DBA Data[Home] [Help]

APPS.OTA_BST_API dependencies on HR_API

Line 293: -- another user. This will raise the HR_Api.Object_Locked exception.

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

Line 304: -- call to hr_api.mandatory_arg_error procedure to ensure that these

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: -- ----------------------------------------------------------------------------

Line 354: -- by raising and handling the exception hr_api.validate_enabled. We use

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: --

Line 498: -- by raising and handling the exception hr_api.validate_enabled. We use

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: --

Line 564: p_business_group_id in number default hr_api.g_number,

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,

Line 565: p_active_flag in varchar2 default hr_api.g_varchar2,

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,

Line 566: p_default_flag 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,

Line 567: p_name 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,

Line 569: p_type 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,

Line 570: p_comments 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,

Line 571: p_description 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,

Line 572: p_bst_information_category 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,

Line 573: p_bst_information1 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,

Line 574: p_bst_information2 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,

Line 575: p_bst_information3 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,

Line 576: p_bst_information4 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,

Line 577: p_bst_information5 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,

Line 578: p_bst_information6 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,

Line 579: p_bst_information7 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,

Line 580: p_bst_information8 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,

Line 581: p_bst_information9 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,

Line 582: p_bst_information10 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,

Line 583: p_bst_information11 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,

Line 584: p_bst_information12 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,

Line 585: p_bst_information13 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,

Line 586: p_bst_information14 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,

Line 587: p_bst_information15 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,

Line 588: p_bst_information16 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,

Line 589: p_bst_information17 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

Line 590: p_bst_information18 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
594: );

Line 591: p_bst_information19 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: );
595: --

Line 592: p_bst_information20 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: --
596: -- ----------------------------------------------------------------------------

Line 633: -- by raising and handling the exception hr_api.validate_enabled. We use

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: --