APPS.GMDFMLAP_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 := 'GMDFMLAP';
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 := 'GMDFMLAP';
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 85: FROM FND_USER

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

Line 100: FROM FND_USER

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