174: p_retention_potential => p_retention_potential,
175: p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
176: );
177: exception
178: when hr_api.cannot_find_prog_unit then
179: hr_api.cannot_find_prog_unit_error
180: (p_module_name => 'create_appraisal',
181: p_hook_type => 'BP'
182: );
175: p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
176: );
177: exception
178: when hr_api.cannot_find_prog_unit then
179: hr_api.cannot_find_prog_unit_error
180: (p_module_name => 'create_appraisal',
181: p_hook_type => 'BP'
182: );
183: end;
343: p_retention_potential => p_retention_potential,
344: p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
345: );
346: exception
347: when hr_api.cannot_find_prog_unit then
348: hr_api.cannot_find_prog_unit_error
349: (p_module_name => 'create_appraisal',
350: p_hook_type => 'AP'
351: );
344: p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
345: );
346: exception
347: when hr_api.cannot_find_prog_unit then
348: hr_api.cannot_find_prog_unit_error
349: (p_module_name => 'create_appraisal',
350: p_hook_type => 'AP'
351: );
352: end;
354: --
355: -- When in validation only mode raise the Validate_Enabled exception
356: --
357: if p_validate then
358: raise hr_api.validate_enabled;
359: end if;
360: --
361: -- Set all output arguments
362: --
364: p_object_version_number := l_object_version_number;
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 11);
367: exception
368: when hr_api.validate_enabled then
369: --
370: -- As the Validate_Enabled exception has been raised
371: -- we must rollback to the savepoint
372: --
520: p_effective_date in date,
521: p_appraisal_id in number,
522: p_object_version_number in out nocopy number,
523: p_appraiser_person_id in number,
524: p_appraisal_date in date default hr_api.g_date,
525: p_appraisal_period_end_date in date default hr_api.g_date,
526: p_appraisal_period_start_date in date default hr_api.g_date,
527: p_type in varchar2 default hr_api.g_varchar2,
528: p_next_appraisal_date in date default hr_api.g_date,
521: p_appraisal_id in number,
522: p_object_version_number in out nocopy number,
523: p_appraiser_person_id in number,
524: p_appraisal_date in date default hr_api.g_date,
525: p_appraisal_period_end_date in date default hr_api.g_date,
526: p_appraisal_period_start_date in date default hr_api.g_date,
527: p_type in varchar2 default hr_api.g_varchar2,
528: p_next_appraisal_date in date default hr_api.g_date,
529: p_status in varchar2 default hr_api.g_varchar2,
522: p_object_version_number in out nocopy number,
523: p_appraiser_person_id in number,
524: p_appraisal_date in date default hr_api.g_date,
525: p_appraisal_period_end_date in date default hr_api.g_date,
526: p_appraisal_period_start_date in date default hr_api.g_date,
527: p_type in varchar2 default hr_api.g_varchar2,
528: p_next_appraisal_date in date default hr_api.g_date,
529: p_status in varchar2 default hr_api.g_varchar2,
530: p_comments in varchar2 default hr_api.g_varchar2,
523: p_appraiser_person_id in number,
524: p_appraisal_date in date default hr_api.g_date,
525: p_appraisal_period_end_date in date default hr_api.g_date,
526: p_appraisal_period_start_date in date default hr_api.g_date,
527: p_type in varchar2 default hr_api.g_varchar2,
528: p_next_appraisal_date in date default hr_api.g_date,
529: p_status in varchar2 default hr_api.g_varchar2,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_overall_performance_level_id in number default hr_api.g_number,
524: p_appraisal_date in date default hr_api.g_date,
525: p_appraisal_period_end_date in date default hr_api.g_date,
526: p_appraisal_period_start_date in date default hr_api.g_date,
527: p_type in varchar2 default hr_api.g_varchar2,
528: p_next_appraisal_date in date default hr_api.g_date,
529: p_status in varchar2 default hr_api.g_varchar2,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_overall_performance_level_id in number default hr_api.g_number,
532: p_open in varchar2 default hr_api.g_varchar2,
525: p_appraisal_period_end_date in date default hr_api.g_date,
526: p_appraisal_period_start_date in date default hr_api.g_date,
527: p_type in varchar2 default hr_api.g_varchar2,
528: p_next_appraisal_date in date default hr_api.g_date,
529: p_status in varchar2 default hr_api.g_varchar2,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_overall_performance_level_id in number default hr_api.g_number,
532: p_open in varchar2 default hr_api.g_varchar2,
533: p_attribute_category in varchar2 default hr_api.g_varchar2,
526: p_appraisal_period_start_date in date default hr_api.g_date,
527: p_type in varchar2 default hr_api.g_varchar2,
528: p_next_appraisal_date in date default hr_api.g_date,
529: p_status in varchar2 default hr_api.g_varchar2,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_overall_performance_level_id in number default hr_api.g_number,
532: p_open in varchar2 default hr_api.g_varchar2,
533: p_attribute_category in varchar2 default hr_api.g_varchar2,
534: p_attribute1 in varchar2 default hr_api.g_varchar2,
527: p_type in varchar2 default hr_api.g_varchar2,
528: p_next_appraisal_date in date default hr_api.g_date,
529: p_status in varchar2 default hr_api.g_varchar2,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_overall_performance_level_id in number default hr_api.g_number,
532: p_open in varchar2 default hr_api.g_varchar2,
533: p_attribute_category in varchar2 default hr_api.g_varchar2,
534: p_attribute1 in varchar2 default hr_api.g_varchar2,
535: p_attribute2 in varchar2 default hr_api.g_varchar2,
528: p_next_appraisal_date in date default hr_api.g_date,
529: p_status in varchar2 default hr_api.g_varchar2,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_overall_performance_level_id in number default hr_api.g_number,
532: p_open in varchar2 default hr_api.g_varchar2,
533: p_attribute_category in varchar2 default hr_api.g_varchar2,
534: p_attribute1 in varchar2 default hr_api.g_varchar2,
535: p_attribute2 in varchar2 default hr_api.g_varchar2,
536: p_attribute3 in varchar2 default hr_api.g_varchar2,
529: p_status in varchar2 default hr_api.g_varchar2,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_overall_performance_level_id in number default hr_api.g_number,
532: p_open in varchar2 default hr_api.g_varchar2,
533: p_attribute_category in varchar2 default hr_api.g_varchar2,
534: p_attribute1 in varchar2 default hr_api.g_varchar2,
535: p_attribute2 in varchar2 default hr_api.g_varchar2,
536: p_attribute3 in varchar2 default hr_api.g_varchar2,
537: p_attribute4 in varchar2 default hr_api.g_varchar2,
530: p_comments in varchar2 default hr_api.g_varchar2,
531: p_overall_performance_level_id in number default hr_api.g_number,
532: p_open in varchar2 default hr_api.g_varchar2,
533: p_attribute_category in varchar2 default hr_api.g_varchar2,
534: p_attribute1 in varchar2 default hr_api.g_varchar2,
535: p_attribute2 in varchar2 default hr_api.g_varchar2,
536: p_attribute3 in varchar2 default hr_api.g_varchar2,
537: p_attribute4 in varchar2 default hr_api.g_varchar2,
538: p_attribute5 in varchar2 default hr_api.g_varchar2,
531: p_overall_performance_level_id in number default hr_api.g_number,
532: p_open in varchar2 default hr_api.g_varchar2,
533: p_attribute_category in varchar2 default hr_api.g_varchar2,
534: p_attribute1 in varchar2 default hr_api.g_varchar2,
535: p_attribute2 in varchar2 default hr_api.g_varchar2,
536: p_attribute3 in varchar2 default hr_api.g_varchar2,
537: p_attribute4 in varchar2 default hr_api.g_varchar2,
538: p_attribute5 in varchar2 default hr_api.g_varchar2,
539: p_attribute6 in varchar2 default hr_api.g_varchar2,
532: p_open in varchar2 default hr_api.g_varchar2,
533: p_attribute_category in varchar2 default hr_api.g_varchar2,
534: p_attribute1 in varchar2 default hr_api.g_varchar2,
535: p_attribute2 in varchar2 default hr_api.g_varchar2,
536: p_attribute3 in varchar2 default hr_api.g_varchar2,
537: p_attribute4 in varchar2 default hr_api.g_varchar2,
538: p_attribute5 in varchar2 default hr_api.g_varchar2,
539: p_attribute6 in varchar2 default hr_api.g_varchar2,
540: p_attribute7 in varchar2 default hr_api.g_varchar2,
533: p_attribute_category in varchar2 default hr_api.g_varchar2,
534: p_attribute1 in varchar2 default hr_api.g_varchar2,
535: p_attribute2 in varchar2 default hr_api.g_varchar2,
536: p_attribute3 in varchar2 default hr_api.g_varchar2,
537: p_attribute4 in varchar2 default hr_api.g_varchar2,
538: p_attribute5 in varchar2 default hr_api.g_varchar2,
539: p_attribute6 in varchar2 default hr_api.g_varchar2,
540: p_attribute7 in varchar2 default hr_api.g_varchar2,
541: p_attribute8 in varchar2 default hr_api.g_varchar2,
534: p_attribute1 in varchar2 default hr_api.g_varchar2,
535: p_attribute2 in varchar2 default hr_api.g_varchar2,
536: p_attribute3 in varchar2 default hr_api.g_varchar2,
537: p_attribute4 in varchar2 default hr_api.g_varchar2,
538: p_attribute5 in varchar2 default hr_api.g_varchar2,
539: p_attribute6 in varchar2 default hr_api.g_varchar2,
540: p_attribute7 in varchar2 default hr_api.g_varchar2,
541: p_attribute8 in varchar2 default hr_api.g_varchar2,
542: p_attribute9 in varchar2 default hr_api.g_varchar2,
535: p_attribute2 in varchar2 default hr_api.g_varchar2,
536: p_attribute3 in varchar2 default hr_api.g_varchar2,
537: p_attribute4 in varchar2 default hr_api.g_varchar2,
538: p_attribute5 in varchar2 default hr_api.g_varchar2,
539: p_attribute6 in varchar2 default hr_api.g_varchar2,
540: p_attribute7 in varchar2 default hr_api.g_varchar2,
541: p_attribute8 in varchar2 default hr_api.g_varchar2,
542: p_attribute9 in varchar2 default hr_api.g_varchar2,
543: p_attribute10 in varchar2 default hr_api.g_varchar2,
536: p_attribute3 in varchar2 default hr_api.g_varchar2,
537: p_attribute4 in varchar2 default hr_api.g_varchar2,
538: p_attribute5 in varchar2 default hr_api.g_varchar2,
539: p_attribute6 in varchar2 default hr_api.g_varchar2,
540: p_attribute7 in varchar2 default hr_api.g_varchar2,
541: p_attribute8 in varchar2 default hr_api.g_varchar2,
542: p_attribute9 in varchar2 default hr_api.g_varchar2,
543: p_attribute10 in varchar2 default hr_api.g_varchar2,
544: p_attribute11 in varchar2 default hr_api.g_varchar2,
537: p_attribute4 in varchar2 default hr_api.g_varchar2,
538: p_attribute5 in varchar2 default hr_api.g_varchar2,
539: p_attribute6 in varchar2 default hr_api.g_varchar2,
540: p_attribute7 in varchar2 default hr_api.g_varchar2,
541: p_attribute8 in varchar2 default hr_api.g_varchar2,
542: p_attribute9 in varchar2 default hr_api.g_varchar2,
543: p_attribute10 in varchar2 default hr_api.g_varchar2,
544: p_attribute11 in varchar2 default hr_api.g_varchar2,
545: p_attribute12 in varchar2 default hr_api.g_varchar2,
538: p_attribute5 in varchar2 default hr_api.g_varchar2,
539: p_attribute6 in varchar2 default hr_api.g_varchar2,
540: p_attribute7 in varchar2 default hr_api.g_varchar2,
541: p_attribute8 in varchar2 default hr_api.g_varchar2,
542: p_attribute9 in varchar2 default hr_api.g_varchar2,
543: p_attribute10 in varchar2 default hr_api.g_varchar2,
544: p_attribute11 in varchar2 default hr_api.g_varchar2,
545: p_attribute12 in varchar2 default hr_api.g_varchar2,
546: p_attribute13 in varchar2 default hr_api.g_varchar2,
539: p_attribute6 in varchar2 default hr_api.g_varchar2,
540: p_attribute7 in varchar2 default hr_api.g_varchar2,
541: p_attribute8 in varchar2 default hr_api.g_varchar2,
542: p_attribute9 in varchar2 default hr_api.g_varchar2,
543: p_attribute10 in varchar2 default hr_api.g_varchar2,
544: p_attribute11 in varchar2 default hr_api.g_varchar2,
545: p_attribute12 in varchar2 default hr_api.g_varchar2,
546: p_attribute13 in varchar2 default hr_api.g_varchar2,
547: p_attribute14 in varchar2 default hr_api.g_varchar2,
540: p_attribute7 in varchar2 default hr_api.g_varchar2,
541: p_attribute8 in varchar2 default hr_api.g_varchar2,
542: p_attribute9 in varchar2 default hr_api.g_varchar2,
543: p_attribute10 in varchar2 default hr_api.g_varchar2,
544: p_attribute11 in varchar2 default hr_api.g_varchar2,
545: p_attribute12 in varchar2 default hr_api.g_varchar2,
546: p_attribute13 in varchar2 default hr_api.g_varchar2,
547: p_attribute14 in varchar2 default hr_api.g_varchar2,
548: p_attribute15 in varchar2 default hr_api.g_varchar2,
541: p_attribute8 in varchar2 default hr_api.g_varchar2,
542: p_attribute9 in varchar2 default hr_api.g_varchar2,
543: p_attribute10 in varchar2 default hr_api.g_varchar2,
544: p_attribute11 in varchar2 default hr_api.g_varchar2,
545: p_attribute12 in varchar2 default hr_api.g_varchar2,
546: p_attribute13 in varchar2 default hr_api.g_varchar2,
547: p_attribute14 in varchar2 default hr_api.g_varchar2,
548: p_attribute15 in varchar2 default hr_api.g_varchar2,
549: p_attribute16 in varchar2 default hr_api.g_varchar2,
542: p_attribute9 in varchar2 default hr_api.g_varchar2,
543: p_attribute10 in varchar2 default hr_api.g_varchar2,
544: p_attribute11 in varchar2 default hr_api.g_varchar2,
545: p_attribute12 in varchar2 default hr_api.g_varchar2,
546: p_attribute13 in varchar2 default hr_api.g_varchar2,
547: p_attribute14 in varchar2 default hr_api.g_varchar2,
548: p_attribute15 in varchar2 default hr_api.g_varchar2,
549: p_attribute16 in varchar2 default hr_api.g_varchar2,
550: p_attribute17 in varchar2 default hr_api.g_varchar2,
543: p_attribute10 in varchar2 default hr_api.g_varchar2,
544: p_attribute11 in varchar2 default hr_api.g_varchar2,
545: p_attribute12 in varchar2 default hr_api.g_varchar2,
546: p_attribute13 in varchar2 default hr_api.g_varchar2,
547: p_attribute14 in varchar2 default hr_api.g_varchar2,
548: p_attribute15 in varchar2 default hr_api.g_varchar2,
549: p_attribute16 in varchar2 default hr_api.g_varchar2,
550: p_attribute17 in varchar2 default hr_api.g_varchar2,
551: p_attribute18 in varchar2 default hr_api.g_varchar2,
544: p_attribute11 in varchar2 default hr_api.g_varchar2,
545: p_attribute12 in varchar2 default hr_api.g_varchar2,
546: p_attribute13 in varchar2 default hr_api.g_varchar2,
547: p_attribute14 in varchar2 default hr_api.g_varchar2,
548: p_attribute15 in varchar2 default hr_api.g_varchar2,
549: p_attribute16 in varchar2 default hr_api.g_varchar2,
550: p_attribute17 in varchar2 default hr_api.g_varchar2,
551: p_attribute18 in varchar2 default hr_api.g_varchar2,
552: p_attribute19 in varchar2 default hr_api.g_varchar2,
545: p_attribute12 in varchar2 default hr_api.g_varchar2,
546: p_attribute13 in varchar2 default hr_api.g_varchar2,
547: p_attribute14 in varchar2 default hr_api.g_varchar2,
548: p_attribute15 in varchar2 default hr_api.g_varchar2,
549: p_attribute16 in varchar2 default hr_api.g_varchar2,
550: p_attribute17 in varchar2 default hr_api.g_varchar2,
551: p_attribute18 in varchar2 default hr_api.g_varchar2,
552: p_attribute19 in varchar2 default hr_api.g_varchar2,
553: p_attribute20 in varchar2 default hr_api.g_varchar2,
546: p_attribute13 in varchar2 default hr_api.g_varchar2,
547: p_attribute14 in varchar2 default hr_api.g_varchar2,
548: p_attribute15 in varchar2 default hr_api.g_varchar2,
549: p_attribute16 in varchar2 default hr_api.g_varchar2,
550: p_attribute17 in varchar2 default hr_api.g_varchar2,
551: p_attribute18 in varchar2 default hr_api.g_varchar2,
552: p_attribute19 in varchar2 default hr_api.g_varchar2,
553: p_attribute20 in varchar2 default hr_api.g_varchar2,
554: p_system_type in varchar2 default hr_api.g_varchar2,
547: p_attribute14 in varchar2 default hr_api.g_varchar2,
548: p_attribute15 in varchar2 default hr_api.g_varchar2,
549: p_attribute16 in varchar2 default hr_api.g_varchar2,
550: p_attribute17 in varchar2 default hr_api.g_varchar2,
551: p_attribute18 in varchar2 default hr_api.g_varchar2,
552: p_attribute19 in varchar2 default hr_api.g_varchar2,
553: p_attribute20 in varchar2 default hr_api.g_varchar2,
554: p_system_type in varchar2 default hr_api.g_varchar2,
555: p_system_params in varchar2 default hr_api.g_varchar2,
548: p_attribute15 in varchar2 default hr_api.g_varchar2,
549: p_attribute16 in varchar2 default hr_api.g_varchar2,
550: p_attribute17 in varchar2 default hr_api.g_varchar2,
551: p_attribute18 in varchar2 default hr_api.g_varchar2,
552: p_attribute19 in varchar2 default hr_api.g_varchar2,
553: p_attribute20 in varchar2 default hr_api.g_varchar2,
554: p_system_type in varchar2 default hr_api.g_varchar2,
555: p_system_params in varchar2 default hr_api.g_varchar2,
556: p_appraisee_access in varchar2 default hr_api.g_varchar2,
549: p_attribute16 in varchar2 default hr_api.g_varchar2,
550: p_attribute17 in varchar2 default hr_api.g_varchar2,
551: p_attribute18 in varchar2 default hr_api.g_varchar2,
552: p_attribute19 in varchar2 default hr_api.g_varchar2,
553: p_attribute20 in varchar2 default hr_api.g_varchar2,
554: p_system_type in varchar2 default hr_api.g_varchar2,
555: p_system_params in varchar2 default hr_api.g_varchar2,
556: p_appraisee_access in varchar2 default hr_api.g_varchar2,
557: p_main_appraiser_id in number default hr_api.g_number,
550: p_attribute17 in varchar2 default hr_api.g_varchar2,
551: p_attribute18 in varchar2 default hr_api.g_varchar2,
552: p_attribute19 in varchar2 default hr_api.g_varchar2,
553: p_attribute20 in varchar2 default hr_api.g_varchar2,
554: p_system_type in varchar2 default hr_api.g_varchar2,
555: p_system_params in varchar2 default hr_api.g_varchar2,
556: p_appraisee_access in varchar2 default hr_api.g_varchar2,
557: p_main_appraiser_id in number default hr_api.g_number,
558: p_assignment_id in number default hr_api.g_number,
551: p_attribute18 in varchar2 default hr_api.g_varchar2,
552: p_attribute19 in varchar2 default hr_api.g_varchar2,
553: p_attribute20 in varchar2 default hr_api.g_varchar2,
554: p_system_type in varchar2 default hr_api.g_varchar2,
555: p_system_params in varchar2 default hr_api.g_varchar2,
556: p_appraisee_access in varchar2 default hr_api.g_varchar2,
557: p_main_appraiser_id in number default hr_api.g_number,
558: p_assignment_id in number default hr_api.g_number,
559: p_assignment_start_date in date default hr_api.g_date,
552: p_attribute19 in varchar2 default hr_api.g_varchar2,
553: p_attribute20 in varchar2 default hr_api.g_varchar2,
554: p_system_type in varchar2 default hr_api.g_varchar2,
555: p_system_params in varchar2 default hr_api.g_varchar2,
556: p_appraisee_access in varchar2 default hr_api.g_varchar2,
557: p_main_appraiser_id in number default hr_api.g_number,
558: p_assignment_id in number default hr_api.g_number,
559: p_assignment_start_date in date default hr_api.g_date,
560: p_asg_business_group_id in number default hr_api.g_number,
553: p_attribute20 in varchar2 default hr_api.g_varchar2,
554: p_system_type in varchar2 default hr_api.g_varchar2,
555: p_system_params in varchar2 default hr_api.g_varchar2,
556: p_appraisee_access in varchar2 default hr_api.g_varchar2,
557: p_main_appraiser_id in number default hr_api.g_number,
558: p_assignment_id in number default hr_api.g_number,
559: p_assignment_start_date in date default hr_api.g_date,
560: p_asg_business_group_id in number default hr_api.g_number,
561: p_assignment_organization_id in number default hr_api.g_number,
554: p_system_type in varchar2 default hr_api.g_varchar2,
555: p_system_params in varchar2 default hr_api.g_varchar2,
556: p_appraisee_access in varchar2 default hr_api.g_varchar2,
557: p_main_appraiser_id in number default hr_api.g_number,
558: p_assignment_id in number default hr_api.g_number,
559: p_assignment_start_date in date default hr_api.g_date,
560: p_asg_business_group_id in number default hr_api.g_number,
561: p_assignment_organization_id in number default hr_api.g_number,
562: p_assignment_job_id in number default hr_api.g_number,
555: p_system_params in varchar2 default hr_api.g_varchar2,
556: p_appraisee_access in varchar2 default hr_api.g_varchar2,
557: p_main_appraiser_id in number default hr_api.g_number,
558: p_assignment_id in number default hr_api.g_number,
559: p_assignment_start_date in date default hr_api.g_date,
560: p_asg_business_group_id in number default hr_api.g_number,
561: p_assignment_organization_id in number default hr_api.g_number,
562: p_assignment_job_id in number default hr_api.g_number,
563: p_assignment_position_id in number default hr_api.g_number,
556: p_appraisee_access in varchar2 default hr_api.g_varchar2,
557: p_main_appraiser_id in number default hr_api.g_number,
558: p_assignment_id in number default hr_api.g_number,
559: p_assignment_start_date in date default hr_api.g_date,
560: p_asg_business_group_id in number default hr_api.g_number,
561: p_assignment_organization_id in number default hr_api.g_number,
562: p_assignment_job_id in number default hr_api.g_number,
563: p_assignment_position_id in number default hr_api.g_number,
564: p_assignment_grade_id in number default hr_api.g_number,
557: p_main_appraiser_id in number default hr_api.g_number,
558: p_assignment_id in number default hr_api.g_number,
559: p_assignment_start_date in date default hr_api.g_date,
560: p_asg_business_group_id in number default hr_api.g_number,
561: p_assignment_organization_id in number default hr_api.g_number,
562: p_assignment_job_id in number default hr_api.g_number,
563: p_assignment_position_id in number default hr_api.g_number,
564: p_assignment_grade_id in number default hr_api.g_number,
565: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
558: p_assignment_id in number default hr_api.g_number,
559: p_assignment_start_date in date default hr_api.g_date,
560: p_asg_business_group_id in number default hr_api.g_number,
561: p_assignment_organization_id in number default hr_api.g_number,
562: p_assignment_job_id in number default hr_api.g_number,
563: p_assignment_position_id in number default hr_api.g_number,
564: p_assignment_grade_id in number default hr_api.g_number,
565: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
566: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
559: p_assignment_start_date in date default hr_api.g_date,
560: p_asg_business_group_id in number default hr_api.g_number,
561: p_assignment_organization_id in number default hr_api.g_number,
562: p_assignment_job_id in number default hr_api.g_number,
563: p_assignment_position_id in number default hr_api.g_number,
564: p_assignment_grade_id in number default hr_api.g_number,
565: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
566: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
567: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
560: p_asg_business_group_id in number default hr_api.g_number,
561: p_assignment_organization_id in number default hr_api.g_number,
562: p_assignment_job_id in number default hr_api.g_number,
563: p_assignment_position_id in number default hr_api.g_number,
564: p_assignment_grade_id in number default hr_api.g_number,
565: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
566: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
567: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
568: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
561: p_assignment_organization_id in number default hr_api.g_number,
562: p_assignment_job_id in number default hr_api.g_number,
563: p_assignment_position_id in number default hr_api.g_number,
564: p_assignment_grade_id in number default hr_api.g_number,
565: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
566: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
567: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
568: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
569: p_potential_details in varchar2 default hr_api.g_varchar2,
562: p_assignment_job_id in number default hr_api.g_number,
563: p_assignment_position_id in number default hr_api.g_number,
564: p_assignment_grade_id in number default hr_api.g_number,
565: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
566: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
567: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
568: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
569: p_potential_details in varchar2 default hr_api.g_varchar2,
570: p_event_id in number default hr_api.g_number,
563: p_assignment_position_id in number default hr_api.g_number,
564: p_assignment_grade_id in number default hr_api.g_number,
565: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
566: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
567: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
568: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
569: p_potential_details in varchar2 default hr_api.g_varchar2,
570: p_event_id in number default hr_api.g_number,
571: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
564: p_assignment_grade_id in number default hr_api.g_number,
565: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
566: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
567: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
568: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
569: p_potential_details in varchar2 default hr_api.g_varchar2,
570: p_event_id in number default hr_api.g_number,
571: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
572: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
565: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
566: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
567: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
568: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
569: p_potential_details in varchar2 default hr_api.g_varchar2,
570: p_event_id in number default hr_api.g_number,
571: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
572: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
573: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
566: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
567: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
568: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
569: p_potential_details in varchar2 default hr_api.g_varchar2,
570: p_event_id in number default hr_api.g_number,
571: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
572: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
573: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
574: p_show_participant_details in varchar2 default hr_api.g_varchar2,
567: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
568: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
569: p_potential_details in varchar2 default hr_api.g_varchar2,
570: p_event_id in number default hr_api.g_number,
571: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
572: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
573: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
574: p_show_participant_details in varchar2 default hr_api.g_varchar2,
575: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
568: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
569: p_potential_details in varchar2 default hr_api.g_varchar2,
570: p_event_id in number default hr_api.g_number,
571: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
572: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
573: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
574: p_show_participant_details in varchar2 default hr_api.g_varchar2,
575: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
576: p_show_participant_names in varchar2 default hr_api.g_varchar2,
569: p_potential_details in varchar2 default hr_api.g_varchar2,
570: p_event_id in number default hr_api.g_number,
571: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
572: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
573: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
574: p_show_participant_details in varchar2 default hr_api.g_varchar2,
575: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
576: p_show_participant_names in varchar2 default hr_api.g_varchar2,
577: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
570: p_event_id in number default hr_api.g_number,
571: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
572: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
573: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
574: p_show_participant_details in varchar2 default hr_api.g_varchar2,
575: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
576: p_show_participant_names in varchar2 default hr_api.g_varchar2,
577: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
578: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
571: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
572: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
573: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
574: p_show_participant_details in varchar2 default hr_api.g_varchar2,
575: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
576: p_show_participant_names in varchar2 default hr_api.g_varchar2,
577: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
578: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
579: p_update_appraisal in varchar2 default hr_api.g_varchar2,
572: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
573: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
574: p_show_participant_details in varchar2 default hr_api.g_varchar2,
575: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
576: p_show_participant_names in varchar2 default hr_api.g_varchar2,
577: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
578: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
579: p_update_appraisal in varchar2 default hr_api.g_varchar2,
580: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
573: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
574: p_show_participant_details in varchar2 default hr_api.g_varchar2,
575: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
576: p_show_participant_names in varchar2 default hr_api.g_varchar2,
577: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
578: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
579: p_update_appraisal in varchar2 default hr_api.g_varchar2,
580: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
581: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
574: p_show_participant_details in varchar2 default hr_api.g_varchar2,
575: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
576: p_show_participant_names in varchar2 default hr_api.g_varchar2,
577: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
578: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
579: p_update_appraisal in varchar2 default hr_api.g_varchar2,
580: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
581: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
582: p_plan_id in number default hr_api.g_number,
575: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
576: p_show_participant_names in varchar2 default hr_api.g_varchar2,
577: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
578: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
579: p_update_appraisal in varchar2 default hr_api.g_varchar2,
580: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
581: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
582: p_plan_id in number default hr_api.g_number,
583: p_offline_status in varchar2 default hr_api.g_varchar2,
576: p_show_participant_names in varchar2 default hr_api.g_varchar2,
577: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
578: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
579: p_update_appraisal in varchar2 default hr_api.g_varchar2,
580: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
581: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
582: p_plan_id in number default hr_api.g_number,
583: p_offline_status in varchar2 default hr_api.g_varchar2,
584: p_retention_potential in varchar2 default hr_api.g_varchar2,
577: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
578: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
579: p_update_appraisal in varchar2 default hr_api.g_varchar2,
580: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
581: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
582: p_plan_id in number default hr_api.g_number,
583: p_offline_status in varchar2 default hr_api.g_varchar2,
584: p_retention_potential in varchar2 default hr_api.g_varchar2,
585: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
578: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
579: p_update_appraisal in varchar2 default hr_api.g_varchar2,
580: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
581: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
582: p_plan_id in number default hr_api.g_number,
583: p_offline_status in varchar2 default hr_api.g_varchar2,
584: p_retention_potential in varchar2 default hr_api.g_varchar2,
585: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
586: ) is
579: p_update_appraisal in varchar2 default hr_api.g_varchar2,
580: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
581: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
582: p_plan_id in number default hr_api.g_number,
583: p_offline_status in varchar2 default hr_api.g_varchar2,
584: p_retention_potential in varchar2 default hr_api.g_varchar2,
585: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
586: ) is
587: --
580: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
581: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
582: p_plan_id in number default hr_api.g_number,
583: p_offline_status in varchar2 default hr_api.g_varchar2,
584: p_retention_potential in varchar2 default hr_api.g_varchar2,
585: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
586: ) is
587: --
588: -- Declare cursors and local variables
581: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
582: p_plan_id in number default hr_api.g_number,
583: p_offline_status in varchar2 default hr_api.g_varchar2,
584: p_retention_potential in varchar2 default hr_api.g_varchar2,
585: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
586: ) is
587: --
588: -- Declare cursors and local variables
589: --
842: p_retention_potential => p_retention_potential,
843: p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
844: );
845: exception
846: when hr_api.cannot_find_prog_unit then
847: hr_api.cannot_find_prog_unit_error
848: (p_module_name => 'update_appraisal',
849: p_hook_type => 'BP'
850: );
843: p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
844: );
845: exception
846: when hr_api.cannot_find_prog_unit then
847: hr_api.cannot_find_prog_unit_error
848: (p_module_name => 'update_appraisal',
849: p_hook_type => 'BP'
850: );
851: end;
880: hr_utility.set_location('p_main_appraiser_id:'|| p_main_appraiser_id, 5);
881:
882:
883: IF l_old_mainap_id IS NOT NULL
884: AND p_main_appraiser_id <> hr_api.g_number THEN
885: IF l_old_mainap_id <> p_main_appraiser_id THEN
886: IF (l_appraisal_sys_status IN ('PLANNED','SAVED')
887: AND p_appraiser_person_id <> l_appraisee_person_id) THEN
888: l_appraiser_person_id := p_main_appraiser_id;
1086: p_retention_potential => p_retention_potential,
1087: p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
1088: );
1089: exception
1090: when hr_api.cannot_find_prog_unit then
1091: hr_api.cannot_find_prog_unit_error
1092: (p_module_name => 'update_appraisal',
1093: p_hook_type => 'AP'
1094: );
1087: p_show_participant_comments => p_show_participant_comments -- 8651478 bug fix
1088: );
1089: exception
1090: when hr_api.cannot_find_prog_unit then
1091: hr_api.cannot_find_prog_unit_error
1092: (p_module_name => 'update_appraisal',
1093: p_hook_type => 'AP'
1094: );
1095: end;
1099: --
1100: -- When in validation only mode raise the Validate_Enabled exception
1101: --
1102: if p_validate then
1103: raise hr_api.validate_enabled;
1104: end if;
1105: --
1106: -- Set all output arguments. l_object_version_number now has the new
1107: -- object version number as the update was successful
1109: p_object_version_number := l_object_version_number;
1110: --
1111: hr_utility.set_location(' Leaving:'||l_proc, 11);
1112: exception
1113: when hr_api.validate_enabled then
1114: --
1115: -- As the Validate_Enabled exception has been raised
1116: -- we must rollback to the savepoint
1117: --
1250: p_appraisal_id => p_appraisal_id,
1251: p_object_version_number => p_object_version_number
1252: );
1253: exception
1254: when hr_api.cannot_find_prog_unit then
1255: hr_api.cannot_find_prog_unit_error
1256: (p_module_name => 'delete_appraisal',
1257: p_hook_type => 'BP'
1258: );
1251: p_object_version_number => p_object_version_number
1252: );
1253: exception
1254: when hr_api.cannot_find_prog_unit then
1255: hr_api.cannot_find_prog_unit_error
1256: (p_module_name => 'delete_appraisal',
1257: p_hook_type => 'BP'
1258: );
1259: end;
1408: p_appraisal_id => p_appraisal_id,
1409: p_object_version_number => p_object_version_number
1410: );
1411: exception
1412: when hr_api.cannot_find_prog_unit then
1413: hr_api.cannot_find_prog_unit_error
1414: (p_module_name => 'delete_appraisal',
1415: p_hook_type => 'AP'
1416: );
1409: p_object_version_number => p_object_version_number
1410: );
1411: exception
1412: when hr_api.cannot_find_prog_unit then
1413: hr_api.cannot_find_prog_unit_error
1414: (p_module_name => 'delete_appraisal',
1415: p_hook_type => 'AP'
1416: );
1417: end;
1420: --
1421: -- When in validation only mode raise the Validate_Enabled exception
1422: --
1423: if p_validate then
1424: raise hr_api.validate_enabled;
1425: end if;
1426: --
1427: hr_utility.set_location(' Leaving:'||l_proc, 11);
1428: exception
1425: end if;
1426: --
1427: hr_utility.set_location(' Leaving:'||l_proc, 11);
1428: exception
1429: when hr_api.validate_enabled then
1430: --
1431: -- As the Validate_Enabled exception has been raised
1432: -- we must rollback to the savepoint
1433: --