DBA Data[Home] [Help]

APPS.PAY_PAY_UPD dependencies on HR_API

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

67: --
68: Begin
69: hr_utility.set_location('Entering:'||l_proc, 5);
70: --
71: If (p_datetrack_mode = hr_api.g_correction) then
72: --
73: hr_utility.set_location(l_proc, 10);
74: hr_utility.trace('In CORRECTION , p_effective_date : '||to_char(p_effective_date));
75: --

Line 198: When hr_api.check_integrity_violated Then

194: End If;
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 15);
197: Exception
198: When hr_api.check_integrity_violated Then
199: -- A check constraint has been violated
200: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
201: pay_pay_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

198: When hr_api.check_integrity_violated Then
199: -- A check constraint has been violated
200: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
201: pay_pay_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.unique_integrity_violated Then
204: -- Unique integrity has been violated
205: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
206: pay_pay_shd.constraint_error

Line 203: When hr_api.unique_integrity_violated Then

199: -- A check constraint has been violated
200: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
201: pay_pay_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.unique_integrity_violated Then
204: -- Unique integrity has been violated
205: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
206: pay_pay_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

203: When hr_api.unique_integrity_violated Then
204: -- Unique integrity has been violated
205: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
206: pay_pay_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When Others Then
209: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
210: Raise;
211: End dt_update_dml;

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

320: l_dummy_version_number number;
321: --
322: Begin
323: hr_utility.set_location('Entering:'||l_proc, 5);
324: If (p_datetrack_mode <> hr_api.g_correction) then
325: --
326: -- Update the current effective end date
327: --
328: pay_pay_shd.upd_effective_end_date

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

333: ,p_validation_end_date => p_validation_end_date
334: ,p_object_version_number => l_dummy_version_number
335: );
336: --
337: If (p_datetrack_mode = hr_api.g_update_override) then
338: --
339: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
340: -- delete any future rows
341: --

Line 725: when hr_api.cannot_find_prog_unit then

721: );
722: --
723: exception
724: --
725: when hr_api.cannot_find_prog_unit then
726: --
727: hr_api.cannot_find_prog_unit_error
728: (p_module_name => 'PAY_ALL_PAYROLLS_F'
729: ,p_hook_type => 'AU');

Line 727: hr_api.cannot_find_prog_unit_error

723: exception
724: --
725: when hr_api.cannot_find_prog_unit then
726: --
727: hr_api.cannot_find_prog_unit_error
728: (p_module_name => 'PAY_ALL_PAYROLLS_F'
729: ,p_hook_type => 'AU');
730: --
731: end;

Line 791: If (p_rec.default_payment_method_id = hr_api.g_number) then

787: -- p_rec plsql record structure
788: -- to see if a system default is being used. If a system default
789: -- is being used then we must set to the 'current' argument value.
790: --
791: If (p_rec.default_payment_method_id = hr_api.g_number) then
792: --
793: p_rec.default_payment_method_id :=
794: pay_pay_shd.g_old_rec.default_payment_method_id;
795: --

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

794: pay_pay_shd.g_old_rec.default_payment_method_id;
795: --
796: End If;
797: --
798: If (p_rec.business_group_id = hr_api.g_number) then
799: --
800: p_rec.business_group_id := pay_pay_shd.g_old_rec.business_group_id;
801: --
802: End if;

Line 804: If (p_rec.consolidation_set_id = hr_api.g_number) then

800: p_rec.business_group_id := pay_pay_shd.g_old_rec.business_group_id;
801: --
802: End if;
803: --
804: If (p_rec.consolidation_set_id = hr_api.g_number) then
805: --
806: p_rec.consolidation_set_id := pay_pay_shd.g_old_rec.consolidation_set_id;
807: --
808: End If;

Line 810: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then

806: p_rec.consolidation_set_id := pay_pay_shd.g_old_rec.consolidation_set_id;
807: --
808: End If;
809: --
810: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
811: --
812: p_rec.cost_allocation_keyflex_id :=
813: pay_pay_shd.g_old_rec.cost_allocation_keyflex_id;
814: --

Line 817: If (p_rec.suspense_account_keyflex_id = hr_api.g_number) then

813: pay_pay_shd.g_old_rec.cost_allocation_keyflex_id;
814: --
815: End If;
816: --
817: If (p_rec.suspense_account_keyflex_id = hr_api.g_number) then
818: --
819: p_rec.suspense_account_keyflex_id :=
820: pay_pay_shd.g_old_rec.suspense_account_keyflex_id;
821: --

Line 824: If (p_rec.gl_set_of_books_id = hr_api.g_number) then

820: pay_pay_shd.g_old_rec.suspense_account_keyflex_id;
821: --
822: End If;
823: --
824: If (p_rec.gl_set_of_books_id = hr_api.g_number) then
825: --
826: p_rec.gl_set_of_books_id :=
827: pay_pay_shd.g_old_rec.gl_set_of_books_id;
828: --

Line 831: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then

827: pay_pay_shd.g_old_rec.gl_set_of_books_id;
828: --
829: End If;
830: --
831: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
832: --
833: p_rec.soft_coding_keyflex_id :=
834: pay_pay_shd.g_old_rec.soft_coding_keyflex_id;
835: --

Line 838: If (p_rec.period_type = hr_api.g_varchar2) then

834: pay_pay_shd.g_old_rec.soft_coding_keyflex_id;
835: --
836: End If;
837: --
838: If (p_rec.period_type = hr_api.g_varchar2) then
839: --
840: p_rec.period_type :=
841: pay_pay_shd.g_old_rec.period_type;
842: --

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

841: pay_pay_shd.g_old_rec.period_type;
842: --
843: End If;
844: --
845: If (p_rec.organization_id = hr_api.g_number) then
846: --
847: p_rec.organization_id := pay_pay_shd.g_old_rec.organization_id;
848: --
849: End If;

Line 851: If (p_rec.cut_off_date_offset = hr_api.g_number) then

847: p_rec.organization_id := pay_pay_shd.g_old_rec.organization_id;
848: --
849: End If;
850: --
851: If (p_rec.cut_off_date_offset = hr_api.g_number) then
852: --
853: p_rec.cut_off_date_offset := pay_pay_shd.g_old_rec.cut_off_date_offset;
854: --
855: End If;

Line 857: If (p_rec.direct_deposit_date_offset = hr_api.g_number) then

853: p_rec.cut_off_date_offset := pay_pay_shd.g_old_rec.cut_off_date_offset;
854: --
855: End If;
856: --
857: If (p_rec.direct_deposit_date_offset = hr_api.g_number) then
858: --
859: p_rec.direct_deposit_date_offset :=
860: pay_pay_shd.g_old_rec.direct_deposit_date_offset;
861: --

Line 864: If (p_rec.first_period_end_date = hr_api.g_date) then

860: pay_pay_shd.g_old_rec.direct_deposit_date_offset;
861: --
862: End If;
863: --
864: If (p_rec.first_period_end_date = hr_api.g_date) then
865: --
866: p_rec.first_period_end_date :=
867: pay_pay_shd.g_old_rec.first_period_end_date;
868: --

Line 870: If (p_rec.negative_pay_allowed_flag = hr_api.g_varchar2) then

866: p_rec.first_period_end_date :=
867: pay_pay_shd.g_old_rec.first_period_end_date;
868: --
869: End If;
870: If (p_rec.negative_pay_allowed_flag = hr_api.g_varchar2) then
871: --
872: p_rec.negative_pay_allowed_flag :=
873: pay_pay_shd.g_old_rec.negative_pay_allowed_flag;
874: --

Line 876: If (p_rec.number_of_years = hr_api.g_number) then

872: p_rec.negative_pay_allowed_flag :=
873: pay_pay_shd.g_old_rec.negative_pay_allowed_flag;
874: --
875: End If;
876: If (p_rec.number_of_years = hr_api.g_number) then
877: --
878: p_rec.number_of_years := pay_pay_shd.g_old_rec.number_of_years;
879: --
880: End If;

Line 882: If (p_rec.pay_advice_date_offset = hr_api.g_number) then

878: p_rec.number_of_years := pay_pay_shd.g_old_rec.number_of_years;
879: --
880: End If;
881: --
882: If (p_rec.pay_advice_date_offset = hr_api.g_number) then
883: --
884: p_rec.pay_advice_date_offset :=
885: pay_pay_shd.g_old_rec.pay_advice_date_offset;
886: --

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

885: pay_pay_shd.g_old_rec.pay_advice_date_offset;
886: --
887: End If;
888: --
889: If (p_rec.pay_date_offset = hr_api.g_number) then
890: --
891: p_rec.pay_date_offset := pay_pay_shd.g_old_rec.pay_date_offset;
892: --
893: End If;

Line 895: If (p_rec.payroll_name = hr_api.g_varchar2) then

891: p_rec.pay_date_offset := pay_pay_shd.g_old_rec.pay_date_offset;
892: --
893: End If;
894: --
895: If (p_rec.payroll_name = hr_api.g_varchar2) then
896: --
897: p_rec.payroll_name := pay_pay_shd.g_old_rec.payroll_name;
898: --
899: End If;

Line 901: If (p_rec.workload_shifting_level = hr_api.g_varchar2) then

897: p_rec.payroll_name := pay_pay_shd.g_old_rec.payroll_name;
898: --
899: End If;
900: --
901: If (p_rec.workload_shifting_level = hr_api.g_varchar2) then
902: --
903: p_rec.workload_shifting_level :=
904: pay_pay_shd.g_old_rec.workload_shifting_level;
905: --

Line 908: If (p_rec.comment_id = hr_api.g_number) then

904: pay_pay_shd.g_old_rec.workload_shifting_level;
905: --
906: End If;
907: --
908: If (p_rec.comment_id = hr_api.g_number) then
909: --
910: p_rec.comment_id := pay_pay_shd.g_old_rec.comment_id;
911: --
912: End If;

Line 914: If (p_rec.comments = hr_api.g_varchar2) then

910: p_rec.comment_id := pay_pay_shd.g_old_rec.comment_id;
911: --
912: End If;
913: --
914: If (p_rec.comments = hr_api.g_varchar2) then
915: --
916: p_rec.comments := pay_pay_shd.g_old_rec.comments;
917: --
918: End If;

Line 920: If (p_rec.midpoint_offset = hr_api.g_number) then

916: p_rec.comments := pay_pay_shd.g_old_rec.comments;
917: --
918: End If;
919: --
920: If (p_rec.midpoint_offset = hr_api.g_number) then
921: --
922: p_rec.midpoint_offset := pay_pay_shd.g_old_rec.midpoint_offset;
923: --
924: End If;

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

922: p_rec.midpoint_offset := pay_pay_shd.g_old_rec.midpoint_offset;
923: --
924: End If;
925: --
926: If (p_rec.attribute_category = hr_api.g_varchar2) then
927: --
928: p_rec.attribute_category := pay_pay_shd.g_old_rec.attribute_category;
929: --
930: End If;

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

928: p_rec.attribute_category := pay_pay_shd.g_old_rec.attribute_category;
929: --
930: End If;
931: --
932: If (p_rec.attribute1 = hr_api.g_varchar2) then
933: --
934: p_rec.attribute1 := pay_pay_shd.g_old_rec.attribute1;
935: --
936: End If;

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

934: p_rec.attribute1 := pay_pay_shd.g_old_rec.attribute1;
935: --
936: End If;
937: --
938: If (p_rec.attribute2 = hr_api.g_varchar2) then
939: --
940: p_rec.attribute2 := pay_pay_shd.g_old_rec.attribute2;
941: --
942: End If;

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

940: p_rec.attribute2 := pay_pay_shd.g_old_rec.attribute2;
941: --
942: End If;
943: --
944: If (p_rec.attribute3 = hr_api.g_varchar2) then
945: --
946: p_rec.attribute3 := pay_pay_shd.g_old_rec.attribute3;
947: --
948: End If;

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

946: p_rec.attribute3 := pay_pay_shd.g_old_rec.attribute3;
947: --
948: End If;
949: --
950: If (p_rec.attribute4 = hr_api.g_varchar2) then
951: --
952: p_rec.attribute4 := pay_pay_shd.g_old_rec.attribute4;
953: --
954: End If;

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

952: p_rec.attribute4 := pay_pay_shd.g_old_rec.attribute4;
953: --
954: End If;
955: --
956: If (p_rec.attribute5 = hr_api.g_varchar2) then
957: --
958: p_rec.attribute5 := pay_pay_shd.g_old_rec.attribute5;
959: --
960: End If;

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

958: p_rec.attribute5 := pay_pay_shd.g_old_rec.attribute5;
959: --
960: End If;
961: --
962: If (p_rec.attribute6 = hr_api.g_varchar2) then
963: --
964: p_rec.attribute6 := pay_pay_shd.g_old_rec.attribute6;
965: --
966: End If;

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

964: p_rec.attribute6 := pay_pay_shd.g_old_rec.attribute6;
965: --
966: End If;
967: --
968: If (p_rec.attribute7 = hr_api.g_varchar2) then
969: --
970: p_rec.attribute7 := pay_pay_shd.g_old_rec.attribute7;
971: --
972: End If;

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

970: p_rec.attribute7 := pay_pay_shd.g_old_rec.attribute7;
971: --
972: End If;
973: --
974: If (p_rec.attribute8 = hr_api.g_varchar2) then
975: --
976: p_rec.attribute8 := pay_pay_shd.g_old_rec.attribute8;
977: --
978: End If;

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

976: p_rec.attribute8 := pay_pay_shd.g_old_rec.attribute8;
977: --
978: End If;
979: --
980: If (p_rec.attribute9 = hr_api.g_varchar2) then
981: --
982: p_rec.attribute9 := pay_pay_shd.g_old_rec.attribute9;
983: --
984: End If;

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

982: p_rec.attribute9 := pay_pay_shd.g_old_rec.attribute9;
983: --
984: End If;
985: --
986: If (p_rec.attribute10 = hr_api.g_varchar2) then
987: --
988: p_rec.attribute10 := pay_pay_shd.g_old_rec.attribute10;
989: --
990: End If;

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

988: p_rec.attribute10 := pay_pay_shd.g_old_rec.attribute10;
989: --
990: End If;
991: --
992: If (p_rec.attribute11 = hr_api.g_varchar2) then
993: --
994: p_rec.attribute11 := pay_pay_shd.g_old_rec.attribute11;
995: --
996: End If;

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

994: p_rec.attribute11 := pay_pay_shd.g_old_rec.attribute11;
995: --
996: End If;
997: --
998: If (p_rec.attribute12 = hr_api.g_varchar2) then
999: --
1000: p_rec.attribute12 := pay_pay_shd.g_old_rec.attribute12;
1001: --
1002: End If;

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

1000: p_rec.attribute12 := pay_pay_shd.g_old_rec.attribute12;
1001: --
1002: End If;
1003: --
1004: If (p_rec.attribute13 = hr_api.g_varchar2) then
1005: --
1006: p_rec.attribute13 := pay_pay_shd.g_old_rec.attribute13;
1007: --
1008: End If;

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

1006: p_rec.attribute13 := pay_pay_shd.g_old_rec.attribute13;
1007: --
1008: End If;
1009: --
1010: If (p_rec.attribute14 = hr_api.g_varchar2) then
1011: --
1012: p_rec.attribute14 := pay_pay_shd.g_old_rec.attribute14;
1013: --
1014: End If;

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

1012: p_rec.attribute14 := pay_pay_shd.g_old_rec.attribute14;
1013: --
1014: End If;
1015: --
1016: If (p_rec.attribute15 = hr_api.g_varchar2) then
1017: --
1018: p_rec.attribute15 := pay_pay_shd.g_old_rec.attribute15;
1019: --
1020: End If;

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

1018: p_rec.attribute15 := pay_pay_shd.g_old_rec.attribute15;
1019: --
1020: End If;
1021: --
1022: If (p_rec.attribute16 = hr_api.g_varchar2) then
1023: --
1024: p_rec.attribute16 := pay_pay_shd.g_old_rec.attribute16;
1025: --
1026: End If;

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

1023: --
1024: p_rec.attribute16 := pay_pay_shd.g_old_rec.attribute16;
1025: --
1026: End If;
1027: If (p_rec.attribute17 = hr_api.g_varchar2) then
1028: --
1029: p_rec.attribute17 := pay_pay_shd.g_old_rec.attribute17;
1030: --
1031: End If;

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

1029: p_rec.attribute17 := pay_pay_shd.g_old_rec.attribute17;
1030: --
1031: End If;
1032: --
1033: If (p_rec.attribute18 = hr_api.g_varchar2) then
1034: --
1035: p_rec.attribute18 := pay_pay_shd.g_old_rec.attribute18;
1036: --
1037: End If;

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

1035: p_rec.attribute18 := pay_pay_shd.g_old_rec.attribute18;
1036: --
1037: End If;
1038: --
1039: If (p_rec.attribute19 = hr_api.g_varchar2) then
1040: --
1041: p_rec.attribute19 := pay_pay_shd.g_old_rec.attribute19;
1042: --
1043: End If;

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

1041: p_rec.attribute19 := pay_pay_shd.g_old_rec.attribute19;
1042: --
1043: End If;
1044: --
1045: If (p_rec.attribute20 = hr_api.g_varchar2) then
1046: --
1047: p_rec.attribute20 := pay_pay_shd.g_old_rec.attribute20;
1048: --
1049: End If;

Line 1051: If (p_rec.arrears_flag = hr_api.g_varchar2) then

1047: p_rec.attribute20 := pay_pay_shd.g_old_rec.attribute20;
1048: --
1049: End If;
1050: --
1051: If (p_rec.arrears_flag = hr_api.g_varchar2) then
1052: --
1053: p_rec.arrears_flag := pay_pay_shd.g_old_rec.arrears_flag;
1054: --
1055: End If;

Line 1057: If (p_rec.payroll_type = hr_api.g_varchar2) then

1053: p_rec.arrears_flag := pay_pay_shd.g_old_rec.arrears_flag;
1054: --
1055: End If;
1056: --
1057: If (p_rec.payroll_type = hr_api.g_varchar2) then
1058: --
1059: p_rec.payroll_type := pay_pay_shd.g_old_rec.payroll_type;
1060: --
1061: End If;

Line 1063: If (p_rec.prl_information_category = hr_api.g_varchar2) then

1059: p_rec.payroll_type := pay_pay_shd.g_old_rec.payroll_type;
1060: --
1061: End If;
1062: --
1063: If (p_rec.prl_information_category = hr_api.g_varchar2) then
1064: --
1065: p_rec.prl_information_category :=
1066: pay_pay_shd.g_old_rec.prl_information_category;
1067: --

Line 1070: If (p_rec.prl_information1 = hr_api.g_varchar2) then

1066: pay_pay_shd.g_old_rec.prl_information_category;
1067: --
1068: End If;
1069: --
1070: If (p_rec.prl_information1 = hr_api.g_varchar2) then
1071: --
1072: p_rec.prl_information1 := pay_pay_shd.g_old_rec.prl_information1;
1073: --
1074: End If;

Line 1076: If (p_rec.prl_information2 = hr_api.g_varchar2) then

1072: p_rec.prl_information1 := pay_pay_shd.g_old_rec.prl_information1;
1073: --
1074: End If;
1075: --
1076: If (p_rec.prl_information2 = hr_api.g_varchar2) then
1077: --
1078: p_rec.prl_information2 := pay_pay_shd.g_old_rec.prl_information2;
1079: --
1080: End If;

Line 1082: If (p_rec.prl_information3 = hr_api.g_varchar2) then

1078: p_rec.prl_information2 := pay_pay_shd.g_old_rec.prl_information2;
1079: --
1080: End If;
1081: --
1082: If (p_rec.prl_information3 = hr_api.g_varchar2) then
1083: --
1084: p_rec.prl_information3 := pay_pay_shd.g_old_rec.prl_information3;
1085: --
1086: End If;

Line 1088: If (p_rec.prl_information4 = hr_api.g_varchar2) then

1084: p_rec.prl_information3 := pay_pay_shd.g_old_rec.prl_information3;
1085: --
1086: End If;
1087: --
1088: If (p_rec.prl_information4 = hr_api.g_varchar2) then
1089: --
1090: p_rec.prl_information4 := pay_pay_shd.g_old_rec.prl_information4;
1091: --
1092: End If;

Line 1094: If (p_rec.prl_information5 = hr_api.g_varchar2) then

1090: p_rec.prl_information4 := pay_pay_shd.g_old_rec.prl_information4;
1091: --
1092: End If;
1093: --
1094: If (p_rec.prl_information5 = hr_api.g_varchar2) then
1095: --
1096: p_rec.prl_information5 := pay_pay_shd.g_old_rec.prl_information5;
1097: --
1098: End If;

Line 1100: If (p_rec.prl_information6 = hr_api.g_varchar2) then

1096: p_rec.prl_information5 := pay_pay_shd.g_old_rec.prl_information5;
1097: --
1098: End If;
1099: --
1100: If (p_rec.prl_information6 = hr_api.g_varchar2) then
1101: --
1102: p_rec.prl_information6 := pay_pay_shd.g_old_rec.prl_information6;
1103: --
1104: End If;

Line 1106: If (p_rec.prl_information7 = hr_api.g_varchar2) then

1102: p_rec.prl_information6 := pay_pay_shd.g_old_rec.prl_information6;
1103: --
1104: End If;
1105: --
1106: If (p_rec.prl_information7 = hr_api.g_varchar2) then
1107: --
1108: p_rec.prl_information7 := pay_pay_shd.g_old_rec.prl_information7;
1109: --
1110: End If;

Line 1111: If (p_rec.prl_information8 = hr_api.g_varchar2) then

1107: --
1108: p_rec.prl_information7 := pay_pay_shd.g_old_rec.prl_information7;
1109: --
1110: End If;
1111: If (p_rec.prl_information8 = hr_api.g_varchar2) then
1112: --
1113: p_rec.prl_information8 := pay_pay_shd.g_old_rec.prl_information8;
1114: --
1115: End If;

Line 1117: If (p_rec.prl_information9 = hr_api.g_varchar2) then

1113: p_rec.prl_information8 := pay_pay_shd.g_old_rec.prl_information8;
1114: --
1115: End If;
1116: --
1117: If (p_rec.prl_information9 = hr_api.g_varchar2) then
1118: --
1119: p_rec.prl_information9 := pay_pay_shd.g_old_rec.prl_information9;
1120: --
1121: End If;

Line 1123: If (p_rec.prl_information10 = hr_api.g_varchar2) then

1119: p_rec.prl_information9 := pay_pay_shd.g_old_rec.prl_information9;
1120: --
1121: End If;
1122: --
1123: If (p_rec.prl_information10 = hr_api.g_varchar2) then
1124: --
1125: p_rec.prl_information10 := pay_pay_shd.g_old_rec.prl_information10;
1126: --
1127: End If;

Line 1129: If (p_rec.prl_information11 = hr_api.g_varchar2) then

1125: p_rec.prl_information10 := pay_pay_shd.g_old_rec.prl_information10;
1126: --
1127: End If;
1128: --
1129: If (p_rec.prl_information11 = hr_api.g_varchar2) then
1130: --
1131: p_rec.prl_information11 := pay_pay_shd.g_old_rec.prl_information11;
1132: --
1133: End If;

Line 1135: If (p_rec.prl_information12 = hr_api.g_varchar2) then

1131: p_rec.prl_information11 := pay_pay_shd.g_old_rec.prl_information11;
1132: --
1133: End If;
1134: --
1135: If (p_rec.prl_information12 = hr_api.g_varchar2) then
1136: --
1137: p_rec.prl_information12 := pay_pay_shd.g_old_rec.prl_information12;
1138: --
1139: End If;

Line 1141: If (p_rec.prl_information13 = hr_api.g_varchar2) then

1137: p_rec.prl_information12 := pay_pay_shd.g_old_rec.prl_information12;
1138: --
1139: End If;
1140: --
1141: If (p_rec.prl_information13 = hr_api.g_varchar2) then
1142: --
1143: p_rec.prl_information13 := pay_pay_shd.g_old_rec.prl_information13;
1144: --
1145: End If;

Line 1147: If (p_rec.prl_information14 = hr_api.g_varchar2) then

1143: p_rec.prl_information13 := pay_pay_shd.g_old_rec.prl_information13;
1144: --
1145: End If;
1146: --
1147: If (p_rec.prl_information14 = hr_api.g_varchar2) then
1148: --
1149: p_rec.prl_information14 := pay_pay_shd.g_old_rec.prl_information14;
1150: --
1151: End If;

Line 1153: If (p_rec.prl_information15 = hr_api.g_varchar2) then

1149: p_rec.prl_information14 := pay_pay_shd.g_old_rec.prl_information14;
1150: --
1151: End If;
1152: --
1153: If (p_rec.prl_information15 = hr_api.g_varchar2) then
1154: --
1155: p_rec.prl_information15 := pay_pay_shd.g_old_rec.prl_information15;
1156: --
1157: End If;

Line 1159: If (p_rec.prl_information16 = hr_api.g_varchar2) then

1155: p_rec.prl_information15 := pay_pay_shd.g_old_rec.prl_information15;
1156: --
1157: End If;
1158: --
1159: If (p_rec.prl_information16 = hr_api.g_varchar2) then
1160: --
1161: p_rec.prl_information16 := pay_pay_shd.g_old_rec.prl_information16;
1162: --
1163: End If;

Line 1165: If (p_rec.prl_information17 = hr_api.g_varchar2) then

1161: p_rec.prl_information16 := pay_pay_shd.g_old_rec.prl_information16;
1162: --
1163: End If;
1164: --
1165: If (p_rec.prl_information17 = hr_api.g_varchar2) then
1166: --
1167: p_rec.prl_information17 := pay_pay_shd.g_old_rec.prl_information17;
1168: --
1169: End If;

Line 1171: If (p_rec.prl_information18 = hr_api.g_varchar2) then

1167: p_rec.prl_information17 := pay_pay_shd.g_old_rec.prl_information17;
1168: --
1169: End If;
1170: --
1171: If (p_rec.prl_information18 = hr_api.g_varchar2) then
1172: --
1173: p_rec.prl_information18 := pay_pay_shd.g_old_rec.prl_information18;
1174: --
1175: End If;

Line 1177: If (p_rec.prl_information19 = hr_api.g_varchar2) then

1173: p_rec.prl_information18 := pay_pay_shd.g_old_rec.prl_information18;
1174: --
1175: End If;
1176: --
1177: If (p_rec.prl_information19 = hr_api.g_varchar2) then
1178: --
1179: p_rec.prl_information19 := pay_pay_shd.g_old_rec.prl_information19;
1180: --
1181: End If;

Line 1183: If (p_rec.prl_information20 = hr_api.g_varchar2) then

1179: p_rec.prl_information19 := pay_pay_shd.g_old_rec.prl_information19;
1180: --
1181: End If;
1182: --
1183: If (p_rec.prl_information20 = hr_api.g_varchar2) then
1184: --
1185: p_rec.prl_information20 := pay_pay_shd.g_old_rec.prl_information20;
1186: --
1187: End If;

Line 1189: If (p_rec.prl_information21 = hr_api.g_varchar2) then

1185: p_rec.prl_information20 := pay_pay_shd.g_old_rec.prl_information20;
1186: --
1187: End If;
1188: --
1189: If (p_rec.prl_information21 = hr_api.g_varchar2) then
1190: --
1191: p_rec.prl_information21 := pay_pay_shd.g_old_rec.prl_information21;
1192: --
1193: End If;

Line 1195: If (p_rec.prl_information22 = hr_api.g_varchar2) then

1191: p_rec.prl_information21 := pay_pay_shd.g_old_rec.prl_information21;
1192: --
1193: End If;
1194: --
1195: If (p_rec.prl_information22 = hr_api.g_varchar2) then
1196: --
1197: p_rec.prl_information22 := pay_pay_shd.g_old_rec.prl_information22;
1198: --
1199: End If;

Line 1201: If (p_rec.prl_information23 = hr_api.g_varchar2) then

1197: p_rec.prl_information22 := pay_pay_shd.g_old_rec.prl_information22;
1198: --
1199: End If;
1200: --
1201: If (p_rec.prl_information23 = hr_api.g_varchar2) then
1202: --
1203: p_rec.prl_information23 := pay_pay_shd.g_old_rec.prl_information23;
1204: --
1205: End If;

Line 1207: If (p_rec.prl_information24 = hr_api.g_varchar2) then

1203: p_rec.prl_information23 := pay_pay_shd.g_old_rec.prl_information23;
1204: --
1205: End If;
1206: --
1207: If (p_rec.prl_information24 = hr_api.g_varchar2) then
1208: --
1209: p_rec.prl_information24 := pay_pay_shd.g_old_rec.prl_information24;
1210: --
1211: End If;

Line 1213: If (p_rec.prl_information25 = hr_api.g_varchar2) then

1209: p_rec.prl_information24 := pay_pay_shd.g_old_rec.prl_information24;
1210: --
1211: End If;
1212: --
1213: If (p_rec.prl_information25 = hr_api.g_varchar2) then
1214: --
1215: p_rec.prl_information25 := pay_pay_shd.g_old_rec.prl_information25;
1216: --
1217: End If;

Line 1219: If (p_rec.prl_information26 = hr_api.g_varchar2) then

1215: p_rec.prl_information25 := pay_pay_shd.g_old_rec.prl_information25;
1216: --
1217: End If;
1218: --
1219: If (p_rec.prl_information26 = hr_api.g_varchar2) then
1220: --
1221: p_rec.prl_information26 := pay_pay_shd.g_old_rec.prl_information26;
1222: --
1223: End If;

Line 1225: If (p_rec.prl_information27 = hr_api.g_varchar2) then

1221: p_rec.prl_information26 := pay_pay_shd.g_old_rec.prl_information26;
1222: --
1223: End If;
1224: --
1225: If (p_rec.prl_information27 = hr_api.g_varchar2) then
1226: --
1227: p_rec.prl_information27 := pay_pay_shd.g_old_rec.prl_information27;
1228: --
1229: End If;

Line 1231: If (p_rec.prl_information28 = hr_api.g_varchar2) then

1227: p_rec.prl_information27 := pay_pay_shd.g_old_rec.prl_information27;
1228: --
1229: End If;
1230: --
1231: If (p_rec.prl_information28 = hr_api.g_varchar2) then
1232: --
1233: p_rec.prl_information28 := pay_pay_shd.g_old_rec.prl_information28;
1234: --
1235: End If;

Line 1237: If (p_rec.prl_information29 = hr_api.g_varchar2) then

1233: p_rec.prl_information28 := pay_pay_shd.g_old_rec.prl_information28;
1234: --
1235: End If;
1236: --
1237: If (p_rec.prl_information29 = hr_api.g_varchar2) then
1238: --
1239: p_rec.prl_information29 := pay_pay_shd.g_old_rec.prl_information29;
1240: --
1241: End If;

Line 1243: If (p_rec.prl_information30 = hr_api.g_varchar2) then

1239: p_rec.prl_information29 := pay_pay_shd.g_old_rec.prl_information29;
1240: --
1241: End If;
1242: --
1243: If (p_rec.prl_information30 = hr_api.g_varchar2) then
1244: --
1245: p_rec.prl_information30 := pay_pay_shd.g_old_rec.prl_information30;
1246: --
1247: End If;

Line 1249: If (p_rec.multi_assignments_flag = hr_api.g_varchar2) then

1245: p_rec.prl_information30 := pay_pay_shd.g_old_rec.prl_information30;
1246: --
1247: End If;
1248: --
1249: If (p_rec.multi_assignments_flag = hr_api.g_varchar2) then
1250: --
1251: p_rec.multi_assignments_flag := pay_pay_shd.g_old_rec.multi_assignments_flag;
1252: --
1253: End If;

Line 1255: If (p_rec.period_reset_years = hr_api.g_varchar2) then

1251: p_rec.multi_assignments_flag := pay_pay_shd.g_old_rec.multi_assignments_flag;
1252: --
1253: End If;
1254: --
1255: If (p_rec.period_reset_years = hr_api.g_varchar2) then
1256: --
1257: p_rec.period_reset_years := pay_pay_shd.g_old_rec.period_reset_years;
1258: --
1259: End If;

Line 1261: IF (p_rec.payslip_view_date_offset = hr_api.g_number) then

1257: p_rec.period_reset_years := pay_pay_shd.g_old_rec.period_reset_years;
1258: --
1259: End If;
1260: --
1261: IF (p_rec.payslip_view_date_offset = hr_api.g_number) then
1262: --
1263: p_rec.payslip_view_date_offset := pay_pay_shd.g_old_rec.payslip_view_date_offset;
1264: --
1265: End If;

Line 1376: ,p_consolidation_set_id in number default hr_api.g_number

1372: -- ----------------------------------------------------------------------------
1373: Procedure upd
1374: (p_effective_date in date
1375: ,p_datetrack_mode in varchar2
1376: ,p_consolidation_set_id in number default hr_api.g_number
1377: ,p_period_type in varchar2 default hr_api.g_varchar2
1378: ,p_cut_off_date_offset in number default hr_api.g_number
1379: ,p_direct_deposit_date_offset in number default hr_api.g_number
1380: ,p_first_period_end_date in date default hr_api.g_date

Line 1377: ,p_period_type in varchar2 default hr_api.g_varchar2

1373: Procedure upd
1374: (p_effective_date in date
1375: ,p_datetrack_mode in varchar2
1376: ,p_consolidation_set_id in number default hr_api.g_number
1377: ,p_period_type in varchar2 default hr_api.g_varchar2
1378: ,p_cut_off_date_offset in number default hr_api.g_number
1379: ,p_direct_deposit_date_offset in number default hr_api.g_number
1380: ,p_first_period_end_date in date default hr_api.g_date
1381: ,p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2

Line 1378: ,p_cut_off_date_offset in number default hr_api.g_number

1374: (p_effective_date in date
1375: ,p_datetrack_mode in varchar2
1376: ,p_consolidation_set_id in number default hr_api.g_number
1377: ,p_period_type in varchar2 default hr_api.g_varchar2
1378: ,p_cut_off_date_offset in number default hr_api.g_number
1379: ,p_direct_deposit_date_offset in number default hr_api.g_number
1380: ,p_first_period_end_date in date default hr_api.g_date
1381: ,p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2
1382: ,p_number_of_years in number default hr_api.g_number

Line 1379: ,p_direct_deposit_date_offset in number default hr_api.g_number

1375: ,p_datetrack_mode in varchar2
1376: ,p_consolidation_set_id in number default hr_api.g_number
1377: ,p_period_type in varchar2 default hr_api.g_varchar2
1378: ,p_cut_off_date_offset in number default hr_api.g_number
1379: ,p_direct_deposit_date_offset in number default hr_api.g_number
1380: ,p_first_period_end_date in date default hr_api.g_date
1381: ,p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2
1382: ,p_number_of_years in number default hr_api.g_number
1383: ,p_pay_advice_date_offset in number default hr_api.g_number

Line 1380: ,p_first_period_end_date in date default hr_api.g_date

1376: ,p_consolidation_set_id in number default hr_api.g_number
1377: ,p_period_type in varchar2 default hr_api.g_varchar2
1378: ,p_cut_off_date_offset in number default hr_api.g_number
1379: ,p_direct_deposit_date_offset in number default hr_api.g_number
1380: ,p_first_period_end_date in date default hr_api.g_date
1381: ,p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2
1382: ,p_number_of_years in number default hr_api.g_number
1383: ,p_pay_advice_date_offset in number default hr_api.g_number
1384: ,p_pay_date_offset in number default hr_api.g_number

Line 1381: ,p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2

1377: ,p_period_type in varchar2 default hr_api.g_varchar2
1378: ,p_cut_off_date_offset in number default hr_api.g_number
1379: ,p_direct_deposit_date_offset in number default hr_api.g_number
1380: ,p_first_period_end_date in date default hr_api.g_date
1381: ,p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2
1382: ,p_number_of_years in number default hr_api.g_number
1383: ,p_pay_advice_date_offset in number default hr_api.g_number
1384: ,p_pay_date_offset in number default hr_api.g_number
1385: ,p_payroll_name in varchar2 default hr_api.g_varchar2

Line 1382: ,p_number_of_years in number default hr_api.g_number

1378: ,p_cut_off_date_offset in number default hr_api.g_number
1379: ,p_direct_deposit_date_offset in number default hr_api.g_number
1380: ,p_first_period_end_date in date default hr_api.g_date
1381: ,p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2
1382: ,p_number_of_years in number default hr_api.g_number
1383: ,p_pay_advice_date_offset in number default hr_api.g_number
1384: ,p_pay_date_offset in number default hr_api.g_number
1385: ,p_payroll_name in varchar2 default hr_api.g_varchar2
1386: ,p_workload_shifting_level in varchar2 default hr_api.g_varchar2

Line 1383: ,p_pay_advice_date_offset in number default hr_api.g_number

1379: ,p_direct_deposit_date_offset in number default hr_api.g_number
1380: ,p_first_period_end_date in date default hr_api.g_date
1381: ,p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2
1382: ,p_number_of_years in number default hr_api.g_number
1383: ,p_pay_advice_date_offset in number default hr_api.g_number
1384: ,p_pay_date_offset in number default hr_api.g_number
1385: ,p_payroll_name in varchar2 default hr_api.g_varchar2
1386: ,p_workload_shifting_level in varchar2 default hr_api.g_varchar2
1387: ,p_default_payment_method_id in number default hr_api.g_number

Line 1384: ,p_pay_date_offset in number default hr_api.g_number

1380: ,p_first_period_end_date in date default hr_api.g_date
1381: ,p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2
1382: ,p_number_of_years in number default hr_api.g_number
1383: ,p_pay_advice_date_offset in number default hr_api.g_number
1384: ,p_pay_date_offset in number default hr_api.g_number
1385: ,p_payroll_name in varchar2 default hr_api.g_varchar2
1386: ,p_workload_shifting_level in varchar2 default hr_api.g_varchar2
1387: ,p_default_payment_method_id in number default hr_api.g_number
1388: ,p_cost_allocation_keyflex_id in number default hr_api.g_number

Line 1385: ,p_payroll_name in varchar2 default hr_api.g_varchar2

1381: ,p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2
1382: ,p_number_of_years in number default hr_api.g_number
1383: ,p_pay_advice_date_offset in number default hr_api.g_number
1384: ,p_pay_date_offset in number default hr_api.g_number
1385: ,p_payroll_name in varchar2 default hr_api.g_varchar2
1386: ,p_workload_shifting_level in varchar2 default hr_api.g_varchar2
1387: ,p_default_payment_method_id in number default hr_api.g_number
1388: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1389: ,p_suspense_account_keyflex_id in number default hr_api.g_number

Line 1386: ,p_workload_shifting_level in varchar2 default hr_api.g_varchar2

1382: ,p_number_of_years in number default hr_api.g_number
1383: ,p_pay_advice_date_offset in number default hr_api.g_number
1384: ,p_pay_date_offset in number default hr_api.g_number
1385: ,p_payroll_name in varchar2 default hr_api.g_varchar2
1386: ,p_workload_shifting_level in varchar2 default hr_api.g_varchar2
1387: ,p_default_payment_method_id in number default hr_api.g_number
1388: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1389: ,p_suspense_account_keyflex_id in number default hr_api.g_number
1390: ,p_gl_set_of_books_id in number default hr_api.g_number

Line 1387: ,p_default_payment_method_id in number default hr_api.g_number

1383: ,p_pay_advice_date_offset in number default hr_api.g_number
1384: ,p_pay_date_offset in number default hr_api.g_number
1385: ,p_payroll_name in varchar2 default hr_api.g_varchar2
1386: ,p_workload_shifting_level in varchar2 default hr_api.g_varchar2
1387: ,p_default_payment_method_id in number default hr_api.g_number
1388: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1389: ,p_suspense_account_keyflex_id in number default hr_api.g_number
1390: ,p_gl_set_of_books_id in number default hr_api.g_number
1391: ,p_soft_coding_keyflex_id in number default hr_api.g_number

Line 1388: ,p_cost_allocation_keyflex_id in number default hr_api.g_number

1384: ,p_pay_date_offset in number default hr_api.g_number
1385: ,p_payroll_name in varchar2 default hr_api.g_varchar2
1386: ,p_workload_shifting_level in varchar2 default hr_api.g_varchar2
1387: ,p_default_payment_method_id in number default hr_api.g_number
1388: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1389: ,p_suspense_account_keyflex_id in number default hr_api.g_number
1390: ,p_gl_set_of_books_id in number default hr_api.g_number
1391: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1392: ,p_organization_id in number default hr_api.g_number

Line 1389: ,p_suspense_account_keyflex_id in number default hr_api.g_number

1385: ,p_payroll_name in varchar2 default hr_api.g_varchar2
1386: ,p_workload_shifting_level in varchar2 default hr_api.g_varchar2
1387: ,p_default_payment_method_id in number default hr_api.g_number
1388: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1389: ,p_suspense_account_keyflex_id in number default hr_api.g_number
1390: ,p_gl_set_of_books_id in number default hr_api.g_number
1391: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1392: ,p_organization_id in number default hr_api.g_number
1393: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1390: ,p_gl_set_of_books_id in number default hr_api.g_number

1386: ,p_workload_shifting_level in varchar2 default hr_api.g_varchar2
1387: ,p_default_payment_method_id in number default hr_api.g_number
1388: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1389: ,p_suspense_account_keyflex_id in number default hr_api.g_number
1390: ,p_gl_set_of_books_id in number default hr_api.g_number
1391: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1392: ,p_organization_id in number default hr_api.g_number
1393: ,p_comments in varchar2 default hr_api.g_varchar2
1394: ,p_midpoint_offset in number default hr_api.g_number

Line 1391: ,p_soft_coding_keyflex_id in number default hr_api.g_number

1387: ,p_default_payment_method_id in number default hr_api.g_number
1388: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1389: ,p_suspense_account_keyflex_id in number default hr_api.g_number
1390: ,p_gl_set_of_books_id in number default hr_api.g_number
1391: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1392: ,p_organization_id in number default hr_api.g_number
1393: ,p_comments in varchar2 default hr_api.g_varchar2
1394: ,p_midpoint_offset in number default hr_api.g_number
1395: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 1392: ,p_organization_id in number default hr_api.g_number

1388: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1389: ,p_suspense_account_keyflex_id in number default hr_api.g_number
1390: ,p_gl_set_of_books_id in number default hr_api.g_number
1391: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1392: ,p_organization_id in number default hr_api.g_number
1393: ,p_comments in varchar2 default hr_api.g_varchar2
1394: ,p_midpoint_offset in number default hr_api.g_number
1395: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1396: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1393: ,p_comments in varchar2 default hr_api.g_varchar2

1389: ,p_suspense_account_keyflex_id in number default hr_api.g_number
1390: ,p_gl_set_of_books_id in number default hr_api.g_number
1391: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1392: ,p_organization_id in number default hr_api.g_number
1393: ,p_comments in varchar2 default hr_api.g_varchar2
1394: ,p_midpoint_offset in number default hr_api.g_number
1395: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1396: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1397: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1394: ,p_midpoint_offset in number default hr_api.g_number

1390: ,p_gl_set_of_books_id in number default hr_api.g_number
1391: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1392: ,p_organization_id in number default hr_api.g_number
1393: ,p_comments in varchar2 default hr_api.g_varchar2
1394: ,p_midpoint_offset in number default hr_api.g_number
1395: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1396: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1397: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1398: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1395: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1391: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1392: ,p_organization_id in number default hr_api.g_number
1393: ,p_comments in varchar2 default hr_api.g_varchar2
1394: ,p_midpoint_offset in number default hr_api.g_number
1395: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1396: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1397: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1398: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1399: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1396: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1392: ,p_organization_id in number default hr_api.g_number
1393: ,p_comments in varchar2 default hr_api.g_varchar2
1394: ,p_midpoint_offset in number default hr_api.g_number
1395: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1396: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1397: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1398: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1399: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1400: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1397: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1393: ,p_comments in varchar2 default hr_api.g_varchar2
1394: ,p_midpoint_offset in number default hr_api.g_number
1395: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1396: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1397: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1398: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1399: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1400: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1401: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1398: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1394: ,p_midpoint_offset in number default hr_api.g_number
1395: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1396: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1397: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1398: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1399: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1400: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1401: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1402: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1399: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1395: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1396: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1397: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1398: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1399: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1400: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1401: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1402: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1403: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1400: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1396: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1397: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1398: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1399: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1400: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1401: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1402: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1403: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1404: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1401: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1397: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1398: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1399: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1400: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1401: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1402: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1403: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1404: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1405: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1402: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1398: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1399: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1400: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1401: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1402: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1403: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1404: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1405: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1406: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1403: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1399: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1400: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1401: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1402: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1403: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1404: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1405: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1406: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1407: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1404: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1400: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1401: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1402: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1403: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1404: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1405: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1406: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1407: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1408: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1405: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1401: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1402: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1403: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1404: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1405: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1406: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1407: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1408: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1409: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1406: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1402: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1403: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1404: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1405: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1406: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1407: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1408: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1409: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1410: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1407: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1403: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1404: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1405: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1406: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1407: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1408: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1409: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1410: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1411: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1408: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1404: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1405: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1406: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1407: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1408: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1409: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1410: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1411: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1412: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1409: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1405: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1406: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1407: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1408: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1409: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1410: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1411: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1412: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1413: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1410: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1406: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1407: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1408: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1409: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1410: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1411: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1412: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1413: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1414: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1411: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1407: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1408: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1409: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1410: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1411: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1412: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1413: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1414: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1415: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1412: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1408: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1409: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1410: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1411: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1412: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1413: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1414: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1415: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1416: ,p_arrears_flag in varchar2 default hr_api.g_varchar2

Line 1413: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1409: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1410: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1411: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1412: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1413: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1414: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1415: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1416: ,p_arrears_flag in varchar2 default hr_api.g_varchar2
1417: ,p_payroll_type in varchar2 default hr_api.g_varchar2

Line 1414: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1410: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1411: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1412: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1413: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1414: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1415: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1416: ,p_arrears_flag in varchar2 default hr_api.g_varchar2
1417: ,p_payroll_type in varchar2 default hr_api.g_varchar2
1418: ,p_prl_information_category in varchar2 default hr_api.g_varchar2

Line 1415: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1411: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1412: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1413: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1414: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1415: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1416: ,p_arrears_flag in varchar2 default hr_api.g_varchar2
1417: ,p_payroll_type in varchar2 default hr_api.g_varchar2
1418: ,p_prl_information_category in varchar2 default hr_api.g_varchar2
1419: ,p_prl_information1 in varchar2 default hr_api.g_varchar2

Line 1416: ,p_arrears_flag in varchar2 default hr_api.g_varchar2

1412: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1413: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1414: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1415: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1416: ,p_arrears_flag in varchar2 default hr_api.g_varchar2
1417: ,p_payroll_type in varchar2 default hr_api.g_varchar2
1418: ,p_prl_information_category in varchar2 default hr_api.g_varchar2
1419: ,p_prl_information1 in varchar2 default hr_api.g_varchar2
1420: ,p_prl_information2 in varchar2 default hr_api.g_varchar2

Line 1417: ,p_payroll_type in varchar2 default hr_api.g_varchar2

1413: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1414: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1415: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1416: ,p_arrears_flag in varchar2 default hr_api.g_varchar2
1417: ,p_payroll_type in varchar2 default hr_api.g_varchar2
1418: ,p_prl_information_category in varchar2 default hr_api.g_varchar2
1419: ,p_prl_information1 in varchar2 default hr_api.g_varchar2
1420: ,p_prl_information2 in varchar2 default hr_api.g_varchar2
1421: ,p_prl_information3 in varchar2 default hr_api.g_varchar2

Line 1418: ,p_prl_information_category in varchar2 default hr_api.g_varchar2

1414: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1415: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1416: ,p_arrears_flag in varchar2 default hr_api.g_varchar2
1417: ,p_payroll_type in varchar2 default hr_api.g_varchar2
1418: ,p_prl_information_category in varchar2 default hr_api.g_varchar2
1419: ,p_prl_information1 in varchar2 default hr_api.g_varchar2
1420: ,p_prl_information2 in varchar2 default hr_api.g_varchar2
1421: ,p_prl_information3 in varchar2 default hr_api.g_varchar2
1422: ,p_prl_information4 in varchar2 default hr_api.g_varchar2

Line 1419: ,p_prl_information1 in varchar2 default hr_api.g_varchar2

1415: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1416: ,p_arrears_flag in varchar2 default hr_api.g_varchar2
1417: ,p_payroll_type in varchar2 default hr_api.g_varchar2
1418: ,p_prl_information_category in varchar2 default hr_api.g_varchar2
1419: ,p_prl_information1 in varchar2 default hr_api.g_varchar2
1420: ,p_prl_information2 in varchar2 default hr_api.g_varchar2
1421: ,p_prl_information3 in varchar2 default hr_api.g_varchar2
1422: ,p_prl_information4 in varchar2 default hr_api.g_varchar2
1423: ,p_prl_information5 in varchar2 default hr_api.g_varchar2

Line 1420: ,p_prl_information2 in varchar2 default hr_api.g_varchar2

1416: ,p_arrears_flag in varchar2 default hr_api.g_varchar2
1417: ,p_payroll_type in varchar2 default hr_api.g_varchar2
1418: ,p_prl_information_category in varchar2 default hr_api.g_varchar2
1419: ,p_prl_information1 in varchar2 default hr_api.g_varchar2
1420: ,p_prl_information2 in varchar2 default hr_api.g_varchar2
1421: ,p_prl_information3 in varchar2 default hr_api.g_varchar2
1422: ,p_prl_information4 in varchar2 default hr_api.g_varchar2
1423: ,p_prl_information5 in varchar2 default hr_api.g_varchar2
1424: ,p_prl_information6 in varchar2 default hr_api.g_varchar2

Line 1421: ,p_prl_information3 in varchar2 default hr_api.g_varchar2

1417: ,p_payroll_type in varchar2 default hr_api.g_varchar2
1418: ,p_prl_information_category in varchar2 default hr_api.g_varchar2
1419: ,p_prl_information1 in varchar2 default hr_api.g_varchar2
1420: ,p_prl_information2 in varchar2 default hr_api.g_varchar2
1421: ,p_prl_information3 in varchar2 default hr_api.g_varchar2
1422: ,p_prl_information4 in varchar2 default hr_api.g_varchar2
1423: ,p_prl_information5 in varchar2 default hr_api.g_varchar2
1424: ,p_prl_information6 in varchar2 default hr_api.g_varchar2
1425: ,p_prl_information7 in varchar2 default hr_api.g_varchar2

Line 1422: ,p_prl_information4 in varchar2 default hr_api.g_varchar2

1418: ,p_prl_information_category in varchar2 default hr_api.g_varchar2
1419: ,p_prl_information1 in varchar2 default hr_api.g_varchar2
1420: ,p_prl_information2 in varchar2 default hr_api.g_varchar2
1421: ,p_prl_information3 in varchar2 default hr_api.g_varchar2
1422: ,p_prl_information4 in varchar2 default hr_api.g_varchar2
1423: ,p_prl_information5 in varchar2 default hr_api.g_varchar2
1424: ,p_prl_information6 in varchar2 default hr_api.g_varchar2
1425: ,p_prl_information7 in varchar2 default hr_api.g_varchar2
1426: ,p_prl_information8 in varchar2 default hr_api.g_varchar2

Line 1423: ,p_prl_information5 in varchar2 default hr_api.g_varchar2

1419: ,p_prl_information1 in varchar2 default hr_api.g_varchar2
1420: ,p_prl_information2 in varchar2 default hr_api.g_varchar2
1421: ,p_prl_information3 in varchar2 default hr_api.g_varchar2
1422: ,p_prl_information4 in varchar2 default hr_api.g_varchar2
1423: ,p_prl_information5 in varchar2 default hr_api.g_varchar2
1424: ,p_prl_information6 in varchar2 default hr_api.g_varchar2
1425: ,p_prl_information7 in varchar2 default hr_api.g_varchar2
1426: ,p_prl_information8 in varchar2 default hr_api.g_varchar2
1427: ,p_prl_information9 in varchar2 default hr_api.g_varchar2

Line 1424: ,p_prl_information6 in varchar2 default hr_api.g_varchar2

1420: ,p_prl_information2 in varchar2 default hr_api.g_varchar2
1421: ,p_prl_information3 in varchar2 default hr_api.g_varchar2
1422: ,p_prl_information4 in varchar2 default hr_api.g_varchar2
1423: ,p_prl_information5 in varchar2 default hr_api.g_varchar2
1424: ,p_prl_information6 in varchar2 default hr_api.g_varchar2
1425: ,p_prl_information7 in varchar2 default hr_api.g_varchar2
1426: ,p_prl_information8 in varchar2 default hr_api.g_varchar2
1427: ,p_prl_information9 in varchar2 default hr_api.g_varchar2
1428: ,p_prl_information10 in varchar2 default hr_api.g_varchar2

Line 1425: ,p_prl_information7 in varchar2 default hr_api.g_varchar2

1421: ,p_prl_information3 in varchar2 default hr_api.g_varchar2
1422: ,p_prl_information4 in varchar2 default hr_api.g_varchar2
1423: ,p_prl_information5 in varchar2 default hr_api.g_varchar2
1424: ,p_prl_information6 in varchar2 default hr_api.g_varchar2
1425: ,p_prl_information7 in varchar2 default hr_api.g_varchar2
1426: ,p_prl_information8 in varchar2 default hr_api.g_varchar2
1427: ,p_prl_information9 in varchar2 default hr_api.g_varchar2
1428: ,p_prl_information10 in varchar2 default hr_api.g_varchar2
1429: ,p_prl_information11 in varchar2 default hr_api.g_varchar2

Line 1426: ,p_prl_information8 in varchar2 default hr_api.g_varchar2

1422: ,p_prl_information4 in varchar2 default hr_api.g_varchar2
1423: ,p_prl_information5 in varchar2 default hr_api.g_varchar2
1424: ,p_prl_information6 in varchar2 default hr_api.g_varchar2
1425: ,p_prl_information7 in varchar2 default hr_api.g_varchar2
1426: ,p_prl_information8 in varchar2 default hr_api.g_varchar2
1427: ,p_prl_information9 in varchar2 default hr_api.g_varchar2
1428: ,p_prl_information10 in varchar2 default hr_api.g_varchar2
1429: ,p_prl_information11 in varchar2 default hr_api.g_varchar2
1430: ,p_prl_information12 in varchar2 default hr_api.g_varchar2

Line 1427: ,p_prl_information9 in varchar2 default hr_api.g_varchar2

1423: ,p_prl_information5 in varchar2 default hr_api.g_varchar2
1424: ,p_prl_information6 in varchar2 default hr_api.g_varchar2
1425: ,p_prl_information7 in varchar2 default hr_api.g_varchar2
1426: ,p_prl_information8 in varchar2 default hr_api.g_varchar2
1427: ,p_prl_information9 in varchar2 default hr_api.g_varchar2
1428: ,p_prl_information10 in varchar2 default hr_api.g_varchar2
1429: ,p_prl_information11 in varchar2 default hr_api.g_varchar2
1430: ,p_prl_information12 in varchar2 default hr_api.g_varchar2
1431: ,p_prl_information13 in varchar2 default hr_api.g_varchar2

Line 1428: ,p_prl_information10 in varchar2 default hr_api.g_varchar2

1424: ,p_prl_information6 in varchar2 default hr_api.g_varchar2
1425: ,p_prl_information7 in varchar2 default hr_api.g_varchar2
1426: ,p_prl_information8 in varchar2 default hr_api.g_varchar2
1427: ,p_prl_information9 in varchar2 default hr_api.g_varchar2
1428: ,p_prl_information10 in varchar2 default hr_api.g_varchar2
1429: ,p_prl_information11 in varchar2 default hr_api.g_varchar2
1430: ,p_prl_information12 in varchar2 default hr_api.g_varchar2
1431: ,p_prl_information13 in varchar2 default hr_api.g_varchar2
1432: ,p_prl_information14 in varchar2 default hr_api.g_varchar2

Line 1429: ,p_prl_information11 in varchar2 default hr_api.g_varchar2

1425: ,p_prl_information7 in varchar2 default hr_api.g_varchar2
1426: ,p_prl_information8 in varchar2 default hr_api.g_varchar2
1427: ,p_prl_information9 in varchar2 default hr_api.g_varchar2
1428: ,p_prl_information10 in varchar2 default hr_api.g_varchar2
1429: ,p_prl_information11 in varchar2 default hr_api.g_varchar2
1430: ,p_prl_information12 in varchar2 default hr_api.g_varchar2
1431: ,p_prl_information13 in varchar2 default hr_api.g_varchar2
1432: ,p_prl_information14 in varchar2 default hr_api.g_varchar2
1433: ,p_prl_information15 in varchar2 default hr_api.g_varchar2

Line 1430: ,p_prl_information12 in varchar2 default hr_api.g_varchar2

1426: ,p_prl_information8 in varchar2 default hr_api.g_varchar2
1427: ,p_prl_information9 in varchar2 default hr_api.g_varchar2
1428: ,p_prl_information10 in varchar2 default hr_api.g_varchar2
1429: ,p_prl_information11 in varchar2 default hr_api.g_varchar2
1430: ,p_prl_information12 in varchar2 default hr_api.g_varchar2
1431: ,p_prl_information13 in varchar2 default hr_api.g_varchar2
1432: ,p_prl_information14 in varchar2 default hr_api.g_varchar2
1433: ,p_prl_information15 in varchar2 default hr_api.g_varchar2
1434: ,p_prl_information16 in varchar2 default hr_api.g_varchar2

Line 1431: ,p_prl_information13 in varchar2 default hr_api.g_varchar2

1427: ,p_prl_information9 in varchar2 default hr_api.g_varchar2
1428: ,p_prl_information10 in varchar2 default hr_api.g_varchar2
1429: ,p_prl_information11 in varchar2 default hr_api.g_varchar2
1430: ,p_prl_information12 in varchar2 default hr_api.g_varchar2
1431: ,p_prl_information13 in varchar2 default hr_api.g_varchar2
1432: ,p_prl_information14 in varchar2 default hr_api.g_varchar2
1433: ,p_prl_information15 in varchar2 default hr_api.g_varchar2
1434: ,p_prl_information16 in varchar2 default hr_api.g_varchar2
1435: ,p_prl_information17 in varchar2 default hr_api.g_varchar2

Line 1432: ,p_prl_information14 in varchar2 default hr_api.g_varchar2

1428: ,p_prl_information10 in varchar2 default hr_api.g_varchar2
1429: ,p_prl_information11 in varchar2 default hr_api.g_varchar2
1430: ,p_prl_information12 in varchar2 default hr_api.g_varchar2
1431: ,p_prl_information13 in varchar2 default hr_api.g_varchar2
1432: ,p_prl_information14 in varchar2 default hr_api.g_varchar2
1433: ,p_prl_information15 in varchar2 default hr_api.g_varchar2
1434: ,p_prl_information16 in varchar2 default hr_api.g_varchar2
1435: ,p_prl_information17 in varchar2 default hr_api.g_varchar2
1436: ,p_prl_information18 in varchar2 default hr_api.g_varchar2

Line 1433: ,p_prl_information15 in varchar2 default hr_api.g_varchar2

1429: ,p_prl_information11 in varchar2 default hr_api.g_varchar2
1430: ,p_prl_information12 in varchar2 default hr_api.g_varchar2
1431: ,p_prl_information13 in varchar2 default hr_api.g_varchar2
1432: ,p_prl_information14 in varchar2 default hr_api.g_varchar2
1433: ,p_prl_information15 in varchar2 default hr_api.g_varchar2
1434: ,p_prl_information16 in varchar2 default hr_api.g_varchar2
1435: ,p_prl_information17 in varchar2 default hr_api.g_varchar2
1436: ,p_prl_information18 in varchar2 default hr_api.g_varchar2
1437: ,p_prl_information19 in varchar2 default hr_api.g_varchar2

Line 1434: ,p_prl_information16 in varchar2 default hr_api.g_varchar2

1430: ,p_prl_information12 in varchar2 default hr_api.g_varchar2
1431: ,p_prl_information13 in varchar2 default hr_api.g_varchar2
1432: ,p_prl_information14 in varchar2 default hr_api.g_varchar2
1433: ,p_prl_information15 in varchar2 default hr_api.g_varchar2
1434: ,p_prl_information16 in varchar2 default hr_api.g_varchar2
1435: ,p_prl_information17 in varchar2 default hr_api.g_varchar2
1436: ,p_prl_information18 in varchar2 default hr_api.g_varchar2
1437: ,p_prl_information19 in varchar2 default hr_api.g_varchar2
1438: ,p_prl_information20 in varchar2 default hr_api.g_varchar2

Line 1435: ,p_prl_information17 in varchar2 default hr_api.g_varchar2

1431: ,p_prl_information13 in varchar2 default hr_api.g_varchar2
1432: ,p_prl_information14 in varchar2 default hr_api.g_varchar2
1433: ,p_prl_information15 in varchar2 default hr_api.g_varchar2
1434: ,p_prl_information16 in varchar2 default hr_api.g_varchar2
1435: ,p_prl_information17 in varchar2 default hr_api.g_varchar2
1436: ,p_prl_information18 in varchar2 default hr_api.g_varchar2
1437: ,p_prl_information19 in varchar2 default hr_api.g_varchar2
1438: ,p_prl_information20 in varchar2 default hr_api.g_varchar2
1439: ,p_prl_information21 in varchar2 default hr_api.g_varchar2

Line 1436: ,p_prl_information18 in varchar2 default hr_api.g_varchar2

1432: ,p_prl_information14 in varchar2 default hr_api.g_varchar2
1433: ,p_prl_information15 in varchar2 default hr_api.g_varchar2
1434: ,p_prl_information16 in varchar2 default hr_api.g_varchar2
1435: ,p_prl_information17 in varchar2 default hr_api.g_varchar2
1436: ,p_prl_information18 in varchar2 default hr_api.g_varchar2
1437: ,p_prl_information19 in varchar2 default hr_api.g_varchar2
1438: ,p_prl_information20 in varchar2 default hr_api.g_varchar2
1439: ,p_prl_information21 in varchar2 default hr_api.g_varchar2
1440: ,p_prl_information22 in varchar2 default hr_api.g_varchar2

Line 1437: ,p_prl_information19 in varchar2 default hr_api.g_varchar2

1433: ,p_prl_information15 in varchar2 default hr_api.g_varchar2
1434: ,p_prl_information16 in varchar2 default hr_api.g_varchar2
1435: ,p_prl_information17 in varchar2 default hr_api.g_varchar2
1436: ,p_prl_information18 in varchar2 default hr_api.g_varchar2
1437: ,p_prl_information19 in varchar2 default hr_api.g_varchar2
1438: ,p_prl_information20 in varchar2 default hr_api.g_varchar2
1439: ,p_prl_information21 in varchar2 default hr_api.g_varchar2
1440: ,p_prl_information22 in varchar2 default hr_api.g_varchar2
1441: ,p_prl_information23 in varchar2 default hr_api.g_varchar2

Line 1438: ,p_prl_information20 in varchar2 default hr_api.g_varchar2

1434: ,p_prl_information16 in varchar2 default hr_api.g_varchar2
1435: ,p_prl_information17 in varchar2 default hr_api.g_varchar2
1436: ,p_prl_information18 in varchar2 default hr_api.g_varchar2
1437: ,p_prl_information19 in varchar2 default hr_api.g_varchar2
1438: ,p_prl_information20 in varchar2 default hr_api.g_varchar2
1439: ,p_prl_information21 in varchar2 default hr_api.g_varchar2
1440: ,p_prl_information22 in varchar2 default hr_api.g_varchar2
1441: ,p_prl_information23 in varchar2 default hr_api.g_varchar2
1442: ,p_prl_information24 in varchar2 default hr_api.g_varchar2

Line 1439: ,p_prl_information21 in varchar2 default hr_api.g_varchar2

1435: ,p_prl_information17 in varchar2 default hr_api.g_varchar2
1436: ,p_prl_information18 in varchar2 default hr_api.g_varchar2
1437: ,p_prl_information19 in varchar2 default hr_api.g_varchar2
1438: ,p_prl_information20 in varchar2 default hr_api.g_varchar2
1439: ,p_prl_information21 in varchar2 default hr_api.g_varchar2
1440: ,p_prl_information22 in varchar2 default hr_api.g_varchar2
1441: ,p_prl_information23 in varchar2 default hr_api.g_varchar2
1442: ,p_prl_information24 in varchar2 default hr_api.g_varchar2
1443: ,p_prl_information25 in varchar2 default hr_api.g_varchar2

Line 1440: ,p_prl_information22 in varchar2 default hr_api.g_varchar2

1436: ,p_prl_information18 in varchar2 default hr_api.g_varchar2
1437: ,p_prl_information19 in varchar2 default hr_api.g_varchar2
1438: ,p_prl_information20 in varchar2 default hr_api.g_varchar2
1439: ,p_prl_information21 in varchar2 default hr_api.g_varchar2
1440: ,p_prl_information22 in varchar2 default hr_api.g_varchar2
1441: ,p_prl_information23 in varchar2 default hr_api.g_varchar2
1442: ,p_prl_information24 in varchar2 default hr_api.g_varchar2
1443: ,p_prl_information25 in varchar2 default hr_api.g_varchar2
1444: ,p_prl_information26 in varchar2 default hr_api.g_varchar2

Line 1441: ,p_prl_information23 in varchar2 default hr_api.g_varchar2

1437: ,p_prl_information19 in varchar2 default hr_api.g_varchar2
1438: ,p_prl_information20 in varchar2 default hr_api.g_varchar2
1439: ,p_prl_information21 in varchar2 default hr_api.g_varchar2
1440: ,p_prl_information22 in varchar2 default hr_api.g_varchar2
1441: ,p_prl_information23 in varchar2 default hr_api.g_varchar2
1442: ,p_prl_information24 in varchar2 default hr_api.g_varchar2
1443: ,p_prl_information25 in varchar2 default hr_api.g_varchar2
1444: ,p_prl_information26 in varchar2 default hr_api.g_varchar2
1445: ,p_prl_information27 in varchar2 default hr_api.g_varchar2

Line 1442: ,p_prl_information24 in varchar2 default hr_api.g_varchar2

1438: ,p_prl_information20 in varchar2 default hr_api.g_varchar2
1439: ,p_prl_information21 in varchar2 default hr_api.g_varchar2
1440: ,p_prl_information22 in varchar2 default hr_api.g_varchar2
1441: ,p_prl_information23 in varchar2 default hr_api.g_varchar2
1442: ,p_prl_information24 in varchar2 default hr_api.g_varchar2
1443: ,p_prl_information25 in varchar2 default hr_api.g_varchar2
1444: ,p_prl_information26 in varchar2 default hr_api.g_varchar2
1445: ,p_prl_information27 in varchar2 default hr_api.g_varchar2
1446: ,p_prl_information28 in varchar2 default hr_api.g_varchar2

Line 1443: ,p_prl_information25 in varchar2 default hr_api.g_varchar2

1439: ,p_prl_information21 in varchar2 default hr_api.g_varchar2
1440: ,p_prl_information22 in varchar2 default hr_api.g_varchar2
1441: ,p_prl_information23 in varchar2 default hr_api.g_varchar2
1442: ,p_prl_information24 in varchar2 default hr_api.g_varchar2
1443: ,p_prl_information25 in varchar2 default hr_api.g_varchar2
1444: ,p_prl_information26 in varchar2 default hr_api.g_varchar2
1445: ,p_prl_information27 in varchar2 default hr_api.g_varchar2
1446: ,p_prl_information28 in varchar2 default hr_api.g_varchar2
1447: ,p_prl_information29 in varchar2 default hr_api.g_varchar2

Line 1444: ,p_prl_information26 in varchar2 default hr_api.g_varchar2

1440: ,p_prl_information22 in varchar2 default hr_api.g_varchar2
1441: ,p_prl_information23 in varchar2 default hr_api.g_varchar2
1442: ,p_prl_information24 in varchar2 default hr_api.g_varchar2
1443: ,p_prl_information25 in varchar2 default hr_api.g_varchar2
1444: ,p_prl_information26 in varchar2 default hr_api.g_varchar2
1445: ,p_prl_information27 in varchar2 default hr_api.g_varchar2
1446: ,p_prl_information28 in varchar2 default hr_api.g_varchar2
1447: ,p_prl_information29 in varchar2 default hr_api.g_varchar2
1448: ,p_prl_information30 in varchar2 default hr_api.g_varchar2

Line 1445: ,p_prl_information27 in varchar2 default hr_api.g_varchar2

1441: ,p_prl_information23 in varchar2 default hr_api.g_varchar2
1442: ,p_prl_information24 in varchar2 default hr_api.g_varchar2
1443: ,p_prl_information25 in varchar2 default hr_api.g_varchar2
1444: ,p_prl_information26 in varchar2 default hr_api.g_varchar2
1445: ,p_prl_information27 in varchar2 default hr_api.g_varchar2
1446: ,p_prl_information28 in varchar2 default hr_api.g_varchar2
1447: ,p_prl_information29 in varchar2 default hr_api.g_varchar2
1448: ,p_prl_information30 in varchar2 default hr_api.g_varchar2
1449: ,p_multi_assignments_flag in varchar2 default hr_api.g_varchar2

Line 1446: ,p_prl_information28 in varchar2 default hr_api.g_varchar2

1442: ,p_prl_information24 in varchar2 default hr_api.g_varchar2
1443: ,p_prl_information25 in varchar2 default hr_api.g_varchar2
1444: ,p_prl_information26 in varchar2 default hr_api.g_varchar2
1445: ,p_prl_information27 in varchar2 default hr_api.g_varchar2
1446: ,p_prl_information28 in varchar2 default hr_api.g_varchar2
1447: ,p_prl_information29 in varchar2 default hr_api.g_varchar2
1448: ,p_prl_information30 in varchar2 default hr_api.g_varchar2
1449: ,p_multi_assignments_flag in varchar2 default hr_api.g_varchar2
1450: ,p_period_reset_years in varchar2 default hr_api.g_varchar2

Line 1447: ,p_prl_information29 in varchar2 default hr_api.g_varchar2

1443: ,p_prl_information25 in varchar2 default hr_api.g_varchar2
1444: ,p_prl_information26 in varchar2 default hr_api.g_varchar2
1445: ,p_prl_information27 in varchar2 default hr_api.g_varchar2
1446: ,p_prl_information28 in varchar2 default hr_api.g_varchar2
1447: ,p_prl_information29 in varchar2 default hr_api.g_varchar2
1448: ,p_prl_information30 in varchar2 default hr_api.g_varchar2
1449: ,p_multi_assignments_flag in varchar2 default hr_api.g_varchar2
1450: ,p_period_reset_years in varchar2 default hr_api.g_varchar2
1451:

Line 1448: ,p_prl_information30 in varchar2 default hr_api.g_varchar2

1444: ,p_prl_information26 in varchar2 default hr_api.g_varchar2
1445: ,p_prl_information27 in varchar2 default hr_api.g_varchar2
1446: ,p_prl_information28 in varchar2 default hr_api.g_varchar2
1447: ,p_prl_information29 in varchar2 default hr_api.g_varchar2
1448: ,p_prl_information30 in varchar2 default hr_api.g_varchar2
1449: ,p_multi_assignments_flag in varchar2 default hr_api.g_varchar2
1450: ,p_period_reset_years in varchar2 default hr_api.g_varchar2
1451:
1452: ,p_payslip_view_date_offset in number default hr_api.g_number

Line 1449: ,p_multi_assignments_flag in varchar2 default hr_api.g_varchar2

1445: ,p_prl_information27 in varchar2 default hr_api.g_varchar2
1446: ,p_prl_information28 in varchar2 default hr_api.g_varchar2
1447: ,p_prl_information29 in varchar2 default hr_api.g_varchar2
1448: ,p_prl_information30 in varchar2 default hr_api.g_varchar2
1449: ,p_multi_assignments_flag in varchar2 default hr_api.g_varchar2
1450: ,p_period_reset_years in varchar2 default hr_api.g_varchar2
1451:
1452: ,p_payslip_view_date_offset in number default hr_api.g_number
1453: ,p_payroll_id in out nocopy number -- Added 'out'.

Line 1450: ,p_period_reset_years in varchar2 default hr_api.g_varchar2

1446: ,p_prl_information28 in varchar2 default hr_api.g_varchar2
1447: ,p_prl_information29 in varchar2 default hr_api.g_varchar2
1448: ,p_prl_information30 in varchar2 default hr_api.g_varchar2
1449: ,p_multi_assignments_flag in varchar2 default hr_api.g_varchar2
1450: ,p_period_reset_years in varchar2 default hr_api.g_varchar2
1451:
1452: ,p_payslip_view_date_offset in number default hr_api.g_number
1453: ,p_payroll_id in out nocopy number -- Added 'out'.
1454: ,p_object_version_number in out nocopy number

Line 1452: ,p_payslip_view_date_offset in number default hr_api.g_number

1448: ,p_prl_information30 in varchar2 default hr_api.g_varchar2
1449: ,p_multi_assignments_flag in varchar2 default hr_api.g_varchar2
1450: ,p_period_reset_years in varchar2 default hr_api.g_varchar2
1451:
1452: ,p_payslip_view_date_offset in number default hr_api.g_number
1453: ,p_payroll_id in out nocopy number -- Added 'out'.
1454: ,p_object_version_number in out nocopy number
1455:
1456: ,p_effective_start_date out nocopy date

Line 1476: ,hr_api.g_number

1472: (p_payroll_id
1473: ,null
1474: ,null
1475: ,p_default_payment_method_id
1476: ,hr_api.g_number
1477: ,p_consolidation_set_id
1478: ,p_cost_allocation_keyflex_id
1479: ,p_suspense_account_keyflex_id
1480: ,p_gl_set_of_books_id

Line 1493: ,hr_api.g_number

1489: ,p_pay_advice_date_offset
1490: ,p_pay_date_offset
1491: ,p_payroll_name
1492: ,p_workload_shifting_level
1493: ,hr_api.g_number
1494: ,p_comments
1495: ,p_midpoint_offset
1496: ,p_attribute_category
1497: ,p_attribute1