148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: --
151: Exception
152: When hr_api.check_integrity_violated Then
153: -- A check constraint has been violated
154: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
155: --
156: irc_ipc_shd.constraint_error
153: -- A check constraint has been violated
154: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
155: --
156: irc_ipc_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
161: --
154: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
155: --
156: irc_ipc_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
161: --
162: irc_ipc_shd.constraint_error
159: -- Parent integrity has been violated
160: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
161: --
162: irc_ipc_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: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
167: --
160: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
161: --
162: irc_ipc_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: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
167: --
168: irc_ipc_shd.constraint_error
165: -- Unique integrity has been violated
166: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
167: --
168: irc_ipc_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When Others Then
171: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
172: --
173: Raise;
553: );
554: --
555: exception
556: --
557: when hr_api.cannot_find_prog_unit then
558: --
559: hr_api.cannot_find_prog_unit_error
560: (p_module_name => 'IRC_POSTING_CONTENTS'
561: ,p_hook_type => 'AU');
555: exception
556: --
557: when hr_api.cannot_find_prog_unit then
558: --
559: hr_api.cannot_find_prog_unit_error
560: (p_module_name => 'IRC_POSTING_CONTENTS'
561: ,p_hook_type => 'AU');
562: --
563: end;
618: -- p_rec plsql record structure
619: -- to see if a system default is being used. If a system default
620: -- is being used then we must set to the 'current' argument value.
621: --
622: If (p_rec.display_manager_info = hr_api.g_varchar2) then
623: p_rec.display_manager_info :=
624: irc_ipc_shd.g_old_rec.display_manager_info;
625: End If;
626: If (p_rec.display_recruiter_info = hr_api.g_varchar2) then
622: If (p_rec.display_manager_info = hr_api.g_varchar2) then
623: p_rec.display_manager_info :=
624: irc_ipc_shd.g_old_rec.display_manager_info;
625: End If;
626: If (p_rec.display_recruiter_info = hr_api.g_varchar2) then
627: p_rec.display_recruiter_info :=
628: irc_ipc_shd.g_old_rec.display_recruiter_info;
629: End If;
630: If (p_rec.attribute_category = hr_api.g_varchar2) then
626: If (p_rec.display_recruiter_info = hr_api.g_varchar2) then
627: p_rec.display_recruiter_info :=
628: irc_ipc_shd.g_old_rec.display_recruiter_info;
629: End If;
630: If (p_rec.attribute_category = hr_api.g_varchar2) then
631: p_rec.attribute_category :=
632: irc_ipc_shd.g_old_rec.attribute_category;
633: End If;
634: If (p_rec.attribute1 = hr_api.g_varchar2) then
630: If (p_rec.attribute_category = hr_api.g_varchar2) then
631: p_rec.attribute_category :=
632: irc_ipc_shd.g_old_rec.attribute_category;
633: End If;
634: If (p_rec.attribute1 = hr_api.g_varchar2) then
635: p_rec.attribute1 :=
636: irc_ipc_shd.g_old_rec.attribute1;
637: End If;
638: If (p_rec.attribute2 = hr_api.g_varchar2) then
634: If (p_rec.attribute1 = hr_api.g_varchar2) then
635: p_rec.attribute1 :=
636: irc_ipc_shd.g_old_rec.attribute1;
637: End If;
638: If (p_rec.attribute2 = hr_api.g_varchar2) then
639: p_rec.attribute2 :=
640: irc_ipc_shd.g_old_rec.attribute2;
641: End If;
642: If (p_rec.attribute3 = hr_api.g_varchar2) then
638: If (p_rec.attribute2 = hr_api.g_varchar2) then
639: p_rec.attribute2 :=
640: irc_ipc_shd.g_old_rec.attribute2;
641: End If;
642: If (p_rec.attribute3 = hr_api.g_varchar2) then
643: p_rec.attribute3 :=
644: irc_ipc_shd.g_old_rec.attribute3;
645: End If;
646: If (p_rec.attribute4 = hr_api.g_varchar2) then
642: If (p_rec.attribute3 = hr_api.g_varchar2) then
643: p_rec.attribute3 :=
644: irc_ipc_shd.g_old_rec.attribute3;
645: End If;
646: If (p_rec.attribute4 = hr_api.g_varchar2) then
647: p_rec.attribute4 :=
648: irc_ipc_shd.g_old_rec.attribute4;
649: End If;
650: If (p_rec.attribute5 = hr_api.g_varchar2) then
646: If (p_rec.attribute4 = hr_api.g_varchar2) then
647: p_rec.attribute4 :=
648: irc_ipc_shd.g_old_rec.attribute4;
649: End If;
650: If (p_rec.attribute5 = hr_api.g_varchar2) then
651: p_rec.attribute5 :=
652: irc_ipc_shd.g_old_rec.attribute5;
653: End If;
654: If (p_rec.attribute6 = hr_api.g_varchar2) then
650: If (p_rec.attribute5 = hr_api.g_varchar2) then
651: p_rec.attribute5 :=
652: irc_ipc_shd.g_old_rec.attribute5;
653: End If;
654: If (p_rec.attribute6 = hr_api.g_varchar2) then
655: p_rec.attribute6 :=
656: irc_ipc_shd.g_old_rec.attribute6;
657: End If;
658: If (p_rec.attribute7 = hr_api.g_varchar2) then
654: If (p_rec.attribute6 = hr_api.g_varchar2) then
655: p_rec.attribute6 :=
656: irc_ipc_shd.g_old_rec.attribute6;
657: End If;
658: If (p_rec.attribute7 = hr_api.g_varchar2) then
659: p_rec.attribute7 :=
660: irc_ipc_shd.g_old_rec.attribute7;
661: End If;
662: If (p_rec.attribute8 = hr_api.g_varchar2) then
658: If (p_rec.attribute7 = hr_api.g_varchar2) then
659: p_rec.attribute7 :=
660: irc_ipc_shd.g_old_rec.attribute7;
661: End If;
662: If (p_rec.attribute8 = hr_api.g_varchar2) then
663: p_rec.attribute8 :=
664: irc_ipc_shd.g_old_rec.attribute8;
665: End If;
666: If (p_rec.attribute9 = hr_api.g_varchar2) then
662: If (p_rec.attribute8 = hr_api.g_varchar2) then
663: p_rec.attribute8 :=
664: irc_ipc_shd.g_old_rec.attribute8;
665: End If;
666: If (p_rec.attribute9 = hr_api.g_varchar2) then
667: p_rec.attribute9 :=
668: irc_ipc_shd.g_old_rec.attribute9;
669: End If;
670: If (p_rec.attribute10 = hr_api.g_varchar2) then
666: If (p_rec.attribute9 = hr_api.g_varchar2) then
667: p_rec.attribute9 :=
668: irc_ipc_shd.g_old_rec.attribute9;
669: End If;
670: If (p_rec.attribute10 = hr_api.g_varchar2) then
671: p_rec.attribute10 :=
672: irc_ipc_shd.g_old_rec.attribute10;
673: End If;
674: If (p_rec.attribute11 = hr_api.g_varchar2) then
670: If (p_rec.attribute10 = hr_api.g_varchar2) then
671: p_rec.attribute10 :=
672: irc_ipc_shd.g_old_rec.attribute10;
673: End If;
674: If (p_rec.attribute11 = hr_api.g_varchar2) then
675: p_rec.attribute11 :=
676: irc_ipc_shd.g_old_rec.attribute11;
677: End If;
678: If (p_rec.attribute12 = hr_api.g_varchar2) then
674: If (p_rec.attribute11 = hr_api.g_varchar2) then
675: p_rec.attribute11 :=
676: irc_ipc_shd.g_old_rec.attribute11;
677: End If;
678: If (p_rec.attribute12 = hr_api.g_varchar2) then
679: p_rec.attribute12 :=
680: irc_ipc_shd.g_old_rec.attribute12;
681: End If;
682: If (p_rec.attribute13 = hr_api.g_varchar2) then
678: If (p_rec.attribute12 = hr_api.g_varchar2) then
679: p_rec.attribute12 :=
680: irc_ipc_shd.g_old_rec.attribute12;
681: End If;
682: If (p_rec.attribute13 = hr_api.g_varchar2) then
683: p_rec.attribute13 :=
684: irc_ipc_shd.g_old_rec.attribute13;
685: End If;
686: If (p_rec.attribute14 = hr_api.g_varchar2) then
682: If (p_rec.attribute13 = hr_api.g_varchar2) then
683: p_rec.attribute13 :=
684: irc_ipc_shd.g_old_rec.attribute13;
685: End If;
686: If (p_rec.attribute14 = hr_api.g_varchar2) then
687: p_rec.attribute14 :=
688: irc_ipc_shd.g_old_rec.attribute14;
689: End If;
690: If (p_rec.attribute15 = hr_api.g_varchar2) then
686: If (p_rec.attribute14 = hr_api.g_varchar2) then
687: p_rec.attribute14 :=
688: irc_ipc_shd.g_old_rec.attribute14;
689: End If;
690: If (p_rec.attribute15 = hr_api.g_varchar2) then
691: p_rec.attribute15 :=
692: irc_ipc_shd.g_old_rec.attribute15;
693: End If;
694: If (p_rec.attribute16 = hr_api.g_varchar2) then
690: If (p_rec.attribute15 = hr_api.g_varchar2) then
691: p_rec.attribute15 :=
692: irc_ipc_shd.g_old_rec.attribute15;
693: End If;
694: If (p_rec.attribute16 = hr_api.g_varchar2) then
695: p_rec.attribute16 :=
696: irc_ipc_shd.g_old_rec.attribute16;
697: End If;
698: If (p_rec.attribute17 = hr_api.g_varchar2) then
694: If (p_rec.attribute16 = hr_api.g_varchar2) then
695: p_rec.attribute16 :=
696: irc_ipc_shd.g_old_rec.attribute16;
697: End If;
698: If (p_rec.attribute17 = hr_api.g_varchar2) then
699: p_rec.attribute17 :=
700: irc_ipc_shd.g_old_rec.attribute17;
701: End If;
702: If (p_rec.attribute18 = hr_api.g_varchar2) then
698: If (p_rec.attribute17 = hr_api.g_varchar2) then
699: p_rec.attribute17 :=
700: irc_ipc_shd.g_old_rec.attribute17;
701: End If;
702: If (p_rec.attribute18 = hr_api.g_varchar2) then
703: p_rec.attribute18 :=
704: irc_ipc_shd.g_old_rec.attribute18;
705: End If;
706: If (p_rec.attribute19 = hr_api.g_varchar2) then
702: If (p_rec.attribute18 = hr_api.g_varchar2) then
703: p_rec.attribute18 :=
704: irc_ipc_shd.g_old_rec.attribute18;
705: End If;
706: If (p_rec.attribute19 = hr_api.g_varchar2) then
707: p_rec.attribute19 :=
708: irc_ipc_shd.g_old_rec.attribute19;
709: End If;
710: If (p_rec.attribute20 = hr_api.g_varchar2) then
706: If (p_rec.attribute19 = hr_api.g_varchar2) then
707: p_rec.attribute19 :=
708: irc_ipc_shd.g_old_rec.attribute19;
709: End If;
710: If (p_rec.attribute20 = hr_api.g_varchar2) then
711: p_rec.attribute20 :=
712: irc_ipc_shd.g_old_rec.attribute20;
713: End If;
714: If (p_rec.attribute21 = hr_api.g_varchar2) then
710: If (p_rec.attribute20 = hr_api.g_varchar2) then
711: p_rec.attribute20 :=
712: irc_ipc_shd.g_old_rec.attribute20;
713: End If;
714: If (p_rec.attribute21 = hr_api.g_varchar2) then
715: p_rec.attribute21 :=
716: irc_ipc_shd.g_old_rec.attribute21;
717: End If;
718: If (p_rec.attribute22 = hr_api.g_varchar2) then
714: If (p_rec.attribute21 = hr_api.g_varchar2) then
715: p_rec.attribute21 :=
716: irc_ipc_shd.g_old_rec.attribute21;
717: End If;
718: If (p_rec.attribute22 = hr_api.g_varchar2) then
719: p_rec.attribute22 :=
720: irc_ipc_shd.g_old_rec.attribute22;
721: End If;
722: If (p_rec.attribute23 = hr_api.g_varchar2) then
718: If (p_rec.attribute22 = hr_api.g_varchar2) then
719: p_rec.attribute22 :=
720: irc_ipc_shd.g_old_rec.attribute22;
721: End If;
722: If (p_rec.attribute23 = hr_api.g_varchar2) then
723: p_rec.attribute23 :=
724: irc_ipc_shd.g_old_rec.attribute23;
725: End If;
726: If (p_rec.attribute24 = hr_api.g_varchar2) then
722: If (p_rec.attribute23 = hr_api.g_varchar2) then
723: p_rec.attribute23 :=
724: irc_ipc_shd.g_old_rec.attribute23;
725: End If;
726: If (p_rec.attribute24 = hr_api.g_varchar2) then
727: p_rec.attribute24 :=
728: irc_ipc_shd.g_old_rec.attribute24;
729: End If;
730: If (p_rec.attribute25 = hr_api.g_varchar2) then
726: If (p_rec.attribute24 = hr_api.g_varchar2) then
727: p_rec.attribute24 :=
728: irc_ipc_shd.g_old_rec.attribute24;
729: End If;
730: If (p_rec.attribute25 = hr_api.g_varchar2) then
731: p_rec.attribute25 :=
732: irc_ipc_shd.g_old_rec.attribute25;
733: End If;
734: If (p_rec.attribute26 = hr_api.g_varchar2) then
730: If (p_rec.attribute25 = hr_api.g_varchar2) then
731: p_rec.attribute25 :=
732: irc_ipc_shd.g_old_rec.attribute25;
733: End If;
734: If (p_rec.attribute26 = hr_api.g_varchar2) then
735: p_rec.attribute26 :=
736: irc_ipc_shd.g_old_rec.attribute26;
737: End If;
738: If (p_rec.attribute27 = hr_api.g_varchar2) then
734: If (p_rec.attribute26 = hr_api.g_varchar2) then
735: p_rec.attribute26 :=
736: irc_ipc_shd.g_old_rec.attribute26;
737: End If;
738: If (p_rec.attribute27 = hr_api.g_varchar2) then
739: p_rec.attribute27 :=
740: irc_ipc_shd.g_old_rec.attribute27;
741: End If;
742: If (p_rec.attribute28 = hr_api.g_varchar2) then
738: If (p_rec.attribute27 = hr_api.g_varchar2) then
739: p_rec.attribute27 :=
740: irc_ipc_shd.g_old_rec.attribute27;
741: End If;
742: If (p_rec.attribute28 = hr_api.g_varchar2) then
743: p_rec.attribute28 :=
744: irc_ipc_shd.g_old_rec.attribute28;
745: End If;
746: If (p_rec.attribute29 = hr_api.g_varchar2) then
742: If (p_rec.attribute28 = hr_api.g_varchar2) then
743: p_rec.attribute28 :=
744: irc_ipc_shd.g_old_rec.attribute28;
745: End If;
746: If (p_rec.attribute29 = hr_api.g_varchar2) then
747: p_rec.attribute29 :=
748: irc_ipc_shd.g_old_rec.attribute29;
749: End If;
750: If (p_rec.attribute30 = hr_api.g_varchar2) then
746: If (p_rec.attribute29 = hr_api.g_varchar2) then
747: p_rec.attribute29 :=
748: irc_ipc_shd.g_old_rec.attribute29;
749: End If;
750: If (p_rec.attribute30 = hr_api.g_varchar2) then
751: p_rec.attribute30 :=
752: irc_ipc_shd.g_old_rec.attribute30;
753: End If;
754: If (p_rec.ipc_information_category = hr_api.g_varchar2) then
750: If (p_rec.attribute30 = hr_api.g_varchar2) then
751: p_rec.attribute30 :=
752: irc_ipc_shd.g_old_rec.attribute30;
753: End If;
754: If (p_rec.ipc_information_category = hr_api.g_varchar2) then
755: p_rec.ipc_information_category :=
756: irc_ipc_shd.g_old_rec.ipc_information_category;
757: End If;
758: If (p_rec.ipc_information1 = hr_api.g_varchar2) then
754: If (p_rec.ipc_information_category = hr_api.g_varchar2) then
755: p_rec.ipc_information_category :=
756: irc_ipc_shd.g_old_rec.ipc_information_category;
757: End If;
758: If (p_rec.ipc_information1 = hr_api.g_varchar2) then
759: p_rec.ipc_information1 :=
760: irc_ipc_shd.g_old_rec.ipc_information1;
761: End If;
762: If (p_rec.ipc_information2 = hr_api.g_varchar2) then
758: If (p_rec.ipc_information1 = hr_api.g_varchar2) then
759: p_rec.ipc_information1 :=
760: irc_ipc_shd.g_old_rec.ipc_information1;
761: End If;
762: If (p_rec.ipc_information2 = hr_api.g_varchar2) then
763: p_rec.ipc_information2 :=
764: irc_ipc_shd.g_old_rec.ipc_information2;
765: End If;
766: If (p_rec.ipc_information3 = hr_api.g_varchar2) then
762: If (p_rec.ipc_information2 = hr_api.g_varchar2) then
763: p_rec.ipc_information2 :=
764: irc_ipc_shd.g_old_rec.ipc_information2;
765: End If;
766: If (p_rec.ipc_information3 = hr_api.g_varchar2) then
767: p_rec.ipc_information3 :=
768: irc_ipc_shd.g_old_rec.ipc_information3;
769: End If;
770: If (p_rec.ipc_information4 = hr_api.g_varchar2) then
766: If (p_rec.ipc_information3 = hr_api.g_varchar2) then
767: p_rec.ipc_information3 :=
768: irc_ipc_shd.g_old_rec.ipc_information3;
769: End If;
770: If (p_rec.ipc_information4 = hr_api.g_varchar2) then
771: p_rec.ipc_information4 :=
772: irc_ipc_shd.g_old_rec.ipc_information4;
773: End If;
774: If (p_rec.ipc_information5 = hr_api.g_varchar2) then
770: If (p_rec.ipc_information4 = hr_api.g_varchar2) then
771: p_rec.ipc_information4 :=
772: irc_ipc_shd.g_old_rec.ipc_information4;
773: End If;
774: If (p_rec.ipc_information5 = hr_api.g_varchar2) then
775: p_rec.ipc_information5 :=
776: irc_ipc_shd.g_old_rec.ipc_information5;
777: End If;
778: If (p_rec.ipc_information6 = hr_api.g_varchar2) then
774: If (p_rec.ipc_information5 = hr_api.g_varchar2) then
775: p_rec.ipc_information5 :=
776: irc_ipc_shd.g_old_rec.ipc_information5;
777: End If;
778: If (p_rec.ipc_information6 = hr_api.g_varchar2) then
779: p_rec.ipc_information6 :=
780: irc_ipc_shd.g_old_rec.ipc_information6;
781: End If;
782: If (p_rec.ipc_information7 = hr_api.g_varchar2) then
778: If (p_rec.ipc_information6 = hr_api.g_varchar2) then
779: p_rec.ipc_information6 :=
780: irc_ipc_shd.g_old_rec.ipc_information6;
781: End If;
782: If (p_rec.ipc_information7 = hr_api.g_varchar2) then
783: p_rec.ipc_information7 :=
784: irc_ipc_shd.g_old_rec.ipc_information7;
785: End If;
786: If (p_rec.ipc_information8 = hr_api.g_varchar2) then
782: If (p_rec.ipc_information7 = hr_api.g_varchar2) then
783: p_rec.ipc_information7 :=
784: irc_ipc_shd.g_old_rec.ipc_information7;
785: End If;
786: If (p_rec.ipc_information8 = hr_api.g_varchar2) then
787: p_rec.ipc_information8 :=
788: irc_ipc_shd.g_old_rec.ipc_information8;
789: End If;
790: If (p_rec.ipc_information9 = hr_api.g_varchar2) then
786: If (p_rec.ipc_information8 = hr_api.g_varchar2) then
787: p_rec.ipc_information8 :=
788: irc_ipc_shd.g_old_rec.ipc_information8;
789: End If;
790: If (p_rec.ipc_information9 = hr_api.g_varchar2) then
791: p_rec.ipc_information9 :=
792: irc_ipc_shd.g_old_rec.ipc_information9;
793: End If;
794: If (p_rec.ipc_information10 = hr_api.g_varchar2) then
790: If (p_rec.ipc_information9 = hr_api.g_varchar2) then
791: p_rec.ipc_information9 :=
792: irc_ipc_shd.g_old_rec.ipc_information9;
793: End If;
794: If (p_rec.ipc_information10 = hr_api.g_varchar2) then
795: p_rec.ipc_information10 :=
796: irc_ipc_shd.g_old_rec.ipc_information10;
797: End If;
798: If (p_rec.ipc_information11 = hr_api.g_varchar2) then
794: If (p_rec.ipc_information10 = hr_api.g_varchar2) then
795: p_rec.ipc_information10 :=
796: irc_ipc_shd.g_old_rec.ipc_information10;
797: End If;
798: If (p_rec.ipc_information11 = hr_api.g_varchar2) then
799: p_rec.ipc_information11 :=
800: irc_ipc_shd.g_old_rec.ipc_information11;
801: End If;
802: If (p_rec.ipc_information12 = hr_api.g_varchar2) then
798: If (p_rec.ipc_information11 = hr_api.g_varchar2) then
799: p_rec.ipc_information11 :=
800: irc_ipc_shd.g_old_rec.ipc_information11;
801: End If;
802: If (p_rec.ipc_information12 = hr_api.g_varchar2) then
803: p_rec.ipc_information12 :=
804: irc_ipc_shd.g_old_rec.ipc_information12;
805: End If;
806: If (p_rec.ipc_information13 = hr_api.g_varchar2) then
802: If (p_rec.ipc_information12 = hr_api.g_varchar2) then
803: p_rec.ipc_information12 :=
804: irc_ipc_shd.g_old_rec.ipc_information12;
805: End If;
806: If (p_rec.ipc_information13 = hr_api.g_varchar2) then
807: p_rec.ipc_information13 :=
808: irc_ipc_shd.g_old_rec.ipc_information13;
809: End If;
810: If (p_rec.ipc_information14 = hr_api.g_varchar2) then
806: If (p_rec.ipc_information13 = hr_api.g_varchar2) then
807: p_rec.ipc_information13 :=
808: irc_ipc_shd.g_old_rec.ipc_information13;
809: End If;
810: If (p_rec.ipc_information14 = hr_api.g_varchar2) then
811: p_rec.ipc_information14 :=
812: irc_ipc_shd.g_old_rec.ipc_information14;
813: End If;
814: If (p_rec.ipc_information15 = hr_api.g_varchar2) then
810: If (p_rec.ipc_information14 = hr_api.g_varchar2) then
811: p_rec.ipc_information14 :=
812: irc_ipc_shd.g_old_rec.ipc_information14;
813: End If;
814: If (p_rec.ipc_information15 = hr_api.g_varchar2) then
815: p_rec.ipc_information15 :=
816: irc_ipc_shd.g_old_rec.ipc_information15;
817: End If;
818: If (p_rec.ipc_information16 = hr_api.g_varchar2) then
814: If (p_rec.ipc_information15 = hr_api.g_varchar2) then
815: p_rec.ipc_information15 :=
816: irc_ipc_shd.g_old_rec.ipc_information15;
817: End If;
818: If (p_rec.ipc_information16 = hr_api.g_varchar2) then
819: p_rec.ipc_information16 :=
820: irc_ipc_shd.g_old_rec.ipc_information16;
821: End If;
822: If (p_rec.ipc_information17 = hr_api.g_varchar2) then
818: If (p_rec.ipc_information16 = hr_api.g_varchar2) then
819: p_rec.ipc_information16 :=
820: irc_ipc_shd.g_old_rec.ipc_information16;
821: End If;
822: If (p_rec.ipc_information17 = hr_api.g_varchar2) then
823: p_rec.ipc_information17 :=
824: irc_ipc_shd.g_old_rec.ipc_information17;
825: End If;
826: If (p_rec.ipc_information18 = hr_api.g_varchar2) then
822: If (p_rec.ipc_information17 = hr_api.g_varchar2) then
823: p_rec.ipc_information17 :=
824: irc_ipc_shd.g_old_rec.ipc_information17;
825: End If;
826: If (p_rec.ipc_information18 = hr_api.g_varchar2) then
827: p_rec.ipc_information18 :=
828: irc_ipc_shd.g_old_rec.ipc_information18;
829: End If;
830: If (p_rec.ipc_information19 = hr_api.g_varchar2) then
826: If (p_rec.ipc_information18 = hr_api.g_varchar2) then
827: p_rec.ipc_information18 :=
828: irc_ipc_shd.g_old_rec.ipc_information18;
829: End If;
830: If (p_rec.ipc_information19 = hr_api.g_varchar2) then
831: p_rec.ipc_information19 :=
832: irc_ipc_shd.g_old_rec.ipc_information19;
833: End If;
834: If (p_rec.ipc_information20 = hr_api.g_varchar2) then
830: If (p_rec.ipc_information19 = hr_api.g_varchar2) then
831: p_rec.ipc_information19 :=
832: irc_ipc_shd.g_old_rec.ipc_information19;
833: End If;
834: If (p_rec.ipc_information20 = hr_api.g_varchar2) then
835: p_rec.ipc_information20 :=
836: irc_ipc_shd.g_old_rec.ipc_information20;
837: End If;
838: If (p_rec.ipc_information21 = hr_api.g_varchar2) then
834: If (p_rec.ipc_information20 = hr_api.g_varchar2) then
835: p_rec.ipc_information20 :=
836: irc_ipc_shd.g_old_rec.ipc_information20;
837: End If;
838: If (p_rec.ipc_information21 = hr_api.g_varchar2) then
839: p_rec.ipc_information21 :=
840: irc_ipc_shd.g_old_rec.ipc_information21;
841: End If;
842: If (p_rec.ipc_information22 = hr_api.g_varchar2) then
838: If (p_rec.ipc_information21 = hr_api.g_varchar2) then
839: p_rec.ipc_information21 :=
840: irc_ipc_shd.g_old_rec.ipc_information21;
841: End If;
842: If (p_rec.ipc_information22 = hr_api.g_varchar2) then
843: p_rec.ipc_information22 :=
844: irc_ipc_shd.g_old_rec.ipc_information22;
845: End If;
846: If (p_rec.ipc_information23 = hr_api.g_varchar2) then
842: If (p_rec.ipc_information22 = hr_api.g_varchar2) then
843: p_rec.ipc_information22 :=
844: irc_ipc_shd.g_old_rec.ipc_information22;
845: End If;
846: If (p_rec.ipc_information23 = hr_api.g_varchar2) then
847: p_rec.ipc_information23 :=
848: irc_ipc_shd.g_old_rec.ipc_information23;
849: End If;
850: If (p_rec.ipc_information24 = hr_api.g_varchar2) then
846: If (p_rec.ipc_information23 = hr_api.g_varchar2) then
847: p_rec.ipc_information23 :=
848: irc_ipc_shd.g_old_rec.ipc_information23;
849: End If;
850: If (p_rec.ipc_information24 = hr_api.g_varchar2) then
851: p_rec.ipc_information24 :=
852: irc_ipc_shd.g_old_rec.ipc_information24;
853: End If;
854: If (p_rec.ipc_information25 = hr_api.g_varchar2) then
850: If (p_rec.ipc_information24 = hr_api.g_varchar2) then
851: p_rec.ipc_information24 :=
852: irc_ipc_shd.g_old_rec.ipc_information24;
853: End If;
854: If (p_rec.ipc_information25 = hr_api.g_varchar2) then
855: p_rec.ipc_information25 :=
856: irc_ipc_shd.g_old_rec.ipc_information25;
857: End If;
858: If (p_rec.ipc_information26 = hr_api.g_varchar2) then
854: If (p_rec.ipc_information25 = hr_api.g_varchar2) then
855: p_rec.ipc_information25 :=
856: irc_ipc_shd.g_old_rec.ipc_information25;
857: End If;
858: If (p_rec.ipc_information26 = hr_api.g_varchar2) then
859: p_rec.ipc_information26 :=
860: irc_ipc_shd.g_old_rec.ipc_information26;
861: End If;
862: If (p_rec.ipc_information27 = hr_api.g_varchar2) then
858: If (p_rec.ipc_information26 = hr_api.g_varchar2) then
859: p_rec.ipc_information26 :=
860: irc_ipc_shd.g_old_rec.ipc_information26;
861: End If;
862: If (p_rec.ipc_information27 = hr_api.g_varchar2) then
863: p_rec.ipc_information27 :=
864: irc_ipc_shd.g_old_rec.ipc_information27;
865: End If;
866: If (p_rec.ipc_information28 = hr_api.g_varchar2) then
862: If (p_rec.ipc_information27 = hr_api.g_varchar2) then
863: p_rec.ipc_information27 :=
864: irc_ipc_shd.g_old_rec.ipc_information27;
865: End If;
866: If (p_rec.ipc_information28 = hr_api.g_varchar2) then
867: p_rec.ipc_information28 :=
868: irc_ipc_shd.g_old_rec.ipc_information28;
869: End If;
870: If (p_rec.ipc_information29 = hr_api.g_varchar2) then
866: If (p_rec.ipc_information28 = hr_api.g_varchar2) then
867: p_rec.ipc_information28 :=
868: irc_ipc_shd.g_old_rec.ipc_information28;
869: End If;
870: If (p_rec.ipc_information29 = hr_api.g_varchar2) then
871: p_rec.ipc_information29 :=
872: irc_ipc_shd.g_old_rec.ipc_information29;
873: End If;
874: If (p_rec.ipc_information30 = hr_api.g_varchar2) then
870: If (p_rec.ipc_information29 = hr_api.g_varchar2) then
871: p_rec.ipc_information29 :=
872: irc_ipc_shd.g_old_rec.ipc_information29;
873: End If;
874: If (p_rec.ipc_information30 = hr_api.g_varchar2) then
875: p_rec.ipc_information30 :=
876: irc_ipc_shd.g_old_rec.ipc_information30;
877: End If;
878: If (p_rec.date_approved = hr_api.g_date) then
874: If (p_rec.ipc_information30 = hr_api.g_varchar2) then
875: p_rec.ipc_information30 :=
876: irc_ipc_shd.g_old_rec.ipc_information30;
877: End If;
878: If (p_rec.date_approved = hr_api.g_date) then
879: p_rec.date_approved :=
880: irc_ipc_shd.g_old_rec.date_approved;
881: End If;
882: If (p_rec.recruiter_full_name = hr_api.g_varchar2) then
878: If (p_rec.date_approved = hr_api.g_date) then
879: p_rec.date_approved :=
880: irc_ipc_shd.g_old_rec.date_approved;
881: End If;
882: If (p_rec.recruiter_full_name = hr_api.g_varchar2) then
883: p_rec.recruiter_full_name :=
884: irc_ipc_shd.g_old_rec.recruiter_full_name;
885: End If;
886: If (p_rec.recruiter_email = hr_api.g_varchar2) then
882: If (p_rec.recruiter_full_name = hr_api.g_varchar2) then
883: p_rec.recruiter_full_name :=
884: irc_ipc_shd.g_old_rec.recruiter_full_name;
885: End If;
886: If (p_rec.recruiter_email = hr_api.g_varchar2) then
887: p_rec.recruiter_email :=
888: irc_ipc_shd.g_old_rec.recruiter_email;
889: End If;
890: If (p_rec.recruiter_work_telephone = hr_api.g_varchar2) then
886: If (p_rec.recruiter_email = hr_api.g_varchar2) then
887: p_rec.recruiter_email :=
888: irc_ipc_shd.g_old_rec.recruiter_email;
889: End If;
890: If (p_rec.recruiter_work_telephone = hr_api.g_varchar2) then
891: p_rec.recruiter_work_telephone :=
892: irc_ipc_shd.g_old_rec.recruiter_work_telephone;
893: End If;
894: If (p_rec.manager_full_name = hr_api.g_varchar2) then
890: If (p_rec.recruiter_work_telephone = hr_api.g_varchar2) then
891: p_rec.recruiter_work_telephone :=
892: irc_ipc_shd.g_old_rec.recruiter_work_telephone;
893: End If;
894: If (p_rec.manager_full_name = hr_api.g_varchar2) then
895: p_rec.manager_full_name :=
896: irc_ipc_shd.g_old_rec.manager_full_name;
897: End If;
898: If (p_rec.manager_email = hr_api.g_varchar2) then
894: If (p_rec.manager_full_name = hr_api.g_varchar2) then
895: p_rec.manager_full_name :=
896: irc_ipc_shd.g_old_rec.manager_full_name;
897: End If;
898: If (p_rec.manager_email = hr_api.g_varchar2) then
899: p_rec.manager_email :=
900: irc_ipc_shd.g_old_rec.manager_email;
901: End If;
902: If (p_rec.manager_work_telephone = hr_api.g_varchar2) then
898: If (p_rec.manager_email = hr_api.g_varchar2) then
899: p_rec.manager_email :=
900: irc_ipc_shd.g_old_rec.manager_email;
901: End If;
902: If (p_rec.manager_work_telephone = hr_api.g_varchar2) then
903: p_rec.manager_work_telephone :=
904: irc_ipc_shd.g_old_rec.manager_work_telephone;
905: End If;
906: --
956: -- ----------------------------------------------------------------------------
957: Procedure upd
958: (p_posting_content_id in number
959: ,p_object_version_number in out nocopy number
960: ,p_display_manager_info in varchar2 default hr_api.g_varchar2
961: ,p_display_recruiter_info in varchar2 default hr_api.g_varchar2
962: ,p_attribute_category in varchar2 default hr_api.g_varchar2
963: ,p_attribute1 in varchar2 default hr_api.g_varchar2
964: ,p_attribute2 in varchar2 default hr_api.g_varchar2
957: Procedure upd
958: (p_posting_content_id in number
959: ,p_object_version_number in out nocopy number
960: ,p_display_manager_info in varchar2 default hr_api.g_varchar2
961: ,p_display_recruiter_info in varchar2 default hr_api.g_varchar2
962: ,p_attribute_category in varchar2 default hr_api.g_varchar2
963: ,p_attribute1 in varchar2 default hr_api.g_varchar2
964: ,p_attribute2 in varchar2 default hr_api.g_varchar2
965: ,p_attribute3 in varchar2 default hr_api.g_varchar2
958: (p_posting_content_id in number
959: ,p_object_version_number in out nocopy number
960: ,p_display_manager_info in varchar2 default hr_api.g_varchar2
961: ,p_display_recruiter_info in varchar2 default hr_api.g_varchar2
962: ,p_attribute_category in varchar2 default hr_api.g_varchar2
963: ,p_attribute1 in varchar2 default hr_api.g_varchar2
964: ,p_attribute2 in varchar2 default hr_api.g_varchar2
965: ,p_attribute3 in varchar2 default hr_api.g_varchar2
966: ,p_attribute4 in varchar2 default hr_api.g_varchar2
959: ,p_object_version_number in out nocopy number
960: ,p_display_manager_info in varchar2 default hr_api.g_varchar2
961: ,p_display_recruiter_info in varchar2 default hr_api.g_varchar2
962: ,p_attribute_category in varchar2 default hr_api.g_varchar2
963: ,p_attribute1 in varchar2 default hr_api.g_varchar2
964: ,p_attribute2 in varchar2 default hr_api.g_varchar2
965: ,p_attribute3 in varchar2 default hr_api.g_varchar2
966: ,p_attribute4 in varchar2 default hr_api.g_varchar2
967: ,p_attribute5 in varchar2 default hr_api.g_varchar2
960: ,p_display_manager_info in varchar2 default hr_api.g_varchar2
961: ,p_display_recruiter_info in varchar2 default hr_api.g_varchar2
962: ,p_attribute_category in varchar2 default hr_api.g_varchar2
963: ,p_attribute1 in varchar2 default hr_api.g_varchar2
964: ,p_attribute2 in varchar2 default hr_api.g_varchar2
965: ,p_attribute3 in varchar2 default hr_api.g_varchar2
966: ,p_attribute4 in varchar2 default hr_api.g_varchar2
967: ,p_attribute5 in varchar2 default hr_api.g_varchar2
968: ,p_attribute6 in varchar2 default hr_api.g_varchar2
961: ,p_display_recruiter_info in varchar2 default hr_api.g_varchar2
962: ,p_attribute_category in varchar2 default hr_api.g_varchar2
963: ,p_attribute1 in varchar2 default hr_api.g_varchar2
964: ,p_attribute2 in varchar2 default hr_api.g_varchar2
965: ,p_attribute3 in varchar2 default hr_api.g_varchar2
966: ,p_attribute4 in varchar2 default hr_api.g_varchar2
967: ,p_attribute5 in varchar2 default hr_api.g_varchar2
968: ,p_attribute6 in varchar2 default hr_api.g_varchar2
969: ,p_attribute7 in varchar2 default hr_api.g_varchar2
962: ,p_attribute_category in varchar2 default hr_api.g_varchar2
963: ,p_attribute1 in varchar2 default hr_api.g_varchar2
964: ,p_attribute2 in varchar2 default hr_api.g_varchar2
965: ,p_attribute3 in varchar2 default hr_api.g_varchar2
966: ,p_attribute4 in varchar2 default hr_api.g_varchar2
967: ,p_attribute5 in varchar2 default hr_api.g_varchar2
968: ,p_attribute6 in varchar2 default hr_api.g_varchar2
969: ,p_attribute7 in varchar2 default hr_api.g_varchar2
970: ,p_attribute8 in varchar2 default hr_api.g_varchar2
963: ,p_attribute1 in varchar2 default hr_api.g_varchar2
964: ,p_attribute2 in varchar2 default hr_api.g_varchar2
965: ,p_attribute3 in varchar2 default hr_api.g_varchar2
966: ,p_attribute4 in varchar2 default hr_api.g_varchar2
967: ,p_attribute5 in varchar2 default hr_api.g_varchar2
968: ,p_attribute6 in varchar2 default hr_api.g_varchar2
969: ,p_attribute7 in varchar2 default hr_api.g_varchar2
970: ,p_attribute8 in varchar2 default hr_api.g_varchar2
971: ,p_attribute9 in varchar2 default hr_api.g_varchar2
964: ,p_attribute2 in varchar2 default hr_api.g_varchar2
965: ,p_attribute3 in varchar2 default hr_api.g_varchar2
966: ,p_attribute4 in varchar2 default hr_api.g_varchar2
967: ,p_attribute5 in varchar2 default hr_api.g_varchar2
968: ,p_attribute6 in varchar2 default hr_api.g_varchar2
969: ,p_attribute7 in varchar2 default hr_api.g_varchar2
970: ,p_attribute8 in varchar2 default hr_api.g_varchar2
971: ,p_attribute9 in varchar2 default hr_api.g_varchar2
972: ,p_attribute10 in varchar2 default hr_api.g_varchar2
965: ,p_attribute3 in varchar2 default hr_api.g_varchar2
966: ,p_attribute4 in varchar2 default hr_api.g_varchar2
967: ,p_attribute5 in varchar2 default hr_api.g_varchar2
968: ,p_attribute6 in varchar2 default hr_api.g_varchar2
969: ,p_attribute7 in varchar2 default hr_api.g_varchar2
970: ,p_attribute8 in varchar2 default hr_api.g_varchar2
971: ,p_attribute9 in varchar2 default hr_api.g_varchar2
972: ,p_attribute10 in varchar2 default hr_api.g_varchar2
973: ,p_attribute11 in varchar2 default hr_api.g_varchar2
966: ,p_attribute4 in varchar2 default hr_api.g_varchar2
967: ,p_attribute5 in varchar2 default hr_api.g_varchar2
968: ,p_attribute6 in varchar2 default hr_api.g_varchar2
969: ,p_attribute7 in varchar2 default hr_api.g_varchar2
970: ,p_attribute8 in varchar2 default hr_api.g_varchar2
971: ,p_attribute9 in varchar2 default hr_api.g_varchar2
972: ,p_attribute10 in varchar2 default hr_api.g_varchar2
973: ,p_attribute11 in varchar2 default hr_api.g_varchar2
974: ,p_attribute12 in varchar2 default hr_api.g_varchar2
967: ,p_attribute5 in varchar2 default hr_api.g_varchar2
968: ,p_attribute6 in varchar2 default hr_api.g_varchar2
969: ,p_attribute7 in varchar2 default hr_api.g_varchar2
970: ,p_attribute8 in varchar2 default hr_api.g_varchar2
971: ,p_attribute9 in varchar2 default hr_api.g_varchar2
972: ,p_attribute10 in varchar2 default hr_api.g_varchar2
973: ,p_attribute11 in varchar2 default hr_api.g_varchar2
974: ,p_attribute12 in varchar2 default hr_api.g_varchar2
975: ,p_attribute13 in varchar2 default hr_api.g_varchar2
968: ,p_attribute6 in varchar2 default hr_api.g_varchar2
969: ,p_attribute7 in varchar2 default hr_api.g_varchar2
970: ,p_attribute8 in varchar2 default hr_api.g_varchar2
971: ,p_attribute9 in varchar2 default hr_api.g_varchar2
972: ,p_attribute10 in varchar2 default hr_api.g_varchar2
973: ,p_attribute11 in varchar2 default hr_api.g_varchar2
974: ,p_attribute12 in varchar2 default hr_api.g_varchar2
975: ,p_attribute13 in varchar2 default hr_api.g_varchar2
976: ,p_attribute14 in varchar2 default hr_api.g_varchar2
969: ,p_attribute7 in varchar2 default hr_api.g_varchar2
970: ,p_attribute8 in varchar2 default hr_api.g_varchar2
971: ,p_attribute9 in varchar2 default hr_api.g_varchar2
972: ,p_attribute10 in varchar2 default hr_api.g_varchar2
973: ,p_attribute11 in varchar2 default hr_api.g_varchar2
974: ,p_attribute12 in varchar2 default hr_api.g_varchar2
975: ,p_attribute13 in varchar2 default hr_api.g_varchar2
976: ,p_attribute14 in varchar2 default hr_api.g_varchar2
977: ,p_attribute15 in varchar2 default hr_api.g_varchar2
970: ,p_attribute8 in varchar2 default hr_api.g_varchar2
971: ,p_attribute9 in varchar2 default hr_api.g_varchar2
972: ,p_attribute10 in varchar2 default hr_api.g_varchar2
973: ,p_attribute11 in varchar2 default hr_api.g_varchar2
974: ,p_attribute12 in varchar2 default hr_api.g_varchar2
975: ,p_attribute13 in varchar2 default hr_api.g_varchar2
976: ,p_attribute14 in varchar2 default hr_api.g_varchar2
977: ,p_attribute15 in varchar2 default hr_api.g_varchar2
978: ,p_attribute16 in varchar2 default hr_api.g_varchar2
971: ,p_attribute9 in varchar2 default hr_api.g_varchar2
972: ,p_attribute10 in varchar2 default hr_api.g_varchar2
973: ,p_attribute11 in varchar2 default hr_api.g_varchar2
974: ,p_attribute12 in varchar2 default hr_api.g_varchar2
975: ,p_attribute13 in varchar2 default hr_api.g_varchar2
976: ,p_attribute14 in varchar2 default hr_api.g_varchar2
977: ,p_attribute15 in varchar2 default hr_api.g_varchar2
978: ,p_attribute16 in varchar2 default hr_api.g_varchar2
979: ,p_attribute17 in varchar2 default hr_api.g_varchar2
972: ,p_attribute10 in varchar2 default hr_api.g_varchar2
973: ,p_attribute11 in varchar2 default hr_api.g_varchar2
974: ,p_attribute12 in varchar2 default hr_api.g_varchar2
975: ,p_attribute13 in varchar2 default hr_api.g_varchar2
976: ,p_attribute14 in varchar2 default hr_api.g_varchar2
977: ,p_attribute15 in varchar2 default hr_api.g_varchar2
978: ,p_attribute16 in varchar2 default hr_api.g_varchar2
979: ,p_attribute17 in varchar2 default hr_api.g_varchar2
980: ,p_attribute18 in varchar2 default hr_api.g_varchar2
973: ,p_attribute11 in varchar2 default hr_api.g_varchar2
974: ,p_attribute12 in varchar2 default hr_api.g_varchar2
975: ,p_attribute13 in varchar2 default hr_api.g_varchar2
976: ,p_attribute14 in varchar2 default hr_api.g_varchar2
977: ,p_attribute15 in varchar2 default hr_api.g_varchar2
978: ,p_attribute16 in varchar2 default hr_api.g_varchar2
979: ,p_attribute17 in varchar2 default hr_api.g_varchar2
980: ,p_attribute18 in varchar2 default hr_api.g_varchar2
981: ,p_attribute19 in varchar2 default hr_api.g_varchar2
974: ,p_attribute12 in varchar2 default hr_api.g_varchar2
975: ,p_attribute13 in varchar2 default hr_api.g_varchar2
976: ,p_attribute14 in varchar2 default hr_api.g_varchar2
977: ,p_attribute15 in varchar2 default hr_api.g_varchar2
978: ,p_attribute16 in varchar2 default hr_api.g_varchar2
979: ,p_attribute17 in varchar2 default hr_api.g_varchar2
980: ,p_attribute18 in varchar2 default hr_api.g_varchar2
981: ,p_attribute19 in varchar2 default hr_api.g_varchar2
982: ,p_attribute20 in varchar2 default hr_api.g_varchar2
975: ,p_attribute13 in varchar2 default hr_api.g_varchar2
976: ,p_attribute14 in varchar2 default hr_api.g_varchar2
977: ,p_attribute15 in varchar2 default hr_api.g_varchar2
978: ,p_attribute16 in varchar2 default hr_api.g_varchar2
979: ,p_attribute17 in varchar2 default hr_api.g_varchar2
980: ,p_attribute18 in varchar2 default hr_api.g_varchar2
981: ,p_attribute19 in varchar2 default hr_api.g_varchar2
982: ,p_attribute20 in varchar2 default hr_api.g_varchar2
983: ,p_attribute21 in varchar2 default hr_api.g_varchar2
976: ,p_attribute14 in varchar2 default hr_api.g_varchar2
977: ,p_attribute15 in varchar2 default hr_api.g_varchar2
978: ,p_attribute16 in varchar2 default hr_api.g_varchar2
979: ,p_attribute17 in varchar2 default hr_api.g_varchar2
980: ,p_attribute18 in varchar2 default hr_api.g_varchar2
981: ,p_attribute19 in varchar2 default hr_api.g_varchar2
982: ,p_attribute20 in varchar2 default hr_api.g_varchar2
983: ,p_attribute21 in varchar2 default hr_api.g_varchar2
984: ,p_attribute22 in varchar2 default hr_api.g_varchar2
977: ,p_attribute15 in varchar2 default hr_api.g_varchar2
978: ,p_attribute16 in varchar2 default hr_api.g_varchar2
979: ,p_attribute17 in varchar2 default hr_api.g_varchar2
980: ,p_attribute18 in varchar2 default hr_api.g_varchar2
981: ,p_attribute19 in varchar2 default hr_api.g_varchar2
982: ,p_attribute20 in varchar2 default hr_api.g_varchar2
983: ,p_attribute21 in varchar2 default hr_api.g_varchar2
984: ,p_attribute22 in varchar2 default hr_api.g_varchar2
985: ,p_attribute23 in varchar2 default hr_api.g_varchar2
978: ,p_attribute16 in varchar2 default hr_api.g_varchar2
979: ,p_attribute17 in varchar2 default hr_api.g_varchar2
980: ,p_attribute18 in varchar2 default hr_api.g_varchar2
981: ,p_attribute19 in varchar2 default hr_api.g_varchar2
982: ,p_attribute20 in varchar2 default hr_api.g_varchar2
983: ,p_attribute21 in varchar2 default hr_api.g_varchar2
984: ,p_attribute22 in varchar2 default hr_api.g_varchar2
985: ,p_attribute23 in varchar2 default hr_api.g_varchar2
986: ,p_attribute24 in varchar2 default hr_api.g_varchar2
979: ,p_attribute17 in varchar2 default hr_api.g_varchar2
980: ,p_attribute18 in varchar2 default hr_api.g_varchar2
981: ,p_attribute19 in varchar2 default hr_api.g_varchar2
982: ,p_attribute20 in varchar2 default hr_api.g_varchar2
983: ,p_attribute21 in varchar2 default hr_api.g_varchar2
984: ,p_attribute22 in varchar2 default hr_api.g_varchar2
985: ,p_attribute23 in varchar2 default hr_api.g_varchar2
986: ,p_attribute24 in varchar2 default hr_api.g_varchar2
987: ,p_attribute25 in varchar2 default hr_api.g_varchar2
980: ,p_attribute18 in varchar2 default hr_api.g_varchar2
981: ,p_attribute19 in varchar2 default hr_api.g_varchar2
982: ,p_attribute20 in varchar2 default hr_api.g_varchar2
983: ,p_attribute21 in varchar2 default hr_api.g_varchar2
984: ,p_attribute22 in varchar2 default hr_api.g_varchar2
985: ,p_attribute23 in varchar2 default hr_api.g_varchar2
986: ,p_attribute24 in varchar2 default hr_api.g_varchar2
987: ,p_attribute25 in varchar2 default hr_api.g_varchar2
988: ,p_attribute26 in varchar2 default hr_api.g_varchar2
981: ,p_attribute19 in varchar2 default hr_api.g_varchar2
982: ,p_attribute20 in varchar2 default hr_api.g_varchar2
983: ,p_attribute21 in varchar2 default hr_api.g_varchar2
984: ,p_attribute22 in varchar2 default hr_api.g_varchar2
985: ,p_attribute23 in varchar2 default hr_api.g_varchar2
986: ,p_attribute24 in varchar2 default hr_api.g_varchar2
987: ,p_attribute25 in varchar2 default hr_api.g_varchar2
988: ,p_attribute26 in varchar2 default hr_api.g_varchar2
989: ,p_attribute27 in varchar2 default hr_api.g_varchar2
982: ,p_attribute20 in varchar2 default hr_api.g_varchar2
983: ,p_attribute21 in varchar2 default hr_api.g_varchar2
984: ,p_attribute22 in varchar2 default hr_api.g_varchar2
985: ,p_attribute23 in varchar2 default hr_api.g_varchar2
986: ,p_attribute24 in varchar2 default hr_api.g_varchar2
987: ,p_attribute25 in varchar2 default hr_api.g_varchar2
988: ,p_attribute26 in varchar2 default hr_api.g_varchar2
989: ,p_attribute27 in varchar2 default hr_api.g_varchar2
990: ,p_attribute28 in varchar2 default hr_api.g_varchar2
983: ,p_attribute21 in varchar2 default hr_api.g_varchar2
984: ,p_attribute22 in varchar2 default hr_api.g_varchar2
985: ,p_attribute23 in varchar2 default hr_api.g_varchar2
986: ,p_attribute24 in varchar2 default hr_api.g_varchar2
987: ,p_attribute25 in varchar2 default hr_api.g_varchar2
988: ,p_attribute26 in varchar2 default hr_api.g_varchar2
989: ,p_attribute27 in varchar2 default hr_api.g_varchar2
990: ,p_attribute28 in varchar2 default hr_api.g_varchar2
991: ,p_attribute29 in varchar2 default hr_api.g_varchar2
984: ,p_attribute22 in varchar2 default hr_api.g_varchar2
985: ,p_attribute23 in varchar2 default hr_api.g_varchar2
986: ,p_attribute24 in varchar2 default hr_api.g_varchar2
987: ,p_attribute25 in varchar2 default hr_api.g_varchar2
988: ,p_attribute26 in varchar2 default hr_api.g_varchar2
989: ,p_attribute27 in varchar2 default hr_api.g_varchar2
990: ,p_attribute28 in varchar2 default hr_api.g_varchar2
991: ,p_attribute29 in varchar2 default hr_api.g_varchar2
992: ,p_attribute30 in varchar2 default hr_api.g_varchar2
985: ,p_attribute23 in varchar2 default hr_api.g_varchar2
986: ,p_attribute24 in varchar2 default hr_api.g_varchar2
987: ,p_attribute25 in varchar2 default hr_api.g_varchar2
988: ,p_attribute26 in varchar2 default hr_api.g_varchar2
989: ,p_attribute27 in varchar2 default hr_api.g_varchar2
990: ,p_attribute28 in varchar2 default hr_api.g_varchar2
991: ,p_attribute29 in varchar2 default hr_api.g_varchar2
992: ,p_attribute30 in varchar2 default hr_api.g_varchar2
993: ,p_ipc_information_category in varchar2 default hr_api.g_varchar2
986: ,p_attribute24 in varchar2 default hr_api.g_varchar2
987: ,p_attribute25 in varchar2 default hr_api.g_varchar2
988: ,p_attribute26 in varchar2 default hr_api.g_varchar2
989: ,p_attribute27 in varchar2 default hr_api.g_varchar2
990: ,p_attribute28 in varchar2 default hr_api.g_varchar2
991: ,p_attribute29 in varchar2 default hr_api.g_varchar2
992: ,p_attribute30 in varchar2 default hr_api.g_varchar2
993: ,p_ipc_information_category in varchar2 default hr_api.g_varchar2
994: ,p_ipc_information1 in varchar2 default hr_api.g_varchar2
987: ,p_attribute25 in varchar2 default hr_api.g_varchar2
988: ,p_attribute26 in varchar2 default hr_api.g_varchar2
989: ,p_attribute27 in varchar2 default hr_api.g_varchar2
990: ,p_attribute28 in varchar2 default hr_api.g_varchar2
991: ,p_attribute29 in varchar2 default hr_api.g_varchar2
992: ,p_attribute30 in varchar2 default hr_api.g_varchar2
993: ,p_ipc_information_category in varchar2 default hr_api.g_varchar2
994: ,p_ipc_information1 in varchar2 default hr_api.g_varchar2
995: ,p_ipc_information2 in varchar2 default hr_api.g_varchar2
988: ,p_attribute26 in varchar2 default hr_api.g_varchar2
989: ,p_attribute27 in varchar2 default hr_api.g_varchar2
990: ,p_attribute28 in varchar2 default hr_api.g_varchar2
991: ,p_attribute29 in varchar2 default hr_api.g_varchar2
992: ,p_attribute30 in varchar2 default hr_api.g_varchar2
993: ,p_ipc_information_category in varchar2 default hr_api.g_varchar2
994: ,p_ipc_information1 in varchar2 default hr_api.g_varchar2
995: ,p_ipc_information2 in varchar2 default hr_api.g_varchar2
996: ,p_ipc_information3 in varchar2 default hr_api.g_varchar2
989: ,p_attribute27 in varchar2 default hr_api.g_varchar2
990: ,p_attribute28 in varchar2 default hr_api.g_varchar2
991: ,p_attribute29 in varchar2 default hr_api.g_varchar2
992: ,p_attribute30 in varchar2 default hr_api.g_varchar2
993: ,p_ipc_information_category in varchar2 default hr_api.g_varchar2
994: ,p_ipc_information1 in varchar2 default hr_api.g_varchar2
995: ,p_ipc_information2 in varchar2 default hr_api.g_varchar2
996: ,p_ipc_information3 in varchar2 default hr_api.g_varchar2
997: ,p_ipc_information4 in varchar2 default hr_api.g_varchar2
990: ,p_attribute28 in varchar2 default hr_api.g_varchar2
991: ,p_attribute29 in varchar2 default hr_api.g_varchar2
992: ,p_attribute30 in varchar2 default hr_api.g_varchar2
993: ,p_ipc_information_category in varchar2 default hr_api.g_varchar2
994: ,p_ipc_information1 in varchar2 default hr_api.g_varchar2
995: ,p_ipc_information2 in varchar2 default hr_api.g_varchar2
996: ,p_ipc_information3 in varchar2 default hr_api.g_varchar2
997: ,p_ipc_information4 in varchar2 default hr_api.g_varchar2
998: ,p_ipc_information5 in varchar2 default hr_api.g_varchar2
991: ,p_attribute29 in varchar2 default hr_api.g_varchar2
992: ,p_attribute30 in varchar2 default hr_api.g_varchar2
993: ,p_ipc_information_category in varchar2 default hr_api.g_varchar2
994: ,p_ipc_information1 in varchar2 default hr_api.g_varchar2
995: ,p_ipc_information2 in varchar2 default hr_api.g_varchar2
996: ,p_ipc_information3 in varchar2 default hr_api.g_varchar2
997: ,p_ipc_information4 in varchar2 default hr_api.g_varchar2
998: ,p_ipc_information5 in varchar2 default hr_api.g_varchar2
999: ,p_ipc_information6 in varchar2 default hr_api.g_varchar2
992: ,p_attribute30 in varchar2 default hr_api.g_varchar2
993: ,p_ipc_information_category in varchar2 default hr_api.g_varchar2
994: ,p_ipc_information1 in varchar2 default hr_api.g_varchar2
995: ,p_ipc_information2 in varchar2 default hr_api.g_varchar2
996: ,p_ipc_information3 in varchar2 default hr_api.g_varchar2
997: ,p_ipc_information4 in varchar2 default hr_api.g_varchar2
998: ,p_ipc_information5 in varchar2 default hr_api.g_varchar2
999: ,p_ipc_information6 in varchar2 default hr_api.g_varchar2
1000: ,p_ipc_information7 in varchar2 default hr_api.g_varchar2
993: ,p_ipc_information_category in varchar2 default hr_api.g_varchar2
994: ,p_ipc_information1 in varchar2 default hr_api.g_varchar2
995: ,p_ipc_information2 in varchar2 default hr_api.g_varchar2
996: ,p_ipc_information3 in varchar2 default hr_api.g_varchar2
997: ,p_ipc_information4 in varchar2 default hr_api.g_varchar2
998: ,p_ipc_information5 in varchar2 default hr_api.g_varchar2
999: ,p_ipc_information6 in varchar2 default hr_api.g_varchar2
1000: ,p_ipc_information7 in varchar2 default hr_api.g_varchar2
1001: ,p_ipc_information8 in varchar2 default hr_api.g_varchar2
994: ,p_ipc_information1 in varchar2 default hr_api.g_varchar2
995: ,p_ipc_information2 in varchar2 default hr_api.g_varchar2
996: ,p_ipc_information3 in varchar2 default hr_api.g_varchar2
997: ,p_ipc_information4 in varchar2 default hr_api.g_varchar2
998: ,p_ipc_information5 in varchar2 default hr_api.g_varchar2
999: ,p_ipc_information6 in varchar2 default hr_api.g_varchar2
1000: ,p_ipc_information7 in varchar2 default hr_api.g_varchar2
1001: ,p_ipc_information8 in varchar2 default hr_api.g_varchar2
1002: ,p_ipc_information9 in varchar2 default hr_api.g_varchar2
995: ,p_ipc_information2 in varchar2 default hr_api.g_varchar2
996: ,p_ipc_information3 in varchar2 default hr_api.g_varchar2
997: ,p_ipc_information4 in varchar2 default hr_api.g_varchar2
998: ,p_ipc_information5 in varchar2 default hr_api.g_varchar2
999: ,p_ipc_information6 in varchar2 default hr_api.g_varchar2
1000: ,p_ipc_information7 in varchar2 default hr_api.g_varchar2
1001: ,p_ipc_information8 in varchar2 default hr_api.g_varchar2
1002: ,p_ipc_information9 in varchar2 default hr_api.g_varchar2
1003: ,p_ipc_information10 in varchar2 default hr_api.g_varchar2
996: ,p_ipc_information3 in varchar2 default hr_api.g_varchar2
997: ,p_ipc_information4 in varchar2 default hr_api.g_varchar2
998: ,p_ipc_information5 in varchar2 default hr_api.g_varchar2
999: ,p_ipc_information6 in varchar2 default hr_api.g_varchar2
1000: ,p_ipc_information7 in varchar2 default hr_api.g_varchar2
1001: ,p_ipc_information8 in varchar2 default hr_api.g_varchar2
1002: ,p_ipc_information9 in varchar2 default hr_api.g_varchar2
1003: ,p_ipc_information10 in varchar2 default hr_api.g_varchar2
1004: ,p_ipc_information11 in varchar2 default hr_api.g_varchar2
997: ,p_ipc_information4 in varchar2 default hr_api.g_varchar2
998: ,p_ipc_information5 in varchar2 default hr_api.g_varchar2
999: ,p_ipc_information6 in varchar2 default hr_api.g_varchar2
1000: ,p_ipc_information7 in varchar2 default hr_api.g_varchar2
1001: ,p_ipc_information8 in varchar2 default hr_api.g_varchar2
1002: ,p_ipc_information9 in varchar2 default hr_api.g_varchar2
1003: ,p_ipc_information10 in varchar2 default hr_api.g_varchar2
1004: ,p_ipc_information11 in varchar2 default hr_api.g_varchar2
1005: ,p_ipc_information12 in varchar2 default hr_api.g_varchar2
998: ,p_ipc_information5 in varchar2 default hr_api.g_varchar2
999: ,p_ipc_information6 in varchar2 default hr_api.g_varchar2
1000: ,p_ipc_information7 in varchar2 default hr_api.g_varchar2
1001: ,p_ipc_information8 in varchar2 default hr_api.g_varchar2
1002: ,p_ipc_information9 in varchar2 default hr_api.g_varchar2
1003: ,p_ipc_information10 in varchar2 default hr_api.g_varchar2
1004: ,p_ipc_information11 in varchar2 default hr_api.g_varchar2
1005: ,p_ipc_information12 in varchar2 default hr_api.g_varchar2
1006: ,p_ipc_information13 in varchar2 default hr_api.g_varchar2
999: ,p_ipc_information6 in varchar2 default hr_api.g_varchar2
1000: ,p_ipc_information7 in varchar2 default hr_api.g_varchar2
1001: ,p_ipc_information8 in varchar2 default hr_api.g_varchar2
1002: ,p_ipc_information9 in varchar2 default hr_api.g_varchar2
1003: ,p_ipc_information10 in varchar2 default hr_api.g_varchar2
1004: ,p_ipc_information11 in varchar2 default hr_api.g_varchar2
1005: ,p_ipc_information12 in varchar2 default hr_api.g_varchar2
1006: ,p_ipc_information13 in varchar2 default hr_api.g_varchar2
1007: ,p_ipc_information14 in varchar2 default hr_api.g_varchar2
1000: ,p_ipc_information7 in varchar2 default hr_api.g_varchar2
1001: ,p_ipc_information8 in varchar2 default hr_api.g_varchar2
1002: ,p_ipc_information9 in varchar2 default hr_api.g_varchar2
1003: ,p_ipc_information10 in varchar2 default hr_api.g_varchar2
1004: ,p_ipc_information11 in varchar2 default hr_api.g_varchar2
1005: ,p_ipc_information12 in varchar2 default hr_api.g_varchar2
1006: ,p_ipc_information13 in varchar2 default hr_api.g_varchar2
1007: ,p_ipc_information14 in varchar2 default hr_api.g_varchar2
1008: ,p_ipc_information15 in varchar2 default hr_api.g_varchar2
1001: ,p_ipc_information8 in varchar2 default hr_api.g_varchar2
1002: ,p_ipc_information9 in varchar2 default hr_api.g_varchar2
1003: ,p_ipc_information10 in varchar2 default hr_api.g_varchar2
1004: ,p_ipc_information11 in varchar2 default hr_api.g_varchar2
1005: ,p_ipc_information12 in varchar2 default hr_api.g_varchar2
1006: ,p_ipc_information13 in varchar2 default hr_api.g_varchar2
1007: ,p_ipc_information14 in varchar2 default hr_api.g_varchar2
1008: ,p_ipc_information15 in varchar2 default hr_api.g_varchar2
1009: ,p_ipc_information16 in varchar2 default hr_api.g_varchar2
1002: ,p_ipc_information9 in varchar2 default hr_api.g_varchar2
1003: ,p_ipc_information10 in varchar2 default hr_api.g_varchar2
1004: ,p_ipc_information11 in varchar2 default hr_api.g_varchar2
1005: ,p_ipc_information12 in varchar2 default hr_api.g_varchar2
1006: ,p_ipc_information13 in varchar2 default hr_api.g_varchar2
1007: ,p_ipc_information14 in varchar2 default hr_api.g_varchar2
1008: ,p_ipc_information15 in varchar2 default hr_api.g_varchar2
1009: ,p_ipc_information16 in varchar2 default hr_api.g_varchar2
1010: ,p_ipc_information17 in varchar2 default hr_api.g_varchar2
1003: ,p_ipc_information10 in varchar2 default hr_api.g_varchar2
1004: ,p_ipc_information11 in varchar2 default hr_api.g_varchar2
1005: ,p_ipc_information12 in varchar2 default hr_api.g_varchar2
1006: ,p_ipc_information13 in varchar2 default hr_api.g_varchar2
1007: ,p_ipc_information14 in varchar2 default hr_api.g_varchar2
1008: ,p_ipc_information15 in varchar2 default hr_api.g_varchar2
1009: ,p_ipc_information16 in varchar2 default hr_api.g_varchar2
1010: ,p_ipc_information17 in varchar2 default hr_api.g_varchar2
1011: ,p_ipc_information18 in varchar2 default hr_api.g_varchar2
1004: ,p_ipc_information11 in varchar2 default hr_api.g_varchar2
1005: ,p_ipc_information12 in varchar2 default hr_api.g_varchar2
1006: ,p_ipc_information13 in varchar2 default hr_api.g_varchar2
1007: ,p_ipc_information14 in varchar2 default hr_api.g_varchar2
1008: ,p_ipc_information15 in varchar2 default hr_api.g_varchar2
1009: ,p_ipc_information16 in varchar2 default hr_api.g_varchar2
1010: ,p_ipc_information17 in varchar2 default hr_api.g_varchar2
1011: ,p_ipc_information18 in varchar2 default hr_api.g_varchar2
1012: ,p_ipc_information19 in varchar2 default hr_api.g_varchar2
1005: ,p_ipc_information12 in varchar2 default hr_api.g_varchar2
1006: ,p_ipc_information13 in varchar2 default hr_api.g_varchar2
1007: ,p_ipc_information14 in varchar2 default hr_api.g_varchar2
1008: ,p_ipc_information15 in varchar2 default hr_api.g_varchar2
1009: ,p_ipc_information16 in varchar2 default hr_api.g_varchar2
1010: ,p_ipc_information17 in varchar2 default hr_api.g_varchar2
1011: ,p_ipc_information18 in varchar2 default hr_api.g_varchar2
1012: ,p_ipc_information19 in varchar2 default hr_api.g_varchar2
1013: ,p_ipc_information20 in varchar2 default hr_api.g_varchar2
1006: ,p_ipc_information13 in varchar2 default hr_api.g_varchar2
1007: ,p_ipc_information14 in varchar2 default hr_api.g_varchar2
1008: ,p_ipc_information15 in varchar2 default hr_api.g_varchar2
1009: ,p_ipc_information16 in varchar2 default hr_api.g_varchar2
1010: ,p_ipc_information17 in varchar2 default hr_api.g_varchar2
1011: ,p_ipc_information18 in varchar2 default hr_api.g_varchar2
1012: ,p_ipc_information19 in varchar2 default hr_api.g_varchar2
1013: ,p_ipc_information20 in varchar2 default hr_api.g_varchar2
1014: ,p_ipc_information21 in varchar2 default hr_api.g_varchar2
1007: ,p_ipc_information14 in varchar2 default hr_api.g_varchar2
1008: ,p_ipc_information15 in varchar2 default hr_api.g_varchar2
1009: ,p_ipc_information16 in varchar2 default hr_api.g_varchar2
1010: ,p_ipc_information17 in varchar2 default hr_api.g_varchar2
1011: ,p_ipc_information18 in varchar2 default hr_api.g_varchar2
1012: ,p_ipc_information19 in varchar2 default hr_api.g_varchar2
1013: ,p_ipc_information20 in varchar2 default hr_api.g_varchar2
1014: ,p_ipc_information21 in varchar2 default hr_api.g_varchar2
1015: ,p_ipc_information22 in varchar2 default hr_api.g_varchar2
1008: ,p_ipc_information15 in varchar2 default hr_api.g_varchar2
1009: ,p_ipc_information16 in varchar2 default hr_api.g_varchar2
1010: ,p_ipc_information17 in varchar2 default hr_api.g_varchar2
1011: ,p_ipc_information18 in varchar2 default hr_api.g_varchar2
1012: ,p_ipc_information19 in varchar2 default hr_api.g_varchar2
1013: ,p_ipc_information20 in varchar2 default hr_api.g_varchar2
1014: ,p_ipc_information21 in varchar2 default hr_api.g_varchar2
1015: ,p_ipc_information22 in varchar2 default hr_api.g_varchar2
1016: ,p_ipc_information23 in varchar2 default hr_api.g_varchar2
1009: ,p_ipc_information16 in varchar2 default hr_api.g_varchar2
1010: ,p_ipc_information17 in varchar2 default hr_api.g_varchar2
1011: ,p_ipc_information18 in varchar2 default hr_api.g_varchar2
1012: ,p_ipc_information19 in varchar2 default hr_api.g_varchar2
1013: ,p_ipc_information20 in varchar2 default hr_api.g_varchar2
1014: ,p_ipc_information21 in varchar2 default hr_api.g_varchar2
1015: ,p_ipc_information22 in varchar2 default hr_api.g_varchar2
1016: ,p_ipc_information23 in varchar2 default hr_api.g_varchar2
1017: ,p_ipc_information24 in varchar2 default hr_api.g_varchar2
1010: ,p_ipc_information17 in varchar2 default hr_api.g_varchar2
1011: ,p_ipc_information18 in varchar2 default hr_api.g_varchar2
1012: ,p_ipc_information19 in varchar2 default hr_api.g_varchar2
1013: ,p_ipc_information20 in varchar2 default hr_api.g_varchar2
1014: ,p_ipc_information21 in varchar2 default hr_api.g_varchar2
1015: ,p_ipc_information22 in varchar2 default hr_api.g_varchar2
1016: ,p_ipc_information23 in varchar2 default hr_api.g_varchar2
1017: ,p_ipc_information24 in varchar2 default hr_api.g_varchar2
1018: ,p_ipc_information25 in varchar2 default hr_api.g_varchar2
1011: ,p_ipc_information18 in varchar2 default hr_api.g_varchar2
1012: ,p_ipc_information19 in varchar2 default hr_api.g_varchar2
1013: ,p_ipc_information20 in varchar2 default hr_api.g_varchar2
1014: ,p_ipc_information21 in varchar2 default hr_api.g_varchar2
1015: ,p_ipc_information22 in varchar2 default hr_api.g_varchar2
1016: ,p_ipc_information23 in varchar2 default hr_api.g_varchar2
1017: ,p_ipc_information24 in varchar2 default hr_api.g_varchar2
1018: ,p_ipc_information25 in varchar2 default hr_api.g_varchar2
1019: ,p_ipc_information26 in varchar2 default hr_api.g_varchar2
1012: ,p_ipc_information19 in varchar2 default hr_api.g_varchar2
1013: ,p_ipc_information20 in varchar2 default hr_api.g_varchar2
1014: ,p_ipc_information21 in varchar2 default hr_api.g_varchar2
1015: ,p_ipc_information22 in varchar2 default hr_api.g_varchar2
1016: ,p_ipc_information23 in varchar2 default hr_api.g_varchar2
1017: ,p_ipc_information24 in varchar2 default hr_api.g_varchar2
1018: ,p_ipc_information25 in varchar2 default hr_api.g_varchar2
1019: ,p_ipc_information26 in varchar2 default hr_api.g_varchar2
1020: ,p_ipc_information27 in varchar2 default hr_api.g_varchar2
1013: ,p_ipc_information20 in varchar2 default hr_api.g_varchar2
1014: ,p_ipc_information21 in varchar2 default hr_api.g_varchar2
1015: ,p_ipc_information22 in varchar2 default hr_api.g_varchar2
1016: ,p_ipc_information23 in varchar2 default hr_api.g_varchar2
1017: ,p_ipc_information24 in varchar2 default hr_api.g_varchar2
1018: ,p_ipc_information25 in varchar2 default hr_api.g_varchar2
1019: ,p_ipc_information26 in varchar2 default hr_api.g_varchar2
1020: ,p_ipc_information27 in varchar2 default hr_api.g_varchar2
1021: ,p_ipc_information28 in varchar2 default hr_api.g_varchar2
1014: ,p_ipc_information21 in varchar2 default hr_api.g_varchar2
1015: ,p_ipc_information22 in varchar2 default hr_api.g_varchar2
1016: ,p_ipc_information23 in varchar2 default hr_api.g_varchar2
1017: ,p_ipc_information24 in varchar2 default hr_api.g_varchar2
1018: ,p_ipc_information25 in varchar2 default hr_api.g_varchar2
1019: ,p_ipc_information26 in varchar2 default hr_api.g_varchar2
1020: ,p_ipc_information27 in varchar2 default hr_api.g_varchar2
1021: ,p_ipc_information28 in varchar2 default hr_api.g_varchar2
1022: ,p_ipc_information29 in varchar2 default hr_api.g_varchar2
1015: ,p_ipc_information22 in varchar2 default hr_api.g_varchar2
1016: ,p_ipc_information23 in varchar2 default hr_api.g_varchar2
1017: ,p_ipc_information24 in varchar2 default hr_api.g_varchar2
1018: ,p_ipc_information25 in varchar2 default hr_api.g_varchar2
1019: ,p_ipc_information26 in varchar2 default hr_api.g_varchar2
1020: ,p_ipc_information27 in varchar2 default hr_api.g_varchar2
1021: ,p_ipc_information28 in varchar2 default hr_api.g_varchar2
1022: ,p_ipc_information29 in varchar2 default hr_api.g_varchar2
1023: ,p_ipc_information30 in varchar2 default hr_api.g_varchar2
1016: ,p_ipc_information23 in varchar2 default hr_api.g_varchar2
1017: ,p_ipc_information24 in varchar2 default hr_api.g_varchar2
1018: ,p_ipc_information25 in varchar2 default hr_api.g_varchar2
1019: ,p_ipc_information26 in varchar2 default hr_api.g_varchar2
1020: ,p_ipc_information27 in varchar2 default hr_api.g_varchar2
1021: ,p_ipc_information28 in varchar2 default hr_api.g_varchar2
1022: ,p_ipc_information29 in varchar2 default hr_api.g_varchar2
1023: ,p_ipc_information30 in varchar2 default hr_api.g_varchar2
1024: ,p_date_approved in date default hr_api.g_date
1017: ,p_ipc_information24 in varchar2 default hr_api.g_varchar2
1018: ,p_ipc_information25 in varchar2 default hr_api.g_varchar2
1019: ,p_ipc_information26 in varchar2 default hr_api.g_varchar2
1020: ,p_ipc_information27 in varchar2 default hr_api.g_varchar2
1021: ,p_ipc_information28 in varchar2 default hr_api.g_varchar2
1022: ,p_ipc_information29 in varchar2 default hr_api.g_varchar2
1023: ,p_ipc_information30 in varchar2 default hr_api.g_varchar2
1024: ,p_date_approved in date default hr_api.g_date
1025: ,p_recruiter_full_name in varchar2 default hr_api.g_varchar2
1018: ,p_ipc_information25 in varchar2 default hr_api.g_varchar2
1019: ,p_ipc_information26 in varchar2 default hr_api.g_varchar2
1020: ,p_ipc_information27 in varchar2 default hr_api.g_varchar2
1021: ,p_ipc_information28 in varchar2 default hr_api.g_varchar2
1022: ,p_ipc_information29 in varchar2 default hr_api.g_varchar2
1023: ,p_ipc_information30 in varchar2 default hr_api.g_varchar2
1024: ,p_date_approved in date default hr_api.g_date
1025: ,p_recruiter_full_name in varchar2 default hr_api.g_varchar2
1026: ,p_recruiter_email in varchar2 default hr_api.g_varchar2
1019: ,p_ipc_information26 in varchar2 default hr_api.g_varchar2
1020: ,p_ipc_information27 in varchar2 default hr_api.g_varchar2
1021: ,p_ipc_information28 in varchar2 default hr_api.g_varchar2
1022: ,p_ipc_information29 in varchar2 default hr_api.g_varchar2
1023: ,p_ipc_information30 in varchar2 default hr_api.g_varchar2
1024: ,p_date_approved in date default hr_api.g_date
1025: ,p_recruiter_full_name in varchar2 default hr_api.g_varchar2
1026: ,p_recruiter_email in varchar2 default hr_api.g_varchar2
1027: ,p_recruiter_work_telephone in varchar2 default hr_api.g_varchar2
1020: ,p_ipc_information27 in varchar2 default hr_api.g_varchar2
1021: ,p_ipc_information28 in varchar2 default hr_api.g_varchar2
1022: ,p_ipc_information29 in varchar2 default hr_api.g_varchar2
1023: ,p_ipc_information30 in varchar2 default hr_api.g_varchar2
1024: ,p_date_approved in date default hr_api.g_date
1025: ,p_recruiter_full_name in varchar2 default hr_api.g_varchar2
1026: ,p_recruiter_email in varchar2 default hr_api.g_varchar2
1027: ,p_recruiter_work_telephone in varchar2 default hr_api.g_varchar2
1028: ,p_manager_full_name in varchar2 default hr_api.g_varchar2
1021: ,p_ipc_information28 in varchar2 default hr_api.g_varchar2
1022: ,p_ipc_information29 in varchar2 default hr_api.g_varchar2
1023: ,p_ipc_information30 in varchar2 default hr_api.g_varchar2
1024: ,p_date_approved in date default hr_api.g_date
1025: ,p_recruiter_full_name in varchar2 default hr_api.g_varchar2
1026: ,p_recruiter_email in varchar2 default hr_api.g_varchar2
1027: ,p_recruiter_work_telephone in varchar2 default hr_api.g_varchar2
1028: ,p_manager_full_name in varchar2 default hr_api.g_varchar2
1029: ,p_manager_email in varchar2 default hr_api.g_varchar2
1022: ,p_ipc_information29 in varchar2 default hr_api.g_varchar2
1023: ,p_ipc_information30 in varchar2 default hr_api.g_varchar2
1024: ,p_date_approved in date default hr_api.g_date
1025: ,p_recruiter_full_name in varchar2 default hr_api.g_varchar2
1026: ,p_recruiter_email in varchar2 default hr_api.g_varchar2
1027: ,p_recruiter_work_telephone in varchar2 default hr_api.g_varchar2
1028: ,p_manager_full_name in varchar2 default hr_api.g_varchar2
1029: ,p_manager_email in varchar2 default hr_api.g_varchar2
1030: ,p_manager_work_telephone in varchar2 default hr_api.g_varchar2
1023: ,p_ipc_information30 in varchar2 default hr_api.g_varchar2
1024: ,p_date_approved in date default hr_api.g_date
1025: ,p_recruiter_full_name in varchar2 default hr_api.g_varchar2
1026: ,p_recruiter_email in varchar2 default hr_api.g_varchar2
1027: ,p_recruiter_work_telephone in varchar2 default hr_api.g_varchar2
1028: ,p_manager_full_name in varchar2 default hr_api.g_varchar2
1029: ,p_manager_email in varchar2 default hr_api.g_varchar2
1030: ,p_manager_work_telephone in varchar2 default hr_api.g_varchar2
1031: ) is
1024: ,p_date_approved in date default hr_api.g_date
1025: ,p_recruiter_full_name in varchar2 default hr_api.g_varchar2
1026: ,p_recruiter_email in varchar2 default hr_api.g_varchar2
1027: ,p_recruiter_work_telephone in varchar2 default hr_api.g_varchar2
1028: ,p_manager_full_name in varchar2 default hr_api.g_varchar2
1029: ,p_manager_email in varchar2 default hr_api.g_varchar2
1030: ,p_manager_work_telephone in varchar2 default hr_api.g_varchar2
1031: ) is
1032: --
1025: ,p_recruiter_full_name in varchar2 default hr_api.g_varchar2
1026: ,p_recruiter_email in varchar2 default hr_api.g_varchar2
1027: ,p_recruiter_work_telephone in varchar2 default hr_api.g_varchar2
1028: ,p_manager_full_name in varchar2 default hr_api.g_varchar2
1029: ,p_manager_email in varchar2 default hr_api.g_varchar2
1030: ,p_manager_work_telephone in varchar2 default hr_api.g_varchar2
1031: ) is
1032: --
1033: l_rec irc_ipc_shd.g_rec_type;
1026: ,p_recruiter_email in varchar2 default hr_api.g_varchar2
1027: ,p_recruiter_work_telephone in varchar2 default hr_api.g_varchar2
1028: ,p_manager_full_name in varchar2 default hr_api.g_varchar2
1029: ,p_manager_email in varchar2 default hr_api.g_varchar2
1030: ,p_manager_work_telephone in varchar2 default hr_api.g_varchar2
1031: ) is
1032: --
1033: l_rec irc_ipc_shd.g_rec_type;
1034: l_proc varchar2(72) := g_package||'upd';