130:
131: hr_utility.set_location(' Leaving:'||l_proc, 10);
132:
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: per_apr_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: per_apr_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: per_apr_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: per_apr_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: per_apr_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: per_apr_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: per_apr_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: per_apr_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: per_apr_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: per_apr_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: Raise;
148: End update_dml;
149:
359: p_retention_potential_o => per_apr_shd.g_old_rec.retention_potential,
360: p_show_participant_comments_o => per_apr_shd.g_old_rec.show_participant_comments -- 8651478 bug fix
361: );
362: exception
363: when hr_api.cannot_find_prog_unit then
364: hr_api.cannot_find_prog_unit_error
365: ( p_module_name => 'PER_APPRAISALS'
366: ,p_hook_type => 'AU'
367: );
360: p_show_participant_comments_o => per_apr_shd.g_old_rec.show_participant_comments -- 8651478 bug fix
361: );
362: exception
363: when hr_api.cannot_find_prog_unit then
364: hr_api.cannot_find_prog_unit_error
365: ( p_module_name => 'PER_APPRAISALS'
366: ,p_hook_type => 'AU'
367: );
368: end;
427: -- p_rec plsql record structure
428: -- to see if a system default is being used. If a system default
429: -- is being used then we must set to the 'current' argument value.
430:
431: If (p_rec.business_group_id = hr_api.g_number) then
432: p_rec.business_group_id :=
433: per_apr_shd.g_old_rec.business_group_id;
434: End If;
435: If (p_rec.appraisal_template_id = hr_api.g_number) then
431: If (p_rec.business_group_id = hr_api.g_number) then
432: p_rec.business_group_id :=
433: per_apr_shd.g_old_rec.business_group_id;
434: End If;
435: If (p_rec.appraisal_template_id = hr_api.g_number) then
436: p_rec.appraisal_template_id :=
437: per_apr_shd.g_old_rec.appraisal_template_id;
438: End If;
439: If (p_rec.appraisee_person_id = hr_api.g_number) then
435: If (p_rec.appraisal_template_id = hr_api.g_number) then
436: p_rec.appraisal_template_id :=
437: per_apr_shd.g_old_rec.appraisal_template_id;
438: End If;
439: If (p_rec.appraisee_person_id = hr_api.g_number) then
440: p_rec.appraisee_person_id :=
441: per_apr_shd.g_old_rec.appraisee_person_id;
442: End If;
443: If (p_rec.appraiser_person_id = hr_api.g_number) then
439: If (p_rec.appraisee_person_id = hr_api.g_number) then
440: p_rec.appraisee_person_id :=
441: per_apr_shd.g_old_rec.appraisee_person_id;
442: End If;
443: If (p_rec.appraiser_person_id = hr_api.g_number) then
444: p_rec.appraiser_person_id :=
445: per_apr_shd.g_old_rec.appraiser_person_id;
446: End If;
447: If (p_rec.appraisal_date = hr_api.g_date) then
443: If (p_rec.appraiser_person_id = hr_api.g_number) then
444: p_rec.appraiser_person_id :=
445: per_apr_shd.g_old_rec.appraiser_person_id;
446: End If;
447: If (p_rec.appraisal_date = hr_api.g_date) then
448: p_rec.appraisal_date :=
449: per_apr_shd.g_old_rec.appraisal_date;
450: End If;
451: If (p_rec.appraisal_period_end_date = hr_api.g_date) then
447: If (p_rec.appraisal_date = hr_api.g_date) then
448: p_rec.appraisal_date :=
449: per_apr_shd.g_old_rec.appraisal_date;
450: End If;
451: If (p_rec.appraisal_period_end_date = hr_api.g_date) then
452: p_rec.appraisal_period_end_date :=
453: per_apr_shd.g_old_rec.appraisal_period_end_date;
454: End If;
455: If (p_rec.appraisal_period_start_date = hr_api.g_date) then
451: If (p_rec.appraisal_period_end_date = hr_api.g_date) then
452: p_rec.appraisal_period_end_date :=
453: per_apr_shd.g_old_rec.appraisal_period_end_date;
454: End If;
455: If (p_rec.appraisal_period_start_date = hr_api.g_date) then
456: p_rec.appraisal_period_start_date :=
457: per_apr_shd.g_old_rec.appraisal_period_start_date;
458: End If;
459: If (p_rec.type = hr_api.g_varchar2) then
455: If (p_rec.appraisal_period_start_date = hr_api.g_date) then
456: p_rec.appraisal_period_start_date :=
457: per_apr_shd.g_old_rec.appraisal_period_start_date;
458: End If;
459: If (p_rec.type = hr_api.g_varchar2) then
460: p_rec.type :=
461: per_apr_shd.g_old_rec.type;
462: End If;
463: If (p_rec.next_appraisal_date = hr_api.g_date) then
459: If (p_rec.type = hr_api.g_varchar2) then
460: p_rec.type :=
461: per_apr_shd.g_old_rec.type;
462: End If;
463: If (p_rec.next_appraisal_date = hr_api.g_date) then
464: p_rec.next_appraisal_date :=
465: per_apr_shd.g_old_rec.next_appraisal_date;
466: End If;
467: If (p_rec.status = hr_api.g_varchar2) then
463: If (p_rec.next_appraisal_date = hr_api.g_date) then
464: p_rec.next_appraisal_date :=
465: per_apr_shd.g_old_rec.next_appraisal_date;
466: End If;
467: If (p_rec.status = hr_api.g_varchar2) then
468: p_rec.status :=
469: per_apr_shd.g_old_rec.status;
470: End If;
471: If (p_rec.comments = hr_api.g_varchar2) then
467: If (p_rec.status = hr_api.g_varchar2) then
468: p_rec.status :=
469: per_apr_shd.g_old_rec.status;
470: End If;
471: If (p_rec.comments = hr_api.g_varchar2) then
472: p_rec.comments :=
473: per_apr_shd.g_old_rec.comments;
474: End If;
475: If (p_rec.overall_performance_level_id = hr_api.g_number) then
471: If (p_rec.comments = hr_api.g_varchar2) then
472: p_rec.comments :=
473: per_apr_shd.g_old_rec.comments;
474: End If;
475: If (p_rec.overall_performance_level_id = hr_api.g_number) then
476: p_rec.overall_performance_level_id :=
477: per_apr_shd.g_old_rec.overall_performance_level_id;
478: End If;
479: If (p_rec.open = hr_api.g_varchar2) then
475: If (p_rec.overall_performance_level_id = hr_api.g_number) then
476: p_rec.overall_performance_level_id :=
477: per_apr_shd.g_old_rec.overall_performance_level_id;
478: End If;
479: If (p_rec.open = hr_api.g_varchar2) then
480: p_rec.open := per_apr_shd.g_old_rec.open;
481: End If;
482: If (p_rec.attribute_category = hr_api.g_varchar2) then
483: p_rec.attribute_category :=
478: End If;
479: If (p_rec.open = hr_api.g_varchar2) then
480: p_rec.open := per_apr_shd.g_old_rec.open;
481: End If;
482: If (p_rec.attribute_category = hr_api.g_varchar2) then
483: p_rec.attribute_category :=
484: per_apr_shd.g_old_rec.attribute_category;
485: End If;
486: If (p_rec.attribute1 = hr_api.g_varchar2) then
482: If (p_rec.attribute_category = hr_api.g_varchar2) then
483: p_rec.attribute_category :=
484: per_apr_shd.g_old_rec.attribute_category;
485: End If;
486: If (p_rec.attribute1 = hr_api.g_varchar2) then
487: p_rec.attribute1 :=
488: per_apr_shd.g_old_rec.attribute1;
489: End If;
490: If (p_rec.attribute2 = hr_api.g_varchar2) then
486: If (p_rec.attribute1 = hr_api.g_varchar2) then
487: p_rec.attribute1 :=
488: per_apr_shd.g_old_rec.attribute1;
489: End If;
490: If (p_rec.attribute2 = hr_api.g_varchar2) then
491: p_rec.attribute2 :=
492: per_apr_shd.g_old_rec.attribute2;
493: End If;
494: If (p_rec.attribute3 = hr_api.g_varchar2) then
490: If (p_rec.attribute2 = hr_api.g_varchar2) then
491: p_rec.attribute2 :=
492: per_apr_shd.g_old_rec.attribute2;
493: End If;
494: If (p_rec.attribute3 = hr_api.g_varchar2) then
495: p_rec.attribute3 :=
496: per_apr_shd.g_old_rec.attribute3;
497: End If;
498: If (p_rec.attribute4 = hr_api.g_varchar2) then
494: If (p_rec.attribute3 = hr_api.g_varchar2) then
495: p_rec.attribute3 :=
496: per_apr_shd.g_old_rec.attribute3;
497: End If;
498: If (p_rec.attribute4 = hr_api.g_varchar2) then
499: p_rec.attribute4 :=
500: per_apr_shd.g_old_rec.attribute4;
501: End If;
502: If (p_rec.attribute5 = hr_api.g_varchar2) then
498: If (p_rec.attribute4 = hr_api.g_varchar2) then
499: p_rec.attribute4 :=
500: per_apr_shd.g_old_rec.attribute4;
501: End If;
502: If (p_rec.attribute5 = hr_api.g_varchar2) then
503: p_rec.attribute5 :=
504: per_apr_shd.g_old_rec.attribute5;
505: End If;
506: If (p_rec.attribute6 = hr_api.g_varchar2) then
502: If (p_rec.attribute5 = hr_api.g_varchar2) then
503: p_rec.attribute5 :=
504: per_apr_shd.g_old_rec.attribute5;
505: End If;
506: If (p_rec.attribute6 = hr_api.g_varchar2) then
507: p_rec.attribute6 :=
508: per_apr_shd.g_old_rec.attribute6;
509: End If;
510: If (p_rec.attribute7 = hr_api.g_varchar2) then
506: If (p_rec.attribute6 = hr_api.g_varchar2) then
507: p_rec.attribute6 :=
508: per_apr_shd.g_old_rec.attribute6;
509: End If;
510: If (p_rec.attribute7 = hr_api.g_varchar2) then
511: p_rec.attribute7 :=
512: per_apr_shd.g_old_rec.attribute7;
513: End If;
514: If (p_rec.attribute8 = hr_api.g_varchar2) then
510: If (p_rec.attribute7 = hr_api.g_varchar2) then
511: p_rec.attribute7 :=
512: per_apr_shd.g_old_rec.attribute7;
513: End If;
514: If (p_rec.attribute8 = hr_api.g_varchar2) then
515: p_rec.attribute8 :=
516: per_apr_shd.g_old_rec.attribute8;
517: End If;
518: If (p_rec.attribute9 = hr_api.g_varchar2) then
514: If (p_rec.attribute8 = hr_api.g_varchar2) then
515: p_rec.attribute8 :=
516: per_apr_shd.g_old_rec.attribute8;
517: End If;
518: If (p_rec.attribute9 = hr_api.g_varchar2) then
519: p_rec.attribute9 :=
520: per_apr_shd.g_old_rec.attribute9;
521: End If;
522: If (p_rec.attribute10 = hr_api.g_varchar2) then
518: If (p_rec.attribute9 = hr_api.g_varchar2) then
519: p_rec.attribute9 :=
520: per_apr_shd.g_old_rec.attribute9;
521: End If;
522: If (p_rec.attribute10 = hr_api.g_varchar2) then
523: p_rec.attribute10 :=
524: per_apr_shd.g_old_rec.attribute10;
525: End If;
526: If (p_rec.attribute11 = hr_api.g_varchar2) then
522: If (p_rec.attribute10 = hr_api.g_varchar2) then
523: p_rec.attribute10 :=
524: per_apr_shd.g_old_rec.attribute10;
525: End If;
526: If (p_rec.attribute11 = hr_api.g_varchar2) then
527: p_rec.attribute11 :=
528: per_apr_shd.g_old_rec.attribute11;
529: End If;
530: If (p_rec.attribute12 = hr_api.g_varchar2) then
526: If (p_rec.attribute11 = hr_api.g_varchar2) then
527: p_rec.attribute11 :=
528: per_apr_shd.g_old_rec.attribute11;
529: End If;
530: If (p_rec.attribute12 = hr_api.g_varchar2) then
531: p_rec.attribute12 :=
532: per_apr_shd.g_old_rec.attribute12;
533: End If;
534: If (p_rec.attribute13 = hr_api.g_varchar2) then
530: If (p_rec.attribute12 = hr_api.g_varchar2) then
531: p_rec.attribute12 :=
532: per_apr_shd.g_old_rec.attribute12;
533: End If;
534: If (p_rec.attribute13 = hr_api.g_varchar2) then
535: p_rec.attribute13 :=
536: per_apr_shd.g_old_rec.attribute13;
537: End If;
538: If (p_rec.attribute14 = hr_api.g_varchar2) then
534: If (p_rec.attribute13 = hr_api.g_varchar2) then
535: p_rec.attribute13 :=
536: per_apr_shd.g_old_rec.attribute13;
537: End If;
538: If (p_rec.attribute14 = hr_api.g_varchar2) then
539: p_rec.attribute14 :=
540: per_apr_shd.g_old_rec.attribute14;
541: End If;
542: If (p_rec.attribute15 = hr_api.g_varchar2) then
538: If (p_rec.attribute14 = hr_api.g_varchar2) then
539: p_rec.attribute14 :=
540: per_apr_shd.g_old_rec.attribute14;
541: End If;
542: If (p_rec.attribute15 = hr_api.g_varchar2) then
543: p_rec.attribute15 :=
544: per_apr_shd.g_old_rec.attribute15;
545: End If;
546: If (p_rec.attribute16 = hr_api.g_varchar2) then
542: If (p_rec.attribute15 = hr_api.g_varchar2) then
543: p_rec.attribute15 :=
544: per_apr_shd.g_old_rec.attribute15;
545: End If;
546: If (p_rec.attribute16 = hr_api.g_varchar2) then
547: p_rec.attribute16 :=
548: per_apr_shd.g_old_rec.attribute16;
549: End If;
550: If (p_rec.attribute17 = hr_api.g_varchar2) then
546: If (p_rec.attribute16 = hr_api.g_varchar2) then
547: p_rec.attribute16 :=
548: per_apr_shd.g_old_rec.attribute16;
549: End If;
550: If (p_rec.attribute17 = hr_api.g_varchar2) then
551: p_rec.attribute17 :=
552: per_apr_shd.g_old_rec.attribute17;
553: End If;
554: If (p_rec.attribute18 = hr_api.g_varchar2) then
550: If (p_rec.attribute17 = hr_api.g_varchar2) then
551: p_rec.attribute17 :=
552: per_apr_shd.g_old_rec.attribute17;
553: End If;
554: If (p_rec.attribute18 = hr_api.g_varchar2) then
555: p_rec.attribute18 :=
556: per_apr_shd.g_old_rec.attribute18;
557: End If;
558: If (p_rec.attribute19 = hr_api.g_varchar2) then
554: If (p_rec.attribute18 = hr_api.g_varchar2) then
555: p_rec.attribute18 :=
556: per_apr_shd.g_old_rec.attribute18;
557: End If;
558: If (p_rec.attribute19 = hr_api.g_varchar2) then
559: p_rec.attribute19 :=
560: per_apr_shd.g_old_rec.attribute19;
561: End If;
562: If (p_rec.attribute20 = hr_api.g_varchar2) then
558: If (p_rec.attribute19 = hr_api.g_varchar2) then
559: p_rec.attribute19 :=
560: per_apr_shd.g_old_rec.attribute19;
561: End If;
562: If (p_rec.attribute20 = hr_api.g_varchar2) then
563: p_rec.attribute20 :=
564: per_apr_shd.g_old_rec.attribute20;
565: End If;
566:
563: p_rec.attribute20 :=
564: per_apr_shd.g_old_rec.attribute20;
565: End If;
566:
567: If (p_rec.system_type = hr_api.g_varchar2) then
568: p_rec.system_type :=
569: per_apr_shd.g_old_rec.system_type;
570: End If;
571: If (p_rec.system_params = hr_api.g_varchar2) then
567: If (p_rec.system_type = hr_api.g_varchar2) then
568: p_rec.system_type :=
569: per_apr_shd.g_old_rec.system_type;
570: End If;
571: If (p_rec.system_params = hr_api.g_varchar2) then
572: p_rec.system_params :=
573: per_apr_shd.g_old_rec.system_params;
574: End If;
575:
572: p_rec.system_params :=
573: per_apr_shd.g_old_rec.system_params;
574: End If;
575:
576: If (p_rec.appraisee_access = hr_api.g_varchar2) then
577: p_rec.appraisee_access :=
578: per_apr_shd.g_old_rec.appraisee_access;
579: End If;
580: If (p_rec.main_appraiser_id = hr_api.g_number) then
576: If (p_rec.appraisee_access = hr_api.g_varchar2) then
577: p_rec.appraisee_access :=
578: per_apr_shd.g_old_rec.appraisee_access;
579: End If;
580: If (p_rec.main_appraiser_id = hr_api.g_number) then
581: p_rec.main_appraiser_id :=
582: per_apr_shd.g_old_rec.main_appraiser_id;
583: End If;
584: If (p_rec.assignment_id = hr_api.g_number) then
580: If (p_rec.main_appraiser_id = hr_api.g_number) then
581: p_rec.main_appraiser_id :=
582: per_apr_shd.g_old_rec.main_appraiser_id;
583: End If;
584: If (p_rec.assignment_id = hr_api.g_number) then
585: p_rec.assignment_id :=
586: per_apr_shd.g_old_rec.assignment_id;
587: End If;
588: If (p_rec.assignment_start_date = hr_api.g_date) then
584: If (p_rec.assignment_id = hr_api.g_number) then
585: p_rec.assignment_id :=
586: per_apr_shd.g_old_rec.assignment_id;
587: End If;
588: If (p_rec.assignment_start_date = hr_api.g_date) then
589: p_rec.assignment_start_date :=
590: per_apr_shd.g_old_rec.assignment_start_date;
591: End If;
592:
589: p_rec.assignment_start_date :=
590: per_apr_shd.g_old_rec.assignment_start_date;
591: End If;
592:
593: If (p_rec.assignment_business_group_id = hr_api.g_number) then
594: p_rec.assignment_business_group_id :=
595: per_apr_shd.g_old_rec.assignment_business_group_id;
596: End If;
597: If (p_rec.assignment_organization_id = hr_api.g_number) then
593: If (p_rec.assignment_business_group_id = hr_api.g_number) then
594: p_rec.assignment_business_group_id :=
595: per_apr_shd.g_old_rec.assignment_business_group_id;
596: End If;
597: If (p_rec.assignment_organization_id = hr_api.g_number) then
598: p_rec.assignment_organization_id :=
599: per_apr_shd.g_old_rec.assignment_organization_id;
600: End If;
601: If (p_rec.assignment_job_id = hr_api.g_number) then
597: If (p_rec.assignment_organization_id = hr_api.g_number) then
598: p_rec.assignment_organization_id :=
599: per_apr_shd.g_old_rec.assignment_organization_id;
600: End If;
601: If (p_rec.assignment_job_id = hr_api.g_number) then
602: p_rec.assignment_job_id :=
603: per_apr_shd.g_old_rec.assignment_job_id;
604: End If;
605: If (p_rec.assignment_position_id = hr_api.g_number) then
601: If (p_rec.assignment_job_id = hr_api.g_number) then
602: p_rec.assignment_job_id :=
603: per_apr_shd.g_old_rec.assignment_job_id;
604: End If;
605: If (p_rec.assignment_position_id = hr_api.g_number) then
606: p_rec.assignment_position_id :=
607: per_apr_shd.g_old_rec.assignment_position_id;
608: End If;
609: If (p_rec.assignment_grade_id = hr_api.g_number) then
605: If (p_rec.assignment_position_id = hr_api.g_number) then
606: p_rec.assignment_position_id :=
607: per_apr_shd.g_old_rec.assignment_position_id;
608: End If;
609: If (p_rec.assignment_grade_id = hr_api.g_number) then
610: p_rec.assignment_grade_id :=
611: per_apr_shd.g_old_rec.assignment_grade_id;
612: End If;
613:
610: p_rec.assignment_grade_id :=
611: per_apr_shd.g_old_rec.assignment_grade_id;
612: End If;
613:
614: If (p_rec.potential_readiness_level = hr_api.g_varchar2) then
615: p_rec.potential_readiness_level :=
616: per_apr_shd.g_old_rec.potential_readiness_level;
617: End If;
618: If (p_rec.potential_short_term_workopp = hr_api.g_varchar2) then
614: If (p_rec.potential_readiness_level = hr_api.g_varchar2) then
615: p_rec.potential_readiness_level :=
616: per_apr_shd.g_old_rec.potential_readiness_level;
617: End If;
618: If (p_rec.potential_short_term_workopp = hr_api.g_varchar2) then
619: p_rec.potential_short_term_workopp :=
620: per_apr_shd.g_old_rec.potential_short_term_workopp;
621: End If;
622: If (p_rec.potential_long_term_workopp = hr_api.g_varchar2) then
618: If (p_rec.potential_short_term_workopp = hr_api.g_varchar2) then
619: p_rec.potential_short_term_workopp :=
620: per_apr_shd.g_old_rec.potential_short_term_workopp;
621: End If;
622: If (p_rec.potential_long_term_workopp = hr_api.g_varchar2) then
623: p_rec.potential_long_term_workopp :=
624: per_apr_shd.g_old_rec.potential_long_term_workopp;
625: End If;
626: If (p_rec.potential_details = hr_api.g_varchar2) then
622: If (p_rec.potential_long_term_workopp = hr_api.g_varchar2) then
623: p_rec.potential_long_term_workopp :=
624: per_apr_shd.g_old_rec.potential_long_term_workopp;
625: End If;
626: If (p_rec.potential_details = hr_api.g_varchar2) then
627: p_rec.potential_details :=
628: per_apr_shd.g_old_rec.potential_details;
629: End If;
630: If (p_rec.event_id = hr_api.g_number) then
626: If (p_rec.potential_details = hr_api.g_varchar2) then
627: p_rec.potential_details :=
628: per_apr_shd.g_old_rec.potential_details;
629: End If;
630: If (p_rec.event_id = hr_api.g_number) then
631: p_rec.event_id :=
632: per_apr_shd.g_old_rec.event_id;
633: End If;
634:
631: p_rec.event_id :=
632: per_apr_shd.g_old_rec.event_id;
633: End If;
634:
635: If (p_rec.appraisal_system_status = hr_api.g_varchar2) then
636: p_rec.appraisal_system_status :=
637: per_apr_shd.g_old_rec.appraisal_system_status;
638: End If;
639:
636: p_rec.appraisal_system_status :=
637: per_apr_shd.g_old_rec.appraisal_system_status;
638: End If;
639:
640: If (p_rec.show_competency_ratings = hr_api.g_varchar2) then
641: p_rec.show_competency_ratings :=
642: per_apr_shd.g_old_rec.show_competency_ratings;
643: End If;
644:
641: p_rec.show_competency_ratings :=
642: per_apr_shd.g_old_rec.show_competency_ratings;
643: End If;
644:
645: If (p_rec.show_objective_ratings = hr_api.g_varchar2) then
646: p_rec.show_objective_ratings :=
647: per_apr_shd.g_old_rec.show_objective_ratings;
648: End If;
649:
646: p_rec.show_objective_ratings :=
647: per_apr_shd.g_old_rec.show_objective_ratings;
648: End If;
649:
650: If (p_rec.show_questionnaire_info = hr_api.g_varchar2) then
651: p_rec.show_questionnaire_info :=
652: per_apr_shd.g_old_rec.show_questionnaire_info;
653: End If;
654:
651: p_rec.show_questionnaire_info :=
652: per_apr_shd.g_old_rec.show_questionnaire_info;
653: End If;
654:
655: If (p_rec.show_participant_details = hr_api.g_varchar2) then
656: p_rec.show_participant_details :=
657: per_apr_shd.g_old_rec.show_participant_details;
658: End If;
659:
656: p_rec.show_participant_details :=
657: per_apr_shd.g_old_rec.show_participant_details;
658: End If;
659:
660: If (p_rec.show_participant_ratings = hr_api.g_varchar2) then
661: p_rec.show_participant_ratings :=
662: per_apr_shd.g_old_rec.show_participant_ratings;
663: End If;
664:
661: p_rec.show_participant_ratings :=
662: per_apr_shd.g_old_rec.show_participant_ratings;
663: End If;
664:
665: If (p_rec.show_participant_names = hr_api.g_varchar2) then
666: p_rec.show_participant_names :=
667: per_apr_shd.g_old_rec.show_participant_names;
668: End If;
669:
666: p_rec.show_participant_names :=
667: per_apr_shd.g_old_rec.show_participant_names;
668: End If;
669:
670: If (p_rec.show_overall_ratings = hr_api.g_varchar2) then
671: p_rec.show_overall_ratings :=
672: per_apr_shd.g_old_rec.show_overall_ratings;
673: End If;
674:
671: p_rec.show_overall_ratings :=
672: per_apr_shd.g_old_rec.show_overall_ratings;
673: End If;
674:
675: If (p_rec.show_overall_comments = hr_api.g_varchar2) then
676: p_rec.show_overall_comments :=
677: per_apr_shd.g_old_rec.show_overall_comments;
678: End If;
679:
676: p_rec.show_overall_comments :=
677: per_apr_shd.g_old_rec.show_overall_comments;
678: End If;
679:
680: If (p_rec.update_appraisal = hr_api.g_varchar2) then
681: p_rec.update_appraisal :=
682: per_apr_shd.g_old_rec.update_appraisal;
683: End If;
684:
681: p_rec.update_appraisal :=
682: per_apr_shd.g_old_rec.update_appraisal;
683: End If;
684:
685: If (p_rec.provide_overall_feedback = hr_api.g_varchar2) then
686: p_rec.provide_overall_feedback :=
687: per_apr_shd.g_old_rec.provide_overall_feedback;
688: End If;
689:
686: p_rec.provide_overall_feedback :=
687: per_apr_shd.g_old_rec.provide_overall_feedback;
688: End If;
689:
690: If (p_rec.appraisee_comments = hr_api.g_varchar2) then
691: p_rec.appraisee_comments :=
692: per_apr_shd.g_old_rec.appraisee_comments;
693: End If;
694:
691: p_rec.appraisee_comments :=
692: per_apr_shd.g_old_rec.appraisee_comments;
693: End If;
694:
695: If (p_rec.plan_id = hr_api.g_number) then
696: p_rec.plan_id :=
697: per_apr_shd.g_old_rec.plan_id;
698: End If;
699:
696: p_rec.plan_id :=
697: per_apr_shd.g_old_rec.plan_id;
698: End If;
699:
700: If (p_rec.offline_status = hr_api.g_varchar2) then
701: p_rec.offline_status :=
702: per_apr_shd.g_old_rec.offline_status;
703: End If;
704:
701: p_rec.offline_status :=
702: per_apr_shd.g_old_rec.offline_status;
703: End If;
704:
705: If (p_rec.retention_potential = hr_api.g_varchar2) then
706: p_rec.retention_potential :=
707: per_apr_shd.g_old_rec.retention_potential;
708: End If;
709:
707: per_apr_shd.g_old_rec.retention_potential;
708: End If;
709:
710: -- 8651478 bug fix
711: If (p_rec.show_participant_comments = hr_api.g_varchar2) then
712: p_rec.show_participant_comments :=
713: per_apr_shd.g_old_rec.show_participant_comments;
714: End If;
715:
775:
776: -- If we are validating then raise the Validate_Enabled exception
777:
778: If p_validate then
779: Raise HR_Api.Validate_Enabled;
780: End If;
781:
782: hr_utility.set_location(' Leaving:'||l_proc, 10);
783: Exception
780: End If;
781:
782: hr_utility.set_location(' Leaving:'||l_proc, 10);
783: Exception
784: When HR_Api.Validate_Enabled Then
785:
786: -- As the Validate_Enabled exception has been raised
787: -- we must rollback to the savepoint
788:
796: (
797: p_appraisal_id in number,
798: p_object_version_number in out nocopy number,
799: p_appraiser_person_id in number,
800: p_appraisal_date in date default hr_api.g_date,
801: p_appraisal_period_end_date in date default hr_api.g_date,
802: p_appraisal_period_start_date in date default hr_api.g_date,
803: p_type in varchar2 default hr_api.g_varchar2,
804: p_next_appraisal_date in date default hr_api.g_date,
797: p_appraisal_id in number,
798: p_object_version_number in out nocopy number,
799: p_appraiser_person_id in number,
800: p_appraisal_date in date default hr_api.g_date,
801: p_appraisal_period_end_date in date default hr_api.g_date,
802: p_appraisal_period_start_date in date default hr_api.g_date,
803: p_type in varchar2 default hr_api.g_varchar2,
804: p_next_appraisal_date in date default hr_api.g_date,
805: p_status in varchar2 default hr_api.g_varchar2,
798: p_object_version_number in out nocopy number,
799: p_appraiser_person_id in number,
800: p_appraisal_date in date default hr_api.g_date,
801: p_appraisal_period_end_date in date default hr_api.g_date,
802: p_appraisal_period_start_date in date default hr_api.g_date,
803: p_type in varchar2 default hr_api.g_varchar2,
804: p_next_appraisal_date in date default hr_api.g_date,
805: p_status in varchar2 default hr_api.g_varchar2,
806: p_comments in varchar2 default hr_api.g_varchar2,
799: p_appraiser_person_id in number,
800: p_appraisal_date in date default hr_api.g_date,
801: p_appraisal_period_end_date in date default hr_api.g_date,
802: p_appraisal_period_start_date in date default hr_api.g_date,
803: p_type in varchar2 default hr_api.g_varchar2,
804: p_next_appraisal_date in date default hr_api.g_date,
805: p_status in varchar2 default hr_api.g_varchar2,
806: p_comments in varchar2 default hr_api.g_varchar2,
807: p_overall_performance_level_id in number default hr_api.g_number,
800: p_appraisal_date in date default hr_api.g_date,
801: p_appraisal_period_end_date in date default hr_api.g_date,
802: p_appraisal_period_start_date in date default hr_api.g_date,
803: p_type in varchar2 default hr_api.g_varchar2,
804: p_next_appraisal_date in date default hr_api.g_date,
805: p_status in varchar2 default hr_api.g_varchar2,
806: p_comments in varchar2 default hr_api.g_varchar2,
807: p_overall_performance_level_id in number default hr_api.g_number,
808: p_open in varchar2 default hr_api.g_varchar2,
801: p_appraisal_period_end_date in date default hr_api.g_date,
802: p_appraisal_period_start_date in date default hr_api.g_date,
803: p_type in varchar2 default hr_api.g_varchar2,
804: p_next_appraisal_date in date default hr_api.g_date,
805: p_status in varchar2 default hr_api.g_varchar2,
806: p_comments in varchar2 default hr_api.g_varchar2,
807: p_overall_performance_level_id in number default hr_api.g_number,
808: p_open in varchar2 default hr_api.g_varchar2,
809: p_attribute_category in varchar2 default hr_api.g_varchar2,
802: p_appraisal_period_start_date in date default hr_api.g_date,
803: p_type in varchar2 default hr_api.g_varchar2,
804: p_next_appraisal_date in date default hr_api.g_date,
805: p_status in varchar2 default hr_api.g_varchar2,
806: p_comments in varchar2 default hr_api.g_varchar2,
807: p_overall_performance_level_id in number default hr_api.g_number,
808: p_open in varchar2 default hr_api.g_varchar2,
809: p_attribute_category in varchar2 default hr_api.g_varchar2,
810: p_attribute1 in varchar2 default hr_api.g_varchar2,
803: p_type in varchar2 default hr_api.g_varchar2,
804: p_next_appraisal_date in date default hr_api.g_date,
805: p_status in varchar2 default hr_api.g_varchar2,
806: p_comments in varchar2 default hr_api.g_varchar2,
807: p_overall_performance_level_id in number default hr_api.g_number,
808: p_open in varchar2 default hr_api.g_varchar2,
809: p_attribute_category in varchar2 default hr_api.g_varchar2,
810: p_attribute1 in varchar2 default hr_api.g_varchar2,
811: p_attribute2 in varchar2 default hr_api.g_varchar2,
804: p_next_appraisal_date in date default hr_api.g_date,
805: p_status in varchar2 default hr_api.g_varchar2,
806: p_comments in varchar2 default hr_api.g_varchar2,
807: p_overall_performance_level_id in number default hr_api.g_number,
808: p_open in varchar2 default hr_api.g_varchar2,
809: p_attribute_category in varchar2 default hr_api.g_varchar2,
810: p_attribute1 in varchar2 default hr_api.g_varchar2,
811: p_attribute2 in varchar2 default hr_api.g_varchar2,
812: p_attribute3 in varchar2 default hr_api.g_varchar2,
805: p_status in varchar2 default hr_api.g_varchar2,
806: p_comments in varchar2 default hr_api.g_varchar2,
807: p_overall_performance_level_id in number default hr_api.g_number,
808: p_open in varchar2 default hr_api.g_varchar2,
809: p_attribute_category in varchar2 default hr_api.g_varchar2,
810: p_attribute1 in varchar2 default hr_api.g_varchar2,
811: p_attribute2 in varchar2 default hr_api.g_varchar2,
812: p_attribute3 in varchar2 default hr_api.g_varchar2,
813: p_attribute4 in varchar2 default hr_api.g_varchar2,
806: p_comments in varchar2 default hr_api.g_varchar2,
807: p_overall_performance_level_id in number default hr_api.g_number,
808: p_open in varchar2 default hr_api.g_varchar2,
809: p_attribute_category in varchar2 default hr_api.g_varchar2,
810: p_attribute1 in varchar2 default hr_api.g_varchar2,
811: p_attribute2 in varchar2 default hr_api.g_varchar2,
812: p_attribute3 in varchar2 default hr_api.g_varchar2,
813: p_attribute4 in varchar2 default hr_api.g_varchar2,
814: p_attribute5 in varchar2 default hr_api.g_varchar2,
807: p_overall_performance_level_id in number default hr_api.g_number,
808: p_open in varchar2 default hr_api.g_varchar2,
809: p_attribute_category in varchar2 default hr_api.g_varchar2,
810: p_attribute1 in varchar2 default hr_api.g_varchar2,
811: p_attribute2 in varchar2 default hr_api.g_varchar2,
812: p_attribute3 in varchar2 default hr_api.g_varchar2,
813: p_attribute4 in varchar2 default hr_api.g_varchar2,
814: p_attribute5 in varchar2 default hr_api.g_varchar2,
815: p_attribute6 in varchar2 default hr_api.g_varchar2,
808: p_open in varchar2 default hr_api.g_varchar2,
809: p_attribute_category in varchar2 default hr_api.g_varchar2,
810: p_attribute1 in varchar2 default hr_api.g_varchar2,
811: p_attribute2 in varchar2 default hr_api.g_varchar2,
812: p_attribute3 in varchar2 default hr_api.g_varchar2,
813: p_attribute4 in varchar2 default hr_api.g_varchar2,
814: p_attribute5 in varchar2 default hr_api.g_varchar2,
815: p_attribute6 in varchar2 default hr_api.g_varchar2,
816: p_attribute7 in varchar2 default hr_api.g_varchar2,
809: p_attribute_category in varchar2 default hr_api.g_varchar2,
810: p_attribute1 in varchar2 default hr_api.g_varchar2,
811: p_attribute2 in varchar2 default hr_api.g_varchar2,
812: p_attribute3 in varchar2 default hr_api.g_varchar2,
813: p_attribute4 in varchar2 default hr_api.g_varchar2,
814: p_attribute5 in varchar2 default hr_api.g_varchar2,
815: p_attribute6 in varchar2 default hr_api.g_varchar2,
816: p_attribute7 in varchar2 default hr_api.g_varchar2,
817: p_attribute8 in varchar2 default hr_api.g_varchar2,
810: p_attribute1 in varchar2 default hr_api.g_varchar2,
811: p_attribute2 in varchar2 default hr_api.g_varchar2,
812: p_attribute3 in varchar2 default hr_api.g_varchar2,
813: p_attribute4 in varchar2 default hr_api.g_varchar2,
814: p_attribute5 in varchar2 default hr_api.g_varchar2,
815: p_attribute6 in varchar2 default hr_api.g_varchar2,
816: p_attribute7 in varchar2 default hr_api.g_varchar2,
817: p_attribute8 in varchar2 default hr_api.g_varchar2,
818: p_attribute9 in varchar2 default hr_api.g_varchar2,
811: p_attribute2 in varchar2 default hr_api.g_varchar2,
812: p_attribute3 in varchar2 default hr_api.g_varchar2,
813: p_attribute4 in varchar2 default hr_api.g_varchar2,
814: p_attribute5 in varchar2 default hr_api.g_varchar2,
815: p_attribute6 in varchar2 default hr_api.g_varchar2,
816: p_attribute7 in varchar2 default hr_api.g_varchar2,
817: p_attribute8 in varchar2 default hr_api.g_varchar2,
818: p_attribute9 in varchar2 default hr_api.g_varchar2,
819: p_attribute10 in varchar2 default hr_api.g_varchar2,
812: p_attribute3 in varchar2 default hr_api.g_varchar2,
813: p_attribute4 in varchar2 default hr_api.g_varchar2,
814: p_attribute5 in varchar2 default hr_api.g_varchar2,
815: p_attribute6 in varchar2 default hr_api.g_varchar2,
816: p_attribute7 in varchar2 default hr_api.g_varchar2,
817: p_attribute8 in varchar2 default hr_api.g_varchar2,
818: p_attribute9 in varchar2 default hr_api.g_varchar2,
819: p_attribute10 in varchar2 default hr_api.g_varchar2,
820: p_attribute11 in varchar2 default hr_api.g_varchar2,
813: p_attribute4 in varchar2 default hr_api.g_varchar2,
814: p_attribute5 in varchar2 default hr_api.g_varchar2,
815: p_attribute6 in varchar2 default hr_api.g_varchar2,
816: p_attribute7 in varchar2 default hr_api.g_varchar2,
817: p_attribute8 in varchar2 default hr_api.g_varchar2,
818: p_attribute9 in varchar2 default hr_api.g_varchar2,
819: p_attribute10 in varchar2 default hr_api.g_varchar2,
820: p_attribute11 in varchar2 default hr_api.g_varchar2,
821: p_attribute12 in varchar2 default hr_api.g_varchar2,
814: p_attribute5 in varchar2 default hr_api.g_varchar2,
815: p_attribute6 in varchar2 default hr_api.g_varchar2,
816: p_attribute7 in varchar2 default hr_api.g_varchar2,
817: p_attribute8 in varchar2 default hr_api.g_varchar2,
818: p_attribute9 in varchar2 default hr_api.g_varchar2,
819: p_attribute10 in varchar2 default hr_api.g_varchar2,
820: p_attribute11 in varchar2 default hr_api.g_varchar2,
821: p_attribute12 in varchar2 default hr_api.g_varchar2,
822: p_attribute13 in varchar2 default hr_api.g_varchar2,
815: p_attribute6 in varchar2 default hr_api.g_varchar2,
816: p_attribute7 in varchar2 default hr_api.g_varchar2,
817: p_attribute8 in varchar2 default hr_api.g_varchar2,
818: p_attribute9 in varchar2 default hr_api.g_varchar2,
819: p_attribute10 in varchar2 default hr_api.g_varchar2,
820: p_attribute11 in varchar2 default hr_api.g_varchar2,
821: p_attribute12 in varchar2 default hr_api.g_varchar2,
822: p_attribute13 in varchar2 default hr_api.g_varchar2,
823: p_attribute14 in varchar2 default hr_api.g_varchar2,
816: p_attribute7 in varchar2 default hr_api.g_varchar2,
817: p_attribute8 in varchar2 default hr_api.g_varchar2,
818: p_attribute9 in varchar2 default hr_api.g_varchar2,
819: p_attribute10 in varchar2 default hr_api.g_varchar2,
820: p_attribute11 in varchar2 default hr_api.g_varchar2,
821: p_attribute12 in varchar2 default hr_api.g_varchar2,
822: p_attribute13 in varchar2 default hr_api.g_varchar2,
823: p_attribute14 in varchar2 default hr_api.g_varchar2,
824: p_attribute15 in varchar2 default hr_api.g_varchar2,
817: p_attribute8 in varchar2 default hr_api.g_varchar2,
818: p_attribute9 in varchar2 default hr_api.g_varchar2,
819: p_attribute10 in varchar2 default hr_api.g_varchar2,
820: p_attribute11 in varchar2 default hr_api.g_varchar2,
821: p_attribute12 in varchar2 default hr_api.g_varchar2,
822: p_attribute13 in varchar2 default hr_api.g_varchar2,
823: p_attribute14 in varchar2 default hr_api.g_varchar2,
824: p_attribute15 in varchar2 default hr_api.g_varchar2,
825: p_attribute16 in varchar2 default hr_api.g_varchar2,
818: p_attribute9 in varchar2 default hr_api.g_varchar2,
819: p_attribute10 in varchar2 default hr_api.g_varchar2,
820: p_attribute11 in varchar2 default hr_api.g_varchar2,
821: p_attribute12 in varchar2 default hr_api.g_varchar2,
822: p_attribute13 in varchar2 default hr_api.g_varchar2,
823: p_attribute14 in varchar2 default hr_api.g_varchar2,
824: p_attribute15 in varchar2 default hr_api.g_varchar2,
825: p_attribute16 in varchar2 default hr_api.g_varchar2,
826: p_attribute17 in varchar2 default hr_api.g_varchar2,
819: p_attribute10 in varchar2 default hr_api.g_varchar2,
820: p_attribute11 in varchar2 default hr_api.g_varchar2,
821: p_attribute12 in varchar2 default hr_api.g_varchar2,
822: p_attribute13 in varchar2 default hr_api.g_varchar2,
823: p_attribute14 in varchar2 default hr_api.g_varchar2,
824: p_attribute15 in varchar2 default hr_api.g_varchar2,
825: p_attribute16 in varchar2 default hr_api.g_varchar2,
826: p_attribute17 in varchar2 default hr_api.g_varchar2,
827: p_attribute18 in varchar2 default hr_api.g_varchar2,
820: p_attribute11 in varchar2 default hr_api.g_varchar2,
821: p_attribute12 in varchar2 default hr_api.g_varchar2,
822: p_attribute13 in varchar2 default hr_api.g_varchar2,
823: p_attribute14 in varchar2 default hr_api.g_varchar2,
824: p_attribute15 in varchar2 default hr_api.g_varchar2,
825: p_attribute16 in varchar2 default hr_api.g_varchar2,
826: p_attribute17 in varchar2 default hr_api.g_varchar2,
827: p_attribute18 in varchar2 default hr_api.g_varchar2,
828: p_attribute19 in varchar2 default hr_api.g_varchar2,
821: p_attribute12 in varchar2 default hr_api.g_varchar2,
822: p_attribute13 in varchar2 default hr_api.g_varchar2,
823: p_attribute14 in varchar2 default hr_api.g_varchar2,
824: p_attribute15 in varchar2 default hr_api.g_varchar2,
825: p_attribute16 in varchar2 default hr_api.g_varchar2,
826: p_attribute17 in varchar2 default hr_api.g_varchar2,
827: p_attribute18 in varchar2 default hr_api.g_varchar2,
828: p_attribute19 in varchar2 default hr_api.g_varchar2,
829: p_attribute20 in varchar2 default hr_api.g_varchar2,
822: p_attribute13 in varchar2 default hr_api.g_varchar2,
823: p_attribute14 in varchar2 default hr_api.g_varchar2,
824: p_attribute15 in varchar2 default hr_api.g_varchar2,
825: p_attribute16 in varchar2 default hr_api.g_varchar2,
826: p_attribute17 in varchar2 default hr_api.g_varchar2,
827: p_attribute18 in varchar2 default hr_api.g_varchar2,
828: p_attribute19 in varchar2 default hr_api.g_varchar2,
829: p_attribute20 in varchar2 default hr_api.g_varchar2,
830: p_effective_date in date,
823: p_attribute14 in varchar2 default hr_api.g_varchar2,
824: p_attribute15 in varchar2 default hr_api.g_varchar2,
825: p_attribute16 in varchar2 default hr_api.g_varchar2,
826: p_attribute17 in varchar2 default hr_api.g_varchar2,
827: p_attribute18 in varchar2 default hr_api.g_varchar2,
828: p_attribute19 in varchar2 default hr_api.g_varchar2,
829: p_attribute20 in varchar2 default hr_api.g_varchar2,
830: p_effective_date in date,
831: p_system_type in varchar2 default hr_api.g_varchar2,
824: p_attribute15 in varchar2 default hr_api.g_varchar2,
825: p_attribute16 in varchar2 default hr_api.g_varchar2,
826: p_attribute17 in varchar2 default hr_api.g_varchar2,
827: p_attribute18 in varchar2 default hr_api.g_varchar2,
828: p_attribute19 in varchar2 default hr_api.g_varchar2,
829: p_attribute20 in varchar2 default hr_api.g_varchar2,
830: p_effective_date in date,
831: p_system_type in varchar2 default hr_api.g_varchar2,
832: p_system_params in varchar2 default hr_api.g_varchar2,
825: p_attribute16 in varchar2 default hr_api.g_varchar2,
826: p_attribute17 in varchar2 default hr_api.g_varchar2,
827: p_attribute18 in varchar2 default hr_api.g_varchar2,
828: p_attribute19 in varchar2 default hr_api.g_varchar2,
829: p_attribute20 in varchar2 default hr_api.g_varchar2,
830: p_effective_date in date,
831: p_system_type in varchar2 default hr_api.g_varchar2,
832: p_system_params in varchar2 default hr_api.g_varchar2,
833: p_appraisee_access in varchar2 default hr_api.g_varchar2,
827: p_attribute18 in varchar2 default hr_api.g_varchar2,
828: p_attribute19 in varchar2 default hr_api.g_varchar2,
829: p_attribute20 in varchar2 default hr_api.g_varchar2,
830: p_effective_date in date,
831: p_system_type in varchar2 default hr_api.g_varchar2,
832: p_system_params in varchar2 default hr_api.g_varchar2,
833: p_appraisee_access in varchar2 default hr_api.g_varchar2,
834: p_main_appraiser_id in number default hr_api.g_number,
835: p_assignment_id in number default hr_api.g_number,
828: p_attribute19 in varchar2 default hr_api.g_varchar2,
829: p_attribute20 in varchar2 default hr_api.g_varchar2,
830: p_effective_date in date,
831: p_system_type in varchar2 default hr_api.g_varchar2,
832: p_system_params in varchar2 default hr_api.g_varchar2,
833: p_appraisee_access in varchar2 default hr_api.g_varchar2,
834: p_main_appraiser_id in number default hr_api.g_number,
835: p_assignment_id in number default hr_api.g_number,
836: p_assignment_start_date in date default hr_api.g_date,
829: p_attribute20 in varchar2 default hr_api.g_varchar2,
830: p_effective_date in date,
831: p_system_type in varchar2 default hr_api.g_varchar2,
832: p_system_params in varchar2 default hr_api.g_varchar2,
833: p_appraisee_access in varchar2 default hr_api.g_varchar2,
834: p_main_appraiser_id in number default hr_api.g_number,
835: p_assignment_id in number default hr_api.g_number,
836: p_assignment_start_date in date default hr_api.g_date,
837: p_asg_business_group_id in number default hr_api.g_number,
830: p_effective_date in date,
831: p_system_type in varchar2 default hr_api.g_varchar2,
832: p_system_params in varchar2 default hr_api.g_varchar2,
833: p_appraisee_access in varchar2 default hr_api.g_varchar2,
834: p_main_appraiser_id in number default hr_api.g_number,
835: p_assignment_id in number default hr_api.g_number,
836: p_assignment_start_date in date default hr_api.g_date,
837: p_asg_business_group_id in number default hr_api.g_number,
838: p_assignment_organization_id in number default hr_api.g_number,
831: p_system_type in varchar2 default hr_api.g_varchar2,
832: p_system_params in varchar2 default hr_api.g_varchar2,
833: p_appraisee_access in varchar2 default hr_api.g_varchar2,
834: p_main_appraiser_id in number default hr_api.g_number,
835: p_assignment_id in number default hr_api.g_number,
836: p_assignment_start_date in date default hr_api.g_date,
837: p_asg_business_group_id in number default hr_api.g_number,
838: p_assignment_organization_id in number default hr_api.g_number,
839: p_assignment_job_id in number default hr_api.g_number,
832: p_system_params in varchar2 default hr_api.g_varchar2,
833: p_appraisee_access in varchar2 default hr_api.g_varchar2,
834: p_main_appraiser_id in number default hr_api.g_number,
835: p_assignment_id in number default hr_api.g_number,
836: p_assignment_start_date in date default hr_api.g_date,
837: p_asg_business_group_id in number default hr_api.g_number,
838: p_assignment_organization_id in number default hr_api.g_number,
839: p_assignment_job_id in number default hr_api.g_number,
840: p_assignment_position_id in number default hr_api.g_number,
833: p_appraisee_access in varchar2 default hr_api.g_varchar2,
834: p_main_appraiser_id in number default hr_api.g_number,
835: p_assignment_id in number default hr_api.g_number,
836: p_assignment_start_date in date default hr_api.g_date,
837: p_asg_business_group_id in number default hr_api.g_number,
838: p_assignment_organization_id in number default hr_api.g_number,
839: p_assignment_job_id in number default hr_api.g_number,
840: p_assignment_position_id in number default hr_api.g_number,
841: p_assignment_grade_id in number default hr_api.g_number,
834: p_main_appraiser_id in number default hr_api.g_number,
835: p_assignment_id in number default hr_api.g_number,
836: p_assignment_start_date in date default hr_api.g_date,
837: p_asg_business_group_id in number default hr_api.g_number,
838: p_assignment_organization_id in number default hr_api.g_number,
839: p_assignment_job_id in number default hr_api.g_number,
840: p_assignment_position_id in number default hr_api.g_number,
841: p_assignment_grade_id in number default hr_api.g_number,
842: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
835: p_assignment_id in number default hr_api.g_number,
836: p_assignment_start_date in date default hr_api.g_date,
837: p_asg_business_group_id in number default hr_api.g_number,
838: p_assignment_organization_id in number default hr_api.g_number,
839: p_assignment_job_id in number default hr_api.g_number,
840: p_assignment_position_id in number default hr_api.g_number,
841: p_assignment_grade_id in number default hr_api.g_number,
842: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
843: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
836: p_assignment_start_date in date default hr_api.g_date,
837: p_asg_business_group_id in number default hr_api.g_number,
838: p_assignment_organization_id in number default hr_api.g_number,
839: p_assignment_job_id in number default hr_api.g_number,
840: p_assignment_position_id in number default hr_api.g_number,
841: p_assignment_grade_id in number default hr_api.g_number,
842: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
843: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
844: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
837: p_asg_business_group_id in number default hr_api.g_number,
838: p_assignment_organization_id in number default hr_api.g_number,
839: p_assignment_job_id in number default hr_api.g_number,
840: p_assignment_position_id in number default hr_api.g_number,
841: p_assignment_grade_id in number default hr_api.g_number,
842: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
843: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
844: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
845: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
838: p_assignment_organization_id in number default hr_api.g_number,
839: p_assignment_job_id in number default hr_api.g_number,
840: p_assignment_position_id in number default hr_api.g_number,
841: p_assignment_grade_id in number default hr_api.g_number,
842: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
843: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
844: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
845: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
846: p_potential_details in varchar2 default hr_api.g_varchar2,
839: p_assignment_job_id in number default hr_api.g_number,
840: p_assignment_position_id in number default hr_api.g_number,
841: p_assignment_grade_id in number default hr_api.g_number,
842: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
843: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
844: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
845: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
846: p_potential_details in varchar2 default hr_api.g_varchar2,
847: p_event_id in number default hr_api.g_number,
840: p_assignment_position_id in number default hr_api.g_number,
841: p_assignment_grade_id in number default hr_api.g_number,
842: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
843: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
844: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
845: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
846: p_potential_details in varchar2 default hr_api.g_varchar2,
847: p_event_id in number default hr_api.g_number,
848: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
841: p_assignment_grade_id in number default hr_api.g_number,
842: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
843: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
844: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
845: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
846: p_potential_details in varchar2 default hr_api.g_varchar2,
847: p_event_id in number default hr_api.g_number,
848: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
849: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
842: p_appraisal_system_status in varchar2 default hr_api.g_varchar2,
843: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
844: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
845: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
846: p_potential_details in varchar2 default hr_api.g_varchar2,
847: p_event_id in number default hr_api.g_number,
848: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
849: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
850: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
843: p_potential_readiness_level in varchar2 default hr_api.g_varchar2,
844: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
845: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
846: p_potential_details in varchar2 default hr_api.g_varchar2,
847: p_event_id in number default hr_api.g_number,
848: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
849: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
850: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
851: p_show_participant_details in varchar2 default hr_api.g_varchar2,
844: p_potential_short_term_workopp in varchar2 default hr_api.g_varchar2,
845: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
846: p_potential_details in varchar2 default hr_api.g_varchar2,
847: p_event_id in number default hr_api.g_number,
848: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
849: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
850: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
851: p_show_participant_details in varchar2 default hr_api.g_varchar2,
852: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
845: p_potential_long_term_workopp in varchar2 default hr_api.g_varchar2,
846: p_potential_details in varchar2 default hr_api.g_varchar2,
847: p_event_id in number default hr_api.g_number,
848: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
849: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
850: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
851: p_show_participant_details in varchar2 default hr_api.g_varchar2,
852: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
853: p_show_participant_names in varchar2 default hr_api.g_varchar2,
846: p_potential_details in varchar2 default hr_api.g_varchar2,
847: p_event_id in number default hr_api.g_number,
848: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
849: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
850: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
851: p_show_participant_details in varchar2 default hr_api.g_varchar2,
852: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
853: p_show_participant_names in varchar2 default hr_api.g_varchar2,
854: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
847: p_event_id in number default hr_api.g_number,
848: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
849: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
850: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
851: p_show_participant_details in varchar2 default hr_api.g_varchar2,
852: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
853: p_show_participant_names in varchar2 default hr_api.g_varchar2,
854: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
855: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
848: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
849: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
850: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
851: p_show_participant_details in varchar2 default hr_api.g_varchar2,
852: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
853: p_show_participant_names in varchar2 default hr_api.g_varchar2,
854: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
855: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
856: p_update_appraisal in varchar2 default hr_api.g_varchar2,
849: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
850: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
851: p_show_participant_details in varchar2 default hr_api.g_varchar2,
852: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
853: p_show_participant_names in varchar2 default hr_api.g_varchar2,
854: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
855: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
856: p_update_appraisal in varchar2 default hr_api.g_varchar2,
857: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
850: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
851: p_show_participant_details in varchar2 default hr_api.g_varchar2,
852: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
853: p_show_participant_names in varchar2 default hr_api.g_varchar2,
854: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
855: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
856: p_update_appraisal in varchar2 default hr_api.g_varchar2,
857: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
858: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
851: p_show_participant_details in varchar2 default hr_api.g_varchar2,
852: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
853: p_show_participant_names in varchar2 default hr_api.g_varchar2,
854: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
855: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
856: p_update_appraisal in varchar2 default hr_api.g_varchar2,
857: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
858: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
859: p_plan_id in number default hr_api.g_number,
852: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
853: p_show_participant_names in varchar2 default hr_api.g_varchar2,
854: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
855: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
856: p_update_appraisal in varchar2 default hr_api.g_varchar2,
857: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
858: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
859: p_plan_id in number default hr_api.g_number,
860: p_offline_status in varchar2 default hr_api.g_varchar2,
853: p_show_participant_names in varchar2 default hr_api.g_varchar2,
854: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
855: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
856: p_update_appraisal in varchar2 default hr_api.g_varchar2,
857: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
858: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
859: p_plan_id in number default hr_api.g_number,
860: p_offline_status in varchar2 default hr_api.g_varchar2,
861: p_retention_potential in varchar2 default hr_api.g_varchar2,
854: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
855: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
856: p_update_appraisal in varchar2 default hr_api.g_varchar2,
857: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
858: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
859: p_plan_id in number default hr_api.g_number,
860: p_offline_status in varchar2 default hr_api.g_varchar2,
861: p_retention_potential in varchar2 default hr_api.g_varchar2,
862: p_validate in boolean default false,
855: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
856: p_update_appraisal in varchar2 default hr_api.g_varchar2,
857: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
858: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
859: p_plan_id in number default hr_api.g_number,
860: p_offline_status in varchar2 default hr_api.g_varchar2,
861: p_retention_potential in varchar2 default hr_api.g_varchar2,
862: p_validate in boolean default false,
863: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
856: p_update_appraisal in varchar2 default hr_api.g_varchar2,
857: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
858: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
859: p_plan_id in number default hr_api.g_number,
860: p_offline_status in varchar2 default hr_api.g_varchar2,
861: p_retention_potential in varchar2 default hr_api.g_varchar2,
862: p_validate in boolean default false,
863: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
864: ) is
857: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
858: p_appraisee_comments in varchar2 default hr_api.g_varchar2,
859: p_plan_id in number default hr_api.g_number,
860: p_offline_status in varchar2 default hr_api.g_varchar2,
861: p_retention_potential in varchar2 default hr_api.g_varchar2,
862: p_validate in boolean default false,
863: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
864: ) is
865:
859: p_plan_id in number default hr_api.g_number,
860: p_offline_status in varchar2 default hr_api.g_varchar2,
861: p_retention_potential in varchar2 default hr_api.g_varchar2,
862: p_validate in boolean default false,
863: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
864: ) is
865:
866: l_rec per_apr_shd.g_rec_type;
867: l_proc varchar2(72) := g_package||'upd';
875: l_rec :=
876: per_apr_shd.convert_args
877: (
878: p_appraisal_id,
879: hr_api.g_number,
880: p_object_version_number,
881: hr_api.g_number,
882: hr_api.g_number,
883: p_appraiser_person_id,
877: (
878: p_appraisal_id,
879: hr_api.g_number,
880: p_object_version_number,
881: hr_api.g_number,
882: hr_api.g_number,
883: p_appraiser_person_id,
884: p_appraisal_date,
885: p_appraisal_period_end_date,
878: p_appraisal_id,
879: hr_api.g_number,
880: p_object_version_number,
881: hr_api.g_number,
882: hr_api.g_number,
883: p_appraiser_person_id,
884: p_appraisal_date,
885: p_appraisal_period_end_date,
886: p_appraisal_period_start_date,
886: p_appraisal_period_start_date,
887: p_type,
888: p_next_appraisal_date,
889: p_status,
890: hr_api.g_date,
891: hr_api.g_number,
892: p_comments,
893: p_overall_performance_level_id,
894: p_open,
887: p_type,
888: p_next_appraisal_date,
889: p_status,
890: hr_api.g_date,
891: hr_api.g_number,
892: p_comments,
893: p_overall_performance_level_id,
894: p_open,
895: p_attribute_category,