APPS.WIP_EAM_WRAPPROVAL_PVT dependencies on FND_GLOBAL

Line 154: owner_role=> FND_GLOBAL.USER_NAME);

150:
151: wf_engine.CreateProcess( itemtype => itemtype,
152: itemkey => itemkey,
153: process => l_workflow_process,
154: owner_role=> FND_GLOBAL.USER_NAME);
155:
156: /* Get Asset description */
157: l_stmt_number := 30 ;
158: begin

Line 425: -- l_from_role := FND_GLOBAL.USER_NAME ;

421: aname=> 'WORK_REQUEST_TYPE',
422: avalue=> l_work_request_type);
423:
424: -- From_Role is displayed on Notifn Summary screen
425: -- l_from_role := FND_GLOBAL.USER_NAME ;
426:
427: BEGIN
428: SELECT user_name
429: INTO l_user_name

Line 434: l_user_name := FND_GLOBAL.USER_NAME ;

430: FROM fnd_user
431: WHERE user_id in (select created_by FROM wip_eam_work_requests where work_request_id = p_work_request_id);
432: EXCEPTION
433: When NO_DATA_FOUND then
434: l_user_name := FND_GLOBAL.USER_NAME ;
435: END;
436:
437: wf_engine.SetItemAttrText(itemtype=>itemtype,
438: itemkey =>itemkey,

Line 447: avalue=> FND_GLOBAL.USER_NAME );

443: if ((p_notify_originator is not null) and (p_notify_originator = 1)) then
444: wf_engine.SetItemAttrText(itemtype=>itemtype,
445: itemkey =>itemkey,
446: aname=> 'WORK_REQUEST_ORIGINATOR',
447: avalue=> FND_GLOBAL.USER_NAME );
448: else
449: wf_engine.SetItemAttrText(itemtype=>itemtype,
450: itemkey =>itemkey,
451: aname=> 'WORK_REQUEST_ORIGINATOR',

Line 582: last_updated_by = FND_GLOBAL.USER_ID,

578: If (funcmode = 'RUN') then
579:
580: Update WIP_EAM_WORK_REQUESTS
581: set work_request_status_id = 3 ,
582: last_updated_by = FND_GLOBAL.USER_ID,
583: last_update_date = SYSDATE
584: Where work_request_id = l_work_request_id ;
585:
586: -- Set the from role to be displayed on notifn summary

Line 627: FND_GLOBAL.USER_ID,

623: NOTIFICATION_ID )
624: Values
625: ( l_work_request_note_id,
626: SYSDATE ,
627: FND_GLOBAL.USER_ID,
628: SYSDATE,
629: FND_GLOBAL.USER_ID,
630: null,
631: l_work_request_id,

Line 629: FND_GLOBAL.USER_ID,

625: ( l_work_request_note_id,
626: SYSDATE ,
627: FND_GLOBAL.USER_ID,
628: SYSDATE,
629: FND_GLOBAL.USER_ID,
630: null,
631: l_work_request_id,
632: l_comment ,
633: 2,

Line 706: last_updated_by = FND_GLOBAL.USER_ID,

702: If (funcmode = 'RUN') then
703:
704: Update WIP_EAM_WORK_REQUESTS
705: set work_request_status_id = 5,
706: last_updated_by = FND_GLOBAL.USER_ID,
707: last_update_date = SYSDATE
708: Where work_request_id = l_work_request_id ;
709:
710: -- Set the from role to be displayed on notifn summary

Line 750: FND_GLOBAL.USER_ID,

746: NOTIFICATION_ID )
747: Values
748: ( l_work_request_note_id,
749: SYSDATE ,
750: FND_GLOBAL.USER_ID,
751: SYSDATE,
752: FND_GLOBAL.USER_ID,
753: null,
754: l_work_request_id,

Line 752: FND_GLOBAL.USER_ID,

748: ( l_work_request_note_id,
749: SYSDATE ,
750: FND_GLOBAL.USER_ID,
751: SYSDATE,
752: FND_GLOBAL.USER_ID,
753: null,
754: l_work_request_id,
755: l_comment ,
756: 2,

Line 839: avalue=> FND_GLOBAL.USER_NAME);

835: not the from field of the person who has changed status to Add. Info
836: wf_engine.SetItemAttrText(itemtype=>itemtype,
837: itemkey =>itemkey,
838: aname=> '#FROM_ROLE',
839: avalue=> FND_GLOBAL.USER_NAME);
840: */
841:
842: -- 7 Aug '01 , as per discussion with Adey
843:

Line 858: last_updated_by = FND_GLOBAL.USER_ID,

854:
855: l_stmt_number := 20;
856: Update WIP_EAM_WORK_REQUESTS
857: set work_request_status_id = 2,
858: last_updated_by = FND_GLOBAL.USER_ID,
859: last_update_date = SYSDATE
860: Where work_request_id = l_work_request_id ;
861:
862: -- If l_comment is not null Then

Line 917: FND_GLOBAL.USER_ID ,

913: NOTIFICATION_ID )
914: Values
915: ( l_work_request_note_id,
916: SYSDATE ,
917: FND_GLOBAL.USER_ID ,
918: SYSDATE,
919: FND_GLOBAL.USER_ID,
920: null,
921: l_work_request_id,

Line 919: FND_GLOBAL.USER_ID,

915: ( l_work_request_note_id,
916: SYSDATE ,
917: FND_GLOBAL.USER_ID ,
918: SYSDATE,
919: FND_GLOBAL.USER_ID,
920: null,
921: l_work_request_id,
922: l_comment ,
923: 2,