266: p_data_source => p_data_source,
267: p_event_availability => p_event_availability);
268:
269: exception
270: when hr_api.cannot_find_prog_unit then
271: hr_api.cannot_find_prog_unit_error
272: (p_module_name => 'CREATE_CLASS'
273: ,p_hook_type => 'BP'
274: );
267: p_event_availability => p_event_availability);
268:
269: exception
270: when hr_api.cannot_find_prog_unit then
271: hr_api.cannot_find_prog_unit_error
272: (p_module_name => 'CREATE_CLASS'
273: ,p_hook_type => 'BP'
274: );
275: end;
444: p_parent_offering_id => p_parent_offering_id,
445: p_data_source => p_data_source,
446: p_event_availability => p_event_availability);
447: exception
448: when hr_api.cannot_find_prog_unit then
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'CREATE_CLASS'
451: ,p_hook_type => 'AP'
452: );
445: p_data_source => p_data_source,
446: p_event_availability => p_event_availability);
447: exception
448: when hr_api.cannot_find_prog_unit then
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'CREATE_CLASS'
451: ,p_hook_type => 'AP'
452: );
453: end;
455: --
456: -- When in validation only mode raise the Validate_Enabled exception
457: --
458: if p_validate then
459: raise hr_api.validate_enabled;
460: end if;
461: --
462: -- Set all output arguments
463: --
465: p_object_version_number := l_object_version_number;
466: --
467: hr_utility.set_location(' Leaving:'||l_proc, 70);
468: exception
469: when hr_api.validate_enabled then
470: --
471: -- As the Validate_Enabled exception has been raised
472: -- we must rollback to the savepoint
473: --
496: --
497: procedure update_class
498: (p_event_id in number,
499: p_effective_date in date,
500: p_vendor_id in number default hr_api.g_number,
501: p_activity_version_id in number default hr_api.g_number,
502: p_business_group_id in number default hr_api.g_number,
503: p_organization_id in number default hr_api.g_number,
504: p_event_type in varchar2 default hr_api.g_varchar2,
497: procedure update_class
498: (p_event_id in number,
499: p_effective_date in date,
500: p_vendor_id in number default hr_api.g_number,
501: p_activity_version_id in number default hr_api.g_number,
502: p_business_group_id in number default hr_api.g_number,
503: p_organization_id in number default hr_api.g_number,
504: p_event_type in varchar2 default hr_api.g_varchar2,
505: p_object_version_number in out nocopy number,
498: (p_event_id in number,
499: p_effective_date in date,
500: p_vendor_id in number default hr_api.g_number,
501: p_activity_version_id in number default hr_api.g_number,
502: p_business_group_id in number default hr_api.g_number,
503: p_organization_id in number default hr_api.g_number,
504: p_event_type in varchar2 default hr_api.g_varchar2,
505: p_object_version_number in out nocopy number,
506: p_title in varchar2 default hr_api.g_varchar2,
499: p_effective_date in date,
500: p_vendor_id in number default hr_api.g_number,
501: p_activity_version_id in number default hr_api.g_number,
502: p_business_group_id in number default hr_api.g_number,
503: p_organization_id in number default hr_api.g_number,
504: p_event_type in varchar2 default hr_api.g_varchar2,
505: p_object_version_number in out nocopy number,
506: p_title in varchar2 default hr_api.g_varchar2,
507: p_budget_cost in number default hr_api.g_number,
500: p_vendor_id in number default hr_api.g_number,
501: p_activity_version_id in number default hr_api.g_number,
502: p_business_group_id in number default hr_api.g_number,
503: p_organization_id in number default hr_api.g_number,
504: p_event_type in varchar2 default hr_api.g_varchar2,
505: p_object_version_number in out nocopy number,
506: p_title in varchar2 default hr_api.g_varchar2,
507: p_budget_cost in number default hr_api.g_number,
508: p_actual_cost in number default hr_api.g_number,
502: p_business_group_id in number default hr_api.g_number,
503: p_organization_id in number default hr_api.g_number,
504: p_event_type in varchar2 default hr_api.g_varchar2,
505: p_object_version_number in out nocopy number,
506: p_title in varchar2 default hr_api.g_varchar2,
507: p_budget_cost in number default hr_api.g_number,
508: p_actual_cost in number default hr_api.g_number,
509: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
510: p_centre in varchar2 default hr_api.g_varchar2,
503: p_organization_id in number default hr_api.g_number,
504: p_event_type in varchar2 default hr_api.g_varchar2,
505: p_object_version_number in out nocopy number,
506: p_title in varchar2 default hr_api.g_varchar2,
507: p_budget_cost in number default hr_api.g_number,
508: p_actual_cost in number default hr_api.g_number,
509: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
510: p_centre in varchar2 default hr_api.g_varchar2,
511: p_comments in varchar2 default hr_api.g_varchar2,
504: p_event_type in varchar2 default hr_api.g_varchar2,
505: p_object_version_number in out nocopy number,
506: p_title in varchar2 default hr_api.g_varchar2,
507: p_budget_cost in number default hr_api.g_number,
508: p_actual_cost in number default hr_api.g_number,
509: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
510: p_centre in varchar2 default hr_api.g_varchar2,
511: p_comments in varchar2 default hr_api.g_varchar2,
512: p_course_end_date in date default hr_api.g_date,
505: p_object_version_number in out nocopy number,
506: p_title in varchar2 default hr_api.g_varchar2,
507: p_budget_cost in number default hr_api.g_number,
508: p_actual_cost in number default hr_api.g_number,
509: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
510: p_centre in varchar2 default hr_api.g_varchar2,
511: p_comments in varchar2 default hr_api.g_varchar2,
512: p_course_end_date in date default hr_api.g_date,
513: p_course_end_time in varchar2 default hr_api.g_varchar2,
506: p_title in varchar2 default hr_api.g_varchar2,
507: p_budget_cost in number default hr_api.g_number,
508: p_actual_cost in number default hr_api.g_number,
509: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
510: p_centre in varchar2 default hr_api.g_varchar2,
511: p_comments in varchar2 default hr_api.g_varchar2,
512: p_course_end_date in date default hr_api.g_date,
513: p_course_end_time in varchar2 default hr_api.g_varchar2,
514: p_course_start_date in date default hr_api.g_date,
507: p_budget_cost in number default hr_api.g_number,
508: p_actual_cost in number default hr_api.g_number,
509: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
510: p_centre in varchar2 default hr_api.g_varchar2,
511: p_comments in varchar2 default hr_api.g_varchar2,
512: p_course_end_date in date default hr_api.g_date,
513: p_course_end_time in varchar2 default hr_api.g_varchar2,
514: p_course_start_date in date default hr_api.g_date,
515: p_course_start_time in varchar2 default hr_api.g_varchar2,
508: p_actual_cost in number default hr_api.g_number,
509: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
510: p_centre in varchar2 default hr_api.g_varchar2,
511: p_comments in varchar2 default hr_api.g_varchar2,
512: p_course_end_date in date default hr_api.g_date,
513: p_course_end_time in varchar2 default hr_api.g_varchar2,
514: p_course_start_date in date default hr_api.g_date,
515: p_course_start_time in varchar2 default hr_api.g_varchar2,
516: p_duration in number default hr_api.g_number,
509: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
510: p_centre in varchar2 default hr_api.g_varchar2,
511: p_comments in varchar2 default hr_api.g_varchar2,
512: p_course_end_date in date default hr_api.g_date,
513: p_course_end_time in varchar2 default hr_api.g_varchar2,
514: p_course_start_date in date default hr_api.g_date,
515: p_course_start_time in varchar2 default hr_api.g_varchar2,
516: p_duration in number default hr_api.g_number,
517: p_duration_units in varchar2 default hr_api.g_varchar2,
510: p_centre in varchar2 default hr_api.g_varchar2,
511: p_comments in varchar2 default hr_api.g_varchar2,
512: p_course_end_date in date default hr_api.g_date,
513: p_course_end_time in varchar2 default hr_api.g_varchar2,
514: p_course_start_date in date default hr_api.g_date,
515: p_course_start_time in varchar2 default hr_api.g_varchar2,
516: p_duration in number default hr_api.g_number,
517: p_duration_units in varchar2 default hr_api.g_varchar2,
518: p_enrolment_end_date in date default hr_api.g_date,
511: p_comments in varchar2 default hr_api.g_varchar2,
512: p_course_end_date in date default hr_api.g_date,
513: p_course_end_time in varchar2 default hr_api.g_varchar2,
514: p_course_start_date in date default hr_api.g_date,
515: p_course_start_time in varchar2 default hr_api.g_varchar2,
516: p_duration in number default hr_api.g_number,
517: p_duration_units in varchar2 default hr_api.g_varchar2,
518: p_enrolment_end_date in date default hr_api.g_date,
519: p_enrolment_start_date in date default hr_api.g_date,
512: p_course_end_date in date default hr_api.g_date,
513: p_course_end_time in varchar2 default hr_api.g_varchar2,
514: p_course_start_date in date default hr_api.g_date,
515: p_course_start_time in varchar2 default hr_api.g_varchar2,
516: p_duration in number default hr_api.g_number,
517: p_duration_units in varchar2 default hr_api.g_varchar2,
518: p_enrolment_end_date in date default hr_api.g_date,
519: p_enrolment_start_date in date default hr_api.g_date,
520: p_language_id in number default hr_api.g_number,
513: p_course_end_time in varchar2 default hr_api.g_varchar2,
514: p_course_start_date in date default hr_api.g_date,
515: p_course_start_time in varchar2 default hr_api.g_varchar2,
516: p_duration in number default hr_api.g_number,
517: p_duration_units in varchar2 default hr_api.g_varchar2,
518: p_enrolment_end_date in date default hr_api.g_date,
519: p_enrolment_start_date in date default hr_api.g_date,
520: p_language_id in number default hr_api.g_number,
521: p_user_status in varchar2 default hr_api.g_varchar2,
514: p_course_start_date in date default hr_api.g_date,
515: p_course_start_time in varchar2 default hr_api.g_varchar2,
516: p_duration in number default hr_api.g_number,
517: p_duration_units in varchar2 default hr_api.g_varchar2,
518: p_enrolment_end_date in date default hr_api.g_date,
519: p_enrolment_start_date in date default hr_api.g_date,
520: p_language_id in number default hr_api.g_number,
521: p_user_status in varchar2 default hr_api.g_varchar2,
522: p_development_event_type in varchar2 default hr_api.g_varchar2,
515: p_course_start_time in varchar2 default hr_api.g_varchar2,
516: p_duration in number default hr_api.g_number,
517: p_duration_units in varchar2 default hr_api.g_varchar2,
518: p_enrolment_end_date in date default hr_api.g_date,
519: p_enrolment_start_date in date default hr_api.g_date,
520: p_language_id in number default hr_api.g_number,
521: p_user_status in varchar2 default hr_api.g_varchar2,
522: p_development_event_type in varchar2 default hr_api.g_varchar2,
523: p_event_status in varchar2 default hr_api.g_varchar2,
516: p_duration in number default hr_api.g_number,
517: p_duration_units in varchar2 default hr_api.g_varchar2,
518: p_enrolment_end_date in date default hr_api.g_date,
519: p_enrolment_start_date in date default hr_api.g_date,
520: p_language_id in number default hr_api.g_number,
521: p_user_status in varchar2 default hr_api.g_varchar2,
522: p_development_event_type in varchar2 default hr_api.g_varchar2,
523: p_event_status in varchar2 default hr_api.g_varchar2,
524: p_price_basis in varchar2 default hr_api.g_varchar2,
517: p_duration_units in varchar2 default hr_api.g_varchar2,
518: p_enrolment_end_date in date default hr_api.g_date,
519: p_enrolment_start_date in date default hr_api.g_date,
520: p_language_id in number default hr_api.g_number,
521: p_user_status in varchar2 default hr_api.g_varchar2,
522: p_development_event_type in varchar2 default hr_api.g_varchar2,
523: p_event_status in varchar2 default hr_api.g_varchar2,
524: p_price_basis in varchar2 default hr_api.g_varchar2,
525: p_currency_code in varchar2 default hr_api.g_varchar2,
518: p_enrolment_end_date in date default hr_api.g_date,
519: p_enrolment_start_date in date default hr_api.g_date,
520: p_language_id in number default hr_api.g_number,
521: p_user_status in varchar2 default hr_api.g_varchar2,
522: p_development_event_type in varchar2 default hr_api.g_varchar2,
523: p_event_status in varchar2 default hr_api.g_varchar2,
524: p_price_basis in varchar2 default hr_api.g_varchar2,
525: p_currency_code in varchar2 default hr_api.g_varchar2,
526: p_maximum_attendees in number default hr_api.g_number,
519: p_enrolment_start_date in date default hr_api.g_date,
520: p_language_id in number default hr_api.g_number,
521: p_user_status in varchar2 default hr_api.g_varchar2,
522: p_development_event_type in varchar2 default hr_api.g_varchar2,
523: p_event_status in varchar2 default hr_api.g_varchar2,
524: p_price_basis in varchar2 default hr_api.g_varchar2,
525: p_currency_code in varchar2 default hr_api.g_varchar2,
526: p_maximum_attendees in number default hr_api.g_number,
527: p_maximum_internal_attendees in number default hr_api.g_number,
520: p_language_id in number default hr_api.g_number,
521: p_user_status in varchar2 default hr_api.g_varchar2,
522: p_development_event_type in varchar2 default hr_api.g_varchar2,
523: p_event_status in varchar2 default hr_api.g_varchar2,
524: p_price_basis in varchar2 default hr_api.g_varchar2,
525: p_currency_code in varchar2 default hr_api.g_varchar2,
526: p_maximum_attendees in number default hr_api.g_number,
527: p_maximum_internal_attendees in number default hr_api.g_number,
528: p_minimum_attendees in number default hr_api.g_number,
521: p_user_status in varchar2 default hr_api.g_varchar2,
522: p_development_event_type in varchar2 default hr_api.g_varchar2,
523: p_event_status in varchar2 default hr_api.g_varchar2,
524: p_price_basis in varchar2 default hr_api.g_varchar2,
525: p_currency_code in varchar2 default hr_api.g_varchar2,
526: p_maximum_attendees in number default hr_api.g_number,
527: p_maximum_internal_attendees in number default hr_api.g_number,
528: p_minimum_attendees in number default hr_api.g_number,
529: p_standard_price in number default hr_api.g_number,
522: p_development_event_type in varchar2 default hr_api.g_varchar2,
523: p_event_status in varchar2 default hr_api.g_varchar2,
524: p_price_basis in varchar2 default hr_api.g_varchar2,
525: p_currency_code in varchar2 default hr_api.g_varchar2,
526: p_maximum_attendees in number default hr_api.g_number,
527: p_maximum_internal_attendees in number default hr_api.g_number,
528: p_minimum_attendees in number default hr_api.g_number,
529: p_standard_price in number default hr_api.g_number,
530: p_category_code in varchar2 default hr_api.g_varchar2,
523: p_event_status in varchar2 default hr_api.g_varchar2,
524: p_price_basis in varchar2 default hr_api.g_varchar2,
525: p_currency_code in varchar2 default hr_api.g_varchar2,
526: p_maximum_attendees in number default hr_api.g_number,
527: p_maximum_internal_attendees in number default hr_api.g_number,
528: p_minimum_attendees in number default hr_api.g_number,
529: p_standard_price in number default hr_api.g_number,
530: p_category_code in varchar2 default hr_api.g_varchar2,
531: p_parent_event_id in number default hr_api.g_number,
524: p_price_basis in varchar2 default hr_api.g_varchar2,
525: p_currency_code in varchar2 default hr_api.g_varchar2,
526: p_maximum_attendees in number default hr_api.g_number,
527: p_maximum_internal_attendees in number default hr_api.g_number,
528: p_minimum_attendees in number default hr_api.g_number,
529: p_standard_price in number default hr_api.g_number,
530: p_category_code in varchar2 default hr_api.g_varchar2,
531: p_parent_event_id in number default hr_api.g_number,
532: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
525: p_currency_code in varchar2 default hr_api.g_varchar2,
526: p_maximum_attendees in number default hr_api.g_number,
527: p_maximum_internal_attendees in number default hr_api.g_number,
528: p_minimum_attendees in number default hr_api.g_number,
529: p_standard_price in number default hr_api.g_number,
530: p_category_code in varchar2 default hr_api.g_varchar2,
531: p_parent_event_id in number default hr_api.g_number,
532: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
533: p_public_event_flag in varchar2 default hr_api.g_varchar2,
526: p_maximum_attendees in number default hr_api.g_number,
527: p_maximum_internal_attendees in number default hr_api.g_number,
528: p_minimum_attendees in number default hr_api.g_number,
529: p_standard_price in number default hr_api.g_number,
530: p_category_code in varchar2 default hr_api.g_varchar2,
531: p_parent_event_id in number default hr_api.g_number,
532: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
533: p_public_event_flag in varchar2 default hr_api.g_varchar2,
534: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
527: p_maximum_internal_attendees in number default hr_api.g_number,
528: p_minimum_attendees in number default hr_api.g_number,
529: p_standard_price in number default hr_api.g_number,
530: p_category_code in varchar2 default hr_api.g_varchar2,
531: p_parent_event_id in number default hr_api.g_number,
532: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
533: p_public_event_flag in varchar2 default hr_api.g_varchar2,
534: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
535: p_evt_information_category in varchar2 default hr_api.g_varchar2,
528: p_minimum_attendees in number default hr_api.g_number,
529: p_standard_price in number default hr_api.g_number,
530: p_category_code in varchar2 default hr_api.g_varchar2,
531: p_parent_event_id in number default hr_api.g_number,
532: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
533: p_public_event_flag in varchar2 default hr_api.g_varchar2,
534: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
535: p_evt_information_category in varchar2 default hr_api.g_varchar2,
536: p_evt_information1 in varchar2 default hr_api.g_varchar2,
529: p_standard_price in number default hr_api.g_number,
530: p_category_code in varchar2 default hr_api.g_varchar2,
531: p_parent_event_id in number default hr_api.g_number,
532: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
533: p_public_event_flag in varchar2 default hr_api.g_varchar2,
534: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
535: p_evt_information_category in varchar2 default hr_api.g_varchar2,
536: p_evt_information1 in varchar2 default hr_api.g_varchar2,
537: p_evt_information2 in varchar2 default hr_api.g_varchar2,
530: p_category_code in varchar2 default hr_api.g_varchar2,
531: p_parent_event_id in number default hr_api.g_number,
532: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
533: p_public_event_flag in varchar2 default hr_api.g_varchar2,
534: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
535: p_evt_information_category in varchar2 default hr_api.g_varchar2,
536: p_evt_information1 in varchar2 default hr_api.g_varchar2,
537: p_evt_information2 in varchar2 default hr_api.g_varchar2,
538: p_evt_information3 in varchar2 default hr_api.g_varchar2,
531: p_parent_event_id in number default hr_api.g_number,
532: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
533: p_public_event_flag in varchar2 default hr_api.g_varchar2,
534: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
535: p_evt_information_category in varchar2 default hr_api.g_varchar2,
536: p_evt_information1 in varchar2 default hr_api.g_varchar2,
537: p_evt_information2 in varchar2 default hr_api.g_varchar2,
538: p_evt_information3 in varchar2 default hr_api.g_varchar2,
539: p_evt_information4 in varchar2 default hr_api.g_varchar2,
532: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
533: p_public_event_flag in varchar2 default hr_api.g_varchar2,
534: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
535: p_evt_information_category in varchar2 default hr_api.g_varchar2,
536: p_evt_information1 in varchar2 default hr_api.g_varchar2,
537: p_evt_information2 in varchar2 default hr_api.g_varchar2,
538: p_evt_information3 in varchar2 default hr_api.g_varchar2,
539: p_evt_information4 in varchar2 default hr_api.g_varchar2,
540: p_evt_information5 in varchar2 default hr_api.g_varchar2,
533: p_public_event_flag in varchar2 default hr_api.g_varchar2,
534: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
535: p_evt_information_category in varchar2 default hr_api.g_varchar2,
536: p_evt_information1 in varchar2 default hr_api.g_varchar2,
537: p_evt_information2 in varchar2 default hr_api.g_varchar2,
538: p_evt_information3 in varchar2 default hr_api.g_varchar2,
539: p_evt_information4 in varchar2 default hr_api.g_varchar2,
540: p_evt_information5 in varchar2 default hr_api.g_varchar2,
541: p_evt_information6 in varchar2 default hr_api.g_varchar2,
534: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
535: p_evt_information_category in varchar2 default hr_api.g_varchar2,
536: p_evt_information1 in varchar2 default hr_api.g_varchar2,
537: p_evt_information2 in varchar2 default hr_api.g_varchar2,
538: p_evt_information3 in varchar2 default hr_api.g_varchar2,
539: p_evt_information4 in varchar2 default hr_api.g_varchar2,
540: p_evt_information5 in varchar2 default hr_api.g_varchar2,
541: p_evt_information6 in varchar2 default hr_api.g_varchar2,
542: p_evt_information7 in varchar2 default hr_api.g_varchar2,
535: p_evt_information_category in varchar2 default hr_api.g_varchar2,
536: p_evt_information1 in varchar2 default hr_api.g_varchar2,
537: p_evt_information2 in varchar2 default hr_api.g_varchar2,
538: p_evt_information3 in varchar2 default hr_api.g_varchar2,
539: p_evt_information4 in varchar2 default hr_api.g_varchar2,
540: p_evt_information5 in varchar2 default hr_api.g_varchar2,
541: p_evt_information6 in varchar2 default hr_api.g_varchar2,
542: p_evt_information7 in varchar2 default hr_api.g_varchar2,
543: p_evt_information8 in varchar2 default hr_api.g_varchar2,
536: p_evt_information1 in varchar2 default hr_api.g_varchar2,
537: p_evt_information2 in varchar2 default hr_api.g_varchar2,
538: p_evt_information3 in varchar2 default hr_api.g_varchar2,
539: p_evt_information4 in varchar2 default hr_api.g_varchar2,
540: p_evt_information5 in varchar2 default hr_api.g_varchar2,
541: p_evt_information6 in varchar2 default hr_api.g_varchar2,
542: p_evt_information7 in varchar2 default hr_api.g_varchar2,
543: p_evt_information8 in varchar2 default hr_api.g_varchar2,
544: p_evt_information9 in varchar2 default hr_api.g_varchar2,
537: p_evt_information2 in varchar2 default hr_api.g_varchar2,
538: p_evt_information3 in varchar2 default hr_api.g_varchar2,
539: p_evt_information4 in varchar2 default hr_api.g_varchar2,
540: p_evt_information5 in varchar2 default hr_api.g_varchar2,
541: p_evt_information6 in varchar2 default hr_api.g_varchar2,
542: p_evt_information7 in varchar2 default hr_api.g_varchar2,
543: p_evt_information8 in varchar2 default hr_api.g_varchar2,
544: p_evt_information9 in varchar2 default hr_api.g_varchar2,
545: p_evt_information10 in varchar2 default hr_api.g_varchar2,
538: p_evt_information3 in varchar2 default hr_api.g_varchar2,
539: p_evt_information4 in varchar2 default hr_api.g_varchar2,
540: p_evt_information5 in varchar2 default hr_api.g_varchar2,
541: p_evt_information6 in varchar2 default hr_api.g_varchar2,
542: p_evt_information7 in varchar2 default hr_api.g_varchar2,
543: p_evt_information8 in varchar2 default hr_api.g_varchar2,
544: p_evt_information9 in varchar2 default hr_api.g_varchar2,
545: p_evt_information10 in varchar2 default hr_api.g_varchar2,
546: p_evt_information11 in varchar2 default hr_api.g_varchar2,
539: p_evt_information4 in varchar2 default hr_api.g_varchar2,
540: p_evt_information5 in varchar2 default hr_api.g_varchar2,
541: p_evt_information6 in varchar2 default hr_api.g_varchar2,
542: p_evt_information7 in varchar2 default hr_api.g_varchar2,
543: p_evt_information8 in varchar2 default hr_api.g_varchar2,
544: p_evt_information9 in varchar2 default hr_api.g_varchar2,
545: p_evt_information10 in varchar2 default hr_api.g_varchar2,
546: p_evt_information11 in varchar2 default hr_api.g_varchar2,
547: p_evt_information12 in varchar2 default hr_api.g_varchar2,
540: p_evt_information5 in varchar2 default hr_api.g_varchar2,
541: p_evt_information6 in varchar2 default hr_api.g_varchar2,
542: p_evt_information7 in varchar2 default hr_api.g_varchar2,
543: p_evt_information8 in varchar2 default hr_api.g_varchar2,
544: p_evt_information9 in varchar2 default hr_api.g_varchar2,
545: p_evt_information10 in varchar2 default hr_api.g_varchar2,
546: p_evt_information11 in varchar2 default hr_api.g_varchar2,
547: p_evt_information12 in varchar2 default hr_api.g_varchar2,
548: p_evt_information13 in varchar2 default hr_api.g_varchar2,
541: p_evt_information6 in varchar2 default hr_api.g_varchar2,
542: p_evt_information7 in varchar2 default hr_api.g_varchar2,
543: p_evt_information8 in varchar2 default hr_api.g_varchar2,
544: p_evt_information9 in varchar2 default hr_api.g_varchar2,
545: p_evt_information10 in varchar2 default hr_api.g_varchar2,
546: p_evt_information11 in varchar2 default hr_api.g_varchar2,
547: p_evt_information12 in varchar2 default hr_api.g_varchar2,
548: p_evt_information13 in varchar2 default hr_api.g_varchar2,
549: p_evt_information14 in varchar2 default hr_api.g_varchar2,
542: p_evt_information7 in varchar2 default hr_api.g_varchar2,
543: p_evt_information8 in varchar2 default hr_api.g_varchar2,
544: p_evt_information9 in varchar2 default hr_api.g_varchar2,
545: p_evt_information10 in varchar2 default hr_api.g_varchar2,
546: p_evt_information11 in varchar2 default hr_api.g_varchar2,
547: p_evt_information12 in varchar2 default hr_api.g_varchar2,
548: p_evt_information13 in varchar2 default hr_api.g_varchar2,
549: p_evt_information14 in varchar2 default hr_api.g_varchar2,
550: p_evt_information15 in varchar2 default hr_api.g_varchar2,
543: p_evt_information8 in varchar2 default hr_api.g_varchar2,
544: p_evt_information9 in varchar2 default hr_api.g_varchar2,
545: p_evt_information10 in varchar2 default hr_api.g_varchar2,
546: p_evt_information11 in varchar2 default hr_api.g_varchar2,
547: p_evt_information12 in varchar2 default hr_api.g_varchar2,
548: p_evt_information13 in varchar2 default hr_api.g_varchar2,
549: p_evt_information14 in varchar2 default hr_api.g_varchar2,
550: p_evt_information15 in varchar2 default hr_api.g_varchar2,
551: p_evt_information16 in varchar2 default hr_api.g_varchar2,
544: p_evt_information9 in varchar2 default hr_api.g_varchar2,
545: p_evt_information10 in varchar2 default hr_api.g_varchar2,
546: p_evt_information11 in varchar2 default hr_api.g_varchar2,
547: p_evt_information12 in varchar2 default hr_api.g_varchar2,
548: p_evt_information13 in varchar2 default hr_api.g_varchar2,
549: p_evt_information14 in varchar2 default hr_api.g_varchar2,
550: p_evt_information15 in varchar2 default hr_api.g_varchar2,
551: p_evt_information16 in varchar2 default hr_api.g_varchar2,
552: p_evt_information17 in varchar2 default hr_api.g_varchar2,
545: p_evt_information10 in varchar2 default hr_api.g_varchar2,
546: p_evt_information11 in varchar2 default hr_api.g_varchar2,
547: p_evt_information12 in varchar2 default hr_api.g_varchar2,
548: p_evt_information13 in varchar2 default hr_api.g_varchar2,
549: p_evt_information14 in varchar2 default hr_api.g_varchar2,
550: p_evt_information15 in varchar2 default hr_api.g_varchar2,
551: p_evt_information16 in varchar2 default hr_api.g_varchar2,
552: p_evt_information17 in varchar2 default hr_api.g_varchar2,
553: p_evt_information18 in varchar2 default hr_api.g_varchar2,
546: p_evt_information11 in varchar2 default hr_api.g_varchar2,
547: p_evt_information12 in varchar2 default hr_api.g_varchar2,
548: p_evt_information13 in varchar2 default hr_api.g_varchar2,
549: p_evt_information14 in varchar2 default hr_api.g_varchar2,
550: p_evt_information15 in varchar2 default hr_api.g_varchar2,
551: p_evt_information16 in varchar2 default hr_api.g_varchar2,
552: p_evt_information17 in varchar2 default hr_api.g_varchar2,
553: p_evt_information18 in varchar2 default hr_api.g_varchar2,
554: p_evt_information19 in varchar2 default hr_api.g_varchar2,
547: p_evt_information12 in varchar2 default hr_api.g_varchar2,
548: p_evt_information13 in varchar2 default hr_api.g_varchar2,
549: p_evt_information14 in varchar2 default hr_api.g_varchar2,
550: p_evt_information15 in varchar2 default hr_api.g_varchar2,
551: p_evt_information16 in varchar2 default hr_api.g_varchar2,
552: p_evt_information17 in varchar2 default hr_api.g_varchar2,
553: p_evt_information18 in varchar2 default hr_api.g_varchar2,
554: p_evt_information19 in varchar2 default hr_api.g_varchar2,
555: p_evt_information20 in varchar2 default hr_api.g_varchar2,
548: p_evt_information13 in varchar2 default hr_api.g_varchar2,
549: p_evt_information14 in varchar2 default hr_api.g_varchar2,
550: p_evt_information15 in varchar2 default hr_api.g_varchar2,
551: p_evt_information16 in varchar2 default hr_api.g_varchar2,
552: p_evt_information17 in varchar2 default hr_api.g_varchar2,
553: p_evt_information18 in varchar2 default hr_api.g_varchar2,
554: p_evt_information19 in varchar2 default hr_api.g_varchar2,
555: p_evt_information20 in varchar2 default hr_api.g_varchar2,
556: p_project_id in number default hr_api.g_number,
549: p_evt_information14 in varchar2 default hr_api.g_varchar2,
550: p_evt_information15 in varchar2 default hr_api.g_varchar2,
551: p_evt_information16 in varchar2 default hr_api.g_varchar2,
552: p_evt_information17 in varchar2 default hr_api.g_varchar2,
553: p_evt_information18 in varchar2 default hr_api.g_varchar2,
554: p_evt_information19 in varchar2 default hr_api.g_varchar2,
555: p_evt_information20 in varchar2 default hr_api.g_varchar2,
556: p_project_id in number default hr_api.g_number,
557: p_owner_id in number default hr_api.g_number,
550: p_evt_information15 in varchar2 default hr_api.g_varchar2,
551: p_evt_information16 in varchar2 default hr_api.g_varchar2,
552: p_evt_information17 in varchar2 default hr_api.g_varchar2,
553: p_evt_information18 in varchar2 default hr_api.g_varchar2,
554: p_evt_information19 in varchar2 default hr_api.g_varchar2,
555: p_evt_information20 in varchar2 default hr_api.g_varchar2,
556: p_project_id in number default hr_api.g_number,
557: p_owner_id in number default hr_api.g_number,
558: p_line_id in number default hr_api.g_number,
551: p_evt_information16 in varchar2 default hr_api.g_varchar2,
552: p_evt_information17 in varchar2 default hr_api.g_varchar2,
553: p_evt_information18 in varchar2 default hr_api.g_varchar2,
554: p_evt_information19 in varchar2 default hr_api.g_varchar2,
555: p_evt_information20 in varchar2 default hr_api.g_varchar2,
556: p_project_id in number default hr_api.g_number,
557: p_owner_id in number default hr_api.g_number,
558: p_line_id in number default hr_api.g_number,
559: p_org_id in number default hr_api.g_number,
552: p_evt_information17 in varchar2 default hr_api.g_varchar2,
553: p_evt_information18 in varchar2 default hr_api.g_varchar2,
554: p_evt_information19 in varchar2 default hr_api.g_varchar2,
555: p_evt_information20 in varchar2 default hr_api.g_varchar2,
556: p_project_id in number default hr_api.g_number,
557: p_owner_id in number default hr_api.g_number,
558: p_line_id in number default hr_api.g_number,
559: p_org_id in number default hr_api.g_number,
560: p_training_center_id in number default hr_api.g_number,
553: p_evt_information18 in varchar2 default hr_api.g_varchar2,
554: p_evt_information19 in varchar2 default hr_api.g_varchar2,
555: p_evt_information20 in varchar2 default hr_api.g_varchar2,
556: p_project_id in number default hr_api.g_number,
557: p_owner_id in number default hr_api.g_number,
558: p_line_id in number default hr_api.g_number,
559: p_org_id in number default hr_api.g_number,
560: p_training_center_id in number default hr_api.g_number,
561: p_location_id in number default hr_api.g_number,
554: p_evt_information19 in varchar2 default hr_api.g_varchar2,
555: p_evt_information20 in varchar2 default hr_api.g_varchar2,
556: p_project_id in number default hr_api.g_number,
557: p_owner_id in number default hr_api.g_number,
558: p_line_id in number default hr_api.g_number,
559: p_org_id in number default hr_api.g_number,
560: p_training_center_id in number default hr_api.g_number,
561: p_location_id in number default hr_api.g_number,
562: p_offering_id in number default hr_api.g_number,
555: p_evt_information20 in varchar2 default hr_api.g_varchar2,
556: p_project_id in number default hr_api.g_number,
557: p_owner_id in number default hr_api.g_number,
558: p_line_id in number default hr_api.g_number,
559: p_org_id in number default hr_api.g_number,
560: p_training_center_id in number default hr_api.g_number,
561: p_location_id in number default hr_api.g_number,
562: p_offering_id in number default hr_api.g_number,
563: p_timezone in varchar2 default hr_api.g_varchar2,
556: p_project_id in number default hr_api.g_number,
557: p_owner_id in number default hr_api.g_number,
558: p_line_id in number default hr_api.g_number,
559: p_org_id in number default hr_api.g_number,
560: p_training_center_id in number default hr_api.g_number,
561: p_location_id in number default hr_api.g_number,
562: p_offering_id in number default hr_api.g_number,
563: p_timezone in varchar2 default hr_api.g_varchar2,
564: -- Bug#2200078 Corrected default value for offering_id and timezone
557: p_owner_id in number default hr_api.g_number,
558: p_line_id in number default hr_api.g_number,
559: p_org_id in number default hr_api.g_number,
560: p_training_center_id in number default hr_api.g_number,
561: p_location_id in number default hr_api.g_number,
562: p_offering_id in number default hr_api.g_number,
563: p_timezone in varchar2 default hr_api.g_varchar2,
564: -- Bug#2200078 Corrected default value for offering_id and timezone
565: -- p_offering_id in number default null,
558: p_line_id in number default hr_api.g_number,
559: p_org_id in number default hr_api.g_number,
560: p_training_center_id in number default hr_api.g_number,
561: p_location_id in number default hr_api.g_number,
562: p_offering_id in number default hr_api.g_number,
563: p_timezone in varchar2 default hr_api.g_varchar2,
564: -- Bug#2200078 Corrected default value for offering_id and timezone
565: -- p_offering_id in number default null,
566: -- p_timezone in varchar2 default null,
559: p_org_id in number default hr_api.g_number,
560: p_training_center_id in number default hr_api.g_number,
561: p_location_id in number default hr_api.g_number,
562: p_offering_id in number default hr_api.g_number,
563: p_timezone in varchar2 default hr_api.g_varchar2,
564: -- Bug#2200078 Corrected default value for offering_id and timezone
565: -- p_offering_id in number default null,
566: -- p_timezone in varchar2 default null,
567: p_parent_offering_id in number default hr_api.g_number,
563: p_timezone in varchar2 default hr_api.g_varchar2,
564: -- Bug#2200078 Corrected default value for offering_id and timezone
565: -- p_offering_id in number default null,
566: -- p_timezone in varchar2 default null,
567: p_parent_offering_id in number default hr_api.g_number,
568: p_data_source in varchar2 default hr_api.g_varchar2,
569: p_validate in boolean default false,
570: p_event_availability in varchar2 default hr_api.g_varchar2
571: ) is
564: -- Bug#2200078 Corrected default value for offering_id and timezone
565: -- p_offering_id in number default null,
566: -- p_timezone in varchar2 default null,
567: p_parent_offering_id in number default hr_api.g_number,
568: p_data_source in varchar2 default hr_api.g_varchar2,
569: p_validate in boolean default false,
570: p_event_availability in varchar2 default hr_api.g_varchar2
571: ) is
572: --
566: -- p_timezone in varchar2 default null,
567: p_parent_offering_id in number default hr_api.g_number,
568: p_data_source in varchar2 default hr_api.g_varchar2,
569: p_validate in boolean default false,
570: p_event_availability in varchar2 default hr_api.g_varchar2
571: ) is
572: --
573: -- Declare cursors and local variables
574: --
584: savepoint UPDATE_CLASS;
585: --
586: -- Truncate the time portion from all IN date parameters
587: --
588: IF p_timezone <> hr_api.g_varchar2 THEN
589: l_timezonechanged := istimezonechanged(p_event_id, p_timezone);
590: END IF;
591: --
592: l_effective_date := trunc(p_effective_date);
666: p_data_source => p_data_source,
667: p_event_availability => p_event_availability);
668:
669: exception
670: when hr_api.cannot_find_prog_unit then
671: hr_api.cannot_find_prog_unit_error
672: (p_module_name => 'UPDATE_CLASS'
673: ,p_hook_type => 'BP'
674: );
667: p_event_availability => p_event_availability);
668:
669: exception
670: when hr_api.cannot_find_prog_unit then
671: hr_api.cannot_find_prog_unit_error
672: (p_module_name => 'UPDATE_CLASS'
673: ,p_hook_type => 'BP'
674: );
675: end;
836: p_data_source => p_data_source,
837: p_event_availability => p_event_availability);
838:
839: exception
840: when hr_api.cannot_find_prog_unit then
841: hr_api.cannot_find_prog_unit_error
842: (p_module_name => 'UPDATE_CLASS'
843: ,p_hook_type => 'AP'
844: );
837: p_event_availability => p_event_availability);
838:
839: exception
840: when hr_api.cannot_find_prog_unit then
841: hr_api.cannot_find_prog_unit_error
842: (p_module_name => 'UPDATE_CLASS'
843: ,p_hook_type => 'AP'
844: );
845: end;
856: --
857: -- When in validation only mode raise the Validate_Enabled exception
858: --
859: if p_validate then
860: raise hr_api.validate_enabled;
861: end if;
862: --
863: -- Set all output arguments
864: --
863: -- Set all output arguments
864: --
865: hr_utility.set_location(' Leaving:'||l_proc, 70);
866: exception
867: when hr_api.validate_enabled then
868: --
869: -- As the Validate_Enabled exception has been raised
870: -- we must rollback to the savepoint
871: --
921: (p_event_id => p_event_id,
922: p_object_version_number => p_object_version_number
923: );
924: exception
925: when hr_api.cannot_find_prog_unit then
926: hr_api.cannot_find_prog_unit_error
927: (p_module_name => 'DELETE_CLASS'
928: ,p_hook_type => 'BP'
929: );
922: p_object_version_number => p_object_version_number
923: );
924: exception
925: when hr_api.cannot_find_prog_unit then
926: hr_api.cannot_find_prog_unit_error
927: (p_module_name => 'DELETE_CLASS'
928: ,p_hook_type => 'BP'
929: );
930: end;
954: (p_event_id => p_event_id,
955: p_object_version_number => p_object_version_number
956: );
957: exception
958: when hr_api.cannot_find_prog_unit then
959: hr_api.cannot_find_prog_unit_error
960: (p_module_name => 'DELETE_CLASS'
961: ,p_hook_type => 'AP'
962: );
955: p_object_version_number => p_object_version_number
956: );
957: exception
958: when hr_api.cannot_find_prog_unit then
959: hr_api.cannot_find_prog_unit_error
960: (p_module_name => 'DELETE_CLASS'
961: ,p_hook_type => 'AP'
962: );
963: end;
965: --
966: -- When in validation only mode raise the Validate_Enabled exception
967: --
968: if p_validate then
969: raise hr_api.validate_enabled;
970: end if;
971: --
972: -- Set all output arguments
973: --
973: --
974: --
975: hr_utility.set_location(' Leaving:'||l_proc, 170);
976: exception
977: when hr_api.validate_enabled then
978: --
979: -- As the Validate_Enabled exception has been raised
980: -- we must rollback to the savepoint
981: --