eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TDB_API_UPD2 dependencies on HR_API

Line 349: p_booking_status_type_id in number default hr_api.g_number,

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,

Line 350: p_delegate_person_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,

Line 351: p_contact_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,

Line 352: p_business_group_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,

Line 353: p_event_id in number default hr_api.g_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,
357: p_corespondent in varchar2 default hr_api.g_varchar2,

Line 354: p_customer_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,
358: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,

Line 355: p_authorizer_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,
359: p_number_of_places in number default hr_api.g_number,

Line 356: p_date_booking_placed in date default hr_api.g_date,

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,

Line 357: p_corespondent in varchar2 default hr_api.g_varchar2,

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,

Line 358: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,

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,

Line 359: p_number_of_places 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,
363: p_comments in varchar2 default hr_api.g_varchar2,

Line 361: p_administrator in number default hr_api.g_number,

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,

Line 362: p_booking_priority 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,

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

Line 364: p_contact_address_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,

Line 365: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,

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,

Line 366: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,

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,

Line 367: p_third_party_customer_id in number default hr_api.g_number,

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,

Line 368: p_third_party_contact_id in number default hr_api.g_number,

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,

Line 369: p_third_party_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,
373: p_status_change_comments in varchar2 default hr_api.g_varchar2,

Line 370: p_third_party_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,
374: p_failure_reason in varchar2 default hr_api.g_varchar2,

Line 371: p_third_party_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,
375: p_attendance_result in varchar2 default hr_api.g_varchar2,

Line 372: p_date_status_changed in date default hr_api.g_date,

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,

Line 373: p_status_change_comments in varchar2 default hr_api.g_varchar2,

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,

Line 374: p_failure_reason 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,

Line 375: p_attendance_result 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,

Line 376: p_language_id in number default hr_api.g_number,

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,

Line 377: p_source_of_booking 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,

Line 378: p_special_booking_instructions 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,

Line 379: p_successful_attendance_flag 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,

Line 380: p_tdb_information_category 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,

Line 381: p_tdb_information1 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,

Line 382: p_tdb_information2 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,

Line 383: p_tdb_information3 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,

Line 384: p_tdb_information4 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,

Line 385: p_tdb_information5 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,

Line 386: p_tdb_information6 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,

Line 387: p_tdb_information7 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,

Line 388: p_tdb_information8 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,

Line 389: p_tdb_information9 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,

Line 390: p_tdb_information10 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,

Line 391: p_tdb_information11 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,

Line 392: p_tdb_information12 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,

Line 393: p_tdb_information13 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,

Line 394: p_tdb_information14 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,

Line 395: p_tdb_information15 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,

Line 396: p_tdb_information16 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,

Line 397: p_tdb_information17 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',

Line 398: p_tdb_information18 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',
402: p_tfl_object_version_number in out nocopy number,

Line 399: p_tdb_information19 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,
403: p_finance_header_id in number default hr_api.g_number,

Line 400: p_tdb_information20 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,
404: p_finance_line_id in out nocopy number,

Line 403: p_finance_header_id in number default hr_api.g_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,

Line 405: p_standard_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,

Line 406: p_unitary_amount in number default hr_api.g_number,

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,

Line 407: p_money_amount 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,

Line 408: p_currency_code 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,

Line 409: p_booking_deal_type in varchar2 default hr_api.g_varchar2,

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,

Line 410: p_booking_deal_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,

Line 411: p_enrollment_type in varchar2 default hr_api.g_varchar2,

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,

Line 413: p_organization_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,

Line 414: p_sponsor_person_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,

Line 415: p_sponsor_assignment_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,

Line 416: p_person_address_id in number default hr_api.g_number,

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,

Line 417: p_delegate_assignment_id in number default hr_api.g_number,

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,

Line 418: p_delegate_contact_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,
422: p_line_id in number default hr_api.g_number,

Line 419: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,

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,

Line 420: p_third_party_email in varchar2 default hr_api.g_varchar2,

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,

Line 421: p_person_address_type 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,

Line 422: p_line_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,
426: p_old_event_id in number default hr_api.g_number,

Line 423: p_org_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,

Line 424: p_daemon_flag 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,
428: p_interface_source in varchar2 default hr_api.g_varchar2,

Line 425: p_daemon_type 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,

Line 426: p_old_event_id in number default hr_api.g_number,

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,

Line 427: p_quote_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,
431: p_score in number default hr_api.g_number,

Line 428: p_interface_source in varchar2 default hr_api.g_varchar2,

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,

Line 429: p_total_training_time 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,
433: p_total_content in number default hr_api.g_number,

Line 430: p_content_player_status 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,
434: p_booking_justification_id in number default hr_api.g_number,

Line 431: p_score 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,

Line 432: p_completed_content 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,
436: p_override_prerequisites in varchar2 default 'N',

Line 433: p_total_content in number default hr_api.g_number,

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

Line 434: p_booking_justification_id in number default hr_api.g_number,

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')

Line 437: p_is_history_flag in varchar2 default hr_api.g_varchar2

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: is
440:
441: l_proc varchar2(72) := g_package || ' ' || 'create_enrollment';

Line 680: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;

676: FETCH csr_get_enr_details INTO l_enr_details_rec;
677: CLOSE csr_get_enr_details;
678:
679: -- Modified for bug#4681165
680: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
681: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
682: 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;
683: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
684: 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;

Line 681: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;

677: CLOSE csr_get_enr_details;
678:
679: -- Modified for bug#4681165
680: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
681: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
682: 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;
683: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
684: 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;
685: 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;

Line 682: 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;

678:
679: -- Modified for bug#4681165
680: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
681: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
682: 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;
683: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
684: 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;
685: 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;
686:

Line 683: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;

679: -- Modified for bug#4681165
680: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
681: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
682: 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;
683: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
684: 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;
685: 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;
686:
687:

Line 684: 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;

680: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
681: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
682: 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;
683: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
684: 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;
685: 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;
686:
687:
688: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);

Line 685: 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;

681: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
682: 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;
683: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
684: 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;
685: 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;
686:
687:
688: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
689: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);

Line 713: IF nvl(p_status_change_comments,hr_api.g_varchar2) <> l_evt_status_chg_comments THEN

709: END IF;
710: END IF;
711:
712: -- Added for bug#4654530
713: IF nvl(p_status_change_comments,hr_api.g_varchar2) <> l_evt_status_chg_comments THEN
714:
715: OPEN get_status_info;
716: FETCH get_status_info INTO l_old_booking_status;
717: CLOSE get_status_info;

Line 891: If (p_delegate_person_id = hr_api.g_number) then

887: OPEN is_contact;
888: FETCH is_contact INTO l_contact_id,l_delegate_contact_id;
889: CLOSE is_contact;
890:
891: If (p_delegate_person_id = hr_api.g_number) then
892: select delegate_person_id into l_person_id from ota_delegate_bookings
893: where booking_id = p_booking_id;
894: else l_person_id := p_delegate_person_id;
895: End If;

Line 1038: IF p_event_id <> hr_api.g_number

1034: --
1035: end if;
1036: --
1037: --Added for Bug#4106893
1038: IF p_event_id <> hr_api.g_number
1039: AND p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
1040: l_event_id_changed:= true;
1041: END IF;
1042:

Line 1043: IF p_delegate_person_id <> hr_api.g_number

1039: AND p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
1040: l_event_id_changed:= true;
1041: END IF;
1042:
1043: IF p_delegate_person_id <> hr_api.g_number
1044: AND p_delegate_person_id <> ota_tdb_shd.g_old_rec.delegate_person_id THEN
1045: l_person_id_changed := true;
1046: END IF;
1047:

Line 1048: IF p_delegate_contact_id <> hr_api.g_number

1044: AND p_delegate_person_id <> ota_tdb_shd.g_old_rec.delegate_person_id THEN
1045: l_person_id_changed := true;
1046: END IF;
1047:
1048: IF p_delegate_contact_id <> hr_api.g_number
1049: AND p_delegate_contact_id <> ota_tdb_shd.g_old_rec.delegate_contact_id THEN
1050: l_contact_id_changed := true;
1051: END IF;
1052:

Line 1285: raise hr_api.validate_enabled;

1281: -- When in validation only mode raise the Validate_Enabled exception
1282: --
1283: if p_validate then
1284: --
1285: raise hr_api.validate_enabled;
1286: --
1287: end if;
1288:
1289: --

Line 1295: when hr_api.validate_enabled then

1291: hr_utility.set_location('Leaving:'||l_proc, 10);
1292: end if;
1293: --
1294: exception
1295: when hr_api.validate_enabled then
1296: --
1297: -- As the Validate_Enabled exception has been raised
1298: -- we must rollback to the savepoint
1299: --

Line 1405: If ( p_delegate_person_id = hr_api.g_number ) Then

1401: Begin
1402: -- Prerequisite Validation Code
1403: l_check_prereq := false;
1404:
1405: If ( p_delegate_person_id = hr_api.g_number ) Then
1406: l_delegate_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;
1407: Else
1408: l_delegate_person_id := p_delegate_person_id;
1409: End If;

Line 1411: If ( p_delegate_contact_id = hr_api.g_number ) Then

1407: Else
1408: l_delegate_person_id := p_delegate_person_id;
1409: End If;
1410:
1411: If ( p_delegate_contact_id = hr_api.g_number ) Then
1412: l_delegate_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;
1413: Else
1414: l_delegate_contact_id := p_delegate_contact_id;
1415: End If;

Line 1417: If ( p_customer_id = hr_api.g_number ) Then

1413: Else
1414: l_delegate_contact_id := p_delegate_contact_id;
1415: End If;
1416:
1417: If ( p_customer_id = hr_api.g_number ) Then
1418: l_customer_id := ota_tdb_shd.g_old_rec.customer_id;
1419: Else
1420: l_customer_id := p_customer_id;
1421: End If;

Line 1423: If ( p_event_id = hr_api.g_number ) Then

1419: Else
1420: l_customer_id := p_customer_id;
1421: End If;
1422:
1423: If ( p_event_id = hr_api.g_number ) Then
1424: l_event_id := ota_tdb_shd.g_old_rec.event_id;
1425: Else
1426: l_event_id := p_event_id;
1427: End If;

Line 1429: If ( p_booking_status_type_id = hr_api.g_number ) Then

1425: Else
1426: l_event_id := p_event_id;
1427: End If;
1428:
1429: If ( p_booking_status_type_id = hr_api.g_number ) Then
1430: l_booking_status_type_id := ota_tdb_shd.g_old_rec.booking_status_type_id;
1431: Else
1432: l_booking_status_type_id := p_booking_status_type_id;
1433: End If;