2: /* $Header: ghwgipro.pkb 120.17.12010000.2 2010/01/12 10:40:56 managarw ship $ */
3: PROCEDURE ghr_wgi_process (
4: errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_personnel_office_id IN ghr_pa_requests.personnel_office_id%TYPE
7: DEFAULT NULL,
8: p_pay_plan IN ghr_pay_plans.pay_plan%TYPE
9: DEFAULT NULL
10: )
38: p_frequency IN NUMBER DEFAULT 90,
39: p_log_flag IN CHAR DEFAULT 'N',
40: p_errbuf OUT NOCOPY VARCHAR2,
41: p_retcode OUT NOCOPY NUMBER,
42: p_personnel_office_id IN ghr_pa_requests.personnel_office_id%TYPE
43: DEFAULT NULL,
44: p_pay_plan IN ghr_pay_plans.pay_plan%TYPE
45: DEFAULT NULL
46: )
88: l_first_name per_people_f.first_name%TYPE;
89: l_middle_names per_people_f.middle_names%TYPE;
90: l_full_name per_people_f.full_name%TYPE;
91: l_position_id per_assignments.position_id%TYPE;
92: l_grade_id ghr_pa_requests.to_grade_id%TYPE;
93: l_job_id per_assignments.job_id%TYPE;
94: l_location_id per_assignments.location_id%TYPE;
95: l_organization_id per_assignments.organization_id%TYPE;
96: l_proc VARCHAR2 (30) := 'AWGI :';
107: l_wgi_pay_date DATE;
108: l_wgi_due_date DATE; -- Bug 3747024
109: l_value VARCHAR2 (30);
110: l_multiple_error_flag BOOLEAN;
111: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
112: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
113: l_1_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
114: l_1_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
115: l_2_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
108: l_wgi_due_date DATE; -- Bug 3747024
109: l_value VARCHAR2 (30);
110: l_multiple_error_flag BOOLEAN;
111: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
112: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
113: l_1_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
114: l_1_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
115: l_2_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
116: l_2_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
110: l_multiple_error_flag BOOLEAN;
111: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
112: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
113: l_1_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
114: l_1_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
115: l_2_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
116: l_2_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
117: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
118: l_validate BOOLEAN;
112: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
113: l_1_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
114: l_1_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
115: l_2_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
116: l_2_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
117: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
118: l_validate BOOLEAN;
119: l_u_attachment_modified_flag VARCHAR2 (30);
120: l_u_approved_flag VARCHAR2 (30);
113: l_1_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
114: l_1_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
115: l_2_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
116: l_2_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
117: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
118: l_validate BOOLEAN;
119: l_u_attachment_modified_flag VARCHAR2 (30);
120: l_u_approved_flag VARCHAR2 (30);
121: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;
127: l_i_routing_seq_number NUMBER;
128: l_u_prh_object_version_number NUMBER;
129: l_i_pa_routing_history_id NUMBER;
130: l_i_prh_object_version_number NUMBER;
131: l_effective_date ghr_pa_requests.effective_date%TYPE;
132: -- For Create SF52 procedure
133: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE; --'SALARY_CHG';
134: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
135: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
129: l_i_pa_routing_history_id NUMBER;
130: l_i_prh_object_version_number NUMBER;
131: l_effective_date ghr_pa_requests.effective_date%TYPE;
132: -- For Create SF52 procedure
133: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE; --'SALARY_CHG';
134: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
135: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
136: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
137: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
130: l_i_prh_object_version_number NUMBER;
131: l_effective_date ghr_pa_requests.effective_date%TYPE;
132: -- For Create SF52 procedure
133: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE; --'SALARY_CHG';
134: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
135: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
136: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
137: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
138: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
131: l_effective_date ghr_pa_requests.effective_date%TYPE;
132: -- For Create SF52 procedure
133: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE; --'SALARY_CHG';
134: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
135: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
136: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
137: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
138: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
139: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
132: -- For Create SF52 procedure
133: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE; --'SALARY_CHG';
134: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
135: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
136: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
137: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
138: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
139: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
140: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE
133: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE; --'SALARY_CHG';
134: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
135: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
136: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
137: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
138: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
139: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
140: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE
141: := 'N';
134: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
135: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
136: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
137: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
138: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
139: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
140: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE
141: := 'N';
142: -- For Update SF52 procedure (ghr_pa_requests_pkg.get_SF52_person_ddf_details)
135: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
136: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
137: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
138: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
139: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
140: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE
141: := 'N';
142: -- For Update SF52 procedure (ghr_pa_requests_pkg.get_SF52_person_ddf_details)
143: l_citizenship ghr_pa_requests.citizenship%TYPE;
136: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
137: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
138: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
139: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
140: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE
141: := 'N';
142: -- For Update SF52 procedure (ghr_pa_requests_pkg.get_SF52_person_ddf_details)
143: l_citizenship ghr_pa_requests.citizenship%TYPE;
144: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
138: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
139: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
140: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE
141: := 'N';
142: -- For Update SF52 procedure (ghr_pa_requests_pkg.get_SF52_person_ddf_details)
143: l_citizenship ghr_pa_requests.citizenship%TYPE;
144: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
145: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
146: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
139: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
140: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE
141: := 'N';
142: -- For Update SF52 procedure (ghr_pa_requests_pkg.get_SF52_person_ddf_details)
143: l_citizenship ghr_pa_requests.citizenship%TYPE;
144: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
145: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
146: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
147: l_scd_leave VARCHAR2 (150);
140: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%TYPE
141: := 'N';
142: -- For Update SF52 procedure (ghr_pa_requests_pkg.get_SF52_person_ddf_details)
143: l_citizenship ghr_pa_requests.citizenship%TYPE;
144: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
145: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
146: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
147: l_scd_leave VARCHAR2 (150);
148: -- For Update SF52 procedure From side data elements(ghr_pa_requests_pkg.SF52_from_data_elements)
141: := 'N';
142: -- For Update SF52 procedure (ghr_pa_requests_pkg.get_SF52_person_ddf_details)
143: l_citizenship ghr_pa_requests.citizenship%TYPE;
144: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
145: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
146: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
147: l_scd_leave VARCHAR2 (150);
148: -- For Update SF52 procedure From side data elements(ghr_pa_requests_pkg.SF52_from_data_elements)
149: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
142: -- For Update SF52 procedure (ghr_pa_requests_pkg.get_SF52_person_ddf_details)
143: l_citizenship ghr_pa_requests.citizenship%TYPE;
144: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
145: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
146: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
147: l_scd_leave VARCHAR2 (150);
148: -- For Update SF52 procedure From side data elements(ghr_pa_requests_pkg.SF52_from_data_elements)
149: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
150: l_from_agency_code ghr_pa_requests.from_agency_code%TYPE;
144: l_veterans_preference ghr_pa_requests.veterans_preference%TYPE;
145: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
146: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
147: l_scd_leave VARCHAR2 (150);
148: -- For Update SF52 procedure From side data elements(ghr_pa_requests_pkg.SF52_from_data_elements)
149: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
150: l_from_agency_code ghr_pa_requests.from_agency_code%TYPE;
151: l_from_agency_desc ghr_pa_requests.from_agency_desc%TYPE;
152: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
145: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%TYPE;
146: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
147: l_scd_leave VARCHAR2 (150);
148: -- For Update SF52 procedure From side data elements(ghr_pa_requests_pkg.SF52_from_data_elements)
149: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
150: l_from_agency_code ghr_pa_requests.from_agency_code%TYPE;
151: l_from_agency_desc ghr_pa_requests.from_agency_desc%TYPE;
152: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
153: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
146: l_veterans_status ghr_pa_requests.veterans_status%TYPE;
147: l_scd_leave VARCHAR2 (150);
148: -- For Update SF52 procedure From side data elements(ghr_pa_requests_pkg.SF52_from_data_elements)
149: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
150: l_from_agency_code ghr_pa_requests.from_agency_code%TYPE;
151: l_from_agency_desc ghr_pa_requests.from_agency_desc%TYPE;
152: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
153: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
154: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
147: l_scd_leave VARCHAR2 (150);
148: -- For Update SF52 procedure From side data elements(ghr_pa_requests_pkg.SF52_from_data_elements)
149: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
150: l_from_agency_code ghr_pa_requests.from_agency_code%TYPE;
151: l_from_agency_desc ghr_pa_requests.from_agency_desc%TYPE;
152: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
153: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
154: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
155: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
148: -- For Update SF52 procedure From side data elements(ghr_pa_requests_pkg.SF52_from_data_elements)
149: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
150: l_from_agency_code ghr_pa_requests.from_agency_code%TYPE;
151: l_from_agency_desc ghr_pa_requests.from_agency_desc%TYPE;
152: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
153: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
154: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
155: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
156: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
149: l_from_adj_basic_pay ghr_pa_requests.from_adj_basic_pay%TYPE;
150: l_from_agency_code ghr_pa_requests.from_agency_code%TYPE;
151: l_from_agency_desc ghr_pa_requests.from_agency_desc%TYPE;
152: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
153: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
154: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
155: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
156: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
157: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
150: l_from_agency_code ghr_pa_requests.from_agency_code%TYPE;
151: l_from_agency_desc ghr_pa_requests.from_agency_desc%TYPE;
152: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
153: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
154: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
155: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
156: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
157: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
158: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
151: l_from_agency_desc ghr_pa_requests.from_agency_desc%TYPE;
152: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
153: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
154: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
155: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
156: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
157: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
158: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
159: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
152: l_from_basic_pay ghr_pa_requests.from_basic_pay%TYPE;
153: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
154: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
155: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
156: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
157: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
158: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
159: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
160: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
153: l_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
154: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
155: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
156: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
157: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
158: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
159: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
160: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
161: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
154: l_from_locality_adj ghr_pa_requests.from_locality_adj%TYPE;
155: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
156: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
157: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
158: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
159: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
160: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
161: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
162: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
155: l_from_occ_code ghr_pa_requests.from_occ_code%TYPE;
156: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
157: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
158: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
159: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
160: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
161: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
162: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
163: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
156: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
157: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
158: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
159: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
160: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
161: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
162: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
163: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
164: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
157: l_from_other_pay_amount ghr_pa_requests.from_other_pay_amount%TYPE;
158: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
159: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
160: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
161: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
162: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
163: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
164: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
165: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
158: l_from_pay_basis ghr_pa_requests.from_pay_basis%TYPE;
159: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
160: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
161: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
162: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
163: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
164: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
165: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
166: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
159: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
160: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
161: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
162: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
163: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
164: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
165: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
166: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
167: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
160: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
161: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
162: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
163: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
164: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
165: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
166: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
167: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
168: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
161: l_from_position_org_line1 ghr_pa_requests.from_position_org_line1%TYPE;
162: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
163: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
164: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
165: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
166: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
167: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
168: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
169: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
162: l_from_position_org_line2 ghr_pa_requests.from_position_org_line2%TYPE;
163: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
164: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
165: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
166: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
167: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
168: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
169: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
170: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
163: l_from_position_org_line3 ghr_pa_requests.from_position_org_line3%TYPE;
164: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
165: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
166: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
167: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
168: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
169: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
170: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
171: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
164: l_from_position_org_line4 ghr_pa_requests.from_position_org_line4%TYPE;
165: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
166: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
167: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
168: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
169: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
170: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
171: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
172: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
165: l_from_position_org_line5 ghr_pa_requests.from_position_org_line5%TYPE;
166: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
167: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
168: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
169: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
170: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
171: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
172: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
173: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
166: l_from_position_org_line6 ghr_pa_requests.from_position_org_line6%TYPE;
167: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
168: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
169: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
170: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
171: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
172: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
173: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
174: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
167: l_from_position_number ghr_pa_requests.from_position_number%TYPE;
168: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
169: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
170: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
171: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
172: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
173: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
174: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
175: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
168: l_from_position_seq_no ghr_pa_requests.from_position_seq_no%TYPE;
169: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
170: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
171: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
172: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
173: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
174: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
175: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
176: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
169: l_from_position_title ghr_pa_requests.from_position_title%TYPE;
170: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
171: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
172: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
173: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
174: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
175: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
176: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
177: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
170: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
171: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
172: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
173: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
174: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
175: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
176: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
177: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
178: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
171: l_from_total_salary ghr_pa_requests.from_total_salary%TYPE;
172: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
173: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
174: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
175: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
176: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
177: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
178: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
179: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
172: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
173: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
174: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
175: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
176: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
177: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
178: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
179: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
180: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
173: l_to_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
174: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
175: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
176: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
177: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
178: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
179: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
180: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
181: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
174: l_to_availability_pay ghr_pa_requests.to_availability_pay%TYPE;
175: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
176: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
177: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
178: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
179: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
180: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
181: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
182: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
175: l_to_ap_premium_pay_indicator ghr_pa_requests.to_ap_premium_pay_indicator%TYPE;
176: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
177: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
178: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
179: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
180: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
181: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
182: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
183: l_education_level ghr_pa_requests.education_level%TYPE;
176: l_to_retention_allowance ghr_pa_requests.to_retention_allowance%TYPE;
177: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
178: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
179: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
180: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
181: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
182: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
183: l_education_level ghr_pa_requests.education_level%TYPE;
184: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
177: l_to_supervisory_differential ghr_pa_requests.to_supervisory_differential%TYPE;
178: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
179: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
180: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
181: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
182: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
183: l_education_level ghr_pa_requests.education_level%TYPE;
184: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
185: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
178: l_to_staffing_differential ghr_pa_requests.to_staffing_differential%TYPE;
179: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
180: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
181: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
182: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
183: l_education_level ghr_pa_requests.education_level%TYPE;
184: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
185: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
186: --
179: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
180: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
181: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
182: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
183: l_education_level ghr_pa_requests.education_level%TYPE;
184: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
185: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
186: --
187: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%TYPE;
180: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%TYPE;
181: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
182: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
183: l_education_level ghr_pa_requests.education_level%TYPE;
184: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
185: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
186: --
187: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%TYPE;
188: l_supervisory_diff_percentage ghr_pa_requests.to_supervisory_diff_percentage%TYPE;
181: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
182: l_duty_station_location_id ghr_pa_requests.duty_station_location_id%TYPE;
183: l_education_level ghr_pa_requests.education_level%TYPE;
184: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
185: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
186: --
187: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%TYPE;
188: l_supervisory_diff_percentage ghr_pa_requests.to_supervisory_diff_percentage%TYPE;
189: l_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%TYPE;
183: l_education_level ghr_pa_requests.education_level%TYPE;
184: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
185: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
186: --
187: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%TYPE;
188: l_supervisory_diff_percentage ghr_pa_requests.to_supervisory_diff_percentage%TYPE;
189: l_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%TYPE;
190: l_award_percentage ghr_pa_requests.award_percentage%TYPE;
191: --
184: l_academic_discipline ghr_pa_requests.academic_discipline%TYPE;
185: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
186: --
187: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%TYPE;
188: l_supervisory_diff_percentage ghr_pa_requests.to_supervisory_diff_percentage%TYPE;
189: l_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%TYPE;
190: l_award_percentage ghr_pa_requests.award_percentage%TYPE;
191: --
192: -- for get_SF52_asg_ddf_details
185: l_year_degree_attained ghr_pa_requests.year_degree_attained%TYPE;
186: --
187: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%TYPE;
188: l_supervisory_diff_percentage ghr_pa_requests.to_supervisory_diff_percentage%TYPE;
189: l_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%TYPE;
190: l_award_percentage ghr_pa_requests.award_percentage%TYPE;
191: --
192: -- for get_SF52_asg_ddf_details
193: l_tenure ghr_pa_requests.tenure%TYPE;
186: --
187: l_retention_allow_percentage ghr_pa_requests.to_retention_allow_percentage%TYPE;
188: l_supervisory_diff_percentage ghr_pa_requests.to_supervisory_diff_percentage%TYPE;
189: l_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%TYPE;
190: l_award_percentage ghr_pa_requests.award_percentage%TYPE;
191: --
192: -- for get_SF52_asg_ddf_details
193: l_tenure ghr_pa_requests.tenure%TYPE;
194: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
189: l_staffing_diff_percentage ghr_pa_requests.to_staffing_diff_percentage%TYPE;
190: l_award_percentage ghr_pa_requests.award_percentage%TYPE;
191: --
192: -- for get_SF52_asg_ddf_details
193: l_tenure ghr_pa_requests.tenure%TYPE;
194: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
195: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
196: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
197: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
190: l_award_percentage ghr_pa_requests.award_percentage%TYPE;
191: --
192: -- for get_SF52_asg_ddf_details
193: l_tenure ghr_pa_requests.tenure%TYPE;
194: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
195: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
196: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
197: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
191: --
192: -- for get_SF52_asg_ddf_details
193: l_tenure ghr_pa_requests.tenure%TYPE;
194: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
195: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
196: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
197: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
192: -- for get_SF52_asg_ddf_details
193: l_tenure ghr_pa_requests.tenure%TYPE;
194: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
195: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
196: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
197: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
200: l_functional_class ghr_pa_requests.functional_class%TYPE;
193: l_tenure ghr_pa_requests.tenure%TYPE;
194: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
195: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
196: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
197: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
200: l_functional_class ghr_pa_requests.functional_class%TYPE;
201: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
194: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%TYPE;
195: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
196: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
197: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
200: l_functional_class ghr_pa_requests.functional_class%TYPE;
201: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
202: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
195: l_annuitant_indicator_desc ghr_pa_requests.annuitant_indicator_desc%TYPE;
196: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
197: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
200: l_functional_class ghr_pa_requests.functional_class%TYPE;
201: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
202: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
203: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
196: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
197: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
200: l_functional_class ghr_pa_requests.functional_class%TYPE;
201: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
202: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
203: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
204: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
197: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
200: l_functional_class ghr_pa_requests.functional_class%TYPE;
201: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
202: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
203: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
204: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
205: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
198: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
200: l_functional_class ghr_pa_requests.functional_class%TYPE;
201: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
202: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
203: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
204: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
205: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
206: -- for get_duty_station_detail
199: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
200: l_functional_class ghr_pa_requests.functional_class%TYPE;
201: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
202: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
203: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
204: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
205: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
206: -- for get_duty_station_detail
207: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
200: l_functional_class ghr_pa_requests.functional_class%TYPE;
201: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
202: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
203: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
204: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
205: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
206: -- for get_duty_station_detail
207: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
208: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
201: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
202: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
203: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
204: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
205: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
206: -- for get_duty_station_detail
207: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
208: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
209: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
203: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
204: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
205: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
206: -- for get_duty_station_detail
207: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
208: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
209: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
210: l_fegli ghr_pa_requests.fegli%TYPE;
211: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
204: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
205: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
206: -- for get_duty_station_detail
207: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
208: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
209: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
210: l_fegli ghr_pa_requests.fegli%TYPE;
211: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
212: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
205: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
206: -- for get_duty_station_detail
207: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
208: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
209: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
210: l_fegli ghr_pa_requests.fegli%TYPE;
211: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
212: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
213: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
206: -- for get_duty_station_detail
207: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
208: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
209: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
210: l_fegli ghr_pa_requests.fegli%TYPE;
211: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
212: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
213: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
214: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
207: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
208: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
209: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
210: l_fegli ghr_pa_requests.fegli%TYPE;
211: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
212: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
213: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
214: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
215: -- for check_assignment_id
208: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
209: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
210: l_fegli ghr_pa_requests.fegli%TYPE;
211: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
212: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
213: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
214: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
215: -- for check_assignment_id
216: -- for person_in_pa_requests
209: l_custom_pay_calc_flag ghr_pa_requests.custom_pay_calc_flag%TYPE;
210: l_fegli ghr_pa_requests.fegli%TYPE;
211: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
212: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
213: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
214: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
215: -- for check_assignment_id
216: -- for person_in_pa_requests
217: l_days NUMBER := 350;
210: l_fegli ghr_pa_requests.fegli%TYPE;
211: l_fegli_desc ghr_pa_requests.fegli_desc%TYPE;
212: l_retirement_plan ghr_pa_requests.retirement_plan%TYPE;
213: l_retirement_plan_desc ghr_pa_requests.retirement_plan_desc%TYPE;
214: l_service_comp_date ghr_pa_requests.service_comp_date%TYPE;
215: -- for check_assignment_id
216: -- for person_in_pa_requests
217: l_days NUMBER := 350;
218: l_frequency NUMBER;
224: l_start_wgi_wf_flag CHAR (1) := 'N';
225: l_errbuf VARCHAR2 (2000);
226: l_retcode NUMBER := 0;
227: -- to side pay calc added for bug fix
228: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
229: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
230: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
231: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
232: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
225: l_errbuf VARCHAR2 (2000);
226: l_retcode NUMBER := 0;
227: -- to side pay calc added for bug fix
228: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
229: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
230: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
231: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
232: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
233: -- Added for WGI Custome user hook
226: l_retcode NUMBER := 0;
227: -- to side pay calc added for bug fix
228: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
229: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
230: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
231: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
232: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
233: -- Added for WGI Custome user hook
234: l_wgi_in_rec_type ghr_wgi_pkg.wgi_in_rec_type; -- This is the IN record structure for the WGI hook
227: -- to side pay calc added for bug fix
228: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
229: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
230: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
231: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
232: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
233: -- Added for WGI Custome user hook
234: l_wgi_in_rec_type ghr_wgi_pkg.wgi_in_rec_type; -- This is the IN record structure for the WGI hook
235: l_wgi_out_rec_type ghr_wgi_pkg.wgi_out_rec_type; -- This is the IN/OUT record structure for the WGI hook
228: l_to_basic_pay ghr_pa_requests.to_basic_pay%TYPE;
229: l_to_locality_adj ghr_pa_requests.to_locality_adj%TYPE;
230: l_to_adj_basic_pay ghr_pa_requests.to_adj_basic_pay%TYPE;
231: l_to_total_salary ghr_pa_requests.to_total_salary%TYPE;
232: l_to_other_pay_amount ghr_pa_requests.to_other_pay_amount%TYPE;
233: -- Added for WGI Custome user hook
234: l_wgi_in_rec_type ghr_wgi_pkg.wgi_in_rec_type; -- This is the IN record structure for the WGI hook
235: l_wgi_out_rec_type ghr_wgi_pkg.wgi_out_rec_type; -- This is the IN/OUT record structure for the WGI hook
236: --
234: l_wgi_in_rec_type ghr_wgi_pkg.wgi_in_rec_type; -- This is the IN record structure for the WGI hook
235: l_wgi_out_rec_type ghr_wgi_pkg.wgi_out_rec_type; -- This is the IN/OUT record structure for the WGI hook
236: --
237: l_open_pay_fields BOOLEAN;
238: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
239: -- Added for the output parameters these values are not used anywhere
240: l_tmp_work_schedule ghr_pa_requests.work_schedule%TYPE;
241: l_tmp_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
242: l_tmp_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
236: --
237: l_open_pay_fields BOOLEAN;
238: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
239: -- Added for the output parameters these values are not used anywhere
240: l_tmp_work_schedule ghr_pa_requests.work_schedule%TYPE;
241: l_tmp_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
242: l_tmp_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
243: l_tmp_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
244: l_tmp_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
237: l_open_pay_fields BOOLEAN;
238: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
239: -- Added for the output parameters these values are not used anywhere
240: l_tmp_work_schedule ghr_pa_requests.work_schedule%TYPE;
241: l_tmp_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
242: l_tmp_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
243: l_tmp_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
244: l_tmp_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
245: l_tmp_from_temp_step ghr_pa_requests.from_step_or_rate%TYPE;
238: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
239: -- Added for the output parameters these values are not used anywhere
240: l_tmp_work_schedule ghr_pa_requests.work_schedule%TYPE;
241: l_tmp_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
242: l_tmp_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
243: l_tmp_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
244: l_tmp_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
245: l_tmp_from_temp_step ghr_pa_requests.from_step_or_rate%TYPE;
246: -- Added pay calc record type in/out
239: -- Added for the output parameters these values are not used anywhere
240: l_tmp_work_schedule ghr_pa_requests.work_schedule%TYPE;
241: l_tmp_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
242: l_tmp_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
243: l_tmp_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
244: l_tmp_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
245: l_tmp_from_temp_step ghr_pa_requests.from_step_or_rate%TYPE;
246: -- Added pay calc record type in/out
247: l_pay_calc_in_rec_type ghr_pay_calc.pay_calc_in_rec_type;
240: l_tmp_work_schedule ghr_pa_requests.work_schedule%TYPE;
241: l_tmp_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
242: l_tmp_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
243: l_tmp_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
244: l_tmp_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
245: l_tmp_from_temp_step ghr_pa_requests.from_step_or_rate%TYPE;
246: -- Added pay calc record type in/out
247: l_pay_calc_in_rec_type ghr_pay_calc.pay_calc_in_rec_type;
248: l_pay_calc_out_rec_type ghr_pay_calc.pay_calc_out_rec_type;
241: l_tmp_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
242: l_tmp_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
243: l_tmp_from_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
244: l_tmp_from_step_or_rate ghr_pa_requests.from_step_or_rate%TYPE;
245: l_tmp_from_temp_step ghr_pa_requests.from_step_or_rate%TYPE;
246: -- Added pay calc record type in/out
247: l_pay_calc_in_rec_type ghr_pay_calc.pay_calc_in_rec_type;
248: l_pay_calc_out_rec_type ghr_pay_calc.pay_calc_out_rec_type;
249: l_req VARCHAR2 (15);
246: -- Added pay calc record type in/out
247: l_pay_calc_in_rec_type ghr_pay_calc.pay_calc_in_rec_type;
248: l_pay_calc_out_rec_type ghr_pay_calc.pay_calc_out_rec_type;
249: l_req VARCHAR2 (15);
250: l_in_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
251: l_in_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
252: -- Remarks
253: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
254: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
247: l_pay_calc_in_rec_type ghr_pay_calc.pay_calc_in_rec_type;
248: l_pay_calc_out_rec_type ghr_pay_calc.pay_calc_out_rec_type;
249: l_req VARCHAR2 (15);
250: l_in_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
251: l_in_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
252: -- Remarks
253: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
254: l_pre_object_version_number ghr_pa_remarks.object_version_number%TYPE;
255: l_remark_id1 ghr_pa_remarks.remark_id%TYPE := NULL;
314:
315: l_ret_calc_perc NUMBER (15,3);
316: l_new_retention_allowance NUMBER;
317: l_per_pay_plan per_grade_definitions.segment1%TYPE;
318: l_from_pay_table_identifier ghr_pa_requests.from_pay_table_identifier%TYPE;
319: -- Sun 4490539
320: l_check_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
321: l_check_step_or_rate ghr_pa_requests.to_step_or_rate%type;
322: -- End Sun 4490539
316: l_new_retention_allowance NUMBER;
317: l_per_pay_plan per_grade_definitions.segment1%TYPE;
318: l_from_pay_table_identifier ghr_pa_requests.from_pay_table_identifier%TYPE;
319: -- Sun 4490539
320: l_check_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
321: l_check_step_or_rate ghr_pa_requests.to_step_or_rate%type;
322: -- End Sun 4490539
323: -- vmididho 6145659
324: cursor val_pa_remarks(p_pa_request_id in number,
317: l_per_pay_plan per_grade_definitions.segment1%TYPE;
318: l_from_pay_table_identifier ghr_pa_requests.from_pay_table_identifier%TYPE;
319: -- Sun 4490539
320: l_check_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
321: l_check_step_or_rate ghr_pa_requests.to_step_or_rate%type;
322: -- End Sun 4490539
323: -- vmididho 6145659
324: cursor val_pa_remarks(p_pa_request_id in number,
325: p_remark_id in number)
1190:
1191: --
1192: -- Get SF52 Person DDF details
1193: --
1194: ghr_pa_requests_pkg.get_sf52_person_ddf_details (
1195: p_person_id => l_person_id,
1196: p_date_effective => l_effective_date,
1197: p_citizenship => l_citizenship,
1198: p_veterans_preference => l_veterans_preference,
1249:
1250: --
1251: -- Get assignment details
1252: --
1253: ghr_pa_requests_pkg.get_sf52_asg_ddf_details (
1254: p_assignment_id => l_assignment_id,
1255: p_date_effective => l_effective_date,
1256: p_tenure => l_tenure,
1257: p_annuitant_indicator => l_annuitant_indicator,
1262: --
1263: -- get fegli desc
1264: --
1265: l_annuitant_indicator_desc :=
1266: ghr_pa_requests_pkg.get_lookup_meaning (800,
1267: 'GHR_US_ANNUITANT INDICATOR',
1268: l_annuitant_indicator
1269: );
1270: --
1270: --
1271: -- populate work schedule desc
1272: --
1273: l_work_schedule_desc :=
1274: ghr_pa_requests_pkg.get_lookup_meaning (800,
1275: 'GHR_US_WORK_SCHEDULE',
1276: l_work_schedule
1277: );
1278: --
1277: );
1278: --
1279: -- Get position details
1280: --
1281: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (
1282: p_position_id => l_from_position_id,
1283: p_date_effective => l_effective_date,
1284: p_flsa_category => l_flsa_category,
1285: p_bargaining_unit_status => l_bargaining_unit_status,
1309:
1310: --
1311: -- Get location details
1312: --
1313: ghr_pa_requests_pkg.get_sf52_loc_ddf_details (
1314: p_location_id => l_location_id,
1315: p_duty_station_id => l_duty_station_id
1316: );
1317:
1331:
1332: --
1333: -- Get duty station details
1334: --
1335: ghr_pa_requests_pkg.get_duty_station_details (
1336: p_duty_station_id => l_duty_station_id,
1337: p_effective_date => l_effective_date,
1338: p_duty_station_code => l_duty_station_code,
1339: p_duty_station_desc => l_duty_station_desc
1361: p_value => l_fegli,
1362: p_multiple_error_flag => l_multiple_error_flag
1363: );
1364: l_fegli_desc :=
1365: ghr_pa_requests_pkg.get_lookup_meaning (800,
1366: 'GHR_US_FEGLI',
1367: l_fegli
1368: );
1369:
1566:
1567: IF l_retirement_plan IS NOT NULL
1568: THEN
1569: l_retirement_plan_desc :=
1570: ghr_pa_requests_pkg.get_lookup_meaning (800,
1571: 'GHR_US_RETIREMENT_PLAN',
1572: l_retirement_plan
1573: );
1574: END IF;
2254: --
2255: -- Local variables
2256: -- This function returns description and not meaning as is used to fetch only type GHR_US_LEGAL_AUTHORITY
2257: --
2258: l_effective_date ghr_pa_requests.effective_date%TYPE;
2259: l_lookup_type hr_lookups.lookup_type%TYPE;
2260: l_lookup_code hr_lookups.lookup_code%TYPE;
2261: l_meaning hr_lookups.meaning%TYPE;
2262:
2308: --
2309: -- Check assignment id
2310: --
2311: FUNCTION check_assignment_prd (
2312: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE
2313: )
2314: RETURN BOOLEAN
2315: IS
2316: --
2327: --
2328: -- Verify person in PA requests
2329: --
2330: FUNCTION person_in_pa_requests (
2331: p_person_id IN ghr_pa_requests.person_id%TYPE,
2332: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2333: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2334: p_days IN NUMBER
2335: )
2328: -- Verify person in PA requests
2329: --
2330: FUNCTION person_in_pa_requests (
2331: p_person_id IN ghr_pa_requests.person_id%TYPE,
2332: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2333: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2334: p_days IN NUMBER
2335: )
2336: RETURN BOOLEAN
2329: --
2330: FUNCTION person_in_pa_requests (
2331: p_person_id IN ghr_pa_requests.person_id%TYPE,
2332: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2333: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2334: p_days IN NUMBER
2335: )
2336: RETURN BOOLEAN
2337: IS
2339: CURSOR csr_action_taken
2340: IS
2341: SELECT pr.pa_request_id,
2342: MAX (pa_routing_history_id) pa_routing_history_id
2343: FROM ghr_pa_requests pr, ghr_pa_routing_history prh
2344: WHERE pr.pa_request_id = prh.pa_request_id
2345: AND person_id = p_person_id
2346: AND (first_noa_code = p_first_noa_code OR first_noa_code = '888'
2347: )
2406: --
2407: -- Derive Legal Authority code and Remarks
2408: --
2409: PROCEDURE derive_legal_auth_cd_remarks (
2410: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2411: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE,
2412: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2413: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2414: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2407: -- Derive Legal Authority code and Remarks
2408: --
2409: PROCEDURE derive_legal_auth_cd_remarks (
2410: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2411: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE,
2412: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2413: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2414: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2415: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2408: --
2409: PROCEDURE derive_legal_auth_cd_remarks (
2410: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2411: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE,
2412: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2413: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2414: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2415: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2416: DEFAULT NULL,
2409: PROCEDURE derive_legal_auth_cd_remarks (
2410: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2411: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE,
2412: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2413: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2414: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2415: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2416: DEFAULT NULL,
2417: p_retained_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE
2410: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2411: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE,
2412: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2413: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2414: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2415: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2416: DEFAULT NULL,
2417: p_retained_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE
2418: DEFAULT NULL,
2411: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE,
2412: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2413: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2414: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2415: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2416: DEFAULT NULL,
2417: p_retained_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE
2418: DEFAULT NULL,
2419: p_retained_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2413: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2414: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2415: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2416: DEFAULT NULL,
2417: p_retained_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE
2418: DEFAULT NULL,
2419: p_retained_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2420: DEFAULT NULL,
2421: -- Bug#5204589
2415: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2416: DEFAULT NULL,
2417: p_retained_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE
2418: DEFAULT NULL,
2419: p_retained_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2420: DEFAULT NULL,
2421: -- Bug#5204589
2422: p_temp_step IN ghr_pa_requests.from_step_or_rate%TYPE default null,
2423: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2418: DEFAULT NULL,
2419: p_retained_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2420: DEFAULT NULL,
2421: -- Bug#5204589
2422: p_temp_step IN ghr_pa_requests.from_step_or_rate%TYPE default null,
2423: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2424: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2425: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2426: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2419: p_retained_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2420: DEFAULT NULL,
2421: -- Bug#5204589
2422: p_temp_step IN ghr_pa_requests.from_step_or_rate%TYPE default null,
2423: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2424: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2425: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2426: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2427: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2420: DEFAULT NULL,
2421: -- Bug#5204589
2422: p_temp_step IN ghr_pa_requests.from_step_or_rate%TYPE default null,
2423: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2424: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2425: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2426: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2427: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2428: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2421: -- Bug#5204589
2422: p_temp_step IN ghr_pa_requests.from_step_or_rate%TYPE default null,
2423: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2424: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2425: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2426: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2427: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2428: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2429: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2422: p_temp_step IN ghr_pa_requests.from_step_or_rate%TYPE default null,
2423: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2424: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2425: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2426: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2427: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2428: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2429: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2430: p_remark1_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2423: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2424: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2425: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2426: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2427: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2428: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2429: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2430: p_remark1_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2431: p_remark1_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2436: p_remark2_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2437: p_remark2_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE
2438: )
2439: IS
2440: l_eq_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2441: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2442: l_remark_id1 ghr_remarks.remark_id%TYPE;
2443: l_remark_code1 ghr_remarks.code%TYPE := NULL;
2444: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
2437: p_remark2_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE
2438: )
2439: IS
2440: l_eq_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2441: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2442: l_remark_id1 ghr_remarks.remark_id%TYPE;
2443: l_remark_code1 ghr_remarks.code%TYPE := NULL;
2444: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
2445: l_remark_desc1_out ghr_pa_remarks.description%TYPE;
2451: l_remark1_ins3 VARCHAR2 (150) := NULL;
2452: l_remark2_ins1 VARCHAR2 (150) := NULL;
2453: l_remark2_ins2 VARCHAR2 (150) := NULL;
2454: l_remark2_ins3 VARCHAR2 (150) := NULL;
2455: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2456: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2457: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2458: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2459:
2452: l_remark2_ins1 VARCHAR2 (150) := NULL;
2453: l_remark2_ins2 VARCHAR2 (150) := NULL;
2454: l_remark2_ins3 VARCHAR2 (150) := NULL;
2455: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2456: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2457: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2458: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2459:
2460: CURSOR c_eq_pay_plan
2453: l_remark2_ins2 VARCHAR2 (150) := NULL;
2454: l_remark2_ins3 VARCHAR2 (150) := NULL;
2455: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2456: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2457: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2458: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2459:
2460: CURSOR c_eq_pay_plan
2461: IS
2454: l_remark2_ins3 VARCHAR2 (150) := NULL;
2455: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2456: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2457: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2458: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2459:
2460: CURSOR c_eq_pay_plan
2461: IS
2462: SELECT gpp.equivalent_pay_plan
2742: --
2743: --
2744: --
2745: FUNCTION checkiffwpayplan (
2746: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2747: )
2748: RETURN BOOLEAN
2749: IS
2750: --
2748: RETURN BOOLEAN
2749: IS
2750: --
2751: -- Local variables
2752: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2753:
2754: -- This function checks if the Pay plan is FW equivalent. If its the it returns TRUE otherwise FALSE
2755: --
2756: --
2779:
2780: --
2781: --
2782: FUNCTION checkpayplanparm (
2783: p_in_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2784: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2785: )
2786: RETURN BOOLEAN
2787: IS
2780: --
2781: --
2782: FUNCTION checkpayplanparm (
2783: p_in_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2784: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2785: )
2786: RETURN BOOLEAN
2787: IS
2788: --
2806:
2807: --
2808: --
2809: FUNCTION checkpoiparm (
2810: p_in_personnel_office_id IN OUT NOCOPY ghr_pa_requests.personnel_office_id%TYPE,
2811: p_position_id IN per_assignments.position_id%TYPE,
2812: p_effective_date IN ghr_pa_requests.effective_date%TYPE
2813: )
2814: RETURN BOOLEAN
2808: --
2809: FUNCTION checkpoiparm (
2810: p_in_personnel_office_id IN OUT NOCOPY ghr_pa_requests.personnel_office_id%TYPE,
2811: p_position_id IN per_assignments.position_id%TYPE,
2812: p_effective_date IN ghr_pa_requests.effective_date%TYPE
2813: )
2814: RETURN BOOLEAN
2815: IS
2816: --
2813: )
2814: RETURN BOOLEAN
2815: IS
2816: --
2817: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
2818: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
2819: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2820: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2821: l_functional_class ghr_pa_requests.functional_class%TYPE;
2814: RETURN BOOLEAN
2815: IS
2816: --
2817: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
2818: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
2819: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2820: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2821: l_functional_class ghr_pa_requests.functional_class%TYPE;
2822: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2815: IS
2816: --
2817: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
2818: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
2819: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2820: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2821: l_functional_class ghr_pa_requests.functional_class%TYPE;
2822: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2823: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2816: --
2817: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
2818: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
2819: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2820: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2821: l_functional_class ghr_pa_requests.functional_class%TYPE;
2822: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2823: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2824: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2817: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
2818: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
2819: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2820: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2821: l_functional_class ghr_pa_requests.functional_class%TYPE;
2822: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2823: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2824: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2825: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2818: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
2819: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2820: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2821: l_functional_class ghr_pa_requests.functional_class%TYPE;
2822: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2823: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2824: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2825: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2826: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2819: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2820: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2821: l_functional_class ghr_pa_requests.functional_class%TYPE;
2822: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2823: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2824: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2825: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2826: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2827: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2820: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2821: l_functional_class ghr_pa_requests.functional_class%TYPE;
2822: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2823: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2824: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2825: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2826: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2827: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2828: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
2821: l_functional_class ghr_pa_requests.functional_class%TYPE;
2822: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2823: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2824: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2825: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2826: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2827: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2828: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
2829: l_po_id ghr_pa_requests.personnel_office_id%TYPE;
2822: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2823: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2824: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2825: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2826: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2827: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2828: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
2829: l_po_id ghr_pa_requests.personnel_office_id%TYPE;
2830: --
2823: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2824: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2825: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2826: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2827: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2828: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
2829: l_po_id ghr_pa_requests.personnel_office_id%TYPE;
2830: --
2831: --
2824: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2825: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2826: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2827: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2828: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
2829: l_po_id ghr_pa_requests.personnel_office_id%TYPE;
2830: --
2831: --
2832: BEGIN
2825: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2826: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2827: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2828: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
2829: l_po_id ghr_pa_requests.personnel_office_id%TYPE;
2830: --
2831: --
2832: BEGIN
2833: --
2833: --
2834: l_po_id := p_in_personnel_office_id;
2835: IF p_in_personnel_office_id IS NOT NULL
2836: THEN
2837: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (p_position_id => p_position_id,
2838: p_date_effective => p_effective_date,
2839: p_flsa_category => l_flsa_category,
2840: p_bargaining_unit_status => l_bargaining_unit_status,
2841: p_work_schedule => l_work_schedule,
2856: RETURN FALSE;
2857: END IF;
2858: ELSE
2859: ----------------Return PO ID also
2860: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (p_position_id => p_position_id,
2861: p_date_effective => p_effective_date,
2862: p_flsa_category => l_flsa_category,
2863: p_bargaining_unit_status => l_bargaining_unit_status,
2864: p_work_schedule => l_work_schedule,
2884:
2885: --
2886: --
2887: FUNCTION checkifmaxpayplan (
2888: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2889: p_from_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2890: )
2891: RETURN BOOLEAN
2892: IS
2885: --
2886: --
2887: FUNCTION checkifmaxpayplan (
2888: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2889: p_from_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2890: )
2891: RETURN BOOLEAN
2892: IS
2893: --
2891: RETURN BOOLEAN
2892: IS
2893: --
2894: -- Local variables
2895: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2896: l_maximum_step ghr_pay_plans.maximum_step%TYPE;
2897:
2898: --
2899: -- This function checks if the Pay plan is FW equivalent. If its the it returns TRUE otherwise FALSE