APPS.OTA_RESOURCE_BOOKING_API dependencies on OTA_RESOURCE_BOOKINGS

Line 69: l_resource_booking_id ota_resource_bookings.resource_booking_id%type ;

65: --
66: l_proc varchar2(72) := g_package||' create_resource_booking ';
67: l_object_version_number number;
68: l_effective_date date;
69: l_resource_booking_id ota_resource_bookings.resource_booking_id%type ;
70:
71: l_person_id per_people_f.person_id%type;
72:
73: cursor get_trainer_id is

Line 396: from ota_resource_bookings orb

392:
393: cursor get_res_info
394: is
395: select orb.status,orb.event_id,orb.required_date_from
396: from ota_resource_bookings orb
397: where resource_booking_id = p_resource_booking_id;
398:
399: cursor get_trainer_id is
400: select osr.trainer_id from ota_suppliable_resources osr

Line 707: from ota_resource_bookings orb

703: is
704: select orb.required_date_From,orb.required_date_to,
705: orb.required_start_time,orb.required_end_time,
706: orb.status,orb.supplied_resource_id,orb.event_id
707: from ota_resource_bookings orb
708: where resource_booking_id = p_resource_booking_id;
709:
710: cursor get_trainer_id (crs_sup_res_id number)is
711: select osr.trainer_id from ota_suppliable_resources osr

Line 722: l_sup_res_id ota_resource_bookings.supplied_resource_id%type;

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: --
726: begin