DBA Data[Home] [Help]

APPS.PQH_ASA_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 181: When hr_api.check_integrity_violated Then

177: End If;
178: --
179: hr_utility.set_location(' Leaving:'||l_proc, 15);
180: Exception
181: When hr_api.check_integrity_violated Then
182: -- A check constraint has been violated
183: --
184: pqh_asa_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

181: When hr_api.check_integrity_violated Then
182: -- A check constraint has been violated
183: --
184: pqh_asa_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: --
189: pqh_asa_shd.constraint_error

Line 186: When hr_api.unique_integrity_violated Then

182: -- A check constraint has been violated
183: --
184: pqh_asa_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: --
189: pqh_asa_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: --
189: pqh_asa_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: --
193: Raise;
194: End dt_update_dml;

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

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

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

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

Line 782: when hr_api.cannot_find_prog_unit then

778: );
779: --
780: exception
781: --
782: when hr_api.cannot_find_prog_unit then
783: --
784: hr_api.cannot_find_prog_unit_error
785: (p_module_name => 'PQH_ASSIGN_ACCOMMODATIONS_F'
786: ,p_hook_type => 'AU');

Line 784: hr_api.cannot_find_prog_unit_error

780: exception
781: --
782: when hr_api.cannot_find_prog_unit then
783: --
784: hr_api.cannot_find_prog_unit_error
785: (p_module_name => 'PQH_ASSIGN_ACCOMMODATIONS_F'
786: ,p_hook_type => 'AU');
787: --
788: end;

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

843: -- p_rec plsql record structure
844: -- to see if a system default is being used. If a system default
845: -- is being used then we must set to the 'current' argument value.
846: --
847: If (p_rec.business_group_id = hr_api.g_number) then
848: p_rec.business_group_id :=
849: pqh_asa_shd.g_old_rec.business_group_id;
850: End If;
851: If (p_rec.assignment_id = hr_api.g_number) then

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

847: If (p_rec.business_group_id = hr_api.g_number) then
848: p_rec.business_group_id :=
849: pqh_asa_shd.g_old_rec.business_group_id;
850: End If;
851: If (p_rec.assignment_id = hr_api.g_number) then
852: p_rec.assignment_id :=
853: pqh_asa_shd.g_old_rec.assignment_id;
854: End If;
855: If (p_rec.accommodation_given = hr_api.g_varchar2) then

Line 855: If (p_rec.accommodation_given = hr_api.g_varchar2) then

851: If (p_rec.assignment_id = hr_api.g_number) then
852: p_rec.assignment_id :=
853: pqh_asa_shd.g_old_rec.assignment_id;
854: End If;
855: If (p_rec.accommodation_given = hr_api.g_varchar2) then
856: p_rec.accommodation_given :=
857: pqh_asa_shd.g_old_rec.accommodation_given;
858: End If;
859: If (p_rec.temporary_assignment = hr_api.g_varchar2) then

Line 859: If (p_rec.temporary_assignment = hr_api.g_varchar2) then

855: If (p_rec.accommodation_given = hr_api.g_varchar2) then
856: p_rec.accommodation_given :=
857: pqh_asa_shd.g_old_rec.accommodation_given;
858: End If;
859: If (p_rec.temporary_assignment = hr_api.g_varchar2) then
860: p_rec.temporary_assignment :=
861: pqh_asa_shd.g_old_rec.temporary_assignment;
862: End If;
863: If (p_rec.accommodation_id = hr_api.g_number) then

Line 863: If (p_rec.accommodation_id = hr_api.g_number) then

859: If (p_rec.temporary_assignment = hr_api.g_varchar2) then
860: p_rec.temporary_assignment :=
861: pqh_asa_shd.g_old_rec.temporary_assignment;
862: End If;
863: If (p_rec.accommodation_id = hr_api.g_number) then
864: p_rec.accommodation_id :=
865: pqh_asa_shd.g_old_rec.accommodation_id;
866: End If;
867: If (p_rec.acceptance_date = hr_api.g_date) then

Line 867: If (p_rec.acceptance_date = hr_api.g_date) then

863: If (p_rec.accommodation_id = hr_api.g_number) then
864: p_rec.accommodation_id :=
865: pqh_asa_shd.g_old_rec.accommodation_id;
866: End If;
867: If (p_rec.acceptance_date = hr_api.g_date) then
868: p_rec.acceptance_date :=
869: pqh_asa_shd.g_old_rec.acceptance_date;
870: End If;
871: If (p_rec.moving_date = hr_api.g_date) then

Line 871: If (p_rec.moving_date = hr_api.g_date) then

867: If (p_rec.acceptance_date = hr_api.g_date) then
868: p_rec.acceptance_date :=
869: pqh_asa_shd.g_old_rec.acceptance_date;
870: End If;
871: If (p_rec.moving_date = hr_api.g_date) then
872: p_rec.moving_date :=
873: pqh_asa_shd.g_old_rec.moving_date;
874: End If;
875: If (p_rec.refusal_date = hr_api.g_date) then

Line 875: If (p_rec.refusal_date = hr_api.g_date) then

871: If (p_rec.moving_date = hr_api.g_date) then
872: p_rec.moving_date :=
873: pqh_asa_shd.g_old_rec.moving_date;
874: End If;
875: If (p_rec.refusal_date = hr_api.g_date) then
876: p_rec.refusal_date :=
877: pqh_asa_shd.g_old_rec.refusal_date;
878: End If;
879: If (p_rec.comments = hr_api.g_varchar2) then

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

875: If (p_rec.refusal_date = hr_api.g_date) then
876: p_rec.refusal_date :=
877: pqh_asa_shd.g_old_rec.refusal_date;
878: End If;
879: If (p_rec.comments = hr_api.g_varchar2) then
880: p_rec.comments :=
881: pqh_asa_shd.g_old_rec.comments;
882: End If;
883: If (p_rec.indemnity_entitlement = hr_api.g_varchar2) then

Line 883: If (p_rec.indemnity_entitlement = hr_api.g_varchar2) then

879: If (p_rec.comments = hr_api.g_varchar2) then
880: p_rec.comments :=
881: pqh_asa_shd.g_old_rec.comments;
882: End If;
883: If (p_rec.indemnity_entitlement = hr_api.g_varchar2) then
884: p_rec.indemnity_entitlement :=
885: pqh_asa_shd.g_old_rec.indemnity_entitlement;
886: End If;
887: If (p_rec.indemnity_amount = hr_api.g_number) then

Line 887: If (p_rec.indemnity_amount = hr_api.g_number) then

883: If (p_rec.indemnity_entitlement = hr_api.g_varchar2) then
884: p_rec.indemnity_entitlement :=
885: pqh_asa_shd.g_old_rec.indemnity_entitlement;
886: End If;
887: If (p_rec.indemnity_amount = hr_api.g_number) then
888: p_rec.indemnity_amount :=
889: pqh_asa_shd.g_old_rec.indemnity_amount;
890: End If;
891: If (p_rec.type_of_payment = hr_api.g_varchar2) then

Line 891: If (p_rec.type_of_payment = hr_api.g_varchar2) then

887: If (p_rec.indemnity_amount = hr_api.g_number) then
888: p_rec.indemnity_amount :=
889: pqh_asa_shd.g_old_rec.indemnity_amount;
890: End If;
891: If (p_rec.type_of_payment = hr_api.g_varchar2) then
892: p_rec.type_of_payment :=
893: pqh_asa_shd.g_old_rec.type_of_payment;
894: End If;
895: If (p_rec.information_category = hr_api.g_varchar2) then

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

891: If (p_rec.type_of_payment = hr_api.g_varchar2) then
892: p_rec.type_of_payment :=
893: pqh_asa_shd.g_old_rec.type_of_payment;
894: End If;
895: If (p_rec.information_category = hr_api.g_varchar2) then
896: p_rec.information_category :=
897: pqh_asa_shd.g_old_rec.information_category;
898: End If;
899: If (p_rec.information1 = hr_api.g_varchar2) then

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

895: If (p_rec.information_category = hr_api.g_varchar2) then
896: p_rec.information_category :=
897: pqh_asa_shd.g_old_rec.information_category;
898: End If;
899: If (p_rec.information1 = hr_api.g_varchar2) then
900: p_rec.information1 :=
901: pqh_asa_shd.g_old_rec.information1;
902: End If;
903: If (p_rec.information2 = hr_api.g_varchar2) then

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

899: If (p_rec.information1 = hr_api.g_varchar2) then
900: p_rec.information1 :=
901: pqh_asa_shd.g_old_rec.information1;
902: End If;
903: If (p_rec.information2 = hr_api.g_varchar2) then
904: p_rec.information2 :=
905: pqh_asa_shd.g_old_rec.information2;
906: End If;
907: If (p_rec.information3 = hr_api.g_varchar2) then

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

903: If (p_rec.information2 = hr_api.g_varchar2) then
904: p_rec.information2 :=
905: pqh_asa_shd.g_old_rec.information2;
906: End If;
907: If (p_rec.information3 = hr_api.g_varchar2) then
908: p_rec.information3 :=
909: pqh_asa_shd.g_old_rec.information3;
910: End If;
911: If (p_rec.information4 = hr_api.g_varchar2) then

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

907: If (p_rec.information3 = hr_api.g_varchar2) then
908: p_rec.information3 :=
909: pqh_asa_shd.g_old_rec.information3;
910: End If;
911: If (p_rec.information4 = hr_api.g_varchar2) then
912: p_rec.information4 :=
913: pqh_asa_shd.g_old_rec.information4;
914: End If;
915: If (p_rec.information5 = hr_api.g_varchar2) then

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

911: If (p_rec.information4 = hr_api.g_varchar2) then
912: p_rec.information4 :=
913: pqh_asa_shd.g_old_rec.information4;
914: End If;
915: If (p_rec.information5 = hr_api.g_varchar2) then
916: p_rec.information5 :=
917: pqh_asa_shd.g_old_rec.information5;
918: End If;
919: If (p_rec.information6 = hr_api.g_varchar2) then

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

915: If (p_rec.information5 = hr_api.g_varchar2) then
916: p_rec.information5 :=
917: pqh_asa_shd.g_old_rec.information5;
918: End If;
919: If (p_rec.information6 = hr_api.g_varchar2) then
920: p_rec.information6 :=
921: pqh_asa_shd.g_old_rec.information6;
922: End If;
923: If (p_rec.information7 = hr_api.g_varchar2) then

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

919: If (p_rec.information6 = hr_api.g_varchar2) then
920: p_rec.information6 :=
921: pqh_asa_shd.g_old_rec.information6;
922: End If;
923: If (p_rec.information7 = hr_api.g_varchar2) then
924: p_rec.information7 :=
925: pqh_asa_shd.g_old_rec.information7;
926: End If;
927: If (p_rec.information8 = hr_api.g_varchar2) then

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

923: If (p_rec.information7 = hr_api.g_varchar2) then
924: p_rec.information7 :=
925: pqh_asa_shd.g_old_rec.information7;
926: End If;
927: If (p_rec.information8 = hr_api.g_varchar2) then
928: p_rec.information8 :=
929: pqh_asa_shd.g_old_rec.information8;
930: End If;
931: If (p_rec.information9 = hr_api.g_varchar2) then

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

927: If (p_rec.information8 = hr_api.g_varchar2) then
928: p_rec.information8 :=
929: pqh_asa_shd.g_old_rec.information8;
930: End If;
931: If (p_rec.information9 = hr_api.g_varchar2) then
932: p_rec.information9 :=
933: pqh_asa_shd.g_old_rec.information9;
934: End If;
935: If (p_rec.information10 = hr_api.g_varchar2) then

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

931: If (p_rec.information9 = hr_api.g_varchar2) then
932: p_rec.information9 :=
933: pqh_asa_shd.g_old_rec.information9;
934: End If;
935: If (p_rec.information10 = hr_api.g_varchar2) then
936: p_rec.information10 :=
937: pqh_asa_shd.g_old_rec.information10;
938: End If;
939: If (p_rec.information11 = hr_api.g_varchar2) then

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

935: If (p_rec.information10 = hr_api.g_varchar2) then
936: p_rec.information10 :=
937: pqh_asa_shd.g_old_rec.information10;
938: End If;
939: If (p_rec.information11 = hr_api.g_varchar2) then
940: p_rec.information11 :=
941: pqh_asa_shd.g_old_rec.information11;
942: End If;
943: If (p_rec.information12 = hr_api.g_varchar2) then

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

939: If (p_rec.information11 = hr_api.g_varchar2) then
940: p_rec.information11 :=
941: pqh_asa_shd.g_old_rec.information11;
942: End If;
943: If (p_rec.information12 = hr_api.g_varchar2) then
944: p_rec.information12 :=
945: pqh_asa_shd.g_old_rec.information12;
946: End If;
947: If (p_rec.information13 = hr_api.g_varchar2) then

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

943: If (p_rec.information12 = hr_api.g_varchar2) then
944: p_rec.information12 :=
945: pqh_asa_shd.g_old_rec.information12;
946: End If;
947: If (p_rec.information13 = hr_api.g_varchar2) then
948: p_rec.information13 :=
949: pqh_asa_shd.g_old_rec.information13;
950: End If;
951: If (p_rec.information14 = hr_api.g_varchar2) then

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

947: If (p_rec.information13 = hr_api.g_varchar2) then
948: p_rec.information13 :=
949: pqh_asa_shd.g_old_rec.information13;
950: End If;
951: If (p_rec.information14 = hr_api.g_varchar2) then
952: p_rec.information14 :=
953: pqh_asa_shd.g_old_rec.information14;
954: End If;
955: If (p_rec.information15 = hr_api.g_varchar2) then

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

951: If (p_rec.information14 = hr_api.g_varchar2) then
952: p_rec.information14 :=
953: pqh_asa_shd.g_old_rec.information14;
954: End If;
955: If (p_rec.information15 = hr_api.g_varchar2) then
956: p_rec.information15 :=
957: pqh_asa_shd.g_old_rec.information15;
958: End If;
959: If (p_rec.information16 = hr_api.g_varchar2) then

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

955: If (p_rec.information15 = hr_api.g_varchar2) then
956: p_rec.information15 :=
957: pqh_asa_shd.g_old_rec.information15;
958: End If;
959: If (p_rec.information16 = hr_api.g_varchar2) then
960: p_rec.information16 :=
961: pqh_asa_shd.g_old_rec.information16;
962: End If;
963: If (p_rec.information17 = hr_api.g_varchar2) then

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

959: If (p_rec.information16 = hr_api.g_varchar2) then
960: p_rec.information16 :=
961: pqh_asa_shd.g_old_rec.information16;
962: End If;
963: If (p_rec.information17 = hr_api.g_varchar2) then
964: p_rec.information17 :=
965: pqh_asa_shd.g_old_rec.information17;
966: End If;
967: If (p_rec.information18 = hr_api.g_varchar2) then

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

963: If (p_rec.information17 = hr_api.g_varchar2) then
964: p_rec.information17 :=
965: pqh_asa_shd.g_old_rec.information17;
966: End If;
967: If (p_rec.information18 = hr_api.g_varchar2) then
968: p_rec.information18 :=
969: pqh_asa_shd.g_old_rec.information18;
970: End If;
971: If (p_rec.information19 = hr_api.g_varchar2) then

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

967: If (p_rec.information18 = hr_api.g_varchar2) then
968: p_rec.information18 :=
969: pqh_asa_shd.g_old_rec.information18;
970: End If;
971: If (p_rec.information19 = hr_api.g_varchar2) then
972: p_rec.information19 :=
973: pqh_asa_shd.g_old_rec.information19;
974: End If;
975: If (p_rec.information20 = hr_api.g_varchar2) then

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

971: If (p_rec.information19 = hr_api.g_varchar2) then
972: p_rec.information19 :=
973: pqh_asa_shd.g_old_rec.information19;
974: End If;
975: If (p_rec.information20 = hr_api.g_varchar2) then
976: p_rec.information20 :=
977: pqh_asa_shd.g_old_rec.information20;
978: End If;
979: If (p_rec.information21 = hr_api.g_varchar2) then

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

975: If (p_rec.information20 = hr_api.g_varchar2) then
976: p_rec.information20 :=
977: pqh_asa_shd.g_old_rec.information20;
978: End If;
979: If (p_rec.information21 = hr_api.g_varchar2) then
980: p_rec.information21 :=
981: pqh_asa_shd.g_old_rec.information21;
982: End If;
983: If (p_rec.information22 = hr_api.g_varchar2) then

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

979: If (p_rec.information21 = hr_api.g_varchar2) then
980: p_rec.information21 :=
981: pqh_asa_shd.g_old_rec.information21;
982: End If;
983: If (p_rec.information22 = hr_api.g_varchar2) then
984: p_rec.information22 :=
985: pqh_asa_shd.g_old_rec.information22;
986: End If;
987: If (p_rec.information23 = hr_api.g_varchar2) then

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

983: If (p_rec.information22 = hr_api.g_varchar2) then
984: p_rec.information22 :=
985: pqh_asa_shd.g_old_rec.information22;
986: End If;
987: If (p_rec.information23 = hr_api.g_varchar2) then
988: p_rec.information23 :=
989: pqh_asa_shd.g_old_rec.information23;
990: End If;
991: If (p_rec.information24 = hr_api.g_varchar2) then

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

987: If (p_rec.information23 = hr_api.g_varchar2) then
988: p_rec.information23 :=
989: pqh_asa_shd.g_old_rec.information23;
990: End If;
991: If (p_rec.information24 = hr_api.g_varchar2) then
992: p_rec.information24 :=
993: pqh_asa_shd.g_old_rec.information24;
994: End If;
995: If (p_rec.information25 = hr_api.g_varchar2) then

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

991: If (p_rec.information24 = hr_api.g_varchar2) then
992: p_rec.information24 :=
993: pqh_asa_shd.g_old_rec.information24;
994: End If;
995: If (p_rec.information25 = hr_api.g_varchar2) then
996: p_rec.information25 :=
997: pqh_asa_shd.g_old_rec.information25;
998: End If;
999: If (p_rec.information26 = hr_api.g_varchar2) then

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

995: If (p_rec.information25 = hr_api.g_varchar2) then
996: p_rec.information25 :=
997: pqh_asa_shd.g_old_rec.information25;
998: End If;
999: If (p_rec.information26 = hr_api.g_varchar2) then
1000: p_rec.information26 :=
1001: pqh_asa_shd.g_old_rec.information26;
1002: End If;
1003: If (p_rec.information27 = hr_api.g_varchar2) then

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

999: If (p_rec.information26 = hr_api.g_varchar2) then
1000: p_rec.information26 :=
1001: pqh_asa_shd.g_old_rec.information26;
1002: End If;
1003: If (p_rec.information27 = hr_api.g_varchar2) then
1004: p_rec.information27 :=
1005: pqh_asa_shd.g_old_rec.information27;
1006: End If;
1007: If (p_rec.information28 = hr_api.g_varchar2) then

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

1003: If (p_rec.information27 = hr_api.g_varchar2) then
1004: p_rec.information27 :=
1005: pqh_asa_shd.g_old_rec.information27;
1006: End If;
1007: If (p_rec.information28 = hr_api.g_varchar2) then
1008: p_rec.information28 :=
1009: pqh_asa_shd.g_old_rec.information28;
1010: End If;
1011: If (p_rec.information29 = hr_api.g_varchar2) then

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

1007: If (p_rec.information28 = hr_api.g_varchar2) then
1008: p_rec.information28 :=
1009: pqh_asa_shd.g_old_rec.information28;
1010: End If;
1011: If (p_rec.information29 = hr_api.g_varchar2) then
1012: p_rec.information29 :=
1013: pqh_asa_shd.g_old_rec.information29;
1014: End If;
1015: If (p_rec.information30 = hr_api.g_varchar2) then

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

1011: If (p_rec.information29 = hr_api.g_varchar2) then
1012: p_rec.information29 :=
1013: pqh_asa_shd.g_old_rec.information29;
1014: End If;
1015: If (p_rec.information30 = hr_api.g_varchar2) then
1016: p_rec.information30 :=
1017: pqh_asa_shd.g_old_rec.information30;
1018: End If;
1019: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

1015: If (p_rec.information30 = hr_api.g_varchar2) then
1016: p_rec.information30 :=
1017: pqh_asa_shd.g_old_rec.information30;
1018: End If;
1019: If (p_rec.attribute_category = hr_api.g_varchar2) then
1020: p_rec.attribute_category :=
1021: pqh_asa_shd.g_old_rec.attribute_category;
1022: End If;
1023: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

1019: If (p_rec.attribute_category = hr_api.g_varchar2) then
1020: p_rec.attribute_category :=
1021: pqh_asa_shd.g_old_rec.attribute_category;
1022: End If;
1023: If (p_rec.attribute1 = hr_api.g_varchar2) then
1024: p_rec.attribute1 :=
1025: pqh_asa_shd.g_old_rec.attribute1;
1026: End If;
1027: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

1023: If (p_rec.attribute1 = hr_api.g_varchar2) then
1024: p_rec.attribute1 :=
1025: pqh_asa_shd.g_old_rec.attribute1;
1026: End If;
1027: If (p_rec.attribute2 = hr_api.g_varchar2) then
1028: p_rec.attribute2 :=
1029: pqh_asa_shd.g_old_rec.attribute2;
1030: End If;
1031: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

1027: If (p_rec.attribute2 = hr_api.g_varchar2) then
1028: p_rec.attribute2 :=
1029: pqh_asa_shd.g_old_rec.attribute2;
1030: End If;
1031: If (p_rec.attribute3 = hr_api.g_varchar2) then
1032: p_rec.attribute3 :=
1033: pqh_asa_shd.g_old_rec.attribute3;
1034: End If;
1035: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

1031: If (p_rec.attribute3 = hr_api.g_varchar2) then
1032: p_rec.attribute3 :=
1033: pqh_asa_shd.g_old_rec.attribute3;
1034: End If;
1035: If (p_rec.attribute4 = hr_api.g_varchar2) then
1036: p_rec.attribute4 :=
1037: pqh_asa_shd.g_old_rec.attribute4;
1038: End If;
1039: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

1035: If (p_rec.attribute4 = hr_api.g_varchar2) then
1036: p_rec.attribute4 :=
1037: pqh_asa_shd.g_old_rec.attribute4;
1038: End If;
1039: If (p_rec.attribute5 = hr_api.g_varchar2) then
1040: p_rec.attribute5 :=
1041: pqh_asa_shd.g_old_rec.attribute5;
1042: End If;
1043: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

1039: If (p_rec.attribute5 = hr_api.g_varchar2) then
1040: p_rec.attribute5 :=
1041: pqh_asa_shd.g_old_rec.attribute5;
1042: End If;
1043: If (p_rec.attribute6 = hr_api.g_varchar2) then
1044: p_rec.attribute6 :=
1045: pqh_asa_shd.g_old_rec.attribute6;
1046: End If;
1047: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

1043: If (p_rec.attribute6 = hr_api.g_varchar2) then
1044: p_rec.attribute6 :=
1045: pqh_asa_shd.g_old_rec.attribute6;
1046: End If;
1047: If (p_rec.attribute7 = hr_api.g_varchar2) then
1048: p_rec.attribute7 :=
1049: pqh_asa_shd.g_old_rec.attribute7;
1050: End If;
1051: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

1047: If (p_rec.attribute7 = hr_api.g_varchar2) then
1048: p_rec.attribute7 :=
1049: pqh_asa_shd.g_old_rec.attribute7;
1050: End If;
1051: If (p_rec.attribute8 = hr_api.g_varchar2) then
1052: p_rec.attribute8 :=
1053: pqh_asa_shd.g_old_rec.attribute8;
1054: End If;
1055: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

1051: If (p_rec.attribute8 = hr_api.g_varchar2) then
1052: p_rec.attribute8 :=
1053: pqh_asa_shd.g_old_rec.attribute8;
1054: End If;
1055: If (p_rec.attribute9 = hr_api.g_varchar2) then
1056: p_rec.attribute9 :=
1057: pqh_asa_shd.g_old_rec.attribute9;
1058: End If;
1059: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

1055: If (p_rec.attribute9 = hr_api.g_varchar2) then
1056: p_rec.attribute9 :=
1057: pqh_asa_shd.g_old_rec.attribute9;
1058: End If;
1059: If (p_rec.attribute10 = hr_api.g_varchar2) then
1060: p_rec.attribute10 :=
1061: pqh_asa_shd.g_old_rec.attribute10;
1062: End If;
1063: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

1059: If (p_rec.attribute10 = hr_api.g_varchar2) then
1060: p_rec.attribute10 :=
1061: pqh_asa_shd.g_old_rec.attribute10;
1062: End If;
1063: If (p_rec.attribute11 = hr_api.g_varchar2) then
1064: p_rec.attribute11 :=
1065: pqh_asa_shd.g_old_rec.attribute11;
1066: End If;
1067: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

1063: If (p_rec.attribute11 = hr_api.g_varchar2) then
1064: p_rec.attribute11 :=
1065: pqh_asa_shd.g_old_rec.attribute11;
1066: End If;
1067: If (p_rec.attribute12 = hr_api.g_varchar2) then
1068: p_rec.attribute12 :=
1069: pqh_asa_shd.g_old_rec.attribute12;
1070: End If;
1071: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

1067: If (p_rec.attribute12 = hr_api.g_varchar2) then
1068: p_rec.attribute12 :=
1069: pqh_asa_shd.g_old_rec.attribute12;
1070: End If;
1071: If (p_rec.attribute13 = hr_api.g_varchar2) then
1072: p_rec.attribute13 :=
1073: pqh_asa_shd.g_old_rec.attribute13;
1074: End If;
1075: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

1071: If (p_rec.attribute13 = hr_api.g_varchar2) then
1072: p_rec.attribute13 :=
1073: pqh_asa_shd.g_old_rec.attribute13;
1074: End If;
1075: If (p_rec.attribute14 = hr_api.g_varchar2) then
1076: p_rec.attribute14 :=
1077: pqh_asa_shd.g_old_rec.attribute14;
1078: End If;
1079: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

1075: If (p_rec.attribute14 = hr_api.g_varchar2) then
1076: p_rec.attribute14 :=
1077: pqh_asa_shd.g_old_rec.attribute14;
1078: End If;
1079: If (p_rec.attribute15 = hr_api.g_varchar2) then
1080: p_rec.attribute15 :=
1081: pqh_asa_shd.g_old_rec.attribute15;
1082: End If;
1083: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

1079: If (p_rec.attribute15 = hr_api.g_varchar2) then
1080: p_rec.attribute15 :=
1081: pqh_asa_shd.g_old_rec.attribute15;
1082: End If;
1083: If (p_rec.attribute16 = hr_api.g_varchar2) then
1084: p_rec.attribute16 :=
1085: pqh_asa_shd.g_old_rec.attribute16;
1086: End If;
1087: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

1083: If (p_rec.attribute16 = hr_api.g_varchar2) then
1084: p_rec.attribute16 :=
1085: pqh_asa_shd.g_old_rec.attribute16;
1086: End If;
1087: If (p_rec.attribute17 = hr_api.g_varchar2) then
1088: p_rec.attribute17 :=
1089: pqh_asa_shd.g_old_rec.attribute17;
1090: End If;
1091: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

1087: If (p_rec.attribute17 = hr_api.g_varchar2) then
1088: p_rec.attribute17 :=
1089: pqh_asa_shd.g_old_rec.attribute17;
1090: End If;
1091: If (p_rec.attribute18 = hr_api.g_varchar2) then
1092: p_rec.attribute18 :=
1093: pqh_asa_shd.g_old_rec.attribute18;
1094: End If;
1095: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

1091: If (p_rec.attribute18 = hr_api.g_varchar2) then
1092: p_rec.attribute18 :=
1093: pqh_asa_shd.g_old_rec.attribute18;
1094: End If;
1095: If (p_rec.attribute19 = hr_api.g_varchar2) then
1096: p_rec.attribute19 :=
1097: pqh_asa_shd.g_old_rec.attribute19;
1098: End If;
1099: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

1095: If (p_rec.attribute19 = hr_api.g_varchar2) then
1096: p_rec.attribute19 :=
1097: pqh_asa_shd.g_old_rec.attribute19;
1098: End If;
1099: If (p_rec.attribute20 = hr_api.g_varchar2) then
1100: p_rec.attribute20 :=
1101: pqh_asa_shd.g_old_rec.attribute20;
1102: End If;
1103: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

1099: If (p_rec.attribute20 = hr_api.g_varchar2) then
1100: p_rec.attribute20 :=
1101: pqh_asa_shd.g_old_rec.attribute20;
1102: End If;
1103: If (p_rec.attribute21 = hr_api.g_varchar2) then
1104: p_rec.attribute21 :=
1105: pqh_asa_shd.g_old_rec.attribute21;
1106: End If;
1107: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

1103: If (p_rec.attribute21 = hr_api.g_varchar2) then
1104: p_rec.attribute21 :=
1105: pqh_asa_shd.g_old_rec.attribute21;
1106: End If;
1107: If (p_rec.attribute22 = hr_api.g_varchar2) then
1108: p_rec.attribute22 :=
1109: pqh_asa_shd.g_old_rec.attribute22;
1110: End If;
1111: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

1107: If (p_rec.attribute22 = hr_api.g_varchar2) then
1108: p_rec.attribute22 :=
1109: pqh_asa_shd.g_old_rec.attribute22;
1110: End If;
1111: If (p_rec.attribute23 = hr_api.g_varchar2) then
1112: p_rec.attribute23 :=
1113: pqh_asa_shd.g_old_rec.attribute23;
1114: End If;
1115: If (p_rec.attribute24 = hr_api.g_varchar2) then

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

1111: If (p_rec.attribute23 = hr_api.g_varchar2) then
1112: p_rec.attribute23 :=
1113: pqh_asa_shd.g_old_rec.attribute23;
1114: End If;
1115: If (p_rec.attribute24 = hr_api.g_varchar2) then
1116: p_rec.attribute24 :=
1117: pqh_asa_shd.g_old_rec.attribute24;
1118: End If;
1119: If (p_rec.attribute25 = hr_api.g_varchar2) then

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

1115: If (p_rec.attribute24 = hr_api.g_varchar2) then
1116: p_rec.attribute24 :=
1117: pqh_asa_shd.g_old_rec.attribute24;
1118: End If;
1119: If (p_rec.attribute25 = hr_api.g_varchar2) then
1120: p_rec.attribute25 :=
1121: pqh_asa_shd.g_old_rec.attribute25;
1122: End If;
1123: If (p_rec.attribute26 = hr_api.g_varchar2) then

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

1119: If (p_rec.attribute25 = hr_api.g_varchar2) then
1120: p_rec.attribute25 :=
1121: pqh_asa_shd.g_old_rec.attribute25;
1122: End If;
1123: If (p_rec.attribute26 = hr_api.g_varchar2) then
1124: p_rec.attribute26 :=
1125: pqh_asa_shd.g_old_rec.attribute26;
1126: End If;
1127: If (p_rec.attribute27 = hr_api.g_varchar2) then

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

1123: If (p_rec.attribute26 = hr_api.g_varchar2) then
1124: p_rec.attribute26 :=
1125: pqh_asa_shd.g_old_rec.attribute26;
1126: End If;
1127: If (p_rec.attribute27 = hr_api.g_varchar2) then
1128: p_rec.attribute27 :=
1129: pqh_asa_shd.g_old_rec.attribute27;
1130: End If;
1131: If (p_rec.attribute28 = hr_api.g_varchar2) then

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

1127: If (p_rec.attribute27 = hr_api.g_varchar2) then
1128: p_rec.attribute27 :=
1129: pqh_asa_shd.g_old_rec.attribute27;
1130: End If;
1131: If (p_rec.attribute28 = hr_api.g_varchar2) then
1132: p_rec.attribute28 :=
1133: pqh_asa_shd.g_old_rec.attribute28;
1134: End If;
1135: If (p_rec.attribute29 = hr_api.g_varchar2) then

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

1131: If (p_rec.attribute28 = hr_api.g_varchar2) then
1132: p_rec.attribute28 :=
1133: pqh_asa_shd.g_old_rec.attribute28;
1134: End If;
1135: If (p_rec.attribute29 = hr_api.g_varchar2) then
1136: p_rec.attribute29 :=
1137: pqh_asa_shd.g_old_rec.attribute29;
1138: End If;
1139: If (p_rec.attribute30 = hr_api.g_varchar2) then

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

1135: If (p_rec.attribute29 = hr_api.g_varchar2) then
1136: p_rec.attribute29 :=
1137: pqh_asa_shd.g_old_rec.attribute29;
1138: End If;
1139: If (p_rec.attribute30 = hr_api.g_varchar2) then
1140: p_rec.attribute30 :=
1141: pqh_asa_shd.g_old_rec.attribute30;
1142: End If;
1143: If (p_rec.reason_for_no_acco = hr_api.g_varchar2) then

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

1139: If (p_rec.attribute30 = hr_api.g_varchar2) then
1140: p_rec.attribute30 :=
1141: pqh_asa_shd.g_old_rec.attribute30;
1142: End If;
1143: If (p_rec.reason_for_no_acco = hr_api.g_varchar2) then
1144: p_rec.reason_for_no_acco :=
1145: pqh_asa_shd.g_old_rec.reason_for_no_acco;
1146: End If;
1147: If (p_rec.indemnity_currency = hr_api.g_varchar2) then

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

1143: If (p_rec.reason_for_no_acco = hr_api.g_varchar2) then
1144: p_rec.reason_for_no_acco :=
1145: pqh_asa_shd.g_old_rec.reason_for_no_acco;
1146: End If;
1147: If (p_rec.indemnity_currency = hr_api.g_varchar2) then
1148: p_rec.indemnity_currency :=
1149: pqh_asa_shd.g_old_rec.indemnity_currency;
1150: End If;
1151: --

Line 1246: ,p_business_group_id in number default hr_api.g_number

1242: (p_effective_date in date
1243: ,p_datetrack_mode in varchar2
1244: ,p_assignment_acco_id in number
1245: ,p_object_version_number in out nocopy number
1246: ,p_business_group_id in number default hr_api.g_number
1247: ,p_assignment_id in number default hr_api.g_number
1248: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
1249: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
1250: ,p_accommodation_id in number default hr_api.g_number

Line 1247: ,p_assignment_id in number default hr_api.g_number

1243: ,p_datetrack_mode in varchar2
1244: ,p_assignment_acco_id in number
1245: ,p_object_version_number in out nocopy number
1246: ,p_business_group_id in number default hr_api.g_number
1247: ,p_assignment_id in number default hr_api.g_number
1248: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
1249: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
1250: ,p_accommodation_id in number default hr_api.g_number
1251: ,p_acceptance_date in date default hr_api.g_date

Line 1248: ,p_accommodation_given in varchar2 default hr_api.g_varchar2

1244: ,p_assignment_acco_id in number
1245: ,p_object_version_number in out nocopy number
1246: ,p_business_group_id in number default hr_api.g_number
1247: ,p_assignment_id in number default hr_api.g_number
1248: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
1249: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
1250: ,p_accommodation_id in number default hr_api.g_number
1251: ,p_acceptance_date in date default hr_api.g_date
1252: ,p_moving_date in date default hr_api.g_date

Line 1249: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2

1245: ,p_object_version_number in out nocopy number
1246: ,p_business_group_id in number default hr_api.g_number
1247: ,p_assignment_id in number default hr_api.g_number
1248: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
1249: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
1250: ,p_accommodation_id in number default hr_api.g_number
1251: ,p_acceptance_date in date default hr_api.g_date
1252: ,p_moving_date in date default hr_api.g_date
1253: ,p_refusal_date in date default hr_api.g_date

Line 1250: ,p_accommodation_id in number default hr_api.g_number

1246: ,p_business_group_id in number default hr_api.g_number
1247: ,p_assignment_id in number default hr_api.g_number
1248: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
1249: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
1250: ,p_accommodation_id in number default hr_api.g_number
1251: ,p_acceptance_date in date default hr_api.g_date
1252: ,p_moving_date in date default hr_api.g_date
1253: ,p_refusal_date in date default hr_api.g_date
1254: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1251: ,p_acceptance_date in date default hr_api.g_date

1247: ,p_assignment_id in number default hr_api.g_number
1248: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
1249: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
1250: ,p_accommodation_id in number default hr_api.g_number
1251: ,p_acceptance_date in date default hr_api.g_date
1252: ,p_moving_date in date default hr_api.g_date
1253: ,p_refusal_date in date default hr_api.g_date
1254: ,p_comments in varchar2 default hr_api.g_varchar2
1255: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2

Line 1252: ,p_moving_date in date default hr_api.g_date

1248: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
1249: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
1250: ,p_accommodation_id in number default hr_api.g_number
1251: ,p_acceptance_date in date default hr_api.g_date
1252: ,p_moving_date in date default hr_api.g_date
1253: ,p_refusal_date in date default hr_api.g_date
1254: ,p_comments in varchar2 default hr_api.g_varchar2
1255: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
1256: ,p_indemnity_amount in number default hr_api.g_number

Line 1253: ,p_refusal_date in date default hr_api.g_date

1249: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
1250: ,p_accommodation_id in number default hr_api.g_number
1251: ,p_acceptance_date in date default hr_api.g_date
1252: ,p_moving_date in date default hr_api.g_date
1253: ,p_refusal_date in date default hr_api.g_date
1254: ,p_comments in varchar2 default hr_api.g_varchar2
1255: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
1256: ,p_indemnity_amount in number default hr_api.g_number
1257: ,p_type_of_payment in varchar2 default hr_api.g_varchar2

Line 1254: ,p_comments in varchar2 default hr_api.g_varchar2

1250: ,p_accommodation_id in number default hr_api.g_number
1251: ,p_acceptance_date in date default hr_api.g_date
1252: ,p_moving_date in date default hr_api.g_date
1253: ,p_refusal_date in date default hr_api.g_date
1254: ,p_comments in varchar2 default hr_api.g_varchar2
1255: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
1256: ,p_indemnity_amount in number default hr_api.g_number
1257: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
1258: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 1255: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2

1251: ,p_acceptance_date in date default hr_api.g_date
1252: ,p_moving_date in date default hr_api.g_date
1253: ,p_refusal_date in date default hr_api.g_date
1254: ,p_comments in varchar2 default hr_api.g_varchar2
1255: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
1256: ,p_indemnity_amount in number default hr_api.g_number
1257: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
1258: ,p_information_category in varchar2 default hr_api.g_varchar2
1259: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 1256: ,p_indemnity_amount in number default hr_api.g_number

1252: ,p_moving_date in date default hr_api.g_date
1253: ,p_refusal_date in date default hr_api.g_date
1254: ,p_comments in varchar2 default hr_api.g_varchar2
1255: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
1256: ,p_indemnity_amount in number default hr_api.g_number
1257: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
1258: ,p_information_category in varchar2 default hr_api.g_varchar2
1259: ,p_information1 in varchar2 default hr_api.g_varchar2
1260: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 1257: ,p_type_of_payment in varchar2 default hr_api.g_varchar2

1253: ,p_refusal_date in date default hr_api.g_date
1254: ,p_comments in varchar2 default hr_api.g_varchar2
1255: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
1256: ,p_indemnity_amount in number default hr_api.g_number
1257: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
1258: ,p_information_category in varchar2 default hr_api.g_varchar2
1259: ,p_information1 in varchar2 default hr_api.g_varchar2
1260: ,p_information2 in varchar2 default hr_api.g_varchar2
1261: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 1258: ,p_information_category in varchar2 default hr_api.g_varchar2

1254: ,p_comments in varchar2 default hr_api.g_varchar2
1255: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
1256: ,p_indemnity_amount in number default hr_api.g_number
1257: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
1258: ,p_information_category in varchar2 default hr_api.g_varchar2
1259: ,p_information1 in varchar2 default hr_api.g_varchar2
1260: ,p_information2 in varchar2 default hr_api.g_varchar2
1261: ,p_information3 in varchar2 default hr_api.g_varchar2
1262: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 1259: ,p_information1 in varchar2 default hr_api.g_varchar2

1255: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
1256: ,p_indemnity_amount in number default hr_api.g_number
1257: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
1258: ,p_information_category in varchar2 default hr_api.g_varchar2
1259: ,p_information1 in varchar2 default hr_api.g_varchar2
1260: ,p_information2 in varchar2 default hr_api.g_varchar2
1261: ,p_information3 in varchar2 default hr_api.g_varchar2
1262: ,p_information4 in varchar2 default hr_api.g_varchar2
1263: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 1260: ,p_information2 in varchar2 default hr_api.g_varchar2

1256: ,p_indemnity_amount in number default hr_api.g_number
1257: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
1258: ,p_information_category in varchar2 default hr_api.g_varchar2
1259: ,p_information1 in varchar2 default hr_api.g_varchar2
1260: ,p_information2 in varchar2 default hr_api.g_varchar2
1261: ,p_information3 in varchar2 default hr_api.g_varchar2
1262: ,p_information4 in varchar2 default hr_api.g_varchar2
1263: ,p_information5 in varchar2 default hr_api.g_varchar2
1264: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 1261: ,p_information3 in varchar2 default hr_api.g_varchar2

1257: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
1258: ,p_information_category in varchar2 default hr_api.g_varchar2
1259: ,p_information1 in varchar2 default hr_api.g_varchar2
1260: ,p_information2 in varchar2 default hr_api.g_varchar2
1261: ,p_information3 in varchar2 default hr_api.g_varchar2
1262: ,p_information4 in varchar2 default hr_api.g_varchar2
1263: ,p_information5 in varchar2 default hr_api.g_varchar2
1264: ,p_information6 in varchar2 default hr_api.g_varchar2
1265: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 1262: ,p_information4 in varchar2 default hr_api.g_varchar2

1258: ,p_information_category in varchar2 default hr_api.g_varchar2
1259: ,p_information1 in varchar2 default hr_api.g_varchar2
1260: ,p_information2 in varchar2 default hr_api.g_varchar2
1261: ,p_information3 in varchar2 default hr_api.g_varchar2
1262: ,p_information4 in varchar2 default hr_api.g_varchar2
1263: ,p_information5 in varchar2 default hr_api.g_varchar2
1264: ,p_information6 in varchar2 default hr_api.g_varchar2
1265: ,p_information7 in varchar2 default hr_api.g_varchar2
1266: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 1263: ,p_information5 in varchar2 default hr_api.g_varchar2

1259: ,p_information1 in varchar2 default hr_api.g_varchar2
1260: ,p_information2 in varchar2 default hr_api.g_varchar2
1261: ,p_information3 in varchar2 default hr_api.g_varchar2
1262: ,p_information4 in varchar2 default hr_api.g_varchar2
1263: ,p_information5 in varchar2 default hr_api.g_varchar2
1264: ,p_information6 in varchar2 default hr_api.g_varchar2
1265: ,p_information7 in varchar2 default hr_api.g_varchar2
1266: ,p_information8 in varchar2 default hr_api.g_varchar2
1267: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 1264: ,p_information6 in varchar2 default hr_api.g_varchar2

1260: ,p_information2 in varchar2 default hr_api.g_varchar2
1261: ,p_information3 in varchar2 default hr_api.g_varchar2
1262: ,p_information4 in varchar2 default hr_api.g_varchar2
1263: ,p_information5 in varchar2 default hr_api.g_varchar2
1264: ,p_information6 in varchar2 default hr_api.g_varchar2
1265: ,p_information7 in varchar2 default hr_api.g_varchar2
1266: ,p_information8 in varchar2 default hr_api.g_varchar2
1267: ,p_information9 in varchar2 default hr_api.g_varchar2
1268: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 1265: ,p_information7 in varchar2 default hr_api.g_varchar2

1261: ,p_information3 in varchar2 default hr_api.g_varchar2
1262: ,p_information4 in varchar2 default hr_api.g_varchar2
1263: ,p_information5 in varchar2 default hr_api.g_varchar2
1264: ,p_information6 in varchar2 default hr_api.g_varchar2
1265: ,p_information7 in varchar2 default hr_api.g_varchar2
1266: ,p_information8 in varchar2 default hr_api.g_varchar2
1267: ,p_information9 in varchar2 default hr_api.g_varchar2
1268: ,p_information10 in varchar2 default hr_api.g_varchar2
1269: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 1266: ,p_information8 in varchar2 default hr_api.g_varchar2

1262: ,p_information4 in varchar2 default hr_api.g_varchar2
1263: ,p_information5 in varchar2 default hr_api.g_varchar2
1264: ,p_information6 in varchar2 default hr_api.g_varchar2
1265: ,p_information7 in varchar2 default hr_api.g_varchar2
1266: ,p_information8 in varchar2 default hr_api.g_varchar2
1267: ,p_information9 in varchar2 default hr_api.g_varchar2
1268: ,p_information10 in varchar2 default hr_api.g_varchar2
1269: ,p_information11 in varchar2 default hr_api.g_varchar2
1270: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 1267: ,p_information9 in varchar2 default hr_api.g_varchar2

1263: ,p_information5 in varchar2 default hr_api.g_varchar2
1264: ,p_information6 in varchar2 default hr_api.g_varchar2
1265: ,p_information7 in varchar2 default hr_api.g_varchar2
1266: ,p_information8 in varchar2 default hr_api.g_varchar2
1267: ,p_information9 in varchar2 default hr_api.g_varchar2
1268: ,p_information10 in varchar2 default hr_api.g_varchar2
1269: ,p_information11 in varchar2 default hr_api.g_varchar2
1270: ,p_information12 in varchar2 default hr_api.g_varchar2
1271: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 1268: ,p_information10 in varchar2 default hr_api.g_varchar2

1264: ,p_information6 in varchar2 default hr_api.g_varchar2
1265: ,p_information7 in varchar2 default hr_api.g_varchar2
1266: ,p_information8 in varchar2 default hr_api.g_varchar2
1267: ,p_information9 in varchar2 default hr_api.g_varchar2
1268: ,p_information10 in varchar2 default hr_api.g_varchar2
1269: ,p_information11 in varchar2 default hr_api.g_varchar2
1270: ,p_information12 in varchar2 default hr_api.g_varchar2
1271: ,p_information13 in varchar2 default hr_api.g_varchar2
1272: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 1269: ,p_information11 in varchar2 default hr_api.g_varchar2

1265: ,p_information7 in varchar2 default hr_api.g_varchar2
1266: ,p_information8 in varchar2 default hr_api.g_varchar2
1267: ,p_information9 in varchar2 default hr_api.g_varchar2
1268: ,p_information10 in varchar2 default hr_api.g_varchar2
1269: ,p_information11 in varchar2 default hr_api.g_varchar2
1270: ,p_information12 in varchar2 default hr_api.g_varchar2
1271: ,p_information13 in varchar2 default hr_api.g_varchar2
1272: ,p_information14 in varchar2 default hr_api.g_varchar2
1273: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 1270: ,p_information12 in varchar2 default hr_api.g_varchar2

1266: ,p_information8 in varchar2 default hr_api.g_varchar2
1267: ,p_information9 in varchar2 default hr_api.g_varchar2
1268: ,p_information10 in varchar2 default hr_api.g_varchar2
1269: ,p_information11 in varchar2 default hr_api.g_varchar2
1270: ,p_information12 in varchar2 default hr_api.g_varchar2
1271: ,p_information13 in varchar2 default hr_api.g_varchar2
1272: ,p_information14 in varchar2 default hr_api.g_varchar2
1273: ,p_information15 in varchar2 default hr_api.g_varchar2
1274: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 1271: ,p_information13 in varchar2 default hr_api.g_varchar2

1267: ,p_information9 in varchar2 default hr_api.g_varchar2
1268: ,p_information10 in varchar2 default hr_api.g_varchar2
1269: ,p_information11 in varchar2 default hr_api.g_varchar2
1270: ,p_information12 in varchar2 default hr_api.g_varchar2
1271: ,p_information13 in varchar2 default hr_api.g_varchar2
1272: ,p_information14 in varchar2 default hr_api.g_varchar2
1273: ,p_information15 in varchar2 default hr_api.g_varchar2
1274: ,p_information16 in varchar2 default hr_api.g_varchar2
1275: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 1272: ,p_information14 in varchar2 default hr_api.g_varchar2

1268: ,p_information10 in varchar2 default hr_api.g_varchar2
1269: ,p_information11 in varchar2 default hr_api.g_varchar2
1270: ,p_information12 in varchar2 default hr_api.g_varchar2
1271: ,p_information13 in varchar2 default hr_api.g_varchar2
1272: ,p_information14 in varchar2 default hr_api.g_varchar2
1273: ,p_information15 in varchar2 default hr_api.g_varchar2
1274: ,p_information16 in varchar2 default hr_api.g_varchar2
1275: ,p_information17 in varchar2 default hr_api.g_varchar2
1276: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 1273: ,p_information15 in varchar2 default hr_api.g_varchar2

1269: ,p_information11 in varchar2 default hr_api.g_varchar2
1270: ,p_information12 in varchar2 default hr_api.g_varchar2
1271: ,p_information13 in varchar2 default hr_api.g_varchar2
1272: ,p_information14 in varchar2 default hr_api.g_varchar2
1273: ,p_information15 in varchar2 default hr_api.g_varchar2
1274: ,p_information16 in varchar2 default hr_api.g_varchar2
1275: ,p_information17 in varchar2 default hr_api.g_varchar2
1276: ,p_information18 in varchar2 default hr_api.g_varchar2
1277: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 1274: ,p_information16 in varchar2 default hr_api.g_varchar2

1270: ,p_information12 in varchar2 default hr_api.g_varchar2
1271: ,p_information13 in varchar2 default hr_api.g_varchar2
1272: ,p_information14 in varchar2 default hr_api.g_varchar2
1273: ,p_information15 in varchar2 default hr_api.g_varchar2
1274: ,p_information16 in varchar2 default hr_api.g_varchar2
1275: ,p_information17 in varchar2 default hr_api.g_varchar2
1276: ,p_information18 in varchar2 default hr_api.g_varchar2
1277: ,p_information19 in varchar2 default hr_api.g_varchar2
1278: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 1275: ,p_information17 in varchar2 default hr_api.g_varchar2

1271: ,p_information13 in varchar2 default hr_api.g_varchar2
1272: ,p_information14 in varchar2 default hr_api.g_varchar2
1273: ,p_information15 in varchar2 default hr_api.g_varchar2
1274: ,p_information16 in varchar2 default hr_api.g_varchar2
1275: ,p_information17 in varchar2 default hr_api.g_varchar2
1276: ,p_information18 in varchar2 default hr_api.g_varchar2
1277: ,p_information19 in varchar2 default hr_api.g_varchar2
1278: ,p_information20 in varchar2 default hr_api.g_varchar2
1279: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 1276: ,p_information18 in varchar2 default hr_api.g_varchar2

1272: ,p_information14 in varchar2 default hr_api.g_varchar2
1273: ,p_information15 in varchar2 default hr_api.g_varchar2
1274: ,p_information16 in varchar2 default hr_api.g_varchar2
1275: ,p_information17 in varchar2 default hr_api.g_varchar2
1276: ,p_information18 in varchar2 default hr_api.g_varchar2
1277: ,p_information19 in varchar2 default hr_api.g_varchar2
1278: ,p_information20 in varchar2 default hr_api.g_varchar2
1279: ,p_information21 in varchar2 default hr_api.g_varchar2
1280: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 1277: ,p_information19 in varchar2 default hr_api.g_varchar2

1273: ,p_information15 in varchar2 default hr_api.g_varchar2
1274: ,p_information16 in varchar2 default hr_api.g_varchar2
1275: ,p_information17 in varchar2 default hr_api.g_varchar2
1276: ,p_information18 in varchar2 default hr_api.g_varchar2
1277: ,p_information19 in varchar2 default hr_api.g_varchar2
1278: ,p_information20 in varchar2 default hr_api.g_varchar2
1279: ,p_information21 in varchar2 default hr_api.g_varchar2
1280: ,p_information22 in varchar2 default hr_api.g_varchar2
1281: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 1278: ,p_information20 in varchar2 default hr_api.g_varchar2

1274: ,p_information16 in varchar2 default hr_api.g_varchar2
1275: ,p_information17 in varchar2 default hr_api.g_varchar2
1276: ,p_information18 in varchar2 default hr_api.g_varchar2
1277: ,p_information19 in varchar2 default hr_api.g_varchar2
1278: ,p_information20 in varchar2 default hr_api.g_varchar2
1279: ,p_information21 in varchar2 default hr_api.g_varchar2
1280: ,p_information22 in varchar2 default hr_api.g_varchar2
1281: ,p_information23 in varchar2 default hr_api.g_varchar2
1282: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 1279: ,p_information21 in varchar2 default hr_api.g_varchar2

1275: ,p_information17 in varchar2 default hr_api.g_varchar2
1276: ,p_information18 in varchar2 default hr_api.g_varchar2
1277: ,p_information19 in varchar2 default hr_api.g_varchar2
1278: ,p_information20 in varchar2 default hr_api.g_varchar2
1279: ,p_information21 in varchar2 default hr_api.g_varchar2
1280: ,p_information22 in varchar2 default hr_api.g_varchar2
1281: ,p_information23 in varchar2 default hr_api.g_varchar2
1282: ,p_information24 in varchar2 default hr_api.g_varchar2
1283: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 1280: ,p_information22 in varchar2 default hr_api.g_varchar2

1276: ,p_information18 in varchar2 default hr_api.g_varchar2
1277: ,p_information19 in varchar2 default hr_api.g_varchar2
1278: ,p_information20 in varchar2 default hr_api.g_varchar2
1279: ,p_information21 in varchar2 default hr_api.g_varchar2
1280: ,p_information22 in varchar2 default hr_api.g_varchar2
1281: ,p_information23 in varchar2 default hr_api.g_varchar2
1282: ,p_information24 in varchar2 default hr_api.g_varchar2
1283: ,p_information25 in varchar2 default hr_api.g_varchar2
1284: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 1281: ,p_information23 in varchar2 default hr_api.g_varchar2

1277: ,p_information19 in varchar2 default hr_api.g_varchar2
1278: ,p_information20 in varchar2 default hr_api.g_varchar2
1279: ,p_information21 in varchar2 default hr_api.g_varchar2
1280: ,p_information22 in varchar2 default hr_api.g_varchar2
1281: ,p_information23 in varchar2 default hr_api.g_varchar2
1282: ,p_information24 in varchar2 default hr_api.g_varchar2
1283: ,p_information25 in varchar2 default hr_api.g_varchar2
1284: ,p_information26 in varchar2 default hr_api.g_varchar2
1285: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 1282: ,p_information24 in varchar2 default hr_api.g_varchar2

1278: ,p_information20 in varchar2 default hr_api.g_varchar2
1279: ,p_information21 in varchar2 default hr_api.g_varchar2
1280: ,p_information22 in varchar2 default hr_api.g_varchar2
1281: ,p_information23 in varchar2 default hr_api.g_varchar2
1282: ,p_information24 in varchar2 default hr_api.g_varchar2
1283: ,p_information25 in varchar2 default hr_api.g_varchar2
1284: ,p_information26 in varchar2 default hr_api.g_varchar2
1285: ,p_information27 in varchar2 default hr_api.g_varchar2
1286: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 1283: ,p_information25 in varchar2 default hr_api.g_varchar2

1279: ,p_information21 in varchar2 default hr_api.g_varchar2
1280: ,p_information22 in varchar2 default hr_api.g_varchar2
1281: ,p_information23 in varchar2 default hr_api.g_varchar2
1282: ,p_information24 in varchar2 default hr_api.g_varchar2
1283: ,p_information25 in varchar2 default hr_api.g_varchar2
1284: ,p_information26 in varchar2 default hr_api.g_varchar2
1285: ,p_information27 in varchar2 default hr_api.g_varchar2
1286: ,p_information28 in varchar2 default hr_api.g_varchar2
1287: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 1284: ,p_information26 in varchar2 default hr_api.g_varchar2

1280: ,p_information22 in varchar2 default hr_api.g_varchar2
1281: ,p_information23 in varchar2 default hr_api.g_varchar2
1282: ,p_information24 in varchar2 default hr_api.g_varchar2
1283: ,p_information25 in varchar2 default hr_api.g_varchar2
1284: ,p_information26 in varchar2 default hr_api.g_varchar2
1285: ,p_information27 in varchar2 default hr_api.g_varchar2
1286: ,p_information28 in varchar2 default hr_api.g_varchar2
1287: ,p_information29 in varchar2 default hr_api.g_varchar2
1288: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 1285: ,p_information27 in varchar2 default hr_api.g_varchar2

1281: ,p_information23 in varchar2 default hr_api.g_varchar2
1282: ,p_information24 in varchar2 default hr_api.g_varchar2
1283: ,p_information25 in varchar2 default hr_api.g_varchar2
1284: ,p_information26 in varchar2 default hr_api.g_varchar2
1285: ,p_information27 in varchar2 default hr_api.g_varchar2
1286: ,p_information28 in varchar2 default hr_api.g_varchar2
1287: ,p_information29 in varchar2 default hr_api.g_varchar2
1288: ,p_information30 in varchar2 default hr_api.g_varchar2
1289: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 1286: ,p_information28 in varchar2 default hr_api.g_varchar2

1282: ,p_information24 in varchar2 default hr_api.g_varchar2
1283: ,p_information25 in varchar2 default hr_api.g_varchar2
1284: ,p_information26 in varchar2 default hr_api.g_varchar2
1285: ,p_information27 in varchar2 default hr_api.g_varchar2
1286: ,p_information28 in varchar2 default hr_api.g_varchar2
1287: ,p_information29 in varchar2 default hr_api.g_varchar2
1288: ,p_information30 in varchar2 default hr_api.g_varchar2
1289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1290: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1287: ,p_information29 in varchar2 default hr_api.g_varchar2

1283: ,p_information25 in varchar2 default hr_api.g_varchar2
1284: ,p_information26 in varchar2 default hr_api.g_varchar2
1285: ,p_information27 in varchar2 default hr_api.g_varchar2
1286: ,p_information28 in varchar2 default hr_api.g_varchar2
1287: ,p_information29 in varchar2 default hr_api.g_varchar2
1288: ,p_information30 in varchar2 default hr_api.g_varchar2
1289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1291: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1288: ,p_information30 in varchar2 default hr_api.g_varchar2

1284: ,p_information26 in varchar2 default hr_api.g_varchar2
1285: ,p_information27 in varchar2 default hr_api.g_varchar2
1286: ,p_information28 in varchar2 default hr_api.g_varchar2
1287: ,p_information29 in varchar2 default hr_api.g_varchar2
1288: ,p_information30 in varchar2 default hr_api.g_varchar2
1289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1292: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1289: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1285: ,p_information27 in varchar2 default hr_api.g_varchar2
1286: ,p_information28 in varchar2 default hr_api.g_varchar2
1287: ,p_information29 in varchar2 default hr_api.g_varchar2
1288: ,p_information30 in varchar2 default hr_api.g_varchar2
1289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1293: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1290: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1286: ,p_information28 in varchar2 default hr_api.g_varchar2
1287: ,p_information29 in varchar2 default hr_api.g_varchar2
1288: ,p_information30 in varchar2 default hr_api.g_varchar2
1289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1294: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1291: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1287: ,p_information29 in varchar2 default hr_api.g_varchar2
1288: ,p_information30 in varchar2 default hr_api.g_varchar2
1289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1295: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1292: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1288: ,p_information30 in varchar2 default hr_api.g_varchar2
1289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1296: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1293: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1297: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1294: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1298: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1295: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1299: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1296: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1300: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1297: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1301: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1298: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1302: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1299: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1303: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1300: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1304: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1301: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1305: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1302: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1306: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1303: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1307: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1304: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1308: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1305: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1309: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1306: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1309: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1310: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 1307: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1309: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1310: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1311: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 1308: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1309: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1310: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1311: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1312: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 1309: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1309: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1310: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1311: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1312: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1313: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 1310: ,p_attribute21 in varchar2 default hr_api.g_varchar2

1306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1309: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1310: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1311: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1312: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1313: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 1311: ,p_attribute22 in varchar2 default hr_api.g_varchar2

1307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1309: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1310: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1311: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1312: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1313: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 1312: ,p_attribute23 in varchar2 default hr_api.g_varchar2

1308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1309: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1310: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1311: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1312: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1313: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 1313: ,p_attribute24 in varchar2 default hr_api.g_varchar2

1309: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1310: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1311: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1312: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1313: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 1314: ,p_attribute25 in varchar2 default hr_api.g_varchar2

1310: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1311: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1312: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1313: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 1315: ,p_attribute26 in varchar2 default hr_api.g_varchar2

1311: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1312: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1313: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 1316: ,p_attribute27 in varchar2 default hr_api.g_varchar2

1312: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1313: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1320: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2

Line 1317: ,p_attribute28 in varchar2 default hr_api.g_varchar2

1313: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1314: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1320: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2
1321: ,p_indemnity_currency in varchar2 default hr_api.g_varchar2

Line 1318: ,p_attribute29 in varchar2 default hr_api.g_varchar2

1314: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1315: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1320: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2
1321: ,p_indemnity_currency in varchar2 default hr_api.g_varchar2
1322: ,p_effective_start_date out nocopy date

Line 1319: ,p_attribute30 in varchar2 default hr_api.g_varchar2

1315: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1316: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1320: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2
1321: ,p_indemnity_currency in varchar2 default hr_api.g_varchar2
1322: ,p_effective_start_date out nocopy date
1323: ,p_effective_end_date out nocopy date

Line 1320: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2

1316: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1317: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1320: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2
1321: ,p_indemnity_currency in varchar2 default hr_api.g_varchar2
1322: ,p_effective_start_date out nocopy date
1323: ,p_effective_end_date out nocopy date
1324: ) is

Line 1321: ,p_indemnity_currency in varchar2 default hr_api.g_varchar2

1317: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1318: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1319: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1320: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2
1321: ,p_indemnity_currency in varchar2 default hr_api.g_varchar2
1322: ,p_effective_start_date out nocopy date
1323: ,p_effective_end_date out nocopy date
1324: ) is
1325: --