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.IA_WF_REQUEST_PKG dependencies on WF_ENGINE

Line 356: -- WF_ENGINE.threshold := -1;

352: /****************************
353: * Launching Workflow Process
354: *****************************/
355:
356: -- WF_ENGINE.threshold := -1;
357:
358:
359: begin
360: -----------------------------------------------------

Line 363: WF_ENGINE.createProcess(ItemType => IA_WF_UTIL_PKG.WF_TransactionType,

359: begin
360: -----------------------------------------------------
361: debugInfo := 'Create a new process';
362: -----------------------------------------------------
363: WF_ENGINE.createProcess(ItemType => IA_WF_UTIL_PKG.WF_TransactionType,
364: ItemKey => l_itemkey,
365: process => IA_WF_UTIL_PKG.WF_MainProcess);
366:
367: exception

Line 384: WF_ENGINE.SetItemOwner(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

380: -----------------------------------------------------
381: debugInfo := 'Set system item attributes';
382: -----------------------------------------------------
383: if (l_system_admin is NOT NULL) then
384: WF_ENGINE.SetItemOwner(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
385: itemkey => l_itemkey,
386: owner => l_system_admin); -- l_preparer_name);
387: end if;
388:

Line 389: WF_ENGINE.SetItemUserKey(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

385: itemkey => l_itemkey,
386: owner => l_system_admin); -- l_preparer_name);
387: end if;
388:
389: WF_ENGINE.SetItemUserKey(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
390: itemkey => l_itemkey,
391: userkey => p_request_id); -- p_request_id);
392:
393: exception

Line 407: WF_ENGINE.SetItemAttrNumber(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

403: -----------------------------------------------------
404: debugInfo := 'Set item attributes';
405: -----------------------------------------------------
406: l_attribute := 'REQUEST_ID';
407: WF_ENGINE.SetItemAttrNumber(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
408: itemkey => l_itemkey,
409: aname => 'REQUEST_ID',
410: avalue => p_request_id);
411:

Line 413: WF_ENGINE.SetItemAttrNumber(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

409: aname => 'REQUEST_ID',
410: avalue => p_request_id);
411:
412: l_attribute := 'PREPARER_ID';
413: WF_ENGINE.SetItemAttrNumber(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
414: itemkey => l_itemkey,
415: aname => 'PREPARER_ID',
416: avalue => l_preparer_id);
417:

Line 419: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

415: aname => 'PREPARER_ID',
416: avalue => l_preparer_id);
417:
418: l_attribute := 'PREPARER_NAME';
419: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
420: itemkey => l_itemkey,
421: aname => 'PREPARER_NAME',
422: avalue => l_preparer_name);
423:

Line 425: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

421: aname => 'PREPARER_NAME',
422: avalue => l_preparer_name);
423:
424: l_attribute := 'PREPARER_NAME_DISP';
425: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
426: itemkey => l_itemkey,
427: aname => 'PREPARER_NAME_DISP',
428: avalue => l_preparer_name_display);
429:

Line 431: WF_ENGINE.SetItemAttrNumber(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

427: aname => 'PREPARER_NAME_DISP',
428: avalue => l_preparer_name_display);
429:
430: l_attribute := 'REQUESTER_ID';
431: WF_ENGINE.SetItemAttrNumber(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
432: itemkey => l_itemkey,
433: aname => 'REQUESTER_ID',
434: avalue => l_requester_id);
435:

Line 437: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

433: aname => 'REQUESTER_ID',
434: avalue => l_requester_id);
435:
436: l_attribute := 'REQUESTER_NAME';
437: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
438: itemkey => l_itemkey,
439: aname => 'REQUESTER_NAME',
440: avalue => l_requester_name);
441:

Line 443: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

439: aname => 'REQUESTER_NAME',
440: avalue => l_requester_name);
441:
442: l_attribute := 'REQUESTER_NAME_DISP';
443: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
444: itemkey => l_itemkey,
445: aname => 'REQUESTER_NAME_DISP',
446: avalue => l_requester_name_display);
447:

Line 449: WF_ENGINE.SetItemAttrNumber(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

445: aname => 'REQUESTER_NAME_DISP',
446: avalue => l_requester_name_display);
447:
448: l_attribute := 'DELEGATEE_ID';
449: WF_ENGINE.SetItemAttrNumber(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
450: itemkey => l_itemkey,
451: aname => 'DELEGATEE_ID',
452: avalue => '');
453:

Line 455: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

451: aname => 'DELEGATEE_ID',
452: avalue => '');
453:
454: l_attribute := 'BOOK_TYPE_CODE';
455: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
456: itemkey => l_itemkey,
457: aname => 'BOOK_TYPE_CODE',
458: avalue => l_book_type_code);
459:

Line 461: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

457: aname => 'BOOK_TYPE_CODE',
458: avalue => l_book_type_code);
459:
460: l_attribute := 'REQUEST_TYPE';
461: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
462: itemkey => l_itemkey,
463: aname => 'REQUEST_TYPE',
464: avalue => l_request_type);
465:

Line 467: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

463: aname => 'REQUEST_TYPE',
464: avalue => l_request_type);
465:
466: l_attribute := 'REQUEST_TYPE_DISP';
467: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
468: itemkey => l_itemkey,
469: aname => 'REQUEST_TYPE_DISP',
470: avalue => IA_WF_UTIL_PKG.GetLookupMeaning(p_lookup_type=>'REQUEST_TYPE',
471: p_lookup_code=>l_request_type));

Line 474: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

470: avalue => IA_WF_UTIL_PKG.GetLookupMeaning(p_lookup_type=>'REQUEST_TYPE',
471: p_lookup_code=>l_request_type));
472:
473: l_attribute := 'REQUEST_PURPOSE';
474: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
475: itemkey => l_itemkey,
476: aname => 'REQUEST_PURPOSE',
477: avalue => l_purpose);
478:

Line 480: WF_ENGINE.SetItemAttrNumber(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

476: aname => 'REQUEST_PURPOSE',
477: avalue => l_purpose);
478:
479: l_attribute := 'RULE_ID';
480: WF_ENGINE.SetItemAttrNumber(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
481: itemkey => l_itemkey,
482: aname => 'RULE_ID',
483: avalue => l_rule_id);
484:

Line 486: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

482: aname => 'RULE_ID',
483: avalue => l_rule_id);
484:
485: l_attribute := 'APPROVAL_CHAIN_PHASE';
486: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
487: itemkey => l_itemkey,
488: aname => 'APPROVAL_CHAIN_PHASE',
489: avalue => l_chain_phase);
490:

Line 492: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

488: aname => 'APPROVAL_CHAIN_PHASE',
489: avalue => l_chain_phase);
490:
491: l_attribute := 'APPROVAL_CHAIN_PHASE_DISP';
492: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
493: itemkey => l_itemkey,
494: aname => 'APPROVAL_CHAIN_PHASE_DISP',
495: avalue => IA_WF_UTIL_PKG.GetLookupMeaning(p_lookup_type=>'APPROVAL_TYPE',
496: p_lookup_code=>l_chain_phase));

Line 499: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

495: avalue => IA_WF_UTIL_PKG.GetLookupMeaning(p_lookup_type=>'APPROVAL_TYPE',
496: p_lookup_code=>l_chain_phase));
497:
498: l_attribute := 'NO_MORE_APPROVER_FLAG';
499: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
500: itemkey => l_itemkey,
501: aname => 'NO_MORE_APPROVER_FLAG',
502: avalue => 'N');
503:

Line 506: WF_ENGINE.SetItemAttrDate(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

502: avalue => 'N');
503:
504: /** Reference for settting other item types
505:
506: WF_ENGINE.SetItemAttrDate(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
507: itemkey => l_itemkey,
508: aname => 'AAA_DATE',
509: avalue => p_aaa_date);
510: ***/

Line 513: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

509: avalue => p_aaa_date);
510: ***/
511:
512: l_attribute := 'REQUEST_STATUS';
513: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
514: itemkey => l_itemkey,
515: aname => 'REQUEST_STATUS',
516: avalue => IA_WF_UTIL_PKG.HeaderStatusPendingApproval);
517:

Line 519: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

515: aname => 'REQUEST_STATUS',
516: avalue => IA_WF_UTIL_PKG.HeaderStatusPendingApproval);
517:
518: l_attribute := 'REQUEST_STATUS_DISP';
519: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
520: itemkey => l_itemkey,
521: aname => 'REQUEST_STATUS_DISP',
522: avalue => IA_WF_UTIL_PKG.GetLookupMeaning(p_lookup_type=>'REQ_HDR_STATUS',
523: p_lookup_code=>IA_WF_UTIL_PKG.HeaderStatusPendingApproval));

Line 542: WF_ENGINE.StartProcess(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

538: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => l_itemkey,
539: p_calling_fn => callingProgram,
540: p_parameter1 => debugInfo);
541: -----------------------------------------------------
542: WF_ENGINE.StartProcess(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
543: itemkey => l_itemkey);
544:
545: exception
546: when others then

Line 620: WF_ENGINE.AbortProcess(IA_WF_UTIL_PKG.WF_TransactionType,

616: p_calling_fn => callingProgram,
617: p_parameter1 => debugInfo);
618: -----------------------------------------------------
619:
620: WF_ENGINE.AbortProcess(IA_WF_UTIL_PKG.WF_TransactionType,
621: p_request_id);
622:
623: commit;
624:

Line 677: l_rule_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

673: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
674: p_calling_fn => callingProgram,
675: p_parameter1 => debugInfo);
676: -----------------------------------------------------
677: l_rule_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
678: ,itemkey => itemkey
679: ,aname => 'RULE_ID');
680:
681: -----------------------------------------------------

Line 687: l_book_type_code := WF_ENGINE.GetItemAttrText(itemtype => itemtype

683: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
684: p_calling_fn => callingProgram,
685: p_parameter1 => debugInfo);
686: -----------------------------------------------------
687: l_book_type_code := WF_ENGINE.GetItemAttrText(itemtype => itemtype
688: ,itemkey => itemkey
689: ,aname => 'BOOK_TYPE_CODE');
690:
691: -----------------------------------------------------

Line 710: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

706:
707: begin
708:
709: l_attribute := 'APPROVALS_REQUIRED';
710: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
711: itemkey => itemkey,
712: aname => 'APPROVALS_REQUIRED',
713: avalue => l_approvals_required);
714: exception

Line 800: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

796: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
797: p_calling_fn => callingProgram,
798: p_parameter1 => debugInfo);
799: -----------------------------------------------------
800: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
801: ,itemkey => itemkey
802: ,aname => 'REQUEST_ID');
803:
804: -----------------------------------------------------

Line 805: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype

801: ,itemkey => itemkey
802: ,aname => 'REQUEST_ID');
803:
804: -----------------------------------------------------
805: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype
806: ,itemkey => itemkey
807: ,aname => 'APPROVAL_CHAIN_PHASE');
808:
809: -----------------------------------------------------

Line 829: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

825:
826: l_approver_id := tempApprover.person_id;
827:
828:
829: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
830: itemkey => itemkey,
831: aname => 'APPROVAL_CHAIN_PHASE',
832: avalue => l_chain_phase);
833:

Line 834: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

830: itemkey => itemkey,
831: aname => 'APPROVAL_CHAIN_PHASE',
832: avalue => l_chain_phase);
833:
834: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
835: itemkey => itemkey,
836: aname => 'APPROVAL_CHAIN_PHASE_DISP',
837: avalue => IA_WF_UTIL_PKG.GetLookupMeaning(p_lookup_type=>'APPROVAL_TYPE',
838: p_lookup_code=>l_chain_phase));

Line 847: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

843: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
844: p_calling_fn => callingProgram,
845: p_parameter1 => debugInfo);
846: -----------------------------------------------------
847: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
848: itemkey => itemkey,
849: aname => 'NO_MORE_APPROVER_FLAG',
850: avalue => 'Y');
851:

Line 879: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

875: l_approver_id,
876: l_approver_name,
877: l_approver_name_display);
878:
879: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
880: itemkey => itemkey,
881: aname => 'APPROVER_ID',
882: avalue => l_approver_id);
883:

Line 887: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

883:
884: -- l_approver_role := 'DEMO'; -- I guess fnd user needs to be set up for the role to be retrieved correctly.
885:
886: /*
887: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
888: itemkey => itemkey,
889: aname => 'APPROVER_ROLE',
890: avalue => l_approver_role);
891: */

Line 893: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

889: aname => 'APPROVER_ROLE',
890: avalue => l_approver_role);
891: */
892:
893: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
894: itemkey => itemkey,
895: aname => 'APPROVER_NAME',
896: avalue => l_approver_name);
897:

Line 898: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

894: itemkey => itemkey,
895: aname => 'APPROVER_NAME',
896: avalue => l_approver_name);
897:
898: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
899: itemkey => itemkey,
900: aname => 'APPROVER_NAME_DISP',
901: avalue => l_approver_name_display);
902:

Line 1173: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1169: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1170: p_calling_fn => callingProgram,
1171: p_parameter1 => debugInfo);
1172: -----------------------------------------------------
1173: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1174: ,itemkey => itemkey
1175: ,aname => 'REQUEST_ID');
1176:
1177: -----------------------------------------------------

Line 1178: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype

1174: ,itemkey => itemkey
1175: ,aname => 'REQUEST_ID');
1176:
1177: -----------------------------------------------------
1178: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1179: ,itemkey => itemkey
1180: ,aname => 'APPROVAL_CHAIN_PHASE');
1181:
1182: -----------------------------------------------------

Line 1188: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1184: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1185: p_calling_fn => callingProgram,
1186: p_parameter1 => debugInfo);
1187: -----------------------------------------------------
1188: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1189: ,itemkey => itemkey
1190: ,aname => 'APPROVER_ID');
1191:
1192: -----------------------------------------------------

Line 1211: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype

1207: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1208: p_calling_fn => callingProgram,
1209: p_parameter1 => debugInfo);
1210: -----------------------------------------------------
1211: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype
1212: ,itemkey => itemkey
1213: ,aname => 'APPROVAL_ID'
1214: ,avalue => l_approval_id);
1215:

Line 1622: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1618: BEGIN
1619:
1620: if (funcmode = 'RUN') then
1621:
1622: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1623: ,itemkey => itemkey
1624: ,aname => 'REQUEST_ID');
1625:
1626: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

Line 1626: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1622: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1623: ,itemkey => itemkey
1624: ,aname => 'REQUEST_ID');
1625:
1626: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1627: ,itemkey => itemkey
1628: ,aname => 'APPROVAL_ID');
1629:
1630: l_approver_role := WF_ENGINE.GetItemAttrText(itemtype => itemtype

Line 1630: l_approver_role := WF_ENGINE.GetItemAttrText(itemtype => itemtype

1626: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1627: ,itemkey => itemkey
1628: ,aname => 'APPROVAL_ID');
1629:
1630: l_approver_role := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1631: ,itemkey => itemkey
1632: ,aname => 'APPROVER_ROLE');
1633:
1634: l_notification_id := WF_NOTIFICATION.SEND(

Line 1692: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1688: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1689: p_calling_fn => callingProgram,
1690: p_parameter1 => debugInfo);
1691: -----------------------------------------------------
1692: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1693: ,itemkey => itemkey
1694: ,aname => 'REQUEST_ID');
1695:
1696: -----------------------------------------------------

Line 1697: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype

1693: ,itemkey => itemkey
1694: ,aname => 'REQUEST_ID');
1695:
1696: -----------------------------------------------------
1697: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1698: ,itemkey => itemkey
1699: ,aname => 'APPROVAL_CHAIN_PHASE');
1700:
1701: -----------------------------------------------------

Line 1707: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1703: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1704: p_calling_fn => callingProgram,
1705: p_parameter1 => debugInfo);
1706: -----------------------------------------------------
1707: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1708: ,itemkey => itemkey
1709: ,aname => 'APPROVAL_ID');
1710:
1711: -----------------------------------------------------

Line 1717: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1713: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1714: p_calling_fn => callingProgram,
1715: p_parameter1 => debugInfo);
1716: -----------------------------------------------------
1717: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1718: ,itemkey => itemkey
1719: ,aname => 'APPROVER_ID');
1720:
1721: tempApprover.person_id := l_approver_id;

Line 1731: if (IA_WF_UTIL_PKG.GetApprovalMethod(p_rule_id => WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1727: p_calling_fn => callingProgram,
1728: p_parameter1 => debugInfo);
1729: -----------------------------------------------------
1730: -- Bug#5002756: Disabled UpdateApprovalStatus in case of CostCenter method
1731: if (IA_WF_UTIL_PKG.GetApprovalMethod(p_rule_id => WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1732: ,itemkey => itemkey
1733: ,aname => 'RULE_ID')
1734: ,p_book_type_code => WF_ENGINE.GetItemAttrText(itemtype => itemtype
1735: ,itemkey => itemkey

Line 1734: ,p_book_type_code => WF_ENGINE.GetItemAttrText(itemtype => itemtype

1730: -- Bug#5002756: Disabled UpdateApprovalStatus in case of CostCenter method
1731: if (IA_WF_UTIL_PKG.GetApprovalMethod(p_rule_id => WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1732: ,itemkey => itemkey
1733: ,aname => 'RULE_ID')
1734: ,p_book_type_code => WF_ENGINE.GetItemAttrText(itemtype => itemtype
1735: ,itemkey => itemkey
1736: ,aname => 'BOOK_TYPE_CODE')
1737: )
1738: = IA_WF_UTIL_PKG.ApprovalMethodHierarchy ) then

Line 1816: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1812: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1813: p_calling_fn => callingProgram,
1814: p_parameter1 => debugInfo);
1815: -----------------------------------------------------
1816: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1817: ,itemkey => itemkey
1818: ,aname => 'REQUEST_ID');
1819:
1820: -----------------------------------------------------

Line 1821: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype

1817: ,itemkey => itemkey
1818: ,aname => 'REQUEST_ID');
1819:
1820: -----------------------------------------------------
1821: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1822: ,itemkey => itemkey
1823: ,aname => 'APPROVAL_CHAIN_PHASE');
1824:
1825: -----------------------------------------------------

Line 1831: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1827: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1828: p_calling_fn => callingProgram,
1829: p_parameter1 => debugInfo);
1830: -----------------------------------------------------
1831: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1832: ,itemkey => itemkey
1833: ,aname => 'APPROVAL_ID');
1834:
1835: -----------------------------------------------------

Line 1841: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1837: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1838: p_calling_fn => callingProgram,
1839: p_parameter1 => debugInfo);
1840: -----------------------------------------------------
1841: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1842: ,itemkey => itemkey
1843: ,aname => 'APPROVER_ID');
1844:
1845: IA_WF_UTIL_PKG.AddDebugMessage(callingProgram, debugInfo, l_approver_id);

Line 1853: l_delegatee_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1849: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1850: p_calling_fn => callingProgram,
1851: p_parameter1 => debugInfo);
1852: -----------------------------------------------------
1853: l_delegatee_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1854: ,itemkey => itemkey
1855: ,aname => 'DELEGATEE_ID');
1856:
1857: IA_WF_UTIL_PKG.AddDebugMessage(callingProgram, debugInfo, l_delegatee_id);

Line 1876: if (IA_WF_UTIL_PKG.GetApprovalMethod(p_rule_id => WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1872: p_calling_fn => callingProgram,
1873: p_parameter1 => debugInfo);
1874: -----------------------------------------------------
1875: -- Bug#5002756: Disabled UpdateApprovalStatus in case of CostCenter method
1876: if (IA_WF_UTIL_PKG.GetApprovalMethod(p_rule_id => WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1877: ,itemkey => itemkey
1878: ,aname => 'RULE_ID')
1879: ,p_book_type_code => WF_ENGINE.GetItemAttrText(itemtype => itemtype
1880: ,itemkey => itemkey

Line 1879: ,p_book_type_code => WF_ENGINE.GetItemAttrText(itemtype => itemtype

1875: -- Bug#5002756: Disabled UpdateApprovalStatus in case of CostCenter method
1876: if (IA_WF_UTIL_PKG.GetApprovalMethod(p_rule_id => WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1877: ,itemkey => itemkey
1878: ,aname => 'RULE_ID')
1879: ,p_book_type_code => WF_ENGINE.GetItemAttrText(itemtype => itemtype
1880: ,itemkey => itemkey
1881: ,aname => 'BOOK_TYPE_CODE')
1882: )
1883: = IA_WF_UTIL_PKG.ApprovalMethodHierarchy ) then

Line 1959: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1955: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1956: p_calling_fn => callingProgram,
1957: p_parameter1 => debugInfo);
1958: -----------------------------------------------------
1959: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1960: ,itemkey => itemkey
1961: ,aname => 'REQUEST_ID');
1962:
1963: -----------------------------------------------------

Line 1964: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype

1960: ,itemkey => itemkey
1961: ,aname => 'REQUEST_ID');
1962:
1963: -----------------------------------------------------
1964: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1965: ,itemkey => itemkey
1966: ,aname => 'APPROVAL_CHAIN_PHASE');
1967:
1968: -----------------------------------------------------

Line 1974: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1970: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1971: p_calling_fn => callingProgram,
1972: p_parameter1 => debugInfo);
1973: -----------------------------------------------------
1974: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1975: ,itemkey => itemkey
1976: ,aname => 'APPROVAL_ID');
1977:
1978: -----------------------------------------------------

Line 1984: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1980: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
1981: p_calling_fn => callingProgram,
1982: p_parameter1 => debugInfo);
1983: -----------------------------------------------------
1984: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1985: ,itemkey => itemkey
1986: ,aname => 'APPROVER_ID');
1987:
1988: tempApprover.person_id := l_approver_id;

Line 1998: if (IA_WF_UTIL_PKG.GetApprovalMethod(p_rule_id => WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1994: p_calling_fn => callingProgram,
1995: p_parameter1 => debugInfo);
1996: -----------------------------------------------------
1997: -- Bug#5002756: Disabled UpdateApprovalStatus in case of CostCenter method
1998: if (IA_WF_UTIL_PKG.GetApprovalMethod(p_rule_id => WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1999: ,itemkey => itemkey
2000: ,aname => 'RULE_ID')
2001: ,p_book_type_code => WF_ENGINE.GetItemAttrText(itemtype => itemtype
2002: ,itemkey => itemkey

Line 2001: ,p_book_type_code => WF_ENGINE.GetItemAttrText(itemtype => itemtype

1997: -- Bug#5002756: Disabled UpdateApprovalStatus in case of CostCenter method
1998: if (IA_WF_UTIL_PKG.GetApprovalMethod(p_rule_id => WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1999: ,itemkey => itemkey
2000: ,aname => 'RULE_ID')
2001: ,p_book_type_code => WF_ENGINE.GetItemAttrText(itemtype => itemtype
2002: ,itemkey => itemkey
2003: ,aname => 'BOOK_TYPE_CODE')
2004: )
2005: = IA_WF_UTIL_PKG.ApprovalMethodHierarchy ) then

Line 2036: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

2032: -----------------------------------------------------
2033: Update_Request_Header_Status(p_request_id => l_request_id
2034: ,p_status => IA_WF_UTIL_PKG.HeaderStatusRejected);
2035:
2036: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
2037: itemkey => itemkey,
2038: aname => 'REQUEST_STATUS',
2039: avalue => IA_WF_UTIL_PKG.HeaderStatusRejected);
2040:

Line 2041: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

2037: itemkey => itemkey,
2038: aname => 'REQUEST_STATUS',
2039: avalue => IA_WF_UTIL_PKG.HeaderStatusRejected);
2040:
2041: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
2042: itemkey => itemkey,
2043: aname => 'REQUEST_STATUS_DISP',
2044: avalue => IA_WF_UTIL_PKG.GetLookupMeaning(p_lookup_type=>'REQ_HDR_STATUS',
2045: p_lookup_code=>IA_WF_UTIL_PKG.HeaderStatusRejected));

Line 2108: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

2104: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
2105: p_calling_fn => callingProgram,
2106: p_parameter1 => debugInfo);
2107: -----------------------------------------------------
2108: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
2109: ,itemkey => itemkey
2110: ,aname => 'REQUEST_ID');
2111:
2112: -----------------------------------------------------

Line 2113: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype

2109: ,itemkey => itemkey
2110: ,aname => 'REQUEST_ID');
2111:
2112: -----------------------------------------------------
2113: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype
2114: ,itemkey => itemkey
2115: ,aname => 'APPROVAL_CHAIN_PHASE');
2116:
2117: -----------------------------------------------------

Line 2123: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

2119: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
2120: p_calling_fn => callingProgram,
2121: p_parameter1 => debugInfo);
2122: -----------------------------------------------------
2123: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
2124: ,itemkey => itemkey
2125: ,aname => 'APPROVAL_ID');
2126:
2127: -----------------------------------------------------

Line 2133: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

2129: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
2130: p_calling_fn => callingProgram,
2131: p_parameter1 => debugInfo);
2132: -----------------------------------------------------
2133: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
2134: ,itemkey => itemkey
2135: ,aname => 'APPROVER_ID');
2136:
2137:

Line 2152: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

2148: -----------------------------------------------------
2149: Update_Request_Header_Status(p_request_id => l_request_id
2150: ,p_status => IA_WF_UTIL_PKG.HeaderStatusRejected);
2151:
2152: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
2153: itemkey => itemkey,
2154: aname => 'REQUEST_STATUS',
2155: avalue => IA_WF_UTIL_PKG.HeaderStatusRejected);
2156:

Line 2157: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,

2153: itemkey => itemkey,
2154: aname => 'REQUEST_STATUS',
2155: avalue => IA_WF_UTIL_PKG.HeaderStatusRejected);
2156:
2157: WF_ENGINE.SetItemAttrText(itemtype => IA_WF_UTIL_PKG.WF_TransactionType,
2158: itemkey => itemkey,
2159: aname => 'REQUEST_STATUS_DISP',
2160: avalue => IA_WF_UTIL_PKG.GetLookupMeaning(p_lookup_type=>'REQ_HDR_STATUS',
2161: p_lookup_code=>IA_WF_UTIL_PKG.HeaderStatusRejected));

Line 2216: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

2212: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
2213: p_calling_fn => callingProgram,
2214: p_parameter1 => debugInfo);
2215: -----------------------------------------------------
2216: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
2217: ,itemkey => itemkey
2218: ,aname => 'REQUEST_ID');
2219:
2220: -----------------------------------------------------

Line 2226: l_approvals_required := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

2222: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
2223: p_calling_fn => callingProgram,
2224: p_parameter1 => debugInfo);
2225: -----------------------------------------------------
2226: l_approvals_required := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
2227: ,itemkey => itemkey
2228: ,aname => 'APPROVALS_REQUIRED');
2229:
2230: if (l_approvals_required = 'YES') then

Line 2233: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype

2229:
2230: if (l_approvals_required = 'YES') then
2231: -----------------------------------------------------
2232: debugInfo := 'Get approval chain phase';
2233: l_chain_phase := WF_ENGINE.GetItemAttrText(itemtype => itemtype
2234: ,itemkey => itemkey
2235: ,aname => 'APPROVAL_CHAIN_PHASE');
2236:
2237: -----------------------------------------------------

Line 2243: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

2239: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
2240: p_calling_fn => callingProgram,
2241: p_parameter1 => debugInfo);
2242: -----------------------------------------------------
2243: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
2244: ,itemkey => itemkey
2245: ,aname => 'APPROVAL_ID');
2246:
2247: -----------------------------------------------------

Line 2269: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2265: -----------------------------------------------------
2266: Update_Request_Header_Status(p_request_id => l_request_id
2267: ,p_status => IA_WF_UTIL_PKG.HeaderStatusApproved);
2268:
2269: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2270: itemkey => itemkey,
2271: aname => 'REQUEST_STATUS',
2272: avalue => IA_WF_UTIL_PKG.HeaderStatusApproved);
2273:

Line 2274: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2270: itemkey => itemkey,
2271: aname => 'REQUEST_STATUS',
2272: avalue => IA_WF_UTIL_PKG.HeaderStatusApproved);
2273:
2274: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2275: itemkey => itemkey,
2276: aname => 'REQUEST_STATUS_DISP',
2277: avalue => IA_WF_UTIL_PKG.GetLookupMeaning(p_lookup_type=>'REQ_HDR_STATUS',
2278: p_lookup_code=>IA_WF_UTIL_PKG.HeaderStatusApproved));

Line 2334: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

2330: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
2331: p_calling_fn => callingProgram,
2332: p_parameter1 => debugInfo);
2333: -----------------------------------------------------
2334: l_approval_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
2335: ,itemkey => itemkey
2336: ,aname => 'APPROVAL_ID');
2337:
2338: -----------------------------------------------------

Line 2344: l_rule_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

2340: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
2341: p_calling_fn => callingProgram,
2342: p_parameter1 => debugInfo);
2343: -----------------------------------------------------
2344: l_rule_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
2345: ,itemkey => itemkey
2346: ,aname => 'RULE_ID');
2347:
2348: -----------------------------------------------------

Line 2354: l_book_type_code := WF_ENGINE.GetItemAttrText(itemtype => itemtype

2350: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
2351: p_calling_fn => callingProgram,
2352: p_parameter1 => debugInfo);
2353: -----------------------------------------------------
2354: l_book_type_code := WF_ENGINE.GetItemAttrText(itemtype => itemtype
2355: ,itemkey => itemkey
2356: ,aname => 'BOOK_TYPE_CODE');
2357:
2358: -----------------------------------------------------

Line 2415: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

2411: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
2412: p_calling_fn => callingProgram,
2413: p_parameter1 => debugInfo);
2414: -----------------------------------------------------
2415: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
2416: ,itemkey => itemkey
2417: ,aname => 'REQUEST_ID');
2418:
2419: -----------------------------------------------------

Line 2475: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

2471: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,
2472: p_calling_fn => callingProgram,
2473: p_parameter1 => debugInfo);
2474: -----------------------------------------------------
2475: l_request_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
2476: ,itemkey => itemkey
2477: ,aname => 'REQUEST_ID');
2478:
2479: -----------------------------------------------------

Line 2501: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2497: -----------------------------------------------------
2498: Update_Request_Header_Status(p_request_id => l_request_id
2499: ,p_status => IA_WF_UTIL_PKG.HeaderStatusPost);
2500:
2501: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2502: itemkey => itemkey,
2503: aname => 'REQUEST_STATUS',
2504: avalue => IA_WF_UTIL_PKG.HeaderStatusPost);
2505:

Line 2506: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2502: itemkey => itemkey,
2503: aname => 'REQUEST_STATUS',
2504: avalue => IA_WF_UTIL_PKG.HeaderStatusPost);
2505:
2506: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2507: itemkey => itemkey,
2508: aname => 'REQUEST_STATUS_DISP',
2509: avalue => IA_WF_UTIL_PKG.GetLookupMeaning(p_lookup_type=>'REQ_HDR_STATUS',
2510: p_lookup_code=>IA_WF_UTIL_PKG.HeaderStatusPost));