159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 10);
161: --
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: --
166: per_mea_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: --
166: per_mea_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.parent_integrity_violated Then
169: -- Parent integrity has been violated
170: --
171: per_mea_shd.constraint_error
164: -- A check constraint has been violated
165: --
166: per_mea_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.parent_integrity_violated Then
169: -- Parent integrity has been violated
170: --
171: per_mea_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.parent_integrity_violated Then
169: -- Parent integrity has been violated
170: --
171: per_mea_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.unique_integrity_violated Then
174: -- Unique integrity has been violated
175: --
176: per_mea_shd.constraint_error
169: -- Parent integrity has been violated
170: --
171: per_mea_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.unique_integrity_violated Then
174: -- Unique integrity has been violated
175: --
176: per_mea_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.unique_integrity_violated Then
174: -- Unique integrity has been violated
175: --
176: per_mea_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When Others Then
179: --
180: Raise;
181: End update_dml;
419: );
420: --
421: exception
422: --
423: when hr_api.cannot_find_prog_unit then
424: --
425: hr_api.cannot_find_prog_unit_error
426: (p_module_name => 'PER_MEDICAL_ASSESSMENTS'
427: ,p_hook_type => 'AU');
421: exception
422: --
423: when hr_api.cannot_find_prog_unit then
424: --
425: hr_api.cannot_find_prog_unit_error
426: (p_module_name => 'PER_MEDICAL_ASSESSMENTS'
427: ,p_hook_type => 'AU');
428: --
429: end;
488: -- p_rec plsql record structure
489: -- to see if a system default is being used. If a system default
490: -- is being used then we must set to the 'current' argument value.
491: --
492: If (p_rec.person_id = hr_api.g_number) then
493: p_rec.person_id :=
494: per_mea_shd.g_old_rec.person_id;
495: End If;
496: --
495: End If;
496: --
497: hr_utility.set_location(l_proc, 20);
498: --
499: If (p_rec.examiner_name = hr_api.g_varchar2) then
500: p_rec.examiner_name :=
501: per_mea_shd.g_old_rec.examiner_name;
502: End If;
503: --
502: End If;
503: --
504: hr_utility.set_location(l_proc, 30);
505: --
506: If (p_rec.organization_id = hr_api.g_number) then
507: p_rec.organization_id :=
508: per_mea_shd.g_old_rec.organization_id;
509: End If;
510: --
509: End If;
510: --
511: hr_utility.set_location(l_proc, 40);
512: --
513: If (p_rec.consultation_date = hr_api.g_date) then
514: p_rec.consultation_date :=
515: per_mea_shd.g_old_rec.consultation_date;
516: End If;
517: --
516: End If;
517: --
518: hr_utility.set_location(l_proc, 50);
519: --
520: If (p_rec.consultation_type = hr_api.g_varchar2) then
521: p_rec.consultation_type :=
522: per_mea_shd.g_old_rec.consultation_type;
523: End If;
524: --
523: End If;
524: --
525: hr_utility.set_location(l_proc, 60);
526: --
527: If (p_rec.incident_id = hr_api.g_number) then
528: p_rec.incident_id :=
529: per_mea_shd.g_old_rec.incident_id;
530: End If;
531: --
530: End If;
531: --
532: hr_utility.set_location(l_proc, 70);
533: --
534: If (p_rec.consultation_result = hr_api.g_varchar2) then
535: p_rec.consultation_result :=
536: per_mea_shd.g_old_rec.consultation_result;
537: End If;
538: --
537: End If;
538: --
539: hr_utility.set_location(l_proc, 80);
540: --
541: If (p_rec.disability_id = hr_api.g_number) then
542: p_rec.disability_id :=
543: per_mea_shd.g_old_rec.disability_id;
544: End If;
545: --
544: End If;
545: --
546: hr_utility.set_location(l_proc, 90);
547: --
548: If (p_rec.next_consultation_date = hr_api.g_date) then
549: p_rec.next_consultation_date :=
550: per_mea_shd.g_old_rec.next_consultation_date;
551: End If; --
552: hr_utility.set_location(l_proc, 100);
550: per_mea_shd.g_old_rec.next_consultation_date;
551: End If; --
552: hr_utility.set_location(l_proc, 100);
553: --
554: If (p_rec.description = hr_api.g_varchar2) then
555: p_rec.description :=
556: per_mea_shd.g_old_rec.description;
557: End If; --
558: hr_utility.set_location(l_proc, 110);
556: per_mea_shd.g_old_rec.description;
557: End If; --
558: hr_utility.set_location(l_proc, 110);
559: --
560: If (p_rec.attribute_category = hr_api.g_varchar2) then
561: p_rec.attribute_category :=
562: per_mea_shd.g_old_rec.attribute_category;
563: End If;
564: If (p_rec.attribute1 = hr_api.g_varchar2) then
560: If (p_rec.attribute_category = hr_api.g_varchar2) then
561: p_rec.attribute_category :=
562: per_mea_shd.g_old_rec.attribute_category;
563: End If;
564: If (p_rec.attribute1 = hr_api.g_varchar2) then
565: p_rec.attribute1 :=
566: per_mea_shd.g_old_rec.attribute1;
567: End If;
568: If (p_rec.attribute2 = hr_api.g_varchar2) then
564: If (p_rec.attribute1 = hr_api.g_varchar2) then
565: p_rec.attribute1 :=
566: per_mea_shd.g_old_rec.attribute1;
567: End If;
568: If (p_rec.attribute2 = hr_api.g_varchar2) then
569: p_rec.attribute2 :=
570: per_mea_shd.g_old_rec.attribute2;
571: End If;
572: If (p_rec.attribute3 = hr_api.g_varchar2) then
568: If (p_rec.attribute2 = hr_api.g_varchar2) then
569: p_rec.attribute2 :=
570: per_mea_shd.g_old_rec.attribute2;
571: End If;
572: If (p_rec.attribute3 = hr_api.g_varchar2) then
573: p_rec.attribute3 :=
574: per_mea_shd.g_old_rec.attribute3;
575: End If;
576: If (p_rec.attribute4 = hr_api.g_varchar2) then
572: If (p_rec.attribute3 = hr_api.g_varchar2) then
573: p_rec.attribute3 :=
574: per_mea_shd.g_old_rec.attribute3;
575: End If;
576: If (p_rec.attribute4 = hr_api.g_varchar2) then
577: p_rec.attribute4 :=
578: per_mea_shd.g_old_rec.attribute4;
579: End If;
580: If (p_rec.attribute5 = hr_api.g_varchar2) then
576: If (p_rec.attribute4 = hr_api.g_varchar2) then
577: p_rec.attribute4 :=
578: per_mea_shd.g_old_rec.attribute4;
579: End If;
580: If (p_rec.attribute5 = hr_api.g_varchar2) then
581: p_rec.attribute5 :=
582: per_mea_shd.g_old_rec.attribute5;
583: End If;
584: If (p_rec.attribute6 = hr_api.g_varchar2) then
580: If (p_rec.attribute5 = hr_api.g_varchar2) then
581: p_rec.attribute5 :=
582: per_mea_shd.g_old_rec.attribute5;
583: End If;
584: If (p_rec.attribute6 = hr_api.g_varchar2) then
585: p_rec.attribute6 :=
586: per_mea_shd.g_old_rec.attribute6;
587: End If;
588: If (p_rec.attribute7 = hr_api.g_varchar2) then
584: If (p_rec.attribute6 = hr_api.g_varchar2) then
585: p_rec.attribute6 :=
586: per_mea_shd.g_old_rec.attribute6;
587: End If;
588: If (p_rec.attribute7 = hr_api.g_varchar2) then
589: p_rec.attribute7 :=
590: per_mea_shd.g_old_rec.attribute7;
591: End If;
592: If (p_rec.attribute8 = hr_api.g_varchar2) then
588: If (p_rec.attribute7 = hr_api.g_varchar2) then
589: p_rec.attribute7 :=
590: per_mea_shd.g_old_rec.attribute7;
591: End If;
592: If (p_rec.attribute8 = hr_api.g_varchar2) then
593: p_rec.attribute8 :=
594: per_mea_shd.g_old_rec.attribute8;
595: End If;
596: If (p_rec.attribute9 = hr_api.g_varchar2) then
592: If (p_rec.attribute8 = hr_api.g_varchar2) then
593: p_rec.attribute8 :=
594: per_mea_shd.g_old_rec.attribute8;
595: End If;
596: If (p_rec.attribute9 = hr_api.g_varchar2) then
597: p_rec.attribute9 :=
598: per_mea_shd.g_old_rec.attribute9;
599: End If;
600: If (p_rec.attribute10 = hr_api.g_varchar2) then
596: If (p_rec.attribute9 = hr_api.g_varchar2) then
597: p_rec.attribute9 :=
598: per_mea_shd.g_old_rec.attribute9;
599: End If;
600: If (p_rec.attribute10 = hr_api.g_varchar2) then
601: p_rec.attribute10 :=
602: per_mea_shd.g_old_rec.attribute10;
603: End If;
604: If (p_rec.attribute11 = hr_api.g_varchar2) then
600: If (p_rec.attribute10 = hr_api.g_varchar2) then
601: p_rec.attribute10 :=
602: per_mea_shd.g_old_rec.attribute10;
603: End If;
604: If (p_rec.attribute11 = hr_api.g_varchar2) then
605: p_rec.attribute11 :=
606: per_mea_shd.g_old_rec.attribute11;
607: End If;
608: If (p_rec.attribute12 = hr_api.g_varchar2) then
604: If (p_rec.attribute11 = hr_api.g_varchar2) then
605: p_rec.attribute11 :=
606: per_mea_shd.g_old_rec.attribute11;
607: End If;
608: If (p_rec.attribute12 = hr_api.g_varchar2) then
609: p_rec.attribute12 :=
610: per_mea_shd.g_old_rec.attribute12;
611: End If;
612: If (p_rec.attribute13 = hr_api.g_varchar2) then
608: If (p_rec.attribute12 = hr_api.g_varchar2) then
609: p_rec.attribute12 :=
610: per_mea_shd.g_old_rec.attribute12;
611: End If;
612: If (p_rec.attribute13 = hr_api.g_varchar2) then
613: p_rec.attribute13 :=
614: per_mea_shd.g_old_rec.attribute13;
615: End If;
616: If (p_rec.attribute14 = hr_api.g_varchar2) then
612: If (p_rec.attribute13 = hr_api.g_varchar2) then
613: p_rec.attribute13 :=
614: per_mea_shd.g_old_rec.attribute13;
615: End If;
616: If (p_rec.attribute14 = hr_api.g_varchar2) then
617: p_rec.attribute14 :=
618: per_mea_shd.g_old_rec.attribute14;
619: End If;
620: If (p_rec.attribute15 = hr_api.g_varchar2) then
616: If (p_rec.attribute14 = hr_api.g_varchar2) then
617: p_rec.attribute14 :=
618: per_mea_shd.g_old_rec.attribute14;
619: End If;
620: If (p_rec.attribute15 = hr_api.g_varchar2) then
621: p_rec.attribute15 :=
622: per_mea_shd.g_old_rec.attribute15;
623: End If;
624: If (p_rec.attribute16 = hr_api.g_varchar2) then
620: If (p_rec.attribute15 = hr_api.g_varchar2) then
621: p_rec.attribute15 :=
622: per_mea_shd.g_old_rec.attribute15;
623: End If;
624: If (p_rec.attribute16 = hr_api.g_varchar2) then
625: p_rec.attribute16 :=
626: per_mea_shd.g_old_rec.attribute16;
627: End If;
628: If (p_rec.attribute17 = hr_api.g_varchar2) then
624: If (p_rec.attribute16 = hr_api.g_varchar2) then
625: p_rec.attribute16 :=
626: per_mea_shd.g_old_rec.attribute16;
627: End If;
628: If (p_rec.attribute17 = hr_api.g_varchar2) then
629: p_rec.attribute17 :=
630: per_mea_shd.g_old_rec.attribute17;
631: End If;
632: If (p_rec.attribute18 = hr_api.g_varchar2) then
628: If (p_rec.attribute17 = hr_api.g_varchar2) then
629: p_rec.attribute17 :=
630: per_mea_shd.g_old_rec.attribute17;
631: End If;
632: If (p_rec.attribute18 = hr_api.g_varchar2) then
633: p_rec.attribute18 :=
634: per_mea_shd.g_old_rec.attribute18;
635: End If;
636: If (p_rec.attribute19 = hr_api.g_varchar2) then
632: If (p_rec.attribute18 = hr_api.g_varchar2) then
633: p_rec.attribute18 :=
634: per_mea_shd.g_old_rec.attribute18;
635: End If;
636: If (p_rec.attribute19 = hr_api.g_varchar2) then
637: p_rec.attribute19 :=
638: per_mea_shd.g_old_rec.attribute19;
639: End If;
640: If (p_rec.attribute20 = hr_api.g_varchar2) then
636: If (p_rec.attribute19 = hr_api.g_varchar2) then
637: p_rec.attribute19 :=
638: per_mea_shd.g_old_rec.attribute19;
639: End If;
640: If (p_rec.attribute20 = hr_api.g_varchar2) then
641: p_rec.attribute20 :=
642: per_mea_shd.g_old_rec.attribute20;
643: End If;
644: If (p_rec.attribute21 = hr_api.g_varchar2) then
640: If (p_rec.attribute20 = hr_api.g_varchar2) then
641: p_rec.attribute20 :=
642: per_mea_shd.g_old_rec.attribute20;
643: End If;
644: If (p_rec.attribute21 = hr_api.g_varchar2) then
645: p_rec.attribute21 :=
646: per_mea_shd.g_old_rec.attribute21;
647: End If;
648: If (p_rec.attribute22 = hr_api.g_varchar2) then
644: If (p_rec.attribute21 = hr_api.g_varchar2) then
645: p_rec.attribute21 :=
646: per_mea_shd.g_old_rec.attribute21;
647: End If;
648: If (p_rec.attribute22 = hr_api.g_varchar2) then
649: p_rec.attribute22 :=
650: per_mea_shd.g_old_rec.attribute22;
651: End If;
652: If (p_rec.attribute23 = hr_api.g_varchar2) then
648: If (p_rec.attribute22 = hr_api.g_varchar2) then
649: p_rec.attribute22 :=
650: per_mea_shd.g_old_rec.attribute22;
651: End If;
652: If (p_rec.attribute23 = hr_api.g_varchar2) then
653: p_rec.attribute23 :=
654: per_mea_shd.g_old_rec.attribute23;
655: End If;
656: If (p_rec.attribute24 = hr_api.g_varchar2) then
652: If (p_rec.attribute23 = hr_api.g_varchar2) then
653: p_rec.attribute23 :=
654: per_mea_shd.g_old_rec.attribute23;
655: End If;
656: If (p_rec.attribute24 = hr_api.g_varchar2) then
657: p_rec.attribute24 :=
658: per_mea_shd.g_old_rec.attribute24;
659: End If;
660: If (p_rec.attribute25 = hr_api.g_varchar2) then
656: If (p_rec.attribute24 = hr_api.g_varchar2) then
657: p_rec.attribute24 :=
658: per_mea_shd.g_old_rec.attribute24;
659: End If;
660: If (p_rec.attribute25 = hr_api.g_varchar2) then
661: p_rec.attribute25 :=
662: per_mea_shd.g_old_rec.attribute25;
663: End If;
664: If (p_rec.attribute26 = hr_api.g_varchar2) then
660: If (p_rec.attribute25 = hr_api.g_varchar2) then
661: p_rec.attribute25 :=
662: per_mea_shd.g_old_rec.attribute25;
663: End If;
664: If (p_rec.attribute26 = hr_api.g_varchar2) then
665: p_rec.attribute26 :=
666: per_mea_shd.g_old_rec.attribute26;
667: End If;
668: If (p_rec.attribute27 = hr_api.g_varchar2) then
664: If (p_rec.attribute26 = hr_api.g_varchar2) then
665: p_rec.attribute26 :=
666: per_mea_shd.g_old_rec.attribute26;
667: End If;
668: If (p_rec.attribute27 = hr_api.g_varchar2) then
669: p_rec.attribute27 :=
670: per_mea_shd.g_old_rec.attribute27;
671: End If;
672: If (p_rec.attribute28 = hr_api.g_varchar2) then
668: If (p_rec.attribute27 = hr_api.g_varchar2) then
669: p_rec.attribute27 :=
670: per_mea_shd.g_old_rec.attribute27;
671: End If;
672: If (p_rec.attribute28 = hr_api.g_varchar2) then
673: p_rec.attribute28 :=
674: per_mea_shd.g_old_rec.attribute28;
675: End If;
676: If (p_rec.attribute29 = hr_api.g_varchar2) then
672: If (p_rec.attribute28 = hr_api.g_varchar2) then
673: p_rec.attribute28 :=
674: per_mea_shd.g_old_rec.attribute28;
675: End If;
676: If (p_rec.attribute29 = hr_api.g_varchar2) then
677: p_rec.attribute29 :=
678: per_mea_shd.g_old_rec.attribute29;
679: End If;
680: If (p_rec.attribute30 = hr_api.g_varchar2) then
676: If (p_rec.attribute29 = hr_api.g_varchar2) then
677: p_rec.attribute29 :=
678: per_mea_shd.g_old_rec.attribute29;
679: End If;
680: If (p_rec.attribute30 = hr_api.g_varchar2) then
681: p_rec.attribute30 :=
682: per_mea_shd.g_old_rec.attribute30;
683: End If;
684: If (p_rec.mea_information_category = hr_api.g_varchar2) then
680: If (p_rec.attribute30 = hr_api.g_varchar2) then
681: p_rec.attribute30 :=
682: per_mea_shd.g_old_rec.attribute30;
683: End If;
684: If (p_rec.mea_information_category = hr_api.g_varchar2) then
685: p_rec.mea_information_category :=
686: per_mea_shd.g_old_rec.mea_information_category;
687: End If;
688: If (p_rec.mea_information1 = hr_api.g_varchar2) then
684: If (p_rec.mea_information_category = hr_api.g_varchar2) then
685: p_rec.mea_information_category :=
686: per_mea_shd.g_old_rec.mea_information_category;
687: End If;
688: If (p_rec.mea_information1 = hr_api.g_varchar2) then
689: p_rec.mea_information1 :=
690: per_mea_shd.g_old_rec.mea_information1;
691: End If;
692: If (p_rec.mea_information2 = hr_api.g_varchar2) then
688: If (p_rec.mea_information1 = hr_api.g_varchar2) then
689: p_rec.mea_information1 :=
690: per_mea_shd.g_old_rec.mea_information1;
691: End If;
692: If (p_rec.mea_information2 = hr_api.g_varchar2) then
693: p_rec.mea_information2 :=
694: per_mea_shd.g_old_rec.mea_information2;
695: End If;
696: If (p_rec.mea_information3 = hr_api.g_varchar2) then
692: If (p_rec.mea_information2 = hr_api.g_varchar2) then
693: p_rec.mea_information2 :=
694: per_mea_shd.g_old_rec.mea_information2;
695: End If;
696: If (p_rec.mea_information3 = hr_api.g_varchar2) then
697: p_rec.mea_information3 :=
698: per_mea_shd.g_old_rec.mea_information3;
699: End If;
700: If (p_rec.mea_information4 = hr_api.g_varchar2) then
696: If (p_rec.mea_information3 = hr_api.g_varchar2) then
697: p_rec.mea_information3 :=
698: per_mea_shd.g_old_rec.mea_information3;
699: End If;
700: If (p_rec.mea_information4 = hr_api.g_varchar2) then
701: p_rec.mea_information4 :=
702: per_mea_shd.g_old_rec.mea_information4;
703: End If;
704: If (p_rec.mea_information5 = hr_api.g_varchar2) then
700: If (p_rec.mea_information4 = hr_api.g_varchar2) then
701: p_rec.mea_information4 :=
702: per_mea_shd.g_old_rec.mea_information4;
703: End If;
704: If (p_rec.mea_information5 = hr_api.g_varchar2) then
705: p_rec.mea_information5 :=
706: per_mea_shd.g_old_rec.mea_information5;
707: End If;
708: If (p_rec.mea_information6 = hr_api.g_varchar2) then
704: If (p_rec.mea_information5 = hr_api.g_varchar2) then
705: p_rec.mea_information5 :=
706: per_mea_shd.g_old_rec.mea_information5;
707: End If;
708: If (p_rec.mea_information6 = hr_api.g_varchar2) then
709: p_rec.mea_information6 :=
710: per_mea_shd.g_old_rec.mea_information6;
711: End If;
712: If (p_rec.mea_information7 = hr_api.g_varchar2) then
708: If (p_rec.mea_information6 = hr_api.g_varchar2) then
709: p_rec.mea_information6 :=
710: per_mea_shd.g_old_rec.mea_information6;
711: End If;
712: If (p_rec.mea_information7 = hr_api.g_varchar2) then
713: p_rec.mea_information7 :=
714: per_mea_shd.g_old_rec.mea_information7;
715: End If;
716: If (p_rec.mea_information8 = hr_api.g_varchar2) then
712: If (p_rec.mea_information7 = hr_api.g_varchar2) then
713: p_rec.mea_information7 :=
714: per_mea_shd.g_old_rec.mea_information7;
715: End If;
716: If (p_rec.mea_information8 = hr_api.g_varchar2) then
717: p_rec.mea_information8 :=
718: per_mea_shd.g_old_rec.mea_information8;
719: End If;
720: If (p_rec.mea_information9 = hr_api.g_varchar2) then
716: If (p_rec.mea_information8 = hr_api.g_varchar2) then
717: p_rec.mea_information8 :=
718: per_mea_shd.g_old_rec.mea_information8;
719: End If;
720: If (p_rec.mea_information9 = hr_api.g_varchar2) then
721: p_rec.mea_information9 :=
722: per_mea_shd.g_old_rec.mea_information9;
723: End If;
724: If (p_rec.mea_information10 = hr_api.g_varchar2) then
720: If (p_rec.mea_information9 = hr_api.g_varchar2) then
721: p_rec.mea_information9 :=
722: per_mea_shd.g_old_rec.mea_information9;
723: End If;
724: If (p_rec.mea_information10 = hr_api.g_varchar2) then
725: p_rec.mea_information10 :=
726: per_mea_shd.g_old_rec.mea_information10;
727: End If;
728: If (p_rec.mea_information11 = hr_api.g_varchar2) then
724: If (p_rec.mea_information10 = hr_api.g_varchar2) then
725: p_rec.mea_information10 :=
726: per_mea_shd.g_old_rec.mea_information10;
727: End If;
728: If (p_rec.mea_information11 = hr_api.g_varchar2) then
729: p_rec.mea_information11 :=
730: per_mea_shd.g_old_rec.mea_information11;
731: End If;
732: If (p_rec.mea_information12 = hr_api.g_varchar2) then
728: If (p_rec.mea_information11 = hr_api.g_varchar2) then
729: p_rec.mea_information11 :=
730: per_mea_shd.g_old_rec.mea_information11;
731: End If;
732: If (p_rec.mea_information12 = hr_api.g_varchar2) then
733: p_rec.mea_information12 :=
734: per_mea_shd.g_old_rec.mea_information12;
735: End If;
736: If (p_rec.mea_information13 = hr_api.g_varchar2) then
732: If (p_rec.mea_information12 = hr_api.g_varchar2) then
733: p_rec.mea_information12 :=
734: per_mea_shd.g_old_rec.mea_information12;
735: End If;
736: If (p_rec.mea_information13 = hr_api.g_varchar2) then
737: p_rec.mea_information13 :=
738: per_mea_shd.g_old_rec.mea_information13;
739: End If;
740: If (p_rec.mea_information14 = hr_api.g_varchar2) then
736: If (p_rec.mea_information13 = hr_api.g_varchar2) then
737: p_rec.mea_information13 :=
738: per_mea_shd.g_old_rec.mea_information13;
739: End If;
740: If (p_rec.mea_information14 = hr_api.g_varchar2) then
741: p_rec.mea_information14 :=
742: per_mea_shd.g_old_rec.mea_information14;
743: End If;
744: If (p_rec.mea_information15 = hr_api.g_varchar2) then
740: If (p_rec.mea_information14 = hr_api.g_varchar2) then
741: p_rec.mea_information14 :=
742: per_mea_shd.g_old_rec.mea_information14;
743: End If;
744: If (p_rec.mea_information15 = hr_api.g_varchar2) then
745: p_rec.mea_information15 :=
746: per_mea_shd.g_old_rec.mea_information15;
747: End If;
748: If (p_rec.mea_information16 = hr_api.g_varchar2) then
744: If (p_rec.mea_information15 = hr_api.g_varchar2) then
745: p_rec.mea_information15 :=
746: per_mea_shd.g_old_rec.mea_information15;
747: End If;
748: If (p_rec.mea_information16 = hr_api.g_varchar2) then
749: p_rec.mea_information16 :=
750: per_mea_shd.g_old_rec.mea_information16;
751: End If;
752: If (p_rec.mea_information17 = hr_api.g_varchar2) then
748: If (p_rec.mea_information16 = hr_api.g_varchar2) then
749: p_rec.mea_information16 :=
750: per_mea_shd.g_old_rec.mea_information16;
751: End If;
752: If (p_rec.mea_information17 = hr_api.g_varchar2) then
753: p_rec.mea_information17 :=
754: per_mea_shd.g_old_rec.mea_information17;
755: End If;
756: If (p_rec.mea_information18 = hr_api.g_varchar2) then
752: If (p_rec.mea_information17 = hr_api.g_varchar2) then
753: p_rec.mea_information17 :=
754: per_mea_shd.g_old_rec.mea_information17;
755: End If;
756: If (p_rec.mea_information18 = hr_api.g_varchar2) then
757: p_rec.mea_information18 :=
758: per_mea_shd.g_old_rec.mea_information18;
759: End If;
760: If (p_rec.mea_information19 = hr_api.g_varchar2) then
756: If (p_rec.mea_information18 = hr_api.g_varchar2) then
757: p_rec.mea_information18 :=
758: per_mea_shd.g_old_rec.mea_information18;
759: End If;
760: If (p_rec.mea_information19 = hr_api.g_varchar2) then
761: p_rec.mea_information19 :=
762: per_mea_shd.g_old_rec.mea_information19;
763: End If;
764: If (p_rec.mea_information20 = hr_api.g_varchar2) then
760: If (p_rec.mea_information19 = hr_api.g_varchar2) then
761: p_rec.mea_information19 :=
762: per_mea_shd.g_old_rec.mea_information19;
763: End If;
764: If (p_rec.mea_information20 = hr_api.g_varchar2) then
765: p_rec.mea_information20 :=
766: per_mea_shd.g_old_rec.mea_information20;
767: End If;
768: If (p_rec.mea_information21 = hr_api.g_varchar2) then
764: If (p_rec.mea_information20 = hr_api.g_varchar2) then
765: p_rec.mea_information20 :=
766: per_mea_shd.g_old_rec.mea_information20;
767: End If;
768: If (p_rec.mea_information21 = hr_api.g_varchar2) then
769: p_rec.mea_information21 :=
770: per_mea_shd.g_old_rec.mea_information21;
771: End If;
772: If (p_rec.mea_information22 = hr_api.g_varchar2) then
768: If (p_rec.mea_information21 = hr_api.g_varchar2) then
769: p_rec.mea_information21 :=
770: per_mea_shd.g_old_rec.mea_information21;
771: End If;
772: If (p_rec.mea_information22 = hr_api.g_varchar2) then
773: p_rec.mea_information22 :=
774: per_mea_shd.g_old_rec.mea_information22;
775: End If;
776: If (p_rec.mea_information23 = hr_api.g_varchar2) then
772: If (p_rec.mea_information22 = hr_api.g_varchar2) then
773: p_rec.mea_information22 :=
774: per_mea_shd.g_old_rec.mea_information22;
775: End If;
776: If (p_rec.mea_information23 = hr_api.g_varchar2) then
777: p_rec.mea_information23 :=
778: per_mea_shd.g_old_rec.mea_information23;
779: End If;
780: If (p_rec.mea_information24 = hr_api.g_varchar2) then
776: If (p_rec.mea_information23 = hr_api.g_varchar2) then
777: p_rec.mea_information23 :=
778: per_mea_shd.g_old_rec.mea_information23;
779: End If;
780: If (p_rec.mea_information24 = hr_api.g_varchar2) then
781: p_rec.mea_information24 :=
782: per_mea_shd.g_old_rec.mea_information24;
783: End If;
784: If (p_rec.mea_information25 = hr_api.g_varchar2) then
780: If (p_rec.mea_information24 = hr_api.g_varchar2) then
781: p_rec.mea_information24 :=
782: per_mea_shd.g_old_rec.mea_information24;
783: End If;
784: If (p_rec.mea_information25 = hr_api.g_varchar2) then
785: p_rec.mea_information25 :=
786: per_mea_shd.g_old_rec.mea_information25;
787: End If;
788: If (p_rec.mea_information26 = hr_api.g_varchar2) then
784: If (p_rec.mea_information25 = hr_api.g_varchar2) then
785: p_rec.mea_information25 :=
786: per_mea_shd.g_old_rec.mea_information25;
787: End If;
788: If (p_rec.mea_information26 = hr_api.g_varchar2) then
789: p_rec.mea_information26 :=
790: per_mea_shd.g_old_rec.mea_information26;
791: End If;
792: If (p_rec.mea_information27 = hr_api.g_varchar2) then
788: If (p_rec.mea_information26 = hr_api.g_varchar2) then
789: p_rec.mea_information26 :=
790: per_mea_shd.g_old_rec.mea_information26;
791: End If;
792: If (p_rec.mea_information27 = hr_api.g_varchar2) then
793: p_rec.mea_information27 :=
794: per_mea_shd.g_old_rec.mea_information27;
795: End If;
796: If (p_rec.mea_information28 = hr_api.g_varchar2) then
792: If (p_rec.mea_information27 = hr_api.g_varchar2) then
793: p_rec.mea_information27 :=
794: per_mea_shd.g_old_rec.mea_information27;
795: End If;
796: If (p_rec.mea_information28 = hr_api.g_varchar2) then
797: p_rec.mea_information28 :=
798: per_mea_shd.g_old_rec.mea_information28;
799: End If;
800: If (p_rec.mea_information29 = hr_api.g_varchar2) then
796: If (p_rec.mea_information28 = hr_api.g_varchar2) then
797: p_rec.mea_information28 :=
798: per_mea_shd.g_old_rec.mea_information28;
799: End If;
800: If (p_rec.mea_information29 = hr_api.g_varchar2) then
801: p_rec.mea_information29 :=
802: per_mea_shd.g_old_rec.mea_information29;
803: End If;
804: If (p_rec.mea_information30 = hr_api.g_varchar2) then
800: If (p_rec.mea_information29 = hr_api.g_varchar2) then
801: p_rec.mea_information29 :=
802: per_mea_shd.g_old_rec.mea_information29;
803: End If;
804: If (p_rec.mea_information30 = hr_api.g_varchar2) then
805: p_rec.mea_information30 :=
806: per_mea_shd.g_old_rec.mea_information30;
807: End If;
808: --
878: Procedure upd
879: (p_effective_date in date
880: ,p_medical_assessment_id in number
881: ,p_object_version_number in out nocopy number
882: ,p_consultation_date in date default hr_api.g_date
883: ,p_consultation_type in varchar2 default hr_api.g_varchar2
884: ,p_examiner_name in varchar2 default hr_api.g_varchar2
885: ,p_organization_id in number default hr_api.g_number
886: ,p_incident_id in number default hr_api.g_number
879: (p_effective_date in date
880: ,p_medical_assessment_id in number
881: ,p_object_version_number in out nocopy number
882: ,p_consultation_date in date default hr_api.g_date
883: ,p_consultation_type in varchar2 default hr_api.g_varchar2
884: ,p_examiner_name in varchar2 default hr_api.g_varchar2
885: ,p_organization_id in number default hr_api.g_number
886: ,p_incident_id in number default hr_api.g_number
887: ,p_consultation_result in varchar2 default hr_api.g_varchar2
880: ,p_medical_assessment_id in number
881: ,p_object_version_number in out nocopy number
882: ,p_consultation_date in date default hr_api.g_date
883: ,p_consultation_type in varchar2 default hr_api.g_varchar2
884: ,p_examiner_name in varchar2 default hr_api.g_varchar2
885: ,p_organization_id in number default hr_api.g_number
886: ,p_incident_id in number default hr_api.g_number
887: ,p_consultation_result in varchar2 default hr_api.g_varchar2
888: ,p_disability_id in number default hr_api.g_number
881: ,p_object_version_number in out nocopy number
882: ,p_consultation_date in date default hr_api.g_date
883: ,p_consultation_type in varchar2 default hr_api.g_varchar2
884: ,p_examiner_name in varchar2 default hr_api.g_varchar2
885: ,p_organization_id in number default hr_api.g_number
886: ,p_incident_id in number default hr_api.g_number
887: ,p_consultation_result in varchar2 default hr_api.g_varchar2
888: ,p_disability_id in number default hr_api.g_number
889: ,p_next_consultation_date in date default hr_api.g_date
882: ,p_consultation_date in date default hr_api.g_date
883: ,p_consultation_type in varchar2 default hr_api.g_varchar2
884: ,p_examiner_name in varchar2 default hr_api.g_varchar2
885: ,p_organization_id in number default hr_api.g_number
886: ,p_incident_id in number default hr_api.g_number
887: ,p_consultation_result in varchar2 default hr_api.g_varchar2
888: ,p_disability_id in number default hr_api.g_number
889: ,p_next_consultation_date in date default hr_api.g_date
890: ,p_description in varchar2 default hr_api.g_varchar2
883: ,p_consultation_type in varchar2 default hr_api.g_varchar2
884: ,p_examiner_name in varchar2 default hr_api.g_varchar2
885: ,p_organization_id in number default hr_api.g_number
886: ,p_incident_id in number default hr_api.g_number
887: ,p_consultation_result in varchar2 default hr_api.g_varchar2
888: ,p_disability_id in number default hr_api.g_number
889: ,p_next_consultation_date in date default hr_api.g_date
890: ,p_description in varchar2 default hr_api.g_varchar2
891: ,p_attribute_category in varchar2 default hr_api.g_varchar2
884: ,p_examiner_name in varchar2 default hr_api.g_varchar2
885: ,p_organization_id in number default hr_api.g_number
886: ,p_incident_id in number default hr_api.g_number
887: ,p_consultation_result in varchar2 default hr_api.g_varchar2
888: ,p_disability_id in number default hr_api.g_number
889: ,p_next_consultation_date in date default hr_api.g_date
890: ,p_description in varchar2 default hr_api.g_varchar2
891: ,p_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_attribute1 in varchar2 default hr_api.g_varchar2
885: ,p_organization_id in number default hr_api.g_number
886: ,p_incident_id in number default hr_api.g_number
887: ,p_consultation_result in varchar2 default hr_api.g_varchar2
888: ,p_disability_id in number default hr_api.g_number
889: ,p_next_consultation_date in date default hr_api.g_date
890: ,p_description in varchar2 default hr_api.g_varchar2
891: ,p_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_attribute2 in varchar2 default hr_api.g_varchar2
886: ,p_incident_id in number default hr_api.g_number
887: ,p_consultation_result in varchar2 default hr_api.g_varchar2
888: ,p_disability_id in number default hr_api.g_number
889: ,p_next_consultation_date in date default hr_api.g_date
890: ,p_description in varchar2 default hr_api.g_varchar2
891: ,p_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_attribute3 in varchar2 default hr_api.g_varchar2
887: ,p_consultation_result in varchar2 default hr_api.g_varchar2
888: ,p_disability_id in number default hr_api.g_number
889: ,p_next_consultation_date in date default hr_api.g_date
890: ,p_description in varchar2 default hr_api.g_varchar2
891: ,p_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_attribute4 in varchar2 default hr_api.g_varchar2
888: ,p_disability_id in number default hr_api.g_number
889: ,p_next_consultation_date in date default hr_api.g_date
890: ,p_description in varchar2 default hr_api.g_varchar2
891: ,p_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_attribute5 in varchar2 default hr_api.g_varchar2
889: ,p_next_consultation_date in date default hr_api.g_date
890: ,p_description in varchar2 default hr_api.g_varchar2
891: ,p_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_attribute6 in varchar2 default hr_api.g_varchar2
890: ,p_description in varchar2 default hr_api.g_varchar2
891: ,p_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_attribute7 in varchar2 default hr_api.g_varchar2
891: ,p_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_attribute8 in varchar2 default hr_api.g_varchar2
892: ,p_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_attribute9 in varchar2 default hr_api.g_varchar2
893: ,p_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_attribute10 in varchar2 default hr_api.g_varchar2
894: ,p_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_attribute11 in varchar2 default hr_api.g_varchar2
895: ,p_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_attribute12 in varchar2 default hr_api.g_varchar2
896: ,p_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_attribute13 in varchar2 default hr_api.g_varchar2
897: ,p_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_attribute14 in varchar2 default hr_api.g_varchar2
898: ,p_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_attribute15 in varchar2 default hr_api.g_varchar2
899: ,p_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_attribute16 in varchar2 default hr_api.g_varchar2
900: ,p_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_attribute17 in varchar2 default hr_api.g_varchar2
901: ,p_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_attribute18 in varchar2 default hr_api.g_varchar2
902: ,p_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_attribute19 in varchar2 default hr_api.g_varchar2
903: ,p_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_attribute20 in varchar2 default hr_api.g_varchar2
904: ,p_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_attribute21 in varchar2 default hr_api.g_varchar2
905: ,p_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_attribute22 in varchar2 default hr_api.g_varchar2
906: ,p_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_attribute23 in varchar2 default hr_api.g_varchar2
907: ,p_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_attribute24 in varchar2 default hr_api.g_varchar2
908: ,p_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_attribute25 in varchar2 default hr_api.g_varchar2
909: ,p_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_attribute26 in varchar2 default hr_api.g_varchar2
910: ,p_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_attribute27 in varchar2 default hr_api.g_varchar2
911: ,p_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_attribute28 in varchar2 default hr_api.g_varchar2
912: ,p_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_attribute29 in varchar2 default hr_api.g_varchar2
913: ,p_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_attribute30 in varchar2 default hr_api.g_varchar2
914: ,p_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_attribute30 in varchar2 default hr_api.g_varchar2
922: ,p_mea_information_category in varchar2 default hr_api.g_varchar2
915: ,p_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_attribute30 in varchar2 default hr_api.g_varchar2
922: ,p_mea_information_category in varchar2 default hr_api.g_varchar2
923: ,p_mea_information1 in varchar2 default hr_api.g_varchar2
916: ,p_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_attribute30 in varchar2 default hr_api.g_varchar2
922: ,p_mea_information_category in varchar2 default hr_api.g_varchar2
923: ,p_mea_information1 in varchar2 default hr_api.g_varchar2
924: ,p_mea_information2 in varchar2 default hr_api.g_varchar2
917: ,p_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_attribute30 in varchar2 default hr_api.g_varchar2
922: ,p_mea_information_category in varchar2 default hr_api.g_varchar2
923: ,p_mea_information1 in varchar2 default hr_api.g_varchar2
924: ,p_mea_information2 in varchar2 default hr_api.g_varchar2
925: ,p_mea_information3 in varchar2 default hr_api.g_varchar2
918: ,p_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_attribute30 in varchar2 default hr_api.g_varchar2
922: ,p_mea_information_category in varchar2 default hr_api.g_varchar2
923: ,p_mea_information1 in varchar2 default hr_api.g_varchar2
924: ,p_mea_information2 in varchar2 default hr_api.g_varchar2
925: ,p_mea_information3 in varchar2 default hr_api.g_varchar2
926: ,p_mea_information4 in varchar2 default hr_api.g_varchar2
919: ,p_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_attribute30 in varchar2 default hr_api.g_varchar2
922: ,p_mea_information_category in varchar2 default hr_api.g_varchar2
923: ,p_mea_information1 in varchar2 default hr_api.g_varchar2
924: ,p_mea_information2 in varchar2 default hr_api.g_varchar2
925: ,p_mea_information3 in varchar2 default hr_api.g_varchar2
926: ,p_mea_information4 in varchar2 default hr_api.g_varchar2
927: ,p_mea_information5 in varchar2 default hr_api.g_varchar2
920: ,p_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_attribute30 in varchar2 default hr_api.g_varchar2
922: ,p_mea_information_category in varchar2 default hr_api.g_varchar2
923: ,p_mea_information1 in varchar2 default hr_api.g_varchar2
924: ,p_mea_information2 in varchar2 default hr_api.g_varchar2
925: ,p_mea_information3 in varchar2 default hr_api.g_varchar2
926: ,p_mea_information4 in varchar2 default hr_api.g_varchar2
927: ,p_mea_information5 in varchar2 default hr_api.g_varchar2
928: ,p_mea_information6 in varchar2 default hr_api.g_varchar2
921: ,p_attribute30 in varchar2 default hr_api.g_varchar2
922: ,p_mea_information_category in varchar2 default hr_api.g_varchar2
923: ,p_mea_information1 in varchar2 default hr_api.g_varchar2
924: ,p_mea_information2 in varchar2 default hr_api.g_varchar2
925: ,p_mea_information3 in varchar2 default hr_api.g_varchar2
926: ,p_mea_information4 in varchar2 default hr_api.g_varchar2
927: ,p_mea_information5 in varchar2 default hr_api.g_varchar2
928: ,p_mea_information6 in varchar2 default hr_api.g_varchar2
929: ,p_mea_information7 in varchar2 default hr_api.g_varchar2
922: ,p_mea_information_category in varchar2 default hr_api.g_varchar2
923: ,p_mea_information1 in varchar2 default hr_api.g_varchar2
924: ,p_mea_information2 in varchar2 default hr_api.g_varchar2
925: ,p_mea_information3 in varchar2 default hr_api.g_varchar2
926: ,p_mea_information4 in varchar2 default hr_api.g_varchar2
927: ,p_mea_information5 in varchar2 default hr_api.g_varchar2
928: ,p_mea_information6 in varchar2 default hr_api.g_varchar2
929: ,p_mea_information7 in varchar2 default hr_api.g_varchar2
930: ,p_mea_information8 in varchar2 default hr_api.g_varchar2
923: ,p_mea_information1 in varchar2 default hr_api.g_varchar2
924: ,p_mea_information2 in varchar2 default hr_api.g_varchar2
925: ,p_mea_information3 in varchar2 default hr_api.g_varchar2
926: ,p_mea_information4 in varchar2 default hr_api.g_varchar2
927: ,p_mea_information5 in varchar2 default hr_api.g_varchar2
928: ,p_mea_information6 in varchar2 default hr_api.g_varchar2
929: ,p_mea_information7 in varchar2 default hr_api.g_varchar2
930: ,p_mea_information8 in varchar2 default hr_api.g_varchar2
931: ,p_mea_information9 in varchar2 default hr_api.g_varchar2
924: ,p_mea_information2 in varchar2 default hr_api.g_varchar2
925: ,p_mea_information3 in varchar2 default hr_api.g_varchar2
926: ,p_mea_information4 in varchar2 default hr_api.g_varchar2
927: ,p_mea_information5 in varchar2 default hr_api.g_varchar2
928: ,p_mea_information6 in varchar2 default hr_api.g_varchar2
929: ,p_mea_information7 in varchar2 default hr_api.g_varchar2
930: ,p_mea_information8 in varchar2 default hr_api.g_varchar2
931: ,p_mea_information9 in varchar2 default hr_api.g_varchar2
932: ,p_mea_information10 in varchar2 default hr_api.g_varchar2
925: ,p_mea_information3 in varchar2 default hr_api.g_varchar2
926: ,p_mea_information4 in varchar2 default hr_api.g_varchar2
927: ,p_mea_information5 in varchar2 default hr_api.g_varchar2
928: ,p_mea_information6 in varchar2 default hr_api.g_varchar2
929: ,p_mea_information7 in varchar2 default hr_api.g_varchar2
930: ,p_mea_information8 in varchar2 default hr_api.g_varchar2
931: ,p_mea_information9 in varchar2 default hr_api.g_varchar2
932: ,p_mea_information10 in varchar2 default hr_api.g_varchar2
933: ,p_mea_information11 in varchar2 default hr_api.g_varchar2
926: ,p_mea_information4 in varchar2 default hr_api.g_varchar2
927: ,p_mea_information5 in varchar2 default hr_api.g_varchar2
928: ,p_mea_information6 in varchar2 default hr_api.g_varchar2
929: ,p_mea_information7 in varchar2 default hr_api.g_varchar2
930: ,p_mea_information8 in varchar2 default hr_api.g_varchar2
931: ,p_mea_information9 in varchar2 default hr_api.g_varchar2
932: ,p_mea_information10 in varchar2 default hr_api.g_varchar2
933: ,p_mea_information11 in varchar2 default hr_api.g_varchar2
934: ,p_mea_information12 in varchar2 default hr_api.g_varchar2
927: ,p_mea_information5 in varchar2 default hr_api.g_varchar2
928: ,p_mea_information6 in varchar2 default hr_api.g_varchar2
929: ,p_mea_information7 in varchar2 default hr_api.g_varchar2
930: ,p_mea_information8 in varchar2 default hr_api.g_varchar2
931: ,p_mea_information9 in varchar2 default hr_api.g_varchar2
932: ,p_mea_information10 in varchar2 default hr_api.g_varchar2
933: ,p_mea_information11 in varchar2 default hr_api.g_varchar2
934: ,p_mea_information12 in varchar2 default hr_api.g_varchar2
935: ,p_mea_information13 in varchar2 default hr_api.g_varchar2
928: ,p_mea_information6 in varchar2 default hr_api.g_varchar2
929: ,p_mea_information7 in varchar2 default hr_api.g_varchar2
930: ,p_mea_information8 in varchar2 default hr_api.g_varchar2
931: ,p_mea_information9 in varchar2 default hr_api.g_varchar2
932: ,p_mea_information10 in varchar2 default hr_api.g_varchar2
933: ,p_mea_information11 in varchar2 default hr_api.g_varchar2
934: ,p_mea_information12 in varchar2 default hr_api.g_varchar2
935: ,p_mea_information13 in varchar2 default hr_api.g_varchar2
936: ,p_mea_information14 in varchar2 default hr_api.g_varchar2
929: ,p_mea_information7 in varchar2 default hr_api.g_varchar2
930: ,p_mea_information8 in varchar2 default hr_api.g_varchar2
931: ,p_mea_information9 in varchar2 default hr_api.g_varchar2
932: ,p_mea_information10 in varchar2 default hr_api.g_varchar2
933: ,p_mea_information11 in varchar2 default hr_api.g_varchar2
934: ,p_mea_information12 in varchar2 default hr_api.g_varchar2
935: ,p_mea_information13 in varchar2 default hr_api.g_varchar2
936: ,p_mea_information14 in varchar2 default hr_api.g_varchar2
937: ,p_mea_information15 in varchar2 default hr_api.g_varchar2
930: ,p_mea_information8 in varchar2 default hr_api.g_varchar2
931: ,p_mea_information9 in varchar2 default hr_api.g_varchar2
932: ,p_mea_information10 in varchar2 default hr_api.g_varchar2
933: ,p_mea_information11 in varchar2 default hr_api.g_varchar2
934: ,p_mea_information12 in varchar2 default hr_api.g_varchar2
935: ,p_mea_information13 in varchar2 default hr_api.g_varchar2
936: ,p_mea_information14 in varchar2 default hr_api.g_varchar2
937: ,p_mea_information15 in varchar2 default hr_api.g_varchar2
938: ,p_mea_information16 in varchar2 default hr_api.g_varchar2
931: ,p_mea_information9 in varchar2 default hr_api.g_varchar2
932: ,p_mea_information10 in varchar2 default hr_api.g_varchar2
933: ,p_mea_information11 in varchar2 default hr_api.g_varchar2
934: ,p_mea_information12 in varchar2 default hr_api.g_varchar2
935: ,p_mea_information13 in varchar2 default hr_api.g_varchar2
936: ,p_mea_information14 in varchar2 default hr_api.g_varchar2
937: ,p_mea_information15 in varchar2 default hr_api.g_varchar2
938: ,p_mea_information16 in varchar2 default hr_api.g_varchar2
939: ,p_mea_information17 in varchar2 default hr_api.g_varchar2
932: ,p_mea_information10 in varchar2 default hr_api.g_varchar2
933: ,p_mea_information11 in varchar2 default hr_api.g_varchar2
934: ,p_mea_information12 in varchar2 default hr_api.g_varchar2
935: ,p_mea_information13 in varchar2 default hr_api.g_varchar2
936: ,p_mea_information14 in varchar2 default hr_api.g_varchar2
937: ,p_mea_information15 in varchar2 default hr_api.g_varchar2
938: ,p_mea_information16 in varchar2 default hr_api.g_varchar2
939: ,p_mea_information17 in varchar2 default hr_api.g_varchar2
940: ,p_mea_information18 in varchar2 default hr_api.g_varchar2
933: ,p_mea_information11 in varchar2 default hr_api.g_varchar2
934: ,p_mea_information12 in varchar2 default hr_api.g_varchar2
935: ,p_mea_information13 in varchar2 default hr_api.g_varchar2
936: ,p_mea_information14 in varchar2 default hr_api.g_varchar2
937: ,p_mea_information15 in varchar2 default hr_api.g_varchar2
938: ,p_mea_information16 in varchar2 default hr_api.g_varchar2
939: ,p_mea_information17 in varchar2 default hr_api.g_varchar2
940: ,p_mea_information18 in varchar2 default hr_api.g_varchar2
941: ,p_mea_information19 in varchar2 default hr_api.g_varchar2
934: ,p_mea_information12 in varchar2 default hr_api.g_varchar2
935: ,p_mea_information13 in varchar2 default hr_api.g_varchar2
936: ,p_mea_information14 in varchar2 default hr_api.g_varchar2
937: ,p_mea_information15 in varchar2 default hr_api.g_varchar2
938: ,p_mea_information16 in varchar2 default hr_api.g_varchar2
939: ,p_mea_information17 in varchar2 default hr_api.g_varchar2
940: ,p_mea_information18 in varchar2 default hr_api.g_varchar2
941: ,p_mea_information19 in varchar2 default hr_api.g_varchar2
942: ,p_mea_information20 in varchar2 default hr_api.g_varchar2
935: ,p_mea_information13 in varchar2 default hr_api.g_varchar2
936: ,p_mea_information14 in varchar2 default hr_api.g_varchar2
937: ,p_mea_information15 in varchar2 default hr_api.g_varchar2
938: ,p_mea_information16 in varchar2 default hr_api.g_varchar2
939: ,p_mea_information17 in varchar2 default hr_api.g_varchar2
940: ,p_mea_information18 in varchar2 default hr_api.g_varchar2
941: ,p_mea_information19 in varchar2 default hr_api.g_varchar2
942: ,p_mea_information20 in varchar2 default hr_api.g_varchar2
943: ,p_mea_information21 in varchar2 default hr_api.g_varchar2
936: ,p_mea_information14 in varchar2 default hr_api.g_varchar2
937: ,p_mea_information15 in varchar2 default hr_api.g_varchar2
938: ,p_mea_information16 in varchar2 default hr_api.g_varchar2
939: ,p_mea_information17 in varchar2 default hr_api.g_varchar2
940: ,p_mea_information18 in varchar2 default hr_api.g_varchar2
941: ,p_mea_information19 in varchar2 default hr_api.g_varchar2
942: ,p_mea_information20 in varchar2 default hr_api.g_varchar2
943: ,p_mea_information21 in varchar2 default hr_api.g_varchar2
944: ,p_mea_information22 in varchar2 default hr_api.g_varchar2
937: ,p_mea_information15 in varchar2 default hr_api.g_varchar2
938: ,p_mea_information16 in varchar2 default hr_api.g_varchar2
939: ,p_mea_information17 in varchar2 default hr_api.g_varchar2
940: ,p_mea_information18 in varchar2 default hr_api.g_varchar2
941: ,p_mea_information19 in varchar2 default hr_api.g_varchar2
942: ,p_mea_information20 in varchar2 default hr_api.g_varchar2
943: ,p_mea_information21 in varchar2 default hr_api.g_varchar2
944: ,p_mea_information22 in varchar2 default hr_api.g_varchar2
945: ,p_mea_information23 in varchar2 default hr_api.g_varchar2
938: ,p_mea_information16 in varchar2 default hr_api.g_varchar2
939: ,p_mea_information17 in varchar2 default hr_api.g_varchar2
940: ,p_mea_information18 in varchar2 default hr_api.g_varchar2
941: ,p_mea_information19 in varchar2 default hr_api.g_varchar2
942: ,p_mea_information20 in varchar2 default hr_api.g_varchar2
943: ,p_mea_information21 in varchar2 default hr_api.g_varchar2
944: ,p_mea_information22 in varchar2 default hr_api.g_varchar2
945: ,p_mea_information23 in varchar2 default hr_api.g_varchar2
946: ,p_mea_information24 in varchar2 default hr_api.g_varchar2
939: ,p_mea_information17 in varchar2 default hr_api.g_varchar2
940: ,p_mea_information18 in varchar2 default hr_api.g_varchar2
941: ,p_mea_information19 in varchar2 default hr_api.g_varchar2
942: ,p_mea_information20 in varchar2 default hr_api.g_varchar2
943: ,p_mea_information21 in varchar2 default hr_api.g_varchar2
944: ,p_mea_information22 in varchar2 default hr_api.g_varchar2
945: ,p_mea_information23 in varchar2 default hr_api.g_varchar2
946: ,p_mea_information24 in varchar2 default hr_api.g_varchar2
947: ,p_mea_information25 in varchar2 default hr_api.g_varchar2
940: ,p_mea_information18 in varchar2 default hr_api.g_varchar2
941: ,p_mea_information19 in varchar2 default hr_api.g_varchar2
942: ,p_mea_information20 in varchar2 default hr_api.g_varchar2
943: ,p_mea_information21 in varchar2 default hr_api.g_varchar2
944: ,p_mea_information22 in varchar2 default hr_api.g_varchar2
945: ,p_mea_information23 in varchar2 default hr_api.g_varchar2
946: ,p_mea_information24 in varchar2 default hr_api.g_varchar2
947: ,p_mea_information25 in varchar2 default hr_api.g_varchar2
948: ,p_mea_information26 in varchar2 default hr_api.g_varchar2
941: ,p_mea_information19 in varchar2 default hr_api.g_varchar2
942: ,p_mea_information20 in varchar2 default hr_api.g_varchar2
943: ,p_mea_information21 in varchar2 default hr_api.g_varchar2
944: ,p_mea_information22 in varchar2 default hr_api.g_varchar2
945: ,p_mea_information23 in varchar2 default hr_api.g_varchar2
946: ,p_mea_information24 in varchar2 default hr_api.g_varchar2
947: ,p_mea_information25 in varchar2 default hr_api.g_varchar2
948: ,p_mea_information26 in varchar2 default hr_api.g_varchar2
949: ,p_mea_information27 in varchar2 default hr_api.g_varchar2
942: ,p_mea_information20 in varchar2 default hr_api.g_varchar2
943: ,p_mea_information21 in varchar2 default hr_api.g_varchar2
944: ,p_mea_information22 in varchar2 default hr_api.g_varchar2
945: ,p_mea_information23 in varchar2 default hr_api.g_varchar2
946: ,p_mea_information24 in varchar2 default hr_api.g_varchar2
947: ,p_mea_information25 in varchar2 default hr_api.g_varchar2
948: ,p_mea_information26 in varchar2 default hr_api.g_varchar2
949: ,p_mea_information27 in varchar2 default hr_api.g_varchar2
950: ,p_mea_information28 in varchar2 default hr_api.g_varchar2
943: ,p_mea_information21 in varchar2 default hr_api.g_varchar2
944: ,p_mea_information22 in varchar2 default hr_api.g_varchar2
945: ,p_mea_information23 in varchar2 default hr_api.g_varchar2
946: ,p_mea_information24 in varchar2 default hr_api.g_varchar2
947: ,p_mea_information25 in varchar2 default hr_api.g_varchar2
948: ,p_mea_information26 in varchar2 default hr_api.g_varchar2
949: ,p_mea_information27 in varchar2 default hr_api.g_varchar2
950: ,p_mea_information28 in varchar2 default hr_api.g_varchar2
951: ,p_mea_information29 in varchar2 default hr_api.g_varchar2
944: ,p_mea_information22 in varchar2 default hr_api.g_varchar2
945: ,p_mea_information23 in varchar2 default hr_api.g_varchar2
946: ,p_mea_information24 in varchar2 default hr_api.g_varchar2
947: ,p_mea_information25 in varchar2 default hr_api.g_varchar2
948: ,p_mea_information26 in varchar2 default hr_api.g_varchar2
949: ,p_mea_information27 in varchar2 default hr_api.g_varchar2
950: ,p_mea_information28 in varchar2 default hr_api.g_varchar2
951: ,p_mea_information29 in varchar2 default hr_api.g_varchar2
952: ,p_mea_information30 in varchar2 default hr_api.g_varchar2
945: ,p_mea_information23 in varchar2 default hr_api.g_varchar2
946: ,p_mea_information24 in varchar2 default hr_api.g_varchar2
947: ,p_mea_information25 in varchar2 default hr_api.g_varchar2
948: ,p_mea_information26 in varchar2 default hr_api.g_varchar2
949: ,p_mea_information27 in varchar2 default hr_api.g_varchar2
950: ,p_mea_information28 in varchar2 default hr_api.g_varchar2
951: ,p_mea_information29 in varchar2 default hr_api.g_varchar2
952: ,p_mea_information30 in varchar2 default hr_api.g_varchar2
953: ) is
946: ,p_mea_information24 in varchar2 default hr_api.g_varchar2
947: ,p_mea_information25 in varchar2 default hr_api.g_varchar2
948: ,p_mea_information26 in varchar2 default hr_api.g_varchar2
949: ,p_mea_information27 in varchar2 default hr_api.g_varchar2
950: ,p_mea_information28 in varchar2 default hr_api.g_varchar2
951: ,p_mea_information29 in varchar2 default hr_api.g_varchar2
952: ,p_mea_information30 in varchar2 default hr_api.g_varchar2
953: ) is
954: --
947: ,p_mea_information25 in varchar2 default hr_api.g_varchar2
948: ,p_mea_information26 in varchar2 default hr_api.g_varchar2
949: ,p_mea_information27 in varchar2 default hr_api.g_varchar2
950: ,p_mea_information28 in varchar2 default hr_api.g_varchar2
951: ,p_mea_information29 in varchar2 default hr_api.g_varchar2
952: ,p_mea_information30 in varchar2 default hr_api.g_varchar2
953: ) is
954: --
955: l_rec per_mea_shd.g_rec_type;
948: ,p_mea_information26 in varchar2 default hr_api.g_varchar2
949: ,p_mea_information27 in varchar2 default hr_api.g_varchar2
950: ,p_mea_information28 in varchar2 default hr_api.g_varchar2
951: ,p_mea_information29 in varchar2 default hr_api.g_varchar2
952: ,p_mea_information30 in varchar2 default hr_api.g_varchar2
953: ) is
954: --
955: l_rec per_mea_shd.g_rec_type;
956: l_proc varchar2(72) := g_package||'upd';
963: --
964: l_rec :=
965: per_mea_shd.convert_args
966: (p_medical_assessment_id
967: ,hr_api.g_number
968: ,p_examiner_name
969: ,p_organization_id
970: ,p_consultation_date
971: ,p_consultation_type