1: PACKAGE gmdopgap_wf_pkg AUTHID CURRENT_USER AS
2: /* $Header: GMDOPGAS.pls 115.4 2002/10/29 18:29:09 txdaniel noship $ */
3: /* procedure to initialize and run Workflow */
4: PROCEDURE wf_init (
5: p_operation_id IN GMD_OPERATIONS_B.oprn_id%TYPE,
6: p_operation_no IN GMD_OPERATIONS_B.oprn_no%TYPE,
7: p_operation_vers IN GMD_OPERATIONS_B.oprn_vers%TYPE,
8: p_start_status IN GMD_OPERATIONS_B.operation_status%TYPE,
9: p_target_status IN GMD_OPERATIONS_B.operation_status%TYPE,
2: /* $Header: GMDOPGAS.pls 115.4 2002/10/29 18:29:09 txdaniel noship $ */
3: /* procedure to initialize and run Workflow */
4: PROCEDURE wf_init (
5: p_operation_id IN GMD_OPERATIONS_B.oprn_id%TYPE,
6: p_operation_no IN GMD_OPERATIONS_B.oprn_no%TYPE,
7: p_operation_vers IN GMD_OPERATIONS_B.oprn_vers%TYPE,
8: p_start_status IN GMD_OPERATIONS_B.operation_status%TYPE,
9: p_target_status IN GMD_OPERATIONS_B.operation_status%TYPE,
10: p_requester IN GMD_OPERATIONS_B.LAST_UPDATED_BY%TYPE,
3: /* procedure to initialize and run Workflow */
4: PROCEDURE wf_init (
5: p_operation_id IN GMD_OPERATIONS_B.oprn_id%TYPE,
6: p_operation_no IN GMD_OPERATIONS_B.oprn_no%TYPE,
7: p_operation_vers IN GMD_OPERATIONS_B.oprn_vers%TYPE,
8: p_start_status IN GMD_OPERATIONS_B.operation_status%TYPE,
9: p_target_status IN GMD_OPERATIONS_B.operation_status%TYPE,
10: p_requester IN GMD_OPERATIONS_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN GMD_OPERATIONS_B.LAST_UPDATE_DATE%TYPE
4: PROCEDURE wf_init (
5: p_operation_id IN GMD_OPERATIONS_B.oprn_id%TYPE,
6: p_operation_no IN GMD_OPERATIONS_B.oprn_no%TYPE,
7: p_operation_vers IN GMD_OPERATIONS_B.oprn_vers%TYPE,
8: p_start_status IN GMD_OPERATIONS_B.operation_status%TYPE,
9: p_target_status IN GMD_OPERATIONS_B.operation_status%TYPE,
10: p_requester IN GMD_OPERATIONS_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN GMD_OPERATIONS_B.LAST_UPDATE_DATE%TYPE
12: );
5: p_operation_id IN GMD_OPERATIONS_B.oprn_id%TYPE,
6: p_operation_no IN GMD_OPERATIONS_B.oprn_no%TYPE,
7: p_operation_vers IN GMD_OPERATIONS_B.oprn_vers%TYPE,
8: p_start_status IN GMD_OPERATIONS_B.operation_status%TYPE,
9: p_target_status IN GMD_OPERATIONS_B.operation_status%TYPE,
10: p_requester IN GMD_OPERATIONS_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN GMD_OPERATIONS_B.LAST_UPDATE_DATE%TYPE
12: );
13:
6: p_operation_no IN GMD_OPERATIONS_B.oprn_no%TYPE,
7: p_operation_vers IN GMD_OPERATIONS_B.oprn_vers%TYPE,
8: p_start_status IN GMD_OPERATIONS_B.operation_status%TYPE,
9: p_target_status IN GMD_OPERATIONS_B.operation_status%TYPE,
10: p_requester IN GMD_OPERATIONS_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN GMD_OPERATIONS_B.LAST_UPDATE_DATE%TYPE
12: );
13:
14: /* Is approval required for next Activity */
7: p_operation_vers IN GMD_OPERATIONS_B.oprn_vers%TYPE,
8: p_start_status IN GMD_OPERATIONS_B.operation_status%TYPE,
9: p_target_status IN GMD_OPERATIONS_B.operation_status%TYPE,
10: p_requester IN GMD_OPERATIONS_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN GMD_OPERATIONS_B.LAST_UPDATE_DATE%TYPE
12: );
13:
14: /* Is approval required for next Activity */
15: