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

Line 309: WF_ENGINE.setitemattrnumber(p_item_type,

305: (p_item_type => p_item_type
306: ,p_item_key => p_item_key
307: ,p_name => 'OTA_TRANSACTION_STEP_ID');
308:
309: WF_ENGINE.setitemattrnumber(p_item_type,
310: p_item_key,
311: 'OTA_TRANSACTION_STEP_ID',
312: l_transaction_step_id);
313:

Line 317: WF_ENGINE.setitemattrtext(p_item_type,

313:
314: Begin
315: -- Setting sshr510 attribute.
316: --
317: WF_ENGINE.setitemattrtext(p_item_type,
318: p_item_key,
319: 'HR_REVIEW_TEMPLATE_RN_ATTR',
320: 'OTA_TP_REVIEW_RN_NTF');
321: --

Line 327: l_approval_mode :=wf_engine.getItemAttrText(itemtype => p_item_type

323: null;
324: End;
325:
326:
327: l_approval_mode :=wf_engine.getItemAttrText(itemtype => p_item_type
328: ,itemkey => p_item_key
329: ,aname => 'HR_RUNTIME_APPROVAL_REQ_FLAG');
330:
331:

Line 344: WF_ENGINE.setitemattrnumber(p_item_type,

340: (p_item_type => p_item_type
341: ,p_item_key => p_item_key
342: ,p_name => 'OTA_EVENT_ID');
343:
344: WF_ENGINE.setitemattrnumber(p_item_type,
345: p_item_key,
346: 'OTA_EVENT_ID',
347: p_eventid);
348: end if;

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

661: ,p_object_version_number => l_trans_obj_vers_nums
662: ,p_rows => l_trans_step_rows);
663: */
664: --added new
665: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
666: ,itemkey => p_item_key
667: ,aname => 'OTA_TRANSACTION_STEP_ID');
668: get_review_data_from_tt(
669: p_transaction_step_id => l_trans_step_id

Line 1155: WF_ENGINE.setitemattrtext(l_item_type,

1151:
1152: l_person_details := ota_trng_enroll_ss.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);
1153:
1154: IF l_person_details.full_name is not null then
1155: WF_ENGINE.setitemattrtext(l_item_type,
1156: l_item_key,
1157: 'CURRENT_PERSON_DISPLAY_NAME',
1158: l_person_details.full_name);
1159: END IF;

Line 1200: WF_ENGINE.setitemattrtext(l_item_type,

1196: End Loop;
1197: end if;
1198:
1199:
1200: WF_ENGINE.setitemattrtext(l_item_type,
1201: l_item_key,
1202: 'OTA_ACTIVITY_VERSION_NAME',
1203: l_version_name);
1204:

Line 1206: WF_ENGINE.setitemattrtext(l_item_type,

1202: 'OTA_ACTIVITY_VERSION_NAME',
1203: l_version_name);
1204:
1205:
1206: WF_ENGINE.setitemattrtext(l_item_type,
1207: l_item_key,
1208: 'EVENT_OWNER_EMAIL',
1209: l_owner_username);
1210:

Line 1212: WF_ENGINE.setitemattrtext(l_item_type,

1208: 'EVENT_OWNER_EMAIL',
1209: l_owner_username);
1210:
1211:
1212: WF_ENGINE.setitemattrtext(l_item_type,
1213: l_item_key,
1214: 'OTA_EVENT_TITLE',
1215: l_event_title);
1216:

Line 1217: WF_ENGINE.setitemattrtext(l_item_type,

1213: l_item_key,
1214: 'OTA_EVENT_TITLE',
1215: l_event_title);
1216:
1217: WF_ENGINE.setitemattrtext(l_item_type,
1218: l_item_key,
1219: 'OTA_COURSE_START_DATE',
1220: l_course_start_date);
1221:

Line 1222: WF_ENGINE.setitemattrtext(l_item_type,

1218: l_item_key,
1219: 'OTA_COURSE_START_DATE',
1220: l_course_start_date);
1221:
1222: WF_ENGINE.setitemattrtext(l_item_type,
1223: l_item_key,
1224: 'OTA_COURSE_END_DATE',
1225: l_course_end_date);
1226:

Line 1227: WF_ENGINE.setitemattrnumber(l_item_type,

1223: l_item_key,
1224: 'OTA_COURSE_END_DATE',
1225: l_course_end_date);
1226:
1227: WF_ENGINE.setitemattrnumber(l_item_type,
1228: l_item_key,
1229: 'TRANSACTION_ID',
1230: --Bug#4617150
1231: -- hr_transaction_web.get_transaction_id

Line 1237: WF_ENGINE.setitemattrnumber(l_item_type,

1233: (p_item_type => l_item_type
1234: ,p_item_key => l_item_key));
1235:
1236:
1237: WF_ENGINE.setitemattrnumber(l_item_type,
1238: l_item_key,
1239: 'FORWARD_FROM_PERSON_ID',
1240: l_delegate_id);
1241:

Line 1266: WF_ENGINE.setitemattrtext(l_item_type,

1262: -- Bug#2227738 hdshah change the exception
1263: -- RAISE OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception ;
1264: RAISE status_not_seeded;
1265: ELSE
1266: WF_ENGINE.setitemattrtext(l_item_type,
1267: l_item_key,
1268: 'ENROLL_IN_A_CLASS_STATUS',
1269: l_booking_status_row.name);
1270: END IF ;

Line 1272: WF_ENGINE.setitemattrtext(l_item_type,

1268: 'ENROLL_IN_A_CLASS_STATUS',
1269: l_booking_status_row.name);
1270: END IF ;
1271:
1272: WF_ENGINE.setitemattrtext(l_item_type,
1273: l_item_key,
1274: 'ENROLL_IN_A_CLASS_STATUS',
1275: l_booking_status_row.name);
1276:

Line 1342: WF_ENGINE.setitemattrtext(l_item_type,

1338: (p_item_type => l_item_type
1339: ,p_item_key => l_item_key
1340: ,p_name => 'OTA_AUTO_CREATE_FINANCE');
1341:
1342: WF_ENGINE.setitemattrtext(l_item_type,
1343: l_item_key,
1344: 'OTA_AUTO_CREATE_FINANCE',
1345: l_auto_create_finance);
1346:

Line 1352: WF_ENGINE.setitemattrtext(l_item_type,

1348: (p_item_type => l_item_type
1349: ,p_item_key => l_item_key
1350: ,p_name => 'OTA_SSHR_AUTO_GL_TRANSFER');
1351:
1352: WF_ENGINE.setitemattrtext(l_item_type,
1353: l_item_key,
1354: 'OTA_SSHR_AUTO_GL_TRANSFER',
1355: l_automatic_transfer_gl);
1356:

Line 1362: WF_ENGINE.setitemattrnumber(l_item_type,

1358: (p_item_type => l_item_type
1359: ,p_item_key => l_item_key
1360: ,p_name => 'OTA_USER_ID');
1361:
1362: WF_ENGINE.setitemattrnumber(l_item_type,
1363: l_item_key,
1364: 'OTA_USER_ID',
1365: l_user);
1366:

Line 1368: WF_ENGINE.setitemattrtext(l_item_type,

1364: 'OTA_USER_ID',
1365: l_user);
1366:
1367:
1368: WF_ENGINE.setitemattrtext(l_item_type,
1369: l_item_key,
1370: 'BOOKING_ID',
1371: l_booking_id);
1372:

Line 1389: WF_ENGINE.setitemattrnumber(l_item_type,

1385: (p_item_type => l_item_type
1386: ,p_item_key => l_item_key
1387: ,p_name => 'OTA_EVENT_ID');
1388:
1389: WF_ENGINE.setitemattrnumber(l_item_type,
1390: l_item_key,
1391: 'OTA_EVENT_ID',
1392: l_eventid);
1393:

Line 1400: WF_ENGINE.setitemattrnumber(l_item_type,

1396: ,p_item_key => l_item_key
1397: ,p_name => 'OTA_DELEGATE_PERSON_ID');
1398:
1399:
1400: WF_ENGINE.setitemattrnumber(l_item_type,
1401: l_item_key,
1402: 'OTA_DELEGATE_PERSON_ID',
1403: l_delegate_id);
1404: /* End Set wf item attribute for rejecttion */

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

1419: ,p_name => 'P_DELEGATE_PERSON_ID'));
1420:
1421:
1422:
1423: l_auto_create_finance := wf_engine.GetItemAttrtext(itemtype => l_item_type
1424: ,itemkey => l_item_key
1425: ,aname => 'OTA_AUTO_CREATE_FINANCE');
1426:
1427:

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

1424: ,itemkey => l_item_key
1425: ,aname => 'OTA_AUTO_CREATE_FINANCE');
1426:
1427:
1428: l_automatic_transfer_gl := wf_engine.GetItemAttrtext(itemtype => l_item_type
1429: ,itemkey => l_item_key
1430: ,aname => 'OTA_SSHR_AUTO_GL_TRANSFER');
1431:
1432: l_user := wf_engine.GetItemAttrNumber(itemtype => l_item_type

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

1428: l_automatic_transfer_gl := wf_engine.GetItemAttrtext(itemtype => l_item_type
1429: ,itemkey => l_item_key
1430: ,aname => 'OTA_SSHR_AUTO_GL_TRANSFER');
1431:
1432: l_user := wf_engine.GetItemAttrNumber(itemtype => l_item_type
1433: ,itemkey => l_item_key
1434: ,aname => 'OTA_USER_ID');
1435:
1436: OPEN bg_to(l_eventid);

Line 1500: WF_ENGINE.setitemattrtext(l_item_type,

1496: -- Bug#2227738 hdshah change the exception
1497: -- RAISE OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception ;
1498: RAISE status_not_seeded;
1499: ELSE
1500: WF_ENGINE.setitemattrtext(l_item_type,
1501: l_item_key,
1502: 'ENROLL_IN_A_CLASS_STATUS',
1503: l_booking_status_row.name);
1504: END IF ;

Line 1506: WF_ENGINE.setitemattrtext(l_item_type,

1502: 'ENROLL_IN_A_CLASS_STATUS',
1503: l_booking_status_row.name);
1504: END IF ;
1505:
1506: WF_ENGINE.setitemattrtext(l_item_type,
1507: l_item_key,
1508: 'ENROLL_IN_A_CLASS_STATUS',
1509: l_booking_status_row.name);
1510:

Line 1566: wf_engine.setItemAttrText (itemtype => l_item_type

1562: p_auto_transfer => l_automatic_transfer_gl);
1563:
1564: IF fapi_result = 'S' THEN
1565:
1566: wf_engine.setItemAttrText (itemtype => l_item_type
1567: ,itemkey => l_item_key
1568: ,aname => 'API_RESULT'
1569: ,avalue => fapi_result);
1570:

Line 1571: wf_engine.setItemAttrText (itemtype => l_item_type

1567: ,itemkey => l_item_key
1568: ,aname => 'API_RESULT'
1569: ,avalue => fapi_result);
1570:
1571: wf_engine.setItemAttrText (itemtype => l_item_type
1572: ,itemkey => l_item_key
1573: ,aname => 'API_FROM'
1574: ,avalue => fapi_from);
1575:

Line 1576: wf_engine.setItemAttrText (itemtype => l_item_type

1572: ,itemkey => l_item_key
1573: ,aname => 'API_FROM'
1574: ,avalue => fapi_from);
1575:
1576: wf_engine.setItemAttrText (itemtype => l_item_type
1577: ,itemkey => l_item_key
1578: ,aname => 'API_TO'
1579: ,avalue => fapi_to);
1580:

Line 1581: wf_engine.setItemAttrNumber(itemtype => l_item_type

1577: ,itemkey => l_item_key
1578: ,aname => 'API_TO'
1579: ,avalue => fapi_to);
1580:
1581: wf_engine.setItemAttrNumber(itemtype => l_item_type
1582: ,itemkey => l_item_key
1583: ,aname => 'EVENT_ID'
1584: ,avalue => l_eventid);
1585:

Line 1586: wf_engine.setItemAttrText (itemtype => l_item_type

1582: ,itemkey => l_item_key
1583: ,aname => 'EVENT_ID'
1584: ,avalue => l_eventid);
1585:
1586: wf_engine.setItemAttrText (itemtype => l_item_type
1587: ,itemkey => l_item_key
1588: ,aname => 'BUSINESS_GROUP_NAME'
1589: ,avalue => l_business_group_name);
1590:

Line 1591: wf_engine.setItemAttrText (itemtype => l_item_type

1587: ,itemkey => l_item_key
1588: ,aname => 'BUSINESS_GROUP_NAME'
1589: ,avalue => l_business_group_name);
1590:
1591: wf_engine.setItemAttrText (itemtype => l_item_type
1592: ,itemkey => l_item_key
1593: ,aname => 'NOTIFICATION_TEXT'
1594: ,avalue => l_notification_text);
1595:

Line 1631: wf_engine.setItemAttrText (itemtype => l_item_type

1627: ELSIF fapi_result = 'E' THEN
1628:
1629: l_notification_text := NULL;
1630:
1631: wf_engine.setItemAttrText (itemtype => l_item_type
1632: ,itemkey => l_item_key
1633: ,aname => 'API_RESULT'
1634: ,avalue => fapi_result);
1635:

Line 1636: wf_engine.setItemAttrText (itemtype => l_item_type

1632: ,itemkey => l_item_key
1633: ,aname => 'API_RESULT'
1634: ,avalue => fapi_result);
1635:
1636: wf_engine.setItemAttrText (itemtype => l_item_type
1637: ,itemkey => l_item_key
1638: ,aname => 'API_FROM'
1639: ,avalue => fapi_from);
1640:

Line 1641: wf_engine.setItemAttrText (itemtype => l_item_type

1637: ,itemkey => l_item_key
1638: ,aname => 'API_FROM'
1639: ,avalue => fapi_from);
1640:
1641: wf_engine.setItemAttrText (itemtype => l_item_type
1642: ,itemkey => l_item_key
1643: ,aname => 'API_TO'
1644: ,avalue => fapi_to);
1645:

Line 1646: wf_engine.setItemAttrNumber(itemtype => l_item_type

1642: ,itemkey => l_item_key
1643: ,aname => 'API_TO'
1644: ,avalue => fapi_to);
1645:
1646: wf_engine.setItemAttrNumber(itemtype => l_item_type
1647: ,itemkey => l_item_key
1648: ,aname => 'EVENT_ID'
1649: ,avalue => l_eventid);
1650:

Line 1651: wf_engine.setItemAttrText (itemtype => l_item_type

1647: ,itemkey => l_item_key
1648: ,aname => 'EVENT_ID'
1649: ,avalue => l_eventid);
1650:
1651: wf_engine.setItemAttrText (itemtype => l_item_type
1652: ,itemkey => l_item_key
1653: ,aname => 'BUSINESS_GROUP_NAME'
1654: ,avalue => l_business_group_name);
1655:

Line 1656: wf_engine.setItemAttrText (itemtype => l_item_type

1652: ,itemkey => l_item_key
1653: ,aname => 'BUSINESS_GROUP_NAME'
1654: ,avalue => l_business_group_name);
1655:
1656: wf_engine.setItemAttrText (itemtype => l_item_type
1657: ,itemkey => l_item_key
1658: ,aname => 'NOTIFICATION_TEXT'
1659: ,avalue => l_notification_text);
1660:

Line 1681: wf_engine.setItemAttrText (itemtype => l_item_type

1677: /*Bug#2215026 Two separate update_enrollment procedure calls included for successful and unsuccessful finance creation.
1678: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id, p_booking_deal_type included.
1679: -- p_update_finance_line parameter changed from 'N' to 'Y'.
1680: */
1681: wf_engine.setItemAttrText (itemtype => l_item_type
1682: ,itemkey => l_item_key
1683: ,aname => 'BOOKING_STATUS_TYPE_ID'
1684: ,avalue => l_booking_status_row.booking_status_type_id);
1685:

Line 1686: WF_ENGINE.setitemattrtext(l_item_type,

1682: ,itemkey => l_item_key
1683: ,aname => 'BOOKING_STATUS_TYPE_ID'
1684: ,avalue => l_booking_status_row.booking_status_type_id);
1685:
1686: WF_ENGINE.setitemattrtext(l_item_type,
1687: l_item_key,
1688: 'BOOKING_ID',
1689: l_booking_id);
1690:

Line 1703: wf_engine.setItemAttrText (itemtype => l_item_type

1699: p_finance_line_id => l_finance_line_id,
1700: p_date_status_changed => l_current_date,
1701: p_date_booking_placed => l_date_booking_placed);
1702:
1703: wf_engine.setItemAttrText (itemtype => l_item_type
1704: ,itemkey => l_item_key
1705: ,aname => 'BOOKING_STATUS_TYPE_ID'
1706: ,avalue => l_booking_status_row.booking_status_type_id);
1707:

Line 1708: WF_ENGINE.setitemattrtext(l_item_type,

1704: ,itemkey => l_item_key
1705: ,aname => 'BOOKING_STATUS_TYPE_ID'
1706: ,avalue => l_booking_status_row.booking_status_type_id);
1707:
1708: WF_ENGINE.setitemattrtext(l_item_type,
1709: l_item_key,
1710: 'BOOKING_ID',
1711: l_booking_id);
1712:

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

1750: l_trans_step_id number;
1751:
1752: begin
1753:
1754: l_trans_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1755: ,itemkey => itemkey
1756: ,aname => 'OTA_TRANSACTION_STEP_ID');
1757:
1758: if ( funmode = 'RUN' ) then

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

1807:
1808:
1809: begin
1810:
1811: /* l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1812: ,itemkey => itemkey
1813: ,aname => 'OTA_TRANSACTION_STEP_ID');
1814: */
1815:

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

1821: (p_transaction_step_id => l_transaction_step_id
1822: ,p_name => 'P_EVENTID'));
1823: */
1824:
1825: l_eventid := wf_engine.GetItemAttrNumber(itemtype => itemtype
1826: ,itemkey => itemkey
1827: ,aname => 'OTA_EVENT_ID');
1828:
1829: /* Bug#2258423 hdshah read delegate person id from workflow instead of transaction table

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

1833: -- ,p_name => 'P_PERSON_ID'));
1834: ,p_name => 'P_DELEGATE_PERSON_ID'));
1835: */
1836:
1837: l_delegate_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
1838: ,itemkey => itemkey
1839: ,aname => 'OTA_DELEGATE_PERSON_ID');
1840:
1841:

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

1887: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1888:
1889: begin
1890:
1891: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
1892: ,itemkey => p_item_key
1893: ,aname => 'OTA_TRANSACTION_STEP_ID');
1894:
1895: -- Code added for Bug#2782175

Line 1902: l_approval_mode :=wf_engine.getItemAttrText(itemtype => p_item_type

1898: ,p_item_type => l_dummy_item_type
1899: ,p_item_key => l_dummy_item_key
1900: ,p_activity_id => l_activity_id);
1901:
1902: l_approval_mode :=wf_engine.getItemAttrText(itemtype => p_item_type
1903: ,itemkey => p_item_key
1904: ,aname => 'HR_RUNTIME_APPROVAL_REQ_FLAG');
1905:
1906:

Line 1919: WF_ENGINE.setitemattrnumber(p_item_type,

1915: (p_item_type => p_item_type
1916: ,p_item_key => p_item_key
1917: ,p_name => 'OTA_EVENT_ID');
1918:
1919: WF_ENGINE.setitemattrnumber(p_item_type,
1920: p_item_key,
1921: 'OTA_EVENT_ID',
1922: l_eventid);
1923: end if; */