eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_EAM_WRAPPROVAL_PVT dependencies on WF_ENGINE

Line 151: wf_engine.CreateProcess( itemtype => itemtype,

147: select wip_Eam_wrapproval_s.nextval
148: into itemkey
149: from dual;
150:
151: wf_engine.CreateProcess( itemtype => itemtype,
152: itemkey => itemkey,
153: process => l_workflow_process,
154: owner_role=> FND_GLOBAL.USER_NAME);
155:

Line 332: wf_engine.SetItemAttrNumber( itemtype => itemtype,

328:
329:
330: /* Set Attributes */
331: l_stmt_number := 80 ;
332: wf_engine.SetItemAttrNumber( itemtype => itemtype,
333: itemkey => itemkey,
334: aname => 'WORK_REQUEST_ID',
335: avalue => p_work_request_id );
336:

Line 337: wf_engine.SetItemAttrText( itemtype => itemtype,

333: itemkey => itemkey,
334: aname => 'WORK_REQUEST_ID',
335: avalue => p_work_request_id );
336:
337: wf_engine.SetItemAttrText( itemtype => itemtype,
338: itemkey => itemkey,
339: aname => 'ASSET_NUMBER',
340: avalue => l_instance_number);
341:

Line 342: wf_engine.SetItemAttrText(itemtype => itemtype,

338: itemkey => itemkey,
339: aname => 'ASSET_NUMBER',
340: avalue => l_instance_number);
341:
342: wf_engine.SetItemAttrText(itemtype => itemtype,
343: itemkey => itemkey,
344: aname => 'ASSET_DESCRIPTION',
345: avalue => l_asset_description);
346:

Line 347: wf_engine.SetItemAttrNumber(itemtype => itemtype,

343: itemkey => itemkey,
344: aname => 'ASSET_DESCRIPTION',
345: avalue => l_asset_description);
346:
347: wf_engine.SetItemAttrNumber(itemtype => itemtype,
348: itemkey => itemkey,
349: aname => 'ASSET_GROUP',
350: avalue => p_asset_group);
351:

Line 352: wf_engine.SetItemAttrText(itemtype => itemtype,

348: itemkey => itemkey,
349: aname => 'ASSET_GROUP',
350: avalue => p_asset_group);
351:
352: wf_engine.SetItemAttrText(itemtype => itemtype,
353: itemkey => itemkey,
354: aname => 'ASSET_GROUP_SEGMENTS',
355: avalue => l_asset_group_segments);
356:

Line 357: wf_engine.SetItemAttrText(itemtype =>itemtype,

353: itemkey => itemkey,
354: aname => 'ASSET_GROUP_SEGMENTS',
355: avalue => l_asset_group_segments);
356:
357: wf_engine.SetItemAttrText(itemtype =>itemtype,
358: itemkey =>itemkey,
359: aname => 'ASSET_GROUP_DESCRIPTION',
360: avalue => l_asset_group_description);
361:

Line 362: wf_engine.SetItemAttrNumber( itemtype => itemtype,

358: itemkey =>itemkey,
359: aname => 'ASSET_GROUP_DESCRIPTION',
360: avalue => l_asset_group_description);
361:
362: wf_engine.SetItemAttrNumber( itemtype => itemtype,
363: itemkey => itemkey,
364: aname => 'WORK_REQUEST_STATUS_ID',
365: avalue => p_work_request_status_id);
366:

Line 367: wf_engine.SetItemAttrNumber( itemtype => itemtype,

363: itemkey => itemkey,
364: aname => 'WORK_REQUEST_STATUS_ID',
365: avalue => p_work_request_status_id);
366:
367: wf_engine.SetItemAttrNumber( itemtype => itemtype,
368: itemkey => itemkey,
369: aname => 'WORK_REQUEST_PRIORITY_ID',
370: avalue => p_work_request_priority_id);
371:

Line 372: wf_engine.SetItemAttrText(itemtype =>itemtype,

368: itemkey => itemkey,
369: aname => 'WORK_REQUEST_PRIORITY_ID',
370: avalue => p_work_request_priority_id);
371:
372: wf_engine.SetItemAttrText(itemtype =>itemtype,
373: itemkey =>itemkey,
374: aname => 'PRIORITY_DESCRIPTION',
375: avalue => l_priority_description);
376:

Line 377: wf_engine.SetItemAttrNumber( itemtype => itemtype,

373: itemkey =>itemkey,
374: aname => 'PRIORITY_DESCRIPTION',
375: avalue => l_priority_description);
376:
377: wf_engine.SetItemAttrNumber( itemtype => itemtype,
378: itemkey => itemkey,
379: aname => 'WORK_REQUEST_OWNING_DEPT_ID',
380: avalue => p_work_request_owning_dept_id);
381:

Line 382: wf_engine.SetItemAttrText(itemtype=>itemtype,

378: itemkey => itemkey,
379: aname => 'WORK_REQUEST_OWNING_DEPT_ID',
380: avalue => p_work_request_owning_dept_id);
381:
382: wf_engine.SetItemAttrText(itemtype=>itemtype,
383: itemkey =>itemkey,
384: aname=> 'DEPARTMENT_CODE',
385: avalue=> l_department_code);
386:

Line 387: wf_engine.SetItemAttrDate( itemtype => itemtype,

383: itemkey =>itemkey,
384: aname=> 'DEPARTMENT_CODE',
385: avalue=> l_department_code);
386:
387: wf_engine.SetItemAttrDate( itemtype => itemtype,
388: itemkey => itemkey,
389: aname => 'EXPECTED_RESOLUTION_DATE',
390: avalue => p_expected_resolution_date);
391:

Line 392: wf_engine.SetItemAttrText( itemtype => itemtype,

388: itemkey => itemkey,
389: aname => 'EXPECTED_RESOLUTION_DATE',
390: avalue => p_expected_resolution_date);
391:
392: wf_engine.SetItemAttrText( itemtype => itemtype,
393: itemkey => itemkey,
394: aname => 'NOTES',
395: avalue => l_notes);
396:

Line 398: wf_engine.SetItemAttrText(itemtype=>itemtype,

394: aname => 'NOTES',
395: avalue => l_notes);
396:
397: /* Responsibility associated to the Owning Dept in MSN */
398: wf_engine.SetItemAttrText(itemtype=>itemtype,
399: itemkey =>itemkey,
400: aname=> 'DEPT_RESPONSIBILTY',
401: avalue=> l_role_name);
402:

Line 404: wf_engine.SetItemAttrNumber( itemtype => itemtype,

400: aname=> 'DEPT_RESPONSIBILTY',
401: avalue=> l_role_name);
402:
403:
404: wf_engine.SetItemAttrNumber( itemtype => itemtype,
405: itemkey => itemkey,
406: aname => 'ASSET_LOCATION',
407: avalue => l_asset_location);
408:

Line 409: wf_engine.SetItemAttrText(itemtype=>itemtype,

405: itemkey => itemkey,
406: aname => 'ASSET_LOCATION',
407: avalue => l_asset_location);
408:
409: wf_engine.SetItemAttrText(itemtype=>itemtype,
410: itemkey =>itemkey,
411: aname=> 'LOCATION_CODES',
412: avalue=> l_location_codes);
413:

Line 414: wf_engine.SetItemAttrNumber(itemtype=>itemtype,

410: itemkey =>itemkey,
411: aname=> 'LOCATION_CODES',
412: avalue=> l_location_codes);
413:
414: wf_engine.SetItemAttrNumber(itemtype=>itemtype,
415: itemkey =>itemkey,
416: aname=> 'WORK_REQUEST_TYPE_ID',
417: avalue=> p_work_request_type_id);
418:

Line 419: wf_engine.SetItemAttrText(itemtype=>itemtype,

415: itemkey =>itemkey,
416: aname=> 'WORK_REQUEST_TYPE_ID',
417: avalue=> p_work_request_type_id);
418:
419: wf_engine.SetItemAttrText(itemtype=>itemtype,
420: itemkey =>itemkey,
421: aname=> 'WORK_REQUEST_TYPE',
422: avalue=> l_work_request_type);
423:

Line 437: wf_engine.SetItemAttrText(itemtype=>itemtype,

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,
439: aname=> '#FROM_ROLE',
440: avalue=> l_user_name );
441:

Line 444: wf_engine.SetItemAttrText(itemtype=>itemtype,

440: avalue=> l_user_name );
441:
442: -- sraval: set originator attribute if notify_originator is 'Yes'
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

Line 449: 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',
452: avalue=> null);
453:

Line 457: wf_engine.StartProcess( itemtype => itemtype,

453:
454: end if;
455: /* Start Process */
456: l_stmt_number := 100 ;
457: wf_engine.StartProcess( itemtype => itemtype,
458: itemkey => itemkey);
459:
460: /* Set workflow process to background for better performance */
461:

Line 467: --wf_engine.threshold := -1;

463: set wf_item_type = itemtype,
464: wf_item_key = itemkey
465: where work_request_id = p_work_request_id;
466: l_stmt_number := 120 ;
467: --wf_engine.threshold := -1;
468:
469: -- commit ;
470:
471: EXCEPTION

Line 501: l_approver_name:=wf_engine.context_user;

497:
498: BEGIN
499: If (funcmode = 'RESPOND') THEN
500:
501: l_approver_name:=wf_engine.context_user;
502:
503:
504:
505: -- gajs_test_mesg('l_approver_name in respond:'||l_approver_name);

Line 506: wf_engine.SetItemAttrText(itemtype=>itemtype,

502:
503:
504:
505: -- gajs_test_mesg('l_approver_name in respond:'||l_approver_name);
506: wf_engine.SetItemAttrText(itemtype=>itemtype,
507: itemkey =>itemkey,
508: aname=> '#FROM_ROLE',
509: avalue=> l_approver_name);
510:

Line 513: wf_engine.SetItemAttrText(itemtype=>itemtype,

509: avalue=> l_approver_name);
510:
511: --Bug 3494922: Set From Role 2 to the approver's user name
512: BEGIN
513: wf_engine.SetItemAttrText(itemtype=>itemtype,
514: itemkey =>itemkey,
515: aname=> 'FROM_ROLE2',
516: avalue=> l_approver_name);
517: EXCEPTION/*bug#4395553 - added for WF upgraded from pre11i10*/

Line 520: wf_engine.AddItemAttr(itemtype=>itemtype,

516: avalue=> l_approver_name);
517: EXCEPTION/*bug#4395553 - added for WF upgraded from pre11i10*/
518: WHEN OTHERS THEN
519: IF (wf_core.error_name = 'WFENG_ITEM_ATTR') THEN
520: wf_engine.AddItemAttr(itemtype=>itemtype,
521: itemkey =>itemkey,
522: aname=>'FROM_ROLE2');
523: wf_engine.SetItemAttrText( itemtype => itemtype,
524: itemkey => itemkey,

Line 523: wf_engine.SetItemAttrText( itemtype => itemtype,

519: IF (wf_core.error_name = 'WFENG_ITEM_ATTR') THEN
520: wf_engine.AddItemAttr(itemtype=>itemtype,
521: itemkey =>itemkey,
522: aname=>'FROM_ROLE2');
523: wf_engine.SetItemAttrText( itemtype => itemtype,
524: itemkey => itemkey,
525: aname => 'FROM_ROLE2',
526: avalue => l_approver_name );
527: ELSE

Line 553: wf_engine.GetItemAttrNumber( itemtype => itemtype,

549: funcmode in varchar2,
550: resultout out NOCOPY varchar2) is
551:
552: l_work_request_id number :=
553: wf_engine.GetItemAttrNumber( itemtype => itemtype,
554: itemkey => itemkey,
555: aname => 'WORK_REQUEST_ID');
556:
557: l_comment varchar2(2000) :=

Line 558: wf_engine.GetItemAttrText( itemtype => itemtype,

554: itemkey => itemkey,
555: aname => 'WORK_REQUEST_ID');
556:
557: l_comment varchar2(2000) :=
558: wf_engine.GetItemAttrText( itemtype => itemtype,
559: itemkey => itemkey,
560: aname => 'COMMENT');
561:
562: l_role_name varchar2(80) :=

Line 563: wf_engine.GetItemAttrText( itemtype=>itemtype,

559: itemkey => itemkey,
560: aname => 'COMMENT');
561:
562: l_role_name varchar2(80) :=
563: wf_engine.GetItemAttrText( itemtype=>itemtype,
564: itemkey =>itemkey,
565: aname=> 'DEPT_RESPONSIBILTY');
566:
567: l_approver_name varchar2(100):=wf_engine.GetItemAttrText( itemtype=>itemtype,

Line 567: l_approver_name varchar2(100):=wf_engine.GetItemAttrText( itemtype=>itemtype,

563: wf_engine.GetItemAttrText( itemtype=>itemtype,
564: itemkey =>itemkey,
565: aname=> 'DEPT_RESPONSIBILTY');
566:
567: l_approver_name varchar2(100):=wf_engine.GetItemAttrText( itemtype=>itemtype,
568: itemkey =>itemkey,
569: aname=> '#FROM_ROLE');
570: l_work_request_note_id number;
571: l_last_updated_by number;

Line 677: wf_engine.GetItemAttrNumber( itemtype => itemtype,

673: funcmode in varchar2,
674: resultout out NOCOPY varchar2) is
675:
676: l_work_request_id number :=
677: wf_engine.GetItemAttrNumber( itemtype => itemtype,
678: itemkey => itemkey,
679: aname => 'WORK_REQUEST_ID');
680:
681: l_comment varchar2(2000) :=

Line 682: wf_engine.GetItemAttrText( itemtype => itemtype,

678: itemkey => itemkey,
679: aname => 'WORK_REQUEST_ID');
680:
681: l_comment varchar2(2000) :=
682: wf_engine.GetItemAttrText( itemtype => itemtype,
683: itemkey => itemkey,
684: aname => 'COMMENT');
685:
686: l_role_name varchar2(80) :=

Line 687: wf_engine.GetItemAttrText( itemtype=>itemtype,

683: itemkey => itemkey,
684: aname => 'COMMENT');
685:
686: l_role_name varchar2(80) :=
687: wf_engine.GetItemAttrText( itemtype=>itemtype,
688: itemkey =>itemkey,
689: aname=> 'DEPT_RESPONSIBILTY');
690:
691: l_user_name varchar2(100):=wf_engine.GetItemAttrText( itemtype=>itemtype,

Line 691: l_user_name varchar2(100):=wf_engine.GetItemAttrText( itemtype=>itemtype,

687: wf_engine.GetItemAttrText( itemtype=>itemtype,
688: itemkey =>itemkey,
689: aname=> 'DEPT_RESPONSIBILTY');
690:
691: l_user_name varchar2(100):=wf_engine.GetItemAttrText( itemtype=>itemtype,
692: itemkey =>itemkey,
693: aname=> '#FROM_ROLE');
694:
695: l_work_request_note_id number;

Line 797: wf_engine.GetItemAttrNumber( itemtype => itemtype,

793: funcmode in varchar2,
794: resultout out NOCOPY varchar2) is
795:
796: l_work_request_id number :=
797: wf_engine.GetItemAttrNumber( itemtype => itemtype,
798: itemkey => itemkey,
799: aname => 'WORK_REQUEST_ID');
800:
801: l_comment varchar2(2000) :=

Line 802: wf_engine.GetItemAttrText( itemtype => itemtype,

798: itemkey => itemkey,
799: aname => 'WORK_REQUEST_ID');
800:
801: l_comment varchar2(2000) :=
802: wf_engine.GetItemAttrText( itemtype => itemtype,
803: itemkey => itemkey,
804: aname => 'COMMENT');
805:
806: l_previous_reassign_comment varchar2(2000) :=

Line 807: wf_engine.GetItemAttrText( itemtype => itemtype,

803: itemkey => itemkey,
804: aname => 'COMMENT');
805:
806: l_previous_reassign_comment varchar2(2000) :=
807: wf_engine.GetItemAttrText( itemtype => itemtype,
808: itemkey => itemkey,
809: aname => 'PREVIOUS_REASSIGN_COMMENT');
810: -- From role
811: l_role_name varchar2(80) :=

Line 812: wf_engine.GetItemAttrText( itemtype=>itemtype,

808: itemkey => itemkey,
809: aname => 'PREVIOUS_REASSIGN_COMMENT');
810: -- From role
811: l_role_name varchar2(80) :=
812: wf_engine.GetItemAttrText( itemtype=>itemtype,
813: itemkey =>itemkey,
814: aname=> 'DEPT_RESPONSIBILTY');
815: -- To role
816: l_reassign_role_name varchar2(80) :=

Line 817: wf_engine.GetItemAttrText( itemtype=>itemtype,

813: itemkey =>itemkey,
814: aname=> 'DEPT_RESPONSIBILTY');
815: -- To role
816: l_reassign_role_name varchar2(80) :=
817: wf_engine.GetItemAttrText( itemtype=>itemtype,
818: itemkey =>itemkey,
819: aname=> 'REASSIGN_ROLE');
820:
821: l_user_name varchar2(100):=wf_engine.GetItemAttrText( itemtype=>itemtype,

Line 821: l_user_name varchar2(100):=wf_engine.GetItemAttrText( itemtype=>itemtype,

817: wf_engine.GetItemAttrText( itemtype=>itemtype,
818: itemkey =>itemkey,
819: aname=> 'REASSIGN_ROLE');
820:
821: l_user_name varchar2(100):=wf_engine.GetItemAttrText( itemtype=>itemtype,
822: itemkey =>itemkey,
823: aname=> '#FROM_ROLE');
824:
825: l_work_request_note_id number ;

Line 836: wf_engine.SetItemAttrText(itemtype=>itemtype,

832: l_stmt_number := 10;
833: /* Bug: 3418639 - Commenting line below so that the From field in notification
834: is the same as the from field during creation of notification and
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: */

Line 850: wf_engine.SetItemAttrText(itemtype=>itemtype,

846: End if ;
847:
848:
849: l_stmt_number := 15;
850: wf_engine.SetItemAttrText(itemtype=>itemtype,
851: itemkey =>itemkey,
852: aname=> 'DEPT_RESPONSIBILTY',
853: avalue=> l_reassign_role_name);
854:

Line 878: wf_engine.SetItemAttrText( itemtype => itemtype,

874:
875: l_stmt_number := 50;
876:
877: -- set additional info comment before changing and nullifying comment, bug7480408
878: wf_engine.SetItemAttrText( itemtype => itemtype,
879: itemkey => itemkey,
880: aname => 'ADD_COMMENT',
881: avalue => l_comment);
882:

Line 940: wf_engine.SetItemAttrText( itemtype => itemtype,

936: End ;
937: */
938:
939: l_stmt_number := 70;
940: wf_engine.SetItemAttrText( itemtype => itemtype,
941: itemkey => itemkey,
942: aname => 'PREVIOUS_REASSIGN_COMMENT',
943: avalue => l_previous_reassign_comment);
944:

Line 948: wf_engine.SetItemAttrText( itemtype => itemtype,

944:
945: -- Comment box is cleared so new comments can be entered
946: l_comment := null ;
947: l_stmt_number := 80;
948: wf_engine.SetItemAttrText( itemtype => itemtype,
949: itemkey => itemkey,
950: aname => 'COMMENT',
951: avalue => l_comment);
952: -- End if ; --- comment not null

Line 1002: l_work_request_originator := wf_engine.GetItemAttrText(itemtype => itemtype

998: --
999: if (funcmode = 'RUN') then
1000:
1001: -- retrieve requestor, approver
1002: l_work_request_originator := wf_engine.GetItemAttrText(itemtype => itemtype
1003: ,itemkey => itemkey
1004: ,aname => 'WORK_REQUEST_ORIGINATOR'
1005: ,ignore_notfound=>true);/*Added for bug#4425039*/
1006:

Line 1008: resultout := wf_engine.eng_completed||':'||wf_no;

1004: ,aname => 'WORK_REQUEST_ORIGINATOR'
1005: ,ignore_notfound=>true);/*Added for bug#4425039*/
1006:
1007: if l_work_request_originator is null then
1008: resultout := wf_engine.eng_completed||':'||wf_no;
1009: else
1010: resultout := wf_engine.eng_completed||':'||wf_yes;
1011: end if;
1012: return;

Line 1010: resultout := wf_engine.eng_completed||':'||wf_yes;

1006:
1007: if l_work_request_originator is null then
1008: resultout := wf_engine.eng_completed||':'||wf_no;
1009: else
1010: resultout := wf_engine.eng_completed||':'||wf_yes;
1011: end if;
1012: return;
1013: end if;
1014:

Line 1026: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

1022: --
1023: if (funcmode = 'CANCEL') then
1024:
1025: -- no result needed
1026: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1027: return;
1028: end if;
1029:
1030:

Line 1036: resultout := wf_engine.eng_null;

1032: -- Other execution modes may be created in the future. Your
1033: -- activity will indicate that it does not implement a mode
1034: -- by returning null
1035: --
1036: resultout := wf_engine.eng_null;
1037: return;
1038:
1039: exception
1040: when others then

Line 1070: wf_engine.SetItemAttrText( itemtype => itemtype,

1066: when others then
1067: l_employee_name := p_user_name;
1068: end;
1069:
1070: wf_engine.SetItemAttrText( itemtype => itemtype,
1071: itemkey => itemkey,
1072: aname => 'FROM_ROLE_EMPLOYEE',
1073: avalue => l_employee_name );
1074: end set_employee_name;