APPS.PER_OBJ_UPD dependencies on HR_API

Line 135: When hr_api.check_integrity_violated Then

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

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

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));

Line 139: When hr_api.parent_integrity_violated Then

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

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

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));

Line 143: When hr_api.unique_integrity_violated Then

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

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

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: --

Line 380: when hr_api.cannot_find_prog_unit then

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: );

Line 381: hr_api.cannot_find_prog_unit_error

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;

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

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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:

Line 613: If (p_rec.scorecard_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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:

Line 630: If (p_rec.next_review_date = hr_api.g_date) then

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

Line 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

Line 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

Line 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

Line 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:

Line 652: If (p_rec.target_value = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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:

Line 673: If (p_rec.measurement_style_code = hr_api.g_varchar2) then

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

Line 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

Line 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

Line 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

Line 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:

Line 777: Raise HR_Api.Validate_Enabled;

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

Line 782: When HR_Api.Validate_Enabled Then

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: --

Line 796: p_name in varchar2 default hr_api.g_varchar2,

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,

Line 797: p_target_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,

Line 798: p_start_date in date default hr_api.g_date,

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,

Line 800: p_achievement_date in date default hr_api.g_date,

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,

Line 801: p_detail 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,

Line 802: p_comments 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,

Line 803: p_success_criteria 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,

Line 804: p_attribute_category 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,

Line 805: p_attribute1 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,

Line 806: p_attribute2 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,

Line 807: p_attribute3 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,

Line 808: p_attribute4 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,

Line 809: p_attribute5 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,

Line 810: p_attribute6 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,

Line 811: p_attribute7 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,

Line 812: p_attribute8 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,

Line 813: p_attribute9 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,

Line 814: p_attribute10 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,

Line 815: p_attribute11 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,

Line 816: p_attribute12 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,

Line 817: p_attribute13 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,

Line 818: p_attribute14 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,

Line 819: p_attribute15 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,

Line 820: p_attribute16 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,

Line 821: p_attribute17 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:

Line 822: p_attribute18 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:
826: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 823: p_attribute19 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,

Line 824: p_attribute20 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,

Line 826: p_attribute21 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,

Line 827: p_attribute22 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,

Line 828: p_attribute23 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,

Line 829: p_attribute24 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,

Line 830: p_attribute25 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,

Line 831: p_attribute26 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,

Line 832: p_attribute27 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:

Line 833: p_attribute28 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:
837: p_scorecard_id in number default hr_api.g_number,

Line 834: p_attribute29 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,
838: p_copied_from_library_id in number default hr_api.g_number,

Line 835: p_attribute30 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,
839: p_copied_from_objective_id in number default hr_api.g_number,

Line 837: p_scorecard_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:

Line 838: p_copied_from_library_id in number default hr_api.g_number,

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,

Line 839: p_copied_from_objective_id in number default hr_api.g_number,

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,

Line 840: p_aligned_with_objective_id in number default hr_api.g_number,

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,

Line 842: p_next_review_date in date default hr_api.g_date,

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,

Line 843: p_group_code 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:

Line 844: p_priority_code in varchar2 default hr_api.g_varchar2,

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,

Line 845: p_appraise_flag in varchar2 default hr_api.g_varchar2,

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,

Line 846: p_verified_flag in varchar2 default hr_api.g_varchar2,

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,

Line 848: p_target_value 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,

Line 849: p_actual_value in number default hr_api.g_number,

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:

Line 850: p_weighting_percent in number default hr_api.g_number,

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,

Line 851: p_complete_percent in number default hr_api.g_number,

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,

Line 852: p_uom_code 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,

Line 854: p_measurement_style_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,

Line 855: p_measure_name 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:

Line 856: p_measure_type_code in varchar2 default hr_api.g_varchar2,

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,

Line 857: p_measure_comments 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,
861: p_weighting_appraisal_warning out nocopy boolean,

Line 858: p_sharing_access_code in varchar2 default hr_api.g_varchar2,

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:

Line 865: p_appraisal_id in number default hr_api.g_number

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';

Line 887: hr_api.g_number,

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,

Line 889: hr_api.g_number,

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,