START_WORKFLOW Function

This function starts a new Workflow given the Workflow definition ID.

Syntax

APEX_WORKFLOW.START_WORKFLOW (
    p_application_id         IN NUMBER
                                  DEFAULT apex_application.g_flow_id,
    p_static_id              IN VARCHAR2,
    p_parameters             IN t_workflow_parameters
                                  DEFAULT c_empty_workflow_parameters,
    p_initiator              IN VARCHAR2                     DEFAULT NULL,
    p_detail_pk              IN VARCHAR2                     DEFAULT NULL,
    p_debug_level            IN apex_debug_api.t_log_level   DEFAULT NULL )
RETURN NUMBER;

Parameters

Parameter	Description
`p_application_id`	The application ID that creates the Workflow.
`p_static_id`	Static ID of the Workflow definition.
`p_parameters`	Optional workflow parameters.
`p_initiator`	(Optional) Initiator information for the workflow.
`p_detail_pk`	(Optional) Detail Primary Key.
`p_debug_level`	(Optional) Debug log level for the Workflow instance being started.

Returns

The ID of the newly started workflow.

Example

The following example starts a Workflow for a given requisition.

BEGIN
    l_workflow_id := apex_workflow.start_workflow (
        p_application_id => 110,
        p_static_id      => 'REQUISITIONWORKFLOW',
        p_parameters     => apex_workflow.t_workflow_parameters(
            1 => apex_workflow.t_workflow_parameter(static_id => 'REQ_DATE', string_value   => sysdate),
            3 => apex_workflow.t_workflow_parameter(static_id => 'REQ_AMOUNT', string_value => l_req_amount),
            4 => apex_workflow.t_workflow_parameter(static_id => 'REQ_ITEM', string_value   => l_req_item),
            5 => apex_workflow.t_workflow_parameter(static_id => 'REQ_ID', string_value     => l_req_id)),
        p_debug_level => apex_debug_api.c_log_level_info );
END;