APPS.OTA_RESOURCE_BOOKING_API dependencies on OTA_EVENTS

Line 407: l_event_id ota_events.event_id%type;

403: and osr.supplied_resource_id = p_supplied_resource_id;
404:
405:
406: l_status varchar2(30);
407: l_event_id ota_events.event_id%type;
408: l_date_from date;
409: l_start_date_changed boolean;
410:
411: l_notify_days_before number(9) := fnd_profile.value('OTA_INST_REMIND_NTF_DAYS');

Line 718: l_start_time ota_events.course_start_time%type;

714: and osr.supplied_resource_id = crs_sup_res_id;
715:
716: l_start_date varchar2(100);
717: l_end_date varchar2(100);
718: l_start_time ota_events.course_start_time%type;
719: l_end_time ota_events.course_start_time%type;
720: l_status varchar2(30);
721: l_event_id ota_events.event_id%type;
722: l_sup_res_id ota_resource_bookings.supplied_resource_id%type;

Line 719: l_end_time ota_events.course_start_time%type;

715:
716: l_start_date varchar2(100);
717: l_end_date varchar2(100);
718: l_start_time ota_events.course_start_time%type;
719: l_end_time ota_events.course_start_time%type;
720: l_status varchar2(30);
721: l_event_id ota_events.event_id%type;
722: l_sup_res_id ota_resource_bookings.supplied_resource_id%type;
723: l_person_id per_people_f.person_id%type;

Line 721: l_event_id ota_events.event_id%type;

717: l_end_date varchar2(100);
718: l_start_time ota_events.course_start_time%type;
719: l_end_time ota_events.course_start_time%type;
720: l_status varchar2(30);
721: l_event_id ota_events.event_id%type;
722: l_sup_res_id ota_resource_bookings.supplied_resource_id%type;
723: l_person_id per_people_f.person_id%type;
724: --
725: --