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

Line 138: l_review_item_name := wf_engine.GetActivityAttrText(itemtype => p_item_type,

134: l_transaction_table(l_count).param_value := p_trndates;
135: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
136:
137:
138: l_review_item_name := wf_engine.GetActivityAttrText(itemtype => p_item_type,
139: itemkey => p_item_key,
140: actid => p_activity_id,
141: aname => gv_wf_review_region_item);
142:

Line 337: l_review_item_name := wf_engine.GetActivityAttrText(itemtype => p_item_type,

333: l_transaction_table(l_count).param_value := p_activity_id;
334: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
335:
336:
337: l_review_item_name := wf_engine.GetActivityAttrText(itemtype => p_item_type,
338: itemkey => p_item_key,
339: actid => p_activity_id,
340: aname => gv_wf_review_region_item);
341:

Line 528: WF_ENGINE.setitemattrnumber(p_item_type,

524: (p_item_type => p_item_type
525: ,p_item_key => p_item_key
526: ,p_name => 'OTA_TRANSACTION_STEP_ID');
527:
528: WF_ENGINE.setitemattrnumber(p_item_type,
529: p_item_key,
530: 'OTA_TRANSACTION_STEP_ID',
531: l_transaction_step_id);
532:

Line 1348: WF_ENGINE.setitemattrtext(l_item_type,

1344:
1345: l_person_details := OTA_EL_ENROLL_SS.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);
1346:
1347: IF l_person_details.full_name is not null then
1348: WF_ENGINE.setitemattrtext(l_item_type,
1349: l_item_key,
1350: 'CURRENT_PERSON_DISPLAY_NAME',
1351: l_person_details.full_name);
1352: END IF;

Line 1393: WF_ENGINE.setitemattrtext(l_item_type,

1389: End Loop;
1390: end if;
1391:
1392:
1393: WF_ENGINE.setitemattrtext(l_item_type,
1394: l_item_key,
1395: 'OTA_ACTIVITY_VERSION_NAME',
1396: l_version_name);
1397:

Line 1399: WF_ENGINE.setitemattrtext(l_item_type,

1395: 'OTA_ACTIVITY_VERSION_NAME',
1396: l_version_name);
1397:
1398:
1399: WF_ENGINE.setitemattrtext(l_item_type,
1400: l_item_key,
1401: 'EVENT_OWNER_EMAIL',
1402: l_owner_username);
1403:

Line 1405: WF_ENGINE.setitemattrtext(l_item_type,

1401: 'EVENT_OWNER_EMAIL',
1402: l_owner_username);
1403:
1404:
1405: WF_ENGINE.setitemattrtext(l_item_type,
1406: l_item_key,
1407: 'OTA_EVENT_TITLE',
1408: l_event_title);
1409:

Line 1410: WF_ENGINE.setitemattrtext(l_item_type,

1406: l_item_key,
1407: 'OTA_EVENT_TITLE',
1408: l_event_title);
1409:
1410: WF_ENGINE.setitemattrtext(l_item_type,
1411: l_item_key,
1412: 'OTA_COURSE_START_DATE',
1413: l_course_start_date);
1414:

Line 1415: WF_ENGINE.setitemattrtext(l_item_type,

1411: l_item_key,
1412: 'OTA_COURSE_START_DATE',
1413: l_course_start_date);
1414:
1415: WF_ENGINE.setitemattrtext(l_item_type,
1416: l_item_key,
1417: 'OTA_COURSE_END_DATE',
1418: l_course_end_date);
1419:

Line 1420: WF_ENGINE.setitemattrnumber(l_item_type,

1416: l_item_key,
1417: 'OTA_COURSE_END_DATE',
1418: l_course_end_date);
1419:
1420: WF_ENGINE.setitemattrnumber(l_item_type,
1421: l_item_key,
1422: 'TRANSACTION_ID',
1423: --Bug#4617150
1424: -- hr_transaction_web.get_transaction_id

Line 1430: WF_ENGINE.setitemattrnumber(l_item_type,

1426: (p_item_type => l_item_type
1427: ,p_item_key => l_item_key));
1428:
1429:
1430: WF_ENGINE.setitemattrnumber(l_item_type,
1431: l_item_key,
1432: 'FORWARD_FROM_PERSON_ID',
1433: l_delegate_id);
1434:

Line 1459: WF_ENGINE.setitemattrtext(l_item_type,

1455: -- Bug#2227738 hdshah change the exception
1456: -- RAISE OTA_ENROLL_CLASS_UTILITY_WEB.g_mesg_on_stack_exception ;
1457: RAISE status_not_seeded;
1458: ELSE
1459: WF_ENGINE.setitemattrtext(l_item_type,
1460: l_item_key,
1461: 'ENROLL_IN_A_CLASS_STATUS',
1462: l_booking_status_row.name);
1463: END IF ;

Line 1465: WF_ENGINE.setitemattrtext(l_item_type,

1461: 'ENROLL_IN_A_CLASS_STATUS',
1462: l_booking_status_row.name);
1463: END IF ;
1464:
1465: WF_ENGINE.setitemattrtext(l_item_type,
1466: l_item_key,
1467: 'ENROLL_IN_A_CLASS_STATUS',
1468: l_booking_status_row.name);
1469:

Line 1535: WF_ENGINE.setitemattrtext(l_item_type,

1531: (p_item_type => l_item_type
1532: ,p_item_key => l_item_key
1533: ,p_name => 'OTA_AUTO_CREATE_FINANCE');
1534:
1535: WF_ENGINE.setitemattrtext(l_item_type,
1536: l_item_key,
1537: 'OTA_AUTO_CREATE_FINANCE',
1538: l_auto_create_finance);
1539:

Line 1545: WF_ENGINE.setitemattrtext(l_item_type,

1541: (p_item_type => l_item_type
1542: ,p_item_key => l_item_key
1543: ,p_name => 'OTA_SSHR_AUTO_GL_TRANSFER');
1544:
1545: WF_ENGINE.setitemattrtext(l_item_type,
1546: l_item_key,
1547: 'OTA_SSHR_AUTO_GL_TRANSFER',
1548: l_automatic_transfer_gl);
1549:

Line 1555: WF_ENGINE.setitemattrnumber(l_item_type,

1551: (p_item_type => l_item_type
1552: ,p_item_key => l_item_key
1553: ,p_name => 'OTA_USER_ID');
1554:
1555: WF_ENGINE.setitemattrnumber(l_item_type,
1556: l_item_key,
1557: 'OTA_USER_ID',
1558: l_user);
1559:

Line 1561: WF_ENGINE.setitemattrtext(l_item_type,

1557: 'OTA_USER_ID',
1558: l_user);
1559:
1560:
1561: WF_ENGINE.setitemattrtext(l_item_type,
1562: l_item_key,
1563: 'BOOKING_ID',
1564: l_booking_id);
1565:

Line 1582: WF_ENGINE.setitemattrnumber(l_item_type,

1578: (p_item_type => l_item_type
1579: ,p_item_key => l_item_key
1580: ,p_name => 'OTA_EVENT_ID');
1581:
1582: WF_ENGINE.setitemattrnumber(l_item_type,
1583: l_item_key,
1584: 'OTA_EVENT_ID',
1585: l_eventid);
1586:

Line 1593: WF_ENGINE.setitemattrnumber(l_item_type,

1589: ,p_item_key => l_item_key
1590: ,p_name => 'OTA_DELEGATE_PERSON_ID');
1591:
1592:
1593: WF_ENGINE.setitemattrnumber(l_item_type,
1594: l_item_key,
1595: 'OTA_DELEGATE_PERSON_ID',
1596: l_delegate_id);
1597: /* End Set wf item attribute for rejecttion */

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

1612: ,p_name => 'P_DELEGATE_PERSON_ID'));
1613:
1614:
1615:
1616: l_auto_create_finance := wf_engine.GetItemAttrtext(itemtype => l_item_type
1617: ,itemkey => l_item_key
1618: ,aname => 'OTA_AUTO_CREATE_FINANCE');
1619:
1620:

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

1617: ,itemkey => l_item_key
1618: ,aname => 'OTA_AUTO_CREATE_FINANCE');
1619:
1620:
1621: l_automatic_transfer_gl := wf_engine.GetItemAttrtext(itemtype => l_item_type
1622: ,itemkey => l_item_key
1623: ,aname => 'OTA_SSHR_AUTO_GL_TRANSFER');
1624:
1625: l_user := wf_engine.GetItemAttrNumber(itemtype => l_item_type

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

1621: l_automatic_transfer_gl := wf_engine.GetItemAttrtext(itemtype => l_item_type
1622: ,itemkey => l_item_key
1623: ,aname => 'OTA_SSHR_AUTO_GL_TRANSFER');
1624:
1625: l_user := wf_engine.GetItemAttrNumber(itemtype => l_item_type
1626: ,itemkey => l_item_key
1627: ,aname => 'OTA_USER_ID');
1628:
1629: OPEN bg_to(l_eventid);

Line 1693: WF_ENGINE.setitemattrtext(l_item_type,

1689: -- Bug#2227738 hdshah change the exception
1690: -- RAISE OTA_ENROLL_CLASS_UTILITY_WEB.g_mesg_on_stack_exception ;
1691: RAISE status_not_seeded;
1692: ELSE
1693: WF_ENGINE.setitemattrtext(l_item_type,
1694: l_item_key,
1695: 'ENROLL_IN_A_CLASS_STATUS',
1696: l_booking_status_row.name);
1697: END IF ;

Line 1699: WF_ENGINE.setitemattrtext(l_item_type,

1695: 'ENROLL_IN_A_CLASS_STATUS',
1696: l_booking_status_row.name);
1697: END IF ;
1698:
1699: WF_ENGINE.setitemattrtext(l_item_type,
1700: l_item_key,
1701: 'ENROLL_IN_A_CLASS_STATUS',
1702: l_booking_status_row.name);
1703:

Line 1759: wf_engine.setItemAttrText (itemtype => l_item_type

1755: p_auto_transfer => l_automatic_transfer_gl);
1756:
1757: IF fapi_result = 'S' THEN
1758:
1759: wf_engine.setItemAttrText (itemtype => l_item_type
1760: ,itemkey => l_item_key
1761: ,aname => 'API_RESULT'
1762: ,avalue => fapi_result);
1763:

Line 1764: wf_engine.setItemAttrText (itemtype => l_item_type

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

Line 1769: wf_engine.setItemAttrText (itemtype => l_item_type

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

Line 1774: wf_engine.setItemAttrNumber(itemtype => l_item_type

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

Line 1779: wf_engine.setItemAttrText (itemtype => l_item_type

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

Line 1784: wf_engine.setItemAttrText (itemtype => l_item_type

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

Line 1824: wf_engine.setItemAttrText (itemtype => l_item_type

1820: ELSIF fapi_result = 'E' THEN
1821:
1822: l_notification_text := NULL;
1823:
1824: wf_engine.setItemAttrText (itemtype => l_item_type
1825: ,itemkey => l_item_key
1826: ,aname => 'API_RESULT'
1827: ,avalue => fapi_result);
1828:

Line 1829: wf_engine.setItemAttrText (itemtype => l_item_type

1825: ,itemkey => l_item_key
1826: ,aname => 'API_RESULT'
1827: ,avalue => fapi_result);
1828:
1829: wf_engine.setItemAttrText (itemtype => l_item_type
1830: ,itemkey => l_item_key
1831: ,aname => 'API_FROM'
1832: ,avalue => fapi_from);
1833:

Line 1834: wf_engine.setItemAttrText (itemtype => l_item_type

1830: ,itemkey => l_item_key
1831: ,aname => 'API_FROM'
1832: ,avalue => fapi_from);
1833:
1834: wf_engine.setItemAttrText (itemtype => l_item_type
1835: ,itemkey => l_item_key
1836: ,aname => 'API_TO'
1837: ,avalue => fapi_to);
1838:

Line 1839: wf_engine.setItemAttrNumber(itemtype => l_item_type

1835: ,itemkey => l_item_key
1836: ,aname => 'API_TO'
1837: ,avalue => fapi_to);
1838:
1839: wf_engine.setItemAttrNumber(itemtype => l_item_type
1840: ,itemkey => l_item_key
1841: ,aname => 'EVENT_ID'
1842: ,avalue => l_eventid);
1843:

Line 1844: wf_engine.setItemAttrText (itemtype => l_item_type

1840: ,itemkey => l_item_key
1841: ,aname => 'EVENT_ID'
1842: ,avalue => l_eventid);
1843:
1844: wf_engine.setItemAttrText (itemtype => l_item_type
1845: ,itemkey => l_item_key
1846: ,aname => 'BUSINESS_GROUP_NAME'
1847: ,avalue => l_business_group_name);
1848:

Line 1849: wf_engine.setItemAttrText (itemtype => l_item_type

1845: ,itemkey => l_item_key
1846: ,aname => 'BUSINESS_GROUP_NAME'
1847: ,avalue => l_business_group_name);
1848:
1849: wf_engine.setItemAttrText (itemtype => l_item_type
1850: ,itemkey => l_item_key
1851: ,aname => 'NOTIFICATION_TEXT'
1852: ,avalue => l_notification_text);
1853:

Line 1899: wf_engine.setItemAttrText (itemtype => l_item_type

1895: UPDATE ota_finance_lines SET transfer_status = 'AT'
1896: WHERE finance_line_id = l_finance_line_id;
1897: END IF;
1898: */
1899: wf_engine.setItemAttrText (itemtype => l_item_type
1900: ,itemkey => l_item_key
1901: ,aname => 'BOOKING_STATUS_TYPE_ID'
1902: ,avalue => l_booking_status_row.booking_status_type_id);
1903:

Line 1904: WF_ENGINE.setitemattrtext(l_item_type,

1900: ,itemkey => l_item_key
1901: ,aname => 'BOOKING_STATUS_TYPE_ID'
1902: ,avalue => l_booking_status_row.booking_status_type_id);
1903:
1904: WF_ENGINE.setitemattrtext(l_item_type,
1905: l_item_key,
1906: 'BOOKING_ID',
1907: l_booking_id);
1908:

Line 1921: wf_engine.setItemAttrText (itemtype => l_item_type

1917: p_finance_line_id => l_finance_line_id,
1918: p_date_status_changed => l_current_date,
1919: p_date_booking_placed => l_date_booking_placed);
1920:
1921: wf_engine.setItemAttrText (itemtype => l_item_type
1922: ,itemkey => l_item_key
1923: ,aname => 'BOOKING_STATUS_TYPE_ID'
1924: ,avalue => l_booking_status_row.booking_status_type_id);
1925:

Line 1926: WF_ENGINE.setitemattrtext(l_item_type,

1922: ,itemkey => l_item_key
1923: ,aname => 'BOOKING_STATUS_TYPE_ID'
1924: ,avalue => l_booking_status_row.booking_status_type_id);
1925:
1926: WF_ENGINE.setitemattrtext(l_item_type,
1927: l_item_key,
1928: 'BOOKING_ID',
1929: l_booking_id);
1930:

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

1968: l_trans_step_id number;
1969:
1970: begin
1971:
1972: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1973: ,itemkey => itemkey
1974: ,aname => 'OTA_TRANSACTION_STEP_ID');
1975:
1976: if ( funmode = 'RUN' ) then

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

1996: l_transaction_step_id number;
1997:
1998: begin
1999:
2000: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
2001: ,itemkey => p_item_key
2002: ,aname => 'OTA_TRANSACTION_STEP_ID');
2003: process_api2(true,l_transaction_step_id);
2004: