6.25 SET_TASK_DUE Procedure

This procedure sets the due date of a task and can be invoked by the Business Administrator to update the due date of the task.

This API cannot be invoked for a task that is Expired, Errored, Completed or Canceled.

The due date needs to be in the future, otherwise an exception is thrown when invoking this API.

Syntax

APEX_APPROVAL.SET_TASK_DUE (
    p_task_id                IN NUMBER,
    p_due_date               IN timestamp with time zone )

Parameters

Table 6-23 SET_TASK_DUE Parameters

Parameter	Description
p_task_id	The Task ID.
p_due_date	The new due date of the Task.

Example

BEGIN
    apex_approval.set_task_due(
        p_task_id  => 1234,
        p_due_date => sysdate+20
    );
END;