200: ELSE
201: l_pay_rate_determinant := p_pay_rate_determinant_code;
202: END IF;
203: --End Bug# 5639003
204: /* Calling GHR_CPDF_CHECK1 */
205: --
206: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_bargaining_unit '|| l_proc, 10);
207: --
208:
202: END IF;
203: --End Bug# 5639003
204: /* Calling GHR_CPDF_CHECK1 */
205: --
206: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_bargaining_unit '|| l_proc, 10);
207: --
208:
209: GHR_CPDF_CHECK1.chk_bargaining_unit
210: (p_to_pay_plan
205: --
206: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_bargaining_unit '|| l_proc, 10);
207: --
208:
209: GHR_CPDF_CHECK1.chk_bargaining_unit
210: (p_to_pay_plan
211: ,p_agency_subelement
212: ,p_bargaining_unit_status_code
213: );
212: ,p_bargaining_unit_status_code
213: );
214:
215: --
216: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_fegli '|| l_proc, 11);
217: --
218:
219: GHR_CPDF_CHECK1.chk_fegli
220: (p_to_basic_pay
215: --
216: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_fegli '|| l_proc, 11);
217: --
218:
219: GHR_CPDF_CHECK1.chk_fegli
220: (p_to_basic_pay
221: ,p_to_pay_plan
222: ,p_fegli_code
223: ,p_effective_date
222: ,p_fegli_code
223: ,p_effective_date
224: );
225:
226: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_fsla_category'|| l_proc, 12);
227:
228: GHR_CPDF_CHECK1.chk_fsla_category
229: (p_duty_station_lookup_code
230: ,p_to_pay_plan
224: );
225:
226: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_fsla_category'|| l_proc, 12);
227:
228: GHR_CPDF_CHECK1.chk_fsla_category
229: (p_duty_station_lookup_code
230: ,p_to_pay_plan
231: ,p_agency_subelement
232: ,p_flsa_category
232: ,p_flsa_category
233: ,p_to_grade_or_level
234: ,p_effective_date --Bug# 5619873
235: );
236: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_functional_classification'|| l_proc, 13);
237:
238: GHR_CPDF_CHECK1.chk_functional_classification
239: (p_Occupation_code
240: ,p_functional_class
234: ,p_effective_date --Bug# 5619873
235: );
236: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_functional_classification'|| l_proc, 13);
237:
238: GHR_CPDF_CHECK1.chk_functional_classification
239: (p_Occupation_code
240: ,p_functional_class
241: ,p_effective_date --Bug# 5619873
242: );
241: ,p_effective_date --Bug# 5619873
242: );
243:
244: --
245: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_health_plan '|| l_proc, 14);
246: --
247:
248: GHR_CPDF_CHECK1.chk_health_plan
249: (p_health_plan
244: --
245: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_health_plan '|| l_proc, 14);
246: --
247:
248: GHR_CPDF_CHECK1.chk_health_plan
249: (p_health_plan
250: ,p_tenure_group_code
251: ,p_work_schedule_code
252: ,p_to_pay_basis
255: ,p_Cur_Appt_Auth_1
256: ,p_Cur_Appt_Auth_2
257: );
258:
259: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_retain_grade'|| l_proc, 15);
260:
261: GHR_CPDF_CHECK1.chk_retain_grade
262: (p_retain_pay_plan
263: ,p_retain_grade
257: );
258:
259: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_retain_grade'|| l_proc, 15);
260:
261: GHR_CPDF_CHECK1.chk_retain_grade
262: (p_retain_pay_plan
263: ,p_retain_grade
264: ,l_pay_rate_determinant
265: ,p_effective_date
263: ,p_retain_grade
264: ,l_pay_rate_determinant
265: ,p_effective_date
266: );
267: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_retain_pay_plan'|| l_proc, 16);
268:
269: GHR_CPDF_CHECK1.chk_retain_pay_plan
270: (p_retain_grade
271: ,p_retain_pay_plan
265: ,p_effective_date
266: );
267: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_retain_pay_plan'|| l_proc, 16);
268:
269: GHR_CPDF_CHECK1.chk_retain_pay_plan
270: (p_retain_grade
271: ,p_retain_pay_plan
272: ,p_retain_step
273: ,p_to_pay_plan
276:
277: );
278:
279:
280: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_retain_step'|| l_proc, 17);
281: GHR_CPDF_CHECK1.chk_retain_step
282: (l_pay_rate_determinant
283: ,p_first_action_noa_la_code1
284: ,p_first_action_noa_la_code2
277: );
278:
279:
280: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_retain_step'|| l_proc, 17);
281: GHR_CPDF_CHECK1.chk_retain_step
282: (l_pay_rate_determinant
283: ,p_first_action_noa_la_code1
284: ,p_first_action_noa_la_code2
285: ,p_Cur_Appt_Auth_1
289: ,p_retain_step
290: ,p_effective_date
291: );
292:
293: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_retirement_plan'|| l_proc, 18);
294: -- For Dual corrections with Return to Duty combination this validation has been removed
295: -- as this validation will be validated during udpate HR of second action correction of dual combination
296: --Bug #8690175 ---Bug # 8838531 added the validation for both normal and corrections
297: --ghr_history_api.get_g_session_var(l_session);
296: --Bug #8690175 ---Bug # 8838531 added the validation for both normal and corrections
297: --ghr_history_api.get_g_session_var(l_session);
298: If NOT(NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y'
299: and p_noa_family_code IN ('RETURN_TO_DUTY')) then
300: GHR_CPDF_CHECK1.chk_retirement_plan
301: (p_retirement_plan_code
302: ,p_fers_coverage
303: ,p_effective_date --Bug# 15941036 added effective date parameter
304: );
305: end if;
306: --Bug #8690175
307:
308:
309: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_special_pay_table_id'|| l_proc, 19);
310: GHR_CPDF_CHECK1.chk_special_pay_table_id
311: (l_pay_rate_determinant
312: ,p_to_pay_plan
313: ,p_special_pay_table_id
306: --Bug #8690175
307:
308:
309: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_special_pay_table_id'|| l_proc, 19);
310: GHR_CPDF_CHECK1.chk_special_pay_table_id
311: (l_pay_rate_determinant
312: ,p_to_pay_plan
313: ,p_special_pay_table_id
314: -- FWFA Changes Bug#4444609
316: -- FWFA Changes
317: );
318:
319:
320: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_us_citizenship'|| l_proc, 20);
321: GHR_CPDF_CHECK1.chk_us_citizenship
322: (p_citizenship
323: ,p_duty_station_lookup_code
324: );
317: );
318:
319:
320: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_us_citizenship'|| l_proc, 20);
321: GHR_CPDF_CHECK1.chk_us_citizenship
322: (p_citizenship
323: ,p_duty_station_lookup_code
324: );
325:
322: (p_citizenship
323: ,p_duty_station_lookup_code
324: );
325:
326: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_century_info'|| l_proc, 37);
327: GHR_CPDF_CHECK1.chk_century_info (
328: p_date_of_birth => p_employee_date_of_birth
329: ,p_effective_date => p_effective_date
330: ,p_Service_Computation_Date => p_service_computation_date
323: ,p_duty_station_lookup_code
324: );
325:
326: hr_utility.set_location('Calling GHR_CPDF_CHECK1.chk_century_info'|| l_proc, 37);
327: GHR_CPDF_CHECK1.chk_century_info (
328: p_date_of_birth => p_employee_date_of_birth
329: ,p_effective_date => p_effective_date
330: ,p_Service_Computation_Date => p_service_computation_date
331: ,p_year_degree_attained => p_year_degree_attained