1: PACKAGE gmdrvgap_wf_pkg AUTHID CURRENT_USER AS
2: /* $Header: GMDRVGAS.pls 115.3 2002/10/29 19:17:14 txdaniel noship $ */
3: /* procedure to initialize and run Workflow */
4: PROCEDURE wf_init (
5: p_recipe_validity_rule_id IN GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE,
6: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,
7: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
8: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
9: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,
2: /* $Header: GMDRVGAS.pls 115.3 2002/10/29 19:17:14 txdaniel noship $ */
3: /* procedure to initialize and run Workflow */
4: PROCEDURE wf_init (
5: p_recipe_validity_rule_id IN GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE,
6: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,
7: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
8: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
9: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATE_DATE%TYPE
3: /* procedure to initialize and run Workflow */
4: PROCEDURE wf_init (
5: p_recipe_validity_rule_id IN GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE,
6: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,
7: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
8: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
9: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATE_DATE%TYPE
11: );
4: PROCEDURE wf_init (
5: p_recipe_validity_rule_id IN GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE,
6: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,
7: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
8: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
9: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATE_DATE%TYPE
11: );
12:
5: p_recipe_validity_rule_id IN GMD_RECIPE_VALIDITY_RULES.recipe_validity_rule_id%TYPE,
6: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,
7: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
8: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
9: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATE_DATE%TYPE
11: );
12:
13: /* Is approval required for next Activity */
6: p_recipe_id IN GMD_RECIPE_VALIDITY_RULES.recipe_id%TYPE,
7: p_start_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
8: p_target_status IN GMD_RECIPE_VALIDITY_RULES.validity_rule_status%TYPE,
9: p_requester IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATED_BY%TYPE,
10: p_last_update_date IN GMD_RECIPE_VALIDITY_RULES.LAST_UPDATE_DATE%TYPE
11: );
12:
13: /* Is approval required for next Activity */
14: