DBA Data[Home] [Help]

APPS.OTA_TAD_API dependencies on HR_API

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

192: --
193: -- Post Failure:
194: -- The Lck process can fail for three reasons:
195: -- 1) When attempting to lock the row the row could already be locked by
196: -- another user. This will raise the HR_Api.Object_Locked exception.
197: -- 2) The row which is required to be locked doesn't exist in the HR Schema.
198: -- This error is trapped and reported using the message name
199: -- 'HR_7155_OBJECT_INVALID'.
200: -- 3) The row although existing in the HR Schema has a different object

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

203: -- 'HR_7155_OBJECT_INVALID'.
204: --
205: -- Developer Implementation Notes:
206: -- For each primary key and the object version number arguments add a
207: -- call to hr_api.mandatory_arg_error procedure to ensure that these
208: -- argument values are not null.
209: --
210: -- {End Of Comments}
211: -- ----------------------------------------------------------------------------

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

253: -- default is false. The validation is controlled by a savepoint and
254: -- rollback mechanism. The savepoint is issued at the beginning of the
255: -- business process and is rollbacked at the end of the business process
256: -- when all the processing has been completed. The rollback is controlled
257: -- by raising and handling the exception hr_api.validate_enabled. We use
258: -- the exception because, by raising the exception with the business
259: -- process, we can exit successfully without having any of the 'OUT'
260: -- arguments being set.
261: --

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

396: -- default is false. The validation is controlled by a savepoint and
397: -- rollback mechanism. The savepoint is issued at the beginning of the
398: -- business process and is rollbacked at the end of the business process
399: -- when all the processing has been completed. The rollback is controlled
400: -- by raising and handling the exception hr_api.validate_enabled. We use
401: -- the exception because, by raising the exception with the business
402: -- process, we can exit successfully without having any of the 'OUT'
403: -- arguments being set.
404: --

Line 466: p_business_group_id in number default hr_api.g_number,

462: -- ----------------------------------------------------------------------------
463: Procedure upd
464: (
465: p_activity_id in number,
466: p_business_group_id in number default hr_api.g_number,
467: p_name in varchar2 default hr_api.g_varchar2,
468: p_comments in varchar2 default hr_api.g_varchar2,
469: p_description in varchar2 default hr_api.g_varchar2,
470: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,

Line 467: p_name in varchar2 default hr_api.g_varchar2,

463: Procedure upd
464: (
465: p_activity_id in number,
466: p_business_group_id in number default hr_api.g_number,
467: p_name in varchar2 default hr_api.g_varchar2,
468: p_comments in varchar2 default hr_api.g_varchar2,
469: p_description in varchar2 default hr_api.g_varchar2,
470: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
471: p_object_version_number in out nocopy number,

Line 468: p_comments in varchar2 default hr_api.g_varchar2,

464: (
465: p_activity_id in number,
466: p_business_group_id in number default hr_api.g_number,
467: p_name in varchar2 default hr_api.g_varchar2,
468: p_comments in varchar2 default hr_api.g_varchar2,
469: p_description in varchar2 default hr_api.g_varchar2,
470: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
471: p_object_version_number in out nocopy number,
472: p_tad_information_category in varchar2 default hr_api.g_varchar2,

Line 469: p_description in varchar2 default hr_api.g_varchar2,

465: p_activity_id in number,
466: p_business_group_id in number default hr_api.g_number,
467: p_name in varchar2 default hr_api.g_varchar2,
468: p_comments in varchar2 default hr_api.g_varchar2,
469: p_description in varchar2 default hr_api.g_varchar2,
470: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
471: p_object_version_number in out nocopy number,
472: p_tad_information_category in varchar2 default hr_api.g_varchar2,
473: p_tad_information1 in varchar2 default hr_api.g_varchar2,

Line 470: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,

466: p_business_group_id in number default hr_api.g_number,
467: p_name in varchar2 default hr_api.g_varchar2,
468: p_comments in varchar2 default hr_api.g_varchar2,
469: p_description in varchar2 default hr_api.g_varchar2,
470: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
471: p_object_version_number in out nocopy number,
472: p_tad_information_category in varchar2 default hr_api.g_varchar2,
473: p_tad_information1 in varchar2 default hr_api.g_varchar2,
474: p_tad_information2 in varchar2 default hr_api.g_varchar2,

Line 472: p_tad_information_category in varchar2 default hr_api.g_varchar2,

468: p_comments in varchar2 default hr_api.g_varchar2,
469: p_description in varchar2 default hr_api.g_varchar2,
470: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
471: p_object_version_number in out nocopy number,
472: p_tad_information_category in varchar2 default hr_api.g_varchar2,
473: p_tad_information1 in varchar2 default hr_api.g_varchar2,
474: p_tad_information2 in varchar2 default hr_api.g_varchar2,
475: p_tad_information3 in varchar2 default hr_api.g_varchar2,
476: p_tad_information4 in varchar2 default hr_api.g_varchar2,

Line 473: p_tad_information1 in varchar2 default hr_api.g_varchar2,

469: p_description in varchar2 default hr_api.g_varchar2,
470: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
471: p_object_version_number in out nocopy number,
472: p_tad_information_category in varchar2 default hr_api.g_varchar2,
473: p_tad_information1 in varchar2 default hr_api.g_varchar2,
474: p_tad_information2 in varchar2 default hr_api.g_varchar2,
475: p_tad_information3 in varchar2 default hr_api.g_varchar2,
476: p_tad_information4 in varchar2 default hr_api.g_varchar2,
477: p_tad_information5 in varchar2 default hr_api.g_varchar2,

Line 474: p_tad_information2 in varchar2 default hr_api.g_varchar2,

470: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
471: p_object_version_number in out nocopy number,
472: p_tad_information_category in varchar2 default hr_api.g_varchar2,
473: p_tad_information1 in varchar2 default hr_api.g_varchar2,
474: p_tad_information2 in varchar2 default hr_api.g_varchar2,
475: p_tad_information3 in varchar2 default hr_api.g_varchar2,
476: p_tad_information4 in varchar2 default hr_api.g_varchar2,
477: p_tad_information5 in varchar2 default hr_api.g_varchar2,
478: p_tad_information6 in varchar2 default hr_api.g_varchar2,

Line 475: p_tad_information3 in varchar2 default hr_api.g_varchar2,

471: p_object_version_number in out nocopy number,
472: p_tad_information_category in varchar2 default hr_api.g_varchar2,
473: p_tad_information1 in varchar2 default hr_api.g_varchar2,
474: p_tad_information2 in varchar2 default hr_api.g_varchar2,
475: p_tad_information3 in varchar2 default hr_api.g_varchar2,
476: p_tad_information4 in varchar2 default hr_api.g_varchar2,
477: p_tad_information5 in varchar2 default hr_api.g_varchar2,
478: p_tad_information6 in varchar2 default hr_api.g_varchar2,
479: p_tad_information7 in varchar2 default hr_api.g_varchar2,

Line 476: p_tad_information4 in varchar2 default hr_api.g_varchar2,

472: p_tad_information_category in varchar2 default hr_api.g_varchar2,
473: p_tad_information1 in varchar2 default hr_api.g_varchar2,
474: p_tad_information2 in varchar2 default hr_api.g_varchar2,
475: p_tad_information3 in varchar2 default hr_api.g_varchar2,
476: p_tad_information4 in varchar2 default hr_api.g_varchar2,
477: p_tad_information5 in varchar2 default hr_api.g_varchar2,
478: p_tad_information6 in varchar2 default hr_api.g_varchar2,
479: p_tad_information7 in varchar2 default hr_api.g_varchar2,
480: p_tad_information8 in varchar2 default hr_api.g_varchar2,

Line 477: p_tad_information5 in varchar2 default hr_api.g_varchar2,

473: p_tad_information1 in varchar2 default hr_api.g_varchar2,
474: p_tad_information2 in varchar2 default hr_api.g_varchar2,
475: p_tad_information3 in varchar2 default hr_api.g_varchar2,
476: p_tad_information4 in varchar2 default hr_api.g_varchar2,
477: p_tad_information5 in varchar2 default hr_api.g_varchar2,
478: p_tad_information6 in varchar2 default hr_api.g_varchar2,
479: p_tad_information7 in varchar2 default hr_api.g_varchar2,
480: p_tad_information8 in varchar2 default hr_api.g_varchar2,
481: p_tad_information9 in varchar2 default hr_api.g_varchar2,

Line 478: p_tad_information6 in varchar2 default hr_api.g_varchar2,

474: p_tad_information2 in varchar2 default hr_api.g_varchar2,
475: p_tad_information3 in varchar2 default hr_api.g_varchar2,
476: p_tad_information4 in varchar2 default hr_api.g_varchar2,
477: p_tad_information5 in varchar2 default hr_api.g_varchar2,
478: p_tad_information6 in varchar2 default hr_api.g_varchar2,
479: p_tad_information7 in varchar2 default hr_api.g_varchar2,
480: p_tad_information8 in varchar2 default hr_api.g_varchar2,
481: p_tad_information9 in varchar2 default hr_api.g_varchar2,
482: p_tad_information10 in varchar2 default hr_api.g_varchar2,

Line 479: p_tad_information7 in varchar2 default hr_api.g_varchar2,

475: p_tad_information3 in varchar2 default hr_api.g_varchar2,
476: p_tad_information4 in varchar2 default hr_api.g_varchar2,
477: p_tad_information5 in varchar2 default hr_api.g_varchar2,
478: p_tad_information6 in varchar2 default hr_api.g_varchar2,
479: p_tad_information7 in varchar2 default hr_api.g_varchar2,
480: p_tad_information8 in varchar2 default hr_api.g_varchar2,
481: p_tad_information9 in varchar2 default hr_api.g_varchar2,
482: p_tad_information10 in varchar2 default hr_api.g_varchar2,
483: p_tad_information11 in varchar2 default hr_api.g_varchar2,

Line 480: p_tad_information8 in varchar2 default hr_api.g_varchar2,

476: p_tad_information4 in varchar2 default hr_api.g_varchar2,
477: p_tad_information5 in varchar2 default hr_api.g_varchar2,
478: p_tad_information6 in varchar2 default hr_api.g_varchar2,
479: p_tad_information7 in varchar2 default hr_api.g_varchar2,
480: p_tad_information8 in varchar2 default hr_api.g_varchar2,
481: p_tad_information9 in varchar2 default hr_api.g_varchar2,
482: p_tad_information10 in varchar2 default hr_api.g_varchar2,
483: p_tad_information11 in varchar2 default hr_api.g_varchar2,
484: p_tad_information12 in varchar2 default hr_api.g_varchar2,

Line 481: p_tad_information9 in varchar2 default hr_api.g_varchar2,

477: p_tad_information5 in varchar2 default hr_api.g_varchar2,
478: p_tad_information6 in varchar2 default hr_api.g_varchar2,
479: p_tad_information7 in varchar2 default hr_api.g_varchar2,
480: p_tad_information8 in varchar2 default hr_api.g_varchar2,
481: p_tad_information9 in varchar2 default hr_api.g_varchar2,
482: p_tad_information10 in varchar2 default hr_api.g_varchar2,
483: p_tad_information11 in varchar2 default hr_api.g_varchar2,
484: p_tad_information12 in varchar2 default hr_api.g_varchar2,
485: p_tad_information13 in varchar2 default hr_api.g_varchar2,

Line 482: p_tad_information10 in varchar2 default hr_api.g_varchar2,

478: p_tad_information6 in varchar2 default hr_api.g_varchar2,
479: p_tad_information7 in varchar2 default hr_api.g_varchar2,
480: p_tad_information8 in varchar2 default hr_api.g_varchar2,
481: p_tad_information9 in varchar2 default hr_api.g_varchar2,
482: p_tad_information10 in varchar2 default hr_api.g_varchar2,
483: p_tad_information11 in varchar2 default hr_api.g_varchar2,
484: p_tad_information12 in varchar2 default hr_api.g_varchar2,
485: p_tad_information13 in varchar2 default hr_api.g_varchar2,
486: p_tad_information14 in varchar2 default hr_api.g_varchar2,

Line 483: p_tad_information11 in varchar2 default hr_api.g_varchar2,

479: p_tad_information7 in varchar2 default hr_api.g_varchar2,
480: p_tad_information8 in varchar2 default hr_api.g_varchar2,
481: p_tad_information9 in varchar2 default hr_api.g_varchar2,
482: p_tad_information10 in varchar2 default hr_api.g_varchar2,
483: p_tad_information11 in varchar2 default hr_api.g_varchar2,
484: p_tad_information12 in varchar2 default hr_api.g_varchar2,
485: p_tad_information13 in varchar2 default hr_api.g_varchar2,
486: p_tad_information14 in varchar2 default hr_api.g_varchar2,
487: p_tad_information15 in varchar2 default hr_api.g_varchar2,

Line 484: p_tad_information12 in varchar2 default hr_api.g_varchar2,

480: p_tad_information8 in varchar2 default hr_api.g_varchar2,
481: p_tad_information9 in varchar2 default hr_api.g_varchar2,
482: p_tad_information10 in varchar2 default hr_api.g_varchar2,
483: p_tad_information11 in varchar2 default hr_api.g_varchar2,
484: p_tad_information12 in varchar2 default hr_api.g_varchar2,
485: p_tad_information13 in varchar2 default hr_api.g_varchar2,
486: p_tad_information14 in varchar2 default hr_api.g_varchar2,
487: p_tad_information15 in varchar2 default hr_api.g_varchar2,
488: p_tad_information16 in varchar2 default hr_api.g_varchar2,

Line 485: p_tad_information13 in varchar2 default hr_api.g_varchar2,

481: p_tad_information9 in varchar2 default hr_api.g_varchar2,
482: p_tad_information10 in varchar2 default hr_api.g_varchar2,
483: p_tad_information11 in varchar2 default hr_api.g_varchar2,
484: p_tad_information12 in varchar2 default hr_api.g_varchar2,
485: p_tad_information13 in varchar2 default hr_api.g_varchar2,
486: p_tad_information14 in varchar2 default hr_api.g_varchar2,
487: p_tad_information15 in varchar2 default hr_api.g_varchar2,
488: p_tad_information16 in varchar2 default hr_api.g_varchar2,
489: p_tad_information17 in varchar2 default hr_api.g_varchar2,

Line 486: p_tad_information14 in varchar2 default hr_api.g_varchar2,

482: p_tad_information10 in varchar2 default hr_api.g_varchar2,
483: p_tad_information11 in varchar2 default hr_api.g_varchar2,
484: p_tad_information12 in varchar2 default hr_api.g_varchar2,
485: p_tad_information13 in varchar2 default hr_api.g_varchar2,
486: p_tad_information14 in varchar2 default hr_api.g_varchar2,
487: p_tad_information15 in varchar2 default hr_api.g_varchar2,
488: p_tad_information16 in varchar2 default hr_api.g_varchar2,
489: p_tad_information17 in varchar2 default hr_api.g_varchar2,
490: p_tad_information18 in varchar2 default hr_api.g_varchar2,

Line 487: p_tad_information15 in varchar2 default hr_api.g_varchar2,

483: p_tad_information11 in varchar2 default hr_api.g_varchar2,
484: p_tad_information12 in varchar2 default hr_api.g_varchar2,
485: p_tad_information13 in varchar2 default hr_api.g_varchar2,
486: p_tad_information14 in varchar2 default hr_api.g_varchar2,
487: p_tad_information15 in varchar2 default hr_api.g_varchar2,
488: p_tad_information16 in varchar2 default hr_api.g_varchar2,
489: p_tad_information17 in varchar2 default hr_api.g_varchar2,
490: p_tad_information18 in varchar2 default hr_api.g_varchar2,
491: p_tad_information19 in varchar2 default hr_api.g_varchar2,

Line 488: p_tad_information16 in varchar2 default hr_api.g_varchar2,

484: p_tad_information12 in varchar2 default hr_api.g_varchar2,
485: p_tad_information13 in varchar2 default hr_api.g_varchar2,
486: p_tad_information14 in varchar2 default hr_api.g_varchar2,
487: p_tad_information15 in varchar2 default hr_api.g_varchar2,
488: p_tad_information16 in varchar2 default hr_api.g_varchar2,
489: p_tad_information17 in varchar2 default hr_api.g_varchar2,
490: p_tad_information18 in varchar2 default hr_api.g_varchar2,
491: p_tad_information19 in varchar2 default hr_api.g_varchar2,
492: p_tad_information20 in varchar2 default hr_api.g_varchar2,

Line 489: p_tad_information17 in varchar2 default hr_api.g_varchar2,

485: p_tad_information13 in varchar2 default hr_api.g_varchar2,
486: p_tad_information14 in varchar2 default hr_api.g_varchar2,
487: p_tad_information15 in varchar2 default hr_api.g_varchar2,
488: p_tad_information16 in varchar2 default hr_api.g_varchar2,
489: p_tad_information17 in varchar2 default hr_api.g_varchar2,
490: p_tad_information18 in varchar2 default hr_api.g_varchar2,
491: p_tad_information19 in varchar2 default hr_api.g_varchar2,
492: p_tad_information20 in varchar2 default hr_api.g_varchar2,
493: p_category_usage_id in number default hr_api.g_number,

Line 490: p_tad_information18 in varchar2 default hr_api.g_varchar2,

486: p_tad_information14 in varchar2 default hr_api.g_varchar2,
487: p_tad_information15 in varchar2 default hr_api.g_varchar2,
488: p_tad_information16 in varchar2 default hr_api.g_varchar2,
489: p_tad_information17 in varchar2 default hr_api.g_varchar2,
490: p_tad_information18 in varchar2 default hr_api.g_varchar2,
491: p_tad_information19 in varchar2 default hr_api.g_varchar2,
492: p_tad_information20 in varchar2 default hr_api.g_varchar2,
493: p_category_usage_id in number default hr_api.g_number,
494: p_validate in boolean default false

Line 491: p_tad_information19 in varchar2 default hr_api.g_varchar2,

487: p_tad_information15 in varchar2 default hr_api.g_varchar2,
488: p_tad_information16 in varchar2 default hr_api.g_varchar2,
489: p_tad_information17 in varchar2 default hr_api.g_varchar2,
490: p_tad_information18 in varchar2 default hr_api.g_varchar2,
491: p_tad_information19 in varchar2 default hr_api.g_varchar2,
492: p_tad_information20 in varchar2 default hr_api.g_varchar2,
493: p_category_usage_id in number default hr_api.g_number,
494: p_validate in boolean default false
495: );

Line 492: p_tad_information20 in varchar2 default hr_api.g_varchar2,

488: p_tad_information16 in varchar2 default hr_api.g_varchar2,
489: p_tad_information17 in varchar2 default hr_api.g_varchar2,
490: p_tad_information18 in varchar2 default hr_api.g_varchar2,
491: p_tad_information19 in varchar2 default hr_api.g_varchar2,
492: p_tad_information20 in varchar2 default hr_api.g_varchar2,
493: p_category_usage_id in number default hr_api.g_number,
494: p_validate in boolean default false
495: );
496: --

Line 493: p_category_usage_id in number default hr_api.g_number,

489: p_tad_information17 in varchar2 default hr_api.g_varchar2,
490: p_tad_information18 in varchar2 default hr_api.g_varchar2,
491: p_tad_information19 in varchar2 default hr_api.g_varchar2,
492: p_tad_information20 in varchar2 default hr_api.g_varchar2,
493: p_category_usage_id in number default hr_api.g_number,
494: p_validate in boolean default false
495: );
496: --
497: -- ----------------------------------------------------------------------------

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

530: -- default is false. The validation is controlled by a savepoint and
531: -- rollback mechanism. The savepoint is issued at the beginning of the
532: -- business process and is rollbacked at the end of the business process
533: -- when all the processing has been completed. The rollback is controlled
534: -- by raising and handling the exception hr_api.validate_enabled. We use
535: -- the exception because, by raising the exception with the business
536: -- process, we can exit successfully without having any of the 'OUT'
537: -- arguments being set.
538: --