6.13 GET_TASK_HISTORY Function

This function gets the approval log for a task.

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_HISTORY (
    p_task_id        IN NUMBER,
    p_include_all    IN VARCHAR2 DEFAULT 'N' )
RETURN wwv_flow_t_approval_log_table pipelined;

Parameters

Table 6-11 GET_TASK_HISTORY Parameters

Parameter	Description
p_task_id	The task ID.
p_include_all	If set to Y, the history of all tasks linked to the task with the given task ID is shown. In 22.2, this includes prior Tasks that have been expired.

Returns

A table of approval log entries (type apex_t_approval_log).

Example

select *  from table ( apex_approval.get_task_history ( p_task_id => 1234,
                                                 p_include_all => 'Y' ) )