DBA Data[Home] [Help]

APPS.OTA_EVENT_API dependencies on HR_API

Line 268: when hr_api.cannot_find_prog_unit then

264: p_parent_offering_id => p_parent_offering_id,
265: p_data_source => p_data_source);
266:
267: exception
268: when hr_api.cannot_find_prog_unit then
269: hr_api.cannot_find_prog_unit_error
270: (p_module_name => 'CREATE_CLASS'
271: ,p_hook_type => 'BP'
272: );

Line 269: hr_api.cannot_find_prog_unit_error

265: p_data_source => p_data_source);
266:
267: exception
268: when hr_api.cannot_find_prog_unit then
269: hr_api.cannot_find_prog_unit_error
270: (p_module_name => 'CREATE_CLASS'
271: ,p_hook_type => 'BP'
272: );
273: end;

Line 441: when hr_api.cannot_find_prog_unit then

437: p_timezone => p_timezone,
438: p_parent_offering_id => p_parent_offering_id,
439: p_data_source => p_data_source);
440: exception
441: when hr_api.cannot_find_prog_unit then
442: hr_api.cannot_find_prog_unit_error
443: (p_module_name => 'CREATE_CLASS'
444: ,p_hook_type => 'AP'
445: );

Line 442: hr_api.cannot_find_prog_unit_error

438: p_parent_offering_id => p_parent_offering_id,
439: p_data_source => p_data_source);
440: exception
441: when hr_api.cannot_find_prog_unit then
442: hr_api.cannot_find_prog_unit_error
443: (p_module_name => 'CREATE_CLASS'
444: ,p_hook_type => 'AP'
445: );
446: end;

Line 452: raise hr_api.validate_enabled;

448: --
449: -- When in validation only mode raise the Validate_Enabled exception
450: --
451: if p_validate then
452: raise hr_api.validate_enabled;
453: end if;
454: --
455: -- Set all output arguments
456: --

Line 462: when hr_api.validate_enabled then

458: p_object_version_number := l_object_version_number;
459: --
460: hr_utility.set_location(' Leaving:'||l_proc, 70);
461: exception
462: when hr_api.validate_enabled then
463: --
464: -- As the Validate_Enabled exception has been raised
465: -- we must rollback to the savepoint
466: --

Line 493: p_vendor_id in number default hr_api.g_number,

489: --
490: procedure update_class
491: (p_event_id in number,
492: p_effective_date in date,
493: p_vendor_id in number default hr_api.g_number,
494: p_activity_version_id in number default hr_api.g_number,
495: p_business_group_id in number default hr_api.g_number,
496: p_organization_id in number default hr_api.g_number,
497: p_event_type in varchar2 default hr_api.g_varchar2,

Line 494: p_activity_version_id in number default hr_api.g_number,

490: procedure update_class
491: (p_event_id in number,
492: p_effective_date in date,
493: p_vendor_id in number default hr_api.g_number,
494: p_activity_version_id in number default hr_api.g_number,
495: p_business_group_id in number default hr_api.g_number,
496: p_organization_id in number default hr_api.g_number,
497: p_event_type in varchar2 default hr_api.g_varchar2,
498: p_object_version_number in out nocopy number,

Line 495: p_business_group_id in number default hr_api.g_number,

491: (p_event_id in number,
492: p_effective_date in date,
493: p_vendor_id in number default hr_api.g_number,
494: p_activity_version_id in number default hr_api.g_number,
495: p_business_group_id in number default hr_api.g_number,
496: p_organization_id in number default hr_api.g_number,
497: p_event_type in varchar2 default hr_api.g_varchar2,
498: p_object_version_number in out nocopy number,
499: p_title in varchar2 default hr_api.g_varchar2,

Line 496: p_organization_id in number default hr_api.g_number,

492: p_effective_date in date,
493: p_vendor_id in number default hr_api.g_number,
494: p_activity_version_id in number default hr_api.g_number,
495: p_business_group_id in number default hr_api.g_number,
496: p_organization_id in number default hr_api.g_number,
497: p_event_type in varchar2 default hr_api.g_varchar2,
498: p_object_version_number in out nocopy number,
499: p_title in varchar2 default hr_api.g_varchar2,
500: p_budget_cost in number default hr_api.g_number,

Line 497: p_event_type in varchar2 default hr_api.g_varchar2,

493: p_vendor_id in number default hr_api.g_number,
494: p_activity_version_id in number default hr_api.g_number,
495: p_business_group_id in number default hr_api.g_number,
496: p_organization_id in number default hr_api.g_number,
497: p_event_type in varchar2 default hr_api.g_varchar2,
498: p_object_version_number in out nocopy number,
499: p_title in varchar2 default hr_api.g_varchar2,
500: p_budget_cost in number default hr_api.g_number,
501: p_actual_cost in number default hr_api.g_number,

Line 499: p_title in varchar2 default hr_api.g_varchar2,

495: p_business_group_id in number default hr_api.g_number,
496: p_organization_id in number default hr_api.g_number,
497: p_event_type in varchar2 default hr_api.g_varchar2,
498: p_object_version_number in out nocopy number,
499: p_title in varchar2 default hr_api.g_varchar2,
500: p_budget_cost in number default hr_api.g_number,
501: p_actual_cost in number default hr_api.g_number,
502: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
503: p_centre in varchar2 default hr_api.g_varchar2,

Line 500: p_budget_cost in number default hr_api.g_number,

496: p_organization_id in number default hr_api.g_number,
497: p_event_type in varchar2 default hr_api.g_varchar2,
498: p_object_version_number in out nocopy number,
499: p_title in varchar2 default hr_api.g_varchar2,
500: p_budget_cost in number default hr_api.g_number,
501: p_actual_cost in number default hr_api.g_number,
502: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
503: p_centre in varchar2 default hr_api.g_varchar2,
504: p_comments in varchar2 default hr_api.g_varchar2,

Line 501: p_actual_cost in number default hr_api.g_number,

497: p_event_type in varchar2 default hr_api.g_varchar2,
498: p_object_version_number in out nocopy number,
499: p_title in varchar2 default hr_api.g_varchar2,
500: p_budget_cost in number default hr_api.g_number,
501: p_actual_cost in number default hr_api.g_number,
502: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
503: p_centre in varchar2 default hr_api.g_varchar2,
504: p_comments in varchar2 default hr_api.g_varchar2,
505: p_course_end_date in date default hr_api.g_date,

Line 502: p_budget_currency_code in varchar2 default hr_api.g_varchar2,

498: p_object_version_number in out nocopy number,
499: p_title in varchar2 default hr_api.g_varchar2,
500: p_budget_cost in number default hr_api.g_number,
501: p_actual_cost in number default hr_api.g_number,
502: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
503: p_centre in varchar2 default hr_api.g_varchar2,
504: p_comments in varchar2 default hr_api.g_varchar2,
505: p_course_end_date in date default hr_api.g_date,
506: p_course_end_time in varchar2 default hr_api.g_varchar2,

Line 503: p_centre in varchar2 default hr_api.g_varchar2,

499: p_title in varchar2 default hr_api.g_varchar2,
500: p_budget_cost in number default hr_api.g_number,
501: p_actual_cost in number default hr_api.g_number,
502: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
503: p_centre in varchar2 default hr_api.g_varchar2,
504: p_comments in varchar2 default hr_api.g_varchar2,
505: p_course_end_date in date default hr_api.g_date,
506: p_course_end_time in varchar2 default hr_api.g_varchar2,
507: p_course_start_date in date default hr_api.g_date,

Line 504: p_comments in varchar2 default hr_api.g_varchar2,

500: p_budget_cost in number default hr_api.g_number,
501: p_actual_cost in number default hr_api.g_number,
502: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
503: p_centre in varchar2 default hr_api.g_varchar2,
504: p_comments in varchar2 default hr_api.g_varchar2,
505: p_course_end_date in date default hr_api.g_date,
506: p_course_end_time in varchar2 default hr_api.g_varchar2,
507: p_course_start_date in date default hr_api.g_date,
508: p_course_start_time in varchar2 default hr_api.g_varchar2,

Line 505: p_course_end_date in date default hr_api.g_date,

501: p_actual_cost in number default hr_api.g_number,
502: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
503: p_centre in varchar2 default hr_api.g_varchar2,
504: p_comments in varchar2 default hr_api.g_varchar2,
505: p_course_end_date in date default hr_api.g_date,
506: p_course_end_time in varchar2 default hr_api.g_varchar2,
507: p_course_start_date in date default hr_api.g_date,
508: p_course_start_time in varchar2 default hr_api.g_varchar2,
509: p_duration in number default hr_api.g_number,

Line 506: p_course_end_time in varchar2 default hr_api.g_varchar2,

502: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
503: p_centre in varchar2 default hr_api.g_varchar2,
504: p_comments in varchar2 default hr_api.g_varchar2,
505: p_course_end_date in date default hr_api.g_date,
506: p_course_end_time in varchar2 default hr_api.g_varchar2,
507: p_course_start_date in date default hr_api.g_date,
508: p_course_start_time in varchar2 default hr_api.g_varchar2,
509: p_duration in number default hr_api.g_number,
510: p_duration_units in varchar2 default hr_api.g_varchar2,

Line 507: p_course_start_date in date default hr_api.g_date,

503: p_centre in varchar2 default hr_api.g_varchar2,
504: p_comments in varchar2 default hr_api.g_varchar2,
505: p_course_end_date in date default hr_api.g_date,
506: p_course_end_time in varchar2 default hr_api.g_varchar2,
507: p_course_start_date in date default hr_api.g_date,
508: p_course_start_time in varchar2 default hr_api.g_varchar2,
509: p_duration in number default hr_api.g_number,
510: p_duration_units in varchar2 default hr_api.g_varchar2,
511: p_enrolment_end_date in date default hr_api.g_date,

Line 508: p_course_start_time in varchar2 default hr_api.g_varchar2,

504: p_comments in varchar2 default hr_api.g_varchar2,
505: p_course_end_date in date default hr_api.g_date,
506: p_course_end_time in varchar2 default hr_api.g_varchar2,
507: p_course_start_date in date default hr_api.g_date,
508: p_course_start_time in varchar2 default hr_api.g_varchar2,
509: p_duration in number default hr_api.g_number,
510: p_duration_units in varchar2 default hr_api.g_varchar2,
511: p_enrolment_end_date in date default hr_api.g_date,
512: p_enrolment_start_date in date default hr_api.g_date,

Line 509: p_duration in number default hr_api.g_number,

505: p_course_end_date in date default hr_api.g_date,
506: p_course_end_time in varchar2 default hr_api.g_varchar2,
507: p_course_start_date in date default hr_api.g_date,
508: p_course_start_time in varchar2 default hr_api.g_varchar2,
509: p_duration in number default hr_api.g_number,
510: p_duration_units in varchar2 default hr_api.g_varchar2,
511: p_enrolment_end_date in date default hr_api.g_date,
512: p_enrolment_start_date in date default hr_api.g_date,
513: p_language_id in number default hr_api.g_number,

Line 510: p_duration_units in varchar2 default hr_api.g_varchar2,

506: p_course_end_time in varchar2 default hr_api.g_varchar2,
507: p_course_start_date in date default hr_api.g_date,
508: p_course_start_time in varchar2 default hr_api.g_varchar2,
509: p_duration in number default hr_api.g_number,
510: p_duration_units in varchar2 default hr_api.g_varchar2,
511: p_enrolment_end_date in date default hr_api.g_date,
512: p_enrolment_start_date in date default hr_api.g_date,
513: p_language_id in number default hr_api.g_number,
514: p_user_status in varchar2 default hr_api.g_varchar2,

Line 511: p_enrolment_end_date in date default hr_api.g_date,

507: p_course_start_date in date default hr_api.g_date,
508: p_course_start_time in varchar2 default hr_api.g_varchar2,
509: p_duration in number default hr_api.g_number,
510: p_duration_units in varchar2 default hr_api.g_varchar2,
511: p_enrolment_end_date in date default hr_api.g_date,
512: p_enrolment_start_date in date default hr_api.g_date,
513: p_language_id in number default hr_api.g_number,
514: p_user_status in varchar2 default hr_api.g_varchar2,
515: p_development_event_type in varchar2 default hr_api.g_varchar2,

Line 512: p_enrolment_start_date in date default hr_api.g_date,

508: p_course_start_time in varchar2 default hr_api.g_varchar2,
509: p_duration in number default hr_api.g_number,
510: p_duration_units in varchar2 default hr_api.g_varchar2,
511: p_enrolment_end_date in date default hr_api.g_date,
512: p_enrolment_start_date in date default hr_api.g_date,
513: p_language_id in number default hr_api.g_number,
514: p_user_status in varchar2 default hr_api.g_varchar2,
515: p_development_event_type in varchar2 default hr_api.g_varchar2,
516: p_event_status in varchar2 default hr_api.g_varchar2,

Line 513: p_language_id in number default hr_api.g_number,

509: p_duration in number default hr_api.g_number,
510: p_duration_units in varchar2 default hr_api.g_varchar2,
511: p_enrolment_end_date in date default hr_api.g_date,
512: p_enrolment_start_date in date default hr_api.g_date,
513: p_language_id in number default hr_api.g_number,
514: p_user_status in varchar2 default hr_api.g_varchar2,
515: p_development_event_type in varchar2 default hr_api.g_varchar2,
516: p_event_status in varchar2 default hr_api.g_varchar2,
517: p_price_basis in varchar2 default hr_api.g_varchar2,

Line 514: p_user_status in varchar2 default hr_api.g_varchar2,

510: p_duration_units in varchar2 default hr_api.g_varchar2,
511: p_enrolment_end_date in date default hr_api.g_date,
512: p_enrolment_start_date in date default hr_api.g_date,
513: p_language_id in number default hr_api.g_number,
514: p_user_status in varchar2 default hr_api.g_varchar2,
515: p_development_event_type in varchar2 default hr_api.g_varchar2,
516: p_event_status in varchar2 default hr_api.g_varchar2,
517: p_price_basis in varchar2 default hr_api.g_varchar2,
518: p_currency_code in varchar2 default hr_api.g_varchar2,

Line 515: p_development_event_type in varchar2 default hr_api.g_varchar2,

511: p_enrolment_end_date in date default hr_api.g_date,
512: p_enrolment_start_date in date default hr_api.g_date,
513: p_language_id in number default hr_api.g_number,
514: p_user_status in varchar2 default hr_api.g_varchar2,
515: p_development_event_type in varchar2 default hr_api.g_varchar2,
516: p_event_status in varchar2 default hr_api.g_varchar2,
517: p_price_basis in varchar2 default hr_api.g_varchar2,
518: p_currency_code in varchar2 default hr_api.g_varchar2,
519: p_maximum_attendees in number default hr_api.g_number,

Line 516: p_event_status in varchar2 default hr_api.g_varchar2,

512: p_enrolment_start_date in date default hr_api.g_date,
513: p_language_id in number default hr_api.g_number,
514: p_user_status in varchar2 default hr_api.g_varchar2,
515: p_development_event_type in varchar2 default hr_api.g_varchar2,
516: p_event_status in varchar2 default hr_api.g_varchar2,
517: p_price_basis in varchar2 default hr_api.g_varchar2,
518: p_currency_code in varchar2 default hr_api.g_varchar2,
519: p_maximum_attendees in number default hr_api.g_number,
520: p_maximum_internal_attendees in number default hr_api.g_number,

Line 517: p_price_basis in varchar2 default hr_api.g_varchar2,

513: p_language_id in number default hr_api.g_number,
514: p_user_status in varchar2 default hr_api.g_varchar2,
515: p_development_event_type in varchar2 default hr_api.g_varchar2,
516: p_event_status in varchar2 default hr_api.g_varchar2,
517: p_price_basis in varchar2 default hr_api.g_varchar2,
518: p_currency_code in varchar2 default hr_api.g_varchar2,
519: p_maximum_attendees in number default hr_api.g_number,
520: p_maximum_internal_attendees in number default hr_api.g_number,
521: p_minimum_attendees in number default hr_api.g_number,

Line 518: p_currency_code in varchar2 default hr_api.g_varchar2,

514: p_user_status in varchar2 default hr_api.g_varchar2,
515: p_development_event_type in varchar2 default hr_api.g_varchar2,
516: p_event_status in varchar2 default hr_api.g_varchar2,
517: p_price_basis in varchar2 default hr_api.g_varchar2,
518: p_currency_code in varchar2 default hr_api.g_varchar2,
519: p_maximum_attendees in number default hr_api.g_number,
520: p_maximum_internal_attendees in number default hr_api.g_number,
521: p_minimum_attendees in number default hr_api.g_number,
522: p_standard_price in number default hr_api.g_number,

Line 519: p_maximum_attendees in number default hr_api.g_number,

515: p_development_event_type in varchar2 default hr_api.g_varchar2,
516: p_event_status in varchar2 default hr_api.g_varchar2,
517: p_price_basis in varchar2 default hr_api.g_varchar2,
518: p_currency_code in varchar2 default hr_api.g_varchar2,
519: p_maximum_attendees in number default hr_api.g_number,
520: p_maximum_internal_attendees in number default hr_api.g_number,
521: p_minimum_attendees in number default hr_api.g_number,
522: p_standard_price in number default hr_api.g_number,
523: p_category_code in varchar2 default hr_api.g_varchar2,

Line 520: p_maximum_internal_attendees in number default hr_api.g_number,

516: p_event_status in varchar2 default hr_api.g_varchar2,
517: p_price_basis in varchar2 default hr_api.g_varchar2,
518: p_currency_code in varchar2 default hr_api.g_varchar2,
519: p_maximum_attendees in number default hr_api.g_number,
520: p_maximum_internal_attendees in number default hr_api.g_number,
521: p_minimum_attendees in number default hr_api.g_number,
522: p_standard_price in number default hr_api.g_number,
523: p_category_code in varchar2 default hr_api.g_varchar2,
524: p_parent_event_id in number default hr_api.g_number,

Line 521: p_minimum_attendees in number default hr_api.g_number,

517: p_price_basis in varchar2 default hr_api.g_varchar2,
518: p_currency_code in varchar2 default hr_api.g_varchar2,
519: p_maximum_attendees in number default hr_api.g_number,
520: p_maximum_internal_attendees in number default hr_api.g_number,
521: p_minimum_attendees in number default hr_api.g_number,
522: p_standard_price in number default hr_api.g_number,
523: p_category_code in varchar2 default hr_api.g_varchar2,
524: p_parent_event_id in number default hr_api.g_number,
525: p_book_independent_flag in varchar2 default hr_api.g_varchar2,

Line 522: p_standard_price in number default hr_api.g_number,

518: p_currency_code in varchar2 default hr_api.g_varchar2,
519: p_maximum_attendees in number default hr_api.g_number,
520: p_maximum_internal_attendees in number default hr_api.g_number,
521: p_minimum_attendees in number default hr_api.g_number,
522: p_standard_price in number default hr_api.g_number,
523: p_category_code in varchar2 default hr_api.g_varchar2,
524: p_parent_event_id in number default hr_api.g_number,
525: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
526: p_public_event_flag in varchar2 default hr_api.g_varchar2,

Line 523: p_category_code in varchar2 default hr_api.g_varchar2,

519: p_maximum_attendees in number default hr_api.g_number,
520: p_maximum_internal_attendees in number default hr_api.g_number,
521: p_minimum_attendees in number default hr_api.g_number,
522: p_standard_price in number default hr_api.g_number,
523: p_category_code in varchar2 default hr_api.g_varchar2,
524: p_parent_event_id in number default hr_api.g_number,
525: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
526: p_public_event_flag in varchar2 default hr_api.g_varchar2,
527: p_secure_event_flag in varchar2 default hr_api.g_varchar2,

Line 524: p_parent_event_id in number default hr_api.g_number,

520: p_maximum_internal_attendees in number default hr_api.g_number,
521: p_minimum_attendees in number default hr_api.g_number,
522: p_standard_price in number default hr_api.g_number,
523: p_category_code in varchar2 default hr_api.g_varchar2,
524: p_parent_event_id in number default hr_api.g_number,
525: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
526: p_public_event_flag in varchar2 default hr_api.g_varchar2,
527: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
528: p_evt_information_category in varchar2 default hr_api.g_varchar2,

Line 525: p_book_independent_flag in varchar2 default hr_api.g_varchar2,

521: p_minimum_attendees in number default hr_api.g_number,
522: p_standard_price in number default hr_api.g_number,
523: p_category_code in varchar2 default hr_api.g_varchar2,
524: p_parent_event_id in number default hr_api.g_number,
525: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
526: p_public_event_flag in varchar2 default hr_api.g_varchar2,
527: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
528: p_evt_information_category in varchar2 default hr_api.g_varchar2,
529: p_evt_information1 in varchar2 default hr_api.g_varchar2,

Line 526: p_public_event_flag in varchar2 default hr_api.g_varchar2,

522: p_standard_price in number default hr_api.g_number,
523: p_category_code in varchar2 default hr_api.g_varchar2,
524: p_parent_event_id in number default hr_api.g_number,
525: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
526: p_public_event_flag in varchar2 default hr_api.g_varchar2,
527: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
528: p_evt_information_category in varchar2 default hr_api.g_varchar2,
529: p_evt_information1 in varchar2 default hr_api.g_varchar2,
530: p_evt_information2 in varchar2 default hr_api.g_varchar2,

Line 527: p_secure_event_flag in varchar2 default hr_api.g_varchar2,

523: p_category_code in varchar2 default hr_api.g_varchar2,
524: p_parent_event_id in number default hr_api.g_number,
525: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
526: p_public_event_flag in varchar2 default hr_api.g_varchar2,
527: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
528: p_evt_information_category in varchar2 default hr_api.g_varchar2,
529: p_evt_information1 in varchar2 default hr_api.g_varchar2,
530: p_evt_information2 in varchar2 default hr_api.g_varchar2,
531: p_evt_information3 in varchar2 default hr_api.g_varchar2,

Line 528: p_evt_information_category in varchar2 default hr_api.g_varchar2,

524: p_parent_event_id in number default hr_api.g_number,
525: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
526: p_public_event_flag in varchar2 default hr_api.g_varchar2,
527: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
528: p_evt_information_category in varchar2 default hr_api.g_varchar2,
529: p_evt_information1 in varchar2 default hr_api.g_varchar2,
530: p_evt_information2 in varchar2 default hr_api.g_varchar2,
531: p_evt_information3 in varchar2 default hr_api.g_varchar2,
532: p_evt_information4 in varchar2 default hr_api.g_varchar2,

Line 529: p_evt_information1 in varchar2 default hr_api.g_varchar2,

525: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
526: p_public_event_flag in varchar2 default hr_api.g_varchar2,
527: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
528: p_evt_information_category in varchar2 default hr_api.g_varchar2,
529: p_evt_information1 in varchar2 default hr_api.g_varchar2,
530: p_evt_information2 in varchar2 default hr_api.g_varchar2,
531: p_evt_information3 in varchar2 default hr_api.g_varchar2,
532: p_evt_information4 in varchar2 default hr_api.g_varchar2,
533: p_evt_information5 in varchar2 default hr_api.g_varchar2,

Line 530: p_evt_information2 in varchar2 default hr_api.g_varchar2,

526: p_public_event_flag in varchar2 default hr_api.g_varchar2,
527: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
528: p_evt_information_category in varchar2 default hr_api.g_varchar2,
529: p_evt_information1 in varchar2 default hr_api.g_varchar2,
530: p_evt_information2 in varchar2 default hr_api.g_varchar2,
531: p_evt_information3 in varchar2 default hr_api.g_varchar2,
532: p_evt_information4 in varchar2 default hr_api.g_varchar2,
533: p_evt_information5 in varchar2 default hr_api.g_varchar2,
534: p_evt_information6 in varchar2 default hr_api.g_varchar2,

Line 531: p_evt_information3 in varchar2 default hr_api.g_varchar2,

527: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
528: p_evt_information_category in varchar2 default hr_api.g_varchar2,
529: p_evt_information1 in varchar2 default hr_api.g_varchar2,
530: p_evt_information2 in varchar2 default hr_api.g_varchar2,
531: p_evt_information3 in varchar2 default hr_api.g_varchar2,
532: p_evt_information4 in varchar2 default hr_api.g_varchar2,
533: p_evt_information5 in varchar2 default hr_api.g_varchar2,
534: p_evt_information6 in varchar2 default hr_api.g_varchar2,
535: p_evt_information7 in varchar2 default hr_api.g_varchar2,

Line 532: p_evt_information4 in varchar2 default hr_api.g_varchar2,

528: p_evt_information_category in varchar2 default hr_api.g_varchar2,
529: p_evt_information1 in varchar2 default hr_api.g_varchar2,
530: p_evt_information2 in varchar2 default hr_api.g_varchar2,
531: p_evt_information3 in varchar2 default hr_api.g_varchar2,
532: p_evt_information4 in varchar2 default hr_api.g_varchar2,
533: p_evt_information5 in varchar2 default hr_api.g_varchar2,
534: p_evt_information6 in varchar2 default hr_api.g_varchar2,
535: p_evt_information7 in varchar2 default hr_api.g_varchar2,
536: p_evt_information8 in varchar2 default hr_api.g_varchar2,

Line 533: p_evt_information5 in varchar2 default hr_api.g_varchar2,

529: p_evt_information1 in varchar2 default hr_api.g_varchar2,
530: p_evt_information2 in varchar2 default hr_api.g_varchar2,
531: p_evt_information3 in varchar2 default hr_api.g_varchar2,
532: p_evt_information4 in varchar2 default hr_api.g_varchar2,
533: p_evt_information5 in varchar2 default hr_api.g_varchar2,
534: p_evt_information6 in varchar2 default hr_api.g_varchar2,
535: p_evt_information7 in varchar2 default hr_api.g_varchar2,
536: p_evt_information8 in varchar2 default hr_api.g_varchar2,
537: p_evt_information9 in varchar2 default hr_api.g_varchar2,

Line 534: p_evt_information6 in varchar2 default hr_api.g_varchar2,

530: p_evt_information2 in varchar2 default hr_api.g_varchar2,
531: p_evt_information3 in varchar2 default hr_api.g_varchar2,
532: p_evt_information4 in varchar2 default hr_api.g_varchar2,
533: p_evt_information5 in varchar2 default hr_api.g_varchar2,
534: p_evt_information6 in varchar2 default hr_api.g_varchar2,
535: p_evt_information7 in varchar2 default hr_api.g_varchar2,
536: p_evt_information8 in varchar2 default hr_api.g_varchar2,
537: p_evt_information9 in varchar2 default hr_api.g_varchar2,
538: p_evt_information10 in varchar2 default hr_api.g_varchar2,

Line 535: p_evt_information7 in varchar2 default hr_api.g_varchar2,

531: p_evt_information3 in varchar2 default hr_api.g_varchar2,
532: p_evt_information4 in varchar2 default hr_api.g_varchar2,
533: p_evt_information5 in varchar2 default hr_api.g_varchar2,
534: p_evt_information6 in varchar2 default hr_api.g_varchar2,
535: p_evt_information7 in varchar2 default hr_api.g_varchar2,
536: p_evt_information8 in varchar2 default hr_api.g_varchar2,
537: p_evt_information9 in varchar2 default hr_api.g_varchar2,
538: p_evt_information10 in varchar2 default hr_api.g_varchar2,
539: p_evt_information11 in varchar2 default hr_api.g_varchar2,

Line 536: p_evt_information8 in varchar2 default hr_api.g_varchar2,

532: p_evt_information4 in varchar2 default hr_api.g_varchar2,
533: p_evt_information5 in varchar2 default hr_api.g_varchar2,
534: p_evt_information6 in varchar2 default hr_api.g_varchar2,
535: p_evt_information7 in varchar2 default hr_api.g_varchar2,
536: p_evt_information8 in varchar2 default hr_api.g_varchar2,
537: p_evt_information9 in varchar2 default hr_api.g_varchar2,
538: p_evt_information10 in varchar2 default hr_api.g_varchar2,
539: p_evt_information11 in varchar2 default hr_api.g_varchar2,
540: p_evt_information12 in varchar2 default hr_api.g_varchar2,

Line 537: p_evt_information9 in varchar2 default hr_api.g_varchar2,

533: p_evt_information5 in varchar2 default hr_api.g_varchar2,
534: p_evt_information6 in varchar2 default hr_api.g_varchar2,
535: p_evt_information7 in varchar2 default hr_api.g_varchar2,
536: p_evt_information8 in varchar2 default hr_api.g_varchar2,
537: p_evt_information9 in varchar2 default hr_api.g_varchar2,
538: p_evt_information10 in varchar2 default hr_api.g_varchar2,
539: p_evt_information11 in varchar2 default hr_api.g_varchar2,
540: p_evt_information12 in varchar2 default hr_api.g_varchar2,
541: p_evt_information13 in varchar2 default hr_api.g_varchar2,

Line 538: p_evt_information10 in varchar2 default hr_api.g_varchar2,

534: p_evt_information6 in varchar2 default hr_api.g_varchar2,
535: p_evt_information7 in varchar2 default hr_api.g_varchar2,
536: p_evt_information8 in varchar2 default hr_api.g_varchar2,
537: p_evt_information9 in varchar2 default hr_api.g_varchar2,
538: p_evt_information10 in varchar2 default hr_api.g_varchar2,
539: p_evt_information11 in varchar2 default hr_api.g_varchar2,
540: p_evt_information12 in varchar2 default hr_api.g_varchar2,
541: p_evt_information13 in varchar2 default hr_api.g_varchar2,
542: p_evt_information14 in varchar2 default hr_api.g_varchar2,

Line 539: p_evt_information11 in varchar2 default hr_api.g_varchar2,

535: p_evt_information7 in varchar2 default hr_api.g_varchar2,
536: p_evt_information8 in varchar2 default hr_api.g_varchar2,
537: p_evt_information9 in varchar2 default hr_api.g_varchar2,
538: p_evt_information10 in varchar2 default hr_api.g_varchar2,
539: p_evt_information11 in varchar2 default hr_api.g_varchar2,
540: p_evt_information12 in varchar2 default hr_api.g_varchar2,
541: p_evt_information13 in varchar2 default hr_api.g_varchar2,
542: p_evt_information14 in varchar2 default hr_api.g_varchar2,
543: p_evt_information15 in varchar2 default hr_api.g_varchar2,

Line 540: p_evt_information12 in varchar2 default hr_api.g_varchar2,

536: p_evt_information8 in varchar2 default hr_api.g_varchar2,
537: p_evt_information9 in varchar2 default hr_api.g_varchar2,
538: p_evt_information10 in varchar2 default hr_api.g_varchar2,
539: p_evt_information11 in varchar2 default hr_api.g_varchar2,
540: p_evt_information12 in varchar2 default hr_api.g_varchar2,
541: p_evt_information13 in varchar2 default hr_api.g_varchar2,
542: p_evt_information14 in varchar2 default hr_api.g_varchar2,
543: p_evt_information15 in varchar2 default hr_api.g_varchar2,
544: p_evt_information16 in varchar2 default hr_api.g_varchar2,

Line 541: p_evt_information13 in varchar2 default hr_api.g_varchar2,

537: p_evt_information9 in varchar2 default hr_api.g_varchar2,
538: p_evt_information10 in varchar2 default hr_api.g_varchar2,
539: p_evt_information11 in varchar2 default hr_api.g_varchar2,
540: p_evt_information12 in varchar2 default hr_api.g_varchar2,
541: p_evt_information13 in varchar2 default hr_api.g_varchar2,
542: p_evt_information14 in varchar2 default hr_api.g_varchar2,
543: p_evt_information15 in varchar2 default hr_api.g_varchar2,
544: p_evt_information16 in varchar2 default hr_api.g_varchar2,
545: p_evt_information17 in varchar2 default hr_api.g_varchar2,

Line 542: p_evt_information14 in varchar2 default hr_api.g_varchar2,

538: p_evt_information10 in varchar2 default hr_api.g_varchar2,
539: p_evt_information11 in varchar2 default hr_api.g_varchar2,
540: p_evt_information12 in varchar2 default hr_api.g_varchar2,
541: p_evt_information13 in varchar2 default hr_api.g_varchar2,
542: p_evt_information14 in varchar2 default hr_api.g_varchar2,
543: p_evt_information15 in varchar2 default hr_api.g_varchar2,
544: p_evt_information16 in varchar2 default hr_api.g_varchar2,
545: p_evt_information17 in varchar2 default hr_api.g_varchar2,
546: p_evt_information18 in varchar2 default hr_api.g_varchar2,

Line 543: p_evt_information15 in varchar2 default hr_api.g_varchar2,

539: p_evt_information11 in varchar2 default hr_api.g_varchar2,
540: p_evt_information12 in varchar2 default hr_api.g_varchar2,
541: p_evt_information13 in varchar2 default hr_api.g_varchar2,
542: p_evt_information14 in varchar2 default hr_api.g_varchar2,
543: p_evt_information15 in varchar2 default hr_api.g_varchar2,
544: p_evt_information16 in varchar2 default hr_api.g_varchar2,
545: p_evt_information17 in varchar2 default hr_api.g_varchar2,
546: p_evt_information18 in varchar2 default hr_api.g_varchar2,
547: p_evt_information19 in varchar2 default hr_api.g_varchar2,

Line 544: p_evt_information16 in varchar2 default hr_api.g_varchar2,

540: p_evt_information12 in varchar2 default hr_api.g_varchar2,
541: p_evt_information13 in varchar2 default hr_api.g_varchar2,
542: p_evt_information14 in varchar2 default hr_api.g_varchar2,
543: p_evt_information15 in varchar2 default hr_api.g_varchar2,
544: p_evt_information16 in varchar2 default hr_api.g_varchar2,
545: p_evt_information17 in varchar2 default hr_api.g_varchar2,
546: p_evt_information18 in varchar2 default hr_api.g_varchar2,
547: p_evt_information19 in varchar2 default hr_api.g_varchar2,
548: p_evt_information20 in varchar2 default hr_api.g_varchar2,

Line 545: p_evt_information17 in varchar2 default hr_api.g_varchar2,

541: p_evt_information13 in varchar2 default hr_api.g_varchar2,
542: p_evt_information14 in varchar2 default hr_api.g_varchar2,
543: p_evt_information15 in varchar2 default hr_api.g_varchar2,
544: p_evt_information16 in varchar2 default hr_api.g_varchar2,
545: p_evt_information17 in varchar2 default hr_api.g_varchar2,
546: p_evt_information18 in varchar2 default hr_api.g_varchar2,
547: p_evt_information19 in varchar2 default hr_api.g_varchar2,
548: p_evt_information20 in varchar2 default hr_api.g_varchar2,
549: p_project_id in number default hr_api.g_number,

Line 546: p_evt_information18 in varchar2 default hr_api.g_varchar2,

542: p_evt_information14 in varchar2 default hr_api.g_varchar2,
543: p_evt_information15 in varchar2 default hr_api.g_varchar2,
544: p_evt_information16 in varchar2 default hr_api.g_varchar2,
545: p_evt_information17 in varchar2 default hr_api.g_varchar2,
546: p_evt_information18 in varchar2 default hr_api.g_varchar2,
547: p_evt_information19 in varchar2 default hr_api.g_varchar2,
548: p_evt_information20 in varchar2 default hr_api.g_varchar2,
549: p_project_id in number default hr_api.g_number,
550: p_owner_id in number default hr_api.g_number,

Line 547: p_evt_information19 in varchar2 default hr_api.g_varchar2,

543: p_evt_information15 in varchar2 default hr_api.g_varchar2,
544: p_evt_information16 in varchar2 default hr_api.g_varchar2,
545: p_evt_information17 in varchar2 default hr_api.g_varchar2,
546: p_evt_information18 in varchar2 default hr_api.g_varchar2,
547: p_evt_information19 in varchar2 default hr_api.g_varchar2,
548: p_evt_information20 in varchar2 default hr_api.g_varchar2,
549: p_project_id in number default hr_api.g_number,
550: p_owner_id in number default hr_api.g_number,
551: p_line_id in number default hr_api.g_number,

Line 548: p_evt_information20 in varchar2 default hr_api.g_varchar2,

544: p_evt_information16 in varchar2 default hr_api.g_varchar2,
545: p_evt_information17 in varchar2 default hr_api.g_varchar2,
546: p_evt_information18 in varchar2 default hr_api.g_varchar2,
547: p_evt_information19 in varchar2 default hr_api.g_varchar2,
548: p_evt_information20 in varchar2 default hr_api.g_varchar2,
549: p_project_id in number default hr_api.g_number,
550: p_owner_id in number default hr_api.g_number,
551: p_line_id in number default hr_api.g_number,
552: p_org_id in number default hr_api.g_number,

Line 549: p_project_id in number default hr_api.g_number,

545: p_evt_information17 in varchar2 default hr_api.g_varchar2,
546: p_evt_information18 in varchar2 default hr_api.g_varchar2,
547: p_evt_information19 in varchar2 default hr_api.g_varchar2,
548: p_evt_information20 in varchar2 default hr_api.g_varchar2,
549: p_project_id in number default hr_api.g_number,
550: p_owner_id in number default hr_api.g_number,
551: p_line_id in number default hr_api.g_number,
552: p_org_id in number default hr_api.g_number,
553: p_training_center_id in number default hr_api.g_number,

Line 550: p_owner_id in number default hr_api.g_number,

546: p_evt_information18 in varchar2 default hr_api.g_varchar2,
547: p_evt_information19 in varchar2 default hr_api.g_varchar2,
548: p_evt_information20 in varchar2 default hr_api.g_varchar2,
549: p_project_id in number default hr_api.g_number,
550: p_owner_id in number default hr_api.g_number,
551: p_line_id in number default hr_api.g_number,
552: p_org_id in number default hr_api.g_number,
553: p_training_center_id in number default hr_api.g_number,
554: p_location_id in number default hr_api.g_number,

Line 551: p_line_id in number default hr_api.g_number,

547: p_evt_information19 in varchar2 default hr_api.g_varchar2,
548: p_evt_information20 in varchar2 default hr_api.g_varchar2,
549: p_project_id in number default hr_api.g_number,
550: p_owner_id in number default hr_api.g_number,
551: p_line_id in number default hr_api.g_number,
552: p_org_id in number default hr_api.g_number,
553: p_training_center_id in number default hr_api.g_number,
554: p_location_id in number default hr_api.g_number,
555: p_offering_id in number default hr_api.g_number,

Line 552: p_org_id in number default hr_api.g_number,

548: p_evt_information20 in varchar2 default hr_api.g_varchar2,
549: p_project_id in number default hr_api.g_number,
550: p_owner_id in number default hr_api.g_number,
551: p_line_id in number default hr_api.g_number,
552: p_org_id in number default hr_api.g_number,
553: p_training_center_id in number default hr_api.g_number,
554: p_location_id in number default hr_api.g_number,
555: p_offering_id in number default hr_api.g_number,
556: p_timezone in varchar2 default hr_api.g_varchar2,

Line 553: p_training_center_id in number default hr_api.g_number,

549: p_project_id in number default hr_api.g_number,
550: p_owner_id in number default hr_api.g_number,
551: p_line_id in number default hr_api.g_number,
552: p_org_id in number default hr_api.g_number,
553: p_training_center_id in number default hr_api.g_number,
554: p_location_id in number default hr_api.g_number,
555: p_offering_id in number default hr_api.g_number,
556: p_timezone in varchar2 default hr_api.g_varchar2,
557: -- Bug#2200078 Corrected default value for offering_id and timezone

Line 554: p_location_id in number default hr_api.g_number,

550: p_owner_id in number default hr_api.g_number,
551: p_line_id in number default hr_api.g_number,
552: p_org_id in number default hr_api.g_number,
553: p_training_center_id in number default hr_api.g_number,
554: p_location_id in number default hr_api.g_number,
555: p_offering_id in number default hr_api.g_number,
556: p_timezone in varchar2 default hr_api.g_varchar2,
557: -- Bug#2200078 Corrected default value for offering_id and timezone
558: -- p_offering_id in number default null,

Line 555: p_offering_id in number default hr_api.g_number,

551: p_line_id in number default hr_api.g_number,
552: p_org_id in number default hr_api.g_number,
553: p_training_center_id in number default hr_api.g_number,
554: p_location_id in number default hr_api.g_number,
555: p_offering_id in number default hr_api.g_number,
556: p_timezone in varchar2 default hr_api.g_varchar2,
557: -- Bug#2200078 Corrected default value for offering_id and timezone
558: -- p_offering_id in number default null,
559: -- p_timezone in varchar2 default null,

Line 556: p_timezone in varchar2 default hr_api.g_varchar2,

552: p_org_id in number default hr_api.g_number,
553: p_training_center_id in number default hr_api.g_number,
554: p_location_id in number default hr_api.g_number,
555: p_offering_id in number default hr_api.g_number,
556: p_timezone in varchar2 default hr_api.g_varchar2,
557: -- Bug#2200078 Corrected default value for offering_id and timezone
558: -- p_offering_id in number default null,
559: -- p_timezone in varchar2 default null,
560: p_parent_offering_id in number default hr_api.g_number,

Line 560: p_parent_offering_id in number default hr_api.g_number,

556: p_timezone in varchar2 default hr_api.g_varchar2,
557: -- Bug#2200078 Corrected default value for offering_id and timezone
558: -- p_offering_id in number default null,
559: -- p_timezone in varchar2 default null,
560: p_parent_offering_id in number default hr_api.g_number,
561: p_data_source in varchar2 default hr_api.g_varchar2,
562: p_validate in boolean default false
563: ) is
564: --

Line 561: p_data_source in varchar2 default hr_api.g_varchar2,

557: -- Bug#2200078 Corrected default value for offering_id and timezone
558: -- p_offering_id in number default null,
559: -- p_timezone in varchar2 default null,
560: p_parent_offering_id in number default hr_api.g_number,
561: p_data_source in varchar2 default hr_api.g_varchar2,
562: p_validate in boolean default false
563: ) is
564: --
565: -- Declare cursors and local variables

Line 580: IF p_timezone <> hr_api.g_varchar2 THEN

576: savepoint UPDATE_CLASS;
577: --
578: -- Truncate the time portion from all IN date parameters
579: --
580: IF p_timezone <> hr_api.g_varchar2 THEN
581: l_timezonechanged := istimezonechanged(p_event_id, p_timezone);
582: END IF;
583: --
584: l_effective_date := trunc(p_effective_date);

Line 661: when hr_api.cannot_find_prog_unit then

657: p_parent_offering_id => p_parent_offering_id,
658: p_data_source => p_data_source);
659:
660: exception
661: when hr_api.cannot_find_prog_unit then
662: hr_api.cannot_find_prog_unit_error
663: (p_module_name => 'UPDATE_CLASS'
664: ,p_hook_type => 'BP'
665: );

Line 662: hr_api.cannot_find_prog_unit_error

658: p_data_source => p_data_source);
659:
660: exception
661: when hr_api.cannot_find_prog_unit then
662: hr_api.cannot_find_prog_unit_error
663: (p_module_name => 'UPDATE_CLASS'
664: ,p_hook_type => 'BP'
665: );
666: end;

Line 829: when hr_api.cannot_find_prog_unit then

825: p_parent_offering_id => p_parent_offering_id,
826: p_data_source => p_data_source);
827:
828: exception
829: when hr_api.cannot_find_prog_unit then
830: hr_api.cannot_find_prog_unit_error
831: (p_module_name => 'UPDATE_CLASS'
832: ,p_hook_type => 'AP'
833: );

Line 830: hr_api.cannot_find_prog_unit_error

826: p_data_source => p_data_source);
827:
828: exception
829: when hr_api.cannot_find_prog_unit then
830: hr_api.cannot_find_prog_unit_error
831: (p_module_name => 'UPDATE_CLASS'
832: ,p_hook_type => 'AP'
833: );
834: end;

Line 849: raise hr_api.validate_enabled;

845: --
846: -- When in validation only mode raise the Validate_Enabled exception
847: --
848: if p_validate then
849: raise hr_api.validate_enabled;
850: end if;
851: --
852: -- Set all output arguments
853: --

Line 856: when hr_api.validate_enabled then

852: -- Set all output arguments
853: --
854: hr_utility.set_location(' Leaving:'||l_proc, 70);
855: exception
856: when hr_api.validate_enabled then
857: --
858: -- As the Validate_Enabled exception has been raised
859: -- we must rollback to the savepoint
860: --

Line 914: when hr_api.cannot_find_prog_unit then

910: (p_event_id => p_event_id,
911: p_object_version_number => p_object_version_number
912: );
913: exception
914: when hr_api.cannot_find_prog_unit then
915: hr_api.cannot_find_prog_unit_error
916: (p_module_name => 'DELETE_CLASS'
917: ,p_hook_type => 'BP'
918: );

Line 915: hr_api.cannot_find_prog_unit_error

911: p_object_version_number => p_object_version_number
912: );
913: exception
914: when hr_api.cannot_find_prog_unit then
915: hr_api.cannot_find_prog_unit_error
916: (p_module_name => 'DELETE_CLASS'
917: ,p_hook_type => 'BP'
918: );
919: end;

Line 947: when hr_api.cannot_find_prog_unit then

943: (p_event_id => p_event_id,
944: p_object_version_number => p_object_version_number
945: );
946: exception
947: when hr_api.cannot_find_prog_unit then
948: hr_api.cannot_find_prog_unit_error
949: (p_module_name => 'DELETE_CLASS'
950: ,p_hook_type => 'AP'
951: );

Line 948: hr_api.cannot_find_prog_unit_error

944: p_object_version_number => p_object_version_number
945: );
946: exception
947: when hr_api.cannot_find_prog_unit then
948: hr_api.cannot_find_prog_unit_error
949: (p_module_name => 'DELETE_CLASS'
950: ,p_hook_type => 'AP'
951: );
952: end;

Line 958: raise hr_api.validate_enabled;

954: --
955: -- When in validation only mode raise the Validate_Enabled exception
956: --
957: if p_validate then
958: raise hr_api.validate_enabled;
959: end if;
960: --
961: -- Set all output arguments
962: --

Line 966: when hr_api.validate_enabled then

962: --
963: --
964: hr_utility.set_location(' Leaving:'||l_proc, 170);
965: exception
966: when hr_api.validate_enabled then
967: --
968: -- As the Validate_Enabled exception has been raised
969: -- we must rollback to the savepoint
970: --