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 1484: WF_ENGINE.setitemattrtext(l_item_type,

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

Line 1494: WF_ENGINE.setitemattrtext(l_item_type,

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

Line 1504: WF_ENGINE.setitemattrnumber(l_item_type,

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

Line 1510: WF_ENGINE.setitemattrtext(l_item_type,

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

Line 1528: WF_ENGINE.setitemattrnumber(l_item_type,

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

Line 1539: WF_ENGINE.setitemattrnumber(l_item_type,

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

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

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

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

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

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

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

Line 1639: WF_ENGINE.setitemattrtext(l_item_type,

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

Line 1645: WF_ENGINE.setitemattrtext(l_item_type,

1641: 'ENROLL_IN_A_CLASS_STATUS',
1642: l_booking_status_row.name);
1643: END IF ;
1644:
1645: WF_ENGINE.setitemattrtext(l_item_type,
1646: l_item_key,
1647: 'ENROLL_IN_A_CLASS_STATUS',
1648: l_booking_status_row.name);
1649:

Line 1699: wf_engine.setItemAttrText (itemtype => l_item_type

1695: p_auto_transfer => l_automatic_transfer_gl);
1696:
1697: IF fapi_result = 'S' THEN
1698:
1699: wf_engine.setItemAttrText (itemtype => l_item_type
1700: ,itemkey => l_item_key
1701: ,aname => 'API_RESULT'
1702: ,avalue => fapi_result);
1703:

Line 1704: wf_engine.setItemAttrText (itemtype => l_item_type

1700: ,itemkey => l_item_key
1701: ,aname => 'API_RESULT'
1702: ,avalue => fapi_result);
1703:
1704: wf_engine.setItemAttrText (itemtype => l_item_type
1705: ,itemkey => l_item_key
1706: ,aname => 'API_FROM'
1707: ,avalue => fapi_from);
1708:

Line 1709: wf_engine.setItemAttrText (itemtype => l_item_type

1705: ,itemkey => l_item_key
1706: ,aname => 'API_FROM'
1707: ,avalue => fapi_from);
1708:
1709: wf_engine.setItemAttrText (itemtype => l_item_type
1710: ,itemkey => l_item_key
1711: ,aname => 'API_TO'
1712: ,avalue => fapi_to);
1713:

Line 1714: wf_engine.setItemAttrNumber(itemtype => l_item_type

1710: ,itemkey => l_item_key
1711: ,aname => 'API_TO'
1712: ,avalue => fapi_to);
1713:
1714: wf_engine.setItemAttrNumber(itemtype => l_item_type
1715: ,itemkey => l_item_key
1716: ,aname => 'EVENT_ID'
1717: ,avalue => l_eventid);
1718:

Line 1719: wf_engine.setItemAttrText (itemtype => l_item_type

1715: ,itemkey => l_item_key
1716: ,aname => 'EVENT_ID'
1717: ,avalue => l_eventid);
1718:
1719: wf_engine.setItemAttrText (itemtype => l_item_type
1720: ,itemkey => l_item_key
1721: ,aname => 'BUSINESS_GROUP_NAME'
1722: ,avalue => l_business_group_name);
1723:

Line 1724: wf_engine.setItemAttrText (itemtype => l_item_type

1720: ,itemkey => l_item_key
1721: ,aname => 'BUSINESS_GROUP_NAME'
1722: ,avalue => l_business_group_name);
1723:
1724: wf_engine.setItemAttrText (itemtype => l_item_type
1725: ,itemkey => l_item_key
1726: ,aname => 'NOTIFICATION_TEXT'
1727: ,avalue => l_notification_text);
1728:

Line 1764: wf_engine.setItemAttrText (itemtype => l_item_type

1760: ELSIF fapi_result = 'E' THEN
1761:
1762: l_notification_text := NULL;
1763:
1764: wf_engine.setItemAttrText (itemtype => l_item_type
1765: ,itemkey => l_item_key
1766: ,aname => 'API_RESULT'
1767: ,avalue => fapi_result);
1768:

Line 1769: wf_engine.setItemAttrText (itemtype => l_item_type

1765: ,itemkey => l_item_key
1766: ,aname => 'API_RESULT'
1767: ,avalue => fapi_result);
1768:
1769: wf_engine.setItemAttrText (itemtype => l_item_type
1770: ,itemkey => l_item_key
1771: ,aname => 'API_FROM'
1772: ,avalue => fapi_from);
1773:

Line 1774: wf_engine.setItemAttrText (itemtype => l_item_type

1770: ,itemkey => l_item_key
1771: ,aname => 'API_FROM'
1772: ,avalue => fapi_from);
1773:
1774: wf_engine.setItemAttrText (itemtype => l_item_type
1775: ,itemkey => l_item_key
1776: ,aname => 'API_TO'
1777: ,avalue => fapi_to);
1778:

Line 1779: wf_engine.setItemAttrNumber(itemtype => l_item_type

1775: ,itemkey => l_item_key
1776: ,aname => 'API_TO'
1777: ,avalue => fapi_to);
1778:
1779: wf_engine.setItemAttrNumber(itemtype => l_item_type
1780: ,itemkey => l_item_key
1781: ,aname => 'EVENT_ID'
1782: ,avalue => l_eventid);
1783:

Line 1784: wf_engine.setItemAttrText (itemtype => l_item_type

1780: ,itemkey => l_item_key
1781: ,aname => 'EVENT_ID'
1782: ,avalue => l_eventid);
1783:
1784: wf_engine.setItemAttrText (itemtype => l_item_type
1785: ,itemkey => l_item_key
1786: ,aname => 'BUSINESS_GROUP_NAME'
1787: ,avalue => l_business_group_name);
1788:

Line 1789: wf_engine.setItemAttrText (itemtype => l_item_type

1785: ,itemkey => l_item_key
1786: ,aname => 'BUSINESS_GROUP_NAME'
1787: ,avalue => l_business_group_name);
1788:
1789: wf_engine.setItemAttrText (itemtype => l_item_type
1790: ,itemkey => l_item_key
1791: ,aname => 'NOTIFICATION_TEXT'
1792: ,avalue => l_notification_text);
1793:

Line 1814: wf_engine.setItemAttrText (itemtype => l_item_type

1810: /*Bug#2215026 Two separate update_enrollment procedure calls included for successful and unsuccessful finance creation.
1811: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id, p_booking_deal_type included.
1812: -- p_update_finance_line parameter changed from 'N' to 'Y'.
1813: */
1814: wf_engine.setItemAttrText (itemtype => l_item_type
1815: ,itemkey => l_item_key
1816: ,aname => 'BOOKING_STATUS_TYPE_ID'
1817: ,avalue => l_booking_status_row.booking_status_type_id);
1818:

Line 1819: WF_ENGINE.setitemattrtext(l_item_type,

1815: ,itemkey => l_item_key
1816: ,aname => 'BOOKING_STATUS_TYPE_ID'
1817: ,avalue => l_booking_status_row.booking_status_type_id);
1818:
1819: WF_ENGINE.setitemattrtext(l_item_type,
1820: l_item_key,
1821: 'BOOKING_ID',
1822: l_booking_id);
1823:

Line 1836: wf_engine.setItemAttrText (itemtype => l_item_type

1832: p_finance_line_id => l_finance_line_id,
1833: p_date_status_changed => l_current_date,
1834: p_date_booking_placed => l_date_booking_placed);
1835:
1836: wf_engine.setItemAttrText (itemtype => l_item_type
1837: ,itemkey => l_item_key
1838: ,aname => 'BOOKING_STATUS_TYPE_ID'
1839: ,avalue => l_booking_status_row.booking_status_type_id);
1840:

Line 1841: WF_ENGINE.setitemattrtext(l_item_type,

1837: ,itemkey => l_item_key
1838: ,aname => 'BOOKING_STATUS_TYPE_ID'
1839: ,avalue => l_booking_status_row.booking_status_type_id);
1840:
1841: WF_ENGINE.setitemattrtext(l_item_type,
1842: l_item_key,
1843: 'BOOKING_ID',
1844: l_booking_id);
1845:

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

1879: l_trans_step_id number;
1880:
1881: begin
1882:
1883: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1884: ,itemkey => itemkey
1885: ,aname => 'OTA_TRANSACTION_STEP_ID');
1886:
1887: if ( funmode = 'RUN' ) then

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

1936:
1937:
1938: begin
1939:
1940: /* l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1941: ,itemkey => itemkey
1942: ,aname => 'OTA_TRANSACTION_STEP_ID');
1943: */
1944:

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

1950: (p_transaction_step_id => l_transaction_step_id
1951: ,p_name => 'P_EVENTID'));
1952: */
1953:
1954: l_eventid := wf_engine.GetItemAttrNumber(itemtype => itemtype
1955: ,itemkey => itemkey
1956: ,aname => 'OTA_EVENT_ID');
1957:
1958: /* Bug#2258423 hdshah read delegate person id from workflow instead of transaction table

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

1962: -- ,p_name => 'P_PERSON_ID'));
1963: ,p_name => 'P_DELEGATE_PERSON_ID'));
1964: */
1965:
1966: l_delegate_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1967: ,itemkey => itemkey
1968: ,aname => 'OTA_DELEGATE_PERSON_ID');
1969:
1970:

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

2011:
2012: l_transaction_step_id number;
2013: begin
2014:
2015: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
2016: ,itemkey => p_item_key
2017: ,aname => 'OTA_TRANSACTION_STEP_ID');
2018: process_api2(true,l_transaction_step_id);
2019: p_message := 'S' ;

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

2779: l_event_id NUMBER;
2780: l_user_name FND_USER.USER_NAME%TYPE;
2781: BEGIN
2782:
2783: l_event_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2784: ,itemkey => itemkey
2785: ,aname => 'OTA_EVENT_ID');
2786:
2787:

Line 2793: wf_engine.setItemAttrText (itemtype => itemtype

2789: FETCH user_name INTO l_user_name;
2790: CLOSE user_name;
2791:
2792:
2793: wf_engine.setItemAttrText (itemtype => itemtype
2794: ,itemkey => itemkey
2795: ,aname => 'EVENT_OWNER_EMAIL'
2796: ,avalue => l_user_name);
2797:

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

2794: ,itemkey => itemkey
2795: ,aname => 'EVENT_OWNER_EMAIL'
2796: ,avalue => l_user_name);
2797:
2798: l_api_result := wf_engine.GetItemAttrText(itemtype => itemtype
2799: ,itemkey => itemkey
2800: ,aname => 'API_RESULT');
2801:
2802: l_api_from := wf_engine.GetItemAttrText(itemtype => itemtype

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

2798: l_api_result := wf_engine.GetItemAttrText(itemtype => itemtype
2799: ,itemkey => itemkey
2800: ,aname => 'API_RESULT');
2801:
2802: l_api_from := wf_engine.GetItemAttrText(itemtype => itemtype
2803: ,itemkey => itemkey
2804: ,aname => 'API_FROM');
2805:
2806: l_api_to := wf_engine.GetItemAttrText(itemtype => itemtype

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

2802: l_api_from := wf_engine.GetItemAttrText(itemtype => itemtype
2803: ,itemkey => itemkey
2804: ,aname => 'API_FROM');
2805:
2806: l_api_to := wf_engine.GetItemAttrText(itemtype => itemtype
2807: ,itemkey => itemkey
2808: ,aname => 'API_TO');
2809:
2810: IF (funcmode='RUN') THEN

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

2893: l_lang_description := ota_general.fnd_lang_desc(l_lang_id);
2894:
2895: --set wf item attributes
2896:
2897: --wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );
2898: wf_engine.setItemAttrText(p_item_type,p_item_key,'STATE_LIST',l_timezone);
2899: --wf_engine.setItemAttrText(p_item_type,p_item_key,'LANGUAGE',l_lang_description );
2900:
2901:

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

2894:
2895: --set wf item attributes
2896:
2897: --wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );
2898: wf_engine.setItemAttrText(p_item_type,p_item_key,'STATE_LIST',l_timezone);
2899: --wf_engine.setItemAttrText(p_item_type,p_item_key,'LANGUAGE',l_lang_description );
2900:
2901:
2902:

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

2895: --set wf item attributes
2896:
2897: --wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );
2898: wf_engine.setItemAttrText(p_item_type,p_item_key,'STATE_LIST',l_timezone);
2899: --wf_engine.setItemAttrText(p_item_type,p_item_key,'LANGUAGE',l_lang_description );
2900:
2901:
2902:
2903:

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

2949: l_forward_to_person_id per_people_f.person_id%type;
2950:
2951: BEGIN
2952:
2953: l_event_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2954: ,itemkey => itemkey
2955: ,aname => 'OTA_EVENT_ID');
2956:
2957: /* set_addnl_attributes(p_item_type => itemtype,

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

2963: OPEN user_name(l_event_id);
2964: FETCH user_name INTO l_user_name;
2965: CLOSE user_name;
2966:
2967: l_approval_req_flag := wf_engine.GetItemAttrText(itemtype => itemtype
2968: ,itemkey => itemkey
2969: ,aname => 'HR_RUNTIME_APPROVAL_REQ_FLAG');
2970:
2971: l_booking_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

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

2967: l_approval_req_flag := wf_engine.GetItemAttrText(itemtype => itemtype
2968: ,itemkey => itemkey
2969: ,aname => 'HR_RUNTIME_APPROVAL_REQ_FLAG');
2970:
2971: l_booking_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2972: ,itemkey => itemkey
2973: ,aname => 'BOOKING_ID');
2974:
2975: l_notification_text := wf_engine.GetItemAttrText(itemtype => itemtype

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

2971: l_booking_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2972: ,itemkey => itemkey
2973: ,aname => 'BOOKING_ID');
2974:
2975: l_notification_text := wf_engine.GetItemAttrText(itemtype => itemtype
2976: ,itemkey => itemkey
2977: ,aname => 'NOTIFICATION_TEXT');
2978:
2979: IF l_booking_id is not null then

Line 2990: wf_engine.setItemAttrText (itemtype => itemtype

2986: fnd_message.set_name('OTA', 'OTA_443496_WAITLIST_NTF_TEXT');
2987:
2988: l_notification_text := l_notification_text || fnd_message.get();
2989:
2990: wf_engine.setItemAttrText (itemtype => itemtype
2991: ,itemkey => itemkey
2992: ,aname => 'NOTIFICATION_TEXT'
2993: ,avalue => l_notification_text);
2994: End If;

Line 2998: wf_engine.setItemAttrText (itemtype => itemtype

2994: End If;
2995:
2996: END IF;
2997:
2998: wf_engine.setItemAttrText (itemtype => itemtype
2999: ,itemkey => itemkey
3000: ,aname => 'EVENT_OWNER_EMAIL'
3001: ,avalue => l_user_name);
3002:

Line 3004: l_forward_to_person_id := wf_engine.GetItemAttrNumber

3000: ,aname => 'EVENT_OWNER_EMAIL'
3001: ,avalue => l_user_name);
3002:
3003: /*bug# 7346984 starts*/
3004: l_forward_to_person_id := wf_engine.GetItemAttrNumber
3005: (itemtype => itemtype
3006: ,itemkey => itemkey
3007: ,aname =>'FORWARD_TO_PERSON_ID');
3008:

Line 3010: wf_engine.SetItemAttrNumber(itemtype => itemtype

3006: ,itemkey => itemkey
3007: ,aname =>'FORWARD_TO_PERSON_ID');
3008:
3009: if(l_forward_to_person_id is null) then
3010: wf_engine.SetItemAttrNumber(itemtype => itemtype
3011: ,itemkey => itemkey
3012: ,aname => 'FORWARD_TO_PERSON_ID'
3013: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype
3014: ,itemkey => itemkey

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

3009: if(l_forward_to_person_id is null) then
3010: wf_engine.SetItemAttrNumber(itemtype => itemtype
3011: ,itemkey => itemkey
3012: ,aname => 'FORWARD_TO_PERSON_ID'
3013: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype
3014: ,itemkey => itemkey
3015: ,aname => 'CREATOR_PERSON_ID'));
3016:
3017: wf_engine.SetItemAttrText(itemtype => itemtype

Line 3017: wf_engine.SetItemAttrText(itemtype => itemtype

3013: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype
3014: ,itemkey => itemkey
3015: ,aname => 'CREATOR_PERSON_ID'));
3016:
3017: wf_engine.SetItemAttrText(itemtype => itemtype
3018: ,itemkey => itemkey
3019: ,aname => 'FORWARD_TO_USERNAME'
3020: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
3021: ,itemkey => itemkey

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

3016:
3017: wf_engine.SetItemAttrText(itemtype => itemtype
3018: ,itemkey => itemkey
3019: ,aname => 'FORWARD_TO_USERNAME'
3020: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
3021: ,itemkey => itemkey
3022: ,aname => 'CREATOR_PERSON_USERNAME'));
3023:
3024: wf_engine.SetItemAttrText(itemtype => itemtype

Line 3024: wf_engine.SetItemAttrText(itemtype => itemtype

3020: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
3021: ,itemkey => itemkey
3022: ,aname => 'CREATOR_PERSON_USERNAME'));
3023:
3024: wf_engine.SetItemAttrText(itemtype => itemtype
3025: ,itemkey => itemkey
3026: ,aname => 'FORWARD_TO_DISPLAY_NAME'
3027: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
3028: ,itemkey => itemkey

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

3023:
3024: wf_engine.SetItemAttrText(itemtype => itemtype
3025: ,itemkey => itemkey
3026: ,aname => 'FORWARD_TO_DISPLAY_NAME'
3027: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
3028: ,itemkey => itemkey
3029: ,aname => 'CREATOR_PERSON_DISPLAY_NAME'));
3030: end if;
3031: /*bug# 7346984 ends*/

Line 3088: wf_engine.setItemAttrText (itemtype => itemtype

3084: l_forward_to_person_id per_people_f.person_id%type;
3085: BEGIN
3086:
3087: IF (funcmode='RUN') THEN
3088: wf_engine.setItemAttrText (itemtype => itemtype
3089: ,itemkey => itemkey
3090: ,aname => 'APPROVAL_RESULT'
3091: ,avalue => 'ACCEPTED');
3092: resultout:='COMPLETE';

Line 3094: l_forward_to_person_id := wf_engine.GetItemAttrNumber

3090: ,aname => 'APPROVAL_RESULT'
3091: ,avalue => 'ACCEPTED');
3092: resultout:='COMPLETE';
3093: /*bug# 3445970 starts*/
3094: l_forward_to_person_id := wf_engine.GetItemAttrNumber
3095: (itemtype => itemtype
3096: ,itemkey => itemkey
3097: ,aname =>'FORWARD_TO_PERSON_ID');
3098:

Line 3100: wf_engine.SetItemAttrNumber(itemtype => itemtype

3096: ,itemkey => itemkey
3097: ,aname =>'FORWARD_TO_PERSON_ID');
3098:
3099: if(l_forward_to_person_id is null) then
3100: wf_engine.SetItemAttrNumber(itemtype => itemtype
3101: ,itemkey => itemkey
3102: ,aname => 'FORWARD_TO_PERSON_ID'
3103: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype
3104: ,itemkey => itemkey

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

3099: if(l_forward_to_person_id is null) then
3100: wf_engine.SetItemAttrNumber(itemtype => itemtype
3101: ,itemkey => itemkey
3102: ,aname => 'FORWARD_TO_PERSON_ID'
3103: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype
3104: ,itemkey => itemkey
3105: ,aname => 'CREATOR_PERSON_ID'));
3106:
3107: wf_engine.SetItemAttrText(itemtype => itemtype

Line 3107: wf_engine.SetItemAttrText(itemtype => itemtype

3103: ,avalue => wf_engine.GetItemAttrNumber(itemtype => itemtype
3104: ,itemkey => itemkey
3105: ,aname => 'CREATOR_PERSON_ID'));
3106:
3107: wf_engine.SetItemAttrText(itemtype => itemtype
3108: ,itemkey => itemkey
3109: ,aname => 'FORWARD_TO_USERNAME'
3110: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
3111: ,itemkey => itemkey

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

3106:
3107: wf_engine.SetItemAttrText(itemtype => itemtype
3108: ,itemkey => itemkey
3109: ,aname => 'FORWARD_TO_USERNAME'
3110: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
3111: ,itemkey => itemkey
3112: ,aname => 'CREATOR_PERSON_USERNAME'));
3113:
3114: wf_engine.SetItemAttrText(itemtype => itemtype

Line 3114: wf_engine.SetItemAttrText(itemtype => itemtype

3110: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
3111: ,itemkey => itemkey
3112: ,aname => 'CREATOR_PERSON_USERNAME'));
3113:
3114: wf_engine.SetItemAttrText(itemtype => itemtype
3115: ,itemkey => itemkey
3116: ,aname => 'FORWARD_TO_DISPLAY_NAME'
3117: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
3118: ,itemkey => itemkey

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

3113:
3114: wf_engine.SetItemAttrText(itemtype => itemtype
3115: ,itemkey => itemkey
3116: ,aname => 'FORWARD_TO_DISPLAY_NAME'
3117: ,avalue => wf_engine.GetItemAttrText(itemtype => itemtype
3118: ,itemkey => itemkey
3119: ,aname => 'CREATOR_PERSON_DISPLAY_NAME'));
3120: end if;
3121: /*bug# 3445970 ends*/