eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DEI_UPD dependencies on HR_API

Line 154: When hr_api.check_integrity_violated Then

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

Line 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

Line 159: When hr_api.parent_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
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 164: When hr_api.unique_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
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 589: when hr_api.cannot_find_prog_unit then

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

Line 591: hr_api.cannot_find_prog_unit_error

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;

Line 654: If (p_rec.person_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 1034: ,p_document_type_id in number default hr_api.g_number

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

Line 1035: ,p_date_from in date default hr_api.g_date

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

Line 1036: ,p_date_to in date default hr_api.g_date

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

Line 1037: ,p_document_number in varchar2 default hr_api.g_varchar2

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

Line 1038: ,p_issued_by 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

Line 1039: ,p_issued_at in varchar2 default hr_api.g_varchar2

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

Line 1040: ,p_issued_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

Line 1041: ,p_issuing_authority 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

Line 1042: ,p_verified_by in number default hr_api.g_number

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

Line 1043: ,p_verified_date in date default hr_api.g_date

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

Line 1044: ,p_related_object_name 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

Line 1045: ,p_related_object_id_col 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

Line 1046: ,p_related_object_id in number default hr_api.g_number

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

Line 1047: ,p_dei_attribute_category 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

Line 1048: ,p_dei_attribute1 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

Line 1049: ,p_dei_attribute2 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

Line 1050: ,p_dei_attribute3 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

Line 1051: ,p_dei_attribute4 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

Line 1052: ,p_dei_attribute5 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

Line 1053: ,p_dei_attribute6 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

Line 1054: ,p_dei_attribute7 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

Line 1055: ,p_dei_attribute8 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

Line 1056: ,p_dei_attribute9 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

Line 1057: ,p_dei_attribute10 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

Line 1058: ,p_dei_attribute11 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

Line 1059: ,p_dei_attribute12 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

Line 1060: ,p_dei_attribute13 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

Line 1061: ,p_dei_attribute14 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

Line 1062: ,p_dei_attribute15 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

Line 1063: ,p_dei_attribute16 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

Line 1064: ,p_dei_attribute17 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

Line 1065: ,p_dei_attribute18 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

Line 1066: ,p_dei_attribute19 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

Line 1067: ,p_dei_attribute20 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

Line 1068: ,p_dei_attribute21 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

Line 1069: ,p_dei_attribute22 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

Line 1070: ,p_dei_attribute23 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

Line 1071: ,p_dei_attribute24 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

Line 1072: ,p_dei_attribute25 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

Line 1073: ,p_dei_attribute26 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

Line 1074: ,p_dei_attribute27 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

Line 1075: ,p_dei_attribute28 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

Line 1076: ,p_dei_attribute29 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

Line 1077: ,p_dei_attribute30 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

Line 1078: ,p_dei_information_category 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

Line 1079: ,p_dei_information1 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

Line 1080: ,p_dei_information2 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

Line 1081: ,p_dei_information3 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

Line 1082: ,p_dei_information4 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

Line 1083: ,p_dei_information5 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

Line 1084: ,p_dei_information6 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

Line 1085: ,p_dei_information7 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

Line 1086: ,p_dei_information8 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

Line 1087: ,p_dei_information9 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

Line 1088: ,p_dei_information10 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

Line 1089: ,p_dei_information11 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

Line 1090: ,p_dei_information12 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

Line 1091: ,p_dei_information13 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

Line 1092: ,p_dei_information14 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

Line 1093: ,p_dei_information15 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

Line 1094: ,p_dei_information16 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

Line 1095: ,p_dei_information17 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

Line 1096: ,p_dei_information18 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

Line 1097: ,p_dei_information19 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

Line 1098: ,p_dei_information20 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

Line 1099: ,p_dei_information21 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

Line 1100: ,p_dei_information22 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

Line 1101: ,p_dei_information23 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

Line 1102: ,p_dei_information24 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

Line 1103: ,p_dei_information25 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

Line 1104: ,p_dei_information26 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

Line 1105: ,p_dei_information27 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

Line 1106: ,p_dei_information28 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
1110: ,p_program_application_id in number default hr_api.g_number

Line 1107: ,p_dei_information29 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
1111: ,p_program_id in number default hr_api.g_number

Line 1108: ,p_dei_information30 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
1112: ,p_program_update_date in date default hr_api.g_date

Line 1109: ,p_request_id in number default hr_api.g_number

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

Line 1110: ,p_program_application_id in number default hr_api.g_number

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

Line 1111: ,p_program_id in number default hr_api.g_number

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;

Line 1112: ,p_program_update_date in date default hr_api.g_date

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

Line 1127: ,hr_api.g_number

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