APPS.HR_CLE_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 155: When hr_api.check_integrity_violated Then

151: End If;
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 15);
154: Exception
155: When hr_api.check_integrity_violated Then
156: -- A check constraint has been violated
157: --
158: hr_cle_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

155: When hr_api.check_integrity_violated Then
156: -- A check constraint has been violated
157: --
158: hr_cle_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.unique_integrity_violated Then
161: -- Unique integrity has been violated
162: --
163: hr_cle_shd.constraint_error

Line 160: When hr_api.unique_integrity_violated Then

156: -- A check constraint has been violated
157: --
158: hr_cle_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.unique_integrity_violated Then
161: -- Unique integrity has been violated
162: --
163: hr_cle_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

160: When hr_api.unique_integrity_violated Then
161: -- Unique integrity has been violated
162: --
163: hr_cle_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When Others Then
166: --
167: Raise;
168: End dt_update_dml;

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

277: l_dummy_version_number number;
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: If (p_datetrack_mode <> hr_api.g_correction) then
282: --
283: -- Update the current effective end date
284: --
285: hr_cle_shd.upd_effective_end_date

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

290: ,p_validation_end_date => p_validation_end_date
291: ,p_object_version_number => l_dummy_version_number
292: );
293: --
294: If (p_datetrack_mode = hr_api.g_update_override) then
295: --
296: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
297: -- delete any future rows
298: --

Line 652: when hr_api.cannot_find_prog_unit then

648: );
649: --
650: exception
651: --
652: when hr_api.cannot_find_prog_unit then
653: --
654: hr_api.cannot_find_prog_unit_error
655: (p_module_name => 'HR_DE_SOC_INS_CONTR_LVLS_F'
656: ,p_hook_type => 'AU');

Line 654: hr_api.cannot_find_prog_unit_error

650: exception
651: --
652: when hr_api.cannot_find_prog_unit then
653: --
654: hr_api.cannot_find_prog_unit_error
655: (p_module_name => 'HR_DE_SOC_INS_CONTR_LVLS_F'
656: ,p_hook_type => 'AU');
657: --
658: end;

Line 717: If (p_rec.organization_id = hr_api.g_number) then

713: -- p_rec plsql record structure
714: -- to see if a system default is being used. If a system default
715: -- is being used then we must set to the 'current' argument value.
716: --
717: If (p_rec.organization_id = hr_api.g_number) then
718: p_rec.organization_id :=
719: hr_cle_shd.g_old_rec.organization_id;
720: End If;
721: If (p_rec.normal_percentage = hr_api.g_number) then

Line 721: If (p_rec.normal_percentage = hr_api.g_number) then

717: If (p_rec.organization_id = hr_api.g_number) then
718: p_rec.organization_id :=
719: hr_cle_shd.g_old_rec.organization_id;
720: End If;
721: If (p_rec.normal_percentage = hr_api.g_number) then
722: p_rec.normal_percentage :=
723: hr_cle_shd.g_old_rec.normal_percentage;
724: End If;
725: If (p_rec.normal_amount = hr_api.g_number) then

Line 725: If (p_rec.normal_amount = hr_api.g_number) then

721: If (p_rec.normal_percentage = hr_api.g_number) then
722: p_rec.normal_percentage :=
723: hr_cle_shd.g_old_rec.normal_percentage;
724: End If;
725: If (p_rec.normal_amount = hr_api.g_number) then
726: p_rec.normal_amount :=
727: hr_cle_shd.g_old_rec.normal_amount;
728: End If;
729: If (p_rec.increased_percentage = hr_api.g_number) then

Line 729: If (p_rec.increased_percentage = hr_api.g_number) then

725: If (p_rec.normal_amount = hr_api.g_number) then
726: p_rec.normal_amount :=
727: hr_cle_shd.g_old_rec.normal_amount;
728: End If;
729: If (p_rec.increased_percentage = hr_api.g_number) then
730: p_rec.increased_percentage :=
731: hr_cle_shd.g_old_rec.increased_percentage;
732: End If;
733: If (p_rec.increased_amount = hr_api.g_number) then

Line 733: If (p_rec.increased_amount = hr_api.g_number) then

729: If (p_rec.increased_percentage = hr_api.g_number) then
730: p_rec.increased_percentage :=
731: hr_cle_shd.g_old_rec.increased_percentage;
732: End If;
733: If (p_rec.increased_amount = hr_api.g_number) then
734: p_rec.increased_amount :=
735: hr_cle_shd.g_old_rec.increased_amount;
736: End If;
737: If (p_rec.reduced_percentage = hr_api.g_number) then

Line 737: If (p_rec.reduced_percentage = hr_api.g_number) then

733: If (p_rec.increased_amount = hr_api.g_number) then
734: p_rec.increased_amount :=
735: hr_cle_shd.g_old_rec.increased_amount;
736: End If;
737: If (p_rec.reduced_percentage = hr_api.g_number) then
738: p_rec.reduced_percentage :=
739: hr_cle_shd.g_old_rec.reduced_percentage;
740: End If;
741: If (p_rec.reduced_amount = hr_api.g_number) then

Line 741: If (p_rec.reduced_amount = hr_api.g_number) then

737: If (p_rec.reduced_percentage = hr_api.g_number) then
738: p_rec.reduced_percentage :=
739: hr_cle_shd.g_old_rec.reduced_percentage;
740: End If;
741: If (p_rec.reduced_amount = hr_api.g_number) then
742: p_rec.reduced_amount :=
743: hr_cle_shd.g_old_rec.reduced_amount;
744: End If;
745: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 745: If (p_rec.attribute_category = hr_api.g_varchar2) then

741: If (p_rec.reduced_amount = hr_api.g_number) then
742: p_rec.reduced_amount :=
743: hr_cle_shd.g_old_rec.reduced_amount;
744: End If;
745: If (p_rec.attribute_category = hr_api.g_varchar2) then
746: p_rec.attribute_category :=
747: hr_cle_shd.g_old_rec.attribute_category;
748: End If;
749: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 749: If (p_rec.attribute1 = hr_api.g_varchar2) then

745: If (p_rec.attribute_category = hr_api.g_varchar2) then
746: p_rec.attribute_category :=
747: hr_cle_shd.g_old_rec.attribute_category;
748: End If;
749: If (p_rec.attribute1 = hr_api.g_varchar2) then
750: p_rec.attribute1 :=
751: hr_cle_shd.g_old_rec.attribute1;
752: End If;
753: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 753: If (p_rec.attribute2 = hr_api.g_varchar2) then

749: If (p_rec.attribute1 = hr_api.g_varchar2) then
750: p_rec.attribute1 :=
751: hr_cle_shd.g_old_rec.attribute1;
752: End If;
753: If (p_rec.attribute2 = hr_api.g_varchar2) then
754: p_rec.attribute2 :=
755: hr_cle_shd.g_old_rec.attribute2;
756: End If;
757: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 757: If (p_rec.attribute3 = hr_api.g_varchar2) then

753: If (p_rec.attribute2 = hr_api.g_varchar2) then
754: p_rec.attribute2 :=
755: hr_cle_shd.g_old_rec.attribute2;
756: End If;
757: If (p_rec.attribute3 = hr_api.g_varchar2) then
758: p_rec.attribute3 :=
759: hr_cle_shd.g_old_rec.attribute3;
760: End If;
761: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 761: If (p_rec.attribute4 = hr_api.g_varchar2) then

757: If (p_rec.attribute3 = hr_api.g_varchar2) then
758: p_rec.attribute3 :=
759: hr_cle_shd.g_old_rec.attribute3;
760: End If;
761: If (p_rec.attribute4 = hr_api.g_varchar2) then
762: p_rec.attribute4 :=
763: hr_cle_shd.g_old_rec.attribute4;
764: End If;
765: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 765: If (p_rec.attribute5 = hr_api.g_varchar2) then

761: If (p_rec.attribute4 = hr_api.g_varchar2) then
762: p_rec.attribute4 :=
763: hr_cle_shd.g_old_rec.attribute4;
764: End If;
765: If (p_rec.attribute5 = hr_api.g_varchar2) then
766: p_rec.attribute5 :=
767: hr_cle_shd.g_old_rec.attribute5;
768: End If;
769: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 769: If (p_rec.attribute6 = hr_api.g_varchar2) then

765: If (p_rec.attribute5 = hr_api.g_varchar2) then
766: p_rec.attribute5 :=
767: hr_cle_shd.g_old_rec.attribute5;
768: End If;
769: If (p_rec.attribute6 = hr_api.g_varchar2) then
770: p_rec.attribute6 :=
771: hr_cle_shd.g_old_rec.attribute6;
772: End If;
773: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 773: If (p_rec.attribute7 = hr_api.g_varchar2) then

769: If (p_rec.attribute6 = hr_api.g_varchar2) then
770: p_rec.attribute6 :=
771: hr_cle_shd.g_old_rec.attribute6;
772: End If;
773: If (p_rec.attribute7 = hr_api.g_varchar2) then
774: p_rec.attribute7 :=
775: hr_cle_shd.g_old_rec.attribute7;
776: End If;
777: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 777: If (p_rec.attribute8 = hr_api.g_varchar2) then

773: If (p_rec.attribute7 = hr_api.g_varchar2) then
774: p_rec.attribute7 :=
775: hr_cle_shd.g_old_rec.attribute7;
776: End If;
777: If (p_rec.attribute8 = hr_api.g_varchar2) then
778: p_rec.attribute8 :=
779: hr_cle_shd.g_old_rec.attribute8;
780: End If;
781: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 781: If (p_rec.attribute9 = hr_api.g_varchar2) then

777: If (p_rec.attribute8 = hr_api.g_varchar2) then
778: p_rec.attribute8 :=
779: hr_cle_shd.g_old_rec.attribute8;
780: End If;
781: If (p_rec.attribute9 = hr_api.g_varchar2) then
782: p_rec.attribute9 :=
783: hr_cle_shd.g_old_rec.attribute9;
784: End If;
785: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 785: If (p_rec.attribute10 = hr_api.g_varchar2) then

781: If (p_rec.attribute9 = hr_api.g_varchar2) then
782: p_rec.attribute9 :=
783: hr_cle_shd.g_old_rec.attribute9;
784: End If;
785: If (p_rec.attribute10 = hr_api.g_varchar2) then
786: p_rec.attribute10 :=
787: hr_cle_shd.g_old_rec.attribute10;
788: End If;
789: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 789: If (p_rec.attribute11 = hr_api.g_varchar2) then

785: If (p_rec.attribute10 = hr_api.g_varchar2) then
786: p_rec.attribute10 :=
787: hr_cle_shd.g_old_rec.attribute10;
788: End If;
789: If (p_rec.attribute11 = hr_api.g_varchar2) then
790: p_rec.attribute11 :=
791: hr_cle_shd.g_old_rec.attribute11;
792: End If;
793: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 793: If (p_rec.attribute12 = hr_api.g_varchar2) then

789: If (p_rec.attribute11 = hr_api.g_varchar2) then
790: p_rec.attribute11 :=
791: hr_cle_shd.g_old_rec.attribute11;
792: End If;
793: If (p_rec.attribute12 = hr_api.g_varchar2) then
794: p_rec.attribute12 :=
795: hr_cle_shd.g_old_rec.attribute12;
796: End If;
797: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 797: If (p_rec.attribute13 = hr_api.g_varchar2) then

793: If (p_rec.attribute12 = hr_api.g_varchar2) then
794: p_rec.attribute12 :=
795: hr_cle_shd.g_old_rec.attribute12;
796: End If;
797: If (p_rec.attribute13 = hr_api.g_varchar2) then
798: p_rec.attribute13 :=
799: hr_cle_shd.g_old_rec.attribute13;
800: End If;
801: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 801: If (p_rec.attribute14 = hr_api.g_varchar2) then

797: If (p_rec.attribute13 = hr_api.g_varchar2) then
798: p_rec.attribute13 :=
799: hr_cle_shd.g_old_rec.attribute13;
800: End If;
801: If (p_rec.attribute14 = hr_api.g_varchar2) then
802: p_rec.attribute14 :=
803: hr_cle_shd.g_old_rec.attribute14;
804: End If;
805: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 805: If (p_rec.attribute15 = hr_api.g_varchar2) then

801: If (p_rec.attribute14 = hr_api.g_varchar2) then
802: p_rec.attribute14 :=
803: hr_cle_shd.g_old_rec.attribute14;
804: End If;
805: If (p_rec.attribute15 = hr_api.g_varchar2) then
806: p_rec.attribute15 :=
807: hr_cle_shd.g_old_rec.attribute15;
808: End If;
809: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 809: If (p_rec.attribute16 = hr_api.g_varchar2) then

805: If (p_rec.attribute15 = hr_api.g_varchar2) then
806: p_rec.attribute15 :=
807: hr_cle_shd.g_old_rec.attribute15;
808: End If;
809: If (p_rec.attribute16 = hr_api.g_varchar2) then
810: p_rec.attribute16 :=
811: hr_cle_shd.g_old_rec.attribute16;
812: End If;
813: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 813: If (p_rec.attribute17 = hr_api.g_varchar2) then

809: If (p_rec.attribute16 = hr_api.g_varchar2) then
810: p_rec.attribute16 :=
811: hr_cle_shd.g_old_rec.attribute16;
812: End If;
813: If (p_rec.attribute17 = hr_api.g_varchar2) then
814: p_rec.attribute17 :=
815: hr_cle_shd.g_old_rec.attribute17;
816: End If;
817: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 817: If (p_rec.attribute18 = hr_api.g_varchar2) then

813: If (p_rec.attribute17 = hr_api.g_varchar2) then
814: p_rec.attribute17 :=
815: hr_cle_shd.g_old_rec.attribute17;
816: End If;
817: If (p_rec.attribute18 = hr_api.g_varchar2) then
818: p_rec.attribute18 :=
819: hr_cle_shd.g_old_rec.attribute18;
820: End If;
821: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 821: If (p_rec.attribute19 = hr_api.g_varchar2) then

817: If (p_rec.attribute18 = hr_api.g_varchar2) then
818: p_rec.attribute18 :=
819: hr_cle_shd.g_old_rec.attribute18;
820: End If;
821: If (p_rec.attribute19 = hr_api.g_varchar2) then
822: p_rec.attribute19 :=
823: hr_cle_shd.g_old_rec.attribute19;
824: End If;
825: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 825: If (p_rec.attribute20 = hr_api.g_varchar2) then

821: If (p_rec.attribute19 = hr_api.g_varchar2) then
822: p_rec.attribute19 :=
823: hr_cle_shd.g_old_rec.attribute19;
824: End If;
825: If (p_rec.attribute20 = hr_api.g_varchar2) then
826: p_rec.attribute20 :=
827: hr_cle_shd.g_old_rec.attribute20;
828: End If;
829: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 829: If (p_rec.attribute21 = hr_api.g_varchar2) then

825: If (p_rec.attribute20 = hr_api.g_varchar2) then
826: p_rec.attribute20 :=
827: hr_cle_shd.g_old_rec.attribute20;
828: End If;
829: If (p_rec.attribute21 = hr_api.g_varchar2) then
830: p_rec.attribute21 :=
831: hr_cle_shd.g_old_rec.attribute21;
832: End If;
833: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 833: If (p_rec.attribute22 = hr_api.g_varchar2) then

829: If (p_rec.attribute21 = hr_api.g_varchar2) then
830: p_rec.attribute21 :=
831: hr_cle_shd.g_old_rec.attribute21;
832: End If;
833: If (p_rec.attribute22 = hr_api.g_varchar2) then
834: p_rec.attribute22 :=
835: hr_cle_shd.g_old_rec.attribute22;
836: End If;
837: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 837: If (p_rec.attribute23 = hr_api.g_varchar2) then

833: If (p_rec.attribute22 = hr_api.g_varchar2) then
834: p_rec.attribute22 :=
835: hr_cle_shd.g_old_rec.attribute22;
836: End If;
837: If (p_rec.attribute23 = hr_api.g_varchar2) then
838: p_rec.attribute23 :=
839: hr_cle_shd.g_old_rec.attribute23;
840: End If;
841: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 841: If (p_rec.attribute24 = hr_api.g_varchar2) then

837: If (p_rec.attribute23 = hr_api.g_varchar2) then
838: p_rec.attribute23 :=
839: hr_cle_shd.g_old_rec.attribute23;
840: End If;
841: If (p_rec.attribute24 = hr_api.g_varchar2) then
842: p_rec.attribute24 :=
843: hr_cle_shd.g_old_rec.attribute24;
844: End If;
845: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 845: If (p_rec.attribute25 = hr_api.g_varchar2) then

841: If (p_rec.attribute24 = hr_api.g_varchar2) then
842: p_rec.attribute24 :=
843: hr_cle_shd.g_old_rec.attribute24;
844: End If;
845: If (p_rec.attribute25 = hr_api.g_varchar2) then
846: p_rec.attribute25 :=
847: hr_cle_shd.g_old_rec.attribute25;
848: End If;
849: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 849: If (p_rec.attribute26 = hr_api.g_varchar2) then

845: If (p_rec.attribute25 = hr_api.g_varchar2) then
846: p_rec.attribute25 :=
847: hr_cle_shd.g_old_rec.attribute25;
848: End If;
849: If (p_rec.attribute26 = hr_api.g_varchar2) then
850: p_rec.attribute26 :=
851: hr_cle_shd.g_old_rec.attribute26;
852: End If;
853: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 853: If (p_rec.attribute27 = hr_api.g_varchar2) then

849: If (p_rec.attribute26 = hr_api.g_varchar2) then
850: p_rec.attribute26 :=
851: hr_cle_shd.g_old_rec.attribute26;
852: End If;
853: If (p_rec.attribute27 = hr_api.g_varchar2) then
854: p_rec.attribute27 :=
855: hr_cle_shd.g_old_rec.attribute27;
856: End If;
857: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 857: If (p_rec.attribute28 = hr_api.g_varchar2) then

853: If (p_rec.attribute27 = hr_api.g_varchar2) then
854: p_rec.attribute27 :=
855: hr_cle_shd.g_old_rec.attribute27;
856: End If;
857: If (p_rec.attribute28 = hr_api.g_varchar2) then
858: p_rec.attribute28 :=
859: hr_cle_shd.g_old_rec.attribute28;
860: End If;
861: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 861: If (p_rec.attribute29 = hr_api.g_varchar2) then

857: If (p_rec.attribute28 = hr_api.g_varchar2) then
858: p_rec.attribute28 :=
859: hr_cle_shd.g_old_rec.attribute28;
860: End If;
861: If (p_rec.attribute29 = hr_api.g_varchar2) then
862: p_rec.attribute29 :=
863: hr_cle_shd.g_old_rec.attribute29;
864: End If;
865: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 865: If (p_rec.attribute30 = hr_api.g_varchar2) then

861: If (p_rec.attribute29 = hr_api.g_varchar2) then
862: p_rec.attribute29 :=
863: hr_cle_shd.g_old_rec.attribute29;
864: End If;
865: If (p_rec.attribute30 = hr_api.g_varchar2) then
866: p_rec.attribute30 :=
867: hr_cle_shd.g_old_rec.attribute30;
868: End If;
869: If (p_rec.flat_tax_limit_per_month= hr_api.g_number) then

Line 869: If (p_rec.flat_tax_limit_per_month= hr_api.g_number) then

865: If (p_rec.attribute30 = hr_api.g_varchar2) then
866: p_rec.attribute30 :=
867: hr_cle_shd.g_old_rec.attribute30;
868: End If;
869: If (p_rec.flat_tax_limit_per_month= hr_api.g_number) then
870: p_rec.flat_tax_limit_per_month :=
871: hr_cle_shd.g_old_rec.flat_tax_limit_per_month;
872: End If;
873: If (p_rec.flat_tax_limit_per_year = hr_api.g_number) then

Line 873: If (p_rec.flat_tax_limit_per_year = hr_api.g_number) then

869: If (p_rec.flat_tax_limit_per_month= hr_api.g_number) then
870: p_rec.flat_tax_limit_per_month :=
871: hr_cle_shd.g_old_rec.flat_tax_limit_per_month;
872: End If;
873: If (p_rec.flat_tax_limit_per_year = hr_api.g_number) then
874: p_rec.flat_tax_limit_per_year :=
875: hr_cle_shd.g_old_rec.flat_tax_limit_per_year;
876: End If;
877: If (p_rec.min_increased_contribution= hr_api.g_number) then

Line 877: If (p_rec.min_increased_contribution= hr_api.g_number) then

873: If (p_rec.flat_tax_limit_per_year = hr_api.g_number) then
874: p_rec.flat_tax_limit_per_year :=
875: hr_cle_shd.g_old_rec.flat_tax_limit_per_year;
876: End If;
877: If (p_rec.min_increased_contribution= hr_api.g_number) then
878: p_rec.min_increased_contribution :=
879: hr_cle_shd.g_old_rec.min_increased_contribution;
880: End If;
881: If (p_rec.max_increased_contribution= hr_api.g_number) then

Line 881: If (p_rec.max_increased_contribution= hr_api.g_number) then

877: If (p_rec.min_increased_contribution= hr_api.g_number) then
878: p_rec.min_increased_contribution :=
879: hr_cle_shd.g_old_rec.min_increased_contribution;
880: End If;
881: If (p_rec.max_increased_contribution= hr_api.g_number) then
882: p_rec.max_increased_contribution :=
883: hr_cle_shd.g_old_rec.max_increased_contribution;
884: End If;
885: If (p_rec.month1= hr_api.g_varchar2) then

Line 885: If (p_rec.month1= hr_api.g_varchar2) then

881: If (p_rec.max_increased_contribution= hr_api.g_number) then
882: p_rec.max_increased_contribution :=
883: hr_cle_shd.g_old_rec.max_increased_contribution;
884: End If;
885: If (p_rec.month1= hr_api.g_varchar2) then
886: p_rec.month1 :=
887: hr_cle_shd.g_old_rec.month1;
888: End If;
889: If (p_rec.month1_min_contribution= hr_api.g_number) then

Line 889: If (p_rec.month1_min_contribution= hr_api.g_number) then

885: If (p_rec.month1= hr_api.g_varchar2) then
886: p_rec.month1 :=
887: hr_cle_shd.g_old_rec.month1;
888: End If;
889: If (p_rec.month1_min_contribution= hr_api.g_number) then
890: p_rec.month1_min_contribution :=
891: hr_cle_shd.g_old_rec.month1_min_contribution;
892: End If;
893: If (p_rec.month1_max_contribution= hr_api.g_number) then

Line 893: If (p_rec.month1_max_contribution= hr_api.g_number) then

889: If (p_rec.month1_min_contribution= hr_api.g_number) then
890: p_rec.month1_min_contribution :=
891: hr_cle_shd.g_old_rec.month1_min_contribution;
892: End If;
893: If (p_rec.month1_max_contribution= hr_api.g_number) then
894: p_rec.month1_max_contribution :=
895: hr_cle_shd.g_old_rec.month1_max_contribution;
896: End If;
897: If (p_rec.month2= hr_api.g_varchar2) then

Line 897: If (p_rec.month2= hr_api.g_varchar2) then

893: If (p_rec.month1_max_contribution= hr_api.g_number) then
894: p_rec.month1_max_contribution :=
895: hr_cle_shd.g_old_rec.month1_max_contribution;
896: End If;
897: If (p_rec.month2= hr_api.g_varchar2) then
898: p_rec.month2 :=
899: hr_cle_shd.g_old_rec.month2;
900: End If;
901: If (p_rec.month2_min_contribution = hr_api.g_number) then

Line 901: If (p_rec.month2_min_contribution = hr_api.g_number) then

897: If (p_rec.month2= hr_api.g_varchar2) then
898: p_rec.month2 :=
899: hr_cle_shd.g_old_rec.month2;
900: End If;
901: If (p_rec.month2_min_contribution = hr_api.g_number) then
902: p_rec.month2_min_contribution :=
903: hr_cle_shd.g_old_rec.month2_min_contribution;
904: End If;
905: If (p_rec.month2_max_contribution = hr_api.g_number) then

Line 905: If (p_rec.month2_max_contribution = hr_api.g_number) then

901: If (p_rec.month2_min_contribution = hr_api.g_number) then
902: p_rec.month2_min_contribution :=
903: hr_cle_shd.g_old_rec.month2_min_contribution;
904: End If;
905: If (p_rec.month2_max_contribution = hr_api.g_number) then
906: p_rec.month2_max_contribution :=
907: hr_cle_shd.g_old_rec.month2_max_contribution;
908: End If;
909: If (p_rec.employee_contribution= hr_api.g_number) then

Line 909: If (p_rec.employee_contribution= hr_api.g_number) then

905: If (p_rec.month2_max_contribution = hr_api.g_number) then
906: p_rec.month2_max_contribution :=
907: hr_cle_shd.g_old_rec.month2_max_contribution;
908: End If;
909: If (p_rec.employee_contribution= hr_api.g_number) then
910: p_rec.employee_contribution :=
911: hr_cle_shd.g_old_rec.employee_contribution;
912: End If;
913: If (p_rec.contribution_level_type = hr_api.g_varchar2) then

Line 913: If (p_rec.contribution_level_type = hr_api.g_varchar2) then

909: If (p_rec.employee_contribution= hr_api.g_number) then
910: p_rec.employee_contribution :=
911: hr_cle_shd.g_old_rec.employee_contribution;
912: End If;
913: If (p_rec.contribution_level_type = hr_api.g_varchar2) then
914: p_rec.contribution_level_type :=
915: hr_cle_shd.g_old_rec.contribution_level_type;
916: End If;
917:

Line 1007: ,p_organization_id in number default hr_api.g_number

1003: (p_effective_date in date
1004: ,p_datetrack_mode in varchar2
1005: ,p_soc_ins_contr_lvls_id in number
1006: ,p_object_version_number in out nocopy number
1007: ,p_organization_id in number default hr_api.g_number
1008: ,p_normal_percentage in number default hr_api.g_number
1009: ,p_increased_percentage in number default hr_api.g_number
1010: ,p_reduced_percentage in number default hr_api.g_number
1011: ,p_normal_amount in number default hr_api.g_number

Line 1008: ,p_normal_percentage in number default hr_api.g_number

1004: ,p_datetrack_mode in varchar2
1005: ,p_soc_ins_contr_lvls_id in number
1006: ,p_object_version_number in out nocopy number
1007: ,p_organization_id in number default hr_api.g_number
1008: ,p_normal_percentage in number default hr_api.g_number
1009: ,p_increased_percentage in number default hr_api.g_number
1010: ,p_reduced_percentage in number default hr_api.g_number
1011: ,p_normal_amount in number default hr_api.g_number
1012: ,p_increased_amount in number default hr_api.g_number

Line 1009: ,p_increased_percentage in number default hr_api.g_number

1005: ,p_soc_ins_contr_lvls_id in number
1006: ,p_object_version_number in out nocopy number
1007: ,p_organization_id in number default hr_api.g_number
1008: ,p_normal_percentage in number default hr_api.g_number
1009: ,p_increased_percentage in number default hr_api.g_number
1010: ,p_reduced_percentage in number default hr_api.g_number
1011: ,p_normal_amount in number default hr_api.g_number
1012: ,p_increased_amount in number default hr_api.g_number
1013: ,p_reduced_amount in number default hr_api.g_number

Line 1010: ,p_reduced_percentage in number default hr_api.g_number

1006: ,p_object_version_number in out nocopy number
1007: ,p_organization_id in number default hr_api.g_number
1008: ,p_normal_percentage in number default hr_api.g_number
1009: ,p_increased_percentage in number default hr_api.g_number
1010: ,p_reduced_percentage in number default hr_api.g_number
1011: ,p_normal_amount in number default hr_api.g_number
1012: ,p_increased_amount in number default hr_api.g_number
1013: ,p_reduced_amount in number default hr_api.g_number
1014: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 1011: ,p_normal_amount in number default hr_api.g_number

1007: ,p_organization_id in number default hr_api.g_number
1008: ,p_normal_percentage in number default hr_api.g_number
1009: ,p_increased_percentage in number default hr_api.g_number
1010: ,p_reduced_percentage in number default hr_api.g_number
1011: ,p_normal_amount in number default hr_api.g_number
1012: ,p_increased_amount in number default hr_api.g_number
1013: ,p_reduced_amount in number default hr_api.g_number
1014: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1015: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1012: ,p_increased_amount in number default hr_api.g_number

1008: ,p_normal_percentage in number default hr_api.g_number
1009: ,p_increased_percentage in number default hr_api.g_number
1010: ,p_reduced_percentage in number default hr_api.g_number
1011: ,p_normal_amount in number default hr_api.g_number
1012: ,p_increased_amount in number default hr_api.g_number
1013: ,p_reduced_amount in number default hr_api.g_number
1014: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1015: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1013: ,p_reduced_amount in number default hr_api.g_number

1009: ,p_increased_percentage in number default hr_api.g_number
1010: ,p_reduced_percentage in number default hr_api.g_number
1011: ,p_normal_amount in number default hr_api.g_number
1012: ,p_increased_amount in number default hr_api.g_number
1013: ,p_reduced_amount in number default hr_api.g_number
1014: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1015: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1014: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1010: ,p_reduced_percentage in number default hr_api.g_number
1011: ,p_normal_amount in number default hr_api.g_number
1012: ,p_increased_amount in number default hr_api.g_number
1013: ,p_reduced_amount in number default hr_api.g_number
1014: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1015: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1015: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1011: ,p_normal_amount in number default hr_api.g_number
1012: ,p_increased_amount in number default hr_api.g_number
1013: ,p_reduced_amount in number default hr_api.g_number
1014: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1015: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1016: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1012: ,p_increased_amount in number default hr_api.g_number
1013: ,p_reduced_amount in number default hr_api.g_number
1014: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1015: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1017: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1013: ,p_reduced_amount in number default hr_api.g_number
1014: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1015: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1018: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1014: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1015: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1019: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1015: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1020: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1016: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1021: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1017: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1022: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1018: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1023: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1019: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1024: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1020: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1025: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1021: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1026: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1022: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1027: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1023: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1028: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1024: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1029: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1025: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1030: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1026: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1031: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1027: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 1032: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1028: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 1033: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1029: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 1034: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1030: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 1035: ,p_attribute21 in varchar2 default hr_api.g_varchar2

1031: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 1036: ,p_attribute22 in varchar2 default hr_api.g_varchar2

1032: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 1037: ,p_attribute23 in varchar2 default hr_api.g_varchar2

1033: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 1038: ,p_attribute24 in varchar2 default hr_api.g_varchar2

1034: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 1039: ,p_attribute25 in varchar2 default hr_api.g_varchar2

1035: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 1040: ,p_attribute26 in varchar2 default hr_api.g_varchar2

1036: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 1041: ,p_attribute27 in varchar2 default hr_api.g_varchar2

1037: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1045: ,p_flat_tax_limit_per_month in number default hr_api.g_number

Line 1042: ,p_attribute28 in varchar2 default hr_api.g_varchar2

1038: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1045: ,p_flat_tax_limit_per_month in number default hr_api.g_number
1046: ,p_flat_tax_limit_per_year in number default hr_api.g_number

Line 1043: ,p_attribute29 in varchar2 default hr_api.g_varchar2

1039: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1045: ,p_flat_tax_limit_per_month in number default hr_api.g_number
1046: ,p_flat_tax_limit_per_year in number default hr_api.g_number
1047: ,p_min_increased_contribution in number default hr_api.g_number

Line 1044: ,p_attribute30 in varchar2 default hr_api.g_varchar2

1040: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1045: ,p_flat_tax_limit_per_month in number default hr_api.g_number
1046: ,p_flat_tax_limit_per_year in number default hr_api.g_number
1047: ,p_min_increased_contribution in number default hr_api.g_number
1048: ,p_max_increased_contribution in number default hr_api.g_number

Line 1045: ,p_flat_tax_limit_per_month in number default hr_api.g_number

1041: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1045: ,p_flat_tax_limit_per_month in number default hr_api.g_number
1046: ,p_flat_tax_limit_per_year in number default hr_api.g_number
1047: ,p_min_increased_contribution in number default hr_api.g_number
1048: ,p_max_increased_contribution in number default hr_api.g_number
1049: ,p_month1 in varchar2 default hr_api.g_varchar2

Line 1046: ,p_flat_tax_limit_per_year in number default hr_api.g_number

1042: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1045: ,p_flat_tax_limit_per_month in number default hr_api.g_number
1046: ,p_flat_tax_limit_per_year in number default hr_api.g_number
1047: ,p_min_increased_contribution in number default hr_api.g_number
1048: ,p_max_increased_contribution in number default hr_api.g_number
1049: ,p_month1 in varchar2 default hr_api.g_varchar2
1050: ,p_month1_min_contribution in number default hr_api.g_number

Line 1047: ,p_min_increased_contribution in number default hr_api.g_number

1043: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1045: ,p_flat_tax_limit_per_month in number default hr_api.g_number
1046: ,p_flat_tax_limit_per_year in number default hr_api.g_number
1047: ,p_min_increased_contribution in number default hr_api.g_number
1048: ,p_max_increased_contribution in number default hr_api.g_number
1049: ,p_month1 in varchar2 default hr_api.g_varchar2
1050: ,p_month1_min_contribution in number default hr_api.g_number
1051: ,p_month1_max_contribution in number default hr_api.g_number

Line 1048: ,p_max_increased_contribution in number default hr_api.g_number

1044: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1045: ,p_flat_tax_limit_per_month in number default hr_api.g_number
1046: ,p_flat_tax_limit_per_year in number default hr_api.g_number
1047: ,p_min_increased_contribution in number default hr_api.g_number
1048: ,p_max_increased_contribution in number default hr_api.g_number
1049: ,p_month1 in varchar2 default hr_api.g_varchar2
1050: ,p_month1_min_contribution in number default hr_api.g_number
1051: ,p_month1_max_contribution in number default hr_api.g_number
1052: ,p_month2 in varchar2 default hr_api.g_varchar2

Line 1049: ,p_month1 in varchar2 default hr_api.g_varchar2

1045: ,p_flat_tax_limit_per_month in number default hr_api.g_number
1046: ,p_flat_tax_limit_per_year in number default hr_api.g_number
1047: ,p_min_increased_contribution in number default hr_api.g_number
1048: ,p_max_increased_contribution in number default hr_api.g_number
1049: ,p_month1 in varchar2 default hr_api.g_varchar2
1050: ,p_month1_min_contribution in number default hr_api.g_number
1051: ,p_month1_max_contribution in number default hr_api.g_number
1052: ,p_month2 in varchar2 default hr_api.g_varchar2
1053: ,p_month2_min_contribution in number default hr_api.g_number

Line 1050: ,p_month1_min_contribution in number default hr_api.g_number

1046: ,p_flat_tax_limit_per_year in number default hr_api.g_number
1047: ,p_min_increased_contribution in number default hr_api.g_number
1048: ,p_max_increased_contribution in number default hr_api.g_number
1049: ,p_month1 in varchar2 default hr_api.g_varchar2
1050: ,p_month1_min_contribution in number default hr_api.g_number
1051: ,p_month1_max_contribution in number default hr_api.g_number
1052: ,p_month2 in varchar2 default hr_api.g_varchar2
1053: ,p_month2_min_contribution in number default hr_api.g_number
1054: ,p_month2_max_contribution in number default hr_api.g_number

Line 1051: ,p_month1_max_contribution in number default hr_api.g_number

1047: ,p_min_increased_contribution in number default hr_api.g_number
1048: ,p_max_increased_contribution in number default hr_api.g_number
1049: ,p_month1 in varchar2 default hr_api.g_varchar2
1050: ,p_month1_min_contribution in number default hr_api.g_number
1051: ,p_month1_max_contribution in number default hr_api.g_number
1052: ,p_month2 in varchar2 default hr_api.g_varchar2
1053: ,p_month2_min_contribution in number default hr_api.g_number
1054: ,p_month2_max_contribution in number default hr_api.g_number
1055: ,p_employee_contribution in number default hr_api.g_number

Line 1052: ,p_month2 in varchar2 default hr_api.g_varchar2

1048: ,p_max_increased_contribution in number default hr_api.g_number
1049: ,p_month1 in varchar2 default hr_api.g_varchar2
1050: ,p_month1_min_contribution in number default hr_api.g_number
1051: ,p_month1_max_contribution in number default hr_api.g_number
1052: ,p_month2 in varchar2 default hr_api.g_varchar2
1053: ,p_month2_min_contribution in number default hr_api.g_number
1054: ,p_month2_max_contribution in number default hr_api.g_number
1055: ,p_employee_contribution in number default hr_api.g_number
1056: ,p_contribution_level_type in varchar2 default hr_api.g_varchar2

Line 1053: ,p_month2_min_contribution in number default hr_api.g_number

1049: ,p_month1 in varchar2 default hr_api.g_varchar2
1050: ,p_month1_min_contribution in number default hr_api.g_number
1051: ,p_month1_max_contribution in number default hr_api.g_number
1052: ,p_month2 in varchar2 default hr_api.g_varchar2
1053: ,p_month2_min_contribution in number default hr_api.g_number
1054: ,p_month2_max_contribution in number default hr_api.g_number
1055: ,p_employee_contribution in number default hr_api.g_number
1056: ,p_contribution_level_type in varchar2 default hr_api.g_varchar2
1057: ,p_effective_start_date out nocopy date

Line 1054: ,p_month2_max_contribution in number default hr_api.g_number

1050: ,p_month1_min_contribution in number default hr_api.g_number
1051: ,p_month1_max_contribution in number default hr_api.g_number
1052: ,p_month2 in varchar2 default hr_api.g_varchar2
1053: ,p_month2_min_contribution in number default hr_api.g_number
1054: ,p_month2_max_contribution in number default hr_api.g_number
1055: ,p_employee_contribution in number default hr_api.g_number
1056: ,p_contribution_level_type in varchar2 default hr_api.g_varchar2
1057: ,p_effective_start_date out nocopy date
1058: ,p_effective_end_date out nocopy date

Line 1055: ,p_employee_contribution in number default hr_api.g_number

1051: ,p_month1_max_contribution in number default hr_api.g_number
1052: ,p_month2 in varchar2 default hr_api.g_varchar2
1053: ,p_month2_min_contribution in number default hr_api.g_number
1054: ,p_month2_max_contribution in number default hr_api.g_number
1055: ,p_employee_contribution in number default hr_api.g_number
1056: ,p_contribution_level_type in varchar2 default hr_api.g_varchar2
1057: ,p_effective_start_date out nocopy date
1058: ,p_effective_end_date out nocopy date
1059: ) is

Line 1056: ,p_contribution_level_type in varchar2 default hr_api.g_varchar2

1052: ,p_month2 in varchar2 default hr_api.g_varchar2
1053: ,p_month2_min_contribution in number default hr_api.g_number
1054: ,p_month2_max_contribution in number default hr_api.g_number
1055: ,p_employee_contribution in number default hr_api.g_number
1056: ,p_contribution_level_type in varchar2 default hr_api.g_varchar2
1057: ,p_effective_start_date out nocopy date
1058: ,p_effective_end_date out nocopy date
1059: ) is
1060: --