DBA Data[Home] [Help]

APPS.GMDRVLAP_WF_PKG dependencies on FND_USER

Line 18: l_performer_name FND_USER.USER_NAME%TYPE ;

14: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMDRVLAP';
15: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := to_char(p_recipe_validity_rule_id)||'-'||
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 */

Line 19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;

15: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := to_char(p_recipe_validity_rule_id)||'-'||
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);

Line 100: FROM FND_USER

96:
97: -- get values to be stored into the workflow item
98: SELECT USER_NAME , DESCRIPTION
99: INTO l_performer_name ,l_performer_display_name
100: FROM FND_USER
101: WHERE USER_ID = p_Requester;
102:
103: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
104: aname => 'GMDRVLAP_REQUSTER',