150: --
151: hr_utility.set_location(' Leaving:'||l_proc, 10);
152: --
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: --
157: hr_dei_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: --
157: hr_dei_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: --
162: hr_dei_shd.constraint_error
155: -- A check constraint has been violated
156: --
157: hr_dei_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: --
162: hr_dei_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: --
162: hr_dei_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: --
167: hr_dei_shd.constraint_error
160: -- Parent integrity has been violated
161: --
162: hr_dei_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: --
167: hr_dei_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: --
167: hr_dei_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: --
171: Raise;
172: End update_dml;
585: );
586: --
587: exception
588: --
589: when hr_api.cannot_find_prog_unit then
590: --
591: hr_api.cannot_find_prog_unit_error
592: (p_module_name => 'HR_DOCUMENT_EXTRA_INFO'
593: ,p_hook_type => 'AU');
587: exception
588: --
589: when hr_api.cannot_find_prog_unit then
590: --
591: hr_api.cannot_find_prog_unit_error
592: (p_module_name => 'HR_DOCUMENT_EXTRA_INFO'
593: ,p_hook_type => 'AU');
594: --
595: end;
650: -- p_rec plsql record structure
651: -- to see if a system default is being used. If a system default
652: -- is being used then we must set to the 'current' argument value.
653: --
654: If (p_rec.person_id = hr_api.g_number) then
655: p_rec.person_id :=
656: hr_dei_shd.g_old_rec.person_id;
657: End If;
658: If (p_rec.document_type_id = hr_api.g_number) then
654: If (p_rec.person_id = hr_api.g_number) then
655: p_rec.person_id :=
656: hr_dei_shd.g_old_rec.person_id;
657: End If;
658: If (p_rec.document_type_id = hr_api.g_number) then
659: p_rec.document_type_id :=
660: hr_dei_shd.g_old_rec.document_type_id;
661: End If;
662: If (p_rec.document_number = hr_api.g_varchar2) then
658: If (p_rec.document_type_id = hr_api.g_number) then
659: p_rec.document_type_id :=
660: hr_dei_shd.g_old_rec.document_type_id;
661: End If;
662: If (p_rec.document_number = hr_api.g_varchar2) then
663: p_rec.document_number :=
664: hr_dei_shd.g_old_rec.document_number;
665: End If;
666: If (p_rec.date_from = hr_api.g_date) then
662: If (p_rec.document_number = hr_api.g_varchar2) then
663: p_rec.document_number :=
664: hr_dei_shd.g_old_rec.document_number;
665: End If;
666: If (p_rec.date_from = hr_api.g_date) then
667: p_rec.date_from :=
668: hr_dei_shd.g_old_rec.date_from;
669: End If;
670: If (p_rec.date_to = hr_api.g_date) then
666: If (p_rec.date_from = hr_api.g_date) then
667: p_rec.date_from :=
668: hr_dei_shd.g_old_rec.date_from;
669: End If;
670: If (p_rec.date_to = hr_api.g_date) then
671: p_rec.date_to :=
672: hr_dei_shd.g_old_rec.date_to;
673: End If;
674: If (p_rec.issued_by = hr_api.g_varchar2) then
670: If (p_rec.date_to = hr_api.g_date) then
671: p_rec.date_to :=
672: hr_dei_shd.g_old_rec.date_to;
673: End If;
674: If (p_rec.issued_by = hr_api.g_varchar2) then
675: p_rec.issued_by :=
676: hr_dei_shd.g_old_rec.issued_by;
677: End If;
678: If (p_rec.issued_at = hr_api.g_varchar2) then
674: If (p_rec.issued_by = hr_api.g_varchar2) then
675: p_rec.issued_by :=
676: hr_dei_shd.g_old_rec.issued_by;
677: End If;
678: If (p_rec.issued_at = hr_api.g_varchar2) then
679: p_rec.issued_at :=
680: hr_dei_shd.g_old_rec.issued_at;
681: End If;
682: If (p_rec.issued_date = hr_api.g_date) then
678: If (p_rec.issued_at = hr_api.g_varchar2) then
679: p_rec.issued_at :=
680: hr_dei_shd.g_old_rec.issued_at;
681: End If;
682: If (p_rec.issued_date = hr_api.g_date) then
683: p_rec.issued_date :=
684: hr_dei_shd.g_old_rec.issued_date;
685: End If;
686: If (p_rec.issuing_authority = hr_api.g_varchar2) then
682: If (p_rec.issued_date = hr_api.g_date) then
683: p_rec.issued_date :=
684: hr_dei_shd.g_old_rec.issued_date;
685: End If;
686: If (p_rec.issuing_authority = hr_api.g_varchar2) then
687: p_rec.issuing_authority :=
688: hr_dei_shd.g_old_rec.issuing_authority;
689: End If;
690: If (p_rec.verified_by = hr_api.g_number) then
686: If (p_rec.issuing_authority = hr_api.g_varchar2) then
687: p_rec.issuing_authority :=
688: hr_dei_shd.g_old_rec.issuing_authority;
689: End If;
690: If (p_rec.verified_by = hr_api.g_number) then
691: p_rec.verified_by :=
692: hr_dei_shd.g_old_rec.verified_by;
693: End If;
694: If (p_rec.verified_date = hr_api.g_date) then
690: If (p_rec.verified_by = hr_api.g_number) then
691: p_rec.verified_by :=
692: hr_dei_shd.g_old_rec.verified_by;
693: End If;
694: If (p_rec.verified_date = hr_api.g_date) then
695: p_rec.verified_date :=
696: hr_dei_shd.g_old_rec.verified_date;
697: End If;
698: If (p_rec.related_object_name = hr_api.g_varchar2) then
694: If (p_rec.verified_date = hr_api.g_date) then
695: p_rec.verified_date :=
696: hr_dei_shd.g_old_rec.verified_date;
697: End If;
698: If (p_rec.related_object_name = hr_api.g_varchar2) then
699: p_rec.related_object_name :=
700: hr_dei_shd.g_old_rec.related_object_name;
701: End If;
702: If (p_rec.related_object_id_col = hr_api.g_varchar2) then
698: If (p_rec.related_object_name = hr_api.g_varchar2) then
699: p_rec.related_object_name :=
700: hr_dei_shd.g_old_rec.related_object_name;
701: End If;
702: If (p_rec.related_object_id_col = hr_api.g_varchar2) then
703: p_rec.related_object_id_col :=
704: hr_dei_shd.g_old_rec.related_object_id_col;
705: End If;
706: If (p_rec.related_object_id = hr_api.g_number) then
702: If (p_rec.related_object_id_col = hr_api.g_varchar2) then
703: p_rec.related_object_id_col :=
704: hr_dei_shd.g_old_rec.related_object_id_col;
705: End If;
706: If (p_rec.related_object_id = hr_api.g_number) then
707: p_rec.related_object_id :=
708: hr_dei_shd.g_old_rec.related_object_id;
709: End If;
710: If (p_rec.dei_attribute_category = hr_api.g_varchar2) then
706: If (p_rec.related_object_id = hr_api.g_number) then
707: p_rec.related_object_id :=
708: hr_dei_shd.g_old_rec.related_object_id;
709: End If;
710: If (p_rec.dei_attribute_category = hr_api.g_varchar2) then
711: p_rec.dei_attribute_category :=
712: hr_dei_shd.g_old_rec.dei_attribute_category;
713: End If;
714: If (p_rec.dei_attribute1 = hr_api.g_varchar2) then
710: If (p_rec.dei_attribute_category = hr_api.g_varchar2) then
711: p_rec.dei_attribute_category :=
712: hr_dei_shd.g_old_rec.dei_attribute_category;
713: End If;
714: If (p_rec.dei_attribute1 = hr_api.g_varchar2) then
715: p_rec.dei_attribute1 :=
716: hr_dei_shd.g_old_rec.dei_attribute1;
717: End If;
718: If (p_rec.dei_attribute2 = hr_api.g_varchar2) then
714: If (p_rec.dei_attribute1 = hr_api.g_varchar2) then
715: p_rec.dei_attribute1 :=
716: hr_dei_shd.g_old_rec.dei_attribute1;
717: End If;
718: If (p_rec.dei_attribute2 = hr_api.g_varchar2) then
719: p_rec.dei_attribute2 :=
720: hr_dei_shd.g_old_rec.dei_attribute2;
721: End If;
722: If (p_rec.dei_attribute3 = hr_api.g_varchar2) then
718: If (p_rec.dei_attribute2 = hr_api.g_varchar2) then
719: p_rec.dei_attribute2 :=
720: hr_dei_shd.g_old_rec.dei_attribute2;
721: End If;
722: If (p_rec.dei_attribute3 = hr_api.g_varchar2) then
723: p_rec.dei_attribute3 :=
724: hr_dei_shd.g_old_rec.dei_attribute3;
725: End If;
726: If (p_rec.dei_attribute4 = hr_api.g_varchar2) then
722: If (p_rec.dei_attribute3 = hr_api.g_varchar2) then
723: p_rec.dei_attribute3 :=
724: hr_dei_shd.g_old_rec.dei_attribute3;
725: End If;
726: If (p_rec.dei_attribute4 = hr_api.g_varchar2) then
727: p_rec.dei_attribute4 :=
728: hr_dei_shd.g_old_rec.dei_attribute4;
729: End If;
730: If (p_rec.dei_attribute5 = hr_api.g_varchar2) then
726: If (p_rec.dei_attribute4 = hr_api.g_varchar2) then
727: p_rec.dei_attribute4 :=
728: hr_dei_shd.g_old_rec.dei_attribute4;
729: End If;
730: If (p_rec.dei_attribute5 = hr_api.g_varchar2) then
731: p_rec.dei_attribute5 :=
732: hr_dei_shd.g_old_rec.dei_attribute5;
733: End If;
734: If (p_rec.dei_attribute6 = hr_api.g_varchar2) then
730: If (p_rec.dei_attribute5 = hr_api.g_varchar2) then
731: p_rec.dei_attribute5 :=
732: hr_dei_shd.g_old_rec.dei_attribute5;
733: End If;
734: If (p_rec.dei_attribute6 = hr_api.g_varchar2) then
735: p_rec.dei_attribute6 :=
736: hr_dei_shd.g_old_rec.dei_attribute6;
737: End If;
738: If (p_rec.dei_attribute7 = hr_api.g_varchar2) then
734: If (p_rec.dei_attribute6 = hr_api.g_varchar2) then
735: p_rec.dei_attribute6 :=
736: hr_dei_shd.g_old_rec.dei_attribute6;
737: End If;
738: If (p_rec.dei_attribute7 = hr_api.g_varchar2) then
739: p_rec.dei_attribute7 :=
740: hr_dei_shd.g_old_rec.dei_attribute7;
741: End If;
742: If (p_rec.dei_attribute8 = hr_api.g_varchar2) then
738: If (p_rec.dei_attribute7 = hr_api.g_varchar2) then
739: p_rec.dei_attribute7 :=
740: hr_dei_shd.g_old_rec.dei_attribute7;
741: End If;
742: If (p_rec.dei_attribute8 = hr_api.g_varchar2) then
743: p_rec.dei_attribute8 :=
744: hr_dei_shd.g_old_rec.dei_attribute8;
745: End If;
746: If (p_rec.dei_attribute9 = hr_api.g_varchar2) then
742: If (p_rec.dei_attribute8 = hr_api.g_varchar2) then
743: p_rec.dei_attribute8 :=
744: hr_dei_shd.g_old_rec.dei_attribute8;
745: End If;
746: If (p_rec.dei_attribute9 = hr_api.g_varchar2) then
747: p_rec.dei_attribute9 :=
748: hr_dei_shd.g_old_rec.dei_attribute9;
749: End If;
750: If (p_rec.dei_attribute10 = hr_api.g_varchar2) then
746: If (p_rec.dei_attribute9 = hr_api.g_varchar2) then
747: p_rec.dei_attribute9 :=
748: hr_dei_shd.g_old_rec.dei_attribute9;
749: End If;
750: If (p_rec.dei_attribute10 = hr_api.g_varchar2) then
751: p_rec.dei_attribute10 :=
752: hr_dei_shd.g_old_rec.dei_attribute10;
753: End If;
754: If (p_rec.dei_attribute11 = hr_api.g_varchar2) then
750: If (p_rec.dei_attribute10 = hr_api.g_varchar2) then
751: p_rec.dei_attribute10 :=
752: hr_dei_shd.g_old_rec.dei_attribute10;
753: End If;
754: If (p_rec.dei_attribute11 = hr_api.g_varchar2) then
755: p_rec.dei_attribute11 :=
756: hr_dei_shd.g_old_rec.dei_attribute11;
757: End If;
758: If (p_rec.dei_attribute12 = hr_api.g_varchar2) then
754: If (p_rec.dei_attribute11 = hr_api.g_varchar2) then
755: p_rec.dei_attribute11 :=
756: hr_dei_shd.g_old_rec.dei_attribute11;
757: End If;
758: If (p_rec.dei_attribute12 = hr_api.g_varchar2) then
759: p_rec.dei_attribute12 :=
760: hr_dei_shd.g_old_rec.dei_attribute12;
761: End If;
762: If (p_rec.dei_attribute13 = hr_api.g_varchar2) then
758: If (p_rec.dei_attribute12 = hr_api.g_varchar2) then
759: p_rec.dei_attribute12 :=
760: hr_dei_shd.g_old_rec.dei_attribute12;
761: End If;
762: If (p_rec.dei_attribute13 = hr_api.g_varchar2) then
763: p_rec.dei_attribute13 :=
764: hr_dei_shd.g_old_rec.dei_attribute13;
765: End If;
766: If (p_rec.dei_attribute14 = hr_api.g_varchar2) then
762: If (p_rec.dei_attribute13 = hr_api.g_varchar2) then
763: p_rec.dei_attribute13 :=
764: hr_dei_shd.g_old_rec.dei_attribute13;
765: End If;
766: If (p_rec.dei_attribute14 = hr_api.g_varchar2) then
767: p_rec.dei_attribute14 :=
768: hr_dei_shd.g_old_rec.dei_attribute14;
769: End If;
770: If (p_rec.dei_attribute15 = hr_api.g_varchar2) then
766: If (p_rec.dei_attribute14 = hr_api.g_varchar2) then
767: p_rec.dei_attribute14 :=
768: hr_dei_shd.g_old_rec.dei_attribute14;
769: End If;
770: If (p_rec.dei_attribute15 = hr_api.g_varchar2) then
771: p_rec.dei_attribute15 :=
772: hr_dei_shd.g_old_rec.dei_attribute15;
773: End If;
774: If (p_rec.dei_attribute16 = hr_api.g_varchar2) then
770: If (p_rec.dei_attribute15 = hr_api.g_varchar2) then
771: p_rec.dei_attribute15 :=
772: hr_dei_shd.g_old_rec.dei_attribute15;
773: End If;
774: If (p_rec.dei_attribute16 = hr_api.g_varchar2) then
775: p_rec.dei_attribute16 :=
776: hr_dei_shd.g_old_rec.dei_attribute16;
777: End If;
778: If (p_rec.dei_attribute17 = hr_api.g_varchar2) then
774: If (p_rec.dei_attribute16 = hr_api.g_varchar2) then
775: p_rec.dei_attribute16 :=
776: hr_dei_shd.g_old_rec.dei_attribute16;
777: End If;
778: If (p_rec.dei_attribute17 = hr_api.g_varchar2) then
779: p_rec.dei_attribute17 :=
780: hr_dei_shd.g_old_rec.dei_attribute17;
781: End If;
782: If (p_rec.dei_attribute18 = hr_api.g_varchar2) then
778: If (p_rec.dei_attribute17 = hr_api.g_varchar2) then
779: p_rec.dei_attribute17 :=
780: hr_dei_shd.g_old_rec.dei_attribute17;
781: End If;
782: If (p_rec.dei_attribute18 = hr_api.g_varchar2) then
783: p_rec.dei_attribute18 :=
784: hr_dei_shd.g_old_rec.dei_attribute18;
785: End If;
786: If (p_rec.dei_attribute19 = hr_api.g_varchar2) then
782: If (p_rec.dei_attribute18 = hr_api.g_varchar2) then
783: p_rec.dei_attribute18 :=
784: hr_dei_shd.g_old_rec.dei_attribute18;
785: End If;
786: If (p_rec.dei_attribute19 = hr_api.g_varchar2) then
787: p_rec.dei_attribute19 :=
788: hr_dei_shd.g_old_rec.dei_attribute19;
789: End If;
790: If (p_rec.dei_attribute20 = hr_api.g_varchar2) then
786: If (p_rec.dei_attribute19 = hr_api.g_varchar2) then
787: p_rec.dei_attribute19 :=
788: hr_dei_shd.g_old_rec.dei_attribute19;
789: End If;
790: If (p_rec.dei_attribute20 = hr_api.g_varchar2) then
791: p_rec.dei_attribute20 :=
792: hr_dei_shd.g_old_rec.dei_attribute20;
793: End If;
794: If (p_rec.dei_attribute21 = hr_api.g_varchar2) then
790: If (p_rec.dei_attribute20 = hr_api.g_varchar2) then
791: p_rec.dei_attribute20 :=
792: hr_dei_shd.g_old_rec.dei_attribute20;
793: End If;
794: If (p_rec.dei_attribute21 = hr_api.g_varchar2) then
795: p_rec.dei_attribute21 :=
796: hr_dei_shd.g_old_rec.dei_attribute21;
797: End If;
798: If (p_rec.dei_attribute22 = hr_api.g_varchar2) then
794: If (p_rec.dei_attribute21 = hr_api.g_varchar2) then
795: p_rec.dei_attribute21 :=
796: hr_dei_shd.g_old_rec.dei_attribute21;
797: End If;
798: If (p_rec.dei_attribute22 = hr_api.g_varchar2) then
799: p_rec.dei_attribute22 :=
800: hr_dei_shd.g_old_rec.dei_attribute22;
801: End If;
802: If (p_rec.dei_attribute23 = hr_api.g_varchar2) then
798: If (p_rec.dei_attribute22 = hr_api.g_varchar2) then
799: p_rec.dei_attribute22 :=
800: hr_dei_shd.g_old_rec.dei_attribute22;
801: End If;
802: If (p_rec.dei_attribute23 = hr_api.g_varchar2) then
803: p_rec.dei_attribute23 :=
804: hr_dei_shd.g_old_rec.dei_attribute23;
805: End If;
806: If (p_rec.dei_attribute24 = hr_api.g_varchar2) then
802: If (p_rec.dei_attribute23 = hr_api.g_varchar2) then
803: p_rec.dei_attribute23 :=
804: hr_dei_shd.g_old_rec.dei_attribute23;
805: End If;
806: If (p_rec.dei_attribute24 = hr_api.g_varchar2) then
807: p_rec.dei_attribute24 :=
808: hr_dei_shd.g_old_rec.dei_attribute24;
809: End If;
810: If (p_rec.dei_attribute25 = hr_api.g_varchar2) then
806: If (p_rec.dei_attribute24 = hr_api.g_varchar2) then
807: p_rec.dei_attribute24 :=
808: hr_dei_shd.g_old_rec.dei_attribute24;
809: End If;
810: If (p_rec.dei_attribute25 = hr_api.g_varchar2) then
811: p_rec.dei_attribute25 :=
812: hr_dei_shd.g_old_rec.dei_attribute25;
813: End If;
814: If (p_rec.dei_attribute26 = hr_api.g_varchar2) then
810: If (p_rec.dei_attribute25 = hr_api.g_varchar2) then
811: p_rec.dei_attribute25 :=
812: hr_dei_shd.g_old_rec.dei_attribute25;
813: End If;
814: If (p_rec.dei_attribute26 = hr_api.g_varchar2) then
815: p_rec.dei_attribute26 :=
816: hr_dei_shd.g_old_rec.dei_attribute26;
817: End If;
818: If (p_rec.dei_attribute27 = hr_api.g_varchar2) then
814: If (p_rec.dei_attribute26 = hr_api.g_varchar2) then
815: p_rec.dei_attribute26 :=
816: hr_dei_shd.g_old_rec.dei_attribute26;
817: End If;
818: If (p_rec.dei_attribute27 = hr_api.g_varchar2) then
819: p_rec.dei_attribute27 :=
820: hr_dei_shd.g_old_rec.dei_attribute27;
821: End If;
822: If (p_rec.dei_attribute28 = hr_api.g_varchar2) then
818: If (p_rec.dei_attribute27 = hr_api.g_varchar2) then
819: p_rec.dei_attribute27 :=
820: hr_dei_shd.g_old_rec.dei_attribute27;
821: End If;
822: If (p_rec.dei_attribute28 = hr_api.g_varchar2) then
823: p_rec.dei_attribute28 :=
824: hr_dei_shd.g_old_rec.dei_attribute28;
825: End If;
826: If (p_rec.dei_attribute29 = hr_api.g_varchar2) then
822: If (p_rec.dei_attribute28 = hr_api.g_varchar2) then
823: p_rec.dei_attribute28 :=
824: hr_dei_shd.g_old_rec.dei_attribute28;
825: End If;
826: If (p_rec.dei_attribute29 = hr_api.g_varchar2) then
827: p_rec.dei_attribute29 :=
828: hr_dei_shd.g_old_rec.dei_attribute29;
829: End If;
830: If (p_rec.dei_attribute30 = hr_api.g_varchar2) then
826: If (p_rec.dei_attribute29 = hr_api.g_varchar2) then
827: p_rec.dei_attribute29 :=
828: hr_dei_shd.g_old_rec.dei_attribute29;
829: End If;
830: If (p_rec.dei_attribute30 = hr_api.g_varchar2) then
831: p_rec.dei_attribute30 :=
832: hr_dei_shd.g_old_rec.dei_attribute30;
833: End If;
834: If (p_rec.dei_information_category = hr_api.g_varchar2) then
830: If (p_rec.dei_attribute30 = hr_api.g_varchar2) then
831: p_rec.dei_attribute30 :=
832: hr_dei_shd.g_old_rec.dei_attribute30;
833: End If;
834: If (p_rec.dei_information_category = hr_api.g_varchar2) then
835: p_rec.dei_information_category :=
836: hr_dei_shd.g_old_rec.dei_information_category;
837: End If;
838: If (p_rec.dei_information1 = hr_api.g_varchar2) then
834: If (p_rec.dei_information_category = hr_api.g_varchar2) then
835: p_rec.dei_information_category :=
836: hr_dei_shd.g_old_rec.dei_information_category;
837: End If;
838: If (p_rec.dei_information1 = hr_api.g_varchar2) then
839: p_rec.dei_information1 :=
840: hr_dei_shd.g_old_rec.dei_information1;
841: End If;
842: If (p_rec.dei_information2 = hr_api.g_varchar2) then
838: If (p_rec.dei_information1 = hr_api.g_varchar2) then
839: p_rec.dei_information1 :=
840: hr_dei_shd.g_old_rec.dei_information1;
841: End If;
842: If (p_rec.dei_information2 = hr_api.g_varchar2) then
843: p_rec.dei_information2 :=
844: hr_dei_shd.g_old_rec.dei_information2;
845: End If;
846: If (p_rec.dei_information3 = hr_api.g_varchar2) then
842: If (p_rec.dei_information2 = hr_api.g_varchar2) then
843: p_rec.dei_information2 :=
844: hr_dei_shd.g_old_rec.dei_information2;
845: End If;
846: If (p_rec.dei_information3 = hr_api.g_varchar2) then
847: p_rec.dei_information3 :=
848: hr_dei_shd.g_old_rec.dei_information3;
849: End If;
850: If (p_rec.dei_information4 = hr_api.g_varchar2) then
846: If (p_rec.dei_information3 = hr_api.g_varchar2) then
847: p_rec.dei_information3 :=
848: hr_dei_shd.g_old_rec.dei_information3;
849: End If;
850: If (p_rec.dei_information4 = hr_api.g_varchar2) then
851: p_rec.dei_information4 :=
852: hr_dei_shd.g_old_rec.dei_information4;
853: End If;
854: If (p_rec.dei_information5 = hr_api.g_varchar2) then
850: If (p_rec.dei_information4 = hr_api.g_varchar2) then
851: p_rec.dei_information4 :=
852: hr_dei_shd.g_old_rec.dei_information4;
853: End If;
854: If (p_rec.dei_information5 = hr_api.g_varchar2) then
855: p_rec.dei_information5 :=
856: hr_dei_shd.g_old_rec.dei_information5;
857: End If;
858: If (p_rec.dei_information6 = hr_api.g_varchar2) then
854: If (p_rec.dei_information5 = hr_api.g_varchar2) then
855: p_rec.dei_information5 :=
856: hr_dei_shd.g_old_rec.dei_information5;
857: End If;
858: If (p_rec.dei_information6 = hr_api.g_varchar2) then
859: p_rec.dei_information6 :=
860: hr_dei_shd.g_old_rec.dei_information6;
861: End If;
862: If (p_rec.dei_information7 = hr_api.g_varchar2) then
858: If (p_rec.dei_information6 = hr_api.g_varchar2) then
859: p_rec.dei_information6 :=
860: hr_dei_shd.g_old_rec.dei_information6;
861: End If;
862: If (p_rec.dei_information7 = hr_api.g_varchar2) then
863: p_rec.dei_information7 :=
864: hr_dei_shd.g_old_rec.dei_information7;
865: End If;
866: If (p_rec.dei_information8 = hr_api.g_varchar2) then
862: If (p_rec.dei_information7 = hr_api.g_varchar2) then
863: p_rec.dei_information7 :=
864: hr_dei_shd.g_old_rec.dei_information7;
865: End If;
866: If (p_rec.dei_information8 = hr_api.g_varchar2) then
867: p_rec.dei_information8 :=
868: hr_dei_shd.g_old_rec.dei_information8;
869: End If;
870: If (p_rec.dei_information9 = hr_api.g_varchar2) then
866: If (p_rec.dei_information8 = hr_api.g_varchar2) then
867: p_rec.dei_information8 :=
868: hr_dei_shd.g_old_rec.dei_information8;
869: End If;
870: If (p_rec.dei_information9 = hr_api.g_varchar2) then
871: p_rec.dei_information9 :=
872: hr_dei_shd.g_old_rec.dei_information9;
873: End If;
874: If (p_rec.dei_information10 = hr_api.g_varchar2) then
870: If (p_rec.dei_information9 = hr_api.g_varchar2) then
871: p_rec.dei_information9 :=
872: hr_dei_shd.g_old_rec.dei_information9;
873: End If;
874: If (p_rec.dei_information10 = hr_api.g_varchar2) then
875: p_rec.dei_information10 :=
876: hr_dei_shd.g_old_rec.dei_information10;
877: End If;
878: If (p_rec.dei_information11 = hr_api.g_varchar2) then
874: If (p_rec.dei_information10 = hr_api.g_varchar2) then
875: p_rec.dei_information10 :=
876: hr_dei_shd.g_old_rec.dei_information10;
877: End If;
878: If (p_rec.dei_information11 = hr_api.g_varchar2) then
879: p_rec.dei_information11 :=
880: hr_dei_shd.g_old_rec.dei_information11;
881: End If;
882: If (p_rec.dei_information12 = hr_api.g_varchar2) then
878: If (p_rec.dei_information11 = hr_api.g_varchar2) then
879: p_rec.dei_information11 :=
880: hr_dei_shd.g_old_rec.dei_information11;
881: End If;
882: If (p_rec.dei_information12 = hr_api.g_varchar2) then
883: p_rec.dei_information12 :=
884: hr_dei_shd.g_old_rec.dei_information12;
885: End If;
886: If (p_rec.dei_information13 = hr_api.g_varchar2) then
882: If (p_rec.dei_information12 = hr_api.g_varchar2) then
883: p_rec.dei_information12 :=
884: hr_dei_shd.g_old_rec.dei_information12;
885: End If;
886: If (p_rec.dei_information13 = hr_api.g_varchar2) then
887: p_rec.dei_information13 :=
888: hr_dei_shd.g_old_rec.dei_information13;
889: End If;
890: If (p_rec.dei_information14 = hr_api.g_varchar2) then
886: If (p_rec.dei_information13 = hr_api.g_varchar2) then
887: p_rec.dei_information13 :=
888: hr_dei_shd.g_old_rec.dei_information13;
889: End If;
890: If (p_rec.dei_information14 = hr_api.g_varchar2) then
891: p_rec.dei_information14 :=
892: hr_dei_shd.g_old_rec.dei_information14;
893: End If;
894: If (p_rec.dei_information15 = hr_api.g_varchar2) then
890: If (p_rec.dei_information14 = hr_api.g_varchar2) then
891: p_rec.dei_information14 :=
892: hr_dei_shd.g_old_rec.dei_information14;
893: End If;
894: If (p_rec.dei_information15 = hr_api.g_varchar2) then
895: p_rec.dei_information15 :=
896: hr_dei_shd.g_old_rec.dei_information15;
897: End If;
898: If (p_rec.dei_information16 = hr_api.g_varchar2) then
894: If (p_rec.dei_information15 = hr_api.g_varchar2) then
895: p_rec.dei_information15 :=
896: hr_dei_shd.g_old_rec.dei_information15;
897: End If;
898: If (p_rec.dei_information16 = hr_api.g_varchar2) then
899: p_rec.dei_information16 :=
900: hr_dei_shd.g_old_rec.dei_information16;
901: End If;
902: If (p_rec.dei_information17 = hr_api.g_varchar2) then
898: If (p_rec.dei_information16 = hr_api.g_varchar2) then
899: p_rec.dei_information16 :=
900: hr_dei_shd.g_old_rec.dei_information16;
901: End If;
902: If (p_rec.dei_information17 = hr_api.g_varchar2) then
903: p_rec.dei_information17 :=
904: hr_dei_shd.g_old_rec.dei_information17;
905: End If;
906: If (p_rec.dei_information18 = hr_api.g_varchar2) then
902: If (p_rec.dei_information17 = hr_api.g_varchar2) then
903: p_rec.dei_information17 :=
904: hr_dei_shd.g_old_rec.dei_information17;
905: End If;
906: If (p_rec.dei_information18 = hr_api.g_varchar2) then
907: p_rec.dei_information18 :=
908: hr_dei_shd.g_old_rec.dei_information18;
909: End If;
910: If (p_rec.dei_information19 = hr_api.g_varchar2) then
906: If (p_rec.dei_information18 = hr_api.g_varchar2) then
907: p_rec.dei_information18 :=
908: hr_dei_shd.g_old_rec.dei_information18;
909: End If;
910: If (p_rec.dei_information19 = hr_api.g_varchar2) then
911: p_rec.dei_information19 :=
912: hr_dei_shd.g_old_rec.dei_information19;
913: End If;
914: If (p_rec.dei_information20 = hr_api.g_varchar2) then
910: If (p_rec.dei_information19 = hr_api.g_varchar2) then
911: p_rec.dei_information19 :=
912: hr_dei_shd.g_old_rec.dei_information19;
913: End If;
914: If (p_rec.dei_information20 = hr_api.g_varchar2) then
915: p_rec.dei_information20 :=
916: hr_dei_shd.g_old_rec.dei_information20;
917: End If;
918: If (p_rec.dei_information21 = hr_api.g_varchar2) then
914: If (p_rec.dei_information20 = hr_api.g_varchar2) then
915: p_rec.dei_information20 :=
916: hr_dei_shd.g_old_rec.dei_information20;
917: End If;
918: If (p_rec.dei_information21 = hr_api.g_varchar2) then
919: p_rec.dei_information21 :=
920: hr_dei_shd.g_old_rec.dei_information21;
921: End If;
922: If (p_rec.dei_information22 = hr_api.g_varchar2) then
918: If (p_rec.dei_information21 = hr_api.g_varchar2) then
919: p_rec.dei_information21 :=
920: hr_dei_shd.g_old_rec.dei_information21;
921: End If;
922: If (p_rec.dei_information22 = hr_api.g_varchar2) then
923: p_rec.dei_information22 :=
924: hr_dei_shd.g_old_rec.dei_information22;
925: End If;
926: If (p_rec.dei_information23 = hr_api.g_varchar2) then
922: If (p_rec.dei_information22 = hr_api.g_varchar2) then
923: p_rec.dei_information22 :=
924: hr_dei_shd.g_old_rec.dei_information22;
925: End If;
926: If (p_rec.dei_information23 = hr_api.g_varchar2) then
927: p_rec.dei_information23 :=
928: hr_dei_shd.g_old_rec.dei_information23;
929: End If;
930: If (p_rec.dei_information24 = hr_api.g_varchar2) then
926: If (p_rec.dei_information23 = hr_api.g_varchar2) then
927: p_rec.dei_information23 :=
928: hr_dei_shd.g_old_rec.dei_information23;
929: End If;
930: If (p_rec.dei_information24 = hr_api.g_varchar2) then
931: p_rec.dei_information24 :=
932: hr_dei_shd.g_old_rec.dei_information24;
933: End If;
934: If (p_rec.dei_information25 = hr_api.g_varchar2) then
930: If (p_rec.dei_information24 = hr_api.g_varchar2) then
931: p_rec.dei_information24 :=
932: hr_dei_shd.g_old_rec.dei_information24;
933: End If;
934: If (p_rec.dei_information25 = hr_api.g_varchar2) then
935: p_rec.dei_information25 :=
936: hr_dei_shd.g_old_rec.dei_information25;
937: End If;
938: If (p_rec.dei_information26 = hr_api.g_varchar2) then
934: If (p_rec.dei_information25 = hr_api.g_varchar2) then
935: p_rec.dei_information25 :=
936: hr_dei_shd.g_old_rec.dei_information25;
937: End If;
938: If (p_rec.dei_information26 = hr_api.g_varchar2) then
939: p_rec.dei_information26 :=
940: hr_dei_shd.g_old_rec.dei_information26;
941: End If;
942: If (p_rec.dei_information27 = hr_api.g_varchar2) then
938: If (p_rec.dei_information26 = hr_api.g_varchar2) then
939: p_rec.dei_information26 :=
940: hr_dei_shd.g_old_rec.dei_information26;
941: End If;
942: If (p_rec.dei_information27 = hr_api.g_varchar2) then
943: p_rec.dei_information27 :=
944: hr_dei_shd.g_old_rec.dei_information27;
945: End If;
946: If (p_rec.dei_information28 = hr_api.g_varchar2) then
942: If (p_rec.dei_information27 = hr_api.g_varchar2) then
943: p_rec.dei_information27 :=
944: hr_dei_shd.g_old_rec.dei_information27;
945: End If;
946: If (p_rec.dei_information28 = hr_api.g_varchar2) then
947: p_rec.dei_information28 :=
948: hr_dei_shd.g_old_rec.dei_information28;
949: End If;
950: If (p_rec.dei_information29 = hr_api.g_varchar2) then
946: If (p_rec.dei_information28 = hr_api.g_varchar2) then
947: p_rec.dei_information28 :=
948: hr_dei_shd.g_old_rec.dei_information28;
949: End If;
950: If (p_rec.dei_information29 = hr_api.g_varchar2) then
951: p_rec.dei_information29 :=
952: hr_dei_shd.g_old_rec.dei_information29;
953: End If;
954: If (p_rec.dei_information30 = hr_api.g_varchar2) then
950: If (p_rec.dei_information29 = hr_api.g_varchar2) then
951: p_rec.dei_information29 :=
952: hr_dei_shd.g_old_rec.dei_information29;
953: End If;
954: If (p_rec.dei_information30 = hr_api.g_varchar2) then
955: p_rec.dei_information30 :=
956: hr_dei_shd.g_old_rec.dei_information30;
957: End If;
958: If (p_rec.request_id = hr_api.g_number) then
954: If (p_rec.dei_information30 = hr_api.g_varchar2) then
955: p_rec.dei_information30 :=
956: hr_dei_shd.g_old_rec.dei_information30;
957: End If;
958: If (p_rec.request_id = hr_api.g_number) then
959: p_rec.request_id :=
960: hr_dei_shd.g_old_rec.request_id;
961: End If;
962: If (p_rec.program_application_id = hr_api.g_number) then
958: If (p_rec.request_id = hr_api.g_number) then
959: p_rec.request_id :=
960: hr_dei_shd.g_old_rec.request_id;
961: End If;
962: If (p_rec.program_application_id = hr_api.g_number) then
963: p_rec.program_application_id :=
964: hr_dei_shd.g_old_rec.program_application_id;
965: End If;
966: If (p_rec.program_id = hr_api.g_number) then
962: If (p_rec.program_application_id = hr_api.g_number) then
963: p_rec.program_application_id :=
964: hr_dei_shd.g_old_rec.program_application_id;
965: End If;
966: If (p_rec.program_id = hr_api.g_number) then
967: p_rec.program_id :=
968: hr_dei_shd.g_old_rec.program_id;
969: End If;
970: If (p_rec.program_update_date = hr_api.g_date) then
966: If (p_rec.program_id = hr_api.g_number) then
967: p_rec.program_id :=
968: hr_dei_shd.g_old_rec.program_id;
969: End If;
970: If (p_rec.program_update_date = hr_api.g_date) then
971: p_rec.program_update_date :=
972: hr_dei_shd.g_old_rec.program_update_date;
973: End If;
974: --
1030: -- ----------------------------------------------------------------------------
1031: Procedure upd
1032: (p_document_extra_info_id in number
1033: ,p_object_version_number in out nocopy number
1034: ,p_document_type_id in number default hr_api.g_number
1035: ,p_date_from in date default hr_api.g_date
1036: ,p_date_to in date default hr_api.g_date
1037: ,p_document_number in varchar2 default hr_api.g_varchar2
1038: ,p_issued_by in varchar2 default hr_api.g_varchar2
1031: Procedure upd
1032: (p_document_extra_info_id in number
1033: ,p_object_version_number in out nocopy number
1034: ,p_document_type_id in number default hr_api.g_number
1035: ,p_date_from in date default hr_api.g_date
1036: ,p_date_to in date default hr_api.g_date
1037: ,p_document_number in varchar2 default hr_api.g_varchar2
1038: ,p_issued_by in varchar2 default hr_api.g_varchar2
1039: ,p_issued_at in varchar2 default hr_api.g_varchar2
1032: (p_document_extra_info_id in number
1033: ,p_object_version_number in out nocopy number
1034: ,p_document_type_id in number default hr_api.g_number
1035: ,p_date_from in date default hr_api.g_date
1036: ,p_date_to in date default hr_api.g_date
1037: ,p_document_number in varchar2 default hr_api.g_varchar2
1038: ,p_issued_by in varchar2 default hr_api.g_varchar2
1039: ,p_issued_at in varchar2 default hr_api.g_varchar2
1040: ,p_issued_date in date default hr_api.g_date
1033: ,p_object_version_number in out nocopy number
1034: ,p_document_type_id in number default hr_api.g_number
1035: ,p_date_from in date default hr_api.g_date
1036: ,p_date_to in date default hr_api.g_date
1037: ,p_document_number in varchar2 default hr_api.g_varchar2
1038: ,p_issued_by in varchar2 default hr_api.g_varchar2
1039: ,p_issued_at in varchar2 default hr_api.g_varchar2
1040: ,p_issued_date in date default hr_api.g_date
1041: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
1034: ,p_document_type_id in number default hr_api.g_number
1035: ,p_date_from in date default hr_api.g_date
1036: ,p_date_to in date default hr_api.g_date
1037: ,p_document_number in varchar2 default hr_api.g_varchar2
1038: ,p_issued_by in varchar2 default hr_api.g_varchar2
1039: ,p_issued_at in varchar2 default hr_api.g_varchar2
1040: ,p_issued_date in date default hr_api.g_date
1041: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
1042: ,p_verified_by in number default hr_api.g_number
1035: ,p_date_from in date default hr_api.g_date
1036: ,p_date_to in date default hr_api.g_date
1037: ,p_document_number in varchar2 default hr_api.g_varchar2
1038: ,p_issued_by in varchar2 default hr_api.g_varchar2
1039: ,p_issued_at in varchar2 default hr_api.g_varchar2
1040: ,p_issued_date in date default hr_api.g_date
1041: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
1042: ,p_verified_by in number default hr_api.g_number
1043: ,p_verified_date in date default hr_api.g_date
1036: ,p_date_to in date default hr_api.g_date
1037: ,p_document_number in varchar2 default hr_api.g_varchar2
1038: ,p_issued_by in varchar2 default hr_api.g_varchar2
1039: ,p_issued_at in varchar2 default hr_api.g_varchar2
1040: ,p_issued_date in date default hr_api.g_date
1041: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
1042: ,p_verified_by in number default hr_api.g_number
1043: ,p_verified_date in date default hr_api.g_date
1044: ,p_related_object_name in varchar2 default hr_api.g_varchar2
1037: ,p_document_number in varchar2 default hr_api.g_varchar2
1038: ,p_issued_by in varchar2 default hr_api.g_varchar2
1039: ,p_issued_at in varchar2 default hr_api.g_varchar2
1040: ,p_issued_date in date default hr_api.g_date
1041: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
1042: ,p_verified_by in number default hr_api.g_number
1043: ,p_verified_date in date default hr_api.g_date
1044: ,p_related_object_name in varchar2 default hr_api.g_varchar2
1045: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
1038: ,p_issued_by in varchar2 default hr_api.g_varchar2
1039: ,p_issued_at in varchar2 default hr_api.g_varchar2
1040: ,p_issued_date in date default hr_api.g_date
1041: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
1042: ,p_verified_by in number default hr_api.g_number
1043: ,p_verified_date in date default hr_api.g_date
1044: ,p_related_object_name in varchar2 default hr_api.g_varchar2
1045: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
1046: ,p_related_object_id in number default hr_api.g_number
1039: ,p_issued_at in varchar2 default hr_api.g_varchar2
1040: ,p_issued_date in date default hr_api.g_date
1041: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
1042: ,p_verified_by in number default hr_api.g_number
1043: ,p_verified_date in date default hr_api.g_date
1044: ,p_related_object_name in varchar2 default hr_api.g_varchar2
1045: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
1046: ,p_related_object_id in number default hr_api.g_number
1047: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
1040: ,p_issued_date in date default hr_api.g_date
1041: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
1042: ,p_verified_by in number default hr_api.g_number
1043: ,p_verified_date in date default hr_api.g_date
1044: ,p_related_object_name in varchar2 default hr_api.g_varchar2
1045: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
1046: ,p_related_object_id in number default hr_api.g_number
1047: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
1048: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
1041: ,p_issuing_authority in varchar2 default hr_api.g_varchar2
1042: ,p_verified_by in number default hr_api.g_number
1043: ,p_verified_date in date default hr_api.g_date
1044: ,p_related_object_name in varchar2 default hr_api.g_varchar2
1045: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
1046: ,p_related_object_id in number default hr_api.g_number
1047: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
1048: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
1049: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
1042: ,p_verified_by in number default hr_api.g_number
1043: ,p_verified_date in date default hr_api.g_date
1044: ,p_related_object_name in varchar2 default hr_api.g_varchar2
1045: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
1046: ,p_related_object_id in number default hr_api.g_number
1047: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
1048: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
1049: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
1050: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
1043: ,p_verified_date in date default hr_api.g_date
1044: ,p_related_object_name in varchar2 default hr_api.g_varchar2
1045: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
1046: ,p_related_object_id in number default hr_api.g_number
1047: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
1048: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
1049: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
1050: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
1051: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
1044: ,p_related_object_name in varchar2 default hr_api.g_varchar2
1045: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
1046: ,p_related_object_id in number default hr_api.g_number
1047: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
1048: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
1049: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
1050: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
1051: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
1052: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
1045: ,p_related_object_id_col in varchar2 default hr_api.g_varchar2
1046: ,p_related_object_id in number default hr_api.g_number
1047: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
1048: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
1049: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
1050: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
1051: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
1052: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
1053: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
1046: ,p_related_object_id in number default hr_api.g_number
1047: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
1048: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
1049: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
1050: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
1051: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
1052: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
1053: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
1054: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
1047: ,p_dei_attribute_category in varchar2 default hr_api.g_varchar2
1048: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
1049: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
1050: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
1051: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
1052: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
1053: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
1054: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
1055: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
1048: ,p_dei_attribute1 in varchar2 default hr_api.g_varchar2
1049: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
1050: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
1051: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
1052: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
1053: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
1054: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
1055: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
1056: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
1049: ,p_dei_attribute2 in varchar2 default hr_api.g_varchar2
1050: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
1051: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
1052: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
1053: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
1054: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
1055: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
1056: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
1057: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
1050: ,p_dei_attribute3 in varchar2 default hr_api.g_varchar2
1051: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
1052: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
1053: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
1054: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
1055: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
1056: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
1057: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
1058: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
1051: ,p_dei_attribute4 in varchar2 default hr_api.g_varchar2
1052: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
1053: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
1054: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
1055: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
1056: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
1057: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
1058: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
1059: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
1052: ,p_dei_attribute5 in varchar2 default hr_api.g_varchar2
1053: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
1054: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
1055: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
1056: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
1057: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
1058: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
1059: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
1060: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
1053: ,p_dei_attribute6 in varchar2 default hr_api.g_varchar2
1054: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
1055: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
1056: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
1057: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
1058: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
1059: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
1060: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
1061: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
1054: ,p_dei_attribute7 in varchar2 default hr_api.g_varchar2
1055: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
1056: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
1057: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
1058: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
1059: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
1060: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
1061: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
1062: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
1055: ,p_dei_attribute8 in varchar2 default hr_api.g_varchar2
1056: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
1057: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
1058: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
1059: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
1060: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
1061: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
1062: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
1063: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
1056: ,p_dei_attribute9 in varchar2 default hr_api.g_varchar2
1057: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
1058: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
1059: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
1060: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
1061: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
1062: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
1063: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
1064: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
1057: ,p_dei_attribute10 in varchar2 default hr_api.g_varchar2
1058: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
1059: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
1060: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
1061: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
1062: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
1063: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
1064: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
1065: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
1058: ,p_dei_attribute11 in varchar2 default hr_api.g_varchar2
1059: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
1060: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
1061: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
1062: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
1063: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
1064: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
1065: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
1066: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
1059: ,p_dei_attribute12 in varchar2 default hr_api.g_varchar2
1060: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
1061: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
1062: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
1063: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
1064: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
1065: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
1066: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
1067: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
1060: ,p_dei_attribute13 in varchar2 default hr_api.g_varchar2
1061: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
1062: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
1063: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
1064: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
1065: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
1066: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
1067: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
1068: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
1061: ,p_dei_attribute14 in varchar2 default hr_api.g_varchar2
1062: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
1063: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
1064: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
1065: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
1066: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
1067: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
1068: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
1069: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
1062: ,p_dei_attribute15 in varchar2 default hr_api.g_varchar2
1063: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
1064: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
1065: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
1066: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
1067: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
1068: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
1069: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
1070: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
1063: ,p_dei_attribute16 in varchar2 default hr_api.g_varchar2
1064: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
1065: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
1066: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
1067: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
1068: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
1069: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
1070: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
1071: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
1064: ,p_dei_attribute17 in varchar2 default hr_api.g_varchar2
1065: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
1066: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
1067: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
1068: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
1069: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
1070: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
1071: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
1072: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
1065: ,p_dei_attribute18 in varchar2 default hr_api.g_varchar2
1066: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
1067: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
1068: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
1069: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
1070: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
1071: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
1072: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
1073: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
1066: ,p_dei_attribute19 in varchar2 default hr_api.g_varchar2
1067: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
1068: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
1069: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
1070: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
1071: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
1072: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
1073: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
1074: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
1067: ,p_dei_attribute20 in varchar2 default hr_api.g_varchar2
1068: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
1069: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
1070: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
1071: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
1072: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
1073: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
1074: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
1075: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
1068: ,p_dei_attribute21 in varchar2 default hr_api.g_varchar2
1069: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
1070: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
1071: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
1072: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
1073: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
1074: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
1075: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
1076: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
1069: ,p_dei_attribute22 in varchar2 default hr_api.g_varchar2
1070: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
1071: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
1072: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
1073: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
1074: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
1075: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
1076: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
1077: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
1070: ,p_dei_attribute23 in varchar2 default hr_api.g_varchar2
1071: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
1072: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
1073: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
1074: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
1075: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
1076: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
1077: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
1078: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
1071: ,p_dei_attribute24 in varchar2 default hr_api.g_varchar2
1072: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
1073: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
1074: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
1075: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
1076: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
1077: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
1078: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
1079: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
1072: ,p_dei_attribute25 in varchar2 default hr_api.g_varchar2
1073: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
1074: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
1075: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
1076: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
1077: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
1078: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
1079: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
1080: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
1073: ,p_dei_attribute26 in varchar2 default hr_api.g_varchar2
1074: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
1075: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
1076: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
1077: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
1078: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
1079: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
1080: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
1081: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
1074: ,p_dei_attribute27 in varchar2 default hr_api.g_varchar2
1075: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
1076: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
1077: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
1078: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
1079: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
1080: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
1081: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
1082: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
1075: ,p_dei_attribute28 in varchar2 default hr_api.g_varchar2
1076: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
1077: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
1078: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
1079: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
1080: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
1081: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
1082: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
1083: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
1076: ,p_dei_attribute29 in varchar2 default hr_api.g_varchar2
1077: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
1078: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
1079: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
1080: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
1081: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
1082: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
1083: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
1084: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
1077: ,p_dei_attribute30 in varchar2 default hr_api.g_varchar2
1078: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
1079: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
1080: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
1081: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
1082: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
1083: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
1084: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
1085: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
1078: ,p_dei_information_category in varchar2 default hr_api.g_varchar2
1079: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
1080: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
1081: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
1082: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
1083: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
1084: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
1085: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
1086: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
1079: ,p_dei_information1 in varchar2 default hr_api.g_varchar2
1080: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
1081: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
1082: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
1083: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
1084: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
1085: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
1086: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
1087: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
1080: ,p_dei_information2 in varchar2 default hr_api.g_varchar2
1081: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
1082: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
1083: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
1084: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
1085: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
1086: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
1087: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
1088: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
1081: ,p_dei_information3 in varchar2 default hr_api.g_varchar2
1082: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
1083: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
1084: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
1085: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
1086: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
1087: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
1088: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
1089: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
1082: ,p_dei_information4 in varchar2 default hr_api.g_varchar2
1083: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
1084: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
1085: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
1086: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
1087: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
1088: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
1089: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
1090: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
1083: ,p_dei_information5 in varchar2 default hr_api.g_varchar2
1084: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
1085: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
1086: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
1087: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
1088: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
1089: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
1090: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
1091: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
1084: ,p_dei_information6 in varchar2 default hr_api.g_varchar2
1085: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
1086: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
1087: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
1088: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
1089: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
1090: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
1091: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
1092: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
1085: ,p_dei_information7 in varchar2 default hr_api.g_varchar2
1086: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
1087: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
1088: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
1089: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
1090: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
1091: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
1092: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
1093: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
1086: ,p_dei_information8 in varchar2 default hr_api.g_varchar2
1087: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
1088: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
1089: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
1090: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
1091: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
1092: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
1093: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
1094: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
1087: ,p_dei_information9 in varchar2 default hr_api.g_varchar2
1088: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
1089: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
1090: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
1091: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
1092: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
1093: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
1094: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
1095: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
1088: ,p_dei_information10 in varchar2 default hr_api.g_varchar2
1089: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
1090: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
1091: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
1092: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
1093: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
1094: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
1095: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
1096: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
1089: ,p_dei_information11 in varchar2 default hr_api.g_varchar2
1090: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
1091: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
1092: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
1093: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
1094: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
1095: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
1096: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
1097: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
1090: ,p_dei_information12 in varchar2 default hr_api.g_varchar2
1091: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
1092: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
1093: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
1094: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
1095: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
1096: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
1097: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
1098: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
1091: ,p_dei_information13 in varchar2 default hr_api.g_varchar2
1092: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
1093: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
1094: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
1095: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
1096: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
1097: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
1098: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
1099: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
1092: ,p_dei_information14 in varchar2 default hr_api.g_varchar2
1093: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
1094: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
1095: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
1096: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
1097: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
1098: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
1099: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
1100: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
1093: ,p_dei_information15 in varchar2 default hr_api.g_varchar2
1094: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
1095: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
1096: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
1097: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
1098: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
1099: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
1100: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
1101: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
1094: ,p_dei_information16 in varchar2 default hr_api.g_varchar2
1095: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
1096: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
1097: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
1098: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
1099: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
1100: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
1101: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
1102: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
1095: ,p_dei_information17 in varchar2 default hr_api.g_varchar2
1096: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
1097: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
1098: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
1099: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
1100: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
1101: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
1102: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
1103: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
1096: ,p_dei_information18 in varchar2 default hr_api.g_varchar2
1097: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
1098: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
1099: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
1100: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
1101: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
1102: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
1103: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
1104: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
1097: ,p_dei_information19 in varchar2 default hr_api.g_varchar2
1098: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
1099: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
1100: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
1101: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
1102: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
1103: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
1104: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
1105: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
1098: ,p_dei_information20 in varchar2 default hr_api.g_varchar2
1099: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
1100: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
1101: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
1102: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
1103: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
1104: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
1105: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
1106: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
1099: ,p_dei_information21 in varchar2 default hr_api.g_varchar2
1100: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
1101: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
1102: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
1103: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
1104: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
1105: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
1106: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
1107: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
1100: ,p_dei_information22 in varchar2 default hr_api.g_varchar2
1101: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
1102: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
1103: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
1104: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
1105: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
1106: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
1107: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
1108: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
1101: ,p_dei_information23 in varchar2 default hr_api.g_varchar2
1102: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
1103: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
1104: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
1105: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
1106: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
1107: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
1108: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
1109: ,p_request_id in number default hr_api.g_number
1102: ,p_dei_information24 in varchar2 default hr_api.g_varchar2
1103: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
1104: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
1105: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
1106: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
1107: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
1108: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
1109: ,p_request_id in number default hr_api.g_number
1110: ,p_program_application_id in number default hr_api.g_number
1103: ,p_dei_information25 in varchar2 default hr_api.g_varchar2
1104: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
1105: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
1106: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
1107: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
1108: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
1109: ,p_request_id in number default hr_api.g_number
1110: ,p_program_application_id in number default hr_api.g_number
1111: ,p_program_id in number default hr_api.g_number
1104: ,p_dei_information26 in varchar2 default hr_api.g_varchar2
1105: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
1106: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
1107: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
1108: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
1109: ,p_request_id in number default hr_api.g_number
1110: ,p_program_application_id in number default hr_api.g_number
1111: ,p_program_id in number default hr_api.g_number
1112: ,p_program_update_date in date default hr_api.g_date
1105: ,p_dei_information27 in varchar2 default hr_api.g_varchar2
1106: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
1107: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
1108: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
1109: ,p_request_id in number default hr_api.g_number
1110: ,p_program_application_id in number default hr_api.g_number
1111: ,p_program_id in number default hr_api.g_number
1112: ,p_program_update_date in date default hr_api.g_date
1113: ) is
1106: ,p_dei_information28 in varchar2 default hr_api.g_varchar2
1107: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
1108: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
1109: ,p_request_id in number default hr_api.g_number
1110: ,p_program_application_id in number default hr_api.g_number
1111: ,p_program_id in number default hr_api.g_number
1112: ,p_program_update_date in date default hr_api.g_date
1113: ) is
1114: --
1107: ,p_dei_information29 in varchar2 default hr_api.g_varchar2
1108: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
1109: ,p_request_id in number default hr_api.g_number
1110: ,p_program_application_id in number default hr_api.g_number
1111: ,p_program_id in number default hr_api.g_number
1112: ,p_program_update_date in date default hr_api.g_date
1113: ) is
1114: --
1115: l_rec hr_dei_shd.g_rec_type;
1108: ,p_dei_information30 in varchar2 default hr_api.g_varchar2
1109: ,p_request_id in number default hr_api.g_number
1110: ,p_program_application_id in number default hr_api.g_number
1111: ,p_program_id in number default hr_api.g_number
1112: ,p_program_update_date in date default hr_api.g_date
1113: ) is
1114: --
1115: l_rec hr_dei_shd.g_rec_type;
1116: l_proc varchar2(72) := g_package||'upd';
1123: --
1124: l_rec :=
1125: hr_dei_shd.convert_args
1126: (p_document_extra_info_id
1127: ,hr_api.g_number
1128: ,p_document_type_id
1129: ,p_document_number
1130: ,p_date_from
1131: ,p_date_to