6.12 GET_TASK_DELEGATES Function

This function gets the potential new owners of a task. The actual owner is excluded from the list.

This function only returns data in the context of a valid Oracle APEX session. It returns no data in SQL Workshop.

Syntax

APEX_APPROVAL.GET_TASK_DELEGATES (
    p_task_id IN NUMBER )
RETURN wwv_flow_t_temp_lov_data pipelined;

Parameters

Table 6-10 GET_TASK_DELEGATES Parameters

Parameter	Description
p_task_id	The task ID.

Returns

A table of apex_t_temp_lov_data.

Example

select disp,val from table ( apex_approval.get_task_delegates ( p_task_id => 1234 ) )