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

Line 29: l_item_value := wf_engine.getItemAttrText(itemtype => itemtype

25:
26:
27:
28:
29: l_item_value := wf_engine.getItemAttrText(itemtype => itemtype
30: ,itemkey => itemkey
31: , aname => 'HR_RUNTIME_APPROVAL_REQ_FLAG');
32:
33:

Line 367: WF_ENGINE.setitemattrnumber(p_item_type,

363: (p_item_type => p_item_type
364: ,p_item_key => p_item_key
365: ,p_name => 'OTA_TRANSACTION_STEP_ID');
366:
367: WF_ENGINE.setitemattrnumber(p_item_type,
368: p_item_key,
369: 'OTA_TRANSACTION_STEP_ID',
370: l_transaction_step_id);
371:

Line 379: WF_ENGINE.setitemattrnumber(p_item_type,

375: (p_item_type => p_item_type
376: ,p_item_key => p_item_key
377: ,p_name => 'OTA_EVENT_ID');
378:
379: WF_ENGINE.setitemattrnumber(p_item_type,
380: p_item_key,
381: 'OTA_EVENT_ID',
382: p_eventid);
383:

Line 385: WF_ENGINE.setitemattrtext(p_item_type,

381: 'OTA_EVENT_ID',
382: p_eventid);
383:
384: -- bug 4146681
385: WF_ENGINE.setitemattrtext(p_item_type,
386: p_item_key,
387: 'HR_RESTRICT_EDIT_ATTR',
388: 'Y');
389: --bug 4146681

Line 721: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type

717: ,p_object_version_number => l_trans_obj_vers_nums
718: ,p_rows => l_trans_step_rows);
719: */
720: --added new
721: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
722: ,itemkey => p_item_key
723: ,aname => 'OTA_TRANSACTION_STEP_ID');
724: get_review_data_from_tt(
725: p_transaction_step_id => l_trans_step_id

Line 1270: WF_ENGINE.setitemattrtext(l_item_type,

1266:
1267: l_person_details := OTA_LEARNER_ENROLL_SS.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);
1268:
1269: IF l_person_details.full_name is not null then
1270: WF_ENGINE.setitemattrtext(l_item_type,
1271: l_item_key,
1272: 'CURRENT_PERSON_DISPLAY_NAME',
1273: l_person_details.full_name);
1274: END IF;

Line 1319: WF_ENGINE.setitemattrtext(l_item_type,

1315: End Loop;
1316: end if;
1317:
1318:
1319: WF_ENGINE.setitemattrtext(l_item_type,
1320: l_item_key,
1321: 'OTA_ACTIVITY_VERSION_NAME',
1322: l_version_name);
1323:

Line 1325: WF_ENGINE.setitemattrtext(l_item_type,

1321: 'OTA_ACTIVITY_VERSION_NAME',
1322: l_version_name);
1323:
1324:
1325: WF_ENGINE.setitemattrtext(l_item_type,
1326: l_item_key,
1327: 'EVENT_OWNER_EMAIL',
1328: l_owner_username);
1329:

Line 1331: WF_ENGINE.setitemattrtext(l_item_type,

1327: 'EVENT_OWNER_EMAIL',
1328: l_owner_username);
1329:
1330:
1331: WF_ENGINE.setitemattrtext(l_item_type,
1332: l_item_key,
1333: 'OTA_EVENT_TITLE',
1334: l_eventid); --Enh 5606090: Language support for Event Details.
1335:

Line 1336: WF_ENGINE.setitemattrtext(l_item_type,

1332: l_item_key,
1333: 'OTA_EVENT_TITLE',
1334: l_eventid); --Enh 5606090: Language support for Event Details.
1335:
1336: WF_ENGINE.setitemattrtext(l_item_type,
1337: l_item_key,
1338: 'OTA_COURSE_START_DATE',
1339: l_course_start_date);
1340:

Line 1342: WF_ENGINE.setitemattrtext(l_item_type,

1338: 'OTA_COURSE_START_DATE',
1339: l_course_start_date);
1340:
1341:
1342: WF_ENGINE.setitemattrtext(l_item_type,
1343: l_item_key,
1344: 'OTA_COURSE_END_DATE',
1345: l_course_end_date);
1346:

Line 1347: WF_ENGINE.setitemattrtext(l_item_type,

1343: l_item_key,
1344: 'OTA_COURSE_END_DATE',
1345: l_course_end_date);
1346:
1347: WF_ENGINE.setitemattrtext(l_item_type,
1348: l_item_key,
1349: 'OTA_CLASS_START_TIME',
1350: nvl(l_course_start_time,'00:00'));
1351:

Line 1352: WF_ENGINE.setitemattrtext(l_item_type,

1348: l_item_key,
1349: 'OTA_CLASS_START_TIME',
1350: nvl(l_course_start_time,'00:00'));
1351:
1352: WF_ENGINE.setitemattrtext(l_item_type,
1353: l_item_key,
1354: 'OTA_DELIVERY_MODE_NAME',
1355: l_delivery_mode);
1356:

Line 1357: WF_ENGINE.setitemattrtext(l_item_type,

1353: l_item_key,
1354: 'OTA_DELIVERY_MODE_NAME',
1355: l_delivery_mode);
1356:
1357: WF_ENGINE.setitemattrtext(l_item_type,
1358: l_item_key,
1359: 'OTA_LOCATION_ADDRESS',
1360: l_event_location);
1361:

Line 1362: wf_engine.setItemAttrText(l_item_type,l_item_key,'STATE_LIST',l_timezone);

1358: l_item_key,
1359: 'OTA_LOCATION_ADDRESS',
1360: l_event_location);
1361:
1362: wf_engine.setItemAttrText(l_item_type,l_item_key,'STATE_LIST',l_timezone);
1363:
1364: /* hr_approval_wf.create_item_attrib_if_notexist
1365: (p_item_type => l_item_type
1366: ,p_item_key => l_item_key

Line 1368: wf_engine.setItemAttrText(l_item_type,l_item_key,'PQH_EVENT_NAME',nvl(l_course_end_time,'23:59'));

1364: /* hr_approval_wf.create_item_attrib_if_notexist
1365: (p_item_type => l_item_type
1366: ,p_item_key => l_item_key
1367: ,p_name => 'OTA_CLASS_END_TIME');*/
1368: wf_engine.setItemAttrText(l_item_type,l_item_key,'PQH_EVENT_NAME',nvl(l_course_end_time,'23:59'));
1369:
1370: WF_ENGINE.setitemattrnumber(l_item_type,
1371: l_item_key,
1372: 'TRANSACTION_ID',

Line 1370: WF_ENGINE.setitemattrnumber(l_item_type,

1366: ,p_item_key => l_item_key
1367: ,p_name => 'OTA_CLASS_END_TIME');*/
1368: wf_engine.setItemAttrText(l_item_type,l_item_key,'PQH_EVENT_NAME',nvl(l_course_end_time,'23:59'));
1369:
1370: WF_ENGINE.setitemattrnumber(l_item_type,
1371: l_item_key,
1372: 'TRANSACTION_ID',
1373: --Bug#4617150
1374: -- hr_transaction_web.get_transaction_id

Line 1380: WF_ENGINE.setitemattrnumber(l_item_type,

1376: (p_item_type => l_item_type
1377: ,p_item_key => l_item_key));
1378:
1379:
1380: WF_ENGINE.setitemattrnumber(l_item_type,
1381: l_item_key,
1382: 'FORWARD_FROM_PERSON_ID',
1383: l_delegate_id);
1384:

Line 1406: WF_ENGINE.setitemattrtext(l_item_type,

1402: IF l_booking_status_row.booking_Status_type_id is null then
1403: fnd_message.set_name ('OTA','OTA_13667_WEB_STATUS_NOT_SEEDE');
1404: RAISE status_not_seeded;
1405: ELSE
1406: WF_ENGINE.setitemattrtext(l_item_type,
1407: l_item_key,
1408: 'ENROLL_IN_A_CLASS_STATUS',
1409: l_booking_status_row.name);
1410: END IF ;

Line 1412: WF_ENGINE.setitemattrtext(l_item_type,

1408: 'ENROLL_IN_A_CLASS_STATUS',
1409: l_booking_status_row.name);
1410: END IF ;
1411:
1412: WF_ENGINE.setitemattrtext(l_item_type,
1413: l_item_key,
1414: 'ENROLL_IN_A_CLASS_STATUS',
1415: l_booking_status_row.name);
1416:

Line 1485: WF_ENGINE.setitemattrtext(l_item_type,

1481: (p_item_type => l_item_type
1482: ,p_item_key => l_item_key
1483: ,p_name => 'OTA_AUTO_CREATE_FINANCE');
1484:
1485: WF_ENGINE.setitemattrtext(l_item_type,
1486: l_item_key,
1487: 'OTA_AUTO_CREATE_FINANCE',
1488: l_auto_create_finance);
1489:

Line 1495: WF_ENGINE.setitemattrtext(l_item_type,

1491: (p_item_type => l_item_type
1492: ,p_item_key => l_item_key
1493: ,p_name => 'OTA_SSHR_AUTO_GL_TRANSFER');
1494:
1495: WF_ENGINE.setitemattrtext(l_item_type,
1496: l_item_key,
1497: 'OTA_SSHR_AUTO_GL_TRANSFER',
1498: l_automatic_transfer_gl);
1499:

Line 1505: WF_ENGINE.setitemattrnumber(l_item_type,

1501: (p_item_type => l_item_type
1502: ,p_item_key => l_item_key
1503: ,p_name => 'OTA_USER_ID');
1504:
1505: WF_ENGINE.setitemattrnumber(l_item_type,
1506: l_item_key,
1507: 'OTA_USER_ID',
1508: l_user);
1509:

Line 1511: WF_ENGINE.setitemattrtext(l_item_type,

1507: 'OTA_USER_ID',
1508: l_user);
1509:
1510:
1511: WF_ENGINE.setitemattrtext(l_item_type,
1512: l_item_key,
1513: 'BOOKING_ID',
1514: l_booking_id);
1515:

Line 1529: WF_ENGINE.setitemattrnumber(l_item_type,

1525: (p_item_type => l_item_type
1526: ,p_item_key => l_item_key
1527: ,p_name => 'OTA_EVENT_ID');
1528:
1529: WF_ENGINE.setitemattrnumber(l_item_type,
1530: l_item_key,
1531: 'OTA_EVENT_ID',
1532: l_eventid);
1533:

Line 1540: WF_ENGINE.setitemattrnumber(l_item_type,

1536: ,p_item_key => l_item_key
1537: ,p_name => 'OTA_DELEGATE_PERSON_ID');
1538:
1539:
1540: WF_ENGINE.setitemattrnumber(l_item_type,
1541: l_item_key,
1542: 'OTA_DELEGATE_PERSON_ID',
1543: l_delegate_id);
1544: /* End Set wf item attribute for rejection */

Line 1561: l_auto_create_finance := wf_engine.GetItemAttrtext(itemtype => l_item_type

1557: ,p_name => 'P_DELEGATE_PERSON_ID'));
1558:
1559:
1560:
1561: l_auto_create_finance := wf_engine.GetItemAttrtext(itemtype => l_item_type
1562: ,itemkey => l_item_key
1563: ,aname => 'OTA_AUTO_CREATE_FINANCE');
1564:
1565:

Line 1566: l_automatic_transfer_gl := wf_engine.GetItemAttrtext(itemtype => l_item_type

1562: ,itemkey => l_item_key
1563: ,aname => 'OTA_AUTO_CREATE_FINANCE');
1564:
1565:
1566: l_automatic_transfer_gl := wf_engine.GetItemAttrtext(itemtype => l_item_type
1567: ,itemkey => l_item_key
1568: ,aname => 'OTA_SSHR_AUTO_GL_TRANSFER');
1569:
1570: l_user := wf_engine.GetItemAttrNumber(itemtype => l_item_type

Line 1570: l_user := wf_engine.GetItemAttrNumber(itemtype => l_item_type

1566: l_automatic_transfer_gl := wf_engine.GetItemAttrtext(itemtype => l_item_type
1567: ,itemkey => l_item_key
1568: ,aname => 'OTA_SSHR_AUTO_GL_TRANSFER');
1569:
1570: l_user := wf_engine.GetItemAttrNumber(itemtype => l_item_type
1571: ,itemkey => l_item_key
1572: ,aname => 'OTA_USER_ID');
1573:
1574: OPEN bg_to(l_eventid);

Line 1642: WF_ENGINE.setitemattrtext(l_item_type,

1638: IF l_booking_status_row.booking_Status_type_id is null then
1639: fnd_message.set_name ('OTA','OTA_13667_WEB_STATUS_NOT_SEEDE');
1640: RAISE status_not_seeded;
1641: ELSE
1642: WF_ENGINE.setitemattrtext(l_item_type,
1643: l_item_key,
1644: 'ENROLL_IN_A_CLASS_STATUS',
1645: l_booking_status_row.name);
1646: END IF ;

Line 1648: WF_ENGINE.setitemattrtext(l_item_type,

1644: 'ENROLL_IN_A_CLASS_STATUS',
1645: l_booking_status_row.name);
1646: END IF ;
1647:
1648: WF_ENGINE.setitemattrtext(l_item_type,
1649: l_item_key,
1650: 'ENROLL_IN_A_CLASS_STATUS',
1651: l_booking_status_row.name);
1652:

Line 1708: wf_engine.setItemAttrText (itemtype => l_item_type

1704: p_auto_transfer => l_automatic_transfer_gl);
1705:
1706: IF fapi_result = 'S' THEN
1707:
1708: wf_engine.setItemAttrText (itemtype => l_item_type
1709: ,itemkey => l_item_key
1710: ,aname => 'API_RESULT'
1711: ,avalue => fapi_result);
1712:

Line 1713: wf_engine.setItemAttrText (itemtype => l_item_type

1709: ,itemkey => l_item_key
1710: ,aname => 'API_RESULT'
1711: ,avalue => fapi_result);
1712:
1713: wf_engine.setItemAttrText (itemtype => l_item_type
1714: ,itemkey => l_item_key
1715: ,aname => 'API_FROM'
1716: ,avalue => fapi_from);
1717:

Line 1718: wf_engine.setItemAttrText (itemtype => l_item_type

1714: ,itemkey => l_item_key
1715: ,aname => 'API_FROM'
1716: ,avalue => fapi_from);
1717:
1718: wf_engine.setItemAttrText (itemtype => l_item_type
1719: ,itemkey => l_item_key
1720: ,aname => 'API_TO'
1721: ,avalue => fapi_to);
1722:

Line 1723: wf_engine.setItemAttrNumber(itemtype => l_item_type

1719: ,itemkey => l_item_key
1720: ,aname => 'API_TO'
1721: ,avalue => fapi_to);
1722:
1723: wf_engine.setItemAttrNumber(itemtype => l_item_type
1724: ,itemkey => l_item_key
1725: ,aname => 'EVENT_ID'
1726: ,avalue => l_eventid);
1727:

Line 1728: wf_engine.setItemAttrText (itemtype => l_item_type

1724: ,itemkey => l_item_key
1725: ,aname => 'EVENT_ID'
1726: ,avalue => l_eventid);
1727:
1728: wf_engine.setItemAttrText (itemtype => l_item_type
1729: ,itemkey => l_item_key
1730: ,aname => 'BUSINESS_GROUP_NAME'
1731: ,avalue => l_business_group_name);
1732:

Line 1733: wf_engine.setItemAttrText (itemtype => l_item_type

1729: ,itemkey => l_item_key
1730: ,aname => 'BUSINESS_GROUP_NAME'
1731: ,avalue => l_business_group_name);
1732:
1733: wf_engine.setItemAttrText (itemtype => l_item_type
1734: ,itemkey => l_item_key
1735: ,aname => 'NOTIFICATION_TEXT'
1736: ,avalue => l_notification_text);
1737:

Line 1773: wf_engine.setItemAttrText (itemtype => l_item_type

1769: ELSIF fapi_result = 'E' THEN
1770:
1771: l_notification_text := NULL;
1772:
1773: wf_engine.setItemAttrText (itemtype => l_item_type
1774: ,itemkey => l_item_key
1775: ,aname => 'API_RESULT'
1776: ,avalue => fapi_result);
1777:

Line 1778: wf_engine.setItemAttrText (itemtype => l_item_type

1774: ,itemkey => l_item_key
1775: ,aname => 'API_RESULT'
1776: ,avalue => fapi_result);
1777:
1778: wf_engine.setItemAttrText (itemtype => l_item_type
1779: ,itemkey => l_item_key
1780: ,aname => 'API_FROM'
1781: ,avalue => fapi_from);
1782:

Line 1783: wf_engine.setItemAttrText (itemtype => l_item_type

1779: ,itemkey => l_item_key
1780: ,aname => 'API_FROM'
1781: ,avalue => fapi_from);
1782:
1783: wf_engine.setItemAttrText (itemtype => l_item_type
1784: ,itemkey => l_item_key
1785: ,aname => 'API_TO'
1786: ,avalue => fapi_to);
1787:

Line 1788: wf_engine.setItemAttrNumber(itemtype => l_item_type

1784: ,itemkey => l_item_key
1785: ,aname => 'API_TO'
1786: ,avalue => fapi_to);
1787:
1788: wf_engine.setItemAttrNumber(itemtype => l_item_type
1789: ,itemkey => l_item_key
1790: ,aname => 'EVENT_ID'
1791: ,avalue => l_eventid);
1792:

Line 1793: wf_engine.setItemAttrText (itemtype => l_item_type

1789: ,itemkey => l_item_key
1790: ,aname => 'EVENT_ID'
1791: ,avalue => l_eventid);
1792:
1793: wf_engine.setItemAttrText (itemtype => l_item_type
1794: ,itemkey => l_item_key
1795: ,aname => 'BUSINESS_GROUP_NAME'
1796: ,avalue => l_business_group_name);
1797:

Line 1798: wf_engine.setItemAttrText (itemtype => l_item_type

1794: ,itemkey => l_item_key
1795: ,aname => 'BUSINESS_GROUP_NAME'
1796: ,avalue => l_business_group_name);
1797:
1798: wf_engine.setItemAttrText (itemtype => l_item_type
1799: ,itemkey => l_item_key
1800: ,aname => 'NOTIFICATION_TEXT'
1801: ,avalue => l_notification_text);
1802:

Line 1823: wf_engine.setItemAttrText (itemtype => l_item_type

1819: /*Bug#2215026 Two separate update_enrollment procedure calls included for successful and unsuccessful finance creation.
1820: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id, p_booking_deal_type included.
1821: -- p_update_finance_line parameter changed from 'N' to 'Y'.
1822: */
1823: wf_engine.setItemAttrText (itemtype => l_item_type
1824: ,itemkey => l_item_key
1825: ,aname => 'BOOKING_STATUS_TYPE_ID'
1826: ,avalue => l_booking_status_row.booking_status_type_id);
1827:

Line 1828: WF_ENGINE.setitemattrtext(l_item_type,

1824: ,itemkey => l_item_key
1825: ,aname => 'BOOKING_STATUS_TYPE_ID'
1826: ,avalue => l_booking_status_row.booking_status_type_id);
1827:
1828: WF_ENGINE.setitemattrtext(l_item_type,
1829: l_item_key,
1830: 'BOOKING_ID',
1831: l_booking_id);
1832:

Line 1845: wf_engine.setItemAttrText (itemtype => l_item_type

1841: p_finance_line_id => l_finance_line_id,
1842: p_date_status_changed => l_current_date,
1843: p_date_booking_placed => l_date_booking_placed);
1844:
1845: wf_engine.setItemAttrText (itemtype => l_item_type
1846: ,itemkey => l_item_key
1847: ,aname => 'BOOKING_STATUS_TYPE_ID'
1848: ,avalue => l_booking_status_row.booking_status_type_id);
1849:

Line 1850: WF_ENGINE.setitemattrtext(l_item_type,

1846: ,itemkey => l_item_key
1847: ,aname => 'BOOKING_STATUS_TYPE_ID'
1848: ,avalue => l_booking_status_row.booking_status_type_id);
1849:
1850: WF_ENGINE.setitemattrtext(l_item_type,
1851: l_item_key,
1852: 'BOOKING_ID',
1853: l_booking_id);
1854:

Line 1892: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

1888: l_trans_step_id number;
1889:
1890: begin
1891:
1892: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1893: ,itemkey => itemkey
1894: ,aname => 'OTA_TRANSACTION_STEP_ID');
1895:
1896: if ( funmode = 'RUN' ) then

Line 1949: /* l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

1945:
1946:
1947: begin
1948:
1949: /* l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1950: ,itemkey => itemkey
1951: ,aname => 'OTA_TRANSACTION_STEP_ID');
1952: */
1953:

Line 1963: l_eventid := wf_engine.GetItemAttrNumber(itemtype => itemtype

1959: (p_transaction_step_id => l_transaction_step_id
1960: ,p_name => 'P_EVENTID'));
1961: */
1962:
1963: l_eventid := wf_engine.GetItemAttrNumber(itemtype => itemtype
1964: ,itemkey => itemkey
1965: ,aname => 'OTA_EVENT_ID');
1966:
1967: /* Bug#2258423 hdshah read delegate person id from workflow instead of transaction table

Line 1975: l_delegate_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

1971: -- ,p_name => 'P_PERSON_ID'));
1972: ,p_name => 'P_DELEGATE_PERSON_ID'));
1973: */
1974:
1975: l_delegate_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1976: ,itemkey => itemkey
1977: ,aname => 'OTA_DELEGATE_PERSON_ID');
1978:
1979:

Line 2024: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type

2020:
2021: l_transaction_step_id number;
2022: begin
2023:
2024: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
2025: ,itemkey => p_item_key
2026: ,aname => 'OTA_TRANSACTION_STEP_ID');
2027: process_api2(true,l_transaction_step_id);
2028: p_message := 'S' ;

Line 2107: l_event_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

2103: l_event_id NUMBER;
2104: l_user_name FND_USER.USER_NAME%TYPE;
2105: BEGIN
2106:
2107: l_event_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2108: ,itemkey => itemkey
2109: ,aname => 'OTA_EVENT_ID');
2110:
2111:

Line 2117: wf_engine.setItemAttrText (itemtype => itemtype

2113: FETCH user_name INTO l_user_name;
2114: CLOSE user_name;
2115:
2116:
2117: wf_engine.setItemAttrText (itemtype => itemtype
2118: ,itemkey => itemkey
2119: ,aname => 'EVENT_OWNER_EMAIL'
2120: ,avalue => l_user_name);
2121:

Line 2122: l_api_result := wf_engine.GetItemAttrText(itemtype => itemtype

2118: ,itemkey => itemkey
2119: ,aname => 'EVENT_OWNER_EMAIL'
2120: ,avalue => l_user_name);
2121:
2122: l_api_result := wf_engine.GetItemAttrText(itemtype => itemtype
2123: ,itemkey => itemkey
2124: ,aname => 'API_RESULT');
2125:
2126: l_api_from := wf_engine.GetItemAttrText(itemtype => itemtype

Line 2126: l_api_from := wf_engine.GetItemAttrText(itemtype => itemtype

2122: l_api_result := wf_engine.GetItemAttrText(itemtype => itemtype
2123: ,itemkey => itemkey
2124: ,aname => 'API_RESULT');
2125:
2126: l_api_from := wf_engine.GetItemAttrText(itemtype => itemtype
2127: ,itemkey => itemkey
2128: ,aname => 'API_FROM');
2129:
2130: l_api_to := wf_engine.GetItemAttrText(itemtype => itemtype

Line 2130: l_api_to := wf_engine.GetItemAttrText(itemtype => itemtype

2126: l_api_from := wf_engine.GetItemAttrText(itemtype => itemtype
2127: ,itemkey => itemkey
2128: ,aname => 'API_FROM');
2129:
2130: l_api_to := wf_engine.GetItemAttrText(itemtype => itemtype
2131: ,itemkey => itemkey
2132: ,aname => 'API_TO');
2133:
2134: IF (funcmode='RUN') THEN

Line 2221: --wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );

2217: l_lang_description := ota_general.fnd_lang_desc(l_lang_id);
2218:
2219: --set wf item attributes
2220:
2221: --wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );
2222: wf_engine.setItemAttrText(p_item_type,p_item_key,'STATE_LIST',l_timezone);
2223: --wf_engine.setItemAttrText(p_item_type,p_item_key,'LANGUAGE',l_lang_description );
2224:
2225:

Line 2222: wf_engine.setItemAttrText(p_item_type,p_item_key,'STATE_LIST',l_timezone);

2218:
2219: --set wf item attributes
2220:
2221: --wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );
2222: wf_engine.setItemAttrText(p_item_type,p_item_key,'STATE_LIST',l_timezone);
2223: --wf_engine.setItemAttrText(p_item_type,p_item_key,'LANGUAGE',l_lang_description );
2224:
2225:
2226:

Line 2223: --wf_engine.setItemAttrText(p_item_type,p_item_key,'LANGUAGE',l_lang_description );

2219: --set wf item attributes
2220:
2221: --wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );
2222: wf_engine.setItemAttrText(p_item_type,p_item_key,'STATE_LIST',l_timezone);
2223: --wf_engine.setItemAttrText(p_item_type,p_item_key,'LANGUAGE',l_lang_description );
2224:
2225:
2226:
2227:

Line 2277: l_event_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

2273: l_forward_to_person_id per_people_f.person_id%type;
2274:
2275: BEGIN
2276:
2277: l_event_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2278: ,itemkey => itemkey
2279: ,aname => 'OTA_EVENT_ID');
2280:
2281: /* set_addnl_attributes(p_item_type => itemtype,

Line 2291: l_approval_req_flag := wf_engine.GetItemAttrText(itemtype => itemtype

2287: OPEN user_name(l_event_id);
2288: FETCH user_name INTO l_user_name;
2289: CLOSE user_name;
2290:
2291: l_approval_req_flag := wf_engine.GetItemAttrText(itemtype => itemtype
2292: ,itemkey => itemkey
2293: ,aname => 'HR_RUNTIME_APPROVAL_REQ_FLAG');
2294:
2295: l_booking_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

Line 2295: l_booking_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

2291: l_approval_req_flag := wf_engine.GetItemAttrText(itemtype => itemtype
2292: ,itemkey => itemkey
2293: ,aname => 'HR_RUNTIME_APPROVAL_REQ_FLAG');
2294:
2295: l_booking_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2296: ,itemkey => itemkey
2297: ,aname => 'BOOKING_ID');
2298:
2299: l_notification_text := wf_engine.GetItemAttrText(itemtype => itemtype

Line 2299: l_notification_text := wf_engine.GetItemAttrText(itemtype => itemtype

2295: l_booking_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2296: ,itemkey => itemkey
2297: ,aname => 'BOOKING_ID');
2298:
2299: l_notification_text := wf_engine.GetItemAttrText(itemtype => itemtype
2300: ,itemkey => itemkey
2301: ,aname => 'NOTIFICATION_TEXT');
2302:
2303: IF l_booking_id is not null then

Line 2314: wf_engine.setItemAttrText (itemtype => itemtype

2310: fnd_message.set_name('OTA', 'OTA_443496_WAITLIST_NTF_TEXT');
2311:
2312: l_notification_text := l_notification_text || fnd_message.get();
2313:
2314: wf_engine.setItemAttrText (itemtype => itemtype
2315: ,itemkey => itemkey
2316: ,aname => 'NOTIFICATION_TEXT'
2317: ,avalue => l_notification_text);
2318: End If;

Line 2322: wf_engine.setItemAttrText (itemtype => itemtype

2318: End If;
2319:
2320: END IF;
2321:
2322: wf_engine.setItemAttrText (itemtype => itemtype
2323: ,itemkey => itemkey
2324: ,aname => 'EVENT_OWNER_EMAIL'
2325: ,avalue => l_user_name);
2326:

Line 2328: l_forward_to_person_id := wf_engine.GetItemAttrNumber

2324: ,aname => 'EVENT_OWNER_EMAIL'
2325: ,avalue => l_user_name);
2326:
2327: /*bug# 7346984 starts*/
2328: l_forward_to_person_id := wf_engine.GetItemAttrNumber
2329: (itemtype => itemtype
2330: ,itemkey => itemkey
2331: ,aname =>'FORWARD_TO_PERSON_ID');
2332:

Line 2334: wf_engine.SetItemAttrNumber(itemtype => itemtype

2330: ,itemkey => itemkey
2331: ,aname =>'FORWARD_TO_PERSON_ID');
2332:
2333: if(l_forward_to_person_id is null) then
2334: wf_engine.SetItemAttrNumber(itemtype => itemtype
2335: ,itemkey => itemkey
2336: ,aname => 'FORWARD_TO_PERSON_ID'
2337: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype
2338: ,itemkey => itemkey

Line 2337: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype

2333: if(l_forward_to_person_id is null) then
2334: wf_engine.SetItemAttrNumber(itemtype => itemtype
2335: ,itemkey => itemkey
2336: ,aname => 'FORWARD_TO_PERSON_ID'
2337: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype
2338: ,itemkey => itemkey
2339: ,aname => 'CREATOR_PERSON_ID'));
2340:
2341: wf_engine.SetItemAttrText(itemtype => itemtype

Line 2341: wf_engine.SetItemAttrText(itemtype => itemtype

2337: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype
2338: ,itemkey => itemkey
2339: ,aname => 'CREATOR_PERSON_ID'));
2340:
2341: wf_engine.SetItemAttrText(itemtype => itemtype
2342: ,itemkey => itemkey
2343: ,aname => 'FORWARD_TO_USERNAME'
2344: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
2345: ,itemkey => itemkey

Line 2344: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype

2340:
2341: wf_engine.SetItemAttrText(itemtype => itemtype
2342: ,itemkey => itemkey
2343: ,aname => 'FORWARD_TO_USERNAME'
2344: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
2345: ,itemkey => itemkey
2346: ,aname => 'CREATOR_PERSON_USERNAME'));
2347:
2348: wf_engine.SetItemAttrText(itemtype => itemtype

Line 2348: wf_engine.SetItemAttrText(itemtype => itemtype

2344: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
2345: ,itemkey => itemkey
2346: ,aname => 'CREATOR_PERSON_USERNAME'));
2347:
2348: wf_engine.SetItemAttrText(itemtype => itemtype
2349: ,itemkey => itemkey
2350: ,aname => 'FORWARD_TO_DISPLAY_NAME'
2351: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
2352: ,itemkey => itemkey

Line 2351: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype

2347:
2348: wf_engine.SetItemAttrText(itemtype => itemtype
2349: ,itemkey => itemkey
2350: ,aname => 'FORWARD_TO_DISPLAY_NAME'
2351: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
2352: ,itemkey => itemkey
2353: ,aname => 'CREATOR_PERSON_DISPLAY_NAME'));
2354: end if;
2355: /*bug# 7346984 ends*/

Line 2412: wf_engine.setItemAttrText (itemtype => itemtype

2408: l_forward_to_person_id per_people_f.person_id%type;
2409: BEGIN
2410:
2411: IF (funcmode='RUN') THEN
2412: wf_engine.setItemAttrText (itemtype => itemtype
2413: ,itemkey => itemkey
2414: ,aname => 'APPROVAL_RESULT'
2415: ,avalue => 'ACCEPTED');
2416: resultout:='COMPLETE';

Line 2418: l_forward_to_person_id := wf_engine.GetItemAttrNumber

2414: ,aname => 'APPROVAL_RESULT'
2415: ,avalue => 'ACCEPTED');
2416: resultout:='COMPLETE';
2417: /*bug# 3445970 starts*/
2418: l_forward_to_person_id := wf_engine.GetItemAttrNumber
2419: (itemtype => itemtype
2420: ,itemkey => itemkey
2421: ,aname =>'FORWARD_TO_PERSON_ID');
2422:

Line 2424: wf_engine.SetItemAttrNumber(itemtype => itemtype

2420: ,itemkey => itemkey
2421: ,aname =>'FORWARD_TO_PERSON_ID');
2422:
2423: if(l_forward_to_person_id is null) then
2424: wf_engine.SetItemAttrNumber(itemtype => itemtype
2425: ,itemkey => itemkey
2426: ,aname => 'FORWARD_TO_PERSON_ID'
2427: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype
2428: ,itemkey => itemkey

Line 2427: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype

2423: if(l_forward_to_person_id is null) then
2424: wf_engine.SetItemAttrNumber(itemtype => itemtype
2425: ,itemkey => itemkey
2426: ,aname => 'FORWARD_TO_PERSON_ID'
2427: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype
2428: ,itemkey => itemkey
2429: ,aname => 'CREATOR_PERSON_ID'));
2430:
2431: wf_engine.SetItemAttrText(itemtype => itemtype

Line 2431: wf_engine.SetItemAttrText(itemtype => itemtype

2427: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype
2428: ,itemkey => itemkey
2429: ,aname => 'CREATOR_PERSON_ID'));
2430:
2431: wf_engine.SetItemAttrText(itemtype => itemtype
2432: ,itemkey => itemkey
2433: ,aname => 'FORWARD_TO_USERNAME'
2434: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
2435: ,itemkey => itemkey

Line 2434: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype

2430:
2431: wf_engine.SetItemAttrText(itemtype => itemtype
2432: ,itemkey => itemkey
2433: ,aname => 'FORWARD_TO_USERNAME'
2434: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
2435: ,itemkey => itemkey
2436: ,aname => 'CREATOR_PERSON_USERNAME'));
2437:
2438: wf_engine.SetItemAttrText(itemtype => itemtype

Line 2438: wf_engine.SetItemAttrText(itemtype => itemtype

2434: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
2435: ,itemkey => itemkey
2436: ,aname => 'CREATOR_PERSON_USERNAME'));
2437:
2438: wf_engine.SetItemAttrText(itemtype => itemtype
2439: ,itemkey => itemkey
2440: ,aname => 'FORWARD_TO_DISPLAY_NAME'
2441: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
2442: ,itemkey => itemkey

Line 2441: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype

2437:
2438: wf_engine.SetItemAttrText(itemtype => itemtype
2439: ,itemkey => itemkey
2440: ,aname => 'FORWARD_TO_DISPLAY_NAME'
2441: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
2442: ,itemkey => itemkey
2443: ,aname => 'CREATOR_PERSON_DISPLAY_NAME'));
2444: end if;
2445: /*bug# 3445970 ends*/

Line 2534: l_creator_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

2530: l_creator_person_id number :=null;
2531: l_current_person_id number :=null;
2532: BEGIN
2533:
2534: l_creator_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2535: ,itemkey => itemkey
2536: ,aname => 'CREATOR_PERSON_ID');
2537:
2538: l_current_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

Line 2538: l_current_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

2534: l_creator_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2535: ,itemkey => itemkey
2536: ,aname => 'CREATOR_PERSON_ID');
2537:
2538: l_current_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2539: ,itemkey => itemkey
2540: ,aname => 'CURRENT_PERSON_ID');
2541: if(l_creator_person_id = l_current_person_id) then
2542: l_details := wf_engine.getitemattrtext(itemtype,

Line 2542: l_details := wf_engine.getitemattrtext(itemtype,

2538: l_current_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2539: ,itemkey => itemkey
2540: ,aname => 'CURRENT_PERSON_ID');
2541: if(l_creator_person_id = l_current_person_id) then
2542: l_details := wf_engine.getitemattrtext(itemtype,
2543: itemkey,
2544: 'FYI_NTF_DETAILS',
2545: true);
2546: if l_details = 'Y' then