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_DELEGATE_BOOKINGS

Line 153: , ota_delegate_bookings tdb

149: cursor csr_sec_grp is
150: select pbg.security_group_id,
151: pbg.legislation_code
152: from per_business_groups_perf pbg
153: , ota_delegate_bookings tdb
154: where tdb.booking_id = p_booking_id
155: and pbg.business_group_id = tdb.business_group_id;
156: --
157: -- Declare local variables

Line 247: , ota_delegate_bookings tdb

243: --
244: cursor csr_leg_code is
245: select pbg.legislation_code
246: from per_business_groups_perf pbg
247: , ota_delegate_bookings tdb
248: where tdb.booking_id = p_booking_id
249: and pbg.business_group_id = tdb.business_group_id;
250: --
251: -- Declare local variables

Line 960: from ota_delegate_bookings a,

956: -- Only placed or attended places take an internal place
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.

Line 1447: from ota_delegate_bookings

1443: -- cursor to select the booking ID
1444: --
1445: Cursor c_booking_customer is
1446: select booking_id
1447: from ota_delegate_bookings
1448: where event_id = p_event_id
1449: and delegate_contact_id = p_person_id;
1450: --
1451: Cursor c_booking_organization is

Line 1453: from ota_delegate_bookings

1449: and delegate_contact_id = p_person_id;
1450: --
1451: Cursor c_booking_organization is
1452: select booking_id
1453: from ota_delegate_bookings
1454: where event_id = p_event_id
1455: and delegate_person_id = p_person_id;
1456:
1457: /** Created for Bug 1576558 **/

Line 1460: from ota_delegate_bookings tdb,

1456:
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 **/

Line 1469: from ota_delegate_bookings tdb,

1465:
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 **/

Line 2028: from ota_delegate_bookings db,

2024: -- cursor to count the number of confirmed bookings for the event to date
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)

Line 2120: from ota_delegate_bookings

2116: -- cursor to check the existence of a booking to the parent event
2117: --
2118: cursor c_customer_parent_booking is
2119: select 'X'
2120: from ota_delegate_bookings
2121: where customer_id = p_customer_id
2122: and event_id in (select a.program_event_id
2123: from ota_program_memberships a
2124: where a.event_id = p_event_id)

Line 2139: from ota_delegate_bookings

2135: );
2136: --
2137: cursor c_organization_parent_booking is
2138: select 'X'
2139: from ota_delegate_bookings
2140: where event_id in (select a.program_event_id
2141: from ota_program_memberships a
2142: where a.event_id = p_event_id)
2143: and (

Line 3007: hr_utility.set_message_token('TABLE_NAME', 'OTA_DELEGATE_BOOKINGS');

3003: If NOT (p_internal_booking_flag in ('N', 'Y')) then
3004: hr_utility.set_message(801,'HR_7166_OBJECT_CHK_CONSTRAINT');
3005: hr_utility.set_message_token('CONSTRAINT_NAME',
3006: 'OTA_TDB_INTERNAL_BOOKING_F_CHK');
3007: hr_utility.set_message_token('TABLE_NAME', 'OTA_DELEGATE_BOOKINGS');
3008: hr_utility.raise_error;
3009: End If;
3010: If NOT (p_successful_attendance_flag in ('N', 'Y')) then
3011: hr_utility.set_message(801,'HR_7166_OBJECT_CHK_CONSTRAINT');

Line 3014: hr_utility.set_message_token('TABLE_NAME', 'OTA_DELEGATE_BOOKINGS');

3010: If NOT (p_successful_attendance_flag in ('N', 'Y')) then
3011: hr_utility.set_message(801,'HR_7166_OBJECT_CHK_CONSTRAINT');
3012: hr_utility.set_message_token('CONSTRAINT_NAME',
3013: 'OTA_TDB_SUCCESSFUL_ATTENDA_CHK');
3014: hr_utility.set_message_token('TABLE_NAME', 'OTA_DELEGATE_BOOKINGS');
3015: hr_utility.raise_error;
3016: End If;
3017: --
3018: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 3041: from ota_delegate_bookings tdb,

3037: l_result number;
3038:
3039: cursor c_pmm_int_enrollments is
3040: select 1
3041: from ota_delegate_bookings tdb,
3042: ota_program_memberships pmm
3043: where tdb.event_id = pmm.event_id
3044: and pmm.program_event_id = l_event_id
3045: and tdb.delegate_person_id = l_delegate_person_id;

Line 3049: from ota_delegate_bookings tdb,

3045: and tdb.delegate_person_id = l_delegate_person_id;
3046:
3047: cursor c_pmm_ext_enrollments is
3048: select 1
3049: from ota_delegate_bookings tdb,
3050: ota_program_memberships pmm
3051: where tdb.event_id = pmm.event_id
3052: and pmm.program_event_id = l_event_id
3053: and tdb.delegate_contact_id = l_delegate_contact_id;

Line 3405: l_event_id OTA_DELEGATE_BOOKINGS.event_id%TYPE := p_event_id;

3401: ,p_content_player_status IN VARCHAR2
3402: ,p_delegate_person_id IN NUMBER
3403: ,p_delegate_contact_id IN NUMBER) IS
3404:
3405: l_event_id OTA_DELEGATE_BOOKINGS.event_id%TYPE := p_event_id;
3406:
3407: CURSOR csr_get_class_type(p_class_id NUMBER) IS
3408: SELECT oft.learning_object_id
3409: ,ctu.online_flag

Line 3424: l_player_status ota_delegate_bookings.content_player_status%TYPE;

3420: l_imported_off_id ota_events.offering_id%TYPE;
3421: l_bkng_status_type VARCHAR2(30);
3422: l_old_bst VARCHAR2(30);
3423:
3424: l_player_status ota_delegate_bookings.content_player_status%TYPE;
3425:
3426: CURSOR csr_get_performance_data(p_user_id NUMBER
3427: ,p_user_type VARCHAR2
3428: ,p_lo_id NUMBER) IS

Line 3438: l_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;

3434: AND lesson_status IN ('P', 'C');
3435:
3436: l_user_type ota_performances.user_type%TYPE;
3437: l_user_id ota_performances.user_id%TYPE;
3438: l_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
3439: l_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
3440:
3441: BEGIN
3442: IF p_booking_status_type_id <> hr_api.g_number THEN

Line 3439: l_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;

3435:
3436: l_user_type ota_performances.user_type%TYPE;
3437: l_user_id ota_performances.user_id%TYPE;
3438: l_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
3439: l_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
3440:
3441: BEGIN
3442: IF p_booking_status_type_id <> hr_api.g_number THEN
3443: ota_utility.get_booking_status_type(p_booking_status_type_id,l_bkng_status_type);

Line 3590: ,p_descflex_name => 'OTA_DELEGATE_BOOKINGS'

3586: --
3587:
3588: hr_dflex_utility.ins_or_upd_descflex_attribs
3589: (p_appl_short_name => 'OTA'
3590: ,p_descflex_name => 'OTA_DELEGATE_BOOKINGS'
3591: ,p_attribute_category => p_rec.tdb_information_category
3592: ,p_attribute1_name => 'TDB_INFORMATION1'
3593: ,p_attribute1_value => p_rec.tdb_information1
3594: ,p_attribute2_name => 'TDB_INFORMATION2'