125:
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127:
128: Exception
129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: per_apt_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
128: Exception
129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: per_apt_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: per_apt_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: per_apt_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: per_apt_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: per_apt_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_apt_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: per_apt_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_apt_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_apt_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: Raise;
143: End update_dml;
144:
352:
353: );
354:
355: exception
356: when hr_api.cannot_find_prog_unit then
357: hr_api.cannot_find_prog_unit_error
358: ( p_module_name => 'PER_APPRAISAL_TEMPLATES'
359: ,p_hook_type => 'AU'
360: );
353: );
354:
355: exception
356: when hr_api.cannot_find_prog_unit then
357: hr_api.cannot_find_prog_unit_error
358: ( p_module_name => 'PER_APPRAISAL_TEMPLATES'
359: ,p_hook_type => 'AU'
360: );
361: end;
420: -- p_rec plsql record structure
421: -- to see if a system default is being used. If a system default
422: -- is being used then we must set to the 'current' argument value.
423:
424: If (p_rec.business_group_id = hr_api.g_number) then
425: p_rec.business_group_id :=
426: per_apt_shd.g_old_rec.business_group_id;
427: End If;
428: If (p_rec.name = hr_api.g_varchar2) then
424: If (p_rec.business_group_id = hr_api.g_number) then
425: p_rec.business_group_id :=
426: per_apt_shd.g_old_rec.business_group_id;
427: End If;
428: If (p_rec.name = hr_api.g_varchar2) then
429: p_rec.name :=
430: per_apt_shd.g_old_rec.name;
431: End If;
432: If (p_rec.description = hr_api.g_varchar2) then
428: If (p_rec.name = hr_api.g_varchar2) then
429: p_rec.name :=
430: per_apt_shd.g_old_rec.name;
431: End If;
432: If (p_rec.description = hr_api.g_varchar2) then
433: p_rec.description :=
434: per_apt_shd.g_old_rec.description;
435: End If;
436: If (p_rec.instructions = hr_api.g_varchar2) then
432: If (p_rec.description = hr_api.g_varchar2) then
433: p_rec.description :=
434: per_apt_shd.g_old_rec.description;
435: End If;
436: If (p_rec.instructions = hr_api.g_varchar2) then
437: p_rec.instructions :=
438: per_apt_shd.g_old_rec.instructions;
439: End If;
440: If (p_rec.date_from = hr_api.g_date) then
436: If (p_rec.instructions = hr_api.g_varchar2) then
437: p_rec.instructions :=
438: per_apt_shd.g_old_rec.instructions;
439: End If;
440: If (p_rec.date_from = hr_api.g_date) then
441: p_rec.date_from :=
442: per_apt_shd.g_old_rec.date_from;
443: End If;
444: If (p_rec.date_to = hr_api.g_date) then
440: If (p_rec.date_from = hr_api.g_date) then
441: p_rec.date_from :=
442: per_apt_shd.g_old_rec.date_from;
443: End If;
444: If (p_rec.date_to = hr_api.g_date) then
445: p_rec.date_to :=
446: per_apt_shd.g_old_rec.date_to;
447: End If;
448: If (p_rec.assessment_type_id = hr_api.g_number) then
444: If (p_rec.date_to = hr_api.g_date) then
445: p_rec.date_to :=
446: per_apt_shd.g_old_rec.date_to;
447: End If;
448: If (p_rec.assessment_type_id = hr_api.g_number) then
449: p_rec.assessment_type_id :=
450: per_apt_shd.g_old_rec.assessment_type_id;
451: End If;
452: If (p_rec.rating_scale_id = hr_api.g_number) then
448: If (p_rec.assessment_type_id = hr_api.g_number) then
449: p_rec.assessment_type_id :=
450: per_apt_shd.g_old_rec.assessment_type_id;
451: End If;
452: If (p_rec.rating_scale_id = hr_api.g_number) then
453: p_rec.rating_scale_id :=
454: per_apt_shd.g_old_rec.rating_scale_id;
455: End If;
456: If (p_rec.questionnaire_template_id = hr_api.g_number) then
452: If (p_rec.rating_scale_id = hr_api.g_number) then
453: p_rec.rating_scale_id :=
454: per_apt_shd.g_old_rec.rating_scale_id;
455: End If;
456: If (p_rec.questionnaire_template_id = hr_api.g_number) then
457: p_rec.questionnaire_template_id :=
458: per_apt_shd.g_old_rec.questionnaire_template_id;
459: End If;
460: If (p_rec.attribute_category = hr_api.g_varchar2) then
456: If (p_rec.questionnaire_template_id = hr_api.g_number) then
457: p_rec.questionnaire_template_id :=
458: per_apt_shd.g_old_rec.questionnaire_template_id;
459: End If;
460: If (p_rec.attribute_category = hr_api.g_varchar2) then
461: p_rec.attribute_category :=
462: per_apt_shd.g_old_rec.attribute_category;
463: End If;
464: If (p_rec.attribute1 = hr_api.g_varchar2) then
460: If (p_rec.attribute_category = hr_api.g_varchar2) then
461: p_rec.attribute_category :=
462: per_apt_shd.g_old_rec.attribute_category;
463: End If;
464: If (p_rec.attribute1 = hr_api.g_varchar2) then
465: p_rec.attribute1 :=
466: per_apt_shd.g_old_rec.attribute1;
467: End If;
468: If (p_rec.attribute2 = hr_api.g_varchar2) then
464: If (p_rec.attribute1 = hr_api.g_varchar2) then
465: p_rec.attribute1 :=
466: per_apt_shd.g_old_rec.attribute1;
467: End If;
468: If (p_rec.attribute2 = hr_api.g_varchar2) then
469: p_rec.attribute2 :=
470: per_apt_shd.g_old_rec.attribute2;
471: End If;
472: If (p_rec.attribute3 = hr_api.g_varchar2) then
468: If (p_rec.attribute2 = hr_api.g_varchar2) then
469: p_rec.attribute2 :=
470: per_apt_shd.g_old_rec.attribute2;
471: End If;
472: If (p_rec.attribute3 = hr_api.g_varchar2) then
473: p_rec.attribute3 :=
474: per_apt_shd.g_old_rec.attribute3;
475: End If;
476: If (p_rec.attribute4 = hr_api.g_varchar2) then
472: If (p_rec.attribute3 = hr_api.g_varchar2) then
473: p_rec.attribute3 :=
474: per_apt_shd.g_old_rec.attribute3;
475: End If;
476: If (p_rec.attribute4 = hr_api.g_varchar2) then
477: p_rec.attribute4 :=
478: per_apt_shd.g_old_rec.attribute4;
479: End If;
480: If (p_rec.attribute5 = hr_api.g_varchar2) then
476: If (p_rec.attribute4 = hr_api.g_varchar2) then
477: p_rec.attribute4 :=
478: per_apt_shd.g_old_rec.attribute4;
479: End If;
480: If (p_rec.attribute5 = hr_api.g_varchar2) then
481: p_rec.attribute5 :=
482: per_apt_shd.g_old_rec.attribute5;
483: End If;
484: If (p_rec.attribute6 = hr_api.g_varchar2) then
480: If (p_rec.attribute5 = hr_api.g_varchar2) then
481: p_rec.attribute5 :=
482: per_apt_shd.g_old_rec.attribute5;
483: End If;
484: If (p_rec.attribute6 = hr_api.g_varchar2) then
485: p_rec.attribute6 :=
486: per_apt_shd.g_old_rec.attribute6;
487: End If;
488: If (p_rec.attribute7 = hr_api.g_varchar2) then
484: If (p_rec.attribute6 = hr_api.g_varchar2) then
485: p_rec.attribute6 :=
486: per_apt_shd.g_old_rec.attribute6;
487: End If;
488: If (p_rec.attribute7 = hr_api.g_varchar2) then
489: p_rec.attribute7 :=
490: per_apt_shd.g_old_rec.attribute7;
491: End If;
492: If (p_rec.attribute8 = hr_api.g_varchar2) then
488: If (p_rec.attribute7 = hr_api.g_varchar2) then
489: p_rec.attribute7 :=
490: per_apt_shd.g_old_rec.attribute7;
491: End If;
492: If (p_rec.attribute8 = hr_api.g_varchar2) then
493: p_rec.attribute8 :=
494: per_apt_shd.g_old_rec.attribute8;
495: End If;
496: If (p_rec.attribute9 = hr_api.g_varchar2) then
492: If (p_rec.attribute8 = hr_api.g_varchar2) then
493: p_rec.attribute8 :=
494: per_apt_shd.g_old_rec.attribute8;
495: End If;
496: If (p_rec.attribute9 = hr_api.g_varchar2) then
497: p_rec.attribute9 :=
498: per_apt_shd.g_old_rec.attribute9;
499: End If;
500: If (p_rec.attribute10 = hr_api.g_varchar2) then
496: If (p_rec.attribute9 = hr_api.g_varchar2) then
497: p_rec.attribute9 :=
498: per_apt_shd.g_old_rec.attribute9;
499: End If;
500: If (p_rec.attribute10 = hr_api.g_varchar2) then
501: p_rec.attribute10 :=
502: per_apt_shd.g_old_rec.attribute10;
503: End If;
504: If (p_rec.attribute11 = hr_api.g_varchar2) then
500: If (p_rec.attribute10 = hr_api.g_varchar2) then
501: p_rec.attribute10 :=
502: per_apt_shd.g_old_rec.attribute10;
503: End If;
504: If (p_rec.attribute11 = hr_api.g_varchar2) then
505: p_rec.attribute11 :=
506: per_apt_shd.g_old_rec.attribute11;
507: End If;
508: If (p_rec.attribute12 = hr_api.g_varchar2) then
504: If (p_rec.attribute11 = hr_api.g_varchar2) then
505: p_rec.attribute11 :=
506: per_apt_shd.g_old_rec.attribute11;
507: End If;
508: If (p_rec.attribute12 = hr_api.g_varchar2) then
509: p_rec.attribute12 :=
510: per_apt_shd.g_old_rec.attribute12;
511: End If;
512: If (p_rec.attribute13 = hr_api.g_varchar2) then
508: If (p_rec.attribute12 = hr_api.g_varchar2) then
509: p_rec.attribute12 :=
510: per_apt_shd.g_old_rec.attribute12;
511: End If;
512: If (p_rec.attribute13 = hr_api.g_varchar2) then
513: p_rec.attribute13 :=
514: per_apt_shd.g_old_rec.attribute13;
515: End If;
516: If (p_rec.attribute14 = hr_api.g_varchar2) then
512: If (p_rec.attribute13 = hr_api.g_varchar2) then
513: p_rec.attribute13 :=
514: per_apt_shd.g_old_rec.attribute13;
515: End If;
516: If (p_rec.attribute14 = hr_api.g_varchar2) then
517: p_rec.attribute14 :=
518: per_apt_shd.g_old_rec.attribute14;
519: End If;
520: If (p_rec.attribute15 = hr_api.g_varchar2) then
516: If (p_rec.attribute14 = hr_api.g_varchar2) then
517: p_rec.attribute14 :=
518: per_apt_shd.g_old_rec.attribute14;
519: End If;
520: If (p_rec.attribute15 = hr_api.g_varchar2) then
521: p_rec.attribute15 :=
522: per_apt_shd.g_old_rec.attribute15;
523: End If;
524: If (p_rec.attribute16 = hr_api.g_varchar2) then
520: If (p_rec.attribute15 = hr_api.g_varchar2) then
521: p_rec.attribute15 :=
522: per_apt_shd.g_old_rec.attribute15;
523: End If;
524: If (p_rec.attribute16 = hr_api.g_varchar2) then
525: p_rec.attribute16 :=
526: per_apt_shd.g_old_rec.attribute16;
527: End If;
528: If (p_rec.attribute17 = hr_api.g_varchar2) then
524: If (p_rec.attribute16 = hr_api.g_varchar2) then
525: p_rec.attribute16 :=
526: per_apt_shd.g_old_rec.attribute16;
527: End If;
528: If (p_rec.attribute17 = hr_api.g_varchar2) then
529: p_rec.attribute17 :=
530: per_apt_shd.g_old_rec.attribute17;
531: End If;
532: If (p_rec.attribute18 = hr_api.g_varchar2) then
528: If (p_rec.attribute17 = hr_api.g_varchar2) then
529: p_rec.attribute17 :=
530: per_apt_shd.g_old_rec.attribute17;
531: End If;
532: If (p_rec.attribute18 = hr_api.g_varchar2) then
533: p_rec.attribute18 :=
534: per_apt_shd.g_old_rec.attribute18;
535: End If;
536: If (p_rec.attribute19 = hr_api.g_varchar2) then
532: If (p_rec.attribute18 = hr_api.g_varchar2) then
533: p_rec.attribute18 :=
534: per_apt_shd.g_old_rec.attribute18;
535: End If;
536: If (p_rec.attribute19 = hr_api.g_varchar2) then
537: p_rec.attribute19 :=
538: per_apt_shd.g_old_rec.attribute19;
539: End If;
540: If (p_rec.attribute20 = hr_api.g_varchar2) then
536: If (p_rec.attribute19 = hr_api.g_varchar2) then
537: p_rec.attribute19 :=
538: per_apt_shd.g_old_rec.attribute19;
539: End If;
540: If (p_rec.attribute20 = hr_api.g_varchar2) then
541: p_rec.attribute20 :=
542: per_apt_shd.g_old_rec.attribute20;
543: End If;
544: If (p_rec.objective_asmnt_type_id = hr_api.g_number) then
540: If (p_rec.attribute20 = hr_api.g_varchar2) then
541: p_rec.attribute20 :=
542: per_apt_shd.g_old_rec.attribute20;
543: End If;
544: If (p_rec.objective_asmnt_type_id = hr_api.g_number) then
545: p_rec.objective_asmnt_type_id :=
546: per_apt_shd.g_old_rec.objective_asmnt_type_id;
547: End If;
548: If (p_rec.ma_quest_template_id = hr_api.g_number) then
544: If (p_rec.objective_asmnt_type_id = hr_api.g_number) then
545: p_rec.objective_asmnt_type_id :=
546: per_apt_shd.g_old_rec.objective_asmnt_type_id;
547: End If;
548: If (p_rec.ma_quest_template_id = hr_api.g_number) then
549: p_rec.ma_quest_template_id :=
550: per_apt_shd.g_old_rec.ma_quest_template_id;
551: End If;
552: If (p_rec.link_appr_to_learning_path = hr_api.g_varchar2) then
548: If (p_rec.ma_quest_template_id = hr_api.g_number) then
549: p_rec.ma_quest_template_id :=
550: per_apt_shd.g_old_rec.ma_quest_template_id;
551: End If;
552: If (p_rec.link_appr_to_learning_path = hr_api.g_varchar2) then
553: p_rec.link_appr_to_learning_path :=
554: per_apt_shd.g_old_rec.link_appr_to_learning_path;
555: End If;
556: If (p_rec.final_score_formula_id = hr_api.g_number) then
552: If (p_rec.link_appr_to_learning_path = hr_api.g_varchar2) then
553: p_rec.link_appr_to_learning_path :=
554: per_apt_shd.g_old_rec.link_appr_to_learning_path;
555: End If;
556: If (p_rec.final_score_formula_id = hr_api.g_number) then
557: p_rec.final_score_formula_id :=
558: per_apt_shd.g_old_rec.final_score_formula_id;
559: End If;
560: If (p_rec.update_personal_comp_profile = hr_api.g_varchar2) then
556: If (p_rec.final_score_formula_id = hr_api.g_number) then
557: p_rec.final_score_formula_id :=
558: per_apt_shd.g_old_rec.final_score_formula_id;
559: End If;
560: If (p_rec.update_personal_comp_profile = hr_api.g_varchar2) then
561: p_rec.update_personal_comp_profile :=
562: per_apt_shd.g_old_rec.update_personal_comp_profile;
563: End If;
564: If (p_rec.comp_profile_source_type = hr_api.g_varchar2) then
560: If (p_rec.update_personal_comp_profile = hr_api.g_varchar2) then
561: p_rec.update_personal_comp_profile :=
562: per_apt_shd.g_old_rec.update_personal_comp_profile;
563: End If;
564: If (p_rec.comp_profile_source_type = hr_api.g_varchar2) then
565: p_rec.comp_profile_source_type :=
566: per_apt_shd.g_old_rec.comp_profile_source_type;
567: End If;
568: If (p_rec.show_competency_ratings = hr_api.g_varchar2) then
564: If (p_rec.comp_profile_source_type = hr_api.g_varchar2) then
565: p_rec.comp_profile_source_type :=
566: per_apt_shd.g_old_rec.comp_profile_source_type;
567: End If;
568: If (p_rec.show_competency_ratings = hr_api.g_varchar2) then
569: p_rec.show_competency_ratings :=
570: per_apt_shd.g_old_rec.show_competency_ratings;
571: End If;
572: If (p_rec.show_objective_ratings = hr_api.g_varchar2) then
568: If (p_rec.show_competency_ratings = hr_api.g_varchar2) then
569: p_rec.show_competency_ratings :=
570: per_apt_shd.g_old_rec.show_competency_ratings;
571: End If;
572: If (p_rec.show_objective_ratings = hr_api.g_varchar2) then
573: p_rec.show_objective_ratings :=
574: per_apt_shd.g_old_rec.show_objective_ratings;
575: End If;
576: If (p_rec.show_overall_ratings = hr_api.g_varchar2) then
572: If (p_rec.show_objective_ratings = hr_api.g_varchar2) then
573: p_rec.show_objective_ratings :=
574: per_apt_shd.g_old_rec.show_objective_ratings;
575: End If;
576: If (p_rec.show_overall_ratings = hr_api.g_varchar2) then
577: p_rec.show_overall_ratings :=
578: per_apt_shd.g_old_rec.show_overall_ratings;
579: End If;
580: If (p_rec.show_overall_comments = hr_api.g_varchar2) then
576: If (p_rec.show_overall_ratings = hr_api.g_varchar2) then
577: p_rec.show_overall_ratings :=
578: per_apt_shd.g_old_rec.show_overall_ratings;
579: End If;
580: If (p_rec.show_overall_comments = hr_api.g_varchar2) then
581: p_rec.show_overall_comments :=
582: per_apt_shd.g_old_rec.show_overall_comments;
583: End If;
584: If (p_rec.provide_overall_feedback = hr_api.g_varchar2) then
580: If (p_rec.show_overall_comments = hr_api.g_varchar2) then
581: p_rec.show_overall_comments :=
582: per_apt_shd.g_old_rec.show_overall_comments;
583: End If;
584: If (p_rec.provide_overall_feedback = hr_api.g_varchar2) then
585: p_rec.provide_overall_feedback :=
586: per_apt_shd.g_old_rec.provide_overall_feedback;
587: End If;
588: If (p_rec.show_participant_details = hr_api.g_varchar2) then
584: If (p_rec.provide_overall_feedback = hr_api.g_varchar2) then
585: p_rec.provide_overall_feedback :=
586: per_apt_shd.g_old_rec.provide_overall_feedback;
587: End If;
588: If (p_rec.show_participant_details = hr_api.g_varchar2) then
589: p_rec.show_participant_details :=
590: per_apt_shd.g_old_rec.show_participant_details;
591: End If;
592: If (p_rec.allow_add_participant = hr_api.g_varchar2) then
588: If (p_rec.show_participant_details = hr_api.g_varchar2) then
589: p_rec.show_participant_details :=
590: per_apt_shd.g_old_rec.show_participant_details;
591: End If;
592: If (p_rec.allow_add_participant = hr_api.g_varchar2) then
593: p_rec.allow_add_participant :=
594: per_apt_shd.g_old_rec.allow_add_participant;
595: End If;
596: If (p_rec.show_additional_details = hr_api.g_varchar2) then
592: If (p_rec.allow_add_participant = hr_api.g_varchar2) then
593: p_rec.allow_add_participant :=
594: per_apt_shd.g_old_rec.allow_add_participant;
595: End If;
596: If (p_rec.show_additional_details = hr_api.g_varchar2) then
597: p_rec.show_additional_details :=
598: per_apt_shd.g_old_rec.show_additional_details;
599: End If;
600: If (p_rec.show_participant_names = hr_api.g_varchar2) then
596: If (p_rec.show_additional_details = hr_api.g_varchar2) then
597: p_rec.show_additional_details :=
598: per_apt_shd.g_old_rec.show_additional_details;
599: End If;
600: If (p_rec.show_participant_names = hr_api.g_varchar2) then
601: p_rec.show_participant_names :=
602: per_apt_shd.g_old_rec.show_participant_names;
603: End If;
604: If (p_rec.show_participant_ratings = hr_api.g_varchar2) then
600: If (p_rec.show_participant_names = hr_api.g_varchar2) then
601: p_rec.show_participant_names :=
602: per_apt_shd.g_old_rec.show_participant_names;
603: End If;
604: If (p_rec.show_participant_ratings = hr_api.g_varchar2) then
605: p_rec.show_participant_ratings :=
606: per_apt_shd.g_old_rec.show_participant_ratings;
607: End If;
608: If (p_rec.available_flag = hr_api.g_varchar2) then
604: If (p_rec.show_participant_ratings = hr_api.g_varchar2) then
605: p_rec.show_participant_ratings :=
606: per_apt_shd.g_old_rec.show_participant_ratings;
607: End If;
608: If (p_rec.available_flag = hr_api.g_varchar2) then
609: p_rec.available_flag :=
610: per_apt_shd.g_old_rec.available_flag;
611: End If;
612: If (p_rec.show_questionnaire_info = hr_api.g_varchar2) then
608: If (p_rec.available_flag = hr_api.g_varchar2) then
609: p_rec.available_flag :=
610: per_apt_shd.g_old_rec.available_flag;
611: End If;
612: If (p_rec.show_questionnaire_info = hr_api.g_varchar2) then
613: p_rec.show_questionnaire_info :=
614: per_apt_shd.g_old_rec.show_questionnaire_info;
615: End If;
616: If (p_rec.ma_off_template_code =hr_api.g_varchar2) then
612: If (p_rec.show_questionnaire_info = hr_api.g_varchar2) then
613: p_rec.show_questionnaire_info :=
614: per_apt_shd.g_old_rec.show_questionnaire_info;
615: End If;
616: If (p_rec.ma_off_template_code =hr_api.g_varchar2) then
617: p_rec.ma_off_template_code :=
618: per_apt_shd.g_old_rec.ma_off_template_code;
619: End If;
620: If (p_rec.appraisee_off_template_code =hr_api.g_varchar2) then
616: If (p_rec.ma_off_template_code =hr_api.g_varchar2) then
617: p_rec.ma_off_template_code :=
618: per_apt_shd.g_old_rec.ma_off_template_code;
619: End If;
620: If (p_rec.appraisee_off_template_code =hr_api.g_varchar2) then
621: p_rec.appraisee_off_template_code :=
622: per_apt_shd.g_old_rec.appraisee_off_template_code;
623: End If;
624: If (p_rec.other_part_off_template_code =hr_api.g_varchar2) then
620: If (p_rec.appraisee_off_template_code =hr_api.g_varchar2) then
621: p_rec.appraisee_off_template_code :=
622: per_apt_shd.g_old_rec.appraisee_off_template_code;
623: End If;
624: If (p_rec.other_part_off_template_code =hr_api.g_varchar2) then
625: p_rec.other_part_off_template_code :=
626: per_apt_shd.g_old_rec.other_part_off_template_code;
627: End If;
628: If (p_rec.part_rev_off_template_code =hr_api.g_varchar2) then
624: If (p_rec.other_part_off_template_code =hr_api.g_varchar2) then
625: p_rec.other_part_off_template_code :=
626: per_apt_shd.g_old_rec.other_part_off_template_code;
627: End If;
628: If (p_rec.part_rev_off_template_code =hr_api.g_varchar2) then
629: p_rec.part_rev_off_template_code :=
630: per_apt_shd.g_old_rec.part_rev_off_template_code;
631: End If;
632: If (p_rec.part_app_off_template_code =hr_api.g_varchar2) then
628: If (p_rec.part_rev_off_template_code =hr_api.g_varchar2) then
629: p_rec.part_rev_off_template_code :=
630: per_apt_shd.g_old_rec.part_rev_off_template_code;
631: End If;
632: If (p_rec.part_app_off_template_code =hr_api.g_varchar2) then
633: p_rec.part_app_off_template_code :=
634: per_apt_shd.g_old_rec.part_app_off_template_code ;
635: End If;
636:
634: per_apt_shd.g_old_rec.part_app_off_template_code ;
635: End If;
636:
637: -- 8651478 bug fix
638: If (p_rec.show_participant_comments = hr_api.g_varchar2) then
639: p_rec.show_participant_comments :=
640: per_apt_shd.g_old_rec.show_participant_comments;
641: End If;
642:
640: per_apt_shd.g_old_rec.show_participant_comments;
641: End If;
642:
643:
644: If (p_rec.show_term_employee = hr_api.g_varchar2) then
645: p_rec.show_term_employee :=
646: per_apt_shd.g_old_rec.show_term_employee;
647: End If;
648:
645: p_rec.show_term_employee :=
646: per_apt_shd.g_old_rec.show_term_employee;
647: End If;
648:
649: If (p_rec.show_term_contigent = hr_api.g_varchar2) then
650: p_rec.show_term_contigent :=
651: per_apt_shd.g_old_rec.show_term_contigent;
652: End If;
653:
650: p_rec.show_term_contigent :=
651: per_apt_shd.g_old_rec.show_term_contigent;
652: End If;
653:
654: If (p_rec.disp_term_emp_period_from = hr_api.g_number) then
655: p_rec.disp_term_emp_period_from :=
656: per_apt_shd.g_old_rec.disp_term_emp_period_from;
657: End If;
658:
655: p_rec.disp_term_emp_period_from :=
656: per_apt_shd.g_old_rec.disp_term_emp_period_from;
657: End If;
658:
659: If (p_rec.show_future_term_employee = hr_api.g_varchar2) then
660: p_rec.show_future_term_employee :=
661: per_apt_shd.g_old_rec.show_future_term_employee;
662: End If;
663:
721:
722: -- If we are validating then raise the Validate_Enabled exception
723:
724: If p_validate then
725: Raise HR_Api.Validate_Enabled;
726: End If;
727:
728: hr_utility.set_location(' Leaving:'||l_proc, 10);
729: Exception
726: End If;
727:
728: hr_utility.set_location(' Leaving:'||l_proc, 10);
729: Exception
730: When HR_Api.Validate_Enabled Then
731:
732: -- As the Validate_Enabled exception has been raised
733: -- we must rollback to the savepoint
734:
741: Procedure upd
742: (
743: p_appraisal_template_id in number,
744: p_object_version_number in out nocopy number,
745: p_name in varchar2 default hr_api.g_varchar2,
746: p_description in varchar2 default hr_api.g_varchar2,
747: p_instructions in varchar2 default hr_api.g_varchar2,
748: p_date_from in date default hr_api.g_date,
749: p_date_to in date default hr_api.g_date,
742: (
743: p_appraisal_template_id in number,
744: p_object_version_number in out nocopy number,
745: p_name in varchar2 default hr_api.g_varchar2,
746: p_description in varchar2 default hr_api.g_varchar2,
747: p_instructions in varchar2 default hr_api.g_varchar2,
748: p_date_from in date default hr_api.g_date,
749: p_date_to in date default hr_api.g_date,
750: p_assessment_type_id in number default hr_api.g_number,
743: p_appraisal_template_id in number,
744: p_object_version_number in out nocopy number,
745: p_name in varchar2 default hr_api.g_varchar2,
746: p_description in varchar2 default hr_api.g_varchar2,
747: p_instructions in varchar2 default hr_api.g_varchar2,
748: p_date_from in date default hr_api.g_date,
749: p_date_to in date default hr_api.g_date,
750: p_assessment_type_id in number default hr_api.g_number,
751: p_rating_scale_id in number default hr_api.g_number,
744: p_object_version_number in out nocopy number,
745: p_name in varchar2 default hr_api.g_varchar2,
746: p_description in varchar2 default hr_api.g_varchar2,
747: p_instructions in varchar2 default hr_api.g_varchar2,
748: p_date_from in date default hr_api.g_date,
749: p_date_to in date default hr_api.g_date,
750: p_assessment_type_id in number default hr_api.g_number,
751: p_rating_scale_id in number default hr_api.g_number,
752: p_questionnaire_template_id in number default hr_api.g_number,
745: p_name in varchar2 default hr_api.g_varchar2,
746: p_description in varchar2 default hr_api.g_varchar2,
747: p_instructions in varchar2 default hr_api.g_varchar2,
748: p_date_from in date default hr_api.g_date,
749: p_date_to in date default hr_api.g_date,
750: p_assessment_type_id in number default hr_api.g_number,
751: p_rating_scale_id in number default hr_api.g_number,
752: p_questionnaire_template_id in number default hr_api.g_number,
753: p_attribute_category in varchar2 default hr_api.g_varchar2,
746: p_description in varchar2 default hr_api.g_varchar2,
747: p_instructions in varchar2 default hr_api.g_varchar2,
748: p_date_from in date default hr_api.g_date,
749: p_date_to in date default hr_api.g_date,
750: p_assessment_type_id in number default hr_api.g_number,
751: p_rating_scale_id in number default hr_api.g_number,
752: p_questionnaire_template_id in number default hr_api.g_number,
753: p_attribute_category in varchar2 default hr_api.g_varchar2,
754: p_attribute1 in varchar2 default hr_api.g_varchar2,
747: p_instructions in varchar2 default hr_api.g_varchar2,
748: p_date_from in date default hr_api.g_date,
749: p_date_to in date default hr_api.g_date,
750: p_assessment_type_id in number default hr_api.g_number,
751: p_rating_scale_id in number default hr_api.g_number,
752: p_questionnaire_template_id in number default hr_api.g_number,
753: p_attribute_category in varchar2 default hr_api.g_varchar2,
754: p_attribute1 in varchar2 default hr_api.g_varchar2,
755: p_attribute2 in varchar2 default hr_api.g_varchar2,
748: p_date_from in date default hr_api.g_date,
749: p_date_to in date default hr_api.g_date,
750: p_assessment_type_id in number default hr_api.g_number,
751: p_rating_scale_id in number default hr_api.g_number,
752: p_questionnaire_template_id in number default hr_api.g_number,
753: p_attribute_category in varchar2 default hr_api.g_varchar2,
754: p_attribute1 in varchar2 default hr_api.g_varchar2,
755: p_attribute2 in varchar2 default hr_api.g_varchar2,
756: p_attribute3 in varchar2 default hr_api.g_varchar2,
749: p_date_to in date default hr_api.g_date,
750: p_assessment_type_id in number default hr_api.g_number,
751: p_rating_scale_id in number default hr_api.g_number,
752: p_questionnaire_template_id in number default hr_api.g_number,
753: p_attribute_category in varchar2 default hr_api.g_varchar2,
754: p_attribute1 in varchar2 default hr_api.g_varchar2,
755: p_attribute2 in varchar2 default hr_api.g_varchar2,
756: p_attribute3 in varchar2 default hr_api.g_varchar2,
757: p_attribute4 in varchar2 default hr_api.g_varchar2,
750: p_assessment_type_id in number default hr_api.g_number,
751: p_rating_scale_id in number default hr_api.g_number,
752: p_questionnaire_template_id in number default hr_api.g_number,
753: p_attribute_category in varchar2 default hr_api.g_varchar2,
754: p_attribute1 in varchar2 default hr_api.g_varchar2,
755: p_attribute2 in varchar2 default hr_api.g_varchar2,
756: p_attribute3 in varchar2 default hr_api.g_varchar2,
757: p_attribute4 in varchar2 default hr_api.g_varchar2,
758: p_attribute5 in varchar2 default hr_api.g_varchar2,
751: p_rating_scale_id in number default hr_api.g_number,
752: p_questionnaire_template_id in number default hr_api.g_number,
753: p_attribute_category in varchar2 default hr_api.g_varchar2,
754: p_attribute1 in varchar2 default hr_api.g_varchar2,
755: p_attribute2 in varchar2 default hr_api.g_varchar2,
756: p_attribute3 in varchar2 default hr_api.g_varchar2,
757: p_attribute4 in varchar2 default hr_api.g_varchar2,
758: p_attribute5 in varchar2 default hr_api.g_varchar2,
759: p_attribute6 in varchar2 default hr_api.g_varchar2,
752: p_questionnaire_template_id in number default hr_api.g_number,
753: p_attribute_category in varchar2 default hr_api.g_varchar2,
754: p_attribute1 in varchar2 default hr_api.g_varchar2,
755: p_attribute2 in varchar2 default hr_api.g_varchar2,
756: p_attribute3 in varchar2 default hr_api.g_varchar2,
757: p_attribute4 in varchar2 default hr_api.g_varchar2,
758: p_attribute5 in varchar2 default hr_api.g_varchar2,
759: p_attribute6 in varchar2 default hr_api.g_varchar2,
760: p_attribute7 in varchar2 default hr_api.g_varchar2,
753: p_attribute_category in varchar2 default hr_api.g_varchar2,
754: p_attribute1 in varchar2 default hr_api.g_varchar2,
755: p_attribute2 in varchar2 default hr_api.g_varchar2,
756: p_attribute3 in varchar2 default hr_api.g_varchar2,
757: p_attribute4 in varchar2 default hr_api.g_varchar2,
758: p_attribute5 in varchar2 default hr_api.g_varchar2,
759: p_attribute6 in varchar2 default hr_api.g_varchar2,
760: p_attribute7 in varchar2 default hr_api.g_varchar2,
761: p_attribute8 in varchar2 default hr_api.g_varchar2,
754: p_attribute1 in varchar2 default hr_api.g_varchar2,
755: p_attribute2 in varchar2 default hr_api.g_varchar2,
756: p_attribute3 in varchar2 default hr_api.g_varchar2,
757: p_attribute4 in varchar2 default hr_api.g_varchar2,
758: p_attribute5 in varchar2 default hr_api.g_varchar2,
759: p_attribute6 in varchar2 default hr_api.g_varchar2,
760: p_attribute7 in varchar2 default hr_api.g_varchar2,
761: p_attribute8 in varchar2 default hr_api.g_varchar2,
762: p_attribute9 in varchar2 default hr_api.g_varchar2,
755: p_attribute2 in varchar2 default hr_api.g_varchar2,
756: p_attribute3 in varchar2 default hr_api.g_varchar2,
757: p_attribute4 in varchar2 default hr_api.g_varchar2,
758: p_attribute5 in varchar2 default hr_api.g_varchar2,
759: p_attribute6 in varchar2 default hr_api.g_varchar2,
760: p_attribute7 in varchar2 default hr_api.g_varchar2,
761: p_attribute8 in varchar2 default hr_api.g_varchar2,
762: p_attribute9 in varchar2 default hr_api.g_varchar2,
763: p_attribute10 in varchar2 default hr_api.g_varchar2,
756: p_attribute3 in varchar2 default hr_api.g_varchar2,
757: p_attribute4 in varchar2 default hr_api.g_varchar2,
758: p_attribute5 in varchar2 default hr_api.g_varchar2,
759: p_attribute6 in varchar2 default hr_api.g_varchar2,
760: p_attribute7 in varchar2 default hr_api.g_varchar2,
761: p_attribute8 in varchar2 default hr_api.g_varchar2,
762: p_attribute9 in varchar2 default hr_api.g_varchar2,
763: p_attribute10 in varchar2 default hr_api.g_varchar2,
764: p_attribute11 in varchar2 default hr_api.g_varchar2,
757: p_attribute4 in varchar2 default hr_api.g_varchar2,
758: p_attribute5 in varchar2 default hr_api.g_varchar2,
759: p_attribute6 in varchar2 default hr_api.g_varchar2,
760: p_attribute7 in varchar2 default hr_api.g_varchar2,
761: p_attribute8 in varchar2 default hr_api.g_varchar2,
762: p_attribute9 in varchar2 default hr_api.g_varchar2,
763: p_attribute10 in varchar2 default hr_api.g_varchar2,
764: p_attribute11 in varchar2 default hr_api.g_varchar2,
765: p_attribute12 in varchar2 default hr_api.g_varchar2,
758: p_attribute5 in varchar2 default hr_api.g_varchar2,
759: p_attribute6 in varchar2 default hr_api.g_varchar2,
760: p_attribute7 in varchar2 default hr_api.g_varchar2,
761: p_attribute8 in varchar2 default hr_api.g_varchar2,
762: p_attribute9 in varchar2 default hr_api.g_varchar2,
763: p_attribute10 in varchar2 default hr_api.g_varchar2,
764: p_attribute11 in varchar2 default hr_api.g_varchar2,
765: p_attribute12 in varchar2 default hr_api.g_varchar2,
766: p_attribute13 in varchar2 default hr_api.g_varchar2,
759: p_attribute6 in varchar2 default hr_api.g_varchar2,
760: p_attribute7 in varchar2 default hr_api.g_varchar2,
761: p_attribute8 in varchar2 default hr_api.g_varchar2,
762: p_attribute9 in varchar2 default hr_api.g_varchar2,
763: p_attribute10 in varchar2 default hr_api.g_varchar2,
764: p_attribute11 in varchar2 default hr_api.g_varchar2,
765: p_attribute12 in varchar2 default hr_api.g_varchar2,
766: p_attribute13 in varchar2 default hr_api.g_varchar2,
767: p_attribute14 in varchar2 default hr_api.g_varchar2,
760: p_attribute7 in varchar2 default hr_api.g_varchar2,
761: p_attribute8 in varchar2 default hr_api.g_varchar2,
762: p_attribute9 in varchar2 default hr_api.g_varchar2,
763: p_attribute10 in varchar2 default hr_api.g_varchar2,
764: p_attribute11 in varchar2 default hr_api.g_varchar2,
765: p_attribute12 in varchar2 default hr_api.g_varchar2,
766: p_attribute13 in varchar2 default hr_api.g_varchar2,
767: p_attribute14 in varchar2 default hr_api.g_varchar2,
768: p_attribute15 in varchar2 default hr_api.g_varchar2,
761: p_attribute8 in varchar2 default hr_api.g_varchar2,
762: p_attribute9 in varchar2 default hr_api.g_varchar2,
763: p_attribute10 in varchar2 default hr_api.g_varchar2,
764: p_attribute11 in varchar2 default hr_api.g_varchar2,
765: p_attribute12 in varchar2 default hr_api.g_varchar2,
766: p_attribute13 in varchar2 default hr_api.g_varchar2,
767: p_attribute14 in varchar2 default hr_api.g_varchar2,
768: p_attribute15 in varchar2 default hr_api.g_varchar2,
769: p_attribute16 in varchar2 default hr_api.g_varchar2,
762: p_attribute9 in varchar2 default hr_api.g_varchar2,
763: p_attribute10 in varchar2 default hr_api.g_varchar2,
764: p_attribute11 in varchar2 default hr_api.g_varchar2,
765: p_attribute12 in varchar2 default hr_api.g_varchar2,
766: p_attribute13 in varchar2 default hr_api.g_varchar2,
767: p_attribute14 in varchar2 default hr_api.g_varchar2,
768: p_attribute15 in varchar2 default hr_api.g_varchar2,
769: p_attribute16 in varchar2 default hr_api.g_varchar2,
770: p_attribute17 in varchar2 default hr_api.g_varchar2,
763: p_attribute10 in varchar2 default hr_api.g_varchar2,
764: p_attribute11 in varchar2 default hr_api.g_varchar2,
765: p_attribute12 in varchar2 default hr_api.g_varchar2,
766: p_attribute13 in varchar2 default hr_api.g_varchar2,
767: p_attribute14 in varchar2 default hr_api.g_varchar2,
768: p_attribute15 in varchar2 default hr_api.g_varchar2,
769: p_attribute16 in varchar2 default hr_api.g_varchar2,
770: p_attribute17 in varchar2 default hr_api.g_varchar2,
771: p_attribute18 in varchar2 default hr_api.g_varchar2,
764: p_attribute11 in varchar2 default hr_api.g_varchar2,
765: p_attribute12 in varchar2 default hr_api.g_varchar2,
766: p_attribute13 in varchar2 default hr_api.g_varchar2,
767: p_attribute14 in varchar2 default hr_api.g_varchar2,
768: p_attribute15 in varchar2 default hr_api.g_varchar2,
769: p_attribute16 in varchar2 default hr_api.g_varchar2,
770: p_attribute17 in varchar2 default hr_api.g_varchar2,
771: p_attribute18 in varchar2 default hr_api.g_varchar2,
772: p_attribute19 in varchar2 default hr_api.g_varchar2,
765: p_attribute12 in varchar2 default hr_api.g_varchar2,
766: p_attribute13 in varchar2 default hr_api.g_varchar2,
767: p_attribute14 in varchar2 default hr_api.g_varchar2,
768: p_attribute15 in varchar2 default hr_api.g_varchar2,
769: p_attribute16 in varchar2 default hr_api.g_varchar2,
770: p_attribute17 in varchar2 default hr_api.g_varchar2,
771: p_attribute18 in varchar2 default hr_api.g_varchar2,
772: p_attribute19 in varchar2 default hr_api.g_varchar2,
773: p_attribute20 in varchar2 default hr_api.g_varchar2,
766: p_attribute13 in varchar2 default hr_api.g_varchar2,
767: p_attribute14 in varchar2 default hr_api.g_varchar2,
768: p_attribute15 in varchar2 default hr_api.g_varchar2,
769: p_attribute16 in varchar2 default hr_api.g_varchar2,
770: p_attribute17 in varchar2 default hr_api.g_varchar2,
771: p_attribute18 in varchar2 default hr_api.g_varchar2,
772: p_attribute19 in varchar2 default hr_api.g_varchar2,
773: p_attribute20 in varchar2 default hr_api.g_varchar2,
774: p_objective_asmnt_type_id in number default hr_api.g_number,
767: p_attribute14 in varchar2 default hr_api.g_varchar2,
768: p_attribute15 in varchar2 default hr_api.g_varchar2,
769: p_attribute16 in varchar2 default hr_api.g_varchar2,
770: p_attribute17 in varchar2 default hr_api.g_varchar2,
771: p_attribute18 in varchar2 default hr_api.g_varchar2,
772: p_attribute19 in varchar2 default hr_api.g_varchar2,
773: p_attribute20 in varchar2 default hr_api.g_varchar2,
774: p_objective_asmnt_type_id in number default hr_api.g_number,
775: p_ma_quest_template_id in number default hr_api.g_number,
768: p_attribute15 in varchar2 default hr_api.g_varchar2,
769: p_attribute16 in varchar2 default hr_api.g_varchar2,
770: p_attribute17 in varchar2 default hr_api.g_varchar2,
771: p_attribute18 in varchar2 default hr_api.g_varchar2,
772: p_attribute19 in varchar2 default hr_api.g_varchar2,
773: p_attribute20 in varchar2 default hr_api.g_varchar2,
774: p_objective_asmnt_type_id in number default hr_api.g_number,
775: p_ma_quest_template_id in number default hr_api.g_number,
776: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
769: p_attribute16 in varchar2 default hr_api.g_varchar2,
770: p_attribute17 in varchar2 default hr_api.g_varchar2,
771: p_attribute18 in varchar2 default hr_api.g_varchar2,
772: p_attribute19 in varchar2 default hr_api.g_varchar2,
773: p_attribute20 in varchar2 default hr_api.g_varchar2,
774: p_objective_asmnt_type_id in number default hr_api.g_number,
775: p_ma_quest_template_id in number default hr_api.g_number,
776: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
777: p_final_score_formula_id in number default hr_api.g_number,
770: p_attribute17 in varchar2 default hr_api.g_varchar2,
771: p_attribute18 in varchar2 default hr_api.g_varchar2,
772: p_attribute19 in varchar2 default hr_api.g_varchar2,
773: p_attribute20 in varchar2 default hr_api.g_varchar2,
774: p_objective_asmnt_type_id in number default hr_api.g_number,
775: p_ma_quest_template_id in number default hr_api.g_number,
776: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
777: p_final_score_formula_id in number default hr_api.g_number,
778: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
771: p_attribute18 in varchar2 default hr_api.g_varchar2,
772: p_attribute19 in varchar2 default hr_api.g_varchar2,
773: p_attribute20 in varchar2 default hr_api.g_varchar2,
774: p_objective_asmnt_type_id in number default hr_api.g_number,
775: p_ma_quest_template_id in number default hr_api.g_number,
776: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
777: p_final_score_formula_id in number default hr_api.g_number,
778: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
779: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
772: p_attribute19 in varchar2 default hr_api.g_varchar2,
773: p_attribute20 in varchar2 default hr_api.g_varchar2,
774: p_objective_asmnt_type_id in number default hr_api.g_number,
775: p_ma_quest_template_id in number default hr_api.g_number,
776: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
777: p_final_score_formula_id in number default hr_api.g_number,
778: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
779: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
780: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
773: p_attribute20 in varchar2 default hr_api.g_varchar2,
774: p_objective_asmnt_type_id in number default hr_api.g_number,
775: p_ma_quest_template_id in number default hr_api.g_number,
776: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
777: p_final_score_formula_id in number default hr_api.g_number,
778: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
779: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
780: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
781: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
774: p_objective_asmnt_type_id in number default hr_api.g_number,
775: p_ma_quest_template_id in number default hr_api.g_number,
776: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
777: p_final_score_formula_id in number default hr_api.g_number,
778: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
779: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
780: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
781: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
782: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
775: p_ma_quest_template_id in number default hr_api.g_number,
776: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
777: p_final_score_formula_id in number default hr_api.g_number,
778: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
779: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
780: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
781: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
782: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
783: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
776: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
777: p_final_score_formula_id in number default hr_api.g_number,
778: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
779: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
780: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
781: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
782: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
783: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
784: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
777: p_final_score_formula_id in number default hr_api.g_number,
778: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
779: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
780: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
781: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
782: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
783: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
784: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
785: p_show_participant_details in varchar2 default hr_api.g_varchar2,
778: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
779: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
780: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
781: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
782: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
783: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
784: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
785: p_show_participant_details in varchar2 default hr_api.g_varchar2,
786: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
779: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
780: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
781: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
782: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
783: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
784: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
785: p_show_participant_details in varchar2 default hr_api.g_varchar2,
786: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
787: p_show_additional_details in varchar2 default hr_api.g_varchar2,
780: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
781: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
782: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
783: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
784: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
785: p_show_participant_details in varchar2 default hr_api.g_varchar2,
786: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
787: p_show_additional_details in varchar2 default hr_api.g_varchar2,
788: p_show_participant_names in varchar2 default hr_api.g_varchar2,
781: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
782: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
783: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
784: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
785: p_show_participant_details in varchar2 default hr_api.g_varchar2,
786: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
787: p_show_additional_details in varchar2 default hr_api.g_varchar2,
788: p_show_participant_names in varchar2 default hr_api.g_varchar2,
789: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
782: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
783: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
784: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
785: p_show_participant_details in varchar2 default hr_api.g_varchar2,
786: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
787: p_show_additional_details in varchar2 default hr_api.g_varchar2,
788: p_show_participant_names in varchar2 default hr_api.g_varchar2,
789: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
790: p_available_flag in varchar2 default hr_api.g_varchar2,
783: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
784: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
785: p_show_participant_details in varchar2 default hr_api.g_varchar2,
786: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
787: p_show_additional_details in varchar2 default hr_api.g_varchar2,
788: p_show_participant_names in varchar2 default hr_api.g_varchar2,
789: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
790: p_available_flag in varchar2 default hr_api.g_varchar2,
791: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
784: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
785: p_show_participant_details in varchar2 default hr_api.g_varchar2,
786: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
787: p_show_additional_details in varchar2 default hr_api.g_varchar2,
788: p_show_participant_names in varchar2 default hr_api.g_varchar2,
789: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
790: p_available_flag in varchar2 default hr_api.g_varchar2,
791: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
792: p_effective_date in date
785: p_show_participant_details in varchar2 default hr_api.g_varchar2,
786: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
787: p_show_additional_details in varchar2 default hr_api.g_varchar2,
788: p_show_participant_names in varchar2 default hr_api.g_varchar2,
789: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
790: p_available_flag in varchar2 default hr_api.g_varchar2,
791: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
792: p_effective_date in date
793: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
786: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
787: p_show_additional_details in varchar2 default hr_api.g_varchar2,
788: p_show_participant_names in varchar2 default hr_api.g_varchar2,
789: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
790: p_available_flag in varchar2 default hr_api.g_varchar2,
791: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
792: p_effective_date in date
793: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
794: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
787: p_show_additional_details in varchar2 default hr_api.g_varchar2,
788: p_show_participant_names in varchar2 default hr_api.g_varchar2,
789: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
790: p_available_flag in varchar2 default hr_api.g_varchar2,
791: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
792: p_effective_date in date
793: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
794: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
795: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
789: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
790: p_available_flag in varchar2 default hr_api.g_varchar2,
791: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
792: p_effective_date in date
793: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
794: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
795: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
796: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
797: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
790: p_available_flag in varchar2 default hr_api.g_varchar2,
791: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
792: p_effective_date in date
793: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
794: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
795: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
796: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
797: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
798: p_validate in boolean default false ,
791: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
792: p_effective_date in date
793: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
794: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
795: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
796: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
797: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
798: p_validate in boolean default false ,
799: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
792: p_effective_date in date
793: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
794: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
795: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
796: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
797: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
798: p_validate in boolean default false ,
799: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
800: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
793: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
794: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
795: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
796: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
797: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
798: p_validate in boolean default false ,
799: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
800: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
801: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
795: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
796: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
797: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
798: p_validate in boolean default false ,
799: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
800: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
801: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
802: ,p_disp_term_emp_period_from in number default hr_api.g_number -- 6181267 bug fix
803: ,p_show_future_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
796: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
797: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
798: p_validate in boolean default false ,
799: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
800: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
801: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
802: ,p_disp_term_emp_period_from in number default hr_api.g_number -- 6181267 bug fix
803: ,p_show_future_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
804: ) is
797: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
798: p_validate in boolean default false ,
799: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
800: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
801: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
802: ,p_disp_term_emp_period_from in number default hr_api.g_number -- 6181267 bug fix
803: ,p_show_future_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
804: ) is
805:
798: p_validate in boolean default false ,
799: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
800: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
801: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
802: ,p_disp_term_emp_period_from in number default hr_api.g_number -- 6181267 bug fix
803: ,p_show_future_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
804: ) is
805:
806: l_rec per_apt_shd.g_rec_type;
799: p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
800: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
801: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
802: ,p_disp_term_emp_period_from in number default hr_api.g_number -- 6181267 bug fix
803: ,p_show_future_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
804: ) is
805:
806: l_rec per_apt_shd.g_rec_type;
807: l_proc varchar2(72) := g_package||'upd';
815: l_rec :=
816: per_apt_shd.convert_args
817: (
818: p_appraisal_template_id,
819: hr_api.g_number,
820: p_object_version_number,
821: p_name,
822: p_description,
823: p_instructions,