289: --
290: -- Post Failure:
291: -- The Lck process can fail for three reasons:
292: -- 1) When attempting to lock the row the row could already be locked by
293: -- another user. This will raise the HR_Api.Object_Locked exception.
294: -- 2) The row which is required to be locked doesn't exist in the HR Schema.
295: -- This error is trapped and reported using the message name
296: -- 'HR_7220_INVALID_PRIMARY_KEY'.
297: -- 3) The row although existing in the HR Schema has a different object
300: -- 'HR_7155_OBJECT_INVALID'.
301: --
302: -- Developer Implementation Notes:
303: -- For each primary key and the object version number arguments add a
304: -- call to hr_api.mandatory_arg_error procedure to ensure that these
305: -- argument values are not null.
306: --
307: -- {End Of Comments}
308: -- ----------------------------------------------------------------------------
350: -- default is false. The validation is controlled by a savepoint and
351: -- rollback mechanism. The savepoint is issued at the beginning of the
352: -- business process and is rollbacked at the end of the business process
353: -- when all the processing has been completed. The rollback is controlled
354: -- by raising and handling the exception hr_api.validate_enabled. We use
355: -- the exception because, by raising the exception with the business
356: -- process, we can exit successfully without having any of the 'OUT'
357: -- arguments being set.
358: --
494: -- default is false. The validation is controlled by a savepoint and
495: -- rollback mechanism. The savepoint is issued at the beginning of the
496: -- business process and is rollbacked at the end of the business process
497: -- when all the processing has been completed. The rollback is controlled
498: -- by raising and handling the exception hr_api.validate_enabled. We use
499: -- the exception because, by raising the exception with the business
500: -- process, we can exit successfully without having any of the 'OUT'
501: -- arguments being set.
502: --
560: -- ----------------------------------------------------------------------------
561: Procedure upd
562: (
563: p_booking_status_type_id in number,
564: p_business_group_id in number default hr_api.g_number,
565: p_active_flag in varchar2 default hr_api.g_varchar2,
566: p_default_flag in varchar2 default hr_api.g_varchar2,
567: p_name in varchar2 default hr_api.g_varchar2,
568: p_object_version_number in out nocopy number,
561: Procedure upd
562: (
563: p_booking_status_type_id in number,
564: p_business_group_id in number default hr_api.g_number,
565: p_active_flag in varchar2 default hr_api.g_varchar2,
566: p_default_flag in varchar2 default hr_api.g_varchar2,
567: p_name in varchar2 default hr_api.g_varchar2,
568: p_object_version_number in out nocopy number,
569: p_type in varchar2 default hr_api.g_varchar2,
562: (
563: p_booking_status_type_id in number,
564: p_business_group_id in number default hr_api.g_number,
565: p_active_flag in varchar2 default hr_api.g_varchar2,
566: p_default_flag in varchar2 default hr_api.g_varchar2,
567: p_name in varchar2 default hr_api.g_varchar2,
568: p_object_version_number in out nocopy number,
569: p_type in varchar2 default hr_api.g_varchar2,
570: p_comments in varchar2 default hr_api.g_varchar2,
563: p_booking_status_type_id in number,
564: p_business_group_id in number default hr_api.g_number,
565: p_active_flag in varchar2 default hr_api.g_varchar2,
566: p_default_flag in varchar2 default hr_api.g_varchar2,
567: p_name in varchar2 default hr_api.g_varchar2,
568: p_object_version_number in out nocopy number,
569: p_type in varchar2 default hr_api.g_varchar2,
570: p_comments in varchar2 default hr_api.g_varchar2,
571: p_description in varchar2 default hr_api.g_varchar2,
565: p_active_flag in varchar2 default hr_api.g_varchar2,
566: p_default_flag in varchar2 default hr_api.g_varchar2,
567: p_name in varchar2 default hr_api.g_varchar2,
568: p_object_version_number in out nocopy number,
569: p_type in varchar2 default hr_api.g_varchar2,
570: p_comments in varchar2 default hr_api.g_varchar2,
571: p_description in varchar2 default hr_api.g_varchar2,
572: p_bst_information_category in varchar2 default hr_api.g_varchar2,
573: p_bst_information1 in varchar2 default hr_api.g_varchar2,
566: p_default_flag in varchar2 default hr_api.g_varchar2,
567: p_name in varchar2 default hr_api.g_varchar2,
568: p_object_version_number in out nocopy number,
569: p_type in varchar2 default hr_api.g_varchar2,
570: p_comments in varchar2 default hr_api.g_varchar2,
571: p_description in varchar2 default hr_api.g_varchar2,
572: p_bst_information_category in varchar2 default hr_api.g_varchar2,
573: p_bst_information1 in varchar2 default hr_api.g_varchar2,
574: p_bst_information2 in varchar2 default hr_api.g_varchar2,
567: p_name in varchar2 default hr_api.g_varchar2,
568: p_object_version_number in out nocopy number,
569: p_type in varchar2 default hr_api.g_varchar2,
570: p_comments in varchar2 default hr_api.g_varchar2,
571: p_description in varchar2 default hr_api.g_varchar2,
572: p_bst_information_category in varchar2 default hr_api.g_varchar2,
573: p_bst_information1 in varchar2 default hr_api.g_varchar2,
574: p_bst_information2 in varchar2 default hr_api.g_varchar2,
575: p_bst_information3 in varchar2 default hr_api.g_varchar2,
568: p_object_version_number in out nocopy number,
569: p_type in varchar2 default hr_api.g_varchar2,
570: p_comments in varchar2 default hr_api.g_varchar2,
571: p_description in varchar2 default hr_api.g_varchar2,
572: p_bst_information_category in varchar2 default hr_api.g_varchar2,
573: p_bst_information1 in varchar2 default hr_api.g_varchar2,
574: p_bst_information2 in varchar2 default hr_api.g_varchar2,
575: p_bst_information3 in varchar2 default hr_api.g_varchar2,
576: p_bst_information4 in varchar2 default hr_api.g_varchar2,
569: p_type in varchar2 default hr_api.g_varchar2,
570: p_comments in varchar2 default hr_api.g_varchar2,
571: p_description in varchar2 default hr_api.g_varchar2,
572: p_bst_information_category in varchar2 default hr_api.g_varchar2,
573: p_bst_information1 in varchar2 default hr_api.g_varchar2,
574: p_bst_information2 in varchar2 default hr_api.g_varchar2,
575: p_bst_information3 in varchar2 default hr_api.g_varchar2,
576: p_bst_information4 in varchar2 default hr_api.g_varchar2,
577: p_bst_information5 in varchar2 default hr_api.g_varchar2,
570: p_comments in varchar2 default hr_api.g_varchar2,
571: p_description in varchar2 default hr_api.g_varchar2,
572: p_bst_information_category in varchar2 default hr_api.g_varchar2,
573: p_bst_information1 in varchar2 default hr_api.g_varchar2,
574: p_bst_information2 in varchar2 default hr_api.g_varchar2,
575: p_bst_information3 in varchar2 default hr_api.g_varchar2,
576: p_bst_information4 in varchar2 default hr_api.g_varchar2,
577: p_bst_information5 in varchar2 default hr_api.g_varchar2,
578: p_bst_information6 in varchar2 default hr_api.g_varchar2,
571: p_description in varchar2 default hr_api.g_varchar2,
572: p_bst_information_category in varchar2 default hr_api.g_varchar2,
573: p_bst_information1 in varchar2 default hr_api.g_varchar2,
574: p_bst_information2 in varchar2 default hr_api.g_varchar2,
575: p_bst_information3 in varchar2 default hr_api.g_varchar2,
576: p_bst_information4 in varchar2 default hr_api.g_varchar2,
577: p_bst_information5 in varchar2 default hr_api.g_varchar2,
578: p_bst_information6 in varchar2 default hr_api.g_varchar2,
579: p_bst_information7 in varchar2 default hr_api.g_varchar2,
572: p_bst_information_category in varchar2 default hr_api.g_varchar2,
573: p_bst_information1 in varchar2 default hr_api.g_varchar2,
574: p_bst_information2 in varchar2 default hr_api.g_varchar2,
575: p_bst_information3 in varchar2 default hr_api.g_varchar2,
576: p_bst_information4 in varchar2 default hr_api.g_varchar2,
577: p_bst_information5 in varchar2 default hr_api.g_varchar2,
578: p_bst_information6 in varchar2 default hr_api.g_varchar2,
579: p_bst_information7 in varchar2 default hr_api.g_varchar2,
580: p_bst_information8 in varchar2 default hr_api.g_varchar2,
573: p_bst_information1 in varchar2 default hr_api.g_varchar2,
574: p_bst_information2 in varchar2 default hr_api.g_varchar2,
575: p_bst_information3 in varchar2 default hr_api.g_varchar2,
576: p_bst_information4 in varchar2 default hr_api.g_varchar2,
577: p_bst_information5 in varchar2 default hr_api.g_varchar2,
578: p_bst_information6 in varchar2 default hr_api.g_varchar2,
579: p_bst_information7 in varchar2 default hr_api.g_varchar2,
580: p_bst_information8 in varchar2 default hr_api.g_varchar2,
581: p_bst_information9 in varchar2 default hr_api.g_varchar2,
574: p_bst_information2 in varchar2 default hr_api.g_varchar2,
575: p_bst_information3 in varchar2 default hr_api.g_varchar2,
576: p_bst_information4 in varchar2 default hr_api.g_varchar2,
577: p_bst_information5 in varchar2 default hr_api.g_varchar2,
578: p_bst_information6 in varchar2 default hr_api.g_varchar2,
579: p_bst_information7 in varchar2 default hr_api.g_varchar2,
580: p_bst_information8 in varchar2 default hr_api.g_varchar2,
581: p_bst_information9 in varchar2 default hr_api.g_varchar2,
582: p_bst_information10 in varchar2 default hr_api.g_varchar2,
575: p_bst_information3 in varchar2 default hr_api.g_varchar2,
576: p_bst_information4 in varchar2 default hr_api.g_varchar2,
577: p_bst_information5 in varchar2 default hr_api.g_varchar2,
578: p_bst_information6 in varchar2 default hr_api.g_varchar2,
579: p_bst_information7 in varchar2 default hr_api.g_varchar2,
580: p_bst_information8 in varchar2 default hr_api.g_varchar2,
581: p_bst_information9 in varchar2 default hr_api.g_varchar2,
582: p_bst_information10 in varchar2 default hr_api.g_varchar2,
583: p_bst_information11 in varchar2 default hr_api.g_varchar2,
576: p_bst_information4 in varchar2 default hr_api.g_varchar2,
577: p_bst_information5 in varchar2 default hr_api.g_varchar2,
578: p_bst_information6 in varchar2 default hr_api.g_varchar2,
579: p_bst_information7 in varchar2 default hr_api.g_varchar2,
580: p_bst_information8 in varchar2 default hr_api.g_varchar2,
581: p_bst_information9 in varchar2 default hr_api.g_varchar2,
582: p_bst_information10 in varchar2 default hr_api.g_varchar2,
583: p_bst_information11 in varchar2 default hr_api.g_varchar2,
584: p_bst_information12 in varchar2 default hr_api.g_varchar2,
577: p_bst_information5 in varchar2 default hr_api.g_varchar2,
578: p_bst_information6 in varchar2 default hr_api.g_varchar2,
579: p_bst_information7 in varchar2 default hr_api.g_varchar2,
580: p_bst_information8 in varchar2 default hr_api.g_varchar2,
581: p_bst_information9 in varchar2 default hr_api.g_varchar2,
582: p_bst_information10 in varchar2 default hr_api.g_varchar2,
583: p_bst_information11 in varchar2 default hr_api.g_varchar2,
584: p_bst_information12 in varchar2 default hr_api.g_varchar2,
585: p_bst_information13 in varchar2 default hr_api.g_varchar2,
578: p_bst_information6 in varchar2 default hr_api.g_varchar2,
579: p_bst_information7 in varchar2 default hr_api.g_varchar2,
580: p_bst_information8 in varchar2 default hr_api.g_varchar2,
581: p_bst_information9 in varchar2 default hr_api.g_varchar2,
582: p_bst_information10 in varchar2 default hr_api.g_varchar2,
583: p_bst_information11 in varchar2 default hr_api.g_varchar2,
584: p_bst_information12 in varchar2 default hr_api.g_varchar2,
585: p_bst_information13 in varchar2 default hr_api.g_varchar2,
586: p_bst_information14 in varchar2 default hr_api.g_varchar2,
579: p_bst_information7 in varchar2 default hr_api.g_varchar2,
580: p_bst_information8 in varchar2 default hr_api.g_varchar2,
581: p_bst_information9 in varchar2 default hr_api.g_varchar2,
582: p_bst_information10 in varchar2 default hr_api.g_varchar2,
583: p_bst_information11 in varchar2 default hr_api.g_varchar2,
584: p_bst_information12 in varchar2 default hr_api.g_varchar2,
585: p_bst_information13 in varchar2 default hr_api.g_varchar2,
586: p_bst_information14 in varchar2 default hr_api.g_varchar2,
587: p_bst_information15 in varchar2 default hr_api.g_varchar2,
580: p_bst_information8 in varchar2 default hr_api.g_varchar2,
581: p_bst_information9 in varchar2 default hr_api.g_varchar2,
582: p_bst_information10 in varchar2 default hr_api.g_varchar2,
583: p_bst_information11 in varchar2 default hr_api.g_varchar2,
584: p_bst_information12 in varchar2 default hr_api.g_varchar2,
585: p_bst_information13 in varchar2 default hr_api.g_varchar2,
586: p_bst_information14 in varchar2 default hr_api.g_varchar2,
587: p_bst_information15 in varchar2 default hr_api.g_varchar2,
588: p_bst_information16 in varchar2 default hr_api.g_varchar2,
581: p_bst_information9 in varchar2 default hr_api.g_varchar2,
582: p_bst_information10 in varchar2 default hr_api.g_varchar2,
583: p_bst_information11 in varchar2 default hr_api.g_varchar2,
584: p_bst_information12 in varchar2 default hr_api.g_varchar2,
585: p_bst_information13 in varchar2 default hr_api.g_varchar2,
586: p_bst_information14 in varchar2 default hr_api.g_varchar2,
587: p_bst_information15 in varchar2 default hr_api.g_varchar2,
588: p_bst_information16 in varchar2 default hr_api.g_varchar2,
589: p_bst_information17 in varchar2 default hr_api.g_varchar2,
582: p_bst_information10 in varchar2 default hr_api.g_varchar2,
583: p_bst_information11 in varchar2 default hr_api.g_varchar2,
584: p_bst_information12 in varchar2 default hr_api.g_varchar2,
585: p_bst_information13 in varchar2 default hr_api.g_varchar2,
586: p_bst_information14 in varchar2 default hr_api.g_varchar2,
587: p_bst_information15 in varchar2 default hr_api.g_varchar2,
588: p_bst_information16 in varchar2 default hr_api.g_varchar2,
589: p_bst_information17 in varchar2 default hr_api.g_varchar2,
590: p_bst_information18 in varchar2 default hr_api.g_varchar2,
583: p_bst_information11 in varchar2 default hr_api.g_varchar2,
584: p_bst_information12 in varchar2 default hr_api.g_varchar2,
585: p_bst_information13 in varchar2 default hr_api.g_varchar2,
586: p_bst_information14 in varchar2 default hr_api.g_varchar2,
587: p_bst_information15 in varchar2 default hr_api.g_varchar2,
588: p_bst_information16 in varchar2 default hr_api.g_varchar2,
589: p_bst_information17 in varchar2 default hr_api.g_varchar2,
590: p_bst_information18 in varchar2 default hr_api.g_varchar2,
591: p_bst_information19 in varchar2 default hr_api.g_varchar2,
584: p_bst_information12 in varchar2 default hr_api.g_varchar2,
585: p_bst_information13 in varchar2 default hr_api.g_varchar2,
586: p_bst_information14 in varchar2 default hr_api.g_varchar2,
587: p_bst_information15 in varchar2 default hr_api.g_varchar2,
588: p_bst_information16 in varchar2 default hr_api.g_varchar2,
589: p_bst_information17 in varchar2 default hr_api.g_varchar2,
590: p_bst_information18 in varchar2 default hr_api.g_varchar2,
591: p_bst_information19 in varchar2 default hr_api.g_varchar2,
592: p_bst_information20 in varchar2 default hr_api.g_varchar2,
585: p_bst_information13 in varchar2 default hr_api.g_varchar2,
586: p_bst_information14 in varchar2 default hr_api.g_varchar2,
587: p_bst_information15 in varchar2 default hr_api.g_varchar2,
588: p_bst_information16 in varchar2 default hr_api.g_varchar2,
589: p_bst_information17 in varchar2 default hr_api.g_varchar2,
590: p_bst_information18 in varchar2 default hr_api.g_varchar2,
591: p_bst_information19 in varchar2 default hr_api.g_varchar2,
592: p_bst_information20 in varchar2 default hr_api.g_varchar2,
593: p_validate in boolean default false
586: p_bst_information14 in varchar2 default hr_api.g_varchar2,
587: p_bst_information15 in varchar2 default hr_api.g_varchar2,
588: p_bst_information16 in varchar2 default hr_api.g_varchar2,
589: p_bst_information17 in varchar2 default hr_api.g_varchar2,
590: p_bst_information18 in varchar2 default hr_api.g_varchar2,
591: p_bst_information19 in varchar2 default hr_api.g_varchar2,
592: p_bst_information20 in varchar2 default hr_api.g_varchar2,
593: p_validate in boolean default false
594: );
587: p_bst_information15 in varchar2 default hr_api.g_varchar2,
588: p_bst_information16 in varchar2 default hr_api.g_varchar2,
589: p_bst_information17 in varchar2 default hr_api.g_varchar2,
590: p_bst_information18 in varchar2 default hr_api.g_varchar2,
591: p_bst_information19 in varchar2 default hr_api.g_varchar2,
592: p_bst_information20 in varchar2 default hr_api.g_varchar2,
593: p_validate in boolean default false
594: );
595: --
588: p_bst_information16 in varchar2 default hr_api.g_varchar2,
589: p_bst_information17 in varchar2 default hr_api.g_varchar2,
590: p_bst_information18 in varchar2 default hr_api.g_varchar2,
591: p_bst_information19 in varchar2 default hr_api.g_varchar2,
592: p_bst_information20 in varchar2 default hr_api.g_varchar2,
593: p_validate in boolean default false
594: );
595: --
596: -- ----------------------------------------------------------------------------
629: -- default is false. The validation is controlled by a savepoint and
630: -- rollback mechanism. The savepoint is issued at the beginning of the
631: -- business process and is rollbacked at the end of the business process
632: -- when all the processing has been completed. The rollback is controlled
633: -- by raising and handling the exception hr_api.validate_enabled. We use
634: -- the exception because, by raising the exception with the business
635: -- process, we can exit successfully without having any of the 'OUT'
636: -- arguments being set.
637: --