52: --
53: --
54: --
55: l_user_name ghr_pa_routing_history.user_name%TYPE;
56: l_person_id ghr_pa_requests.person_id%TYPE;
57: l_position_id ghr_pa_requests.from_position_id%TYPE;
58: l_effective_date ghr_pa_requests.effective_date%TYPE;
59: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
60: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
53: --
54: --
55: l_user_name ghr_pa_routing_history.user_name%TYPE;
56: l_person_id ghr_pa_requests.person_id%TYPE;
57: l_position_id ghr_pa_requests.from_position_id%TYPE;
58: l_effective_date ghr_pa_requests.effective_date%TYPE;
59: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
60: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
61: l_full_name per_people_f.full_name%TYPE;
54: --
55: l_user_name ghr_pa_routing_history.user_name%TYPE;
56: l_person_id ghr_pa_requests.person_id%TYPE;
57: l_position_id ghr_pa_requests.from_position_id%TYPE;
58: l_effective_date ghr_pa_requests.effective_date%TYPE;
59: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
60: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
61: l_full_name per_people_f.full_name%TYPE;
62: l_routing_group_name ghr_routing_groups.name%TYPE;
55: l_user_name ghr_pa_routing_history.user_name%TYPE;
56: l_person_id ghr_pa_requests.person_id%TYPE;
57: l_position_id ghr_pa_requests.from_position_id%TYPE;
58: l_effective_date ghr_pa_requests.effective_date%TYPE;
59: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
60: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
61: l_full_name per_people_f.full_name%TYPE;
62: l_routing_group_name ghr_routing_groups.name%TYPE;
63: l_routing_group_desc ghr_routing_groups.description%TYPE;
56: l_person_id ghr_pa_requests.person_id%TYPE;
57: l_position_id ghr_pa_requests.from_position_id%TYPE;
58: l_effective_date ghr_pa_requests.effective_date%TYPE;
59: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
60: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
61: l_full_name per_people_f.full_name%TYPE;
62: l_routing_group_name ghr_routing_groups.name%TYPE;
63: l_routing_group_desc ghr_routing_groups.description%TYPE;
64: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
78: l_line5 varchar2(500);
79: l_line6 varchar2(500);
80: l_line7 varchar2(500);
81: l_wgi_error_note varchar2(500);
82: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
83: l_gbx_user_id ghr_pois.person_id%TYPE;
84: l_routing_group varchar2(500);
85: -- NOCOPY Changes
86: l_result varchar2(250);
429: -- |-----------------------------< get_next_approver >------------------------|
430: -- ----------------------------------------------------------------------------
431: function get_next_approver
432: (p_person_id in per_people_f.person_id%type,
433: p_effective_date in ghr_pa_requests.effective_date%TYPE
434: )
435: return ghr_pa_routing_history.user_name%TYPE is
436: --
437: l_in_person_id ghr_pa_requests.person_id%TYPE;
433: p_effective_date in ghr_pa_requests.effective_date%TYPE
434: )
435: return ghr_pa_routing_history.user_name%TYPE is
436: --
437: l_in_person_id ghr_pa_requests.person_id%TYPE;
438: l_effective_date ghr_pa_requests.effective_date%TYPE;
439: l_out_person_name ghr_pa_routing_history.user_name%TYPE;
440: --
441: cursor csr_pa is
434: )
435: return ghr_pa_routing_history.user_name%TYPE is
436: --
437: l_in_person_id ghr_pa_requests.person_id%TYPE;
438: l_effective_date ghr_pa_requests.effective_date%TYPE;
439: l_out_person_name ghr_pa_routing_history.user_name%TYPE;
440: --
441: cursor csr_pa is
442: select substr(usr.user_name,1,30) user_name
479: PROCEDURE Get_emp_personnel_groupbox (
480: p_position_id IN number,
481: p_effective_date IN date,
482: p_groupbox_name out nocopy varchar2,
483: p_personnel_office_id out nocopy ghr_pa_requests.personnel_office_id%TYPE,
484: p_gbx_user_id out nocopy ghr_pois.person_id%TYPE
485: ) IS
486: --
487: -- Local variables
487: -- Local variables
488: --
489: l_groupbox_name ghr_groupboxes.name%TYPE;
490: --
491: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
492: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
493: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
494: l_functional_class ghr_pa_requests.functional_class%TYPE;
495: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
488: --
489: l_groupbox_name ghr_groupboxes.name%TYPE;
490: --
491: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
492: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
493: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
494: l_functional_class ghr_pa_requests.functional_class%TYPE;
495: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
496: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
489: l_groupbox_name ghr_groupboxes.name%TYPE;
490: --
491: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
492: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
493: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
494: l_functional_class ghr_pa_requests.functional_class%TYPE;
495: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
496: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
497: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
490: --
491: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
492: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
493: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
494: l_functional_class ghr_pa_requests.functional_class%TYPE;
495: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
496: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
497: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
498: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
491: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
492: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
493: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
494: l_functional_class ghr_pa_requests.functional_class%TYPE;
495: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
496: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
497: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
498: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
499: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
492: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
493: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
494: l_functional_class ghr_pa_requests.functional_class%TYPE;
495: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
496: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
497: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
498: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
499: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
500: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
493: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
494: l_functional_class ghr_pa_requests.functional_class%TYPE;
495: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
496: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
497: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
498: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
499: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
500: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
501: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
494: l_functional_class ghr_pa_requests.functional_class%TYPE;
495: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
496: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
497: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
498: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
499: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
500: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
501: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
502: l_gbx_user_id ghr_pois.person_id%TYPE;
495: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
496: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
497: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
498: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
499: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
500: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
501: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
502: l_gbx_user_id ghr_pois.person_id%TYPE;
503: --
496: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
497: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
498: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
499: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
500: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
501: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
502: l_gbx_user_id ghr_pois.person_id%TYPE;
503: --
504: --
497: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
498: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
499: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
500: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
501: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
502: l_gbx_user_id ghr_pois.person_id%TYPE;
503: --
504: --
505: cursor csr_poi_code is
509: AND poi.personnel_office_id = nvl(l_personnel_office_id,-99999999);
510: --
511: begin
512: --
513: ghr_pa_requests_pkg.get_SF52_pos_ddf_details
514: (p_position_id => p_position_id
515: ,p_date_effective => trunc(p_effective_date)
516: ,p_flsa_category => l_flsa_category
517: ,p_bargaining_unit_status => l_bargaining_unit_status
559: ) IS
560: --
561: -- Local variables
562: --
563: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
564: l_person_id ghr_pa_requests.person_id%TYPE;
565: l_effective_date ghr_pa_requests.effective_date%TYPE;
566: l_position_id ghr_pa_requests.from_position_id%TYPE;
567: --
560: --
561: -- Local variables
562: --
563: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
564: l_person_id ghr_pa_requests.person_id%TYPE;
565: l_effective_date ghr_pa_requests.effective_date%TYPE;
566: l_position_id ghr_pa_requests.from_position_id%TYPE;
567: --
568: cursor csr_par is
561: -- Local variables
562: --
563: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
564: l_person_id ghr_pa_requests.person_id%TYPE;
565: l_effective_date ghr_pa_requests.effective_date%TYPE;
566: l_position_id ghr_pa_requests.from_position_id%TYPE;
567: --
568: cursor csr_par is
569: select person_id, effective_date, from_position_id
562: --
563: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
564: l_person_id ghr_pa_requests.person_id%TYPE;
565: l_effective_date ghr_pa_requests.effective_date%TYPE;
566: l_position_id ghr_pa_requests.from_position_id%TYPE;
567: --
568: cursor csr_par is
569: select person_id, effective_date, from_position_id
570: from ghr_pa_requests par
566: l_position_id ghr_pa_requests.from_position_id%TYPE;
567: --
568: cursor csr_par is
569: select person_id, effective_date, from_position_id
570: from ghr_pa_requests par
571: where par.pa_request_id = l_pa_request_id;
572: --
573: begin
574: --
701: result in out nocopy varchar2
702: ) is
703: cursor c1 is
704: select object_version_number
705: from ghr_pa_requests
706: where pa_request_id = itemkey;
707: l_ovn ghr_pa_requests.object_version_number%type;
708: l_result VARCHAR2(250);
709:
703: cursor c1 is
704: select object_version_number
705: from ghr_pa_requests
706: where pa_request_id = itemkey;
707: l_ovn ghr_pa_requests.object_version_number%type;
708: l_result VARCHAR2(250);
709:
710: Begin
711: l_result := result;
784: l_line7 varchar2(500);
785: l_office_symbol_id varchar2(30);
786: l_office_symbol_name varchar2(80);
787: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
788: l_ret_grade ghr_pa_requests.from_grade_or_level%type;
789: l_cur_grade ghr_pa_requests.from_grade_or_level%type;
790: l_ret_pay_plan varchar2(30);
791: l_cur_pay_plan varchar2(30);
792: l_cur_step_rate ghr_pa_requests.from_step_or_rate%type;
785: l_office_symbol_id varchar2(30);
786: l_office_symbol_name varchar2(80);
787: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
788: l_ret_grade ghr_pa_requests.from_grade_or_level%type;
789: l_cur_grade ghr_pa_requests.from_grade_or_level%type;
790: l_ret_pay_plan varchar2(30);
791: l_cur_pay_plan varchar2(30);
792: l_cur_step_rate ghr_pa_requests.from_step_or_rate%type;
793: l_ret_step_rate ghr_pa_requests.from_step_or_rate%type;
788: l_ret_grade ghr_pa_requests.from_grade_or_level%type;
789: l_cur_grade ghr_pa_requests.from_grade_or_level%type;
790: l_ret_pay_plan varchar2(30);
791: l_cur_pay_plan varchar2(30);
792: l_cur_step_rate ghr_pa_requests.from_step_or_rate%type;
793: l_ret_step_rate ghr_pa_requests.from_step_or_rate%type;
794: l_rating_id per_analysis_criteria.segment2%type;
795: l_rating ghr_pa_request_extra_info.rei_information3%type;
796: l_rating_date varchar2(30);
789: l_cur_grade ghr_pa_requests.from_grade_or_level%type;
790: l_ret_pay_plan varchar2(30);
791: l_cur_pay_plan varchar2(30);
792: l_cur_step_rate ghr_pa_requests.from_step_or_rate%type;
793: l_ret_step_rate ghr_pa_requests.from_step_or_rate%type;
794: l_rating_id per_analysis_criteria.segment2%type;
795: l_rating ghr_pa_request_extra_info.rei_information3%type;
796: l_rating_date varchar2(30);
797: l_wgi_date varchar2(30);
794: l_rating_id per_analysis_criteria.segment2%type;
795: l_rating ghr_pa_request_extra_info.rei_information3%type;
796: l_rating_date varchar2(30);
797: l_wgi_date varchar2(30);
798: l_new_step ghr_pa_requests.to_step_or_rate%type;
799: l_new_sal ghr_pa_requests.to_total_salary%type;
800: l_positionei_rec per_position_extra_info%rowtype;
801: l_special_info ghr_api.special_information_type;
802: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
795: l_rating ghr_pa_request_extra_info.rei_information3%type;
796: l_rating_date varchar2(30);
797: l_wgi_date varchar2(30);
798: l_new_step ghr_pa_requests.to_step_or_rate%type;
799: l_new_sal ghr_pa_requests.to_total_salary%type;
800: l_positionei_rec per_position_extra_info%rowtype;
801: l_special_info ghr_api.special_information_type;
802: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
803: l_routing_group_name ghr_routing_groups.name%TYPE;
798: l_new_step ghr_pa_requests.to_step_or_rate%type;
799: l_new_sal ghr_pa_requests.to_total_salary%type;
800: l_positionei_rec per_position_extra_info%rowtype;
801: l_special_info ghr_api.special_information_type;
802: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
803: l_routing_group_name ghr_routing_groups.name%TYPE;
804: l_rgp_description ghr_routing_groups.description%TYPE;
805: --
806: --
820: from_grade_or_level,
821: from_step_or_rate,
822: to_step_or_rate,
823: to_total_salary
824: from ghr_pa_requests
825: where pa_request_id = p_request_id;
826: --
827: cursor cur_par_extra is
828: select rei_information3,
833: --
834: --
835: cursor csr_rgp is
836: SELECT rgp.name, rgp.description
837: FROM ghr_routing_groups rgp, ghr_pa_requests par
838: WHERE par.pa_request_id = p_request_id
839: and par.routing_group_id = rgp.routing_group_id;
840: --
841: Begin
1040: --
1041: end EndWGIProcess;
1042: --
1043: --
1044: procedure update_sf52_action_taken(p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1045: ,p_routing_group_id in ghr_pa_requests.routing_group_id%type
1046: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%type
1047: ,p_action_taken in ghr_pa_routing_history.action_taken%TYPE
1048: ,p_gbx_user_id in ghr_pois.person_id%TYPE)
1041: end EndWGIProcess;
1042: --
1043: --
1044: procedure update_sf52_action_taken(p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1045: ,p_routing_group_id in ghr_pa_requests.routing_group_id%type
1046: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%type
1047: ,p_action_taken in ghr_pa_routing_history.action_taken%TYPE
1048: ,p_gbx_user_id in ghr_pois.person_id%TYPE)
1049: is
1055: -- Local variables
1056: --
1057: l_exists boolean := false;
1058: l_validate boolean := false;
1059: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
1060: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1061: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
1062: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE;
1063: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
1056: --
1057: l_exists boolean := false;
1058: l_validate boolean := false;
1059: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
1060: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1061: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
1062: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE;
1063: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
1064: l_additional_info_person_id ghr_pa_requests.additional_info_person_id%TYPE;
1057: l_exists boolean := false;
1058: l_validate boolean := false;
1059: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
1060: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1061: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
1062: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE;
1063: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
1064: l_additional_info_person_id ghr_pa_requests.additional_info_person_id%TYPE;
1065: l_additional_info_tel_number ghr_pa_requests.additional_info_tel_number%TYPE;
1058: l_validate boolean := false;
1059: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
1060: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1061: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
1062: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE;
1063: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
1064: l_additional_info_person_id ghr_pa_requests.additional_info_person_id%TYPE;
1065: l_additional_info_tel_number ghr_pa_requests.additional_info_tel_number%TYPE;
1066: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%TYPE;
1059: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
1060: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1061: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
1062: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE;
1063: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
1064: l_additional_info_person_id ghr_pa_requests.additional_info_person_id%TYPE;
1065: l_additional_info_tel_number ghr_pa_requests.additional_info_tel_number%TYPE;
1066: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%TYPE;
1067: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
1060: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1061: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
1062: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE;
1063: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
1064: l_additional_info_person_id ghr_pa_requests.additional_info_person_id%TYPE;
1065: l_additional_info_tel_number ghr_pa_requests.additional_info_tel_number%TYPE;
1066: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%TYPE;
1067: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
1068: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
1061: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
1062: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE;
1063: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
1064: l_additional_info_person_id ghr_pa_requests.additional_info_person_id%TYPE;
1065: l_additional_info_tel_number ghr_pa_requests.additional_info_tel_number%TYPE;
1066: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%TYPE;
1067: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
1068: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
1069: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
1062: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE;
1063: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
1064: l_additional_info_person_id ghr_pa_requests.additional_info_person_id%TYPE;
1065: l_additional_info_tel_number ghr_pa_requests.additional_info_tel_number%TYPE;
1066: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%TYPE;
1067: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
1068: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
1069: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
1070: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
1063: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
1064: l_additional_info_person_id ghr_pa_requests.additional_info_person_id%TYPE;
1065: l_additional_info_tel_number ghr_pa_requests.additional_info_tel_number%TYPE;
1066: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%TYPE;
1067: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
1068: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
1069: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
1070: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
1071: l_authorized_by_person_id ghr_pa_requests.authorized_by_person_id%TYPE;
1064: l_additional_info_person_id ghr_pa_requests.additional_info_person_id%TYPE;
1065: l_additional_info_tel_number ghr_pa_requests.additional_info_tel_number%TYPE;
1066: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%TYPE;
1067: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
1068: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
1069: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
1070: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
1071: l_authorized_by_person_id ghr_pa_requests.authorized_by_person_id%TYPE;
1072: l_authorized_by_title ghr_pa_requests.authorized_by_title%TYPE;
1065: l_additional_info_tel_number ghr_pa_requests.additional_info_tel_number%TYPE;
1066: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%TYPE;
1067: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
1068: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
1069: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
1070: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
1071: l_authorized_by_person_id ghr_pa_requests.authorized_by_person_id%TYPE;
1072: l_authorized_by_title ghr_pa_requests.authorized_by_title%TYPE;
1073: l_award_amount ghr_pa_requests.award_amount%TYPE;
1066: l_altered_pa_request_id ghr_pa_requests.altered_pa_request_id%TYPE;
1067: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
1068: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
1069: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
1070: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
1071: l_authorized_by_person_id ghr_pa_requests.authorized_by_person_id%TYPE;
1072: l_authorized_by_title ghr_pa_requests.authorized_by_title%TYPE;
1073: l_award_amount ghr_pa_requests.award_amount%TYPE;
1074: l_award_uom ghr_pa_requests.award_uom%TYPE;
1067: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
1068: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
1069: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
1070: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
1071: l_authorized_by_person_id ghr_pa_requests.authorized_by_person_id%TYPE;
1072: l_authorized_by_title ghr_pa_requests.authorized_by_title%TYPE;
1073: l_award_amount ghr_pa_requests.award_amount%TYPE;
1074: l_award_uom ghr_pa_requests.award_uom%TYPE;
1075: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
1068: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
1069: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
1070: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
1071: l_authorized_by_person_id ghr_pa_requests.authorized_by_person_id%TYPE;
1072: l_authorized_by_title ghr_pa_requests.authorized_by_title%TYPE;
1073: l_award_amount ghr_pa_requests.award_amount%TYPE;
1074: l_award_uom ghr_pa_requests.award_uom%TYPE;
1075: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
1076: l_citizenship ghr_pa_requests.citizenship%TYPE;
1069: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
1070: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
1071: l_authorized_by_person_id ghr_pa_requests.authorized_by_person_id%TYPE;
1072: l_authorized_by_title ghr_pa_requests.authorized_by_title%TYPE;
1073: l_award_amount ghr_pa_requests.award_amount%TYPE;
1074: l_award_uom ghr_pa_requests.award_uom%TYPE;
1075: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
1076: l_citizenship ghr_pa_requests.citizenship%TYPE;
1077: l_concurrence_date ghr_pa_requests.concurrence_date%TYPE;
1070: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
1071: l_authorized_by_person_id ghr_pa_requests.authorized_by_person_id%TYPE;
1072: l_authorized_by_title ghr_pa_requests.authorized_by_title%TYPE;
1073: l_award_amount ghr_pa_requests.award_amount%TYPE;
1074: l_award_uom ghr_pa_requests.award_uom%TYPE;
1075: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
1076: l_citizenship ghr_pa_requests.citizenship%TYPE;
1077: l_concurrence_date ghr_pa_requests.concurrence_date%TYPE;
1078: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
1071: l_authorized_by_person_id ghr_pa_requests.authorized_by_person_id%TYPE;
1072: l_authorized_by_title ghr_pa_requests.authorized_by_title%TYPE;
1073: l_award_amount ghr_pa_requests.award_amount%TYPE;
1074: l_award_uom ghr_pa_requests.award_uom%TYPE;
1075: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
1076: l_citizenship ghr_pa_requests.citizenship%TYPE;
1077: l_concurrence_date ghr_pa_requests.concurrence_date%TYPE;
1078: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
1079: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
1072: l_authorized_by_title ghr_pa_requests.authorized_by_title%TYPE;
1073: l_award_amount ghr_pa_requests.award_amount%TYPE;
1074: l_award_uom ghr_pa_requests.award_uom%TYPE;
1075: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
1076: l_citizenship ghr_pa_requests.citizenship%TYPE;
1077: l_concurrence_date ghr_pa_requests.concurrence_date%TYPE;
1078: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
1079: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
1080: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
1073: l_award_amount ghr_pa_requests.award_amount%TYPE;
1074: l_award_uom ghr_pa_requests.award_uom%TYPE;
1075: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
1076: l_citizenship ghr_pa_requests.citizenship%TYPE;
1077: l_concurrence_date ghr_pa_requests.concurrence_date%TYPE;
1078: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
1079: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
1080: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
1081: l_duty_station_id ghr_pa_requests.duty_station_id%TYPE;
1074: l_award_uom ghr_pa_requests.award_uom%TYPE;
1075: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
1076: l_citizenship ghr_pa_requests.citizenship%TYPE;
1077: l_concurrence_date ghr_pa_requests.concurrence_date%TYPE;
1078: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
1079: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
1080: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
1081: l_duty_station_id ghr_pa_requests.duty_station_id%TYPE;
1082: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
1075: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
1076: l_citizenship ghr_pa_requests.citizenship%TYPE;
1077: l_concurrence_date ghr_pa_requests.concurrence_date%TYPE;
1078: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
1079: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
1080: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
1081: l_duty_station_id ghr_pa_requests.duty_station_id%TYPE;
1082: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
1083: l_education_level ghr_pa_requests.education_level%TYPE;
1076: l_citizenship ghr_pa_requests.citizenship%TYPE;
1077: l_concurrence_date ghr_pa_requests.concurrence_date%TYPE;
1078: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
1079: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
1080: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
1081: l_duty_station_id ghr_pa_requests.duty_station_id%TYPE;
1082: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
1083: l_education_level ghr_pa_requests.education_level%TYPE;
1084: l_effective_date ghr_pa_requests.effective_date%TYPE;
1077: l_concurrence_date ghr_pa_requests.concurrence_date%TYPE;
1078: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
1079: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
1080: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
1081: l_duty_station_id ghr_pa_requests.duty_station_id%TYPE;
1082: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
1083: l_education_level ghr_pa_requests.education_level%TYPE;
1084: l_effective_date ghr_pa_requests.effective_date%TYPE;
1085: l_employee_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1078: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
1079: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
1080: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
1081: l_duty_station_id ghr_pa_requests.duty_station_id%TYPE;
1082: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
1083: l_education_level ghr_pa_requests.education_level%TYPE;
1084: l_effective_date ghr_pa_requests.effective_date%TYPE;
1085: l_employee_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1086: l_employee_date_of_birth ghr_pa_requests.employee_date_of_birth%TYPE;
1079: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
1080: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
1081: l_duty_station_id ghr_pa_requests.duty_station_id%TYPE;
1082: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
1083: l_education_level ghr_pa_requests.education_level%TYPE;
1084: l_effective_date ghr_pa_requests.effective_date%TYPE;
1085: l_employee_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1086: l_employee_date_of_birth ghr_pa_requests.employee_date_of_birth%TYPE;
1087: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
1080: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
1081: l_duty_station_id ghr_pa_requests.duty_station_id%TYPE;
1082: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
1083: l_education_level ghr_pa_requests.education_level%TYPE;
1084: l_effective_date ghr_pa_requests.effective_date%TYPE;
1085: l_employee_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1086: l_employee_date_of_birth ghr_pa_requests.employee_date_of_birth%TYPE;
1087: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
1088: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
1081: l_duty_station_id ghr_pa_requests.duty_station_id%TYPE;
1082: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
1083: l_education_level ghr_pa_requests.education_level%TYPE;
1084: l_effective_date ghr_pa_requests.effective_date%TYPE;
1085: l_employee_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1086: l_employee_date_of_birth ghr_pa_requests.employee_date_of_birth%TYPE;
1087: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
1088: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
1089: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
1082: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
1083: l_education_level ghr_pa_requests.education_level%TYPE;
1084: l_effective_date ghr_pa_requests.effective_date%TYPE;
1085: l_employee_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1086: l_employee_date_of_birth ghr_pa_requests.employee_date_of_birth%TYPE;
1087: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
1088: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
1089: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
1090: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%TYPE;
1083: l_education_level ghr_pa_requests.education_level%TYPE;
1084: l_effective_date ghr_pa_requests.effective_date%TYPE;
1085: l_employee_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1086: l_employee_date_of_birth ghr_pa_requests.employee_date_of_birth%TYPE;
1087: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
1088: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
1089: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
1090: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%TYPE;
1091: l_fegli ghr_pa_requests.fegli%TYPE;
1084: l_effective_date ghr_pa_requests.effective_date%TYPE;
1085: l_employee_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1086: l_employee_date_of_birth ghr_pa_requests.employee_date_of_birth%TYPE;
1087: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
1088: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
1089: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
1090: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%TYPE;
1091: l_fegli ghr_pa_requests.fegli%TYPE;
1092: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
1085: l_employee_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1086: l_employee_date_of_birth ghr_pa_requests.employee_date_of_birth%TYPE;
1087: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
1088: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
1089: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
1090: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%TYPE;
1091: l_fegli ghr_pa_requests.fegli%TYPE;
1092: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
1093: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1086: l_employee_date_of_birth ghr_pa_requests.employee_date_of_birth%TYPE;
1087: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
1088: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
1089: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
1090: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%TYPE;
1091: l_fegli ghr_pa_requests.fegli%TYPE;
1092: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
1093: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1094: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1087: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
1088: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
1089: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
1090: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%TYPE;
1091: l_fegli ghr_pa_requests.fegli%TYPE;
1092: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
1093: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1094: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1095: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
1088: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
1089: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
1090: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%TYPE;
1091: l_fegli ghr_pa_requests.fegli%TYPE;
1092: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
1093: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1094: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1095: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
1096: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
1089: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
1090: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%TYPE;
1091: l_fegli ghr_pa_requests.fegli%TYPE;
1092: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
1093: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1094: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1095: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
1096: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
1097: l_first_noa_cancel_or_correct ghr_pa_requests.first_noa_cancel_or_correct%TYPE;
1090: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%TYPE;
1091: l_fegli ghr_pa_requests.fegli%TYPE;
1092: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
1093: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1094: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1095: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
1096: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
1097: l_first_noa_cancel_or_correct ghr_pa_requests.first_noa_cancel_or_correct%TYPE;
1098: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1091: l_fegli ghr_pa_requests.fegli%TYPE;
1092: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
1093: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1094: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1095: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
1096: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
1097: l_first_noa_cancel_or_correct ghr_pa_requests.first_noa_cancel_or_correct%TYPE;
1098: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1099: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
1092: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
1093: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1094: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1095: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
1096: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
1097: l_first_noa_cancel_or_correct ghr_pa_requests.first_noa_cancel_or_correct%TYPE;
1098: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1099: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
1100: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1093: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1094: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1095: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
1096: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
1097: l_first_noa_cancel_or_correct ghr_pa_requests.first_noa_cancel_or_correct%TYPE;
1098: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1099: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
1100: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1101: l_first_noa_pa_request_id ghr_pa_requests.first_noa_pa_request_id%TYPE;
1094: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1095: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
1096: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
1097: l_first_noa_cancel_or_correct ghr_pa_requests.first_noa_cancel_or_correct%TYPE;
1098: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1099: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
1100: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1101: l_first_noa_pa_request_id ghr_pa_requests.first_noa_pa_request_id%TYPE;
1102: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
1095: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
1096: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
1097: l_first_noa_cancel_or_correct ghr_pa_requests.first_noa_cancel_or_correct%TYPE;
1098: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1099: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
1100: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1101: l_first_noa_pa_request_id ghr_pa_requests.first_noa_pa_request_id%TYPE;
1102: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
1103: l_forwarding_address_line1 ghr_pa_requests.forwarding_address_line1%TYPE;
1096: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
1097: l_first_noa_cancel_or_correct ghr_pa_requests.first_noa_cancel_or_correct%TYPE;
1098: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1099: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
1100: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1101: l_first_noa_pa_request_id ghr_pa_requests.first_noa_pa_request_id%TYPE;
1102: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
1103: l_forwarding_address_line1 ghr_pa_requests.forwarding_address_line1%TYPE;
1104: l_forwarding_address_line2 ghr_pa_requests.forwarding_address_line2%TYPE;
1097: l_first_noa_cancel_or_correct ghr_pa_requests.first_noa_cancel_or_correct%TYPE;
1098: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1099: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
1100: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1101: l_first_noa_pa_request_id ghr_pa_requests.first_noa_pa_request_id%TYPE;
1102: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
1103: l_forwarding_address_line1 ghr_pa_requests.forwarding_address_line1%TYPE;
1104: l_forwarding_address_line2 ghr_pa_requests.forwarding_address_line2%TYPE;
1105: l_forwarding_address_line3 ghr_pa_requests.forwarding_address_line3%TYPE;
1098: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1099: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
1100: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1101: l_first_noa_pa_request_id ghr_pa_requests.first_noa_pa_request_id%TYPE;
1102: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
1103: l_forwarding_address_line1 ghr_pa_requests.forwarding_address_line1%TYPE;
1104: l_forwarding_address_line2 ghr_pa_requests.forwarding_address_line2%TYPE;
1105: l_forwarding_address_line3 ghr_pa_requests.forwarding_address_line3%TYPE;
1106: l_forwarding_country ghr_pa_requests.forwarding_country%TYPE;
1099: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
1100: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1101: l_first_noa_pa_request_id ghr_pa_requests.first_noa_pa_request_id%TYPE;
1102: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
1103: l_forwarding_address_line1 ghr_pa_requests.forwarding_address_line1%TYPE;
1104: l_forwarding_address_line2 ghr_pa_requests.forwarding_address_line2%TYPE;
1105: l_forwarding_address_line3 ghr_pa_requests.forwarding_address_line3%TYPE;
1106: l_forwarding_country ghr_pa_requests.forwarding_country%TYPE;
1107: l_forwarding_postal_code ghr_pa_requests.forwarding_postal_code%TYPE;
1100: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1101: l_first_noa_pa_request_id ghr_pa_requests.first_noa_pa_request_id%TYPE;
1102: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
1103: l_forwarding_address_line1 ghr_pa_requests.forwarding_address_line1%TYPE;
1104: l_forwarding_address_line2 ghr_pa_requests.forwarding_address_line2%TYPE;
1105: l_forwarding_address_line3 ghr_pa_requests.forwarding_address_line3%TYPE;
1106: l_forwarding_country ghr_pa_requests.forwarding_country%TYPE;
1107: l_forwarding_postal_code ghr_pa_requests.forwarding_postal_code%TYPE;
1108: l_forwarding_region_2 ghr_pa_requests.forwarding_region_2%TYPE;
1101: l_first_noa_pa_request_id ghr_pa_requests.first_noa_pa_request_id%TYPE;
1102: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
1103: l_forwarding_address_line1 ghr_pa_requests.forwarding_address_line1%TYPE;
1104: l_forwarding_address_line2 ghr_pa_requests.forwarding_address_line2%TYPE;
1105: l_forwarding_address_line3 ghr_pa_requests.forwarding_address_line3%TYPE;
1106: l_forwarding_country ghr_pa_requests.forwarding_country%TYPE;
1107: l_forwarding_postal_code ghr_pa_requests.forwarding_postal_code%TYPE;
1108: l_forwarding_region_2 ghr_pa_requests.forwarding_region_2%TYPE;
1109: l_forwarding_town_or_city ghr_pa_requests.forwarding_town_or_city%TYPE;
1102: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
1103: l_forwarding_address_line1 ghr_pa_requests.forwarding_address_line1%TYPE;
1104: l_forwarding_address_line2 ghr_pa_requests.forwarding_address_line2%TYPE;
1105: l_forwarding_address_line3 ghr_pa_requests.forwarding_address_line3%TYPE;
1106: l_forwarding_country ghr_pa_requests.forwarding_country%TYPE;
1107: l_forwarding_postal_code ghr_pa_requests.forwarding_postal_code%TYPE;
1108: l_forwarding_region_2 ghr_pa_requests.forwarding_region_2%TYPE;
1109: l_forwarding_town_or_city ghr_pa_requests.forwarding_town_or_city%TYPE;
1110: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
1103: l_forwarding_address_line1 ghr_pa_requests.forwarding_address_line1%TYPE;
1104: l_forwarding_address_line2 ghr_pa_requests.forwarding_address_line2%TYPE;
1105: l_forwarding_address_line3 ghr_pa_requests.forwarding_address_line3%TYPE;
1106: l_forwarding_country ghr_pa_requests.forwarding_country%TYPE;
1107: l_forwarding_postal_code ghr_pa_requests.forwarding_postal_code%TYPE;
1108: l_forwarding_region_2 ghr_pa_requests.forwarding_region_2%TYPE;
1109: l_forwarding_town_or_city ghr_pa_requests.forwarding_town_or_city%TYPE;
1110: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
1111: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
1104: l_forwarding_address_line2 ghr_pa_requests.forwarding_address_line2%TYPE;
1105: l_forwarding_address_line3 ghr_pa_requests.forwarding_address_line3%TYPE;
1106: l_forwarding_country ghr_pa_requests.forwarding_country%TYPE;
1107: l_forwarding_postal_code ghr_pa_requests.forwarding_postal_code%TYPE;
1108: l_forwarding_region_2 ghr_pa_requests.forwarding_region_2%TYPE;
1109: l_forwarding_town_or_city ghr_pa_requests.forwarding_town_or_city%TYPE;
1110: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
1111: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
1112: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
1105: l_forwarding_address_line3 ghr_pa_requests.forwarding_address_line3%TYPE;
1106: l_forwarding_country ghr_pa_requests.forwarding_country%TYPE;
1107: l_forwarding_postal_code ghr_pa_requests.forwarding_postal_code%TYPE;
1108: l_forwarding_region_2 ghr_pa_requests.forwarding_region_2%TYPE;
1109: l_forwarding_town_or_city ghr_pa_requests.forwarding_town_or_city%TYPE;
1110: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
1111: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
1112: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
1113: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
1106: l_forwarding_country ghr_pa_requests.forwarding_country%TYPE;
1107: l_forwarding_postal_code ghr_pa_requests.forwarding_postal_code%TYPE;
1108: l_forwarding_region_2 ghr_pa_requests.forwarding_region_2%TYPE;
1109: l_forwarding_town_or_city ghr_pa_requests.forwarding_town_or_city%TYPE;
1110: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
1111: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
1112: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
1113: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
1114: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
1107: l_forwarding_postal_code ghr_pa_requests.forwarding_postal_code%TYPE;
1108: l_forwarding_region_2 ghr_pa_requests.forwarding_region_2%TYPE;
1109: l_forwarding_town_or_city ghr_pa_requests.forwarding_town_or_city%TYPE;
1110: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
1111: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
1112: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
1113: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
1114: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
1115: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
1108: l_forwarding_region_2 ghr_pa_requests.forwarding_region_2%TYPE;
1109: l_forwarding_town_or_city ghr_pa_requests.forwarding_town_or_city%TYPE;
1110: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
1111: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
1112: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
1113: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
1114: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
1115: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
1116: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
1109: l_forwarding_town_or_city ghr_pa_requests.forwarding_town_or_city%TYPE;
1110: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
1111: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
1112: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
1113: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
1114: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
1115: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
1116: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
1117: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
1110: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
1111: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
1112: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
1113: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
1114: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
1115: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
1116: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
1117: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
1118: -- FWFA Changes Bug#4444609
1111: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
1112: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
1113: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
1114: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
1115: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
1116: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
1117: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
1118: -- FWFA Changes Bug#4444609
1119: l_input_pay_rate_determinant ghr_pa_requests.input_pay_rate_determinant%TYPE;
1112: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
1113: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
1114: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
1115: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
1116: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
1117: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
1118: -- FWFA Changes Bug#4444609
1119: l_input_pay_rate_determinant ghr_pa_requests.input_pay_rate_determinant%TYPE;
1120: l_from_pay_table_identifier ghr_pa_requests.from_pay_table_identifier%TYPE;
1113: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
1114: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
1115: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
1116: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
1117: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
1118: -- FWFA Changes Bug#4444609
1119: l_input_pay_rate_determinant ghr_pa_requests.input_pay_rate_determinant%TYPE;
1120: l_from_pay_table_identifier ghr_pa_requests.from_pay_table_identifier%TYPE;
1121: -- FWFA Changes
1115: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
1116: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
1117: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
1118: -- FWFA Changes Bug#4444609
1119: l_input_pay_rate_determinant ghr_pa_requests.input_pay_rate_determinant%TYPE;
1120: l_from_pay_table_identifier ghr_pa_requests.from_pay_table_identifier%TYPE;
1121: -- FWFA Changes
1122: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
1123: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
1116: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
1117: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
1118: -- FWFA Changes Bug#4444609
1119: l_input_pay_rate_determinant ghr_pa_requests.input_pay_rate_determinant%TYPE;
1120: l_from_pay_table_identifier ghr_pa_requests.from_pay_table_identifier%TYPE;
1121: -- FWFA Changes
1122: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
1123: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
1124: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
1118: -- FWFA Changes Bug#4444609
1119: l_input_pay_rate_determinant ghr_pa_requests.input_pay_rate_determinant%TYPE;
1120: l_from_pay_table_identifier ghr_pa_requests.from_pay_table_identifier%TYPE;
1121: -- FWFA Changes
1122: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
1123: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
1124: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
1125: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
1126: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
1119: l_input_pay_rate_determinant ghr_pa_requests.input_pay_rate_determinant%TYPE;
1120: l_from_pay_table_identifier ghr_pa_requests.from_pay_table_identifier%TYPE;
1121: -- FWFA Changes
1122: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
1123: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
1124: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
1125: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
1126: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
1127: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
1120: l_from_pay_table_identifier ghr_pa_requests.from_pay_table_identifier%TYPE;
1121: -- FWFA Changes
1122: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
1123: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
1124: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
1125: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
1126: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
1127: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
1128: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
1121: -- FWFA Changes
1122: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
1123: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
1124: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
1125: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
1126: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
1127: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
1128: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
1129: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
1122: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
1123: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
1124: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
1125: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
1126: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
1127: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
1128: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
1129: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
1130: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
1123: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
1124: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
1125: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
1126: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
1127: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
1128: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
1129: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
1130: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
1131: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
1124: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
1125: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
1126: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
1127: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
1128: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
1129: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
1130: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
1131: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
1132: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
1125: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
1126: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
1127: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
1128: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
1129: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
1130: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
1131: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
1132: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
1133: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
1126: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
1127: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
1128: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
1129: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
1130: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
1131: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
1132: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
1133: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
1134: l_functional_class ghr_pa_requests.functional_class%TYPE;
1127: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
1128: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
1129: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
1130: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
1131: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
1132: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
1133: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
1134: l_functional_class ghr_pa_requests.functional_class%TYPE;
1135: l_notepad ghr_pa_requests.notepad%TYPE;
1128: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
1129: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
1130: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
1131: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
1132: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
1133: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
1134: l_functional_class ghr_pa_requests.functional_class%TYPE;
1135: l_notepad ghr_pa_requests.notepad%TYPE;
1136: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
1129: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
1130: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
1131: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
1132: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
1133: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
1134: l_functional_class ghr_pa_requests.functional_class%TYPE;
1135: l_notepad ghr_pa_requests.notepad%TYPE;
1136: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
1137: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
1130: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
1131: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
1132: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
1133: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
1134: l_functional_class ghr_pa_requests.functional_class%TYPE;
1135: l_notepad ghr_pa_requests.notepad%TYPE;
1136: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
1137: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
1138: l_person_id ghr_pa_requests.person_id%TYPE;
1131: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
1132: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
1133: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
1134: l_functional_class ghr_pa_requests.functional_class%TYPE;
1135: l_notepad ghr_pa_requests.notepad%TYPE;
1136: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
1137: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
1138: l_person_id ghr_pa_requests.person_id%TYPE;
1139: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
1132: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
1133: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
1134: l_functional_class ghr_pa_requests.functional_class%TYPE;
1135: l_notepad ghr_pa_requests.notepad%TYPE;
1136: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
1137: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
1138: l_person_id ghr_pa_requests.person_id%TYPE;
1139: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
1140: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
1133: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
1134: l_functional_class ghr_pa_requests.functional_class%TYPE;
1135: l_notepad ghr_pa_requests.notepad%TYPE;
1136: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
1137: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
1138: l_person_id ghr_pa_requests.person_id%TYPE;
1139: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
1140: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
1141: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
1134: l_functional_class ghr_pa_requests.functional_class%TYPE;
1135: l_notepad ghr_pa_requests.notepad%TYPE;
1136: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
1137: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
1138: l_person_id ghr_pa_requests.person_id%TYPE;
1139: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
1140: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
1141: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
1142: l_requested_by_title ghr_pa_requests.requested_by_title%TYPE;
1135: l_notepad ghr_pa_requests.notepad%TYPE;
1136: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
1137: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
1138: l_person_id ghr_pa_requests.person_id%TYPE;
1139: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
1140: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
1141: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
1142: l_requested_by_title ghr_pa_requests.requested_by_title%TYPE;
1143: l_requested_date ghr_pa_requests.requested_date%TYPE;
1136: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
1137: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
1138: l_person_id ghr_pa_requests.person_id%TYPE;
1139: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
1140: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
1141: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
1142: l_requested_by_title ghr_pa_requests.requested_by_title%TYPE;
1143: l_requested_date ghr_pa_requests.requested_date%TYPE;
1144: l_requesting_office_remarks_de ghr_pa_requests.requesting_office_remarks_desc%TYPE;
1137: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
1138: l_person_id ghr_pa_requests.person_id%TYPE;
1139: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
1140: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
1141: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
1142: l_requested_by_title ghr_pa_requests.requested_by_title%TYPE;
1143: l_requested_date ghr_pa_requests.requested_date%TYPE;
1144: l_requesting_office_remarks_de ghr_pa_requests.requesting_office_remarks_desc%TYPE;
1145: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%TYPE;
1138: l_person_id ghr_pa_requests.person_id%TYPE;
1139: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
1140: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
1141: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
1142: l_requested_by_title ghr_pa_requests.requested_by_title%TYPE;
1143: l_requested_date ghr_pa_requests.requested_date%TYPE;
1144: l_requesting_office_remarks_de ghr_pa_requests.requesting_office_remarks_desc%TYPE;
1145: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%TYPE;
1146: l_request_number ghr_pa_requests.request_number%TYPE;
1139: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
1140: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
1141: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
1142: l_requested_by_title ghr_pa_requests.requested_by_title%TYPE;
1143: l_requested_date ghr_pa_requests.requested_date%TYPE;
1144: l_requesting_office_remarks_de ghr_pa_requests.requesting_office_remarks_desc%TYPE;
1145: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%TYPE;
1146: l_request_number ghr_pa_requests.request_number%TYPE;
1147: l_resign_and_retire_reason_des ghr_pa_requests.resign_and_retire_reason_desc%TYPE;
1140: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
1141: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
1142: l_requested_by_title ghr_pa_requests.requested_by_title%TYPE;
1143: l_requested_date ghr_pa_requests.requested_date%TYPE;
1144: l_requesting_office_remarks_de ghr_pa_requests.requesting_office_remarks_desc%TYPE;
1145: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%TYPE;
1146: l_request_number ghr_pa_requests.request_number%TYPE;
1147: l_resign_and_retire_reason_des ghr_pa_requests.resign_and_retire_reason_desc%TYPE;
1148: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
1141: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
1142: l_requested_by_title ghr_pa_requests.requested_by_title%TYPE;
1143: l_requested_date ghr_pa_requests.requested_date%TYPE;
1144: l_requesting_office_remarks_de ghr_pa_requests.requesting_office_remarks_desc%TYPE;
1145: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%TYPE;
1146: l_request_number ghr_pa_requests.request_number%TYPE;
1147: l_resign_and_retire_reason_des ghr_pa_requests.resign_and_retire_reason_desc%TYPE;
1148: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
1149: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
1142: l_requested_by_title ghr_pa_requests.requested_by_title%TYPE;
1143: l_requested_date ghr_pa_requests.requested_date%TYPE;
1144: l_requesting_office_remarks_de ghr_pa_requests.requesting_office_remarks_desc%TYPE;
1145: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%TYPE;
1146: l_request_number ghr_pa_requests.request_number%TYPE;
1147: l_resign_and_retire_reason_des ghr_pa_requests.resign_and_retire_reason_desc%TYPE;
1148: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
1149: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
1150: l_second_action_la_code1 ghr_pa_requests.second_action_la_code1%TYPE;
1143: l_requested_date ghr_pa_requests.requested_date%TYPE;
1144: l_requesting_office_remarks_de ghr_pa_requests.requesting_office_remarks_desc%TYPE;
1145: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%TYPE;
1146: l_request_number ghr_pa_requests.request_number%TYPE;
1147: l_resign_and_retire_reason_des ghr_pa_requests.resign_and_retire_reason_desc%TYPE;
1148: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
1149: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
1150: l_second_action_la_code1 ghr_pa_requests.second_action_la_code1%TYPE;
1151: l_second_action_la_code2 ghr_pa_requests.second_action_la_code2%TYPE;
1144: l_requesting_office_remarks_de ghr_pa_requests.requesting_office_remarks_desc%TYPE;
1145: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%TYPE;
1146: l_request_number ghr_pa_requests.request_number%TYPE;
1147: l_resign_and_retire_reason_des ghr_pa_requests.resign_and_retire_reason_desc%TYPE;
1148: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
1149: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
1150: l_second_action_la_code1 ghr_pa_requests.second_action_la_code1%TYPE;
1151: l_second_action_la_code2 ghr_pa_requests.second_action_la_code2%TYPE;
1152: l_second_action_la_desc1 ghr_pa_requests.second_action_la_desc1%TYPE;
1145: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%TYPE;
1146: l_request_number ghr_pa_requests.request_number%TYPE;
1147: l_resign_and_retire_reason_des ghr_pa_requests.resign_and_retire_reason_desc%TYPE;
1148: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
1149: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
1150: l_second_action_la_code1 ghr_pa_requests.second_action_la_code1%TYPE;
1151: l_second_action_la_code2 ghr_pa_requests.second_action_la_code2%TYPE;
1152: l_second_action_la_desc1 ghr_pa_requests.second_action_la_desc1%TYPE;
1153: l_second_action_la_desc2 ghr_pa_requests.second_action_la_desc2%TYPE;
1146: l_request_number ghr_pa_requests.request_number%TYPE;
1147: l_resign_and_retire_reason_des ghr_pa_requests.resign_and_retire_reason_desc%TYPE;
1148: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
1149: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
1150: l_second_action_la_code1 ghr_pa_requests.second_action_la_code1%TYPE;
1151: l_second_action_la_code2 ghr_pa_requests.second_action_la_code2%TYPE;
1152: l_second_action_la_desc1 ghr_pa_requests.second_action_la_desc1%TYPE;
1153: l_second_action_la_desc2 ghr_pa_requests.second_action_la_desc2%TYPE;
1154: l_second_noa_cancel_or_correct ghr_pa_requests.second_noa_cancel_or_correct%TYPE;
1147: l_resign_and_retire_reason_des ghr_pa_requests.resign_and_retire_reason_desc%TYPE;
1148: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
1149: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
1150: l_second_action_la_code1 ghr_pa_requests.second_action_la_code1%TYPE;
1151: l_second_action_la_code2 ghr_pa_requests.second_action_la_code2%TYPE;
1152: l_second_action_la_desc1 ghr_pa_requests.second_action_la_desc1%TYPE;
1153: l_second_action_la_desc2 ghr_pa_requests.second_action_la_desc2%TYPE;
1154: l_second_noa_cancel_or_correct ghr_pa_requests.second_noa_cancel_or_correct%TYPE;
1155: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
1148: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
1149: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
1150: l_second_action_la_code1 ghr_pa_requests.second_action_la_code1%TYPE;
1151: l_second_action_la_code2 ghr_pa_requests.second_action_la_code2%TYPE;
1152: l_second_action_la_desc1 ghr_pa_requests.second_action_la_desc1%TYPE;
1153: l_second_action_la_desc2 ghr_pa_requests.second_action_la_desc2%TYPE;
1154: l_second_noa_cancel_or_correct ghr_pa_requests.second_noa_cancel_or_correct%TYPE;
1155: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
1156: l_second_noa_desc ghr_pa_requests.second_noa_desc%TYPE;
1149: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
1150: l_second_action_la_code1 ghr_pa_requests.second_action_la_code1%TYPE;
1151: l_second_action_la_code2 ghr_pa_requests.second_action_la_code2%TYPE;
1152: l_second_action_la_desc1 ghr_pa_requests.second_action_la_desc1%TYPE;
1153: l_second_action_la_desc2 ghr_pa_requests.second_action_la_desc2%TYPE;
1154: l_second_noa_cancel_or_correct ghr_pa_requests.second_noa_cancel_or_correct%TYPE;
1155: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
1156: l_second_noa_desc ghr_pa_requests.second_noa_desc%TYPE;
1157: l_second_noa_id ghr_pa_requests.second_noa_id%TYPE;
1150: l_second_action_la_code1 ghr_pa_requests.second_action_la_code1%TYPE;
1151: l_second_action_la_code2 ghr_pa_requests.second_action_la_code2%TYPE;
1152: l_second_action_la_desc1 ghr_pa_requests.second_action_la_desc1%TYPE;
1153: l_second_action_la_desc2 ghr_pa_requests.second_action_la_desc2%TYPE;
1154: l_second_noa_cancel_or_correct ghr_pa_requests.second_noa_cancel_or_correct%TYPE;
1155: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
1156: l_second_noa_desc ghr_pa_requests.second_noa_desc%TYPE;
1157: l_second_noa_id ghr_pa_requests.second_noa_id%TYPE;
1158: l_second_noa_pa_request_id ghr_pa_requests.second_noa_pa_request_id%TYPE;
1151: l_second_action_la_code2 ghr_pa_requests.second_action_la_code2%TYPE;
1152: l_second_action_la_desc1 ghr_pa_requests.second_action_la_desc1%TYPE;
1153: l_second_action_la_desc2 ghr_pa_requests.second_action_la_desc2%TYPE;
1154: l_second_noa_cancel_or_correct ghr_pa_requests.second_noa_cancel_or_correct%TYPE;
1155: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
1156: l_second_noa_desc ghr_pa_requests.second_noa_desc%TYPE;
1157: l_second_noa_id ghr_pa_requests.second_noa_id%TYPE;
1158: l_second_noa_pa_request_id ghr_pa_requests.second_noa_pa_request_id%TYPE;
1159: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
1152: l_second_action_la_desc1 ghr_pa_requests.second_action_la_desc1%TYPE;
1153: l_second_action_la_desc2 ghr_pa_requests.second_action_la_desc2%TYPE;
1154: l_second_noa_cancel_or_correct ghr_pa_requests.second_noa_cancel_or_correct%TYPE;
1155: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
1156: l_second_noa_desc ghr_pa_requests.second_noa_desc%TYPE;
1157: l_second_noa_id ghr_pa_requests.second_noa_id%TYPE;
1158: l_second_noa_pa_request_id ghr_pa_requests.second_noa_pa_request_id%TYPE;
1159: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
1160: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
1153: l_second_action_la_desc2 ghr_pa_requests.second_action_la_desc2%TYPE;
1154: l_second_noa_cancel_or_correct ghr_pa_requests.second_noa_cancel_or_correct%TYPE;
1155: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
1156: l_second_noa_desc ghr_pa_requests.second_noa_desc%TYPE;
1157: l_second_noa_id ghr_pa_requests.second_noa_id%TYPE;
1158: l_second_noa_pa_request_id ghr_pa_requests.second_noa_pa_request_id%TYPE;
1159: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
1160: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
1161: l_tenure ghr_pa_requests.tenure%TYPE;
1154: l_second_noa_cancel_or_correct ghr_pa_requests.second_noa_cancel_or_correct%TYPE;
1155: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
1156: l_second_noa_desc ghr_pa_requests.second_noa_desc%TYPE;
1157: l_second_noa_id ghr_pa_requests.second_noa_id%TYPE;
1158: l_second_noa_pa_request_id ghr_pa_requests.second_noa_pa_request_id%TYPE;
1159: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
1160: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
1161: l_tenure ghr_pa_requests.tenure%TYPE;
1162: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
1155: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
1156: l_second_noa_desc ghr_pa_requests.second_noa_desc%TYPE;
1157: l_second_noa_id ghr_pa_requests.second_noa_id%TYPE;
1158: l_second_noa_pa_request_id ghr_pa_requests.second_noa_pa_request_id%TYPE;
1159: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
1160: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
1161: l_tenure ghr_pa_requests.tenure%TYPE;
1162: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
1163: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
1156: l_second_noa_desc ghr_pa_requests.second_noa_desc%TYPE;
1157: l_second_noa_id ghr_pa_requests.second_noa_id%TYPE;
1158: l_second_noa_pa_request_id ghr_pa_requests.second_noa_pa_request_id%TYPE;
1159: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
1160: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
1161: l_tenure ghr_pa_requests.tenure%TYPE;
1162: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
1163: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
1164: l_to_grade_id ghr_pa_requests.to_grade_id%TYPE;
1157: l_second_noa_id ghr_pa_requests.second_noa_id%TYPE;
1158: l_second_noa_pa_request_id ghr_pa_requests.second_noa_pa_request_id%TYPE;
1159: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
1160: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
1161: l_tenure ghr_pa_requests.tenure%TYPE;
1162: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
1163: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
1164: l_to_grade_id ghr_pa_requests.to_grade_id%TYPE;
1165: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%TYPE;
1158: l_second_noa_pa_request_id ghr_pa_requests.second_noa_pa_request_id%TYPE;
1159: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
1160: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
1161: l_tenure ghr_pa_requests.tenure%TYPE;
1162: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
1163: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
1164: l_to_grade_id ghr_pa_requests.to_grade_id%TYPE;
1165: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%TYPE;
1166: l_to_job_id ghr_pa_requests.to_job_id%TYPE;
1159: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
1160: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
1161: l_tenure ghr_pa_requests.tenure%TYPE;
1162: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
1163: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
1164: l_to_grade_id ghr_pa_requests.to_grade_id%TYPE;
1165: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%TYPE;
1166: l_to_job_id ghr_pa_requests.to_job_id%TYPE;
1167: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
1160: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
1161: l_tenure ghr_pa_requests.tenure%TYPE;
1162: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
1163: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
1164: l_to_grade_id ghr_pa_requests.to_grade_id%TYPE;
1165: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%TYPE;
1166: l_to_job_id ghr_pa_requests.to_job_id%TYPE;
1167: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
1168: l_to_occ_code ghr_pa_requests.to_occ_code%TYPE;
1161: l_tenure ghr_pa_requests.tenure%TYPE;
1162: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
1163: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
1164: l_to_grade_id ghr_pa_requests.to_grade_id%TYPE;
1165: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%TYPE;
1166: l_to_job_id ghr_pa_requests.to_job_id%TYPE;
1167: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
1168: l_to_occ_code ghr_pa_requests.to_occ_code%TYPE;
1169: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
1162: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
1163: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
1164: l_to_grade_id ghr_pa_requests.to_grade_id%TYPE;
1165: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%TYPE;
1166: l_to_job_id ghr_pa_requests.to_job_id%TYPE;
1167: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
1168: l_to_occ_code ghr_pa_requests.to_occ_code%TYPE;
1169: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
1170: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
1163: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
1164: l_to_grade_id ghr_pa_requests.to_grade_id%TYPE;
1165: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%TYPE;
1166: l_to_job_id ghr_pa_requests.to_job_id%TYPE;
1167: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
1168: l_to_occ_code ghr_pa_requests.to_occ_code%TYPE;
1169: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
1170: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
1171: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1164: l_to_grade_id ghr_pa_requests.to_grade_id%TYPE;
1165: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%TYPE;
1166: l_to_job_id ghr_pa_requests.to_job_id%TYPE;
1167: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
1168: l_to_occ_code ghr_pa_requests.to_occ_code%TYPE;
1169: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
1170: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
1171: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1172: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1165: l_to_grade_or_level ghr_pa_requests.to_grade_or_level%TYPE;
1166: l_to_job_id ghr_pa_requests.to_job_id%TYPE;
1167: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
1168: l_to_occ_code ghr_pa_requests.to_occ_code%TYPE;
1169: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
1170: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
1171: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1172: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1173: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
1166: l_to_job_id ghr_pa_requests.to_job_id%TYPE;
1167: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
1168: l_to_occ_code ghr_pa_requests.to_occ_code%TYPE;
1169: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
1170: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
1171: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1172: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1173: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
1174: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
1167: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
1168: l_to_occ_code ghr_pa_requests.to_occ_code%TYPE;
1169: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
1170: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
1171: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1172: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1173: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
1174: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
1175: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
1168: l_to_occ_code ghr_pa_requests.to_occ_code%TYPE;
1169: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
1170: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
1171: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1172: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1173: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
1174: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
1175: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
1176: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
1169: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
1170: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
1171: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1172: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1173: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
1174: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
1175: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
1176: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
1177: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
1170: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
1171: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1172: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1173: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
1174: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
1175: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
1176: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
1177: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
1178: l_to_pay_basis ghr_pa_requests.to_pay_basis%TYPE;
1171: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1172: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1173: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
1174: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
1175: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
1176: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
1177: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
1178: l_to_pay_basis ghr_pa_requests.to_pay_basis%TYPE;
1179: l_to_pay_plan ghr_pa_requests.to_pay_plan%TYPE;
1172: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1173: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
1174: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
1175: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
1176: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
1177: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
1178: l_to_pay_basis ghr_pa_requests.to_pay_basis%TYPE;
1179: l_to_pay_plan ghr_pa_requests.to_pay_plan%TYPE;
1180: -- FWFA Changes Bug 4444609
1173: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
1174: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
1175: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
1176: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
1177: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
1178: l_to_pay_basis ghr_pa_requests.to_pay_basis%TYPE;
1179: l_to_pay_plan ghr_pa_requests.to_pay_plan%TYPE;
1180: -- FWFA Changes Bug 4444609
1181: l_to_pay_table_identifier ghr_pa_requests.to_pay_table_identifier%TYPE;
1174: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
1175: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
1176: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
1177: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
1178: l_to_pay_basis ghr_pa_requests.to_pay_basis%TYPE;
1179: l_to_pay_plan ghr_pa_requests.to_pay_plan%TYPE;
1180: -- FWFA Changes Bug 4444609
1181: l_to_pay_table_identifier ghr_pa_requests.to_pay_table_identifier%TYPE;
1182: -- FWFA Changes
1175: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
1176: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
1177: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
1178: l_to_pay_basis ghr_pa_requests.to_pay_basis%TYPE;
1179: l_to_pay_plan ghr_pa_requests.to_pay_plan%TYPE;
1180: -- FWFA Changes Bug 4444609
1181: l_to_pay_table_identifier ghr_pa_requests.to_pay_table_identifier%TYPE;
1182: -- FWFA Changes
1183: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
1177: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
1178: l_to_pay_basis ghr_pa_requests.to_pay_basis%TYPE;
1179: l_to_pay_plan ghr_pa_requests.to_pay_plan%TYPE;
1180: -- FWFA Changes Bug 4444609
1181: l_to_pay_table_identifier ghr_pa_requests.to_pay_table_identifier%TYPE;
1182: -- FWFA Changes
1183: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
1184: l_to_position_org_line1 ghr_pa_requests.to_position_org_line1%TYPE;
1185: l_to_position_org_line2 ghr_pa_requests.to_position_org_line2%TYPE;
1179: l_to_pay_plan ghr_pa_requests.to_pay_plan%TYPE;
1180: -- FWFA Changes Bug 4444609
1181: l_to_pay_table_identifier ghr_pa_requests.to_pay_table_identifier%TYPE;
1182: -- FWFA Changes
1183: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
1184: l_to_position_org_line1 ghr_pa_requests.to_position_org_line1%TYPE;
1185: l_to_position_org_line2 ghr_pa_requests.to_position_org_line2%TYPE;
1186: l_to_position_org_line3 ghr_pa_requests.to_position_org_line3%TYPE;
1187: l_to_position_org_line4 ghr_pa_requests.to_position_org_line4%TYPE;
1180: -- FWFA Changes Bug 4444609
1181: l_to_pay_table_identifier ghr_pa_requests.to_pay_table_identifier%TYPE;
1182: -- FWFA Changes
1183: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
1184: l_to_position_org_line1 ghr_pa_requests.to_position_org_line1%TYPE;
1185: l_to_position_org_line2 ghr_pa_requests.to_position_org_line2%TYPE;
1186: l_to_position_org_line3 ghr_pa_requests.to_position_org_line3%TYPE;
1187: l_to_position_org_line4 ghr_pa_requests.to_position_org_line4%TYPE;
1188: l_to_position_org_line5 ghr_pa_requests.to_position_org_line5%TYPE;
1181: l_to_pay_table_identifier ghr_pa_requests.to_pay_table_identifier%TYPE;
1182: -- FWFA Changes
1183: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
1184: l_to_position_org_line1 ghr_pa_requests.to_position_org_line1%TYPE;
1185: l_to_position_org_line2 ghr_pa_requests.to_position_org_line2%TYPE;
1186: l_to_position_org_line3 ghr_pa_requests.to_position_org_line3%TYPE;
1187: l_to_position_org_line4 ghr_pa_requests.to_position_org_line4%TYPE;
1188: l_to_position_org_line5 ghr_pa_requests.to_position_org_line5%TYPE;
1189: l_to_position_org_line6 ghr_pa_requests.to_position_org_line6%TYPE;
1182: -- FWFA Changes
1183: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
1184: l_to_position_org_line1 ghr_pa_requests.to_position_org_line1%TYPE;
1185: l_to_position_org_line2 ghr_pa_requests.to_position_org_line2%TYPE;
1186: l_to_position_org_line3 ghr_pa_requests.to_position_org_line3%TYPE;
1187: l_to_position_org_line4 ghr_pa_requests.to_position_org_line4%TYPE;
1188: l_to_position_org_line5 ghr_pa_requests.to_position_org_line5%TYPE;
1189: l_to_position_org_line6 ghr_pa_requests.to_position_org_line6%TYPE;
1190: l_to_position_number ghr_pa_requests.to_position_number%TYPE;
1183: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
1184: l_to_position_org_line1 ghr_pa_requests.to_position_org_line1%TYPE;
1185: l_to_position_org_line2 ghr_pa_requests.to_position_org_line2%TYPE;
1186: l_to_position_org_line3 ghr_pa_requests.to_position_org_line3%TYPE;
1187: l_to_position_org_line4 ghr_pa_requests.to_position_org_line4%TYPE;
1188: l_to_position_org_line5 ghr_pa_requests.to_position_org_line5%TYPE;
1189: l_to_position_org_line6 ghr_pa_requests.to_position_org_line6%TYPE;
1190: l_to_position_number ghr_pa_requests.to_position_number%TYPE;
1191: l_to_position_seq_no ghr_pa_requests.to_position_seq_no%TYPE;
1184: l_to_position_org_line1 ghr_pa_requests.to_position_org_line1%TYPE;
1185: l_to_position_org_line2 ghr_pa_requests.to_position_org_line2%TYPE;
1186: l_to_position_org_line3 ghr_pa_requests.to_position_org_line3%TYPE;
1187: l_to_position_org_line4 ghr_pa_requests.to_position_org_line4%TYPE;
1188: l_to_position_org_line5 ghr_pa_requests.to_position_org_line5%TYPE;
1189: l_to_position_org_line6 ghr_pa_requests.to_position_org_line6%TYPE;
1190: l_to_position_number ghr_pa_requests.to_position_number%TYPE;
1191: l_to_position_seq_no ghr_pa_requests.to_position_seq_no%TYPE;
1192: l_to_position_title ghr_pa_requests.to_position_title%TYPE;
1185: l_to_position_org_line2 ghr_pa_requests.to_position_org_line2%TYPE;
1186: l_to_position_org_line3 ghr_pa_requests.to_position_org_line3%TYPE;
1187: l_to_position_org_line4 ghr_pa_requests.to_position_org_line4%TYPE;
1188: l_to_position_org_line5 ghr_pa_requests.to_position_org_line5%TYPE;
1189: l_to_position_org_line6 ghr_pa_requests.to_position_org_line6%TYPE;
1190: l_to_position_number ghr_pa_requests.to_position_number%TYPE;
1191: l_to_position_seq_no ghr_pa_requests.to_position_seq_no%TYPE;
1192: l_to_position_title ghr_pa_requests.to_position_title%TYPE;
1193: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
1186: l_to_position_org_line3 ghr_pa_requests.to_position_org_line3%TYPE;
1187: l_to_position_org_line4 ghr_pa_requests.to_position_org_line4%TYPE;
1188: l_to_position_org_line5 ghr_pa_requests.to_position_org_line5%TYPE;
1189: l_to_position_org_line6 ghr_pa_requests.to_position_org_line6%TYPE;
1190: l_to_position_number ghr_pa_requests.to_position_number%TYPE;
1191: l_to_position_seq_no ghr_pa_requests.to_position_seq_no%TYPE;
1192: l_to_position_title ghr_pa_requests.to_position_title%TYPE;
1193: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
1194: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
1187: l_to_position_org_line4 ghr_pa_requests.to_position_org_line4%TYPE;
1188: l_to_position_org_line5 ghr_pa_requests.to_position_org_line5%TYPE;
1189: l_to_position_org_line6 ghr_pa_requests.to_position_org_line6%TYPE;
1190: l_to_position_number ghr_pa_requests.to_position_number%TYPE;
1191: l_to_position_seq_no ghr_pa_requests.to_position_seq_no%TYPE;
1192: l_to_position_title ghr_pa_requests.to_position_title%TYPE;
1193: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
1194: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
1195: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
1188: l_to_position_org_line5 ghr_pa_requests.to_position_org_line5%TYPE;
1189: l_to_position_org_line6 ghr_pa_requests.to_position_org_line6%TYPE;
1190: l_to_position_number ghr_pa_requests.to_position_number%TYPE;
1191: l_to_position_seq_no ghr_pa_requests.to_position_seq_no%TYPE;
1192: l_to_position_title ghr_pa_requests.to_position_title%TYPE;
1193: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
1194: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
1195: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
1196: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
1189: l_to_position_org_line6 ghr_pa_requests.to_position_org_line6%TYPE;
1190: l_to_position_number ghr_pa_requests.to_position_number%TYPE;
1191: l_to_position_seq_no ghr_pa_requests.to_position_seq_no%TYPE;
1192: l_to_position_title ghr_pa_requests.to_position_title%TYPE;
1193: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
1194: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
1195: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
1196: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
1197: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
1190: l_to_position_number ghr_pa_requests.to_position_number%TYPE;
1191: l_to_position_seq_no ghr_pa_requests.to_position_seq_no%TYPE;
1192: l_to_position_title ghr_pa_requests.to_position_title%TYPE;
1193: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
1194: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
1195: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
1196: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
1197: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
1198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
1191: l_to_position_seq_no ghr_pa_requests.to_position_seq_no%TYPE;
1192: l_to_position_title ghr_pa_requests.to_position_title%TYPE;
1193: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
1194: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
1195: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
1196: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
1197: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
1198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
1199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
1192: l_to_position_title ghr_pa_requests.to_position_title%TYPE;
1193: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
1194: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
1195: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
1196: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
1197: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
1198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
1199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
1200: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
1193: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
1194: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
1195: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
1196: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
1197: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
1198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
1199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
1200: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
1201: l_first_noa_information1 ghr_pa_requests.first_noa_information1%TYPE;
1194: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
1195: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
1196: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
1197: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
1198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
1199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
1200: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
1201: l_first_noa_information1 ghr_pa_requests.first_noa_information1%TYPE;
1202: l_first_noa_information2 ghr_pa_requests.first_noa_information2%TYPE;
1195: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
1196: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
1197: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
1198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
1199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
1200: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
1201: l_first_noa_information1 ghr_pa_requests.first_noa_information1%TYPE;
1202: l_first_noa_information2 ghr_pa_requests.first_noa_information2%TYPE;
1203: l_first_noa_information3 ghr_pa_requests.first_noa_information3%TYPE;
1196: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
1197: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
1198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
1199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
1200: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
1201: l_first_noa_information1 ghr_pa_requests.first_noa_information1%TYPE;
1202: l_first_noa_information2 ghr_pa_requests.first_noa_information2%TYPE;
1203: l_first_noa_information3 ghr_pa_requests.first_noa_information3%TYPE;
1204: l_first_noa_information4 ghr_pa_requests.first_noa_information4%TYPE;
1197: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
1198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
1199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
1200: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
1201: l_first_noa_information1 ghr_pa_requests.first_noa_information1%TYPE;
1202: l_first_noa_information2 ghr_pa_requests.first_noa_information2%TYPE;
1203: l_first_noa_information3 ghr_pa_requests.first_noa_information3%TYPE;
1204: l_first_noa_information4 ghr_pa_requests.first_noa_information4%TYPE;
1205: l_first_noa_information5 ghr_pa_requests.first_noa_information5%TYPE;
1198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
1199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
1200: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
1201: l_first_noa_information1 ghr_pa_requests.first_noa_information1%TYPE;
1202: l_first_noa_information2 ghr_pa_requests.first_noa_information2%TYPE;
1203: l_first_noa_information3 ghr_pa_requests.first_noa_information3%TYPE;
1204: l_first_noa_information4 ghr_pa_requests.first_noa_information4%TYPE;
1205: l_first_noa_information5 ghr_pa_requests.first_noa_information5%TYPE;
1206: l_second_lac1_information1 ghr_pa_requests.second_lac1_information1%TYPE;
1199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
1200: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
1201: l_first_noa_information1 ghr_pa_requests.first_noa_information1%TYPE;
1202: l_first_noa_information2 ghr_pa_requests.first_noa_information2%TYPE;
1203: l_first_noa_information3 ghr_pa_requests.first_noa_information3%TYPE;
1204: l_first_noa_information4 ghr_pa_requests.first_noa_information4%TYPE;
1205: l_first_noa_information5 ghr_pa_requests.first_noa_information5%TYPE;
1206: l_second_lac1_information1 ghr_pa_requests.second_lac1_information1%TYPE;
1207: l_second_lac1_information2 ghr_pa_requests.second_lac1_information2%TYPE;
1200: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
1201: l_first_noa_information1 ghr_pa_requests.first_noa_information1%TYPE;
1202: l_first_noa_information2 ghr_pa_requests.first_noa_information2%TYPE;
1203: l_first_noa_information3 ghr_pa_requests.first_noa_information3%TYPE;
1204: l_first_noa_information4 ghr_pa_requests.first_noa_information4%TYPE;
1205: l_first_noa_information5 ghr_pa_requests.first_noa_information5%TYPE;
1206: l_second_lac1_information1 ghr_pa_requests.second_lac1_information1%TYPE;
1207: l_second_lac1_information2 ghr_pa_requests.second_lac1_information2%TYPE;
1208: l_second_lac1_information3 ghr_pa_requests.second_lac1_information3%TYPE;
1201: l_first_noa_information1 ghr_pa_requests.first_noa_information1%TYPE;
1202: l_first_noa_information2 ghr_pa_requests.first_noa_information2%TYPE;
1203: l_first_noa_information3 ghr_pa_requests.first_noa_information3%TYPE;
1204: l_first_noa_information4 ghr_pa_requests.first_noa_information4%TYPE;
1205: l_first_noa_information5 ghr_pa_requests.first_noa_information5%TYPE;
1206: l_second_lac1_information1 ghr_pa_requests.second_lac1_information1%TYPE;
1207: l_second_lac1_information2 ghr_pa_requests.second_lac1_information2%TYPE;
1208: l_second_lac1_information3 ghr_pa_requests.second_lac1_information3%TYPE;
1209: l_second_lac1_information4 ghr_pa_requests.second_lac1_information4%TYPE;
1202: l_first_noa_information2 ghr_pa_requests.first_noa_information2%TYPE;
1203: l_first_noa_information3 ghr_pa_requests.first_noa_information3%TYPE;
1204: l_first_noa_information4 ghr_pa_requests.first_noa_information4%TYPE;
1205: l_first_noa_information5 ghr_pa_requests.first_noa_information5%TYPE;
1206: l_second_lac1_information1 ghr_pa_requests.second_lac1_information1%TYPE;
1207: l_second_lac1_information2 ghr_pa_requests.second_lac1_information2%TYPE;
1208: l_second_lac1_information3 ghr_pa_requests.second_lac1_information3%TYPE;
1209: l_second_lac1_information4 ghr_pa_requests.second_lac1_information4%TYPE;
1210: l_second_lac1_information5 ghr_pa_requests.second_lac1_information5%TYPE;
1203: l_first_noa_information3 ghr_pa_requests.first_noa_information3%TYPE;
1204: l_first_noa_information4 ghr_pa_requests.first_noa_information4%TYPE;
1205: l_first_noa_information5 ghr_pa_requests.first_noa_information5%TYPE;
1206: l_second_lac1_information1 ghr_pa_requests.second_lac1_information1%TYPE;
1207: l_second_lac1_information2 ghr_pa_requests.second_lac1_information2%TYPE;
1208: l_second_lac1_information3 ghr_pa_requests.second_lac1_information3%TYPE;
1209: l_second_lac1_information4 ghr_pa_requests.second_lac1_information4%TYPE;
1210: l_second_lac1_information5 ghr_pa_requests.second_lac1_information5%TYPE;
1211: l_second_lac2_information1 ghr_pa_requests.second_lac2_information1%TYPE;
1204: l_first_noa_information4 ghr_pa_requests.first_noa_information4%TYPE;
1205: l_first_noa_information5 ghr_pa_requests.first_noa_information5%TYPE;
1206: l_second_lac1_information1 ghr_pa_requests.second_lac1_information1%TYPE;
1207: l_second_lac1_information2 ghr_pa_requests.second_lac1_information2%TYPE;
1208: l_second_lac1_information3 ghr_pa_requests.second_lac1_information3%TYPE;
1209: l_second_lac1_information4 ghr_pa_requests.second_lac1_information4%TYPE;
1210: l_second_lac1_information5 ghr_pa_requests.second_lac1_information5%TYPE;
1211: l_second_lac2_information1 ghr_pa_requests.second_lac2_information1%TYPE;
1212: l_second_lac2_information2 ghr_pa_requests.second_lac2_information2%TYPE;
1205: l_first_noa_information5 ghr_pa_requests.first_noa_information5%TYPE;
1206: l_second_lac1_information1 ghr_pa_requests.second_lac1_information1%TYPE;
1207: l_second_lac1_information2 ghr_pa_requests.second_lac1_information2%TYPE;
1208: l_second_lac1_information3 ghr_pa_requests.second_lac1_information3%TYPE;
1209: l_second_lac1_information4 ghr_pa_requests.second_lac1_information4%TYPE;
1210: l_second_lac1_information5 ghr_pa_requests.second_lac1_information5%TYPE;
1211: l_second_lac2_information1 ghr_pa_requests.second_lac2_information1%TYPE;
1212: l_second_lac2_information2 ghr_pa_requests.second_lac2_information2%TYPE;
1213: l_second_lac2_information3 ghr_pa_requests.second_lac2_information3%TYPE;
1206: l_second_lac1_information1 ghr_pa_requests.second_lac1_information1%TYPE;
1207: l_second_lac1_information2 ghr_pa_requests.second_lac1_information2%TYPE;
1208: l_second_lac1_information3 ghr_pa_requests.second_lac1_information3%TYPE;
1209: l_second_lac1_information4 ghr_pa_requests.second_lac1_information4%TYPE;
1210: l_second_lac1_information5 ghr_pa_requests.second_lac1_information5%TYPE;
1211: l_second_lac2_information1 ghr_pa_requests.second_lac2_information1%TYPE;
1212: l_second_lac2_information2 ghr_pa_requests.second_lac2_information2%TYPE;
1213: l_second_lac2_information3 ghr_pa_requests.second_lac2_information3%TYPE;
1214: l_second_lac2_information4 ghr_pa_requests.second_lac2_information4%TYPE;
1207: l_second_lac1_information2 ghr_pa_requests.second_lac1_information2%TYPE;
1208: l_second_lac1_information3 ghr_pa_requests.second_lac1_information3%TYPE;
1209: l_second_lac1_information4 ghr_pa_requests.second_lac1_information4%TYPE;
1210: l_second_lac1_information5 ghr_pa_requests.second_lac1_information5%TYPE;
1211: l_second_lac2_information1 ghr_pa_requests.second_lac2_information1%TYPE;
1212: l_second_lac2_information2 ghr_pa_requests.second_lac2_information2%TYPE;
1213: l_second_lac2_information3 ghr_pa_requests.second_lac2_information3%TYPE;
1214: l_second_lac2_information4 ghr_pa_requests.second_lac2_information4%TYPE;
1215: l_second_lac2_information5 ghr_pa_requests.second_lac2_information5%TYPE;
1208: l_second_lac1_information3 ghr_pa_requests.second_lac1_information3%TYPE;
1209: l_second_lac1_information4 ghr_pa_requests.second_lac1_information4%TYPE;
1210: l_second_lac1_information5 ghr_pa_requests.second_lac1_information5%TYPE;
1211: l_second_lac2_information1 ghr_pa_requests.second_lac2_information1%TYPE;
1212: l_second_lac2_information2 ghr_pa_requests.second_lac2_information2%TYPE;
1213: l_second_lac2_information3 ghr_pa_requests.second_lac2_information3%TYPE;
1214: l_second_lac2_information4 ghr_pa_requests.second_lac2_information4%TYPE;
1215: l_second_lac2_information5 ghr_pa_requests.second_lac2_information5%TYPE;
1216: l_second_noa_information1 ghr_pa_requests.second_noa_information1%TYPE;
1209: l_second_lac1_information4 ghr_pa_requests.second_lac1_information4%TYPE;
1210: l_second_lac1_information5 ghr_pa_requests.second_lac1_information5%TYPE;
1211: l_second_lac2_information1 ghr_pa_requests.second_lac2_information1%TYPE;
1212: l_second_lac2_information2 ghr_pa_requests.second_lac2_information2%TYPE;
1213: l_second_lac2_information3 ghr_pa_requests.second_lac2_information3%TYPE;
1214: l_second_lac2_information4 ghr_pa_requests.second_lac2_information4%TYPE;
1215: l_second_lac2_information5 ghr_pa_requests.second_lac2_information5%TYPE;
1216: l_second_noa_information1 ghr_pa_requests.second_noa_information1%TYPE;
1217: l_second_noa_information2 ghr_pa_requests.second_noa_information2%TYPE;
1210: l_second_lac1_information5 ghr_pa_requests.second_lac1_information5%TYPE;
1211: l_second_lac2_information1 ghr_pa_requests.second_lac2_information1%TYPE;
1212: l_second_lac2_information2 ghr_pa_requests.second_lac2_information2%TYPE;
1213: l_second_lac2_information3 ghr_pa_requests.second_lac2_information3%TYPE;
1214: l_second_lac2_information4 ghr_pa_requests.second_lac2_information4%TYPE;
1215: l_second_lac2_information5 ghr_pa_requests.second_lac2_information5%TYPE;
1216: l_second_noa_information1 ghr_pa_requests.second_noa_information1%TYPE;
1217: l_second_noa_information2 ghr_pa_requests.second_noa_information2%TYPE;
1218: l_second_noa_information3 ghr_pa_requests.second_noa_information3%TYPE;
1211: l_second_lac2_information1 ghr_pa_requests.second_lac2_information1%TYPE;
1212: l_second_lac2_information2 ghr_pa_requests.second_lac2_information2%TYPE;
1213: l_second_lac2_information3 ghr_pa_requests.second_lac2_information3%TYPE;
1214: l_second_lac2_information4 ghr_pa_requests.second_lac2_information4%TYPE;
1215: l_second_lac2_information5 ghr_pa_requests.second_lac2_information5%TYPE;
1216: l_second_noa_information1 ghr_pa_requests.second_noa_information1%TYPE;
1217: l_second_noa_information2 ghr_pa_requests.second_noa_information2%TYPE;
1218: l_second_noa_information3 ghr_pa_requests.second_noa_information3%TYPE;
1219: l_second_noa_information4 ghr_pa_requests.second_noa_information4%TYPE;
1212: l_second_lac2_information2 ghr_pa_requests.second_lac2_information2%TYPE;
1213: l_second_lac2_information3 ghr_pa_requests.second_lac2_information3%TYPE;
1214: l_second_lac2_information4 ghr_pa_requests.second_lac2_information4%TYPE;
1215: l_second_lac2_information5 ghr_pa_requests.second_lac2_information5%TYPE;
1216: l_second_noa_information1 ghr_pa_requests.second_noa_information1%TYPE;
1217: l_second_noa_information2 ghr_pa_requests.second_noa_information2%TYPE;
1218: l_second_noa_information3 ghr_pa_requests.second_noa_information3%TYPE;
1219: l_second_noa_information4 ghr_pa_requests.second_noa_information4%TYPE;
1220: l_second_noa_information5 ghr_pa_requests.second_noa_information5%TYPE;
1213: l_second_lac2_information3 ghr_pa_requests.second_lac2_information3%TYPE;
1214: l_second_lac2_information4 ghr_pa_requests.second_lac2_information4%TYPE;
1215: l_second_lac2_information5 ghr_pa_requests.second_lac2_information5%TYPE;
1216: l_second_noa_information1 ghr_pa_requests.second_noa_information1%TYPE;
1217: l_second_noa_information2 ghr_pa_requests.second_noa_information2%TYPE;
1218: l_second_noa_information3 ghr_pa_requests.second_noa_information3%TYPE;
1219: l_second_noa_information4 ghr_pa_requests.second_noa_information4%TYPE;
1220: l_second_noa_information5 ghr_pa_requests.second_noa_information5%TYPE;
1221: l_first_lac1_information1 ghr_pa_requests.first_lac1_information1%TYPE;
1214: l_second_lac2_information4 ghr_pa_requests.second_lac2_information4%TYPE;
1215: l_second_lac2_information5 ghr_pa_requests.second_lac2_information5%TYPE;
1216: l_second_noa_information1 ghr_pa_requests.second_noa_information1%TYPE;
1217: l_second_noa_information2 ghr_pa_requests.second_noa_information2%TYPE;
1218: l_second_noa_information3 ghr_pa_requests.second_noa_information3%TYPE;
1219: l_second_noa_information4 ghr_pa_requests.second_noa_information4%TYPE;
1220: l_second_noa_information5 ghr_pa_requests.second_noa_information5%TYPE;
1221: l_first_lac1_information1 ghr_pa_requests.first_lac1_information1%TYPE;
1222: l_first_lac1_information2 ghr_pa_requests.first_lac1_information2%TYPE;
1215: l_second_lac2_information5 ghr_pa_requests.second_lac2_information5%TYPE;
1216: l_second_noa_information1 ghr_pa_requests.second_noa_information1%TYPE;
1217: l_second_noa_information2 ghr_pa_requests.second_noa_information2%TYPE;
1218: l_second_noa_information3 ghr_pa_requests.second_noa_information3%TYPE;
1219: l_second_noa_information4 ghr_pa_requests.second_noa_information4%TYPE;
1220: l_second_noa_information5 ghr_pa_requests.second_noa_information5%TYPE;
1221: l_first_lac1_information1 ghr_pa_requests.first_lac1_information1%TYPE;
1222: l_first_lac1_information2 ghr_pa_requests.first_lac1_information2%TYPE;
1223: l_first_lac1_information3 ghr_pa_requests.first_lac1_information3%TYPE;
1216: l_second_noa_information1 ghr_pa_requests.second_noa_information1%TYPE;
1217: l_second_noa_information2 ghr_pa_requests.second_noa_information2%TYPE;
1218: l_second_noa_information3 ghr_pa_requests.second_noa_information3%TYPE;
1219: l_second_noa_information4 ghr_pa_requests.second_noa_information4%TYPE;
1220: l_second_noa_information5 ghr_pa_requests.second_noa_information5%TYPE;
1221: l_first_lac1_information1 ghr_pa_requests.first_lac1_information1%TYPE;
1222: l_first_lac1_information2 ghr_pa_requests.first_lac1_information2%TYPE;
1223: l_first_lac1_information3 ghr_pa_requests.first_lac1_information3%TYPE;
1224: l_first_lac1_information4 ghr_pa_requests.first_lac1_information4%TYPE;
1217: l_second_noa_information2 ghr_pa_requests.second_noa_information2%TYPE;
1218: l_second_noa_information3 ghr_pa_requests.second_noa_information3%TYPE;
1219: l_second_noa_information4 ghr_pa_requests.second_noa_information4%TYPE;
1220: l_second_noa_information5 ghr_pa_requests.second_noa_information5%TYPE;
1221: l_first_lac1_information1 ghr_pa_requests.first_lac1_information1%TYPE;
1222: l_first_lac1_information2 ghr_pa_requests.first_lac1_information2%TYPE;
1223: l_first_lac1_information3 ghr_pa_requests.first_lac1_information3%TYPE;
1224: l_first_lac1_information4 ghr_pa_requests.first_lac1_information4%TYPE;
1225: l_first_lac1_information5 ghr_pa_requests.first_lac1_information5%TYPE;
1218: l_second_noa_information3 ghr_pa_requests.second_noa_information3%TYPE;
1219: l_second_noa_information4 ghr_pa_requests.second_noa_information4%TYPE;
1220: l_second_noa_information5 ghr_pa_requests.second_noa_information5%TYPE;
1221: l_first_lac1_information1 ghr_pa_requests.first_lac1_information1%TYPE;
1222: l_first_lac1_information2 ghr_pa_requests.first_lac1_information2%TYPE;
1223: l_first_lac1_information3 ghr_pa_requests.first_lac1_information3%TYPE;
1224: l_first_lac1_information4 ghr_pa_requests.first_lac1_information4%TYPE;
1225: l_first_lac1_information5 ghr_pa_requests.first_lac1_information5%TYPE;
1226: l_first_lac2_information1 ghr_pa_requests.first_lac2_information1%TYPE;
1219: l_second_noa_information4 ghr_pa_requests.second_noa_information4%TYPE;
1220: l_second_noa_information5 ghr_pa_requests.second_noa_information5%TYPE;
1221: l_first_lac1_information1 ghr_pa_requests.first_lac1_information1%TYPE;
1222: l_first_lac1_information2 ghr_pa_requests.first_lac1_information2%TYPE;
1223: l_first_lac1_information3 ghr_pa_requests.first_lac1_information3%TYPE;
1224: l_first_lac1_information4 ghr_pa_requests.first_lac1_information4%TYPE;
1225: l_first_lac1_information5 ghr_pa_requests.first_lac1_information5%TYPE;
1226: l_first_lac2_information1 ghr_pa_requests.first_lac2_information1%TYPE;
1227: l_first_lac2_information2 ghr_pa_requests.first_lac2_information2%TYPE;
1220: l_second_noa_information5 ghr_pa_requests.second_noa_information5%TYPE;
1221: l_first_lac1_information1 ghr_pa_requests.first_lac1_information1%TYPE;
1222: l_first_lac1_information2 ghr_pa_requests.first_lac1_information2%TYPE;
1223: l_first_lac1_information3 ghr_pa_requests.first_lac1_information3%TYPE;
1224: l_first_lac1_information4 ghr_pa_requests.first_lac1_information4%TYPE;
1225: l_first_lac1_information5 ghr_pa_requests.first_lac1_information5%TYPE;
1226: l_first_lac2_information1 ghr_pa_requests.first_lac2_information1%TYPE;
1227: l_first_lac2_information2 ghr_pa_requests.first_lac2_information2%TYPE;
1228: l_first_lac2_information3 ghr_pa_requests.first_lac2_information3%TYPE;
1221: l_first_lac1_information1 ghr_pa_requests.first_lac1_information1%TYPE;
1222: l_first_lac1_information2 ghr_pa_requests.first_lac1_information2%TYPE;
1223: l_first_lac1_information3 ghr_pa_requests.first_lac1_information3%TYPE;
1224: l_first_lac1_information4 ghr_pa_requests.first_lac1_information4%TYPE;
1225: l_first_lac1_information5 ghr_pa_requests.first_lac1_information5%TYPE;
1226: l_first_lac2_information1 ghr_pa_requests.first_lac2_information1%TYPE;
1227: l_first_lac2_information2 ghr_pa_requests.first_lac2_information2%TYPE;
1228: l_first_lac2_information3 ghr_pa_requests.first_lac2_information3%TYPE;
1229: l_first_lac2_information4 ghr_pa_requests.first_lac2_information4%TYPE;
1222: l_first_lac1_information2 ghr_pa_requests.first_lac1_information2%TYPE;
1223: l_first_lac1_information3 ghr_pa_requests.first_lac1_information3%TYPE;
1224: l_first_lac1_information4 ghr_pa_requests.first_lac1_information4%TYPE;
1225: l_first_lac1_information5 ghr_pa_requests.first_lac1_information5%TYPE;
1226: l_first_lac2_information1 ghr_pa_requests.first_lac2_information1%TYPE;
1227: l_first_lac2_information2 ghr_pa_requests.first_lac2_information2%TYPE;
1228: l_first_lac2_information3 ghr_pa_requests.first_lac2_information3%TYPE;
1229: l_first_lac2_information4 ghr_pa_requests.first_lac2_information4%TYPE;
1230: l_first_lac2_information5 ghr_pa_requests.first_lac2_information5%TYPE;
1223: l_first_lac1_information3 ghr_pa_requests.first_lac1_information3%TYPE;
1224: l_first_lac1_information4 ghr_pa_requests.first_lac1_information4%TYPE;
1225: l_first_lac1_information5 ghr_pa_requests.first_lac1_information5%TYPE;
1226: l_first_lac2_information1 ghr_pa_requests.first_lac2_information1%TYPE;
1227: l_first_lac2_information2 ghr_pa_requests.first_lac2_information2%TYPE;
1228: l_first_lac2_information3 ghr_pa_requests.first_lac2_information3%TYPE;
1229: l_first_lac2_information4 ghr_pa_requests.first_lac2_information4%TYPE;
1230: l_first_lac2_information5 ghr_pa_requests.first_lac2_information5%TYPE;
1231: l_u_attachment_modified_flag varchar2(30);
1224: l_first_lac1_information4 ghr_pa_requests.first_lac1_information4%TYPE;
1225: l_first_lac1_information5 ghr_pa_requests.first_lac1_information5%TYPE;
1226: l_first_lac2_information1 ghr_pa_requests.first_lac2_information1%TYPE;
1227: l_first_lac2_information2 ghr_pa_requests.first_lac2_information2%TYPE;
1228: l_first_lac2_information3 ghr_pa_requests.first_lac2_information3%TYPE;
1229: l_first_lac2_information4 ghr_pa_requests.first_lac2_information4%TYPE;
1230: l_first_lac2_information5 ghr_pa_requests.first_lac2_information5%TYPE;
1231: l_u_attachment_modified_flag varchar2(30);
1232: l_u_approved_flag varchar2(30);
1225: l_first_lac1_information5 ghr_pa_requests.first_lac1_information5%TYPE;
1226: l_first_lac2_information1 ghr_pa_requests.first_lac2_information1%TYPE;
1227: l_first_lac2_information2 ghr_pa_requests.first_lac2_information2%TYPE;
1228: l_first_lac2_information3 ghr_pa_requests.first_lac2_information3%TYPE;
1229: l_first_lac2_information4 ghr_pa_requests.first_lac2_information4%TYPE;
1230: l_first_lac2_information5 ghr_pa_requests.first_lac2_information5%TYPE;
1231: l_u_attachment_modified_flag varchar2(30);
1232: l_u_approved_flag varchar2(30);
1233: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;
1226: l_first_lac2_information1 ghr_pa_requests.first_lac2_information1%TYPE;
1227: l_first_lac2_information2 ghr_pa_requests.first_lac2_information2%TYPE;
1228: l_first_lac2_information3 ghr_pa_requests.first_lac2_information3%TYPE;
1229: l_first_lac2_information4 ghr_pa_requests.first_lac2_information4%TYPE;
1230: l_first_lac2_information5 ghr_pa_requests.first_lac2_information5%TYPE;
1231: l_u_attachment_modified_flag varchar2(30);
1232: l_u_approved_flag varchar2(30);
1233: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;
1234: l_i_user_name_routed_to ghr_pa_routing_history.user_name%TYPE;
1238: l_u_prh_object_version_number number;
1239: l_i_pa_routing_history_id number;
1240: l_i_prh_object_version_number number;
1241: l_u_approval_status ghr_pa_routing_history.approval_status%TYPE;
1242: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%TYPE;
1243: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%TYPE;
1244: l_approval_date ghr_pa_requests.approval_date%TYPE;
1245: --
1246: l_to_retention_allow_percentag ghr_pa_requests.to_retention_allow_percentage%TYPE;
1239: l_i_pa_routing_history_id number;
1240: l_i_prh_object_version_number number;
1241: l_u_approval_status ghr_pa_routing_history.approval_status%TYPE;
1242: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%TYPE;
1243: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%TYPE;
1244: l_approval_date ghr_pa_requests.approval_date%TYPE;
1245: --
1246: l_to_retention_allow_percentag ghr_pa_requests.to_retention_allow_percentage%TYPE;
1247: l_to_supervisory_diff_percenta ghr_pa_requests.to_supervisory_diff_percentage%TYPE;
1240: l_i_prh_object_version_number number;
1241: l_u_approval_status ghr_pa_routing_history.approval_status%TYPE;
1242: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%TYPE;
1243: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%TYPE;
1244: l_approval_date ghr_pa_requests.approval_date%TYPE;
1245: --
1246: l_to_retention_allow_percentag ghr_pa_requests.to_retention_allow_percentage%TYPE;
1247: l_to_supervisory_diff_percenta ghr_pa_requests.to_supervisory_diff_percentage%TYPE;
1248: l_to_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%TYPE;
1242: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%TYPE;
1243: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%TYPE;
1244: l_approval_date ghr_pa_requests.approval_date%TYPE;
1245: --
1246: l_to_retention_allow_percentag ghr_pa_requests.to_retention_allow_percentage%TYPE;
1247: l_to_supervisory_diff_percenta ghr_pa_requests.to_supervisory_diff_percentage%TYPE;
1248: l_to_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%TYPE;
1249: l_award_percentage ghr_pa_requests.award_percentage%TYPE;
1250: l_commit number;
1243: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%TYPE;
1244: l_approval_date ghr_pa_requests.approval_date%TYPE;
1245: --
1246: l_to_retention_allow_percentag ghr_pa_requests.to_retention_allow_percentage%TYPE;
1247: l_to_supervisory_diff_percenta ghr_pa_requests.to_supervisory_diff_percentage%TYPE;
1248: l_to_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%TYPE;
1249: l_award_percentage ghr_pa_requests.award_percentage%TYPE;
1250: l_commit number;
1251:
1244: l_approval_date ghr_pa_requests.approval_date%TYPE;
1245: --
1246: l_to_retention_allow_percentag ghr_pa_requests.to_retention_allow_percentage%TYPE;
1247: l_to_supervisory_diff_percenta ghr_pa_requests.to_supervisory_diff_percentage%TYPE;
1248: l_to_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%TYPE;
1249: l_award_percentage ghr_pa_requests.award_percentage%TYPE;
1250: l_commit number;
1251:
1252: --
1245: --
1246: l_to_retention_allow_percentag ghr_pa_requests.to_retention_allow_percentage%TYPE;
1247: l_to_supervisory_diff_percenta ghr_pa_requests.to_supervisory_diff_percentage%TYPE;
1248: l_to_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%TYPE;
1249: l_award_percentage ghr_pa_requests.award_percentage%TYPE;
1250: l_commit number;
1251:
1252: --
1253: -- Added cursor to select object version number and routing history id
1445: -- i_user_name_routed_to,
1446: -- i_groupbox_id
1447: -- i_routing_list_id,
1448: -- i_routing_seq_number
1449: from ghr_pa_requests
1450: where pa_request_id = p_pa_request_id;
1451: --
1452: begin
1453: -- Replacing the insert dml with a call to the dt_fndate.change_ses_date procedure .
1665: l_i_groupbox_id := p_groupbox_id;
1666: -- Get the Electronic Auth. values
1667: l_u_approval_status := 'APPROVE';
1668: l_approval_date := sysdate;
1669: l_approving_official_full_name := ghr_pa_requests_pkg.get_full_name_fml (p_gbx_user_id);
1670: l_approving_official_work_titl :=
1671: ghr_pa_requests_pkg.get_position_work_title (p_person_id => TO_CHAR(p_gbx_user_id));
1672: end if;
1673: -- Set Request Number
1667: l_u_approval_status := 'APPROVE';
1668: l_approval_date := sysdate;
1669: l_approving_official_full_name := ghr_pa_requests_pkg.get_full_name_fml (p_gbx_user_id);
1670: l_approving_official_work_titl :=
1671: ghr_pa_requests_pkg.get_position_work_title (p_person_id => TO_CHAR(p_gbx_user_id));
1672: end if;
1673: -- Set Request Number
1674: l_request_number := 'WGI:' || p_pa_request_id;
1675: ghr_sf52_api.update_sf52(
1989: --
1990: --
1991: --
1992: l_user_name ghr_pa_routing_history.user_name%TYPE;
1993: l_person_id ghr_pa_requests.person_id%TYPE;
1994: l_position_id ghr_pa_requests.from_position_id%TYPE;
1995: l_effective_date ghr_pa_requests.effective_date%TYPE;
1996: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1997: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1990: --
1991: --
1992: l_user_name ghr_pa_routing_history.user_name%TYPE;
1993: l_person_id ghr_pa_requests.person_id%TYPE;
1994: l_position_id ghr_pa_requests.from_position_id%TYPE;
1995: l_effective_date ghr_pa_requests.effective_date%TYPE;
1996: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1997: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1998: l_full_name per_people_f.full_name%TYPE;
1991: --
1992: l_user_name ghr_pa_routing_history.user_name%TYPE;
1993: l_person_id ghr_pa_requests.person_id%TYPE;
1994: l_position_id ghr_pa_requests.from_position_id%TYPE;
1995: l_effective_date ghr_pa_requests.effective_date%TYPE;
1996: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1997: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1998: l_full_name per_people_f.full_name%TYPE;
1999: l_routing_group_name ghr_routing_groups.name%TYPE;
1992: l_user_name ghr_pa_routing_history.user_name%TYPE;
1993: l_person_id ghr_pa_requests.person_id%TYPE;
1994: l_position_id ghr_pa_requests.from_position_id%TYPE;
1995: l_effective_date ghr_pa_requests.effective_date%TYPE;
1996: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1997: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1998: l_full_name per_people_f.full_name%TYPE;
1999: l_routing_group_name ghr_routing_groups.name%TYPE;
2000: l_routing_group_desc ghr_routing_groups.description%TYPE;
1993: l_person_id ghr_pa_requests.person_id%TYPE;
1994: l_position_id ghr_pa_requests.from_position_id%TYPE;
1995: l_effective_date ghr_pa_requests.effective_date%TYPE;
1996: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1997: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1998: l_full_name per_people_f.full_name%TYPE;
1999: l_routing_group_name ghr_routing_groups.name%TYPE;
2000: l_routing_group_desc ghr_routing_groups.description%TYPE;
2001: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
2014: l_line4 varchar2(500);
2015: l_line5 varchar2(500);
2016: l_line6 varchar2(500);
2017: l_line7 varchar2(500);
2018: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2019: l_gbx_user_id ghr_pois.person_id%TYPE;
2020: l_routing_group varchar2(500);
2021: l_wgi_error_note varchar2(500);
2022: -- NOCOPY Changes
2225: --
2226: l_u_prh_object_version_number number;
2227: l_i_pa_routing_history_id number;
2228: l_i_prh_object_version_number number;
2229: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
2230: l_person_id ghr_pa_requests.person_id%TYPE;
2231: l_effective_date ghr_pa_requests.effective_date%TYPE;
2232: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
2233: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
2226: l_u_prh_object_version_number number;
2227: l_i_pa_routing_history_id number;
2228: l_i_prh_object_version_number number;
2229: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
2230: l_person_id ghr_pa_requests.person_id%TYPE;
2231: l_effective_date ghr_pa_requests.effective_date%TYPE;
2232: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
2233: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
2234: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
2227: l_i_pa_routing_history_id number;
2228: l_i_prh_object_version_number number;
2229: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
2230: l_person_id ghr_pa_requests.person_id%TYPE;
2231: l_effective_date ghr_pa_requests.effective_date%TYPE;
2232: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
2233: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
2234: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
2235: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
2228: l_i_prh_object_version_number number;
2229: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
2230: l_person_id ghr_pa_requests.person_id%TYPE;
2231: l_effective_date ghr_pa_requests.effective_date%TYPE;
2232: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
2233: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
2234: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
2235: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
2236: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2229: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
2230: l_person_id ghr_pa_requests.person_id%TYPE;
2231: l_effective_date ghr_pa_requests.effective_date%TYPE;
2232: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
2233: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
2234: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
2235: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
2236: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2237: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2230: l_person_id ghr_pa_requests.person_id%TYPE;
2231: l_effective_date ghr_pa_requests.effective_date%TYPE;
2232: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
2233: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
2234: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
2235: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
2236: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2237: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2238: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2231: l_effective_date ghr_pa_requests.effective_date%TYPE;
2232: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
2233: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
2234: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
2235: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
2236: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2237: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2238: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2239: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2232: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
2233: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
2234: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
2235: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
2236: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2237: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2238: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2239: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2240: l_validate boolean := false;
2233: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
2234: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
2235: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
2236: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2237: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2238: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2239: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2240: l_validate boolean := false;
2241: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
2234: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
2235: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
2236: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2237: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2238: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2239: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2240: l_validate boolean := false;
2241: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
2242: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
2235: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
2236: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2237: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2238: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2239: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2240: l_validate boolean := false;
2241: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
2242: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
2243: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
2237: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2238: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2239: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2240: l_validate boolean := false;
2241: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
2242: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
2243: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
2244: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
2245: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
2238: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2239: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2240: l_validate boolean := false;
2241: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
2242: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
2243: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
2244: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
2245: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
2246: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
2239: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2240: l_validate boolean := false;
2241: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
2242: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
2243: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
2244: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
2245: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
2246: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
2247: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
2240: l_validate boolean := false;
2241: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
2242: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
2243: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
2244: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
2245: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
2246: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
2247: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
2248: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2241: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
2242: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
2243: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
2244: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
2245: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
2246: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
2247: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
2248: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2249: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
2242: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
2243: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
2244: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
2245: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
2246: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
2247: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
2248: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2249: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
2250: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
2243: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
2244: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
2245: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
2246: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
2247: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
2248: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2249: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
2250: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
2251: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
2244: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
2245: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
2246: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
2247: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
2248: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2249: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
2250: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
2251: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
2252: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
2245: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
2246: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
2247: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
2248: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2249: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
2250: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
2251: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
2252: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
2253: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
2246: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
2247: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
2248: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2249: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
2250: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
2251: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
2252: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
2253: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
2254: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
2247: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
2248: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2249: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
2250: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
2251: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
2252: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
2253: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
2254: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
2255: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
2248: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2249: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
2250: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
2251: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
2252: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
2253: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
2254: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
2255: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
2256: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
2249: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
2250: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
2251: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
2252: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
2253: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
2254: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
2255: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
2256: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
2257: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
2250: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
2251: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
2252: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
2253: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
2254: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
2255: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
2256: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
2257: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
2258: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
2251: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
2252: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
2253: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
2254: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
2255: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
2256: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
2257: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
2258: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
2259: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
2252: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
2253: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
2254: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
2255: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
2256: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
2257: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
2258: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
2259: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
2260: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
2253: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
2254: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
2255: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
2256: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
2257: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
2258: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
2259: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
2260: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
2261: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2254: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
2255: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
2256: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
2257: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
2258: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
2259: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
2260: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
2261: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2262: -- Remarks
2255: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
2256: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
2257: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
2258: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
2259: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
2260: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
2261: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2262: -- Remarks
2263: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
2256: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
2257: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
2258: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
2259: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
2260: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
2261: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2262: -- Remarks
2263: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
2264: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
2306: from_position_seq_no,
2307: from_position_title,
2308: from_step_or_rate,
2309: from_total_salary
2310: from ghr_pa_requests
2311: where pa_request_id = to_number(itemkey);
2312: --
2313: --
2314: begin
2533: --
2534: -- Fetch PA request details
2535: cursor csr_par_info is
2536: select *
2537: from ghr_pa_requests
2538: where pa_request_id = to_number(itemkey);
2539: cursor csr_check_par is
2540: select count(*)
2541: from ghr_pa_requests
2537: from ghr_pa_requests
2538: where pa_request_id = to_number(itemkey);
2539: cursor csr_check_par is
2540: select count(*)
2541: from ghr_pa_requests
2542: where pa_request_id = to_number(itemkey);
2543: --
2544: l_sf52_data_in_rec ghr_pa_requests%rowtype;
2545: l_count number;
2540: select count(*)
2541: from ghr_pa_requests
2542: where pa_request_id = to_number(itemkey);
2543: --
2544: l_sf52_data_in_rec ghr_pa_requests%rowtype;
2545: l_count number;
2546: l_result VARCHAR2(250);
2547: --
2548: --