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_WF dependencies on OTA_BOOKING_STATUS_TYPES

Line 1227: ota_delegate_bookings tdb, ota_booking_status_types bst

1223: IS
1224: SELECT
1225: bst.type
1226: FROM
1227: ota_delegate_bookings tdb, ota_booking_status_types bst
1228: WHERE
1229: line_id = to_number(itemkey)AND
1230: bst.booking_status_type_id = tdb.booking_status_type_id;
1231:

Line 1233: l_type ota_booking_status_types.type%type;

1229: line_id = to_number(itemkey)AND
1230: bst.booking_status_type_id = tdb.booking_status_type_id;
1231:
1232: l_proc varchar2(72) := g_package||'chk_enroll_status_adv';
1233: l_type ota_booking_status_types.type%type;
1234:
1235: BEGIN
1236: hr_utility.set_location('Entering:'||l_proc, 5);
1237: IF (funcmode = 'RUN') THEN

Line 1340: ota_booking_status_types bst

1336: SELECT
1337: bst.type
1338: FROM
1339: ota_delegate_bookings tdb,
1340: ota_booking_status_types bst
1341: WHERE
1342: line_id = to_number(itemkey)AND
1343: bst.booking_status_type_id = tdb.booking_status_type_id;
1344:

Line 1346: l_type ota_booking_status_types.type%type;

1342: line_id = to_number(itemkey)AND
1343: bst.booking_status_type_id = tdb.booking_status_type_id;
1344:
1345: l_proc varchar2(72) := g_package||'chk_enroll_status_arr';
1346: l_type ota_booking_status_types.type%type;
1347:
1348: BEGIN
1349: hr_utility.set_location('Entering:'||l_proc, 5);
1350: IF (funcmode = 'RUN') THEN

Line 1553: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;

1549: l_org_id oe_order_lines.org_id%type;
1550: l_proc varchar2(72) := g_package||'cancel_enrollment';
1551: l_return_status varchar2(1);
1552:
1553: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;
1554: l_booking_status_type varchar2(3);
1555:
1556: CURSOR C_ENROLLMENT IS
1557: SELECT

Line 1570: OTA_BOOKING_STATUS_TYPES

1566: CURSOR C_BOOKING_STATUS IS
1567: SELECT
1568: Type
1569: FROM
1570: OTA_BOOKING_STATUS_TYPES
1571: WHERE
1572: booking_status_type_id = l_booking_status_type_id;
1573:
1574:

Line 1837: ota_booking_status_types bst

1833: SELECT
1834: bst.type
1835: FROM
1836: ota_delegate_bookings tdb,
1837: ota_booking_status_types bst
1838: WHERE
1839: event_id = l_event_id AND
1840: bst.booking_status_type_id = tdb.booking_status_type_id;
1841:

Line 1843: l_type ota_booking_status_types.type%type;

1839: event_id = l_event_id AND
1840: bst.booking_status_type_id = tdb.booking_status_type_id;
1841:
1842: l_proc varchar2(72) := g_package||'chk_event_enroll_status';
1843: l_type ota_booking_status_types.type%type;
1844:
1845: BEGIN
1846: hr_utility.set_location('Entering:'||l_proc, 5);
1847: IF (funcmode = 'RUN') THEN