DBA Data[Home] [Help]

APPS.IRC_IPC_UPD dependencies on HR_API

Line 152: When hr_api.check_integrity_violated Then

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

Line 157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 158: When hr_api.parent_integrity_violated Then

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

Line 163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 164: When hr_api.unique_integrity_violated Then

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

Line 169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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;

Line 557: when hr_api.cannot_find_prog_unit then

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

Line 559: hr_api.cannot_find_prog_unit_error

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;

Line 622: If (p_rec.display_manager_info = hr_api.g_varchar2) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 960: ,p_display_manager_info in varchar2 default hr_api.g_varchar2

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

Line 961: ,p_display_recruiter_info 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

Line 962: ,p_attribute_category 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

Line 963: ,p_attribute1 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

Line 964: ,p_attribute2 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

Line 965: ,p_attribute3 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

Line 966: ,p_attribute4 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

Line 967: ,p_attribute5 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

Line 968: ,p_attribute6 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

Line 969: ,p_attribute7 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

Line 970: ,p_attribute8 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

Line 971: ,p_attribute9 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

Line 972: ,p_attribute10 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

Line 973: ,p_attribute11 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

Line 974: ,p_attribute12 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

Line 975: ,p_attribute13 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

Line 976: ,p_attribute14 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

Line 977: ,p_attribute15 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

Line 978: ,p_attribute16 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

Line 979: ,p_attribute17 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

Line 980: ,p_attribute18 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

Line 981: ,p_attribute19 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

Line 982: ,p_attribute20 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

Line 983: ,p_attribute21 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

Line 984: ,p_attribute22 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

Line 985: ,p_attribute23 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

Line 986: ,p_attribute24 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

Line 987: ,p_attribute25 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

Line 988: ,p_attribute26 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

Line 989: ,p_attribute27 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

Line 990: ,p_attribute28 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

Line 991: ,p_attribute29 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

Line 992: ,p_attribute30 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

Line 993: ,p_ipc_information_category 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

Line 994: ,p_ipc_information1 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

Line 995: ,p_ipc_information2 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

Line 996: ,p_ipc_information3 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

Line 997: ,p_ipc_information4 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

Line 998: ,p_ipc_information5 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

Line 999: ,p_ipc_information6 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

Line 1000: ,p_ipc_information7 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

Line 1001: ,p_ipc_information8 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

Line 1002: ,p_ipc_information9 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

Line 1003: ,p_ipc_information10 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

Line 1004: ,p_ipc_information11 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

Line 1005: ,p_ipc_information12 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

Line 1006: ,p_ipc_information13 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

Line 1007: ,p_ipc_information14 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

Line 1008: ,p_ipc_information15 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

Line 1009: ,p_ipc_information16 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

Line 1010: ,p_ipc_information17 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

Line 1011: ,p_ipc_information18 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

Line 1012: ,p_ipc_information19 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

Line 1013: ,p_ipc_information20 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

Line 1014: ,p_ipc_information21 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

Line 1015: ,p_ipc_information22 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

Line 1016: ,p_ipc_information23 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

Line 1017: ,p_ipc_information24 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

Line 1018: ,p_ipc_information25 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

Line 1019: ,p_ipc_information26 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

Line 1020: ,p_ipc_information27 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

Line 1021: ,p_ipc_information28 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
1025: ,p_recruiter_full_name in varchar2 default hr_api.g_varchar2

Line 1022: ,p_ipc_information29 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

Line 1023: ,p_ipc_information30 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

Line 1024: ,p_date_approved in date default hr_api.g_date

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

Line 1025: ,p_recruiter_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

Line 1026: ,p_recruiter_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

Line 1027: ,p_recruiter_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

Line 1028: ,p_manager_full_name 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
1032: --

Line 1029: ,p_manager_email in varchar2 default hr_api.g_varchar2

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;

Line 1030: ,p_manager_work_telephone 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;
1034: l_proc varchar2(72) := g_package||'upd';