eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_APPRAISALS_API dependencies on HR_API

Line 174: when hr_api.cannot_find_prog_unit then

170: p_plan_id => p_plan_id,
171: p_offline_status => p_offline_status
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'create_appraisal',
177: p_hook_type => 'BP'
178: );

Line 175: hr_api.cannot_find_prog_unit_error

171: p_offline_status => p_offline_status
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'create_appraisal',
177: p_hook_type => 'BP'
178: );
179: end;

Line 339: when hr_api.cannot_find_prog_unit then

335: p_plan_id => p_plan_id,
336: p_offline_status => p_offline_status
337: );
338: exception
339: when hr_api.cannot_find_prog_unit then
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'create_appraisal',
342: p_hook_type => 'AP'
343: );

Line 340: hr_api.cannot_find_prog_unit_error

336: p_offline_status => p_offline_status
337: );
338: exception
339: when hr_api.cannot_find_prog_unit then
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'create_appraisal',
342: p_hook_type => 'AP'
343: );
344: end;

Line 350: raise hr_api.validate_enabled;

346: --
347: -- When in validation only mode raise the Validate_Enabled exception
348: --
349: if p_validate then
350: raise hr_api.validate_enabled;
351: end if;
352: --
353: -- Set all output arguments
354: --

Line 360: when hr_api.validate_enabled then

356: p_object_version_number := l_object_version_number;
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 11);
359: exception
360: when hr_api.validate_enabled then
361: --
362: -- As the Validate_Enabled exception has been raised
363: -- we must rollback to the savepoint
364: --

Line 516: p_appraisal_date in date default hr_api.g_date,

512: p_effective_date in date,
513: p_appraisal_id in number,
514: p_object_version_number in out nocopy number,
515: p_appraiser_person_id in number,
516: p_appraisal_date in date default hr_api.g_date,
517: p_appraisal_period_end_date in date default hr_api.g_date,
518: p_appraisal_period_start_date in date default hr_api.g_date,
519: p_type in varchar2 default hr_api.g_varchar2,
520: p_next_appraisal_date in date default hr_api.g_date,

Line 517: p_appraisal_period_end_date in date default hr_api.g_date,

513: p_appraisal_id in number,
514: p_object_version_number in out nocopy number,
515: p_appraiser_person_id in number,
516: p_appraisal_date in date default hr_api.g_date,
517: p_appraisal_period_end_date in date default hr_api.g_date,
518: p_appraisal_period_start_date in date default hr_api.g_date,
519: p_type in varchar2 default hr_api.g_varchar2,
520: p_next_appraisal_date in date default hr_api.g_date,
521: p_status in varchar2 default hr_api.g_varchar2,

Line 518: p_appraisal_period_start_date in date default hr_api.g_date,

514: p_object_version_number in out nocopy number,
515: p_appraiser_person_id in number,
516: p_appraisal_date in date default hr_api.g_date,
517: p_appraisal_period_end_date in date default hr_api.g_date,
518: p_appraisal_period_start_date in date default hr_api.g_date,
519: p_type in varchar2 default hr_api.g_varchar2,
520: p_next_appraisal_date in date default hr_api.g_date,
521: p_status in varchar2 default hr_api.g_varchar2,
522: p_comments in varchar2 default hr_api.g_varchar2,

Line 519: p_type in varchar2 default hr_api.g_varchar2,

515: p_appraiser_person_id in number,
516: p_appraisal_date in date default hr_api.g_date,
517: p_appraisal_period_end_date in date default hr_api.g_date,
518: p_appraisal_period_start_date in date default hr_api.g_date,
519: p_type in varchar2 default hr_api.g_varchar2,
520: p_next_appraisal_date in date default hr_api.g_date,
521: p_status in varchar2 default hr_api.g_varchar2,
522: p_comments in varchar2 default hr_api.g_varchar2,
523: p_overall_performance_level_id in number default hr_api.g_number,

Line 520: p_next_appraisal_date in date default hr_api.g_date,

516: p_appraisal_date in date default hr_api.g_date,
517: p_appraisal_period_end_date in date default hr_api.g_date,
518: p_appraisal_period_start_date in date default hr_api.g_date,
519: p_type in varchar2 default hr_api.g_varchar2,
520: p_next_appraisal_date in date default hr_api.g_date,
521: p_status in varchar2 default hr_api.g_varchar2,
522: p_comments in varchar2 default hr_api.g_varchar2,
523: p_overall_performance_level_id in number default hr_api.g_number,
524: p_open in varchar2 default hr_api.g_varchar2,

Line 521: p_status in varchar2 default hr_api.g_varchar2,

517: p_appraisal_period_end_date in date default hr_api.g_date,
518: p_appraisal_period_start_date in date default hr_api.g_date,
519: p_type in varchar2 default hr_api.g_varchar2,
520: p_next_appraisal_date in date default hr_api.g_date,
521: p_status in varchar2 default hr_api.g_varchar2,
522: p_comments in varchar2 default hr_api.g_varchar2,
523: p_overall_performance_level_id in number default hr_api.g_number,
524: p_open in varchar2 default hr_api.g_varchar2,
525: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 522: p_comments in varchar2 default hr_api.g_varchar2,

518: p_appraisal_period_start_date in date default hr_api.g_date,
519: p_type in varchar2 default hr_api.g_varchar2,
520: p_next_appraisal_date in date default hr_api.g_date,
521: p_status in varchar2 default hr_api.g_varchar2,
522: p_comments in varchar2 default hr_api.g_varchar2,
523: p_overall_performance_level_id in number default hr_api.g_number,
524: p_open in varchar2 default hr_api.g_varchar2,
525: p_attribute_category in varchar2 default hr_api.g_varchar2,
526: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 523: p_overall_performance_level_id in number default hr_api.g_number,

519: p_type in varchar2 default hr_api.g_varchar2,
520: p_next_appraisal_date in date default hr_api.g_date,
521: p_status in varchar2 default hr_api.g_varchar2,
522: p_comments in varchar2 default hr_api.g_varchar2,
523: p_overall_performance_level_id in number default hr_api.g_number,
524: p_open in varchar2 default hr_api.g_varchar2,
525: p_attribute_category in varchar2 default hr_api.g_varchar2,
526: p_attribute1 in varchar2 default hr_api.g_varchar2,
527: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 524: p_open in varchar2 default hr_api.g_varchar2,

520: p_next_appraisal_date in date default hr_api.g_date,
521: p_status in varchar2 default hr_api.g_varchar2,
522: p_comments in varchar2 default hr_api.g_varchar2,
523: p_overall_performance_level_id in number default hr_api.g_number,
524: p_open in varchar2 default hr_api.g_varchar2,
525: p_attribute_category in varchar2 default hr_api.g_varchar2,
526: p_attribute1 in varchar2 default hr_api.g_varchar2,
527: p_attribute2 in varchar2 default hr_api.g_varchar2,
528: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 525: p_attribute_category in varchar2 default hr_api.g_varchar2,

521: p_status in varchar2 default hr_api.g_varchar2,
522: p_comments in varchar2 default hr_api.g_varchar2,
523: p_overall_performance_level_id in number default hr_api.g_number,
524: p_open in varchar2 default hr_api.g_varchar2,
525: p_attribute_category in varchar2 default hr_api.g_varchar2,
526: p_attribute1 in varchar2 default hr_api.g_varchar2,
527: p_attribute2 in varchar2 default hr_api.g_varchar2,
528: p_attribute3 in varchar2 default hr_api.g_varchar2,
529: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 526: p_attribute1 in varchar2 default hr_api.g_varchar2,

522: p_comments in varchar2 default hr_api.g_varchar2,
523: p_overall_performance_level_id in number default hr_api.g_number,
524: p_open in varchar2 default hr_api.g_varchar2,
525: p_attribute_category in varchar2 default hr_api.g_varchar2,
526: p_attribute1 in varchar2 default hr_api.g_varchar2,
527: p_attribute2 in varchar2 default hr_api.g_varchar2,
528: p_attribute3 in varchar2 default hr_api.g_varchar2,
529: p_attribute4 in varchar2 default hr_api.g_varchar2,
530: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 527: p_attribute2 in varchar2 default hr_api.g_varchar2,

523: p_overall_performance_level_id in number default hr_api.g_number,
524: p_open in varchar2 default hr_api.g_varchar2,
525: p_attribute_category in varchar2 default hr_api.g_varchar2,
526: p_attribute1 in varchar2 default hr_api.g_varchar2,
527: p_attribute2 in varchar2 default hr_api.g_varchar2,
528: p_attribute3 in varchar2 default hr_api.g_varchar2,
529: p_attribute4 in varchar2 default hr_api.g_varchar2,
530: p_attribute5 in varchar2 default hr_api.g_varchar2,
531: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 528: p_attribute3 in varchar2 default hr_api.g_varchar2,

524: p_open in varchar2 default hr_api.g_varchar2,
525: p_attribute_category in varchar2 default hr_api.g_varchar2,
526: p_attribute1 in varchar2 default hr_api.g_varchar2,
527: p_attribute2 in varchar2 default hr_api.g_varchar2,
528: p_attribute3 in varchar2 default hr_api.g_varchar2,
529: p_attribute4 in varchar2 default hr_api.g_varchar2,
530: p_attribute5 in varchar2 default hr_api.g_varchar2,
531: p_attribute6 in varchar2 default hr_api.g_varchar2,
532: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 529: p_attribute4 in varchar2 default hr_api.g_varchar2,

525: p_attribute_category in varchar2 default hr_api.g_varchar2,
526: p_attribute1 in varchar2 default hr_api.g_varchar2,
527: p_attribute2 in varchar2 default hr_api.g_varchar2,
528: p_attribute3 in varchar2 default hr_api.g_varchar2,
529: p_attribute4 in varchar2 default hr_api.g_varchar2,
530: p_attribute5 in varchar2 default hr_api.g_varchar2,
531: p_attribute6 in varchar2 default hr_api.g_varchar2,
532: p_attribute7 in varchar2 default hr_api.g_varchar2,
533: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 530: p_attribute5 in varchar2 default hr_api.g_varchar2,

526: p_attribute1 in varchar2 default hr_api.g_varchar2,
527: p_attribute2 in varchar2 default hr_api.g_varchar2,
528: p_attribute3 in varchar2 default hr_api.g_varchar2,
529: p_attribute4 in varchar2 default hr_api.g_varchar2,
530: p_attribute5 in varchar2 default hr_api.g_varchar2,
531: p_attribute6 in varchar2 default hr_api.g_varchar2,
532: p_attribute7 in varchar2 default hr_api.g_varchar2,
533: p_attribute8 in varchar2 default hr_api.g_varchar2,
534: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 531: p_attribute6 in varchar2 default hr_api.g_varchar2,

527: p_attribute2 in varchar2 default hr_api.g_varchar2,
528: p_attribute3 in varchar2 default hr_api.g_varchar2,
529: p_attribute4 in varchar2 default hr_api.g_varchar2,
530: p_attribute5 in varchar2 default hr_api.g_varchar2,
531: p_attribute6 in varchar2 default hr_api.g_varchar2,
532: p_attribute7 in varchar2 default hr_api.g_varchar2,
533: p_attribute8 in varchar2 default hr_api.g_varchar2,
534: p_attribute9 in varchar2 default hr_api.g_varchar2,
535: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 532: p_attribute7 in varchar2 default hr_api.g_varchar2,

528: p_attribute3 in varchar2 default hr_api.g_varchar2,
529: p_attribute4 in varchar2 default hr_api.g_varchar2,
530: p_attribute5 in varchar2 default hr_api.g_varchar2,
531: p_attribute6 in varchar2 default hr_api.g_varchar2,
532: p_attribute7 in varchar2 default hr_api.g_varchar2,
533: p_attribute8 in varchar2 default hr_api.g_varchar2,
534: p_attribute9 in varchar2 default hr_api.g_varchar2,
535: p_attribute10 in varchar2 default hr_api.g_varchar2,
536: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 533: p_attribute8 in varchar2 default hr_api.g_varchar2,

529: p_attribute4 in varchar2 default hr_api.g_varchar2,
530: p_attribute5 in varchar2 default hr_api.g_varchar2,
531: p_attribute6 in varchar2 default hr_api.g_varchar2,
532: p_attribute7 in varchar2 default hr_api.g_varchar2,
533: p_attribute8 in varchar2 default hr_api.g_varchar2,
534: p_attribute9 in varchar2 default hr_api.g_varchar2,
535: p_attribute10 in varchar2 default hr_api.g_varchar2,
536: p_attribute11 in varchar2 default hr_api.g_varchar2,
537: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 534: p_attribute9 in varchar2 default hr_api.g_varchar2,

530: p_attribute5 in varchar2 default hr_api.g_varchar2,
531: p_attribute6 in varchar2 default hr_api.g_varchar2,
532: p_attribute7 in varchar2 default hr_api.g_varchar2,
533: p_attribute8 in varchar2 default hr_api.g_varchar2,
534: p_attribute9 in varchar2 default hr_api.g_varchar2,
535: p_attribute10 in varchar2 default hr_api.g_varchar2,
536: p_attribute11 in varchar2 default hr_api.g_varchar2,
537: p_attribute12 in varchar2 default hr_api.g_varchar2,
538: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 535: p_attribute10 in varchar2 default hr_api.g_varchar2,

531: p_attribute6 in varchar2 default hr_api.g_varchar2,
532: p_attribute7 in varchar2 default hr_api.g_varchar2,
533: p_attribute8 in varchar2 default hr_api.g_varchar2,
534: p_attribute9 in varchar2 default hr_api.g_varchar2,
535: p_attribute10 in varchar2 default hr_api.g_varchar2,
536: p_attribute11 in varchar2 default hr_api.g_varchar2,
537: p_attribute12 in varchar2 default hr_api.g_varchar2,
538: p_attribute13 in varchar2 default hr_api.g_varchar2,
539: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 536: p_attribute11 in varchar2 default hr_api.g_varchar2,

532: p_attribute7 in varchar2 default hr_api.g_varchar2,
533: p_attribute8 in varchar2 default hr_api.g_varchar2,
534: p_attribute9 in varchar2 default hr_api.g_varchar2,
535: p_attribute10 in varchar2 default hr_api.g_varchar2,
536: p_attribute11 in varchar2 default hr_api.g_varchar2,
537: p_attribute12 in varchar2 default hr_api.g_varchar2,
538: p_attribute13 in varchar2 default hr_api.g_varchar2,
539: p_attribute14 in varchar2 default hr_api.g_varchar2,
540: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 537: p_attribute12 in varchar2 default hr_api.g_varchar2,

533: p_attribute8 in varchar2 default hr_api.g_varchar2,
534: p_attribute9 in varchar2 default hr_api.g_varchar2,
535: p_attribute10 in varchar2 default hr_api.g_varchar2,
536: p_attribute11 in varchar2 default hr_api.g_varchar2,
537: p_attribute12 in varchar2 default hr_api.g_varchar2,
538: p_attribute13 in varchar2 default hr_api.g_varchar2,
539: p_attribute14 in varchar2 default hr_api.g_varchar2,
540: p_attribute15 in varchar2 default hr_api.g_varchar2,
541: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 538: p_attribute13 in varchar2 default hr_api.g_varchar2,

534: p_attribute9 in varchar2 default hr_api.g_varchar2,
535: p_attribute10 in varchar2 default hr_api.g_varchar2,
536: p_attribute11 in varchar2 default hr_api.g_varchar2,
537: p_attribute12 in varchar2 default hr_api.g_varchar2,
538: p_attribute13 in varchar2 default hr_api.g_varchar2,
539: p_attribute14 in varchar2 default hr_api.g_varchar2,
540: p_attribute15 in varchar2 default hr_api.g_varchar2,
541: p_attribute16 in varchar2 default hr_api.g_varchar2,
542: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 539: p_attribute14 in varchar2 default hr_api.g_varchar2,

535: p_attribute10 in varchar2 default hr_api.g_varchar2,
536: p_attribute11 in varchar2 default hr_api.g_varchar2,
537: p_attribute12 in varchar2 default hr_api.g_varchar2,
538: p_attribute13 in varchar2 default hr_api.g_varchar2,
539: p_attribute14 in varchar2 default hr_api.g_varchar2,
540: p_attribute15 in varchar2 default hr_api.g_varchar2,
541: p_attribute16 in varchar2 default hr_api.g_varchar2,
542: p_attribute17 in varchar2 default hr_api.g_varchar2,
543: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 540: p_attribute15 in varchar2 default hr_api.g_varchar2,

536: p_attribute11 in varchar2 default hr_api.g_varchar2,
537: p_attribute12 in varchar2 default hr_api.g_varchar2,
538: p_attribute13 in varchar2 default hr_api.g_varchar2,
539: p_attribute14 in varchar2 default hr_api.g_varchar2,
540: p_attribute15 in varchar2 default hr_api.g_varchar2,
541: p_attribute16 in varchar2 default hr_api.g_varchar2,
542: p_attribute17 in varchar2 default hr_api.g_varchar2,
543: p_attribute18 in varchar2 default hr_api.g_varchar2,
544: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 541: p_attribute16 in varchar2 default hr_api.g_varchar2,

537: p_attribute12 in varchar2 default hr_api.g_varchar2,
538: p_attribute13 in varchar2 default hr_api.g_varchar2,
539: p_attribute14 in varchar2 default hr_api.g_varchar2,
540: p_attribute15 in varchar2 default hr_api.g_varchar2,
541: p_attribute16 in varchar2 default hr_api.g_varchar2,
542: p_attribute17 in varchar2 default hr_api.g_varchar2,
543: p_attribute18 in varchar2 default hr_api.g_varchar2,
544: p_attribute19 in varchar2 default hr_api.g_varchar2,
545: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 542: p_attribute17 in varchar2 default hr_api.g_varchar2,

538: p_attribute13 in varchar2 default hr_api.g_varchar2,
539: p_attribute14 in varchar2 default hr_api.g_varchar2,
540: p_attribute15 in varchar2 default hr_api.g_varchar2,
541: p_attribute16 in varchar2 default hr_api.g_varchar2,
542: p_attribute17 in varchar2 default hr_api.g_varchar2,
543: p_attribute18 in varchar2 default hr_api.g_varchar2,
544: p_attribute19 in varchar2 default hr_api.g_varchar2,
545: p_attribute20 in varchar2 default hr_api.g_varchar2,
546: p_system_type in varchar2 default hr_api.g_varchar2,

Line 543: p_attribute18 in varchar2 default hr_api.g_varchar2,

539: p_attribute14 in varchar2 default hr_api.g_varchar2,
540: p_attribute15 in varchar2 default hr_api.g_varchar2,
541: p_attribute16 in varchar2 default hr_api.g_varchar2,
542: p_attribute17 in varchar2 default hr_api.g_varchar2,
543: p_attribute18 in varchar2 default hr_api.g_varchar2,
544: p_attribute19 in varchar2 default hr_api.g_varchar2,
545: p_attribute20 in varchar2 default hr_api.g_varchar2,
546: p_system_type in varchar2 default hr_api.g_varchar2,
547: p_system_params in varchar2 default hr_api.g_varchar2,

Line 544: p_attribute19 in varchar2 default hr_api.g_varchar2,

540: p_attribute15 in varchar2 default hr_api.g_varchar2,
541: p_attribute16 in varchar2 default hr_api.g_varchar2,
542: p_attribute17 in varchar2 default hr_api.g_varchar2,
543: p_attribute18 in varchar2 default hr_api.g_varchar2,
544: p_attribute19 in varchar2 default hr_api.g_varchar2,
545: p_attribute20 in varchar2 default hr_api.g_varchar2,
546: p_system_type in varchar2 default hr_api.g_varchar2,
547: p_system_params in varchar2 default hr_api.g_varchar2,
548: p_appraisee_access in varchar2 default hr_api.g_varchar2,

Line 545: p_attribute20 in varchar2 default hr_api.g_varchar2,

541: p_attribute16 in varchar2 default hr_api.g_varchar2,
542: p_attribute17 in varchar2 default hr_api.g_varchar2,
543: p_attribute18 in varchar2 default hr_api.g_varchar2,
544: p_attribute19 in varchar2 default hr_api.g_varchar2,
545: p_attribute20 in varchar2 default hr_api.g_varchar2,
546: p_system_type in varchar2 default hr_api.g_varchar2,
547: p_system_params in varchar2 default hr_api.g_varchar2,
548: p_appraisee_access in varchar2 default hr_api.g_varchar2,
549: p_main_appraiser_id in number default hr_api.g_number,

Line 546: p_system_type in varchar2 default hr_api.g_varchar2,

542: p_attribute17 in varchar2 default hr_api.g_varchar2,
543: p_attribute18 in varchar2 default hr_api.g_varchar2,
544: p_attribute19 in varchar2 default hr_api.g_varchar2,
545: p_attribute20 in varchar2 default hr_api.g_varchar2,
546: p_system_type in varchar2 default hr_api.g_varchar2,
547: p_system_params in varchar2 default hr_api.g_varchar2,
548: p_appraisee_access in varchar2 default hr_api.g_varchar2,
549: p_main_appraiser_id in number default hr_api.g_number,
550: p_assignment_id in number default hr_api.g_number,

Line 547: p_system_params in varchar2 default hr_api.g_varchar2,

543: p_attribute18 in varchar2 default hr_api.g_varchar2,
544: p_attribute19 in varchar2 default hr_api.g_varchar2,
545: p_attribute20 in varchar2 default hr_api.g_varchar2,
546: p_system_type in varchar2 default hr_api.g_varchar2,
547: p_system_params in varchar2 default hr_api.g_varchar2,
548: p_appraisee_access in varchar2 default hr_api.g_varchar2,
549: p_main_appraiser_id in number default hr_api.g_number,
550: p_assignment_id in number default hr_api.g_number,
551: p_assignment_start_date in date default hr_api.g_date,

Line 548: p_appraisee_access in varchar2 default hr_api.g_varchar2,

544: p_attribute19 in varchar2 default hr_api.g_varchar2,
545: p_attribute20 in varchar2 default hr_api.g_varchar2,
546: p_system_type in varchar2 default hr_api.g_varchar2,
547: p_system_params in varchar2 default hr_api.g_varchar2,
548: p_appraisee_access in varchar2 default hr_api.g_varchar2,
549: p_main_appraiser_id in number default hr_api.g_number,
550: p_assignment_id in number default hr_api.g_number,
551: p_assignment_start_date in date default hr_api.g_date,
552: p_asg_business_group_id in number default hr_api.g_number,

Line 549: p_main_appraiser_id in number default hr_api.g_number,

545: p_attribute20 in varchar2 default hr_api.g_varchar2,
546: p_system_type in varchar2 default hr_api.g_varchar2,
547: p_system_params in varchar2 default hr_api.g_varchar2,
548: p_appraisee_access in varchar2 default hr_api.g_varchar2,
549: p_main_appraiser_id in number default hr_api.g_number,
550: p_assignment_id in number default hr_api.g_number,
551: p_assignment_start_date in date default hr_api.g_date,
552: p_asg_business_group_id in number default hr_api.g_number,
553: p_assignment_organization_id in number default hr_api.g_number,

Line 550: p_assignment_id in number default hr_api.g_number,

546: p_system_type in varchar2 default hr_api.g_varchar2,
547: p_system_params in varchar2 default hr_api.g_varchar2,
548: p_appraisee_access in varchar2 default hr_api.g_varchar2,
549: p_main_appraiser_id in number default hr_api.g_number,
550: p_assignment_id in number default hr_api.g_number,
551: p_assignment_start_date in date default hr_api.g_date,
552: p_asg_business_group_id in number default hr_api.g_number,
553: p_assignment_organization_id in number default hr_api.g_number,
554: p_assignment_job_id in number default hr_api.g_number,

Line 551: p_assignment_start_date in date default hr_api.g_date,

547: p_system_params in varchar2 default hr_api.g_varchar2,
548: p_appraisee_access in varchar2 default hr_api.g_varchar2,
549: p_main_appraiser_id in number default hr_api.g_number,
550: p_assignment_id in number default hr_api.g_number,
551: p_assignment_start_date in date default hr_api.g_date,
552: p_asg_business_group_id in number default hr_api.g_number,
553: p_assignment_organization_id in number default hr_api.g_number,
554: p_assignment_job_id in number default hr_api.g_number,
555: p_assignment_position_id in number default hr_api.g_number,

Line 552: p_asg_business_group_id in number default hr_api.g_number,

548: p_appraisee_access in varchar2 default hr_api.g_varchar2,
549: p_main_appraiser_id in number default hr_api.g_number,
550: p_assignment_id in number default hr_api.g_number,
551: p_assignment_start_date in date default hr_api.g_date,
552: p_asg_business_group_id in number default hr_api.g_number,
553: p_assignment_organization_id in number default hr_api.g_number,
554: p_assignment_job_id in number default hr_api.g_number,
555: p_assignment_position_id in number default hr_api.g_number,
556: p_assignment_grade_id in number default hr_api.g_number,

Line 553: p_assignment_organization_id in number default hr_api.g_number,

549: p_main_appraiser_id in number default hr_api.g_number,
550: p_assignment_id in number default hr_api.g_number,
551: p_assignment_start_date in date default hr_api.g_date,
552: p_asg_business_group_id in number default hr_api.g_number,
553: p_assignment_organization_id in number default hr_api.g_number,
554: p_assignment_job_id in number default hr_api.g_number,
555: p_assignment_position_id in number default hr_api.g_number,
556: p_assignment_grade_id in number default hr_api.g_number,
557: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,

Line 554: p_assignment_job_id in number default hr_api.g_number,

550: p_assignment_id in number default hr_api.g_number,
551: p_assignment_start_date in date default hr_api.g_date,
552: p_asg_business_group_id in number default hr_api.g_number,
553: p_assignment_organization_id in number default hr_api.g_number,
554: p_assignment_job_id in number default hr_api.g_number,
555: p_assignment_position_id in number default hr_api.g_number,
556: p_assignment_grade_id in number default hr_api.g_number,
557: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
558: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,

Line 555: p_assignment_position_id in number default hr_api.g_number,

551: p_assignment_start_date in date default hr_api.g_date,
552: p_asg_business_group_id in number default hr_api.g_number,
553: p_assignment_organization_id in number default hr_api.g_number,
554: p_assignment_job_id in number default hr_api.g_number,
555: p_assignment_position_id in number default hr_api.g_number,
556: p_assignment_grade_id in number default hr_api.g_number,
557: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
558: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
559: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,

Line 556: p_assignment_grade_id in number default hr_api.g_number,

552: p_asg_business_group_id in number default hr_api.g_number,
553: p_assignment_organization_id in number default hr_api.g_number,
554: p_assignment_job_id in number default hr_api.g_number,
555: p_assignment_position_id in number default hr_api.g_number,
556: p_assignment_grade_id in number default hr_api.g_number,
557: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
558: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
559: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
560: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,

Line 557: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,

553: p_assignment_organization_id in number default hr_api.g_number,
554: p_assignment_job_id in number default hr_api.g_number,
555: p_assignment_position_id in number default hr_api.g_number,
556: p_assignment_grade_id in number default hr_api.g_number,
557: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
558: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
559: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
560: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
561: p_potential_details in varchar2 default hr_api.g_varchar2,

Line 558: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,

554: p_assignment_job_id in number default hr_api.g_number,
555: p_assignment_position_id in number default hr_api.g_number,
556: p_assignment_grade_id in number default hr_api.g_number,
557: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
558: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
559: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
560: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
561: p_potential_details in varchar2 default hr_api.g_varchar2,
562: p_event_id in number default hr_api.g_number,

Line 559: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,

555: p_assignment_position_id in number default hr_api.g_number,
556: p_assignment_grade_id in number default hr_api.g_number,
557: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
558: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
559: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
560: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
561: p_potential_details in varchar2 default hr_api.g_varchar2,
562: p_event_id in number default hr_api.g_number,
563: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,

Line 560: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,

556: p_assignment_grade_id in number default hr_api.g_number,
557: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
558: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
559: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
560: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
561: p_potential_details in varchar2 default hr_api.g_varchar2,
562: p_event_id in number default hr_api.g_number,
563: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
564: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,

Line 561: p_potential_details in varchar2 default hr_api.g_varchar2,

557: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
558: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
559: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
560: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
561: p_potential_details in varchar2 default hr_api.g_varchar2,
562: p_event_id in number default hr_api.g_number,
563: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
564: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
565: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,

Line 562: p_event_id in number default hr_api.g_number,

558: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
559: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
560: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
561: p_potential_details in varchar2 default hr_api.g_varchar2,
562: p_event_id in number default hr_api.g_number,
563: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
564: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
565: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
566: p_show_participant_details in varchar2 default hr_api.g_varchar2,

Line 563: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,

559: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
560: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
561: p_potential_details in varchar2 default hr_api.g_varchar2,
562: p_event_id in number default hr_api.g_number,
563: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
564: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
565: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
566: p_show_participant_details in varchar2 default hr_api.g_varchar2,
567: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,

Line 564: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,

560: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
561: p_potential_details in varchar2 default hr_api.g_varchar2,
562: p_event_id in number default hr_api.g_number,
563: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
564: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
565: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
566: p_show_participant_details in varchar2 default hr_api.g_varchar2,
567: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
568: p_show_participant_names in varchar2 default hr_api.g_varchar2,

Line 565: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,

561: p_potential_details in varchar2 default hr_api.g_varchar2,
562: p_event_id in number default hr_api.g_number,
563: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
564: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
565: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
566: p_show_participant_details in varchar2 default hr_api.g_varchar2,
567: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
568: p_show_participant_names in varchar2 default hr_api.g_varchar2,
569: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,

Line 566: p_show_participant_details in varchar2 default hr_api.g_varchar2,

562: p_event_id in number default hr_api.g_number,
563: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
564: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
565: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
566: p_show_participant_details in varchar2 default hr_api.g_varchar2,
567: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
568: p_show_participant_names in varchar2 default hr_api.g_varchar2,
569: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
570: p_show_overall_comments in varchar2 default hr_api.g_varchar2,

Line 567: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,

563: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
564: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
565: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
566: p_show_participant_details in varchar2 default hr_api.g_varchar2,
567: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
568: p_show_participant_names in varchar2 default hr_api.g_varchar2,
569: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
570: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
571: p_update_appraisal in varchar2 default hr_api.g_varchar2,

Line 568: p_show_participant_names in varchar2 default hr_api.g_varchar2,

564: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
565: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
566: p_show_participant_details in varchar2 default hr_api.g_varchar2,
567: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
568: p_show_participant_names in varchar2 default hr_api.g_varchar2,
569: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
570: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
571: p_update_appraisal in varchar2 default hr_api.g_varchar2,
572: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,

Line 569: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,

565: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
566: p_show_participant_details in varchar2 default hr_api.g_varchar2,
567: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
568: p_show_participant_names in varchar2 default hr_api.g_varchar2,
569: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
570: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
571: p_update_appraisal in varchar2 default hr_api.g_varchar2,
572: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
573: p_appraisee_comments in varchar2 default hr_api.g_varchar2,

Line 570: p_show_overall_comments in varchar2 default hr_api.g_varchar2,

566: p_show_participant_details in varchar2 default hr_api.g_varchar2,
567: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
568: p_show_participant_names in varchar2 default hr_api.g_varchar2,
569: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
570: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
571: p_update_appraisal in varchar2 default hr_api.g_varchar2,
572: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
573: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
574: p_plan_id in number default hr_api.g_number,

Line 571: p_update_appraisal in varchar2 default hr_api.g_varchar2,

567: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
568: p_show_participant_names in varchar2 default hr_api.g_varchar2,
569: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
570: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
571: p_update_appraisal in varchar2 default hr_api.g_varchar2,
572: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
573: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
574: p_plan_id in number default hr_api.g_number,
575: p_offline_status in varchar2 default hr_api.g_varchar2

Line 572: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,

568: p_show_participant_names in varchar2 default hr_api.g_varchar2,
569: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
570: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
571: p_update_appraisal in varchar2 default hr_api.g_varchar2,
572: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
573: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
574: p_plan_id in number default hr_api.g_number,
575: p_offline_status in varchar2 default hr_api.g_varchar2
576: ) is

Line 573: p_appraisee_comments in varchar2 default hr_api.g_varchar2,

569: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
570: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
571: p_update_appraisal in varchar2 default hr_api.g_varchar2,
572: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
573: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
574: p_plan_id in number default hr_api.g_number,
575: p_offline_status in varchar2 default hr_api.g_varchar2
576: ) is
577: --

Line 574: p_plan_id in number default hr_api.g_number,

570: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
571: p_update_appraisal in varchar2 default hr_api.g_varchar2,
572: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
573: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
574: p_plan_id in number default hr_api.g_number,
575: p_offline_status in varchar2 default hr_api.g_varchar2
576: ) is
577: --
578: -- Declare cursors and local variables

Line 575: p_offline_status in varchar2 default hr_api.g_varchar2

571: p_update_appraisal in varchar2 default hr_api.g_varchar2,
572: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
573: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
574: p_plan_id in number default hr_api.g_number,
575: p_offline_status in varchar2 default hr_api.g_varchar2
576: ) is
577: --
578: -- Declare cursors and local variables
579: --

Line 826: when hr_api.cannot_find_prog_unit then

822: p_plan_id => p_plan_id,
823: p_offline_status => p_offline_status
824: );
825: exception
826: when hr_api.cannot_find_prog_unit then
827: hr_api.cannot_find_prog_unit_error
828: (p_module_name => 'update_appraisal',
829: p_hook_type => 'BP'
830: );

Line 827: hr_api.cannot_find_prog_unit_error

823: p_offline_status => p_offline_status
824: );
825: exception
826: when hr_api.cannot_find_prog_unit then
827: hr_api.cannot_find_prog_unit_error
828: (p_module_name => 'update_appraisal',
829: p_hook_type => 'BP'
830: );
831: end;

Line 948: if l_old_mainap_id IS NOT NULL AND p_main_appraiser_id <> hr_api.g_number THEN

944: , p_validate => p_validate
945: , p_effective_date => p_effective_date);
946: END IF;
947:
948: if l_old_mainap_id IS NOT NULL AND p_main_appraiser_id <> hr_api.g_number THEN
949: if l_old_mainap_id <> p_main_appraiser_id THEN
950: Get_Participant_id(p_appraisal_id, l_old_mainap_id, l_participant_id_1, l_part_object_version_number_1);
951: -- if old MA is a Participant change his Type
952: if l_participant_id_1 IS NOT NULL THEN

Line 1042: when hr_api.cannot_find_prog_unit then

1038: p_plan_id => p_plan_id,
1039: p_offline_status => p_offline_status
1040: );
1041: exception
1042: when hr_api.cannot_find_prog_unit then
1043: hr_api.cannot_find_prog_unit_error
1044: (p_module_name => 'update_appraisal',
1045: p_hook_type => 'AP'
1046: );

Line 1043: hr_api.cannot_find_prog_unit_error

1039: p_offline_status => p_offline_status
1040: );
1041: exception
1042: when hr_api.cannot_find_prog_unit then
1043: hr_api.cannot_find_prog_unit_error
1044: (p_module_name => 'update_appraisal',
1045: p_hook_type => 'AP'
1046: );
1047: end;

Line 1055: raise hr_api.validate_enabled;

1051: --
1052: -- When in validation only mode raise the Validate_Enabled exception
1053: --
1054: if p_validate then
1055: raise hr_api.validate_enabled;
1056: end if;
1057: --
1058: -- Set all output arguments. l_object_version_number now has the new
1059: -- object version number as the update was successful

Line 1065: when hr_api.validate_enabled then

1061: p_object_version_number := l_object_version_number;
1062: --
1063: hr_utility.set_location(' Leaving:'||l_proc, 11);
1064: exception
1065: when hr_api.validate_enabled then
1066: --
1067: -- As the Validate_Enabled exception has been raised
1068: -- we must rollback to the savepoint
1069: --

Line 1206: when hr_api.cannot_find_prog_unit then

1202: p_appraisal_id => p_appraisal_id,
1203: p_object_version_number => p_object_version_number
1204: );
1205: exception
1206: when hr_api.cannot_find_prog_unit then
1207: hr_api.cannot_find_prog_unit_error
1208: (p_module_name => 'delete_appraisal',
1209: p_hook_type => 'BP'
1210: );

Line 1207: hr_api.cannot_find_prog_unit_error

1203: p_object_version_number => p_object_version_number
1204: );
1205: exception
1206: when hr_api.cannot_find_prog_unit then
1207: hr_api.cannot_find_prog_unit_error
1208: (p_module_name => 'delete_appraisal',
1209: p_hook_type => 'BP'
1210: );
1211: end;

Line 1364: when hr_api.cannot_find_prog_unit then

1360: p_appraisal_id => p_appraisal_id,
1361: p_object_version_number => p_object_version_number
1362: );
1363: exception
1364: when hr_api.cannot_find_prog_unit then
1365: hr_api.cannot_find_prog_unit_error
1366: (p_module_name => 'delete_appraisal',
1367: p_hook_type => 'AP'
1368: );

Line 1365: hr_api.cannot_find_prog_unit_error

1361: p_object_version_number => p_object_version_number
1362: );
1363: exception
1364: when hr_api.cannot_find_prog_unit then
1365: hr_api.cannot_find_prog_unit_error
1366: (p_module_name => 'delete_appraisal',
1367: p_hook_type => 'AP'
1368: );
1369: end;

Line 1376: raise hr_api.validate_enabled;

1372: --
1373: -- When in validation only mode raise the Validate_Enabled exception
1374: --
1375: if p_validate then
1376: raise hr_api.validate_enabled;
1377: end if;
1378: --
1379: hr_utility.set_location(' Leaving:'||l_proc, 11);
1380: exception

Line 1381: when hr_api.validate_enabled then

1377: end if;
1378: --
1379: hr_utility.set_location(' Leaving:'||l_proc, 11);
1380: exception
1381: when hr_api.validate_enabled then
1382: --
1383: -- As the Validate_Enabled exception has been raised
1384: -- we must rollback to the savepoint
1385: --