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_FUND_REQUEST_APR_PVT dependencies on WF_ENGINE

Line 1299: wf_engine.getitemattrtext(

1295: l_hyphen_pos1 := INSTR(document_id, ':');
1296: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1297: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1298: l_activity_type :=
1299: wf_engine.getitemattrtext(
1300: itemtype => l_item_type
1301: ,itemkey => l_item_key
1302: ,aname => 'AMS_ACTIVITY_TYPE');
1303: l_act_budget_id :=

Line 1304: wf_engine.getitemattrnumber(

1300: itemtype => l_item_type
1301: ,itemkey => l_item_key
1302: ,aname => 'AMS_ACTIVITY_TYPE');
1303: l_act_budget_id :=
1304: wf_engine.getitemattrnumber(
1305: itemtype => l_item_type
1306: ,itemkey => l_item_key
1307: ,aname => 'AMS_ACTIVITY_ID');
1308: l_requested_amt :=

Line 1309: wf_engine.getitemattrnumber(

1305: itemtype => l_item_type
1306: ,itemkey => l_item_key
1307: ,aname => 'AMS_ACTIVITY_ID');
1308: l_requested_amt :=
1309: wf_engine.getitemattrnumber(
1310: itemtype => l_item_type
1311: ,itemkey => l_item_key
1312: ,aname => 'AMS_REQUESTED_AMOUNT');
1313: l_note := wf_engine.getitemattrtext(

Line 1313: l_note := wf_engine.getitemattrtext(

1309: wf_engine.getitemattrnumber(
1310: itemtype => l_item_type
1311: ,itemkey => l_item_key
1312: ,aname => 'AMS_REQUESTED_AMOUNT');
1313: l_note := wf_engine.getitemattrtext(
1314: itemtype => l_item_type
1315: ,itemkey => l_item_key
1316: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1317: l_approver :=

Line 1318: wf_engine.getitemattrtext(

1314: itemtype => l_item_type
1315: ,itemkey => l_item_key
1316: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1317: l_approver :=
1318: wf_engine.getitemattrtext(
1319: itemtype => l_item_type
1320: ,itemkey => l_item_key
1321: ,aname => 'AMS_APPROVER_DISPLAY_NAME');
1322: OPEN c_act_budget_rec(l_act_budget_id);

Line 1332: wf_engine.setitemattrtext(

1328: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1329: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1330: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1331: l_string := fnd_message.get;
1332: wf_engine.setitemattrtext(
1333: itemtype => l_item_type
1334: ,itemkey => l_item_key
1335: ,aname => 'FYI_SUBJECT'
1336: ,avalue => l_string);

Line 1356: l_note := wf_engine.getitemattrtext(

1352: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1353: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1354: l_string1 := fnd_message.get;
1355:
1356: l_note := wf_engine.getitemattrtext(
1357: itemtype => l_item_type
1358: ,itemkey => l_item_key
1359: ,aname => 'APPROVAL_NOTE');
1360:

Line 1363: wf_engine.getitemattrtext(

1359: ,aname => 'APPROVAL_NOTE');
1360:
1361: /*
1362: l_forwarder :=
1363: wf_engine.getitemattrtext(
1364: itemtype => l_item_type
1365: ,itemkey => l_item_key
1366: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1367: */

Line 1476: wf_engine.getitemattrtext(

1472: l_hyphen_pos1 := INSTR(document_id, ':');
1473: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1474: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1475: l_activity_type :=
1476: wf_engine.getitemattrtext(
1477: itemtype => l_item_type
1478: ,itemkey => l_item_key
1479: ,aname => 'AMS_ACTIVITY_TYPE');
1480: l_act_budget_id :=

Line 1481: wf_engine.getitemattrnumber(

1477: itemtype => l_item_type
1478: ,itemkey => l_item_key
1479: ,aname => 'AMS_ACTIVITY_TYPE');
1480: l_act_budget_id :=
1481: wf_engine.getitemattrnumber(
1482: itemtype => l_item_type
1483: ,itemkey => l_item_key
1484: ,aname => 'AMS_ACTIVITY_ID');
1485: l_requested_amt :=

Line 1486: wf_engine.getitemattrnumber(

1482: itemtype => l_item_type
1483: ,itemkey => l_item_key
1484: ,aname => 'AMS_ACTIVITY_ID');
1485: l_requested_amt :=
1486: wf_engine.getitemattrnumber(
1487: itemtype => l_item_type
1488: ,itemkey => l_item_key
1489: ,aname => 'AMS_REQUESTED_AMOUNT');
1490: l_approved_amt :=

Line 1491: wf_engine.getitemattrnumber(

1487: itemtype => l_item_type
1488: ,itemkey => l_item_key
1489: ,aname => 'AMS_REQUESTED_AMOUNT');
1490: l_approved_amt :=
1491: wf_engine.getitemattrnumber(
1492: itemtype => l_item_type
1493: ,itemkey => l_item_key
1494: ,aname => 'AMS_AMOUNT');
1495: l_note := wf_engine.getitemattrtext(

Line 1495: l_note := wf_engine.getitemattrtext(

1491: wf_engine.getitemattrnumber(
1492: itemtype => l_item_type
1493: ,itemkey => l_item_key
1494: ,aname => 'AMS_AMOUNT');
1495: l_note := wf_engine.getitemattrtext(
1496: itemtype => l_item_type
1497: ,itemkey => l_item_key
1498: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1499: l_approver :=

Line 1500: wf_engine.getitemattrtext(

1496: itemtype => l_item_type
1497: ,itemkey => l_item_key
1498: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1499: l_approver :=
1500: wf_engine.getitemattrtext(
1501: itemtype => l_item_type
1502: ,itemkey => l_item_key
1503: ,aname => 'AMS_APPROVER');
1504:

Line 1507: wf_engine.getitemattrtext (

1503: ,aname => 'AMS_APPROVER');
1504:
1505: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */
1506: l_approver_note :=
1507: wf_engine.getitemattrtext (
1508: itemtype=> l_item_type,
1509: itemkey=> l_item_key,
1510: aname => 'APPROVAL_NOTE'
1511: );

Line 1524: wf_engine.setitemattrtext(

1520: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1521: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1522: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1523: l_string := fnd_message.get;
1524: wf_engine.setitemattrtext(
1525: itemtype => l_item_type
1526: ,itemkey => l_item_key
1527: ,aname => 'APRV_SUBJECT'
1528: ,avalue => l_string);

Line 1558: l_note := wf_engine.getitemattrtext(

1554: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */
1555: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
1556: l_string2 := fnd_message.get;
1557: /*
1558: l_note := wf_engine.getitemattrtext(
1559: itemtype => l_item_type
1560: ,itemkey => l_item_key
1561: ,aname => 'NOTE');
1562:

Line 1565: wf_engine.getitemattrtext(

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

Line 1678: wf_engine.getitemattrtext(

1674: l_hyphen_pos1 := INSTR(document_id, ':');
1675: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1676: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1677: l_activity_type :=
1678: wf_engine.getitemattrtext(
1679: itemtype => l_item_type
1680: ,itemkey => l_item_key
1681: ,aname => 'AMS_ACTIVITY_TYPE');
1682: l_act_budget_id :=

Line 1683: wf_engine.getitemattrnumber(

1679: itemtype => l_item_type
1680: ,itemkey => l_item_key
1681: ,aname => 'AMS_ACTIVITY_TYPE');
1682: l_act_budget_id :=
1683: wf_engine.getitemattrnumber(
1684: itemtype => l_item_type
1685: ,itemkey => l_item_key
1686: ,aname => 'AMS_ACTIVITY_ID');
1687: l_requested_amt :=

Line 1688: wf_engine.getitemattrnumber(

1684: itemtype => l_item_type
1685: ,itemkey => l_item_key
1686: ,aname => 'AMS_ACTIVITY_ID');
1687: l_requested_amt :=
1688: wf_engine.getitemattrnumber(
1689: itemtype => l_item_type
1690: ,itemkey => l_item_key
1691: ,aname => 'AMS_REQUESTED_AMOUNT');
1692: l_note := wf_engine.getitemattrtext(

Line 1692: l_note := wf_engine.getitemattrtext(

1688: wf_engine.getitemattrnumber(
1689: itemtype => l_item_type
1690: ,itemkey => l_item_key
1691: ,aname => 'AMS_REQUESTED_AMOUNT');
1692: l_note := wf_engine.getitemattrtext(
1693: itemtype => l_item_type
1694: ,itemkey => l_item_key
1695: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1696: l_approver :=

Line 1697: wf_engine.getitemattrtext(

1693: itemtype => l_item_type
1694: ,itemkey => l_item_key
1695: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1696: l_approver :=
1697: wf_engine.getitemattrtext(
1698: itemtype => l_item_type
1699: ,itemkey => l_item_key
1700: ,aname => 'AMS_APPROVER');
1701: OPEN c_act_budget_rec(l_act_budget_id);

Line 1711: wf_engine.setitemattrtext(

1707: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1708: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1709: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1710: l_string := fnd_message.get;
1711: wf_engine.setitemattrtext(
1712: itemtype => l_item_type
1713: ,itemkey => l_item_key
1714: ,aname => 'REJECT_SUBJECT'
1715: ,avalue => l_string);

Line 1736: l_note := wf_engine.getitemattrtext(

1732: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1733: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1734: l_string1 := fnd_message.get;
1735: /*
1736: l_note := wf_engine.getitemattrtext(
1737: itemtype => l_item_type
1738: ,itemkey => l_item_key
1739: ,aname => 'NOTE');
1740:

Line 1743: wf_engine.getitemattrtext(

1739: ,aname => 'NOTE');
1740:
1741:
1742: l_forwarder :=
1743: wf_engine.getitemattrtext(
1744: itemtype => l_item_type
1745: ,itemkey => l_item_key
1746: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1747: */

Line 1751: wf_engine.getitemattrtext (

1747: */
1748:
1749: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
1750: l_note :=
1751: wf_engine.getitemattrtext (
1752: itemtype=> l_item_type,
1753: itemkey=> l_item_key,
1754: aname => 'APPROVAL_NOTE'
1755: );

Line 1868: wf_engine.getitemattrtext(

1864: l_hyphen_pos1 := INSTR(document_id, ':');
1865: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1866: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1867: l_activity_type :=
1868: wf_engine.getitemattrtext(
1869: itemtype => l_item_type
1870: ,itemkey => l_item_key
1871: ,aname => 'AMS_ACTIVITY_TYPE');
1872: l_act_budget_id :=

Line 1873: wf_engine.getitemattrnumber(

1869: itemtype => l_item_type
1870: ,itemkey => l_item_key
1871: ,aname => 'AMS_ACTIVITY_TYPE');
1872: l_act_budget_id :=
1873: wf_engine.getitemattrnumber(
1874: itemtype => l_item_type
1875: ,itemkey => l_item_key
1876: ,aname => 'AMS_ACTIVITY_ID');
1877: l_requested_amt :=

Line 1878: wf_engine.getitemattrnumber(

1874: itemtype => l_item_type
1875: ,itemkey => l_item_key
1876: ,aname => 'AMS_ACTIVITY_ID');
1877: l_requested_amt :=
1878: wf_engine.getitemattrnumber(
1879: itemtype => l_item_type
1880: ,itemkey => l_item_key
1881: ,aname => 'AMS_REQUESTED_AMOUNT');
1882: l_note := wf_engine.getitemattrtext(

Line 1882: l_note := wf_engine.getitemattrtext(

1878: wf_engine.getitemattrnumber(
1879: itemtype => l_item_type
1880: ,itemkey => l_item_key
1881: ,aname => 'AMS_REQUESTED_AMOUNT');
1882: l_note := wf_engine.getitemattrtext(
1883: itemtype => l_item_type
1884: ,itemkey => l_item_key
1885: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1886: l_approver :=

Line 1887: wf_engine.getitemattrtext(

1883: itemtype => l_item_type
1884: ,itemkey => l_item_key
1885: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1886: l_approver :=
1887: wf_engine.getitemattrtext(
1888: itemtype => l_item_type
1889: ,itemkey => l_item_key
1890: ,aname => 'AMS_APPROVER_DISPLAY_NAME');
1891: OPEN c_act_budget_rec(l_act_budget_id);

Line 1901: wf_engine.setitemattrtext(

1897: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1898: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1900: l_string := fnd_message.get;
1901: wf_engine.setitemattrtext(
1902: itemtype => l_item_type
1903: ,itemkey => l_item_key
1904: ,aname => 'APP_SUBJECT'
1905: ,avalue => l_string);

Line 1925: l_note := wf_engine.getitemattrtext(

1921: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1922: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1923: l_string1 := fnd_message.get;
1924: /*
1925: l_note := wf_engine.getitemattrtext(
1926: itemtype => l_item_type
1927: ,itemkey => l_item_key
1928: ,aname => 'NOTE');
1929:

Line 1932: wf_engine.getitemattrtext(

1928: ,aname => 'NOTE');
1929:
1930:
1931: l_forwarder :=
1932: wf_engine.getitemattrtext(
1933: itemtype => l_item_type
1934: ,itemkey => l_item_key
1935: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1936: */

Line 2044: wf_engine.getitemattrtext(

2040: l_hyphen_pos1 := INSTR(document_id, ':');
2041: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
2042: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
2043: l_activity_type :=
2044: wf_engine.getitemattrtext(
2045: itemtype => l_item_type
2046: ,itemkey => l_item_key
2047: ,aname => 'AMS_ACTIVITY_TYPE');
2048: l_act_budget_id :=

Line 2049: wf_engine.getitemattrnumber(

2045: itemtype => l_item_type
2046: ,itemkey => l_item_key
2047: ,aname => 'AMS_ACTIVITY_TYPE');
2048: l_act_budget_id :=
2049: wf_engine.getitemattrnumber(
2050: itemtype => l_item_type
2051: ,itemkey => l_item_key
2052: ,aname => 'AMS_ACTIVITY_ID');
2053: l_requested_amt :=

Line 2054: wf_engine.getitemattrnumber(

2050: itemtype => l_item_type
2051: ,itemkey => l_item_key
2052: ,aname => 'AMS_ACTIVITY_ID');
2053: l_requested_amt :=
2054: wf_engine.getitemattrnumber(
2055: itemtype => l_item_type
2056: ,itemkey => l_item_key
2057: ,aname => 'AMS_REQUESTED_AMOUNT');
2058: l_note := wf_engine.getitemattrtext(

Line 2058: l_note := wf_engine.getitemattrtext(

2054: wf_engine.getitemattrnumber(
2055: itemtype => l_item_type
2056: ,itemkey => l_item_key
2057: ,aname => 'AMS_REQUESTED_AMOUNT');
2058: l_note := wf_engine.getitemattrtext(
2059: itemtype => l_item_type
2060: ,itemkey => l_item_key
2061: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
2062: l_approver :=

Line 2063: wf_engine.getitemattrtext(

2059: itemtype => l_item_type
2060: ,itemkey => l_item_key
2061: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
2062: l_approver :=
2063: wf_engine.getitemattrtext(
2064: itemtype => l_item_type
2065: ,itemkey => l_item_key
2066: ,aname => 'AMS_APPROVER');
2067: OPEN c_act_budget_rec(l_act_budget_id);

Line 2077: wf_engine.setitemattrtext(

2073: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2074: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2075: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2076: l_string := fnd_message.get;
2077: wf_engine.setitemattrtext(
2078: itemtype => l_item_type
2079: ,itemkey => l_item_key
2080: ,aname => 'FYI_SUBJECT'
2081: ,avalue => l_string);

Line 2101: l_note := wf_engine.getitemattrtext(

2097: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
2098: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
2099: l_string1 := fnd_message.get;
2100: /*
2101: l_note := wf_engine.getitemattrtext(
2102: itemtype => l_item_type
2103: ,itemkey => l_item_key
2104: ,aname => 'NOTE');
2105:

Line 2108: wf_engine.getitemattrtext(

2104: ,aname => 'NOTE');
2105:
2106:
2107: l_forwarder :=
2108: wf_engine.getitemattrtext(
2109: itemtype => l_item_type
2110: ,itemkey => l_item_key
2111: ,aname => 'AMS_FORWARD_FROM_USERNAME');
2112: */

Line 2267: wf_engine.getitemattrnumber(

2263:
2264: BEGIN
2265: fnd_msg_pub.initialize;
2266: l_activity_id :=
2267: wf_engine.getitemattrnumber(
2268: itemtype => itemtype
2269: ,itemkey => itemkey
2270: ,aname => 'AMS_ACTIVITY_ID');
2271: l_child_transfer_flag :=

Line 2272: wf_engine.getitemattrtext(

2268: itemtype => itemtype
2269: ,itemkey => itemkey
2270: ,aname => 'AMS_ACTIVITY_ID');
2271: l_child_transfer_flag :=
2272: wf_engine.getitemattrtext(
2273: itemtype => itemtype
2274: ,itemkey => itemkey
2275: ,aname => 'AMS_GENERIC_FLAG');
2276:

Line 2373: wf_engine.setitemattrnumber(

2369: ,x_approver_seq => l_approver_seq
2370: ,x_return_status => l_return_status);
2371:
2372: IF l_return_status = fnd_api.g_ret_sts_success THEN
2373: wf_engine.setitemattrnumber(
2374: itemtype => itemtype
2375: ,itemkey => itemkey
2376: ,aname => 'AMS_APPROVAL_DETAIL_ID'
2377: ,avalue => l_approval_detail_id);

Line 2378: wf_engine.setitemattrnumber(

2374: itemtype => itemtype
2375: ,itemkey => itemkey
2376: ,aname => 'AMS_APPROVAL_DETAIL_ID'
2377: ,avalue => l_approval_detail_id);
2378: wf_engine.setitemattrnumber(
2379: itemtype => itemtype
2380: ,itemkey => itemkey
2381: ,aname => 'AMS_APPROVER_SEQ'
2382: ,avalue => l_approver_seq);

Line 2383: wf_engine.setitemattrnumber(

2379: itemtype => itemtype
2380: ,itemkey => itemkey
2381: ,aname => 'AMS_APPROVER_SEQ'
2382: ,avalue => l_approver_seq);
2383: wf_engine.setitemattrnumber(
2384: itemtype => itemtype
2385: ,itemkey => itemkey
2386: ,aname => 'AMS_REQUESTED_AMOUNT'
2387: ,avalue => l_object_details.total_header_amount);

Line 2393: wf_engine.setitemattrtext(

2389: -- yzhao: 01/28/2003 set justfication
2390: OPEN c_get_justification(l_activity_id);
2391: FETCH c_get_justification INTO l_justification;
2392: CLOSE c_get_justification;
2393: wf_engine.setitemattrtext(
2394: itemtype => itemtype
2395: ,itemkey => itemkey
2396: ,aname => 'AMS_NOTES_FROM_REQUESTOR'
2397: ,avalue => l_justification);

Line 2401: wf_engine.getitemattrtext(

2397: ,avalue => l_justification);
2398:
2399: /* set the fyi subject
2400: l_approver :=
2401: wf_engine.getitemattrtext(
2402: itemtype => itemtype
2403: ,itemkey => itemkey
2404: ,aname => 'AMS_APPROVER');
2405: */

Line 2414: wf_engine.setitemattrtext(

2410: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2411: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2412: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2413: l_string := fnd_message.get;
2414: wf_engine.setitemattrtext(
2415: itemtype => itemtype
2416: ,itemkey => itemkey
2417: ,aname => 'FYI_SUBJECT'
2418: ,avalue => l_string);

Line 2428: wf_engine.setitemattrtext(

2424: -- fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2425: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2426: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2427: l_string := fnd_message.get;
2428: wf_engine.setitemattrtext(
2429: itemtype => itemtype
2430: ,itemkey => itemkey
2431: ,aname => 'APRV_SUBJECT'
2432: ,avalue => l_string);

Line 2441: wf_engine.setitemattrtext(

2437: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2438: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2439: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2440: l_string := fnd_message.get;
2441: wf_engine.setitemattrtext(
2442: itemtype => itemtype
2443: ,itemkey => itemkey
2444: ,aname => 'REJECT_SUBJECT'
2445: ,avalue => l_string);

Line 2454: wf_engine.setitemattrtext(

2450: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2451: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2452: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2453: l_string := fnd_message.get;
2454: wf_engine.setitemattrtext(
2455: itemtype => itemtype
2456: ,itemkey => itemkey
2457: ,aname => 'APP_SUBJECT'
2458: ,avalue => l_string);

Line 2461: wf_engine.setitemattrtext (

2457: ,aname => 'APP_SUBJECT'
2458: ,avalue => l_string);
2459: /* mpande added for implementation of BUG#2352621*/
2460: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','FREQ');
2461: wf_engine.setitemattrtext (
2462: itemtype=> itemtype,
2463: itemkey=> itemkey,
2464: aname => 'AMS_APPROVAL_OBJECT_MEANING',
2465: avalue=> l_lookup_meaning

Line 2467: wf_engine.setitemattrtext (

2463: itemkey=> itemkey,
2464: aname => 'AMS_APPROVAL_OBJECT_MEANING',
2465: avalue=> l_lookup_meaning
2466: );
2467: wf_engine.setitemattrtext (
2468: itemtype=> itemtype,
2469: itemkey=> itemkey,
2470: aname => 'AMS_APPROVAL_OBJECT_NAME',
2471: avalue=> l_object_details.name

Line 2713: wf_engine.getitemattrtext(

2709:
2710: BEGIN
2711: IF funcmode = 'RUN' THEN
2712: l_update_status :=
2713: wf_engine.getitemattrtext(
2714: itemtype => itemtype
2715: ,itemkey => itemkey
2716: ,aname => 'UPDATE_GEN_STATUS');
2717: l_approved_amount :=

Line 2718: wf_engine.getitemattrnumber(

2714: itemtype => itemtype
2715: ,itemkey => itemkey
2716: ,aname => 'UPDATE_GEN_STATUS');
2717: l_approved_amount :=
2718: wf_engine.getitemattrnumber(
2719: itemtype => itemtype
2720: ,itemkey => itemkey
2721: ,aname => 'AMS_AMOUNT');
2722: l_approver_id :=

Line 2723: wf_engine.getitemattrnumber(

2719: itemtype => itemtype
2720: ,itemkey => itemkey
2721: ,aname => 'AMS_AMOUNT');
2722: l_approver_id :=
2723: wf_engine.getitemattrnumber(
2724: itemtype => itemtype
2725: ,itemkey => itemkey
2726: ,aname => 'AMS_APPROVER_ID');
2727: l_requester_id :=

Line 2728: wf_engine.getitemattrnumber(

2724: itemtype => itemtype
2725: ,itemkey => itemkey
2726: ,aname => 'AMS_APPROVER_ID');
2727: l_requester_id :=
2728: wf_engine.getitemattrnumber(
2729: itemtype => itemtype
2730: ,itemkey => itemkey
2731: ,aname => 'AMS_REQUESTER_ID');
2732:

Line 2735: wf_engine.getitemattrnumber(

2731: ,aname => 'AMS_REQUESTER_ID');
2732:
2733: IF l_update_status = 'APPROVED' THEN
2734: l_next_status_id :=
2735: wf_engine.getitemattrnumber(
2736: itemtype => itemtype
2737: ,itemkey => itemkey
2738: ,aname => 'AMS_NEW_STAT_ID');
2739:

Line 2745: wf_engine.getitemattrtext (

2741: if auto approval amount > request amount, then final approval amount := request amount
2742: else final approval amount := auto approval amount
2743: */
2744: l_approver :=
2745: wf_engine.getitemattrtext (
2746: itemtype=> itemtype,
2747: itemkey=> itemkey,
2748: aname => 'AMS_APPROVER'
2749: );

Line 2751: wf_engine.getitemattrnumber (

2747: itemkey=> itemkey,
2748: aname => 'AMS_APPROVER'
2749: );
2750: l_requested_amt :=
2751: wf_engine.getitemattrnumber (
2752: itemtype=> itemtype,
2753: itemkey=> itemkey,
2754: aname => 'AMS_REQUESTED_AMOUNT'
2755: );

Line 2781: wf_engine.setitemattrnumber (

2777: l_approved_amount := l_number_value;
2778: END IF;
2779:
2780: -- set approval amount to workflow so notificaiton gets the correct amount
2781: wf_engine.setitemattrnumber (
2782: itemtype=> itemtype,
2783: itemkey=> itemkey,
2784: aname => 'AMS_AMOUNT',
2785: avalue=> l_approved_amount

Line 2793: wf_engine.getitemattrnumber (

2789:
2790: -- mpande 6/11/2002 bug#2352621
2791: ELSIF l_update_status = 'REJECTED' THEN
2792: l_next_status_id :=
2793: wf_engine.getitemattrnumber (
2794: itemtype=> itemtype,
2795: itemkey=> itemkey,
2796: aname => 'AMS_REJECT_STAT_ID'
2797: );

Line 2808: wf_engine.getitemattrtext(

2804: END IF;
2805:
2806:
2807: l_child_transfer_flag :=
2808: wf_engine.getitemattrtext(
2809: itemtype => itemtype
2810: ,itemkey => itemkey
2811: ,aname => 'AMS_GENERIC_FLAG');
2812:

Line 2813: l_note := wf_engine.getitemattrtext(

2809: itemtype => itemtype
2810: ,itemkey => itemkey
2811: ,aname => 'AMS_GENERIC_FLAG');
2812:
2813: l_note := wf_engine.getitemattrtext(
2814: itemtype => itemtype
2815: ,itemkey => itemkey
2816: ,aname => 'APPROVAL_NOTE');
2817:

Line 2819: wf_engine.getitemattrnumber(

2815: ,itemkey => itemkey
2816: ,aname => 'APPROVAL_NOTE');
2817:
2818: l_object_version_number :=
2819: wf_engine.getitemattrnumber(
2820: itemtype => itemtype
2821: ,itemkey => itemkey
2822: ,aname => 'AMS_OBJECT_VERSION_NUMBER');
2823: l_act_budget_id :=

Line 2824: wf_engine.getitemattrnumber(

2820: itemtype => itemtype
2821: ,itemkey => itemkey
2822: ,aname => 'AMS_OBJECT_VERSION_NUMBER');
2823: l_act_budget_id :=
2824: wf_engine.getitemattrnumber(
2825: itemtype => itemtype
2826: ,itemkey => itemkey
2827: ,aname => 'AMS_ACTIVITY_ID');
2828: OPEN c_act_budget_rec(l_act_budget_id);