APPS.GMDRPLAP_WF_PKG dependencies on FND_USER

Line 18: l_performer_name FND_USER.USER_NAME%TYPE ;

14:
15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMDRPLAP';
16: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := to_char(p_recipe_id)||'-'||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:
21: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
22:

Line 19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;

15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMDRPLAP';
16: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := to_char(p_recipe_id)||'-'||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:
21: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
22:
23: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */

Line 90: FROM FND_USER

86:
87: -- get values to be stored into the workflow item
88: SELECT USER_NAME , DESCRIPTION
89: INTO l_performer_name ,l_performer_display_name
90: FROM FND_USER
91: WHERE USER_ID = p_Requester;
92:
93: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
94: aname => 'GMDRPLAP_REQUSTER',

Line 112: FROM FND_USER

108: END IF;
109:
110: SELECT USER_NAME , DESCRIPTION
111: INTO l_performer_name ,l_performer_display_name
112: FROM FND_USER
113: WHERE USER_ID = l_owner_id;
114:
115: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
116: aname => 'GMDRPLAP_OWNER_ID',