eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_ACC_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 195: When hr_api.check_integrity_violated Then

191: End If;
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 15);
194: Exception
195: When hr_api.check_integrity_violated Then
196: -- A check constraint has been violated
197: --
198: pqh_acc_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

195: When hr_api.check_integrity_violated Then
196: -- A check constraint has been violated
197: --
198: pqh_acc_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: --
203: pqh_acc_shd.constraint_error

Line 200: When hr_api.unique_integrity_violated Then

196: -- A check constraint has been violated
197: --
198: pqh_acc_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: --
203: pqh_acc_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: --
203: pqh_acc_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When Others Then
206: --
207: Raise;
208: End dt_update_dml;

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

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

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

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

Line 852: when hr_api.cannot_find_prog_unit then

848: );
849: --
850: exception
851: --
852: when hr_api.cannot_find_prog_unit then
853: --
854: hr_api.cannot_find_prog_unit_error
855: (p_module_name => 'PQH_ACCOMMODATIONS_F'
856: ,p_hook_type => 'AU');

Line 854: hr_api.cannot_find_prog_unit_error

850: exception
851: --
852: when hr_api.cannot_find_prog_unit then
853: --
854: hr_api.cannot_find_prog_unit_error
855: (p_module_name => 'PQH_ACCOMMODATIONS_F'
856: ,p_hook_type => 'AU');
857: --
858: end;

Line 917: If (p_rec.accommodation_name = hr_api.g_varchar2) then

913: -- p_rec plsql record structure
914: -- to see if a system default is being used. If a system default
915: -- is being used then we must set to the 'current' argument value.
916: --
917: If (p_rec.accommodation_name = hr_api.g_varchar2) then
918: p_rec.accommodation_name :=
919: pqh_acc_shd.g_old_rec.accommodation_name;
920: End If;
921: If (p_rec.business_group_id = hr_api.g_number) then

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

917: If (p_rec.accommodation_name = hr_api.g_varchar2) then
918: p_rec.accommodation_name :=
919: pqh_acc_shd.g_old_rec.accommodation_name;
920: End If;
921: If (p_rec.business_group_id = hr_api.g_number) then
922: p_rec.business_group_id :=
923: pqh_acc_shd.g_old_rec.business_group_id;
924: End If;
925: If (p_rec.location_id = hr_api.g_number) then

Line 925: If (p_rec.location_id = hr_api.g_number) then

921: If (p_rec.business_group_id = hr_api.g_number) then
922: p_rec.business_group_id :=
923: pqh_acc_shd.g_old_rec.business_group_id;
924: End If;
925: If (p_rec.location_id = hr_api.g_number) then
926: p_rec.location_id :=
927: pqh_acc_shd.g_old_rec.location_id;
928: End If;
929: If (p_rec.accommodation_desc = hr_api.g_varchar2) then

Line 929: If (p_rec.accommodation_desc = hr_api.g_varchar2) then

925: If (p_rec.location_id = hr_api.g_number) then
926: p_rec.location_id :=
927: pqh_acc_shd.g_old_rec.location_id;
928: End If;
929: If (p_rec.accommodation_desc = hr_api.g_varchar2) then
930: p_rec.accommodation_desc :=
931: pqh_acc_shd.g_old_rec.accommodation_desc;
932: End If;
933: If (p_rec.accommodation_type = hr_api.g_varchar2) then

Line 933: If (p_rec.accommodation_type = hr_api.g_varchar2) then

929: If (p_rec.accommodation_desc = hr_api.g_varchar2) then
930: p_rec.accommodation_desc :=
931: pqh_acc_shd.g_old_rec.accommodation_desc;
932: End If;
933: If (p_rec.accommodation_type = hr_api.g_varchar2) then
934: p_rec.accommodation_type :=
935: pqh_acc_shd.g_old_rec.accommodation_type;
936: End If;
937: If (p_rec.style = hr_api.g_varchar2) then

Line 937: If (p_rec.style = hr_api.g_varchar2) then

933: If (p_rec.accommodation_type = hr_api.g_varchar2) then
934: p_rec.accommodation_type :=
935: pqh_acc_shd.g_old_rec.accommodation_type;
936: End If;
937: If (p_rec.style = hr_api.g_varchar2) then
938: p_rec.style :=
939: pqh_acc_shd.g_old_rec.style;
940: End If;
941: If (p_rec.address_line_1 = hr_api.g_varchar2) then

Line 941: If (p_rec.address_line_1 = hr_api.g_varchar2) then

937: If (p_rec.style = hr_api.g_varchar2) then
938: p_rec.style :=
939: pqh_acc_shd.g_old_rec.style;
940: End If;
941: If (p_rec.address_line_1 = hr_api.g_varchar2) then
942: p_rec.address_line_1 :=
943: pqh_acc_shd.g_old_rec.address_line_1;
944: End If;
945: If (p_rec.address_line_2 = hr_api.g_varchar2) then

Line 945: If (p_rec.address_line_2 = hr_api.g_varchar2) then

941: If (p_rec.address_line_1 = hr_api.g_varchar2) then
942: p_rec.address_line_1 :=
943: pqh_acc_shd.g_old_rec.address_line_1;
944: End If;
945: If (p_rec.address_line_2 = hr_api.g_varchar2) then
946: p_rec.address_line_2 :=
947: pqh_acc_shd.g_old_rec.address_line_2;
948: End If;
949: If (p_rec.address_line_3 = hr_api.g_varchar2) then

Line 949: If (p_rec.address_line_3 = hr_api.g_varchar2) then

945: If (p_rec.address_line_2 = hr_api.g_varchar2) then
946: p_rec.address_line_2 :=
947: pqh_acc_shd.g_old_rec.address_line_2;
948: End If;
949: If (p_rec.address_line_3 = hr_api.g_varchar2) then
950: p_rec.address_line_3 :=
951: pqh_acc_shd.g_old_rec.address_line_3;
952: End If;
953: If (p_rec.town_or_city = hr_api.g_varchar2) then

Line 953: If (p_rec.town_or_city = hr_api.g_varchar2) then

949: If (p_rec.address_line_3 = hr_api.g_varchar2) then
950: p_rec.address_line_3 :=
951: pqh_acc_shd.g_old_rec.address_line_3;
952: End If;
953: If (p_rec.town_or_city = hr_api.g_varchar2) then
954: p_rec.town_or_city :=
955: pqh_acc_shd.g_old_rec.town_or_city;
956: End If;
957: If (p_rec.country = hr_api.g_varchar2) then

Line 957: If (p_rec.country = hr_api.g_varchar2) then

953: If (p_rec.town_or_city = hr_api.g_varchar2) then
954: p_rec.town_or_city :=
955: pqh_acc_shd.g_old_rec.town_or_city;
956: End If;
957: If (p_rec.country = hr_api.g_varchar2) then
958: p_rec.country :=
959: pqh_acc_shd.g_old_rec.country;
960: End If;
961: If (p_rec.postal_code = hr_api.g_varchar2) then

Line 961: If (p_rec.postal_code = hr_api.g_varchar2) then

957: If (p_rec.country = hr_api.g_varchar2) then
958: p_rec.country :=
959: pqh_acc_shd.g_old_rec.country;
960: End If;
961: If (p_rec.postal_code = hr_api.g_varchar2) then
962: p_rec.postal_code :=
963: pqh_acc_shd.g_old_rec.postal_code;
964: End If;
965: If (p_rec.region_1 = hr_api.g_varchar2) then

Line 965: If (p_rec.region_1 = hr_api.g_varchar2) then

961: If (p_rec.postal_code = hr_api.g_varchar2) then
962: p_rec.postal_code :=
963: pqh_acc_shd.g_old_rec.postal_code;
964: End If;
965: If (p_rec.region_1 = hr_api.g_varchar2) then
966: p_rec.region_1 :=
967: pqh_acc_shd.g_old_rec.region_1;
968: End If;
969: If (p_rec.region_2 = hr_api.g_varchar2) then

Line 969: If (p_rec.region_2 = hr_api.g_varchar2) then

965: If (p_rec.region_1 = hr_api.g_varchar2) then
966: p_rec.region_1 :=
967: pqh_acc_shd.g_old_rec.region_1;
968: End If;
969: If (p_rec.region_2 = hr_api.g_varchar2) then
970: p_rec.region_2 :=
971: pqh_acc_shd.g_old_rec.region_2;
972: End If;
973: If (p_rec.region_3 = hr_api.g_varchar2) then

Line 973: If (p_rec.region_3 = hr_api.g_varchar2) then

969: If (p_rec.region_2 = hr_api.g_varchar2) then
970: p_rec.region_2 :=
971: pqh_acc_shd.g_old_rec.region_2;
972: End If;
973: If (p_rec.region_3 = hr_api.g_varchar2) then
974: p_rec.region_3 :=
975: pqh_acc_shd.g_old_rec.region_3;
976: End If;
977: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then

Line 977: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then

973: If (p_rec.region_3 = hr_api.g_varchar2) then
974: p_rec.region_3 :=
975: pqh_acc_shd.g_old_rec.region_3;
976: End If;
977: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
978: p_rec.telephone_number_1 :=
979: pqh_acc_shd.g_old_rec.telephone_number_1;
980: End If;
981: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then

Line 981: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then

977: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
978: p_rec.telephone_number_1 :=
979: pqh_acc_shd.g_old_rec.telephone_number_1;
980: End If;
981: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
982: p_rec.telephone_number_2 :=
983: pqh_acc_shd.g_old_rec.telephone_number_2;
984: End If;
985: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then

Line 985: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then

981: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
982: p_rec.telephone_number_2 :=
983: pqh_acc_shd.g_old_rec.telephone_number_2;
984: End If;
985: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
986: p_rec.telephone_number_3 :=
987: pqh_acc_shd.g_old_rec.telephone_number_3;
988: End If;
989: If (p_rec.floor_number = hr_api.g_varchar2) then

Line 989: If (p_rec.floor_number = hr_api.g_varchar2) then

985: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
986: p_rec.telephone_number_3 :=
987: pqh_acc_shd.g_old_rec.telephone_number_3;
988: End If;
989: If (p_rec.floor_number = hr_api.g_varchar2) then
990: p_rec.floor_number :=
991: pqh_acc_shd.g_old_rec.floor_number;
992: End If;
993: If (p_rec.floor_area = hr_api.g_number) then

Line 993: If (p_rec.floor_area = hr_api.g_number) then

989: If (p_rec.floor_number = hr_api.g_varchar2) then
990: p_rec.floor_number :=
991: pqh_acc_shd.g_old_rec.floor_number;
992: End If;
993: If (p_rec.floor_area = hr_api.g_number) then
994: p_rec.floor_area :=
995: pqh_acc_shd.g_old_rec.floor_area;
996: End If;
997: If (p_rec.floor_area_measure_unit = hr_api.g_varchar2) then

Line 997: If (p_rec.floor_area_measure_unit = hr_api.g_varchar2) then

993: If (p_rec.floor_area = hr_api.g_number) then
994: p_rec.floor_area :=
995: pqh_acc_shd.g_old_rec.floor_area;
996: End If;
997: If (p_rec.floor_area_measure_unit = hr_api.g_varchar2) then
998: p_rec.floor_area_measure_unit :=
999: pqh_acc_shd.g_old_rec.floor_area_measure_unit;
1000: End If;
1001: If (p_rec.main_rooms = hr_api.g_number) then

Line 1001: If (p_rec.main_rooms = hr_api.g_number) then

997: If (p_rec.floor_area_measure_unit = hr_api.g_varchar2) then
998: p_rec.floor_area_measure_unit :=
999: pqh_acc_shd.g_old_rec.floor_area_measure_unit;
1000: End If;
1001: If (p_rec.main_rooms = hr_api.g_number) then
1002: p_rec.main_rooms :=
1003: pqh_acc_shd.g_old_rec.main_rooms;
1004: End If;
1005: If (p_rec.family_size = hr_api.g_number) then

Line 1005: If (p_rec.family_size = hr_api.g_number) then

1001: If (p_rec.main_rooms = hr_api.g_number) then
1002: p_rec.main_rooms :=
1003: pqh_acc_shd.g_old_rec.main_rooms;
1004: End If;
1005: If (p_rec.family_size = hr_api.g_number) then
1006: p_rec.family_size :=
1007: pqh_acc_shd.g_old_rec.family_size;
1008: End If;
1009: If (p_rec.suitability_disabled = hr_api.g_varchar2) then

Line 1009: If (p_rec.suitability_disabled = hr_api.g_varchar2) then

1005: If (p_rec.family_size = hr_api.g_number) then
1006: p_rec.family_size :=
1007: pqh_acc_shd.g_old_rec.family_size;
1008: End If;
1009: If (p_rec.suitability_disabled = hr_api.g_varchar2) then
1010: p_rec.suitability_disabled :=
1011: pqh_acc_shd.g_old_rec.suitability_disabled;
1012: End If;
1013: If (p_rec.rental_value = hr_api.g_number) then

Line 1013: If (p_rec.rental_value = hr_api.g_number) then

1009: If (p_rec.suitability_disabled = hr_api.g_varchar2) then
1010: p_rec.suitability_disabled :=
1011: pqh_acc_shd.g_old_rec.suitability_disabled;
1012: End If;
1013: If (p_rec.rental_value = hr_api.g_number) then
1014: p_rec.rental_value :=
1015: pqh_acc_shd.g_old_rec.rental_value;
1016: End If;
1017: If (p_rec.rental_value_currency = hr_api.g_varchar2) then

Line 1017: If (p_rec.rental_value_currency = hr_api.g_varchar2) then

1013: If (p_rec.rental_value = hr_api.g_number) then
1014: p_rec.rental_value :=
1015: pqh_acc_shd.g_old_rec.rental_value;
1016: End If;
1017: If (p_rec.rental_value_currency = hr_api.g_varchar2) then
1018: p_rec.rental_value_currency :=
1019: pqh_acc_shd.g_old_rec.rental_value_currency;
1020: End If;
1021: If (p_rec.owner = hr_api.g_varchar2) then

Line 1021: If (p_rec.owner = hr_api.g_varchar2) then

1017: If (p_rec.rental_value_currency = hr_api.g_varchar2) then
1018: p_rec.rental_value_currency :=
1019: pqh_acc_shd.g_old_rec.rental_value_currency;
1020: End If;
1021: If (p_rec.owner = hr_api.g_varchar2) then
1022: p_rec.owner :=
1023: pqh_acc_shd.g_old_rec.owner;
1024: End If;
1025: If (p_rec.comments = hr_api.g_varchar2) then

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

1021: If (p_rec.owner = hr_api.g_varchar2) then
1022: p_rec.owner :=
1023: pqh_acc_shd.g_old_rec.owner;
1024: End If;
1025: If (p_rec.comments = hr_api.g_varchar2) then
1026: p_rec.comments :=
1027: pqh_acc_shd.g_old_rec.comments;
1028: End If;
1029: If (p_rec.information_category = hr_api.g_varchar2) then

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

1025: If (p_rec.comments = hr_api.g_varchar2) then
1026: p_rec.comments :=
1027: pqh_acc_shd.g_old_rec.comments;
1028: End If;
1029: If (p_rec.information_category = hr_api.g_varchar2) then
1030: p_rec.information_category :=
1031: pqh_acc_shd.g_old_rec.information_category;
1032: End If;
1033: If (p_rec.information1 = hr_api.g_varchar2) then

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

1029: If (p_rec.information_category = hr_api.g_varchar2) then
1030: p_rec.information_category :=
1031: pqh_acc_shd.g_old_rec.information_category;
1032: End If;
1033: If (p_rec.information1 = hr_api.g_varchar2) then
1034: p_rec.information1 :=
1035: pqh_acc_shd.g_old_rec.information1;
1036: End If;
1037: If (p_rec.information2 = hr_api.g_varchar2) then

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

1033: If (p_rec.information1 = hr_api.g_varchar2) then
1034: p_rec.information1 :=
1035: pqh_acc_shd.g_old_rec.information1;
1036: End If;
1037: If (p_rec.information2 = hr_api.g_varchar2) then
1038: p_rec.information2 :=
1039: pqh_acc_shd.g_old_rec.information2;
1040: End If;
1041: If (p_rec.information3 = hr_api.g_varchar2) then

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

1037: If (p_rec.information2 = hr_api.g_varchar2) then
1038: p_rec.information2 :=
1039: pqh_acc_shd.g_old_rec.information2;
1040: End If;
1041: If (p_rec.information3 = hr_api.g_varchar2) then
1042: p_rec.information3 :=
1043: pqh_acc_shd.g_old_rec.information3;
1044: End If;
1045: If (p_rec.information4 = hr_api.g_varchar2) then

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

1041: If (p_rec.information3 = hr_api.g_varchar2) then
1042: p_rec.information3 :=
1043: pqh_acc_shd.g_old_rec.information3;
1044: End If;
1045: If (p_rec.information4 = hr_api.g_varchar2) then
1046: p_rec.information4 :=
1047: pqh_acc_shd.g_old_rec.information4;
1048: End If;
1049: If (p_rec.information5 = hr_api.g_varchar2) then

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

1045: If (p_rec.information4 = hr_api.g_varchar2) then
1046: p_rec.information4 :=
1047: pqh_acc_shd.g_old_rec.information4;
1048: End If;
1049: If (p_rec.information5 = hr_api.g_varchar2) then
1050: p_rec.information5 :=
1051: pqh_acc_shd.g_old_rec.information5;
1052: End If;
1053: If (p_rec.information6 = hr_api.g_varchar2) then

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

1049: If (p_rec.information5 = hr_api.g_varchar2) then
1050: p_rec.information5 :=
1051: pqh_acc_shd.g_old_rec.information5;
1052: End If;
1053: If (p_rec.information6 = hr_api.g_varchar2) then
1054: p_rec.information6 :=
1055: pqh_acc_shd.g_old_rec.information6;
1056: End If;
1057: If (p_rec.information7 = hr_api.g_varchar2) then

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

1053: If (p_rec.information6 = hr_api.g_varchar2) then
1054: p_rec.information6 :=
1055: pqh_acc_shd.g_old_rec.information6;
1056: End If;
1057: If (p_rec.information7 = hr_api.g_varchar2) then
1058: p_rec.information7 :=
1059: pqh_acc_shd.g_old_rec.information7;
1060: End If;
1061: If (p_rec.information8 = hr_api.g_varchar2) then

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

1057: If (p_rec.information7 = hr_api.g_varchar2) then
1058: p_rec.information7 :=
1059: pqh_acc_shd.g_old_rec.information7;
1060: End If;
1061: If (p_rec.information8 = hr_api.g_varchar2) then
1062: p_rec.information8 :=
1063: pqh_acc_shd.g_old_rec.information8;
1064: End If;
1065: If (p_rec.information9 = hr_api.g_varchar2) then

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

1061: If (p_rec.information8 = hr_api.g_varchar2) then
1062: p_rec.information8 :=
1063: pqh_acc_shd.g_old_rec.information8;
1064: End If;
1065: If (p_rec.information9 = hr_api.g_varchar2) then
1066: p_rec.information9 :=
1067: pqh_acc_shd.g_old_rec.information9;
1068: End If;
1069: If (p_rec.information10 = hr_api.g_varchar2) then

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

1065: If (p_rec.information9 = hr_api.g_varchar2) then
1066: p_rec.information9 :=
1067: pqh_acc_shd.g_old_rec.information9;
1068: End If;
1069: If (p_rec.information10 = hr_api.g_varchar2) then
1070: p_rec.information10 :=
1071: pqh_acc_shd.g_old_rec.information10;
1072: End If;
1073: If (p_rec.information11 = hr_api.g_varchar2) then

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

1069: If (p_rec.information10 = hr_api.g_varchar2) then
1070: p_rec.information10 :=
1071: pqh_acc_shd.g_old_rec.information10;
1072: End If;
1073: If (p_rec.information11 = hr_api.g_varchar2) then
1074: p_rec.information11 :=
1075: pqh_acc_shd.g_old_rec.information11;
1076: End If;
1077: If (p_rec.information12 = hr_api.g_varchar2) then

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

1073: If (p_rec.information11 = hr_api.g_varchar2) then
1074: p_rec.information11 :=
1075: pqh_acc_shd.g_old_rec.information11;
1076: End If;
1077: If (p_rec.information12 = hr_api.g_varchar2) then
1078: p_rec.information12 :=
1079: pqh_acc_shd.g_old_rec.information12;
1080: End If;
1081: If (p_rec.information13 = hr_api.g_varchar2) then

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

1077: If (p_rec.information12 = hr_api.g_varchar2) then
1078: p_rec.information12 :=
1079: pqh_acc_shd.g_old_rec.information12;
1080: End If;
1081: If (p_rec.information13 = hr_api.g_varchar2) then
1082: p_rec.information13 :=
1083: pqh_acc_shd.g_old_rec.information13;
1084: End If;
1085: If (p_rec.information14 = hr_api.g_varchar2) then

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

1081: If (p_rec.information13 = hr_api.g_varchar2) then
1082: p_rec.information13 :=
1083: pqh_acc_shd.g_old_rec.information13;
1084: End If;
1085: If (p_rec.information14 = hr_api.g_varchar2) then
1086: p_rec.information14 :=
1087: pqh_acc_shd.g_old_rec.information14;
1088: End If;
1089: If (p_rec.information15 = hr_api.g_varchar2) then

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

1085: If (p_rec.information14 = hr_api.g_varchar2) then
1086: p_rec.information14 :=
1087: pqh_acc_shd.g_old_rec.information14;
1088: End If;
1089: If (p_rec.information15 = hr_api.g_varchar2) then
1090: p_rec.information15 :=
1091: pqh_acc_shd.g_old_rec.information15;
1092: End If;
1093: If (p_rec.information16 = hr_api.g_varchar2) then

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

1089: If (p_rec.information15 = hr_api.g_varchar2) then
1090: p_rec.information15 :=
1091: pqh_acc_shd.g_old_rec.information15;
1092: End If;
1093: If (p_rec.information16 = hr_api.g_varchar2) then
1094: p_rec.information16 :=
1095: pqh_acc_shd.g_old_rec.information16;
1096: End If;
1097: If (p_rec.information17 = hr_api.g_varchar2) then

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

1093: If (p_rec.information16 = hr_api.g_varchar2) then
1094: p_rec.information16 :=
1095: pqh_acc_shd.g_old_rec.information16;
1096: End If;
1097: If (p_rec.information17 = hr_api.g_varchar2) then
1098: p_rec.information17 :=
1099: pqh_acc_shd.g_old_rec.information17;
1100: End If;
1101: If (p_rec.information18 = hr_api.g_varchar2) then

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

1097: If (p_rec.information17 = hr_api.g_varchar2) then
1098: p_rec.information17 :=
1099: pqh_acc_shd.g_old_rec.information17;
1100: End If;
1101: If (p_rec.information18 = hr_api.g_varchar2) then
1102: p_rec.information18 :=
1103: pqh_acc_shd.g_old_rec.information18;
1104: End If;
1105: If (p_rec.information19 = hr_api.g_varchar2) then

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

1101: If (p_rec.information18 = hr_api.g_varchar2) then
1102: p_rec.information18 :=
1103: pqh_acc_shd.g_old_rec.information18;
1104: End If;
1105: If (p_rec.information19 = hr_api.g_varchar2) then
1106: p_rec.information19 :=
1107: pqh_acc_shd.g_old_rec.information19;
1108: End If;
1109: If (p_rec.information20 = hr_api.g_varchar2) then

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

1105: If (p_rec.information19 = hr_api.g_varchar2) then
1106: p_rec.information19 :=
1107: pqh_acc_shd.g_old_rec.information19;
1108: End If;
1109: If (p_rec.information20 = hr_api.g_varchar2) then
1110: p_rec.information20 :=
1111: pqh_acc_shd.g_old_rec.information20;
1112: End If;
1113: If (p_rec.information21 = hr_api.g_varchar2) then

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

1109: If (p_rec.information20 = hr_api.g_varchar2) then
1110: p_rec.information20 :=
1111: pqh_acc_shd.g_old_rec.information20;
1112: End If;
1113: If (p_rec.information21 = hr_api.g_varchar2) then
1114: p_rec.information21 :=
1115: pqh_acc_shd.g_old_rec.information21;
1116: End If;
1117: If (p_rec.information22 = hr_api.g_varchar2) then

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

1113: If (p_rec.information21 = hr_api.g_varchar2) then
1114: p_rec.information21 :=
1115: pqh_acc_shd.g_old_rec.information21;
1116: End If;
1117: If (p_rec.information22 = hr_api.g_varchar2) then
1118: p_rec.information22 :=
1119: pqh_acc_shd.g_old_rec.information22;
1120: End If;
1121: If (p_rec.information23 = hr_api.g_varchar2) then

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

1117: If (p_rec.information22 = hr_api.g_varchar2) then
1118: p_rec.information22 :=
1119: pqh_acc_shd.g_old_rec.information22;
1120: End If;
1121: If (p_rec.information23 = hr_api.g_varchar2) then
1122: p_rec.information23 :=
1123: pqh_acc_shd.g_old_rec.information23;
1124: End If;
1125: If (p_rec.information24 = hr_api.g_varchar2) then

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

1121: If (p_rec.information23 = hr_api.g_varchar2) then
1122: p_rec.information23 :=
1123: pqh_acc_shd.g_old_rec.information23;
1124: End If;
1125: If (p_rec.information24 = hr_api.g_varchar2) then
1126: p_rec.information24 :=
1127: pqh_acc_shd.g_old_rec.information24;
1128: End If;
1129: If (p_rec.information25 = hr_api.g_varchar2) then

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

1125: If (p_rec.information24 = hr_api.g_varchar2) then
1126: p_rec.information24 :=
1127: pqh_acc_shd.g_old_rec.information24;
1128: End If;
1129: If (p_rec.information25 = hr_api.g_varchar2) then
1130: p_rec.information25 :=
1131: pqh_acc_shd.g_old_rec.information25;
1132: End If;
1133: If (p_rec.information26 = hr_api.g_varchar2) then

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

1129: If (p_rec.information25 = hr_api.g_varchar2) then
1130: p_rec.information25 :=
1131: pqh_acc_shd.g_old_rec.information25;
1132: End If;
1133: If (p_rec.information26 = hr_api.g_varchar2) then
1134: p_rec.information26 :=
1135: pqh_acc_shd.g_old_rec.information26;
1136: End If;
1137: If (p_rec.information27 = hr_api.g_varchar2) then

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

1133: If (p_rec.information26 = hr_api.g_varchar2) then
1134: p_rec.information26 :=
1135: pqh_acc_shd.g_old_rec.information26;
1136: End If;
1137: If (p_rec.information27 = hr_api.g_varchar2) then
1138: p_rec.information27 :=
1139: pqh_acc_shd.g_old_rec.information27;
1140: End If;
1141: If (p_rec.information28 = hr_api.g_varchar2) then

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

1137: If (p_rec.information27 = hr_api.g_varchar2) then
1138: p_rec.information27 :=
1139: pqh_acc_shd.g_old_rec.information27;
1140: End If;
1141: If (p_rec.information28 = hr_api.g_varchar2) then
1142: p_rec.information28 :=
1143: pqh_acc_shd.g_old_rec.information28;
1144: End If;
1145: If (p_rec.information29 = hr_api.g_varchar2) then

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

1141: If (p_rec.information28 = hr_api.g_varchar2) then
1142: p_rec.information28 :=
1143: pqh_acc_shd.g_old_rec.information28;
1144: End If;
1145: If (p_rec.information29 = hr_api.g_varchar2) then
1146: p_rec.information29 :=
1147: pqh_acc_shd.g_old_rec.information29;
1148: End If;
1149: If (p_rec.information30 = hr_api.g_varchar2) then

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

1145: If (p_rec.information29 = hr_api.g_varchar2) then
1146: p_rec.information29 :=
1147: pqh_acc_shd.g_old_rec.information29;
1148: End If;
1149: If (p_rec.information30 = hr_api.g_varchar2) then
1150: p_rec.information30 :=
1151: pqh_acc_shd.g_old_rec.information30;
1152: End If;
1153: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

1149: If (p_rec.information30 = hr_api.g_varchar2) then
1150: p_rec.information30 :=
1151: pqh_acc_shd.g_old_rec.information30;
1152: End If;
1153: If (p_rec.attribute_category = hr_api.g_varchar2) then
1154: p_rec.attribute_category :=
1155: pqh_acc_shd.g_old_rec.attribute_category;
1156: End If;
1157: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

1153: If (p_rec.attribute_category = hr_api.g_varchar2) then
1154: p_rec.attribute_category :=
1155: pqh_acc_shd.g_old_rec.attribute_category;
1156: End If;
1157: If (p_rec.attribute1 = hr_api.g_varchar2) then
1158: p_rec.attribute1 :=
1159: pqh_acc_shd.g_old_rec.attribute1;
1160: End If;
1161: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

1157: If (p_rec.attribute1 = hr_api.g_varchar2) then
1158: p_rec.attribute1 :=
1159: pqh_acc_shd.g_old_rec.attribute1;
1160: End If;
1161: If (p_rec.attribute2 = hr_api.g_varchar2) then
1162: p_rec.attribute2 :=
1163: pqh_acc_shd.g_old_rec.attribute2;
1164: End If;
1165: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

1161: If (p_rec.attribute2 = hr_api.g_varchar2) then
1162: p_rec.attribute2 :=
1163: pqh_acc_shd.g_old_rec.attribute2;
1164: End If;
1165: If (p_rec.attribute3 = hr_api.g_varchar2) then
1166: p_rec.attribute3 :=
1167: pqh_acc_shd.g_old_rec.attribute3;
1168: End If;
1169: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

1165: If (p_rec.attribute3 = hr_api.g_varchar2) then
1166: p_rec.attribute3 :=
1167: pqh_acc_shd.g_old_rec.attribute3;
1168: End If;
1169: If (p_rec.attribute4 = hr_api.g_varchar2) then
1170: p_rec.attribute4 :=
1171: pqh_acc_shd.g_old_rec.attribute4;
1172: End If;
1173: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

1169: If (p_rec.attribute4 = hr_api.g_varchar2) then
1170: p_rec.attribute4 :=
1171: pqh_acc_shd.g_old_rec.attribute4;
1172: End If;
1173: If (p_rec.attribute5 = hr_api.g_varchar2) then
1174: p_rec.attribute5 :=
1175: pqh_acc_shd.g_old_rec.attribute5;
1176: End If;
1177: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

1173: If (p_rec.attribute5 = hr_api.g_varchar2) then
1174: p_rec.attribute5 :=
1175: pqh_acc_shd.g_old_rec.attribute5;
1176: End If;
1177: If (p_rec.attribute6 = hr_api.g_varchar2) then
1178: p_rec.attribute6 :=
1179: pqh_acc_shd.g_old_rec.attribute6;
1180: End If;
1181: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

1177: If (p_rec.attribute6 = hr_api.g_varchar2) then
1178: p_rec.attribute6 :=
1179: pqh_acc_shd.g_old_rec.attribute6;
1180: End If;
1181: If (p_rec.attribute7 = hr_api.g_varchar2) then
1182: p_rec.attribute7 :=
1183: pqh_acc_shd.g_old_rec.attribute7;
1184: End If;
1185: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

1181: If (p_rec.attribute7 = hr_api.g_varchar2) then
1182: p_rec.attribute7 :=
1183: pqh_acc_shd.g_old_rec.attribute7;
1184: End If;
1185: If (p_rec.attribute8 = hr_api.g_varchar2) then
1186: p_rec.attribute8 :=
1187: pqh_acc_shd.g_old_rec.attribute8;
1188: End If;
1189: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

1185: If (p_rec.attribute8 = hr_api.g_varchar2) then
1186: p_rec.attribute8 :=
1187: pqh_acc_shd.g_old_rec.attribute8;
1188: End If;
1189: If (p_rec.attribute9 = hr_api.g_varchar2) then
1190: p_rec.attribute9 :=
1191: pqh_acc_shd.g_old_rec.attribute9;
1192: End If;
1193: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

1189: If (p_rec.attribute9 = hr_api.g_varchar2) then
1190: p_rec.attribute9 :=
1191: pqh_acc_shd.g_old_rec.attribute9;
1192: End If;
1193: If (p_rec.attribute10 = hr_api.g_varchar2) then
1194: p_rec.attribute10 :=
1195: pqh_acc_shd.g_old_rec.attribute10;
1196: End If;
1197: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

1193: If (p_rec.attribute10 = hr_api.g_varchar2) then
1194: p_rec.attribute10 :=
1195: pqh_acc_shd.g_old_rec.attribute10;
1196: End If;
1197: If (p_rec.attribute11 = hr_api.g_varchar2) then
1198: p_rec.attribute11 :=
1199: pqh_acc_shd.g_old_rec.attribute11;
1200: End If;
1201: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

1197: If (p_rec.attribute11 = hr_api.g_varchar2) then
1198: p_rec.attribute11 :=
1199: pqh_acc_shd.g_old_rec.attribute11;
1200: End If;
1201: If (p_rec.attribute12 = hr_api.g_varchar2) then
1202: p_rec.attribute12 :=
1203: pqh_acc_shd.g_old_rec.attribute12;
1204: End If;
1205: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

1201: If (p_rec.attribute12 = hr_api.g_varchar2) then
1202: p_rec.attribute12 :=
1203: pqh_acc_shd.g_old_rec.attribute12;
1204: End If;
1205: If (p_rec.attribute13 = hr_api.g_varchar2) then
1206: p_rec.attribute13 :=
1207: pqh_acc_shd.g_old_rec.attribute13;
1208: End If;
1209: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

1205: If (p_rec.attribute13 = hr_api.g_varchar2) then
1206: p_rec.attribute13 :=
1207: pqh_acc_shd.g_old_rec.attribute13;
1208: End If;
1209: If (p_rec.attribute14 = hr_api.g_varchar2) then
1210: p_rec.attribute14 :=
1211: pqh_acc_shd.g_old_rec.attribute14;
1212: End If;
1213: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

1209: If (p_rec.attribute14 = hr_api.g_varchar2) then
1210: p_rec.attribute14 :=
1211: pqh_acc_shd.g_old_rec.attribute14;
1212: End If;
1213: If (p_rec.attribute15 = hr_api.g_varchar2) then
1214: p_rec.attribute15 :=
1215: pqh_acc_shd.g_old_rec.attribute15;
1216: End If;
1217: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

1213: If (p_rec.attribute15 = hr_api.g_varchar2) then
1214: p_rec.attribute15 :=
1215: pqh_acc_shd.g_old_rec.attribute15;
1216: End If;
1217: If (p_rec.attribute16 = hr_api.g_varchar2) then
1218: p_rec.attribute16 :=
1219: pqh_acc_shd.g_old_rec.attribute16;
1220: End If;
1221: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

1217: If (p_rec.attribute16 = hr_api.g_varchar2) then
1218: p_rec.attribute16 :=
1219: pqh_acc_shd.g_old_rec.attribute16;
1220: End If;
1221: If (p_rec.attribute17 = hr_api.g_varchar2) then
1222: p_rec.attribute17 :=
1223: pqh_acc_shd.g_old_rec.attribute17;
1224: End If;
1225: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

1221: If (p_rec.attribute17 = hr_api.g_varchar2) then
1222: p_rec.attribute17 :=
1223: pqh_acc_shd.g_old_rec.attribute17;
1224: End If;
1225: If (p_rec.attribute18 = hr_api.g_varchar2) then
1226: p_rec.attribute18 :=
1227: pqh_acc_shd.g_old_rec.attribute18;
1228: End If;
1229: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

1225: If (p_rec.attribute18 = hr_api.g_varchar2) then
1226: p_rec.attribute18 :=
1227: pqh_acc_shd.g_old_rec.attribute18;
1228: End If;
1229: If (p_rec.attribute19 = hr_api.g_varchar2) then
1230: p_rec.attribute19 :=
1231: pqh_acc_shd.g_old_rec.attribute19;
1232: End If;
1233: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

1229: If (p_rec.attribute19 = hr_api.g_varchar2) then
1230: p_rec.attribute19 :=
1231: pqh_acc_shd.g_old_rec.attribute19;
1232: End If;
1233: If (p_rec.attribute20 = hr_api.g_varchar2) then
1234: p_rec.attribute20 :=
1235: pqh_acc_shd.g_old_rec.attribute20;
1236: End If;
1237: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

1233: If (p_rec.attribute20 = hr_api.g_varchar2) then
1234: p_rec.attribute20 :=
1235: pqh_acc_shd.g_old_rec.attribute20;
1236: End If;
1237: If (p_rec.attribute21 = hr_api.g_varchar2) then
1238: p_rec.attribute21 :=
1239: pqh_acc_shd.g_old_rec.attribute21;
1240: End If;
1241: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

1237: If (p_rec.attribute21 = hr_api.g_varchar2) then
1238: p_rec.attribute21 :=
1239: pqh_acc_shd.g_old_rec.attribute21;
1240: End If;
1241: If (p_rec.attribute22 = hr_api.g_varchar2) then
1242: p_rec.attribute22 :=
1243: pqh_acc_shd.g_old_rec.attribute22;
1244: End If;
1245: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

1241: If (p_rec.attribute22 = hr_api.g_varchar2) then
1242: p_rec.attribute22 :=
1243: pqh_acc_shd.g_old_rec.attribute22;
1244: End If;
1245: If (p_rec.attribute23 = hr_api.g_varchar2) then
1246: p_rec.attribute23 :=
1247: pqh_acc_shd.g_old_rec.attribute23;
1248: End If;
1249: If (p_rec.attribute24 = hr_api.g_varchar2) then

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

1245: If (p_rec.attribute23 = hr_api.g_varchar2) then
1246: p_rec.attribute23 :=
1247: pqh_acc_shd.g_old_rec.attribute23;
1248: End If;
1249: If (p_rec.attribute24 = hr_api.g_varchar2) then
1250: p_rec.attribute24 :=
1251: pqh_acc_shd.g_old_rec.attribute24;
1252: End If;
1253: If (p_rec.attribute25 = hr_api.g_varchar2) then

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

1249: If (p_rec.attribute24 = hr_api.g_varchar2) then
1250: p_rec.attribute24 :=
1251: pqh_acc_shd.g_old_rec.attribute24;
1252: End If;
1253: If (p_rec.attribute25 = hr_api.g_varchar2) then
1254: p_rec.attribute25 :=
1255: pqh_acc_shd.g_old_rec.attribute25;
1256: End If;
1257: If (p_rec.attribute26 = hr_api.g_varchar2) then

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

1253: If (p_rec.attribute25 = hr_api.g_varchar2) then
1254: p_rec.attribute25 :=
1255: pqh_acc_shd.g_old_rec.attribute25;
1256: End If;
1257: If (p_rec.attribute26 = hr_api.g_varchar2) then
1258: p_rec.attribute26 :=
1259: pqh_acc_shd.g_old_rec.attribute26;
1260: End If;
1261: If (p_rec.attribute27 = hr_api.g_varchar2) then

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

1257: If (p_rec.attribute26 = hr_api.g_varchar2) then
1258: p_rec.attribute26 :=
1259: pqh_acc_shd.g_old_rec.attribute26;
1260: End If;
1261: If (p_rec.attribute27 = hr_api.g_varchar2) then
1262: p_rec.attribute27 :=
1263: pqh_acc_shd.g_old_rec.attribute27;
1264: End If;
1265: If (p_rec.attribute28 = hr_api.g_varchar2) then

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

1261: If (p_rec.attribute27 = hr_api.g_varchar2) then
1262: p_rec.attribute27 :=
1263: pqh_acc_shd.g_old_rec.attribute27;
1264: End If;
1265: If (p_rec.attribute28 = hr_api.g_varchar2) then
1266: p_rec.attribute28 :=
1267: pqh_acc_shd.g_old_rec.attribute28;
1268: End If;
1269: If (p_rec.attribute29 = hr_api.g_varchar2) then

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

1265: If (p_rec.attribute28 = hr_api.g_varchar2) then
1266: p_rec.attribute28 :=
1267: pqh_acc_shd.g_old_rec.attribute28;
1268: End If;
1269: If (p_rec.attribute29 = hr_api.g_varchar2) then
1270: p_rec.attribute29 :=
1271: pqh_acc_shd.g_old_rec.attribute29;
1272: End If;
1273: If (p_rec.attribute30 = hr_api.g_varchar2) then

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

1269: If (p_rec.attribute29 = hr_api.g_varchar2) then
1270: p_rec.attribute29 :=
1271: pqh_acc_shd.g_old_rec.attribute29;
1272: End If;
1273: If (p_rec.attribute30 = hr_api.g_varchar2) then
1274: p_rec.attribute30 :=
1275: pqh_acc_shd.g_old_rec.attribute30;
1276: End If;
1277: --

Line 1372: ,p_accommodation_name in varchar2 default hr_api.g_varchar2

1368: (p_effective_date in date
1369: ,p_datetrack_mode in varchar2
1370: ,p_accommodation_id in number
1371: ,p_object_version_number in out nocopy number
1372: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
1373: ,p_business_group_id in number default hr_api.g_number
1374: ,p_location_id in number default hr_api.g_number
1375: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
1376: ,p_accommodation_type in varchar2 default hr_api.g_varchar2

Line 1373: ,p_business_group_id in number default hr_api.g_number

1369: ,p_datetrack_mode in varchar2
1370: ,p_accommodation_id in number
1371: ,p_object_version_number in out nocopy number
1372: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
1373: ,p_business_group_id in number default hr_api.g_number
1374: ,p_location_id in number default hr_api.g_number
1375: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
1376: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
1377: ,p_style in varchar2 default hr_api.g_varchar2

Line 1374: ,p_location_id in number default hr_api.g_number

1370: ,p_accommodation_id in number
1371: ,p_object_version_number in out nocopy number
1372: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
1373: ,p_business_group_id in number default hr_api.g_number
1374: ,p_location_id in number default hr_api.g_number
1375: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
1376: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
1377: ,p_style in varchar2 default hr_api.g_varchar2
1378: ,p_address_line_1 in varchar2 default hr_api.g_varchar2

Line 1375: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2

1371: ,p_object_version_number in out nocopy number
1372: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
1373: ,p_business_group_id in number default hr_api.g_number
1374: ,p_location_id in number default hr_api.g_number
1375: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
1376: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
1377: ,p_style in varchar2 default hr_api.g_varchar2
1378: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
1379: ,p_address_line_2 in varchar2 default hr_api.g_varchar2

Line 1376: ,p_accommodation_type in varchar2 default hr_api.g_varchar2

1372: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
1373: ,p_business_group_id in number default hr_api.g_number
1374: ,p_location_id in number default hr_api.g_number
1375: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
1376: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
1377: ,p_style in varchar2 default hr_api.g_varchar2
1378: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
1379: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
1380: ,p_address_line_3 in varchar2 default hr_api.g_varchar2

Line 1377: ,p_style in varchar2 default hr_api.g_varchar2

1373: ,p_business_group_id in number default hr_api.g_number
1374: ,p_location_id in number default hr_api.g_number
1375: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
1376: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
1377: ,p_style in varchar2 default hr_api.g_varchar2
1378: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
1379: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
1380: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
1381: ,p_town_or_city in varchar2 default hr_api.g_varchar2

Line 1378: ,p_address_line_1 in varchar2 default hr_api.g_varchar2

1374: ,p_location_id in number default hr_api.g_number
1375: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
1376: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
1377: ,p_style in varchar2 default hr_api.g_varchar2
1378: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
1379: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
1380: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
1381: ,p_town_or_city in varchar2 default hr_api.g_varchar2
1382: ,p_country in varchar2 default hr_api.g_varchar2

Line 1379: ,p_address_line_2 in varchar2 default hr_api.g_varchar2

1375: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
1376: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
1377: ,p_style in varchar2 default hr_api.g_varchar2
1378: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
1379: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
1380: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
1381: ,p_town_or_city in varchar2 default hr_api.g_varchar2
1382: ,p_country in varchar2 default hr_api.g_varchar2
1383: ,p_postal_code in varchar2 default hr_api.g_varchar2

Line 1380: ,p_address_line_3 in varchar2 default hr_api.g_varchar2

1376: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
1377: ,p_style in varchar2 default hr_api.g_varchar2
1378: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
1379: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
1380: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
1381: ,p_town_or_city in varchar2 default hr_api.g_varchar2
1382: ,p_country in varchar2 default hr_api.g_varchar2
1383: ,p_postal_code in varchar2 default hr_api.g_varchar2
1384: ,p_region_1 in varchar2 default hr_api.g_varchar2

Line 1381: ,p_town_or_city in varchar2 default hr_api.g_varchar2

1377: ,p_style in varchar2 default hr_api.g_varchar2
1378: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
1379: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
1380: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
1381: ,p_town_or_city in varchar2 default hr_api.g_varchar2
1382: ,p_country in varchar2 default hr_api.g_varchar2
1383: ,p_postal_code in varchar2 default hr_api.g_varchar2
1384: ,p_region_1 in varchar2 default hr_api.g_varchar2
1385: ,p_region_2 in varchar2 default hr_api.g_varchar2

Line 1382: ,p_country in varchar2 default hr_api.g_varchar2

1378: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
1379: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
1380: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
1381: ,p_town_or_city in varchar2 default hr_api.g_varchar2
1382: ,p_country in varchar2 default hr_api.g_varchar2
1383: ,p_postal_code in varchar2 default hr_api.g_varchar2
1384: ,p_region_1 in varchar2 default hr_api.g_varchar2
1385: ,p_region_2 in varchar2 default hr_api.g_varchar2
1386: ,p_region_3 in varchar2 default hr_api.g_varchar2

Line 1383: ,p_postal_code in varchar2 default hr_api.g_varchar2

1379: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
1380: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
1381: ,p_town_or_city in varchar2 default hr_api.g_varchar2
1382: ,p_country in varchar2 default hr_api.g_varchar2
1383: ,p_postal_code in varchar2 default hr_api.g_varchar2
1384: ,p_region_1 in varchar2 default hr_api.g_varchar2
1385: ,p_region_2 in varchar2 default hr_api.g_varchar2
1386: ,p_region_3 in varchar2 default hr_api.g_varchar2
1387: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 1384: ,p_region_1 in varchar2 default hr_api.g_varchar2

1380: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
1381: ,p_town_or_city in varchar2 default hr_api.g_varchar2
1382: ,p_country in varchar2 default hr_api.g_varchar2
1383: ,p_postal_code in varchar2 default hr_api.g_varchar2
1384: ,p_region_1 in varchar2 default hr_api.g_varchar2
1385: ,p_region_2 in varchar2 default hr_api.g_varchar2
1386: ,p_region_3 in varchar2 default hr_api.g_varchar2
1387: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
1388: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 1385: ,p_region_2 in varchar2 default hr_api.g_varchar2

1381: ,p_town_or_city in varchar2 default hr_api.g_varchar2
1382: ,p_country in varchar2 default hr_api.g_varchar2
1383: ,p_postal_code in varchar2 default hr_api.g_varchar2
1384: ,p_region_1 in varchar2 default hr_api.g_varchar2
1385: ,p_region_2 in varchar2 default hr_api.g_varchar2
1386: ,p_region_3 in varchar2 default hr_api.g_varchar2
1387: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
1388: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
1389: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

Line 1386: ,p_region_3 in varchar2 default hr_api.g_varchar2

1382: ,p_country in varchar2 default hr_api.g_varchar2
1383: ,p_postal_code in varchar2 default hr_api.g_varchar2
1384: ,p_region_1 in varchar2 default hr_api.g_varchar2
1385: ,p_region_2 in varchar2 default hr_api.g_varchar2
1386: ,p_region_3 in varchar2 default hr_api.g_varchar2
1387: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
1388: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
1389: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
1390: ,p_floor_number in varchar2 default hr_api.g_varchar2

Line 1387: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

1383: ,p_postal_code in varchar2 default hr_api.g_varchar2
1384: ,p_region_1 in varchar2 default hr_api.g_varchar2
1385: ,p_region_2 in varchar2 default hr_api.g_varchar2
1386: ,p_region_3 in varchar2 default hr_api.g_varchar2
1387: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
1388: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
1389: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
1390: ,p_floor_number in varchar2 default hr_api.g_varchar2
1391: ,p_floor_area in number default hr_api.g_number

Line 1388: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

1384: ,p_region_1 in varchar2 default hr_api.g_varchar2
1385: ,p_region_2 in varchar2 default hr_api.g_varchar2
1386: ,p_region_3 in varchar2 default hr_api.g_varchar2
1387: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
1388: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
1389: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
1390: ,p_floor_number in varchar2 default hr_api.g_varchar2
1391: ,p_floor_area in number default hr_api.g_number
1392: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2

Line 1389: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

1385: ,p_region_2 in varchar2 default hr_api.g_varchar2
1386: ,p_region_3 in varchar2 default hr_api.g_varchar2
1387: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
1388: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
1389: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
1390: ,p_floor_number in varchar2 default hr_api.g_varchar2
1391: ,p_floor_area in number default hr_api.g_number
1392: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
1393: ,p_main_rooms in number default hr_api.g_number

Line 1390: ,p_floor_number in varchar2 default hr_api.g_varchar2

1386: ,p_region_3 in varchar2 default hr_api.g_varchar2
1387: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
1388: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
1389: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
1390: ,p_floor_number in varchar2 default hr_api.g_varchar2
1391: ,p_floor_area in number default hr_api.g_number
1392: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
1393: ,p_main_rooms in number default hr_api.g_number
1394: ,p_family_size in number default hr_api.g_number

Line 1391: ,p_floor_area in number default hr_api.g_number

1387: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
1388: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
1389: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
1390: ,p_floor_number in varchar2 default hr_api.g_varchar2
1391: ,p_floor_area in number default hr_api.g_number
1392: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
1393: ,p_main_rooms in number default hr_api.g_number
1394: ,p_family_size in number default hr_api.g_number
1395: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2

Line 1392: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2

1388: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
1389: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
1390: ,p_floor_number in varchar2 default hr_api.g_varchar2
1391: ,p_floor_area in number default hr_api.g_number
1392: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
1393: ,p_main_rooms in number default hr_api.g_number
1394: ,p_family_size in number default hr_api.g_number
1395: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
1396: ,p_rental_value in number default hr_api.g_number

Line 1393: ,p_main_rooms in number default hr_api.g_number

1389: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
1390: ,p_floor_number in varchar2 default hr_api.g_varchar2
1391: ,p_floor_area in number default hr_api.g_number
1392: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
1393: ,p_main_rooms in number default hr_api.g_number
1394: ,p_family_size in number default hr_api.g_number
1395: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
1396: ,p_rental_value in number default hr_api.g_number
1397: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2

Line 1394: ,p_family_size in number default hr_api.g_number

1390: ,p_floor_number in varchar2 default hr_api.g_varchar2
1391: ,p_floor_area in number default hr_api.g_number
1392: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
1393: ,p_main_rooms in number default hr_api.g_number
1394: ,p_family_size in number default hr_api.g_number
1395: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
1396: ,p_rental_value in number default hr_api.g_number
1397: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
1398: ,p_owner in varchar2 default hr_api.g_varchar2

Line 1395: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2

1391: ,p_floor_area in number default hr_api.g_number
1392: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
1393: ,p_main_rooms in number default hr_api.g_number
1394: ,p_family_size in number default hr_api.g_number
1395: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
1396: ,p_rental_value in number default hr_api.g_number
1397: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
1398: ,p_owner in varchar2 default hr_api.g_varchar2
1399: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1396: ,p_rental_value in number default hr_api.g_number

1392: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
1393: ,p_main_rooms in number default hr_api.g_number
1394: ,p_family_size in number default hr_api.g_number
1395: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
1396: ,p_rental_value in number default hr_api.g_number
1397: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
1398: ,p_owner in varchar2 default hr_api.g_varchar2
1399: ,p_comments in varchar2 default hr_api.g_varchar2
1400: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 1397: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2

1393: ,p_main_rooms in number default hr_api.g_number
1394: ,p_family_size in number default hr_api.g_number
1395: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
1396: ,p_rental_value in number default hr_api.g_number
1397: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
1398: ,p_owner in varchar2 default hr_api.g_varchar2
1399: ,p_comments in varchar2 default hr_api.g_varchar2
1400: ,p_information_category in varchar2 default hr_api.g_varchar2
1401: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 1398: ,p_owner in varchar2 default hr_api.g_varchar2

1394: ,p_family_size in number default hr_api.g_number
1395: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
1396: ,p_rental_value in number default hr_api.g_number
1397: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
1398: ,p_owner in varchar2 default hr_api.g_varchar2
1399: ,p_comments in varchar2 default hr_api.g_varchar2
1400: ,p_information_category in varchar2 default hr_api.g_varchar2
1401: ,p_information1 in varchar2 default hr_api.g_varchar2
1402: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 1399: ,p_comments in varchar2 default hr_api.g_varchar2

1395: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
1396: ,p_rental_value in number default hr_api.g_number
1397: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
1398: ,p_owner in varchar2 default hr_api.g_varchar2
1399: ,p_comments in varchar2 default hr_api.g_varchar2
1400: ,p_information_category in varchar2 default hr_api.g_varchar2
1401: ,p_information1 in varchar2 default hr_api.g_varchar2
1402: ,p_information2 in varchar2 default hr_api.g_varchar2
1403: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 1400: ,p_information_category in varchar2 default hr_api.g_varchar2

1396: ,p_rental_value in number default hr_api.g_number
1397: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
1398: ,p_owner in varchar2 default hr_api.g_varchar2
1399: ,p_comments in varchar2 default hr_api.g_varchar2
1400: ,p_information_category in varchar2 default hr_api.g_varchar2
1401: ,p_information1 in varchar2 default hr_api.g_varchar2
1402: ,p_information2 in varchar2 default hr_api.g_varchar2
1403: ,p_information3 in varchar2 default hr_api.g_varchar2
1404: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 1401: ,p_information1 in varchar2 default hr_api.g_varchar2

1397: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
1398: ,p_owner in varchar2 default hr_api.g_varchar2
1399: ,p_comments in varchar2 default hr_api.g_varchar2
1400: ,p_information_category in varchar2 default hr_api.g_varchar2
1401: ,p_information1 in varchar2 default hr_api.g_varchar2
1402: ,p_information2 in varchar2 default hr_api.g_varchar2
1403: ,p_information3 in varchar2 default hr_api.g_varchar2
1404: ,p_information4 in varchar2 default hr_api.g_varchar2
1405: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 1402: ,p_information2 in varchar2 default hr_api.g_varchar2

1398: ,p_owner in varchar2 default hr_api.g_varchar2
1399: ,p_comments in varchar2 default hr_api.g_varchar2
1400: ,p_information_category in varchar2 default hr_api.g_varchar2
1401: ,p_information1 in varchar2 default hr_api.g_varchar2
1402: ,p_information2 in varchar2 default hr_api.g_varchar2
1403: ,p_information3 in varchar2 default hr_api.g_varchar2
1404: ,p_information4 in varchar2 default hr_api.g_varchar2
1405: ,p_information5 in varchar2 default hr_api.g_varchar2
1406: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 1403: ,p_information3 in varchar2 default hr_api.g_varchar2

1399: ,p_comments in varchar2 default hr_api.g_varchar2
1400: ,p_information_category in varchar2 default hr_api.g_varchar2
1401: ,p_information1 in varchar2 default hr_api.g_varchar2
1402: ,p_information2 in varchar2 default hr_api.g_varchar2
1403: ,p_information3 in varchar2 default hr_api.g_varchar2
1404: ,p_information4 in varchar2 default hr_api.g_varchar2
1405: ,p_information5 in varchar2 default hr_api.g_varchar2
1406: ,p_information6 in varchar2 default hr_api.g_varchar2
1407: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 1404: ,p_information4 in varchar2 default hr_api.g_varchar2

1400: ,p_information_category in varchar2 default hr_api.g_varchar2
1401: ,p_information1 in varchar2 default hr_api.g_varchar2
1402: ,p_information2 in varchar2 default hr_api.g_varchar2
1403: ,p_information3 in varchar2 default hr_api.g_varchar2
1404: ,p_information4 in varchar2 default hr_api.g_varchar2
1405: ,p_information5 in varchar2 default hr_api.g_varchar2
1406: ,p_information6 in varchar2 default hr_api.g_varchar2
1407: ,p_information7 in varchar2 default hr_api.g_varchar2
1408: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 1405: ,p_information5 in varchar2 default hr_api.g_varchar2

1401: ,p_information1 in varchar2 default hr_api.g_varchar2
1402: ,p_information2 in varchar2 default hr_api.g_varchar2
1403: ,p_information3 in varchar2 default hr_api.g_varchar2
1404: ,p_information4 in varchar2 default hr_api.g_varchar2
1405: ,p_information5 in varchar2 default hr_api.g_varchar2
1406: ,p_information6 in varchar2 default hr_api.g_varchar2
1407: ,p_information7 in varchar2 default hr_api.g_varchar2
1408: ,p_information8 in varchar2 default hr_api.g_varchar2
1409: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 1406: ,p_information6 in varchar2 default hr_api.g_varchar2

1402: ,p_information2 in varchar2 default hr_api.g_varchar2
1403: ,p_information3 in varchar2 default hr_api.g_varchar2
1404: ,p_information4 in varchar2 default hr_api.g_varchar2
1405: ,p_information5 in varchar2 default hr_api.g_varchar2
1406: ,p_information6 in varchar2 default hr_api.g_varchar2
1407: ,p_information7 in varchar2 default hr_api.g_varchar2
1408: ,p_information8 in varchar2 default hr_api.g_varchar2
1409: ,p_information9 in varchar2 default hr_api.g_varchar2
1410: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 1407: ,p_information7 in varchar2 default hr_api.g_varchar2

1403: ,p_information3 in varchar2 default hr_api.g_varchar2
1404: ,p_information4 in varchar2 default hr_api.g_varchar2
1405: ,p_information5 in varchar2 default hr_api.g_varchar2
1406: ,p_information6 in varchar2 default hr_api.g_varchar2
1407: ,p_information7 in varchar2 default hr_api.g_varchar2
1408: ,p_information8 in varchar2 default hr_api.g_varchar2
1409: ,p_information9 in varchar2 default hr_api.g_varchar2
1410: ,p_information10 in varchar2 default hr_api.g_varchar2
1411: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 1408: ,p_information8 in varchar2 default hr_api.g_varchar2

1404: ,p_information4 in varchar2 default hr_api.g_varchar2
1405: ,p_information5 in varchar2 default hr_api.g_varchar2
1406: ,p_information6 in varchar2 default hr_api.g_varchar2
1407: ,p_information7 in varchar2 default hr_api.g_varchar2
1408: ,p_information8 in varchar2 default hr_api.g_varchar2
1409: ,p_information9 in varchar2 default hr_api.g_varchar2
1410: ,p_information10 in varchar2 default hr_api.g_varchar2
1411: ,p_information11 in varchar2 default hr_api.g_varchar2
1412: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 1409: ,p_information9 in varchar2 default hr_api.g_varchar2

1405: ,p_information5 in varchar2 default hr_api.g_varchar2
1406: ,p_information6 in varchar2 default hr_api.g_varchar2
1407: ,p_information7 in varchar2 default hr_api.g_varchar2
1408: ,p_information8 in varchar2 default hr_api.g_varchar2
1409: ,p_information9 in varchar2 default hr_api.g_varchar2
1410: ,p_information10 in varchar2 default hr_api.g_varchar2
1411: ,p_information11 in varchar2 default hr_api.g_varchar2
1412: ,p_information12 in varchar2 default hr_api.g_varchar2
1413: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 1410: ,p_information10 in varchar2 default hr_api.g_varchar2

1406: ,p_information6 in varchar2 default hr_api.g_varchar2
1407: ,p_information7 in varchar2 default hr_api.g_varchar2
1408: ,p_information8 in varchar2 default hr_api.g_varchar2
1409: ,p_information9 in varchar2 default hr_api.g_varchar2
1410: ,p_information10 in varchar2 default hr_api.g_varchar2
1411: ,p_information11 in varchar2 default hr_api.g_varchar2
1412: ,p_information12 in varchar2 default hr_api.g_varchar2
1413: ,p_information13 in varchar2 default hr_api.g_varchar2
1414: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 1411: ,p_information11 in varchar2 default hr_api.g_varchar2

1407: ,p_information7 in varchar2 default hr_api.g_varchar2
1408: ,p_information8 in varchar2 default hr_api.g_varchar2
1409: ,p_information9 in varchar2 default hr_api.g_varchar2
1410: ,p_information10 in varchar2 default hr_api.g_varchar2
1411: ,p_information11 in varchar2 default hr_api.g_varchar2
1412: ,p_information12 in varchar2 default hr_api.g_varchar2
1413: ,p_information13 in varchar2 default hr_api.g_varchar2
1414: ,p_information14 in varchar2 default hr_api.g_varchar2
1415: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 1412: ,p_information12 in varchar2 default hr_api.g_varchar2

1408: ,p_information8 in varchar2 default hr_api.g_varchar2
1409: ,p_information9 in varchar2 default hr_api.g_varchar2
1410: ,p_information10 in varchar2 default hr_api.g_varchar2
1411: ,p_information11 in varchar2 default hr_api.g_varchar2
1412: ,p_information12 in varchar2 default hr_api.g_varchar2
1413: ,p_information13 in varchar2 default hr_api.g_varchar2
1414: ,p_information14 in varchar2 default hr_api.g_varchar2
1415: ,p_information15 in varchar2 default hr_api.g_varchar2
1416: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 1413: ,p_information13 in varchar2 default hr_api.g_varchar2

1409: ,p_information9 in varchar2 default hr_api.g_varchar2
1410: ,p_information10 in varchar2 default hr_api.g_varchar2
1411: ,p_information11 in varchar2 default hr_api.g_varchar2
1412: ,p_information12 in varchar2 default hr_api.g_varchar2
1413: ,p_information13 in varchar2 default hr_api.g_varchar2
1414: ,p_information14 in varchar2 default hr_api.g_varchar2
1415: ,p_information15 in varchar2 default hr_api.g_varchar2
1416: ,p_information16 in varchar2 default hr_api.g_varchar2
1417: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 1414: ,p_information14 in varchar2 default hr_api.g_varchar2

1410: ,p_information10 in varchar2 default hr_api.g_varchar2
1411: ,p_information11 in varchar2 default hr_api.g_varchar2
1412: ,p_information12 in varchar2 default hr_api.g_varchar2
1413: ,p_information13 in varchar2 default hr_api.g_varchar2
1414: ,p_information14 in varchar2 default hr_api.g_varchar2
1415: ,p_information15 in varchar2 default hr_api.g_varchar2
1416: ,p_information16 in varchar2 default hr_api.g_varchar2
1417: ,p_information17 in varchar2 default hr_api.g_varchar2
1418: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 1415: ,p_information15 in varchar2 default hr_api.g_varchar2

1411: ,p_information11 in varchar2 default hr_api.g_varchar2
1412: ,p_information12 in varchar2 default hr_api.g_varchar2
1413: ,p_information13 in varchar2 default hr_api.g_varchar2
1414: ,p_information14 in varchar2 default hr_api.g_varchar2
1415: ,p_information15 in varchar2 default hr_api.g_varchar2
1416: ,p_information16 in varchar2 default hr_api.g_varchar2
1417: ,p_information17 in varchar2 default hr_api.g_varchar2
1418: ,p_information18 in varchar2 default hr_api.g_varchar2
1419: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 1416: ,p_information16 in varchar2 default hr_api.g_varchar2

1412: ,p_information12 in varchar2 default hr_api.g_varchar2
1413: ,p_information13 in varchar2 default hr_api.g_varchar2
1414: ,p_information14 in varchar2 default hr_api.g_varchar2
1415: ,p_information15 in varchar2 default hr_api.g_varchar2
1416: ,p_information16 in varchar2 default hr_api.g_varchar2
1417: ,p_information17 in varchar2 default hr_api.g_varchar2
1418: ,p_information18 in varchar2 default hr_api.g_varchar2
1419: ,p_information19 in varchar2 default hr_api.g_varchar2
1420: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 1417: ,p_information17 in varchar2 default hr_api.g_varchar2

1413: ,p_information13 in varchar2 default hr_api.g_varchar2
1414: ,p_information14 in varchar2 default hr_api.g_varchar2
1415: ,p_information15 in varchar2 default hr_api.g_varchar2
1416: ,p_information16 in varchar2 default hr_api.g_varchar2
1417: ,p_information17 in varchar2 default hr_api.g_varchar2
1418: ,p_information18 in varchar2 default hr_api.g_varchar2
1419: ,p_information19 in varchar2 default hr_api.g_varchar2
1420: ,p_information20 in varchar2 default hr_api.g_varchar2
1421: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 1418: ,p_information18 in varchar2 default hr_api.g_varchar2

1414: ,p_information14 in varchar2 default hr_api.g_varchar2
1415: ,p_information15 in varchar2 default hr_api.g_varchar2
1416: ,p_information16 in varchar2 default hr_api.g_varchar2
1417: ,p_information17 in varchar2 default hr_api.g_varchar2
1418: ,p_information18 in varchar2 default hr_api.g_varchar2
1419: ,p_information19 in varchar2 default hr_api.g_varchar2
1420: ,p_information20 in varchar2 default hr_api.g_varchar2
1421: ,p_information21 in varchar2 default hr_api.g_varchar2
1422: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 1419: ,p_information19 in varchar2 default hr_api.g_varchar2

1415: ,p_information15 in varchar2 default hr_api.g_varchar2
1416: ,p_information16 in varchar2 default hr_api.g_varchar2
1417: ,p_information17 in varchar2 default hr_api.g_varchar2
1418: ,p_information18 in varchar2 default hr_api.g_varchar2
1419: ,p_information19 in varchar2 default hr_api.g_varchar2
1420: ,p_information20 in varchar2 default hr_api.g_varchar2
1421: ,p_information21 in varchar2 default hr_api.g_varchar2
1422: ,p_information22 in varchar2 default hr_api.g_varchar2
1423: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 1420: ,p_information20 in varchar2 default hr_api.g_varchar2

1416: ,p_information16 in varchar2 default hr_api.g_varchar2
1417: ,p_information17 in varchar2 default hr_api.g_varchar2
1418: ,p_information18 in varchar2 default hr_api.g_varchar2
1419: ,p_information19 in varchar2 default hr_api.g_varchar2
1420: ,p_information20 in varchar2 default hr_api.g_varchar2
1421: ,p_information21 in varchar2 default hr_api.g_varchar2
1422: ,p_information22 in varchar2 default hr_api.g_varchar2
1423: ,p_information23 in varchar2 default hr_api.g_varchar2
1424: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 1421: ,p_information21 in varchar2 default hr_api.g_varchar2

1417: ,p_information17 in varchar2 default hr_api.g_varchar2
1418: ,p_information18 in varchar2 default hr_api.g_varchar2
1419: ,p_information19 in varchar2 default hr_api.g_varchar2
1420: ,p_information20 in varchar2 default hr_api.g_varchar2
1421: ,p_information21 in varchar2 default hr_api.g_varchar2
1422: ,p_information22 in varchar2 default hr_api.g_varchar2
1423: ,p_information23 in varchar2 default hr_api.g_varchar2
1424: ,p_information24 in varchar2 default hr_api.g_varchar2
1425: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 1422: ,p_information22 in varchar2 default hr_api.g_varchar2

1418: ,p_information18 in varchar2 default hr_api.g_varchar2
1419: ,p_information19 in varchar2 default hr_api.g_varchar2
1420: ,p_information20 in varchar2 default hr_api.g_varchar2
1421: ,p_information21 in varchar2 default hr_api.g_varchar2
1422: ,p_information22 in varchar2 default hr_api.g_varchar2
1423: ,p_information23 in varchar2 default hr_api.g_varchar2
1424: ,p_information24 in varchar2 default hr_api.g_varchar2
1425: ,p_information25 in varchar2 default hr_api.g_varchar2
1426: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 1423: ,p_information23 in varchar2 default hr_api.g_varchar2

1419: ,p_information19 in varchar2 default hr_api.g_varchar2
1420: ,p_information20 in varchar2 default hr_api.g_varchar2
1421: ,p_information21 in varchar2 default hr_api.g_varchar2
1422: ,p_information22 in varchar2 default hr_api.g_varchar2
1423: ,p_information23 in varchar2 default hr_api.g_varchar2
1424: ,p_information24 in varchar2 default hr_api.g_varchar2
1425: ,p_information25 in varchar2 default hr_api.g_varchar2
1426: ,p_information26 in varchar2 default hr_api.g_varchar2
1427: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 1424: ,p_information24 in varchar2 default hr_api.g_varchar2

1420: ,p_information20 in varchar2 default hr_api.g_varchar2
1421: ,p_information21 in varchar2 default hr_api.g_varchar2
1422: ,p_information22 in varchar2 default hr_api.g_varchar2
1423: ,p_information23 in varchar2 default hr_api.g_varchar2
1424: ,p_information24 in varchar2 default hr_api.g_varchar2
1425: ,p_information25 in varchar2 default hr_api.g_varchar2
1426: ,p_information26 in varchar2 default hr_api.g_varchar2
1427: ,p_information27 in varchar2 default hr_api.g_varchar2
1428: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 1425: ,p_information25 in varchar2 default hr_api.g_varchar2

1421: ,p_information21 in varchar2 default hr_api.g_varchar2
1422: ,p_information22 in varchar2 default hr_api.g_varchar2
1423: ,p_information23 in varchar2 default hr_api.g_varchar2
1424: ,p_information24 in varchar2 default hr_api.g_varchar2
1425: ,p_information25 in varchar2 default hr_api.g_varchar2
1426: ,p_information26 in varchar2 default hr_api.g_varchar2
1427: ,p_information27 in varchar2 default hr_api.g_varchar2
1428: ,p_information28 in varchar2 default hr_api.g_varchar2
1429: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 1426: ,p_information26 in varchar2 default hr_api.g_varchar2

1422: ,p_information22 in varchar2 default hr_api.g_varchar2
1423: ,p_information23 in varchar2 default hr_api.g_varchar2
1424: ,p_information24 in varchar2 default hr_api.g_varchar2
1425: ,p_information25 in varchar2 default hr_api.g_varchar2
1426: ,p_information26 in varchar2 default hr_api.g_varchar2
1427: ,p_information27 in varchar2 default hr_api.g_varchar2
1428: ,p_information28 in varchar2 default hr_api.g_varchar2
1429: ,p_information29 in varchar2 default hr_api.g_varchar2
1430: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 1427: ,p_information27 in varchar2 default hr_api.g_varchar2

1423: ,p_information23 in varchar2 default hr_api.g_varchar2
1424: ,p_information24 in varchar2 default hr_api.g_varchar2
1425: ,p_information25 in varchar2 default hr_api.g_varchar2
1426: ,p_information26 in varchar2 default hr_api.g_varchar2
1427: ,p_information27 in varchar2 default hr_api.g_varchar2
1428: ,p_information28 in varchar2 default hr_api.g_varchar2
1429: ,p_information29 in varchar2 default hr_api.g_varchar2
1430: ,p_information30 in varchar2 default hr_api.g_varchar2
1431: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 1428: ,p_information28 in varchar2 default hr_api.g_varchar2

1424: ,p_information24 in varchar2 default hr_api.g_varchar2
1425: ,p_information25 in varchar2 default hr_api.g_varchar2
1426: ,p_information26 in varchar2 default hr_api.g_varchar2
1427: ,p_information27 in varchar2 default hr_api.g_varchar2
1428: ,p_information28 in varchar2 default hr_api.g_varchar2
1429: ,p_information29 in varchar2 default hr_api.g_varchar2
1430: ,p_information30 in varchar2 default hr_api.g_varchar2
1431: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1432: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1429: ,p_information29 in varchar2 default hr_api.g_varchar2

1425: ,p_information25 in varchar2 default hr_api.g_varchar2
1426: ,p_information26 in varchar2 default hr_api.g_varchar2
1427: ,p_information27 in varchar2 default hr_api.g_varchar2
1428: ,p_information28 in varchar2 default hr_api.g_varchar2
1429: ,p_information29 in varchar2 default hr_api.g_varchar2
1430: ,p_information30 in varchar2 default hr_api.g_varchar2
1431: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1432: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1433: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1430: ,p_information30 in varchar2 default hr_api.g_varchar2

1426: ,p_information26 in varchar2 default hr_api.g_varchar2
1427: ,p_information27 in varchar2 default hr_api.g_varchar2
1428: ,p_information28 in varchar2 default hr_api.g_varchar2
1429: ,p_information29 in varchar2 default hr_api.g_varchar2
1430: ,p_information30 in varchar2 default hr_api.g_varchar2
1431: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1432: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1433: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1434: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1431: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1427: ,p_information27 in varchar2 default hr_api.g_varchar2
1428: ,p_information28 in varchar2 default hr_api.g_varchar2
1429: ,p_information29 in varchar2 default hr_api.g_varchar2
1430: ,p_information30 in varchar2 default hr_api.g_varchar2
1431: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1432: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1433: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1434: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1435: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1432: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1428: ,p_information28 in varchar2 default hr_api.g_varchar2
1429: ,p_information29 in varchar2 default hr_api.g_varchar2
1430: ,p_information30 in varchar2 default hr_api.g_varchar2
1431: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1432: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1433: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1434: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1435: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1436: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1433: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1429: ,p_information29 in varchar2 default hr_api.g_varchar2
1430: ,p_information30 in varchar2 default hr_api.g_varchar2
1431: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1432: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1433: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1434: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1435: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1436: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1437: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1434: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1430: ,p_information30 in varchar2 default hr_api.g_varchar2
1431: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1432: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1433: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1434: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1435: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1436: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1437: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1438: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1435: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1431: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1432: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1433: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1434: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1435: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1436: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1437: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1438: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1439: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1436: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1432: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1433: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1434: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1435: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1436: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1437: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1438: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1439: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1440: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1437: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1433: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1434: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1435: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1436: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1437: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1438: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1439: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1440: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1441: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1438: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1434: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1435: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1436: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1437: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1438: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1439: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1440: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1441: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1442: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1439: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1435: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1436: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1437: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1438: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1439: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1440: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1441: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1442: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1443: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1440: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1436: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1437: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1438: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1439: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1440: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1441: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1442: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1443: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1444: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1441: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1437: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1438: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1439: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1440: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1441: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1442: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1443: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1444: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1445: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1442: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1438: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1439: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1440: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1441: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1442: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1443: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1444: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1445: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1446: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1443: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1439: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1440: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1441: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1442: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1443: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1444: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1445: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1446: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1447: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1444: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1440: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1441: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1442: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1443: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1444: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1445: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1446: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1447: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1448: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1445: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1441: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1442: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1443: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1444: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1445: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1446: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1447: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1448: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1449: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1446: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1442: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1443: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1444: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1445: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1446: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1447: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1448: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1449: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1450: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1447: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1443: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1444: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1445: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1446: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1447: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1448: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1449: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1450: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1451: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1448: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1444: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1445: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1446: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1447: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1448: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1449: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1450: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1451: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1452: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 1449: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1445: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1446: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1447: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1448: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1449: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1450: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1451: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1452: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1453: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 1450: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1446: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1447: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1448: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1449: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1450: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1451: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1452: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1453: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1454: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 1451: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1447: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1448: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1449: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1450: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1451: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1452: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1453: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1454: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1455: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 1452: ,p_attribute21 in varchar2 default hr_api.g_varchar2

1448: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1449: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1450: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1451: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1452: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1453: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1454: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1455: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1456: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 1453: ,p_attribute22 in varchar2 default hr_api.g_varchar2

1449: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1450: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1451: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1452: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1453: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1454: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1455: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1456: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1457: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 1454: ,p_attribute23 in varchar2 default hr_api.g_varchar2

1450: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1451: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1452: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1453: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1454: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1455: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1456: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1457: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1458: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 1455: ,p_attribute24 in varchar2 default hr_api.g_varchar2

1451: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1452: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1453: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1454: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1455: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1456: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1457: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1458: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1459: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 1456: ,p_attribute25 in varchar2 default hr_api.g_varchar2

1452: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1453: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1454: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1455: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1456: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1457: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1458: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1459: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1460: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 1457: ,p_attribute26 in varchar2 default hr_api.g_varchar2

1453: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1454: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1455: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1456: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1457: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1458: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1459: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1460: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1461: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 1458: ,p_attribute27 in varchar2 default hr_api.g_varchar2

1454: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1455: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1456: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1457: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1458: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1459: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1460: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1461: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1462: ,p_effective_start_date out nocopy date

Line 1459: ,p_attribute28 in varchar2 default hr_api.g_varchar2

1455: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1456: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1457: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1458: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1459: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1460: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1461: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1462: ,p_effective_start_date out nocopy date
1463: ,p_effective_end_date out nocopy date

Line 1460: ,p_attribute29 in varchar2 default hr_api.g_varchar2

1456: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1457: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1458: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1459: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1460: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1461: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1462: ,p_effective_start_date out nocopy date
1463: ,p_effective_end_date out nocopy date
1464: ) is

Line 1461: ,p_attribute30 in varchar2 default hr_api.g_varchar2

1457: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1458: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1459: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1460: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1461: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1462: ,p_effective_start_date out nocopy date
1463: ,p_effective_end_date out nocopy date
1464: ) is
1465: --