292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294: --
295: Exception
296: When hr_api.check_integrity_violated Then
297: -- A check constraint has been violated
298: ghr_par_shd.constraint_error
299: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
300: When hr_api.parent_integrity_violated Then
295: Exception
296: When hr_api.check_integrity_violated Then
297: -- A check constraint has been violated
298: ghr_par_shd.constraint_error
299: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
300: When hr_api.parent_integrity_violated Then
301: -- Parent integrity has been violated
302: ghr_par_shd.constraint_error
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
296: When hr_api.check_integrity_violated Then
297: -- A check constraint has been violated
298: ghr_par_shd.constraint_error
299: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
300: When hr_api.parent_integrity_violated Then
301: -- Parent integrity has been violated
302: ghr_par_shd.constraint_error
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
299: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
300: When hr_api.parent_integrity_violated Then
301: -- Parent integrity has been violated
302: ghr_par_shd.constraint_error
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
305: -- Unique integrity has been violated
306: ghr_par_shd.constraint_error
307: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
300: When hr_api.parent_integrity_violated Then
301: -- Parent integrity has been violated
302: ghr_par_shd.constraint_error
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
305: -- Unique integrity has been violated
306: ghr_par_shd.constraint_error
307: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
308: When Others Then
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
305: -- Unique integrity has been violated
306: ghr_par_shd.constraint_error
307: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
308: When Others Then
309: Raise;
310: End update_dml;
311: --
834: p_mass_action_select_flag_o => ghr_par_shd.g_old_rec.mass_action_select_flag,
835: p_mass_action_comments_o => ghr_par_shd.g_old_rec.mass_action_comments
836: );
837: exception
838: when hr_api.cannot_find_prog_unit then
839: hr_api.cannot_find_prog_unit_error
840: ( p_module_name => 'GHR_PA_REQUESTS'
841: ,p_hook_type => 'AU'
842: );
835: p_mass_action_comments_o => ghr_par_shd.g_old_rec.mass_action_comments
836: );
837: exception
838: when hr_api.cannot_find_prog_unit then
839: hr_api.cannot_find_prog_unit_error
840: ( p_module_name => 'GHR_PA_REQUESTS'
841: ,p_hook_type => 'AU'
842: );
843: end;
903: -- p_rec plsql record structure
904: -- to see if a system default is being used. If a system default
905: -- is being used then we must set to the 'current' argument value.
906: --
907: If (p_rec.pa_notification_id = hr_api.g_number) then
908: p_rec.pa_notification_id :=
909: ghr_par_shd.g_old_rec.pa_notification_id;
910: End If;
911: If (p_rec.noa_family_code = hr_api.g_varchar2) then
907: If (p_rec.pa_notification_id = hr_api.g_number) then
908: p_rec.pa_notification_id :=
909: ghr_par_shd.g_old_rec.pa_notification_id;
910: End If;
911: If (p_rec.noa_family_code = hr_api.g_varchar2) then
912: p_rec.noa_family_code :=
913: ghr_par_shd.g_old_rec.noa_family_code;
914: End If;
915: If (p_rec.routing_group_id = hr_api.g_number) then
911: If (p_rec.noa_family_code = hr_api.g_varchar2) then
912: p_rec.noa_family_code :=
913: ghr_par_shd.g_old_rec.noa_family_code;
914: End If;
915: If (p_rec.routing_group_id = hr_api.g_number) then
916: p_rec.routing_group_id :=
917: ghr_par_shd.g_old_rec.routing_group_id;
918: End If;
919: If (p_rec.proposed_effective_asap_flag = hr_api.g_varchar2) then
915: If (p_rec.routing_group_id = hr_api.g_number) then
916: p_rec.routing_group_id :=
917: ghr_par_shd.g_old_rec.routing_group_id;
918: End If;
919: If (p_rec.proposed_effective_asap_flag = hr_api.g_varchar2) then
920: p_rec.proposed_effective_asap_flag :=
921: ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
922: End If;
923: If (p_rec.academic_discipline = hr_api.g_varchar2) then
919: If (p_rec.proposed_effective_asap_flag = hr_api.g_varchar2) then
920: p_rec.proposed_effective_asap_flag :=
921: ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
922: End If;
923: If (p_rec.academic_discipline = hr_api.g_varchar2) then
924: p_rec.academic_discipline :=
925: ghr_par_shd.g_old_rec.academic_discipline;
926: End If;
927: If (p_rec.additional_info_person_id = hr_api.g_number) then
923: If (p_rec.academic_discipline = hr_api.g_varchar2) then
924: p_rec.academic_discipline :=
925: ghr_par_shd.g_old_rec.academic_discipline;
926: End If;
927: If (p_rec.additional_info_person_id = hr_api.g_number) then
928: p_rec.additional_info_person_id :=
929: ghr_par_shd.g_old_rec.additional_info_person_id;
930: End If;
931: If (p_rec.additional_info_tel_number = hr_api.g_varchar2) then
927: If (p_rec.additional_info_person_id = hr_api.g_number) then
928: p_rec.additional_info_person_id :=
929: ghr_par_shd.g_old_rec.additional_info_person_id;
930: End If;
931: If (p_rec.additional_info_tel_number = hr_api.g_varchar2) then
932: p_rec.additional_info_tel_number :=
933: ghr_par_shd.g_old_rec.additional_info_tel_number;
934: End If;
935: If (p_rec.agency_code = hr_api.g_varchar2) then
931: If (p_rec.additional_info_tel_number = hr_api.g_varchar2) then
932: p_rec.additional_info_tel_number :=
933: ghr_par_shd.g_old_rec.additional_info_tel_number;
934: End If;
935: If (p_rec.agency_code = hr_api.g_varchar2) then
936: p_rec.agency_code :=
937: ghr_par_shd.g_old_rec.agency_code;
938: End If;
939: If (p_rec.altered_pa_request_id = hr_api.g_number) then
935: If (p_rec.agency_code = hr_api.g_varchar2) then
936: p_rec.agency_code :=
937: ghr_par_shd.g_old_rec.agency_code;
938: End If;
939: If (p_rec.altered_pa_request_id = hr_api.g_number) then
940: p_rec.altered_pa_request_id :=
941: ghr_par_shd.g_old_rec.altered_pa_request_id;
942: End If;
943: If (p_rec.annuitant_indicator = hr_api.g_varchar2) then
939: If (p_rec.altered_pa_request_id = hr_api.g_number) then
940: p_rec.altered_pa_request_id :=
941: ghr_par_shd.g_old_rec.altered_pa_request_id;
942: End If;
943: If (p_rec.annuitant_indicator = hr_api.g_varchar2) then
944: p_rec.annuitant_indicator :=
945: ghr_par_shd.g_old_rec.annuitant_indicator;
946: End If;
947: If (p_rec.annuitant_indicator_desc = hr_api.g_varchar2) then
943: If (p_rec.annuitant_indicator = hr_api.g_varchar2) then
944: p_rec.annuitant_indicator :=
945: ghr_par_shd.g_old_rec.annuitant_indicator;
946: End If;
947: If (p_rec.annuitant_indicator_desc = hr_api.g_varchar2) then
948: p_rec.annuitant_indicator_desc :=
949: ghr_par_shd.g_old_rec.annuitant_indicator_desc;
950: End If;
951: If (p_rec.appropriation_code1 = hr_api.g_varchar2) then
947: If (p_rec.annuitant_indicator_desc = hr_api.g_varchar2) then
948: p_rec.annuitant_indicator_desc :=
949: ghr_par_shd.g_old_rec.annuitant_indicator_desc;
950: End If;
951: If (p_rec.appropriation_code1 = hr_api.g_varchar2) then
952: p_rec.appropriation_code1 :=
953: ghr_par_shd.g_old_rec.appropriation_code1;
954: End If;
955: If (p_rec.appropriation_code2 = hr_api.g_varchar2) then
951: If (p_rec.appropriation_code1 = hr_api.g_varchar2) then
952: p_rec.appropriation_code1 :=
953: ghr_par_shd.g_old_rec.appropriation_code1;
954: End If;
955: If (p_rec.appropriation_code2 = hr_api.g_varchar2) then
956: p_rec.appropriation_code2 :=
957: ghr_par_shd.g_old_rec.appropriation_code2;
958: End If;
959: If (p_rec.approval_date = hr_api.g_date) then
955: If (p_rec.appropriation_code2 = hr_api.g_varchar2) then
956: p_rec.appropriation_code2 :=
957: ghr_par_shd.g_old_rec.appropriation_code2;
958: End If;
959: If (p_rec.approval_date = hr_api.g_date) then
960: p_rec.approval_date :=
961: ghr_par_shd.g_old_rec.approval_date;
962: End If;
963: If (p_rec.approving_official_full_name = hr_api.g_varchar2) then
959: If (p_rec.approval_date = hr_api.g_date) then
960: p_rec.approval_date :=
961: ghr_par_shd.g_old_rec.approval_date;
962: End If;
963: If (p_rec.approving_official_full_name = hr_api.g_varchar2) then
964: p_rec.approving_official_full_name :=
965: ghr_par_shd.g_old_rec.approving_official_full_name;
966: End If;
967: If (p_rec.approving_official_work_title = hr_api.g_varchar2) then
963: If (p_rec.approving_official_full_name = hr_api.g_varchar2) then
964: p_rec.approving_official_full_name :=
965: ghr_par_shd.g_old_rec.approving_official_full_name;
966: End If;
967: If (p_rec.approving_official_work_title = hr_api.g_varchar2) then
968: p_rec.approving_official_work_title :=
969: ghr_par_shd.g_old_rec.approving_official_work_title;
970: End If;
971: If (p_rec.sf50_approval_date = hr_api.g_date) then
967: If (p_rec.approving_official_work_title = hr_api.g_varchar2) then
968: p_rec.approving_official_work_title :=
969: ghr_par_shd.g_old_rec.approving_official_work_title;
970: End If;
971: If (p_rec.sf50_approval_date = hr_api.g_date) then
972: p_rec.sf50_approval_date :=
973: ghr_par_shd.g_old_rec.sf50_approval_date;
974: End If;
975: If (p_rec.sf50_approving_ofcl_full_name = hr_api.g_varchar2) then
971: If (p_rec.sf50_approval_date = hr_api.g_date) then
972: p_rec.sf50_approval_date :=
973: ghr_par_shd.g_old_rec.sf50_approval_date;
974: End If;
975: If (p_rec.sf50_approving_ofcl_full_name = hr_api.g_varchar2) then
976: p_rec.sf50_approving_ofcl_full_name :=
977: ghr_par_shd.g_old_rec.sf50_approving_ofcl_full_name ;
978: End If;
979: If (p_rec.sf50_approving_ofcl_work_title = hr_api.g_varchar2) then
975: If (p_rec.sf50_approving_ofcl_full_name = hr_api.g_varchar2) then
976: p_rec.sf50_approving_ofcl_full_name :=
977: ghr_par_shd.g_old_rec.sf50_approving_ofcl_full_name ;
978: End If;
979: If (p_rec.sf50_approving_ofcl_work_title = hr_api.g_varchar2) then
980: p_rec.sf50_approving_ofcl_work_title :=
981: ghr_par_shd.g_old_rec.sf50_approving_ofcl_work_title;
982: End If;
983: If (p_rec.authorized_by_person_id = hr_api.g_number) then
979: If (p_rec.sf50_approving_ofcl_work_title = hr_api.g_varchar2) then
980: p_rec.sf50_approving_ofcl_work_title :=
981: ghr_par_shd.g_old_rec.sf50_approving_ofcl_work_title;
982: End If;
983: If (p_rec.authorized_by_person_id = hr_api.g_number) then
984: p_rec.authorized_by_person_id :=
985: ghr_par_shd.g_old_rec.authorized_by_person_id;
986: End If;
987: If (p_rec.authorized_by_title = hr_api.g_varchar2) then
983: If (p_rec.authorized_by_person_id = hr_api.g_number) then
984: p_rec.authorized_by_person_id :=
985: ghr_par_shd.g_old_rec.authorized_by_person_id;
986: End If;
987: If (p_rec.authorized_by_title = hr_api.g_varchar2) then
988: p_rec.authorized_by_title :=
989: ghr_par_shd.g_old_rec.authorized_by_title;
990: End If;
991: If (p_rec.award_amount = hr_api.g_number) then
987: If (p_rec.authorized_by_title = hr_api.g_varchar2) then
988: p_rec.authorized_by_title :=
989: ghr_par_shd.g_old_rec.authorized_by_title;
990: End If;
991: If (p_rec.award_amount = hr_api.g_number) then
992: p_rec.award_amount :=
993: ghr_par_shd.g_old_rec.award_amount;
994: End If;
995: If (p_rec.award_uom = hr_api.g_varchar2) then
991: If (p_rec.award_amount = hr_api.g_number) then
992: p_rec.award_amount :=
993: ghr_par_shd.g_old_rec.award_amount;
994: End If;
995: If (p_rec.award_uom = hr_api.g_varchar2) then
996: p_rec.award_uom :=
997: ghr_par_shd.g_old_rec.award_uom;
998: End If;
999: If (p_rec.bargaining_unit_status = hr_api.g_varchar2) then
995: If (p_rec.award_uom = hr_api.g_varchar2) then
996: p_rec.award_uom :=
997: ghr_par_shd.g_old_rec.award_uom;
998: End If;
999: If (p_rec.bargaining_unit_status = hr_api.g_varchar2) then
1000: p_rec.bargaining_unit_status :=
1001: ghr_par_shd.g_old_rec.bargaining_unit_status;
1002: End If;
1003: If (p_rec.citizenship = hr_api.g_varchar2) then
999: If (p_rec.bargaining_unit_status = hr_api.g_varchar2) then
1000: p_rec.bargaining_unit_status :=
1001: ghr_par_shd.g_old_rec.bargaining_unit_status;
1002: End If;
1003: If (p_rec.citizenship = hr_api.g_varchar2) then
1004: p_rec.citizenship :=
1005: ghr_par_shd.g_old_rec.citizenship;
1006: End If;
1007: If (p_rec.concurrence_date = hr_api.g_date) then
1003: If (p_rec.citizenship = hr_api.g_varchar2) then
1004: p_rec.citizenship :=
1005: ghr_par_shd.g_old_rec.citizenship;
1006: End If;
1007: If (p_rec.concurrence_date = hr_api.g_date) then
1008: p_rec.concurrence_date :=
1009: ghr_par_shd.g_old_rec.concurrence_date;
1010: End If;
1011: If (p_rec.custom_pay_calc_flag = hr_api.g_varchar2) then
1007: If (p_rec.concurrence_date = hr_api.g_date) then
1008: p_rec.concurrence_date :=
1009: ghr_par_shd.g_old_rec.concurrence_date;
1010: End If;
1011: If (p_rec.custom_pay_calc_flag = hr_api.g_varchar2) then
1012: p_rec.custom_pay_calc_flag :=
1013: ghr_par_shd.g_old_rec.custom_pay_calc_flag;
1014: End If;
1015: If (p_rec.duty_station_code = hr_api.g_varchar2) then
1011: If (p_rec.custom_pay_calc_flag = hr_api.g_varchar2) then
1012: p_rec.custom_pay_calc_flag :=
1013: ghr_par_shd.g_old_rec.custom_pay_calc_flag;
1014: End If;
1015: If (p_rec.duty_station_code = hr_api.g_varchar2) then
1016: p_rec.duty_station_code :=
1017: ghr_par_shd.g_old_rec.duty_station_code;
1018: End If;
1019: If (p_rec.duty_station_desc = hr_api.g_varchar2) then
1015: If (p_rec.duty_station_code = hr_api.g_varchar2) then
1016: p_rec.duty_station_code :=
1017: ghr_par_shd.g_old_rec.duty_station_code;
1018: End If;
1019: If (p_rec.duty_station_desc = hr_api.g_varchar2) then
1020: p_rec.duty_station_desc :=
1021: ghr_par_shd.g_old_rec.duty_station_desc;
1022: End If;
1023: If (p_rec.duty_station_id = hr_api.g_number) then
1019: If (p_rec.duty_station_desc = hr_api.g_varchar2) then
1020: p_rec.duty_station_desc :=
1021: ghr_par_shd.g_old_rec.duty_station_desc;
1022: End If;
1023: If (p_rec.duty_station_id = hr_api.g_number) then
1024: p_rec.duty_station_id :=
1025: ghr_par_shd.g_old_rec.duty_station_id;
1026: End If;
1027: If (p_rec.duty_station_location_id = hr_api.g_number) then
1023: If (p_rec.duty_station_id = hr_api.g_number) then
1024: p_rec.duty_station_id :=
1025: ghr_par_shd.g_old_rec.duty_station_id;
1026: End If;
1027: If (p_rec.duty_station_location_id = hr_api.g_number) then
1028: p_rec.duty_station_location_id :=
1029: ghr_par_shd.g_old_rec.duty_station_location_id;
1030: End If;
1031: If (p_rec.education_level = hr_api.g_varchar2) then
1027: If (p_rec.duty_station_location_id = hr_api.g_number) then
1028: p_rec.duty_station_location_id :=
1029: ghr_par_shd.g_old_rec.duty_station_location_id;
1030: End If;
1031: If (p_rec.education_level = hr_api.g_varchar2) then
1032: p_rec.education_level :=
1033: ghr_par_shd.g_old_rec.education_level;
1034: End If;
1035: If (p_rec.effective_date = hr_api.g_date) then
1031: If (p_rec.education_level = hr_api.g_varchar2) then
1032: p_rec.education_level :=
1033: ghr_par_shd.g_old_rec.education_level;
1034: End If;
1035: If (p_rec.effective_date = hr_api.g_date) then
1036: p_rec.effective_date :=
1037: ghr_par_shd.g_old_rec.effective_date;
1038: End If;
1039: If (p_rec.employee_assignment_id = hr_api.g_number) then
1035: If (p_rec.effective_date = hr_api.g_date) then
1036: p_rec.effective_date :=
1037: ghr_par_shd.g_old_rec.effective_date;
1038: End If;
1039: If (p_rec.employee_assignment_id = hr_api.g_number) then
1040: p_rec.employee_assignment_id :=
1041: ghr_par_shd.g_old_rec.employee_assignment_id;
1042: End If;
1043: If (p_rec.employee_date_of_birth = hr_api.g_date) then
1039: If (p_rec.employee_assignment_id = hr_api.g_number) then
1040: p_rec.employee_assignment_id :=
1041: ghr_par_shd.g_old_rec.employee_assignment_id;
1042: End If;
1043: If (p_rec.employee_date_of_birth = hr_api.g_date) then
1044: p_rec.employee_date_of_birth :=
1045: ghr_par_shd.g_old_rec.employee_date_of_birth;
1046: End If;
1047: If (p_rec.employee_dept_or_agency = hr_api.g_varchar2) then
1043: If (p_rec.employee_date_of_birth = hr_api.g_date) then
1044: p_rec.employee_date_of_birth :=
1045: ghr_par_shd.g_old_rec.employee_date_of_birth;
1046: End If;
1047: If (p_rec.employee_dept_or_agency = hr_api.g_varchar2) then
1048: p_rec.employee_dept_or_agency :=
1049: ghr_par_shd.g_old_rec.employee_dept_or_agency;
1050: End If;
1051: If (p_rec.employee_first_name = hr_api.g_varchar2) then
1047: If (p_rec.employee_dept_or_agency = hr_api.g_varchar2) then
1048: p_rec.employee_dept_or_agency :=
1049: ghr_par_shd.g_old_rec.employee_dept_or_agency;
1050: End If;
1051: If (p_rec.employee_first_name = hr_api.g_varchar2) then
1052: p_rec.employee_first_name :=
1053: ghr_par_shd.g_old_rec.employee_first_name;
1054: End If;
1055: If (p_rec.employee_last_name = hr_api.g_varchar2) then
1051: If (p_rec.employee_first_name = hr_api.g_varchar2) then
1052: p_rec.employee_first_name :=
1053: ghr_par_shd.g_old_rec.employee_first_name;
1054: End If;
1055: If (p_rec.employee_last_name = hr_api.g_varchar2) then
1056: p_rec.employee_last_name :=
1057: ghr_par_shd.g_old_rec.employee_last_name;
1058: End If;
1059: If (p_rec.employee_middle_names = hr_api.g_varchar2) then
1055: If (p_rec.employee_last_name = hr_api.g_varchar2) then
1056: p_rec.employee_last_name :=
1057: ghr_par_shd.g_old_rec.employee_last_name;
1058: End If;
1059: If (p_rec.employee_middle_names = hr_api.g_varchar2) then
1060: p_rec.employee_middle_names :=
1061: ghr_par_shd.g_old_rec.employee_middle_names;
1062: End If;
1063: If (p_rec.employee_national_identifier = hr_api.g_varchar2) then
1059: If (p_rec.employee_middle_names = hr_api.g_varchar2) then
1060: p_rec.employee_middle_names :=
1061: ghr_par_shd.g_old_rec.employee_middle_names;
1062: End If;
1063: If (p_rec.employee_national_identifier = hr_api.g_varchar2) then
1064: p_rec.employee_national_identifier :=
1065: ghr_par_shd.g_old_rec.employee_national_identifier;
1066: End If;
1067: If (p_rec.fegli = hr_api.g_varchar2) then
1063: If (p_rec.employee_national_identifier = hr_api.g_varchar2) then
1064: p_rec.employee_national_identifier :=
1065: ghr_par_shd.g_old_rec.employee_national_identifier;
1066: End If;
1067: If (p_rec.fegli = hr_api.g_varchar2) then
1068: p_rec.fegli :=
1069: ghr_par_shd.g_old_rec.fegli;
1070: End If;
1071: If (p_rec.fegli_desc = hr_api.g_varchar2) then
1067: If (p_rec.fegli = hr_api.g_varchar2) then
1068: p_rec.fegli :=
1069: ghr_par_shd.g_old_rec.fegli;
1070: End If;
1071: If (p_rec.fegli_desc = hr_api.g_varchar2) then
1072: p_rec.fegli_desc :=
1073: ghr_par_shd.g_old_rec.fegli_desc;
1074: End If;
1075: If (p_rec.first_action_la_code1 = hr_api.g_varchar2) then
1071: If (p_rec.fegli_desc = hr_api.g_varchar2) then
1072: p_rec.fegli_desc :=
1073: ghr_par_shd.g_old_rec.fegli_desc;
1074: End If;
1075: If (p_rec.first_action_la_code1 = hr_api.g_varchar2) then
1076: p_rec.first_action_la_code1 :=
1077: ghr_par_shd.g_old_rec.first_action_la_code1;
1078: End If;
1079: If (p_rec.first_action_la_code2 = hr_api.g_varchar2) then
1075: If (p_rec.first_action_la_code1 = hr_api.g_varchar2) then
1076: p_rec.first_action_la_code1 :=
1077: ghr_par_shd.g_old_rec.first_action_la_code1;
1078: End If;
1079: If (p_rec.first_action_la_code2 = hr_api.g_varchar2) then
1080: p_rec.first_action_la_code2 :=
1081: ghr_par_shd.g_old_rec.first_action_la_code2;
1082: End If;
1083: If (p_rec.first_action_la_desc1 = hr_api.g_varchar2) then
1079: If (p_rec.first_action_la_code2 = hr_api.g_varchar2) then
1080: p_rec.first_action_la_code2 :=
1081: ghr_par_shd.g_old_rec.first_action_la_code2;
1082: End If;
1083: If (p_rec.first_action_la_desc1 = hr_api.g_varchar2) then
1084: p_rec.first_action_la_desc1 :=
1085: ghr_par_shd.g_old_rec.first_action_la_desc1;
1086: End If;
1087: If (p_rec.first_action_la_desc2 = hr_api.g_varchar2) then
1083: If (p_rec.first_action_la_desc1 = hr_api.g_varchar2) then
1084: p_rec.first_action_la_desc1 :=
1085: ghr_par_shd.g_old_rec.first_action_la_desc1;
1086: End If;
1087: If (p_rec.first_action_la_desc2 = hr_api.g_varchar2) then
1088: p_rec.first_action_la_desc2 :=
1089: ghr_par_shd.g_old_rec.first_action_la_desc2;
1090: End If;
1091: If (p_rec.first_noa_cancel_or_correct = hr_api.g_varchar2) then
1087: If (p_rec.first_action_la_desc2 = hr_api.g_varchar2) then
1088: p_rec.first_action_la_desc2 :=
1089: ghr_par_shd.g_old_rec.first_action_la_desc2;
1090: End If;
1091: If (p_rec.first_noa_cancel_or_correct = hr_api.g_varchar2) then
1092: p_rec.first_noa_cancel_or_correct :=
1093: ghr_par_shd.g_old_rec.first_noa_cancel_or_correct;
1094: End If;
1095: If (p_rec.first_noa_code = hr_api.g_varchar2) then
1091: If (p_rec.first_noa_cancel_or_correct = hr_api.g_varchar2) then
1092: p_rec.first_noa_cancel_or_correct :=
1093: ghr_par_shd.g_old_rec.first_noa_cancel_or_correct;
1094: End If;
1095: If (p_rec.first_noa_code = hr_api.g_varchar2) then
1096: p_rec.first_noa_code :=
1097: ghr_par_shd.g_old_rec.first_noa_code;
1098: End If;
1099: If (p_rec.first_noa_desc = hr_api.g_varchar2) then
1095: If (p_rec.first_noa_code = hr_api.g_varchar2) then
1096: p_rec.first_noa_code :=
1097: ghr_par_shd.g_old_rec.first_noa_code;
1098: End If;
1099: If (p_rec.first_noa_desc = hr_api.g_varchar2) then
1100: p_rec.first_noa_desc :=
1101: ghr_par_shd.g_old_rec.first_noa_desc;
1102: End If;
1103: If (p_rec.first_noa_id = hr_api.g_number) then
1099: If (p_rec.first_noa_desc = hr_api.g_varchar2) then
1100: p_rec.first_noa_desc :=
1101: ghr_par_shd.g_old_rec.first_noa_desc;
1102: End If;
1103: If (p_rec.first_noa_id = hr_api.g_number) then
1104: p_rec.first_noa_id :=
1105: ghr_par_shd.g_old_rec.first_noa_id;
1106: End If;
1107: If (p_rec.first_noa_pa_request_id = hr_api.g_number) then
1103: If (p_rec.first_noa_id = hr_api.g_number) then
1104: p_rec.first_noa_id :=
1105: ghr_par_shd.g_old_rec.first_noa_id;
1106: End If;
1107: If (p_rec.first_noa_pa_request_id = hr_api.g_number) then
1108: p_rec.first_noa_pa_request_id :=
1109: ghr_par_shd.g_old_rec.first_noa_pa_request_id;
1110: End If;
1111: If (p_rec.flsa_category = hr_api.g_varchar2) then
1107: If (p_rec.first_noa_pa_request_id = hr_api.g_number) then
1108: p_rec.first_noa_pa_request_id :=
1109: ghr_par_shd.g_old_rec.first_noa_pa_request_id;
1110: End If;
1111: If (p_rec.flsa_category = hr_api.g_varchar2) then
1112: p_rec.flsa_category :=
1113: ghr_par_shd.g_old_rec.flsa_category;
1114: End If;
1115: If (p_rec.forwarding_address_line1 = hr_api.g_varchar2) then
1111: If (p_rec.flsa_category = hr_api.g_varchar2) then
1112: p_rec.flsa_category :=
1113: ghr_par_shd.g_old_rec.flsa_category;
1114: End If;
1115: If (p_rec.forwarding_address_line1 = hr_api.g_varchar2) then
1116: p_rec.forwarding_address_line1 :=
1117: ghr_par_shd.g_old_rec.forwarding_address_line1;
1118: End If;
1119: If (p_rec.forwarding_address_line2 = hr_api.g_varchar2) then
1115: If (p_rec.forwarding_address_line1 = hr_api.g_varchar2) then
1116: p_rec.forwarding_address_line1 :=
1117: ghr_par_shd.g_old_rec.forwarding_address_line1;
1118: End If;
1119: If (p_rec.forwarding_address_line2 = hr_api.g_varchar2) then
1120: p_rec.forwarding_address_line2 :=
1121: ghr_par_shd.g_old_rec.forwarding_address_line2;
1122: End If;
1123: If (p_rec.forwarding_address_line3 = hr_api.g_varchar2) then
1119: If (p_rec.forwarding_address_line2 = hr_api.g_varchar2) then
1120: p_rec.forwarding_address_line2 :=
1121: ghr_par_shd.g_old_rec.forwarding_address_line2;
1122: End If;
1123: If (p_rec.forwarding_address_line3 = hr_api.g_varchar2) then
1124: p_rec.forwarding_address_line3 :=
1125: ghr_par_shd.g_old_rec.forwarding_address_line3;
1126: End If;
1127: If (p_rec.forwarding_country_short_name = hr_api.g_varchar2) then
1123: If (p_rec.forwarding_address_line3 = hr_api.g_varchar2) then
1124: p_rec.forwarding_address_line3 :=
1125: ghr_par_shd.g_old_rec.forwarding_address_line3;
1126: End If;
1127: If (p_rec.forwarding_country_short_name = hr_api.g_varchar2) then
1128: p_rec.forwarding_country_short_name :=
1129: ghr_par_shd.g_old_rec.forwarding_country_short_name;
1130: End If;
1131: If (p_rec.forwarding_country = hr_api.g_varchar2) then
1127: If (p_rec.forwarding_country_short_name = hr_api.g_varchar2) then
1128: p_rec.forwarding_country_short_name :=
1129: ghr_par_shd.g_old_rec.forwarding_country_short_name;
1130: End If;
1131: If (p_rec.forwarding_country = hr_api.g_varchar2) then
1132: p_rec.forwarding_country :=
1133: ghr_par_shd.g_old_rec.forwarding_country;
1134: End If;
1135: If (p_rec.forwarding_postal_code = hr_api.g_varchar2) then
1131: If (p_rec.forwarding_country = hr_api.g_varchar2) then
1132: p_rec.forwarding_country :=
1133: ghr_par_shd.g_old_rec.forwarding_country;
1134: End If;
1135: If (p_rec.forwarding_postal_code = hr_api.g_varchar2) then
1136: p_rec.forwarding_postal_code :=
1137: ghr_par_shd.g_old_rec.forwarding_postal_code;
1138: End If;
1139: If (p_rec.forwarding_region_2 = hr_api.g_varchar2) then
1135: If (p_rec.forwarding_postal_code = hr_api.g_varchar2) then
1136: p_rec.forwarding_postal_code :=
1137: ghr_par_shd.g_old_rec.forwarding_postal_code;
1138: End If;
1139: If (p_rec.forwarding_region_2 = hr_api.g_varchar2) then
1140: p_rec.forwarding_region_2 :=
1141: ghr_par_shd.g_old_rec.forwarding_region_2;
1142: End If;
1143: If (p_rec.forwarding_town_or_city = hr_api.g_varchar2) then
1139: If (p_rec.forwarding_region_2 = hr_api.g_varchar2) then
1140: p_rec.forwarding_region_2 :=
1141: ghr_par_shd.g_old_rec.forwarding_region_2;
1142: End If;
1143: If (p_rec.forwarding_town_or_city = hr_api.g_varchar2) then
1144: p_rec.forwarding_town_or_city :=
1145: ghr_par_shd.g_old_rec.forwarding_town_or_city;
1146: End If;
1147: If (p_rec.from_adj_basic_pay = hr_api.g_number) then
1143: If (p_rec.forwarding_town_or_city = hr_api.g_varchar2) then
1144: p_rec.forwarding_town_or_city :=
1145: ghr_par_shd.g_old_rec.forwarding_town_or_city;
1146: End If;
1147: If (p_rec.from_adj_basic_pay = hr_api.g_number) then
1148: p_rec.from_adj_basic_pay :=
1149: ghr_par_shd.g_old_rec.from_adj_basic_pay;
1150: End If;
1151: If (p_rec.from_agency_code = hr_api.g_varchar2) then
1147: If (p_rec.from_adj_basic_pay = hr_api.g_number) then
1148: p_rec.from_adj_basic_pay :=
1149: ghr_par_shd.g_old_rec.from_adj_basic_pay;
1150: End If;
1151: If (p_rec.from_agency_code = hr_api.g_varchar2) then
1152: p_rec.from_agency_code :=
1153: ghr_par_shd.g_old_rec.from_agency_code;
1154: End If;
1155: If (p_rec.from_agency_desc = hr_api.g_varchar2) then
1151: If (p_rec.from_agency_code = hr_api.g_varchar2) then
1152: p_rec.from_agency_code :=
1153: ghr_par_shd.g_old_rec.from_agency_code;
1154: End If;
1155: If (p_rec.from_agency_desc = hr_api.g_varchar2) then
1156: p_rec.from_agency_desc :=
1157: ghr_par_shd.g_old_rec.from_agency_desc;
1158: End If;
1159: If (p_rec.from_basic_pay = hr_api.g_number) then
1155: If (p_rec.from_agency_desc = hr_api.g_varchar2) then
1156: p_rec.from_agency_desc :=
1157: ghr_par_shd.g_old_rec.from_agency_desc;
1158: End If;
1159: If (p_rec.from_basic_pay = hr_api.g_number) then
1160: p_rec.from_basic_pay :=
1161: ghr_par_shd.g_old_rec.from_basic_pay;
1162: End If;
1163: If (p_rec.from_grade_or_level = hr_api.g_varchar2) then
1159: If (p_rec.from_basic_pay = hr_api.g_number) then
1160: p_rec.from_basic_pay :=
1161: ghr_par_shd.g_old_rec.from_basic_pay;
1162: End If;
1163: If (p_rec.from_grade_or_level = hr_api.g_varchar2) then
1164: p_rec.from_grade_or_level :=
1165: ghr_par_shd.g_old_rec.from_grade_or_level;
1166: End If;
1167: If (p_rec.from_locality_adj = hr_api.g_number) then
1163: If (p_rec.from_grade_or_level = hr_api.g_varchar2) then
1164: p_rec.from_grade_or_level :=
1165: ghr_par_shd.g_old_rec.from_grade_or_level;
1166: End If;
1167: If (p_rec.from_locality_adj = hr_api.g_number) then
1168: p_rec.from_locality_adj :=
1169: ghr_par_shd.g_old_rec.from_locality_adj;
1170: End If;
1171: If (p_rec.from_occ_code = hr_api.g_varchar2) then
1167: If (p_rec.from_locality_adj = hr_api.g_number) then
1168: p_rec.from_locality_adj :=
1169: ghr_par_shd.g_old_rec.from_locality_adj;
1170: End If;
1171: If (p_rec.from_occ_code = hr_api.g_varchar2) then
1172: p_rec.from_occ_code :=
1173: ghr_par_shd.g_old_rec.from_occ_code;
1174: End If;
1175: If (p_rec.from_office_symbol = hr_api.g_varchar2) then
1171: If (p_rec.from_occ_code = hr_api.g_varchar2) then
1172: p_rec.from_occ_code :=
1173: ghr_par_shd.g_old_rec.from_occ_code;
1174: End If;
1175: If (p_rec.from_office_symbol = hr_api.g_varchar2) then
1176: p_rec.from_office_symbol :=
1177: ghr_par_shd.g_old_rec.from_office_symbol;
1178: End If;
1179: If (p_rec.from_other_pay_amount = hr_api.g_number) then
1175: If (p_rec.from_office_symbol = hr_api.g_varchar2) then
1176: p_rec.from_office_symbol :=
1177: ghr_par_shd.g_old_rec.from_office_symbol;
1178: End If;
1179: If (p_rec.from_other_pay_amount = hr_api.g_number) then
1180: p_rec.from_other_pay_amount :=
1181: ghr_par_shd.g_old_rec.from_other_pay_amount;
1182: End If;
1183: If (p_rec.from_pay_basis = hr_api.g_varchar2) then
1179: If (p_rec.from_other_pay_amount = hr_api.g_number) then
1180: p_rec.from_other_pay_amount :=
1181: ghr_par_shd.g_old_rec.from_other_pay_amount;
1182: End If;
1183: If (p_rec.from_pay_basis = hr_api.g_varchar2) then
1184: p_rec.from_pay_basis :=
1185: ghr_par_shd.g_old_rec.from_pay_basis;
1186: End If;
1187: If (p_rec.from_pay_plan = hr_api.g_varchar2) then
1183: If (p_rec.from_pay_basis = hr_api.g_varchar2) then
1184: p_rec.from_pay_basis :=
1185: ghr_par_shd.g_old_rec.from_pay_basis;
1186: End If;
1187: If (p_rec.from_pay_plan = hr_api.g_varchar2) then
1188: p_rec.from_pay_plan :=
1189: ghr_par_shd.g_old_rec.from_pay_plan;
1190: End If;
1191: -- FWFA Changes Bug#4444609
1188: p_rec.from_pay_plan :=
1189: ghr_par_shd.g_old_rec.from_pay_plan;
1190: End If;
1191: -- FWFA Changes Bug#4444609
1192: If (p_rec.input_pay_rate_determinant = hr_api.g_varchar2) then
1193: p_rec.input_pay_rate_determinant :=
1194: ghr_par_shd.g_old_rec.input_pay_rate_determinant;
1195: End If;
1196: If (p_rec.from_pay_table_identifier = hr_api.g_number) then
1192: If (p_rec.input_pay_rate_determinant = hr_api.g_varchar2) then
1193: p_rec.input_pay_rate_determinant :=
1194: ghr_par_shd.g_old_rec.input_pay_rate_determinant;
1195: End If;
1196: If (p_rec.from_pay_table_identifier = hr_api.g_number) then
1197: p_rec.from_pay_table_identifier :=
1198: ghr_par_shd.g_old_rec.from_pay_table_identifier;
1199: End If;
1200: -- FWFA Changes
1197: p_rec.from_pay_table_identifier :=
1198: ghr_par_shd.g_old_rec.from_pay_table_identifier;
1199: End If;
1200: -- FWFA Changes
1201: If (p_rec.from_position_org_line1 = hr_api.g_varchar2) then
1202: p_rec.from_position_org_line1 :=
1203: ghr_par_shd.g_old_rec.from_position_org_line1;
1204: End If;
1205: If (p_rec.from_position_org_line2 = hr_api.g_varchar2) then
1201: If (p_rec.from_position_org_line1 = hr_api.g_varchar2) then
1202: p_rec.from_position_org_line1 :=
1203: ghr_par_shd.g_old_rec.from_position_org_line1;
1204: End If;
1205: If (p_rec.from_position_org_line2 = hr_api.g_varchar2) then
1206: p_rec.from_position_org_line2 :=
1207: ghr_par_shd.g_old_rec.from_position_org_line2;
1208: End If;
1209: If (p_rec.from_position_org_line3 = hr_api.g_varchar2) then
1205: If (p_rec.from_position_org_line2 = hr_api.g_varchar2) then
1206: p_rec.from_position_org_line2 :=
1207: ghr_par_shd.g_old_rec.from_position_org_line2;
1208: End If;
1209: If (p_rec.from_position_org_line3 = hr_api.g_varchar2) then
1210: p_rec.from_position_org_line3 :=
1211: ghr_par_shd.g_old_rec.from_position_org_line3;
1212: End If;
1213: If (p_rec.from_position_org_line4 = hr_api.g_varchar2) then
1209: If (p_rec.from_position_org_line3 = hr_api.g_varchar2) then
1210: p_rec.from_position_org_line3 :=
1211: ghr_par_shd.g_old_rec.from_position_org_line3;
1212: End If;
1213: If (p_rec.from_position_org_line4 = hr_api.g_varchar2) then
1214: p_rec.from_position_org_line4 :=
1215: ghr_par_shd.g_old_rec.from_position_org_line4;
1216: End If;
1217: If (p_rec.from_position_org_line5 = hr_api.g_varchar2) then
1213: If (p_rec.from_position_org_line4 = hr_api.g_varchar2) then
1214: p_rec.from_position_org_line4 :=
1215: ghr_par_shd.g_old_rec.from_position_org_line4;
1216: End If;
1217: If (p_rec.from_position_org_line5 = hr_api.g_varchar2) then
1218: p_rec.from_position_org_line5 :=
1219: ghr_par_shd.g_old_rec.from_position_org_line5;
1220: End If;
1221: If (p_rec.from_position_org_line6 = hr_api.g_varchar2) then
1217: If (p_rec.from_position_org_line5 = hr_api.g_varchar2) then
1218: p_rec.from_position_org_line5 :=
1219: ghr_par_shd.g_old_rec.from_position_org_line5;
1220: End If;
1221: If (p_rec.from_position_org_line6 = hr_api.g_varchar2) then
1222: p_rec.from_position_org_line6 :=
1223: ghr_par_shd.g_old_rec.from_position_org_line6;
1224: End If;
1225: If (p_rec.from_position_id = hr_api.g_number) then
1221: If (p_rec.from_position_org_line6 = hr_api.g_varchar2) then
1222: p_rec.from_position_org_line6 :=
1223: ghr_par_shd.g_old_rec.from_position_org_line6;
1224: End If;
1225: If (p_rec.from_position_id = hr_api.g_number) then
1226: p_rec.from_position_id :=
1227: ghr_par_shd.g_old_rec.from_position_id;
1228: End If;
1229: If (p_rec.from_position_number = hr_api.g_varchar2) then
1225: If (p_rec.from_position_id = hr_api.g_number) then
1226: p_rec.from_position_id :=
1227: ghr_par_shd.g_old_rec.from_position_id;
1228: End If;
1229: If (p_rec.from_position_number = hr_api.g_varchar2) then
1230: p_rec.from_position_number :=
1231: ghr_par_shd.g_old_rec.from_position_number;
1232: End If;
1233: If (p_rec.from_position_seq_no = hr_api.g_number) then
1229: If (p_rec.from_position_number = hr_api.g_varchar2) then
1230: p_rec.from_position_number :=
1231: ghr_par_shd.g_old_rec.from_position_number;
1232: End If;
1233: If (p_rec.from_position_seq_no = hr_api.g_number) then
1234: p_rec.from_position_seq_no :=
1235: ghr_par_shd.g_old_rec.from_position_seq_no;
1236: End If;
1237: If (p_rec.from_position_title = hr_api.g_varchar2) then
1233: If (p_rec.from_position_seq_no = hr_api.g_number) then
1234: p_rec.from_position_seq_no :=
1235: ghr_par_shd.g_old_rec.from_position_seq_no;
1236: End If;
1237: If (p_rec.from_position_title = hr_api.g_varchar2) then
1238: p_rec.from_position_title :=
1239: ghr_par_shd.g_old_rec.from_position_title;
1240: End If;
1241: If (p_rec.from_step_or_rate = hr_api.g_varchar2) then
1237: If (p_rec.from_position_title = hr_api.g_varchar2) then
1238: p_rec.from_position_title :=
1239: ghr_par_shd.g_old_rec.from_position_title;
1240: End If;
1241: If (p_rec.from_step_or_rate = hr_api.g_varchar2) then
1242: p_rec.from_step_or_rate :=
1243: ghr_par_shd.g_old_rec.from_step_or_rate;
1244: End If;
1245: If (p_rec.from_total_salary = hr_api.g_number) then
1241: If (p_rec.from_step_or_rate = hr_api.g_varchar2) then
1242: p_rec.from_step_or_rate :=
1243: ghr_par_shd.g_old_rec.from_step_or_rate;
1244: End If;
1245: If (p_rec.from_total_salary = hr_api.g_number) then
1246: p_rec.from_total_salary :=
1247: ghr_par_shd.g_old_rec.from_total_salary;
1248: End If;
1249: If (p_rec.functional_class = hr_api.g_varchar2) then
1245: If (p_rec.from_total_salary = hr_api.g_number) then
1246: p_rec.from_total_salary :=
1247: ghr_par_shd.g_old_rec.from_total_salary;
1248: End If;
1249: If (p_rec.functional_class = hr_api.g_varchar2) then
1250: p_rec.functional_class :=
1251: ghr_par_shd.g_old_rec.functional_class;
1252: End If;
1253: If (p_rec.notepad = hr_api.g_varchar2) then
1249: If (p_rec.functional_class = hr_api.g_varchar2) then
1250: p_rec.functional_class :=
1251: ghr_par_shd.g_old_rec.functional_class;
1252: End If;
1253: If (p_rec.notepad = hr_api.g_varchar2) then
1254: p_rec.notepad :=
1255: ghr_par_shd.g_old_rec.notepad;
1256: End If;
1257: If (p_rec.part_time_hours = hr_api.g_number) then
1253: If (p_rec.notepad = hr_api.g_varchar2) then
1254: p_rec.notepad :=
1255: ghr_par_shd.g_old_rec.notepad;
1256: End If;
1257: If (p_rec.part_time_hours = hr_api.g_number) then
1258: p_rec.part_time_hours :=
1259: ghr_par_shd.g_old_rec.part_time_hours;
1260: End If;
1261: If (p_rec.pay_rate_determinant = hr_api.g_varchar2) then
1257: If (p_rec.part_time_hours = hr_api.g_number) then
1258: p_rec.part_time_hours :=
1259: ghr_par_shd.g_old_rec.part_time_hours;
1260: End If;
1261: If (p_rec.pay_rate_determinant = hr_api.g_varchar2) then
1262: p_rec.pay_rate_determinant :=
1263: ghr_par_shd.g_old_rec.pay_rate_determinant;
1264: End If;
1265: If (p_rec.personnel_office_id = hr_api.g_varchar2) then
1261: If (p_rec.pay_rate_determinant = hr_api.g_varchar2) then
1262: p_rec.pay_rate_determinant :=
1263: ghr_par_shd.g_old_rec.pay_rate_determinant;
1264: End If;
1265: If (p_rec.personnel_office_id = hr_api.g_varchar2) then
1266: p_rec.personnel_office_id :=
1267: ghr_par_shd.g_old_rec.personnel_office_id;
1268: End If;
1269: If (p_rec.person_id = hr_api.g_number) then
1265: If (p_rec.personnel_office_id = hr_api.g_varchar2) then
1266: p_rec.personnel_office_id :=
1267: ghr_par_shd.g_old_rec.personnel_office_id;
1268: End If;
1269: If (p_rec.person_id = hr_api.g_number) then
1270: p_rec.person_id :=
1271: ghr_par_shd.g_old_rec.person_id;
1272: End If;
1273: If (p_rec.position_occupied = hr_api.g_varchar2) then
1269: If (p_rec.person_id = hr_api.g_number) then
1270: p_rec.person_id :=
1271: ghr_par_shd.g_old_rec.person_id;
1272: End If;
1273: If (p_rec.position_occupied = hr_api.g_varchar2) then
1274: p_rec.position_occupied :=
1275: ghr_par_shd.g_old_rec.position_occupied;
1276: End If;
1277: If (p_rec.proposed_effective_date = hr_api.g_date) then
1273: If (p_rec.position_occupied = hr_api.g_varchar2) then
1274: p_rec.position_occupied :=
1275: ghr_par_shd.g_old_rec.position_occupied;
1276: End If;
1277: If (p_rec.proposed_effective_date = hr_api.g_date) then
1278: p_rec.proposed_effective_date :=
1279: ghr_par_shd.g_old_rec.proposed_effective_date;
1280: End If;
1281: If (p_rec.proposed_effective_asap_flag = hr_api.g_varchar2) then
1277: If (p_rec.proposed_effective_date = hr_api.g_date) then
1278: p_rec.proposed_effective_date :=
1279: ghr_par_shd.g_old_rec.proposed_effective_date;
1280: End If;
1281: If (p_rec.proposed_effective_asap_flag = hr_api.g_varchar2) then
1282: p_rec.proposed_effective_asap_flag :=
1283: ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
1284: End If;
1285:
1282: p_rec.proposed_effective_asap_flag :=
1283: ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
1284: End If;
1285:
1286: If (p_rec.requested_by_person_id = hr_api.g_number) then
1287: p_rec.requested_by_person_id :=
1288: ghr_par_shd.g_old_rec.requested_by_person_id;
1289: End If;
1290: If (p_rec.requested_by_title = hr_api.g_varchar2) then
1286: If (p_rec.requested_by_person_id = hr_api.g_number) then
1287: p_rec.requested_by_person_id :=
1288: ghr_par_shd.g_old_rec.requested_by_person_id;
1289: End If;
1290: If (p_rec.requested_by_title = hr_api.g_varchar2) then
1291: p_rec.requested_by_title :=
1292: ghr_par_shd.g_old_rec.requested_by_title;
1293: End If;
1294: If (p_rec.requested_date = hr_api.g_date) then
1290: If (p_rec.requested_by_title = hr_api.g_varchar2) then
1291: p_rec.requested_by_title :=
1292: ghr_par_shd.g_old_rec.requested_by_title;
1293: End If;
1294: If (p_rec.requested_date = hr_api.g_date) then
1295: p_rec.requested_date :=
1296: ghr_par_shd.g_old_rec.requested_date;
1297: End If;
1298: If (p_rec.requesting_office_remarks_desc = hr_api.g_varchar2) then
1294: If (p_rec.requested_date = hr_api.g_date) then
1295: p_rec.requested_date :=
1296: ghr_par_shd.g_old_rec.requested_date;
1297: End If;
1298: If (p_rec.requesting_office_remarks_desc = hr_api.g_varchar2) then
1299: p_rec.requesting_office_remarks_desc :=
1300: ghr_par_shd.g_old_rec.requesting_office_remarks_desc;
1301: End If;
1302: If (p_rec.requesting_office_remarks_flag = hr_api.g_varchar2) then
1298: If (p_rec.requesting_office_remarks_desc = hr_api.g_varchar2) then
1299: p_rec.requesting_office_remarks_desc :=
1300: ghr_par_shd.g_old_rec.requesting_office_remarks_desc;
1301: End If;
1302: If (p_rec.requesting_office_remarks_flag = hr_api.g_varchar2) then
1303: p_rec.requesting_office_remarks_flag :=
1304: ghr_par_shd.g_old_rec.requesting_office_remarks_flag;
1305: End If;
1306: If (p_rec.request_number = hr_api.g_varchar2) then
1302: If (p_rec.requesting_office_remarks_flag = hr_api.g_varchar2) then
1303: p_rec.requesting_office_remarks_flag :=
1304: ghr_par_shd.g_old_rec.requesting_office_remarks_flag;
1305: End If;
1306: If (p_rec.request_number = hr_api.g_varchar2) then
1307: p_rec.request_number :=
1308: ghr_par_shd.g_old_rec.request_number;
1309: End If;
1310: If (p_rec.resign_and_retire_reason_desc = hr_api.g_varchar2) then
1306: If (p_rec.request_number = hr_api.g_varchar2) then
1307: p_rec.request_number :=
1308: ghr_par_shd.g_old_rec.request_number;
1309: End If;
1310: If (p_rec.resign_and_retire_reason_desc = hr_api.g_varchar2) then
1311: p_rec.resign_and_retire_reason_desc :=
1312: ghr_par_shd.g_old_rec.resign_and_retire_reason_desc;
1313: End If;
1314: If (p_rec.retirement_plan = hr_api.g_varchar2) then
1310: If (p_rec.resign_and_retire_reason_desc = hr_api.g_varchar2) then
1311: p_rec.resign_and_retire_reason_desc :=
1312: ghr_par_shd.g_old_rec.resign_and_retire_reason_desc;
1313: End If;
1314: If (p_rec.retirement_plan = hr_api.g_varchar2) then
1315: p_rec.retirement_plan :=
1316: ghr_par_shd.g_old_rec.retirement_plan;
1317: End If;
1318: If (p_rec.retirement_plan_desc = hr_api.g_varchar2) then
1314: If (p_rec.retirement_plan = hr_api.g_varchar2) then
1315: p_rec.retirement_plan :=
1316: ghr_par_shd.g_old_rec.retirement_plan;
1317: End If;
1318: If (p_rec.retirement_plan_desc = hr_api.g_varchar2) then
1319: p_rec.retirement_plan_desc :=
1320: ghr_par_shd.g_old_rec.retirement_plan_desc;
1321: End If;
1322: If (p_rec.second_action_la_code1 = hr_api.g_varchar2) then
1318: If (p_rec.retirement_plan_desc = hr_api.g_varchar2) then
1319: p_rec.retirement_plan_desc :=
1320: ghr_par_shd.g_old_rec.retirement_plan_desc;
1321: End If;
1322: If (p_rec.second_action_la_code1 = hr_api.g_varchar2) then
1323: p_rec.second_action_la_code1 :=
1324: ghr_par_shd.g_old_rec.second_action_la_code1;
1325: End If;
1326: If (p_rec.second_action_la_code2 = hr_api.g_varchar2) then
1322: If (p_rec.second_action_la_code1 = hr_api.g_varchar2) then
1323: p_rec.second_action_la_code1 :=
1324: ghr_par_shd.g_old_rec.second_action_la_code1;
1325: End If;
1326: If (p_rec.second_action_la_code2 = hr_api.g_varchar2) then
1327: p_rec.second_action_la_code2 :=
1328: ghr_par_shd.g_old_rec.second_action_la_code2;
1329: End If;
1330: If (p_rec.second_action_la_desc1 = hr_api.g_varchar2) then
1326: If (p_rec.second_action_la_code2 = hr_api.g_varchar2) then
1327: p_rec.second_action_la_code2 :=
1328: ghr_par_shd.g_old_rec.second_action_la_code2;
1329: End If;
1330: If (p_rec.second_action_la_desc1 = hr_api.g_varchar2) then
1331: p_rec.second_action_la_desc1 :=
1332: ghr_par_shd.g_old_rec.second_action_la_desc1;
1333: End If;
1334: If (p_rec.second_action_la_desc2 = hr_api.g_varchar2) then
1330: If (p_rec.second_action_la_desc1 = hr_api.g_varchar2) then
1331: p_rec.second_action_la_desc1 :=
1332: ghr_par_shd.g_old_rec.second_action_la_desc1;
1333: End If;
1334: If (p_rec.second_action_la_desc2 = hr_api.g_varchar2) then
1335: p_rec.second_action_la_desc2 :=
1336: ghr_par_shd.g_old_rec.second_action_la_desc2;
1337: End If;
1338: If (p_rec.second_noa_cancel_or_correct = hr_api.g_varchar2) then
1334: If (p_rec.second_action_la_desc2 = hr_api.g_varchar2) then
1335: p_rec.second_action_la_desc2 :=
1336: ghr_par_shd.g_old_rec.second_action_la_desc2;
1337: End If;
1338: If (p_rec.second_noa_cancel_or_correct = hr_api.g_varchar2) then
1339: p_rec.second_noa_cancel_or_correct :=
1340: ghr_par_shd.g_old_rec.second_noa_cancel_or_correct;
1341: End If;
1342: If (p_rec.second_noa_code = hr_api.g_varchar2) then
1338: If (p_rec.second_noa_cancel_or_correct = hr_api.g_varchar2) then
1339: p_rec.second_noa_cancel_or_correct :=
1340: ghr_par_shd.g_old_rec.second_noa_cancel_or_correct;
1341: End If;
1342: If (p_rec.second_noa_code = hr_api.g_varchar2) then
1343: p_rec.second_noa_code :=
1344: ghr_par_shd.g_old_rec.second_noa_code;
1345: End If;
1346: If (p_rec.second_noa_desc = hr_api.g_varchar2) then
1342: If (p_rec.second_noa_code = hr_api.g_varchar2) then
1343: p_rec.second_noa_code :=
1344: ghr_par_shd.g_old_rec.second_noa_code;
1345: End If;
1346: If (p_rec.second_noa_desc = hr_api.g_varchar2) then
1347: p_rec.second_noa_desc :=
1348: ghr_par_shd.g_old_rec.second_noa_desc;
1349: End If;
1350: If (p_rec.second_noa_id = hr_api.g_number) then
1346: If (p_rec.second_noa_desc = hr_api.g_varchar2) then
1347: p_rec.second_noa_desc :=
1348: ghr_par_shd.g_old_rec.second_noa_desc;
1349: End If;
1350: If (p_rec.second_noa_id = hr_api.g_number) then
1351: p_rec.second_noa_id :=
1352: ghr_par_shd.g_old_rec.second_noa_id;
1353: End If;
1354: If (p_rec.second_noa_pa_request_id = hr_api.g_number) then
1350: If (p_rec.second_noa_id = hr_api.g_number) then
1351: p_rec.second_noa_id :=
1352: ghr_par_shd.g_old_rec.second_noa_id;
1353: End If;
1354: If (p_rec.second_noa_pa_request_id = hr_api.g_number) then
1355: p_rec.second_noa_pa_request_id :=
1356: ghr_par_shd.g_old_rec.second_noa_pa_request_id;
1357: End If;
1358: If (p_rec.service_comp_date = hr_api.g_date) then
1354: If (p_rec.second_noa_pa_request_id = hr_api.g_number) then
1355: p_rec.second_noa_pa_request_id :=
1356: ghr_par_shd.g_old_rec.second_noa_pa_request_id;
1357: End If;
1358: If (p_rec.service_comp_date = hr_api.g_date) then
1359: p_rec.service_comp_date :=
1360: ghr_par_shd.g_old_rec.service_comp_date;
1361: End If;
1362: If (p_rec.status = hr_api.g_varchar2) then
1358: If (p_rec.service_comp_date = hr_api.g_date) then
1359: p_rec.service_comp_date :=
1360: ghr_par_shd.g_old_rec.service_comp_date;
1361: End If;
1362: If (p_rec.status = hr_api.g_varchar2) then
1363: p_rec.status :=
1364: ghr_par_shd.g_old_rec.status;
1365: End If;
1366: If (p_rec.supervisory_status = hr_api.g_varchar2) then
1362: If (p_rec.status = hr_api.g_varchar2) then
1363: p_rec.status :=
1364: ghr_par_shd.g_old_rec.status;
1365: End If;
1366: If (p_rec.supervisory_status = hr_api.g_varchar2) then
1367: p_rec.supervisory_status :=
1368: ghr_par_shd.g_old_rec.supervisory_status;
1369: End If;
1370: If (p_rec.tenure = hr_api.g_varchar2) then
1366: If (p_rec.supervisory_status = hr_api.g_varchar2) then
1367: p_rec.supervisory_status :=
1368: ghr_par_shd.g_old_rec.supervisory_status;
1369: End If;
1370: If (p_rec.tenure = hr_api.g_varchar2) then
1371: p_rec.tenure :=
1372: ghr_par_shd.g_old_rec.tenure;
1373: End If;
1374: If (p_rec.to_adj_basic_pay = hr_api.g_number) then
1370: If (p_rec.tenure = hr_api.g_varchar2) then
1371: p_rec.tenure :=
1372: ghr_par_shd.g_old_rec.tenure;
1373: End If;
1374: If (p_rec.to_adj_basic_pay = hr_api.g_number) then
1375: p_rec.to_adj_basic_pay :=
1376: ghr_par_shd.g_old_rec.to_adj_basic_pay;
1377: End If;
1378: If (p_rec.to_basic_pay = hr_api.g_number) then
1374: If (p_rec.to_adj_basic_pay = hr_api.g_number) then
1375: p_rec.to_adj_basic_pay :=
1376: ghr_par_shd.g_old_rec.to_adj_basic_pay;
1377: End If;
1378: If (p_rec.to_basic_pay = hr_api.g_number) then
1379: p_rec.to_basic_pay :=
1380: ghr_par_shd.g_old_rec.to_basic_pay;
1381: End If;
1382: If (p_rec.to_grade_id = hr_api.g_number) then
1378: If (p_rec.to_basic_pay = hr_api.g_number) then
1379: p_rec.to_basic_pay :=
1380: ghr_par_shd.g_old_rec.to_basic_pay;
1381: End If;
1382: If (p_rec.to_grade_id = hr_api.g_number) then
1383: p_rec.to_grade_id :=
1384: ghr_par_shd.g_old_rec.to_grade_id;
1385: End If;
1386: If (p_rec.to_grade_or_level = hr_api.g_varchar2) then
1382: If (p_rec.to_grade_id = hr_api.g_number) then
1383: p_rec.to_grade_id :=
1384: ghr_par_shd.g_old_rec.to_grade_id;
1385: End If;
1386: If (p_rec.to_grade_or_level = hr_api.g_varchar2) then
1387: p_rec.to_grade_or_level :=
1388: ghr_par_shd.g_old_rec.to_grade_or_level;
1389: End If;
1390: If (p_rec.to_job_id = hr_api.g_number) then
1386: If (p_rec.to_grade_or_level = hr_api.g_varchar2) then
1387: p_rec.to_grade_or_level :=
1388: ghr_par_shd.g_old_rec.to_grade_or_level;
1389: End If;
1390: If (p_rec.to_job_id = hr_api.g_number) then
1391: p_rec.to_job_id :=
1392: ghr_par_shd.g_old_rec.to_job_id;
1393: End If;
1394: If (p_rec.to_locality_adj = hr_api.g_number) then
1390: If (p_rec.to_job_id = hr_api.g_number) then
1391: p_rec.to_job_id :=
1392: ghr_par_shd.g_old_rec.to_job_id;
1393: End If;
1394: If (p_rec.to_locality_adj = hr_api.g_number) then
1395: p_rec.to_locality_adj :=
1396: ghr_par_shd.g_old_rec.to_locality_adj;
1397: End If;
1398: If (p_rec.to_occ_code = hr_api.g_varchar2) then
1394: If (p_rec.to_locality_adj = hr_api.g_number) then
1395: p_rec.to_locality_adj :=
1396: ghr_par_shd.g_old_rec.to_locality_adj;
1397: End If;
1398: If (p_rec.to_occ_code = hr_api.g_varchar2) then
1399: p_rec.to_occ_code :=
1400: ghr_par_shd.g_old_rec.to_occ_code;
1401: End If;
1402: If (p_rec.to_office_symbol = hr_api.g_varchar2) then
1398: If (p_rec.to_occ_code = hr_api.g_varchar2) then
1399: p_rec.to_occ_code :=
1400: ghr_par_shd.g_old_rec.to_occ_code;
1401: End If;
1402: If (p_rec.to_office_symbol = hr_api.g_varchar2) then
1403: p_rec.to_office_symbol :=
1404: ghr_par_shd.g_old_rec.to_office_symbol;
1405: End If;
1406: If (p_rec.to_organization_id = hr_api.g_number) then
1402: If (p_rec.to_office_symbol = hr_api.g_varchar2) then
1403: p_rec.to_office_symbol :=
1404: ghr_par_shd.g_old_rec.to_office_symbol;
1405: End If;
1406: If (p_rec.to_organization_id = hr_api.g_number) then
1407: p_rec.to_organization_id :=
1408: ghr_par_shd.g_old_rec.to_organization_id;
1409: End If;
1410: If (p_rec.to_other_pay_amount = hr_api.g_number) then
1406: If (p_rec.to_organization_id = hr_api.g_number) then
1407: p_rec.to_organization_id :=
1408: ghr_par_shd.g_old_rec.to_organization_id;
1409: End If;
1410: If (p_rec.to_other_pay_amount = hr_api.g_number) then
1411: p_rec.to_other_pay_amount :=
1412: ghr_par_shd.g_old_rec.to_other_pay_amount;
1413: End If;
1414: If (p_rec.to_pay_basis = hr_api.g_varchar2) then
1410: If (p_rec.to_other_pay_amount = hr_api.g_number) then
1411: p_rec.to_other_pay_amount :=
1412: ghr_par_shd.g_old_rec.to_other_pay_amount;
1413: End If;
1414: If (p_rec.to_pay_basis = hr_api.g_varchar2) then
1415: p_rec.to_pay_basis :=
1416: ghr_par_shd.g_old_rec.to_pay_basis;
1417: End If;
1418: If (p_rec.to_pay_plan = hr_api.g_varchar2) then
1414: If (p_rec.to_pay_basis = hr_api.g_varchar2) then
1415: p_rec.to_pay_basis :=
1416: ghr_par_shd.g_old_rec.to_pay_basis;
1417: End If;
1418: If (p_rec.to_pay_plan = hr_api.g_varchar2) then
1419: p_rec.to_pay_plan :=
1420: ghr_par_shd.g_old_rec.to_pay_plan;
1421: End If;
1422: -- FWFA Changes Bug#4444609
1419: p_rec.to_pay_plan :=
1420: ghr_par_shd.g_old_rec.to_pay_plan;
1421: End If;
1422: -- FWFA Changes Bug#4444609
1423: If (p_rec.to_pay_table_identifier = hr_api.g_number) then
1424: p_rec.to_pay_table_identifier :=
1425: ghr_par_shd.g_old_rec.to_pay_table_identifier;
1426: End If;
1427: -- FWFA Changes
1424: p_rec.to_pay_table_identifier :=
1425: ghr_par_shd.g_old_rec.to_pay_table_identifier;
1426: End If;
1427: -- FWFA Changes
1428: If (p_rec.to_position_id = hr_api.g_number) then
1429: p_rec.to_position_id :=
1430: ghr_par_shd.g_old_rec.to_position_id;
1431: End If;
1432: If (p_rec.to_position_org_line1 = hr_api.g_varchar2) then
1428: If (p_rec.to_position_id = hr_api.g_number) then
1429: p_rec.to_position_id :=
1430: ghr_par_shd.g_old_rec.to_position_id;
1431: End If;
1432: If (p_rec.to_position_org_line1 = hr_api.g_varchar2) then
1433: p_rec.to_position_org_line1 :=
1434: ghr_par_shd.g_old_rec.to_position_org_line1;
1435: End If;
1436: If (p_rec.to_position_org_line2 = hr_api.g_varchar2) then
1432: If (p_rec.to_position_org_line1 = hr_api.g_varchar2) then
1433: p_rec.to_position_org_line1 :=
1434: ghr_par_shd.g_old_rec.to_position_org_line1;
1435: End If;
1436: If (p_rec.to_position_org_line2 = hr_api.g_varchar2) then
1437: p_rec.to_position_org_line2 :=
1438: ghr_par_shd.g_old_rec.to_position_org_line2;
1439: End If;
1440: If (p_rec.to_position_org_line3 = hr_api.g_varchar2) then
1436: If (p_rec.to_position_org_line2 = hr_api.g_varchar2) then
1437: p_rec.to_position_org_line2 :=
1438: ghr_par_shd.g_old_rec.to_position_org_line2;
1439: End If;
1440: If (p_rec.to_position_org_line3 = hr_api.g_varchar2) then
1441: p_rec.to_position_org_line3 :=
1442: ghr_par_shd.g_old_rec.to_position_org_line3;
1443: End If;
1444: If (p_rec.to_position_org_line4 = hr_api.g_varchar2) then
1440: If (p_rec.to_position_org_line3 = hr_api.g_varchar2) then
1441: p_rec.to_position_org_line3 :=
1442: ghr_par_shd.g_old_rec.to_position_org_line3;
1443: End If;
1444: If (p_rec.to_position_org_line4 = hr_api.g_varchar2) then
1445: p_rec.to_position_org_line4 :=
1446: ghr_par_shd.g_old_rec.to_position_org_line4;
1447: End If;
1448: If (p_rec.to_position_org_line5 = hr_api.g_varchar2) then
1444: If (p_rec.to_position_org_line4 = hr_api.g_varchar2) then
1445: p_rec.to_position_org_line4 :=
1446: ghr_par_shd.g_old_rec.to_position_org_line4;
1447: End If;
1448: If (p_rec.to_position_org_line5 = hr_api.g_varchar2) then
1449: p_rec.to_position_org_line5 :=
1450: ghr_par_shd.g_old_rec.to_position_org_line5;
1451: End If;
1452: If (p_rec.to_position_org_line6 = hr_api.g_varchar2) then
1448: If (p_rec.to_position_org_line5 = hr_api.g_varchar2) then
1449: p_rec.to_position_org_line5 :=
1450: ghr_par_shd.g_old_rec.to_position_org_line5;
1451: End If;
1452: If (p_rec.to_position_org_line6 = hr_api.g_varchar2) then
1453: p_rec.to_position_org_line6 :=
1454: ghr_par_shd.g_old_rec.to_position_org_line6;
1455: End If;
1456:
1453: p_rec.to_position_org_line6 :=
1454: ghr_par_shd.g_old_rec.to_position_org_line6;
1455: End If;
1456:
1457: If (p_rec.to_position_number = hr_api.g_varchar2) then
1458: p_rec.to_position_number :=
1459: ghr_par_shd.g_old_rec.to_position_number;
1460: End If;
1461: If (p_rec.to_position_seq_no = hr_api.g_number) then
1457: If (p_rec.to_position_number = hr_api.g_varchar2) then
1458: p_rec.to_position_number :=
1459: ghr_par_shd.g_old_rec.to_position_number;
1460: End If;
1461: If (p_rec.to_position_seq_no = hr_api.g_number) then
1462: p_rec.to_position_seq_no :=
1463: ghr_par_shd.g_old_rec.to_position_seq_no;
1464: End If;
1465: If (p_rec.to_position_title = hr_api.g_varchar2) then
1461: If (p_rec.to_position_seq_no = hr_api.g_number) then
1462: p_rec.to_position_seq_no :=
1463: ghr_par_shd.g_old_rec.to_position_seq_no;
1464: End If;
1465: If (p_rec.to_position_title = hr_api.g_varchar2) then
1466: p_rec.to_position_title :=
1467: ghr_par_shd.g_old_rec.to_position_title;
1468: End If;
1469: If (p_rec.to_step_or_rate = hr_api.g_varchar2) then
1465: If (p_rec.to_position_title = hr_api.g_varchar2) then
1466: p_rec.to_position_title :=
1467: ghr_par_shd.g_old_rec.to_position_title;
1468: End If;
1469: If (p_rec.to_step_or_rate = hr_api.g_varchar2) then
1470: p_rec.to_step_or_rate :=
1471: ghr_par_shd.g_old_rec.to_step_or_rate;
1472: End If;
1473:
1470: p_rec.to_step_or_rate :=
1471: ghr_par_shd.g_old_rec.to_step_or_rate;
1472: End If;
1473:
1474: If (p_rec.to_ap_premium_pay_indicator = hr_api.g_varchar2) then
1475: p_rec.to_ap_premium_pay_indicator :=
1476: ghr_par_shd.g_old_rec.to_ap_premium_pay_indicator;
1477: End If;
1478:
1475: p_rec.to_ap_premium_pay_indicator :=
1476: ghr_par_shd.g_old_rec.to_ap_premium_pay_indicator;
1477: End If;
1478:
1479: If (p_rec.to_auo_premium_pay_indicator = hr_api.g_varchar2) then
1480: p_rec.to_auo_premium_pay_indicator :=
1481: ghr_par_shd.g_old_rec.to_auo_premium_pay_indicator;
1482: End If;
1483:
1480: p_rec.to_auo_premium_pay_indicator :=
1481: ghr_par_shd.g_old_rec.to_auo_premium_pay_indicator;
1482: End If;
1483:
1484: If (p_rec.to_au_overtime = hr_api.g_number) then
1485: p_rec.to_au_overtime :=
1486: ghr_par_shd.g_old_rec.to_au_overtime ;
1487: End If;
1488:
1485: p_rec.to_au_overtime :=
1486: ghr_par_shd.g_old_rec.to_au_overtime ;
1487: End If;
1488:
1489: If (p_rec.to_availability_pay = hr_api.g_number) then
1490: p_rec.to_availability_pay :=
1491: ghr_par_shd.g_old_rec.to_availability_pay ;
1492: End If;
1493:
1490: p_rec.to_availability_pay :=
1491: ghr_par_shd.g_old_rec.to_availability_pay ;
1492: End If;
1493:
1494: If (p_rec.to_retention_allowance = hr_api.g_number) then
1495: p_rec.to_retention_allowance :=
1496: ghr_par_shd.g_old_rec.to_retention_allowance;
1497: End If;
1498:
1495: p_rec.to_retention_allowance :=
1496: ghr_par_shd.g_old_rec.to_retention_allowance;
1497: End If;
1498:
1499: If (p_rec.to_staffing_differential = hr_api.g_number) then
1500: p_rec.to_staffing_differential :=
1501: ghr_par_shd.g_old_rec.to_staffing_differential ;
1502: End If;
1503:
1500: p_rec.to_staffing_differential :=
1501: ghr_par_shd.g_old_rec.to_staffing_differential ;
1502: End If;
1503:
1504: If (p_rec.to_supervisory_differential = hr_api.g_number) then
1505: p_rec.to_supervisory_differential :=
1506: ghr_par_shd.g_old_rec.to_supervisory_differential ;
1507: End If;
1508:
1505: p_rec.to_supervisory_differential :=
1506: ghr_par_shd.g_old_rec.to_supervisory_differential ;
1507: End If;
1508:
1509: If (p_rec.to_total_salary = hr_api.g_number) then
1510: p_rec.to_total_salary :=
1511: ghr_par_shd.g_old_rec.to_total_salary;
1512: End If;
1513: If (p_rec.veterans_preference = hr_api.g_varchar2) then
1509: If (p_rec.to_total_salary = hr_api.g_number) then
1510: p_rec.to_total_salary :=
1511: ghr_par_shd.g_old_rec.to_total_salary;
1512: End If;
1513: If (p_rec.veterans_preference = hr_api.g_varchar2) then
1514: p_rec.veterans_preference :=
1515: ghr_par_shd.g_old_rec.veterans_preference;
1516: End If;
1517: If (p_rec.veterans_pref_for_rif = hr_api.g_varchar2) then
1513: If (p_rec.veterans_preference = hr_api.g_varchar2) then
1514: p_rec.veterans_preference :=
1515: ghr_par_shd.g_old_rec.veterans_preference;
1516: End If;
1517: If (p_rec.veterans_pref_for_rif = hr_api.g_varchar2) then
1518: p_rec.veterans_pref_for_rif :=
1519: ghr_par_shd.g_old_rec.veterans_pref_for_rif;
1520: End If;
1521: If (p_rec.veterans_status = hr_api.g_varchar2) then
1517: If (p_rec.veterans_pref_for_rif = hr_api.g_varchar2) then
1518: p_rec.veterans_pref_for_rif :=
1519: ghr_par_shd.g_old_rec.veterans_pref_for_rif;
1520: End If;
1521: If (p_rec.veterans_status = hr_api.g_varchar2) then
1522: p_rec.veterans_status :=
1523: ghr_par_shd.g_old_rec.veterans_status;
1524: End If;
1525: If (p_rec.work_schedule = hr_api.g_varchar2) then
1521: If (p_rec.veterans_status = hr_api.g_varchar2) then
1522: p_rec.veterans_status :=
1523: ghr_par_shd.g_old_rec.veterans_status;
1524: End If;
1525: If (p_rec.work_schedule = hr_api.g_varchar2) then
1526: p_rec.work_schedule :=
1527: ghr_par_shd.g_old_rec.work_schedule;
1528: End If;
1529: If (p_rec.work_schedule_desc = hr_api.g_varchar2) then
1525: If (p_rec.work_schedule = hr_api.g_varchar2) then
1526: p_rec.work_schedule :=
1527: ghr_par_shd.g_old_rec.work_schedule;
1528: End If;
1529: If (p_rec.work_schedule_desc = hr_api.g_varchar2) then
1530: p_rec.work_schedule_desc :=
1531: ghr_par_shd.g_old_rec.work_schedule_desc;
1532: End If;
1533: If (p_rec.year_degree_attained = hr_api.g_number) then
1529: If (p_rec.work_schedule_desc = hr_api.g_varchar2) then
1530: p_rec.work_schedule_desc :=
1531: ghr_par_shd.g_old_rec.work_schedule_desc;
1532: End If;
1533: If (p_rec.year_degree_attained = hr_api.g_number) then
1534: p_rec.year_degree_attained :=
1535: ghr_par_shd.g_old_rec.year_degree_attained;
1536: End If;
1537: If (p_rec.first_noa_information1 = hr_api.g_varchar2) then
1533: If (p_rec.year_degree_attained = hr_api.g_number) then
1534: p_rec.year_degree_attained :=
1535: ghr_par_shd.g_old_rec.year_degree_attained;
1536: End If;
1537: If (p_rec.first_noa_information1 = hr_api.g_varchar2) then
1538: p_rec.first_noa_information1 :=
1539: ghr_par_shd.g_old_rec.first_noa_information1;
1540: End If;
1541: If (p_rec.first_noa_information2 = hr_api.g_varchar2) then
1537: If (p_rec.first_noa_information1 = hr_api.g_varchar2) then
1538: p_rec.first_noa_information1 :=
1539: ghr_par_shd.g_old_rec.first_noa_information1;
1540: End If;
1541: If (p_rec.first_noa_information2 = hr_api.g_varchar2) then
1542: p_rec.first_noa_information2 :=
1543: ghr_par_shd.g_old_rec.first_noa_information2;
1544: End If;
1545: If (p_rec.first_noa_information3 = hr_api.g_varchar2) then
1541: If (p_rec.first_noa_information2 = hr_api.g_varchar2) then
1542: p_rec.first_noa_information2 :=
1543: ghr_par_shd.g_old_rec.first_noa_information2;
1544: End If;
1545: If (p_rec.first_noa_information3 = hr_api.g_varchar2) then
1546: p_rec.first_noa_information3 :=
1547: ghr_par_shd.g_old_rec.first_noa_information3;
1548: End If;
1549: If (p_rec.first_noa_information4 = hr_api.g_varchar2) then
1545: If (p_rec.first_noa_information3 = hr_api.g_varchar2) then
1546: p_rec.first_noa_information3 :=
1547: ghr_par_shd.g_old_rec.first_noa_information3;
1548: End If;
1549: If (p_rec.first_noa_information4 = hr_api.g_varchar2) then
1550: p_rec.first_noa_information4 :=
1551: ghr_par_shd.g_old_rec.first_noa_information4;
1552: End If;
1553: If (p_rec.first_noa_information5 = hr_api.g_varchar2) then
1549: If (p_rec.first_noa_information4 = hr_api.g_varchar2) then
1550: p_rec.first_noa_information4 :=
1551: ghr_par_shd.g_old_rec.first_noa_information4;
1552: End If;
1553: If (p_rec.first_noa_information5 = hr_api.g_varchar2) then
1554: p_rec.first_noa_information5 :=
1555: ghr_par_shd.g_old_rec.first_noa_information5;
1556: End If;
1557: If (p_rec.second_lac1_information1 = hr_api.g_varchar2) then
1553: If (p_rec.first_noa_information5 = hr_api.g_varchar2) then
1554: p_rec.first_noa_information5 :=
1555: ghr_par_shd.g_old_rec.first_noa_information5;
1556: End If;
1557: If (p_rec.second_lac1_information1 = hr_api.g_varchar2) then
1558: p_rec.second_lac1_information1 :=
1559: ghr_par_shd.g_old_rec.second_lac1_information1;
1560: End If;
1561: If (p_rec.second_lac1_information2 = hr_api.g_varchar2) then
1557: If (p_rec.second_lac1_information1 = hr_api.g_varchar2) then
1558: p_rec.second_lac1_information1 :=
1559: ghr_par_shd.g_old_rec.second_lac1_information1;
1560: End If;
1561: If (p_rec.second_lac1_information2 = hr_api.g_varchar2) then
1562: p_rec.second_lac1_information2 :=
1563: ghr_par_shd.g_old_rec.second_lac1_information2;
1564: End If;
1565: If (p_rec.second_lac1_information3 = hr_api.g_varchar2) then
1561: If (p_rec.second_lac1_information2 = hr_api.g_varchar2) then
1562: p_rec.second_lac1_information2 :=
1563: ghr_par_shd.g_old_rec.second_lac1_information2;
1564: End If;
1565: If (p_rec.second_lac1_information3 = hr_api.g_varchar2) then
1566: p_rec.second_lac1_information3 :=
1567: ghr_par_shd.g_old_rec.second_lac1_information3;
1568: End If;
1569: If (p_rec.second_lac1_information4 = hr_api.g_varchar2) then
1565: If (p_rec.second_lac1_information3 = hr_api.g_varchar2) then
1566: p_rec.second_lac1_information3 :=
1567: ghr_par_shd.g_old_rec.second_lac1_information3;
1568: End If;
1569: If (p_rec.second_lac1_information4 = hr_api.g_varchar2) then
1570: p_rec.second_lac1_information4 :=
1571: ghr_par_shd.g_old_rec.second_lac1_information4;
1572: End If;
1573: If (p_rec.second_lac1_information5 = hr_api.g_varchar2) then
1569: If (p_rec.second_lac1_information4 = hr_api.g_varchar2) then
1570: p_rec.second_lac1_information4 :=
1571: ghr_par_shd.g_old_rec.second_lac1_information4;
1572: End If;
1573: If (p_rec.second_lac1_information5 = hr_api.g_varchar2) then
1574: p_rec.second_lac1_information5 :=
1575: ghr_par_shd.g_old_rec.second_lac1_information5;
1576: End If;
1577: If (p_rec.second_lac2_information1 = hr_api.g_varchar2) then
1573: If (p_rec.second_lac1_information5 = hr_api.g_varchar2) then
1574: p_rec.second_lac1_information5 :=
1575: ghr_par_shd.g_old_rec.second_lac1_information5;
1576: End If;
1577: If (p_rec.second_lac2_information1 = hr_api.g_varchar2) then
1578: p_rec.second_lac2_information1 :=
1579: ghr_par_shd.g_old_rec.second_lac2_information1;
1580: End If;
1581: If (p_rec.second_lac2_information2 = hr_api.g_varchar2) then
1577: If (p_rec.second_lac2_information1 = hr_api.g_varchar2) then
1578: p_rec.second_lac2_information1 :=
1579: ghr_par_shd.g_old_rec.second_lac2_information1;
1580: End If;
1581: If (p_rec.second_lac2_information2 = hr_api.g_varchar2) then
1582: p_rec.second_lac2_information2 :=
1583: ghr_par_shd.g_old_rec.second_lac2_information2;
1584: End If;
1585: If (p_rec.second_lac2_information3 = hr_api.g_varchar2) then
1581: If (p_rec.second_lac2_information2 = hr_api.g_varchar2) then
1582: p_rec.second_lac2_information2 :=
1583: ghr_par_shd.g_old_rec.second_lac2_information2;
1584: End If;
1585: If (p_rec.second_lac2_information3 = hr_api.g_varchar2) then
1586: p_rec.second_lac2_information3 :=
1587: ghr_par_shd.g_old_rec.second_lac2_information3;
1588: End If;
1589: If (p_rec.second_lac2_information4 = hr_api.g_varchar2) then
1585: If (p_rec.second_lac2_information3 = hr_api.g_varchar2) then
1586: p_rec.second_lac2_information3 :=
1587: ghr_par_shd.g_old_rec.second_lac2_information3;
1588: End If;
1589: If (p_rec.second_lac2_information4 = hr_api.g_varchar2) then
1590: p_rec.second_lac2_information4 :=
1591: ghr_par_shd.g_old_rec.second_lac2_information4;
1592: End If;
1593: If (p_rec.second_lac2_information5 = hr_api.g_varchar2) then
1589: If (p_rec.second_lac2_information4 = hr_api.g_varchar2) then
1590: p_rec.second_lac2_information4 :=
1591: ghr_par_shd.g_old_rec.second_lac2_information4;
1592: End If;
1593: If (p_rec.second_lac2_information5 = hr_api.g_varchar2) then
1594: p_rec.second_lac2_information5 :=
1595: ghr_par_shd.g_old_rec.second_lac2_information5;
1596: End If;
1597: If (p_rec.second_noa_information1 = hr_api.g_varchar2) then
1593: If (p_rec.second_lac2_information5 = hr_api.g_varchar2) then
1594: p_rec.second_lac2_information5 :=
1595: ghr_par_shd.g_old_rec.second_lac2_information5;
1596: End If;
1597: If (p_rec.second_noa_information1 = hr_api.g_varchar2) then
1598: p_rec.second_noa_information1 :=
1599: ghr_par_shd.g_old_rec.second_noa_information1;
1600: End If;
1601: If (p_rec.second_noa_information2 = hr_api.g_varchar2) then
1597: If (p_rec.second_noa_information1 = hr_api.g_varchar2) then
1598: p_rec.second_noa_information1 :=
1599: ghr_par_shd.g_old_rec.second_noa_information1;
1600: End If;
1601: If (p_rec.second_noa_information2 = hr_api.g_varchar2) then
1602: p_rec.second_noa_information2 :=
1603: ghr_par_shd.g_old_rec.second_noa_information2;
1604: End If;
1605: If (p_rec.second_noa_information3 = hr_api.g_varchar2) then
1601: If (p_rec.second_noa_information2 = hr_api.g_varchar2) then
1602: p_rec.second_noa_information2 :=
1603: ghr_par_shd.g_old_rec.second_noa_information2;
1604: End If;
1605: If (p_rec.second_noa_information3 = hr_api.g_varchar2) then
1606: p_rec.second_noa_information3 :=
1607: ghr_par_shd.g_old_rec.second_noa_information3;
1608: End If;
1609: If (p_rec.second_noa_information4 = hr_api.g_varchar2) then
1605: If (p_rec.second_noa_information3 = hr_api.g_varchar2) then
1606: p_rec.second_noa_information3 :=
1607: ghr_par_shd.g_old_rec.second_noa_information3;
1608: End If;
1609: If (p_rec.second_noa_information4 = hr_api.g_varchar2) then
1610: p_rec.second_noa_information4 :=
1611: ghr_par_shd.g_old_rec.second_noa_information4;
1612: End If;
1613: If (p_rec.second_noa_information5 = hr_api.g_varchar2) then
1609: If (p_rec.second_noa_information4 = hr_api.g_varchar2) then
1610: p_rec.second_noa_information4 :=
1611: ghr_par_shd.g_old_rec.second_noa_information4;
1612: End If;
1613: If (p_rec.second_noa_information5 = hr_api.g_varchar2) then
1614: p_rec.second_noa_information5 :=
1615: ghr_par_shd.g_old_rec.second_noa_information5;
1616: End If;
1617: If (p_rec.first_lac1_information1 = hr_api.g_varchar2) then
1613: If (p_rec.second_noa_information5 = hr_api.g_varchar2) then
1614: p_rec.second_noa_information5 :=
1615: ghr_par_shd.g_old_rec.second_noa_information5;
1616: End If;
1617: If (p_rec.first_lac1_information1 = hr_api.g_varchar2) then
1618: p_rec.first_lac1_information1 :=
1619: ghr_par_shd.g_old_rec.first_lac1_information1;
1620: End If;
1621: If (p_rec.first_lac1_information2 = hr_api.g_varchar2) then
1617: If (p_rec.first_lac1_information1 = hr_api.g_varchar2) then
1618: p_rec.first_lac1_information1 :=
1619: ghr_par_shd.g_old_rec.first_lac1_information1;
1620: End If;
1621: If (p_rec.first_lac1_information2 = hr_api.g_varchar2) then
1622: p_rec.first_lac1_information2 :=
1623: ghr_par_shd.g_old_rec.first_lac1_information2;
1624: End If;
1625: If (p_rec.first_lac1_information3 = hr_api.g_varchar2) then
1621: If (p_rec.first_lac1_information2 = hr_api.g_varchar2) then
1622: p_rec.first_lac1_information2 :=
1623: ghr_par_shd.g_old_rec.first_lac1_information2;
1624: End If;
1625: If (p_rec.first_lac1_information3 = hr_api.g_varchar2) then
1626: p_rec.first_lac1_information3 :=
1627: ghr_par_shd.g_old_rec.first_lac1_information3;
1628: End If;
1629: If (p_rec.first_lac1_information4 = hr_api.g_varchar2) then
1625: If (p_rec.first_lac1_information3 = hr_api.g_varchar2) then
1626: p_rec.first_lac1_information3 :=
1627: ghr_par_shd.g_old_rec.first_lac1_information3;
1628: End If;
1629: If (p_rec.first_lac1_information4 = hr_api.g_varchar2) then
1630: p_rec.first_lac1_information4 :=
1631: ghr_par_shd.g_old_rec.first_lac1_information4;
1632: End If;
1633: If (p_rec.first_lac1_information5 = hr_api.g_varchar2) then
1629: If (p_rec.first_lac1_information4 = hr_api.g_varchar2) then
1630: p_rec.first_lac1_information4 :=
1631: ghr_par_shd.g_old_rec.first_lac1_information4;
1632: End If;
1633: If (p_rec.first_lac1_information5 = hr_api.g_varchar2) then
1634: p_rec.first_lac1_information5 :=
1635: ghr_par_shd.g_old_rec.first_lac1_information5;
1636: End If;
1637: If (p_rec.first_lac2_information1 = hr_api.g_varchar2) then
1633: If (p_rec.first_lac1_information5 = hr_api.g_varchar2) then
1634: p_rec.first_lac1_information5 :=
1635: ghr_par_shd.g_old_rec.first_lac1_information5;
1636: End If;
1637: If (p_rec.first_lac2_information1 = hr_api.g_varchar2) then
1638: p_rec.first_lac2_information1 :=
1639: ghr_par_shd.g_old_rec.first_lac2_information1;
1640: End If;
1641: If (p_rec.first_lac2_information2 = hr_api.g_varchar2) then
1637: If (p_rec.first_lac2_information1 = hr_api.g_varchar2) then
1638: p_rec.first_lac2_information1 :=
1639: ghr_par_shd.g_old_rec.first_lac2_information1;
1640: End If;
1641: If (p_rec.first_lac2_information2 = hr_api.g_varchar2) then
1642: p_rec.first_lac2_information2 :=
1643: ghr_par_shd.g_old_rec.first_lac2_information2;
1644: End If;
1645: If (p_rec.first_lac2_information3 = hr_api.g_varchar2) then
1641: If (p_rec.first_lac2_information2 = hr_api.g_varchar2) then
1642: p_rec.first_lac2_information2 :=
1643: ghr_par_shd.g_old_rec.first_lac2_information2;
1644: End If;
1645: If (p_rec.first_lac2_information3 = hr_api.g_varchar2) then
1646: p_rec.first_lac2_information3 :=
1647: ghr_par_shd.g_old_rec.first_lac2_information3;
1648: End If;
1649: If (p_rec.first_lac2_information4 = hr_api.g_varchar2) then
1645: If (p_rec.first_lac2_information3 = hr_api.g_varchar2) then
1646: p_rec.first_lac2_information3 :=
1647: ghr_par_shd.g_old_rec.first_lac2_information3;
1648: End If;
1649: If (p_rec.first_lac2_information4 = hr_api.g_varchar2) then
1650: p_rec.first_lac2_information4 :=
1651: ghr_par_shd.g_old_rec.first_lac2_information4;
1652: End If;
1653: If (p_rec.first_lac2_information5 = hr_api.g_varchar2) then
1649: If (p_rec.first_lac2_information4 = hr_api.g_varchar2) then
1650: p_rec.first_lac2_information4 :=
1651: ghr_par_shd.g_old_rec.first_lac2_information4;
1652: End If;
1653: If (p_rec.first_lac2_information5 = hr_api.g_varchar2) then
1654: p_rec.first_lac2_information5 :=
1655: ghr_par_shd.g_old_rec.first_lac2_information5;
1656: End If;
1657: If (p_rec.attribute_category = hr_api.g_varchar2) then
1653: If (p_rec.first_lac2_information5 = hr_api.g_varchar2) then
1654: p_rec.first_lac2_information5 :=
1655: ghr_par_shd.g_old_rec.first_lac2_information5;
1656: End If;
1657: If (p_rec.attribute_category = hr_api.g_varchar2) then
1658: p_rec.attribute_category :=
1659: ghr_par_shd.g_old_rec.attribute_category;
1660: End If;
1661: If (p_rec.attribute1 = hr_api.g_varchar2) then
1657: If (p_rec.attribute_category = hr_api.g_varchar2) then
1658: p_rec.attribute_category :=
1659: ghr_par_shd.g_old_rec.attribute_category;
1660: End If;
1661: If (p_rec.attribute1 = hr_api.g_varchar2) then
1662: p_rec.attribute1 :=
1663: ghr_par_shd.g_old_rec.attribute1;
1664: End If;
1665: If (p_rec.attribute2 = hr_api.g_varchar2) then
1661: If (p_rec.attribute1 = hr_api.g_varchar2) then
1662: p_rec.attribute1 :=
1663: ghr_par_shd.g_old_rec.attribute1;
1664: End If;
1665: If (p_rec.attribute2 = hr_api.g_varchar2) then
1666: p_rec.attribute2 :=
1667: ghr_par_shd.g_old_rec.attribute2;
1668: End If;
1669: If (p_rec.attribute3 = hr_api.g_varchar2) then
1665: If (p_rec.attribute2 = hr_api.g_varchar2) then
1666: p_rec.attribute2 :=
1667: ghr_par_shd.g_old_rec.attribute2;
1668: End If;
1669: If (p_rec.attribute3 = hr_api.g_varchar2) then
1670: p_rec.attribute3 :=
1671: ghr_par_shd.g_old_rec.attribute3;
1672: End If;
1673: If (p_rec.attribute4 = hr_api.g_varchar2) then
1669: If (p_rec.attribute3 = hr_api.g_varchar2) then
1670: p_rec.attribute3 :=
1671: ghr_par_shd.g_old_rec.attribute3;
1672: End If;
1673: If (p_rec.attribute4 = hr_api.g_varchar2) then
1674: p_rec.attribute4 :=
1675: ghr_par_shd.g_old_rec.attribute4;
1676: End If;
1677: If (p_rec.attribute5 = hr_api.g_varchar2) then
1673: If (p_rec.attribute4 = hr_api.g_varchar2) then
1674: p_rec.attribute4 :=
1675: ghr_par_shd.g_old_rec.attribute4;
1676: End If;
1677: If (p_rec.attribute5 = hr_api.g_varchar2) then
1678: p_rec.attribute5 :=
1679: ghr_par_shd.g_old_rec.attribute5;
1680: End If;
1681: If (p_rec.attribute6 = hr_api.g_varchar2) then
1677: If (p_rec.attribute5 = hr_api.g_varchar2) then
1678: p_rec.attribute5 :=
1679: ghr_par_shd.g_old_rec.attribute5;
1680: End If;
1681: If (p_rec.attribute6 = hr_api.g_varchar2) then
1682: p_rec.attribute6 :=
1683: ghr_par_shd.g_old_rec.attribute6;
1684: End If;
1685: If (p_rec.attribute7 = hr_api.g_varchar2) then
1681: If (p_rec.attribute6 = hr_api.g_varchar2) then
1682: p_rec.attribute6 :=
1683: ghr_par_shd.g_old_rec.attribute6;
1684: End If;
1685: If (p_rec.attribute7 = hr_api.g_varchar2) then
1686: p_rec.attribute7 :=
1687: ghr_par_shd.g_old_rec.attribute7;
1688: End If;
1689: If (p_rec.attribute8 = hr_api.g_varchar2) then
1685: If (p_rec.attribute7 = hr_api.g_varchar2) then
1686: p_rec.attribute7 :=
1687: ghr_par_shd.g_old_rec.attribute7;
1688: End If;
1689: If (p_rec.attribute8 = hr_api.g_varchar2) then
1690: p_rec.attribute8 :=
1691: ghr_par_shd.g_old_rec.attribute8;
1692: End If;
1693: If (p_rec.attribute9 = hr_api.g_varchar2) then
1689: If (p_rec.attribute8 = hr_api.g_varchar2) then
1690: p_rec.attribute8 :=
1691: ghr_par_shd.g_old_rec.attribute8;
1692: End If;
1693: If (p_rec.attribute9 = hr_api.g_varchar2) then
1694: p_rec.attribute9 :=
1695: ghr_par_shd.g_old_rec.attribute9;
1696: End If;
1697: If (p_rec.attribute10 = hr_api.g_varchar2) then
1693: If (p_rec.attribute9 = hr_api.g_varchar2) then
1694: p_rec.attribute9 :=
1695: ghr_par_shd.g_old_rec.attribute9;
1696: End If;
1697: If (p_rec.attribute10 = hr_api.g_varchar2) then
1698: p_rec.attribute10 :=
1699: ghr_par_shd.g_old_rec.attribute10;
1700: End If;
1701: If (p_rec.attribute11 = hr_api.g_varchar2) then
1697: If (p_rec.attribute10 = hr_api.g_varchar2) then
1698: p_rec.attribute10 :=
1699: ghr_par_shd.g_old_rec.attribute10;
1700: End If;
1701: If (p_rec.attribute11 = hr_api.g_varchar2) then
1702: p_rec.attribute11 :=
1703: ghr_par_shd.g_old_rec.attribute11;
1704: End If;
1705: If (p_rec.attribute12 = hr_api.g_varchar2) then
1701: If (p_rec.attribute11 = hr_api.g_varchar2) then
1702: p_rec.attribute11 :=
1703: ghr_par_shd.g_old_rec.attribute11;
1704: End If;
1705: If (p_rec.attribute12 = hr_api.g_varchar2) then
1706: p_rec.attribute12 :=
1707: ghr_par_shd.g_old_rec.attribute12;
1708: End If;
1709: If (p_rec.attribute13 = hr_api.g_varchar2) then
1705: If (p_rec.attribute12 = hr_api.g_varchar2) then
1706: p_rec.attribute12 :=
1707: ghr_par_shd.g_old_rec.attribute12;
1708: End If;
1709: If (p_rec.attribute13 = hr_api.g_varchar2) then
1710: p_rec.attribute13 :=
1711: ghr_par_shd.g_old_rec.attribute13;
1712: End If;
1713: If (p_rec.attribute14 = hr_api.g_varchar2) then
1709: If (p_rec.attribute13 = hr_api.g_varchar2) then
1710: p_rec.attribute13 :=
1711: ghr_par_shd.g_old_rec.attribute13;
1712: End If;
1713: If (p_rec.attribute14 = hr_api.g_varchar2) then
1714: p_rec.attribute14 :=
1715: ghr_par_shd.g_old_rec.attribute14;
1716: End If;
1717: If (p_rec.attribute15 = hr_api.g_varchar2) then
1713: If (p_rec.attribute14 = hr_api.g_varchar2) then
1714: p_rec.attribute14 :=
1715: ghr_par_shd.g_old_rec.attribute14;
1716: End If;
1717: If (p_rec.attribute15 = hr_api.g_varchar2) then
1718: p_rec.attribute15 :=
1719: ghr_par_shd.g_old_rec.attribute15;
1720: End If;
1721: If (p_rec.attribute16 = hr_api.g_varchar2) then
1717: If (p_rec.attribute15 = hr_api.g_varchar2) then
1718: p_rec.attribute15 :=
1719: ghr_par_shd.g_old_rec.attribute15;
1720: End If;
1721: If (p_rec.attribute16 = hr_api.g_varchar2) then
1722: p_rec.attribute16 :=
1723: ghr_par_shd.g_old_rec.attribute16;
1724: End If;
1725: If (p_rec.attribute17 = hr_api.g_varchar2) then
1721: If (p_rec.attribute16 = hr_api.g_varchar2) then
1722: p_rec.attribute16 :=
1723: ghr_par_shd.g_old_rec.attribute16;
1724: End If;
1725: If (p_rec.attribute17 = hr_api.g_varchar2) then
1726: p_rec.attribute17 :=
1727: ghr_par_shd.g_old_rec.attribute17;
1728: End If;
1729: If (p_rec.attribute18 = hr_api.g_varchar2) then
1725: If (p_rec.attribute17 = hr_api.g_varchar2) then
1726: p_rec.attribute17 :=
1727: ghr_par_shd.g_old_rec.attribute17;
1728: End If;
1729: If (p_rec.attribute18 = hr_api.g_varchar2) then
1730: p_rec.attribute18 :=
1731: ghr_par_shd.g_old_rec.attribute18;
1732: End If;
1733: If (p_rec.attribute19 = hr_api.g_varchar2) then
1729: If (p_rec.attribute18 = hr_api.g_varchar2) then
1730: p_rec.attribute18 :=
1731: ghr_par_shd.g_old_rec.attribute18;
1732: End If;
1733: If (p_rec.attribute19 = hr_api.g_varchar2) then
1734: p_rec.attribute19 :=
1735: ghr_par_shd.g_old_rec.attribute19;
1736: End If;
1737: If (p_rec.attribute20 = hr_api.g_varchar2) then
1733: If (p_rec.attribute19 = hr_api.g_varchar2) then
1734: p_rec.attribute19 :=
1735: ghr_par_shd.g_old_rec.attribute19;
1736: End If;
1737: If (p_rec.attribute20 = hr_api.g_varchar2) then
1738: p_rec.attribute20 :=
1739: ghr_par_shd.g_old_rec.attribute20;
1740: End If;
1741:
1738: p_rec.attribute20 :=
1739: ghr_par_shd.g_old_rec.attribute20;
1740: End If;
1741:
1742: If (p_rec.first_noa_canc_pa_request_id = hr_api.g_number) then
1743: p_rec.first_noa_canc_pa_request_id :=
1744: ghr_par_shd.g_old_rec.first_noa_canc_pa_request_id;
1745: End If;
1746: If (p_rec.second_noa_canc_pa_request_id = hr_api.g_number) then
1742: If (p_rec.first_noa_canc_pa_request_id = hr_api.g_number) then
1743: p_rec.first_noa_canc_pa_request_id :=
1744: ghr_par_shd.g_old_rec.first_noa_canc_pa_request_id;
1745: End If;
1746: If (p_rec.second_noa_canc_pa_request_id = hr_api.g_number) then
1747: p_rec.second_noa_canc_pa_request_id :=
1748: ghr_par_shd.g_old_rec.second_noa_canc_pa_request_id;
1749: End If;
1750: If (p_rec.to_retention_allow_percentage = hr_api.g_number) then
1746: If (p_rec.second_noa_canc_pa_request_id = hr_api.g_number) then
1747: p_rec.second_noa_canc_pa_request_id :=
1748: ghr_par_shd.g_old_rec.second_noa_canc_pa_request_id;
1749: End If;
1750: If (p_rec.to_retention_allow_percentage = hr_api.g_number) then
1751: p_rec.to_retention_allow_percentage :=
1752: ghr_par_shd.g_old_rec.to_retention_allow_percentage;
1753: End If;
1754: If (p_rec.to_supervisory_diff_percentage = hr_api.g_number) then
1750: If (p_rec.to_retention_allow_percentage = hr_api.g_number) then
1751: p_rec.to_retention_allow_percentage :=
1752: ghr_par_shd.g_old_rec.to_retention_allow_percentage;
1753: End If;
1754: If (p_rec.to_supervisory_diff_percentage = hr_api.g_number) then
1755: p_rec.to_supervisory_diff_percentage :=
1756: ghr_par_shd.g_old_rec.to_supervisory_diff_percentage;
1757: End If;
1758: If (p_rec.to_staffing_diff_percentage = hr_api.g_number) then
1754: If (p_rec.to_supervisory_diff_percentage = hr_api.g_number) then
1755: p_rec.to_supervisory_diff_percentage :=
1756: ghr_par_shd.g_old_rec.to_supervisory_diff_percentage;
1757: End If;
1758: If (p_rec.to_staffing_diff_percentage = hr_api.g_number) then
1759: p_rec.to_staffing_diff_percentage :=
1760: ghr_par_shd.g_old_rec.to_staffing_diff_percentage;
1761: End If;
1762: If (p_rec.award_percentage = hr_api.g_number) then
1758: If (p_rec.to_staffing_diff_percentage = hr_api.g_number) then
1759: p_rec.to_staffing_diff_percentage :=
1760: ghr_par_shd.g_old_rec.to_staffing_diff_percentage;
1761: End If;
1762: If (p_rec.award_percentage = hr_api.g_number) then
1763: p_rec.award_percentage :=
1764: ghr_par_shd.g_old_rec.award_percentage;
1765: End If;
1766: If (p_rec.rpa_type = hr_api.g_varchar2) then
1762: If (p_rec.award_percentage = hr_api.g_number) then
1763: p_rec.award_percentage :=
1764: ghr_par_shd.g_old_rec.award_percentage;
1765: End If;
1766: If (p_rec.rpa_type = hr_api.g_varchar2) then
1767: p_rec.rpa_type :=
1768: ghr_par_shd.g_old_rec.rpa_type;
1769: End If;
1770: If (p_rec.mass_action_id = hr_api.g_number) then
1766: If (p_rec.rpa_type = hr_api.g_varchar2) then
1767: p_rec.rpa_type :=
1768: ghr_par_shd.g_old_rec.rpa_type;
1769: End If;
1770: If (p_rec.mass_action_id = hr_api.g_number) then
1771: p_rec.mass_action_id :=
1772: ghr_par_shd.g_old_rec.mass_action_id;
1773: End If;
1774: If (p_rec.mass_action_eligible_flag = hr_api.g_varchar2) then
1770: If (p_rec.mass_action_id = hr_api.g_number) then
1771: p_rec.mass_action_id :=
1772: ghr_par_shd.g_old_rec.mass_action_id;
1773: End If;
1774: If (p_rec.mass_action_eligible_flag = hr_api.g_varchar2) then
1775: p_rec.mass_action_eligible_flag :=
1776: ghr_par_shd.g_old_rec.mass_action_eligible_flag;
1777: End If;
1778: If (p_rec.mass_action_select_flag = hr_api.g_varchar2) then
1774: If (p_rec.mass_action_eligible_flag = hr_api.g_varchar2) then
1775: p_rec.mass_action_eligible_flag :=
1776: ghr_par_shd.g_old_rec.mass_action_eligible_flag;
1777: End If;
1778: If (p_rec.mass_action_select_flag = hr_api.g_varchar2) then
1779: p_rec.mass_action_select_flag :=
1780: ghr_par_shd.g_old_rec.mass_action_select_flag;
1781: End If;
1782: If (p_rec.mass_action_comments = hr_api.g_varchar2) then
1778: If (p_rec.mass_action_select_flag = hr_api.g_varchar2) then
1779: p_rec.mass_action_select_flag :=
1780: ghr_par_shd.g_old_rec.mass_action_select_flag;
1781: End If;
1782: If (p_rec.mass_action_comments = hr_api.g_varchar2) then
1783: p_rec.mass_action_comments :=
1784: ghr_par_shd.g_old_rec.mass_action_comments;
1785: End If;
1786: -- Bug# RRR Changes
1783: p_rec.mass_action_comments :=
1784: ghr_par_shd.g_old_rec.mass_action_comments;
1785: End If;
1786: -- Bug# RRR Changes
1787: If (p_rec.payment_option = hr_api.g_varchar2) then
1788: p_rec.payment_option :=
1789: ghr_par_shd.g_old_rec.payment_option;
1790: End If;
1791: If (p_rec.award_salary = hr_api.g_number) then
1787: If (p_rec.payment_option = hr_api.g_varchar2) then
1788: p_rec.payment_option :=
1789: ghr_par_shd.g_old_rec.payment_option;
1790: End If;
1791: If (p_rec.award_salary = hr_api.g_number) then
1792: p_rec.award_salary :=
1793: ghr_par_shd.g_old_rec.award_salary;
1794: End If;
1795: -- Bug# RRR Changes
1847: -- ----------------------------------------------------------------------------
1848: Procedure upd
1849: (
1850: p_pa_request_id in number,
1851: p_pa_notification_id in number default hr_api.g_number,
1852: p_noa_family_code in varchar2 default hr_api.g_varchar2,
1853: p_routing_group_id in number default hr_api.g_number,
1854: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1855: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1848: Procedure upd
1849: (
1850: p_pa_request_id in number,
1851: p_pa_notification_id in number default hr_api.g_number,
1852: p_noa_family_code in varchar2 default hr_api.g_varchar2,
1853: p_routing_group_id in number default hr_api.g_number,
1854: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1855: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1856: p_additional_info_person_id in number default hr_api.g_number,
1849: (
1850: p_pa_request_id in number,
1851: p_pa_notification_id in number default hr_api.g_number,
1852: p_noa_family_code in varchar2 default hr_api.g_varchar2,
1853: p_routing_group_id in number default hr_api.g_number,
1854: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1855: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1856: p_additional_info_person_id in number default hr_api.g_number,
1857: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1850: p_pa_request_id in number,
1851: p_pa_notification_id in number default hr_api.g_number,
1852: p_noa_family_code in varchar2 default hr_api.g_varchar2,
1853: p_routing_group_id in number default hr_api.g_number,
1854: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1855: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1856: p_additional_info_person_id in number default hr_api.g_number,
1857: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1858: p_agency_code in varchar2 default hr_api.g_varchar2,
1851: p_pa_notification_id in number default hr_api.g_number,
1852: p_noa_family_code in varchar2 default hr_api.g_varchar2,
1853: p_routing_group_id in number default hr_api.g_number,
1854: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1855: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1856: p_additional_info_person_id in number default hr_api.g_number,
1857: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1858: p_agency_code in varchar2 default hr_api.g_varchar2,
1859: p_altered_pa_request_id in number default hr_api.g_number,
1852: p_noa_family_code in varchar2 default hr_api.g_varchar2,
1853: p_routing_group_id in number default hr_api.g_number,
1854: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1855: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1856: p_additional_info_person_id in number default hr_api.g_number,
1857: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1858: p_agency_code in varchar2 default hr_api.g_varchar2,
1859: p_altered_pa_request_id in number default hr_api.g_number,
1860: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1853: p_routing_group_id in number default hr_api.g_number,
1854: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1855: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1856: p_additional_info_person_id in number default hr_api.g_number,
1857: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1858: p_agency_code in varchar2 default hr_api.g_varchar2,
1859: p_altered_pa_request_id in number default hr_api.g_number,
1860: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1861: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1854: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1855: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1856: p_additional_info_person_id in number default hr_api.g_number,
1857: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1858: p_agency_code in varchar2 default hr_api.g_varchar2,
1859: p_altered_pa_request_id in number default hr_api.g_number,
1860: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1861: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1862: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1855: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1856: p_additional_info_person_id in number default hr_api.g_number,
1857: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1858: p_agency_code in varchar2 default hr_api.g_varchar2,
1859: p_altered_pa_request_id in number default hr_api.g_number,
1860: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1861: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1862: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1863: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1856: p_additional_info_person_id in number default hr_api.g_number,
1857: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1858: p_agency_code in varchar2 default hr_api.g_varchar2,
1859: p_altered_pa_request_id in number default hr_api.g_number,
1860: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1861: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1862: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1863: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1864: p_approval_date in date default hr_api.g_date,
1857: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1858: p_agency_code in varchar2 default hr_api.g_varchar2,
1859: p_altered_pa_request_id in number default hr_api.g_number,
1860: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1861: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1862: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1863: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1864: p_approval_date in date default hr_api.g_date,
1865: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1858: p_agency_code in varchar2 default hr_api.g_varchar2,
1859: p_altered_pa_request_id in number default hr_api.g_number,
1860: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1861: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1862: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1863: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1864: p_approval_date in date default hr_api.g_date,
1865: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1866: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1859: p_altered_pa_request_id in number default hr_api.g_number,
1860: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1861: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1862: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1863: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1864: p_approval_date in date default hr_api.g_date,
1865: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1866: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1867: p_sf50_approval_date in date default hr_api.g_date,
1860: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1861: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1862: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1863: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1864: p_approval_date in date default hr_api.g_date,
1865: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1866: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1867: p_sf50_approval_date in date default hr_api.g_date,
1868: p_sf50_approving_ofcl_full_nam in varchar2 default hr_api.g_varchar2,
1861: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1862: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1863: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1864: p_approval_date in date default hr_api.g_date,
1865: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1866: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1867: p_sf50_approval_date in date default hr_api.g_date,
1868: p_sf50_approving_ofcl_full_nam in varchar2 default hr_api.g_varchar2,
1869: p_sf50_approving_ofcl_work_tit in varchar2 default hr_api.g_varchar2,
1862: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1863: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1864: p_approval_date in date default hr_api.g_date,
1865: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1866: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1867: p_sf50_approval_date in date default hr_api.g_date,
1868: p_sf50_approving_ofcl_full_nam in varchar2 default hr_api.g_varchar2,
1869: p_sf50_approving_ofcl_work_tit in varchar2 default hr_api.g_varchar2,
1870: p_authorized_by_person_id in number default hr_api.g_number,
1863: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1864: p_approval_date in date default hr_api.g_date,
1865: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1866: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1867: p_sf50_approval_date in date default hr_api.g_date,
1868: p_sf50_approving_ofcl_full_nam in varchar2 default hr_api.g_varchar2,
1869: p_sf50_approving_ofcl_work_tit in varchar2 default hr_api.g_varchar2,
1870: p_authorized_by_person_id in number default hr_api.g_number,
1871: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1864: p_approval_date in date default hr_api.g_date,
1865: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1866: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1867: p_sf50_approval_date in date default hr_api.g_date,
1868: p_sf50_approving_ofcl_full_nam in varchar2 default hr_api.g_varchar2,
1869: p_sf50_approving_ofcl_work_tit in varchar2 default hr_api.g_varchar2,
1870: p_authorized_by_person_id in number default hr_api.g_number,
1871: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1872: p_award_amount in number default hr_api.g_number,
1865: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1866: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1867: p_sf50_approval_date in date default hr_api.g_date,
1868: p_sf50_approving_ofcl_full_nam in varchar2 default hr_api.g_varchar2,
1869: p_sf50_approving_ofcl_work_tit in varchar2 default hr_api.g_varchar2,
1870: p_authorized_by_person_id in number default hr_api.g_number,
1871: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1872: p_award_amount in number default hr_api.g_number,
1873: p_award_uom in varchar2 default hr_api.g_varchar2,
1866: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1867: p_sf50_approval_date in date default hr_api.g_date,
1868: p_sf50_approving_ofcl_full_nam in varchar2 default hr_api.g_varchar2,
1869: p_sf50_approving_ofcl_work_tit in varchar2 default hr_api.g_varchar2,
1870: p_authorized_by_person_id in number default hr_api.g_number,
1871: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1872: p_award_amount in number default hr_api.g_number,
1873: p_award_uom in varchar2 default hr_api.g_varchar2,
1874: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1867: p_sf50_approval_date in date default hr_api.g_date,
1868: p_sf50_approving_ofcl_full_nam in varchar2 default hr_api.g_varchar2,
1869: p_sf50_approving_ofcl_work_tit in varchar2 default hr_api.g_varchar2,
1870: p_authorized_by_person_id in number default hr_api.g_number,
1871: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1872: p_award_amount in number default hr_api.g_number,
1873: p_award_uom in varchar2 default hr_api.g_varchar2,
1874: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1875: p_citizenship in varchar2 default hr_api.g_varchar2,
1868: p_sf50_approving_ofcl_full_nam in varchar2 default hr_api.g_varchar2,
1869: p_sf50_approving_ofcl_work_tit in varchar2 default hr_api.g_varchar2,
1870: p_authorized_by_person_id in number default hr_api.g_number,
1871: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1872: p_award_amount in number default hr_api.g_number,
1873: p_award_uom in varchar2 default hr_api.g_varchar2,
1874: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1875: p_citizenship in varchar2 default hr_api.g_varchar2,
1876: p_concurrence_date in date default hr_api.g_date,
1869: p_sf50_approving_ofcl_work_tit in varchar2 default hr_api.g_varchar2,
1870: p_authorized_by_person_id in number default hr_api.g_number,
1871: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1872: p_award_amount in number default hr_api.g_number,
1873: p_award_uom in varchar2 default hr_api.g_varchar2,
1874: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1875: p_citizenship in varchar2 default hr_api.g_varchar2,
1876: p_concurrence_date in date default hr_api.g_date,
1877: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1870: p_authorized_by_person_id in number default hr_api.g_number,
1871: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1872: p_award_amount in number default hr_api.g_number,
1873: p_award_uom in varchar2 default hr_api.g_varchar2,
1874: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1875: p_citizenship in varchar2 default hr_api.g_varchar2,
1876: p_concurrence_date in date default hr_api.g_date,
1877: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1878: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1871: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1872: p_award_amount in number default hr_api.g_number,
1873: p_award_uom in varchar2 default hr_api.g_varchar2,
1874: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1875: p_citizenship in varchar2 default hr_api.g_varchar2,
1876: p_concurrence_date in date default hr_api.g_date,
1877: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1878: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1879: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1872: p_award_amount in number default hr_api.g_number,
1873: p_award_uom in varchar2 default hr_api.g_varchar2,
1874: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1875: p_citizenship in varchar2 default hr_api.g_varchar2,
1876: p_concurrence_date in date default hr_api.g_date,
1877: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1878: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1879: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1880: p_duty_station_id in number default hr_api.g_number,
1873: p_award_uom in varchar2 default hr_api.g_varchar2,
1874: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1875: p_citizenship in varchar2 default hr_api.g_varchar2,
1876: p_concurrence_date in date default hr_api.g_date,
1877: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1878: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1879: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1880: p_duty_station_id in number default hr_api.g_number,
1881: p_duty_station_location_id in number default hr_api.g_number,
1874: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1875: p_citizenship in varchar2 default hr_api.g_varchar2,
1876: p_concurrence_date in date default hr_api.g_date,
1877: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1878: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1879: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1880: p_duty_station_id in number default hr_api.g_number,
1881: p_duty_station_location_id in number default hr_api.g_number,
1882: p_education_level in varchar2 default hr_api.g_varchar2,
1875: p_citizenship in varchar2 default hr_api.g_varchar2,
1876: p_concurrence_date in date default hr_api.g_date,
1877: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1878: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1879: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1880: p_duty_station_id in number default hr_api.g_number,
1881: p_duty_station_location_id in number default hr_api.g_number,
1882: p_education_level in varchar2 default hr_api.g_varchar2,
1883: p_effective_date in date default hr_api.g_date,
1876: p_concurrence_date in date default hr_api.g_date,
1877: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1878: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1879: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1880: p_duty_station_id in number default hr_api.g_number,
1881: p_duty_station_location_id in number default hr_api.g_number,
1882: p_education_level in varchar2 default hr_api.g_varchar2,
1883: p_effective_date in date default hr_api.g_date,
1884: p_employee_assignment_id in number default hr_api.g_number,
1877: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1878: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1879: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1880: p_duty_station_id in number default hr_api.g_number,
1881: p_duty_station_location_id in number default hr_api.g_number,
1882: p_education_level in varchar2 default hr_api.g_varchar2,
1883: p_effective_date in date default hr_api.g_date,
1884: p_employee_assignment_id in number default hr_api.g_number,
1885: p_employee_date_of_birth in date default hr_api.g_date,
1878: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1879: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1880: p_duty_station_id in number default hr_api.g_number,
1881: p_duty_station_location_id in number default hr_api.g_number,
1882: p_education_level in varchar2 default hr_api.g_varchar2,
1883: p_effective_date in date default hr_api.g_date,
1884: p_employee_assignment_id in number default hr_api.g_number,
1885: p_employee_date_of_birth in date default hr_api.g_date,
1886: p_employee_dept_or_agency in varchar2 default hr_api.g_varchar2,
1879: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1880: p_duty_station_id in number default hr_api.g_number,
1881: p_duty_station_location_id in number default hr_api.g_number,
1882: p_education_level in varchar2 default hr_api.g_varchar2,
1883: p_effective_date in date default hr_api.g_date,
1884: p_employee_assignment_id in number default hr_api.g_number,
1885: p_employee_date_of_birth in date default hr_api.g_date,
1886: p_employee_dept_or_agency in varchar2 default hr_api.g_varchar2,
1887: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1880: p_duty_station_id in number default hr_api.g_number,
1881: p_duty_station_location_id in number default hr_api.g_number,
1882: p_education_level in varchar2 default hr_api.g_varchar2,
1883: p_effective_date in date default hr_api.g_date,
1884: p_employee_assignment_id in number default hr_api.g_number,
1885: p_employee_date_of_birth in date default hr_api.g_date,
1886: p_employee_dept_or_agency in varchar2 default hr_api.g_varchar2,
1887: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1888: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1881: p_duty_station_location_id in number default hr_api.g_number,
1882: p_education_level in varchar2 default hr_api.g_varchar2,
1883: p_effective_date in date default hr_api.g_date,
1884: p_employee_assignment_id in number default hr_api.g_number,
1885: p_employee_date_of_birth in date default hr_api.g_date,
1886: p_employee_dept_or_agency in varchar2 default hr_api.g_varchar2,
1887: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1888: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1889: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1882: p_education_level in varchar2 default hr_api.g_varchar2,
1883: p_effective_date in date default hr_api.g_date,
1884: p_employee_assignment_id in number default hr_api.g_number,
1885: p_employee_date_of_birth in date default hr_api.g_date,
1886: p_employee_dept_or_agency in varchar2 default hr_api.g_varchar2,
1887: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1888: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1889: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1890: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1883: p_effective_date in date default hr_api.g_date,
1884: p_employee_assignment_id in number default hr_api.g_number,
1885: p_employee_date_of_birth in date default hr_api.g_date,
1886: p_employee_dept_or_agency in varchar2 default hr_api.g_varchar2,
1887: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1888: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1889: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1890: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1891: p_fegli in varchar2 default hr_api.g_varchar2,
1884: p_employee_assignment_id in number default hr_api.g_number,
1885: p_employee_date_of_birth in date default hr_api.g_date,
1886: p_employee_dept_or_agency in varchar2 default hr_api.g_varchar2,
1887: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1888: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1889: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1890: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1891: p_fegli in varchar2 default hr_api.g_varchar2,
1892: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1885: p_employee_date_of_birth in date default hr_api.g_date,
1886: p_employee_dept_or_agency in varchar2 default hr_api.g_varchar2,
1887: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1888: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1889: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1890: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1891: p_fegli in varchar2 default hr_api.g_varchar2,
1892: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1893: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1886: p_employee_dept_or_agency in varchar2 default hr_api.g_varchar2,
1887: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1888: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1889: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1890: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1891: p_fegli in varchar2 default hr_api.g_varchar2,
1892: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1893: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1894: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1887: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1888: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1889: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1890: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1891: p_fegli in varchar2 default hr_api.g_varchar2,
1892: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1893: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1894: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1895: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1888: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1889: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1890: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1891: p_fegli in varchar2 default hr_api.g_varchar2,
1892: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1893: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1894: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1895: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1896: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1889: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1890: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1891: p_fegli in varchar2 default hr_api.g_varchar2,
1892: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1893: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1894: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1895: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1896: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1897: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1890: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1891: p_fegli in varchar2 default hr_api.g_varchar2,
1892: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1893: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1894: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1895: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1896: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1897: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1898: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1891: p_fegli in varchar2 default hr_api.g_varchar2,
1892: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1893: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1894: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1895: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1896: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1897: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1898: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1899: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1892: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1893: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1894: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1895: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1896: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1897: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1898: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1899: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1900: p_first_noa_id in number default hr_api.g_number,
1893: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1894: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1895: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1896: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1897: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1898: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1899: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1900: p_first_noa_id in number default hr_api.g_number,
1901: p_first_noa_pa_request_id in number default hr_api.g_number,
1894: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1895: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1896: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1897: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1898: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1899: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1900: p_first_noa_id in number default hr_api.g_number,
1901: p_first_noa_pa_request_id in number default hr_api.g_number,
1902: p_flsa_category in varchar2 default hr_api.g_varchar2,
1895: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1896: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1897: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1898: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1899: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1900: p_first_noa_id in number default hr_api.g_number,
1901: p_first_noa_pa_request_id in number default hr_api.g_number,
1902: p_flsa_category in varchar2 default hr_api.g_varchar2,
1903: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1896: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1897: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1898: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1899: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1900: p_first_noa_id in number default hr_api.g_number,
1901: p_first_noa_pa_request_id in number default hr_api.g_number,
1902: p_flsa_category in varchar2 default hr_api.g_varchar2,
1903: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1904: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1897: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1898: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1899: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1900: p_first_noa_id in number default hr_api.g_number,
1901: p_first_noa_pa_request_id in number default hr_api.g_number,
1902: p_flsa_category in varchar2 default hr_api.g_varchar2,
1903: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1904: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1905: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1898: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1899: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1900: p_first_noa_id in number default hr_api.g_number,
1901: p_first_noa_pa_request_id in number default hr_api.g_number,
1902: p_flsa_category in varchar2 default hr_api.g_varchar2,
1903: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1904: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1905: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1906: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1899: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1900: p_first_noa_id in number default hr_api.g_number,
1901: p_first_noa_pa_request_id in number default hr_api.g_number,
1902: p_flsa_category in varchar2 default hr_api.g_varchar2,
1903: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1904: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1905: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1906: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1907: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1900: p_first_noa_id in number default hr_api.g_number,
1901: p_first_noa_pa_request_id in number default hr_api.g_number,
1902: p_flsa_category in varchar2 default hr_api.g_varchar2,
1903: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1904: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1905: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1906: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1907: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1908: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1901: p_first_noa_pa_request_id in number default hr_api.g_number,
1902: p_flsa_category in varchar2 default hr_api.g_varchar2,
1903: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1904: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1905: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1906: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1907: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1908: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1909: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1902: p_flsa_category in varchar2 default hr_api.g_varchar2,
1903: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1904: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1905: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1906: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1907: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1908: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1909: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1910: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1903: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1904: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1905: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1906: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1907: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1908: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1909: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1910: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1911: p_from_adj_basic_pay in number default hr_api.g_number,
1904: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1905: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1906: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1907: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1908: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1909: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1910: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1911: p_from_adj_basic_pay in number default hr_api.g_number,
1912: p_from_agency_code in varchar2 default hr_api.g_varchar2,
1905: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1906: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1907: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1908: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1909: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1910: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1911: p_from_adj_basic_pay in number default hr_api.g_number,
1912: p_from_agency_code in varchar2 default hr_api.g_varchar2,
1913: p_from_agency_desc in varchar2 default hr_api.g_varchar2,
1906: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1907: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1908: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1909: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1910: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1911: p_from_adj_basic_pay in number default hr_api.g_number,
1912: p_from_agency_code in varchar2 default hr_api.g_varchar2,
1913: p_from_agency_desc in varchar2 default hr_api.g_varchar2,
1914: p_from_basic_pay in number default hr_api.g_number,
1907: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1908: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1909: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1910: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1911: p_from_adj_basic_pay in number default hr_api.g_number,
1912: p_from_agency_code in varchar2 default hr_api.g_varchar2,
1913: p_from_agency_desc in varchar2 default hr_api.g_varchar2,
1914: p_from_basic_pay in number default hr_api.g_number,
1915: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1908: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1909: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1910: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1911: p_from_adj_basic_pay in number default hr_api.g_number,
1912: p_from_agency_code in varchar2 default hr_api.g_varchar2,
1913: p_from_agency_desc in varchar2 default hr_api.g_varchar2,
1914: p_from_basic_pay in number default hr_api.g_number,
1915: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1916: p_from_locality_adj in number default hr_api.g_number,
1909: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1910: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1911: p_from_adj_basic_pay in number default hr_api.g_number,
1912: p_from_agency_code in varchar2 default hr_api.g_varchar2,
1913: p_from_agency_desc in varchar2 default hr_api.g_varchar2,
1914: p_from_basic_pay in number default hr_api.g_number,
1915: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1916: p_from_locality_adj in number default hr_api.g_number,
1917: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1910: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1911: p_from_adj_basic_pay in number default hr_api.g_number,
1912: p_from_agency_code in varchar2 default hr_api.g_varchar2,
1913: p_from_agency_desc in varchar2 default hr_api.g_varchar2,
1914: p_from_basic_pay in number default hr_api.g_number,
1915: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1916: p_from_locality_adj in number default hr_api.g_number,
1917: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1918: p_from_office_symbol in varchar2 default hr_api.g_varchar2,
1911: p_from_adj_basic_pay in number default hr_api.g_number,
1912: p_from_agency_code in varchar2 default hr_api.g_varchar2,
1913: p_from_agency_desc in varchar2 default hr_api.g_varchar2,
1914: p_from_basic_pay in number default hr_api.g_number,
1915: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1916: p_from_locality_adj in number default hr_api.g_number,
1917: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1918: p_from_office_symbol in varchar2 default hr_api.g_varchar2,
1919: p_from_other_pay_amount in number default hr_api.g_number,
1912: p_from_agency_code in varchar2 default hr_api.g_varchar2,
1913: p_from_agency_desc in varchar2 default hr_api.g_varchar2,
1914: p_from_basic_pay in number default hr_api.g_number,
1915: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1916: p_from_locality_adj in number default hr_api.g_number,
1917: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1918: p_from_office_symbol in varchar2 default hr_api.g_varchar2,
1919: p_from_other_pay_amount in number default hr_api.g_number,
1920: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1913: p_from_agency_desc in varchar2 default hr_api.g_varchar2,
1914: p_from_basic_pay in number default hr_api.g_number,
1915: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1916: p_from_locality_adj in number default hr_api.g_number,
1917: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1918: p_from_office_symbol in varchar2 default hr_api.g_varchar2,
1919: p_from_other_pay_amount in number default hr_api.g_number,
1920: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1921: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1914: p_from_basic_pay in number default hr_api.g_number,
1915: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1916: p_from_locality_adj in number default hr_api.g_number,
1917: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1918: p_from_office_symbol in varchar2 default hr_api.g_varchar2,
1919: p_from_other_pay_amount in number default hr_api.g_number,
1920: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1921: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1922: -- FWFA Changes Bug#4444609
1915: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1916: p_from_locality_adj in number default hr_api.g_number,
1917: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1918: p_from_office_symbol in varchar2 default hr_api.g_varchar2,
1919: p_from_other_pay_amount in number default hr_api.g_number,
1920: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1921: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1922: -- FWFA Changes Bug#4444609
1923: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1916: p_from_locality_adj in number default hr_api.g_number,
1917: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1918: p_from_office_symbol in varchar2 default hr_api.g_varchar2,
1919: p_from_other_pay_amount in number default hr_api.g_number,
1920: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1921: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1922: -- FWFA Changes Bug#4444609
1923: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1924: p_from_pay_table_identifier in number default hr_api.g_number,
1917: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1918: p_from_office_symbol in varchar2 default hr_api.g_varchar2,
1919: p_from_other_pay_amount in number default hr_api.g_number,
1920: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1921: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1922: -- FWFA Changes Bug#4444609
1923: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1924: p_from_pay_table_identifier in number default hr_api.g_number,
1925: -- FWFA Changes
1919: p_from_other_pay_amount in number default hr_api.g_number,
1920: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1921: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1922: -- FWFA Changes Bug#4444609
1923: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1924: p_from_pay_table_identifier in number default hr_api.g_number,
1925: -- FWFA Changes
1926: p_from_position_id in number default hr_api.g_number,
1927: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1920: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1921: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1922: -- FWFA Changes Bug#4444609
1923: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1924: p_from_pay_table_identifier in number default hr_api.g_number,
1925: -- FWFA Changes
1926: p_from_position_id in number default hr_api.g_number,
1927: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1928: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1922: -- FWFA Changes Bug#4444609
1923: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1924: p_from_pay_table_identifier in number default hr_api.g_number,
1925: -- FWFA Changes
1926: p_from_position_id in number default hr_api.g_number,
1927: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1928: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1929: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1930: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
1923: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1924: p_from_pay_table_identifier in number default hr_api.g_number,
1925: -- FWFA Changes
1926: p_from_position_id in number default hr_api.g_number,
1927: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1928: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1929: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1930: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
1931: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
1924: p_from_pay_table_identifier in number default hr_api.g_number,
1925: -- FWFA Changes
1926: p_from_position_id in number default hr_api.g_number,
1927: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1928: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1929: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1930: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
1931: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
1932: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
1925: -- FWFA Changes
1926: p_from_position_id in number default hr_api.g_number,
1927: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1928: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1929: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1930: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
1931: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
1932: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
1933: p_from_position_number in varchar2 default hr_api.g_varchar2,
1926: p_from_position_id in number default hr_api.g_number,
1927: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1928: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1929: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1930: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
1931: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
1932: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
1933: p_from_position_number in varchar2 default hr_api.g_varchar2,
1934: p_from_position_seq_no in number default hr_api.g_number,
1927: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1928: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1929: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1930: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
1931: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
1932: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
1933: p_from_position_number in varchar2 default hr_api.g_varchar2,
1934: p_from_position_seq_no in number default hr_api.g_number,
1935: p_from_position_title in varchar2 default hr_api.g_varchar2,
1928: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1929: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1930: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
1931: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
1932: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
1933: p_from_position_number in varchar2 default hr_api.g_varchar2,
1934: p_from_position_seq_no in number default hr_api.g_number,
1935: p_from_position_title in varchar2 default hr_api.g_varchar2,
1936: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
1929: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1930: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
1931: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
1932: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
1933: p_from_position_number in varchar2 default hr_api.g_varchar2,
1934: p_from_position_seq_no in number default hr_api.g_number,
1935: p_from_position_title in varchar2 default hr_api.g_varchar2,
1936: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
1937: p_from_total_salary in number default hr_api.g_number,
1930: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
1931: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
1932: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
1933: p_from_position_number in varchar2 default hr_api.g_varchar2,
1934: p_from_position_seq_no in number default hr_api.g_number,
1935: p_from_position_title in varchar2 default hr_api.g_varchar2,
1936: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
1937: p_from_total_salary in number default hr_api.g_number,
1938: p_functional_class in varchar2 default hr_api.g_varchar2,
1931: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
1932: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
1933: p_from_position_number in varchar2 default hr_api.g_varchar2,
1934: p_from_position_seq_no in number default hr_api.g_number,
1935: p_from_position_title in varchar2 default hr_api.g_varchar2,
1936: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
1937: p_from_total_salary in number default hr_api.g_number,
1938: p_functional_class in varchar2 default hr_api.g_varchar2,
1939: p_notepad in varchar2 default hr_api.g_varchar2,
1932: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
1933: p_from_position_number in varchar2 default hr_api.g_varchar2,
1934: p_from_position_seq_no in number default hr_api.g_number,
1935: p_from_position_title in varchar2 default hr_api.g_varchar2,
1936: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
1937: p_from_total_salary in number default hr_api.g_number,
1938: p_functional_class in varchar2 default hr_api.g_varchar2,
1939: p_notepad in varchar2 default hr_api.g_varchar2,
1940: p_part_time_hours in number default hr_api.g_number,
1933: p_from_position_number in varchar2 default hr_api.g_varchar2,
1934: p_from_position_seq_no in number default hr_api.g_number,
1935: p_from_position_title in varchar2 default hr_api.g_varchar2,
1936: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
1937: p_from_total_salary in number default hr_api.g_number,
1938: p_functional_class in varchar2 default hr_api.g_varchar2,
1939: p_notepad in varchar2 default hr_api.g_varchar2,
1940: p_part_time_hours in number default hr_api.g_number,
1941: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1934: p_from_position_seq_no in number default hr_api.g_number,
1935: p_from_position_title in varchar2 default hr_api.g_varchar2,
1936: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
1937: p_from_total_salary in number default hr_api.g_number,
1938: p_functional_class in varchar2 default hr_api.g_varchar2,
1939: p_notepad in varchar2 default hr_api.g_varchar2,
1940: p_part_time_hours in number default hr_api.g_number,
1941: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1942: p_personnel_office_id in varchar2 default hr_api.g_varchar2,
1935: p_from_position_title in varchar2 default hr_api.g_varchar2,
1936: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
1937: p_from_total_salary in number default hr_api.g_number,
1938: p_functional_class in varchar2 default hr_api.g_varchar2,
1939: p_notepad in varchar2 default hr_api.g_varchar2,
1940: p_part_time_hours in number default hr_api.g_number,
1941: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1942: p_personnel_office_id in varchar2 default hr_api.g_varchar2,
1943: p_person_id in number default hr_api.g_number,
1936: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
1937: p_from_total_salary in number default hr_api.g_number,
1938: p_functional_class in varchar2 default hr_api.g_varchar2,
1939: p_notepad in varchar2 default hr_api.g_varchar2,
1940: p_part_time_hours in number default hr_api.g_number,
1941: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1942: p_personnel_office_id in varchar2 default hr_api.g_varchar2,
1943: p_person_id in number default hr_api.g_number,
1944: p_position_occupied in varchar2 default hr_api.g_varchar2,
1937: p_from_total_salary in number default hr_api.g_number,
1938: p_functional_class in varchar2 default hr_api.g_varchar2,
1939: p_notepad in varchar2 default hr_api.g_varchar2,
1940: p_part_time_hours in number default hr_api.g_number,
1941: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1942: p_personnel_office_id in varchar2 default hr_api.g_varchar2,
1943: p_person_id in number default hr_api.g_number,
1944: p_position_occupied in varchar2 default hr_api.g_varchar2,
1945: p_proposed_effective_date in date default hr_api.g_date,
1938: p_functional_class in varchar2 default hr_api.g_varchar2,
1939: p_notepad in varchar2 default hr_api.g_varchar2,
1940: p_part_time_hours in number default hr_api.g_number,
1941: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1942: p_personnel_office_id in varchar2 default hr_api.g_varchar2,
1943: p_person_id in number default hr_api.g_number,
1944: p_position_occupied in varchar2 default hr_api.g_varchar2,
1945: p_proposed_effective_date in date default hr_api.g_date,
1946: p_requested_by_person_id in number default hr_api.g_number,
1939: p_notepad in varchar2 default hr_api.g_varchar2,
1940: p_part_time_hours in number default hr_api.g_number,
1941: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1942: p_personnel_office_id in varchar2 default hr_api.g_varchar2,
1943: p_person_id in number default hr_api.g_number,
1944: p_position_occupied in varchar2 default hr_api.g_varchar2,
1945: p_proposed_effective_date in date default hr_api.g_date,
1946: p_requested_by_person_id in number default hr_api.g_number,
1947: p_requested_by_title in varchar2 default hr_api.g_varchar2,
1940: p_part_time_hours in number default hr_api.g_number,
1941: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1942: p_personnel_office_id in varchar2 default hr_api.g_varchar2,
1943: p_person_id in number default hr_api.g_number,
1944: p_position_occupied in varchar2 default hr_api.g_varchar2,
1945: p_proposed_effective_date in date default hr_api.g_date,
1946: p_requested_by_person_id in number default hr_api.g_number,
1947: p_requested_by_title in varchar2 default hr_api.g_varchar2,
1948: p_requested_date in date default hr_api.g_date,
1941: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1942: p_personnel_office_id in varchar2 default hr_api.g_varchar2,
1943: p_person_id in number default hr_api.g_number,
1944: p_position_occupied in varchar2 default hr_api.g_varchar2,
1945: p_proposed_effective_date in date default hr_api.g_date,
1946: p_requested_by_person_id in number default hr_api.g_number,
1947: p_requested_by_title in varchar2 default hr_api.g_varchar2,
1948: p_requested_date in date default hr_api.g_date,
1949: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
1942: p_personnel_office_id in varchar2 default hr_api.g_varchar2,
1943: p_person_id in number default hr_api.g_number,
1944: p_position_occupied in varchar2 default hr_api.g_varchar2,
1945: p_proposed_effective_date in date default hr_api.g_date,
1946: p_requested_by_person_id in number default hr_api.g_number,
1947: p_requested_by_title in varchar2 default hr_api.g_varchar2,
1948: p_requested_date in date default hr_api.g_date,
1949: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
1950: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
1943: p_person_id in number default hr_api.g_number,
1944: p_position_occupied in varchar2 default hr_api.g_varchar2,
1945: p_proposed_effective_date in date default hr_api.g_date,
1946: p_requested_by_person_id in number default hr_api.g_number,
1947: p_requested_by_title in varchar2 default hr_api.g_varchar2,
1948: p_requested_date in date default hr_api.g_date,
1949: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
1950: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
1951: p_request_number in varchar2 default hr_api.g_varchar2,
1944: p_position_occupied in varchar2 default hr_api.g_varchar2,
1945: p_proposed_effective_date in date default hr_api.g_date,
1946: p_requested_by_person_id in number default hr_api.g_number,
1947: p_requested_by_title in varchar2 default hr_api.g_varchar2,
1948: p_requested_date in date default hr_api.g_date,
1949: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
1950: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
1951: p_request_number in varchar2 default hr_api.g_varchar2,
1952: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
1945: p_proposed_effective_date in date default hr_api.g_date,
1946: p_requested_by_person_id in number default hr_api.g_number,
1947: p_requested_by_title in varchar2 default hr_api.g_varchar2,
1948: p_requested_date in date default hr_api.g_date,
1949: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
1950: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
1951: p_request_number in varchar2 default hr_api.g_varchar2,
1952: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
1953: p_retirement_plan in varchar2 default hr_api.g_varchar2,
1946: p_requested_by_person_id in number default hr_api.g_number,
1947: p_requested_by_title in varchar2 default hr_api.g_varchar2,
1948: p_requested_date in date default hr_api.g_date,
1949: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
1950: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
1951: p_request_number in varchar2 default hr_api.g_varchar2,
1952: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
1953: p_retirement_plan in varchar2 default hr_api.g_varchar2,
1954: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
1947: p_requested_by_title in varchar2 default hr_api.g_varchar2,
1948: p_requested_date in date default hr_api.g_date,
1949: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
1950: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
1951: p_request_number in varchar2 default hr_api.g_varchar2,
1952: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
1953: p_retirement_plan in varchar2 default hr_api.g_varchar2,
1954: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
1955: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
1948: p_requested_date in date default hr_api.g_date,
1949: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
1950: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
1951: p_request_number in varchar2 default hr_api.g_varchar2,
1952: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
1953: p_retirement_plan in varchar2 default hr_api.g_varchar2,
1954: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
1955: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
1956: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
1949: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
1950: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
1951: p_request_number in varchar2 default hr_api.g_varchar2,
1952: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
1953: p_retirement_plan in varchar2 default hr_api.g_varchar2,
1954: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
1955: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
1956: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
1957: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1950: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
1951: p_request_number in varchar2 default hr_api.g_varchar2,
1952: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
1953: p_retirement_plan in varchar2 default hr_api.g_varchar2,
1954: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
1955: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
1956: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
1957: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1958: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1951: p_request_number in varchar2 default hr_api.g_varchar2,
1952: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
1953: p_retirement_plan in varchar2 default hr_api.g_varchar2,
1954: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
1955: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
1956: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
1957: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1958: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1959: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1952: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
1953: p_retirement_plan in varchar2 default hr_api.g_varchar2,
1954: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
1955: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
1956: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
1957: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1958: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1959: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1960: p_second_noa_code in varchar2 default hr_api.g_varchar2,
1953: p_retirement_plan in varchar2 default hr_api.g_varchar2,
1954: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
1955: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
1956: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
1957: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1958: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1959: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1960: p_second_noa_code in varchar2 default hr_api.g_varchar2,
1961: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
1954: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
1955: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
1956: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
1957: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1958: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1959: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1960: p_second_noa_code in varchar2 default hr_api.g_varchar2,
1961: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
1962: p_second_noa_id in number default hr_api.g_number,
1955: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
1956: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
1957: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1958: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1959: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1960: p_second_noa_code in varchar2 default hr_api.g_varchar2,
1961: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
1962: p_second_noa_id in number default hr_api.g_number,
1963: p_second_noa_pa_request_id in number default hr_api.g_number,
1956: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
1957: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1958: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1959: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1960: p_second_noa_code in varchar2 default hr_api.g_varchar2,
1961: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
1962: p_second_noa_id in number default hr_api.g_number,
1963: p_second_noa_pa_request_id in number default hr_api.g_number,
1964: p_service_comp_date in date default hr_api.g_date,
1957: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1958: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1959: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1960: p_second_noa_code in varchar2 default hr_api.g_varchar2,
1961: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
1962: p_second_noa_id in number default hr_api.g_number,
1963: p_second_noa_pa_request_id in number default hr_api.g_number,
1964: p_service_comp_date in date default hr_api.g_date,
1965: p_status in varchar2 default hr_api.g_varchar2,
1958: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1959: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1960: p_second_noa_code in varchar2 default hr_api.g_varchar2,
1961: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
1962: p_second_noa_id in number default hr_api.g_number,
1963: p_second_noa_pa_request_id in number default hr_api.g_number,
1964: p_service_comp_date in date default hr_api.g_date,
1965: p_status in varchar2 default hr_api.g_varchar2,
1966: p_supervisory_status in varchar2 default hr_api.g_varchar2,
1959: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1960: p_second_noa_code in varchar2 default hr_api.g_varchar2,
1961: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
1962: p_second_noa_id in number default hr_api.g_number,
1963: p_second_noa_pa_request_id in number default hr_api.g_number,
1964: p_service_comp_date in date default hr_api.g_date,
1965: p_status in varchar2 default hr_api.g_varchar2,
1966: p_supervisory_status in varchar2 default hr_api.g_varchar2,
1967: p_tenure in varchar2 default hr_api.g_varchar2,
1960: p_second_noa_code in varchar2 default hr_api.g_varchar2,
1961: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
1962: p_second_noa_id in number default hr_api.g_number,
1963: p_second_noa_pa_request_id in number default hr_api.g_number,
1964: p_service_comp_date in date default hr_api.g_date,
1965: p_status in varchar2 default hr_api.g_varchar2,
1966: p_supervisory_status in varchar2 default hr_api.g_varchar2,
1967: p_tenure in varchar2 default hr_api.g_varchar2,
1968: p_to_adj_basic_pay in number default hr_api.g_number,
1961: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
1962: p_second_noa_id in number default hr_api.g_number,
1963: p_second_noa_pa_request_id in number default hr_api.g_number,
1964: p_service_comp_date in date default hr_api.g_date,
1965: p_status in varchar2 default hr_api.g_varchar2,
1966: p_supervisory_status in varchar2 default hr_api.g_varchar2,
1967: p_tenure in varchar2 default hr_api.g_varchar2,
1968: p_to_adj_basic_pay in number default hr_api.g_number,
1969: p_to_basic_pay in number default hr_api.g_number,
1962: p_second_noa_id in number default hr_api.g_number,
1963: p_second_noa_pa_request_id in number default hr_api.g_number,
1964: p_service_comp_date in date default hr_api.g_date,
1965: p_status in varchar2 default hr_api.g_varchar2,
1966: p_supervisory_status in varchar2 default hr_api.g_varchar2,
1967: p_tenure in varchar2 default hr_api.g_varchar2,
1968: p_to_adj_basic_pay in number default hr_api.g_number,
1969: p_to_basic_pay in number default hr_api.g_number,
1970: p_to_grade_id in number default hr_api.g_number,
1963: p_second_noa_pa_request_id in number default hr_api.g_number,
1964: p_service_comp_date in date default hr_api.g_date,
1965: p_status in varchar2 default hr_api.g_varchar2,
1966: p_supervisory_status in varchar2 default hr_api.g_varchar2,
1967: p_tenure in varchar2 default hr_api.g_varchar2,
1968: p_to_adj_basic_pay in number default hr_api.g_number,
1969: p_to_basic_pay in number default hr_api.g_number,
1970: p_to_grade_id in number default hr_api.g_number,
1971: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
1964: p_service_comp_date in date default hr_api.g_date,
1965: p_status in varchar2 default hr_api.g_varchar2,
1966: p_supervisory_status in varchar2 default hr_api.g_varchar2,
1967: p_tenure in varchar2 default hr_api.g_varchar2,
1968: p_to_adj_basic_pay in number default hr_api.g_number,
1969: p_to_basic_pay in number default hr_api.g_number,
1970: p_to_grade_id in number default hr_api.g_number,
1971: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
1972: p_to_job_id in number default hr_api.g_number,
1965: p_status in varchar2 default hr_api.g_varchar2,
1966: p_supervisory_status in varchar2 default hr_api.g_varchar2,
1967: p_tenure in varchar2 default hr_api.g_varchar2,
1968: p_to_adj_basic_pay in number default hr_api.g_number,
1969: p_to_basic_pay in number default hr_api.g_number,
1970: p_to_grade_id in number default hr_api.g_number,
1971: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
1972: p_to_job_id in number default hr_api.g_number,
1973: p_to_locality_adj in number default hr_api.g_number,
1966: p_supervisory_status in varchar2 default hr_api.g_varchar2,
1967: p_tenure in varchar2 default hr_api.g_varchar2,
1968: p_to_adj_basic_pay in number default hr_api.g_number,
1969: p_to_basic_pay in number default hr_api.g_number,
1970: p_to_grade_id in number default hr_api.g_number,
1971: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
1972: p_to_job_id in number default hr_api.g_number,
1973: p_to_locality_adj in number default hr_api.g_number,
1974: p_to_occ_code in varchar2 default hr_api.g_varchar2,
1967: p_tenure in varchar2 default hr_api.g_varchar2,
1968: p_to_adj_basic_pay in number default hr_api.g_number,
1969: p_to_basic_pay in number default hr_api.g_number,
1970: p_to_grade_id in number default hr_api.g_number,
1971: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
1972: p_to_job_id in number default hr_api.g_number,
1973: p_to_locality_adj in number default hr_api.g_number,
1974: p_to_occ_code in varchar2 default hr_api.g_varchar2,
1975: p_to_office_symbol in varchar2 default hr_api.g_varchar2,
1968: p_to_adj_basic_pay in number default hr_api.g_number,
1969: p_to_basic_pay in number default hr_api.g_number,
1970: p_to_grade_id in number default hr_api.g_number,
1971: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
1972: p_to_job_id in number default hr_api.g_number,
1973: p_to_locality_adj in number default hr_api.g_number,
1974: p_to_occ_code in varchar2 default hr_api.g_varchar2,
1975: p_to_office_symbol in varchar2 default hr_api.g_varchar2,
1976: p_to_organization_id in number default hr_api.g_number,
1969: p_to_basic_pay in number default hr_api.g_number,
1970: p_to_grade_id in number default hr_api.g_number,
1971: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
1972: p_to_job_id in number default hr_api.g_number,
1973: p_to_locality_adj in number default hr_api.g_number,
1974: p_to_occ_code in varchar2 default hr_api.g_varchar2,
1975: p_to_office_symbol in varchar2 default hr_api.g_varchar2,
1976: p_to_organization_id in number default hr_api.g_number,
1977: p_to_other_pay_amount in number default hr_api.g_number,
1970: p_to_grade_id in number default hr_api.g_number,
1971: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
1972: p_to_job_id in number default hr_api.g_number,
1973: p_to_locality_adj in number default hr_api.g_number,
1974: p_to_occ_code in varchar2 default hr_api.g_varchar2,
1975: p_to_office_symbol in varchar2 default hr_api.g_varchar2,
1976: p_to_organization_id in number default hr_api.g_number,
1977: p_to_other_pay_amount in number default hr_api.g_number,
1978: p_to_au_overtime in number default hr_api.g_number,
1971: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
1972: p_to_job_id in number default hr_api.g_number,
1973: p_to_locality_adj in number default hr_api.g_number,
1974: p_to_occ_code in varchar2 default hr_api.g_varchar2,
1975: p_to_office_symbol in varchar2 default hr_api.g_varchar2,
1976: p_to_organization_id in number default hr_api.g_number,
1977: p_to_other_pay_amount in number default hr_api.g_number,
1978: p_to_au_overtime in number default hr_api.g_number,
1979: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1972: p_to_job_id in number default hr_api.g_number,
1973: p_to_locality_adj in number default hr_api.g_number,
1974: p_to_occ_code in varchar2 default hr_api.g_varchar2,
1975: p_to_office_symbol in varchar2 default hr_api.g_varchar2,
1976: p_to_organization_id in number default hr_api.g_number,
1977: p_to_other_pay_amount in number default hr_api.g_number,
1978: p_to_au_overtime in number default hr_api.g_number,
1979: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1980: p_to_availability_pay in number default hr_api.g_number,
1973: p_to_locality_adj in number default hr_api.g_number,
1974: p_to_occ_code in varchar2 default hr_api.g_varchar2,
1975: p_to_office_symbol in varchar2 default hr_api.g_varchar2,
1976: p_to_organization_id in number default hr_api.g_number,
1977: p_to_other_pay_amount in number default hr_api.g_number,
1978: p_to_au_overtime in number default hr_api.g_number,
1979: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1980: p_to_availability_pay in number default hr_api.g_number,
1981: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1974: p_to_occ_code in varchar2 default hr_api.g_varchar2,
1975: p_to_office_symbol in varchar2 default hr_api.g_varchar2,
1976: p_to_organization_id in number default hr_api.g_number,
1977: p_to_other_pay_amount in number default hr_api.g_number,
1978: p_to_au_overtime in number default hr_api.g_number,
1979: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1980: p_to_availability_pay in number default hr_api.g_number,
1981: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1982: p_to_retention_allowance in number default hr_api.g_number,
1975: p_to_office_symbol in varchar2 default hr_api.g_varchar2,
1976: p_to_organization_id in number default hr_api.g_number,
1977: p_to_other_pay_amount in number default hr_api.g_number,
1978: p_to_au_overtime in number default hr_api.g_number,
1979: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1980: p_to_availability_pay in number default hr_api.g_number,
1981: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1982: p_to_retention_allowance in number default hr_api.g_number,
1983: p_to_supervisory_differential in number default hr_api.g_number,
1976: p_to_organization_id in number default hr_api.g_number,
1977: p_to_other_pay_amount in number default hr_api.g_number,
1978: p_to_au_overtime in number default hr_api.g_number,
1979: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1980: p_to_availability_pay in number default hr_api.g_number,
1981: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1982: p_to_retention_allowance in number default hr_api.g_number,
1983: p_to_supervisory_differential in number default hr_api.g_number,
1984: p_to_staffing_differential in number default hr_api.g_number,
1977: p_to_other_pay_amount in number default hr_api.g_number,
1978: p_to_au_overtime in number default hr_api.g_number,
1979: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1980: p_to_availability_pay in number default hr_api.g_number,
1981: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1982: p_to_retention_allowance in number default hr_api.g_number,
1983: p_to_supervisory_differential in number default hr_api.g_number,
1984: p_to_staffing_differential in number default hr_api.g_number,
1985: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
1978: p_to_au_overtime in number default hr_api.g_number,
1979: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1980: p_to_availability_pay in number default hr_api.g_number,
1981: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1982: p_to_retention_allowance in number default hr_api.g_number,
1983: p_to_supervisory_differential in number default hr_api.g_number,
1984: p_to_staffing_differential in number default hr_api.g_number,
1985: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
1986: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
1979: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1980: p_to_availability_pay in number default hr_api.g_number,
1981: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1982: p_to_retention_allowance in number default hr_api.g_number,
1983: p_to_supervisory_differential in number default hr_api.g_number,
1984: p_to_staffing_differential in number default hr_api.g_number,
1985: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
1986: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
1987: -- FWFA Changes Bug#4444609
1980: p_to_availability_pay in number default hr_api.g_number,
1981: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1982: p_to_retention_allowance in number default hr_api.g_number,
1983: p_to_supervisory_differential in number default hr_api.g_number,
1984: p_to_staffing_differential in number default hr_api.g_number,
1985: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
1986: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
1987: -- FWFA Changes Bug#4444609
1988: p_to_pay_table_identifier in number default hr_api.g_number,
1981: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1982: p_to_retention_allowance in number default hr_api.g_number,
1983: p_to_supervisory_differential in number default hr_api.g_number,
1984: p_to_staffing_differential in number default hr_api.g_number,
1985: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
1986: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
1987: -- FWFA Changes Bug#4444609
1988: p_to_pay_table_identifier in number default hr_api.g_number,
1989: -- FWFA Changes
1982: p_to_retention_allowance in number default hr_api.g_number,
1983: p_to_supervisory_differential in number default hr_api.g_number,
1984: p_to_staffing_differential in number default hr_api.g_number,
1985: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
1986: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
1987: -- FWFA Changes Bug#4444609
1988: p_to_pay_table_identifier in number default hr_api.g_number,
1989: -- FWFA Changes
1990: p_to_position_id in number default hr_api.g_number,
1984: p_to_staffing_differential in number default hr_api.g_number,
1985: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
1986: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
1987: -- FWFA Changes Bug#4444609
1988: p_to_pay_table_identifier in number default hr_api.g_number,
1989: -- FWFA Changes
1990: p_to_position_id in number default hr_api.g_number,
1991: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
1992: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
1986: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
1987: -- FWFA Changes Bug#4444609
1988: p_to_pay_table_identifier in number default hr_api.g_number,
1989: -- FWFA Changes
1990: p_to_position_id in number default hr_api.g_number,
1991: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
1992: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
1993: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
1994: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
1987: -- FWFA Changes Bug#4444609
1988: p_to_pay_table_identifier in number default hr_api.g_number,
1989: -- FWFA Changes
1990: p_to_position_id in number default hr_api.g_number,
1991: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
1992: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
1993: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
1994: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
1995: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
1988: p_to_pay_table_identifier in number default hr_api.g_number,
1989: -- FWFA Changes
1990: p_to_position_id in number default hr_api.g_number,
1991: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
1992: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
1993: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
1994: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
1995: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
1996: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
1989: -- FWFA Changes
1990: p_to_position_id in number default hr_api.g_number,
1991: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
1992: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
1993: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
1994: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
1995: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
1996: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
1997: p_to_position_number in varchar2 default hr_api.g_varchar2,
1990: p_to_position_id in number default hr_api.g_number,
1991: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
1992: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
1993: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
1994: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
1995: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
1996: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
1997: p_to_position_number in varchar2 default hr_api.g_varchar2,
1998: p_to_position_seq_no in number default hr_api.g_number,
1991: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
1992: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
1993: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
1994: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
1995: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
1996: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
1997: p_to_position_number in varchar2 default hr_api.g_varchar2,
1998: p_to_position_seq_no in number default hr_api.g_number,
1999: p_to_position_title in varchar2 default hr_api.g_varchar2,
1992: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
1993: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
1994: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
1995: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
1996: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
1997: p_to_position_number in varchar2 default hr_api.g_varchar2,
1998: p_to_position_seq_no in number default hr_api.g_number,
1999: p_to_position_title in varchar2 default hr_api.g_varchar2,
2000: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
1993: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
1994: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
1995: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
1996: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
1997: p_to_position_number in varchar2 default hr_api.g_varchar2,
1998: p_to_position_seq_no in number default hr_api.g_number,
1999: p_to_position_title in varchar2 default hr_api.g_varchar2,
2000: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2001: p_to_total_salary in number default hr_api.g_number,
1994: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
1995: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
1996: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
1997: p_to_position_number in varchar2 default hr_api.g_varchar2,
1998: p_to_position_seq_no in number default hr_api.g_number,
1999: p_to_position_title in varchar2 default hr_api.g_varchar2,
2000: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2001: p_to_total_salary in number default hr_api.g_number,
2002: p_veterans_preference in varchar2 default hr_api.g_varchar2,
1995: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
1996: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
1997: p_to_position_number in varchar2 default hr_api.g_varchar2,
1998: p_to_position_seq_no in number default hr_api.g_number,
1999: p_to_position_title in varchar2 default hr_api.g_varchar2,
2000: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2001: p_to_total_salary in number default hr_api.g_number,
2002: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2003: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
1996: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
1997: p_to_position_number in varchar2 default hr_api.g_varchar2,
1998: p_to_position_seq_no in number default hr_api.g_number,
1999: p_to_position_title in varchar2 default hr_api.g_varchar2,
2000: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2001: p_to_total_salary in number default hr_api.g_number,
2002: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2003: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2004: p_veterans_status in varchar2 default hr_api.g_varchar2,
1997: p_to_position_number in varchar2 default hr_api.g_varchar2,
1998: p_to_position_seq_no in number default hr_api.g_number,
1999: p_to_position_title in varchar2 default hr_api.g_varchar2,
2000: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2001: p_to_total_salary in number default hr_api.g_number,
2002: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2003: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2004: p_veterans_status in varchar2 default hr_api.g_varchar2,
2005: p_work_schedule in varchar2 default hr_api.g_varchar2,
1998: p_to_position_seq_no in number default hr_api.g_number,
1999: p_to_position_title in varchar2 default hr_api.g_varchar2,
2000: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2001: p_to_total_salary in number default hr_api.g_number,
2002: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2003: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2004: p_veterans_status in varchar2 default hr_api.g_varchar2,
2005: p_work_schedule in varchar2 default hr_api.g_varchar2,
2006: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
1999: p_to_position_title in varchar2 default hr_api.g_varchar2,
2000: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2001: p_to_total_salary in number default hr_api.g_number,
2002: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2003: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2004: p_veterans_status in varchar2 default hr_api.g_varchar2,
2005: p_work_schedule in varchar2 default hr_api.g_varchar2,
2006: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2007: p_year_degree_attained in number default hr_api.g_number,
2000: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2001: p_to_total_salary in number default hr_api.g_number,
2002: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2003: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2004: p_veterans_status in varchar2 default hr_api.g_varchar2,
2005: p_work_schedule in varchar2 default hr_api.g_varchar2,
2006: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2007: p_year_degree_attained in number default hr_api.g_number,
2008: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2001: p_to_total_salary in number default hr_api.g_number,
2002: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2003: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2004: p_veterans_status in varchar2 default hr_api.g_varchar2,
2005: p_work_schedule in varchar2 default hr_api.g_varchar2,
2006: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2007: p_year_degree_attained in number default hr_api.g_number,
2008: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2009: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2002: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2003: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2004: p_veterans_status in varchar2 default hr_api.g_varchar2,
2005: p_work_schedule in varchar2 default hr_api.g_varchar2,
2006: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2007: p_year_degree_attained in number default hr_api.g_number,
2008: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2009: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2010: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2003: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2004: p_veterans_status in varchar2 default hr_api.g_varchar2,
2005: p_work_schedule in varchar2 default hr_api.g_varchar2,
2006: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2007: p_year_degree_attained in number default hr_api.g_number,
2008: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2009: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2010: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2011: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2004: p_veterans_status in varchar2 default hr_api.g_varchar2,
2005: p_work_schedule in varchar2 default hr_api.g_varchar2,
2006: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2007: p_year_degree_attained in number default hr_api.g_number,
2008: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2009: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2010: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2011: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2012: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2005: p_work_schedule in varchar2 default hr_api.g_varchar2,
2006: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2007: p_year_degree_attained in number default hr_api.g_number,
2008: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2009: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2010: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2011: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2012: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2013: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2006: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2007: p_year_degree_attained in number default hr_api.g_number,
2008: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2009: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2010: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2011: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2012: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2013: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2014: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2007: p_year_degree_attained in number default hr_api.g_number,
2008: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2009: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2010: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2011: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2012: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2013: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2014: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2015: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2008: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2009: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2010: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2011: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2012: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2013: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2014: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2015: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2016: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2009: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2010: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2011: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2012: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2013: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2014: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2015: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2016: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2017: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2010: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2011: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2012: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2013: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2014: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2015: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2016: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2017: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2018: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2011: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2012: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2013: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2014: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2015: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2016: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2017: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2018: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2019: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2012: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2013: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2014: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2015: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2016: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2017: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2018: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2019: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2020: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2013: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2014: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2015: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2016: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2017: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2018: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2019: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2020: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2021: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2014: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2015: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2016: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2017: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2018: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2019: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2020: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2021: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2022: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2015: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2016: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2017: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2018: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2019: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2020: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2021: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2022: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2023: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2016: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2017: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2018: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2019: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2020: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2021: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2022: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2023: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2024: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2017: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2018: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2019: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2020: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2021: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2022: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2023: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2024: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2025: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2018: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2019: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2020: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2021: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2022: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2023: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2024: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2025: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2026: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2019: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2020: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2021: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2022: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2023: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2024: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2025: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2026: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2020: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2021: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2022: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2023: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2024: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2025: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2026: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2028: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2021: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2022: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2023: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2024: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2025: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2026: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2028: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2029: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2022: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2023: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2024: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2025: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2026: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2028: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2029: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2030: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2023: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2024: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2025: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2026: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2028: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2029: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2030: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2031: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2024: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2025: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2026: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2028: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2029: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2030: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2031: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2032: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2025: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2026: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2028: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2029: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2030: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2031: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2032: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2033: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2026: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2028: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2029: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2030: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2031: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2032: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2033: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2034: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2028: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2029: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2030: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2031: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2032: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2033: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2034: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2035: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2028: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2029: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2030: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2031: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2032: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2033: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2034: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2035: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2036: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2029: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2030: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2031: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2032: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2033: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2034: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2035: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2036: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2037: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2030: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2031: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2032: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2033: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2034: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2035: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2036: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2037: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2038: p_attribute_category in varchar2 default hr_api.g_varchar2,
2031: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2032: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2033: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2034: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2035: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2036: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2037: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2038: p_attribute_category in varchar2 default hr_api.g_varchar2,
2039: p_attribute1 in varchar2 default hr_api.g_varchar2,
2032: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2033: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2034: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2035: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2036: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2037: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2038: p_attribute_category in varchar2 default hr_api.g_varchar2,
2039: p_attribute1 in varchar2 default hr_api.g_varchar2,
2040: p_attribute2 in varchar2 default hr_api.g_varchar2,
2033: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2034: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2035: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2036: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2037: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2038: p_attribute_category in varchar2 default hr_api.g_varchar2,
2039: p_attribute1 in varchar2 default hr_api.g_varchar2,
2040: p_attribute2 in varchar2 default hr_api.g_varchar2,
2041: p_attribute3 in varchar2 default hr_api.g_varchar2,
2034: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2035: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2036: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2037: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2038: p_attribute_category in varchar2 default hr_api.g_varchar2,
2039: p_attribute1 in varchar2 default hr_api.g_varchar2,
2040: p_attribute2 in varchar2 default hr_api.g_varchar2,
2041: p_attribute3 in varchar2 default hr_api.g_varchar2,
2042: p_attribute4 in varchar2 default hr_api.g_varchar2,
2035: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2036: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2037: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2038: p_attribute_category in varchar2 default hr_api.g_varchar2,
2039: p_attribute1 in varchar2 default hr_api.g_varchar2,
2040: p_attribute2 in varchar2 default hr_api.g_varchar2,
2041: p_attribute3 in varchar2 default hr_api.g_varchar2,
2042: p_attribute4 in varchar2 default hr_api.g_varchar2,
2043: p_attribute5 in varchar2 default hr_api.g_varchar2,
2036: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2037: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2038: p_attribute_category in varchar2 default hr_api.g_varchar2,
2039: p_attribute1 in varchar2 default hr_api.g_varchar2,
2040: p_attribute2 in varchar2 default hr_api.g_varchar2,
2041: p_attribute3 in varchar2 default hr_api.g_varchar2,
2042: p_attribute4 in varchar2 default hr_api.g_varchar2,
2043: p_attribute5 in varchar2 default hr_api.g_varchar2,
2044: p_attribute6 in varchar2 default hr_api.g_varchar2,
2037: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2038: p_attribute_category in varchar2 default hr_api.g_varchar2,
2039: p_attribute1 in varchar2 default hr_api.g_varchar2,
2040: p_attribute2 in varchar2 default hr_api.g_varchar2,
2041: p_attribute3 in varchar2 default hr_api.g_varchar2,
2042: p_attribute4 in varchar2 default hr_api.g_varchar2,
2043: p_attribute5 in varchar2 default hr_api.g_varchar2,
2044: p_attribute6 in varchar2 default hr_api.g_varchar2,
2045: p_attribute7 in varchar2 default hr_api.g_varchar2,
2038: p_attribute_category in varchar2 default hr_api.g_varchar2,
2039: p_attribute1 in varchar2 default hr_api.g_varchar2,
2040: p_attribute2 in varchar2 default hr_api.g_varchar2,
2041: p_attribute3 in varchar2 default hr_api.g_varchar2,
2042: p_attribute4 in varchar2 default hr_api.g_varchar2,
2043: p_attribute5 in varchar2 default hr_api.g_varchar2,
2044: p_attribute6 in varchar2 default hr_api.g_varchar2,
2045: p_attribute7 in varchar2 default hr_api.g_varchar2,
2046: p_attribute8 in varchar2 default hr_api.g_varchar2,
2039: p_attribute1 in varchar2 default hr_api.g_varchar2,
2040: p_attribute2 in varchar2 default hr_api.g_varchar2,
2041: p_attribute3 in varchar2 default hr_api.g_varchar2,
2042: p_attribute4 in varchar2 default hr_api.g_varchar2,
2043: p_attribute5 in varchar2 default hr_api.g_varchar2,
2044: p_attribute6 in varchar2 default hr_api.g_varchar2,
2045: p_attribute7 in varchar2 default hr_api.g_varchar2,
2046: p_attribute8 in varchar2 default hr_api.g_varchar2,
2047: p_attribute9 in varchar2 default hr_api.g_varchar2,
2040: p_attribute2 in varchar2 default hr_api.g_varchar2,
2041: p_attribute3 in varchar2 default hr_api.g_varchar2,
2042: p_attribute4 in varchar2 default hr_api.g_varchar2,
2043: p_attribute5 in varchar2 default hr_api.g_varchar2,
2044: p_attribute6 in varchar2 default hr_api.g_varchar2,
2045: p_attribute7 in varchar2 default hr_api.g_varchar2,
2046: p_attribute8 in varchar2 default hr_api.g_varchar2,
2047: p_attribute9 in varchar2 default hr_api.g_varchar2,
2048: p_attribute10 in varchar2 default hr_api.g_varchar2,
2041: p_attribute3 in varchar2 default hr_api.g_varchar2,
2042: p_attribute4 in varchar2 default hr_api.g_varchar2,
2043: p_attribute5 in varchar2 default hr_api.g_varchar2,
2044: p_attribute6 in varchar2 default hr_api.g_varchar2,
2045: p_attribute7 in varchar2 default hr_api.g_varchar2,
2046: p_attribute8 in varchar2 default hr_api.g_varchar2,
2047: p_attribute9 in varchar2 default hr_api.g_varchar2,
2048: p_attribute10 in varchar2 default hr_api.g_varchar2,
2049: p_attribute11 in varchar2 default hr_api.g_varchar2,
2042: p_attribute4 in varchar2 default hr_api.g_varchar2,
2043: p_attribute5 in varchar2 default hr_api.g_varchar2,
2044: p_attribute6 in varchar2 default hr_api.g_varchar2,
2045: p_attribute7 in varchar2 default hr_api.g_varchar2,
2046: p_attribute8 in varchar2 default hr_api.g_varchar2,
2047: p_attribute9 in varchar2 default hr_api.g_varchar2,
2048: p_attribute10 in varchar2 default hr_api.g_varchar2,
2049: p_attribute11 in varchar2 default hr_api.g_varchar2,
2050: p_attribute12 in varchar2 default hr_api.g_varchar2,
2043: p_attribute5 in varchar2 default hr_api.g_varchar2,
2044: p_attribute6 in varchar2 default hr_api.g_varchar2,
2045: p_attribute7 in varchar2 default hr_api.g_varchar2,
2046: p_attribute8 in varchar2 default hr_api.g_varchar2,
2047: p_attribute9 in varchar2 default hr_api.g_varchar2,
2048: p_attribute10 in varchar2 default hr_api.g_varchar2,
2049: p_attribute11 in varchar2 default hr_api.g_varchar2,
2050: p_attribute12 in varchar2 default hr_api.g_varchar2,
2051: p_attribute13 in varchar2 default hr_api.g_varchar2,
2044: p_attribute6 in varchar2 default hr_api.g_varchar2,
2045: p_attribute7 in varchar2 default hr_api.g_varchar2,
2046: p_attribute8 in varchar2 default hr_api.g_varchar2,
2047: p_attribute9 in varchar2 default hr_api.g_varchar2,
2048: p_attribute10 in varchar2 default hr_api.g_varchar2,
2049: p_attribute11 in varchar2 default hr_api.g_varchar2,
2050: p_attribute12 in varchar2 default hr_api.g_varchar2,
2051: p_attribute13 in varchar2 default hr_api.g_varchar2,
2052: p_attribute14 in varchar2 default hr_api.g_varchar2,
2045: p_attribute7 in varchar2 default hr_api.g_varchar2,
2046: p_attribute8 in varchar2 default hr_api.g_varchar2,
2047: p_attribute9 in varchar2 default hr_api.g_varchar2,
2048: p_attribute10 in varchar2 default hr_api.g_varchar2,
2049: p_attribute11 in varchar2 default hr_api.g_varchar2,
2050: p_attribute12 in varchar2 default hr_api.g_varchar2,
2051: p_attribute13 in varchar2 default hr_api.g_varchar2,
2052: p_attribute14 in varchar2 default hr_api.g_varchar2,
2053: p_attribute15 in varchar2 default hr_api.g_varchar2,
2046: p_attribute8 in varchar2 default hr_api.g_varchar2,
2047: p_attribute9 in varchar2 default hr_api.g_varchar2,
2048: p_attribute10 in varchar2 default hr_api.g_varchar2,
2049: p_attribute11 in varchar2 default hr_api.g_varchar2,
2050: p_attribute12 in varchar2 default hr_api.g_varchar2,
2051: p_attribute13 in varchar2 default hr_api.g_varchar2,
2052: p_attribute14 in varchar2 default hr_api.g_varchar2,
2053: p_attribute15 in varchar2 default hr_api.g_varchar2,
2054: p_attribute16 in varchar2 default hr_api.g_varchar2,
2047: p_attribute9 in varchar2 default hr_api.g_varchar2,
2048: p_attribute10 in varchar2 default hr_api.g_varchar2,
2049: p_attribute11 in varchar2 default hr_api.g_varchar2,
2050: p_attribute12 in varchar2 default hr_api.g_varchar2,
2051: p_attribute13 in varchar2 default hr_api.g_varchar2,
2052: p_attribute14 in varchar2 default hr_api.g_varchar2,
2053: p_attribute15 in varchar2 default hr_api.g_varchar2,
2054: p_attribute16 in varchar2 default hr_api.g_varchar2,
2055: p_attribute17 in varchar2 default hr_api.g_varchar2,
2048: p_attribute10 in varchar2 default hr_api.g_varchar2,
2049: p_attribute11 in varchar2 default hr_api.g_varchar2,
2050: p_attribute12 in varchar2 default hr_api.g_varchar2,
2051: p_attribute13 in varchar2 default hr_api.g_varchar2,
2052: p_attribute14 in varchar2 default hr_api.g_varchar2,
2053: p_attribute15 in varchar2 default hr_api.g_varchar2,
2054: p_attribute16 in varchar2 default hr_api.g_varchar2,
2055: p_attribute17 in varchar2 default hr_api.g_varchar2,
2056: p_attribute18 in varchar2 default hr_api.g_varchar2,
2049: p_attribute11 in varchar2 default hr_api.g_varchar2,
2050: p_attribute12 in varchar2 default hr_api.g_varchar2,
2051: p_attribute13 in varchar2 default hr_api.g_varchar2,
2052: p_attribute14 in varchar2 default hr_api.g_varchar2,
2053: p_attribute15 in varchar2 default hr_api.g_varchar2,
2054: p_attribute16 in varchar2 default hr_api.g_varchar2,
2055: p_attribute17 in varchar2 default hr_api.g_varchar2,
2056: p_attribute18 in varchar2 default hr_api.g_varchar2,
2057: p_attribute19 in varchar2 default hr_api.g_varchar2,
2050: p_attribute12 in varchar2 default hr_api.g_varchar2,
2051: p_attribute13 in varchar2 default hr_api.g_varchar2,
2052: p_attribute14 in varchar2 default hr_api.g_varchar2,
2053: p_attribute15 in varchar2 default hr_api.g_varchar2,
2054: p_attribute16 in varchar2 default hr_api.g_varchar2,
2055: p_attribute17 in varchar2 default hr_api.g_varchar2,
2056: p_attribute18 in varchar2 default hr_api.g_varchar2,
2057: p_attribute19 in varchar2 default hr_api.g_varchar2,
2058: p_attribute20 in varchar2 default hr_api.g_varchar2,
2051: p_attribute13 in varchar2 default hr_api.g_varchar2,
2052: p_attribute14 in varchar2 default hr_api.g_varchar2,
2053: p_attribute15 in varchar2 default hr_api.g_varchar2,
2054: p_attribute16 in varchar2 default hr_api.g_varchar2,
2055: p_attribute17 in varchar2 default hr_api.g_varchar2,
2056: p_attribute18 in varchar2 default hr_api.g_varchar2,
2057: p_attribute19 in varchar2 default hr_api.g_varchar2,
2058: p_attribute20 in varchar2 default hr_api.g_varchar2,
2059: p_first_noa_canc_pa_request_id in number default hr_api.g_number,
2052: p_attribute14 in varchar2 default hr_api.g_varchar2,
2053: p_attribute15 in varchar2 default hr_api.g_varchar2,
2054: p_attribute16 in varchar2 default hr_api.g_varchar2,
2055: p_attribute17 in varchar2 default hr_api.g_varchar2,
2056: p_attribute18 in varchar2 default hr_api.g_varchar2,
2057: p_attribute19 in varchar2 default hr_api.g_varchar2,
2058: p_attribute20 in varchar2 default hr_api.g_varchar2,
2059: p_first_noa_canc_pa_request_id in number default hr_api.g_number,
2060: p_second_noa_canc_pa_request_i in number default hr_api.g_number,
2053: p_attribute15 in varchar2 default hr_api.g_varchar2,
2054: p_attribute16 in varchar2 default hr_api.g_varchar2,
2055: p_attribute17 in varchar2 default hr_api.g_varchar2,
2056: p_attribute18 in varchar2 default hr_api.g_varchar2,
2057: p_attribute19 in varchar2 default hr_api.g_varchar2,
2058: p_attribute20 in varchar2 default hr_api.g_varchar2,
2059: p_first_noa_canc_pa_request_id in number default hr_api.g_number,
2060: p_second_noa_canc_pa_request_i in number default hr_api.g_number,
2061: p_to_retention_allow_percentag in number default hr_api.g_number,
2054: p_attribute16 in varchar2 default hr_api.g_varchar2,
2055: p_attribute17 in varchar2 default hr_api.g_varchar2,
2056: p_attribute18 in varchar2 default hr_api.g_varchar2,
2057: p_attribute19 in varchar2 default hr_api.g_varchar2,
2058: p_attribute20 in varchar2 default hr_api.g_varchar2,
2059: p_first_noa_canc_pa_request_id in number default hr_api.g_number,
2060: p_second_noa_canc_pa_request_i in number default hr_api.g_number,
2061: p_to_retention_allow_percentag in number default hr_api.g_number,
2062: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2055: p_attribute17 in varchar2 default hr_api.g_varchar2,
2056: p_attribute18 in varchar2 default hr_api.g_varchar2,
2057: p_attribute19 in varchar2 default hr_api.g_varchar2,
2058: p_attribute20 in varchar2 default hr_api.g_varchar2,
2059: p_first_noa_canc_pa_request_id in number default hr_api.g_number,
2060: p_second_noa_canc_pa_request_i in number default hr_api.g_number,
2061: p_to_retention_allow_percentag in number default hr_api.g_number,
2062: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2063: p_to_staffing_diff_percentage in number default hr_api.g_number,
2056: p_attribute18 in varchar2 default hr_api.g_varchar2,
2057: p_attribute19 in varchar2 default hr_api.g_varchar2,
2058: p_attribute20 in varchar2 default hr_api.g_varchar2,
2059: p_first_noa_canc_pa_request_id in number default hr_api.g_number,
2060: p_second_noa_canc_pa_request_i in number default hr_api.g_number,
2061: p_to_retention_allow_percentag in number default hr_api.g_number,
2062: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2063: p_to_staffing_diff_percentage in number default hr_api.g_number,
2064: p_award_percentage in number default hr_api.g_number,
2057: p_attribute19 in varchar2 default hr_api.g_varchar2,
2058: p_attribute20 in varchar2 default hr_api.g_varchar2,
2059: p_first_noa_canc_pa_request_id in number default hr_api.g_number,
2060: p_second_noa_canc_pa_request_i in number default hr_api.g_number,
2061: p_to_retention_allow_percentag in number default hr_api.g_number,
2062: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2063: p_to_staffing_diff_percentage in number default hr_api.g_number,
2064: p_award_percentage in number default hr_api.g_number,
2065: p_rpa_type in varchar2 default hr_api.g_varchar2,
2058: p_attribute20 in varchar2 default hr_api.g_varchar2,
2059: p_first_noa_canc_pa_request_id in number default hr_api.g_number,
2060: p_second_noa_canc_pa_request_i in number default hr_api.g_number,
2061: p_to_retention_allow_percentag in number default hr_api.g_number,
2062: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2063: p_to_staffing_diff_percentage in number default hr_api.g_number,
2064: p_award_percentage in number default hr_api.g_number,
2065: p_rpa_type in varchar2 default hr_api.g_varchar2,
2066: p_mass_action_id in number default hr_api.g_number,
2059: p_first_noa_canc_pa_request_id in number default hr_api.g_number,
2060: p_second_noa_canc_pa_request_i in number default hr_api.g_number,
2061: p_to_retention_allow_percentag in number default hr_api.g_number,
2062: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2063: p_to_staffing_diff_percentage in number default hr_api.g_number,
2064: p_award_percentage in number default hr_api.g_number,
2065: p_rpa_type in varchar2 default hr_api.g_varchar2,
2066: p_mass_action_id in number default hr_api.g_number,
2067: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2060: p_second_noa_canc_pa_request_i in number default hr_api.g_number,
2061: p_to_retention_allow_percentag in number default hr_api.g_number,
2062: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2063: p_to_staffing_diff_percentage in number default hr_api.g_number,
2064: p_award_percentage in number default hr_api.g_number,
2065: p_rpa_type in varchar2 default hr_api.g_varchar2,
2066: p_mass_action_id in number default hr_api.g_number,
2067: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2068: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2061: p_to_retention_allow_percentag in number default hr_api.g_number,
2062: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2063: p_to_staffing_diff_percentage in number default hr_api.g_number,
2064: p_award_percentage in number default hr_api.g_number,
2065: p_rpa_type in varchar2 default hr_api.g_varchar2,
2066: p_mass_action_id in number default hr_api.g_number,
2067: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2068: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2069: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2062: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2063: p_to_staffing_diff_percentage in number default hr_api.g_number,
2064: p_award_percentage in number default hr_api.g_number,
2065: p_rpa_type in varchar2 default hr_api.g_varchar2,
2066: p_mass_action_id in number default hr_api.g_number,
2067: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2068: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2069: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2070: -- Bug# RRR Changes
2063: p_to_staffing_diff_percentage in number default hr_api.g_number,
2064: p_award_percentage in number default hr_api.g_number,
2065: p_rpa_type in varchar2 default hr_api.g_varchar2,
2066: p_mass_action_id in number default hr_api.g_number,
2067: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2068: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2069: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2070: -- Bug# RRR Changes
2071: p_payment_option in varchar2 default hr_api.g_varchar2,
2064: p_award_percentage in number default hr_api.g_number,
2065: p_rpa_type in varchar2 default hr_api.g_varchar2,
2066: p_mass_action_id in number default hr_api.g_number,
2067: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2068: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2069: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2070: -- Bug# RRR Changes
2071: p_payment_option in varchar2 default hr_api.g_varchar2,
2072: p_award_salary in number default hr_api.g_number,
2065: p_rpa_type in varchar2 default hr_api.g_varchar2,
2066: p_mass_action_id in number default hr_api.g_number,
2067: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2068: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2069: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2070: -- Bug# RRR Changes
2071: p_payment_option in varchar2 default hr_api.g_varchar2,
2072: p_award_salary in number default hr_api.g_number,
2073: -- Bug# RRR Changes
2067: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2068: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2069: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2070: -- Bug# RRR Changes
2071: p_payment_option in varchar2 default hr_api.g_varchar2,
2072: p_award_salary in number default hr_api.g_number,
2073: -- Bug# RRR Changes
2074: p_object_version_number in out nocopy number
2075: )
2068: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2069: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2070: -- Bug# RRR Changes
2071: p_payment_option in varchar2 default hr_api.g_varchar2,
2072: p_award_salary in number default hr_api.g_number,
2073: -- Bug# RRR Changes
2074: p_object_version_number in out nocopy number
2075: )
2076: is