131: --
132: hr_utility.set_location(' Leaving:'||l_proc, 10);
133: --
134: Exception
135: When hr_api.check_integrity_violated Then
136: -- A check constraint has been violated
137: per_obj_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
134: Exception
135: When hr_api.check_integrity_violated Then
136: -- A check constraint has been violated
137: per_obj_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: per_obj_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.check_integrity_violated Then
136: -- A check constraint has been violated
137: per_obj_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: per_obj_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: per_obj_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: per_obj_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: per_obj_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: per_obj_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: per_obj_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: Raise;
149: End update_dml;
150: --
376: p_sharing_access_code_o => per_obj_shd.g_old_rec.sharing_access_code
377:
378: );
379: exception
380: when hr_api.cannot_find_prog_unit then
381: hr_api.cannot_find_prog_unit_error
382: (p_module_name => 'PER_OBJECTIVES'
383: ,p_hook_type => 'AU'
384: );
377:
378: );
379: exception
380: when hr_api.cannot_find_prog_unit then
381: hr_api.cannot_find_prog_unit_error
382: (p_module_name => 'PER_OBJECTIVES'
383: ,p_hook_type => 'AU'
384: );
385: end;
444: -- p_rec plsql record structure
445: -- to see if a system default is being used. If a system default
446: -- is being used then we must set to the 'current' argument value.
447: --
448: If (p_rec.name = hr_api.g_varchar2) then
449: p_rec.name :=
450: per_obj_shd.g_old_rec.name;
451: End If;
452: If (p_rec.target_date = hr_api.g_date) then
448: If (p_rec.name = hr_api.g_varchar2) then
449: p_rec.name :=
450: per_obj_shd.g_old_rec.name;
451: End If;
452: If (p_rec.target_date = hr_api.g_date) then
453: p_rec.target_date :=
454: per_obj_shd.g_old_rec.target_date;
455: End If;
456: If (p_rec.start_date = hr_api.g_date) then
452: If (p_rec.target_date = hr_api.g_date) then
453: p_rec.target_date :=
454: per_obj_shd.g_old_rec.target_date;
455: End If;
456: If (p_rec.start_date = hr_api.g_date) then
457: p_rec.start_date :=
458: per_obj_shd.g_old_rec.start_date;
459: End If;
460: If (p_rec.business_group_id = hr_api.g_number) then
456: If (p_rec.start_date = hr_api.g_date) then
457: p_rec.start_date :=
458: per_obj_shd.g_old_rec.start_date;
459: End If;
460: If (p_rec.business_group_id = hr_api.g_number) then
461: p_rec.business_group_id :=
462: per_obj_shd.g_old_rec.business_group_id;
463: End If;
464: If (p_rec.owning_person_id = hr_api.g_number) then
460: If (p_rec.business_group_id = hr_api.g_number) then
461: p_rec.business_group_id :=
462: per_obj_shd.g_old_rec.business_group_id;
463: End If;
464: If (p_rec.owning_person_id = hr_api.g_number) then
465: p_rec.owning_person_id :=
466: per_obj_shd.g_old_rec.owning_person_id;
467: End If;
468: If (p_rec.achievement_date = hr_api.g_date) then
464: If (p_rec.owning_person_id = hr_api.g_number) then
465: p_rec.owning_person_id :=
466: per_obj_shd.g_old_rec.owning_person_id;
467: End If;
468: If (p_rec.achievement_date = hr_api.g_date) then
469: p_rec.achievement_date :=
470: per_obj_shd.g_old_rec.achievement_date;
471: End If;
472: If (p_rec.detail = hr_api.g_varchar2) then
468: If (p_rec.achievement_date = hr_api.g_date) then
469: p_rec.achievement_date :=
470: per_obj_shd.g_old_rec.achievement_date;
471: End If;
472: If (p_rec.detail = hr_api.g_varchar2) then
473: p_rec.detail :=
474: per_obj_shd.g_old_rec.detail;
475: End If;
476: If (p_rec.comments = hr_api.g_varchar2) then
472: If (p_rec.detail = hr_api.g_varchar2) then
473: p_rec.detail :=
474: per_obj_shd.g_old_rec.detail;
475: End If;
476: If (p_rec.comments = hr_api.g_varchar2) then
477: p_rec.comments :=
478: per_obj_shd.g_old_rec.comments;
479: End If;
480: If (p_rec.success_criteria = hr_api.g_varchar2) then
476: If (p_rec.comments = hr_api.g_varchar2) then
477: p_rec.comments :=
478: per_obj_shd.g_old_rec.comments;
479: End If;
480: If (p_rec.success_criteria = hr_api.g_varchar2) then
481: p_rec.success_criteria :=
482: per_obj_shd.g_old_rec.success_criteria;
483: End If;
484: If (p_rec.appraisal_id = hr_api.g_number) then
480: If (p_rec.success_criteria = hr_api.g_varchar2) then
481: p_rec.success_criteria :=
482: per_obj_shd.g_old_rec.success_criteria;
483: End If;
484: If (p_rec.appraisal_id = hr_api.g_number) then
485: p_rec.appraisal_id :=
486: per_obj_shd.g_old_rec.appraisal_id;
487: End If;
488: If (p_rec.attribute_category = hr_api.g_varchar2) then
484: If (p_rec.appraisal_id = hr_api.g_number) then
485: p_rec.appraisal_id :=
486: per_obj_shd.g_old_rec.appraisal_id;
487: End If;
488: If (p_rec.attribute_category = hr_api.g_varchar2) then
489: p_rec.attribute_category :=
490: per_obj_shd.g_old_rec.attribute_category;
491: End If;
492: If (p_rec.attribute1 = hr_api.g_varchar2) then
488: If (p_rec.attribute_category = hr_api.g_varchar2) then
489: p_rec.attribute_category :=
490: per_obj_shd.g_old_rec.attribute_category;
491: End If;
492: If (p_rec.attribute1 = hr_api.g_varchar2) then
493: p_rec.attribute1 :=
494: per_obj_shd.g_old_rec.attribute1;
495: End If;
496: If (p_rec.attribute2 = hr_api.g_varchar2) then
492: If (p_rec.attribute1 = hr_api.g_varchar2) then
493: p_rec.attribute1 :=
494: per_obj_shd.g_old_rec.attribute1;
495: End If;
496: If (p_rec.attribute2 = hr_api.g_varchar2) then
497: p_rec.attribute2 :=
498: per_obj_shd.g_old_rec.attribute2;
499: End If;
500: If (p_rec.attribute3 = hr_api.g_varchar2) then
496: If (p_rec.attribute2 = hr_api.g_varchar2) then
497: p_rec.attribute2 :=
498: per_obj_shd.g_old_rec.attribute2;
499: End If;
500: If (p_rec.attribute3 = hr_api.g_varchar2) then
501: p_rec.attribute3 :=
502: per_obj_shd.g_old_rec.attribute3;
503: End If;
504: If (p_rec.attribute4 = hr_api.g_varchar2) then
500: If (p_rec.attribute3 = hr_api.g_varchar2) then
501: p_rec.attribute3 :=
502: per_obj_shd.g_old_rec.attribute3;
503: End If;
504: If (p_rec.attribute4 = hr_api.g_varchar2) then
505: p_rec.attribute4 :=
506: per_obj_shd.g_old_rec.attribute4;
507: End If;
508: If (p_rec.attribute5 = hr_api.g_varchar2) then
504: If (p_rec.attribute4 = hr_api.g_varchar2) then
505: p_rec.attribute4 :=
506: per_obj_shd.g_old_rec.attribute4;
507: End If;
508: If (p_rec.attribute5 = hr_api.g_varchar2) then
509: p_rec.attribute5 :=
510: per_obj_shd.g_old_rec.attribute5;
511: End If;
512: If (p_rec.attribute6 = hr_api.g_varchar2) then
508: If (p_rec.attribute5 = hr_api.g_varchar2) then
509: p_rec.attribute5 :=
510: per_obj_shd.g_old_rec.attribute5;
511: End If;
512: If (p_rec.attribute6 = hr_api.g_varchar2) then
513: p_rec.attribute6 :=
514: per_obj_shd.g_old_rec.attribute6;
515: End If;
516: If (p_rec.attribute7 = hr_api.g_varchar2) then
512: If (p_rec.attribute6 = hr_api.g_varchar2) then
513: p_rec.attribute6 :=
514: per_obj_shd.g_old_rec.attribute6;
515: End If;
516: If (p_rec.attribute7 = hr_api.g_varchar2) then
517: p_rec.attribute7 :=
518: per_obj_shd.g_old_rec.attribute7;
519: End If;
520: If (p_rec.attribute8 = hr_api.g_varchar2) then
516: If (p_rec.attribute7 = hr_api.g_varchar2) then
517: p_rec.attribute7 :=
518: per_obj_shd.g_old_rec.attribute7;
519: End If;
520: If (p_rec.attribute8 = hr_api.g_varchar2) then
521: p_rec.attribute8 :=
522: per_obj_shd.g_old_rec.attribute8;
523: End If;
524: If (p_rec.attribute9 = hr_api.g_varchar2) then
520: If (p_rec.attribute8 = hr_api.g_varchar2) then
521: p_rec.attribute8 :=
522: per_obj_shd.g_old_rec.attribute8;
523: End If;
524: If (p_rec.attribute9 = hr_api.g_varchar2) then
525: p_rec.attribute9 :=
526: per_obj_shd.g_old_rec.attribute9;
527: End If;
528: If (p_rec.attribute10 = hr_api.g_varchar2) then
524: If (p_rec.attribute9 = hr_api.g_varchar2) then
525: p_rec.attribute9 :=
526: per_obj_shd.g_old_rec.attribute9;
527: End If;
528: If (p_rec.attribute10 = hr_api.g_varchar2) then
529: p_rec.attribute10 :=
530: per_obj_shd.g_old_rec.attribute10;
531: End If;
532: If (p_rec.attribute11 = hr_api.g_varchar2) then
528: If (p_rec.attribute10 = hr_api.g_varchar2) then
529: p_rec.attribute10 :=
530: per_obj_shd.g_old_rec.attribute10;
531: End If;
532: If (p_rec.attribute11 = hr_api.g_varchar2) then
533: p_rec.attribute11 :=
534: per_obj_shd.g_old_rec.attribute11;
535: End If;
536: If (p_rec.attribute12 = hr_api.g_varchar2) then
532: If (p_rec.attribute11 = hr_api.g_varchar2) then
533: p_rec.attribute11 :=
534: per_obj_shd.g_old_rec.attribute11;
535: End If;
536: If (p_rec.attribute12 = hr_api.g_varchar2) then
537: p_rec.attribute12 :=
538: per_obj_shd.g_old_rec.attribute12;
539: End If;
540: If (p_rec.attribute13 = hr_api.g_varchar2) then
536: If (p_rec.attribute12 = hr_api.g_varchar2) then
537: p_rec.attribute12 :=
538: per_obj_shd.g_old_rec.attribute12;
539: End If;
540: If (p_rec.attribute13 = hr_api.g_varchar2) then
541: p_rec.attribute13 :=
542: per_obj_shd.g_old_rec.attribute13;
543: End If;
544: If (p_rec.attribute14 = hr_api.g_varchar2) then
540: If (p_rec.attribute13 = hr_api.g_varchar2) then
541: p_rec.attribute13 :=
542: per_obj_shd.g_old_rec.attribute13;
543: End If;
544: If (p_rec.attribute14 = hr_api.g_varchar2) then
545: p_rec.attribute14 :=
546: per_obj_shd.g_old_rec.attribute14;
547: End If;
548: If (p_rec.attribute15 = hr_api.g_varchar2) then
544: If (p_rec.attribute14 = hr_api.g_varchar2) then
545: p_rec.attribute14 :=
546: per_obj_shd.g_old_rec.attribute14;
547: End If;
548: If (p_rec.attribute15 = hr_api.g_varchar2) then
549: p_rec.attribute15 :=
550: per_obj_shd.g_old_rec.attribute15;
551: End If;
552: If (p_rec.attribute16 = hr_api.g_varchar2) then
548: If (p_rec.attribute15 = hr_api.g_varchar2) then
549: p_rec.attribute15 :=
550: per_obj_shd.g_old_rec.attribute15;
551: End If;
552: If (p_rec.attribute16 = hr_api.g_varchar2) then
553: p_rec.attribute16 :=
554: per_obj_shd.g_old_rec.attribute16;
555: End If;
556: If (p_rec.attribute17 = hr_api.g_varchar2) then
552: If (p_rec.attribute16 = hr_api.g_varchar2) then
553: p_rec.attribute16 :=
554: per_obj_shd.g_old_rec.attribute16;
555: End If;
556: If (p_rec.attribute17 = hr_api.g_varchar2) then
557: p_rec.attribute17 :=
558: per_obj_shd.g_old_rec.attribute17;
559: End If;
560: If (p_rec.attribute18 = hr_api.g_varchar2) then
556: If (p_rec.attribute17 = hr_api.g_varchar2) then
557: p_rec.attribute17 :=
558: per_obj_shd.g_old_rec.attribute17;
559: End If;
560: If (p_rec.attribute18 = hr_api.g_varchar2) then
561: p_rec.attribute18 :=
562: per_obj_shd.g_old_rec.attribute18;
563: End If;
564: If (p_rec.attribute19 = hr_api.g_varchar2) then
560: If (p_rec.attribute18 = hr_api.g_varchar2) then
561: p_rec.attribute18 :=
562: per_obj_shd.g_old_rec.attribute18;
563: End If;
564: If (p_rec.attribute19 = hr_api.g_varchar2) then
565: p_rec.attribute19 :=
566: per_obj_shd.g_old_rec.attribute19;
567: End If;
568: If (p_rec.attribute20 = hr_api.g_varchar2) then
564: If (p_rec.attribute19 = hr_api.g_varchar2) then
565: p_rec.attribute19 :=
566: per_obj_shd.g_old_rec.attribute19;
567: End If;
568: If (p_rec.attribute20 = hr_api.g_varchar2) then
569: p_rec.attribute20 :=
570: per_obj_shd.g_old_rec.attribute20;
571: End If;
572: If (p_rec.attribute21 = hr_api.g_varchar2) then
568: If (p_rec.attribute20 = hr_api.g_varchar2) then
569: p_rec.attribute20 :=
570: per_obj_shd.g_old_rec.attribute20;
571: End If;
572: If (p_rec.attribute21 = hr_api.g_varchar2) then
573: p_rec.attribute21 :=
574: per_obj_shd.g_old_rec.attribute21;
575: End If;
576: If (p_rec.attribute22 = hr_api.g_varchar2) then
572: If (p_rec.attribute21 = hr_api.g_varchar2) then
573: p_rec.attribute21 :=
574: per_obj_shd.g_old_rec.attribute21;
575: End If;
576: If (p_rec.attribute22 = hr_api.g_varchar2) then
577: p_rec.attribute22 :=
578: per_obj_shd.g_old_rec.attribute22;
579: End If;
580: If (p_rec.attribute23 = hr_api.g_varchar2) then
576: If (p_rec.attribute22 = hr_api.g_varchar2) then
577: p_rec.attribute22 :=
578: per_obj_shd.g_old_rec.attribute22;
579: End If;
580: If (p_rec.attribute23 = hr_api.g_varchar2) then
581: p_rec.attribute23 :=
582: per_obj_shd.g_old_rec.attribute23;
583: End If;
584: If (p_rec.attribute24 = hr_api.g_varchar2) then
580: If (p_rec.attribute23 = hr_api.g_varchar2) then
581: p_rec.attribute23 :=
582: per_obj_shd.g_old_rec.attribute23;
583: End If;
584: If (p_rec.attribute24 = hr_api.g_varchar2) then
585: p_rec.attribute24 :=
586: per_obj_shd.g_old_rec.attribute24;
587: End If;
588: If (p_rec.attribute25 = hr_api.g_varchar2) then
584: If (p_rec.attribute24 = hr_api.g_varchar2) then
585: p_rec.attribute24 :=
586: per_obj_shd.g_old_rec.attribute24;
587: End If;
588: If (p_rec.attribute25 = hr_api.g_varchar2) then
589: p_rec.attribute25 :=
590: per_obj_shd.g_old_rec.attribute25;
591: End If;
592: If (p_rec.attribute26 = hr_api.g_varchar2) then
588: If (p_rec.attribute25 = hr_api.g_varchar2) then
589: p_rec.attribute25 :=
590: per_obj_shd.g_old_rec.attribute25;
591: End If;
592: If (p_rec.attribute26 = hr_api.g_varchar2) then
593: p_rec.attribute26 :=
594: per_obj_shd.g_old_rec.attribute26;
595: End If;
596: If (p_rec.attribute27 = hr_api.g_varchar2) then
592: If (p_rec.attribute26 = hr_api.g_varchar2) then
593: p_rec.attribute26 :=
594: per_obj_shd.g_old_rec.attribute26;
595: End If;
596: If (p_rec.attribute27 = hr_api.g_varchar2) then
597: p_rec.attribute27 :=
598: per_obj_shd.g_old_rec.attribute27;
599: End If;
600: If (p_rec.attribute28 = hr_api.g_varchar2) then
596: If (p_rec.attribute27 = hr_api.g_varchar2) then
597: p_rec.attribute27 :=
598: per_obj_shd.g_old_rec.attribute27;
599: End If;
600: If (p_rec.attribute28 = hr_api.g_varchar2) then
601: p_rec.attribute28 :=
602: per_obj_shd.g_old_rec.attribute28;
603: End If;
604: If (p_rec.attribute29 = hr_api.g_varchar2) then
600: If (p_rec.attribute28 = hr_api.g_varchar2) then
601: p_rec.attribute28 :=
602: per_obj_shd.g_old_rec.attribute28;
603: End If;
604: If (p_rec.attribute29 = hr_api.g_varchar2) then
605: p_rec.attribute29 :=
606: per_obj_shd.g_old_rec.attribute29;
607: End If;
608: If (p_rec.attribute30 = hr_api.g_varchar2) then
604: If (p_rec.attribute29 = hr_api.g_varchar2) then
605: p_rec.attribute29 :=
606: per_obj_shd.g_old_rec.attribute29;
607: End If;
608: If (p_rec.attribute30 = hr_api.g_varchar2) then
609: p_rec.attribute30 :=
610: per_obj_shd.g_old_rec.attribute30;
611: End If;
612:
609: p_rec.attribute30 :=
610: per_obj_shd.g_old_rec.attribute30;
611: End If;
612:
613: If (p_rec.scorecard_id = hr_api.g_number) then
614: p_rec.scorecard_id :=
615: per_obj_shd.g_old_rec.scorecard_id;
616: End If;
617: If (p_rec.copied_from_library_id = hr_api.g_number) then
613: If (p_rec.scorecard_id = hr_api.g_number) then
614: p_rec.scorecard_id :=
615: per_obj_shd.g_old_rec.scorecard_id;
616: End If;
617: If (p_rec.copied_from_library_id = hr_api.g_number) then
618: p_rec.copied_from_library_id :=
619: per_obj_shd.g_old_rec.copied_from_library_id;
620: End If;
621: If (p_rec.copied_from_objective_id = hr_api.g_number) then
617: If (p_rec.copied_from_library_id = hr_api.g_number) then
618: p_rec.copied_from_library_id :=
619: per_obj_shd.g_old_rec.copied_from_library_id;
620: End If;
621: If (p_rec.copied_from_objective_id = hr_api.g_number) then
622: p_rec.copied_from_objective_id :=
623: per_obj_shd.g_old_rec.copied_from_objective_id;
624: End If;
625: If (p_rec.aligned_with_objective_id = hr_api.g_number) then
621: If (p_rec.copied_from_objective_id = hr_api.g_number) then
622: p_rec.copied_from_objective_id :=
623: per_obj_shd.g_old_rec.copied_from_objective_id;
624: End If;
625: If (p_rec.aligned_with_objective_id = hr_api.g_number) then
626: p_rec.aligned_with_objective_id :=
627: per_obj_shd.g_old_rec.aligned_with_objective_id;
628: End If;
629:
626: p_rec.aligned_with_objective_id :=
627: per_obj_shd.g_old_rec.aligned_with_objective_id;
628: End If;
629:
630: If (p_rec.next_review_date = hr_api.g_date) then
631: p_rec.next_review_date :=
632: per_obj_shd.g_old_rec.next_review_date;
633: End If;
634: If (p_rec.group_code = hr_api.g_varchar2) then
630: If (p_rec.next_review_date = hr_api.g_date) then
631: p_rec.next_review_date :=
632: per_obj_shd.g_old_rec.next_review_date;
633: End If;
634: If (p_rec.group_code = hr_api.g_varchar2) then
635: p_rec.group_code :=
636: per_obj_shd.g_old_rec.group_code;
637: End If;
638: If (p_rec.priority_code = hr_api.g_varchar2) then
634: If (p_rec.group_code = hr_api.g_varchar2) then
635: p_rec.group_code :=
636: per_obj_shd.g_old_rec.group_code;
637: End If;
638: If (p_rec.priority_code = hr_api.g_varchar2) then
639: p_rec.priority_code :=
640: per_obj_shd.g_old_rec.priority_code;
641: End If;
642: If (p_rec.appraise_flag = hr_api.g_varchar2) then
638: If (p_rec.priority_code = hr_api.g_varchar2) then
639: p_rec.priority_code :=
640: per_obj_shd.g_old_rec.priority_code;
641: End If;
642: If (p_rec.appraise_flag = hr_api.g_varchar2) then
643: p_rec.appraise_flag :=
644: per_obj_shd.g_old_rec.appraise_flag;
645: End If;
646: If (p_rec.verified_flag = hr_api.g_varchar2) then
642: If (p_rec.appraise_flag = hr_api.g_varchar2) then
643: p_rec.appraise_flag :=
644: per_obj_shd.g_old_rec.appraise_flag;
645: End If;
646: If (p_rec.verified_flag = hr_api.g_varchar2) then
647: p_rec.verified_flag :=
648: per_obj_shd.g_old_rec.verified_flag;
649: End If;
650:
648: per_obj_shd.g_old_rec.verified_flag;
649: End If;
650:
651:
652: If (p_rec.target_value = hr_api.g_number) then
653: p_rec.target_value :=
654: per_obj_shd.g_old_rec.target_value;
655: End If;
656: If (p_rec.actual_value = hr_api.g_number) then
652: If (p_rec.target_value = hr_api.g_number) then
653: p_rec.target_value :=
654: per_obj_shd.g_old_rec.target_value;
655: End If;
656: If (p_rec.actual_value = hr_api.g_number) then
657: p_rec.actual_value :=
658: per_obj_shd.g_old_rec.actual_value;
659: End If;
660: If (p_rec.weighting_percent = hr_api.g_number) then
656: If (p_rec.actual_value = hr_api.g_number) then
657: p_rec.actual_value :=
658: per_obj_shd.g_old_rec.actual_value;
659: End If;
660: If (p_rec.weighting_percent = hr_api.g_number) then
661: p_rec.weighting_percent :=
662: per_obj_shd.g_old_rec.weighting_percent;
663: End If;
664: If (p_rec.complete_percent = hr_api.g_number) then
660: If (p_rec.weighting_percent = hr_api.g_number) then
661: p_rec.weighting_percent :=
662: per_obj_shd.g_old_rec.weighting_percent;
663: End If;
664: If (p_rec.complete_percent = hr_api.g_number) then
665: p_rec.complete_percent :=
666: per_obj_shd.g_old_rec.complete_percent;
667: End If;
668: If (p_rec.uom_code = hr_api.g_varchar2) then
664: If (p_rec.complete_percent = hr_api.g_number) then
665: p_rec.complete_percent :=
666: per_obj_shd.g_old_rec.complete_percent;
667: End If;
668: If (p_rec.uom_code = hr_api.g_varchar2) then
669: p_rec.uom_code :=
670: per_obj_shd.g_old_rec.uom_code;
671: End If;
672:
669: p_rec.uom_code :=
670: per_obj_shd.g_old_rec.uom_code;
671: End If;
672:
673: If (p_rec.measurement_style_code = hr_api.g_varchar2) then
674: p_rec.measurement_style_code :=
675: per_obj_shd.g_old_rec.measurement_style_code;
676: End If;
677: If (p_rec.measure_name = hr_api.g_varchar2) then
673: If (p_rec.measurement_style_code = hr_api.g_varchar2) then
674: p_rec.measurement_style_code :=
675: per_obj_shd.g_old_rec.measurement_style_code;
676: End If;
677: If (p_rec.measure_name = hr_api.g_varchar2) then
678: p_rec.measure_name :=
679: per_obj_shd.g_old_rec.measure_name;
680: End If;
681: If (p_rec.measure_type_code = hr_api.g_varchar2) then
677: If (p_rec.measure_name = hr_api.g_varchar2) then
678: p_rec.measure_name :=
679: per_obj_shd.g_old_rec.measure_name;
680: End If;
681: If (p_rec.measure_type_code = hr_api.g_varchar2) then
682: p_rec.measure_type_code :=
683: per_obj_shd.g_old_rec.measure_type_code;
684: End If;
685: If (p_rec.measure_comments = hr_api.g_varchar2) then
681: If (p_rec.measure_type_code = hr_api.g_varchar2) then
682: p_rec.measure_type_code :=
683: per_obj_shd.g_old_rec.measure_type_code;
684: End If;
685: If (p_rec.measure_comments = hr_api.g_varchar2) then
686: p_rec.measure_comments :=
687: per_obj_shd.g_old_rec.measure_comments;
688: End If;
689: If (p_rec.sharing_access_code = hr_api.g_varchar2) then
685: If (p_rec.measure_comments = hr_api.g_varchar2) then
686: p_rec.measure_comments :=
687: per_obj_shd.g_old_rec.measure_comments;
688: End If;
689: If (p_rec.sharing_access_code = hr_api.g_varchar2) then
690: p_rec.sharing_access_code :=
691: per_obj_shd.g_old_rec.sharing_access_code;
692: End If;
693:
773: --
774: -- If we are validating then raise the Validate_Enabled exception
775: --
776: If p_validate then
777: Raise HR_Api.Validate_Enabled;
778: End If;
779: --
780: hr_utility.set_location(' Leaving:'||l_proc, 10);
781: Exception
778: End If;
779: --
780: hr_utility.set_location(' Leaving:'||l_proc, 10);
781: Exception
782: When HR_Api.Validate_Enabled Then
783: --
784: -- As the Validate_Enabled exception has been raised
785: -- we must rollback to the savepoint
786: --
792: -- ----------------------------------------------------------------------------
793: Procedure upd
794: (
795: p_objective_id in number,
796: p_name in varchar2 default hr_api.g_varchar2,
797: p_target_date in date default hr_api.g_date,
798: p_start_date in date default hr_api.g_date,
799: p_object_version_number in out nocopy number,
800: p_achievement_date in date default hr_api.g_date,
793: Procedure upd
794: (
795: p_objective_id in number,
796: p_name in varchar2 default hr_api.g_varchar2,
797: p_target_date in date default hr_api.g_date,
798: p_start_date in date default hr_api.g_date,
799: p_object_version_number in out nocopy number,
800: p_achievement_date in date default hr_api.g_date,
801: p_detail in varchar2 default hr_api.g_varchar2,
794: (
795: p_objective_id in number,
796: p_name in varchar2 default hr_api.g_varchar2,
797: p_target_date in date default hr_api.g_date,
798: p_start_date in date default hr_api.g_date,
799: p_object_version_number in out nocopy number,
800: p_achievement_date in date default hr_api.g_date,
801: p_detail in varchar2 default hr_api.g_varchar2,
802: p_comments in varchar2 default hr_api.g_varchar2,
796: p_name in varchar2 default hr_api.g_varchar2,
797: p_target_date in date default hr_api.g_date,
798: p_start_date in date default hr_api.g_date,
799: p_object_version_number in out nocopy number,
800: p_achievement_date in date default hr_api.g_date,
801: p_detail in varchar2 default hr_api.g_varchar2,
802: p_comments in varchar2 default hr_api.g_varchar2,
803: p_success_criteria in varchar2 default hr_api.g_varchar2,
804: p_attribute_category in varchar2 default hr_api.g_varchar2,
797: p_target_date in date default hr_api.g_date,
798: p_start_date in date default hr_api.g_date,
799: p_object_version_number in out nocopy number,
800: p_achievement_date in date default hr_api.g_date,
801: p_detail in varchar2 default hr_api.g_varchar2,
802: p_comments in varchar2 default hr_api.g_varchar2,
803: p_success_criteria in varchar2 default hr_api.g_varchar2,
804: p_attribute_category in varchar2 default hr_api.g_varchar2,
805: p_attribute1 in varchar2 default hr_api.g_varchar2,
798: p_start_date in date default hr_api.g_date,
799: p_object_version_number in out nocopy number,
800: p_achievement_date in date default hr_api.g_date,
801: p_detail in varchar2 default hr_api.g_varchar2,
802: p_comments in varchar2 default hr_api.g_varchar2,
803: p_success_criteria in varchar2 default hr_api.g_varchar2,
804: p_attribute_category in varchar2 default hr_api.g_varchar2,
805: p_attribute1 in varchar2 default hr_api.g_varchar2,
806: p_attribute2 in varchar2 default hr_api.g_varchar2,
799: p_object_version_number in out nocopy number,
800: p_achievement_date in date default hr_api.g_date,
801: p_detail in varchar2 default hr_api.g_varchar2,
802: p_comments in varchar2 default hr_api.g_varchar2,
803: p_success_criteria in varchar2 default hr_api.g_varchar2,
804: p_attribute_category in varchar2 default hr_api.g_varchar2,
805: p_attribute1 in varchar2 default hr_api.g_varchar2,
806: p_attribute2 in varchar2 default hr_api.g_varchar2,
807: p_attribute3 in varchar2 default hr_api.g_varchar2,
800: p_achievement_date in date default hr_api.g_date,
801: p_detail in varchar2 default hr_api.g_varchar2,
802: p_comments in varchar2 default hr_api.g_varchar2,
803: p_success_criteria in varchar2 default hr_api.g_varchar2,
804: p_attribute_category in varchar2 default hr_api.g_varchar2,
805: p_attribute1 in varchar2 default hr_api.g_varchar2,
806: p_attribute2 in varchar2 default hr_api.g_varchar2,
807: p_attribute3 in varchar2 default hr_api.g_varchar2,
808: p_attribute4 in varchar2 default hr_api.g_varchar2,
801: p_detail in varchar2 default hr_api.g_varchar2,
802: p_comments in varchar2 default hr_api.g_varchar2,
803: p_success_criteria in varchar2 default hr_api.g_varchar2,
804: p_attribute_category in varchar2 default hr_api.g_varchar2,
805: p_attribute1 in varchar2 default hr_api.g_varchar2,
806: p_attribute2 in varchar2 default hr_api.g_varchar2,
807: p_attribute3 in varchar2 default hr_api.g_varchar2,
808: p_attribute4 in varchar2 default hr_api.g_varchar2,
809: p_attribute5 in varchar2 default hr_api.g_varchar2,
802: p_comments in varchar2 default hr_api.g_varchar2,
803: p_success_criteria in varchar2 default hr_api.g_varchar2,
804: p_attribute_category in varchar2 default hr_api.g_varchar2,
805: p_attribute1 in varchar2 default hr_api.g_varchar2,
806: p_attribute2 in varchar2 default hr_api.g_varchar2,
807: p_attribute3 in varchar2 default hr_api.g_varchar2,
808: p_attribute4 in varchar2 default hr_api.g_varchar2,
809: p_attribute5 in varchar2 default hr_api.g_varchar2,
810: p_attribute6 in varchar2 default hr_api.g_varchar2,
803: p_success_criteria in varchar2 default hr_api.g_varchar2,
804: p_attribute_category in varchar2 default hr_api.g_varchar2,
805: p_attribute1 in varchar2 default hr_api.g_varchar2,
806: p_attribute2 in varchar2 default hr_api.g_varchar2,
807: p_attribute3 in varchar2 default hr_api.g_varchar2,
808: p_attribute4 in varchar2 default hr_api.g_varchar2,
809: p_attribute5 in varchar2 default hr_api.g_varchar2,
810: p_attribute6 in varchar2 default hr_api.g_varchar2,
811: p_attribute7 in varchar2 default hr_api.g_varchar2,
804: p_attribute_category in varchar2 default hr_api.g_varchar2,
805: p_attribute1 in varchar2 default hr_api.g_varchar2,
806: p_attribute2 in varchar2 default hr_api.g_varchar2,
807: p_attribute3 in varchar2 default hr_api.g_varchar2,
808: p_attribute4 in varchar2 default hr_api.g_varchar2,
809: p_attribute5 in varchar2 default hr_api.g_varchar2,
810: p_attribute6 in varchar2 default hr_api.g_varchar2,
811: p_attribute7 in varchar2 default hr_api.g_varchar2,
812: p_attribute8 in varchar2 default hr_api.g_varchar2,
805: p_attribute1 in varchar2 default hr_api.g_varchar2,
806: p_attribute2 in varchar2 default hr_api.g_varchar2,
807: p_attribute3 in varchar2 default hr_api.g_varchar2,
808: p_attribute4 in varchar2 default hr_api.g_varchar2,
809: p_attribute5 in varchar2 default hr_api.g_varchar2,
810: p_attribute6 in varchar2 default hr_api.g_varchar2,
811: p_attribute7 in varchar2 default hr_api.g_varchar2,
812: p_attribute8 in varchar2 default hr_api.g_varchar2,
813: p_attribute9 in varchar2 default hr_api.g_varchar2,
806: p_attribute2 in varchar2 default hr_api.g_varchar2,
807: p_attribute3 in varchar2 default hr_api.g_varchar2,
808: p_attribute4 in varchar2 default hr_api.g_varchar2,
809: p_attribute5 in varchar2 default hr_api.g_varchar2,
810: p_attribute6 in varchar2 default hr_api.g_varchar2,
811: p_attribute7 in varchar2 default hr_api.g_varchar2,
812: p_attribute8 in varchar2 default hr_api.g_varchar2,
813: p_attribute9 in varchar2 default hr_api.g_varchar2,
814: p_attribute10 in varchar2 default hr_api.g_varchar2,
807: p_attribute3 in varchar2 default hr_api.g_varchar2,
808: p_attribute4 in varchar2 default hr_api.g_varchar2,
809: p_attribute5 in varchar2 default hr_api.g_varchar2,
810: p_attribute6 in varchar2 default hr_api.g_varchar2,
811: p_attribute7 in varchar2 default hr_api.g_varchar2,
812: p_attribute8 in varchar2 default hr_api.g_varchar2,
813: p_attribute9 in varchar2 default hr_api.g_varchar2,
814: p_attribute10 in varchar2 default hr_api.g_varchar2,
815: p_attribute11 in varchar2 default hr_api.g_varchar2,
808: p_attribute4 in varchar2 default hr_api.g_varchar2,
809: p_attribute5 in varchar2 default hr_api.g_varchar2,
810: p_attribute6 in varchar2 default hr_api.g_varchar2,
811: p_attribute7 in varchar2 default hr_api.g_varchar2,
812: p_attribute8 in varchar2 default hr_api.g_varchar2,
813: p_attribute9 in varchar2 default hr_api.g_varchar2,
814: p_attribute10 in varchar2 default hr_api.g_varchar2,
815: p_attribute11 in varchar2 default hr_api.g_varchar2,
816: p_attribute12 in varchar2 default hr_api.g_varchar2,
809: p_attribute5 in varchar2 default hr_api.g_varchar2,
810: p_attribute6 in varchar2 default hr_api.g_varchar2,
811: p_attribute7 in varchar2 default hr_api.g_varchar2,
812: p_attribute8 in varchar2 default hr_api.g_varchar2,
813: p_attribute9 in varchar2 default hr_api.g_varchar2,
814: p_attribute10 in varchar2 default hr_api.g_varchar2,
815: p_attribute11 in varchar2 default hr_api.g_varchar2,
816: p_attribute12 in varchar2 default hr_api.g_varchar2,
817: p_attribute13 in varchar2 default hr_api.g_varchar2,
810: p_attribute6 in varchar2 default hr_api.g_varchar2,
811: p_attribute7 in varchar2 default hr_api.g_varchar2,
812: p_attribute8 in varchar2 default hr_api.g_varchar2,
813: p_attribute9 in varchar2 default hr_api.g_varchar2,
814: p_attribute10 in varchar2 default hr_api.g_varchar2,
815: p_attribute11 in varchar2 default hr_api.g_varchar2,
816: p_attribute12 in varchar2 default hr_api.g_varchar2,
817: p_attribute13 in varchar2 default hr_api.g_varchar2,
818: p_attribute14 in varchar2 default hr_api.g_varchar2,
811: p_attribute7 in varchar2 default hr_api.g_varchar2,
812: p_attribute8 in varchar2 default hr_api.g_varchar2,
813: p_attribute9 in varchar2 default hr_api.g_varchar2,
814: p_attribute10 in varchar2 default hr_api.g_varchar2,
815: p_attribute11 in varchar2 default hr_api.g_varchar2,
816: p_attribute12 in varchar2 default hr_api.g_varchar2,
817: p_attribute13 in varchar2 default hr_api.g_varchar2,
818: p_attribute14 in varchar2 default hr_api.g_varchar2,
819: p_attribute15 in varchar2 default hr_api.g_varchar2,
812: p_attribute8 in varchar2 default hr_api.g_varchar2,
813: p_attribute9 in varchar2 default hr_api.g_varchar2,
814: p_attribute10 in varchar2 default hr_api.g_varchar2,
815: p_attribute11 in varchar2 default hr_api.g_varchar2,
816: p_attribute12 in varchar2 default hr_api.g_varchar2,
817: p_attribute13 in varchar2 default hr_api.g_varchar2,
818: p_attribute14 in varchar2 default hr_api.g_varchar2,
819: p_attribute15 in varchar2 default hr_api.g_varchar2,
820: p_attribute16 in varchar2 default hr_api.g_varchar2,
813: p_attribute9 in varchar2 default hr_api.g_varchar2,
814: p_attribute10 in varchar2 default hr_api.g_varchar2,
815: p_attribute11 in varchar2 default hr_api.g_varchar2,
816: p_attribute12 in varchar2 default hr_api.g_varchar2,
817: p_attribute13 in varchar2 default hr_api.g_varchar2,
818: p_attribute14 in varchar2 default hr_api.g_varchar2,
819: p_attribute15 in varchar2 default hr_api.g_varchar2,
820: p_attribute16 in varchar2 default hr_api.g_varchar2,
821: p_attribute17 in varchar2 default hr_api.g_varchar2,
814: p_attribute10 in varchar2 default hr_api.g_varchar2,
815: p_attribute11 in varchar2 default hr_api.g_varchar2,
816: p_attribute12 in varchar2 default hr_api.g_varchar2,
817: p_attribute13 in varchar2 default hr_api.g_varchar2,
818: p_attribute14 in varchar2 default hr_api.g_varchar2,
819: p_attribute15 in varchar2 default hr_api.g_varchar2,
820: p_attribute16 in varchar2 default hr_api.g_varchar2,
821: p_attribute17 in varchar2 default hr_api.g_varchar2,
822: p_attribute18 in varchar2 default hr_api.g_varchar2,
815: p_attribute11 in varchar2 default hr_api.g_varchar2,
816: p_attribute12 in varchar2 default hr_api.g_varchar2,
817: p_attribute13 in varchar2 default hr_api.g_varchar2,
818: p_attribute14 in varchar2 default hr_api.g_varchar2,
819: p_attribute15 in varchar2 default hr_api.g_varchar2,
820: p_attribute16 in varchar2 default hr_api.g_varchar2,
821: p_attribute17 in varchar2 default hr_api.g_varchar2,
822: p_attribute18 in varchar2 default hr_api.g_varchar2,
823: p_attribute19 in varchar2 default hr_api.g_varchar2,
816: p_attribute12 in varchar2 default hr_api.g_varchar2,
817: p_attribute13 in varchar2 default hr_api.g_varchar2,
818: p_attribute14 in varchar2 default hr_api.g_varchar2,
819: p_attribute15 in varchar2 default hr_api.g_varchar2,
820: p_attribute16 in varchar2 default hr_api.g_varchar2,
821: p_attribute17 in varchar2 default hr_api.g_varchar2,
822: p_attribute18 in varchar2 default hr_api.g_varchar2,
823: p_attribute19 in varchar2 default hr_api.g_varchar2,
824: p_attribute20 in varchar2 default hr_api.g_varchar2,
817: p_attribute13 in varchar2 default hr_api.g_varchar2,
818: p_attribute14 in varchar2 default hr_api.g_varchar2,
819: p_attribute15 in varchar2 default hr_api.g_varchar2,
820: p_attribute16 in varchar2 default hr_api.g_varchar2,
821: p_attribute17 in varchar2 default hr_api.g_varchar2,
822: p_attribute18 in varchar2 default hr_api.g_varchar2,
823: p_attribute19 in varchar2 default hr_api.g_varchar2,
824: p_attribute20 in varchar2 default hr_api.g_varchar2,
825:
818: p_attribute14 in varchar2 default hr_api.g_varchar2,
819: p_attribute15 in varchar2 default hr_api.g_varchar2,
820: p_attribute16 in varchar2 default hr_api.g_varchar2,
821: p_attribute17 in varchar2 default hr_api.g_varchar2,
822: p_attribute18 in varchar2 default hr_api.g_varchar2,
823: p_attribute19 in varchar2 default hr_api.g_varchar2,
824: p_attribute20 in varchar2 default hr_api.g_varchar2,
825:
826: p_attribute21 in varchar2 default hr_api.g_varchar2,
819: p_attribute15 in varchar2 default hr_api.g_varchar2,
820: p_attribute16 in varchar2 default hr_api.g_varchar2,
821: p_attribute17 in varchar2 default hr_api.g_varchar2,
822: p_attribute18 in varchar2 default hr_api.g_varchar2,
823: p_attribute19 in varchar2 default hr_api.g_varchar2,
824: p_attribute20 in varchar2 default hr_api.g_varchar2,
825:
826: p_attribute21 in varchar2 default hr_api.g_varchar2,
827: p_attribute22 in varchar2 default hr_api.g_varchar2,
820: p_attribute16 in varchar2 default hr_api.g_varchar2,
821: p_attribute17 in varchar2 default hr_api.g_varchar2,
822: p_attribute18 in varchar2 default hr_api.g_varchar2,
823: p_attribute19 in varchar2 default hr_api.g_varchar2,
824: p_attribute20 in varchar2 default hr_api.g_varchar2,
825:
826: p_attribute21 in varchar2 default hr_api.g_varchar2,
827: p_attribute22 in varchar2 default hr_api.g_varchar2,
828: p_attribute23 in varchar2 default hr_api.g_varchar2,
822: p_attribute18 in varchar2 default hr_api.g_varchar2,
823: p_attribute19 in varchar2 default hr_api.g_varchar2,
824: p_attribute20 in varchar2 default hr_api.g_varchar2,
825:
826: p_attribute21 in varchar2 default hr_api.g_varchar2,
827: p_attribute22 in varchar2 default hr_api.g_varchar2,
828: p_attribute23 in varchar2 default hr_api.g_varchar2,
829: p_attribute24 in varchar2 default hr_api.g_varchar2,
830: p_attribute25 in varchar2 default hr_api.g_varchar2,
823: p_attribute19 in varchar2 default hr_api.g_varchar2,
824: p_attribute20 in varchar2 default hr_api.g_varchar2,
825:
826: p_attribute21 in varchar2 default hr_api.g_varchar2,
827: p_attribute22 in varchar2 default hr_api.g_varchar2,
828: p_attribute23 in varchar2 default hr_api.g_varchar2,
829: p_attribute24 in varchar2 default hr_api.g_varchar2,
830: p_attribute25 in varchar2 default hr_api.g_varchar2,
831: p_attribute26 in varchar2 default hr_api.g_varchar2,
824: p_attribute20 in varchar2 default hr_api.g_varchar2,
825:
826: p_attribute21 in varchar2 default hr_api.g_varchar2,
827: p_attribute22 in varchar2 default hr_api.g_varchar2,
828: p_attribute23 in varchar2 default hr_api.g_varchar2,
829: p_attribute24 in varchar2 default hr_api.g_varchar2,
830: p_attribute25 in varchar2 default hr_api.g_varchar2,
831: p_attribute26 in varchar2 default hr_api.g_varchar2,
832: p_attribute27 in varchar2 default hr_api.g_varchar2,
825:
826: p_attribute21 in varchar2 default hr_api.g_varchar2,
827: p_attribute22 in varchar2 default hr_api.g_varchar2,
828: p_attribute23 in varchar2 default hr_api.g_varchar2,
829: p_attribute24 in varchar2 default hr_api.g_varchar2,
830: p_attribute25 in varchar2 default hr_api.g_varchar2,
831: p_attribute26 in varchar2 default hr_api.g_varchar2,
832: p_attribute27 in varchar2 default hr_api.g_varchar2,
833: p_attribute28 in varchar2 default hr_api.g_varchar2,
826: p_attribute21 in varchar2 default hr_api.g_varchar2,
827: p_attribute22 in varchar2 default hr_api.g_varchar2,
828: p_attribute23 in varchar2 default hr_api.g_varchar2,
829: p_attribute24 in varchar2 default hr_api.g_varchar2,
830: p_attribute25 in varchar2 default hr_api.g_varchar2,
831: p_attribute26 in varchar2 default hr_api.g_varchar2,
832: p_attribute27 in varchar2 default hr_api.g_varchar2,
833: p_attribute28 in varchar2 default hr_api.g_varchar2,
834: p_attribute29 in varchar2 default hr_api.g_varchar2,
827: p_attribute22 in varchar2 default hr_api.g_varchar2,
828: p_attribute23 in varchar2 default hr_api.g_varchar2,
829: p_attribute24 in varchar2 default hr_api.g_varchar2,
830: p_attribute25 in varchar2 default hr_api.g_varchar2,
831: p_attribute26 in varchar2 default hr_api.g_varchar2,
832: p_attribute27 in varchar2 default hr_api.g_varchar2,
833: p_attribute28 in varchar2 default hr_api.g_varchar2,
834: p_attribute29 in varchar2 default hr_api.g_varchar2,
835: p_attribute30 in varchar2 default hr_api.g_varchar2,
828: p_attribute23 in varchar2 default hr_api.g_varchar2,
829: p_attribute24 in varchar2 default hr_api.g_varchar2,
830: p_attribute25 in varchar2 default hr_api.g_varchar2,
831: p_attribute26 in varchar2 default hr_api.g_varchar2,
832: p_attribute27 in varchar2 default hr_api.g_varchar2,
833: p_attribute28 in varchar2 default hr_api.g_varchar2,
834: p_attribute29 in varchar2 default hr_api.g_varchar2,
835: p_attribute30 in varchar2 default hr_api.g_varchar2,
836:
829: p_attribute24 in varchar2 default hr_api.g_varchar2,
830: p_attribute25 in varchar2 default hr_api.g_varchar2,
831: p_attribute26 in varchar2 default hr_api.g_varchar2,
832: p_attribute27 in varchar2 default hr_api.g_varchar2,
833: p_attribute28 in varchar2 default hr_api.g_varchar2,
834: p_attribute29 in varchar2 default hr_api.g_varchar2,
835: p_attribute30 in varchar2 default hr_api.g_varchar2,
836:
837: p_scorecard_id in number default hr_api.g_number,
830: p_attribute25 in varchar2 default hr_api.g_varchar2,
831: p_attribute26 in varchar2 default hr_api.g_varchar2,
832: p_attribute27 in varchar2 default hr_api.g_varchar2,
833: p_attribute28 in varchar2 default hr_api.g_varchar2,
834: p_attribute29 in varchar2 default hr_api.g_varchar2,
835: p_attribute30 in varchar2 default hr_api.g_varchar2,
836:
837: p_scorecard_id in number default hr_api.g_number,
838: p_copied_from_library_id in number default hr_api.g_number,
831: p_attribute26 in varchar2 default hr_api.g_varchar2,
832: p_attribute27 in varchar2 default hr_api.g_varchar2,
833: p_attribute28 in varchar2 default hr_api.g_varchar2,
834: p_attribute29 in varchar2 default hr_api.g_varchar2,
835: p_attribute30 in varchar2 default hr_api.g_varchar2,
836:
837: p_scorecard_id in number default hr_api.g_number,
838: p_copied_from_library_id in number default hr_api.g_number,
839: p_copied_from_objective_id in number default hr_api.g_number,
833: p_attribute28 in varchar2 default hr_api.g_varchar2,
834: p_attribute29 in varchar2 default hr_api.g_varchar2,
835: p_attribute30 in varchar2 default hr_api.g_varchar2,
836:
837: p_scorecard_id in number default hr_api.g_number,
838: p_copied_from_library_id in number default hr_api.g_number,
839: p_copied_from_objective_id in number default hr_api.g_number,
840: p_aligned_with_objective_id in number default hr_api.g_number,
841:
834: p_attribute29 in varchar2 default hr_api.g_varchar2,
835: p_attribute30 in varchar2 default hr_api.g_varchar2,
836:
837: p_scorecard_id in number default hr_api.g_number,
838: p_copied_from_library_id in number default hr_api.g_number,
839: p_copied_from_objective_id in number default hr_api.g_number,
840: p_aligned_with_objective_id in number default hr_api.g_number,
841:
842: p_next_review_date in date default hr_api.g_date,
835: p_attribute30 in varchar2 default hr_api.g_varchar2,
836:
837: p_scorecard_id in number default hr_api.g_number,
838: p_copied_from_library_id in number default hr_api.g_number,
839: p_copied_from_objective_id in number default hr_api.g_number,
840: p_aligned_with_objective_id in number default hr_api.g_number,
841:
842: p_next_review_date in date default hr_api.g_date,
843: p_group_code in varchar2 default hr_api.g_varchar2,
836:
837: p_scorecard_id in number default hr_api.g_number,
838: p_copied_from_library_id in number default hr_api.g_number,
839: p_copied_from_objective_id in number default hr_api.g_number,
840: p_aligned_with_objective_id in number default hr_api.g_number,
841:
842: p_next_review_date in date default hr_api.g_date,
843: p_group_code in varchar2 default hr_api.g_varchar2,
844: p_priority_code in varchar2 default hr_api.g_varchar2,
838: p_copied_from_library_id in number default hr_api.g_number,
839: p_copied_from_objective_id in number default hr_api.g_number,
840: p_aligned_with_objective_id in number default hr_api.g_number,
841:
842: p_next_review_date in date default hr_api.g_date,
843: p_group_code in varchar2 default hr_api.g_varchar2,
844: p_priority_code in varchar2 default hr_api.g_varchar2,
845: p_appraise_flag in varchar2 default hr_api.g_varchar2,
846: p_verified_flag in varchar2 default hr_api.g_varchar2,
839: p_copied_from_objective_id in number default hr_api.g_number,
840: p_aligned_with_objective_id in number default hr_api.g_number,
841:
842: p_next_review_date in date default hr_api.g_date,
843: p_group_code in varchar2 default hr_api.g_varchar2,
844: p_priority_code in varchar2 default hr_api.g_varchar2,
845: p_appraise_flag in varchar2 default hr_api.g_varchar2,
846: p_verified_flag in varchar2 default hr_api.g_varchar2,
847:
840: p_aligned_with_objective_id in number default hr_api.g_number,
841:
842: p_next_review_date in date default hr_api.g_date,
843: p_group_code in varchar2 default hr_api.g_varchar2,
844: p_priority_code in varchar2 default hr_api.g_varchar2,
845: p_appraise_flag in varchar2 default hr_api.g_varchar2,
846: p_verified_flag in varchar2 default hr_api.g_varchar2,
847:
848: p_target_value in number default hr_api.g_number,
841:
842: p_next_review_date in date default hr_api.g_date,
843: p_group_code in varchar2 default hr_api.g_varchar2,
844: p_priority_code in varchar2 default hr_api.g_varchar2,
845: p_appraise_flag in varchar2 default hr_api.g_varchar2,
846: p_verified_flag in varchar2 default hr_api.g_varchar2,
847:
848: p_target_value in number default hr_api.g_number,
849: p_actual_value in number default hr_api.g_number,
842: p_next_review_date in date default hr_api.g_date,
843: p_group_code in varchar2 default hr_api.g_varchar2,
844: p_priority_code in varchar2 default hr_api.g_varchar2,
845: p_appraise_flag in varchar2 default hr_api.g_varchar2,
846: p_verified_flag in varchar2 default hr_api.g_varchar2,
847:
848: p_target_value in number default hr_api.g_number,
849: p_actual_value in number default hr_api.g_number,
850: p_weighting_percent in number default hr_api.g_number,
844: p_priority_code in varchar2 default hr_api.g_varchar2,
845: p_appraise_flag in varchar2 default hr_api.g_varchar2,
846: p_verified_flag in varchar2 default hr_api.g_varchar2,
847:
848: p_target_value in number default hr_api.g_number,
849: p_actual_value in number default hr_api.g_number,
850: p_weighting_percent in number default hr_api.g_number,
851: p_complete_percent in number default hr_api.g_number,
852: p_uom_code in varchar2 default hr_api.g_varchar2,
845: p_appraise_flag in varchar2 default hr_api.g_varchar2,
846: p_verified_flag in varchar2 default hr_api.g_varchar2,
847:
848: p_target_value in number default hr_api.g_number,
849: p_actual_value in number default hr_api.g_number,
850: p_weighting_percent in number default hr_api.g_number,
851: p_complete_percent in number default hr_api.g_number,
852: p_uom_code in varchar2 default hr_api.g_varchar2,
853:
846: p_verified_flag in varchar2 default hr_api.g_varchar2,
847:
848: p_target_value in number default hr_api.g_number,
849: p_actual_value in number default hr_api.g_number,
850: p_weighting_percent in number default hr_api.g_number,
851: p_complete_percent in number default hr_api.g_number,
852: p_uom_code in varchar2 default hr_api.g_varchar2,
853:
854: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
847:
848: p_target_value in number default hr_api.g_number,
849: p_actual_value in number default hr_api.g_number,
850: p_weighting_percent in number default hr_api.g_number,
851: p_complete_percent in number default hr_api.g_number,
852: p_uom_code in varchar2 default hr_api.g_varchar2,
853:
854: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
855: p_measure_name in varchar2 default hr_api.g_varchar2,
848: p_target_value in number default hr_api.g_number,
849: p_actual_value in number default hr_api.g_number,
850: p_weighting_percent in number default hr_api.g_number,
851: p_complete_percent in number default hr_api.g_number,
852: p_uom_code in varchar2 default hr_api.g_varchar2,
853:
854: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
855: p_measure_name in varchar2 default hr_api.g_varchar2,
856: p_measure_type_code in varchar2 default hr_api.g_varchar2,
850: p_weighting_percent in number default hr_api.g_number,
851: p_complete_percent in number default hr_api.g_number,
852: p_uom_code in varchar2 default hr_api.g_varchar2,
853:
854: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
855: p_measure_name in varchar2 default hr_api.g_varchar2,
856: p_measure_type_code in varchar2 default hr_api.g_varchar2,
857: p_measure_comments in varchar2 default hr_api.g_varchar2,
858: p_sharing_access_code in varchar2 default hr_api.g_varchar2,
851: p_complete_percent in number default hr_api.g_number,
852: p_uom_code in varchar2 default hr_api.g_varchar2,
853:
854: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
855: p_measure_name in varchar2 default hr_api.g_varchar2,
856: p_measure_type_code in varchar2 default hr_api.g_varchar2,
857: p_measure_comments in varchar2 default hr_api.g_varchar2,
858: p_sharing_access_code in varchar2 default hr_api.g_varchar2,
859:
852: p_uom_code in varchar2 default hr_api.g_varchar2,
853:
854: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
855: p_measure_name in varchar2 default hr_api.g_varchar2,
856: p_measure_type_code in varchar2 default hr_api.g_varchar2,
857: p_measure_comments in varchar2 default hr_api.g_varchar2,
858: p_sharing_access_code in varchar2 default hr_api.g_varchar2,
859:
860: p_weighting_over_100_warning out nocopy boolean,
853:
854: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
855: p_measure_name in varchar2 default hr_api.g_varchar2,
856: p_measure_type_code in varchar2 default hr_api.g_varchar2,
857: p_measure_comments in varchar2 default hr_api.g_varchar2,
858: p_sharing_access_code in varchar2 default hr_api.g_varchar2,
859:
860: p_weighting_over_100_warning out nocopy boolean,
861: p_weighting_appraisal_warning out nocopy boolean,
854: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
855: p_measure_name in varchar2 default hr_api.g_varchar2,
856: p_measure_type_code in varchar2 default hr_api.g_varchar2,
857: p_measure_comments in varchar2 default hr_api.g_varchar2,
858: p_sharing_access_code in varchar2 default hr_api.g_varchar2,
859:
860: p_weighting_over_100_warning out nocopy boolean,
861: p_weighting_appraisal_warning out nocopy boolean,
862:
861: p_weighting_appraisal_warning out nocopy boolean,
862:
863: p_effective_date in date,
864: p_validate in boolean default false,
865: p_appraisal_id in number default hr_api.g_number
866: ) is
867: --
868: l_rec per_obj_shd.g_rec_type;
869: l_proc varchar2(72) := g_package||'upd';
883: p_objective_id,
884: p_name,
885: p_target_date,
886: p_start_date,
887: hr_api.g_number,
888: p_object_version_number,
889: hr_api.g_number,
890: p_achievement_date,
891: p_detail,
885: p_target_date,
886: p_start_date,
887: hr_api.g_number,
888: p_object_version_number,
889: hr_api.g_number,
890: p_achievement_date,
891: p_detail,
892: p_comments,
893: p_success_criteria,