259: ,p_automatic_approval_flag => p_automatic_approval_flag
260: );
261:
262: exception
263: when hr_api.cannot_find_prog_unit then
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'CREATE_PERF_MGMT_PLAN',
266: p_hook_type => 'BP'
267: );
260: );
261:
262: exception
263: when hr_api.cannot_find_prog_unit then
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'CREATE_PERF_MGMT_PLAN',
266: p_hook_type => 'BP'
267: );
268: end;
424: ,p_automatic_approval_flag => p_automatic_approval_flag
425: );
426:
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'CREATE_PERF_MGMT_PLAN',
431: p_hook_type => 'AP'
432: );
425: );
426:
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'CREATE_PERF_MGMT_PLAN',
431: p_hook_type => 'AP'
432: );
433:
440: --
441: -- When in validation only mode raise the Validate_Enabled exception
442: --
443: if p_validate then
444: raise hr_api.validate_enabled;
445: end if;
446: --
447: --
448: -- Set all IN OUT and OUT parameters with out values
490:
491: END IF;
492:
493: exception
494: when hr_api.validate_enabled then
495: --
496: -- As the Validate_Enabled exception has been raised
497: -- we must rollback to the savepoint
498: --
536: procedure update_perf_mgmt_plan
537: (p_validate in boolean default false
538: ,p_effective_date in date
539: ,p_plan_id in number
540: ,p_plan_name in varchar2 default hr_api.g_varchar2
541: ,p_administrator_person_id in number default hr_api.g_number
542: ,p_previous_plan_id in number default hr_api.g_number
543: ,p_start_date in date default hr_api.g_date
544: ,p_end_date in date default hr_api.g_date
537: (p_validate in boolean default false
538: ,p_effective_date in date
539: ,p_plan_id in number
540: ,p_plan_name in varchar2 default hr_api.g_varchar2
541: ,p_administrator_person_id in number default hr_api.g_number
542: ,p_previous_plan_id in number default hr_api.g_number
543: ,p_start_date in date default hr_api.g_date
544: ,p_end_date in date default hr_api.g_date
545: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
538: ,p_effective_date in date
539: ,p_plan_id in number
540: ,p_plan_name in varchar2 default hr_api.g_varchar2
541: ,p_administrator_person_id in number default hr_api.g_number
542: ,p_previous_plan_id in number default hr_api.g_number
543: ,p_start_date in date default hr_api.g_date
544: ,p_end_date in date default hr_api.g_date
545: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
546: ,p_supervisor_id in number default hr_api.g_number
539: ,p_plan_id in number
540: ,p_plan_name in varchar2 default hr_api.g_varchar2
541: ,p_administrator_person_id in number default hr_api.g_number
542: ,p_previous_plan_id in number default hr_api.g_number
543: ,p_start_date in date default hr_api.g_date
544: ,p_end_date in date default hr_api.g_date
545: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
546: ,p_supervisor_id in number default hr_api.g_number
547: ,p_supervisor_assignment_id in number default hr_api.g_number
540: ,p_plan_name in varchar2 default hr_api.g_varchar2
541: ,p_administrator_person_id in number default hr_api.g_number
542: ,p_previous_plan_id in number default hr_api.g_number
543: ,p_start_date in date default hr_api.g_date
544: ,p_end_date in date default hr_api.g_date
545: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
546: ,p_supervisor_id in number default hr_api.g_number
547: ,p_supervisor_assignment_id in number default hr_api.g_number
548: ,p_organization_structure_id in number default hr_api.g_number
541: ,p_administrator_person_id in number default hr_api.g_number
542: ,p_previous_plan_id in number default hr_api.g_number
543: ,p_start_date in date default hr_api.g_date
544: ,p_end_date in date default hr_api.g_date
545: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
546: ,p_supervisor_id in number default hr_api.g_number
547: ,p_supervisor_assignment_id in number default hr_api.g_number
548: ,p_organization_structure_id in number default hr_api.g_number
549: ,p_org_structure_version_id in number default hr_api.g_number
542: ,p_previous_plan_id in number default hr_api.g_number
543: ,p_start_date in date default hr_api.g_date
544: ,p_end_date in date default hr_api.g_date
545: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
546: ,p_supervisor_id in number default hr_api.g_number
547: ,p_supervisor_assignment_id in number default hr_api.g_number
548: ,p_organization_structure_id in number default hr_api.g_number
549: ,p_org_structure_version_id in number default hr_api.g_number
550: ,p_top_organization_id in number default hr_api.g_number
543: ,p_start_date in date default hr_api.g_date
544: ,p_end_date in date default hr_api.g_date
545: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
546: ,p_supervisor_id in number default hr_api.g_number
547: ,p_supervisor_assignment_id in number default hr_api.g_number
548: ,p_organization_structure_id in number default hr_api.g_number
549: ,p_org_structure_version_id in number default hr_api.g_number
550: ,p_top_organization_id in number default hr_api.g_number
551: ,p_position_structure_id in number default hr_api.g_number
544: ,p_end_date in date default hr_api.g_date
545: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
546: ,p_supervisor_id in number default hr_api.g_number
547: ,p_supervisor_assignment_id in number default hr_api.g_number
548: ,p_organization_structure_id in number default hr_api.g_number
549: ,p_org_structure_version_id in number default hr_api.g_number
550: ,p_top_organization_id in number default hr_api.g_number
551: ,p_position_structure_id in number default hr_api.g_number
552: ,p_pos_structure_version_id in number default hr_api.g_number
545: ,p_hierarchy_type_code in varchar2 default hr_api.g_varchar2
546: ,p_supervisor_id in number default hr_api.g_number
547: ,p_supervisor_assignment_id in number default hr_api.g_number
548: ,p_organization_structure_id in number default hr_api.g_number
549: ,p_org_structure_version_id in number default hr_api.g_number
550: ,p_top_organization_id in number default hr_api.g_number
551: ,p_position_structure_id in number default hr_api.g_number
552: ,p_pos_structure_version_id in number default hr_api.g_number
553: ,p_top_position_id in number default hr_api.g_number
546: ,p_supervisor_id in number default hr_api.g_number
547: ,p_supervisor_assignment_id in number default hr_api.g_number
548: ,p_organization_structure_id in number default hr_api.g_number
549: ,p_org_structure_version_id in number default hr_api.g_number
550: ,p_top_organization_id in number default hr_api.g_number
551: ,p_position_structure_id in number default hr_api.g_number
552: ,p_pos_structure_version_id in number default hr_api.g_number
553: ,p_top_position_id in number default hr_api.g_number
554: ,p_hierarchy_levels in number default hr_api.g_number
547: ,p_supervisor_assignment_id in number default hr_api.g_number
548: ,p_organization_structure_id in number default hr_api.g_number
549: ,p_org_structure_version_id in number default hr_api.g_number
550: ,p_top_organization_id in number default hr_api.g_number
551: ,p_position_structure_id in number default hr_api.g_number
552: ,p_pos_structure_version_id in number default hr_api.g_number
553: ,p_top_position_id in number default hr_api.g_number
554: ,p_hierarchy_levels in number default hr_api.g_number
555: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
548: ,p_organization_structure_id in number default hr_api.g_number
549: ,p_org_structure_version_id in number default hr_api.g_number
550: ,p_top_organization_id in number default hr_api.g_number
551: ,p_position_structure_id in number default hr_api.g_number
552: ,p_pos_structure_version_id in number default hr_api.g_number
553: ,p_top_position_id in number default hr_api.g_number
554: ,p_hierarchy_levels in number default hr_api.g_number
555: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
556: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
549: ,p_org_structure_version_id in number default hr_api.g_number
550: ,p_top_organization_id in number default hr_api.g_number
551: ,p_position_structure_id in number default hr_api.g_number
552: ,p_pos_structure_version_id in number default hr_api.g_number
553: ,p_top_position_id in number default hr_api.g_number
554: ,p_hierarchy_levels in number default hr_api.g_number
555: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
556: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
557: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
550: ,p_top_organization_id in number default hr_api.g_number
551: ,p_position_structure_id in number default hr_api.g_number
552: ,p_pos_structure_version_id in number default hr_api.g_number
553: ,p_top_position_id in number default hr_api.g_number
554: ,p_hierarchy_levels in number default hr_api.g_number
555: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
556: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
557: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
558: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
551: ,p_position_structure_id in number default hr_api.g_number
552: ,p_pos_structure_version_id in number default hr_api.g_number
553: ,p_top_position_id in number default hr_api.g_number
554: ,p_hierarchy_levels in number default hr_api.g_number
555: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
556: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
557: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
558: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
559: ,p_obj_setting_start_date in date default hr_api.g_date
552: ,p_pos_structure_version_id in number default hr_api.g_number
553: ,p_top_position_id in number default hr_api.g_number
554: ,p_hierarchy_levels in number default hr_api.g_number
555: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
556: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
557: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
558: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
559: ,p_obj_setting_start_date in date default hr_api.g_date
560: ,p_obj_setting_deadline in date default hr_api.g_date
553: ,p_top_position_id in number default hr_api.g_number
554: ,p_hierarchy_levels in number default hr_api.g_number
555: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
556: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
557: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
558: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
559: ,p_obj_setting_start_date in date default hr_api.g_date
560: ,p_obj_setting_deadline in date default hr_api.g_date
561: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
554: ,p_hierarchy_levels in number default hr_api.g_number
555: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
556: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
557: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
558: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
559: ,p_obj_setting_start_date in date default hr_api.g_date
560: ,p_obj_setting_deadline in date default hr_api.g_date
561: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
562: ,p_method_code in varchar2 default hr_api.g_varchar2
555: ,p_automatic_enrollment_flag in varchar2 default hr_api.g_varchar2
556: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
557: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
558: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
559: ,p_obj_setting_start_date in date default hr_api.g_date
560: ,p_obj_setting_deadline in date default hr_api.g_date
561: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
562: ,p_method_code in varchar2 default hr_api.g_varchar2
563: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
556: ,p_assignment_types_code in varchar2 default hr_api.g_varchar2
557: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
558: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
559: ,p_obj_setting_start_date in date default hr_api.g_date
560: ,p_obj_setting_deadline in date default hr_api.g_date
561: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
562: ,p_method_code in varchar2 default hr_api.g_varchar2
563: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
564: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
557: ,p_primary_asg_only_flag in varchar2 default hr_api.g_varchar2
558: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
559: ,p_obj_setting_start_date in date default hr_api.g_date
560: ,p_obj_setting_deadline in date default hr_api.g_date
561: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
562: ,p_method_code in varchar2 default hr_api.g_varchar2
563: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
564: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
565: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
558: ,p_include_obj_setting_flag in varchar2 default hr_api.g_varchar2
559: ,p_obj_setting_start_date in date default hr_api.g_date
560: ,p_obj_setting_deadline in date default hr_api.g_date
561: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
562: ,p_method_code in varchar2 default hr_api.g_varchar2
563: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
564: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
565: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
566: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
559: ,p_obj_setting_start_date in date default hr_api.g_date
560: ,p_obj_setting_deadline in date default hr_api.g_date
561: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
562: ,p_method_code in varchar2 default hr_api.g_varchar2
563: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
564: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
565: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
566: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
567: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
560: ,p_obj_setting_deadline in date default hr_api.g_date
561: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
562: ,p_method_code in varchar2 default hr_api.g_varchar2
563: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
564: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
565: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
566: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
567: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
568: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
561: ,p_obj_set_outside_period_flag in varchar2 default hr_api.g_varchar2
562: ,p_method_code in varchar2 default hr_api.g_varchar2
563: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
564: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
565: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
566: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
567: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
568: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
569: ,p_attribute_category in varchar2 default hr_api.g_varchar2
562: ,p_method_code in varchar2 default hr_api.g_varchar2
563: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
564: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
565: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
566: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
567: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
568: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
569: ,p_attribute_category in varchar2 default hr_api.g_varchar2
570: ,p_attribute1 in varchar2 default hr_api.g_varchar2
563: ,p_notify_population_flag in varchar2 default hr_api.g_varchar2
564: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
565: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
566: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
567: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
568: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
569: ,p_attribute_category in varchar2 default hr_api.g_varchar2
570: ,p_attribute1 in varchar2 default hr_api.g_varchar2
571: ,p_attribute2 in varchar2 default hr_api.g_varchar2
564: ,p_automatic_allocation_flag in varchar2 default hr_api.g_varchar2
565: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
566: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
567: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
568: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
569: ,p_attribute_category in varchar2 default hr_api.g_varchar2
570: ,p_attribute1 in varchar2 default hr_api.g_varchar2
571: ,p_attribute2 in varchar2 default hr_api.g_varchar2
572: ,p_attribute3 in varchar2 default hr_api.g_varchar2
565: ,p_copy_past_objectives_flag in varchar2 default hr_api.g_varchar2
566: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
567: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
568: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
569: ,p_attribute_category in varchar2 default hr_api.g_varchar2
570: ,p_attribute1 in varchar2 default hr_api.g_varchar2
571: ,p_attribute2 in varchar2 default hr_api.g_varchar2
572: ,p_attribute3 in varchar2 default hr_api.g_varchar2
573: ,p_attribute4 in varchar2 default hr_api.g_varchar2
566: ,p_sharing_alignment_task_flag in varchar2 default hr_api.g_varchar2
567: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
568: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
569: ,p_attribute_category in varchar2 default hr_api.g_varchar2
570: ,p_attribute1 in varchar2 default hr_api.g_varchar2
571: ,p_attribute2 in varchar2 default hr_api.g_varchar2
572: ,p_attribute3 in varchar2 default hr_api.g_varchar2
573: ,p_attribute4 in varchar2 default hr_api.g_varchar2
574: ,p_attribute5 in varchar2 default hr_api.g_varchar2
567: ,p_include_appraisals_flag in varchar2 default hr_api.g_varchar2
568: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
569: ,p_attribute_category in varchar2 default hr_api.g_varchar2
570: ,p_attribute1 in varchar2 default hr_api.g_varchar2
571: ,p_attribute2 in varchar2 default hr_api.g_varchar2
572: ,p_attribute3 in varchar2 default hr_api.g_varchar2
573: ,p_attribute4 in varchar2 default hr_api.g_varchar2
574: ,p_attribute5 in varchar2 default hr_api.g_varchar2
575: ,p_attribute6 in varchar2 default hr_api.g_varchar2
568: ,p_change_sc_status_flag in varchar2 default hr_api.g_varchar2
569: ,p_attribute_category in varchar2 default hr_api.g_varchar2
570: ,p_attribute1 in varchar2 default hr_api.g_varchar2
571: ,p_attribute2 in varchar2 default hr_api.g_varchar2
572: ,p_attribute3 in varchar2 default hr_api.g_varchar2
573: ,p_attribute4 in varchar2 default hr_api.g_varchar2
574: ,p_attribute5 in varchar2 default hr_api.g_varchar2
575: ,p_attribute6 in varchar2 default hr_api.g_varchar2
576: ,p_attribute7 in varchar2 default hr_api.g_varchar2
569: ,p_attribute_category in varchar2 default hr_api.g_varchar2
570: ,p_attribute1 in varchar2 default hr_api.g_varchar2
571: ,p_attribute2 in varchar2 default hr_api.g_varchar2
572: ,p_attribute3 in varchar2 default hr_api.g_varchar2
573: ,p_attribute4 in varchar2 default hr_api.g_varchar2
574: ,p_attribute5 in varchar2 default hr_api.g_varchar2
575: ,p_attribute6 in varchar2 default hr_api.g_varchar2
576: ,p_attribute7 in varchar2 default hr_api.g_varchar2
577: ,p_attribute8 in varchar2 default hr_api.g_varchar2
570: ,p_attribute1 in varchar2 default hr_api.g_varchar2
571: ,p_attribute2 in varchar2 default hr_api.g_varchar2
572: ,p_attribute3 in varchar2 default hr_api.g_varchar2
573: ,p_attribute4 in varchar2 default hr_api.g_varchar2
574: ,p_attribute5 in varchar2 default hr_api.g_varchar2
575: ,p_attribute6 in varchar2 default hr_api.g_varchar2
576: ,p_attribute7 in varchar2 default hr_api.g_varchar2
577: ,p_attribute8 in varchar2 default hr_api.g_varchar2
578: ,p_attribute9 in varchar2 default hr_api.g_varchar2
571: ,p_attribute2 in varchar2 default hr_api.g_varchar2
572: ,p_attribute3 in varchar2 default hr_api.g_varchar2
573: ,p_attribute4 in varchar2 default hr_api.g_varchar2
574: ,p_attribute5 in varchar2 default hr_api.g_varchar2
575: ,p_attribute6 in varchar2 default hr_api.g_varchar2
576: ,p_attribute7 in varchar2 default hr_api.g_varchar2
577: ,p_attribute8 in varchar2 default hr_api.g_varchar2
578: ,p_attribute9 in varchar2 default hr_api.g_varchar2
579: ,p_attribute10 in varchar2 default hr_api.g_varchar2
572: ,p_attribute3 in varchar2 default hr_api.g_varchar2
573: ,p_attribute4 in varchar2 default hr_api.g_varchar2
574: ,p_attribute5 in varchar2 default hr_api.g_varchar2
575: ,p_attribute6 in varchar2 default hr_api.g_varchar2
576: ,p_attribute7 in varchar2 default hr_api.g_varchar2
577: ,p_attribute8 in varchar2 default hr_api.g_varchar2
578: ,p_attribute9 in varchar2 default hr_api.g_varchar2
579: ,p_attribute10 in varchar2 default hr_api.g_varchar2
580: ,p_attribute11 in varchar2 default hr_api.g_varchar2
573: ,p_attribute4 in varchar2 default hr_api.g_varchar2
574: ,p_attribute5 in varchar2 default hr_api.g_varchar2
575: ,p_attribute6 in varchar2 default hr_api.g_varchar2
576: ,p_attribute7 in varchar2 default hr_api.g_varchar2
577: ,p_attribute8 in varchar2 default hr_api.g_varchar2
578: ,p_attribute9 in varchar2 default hr_api.g_varchar2
579: ,p_attribute10 in varchar2 default hr_api.g_varchar2
580: ,p_attribute11 in varchar2 default hr_api.g_varchar2
581: ,p_attribute12 in varchar2 default hr_api.g_varchar2
574: ,p_attribute5 in varchar2 default hr_api.g_varchar2
575: ,p_attribute6 in varchar2 default hr_api.g_varchar2
576: ,p_attribute7 in varchar2 default hr_api.g_varchar2
577: ,p_attribute8 in varchar2 default hr_api.g_varchar2
578: ,p_attribute9 in varchar2 default hr_api.g_varchar2
579: ,p_attribute10 in varchar2 default hr_api.g_varchar2
580: ,p_attribute11 in varchar2 default hr_api.g_varchar2
581: ,p_attribute12 in varchar2 default hr_api.g_varchar2
582: ,p_attribute13 in varchar2 default hr_api.g_varchar2
575: ,p_attribute6 in varchar2 default hr_api.g_varchar2
576: ,p_attribute7 in varchar2 default hr_api.g_varchar2
577: ,p_attribute8 in varchar2 default hr_api.g_varchar2
578: ,p_attribute9 in varchar2 default hr_api.g_varchar2
579: ,p_attribute10 in varchar2 default hr_api.g_varchar2
580: ,p_attribute11 in varchar2 default hr_api.g_varchar2
581: ,p_attribute12 in varchar2 default hr_api.g_varchar2
582: ,p_attribute13 in varchar2 default hr_api.g_varchar2
583: ,p_attribute14 in varchar2 default hr_api.g_varchar2
576: ,p_attribute7 in varchar2 default hr_api.g_varchar2
577: ,p_attribute8 in varchar2 default hr_api.g_varchar2
578: ,p_attribute9 in varchar2 default hr_api.g_varchar2
579: ,p_attribute10 in varchar2 default hr_api.g_varchar2
580: ,p_attribute11 in varchar2 default hr_api.g_varchar2
581: ,p_attribute12 in varchar2 default hr_api.g_varchar2
582: ,p_attribute13 in varchar2 default hr_api.g_varchar2
583: ,p_attribute14 in varchar2 default hr_api.g_varchar2
584: ,p_attribute15 in varchar2 default hr_api.g_varchar2
577: ,p_attribute8 in varchar2 default hr_api.g_varchar2
578: ,p_attribute9 in varchar2 default hr_api.g_varchar2
579: ,p_attribute10 in varchar2 default hr_api.g_varchar2
580: ,p_attribute11 in varchar2 default hr_api.g_varchar2
581: ,p_attribute12 in varchar2 default hr_api.g_varchar2
582: ,p_attribute13 in varchar2 default hr_api.g_varchar2
583: ,p_attribute14 in varchar2 default hr_api.g_varchar2
584: ,p_attribute15 in varchar2 default hr_api.g_varchar2
585: ,p_attribute16 in varchar2 default hr_api.g_varchar2
578: ,p_attribute9 in varchar2 default hr_api.g_varchar2
579: ,p_attribute10 in varchar2 default hr_api.g_varchar2
580: ,p_attribute11 in varchar2 default hr_api.g_varchar2
581: ,p_attribute12 in varchar2 default hr_api.g_varchar2
582: ,p_attribute13 in varchar2 default hr_api.g_varchar2
583: ,p_attribute14 in varchar2 default hr_api.g_varchar2
584: ,p_attribute15 in varchar2 default hr_api.g_varchar2
585: ,p_attribute16 in varchar2 default hr_api.g_varchar2
586: ,p_attribute17 in varchar2 default hr_api.g_varchar2
579: ,p_attribute10 in varchar2 default hr_api.g_varchar2
580: ,p_attribute11 in varchar2 default hr_api.g_varchar2
581: ,p_attribute12 in varchar2 default hr_api.g_varchar2
582: ,p_attribute13 in varchar2 default hr_api.g_varchar2
583: ,p_attribute14 in varchar2 default hr_api.g_varchar2
584: ,p_attribute15 in varchar2 default hr_api.g_varchar2
585: ,p_attribute16 in varchar2 default hr_api.g_varchar2
586: ,p_attribute17 in varchar2 default hr_api.g_varchar2
587: ,p_attribute18 in varchar2 default hr_api.g_varchar2
580: ,p_attribute11 in varchar2 default hr_api.g_varchar2
581: ,p_attribute12 in varchar2 default hr_api.g_varchar2
582: ,p_attribute13 in varchar2 default hr_api.g_varchar2
583: ,p_attribute14 in varchar2 default hr_api.g_varchar2
584: ,p_attribute15 in varchar2 default hr_api.g_varchar2
585: ,p_attribute16 in varchar2 default hr_api.g_varchar2
586: ,p_attribute17 in varchar2 default hr_api.g_varchar2
587: ,p_attribute18 in varchar2 default hr_api.g_varchar2
588: ,p_attribute19 in varchar2 default hr_api.g_varchar2
581: ,p_attribute12 in varchar2 default hr_api.g_varchar2
582: ,p_attribute13 in varchar2 default hr_api.g_varchar2
583: ,p_attribute14 in varchar2 default hr_api.g_varchar2
584: ,p_attribute15 in varchar2 default hr_api.g_varchar2
585: ,p_attribute16 in varchar2 default hr_api.g_varchar2
586: ,p_attribute17 in varchar2 default hr_api.g_varchar2
587: ,p_attribute18 in varchar2 default hr_api.g_varchar2
588: ,p_attribute19 in varchar2 default hr_api.g_varchar2
589: ,p_attribute20 in varchar2 default hr_api.g_varchar2
582: ,p_attribute13 in varchar2 default hr_api.g_varchar2
583: ,p_attribute14 in varchar2 default hr_api.g_varchar2
584: ,p_attribute15 in varchar2 default hr_api.g_varchar2
585: ,p_attribute16 in varchar2 default hr_api.g_varchar2
586: ,p_attribute17 in varchar2 default hr_api.g_varchar2
587: ,p_attribute18 in varchar2 default hr_api.g_varchar2
588: ,p_attribute19 in varchar2 default hr_api.g_varchar2
589: ,p_attribute20 in varchar2 default hr_api.g_varchar2
590: ,p_attribute21 in varchar2 default hr_api.g_varchar2
583: ,p_attribute14 in varchar2 default hr_api.g_varchar2
584: ,p_attribute15 in varchar2 default hr_api.g_varchar2
585: ,p_attribute16 in varchar2 default hr_api.g_varchar2
586: ,p_attribute17 in varchar2 default hr_api.g_varchar2
587: ,p_attribute18 in varchar2 default hr_api.g_varchar2
588: ,p_attribute19 in varchar2 default hr_api.g_varchar2
589: ,p_attribute20 in varchar2 default hr_api.g_varchar2
590: ,p_attribute21 in varchar2 default hr_api.g_varchar2
591: ,p_attribute22 in varchar2 default hr_api.g_varchar2
584: ,p_attribute15 in varchar2 default hr_api.g_varchar2
585: ,p_attribute16 in varchar2 default hr_api.g_varchar2
586: ,p_attribute17 in varchar2 default hr_api.g_varchar2
587: ,p_attribute18 in varchar2 default hr_api.g_varchar2
588: ,p_attribute19 in varchar2 default hr_api.g_varchar2
589: ,p_attribute20 in varchar2 default hr_api.g_varchar2
590: ,p_attribute21 in varchar2 default hr_api.g_varchar2
591: ,p_attribute22 in varchar2 default hr_api.g_varchar2
592: ,p_attribute23 in varchar2 default hr_api.g_varchar2
585: ,p_attribute16 in varchar2 default hr_api.g_varchar2
586: ,p_attribute17 in varchar2 default hr_api.g_varchar2
587: ,p_attribute18 in varchar2 default hr_api.g_varchar2
588: ,p_attribute19 in varchar2 default hr_api.g_varchar2
589: ,p_attribute20 in varchar2 default hr_api.g_varchar2
590: ,p_attribute21 in varchar2 default hr_api.g_varchar2
591: ,p_attribute22 in varchar2 default hr_api.g_varchar2
592: ,p_attribute23 in varchar2 default hr_api.g_varchar2
593: ,p_attribute24 in varchar2 default hr_api.g_varchar2
586: ,p_attribute17 in varchar2 default hr_api.g_varchar2
587: ,p_attribute18 in varchar2 default hr_api.g_varchar2
588: ,p_attribute19 in varchar2 default hr_api.g_varchar2
589: ,p_attribute20 in varchar2 default hr_api.g_varchar2
590: ,p_attribute21 in varchar2 default hr_api.g_varchar2
591: ,p_attribute22 in varchar2 default hr_api.g_varchar2
592: ,p_attribute23 in varchar2 default hr_api.g_varchar2
593: ,p_attribute24 in varchar2 default hr_api.g_varchar2
594: ,p_attribute25 in varchar2 default hr_api.g_varchar2
587: ,p_attribute18 in varchar2 default hr_api.g_varchar2
588: ,p_attribute19 in varchar2 default hr_api.g_varchar2
589: ,p_attribute20 in varchar2 default hr_api.g_varchar2
590: ,p_attribute21 in varchar2 default hr_api.g_varchar2
591: ,p_attribute22 in varchar2 default hr_api.g_varchar2
592: ,p_attribute23 in varchar2 default hr_api.g_varchar2
593: ,p_attribute24 in varchar2 default hr_api.g_varchar2
594: ,p_attribute25 in varchar2 default hr_api.g_varchar2
595: ,p_attribute26 in varchar2 default hr_api.g_varchar2
588: ,p_attribute19 in varchar2 default hr_api.g_varchar2
589: ,p_attribute20 in varchar2 default hr_api.g_varchar2
590: ,p_attribute21 in varchar2 default hr_api.g_varchar2
591: ,p_attribute22 in varchar2 default hr_api.g_varchar2
592: ,p_attribute23 in varchar2 default hr_api.g_varchar2
593: ,p_attribute24 in varchar2 default hr_api.g_varchar2
594: ,p_attribute25 in varchar2 default hr_api.g_varchar2
595: ,p_attribute26 in varchar2 default hr_api.g_varchar2
596: ,p_attribute27 in varchar2 default hr_api.g_varchar2
589: ,p_attribute20 in varchar2 default hr_api.g_varchar2
590: ,p_attribute21 in varchar2 default hr_api.g_varchar2
591: ,p_attribute22 in varchar2 default hr_api.g_varchar2
592: ,p_attribute23 in varchar2 default hr_api.g_varchar2
593: ,p_attribute24 in varchar2 default hr_api.g_varchar2
594: ,p_attribute25 in varchar2 default hr_api.g_varchar2
595: ,p_attribute26 in varchar2 default hr_api.g_varchar2
596: ,p_attribute27 in varchar2 default hr_api.g_varchar2
597: ,p_attribute28 in varchar2 default hr_api.g_varchar2
590: ,p_attribute21 in varchar2 default hr_api.g_varchar2
591: ,p_attribute22 in varchar2 default hr_api.g_varchar2
592: ,p_attribute23 in varchar2 default hr_api.g_varchar2
593: ,p_attribute24 in varchar2 default hr_api.g_varchar2
594: ,p_attribute25 in varchar2 default hr_api.g_varchar2
595: ,p_attribute26 in varchar2 default hr_api.g_varchar2
596: ,p_attribute27 in varchar2 default hr_api.g_varchar2
597: ,p_attribute28 in varchar2 default hr_api.g_varchar2
598: ,p_attribute29 in varchar2 default hr_api.g_varchar2
591: ,p_attribute22 in varchar2 default hr_api.g_varchar2
592: ,p_attribute23 in varchar2 default hr_api.g_varchar2
593: ,p_attribute24 in varchar2 default hr_api.g_varchar2
594: ,p_attribute25 in varchar2 default hr_api.g_varchar2
595: ,p_attribute26 in varchar2 default hr_api.g_varchar2
596: ,p_attribute27 in varchar2 default hr_api.g_varchar2
597: ,p_attribute28 in varchar2 default hr_api.g_varchar2
598: ,p_attribute29 in varchar2 default hr_api.g_varchar2
599: ,p_attribute30 in varchar2 default hr_api.g_varchar2
592: ,p_attribute23 in varchar2 default hr_api.g_varchar2
593: ,p_attribute24 in varchar2 default hr_api.g_varchar2
594: ,p_attribute25 in varchar2 default hr_api.g_varchar2
595: ,p_attribute26 in varchar2 default hr_api.g_varchar2
596: ,p_attribute27 in varchar2 default hr_api.g_varchar2
597: ,p_attribute28 in varchar2 default hr_api.g_varchar2
598: ,p_attribute29 in varchar2 default hr_api.g_varchar2
599: ,p_attribute30 in varchar2 default hr_api.g_varchar2
600: ,p_object_version_number in out nocopy number
593: ,p_attribute24 in varchar2 default hr_api.g_varchar2
594: ,p_attribute25 in varchar2 default hr_api.g_varchar2
595: ,p_attribute26 in varchar2 default hr_api.g_varchar2
596: ,p_attribute27 in varchar2 default hr_api.g_varchar2
597: ,p_attribute28 in varchar2 default hr_api.g_varchar2
598: ,p_attribute29 in varchar2 default hr_api.g_varchar2
599: ,p_attribute30 in varchar2 default hr_api.g_varchar2
600: ,p_object_version_number in out nocopy number
601: ,p_status_code out nocopy varchar2
594: ,p_attribute25 in varchar2 default hr_api.g_varchar2
595: ,p_attribute26 in varchar2 default hr_api.g_varchar2
596: ,p_attribute27 in varchar2 default hr_api.g_varchar2
597: ,p_attribute28 in varchar2 default hr_api.g_varchar2
598: ,p_attribute29 in varchar2 default hr_api.g_varchar2
599: ,p_attribute30 in varchar2 default hr_api.g_varchar2
600: ,p_object_version_number in out nocopy number
601: ,p_status_code out nocopy varchar2
602: ,p_duplicate_name_warning out nocopy boolean
595: ,p_attribute26 in varchar2 default hr_api.g_varchar2
596: ,p_attribute27 in varchar2 default hr_api.g_varchar2
597: ,p_attribute28 in varchar2 default hr_api.g_varchar2
598: ,p_attribute29 in varchar2 default hr_api.g_varchar2
599: ,p_attribute30 in varchar2 default hr_api.g_varchar2
600: ,p_object_version_number in out nocopy number
601: ,p_status_code out nocopy varchar2
602: ,p_duplicate_name_warning out nocopy boolean
603: ,p_no_life_events_warning out nocopy boolean
600: ,p_object_version_number in out nocopy number
601: ,p_status_code out nocopy varchar2
602: ,p_duplicate_name_warning out nocopy boolean
603: ,p_no_life_events_warning out nocopy boolean
604: ,p_update_library_objectives in varchar2 default hr_api.g_varchar2 -- 8740021 bug fix
605: ,p_automatic_approval_flag in varchar2 default hr_api.g_varchar2
606: ) is
607:
608: --
601: ,p_status_code out nocopy varchar2
602: ,p_duplicate_name_warning out nocopy boolean
603: ,p_no_life_events_warning out nocopy boolean
604: ,p_update_library_objectives in varchar2 default hr_api.g_varchar2 -- 8740021 bug fix
605: ,p_automatic_approval_flag in varchar2 default hr_api.g_varchar2
606: ) is
607:
608: --
609: -- Declare cursors and local variables
795: ,p_automatic_approval_flag => p_automatic_approval_flag
796: );
797:
798: exception
799: when hr_api.cannot_find_prog_unit then
800: hr_api.cannot_find_prog_unit_error
801: (p_module_name => 'UPDATE_PERF_MGMT_PLAN',
802: p_hook_type => 'BP'
803: );
796: );
797:
798: exception
799: when hr_api.cannot_find_prog_unit then
800: hr_api.cannot_find_prog_unit_error
801: (p_module_name => 'UPDATE_PERF_MGMT_PLAN',
802: p_hook_type => 'BP'
803: );
804:
967: ,p_update_library_objectives => p_update_library_objectives -- 8740021 bug fix
968: ,p_automatic_approval_flag => p_automatic_approval_flag
969: );
970: exception
971: when hr_api.cannot_find_prog_unit then
972: hr_api.cannot_find_prog_unit_error
973: (p_module_name => 'UPDATE_PERF_MGMT_PLAN',
974: p_hook_type => 'AP'
975: );
968: ,p_automatic_approval_flag => p_automatic_approval_flag
969: );
970: exception
971: when hr_api.cannot_find_prog_unit then
972: hr_api.cannot_find_prog_unit_error
973: (p_module_name => 'UPDATE_PERF_MGMT_PLAN',
974: p_hook_type => 'AP'
975: );
976: end;
982: --
983: -- When in validation only mode raise the Validate_Enabled exception
984: --
985: if p_validate then
986: raise hr_api.validate_enabled;
987: end if;
988:
989: --
990: -- Set all IN OUT and OUT parameters with out values
1028:
1029: END IF;
1030:
1031: exception
1032: when hr_api.validate_enabled then
1033: --
1034: -- As the Validate_Enabled exception has been raised
1035: -- we must rollback to the savepoint
1036: --
1118: (p_plan_id => p_plan_id
1119: ,p_object_version_number => p_object_version_number
1120: );
1121: exception
1122: when hr_api.cannot_find_prog_unit then
1123: hr_api.cannot_find_prog_unit_error
1124: (p_module_name => 'DELETE_PERF_MGMT_PLAN',
1125: p_hook_type => 'BP'
1126: );
1119: ,p_object_version_number => p_object_version_number
1120: );
1121: exception
1122: when hr_api.cannot_find_prog_unit then
1123: hr_api.cannot_find_prog_unit_error
1124: (p_module_name => 'DELETE_PERF_MGMT_PLAN',
1125: p_hook_type => 'BP'
1126: );
1127: end;
1148: (p_plan_id => p_plan_id
1149: ,p_object_version_number => p_object_version_number
1150: );
1151: exception
1152: when hr_api.cannot_find_prog_unit then
1153: hr_api.cannot_find_prog_unit_error
1154: (p_module_name => 'DELETE_PERF_MGMT_PLAN',
1155: p_hook_type => 'AP'
1156: );
1149: ,p_object_version_number => p_object_version_number
1150: );
1151: exception
1152: when hr_api.cannot_find_prog_unit then
1153: hr_api.cannot_find_prog_unit_error
1154: (p_module_name => 'DELETE_PERF_MGMT_PLAN',
1155: p_hook_type => 'AP'
1156: );
1157: end;
1160: --
1161: -- When in validation only mode raise the Validate_Enabled exception
1162: --
1163: if p_validate then
1164: raise hr_api.validate_enabled;
1165: end if;
1166:
1167: --
1168: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
1169: --
1170: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1171:
1172: exception
1173: when hr_api.validate_enabled then
1174: --
1175: -- As the Validate_Enabled exception has been raised
1176: -- we must rollback to the savepoint
1177: --
1261: ,p_plan_id => p_plan_id
1262: ,p_object_version_number => l_object_version_number
1263: );
1264: exception
1265: when hr_api.cannot_find_prog_unit then
1266: hr_api.cannot_find_prog_unit_error
1267: (p_module_name => 'PUBLISH',
1268: p_hook_type => 'BP'
1269: );
1262: ,p_object_version_number => l_object_version_number
1263: );
1264: exception
1265: when hr_api.cannot_find_prog_unit then
1266: hr_api.cannot_find_prog_unit_error
1267: (p_module_name => 'PUBLISH',
1268: p_hook_type => 'BP'
1269: );
1270: end;
1302: ,p_plan_id => p_plan_id
1303: ,p_object_version_number => l_object_version_number
1304: );
1305: exception
1306: when hr_api.cannot_find_prog_unit then
1307: hr_api.cannot_find_prog_unit_error
1308: (p_module_name => 'PUBLISH_A',
1309: p_hook_type => 'AP'
1310: );
1303: ,p_object_version_number => l_object_version_number
1304: );
1305: exception
1306: when hr_api.cannot_find_prog_unit then
1307: hr_api.cannot_find_prog_unit_error
1308: (p_module_name => 'PUBLISH_A',
1309: p_hook_type => 'AP'
1310: );
1311: end;
1314: --
1315: -- When in validation only mode raise the Validate_Enabled exception
1316: --
1317: if p_validate then
1318: raise hr_api.validate_enabled;
1319: end if;
1320:
1321: --
1322: -- Set all IN OUT and OUT parameters with out values
1328: --
1329: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1330:
1331: exception
1332: when hr_api.validate_enabled then
1333: --
1334: -- As the Validate_Enabled exception has been raised
1335: -- we must rollback to the savepoint
1336: --
1417: (p_plan_id => p_plan_id
1418: ,p_object_version_number => l_object_version_number
1419: );
1420: exception
1421: when hr_api.cannot_find_prog_unit then
1422: hr_api.cannot_find_prog_unit_error
1423: (p_module_name => 'REVERSE_PUBLISH',
1424: p_hook_type => 'BP'
1425: );
1418: ,p_object_version_number => l_object_version_number
1419: );
1420: exception
1421: when hr_api.cannot_find_prog_unit then
1422: hr_api.cannot_find_prog_unit_error
1423: (p_module_name => 'REVERSE_PUBLISH',
1424: p_hook_type => 'BP'
1425: );
1426: end;
1458: (p_plan_id => p_plan_id
1459: ,p_object_version_number => l_object_version_number
1460: );
1461: exception
1462: when hr_api.cannot_find_prog_unit then
1463: hr_api.cannot_find_prog_unit_error
1464: (p_module_name => 'REVERSE_PUBLISH_A',
1465: p_hook_type => 'AP'
1466: );
1459: ,p_object_version_number => l_object_version_number
1460: );
1461: exception
1462: when hr_api.cannot_find_prog_unit then
1463: hr_api.cannot_find_prog_unit_error
1464: (p_module_name => 'REVERSE_PUBLISH_A',
1465: p_hook_type => 'AP'
1466: );
1467: end;
1470: --
1471: -- When in validation only mode raise the Validate_Enabled exception
1472: --
1473: if p_validate then
1474: raise hr_api.validate_enabled;
1475: end if;
1476:
1477: --
1478: -- Set all IN OUT and OUT parameters with out values
1484: --
1485: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1486:
1487: exception
1488: when hr_api.validate_enabled then
1489: --
1490: -- As the Validate_Enabled exception has been raised
1491: -- we must rollback to the savepoint
1492: --