[Home] [Help]
216: where business_group_id = p_business_group_id
217: and exists
218: (select 1
219: from ota_suppliable_resources sr,
220: ota_resource_bookings rb
221: where rb.event_id = e.event_id
222: and sr.business_group_id = p_business_group_id
223: and sr.supplied_resource_id = rb.supplied_resource_id
224: and sr.currency_code <> e.currency_code);
237: cursor get_rescost is
238: select sr.cost
239: from ota_suppliable_resources sr,
240: ota_events e,
241: ota_resource_bookings rb
242: where rb.event_id = p_event_id
243: and rb.status = 'C'
244: and sr.supplied_resource_id = rb.supplied_resource_id
245: and e.event_id = p_event_id;
369: -- cursor to retrieve booking id
370: --
371: cursor get_book is
372: select resource_booking_id
373: from ota_resource_bookings
374: where supplied_resource_id = p_supplied_resource_id
375: and event_id = p_event_id;
376: --
377: begin
408: -- cursor to perform check
409: --
410: cursor chk_bookings is
411: select 1
412: from ota_resource_bookings
413: where event_id = p_event_id;
414: --
415: begin
416: hr_utility.set_location('Entering:'||l_proc,5);
843: -- cursor to perform check
844: --
845: cursor chk_primven is
846: select 1
847: from ota_resource_bookings rb,
848: ota_events e,
849: ota_offerings off
850: where e.event_id = rb.event_id
851: and off.offering_id = e.parent_offering_id --bug 3494404
910:
911: -- For entire duration flag null or N
912: cursor double_booking is
913: select 1
914: from ota_resource_bookings trb
915: where trb.supplied_resource_id = p_supplied_resource_id
916: and (
917: (p_required_date_from <= trunc(ota_timezone_util.convert_date(trb.required_date_to,nvl(trb.required_end_time, '23:59'),trb.timezone_code,p_timezone))
918: and p_required_date_to >= trunc(ota_timezone_util.convert_date(trb.required_date_from,nvl(trb.required_start_time, '00:00'),trb.timezone_code,p_timezone))
933:
934: Cursor csr_chk_date_overlap is
935: select Book_entire_period_flag,required_end_time,required_start_time,
936: required_date_from,required_date_to,timezone_code
937: from ota_resource_bookings trb
938: where trb.supplied_resource_id = p_supplied_resource_id
939: and (
940: (p_required_date_from between
941: trunc(ota_timezone_util.convert_date(trb.required_date_from,nvl(trb.required_start_time, '00:00'),trb.timezone_code,p_timezone))
1110:
1111: -- For entire duration flag null or N
1112: cursor double_booking is
1113: select 1
1114: from ota_resource_bookings trb
1115: where trb.supplied_resource_id = p_supplied_resource_id
1116: and (
1117: (p_required_date_from <= trunc(ota_timezone_util.convert_date(trb.required_date_to,nvl(trb.required_end_time, '23:59'),trb.timezone_code,p_timezone))
1118: and p_required_date_to >= trunc(ota_timezone_util.convert_date(trb.required_date_from,nvl(trb.required_start_time, '00:00'),trb.timezone_code,p_timezone))
1131:
1132: Cursor csr_chk_date_overlap is
1133: select Book_entire_period_flag,required_end_time,required_start_time,
1134: required_date_from,required_date_to,timezone_code
1135: from ota_resource_bookings trb
1136: where trb.supplied_resource_id = p_supplied_resource_id
1137: and (
1138: (p_required_date_from between
1139: trunc(ota_timezone_util.convert_date(trb.required_date_from,nvl(trb.required_start_time, '00:00'),trb.timezone_code,p_timezone))
1328:
1329: -- For entire duration flag null or N
1330: cursor double_booking is
1331: select 1
1332: from ota_resource_bookings trb
1333: where trb.supplied_resource_id = p_supplied_resource_id
1334: and (
1335: (p_required_date_from <= trunc(ota_timezone_util.convert_date(trb.required_date_to,nvl(trb.required_end_time, '23:59'),trb.timezone_code,p_timezone))
1336: and p_required_date_to >= trunc(ota_timezone_util.convert_date(trb.required_date_from,nvl(trb.required_start_time, '00:00'),trb.timezone_code,p_timezone))
1352: -- Modified to exclude forum and chat related bookings
1353: -- For entire duration flag null or N
1354: cursor trainer_double_booking is
1355: select 1
1356: from ota_resource_bookings trb
1357: where trb.supplied_resource_id = p_supplied_resource_id
1358: and (
1359: (p_required_date_from <= trunc(ota_timezone_util.convert_date(trb.required_date_to,nvl(trb.required_end_time, '23:59'),trb.timezone_code,p_timezone))
1360: and p_required_date_to >= trunc(ota_timezone_util.convert_date(trb.required_date_from,nvl(trb.required_start_time, '00:00'),trb.timezone_code,p_timezone))
1378:
1379: Cursor csr_chk_date_overlap is
1380: select Book_entire_period_flag,required_end_time,required_start_time,
1381: required_date_from,required_date_to,timezone_code
1382: from ota_resource_bookings trb
1383: where trb.supplied_resource_id = p_supplied_resource_id
1384: and p_required_date_from <= trunc (ota_timezone_util.convert_date
1385: (trb.required_date_to, nvl (trb.required_end_time, '23:59'),
1386: trb.timezone_code, p_timezone))
1397: -- Modified to exclude forum and chat related bookings
1398: Cursor csr_chk_trainer_date_overlap is
1399: select Book_entire_period_flag,required_end_time,required_start_time,
1400: required_date_from,required_date_to,timezone_code
1401: from ota_resource_bookings trb
1402: where trb.supplied_resource_id = p_supplied_resource_id
1403: and (
1404: (p_required_date_from between
1405: trunc(ota_timezone_util.convert_date(trb.required_date_from,nvl(trb.required_start_time, '00:00'),trb.timezone_code,p_timezone))
1893: and rud.supplied_resource_id is not null
1894: and rud.required_flag = 'Y'
1895: and not exists
1896: (Select null
1897: From ota_resource_bookings trb
1898: Where
1899: trb.supplied_resource_id = rud.supplied_resource_id
1900: and trb.event_id = p_event_id);
1901: --
1922: fetch get_event_timezone into l_event_timezone;
1923: close get_event_timezone;
1924:
1925: -- bug 3891115
1926: ota_utility.ignore_dff_validation('OTA_RESOURCE_BOOKINGS');
1927: --
1928: ota_resource_booking.ins(p_resource_booking_id => l_resource_booking_id,
1929: p_supplied_resource_id => l_supplied_resource_id,
1930: p_event_id => p_event_id,