DBA Data[Home] [Help]

APPS.WIP_EAM_WRAPPROVAL_PVT dependencies on FND_GLOBAL

Line 141: owner_role=> FND_GLOBAL.USER_NAME);

137:
138: wf_engine.CreateProcess( itemtype => itemtype,
139: itemkey => itemkey,
140: process => l_workflow_process,
141: owner_role=> FND_GLOBAL.USER_NAME);
142:
143: /* Get Asset description */
144: l_stmt_number := 30 ;
145: begin

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

383: aname=> 'WORK_REQUEST_TYPE',
384: avalue=> l_work_request_type);
385:
386: -- From_Role is displayed on Notifn Summary screen
387: -- l_from_role := FND_GLOBAL.USER_NAME ;
388: wf_engine.SetItemAttrText(itemtype=>itemtype,
389: itemkey =>itemkey,
390: aname=> '#FROM_ROLE',
391: avalue=> FND_GLOBAL.USER_NAME );

Line 391: avalue=> FND_GLOBAL.USER_NAME );

387: -- l_from_role := FND_GLOBAL.USER_NAME ;
388: wf_engine.SetItemAttrText(itemtype=>itemtype,
389: itemkey =>itemkey,
390: aname=> '#FROM_ROLE',
391: avalue=> FND_GLOBAL.USER_NAME );
392:
393: -- sraval: set originator attribute if notify_originator is 'Yes'
394: if ((p_notify_originator is not null) and (p_notify_originator = 1)) then
395: wf_engine.SetItemAttrText(itemtype=>itemtype,

Line 398: avalue=> FND_GLOBAL.USER_NAME );

394: if ((p_notify_originator is not null) and (p_notify_originator = 1)) then
395: wf_engine.SetItemAttrText(itemtype=>itemtype,
396: itemkey =>itemkey,
397: aname=> 'WORK_REQUEST_ORIGINATOR',
398: avalue=> FND_GLOBAL.USER_NAME );
399: else
400: wf_engine.SetItemAttrText(itemtype=>itemtype,
401: itemkey =>itemkey,
402: aname=> 'WORK_REQUEST_ORIGINATOR',

Line 471: last_updated_by = FND_GLOBAL.USER_ID,

467: If (funcmode = 'RUN') then
468:
469: Update WIP_EAM_WORK_REQUESTS
470: set work_request_status_id = 3 ,
471: last_updated_by = FND_GLOBAL.USER_ID,
472: last_update_date = SYSDATE
473: Where work_request_id = l_work_request_id ;
474:
475: -- Set the from role to be displayed on notifn summary

Line 477: l_user_name := fnd_global.user_name;

473: Where work_request_id = l_work_request_id ;
474:
475: -- Set the from role to be displayed on notifn summary
476:
477: l_user_name := fnd_global.user_name;
478:
479: wf_engine.SetItemAttrText(itemtype=>itemtype,
480: itemkey =>itemkey,
481: aname=> '#FROM_ROLE',

Line 529: FND_GLOBAL.USER_ID,

525: NOTIFICATION_ID )
526: Values
527: ( l_work_request_note_id,
528: SYSDATE ,
529: FND_GLOBAL.USER_ID,
530: SYSDATE,
531: FND_GLOBAL.USER_ID,
532: null,
533: l_work_request_id,

Line 531: FND_GLOBAL.USER_ID,

527: ( l_work_request_note_id,
528: SYSDATE ,
529: FND_GLOBAL.USER_ID,
530: SYSDATE,
531: FND_GLOBAL.USER_ID,
532: null,
533: l_work_request_id,
534: l_comment ,
535: 2,

Line 605: last_updated_by = FND_GLOBAL.USER_ID,

601: If (funcmode = 'RUN') then
602:
603: Update WIP_EAM_WORK_REQUESTS
604: set work_request_status_id = 5,
605: last_updated_by = FND_GLOBAL.USER_ID,
606: last_update_date = SYSDATE
607: Where work_request_id = l_work_request_id ;
608:
609: -- Set the from role to be displayed on notifn summary

Line 611: l_user_name := fnd_global.user_name;

607: Where work_request_id = l_work_request_id ;
608:
609: -- Set the from role to be displayed on notifn summary
610:
611: l_user_name := fnd_global.user_name;
612: wf_engine.SetItemAttrText(itemtype=>itemtype,
613: itemkey =>itemkey,
614: aname=> '#FROM_ROLE',
615: avalue=> l_user_name ) ;

Line 661: FND_GLOBAL.USER_ID,

657: NOTIFICATION_ID )
658: Values
659: ( l_work_request_note_id,
660: SYSDATE ,
661: FND_GLOBAL.USER_ID,
662: SYSDATE,
663: FND_GLOBAL.USER_ID,
664: null,
665: l_work_request_id,

Line 663: FND_GLOBAL.USER_ID,

659: ( l_work_request_note_id,
660: SYSDATE ,
661: FND_GLOBAL.USER_ID,
662: SYSDATE,
663: FND_GLOBAL.USER_ID,
664: null,
665: l_work_request_id,
666: l_comment ,
667: 2,

Line 748: avalue=> FND_GLOBAL.USER_NAME);

744: not the from field of the person who has changed status to Add. Info
745: wf_engine.SetItemAttrText(itemtype=>itemtype,
746: itemkey =>itemkey,
747: aname=> '#FROM_ROLE',
748: avalue=> FND_GLOBAL.USER_NAME);
749: */
750:
751: -- 7 Aug '01 , as per discussion with Adey
752:

Line 757: l_user_name := FND_GLOBAL.USER_NAME;

753: If l_reassign_role_name is null then
754: l_reassign_role_name := l_role_name ;
755: End if ;
756:
757: l_user_name := FND_GLOBAL.USER_NAME;
758: set_employee_name(
759: itemtype=>itemtype,
760: itemkey =>itemkey,
761: actid => actid,

Line 794: last_updated_by = FND_GLOBAL.USER_ID,

790:
791: l_stmt_number := 20;
792: Update WIP_EAM_WORK_REQUESTS
793: set work_request_status_id = 2,
794: last_updated_by = FND_GLOBAL.USER_ID,
795: last_update_date = SYSDATE
796: Where work_request_id = l_work_request_id ;
797:
798: -- If l_comment is not null Then

Line 846: FND_GLOBAL.USER_ID ,

842: NOTIFICATION_ID )
843: Values
844: ( l_work_request_note_id,
845: SYSDATE ,
846: FND_GLOBAL.USER_ID ,
847: SYSDATE,
848: FND_GLOBAL.USER_ID,
849: null,
850: l_work_request_id,

Line 848: FND_GLOBAL.USER_ID,

844: ( l_work_request_note_id,
845: SYSDATE ,
846: FND_GLOBAL.USER_ID ,
847: SYSDATE,
848: FND_GLOBAL.USER_ID,
849: null,
850: l_work_request_id,
851: l_comment ,
852: 2,