APPS.GHR_SF52_API dependencies on GHR_API

Line 287: l_asg_sf52 ghr_api.asg_sf52_type;

283: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
284: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
285: l_status ghr_pa_requests.status%type;
286: l_message boolean := FALSE;
287: l_asg_sf52 ghr_api.asg_sf52_type;
288: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
289: l_asg_nte_dates ghr_api.asg_nte_dates_type;
290: l_per_sf52 ghr_api.per_sf52_type;
291: l_per_group1 ghr_api.per_group1_type;

Line 288: l_asg_non_sf52 ghr_api.asg_non_sf52_type;

284: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
285: l_status ghr_pa_requests.status%type;
286: l_message boolean := FALSE;
287: l_asg_sf52 ghr_api.asg_sf52_type;
288: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
289: l_asg_nte_dates ghr_api.asg_nte_dates_type;
290: l_per_sf52 ghr_api.per_sf52_type;
291: l_per_group1 ghr_api.per_group1_type;
292: l_per_group2 ghr_api.per_group2_type;

Line 289: l_asg_nte_dates ghr_api.asg_nte_dates_type;

285: l_status ghr_pa_requests.status%type;
286: l_message boolean := FALSE;
287: l_asg_sf52 ghr_api.asg_sf52_type;
288: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
289: l_asg_nte_dates ghr_api.asg_nte_dates_type;
290: l_per_sf52 ghr_api.per_sf52_type;
291: l_per_group1 ghr_api.per_group1_type;
292: l_per_group2 ghr_api.per_group2_type;
293: l_per_scd_info ghr_api.per_scd_info_type;

Line 290: l_per_sf52 ghr_api.per_sf52_type;

286: l_message boolean := FALSE;
287: l_asg_sf52 ghr_api.asg_sf52_type;
288: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
289: l_asg_nte_dates ghr_api.asg_nte_dates_type;
290: l_per_sf52 ghr_api.per_sf52_type;
291: l_per_group1 ghr_api.per_group1_type;
292: l_per_group2 ghr_api.per_group2_type;
293: l_per_scd_info ghr_api.per_scd_info_type;
294: l_per_retained_grade ghr_api.per_retained_grade_type;

Line 291: l_per_group1 ghr_api.per_group1_type;

287: l_asg_sf52 ghr_api.asg_sf52_type;
288: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
289: l_asg_nte_dates ghr_api.asg_nte_dates_type;
290: l_per_sf52 ghr_api.per_sf52_type;
291: l_per_group1 ghr_api.per_group1_type;
292: l_per_group2 ghr_api.per_group2_type;
293: l_per_scd_info ghr_api.per_scd_info_type;
294: l_per_retained_grade ghr_api.per_retained_grade_type;
295: l_per_probations ghr_api.per_probations_type;

Line 292: l_per_group2 ghr_api.per_group2_type;

288: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
289: l_asg_nte_dates ghr_api.asg_nte_dates_type;
290: l_per_sf52 ghr_api.per_sf52_type;
291: l_per_group1 ghr_api.per_group1_type;
292: l_per_group2 ghr_api.per_group2_type;
293: l_per_scd_info ghr_api.per_scd_info_type;
294: l_per_retained_grade ghr_api.per_retained_grade_type;
295: l_per_probations ghr_api.per_probations_type;
296: l_per_sep_retire ghr_api.per_sep_retire_type;

Line 293: l_per_scd_info ghr_api.per_scd_info_type;

289: l_asg_nte_dates ghr_api.asg_nte_dates_type;
290: l_per_sf52 ghr_api.per_sf52_type;
291: l_per_group1 ghr_api.per_group1_type;
292: l_per_group2 ghr_api.per_group2_type;
293: l_per_scd_info ghr_api.per_scd_info_type;
294: l_per_retained_grade ghr_api.per_retained_grade_type;
295: l_per_probations ghr_api.per_probations_type;
296: l_per_sep_retire ghr_api.per_sep_retire_type;
297: l_per_security ghr_api.per_security_type;

Line 294: l_per_retained_grade ghr_api.per_retained_grade_type;

290: l_per_sf52 ghr_api.per_sf52_type;
291: l_per_group1 ghr_api.per_group1_type;
292: l_per_group2 ghr_api.per_group2_type;
293: l_per_scd_info ghr_api.per_scd_info_type;
294: l_per_retained_grade ghr_api.per_retained_grade_type;
295: l_per_probations ghr_api.per_probations_type;
296: l_per_sep_retire ghr_api.per_sep_retire_type;
297: l_per_security ghr_api.per_security_type;
298: l_per_conversions ghr_api.per_conversions_type;

Line 295: l_per_probations ghr_api.per_probations_type;

291: l_per_group1 ghr_api.per_group1_type;
292: l_per_group2 ghr_api.per_group2_type;
293: l_per_scd_info ghr_api.per_scd_info_type;
294: l_per_retained_grade ghr_api.per_retained_grade_type;
295: l_per_probations ghr_api.per_probations_type;
296: l_per_sep_retire ghr_api.per_sep_retire_type;
297: l_per_security ghr_api.per_security_type;
298: l_per_conversions ghr_api.per_conversions_type;
299: l_per_uniformed_services ghr_api.per_uniformed_services_type;

Line 296: l_per_sep_retire ghr_api.per_sep_retire_type;

292: l_per_group2 ghr_api.per_group2_type;
293: l_per_scd_info ghr_api.per_scd_info_type;
294: l_per_retained_grade ghr_api.per_retained_grade_type;
295: l_per_probations ghr_api.per_probations_type;
296: l_per_sep_retire ghr_api.per_sep_retire_type;
297: l_per_security ghr_api.per_security_type;
298: l_per_conversions ghr_api.per_conversions_type;
299: l_per_uniformed_services ghr_api.per_uniformed_services_type;
300: l_pos_oblig ghr_api.pos_oblig_type;

Line 297: l_per_security ghr_api.per_security_type;

293: l_per_scd_info ghr_api.per_scd_info_type;
294: l_per_retained_grade ghr_api.per_retained_grade_type;
295: l_per_probations ghr_api.per_probations_type;
296: l_per_sep_retire ghr_api.per_sep_retire_type;
297: l_per_security ghr_api.per_security_type;
298: l_per_conversions ghr_api.per_conversions_type;
299: l_per_uniformed_services ghr_api.per_uniformed_services_type;
300: l_pos_oblig ghr_api.pos_oblig_type;
301: l_pos_grp2 ghr_api.pos_grp2_type;

Line 298: l_per_conversions ghr_api.per_conversions_type;

294: l_per_retained_grade ghr_api.per_retained_grade_type;
295: l_per_probations ghr_api.per_probations_type;
296: l_per_sep_retire ghr_api.per_sep_retire_type;
297: l_per_security ghr_api.per_security_type;
298: l_per_conversions ghr_api.per_conversions_type;
299: l_per_uniformed_services ghr_api.per_uniformed_services_type;
300: l_pos_oblig ghr_api.pos_oblig_type;
301: l_pos_grp2 ghr_api.pos_grp2_type;
302: l_pos_grp1 ghr_api.pos_grp1_type;

Line 299: l_per_uniformed_services ghr_api.per_uniformed_services_type;

295: l_per_probations ghr_api.per_probations_type;
296: l_per_sep_retire ghr_api.per_sep_retire_type;
297: l_per_security ghr_api.per_security_type;
298: l_per_conversions ghr_api.per_conversions_type;
299: l_per_uniformed_services ghr_api.per_uniformed_services_type;
300: l_pos_oblig ghr_api.pos_oblig_type;
301: l_pos_grp2 ghr_api.pos_grp2_type;
302: l_pos_grp1 ghr_api.pos_grp1_type;
303: l_pos_valid_grade ghr_api.pos_valid_grade_type;

Line 300: l_pos_oblig ghr_api.pos_oblig_type;

296: l_per_sep_retire ghr_api.per_sep_retire_type;
297: l_per_security ghr_api.per_security_type;
298: l_per_conversions ghr_api.per_conversions_type;
299: l_per_uniformed_services ghr_api.per_uniformed_services_type;
300: l_pos_oblig ghr_api.pos_oblig_type;
301: l_pos_grp2 ghr_api.pos_grp2_type;
302: l_pos_grp1 ghr_api.pos_grp1_type;
303: l_pos_valid_grade ghr_api.pos_valid_grade_type;
304: l_pos_car_prog ghr_api.pos_car_prog_type;

Line 301: l_pos_grp2 ghr_api.pos_grp2_type;

297: l_per_security ghr_api.per_security_type;
298: l_per_conversions ghr_api.per_conversions_type;
299: l_per_uniformed_services ghr_api.per_uniformed_services_type;
300: l_pos_oblig ghr_api.pos_oblig_type;
301: l_pos_grp2 ghr_api.pos_grp2_type;
302: l_pos_grp1 ghr_api.pos_grp1_type;
303: l_pos_valid_grade ghr_api.pos_valid_grade_type;
304: l_pos_car_prog ghr_api.pos_car_prog_type;
305: l_loc_info ghr_api.loc_info_type;

Line 302: l_pos_grp1 ghr_api.pos_grp1_type;

298: l_per_conversions ghr_api.per_conversions_type;
299: l_per_uniformed_services ghr_api.per_uniformed_services_type;
300: l_pos_oblig ghr_api.pos_oblig_type;
301: l_pos_grp2 ghr_api.pos_grp2_type;
302: l_pos_grp1 ghr_api.pos_grp1_type;
303: l_pos_valid_grade ghr_api.pos_valid_grade_type;
304: l_pos_car_prog ghr_api.pos_car_prog_type;
305: l_loc_info ghr_api.loc_info_type;
306: l_wgi ghr_api.within_grade_increase_type;

Line 303: l_pos_valid_grade ghr_api.pos_valid_grade_type;

299: l_per_uniformed_services ghr_api.per_uniformed_services_type;
300: l_pos_oblig ghr_api.pos_oblig_type;
301: l_pos_grp2 ghr_api.pos_grp2_type;
302: l_pos_grp1 ghr_api.pos_grp1_type;
303: l_pos_valid_grade ghr_api.pos_valid_grade_type;
304: l_pos_car_prog ghr_api.pos_car_prog_type;
305: l_loc_info ghr_api.loc_info_type;
306: l_wgi ghr_api.within_grade_increase_type;
307: l_recruitment_bonus ghr_api.recruitment_bonus_type;

Line 304: l_pos_car_prog ghr_api.pos_car_prog_type;

300: l_pos_oblig ghr_api.pos_oblig_type;
301: l_pos_grp2 ghr_api.pos_grp2_type;
302: l_pos_grp1 ghr_api.pos_grp1_type;
303: l_pos_valid_grade ghr_api.pos_valid_grade_type;
304: l_pos_car_prog ghr_api.pos_car_prog_type;
305: l_loc_info ghr_api.loc_info_type;
306: l_wgi ghr_api.within_grade_increase_type;
307: l_recruitment_bonus ghr_api.recruitment_bonus_type;
308: l_relocation_bonus ghr_api.relocation_bonus_type;

Line 305: l_loc_info ghr_api.loc_info_type;

301: l_pos_grp2 ghr_api.pos_grp2_type;
302: l_pos_grp1 ghr_api.pos_grp1_type;
303: l_pos_valid_grade ghr_api.pos_valid_grade_type;
304: l_pos_car_prog ghr_api.pos_car_prog_type;
305: l_loc_info ghr_api.loc_info_type;
306: l_wgi ghr_api.within_grade_increase_type;
307: l_recruitment_bonus ghr_api.recruitment_bonus_type;
308: l_relocation_bonus ghr_api.relocation_bonus_type;
309:

Line 306: l_wgi ghr_api.within_grade_increase_type;

302: l_pos_grp1 ghr_api.pos_grp1_type;
303: l_pos_valid_grade ghr_api.pos_valid_grade_type;
304: l_pos_car_prog ghr_api.pos_car_prog_type;
305: l_loc_info ghr_api.loc_info_type;
306: l_wgi ghr_api.within_grade_increase_type;
307: l_recruitment_bonus ghr_api.recruitment_bonus_type;
308: l_relocation_bonus ghr_api.relocation_bonus_type;
309:
310: --Pradeep

Line 307: l_recruitment_bonus ghr_api.recruitment_bonus_type;

303: l_pos_valid_grade ghr_api.pos_valid_grade_type;
304: l_pos_car_prog ghr_api.pos_car_prog_type;
305: l_loc_info ghr_api.loc_info_type;
306: l_wgi ghr_api.within_grade_increase_type;
307: l_recruitment_bonus ghr_api.recruitment_bonus_type;
308: l_relocation_bonus ghr_api.relocation_bonus_type;
309:
310: --Pradeep
311: l_mddds_special_pay ghr_api.mddds_special_pay_type;

Line 308: l_relocation_bonus ghr_api.relocation_bonus_type;

304: l_pos_car_prog ghr_api.pos_car_prog_type;
305: l_loc_info ghr_api.loc_info_type;
306: l_wgi ghr_api.within_grade_increase_type;
307: l_recruitment_bonus ghr_api.recruitment_bonus_type;
308: l_relocation_bonus ghr_api.relocation_bonus_type;
309:
310: --Pradeep
311: l_mddds_special_pay ghr_api.mddds_special_pay_type;
312: l_sf52_from_data ghr_api.prior_sf52_data_type;

Line 311: l_mddds_special_pay ghr_api.mddds_special_pay_type;

307: l_recruitment_bonus ghr_api.recruitment_bonus_type;
308: l_relocation_bonus ghr_api.relocation_bonus_type;
309:
310: --Pradeep
311: l_mddds_special_pay ghr_api.mddds_special_pay_type;
312: l_sf52_from_data ghr_api.prior_sf52_data_type;
313: l_personal_info ghr_api.personal_info_type;
314: l_gov_awards_type ghr_api.government_awards_type;
315: l_perf_appraisal_type ghr_api.performance_appraisal_type;

Line 312: l_sf52_from_data ghr_api.prior_sf52_data_type;

308: l_relocation_bonus ghr_api.relocation_bonus_type;
309:
310: --Pradeep
311: l_mddds_special_pay ghr_api.mddds_special_pay_type;
312: l_sf52_from_data ghr_api.prior_sf52_data_type;
313: l_personal_info ghr_api.personal_info_type;
314: l_gov_awards_type ghr_api.government_awards_type;
315: l_perf_appraisal_type ghr_api.performance_appraisal_type;
316: l_payroll_type ghr_api.government_payroll_type;

Line 313: l_personal_info ghr_api.personal_info_type;

309:
310: --Pradeep
311: l_mddds_special_pay ghr_api.mddds_special_pay_type;
312: l_sf52_from_data ghr_api.prior_sf52_data_type;
313: l_personal_info ghr_api.personal_info_type;
314: l_gov_awards_type ghr_api.government_awards_type;
315: l_perf_appraisal_type ghr_api.performance_appraisal_type;
316: l_payroll_type ghr_api.government_payroll_type;
317: l_conduct_perf_type ghr_api.conduct_performance_type;

Line 314: l_gov_awards_type ghr_api.government_awards_type;

310: --Pradeep
311: l_mddds_special_pay ghr_api.mddds_special_pay_type;
312: l_sf52_from_data ghr_api.prior_sf52_data_type;
313: l_personal_info ghr_api.personal_info_type;
314: l_gov_awards_type ghr_api.government_awards_type;
315: l_perf_appraisal_type ghr_api.performance_appraisal_type;
316: l_payroll_type ghr_api.government_payroll_type;
317: l_conduct_perf_type ghr_api.conduct_performance_type;
318: l_agency_sf52 ghr_api.agency_sf52_type;

Line 315: l_perf_appraisal_type ghr_api.performance_appraisal_type;

311: l_mddds_special_pay ghr_api.mddds_special_pay_type;
312: l_sf52_from_data ghr_api.prior_sf52_data_type;
313: l_personal_info ghr_api.personal_info_type;
314: l_gov_awards_type ghr_api.government_awards_type;
315: l_perf_appraisal_type ghr_api.performance_appraisal_type;
316: l_payroll_type ghr_api.government_payroll_type;
317: l_conduct_perf_type ghr_api.conduct_performance_type;
318: l_agency_sf52 ghr_api.agency_sf52_type;
319: l_agency_code varchar2(80);

Line 316: l_payroll_type ghr_api.government_payroll_type;

312: l_sf52_from_data ghr_api.prior_sf52_data_type;
313: l_personal_info ghr_api.personal_info_type;
314: l_gov_awards_type ghr_api.government_awards_type;
315: l_perf_appraisal_type ghr_api.performance_appraisal_type;
316: l_payroll_type ghr_api.government_payroll_type;
317: l_conduct_perf_type ghr_api.conduct_performance_type;
318: l_agency_sf52 ghr_api.agency_sf52_type;
319: l_agency_code varchar2(80);
320: l_imm_entitlement ghr_api.entitlement_type;

Line 317: l_conduct_perf_type ghr_api.conduct_performance_type;

313: l_personal_info ghr_api.personal_info_type;
314: l_gov_awards_type ghr_api.government_awards_type;
315: l_perf_appraisal_type ghr_api.performance_appraisal_type;
316: l_payroll_type ghr_api.government_payroll_type;
317: l_conduct_perf_type ghr_api.conduct_performance_type;
318: l_agency_sf52 ghr_api.agency_sf52_type;
319: l_agency_code varchar2(80);
320: l_imm_entitlement ghr_api.entitlement_type;
321: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

Line 318: l_agency_sf52 ghr_api.agency_sf52_type;

314: l_gov_awards_type ghr_api.government_awards_type;
315: l_perf_appraisal_type ghr_api.performance_appraisal_type;
316: l_payroll_type ghr_api.government_payroll_type;
317: l_conduct_perf_type ghr_api.conduct_performance_type;
318: l_agency_sf52 ghr_api.agency_sf52_type;
319: l_agency_code varchar2(80);
320: l_imm_entitlement ghr_api.entitlement_type;
321: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
322: l_imm_edp_pay ghr_api.edp_pay_type;

Line 320: l_imm_entitlement ghr_api.entitlement_type;

316: l_payroll_type ghr_api.government_payroll_type;
317: l_conduct_perf_type ghr_api.conduct_performance_type;
318: l_agency_sf52 ghr_api.agency_sf52_type;
319: l_agency_code varchar2(80);
320: l_imm_entitlement ghr_api.entitlement_type;
321: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
322: l_imm_edp_pay ghr_api.edp_pay_type;
323: l_imm_hazard_pay ghr_api.hazard_pay_type;
324: l_imm_health_benefits ghr_api.health_benefits_type;

Line 321: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

317: l_conduct_perf_type ghr_api.conduct_performance_type;
318: l_agency_sf52 ghr_api.agency_sf52_type;
319: l_agency_code varchar2(80);
320: l_imm_entitlement ghr_api.entitlement_type;
321: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
322: l_imm_edp_pay ghr_api.edp_pay_type;
323: l_imm_hazard_pay ghr_api.hazard_pay_type;
324: l_imm_health_benefits ghr_api.health_benefits_type;
325: l_imm_danger_pay ghr_api.danger_pay_type;

Line 322: l_imm_edp_pay ghr_api.edp_pay_type;

318: l_agency_sf52 ghr_api.agency_sf52_type;
319: l_agency_code varchar2(80);
320: l_imm_entitlement ghr_api.entitlement_type;
321: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
322: l_imm_edp_pay ghr_api.edp_pay_type;
323: l_imm_hazard_pay ghr_api.hazard_pay_type;
324: l_imm_health_benefits ghr_api.health_benefits_type;
325: l_imm_danger_pay ghr_api.danger_pay_type;
326: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;

Line 323: l_imm_hazard_pay ghr_api.hazard_pay_type;

319: l_agency_code varchar2(80);
320: l_imm_entitlement ghr_api.entitlement_type;
321: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
322: l_imm_edp_pay ghr_api.edp_pay_type;
323: l_imm_hazard_pay ghr_api.hazard_pay_type;
324: l_imm_health_benefits ghr_api.health_benefits_type;
325: l_imm_danger_pay ghr_api.danger_pay_type;
326: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
327: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;

Line 324: l_imm_health_benefits ghr_api.health_benefits_type;

320: l_imm_entitlement ghr_api.entitlement_type;
321: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
322: l_imm_edp_pay ghr_api.edp_pay_type;
323: l_imm_hazard_pay ghr_api.hazard_pay_type;
324: l_imm_health_benefits ghr_api.health_benefits_type;
325: l_imm_danger_pay ghr_api.danger_pay_type;
326: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
327: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
328: l_imm_post_diff_amt ghr_api.post_diff_amt_type;

Line 325: l_imm_danger_pay ghr_api.danger_pay_type;

321: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
322: l_imm_edp_pay ghr_api.edp_pay_type;
323: l_imm_hazard_pay ghr_api.hazard_pay_type;
324: l_imm_health_benefits ghr_api.health_benefits_type;
325: l_imm_danger_pay ghr_api.danger_pay_type;
326: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
327: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
328: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
329: l_imm_post_diff_percent ghr_api.post_diff_percent_type;

Line 326: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;

322: l_imm_edp_pay ghr_api.edp_pay_type;
323: l_imm_hazard_pay ghr_api.hazard_pay_type;
324: l_imm_health_benefits ghr_api.health_benefits_type;
325: l_imm_danger_pay ghr_api.danger_pay_type;
326: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
327: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
328: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
329: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
330: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

Line 327: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;

323: l_imm_hazard_pay ghr_api.hazard_pay_type;
324: l_imm_health_benefits ghr_api.health_benefits_type;
325: l_imm_danger_pay ghr_api.danger_pay_type;
326: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
327: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
328: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
329: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
330: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
331: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;

Line 328: l_imm_post_diff_amt ghr_api.post_diff_amt_type;

324: l_imm_health_benefits ghr_api.health_benefits_type;
325: l_imm_danger_pay ghr_api.danger_pay_type;
326: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
327: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
328: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
329: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
330: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
331: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
332: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;

Line 329: l_imm_post_diff_percent ghr_api.post_diff_percent_type;

325: l_imm_danger_pay ghr_api.danger_pay_type;
326: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
327: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
328: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
329: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
330: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
331: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
332: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
333: l_imm_premium_pay ghr_api.premium_pay_type;

Line 330: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

326: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
327: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
328: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
329: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
330: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
331: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
332: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
333: l_imm_premium_pay ghr_api.premium_pay_type;
334: l_imm_retirement_annuity ghr_api.retirement_annuity_type;

Line 331: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;

327: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
328: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
329: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
330: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
331: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
332: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
333: l_imm_premium_pay ghr_api.premium_pay_type;
334: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
335: l_imm_severance_pay ghr_api.severance_pay_type;

Line 332: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;

328: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
329: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
330: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
331: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
332: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
333: l_imm_premium_pay ghr_api.premium_pay_type;
334: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
335: l_imm_severance_pay ghr_api.severance_pay_type;
336: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;

Line 333: l_imm_premium_pay ghr_api.premium_pay_type;

329: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
330: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
331: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
332: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
333: l_imm_premium_pay ghr_api.premium_pay_type;
334: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
335: l_imm_severance_pay ghr_api.severance_pay_type;
336: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
337: l_imm_retention_allow_review ghr_api.retention_allow_review_type;

Line 334: l_imm_retirement_annuity ghr_api.retirement_annuity_type;

330: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
331: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
332: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
333: l_imm_premium_pay ghr_api.premium_pay_type;
334: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
335: l_imm_severance_pay ghr_api.severance_pay_type;
336: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
337: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
338: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

Line 335: l_imm_severance_pay ghr_api.severance_pay_type;

331: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
332: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
333: l_imm_premium_pay ghr_api.premium_pay_type;
334: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
335: l_imm_severance_pay ghr_api.severance_pay_type;
336: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
337: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
338: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
339: l_imm_per_benefit_info ghr_api.per_benefit_info_type;

Line 336: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;

332: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
333: l_imm_premium_pay ghr_api.premium_pay_type;
334: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
335: l_imm_severance_pay ghr_api.severance_pay_type;
336: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
337: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
338: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
339: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
340: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104

Line 337: l_imm_retention_allow_review ghr_api.retention_allow_review_type;

333: l_imm_premium_pay ghr_api.premium_pay_type;
334: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
335: l_imm_severance_pay ghr_api.severance_pay_type;
336: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
337: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
338: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
339: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
340: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
341: --Begin Bug# 10181661

Line 338: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

334: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
335: l_imm_severance_pay ghr_api.severance_pay_type;
336: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
337: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
338: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
339: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
340: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
341: --Begin Bug# 10181661
342: l_imm_asg_detail_info ghr_api.asg_detail_info_type;

Line 339: l_imm_per_benefit_info ghr_api.per_benefit_info_type;

335: l_imm_severance_pay ghr_api.severance_pay_type;
336: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
337: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
338: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
339: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
340: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
341: --Begin Bug# 10181661
342: l_imm_asg_detail_info ghr_api.asg_detail_info_type;
343: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;

Line 340: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104

336: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
337: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
338: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
339: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
340: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
341: --Begin Bug# 10181661
342: l_imm_asg_detail_info ghr_api.asg_detail_info_type;
343: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
344: --End Bug# 10181661

Line 342: l_imm_asg_detail_info ghr_api.asg_detail_info_type;

338: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
339: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
340: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
341: --Begin Bug# 10181661
342: l_imm_asg_detail_info ghr_api.asg_detail_info_type;
343: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
344: --End Bug# 10181661
345:
346: /* Cursor C_user_emp_names is

Line 343: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;

339: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
340: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
341: --Begin Bug# 10181661
342: l_imm_asg_detail_info ghr_api.asg_detail_info_type;
343: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
344: --End Bug# 10181661
345:
346: /* Cursor C_user_emp_names is
347: select usr.employee_id,

Line 1684: ghr_api.call_workflow

1680: end if;
1681: End if;
1682: if (l_action_taken not in ('UPDATE_HR','END_ROUTING')) then
1683: -- call workflow
1684: ghr_api.call_workflow
1685: (p_pa_request_id => l_pa_request_id
1686: ,p_action_taken => l_action_taken
1687: );
1688: end if;

Line 2292: l_asg_sf52 ghr_api.asg_sf52_type;

2288: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
2289: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
2290: l_status ghr_pa_requests.status%type;
2291: l_message boolean := FALSE;
2292: l_asg_sf52 ghr_api.asg_sf52_type;
2293: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2294: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2295: l_per_sf52 ghr_api.per_sf52_type;
2296: l_per_group1 ghr_api.per_group1_type;

Line 2293: l_asg_non_sf52 ghr_api.asg_non_sf52_type;

2289: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
2290: l_status ghr_pa_requests.status%type;
2291: l_message boolean := FALSE;
2292: l_asg_sf52 ghr_api.asg_sf52_type;
2293: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2294: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2295: l_per_sf52 ghr_api.per_sf52_type;
2296: l_per_group1 ghr_api.per_group1_type;
2297: l_per_group2 ghr_api.per_group2_type;

Line 2294: l_asg_nte_dates ghr_api.asg_nte_dates_type;

2290: l_status ghr_pa_requests.status%type;
2291: l_message boolean := FALSE;
2292: l_asg_sf52 ghr_api.asg_sf52_type;
2293: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2294: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2295: l_per_sf52 ghr_api.per_sf52_type;
2296: l_per_group1 ghr_api.per_group1_type;
2297: l_per_group2 ghr_api.per_group2_type;
2298: l_per_scd_info ghr_api.per_scd_info_type;

Line 2295: l_per_sf52 ghr_api.per_sf52_type;

2291: l_message boolean := FALSE;
2292: l_asg_sf52 ghr_api.asg_sf52_type;
2293: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2294: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2295: l_per_sf52 ghr_api.per_sf52_type;
2296: l_per_group1 ghr_api.per_group1_type;
2297: l_per_group2 ghr_api.per_group2_type;
2298: l_per_scd_info ghr_api.per_scd_info_type;
2299: l_per_retained_grade ghr_api.per_retained_grade_type;

Line 2296: l_per_group1 ghr_api.per_group1_type;

2292: l_asg_sf52 ghr_api.asg_sf52_type;
2293: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2294: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2295: l_per_sf52 ghr_api.per_sf52_type;
2296: l_per_group1 ghr_api.per_group1_type;
2297: l_per_group2 ghr_api.per_group2_type;
2298: l_per_scd_info ghr_api.per_scd_info_type;
2299: l_per_retained_grade ghr_api.per_retained_grade_type;
2300: l_per_probations ghr_api.per_probations_type;

Line 2297: l_per_group2 ghr_api.per_group2_type;

2293: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2294: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2295: l_per_sf52 ghr_api.per_sf52_type;
2296: l_per_group1 ghr_api.per_group1_type;
2297: l_per_group2 ghr_api.per_group2_type;
2298: l_per_scd_info ghr_api.per_scd_info_type;
2299: l_per_retained_grade ghr_api.per_retained_grade_type;
2300: l_per_probations ghr_api.per_probations_type;
2301: l_per_sep_retire ghr_api.per_sep_retire_type;

Line 2298: l_per_scd_info ghr_api.per_scd_info_type;

2294: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2295: l_per_sf52 ghr_api.per_sf52_type;
2296: l_per_group1 ghr_api.per_group1_type;
2297: l_per_group2 ghr_api.per_group2_type;
2298: l_per_scd_info ghr_api.per_scd_info_type;
2299: l_per_retained_grade ghr_api.per_retained_grade_type;
2300: l_per_probations ghr_api.per_probations_type;
2301: l_per_sep_retire ghr_api.per_sep_retire_type;
2302: l_per_security ghr_api.per_security_type;

Line 2299: l_per_retained_grade ghr_api.per_retained_grade_type;

2295: l_per_sf52 ghr_api.per_sf52_type;
2296: l_per_group1 ghr_api.per_group1_type;
2297: l_per_group2 ghr_api.per_group2_type;
2298: l_per_scd_info ghr_api.per_scd_info_type;
2299: l_per_retained_grade ghr_api.per_retained_grade_type;
2300: l_per_probations ghr_api.per_probations_type;
2301: l_per_sep_retire ghr_api.per_sep_retire_type;
2302: l_per_security ghr_api.per_security_type;
2303: l_per_conversions ghr_api.per_conversions_type;

Line 2300: l_per_probations ghr_api.per_probations_type;

2296: l_per_group1 ghr_api.per_group1_type;
2297: l_per_group2 ghr_api.per_group2_type;
2298: l_per_scd_info ghr_api.per_scd_info_type;
2299: l_per_retained_grade ghr_api.per_retained_grade_type;
2300: l_per_probations ghr_api.per_probations_type;
2301: l_per_sep_retire ghr_api.per_sep_retire_type;
2302: l_per_security ghr_api.per_security_type;
2303: l_per_conversions ghr_api.per_conversions_type;
2304: l_per_uniformed_services ghr_api.per_uniformed_services_type;

Line 2301: l_per_sep_retire ghr_api.per_sep_retire_type;

2297: l_per_group2 ghr_api.per_group2_type;
2298: l_per_scd_info ghr_api.per_scd_info_type;
2299: l_per_retained_grade ghr_api.per_retained_grade_type;
2300: l_per_probations ghr_api.per_probations_type;
2301: l_per_sep_retire ghr_api.per_sep_retire_type;
2302: l_per_security ghr_api.per_security_type;
2303: l_per_conversions ghr_api.per_conversions_type;
2304: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2305: l_pos_oblig ghr_api.pos_oblig_type;

Line 2302: l_per_security ghr_api.per_security_type;

2298: l_per_scd_info ghr_api.per_scd_info_type;
2299: l_per_retained_grade ghr_api.per_retained_grade_type;
2300: l_per_probations ghr_api.per_probations_type;
2301: l_per_sep_retire ghr_api.per_sep_retire_type;
2302: l_per_security ghr_api.per_security_type;
2303: l_per_conversions ghr_api.per_conversions_type;
2304: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2305: l_pos_oblig ghr_api.pos_oblig_type;
2306: l_pos_grp2 ghr_api.pos_grp2_type;

Line 2303: l_per_conversions ghr_api.per_conversions_type;

2299: l_per_retained_grade ghr_api.per_retained_grade_type;
2300: l_per_probations ghr_api.per_probations_type;
2301: l_per_sep_retire ghr_api.per_sep_retire_type;
2302: l_per_security ghr_api.per_security_type;
2303: l_per_conversions ghr_api.per_conversions_type;
2304: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2305: l_pos_oblig ghr_api.pos_oblig_type;
2306: l_pos_grp2 ghr_api.pos_grp2_type;
2307: l_pos_grp1 ghr_api.pos_grp1_type;

Line 2304: l_per_uniformed_services ghr_api.per_uniformed_services_type;

2300: l_per_probations ghr_api.per_probations_type;
2301: l_per_sep_retire ghr_api.per_sep_retire_type;
2302: l_per_security ghr_api.per_security_type;
2303: l_per_conversions ghr_api.per_conversions_type;
2304: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2305: l_pos_oblig ghr_api.pos_oblig_type;
2306: l_pos_grp2 ghr_api.pos_grp2_type;
2307: l_pos_grp1 ghr_api.pos_grp1_type;
2308: l_pos_valid_grade ghr_api.pos_valid_grade_type;

Line 2305: l_pos_oblig ghr_api.pos_oblig_type;

2301: l_per_sep_retire ghr_api.per_sep_retire_type;
2302: l_per_security ghr_api.per_security_type;
2303: l_per_conversions ghr_api.per_conversions_type;
2304: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2305: l_pos_oblig ghr_api.pos_oblig_type;
2306: l_pos_grp2 ghr_api.pos_grp2_type;
2307: l_pos_grp1 ghr_api.pos_grp1_type;
2308: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2309: l_pos_car_prog ghr_api.pos_car_prog_type;

Line 2306: l_pos_grp2 ghr_api.pos_grp2_type;

2302: l_per_security ghr_api.per_security_type;
2303: l_per_conversions ghr_api.per_conversions_type;
2304: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2305: l_pos_oblig ghr_api.pos_oblig_type;
2306: l_pos_grp2 ghr_api.pos_grp2_type;
2307: l_pos_grp1 ghr_api.pos_grp1_type;
2308: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2309: l_pos_car_prog ghr_api.pos_car_prog_type;
2310: l_loc_info ghr_api.loc_info_type;

Line 2307: l_pos_grp1 ghr_api.pos_grp1_type;

2303: l_per_conversions ghr_api.per_conversions_type;
2304: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2305: l_pos_oblig ghr_api.pos_oblig_type;
2306: l_pos_grp2 ghr_api.pos_grp2_type;
2307: l_pos_grp1 ghr_api.pos_grp1_type;
2308: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2309: l_pos_car_prog ghr_api.pos_car_prog_type;
2310: l_loc_info ghr_api.loc_info_type;
2311: l_wgi ghr_api.within_grade_increase_type;

Line 2308: l_pos_valid_grade ghr_api.pos_valid_grade_type;

2304: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2305: l_pos_oblig ghr_api.pos_oblig_type;
2306: l_pos_grp2 ghr_api.pos_grp2_type;
2307: l_pos_grp1 ghr_api.pos_grp1_type;
2308: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2309: l_pos_car_prog ghr_api.pos_car_prog_type;
2310: l_loc_info ghr_api.loc_info_type;
2311: l_wgi ghr_api.within_grade_increase_type;
2312: l_recruitment_bonus ghr_api.recruitment_bonus_type;

Line 2309: l_pos_car_prog ghr_api.pos_car_prog_type;

2305: l_pos_oblig ghr_api.pos_oblig_type;
2306: l_pos_grp2 ghr_api.pos_grp2_type;
2307: l_pos_grp1 ghr_api.pos_grp1_type;
2308: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2309: l_pos_car_prog ghr_api.pos_car_prog_type;
2310: l_loc_info ghr_api.loc_info_type;
2311: l_wgi ghr_api.within_grade_increase_type;
2312: l_recruitment_bonus ghr_api.recruitment_bonus_type;
2313: l_relocation_bonus ghr_api.relocation_bonus_type;

Line 2310: l_loc_info ghr_api.loc_info_type;

2306: l_pos_grp2 ghr_api.pos_grp2_type;
2307: l_pos_grp1 ghr_api.pos_grp1_type;
2308: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2309: l_pos_car_prog ghr_api.pos_car_prog_type;
2310: l_loc_info ghr_api.loc_info_type;
2311: l_wgi ghr_api.within_grade_increase_type;
2312: l_recruitment_bonus ghr_api.recruitment_bonus_type;
2313: l_relocation_bonus ghr_api.relocation_bonus_type;
2314:

Line 2311: l_wgi ghr_api.within_grade_increase_type;

2307: l_pos_grp1 ghr_api.pos_grp1_type;
2308: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2309: l_pos_car_prog ghr_api.pos_car_prog_type;
2310: l_loc_info ghr_api.loc_info_type;
2311: l_wgi ghr_api.within_grade_increase_type;
2312: l_recruitment_bonus ghr_api.recruitment_bonus_type;
2313: l_relocation_bonus ghr_api.relocation_bonus_type;
2314:
2315: --Pradeep

Line 2312: l_recruitment_bonus ghr_api.recruitment_bonus_type;

2308: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2309: l_pos_car_prog ghr_api.pos_car_prog_type;
2310: l_loc_info ghr_api.loc_info_type;
2311: l_wgi ghr_api.within_grade_increase_type;
2312: l_recruitment_bonus ghr_api.recruitment_bonus_type;
2313: l_relocation_bonus ghr_api.relocation_bonus_type;
2314:
2315: --Pradeep
2316: l_mddds_special_pay ghr_api.mddds_special_pay_type;

Line 2313: l_relocation_bonus ghr_api.relocation_bonus_type;

2309: l_pos_car_prog ghr_api.pos_car_prog_type;
2310: l_loc_info ghr_api.loc_info_type;
2311: l_wgi ghr_api.within_grade_increase_type;
2312: l_recruitment_bonus ghr_api.recruitment_bonus_type;
2313: l_relocation_bonus ghr_api.relocation_bonus_type;
2314:
2315: --Pradeep
2316: l_mddds_special_pay ghr_api.mddds_special_pay_type;
2317: l_sf52_from_data ghr_api.prior_sf52_data_type;

Line 2316: l_mddds_special_pay ghr_api.mddds_special_pay_type;

2312: l_recruitment_bonus ghr_api.recruitment_bonus_type;
2313: l_relocation_bonus ghr_api.relocation_bonus_type;
2314:
2315: --Pradeep
2316: l_mddds_special_pay ghr_api.mddds_special_pay_type;
2317: l_sf52_from_data ghr_api.prior_sf52_data_type;
2318: l_personal_info ghr_api.personal_info_type;
2319: l_gov_awards_type ghr_api.government_awards_type;
2320: l_perf_appraisal_type ghr_api.performance_appraisal_type;

Line 2317: l_sf52_from_data ghr_api.prior_sf52_data_type;

2313: l_relocation_bonus ghr_api.relocation_bonus_type;
2314:
2315: --Pradeep
2316: l_mddds_special_pay ghr_api.mddds_special_pay_type;
2317: l_sf52_from_data ghr_api.prior_sf52_data_type;
2318: l_personal_info ghr_api.personal_info_type;
2319: l_gov_awards_type ghr_api.government_awards_type;
2320: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2321: l_payroll_type ghr_api.government_payroll_type;

Line 2318: l_personal_info ghr_api.personal_info_type;

2314:
2315: --Pradeep
2316: l_mddds_special_pay ghr_api.mddds_special_pay_type;
2317: l_sf52_from_data ghr_api.prior_sf52_data_type;
2318: l_personal_info ghr_api.personal_info_type;
2319: l_gov_awards_type ghr_api.government_awards_type;
2320: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2321: l_payroll_type ghr_api.government_payroll_type;
2322: l_conduct_perf_type ghr_api.conduct_performance_type;

Line 2319: l_gov_awards_type ghr_api.government_awards_type;

2315: --Pradeep
2316: l_mddds_special_pay ghr_api.mddds_special_pay_type;
2317: l_sf52_from_data ghr_api.prior_sf52_data_type;
2318: l_personal_info ghr_api.personal_info_type;
2319: l_gov_awards_type ghr_api.government_awards_type;
2320: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2321: l_payroll_type ghr_api.government_payroll_type;
2322: l_conduct_perf_type ghr_api.conduct_performance_type;
2323: l_agency_sf52 ghr_api.agency_sf52_type;

Line 2320: l_perf_appraisal_type ghr_api.performance_appraisal_type;

2316: l_mddds_special_pay ghr_api.mddds_special_pay_type;
2317: l_sf52_from_data ghr_api.prior_sf52_data_type;
2318: l_personal_info ghr_api.personal_info_type;
2319: l_gov_awards_type ghr_api.government_awards_type;
2320: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2321: l_payroll_type ghr_api.government_payroll_type;
2322: l_conduct_perf_type ghr_api.conduct_performance_type;
2323: l_agency_sf52 ghr_api.agency_sf52_type;
2324: l_agency_code varchar2(80);

Line 2321: l_payroll_type ghr_api.government_payroll_type;

2317: l_sf52_from_data ghr_api.prior_sf52_data_type;
2318: l_personal_info ghr_api.personal_info_type;
2319: l_gov_awards_type ghr_api.government_awards_type;
2320: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2321: l_payroll_type ghr_api.government_payroll_type;
2322: l_conduct_perf_type ghr_api.conduct_performance_type;
2323: l_agency_sf52 ghr_api.agency_sf52_type;
2324: l_agency_code varchar2(80);
2325: l_imm_entitlement ghr_api.entitlement_type;

Line 2322: l_conduct_perf_type ghr_api.conduct_performance_type;

2318: l_personal_info ghr_api.personal_info_type;
2319: l_gov_awards_type ghr_api.government_awards_type;
2320: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2321: l_payroll_type ghr_api.government_payroll_type;
2322: l_conduct_perf_type ghr_api.conduct_performance_type;
2323: l_agency_sf52 ghr_api.agency_sf52_type;
2324: l_agency_code varchar2(80);
2325: l_imm_entitlement ghr_api.entitlement_type;
2326: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

Line 2323: l_agency_sf52 ghr_api.agency_sf52_type;

2319: l_gov_awards_type ghr_api.government_awards_type;
2320: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2321: l_payroll_type ghr_api.government_payroll_type;
2322: l_conduct_perf_type ghr_api.conduct_performance_type;
2323: l_agency_sf52 ghr_api.agency_sf52_type;
2324: l_agency_code varchar2(80);
2325: l_imm_entitlement ghr_api.entitlement_type;
2326: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2327: l_imm_edp_pay ghr_api.edp_pay_type;

Line 2325: l_imm_entitlement ghr_api.entitlement_type;

2321: l_payroll_type ghr_api.government_payroll_type;
2322: l_conduct_perf_type ghr_api.conduct_performance_type;
2323: l_agency_sf52 ghr_api.agency_sf52_type;
2324: l_agency_code varchar2(80);
2325: l_imm_entitlement ghr_api.entitlement_type;
2326: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2327: l_imm_edp_pay ghr_api.edp_pay_type;
2328: l_imm_hazard_pay ghr_api.hazard_pay_type;
2329: l_imm_health_benefits ghr_api.health_benefits_type;

Line 2326: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

2322: l_conduct_perf_type ghr_api.conduct_performance_type;
2323: l_agency_sf52 ghr_api.agency_sf52_type;
2324: l_agency_code varchar2(80);
2325: l_imm_entitlement ghr_api.entitlement_type;
2326: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2327: l_imm_edp_pay ghr_api.edp_pay_type;
2328: l_imm_hazard_pay ghr_api.hazard_pay_type;
2329: l_imm_health_benefits ghr_api.health_benefits_type;
2330: l_imm_danger_pay ghr_api.danger_pay_type;

Line 2327: l_imm_edp_pay ghr_api.edp_pay_type;

2323: l_agency_sf52 ghr_api.agency_sf52_type;
2324: l_agency_code varchar2(80);
2325: l_imm_entitlement ghr_api.entitlement_type;
2326: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2327: l_imm_edp_pay ghr_api.edp_pay_type;
2328: l_imm_hazard_pay ghr_api.hazard_pay_type;
2329: l_imm_health_benefits ghr_api.health_benefits_type;
2330: l_imm_danger_pay ghr_api.danger_pay_type;
2331: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;

Line 2328: l_imm_hazard_pay ghr_api.hazard_pay_type;

2324: l_agency_code varchar2(80);
2325: l_imm_entitlement ghr_api.entitlement_type;
2326: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2327: l_imm_edp_pay ghr_api.edp_pay_type;
2328: l_imm_hazard_pay ghr_api.hazard_pay_type;
2329: l_imm_health_benefits ghr_api.health_benefits_type;
2330: l_imm_danger_pay ghr_api.danger_pay_type;
2331: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2332: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;

Line 2329: l_imm_health_benefits ghr_api.health_benefits_type;

2325: l_imm_entitlement ghr_api.entitlement_type;
2326: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2327: l_imm_edp_pay ghr_api.edp_pay_type;
2328: l_imm_hazard_pay ghr_api.hazard_pay_type;
2329: l_imm_health_benefits ghr_api.health_benefits_type;
2330: l_imm_danger_pay ghr_api.danger_pay_type;
2331: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2332: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2333: l_imm_post_diff_amt ghr_api.post_diff_amt_type;

Line 2330: l_imm_danger_pay ghr_api.danger_pay_type;

2326: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2327: l_imm_edp_pay ghr_api.edp_pay_type;
2328: l_imm_hazard_pay ghr_api.hazard_pay_type;
2329: l_imm_health_benefits ghr_api.health_benefits_type;
2330: l_imm_danger_pay ghr_api.danger_pay_type;
2331: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2332: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2333: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2334: l_imm_post_diff_percent ghr_api.post_diff_percent_type;

Line 2331: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;

2327: l_imm_edp_pay ghr_api.edp_pay_type;
2328: l_imm_hazard_pay ghr_api.hazard_pay_type;
2329: l_imm_health_benefits ghr_api.health_benefits_type;
2330: l_imm_danger_pay ghr_api.danger_pay_type;
2331: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2332: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2333: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2334: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2335: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

Line 2332: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;

2328: l_imm_hazard_pay ghr_api.hazard_pay_type;
2329: l_imm_health_benefits ghr_api.health_benefits_type;
2330: l_imm_danger_pay ghr_api.danger_pay_type;
2331: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2332: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2333: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2334: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2335: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2336: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;

Line 2333: l_imm_post_diff_amt ghr_api.post_diff_amt_type;

2329: l_imm_health_benefits ghr_api.health_benefits_type;
2330: l_imm_danger_pay ghr_api.danger_pay_type;
2331: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2332: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2333: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2334: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2335: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2336: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2337: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;

Line 2334: l_imm_post_diff_percent ghr_api.post_diff_percent_type;

2330: l_imm_danger_pay ghr_api.danger_pay_type;
2331: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2332: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2333: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2334: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2335: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2336: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2337: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2338: l_imm_premium_pay ghr_api.premium_pay_type;

Line 2335: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

2331: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2332: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2333: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2334: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2335: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2336: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2337: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2338: l_imm_premium_pay ghr_api.premium_pay_type;
2339: l_imm_retirement_annuity ghr_api.retirement_annuity_type;

Line 2336: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;

2332: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2333: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2334: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2335: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2336: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2337: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2338: l_imm_premium_pay ghr_api.premium_pay_type;
2339: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2340: l_imm_severance_pay ghr_api.severance_pay_type;

Line 2337: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;

2333: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2334: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2335: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2336: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2337: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2338: l_imm_premium_pay ghr_api.premium_pay_type;
2339: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2340: l_imm_severance_pay ghr_api.severance_pay_type;
2341: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;

Line 2338: l_imm_premium_pay ghr_api.premium_pay_type;

2334: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2335: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2336: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2337: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2338: l_imm_premium_pay ghr_api.premium_pay_type;
2339: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2340: l_imm_severance_pay ghr_api.severance_pay_type;
2341: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2342: l_imm_retention_allow_review ghr_api.retention_allow_review_type;

Line 2339: l_imm_retirement_annuity ghr_api.retirement_annuity_type;

2335: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2336: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2337: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2338: l_imm_premium_pay ghr_api.premium_pay_type;
2339: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2340: l_imm_severance_pay ghr_api.severance_pay_type;
2341: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2342: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2343: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

Line 2340: l_imm_severance_pay ghr_api.severance_pay_type;

2336: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2337: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2338: l_imm_premium_pay ghr_api.premium_pay_type;
2339: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2340: l_imm_severance_pay ghr_api.severance_pay_type;
2341: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2342: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2343: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2344: l_rpa_type ghr_pa_requests.rpa_type%type;

Line 2341: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;

2337: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2338: l_imm_premium_pay ghr_api.premium_pay_type;
2339: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2340: l_imm_severance_pay ghr_api.severance_pay_type;
2341: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2342: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2343: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2344: l_rpa_type ghr_pa_requests.rpa_type%type;
2345: l_mass_action_id ghr_pa_requests.mass_action_id%type;

Line 2342: l_imm_retention_allow_review ghr_api.retention_allow_review_type;

2338: l_imm_premium_pay ghr_api.premium_pay_type;
2339: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2340: l_imm_severance_pay ghr_api.severance_pay_type;
2341: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2342: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2343: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2344: l_rpa_type ghr_pa_requests.rpa_type%type;
2345: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2346: l_imm_per_benefit_info ghr_api.per_benefit_info_type;

Line 2343: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

2339: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2340: l_imm_severance_pay ghr_api.severance_pay_type;
2341: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2342: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2343: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2344: l_rpa_type ghr_pa_requests.rpa_type%type;
2345: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2346: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
2347: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104

Line 2346: l_imm_per_benefit_info ghr_api.per_benefit_info_type;

2342: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2343: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2344: l_rpa_type ghr_pa_requests.rpa_type%type;
2345: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2346: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
2347: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
2348: --Begin Bug# 10181661
2349: l_imm_asg_detail_info ghr_api.asg_detail_info_type;
2350: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;

Line 2347: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104

2343: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2344: l_rpa_type ghr_pa_requests.rpa_type%type;
2345: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2346: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
2347: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
2348: --Begin Bug# 10181661
2349: l_imm_asg_detail_info ghr_api.asg_detail_info_type;
2350: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
2351: --End Bug# 10181661

Line 2349: l_imm_asg_detail_info ghr_api.asg_detail_info_type;

2345: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2346: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
2347: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
2348: --Begin Bug# 10181661
2349: l_imm_asg_detail_info ghr_api.asg_detail_info_type;
2350: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
2351: --End Bug# 10181661
2352:
2353:

Line 2350: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;

2346: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
2347: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
2348: --Begin Bug# 10181661
2349: l_imm_asg_detail_info ghr_api.asg_detail_info_type;
2350: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
2351: --End Bug# 10181661
2352:
2353:
2354: CURSOR c_cnt_history IS

Line 4030: ghr_api.call_workflow

4026: p_par_object_version_number => l_rec.object_version_number);
4027: end if;
4028: end if;
4029: if (l_action_taken not in ('UPDATE_HR','END_ROUTING')) then
4030: ghr_api.call_workflow
4031: (p_pa_request_id => p_pa_request_id,
4032: p_action_taken => l_action_taken
4033: );
4034: end if;

Line 4691: ghr_api.call_workflow

4687: End if;
4688:
4689:
4690: -- call work flow
4691: ghr_api.call_workflow
4692: (p_pa_request_id => p_pa_Request_id,
4693: p_action_taken => p_action_taken,
4694: p_old_action_taken => l_old_action_taken
4695: );