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

Line 393: from ota_booking_status_types

389: -- Cursor to retrieve the type of booking status type
390: --
391: Cursor c_status_type is
392: select type
393: from ota_booking_status_types
394: where booking_status_type_id = p_booking_status_type_id;
395: --
396: --
397: l_proc varchar2(72) := g_package||'booking_status_type';

Line 961: ota_booking_status_types b

957: --
958: cursor c_places_taken is
959: select sum(a.number_of_places)
960: from ota_delegate_bookings a,
961: ota_booking_status_types b
962: where a.event_id = p_event_id
963: and a.booking_status_type_id = b.booking_status_type_id
964: and b.type in ('P','A','E') --6683076.Added new enrollment status.
965: and a.internal_booking_flag = 'Y'

Line 1333: from ota_booking_status_types

1329: -- cursor to check that the event is in the same business group
1330: --
1331: Cursor c_same_business_group is
1332: select 'X'
1333: from ota_booking_status_types
1334: where booking_status_type_id = p_booking_status_type_id
1335: and business_group_id = p_business_group_id;
1336: --
1337: l_proc varchar2(72) := g_package||'check_type_business_group';

Line 1461: ota_booking_status_types bst

1457: /** Created for Bug 1576558 **/
1458: cursor c_booking_customer_cancelled is
1459: select bst.type
1460: from ota_delegate_bookings tdb,
1461: ota_booking_status_types bst
1462: where tdb.booking_id = l_result
1463: and bst.booking_status_type_id = tdb.booking_status_type_id;
1464: /** End Created for Bug 1576558 **/
1465:

Line 1470: ota_booking_status_types bst

1466: /** Created for Bug 1823617 **/
1467: cursor c_booking_internal_cancelled is
1468: select bst.type
1469: from ota_delegate_bookings tdb,
1470: ota_booking_status_types bst
1471: where tdb.booking_id = l_result
1472: and bst.booking_status_type_id = tdb.booking_status_type_id;
1473: /** End Created for Bug 1823617 **/
1474:

Line 1657: l_status ota_booking_status_types.name%type; -- bug 3677661

1653: Procedure check_booking_status_type (p_booking_status_type_id in number,
1654: p_event_id number) is -- bug 3677661
1655: --
1656: l_proc varchar2(72) := g_package||'check_booking_status_type';
1657: l_status ota_booking_status_types.name%type; -- bug 3677661
1658: l_validate_event NUMBER; -- bug 3677661
1659: --
1660: CURSOR csr_course_not_in_future -- bug 3677661
1661: IS

Line 1676: FROM ota_booking_status_types bst

1672:
1673: CURSOR csr_booking_sts --- bug 3677661
1674: IS
1675: SELECT name
1676: FROM ota_booking_status_types bst
1677: WHERE bst.booking_status_type_id = p_booking_status_type_id
1678: AND bst.type in ('A','E'); --- bug 9009925
1679:
1680: --

Line 2029: ota_booking_status_types bst

2025: --
2026: Cursor c_number_of_bookings is
2027: select nvl(sum(db.number_of_places),0)
2028: from ota_delegate_bookings db,
2029: ota_booking_status_types bst
2030: where bst.booking_status_type_id = nvl(p_booking_status_type_id,
2031: bst.booking_status_type_id)
2032: and bst.type = nvl(p_status_type, bst.type)
2033: and (p_usage_type is null or

Line 2253: from ota_booking_status_types

2249: l_proc varchar2(72) := g_package||'check_max_allowance';
2250: --
2251: cursor c_event is
2252: select type
2253: from ota_booking_status_types
2254: where booking_status_type_id = p_booking_status_type_id;
2255: --
2256: begin
2257: open c_event;

Line 3191: l_status_type ota_booking_status_types.type%type;

3187:
3188: l_booking_status_changed boolean :=
3189: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,
3190: p_status_type_id);
3191: l_status_type ota_booking_status_types.type%type;
3192: l_old_status_type ota_booking_status_types.type%type;
3193: l_invoice_rule varchar2(80);
3194: l_exist varchar2(1);
3195: l_return boolean;

Line 3192: l_old_status_type ota_booking_status_types.type%type;

3188: l_booking_status_changed boolean :=
3189: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,
3190: p_status_type_id);
3191: l_status_type ota_booking_status_types.type%type;
3192: l_old_status_type ota_booking_status_types.type%type;
3193: l_invoice_rule varchar2(80);
3194: l_exist varchar2(1);
3195: l_return boolean;
3196: l_err_num VARCHAR2(30) := '';

Line 4024: l_status_type ota_booking_status_types.type%TYPE;

4020: AND evt.event_id = p_event_id ;
4021:
4022: /* bug no 4509873 */
4023:
4024: l_status_type ota_booking_status_types.type%TYPE;
4025: --Bug 10253738
4026: l_booking_status_type ota_booking_status_types.type%TYPE;
4027: --
4028: Begin

Line 4026: l_booking_status_type ota_booking_status_types.type%TYPE;

4022: /* bug no 4509873 */
4023:
4024: l_status_type ota_booking_status_types.type%TYPE;
4025: --Bug 10253738
4026: l_booking_status_type ota_booking_status_types.type%TYPE;
4027: --
4028: Begin
4029: hr_utility.set_location('Entering:'||l_proc, 5);
4030: --