61.16 RESUME Procedure

This procedure resumes a Workflow. Only suspended Workflow Instances can be resumed.

If the application is running in a runtime-only session, only Workflow Administrators can perform this operation.

Syntax

APEX_WORKFLOW.RESUME (
    p_instance_id            IN NUMBER,
    p_activity_static_id     IN VARCHAR2 DEFAULT NULL );

Parameters

Parameter Description
p_instance_id ID of the Workflow.
p_activity_static_id Static ID of the Activity to resume the Workflow or NULL if to resume at current activity.

Example

Below example resumes a Workflow Instance at activity "UPDATE_JOB_LEVEL." Only suspended Workflow Instances can be resumed.

BEGIN
    apex_workflow.suspend(
           p_instance_id        => 1234,
           p_activity_static_id => 'UPDATE_JOB_LEVEL');
END;