255: ,p_attribute30 => p_attribute30
256: );
257:
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'CREATE_PERF_MGMT_PLAN',
262: p_hook_type => 'BP'
263: );
256: );
257:
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'CREATE_PERF_MGMT_PLAN',
262: p_hook_type => 'BP'
263: );
264: end;
416: ,p_no_life_events_warning => l_no_life_events_warning
417: );
418:
419: exception
420: when hr_api.cannot_find_prog_unit then
421: hr_api.cannot_find_prog_unit_error
422: (p_module_name => 'CREATE_PERF_MGMT_PLAN',
423: p_hook_type => 'AP'
424: );
417: );
418:
419: exception
420: when hr_api.cannot_find_prog_unit then
421: hr_api.cannot_find_prog_unit_error
422: (p_module_name => 'CREATE_PERF_MGMT_PLAN',
423: p_hook_type => 'AP'
424: );
425:
432: --
433: -- When in validation only mode raise the Validate_Enabled exception
434: --
435: if p_validate then
436: raise hr_api.validate_enabled;
437: end if;
438: --
439: --
440: -- Set all IN OUT and OUT parameters with out values
482:
483: END IF;
484:
485: exception
486: when hr_api.validate_enabled then
487: --
488: -- As the Validate_Enabled exception has been raised
489: -- we must rollback to the savepoint
490: --
528: procedure update_perf_mgmt_plan
529: (p_validate in boolean default false
530: ,p_effective_date in date
531: ,p_plan_id in number
532: ,p_plan_name in varchar2 default hr_api.g_varchar2
533: ,p_administrator_person_id in number default hr_api.g_number
534: ,p_previous_plan_id in number default hr_api.g_number
535: ,p_start_date in date default hr_api.g_date
536: ,p_end_date in date default hr_api.g_date
529: (p_validate in boolean default false
530: ,p_effective_date in date
531: ,p_plan_id in number
532: ,p_plan_name in varchar2 default hr_api.g_varchar2
533: ,p_administrator_person_id in number default hr_api.g_number
534: ,p_previous_plan_id in number default hr_api.g_number
535: ,p_start_date in date default hr_api.g_date
536: ,p_end_date in date default hr_api.g_date
537: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
530: ,p_effective_date in date
531: ,p_plan_id in number
532: ,p_plan_name in varchar2 default hr_api.g_varchar2
533: ,p_administrator_person_id in number default hr_api.g_number
534: ,p_previous_plan_id in number default hr_api.g_number
535: ,p_start_date in date default hr_api.g_date
536: ,p_end_date in date default hr_api.g_date
537: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
538: ,p_supervisor_id in number default hr_api.g_number
531: ,p_plan_id in number
532: ,p_plan_name in varchar2 default hr_api.g_varchar2
533: ,p_administrator_person_id in number default hr_api.g_number
534: ,p_previous_plan_id in number default hr_api.g_number
535: ,p_start_date in date default hr_api.g_date
536: ,p_end_date in date default hr_api.g_date
537: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
538: ,p_supervisor_id in number default hr_api.g_number
539: ,p_supervisor_assignment_id in number default hr_api.g_number
532: ,p_plan_name in varchar2 default hr_api.g_varchar2
533: ,p_administrator_person_id in number default hr_api.g_number
534: ,p_previous_plan_id in number default hr_api.g_number
535: ,p_start_date in date default hr_api.g_date
536: ,p_end_date in date default hr_api.g_date
537: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
538: ,p_supervisor_id in number default hr_api.g_number
539: ,p_supervisor_assignment_id in number default hr_api.g_number
540: ,p_organization_structure_id in number default hr_api.g_number
533: ,p_administrator_person_id in number default hr_api.g_number
534: ,p_previous_plan_id in number default hr_api.g_number
535: ,p_start_date in date default hr_api.g_date
536: ,p_end_date in date default hr_api.g_date
537: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
538: ,p_supervisor_id in number default hr_api.g_number
539: ,p_supervisor_assignment_id in number default hr_api.g_number
540: ,p_organization_structure_id in number default hr_api.g_number
541: ,p_org_structure_version_id in number default hr_api.g_number
534: ,p_previous_plan_id in number default hr_api.g_number
535: ,p_start_date in date default hr_api.g_date
536: ,p_end_date in date default hr_api.g_date
537: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
538: ,p_supervisor_id in number default hr_api.g_number
539: ,p_supervisor_assignment_id in number default hr_api.g_number
540: ,p_organization_structure_id in number default hr_api.g_number
541: ,p_org_structure_version_id in number default hr_api.g_number
542: ,p_top_organization_id in number default hr_api.g_number
535: ,p_start_date in date default hr_api.g_date
536: ,p_end_date in date default hr_api.g_date
537: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
538: ,p_supervisor_id in number default hr_api.g_number
539: ,p_supervisor_assignment_id in number default hr_api.g_number
540: ,p_organization_structure_id in number default hr_api.g_number
541: ,p_org_structure_version_id in number default hr_api.g_number
542: ,p_top_organization_id in number default hr_api.g_number
543: ,p_position_structure_id in number default hr_api.g_number
536: ,p_end_date in date default hr_api.g_date
537: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
538: ,p_supervisor_id in number default hr_api.g_number
539: ,p_supervisor_assignment_id in number default hr_api.g_number
540: ,p_organization_structure_id in number default hr_api.g_number
541: ,p_org_structure_version_id in number default hr_api.g_number
542: ,p_top_organization_id in number default hr_api.g_number
543: ,p_position_structure_id in number default hr_api.g_number
544: ,p_pos_structure_version_id in number default hr_api.g_number
537: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
538: ,p_supervisor_id in number default hr_api.g_number
539: ,p_supervisor_assignment_id in number default hr_api.g_number
540: ,p_organization_structure_id in number default hr_api.g_number
541: ,p_org_structure_version_id in number default hr_api.g_number
542: ,p_top_organization_id in number default hr_api.g_number
543: ,p_position_structure_id in number default hr_api.g_number
544: ,p_pos_structure_version_id in number default hr_api.g_number
545: ,p_top_position_id in number default hr_api.g_number
538: ,p_supervisor_id in number default hr_api.g_number
539: ,p_supervisor_assignment_id in number default hr_api.g_number
540: ,p_organization_structure_id in number default hr_api.g_number
541: ,p_org_structure_version_id in number default hr_api.g_number
542: ,p_top_organization_id in number default hr_api.g_number
543: ,p_position_structure_id in number default hr_api.g_number
544: ,p_pos_structure_version_id in number default hr_api.g_number
545: ,p_top_position_id in number default hr_api.g_number
546: ,p_hierarchy_levels in number default hr_api.g_number
539: ,p_supervisor_assignment_id in number default hr_api.g_number
540: ,p_organization_structure_id in number default hr_api.g_number
541: ,p_org_structure_version_id in number default hr_api.g_number
542: ,p_top_organization_id in number default hr_api.g_number
543: ,p_position_structure_id in number default hr_api.g_number
544: ,p_pos_structure_version_id in number default hr_api.g_number
545: ,p_top_position_id in number default hr_api.g_number
546: ,p_hierarchy_levels in number default hr_api.g_number
547: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
540: ,p_organization_structure_id in number default hr_api.g_number
541: ,p_org_structure_version_id in number default hr_api.g_number
542: ,p_top_organization_id in number default hr_api.g_number
543: ,p_position_structure_id in number default hr_api.g_number
544: ,p_pos_structure_version_id in number default hr_api.g_number
545: ,p_top_position_id in number default hr_api.g_number
546: ,p_hierarchy_levels in number default hr_api.g_number
547: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
548: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
541: ,p_org_structure_version_id in number default hr_api.g_number
542: ,p_top_organization_id in number default hr_api.g_number
543: ,p_position_structure_id in number default hr_api.g_number
544: ,p_pos_structure_version_id in number default hr_api.g_number
545: ,p_top_position_id in number default hr_api.g_number
546: ,p_hierarchy_levels in number default hr_api.g_number
547: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
548: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
549: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
542: ,p_top_organization_id in number default hr_api.g_number
543: ,p_position_structure_id in number default hr_api.g_number
544: ,p_pos_structure_version_id in number default hr_api.g_number
545: ,p_top_position_id in number default hr_api.g_number
546: ,p_hierarchy_levels in number default hr_api.g_number
547: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
548: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
549: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
550: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
543: ,p_position_structure_id in number default hr_api.g_number
544: ,p_pos_structure_version_id in number default hr_api.g_number
545: ,p_top_position_id in number default hr_api.g_number
546: ,p_hierarchy_levels in number default hr_api.g_number
547: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
548: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
549: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
550: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
551: ,p_obj_setting_start_date in date default hr_api.g_date
544: ,p_pos_structure_version_id in number default hr_api.g_number
545: ,p_top_position_id in number default hr_api.g_number
546: ,p_hierarchy_levels in number default hr_api.g_number
547: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
548: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
549: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
550: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
551: ,p_obj_setting_start_date in date default hr_api.g_date
552: ,p_obj_setting_deadline in date default hr_api.g_date
545: ,p_top_position_id in number default hr_api.g_number
546: ,p_hierarchy_levels in number default hr_api.g_number
547: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
548: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
549: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
550: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
551: ,p_obj_setting_start_date in date default hr_api.g_date
552: ,p_obj_setting_deadline in date default hr_api.g_date
553: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
546: ,p_hierarchy_levels in number default hr_api.g_number
547: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
548: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
549: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
550: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
551: ,p_obj_setting_start_date in date default hr_api.g_date
552: ,p_obj_setting_deadline in date default hr_api.g_date
553: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
554: ,p_method_code in varchar2 default hr_api.g_varchar2
547: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
548: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
549: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
550: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
551: ,p_obj_setting_start_date in date default hr_api.g_date
552: ,p_obj_setting_deadline in date default hr_api.g_date
553: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
554: ,p_method_code in varchar2 default hr_api.g_varchar2
555: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
548: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
549: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
550: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
551: ,p_obj_setting_start_date in date default hr_api.g_date
552: ,p_obj_setting_deadline in date default hr_api.g_date
553: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
554: ,p_method_code in varchar2 default hr_api.g_varchar2
555: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
556: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
549: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
550: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
551: ,p_obj_setting_start_date in date default hr_api.g_date
552: ,p_obj_setting_deadline in date default hr_api.g_date
553: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
554: ,p_method_code in varchar2 default hr_api.g_varchar2
555: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
556: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
557: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
550: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
551: ,p_obj_setting_start_date in date default hr_api.g_date
552: ,p_obj_setting_deadline in date default hr_api.g_date
553: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
554: ,p_method_code in varchar2 default hr_api.g_varchar2
555: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
556: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
557: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
558: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
551: ,p_obj_setting_start_date in date default hr_api.g_date
552: ,p_obj_setting_deadline in date default hr_api.g_date
553: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
554: ,p_method_code in varchar2 default hr_api.g_varchar2
555: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
556: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
557: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
558: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
559: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
552: ,p_obj_setting_deadline in date default hr_api.g_date
553: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
554: ,p_method_code in varchar2 default hr_api.g_varchar2
555: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
556: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
557: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
558: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
559: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
560: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
553: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
554: ,p_method_code in varchar2 default hr_api.g_varchar2
555: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
556: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
557: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
558: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
559: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
560: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
561: ,p_attribute_category in varchar2 default hr_api.g_varchar2
554: ,p_method_code in varchar2 default hr_api.g_varchar2
555: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
556: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
557: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
558: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
559: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
560: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
561: ,p_attribute_category in varchar2 default hr_api.g_varchar2
562: ,p_attribute1 in varchar2 default hr_api.g_varchar2
555: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
556: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
557: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
558: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
559: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
560: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
561: ,p_attribute_category in varchar2 default hr_api.g_varchar2
562: ,p_attribute1 in varchar2 default hr_api.g_varchar2
563: ,p_attribute2 in varchar2 default hr_api.g_varchar2
556: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
557: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
558: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
559: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
560: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
561: ,p_attribute_category in varchar2 default hr_api.g_varchar2
562: ,p_attribute1 in varchar2 default hr_api.g_varchar2
563: ,p_attribute2 in varchar2 default hr_api.g_varchar2
564: ,p_attribute3 in varchar2 default hr_api.g_varchar2
557: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
558: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
559: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
560: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
561: ,p_attribute_category in varchar2 default hr_api.g_varchar2
562: ,p_attribute1 in varchar2 default hr_api.g_varchar2
563: ,p_attribute2 in varchar2 default hr_api.g_varchar2
564: ,p_attribute3 in varchar2 default hr_api.g_varchar2
565: ,p_attribute4 in varchar2 default hr_api.g_varchar2
558: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
559: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
560: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
561: ,p_attribute_category in varchar2 default hr_api.g_varchar2
562: ,p_attribute1 in varchar2 default hr_api.g_varchar2
563: ,p_attribute2 in varchar2 default hr_api.g_varchar2
564: ,p_attribute3 in varchar2 default hr_api.g_varchar2
565: ,p_attribute4 in varchar2 default hr_api.g_varchar2
566: ,p_attribute5 in varchar2 default hr_api.g_varchar2
559: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
560: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
561: ,p_attribute_category in varchar2 default hr_api.g_varchar2
562: ,p_attribute1 in varchar2 default hr_api.g_varchar2
563: ,p_attribute2 in varchar2 default hr_api.g_varchar2
564: ,p_attribute3 in varchar2 default hr_api.g_varchar2
565: ,p_attribute4 in varchar2 default hr_api.g_varchar2
566: ,p_attribute5 in varchar2 default hr_api.g_varchar2
567: ,p_attribute6 in varchar2 default hr_api.g_varchar2
560: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
561: ,p_attribute_category in varchar2 default hr_api.g_varchar2
562: ,p_attribute1 in varchar2 default hr_api.g_varchar2
563: ,p_attribute2 in varchar2 default hr_api.g_varchar2
564: ,p_attribute3 in varchar2 default hr_api.g_varchar2
565: ,p_attribute4 in varchar2 default hr_api.g_varchar2
566: ,p_attribute5 in varchar2 default hr_api.g_varchar2
567: ,p_attribute6 in varchar2 default hr_api.g_varchar2
568: ,p_attribute7 in varchar2 default hr_api.g_varchar2
561: ,p_attribute_category in varchar2 default hr_api.g_varchar2
562: ,p_attribute1 in varchar2 default hr_api.g_varchar2
563: ,p_attribute2 in varchar2 default hr_api.g_varchar2
564: ,p_attribute3 in varchar2 default hr_api.g_varchar2
565: ,p_attribute4 in varchar2 default hr_api.g_varchar2
566: ,p_attribute5 in varchar2 default hr_api.g_varchar2
567: ,p_attribute6 in varchar2 default hr_api.g_varchar2
568: ,p_attribute7 in varchar2 default hr_api.g_varchar2
569: ,p_attribute8 in varchar2 default hr_api.g_varchar2
562: ,p_attribute1 in varchar2 default hr_api.g_varchar2
563: ,p_attribute2 in varchar2 default hr_api.g_varchar2
564: ,p_attribute3 in varchar2 default hr_api.g_varchar2
565: ,p_attribute4 in varchar2 default hr_api.g_varchar2
566: ,p_attribute5 in varchar2 default hr_api.g_varchar2
567: ,p_attribute6 in varchar2 default hr_api.g_varchar2
568: ,p_attribute7 in varchar2 default hr_api.g_varchar2
569: ,p_attribute8 in varchar2 default hr_api.g_varchar2
570: ,p_attribute9 in varchar2 default hr_api.g_varchar2
563: ,p_attribute2 in varchar2 default hr_api.g_varchar2
564: ,p_attribute3 in varchar2 default hr_api.g_varchar2
565: ,p_attribute4 in varchar2 default hr_api.g_varchar2
566: ,p_attribute5 in varchar2 default hr_api.g_varchar2
567: ,p_attribute6 in varchar2 default hr_api.g_varchar2
568: ,p_attribute7 in varchar2 default hr_api.g_varchar2
569: ,p_attribute8 in varchar2 default hr_api.g_varchar2
570: ,p_attribute9 in varchar2 default hr_api.g_varchar2
571: ,p_attribute10 in varchar2 default hr_api.g_varchar2
564: ,p_attribute3 in varchar2 default hr_api.g_varchar2
565: ,p_attribute4 in varchar2 default hr_api.g_varchar2
566: ,p_attribute5 in varchar2 default hr_api.g_varchar2
567: ,p_attribute6 in varchar2 default hr_api.g_varchar2
568: ,p_attribute7 in varchar2 default hr_api.g_varchar2
569: ,p_attribute8 in varchar2 default hr_api.g_varchar2
570: ,p_attribute9 in varchar2 default hr_api.g_varchar2
571: ,p_attribute10 in varchar2 default hr_api.g_varchar2
572: ,p_attribute11 in varchar2 default hr_api.g_varchar2
565: ,p_attribute4 in varchar2 default hr_api.g_varchar2
566: ,p_attribute5 in varchar2 default hr_api.g_varchar2
567: ,p_attribute6 in varchar2 default hr_api.g_varchar2
568: ,p_attribute7 in varchar2 default hr_api.g_varchar2
569: ,p_attribute8 in varchar2 default hr_api.g_varchar2
570: ,p_attribute9 in varchar2 default hr_api.g_varchar2
571: ,p_attribute10 in varchar2 default hr_api.g_varchar2
572: ,p_attribute11 in varchar2 default hr_api.g_varchar2
573: ,p_attribute12 in varchar2 default hr_api.g_varchar2
566: ,p_attribute5 in varchar2 default hr_api.g_varchar2
567: ,p_attribute6 in varchar2 default hr_api.g_varchar2
568: ,p_attribute7 in varchar2 default hr_api.g_varchar2
569: ,p_attribute8 in varchar2 default hr_api.g_varchar2
570: ,p_attribute9 in varchar2 default hr_api.g_varchar2
571: ,p_attribute10 in varchar2 default hr_api.g_varchar2
572: ,p_attribute11 in varchar2 default hr_api.g_varchar2
573: ,p_attribute12 in varchar2 default hr_api.g_varchar2
574: ,p_attribute13 in varchar2 default hr_api.g_varchar2
567: ,p_attribute6 in varchar2 default hr_api.g_varchar2
568: ,p_attribute7 in varchar2 default hr_api.g_varchar2
569: ,p_attribute8 in varchar2 default hr_api.g_varchar2
570: ,p_attribute9 in varchar2 default hr_api.g_varchar2
571: ,p_attribute10 in varchar2 default hr_api.g_varchar2
572: ,p_attribute11 in varchar2 default hr_api.g_varchar2
573: ,p_attribute12 in varchar2 default hr_api.g_varchar2
574: ,p_attribute13 in varchar2 default hr_api.g_varchar2
575: ,p_attribute14 in varchar2 default hr_api.g_varchar2
568: ,p_attribute7 in varchar2 default hr_api.g_varchar2
569: ,p_attribute8 in varchar2 default hr_api.g_varchar2
570: ,p_attribute9 in varchar2 default hr_api.g_varchar2
571: ,p_attribute10 in varchar2 default hr_api.g_varchar2
572: ,p_attribute11 in varchar2 default hr_api.g_varchar2
573: ,p_attribute12 in varchar2 default hr_api.g_varchar2
574: ,p_attribute13 in varchar2 default hr_api.g_varchar2
575: ,p_attribute14 in varchar2 default hr_api.g_varchar2
576: ,p_attribute15 in varchar2 default hr_api.g_varchar2
569: ,p_attribute8 in varchar2 default hr_api.g_varchar2
570: ,p_attribute9 in varchar2 default hr_api.g_varchar2
571: ,p_attribute10 in varchar2 default hr_api.g_varchar2
572: ,p_attribute11 in varchar2 default hr_api.g_varchar2
573: ,p_attribute12 in varchar2 default hr_api.g_varchar2
574: ,p_attribute13 in varchar2 default hr_api.g_varchar2
575: ,p_attribute14 in varchar2 default hr_api.g_varchar2
576: ,p_attribute15 in varchar2 default hr_api.g_varchar2
577: ,p_attribute16 in varchar2 default hr_api.g_varchar2
570: ,p_attribute9 in varchar2 default hr_api.g_varchar2
571: ,p_attribute10 in varchar2 default hr_api.g_varchar2
572: ,p_attribute11 in varchar2 default hr_api.g_varchar2
573: ,p_attribute12 in varchar2 default hr_api.g_varchar2
574: ,p_attribute13 in varchar2 default hr_api.g_varchar2
575: ,p_attribute14 in varchar2 default hr_api.g_varchar2
576: ,p_attribute15 in varchar2 default hr_api.g_varchar2
577: ,p_attribute16 in varchar2 default hr_api.g_varchar2
578: ,p_attribute17 in varchar2 default hr_api.g_varchar2
571: ,p_attribute10 in varchar2 default hr_api.g_varchar2
572: ,p_attribute11 in varchar2 default hr_api.g_varchar2
573: ,p_attribute12 in varchar2 default hr_api.g_varchar2
574: ,p_attribute13 in varchar2 default hr_api.g_varchar2
575: ,p_attribute14 in varchar2 default hr_api.g_varchar2
576: ,p_attribute15 in varchar2 default hr_api.g_varchar2
577: ,p_attribute16 in varchar2 default hr_api.g_varchar2
578: ,p_attribute17 in varchar2 default hr_api.g_varchar2
579: ,p_attribute18 in varchar2 default hr_api.g_varchar2
572: ,p_attribute11 in varchar2 default hr_api.g_varchar2
573: ,p_attribute12 in varchar2 default hr_api.g_varchar2
574: ,p_attribute13 in varchar2 default hr_api.g_varchar2
575: ,p_attribute14 in varchar2 default hr_api.g_varchar2
576: ,p_attribute15 in varchar2 default hr_api.g_varchar2
577: ,p_attribute16 in varchar2 default hr_api.g_varchar2
578: ,p_attribute17 in varchar2 default hr_api.g_varchar2
579: ,p_attribute18 in varchar2 default hr_api.g_varchar2
580: ,p_attribute19 in varchar2 default hr_api.g_varchar2
573: ,p_attribute12 in varchar2 default hr_api.g_varchar2
574: ,p_attribute13 in varchar2 default hr_api.g_varchar2
575: ,p_attribute14 in varchar2 default hr_api.g_varchar2
576: ,p_attribute15 in varchar2 default hr_api.g_varchar2
577: ,p_attribute16 in varchar2 default hr_api.g_varchar2
578: ,p_attribute17 in varchar2 default hr_api.g_varchar2
579: ,p_attribute18 in varchar2 default hr_api.g_varchar2
580: ,p_attribute19 in varchar2 default hr_api.g_varchar2
581: ,p_attribute20 in varchar2 default hr_api.g_varchar2
574: ,p_attribute13 in varchar2 default hr_api.g_varchar2
575: ,p_attribute14 in varchar2 default hr_api.g_varchar2
576: ,p_attribute15 in varchar2 default hr_api.g_varchar2
577: ,p_attribute16 in varchar2 default hr_api.g_varchar2
578: ,p_attribute17 in varchar2 default hr_api.g_varchar2
579: ,p_attribute18 in varchar2 default hr_api.g_varchar2
580: ,p_attribute19 in varchar2 default hr_api.g_varchar2
581: ,p_attribute20 in varchar2 default hr_api.g_varchar2
582: ,p_attribute21 in varchar2 default hr_api.g_varchar2
575: ,p_attribute14 in varchar2 default hr_api.g_varchar2
576: ,p_attribute15 in varchar2 default hr_api.g_varchar2
577: ,p_attribute16 in varchar2 default hr_api.g_varchar2
578: ,p_attribute17 in varchar2 default hr_api.g_varchar2
579: ,p_attribute18 in varchar2 default hr_api.g_varchar2
580: ,p_attribute19 in varchar2 default hr_api.g_varchar2
581: ,p_attribute20 in varchar2 default hr_api.g_varchar2
582: ,p_attribute21 in varchar2 default hr_api.g_varchar2
583: ,p_attribute22 in varchar2 default hr_api.g_varchar2
576: ,p_attribute15 in varchar2 default hr_api.g_varchar2
577: ,p_attribute16 in varchar2 default hr_api.g_varchar2
578: ,p_attribute17 in varchar2 default hr_api.g_varchar2
579: ,p_attribute18 in varchar2 default hr_api.g_varchar2
580: ,p_attribute19 in varchar2 default hr_api.g_varchar2
581: ,p_attribute20 in varchar2 default hr_api.g_varchar2
582: ,p_attribute21 in varchar2 default hr_api.g_varchar2
583: ,p_attribute22 in varchar2 default hr_api.g_varchar2
584: ,p_attribute23 in varchar2 default hr_api.g_varchar2
577: ,p_attribute16 in varchar2 default hr_api.g_varchar2
578: ,p_attribute17 in varchar2 default hr_api.g_varchar2
579: ,p_attribute18 in varchar2 default hr_api.g_varchar2
580: ,p_attribute19 in varchar2 default hr_api.g_varchar2
581: ,p_attribute20 in varchar2 default hr_api.g_varchar2
582: ,p_attribute21 in varchar2 default hr_api.g_varchar2
583: ,p_attribute22 in varchar2 default hr_api.g_varchar2
584: ,p_attribute23 in varchar2 default hr_api.g_varchar2
585: ,p_attribute24 in varchar2 default hr_api.g_varchar2
578: ,p_attribute17 in varchar2 default hr_api.g_varchar2
579: ,p_attribute18 in varchar2 default hr_api.g_varchar2
580: ,p_attribute19 in varchar2 default hr_api.g_varchar2
581: ,p_attribute20 in varchar2 default hr_api.g_varchar2
582: ,p_attribute21 in varchar2 default hr_api.g_varchar2
583: ,p_attribute22 in varchar2 default hr_api.g_varchar2
584: ,p_attribute23 in varchar2 default hr_api.g_varchar2
585: ,p_attribute24 in varchar2 default hr_api.g_varchar2
586: ,p_attribute25 in varchar2 default hr_api.g_varchar2
579: ,p_attribute18 in varchar2 default hr_api.g_varchar2
580: ,p_attribute19 in varchar2 default hr_api.g_varchar2
581: ,p_attribute20 in varchar2 default hr_api.g_varchar2
582: ,p_attribute21 in varchar2 default hr_api.g_varchar2
583: ,p_attribute22 in varchar2 default hr_api.g_varchar2
584: ,p_attribute23 in varchar2 default hr_api.g_varchar2
585: ,p_attribute24 in varchar2 default hr_api.g_varchar2
586: ,p_attribute25 in varchar2 default hr_api.g_varchar2
587: ,p_attribute26 in varchar2 default hr_api.g_varchar2
580: ,p_attribute19 in varchar2 default hr_api.g_varchar2
581: ,p_attribute20 in varchar2 default hr_api.g_varchar2
582: ,p_attribute21 in varchar2 default hr_api.g_varchar2
583: ,p_attribute22 in varchar2 default hr_api.g_varchar2
584: ,p_attribute23 in varchar2 default hr_api.g_varchar2
585: ,p_attribute24 in varchar2 default hr_api.g_varchar2
586: ,p_attribute25 in varchar2 default hr_api.g_varchar2
587: ,p_attribute26 in varchar2 default hr_api.g_varchar2
588: ,p_attribute27 in varchar2 default hr_api.g_varchar2
581: ,p_attribute20 in varchar2 default hr_api.g_varchar2
582: ,p_attribute21 in varchar2 default hr_api.g_varchar2
583: ,p_attribute22 in varchar2 default hr_api.g_varchar2
584: ,p_attribute23 in varchar2 default hr_api.g_varchar2
585: ,p_attribute24 in varchar2 default hr_api.g_varchar2
586: ,p_attribute25 in varchar2 default hr_api.g_varchar2
587: ,p_attribute26 in varchar2 default hr_api.g_varchar2
588: ,p_attribute27 in varchar2 default hr_api.g_varchar2
589: ,p_attribute28 in varchar2 default hr_api.g_varchar2
582: ,p_attribute21 in varchar2 default hr_api.g_varchar2
583: ,p_attribute22 in varchar2 default hr_api.g_varchar2
584: ,p_attribute23 in varchar2 default hr_api.g_varchar2
585: ,p_attribute24 in varchar2 default hr_api.g_varchar2
586: ,p_attribute25 in varchar2 default hr_api.g_varchar2
587: ,p_attribute26 in varchar2 default hr_api.g_varchar2
588: ,p_attribute27 in varchar2 default hr_api.g_varchar2
589: ,p_attribute28 in varchar2 default hr_api.g_varchar2
590: ,p_attribute29 in varchar2 default hr_api.g_varchar2
583: ,p_attribute22 in varchar2 default hr_api.g_varchar2
584: ,p_attribute23 in varchar2 default hr_api.g_varchar2
585: ,p_attribute24 in varchar2 default hr_api.g_varchar2
586: ,p_attribute25 in varchar2 default hr_api.g_varchar2
587: ,p_attribute26 in varchar2 default hr_api.g_varchar2
588: ,p_attribute27 in varchar2 default hr_api.g_varchar2
589: ,p_attribute28 in varchar2 default hr_api.g_varchar2
590: ,p_attribute29 in varchar2 default hr_api.g_varchar2
591: ,p_attribute30 in varchar2 default hr_api.g_varchar2
584: ,p_attribute23 in varchar2 default hr_api.g_varchar2
585: ,p_attribute24 in varchar2 default hr_api.g_varchar2
586: ,p_attribute25 in varchar2 default hr_api.g_varchar2
587: ,p_attribute26 in varchar2 default hr_api.g_varchar2
588: ,p_attribute27 in varchar2 default hr_api.g_varchar2
589: ,p_attribute28 in varchar2 default hr_api.g_varchar2
590: ,p_attribute29 in varchar2 default hr_api.g_varchar2
591: ,p_attribute30 in varchar2 default hr_api.g_varchar2
592: ,p_object_version_number in out nocopy number
585: ,p_attribute24 in varchar2 default hr_api.g_varchar2
586: ,p_attribute25 in varchar2 default hr_api.g_varchar2
587: ,p_attribute26 in varchar2 default hr_api.g_varchar2
588: ,p_attribute27 in varchar2 default hr_api.g_varchar2
589: ,p_attribute28 in varchar2 default hr_api.g_varchar2
590: ,p_attribute29 in varchar2 default hr_api.g_varchar2
591: ,p_attribute30 in varchar2 default hr_api.g_varchar2
592: ,p_object_version_number in out nocopy number
593: ,p_status_code out nocopy varchar2
586: ,p_attribute25 in varchar2 default hr_api.g_varchar2
587: ,p_attribute26 in varchar2 default hr_api.g_varchar2
588: ,p_attribute27 in varchar2 default hr_api.g_varchar2
589: ,p_attribute28 in varchar2 default hr_api.g_varchar2
590: ,p_attribute29 in varchar2 default hr_api.g_varchar2
591: ,p_attribute30 in varchar2 default hr_api.g_varchar2
592: ,p_object_version_number in out nocopy number
593: ,p_status_code out nocopy varchar2
594: ,p_duplicate_name_warning out nocopy boolean
587: ,p_attribute26 in varchar2 default hr_api.g_varchar2
588: ,p_attribute27 in varchar2 default hr_api.g_varchar2
589: ,p_attribute28 in varchar2 default hr_api.g_varchar2
590: ,p_attribute29 in varchar2 default hr_api.g_varchar2
591: ,p_attribute30 in varchar2 default hr_api.g_varchar2
592: ,p_object_version_number in out nocopy number
593: ,p_status_code out nocopy varchar2
594: ,p_duplicate_name_warning out nocopy boolean
595: ,p_no_life_events_warning out nocopy boolean
783: ,p_object_version_number => l_object_version_number
784: );
785:
786: exception
787: when hr_api.cannot_find_prog_unit then
788: hr_api.cannot_find_prog_unit_error
789: (p_module_name => 'UPDATE_PERF_MGMT_PLAN',
790: p_hook_type => 'BP'
791: );
784: );
785:
786: exception
787: when hr_api.cannot_find_prog_unit then
788: hr_api.cannot_find_prog_unit_error
789: (p_module_name => 'UPDATE_PERF_MGMT_PLAN',
790: p_hook_type => 'BP'
791: );
792:
951: ,p_duplicate_name_warning => l_duplicate_name_warning
952: ,p_no_life_events_warning => l_no_life_events_warning
953: );
954: exception
955: when hr_api.cannot_find_prog_unit then
956: hr_api.cannot_find_prog_unit_error
957: (p_module_name => 'UPDATE_PERF_MGMT_PLAN',
958: p_hook_type => 'AP'
959: );
952: ,p_no_life_events_warning => l_no_life_events_warning
953: );
954: exception
955: when hr_api.cannot_find_prog_unit then
956: hr_api.cannot_find_prog_unit_error
957: (p_module_name => 'UPDATE_PERF_MGMT_PLAN',
958: p_hook_type => 'AP'
959: );
960: end;
966: --
967: -- When in validation only mode raise the Validate_Enabled exception
968: --
969: if p_validate then
970: raise hr_api.validate_enabled;
971: end if;
972:
973: --
974: -- Set all IN OUT and OUT parameters with out values
1012:
1013: END IF;
1014:
1015: exception
1016: when hr_api.validate_enabled then
1017: --
1018: -- As the Validate_Enabled exception has been raised
1019: -- we must rollback to the savepoint
1020: --
1102: (p_plan_id => p_plan_id
1103: ,p_object_version_number => p_object_version_number
1104: );
1105: exception
1106: when hr_api.cannot_find_prog_unit then
1107: hr_api.cannot_find_prog_unit_error
1108: (p_module_name => 'DELETE_PERF_MGMT_PLAN',
1109: p_hook_type => 'BP'
1110: );
1103: ,p_object_version_number => p_object_version_number
1104: );
1105: exception
1106: when hr_api.cannot_find_prog_unit then
1107: hr_api.cannot_find_prog_unit_error
1108: (p_module_name => 'DELETE_PERF_MGMT_PLAN',
1109: p_hook_type => 'BP'
1110: );
1111: end;
1132: (p_plan_id => p_plan_id
1133: ,p_object_version_number => p_object_version_number
1134: );
1135: exception
1136: when hr_api.cannot_find_prog_unit then
1137: hr_api.cannot_find_prog_unit_error
1138: (p_module_name => 'DELETE_PERF_MGMT_PLAN',
1139: p_hook_type => 'AP'
1140: );
1133: ,p_object_version_number => p_object_version_number
1134: );
1135: exception
1136: when hr_api.cannot_find_prog_unit then
1137: hr_api.cannot_find_prog_unit_error
1138: (p_module_name => 'DELETE_PERF_MGMT_PLAN',
1139: p_hook_type => 'AP'
1140: );
1141: end;
1144: --
1145: -- When in validation only mode raise the Validate_Enabled exception
1146: --
1147: if p_validate then
1148: raise hr_api.validate_enabled;
1149: end if;
1150:
1151: --
1152: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
1153: --
1154: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1155:
1156: exception
1157: when hr_api.validate_enabled then
1158: --
1159: -- As the Validate_Enabled exception has been raised
1160: -- we must rollback to the savepoint
1161: --
1245: ,p_plan_id => p_plan_id
1246: ,p_object_version_number => l_object_version_number
1247: );
1248: exception
1249: when hr_api.cannot_find_prog_unit then
1250: hr_api.cannot_find_prog_unit_error
1251: (p_module_name => 'PUBLISH',
1252: p_hook_type => 'BP'
1253: );
1246: ,p_object_version_number => l_object_version_number
1247: );
1248: exception
1249: when hr_api.cannot_find_prog_unit then
1250: hr_api.cannot_find_prog_unit_error
1251: (p_module_name => 'PUBLISH',
1252: p_hook_type => 'BP'
1253: );
1254: end;
1286: ,p_plan_id => p_plan_id
1287: ,p_object_version_number => l_object_version_number
1288: );
1289: exception
1290: when hr_api.cannot_find_prog_unit then
1291: hr_api.cannot_find_prog_unit_error
1292: (p_module_name => 'PUBLISH_A',
1293: p_hook_type => 'AP'
1294: );
1287: ,p_object_version_number => l_object_version_number
1288: );
1289: exception
1290: when hr_api.cannot_find_prog_unit then
1291: hr_api.cannot_find_prog_unit_error
1292: (p_module_name => 'PUBLISH_A',
1293: p_hook_type => 'AP'
1294: );
1295: end;
1298: --
1299: -- When in validation only mode raise the Validate_Enabled exception
1300: --
1301: if p_validate then
1302: raise hr_api.validate_enabled;
1303: end if;
1304:
1305: --
1306: -- Set all IN OUT and OUT parameters with out values
1312: --
1313: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1314:
1315: exception
1316: when hr_api.validate_enabled then
1317: --
1318: -- As the Validate_Enabled exception has been raised
1319: -- we must rollback to the savepoint
1320: --
1401: (p_plan_id => p_plan_id
1402: ,p_object_version_number => l_object_version_number
1403: );
1404: exception
1405: when hr_api.cannot_find_prog_unit then
1406: hr_api.cannot_find_prog_unit_error
1407: (p_module_name => 'REVERSE_PUBLISH',
1408: p_hook_type => 'BP'
1409: );
1402: ,p_object_version_number => l_object_version_number
1403: );
1404: exception
1405: when hr_api.cannot_find_prog_unit then
1406: hr_api.cannot_find_prog_unit_error
1407: (p_module_name => 'REVERSE_PUBLISH',
1408: p_hook_type => 'BP'
1409: );
1410: end;
1442: (p_plan_id => p_plan_id
1443: ,p_object_version_number => l_object_version_number
1444: );
1445: exception
1446: when hr_api.cannot_find_prog_unit then
1447: hr_api.cannot_find_prog_unit_error
1448: (p_module_name => 'REVERSE_PUBLISH_A',
1449: p_hook_type => 'AP'
1450: );
1443: ,p_object_version_number => l_object_version_number
1444: );
1445: exception
1446: when hr_api.cannot_find_prog_unit then
1447: hr_api.cannot_find_prog_unit_error
1448: (p_module_name => 'REVERSE_PUBLISH_A',
1449: p_hook_type => 'AP'
1450: );
1451: end;
1454: --
1455: -- When in validation only mode raise the Validate_Enabled exception
1456: --
1457: if p_validate then
1458: raise hr_api.validate_enabled;
1459: end if;
1460:
1461: --
1462: -- Set all IN OUT and OUT parameters with out values
1468: --
1469: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1470:
1471: exception
1472: when hr_api.validate_enabled then
1473: --
1474: -- As the Validate_Enabled exception has been raised
1475: -- we must rollback to the savepoint
1476: --