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 wwv_flow.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 wwv_flow_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.

DECLARE
   l_req_id      number        := 10;
   l_req_item    varchar2(100) := 'Some requisition item requiring approval';
   l_req_amount  number        := 2499.42;
   l_workflow_id number;
BEGIN
    l_workflow_id := apex_workflow.start_workflow (
        p_application_id => 110,
        p_static_id      => 'REQUISTIONWORKFLOW',
        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 => wwv_flow_debug_api.c_log_level_info );
END;