6.15 GET_TASK_PRIORITIES Function

This function gets the potential new priorities of a task. The actual priority 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_PRIORITIES (
    p_task_id IN NUMBER )
RETURN wwv_flow_t_temp_lov_data pipelined;

Parameters

Table 6-13 GET_TASK_PRIORITIES 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_priorities ( p_task_id => 1234 ) )