183: --
184: -- Post Failure:
185: -- The Lck process can fail for three reasons:
186: -- 1) When attempting to lock the row the row could already be locked by
187: -- another user. This will raise the HR_Api.Object_Locked exception.
188: -- 2) The row which is required to be locked doesn't exist in the HR Schema.
189: -- This error is trapped and reported using the message name
190: -- 'HR_7220_INVALID_PRIMARY_KEY'.
191: -- 3) The row although existing in the HR Schema has a different object
194: -- 'HR_7155_OBJECT_INVALID'.
195: --
196: -- Developer Implementation Notes:
197: -- For each primary key and the object version number arguments add a
198: -- call to hr_api.mandatory_arg_error procedure to ensure that these
199: -- argument values are not null.
200: --
201: -- {End Of Comments}
202: -- ----------------------------------------------------------------------------
244: -- default is false. The validation is controlled by a savepoint and
245: -- rollback mechanism. The savepoint is issued at the beginning of the
246: -- business process and is rollbacked at the end of the business process
247: -- when all the processing has been completed. The rollback is controlled
248: -- by raising and handling the exception hr_api.validate_enabled. We use
249: -- the exception because, by raising the exception with the business
250: -- process, we can exit successfully without having any of the 'OUT'
251: -- arguments being set.
252: --
398: -- default is false. The validation is controlled by a savepoint and
399: -- rollback mechanism. The savepoint is issued at the beginning of the
400: -- business process and is rollbacked at the end of the business process
401: -- when all the processing has been completed. The rollback is controlled
402: -- by raising and handling the exception hr_api.validate_enabled. We use
403: -- the exception because, by raising the exception with the business
404: -- process, we can exit successfully without having any of the 'OUT'
405: -- arguments being set.
406: --
464: -- ----------------------------------------------------------------------------
465: Procedure upd
466: (
467: p_booking_deal_id in number,
468: p_customer_id in number default hr_api.g_number,
469: p_approved_by_person_id in number default hr_api.g_number,
470: p_business_group_id in number default hr_api.g_number,
471: p_name in varchar2 default hr_api.g_varchar2,
472: p_object_version_number in out nocopy number,
465: Procedure upd
466: (
467: p_booking_deal_id in number,
468: p_customer_id in number default hr_api.g_number,
469: p_approved_by_person_id in number default hr_api.g_number,
470: p_business_group_id in number default hr_api.g_number,
471: p_name in varchar2 default hr_api.g_varchar2,
472: p_object_version_number in out nocopy number,
473: p_start_date in date default hr_api.g_date,
466: (
467: p_booking_deal_id in number,
468: p_customer_id in number default hr_api.g_number,
469: p_approved_by_person_id in number default hr_api.g_number,
470: p_business_group_id in number default hr_api.g_number,
471: p_name in varchar2 default hr_api.g_varchar2,
472: p_object_version_number in out nocopy number,
473: p_start_date in date default hr_api.g_date,
474: p_category in varchar2 default hr_api.g_varchar2,
467: p_booking_deal_id in number,
468: p_customer_id in number default hr_api.g_number,
469: p_approved_by_person_id in number default hr_api.g_number,
470: p_business_group_id in number default hr_api.g_number,
471: p_name in varchar2 default hr_api.g_varchar2,
472: p_object_version_number in out nocopy number,
473: p_start_date in date default hr_api.g_date,
474: p_category in varchar2 default hr_api.g_varchar2,
475: p_comments in varchar2 default hr_api.g_varchar2,
469: p_approved_by_person_id in number default hr_api.g_number,
470: p_business_group_id in number default hr_api.g_number,
471: p_name in varchar2 default hr_api.g_varchar2,
472: p_object_version_number in out nocopy number,
473: p_start_date in date default hr_api.g_date,
474: p_category in varchar2 default hr_api.g_varchar2,
475: p_comments in varchar2 default hr_api.g_varchar2,
476: p_description in varchar2 default hr_api.g_varchar2,
477: p_discount_percentage in number default hr_api.g_number,
470: p_business_group_id in number default hr_api.g_number,
471: p_name in varchar2 default hr_api.g_varchar2,
472: p_object_version_number in out nocopy number,
473: p_start_date in date default hr_api.g_date,
474: p_category in varchar2 default hr_api.g_varchar2,
475: p_comments in varchar2 default hr_api.g_varchar2,
476: p_description in varchar2 default hr_api.g_varchar2,
477: p_discount_percentage in number default hr_api.g_number,
478: p_end_date in date default hr_api.g_date,
471: p_name in varchar2 default hr_api.g_varchar2,
472: p_object_version_number in out nocopy number,
473: p_start_date in date default hr_api.g_date,
474: p_category in varchar2 default hr_api.g_varchar2,
475: p_comments in varchar2 default hr_api.g_varchar2,
476: p_description in varchar2 default hr_api.g_varchar2,
477: p_discount_percentage in number default hr_api.g_number,
478: p_end_date in date default hr_api.g_date,
479: p_number_of_places in number default hr_api.g_number,
472: p_object_version_number in out nocopy number,
473: p_start_date in date default hr_api.g_date,
474: p_category in varchar2 default hr_api.g_varchar2,
475: p_comments in varchar2 default hr_api.g_varchar2,
476: p_description in varchar2 default hr_api.g_varchar2,
477: p_discount_percentage in number default hr_api.g_number,
478: p_end_date in date default hr_api.g_date,
479: p_number_of_places in number default hr_api.g_number,
480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default hr_api.g_varchar2,
473: p_start_date in date default hr_api.g_date,
474: p_category in varchar2 default hr_api.g_varchar2,
475: p_comments in varchar2 default hr_api.g_varchar2,
476: p_description in varchar2 default hr_api.g_varchar2,
477: p_discount_percentage in number default hr_api.g_number,
478: p_end_date in date default hr_api.g_date,
479: p_number_of_places in number default hr_api.g_number,
480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default hr_api.g_varchar2,
481: p_overdraft_limit in number default hr_api.g_number,
474: p_category in varchar2 default hr_api.g_varchar2,
475: p_comments in varchar2 default hr_api.g_varchar2,
476: p_description in varchar2 default hr_api.g_varchar2,
477: p_discount_percentage in number default hr_api.g_number,
478: p_end_date in date default hr_api.g_date,
479: p_number_of_places in number default hr_api.g_number,
480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default hr_api.g_varchar2,
481: p_overdraft_limit in number default hr_api.g_number,
482: p_type in varchar2 default hr_api.g_varchar2,
475: p_comments in varchar2 default hr_api.g_varchar2,
476: p_description in varchar2 default hr_api.g_varchar2,
477: p_discount_percentage in number default hr_api.g_number,
478: p_end_date in date default hr_api.g_date,
479: p_number_of_places in number default hr_api.g_number,
480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default hr_api.g_varchar2,
481: p_overdraft_limit in number default hr_api.g_number,
482: p_type in varchar2 default hr_api.g_varchar2,
483: p_price_list_id in number default hr_api.g_number,
476: p_description in varchar2 default hr_api.g_varchar2,
477: p_discount_percentage in number default hr_api.g_number,
478: p_end_date in date default hr_api.g_date,
479: p_number_of_places in number default hr_api.g_number,
480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default hr_api.g_varchar2,
481: p_overdraft_limit in number default hr_api.g_number,
482: p_type in varchar2 default hr_api.g_varchar2,
483: p_price_list_id in number default hr_api.g_number,
484: p_activity_version_id in number default hr_api.g_number,
477: p_discount_percentage in number default hr_api.g_number,
478: p_end_date in date default hr_api.g_date,
479: p_number_of_places in number default hr_api.g_number,
480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default hr_api.g_varchar2,
481: p_overdraft_limit in number default hr_api.g_number,
482: p_type in varchar2 default hr_api.g_varchar2,
483: p_price_list_id in number default hr_api.g_number,
484: p_activity_version_id in number default hr_api.g_number,
485: p_event_id in number default hr_api.g_number,
478: p_end_date in date default hr_api.g_date,
479: p_number_of_places in number default hr_api.g_number,
480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default hr_api.g_varchar2,
481: p_overdraft_limit in number default hr_api.g_number,
482: p_type in varchar2 default hr_api.g_varchar2,
483: p_price_list_id in number default hr_api.g_number,
484: p_activity_version_id in number default hr_api.g_number,
485: p_event_id in number default hr_api.g_number,
486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
479: p_number_of_places in number default hr_api.g_number,
480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default hr_api.g_varchar2,
481: p_overdraft_limit in number default hr_api.g_number,
482: p_type in varchar2 default hr_api.g_varchar2,
483: p_price_list_id in number default hr_api.g_number,
484: p_activity_version_id in number default hr_api.g_number,
485: p_event_id in number default hr_api.g_number,
486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default hr_api.g_varchar2,
481: p_overdraft_limit in number default hr_api.g_number,
482: p_type in varchar2 default hr_api.g_varchar2,
483: p_price_list_id in number default hr_api.g_number,
484: p_activity_version_id in number default hr_api.g_number,
485: p_event_id in number default hr_api.g_number,
486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
481: p_overdraft_limit in number default hr_api.g_number,
482: p_type in varchar2 default hr_api.g_varchar2,
483: p_price_list_id in number default hr_api.g_number,
484: p_activity_version_id in number default hr_api.g_number,
485: p_event_id in number default hr_api.g_number,
486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
482: p_type in varchar2 default hr_api.g_varchar2,
483: p_price_list_id in number default hr_api.g_number,
484: p_activity_version_id in number default hr_api.g_number,
485: p_event_id in number default hr_api.g_number,
486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
483: p_price_list_id in number default hr_api.g_number,
484: p_activity_version_id in number default hr_api.g_number,
485: p_event_id in number default hr_api.g_number,
486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
484: p_activity_version_id in number default hr_api.g_number,
485: p_event_id in number default hr_api.g_number,
486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
485: p_event_id in number default hr_api.g_number,
486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,
498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,
506: p_tbd_information20 in varchar2 default hr_api.g_varchar2,
499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,
506: p_tbd_information20 in varchar2 default hr_api.g_varchar2,
507: p_validate in boolean default false
500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,
506: p_tbd_information20 in varchar2 default hr_api.g_varchar2,
507: p_validate in boolean default false
508: );
501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,
506: p_tbd_information20 in varchar2 default hr_api.g_varchar2,
507: p_validate in boolean default false
508: );
509: --
502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,
506: p_tbd_information20 in varchar2 default hr_api.g_varchar2,
507: p_validate in boolean default false
508: );
509: --
510: -- ----------------------------------------------------------------------------
543: -- default is false. The validation is controlled by a savepoint and
544: -- rollback mechanism. The savepoint is issued at the beginning of the
545: -- business process and is rollbacked at the end of the business process
546: -- when all the processing has been completed. The rollback is controlled
547: -- by raising and handling the exception hr_api.validate_enabled. We use
548: -- the exception because, by raising the exception with the business
549: -- process, we can exit successfully without having any of the 'OUT'
550: -- arguments being set.
551: --