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 427: /* l_note := wf_engine.getitemattrtext(

423: ,aname => 'AMS_APPROVAL_TYPE'
424: );
425:
426: -- Start Bug fix for 8656583
427: /* l_note := wf_engine.getitemattrtext(
428: itemtype => l_item_type
429: ,itemkey => l_item_key
430: ,aname => 'AMS_NOTES_FROM_REQUESTOR'
431: );

Line 464: wf_engine.setitemattrtext(

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

Line 502: l_note := wf_engine.getitemattrtext(

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

Line 509: wf_engine.getitemattrtext(

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

Line 656: l_activity_type := wf_engine.getitemattrtext(

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

Line 662: l_claim_id := wf_engine.getitemattrtext(

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

Line 668: l_requested_amt := wf_engine.getitemattrtext(

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

Line 674: l_requester := wf_engine.getitemattrtext(

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

Line 680: l_approver := wf_engine.getitemattrtext(

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

Line 686: l_pre_approver := wf_engine.getitemattrtext(

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

Line 698: l_note := wf_engine.getitemattrtext(

694: -- If the approver is the first in line, then the requestor's comments must be shown
695: -- If the approver is not the first, previous approver's comments must be shown
696: /* Commented for bug fix 8656583
697: -- start of Bugfix 7334602
698: l_note := wf_engine.getitemattrtext(
699: itemtype => l_item_type
700: ,itemkey => l_item_key
701: ,aname => 'AMS_NOTES_FROM_REQUESTOR'
702: );

Line 708: l_note := wf_engine.getitemattrtext(

704: -- end of Bugfix 5686652
705: */
706:
707: --Start of Bug fix 8656583
708: l_note := wf_engine.getitemattrtext(
709: itemtype => l_item_type
710: ,itemkey => l_item_key
711: ,aname => 'AMS_PREV_APPROVER_NOTE'
712: );

Line 716: l_note := wf_engine.getitemattrtext(

712: );
713: --End of Bug fix 8656583
714:
715: /*
716: l_note := wf_engine.getitemattrtext(
717: itemtype => l_item_type
718: ,itemkey => l_item_key
719: ,aname => 'NOTE'
720: );

Line 723: l_approval_type := wf_engine.GetItemAttrText(

719: ,aname => 'NOTE'
720: );
721: */
722:
723: l_approval_type := wf_engine.GetItemAttrText(
724: itemtype => l_item_type
725: ,itemkey => l_item_key
726: ,aname => 'AMS_APPROVAL_TYPE'
727: );

Line 758: wf_engine.setitemattrtext(

754: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
755: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
756: l_subject := fnd_message.get;
757:
758: wf_engine.setitemattrtext(
759: itemtype => l_item_type
760: ,itemkey => l_item_key
761: ,aname => 'APP_SUBJECT'
762: ,avalue => l_subject

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

797:
798: l_body := fnd_message.get;
799:
800: /*
801: -- l_note := wf_engine.getitemattrtext(
802: -- itemtype => l_item_type
803: -- ,itemkey => l_item_key
804: -- ,aname => 'NOTE');
805: --

Line 808: -- wf_engine.getitemattrtext(

804: -- ,aname => 'NOTE');
805: --
806: --
807: -- l_forwarder :=
808: -- wf_engine.getitemattrtext(
809: -- itemtype => l_item_type
810: -- ,itemkey => l_item_key
811: -- ,aname => 'AMS_FORWARD_FROM_USERNAME');
812: */

Line 960: l_activity_type := wf_engine.getitemattrtext(

956: l_hyphen_pos1 := INSTR(document_id, ':');
957: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
958: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
959:
960: l_activity_type := wf_engine.getitemattrtext(
961: itemtype => l_item_type
962: ,itemkey => l_item_key
963: ,aname => 'AMS_ACTIVITY_TYPE'
964: );

Line 966: l_claim_id := wf_engine.getitemattrtext(

962: ,itemkey => l_item_key
963: ,aname => 'AMS_ACTIVITY_TYPE'
964: );
965:
966: l_claim_id := wf_engine.getitemattrtext(
967: itemtype => l_item_type
968: ,itemkey => l_item_key
969: ,aname => 'AMS_ACTIVITY_ID'
970: );

Line 972: l_requested_amt := wf_engine.getitemattrtext(

968: ,itemkey => l_item_key
969: ,aname => 'AMS_ACTIVITY_ID'
970: );
971:
972: l_requested_amt := wf_engine.getitemattrtext(
973: itemtype => l_item_type
974: ,itemkey => l_item_key
975: ,aname => 'AMS_REQUESTED_AMOUNT'
976: );

Line 978: l_requester := wf_engine.getitemattrtext(

974: ,itemkey => l_item_key
975: ,aname => 'AMS_REQUESTED_AMOUNT'
976: );
977:
978: l_requester := wf_engine.getitemattrtext(
979: itemtype => l_item_type
980: ,itemkey => l_item_key
981: ,aname => 'AMS_REQUESTER'
982: );

Line 984: l_approval_type := wf_engine.GetItemAttrText(

980: ,itemkey => l_item_key
981: ,aname => 'AMS_REQUESTER'
982: );
983:
984: l_approval_type := wf_engine.GetItemAttrText(
985: itemtype => l_item_type
986: ,itemkey => l_item_key
987: ,aname => 'AMS_APPROVAL_TYPE'
988: );

Line 1019: wf_engine.setitemattrtext(

1015: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1016: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1017: l_subject := fnd_message.get;
1018:
1019: wf_engine.setitemattrtext(
1020: itemtype => l_item_type
1021: ,itemkey => l_item_key
1022: ,aname => 'APP_SUBJECT'
1023: ,avalue => l_subject

Line 1026: l_note := wf_engine.getitemattrtext(

1022: ,aname => 'APP_SUBJECT'
1023: ,avalue => l_subject
1024: );
1025:
1026: l_note := wf_engine.getitemattrtext(
1027: itemtype => l_item_type
1028: ,itemkey => l_item_key
1029: ,aname => 'AMS_PREV_APPROVER_NOTE'
1030: );

Line 1059: l_note := wf_engine.getitemattrtext(

1055: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1056: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1057: l_body := fnd_message.get;
1058: /*
1059: l_note := wf_engine.getitemattrtext(
1060: itemtype => l_item_type
1061: ,itemkey => l_item_key
1062: ,aname => 'NOTE');
1063:

Line 1066: wf_engine.getitemattrtext(

1062: ,aname => 'NOTE');
1063:
1064:
1065: l_forwarder :=
1066: wf_engine.getitemattrtext(
1067: itemtype => l_item_type
1068: ,itemkey => l_item_key
1069: ,aname => 'OZF_FORWARD_FROM_USERNAME');
1070: */

Line 1213: l_activity_type := wf_engine.getitemattrtext(

1209: l_hyphen_pos1 := INSTR(document_id, ':');
1210: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1211: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1212:
1213: l_activity_type := wf_engine.getitemattrtext(
1214: itemtype => l_item_type
1215: ,itemkey => l_item_key
1216: ,aname => 'AMS_ACTIVITY_TYPE'
1217: );

Line 1219: l_claim_id := wf_engine.getitemattrtext(

1215: ,itemkey => l_item_key
1216: ,aname => 'AMS_ACTIVITY_TYPE'
1217: );
1218:
1219: l_claim_id := wf_engine.getitemattrtext(
1220: itemtype => l_item_type
1221: ,itemkey => l_item_key
1222: ,aname => 'AMS_ACTIVITY_ID'
1223: );

Line 1225: l_approved_amt := wf_engine.getitemattrtext(

1221: ,itemkey => l_item_key
1222: ,aname => 'AMS_ACTIVITY_ID'
1223: );
1224:
1225: l_approved_amt := wf_engine.getitemattrtext(
1226: itemtype => l_item_type
1227: ,itemkey => l_item_key
1228: ,aname => 'AMS_REQUESTED_AMOUNT'
1229: );

Line 1231: l_note := wf_engine.getitemattrtext(

1227: ,itemkey => l_item_key
1228: ,aname => 'AMS_REQUESTED_AMOUNT'
1229: );
1230:
1231: l_note := wf_engine.getitemattrtext(
1232: itemtype => l_item_type
1233: ,itemkey => l_item_key
1234: ,aname => 'APPROVAL_NOTE'
1235: );

Line 1237: l_approver := wf_engine.getitemattrtext(

1233: ,itemkey => l_item_key
1234: ,aname => 'APPROVAL_NOTE'
1235: );
1236:
1237: l_approver := wf_engine.getitemattrtext(
1238: itemtype => l_item_type
1239: ,itemkey => l_item_key
1240: ,aname => 'AMS_APPROVER_DISPLAY_NAME'
1241: );

Line 1243: l_approval_type := wf_engine.GetItemAttrText(

1239: ,itemkey => l_item_key
1240: ,aname => 'AMS_APPROVER_DISPLAY_NAME'
1241: );
1242:
1243: l_approval_type := wf_engine.GetItemAttrText(
1244: itemtype => l_item_type
1245: ,itemkey => l_item_key
1246: ,aname => 'AMS_APPROVAL_TYPE'
1247: );

Line 1279: wf_engine.setitemattrtext(

1275: --fnd_message.set_token('APPROVER', l_approver, false);
1276: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1277: l_subject := fnd_message.get;
1278:
1279: wf_engine.setitemattrtext(
1280: itemtype => l_item_type
1281: ,itemkey => l_item_key
1282: ,aname => 'APRV_SUBJECT'
1283: ,avalue => l_subject

Line 1316: l_note := wf_engine.getitemattrtext(

1312: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1313: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1314: l_body := fnd_message.get;
1315: /*
1316: l_note := wf_engine.getitemattrtext(
1317: itemtype => l_item_type
1318: ,itemkey => l_item_key
1319: ,aname => 'NOTE');
1320:

Line 1323: wf_engine.getitemattrtext(

1319: ,aname => 'NOTE');
1320:
1321:
1322: l_forwarder :=
1323: wf_engine.getitemattrtext(
1324: itemtype => l_item_type
1325: ,itemkey => l_item_key
1326: ,aname => 'OZF_FORWARD_FROM_USERNAME');
1327: */

Line 1468: l_activity_type := wf_engine.getitemattrtext(

1464: l_hyphen_pos1 := INSTR(document_id, ':');
1465: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1466: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1467:
1468: l_activity_type := wf_engine.getitemattrtext(
1469: itemtype => l_item_type
1470: ,itemkey => l_item_key
1471: ,aname => 'AMS_ACTIVITY_TYPE'
1472: );

Line 1474: l_claim_id := wf_engine.getitemattrtext(

1470: ,itemkey => l_item_key
1471: ,aname => 'AMS_ACTIVITY_TYPE'
1472: );
1473:
1474: l_claim_id := wf_engine.getitemattrtext(
1475: itemtype => l_item_type
1476: ,itemkey => l_item_key
1477: ,aname => 'AMS_ACTIVITY_ID'
1478: );

Line 1480: l_approved_amt := wf_engine.getitemattrtext(

1476: ,itemkey => l_item_key
1477: ,aname => 'AMS_ACTIVITY_ID'
1478: );
1479:
1480: l_approved_amt := wf_engine.getitemattrtext(
1481: itemtype => l_item_type
1482: ,itemkey => l_item_key
1483: ,aname => 'AMS_AMOUNT'
1484: );

Line 1486: l_note := wf_engine.getitemattrtext(

1482: ,itemkey => l_item_key
1483: ,aname => 'AMS_AMOUNT'
1484: );
1485:
1486: l_note := wf_engine.getitemattrtext(
1487: itemtype => l_item_type
1488: ,itemkey => l_item_key
1489: ,aname => 'APPROVAL_NOTE'
1490: );

Line 1492: l_approver := wf_engine.getitemattrtext(

1488: ,itemkey => l_item_key
1489: ,aname => 'APPROVAL_NOTE'
1490: );
1491:
1492: l_approver := wf_engine.getitemattrtext(
1493: itemtype => l_item_type
1494: ,itemkey => l_item_key
1495: ,aname => 'AMS_APPROVER_DISPLAY_NAME'
1496: );

Line 1498: l_approval_type := wf_engine.GetItemAttrText(

1494: ,itemkey => l_item_key
1495: ,aname => 'AMS_APPROVER_DISPLAY_NAME'
1496: );
1497:
1498: l_approval_type := wf_engine.GetItemAttrText(
1499: itemtype => l_item_type
1500: ,itemkey => l_item_key
1501: ,aname => 'AMS_APPROVAL_TYPE'
1502: );

Line 1534: wf_engine.setitemattrtext(

1530: --fnd_message.set_token('APPROVER', l_approver, false);
1531: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1532: l_subject := fnd_message.get;
1533:
1534: wf_engine.setitemattrtext(
1535: itemtype => l_item_type
1536: ,itemkey => l_item_key
1537: ,aname => 'REJECT_SUBJECT'
1538: ,avalue => l_subject

Line 1572: l_note := wf_engine.getitemattrtext(

1568: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1569: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1570: l_body := fnd_message.get;
1571: /*
1572: l_note := wf_engine.getitemattrtext(
1573: itemtype => l_item_type
1574: ,itemkey => l_item_key
1575: ,aname => 'NOTE');
1576:

Line 1579: wf_engine.getitemattrtext(

1575: ,aname => 'NOTE');
1576:
1577:
1578: l_forwarder :=
1579: wf_engine.getitemattrtext(
1580: itemtype => l_item_type
1581: ,itemkey => l_item_key
1582: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1583: */

Line 1741: l_activity_id := WF_ENGINE.getitemattrnumber(

1737:
1738: BEGIN
1739: FND_MSG_PUB.initialize;
1740:
1741: l_activity_id := WF_ENGINE.getitemattrnumber(
1742: itemtype => itemtype
1743: ,itemkey => itemkey
1744: ,aname => 'AMS_ACTIVITY_ID'
1745: );

Line 1747: l_approval_type := wf_engine.GetItemAttrText(

1743: ,itemkey => itemkey
1744: ,aname => 'AMS_ACTIVITY_ID'
1745: );
1746:
1747: l_approval_type := wf_engine.GetItemAttrText(
1748: itemtype => itemtype
1749: ,itemkey => itemkey
1750: ,aname => 'AMS_APPROVAL_TYPE'
1751: );

Line 1753: l_requester_id := wf_engine.getitemattrnumber(

1749: ,itemkey => itemkey
1750: ,aname => 'AMS_APPROVAL_TYPE'
1751: );
1752:
1753: l_requester_id := wf_engine.getitemattrnumber(
1754: itemtype => itemtype
1755: ,itemkey => itemkey
1756: ,aname => 'AMS_REQUESTER_ID'
1757: );

Line 1818: WF_ENGINE.setitemattrnumber(

1814: ,x_return_status => l_return_status
1815: );
1816:
1817: IF l_return_status = fnd_api.g_ret_sts_success THEN
1818: WF_ENGINE.setitemattrnumber(
1819: itemtype => itemtype
1820: ,itemkey => itemkey
1821: ,aname => 'AMS_APPROVAL_DETAIL_ID'
1822: ,avalue => l_approval_detail_id

Line 1824: WF_ENGINE.setitemattrnumber(

1820: ,itemkey => itemkey
1821: ,aname => 'AMS_APPROVAL_DETAIL_ID'
1822: ,avalue => l_approval_detail_id
1823: );
1824: WF_ENGINE.setitemattrnumber(
1825: itemtype => itemtype
1826: ,itemkey => itemkey
1827: ,aname => 'AMS_APPROVER_SEQ'
1828: ,avalue => l_approver_seq

Line 1830: WF_ENGINE.setitemattrnumber(

1826: ,itemkey => itemkey
1827: ,aname => 'AMS_APPROVER_SEQ'
1828: ,avalue => l_approver_seq
1829: );
1830: WF_ENGINE.setitemattrnumber(
1831: itemtype => itemtype
1832: ,itemkey => itemkey
1833: ,aname => 'AMS_REQUESTED_AMOUNT'
1834: ,avalue => l_object_details.total_header_amount

Line 1838: WF_ENGINE.setitemattrtext(

1834: ,avalue => l_object_details.total_header_amount
1835: );
1836:
1837: -- [BEGIN OF FIX BUG2352621 07/03/2002]
1838: WF_ENGINE.setitemattrtext(
1839: itemtype => itemtype
1840: ,itemkey => itemkey
1841: ,aname => 'AMS_APPROVAL_OBJECT_NAME'
1842: ,avalue => l_object_details.name

Line 1847: WF_ENGINE.setitemattrtext(

1843: );
1844:
1845: l_object_meaning := OZF_UTILITY_PVT.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', 'CLAM');
1846:
1847: WF_ENGINE.setitemattrtext(
1848: itemtype => itemtype
1849: ,itemkey => itemkey
1850: ,aname => 'AMS_APPROVAL_OBJECT_MEANING'
1851: ,avalue => l_object_meaning

Line 1873: WF_ENGINE.setitemattrtext(

1869: , l_claim_source
1870: , l_comments;
1871: CLOSE c_claim_rec;
1872:
1873: WF_ENGINE.setitemattrtext(
1874: itemtype => itemtype
1875: ,itemkey => itemkey
1876: ,aname => 'AMS_NOTES_FROM_REQUESTOR'
1877: ,avalue => l_comments

Line 1881: WF_ENGINE.setitemattrtext(

1877: ,avalue => l_comments
1878: );
1879:
1880: -- Start Bug fix for 8656583
1881: WF_ENGINE.setitemattrtext(
1882: itemtype => itemtype
1883: ,itemkey => itemkey
1884: ,aname => 'APPROVAL_NOTE'
1885: ,avalue => l_comments

Line 1902: WF_ENGINE.setitemattrtext(

1898: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1899: --fnd_message.set_token('APPROVER', l_approver, false);
1900: l_subject := FND_MESSAGE.get;
1901:
1902: WF_ENGINE.setitemattrtext(
1903: itemtype => itemtype
1904: ,itemkey => itemkey
1905: ,aname => 'FYI_SUBJECT'
1906: ,avalue => l_subject

Line 1922: WF_ENGINE.setitemattrtext(

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

Line 1943: WF_ENGINE.setitemattrtext(

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

Line 1964: WF_ENGINE.setitemattrtext(

1960: --fnd_message.set_token('APPROVER', l_approver, false);
1961: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1962: l_subject := FND_MESSAGE.get;
1963:
1964: WF_ENGINE.setitemattrtext(
1965: itemtype => itemtype
1966: ,itemkey => itemkey
1967: ,aname => 'REJECT_SUBJECT'
1968: ,avalue => l_subject

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

2253:
2254: BEGIN
2255: -- [BEGIN OF BUG2631497 FIXING by mchang 23-OCT-2002]
2256: -- mchang: initialized PL/SQL security context since workflow mailer desn't establish those value.
2257: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
2258: , itemkey => itemkey
2259: , aname => 'USER_ID'
2260: );
2261:

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

2258: , itemkey => itemkey
2259: , aname => 'USER_ID'
2260: );
2261:
2262: l_resp_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
2263: , itemkey => itemkey
2264: , aname => 'RESPONSIBILITY_ID'
2265: );
2266:

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

2263: , itemkey => itemkey
2264: , aname => 'RESPONSIBILITY_ID'
2265: );
2266:
2267: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
2268: , itemkey => itemkey
2269: , aname => 'APPLICATION_ID'
2270: );
2271:

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

2268: , itemkey => itemkey
2269: , aname => 'APPLICATION_ID'
2270: );
2271:
2272: l_security_group_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
2273: , itemkey => itemkey
2274: , aname => 'SECURITY_GROUP_ID'
2275: );
2276:

Line 2280: l_update_status := wf_engine.getitemattrtext(

2276:
2277: -- [END OF BUG2631497 FIXING by mchang 23-OCT-2002]
2278:
2279: IF funcmode = 'RUN' THEN
2280: l_update_status := wf_engine.getitemattrtext(
2281: itemtype => itemtype
2282: ,itemkey => itemkey
2283: ,aname => 'UPDATE_GEN_STATUS'
2284: );

Line 2289: WF_ENGINE.setitemattrnumber(

2285:
2286: IF l_update_status IN ('APPROVED', 'REJECTED') AND
2287: (l_user_id IS NULL OR l_resp_id IS NULL OR l_appl_id IS NULL) THEN
2288: l_update_status := NULL;
2289: WF_ENGINE.setitemattrnumber(
2290: itemtype => itemtype
2291: ,itemkey => itemkey
2292: ,aname => 'UPDATE_GEN_STATUS'
2293: ,avalue => l_update_status

Line 2326: l_claim_id := wf_engine.getitemattrnumber(

2322: --, security_group_id => l_security_group_id
2323: );
2324: END IF;
2325:
2326: l_claim_id := wf_engine.getitemattrnumber(
2327: itemtype => itemtype
2328: ,itemkey => itemkey
2329: ,aname => 'AMS_ACTIVITY_ID'
2330: );

Line 2332: l_approval_type := wf_engine.GetItemAttrText(

2328: ,itemkey => itemkey
2329: ,aname => 'AMS_ACTIVITY_ID'
2330: );
2331:
2332: l_approval_type := wf_engine.GetItemAttrText(
2333: itemtype => itemtype
2334: ,itemkey => itemkey
2335: ,aname => 'AMS_APPROVAL_TYPE'
2336: );

Line 2338: l_new_status_id := wf_engine.getitemattrnumber(

2334: ,itemkey => itemkey
2335: ,aname => 'AMS_APPROVAL_TYPE'
2336: );
2337:
2338: l_new_status_id := wf_engine.getitemattrnumber(
2339: itemtype => itemtype
2340: ,itemkey => itemkey
2341: ,aname => 'AMS_NEW_STAT_ID'
2342: );

Line 2344: l_orig_status_id := wf_engine.getitemattrnumber(

2340: ,itemkey => itemkey
2341: ,aname => 'AMS_NEW_STAT_ID'
2342: );
2343:
2344: l_orig_status_id := wf_engine.getitemattrnumber(
2345: itemtype => itemtype
2346: ,itemkey => itemkey
2347: ,aname => 'AMS_ORIG_STAT_ID'
2348: );

Line 2350: l_reject_status_id := wf_engine.getitemattrnumber(

2346: ,itemkey => itemkey
2347: ,aname => 'AMS_ORIG_STAT_ID'
2348: );
2349:
2350: l_reject_status_id := wf_engine.getitemattrnumber(
2351: itemtype => itemtype
2352: ,itemkey => itemkey
2353: ,aname => 'AMS_REJECT_STAT_ID'
2354: );

Line 2445: l_approved_amount := wf_engine.getitemattrnumber(

2441: END IF;
2442:
2443:
2444:
2445: l_approved_amount := wf_engine.getitemattrnumber(
2446: itemtype => itemtype
2447: ,itemkey => itemkey
2448: ,aname => 'AMS_AMOUNT'
2449: );

Line 2451: l_object_version_number := wf_engine.getitemattrnumber(

2447: ,itemkey => itemkey
2448: ,aname => 'AMS_AMOUNT'
2449: );
2450:
2451: l_object_version_number := wf_engine.getitemattrnumber(
2452: itemtype => itemtype
2453: ,itemkey => itemkey
2454: ,aname => 'AMS_OBJECT_VERSION_NUMBER'
2455: );

Line 2464: l_approver_id :=wf_engine.getitemattrnumber(

2460:
2461: -- set org_context since workflow mailer does not set the context
2462: set_org_ctx (l_org_id);
2463:
2464: l_approver_id :=wf_engine.getitemattrnumber(
2465: itemtype => itemtype
2466: ,itemkey => itemkey
2467: ,aname => 'AMS_APPROVER_ID'
2468: );

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

2503: );
2504: resultout := 'COMPLETE:ERROR';
2505: --999
2506: --Set performer of the next notification to original claim approver.
2507: l_approver_role_name := WF_ENGINE.GetItemAttrText(itemtype => itemtype
2508: ,itemkey => itemkey
2509: ,aname => 'AMS_APPROVER'
2510: );
2511:

Line 2512: WF_ENGINE.AssignActivity(itemtype => itemtype

2508: ,itemkey => itemkey
2509: ,aname => 'AMS_APPROVER'
2510: );
2511:
2512: WF_ENGINE.AssignActivity(itemtype => itemtype
2513: ,itemkey => itemkey
2514: ,activity => 'AMSGAPP:AMS_NTF_ERROR_REQUEST'
2515: ,performer => l_approver_role_name
2516: );

Line 2520: WF_ENGINE.AssignActivity(itemtype => itemtype

2516: );
2517:
2518:
2519: /*
2520: WF_ENGINE.AssignActivity(itemtype => itemtype
2521: ,itemkey => itemkey
2522: ,activity => 'AMSGAPP:AMS_NTF_ERROR_REQUEST'
2523: ,performer => 'AMS_APPROVER'
2524: );