DBA Data[Home] [Help]

APPS.HR_APPRAISALS_API dependencies on HR_API

Line 178: when hr_api.cannot_find_prog_unit then

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

Line 179: hr_api.cannot_find_prog_unit_error

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;

Line 347: when hr_api.cannot_find_prog_unit then

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

Line 348: hr_api.cannot_find_prog_unit_error

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;

Line 358: raise hr_api.validate_enabled;

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

Line 368: when hr_api.validate_enabled then

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

Line 524: p_appraisal_date in date default hr_api.g_date,

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,

Line 525: p_appraisal_period_end_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,

Line 526: p_appraisal_period_start_date in date default hr_api.g_date,

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,

Line 527: p_type 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,

Line 528: p_next_appraisal_date in date default hr_api.g_date,

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,

Line 529: p_status 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,

Line 530: p_comments 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,

Line 531: p_overall_performance_level_id in number default hr_api.g_number,

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 553: p_attribute20 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,

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

Line 555: p_system_params 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,
559: p_assignment_start_date in date default hr_api.g_date,

Line 556: p_appraisee_access 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,
560: p_asg_business_group_id in number default hr_api.g_number,

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

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

Line 559: p_assignment_start_date in date default hr_api.g_date,

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,

Line 560: p_asg_business_group_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,

Line 561: p_assignment_organization_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,

Line 562: p_assignment_job_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,
566: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,

Line 563: p_assignment_position_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,
567: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,

Line 564: p_assignment_grade_id in number default hr_api.g_number,

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,

Line 565: p_appraisal_system_status 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,

Line 566: p_potential_readiness_level 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,

Line 567: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,

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,

Line 568: p_potential_long_term_workopp 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,

Line 569: p_potential_details 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,

Line 570: p_event_id in number default hr_api.g_number,

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,

Line 571: p_show_competency_ratings 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,

Line 572: p_show_objective_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,

Line 573: p_show_questionnaire_info 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,

Line 574: p_show_participant_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,
578: p_show_overall_comments in varchar2 default hr_api.g_varchar2,

Line 575: p_show_participant_ratings 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,

Line 576: p_show_participant_names 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,

Line 577: p_show_overall_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,
581: p_appraisee_comments in varchar2 default hr_api.g_varchar2,

Line 578: p_show_overall_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,

Line 579: p_update_appraisal 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,
583: p_offline_status in varchar2 default hr_api.g_varchar2,

Line 580: p_provide_overall_feedback 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,

Line 581: p_appraisee_comments 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

Line 582: p_plan_id in number default hr_api.g_number,

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

Line 583: p_offline_status 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
587: --

Line 584: p_retention_potential 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: --
588: -- Declare cursors and local variables

Line 585: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix

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

Line 846: when hr_api.cannot_find_prog_unit then

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

Line 847: hr_api.cannot_find_prog_unit_error

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;

Line 884: AND p_main_appraiser_id <> hr_api.g_number THEN

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;

Line 1090: when hr_api.cannot_find_prog_unit then

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

Line 1091: hr_api.cannot_find_prog_unit_error

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;

Line 1103: raise hr_api.validate_enabled;

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

Line 1113: when hr_api.validate_enabled then

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

Line 1254: when hr_api.cannot_find_prog_unit then

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

Line 1255: hr_api.cannot_find_prog_unit_error

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;

Line 1412: when hr_api.cannot_find_prog_unit then

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

Line 1413: hr_api.cannot_find_prog_unit_error

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;

Line 1424: raise hr_api.validate_enabled;

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

Line 1429: when hr_api.validate_enabled then

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