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: );
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;
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: );
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;
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: --
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: --
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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: --
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
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);
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: );
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;
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: );
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;
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: --
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: --
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: );
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;
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: );
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;
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: --
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: --