APPS.GMDRVLAP_WF_PKG dependencies on GMD_RECIPES

Line 20: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;

16: to_char(p_last_update_date,'dd-MON-yyyy HH24:mi:ss');
17: l_runform VARCHAR2(100);
18: l_performer_name FND_USER.USER_NAME%TYPE ;
19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
20: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;
21: l_recipe_vers GMD_RECIPES.RECIPE_VERSION%TYPE;
22: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
23: l_recipe_use VARCHAR2(80);
24: --Krishna NPD-Conv, Created l_orgn_id, l_item_id. Modified l_orgn_code, l_item_no.

Line 21: l_recipe_vers GMD_RECIPES.RECIPE_VERSION%TYPE;

17: l_runform VARCHAR2(100);
18: l_performer_name FND_USER.USER_NAME%TYPE ;
19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
20: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;
21: l_recipe_vers GMD_RECIPES.RECIPE_VERSION%TYPE;
22: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
23: l_recipe_use VARCHAR2(80);
24: --Krishna NPD-Conv, Created l_orgn_id, l_item_id. Modified l_orgn_code, l_item_no.
25: l_orgn_id GMD_RECIPE_VALIDITY_RULES.organization_id%TYPE;

Line 71: FROM GMD_RECIPES_B

67: aname => 'GMDRVLAP_TARGET_STATUS',
68: avalue => p_target_status);
69:
70: SELECT RECIPE_NO,RECIPE_VERSION INTO l_recipe_no,l_recipe_vers
71: FROM GMD_RECIPES_B
72: WHERE RECIPE_ID = P_RECIPE_ID;
73: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
74: aname => 'GMDRVLAP_RECIPE_NO',
75: avalue => l_recipe_no);