[Home] [Help]
2: /* $Header: ghwgipro.pkb 120.17.12010000.1 2008/07/28 10:41:40 appldev 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)
1188:
1189: --
1190: -- Get SF52 Person DDF details
1191: --
1192: ghr_pa_requests_pkg.get_sf52_person_ddf_details (
1193: p_person_id => l_person_id,
1194: p_date_effective => l_effective_date,
1195: p_citizenship => l_citizenship,
1196: p_veterans_preference => l_veterans_preference,
1247:
1248: --
1249: -- Get assignment details
1250: --
1251: ghr_pa_requests_pkg.get_sf52_asg_ddf_details (
1252: p_assignment_id => l_assignment_id,
1253: p_date_effective => l_effective_date,
1254: p_tenure => l_tenure,
1255: p_annuitant_indicator => l_annuitant_indicator,
1260: --
1261: -- get fegli desc
1262: --
1263: l_annuitant_indicator_desc :=
1264: ghr_pa_requests_pkg.get_lookup_meaning (800,
1265: 'GHR_US_ANNUITANT INDICATOR',
1266: l_annuitant_indicator
1267: );
1268: --
1268: --
1269: -- populate work schedule desc
1270: --
1271: l_work_schedule_desc :=
1272: ghr_pa_requests_pkg.get_lookup_meaning (800,
1273: 'GHR_US_WORK_SCHEDULE',
1274: l_work_schedule
1275: );
1276: --
1275: );
1276: --
1277: -- Get position details
1278: --
1279: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (
1280: p_position_id => l_from_position_id,
1281: p_date_effective => l_effective_date,
1282: p_flsa_category => l_flsa_category,
1283: p_bargaining_unit_status => l_bargaining_unit_status,
1307:
1308: --
1309: -- Get location details
1310: --
1311: ghr_pa_requests_pkg.get_sf52_loc_ddf_details (
1312: p_location_id => l_location_id,
1313: p_duty_station_id => l_duty_station_id
1314: );
1315:
1329:
1330: --
1331: -- Get duty station details
1332: --
1333: ghr_pa_requests_pkg.get_duty_station_details (
1334: p_duty_station_id => l_duty_station_id,
1335: p_effective_date => l_effective_date,
1336: p_duty_station_code => l_duty_station_code,
1337: p_duty_station_desc => l_duty_station_desc
1359: p_value => l_fegli,
1360: p_multiple_error_flag => l_multiple_error_flag
1361: );
1362: l_fegli_desc :=
1363: ghr_pa_requests_pkg.get_lookup_meaning (800,
1364: 'GHR_US_FEGLI',
1365: l_fegli
1366: );
1367:
1564:
1565: IF l_retirement_plan IS NOT NULL
1566: THEN
1567: l_retirement_plan_desc :=
1568: ghr_pa_requests_pkg.get_lookup_meaning (800,
1569: 'GHR_US_RETIREMENT_PLAN',
1570: l_retirement_plan
1571: );
1572: END IF;
2250: --
2251: -- Local variables
2252: -- This function returns description and not meaning as is used to fetch only type GHR_US_LEGAL_AUTHORITY
2253: --
2254: l_effective_date ghr_pa_requests.effective_date%TYPE;
2255: l_lookup_type hr_lookups.lookup_type%TYPE;
2256: l_lookup_code hr_lookups.lookup_code%TYPE;
2257: l_meaning hr_lookups.meaning%TYPE;
2258:
2304: --
2305: -- Check assignment id
2306: --
2307: FUNCTION check_assignment_prd (
2308: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE
2309: )
2310: RETURN BOOLEAN
2311: IS
2312: --
2323: --
2324: -- Verify person in PA requests
2325: --
2326: FUNCTION person_in_pa_requests (
2327: p_person_id IN ghr_pa_requests.person_id%TYPE,
2328: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2329: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2330: p_days IN NUMBER
2331: )
2324: -- Verify person in PA requests
2325: --
2326: FUNCTION person_in_pa_requests (
2327: p_person_id IN ghr_pa_requests.person_id%TYPE,
2328: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2329: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2330: p_days IN NUMBER
2331: )
2332: RETURN BOOLEAN
2325: --
2326: FUNCTION person_in_pa_requests (
2327: p_person_id IN ghr_pa_requests.person_id%TYPE,
2328: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2329: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2330: p_days IN NUMBER
2331: )
2332: RETURN BOOLEAN
2333: IS
2335: CURSOR csr_action_taken
2336: IS
2337: SELECT pr.pa_request_id,
2338: MAX (pa_routing_history_id) pa_routing_history_id
2339: FROM ghr_pa_requests pr, ghr_pa_routing_history prh
2340: WHERE pr.pa_request_id = prh.pa_request_id
2341: AND person_id = p_person_id
2342: AND (first_noa_code = p_first_noa_code OR first_noa_code = '888'
2343: )
2402: --
2403: -- Derive Legal Authority code and Remarks
2404: --
2405: PROCEDURE derive_legal_auth_cd_remarks (
2406: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2407: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE,
2408: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2409: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2410: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2403: -- Derive Legal Authority code and Remarks
2404: --
2405: PROCEDURE derive_legal_auth_cd_remarks (
2406: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2407: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE,
2408: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2409: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2410: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2411: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2404: --
2405: PROCEDURE derive_legal_auth_cd_remarks (
2406: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2407: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE,
2408: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2409: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2410: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2411: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2412: DEFAULT NULL,
2405: PROCEDURE derive_legal_auth_cd_remarks (
2406: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2407: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE,
2408: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2409: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2410: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2411: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2412: DEFAULT NULL,
2413: p_retained_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE
2406: p_first_noa_code IN ghr_pa_requests.first_noa_code%TYPE,
2407: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE,
2408: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2409: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2410: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2411: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2412: DEFAULT NULL,
2413: p_retained_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE
2414: DEFAULT NULL,
2407: p_pay_rate_determinant IN ghr_pa_requests.pay_rate_determinant%TYPE,
2408: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2409: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2410: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2411: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2412: DEFAULT NULL,
2413: p_retained_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE
2414: DEFAULT NULL,
2415: p_retained_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2409: p_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE,
2410: p_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE,
2411: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2412: DEFAULT NULL,
2413: p_retained_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE
2414: DEFAULT NULL,
2415: p_retained_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2416: DEFAULT NULL,
2417: -- Bug#5204589
2411: p_retained_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2412: DEFAULT NULL,
2413: p_retained_grade_or_level IN ghr_pa_requests.from_grade_or_level%TYPE
2414: DEFAULT NULL,
2415: p_retained_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2416: DEFAULT NULL,
2417: -- Bug#5204589
2418: p_temp_step IN ghr_pa_requests.from_step_or_rate%TYPE default null,
2419: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2414: DEFAULT NULL,
2415: p_retained_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2416: DEFAULT NULL,
2417: -- Bug#5204589
2418: p_temp_step IN ghr_pa_requests.from_step_or_rate%TYPE default null,
2419: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2420: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2421: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2422: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2415: p_retained_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2416: DEFAULT NULL,
2417: -- Bug#5204589
2418: p_temp_step IN ghr_pa_requests.from_step_or_rate%TYPE default null,
2419: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2420: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2421: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2422: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2423: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2416: DEFAULT NULL,
2417: -- Bug#5204589
2418: p_temp_step IN ghr_pa_requests.from_step_or_rate%TYPE default null,
2419: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2420: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2421: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2422: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2423: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2424: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2417: -- Bug#5204589
2418: p_temp_step IN ghr_pa_requests.from_step_or_rate%TYPE default null,
2419: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2420: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2421: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2422: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2423: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2424: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2425: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2418: p_temp_step IN ghr_pa_requests.from_step_or_rate%TYPE default null,
2419: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2420: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2421: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2422: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2423: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2424: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2425: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2426: p_remark1_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2419: p_effective_date IN ghr_pa_requests.effective_date%TYPE,
2420: p_first_action_la_code1 IN OUT NOCOPY ghr_pa_requests.first_action_la_code1%TYPE,
2421: p_first_action_la_desc1 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc1%TYPE,
2422: p_first_action_la_code2 IN OUT NOCOPY ghr_pa_requests.first_action_la_code2%TYPE,
2423: p_first_action_la_desc2 IN OUT NOCOPY ghr_pa_requests.first_action_la_desc2%TYPE,
2424: p_remark_id1 OUT NOCOPY ghr_pa_remarks.remark_id%TYPE,
2425: p_remark_desc1 OUT NOCOPY ghr_pa_remarks.description%TYPE,
2426: p_remark1_info1 OUT NOCOPY ghr_pa_remarks.remark_code_information1%TYPE,
2427: p_remark1_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2432: p_remark2_info2 OUT NOCOPY ghr_pa_remarks.remark_code_information2%TYPE,
2433: p_remark2_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE
2434: )
2435: IS
2436: l_eq_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2437: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2438: l_remark_id1 ghr_remarks.remark_id%TYPE;
2439: l_remark_code1 ghr_remarks.code%TYPE := NULL;
2440: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
2433: p_remark2_info3 OUT NOCOPY ghr_pa_remarks.remark_code_information3%TYPE
2434: )
2435: IS
2436: l_eq_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2437: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2438: l_remark_id1 ghr_remarks.remark_id%TYPE;
2439: l_remark_code1 ghr_remarks.code%TYPE := NULL;
2440: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
2441: l_remark_desc1_out ghr_pa_remarks.description%TYPE;
2447: l_remark1_ins3 VARCHAR2 (150) := NULL;
2448: l_remark2_ins1 VARCHAR2 (150) := NULL;
2449: l_remark2_ins2 VARCHAR2 (150) := NULL;
2450: l_remark2_ins3 VARCHAR2 (150) := NULL;
2451: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2452: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2453: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2454: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2455:
2448: l_remark2_ins1 VARCHAR2 (150) := NULL;
2449: l_remark2_ins2 VARCHAR2 (150) := NULL;
2450: l_remark2_ins3 VARCHAR2 (150) := NULL;
2451: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2452: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2453: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2454: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2455:
2456: CURSOR c_eq_pay_plan
2449: l_remark2_ins2 VARCHAR2 (150) := NULL;
2450: l_remark2_ins3 VARCHAR2 (150) := NULL;
2451: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2452: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2453: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2454: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2455:
2456: CURSOR c_eq_pay_plan
2457: IS
2450: l_remark2_ins3 VARCHAR2 (150) := NULL;
2451: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
2452: l_first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%TYPE;
2453: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
2454: l_first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%TYPE;
2455:
2456: CURSOR c_eq_pay_plan
2457: IS
2458: SELECT gpp.equivalent_pay_plan
2738: --
2739: --
2740: --
2741: FUNCTION checkiffwpayplan (
2742: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2743: )
2744: RETURN BOOLEAN
2745: IS
2746: --
2744: RETURN BOOLEAN
2745: IS
2746: --
2747: -- Local variables
2748: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2749:
2750: -- This function checks if the Pay plan is FW equivalent. If its the it returns TRUE otherwise FALSE
2751: --
2752: --
2775:
2776: --
2777: --
2778: FUNCTION checkpayplanparm (
2779: p_in_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2780: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2781: )
2782: RETURN BOOLEAN
2783: IS
2776: --
2777: --
2778: FUNCTION checkpayplanparm (
2779: p_in_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2780: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE
2781: )
2782: RETURN BOOLEAN
2783: IS
2784: --
2802:
2803: --
2804: --
2805: FUNCTION checkpoiparm (
2806: p_in_personnel_office_id IN OUT NOCOPY ghr_pa_requests.personnel_office_id%TYPE,
2807: p_position_id IN per_assignments.position_id%TYPE,
2808: p_effective_date IN ghr_pa_requests.effective_date%TYPE
2809: )
2810: RETURN BOOLEAN
2804: --
2805: FUNCTION checkpoiparm (
2806: p_in_personnel_office_id IN OUT NOCOPY ghr_pa_requests.personnel_office_id%TYPE,
2807: p_position_id IN per_assignments.position_id%TYPE,
2808: p_effective_date IN ghr_pa_requests.effective_date%TYPE
2809: )
2810: RETURN BOOLEAN
2811: IS
2812: --
2809: )
2810: RETURN BOOLEAN
2811: IS
2812: --
2813: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
2814: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
2815: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2816: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2817: l_functional_class ghr_pa_requests.functional_class%TYPE;
2810: RETURN BOOLEAN
2811: IS
2812: --
2813: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
2814: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
2815: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2816: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2817: l_functional_class ghr_pa_requests.functional_class%TYPE;
2818: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2811: IS
2812: --
2813: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
2814: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
2815: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2816: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2817: l_functional_class ghr_pa_requests.functional_class%TYPE;
2818: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2819: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2812: --
2813: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
2814: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
2815: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2816: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2817: l_functional_class ghr_pa_requests.functional_class%TYPE;
2818: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2819: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2820: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2813: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
2814: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
2815: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2816: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2817: l_functional_class ghr_pa_requests.functional_class%TYPE;
2818: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2819: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2820: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2821: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2814: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
2815: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2816: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2817: l_functional_class ghr_pa_requests.functional_class%TYPE;
2818: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2819: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2820: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2821: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2822: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2815: l_work_schedule ghr_pa_requests.work_schedule%TYPE;
2816: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2817: l_functional_class ghr_pa_requests.functional_class%TYPE;
2818: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2819: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2820: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2821: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2822: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2823: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2816: l_work_schedule_desc ghr_pa_requests.work_schedule_desc%TYPE;
2817: l_functional_class ghr_pa_requests.functional_class%TYPE;
2818: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2819: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2820: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2821: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2822: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2823: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2824: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
2817: l_functional_class ghr_pa_requests.functional_class%TYPE;
2818: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2819: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2820: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2821: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2822: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2823: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2824: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
2825: l_po_id ghr_pa_requests.personnel_office_id%TYPE;
2818: l_supervisory_status ghr_pa_requests.supervisory_status%TYPE;
2819: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2820: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2821: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2822: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2823: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2824: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
2825: l_po_id ghr_pa_requests.personnel_office_id%TYPE;
2826: --
2819: l_position_occupied ghr_pa_requests.position_occupied%TYPE;
2820: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2821: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2822: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2823: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2824: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
2825: l_po_id ghr_pa_requests.personnel_office_id%TYPE;
2826: --
2827: --
2820: l_appropriation_code1 ghr_pa_requests.appropriation_code1%TYPE;
2821: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2822: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2823: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2824: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
2825: l_po_id ghr_pa_requests.personnel_office_id%TYPE;
2826: --
2827: --
2828: BEGIN
2821: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
2822: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2823: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
2824: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
2825: l_po_id ghr_pa_requests.personnel_office_id%TYPE;
2826: --
2827: --
2828: BEGIN
2829: --
2829: --
2830: l_po_id := p_in_personnel_office_id;
2831: IF p_in_personnel_office_id IS NOT NULL
2832: THEN
2833: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (p_position_id => p_position_id,
2834: p_date_effective => p_effective_date,
2835: p_flsa_category => l_flsa_category,
2836: p_bargaining_unit_status => l_bargaining_unit_status,
2837: p_work_schedule => l_work_schedule,
2852: RETURN FALSE;
2853: END IF;
2854: ELSE
2855: ----------------Return PO ID also
2856: ghr_pa_requests_pkg.get_sf52_pos_ddf_details (p_position_id => p_position_id,
2857: p_date_effective => p_effective_date,
2858: p_flsa_category => l_flsa_category,
2859: p_bargaining_unit_status => l_bargaining_unit_status,
2860: p_work_schedule => l_work_schedule,
2880:
2881: --
2882: --
2883: FUNCTION checkifmaxpayplan (
2884: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2885: p_from_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2886: )
2887: RETURN BOOLEAN
2888: IS
2881: --
2882: --
2883: FUNCTION checkifmaxpayplan (
2884: p_from_pay_plan IN ghr_pa_requests.from_pay_plan%TYPE,
2885: p_from_step_or_rate IN ghr_pa_requests.from_step_or_rate%TYPE
2886: )
2887: RETURN BOOLEAN
2888: IS
2889: --
2887: RETURN BOOLEAN
2888: IS
2889: --
2890: -- Local variables
2891: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2892: l_maximum_step ghr_pay_plans.maximum_step%TYPE;
2893:
2894: --
2895: -- This function checks if the Pay plan is FW equivalent. If its the it returns TRUE otherwise FALSE