APPS.OTA_TDB_API_UPD2 dependencies on OTA_EVENTS

Line 298: FROM ota_events evt,

294: CURSOR csr_get_class_details IS
295: SELECT evt.course_start_time
296: ,evt.course_start_date
297: ,evt.event_id
298: FROM ota_events evt,
299: ota_delegate_bookings tdb
300: WHERE tdb.event_id = evt.event_id
301: AND tdb.booking_id = p_booking_id;
302:

Line 311: l_course_start_time OTA_EVENTS.course_start_time%TYPE;

307: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
308: AND bst.type = 'W'
309: AND tdb.event_id = p_event_id;
310:
311: l_course_start_time OTA_EVENTS.course_start_time%TYPE;
312: l_course_start_date OTA_EVENTS.course_start_date%TYPE;
313: l_event_id OTA_EVENTS.event_id%TYPE;
314: l_waitlist_count NUMBER;
315:

Line 312: l_course_start_date OTA_EVENTS.course_start_date%TYPE;

308: AND bst.type = 'W'
309: AND tdb.event_id = p_event_id;
310:
311: l_course_start_time OTA_EVENTS.course_start_time%TYPE;
312: l_course_start_date OTA_EVENTS.course_start_date%TYPE;
313: l_event_id OTA_EVENTS.event_id%TYPE;
314: l_waitlist_count NUMBER;
315:
316: BEGIN

Line 313: l_event_id OTA_EVENTS.event_id%TYPE;

309: AND tdb.event_id = p_event_id;
310:
311: l_course_start_time OTA_EVENTS.course_start_time%TYPE;
312: l_course_start_date OTA_EVENTS.course_start_date%TYPE;
313: l_event_id OTA_EVENTS.event_id%TYPE;
314: l_waitlist_count NUMBER;
315:
316: BEGIN
317: OPEN csr_get_class_details;

Line 489: ota_offerings off , ota_events oev

485:
486: Cursor chk_for_comp_upd
487: is
488: select ocu.online_flag , off.Learning_object_id from ota_category_usages ocu,
489: ota_offerings off , ota_events oev
490: where ocu.category_usage_id = off.delivery_mode_id
491: and off.offering_id = oev.parent_offering_id
492: and oev.event_id = p_event_id;
493:

Line 1390: p_event_id ota_events.event_id%TYPE,

1386: Procedure chk_mandatory_prereqs
1387: (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
1388: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
1389: p_customer_id ota_delegate_bookings.customer_id%TYPE,
1390: p_event_id ota_events.event_id%TYPE,
1391: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE
1392: ) IS
1393:
1394: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;

Line 1397: l_event_id ota_events.event_id%TYPE;

1393:
1394: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
1395: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
1396: l_customer_id ota_delegate_bookings.customer_id%TYPE;
1397: l_event_id ota_events.event_id%TYPE;
1398: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
1399: l_check_prereq boolean;
1400: l_old_status_type varchar2(30);
1401: l_new_status_type varchar2(30);