6.23 RENEW_TASK Function

This function reactivates Expired Tasks. Tasks that have been transitioned to state EXPIRED can be renewed by a Business Administrator.

When a Business Administrator renews a Task, a new Task is created with given the information from the given Task ID. The renewed task is associated with the Expired Task so that users can review the origin of the Task. This function returns the ID of the renewed task.

Syntax

APEX_APPROVAL.RENEW_TASK (
    p_task_id       IN NUMBER,
    p_priority      IN INTEGER  DEFAULT NULL,
    p_due_date      IN timestamp with time zone )
RETURN NUMBER;

Parameters

Table 6-21 RENEW_TASK Parameters

Parameter	Description
p_task_id	The Task ID.
p_priority	The priority of the renewed Task.
p_due_date	The due date for the renewed Task.

Returns

This function returns the ID of the renewed task.

Example

BEGIN
    apex_approval.renew_task(
        p_task_id            => 1234,
        p_priority           => apex_approval.c_task_priority_high,
        p_due_date           => sysdate + 10
    );
END;