APPS.GMI_WF_LOT_RETEST dependencies on FND_USER

Line 42: l_performer_name FND_USER.USER_NAME%TYPE ;

38: l_item_um ic_item_mst.item_um%TYPE ;
39: l_item_um2 ic_item_mst.item_um2%TYPE ;
40: c_whse_item_id ic_item_mst.whse_item_id%TYPE;
41: c_item_id ic_item_mst.item_id%TYPE;
42: l_performer_name FND_USER.USER_NAME%TYPE ;
43: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
44:
45: l_role_name sy_wf_item_roles.retest_role_name%TYPE ;
46: l_role_display_name sy_wf_item_roles.retest_role_display_name%TYPE ;

Line 43: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;

39: l_item_um2 ic_item_mst.item_um2%TYPE ;
40: c_whse_item_id ic_item_mst.whse_item_id%TYPE;
41: c_item_id ic_item_mst.item_id%TYPE;
42: l_performer_name FND_USER.USER_NAME%TYPE ;
43: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
44:
45: l_role_name sy_wf_item_roles.retest_role_name%TYPE ;
46: l_role_display_name sy_wf_item_roles.retest_role_display_name%TYPE ;
47:

Line 82: FROM FND_USER

78: FROM dual;
79:
80: SELECT USER_NAME , DESCRIPTION
81: INTO l_performer_name ,l_performer_display_name
82: FROM FND_USER
83: WHERE USER_ID = p_created_by ;
84:
85: SELECT item_no , item_desc1 ,item_um ,item_um2 , dualum_ind
86: INTO l_item_no ,l_item_desc1 ,l_item_um ,l_item_um2 ,l_dualum_ind

Line 178: so default to previously-selected FND_USER values */

174: close c_item_role;
175:
176: IF l_role_name IS NULL THEN
177: /* no notification target found for this item
178: so default to previously-selected FND_USER values */
179: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
180: itemkey => l_itemkey,
181: aname => 'PERNAME',
182: avalue => l_performer_name);