1: PACKAGE gmdrpgap_wf_pkg AUTHID CURRENT_USER AS
2: /* $Header: GMDRPGAS.pls 115.3 2002/10/29 18:12:16 txdaniel noship $ */
3: /* procedure to initialize and run Workflow */
4: PROCEDURE wf_init (
5: p_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE,
6: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,
7: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
8: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
2: /* $Header: GMDRPGAS.pls 115.3 2002/10/29 18:12:16 txdaniel noship $ */
3: /* procedure to initialize and run Workflow */
4: PROCEDURE wf_init (
5: p_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE,
6: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,
7: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
8: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
10: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,
3: /* procedure to initialize and run Workflow */
4: PROCEDURE wf_init (
5: p_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE,
6: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,
7: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
8: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
10: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN GMD_RECIPES_B.LAST_UPDATE_DATE%TYPE
4: PROCEDURE wf_init (
5: p_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE,
6: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,
7: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
8: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
10: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN GMD_RECIPES_B.LAST_UPDATE_DATE%TYPE
12: );
5: p_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE,
6: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,
7: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
8: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
10: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN GMD_RECIPES_B.LAST_UPDATE_DATE%TYPE
12: );
13:
6: p_recipe_no IN GMD_RECIPES_B.recipe_no%TYPE,
7: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
8: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
10: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN GMD_RECIPES_B.LAST_UPDATE_DATE%TYPE
12: );
13:
14: /* Is approval required for next Activity */
7: p_recipe_vers IN GMD_RECIPES_B.recipe_version%TYPE,
8: p_start_status IN GMD_RECIPES_B.recipe_status%TYPE,
9: p_target_status IN GMD_RECIPES_B.recipe_status%TYPE,
10: p_requester IN GMD_RECIPES_B.LAST_UPDATED_BY%TYPE,
11: p_last_update_date IN GMD_RECIPES_B.LAST_UPDATE_DATE%TYPE
12: );
13:
14: /* Is approval required for next Activity */
15: