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

Line 390: l_activity_type := wf_engine.getitemattrtext(

386: l_hyphen_pos1 := INSTR(document_id, ':');
387: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
388: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
389:
390: l_activity_type := wf_engine.getitemattrtext(
391: itemtype => l_item_type
392: ,itemkey => l_item_key
393: ,aname => 'AMS_ACTIVITY_TYPE'
394: );

Line 396: l_claim_id := wf_engine.getitemattrtext(

392: ,itemkey => l_item_key
393: ,aname => 'AMS_ACTIVITY_TYPE'
394: );
395:
396: l_claim_id := wf_engine.getitemattrtext(
397: itemtype => l_item_type
398: ,itemkey => l_item_key
399: ,aname => 'AMS_ACTIVITY_ID'
400: );

Line 402: l_requested_amt := wf_engine.getitemattrtext(

398: ,itemkey => l_item_key
399: ,aname => 'AMS_ACTIVITY_ID'
400: );
401:
402: l_requested_amt := wf_engine.getitemattrtext(
403: itemtype => l_item_type
404: ,itemkey => l_item_key
405: ,aname => 'AMS_REQUESTED_AMOUNT'
406: );

Line 408: l_note := wf_engine.getitemattrtext(

404: ,itemkey => l_item_key
405: ,aname => 'AMS_REQUESTED_AMOUNT'
406: );
407:
408: l_note := wf_engine.getitemattrtext(
409: itemtype => l_item_type
410: ,itemkey => l_item_key
411: ,aname => 'AMS_PREV_APPROVER_NOTE'
412: );

Line 414: l_approver := wf_engine.getitemattrtext(

410: ,itemkey => l_item_key
411: ,aname => 'AMS_PREV_APPROVER_NOTE'
412: );
413:
414: l_approver := wf_engine.getitemattrtext(
415: itemtype => l_item_type
416: ,itemkey => l_item_key
417: ,aname => 'AMS_APPROVER_DISPLAY_NAME'
418: );

Line 420: l_approval_type := wf_engine.GetItemAttrText(

416: ,itemkey => l_item_key
417: ,aname => 'AMS_APPROVER_DISPLAY_NAME'
418: );
419:
420: l_approval_type := wf_engine.GetItemAttrText(
421: itemtype => l_item_type
422: ,itemkey => l_item_key
423: ,aname => 'AMS_APPROVAL_TYPE'
424: );

Line 426: l_note := wf_engine.getitemattrtext(

422: ,itemkey => l_item_key
423: ,aname => 'AMS_APPROVAL_TYPE'
424: );
425:
426: l_note := wf_engine.getitemattrtext(
427: itemtype => l_item_type
428: ,itemkey => l_item_key
429: ,aname => 'AMS_NOTES_FROM_REQUESTOR'
430: );

Line 461: wf_engine.setitemattrtext(

457: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
458: --fnd_message.set_token('APPROVER', l_approver, false);
459: l_subject := fnd_message.get;
460:
461: wf_engine.setitemattrtext(
462: itemtype => l_item_type
463: ,itemkey => l_item_key
464: ,aname => 'FYI_SUBJECT'
465: ,avalue => l_subject

Line 499: l_note := wf_engine.getitemattrtext(

495: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
496: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
497: l_body := fnd_message.get;
498: /*
499: l_note := wf_engine.getitemattrtext(
500: itemtype => l_item_type
501: ,itemkey => l_item_key
502: ,aname => 'NOTE');
503:

Line 506: wf_engine.getitemattrtext(

502: ,aname => 'NOTE');
503:
504:
505: l_forwarder :=
506: wf_engine.getitemattrtext(
507: itemtype => l_item_type
508: ,itemkey => l_item_key
509: ,aname => 'OZF_FORWARD_FROM_USERNAME');
510: */

Line 653: l_activity_type := wf_engine.getitemattrtext(

649: -- release 2.5 version of this demo
650: l_hyphen_pos1 := INSTR(document_id, ':');
651: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
652: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
653: l_activity_type := wf_engine.getitemattrtext(
654: itemtype => l_item_type
655: ,itemkey => l_item_key
656: ,aname => 'AMS_ACTIVITY_TYPE'
657: );

Line 659: l_claim_id := wf_engine.getitemattrtext(

655: ,itemkey => l_item_key
656: ,aname => 'AMS_ACTIVITY_TYPE'
657: );
658:
659: l_claim_id := wf_engine.getitemattrtext(
660: itemtype => l_item_type
661: ,itemkey => l_item_key
662: ,aname => 'AMS_ACTIVITY_ID'
663: );

Line 665: l_requested_amt := wf_engine.getitemattrtext(

661: ,itemkey => l_item_key
662: ,aname => 'AMS_ACTIVITY_ID'
663: );
664:
665: l_requested_amt := wf_engine.getitemattrtext(
666: itemtype => l_item_type
667: ,itemkey => l_item_key
668: ,aname => 'AMS_REQUESTED_AMOUNT'
669: );

Line 671: l_requester := wf_engine.getitemattrtext(

667: ,itemkey => l_item_key
668: ,aname => 'AMS_REQUESTED_AMOUNT'
669: );
670:
671: l_requester := wf_engine.getitemattrtext(
672: itemtype => l_item_type
673: ,itemkey => l_item_key
674: ,aname => 'AMS_REQUESTER'
675: );

Line 677: l_approver := wf_engine.getitemattrtext(

673: ,itemkey => l_item_key
674: ,aname => 'AMS_REQUESTER'
675: );
676:
677: l_approver := wf_engine.getitemattrtext(
678: itemtype => l_item_type
679: ,itemkey => l_item_key
680: ,aname => 'AMS_APPROVER_DISPLAY_NAME'
681: );

Line 683: l_pre_approver := wf_engine.getitemattrtext(

679: ,itemkey => l_item_key
680: ,aname => 'AMS_APPROVER_DISPLAY_NAME'
681: );
682:
683: l_pre_approver := wf_engine.getitemattrtext(
684: itemtype => l_item_type
685: ,itemkey => l_item_key
686: ,aname => 'AMS_PREV_APPROVER_DISP_NAME'
687: );

Line 695: l_note := wf_engine.getitemattrtext(

691: -- If the approver is the first in line, then the requestor's comments must be shown
692: -- If the approver is not the first, previous approver's comments must be shown
693:
694: -- start of Bugfix 7334602
695: l_note := wf_engine.getitemattrtext(
696: itemtype => l_item_type
697: ,itemkey => l_item_key
698: ,aname => 'AMS_NOTES_FROM_REQUESTOR'
699: );

Line 705: l_note := wf_engine.getitemattrtext(

701:
702: -- end of Bugfix 7334602
703: -- end of Bugfix 5686652
704: /*
705: l_note := wf_engine.getitemattrtext(
706: itemtype => l_item_type
707: ,itemkey => l_item_key
708: ,aname => 'NOTE'
709: );

Line 712: l_approval_type := wf_engine.GetItemAttrText(

708: ,aname => 'NOTE'
709: );
710: */
711:
712: l_approval_type := wf_engine.GetItemAttrText(
713: itemtype => l_item_type
714: ,itemkey => l_item_key
715: ,aname => 'AMS_APPROVAL_TYPE'
716: );

Line 747: wf_engine.setitemattrtext(

743: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
744: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
745: l_subject := fnd_message.get;
746:
747: wf_engine.setitemattrtext(
748: itemtype => l_item_type
749: ,itemkey => l_item_key
750: ,aname => 'APP_SUBJECT'
751: ,avalue => l_subject

Line 790: -- l_note := wf_engine.getitemattrtext(

786:
787: l_body := fnd_message.get;
788:
789: /*
790: -- l_note := wf_engine.getitemattrtext(
791: -- itemtype => l_item_type
792: -- ,itemkey => l_item_key
793: -- ,aname => 'NOTE');
794: --

Line 797: -- wf_engine.getitemattrtext(

793: -- ,aname => 'NOTE');
794: --
795: --
796: -- l_forwarder :=
797: -- wf_engine.getitemattrtext(
798: -- itemtype => l_item_type
799: -- ,itemkey => l_item_key
800: -- ,aname => 'AMS_FORWARD_FROM_USERNAME');
801: */

Line 949: l_activity_type := wf_engine.getitemattrtext(

945: l_hyphen_pos1 := INSTR(document_id, ':');
946: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
947: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
948:
949: l_activity_type := wf_engine.getitemattrtext(
950: itemtype => l_item_type
951: ,itemkey => l_item_key
952: ,aname => 'AMS_ACTIVITY_TYPE'
953: );

Line 955: l_claim_id := wf_engine.getitemattrtext(

951: ,itemkey => l_item_key
952: ,aname => 'AMS_ACTIVITY_TYPE'
953: );
954:
955: l_claim_id := wf_engine.getitemattrtext(
956: itemtype => l_item_type
957: ,itemkey => l_item_key
958: ,aname => 'AMS_ACTIVITY_ID'
959: );

Line 961: l_requested_amt := wf_engine.getitemattrtext(

957: ,itemkey => l_item_key
958: ,aname => 'AMS_ACTIVITY_ID'
959: );
960:
961: l_requested_amt := wf_engine.getitemattrtext(
962: itemtype => l_item_type
963: ,itemkey => l_item_key
964: ,aname => 'AMS_REQUESTED_AMOUNT'
965: );

Line 967: l_requester := wf_engine.getitemattrtext(

963: ,itemkey => l_item_key
964: ,aname => 'AMS_REQUESTED_AMOUNT'
965: );
966:
967: l_requester := wf_engine.getitemattrtext(
968: itemtype => l_item_type
969: ,itemkey => l_item_key
970: ,aname => 'AMS_REQUESTER'
971: );

Line 973: l_approval_type := wf_engine.GetItemAttrText(

969: ,itemkey => l_item_key
970: ,aname => 'AMS_REQUESTER'
971: );
972:
973: l_approval_type := wf_engine.GetItemAttrText(
974: itemtype => l_item_type
975: ,itemkey => l_item_key
976: ,aname => 'AMS_APPROVAL_TYPE'
977: );

Line 1008: wf_engine.setitemattrtext(

1004: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1005: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1006: l_subject := fnd_message.get;
1007:
1008: wf_engine.setitemattrtext(
1009: itemtype => l_item_type
1010: ,itemkey => l_item_key
1011: ,aname => 'APP_SUBJECT'
1012: ,avalue => l_subject

Line 1015: l_note := wf_engine.getitemattrtext(

1011: ,aname => 'APP_SUBJECT'
1012: ,avalue => l_subject
1013: );
1014:
1015: l_note := wf_engine.getitemattrtext(
1016: itemtype => l_item_type
1017: ,itemkey => l_item_key
1018: ,aname => 'AMS_PREV_APPROVER_NOTE'
1019: );

Line 1048: l_note := wf_engine.getitemattrtext(

1044: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1045: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1046: l_body := fnd_message.get;
1047: /*
1048: l_note := wf_engine.getitemattrtext(
1049: itemtype => l_item_type
1050: ,itemkey => l_item_key
1051: ,aname => 'NOTE');
1052:

Line 1055: wf_engine.getitemattrtext(

1051: ,aname => 'NOTE');
1052:
1053:
1054: l_forwarder :=
1055: wf_engine.getitemattrtext(
1056: itemtype => l_item_type
1057: ,itemkey => l_item_key
1058: ,aname => 'OZF_FORWARD_FROM_USERNAME');
1059: */

Line 1202: l_activity_type := wf_engine.getitemattrtext(

1198: l_hyphen_pos1 := INSTR(document_id, ':');
1199: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1200: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1201:
1202: l_activity_type := wf_engine.getitemattrtext(
1203: itemtype => l_item_type
1204: ,itemkey => l_item_key
1205: ,aname => 'AMS_ACTIVITY_TYPE'
1206: );

Line 1208: l_claim_id := wf_engine.getitemattrtext(

1204: ,itemkey => l_item_key
1205: ,aname => 'AMS_ACTIVITY_TYPE'
1206: );
1207:
1208: l_claim_id := wf_engine.getitemattrtext(
1209: itemtype => l_item_type
1210: ,itemkey => l_item_key
1211: ,aname => 'AMS_ACTIVITY_ID'
1212: );

Line 1214: l_approved_amt := wf_engine.getitemattrtext(

1210: ,itemkey => l_item_key
1211: ,aname => 'AMS_ACTIVITY_ID'
1212: );
1213:
1214: l_approved_amt := wf_engine.getitemattrtext(
1215: itemtype => l_item_type
1216: ,itemkey => l_item_key
1217: ,aname => 'AMS_REQUESTED_AMOUNT'
1218: );

Line 1220: l_note := wf_engine.getitemattrtext(

1216: ,itemkey => l_item_key
1217: ,aname => 'AMS_REQUESTED_AMOUNT'
1218: );
1219:
1220: l_note := wf_engine.getitemattrtext(
1221: itemtype => l_item_type
1222: ,itemkey => l_item_key
1223: ,aname => 'APPROVAL_NOTE'
1224: );

Line 1226: l_approver := wf_engine.getitemattrtext(

1222: ,itemkey => l_item_key
1223: ,aname => 'APPROVAL_NOTE'
1224: );
1225:
1226: l_approver := wf_engine.getitemattrtext(
1227: itemtype => l_item_type
1228: ,itemkey => l_item_key
1229: ,aname => 'AMS_APPROVER_DISPLAY_NAME'
1230: );

Line 1232: l_approval_type := wf_engine.GetItemAttrText(

1228: ,itemkey => l_item_key
1229: ,aname => 'AMS_APPROVER_DISPLAY_NAME'
1230: );
1231:
1232: l_approval_type := wf_engine.GetItemAttrText(
1233: itemtype => l_item_type
1234: ,itemkey => l_item_key
1235: ,aname => 'AMS_APPROVAL_TYPE'
1236: );

Line 1268: wf_engine.setitemattrtext(

1264: --fnd_message.set_token('APPROVER', l_approver, false);
1265: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1266: l_subject := fnd_message.get;
1267:
1268: wf_engine.setitemattrtext(
1269: itemtype => l_item_type
1270: ,itemkey => l_item_key
1271: ,aname => 'APRV_SUBJECT'
1272: ,avalue => l_subject

Line 1305: l_note := wf_engine.getitemattrtext(

1301: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1302: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1303: l_body := fnd_message.get;
1304: /*
1305: l_note := wf_engine.getitemattrtext(
1306: itemtype => l_item_type
1307: ,itemkey => l_item_key
1308: ,aname => 'NOTE');
1309:

Line 1312: wf_engine.getitemattrtext(

1308: ,aname => 'NOTE');
1309:
1310:
1311: l_forwarder :=
1312: wf_engine.getitemattrtext(
1313: itemtype => l_item_type
1314: ,itemkey => l_item_key
1315: ,aname => 'OZF_FORWARD_FROM_USERNAME');
1316: */

Line 1457: l_activity_type := wf_engine.getitemattrtext(

1453: l_hyphen_pos1 := INSTR(document_id, ':');
1454: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1455: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1456:
1457: l_activity_type := wf_engine.getitemattrtext(
1458: itemtype => l_item_type
1459: ,itemkey => l_item_key
1460: ,aname => 'AMS_ACTIVITY_TYPE'
1461: );

Line 1463: l_claim_id := wf_engine.getitemattrtext(

1459: ,itemkey => l_item_key
1460: ,aname => 'AMS_ACTIVITY_TYPE'
1461: );
1462:
1463: l_claim_id := wf_engine.getitemattrtext(
1464: itemtype => l_item_type
1465: ,itemkey => l_item_key
1466: ,aname => 'AMS_ACTIVITY_ID'
1467: );

Line 1469: l_approved_amt := wf_engine.getitemattrtext(

1465: ,itemkey => l_item_key
1466: ,aname => 'AMS_ACTIVITY_ID'
1467: );
1468:
1469: l_approved_amt := wf_engine.getitemattrtext(
1470: itemtype => l_item_type
1471: ,itemkey => l_item_key
1472: ,aname => 'AMS_AMOUNT'
1473: );

Line 1475: l_note := wf_engine.getitemattrtext(

1471: ,itemkey => l_item_key
1472: ,aname => 'AMS_AMOUNT'
1473: );
1474:
1475: l_note := wf_engine.getitemattrtext(
1476: itemtype => l_item_type
1477: ,itemkey => l_item_key
1478: ,aname => 'APPROVAL_NOTE'
1479: );

Line 1481: l_approver := wf_engine.getitemattrtext(

1477: ,itemkey => l_item_key
1478: ,aname => 'APPROVAL_NOTE'
1479: );
1480:
1481: l_approver := wf_engine.getitemattrtext(
1482: itemtype => l_item_type
1483: ,itemkey => l_item_key
1484: ,aname => 'AMS_APPROVER_DISPLAY_NAME'
1485: );

Line 1487: l_approval_type := wf_engine.GetItemAttrText(

1483: ,itemkey => l_item_key
1484: ,aname => 'AMS_APPROVER_DISPLAY_NAME'
1485: );
1486:
1487: l_approval_type := wf_engine.GetItemAttrText(
1488: itemtype => l_item_type
1489: ,itemkey => l_item_key
1490: ,aname => 'AMS_APPROVAL_TYPE'
1491: );

Line 1523: wf_engine.setitemattrtext(

1519: --fnd_message.set_token('APPROVER', l_approver, false);
1520: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1521: l_subject := fnd_message.get;
1522:
1523: wf_engine.setitemattrtext(
1524: itemtype => l_item_type
1525: ,itemkey => l_item_key
1526: ,aname => 'REJECT_SUBJECT'
1527: ,avalue => l_subject

Line 1561: l_note := wf_engine.getitemattrtext(

1557: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1558: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1559: l_body := fnd_message.get;
1560: /*
1561: l_note := wf_engine.getitemattrtext(
1562: itemtype => l_item_type
1563: ,itemkey => l_item_key
1564: ,aname => 'NOTE');
1565:

Line 1568: wf_engine.getitemattrtext(

1564: ,aname => 'NOTE');
1565:
1566:
1567: l_forwarder :=
1568: wf_engine.getitemattrtext(
1569: itemtype => l_item_type
1570: ,itemkey => l_item_key
1571: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1572: */

Line 1730: l_activity_id := WF_ENGINE.getitemattrnumber(

1726:
1727: BEGIN
1728: FND_MSG_PUB.initialize;
1729:
1730: l_activity_id := WF_ENGINE.getitemattrnumber(
1731: itemtype => itemtype
1732: ,itemkey => itemkey
1733: ,aname => 'AMS_ACTIVITY_ID'
1734: );

Line 1736: l_approval_type := wf_engine.GetItemAttrText(

1732: ,itemkey => itemkey
1733: ,aname => 'AMS_ACTIVITY_ID'
1734: );
1735:
1736: l_approval_type := wf_engine.GetItemAttrText(
1737: itemtype => itemtype
1738: ,itemkey => itemkey
1739: ,aname => 'AMS_APPROVAL_TYPE'
1740: );

Line 1742: l_requester_id := wf_engine.getitemattrnumber(

1738: ,itemkey => itemkey
1739: ,aname => 'AMS_APPROVAL_TYPE'
1740: );
1741:
1742: l_requester_id := wf_engine.getitemattrnumber(
1743: itemtype => itemtype
1744: ,itemkey => itemkey
1745: ,aname => 'AMS_REQUESTER_ID'
1746: );

Line 1807: WF_ENGINE.setitemattrnumber(

1803: ,x_return_status => l_return_status
1804: );
1805:
1806: IF l_return_status = fnd_api.g_ret_sts_success THEN
1807: WF_ENGINE.setitemattrnumber(
1808: itemtype => itemtype
1809: ,itemkey => itemkey
1810: ,aname => 'AMS_APPROVAL_DETAIL_ID'
1811: ,avalue => l_approval_detail_id

Line 1813: WF_ENGINE.setitemattrnumber(

1809: ,itemkey => itemkey
1810: ,aname => 'AMS_APPROVAL_DETAIL_ID'
1811: ,avalue => l_approval_detail_id
1812: );
1813: WF_ENGINE.setitemattrnumber(
1814: itemtype => itemtype
1815: ,itemkey => itemkey
1816: ,aname => 'AMS_APPROVER_SEQ'
1817: ,avalue => l_approver_seq

Line 1819: WF_ENGINE.setitemattrnumber(

1815: ,itemkey => itemkey
1816: ,aname => 'AMS_APPROVER_SEQ'
1817: ,avalue => l_approver_seq
1818: );
1819: WF_ENGINE.setitemattrnumber(
1820: itemtype => itemtype
1821: ,itemkey => itemkey
1822: ,aname => 'AMS_REQUESTED_AMOUNT'
1823: ,avalue => l_object_details.total_header_amount

Line 1827: WF_ENGINE.setitemattrtext(

1823: ,avalue => l_object_details.total_header_amount
1824: );
1825:
1826: -- [BEGIN OF FIX BUG2352621 07/03/2002]
1827: WF_ENGINE.setitemattrtext(
1828: itemtype => itemtype
1829: ,itemkey => itemkey
1830: ,aname => 'AMS_APPROVAL_OBJECT_NAME'
1831: ,avalue => l_object_details.name

Line 1836: WF_ENGINE.setitemattrtext(

1832: );
1833:
1834: l_object_meaning := OZF_UTILITY_PVT.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', 'CLAM');
1835:
1836: WF_ENGINE.setitemattrtext(
1837: itemtype => itemtype
1838: ,itemkey => itemkey
1839: ,aname => 'AMS_APPROVAL_OBJECT_MEANING'
1840: ,avalue => l_object_meaning

Line 1862: WF_ENGINE.setitemattrtext(

1858: , l_claim_source
1859: , l_comments;
1860: CLOSE c_claim_rec;
1861:
1862: WF_ENGINE.setitemattrtext(
1863: itemtype => itemtype
1864: ,itemkey => itemkey
1865: ,aname => 'AMS_NOTES_FROM_REQUESTOR'
1866: ,avalue => l_comments

Line 1882: WF_ENGINE.setitemattrtext(

1878: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1879: --fnd_message.set_token('APPROVER', l_approver, false);
1880: l_subject := FND_MESSAGE.get;
1881:
1882: WF_ENGINE.setitemattrtext(
1883: itemtype => itemtype
1884: ,itemkey => itemkey
1885: ,aname => 'FYI_SUBJECT'
1886: ,avalue => l_subject

Line 1902: WF_ENGINE.setitemattrtext(

1898: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1900: l_subject := fnd_message.get;
1901:
1902: WF_ENGINE.setitemattrtext(
1903: itemtype => itemtype
1904: ,itemkey => itemkey
1905: ,aname => 'APP_SUBJECT'
1906: ,avalue => l_subject

Line 1923: WF_ENGINE.setitemattrtext(

1919: --fnd_message.set_token('APPROVER', l_approver, false);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1921: l_subject := FND_MESSAGE.get;
1922:
1923: WF_ENGINE.setitemattrtext(
1924: itemtype => itemtype
1925: ,itemkey => itemkey
1926: ,aname => 'APRV_SUBJECT'
1927: ,avalue => l_subject

Line 1944: WF_ENGINE.setitemattrtext(

1940: --fnd_message.set_token('APPROVER', l_approver, false);
1941: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1942: l_subject := FND_MESSAGE.get;
1943:
1944: WF_ENGINE.setitemattrtext(
1945: itemtype => itemtype
1946: ,itemkey => itemkey
1947: ,aname => 'REJECT_SUBJECT'
1948: ,avalue => l_subject

Line 2220: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

2216:
2217: BEGIN
2218: -- [BEGIN OF BUG2631497 FIXING by mchang 23-OCT-2002]
2219: -- mchang: initialized PL/SQL security context since workflow mailer desn't establish those value.
2220: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
2221: , itemkey => itemkey
2222: , aname => 'USER_ID'
2223: );
2224:

Line 2225: l_resp_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

2221: , itemkey => itemkey
2222: , aname => 'USER_ID'
2223: );
2224:
2225: l_resp_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
2226: , itemkey => itemkey
2227: , aname => 'RESPONSIBILITY_ID'
2228: );
2229:

Line 2230: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

2226: , itemkey => itemkey
2227: , aname => 'RESPONSIBILITY_ID'
2228: );
2229:
2230: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
2231: , itemkey => itemkey
2232: , aname => 'APPLICATION_ID'
2233: );
2234:

Line 2235: l_security_group_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

2231: , itemkey => itemkey
2232: , aname => 'APPLICATION_ID'
2233: );
2234:
2235: l_security_group_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
2236: , itemkey => itemkey
2237: , aname => 'SECURITY_GROUP_ID'
2238: );
2239:

Line 2243: l_update_status := wf_engine.getitemattrtext(

2239:
2240: -- [END OF BUG2631497 FIXING by mchang 23-OCT-2002]
2241:
2242: IF funcmode = 'RUN' THEN
2243: l_update_status := wf_engine.getitemattrtext(
2244: itemtype => itemtype
2245: ,itemkey => itemkey
2246: ,aname => 'UPDATE_GEN_STATUS'
2247: );

Line 2252: WF_ENGINE.setitemattrnumber(

2248:
2249: IF l_update_status IN ('APPROVED', 'REJECTED') AND
2250: (l_user_id IS NULL OR l_resp_id IS NULL OR l_appl_id IS NULL) THEN
2251: l_update_status := NULL;
2252: WF_ENGINE.setitemattrnumber(
2253: itemtype => itemtype
2254: ,itemkey => itemkey
2255: ,aname => 'UPDATE_GEN_STATUS'
2256: ,avalue => l_update_status

Line 2289: l_claim_id := wf_engine.getitemattrnumber(

2285: --, security_group_id => l_security_group_id
2286: );
2287: END IF;
2288:
2289: l_claim_id := wf_engine.getitemattrnumber(
2290: itemtype => itemtype
2291: ,itemkey => itemkey
2292: ,aname => 'AMS_ACTIVITY_ID'
2293: );

Line 2295: l_approval_type := wf_engine.GetItemAttrText(

2291: ,itemkey => itemkey
2292: ,aname => 'AMS_ACTIVITY_ID'
2293: );
2294:
2295: l_approval_type := wf_engine.GetItemAttrText(
2296: itemtype => itemtype
2297: ,itemkey => itemkey
2298: ,aname => 'AMS_APPROVAL_TYPE'
2299: );

Line 2301: l_new_status_id := wf_engine.getitemattrnumber(

2297: ,itemkey => itemkey
2298: ,aname => 'AMS_APPROVAL_TYPE'
2299: );
2300:
2301: l_new_status_id := wf_engine.getitemattrnumber(
2302: itemtype => itemtype
2303: ,itemkey => itemkey
2304: ,aname => 'AMS_NEW_STAT_ID'
2305: );

Line 2307: l_orig_status_id := wf_engine.getitemattrnumber(

2303: ,itemkey => itemkey
2304: ,aname => 'AMS_NEW_STAT_ID'
2305: );
2306:
2307: l_orig_status_id := wf_engine.getitemattrnumber(
2308: itemtype => itemtype
2309: ,itemkey => itemkey
2310: ,aname => 'AMS_ORIG_STAT_ID'
2311: );

Line 2313: l_reject_status_id := wf_engine.getitemattrnumber(

2309: ,itemkey => itemkey
2310: ,aname => 'AMS_ORIG_STAT_ID'
2311: );
2312:
2313: l_reject_status_id := wf_engine.getitemattrnumber(
2314: itemtype => itemtype
2315: ,itemkey => itemkey
2316: ,aname => 'AMS_REJECT_STAT_ID'
2317: );

Line 2408: l_approved_amount := wf_engine.getitemattrnumber(

2404: END IF;
2405:
2406:
2407:
2408: l_approved_amount := wf_engine.getitemattrnumber(
2409: itemtype => itemtype
2410: ,itemkey => itemkey
2411: ,aname => 'AMS_AMOUNT'
2412: );

Line 2414: l_object_version_number := wf_engine.getitemattrnumber(

2410: ,itemkey => itemkey
2411: ,aname => 'AMS_AMOUNT'
2412: );
2413:
2414: l_object_version_number := wf_engine.getitemattrnumber(
2415: itemtype => itemtype
2416: ,itemkey => itemkey
2417: ,aname => 'AMS_OBJECT_VERSION_NUMBER'
2418: );

Line 2427: l_approver_id :=wf_engine.getitemattrnumber(

2423:
2424: -- set org_context since workflow mailer does not set the context
2425: set_org_ctx (l_org_id);
2426:
2427: l_approver_id :=wf_engine.getitemattrnumber(
2428: itemtype => itemtype
2429: ,itemkey => itemkey
2430: ,aname => 'AMS_APPROVER_ID'
2431: );

Line 2470: l_approver_role_name := WF_ENGINE.GetItemAttrText(itemtype => itemtype

2466: );
2467: resultout := 'COMPLETE:ERROR';
2468: --999
2469: --Set performer of the next notification to original claim approver.
2470: l_approver_role_name := WF_ENGINE.GetItemAttrText(itemtype => itemtype
2471: ,itemkey => itemkey
2472: ,aname => 'AMS_APPROVER'
2473: );
2474:

Line 2475: WF_ENGINE.AssignActivity(itemtype => itemtype

2471: ,itemkey => itemkey
2472: ,aname => 'AMS_APPROVER'
2473: );
2474:
2475: WF_ENGINE.AssignActivity(itemtype => itemtype
2476: ,itemkey => itemkey
2477: ,activity => 'AMSGAPP:AMS_NTF_ERROR_REQUEST'
2478: ,performer => l_approver_role_name
2479: );

Line 2483: WF_ENGINE.AssignActivity(itemtype => itemtype

2479: );
2480:
2481:
2482: /*
2483: WF_ENGINE.AssignActivity(itemtype => itemtype
2484: ,itemkey => itemkey
2485: ,activity => 'AMSGAPP:AMS_NTF_ERROR_REQUEST'
2486: ,performer => 'AMS_APPROVER'
2487: );