135: --
136: hr_utility.set_location(' Leaving:'||l_proc, 10);
137: --
138: Exception
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
142: pay_eei_mig_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
142: pay_eei_mig_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
147: pay_eei_mig_shd.constraint_error
140: -- A check constraint has been violated
141: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
142: pay_eei_mig_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
147: pay_eei_mig_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
147: pay_eei_mig_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
152: pay_eei_mig_shd.constraint_error
145: -- Parent integrity has been violated
146: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
147: pay_eei_mig_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
152: pay_eei_mig_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
152: pay_eei_mig_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: pay_eei_mig_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;
157: End update_dml;
484: );
485: --
486: exception
487: --
488: when hr_api.cannot_find_prog_unit then
489: --
490: hr_api.cannot_find_prog_unit_error
491: (p_module_name => 'PAY_ELEMENT_TYPE_EXTRA_INFO'
492: ,p_hook_type => 'AU');
486: exception
487: --
488: when hr_api.cannot_find_prog_unit then
489: --
490: hr_api.cannot_find_prog_unit_error
491: (p_module_name => 'PAY_ELEMENT_TYPE_EXTRA_INFO'
492: ,p_hook_type => 'AU');
493: --
494: end;
549: -- p_rec plsql record structure
550: -- to see if a system default is being used. If a system default
551: -- is being used then we must set to the 'current' argument value.
552: --
553: If (p_rec.element_type_id = hr_api.g_number) then
554: p_rec.element_type_id :=
555: pay_eei_mig_shd.g_old_rec.element_type_id;
556: End If;
557: If (p_rec.information_type = hr_api.g_varchar2) then
553: If (p_rec.element_type_id = hr_api.g_number) then
554: p_rec.element_type_id :=
555: pay_eei_mig_shd.g_old_rec.element_type_id;
556: End If;
557: If (p_rec.information_type = hr_api.g_varchar2) then
558: p_rec.information_type :=
559: pay_eei_mig_shd.g_old_rec.information_type;
560: End If;
561: If (p_rec.request_id = hr_api.g_number) then
557: If (p_rec.information_type = hr_api.g_varchar2) then
558: p_rec.information_type :=
559: pay_eei_mig_shd.g_old_rec.information_type;
560: End If;
561: If (p_rec.request_id = hr_api.g_number) then
562: p_rec.request_id :=
563: pay_eei_mig_shd.g_old_rec.request_id;
564: End If;
565: If (p_rec.program_application_id = hr_api.g_number) then
561: If (p_rec.request_id = hr_api.g_number) then
562: p_rec.request_id :=
563: pay_eei_mig_shd.g_old_rec.request_id;
564: End If;
565: If (p_rec.program_application_id = hr_api.g_number) then
566: p_rec.program_application_id :=
567: pay_eei_mig_shd.g_old_rec.program_application_id;
568: End If;
569: If (p_rec.program_id = hr_api.g_number) then
565: If (p_rec.program_application_id = hr_api.g_number) then
566: p_rec.program_application_id :=
567: pay_eei_mig_shd.g_old_rec.program_application_id;
568: End If;
569: If (p_rec.program_id = hr_api.g_number) then
570: p_rec.program_id :=
571: pay_eei_mig_shd.g_old_rec.program_id;
572: End If;
573: If (p_rec.program_update_date = hr_api.g_date) then
569: If (p_rec.program_id = hr_api.g_number) then
570: p_rec.program_id :=
571: pay_eei_mig_shd.g_old_rec.program_id;
572: End If;
573: If (p_rec.program_update_date = hr_api.g_date) then
574: p_rec.program_update_date :=
575: pay_eei_mig_shd.g_old_rec.program_update_date;
576: End If;
577: If (p_rec.eei_attribute_category = hr_api.g_varchar2) then
573: If (p_rec.program_update_date = hr_api.g_date) then
574: p_rec.program_update_date :=
575: pay_eei_mig_shd.g_old_rec.program_update_date;
576: End If;
577: If (p_rec.eei_attribute_category = hr_api.g_varchar2) then
578: p_rec.eei_attribute_category :=
579: pay_eei_mig_shd.g_old_rec.eei_attribute_category;
580: End If;
581: If (p_rec.eei_attribute1 = hr_api.g_varchar2) then
577: If (p_rec.eei_attribute_category = hr_api.g_varchar2) then
578: p_rec.eei_attribute_category :=
579: pay_eei_mig_shd.g_old_rec.eei_attribute_category;
580: End If;
581: If (p_rec.eei_attribute1 = hr_api.g_varchar2) then
582: p_rec.eei_attribute1 :=
583: pay_eei_mig_shd.g_old_rec.eei_attribute1;
584: End If;
585: If (p_rec.eei_attribute2 = hr_api.g_varchar2) then
581: If (p_rec.eei_attribute1 = hr_api.g_varchar2) then
582: p_rec.eei_attribute1 :=
583: pay_eei_mig_shd.g_old_rec.eei_attribute1;
584: End If;
585: If (p_rec.eei_attribute2 = hr_api.g_varchar2) then
586: p_rec.eei_attribute2 :=
587: pay_eei_mig_shd.g_old_rec.eei_attribute2;
588: End If;
589: If (p_rec.eei_attribute3 = hr_api.g_varchar2) then
585: If (p_rec.eei_attribute2 = hr_api.g_varchar2) then
586: p_rec.eei_attribute2 :=
587: pay_eei_mig_shd.g_old_rec.eei_attribute2;
588: End If;
589: If (p_rec.eei_attribute3 = hr_api.g_varchar2) then
590: p_rec.eei_attribute3 :=
591: pay_eei_mig_shd.g_old_rec.eei_attribute3;
592: End If;
593: If (p_rec.eei_attribute4 = hr_api.g_varchar2) then
589: If (p_rec.eei_attribute3 = hr_api.g_varchar2) then
590: p_rec.eei_attribute3 :=
591: pay_eei_mig_shd.g_old_rec.eei_attribute3;
592: End If;
593: If (p_rec.eei_attribute4 = hr_api.g_varchar2) then
594: p_rec.eei_attribute4 :=
595: pay_eei_mig_shd.g_old_rec.eei_attribute4;
596: End If;
597: If (p_rec.eei_attribute5 = hr_api.g_varchar2) then
593: If (p_rec.eei_attribute4 = hr_api.g_varchar2) then
594: p_rec.eei_attribute4 :=
595: pay_eei_mig_shd.g_old_rec.eei_attribute4;
596: End If;
597: If (p_rec.eei_attribute5 = hr_api.g_varchar2) then
598: p_rec.eei_attribute5 :=
599: pay_eei_mig_shd.g_old_rec.eei_attribute5;
600: End If;
601: If (p_rec.eei_attribute6 = hr_api.g_varchar2) then
597: If (p_rec.eei_attribute5 = hr_api.g_varchar2) then
598: p_rec.eei_attribute5 :=
599: pay_eei_mig_shd.g_old_rec.eei_attribute5;
600: End If;
601: If (p_rec.eei_attribute6 = hr_api.g_varchar2) then
602: p_rec.eei_attribute6 :=
603: pay_eei_mig_shd.g_old_rec.eei_attribute6;
604: End If;
605: If (p_rec.eei_attribute7 = hr_api.g_varchar2) then
601: If (p_rec.eei_attribute6 = hr_api.g_varchar2) then
602: p_rec.eei_attribute6 :=
603: pay_eei_mig_shd.g_old_rec.eei_attribute6;
604: End If;
605: If (p_rec.eei_attribute7 = hr_api.g_varchar2) then
606: p_rec.eei_attribute7 :=
607: pay_eei_mig_shd.g_old_rec.eei_attribute7;
608: End If;
609: If (p_rec.eei_attribute8 = hr_api.g_varchar2) then
605: If (p_rec.eei_attribute7 = hr_api.g_varchar2) then
606: p_rec.eei_attribute7 :=
607: pay_eei_mig_shd.g_old_rec.eei_attribute7;
608: End If;
609: If (p_rec.eei_attribute8 = hr_api.g_varchar2) then
610: p_rec.eei_attribute8 :=
611: pay_eei_mig_shd.g_old_rec.eei_attribute8;
612: End If;
613: If (p_rec.eei_attribute9 = hr_api.g_varchar2) then
609: If (p_rec.eei_attribute8 = hr_api.g_varchar2) then
610: p_rec.eei_attribute8 :=
611: pay_eei_mig_shd.g_old_rec.eei_attribute8;
612: End If;
613: If (p_rec.eei_attribute9 = hr_api.g_varchar2) then
614: p_rec.eei_attribute9 :=
615: pay_eei_mig_shd.g_old_rec.eei_attribute9;
616: End If;
617: If (p_rec.eei_attribute10 = hr_api.g_varchar2) then
613: If (p_rec.eei_attribute9 = hr_api.g_varchar2) then
614: p_rec.eei_attribute9 :=
615: pay_eei_mig_shd.g_old_rec.eei_attribute9;
616: End If;
617: If (p_rec.eei_attribute10 = hr_api.g_varchar2) then
618: p_rec.eei_attribute10 :=
619: pay_eei_mig_shd.g_old_rec.eei_attribute10;
620: End If;
621: If (p_rec.eei_attribute11 = hr_api.g_varchar2) then
617: If (p_rec.eei_attribute10 = hr_api.g_varchar2) then
618: p_rec.eei_attribute10 :=
619: pay_eei_mig_shd.g_old_rec.eei_attribute10;
620: End If;
621: If (p_rec.eei_attribute11 = hr_api.g_varchar2) then
622: p_rec.eei_attribute11 :=
623: pay_eei_mig_shd.g_old_rec.eei_attribute11;
624: End If;
625: If (p_rec.eei_attribute12 = hr_api.g_varchar2) then
621: If (p_rec.eei_attribute11 = hr_api.g_varchar2) then
622: p_rec.eei_attribute11 :=
623: pay_eei_mig_shd.g_old_rec.eei_attribute11;
624: End If;
625: If (p_rec.eei_attribute12 = hr_api.g_varchar2) then
626: p_rec.eei_attribute12 :=
627: pay_eei_mig_shd.g_old_rec.eei_attribute12;
628: End If;
629: If (p_rec.eei_attribute13 = hr_api.g_varchar2) then
625: If (p_rec.eei_attribute12 = hr_api.g_varchar2) then
626: p_rec.eei_attribute12 :=
627: pay_eei_mig_shd.g_old_rec.eei_attribute12;
628: End If;
629: If (p_rec.eei_attribute13 = hr_api.g_varchar2) then
630: p_rec.eei_attribute13 :=
631: pay_eei_mig_shd.g_old_rec.eei_attribute13;
632: End If;
633: If (p_rec.eei_attribute14 = hr_api.g_varchar2) then
629: If (p_rec.eei_attribute13 = hr_api.g_varchar2) then
630: p_rec.eei_attribute13 :=
631: pay_eei_mig_shd.g_old_rec.eei_attribute13;
632: End If;
633: If (p_rec.eei_attribute14 = hr_api.g_varchar2) then
634: p_rec.eei_attribute14 :=
635: pay_eei_mig_shd.g_old_rec.eei_attribute14;
636: End If;
637: If (p_rec.eei_attribute15 = hr_api.g_varchar2) then
633: If (p_rec.eei_attribute14 = hr_api.g_varchar2) then
634: p_rec.eei_attribute14 :=
635: pay_eei_mig_shd.g_old_rec.eei_attribute14;
636: End If;
637: If (p_rec.eei_attribute15 = hr_api.g_varchar2) then
638: p_rec.eei_attribute15 :=
639: pay_eei_mig_shd.g_old_rec.eei_attribute15;
640: End If;
641: If (p_rec.eei_attribute16 = hr_api.g_varchar2) then
637: If (p_rec.eei_attribute15 = hr_api.g_varchar2) then
638: p_rec.eei_attribute15 :=
639: pay_eei_mig_shd.g_old_rec.eei_attribute15;
640: End If;
641: If (p_rec.eei_attribute16 = hr_api.g_varchar2) then
642: p_rec.eei_attribute16 :=
643: pay_eei_mig_shd.g_old_rec.eei_attribute16;
644: End If;
645: If (p_rec.eei_attribute17 = hr_api.g_varchar2) then
641: If (p_rec.eei_attribute16 = hr_api.g_varchar2) then
642: p_rec.eei_attribute16 :=
643: pay_eei_mig_shd.g_old_rec.eei_attribute16;
644: End If;
645: If (p_rec.eei_attribute17 = hr_api.g_varchar2) then
646: p_rec.eei_attribute17 :=
647: pay_eei_mig_shd.g_old_rec.eei_attribute17;
648: End If;
649: If (p_rec.eei_attribute18 = hr_api.g_varchar2) then
645: If (p_rec.eei_attribute17 = hr_api.g_varchar2) then
646: p_rec.eei_attribute17 :=
647: pay_eei_mig_shd.g_old_rec.eei_attribute17;
648: End If;
649: If (p_rec.eei_attribute18 = hr_api.g_varchar2) then
650: p_rec.eei_attribute18 :=
651: pay_eei_mig_shd.g_old_rec.eei_attribute18;
652: End If;
653: If (p_rec.eei_attribute19 = hr_api.g_varchar2) then
649: If (p_rec.eei_attribute18 = hr_api.g_varchar2) then
650: p_rec.eei_attribute18 :=
651: pay_eei_mig_shd.g_old_rec.eei_attribute18;
652: End If;
653: If (p_rec.eei_attribute19 = hr_api.g_varchar2) then
654: p_rec.eei_attribute19 :=
655: pay_eei_mig_shd.g_old_rec.eei_attribute19;
656: End If;
657: If (p_rec.eei_attribute20 = hr_api.g_varchar2) then
653: If (p_rec.eei_attribute19 = hr_api.g_varchar2) then
654: p_rec.eei_attribute19 :=
655: pay_eei_mig_shd.g_old_rec.eei_attribute19;
656: End If;
657: If (p_rec.eei_attribute20 = hr_api.g_varchar2) then
658: p_rec.eei_attribute20 :=
659: pay_eei_mig_shd.g_old_rec.eei_attribute20;
660: End If;
661: If (p_rec.eei_information_category = hr_api.g_varchar2) then
657: If (p_rec.eei_attribute20 = hr_api.g_varchar2) then
658: p_rec.eei_attribute20 :=
659: pay_eei_mig_shd.g_old_rec.eei_attribute20;
660: End If;
661: If (p_rec.eei_information_category = hr_api.g_varchar2) then
662: p_rec.eei_information_category :=
663: pay_eei_mig_shd.g_old_rec.eei_information_category;
664: End If;
665: If (p_rec.eei_information1 = hr_api.g_varchar2) then
661: If (p_rec.eei_information_category = hr_api.g_varchar2) then
662: p_rec.eei_information_category :=
663: pay_eei_mig_shd.g_old_rec.eei_information_category;
664: End If;
665: If (p_rec.eei_information1 = hr_api.g_varchar2) then
666: p_rec.eei_information1 :=
667: pay_eei_mig_shd.g_old_rec.eei_information1;
668: End If;
669: If (p_rec.eei_information2 = hr_api.g_varchar2) then
665: If (p_rec.eei_information1 = hr_api.g_varchar2) then
666: p_rec.eei_information1 :=
667: pay_eei_mig_shd.g_old_rec.eei_information1;
668: End If;
669: If (p_rec.eei_information2 = hr_api.g_varchar2) then
670: p_rec.eei_information2 :=
671: pay_eei_mig_shd.g_old_rec.eei_information2;
672: End If;
673: If (p_rec.eei_information3 = hr_api.g_varchar2) then
669: If (p_rec.eei_information2 = hr_api.g_varchar2) then
670: p_rec.eei_information2 :=
671: pay_eei_mig_shd.g_old_rec.eei_information2;
672: End If;
673: If (p_rec.eei_information3 = hr_api.g_varchar2) then
674: p_rec.eei_information3 :=
675: pay_eei_mig_shd.g_old_rec.eei_information3;
676: End If;
677: If (p_rec.eei_information4 = hr_api.g_varchar2) then
673: If (p_rec.eei_information3 = hr_api.g_varchar2) then
674: p_rec.eei_information3 :=
675: pay_eei_mig_shd.g_old_rec.eei_information3;
676: End If;
677: If (p_rec.eei_information4 = hr_api.g_varchar2) then
678: p_rec.eei_information4 :=
679: pay_eei_mig_shd.g_old_rec.eei_information4;
680: End If;
681: If (p_rec.eei_information5 = hr_api.g_varchar2) then
677: If (p_rec.eei_information4 = hr_api.g_varchar2) then
678: p_rec.eei_information4 :=
679: pay_eei_mig_shd.g_old_rec.eei_information4;
680: End If;
681: If (p_rec.eei_information5 = hr_api.g_varchar2) then
682: p_rec.eei_information5 :=
683: pay_eei_mig_shd.g_old_rec.eei_information5;
684: End If;
685: If (p_rec.eei_information6 = hr_api.g_varchar2) then
681: If (p_rec.eei_information5 = hr_api.g_varchar2) then
682: p_rec.eei_information5 :=
683: pay_eei_mig_shd.g_old_rec.eei_information5;
684: End If;
685: If (p_rec.eei_information6 = hr_api.g_varchar2) then
686: p_rec.eei_information6 :=
687: pay_eei_mig_shd.g_old_rec.eei_information6;
688: End If;
689: If (p_rec.eei_information7 = hr_api.g_varchar2) then
685: If (p_rec.eei_information6 = hr_api.g_varchar2) then
686: p_rec.eei_information6 :=
687: pay_eei_mig_shd.g_old_rec.eei_information6;
688: End If;
689: If (p_rec.eei_information7 = hr_api.g_varchar2) then
690: p_rec.eei_information7 :=
691: pay_eei_mig_shd.g_old_rec.eei_information7;
692: End If;
693: If (p_rec.eei_information8 = hr_api.g_varchar2) then
689: If (p_rec.eei_information7 = hr_api.g_varchar2) then
690: p_rec.eei_information7 :=
691: pay_eei_mig_shd.g_old_rec.eei_information7;
692: End If;
693: If (p_rec.eei_information8 = hr_api.g_varchar2) then
694: p_rec.eei_information8 :=
695: pay_eei_mig_shd.g_old_rec.eei_information8;
696: End If;
697: If (p_rec.eei_information9 = hr_api.g_varchar2) then
693: If (p_rec.eei_information8 = hr_api.g_varchar2) then
694: p_rec.eei_information8 :=
695: pay_eei_mig_shd.g_old_rec.eei_information8;
696: End If;
697: If (p_rec.eei_information9 = hr_api.g_varchar2) then
698: p_rec.eei_information9 :=
699: pay_eei_mig_shd.g_old_rec.eei_information9;
700: End If;
701: If (p_rec.eei_information10 = hr_api.g_varchar2) then
697: If (p_rec.eei_information9 = hr_api.g_varchar2) then
698: p_rec.eei_information9 :=
699: pay_eei_mig_shd.g_old_rec.eei_information9;
700: End If;
701: If (p_rec.eei_information10 = hr_api.g_varchar2) then
702: p_rec.eei_information10 :=
703: pay_eei_mig_shd.g_old_rec.eei_information10;
704: End If;
705: If (p_rec.eei_information11 = hr_api.g_varchar2) then
701: If (p_rec.eei_information10 = hr_api.g_varchar2) then
702: p_rec.eei_information10 :=
703: pay_eei_mig_shd.g_old_rec.eei_information10;
704: End If;
705: If (p_rec.eei_information11 = hr_api.g_varchar2) then
706: p_rec.eei_information11 :=
707: pay_eei_mig_shd.g_old_rec.eei_information11;
708: End If;
709: If (p_rec.eei_information12 = hr_api.g_varchar2) then
705: If (p_rec.eei_information11 = hr_api.g_varchar2) then
706: p_rec.eei_information11 :=
707: pay_eei_mig_shd.g_old_rec.eei_information11;
708: End If;
709: If (p_rec.eei_information12 = hr_api.g_varchar2) then
710: p_rec.eei_information12 :=
711: pay_eei_mig_shd.g_old_rec.eei_information12;
712: End If;
713: If (p_rec.eei_information13 = hr_api.g_varchar2) then
709: If (p_rec.eei_information12 = hr_api.g_varchar2) then
710: p_rec.eei_information12 :=
711: pay_eei_mig_shd.g_old_rec.eei_information12;
712: End If;
713: If (p_rec.eei_information13 = hr_api.g_varchar2) then
714: p_rec.eei_information13 :=
715: pay_eei_mig_shd.g_old_rec.eei_information13;
716: End If;
717: If (p_rec.eei_information14 = hr_api.g_varchar2) then
713: If (p_rec.eei_information13 = hr_api.g_varchar2) then
714: p_rec.eei_information13 :=
715: pay_eei_mig_shd.g_old_rec.eei_information13;
716: End If;
717: If (p_rec.eei_information14 = hr_api.g_varchar2) then
718: p_rec.eei_information14 :=
719: pay_eei_mig_shd.g_old_rec.eei_information14;
720: End If;
721: If (p_rec.eei_information15 = hr_api.g_varchar2) then
717: If (p_rec.eei_information14 = hr_api.g_varchar2) then
718: p_rec.eei_information14 :=
719: pay_eei_mig_shd.g_old_rec.eei_information14;
720: End If;
721: If (p_rec.eei_information15 = hr_api.g_varchar2) then
722: p_rec.eei_information15 :=
723: pay_eei_mig_shd.g_old_rec.eei_information15;
724: End If;
725: If (p_rec.eei_information16 = hr_api.g_varchar2) then
721: If (p_rec.eei_information15 = hr_api.g_varchar2) then
722: p_rec.eei_information15 :=
723: pay_eei_mig_shd.g_old_rec.eei_information15;
724: End If;
725: If (p_rec.eei_information16 = hr_api.g_varchar2) then
726: p_rec.eei_information16 :=
727: pay_eei_mig_shd.g_old_rec.eei_information16;
728: End If;
729: If (p_rec.eei_information17 = hr_api.g_varchar2) then
725: If (p_rec.eei_information16 = hr_api.g_varchar2) then
726: p_rec.eei_information16 :=
727: pay_eei_mig_shd.g_old_rec.eei_information16;
728: End If;
729: If (p_rec.eei_information17 = hr_api.g_varchar2) then
730: p_rec.eei_information17 :=
731: pay_eei_mig_shd.g_old_rec.eei_information17;
732: End If;
733: If (p_rec.eei_information18 = hr_api.g_varchar2) then
729: If (p_rec.eei_information17 = hr_api.g_varchar2) then
730: p_rec.eei_information17 :=
731: pay_eei_mig_shd.g_old_rec.eei_information17;
732: End If;
733: If (p_rec.eei_information18 = hr_api.g_varchar2) then
734: p_rec.eei_information18 :=
735: pay_eei_mig_shd.g_old_rec.eei_information18;
736: End If;
737: If (p_rec.eei_information19 = hr_api.g_varchar2) then
733: If (p_rec.eei_information18 = hr_api.g_varchar2) then
734: p_rec.eei_information18 :=
735: pay_eei_mig_shd.g_old_rec.eei_information18;
736: End If;
737: If (p_rec.eei_information19 = hr_api.g_varchar2) then
738: p_rec.eei_information19 :=
739: pay_eei_mig_shd.g_old_rec.eei_information19;
740: End If;
741: If (p_rec.eei_information20 = hr_api.g_varchar2) then
737: If (p_rec.eei_information19 = hr_api.g_varchar2) then
738: p_rec.eei_information19 :=
739: pay_eei_mig_shd.g_old_rec.eei_information19;
740: End If;
741: If (p_rec.eei_information20 = hr_api.g_varchar2) then
742: p_rec.eei_information20 :=
743: pay_eei_mig_shd.g_old_rec.eei_information20;
744: End If;
745: If (p_rec.eei_information21 = hr_api.g_varchar2) then
741: If (p_rec.eei_information20 = hr_api.g_varchar2) then
742: p_rec.eei_information20 :=
743: pay_eei_mig_shd.g_old_rec.eei_information20;
744: End If;
745: If (p_rec.eei_information21 = hr_api.g_varchar2) then
746: p_rec.eei_information21 :=
747: pay_eei_mig_shd.g_old_rec.eei_information21;
748: End If;
749: If (p_rec.eei_information22 = hr_api.g_varchar2) then
745: If (p_rec.eei_information21 = hr_api.g_varchar2) then
746: p_rec.eei_information21 :=
747: pay_eei_mig_shd.g_old_rec.eei_information21;
748: End If;
749: If (p_rec.eei_information22 = hr_api.g_varchar2) then
750: p_rec.eei_information22 :=
751: pay_eei_mig_shd.g_old_rec.eei_information22;
752: End If;
753: If (p_rec.eei_information23 = hr_api.g_varchar2) then
749: If (p_rec.eei_information22 = hr_api.g_varchar2) then
750: p_rec.eei_information22 :=
751: pay_eei_mig_shd.g_old_rec.eei_information22;
752: End If;
753: If (p_rec.eei_information23 = hr_api.g_varchar2) then
754: p_rec.eei_information23 :=
755: pay_eei_mig_shd.g_old_rec.eei_information23;
756: End If;
757: If (p_rec.eei_information24 = hr_api.g_varchar2) then
753: If (p_rec.eei_information23 = hr_api.g_varchar2) then
754: p_rec.eei_information23 :=
755: pay_eei_mig_shd.g_old_rec.eei_information23;
756: End If;
757: If (p_rec.eei_information24 = hr_api.g_varchar2) then
758: p_rec.eei_information24 :=
759: pay_eei_mig_shd.g_old_rec.eei_information24;
760: End If;
761: If (p_rec.eei_information25 = hr_api.g_varchar2) then
757: If (p_rec.eei_information24 = hr_api.g_varchar2) then
758: p_rec.eei_information24 :=
759: pay_eei_mig_shd.g_old_rec.eei_information24;
760: End If;
761: If (p_rec.eei_information25 = hr_api.g_varchar2) then
762: p_rec.eei_information25 :=
763: pay_eei_mig_shd.g_old_rec.eei_information25;
764: End If;
765: If (p_rec.eei_information26 = hr_api.g_varchar2) then
761: If (p_rec.eei_information25 = hr_api.g_varchar2) then
762: p_rec.eei_information25 :=
763: pay_eei_mig_shd.g_old_rec.eei_information25;
764: End If;
765: If (p_rec.eei_information26 = hr_api.g_varchar2) then
766: p_rec.eei_information26 :=
767: pay_eei_mig_shd.g_old_rec.eei_information26;
768: End If;
769: If (p_rec.eei_information27 = hr_api.g_varchar2) then
765: If (p_rec.eei_information26 = hr_api.g_varchar2) then
766: p_rec.eei_information26 :=
767: pay_eei_mig_shd.g_old_rec.eei_information26;
768: End If;
769: If (p_rec.eei_information27 = hr_api.g_varchar2) then
770: p_rec.eei_information27 :=
771: pay_eei_mig_shd.g_old_rec.eei_information27;
772: End If;
773: If (p_rec.eei_information28 = hr_api.g_varchar2) then
769: If (p_rec.eei_information27 = hr_api.g_varchar2) then
770: p_rec.eei_information27 :=
771: pay_eei_mig_shd.g_old_rec.eei_information27;
772: End If;
773: If (p_rec.eei_information28 = hr_api.g_varchar2) then
774: p_rec.eei_information28 :=
775: pay_eei_mig_shd.g_old_rec.eei_information28;
776: End If;
777: If (p_rec.eei_information29 = hr_api.g_varchar2) then
773: If (p_rec.eei_information28 = hr_api.g_varchar2) then
774: p_rec.eei_information28 :=
775: pay_eei_mig_shd.g_old_rec.eei_information28;
776: End If;
777: If (p_rec.eei_information29 = hr_api.g_varchar2) then
778: p_rec.eei_information29 :=
779: pay_eei_mig_shd.g_old_rec.eei_information29;
780: End If;
781: If (p_rec.eei_information30 = hr_api.g_varchar2) then
777: If (p_rec.eei_information29 = hr_api.g_varchar2) then
778: p_rec.eei_information29 :=
779: pay_eei_mig_shd.g_old_rec.eei_information29;
780: End If;
781: If (p_rec.eei_information30 = hr_api.g_varchar2) then
782: p_rec.eei_information30 :=
783: pay_eei_mig_shd.g_old_rec.eei_information30;
784: End If;
785: --
835: -- ----------------------------------------------------------------------------
836: Procedure upd
837: (p_element_type_extra_info_id in number
838: ,p_object_version_number in out nocopy number
839: ,p_element_type_id in number default hr_api.g_number
840: ,p_information_type in varchar2 default hr_api.g_varchar2
841: ,p_request_id in number default hr_api.g_number
842: ,p_program_application_id in number default hr_api.g_number
843: ,p_program_id in number default hr_api.g_number
836: Procedure upd
837: (p_element_type_extra_info_id in number
838: ,p_object_version_number in out nocopy number
839: ,p_element_type_id in number default hr_api.g_number
840: ,p_information_type in varchar2 default hr_api.g_varchar2
841: ,p_request_id in number default hr_api.g_number
842: ,p_program_application_id in number default hr_api.g_number
843: ,p_program_id in number default hr_api.g_number
844: ,p_program_update_date in date default hr_api.g_date
837: (p_element_type_extra_info_id in number
838: ,p_object_version_number in out nocopy number
839: ,p_element_type_id in number default hr_api.g_number
840: ,p_information_type in varchar2 default hr_api.g_varchar2
841: ,p_request_id in number default hr_api.g_number
842: ,p_program_application_id in number default hr_api.g_number
843: ,p_program_id in number default hr_api.g_number
844: ,p_program_update_date in date default hr_api.g_date
845: ,p_eei_attribute_category in varchar2 default hr_api.g_varchar2
838: ,p_object_version_number in out nocopy number
839: ,p_element_type_id in number default hr_api.g_number
840: ,p_information_type in varchar2 default hr_api.g_varchar2
841: ,p_request_id in number default hr_api.g_number
842: ,p_program_application_id in number default hr_api.g_number
843: ,p_program_id in number default hr_api.g_number
844: ,p_program_update_date in date default hr_api.g_date
845: ,p_eei_attribute_category in varchar2 default hr_api.g_varchar2
846: ,p_eei_attribute1 in varchar2 default hr_api.g_varchar2
839: ,p_element_type_id in number default hr_api.g_number
840: ,p_information_type in varchar2 default hr_api.g_varchar2
841: ,p_request_id in number default hr_api.g_number
842: ,p_program_application_id in number default hr_api.g_number
843: ,p_program_id in number default hr_api.g_number
844: ,p_program_update_date in date default hr_api.g_date
845: ,p_eei_attribute_category in varchar2 default hr_api.g_varchar2
846: ,p_eei_attribute1 in varchar2 default hr_api.g_varchar2
847: ,p_eei_attribute2 in varchar2 default hr_api.g_varchar2
840: ,p_information_type in varchar2 default hr_api.g_varchar2
841: ,p_request_id in number default hr_api.g_number
842: ,p_program_application_id in number default hr_api.g_number
843: ,p_program_id in number default hr_api.g_number
844: ,p_program_update_date in date default hr_api.g_date
845: ,p_eei_attribute_category in varchar2 default hr_api.g_varchar2
846: ,p_eei_attribute1 in varchar2 default hr_api.g_varchar2
847: ,p_eei_attribute2 in varchar2 default hr_api.g_varchar2
848: ,p_eei_attribute3 in varchar2 default hr_api.g_varchar2
841: ,p_request_id in number default hr_api.g_number
842: ,p_program_application_id in number default hr_api.g_number
843: ,p_program_id in number default hr_api.g_number
844: ,p_program_update_date in date default hr_api.g_date
845: ,p_eei_attribute_category in varchar2 default hr_api.g_varchar2
846: ,p_eei_attribute1 in varchar2 default hr_api.g_varchar2
847: ,p_eei_attribute2 in varchar2 default hr_api.g_varchar2
848: ,p_eei_attribute3 in varchar2 default hr_api.g_varchar2
849: ,p_eei_attribute4 in varchar2 default hr_api.g_varchar2
842: ,p_program_application_id in number default hr_api.g_number
843: ,p_program_id in number default hr_api.g_number
844: ,p_program_update_date in date default hr_api.g_date
845: ,p_eei_attribute_category in varchar2 default hr_api.g_varchar2
846: ,p_eei_attribute1 in varchar2 default hr_api.g_varchar2
847: ,p_eei_attribute2 in varchar2 default hr_api.g_varchar2
848: ,p_eei_attribute3 in varchar2 default hr_api.g_varchar2
849: ,p_eei_attribute4 in varchar2 default hr_api.g_varchar2
850: ,p_eei_attribute5 in varchar2 default hr_api.g_varchar2
843: ,p_program_id in number default hr_api.g_number
844: ,p_program_update_date in date default hr_api.g_date
845: ,p_eei_attribute_category in varchar2 default hr_api.g_varchar2
846: ,p_eei_attribute1 in varchar2 default hr_api.g_varchar2
847: ,p_eei_attribute2 in varchar2 default hr_api.g_varchar2
848: ,p_eei_attribute3 in varchar2 default hr_api.g_varchar2
849: ,p_eei_attribute4 in varchar2 default hr_api.g_varchar2
850: ,p_eei_attribute5 in varchar2 default hr_api.g_varchar2
851: ,p_eei_attribute6 in varchar2 default hr_api.g_varchar2
844: ,p_program_update_date in date default hr_api.g_date
845: ,p_eei_attribute_category in varchar2 default hr_api.g_varchar2
846: ,p_eei_attribute1 in varchar2 default hr_api.g_varchar2
847: ,p_eei_attribute2 in varchar2 default hr_api.g_varchar2
848: ,p_eei_attribute3 in varchar2 default hr_api.g_varchar2
849: ,p_eei_attribute4 in varchar2 default hr_api.g_varchar2
850: ,p_eei_attribute5 in varchar2 default hr_api.g_varchar2
851: ,p_eei_attribute6 in varchar2 default hr_api.g_varchar2
852: ,p_eei_attribute7 in varchar2 default hr_api.g_varchar2
845: ,p_eei_attribute_category in varchar2 default hr_api.g_varchar2
846: ,p_eei_attribute1 in varchar2 default hr_api.g_varchar2
847: ,p_eei_attribute2 in varchar2 default hr_api.g_varchar2
848: ,p_eei_attribute3 in varchar2 default hr_api.g_varchar2
849: ,p_eei_attribute4 in varchar2 default hr_api.g_varchar2
850: ,p_eei_attribute5 in varchar2 default hr_api.g_varchar2
851: ,p_eei_attribute6 in varchar2 default hr_api.g_varchar2
852: ,p_eei_attribute7 in varchar2 default hr_api.g_varchar2
853: ,p_eei_attribute8 in varchar2 default hr_api.g_varchar2
846: ,p_eei_attribute1 in varchar2 default hr_api.g_varchar2
847: ,p_eei_attribute2 in varchar2 default hr_api.g_varchar2
848: ,p_eei_attribute3 in varchar2 default hr_api.g_varchar2
849: ,p_eei_attribute4 in varchar2 default hr_api.g_varchar2
850: ,p_eei_attribute5 in varchar2 default hr_api.g_varchar2
851: ,p_eei_attribute6 in varchar2 default hr_api.g_varchar2
852: ,p_eei_attribute7 in varchar2 default hr_api.g_varchar2
853: ,p_eei_attribute8 in varchar2 default hr_api.g_varchar2
854: ,p_eei_attribute9 in varchar2 default hr_api.g_varchar2
847: ,p_eei_attribute2 in varchar2 default hr_api.g_varchar2
848: ,p_eei_attribute3 in varchar2 default hr_api.g_varchar2
849: ,p_eei_attribute4 in varchar2 default hr_api.g_varchar2
850: ,p_eei_attribute5 in varchar2 default hr_api.g_varchar2
851: ,p_eei_attribute6 in varchar2 default hr_api.g_varchar2
852: ,p_eei_attribute7 in varchar2 default hr_api.g_varchar2
853: ,p_eei_attribute8 in varchar2 default hr_api.g_varchar2
854: ,p_eei_attribute9 in varchar2 default hr_api.g_varchar2
855: ,p_eei_attribute10 in varchar2 default hr_api.g_varchar2
848: ,p_eei_attribute3 in varchar2 default hr_api.g_varchar2
849: ,p_eei_attribute4 in varchar2 default hr_api.g_varchar2
850: ,p_eei_attribute5 in varchar2 default hr_api.g_varchar2
851: ,p_eei_attribute6 in varchar2 default hr_api.g_varchar2
852: ,p_eei_attribute7 in varchar2 default hr_api.g_varchar2
853: ,p_eei_attribute8 in varchar2 default hr_api.g_varchar2
854: ,p_eei_attribute9 in varchar2 default hr_api.g_varchar2
855: ,p_eei_attribute10 in varchar2 default hr_api.g_varchar2
856: ,p_eei_attribute11 in varchar2 default hr_api.g_varchar2
849: ,p_eei_attribute4 in varchar2 default hr_api.g_varchar2
850: ,p_eei_attribute5 in varchar2 default hr_api.g_varchar2
851: ,p_eei_attribute6 in varchar2 default hr_api.g_varchar2
852: ,p_eei_attribute7 in varchar2 default hr_api.g_varchar2
853: ,p_eei_attribute8 in varchar2 default hr_api.g_varchar2
854: ,p_eei_attribute9 in varchar2 default hr_api.g_varchar2
855: ,p_eei_attribute10 in varchar2 default hr_api.g_varchar2
856: ,p_eei_attribute11 in varchar2 default hr_api.g_varchar2
857: ,p_eei_attribute12 in varchar2 default hr_api.g_varchar2
850: ,p_eei_attribute5 in varchar2 default hr_api.g_varchar2
851: ,p_eei_attribute6 in varchar2 default hr_api.g_varchar2
852: ,p_eei_attribute7 in varchar2 default hr_api.g_varchar2
853: ,p_eei_attribute8 in varchar2 default hr_api.g_varchar2
854: ,p_eei_attribute9 in varchar2 default hr_api.g_varchar2
855: ,p_eei_attribute10 in varchar2 default hr_api.g_varchar2
856: ,p_eei_attribute11 in varchar2 default hr_api.g_varchar2
857: ,p_eei_attribute12 in varchar2 default hr_api.g_varchar2
858: ,p_eei_attribute13 in varchar2 default hr_api.g_varchar2
851: ,p_eei_attribute6 in varchar2 default hr_api.g_varchar2
852: ,p_eei_attribute7 in varchar2 default hr_api.g_varchar2
853: ,p_eei_attribute8 in varchar2 default hr_api.g_varchar2
854: ,p_eei_attribute9 in varchar2 default hr_api.g_varchar2
855: ,p_eei_attribute10 in varchar2 default hr_api.g_varchar2
856: ,p_eei_attribute11 in varchar2 default hr_api.g_varchar2
857: ,p_eei_attribute12 in varchar2 default hr_api.g_varchar2
858: ,p_eei_attribute13 in varchar2 default hr_api.g_varchar2
859: ,p_eei_attribute14 in varchar2 default hr_api.g_varchar2
852: ,p_eei_attribute7 in varchar2 default hr_api.g_varchar2
853: ,p_eei_attribute8 in varchar2 default hr_api.g_varchar2
854: ,p_eei_attribute9 in varchar2 default hr_api.g_varchar2
855: ,p_eei_attribute10 in varchar2 default hr_api.g_varchar2
856: ,p_eei_attribute11 in varchar2 default hr_api.g_varchar2
857: ,p_eei_attribute12 in varchar2 default hr_api.g_varchar2
858: ,p_eei_attribute13 in varchar2 default hr_api.g_varchar2
859: ,p_eei_attribute14 in varchar2 default hr_api.g_varchar2
860: ,p_eei_attribute15 in varchar2 default hr_api.g_varchar2
853: ,p_eei_attribute8 in varchar2 default hr_api.g_varchar2
854: ,p_eei_attribute9 in varchar2 default hr_api.g_varchar2
855: ,p_eei_attribute10 in varchar2 default hr_api.g_varchar2
856: ,p_eei_attribute11 in varchar2 default hr_api.g_varchar2
857: ,p_eei_attribute12 in varchar2 default hr_api.g_varchar2
858: ,p_eei_attribute13 in varchar2 default hr_api.g_varchar2
859: ,p_eei_attribute14 in varchar2 default hr_api.g_varchar2
860: ,p_eei_attribute15 in varchar2 default hr_api.g_varchar2
861: ,p_eei_attribute16 in varchar2 default hr_api.g_varchar2
854: ,p_eei_attribute9 in varchar2 default hr_api.g_varchar2
855: ,p_eei_attribute10 in varchar2 default hr_api.g_varchar2
856: ,p_eei_attribute11 in varchar2 default hr_api.g_varchar2
857: ,p_eei_attribute12 in varchar2 default hr_api.g_varchar2
858: ,p_eei_attribute13 in varchar2 default hr_api.g_varchar2
859: ,p_eei_attribute14 in varchar2 default hr_api.g_varchar2
860: ,p_eei_attribute15 in varchar2 default hr_api.g_varchar2
861: ,p_eei_attribute16 in varchar2 default hr_api.g_varchar2
862: ,p_eei_attribute17 in varchar2 default hr_api.g_varchar2
855: ,p_eei_attribute10 in varchar2 default hr_api.g_varchar2
856: ,p_eei_attribute11 in varchar2 default hr_api.g_varchar2
857: ,p_eei_attribute12 in varchar2 default hr_api.g_varchar2
858: ,p_eei_attribute13 in varchar2 default hr_api.g_varchar2
859: ,p_eei_attribute14 in varchar2 default hr_api.g_varchar2
860: ,p_eei_attribute15 in varchar2 default hr_api.g_varchar2
861: ,p_eei_attribute16 in varchar2 default hr_api.g_varchar2
862: ,p_eei_attribute17 in varchar2 default hr_api.g_varchar2
863: ,p_eei_attribute18 in varchar2 default hr_api.g_varchar2
856: ,p_eei_attribute11 in varchar2 default hr_api.g_varchar2
857: ,p_eei_attribute12 in varchar2 default hr_api.g_varchar2
858: ,p_eei_attribute13 in varchar2 default hr_api.g_varchar2
859: ,p_eei_attribute14 in varchar2 default hr_api.g_varchar2
860: ,p_eei_attribute15 in varchar2 default hr_api.g_varchar2
861: ,p_eei_attribute16 in varchar2 default hr_api.g_varchar2
862: ,p_eei_attribute17 in varchar2 default hr_api.g_varchar2
863: ,p_eei_attribute18 in varchar2 default hr_api.g_varchar2
864: ,p_eei_attribute19 in varchar2 default hr_api.g_varchar2
857: ,p_eei_attribute12 in varchar2 default hr_api.g_varchar2
858: ,p_eei_attribute13 in varchar2 default hr_api.g_varchar2
859: ,p_eei_attribute14 in varchar2 default hr_api.g_varchar2
860: ,p_eei_attribute15 in varchar2 default hr_api.g_varchar2
861: ,p_eei_attribute16 in varchar2 default hr_api.g_varchar2
862: ,p_eei_attribute17 in varchar2 default hr_api.g_varchar2
863: ,p_eei_attribute18 in varchar2 default hr_api.g_varchar2
864: ,p_eei_attribute19 in varchar2 default hr_api.g_varchar2
865: ,p_eei_attribute20 in varchar2 default hr_api.g_varchar2
858: ,p_eei_attribute13 in varchar2 default hr_api.g_varchar2
859: ,p_eei_attribute14 in varchar2 default hr_api.g_varchar2
860: ,p_eei_attribute15 in varchar2 default hr_api.g_varchar2
861: ,p_eei_attribute16 in varchar2 default hr_api.g_varchar2
862: ,p_eei_attribute17 in varchar2 default hr_api.g_varchar2
863: ,p_eei_attribute18 in varchar2 default hr_api.g_varchar2
864: ,p_eei_attribute19 in varchar2 default hr_api.g_varchar2
865: ,p_eei_attribute20 in varchar2 default hr_api.g_varchar2
866: ,p_eei_information_category in varchar2 default hr_api.g_varchar2
859: ,p_eei_attribute14 in varchar2 default hr_api.g_varchar2
860: ,p_eei_attribute15 in varchar2 default hr_api.g_varchar2
861: ,p_eei_attribute16 in varchar2 default hr_api.g_varchar2
862: ,p_eei_attribute17 in varchar2 default hr_api.g_varchar2
863: ,p_eei_attribute18 in varchar2 default hr_api.g_varchar2
864: ,p_eei_attribute19 in varchar2 default hr_api.g_varchar2
865: ,p_eei_attribute20 in varchar2 default hr_api.g_varchar2
866: ,p_eei_information_category in varchar2 default hr_api.g_varchar2
867: ,p_eei_information1 in varchar2 default hr_api.g_varchar2
860: ,p_eei_attribute15 in varchar2 default hr_api.g_varchar2
861: ,p_eei_attribute16 in varchar2 default hr_api.g_varchar2
862: ,p_eei_attribute17 in varchar2 default hr_api.g_varchar2
863: ,p_eei_attribute18 in varchar2 default hr_api.g_varchar2
864: ,p_eei_attribute19 in varchar2 default hr_api.g_varchar2
865: ,p_eei_attribute20 in varchar2 default hr_api.g_varchar2
866: ,p_eei_information_category in varchar2 default hr_api.g_varchar2
867: ,p_eei_information1 in varchar2 default hr_api.g_varchar2
868: ,p_eei_information2 in varchar2 default hr_api.g_varchar2
861: ,p_eei_attribute16 in varchar2 default hr_api.g_varchar2
862: ,p_eei_attribute17 in varchar2 default hr_api.g_varchar2
863: ,p_eei_attribute18 in varchar2 default hr_api.g_varchar2
864: ,p_eei_attribute19 in varchar2 default hr_api.g_varchar2
865: ,p_eei_attribute20 in varchar2 default hr_api.g_varchar2
866: ,p_eei_information_category in varchar2 default hr_api.g_varchar2
867: ,p_eei_information1 in varchar2 default hr_api.g_varchar2
868: ,p_eei_information2 in varchar2 default hr_api.g_varchar2
869: ,p_eei_information3 in varchar2 default hr_api.g_varchar2
862: ,p_eei_attribute17 in varchar2 default hr_api.g_varchar2
863: ,p_eei_attribute18 in varchar2 default hr_api.g_varchar2
864: ,p_eei_attribute19 in varchar2 default hr_api.g_varchar2
865: ,p_eei_attribute20 in varchar2 default hr_api.g_varchar2
866: ,p_eei_information_category in varchar2 default hr_api.g_varchar2
867: ,p_eei_information1 in varchar2 default hr_api.g_varchar2
868: ,p_eei_information2 in varchar2 default hr_api.g_varchar2
869: ,p_eei_information3 in varchar2 default hr_api.g_varchar2
870: ,p_eei_information4 in varchar2 default hr_api.g_varchar2
863: ,p_eei_attribute18 in varchar2 default hr_api.g_varchar2
864: ,p_eei_attribute19 in varchar2 default hr_api.g_varchar2
865: ,p_eei_attribute20 in varchar2 default hr_api.g_varchar2
866: ,p_eei_information_category in varchar2 default hr_api.g_varchar2
867: ,p_eei_information1 in varchar2 default hr_api.g_varchar2
868: ,p_eei_information2 in varchar2 default hr_api.g_varchar2
869: ,p_eei_information3 in varchar2 default hr_api.g_varchar2
870: ,p_eei_information4 in varchar2 default hr_api.g_varchar2
871: ,p_eei_information5 in varchar2 default hr_api.g_varchar2
864: ,p_eei_attribute19 in varchar2 default hr_api.g_varchar2
865: ,p_eei_attribute20 in varchar2 default hr_api.g_varchar2
866: ,p_eei_information_category in varchar2 default hr_api.g_varchar2
867: ,p_eei_information1 in varchar2 default hr_api.g_varchar2
868: ,p_eei_information2 in varchar2 default hr_api.g_varchar2
869: ,p_eei_information3 in varchar2 default hr_api.g_varchar2
870: ,p_eei_information4 in varchar2 default hr_api.g_varchar2
871: ,p_eei_information5 in varchar2 default hr_api.g_varchar2
872: ,p_eei_information6 in varchar2 default hr_api.g_varchar2
865: ,p_eei_attribute20 in varchar2 default hr_api.g_varchar2
866: ,p_eei_information_category in varchar2 default hr_api.g_varchar2
867: ,p_eei_information1 in varchar2 default hr_api.g_varchar2
868: ,p_eei_information2 in varchar2 default hr_api.g_varchar2
869: ,p_eei_information3 in varchar2 default hr_api.g_varchar2
870: ,p_eei_information4 in varchar2 default hr_api.g_varchar2
871: ,p_eei_information5 in varchar2 default hr_api.g_varchar2
872: ,p_eei_information6 in varchar2 default hr_api.g_varchar2
873: ,p_eei_information7 in varchar2 default hr_api.g_varchar2
866: ,p_eei_information_category in varchar2 default hr_api.g_varchar2
867: ,p_eei_information1 in varchar2 default hr_api.g_varchar2
868: ,p_eei_information2 in varchar2 default hr_api.g_varchar2
869: ,p_eei_information3 in varchar2 default hr_api.g_varchar2
870: ,p_eei_information4 in varchar2 default hr_api.g_varchar2
871: ,p_eei_information5 in varchar2 default hr_api.g_varchar2
872: ,p_eei_information6 in varchar2 default hr_api.g_varchar2
873: ,p_eei_information7 in varchar2 default hr_api.g_varchar2
874: ,p_eei_information8 in varchar2 default hr_api.g_varchar2
867: ,p_eei_information1 in varchar2 default hr_api.g_varchar2
868: ,p_eei_information2 in varchar2 default hr_api.g_varchar2
869: ,p_eei_information3 in varchar2 default hr_api.g_varchar2
870: ,p_eei_information4 in varchar2 default hr_api.g_varchar2
871: ,p_eei_information5 in varchar2 default hr_api.g_varchar2
872: ,p_eei_information6 in varchar2 default hr_api.g_varchar2
873: ,p_eei_information7 in varchar2 default hr_api.g_varchar2
874: ,p_eei_information8 in varchar2 default hr_api.g_varchar2
875: ,p_eei_information9 in varchar2 default hr_api.g_varchar2
868: ,p_eei_information2 in varchar2 default hr_api.g_varchar2
869: ,p_eei_information3 in varchar2 default hr_api.g_varchar2
870: ,p_eei_information4 in varchar2 default hr_api.g_varchar2
871: ,p_eei_information5 in varchar2 default hr_api.g_varchar2
872: ,p_eei_information6 in varchar2 default hr_api.g_varchar2
873: ,p_eei_information7 in varchar2 default hr_api.g_varchar2
874: ,p_eei_information8 in varchar2 default hr_api.g_varchar2
875: ,p_eei_information9 in varchar2 default hr_api.g_varchar2
876: ,p_eei_information10 in varchar2 default hr_api.g_varchar2
869: ,p_eei_information3 in varchar2 default hr_api.g_varchar2
870: ,p_eei_information4 in varchar2 default hr_api.g_varchar2
871: ,p_eei_information5 in varchar2 default hr_api.g_varchar2
872: ,p_eei_information6 in varchar2 default hr_api.g_varchar2
873: ,p_eei_information7 in varchar2 default hr_api.g_varchar2
874: ,p_eei_information8 in varchar2 default hr_api.g_varchar2
875: ,p_eei_information9 in varchar2 default hr_api.g_varchar2
876: ,p_eei_information10 in varchar2 default hr_api.g_varchar2
877: ,p_eei_information11 in varchar2 default hr_api.g_varchar2
870: ,p_eei_information4 in varchar2 default hr_api.g_varchar2
871: ,p_eei_information5 in varchar2 default hr_api.g_varchar2
872: ,p_eei_information6 in varchar2 default hr_api.g_varchar2
873: ,p_eei_information7 in varchar2 default hr_api.g_varchar2
874: ,p_eei_information8 in varchar2 default hr_api.g_varchar2
875: ,p_eei_information9 in varchar2 default hr_api.g_varchar2
876: ,p_eei_information10 in varchar2 default hr_api.g_varchar2
877: ,p_eei_information11 in varchar2 default hr_api.g_varchar2
878: ,p_eei_information12 in varchar2 default hr_api.g_varchar2
871: ,p_eei_information5 in varchar2 default hr_api.g_varchar2
872: ,p_eei_information6 in varchar2 default hr_api.g_varchar2
873: ,p_eei_information7 in varchar2 default hr_api.g_varchar2
874: ,p_eei_information8 in varchar2 default hr_api.g_varchar2
875: ,p_eei_information9 in varchar2 default hr_api.g_varchar2
876: ,p_eei_information10 in varchar2 default hr_api.g_varchar2
877: ,p_eei_information11 in varchar2 default hr_api.g_varchar2
878: ,p_eei_information12 in varchar2 default hr_api.g_varchar2
879: ,p_eei_information13 in varchar2 default hr_api.g_varchar2
872: ,p_eei_information6 in varchar2 default hr_api.g_varchar2
873: ,p_eei_information7 in varchar2 default hr_api.g_varchar2
874: ,p_eei_information8 in varchar2 default hr_api.g_varchar2
875: ,p_eei_information9 in varchar2 default hr_api.g_varchar2
876: ,p_eei_information10 in varchar2 default hr_api.g_varchar2
877: ,p_eei_information11 in varchar2 default hr_api.g_varchar2
878: ,p_eei_information12 in varchar2 default hr_api.g_varchar2
879: ,p_eei_information13 in varchar2 default hr_api.g_varchar2
880: ,p_eei_information14 in varchar2 default hr_api.g_varchar2
873: ,p_eei_information7 in varchar2 default hr_api.g_varchar2
874: ,p_eei_information8 in varchar2 default hr_api.g_varchar2
875: ,p_eei_information9 in varchar2 default hr_api.g_varchar2
876: ,p_eei_information10 in varchar2 default hr_api.g_varchar2
877: ,p_eei_information11 in varchar2 default hr_api.g_varchar2
878: ,p_eei_information12 in varchar2 default hr_api.g_varchar2
879: ,p_eei_information13 in varchar2 default hr_api.g_varchar2
880: ,p_eei_information14 in varchar2 default hr_api.g_varchar2
881: ,p_eei_information15 in varchar2 default hr_api.g_varchar2
874: ,p_eei_information8 in varchar2 default hr_api.g_varchar2
875: ,p_eei_information9 in varchar2 default hr_api.g_varchar2
876: ,p_eei_information10 in varchar2 default hr_api.g_varchar2
877: ,p_eei_information11 in varchar2 default hr_api.g_varchar2
878: ,p_eei_information12 in varchar2 default hr_api.g_varchar2
879: ,p_eei_information13 in varchar2 default hr_api.g_varchar2
880: ,p_eei_information14 in varchar2 default hr_api.g_varchar2
881: ,p_eei_information15 in varchar2 default hr_api.g_varchar2
882: ,p_eei_information16 in varchar2 default hr_api.g_varchar2
875: ,p_eei_information9 in varchar2 default hr_api.g_varchar2
876: ,p_eei_information10 in varchar2 default hr_api.g_varchar2
877: ,p_eei_information11 in varchar2 default hr_api.g_varchar2
878: ,p_eei_information12 in varchar2 default hr_api.g_varchar2
879: ,p_eei_information13 in varchar2 default hr_api.g_varchar2
880: ,p_eei_information14 in varchar2 default hr_api.g_varchar2
881: ,p_eei_information15 in varchar2 default hr_api.g_varchar2
882: ,p_eei_information16 in varchar2 default hr_api.g_varchar2
883: ,p_eei_information17 in varchar2 default hr_api.g_varchar2
876: ,p_eei_information10 in varchar2 default hr_api.g_varchar2
877: ,p_eei_information11 in varchar2 default hr_api.g_varchar2
878: ,p_eei_information12 in varchar2 default hr_api.g_varchar2
879: ,p_eei_information13 in varchar2 default hr_api.g_varchar2
880: ,p_eei_information14 in varchar2 default hr_api.g_varchar2
881: ,p_eei_information15 in varchar2 default hr_api.g_varchar2
882: ,p_eei_information16 in varchar2 default hr_api.g_varchar2
883: ,p_eei_information17 in varchar2 default hr_api.g_varchar2
884: ,p_eei_information18 in varchar2 default hr_api.g_varchar2
877: ,p_eei_information11 in varchar2 default hr_api.g_varchar2
878: ,p_eei_information12 in varchar2 default hr_api.g_varchar2
879: ,p_eei_information13 in varchar2 default hr_api.g_varchar2
880: ,p_eei_information14 in varchar2 default hr_api.g_varchar2
881: ,p_eei_information15 in varchar2 default hr_api.g_varchar2
882: ,p_eei_information16 in varchar2 default hr_api.g_varchar2
883: ,p_eei_information17 in varchar2 default hr_api.g_varchar2
884: ,p_eei_information18 in varchar2 default hr_api.g_varchar2
885: ,p_eei_information19 in varchar2 default hr_api.g_varchar2
878: ,p_eei_information12 in varchar2 default hr_api.g_varchar2
879: ,p_eei_information13 in varchar2 default hr_api.g_varchar2
880: ,p_eei_information14 in varchar2 default hr_api.g_varchar2
881: ,p_eei_information15 in varchar2 default hr_api.g_varchar2
882: ,p_eei_information16 in varchar2 default hr_api.g_varchar2
883: ,p_eei_information17 in varchar2 default hr_api.g_varchar2
884: ,p_eei_information18 in varchar2 default hr_api.g_varchar2
885: ,p_eei_information19 in varchar2 default hr_api.g_varchar2
886: ,p_eei_information20 in varchar2 default hr_api.g_varchar2
879: ,p_eei_information13 in varchar2 default hr_api.g_varchar2
880: ,p_eei_information14 in varchar2 default hr_api.g_varchar2
881: ,p_eei_information15 in varchar2 default hr_api.g_varchar2
882: ,p_eei_information16 in varchar2 default hr_api.g_varchar2
883: ,p_eei_information17 in varchar2 default hr_api.g_varchar2
884: ,p_eei_information18 in varchar2 default hr_api.g_varchar2
885: ,p_eei_information19 in varchar2 default hr_api.g_varchar2
886: ,p_eei_information20 in varchar2 default hr_api.g_varchar2
887: ,p_eei_information21 in varchar2 default hr_api.g_varchar2
880: ,p_eei_information14 in varchar2 default hr_api.g_varchar2
881: ,p_eei_information15 in varchar2 default hr_api.g_varchar2
882: ,p_eei_information16 in varchar2 default hr_api.g_varchar2
883: ,p_eei_information17 in varchar2 default hr_api.g_varchar2
884: ,p_eei_information18 in varchar2 default hr_api.g_varchar2
885: ,p_eei_information19 in varchar2 default hr_api.g_varchar2
886: ,p_eei_information20 in varchar2 default hr_api.g_varchar2
887: ,p_eei_information21 in varchar2 default hr_api.g_varchar2
888: ,p_eei_information22 in varchar2 default hr_api.g_varchar2
881: ,p_eei_information15 in varchar2 default hr_api.g_varchar2
882: ,p_eei_information16 in varchar2 default hr_api.g_varchar2
883: ,p_eei_information17 in varchar2 default hr_api.g_varchar2
884: ,p_eei_information18 in varchar2 default hr_api.g_varchar2
885: ,p_eei_information19 in varchar2 default hr_api.g_varchar2
886: ,p_eei_information20 in varchar2 default hr_api.g_varchar2
887: ,p_eei_information21 in varchar2 default hr_api.g_varchar2
888: ,p_eei_information22 in varchar2 default hr_api.g_varchar2
889: ,p_eei_information23 in varchar2 default hr_api.g_varchar2
882: ,p_eei_information16 in varchar2 default hr_api.g_varchar2
883: ,p_eei_information17 in varchar2 default hr_api.g_varchar2
884: ,p_eei_information18 in varchar2 default hr_api.g_varchar2
885: ,p_eei_information19 in varchar2 default hr_api.g_varchar2
886: ,p_eei_information20 in varchar2 default hr_api.g_varchar2
887: ,p_eei_information21 in varchar2 default hr_api.g_varchar2
888: ,p_eei_information22 in varchar2 default hr_api.g_varchar2
889: ,p_eei_information23 in varchar2 default hr_api.g_varchar2
890: ,p_eei_information24 in varchar2 default hr_api.g_varchar2
883: ,p_eei_information17 in varchar2 default hr_api.g_varchar2
884: ,p_eei_information18 in varchar2 default hr_api.g_varchar2
885: ,p_eei_information19 in varchar2 default hr_api.g_varchar2
886: ,p_eei_information20 in varchar2 default hr_api.g_varchar2
887: ,p_eei_information21 in varchar2 default hr_api.g_varchar2
888: ,p_eei_information22 in varchar2 default hr_api.g_varchar2
889: ,p_eei_information23 in varchar2 default hr_api.g_varchar2
890: ,p_eei_information24 in varchar2 default hr_api.g_varchar2
891: ,p_eei_information25 in varchar2 default hr_api.g_varchar2
884: ,p_eei_information18 in varchar2 default hr_api.g_varchar2
885: ,p_eei_information19 in varchar2 default hr_api.g_varchar2
886: ,p_eei_information20 in varchar2 default hr_api.g_varchar2
887: ,p_eei_information21 in varchar2 default hr_api.g_varchar2
888: ,p_eei_information22 in varchar2 default hr_api.g_varchar2
889: ,p_eei_information23 in varchar2 default hr_api.g_varchar2
890: ,p_eei_information24 in varchar2 default hr_api.g_varchar2
891: ,p_eei_information25 in varchar2 default hr_api.g_varchar2
892: ,p_eei_information26 in varchar2 default hr_api.g_varchar2
885: ,p_eei_information19 in varchar2 default hr_api.g_varchar2
886: ,p_eei_information20 in varchar2 default hr_api.g_varchar2
887: ,p_eei_information21 in varchar2 default hr_api.g_varchar2
888: ,p_eei_information22 in varchar2 default hr_api.g_varchar2
889: ,p_eei_information23 in varchar2 default hr_api.g_varchar2
890: ,p_eei_information24 in varchar2 default hr_api.g_varchar2
891: ,p_eei_information25 in varchar2 default hr_api.g_varchar2
892: ,p_eei_information26 in varchar2 default hr_api.g_varchar2
893: ,p_eei_information27 in varchar2 default hr_api.g_varchar2
886: ,p_eei_information20 in varchar2 default hr_api.g_varchar2
887: ,p_eei_information21 in varchar2 default hr_api.g_varchar2
888: ,p_eei_information22 in varchar2 default hr_api.g_varchar2
889: ,p_eei_information23 in varchar2 default hr_api.g_varchar2
890: ,p_eei_information24 in varchar2 default hr_api.g_varchar2
891: ,p_eei_information25 in varchar2 default hr_api.g_varchar2
892: ,p_eei_information26 in varchar2 default hr_api.g_varchar2
893: ,p_eei_information27 in varchar2 default hr_api.g_varchar2
894: ,p_eei_information28 in varchar2 default hr_api.g_varchar2
887: ,p_eei_information21 in varchar2 default hr_api.g_varchar2
888: ,p_eei_information22 in varchar2 default hr_api.g_varchar2
889: ,p_eei_information23 in varchar2 default hr_api.g_varchar2
890: ,p_eei_information24 in varchar2 default hr_api.g_varchar2
891: ,p_eei_information25 in varchar2 default hr_api.g_varchar2
892: ,p_eei_information26 in varchar2 default hr_api.g_varchar2
893: ,p_eei_information27 in varchar2 default hr_api.g_varchar2
894: ,p_eei_information28 in varchar2 default hr_api.g_varchar2
895: ,p_eei_information29 in varchar2 default hr_api.g_varchar2
888: ,p_eei_information22 in varchar2 default hr_api.g_varchar2
889: ,p_eei_information23 in varchar2 default hr_api.g_varchar2
890: ,p_eei_information24 in varchar2 default hr_api.g_varchar2
891: ,p_eei_information25 in varchar2 default hr_api.g_varchar2
892: ,p_eei_information26 in varchar2 default hr_api.g_varchar2
893: ,p_eei_information27 in varchar2 default hr_api.g_varchar2
894: ,p_eei_information28 in varchar2 default hr_api.g_varchar2
895: ,p_eei_information29 in varchar2 default hr_api.g_varchar2
896: ,p_eei_information30 in varchar2 default hr_api.g_varchar2
889: ,p_eei_information23 in varchar2 default hr_api.g_varchar2
890: ,p_eei_information24 in varchar2 default hr_api.g_varchar2
891: ,p_eei_information25 in varchar2 default hr_api.g_varchar2
892: ,p_eei_information26 in varchar2 default hr_api.g_varchar2
893: ,p_eei_information27 in varchar2 default hr_api.g_varchar2
894: ,p_eei_information28 in varchar2 default hr_api.g_varchar2
895: ,p_eei_information29 in varchar2 default hr_api.g_varchar2
896: ,p_eei_information30 in varchar2 default hr_api.g_varchar2
897: ) is
890: ,p_eei_information24 in varchar2 default hr_api.g_varchar2
891: ,p_eei_information25 in varchar2 default hr_api.g_varchar2
892: ,p_eei_information26 in varchar2 default hr_api.g_varchar2
893: ,p_eei_information27 in varchar2 default hr_api.g_varchar2
894: ,p_eei_information28 in varchar2 default hr_api.g_varchar2
895: ,p_eei_information29 in varchar2 default hr_api.g_varchar2
896: ,p_eei_information30 in varchar2 default hr_api.g_varchar2
897: ) is
898: --
891: ,p_eei_information25 in varchar2 default hr_api.g_varchar2
892: ,p_eei_information26 in varchar2 default hr_api.g_varchar2
893: ,p_eei_information27 in varchar2 default hr_api.g_varchar2
894: ,p_eei_information28 in varchar2 default hr_api.g_varchar2
895: ,p_eei_information29 in varchar2 default hr_api.g_varchar2
896: ,p_eei_information30 in varchar2 default hr_api.g_varchar2
897: ) is
898: --
899: l_rec pay_eei_mig_shd.g_rec_type;
892: ,p_eei_information26 in varchar2 default hr_api.g_varchar2
893: ,p_eei_information27 in varchar2 default hr_api.g_varchar2
894: ,p_eei_information28 in varchar2 default hr_api.g_varchar2
895: ,p_eei_information29 in varchar2 default hr_api.g_varchar2
896: ,p_eei_information30 in varchar2 default hr_api.g_varchar2
897: ) is
898: --
899: l_rec pay_eei_mig_shd.g_rec_type;
900: l_proc varchar2(72) := g_package||'upd';