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 1320: wf_engine.getitemattrtext(

1316: l_hyphen_pos1 := INSTR(document_id, ':');
1317: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1318: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1319: l_activity_type :=
1320: wf_engine.getitemattrtext(
1321: itemtype => l_item_type
1322: ,itemkey => l_item_key
1323: ,aname => 'AMS_ACTIVITY_TYPE');
1324: l_act_budget_id :=

Line 1325: wf_engine.getitemattrnumber(

1321: itemtype => l_item_type
1322: ,itemkey => l_item_key
1323: ,aname => 'AMS_ACTIVITY_TYPE');
1324: l_act_budget_id :=
1325: wf_engine.getitemattrnumber(
1326: itemtype => l_item_type
1327: ,itemkey => l_item_key
1328: ,aname => 'AMS_ACTIVITY_ID');
1329: l_requested_amt :=

Line 1330: wf_engine.getitemattrnumber(

1326: itemtype => l_item_type
1327: ,itemkey => l_item_key
1328: ,aname => 'AMS_ACTIVITY_ID');
1329: l_requested_amt :=
1330: wf_engine.getitemattrnumber(
1331: itemtype => l_item_type
1332: ,itemkey => l_item_key
1333: ,aname => 'AMS_REQUESTED_AMOUNT');
1334: l_note := wf_engine.getitemattrtext(

Line 1334: l_note := wf_engine.getitemattrtext(

1330: wf_engine.getitemattrnumber(
1331: itemtype => l_item_type
1332: ,itemkey => l_item_key
1333: ,aname => 'AMS_REQUESTED_AMOUNT');
1334: l_note := wf_engine.getitemattrtext(
1335: itemtype => l_item_type
1336: ,itemkey => l_item_key
1337: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1338: l_approver :=

Line 1339: wf_engine.getitemattrtext(

1335: itemtype => l_item_type
1336: ,itemkey => l_item_key
1337: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1338: l_approver :=
1339: wf_engine.getitemattrtext(
1340: itemtype => l_item_type
1341: ,itemkey => l_item_key
1342: ,aname => 'AMS_APPROVER_DISPLAY_NAME');
1343: OPEN c_act_budget_rec(l_act_budget_id);

Line 1353: wf_engine.setitemattrtext(

1349: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1351: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1352: l_string := fnd_message.get;
1353: wf_engine.setitemattrtext(
1354: itemtype => l_item_type
1355: ,itemkey => l_item_key
1356: ,aname => 'FYI_SUBJECT'
1357: ,avalue => l_string);

Line 1377: l_note := wf_engine.getitemattrtext(

1373: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1374: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1375: l_string1 := fnd_message.get;
1376:
1377: l_note := wf_engine.getitemattrtext(
1378: itemtype => l_item_type
1379: ,itemkey => l_item_key
1380: ,aname => 'APPROVAL_NOTE');
1381:

Line 1384: wf_engine.getitemattrtext(

1380: ,aname => 'APPROVAL_NOTE');
1381:
1382: /*
1383: l_forwarder :=
1384: wf_engine.getitemattrtext(
1385: itemtype => l_item_type
1386: ,itemkey => l_item_key
1387: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1388: */

Line 1497: wf_engine.getitemattrtext(

1493: l_hyphen_pos1 := INSTR(document_id, ':');
1494: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1495: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1496: l_activity_type :=
1497: wf_engine.getitemattrtext(
1498: itemtype => l_item_type
1499: ,itemkey => l_item_key
1500: ,aname => 'AMS_ACTIVITY_TYPE');
1501: l_act_budget_id :=

Line 1502: wf_engine.getitemattrnumber(

1498: itemtype => l_item_type
1499: ,itemkey => l_item_key
1500: ,aname => 'AMS_ACTIVITY_TYPE');
1501: l_act_budget_id :=
1502: wf_engine.getitemattrnumber(
1503: itemtype => l_item_type
1504: ,itemkey => l_item_key
1505: ,aname => 'AMS_ACTIVITY_ID');
1506: l_requested_amt :=

Line 1507: wf_engine.getitemattrnumber(

1503: itemtype => l_item_type
1504: ,itemkey => l_item_key
1505: ,aname => 'AMS_ACTIVITY_ID');
1506: l_requested_amt :=
1507: wf_engine.getitemattrnumber(
1508: itemtype => l_item_type
1509: ,itemkey => l_item_key
1510: ,aname => 'AMS_REQUESTED_AMOUNT');
1511: l_approved_amt :=

Line 1512: wf_engine.getitemattrnumber(

1508: itemtype => l_item_type
1509: ,itemkey => l_item_key
1510: ,aname => 'AMS_REQUESTED_AMOUNT');
1511: l_approved_amt :=
1512: wf_engine.getitemattrnumber(
1513: itemtype => l_item_type
1514: ,itemkey => l_item_key
1515: ,aname => 'AMS_AMOUNT');
1516: l_note := wf_engine.getitemattrtext(

Line 1516: l_note := wf_engine.getitemattrtext(

1512: wf_engine.getitemattrnumber(
1513: itemtype => l_item_type
1514: ,itemkey => l_item_key
1515: ,aname => 'AMS_AMOUNT');
1516: l_note := wf_engine.getitemattrtext(
1517: itemtype => l_item_type
1518: ,itemkey => l_item_key
1519: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1520: l_approver :=

Line 1521: wf_engine.getitemattrtext(

1517: itemtype => l_item_type
1518: ,itemkey => l_item_key
1519: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1520: l_approver :=
1521: wf_engine.getitemattrtext(
1522: itemtype => l_item_type
1523: ,itemkey => l_item_key
1524: ,aname => 'AMS_APPROVER');
1525:

Line 1528: wf_engine.getitemattrtext (

1524: ,aname => 'AMS_APPROVER');
1525:
1526: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */
1527: l_approver_note :=
1528: wf_engine.getitemattrtext (
1529: itemtype=> l_item_type,
1530: itemkey=> l_item_key,
1531: aname => 'APPROVAL_NOTE'
1532: );

Line 1545: wf_engine.setitemattrtext(

1541: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1542: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1543: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1544: l_string := fnd_message.get;
1545: wf_engine.setitemattrtext(
1546: itemtype => l_item_type
1547: ,itemkey => l_item_key
1548: ,aname => 'APRV_SUBJECT'
1549: ,avalue => l_string);

Line 1579: l_note := wf_engine.getitemattrtext(

1575: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */
1576: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
1577: l_string2 := fnd_message.get;
1578: /*
1579: l_note := wf_engine.getitemattrtext(
1580: itemtype => l_item_type
1581: ,itemkey => l_item_key
1582: ,aname => 'NOTE');
1583:

Line 1586: wf_engine.getitemattrtext(

1582: ,aname => 'NOTE');
1583:
1584:
1585: l_forwarder :=
1586: wf_engine.getitemattrtext(
1587: itemtype => l_item_type
1588: ,itemkey => l_item_key
1589: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1590: */

Line 1699: wf_engine.getitemattrtext(

1695: l_hyphen_pos1 := INSTR(document_id, ':');
1696: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1697: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1698: l_activity_type :=
1699: wf_engine.getitemattrtext(
1700: itemtype => l_item_type
1701: ,itemkey => l_item_key
1702: ,aname => 'AMS_ACTIVITY_TYPE');
1703: l_act_budget_id :=

Line 1704: wf_engine.getitemattrnumber(

1700: itemtype => l_item_type
1701: ,itemkey => l_item_key
1702: ,aname => 'AMS_ACTIVITY_TYPE');
1703: l_act_budget_id :=
1704: wf_engine.getitemattrnumber(
1705: itemtype => l_item_type
1706: ,itemkey => l_item_key
1707: ,aname => 'AMS_ACTIVITY_ID');
1708: l_requested_amt :=

Line 1709: wf_engine.getitemattrnumber(

1705: itemtype => l_item_type
1706: ,itemkey => l_item_key
1707: ,aname => 'AMS_ACTIVITY_ID');
1708: l_requested_amt :=
1709: wf_engine.getitemattrnumber(
1710: itemtype => l_item_type
1711: ,itemkey => l_item_key
1712: ,aname => 'AMS_REQUESTED_AMOUNT');
1713: l_note := wf_engine.getitemattrtext(

Line 1713: l_note := wf_engine.getitemattrtext(

1709: wf_engine.getitemattrnumber(
1710: itemtype => l_item_type
1711: ,itemkey => l_item_key
1712: ,aname => 'AMS_REQUESTED_AMOUNT');
1713: l_note := wf_engine.getitemattrtext(
1714: itemtype => l_item_type
1715: ,itemkey => l_item_key
1716: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1717: l_approver :=

Line 1718: wf_engine.getitemattrtext(

1714: itemtype => l_item_type
1715: ,itemkey => l_item_key
1716: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1717: l_approver :=
1718: wf_engine.getitemattrtext(
1719: itemtype => l_item_type
1720: ,itemkey => l_item_key
1721: ,aname => 'AMS_APPROVER');
1722: OPEN c_act_budget_rec(l_act_budget_id);

Line 1732: wf_engine.setitemattrtext(

1728: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1730: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1731: l_string := fnd_message.get;
1732: wf_engine.setitemattrtext(
1733: itemtype => l_item_type
1734: ,itemkey => l_item_key
1735: ,aname => 'REJECT_SUBJECT'
1736: ,avalue => l_string);

Line 1757: l_note := wf_engine.getitemattrtext(

1753: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1754: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1755: l_string1 := fnd_message.get;
1756: /*
1757: l_note := wf_engine.getitemattrtext(
1758: itemtype => l_item_type
1759: ,itemkey => l_item_key
1760: ,aname => 'NOTE');
1761:

Line 1764: wf_engine.getitemattrtext(

1760: ,aname => 'NOTE');
1761:
1762:
1763: l_forwarder :=
1764: wf_engine.getitemattrtext(
1765: itemtype => l_item_type
1766: ,itemkey => l_item_key
1767: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1768: */

Line 1772: wf_engine.getitemattrtext (

1768: */
1769:
1770: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
1771: l_note :=
1772: wf_engine.getitemattrtext (
1773: itemtype=> l_item_type,
1774: itemkey=> l_item_key,
1775: aname => 'APPROVAL_NOTE'
1776: );

Line 1889: wf_engine.getitemattrtext(

1885: l_hyphen_pos1 := INSTR(document_id, ':');
1886: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1887: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1888: l_activity_type :=
1889: wf_engine.getitemattrtext(
1890: itemtype => l_item_type
1891: ,itemkey => l_item_key
1892: ,aname => 'AMS_ACTIVITY_TYPE');
1893: l_act_budget_id :=

Line 1894: wf_engine.getitemattrnumber(

1890: itemtype => l_item_type
1891: ,itemkey => l_item_key
1892: ,aname => 'AMS_ACTIVITY_TYPE');
1893: l_act_budget_id :=
1894: wf_engine.getitemattrnumber(
1895: itemtype => l_item_type
1896: ,itemkey => l_item_key
1897: ,aname => 'AMS_ACTIVITY_ID');
1898: l_requested_amt :=

Line 1899: wf_engine.getitemattrnumber(

1895: itemtype => l_item_type
1896: ,itemkey => l_item_key
1897: ,aname => 'AMS_ACTIVITY_ID');
1898: l_requested_amt :=
1899: wf_engine.getitemattrnumber(
1900: itemtype => l_item_type
1901: ,itemkey => l_item_key
1902: ,aname => 'AMS_REQUESTED_AMOUNT');
1903: l_note := wf_engine.getitemattrtext(

Line 1903: l_note := wf_engine.getitemattrtext(

1899: wf_engine.getitemattrnumber(
1900: itemtype => l_item_type
1901: ,itemkey => l_item_key
1902: ,aname => 'AMS_REQUESTED_AMOUNT');
1903: l_note := wf_engine.getitemattrtext(
1904: itemtype => l_item_type
1905: ,itemkey => l_item_key
1906: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1907: l_approver :=

Line 1908: wf_engine.getitemattrtext(

1904: itemtype => l_item_type
1905: ,itemkey => l_item_key
1906: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
1907: l_approver :=
1908: wf_engine.getitemattrtext(
1909: itemtype => l_item_type
1910: ,itemkey => l_item_key
1911: ,aname => 'AMS_APPROVER_DISPLAY_NAME');
1912: OPEN c_act_budget_rec(l_act_budget_id);

Line 1922: wf_engine.setitemattrtext(

1918: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1921: l_string := fnd_message.get;
1922: wf_engine.setitemattrtext(
1923: itemtype => l_item_type
1924: ,itemkey => l_item_key
1925: ,aname => 'APP_SUBJECT'
1926: ,avalue => l_string);

Line 1946: l_note := wf_engine.getitemattrtext(

1942: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1943: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1944: l_string1 := fnd_message.get;
1945: /*
1946: l_note := wf_engine.getitemattrtext(
1947: itemtype => l_item_type
1948: ,itemkey => l_item_key
1949: ,aname => 'NOTE');
1950:

Line 1953: wf_engine.getitemattrtext(

1949: ,aname => 'NOTE');
1950:
1951:
1952: l_forwarder :=
1953: wf_engine.getitemattrtext(
1954: itemtype => l_item_type
1955: ,itemkey => l_item_key
1956: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1957: */

Line 2065: wf_engine.getitemattrtext(

2061: l_hyphen_pos1 := INSTR(document_id, ':');
2062: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
2063: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
2064: l_activity_type :=
2065: wf_engine.getitemattrtext(
2066: itemtype => l_item_type
2067: ,itemkey => l_item_key
2068: ,aname => 'AMS_ACTIVITY_TYPE');
2069: l_act_budget_id :=

Line 2070: wf_engine.getitemattrnumber(

2066: itemtype => l_item_type
2067: ,itemkey => l_item_key
2068: ,aname => 'AMS_ACTIVITY_TYPE');
2069: l_act_budget_id :=
2070: wf_engine.getitemattrnumber(
2071: itemtype => l_item_type
2072: ,itemkey => l_item_key
2073: ,aname => 'AMS_ACTIVITY_ID');
2074: l_requested_amt :=

Line 2075: wf_engine.getitemattrnumber(

2071: itemtype => l_item_type
2072: ,itemkey => l_item_key
2073: ,aname => 'AMS_ACTIVITY_ID');
2074: l_requested_amt :=
2075: wf_engine.getitemattrnumber(
2076: itemtype => l_item_type
2077: ,itemkey => l_item_key
2078: ,aname => 'AMS_REQUESTED_AMOUNT');
2079: l_note := wf_engine.getitemattrtext(

Line 2079: l_note := wf_engine.getitemattrtext(

2075: wf_engine.getitemattrnumber(
2076: itemtype => l_item_type
2077: ,itemkey => l_item_key
2078: ,aname => 'AMS_REQUESTED_AMOUNT');
2079: l_note := wf_engine.getitemattrtext(
2080: itemtype => l_item_type
2081: ,itemkey => l_item_key
2082: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
2083: l_approver :=

Line 2084: wf_engine.getitemattrtext(

2080: itemtype => l_item_type
2081: ,itemkey => l_item_key
2082: ,aname => 'AMS_NOTES_FROM_REQUESTOR');
2083: l_approver :=
2084: wf_engine.getitemattrtext(
2085: itemtype => l_item_type
2086: ,itemkey => l_item_key
2087: ,aname => 'AMS_APPROVER');
2088: OPEN c_act_budget_rec(l_act_budget_id);

Line 2098: wf_engine.setitemattrtext(

2094: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2096: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2097: l_string := fnd_message.get;
2098: wf_engine.setitemattrtext(
2099: itemtype => l_item_type
2100: ,itemkey => l_item_key
2101: ,aname => 'FYI_SUBJECT'
2102: ,avalue => l_string);

Line 2122: l_note := wf_engine.getitemattrtext(

2118: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
2119: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
2120: l_string1 := fnd_message.get;
2121: /*
2122: l_note := wf_engine.getitemattrtext(
2123: itemtype => l_item_type
2124: ,itemkey => l_item_key
2125: ,aname => 'NOTE');
2126:

Line 2129: wf_engine.getitemattrtext(

2125: ,aname => 'NOTE');
2126:
2127:
2128: l_forwarder :=
2129: wf_engine.getitemattrtext(
2130: itemtype => l_item_type
2131: ,itemkey => l_item_key
2132: ,aname => 'AMS_FORWARD_FROM_USERNAME');
2133: */

Line 2288: wf_engine.getitemattrnumber(

2284:
2285: BEGIN
2286: fnd_msg_pub.initialize;
2287: l_activity_id :=
2288: wf_engine.getitemattrnumber(
2289: itemtype => itemtype
2290: ,itemkey => itemkey
2291: ,aname => 'AMS_ACTIVITY_ID');
2292: l_child_transfer_flag :=

Line 2293: wf_engine.getitemattrtext(

2289: itemtype => itemtype
2290: ,itemkey => itemkey
2291: ,aname => 'AMS_ACTIVITY_ID');
2292: l_child_transfer_flag :=
2293: wf_engine.getitemattrtext(
2294: itemtype => itemtype
2295: ,itemkey => itemkey
2296: ,aname => 'AMS_GENERIC_FLAG');
2297:

Line 2401: wf_engine.setitemattrnumber(

2397: ,x_approver_seq => l_approver_seq
2398: ,x_return_status => l_return_status);
2399:
2400: IF l_return_status = fnd_api.g_ret_sts_success THEN
2401: wf_engine.setitemattrnumber(
2402: itemtype => itemtype
2403: ,itemkey => itemkey
2404: ,aname => 'AMS_APPROVAL_DETAIL_ID'
2405: ,avalue => l_approval_detail_id);

Line 2406: wf_engine.setitemattrnumber(

2402: itemtype => itemtype
2403: ,itemkey => itemkey
2404: ,aname => 'AMS_APPROVAL_DETAIL_ID'
2405: ,avalue => l_approval_detail_id);
2406: wf_engine.setitemattrnumber(
2407: itemtype => itemtype
2408: ,itemkey => itemkey
2409: ,aname => 'AMS_APPROVER_SEQ'
2410: ,avalue => l_approver_seq);

Line 2411: wf_engine.setitemattrnumber(

2407: itemtype => itemtype
2408: ,itemkey => itemkey
2409: ,aname => 'AMS_APPROVER_SEQ'
2410: ,avalue => l_approver_seq);
2411: wf_engine.setitemattrnumber(
2412: itemtype => itemtype
2413: ,itemkey => itemkey
2414: ,aname => 'AMS_REQUESTED_AMOUNT'
2415: ,avalue => l_object_details.total_header_amount);

Line 2421: wf_engine.setitemattrtext(

2417: -- yzhao: 01/28/2003 set justfication
2418: OPEN c_get_justification(l_activity_id);
2419: FETCH c_get_justification INTO l_justification;
2420: CLOSE c_get_justification;
2421: wf_engine.setitemattrtext(
2422: itemtype => itemtype
2423: ,itemkey => itemkey
2424: ,aname => 'AMS_NOTES_FROM_REQUESTOR'
2425: ,avalue => l_justification);

Line 2429: wf_engine.getitemattrtext(

2425: ,avalue => l_justification);
2426:
2427: /* set the fyi subject
2428: l_approver :=
2429: wf_engine.getitemattrtext(
2430: itemtype => itemtype
2431: ,itemkey => itemkey
2432: ,aname => 'AMS_APPROVER');
2433: */

Line 2442: wf_engine.setitemattrtext(

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

Line 2456: wf_engine.setitemattrtext(

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

Line 2469: wf_engine.setitemattrtext(

2465: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2466: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2467: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2468: l_string := fnd_message.get;
2469: wf_engine.setitemattrtext(
2470: itemtype => itemtype
2471: ,itemkey => itemkey
2472: ,aname => 'REJECT_SUBJECT'
2473: ,avalue => l_string);

Line 2482: wf_engine.setitemattrtext(

2478: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2479: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2480: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2481: l_string := fnd_message.get;
2482: wf_engine.setitemattrtext(
2483: itemtype => itemtype
2484: ,itemkey => itemkey
2485: ,aname => 'APP_SUBJECT'
2486: ,avalue => l_string);

Line 2489: wf_engine.setitemattrtext (

2485: ,aname => 'APP_SUBJECT'
2486: ,avalue => l_string);
2487: /* mpande added for implementation of BUG#2352621*/
2488: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','FREQ');
2489: wf_engine.setitemattrtext (
2490: itemtype=> itemtype,
2491: itemkey=> itemkey,
2492: aname => 'AMS_APPROVAL_OBJECT_MEANING',
2493: avalue=> l_lookup_meaning

Line 2495: wf_engine.setitemattrtext (

2491: itemkey=> itemkey,
2492: aname => 'AMS_APPROVAL_OBJECT_MEANING',
2493: avalue=> l_lookup_meaning
2494: );
2495: wf_engine.setitemattrtext (
2496: itemtype=> itemtype,
2497: itemkey=> itemkey,
2498: aname => 'AMS_APPROVAL_OBJECT_NAME',
2499: avalue=> l_object_details.name

Line 2741: wf_engine.getitemattrtext(

2737:
2738: BEGIN
2739: IF funcmode = 'RUN' THEN
2740: l_update_status :=
2741: wf_engine.getitemattrtext(
2742: itemtype => itemtype
2743: ,itemkey => itemkey
2744: ,aname => 'UPDATE_GEN_STATUS');
2745: l_approved_amount :=

Line 2746: wf_engine.getitemattrnumber(

2742: itemtype => itemtype
2743: ,itemkey => itemkey
2744: ,aname => 'UPDATE_GEN_STATUS');
2745: l_approved_amount :=
2746: wf_engine.getitemattrnumber(
2747: itemtype => itemtype
2748: ,itemkey => itemkey
2749: ,aname => 'AMS_AMOUNT');
2750: l_approver_id :=

Line 2751: wf_engine.getitemattrnumber(

2747: itemtype => itemtype
2748: ,itemkey => itemkey
2749: ,aname => 'AMS_AMOUNT');
2750: l_approver_id :=
2751: wf_engine.getitemattrnumber(
2752: itemtype => itemtype
2753: ,itemkey => itemkey
2754: ,aname => 'AMS_APPROVER_ID');
2755: l_requester_id :=

Line 2756: wf_engine.getitemattrnumber(

2752: itemtype => itemtype
2753: ,itemkey => itemkey
2754: ,aname => 'AMS_APPROVER_ID');
2755: l_requester_id :=
2756: wf_engine.getitemattrnumber(
2757: itemtype => itemtype
2758: ,itemkey => itemkey
2759: ,aname => 'AMS_REQUESTER_ID');
2760:

Line 2763: wf_engine.getitemattrnumber(

2759: ,aname => 'AMS_REQUESTER_ID');
2760:
2761: IF l_update_status = 'APPROVED' THEN
2762: l_next_status_id :=
2763: wf_engine.getitemattrnumber(
2764: itemtype => itemtype
2765: ,itemkey => itemkey
2766: ,aname => 'AMS_NEW_STAT_ID');
2767:

Line 2773: wf_engine.getitemattrtext (

2769: if auto approval amount > request amount, then final approval amount := request amount
2770: else final approval amount := auto approval amount
2771: */
2772: l_approver :=
2773: wf_engine.getitemattrtext (
2774: itemtype=> itemtype,
2775: itemkey=> itemkey,
2776: aname => 'AMS_APPROVER'
2777: );

Line 2779: wf_engine.getitemattrnumber (

2775: itemkey=> itemkey,
2776: aname => 'AMS_APPROVER'
2777: );
2778: l_requested_amt :=
2779: wf_engine.getitemattrnumber (
2780: itemtype=> itemtype,
2781: itemkey=> itemkey,
2782: aname => 'AMS_REQUESTED_AMOUNT'
2783: );

Line 2809: wf_engine.setitemattrnumber (

2805: l_approved_amount := l_number_value;
2806: END IF;
2807:
2808: -- set approval amount to workflow so notificaiton gets the correct amount
2809: wf_engine.setitemattrnumber (
2810: itemtype=> itemtype,
2811: itemkey=> itemkey,
2812: aname => 'AMS_AMOUNT',
2813: avalue=> l_approved_amount

Line 2821: wf_engine.getitemattrnumber (

2817:
2818: -- mpande 6/11/2002 bug#2352621
2819: ELSIF l_update_status = 'REJECTED' THEN
2820: l_next_status_id :=
2821: wf_engine.getitemattrnumber (
2822: itemtype=> itemtype,
2823: itemkey=> itemkey,
2824: aname => 'AMS_REJECT_STAT_ID'
2825: );

Line 2836: wf_engine.getitemattrtext(

2832: END IF;
2833:
2834:
2835: l_child_transfer_flag :=
2836: wf_engine.getitemattrtext(
2837: itemtype => itemtype
2838: ,itemkey => itemkey
2839: ,aname => 'AMS_GENERIC_FLAG');
2840:

Line 2841: l_note := wf_engine.getitemattrtext(

2837: itemtype => itemtype
2838: ,itemkey => itemkey
2839: ,aname => 'AMS_GENERIC_FLAG');
2840:
2841: l_note := wf_engine.getitemattrtext(
2842: itemtype => itemtype
2843: ,itemkey => itemkey
2844: ,aname => 'APPROVAL_NOTE');
2845:

Line 2847: wf_engine.getitemattrnumber(

2843: ,itemkey => itemkey
2844: ,aname => 'APPROVAL_NOTE');
2845:
2846: l_object_version_number :=
2847: wf_engine.getitemattrnumber(
2848: itemtype => itemtype
2849: ,itemkey => itemkey
2850: ,aname => 'AMS_OBJECT_VERSION_NUMBER');
2851: l_act_budget_id :=

Line 2852: wf_engine.getitemattrnumber(

2848: itemtype => itemtype
2849: ,itemkey => itemkey
2850: ,aname => 'AMS_OBJECT_VERSION_NUMBER');
2851: l_act_budget_id :=
2852: wf_engine.getitemattrnumber(
2853: itemtype => itemtype
2854: ,itemkey => itemkey
2855: ,aname => 'AMS_ACTIVITY_ID');
2856: OPEN c_act_budget_rec(l_act_budget_id);