DBA Data[Home] [Help]

APPS.OTA_RESOURCE_BOOKING_API dependencies on HR_API

Line 146: when hr_api.cannot_find_prog_unit then

142: ,p_timezone_code => p_timezone_code );
143:
144:
145: exception
146: when hr_api.cannot_find_prog_unit then
147: hr_api.cannot_find_prog_unit_error
148: (p_module_name => 'create_resource_booking'
149: ,p_hook_type => 'BP'
150: );

Line 147: hr_api.cannot_find_prog_unit_error

143:
144:
145: exception
146: when hr_api.cannot_find_prog_unit then
147: hr_api.cannot_find_prog_unit_error
148: (p_module_name => 'create_resource_booking'
149: ,p_hook_type => 'BP'
150: );
151: end;

Line 265: when hr_api.cannot_find_prog_unit then

261: ,p_timezone_code => p_timezone_code);
262:
263:
264: exception
265: when hr_api.cannot_find_prog_unit then
266: hr_api.cannot_find_prog_unit_error
267: (p_module_name => 'create_resource_booking'
268: ,p_hook_type => 'AP'
269: );

Line 266: hr_api.cannot_find_prog_unit_error

262:
263:
264: exception
265: when hr_api.cannot_find_prog_unit then
266: hr_api.cannot_find_prog_unit_error
267: (p_module_name => 'create_resource_booking'
268: ,p_hook_type => 'AP'
269: );
270: end;

Line 275: raise hr_api.validate_enabled;

271: --
272: -- When in validation only mode raise the Validate_Enabled exception
273: --
274: if p_validate then
275: raise hr_api.validate_enabled;
276: end if;
277: --
278: -- Set all output arguments
279: --

Line 308: when hr_api.validate_enabled then

304: end if;
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 70);
307: exception
308: when hr_api.validate_enabled then
309: --
310: -- As the Validate_Enabled exception has been raised
311: -- we must rollback to the savepoint
312: --

Line 339: ,p_event_id in number default hr_api.g_number

335: (p_effective_date in date
336: ,p_supplied_resource_id in number
337: ,p_date_booking_placed in date
338: ,p_status in varchar2
339: ,p_event_id in number default hr_api.g_number
340: ,p_absolute_price in number default hr_api.g_number
341: ,p_booking_person_id in number default hr_api.g_number
342: ,p_comments in varchar2 default hr_api.g_varchar2
343: ,p_contact_name in varchar2 default hr_api.g_varchar2

Line 340: ,p_absolute_price in number default hr_api.g_number

336: ,p_supplied_resource_id in number
337: ,p_date_booking_placed in date
338: ,p_status in varchar2
339: ,p_event_id in number default hr_api.g_number
340: ,p_absolute_price in number default hr_api.g_number
341: ,p_booking_person_id in number default hr_api.g_number
342: ,p_comments in varchar2 default hr_api.g_varchar2
343: ,p_contact_name in varchar2 default hr_api.g_varchar2
344: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2

Line 341: ,p_booking_person_id in number default hr_api.g_number

337: ,p_date_booking_placed in date
338: ,p_status in varchar2
339: ,p_event_id in number default hr_api.g_number
340: ,p_absolute_price in number default hr_api.g_number
341: ,p_booking_person_id in number default hr_api.g_number
342: ,p_comments in varchar2 default hr_api.g_varchar2
343: ,p_contact_name in varchar2 default hr_api.g_varchar2
344: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
345: ,p_delegates_per_unit in number default hr_api.g_number

Line 342: ,p_comments in varchar2 default hr_api.g_varchar2

338: ,p_status in varchar2
339: ,p_event_id in number default hr_api.g_number
340: ,p_absolute_price in number default hr_api.g_number
341: ,p_booking_person_id in number default hr_api.g_number
342: ,p_comments in varchar2 default hr_api.g_varchar2
343: ,p_contact_name in varchar2 default hr_api.g_varchar2
344: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
345: ,p_delegates_per_unit in number default hr_api.g_number
346: ,p_quantity in number default hr_api.g_number

Line 343: ,p_contact_name in varchar2 default hr_api.g_varchar2

339: ,p_event_id in number default hr_api.g_number
340: ,p_absolute_price in number default hr_api.g_number
341: ,p_booking_person_id in number default hr_api.g_number
342: ,p_comments in varchar2 default hr_api.g_varchar2
343: ,p_contact_name in varchar2 default hr_api.g_varchar2
344: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
345: ,p_delegates_per_unit in number default hr_api.g_number
346: ,p_quantity in number default hr_api.g_number
347: ,p_required_date_from in date default hr_api.g_date

Line 344: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2

340: ,p_absolute_price in number default hr_api.g_number
341: ,p_booking_person_id in number default hr_api.g_number
342: ,p_comments in varchar2 default hr_api.g_varchar2
343: ,p_contact_name in varchar2 default hr_api.g_varchar2
344: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
345: ,p_delegates_per_unit in number default hr_api.g_number
346: ,p_quantity in number default hr_api.g_number
347: ,p_required_date_from in date default hr_api.g_date
348: ,p_required_date_to in date default hr_api.g_date

Line 345: ,p_delegates_per_unit in number default hr_api.g_number

341: ,p_booking_person_id in number default hr_api.g_number
342: ,p_comments in varchar2 default hr_api.g_varchar2
343: ,p_contact_name in varchar2 default hr_api.g_varchar2
344: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
345: ,p_delegates_per_unit in number default hr_api.g_number
346: ,p_quantity in number default hr_api.g_number
347: ,p_required_date_from in date default hr_api.g_date
348: ,p_required_date_to in date default hr_api.g_date
349: ,p_required_end_time in varchar2 default hr_api.g_varchar2

Line 346: ,p_quantity in number default hr_api.g_number

342: ,p_comments in varchar2 default hr_api.g_varchar2
343: ,p_contact_name in varchar2 default hr_api.g_varchar2
344: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
345: ,p_delegates_per_unit in number default hr_api.g_number
346: ,p_quantity in number default hr_api.g_number
347: ,p_required_date_from in date default hr_api.g_date
348: ,p_required_date_to in date default hr_api.g_date
349: ,p_required_end_time in varchar2 default hr_api.g_varchar2
350: ,p_required_start_time in varchar2 default hr_api.g_varchar2

Line 347: ,p_required_date_from in date default hr_api.g_date

343: ,p_contact_name in varchar2 default hr_api.g_varchar2
344: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
345: ,p_delegates_per_unit in number default hr_api.g_number
346: ,p_quantity in number default hr_api.g_number
347: ,p_required_date_from in date default hr_api.g_date
348: ,p_required_date_to in date default hr_api.g_date
349: ,p_required_end_time in varchar2 default hr_api.g_varchar2
350: ,p_required_start_time in varchar2 default hr_api.g_varchar2
351: ,p_deliver_to in varchar2 default hr_api.g_varchar2

Line 348: ,p_required_date_to in date default hr_api.g_date

344: ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
345: ,p_delegates_per_unit in number default hr_api.g_number
346: ,p_quantity in number default hr_api.g_number
347: ,p_required_date_from in date default hr_api.g_date
348: ,p_required_date_to in date default hr_api.g_date
349: ,p_required_end_time in varchar2 default hr_api.g_varchar2
350: ,p_required_start_time in varchar2 default hr_api.g_varchar2
351: ,p_deliver_to in varchar2 default hr_api.g_varchar2
352: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2

Line 349: ,p_required_end_time in varchar2 default hr_api.g_varchar2

345: ,p_delegates_per_unit in number default hr_api.g_number
346: ,p_quantity in number default hr_api.g_number
347: ,p_required_date_from in date default hr_api.g_date
348: ,p_required_date_to in date default hr_api.g_date
349: ,p_required_end_time in varchar2 default hr_api.g_varchar2
350: ,p_required_start_time in varchar2 default hr_api.g_varchar2
351: ,p_deliver_to in varchar2 default hr_api.g_varchar2
352: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
353: ,p_role_to_play in varchar2 default hr_api.g_varchar2

Line 350: ,p_required_start_time in varchar2 default hr_api.g_varchar2

346: ,p_quantity in number default hr_api.g_number
347: ,p_required_date_from in date default hr_api.g_date
348: ,p_required_date_to in date default hr_api.g_date
349: ,p_required_end_time in varchar2 default hr_api.g_varchar2
350: ,p_required_start_time in varchar2 default hr_api.g_varchar2
351: ,p_deliver_to in varchar2 default hr_api.g_varchar2
352: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
353: ,p_role_to_play in varchar2 default hr_api.g_varchar2
354: ,p_trb_information_category in varchar2 default hr_api.g_varchar2

Line 351: ,p_deliver_to in varchar2 default hr_api.g_varchar2

347: ,p_required_date_from in date default hr_api.g_date
348: ,p_required_date_to in date default hr_api.g_date
349: ,p_required_end_time in varchar2 default hr_api.g_varchar2
350: ,p_required_start_time in varchar2 default hr_api.g_varchar2
351: ,p_deliver_to in varchar2 default hr_api.g_varchar2
352: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
353: ,p_role_to_play in varchar2 default hr_api.g_varchar2
354: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
355: ,p_trb_information1 in varchar2 default hr_api.g_varchar2

Line 352: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2

348: ,p_required_date_to in date default hr_api.g_date
349: ,p_required_end_time in varchar2 default hr_api.g_varchar2
350: ,p_required_start_time in varchar2 default hr_api.g_varchar2
351: ,p_deliver_to in varchar2 default hr_api.g_varchar2
352: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
353: ,p_role_to_play in varchar2 default hr_api.g_varchar2
354: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
355: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information2 in varchar2 default hr_api.g_varchar2

Line 353: ,p_role_to_play in varchar2 default hr_api.g_varchar2

349: ,p_required_end_time in varchar2 default hr_api.g_varchar2
350: ,p_required_start_time in varchar2 default hr_api.g_varchar2
351: ,p_deliver_to in varchar2 default hr_api.g_varchar2
352: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
353: ,p_role_to_play in varchar2 default hr_api.g_varchar2
354: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
355: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information3 in varchar2 default hr_api.g_varchar2

Line 354: ,p_trb_information_category in varchar2 default hr_api.g_varchar2

350: ,p_required_start_time in varchar2 default hr_api.g_varchar2
351: ,p_deliver_to in varchar2 default hr_api.g_varchar2
352: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
353: ,p_role_to_play in varchar2 default hr_api.g_varchar2
354: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
355: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information4 in varchar2 default hr_api.g_varchar2

Line 355: ,p_trb_information1 in varchar2 default hr_api.g_varchar2

351: ,p_deliver_to in varchar2 default hr_api.g_varchar2
352: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
353: ,p_role_to_play in varchar2 default hr_api.g_varchar2
354: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
355: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information5 in varchar2 default hr_api.g_varchar2

Line 356: ,p_trb_information2 in varchar2 default hr_api.g_varchar2

352: ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
353: ,p_role_to_play in varchar2 default hr_api.g_varchar2
354: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
355: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information6 in varchar2 default hr_api.g_varchar2

Line 357: ,p_trb_information3 in varchar2 default hr_api.g_varchar2

353: ,p_role_to_play in varchar2 default hr_api.g_varchar2
354: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
355: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information7 in varchar2 default hr_api.g_varchar2

Line 358: ,p_trb_information4 in varchar2 default hr_api.g_varchar2

354: ,p_trb_information_category in varchar2 default hr_api.g_varchar2
355: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information8 in varchar2 default hr_api.g_varchar2

Line 359: ,p_trb_information5 in varchar2 default hr_api.g_varchar2

355: ,p_trb_information1 in varchar2 default hr_api.g_varchar2
356: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information9 in varchar2 default hr_api.g_varchar2

Line 360: ,p_trb_information6 in varchar2 default hr_api.g_varchar2

356: ,p_trb_information2 in varchar2 default hr_api.g_varchar2
357: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
364: ,p_trb_information10 in varchar2 default hr_api.g_varchar2

Line 361: ,p_trb_information7 in varchar2 default hr_api.g_varchar2

357: ,p_trb_information3 in varchar2 default hr_api.g_varchar2
358: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
364: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
365: ,p_trb_information11 in varchar2 default hr_api.g_varchar2

Line 362: ,p_trb_information8 in varchar2 default hr_api.g_varchar2

358: ,p_trb_information4 in varchar2 default hr_api.g_varchar2
359: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
364: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
365: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
366: ,p_trb_information12 in varchar2 default hr_api.g_varchar2

Line 363: ,p_trb_information9 in varchar2 default hr_api.g_varchar2

359: ,p_trb_information5 in varchar2 default hr_api.g_varchar2
360: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
364: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
365: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
366: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
367: ,p_trb_information13 in varchar2 default hr_api.g_varchar2

Line 364: ,p_trb_information10 in varchar2 default hr_api.g_varchar2

360: ,p_trb_information6 in varchar2 default hr_api.g_varchar2
361: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
364: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
365: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
366: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
367: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
368: ,p_trb_information14 in varchar2 default hr_api.g_varchar2

Line 365: ,p_trb_information11 in varchar2 default hr_api.g_varchar2

361: ,p_trb_information7 in varchar2 default hr_api.g_varchar2
362: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
364: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
365: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
366: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
367: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
368: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
369: ,p_trb_information15 in varchar2 default hr_api.g_varchar2

Line 366: ,p_trb_information12 in varchar2 default hr_api.g_varchar2

362: ,p_trb_information8 in varchar2 default hr_api.g_varchar2
363: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
364: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
365: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
366: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
367: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
368: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
369: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
370: ,p_trb_information16 in varchar2 default hr_api.g_varchar2

Line 367: ,p_trb_information13 in varchar2 default hr_api.g_varchar2

363: ,p_trb_information9 in varchar2 default hr_api.g_varchar2
364: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
365: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
366: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
367: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
368: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
369: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
370: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
371: ,p_trb_information17 in varchar2 default hr_api.g_varchar2

Line 368: ,p_trb_information14 in varchar2 default hr_api.g_varchar2

364: ,p_trb_information10 in varchar2 default hr_api.g_varchar2
365: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
366: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
367: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
368: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
369: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
370: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
371: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
372: ,p_trb_information18 in varchar2 default hr_api.g_varchar2

Line 369: ,p_trb_information15 in varchar2 default hr_api.g_varchar2

365: ,p_trb_information11 in varchar2 default hr_api.g_varchar2
366: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
367: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
368: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
369: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
370: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
371: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
372: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
373: ,p_trb_information19 in varchar2 default hr_api.g_varchar2

Line 370: ,p_trb_information16 in varchar2 default hr_api.g_varchar2

366: ,p_trb_information12 in varchar2 default hr_api.g_varchar2
367: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
368: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
369: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
370: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
371: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
372: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
373: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
374: ,p_trb_information20 in varchar2 default hr_api.g_varchar2

Line 371: ,p_trb_information17 in varchar2 default hr_api.g_varchar2

367: ,p_trb_information13 in varchar2 default hr_api.g_varchar2
368: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
369: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
370: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
371: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
372: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
373: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
374: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
375: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2

Line 372: ,p_trb_information18 in varchar2 default hr_api.g_varchar2

368: ,p_trb_information14 in varchar2 default hr_api.g_varchar2
369: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
370: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
371: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
372: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
373: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
374: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
375: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
376: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2

Line 373: ,p_trb_information19 in varchar2 default hr_api.g_varchar2

369: ,p_trb_information15 in varchar2 default hr_api.g_varchar2
370: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
371: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
372: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
373: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
374: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
375: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
376: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
377: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2

Line 374: ,p_trb_information20 in varchar2 default hr_api.g_varchar2

370: ,p_trb_information16 in varchar2 default hr_api.g_varchar2
371: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
372: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
373: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
374: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
375: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
376: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
377: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2
378: ,p_chat_id in number default hr_api.g_number

Line 375: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2

371: ,p_trb_information17 in varchar2 default hr_api.g_varchar2
372: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
373: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
374: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
375: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
376: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
377: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2
378: ,p_chat_id in number default hr_api.g_number
379: ,p_forum_id in number default hr_api.g_number

Line 376: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2

372: ,p_trb_information18 in varchar2 default hr_api.g_varchar2
373: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
374: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
375: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
376: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
377: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2
378: ,p_chat_id in number default hr_api.g_number
379: ,p_forum_id in number default hr_api.g_number
380: ,p_validate in boolean

Line 377: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2

373: ,p_trb_information19 in varchar2 default hr_api.g_varchar2
374: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
375: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
376: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
377: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2
378: ,p_chat_id in number default hr_api.g_number
379: ,p_forum_id in number default hr_api.g_number
380: ,p_validate in boolean
381: ,p_resource_booking_id in number

Line 378: ,p_chat_id in number default hr_api.g_number

374: ,p_trb_information20 in varchar2 default hr_api.g_varchar2
375: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
376: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
377: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2
378: ,p_chat_id in number default hr_api.g_number
379: ,p_forum_id in number default hr_api.g_number
380: ,p_validate in boolean
381: ,p_resource_booking_id in number
382: ,p_object_version_number in out nocopy number

Line 379: ,p_forum_id in number default hr_api.g_number

375: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
376: ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
377: -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2
378: ,p_chat_id in number default hr_api.g_number
379: ,p_forum_id in number default hr_api.g_number
380: ,p_validate in boolean
381: ,p_resource_booking_id in number
382: ,p_object_version_number in out nocopy number
383: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 383: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

379: ,p_forum_id in number default hr_api.g_number
380: ,p_validate in boolean
381: ,p_resource_booking_id in number
382: ,p_object_version_number in out nocopy number
383: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
384: ) is
385: --
386: -- Declare cursors and local variables
387: --

Line 491: when hr_api.cannot_find_prog_unit then

487: ,p_timezone_code => p_timezone_code
488: );
489:
490: exception
491: when hr_api.cannot_find_prog_unit then
492: hr_api.cannot_find_prog_unit_error
493: (p_module_name => 'update_resource_booking'
494: ,p_hook_type => 'BP'
495: );

Line 492: hr_api.cannot_find_prog_unit_error

488: );
489:
490: exception
491: when hr_api.cannot_find_prog_unit then
492: hr_api.cannot_find_prog_unit_error
493: (p_module_name => 'update_resource_booking'
494: ,p_hook_type => 'BP'
495: );
496: end;

Line 610: when hr_api.cannot_find_prog_unit then

606: ,p_timezone_code => p_timezone_code
607: );
608:
609: exception
610: when hr_api.cannot_find_prog_unit then
611: hr_api.cannot_find_prog_unit_error
612: (p_module_name => 'update_resource_booking'
613: ,p_hook_type => 'AP'
614: );

Line 611: hr_api.cannot_find_prog_unit_error

607: );
608:
609: exception
610: when hr_api.cannot_find_prog_unit then
611: hr_api.cannot_find_prog_unit_error
612: (p_module_name => 'update_resource_booking'
613: ,p_hook_type => 'AP'
614: );
615: end;

Line 620: raise hr_api.validate_enabled;

616: --
617: -- When in validation only mode raise the Validate_Enabled exception
618: --
619: if p_validate then
620: raise hr_api.validate_enabled;
621: end if;
622: --
623: -- Set all output arguments
624: --

Line 663: when hr_api.validate_enabled then

659: end if;
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 70);
662: exception
663: when hr_api.validate_enabled then
664: --
665: -- As the Validate_Enabled exception has been raised
666: -- we must rollback to the savepoint
667: --

Line 753: when hr_api.cannot_find_prog_unit then

749: p_object_version_number => p_object_version_number,
750: p_validate => p_validate);
751:
752: exception
753: when hr_api.cannot_find_prog_unit then
754: hr_api.cannot_find_prog_unit_error
755: (p_module_name => 'delete_resource_booking'
756: ,p_hook_type => 'BP'
757: );

Line 754: hr_api.cannot_find_prog_unit_error

750: p_validate => p_validate);
751:
752: exception
753: when hr_api.cannot_find_prog_unit then
754: hr_api.cannot_find_prog_unit_error
755: (p_module_name => 'delete_resource_booking'
756: ,p_hook_type => 'BP'
757: );
758: end;

Line 778: when hr_api.cannot_find_prog_unit then

774: (p_resource_booking_id => p_resource_booking_id ,
775: p_object_version_number => p_object_version_number,
776: p_validate => p_validate);
777: exception
778: when hr_api.cannot_find_prog_unit then
779: hr_api.cannot_find_prog_unit_error
780: (p_module_name => 'delete_resource_booking'
781: ,p_hook_type => 'AP'
782: );

Line 779: hr_api.cannot_find_prog_unit_error

775: p_object_version_number => p_object_version_number,
776: p_validate => p_validate);
777: exception
778: when hr_api.cannot_find_prog_unit then
779: hr_api.cannot_find_prog_unit_error
780: (p_module_name => 'delete_resource_booking'
781: ,p_hook_type => 'AP'
782: );
783: end;

Line 788: raise hr_api.validate_enabled;

784: --
785: -- When in validation only mode raise the Validate_Enabled exception
786: --
787: if p_validate then
788: raise hr_api.validate_enabled;
789: end if;
790: -- Set all output arguments
791: if l_person_id is not null and l_event_id is not null then
792:

Line 815: when hr_api.validate_enabled then

811: --
812: --
813: hr_utility.set_location(' Leaving:'||l_proc, 170);
814: exception
815: when hr_api.validate_enabled then
816: --
817: -- As the Validate_Enabled exception has been raised
818: -- we must rollback to the savepoint
819: --