APPS.PER_SPS_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 144: When hr_api.check_integrity_violated Then

140: End If;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 15);
143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: per_sps_shd.g_api_dml := false; -- Unset the api dml status
147: per_sps_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: per_sps_shd.g_api_dml := false; -- Unset the api dml status
147: per_sps_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: per_sps_shd.g_api_dml := false; -- Unset the api dml status
152: per_sps_shd.constraint_error

Line 149: When hr_api.unique_integrity_violated Then

145: -- A check constraint has been violated
146: per_sps_shd.g_api_dml := false; -- Unset the api dml status
147: per_sps_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: per_sps_shd.g_api_dml := false; -- Unset the api dml status
152: per_sps_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: per_sps_shd.g_api_dml := false; -- Unset the api dml status
152: per_sps_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: per_sps_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;
157: End dt_update_dml;

Line 270: If (p_datetrack_mode <> hr_api.g_correction) then

266: l_dummy_version_number number;
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: If (p_datetrack_mode <> hr_api.g_correction) then
271: --
272: -- Update the current effective end date
273: --
274: per_sps_shd.upd_effective_end_date

Line 283: If (p_datetrack_mode = hr_api.g_update_override) then

279: ,p_validation_end_date => p_validation_end_date
280: ,p_object_version_number => l_dummy_version_number
281: );
282: --
283: If (p_datetrack_mode = hr_api.g_update_override) then
284: --
285: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
286: -- delete any future rows
287: --

Line 597: when hr_api.cannot_find_prog_unit then

593: );
594: --
595: exception
596: --
597: when hr_api.cannot_find_prog_unit then
598: --
599: hr_api.cannot_find_prog_unit_error
600: (p_module_name => 'PER_SPINAL_POINT_STEPS_F'
601: ,p_hook_type => 'AU');

Line 599: hr_api.cannot_find_prog_unit_error

595: exception
596: --
597: when hr_api.cannot_find_prog_unit then
598: --
599: hr_api.cannot_find_prog_unit_error
600: (p_module_name => 'PER_SPINAL_POINT_STEPS_F'
601: ,p_hook_type => 'AU');
602: --
603: end;

Line 662: If (p_rec.business_group_id = hr_api.g_number) then

658: -- p_rec plsql record structure
659: -- to see if a system default is being used. If a system default
660: -- is being used then we must set to the 'current' argument value.
661: --
662: If (p_rec.business_group_id = hr_api.g_number) then
663: p_rec.business_group_id :=
664: per_sps_shd.g_old_rec.business_group_id;
665: End If;
666: If (p_rec.spinal_point_id = hr_api.g_number) then

Line 666: If (p_rec.spinal_point_id = hr_api.g_number) then

662: If (p_rec.business_group_id = hr_api.g_number) then
663: p_rec.business_group_id :=
664: per_sps_shd.g_old_rec.business_group_id;
665: End If;
666: If (p_rec.spinal_point_id = hr_api.g_number) then
667: p_rec.spinal_point_id :=
668: per_sps_shd.g_old_rec.spinal_point_id;
669: End If;
670: If (p_rec.grade_spine_id = hr_api.g_number) then

Line 670: If (p_rec.grade_spine_id = hr_api.g_number) then

666: If (p_rec.spinal_point_id = hr_api.g_number) then
667: p_rec.spinal_point_id :=
668: per_sps_shd.g_old_rec.spinal_point_id;
669: End If;
670: If (p_rec.grade_spine_id = hr_api.g_number) then
671: p_rec.grade_spine_id :=
672: per_sps_shd.g_old_rec.grade_spine_id;
673: End If;
674: If (p_rec.sequence = hr_api.g_number) then

Line 674: If (p_rec.sequence = hr_api.g_number) then

670: If (p_rec.grade_spine_id = hr_api.g_number) then
671: p_rec.grade_spine_id :=
672: per_sps_shd.g_old_rec.grade_spine_id;
673: End If;
674: If (p_rec.sequence = hr_api.g_number) then
675: p_rec.sequence :=
676: per_sps_shd.g_old_rec.sequence;
677: End If;
678: If (p_rec.request_id = hr_api.g_number) then

Line 678: If (p_rec.request_id = hr_api.g_number) then

674: If (p_rec.sequence = hr_api.g_number) then
675: p_rec.sequence :=
676: per_sps_shd.g_old_rec.sequence;
677: End If;
678: If (p_rec.request_id = hr_api.g_number) then
679: p_rec.request_id :=
680: per_sps_shd.g_old_rec.request_id;
681: End If;
682: If (p_rec.program_application_id = hr_api.g_number) then

Line 682: If (p_rec.program_application_id = hr_api.g_number) then

678: If (p_rec.request_id = hr_api.g_number) then
679: p_rec.request_id :=
680: per_sps_shd.g_old_rec.request_id;
681: End If;
682: If (p_rec.program_application_id = hr_api.g_number) then
683: p_rec.program_application_id :=
684: per_sps_shd.g_old_rec.program_application_id;
685: End If;
686: If (p_rec.program_id = hr_api.g_number) then

Line 686: If (p_rec.program_id = hr_api.g_number) then

682: If (p_rec.program_application_id = hr_api.g_number) then
683: p_rec.program_application_id :=
684: per_sps_shd.g_old_rec.program_application_id;
685: End If;
686: If (p_rec.program_id = hr_api.g_number) then
687: p_rec.program_id :=
688: per_sps_shd.g_old_rec.program_id;
689: End If;
690: If (p_rec.program_update_date = hr_api.g_date) then

Line 690: If (p_rec.program_update_date = hr_api.g_date) then

686: If (p_rec.program_id = hr_api.g_number) then
687: p_rec.program_id :=
688: per_sps_shd.g_old_rec.program_id;
689: End If;
690: If (p_rec.program_update_date = hr_api.g_date) then
691: p_rec.program_update_date :=
692: per_sps_shd.g_old_rec.program_update_date;
693: End If;
694: If (p_rec.information1 = hr_api.g_varchar2) then

Line 694: If (p_rec.information1 = hr_api.g_varchar2) then

690: If (p_rec.program_update_date = hr_api.g_date) then
691: p_rec.program_update_date :=
692: per_sps_shd.g_old_rec.program_update_date;
693: End If;
694: If (p_rec.information1 = hr_api.g_varchar2) then
695: p_rec.information1 :=
696: per_sps_shd.g_old_rec.information1;
697: End If;
698: If (p_rec.information2 = hr_api.g_varchar2) then

Line 698: If (p_rec.information2 = hr_api.g_varchar2) then

694: If (p_rec.information1 = hr_api.g_varchar2) then
695: p_rec.information1 :=
696: per_sps_shd.g_old_rec.information1;
697: End If;
698: If (p_rec.information2 = hr_api.g_varchar2) then
699: p_rec.information2 :=
700: per_sps_shd.g_old_rec.information2;
701: End If;
702: If (p_rec.information3 = hr_api.g_varchar2) then

Line 702: If (p_rec.information3 = hr_api.g_varchar2) then

698: If (p_rec.information2 = hr_api.g_varchar2) then
699: p_rec.information2 :=
700: per_sps_shd.g_old_rec.information2;
701: End If;
702: If (p_rec.information3 = hr_api.g_varchar2) then
703: p_rec.information3 :=
704: per_sps_shd.g_old_rec.information3;
705: End If;
706: If (p_rec.information4 = hr_api.g_varchar2) then

Line 706: If (p_rec.information4 = hr_api.g_varchar2) then

702: If (p_rec.information3 = hr_api.g_varchar2) then
703: p_rec.information3 :=
704: per_sps_shd.g_old_rec.information3;
705: End If;
706: If (p_rec.information4 = hr_api.g_varchar2) then
707: p_rec.information4 :=
708: per_sps_shd.g_old_rec.information4;
709: End If;
710: If (p_rec.information5 = hr_api.g_varchar2) then

Line 710: If (p_rec.information5 = hr_api.g_varchar2) then

706: If (p_rec.information4 = hr_api.g_varchar2) then
707: p_rec.information4 :=
708: per_sps_shd.g_old_rec.information4;
709: End If;
710: If (p_rec.information5 = hr_api.g_varchar2) then
711: p_rec.information5 :=
712: per_sps_shd.g_old_rec.information5;
713: End If;
714: If (p_rec.information6 = hr_api.g_varchar2) then

Line 714: If (p_rec.information6 = hr_api.g_varchar2) then

710: If (p_rec.information5 = hr_api.g_varchar2) then
711: p_rec.information5 :=
712: per_sps_shd.g_old_rec.information5;
713: End If;
714: If (p_rec.information6 = hr_api.g_varchar2) then
715: p_rec.information6 :=
716: per_sps_shd.g_old_rec.information6;
717: End If;
718: If (p_rec.information7 = hr_api.g_varchar2) then

Line 718: If (p_rec.information7 = hr_api.g_varchar2) then

714: If (p_rec.information6 = hr_api.g_varchar2) then
715: p_rec.information6 :=
716: per_sps_shd.g_old_rec.information6;
717: End If;
718: If (p_rec.information7 = hr_api.g_varchar2) then
719: p_rec.information7 :=
720: per_sps_shd.g_old_rec.information7;
721: End If;
722: If (p_rec.information8 = hr_api.g_varchar2) then

Line 722: If (p_rec.information8 = hr_api.g_varchar2) then

718: If (p_rec.information7 = hr_api.g_varchar2) then
719: p_rec.information7 :=
720: per_sps_shd.g_old_rec.information7;
721: End If;
722: If (p_rec.information8 = hr_api.g_varchar2) then
723: p_rec.information8 :=
724: per_sps_shd.g_old_rec.information8;
725: End If;
726: If (p_rec.information9 = hr_api.g_varchar2) then

Line 726: If (p_rec.information9 = hr_api.g_varchar2) then

722: If (p_rec.information8 = hr_api.g_varchar2) then
723: p_rec.information8 :=
724: per_sps_shd.g_old_rec.information8;
725: End If;
726: If (p_rec.information9 = hr_api.g_varchar2) then
727: p_rec.information9 :=
728: per_sps_shd.g_old_rec.information9;
729: End If;
730: If (p_rec.information10 = hr_api.g_varchar2) then

Line 730: If (p_rec.information10 = hr_api.g_varchar2) then

726: If (p_rec.information9 = hr_api.g_varchar2) then
727: p_rec.information9 :=
728: per_sps_shd.g_old_rec.information9;
729: End If;
730: If (p_rec.information10 = hr_api.g_varchar2) then
731: p_rec.information10 :=
732: per_sps_shd.g_old_rec.information10;
733: End If;
734: If (p_rec.information11 = hr_api.g_varchar2) then

Line 734: If (p_rec.information11 = hr_api.g_varchar2) then

730: If (p_rec.information10 = hr_api.g_varchar2) then
731: p_rec.information10 :=
732: per_sps_shd.g_old_rec.information10;
733: End If;
734: If (p_rec.information11 = hr_api.g_varchar2) then
735: p_rec.information11 :=
736: per_sps_shd.g_old_rec.information11;
737: End If;
738: If (p_rec.information12 = hr_api.g_varchar2) then

Line 738: If (p_rec.information12 = hr_api.g_varchar2) then

734: If (p_rec.information11 = hr_api.g_varchar2) then
735: p_rec.information11 :=
736: per_sps_shd.g_old_rec.information11;
737: End If;
738: If (p_rec.information12 = hr_api.g_varchar2) then
739: p_rec.information12 :=
740: per_sps_shd.g_old_rec.information12;
741: End If;
742: If (p_rec.information13 = hr_api.g_varchar2) then

Line 742: If (p_rec.information13 = hr_api.g_varchar2) then

738: If (p_rec.information12 = hr_api.g_varchar2) then
739: p_rec.information12 :=
740: per_sps_shd.g_old_rec.information12;
741: End If;
742: If (p_rec.information13 = hr_api.g_varchar2) then
743: p_rec.information13 :=
744: per_sps_shd.g_old_rec.information13;
745: End If;
746: If (p_rec.information14 = hr_api.g_varchar2) then

Line 746: If (p_rec.information14 = hr_api.g_varchar2) then

742: If (p_rec.information13 = hr_api.g_varchar2) then
743: p_rec.information13 :=
744: per_sps_shd.g_old_rec.information13;
745: End If;
746: If (p_rec.information14 = hr_api.g_varchar2) then
747: p_rec.information14 :=
748: per_sps_shd.g_old_rec.information14;
749: End If;
750: If (p_rec.information15 = hr_api.g_varchar2) then

Line 750: If (p_rec.information15 = hr_api.g_varchar2) then

746: If (p_rec.information14 = hr_api.g_varchar2) then
747: p_rec.information14 :=
748: per_sps_shd.g_old_rec.information14;
749: End If;
750: If (p_rec.information15 = hr_api.g_varchar2) then
751: p_rec.information15 :=
752: per_sps_shd.g_old_rec.information15;
753: End If;
754: If (p_rec.information16 = hr_api.g_varchar2) then

Line 754: If (p_rec.information16 = hr_api.g_varchar2) then

750: If (p_rec.information15 = hr_api.g_varchar2) then
751: p_rec.information15 :=
752: per_sps_shd.g_old_rec.information15;
753: End If;
754: If (p_rec.information16 = hr_api.g_varchar2) then
755: p_rec.information16 :=
756: per_sps_shd.g_old_rec.information16;
757: End If;
758: If (p_rec.information17 = hr_api.g_varchar2) then

Line 758: If (p_rec.information17 = hr_api.g_varchar2) then

754: If (p_rec.information16 = hr_api.g_varchar2) then
755: p_rec.information16 :=
756: per_sps_shd.g_old_rec.information16;
757: End If;
758: If (p_rec.information17 = hr_api.g_varchar2) then
759: p_rec.information17 :=
760: per_sps_shd.g_old_rec.information17;
761: End If;
762: If (p_rec.information18 = hr_api.g_varchar2) then

Line 762: If (p_rec.information18 = hr_api.g_varchar2) then

758: If (p_rec.information17 = hr_api.g_varchar2) then
759: p_rec.information17 :=
760: per_sps_shd.g_old_rec.information17;
761: End If;
762: If (p_rec.information18 = hr_api.g_varchar2) then
763: p_rec.information18 :=
764: per_sps_shd.g_old_rec.information18;
765: End If;
766: If (p_rec.information19 = hr_api.g_varchar2) then

Line 766: If (p_rec.information19 = hr_api.g_varchar2) then

762: If (p_rec.information18 = hr_api.g_varchar2) then
763: p_rec.information18 :=
764: per_sps_shd.g_old_rec.information18;
765: End If;
766: If (p_rec.information19 = hr_api.g_varchar2) then
767: p_rec.information19 :=
768: per_sps_shd.g_old_rec.information19;
769: End If;
770: If (p_rec.information20 = hr_api.g_varchar2) then

Line 770: If (p_rec.information20 = hr_api.g_varchar2) then

766: If (p_rec.information19 = hr_api.g_varchar2) then
767: p_rec.information19 :=
768: per_sps_shd.g_old_rec.information19;
769: End If;
770: If (p_rec.information20 = hr_api.g_varchar2) then
771: p_rec.information20 :=
772: per_sps_shd.g_old_rec.information20;
773: End If;
774: If (p_rec.information21 = hr_api.g_varchar2) then

Line 774: If (p_rec.information21 = hr_api.g_varchar2) then

770: If (p_rec.information20 = hr_api.g_varchar2) then
771: p_rec.information20 :=
772: per_sps_shd.g_old_rec.information20;
773: End If;
774: If (p_rec.information21 = hr_api.g_varchar2) then
775: p_rec.information21 :=
776: per_sps_shd.g_old_rec.information21;
777: End If;
778: If (p_rec.information22 = hr_api.g_varchar2) then

Line 778: If (p_rec.information22 = hr_api.g_varchar2) then

774: If (p_rec.information21 = hr_api.g_varchar2) then
775: p_rec.information21 :=
776: per_sps_shd.g_old_rec.information21;
777: End If;
778: If (p_rec.information22 = hr_api.g_varchar2) then
779: p_rec.information22 :=
780: per_sps_shd.g_old_rec.information22;
781: End If;
782: If (p_rec.information23 = hr_api.g_varchar2) then

Line 782: If (p_rec.information23 = hr_api.g_varchar2) then

778: If (p_rec.information22 = hr_api.g_varchar2) then
779: p_rec.information22 :=
780: per_sps_shd.g_old_rec.information22;
781: End If;
782: If (p_rec.information23 = hr_api.g_varchar2) then
783: p_rec.information23 :=
784: per_sps_shd.g_old_rec.information23;
785: End If;
786: If (p_rec.information24 = hr_api.g_varchar2) then

Line 786: If (p_rec.information24 = hr_api.g_varchar2) then

782: If (p_rec.information23 = hr_api.g_varchar2) then
783: p_rec.information23 :=
784: per_sps_shd.g_old_rec.information23;
785: End If;
786: If (p_rec.information24 = hr_api.g_varchar2) then
787: p_rec.information24 :=
788: per_sps_shd.g_old_rec.information24;
789: End If;
790: If (p_rec.information25 = hr_api.g_varchar2) then

Line 790: If (p_rec.information25 = hr_api.g_varchar2) then

786: If (p_rec.information24 = hr_api.g_varchar2) then
787: p_rec.information24 :=
788: per_sps_shd.g_old_rec.information24;
789: End If;
790: If (p_rec.information25 = hr_api.g_varchar2) then
791: p_rec.information25 :=
792: per_sps_shd.g_old_rec.information25;
793: End If;
794: If (p_rec.information26 = hr_api.g_varchar2) then

Line 794: If (p_rec.information26 = hr_api.g_varchar2) then

790: If (p_rec.information25 = hr_api.g_varchar2) then
791: p_rec.information25 :=
792: per_sps_shd.g_old_rec.information25;
793: End If;
794: If (p_rec.information26 = hr_api.g_varchar2) then
795: p_rec.information26 :=
796: per_sps_shd.g_old_rec.information26;
797: End If;
798: If (p_rec.information27 = hr_api.g_varchar2) then

Line 798: If (p_rec.information27 = hr_api.g_varchar2) then

794: If (p_rec.information26 = hr_api.g_varchar2) then
795: p_rec.information26 :=
796: per_sps_shd.g_old_rec.information26;
797: End If;
798: If (p_rec.information27 = hr_api.g_varchar2) then
799: p_rec.information27 :=
800: per_sps_shd.g_old_rec.information27;
801: End If;
802: If (p_rec.information28 = hr_api.g_varchar2) then

Line 802: If (p_rec.information28 = hr_api.g_varchar2) then

798: If (p_rec.information27 = hr_api.g_varchar2) then
799: p_rec.information27 :=
800: per_sps_shd.g_old_rec.information27;
801: End If;
802: If (p_rec.information28 = hr_api.g_varchar2) then
803: p_rec.information28 :=
804: per_sps_shd.g_old_rec.information28;
805: End If;
806: If (p_rec.information29 = hr_api.g_varchar2) then

Line 806: If (p_rec.information29 = hr_api.g_varchar2) then

802: If (p_rec.information28 = hr_api.g_varchar2) then
803: p_rec.information28 :=
804: per_sps_shd.g_old_rec.information28;
805: End If;
806: If (p_rec.information29 = hr_api.g_varchar2) then
807: p_rec.information29 :=
808: per_sps_shd.g_old_rec.information29;
809: End If;
810: If (p_rec.information30 = hr_api.g_varchar2) then

Line 810: If (p_rec.information30 = hr_api.g_varchar2) then

806: If (p_rec.information29 = hr_api.g_varchar2) then
807: p_rec.information29 :=
808: per_sps_shd.g_old_rec.information29;
809: End If;
810: If (p_rec.information30 = hr_api.g_varchar2) then
811: p_rec.information30 :=
812: per_sps_shd.g_old_rec.information30;
813: End If;
814: If (p_rec.information_category = hr_api.g_varchar2) then

Line 814: If (p_rec.information_category = hr_api.g_varchar2) then

810: If (p_rec.information30 = hr_api.g_varchar2) then
811: p_rec.information30 :=
812: per_sps_shd.g_old_rec.information30;
813: End If;
814: If (p_rec.information_category = hr_api.g_varchar2) then
815: p_rec.information_category :=
816: per_sps_shd.g_old_rec.information_category;
817: End If;
818: --

Line 913: ,p_business_group_id in number default hr_api.g_number

909: (p_effective_date in date
910: ,p_datetrack_mode in varchar2
911: ,p_step_id in number
912: ,p_object_version_number in out nocopy number
913: ,p_business_group_id in number default hr_api.g_number
914: ,p_spinal_point_id in number default hr_api.g_number
915: ,p_grade_spine_id in number default hr_api.g_number
916: ,p_sequence in number default hr_api.g_number
917: ,p_request_id in number default hr_api.g_number

Line 914: ,p_spinal_point_id in number default hr_api.g_number

910: ,p_datetrack_mode in varchar2
911: ,p_step_id in number
912: ,p_object_version_number in out nocopy number
913: ,p_business_group_id in number default hr_api.g_number
914: ,p_spinal_point_id in number default hr_api.g_number
915: ,p_grade_spine_id in number default hr_api.g_number
916: ,p_sequence in number default hr_api.g_number
917: ,p_request_id in number default hr_api.g_number
918: ,p_program_application_id in number default hr_api.g_number

Line 915: ,p_grade_spine_id in number default hr_api.g_number

911: ,p_step_id in number
912: ,p_object_version_number in out nocopy number
913: ,p_business_group_id in number default hr_api.g_number
914: ,p_spinal_point_id in number default hr_api.g_number
915: ,p_grade_spine_id in number default hr_api.g_number
916: ,p_sequence in number default hr_api.g_number
917: ,p_request_id in number default hr_api.g_number
918: ,p_program_application_id in number default hr_api.g_number
919: ,p_program_id in number default hr_api.g_number

Line 916: ,p_sequence in number default hr_api.g_number

912: ,p_object_version_number in out nocopy number
913: ,p_business_group_id in number default hr_api.g_number
914: ,p_spinal_point_id in number default hr_api.g_number
915: ,p_grade_spine_id in number default hr_api.g_number
916: ,p_sequence in number default hr_api.g_number
917: ,p_request_id in number default hr_api.g_number
918: ,p_program_application_id in number default hr_api.g_number
919: ,p_program_id in number default hr_api.g_number
920: ,p_program_update_date in date default hr_api.g_date

Line 917: ,p_request_id in number default hr_api.g_number

913: ,p_business_group_id in number default hr_api.g_number
914: ,p_spinal_point_id in number default hr_api.g_number
915: ,p_grade_spine_id in number default hr_api.g_number
916: ,p_sequence in number default hr_api.g_number
917: ,p_request_id in number default hr_api.g_number
918: ,p_program_application_id in number default hr_api.g_number
919: ,p_program_id in number default hr_api.g_number
920: ,p_program_update_date in date default hr_api.g_date
921: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 918: ,p_program_application_id in number default hr_api.g_number

914: ,p_spinal_point_id in number default hr_api.g_number
915: ,p_grade_spine_id in number default hr_api.g_number
916: ,p_sequence in number default hr_api.g_number
917: ,p_request_id in number default hr_api.g_number
918: ,p_program_application_id in number default hr_api.g_number
919: ,p_program_id in number default hr_api.g_number
920: ,p_program_update_date in date default hr_api.g_date
921: ,p_information1 in varchar2 default hr_api.g_varchar2
922: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 919: ,p_program_id in number default hr_api.g_number

915: ,p_grade_spine_id in number default hr_api.g_number
916: ,p_sequence in number default hr_api.g_number
917: ,p_request_id in number default hr_api.g_number
918: ,p_program_application_id in number default hr_api.g_number
919: ,p_program_id in number default hr_api.g_number
920: ,p_program_update_date in date default hr_api.g_date
921: ,p_information1 in varchar2 default hr_api.g_varchar2
922: ,p_information2 in varchar2 default hr_api.g_varchar2
923: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 920: ,p_program_update_date in date default hr_api.g_date

916: ,p_sequence in number default hr_api.g_number
917: ,p_request_id in number default hr_api.g_number
918: ,p_program_application_id in number default hr_api.g_number
919: ,p_program_id in number default hr_api.g_number
920: ,p_program_update_date in date default hr_api.g_date
921: ,p_information1 in varchar2 default hr_api.g_varchar2
922: ,p_information2 in varchar2 default hr_api.g_varchar2
923: ,p_information3 in varchar2 default hr_api.g_varchar2
924: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 921: ,p_information1 in varchar2 default hr_api.g_varchar2

917: ,p_request_id in number default hr_api.g_number
918: ,p_program_application_id in number default hr_api.g_number
919: ,p_program_id in number default hr_api.g_number
920: ,p_program_update_date in date default hr_api.g_date
921: ,p_information1 in varchar2 default hr_api.g_varchar2
922: ,p_information2 in varchar2 default hr_api.g_varchar2
923: ,p_information3 in varchar2 default hr_api.g_varchar2
924: ,p_information4 in varchar2 default hr_api.g_varchar2
925: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 922: ,p_information2 in varchar2 default hr_api.g_varchar2

918: ,p_program_application_id in number default hr_api.g_number
919: ,p_program_id in number default hr_api.g_number
920: ,p_program_update_date in date default hr_api.g_date
921: ,p_information1 in varchar2 default hr_api.g_varchar2
922: ,p_information2 in varchar2 default hr_api.g_varchar2
923: ,p_information3 in varchar2 default hr_api.g_varchar2
924: ,p_information4 in varchar2 default hr_api.g_varchar2
925: ,p_information5 in varchar2 default hr_api.g_varchar2
926: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 923: ,p_information3 in varchar2 default hr_api.g_varchar2

919: ,p_program_id in number default hr_api.g_number
920: ,p_program_update_date in date default hr_api.g_date
921: ,p_information1 in varchar2 default hr_api.g_varchar2
922: ,p_information2 in varchar2 default hr_api.g_varchar2
923: ,p_information3 in varchar2 default hr_api.g_varchar2
924: ,p_information4 in varchar2 default hr_api.g_varchar2
925: ,p_information5 in varchar2 default hr_api.g_varchar2
926: ,p_information6 in varchar2 default hr_api.g_varchar2
927: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 924: ,p_information4 in varchar2 default hr_api.g_varchar2

920: ,p_program_update_date in date default hr_api.g_date
921: ,p_information1 in varchar2 default hr_api.g_varchar2
922: ,p_information2 in varchar2 default hr_api.g_varchar2
923: ,p_information3 in varchar2 default hr_api.g_varchar2
924: ,p_information4 in varchar2 default hr_api.g_varchar2
925: ,p_information5 in varchar2 default hr_api.g_varchar2
926: ,p_information6 in varchar2 default hr_api.g_varchar2
927: ,p_information7 in varchar2 default hr_api.g_varchar2
928: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 925: ,p_information5 in varchar2 default hr_api.g_varchar2

921: ,p_information1 in varchar2 default hr_api.g_varchar2
922: ,p_information2 in varchar2 default hr_api.g_varchar2
923: ,p_information3 in varchar2 default hr_api.g_varchar2
924: ,p_information4 in varchar2 default hr_api.g_varchar2
925: ,p_information5 in varchar2 default hr_api.g_varchar2
926: ,p_information6 in varchar2 default hr_api.g_varchar2
927: ,p_information7 in varchar2 default hr_api.g_varchar2
928: ,p_information8 in varchar2 default hr_api.g_varchar2
929: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 926: ,p_information6 in varchar2 default hr_api.g_varchar2

922: ,p_information2 in varchar2 default hr_api.g_varchar2
923: ,p_information3 in varchar2 default hr_api.g_varchar2
924: ,p_information4 in varchar2 default hr_api.g_varchar2
925: ,p_information5 in varchar2 default hr_api.g_varchar2
926: ,p_information6 in varchar2 default hr_api.g_varchar2
927: ,p_information7 in varchar2 default hr_api.g_varchar2
928: ,p_information8 in varchar2 default hr_api.g_varchar2
929: ,p_information9 in varchar2 default hr_api.g_varchar2
930: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 927: ,p_information7 in varchar2 default hr_api.g_varchar2

923: ,p_information3 in varchar2 default hr_api.g_varchar2
924: ,p_information4 in varchar2 default hr_api.g_varchar2
925: ,p_information5 in varchar2 default hr_api.g_varchar2
926: ,p_information6 in varchar2 default hr_api.g_varchar2
927: ,p_information7 in varchar2 default hr_api.g_varchar2
928: ,p_information8 in varchar2 default hr_api.g_varchar2
929: ,p_information9 in varchar2 default hr_api.g_varchar2
930: ,p_information10 in varchar2 default hr_api.g_varchar2
931: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 928: ,p_information8 in varchar2 default hr_api.g_varchar2

924: ,p_information4 in varchar2 default hr_api.g_varchar2
925: ,p_information5 in varchar2 default hr_api.g_varchar2
926: ,p_information6 in varchar2 default hr_api.g_varchar2
927: ,p_information7 in varchar2 default hr_api.g_varchar2
928: ,p_information8 in varchar2 default hr_api.g_varchar2
929: ,p_information9 in varchar2 default hr_api.g_varchar2
930: ,p_information10 in varchar2 default hr_api.g_varchar2
931: ,p_information11 in varchar2 default hr_api.g_varchar2
932: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 929: ,p_information9 in varchar2 default hr_api.g_varchar2

925: ,p_information5 in varchar2 default hr_api.g_varchar2
926: ,p_information6 in varchar2 default hr_api.g_varchar2
927: ,p_information7 in varchar2 default hr_api.g_varchar2
928: ,p_information8 in varchar2 default hr_api.g_varchar2
929: ,p_information9 in varchar2 default hr_api.g_varchar2
930: ,p_information10 in varchar2 default hr_api.g_varchar2
931: ,p_information11 in varchar2 default hr_api.g_varchar2
932: ,p_information12 in varchar2 default hr_api.g_varchar2
933: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 930: ,p_information10 in varchar2 default hr_api.g_varchar2

926: ,p_information6 in varchar2 default hr_api.g_varchar2
927: ,p_information7 in varchar2 default hr_api.g_varchar2
928: ,p_information8 in varchar2 default hr_api.g_varchar2
929: ,p_information9 in varchar2 default hr_api.g_varchar2
930: ,p_information10 in varchar2 default hr_api.g_varchar2
931: ,p_information11 in varchar2 default hr_api.g_varchar2
932: ,p_information12 in varchar2 default hr_api.g_varchar2
933: ,p_information13 in varchar2 default hr_api.g_varchar2
934: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 931: ,p_information11 in varchar2 default hr_api.g_varchar2

927: ,p_information7 in varchar2 default hr_api.g_varchar2
928: ,p_information8 in varchar2 default hr_api.g_varchar2
929: ,p_information9 in varchar2 default hr_api.g_varchar2
930: ,p_information10 in varchar2 default hr_api.g_varchar2
931: ,p_information11 in varchar2 default hr_api.g_varchar2
932: ,p_information12 in varchar2 default hr_api.g_varchar2
933: ,p_information13 in varchar2 default hr_api.g_varchar2
934: ,p_information14 in varchar2 default hr_api.g_varchar2
935: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 932: ,p_information12 in varchar2 default hr_api.g_varchar2

928: ,p_information8 in varchar2 default hr_api.g_varchar2
929: ,p_information9 in varchar2 default hr_api.g_varchar2
930: ,p_information10 in varchar2 default hr_api.g_varchar2
931: ,p_information11 in varchar2 default hr_api.g_varchar2
932: ,p_information12 in varchar2 default hr_api.g_varchar2
933: ,p_information13 in varchar2 default hr_api.g_varchar2
934: ,p_information14 in varchar2 default hr_api.g_varchar2
935: ,p_information15 in varchar2 default hr_api.g_varchar2
936: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 933: ,p_information13 in varchar2 default hr_api.g_varchar2

929: ,p_information9 in varchar2 default hr_api.g_varchar2
930: ,p_information10 in varchar2 default hr_api.g_varchar2
931: ,p_information11 in varchar2 default hr_api.g_varchar2
932: ,p_information12 in varchar2 default hr_api.g_varchar2
933: ,p_information13 in varchar2 default hr_api.g_varchar2
934: ,p_information14 in varchar2 default hr_api.g_varchar2
935: ,p_information15 in varchar2 default hr_api.g_varchar2
936: ,p_information16 in varchar2 default hr_api.g_varchar2
937: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 934: ,p_information14 in varchar2 default hr_api.g_varchar2

930: ,p_information10 in varchar2 default hr_api.g_varchar2
931: ,p_information11 in varchar2 default hr_api.g_varchar2
932: ,p_information12 in varchar2 default hr_api.g_varchar2
933: ,p_information13 in varchar2 default hr_api.g_varchar2
934: ,p_information14 in varchar2 default hr_api.g_varchar2
935: ,p_information15 in varchar2 default hr_api.g_varchar2
936: ,p_information16 in varchar2 default hr_api.g_varchar2
937: ,p_information17 in varchar2 default hr_api.g_varchar2
938: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 935: ,p_information15 in varchar2 default hr_api.g_varchar2

931: ,p_information11 in varchar2 default hr_api.g_varchar2
932: ,p_information12 in varchar2 default hr_api.g_varchar2
933: ,p_information13 in varchar2 default hr_api.g_varchar2
934: ,p_information14 in varchar2 default hr_api.g_varchar2
935: ,p_information15 in varchar2 default hr_api.g_varchar2
936: ,p_information16 in varchar2 default hr_api.g_varchar2
937: ,p_information17 in varchar2 default hr_api.g_varchar2
938: ,p_information18 in varchar2 default hr_api.g_varchar2
939: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 936: ,p_information16 in varchar2 default hr_api.g_varchar2

932: ,p_information12 in varchar2 default hr_api.g_varchar2
933: ,p_information13 in varchar2 default hr_api.g_varchar2
934: ,p_information14 in varchar2 default hr_api.g_varchar2
935: ,p_information15 in varchar2 default hr_api.g_varchar2
936: ,p_information16 in varchar2 default hr_api.g_varchar2
937: ,p_information17 in varchar2 default hr_api.g_varchar2
938: ,p_information18 in varchar2 default hr_api.g_varchar2
939: ,p_information19 in varchar2 default hr_api.g_varchar2
940: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 937: ,p_information17 in varchar2 default hr_api.g_varchar2

933: ,p_information13 in varchar2 default hr_api.g_varchar2
934: ,p_information14 in varchar2 default hr_api.g_varchar2
935: ,p_information15 in varchar2 default hr_api.g_varchar2
936: ,p_information16 in varchar2 default hr_api.g_varchar2
937: ,p_information17 in varchar2 default hr_api.g_varchar2
938: ,p_information18 in varchar2 default hr_api.g_varchar2
939: ,p_information19 in varchar2 default hr_api.g_varchar2
940: ,p_information20 in varchar2 default hr_api.g_varchar2
941: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 938: ,p_information18 in varchar2 default hr_api.g_varchar2

934: ,p_information14 in varchar2 default hr_api.g_varchar2
935: ,p_information15 in varchar2 default hr_api.g_varchar2
936: ,p_information16 in varchar2 default hr_api.g_varchar2
937: ,p_information17 in varchar2 default hr_api.g_varchar2
938: ,p_information18 in varchar2 default hr_api.g_varchar2
939: ,p_information19 in varchar2 default hr_api.g_varchar2
940: ,p_information20 in varchar2 default hr_api.g_varchar2
941: ,p_information21 in varchar2 default hr_api.g_varchar2
942: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 939: ,p_information19 in varchar2 default hr_api.g_varchar2

935: ,p_information15 in varchar2 default hr_api.g_varchar2
936: ,p_information16 in varchar2 default hr_api.g_varchar2
937: ,p_information17 in varchar2 default hr_api.g_varchar2
938: ,p_information18 in varchar2 default hr_api.g_varchar2
939: ,p_information19 in varchar2 default hr_api.g_varchar2
940: ,p_information20 in varchar2 default hr_api.g_varchar2
941: ,p_information21 in varchar2 default hr_api.g_varchar2
942: ,p_information22 in varchar2 default hr_api.g_varchar2
943: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 940: ,p_information20 in varchar2 default hr_api.g_varchar2

936: ,p_information16 in varchar2 default hr_api.g_varchar2
937: ,p_information17 in varchar2 default hr_api.g_varchar2
938: ,p_information18 in varchar2 default hr_api.g_varchar2
939: ,p_information19 in varchar2 default hr_api.g_varchar2
940: ,p_information20 in varchar2 default hr_api.g_varchar2
941: ,p_information21 in varchar2 default hr_api.g_varchar2
942: ,p_information22 in varchar2 default hr_api.g_varchar2
943: ,p_information23 in varchar2 default hr_api.g_varchar2
944: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 941: ,p_information21 in varchar2 default hr_api.g_varchar2

937: ,p_information17 in varchar2 default hr_api.g_varchar2
938: ,p_information18 in varchar2 default hr_api.g_varchar2
939: ,p_information19 in varchar2 default hr_api.g_varchar2
940: ,p_information20 in varchar2 default hr_api.g_varchar2
941: ,p_information21 in varchar2 default hr_api.g_varchar2
942: ,p_information22 in varchar2 default hr_api.g_varchar2
943: ,p_information23 in varchar2 default hr_api.g_varchar2
944: ,p_information24 in varchar2 default hr_api.g_varchar2
945: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 942: ,p_information22 in varchar2 default hr_api.g_varchar2

938: ,p_information18 in varchar2 default hr_api.g_varchar2
939: ,p_information19 in varchar2 default hr_api.g_varchar2
940: ,p_information20 in varchar2 default hr_api.g_varchar2
941: ,p_information21 in varchar2 default hr_api.g_varchar2
942: ,p_information22 in varchar2 default hr_api.g_varchar2
943: ,p_information23 in varchar2 default hr_api.g_varchar2
944: ,p_information24 in varchar2 default hr_api.g_varchar2
945: ,p_information25 in varchar2 default hr_api.g_varchar2
946: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 943: ,p_information23 in varchar2 default hr_api.g_varchar2

939: ,p_information19 in varchar2 default hr_api.g_varchar2
940: ,p_information20 in varchar2 default hr_api.g_varchar2
941: ,p_information21 in varchar2 default hr_api.g_varchar2
942: ,p_information22 in varchar2 default hr_api.g_varchar2
943: ,p_information23 in varchar2 default hr_api.g_varchar2
944: ,p_information24 in varchar2 default hr_api.g_varchar2
945: ,p_information25 in varchar2 default hr_api.g_varchar2
946: ,p_information26 in varchar2 default hr_api.g_varchar2
947: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 944: ,p_information24 in varchar2 default hr_api.g_varchar2

940: ,p_information20 in varchar2 default hr_api.g_varchar2
941: ,p_information21 in varchar2 default hr_api.g_varchar2
942: ,p_information22 in varchar2 default hr_api.g_varchar2
943: ,p_information23 in varchar2 default hr_api.g_varchar2
944: ,p_information24 in varchar2 default hr_api.g_varchar2
945: ,p_information25 in varchar2 default hr_api.g_varchar2
946: ,p_information26 in varchar2 default hr_api.g_varchar2
947: ,p_information27 in varchar2 default hr_api.g_varchar2
948: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 945: ,p_information25 in varchar2 default hr_api.g_varchar2

941: ,p_information21 in varchar2 default hr_api.g_varchar2
942: ,p_information22 in varchar2 default hr_api.g_varchar2
943: ,p_information23 in varchar2 default hr_api.g_varchar2
944: ,p_information24 in varchar2 default hr_api.g_varchar2
945: ,p_information25 in varchar2 default hr_api.g_varchar2
946: ,p_information26 in varchar2 default hr_api.g_varchar2
947: ,p_information27 in varchar2 default hr_api.g_varchar2
948: ,p_information28 in varchar2 default hr_api.g_varchar2
949: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 946: ,p_information26 in varchar2 default hr_api.g_varchar2

942: ,p_information22 in varchar2 default hr_api.g_varchar2
943: ,p_information23 in varchar2 default hr_api.g_varchar2
944: ,p_information24 in varchar2 default hr_api.g_varchar2
945: ,p_information25 in varchar2 default hr_api.g_varchar2
946: ,p_information26 in varchar2 default hr_api.g_varchar2
947: ,p_information27 in varchar2 default hr_api.g_varchar2
948: ,p_information28 in varchar2 default hr_api.g_varchar2
949: ,p_information29 in varchar2 default hr_api.g_varchar2
950: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 947: ,p_information27 in varchar2 default hr_api.g_varchar2

943: ,p_information23 in varchar2 default hr_api.g_varchar2
944: ,p_information24 in varchar2 default hr_api.g_varchar2
945: ,p_information25 in varchar2 default hr_api.g_varchar2
946: ,p_information26 in varchar2 default hr_api.g_varchar2
947: ,p_information27 in varchar2 default hr_api.g_varchar2
948: ,p_information28 in varchar2 default hr_api.g_varchar2
949: ,p_information29 in varchar2 default hr_api.g_varchar2
950: ,p_information30 in varchar2 default hr_api.g_varchar2
951: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 948: ,p_information28 in varchar2 default hr_api.g_varchar2

944: ,p_information24 in varchar2 default hr_api.g_varchar2
945: ,p_information25 in varchar2 default hr_api.g_varchar2
946: ,p_information26 in varchar2 default hr_api.g_varchar2
947: ,p_information27 in varchar2 default hr_api.g_varchar2
948: ,p_information28 in varchar2 default hr_api.g_varchar2
949: ,p_information29 in varchar2 default hr_api.g_varchar2
950: ,p_information30 in varchar2 default hr_api.g_varchar2
951: ,p_information_category in varchar2 default hr_api.g_varchar2
952: ,p_effective_start_date out nocopy date

Line 949: ,p_information29 in varchar2 default hr_api.g_varchar2

945: ,p_information25 in varchar2 default hr_api.g_varchar2
946: ,p_information26 in varchar2 default hr_api.g_varchar2
947: ,p_information27 in varchar2 default hr_api.g_varchar2
948: ,p_information28 in varchar2 default hr_api.g_varchar2
949: ,p_information29 in varchar2 default hr_api.g_varchar2
950: ,p_information30 in varchar2 default hr_api.g_varchar2
951: ,p_information_category in varchar2 default hr_api.g_varchar2
952: ,p_effective_start_date out nocopy date
953: ,p_effective_end_date out nocopy date

Line 950: ,p_information30 in varchar2 default hr_api.g_varchar2

946: ,p_information26 in varchar2 default hr_api.g_varchar2
947: ,p_information27 in varchar2 default hr_api.g_varchar2
948: ,p_information28 in varchar2 default hr_api.g_varchar2
949: ,p_information29 in varchar2 default hr_api.g_varchar2
950: ,p_information30 in varchar2 default hr_api.g_varchar2
951: ,p_information_category in varchar2 default hr_api.g_varchar2
952: ,p_effective_start_date out nocopy date
953: ,p_effective_end_date out nocopy date
954: ) is

Line 951: ,p_information_category in varchar2 default hr_api.g_varchar2

947: ,p_information27 in varchar2 default hr_api.g_varchar2
948: ,p_information28 in varchar2 default hr_api.g_varchar2
949: ,p_information29 in varchar2 default hr_api.g_varchar2
950: ,p_information30 in varchar2 default hr_api.g_varchar2
951: ,p_information_category in varchar2 default hr_api.g_varchar2
952: ,p_effective_start_date out nocopy date
953: ,p_effective_end_date out nocopy date
954: ) is
955: --