63.19 SET_ACTIVITY_DUE_DATE Procedure

Sets the due date of an activity instance. To change the due date of an activity instance, the workflow instance must be in a faulted or suspended state.

Syntax

APEX_WORKFLOW.SET_ACTIVITY_DUE_DATE (
    p_instance_id            IN              NUMBER,
    p_activity_static_id     IN              VARCHAR2,
    p_due_date               IN              TIMESTAMP WITH TIME ZONE);

Parameters

Parameter	Description
p_instance_id	ID of the workflow instance.
p_activity_static_id	Static ID of the activity instance.
p_due_date	The due date value.

Example

The following example changes the due date for the activity "WAIT_ACTIVITY_1" within the workflow instance with ID 1234. The new due date is set to one day after the current date.

apex_workflow.set_activity_due_date(
       p_instance_id            => 1234,
       p_activity_static_id     => 'WAIT_ACTIVITY_1',
       p_due_date               => sysdate + 1);