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

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

160: l_transaction_table(l_count).param_value := p_trndates;
161: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
162:
163:
164: l_review_item_name := wf_engine.GetActivityAttrText(itemtype => p_item_type,
165: itemkey => p_item_key,
166: actid => p_activity_id,
167: aname => gv_wf_review_region_item);
168:

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

412: l_transaction_table(l_count).param_value := p_activity_id;
413: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
414:
415:
416: l_review_item_name := wf_engine.GetActivityAttrText(itemtype => p_item_type,
417: itemkey => p_item_key,
418: actid => p_activity_id,
419: aname => gv_wf_review_region_item);
420:

Line 607: WF_ENGINE.setitemattrnumber(p_item_type,

603: (p_item_type => p_item_type
604: ,p_item_key => p_item_key
605: ,p_name => 'OTA_TRANSACTION_STEP_ID');
606:
607: WF_ENGINE.setitemattrnumber(p_item_type,
608: p_item_key,
609: 'OTA_TRANSACTION_STEP_ID',
610: l_transaction_step_id);
611:

Line 1603: WF_ENGINE.setitemattrtext(l_item_type,

1599:
1600: l_person_details := ota_enroll_in_training_ss.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);
1601:
1602: IF l_person_details.full_name is not null then
1603: WF_ENGINE.setitemattrtext(l_item_type,
1604: l_item_key,
1605: 'CURRENT_PERSON_DISPLAY_NAME',
1606: l_person_details.full_name);
1607: END IF;

Line 1648: WF_ENGINE.setitemattrtext(l_item_type,

1644: End Loop;
1645: end if;
1646:
1647:
1648: WF_ENGINE.setitemattrtext(l_item_type,
1649: l_item_key,
1650: 'OTA_ACTIVITY_VERSION_NAME',
1651: l_version_name);
1652:

Line 1654: WF_ENGINE.setitemattrtext(l_item_type,

1650: 'OTA_ACTIVITY_VERSION_NAME',
1651: l_version_name);
1652:
1653:
1654: WF_ENGINE.setitemattrtext(l_item_type,
1655: l_item_key,
1656: 'EVENT_OWNER_EMAIL',
1657: l_owner_username);
1658:

Line 1660: WF_ENGINE.setitemattrtext(l_item_type,

1656: 'EVENT_OWNER_EMAIL',
1657: l_owner_username);
1658:
1659:
1660: WF_ENGINE.setitemattrtext(l_item_type,
1661: l_item_key,
1662: 'OTA_EVENT_TITLE',
1663: l_event_title);
1664:

Line 1665: WF_ENGINE.setitemattrtext(l_item_type,

1661: l_item_key,
1662: 'OTA_EVENT_TITLE',
1663: l_event_title);
1664:
1665: WF_ENGINE.setitemattrtext(l_item_type,
1666: l_item_key,
1667: 'OTA_COURSE_START_DATE',
1668: l_course_start_date);
1669:

Line 1670: WF_ENGINE.setitemattrtext(l_item_type,

1666: l_item_key,
1667: 'OTA_COURSE_START_DATE',
1668: l_course_start_date);
1669:
1670: WF_ENGINE.setitemattrtext(l_item_type,
1671: l_item_key,
1672: 'OTA_COURSE_END_DATE',
1673: l_course_end_date);
1674:

Line 1675: WF_ENGINE.setitemattrnumber(l_item_type,

1671: l_item_key,
1672: 'OTA_COURSE_END_DATE',
1673: l_course_end_date);
1674:
1675: WF_ENGINE.setitemattrnumber(l_item_type,
1676: l_item_key,
1677: 'TRANSACTION_ID',
1678: -- Bug#4617150
1679: -- hr_transaction_web.get_transaction_id

Line 1685: WF_ENGINE.setitemattrnumber(l_item_type,

1681: (p_item_type => l_item_type
1682: ,p_item_key => l_item_key));
1683:
1684:
1685: WF_ENGINE.setitemattrnumber(l_item_type,
1686: l_item_key,
1687: 'FORWARD_FROM_PERSON_ID',
1688: l_delegate_id);
1689:

Line 1714: WF_ENGINE.setitemattrtext(l_item_type,

1710: -- Bug#2227738 hdshah change the exception
1711: -- RAISE OTA_ENROLL_IN_TRAINING_SS.g_mesg_on_stack_exception ;
1712: RAISE status_not_seeded;
1713: ELSE
1714: WF_ENGINE.setitemattrtext(l_item_type,
1715: l_item_key,
1716: 'ENROLL_IN_A_CLASS_STATUS',
1717: l_booking_status_row.name);
1718: END IF ;

Line 1720: WF_ENGINE.setitemattrtext(l_item_type,

1716: 'ENROLL_IN_A_CLASS_STATUS',
1717: l_booking_status_row.name);
1718: END IF ;
1719:
1720: WF_ENGINE.setitemattrtext(l_item_type,
1721: l_item_key,
1722: 'ENROLL_IN_A_CLASS_STATUS',
1723: l_booking_status_row.name);
1724:

Line 1791: WF_ENGINE.setitemattrtext(l_item_type,

1787: (p_item_type => l_item_type
1788: ,p_item_key => l_item_key
1789: ,p_name => 'OTA_AUTO_CREATE_FINANCE');
1790:
1791: WF_ENGINE.setitemattrtext(l_item_type,
1792: l_item_key,
1793: 'OTA_AUTO_CREATE_FINANCE',
1794: l_auto_create_finance);
1795:

Line 1801: WF_ENGINE.setitemattrtext(l_item_type,

1797: (p_item_type => l_item_type
1798: ,p_item_key => l_item_key
1799: ,p_name => 'OTA_SSHR_AUTO_GL_TRANSFER');
1800:
1801: WF_ENGINE.setitemattrtext(l_item_type,
1802: l_item_key,
1803: 'OTA_SSHR_AUTO_GL_TRANSFER',
1804: l_automatic_transfer_gl);
1805:

Line 1811: WF_ENGINE.setitemattrnumber(l_item_type,

1807: (p_item_type => l_item_type
1808: ,p_item_key => l_item_key
1809: ,p_name => 'OTA_USER_ID');
1810:
1811: WF_ENGINE.setitemattrnumber(l_item_type,
1812: l_item_key,
1813: 'OTA_USER_ID',
1814: l_user);
1815:

Line 1817: WF_ENGINE.setitemattrtext(l_item_type,

1813: 'OTA_USER_ID',
1814: l_user);
1815:
1816:
1817: WF_ENGINE.setitemattrtext(l_item_type,
1818: l_item_key,
1819: 'BOOKING_ID',
1820: l_booking_id);
1821:

Line 1838: WF_ENGINE.setitemattrnumber(l_item_type,

1834: (p_item_type => l_item_type
1835: ,p_item_key => l_item_key
1836: ,p_name => 'OTA_EVENT_ID');
1837:
1838: WF_ENGINE.setitemattrnumber(l_item_type,
1839: l_item_key,
1840: 'OTA_EVENT_ID',
1841: l_eventid);
1842:

Line 1849: WF_ENGINE.setitemattrnumber(l_item_type,

1845: ,p_item_key => l_item_key
1846: ,p_name => 'OTA_DELEGATE_PERSON_ID');
1847:
1848:
1849: WF_ENGINE.setitemattrnumber(l_item_type,
1850: l_item_key,
1851: 'OTA_DELEGATE_PERSON_ID',
1852: l_delegate_id);
1853: /* End Set wf item attribute for rejecttion */

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

1868: ,p_name => 'P_DELEGATE_PERSON_ID'));
1869:
1870:
1871:
1872: l_auto_create_finance := wf_engine.GetItemAttrtext(itemtype => l_item_type
1873: ,itemkey => l_item_key
1874: ,aname => 'OTA_AUTO_CREATE_FINANCE');
1875:
1876:

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

1873: ,itemkey => l_item_key
1874: ,aname => 'OTA_AUTO_CREATE_FINANCE');
1875:
1876:
1877: l_automatic_transfer_gl := wf_engine.GetItemAttrtext(itemtype => l_item_type
1878: ,itemkey => l_item_key
1879: ,aname => 'OTA_SSHR_AUTO_GL_TRANSFER');
1880:
1881: l_user := wf_engine.GetItemAttrNumber(itemtype => l_item_type

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

1877: l_automatic_transfer_gl := wf_engine.GetItemAttrtext(itemtype => l_item_type
1878: ,itemkey => l_item_key
1879: ,aname => 'OTA_SSHR_AUTO_GL_TRANSFER');
1880:
1881: l_user := wf_engine.GetItemAttrNumber(itemtype => l_item_type
1882: ,itemkey => l_item_key
1883: ,aname => 'OTA_USER_ID');
1884:
1885: OPEN bg_to(l_eventid);

Line 1949: WF_ENGINE.setitemattrtext(l_item_type,

1945: -- Bug#2227738 hdshah change the exception
1946: -- RAISE OTA_ENROLL_IN_TRAINING_SS.g_mesg_on_stack_exception ;
1947: RAISE status_not_seeded;
1948: ELSE
1949: WF_ENGINE.setitemattrtext(l_item_type,
1950: l_item_key,
1951: 'ENROLL_IN_A_CLASS_STATUS',
1952: l_booking_status_row.name);
1953: END IF ;

Line 1955: WF_ENGINE.setitemattrtext(l_item_type,

1951: 'ENROLL_IN_A_CLASS_STATUS',
1952: l_booking_status_row.name);
1953: END IF ;
1954:
1955: WF_ENGINE.setitemattrtext(l_item_type,
1956: l_item_key,
1957: 'ENROLL_IN_A_CLASS_STATUS',
1958: l_booking_status_row.name);
1959:

Line 2015: wf_engine.setItemAttrText (itemtype => l_item_type

2011: p_auto_transfer => l_automatic_transfer_gl);
2012:
2013: IF fapi_result = 'S' THEN
2014:
2015: wf_engine.setItemAttrText (itemtype => l_item_type
2016: ,itemkey => l_item_key
2017: ,aname => 'API_RESULT'
2018: ,avalue => fapi_result);
2019:

Line 2020: wf_engine.setItemAttrText (itemtype => l_item_type

2016: ,itemkey => l_item_key
2017: ,aname => 'API_RESULT'
2018: ,avalue => fapi_result);
2019:
2020: wf_engine.setItemAttrText (itemtype => l_item_type
2021: ,itemkey => l_item_key
2022: ,aname => 'API_FROM'
2023: ,avalue => fapi_from);
2024:

Line 2025: wf_engine.setItemAttrText (itemtype => l_item_type

2021: ,itemkey => l_item_key
2022: ,aname => 'API_FROM'
2023: ,avalue => fapi_from);
2024:
2025: wf_engine.setItemAttrText (itemtype => l_item_type
2026: ,itemkey => l_item_key
2027: ,aname => 'API_TO'
2028: ,avalue => fapi_to);
2029:

Line 2030: wf_engine.setItemAttrNumber(itemtype => l_item_type

2026: ,itemkey => l_item_key
2027: ,aname => 'API_TO'
2028: ,avalue => fapi_to);
2029:
2030: wf_engine.setItemAttrNumber(itemtype => l_item_type
2031: ,itemkey => l_item_key
2032: ,aname => 'EVENT_ID'
2033: ,avalue => l_eventid);
2034:

Line 2035: wf_engine.setItemAttrText (itemtype => l_item_type

2031: ,itemkey => l_item_key
2032: ,aname => 'EVENT_ID'
2033: ,avalue => l_eventid);
2034:
2035: wf_engine.setItemAttrText (itemtype => l_item_type
2036: ,itemkey => l_item_key
2037: ,aname => 'BUSINESS_GROUP_NAME'
2038: ,avalue => l_business_group_name);
2039:

Line 2040: wf_engine.setItemAttrText (itemtype => l_item_type

2036: ,itemkey => l_item_key
2037: ,aname => 'BUSINESS_GROUP_NAME'
2038: ,avalue => l_business_group_name);
2039:
2040: wf_engine.setItemAttrText (itemtype => l_item_type
2041: ,itemkey => l_item_key
2042: ,aname => 'NOTIFICATION_TEXT'
2043: ,avalue => l_notification_text);
2044:

Line 2080: wf_engine.setItemAttrText (itemtype => l_item_type

2076: ELSIF fapi_result = 'E' THEN
2077:
2078: l_notification_text := NULL;
2079:
2080: wf_engine.setItemAttrText (itemtype => l_item_type
2081: ,itemkey => l_item_key
2082: ,aname => 'API_RESULT'
2083: ,avalue => fapi_result);
2084:

Line 2085: wf_engine.setItemAttrText (itemtype => l_item_type

2081: ,itemkey => l_item_key
2082: ,aname => 'API_RESULT'
2083: ,avalue => fapi_result);
2084:
2085: wf_engine.setItemAttrText (itemtype => l_item_type
2086: ,itemkey => l_item_key
2087: ,aname => 'API_FROM'
2088: ,avalue => fapi_from);
2089:

Line 2090: wf_engine.setItemAttrText (itemtype => l_item_type

2086: ,itemkey => l_item_key
2087: ,aname => 'API_FROM'
2088: ,avalue => fapi_from);
2089:
2090: wf_engine.setItemAttrText (itemtype => l_item_type
2091: ,itemkey => l_item_key
2092: ,aname => 'API_TO'
2093: ,avalue => fapi_to);
2094:

Line 2095: wf_engine.setItemAttrNumber(itemtype => l_item_type

2091: ,itemkey => l_item_key
2092: ,aname => 'API_TO'
2093: ,avalue => fapi_to);
2094:
2095: wf_engine.setItemAttrNumber(itemtype => l_item_type
2096: ,itemkey => l_item_key
2097: ,aname => 'EVENT_ID'
2098: ,avalue => l_eventid);
2099:

Line 2100: wf_engine.setItemAttrText (itemtype => l_item_type

2096: ,itemkey => l_item_key
2097: ,aname => 'EVENT_ID'
2098: ,avalue => l_eventid);
2099:
2100: wf_engine.setItemAttrText (itemtype => l_item_type
2101: ,itemkey => l_item_key
2102: ,aname => 'BUSINESS_GROUP_NAME'
2103: ,avalue => l_business_group_name);
2104:

Line 2105: wf_engine.setItemAttrText (itemtype => l_item_type

2101: ,itemkey => l_item_key
2102: ,aname => 'BUSINESS_GROUP_NAME'
2103: ,avalue => l_business_group_name);
2104:
2105: wf_engine.setItemAttrText (itemtype => l_item_type
2106: ,itemkey => l_item_key
2107: ,aname => 'NOTIFICATION_TEXT'
2108: ,avalue => l_notification_text);
2109:

Line 2155: wf_engine.setItemAttrText (itemtype => l_item_type

2151: UPDATE ota_finance_lines SET transfer_status = 'AT'
2152: WHERE finance_line_id = l_finance_line_id;
2153: END IF;
2154: */
2155: wf_engine.setItemAttrText (itemtype => l_item_type
2156: ,itemkey => l_item_key
2157: ,aname => 'BOOKING_STATUS_TYPE_ID'
2158: ,avalue => l_booking_status_row.booking_status_type_id);
2159:

Line 2160: WF_ENGINE.setitemattrtext(l_item_type,

2156: ,itemkey => l_item_key
2157: ,aname => 'BOOKING_STATUS_TYPE_ID'
2158: ,avalue => l_booking_status_row.booking_status_type_id);
2159:
2160: WF_ENGINE.setitemattrtext(l_item_type,
2161: l_item_key,
2162: 'BOOKING_ID',
2163: l_booking_id);
2164:

Line 2177: wf_engine.setItemAttrText (itemtype => l_item_type

2173: p_finance_line_id => l_finance_line_id,
2174: p_date_status_changed => l_current_date,
2175: p_date_booking_placed => l_date_booking_placed);
2176:
2177: wf_engine.setItemAttrText (itemtype => l_item_type
2178: ,itemkey => l_item_key
2179: ,aname => 'BOOKING_STATUS_TYPE_ID'
2180: ,avalue => l_booking_status_row.booking_status_type_id);
2181:

Line 2182: WF_ENGINE.setitemattrtext(l_item_type,

2178: ,itemkey => l_item_key
2179: ,aname => 'BOOKING_STATUS_TYPE_ID'
2180: ,avalue => l_booking_status_row.booking_status_type_id);
2181:
2182: WF_ENGINE.setitemattrtext(l_item_type,
2183: l_item_key,
2184: 'BOOKING_ID',
2185: l_booking_id);
2186:

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

2224: l_trans_step_id number;
2225:
2226: begin
2227:
2228: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2229: ,itemkey => itemkey
2230: ,aname => 'OTA_TRANSACTION_STEP_ID');
2231:
2232: if ( funmode = 'RUN' ) then

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

2281:
2282:
2283: begin
2284:
2285: /* l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2286: ,itemkey => itemkey
2287: ,aname => 'OTA_TRANSACTION_STEP_ID');
2288: */
2289:

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

2295: (p_transaction_step_id => l_transaction_step_id
2296: ,p_name => 'P_EVENTID'));
2297: */
2298:
2299: l_eventid := wf_engine.GetItemAttrNumber(itemtype => itemtype
2300: ,itemkey => itemkey
2301: ,aname => 'OTA_EVENT_ID');
2302:
2303: /* Bug#2258423 hdshah read delegate person id from workflow instead of transaction table

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

2307: -- ,p_name => 'P_PERSON_ID'));
2308: ,p_name => 'P_DELEGATE_PERSON_ID'));
2309: */
2310:
2311: l_delegate_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
2312: ,itemkey => itemkey
2313: ,aname => 'OTA_DELEGATE_PERSON_ID');
2314:
2315:

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

2366: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
2367:
2368: begin
2369:
2370: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
2371: ,itemkey => p_item_key
2372: ,aname => 'OTA_TRANSACTION_STEP_ID');
2373:
2374: -- Code added for Bug#2782175

Line 2381: l_approval_mode := wf_engine.GetActivityAttrText

2377: ,p_item_type => l_dummy_item_type
2378: ,p_item_key => l_dummy_item_key
2379: ,p_activity_id => l_activity_id);
2380:
2381: l_approval_mode := wf_engine.GetActivityAttrText
2382: (itemtype => p_item_type,
2383: itemkey => p_item_key,
2384: actid => l_activity_id,
2385: aname => 'HR_APPROVAL_REQ_FLAG');

Line 2398: WF_ENGINE.setitemattrnumber(p_item_type,

2394: (p_item_type => p_item_type
2395: ,p_item_key => p_item_key
2396: ,p_name => 'OTA_EVENT_ID');
2397:
2398: WF_ENGINE.setitemattrnumber(p_item_type,
2399: p_item_key,
2400: 'OTA_EVENT_ID',
2401: l_eventid);
2402: end if;