1: PACKAGE gmdfmlap_wf_pkg AUTHID CURRENT_USER AS
2: /* $Header: GMDFMLAS.pls 115.3 2002/10/29 19:38:44 txdaniel noship $ */
3: /* procedure to initialize and run Workflow */
4: PROCEDURE wf_init (
5: p_Formula_id IN FM_FORM_MST_B.Formula_id%TYPE,
6: p_Formula_no IN FM_FORM_MST_B.Formula_no%TYPE,
7: p_Formula_vers IN FM_FORM_MST_B.Formula_vers%TYPE,
8: p_start_status IN FM_FORM_MST_B.Formula_status%TYPE,
9: p_target_status IN FM_FORM_MST_B.Formula_status%TYPE,
2: /* $Header: GMDFMLAS.pls 115.3 2002/10/29 19:38:44 txdaniel noship $ */
3: /* procedure to initialize and run Workflow */
4: PROCEDURE wf_init (
5: p_Formula_id IN FM_FORM_MST_B.Formula_id%TYPE,
6: p_Formula_no IN FM_FORM_MST_B.Formula_no%TYPE,
7: p_Formula_vers IN FM_FORM_MST_B.Formula_vers%TYPE,
8: p_start_status IN FM_FORM_MST_B.Formula_status%TYPE,
9: p_target_status IN FM_FORM_MST_B.Formula_status%TYPE,
10: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,
3: /* procedure to initialize and run Workflow */
4: PROCEDURE wf_init (
5: p_Formula_id IN FM_FORM_MST_B.Formula_id%TYPE,
6: p_Formula_no IN FM_FORM_MST_B.Formula_no%TYPE,
7: p_Formula_vers IN FM_FORM_MST_B.Formula_vers%TYPE,
8: p_start_status IN FM_FORM_MST_B.Formula_status%TYPE,
9: p_target_status IN FM_FORM_MST_B.Formula_status%TYPE,
10: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN FM_FORM_MST_B.LAST_UPDATE_DATE%TYPE
4: PROCEDURE wf_init (
5: p_Formula_id IN FM_FORM_MST_B.Formula_id%TYPE,
6: p_Formula_no IN FM_FORM_MST_B.Formula_no%TYPE,
7: p_Formula_vers IN FM_FORM_MST_B.Formula_vers%TYPE,
8: p_start_status IN FM_FORM_MST_B.Formula_status%TYPE,
9: p_target_status IN FM_FORM_MST_B.Formula_status%TYPE,
10: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN FM_FORM_MST_B.LAST_UPDATE_DATE%TYPE
12: );
5: p_Formula_id IN FM_FORM_MST_B.Formula_id%TYPE,
6: p_Formula_no IN FM_FORM_MST_B.Formula_no%TYPE,
7: p_Formula_vers IN FM_FORM_MST_B.Formula_vers%TYPE,
8: p_start_status IN FM_FORM_MST_B.Formula_status%TYPE,
9: p_target_status IN FM_FORM_MST_B.Formula_status%TYPE,
10: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN FM_FORM_MST_B.LAST_UPDATE_DATE%TYPE
12: );
13:
6: p_Formula_no IN FM_FORM_MST_B.Formula_no%TYPE,
7: p_Formula_vers IN FM_FORM_MST_B.Formula_vers%TYPE,
8: p_start_status IN FM_FORM_MST_B.Formula_status%TYPE,
9: p_target_status IN FM_FORM_MST_B.Formula_status%TYPE,
10: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN FM_FORM_MST_B.LAST_UPDATE_DATE%TYPE
12: );
13:
14: /* Is approval required for next Activity */
7: p_Formula_vers IN FM_FORM_MST_B.Formula_vers%TYPE,
8: p_start_status IN FM_FORM_MST_B.Formula_status%TYPE,
9: p_target_status IN FM_FORM_MST_B.Formula_status%TYPE,
10: p_requester IN FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN FM_FORM_MST_B.LAST_UPDATE_DATE%TYPE
12: );
13:
14: /* Is approval required for next Activity */
15: