DBA Data[Home] [Help]

APPS.OTA_EVENT_API dependencies on HR_API

Line 270: when hr_api.cannot_find_prog_unit then

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

Line 271: hr_api.cannot_find_prog_unit_error

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;

Line 448: when hr_api.cannot_find_prog_unit then

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

Line 449: hr_api.cannot_find_prog_unit_error

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;

Line 459: raise hr_api.validate_enabled;

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: --

Line 469: when hr_api.validate_enabled then

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: --

Line 500: p_vendor_id in number default hr_api.g_number,

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,

Line 501: p_activity_version_id in number default hr_api.g_number,

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,

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

Line 503: p_organization_id in number default hr_api.g_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,
507: p_budget_cost in number default hr_api.g_number,

Line 504: p_event_type in varchar2 default hr_api.g_varchar2,

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,

Line 506: p_title in varchar2 default hr_api.g_varchar2,

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,

Line 507: p_budget_cost 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,
511: p_comments in varchar2 default hr_api.g_varchar2,

Line 508: p_actual_cost 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,
512: p_course_end_date in date default hr_api.g_date,

Line 509: p_budget_currency_code 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,
513: p_course_end_time in varchar2 default hr_api.g_varchar2,

Line 510: p_centre 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,

Line 511: p_comments 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,
515: p_course_start_time in varchar2 default hr_api.g_varchar2,

Line 512: p_course_end_date in date default hr_api.g_date,

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,

Line 513: p_course_end_time in varchar2 default hr_api.g_varchar2,

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,

Line 514: p_course_start_date in date default hr_api.g_date,

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,

Line 515: p_course_start_time 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,
519: p_enrolment_start_date in date default hr_api.g_date,

Line 516: p_duration in number default hr_api.g_number,

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,

Line 517: p_duration_units in varchar2 default hr_api.g_varchar2,

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,

Line 518: p_enrolment_end_date in date default hr_api.g_date,

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,

Line 519: p_enrolment_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,
523: p_event_status in varchar2 default hr_api.g_varchar2,

Line 520: p_language_id in number default hr_api.g_number,

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,

Line 521: p_user_status 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,

Line 522: p_development_event_type 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,

Line 523: p_event_status in varchar2 default hr_api.g_varchar2,

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,

Line 524: p_price_basis in varchar2 default hr_api.g_varchar2,

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,

Line 525: p_currency_code in varchar2 default hr_api.g_varchar2,

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,

Line 526: p_maximum_attendees 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,

Line 527: p_maximum_internal_attendees in number default hr_api.g_number,

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,

Line 528: p_minimum_attendees 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,

Line 529: p_standard_price in number default hr_api.g_number,

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,

Line 530: p_category_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,
534: p_secure_event_flag in varchar2 default hr_api.g_varchar2,

Line 531: p_parent_event_id 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,
535: p_evt_information_category in varchar2 default hr_api.g_varchar2,

Line 532: p_book_independent_flag 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,

Line 533: p_public_event_flag 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,

Line 534: p_secure_event_flag 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,

Line 535: p_evt_information_category 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,

Line 536: p_evt_information1 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,

Line 537: p_evt_information2 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,

Line 538: p_evt_information3 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,

Line 539: p_evt_information4 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,

Line 540: p_evt_information5 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,

Line 541: p_evt_information6 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,

Line 542: p_evt_information7 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,

Line 543: p_evt_information8 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,

Line 544: p_evt_information9 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,

Line 545: p_evt_information10 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,

Line 546: p_evt_information11 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,

Line 547: p_evt_information12 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,

Line 548: p_evt_information13 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,

Line 549: p_evt_information14 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,

Line 550: p_evt_information15 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,

Line 551: p_evt_information16 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,

Line 552: p_evt_information17 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,

Line 553: p_evt_information18 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,
557: p_owner_id in number default hr_api.g_number,

Line 554: p_evt_information19 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,
558: p_line_id in number default hr_api.g_number,

Line 555: p_evt_information20 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,
559: p_org_id in number default hr_api.g_number,

Line 556: p_project_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,

Line 557: p_owner_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,

Line 558: p_line_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,

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

Line 560: p_training_center_id in number default hr_api.g_number,

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

Line 561: p_location_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
565: -- p_offering_id in number default null,

Line 562: p_offering_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,
566: -- p_timezone in varchar2 default null,

Line 563: p_timezone in varchar2 default hr_api.g_varchar2,

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,

Line 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

Line 568: p_data_source 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
572: --

Line 570: p_event_availability in varchar2 default hr_api.g_varchar2

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: --

Line 588: IF p_timezone <> hr_api.g_varchar2 THEN

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

Line 670: when hr_api.cannot_find_prog_unit then

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

Line 671: hr_api.cannot_find_prog_unit_error

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;

Line 840: when hr_api.cannot_find_prog_unit then

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

Line 841: hr_api.cannot_find_prog_unit_error

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;

Line 860: raise hr_api.validate_enabled;

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: --

Line 867: when hr_api.validate_enabled then

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: --

Line 925: when hr_api.cannot_find_prog_unit then

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

Line 926: hr_api.cannot_find_prog_unit_error

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;

Line 958: when hr_api.cannot_find_prog_unit then

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

Line 959: hr_api.cannot_find_prog_unit_error

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;

Line 969: raise hr_api.validate_enabled;

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: --

Line 977: when hr_api.validate_enabled then

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: --