103: ,p_bst_information20 => p_bst_information20
104: -- ,p_data_source => p_data_source
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'CREATE_BOOKING_STATUS_TYPE'
110: ,p_hook_type => 'BP'
111: );
104: -- ,p_data_source => p_data_source
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'CREATE_BOOKING_STATUS_TYPE'
110: ,p_hook_type => 'BP'
111: );
112: end;
206: ,p_object_version_number => l_object_version_number
207: -- ,p_data_source => p_data_source
208: );
209: exception
210: when hr_api.cannot_find_prog_unit then
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'CREATE_BOOKING_STATUS_TYPE'
213: ,p_hook_type => 'AP'
214: );
207: -- ,p_data_source => p_data_source
208: );
209: exception
210: when hr_api.cannot_find_prog_unit then
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'CREATE_BOOKING_STATUS_TYPE'
213: ,p_hook_type => 'AP'
214: );
215: end;
217: --
218: -- When in validation only mode raise the Validate_Enabled exception
219: --
220: if p_validate then
221: raise hr_api.validate_enabled;
222: end if;
223: --
224: -- Set all output arguments
225: --
228:
229:
230: hr_utility.set_location(' Leaving:'||l_proc, 70);
231: exception
232: when hr_api.validate_enabled then
233: --
234: -- As the Validate_Enabled exception has been raised
235: -- we must rollback to the savepoint
236: --
260: procedure UPDATE_BOOKING_STATUS_TYPE
261: (p_validate in boolean default false
262: ,p_effective_date in date
263: ,p_business_group_id in number
264: ,p_active_flag in varchar2 default hr_api.g_varchar2
265: ,p_default_flag in varchar2 default hr_api.g_varchar2
266: ,p_name in varchar2 default hr_api.g_varchar2
267: ,p_type in varchar2 default hr_api.g_varchar2
268: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
261: (p_validate in boolean default false
262: ,p_effective_date in date
263: ,p_business_group_id in number
264: ,p_active_flag in varchar2 default hr_api.g_varchar2
265: ,p_default_flag in varchar2 default hr_api.g_varchar2
266: ,p_name in varchar2 default hr_api.g_varchar2
267: ,p_type in varchar2 default hr_api.g_varchar2
268: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
269: ,p_comments in varchar2 default hr_api.g_varchar2
262: ,p_effective_date in date
263: ,p_business_group_id in number
264: ,p_active_flag in varchar2 default hr_api.g_varchar2
265: ,p_default_flag in varchar2 default hr_api.g_varchar2
266: ,p_name in varchar2 default hr_api.g_varchar2
267: ,p_type in varchar2 default hr_api.g_varchar2
268: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_description in varchar2 default hr_api.g_varchar2
263: ,p_business_group_id in number
264: ,p_active_flag in varchar2 default hr_api.g_varchar2
265: ,p_default_flag in varchar2 default hr_api.g_varchar2
266: ,p_name in varchar2 default hr_api.g_varchar2
267: ,p_type in varchar2 default hr_api.g_varchar2
268: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_description in varchar2 default hr_api.g_varchar2
271: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
264: ,p_active_flag in varchar2 default hr_api.g_varchar2
265: ,p_default_flag in varchar2 default hr_api.g_varchar2
266: ,p_name in varchar2 default hr_api.g_varchar2
267: ,p_type in varchar2 default hr_api.g_varchar2
268: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_description in varchar2 default hr_api.g_varchar2
271: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
272: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
265: ,p_default_flag in varchar2 default hr_api.g_varchar2
266: ,p_name in varchar2 default hr_api.g_varchar2
267: ,p_type in varchar2 default hr_api.g_varchar2
268: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_description in varchar2 default hr_api.g_varchar2
271: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
272: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
273: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
266: ,p_name in varchar2 default hr_api.g_varchar2
267: ,p_type in varchar2 default hr_api.g_varchar2
268: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_description in varchar2 default hr_api.g_varchar2
271: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
272: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
273: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
274: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
267: ,p_type in varchar2 default hr_api.g_varchar2
268: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_description in varchar2 default hr_api.g_varchar2
271: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
272: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
273: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
274: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
275: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
268: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_description in varchar2 default hr_api.g_varchar2
271: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
272: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
273: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
274: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
275: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
276: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_description in varchar2 default hr_api.g_varchar2
271: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
272: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
273: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
274: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
275: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
276: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
277: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
270: ,p_description in varchar2 default hr_api.g_varchar2
271: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
272: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
273: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
274: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
275: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
276: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
277: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
278: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
271: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
272: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
273: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
274: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
275: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
276: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
277: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
278: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
279: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
272: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
273: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
274: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
275: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
276: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
277: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
278: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
279: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
280: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
273: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
274: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
275: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
276: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
277: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
278: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
279: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
280: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
281: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
274: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
275: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
276: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
277: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
278: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
279: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
280: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
281: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
282: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
275: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
276: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
277: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
278: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
279: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
280: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
281: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
282: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
283: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
276: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
277: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
278: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
279: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
280: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
281: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
282: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
283: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
284: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
277: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
278: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
279: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
280: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
281: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
282: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
283: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
284: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
285: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
278: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
279: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
280: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
281: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
282: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
283: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
284: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
285: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
286: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
279: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
280: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
281: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
282: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
283: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
284: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
285: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
286: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
287: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
280: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
281: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
282: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
283: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
284: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
285: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
286: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
287: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
288: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
281: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
282: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
283: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
284: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
285: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
286: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
287: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
288: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
289: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
282: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
283: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
284: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
285: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
286: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
287: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
288: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
289: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
290: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
283: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
284: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
285: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
286: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
287: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
288: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
289: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
290: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
291: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
284: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
285: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
286: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
287: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
288: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
289: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
290: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
291: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
292: ,p_booking_status_type_id in number default hr_api.g_number
285: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
286: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
287: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
288: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
289: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
290: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
291: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
292: ,p_booking_status_type_id in number default hr_api.g_number
293: ,p_object_version_number in out nocopy number
286: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
287: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
288: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
289: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
290: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
291: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
292: ,p_booking_status_type_id in number default hr_api.g_number
293: ,p_object_version_number in out nocopy number
294: -- ,p_data_source in varchar2 default hr_api.g_varchar2
287: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
288: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
289: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
290: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
291: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
292: ,p_booking_status_type_id in number default hr_api.g_number
293: ,p_object_version_number in out nocopy number
294: -- ,p_data_source in varchar2 default hr_api.g_varchar2
295: ) is
288: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
289: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
290: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
291: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
292: ,p_booking_status_type_id in number default hr_api.g_number
293: ,p_object_version_number in out nocopy number
294: -- ,p_data_source in varchar2 default hr_api.g_varchar2
295: ) is
296: --
290: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
291: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
292: ,p_booking_status_type_id in number default hr_api.g_number
293: ,p_object_version_number in out nocopy number
294: -- ,p_data_source in varchar2 default hr_api.g_varchar2
295: ) is
296: --
297: -- Declare cursors and local variables
298: --
351: ,p_object_version_number => p_object_version_number
352: -- ,p_data_source => p_data_source
353: );
354: exception
355: when hr_api.cannot_find_prog_unit then
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'UPDATE_BOOKING_STATUS_TYPE'
358: ,p_hook_type => 'BP'
359: );
352: -- ,p_data_source => p_data_source
353: );
354: exception
355: when hr_api.cannot_find_prog_unit then
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'UPDATE_BOOKING_STATUS_TYPE'
358: ,p_hook_type => 'BP'
359: );
360: end;
445: ,p_object_version_number => p_object_version_number
446: -- ,p_data_source => p_data_source
447: );
448: exception
449: when hr_api.cannot_find_prog_unit then
450: hr_api.cannot_find_prog_unit_error
451: (p_module_name => 'UPDATE_BOOKING_STATUS_TYPE'
452: ,p_hook_type => 'AP'
453: );
446: -- ,p_data_source => p_data_source
447: );
448: exception
449: when hr_api.cannot_find_prog_unit then
450: hr_api.cannot_find_prog_unit_error
451: (p_module_name => 'UPDATE_BOOKING_STATUS_TYPE'
452: ,p_hook_type => 'AP'
453: );
454: end;
456: --
457: -- When in validation only mode raise the Validate_Enabled exception
458: --
459: if p_validate then
460: raise hr_api.validate_enabled;
461: end if;
462: --
463: -- Set all output arguments
464: --
463: -- Set all output arguments
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 70);
466: exception
467: when hr_api.validate_enabled then
468: --
469: -- As the Validate_Enabled exception has been raised
470: -- we must rollback to the savepoint
471: --
521: (p_BOOKING_STATUS_TYPE_id => p_BOOKING_STATUS_TYPE_id
522: ,p_object_version_number => p_object_version_number
523: );
524: exception
525: when hr_api.cannot_find_prog_unit then
526: hr_api.cannot_find_prog_unit_error
527: (p_module_name => 'DELETE_BOOKING_STATUS_TYPE'
528: ,p_hook_type => 'BP'
529: );
522: ,p_object_version_number => p_object_version_number
523: );
524: exception
525: when hr_api.cannot_find_prog_unit then
526: hr_api.cannot_find_prog_unit_error
527: (p_module_name => 'DELETE_BOOKING_STATUS_TYPE'
528: ,p_hook_type => 'BP'
529: );
530: end;
552: (P_BOOKING_STATUS_TYPE_ID => P_BOOKING_STATUS_TYPE_ID
553: ,p_object_version_number => p_object_version_number
554: );
555: exception
556: when hr_api.cannot_find_prog_unit then
557: hr_api.cannot_find_prog_unit_error
558: (p_module_name => 'DELETE_BOOKING_STATUS_TYPE'
559: ,p_hook_type => 'AP'
560: );
553: ,p_object_version_number => p_object_version_number
554: );
555: exception
556: when hr_api.cannot_find_prog_unit then
557: hr_api.cannot_find_prog_unit_error
558: (p_module_name => 'DELETE_BOOKING_STATUS_TYPE'
559: ,p_hook_type => 'AP'
560: );
561: end;
563: --
564: -- When in validation only mode raise the Validate_Enabled exception
565: --
566: if p_validate then
567: raise hr_api.validate_enabled;
568: end if;
569: --
570: -- Set all output arguments
571: --
571: --
572: --
573: hr_utility.set_location(' Leaving:'||l_proc, 170);
574: exception
575: when hr_api.validate_enabled then
576: --
577: -- As the Validate_Enabled exception has been raised
578: -- we must rollback to the savepoint
579: --