345: --
346: procedure Update_Enrollment
347: (
348: p_booking_id in number,
349: p_booking_status_type_id in number default hr_api.g_number,
350: p_delegate_person_id in number default hr_api.g_number,
351: p_contact_id in number default hr_api.g_number,
352: p_business_group_id in number default hr_api.g_number,
353: p_event_id in number default hr_api.g_number,
346: procedure Update_Enrollment
347: (
348: p_booking_id in number,
349: p_booking_status_type_id in number default hr_api.g_number,
350: p_delegate_person_id in number default hr_api.g_number,
351: p_contact_id in number default hr_api.g_number,
352: p_business_group_id in number default hr_api.g_number,
353: p_event_id in number default hr_api.g_number,
354: p_customer_id in number default hr_api.g_number,
347: (
348: p_booking_id in number,
349: p_booking_status_type_id in number default hr_api.g_number,
350: p_delegate_person_id in number default hr_api.g_number,
351: p_contact_id in number default hr_api.g_number,
352: p_business_group_id in number default hr_api.g_number,
353: p_event_id in number default hr_api.g_number,
354: p_customer_id in number default hr_api.g_number,
355: p_authorizer_person_id in number default hr_api.g_number,
348: p_booking_id in number,
349: p_booking_status_type_id in number default hr_api.g_number,
350: p_delegate_person_id in number default hr_api.g_number,
351: p_contact_id in number default hr_api.g_number,
352: p_business_group_id in number default hr_api.g_number,
353: p_event_id in number default hr_api.g_number,
354: p_customer_id in number default hr_api.g_number,
355: p_authorizer_person_id in number default hr_api.g_number,
356: p_date_booking_placed in date default hr_api.g_date,
349: p_booking_status_type_id in number default hr_api.g_number,
350: p_delegate_person_id in number default hr_api.g_number,
351: p_contact_id in number default hr_api.g_number,
352: p_business_group_id in number default hr_api.g_number,
353: p_event_id in number default hr_api.g_number,
354: p_customer_id in number default hr_api.g_number,
355: p_authorizer_person_id in number default hr_api.g_number,
356: p_date_booking_placed in date default hr_api.g_date,
357: p_corespondent in varchar2 default hr_api.g_varchar2,
350: p_delegate_person_id in number default hr_api.g_number,
351: p_contact_id in number default hr_api.g_number,
352: p_business_group_id in number default hr_api.g_number,
353: p_event_id in number default hr_api.g_number,
354: p_customer_id in number default hr_api.g_number,
355: p_authorizer_person_id in number default hr_api.g_number,
356: p_date_booking_placed in date default hr_api.g_date,
357: p_corespondent in varchar2 default hr_api.g_varchar2,
358: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
351: p_contact_id in number default hr_api.g_number,
352: p_business_group_id in number default hr_api.g_number,
353: p_event_id in number default hr_api.g_number,
354: p_customer_id in number default hr_api.g_number,
355: p_authorizer_person_id in number default hr_api.g_number,
356: p_date_booking_placed in date default hr_api.g_date,
357: p_corespondent in varchar2 default hr_api.g_varchar2,
358: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
359: p_number_of_places in number default hr_api.g_number,
352: p_business_group_id in number default hr_api.g_number,
353: p_event_id in number default hr_api.g_number,
354: p_customer_id in number default hr_api.g_number,
355: p_authorizer_person_id in number default hr_api.g_number,
356: p_date_booking_placed in date default hr_api.g_date,
357: p_corespondent in varchar2 default hr_api.g_varchar2,
358: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
359: p_number_of_places in number default hr_api.g_number,
360: p_object_version_number in out nocopy number,
353: p_event_id in number default hr_api.g_number,
354: p_customer_id in number default hr_api.g_number,
355: p_authorizer_person_id in number default hr_api.g_number,
356: p_date_booking_placed in date default hr_api.g_date,
357: p_corespondent in varchar2 default hr_api.g_varchar2,
358: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
359: p_number_of_places in number default hr_api.g_number,
360: p_object_version_number in out nocopy number,
361: p_administrator in number default hr_api.g_number,
354: p_customer_id in number default hr_api.g_number,
355: p_authorizer_person_id in number default hr_api.g_number,
356: p_date_booking_placed in date default hr_api.g_date,
357: p_corespondent in varchar2 default hr_api.g_varchar2,
358: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
359: p_number_of_places in number default hr_api.g_number,
360: p_object_version_number in out nocopy number,
361: p_administrator in number default hr_api.g_number,
362: p_booking_priority in varchar2 default hr_api.g_varchar2,
355: p_authorizer_person_id in number default hr_api.g_number,
356: p_date_booking_placed in date default hr_api.g_date,
357: p_corespondent in varchar2 default hr_api.g_varchar2,
358: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
359: p_number_of_places in number default hr_api.g_number,
360: p_object_version_number in out nocopy number,
361: p_administrator in number default hr_api.g_number,
362: p_booking_priority in varchar2 default hr_api.g_varchar2,
363: p_comments in varchar2 default hr_api.g_varchar2,
357: p_corespondent in varchar2 default hr_api.g_varchar2,
358: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
359: p_number_of_places in number default hr_api.g_number,
360: p_object_version_number in out nocopy number,
361: p_administrator in number default hr_api.g_number,
362: p_booking_priority in varchar2 default hr_api.g_varchar2,
363: p_comments in varchar2 default hr_api.g_varchar2,
364: p_contact_address_id in number default hr_api.g_number,
365: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
358: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
359: p_number_of_places in number default hr_api.g_number,
360: p_object_version_number in out nocopy number,
361: p_administrator in number default hr_api.g_number,
362: p_booking_priority in varchar2 default hr_api.g_varchar2,
363: p_comments in varchar2 default hr_api.g_varchar2,
364: p_contact_address_id in number default hr_api.g_number,
365: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
366: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
359: p_number_of_places in number default hr_api.g_number,
360: p_object_version_number in out nocopy number,
361: p_administrator in number default hr_api.g_number,
362: p_booking_priority in varchar2 default hr_api.g_varchar2,
363: p_comments in varchar2 default hr_api.g_varchar2,
364: p_contact_address_id in number default hr_api.g_number,
365: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
366: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
367: p_third_party_customer_id in number default hr_api.g_number,
360: p_object_version_number in out nocopy number,
361: p_administrator in number default hr_api.g_number,
362: p_booking_priority in varchar2 default hr_api.g_varchar2,
363: p_comments in varchar2 default hr_api.g_varchar2,
364: p_contact_address_id in number default hr_api.g_number,
365: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
366: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
367: p_third_party_customer_id in number default hr_api.g_number,
368: p_third_party_contact_id in number default hr_api.g_number,
361: p_administrator in number default hr_api.g_number,
362: p_booking_priority in varchar2 default hr_api.g_varchar2,
363: p_comments in varchar2 default hr_api.g_varchar2,
364: p_contact_address_id in number default hr_api.g_number,
365: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
366: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
367: p_third_party_customer_id in number default hr_api.g_number,
368: p_third_party_contact_id in number default hr_api.g_number,
369: p_third_party_address_id in number default hr_api.g_number,
362: p_booking_priority in varchar2 default hr_api.g_varchar2,
363: p_comments in varchar2 default hr_api.g_varchar2,
364: p_contact_address_id in number default hr_api.g_number,
365: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
366: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
367: p_third_party_customer_id in number default hr_api.g_number,
368: p_third_party_contact_id in number default hr_api.g_number,
369: p_third_party_address_id in number default hr_api.g_number,
370: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
363: p_comments in varchar2 default hr_api.g_varchar2,
364: p_contact_address_id in number default hr_api.g_number,
365: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
366: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
367: p_third_party_customer_id in number default hr_api.g_number,
368: p_third_party_contact_id in number default hr_api.g_number,
369: p_third_party_address_id in number default hr_api.g_number,
370: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
371: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
364: p_contact_address_id in number default hr_api.g_number,
365: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
366: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
367: p_third_party_customer_id in number default hr_api.g_number,
368: p_third_party_contact_id in number default hr_api.g_number,
369: p_third_party_address_id in number default hr_api.g_number,
370: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
371: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
372: p_date_status_changed in date default hr_api.g_date,
365: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
366: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
367: p_third_party_customer_id in number default hr_api.g_number,
368: p_third_party_contact_id in number default hr_api.g_number,
369: p_third_party_address_id in number default hr_api.g_number,
370: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
371: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
372: p_date_status_changed in date default hr_api.g_date,
373: p_status_change_comments in varchar2 default hr_api.g_varchar2,
366: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
367: p_third_party_customer_id in number default hr_api.g_number,
368: p_third_party_contact_id in number default hr_api.g_number,
369: p_third_party_address_id in number default hr_api.g_number,
370: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
371: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
372: p_date_status_changed in date default hr_api.g_date,
373: p_status_change_comments in varchar2 default hr_api.g_varchar2,
374: p_failure_reason in varchar2 default hr_api.g_varchar2,
367: p_third_party_customer_id in number default hr_api.g_number,
368: p_third_party_contact_id in number default hr_api.g_number,
369: p_third_party_address_id in number default hr_api.g_number,
370: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
371: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
372: p_date_status_changed in date default hr_api.g_date,
373: p_status_change_comments in varchar2 default hr_api.g_varchar2,
374: p_failure_reason in varchar2 default hr_api.g_varchar2,
375: p_attendance_result in varchar2 default hr_api.g_varchar2,
368: p_third_party_contact_id in number default hr_api.g_number,
369: p_third_party_address_id in number default hr_api.g_number,
370: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
371: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
372: p_date_status_changed in date default hr_api.g_date,
373: p_status_change_comments in varchar2 default hr_api.g_varchar2,
374: p_failure_reason in varchar2 default hr_api.g_varchar2,
375: p_attendance_result in varchar2 default hr_api.g_varchar2,
376: p_language_id in number default hr_api.g_number,
369: p_third_party_address_id in number default hr_api.g_number,
370: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
371: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
372: p_date_status_changed in date default hr_api.g_date,
373: p_status_change_comments in varchar2 default hr_api.g_varchar2,
374: p_failure_reason in varchar2 default hr_api.g_varchar2,
375: p_attendance_result in varchar2 default hr_api.g_varchar2,
376: p_language_id in number default hr_api.g_number,
377: p_source_of_booking in varchar2 default hr_api.g_varchar2,
370: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
371: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
372: p_date_status_changed in date default hr_api.g_date,
373: p_status_change_comments in varchar2 default hr_api.g_varchar2,
374: p_failure_reason in varchar2 default hr_api.g_varchar2,
375: p_attendance_result in varchar2 default hr_api.g_varchar2,
376: p_language_id in number default hr_api.g_number,
377: p_source_of_booking in varchar2 default hr_api.g_varchar2,
378: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
371: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
372: p_date_status_changed in date default hr_api.g_date,
373: p_status_change_comments in varchar2 default hr_api.g_varchar2,
374: p_failure_reason in varchar2 default hr_api.g_varchar2,
375: p_attendance_result in varchar2 default hr_api.g_varchar2,
376: p_language_id in number default hr_api.g_number,
377: p_source_of_booking in varchar2 default hr_api.g_varchar2,
378: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
379: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
372: p_date_status_changed in date default hr_api.g_date,
373: p_status_change_comments in varchar2 default hr_api.g_varchar2,
374: p_failure_reason in varchar2 default hr_api.g_varchar2,
375: p_attendance_result in varchar2 default hr_api.g_varchar2,
376: p_language_id in number default hr_api.g_number,
377: p_source_of_booking in varchar2 default hr_api.g_varchar2,
378: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
379: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
380: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
373: p_status_change_comments in varchar2 default hr_api.g_varchar2,
374: p_failure_reason in varchar2 default hr_api.g_varchar2,
375: p_attendance_result in varchar2 default hr_api.g_varchar2,
376: p_language_id in number default hr_api.g_number,
377: p_source_of_booking in varchar2 default hr_api.g_varchar2,
378: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
379: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
380: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
381: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
374: p_failure_reason in varchar2 default hr_api.g_varchar2,
375: p_attendance_result in varchar2 default hr_api.g_varchar2,
376: p_language_id in number default hr_api.g_number,
377: p_source_of_booking in varchar2 default hr_api.g_varchar2,
378: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
379: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
380: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
381: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
382: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
375: p_attendance_result in varchar2 default hr_api.g_varchar2,
376: p_language_id in number default hr_api.g_number,
377: p_source_of_booking in varchar2 default hr_api.g_varchar2,
378: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
379: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
380: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
381: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
382: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
383: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
376: p_language_id in number default hr_api.g_number,
377: p_source_of_booking in varchar2 default hr_api.g_varchar2,
378: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
379: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
380: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
381: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
382: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
383: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
384: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
377: p_source_of_booking in varchar2 default hr_api.g_varchar2,
378: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
379: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
380: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
381: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
382: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
383: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
384: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
385: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
378: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
379: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
380: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
381: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
382: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
383: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
384: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
385: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
386: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
379: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
380: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
381: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
382: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
383: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
384: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
385: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
386: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
387: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
380: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
381: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
382: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
383: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
384: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
385: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
386: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
387: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
388: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
381: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
382: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
383: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
384: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
385: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
386: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
387: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
388: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
389: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
382: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
383: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
384: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
385: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
386: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
387: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
388: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
389: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
390: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
383: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
384: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
385: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
386: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
387: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
388: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
389: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
390: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
391: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
384: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
385: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
386: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
387: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
388: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
389: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
390: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
391: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
392: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
385: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
386: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
387: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
388: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
389: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
390: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
391: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
392: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
393: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
386: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
387: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
388: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
389: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
390: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
391: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
392: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
393: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
394: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
387: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
388: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
389: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
390: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
391: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
392: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
393: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
394: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
395: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
388: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
389: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
390: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
391: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
392: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
393: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
394: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
395: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
396: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
389: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
390: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
391: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
392: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
393: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
394: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
395: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
396: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
397: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
390: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
391: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
392: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
393: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
394: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
395: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
396: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
397: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
398: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
391: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
392: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
393: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
394: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
395: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
396: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
397: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
398: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
399: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
392: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
393: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
394: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
395: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
396: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
397: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
398: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
399: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
400: p_tdb_information20 in varchar2 default hr_api.g_varchar2,
393: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
394: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
395: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
396: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
397: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
398: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
399: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
400: p_tdb_information20 in varchar2 default hr_api.g_varchar2,
401: p_update_finance_line in varchar2 default 'N',
394: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
395: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
396: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
397: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
398: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
399: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
400: p_tdb_information20 in varchar2 default hr_api.g_varchar2,
401: p_update_finance_line in varchar2 default 'N',
402: p_tfl_object_version_number in out nocopy number,
395: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
396: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
397: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
398: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
399: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
400: p_tdb_information20 in varchar2 default hr_api.g_varchar2,
401: p_update_finance_line in varchar2 default 'N',
402: p_tfl_object_version_number in out nocopy number,
403: p_finance_header_id in number default hr_api.g_number,
396: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
397: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
398: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
399: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
400: p_tdb_information20 in varchar2 default hr_api.g_varchar2,
401: p_update_finance_line in varchar2 default 'N',
402: p_tfl_object_version_number in out nocopy number,
403: p_finance_header_id in number default hr_api.g_number,
404: p_finance_line_id in out nocopy number,
399: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
400: p_tdb_information20 in varchar2 default hr_api.g_varchar2,
401: p_update_finance_line in varchar2 default 'N',
402: p_tfl_object_version_number in out nocopy number,
403: p_finance_header_id in number default hr_api.g_number,
404: p_finance_line_id in out nocopy number,
405: p_standard_amount in number default hr_api.g_number,
406: p_unitary_amount in number default hr_api.g_number,
407: p_money_amount in number default hr_api.g_number,
401: p_update_finance_line in varchar2 default 'N',
402: p_tfl_object_version_number in out nocopy number,
403: p_finance_header_id in number default hr_api.g_number,
404: p_finance_line_id in out nocopy number,
405: p_standard_amount in number default hr_api.g_number,
406: p_unitary_amount in number default hr_api.g_number,
407: p_money_amount in number default hr_api.g_number,
408: p_currency_code in varchar2 default hr_api.g_varchar2,
409: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
402: p_tfl_object_version_number in out nocopy number,
403: p_finance_header_id in number default hr_api.g_number,
404: p_finance_line_id in out nocopy number,
405: p_standard_amount in number default hr_api.g_number,
406: p_unitary_amount in number default hr_api.g_number,
407: p_money_amount in number default hr_api.g_number,
408: p_currency_code in varchar2 default hr_api.g_varchar2,
409: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
410: p_booking_deal_id in number default hr_api.g_number,
403: p_finance_header_id in number default hr_api.g_number,
404: p_finance_line_id in out nocopy number,
405: p_standard_amount in number default hr_api.g_number,
406: p_unitary_amount in number default hr_api.g_number,
407: p_money_amount in number default hr_api.g_number,
408: p_currency_code in varchar2 default hr_api.g_varchar2,
409: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
410: p_booking_deal_id in number default hr_api.g_number,
411: p_enrollment_type in varchar2 default hr_api.g_varchar2,
404: p_finance_line_id in out nocopy number,
405: p_standard_amount in number default hr_api.g_number,
406: p_unitary_amount in number default hr_api.g_number,
407: p_money_amount in number default hr_api.g_number,
408: p_currency_code in varchar2 default hr_api.g_varchar2,
409: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
410: p_booking_deal_id in number default hr_api.g_number,
411: p_enrollment_type in varchar2 default hr_api.g_varchar2,
412: p_validate in boolean default false,
405: p_standard_amount in number default hr_api.g_number,
406: p_unitary_amount in number default hr_api.g_number,
407: p_money_amount in number default hr_api.g_number,
408: p_currency_code in varchar2 default hr_api.g_varchar2,
409: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
410: p_booking_deal_id in number default hr_api.g_number,
411: p_enrollment_type in varchar2 default hr_api.g_varchar2,
412: p_validate in boolean default false,
413: p_organization_id in number default hr_api.g_number,
406: p_unitary_amount in number default hr_api.g_number,
407: p_money_amount in number default hr_api.g_number,
408: p_currency_code in varchar2 default hr_api.g_varchar2,
409: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
410: p_booking_deal_id in number default hr_api.g_number,
411: p_enrollment_type in varchar2 default hr_api.g_varchar2,
412: p_validate in boolean default false,
413: p_organization_id in number default hr_api.g_number,
414: p_sponsor_person_id in number default hr_api.g_number,
407: p_money_amount in number default hr_api.g_number,
408: p_currency_code in varchar2 default hr_api.g_varchar2,
409: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
410: p_booking_deal_id in number default hr_api.g_number,
411: p_enrollment_type in varchar2 default hr_api.g_varchar2,
412: p_validate in boolean default false,
413: p_organization_id in number default hr_api.g_number,
414: p_sponsor_person_id in number default hr_api.g_number,
415: p_sponsor_assignment_id in number default hr_api.g_number,
409: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
410: p_booking_deal_id in number default hr_api.g_number,
411: p_enrollment_type in varchar2 default hr_api.g_varchar2,
412: p_validate in boolean default false,
413: p_organization_id in number default hr_api.g_number,
414: p_sponsor_person_id in number default hr_api.g_number,
415: p_sponsor_assignment_id in number default hr_api.g_number,
416: p_person_address_id in number default hr_api.g_number,
417: p_delegate_assignment_id in number default hr_api.g_number,
410: p_booking_deal_id in number default hr_api.g_number,
411: p_enrollment_type in varchar2 default hr_api.g_varchar2,
412: p_validate in boolean default false,
413: p_organization_id in number default hr_api.g_number,
414: p_sponsor_person_id in number default hr_api.g_number,
415: p_sponsor_assignment_id in number default hr_api.g_number,
416: p_person_address_id in number default hr_api.g_number,
417: p_delegate_assignment_id in number default hr_api.g_number,
418: p_delegate_contact_id in number default hr_api.g_number,
411: p_enrollment_type in varchar2 default hr_api.g_varchar2,
412: p_validate in boolean default false,
413: p_organization_id in number default hr_api.g_number,
414: p_sponsor_person_id in number default hr_api.g_number,
415: p_sponsor_assignment_id in number default hr_api.g_number,
416: p_person_address_id in number default hr_api.g_number,
417: p_delegate_assignment_id in number default hr_api.g_number,
418: p_delegate_contact_id in number default hr_api.g_number,
419: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
412: p_validate in boolean default false,
413: p_organization_id in number default hr_api.g_number,
414: p_sponsor_person_id in number default hr_api.g_number,
415: p_sponsor_assignment_id in number default hr_api.g_number,
416: p_person_address_id in number default hr_api.g_number,
417: p_delegate_assignment_id in number default hr_api.g_number,
418: p_delegate_contact_id in number default hr_api.g_number,
419: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
420: p_third_party_email in varchar2 default hr_api.g_varchar2,
413: p_organization_id in number default hr_api.g_number,
414: p_sponsor_person_id in number default hr_api.g_number,
415: p_sponsor_assignment_id in number default hr_api.g_number,
416: p_person_address_id in number default hr_api.g_number,
417: p_delegate_assignment_id in number default hr_api.g_number,
418: p_delegate_contact_id in number default hr_api.g_number,
419: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
420: p_third_party_email in varchar2 default hr_api.g_varchar2,
421: p_person_address_type in varchar2 default hr_api.g_varchar2,
414: p_sponsor_person_id in number default hr_api.g_number,
415: p_sponsor_assignment_id in number default hr_api.g_number,
416: p_person_address_id in number default hr_api.g_number,
417: p_delegate_assignment_id in number default hr_api.g_number,
418: p_delegate_contact_id in number default hr_api.g_number,
419: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
420: p_third_party_email in varchar2 default hr_api.g_varchar2,
421: p_person_address_type in varchar2 default hr_api.g_varchar2,
422: p_line_id in number default hr_api.g_number,
415: p_sponsor_assignment_id in number default hr_api.g_number,
416: p_person_address_id in number default hr_api.g_number,
417: p_delegate_assignment_id in number default hr_api.g_number,
418: p_delegate_contact_id in number default hr_api.g_number,
419: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
420: p_third_party_email in varchar2 default hr_api.g_varchar2,
421: p_person_address_type in varchar2 default hr_api.g_varchar2,
422: p_line_id in number default hr_api.g_number,
423: p_org_id in number default hr_api.g_number,
416: p_person_address_id in number default hr_api.g_number,
417: p_delegate_assignment_id in number default hr_api.g_number,
418: p_delegate_contact_id in number default hr_api.g_number,
419: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
420: p_third_party_email in varchar2 default hr_api.g_varchar2,
421: p_person_address_type in varchar2 default hr_api.g_varchar2,
422: p_line_id in number default hr_api.g_number,
423: p_org_id in number default hr_api.g_number,
424: p_daemon_flag in varchar2 default hr_api.g_varchar2,
417: p_delegate_assignment_id in number default hr_api.g_number,
418: p_delegate_contact_id in number default hr_api.g_number,
419: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
420: p_third_party_email in varchar2 default hr_api.g_varchar2,
421: p_person_address_type in varchar2 default hr_api.g_varchar2,
422: p_line_id in number default hr_api.g_number,
423: p_org_id in number default hr_api.g_number,
424: p_daemon_flag in varchar2 default hr_api.g_varchar2,
425: p_daemon_type in varchar2 default hr_api.g_varchar2,
418: p_delegate_contact_id in number default hr_api.g_number,
419: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
420: p_third_party_email in varchar2 default hr_api.g_varchar2,
421: p_person_address_type in varchar2 default hr_api.g_varchar2,
422: p_line_id in number default hr_api.g_number,
423: p_org_id in number default hr_api.g_number,
424: p_daemon_flag in varchar2 default hr_api.g_varchar2,
425: p_daemon_type in varchar2 default hr_api.g_varchar2,
426: p_old_event_id in number default hr_api.g_number,
419: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
420: p_third_party_email in varchar2 default hr_api.g_varchar2,
421: p_person_address_type in varchar2 default hr_api.g_varchar2,
422: p_line_id in number default hr_api.g_number,
423: p_org_id in number default hr_api.g_number,
424: p_daemon_flag in varchar2 default hr_api.g_varchar2,
425: p_daemon_type in varchar2 default hr_api.g_varchar2,
426: p_old_event_id in number default hr_api.g_number,
427: p_quote_line_id in number default hr_api.g_number,
420: p_third_party_email in varchar2 default hr_api.g_varchar2,
421: p_person_address_type in varchar2 default hr_api.g_varchar2,
422: p_line_id in number default hr_api.g_number,
423: p_org_id in number default hr_api.g_number,
424: p_daemon_flag in varchar2 default hr_api.g_varchar2,
425: p_daemon_type in varchar2 default hr_api.g_varchar2,
426: p_old_event_id in number default hr_api.g_number,
427: p_quote_line_id in number default hr_api.g_number,
428: p_interface_source in varchar2 default hr_api.g_varchar2,
421: p_person_address_type in varchar2 default hr_api.g_varchar2,
422: p_line_id in number default hr_api.g_number,
423: p_org_id in number default hr_api.g_number,
424: p_daemon_flag in varchar2 default hr_api.g_varchar2,
425: p_daemon_type in varchar2 default hr_api.g_varchar2,
426: p_old_event_id in number default hr_api.g_number,
427: p_quote_line_id in number default hr_api.g_number,
428: p_interface_source in varchar2 default hr_api.g_varchar2,
429: p_total_training_time in varchar2 default hr_api.g_varchar2,
422: p_line_id in number default hr_api.g_number,
423: p_org_id in number default hr_api.g_number,
424: p_daemon_flag in varchar2 default hr_api.g_varchar2,
425: p_daemon_type in varchar2 default hr_api.g_varchar2,
426: p_old_event_id in number default hr_api.g_number,
427: p_quote_line_id in number default hr_api.g_number,
428: p_interface_source in varchar2 default hr_api.g_varchar2,
429: p_total_training_time in varchar2 default hr_api.g_varchar2,
430: p_content_player_status in varchar2 default hr_api.g_varchar2,
423: p_org_id in number default hr_api.g_number,
424: p_daemon_flag in varchar2 default hr_api.g_varchar2,
425: p_daemon_type in varchar2 default hr_api.g_varchar2,
426: p_old_event_id in number default hr_api.g_number,
427: p_quote_line_id in number default hr_api.g_number,
428: p_interface_source in varchar2 default hr_api.g_varchar2,
429: p_total_training_time in varchar2 default hr_api.g_varchar2,
430: p_content_player_status in varchar2 default hr_api.g_varchar2,
431: p_score in number default hr_api.g_number,
424: p_daemon_flag in varchar2 default hr_api.g_varchar2,
425: p_daemon_type in varchar2 default hr_api.g_varchar2,
426: p_old_event_id in number default hr_api.g_number,
427: p_quote_line_id in number default hr_api.g_number,
428: p_interface_source in varchar2 default hr_api.g_varchar2,
429: p_total_training_time in varchar2 default hr_api.g_varchar2,
430: p_content_player_status in varchar2 default hr_api.g_varchar2,
431: p_score in number default hr_api.g_number,
432: p_completed_content in number default hr_api.g_number,
425: p_daemon_type in varchar2 default hr_api.g_varchar2,
426: p_old_event_id in number default hr_api.g_number,
427: p_quote_line_id in number default hr_api.g_number,
428: p_interface_source in varchar2 default hr_api.g_varchar2,
429: p_total_training_time in varchar2 default hr_api.g_varchar2,
430: p_content_player_status in varchar2 default hr_api.g_varchar2,
431: p_score in number default hr_api.g_number,
432: p_completed_content in number default hr_api.g_number,
433: p_total_content in number default hr_api.g_number,
426: p_old_event_id in number default hr_api.g_number,
427: p_quote_line_id in number default hr_api.g_number,
428: p_interface_source in varchar2 default hr_api.g_varchar2,
429: p_total_training_time in varchar2 default hr_api.g_varchar2,
430: p_content_player_status in varchar2 default hr_api.g_varchar2,
431: p_score in number default hr_api.g_number,
432: p_completed_content in number default hr_api.g_number,
433: p_total_content in number default hr_api.g_number,
434: p_booking_justification_id in number default hr_api.g_number,
427: p_quote_line_id in number default hr_api.g_number,
428: p_interface_source in varchar2 default hr_api.g_varchar2,
429: p_total_training_time in varchar2 default hr_api.g_varchar2,
430: p_content_player_status in varchar2 default hr_api.g_varchar2,
431: p_score in number default hr_api.g_number,
432: p_completed_content in number default hr_api.g_number,
433: p_total_content in number default hr_api.g_number,
434: p_booking_justification_id in number default hr_api.g_number,
435: p_source_cancel in varchar2,
428: p_interface_source in varchar2 default hr_api.g_varchar2,
429: p_total_training_time in varchar2 default hr_api.g_varchar2,
430: p_content_player_status in varchar2 default hr_api.g_varchar2,
431: p_score in number default hr_api.g_number,
432: p_completed_content in number default hr_api.g_number,
433: p_total_content in number default hr_api.g_number,
434: p_booking_justification_id in number default hr_api.g_number,
435: p_source_cancel in varchar2,
436: p_override_prerequisites in varchar2 default 'N',
429: p_total_training_time in varchar2 default hr_api.g_varchar2,
430: p_content_player_status in varchar2 default hr_api.g_varchar2,
431: p_score in number default hr_api.g_number,
432: p_completed_content in number default hr_api.g_number,
433: p_total_content in number default hr_api.g_number,
434: p_booking_justification_id in number default hr_api.g_number,
435: p_source_cancel in varchar2,
436: p_override_prerequisites in varchar2 default 'N',
437: p_is_history_flag in varchar2 default hr_api.g_varchar2
430: p_content_player_status in varchar2 default hr_api.g_varchar2,
431: p_score in number default hr_api.g_number,
432: p_completed_content in number default hr_api.g_number,
433: p_total_content in number default hr_api.g_number,
434: p_booking_justification_id in number default hr_api.g_number,
435: p_source_cancel in varchar2,
436: p_override_prerequisites in varchar2 default 'N',
437: p_is_history_flag in varchar2 default hr_api.g_varchar2
438: ,p_override_learner_access in varchar2 default 'N',
433: p_total_content in number default hr_api.g_number,
434: p_booking_justification_id in number default hr_api.g_number,
435: p_source_cancel in varchar2,
436: p_override_prerequisites in varchar2 default 'N',
437: p_is_history_flag in varchar2 default hr_api.g_varchar2
438: ,p_override_learner_access in varchar2 default 'N',
439: p_sign_eval_status in varchar2 default null)
440: is
441:
678: FETCH csr_get_enr_details INTO l_enr_details_rec;
679: CLOSE csr_get_enr_details;
680:
681: -- Modified for bug#4681165
682: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
683: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
684: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;
685: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
686: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;
679: CLOSE csr_get_enr_details;
680:
681: -- Modified for bug#4681165
682: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
683: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
684: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;
685: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
686: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;
687: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;
680:
681: -- Modified for bug#4681165
682: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
683: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
684: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;
685: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
686: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;
687: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;
688:
681: -- Modified for bug#4681165
682: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
683: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
684: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;
685: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
686: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;
687: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;
688:
689:
682: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
683: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
684: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;
685: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
686: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;
687: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;
688:
689:
690: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
683: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
684: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;
685: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
686: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;
687: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;
688:
689:
690: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
691: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
711: END IF;
712: END IF;
713:
714: -- Added for bug#4654530
715: IF nvl(p_status_change_comments,hr_api.g_varchar2) <> l_evt_status_chg_comments THEN
716:
717: OPEN get_status_info;
718: FETCH get_status_info INTO l_old_booking_status;
719: CLOSE get_status_info;
889: OPEN is_contact;
890: FETCH is_contact INTO l_contact_id,l_delegate_contact_id;
891: CLOSE is_contact;
892:
893: If (p_delegate_person_id = hr_api.g_number) then
894: select delegate_person_id into l_person_id from ota_delegate_bookings
895: where booking_id = p_booking_id;
896: else l_person_id := p_delegate_person_id;
897: End If;
1036: --
1037: end if;
1038: --
1039: --Added for Bug#4106893
1040: IF p_event_id <> hr_api.g_number
1041: AND p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
1042: l_event_id_changed:= true;
1043: END IF;
1044:
1041: AND p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
1042: l_event_id_changed:= true;
1043: END IF;
1044:
1045: IF p_delegate_person_id <> hr_api.g_number
1046: AND p_delegate_person_id <> ota_tdb_shd.g_old_rec.delegate_person_id THEN
1047: l_person_id_changed := true;
1048: END IF;
1049:
1046: AND p_delegate_person_id <> ota_tdb_shd.g_old_rec.delegate_person_id THEN
1047: l_person_id_changed := true;
1048: END IF;
1049:
1050: IF p_delegate_contact_id <> hr_api.g_number
1051: AND p_delegate_contact_id <> ota_tdb_shd.g_old_rec.delegate_contact_id THEN
1052: l_contact_id_changed := true;
1053: END IF;
1054:
1283: -- When in validation only mode raise the Validate_Enabled exception
1284: --
1285: if p_validate then
1286: --
1287: raise hr_api.validate_enabled;
1288: --
1289: end if;
1290:
1291: --
1293: hr_utility.set_location('Leaving:'||l_proc, 10);
1294: end if;
1295: --
1296: exception
1297: when hr_api.validate_enabled then
1298: --
1299: -- As the Validate_Enabled exception has been raised
1300: -- we must rollback to the savepoint
1301: --
1403: Begin
1404: -- Prerequisite Validation Code
1405: l_check_prereq := false;
1406:
1407: If ( p_delegate_person_id = hr_api.g_number ) Then
1408: l_delegate_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;
1409: Else
1410: l_delegate_person_id := p_delegate_person_id;
1411: End If;
1409: Else
1410: l_delegate_person_id := p_delegate_person_id;
1411: End If;
1412:
1413: If ( p_delegate_contact_id = hr_api.g_number ) Then
1414: l_delegate_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;
1415: Else
1416: l_delegate_contact_id := p_delegate_contact_id;
1417: End If;
1415: Else
1416: l_delegate_contact_id := p_delegate_contact_id;
1417: End If;
1418:
1419: If ( p_customer_id = hr_api.g_number ) Then
1420: l_customer_id := ota_tdb_shd.g_old_rec.customer_id;
1421: Else
1422: l_customer_id := p_customer_id;
1423: End If;
1421: Else
1422: l_customer_id := p_customer_id;
1423: End If;
1424:
1425: If ( p_event_id = hr_api.g_number ) Then
1426: l_event_id := ota_tdb_shd.g_old_rec.event_id;
1427: Else
1428: l_event_id := p_event_id;
1429: End If;
1427: Else
1428: l_event_id := p_event_id;
1429: End If;
1430:
1431: If ( p_booking_status_type_id = hr_api.g_number ) Then
1432: l_booking_status_type_id := ota_tdb_shd.g_old_rec.booking_status_type_id;
1433: Else
1434: l_booking_status_type_id := p_booking_status_type_id;
1435: End If;