APPS.GMDFMGAP_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 := 'GMDFMGAP';
16: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := to_char(p_formula_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: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
21: l_formula_desc FM_FORM_MST.FORMULA_DESC1%TYPE;
22: l_owner_id FM_FORM_MST.OWNER_ID%TYPE;

Line 19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;

15: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'GMDFMGAP';
16: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := to_char(p_formula_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: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
21: l_formula_desc FM_FORM_MST.FORMULA_DESC1%TYPE;
22: l_owner_id FM_FORM_MST.OWNER_ID%TYPE;
23: l_formula_class FM_FORM_MST.FORMULA_CLASS%TYPE;

Line 84: FROM FND_USER

80:
81: -- get values to be stored into the workflow item
82: SELECT USER_NAME , DESCRIPTION
83: INTO l_performer_name ,l_performer_display_name
84: FROM FND_USER
85: WHERE USER_ID = p_Requester;
86:
87: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
88: aname => 'GMDFMGAP_REQUSTER',

Line 99: FROM FND_USER

95: WHERE FORMULA_ID = P_FORMULA_ID;
96:
97: SELECT USER_NAME , DESCRIPTION
98: INTO l_performer_name ,l_performer_display_name
99: FROM FND_USER
100: WHERE USER_ID = l_owner_id;
101:
102: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,itemkey => l_itemkey,
103: aname => 'GMDFMGAP_OWNER_ID',