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

APPS.PER_APT_UPD dependencies on HR_API

Line 122: When hr_api.check_integrity_violated Then

118:
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120:
121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: per_apt_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then

Line 125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: per_apt_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: per_apt_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 126: When hr_api.parent_integrity_violated Then

122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: per_apt_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: per_apt_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then

Line 129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: per_apt_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: per_apt_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 130: When hr_api.unique_integrity_violated Then

126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: per_apt_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: per_apt_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When Others Then

Line 133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: per_apt_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When Others Then
135: Raise;
136: End update_dml;
137:

Line 335: when hr_api.cannot_find_prog_unit then

331: p_part_rev_off_template_cd_o => per_apt_shd.g_old_rec.part_rev_off_template_code
332: );
333:
334: exception
335: when hr_api.cannot_find_prog_unit then
336: hr_api.cannot_find_prog_unit_error
337: ( p_module_name => 'PER_APPRAISAL_TEMPLATES'
338: ,p_hook_type => 'AU'
339: );

Line 336: hr_api.cannot_find_prog_unit_error

332: );
333:
334: exception
335: when hr_api.cannot_find_prog_unit then
336: hr_api.cannot_find_prog_unit_error
337: ( p_module_name => 'PER_APPRAISAL_TEMPLATES'
338: ,p_hook_type => 'AU'
339: );
340: end;

Line 403: If (p_rec.business_group_id = hr_api.g_number) then

399: -- p_rec plsql record structure
400: -- to see if a system default is being used. If a system default
401: -- is being used then we must set to the 'current' argument value.
402:
403: If (p_rec.business_group_id = hr_api.g_number) then
404: p_rec.business_group_id :=
405: per_apt_shd.g_old_rec.business_group_id;
406: End If;
407: If (p_rec.name = hr_api.g_varchar2) then

Line 407: If (p_rec.name = hr_api.g_varchar2) then

403: If (p_rec.business_group_id = hr_api.g_number) then
404: p_rec.business_group_id :=
405: per_apt_shd.g_old_rec.business_group_id;
406: End If;
407: If (p_rec.name = hr_api.g_varchar2) then
408: p_rec.name :=
409: per_apt_shd.g_old_rec.name;
410: End If;
411: If (p_rec.description = hr_api.g_varchar2) then

Line 411: If (p_rec.description = hr_api.g_varchar2) then

407: If (p_rec.name = hr_api.g_varchar2) then
408: p_rec.name :=
409: per_apt_shd.g_old_rec.name;
410: End If;
411: If (p_rec.description = hr_api.g_varchar2) then
412: p_rec.description :=
413: per_apt_shd.g_old_rec.description;
414: End If;
415: If (p_rec.instructions = hr_api.g_varchar2) then

Line 415: If (p_rec.instructions = hr_api.g_varchar2) then

411: If (p_rec.description = hr_api.g_varchar2) then
412: p_rec.description :=
413: per_apt_shd.g_old_rec.description;
414: End If;
415: If (p_rec.instructions = hr_api.g_varchar2) then
416: p_rec.instructions :=
417: per_apt_shd.g_old_rec.instructions;
418: End If;
419: If (p_rec.date_from = hr_api.g_date) then

Line 419: If (p_rec.date_from = hr_api.g_date) then

415: If (p_rec.instructions = hr_api.g_varchar2) then
416: p_rec.instructions :=
417: per_apt_shd.g_old_rec.instructions;
418: End If;
419: If (p_rec.date_from = hr_api.g_date) then
420: p_rec.date_from :=
421: per_apt_shd.g_old_rec.date_from;
422: End If;
423: If (p_rec.date_to = hr_api.g_date) then

Line 423: If (p_rec.date_to = hr_api.g_date) then

419: If (p_rec.date_from = hr_api.g_date) then
420: p_rec.date_from :=
421: per_apt_shd.g_old_rec.date_from;
422: End If;
423: If (p_rec.date_to = hr_api.g_date) then
424: p_rec.date_to :=
425: per_apt_shd.g_old_rec.date_to;
426: End If;
427: If (p_rec.assessment_type_id = hr_api.g_number) then

Line 427: If (p_rec.assessment_type_id = hr_api.g_number) then

423: If (p_rec.date_to = hr_api.g_date) then
424: p_rec.date_to :=
425: per_apt_shd.g_old_rec.date_to;
426: End If;
427: If (p_rec.assessment_type_id = hr_api.g_number) then
428: p_rec.assessment_type_id :=
429: per_apt_shd.g_old_rec.assessment_type_id;
430: End If;
431: If (p_rec.rating_scale_id = hr_api.g_number) then

Line 431: If (p_rec.rating_scale_id = hr_api.g_number) then

427: If (p_rec.assessment_type_id = hr_api.g_number) then
428: p_rec.assessment_type_id :=
429: per_apt_shd.g_old_rec.assessment_type_id;
430: End If;
431: If (p_rec.rating_scale_id = hr_api.g_number) then
432: p_rec.rating_scale_id :=
433: per_apt_shd.g_old_rec.rating_scale_id;
434: End If;
435: If (p_rec.questionnaire_template_id = hr_api.g_number) then

Line 435: If (p_rec.questionnaire_template_id = hr_api.g_number) then

431: If (p_rec.rating_scale_id = hr_api.g_number) then
432: p_rec.rating_scale_id :=
433: per_apt_shd.g_old_rec.rating_scale_id;
434: End If;
435: If (p_rec.questionnaire_template_id = hr_api.g_number) then
436: p_rec.questionnaire_template_id :=
437: per_apt_shd.g_old_rec.questionnaire_template_id;
438: End If;
439: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 439: If (p_rec.attribute_category = hr_api.g_varchar2) then

435: If (p_rec.questionnaire_template_id = hr_api.g_number) then
436: p_rec.questionnaire_template_id :=
437: per_apt_shd.g_old_rec.questionnaire_template_id;
438: End If;
439: If (p_rec.attribute_category = hr_api.g_varchar2) then
440: p_rec.attribute_category :=
441: per_apt_shd.g_old_rec.attribute_category;
442: End If;
443: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 443: If (p_rec.attribute1 = hr_api.g_varchar2) then

439: If (p_rec.attribute_category = hr_api.g_varchar2) then
440: p_rec.attribute_category :=
441: per_apt_shd.g_old_rec.attribute_category;
442: End If;
443: If (p_rec.attribute1 = hr_api.g_varchar2) then
444: p_rec.attribute1 :=
445: per_apt_shd.g_old_rec.attribute1;
446: End If;
447: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 447: If (p_rec.attribute2 = hr_api.g_varchar2) then

443: If (p_rec.attribute1 = hr_api.g_varchar2) then
444: p_rec.attribute1 :=
445: per_apt_shd.g_old_rec.attribute1;
446: End If;
447: If (p_rec.attribute2 = hr_api.g_varchar2) then
448: p_rec.attribute2 :=
449: per_apt_shd.g_old_rec.attribute2;
450: End If;
451: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 451: If (p_rec.attribute3 = hr_api.g_varchar2) then

447: If (p_rec.attribute2 = hr_api.g_varchar2) then
448: p_rec.attribute2 :=
449: per_apt_shd.g_old_rec.attribute2;
450: End If;
451: If (p_rec.attribute3 = hr_api.g_varchar2) then
452: p_rec.attribute3 :=
453: per_apt_shd.g_old_rec.attribute3;
454: End If;
455: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 455: If (p_rec.attribute4 = hr_api.g_varchar2) then

451: If (p_rec.attribute3 = hr_api.g_varchar2) then
452: p_rec.attribute3 :=
453: per_apt_shd.g_old_rec.attribute3;
454: End If;
455: If (p_rec.attribute4 = hr_api.g_varchar2) then
456: p_rec.attribute4 :=
457: per_apt_shd.g_old_rec.attribute4;
458: End If;
459: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 459: If (p_rec.attribute5 = hr_api.g_varchar2) then

455: If (p_rec.attribute4 = hr_api.g_varchar2) then
456: p_rec.attribute4 :=
457: per_apt_shd.g_old_rec.attribute4;
458: End If;
459: If (p_rec.attribute5 = hr_api.g_varchar2) then
460: p_rec.attribute5 :=
461: per_apt_shd.g_old_rec.attribute5;
462: End If;
463: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 463: If (p_rec.attribute6 = hr_api.g_varchar2) then

459: If (p_rec.attribute5 = hr_api.g_varchar2) then
460: p_rec.attribute5 :=
461: per_apt_shd.g_old_rec.attribute5;
462: End If;
463: If (p_rec.attribute6 = hr_api.g_varchar2) then
464: p_rec.attribute6 :=
465: per_apt_shd.g_old_rec.attribute6;
466: End If;
467: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 467: If (p_rec.attribute7 = hr_api.g_varchar2) then

463: If (p_rec.attribute6 = hr_api.g_varchar2) then
464: p_rec.attribute6 :=
465: per_apt_shd.g_old_rec.attribute6;
466: End If;
467: If (p_rec.attribute7 = hr_api.g_varchar2) then
468: p_rec.attribute7 :=
469: per_apt_shd.g_old_rec.attribute7;
470: End If;
471: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 471: If (p_rec.attribute8 = hr_api.g_varchar2) then

467: If (p_rec.attribute7 = hr_api.g_varchar2) then
468: p_rec.attribute7 :=
469: per_apt_shd.g_old_rec.attribute7;
470: End If;
471: If (p_rec.attribute8 = hr_api.g_varchar2) then
472: p_rec.attribute8 :=
473: per_apt_shd.g_old_rec.attribute8;
474: End If;
475: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 475: If (p_rec.attribute9 = hr_api.g_varchar2) then

471: If (p_rec.attribute8 = hr_api.g_varchar2) then
472: p_rec.attribute8 :=
473: per_apt_shd.g_old_rec.attribute8;
474: End If;
475: If (p_rec.attribute9 = hr_api.g_varchar2) then
476: p_rec.attribute9 :=
477: per_apt_shd.g_old_rec.attribute9;
478: End If;
479: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 479: If (p_rec.attribute10 = hr_api.g_varchar2) then

475: If (p_rec.attribute9 = hr_api.g_varchar2) then
476: p_rec.attribute9 :=
477: per_apt_shd.g_old_rec.attribute9;
478: End If;
479: If (p_rec.attribute10 = hr_api.g_varchar2) then
480: p_rec.attribute10 :=
481: per_apt_shd.g_old_rec.attribute10;
482: End If;
483: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 483: If (p_rec.attribute11 = hr_api.g_varchar2) then

479: If (p_rec.attribute10 = hr_api.g_varchar2) then
480: p_rec.attribute10 :=
481: per_apt_shd.g_old_rec.attribute10;
482: End If;
483: If (p_rec.attribute11 = hr_api.g_varchar2) then
484: p_rec.attribute11 :=
485: per_apt_shd.g_old_rec.attribute11;
486: End If;
487: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 487: If (p_rec.attribute12 = hr_api.g_varchar2) then

483: If (p_rec.attribute11 = hr_api.g_varchar2) then
484: p_rec.attribute11 :=
485: per_apt_shd.g_old_rec.attribute11;
486: End If;
487: If (p_rec.attribute12 = hr_api.g_varchar2) then
488: p_rec.attribute12 :=
489: per_apt_shd.g_old_rec.attribute12;
490: End If;
491: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 491: If (p_rec.attribute13 = hr_api.g_varchar2) then

487: If (p_rec.attribute12 = hr_api.g_varchar2) then
488: p_rec.attribute12 :=
489: per_apt_shd.g_old_rec.attribute12;
490: End If;
491: If (p_rec.attribute13 = hr_api.g_varchar2) then
492: p_rec.attribute13 :=
493: per_apt_shd.g_old_rec.attribute13;
494: End If;
495: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 495: If (p_rec.attribute14 = hr_api.g_varchar2) then

491: If (p_rec.attribute13 = hr_api.g_varchar2) then
492: p_rec.attribute13 :=
493: per_apt_shd.g_old_rec.attribute13;
494: End If;
495: If (p_rec.attribute14 = hr_api.g_varchar2) then
496: p_rec.attribute14 :=
497: per_apt_shd.g_old_rec.attribute14;
498: End If;
499: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 499: If (p_rec.attribute15 = hr_api.g_varchar2) then

495: If (p_rec.attribute14 = hr_api.g_varchar2) then
496: p_rec.attribute14 :=
497: per_apt_shd.g_old_rec.attribute14;
498: End If;
499: If (p_rec.attribute15 = hr_api.g_varchar2) then
500: p_rec.attribute15 :=
501: per_apt_shd.g_old_rec.attribute15;
502: End If;
503: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 503: If (p_rec.attribute16 = hr_api.g_varchar2) then

499: If (p_rec.attribute15 = hr_api.g_varchar2) then
500: p_rec.attribute15 :=
501: per_apt_shd.g_old_rec.attribute15;
502: End If;
503: If (p_rec.attribute16 = hr_api.g_varchar2) then
504: p_rec.attribute16 :=
505: per_apt_shd.g_old_rec.attribute16;
506: End If;
507: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 507: If (p_rec.attribute17 = hr_api.g_varchar2) then

503: If (p_rec.attribute16 = hr_api.g_varchar2) then
504: p_rec.attribute16 :=
505: per_apt_shd.g_old_rec.attribute16;
506: End If;
507: If (p_rec.attribute17 = hr_api.g_varchar2) then
508: p_rec.attribute17 :=
509: per_apt_shd.g_old_rec.attribute17;
510: End If;
511: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 511: If (p_rec.attribute18 = hr_api.g_varchar2) then

507: If (p_rec.attribute17 = hr_api.g_varchar2) then
508: p_rec.attribute17 :=
509: per_apt_shd.g_old_rec.attribute17;
510: End If;
511: If (p_rec.attribute18 = hr_api.g_varchar2) then
512: p_rec.attribute18 :=
513: per_apt_shd.g_old_rec.attribute18;
514: End If;
515: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 515: If (p_rec.attribute19 = hr_api.g_varchar2) then

511: If (p_rec.attribute18 = hr_api.g_varchar2) then
512: p_rec.attribute18 :=
513: per_apt_shd.g_old_rec.attribute18;
514: End If;
515: If (p_rec.attribute19 = hr_api.g_varchar2) then
516: p_rec.attribute19 :=
517: per_apt_shd.g_old_rec.attribute19;
518: End If;
519: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 519: If (p_rec.attribute20 = hr_api.g_varchar2) then

515: If (p_rec.attribute19 = hr_api.g_varchar2) then
516: p_rec.attribute19 :=
517: per_apt_shd.g_old_rec.attribute19;
518: End If;
519: If (p_rec.attribute20 = hr_api.g_varchar2) then
520: p_rec.attribute20 :=
521: per_apt_shd.g_old_rec.attribute20;
522: End If;
523: If (p_rec.objective_asmnt_type_id = hr_api.g_number) then

Line 523: If (p_rec.objective_asmnt_type_id = hr_api.g_number) then

519: If (p_rec.attribute20 = hr_api.g_varchar2) then
520: p_rec.attribute20 :=
521: per_apt_shd.g_old_rec.attribute20;
522: End If;
523: If (p_rec.objective_asmnt_type_id = hr_api.g_number) then
524: p_rec.objective_asmnt_type_id :=
525: per_apt_shd.g_old_rec.objective_asmnt_type_id;
526: End If;
527: If (p_rec.ma_quest_template_id = hr_api.g_number) then

Line 527: If (p_rec.ma_quest_template_id = hr_api.g_number) then

523: If (p_rec.objective_asmnt_type_id = hr_api.g_number) then
524: p_rec.objective_asmnt_type_id :=
525: per_apt_shd.g_old_rec.objective_asmnt_type_id;
526: End If;
527: If (p_rec.ma_quest_template_id = hr_api.g_number) then
528: p_rec.ma_quest_template_id :=
529: per_apt_shd.g_old_rec.ma_quest_template_id;
530: End If;
531: If (p_rec.link_appr_to_learning_path = hr_api.g_varchar2) then

Line 531: If (p_rec.link_appr_to_learning_path = hr_api.g_varchar2) then

527: If (p_rec.ma_quest_template_id = hr_api.g_number) then
528: p_rec.ma_quest_template_id :=
529: per_apt_shd.g_old_rec.ma_quest_template_id;
530: End If;
531: If (p_rec.link_appr_to_learning_path = hr_api.g_varchar2) then
532: p_rec.link_appr_to_learning_path :=
533: per_apt_shd.g_old_rec.link_appr_to_learning_path;
534: End If;
535: If (p_rec.final_score_formula_id = hr_api.g_number) then

Line 535: If (p_rec.final_score_formula_id = hr_api.g_number) then

531: If (p_rec.link_appr_to_learning_path = hr_api.g_varchar2) then
532: p_rec.link_appr_to_learning_path :=
533: per_apt_shd.g_old_rec.link_appr_to_learning_path;
534: End If;
535: If (p_rec.final_score_formula_id = hr_api.g_number) then
536: p_rec.final_score_formula_id :=
537: per_apt_shd.g_old_rec.final_score_formula_id;
538: End If;
539: If (p_rec.update_personal_comp_profile = hr_api.g_varchar2) then

Line 539: If (p_rec.update_personal_comp_profile = hr_api.g_varchar2) then

535: If (p_rec.final_score_formula_id = hr_api.g_number) then
536: p_rec.final_score_formula_id :=
537: per_apt_shd.g_old_rec.final_score_formula_id;
538: End If;
539: If (p_rec.update_personal_comp_profile = hr_api.g_varchar2) then
540: p_rec.update_personal_comp_profile :=
541: per_apt_shd.g_old_rec.update_personal_comp_profile;
542: End If;
543: If (p_rec.comp_profile_source_type = hr_api.g_varchar2) then

Line 543: If (p_rec.comp_profile_source_type = hr_api.g_varchar2) then

539: If (p_rec.update_personal_comp_profile = hr_api.g_varchar2) then
540: p_rec.update_personal_comp_profile :=
541: per_apt_shd.g_old_rec.update_personal_comp_profile;
542: End If;
543: If (p_rec.comp_profile_source_type = hr_api.g_varchar2) then
544: p_rec.comp_profile_source_type :=
545: per_apt_shd.g_old_rec.comp_profile_source_type;
546: End If;
547: If (p_rec.show_competency_ratings = hr_api.g_varchar2) then

Line 547: If (p_rec.show_competency_ratings = hr_api.g_varchar2) then

543: If (p_rec.comp_profile_source_type = hr_api.g_varchar2) then
544: p_rec.comp_profile_source_type :=
545: per_apt_shd.g_old_rec.comp_profile_source_type;
546: End If;
547: If (p_rec.show_competency_ratings = hr_api.g_varchar2) then
548: p_rec.show_competency_ratings :=
549: per_apt_shd.g_old_rec.show_competency_ratings;
550: End If;
551: If (p_rec.show_objective_ratings = hr_api.g_varchar2) then

Line 551: If (p_rec.show_objective_ratings = hr_api.g_varchar2) then

547: If (p_rec.show_competency_ratings = hr_api.g_varchar2) then
548: p_rec.show_competency_ratings :=
549: per_apt_shd.g_old_rec.show_competency_ratings;
550: End If;
551: If (p_rec.show_objective_ratings = hr_api.g_varchar2) then
552: p_rec.show_objective_ratings :=
553: per_apt_shd.g_old_rec.show_objective_ratings;
554: End If;
555: If (p_rec.show_overall_ratings = hr_api.g_varchar2) then

Line 555: If (p_rec.show_overall_ratings = hr_api.g_varchar2) then

551: If (p_rec.show_objective_ratings = hr_api.g_varchar2) then
552: p_rec.show_objective_ratings :=
553: per_apt_shd.g_old_rec.show_objective_ratings;
554: End If;
555: If (p_rec.show_overall_ratings = hr_api.g_varchar2) then
556: p_rec.show_overall_ratings :=
557: per_apt_shd.g_old_rec.show_overall_ratings;
558: End If;
559: If (p_rec.show_overall_comments = hr_api.g_varchar2) then

Line 559: If (p_rec.show_overall_comments = hr_api.g_varchar2) then

555: If (p_rec.show_overall_ratings = hr_api.g_varchar2) then
556: p_rec.show_overall_ratings :=
557: per_apt_shd.g_old_rec.show_overall_ratings;
558: End If;
559: If (p_rec.show_overall_comments = hr_api.g_varchar2) then
560: p_rec.show_overall_comments :=
561: per_apt_shd.g_old_rec.show_overall_comments;
562: End If;
563: If (p_rec.provide_overall_feedback = hr_api.g_varchar2) then

Line 563: If (p_rec.provide_overall_feedback = hr_api.g_varchar2) then

559: If (p_rec.show_overall_comments = hr_api.g_varchar2) then
560: p_rec.show_overall_comments :=
561: per_apt_shd.g_old_rec.show_overall_comments;
562: End If;
563: If (p_rec.provide_overall_feedback = hr_api.g_varchar2) then
564: p_rec.provide_overall_feedback :=
565: per_apt_shd.g_old_rec.provide_overall_feedback;
566: End If;
567: If (p_rec.show_participant_details = hr_api.g_varchar2) then

Line 567: If (p_rec.show_participant_details = hr_api.g_varchar2) then

563: If (p_rec.provide_overall_feedback = hr_api.g_varchar2) then
564: p_rec.provide_overall_feedback :=
565: per_apt_shd.g_old_rec.provide_overall_feedback;
566: End If;
567: If (p_rec.show_participant_details = hr_api.g_varchar2) then
568: p_rec.show_participant_details :=
569: per_apt_shd.g_old_rec.show_participant_details;
570: End If;
571: If (p_rec.allow_add_participant = hr_api.g_varchar2) then

Line 571: If (p_rec.allow_add_participant = hr_api.g_varchar2) then

567: If (p_rec.show_participant_details = hr_api.g_varchar2) then
568: p_rec.show_participant_details :=
569: per_apt_shd.g_old_rec.show_participant_details;
570: End If;
571: If (p_rec.allow_add_participant = hr_api.g_varchar2) then
572: p_rec.allow_add_participant :=
573: per_apt_shd.g_old_rec.allow_add_participant;
574: End If;
575: If (p_rec.show_additional_details = hr_api.g_varchar2) then

Line 575: If (p_rec.show_additional_details = hr_api.g_varchar2) then

571: If (p_rec.allow_add_participant = hr_api.g_varchar2) then
572: p_rec.allow_add_participant :=
573: per_apt_shd.g_old_rec.allow_add_participant;
574: End If;
575: If (p_rec.show_additional_details = hr_api.g_varchar2) then
576: p_rec.show_additional_details :=
577: per_apt_shd.g_old_rec.show_additional_details;
578: End If;
579: If (p_rec.show_participant_names = hr_api.g_varchar2) then

Line 579: If (p_rec.show_participant_names = hr_api.g_varchar2) then

575: If (p_rec.show_additional_details = hr_api.g_varchar2) then
576: p_rec.show_additional_details :=
577: per_apt_shd.g_old_rec.show_additional_details;
578: End If;
579: If (p_rec.show_participant_names = hr_api.g_varchar2) then
580: p_rec.show_participant_names :=
581: per_apt_shd.g_old_rec.show_participant_names;
582: End If;
583: If (p_rec.show_participant_ratings = hr_api.g_varchar2) then

Line 583: If (p_rec.show_participant_ratings = hr_api.g_varchar2) then

579: If (p_rec.show_participant_names = hr_api.g_varchar2) then
580: p_rec.show_participant_names :=
581: per_apt_shd.g_old_rec.show_participant_names;
582: End If;
583: If (p_rec.show_participant_ratings = hr_api.g_varchar2) then
584: p_rec.show_participant_ratings :=
585: per_apt_shd.g_old_rec.show_participant_ratings;
586: End If;
587: If (p_rec.available_flag = hr_api.g_varchar2) then

Line 587: If (p_rec.available_flag = hr_api.g_varchar2) then

583: If (p_rec.show_participant_ratings = hr_api.g_varchar2) then
584: p_rec.show_participant_ratings :=
585: per_apt_shd.g_old_rec.show_participant_ratings;
586: End If;
587: If (p_rec.available_flag = hr_api.g_varchar2) then
588: p_rec.available_flag :=
589: per_apt_shd.g_old_rec.available_flag;
590: End If;
591: If (p_rec.show_questionnaire_info = hr_api.g_varchar2) then

Line 591: If (p_rec.show_questionnaire_info = hr_api.g_varchar2) then

587: If (p_rec.available_flag = hr_api.g_varchar2) then
588: p_rec.available_flag :=
589: per_apt_shd.g_old_rec.available_flag;
590: End If;
591: If (p_rec.show_questionnaire_info = hr_api.g_varchar2) then
592: p_rec.show_questionnaire_info :=
593: per_apt_shd.g_old_rec.show_questionnaire_info;
594: End If;
595: If (p_rec.ma_off_template_code =hr_api.g_varchar2) then

Line 595: If (p_rec.ma_off_template_code =hr_api.g_varchar2) then

591: If (p_rec.show_questionnaire_info = hr_api.g_varchar2) then
592: p_rec.show_questionnaire_info :=
593: per_apt_shd.g_old_rec.show_questionnaire_info;
594: End If;
595: If (p_rec.ma_off_template_code =hr_api.g_varchar2) then
596: p_rec.ma_off_template_code :=
597: per_apt_shd.g_old_rec.ma_off_template_code;
598: End If;
599: If (p_rec.appraisee_off_template_code =hr_api.g_varchar2) then

Line 599: If (p_rec.appraisee_off_template_code =hr_api.g_varchar2) then

595: If (p_rec.ma_off_template_code =hr_api.g_varchar2) then
596: p_rec.ma_off_template_code :=
597: per_apt_shd.g_old_rec.ma_off_template_code;
598: End If;
599: If (p_rec.appraisee_off_template_code =hr_api.g_varchar2) then
600: p_rec.appraisee_off_template_code :=
601: per_apt_shd.g_old_rec.appraisee_off_template_code;
602: End If;
603: If (p_rec.other_part_off_template_code =hr_api.g_varchar2) then

Line 603: If (p_rec.other_part_off_template_code =hr_api.g_varchar2) then

599: If (p_rec.appraisee_off_template_code =hr_api.g_varchar2) then
600: p_rec.appraisee_off_template_code :=
601: per_apt_shd.g_old_rec.appraisee_off_template_code;
602: End If;
603: If (p_rec.other_part_off_template_code =hr_api.g_varchar2) then
604: p_rec.other_part_off_template_code :=
605: per_apt_shd.g_old_rec.other_part_off_template_code;
606: End If;
607: If (p_rec.part_rev_off_template_code =hr_api.g_varchar2) then

Line 607: If (p_rec.part_rev_off_template_code =hr_api.g_varchar2) then

603: If (p_rec.other_part_off_template_code =hr_api.g_varchar2) then
604: p_rec.other_part_off_template_code :=
605: per_apt_shd.g_old_rec.other_part_off_template_code;
606: End If;
607: If (p_rec.part_rev_off_template_code =hr_api.g_varchar2) then
608: p_rec.part_rev_off_template_code :=
609: per_apt_shd.g_old_rec.part_rev_off_template_code;
610: End If;
611: If (p_rec.part_app_off_template_code =hr_api.g_varchar2) then

Line 611: If (p_rec.part_app_off_template_code =hr_api.g_varchar2) then

607: If (p_rec.part_rev_off_template_code =hr_api.g_varchar2) then
608: p_rec.part_rev_off_template_code :=
609: per_apt_shd.g_old_rec.part_rev_off_template_code;
610: End If;
611: If (p_rec.part_app_off_template_code =hr_api.g_varchar2) then
612: p_rec.part_app_off_template_code :=
613: per_apt_shd.g_old_rec.part_app_off_template_code ;
614: End If;
615:

Line 676: Raise HR_Api.Validate_Enabled;

672:
673: -- If we are validating then raise the Validate_Enabled exception
674:
675: If p_validate then
676: Raise HR_Api.Validate_Enabled;
677: End If;
678:
679: hr_utility.set_location(' Leaving:'||l_proc, 10);
680: Exception

Line 681: When HR_Api.Validate_Enabled Then

677: End If;
678:
679: hr_utility.set_location(' Leaving:'||l_proc, 10);
680: Exception
681: When HR_Api.Validate_Enabled Then
682:
683: -- As the Validate_Enabled exception has been raised
684: -- we must rollback to the savepoint
685:

Line 696: p_name in varchar2 default hr_api.g_varchar2,

692: Procedure upd
693: (
694: p_appraisal_template_id in number,
695: p_object_version_number in out nocopy number,
696: p_name in varchar2 default hr_api.g_varchar2,
697: p_description in varchar2 default hr_api.g_varchar2,
698: p_instructions in varchar2 default hr_api.g_varchar2,
699: p_date_from in date default hr_api.g_date,
700: p_date_to in date default hr_api.g_date,

Line 697: p_description in varchar2 default hr_api.g_varchar2,

693: (
694: p_appraisal_template_id in number,
695: p_object_version_number in out nocopy number,
696: p_name in varchar2 default hr_api.g_varchar2,
697: p_description in varchar2 default hr_api.g_varchar2,
698: p_instructions in varchar2 default hr_api.g_varchar2,
699: p_date_from in date default hr_api.g_date,
700: p_date_to in date default hr_api.g_date,
701: p_assessment_type_id in number default hr_api.g_number,

Line 698: p_instructions in varchar2 default hr_api.g_varchar2,

694: p_appraisal_template_id in number,
695: p_object_version_number in out nocopy number,
696: p_name in varchar2 default hr_api.g_varchar2,
697: p_description in varchar2 default hr_api.g_varchar2,
698: p_instructions in varchar2 default hr_api.g_varchar2,
699: p_date_from in date default hr_api.g_date,
700: p_date_to in date default hr_api.g_date,
701: p_assessment_type_id in number default hr_api.g_number,
702: p_rating_scale_id in number default hr_api.g_number,

Line 699: p_date_from in date default hr_api.g_date,

695: p_object_version_number in out nocopy number,
696: p_name in varchar2 default hr_api.g_varchar2,
697: p_description in varchar2 default hr_api.g_varchar2,
698: p_instructions in varchar2 default hr_api.g_varchar2,
699: p_date_from in date default hr_api.g_date,
700: p_date_to in date default hr_api.g_date,
701: p_assessment_type_id in number default hr_api.g_number,
702: p_rating_scale_id in number default hr_api.g_number,
703: p_questionnaire_template_id in number default hr_api.g_number,

Line 700: p_date_to in date default hr_api.g_date,

696: p_name in varchar2 default hr_api.g_varchar2,
697: p_description in varchar2 default hr_api.g_varchar2,
698: p_instructions in varchar2 default hr_api.g_varchar2,
699: p_date_from in date default hr_api.g_date,
700: p_date_to in date default hr_api.g_date,
701: p_assessment_type_id in number default hr_api.g_number,
702: p_rating_scale_id in number default hr_api.g_number,
703: p_questionnaire_template_id in number default hr_api.g_number,
704: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 701: p_assessment_type_id in number default hr_api.g_number,

697: p_description in varchar2 default hr_api.g_varchar2,
698: p_instructions in varchar2 default hr_api.g_varchar2,
699: p_date_from in date default hr_api.g_date,
700: p_date_to in date default hr_api.g_date,
701: p_assessment_type_id in number default hr_api.g_number,
702: p_rating_scale_id in number default hr_api.g_number,
703: p_questionnaire_template_id in number default hr_api.g_number,
704: p_attribute_category in varchar2 default hr_api.g_varchar2,
705: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 702: p_rating_scale_id in number default hr_api.g_number,

698: p_instructions in varchar2 default hr_api.g_varchar2,
699: p_date_from in date default hr_api.g_date,
700: p_date_to in date default hr_api.g_date,
701: p_assessment_type_id in number default hr_api.g_number,
702: p_rating_scale_id in number default hr_api.g_number,
703: p_questionnaire_template_id in number default hr_api.g_number,
704: p_attribute_category in varchar2 default hr_api.g_varchar2,
705: p_attribute1 in varchar2 default hr_api.g_varchar2,
706: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 703: p_questionnaire_template_id in number default hr_api.g_number,

699: p_date_from in date default hr_api.g_date,
700: p_date_to in date default hr_api.g_date,
701: p_assessment_type_id in number default hr_api.g_number,
702: p_rating_scale_id in number default hr_api.g_number,
703: p_questionnaire_template_id in number default hr_api.g_number,
704: p_attribute_category in varchar2 default hr_api.g_varchar2,
705: p_attribute1 in varchar2 default hr_api.g_varchar2,
706: p_attribute2 in varchar2 default hr_api.g_varchar2,
707: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 704: p_attribute_category in varchar2 default hr_api.g_varchar2,

700: p_date_to in date default hr_api.g_date,
701: p_assessment_type_id in number default hr_api.g_number,
702: p_rating_scale_id in number default hr_api.g_number,
703: p_questionnaire_template_id in number default hr_api.g_number,
704: p_attribute_category in varchar2 default hr_api.g_varchar2,
705: p_attribute1 in varchar2 default hr_api.g_varchar2,
706: p_attribute2 in varchar2 default hr_api.g_varchar2,
707: p_attribute3 in varchar2 default hr_api.g_varchar2,
708: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 705: p_attribute1 in varchar2 default hr_api.g_varchar2,

701: p_assessment_type_id in number default hr_api.g_number,
702: p_rating_scale_id in number default hr_api.g_number,
703: p_questionnaire_template_id in number default hr_api.g_number,
704: p_attribute_category in varchar2 default hr_api.g_varchar2,
705: p_attribute1 in varchar2 default hr_api.g_varchar2,
706: p_attribute2 in varchar2 default hr_api.g_varchar2,
707: p_attribute3 in varchar2 default hr_api.g_varchar2,
708: p_attribute4 in varchar2 default hr_api.g_varchar2,
709: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 706: p_attribute2 in varchar2 default hr_api.g_varchar2,

702: p_rating_scale_id in number default hr_api.g_number,
703: p_questionnaire_template_id in number default hr_api.g_number,
704: p_attribute_category in varchar2 default hr_api.g_varchar2,
705: p_attribute1 in varchar2 default hr_api.g_varchar2,
706: p_attribute2 in varchar2 default hr_api.g_varchar2,
707: p_attribute3 in varchar2 default hr_api.g_varchar2,
708: p_attribute4 in varchar2 default hr_api.g_varchar2,
709: p_attribute5 in varchar2 default hr_api.g_varchar2,
710: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 707: p_attribute3 in varchar2 default hr_api.g_varchar2,

703: p_questionnaire_template_id in number default hr_api.g_number,
704: p_attribute_category in varchar2 default hr_api.g_varchar2,
705: p_attribute1 in varchar2 default hr_api.g_varchar2,
706: p_attribute2 in varchar2 default hr_api.g_varchar2,
707: p_attribute3 in varchar2 default hr_api.g_varchar2,
708: p_attribute4 in varchar2 default hr_api.g_varchar2,
709: p_attribute5 in varchar2 default hr_api.g_varchar2,
710: p_attribute6 in varchar2 default hr_api.g_varchar2,
711: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 708: p_attribute4 in varchar2 default hr_api.g_varchar2,

704: p_attribute_category in varchar2 default hr_api.g_varchar2,
705: p_attribute1 in varchar2 default hr_api.g_varchar2,
706: p_attribute2 in varchar2 default hr_api.g_varchar2,
707: p_attribute3 in varchar2 default hr_api.g_varchar2,
708: p_attribute4 in varchar2 default hr_api.g_varchar2,
709: p_attribute5 in varchar2 default hr_api.g_varchar2,
710: p_attribute6 in varchar2 default hr_api.g_varchar2,
711: p_attribute7 in varchar2 default hr_api.g_varchar2,
712: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 709: p_attribute5 in varchar2 default hr_api.g_varchar2,

705: p_attribute1 in varchar2 default hr_api.g_varchar2,
706: p_attribute2 in varchar2 default hr_api.g_varchar2,
707: p_attribute3 in varchar2 default hr_api.g_varchar2,
708: p_attribute4 in varchar2 default hr_api.g_varchar2,
709: p_attribute5 in varchar2 default hr_api.g_varchar2,
710: p_attribute6 in varchar2 default hr_api.g_varchar2,
711: p_attribute7 in varchar2 default hr_api.g_varchar2,
712: p_attribute8 in varchar2 default hr_api.g_varchar2,
713: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 710: p_attribute6 in varchar2 default hr_api.g_varchar2,

706: p_attribute2 in varchar2 default hr_api.g_varchar2,
707: p_attribute3 in varchar2 default hr_api.g_varchar2,
708: p_attribute4 in varchar2 default hr_api.g_varchar2,
709: p_attribute5 in varchar2 default hr_api.g_varchar2,
710: p_attribute6 in varchar2 default hr_api.g_varchar2,
711: p_attribute7 in varchar2 default hr_api.g_varchar2,
712: p_attribute8 in varchar2 default hr_api.g_varchar2,
713: p_attribute9 in varchar2 default hr_api.g_varchar2,
714: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 711: p_attribute7 in varchar2 default hr_api.g_varchar2,

707: p_attribute3 in varchar2 default hr_api.g_varchar2,
708: p_attribute4 in varchar2 default hr_api.g_varchar2,
709: p_attribute5 in varchar2 default hr_api.g_varchar2,
710: p_attribute6 in varchar2 default hr_api.g_varchar2,
711: p_attribute7 in varchar2 default hr_api.g_varchar2,
712: p_attribute8 in varchar2 default hr_api.g_varchar2,
713: p_attribute9 in varchar2 default hr_api.g_varchar2,
714: p_attribute10 in varchar2 default hr_api.g_varchar2,
715: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 712: p_attribute8 in varchar2 default hr_api.g_varchar2,

708: p_attribute4 in varchar2 default hr_api.g_varchar2,
709: p_attribute5 in varchar2 default hr_api.g_varchar2,
710: p_attribute6 in varchar2 default hr_api.g_varchar2,
711: p_attribute7 in varchar2 default hr_api.g_varchar2,
712: p_attribute8 in varchar2 default hr_api.g_varchar2,
713: p_attribute9 in varchar2 default hr_api.g_varchar2,
714: p_attribute10 in varchar2 default hr_api.g_varchar2,
715: p_attribute11 in varchar2 default hr_api.g_varchar2,
716: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 713: p_attribute9 in varchar2 default hr_api.g_varchar2,

709: p_attribute5 in varchar2 default hr_api.g_varchar2,
710: p_attribute6 in varchar2 default hr_api.g_varchar2,
711: p_attribute7 in varchar2 default hr_api.g_varchar2,
712: p_attribute8 in varchar2 default hr_api.g_varchar2,
713: p_attribute9 in varchar2 default hr_api.g_varchar2,
714: p_attribute10 in varchar2 default hr_api.g_varchar2,
715: p_attribute11 in varchar2 default hr_api.g_varchar2,
716: p_attribute12 in varchar2 default hr_api.g_varchar2,
717: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 714: p_attribute10 in varchar2 default hr_api.g_varchar2,

710: p_attribute6 in varchar2 default hr_api.g_varchar2,
711: p_attribute7 in varchar2 default hr_api.g_varchar2,
712: p_attribute8 in varchar2 default hr_api.g_varchar2,
713: p_attribute9 in varchar2 default hr_api.g_varchar2,
714: p_attribute10 in varchar2 default hr_api.g_varchar2,
715: p_attribute11 in varchar2 default hr_api.g_varchar2,
716: p_attribute12 in varchar2 default hr_api.g_varchar2,
717: p_attribute13 in varchar2 default hr_api.g_varchar2,
718: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 715: p_attribute11 in varchar2 default hr_api.g_varchar2,

711: p_attribute7 in varchar2 default hr_api.g_varchar2,
712: p_attribute8 in varchar2 default hr_api.g_varchar2,
713: p_attribute9 in varchar2 default hr_api.g_varchar2,
714: p_attribute10 in varchar2 default hr_api.g_varchar2,
715: p_attribute11 in varchar2 default hr_api.g_varchar2,
716: p_attribute12 in varchar2 default hr_api.g_varchar2,
717: p_attribute13 in varchar2 default hr_api.g_varchar2,
718: p_attribute14 in varchar2 default hr_api.g_varchar2,
719: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 716: p_attribute12 in varchar2 default hr_api.g_varchar2,

712: p_attribute8 in varchar2 default hr_api.g_varchar2,
713: p_attribute9 in varchar2 default hr_api.g_varchar2,
714: p_attribute10 in varchar2 default hr_api.g_varchar2,
715: p_attribute11 in varchar2 default hr_api.g_varchar2,
716: p_attribute12 in varchar2 default hr_api.g_varchar2,
717: p_attribute13 in varchar2 default hr_api.g_varchar2,
718: p_attribute14 in varchar2 default hr_api.g_varchar2,
719: p_attribute15 in varchar2 default hr_api.g_varchar2,
720: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 717: p_attribute13 in varchar2 default hr_api.g_varchar2,

713: p_attribute9 in varchar2 default hr_api.g_varchar2,
714: p_attribute10 in varchar2 default hr_api.g_varchar2,
715: p_attribute11 in varchar2 default hr_api.g_varchar2,
716: p_attribute12 in varchar2 default hr_api.g_varchar2,
717: p_attribute13 in varchar2 default hr_api.g_varchar2,
718: p_attribute14 in varchar2 default hr_api.g_varchar2,
719: p_attribute15 in varchar2 default hr_api.g_varchar2,
720: p_attribute16 in varchar2 default hr_api.g_varchar2,
721: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 718: p_attribute14 in varchar2 default hr_api.g_varchar2,

714: p_attribute10 in varchar2 default hr_api.g_varchar2,
715: p_attribute11 in varchar2 default hr_api.g_varchar2,
716: p_attribute12 in varchar2 default hr_api.g_varchar2,
717: p_attribute13 in varchar2 default hr_api.g_varchar2,
718: p_attribute14 in varchar2 default hr_api.g_varchar2,
719: p_attribute15 in varchar2 default hr_api.g_varchar2,
720: p_attribute16 in varchar2 default hr_api.g_varchar2,
721: p_attribute17 in varchar2 default hr_api.g_varchar2,
722: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 719: p_attribute15 in varchar2 default hr_api.g_varchar2,

715: p_attribute11 in varchar2 default hr_api.g_varchar2,
716: p_attribute12 in varchar2 default hr_api.g_varchar2,
717: p_attribute13 in varchar2 default hr_api.g_varchar2,
718: p_attribute14 in varchar2 default hr_api.g_varchar2,
719: p_attribute15 in varchar2 default hr_api.g_varchar2,
720: p_attribute16 in varchar2 default hr_api.g_varchar2,
721: p_attribute17 in varchar2 default hr_api.g_varchar2,
722: p_attribute18 in varchar2 default hr_api.g_varchar2,
723: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 720: p_attribute16 in varchar2 default hr_api.g_varchar2,

716: p_attribute12 in varchar2 default hr_api.g_varchar2,
717: p_attribute13 in varchar2 default hr_api.g_varchar2,
718: p_attribute14 in varchar2 default hr_api.g_varchar2,
719: p_attribute15 in varchar2 default hr_api.g_varchar2,
720: p_attribute16 in varchar2 default hr_api.g_varchar2,
721: p_attribute17 in varchar2 default hr_api.g_varchar2,
722: p_attribute18 in varchar2 default hr_api.g_varchar2,
723: p_attribute19 in varchar2 default hr_api.g_varchar2,
724: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 721: p_attribute17 in varchar2 default hr_api.g_varchar2,

717: p_attribute13 in varchar2 default hr_api.g_varchar2,
718: p_attribute14 in varchar2 default hr_api.g_varchar2,
719: p_attribute15 in varchar2 default hr_api.g_varchar2,
720: p_attribute16 in varchar2 default hr_api.g_varchar2,
721: p_attribute17 in varchar2 default hr_api.g_varchar2,
722: p_attribute18 in varchar2 default hr_api.g_varchar2,
723: p_attribute19 in varchar2 default hr_api.g_varchar2,
724: p_attribute20 in varchar2 default hr_api.g_varchar2,
725: p_objective_asmnt_type_id in number default hr_api.g_number,

Line 722: p_attribute18 in varchar2 default hr_api.g_varchar2,

718: p_attribute14 in varchar2 default hr_api.g_varchar2,
719: p_attribute15 in varchar2 default hr_api.g_varchar2,
720: p_attribute16 in varchar2 default hr_api.g_varchar2,
721: p_attribute17 in varchar2 default hr_api.g_varchar2,
722: p_attribute18 in varchar2 default hr_api.g_varchar2,
723: p_attribute19 in varchar2 default hr_api.g_varchar2,
724: p_attribute20 in varchar2 default hr_api.g_varchar2,
725: p_objective_asmnt_type_id in number default hr_api.g_number,
726: p_ma_quest_template_id in number default hr_api.g_number,

Line 723: p_attribute19 in varchar2 default hr_api.g_varchar2,

719: p_attribute15 in varchar2 default hr_api.g_varchar2,
720: p_attribute16 in varchar2 default hr_api.g_varchar2,
721: p_attribute17 in varchar2 default hr_api.g_varchar2,
722: p_attribute18 in varchar2 default hr_api.g_varchar2,
723: p_attribute19 in varchar2 default hr_api.g_varchar2,
724: p_attribute20 in varchar2 default hr_api.g_varchar2,
725: p_objective_asmnt_type_id in number default hr_api.g_number,
726: p_ma_quest_template_id in number default hr_api.g_number,
727: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,

Line 724: p_attribute20 in varchar2 default hr_api.g_varchar2,

720: p_attribute16 in varchar2 default hr_api.g_varchar2,
721: p_attribute17 in varchar2 default hr_api.g_varchar2,
722: p_attribute18 in varchar2 default hr_api.g_varchar2,
723: p_attribute19 in varchar2 default hr_api.g_varchar2,
724: p_attribute20 in varchar2 default hr_api.g_varchar2,
725: p_objective_asmnt_type_id in number default hr_api.g_number,
726: p_ma_quest_template_id in number default hr_api.g_number,
727: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
728: p_final_score_formula_id in number default hr_api.g_number,

Line 725: p_objective_asmnt_type_id in number default hr_api.g_number,

721: p_attribute17 in varchar2 default hr_api.g_varchar2,
722: p_attribute18 in varchar2 default hr_api.g_varchar2,
723: p_attribute19 in varchar2 default hr_api.g_varchar2,
724: p_attribute20 in varchar2 default hr_api.g_varchar2,
725: p_objective_asmnt_type_id in number default hr_api.g_number,
726: p_ma_quest_template_id in number default hr_api.g_number,
727: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
728: p_final_score_formula_id in number default hr_api.g_number,
729: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,

Line 726: p_ma_quest_template_id in number default hr_api.g_number,

722: p_attribute18 in varchar2 default hr_api.g_varchar2,
723: p_attribute19 in varchar2 default hr_api.g_varchar2,
724: p_attribute20 in varchar2 default hr_api.g_varchar2,
725: p_objective_asmnt_type_id in number default hr_api.g_number,
726: p_ma_quest_template_id in number default hr_api.g_number,
727: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
728: p_final_score_formula_id in number default hr_api.g_number,
729: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
730: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,

Line 727: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,

723: p_attribute19 in varchar2 default hr_api.g_varchar2,
724: p_attribute20 in varchar2 default hr_api.g_varchar2,
725: p_objective_asmnt_type_id in number default hr_api.g_number,
726: p_ma_quest_template_id in number default hr_api.g_number,
727: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
728: p_final_score_formula_id in number default hr_api.g_number,
729: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
730: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
731: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,

Line 728: p_final_score_formula_id in number default hr_api.g_number,

724: p_attribute20 in varchar2 default hr_api.g_varchar2,
725: p_objective_asmnt_type_id in number default hr_api.g_number,
726: p_ma_quest_template_id in number default hr_api.g_number,
727: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
728: p_final_score_formula_id in number default hr_api.g_number,
729: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
730: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
731: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
732: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,

Line 729: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,

725: p_objective_asmnt_type_id in number default hr_api.g_number,
726: p_ma_quest_template_id in number default hr_api.g_number,
727: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
728: p_final_score_formula_id in number default hr_api.g_number,
729: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
730: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
731: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
732: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
733: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,

Line 730: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,

726: p_ma_quest_template_id in number default hr_api.g_number,
727: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
728: p_final_score_formula_id in number default hr_api.g_number,
729: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
730: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
731: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
732: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
733: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
734: p_show_overall_comments in varchar2 default hr_api.g_varchar2,

Line 731: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,

727: p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2,
728: p_final_score_formula_id in number default hr_api.g_number,
729: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
730: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
731: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
732: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
733: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
734: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
735: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,

Line 732: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,

728: p_final_score_formula_id in number default hr_api.g_number,
729: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
730: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
731: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
732: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
733: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
734: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
735: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
736: p_show_participant_details in varchar2 default hr_api.g_varchar2,

Line 733: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,

729: p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2,
730: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
731: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
732: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
733: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
734: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
735: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
736: p_show_participant_details in varchar2 default hr_api.g_varchar2,
737: p_allow_add_participant in varchar2 default hr_api.g_varchar2,

Line 734: p_show_overall_comments in varchar2 default hr_api.g_varchar2,

730: p_comp_profile_source_type in varchar2 default hr_api.g_varchar2,
731: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
732: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
733: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
734: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
735: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
736: p_show_participant_details in varchar2 default hr_api.g_varchar2,
737: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
738: p_show_additional_details in varchar2 default hr_api.g_varchar2,

Line 735: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,

731: p_show_competency_ratings in varchar2 default hr_api.g_varchar2,
732: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
733: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
734: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
735: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
736: p_show_participant_details in varchar2 default hr_api.g_varchar2,
737: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
738: p_show_additional_details in varchar2 default hr_api.g_varchar2,
739: p_show_participant_names in varchar2 default hr_api.g_varchar2,

Line 736: p_show_participant_details in varchar2 default hr_api.g_varchar2,

732: p_show_objective_ratings in varchar2 default hr_api.g_varchar2,
733: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
734: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
735: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
736: p_show_participant_details in varchar2 default hr_api.g_varchar2,
737: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
738: p_show_additional_details in varchar2 default hr_api.g_varchar2,
739: p_show_participant_names in varchar2 default hr_api.g_varchar2,
740: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,

Line 737: p_allow_add_participant in varchar2 default hr_api.g_varchar2,

733: p_show_overall_ratings in varchar2 default hr_api.g_varchar2,
734: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
735: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
736: p_show_participant_details in varchar2 default hr_api.g_varchar2,
737: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
738: p_show_additional_details in varchar2 default hr_api.g_varchar2,
739: p_show_participant_names in varchar2 default hr_api.g_varchar2,
740: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
741: p_available_flag in varchar2 default hr_api.g_varchar2,

Line 738: p_show_additional_details in varchar2 default hr_api.g_varchar2,

734: p_show_overall_comments in varchar2 default hr_api.g_varchar2,
735: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
736: p_show_participant_details in varchar2 default hr_api.g_varchar2,
737: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
738: p_show_additional_details in varchar2 default hr_api.g_varchar2,
739: p_show_participant_names in varchar2 default hr_api.g_varchar2,
740: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
741: p_available_flag in varchar2 default hr_api.g_varchar2,
742: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,

Line 739: p_show_participant_names in varchar2 default hr_api.g_varchar2,

735: p_provide_overall_feedback in varchar2 default hr_api.g_varchar2,
736: p_show_participant_details in varchar2 default hr_api.g_varchar2,
737: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
738: p_show_additional_details in varchar2 default hr_api.g_varchar2,
739: p_show_participant_names in varchar2 default hr_api.g_varchar2,
740: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
741: p_available_flag in varchar2 default hr_api.g_varchar2,
742: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
743: p_effective_date in date

Line 740: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,

736: p_show_participant_details in varchar2 default hr_api.g_varchar2,
737: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
738: p_show_additional_details in varchar2 default hr_api.g_varchar2,
739: p_show_participant_names in varchar2 default hr_api.g_varchar2,
740: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
741: p_available_flag in varchar2 default hr_api.g_varchar2,
742: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
743: p_effective_date in date
744: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2

Line 741: p_available_flag in varchar2 default hr_api.g_varchar2,

737: p_allow_add_participant in varchar2 default hr_api.g_varchar2,
738: p_show_additional_details in varchar2 default hr_api.g_varchar2,
739: p_show_participant_names in varchar2 default hr_api.g_varchar2,
740: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
741: p_available_flag in varchar2 default hr_api.g_varchar2,
742: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
743: p_effective_date in date
744: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
745: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2

Line 742: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,

738: p_show_additional_details in varchar2 default hr_api.g_varchar2,
739: p_show_participant_names in varchar2 default hr_api.g_varchar2,
740: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
741: p_available_flag in varchar2 default hr_api.g_varchar2,
742: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
743: p_effective_date in date
744: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
745: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
746: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2

Line 744: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2

740: p_show_participant_ratings in varchar2 default hr_api.g_varchar2,
741: p_available_flag in varchar2 default hr_api.g_varchar2,
742: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
743: p_effective_date in date
744: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
745: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
746: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
747: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
748: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,

Line 745: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2

741: p_available_flag in varchar2 default hr_api.g_varchar2,
742: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
743: p_effective_date in date
744: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
745: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
746: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
747: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
748: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
749: p_validate in boolean default false

Line 746: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2

742: p_show_questionnaire_info in varchar2 default hr_api.g_varchar2,
743: p_effective_date in date
744: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
745: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
746: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
747: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
748: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
749: p_validate in boolean default false
750: ) is

Line 747: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2

743: p_effective_date in date
744: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
745: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
746: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
747: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
748: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
749: p_validate in boolean default false
750: ) is
751:

Line 748: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,

744: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
745: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
746: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
747: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
748: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2,
749: p_validate in boolean default false
750: ) is
751:
752: l_rec per_apt_shd.g_rec_type;

Line 765: hr_api.g_number,

761: l_rec :=
762: per_apt_shd.convert_args
763: (
764: p_appraisal_template_id,
765: hr_api.g_number,
766: p_object_version_number,
767: p_name,
768: p_description,
769: p_instructions,