APPS.PQP_AAT_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 183: When hr_api.check_integrity_violated Then

179: End If;
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 15);
182: Exception
183: When hr_api.check_integrity_violated Then
184: -- A check constraint has been violated
185: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
186: pqp_aat_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

183: When hr_api.check_integrity_violated Then
184: -- A check constraint has been violated
185: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
186: pqp_aat_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated
190: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
191: pqp_aat_shd.constraint_error

Line 188: When hr_api.unique_integrity_violated Then

184: -- A check constraint has been violated
185: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
186: pqp_aat_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated
190: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
191: pqp_aat_shd.constraint_error
192: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated
190: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
191: pqp_aat_shd.constraint_error
192: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
193: When Others Then
194: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
195: Raise;
196: End dt_update_dml;

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

305: l_dummy_version_number number;
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: If (p_datetrack_mode <> hr_api.g_correction) then
310: --
311: -- Update the current effective end date
312: --
313: pqp_aat_shd.upd_effective_end_date

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

318: ,p_validation_end_date => p_validation_end_date
319: ,p_object_version_number => l_dummy_version_number
320: );
321: --
322: If (p_datetrack_mode = hr_api.g_update_override) then
323: --
324: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
325: -- delete any future rows
326: --

Line 793: when hr_api.cannot_find_prog_unit then

789: );
790: --
791: exception
792: --
793: when hr_api.cannot_find_prog_unit then
794: --
795: hr_api.cannot_find_prog_unit_error
796: (p_module_name => 'PQP_ASSIGNMENT_ATTRIBUTES_F'
797: ,p_hook_type => 'AU');

Line 795: hr_api.cannot_find_prog_unit_error

791: exception
792: --
793: when hr_api.cannot_find_prog_unit then
794: --
795: hr_api.cannot_find_prog_unit_error
796: (p_module_name => 'PQP_ASSIGNMENT_ATTRIBUTES_F'
797: ,p_hook_type => 'AU');
798: --
799: end;

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

854: -- p_rec plsql record structure
855: -- to see if a system default is being used. If a system default
856: -- is being used then we must set to the 'current' argument value.
857: --
858: If (p_rec.business_group_id = hr_api.g_number) then
859: p_rec.business_group_id :=
860: pqp_aat_shd.g_old_rec.business_group_id;
861: End If;
862: If (p_rec.assignment_id = hr_api.g_number) then

Line 862: If (p_rec.assignment_id = hr_api.g_number) then

858: If (p_rec.business_group_id = hr_api.g_number) then
859: p_rec.business_group_id :=
860: pqp_aat_shd.g_old_rec.business_group_id;
861: End If;
862: If (p_rec.assignment_id = hr_api.g_number) then
863: p_rec.assignment_id :=
864: pqp_aat_shd.g_old_rec.assignment_id;
865: End If;
866: If (p_rec.contract_type = hr_api.g_varchar2) then

Line 866: If (p_rec.contract_type = hr_api.g_varchar2) then

862: If (p_rec.assignment_id = hr_api.g_number) then
863: p_rec.assignment_id :=
864: pqp_aat_shd.g_old_rec.assignment_id;
865: End If;
866: If (p_rec.contract_type = hr_api.g_varchar2) then
867: p_rec.contract_type :=
868: pqp_aat_shd.g_old_rec.contract_type;
869: End If;
870: If (p_rec.work_pattern = hr_api.g_varchar2) then

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

866: If (p_rec.contract_type = hr_api.g_varchar2) then
867: p_rec.contract_type :=
868: pqp_aat_shd.g_old_rec.contract_type;
869: End If;
870: If (p_rec.work_pattern = hr_api.g_varchar2) then
871: p_rec.work_pattern :=
872: pqp_aat_shd.g_old_rec.work_pattern;
873: End If;
874: If (p_rec.start_day = hr_api.g_varchar2) then

Line 874: If (p_rec.start_day = hr_api.g_varchar2) then

870: If (p_rec.work_pattern = hr_api.g_varchar2) then
871: p_rec.work_pattern :=
872: pqp_aat_shd.g_old_rec.work_pattern;
873: End If;
874: If (p_rec.start_day = hr_api.g_varchar2) then
875: p_rec.start_day :=
876: pqp_aat_shd.g_old_rec.start_day;
877: End If;
878: If (p_rec.primary_company_car = hr_api.g_number) then

Line 878: If (p_rec.primary_company_car = hr_api.g_number) then

874: If (p_rec.start_day = hr_api.g_varchar2) then
875: p_rec.start_day :=
876: pqp_aat_shd.g_old_rec.start_day;
877: End If;
878: If (p_rec.primary_company_car = hr_api.g_number) then
879: p_rec.primary_company_car :=
880: pqp_aat_shd.g_old_rec.primary_company_car;
881: End If;
882: If (p_rec.primary_car_fuel_benefit = hr_api.g_varchar2) then

Line 882: If (p_rec.primary_car_fuel_benefit = hr_api.g_varchar2) then

878: If (p_rec.primary_company_car = hr_api.g_number) then
879: p_rec.primary_company_car :=
880: pqp_aat_shd.g_old_rec.primary_company_car;
881: End If;
882: If (p_rec.primary_car_fuel_benefit = hr_api.g_varchar2) then
883: p_rec.primary_car_fuel_benefit :=
884: pqp_aat_shd.g_old_rec.primary_car_fuel_benefit;
885: End If;
886: If (p_rec.primary_class_1a = hr_api.g_varchar2) then

Line 886: If (p_rec.primary_class_1a = hr_api.g_varchar2) then

882: If (p_rec.primary_car_fuel_benefit = hr_api.g_varchar2) then
883: p_rec.primary_car_fuel_benefit :=
884: pqp_aat_shd.g_old_rec.primary_car_fuel_benefit;
885: End If;
886: If (p_rec.primary_class_1a = hr_api.g_varchar2) then
887: p_rec.primary_class_1a :=
888: pqp_aat_shd.g_old_rec.primary_class_1a;
889: End If;
890: If (p_rec.primary_capital_contribution = hr_api.g_number) then

Line 890: If (p_rec.primary_capital_contribution = hr_api.g_number) then

886: If (p_rec.primary_class_1a = hr_api.g_varchar2) then
887: p_rec.primary_class_1a :=
888: pqp_aat_shd.g_old_rec.primary_class_1a;
889: End If;
890: If (p_rec.primary_capital_contribution = hr_api.g_number) then
891: p_rec.primary_capital_contribution :=
892: pqp_aat_shd.g_old_rec.primary_capital_contribution;
893: End If;
894: If (p_rec.primary_private_contribution = hr_api.g_number) then

Line 894: If (p_rec.primary_private_contribution = hr_api.g_number) then

890: If (p_rec.primary_capital_contribution = hr_api.g_number) then
891: p_rec.primary_capital_contribution :=
892: pqp_aat_shd.g_old_rec.primary_capital_contribution;
893: End If;
894: If (p_rec.primary_private_contribution = hr_api.g_number) then
895: p_rec.primary_private_contribution :=
896: pqp_aat_shd.g_old_rec.primary_private_contribution;
897: End If;
898: If (p_rec.secondary_company_car = hr_api.g_number) then

Line 898: If (p_rec.secondary_company_car = hr_api.g_number) then

894: If (p_rec.primary_private_contribution = hr_api.g_number) then
895: p_rec.primary_private_contribution :=
896: pqp_aat_shd.g_old_rec.primary_private_contribution;
897: End If;
898: If (p_rec.secondary_company_car = hr_api.g_number) then
899: p_rec.secondary_company_car :=
900: pqp_aat_shd.g_old_rec.secondary_company_car;
901: End If;
902: If (p_rec.secondary_car_fuel_benefit = hr_api.g_varchar2) then

Line 902: If (p_rec.secondary_car_fuel_benefit = hr_api.g_varchar2) then

898: If (p_rec.secondary_company_car = hr_api.g_number) then
899: p_rec.secondary_company_car :=
900: pqp_aat_shd.g_old_rec.secondary_company_car;
901: End If;
902: If (p_rec.secondary_car_fuel_benefit = hr_api.g_varchar2) then
903: p_rec.secondary_car_fuel_benefit :=
904: pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit;
905: End If;
906: If (p_rec.secondary_class_1a = hr_api.g_varchar2) then

Line 906: If (p_rec.secondary_class_1a = hr_api.g_varchar2) then

902: If (p_rec.secondary_car_fuel_benefit = hr_api.g_varchar2) then
903: p_rec.secondary_car_fuel_benefit :=
904: pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit;
905: End If;
906: If (p_rec.secondary_class_1a = hr_api.g_varchar2) then
907: p_rec.secondary_class_1a :=
908: pqp_aat_shd.g_old_rec.secondary_class_1a;
909: End If;
910: If (p_rec.secondary_capital_contribution = hr_api.g_number) then

Line 910: If (p_rec.secondary_capital_contribution = hr_api.g_number) then

906: If (p_rec.secondary_class_1a = hr_api.g_varchar2) then
907: p_rec.secondary_class_1a :=
908: pqp_aat_shd.g_old_rec.secondary_class_1a;
909: End If;
910: If (p_rec.secondary_capital_contribution = hr_api.g_number) then
911: p_rec.secondary_capital_contribution :=
912: pqp_aat_shd.g_old_rec.secondary_capital_contribution;
913: End If;
914: If (p_rec.secondary_private_contribution = hr_api.g_number) then

Line 914: If (p_rec.secondary_private_contribution = hr_api.g_number) then

910: If (p_rec.secondary_capital_contribution = hr_api.g_number) then
911: p_rec.secondary_capital_contribution :=
912: pqp_aat_shd.g_old_rec.secondary_capital_contribution;
913: End If;
914: If (p_rec.secondary_private_contribution = hr_api.g_number) then
915: p_rec.secondary_private_contribution :=
916: pqp_aat_shd.g_old_rec.secondary_private_contribution;
917: End If;
918: If (p_rec.company_car_calc_method = hr_api.g_varchar2) then

Line 918: If (p_rec.company_car_calc_method = hr_api.g_varchar2) then

914: If (p_rec.secondary_private_contribution = hr_api.g_number) then
915: p_rec.secondary_private_contribution :=
916: pqp_aat_shd.g_old_rec.secondary_private_contribution;
917: End If;
918: If (p_rec.company_car_calc_method = hr_api.g_varchar2) then
919: p_rec.company_car_calc_method :=
920: pqp_aat_shd.g_old_rec.company_car_calc_method;
921: End If;
922: If (p_rec.company_car_rates_table_id = hr_api.g_number) then

Line 922: If (p_rec.company_car_rates_table_id = hr_api.g_number) then

918: If (p_rec.company_car_calc_method = hr_api.g_varchar2) then
919: p_rec.company_car_calc_method :=
920: pqp_aat_shd.g_old_rec.company_car_calc_method;
921: End If;
922: If (p_rec.company_car_rates_table_id = hr_api.g_number) then
923: p_rec.company_car_rates_table_id :=
924: pqp_aat_shd.g_old_rec.company_car_rates_table_id;
925: End If;
926: If (p_rec.company_car_secondary_table_id = hr_api.g_number) then

Line 926: If (p_rec.company_car_secondary_table_id = hr_api.g_number) then

922: If (p_rec.company_car_rates_table_id = hr_api.g_number) then
923: p_rec.company_car_rates_table_id :=
924: pqp_aat_shd.g_old_rec.company_car_rates_table_id;
925: End If;
926: If (p_rec.company_car_secondary_table_id = hr_api.g_number) then
927: p_rec.company_car_secondary_table_id :=
928: pqp_aat_shd.g_old_rec.company_car_secondary_table_id;
929: End If;
930: If (p_rec.private_car = hr_api.g_number) then

Line 930: If (p_rec.private_car = hr_api.g_number) then

926: If (p_rec.company_car_secondary_table_id = hr_api.g_number) then
927: p_rec.company_car_secondary_table_id :=
928: pqp_aat_shd.g_old_rec.company_car_secondary_table_id;
929: End If;
930: If (p_rec.private_car = hr_api.g_number) then
931: p_rec.private_car :=
932: pqp_aat_shd.g_old_rec.private_car;
933: End If;
934: If (p_rec.private_car_calc_method = hr_api.g_varchar2) then

Line 934: If (p_rec.private_car_calc_method = hr_api.g_varchar2) then

930: If (p_rec.private_car = hr_api.g_number) then
931: p_rec.private_car :=
932: pqp_aat_shd.g_old_rec.private_car;
933: End If;
934: If (p_rec.private_car_calc_method = hr_api.g_varchar2) then
935: p_rec.private_car_calc_method :=
936: pqp_aat_shd.g_old_rec.private_car_calc_method;
937: End If;
938: If (p_rec.private_car_rates_table_id = hr_api.g_number) then

Line 938: If (p_rec.private_car_rates_table_id = hr_api.g_number) then

934: If (p_rec.private_car_calc_method = hr_api.g_varchar2) then
935: p_rec.private_car_calc_method :=
936: pqp_aat_shd.g_old_rec.private_car_calc_method;
937: End If;
938: If (p_rec.private_car_rates_table_id = hr_api.g_number) then
939: p_rec.private_car_rates_table_id :=
940: pqp_aat_shd.g_old_rec.private_car_rates_table_id;
941: End If;
942: If (p_rec.private_car_essential_table_id = hr_api.g_number) then

Line 942: If (p_rec.private_car_essential_table_id = hr_api.g_number) then

938: If (p_rec.private_car_rates_table_id = hr_api.g_number) then
939: p_rec.private_car_rates_table_id :=
940: pqp_aat_shd.g_old_rec.private_car_rates_table_id;
941: End If;
942: If (p_rec.private_car_essential_table_id = hr_api.g_number) then
943: p_rec.private_car_essential_table_id :=
944: pqp_aat_shd.g_old_rec.private_car_essential_table_id;
945: End If;
946: If (p_rec.tp_is_teacher = hr_api.g_varchar2) then

Line 946: If (p_rec.tp_is_teacher = hr_api.g_varchar2) then

942: If (p_rec.private_car_essential_table_id = hr_api.g_number) then
943: p_rec.private_car_essential_table_id :=
944: pqp_aat_shd.g_old_rec.private_car_essential_table_id;
945: End If;
946: If (p_rec.tp_is_teacher = hr_api.g_varchar2) then
947: p_rec.tp_is_teacher :=
948: pqp_aat_shd.g_old_rec.tp_is_teacher;
949: End If;
950: --added for head Teacher seconded location for salary scale calculation

Line 951: If (p_rec.tp_headteacher_grp_code = hr_api.g_number) then

947: p_rec.tp_is_teacher :=
948: pqp_aat_shd.g_old_rec.tp_is_teacher;
949: End If;
950: --added for head Teacher seconded location for salary scale calculation
951: If (p_rec.tp_headteacher_grp_code = hr_api.g_number) then
952: p_rec.tp_headteacher_grp_code :=
953: pqp_aat_shd.g_old_rec.tp_headteacher_grp_code;
954: End If;
955: If (p_rec.tp_safeguarded_grade = hr_api.g_varchar2) then

Line 955: If (p_rec.tp_safeguarded_grade = hr_api.g_varchar2) then

951: If (p_rec.tp_headteacher_grp_code = hr_api.g_number) then
952: p_rec.tp_headteacher_grp_code :=
953: pqp_aat_shd.g_old_rec.tp_headteacher_grp_code;
954: End If;
955: If (p_rec.tp_safeguarded_grade = hr_api.g_varchar2) then
956: p_rec.tp_safeguarded_grade :=
957: pqp_aat_shd.g_old_rec.tp_safeguarded_grade;
958: End If;
959: If (p_rec.tp_safeguarded_grade_id = hr_api.g_number) then

Line 959: If (p_rec.tp_safeguarded_grade_id = hr_api.g_number) then

955: If (p_rec.tp_safeguarded_grade = hr_api.g_varchar2) then
956: p_rec.tp_safeguarded_grade :=
957: pqp_aat_shd.g_old_rec.tp_safeguarded_grade;
958: End If;
959: If (p_rec.tp_safeguarded_grade_id = hr_api.g_number) then
960: p_rec.tp_safeguarded_grade_id :=
961: pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id;
962: End If;
963: If (p_rec.tp_safeguarded_rate_type = hr_api.g_varchar2) then

Line 963: If (p_rec.tp_safeguarded_rate_type = hr_api.g_varchar2) then

959: If (p_rec.tp_safeguarded_grade_id = hr_api.g_number) then
960: p_rec.tp_safeguarded_grade_id :=
961: pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id;
962: End If;
963: If (p_rec.tp_safeguarded_rate_type = hr_api.g_varchar2) then
964: p_rec.tp_safeguarded_rate_type :=
965: pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type;
966: End If;
967: If (p_rec.tp_safeguarded_rate_id = hr_api.g_number) then

Line 967: If (p_rec.tp_safeguarded_rate_id = hr_api.g_number) then

963: If (p_rec.tp_safeguarded_rate_type = hr_api.g_varchar2) then
964: p_rec.tp_safeguarded_rate_type :=
965: pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type;
966: End If;
967: If (p_rec.tp_safeguarded_rate_id = hr_api.g_number) then
968: p_rec.tp_safeguarded_rate_id :=
969: pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id;
970: End If;
971: If (p_rec.tp_safeguarded_spinal_point_id = hr_api.g_number) then

Line 971: If (p_rec.tp_safeguarded_spinal_point_id = hr_api.g_number) then

967: If (p_rec.tp_safeguarded_rate_id = hr_api.g_number) then
968: p_rec.tp_safeguarded_rate_id :=
969: pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id;
970: End If;
971: If (p_rec.tp_safeguarded_spinal_point_id = hr_api.g_number) then
972: p_rec.tp_safeguarded_spinal_point_id :=
973: pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id;
974: End If;
975: If (p_rec.tp_elected_pension = hr_api.g_varchar2) then

Line 975: If (p_rec.tp_elected_pension = hr_api.g_varchar2) then

971: If (p_rec.tp_safeguarded_spinal_point_id = hr_api.g_number) then
972: p_rec.tp_safeguarded_spinal_point_id :=
973: pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id;
974: End If;
975: If (p_rec.tp_elected_pension = hr_api.g_varchar2) then
976: p_rec.tp_elected_pension :=
977: pqp_aat_shd.g_old_rec.tp_elected_pension;
978: End If;
979: If (p_rec.tp_fast_track = hr_api.g_varchar2) then

Line 979: If (p_rec.tp_fast_track = hr_api.g_varchar2) then

975: If (p_rec.tp_elected_pension = hr_api.g_varchar2) then
976: p_rec.tp_elected_pension :=
977: pqp_aat_shd.g_old_rec.tp_elected_pension;
978: End If;
979: If (p_rec.tp_fast_track = hr_api.g_varchar2) then
980: p_rec.tp_fast_track :=
981: pqp_aat_shd.g_old_rec.tp_fast_track;
982: End If;
983: If (p_rec.aat_attribute_category = hr_api.g_varchar2) then

Line 983: If (p_rec.aat_attribute_category = hr_api.g_varchar2) then

979: If (p_rec.tp_fast_track = hr_api.g_varchar2) then
980: p_rec.tp_fast_track :=
981: pqp_aat_shd.g_old_rec.tp_fast_track;
982: End If;
983: If (p_rec.aat_attribute_category = hr_api.g_varchar2) then
984: p_rec.aat_attribute_category :=
985: pqp_aat_shd.g_old_rec.aat_attribute_category;
986: End If;
987: If (p_rec.aat_attribute1 = hr_api.g_varchar2) then

Line 987: If (p_rec.aat_attribute1 = hr_api.g_varchar2) then

983: If (p_rec.aat_attribute_category = hr_api.g_varchar2) then
984: p_rec.aat_attribute_category :=
985: pqp_aat_shd.g_old_rec.aat_attribute_category;
986: End If;
987: If (p_rec.aat_attribute1 = hr_api.g_varchar2) then
988: p_rec.aat_attribute1 :=
989: pqp_aat_shd.g_old_rec.aat_attribute1;
990: End If;
991: If (p_rec.aat_attribute2 = hr_api.g_varchar2) then

Line 991: If (p_rec.aat_attribute2 = hr_api.g_varchar2) then

987: If (p_rec.aat_attribute1 = hr_api.g_varchar2) then
988: p_rec.aat_attribute1 :=
989: pqp_aat_shd.g_old_rec.aat_attribute1;
990: End If;
991: If (p_rec.aat_attribute2 = hr_api.g_varchar2) then
992: p_rec.aat_attribute2 :=
993: pqp_aat_shd.g_old_rec.aat_attribute2;
994: End If;
995: If (p_rec.aat_attribute3 = hr_api.g_varchar2) then

Line 995: If (p_rec.aat_attribute3 = hr_api.g_varchar2) then

991: If (p_rec.aat_attribute2 = hr_api.g_varchar2) then
992: p_rec.aat_attribute2 :=
993: pqp_aat_shd.g_old_rec.aat_attribute2;
994: End If;
995: If (p_rec.aat_attribute3 = hr_api.g_varchar2) then
996: p_rec.aat_attribute3 :=
997: pqp_aat_shd.g_old_rec.aat_attribute3;
998: End If;
999: If (p_rec.aat_attribute4 = hr_api.g_varchar2) then

Line 999: If (p_rec.aat_attribute4 = hr_api.g_varchar2) then

995: If (p_rec.aat_attribute3 = hr_api.g_varchar2) then
996: p_rec.aat_attribute3 :=
997: pqp_aat_shd.g_old_rec.aat_attribute3;
998: End If;
999: If (p_rec.aat_attribute4 = hr_api.g_varchar2) then
1000: p_rec.aat_attribute4 :=
1001: pqp_aat_shd.g_old_rec.aat_attribute4;
1002: End If;
1003: If (p_rec.aat_attribute5 = hr_api.g_varchar2) then

Line 1003: If (p_rec.aat_attribute5 = hr_api.g_varchar2) then

999: If (p_rec.aat_attribute4 = hr_api.g_varchar2) then
1000: p_rec.aat_attribute4 :=
1001: pqp_aat_shd.g_old_rec.aat_attribute4;
1002: End If;
1003: If (p_rec.aat_attribute5 = hr_api.g_varchar2) then
1004: p_rec.aat_attribute5 :=
1005: pqp_aat_shd.g_old_rec.aat_attribute5;
1006: End If;
1007: If (p_rec.aat_attribute6 = hr_api.g_varchar2) then

Line 1007: If (p_rec.aat_attribute6 = hr_api.g_varchar2) then

1003: If (p_rec.aat_attribute5 = hr_api.g_varchar2) then
1004: p_rec.aat_attribute5 :=
1005: pqp_aat_shd.g_old_rec.aat_attribute5;
1006: End If;
1007: If (p_rec.aat_attribute6 = hr_api.g_varchar2) then
1008: p_rec.aat_attribute6 :=
1009: pqp_aat_shd.g_old_rec.aat_attribute6;
1010: End If;
1011: If (p_rec.aat_attribute7 = hr_api.g_varchar2) then

Line 1011: If (p_rec.aat_attribute7 = hr_api.g_varchar2) then

1007: If (p_rec.aat_attribute6 = hr_api.g_varchar2) then
1008: p_rec.aat_attribute6 :=
1009: pqp_aat_shd.g_old_rec.aat_attribute6;
1010: End If;
1011: If (p_rec.aat_attribute7 = hr_api.g_varchar2) then
1012: p_rec.aat_attribute7 :=
1013: pqp_aat_shd.g_old_rec.aat_attribute7;
1014: End If;
1015: If (p_rec.aat_attribute8 = hr_api.g_varchar2) then

Line 1015: If (p_rec.aat_attribute8 = hr_api.g_varchar2) then

1011: If (p_rec.aat_attribute7 = hr_api.g_varchar2) then
1012: p_rec.aat_attribute7 :=
1013: pqp_aat_shd.g_old_rec.aat_attribute7;
1014: End If;
1015: If (p_rec.aat_attribute8 = hr_api.g_varchar2) then
1016: p_rec.aat_attribute8 :=
1017: pqp_aat_shd.g_old_rec.aat_attribute8;
1018: End If;
1019: If (p_rec.aat_attribute9 = hr_api.g_varchar2) then

Line 1019: If (p_rec.aat_attribute9 = hr_api.g_varchar2) then

1015: If (p_rec.aat_attribute8 = hr_api.g_varchar2) then
1016: p_rec.aat_attribute8 :=
1017: pqp_aat_shd.g_old_rec.aat_attribute8;
1018: End If;
1019: If (p_rec.aat_attribute9 = hr_api.g_varchar2) then
1020: p_rec.aat_attribute9 :=
1021: pqp_aat_shd.g_old_rec.aat_attribute9;
1022: End If;
1023: If (p_rec.aat_attribute10 = hr_api.g_varchar2) then

Line 1023: If (p_rec.aat_attribute10 = hr_api.g_varchar2) then

1019: If (p_rec.aat_attribute9 = hr_api.g_varchar2) then
1020: p_rec.aat_attribute9 :=
1021: pqp_aat_shd.g_old_rec.aat_attribute9;
1022: End If;
1023: If (p_rec.aat_attribute10 = hr_api.g_varchar2) then
1024: p_rec.aat_attribute10 :=
1025: pqp_aat_shd.g_old_rec.aat_attribute10;
1026: End If;
1027: If (p_rec.aat_attribute11 = hr_api.g_varchar2) then

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

1023: If (p_rec.aat_attribute10 = hr_api.g_varchar2) then
1024: p_rec.aat_attribute10 :=
1025: pqp_aat_shd.g_old_rec.aat_attribute10;
1026: End If;
1027: If (p_rec.aat_attribute11 = hr_api.g_varchar2) then
1028: p_rec.aat_attribute11 :=
1029: pqp_aat_shd.g_old_rec.aat_attribute11;
1030: End If;
1031: If (p_rec.aat_attribute12 = hr_api.g_varchar2) then

Line 1031: If (p_rec.aat_attribute12 = hr_api.g_varchar2) then

1027: If (p_rec.aat_attribute11 = hr_api.g_varchar2) then
1028: p_rec.aat_attribute11 :=
1029: pqp_aat_shd.g_old_rec.aat_attribute11;
1030: End If;
1031: If (p_rec.aat_attribute12 = hr_api.g_varchar2) then
1032: p_rec.aat_attribute12 :=
1033: pqp_aat_shd.g_old_rec.aat_attribute12;
1034: End If;
1035: If (p_rec.aat_attribute13 = hr_api.g_varchar2) then

Line 1035: If (p_rec.aat_attribute13 = hr_api.g_varchar2) then

1031: If (p_rec.aat_attribute12 = hr_api.g_varchar2) then
1032: p_rec.aat_attribute12 :=
1033: pqp_aat_shd.g_old_rec.aat_attribute12;
1034: End If;
1035: If (p_rec.aat_attribute13 = hr_api.g_varchar2) then
1036: p_rec.aat_attribute13 :=
1037: pqp_aat_shd.g_old_rec.aat_attribute13;
1038: End If;
1039: If (p_rec.aat_attribute14 = hr_api.g_varchar2) then

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

1035: If (p_rec.aat_attribute13 = hr_api.g_varchar2) then
1036: p_rec.aat_attribute13 :=
1037: pqp_aat_shd.g_old_rec.aat_attribute13;
1038: End If;
1039: If (p_rec.aat_attribute14 = hr_api.g_varchar2) then
1040: p_rec.aat_attribute14 :=
1041: pqp_aat_shd.g_old_rec.aat_attribute14;
1042: End If;
1043: If (p_rec.aat_attribute15 = hr_api.g_varchar2) then

Line 1043: If (p_rec.aat_attribute15 = hr_api.g_varchar2) then

1039: If (p_rec.aat_attribute14 = hr_api.g_varchar2) then
1040: p_rec.aat_attribute14 :=
1041: pqp_aat_shd.g_old_rec.aat_attribute14;
1042: End If;
1043: If (p_rec.aat_attribute15 = hr_api.g_varchar2) then
1044: p_rec.aat_attribute15 :=
1045: pqp_aat_shd.g_old_rec.aat_attribute15;
1046: End If;
1047: If (p_rec.aat_attribute16 = hr_api.g_varchar2) then

Line 1047: If (p_rec.aat_attribute16 = hr_api.g_varchar2) then

1043: If (p_rec.aat_attribute15 = hr_api.g_varchar2) then
1044: p_rec.aat_attribute15 :=
1045: pqp_aat_shd.g_old_rec.aat_attribute15;
1046: End If;
1047: If (p_rec.aat_attribute16 = hr_api.g_varchar2) then
1048: p_rec.aat_attribute16 :=
1049: pqp_aat_shd.g_old_rec.aat_attribute16;
1050: End If;
1051: If (p_rec.aat_attribute17 = hr_api.g_varchar2) then

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

1047: If (p_rec.aat_attribute16 = hr_api.g_varchar2) then
1048: p_rec.aat_attribute16 :=
1049: pqp_aat_shd.g_old_rec.aat_attribute16;
1050: End If;
1051: If (p_rec.aat_attribute17 = hr_api.g_varchar2) then
1052: p_rec.aat_attribute17 :=
1053: pqp_aat_shd.g_old_rec.aat_attribute17;
1054: End If;
1055: If (p_rec.aat_attribute18 = hr_api.g_varchar2) then

Line 1055: If (p_rec.aat_attribute18 = hr_api.g_varchar2) then

1051: If (p_rec.aat_attribute17 = hr_api.g_varchar2) then
1052: p_rec.aat_attribute17 :=
1053: pqp_aat_shd.g_old_rec.aat_attribute17;
1054: End If;
1055: If (p_rec.aat_attribute18 = hr_api.g_varchar2) then
1056: p_rec.aat_attribute18 :=
1057: pqp_aat_shd.g_old_rec.aat_attribute18;
1058: End If;
1059: If (p_rec.aat_attribute19 = hr_api.g_varchar2) then

Line 1059: If (p_rec.aat_attribute19 = hr_api.g_varchar2) then

1055: If (p_rec.aat_attribute18 = hr_api.g_varchar2) then
1056: p_rec.aat_attribute18 :=
1057: pqp_aat_shd.g_old_rec.aat_attribute18;
1058: End If;
1059: If (p_rec.aat_attribute19 = hr_api.g_varchar2) then
1060: p_rec.aat_attribute19 :=
1061: pqp_aat_shd.g_old_rec.aat_attribute19;
1062: End If;
1063: If (p_rec.aat_attribute20 = hr_api.g_varchar2) then

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

1059: If (p_rec.aat_attribute19 = hr_api.g_varchar2) then
1060: p_rec.aat_attribute19 :=
1061: pqp_aat_shd.g_old_rec.aat_attribute19;
1062: End If;
1063: If (p_rec.aat_attribute20 = hr_api.g_varchar2) then
1064: p_rec.aat_attribute20 :=
1065: pqp_aat_shd.g_old_rec.aat_attribute20;
1066: End If;
1067: If (p_rec.aat_information_category = hr_api.g_varchar2) then

Line 1067: If (p_rec.aat_information_category = hr_api.g_varchar2) then

1063: If (p_rec.aat_attribute20 = hr_api.g_varchar2) then
1064: p_rec.aat_attribute20 :=
1065: pqp_aat_shd.g_old_rec.aat_attribute20;
1066: End If;
1067: If (p_rec.aat_information_category = hr_api.g_varchar2) then
1068: p_rec.aat_information_category :=
1069: pqp_aat_shd.g_old_rec.aat_information_category;
1070: End If;
1071: If (p_rec.aat_information1 = hr_api.g_varchar2) then

Line 1071: If (p_rec.aat_information1 = hr_api.g_varchar2) then

1067: If (p_rec.aat_information_category = hr_api.g_varchar2) then
1068: p_rec.aat_information_category :=
1069: pqp_aat_shd.g_old_rec.aat_information_category;
1070: End If;
1071: If (p_rec.aat_information1 = hr_api.g_varchar2) then
1072: p_rec.aat_information1 :=
1073: pqp_aat_shd.g_old_rec.aat_information1;
1074: End If;
1075: If (p_rec.aat_information2 = hr_api.g_varchar2) then

Line 1075: If (p_rec.aat_information2 = hr_api.g_varchar2) then

1071: If (p_rec.aat_information1 = hr_api.g_varchar2) then
1072: p_rec.aat_information1 :=
1073: pqp_aat_shd.g_old_rec.aat_information1;
1074: End If;
1075: If (p_rec.aat_information2 = hr_api.g_varchar2) then
1076: p_rec.aat_information2 :=
1077: pqp_aat_shd.g_old_rec.aat_information2;
1078: End If;
1079: If (p_rec.aat_information3 = hr_api.g_varchar2) then

Line 1079: If (p_rec.aat_information3 = hr_api.g_varchar2) then

1075: If (p_rec.aat_information2 = hr_api.g_varchar2) then
1076: p_rec.aat_information2 :=
1077: pqp_aat_shd.g_old_rec.aat_information2;
1078: End If;
1079: If (p_rec.aat_information3 = hr_api.g_varchar2) then
1080: p_rec.aat_information3 :=
1081: pqp_aat_shd.g_old_rec.aat_information3;
1082: End If;
1083: If (p_rec.aat_information4 = hr_api.g_varchar2) then

Line 1083: If (p_rec.aat_information4 = hr_api.g_varchar2) then

1079: If (p_rec.aat_information3 = hr_api.g_varchar2) then
1080: p_rec.aat_information3 :=
1081: pqp_aat_shd.g_old_rec.aat_information3;
1082: End If;
1083: If (p_rec.aat_information4 = hr_api.g_varchar2) then
1084: p_rec.aat_information4 :=
1085: pqp_aat_shd.g_old_rec.aat_information4;
1086: End If;
1087: If (p_rec.aat_information5 = hr_api.g_varchar2) then

Line 1087: If (p_rec.aat_information5 = hr_api.g_varchar2) then

1083: If (p_rec.aat_information4 = hr_api.g_varchar2) then
1084: p_rec.aat_information4 :=
1085: pqp_aat_shd.g_old_rec.aat_information4;
1086: End If;
1087: If (p_rec.aat_information5 = hr_api.g_varchar2) then
1088: p_rec.aat_information5 :=
1089: pqp_aat_shd.g_old_rec.aat_information5;
1090: End If;
1091: If (p_rec.aat_information6 = hr_api.g_varchar2) then

Line 1091: If (p_rec.aat_information6 = hr_api.g_varchar2) then

1087: If (p_rec.aat_information5 = hr_api.g_varchar2) then
1088: p_rec.aat_information5 :=
1089: pqp_aat_shd.g_old_rec.aat_information5;
1090: End If;
1091: If (p_rec.aat_information6 = hr_api.g_varchar2) then
1092: p_rec.aat_information6 :=
1093: pqp_aat_shd.g_old_rec.aat_information6;
1094: End If;
1095: If (p_rec.aat_information7 = hr_api.g_varchar2) then

Line 1095: If (p_rec.aat_information7 = hr_api.g_varchar2) then

1091: If (p_rec.aat_information6 = hr_api.g_varchar2) then
1092: p_rec.aat_information6 :=
1093: pqp_aat_shd.g_old_rec.aat_information6;
1094: End If;
1095: If (p_rec.aat_information7 = hr_api.g_varchar2) then
1096: p_rec.aat_information7 :=
1097: pqp_aat_shd.g_old_rec.aat_information7;
1098: End If;
1099: If (p_rec.aat_information8 = hr_api.g_varchar2) then

Line 1099: If (p_rec.aat_information8 = hr_api.g_varchar2) then

1095: If (p_rec.aat_information7 = hr_api.g_varchar2) then
1096: p_rec.aat_information7 :=
1097: pqp_aat_shd.g_old_rec.aat_information7;
1098: End If;
1099: If (p_rec.aat_information8 = hr_api.g_varchar2) then
1100: p_rec.aat_information8 :=
1101: pqp_aat_shd.g_old_rec.aat_information8;
1102: End If;
1103: If (p_rec.aat_information9 = hr_api.g_varchar2) then

Line 1103: If (p_rec.aat_information9 = hr_api.g_varchar2) then

1099: If (p_rec.aat_information8 = hr_api.g_varchar2) then
1100: p_rec.aat_information8 :=
1101: pqp_aat_shd.g_old_rec.aat_information8;
1102: End If;
1103: If (p_rec.aat_information9 = hr_api.g_varchar2) then
1104: p_rec.aat_information9 :=
1105: pqp_aat_shd.g_old_rec.aat_information9;
1106: End If;
1107: If (p_rec.aat_information10 = hr_api.g_varchar2) then

Line 1107: If (p_rec.aat_information10 = hr_api.g_varchar2) then

1103: If (p_rec.aat_information9 = hr_api.g_varchar2) then
1104: p_rec.aat_information9 :=
1105: pqp_aat_shd.g_old_rec.aat_information9;
1106: End If;
1107: If (p_rec.aat_information10 = hr_api.g_varchar2) then
1108: p_rec.aat_information10 :=
1109: pqp_aat_shd.g_old_rec.aat_information10;
1110: End If;
1111: If (p_rec.aat_information11 = hr_api.g_varchar2) then

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

1107: If (p_rec.aat_information10 = hr_api.g_varchar2) then
1108: p_rec.aat_information10 :=
1109: pqp_aat_shd.g_old_rec.aat_information10;
1110: End If;
1111: If (p_rec.aat_information11 = hr_api.g_varchar2) then
1112: p_rec.aat_information11 :=
1113: pqp_aat_shd.g_old_rec.aat_information11;
1114: End If;
1115: If (p_rec.aat_information12 = hr_api.g_varchar2) then

Line 1115: If (p_rec.aat_information12 = hr_api.g_varchar2) then

1111: If (p_rec.aat_information11 = hr_api.g_varchar2) then
1112: p_rec.aat_information11 :=
1113: pqp_aat_shd.g_old_rec.aat_information11;
1114: End If;
1115: If (p_rec.aat_information12 = hr_api.g_varchar2) then
1116: p_rec.aat_information12 :=
1117: pqp_aat_shd.g_old_rec.aat_information12;
1118: End If;
1119: If (p_rec.aat_information13 = hr_api.g_varchar2) then

Line 1119: If (p_rec.aat_information13 = hr_api.g_varchar2) then

1115: If (p_rec.aat_information12 = hr_api.g_varchar2) then
1116: p_rec.aat_information12 :=
1117: pqp_aat_shd.g_old_rec.aat_information12;
1118: End If;
1119: If (p_rec.aat_information13 = hr_api.g_varchar2) then
1120: p_rec.aat_information13 :=
1121: pqp_aat_shd.g_old_rec.aat_information13;
1122: End If;
1123: If (p_rec.aat_information14 = hr_api.g_varchar2) then

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

1119: If (p_rec.aat_information13 = hr_api.g_varchar2) then
1120: p_rec.aat_information13 :=
1121: pqp_aat_shd.g_old_rec.aat_information13;
1122: End If;
1123: If (p_rec.aat_information14 = hr_api.g_varchar2) then
1124: p_rec.aat_information14 :=
1125: pqp_aat_shd.g_old_rec.aat_information14;
1126: End If;
1127: If (p_rec.aat_information15 = hr_api.g_varchar2) then

Line 1127: If (p_rec.aat_information15 = hr_api.g_varchar2) then

1123: If (p_rec.aat_information14 = hr_api.g_varchar2) then
1124: p_rec.aat_information14 :=
1125: pqp_aat_shd.g_old_rec.aat_information14;
1126: End If;
1127: If (p_rec.aat_information15 = hr_api.g_varchar2) then
1128: p_rec.aat_information15 :=
1129: pqp_aat_shd.g_old_rec.aat_information15;
1130: End If;
1131: If (p_rec.aat_information16 = hr_api.g_varchar2) then

Line 1131: If (p_rec.aat_information16 = hr_api.g_varchar2) then

1127: If (p_rec.aat_information15 = hr_api.g_varchar2) then
1128: p_rec.aat_information15 :=
1129: pqp_aat_shd.g_old_rec.aat_information15;
1130: End If;
1131: If (p_rec.aat_information16 = hr_api.g_varchar2) then
1132: p_rec.aat_information16 :=
1133: pqp_aat_shd.g_old_rec.aat_information16;
1134: End If;
1135: If (p_rec.aat_information17 = hr_api.g_varchar2) then

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

1131: If (p_rec.aat_information16 = hr_api.g_varchar2) then
1132: p_rec.aat_information16 :=
1133: pqp_aat_shd.g_old_rec.aat_information16;
1134: End If;
1135: If (p_rec.aat_information17 = hr_api.g_varchar2) then
1136: p_rec.aat_information17 :=
1137: pqp_aat_shd.g_old_rec.aat_information17;
1138: End If;
1139: If (p_rec.aat_information18 = hr_api.g_varchar2) then

Line 1139: If (p_rec.aat_information18 = hr_api.g_varchar2) then

1135: If (p_rec.aat_information17 = hr_api.g_varchar2) then
1136: p_rec.aat_information17 :=
1137: pqp_aat_shd.g_old_rec.aat_information17;
1138: End If;
1139: If (p_rec.aat_information18 = hr_api.g_varchar2) then
1140: p_rec.aat_information18 :=
1141: pqp_aat_shd.g_old_rec.aat_information18;
1142: End If;
1143: If (p_rec.aat_information19 = hr_api.g_varchar2) then

Line 1143: If (p_rec.aat_information19 = hr_api.g_varchar2) then

1139: If (p_rec.aat_information18 = hr_api.g_varchar2) then
1140: p_rec.aat_information18 :=
1141: pqp_aat_shd.g_old_rec.aat_information18;
1142: End If;
1143: If (p_rec.aat_information19 = hr_api.g_varchar2) then
1144: p_rec.aat_information19 :=
1145: pqp_aat_shd.g_old_rec.aat_information19;
1146: End If;
1147: If (p_rec.aat_information20 = hr_api.g_varchar2) then

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

1143: If (p_rec.aat_information19 = hr_api.g_varchar2) then
1144: p_rec.aat_information19 :=
1145: pqp_aat_shd.g_old_rec.aat_information19;
1146: End If;
1147: If (p_rec.aat_information20 = hr_api.g_varchar2) then
1148: p_rec.aat_information20 :=
1149: pqp_aat_shd.g_old_rec.aat_information20;
1150: End If;
1151: If (p_rec.lgps_process_flag = hr_api.g_varchar2) then

Line 1151: If (p_rec.lgps_process_flag = hr_api.g_varchar2) then

1147: If (p_rec.aat_information20 = hr_api.g_varchar2) then
1148: p_rec.aat_information20 :=
1149: pqp_aat_shd.g_old_rec.aat_information20;
1150: End If;
1151: If (p_rec.lgps_process_flag = hr_api.g_varchar2) then
1152: p_rec.lgps_process_flag :=
1153: pqp_aat_shd.g_old_rec.lgps_process_flag;
1154: End If;
1155: If (p_rec.lgps_exclusion_type = hr_api.g_varchar2) then

Line 1155: If (p_rec.lgps_exclusion_type = hr_api.g_varchar2) then

1151: If (p_rec.lgps_process_flag = hr_api.g_varchar2) then
1152: p_rec.lgps_process_flag :=
1153: pqp_aat_shd.g_old_rec.lgps_process_flag;
1154: End If;
1155: If (p_rec.lgps_exclusion_type = hr_api.g_varchar2) then
1156: p_rec.lgps_exclusion_type :=
1157: pqp_aat_shd.g_old_rec.lgps_exclusion_type;
1158: End If;
1159: If (p_rec.lgps_pensionable_pay = hr_api.g_varchar2) then

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

1155: If (p_rec.lgps_exclusion_type = hr_api.g_varchar2) then
1156: p_rec.lgps_exclusion_type :=
1157: pqp_aat_shd.g_old_rec.lgps_exclusion_type;
1158: End If;
1159: If (p_rec.lgps_pensionable_pay = hr_api.g_varchar2) then
1160: p_rec.lgps_pensionable_pay :=
1161: pqp_aat_shd.g_old_rec.lgps_pensionable_pay;
1162: End If;
1163: If (p_rec.lgps_trans_arrang_flag = hr_api.g_varchar2) then

Line 1163: If (p_rec.lgps_trans_arrang_flag = hr_api.g_varchar2) then

1159: If (p_rec.lgps_pensionable_pay = hr_api.g_varchar2) then
1160: p_rec.lgps_pensionable_pay :=
1161: pqp_aat_shd.g_old_rec.lgps_pensionable_pay;
1162: End If;
1163: If (p_rec.lgps_trans_arrang_flag = hr_api.g_varchar2) then
1164: p_rec.lgps_trans_arrang_flag :=
1165: pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag;
1166: End If;
1167: If (p_rec.lgps_membership_number = hr_api.g_varchar2) then

Line 1167: If (p_rec.lgps_membership_number = hr_api.g_varchar2) then

1163: If (p_rec.lgps_trans_arrang_flag = hr_api.g_varchar2) then
1164: p_rec.lgps_trans_arrang_flag :=
1165: pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag;
1166: End If;
1167: If (p_rec.lgps_membership_number = hr_api.g_varchar2) then
1168: p_rec.lgps_membership_number :=
1169: pqp_aat_shd.g_old_rec.lgps_membership_number;
1170: End If;
1171:

Line 1261: ,p_business_group_id in number default hr_api.g_number

1257: (p_effective_date in date
1258: ,p_datetrack_mode in varchar2
1259: ,p_assignment_attribute_id in number
1260: ,p_object_version_number in out nocopy number
1261: ,p_business_group_id in number default hr_api.g_number
1262: ,p_assignment_id in number default hr_api.g_number
1263: ,p_contract_type in varchar2 default hr_api.g_varchar2
1264: ,p_work_pattern in varchar2 default hr_api.g_varchar2
1265: ,p_start_day in varchar2 default hr_api.g_varchar2

Line 1262: ,p_assignment_id in number default hr_api.g_number

1258: ,p_datetrack_mode in varchar2
1259: ,p_assignment_attribute_id in number
1260: ,p_object_version_number in out nocopy number
1261: ,p_business_group_id in number default hr_api.g_number
1262: ,p_assignment_id in number default hr_api.g_number
1263: ,p_contract_type in varchar2 default hr_api.g_varchar2
1264: ,p_work_pattern in varchar2 default hr_api.g_varchar2
1265: ,p_start_day in varchar2 default hr_api.g_varchar2
1266: ,p_primary_company_car in number default hr_api.g_number

Line 1263: ,p_contract_type in varchar2 default hr_api.g_varchar2

1259: ,p_assignment_attribute_id in number
1260: ,p_object_version_number in out nocopy number
1261: ,p_business_group_id in number default hr_api.g_number
1262: ,p_assignment_id in number default hr_api.g_number
1263: ,p_contract_type in varchar2 default hr_api.g_varchar2
1264: ,p_work_pattern in varchar2 default hr_api.g_varchar2
1265: ,p_start_day in varchar2 default hr_api.g_varchar2
1266: ,p_primary_company_car in number default hr_api.g_number
1267: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2

Line 1264: ,p_work_pattern in varchar2 default hr_api.g_varchar2

1260: ,p_object_version_number in out nocopy number
1261: ,p_business_group_id in number default hr_api.g_number
1262: ,p_assignment_id in number default hr_api.g_number
1263: ,p_contract_type in varchar2 default hr_api.g_varchar2
1264: ,p_work_pattern in varchar2 default hr_api.g_varchar2
1265: ,p_start_day in varchar2 default hr_api.g_varchar2
1266: ,p_primary_company_car in number default hr_api.g_number
1267: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1268: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2

Line 1265: ,p_start_day in varchar2 default hr_api.g_varchar2

1261: ,p_business_group_id in number default hr_api.g_number
1262: ,p_assignment_id in number default hr_api.g_number
1263: ,p_contract_type in varchar2 default hr_api.g_varchar2
1264: ,p_work_pattern in varchar2 default hr_api.g_varchar2
1265: ,p_start_day in varchar2 default hr_api.g_varchar2
1266: ,p_primary_company_car in number default hr_api.g_number
1267: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1268: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
1269: ,p_primary_capital_contribution in number default hr_api.g_number

Line 1266: ,p_primary_company_car in number default hr_api.g_number

1262: ,p_assignment_id in number default hr_api.g_number
1263: ,p_contract_type in varchar2 default hr_api.g_varchar2
1264: ,p_work_pattern in varchar2 default hr_api.g_varchar2
1265: ,p_start_day in varchar2 default hr_api.g_varchar2
1266: ,p_primary_company_car in number default hr_api.g_number
1267: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1268: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
1269: ,p_primary_capital_contribution in number default hr_api.g_number
1270: ,p_primary_private_contribution in number default hr_api.g_number

Line 1267: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2

1263: ,p_contract_type in varchar2 default hr_api.g_varchar2
1264: ,p_work_pattern in varchar2 default hr_api.g_varchar2
1265: ,p_start_day in varchar2 default hr_api.g_varchar2
1266: ,p_primary_company_car in number default hr_api.g_number
1267: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1268: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
1269: ,p_primary_capital_contribution in number default hr_api.g_number
1270: ,p_primary_private_contribution in number default hr_api.g_number
1271: ,p_secondary_company_car in number default hr_api.g_number

Line 1268: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2

1264: ,p_work_pattern in varchar2 default hr_api.g_varchar2
1265: ,p_start_day in varchar2 default hr_api.g_varchar2
1266: ,p_primary_company_car in number default hr_api.g_number
1267: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1268: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
1269: ,p_primary_capital_contribution in number default hr_api.g_number
1270: ,p_primary_private_contribution in number default hr_api.g_number
1271: ,p_secondary_company_car in number default hr_api.g_number
1272: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2

Line 1269: ,p_primary_capital_contribution in number default hr_api.g_number

1265: ,p_start_day in varchar2 default hr_api.g_varchar2
1266: ,p_primary_company_car in number default hr_api.g_number
1267: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1268: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
1269: ,p_primary_capital_contribution in number default hr_api.g_number
1270: ,p_primary_private_contribution in number default hr_api.g_number
1271: ,p_secondary_company_car in number default hr_api.g_number
1272: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1273: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2

Line 1270: ,p_primary_private_contribution in number default hr_api.g_number

1266: ,p_primary_company_car in number default hr_api.g_number
1267: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1268: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
1269: ,p_primary_capital_contribution in number default hr_api.g_number
1270: ,p_primary_private_contribution in number default hr_api.g_number
1271: ,p_secondary_company_car in number default hr_api.g_number
1272: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1273: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
1274: ,p_secondary_capital_contributi in number default hr_api.g_number

Line 1271: ,p_secondary_company_car in number default hr_api.g_number

1267: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1268: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
1269: ,p_primary_capital_contribution in number default hr_api.g_number
1270: ,p_primary_private_contribution in number default hr_api.g_number
1271: ,p_secondary_company_car in number default hr_api.g_number
1272: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1273: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
1274: ,p_secondary_capital_contributi in number default hr_api.g_number
1275: ,p_secondary_private_contributi in number default hr_api.g_number

Line 1272: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2

1268: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
1269: ,p_primary_capital_contribution in number default hr_api.g_number
1270: ,p_primary_private_contribution in number default hr_api.g_number
1271: ,p_secondary_company_car in number default hr_api.g_number
1272: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1273: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
1274: ,p_secondary_capital_contributi in number default hr_api.g_number
1275: ,p_secondary_private_contributi in number default hr_api.g_number
1276: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2

Line 1273: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2

1269: ,p_primary_capital_contribution in number default hr_api.g_number
1270: ,p_primary_private_contribution in number default hr_api.g_number
1271: ,p_secondary_company_car in number default hr_api.g_number
1272: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1273: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
1274: ,p_secondary_capital_contributi in number default hr_api.g_number
1275: ,p_secondary_private_contributi in number default hr_api.g_number
1276: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
1277: ,p_company_car_rates_table_id in number default hr_api.g_number

Line 1274: ,p_secondary_capital_contributi in number default hr_api.g_number

1270: ,p_primary_private_contribution in number default hr_api.g_number
1271: ,p_secondary_company_car in number default hr_api.g_number
1272: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1273: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
1274: ,p_secondary_capital_contributi in number default hr_api.g_number
1275: ,p_secondary_private_contributi in number default hr_api.g_number
1276: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
1277: ,p_company_car_rates_table_id in number default hr_api.g_number
1278: ,p_company_car_secondary_table in number default hr_api.g_number

Line 1275: ,p_secondary_private_contributi in number default hr_api.g_number

1271: ,p_secondary_company_car in number default hr_api.g_number
1272: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1273: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
1274: ,p_secondary_capital_contributi in number default hr_api.g_number
1275: ,p_secondary_private_contributi in number default hr_api.g_number
1276: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
1277: ,p_company_car_rates_table_id in number default hr_api.g_number
1278: ,p_company_car_secondary_table in number default hr_api.g_number
1279: ,p_private_car in number default hr_api.g_number

Line 1276: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2

1272: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
1273: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
1274: ,p_secondary_capital_contributi in number default hr_api.g_number
1275: ,p_secondary_private_contributi in number default hr_api.g_number
1276: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
1277: ,p_company_car_rates_table_id in number default hr_api.g_number
1278: ,p_company_car_secondary_table in number default hr_api.g_number
1279: ,p_private_car in number default hr_api.g_number
1280: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2

Line 1277: ,p_company_car_rates_table_id in number default hr_api.g_number

1273: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
1274: ,p_secondary_capital_contributi in number default hr_api.g_number
1275: ,p_secondary_private_contributi in number default hr_api.g_number
1276: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
1277: ,p_company_car_rates_table_id in number default hr_api.g_number
1278: ,p_company_car_secondary_table in number default hr_api.g_number
1279: ,p_private_car in number default hr_api.g_number
1280: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
1281: ,p_private_car_rates_table_id in number default hr_api.g_number

Line 1278: ,p_company_car_secondary_table in number default hr_api.g_number

1274: ,p_secondary_capital_contributi in number default hr_api.g_number
1275: ,p_secondary_private_contributi in number default hr_api.g_number
1276: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
1277: ,p_company_car_rates_table_id in number default hr_api.g_number
1278: ,p_company_car_secondary_table in number default hr_api.g_number
1279: ,p_private_car in number default hr_api.g_number
1280: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
1281: ,p_private_car_rates_table_id in number default hr_api.g_number
1282: ,p_private_car_essential_table in number default hr_api.g_number

Line 1279: ,p_private_car in number default hr_api.g_number

1275: ,p_secondary_private_contributi in number default hr_api.g_number
1276: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
1277: ,p_company_car_rates_table_id in number default hr_api.g_number
1278: ,p_company_car_secondary_table in number default hr_api.g_number
1279: ,p_private_car in number default hr_api.g_number
1280: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
1281: ,p_private_car_rates_table_id in number default hr_api.g_number
1282: ,p_private_car_essential_table in number default hr_api.g_number
1283: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2

Line 1280: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2

1276: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
1277: ,p_company_car_rates_table_id in number default hr_api.g_number
1278: ,p_company_car_secondary_table in number default hr_api.g_number
1279: ,p_private_car in number default hr_api.g_number
1280: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
1281: ,p_private_car_rates_table_id in number default hr_api.g_number
1282: ,p_private_car_essential_table in number default hr_api.g_number
1283: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
1284: ,p_tp_headteacher_grp_code in number default hr_api.g_number --added for head Teacher seconded location for salary scale calculation

Line 1281: ,p_private_car_rates_table_id in number default hr_api.g_number

1277: ,p_company_car_rates_table_id in number default hr_api.g_number
1278: ,p_company_car_secondary_table in number default hr_api.g_number
1279: ,p_private_car in number default hr_api.g_number
1280: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
1281: ,p_private_car_rates_table_id in number default hr_api.g_number
1282: ,p_private_car_essential_table in number default hr_api.g_number
1283: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
1284: ,p_tp_headteacher_grp_code in number default hr_api.g_number --added for head Teacher seconded location for salary scale calculation
1285: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2

Line 1282: ,p_private_car_essential_table in number default hr_api.g_number

1278: ,p_company_car_secondary_table in number default hr_api.g_number
1279: ,p_private_car in number default hr_api.g_number
1280: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
1281: ,p_private_car_rates_table_id in number default hr_api.g_number
1282: ,p_private_car_essential_table in number default hr_api.g_number
1283: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
1284: ,p_tp_headteacher_grp_code in number default hr_api.g_number --added for head Teacher seconded location for salary scale calculation
1285: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
1286: ,p_tp_safeguarded_grade_id in number default hr_api.g_number

Line 1283: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2

1279: ,p_private_car in number default hr_api.g_number
1280: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
1281: ,p_private_car_rates_table_id in number default hr_api.g_number
1282: ,p_private_car_essential_table in number default hr_api.g_number
1283: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
1284: ,p_tp_headteacher_grp_code in number default hr_api.g_number --added for head Teacher seconded location for salary scale calculation
1285: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
1286: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
1287: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2

Line 1284: ,p_tp_headteacher_grp_code in number default hr_api.g_number --added for head Teacher seconded location for salary scale calculation

1280: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
1281: ,p_private_car_rates_table_id in number default hr_api.g_number
1282: ,p_private_car_essential_table in number default hr_api.g_number
1283: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
1284: ,p_tp_headteacher_grp_code in number default hr_api.g_number --added for head Teacher seconded location for salary scale calculation
1285: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
1286: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
1287: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
1288: ,p_tp_safeguarded_rate_id in number default hr_api.g_number

Line 1285: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2

1281: ,p_private_car_rates_table_id in number default hr_api.g_number
1282: ,p_private_car_essential_table in number default hr_api.g_number
1283: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
1284: ,p_tp_headteacher_grp_code in number default hr_api.g_number --added for head Teacher seconded location for salary scale calculation
1285: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
1286: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
1287: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
1288: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
1289: ,p_tp_spinal_point_id in number default hr_api.g_number

Line 1286: ,p_tp_safeguarded_grade_id in number default hr_api.g_number

1282: ,p_private_car_essential_table in number default hr_api.g_number
1283: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
1284: ,p_tp_headteacher_grp_code in number default hr_api.g_number --added for head Teacher seconded location for salary scale calculation
1285: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
1286: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
1287: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
1288: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
1289: ,p_tp_spinal_point_id in number default hr_api.g_number
1290: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2

Line 1287: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2

1283: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
1284: ,p_tp_headteacher_grp_code in number default hr_api.g_number --added for head Teacher seconded location for salary scale calculation
1285: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
1286: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
1287: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
1288: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
1289: ,p_tp_spinal_point_id in number default hr_api.g_number
1290: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
1291: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2

Line 1288: ,p_tp_safeguarded_rate_id in number default hr_api.g_number

1284: ,p_tp_headteacher_grp_code in number default hr_api.g_number --added for head Teacher seconded location for salary scale calculation
1285: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
1286: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
1287: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
1288: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
1289: ,p_tp_spinal_point_id in number default hr_api.g_number
1290: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
1291: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
1292: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2

Line 1289: ,p_tp_spinal_point_id in number default hr_api.g_number

1285: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
1286: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
1287: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
1288: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
1289: ,p_tp_spinal_point_id in number default hr_api.g_number
1290: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
1291: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
1292: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
1293: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2

Line 1290: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2

1286: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
1287: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
1288: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
1289: ,p_tp_spinal_point_id in number default hr_api.g_number
1290: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
1291: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
1292: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
1293: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
1294: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2

Line 1291: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2

1287: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
1288: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
1289: ,p_tp_spinal_point_id in number default hr_api.g_number
1290: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
1291: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
1292: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
1293: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
1294: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
1295: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2

Line 1292: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2

1288: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
1289: ,p_tp_spinal_point_id in number default hr_api.g_number
1290: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
1291: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
1292: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
1293: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
1294: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
1295: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
1296: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2

Line 1293: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2

1289: ,p_tp_spinal_point_id in number default hr_api.g_number
1290: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
1291: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
1292: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
1293: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
1294: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
1295: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
1296: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
1297: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2

Line 1294: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2

1290: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
1291: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
1292: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
1293: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
1294: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
1295: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
1296: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
1297: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
1298: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2

Line 1295: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2

1291: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
1292: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
1293: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
1294: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
1295: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
1296: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
1297: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
1298: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
1299: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2

Line 1296: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2

1292: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
1293: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
1294: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
1295: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
1296: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
1297: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
1298: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
1299: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
1300: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2

Line 1297: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2

1293: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
1294: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
1295: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
1296: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
1297: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
1298: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
1299: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
1300: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
1301: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2

Line 1298: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2

1294: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
1295: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
1296: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
1297: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
1298: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
1299: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
1300: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
1301: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
1302: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2

Line 1299: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2

1295: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
1296: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
1297: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
1298: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
1299: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
1300: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
1301: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
1302: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
1303: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2

Line 1300: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2

1296: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
1297: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
1298: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
1299: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
1300: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
1301: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
1302: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
1303: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
1304: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2

Line 1301: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2

1297: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
1298: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
1299: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
1300: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
1301: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
1302: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
1303: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
1304: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
1305: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2

Line 1302: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2

1298: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
1299: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
1300: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
1301: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
1302: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
1303: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
1304: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
1305: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
1306: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2

Line 1303: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2

1299: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
1300: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
1301: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
1302: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
1303: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
1304: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
1305: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
1306: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
1307: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2

Line 1304: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2

1300: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
1301: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
1302: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
1303: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
1304: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
1305: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
1306: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
1307: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
1308: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2

Line 1305: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2

1301: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
1302: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
1303: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
1304: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
1305: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
1306: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
1307: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
1308: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
1309: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2

Line 1306: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2

1302: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
1303: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
1304: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
1305: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
1306: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
1307: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
1308: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
1309: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
1310: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2

Line 1307: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2

1303: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
1304: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
1305: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
1306: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
1307: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
1308: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
1309: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
1310: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
1311: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2

Line 1308: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2

1304: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
1305: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
1306: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
1307: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
1308: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
1309: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
1310: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
1311: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
1312: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2

Line 1309: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2

1305: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
1306: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
1307: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
1308: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
1309: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
1310: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
1311: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
1312: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
1313: ,p_aat_information_category in varchar2 default hr_api.g_varchar2

Line 1310: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2

1306: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
1307: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
1308: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
1309: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
1310: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
1311: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
1312: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
1313: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
1314: ,p_aat_information1 in varchar2 default hr_api.g_varchar2

Line 1311: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2

1307: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
1308: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
1309: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
1310: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
1311: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
1312: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
1313: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
1314: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
1315: ,p_aat_information2 in varchar2 default hr_api.g_varchar2

Line 1312: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2

1308: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
1309: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
1310: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
1311: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
1312: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
1313: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
1314: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
1315: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
1316: ,p_aat_information3 in varchar2 default hr_api.g_varchar2

Line 1313: ,p_aat_information_category in varchar2 default hr_api.g_varchar2

1309: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
1310: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
1311: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
1312: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
1313: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
1314: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
1315: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
1316: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
1317: ,p_aat_information4 in varchar2 default hr_api.g_varchar2

Line 1314: ,p_aat_information1 in varchar2 default hr_api.g_varchar2

1310: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
1311: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
1312: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
1313: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
1314: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
1315: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
1316: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
1317: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
1318: ,p_aat_information5 in varchar2 default hr_api.g_varchar2

Line 1315: ,p_aat_information2 in varchar2 default hr_api.g_varchar2

1311: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
1312: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
1313: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
1314: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
1315: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
1316: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
1317: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
1318: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
1319: ,p_aat_information6 in varchar2 default hr_api.g_varchar2

Line 1316: ,p_aat_information3 in varchar2 default hr_api.g_varchar2

1312: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
1313: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
1314: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
1315: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
1316: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
1317: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
1318: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
1319: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
1320: ,p_aat_information7 in varchar2 default hr_api.g_varchar2

Line 1317: ,p_aat_information4 in varchar2 default hr_api.g_varchar2

1313: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
1314: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
1315: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
1316: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
1317: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
1318: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
1319: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
1320: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
1321: ,p_aat_information8 in varchar2 default hr_api.g_varchar2

Line 1318: ,p_aat_information5 in varchar2 default hr_api.g_varchar2

1314: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
1315: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
1316: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
1317: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
1318: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
1319: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
1320: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
1321: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
1322: ,p_aat_information9 in varchar2 default hr_api.g_varchar2

Line 1319: ,p_aat_information6 in varchar2 default hr_api.g_varchar2

1315: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
1316: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
1317: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
1318: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
1319: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
1320: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
1321: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
1322: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
1323: ,p_aat_information10 in varchar2 default hr_api.g_varchar2

Line 1320: ,p_aat_information7 in varchar2 default hr_api.g_varchar2

1316: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
1317: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
1318: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
1319: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
1320: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
1321: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
1322: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
1323: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
1324: ,p_aat_information11 in varchar2 default hr_api.g_varchar2

Line 1321: ,p_aat_information8 in varchar2 default hr_api.g_varchar2

1317: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
1318: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
1319: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
1320: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
1321: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
1322: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
1323: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
1324: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
1325: ,p_aat_information12 in varchar2 default hr_api.g_varchar2

Line 1322: ,p_aat_information9 in varchar2 default hr_api.g_varchar2

1318: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
1319: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
1320: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
1321: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
1322: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
1323: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
1324: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
1325: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
1326: ,p_aat_information13 in varchar2 default hr_api.g_varchar2

Line 1323: ,p_aat_information10 in varchar2 default hr_api.g_varchar2

1319: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
1320: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
1321: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
1322: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
1323: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
1324: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
1325: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
1326: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
1327: ,p_aat_information14 in varchar2 default hr_api.g_varchar2

Line 1324: ,p_aat_information11 in varchar2 default hr_api.g_varchar2

1320: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
1321: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
1322: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
1323: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
1324: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
1325: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
1326: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
1327: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
1328: ,p_aat_information15 in varchar2 default hr_api.g_varchar2

Line 1325: ,p_aat_information12 in varchar2 default hr_api.g_varchar2

1321: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
1322: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
1323: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
1324: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
1325: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
1326: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
1327: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
1328: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
1329: ,p_aat_information16 in varchar2 default hr_api.g_varchar2

Line 1326: ,p_aat_information13 in varchar2 default hr_api.g_varchar2

1322: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
1323: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
1324: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
1325: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
1326: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
1327: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
1328: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
1329: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
1330: ,p_aat_information17 in varchar2 default hr_api.g_varchar2

Line 1327: ,p_aat_information14 in varchar2 default hr_api.g_varchar2

1323: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
1324: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
1325: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
1326: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
1327: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
1328: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
1329: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
1330: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
1331: ,p_aat_information18 in varchar2 default hr_api.g_varchar2

Line 1328: ,p_aat_information15 in varchar2 default hr_api.g_varchar2

1324: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
1325: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
1326: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
1327: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
1328: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
1329: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
1330: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
1331: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
1332: ,p_aat_information19 in varchar2 default hr_api.g_varchar2

Line 1329: ,p_aat_information16 in varchar2 default hr_api.g_varchar2

1325: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
1326: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
1327: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
1328: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
1329: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
1330: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
1331: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
1332: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
1333: ,p_aat_information20 in varchar2 default hr_api.g_varchar2

Line 1330: ,p_aat_information17 in varchar2 default hr_api.g_varchar2

1326: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
1327: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
1328: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
1329: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
1330: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
1331: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
1332: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
1333: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
1334: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2

Line 1331: ,p_aat_information18 in varchar2 default hr_api.g_varchar2

1327: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
1328: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
1329: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
1330: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
1331: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
1332: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
1333: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
1334: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
1335: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2

Line 1332: ,p_aat_information19 in varchar2 default hr_api.g_varchar2

1328: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
1329: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
1330: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
1331: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
1332: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
1333: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
1334: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
1335: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
1336: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2

Line 1333: ,p_aat_information20 in varchar2 default hr_api.g_varchar2

1329: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
1330: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
1331: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
1332: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
1333: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
1334: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
1335: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
1336: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
1337: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2

Line 1334: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2

1330: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
1331: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
1332: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
1333: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
1334: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
1335: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
1336: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
1337: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2
1338: ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2

Line 1335: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2

1331: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
1332: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
1333: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
1334: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
1335: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
1336: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
1337: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2
1338: ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2
1339: ,p_effective_start_date out nocopy date

Line 1336: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2

1332: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
1333: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
1334: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
1335: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
1336: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
1337: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2
1338: ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2
1339: ,p_effective_start_date out nocopy date
1340: ,p_effective_end_date out nocopy date

Line 1337: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2

1333: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
1334: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
1335: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
1336: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
1337: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2
1338: ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2
1339: ,p_effective_start_date out nocopy date
1340: ,p_effective_end_date out nocopy date
1341: ) is

Line 1338: ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2

1334: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
1335: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
1336: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
1337: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2
1338: ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2
1339: ,p_effective_start_date out nocopy date
1340: ,p_effective_end_date out nocopy date
1341: ) is
1342: --