APPS.OTA_INITIALIZATION_WF dependencies on OTA_RESOURCE_BOOKINGS

Line 670: p_sup_res_id in ota_resource_bookings.supplied_resource_id%type,

666:
667: Procedure Initialize_instructor_wf(
668: p_item_type in wf_items.item_type%type,
669: p_eventid in ota_events.event_id%type,
670: p_sup_res_id in ota_resource_bookings.supplied_resource_id%type,
671: p_start_date in varchar2,
672: p_end_date in varchar2,
673: p_start_time in ota_events.course_start_time%type,
674: p_end_time in ota_events.course_start_time%type,

Line 676: p_res_book_id in ota_resource_bookings.resource_booking_id%type,

672: p_end_date in varchar2,
673: p_start_time in ota_events.course_start_time%type,
674: p_end_time in ota_events.course_start_time%type,
675: p_status in varchar2,
676: p_res_book_id in ota_resource_bookings.resource_booking_id%type,
677: p_person_id in number,
678: p_event_fired in varchar2)
679:
680: is

Line 729: from ota_resource_bookings orb,ota_suppliable_resources osr

725: is
726: select distinct(osr.trainer_id) trainer_id ,orb.required_date_from,orb.required_date_to,
727: orb.required_start_time,orb.required_end_time,orb.status,ota_timezone_util.get_timezone_name(orb.timezone_code) timezone,
728: orb.resource_booking_id resource_booking_id
729: from ota_resource_bookings orb,ota_suppliable_resources osr
730: where orb.supplied_resource_id = osr.supplied_resource_id
731: and osr.resource_type ='T'
732: and orb.event_id = p_eventid
733: and (p_res_book_id is null or orb.resource_booking_id=p_res_book_id);

Line 740: from ota_resource_bookings orb,ota_suppliable_resources osr

736: is
737: select osr.trainer_id trainer_id ,orb.required_date_from,orb.required_date_to,
738: orb.required_start_time,orb.required_end_time,orb.status,ota_timezone_util.get_timezone_name(orb.timezone_code) timezone,
739: orb.resource_booking_id resource_booking_id
740: from ota_resource_bookings orb,ota_suppliable_resources osr
741: where orb.supplied_resource_id = osr.supplied_resource_id
742: and osr.supplied_resource_id = p_sup_res_id
743: and osr.resource_type ='T'
744: and orb.event_id = p_eventid;

Line 1140: from ota_resource_bookings orb

1136: where resource_type ='T';
1137:
1138: cursor get_all_cls_info (l_supp_res_id number) is
1139: select orb.event_id event_id
1140: from ota_resource_bookings orb
1141: where orb.supplied_resource_id = l_supp_res_id
1142: and orb.required_date_from = (trunc(sysdate)+l_notify_days_before)
1143: and orb.status= 'C'
1144: and orb.event_id is not null;

Line 1149: from ota_resource_bookings orb,ota_suppliable_resources osr

1145:
1146: /*cursor get_all_cls_info
1147: is
1148: select distinct(orb.event_id) event_id, orb.supplied_resource_id
1149: from ota_resource_bookings orb,ota_suppliable_resources osr
1150: where orb.supplied_resource_id = osr.supplied_resource_id
1151: and osr.resource_type ='T'
1152: and orb.required_date_from = (trunc(sysdate) + l_notify_days_before)
1153: and orb.status= 'C'