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 488: ota_offerings off , ota_events oev

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

Line 1388: p_event_id ota_events.event_id%TYPE,

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

Line 1395: l_event_id ota_events.event_id%TYPE;

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