eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_SF52_API dependencies on GHR_API

Line 286: l_asg_sf52 ghr_api.asg_sf52_type;

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

Line 287: l_asg_non_sf52 ghr_api.asg_non_sf52_type;

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

Line 288: l_asg_nte_dates ghr_api.asg_nte_dates_type;

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

Line 289: l_per_sf52 ghr_api.per_sf52_type;

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

Line 290: l_per_group1 ghr_api.per_group1_type;

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

Line 291: l_per_group2 ghr_api.per_group2_type;

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

Line 292: l_per_scd_info ghr_api.per_scd_info_type;

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

Line 293: l_per_retained_grade ghr_api.per_retained_grade_type;

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

Line 294: l_per_probations ghr_api.per_probations_type;

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

Line 295: l_per_sep_retire ghr_api.per_sep_retire_type;

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

Line 296: l_per_security ghr_api.per_security_type;

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

Line 297: l_per_conversions ghr_api.per_conversions_type;

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

Line 298: l_per_uniformed_services ghr_api.per_uniformed_services_type;

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

Line 299: l_pos_oblig ghr_api.pos_oblig_type;

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

Line 300: l_pos_grp2 ghr_api.pos_grp2_type;

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

Line 301: l_pos_grp1 ghr_api.pos_grp1_type;

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

Line 302: l_pos_valid_grade ghr_api.pos_valid_grade_type;

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

Line 303: l_pos_car_prog ghr_api.pos_car_prog_type;

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

Line 304: l_loc_info ghr_api.loc_info_type;

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

Line 305: l_wgi ghr_api.within_grade_increase_type;

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

Line 306: l_recruitment_bonus ghr_api.recruitment_bonus_type;

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

Line 307: l_relocation_bonus ghr_api.relocation_bonus_type;

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

Line 310: l_mddds_special_pay ghr_api.mddds_special_pay_type;

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

Line 311: l_sf52_from_data ghr_api.prior_sf52_data_type;

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

Line 312: l_personal_info ghr_api.personal_info_type;

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

Line 313: l_gov_awards_type ghr_api.government_awards_type;

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

Line 314: l_perf_appraisal_type ghr_api.performance_appraisal_type;

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

Line 315: l_payroll_type ghr_api.government_payroll_type;

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

Line 316: l_conduct_perf_type ghr_api.conduct_performance_type;

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

Line 317: l_agency_sf52 ghr_api.agency_sf52_type;

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

Line 319: l_imm_entitlement ghr_api.entitlement_type;

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

Line 320: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

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

Line 321: l_imm_edp_pay ghr_api.edp_pay_type;

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

Line 322: l_imm_hazard_pay ghr_api.hazard_pay_type;

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

Line 323: l_imm_health_benefits ghr_api.health_benefits_type;

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

Line 324: l_imm_danger_pay ghr_api.danger_pay_type;

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

Line 325: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;

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

Line 326: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;

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

Line 327: l_imm_post_diff_amt ghr_api.post_diff_amt_type;

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

Line 328: l_imm_post_diff_percent ghr_api.post_diff_percent_type;

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

Line 329: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

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

Line 330: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;

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

Line 331: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;

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

Line 332: l_imm_premium_pay ghr_api.premium_pay_type;

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

Line 333: l_imm_retirement_annuity ghr_api.retirement_annuity_type;

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

Line 334: l_imm_severance_pay ghr_api.severance_pay_type;

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

Line 335: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;

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

Line 336: l_imm_retention_allow_review ghr_api.retention_allow_review_type;

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

Line 337: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

333: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
334: l_imm_severance_pay ghr_api.severance_pay_type;
335: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
336: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
337: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
338: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
339: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
340:
341: /* Cursor C_user_emp_names is

Line 338: l_imm_per_benefit_info ghr_api.per_benefit_info_type;

334: l_imm_severance_pay ghr_api.severance_pay_type;
335: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
336: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
337: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
338: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
339: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
340:
341: /* Cursor C_user_emp_names is
342: select usr.employee_id,

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

335: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
336: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
337: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
338: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
339: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
340:
341: /* Cursor C_user_emp_names is
342: select usr.employee_id,
343: per.first_name,

Line 1611: ghr_api.call_workflow

1607: end if;
1608: End if;
1609: if (l_action_taken not in ('UPDATE_HR','END_ROUTING')) then
1610: -- call workflow
1611: ghr_api.call_workflow
1612: (p_pa_request_id => l_pa_request_id
1613: ,p_action_taken => l_action_taken
1614: );
1615: end if;

Line 2218: l_asg_sf52 ghr_api.asg_sf52_type;

2214: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
2215: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
2216: l_status ghr_pa_requests.status%type;
2217: l_message boolean := FALSE;
2218: l_asg_sf52 ghr_api.asg_sf52_type;
2219: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2220: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2221: l_per_sf52 ghr_api.per_sf52_type;
2222: l_per_group1 ghr_api.per_group1_type;

Line 2219: l_asg_non_sf52 ghr_api.asg_non_sf52_type;

2215: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
2216: l_status ghr_pa_requests.status%type;
2217: l_message boolean := FALSE;
2218: l_asg_sf52 ghr_api.asg_sf52_type;
2219: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2220: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2221: l_per_sf52 ghr_api.per_sf52_type;
2222: l_per_group1 ghr_api.per_group1_type;
2223: l_per_group2 ghr_api.per_group2_type;

Line 2220: l_asg_nte_dates ghr_api.asg_nte_dates_type;

2216: l_status ghr_pa_requests.status%type;
2217: l_message boolean := FALSE;
2218: l_asg_sf52 ghr_api.asg_sf52_type;
2219: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2220: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2221: l_per_sf52 ghr_api.per_sf52_type;
2222: l_per_group1 ghr_api.per_group1_type;
2223: l_per_group2 ghr_api.per_group2_type;
2224: l_per_scd_info ghr_api.per_scd_info_type;

Line 2221: l_per_sf52 ghr_api.per_sf52_type;

2217: l_message boolean := FALSE;
2218: l_asg_sf52 ghr_api.asg_sf52_type;
2219: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2220: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2221: l_per_sf52 ghr_api.per_sf52_type;
2222: l_per_group1 ghr_api.per_group1_type;
2223: l_per_group2 ghr_api.per_group2_type;
2224: l_per_scd_info ghr_api.per_scd_info_type;
2225: l_per_retained_grade ghr_api.per_retained_grade_type;

Line 2222: l_per_group1 ghr_api.per_group1_type;

2218: l_asg_sf52 ghr_api.asg_sf52_type;
2219: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2220: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2221: l_per_sf52 ghr_api.per_sf52_type;
2222: l_per_group1 ghr_api.per_group1_type;
2223: l_per_group2 ghr_api.per_group2_type;
2224: l_per_scd_info ghr_api.per_scd_info_type;
2225: l_per_retained_grade ghr_api.per_retained_grade_type;
2226: l_per_probations ghr_api.per_probations_type;

Line 2223: l_per_group2 ghr_api.per_group2_type;

2219: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2220: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2221: l_per_sf52 ghr_api.per_sf52_type;
2222: l_per_group1 ghr_api.per_group1_type;
2223: l_per_group2 ghr_api.per_group2_type;
2224: l_per_scd_info ghr_api.per_scd_info_type;
2225: l_per_retained_grade ghr_api.per_retained_grade_type;
2226: l_per_probations ghr_api.per_probations_type;
2227: l_per_sep_retire ghr_api.per_sep_retire_type;

Line 2224: l_per_scd_info ghr_api.per_scd_info_type;

2220: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2221: l_per_sf52 ghr_api.per_sf52_type;
2222: l_per_group1 ghr_api.per_group1_type;
2223: l_per_group2 ghr_api.per_group2_type;
2224: l_per_scd_info ghr_api.per_scd_info_type;
2225: l_per_retained_grade ghr_api.per_retained_grade_type;
2226: l_per_probations ghr_api.per_probations_type;
2227: l_per_sep_retire ghr_api.per_sep_retire_type;
2228: l_per_security ghr_api.per_security_type;

Line 2225: l_per_retained_grade ghr_api.per_retained_grade_type;

2221: l_per_sf52 ghr_api.per_sf52_type;
2222: l_per_group1 ghr_api.per_group1_type;
2223: l_per_group2 ghr_api.per_group2_type;
2224: l_per_scd_info ghr_api.per_scd_info_type;
2225: l_per_retained_grade ghr_api.per_retained_grade_type;
2226: l_per_probations ghr_api.per_probations_type;
2227: l_per_sep_retire ghr_api.per_sep_retire_type;
2228: l_per_security ghr_api.per_security_type;
2229: l_per_conversions ghr_api.per_conversions_type;

Line 2226: l_per_probations ghr_api.per_probations_type;

2222: l_per_group1 ghr_api.per_group1_type;
2223: l_per_group2 ghr_api.per_group2_type;
2224: l_per_scd_info ghr_api.per_scd_info_type;
2225: l_per_retained_grade ghr_api.per_retained_grade_type;
2226: l_per_probations ghr_api.per_probations_type;
2227: l_per_sep_retire ghr_api.per_sep_retire_type;
2228: l_per_security ghr_api.per_security_type;
2229: l_per_conversions ghr_api.per_conversions_type;
2230: l_per_uniformed_services ghr_api.per_uniformed_services_type;

Line 2227: l_per_sep_retire ghr_api.per_sep_retire_type;

2223: l_per_group2 ghr_api.per_group2_type;
2224: l_per_scd_info ghr_api.per_scd_info_type;
2225: l_per_retained_grade ghr_api.per_retained_grade_type;
2226: l_per_probations ghr_api.per_probations_type;
2227: l_per_sep_retire ghr_api.per_sep_retire_type;
2228: l_per_security ghr_api.per_security_type;
2229: l_per_conversions ghr_api.per_conversions_type;
2230: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2231: l_pos_oblig ghr_api.pos_oblig_type;

Line 2228: l_per_security ghr_api.per_security_type;

2224: l_per_scd_info ghr_api.per_scd_info_type;
2225: l_per_retained_grade ghr_api.per_retained_grade_type;
2226: l_per_probations ghr_api.per_probations_type;
2227: l_per_sep_retire ghr_api.per_sep_retire_type;
2228: l_per_security ghr_api.per_security_type;
2229: l_per_conversions ghr_api.per_conversions_type;
2230: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2231: l_pos_oblig ghr_api.pos_oblig_type;
2232: l_pos_grp2 ghr_api.pos_grp2_type;

Line 2229: l_per_conversions ghr_api.per_conversions_type;

2225: l_per_retained_grade ghr_api.per_retained_grade_type;
2226: l_per_probations ghr_api.per_probations_type;
2227: l_per_sep_retire ghr_api.per_sep_retire_type;
2228: l_per_security ghr_api.per_security_type;
2229: l_per_conversions ghr_api.per_conversions_type;
2230: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2231: l_pos_oblig ghr_api.pos_oblig_type;
2232: l_pos_grp2 ghr_api.pos_grp2_type;
2233: l_pos_grp1 ghr_api.pos_grp1_type;

Line 2230: l_per_uniformed_services ghr_api.per_uniformed_services_type;

2226: l_per_probations ghr_api.per_probations_type;
2227: l_per_sep_retire ghr_api.per_sep_retire_type;
2228: l_per_security ghr_api.per_security_type;
2229: l_per_conversions ghr_api.per_conversions_type;
2230: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2231: l_pos_oblig ghr_api.pos_oblig_type;
2232: l_pos_grp2 ghr_api.pos_grp2_type;
2233: l_pos_grp1 ghr_api.pos_grp1_type;
2234: l_pos_valid_grade ghr_api.pos_valid_grade_type;

Line 2231: l_pos_oblig ghr_api.pos_oblig_type;

2227: l_per_sep_retire ghr_api.per_sep_retire_type;
2228: l_per_security ghr_api.per_security_type;
2229: l_per_conversions ghr_api.per_conversions_type;
2230: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2231: l_pos_oblig ghr_api.pos_oblig_type;
2232: l_pos_grp2 ghr_api.pos_grp2_type;
2233: l_pos_grp1 ghr_api.pos_grp1_type;
2234: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2235: l_pos_car_prog ghr_api.pos_car_prog_type;

Line 2232: l_pos_grp2 ghr_api.pos_grp2_type;

2228: l_per_security ghr_api.per_security_type;
2229: l_per_conversions ghr_api.per_conversions_type;
2230: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2231: l_pos_oblig ghr_api.pos_oblig_type;
2232: l_pos_grp2 ghr_api.pos_grp2_type;
2233: l_pos_grp1 ghr_api.pos_grp1_type;
2234: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2235: l_pos_car_prog ghr_api.pos_car_prog_type;
2236: l_loc_info ghr_api.loc_info_type;

Line 2233: l_pos_grp1 ghr_api.pos_grp1_type;

2229: l_per_conversions ghr_api.per_conversions_type;
2230: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2231: l_pos_oblig ghr_api.pos_oblig_type;
2232: l_pos_grp2 ghr_api.pos_grp2_type;
2233: l_pos_grp1 ghr_api.pos_grp1_type;
2234: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2235: l_pos_car_prog ghr_api.pos_car_prog_type;
2236: l_loc_info ghr_api.loc_info_type;
2237: l_wgi ghr_api.within_grade_increase_type;

Line 2234: l_pos_valid_grade ghr_api.pos_valid_grade_type;

2230: l_per_uniformed_services ghr_api.per_uniformed_services_type;
2231: l_pos_oblig ghr_api.pos_oblig_type;
2232: l_pos_grp2 ghr_api.pos_grp2_type;
2233: l_pos_grp1 ghr_api.pos_grp1_type;
2234: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2235: l_pos_car_prog ghr_api.pos_car_prog_type;
2236: l_loc_info ghr_api.loc_info_type;
2237: l_wgi ghr_api.within_grade_increase_type;
2238: l_recruitment_bonus ghr_api.recruitment_bonus_type;

Line 2235: l_pos_car_prog ghr_api.pos_car_prog_type;

2231: l_pos_oblig ghr_api.pos_oblig_type;
2232: l_pos_grp2 ghr_api.pos_grp2_type;
2233: l_pos_grp1 ghr_api.pos_grp1_type;
2234: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2235: l_pos_car_prog ghr_api.pos_car_prog_type;
2236: l_loc_info ghr_api.loc_info_type;
2237: l_wgi ghr_api.within_grade_increase_type;
2238: l_recruitment_bonus ghr_api.recruitment_bonus_type;
2239: l_relocation_bonus ghr_api.relocation_bonus_type;

Line 2236: l_loc_info ghr_api.loc_info_type;

2232: l_pos_grp2 ghr_api.pos_grp2_type;
2233: l_pos_grp1 ghr_api.pos_grp1_type;
2234: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2235: l_pos_car_prog ghr_api.pos_car_prog_type;
2236: l_loc_info ghr_api.loc_info_type;
2237: l_wgi ghr_api.within_grade_increase_type;
2238: l_recruitment_bonus ghr_api.recruitment_bonus_type;
2239: l_relocation_bonus ghr_api.relocation_bonus_type;
2240:

Line 2237: l_wgi ghr_api.within_grade_increase_type;

2233: l_pos_grp1 ghr_api.pos_grp1_type;
2234: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2235: l_pos_car_prog ghr_api.pos_car_prog_type;
2236: l_loc_info ghr_api.loc_info_type;
2237: l_wgi ghr_api.within_grade_increase_type;
2238: l_recruitment_bonus ghr_api.recruitment_bonus_type;
2239: l_relocation_bonus ghr_api.relocation_bonus_type;
2240:
2241: --Pradeep

Line 2238: l_recruitment_bonus ghr_api.recruitment_bonus_type;

2234: l_pos_valid_grade ghr_api.pos_valid_grade_type;
2235: l_pos_car_prog ghr_api.pos_car_prog_type;
2236: l_loc_info ghr_api.loc_info_type;
2237: l_wgi ghr_api.within_grade_increase_type;
2238: l_recruitment_bonus ghr_api.recruitment_bonus_type;
2239: l_relocation_bonus ghr_api.relocation_bonus_type;
2240:
2241: --Pradeep
2242: l_mddds_special_pay ghr_api.mddds_special_pay_type;

Line 2239: l_relocation_bonus ghr_api.relocation_bonus_type;

2235: l_pos_car_prog ghr_api.pos_car_prog_type;
2236: l_loc_info ghr_api.loc_info_type;
2237: l_wgi ghr_api.within_grade_increase_type;
2238: l_recruitment_bonus ghr_api.recruitment_bonus_type;
2239: l_relocation_bonus ghr_api.relocation_bonus_type;
2240:
2241: --Pradeep
2242: l_mddds_special_pay ghr_api.mddds_special_pay_type;
2243: l_sf52_from_data ghr_api.prior_sf52_data_type;

Line 2242: l_mddds_special_pay ghr_api.mddds_special_pay_type;

2238: l_recruitment_bonus ghr_api.recruitment_bonus_type;
2239: l_relocation_bonus ghr_api.relocation_bonus_type;
2240:
2241: --Pradeep
2242: l_mddds_special_pay ghr_api.mddds_special_pay_type;
2243: l_sf52_from_data ghr_api.prior_sf52_data_type;
2244: l_personal_info ghr_api.personal_info_type;
2245: l_gov_awards_type ghr_api.government_awards_type;
2246: l_perf_appraisal_type ghr_api.performance_appraisal_type;

Line 2243: l_sf52_from_data ghr_api.prior_sf52_data_type;

2239: l_relocation_bonus ghr_api.relocation_bonus_type;
2240:
2241: --Pradeep
2242: l_mddds_special_pay ghr_api.mddds_special_pay_type;
2243: l_sf52_from_data ghr_api.prior_sf52_data_type;
2244: l_personal_info ghr_api.personal_info_type;
2245: l_gov_awards_type ghr_api.government_awards_type;
2246: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2247: l_payroll_type ghr_api.government_payroll_type;

Line 2244: l_personal_info ghr_api.personal_info_type;

2240:
2241: --Pradeep
2242: l_mddds_special_pay ghr_api.mddds_special_pay_type;
2243: l_sf52_from_data ghr_api.prior_sf52_data_type;
2244: l_personal_info ghr_api.personal_info_type;
2245: l_gov_awards_type ghr_api.government_awards_type;
2246: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2247: l_payroll_type ghr_api.government_payroll_type;
2248: l_conduct_perf_type ghr_api.conduct_performance_type;

Line 2245: l_gov_awards_type ghr_api.government_awards_type;

2241: --Pradeep
2242: l_mddds_special_pay ghr_api.mddds_special_pay_type;
2243: l_sf52_from_data ghr_api.prior_sf52_data_type;
2244: l_personal_info ghr_api.personal_info_type;
2245: l_gov_awards_type ghr_api.government_awards_type;
2246: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2247: l_payroll_type ghr_api.government_payroll_type;
2248: l_conduct_perf_type ghr_api.conduct_performance_type;
2249: l_agency_sf52 ghr_api.agency_sf52_type;

Line 2246: l_perf_appraisal_type ghr_api.performance_appraisal_type;

2242: l_mddds_special_pay ghr_api.mddds_special_pay_type;
2243: l_sf52_from_data ghr_api.prior_sf52_data_type;
2244: l_personal_info ghr_api.personal_info_type;
2245: l_gov_awards_type ghr_api.government_awards_type;
2246: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2247: l_payroll_type ghr_api.government_payroll_type;
2248: l_conduct_perf_type ghr_api.conduct_performance_type;
2249: l_agency_sf52 ghr_api.agency_sf52_type;
2250: l_agency_code varchar2(80);

Line 2247: l_payroll_type ghr_api.government_payroll_type;

2243: l_sf52_from_data ghr_api.prior_sf52_data_type;
2244: l_personal_info ghr_api.personal_info_type;
2245: l_gov_awards_type ghr_api.government_awards_type;
2246: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2247: l_payroll_type ghr_api.government_payroll_type;
2248: l_conduct_perf_type ghr_api.conduct_performance_type;
2249: l_agency_sf52 ghr_api.agency_sf52_type;
2250: l_agency_code varchar2(80);
2251: l_imm_entitlement ghr_api.entitlement_type;

Line 2248: l_conduct_perf_type ghr_api.conduct_performance_type;

2244: l_personal_info ghr_api.personal_info_type;
2245: l_gov_awards_type ghr_api.government_awards_type;
2246: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2247: l_payroll_type ghr_api.government_payroll_type;
2248: l_conduct_perf_type ghr_api.conduct_performance_type;
2249: l_agency_sf52 ghr_api.agency_sf52_type;
2250: l_agency_code varchar2(80);
2251: l_imm_entitlement ghr_api.entitlement_type;
2252: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

Line 2249: l_agency_sf52 ghr_api.agency_sf52_type;

2245: l_gov_awards_type ghr_api.government_awards_type;
2246: l_perf_appraisal_type ghr_api.performance_appraisal_type;
2247: l_payroll_type ghr_api.government_payroll_type;
2248: l_conduct_perf_type ghr_api.conduct_performance_type;
2249: l_agency_sf52 ghr_api.agency_sf52_type;
2250: l_agency_code varchar2(80);
2251: l_imm_entitlement ghr_api.entitlement_type;
2252: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2253: l_imm_edp_pay ghr_api.edp_pay_type;

Line 2251: l_imm_entitlement ghr_api.entitlement_type;

2247: l_payroll_type ghr_api.government_payroll_type;
2248: l_conduct_perf_type ghr_api.conduct_performance_type;
2249: l_agency_sf52 ghr_api.agency_sf52_type;
2250: l_agency_code varchar2(80);
2251: l_imm_entitlement ghr_api.entitlement_type;
2252: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2253: l_imm_edp_pay ghr_api.edp_pay_type;
2254: l_imm_hazard_pay ghr_api.hazard_pay_type;
2255: l_imm_health_benefits ghr_api.health_benefits_type;

Line 2252: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

2248: l_conduct_perf_type ghr_api.conduct_performance_type;
2249: l_agency_sf52 ghr_api.agency_sf52_type;
2250: l_agency_code varchar2(80);
2251: l_imm_entitlement ghr_api.entitlement_type;
2252: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2253: l_imm_edp_pay ghr_api.edp_pay_type;
2254: l_imm_hazard_pay ghr_api.hazard_pay_type;
2255: l_imm_health_benefits ghr_api.health_benefits_type;
2256: l_imm_danger_pay ghr_api.danger_pay_type;

Line 2253: l_imm_edp_pay ghr_api.edp_pay_type;

2249: l_agency_sf52 ghr_api.agency_sf52_type;
2250: l_agency_code varchar2(80);
2251: l_imm_entitlement ghr_api.entitlement_type;
2252: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2253: l_imm_edp_pay ghr_api.edp_pay_type;
2254: l_imm_hazard_pay ghr_api.hazard_pay_type;
2255: l_imm_health_benefits ghr_api.health_benefits_type;
2256: l_imm_danger_pay ghr_api.danger_pay_type;
2257: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;

Line 2254: l_imm_hazard_pay ghr_api.hazard_pay_type;

2250: l_agency_code varchar2(80);
2251: l_imm_entitlement ghr_api.entitlement_type;
2252: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2253: l_imm_edp_pay ghr_api.edp_pay_type;
2254: l_imm_hazard_pay ghr_api.hazard_pay_type;
2255: l_imm_health_benefits ghr_api.health_benefits_type;
2256: l_imm_danger_pay ghr_api.danger_pay_type;
2257: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2258: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;

Line 2255: l_imm_health_benefits ghr_api.health_benefits_type;

2251: l_imm_entitlement ghr_api.entitlement_type;
2252: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2253: l_imm_edp_pay ghr_api.edp_pay_type;
2254: l_imm_hazard_pay ghr_api.hazard_pay_type;
2255: l_imm_health_benefits ghr_api.health_benefits_type;
2256: l_imm_danger_pay ghr_api.danger_pay_type;
2257: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2258: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2259: l_imm_post_diff_amt ghr_api.post_diff_amt_type;

Line 2256: l_imm_danger_pay ghr_api.danger_pay_type;

2252: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
2253: l_imm_edp_pay ghr_api.edp_pay_type;
2254: l_imm_hazard_pay ghr_api.hazard_pay_type;
2255: l_imm_health_benefits ghr_api.health_benefits_type;
2256: l_imm_danger_pay ghr_api.danger_pay_type;
2257: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2258: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2259: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2260: l_imm_post_diff_percent ghr_api.post_diff_percent_type;

Line 2257: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;

2253: l_imm_edp_pay ghr_api.edp_pay_type;
2254: l_imm_hazard_pay ghr_api.hazard_pay_type;
2255: l_imm_health_benefits ghr_api.health_benefits_type;
2256: l_imm_danger_pay ghr_api.danger_pay_type;
2257: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2258: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2259: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2260: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2261: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

Line 2258: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;

2254: l_imm_hazard_pay ghr_api.hazard_pay_type;
2255: l_imm_health_benefits ghr_api.health_benefits_type;
2256: l_imm_danger_pay ghr_api.danger_pay_type;
2257: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2258: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2259: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2260: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2261: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2262: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;

Line 2259: l_imm_post_diff_amt ghr_api.post_diff_amt_type;

2255: l_imm_health_benefits ghr_api.health_benefits_type;
2256: l_imm_danger_pay ghr_api.danger_pay_type;
2257: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2258: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2259: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2260: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2261: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2262: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2263: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;

Line 2260: l_imm_post_diff_percent ghr_api.post_diff_percent_type;

2256: l_imm_danger_pay ghr_api.danger_pay_type;
2257: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2258: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2259: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2260: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2261: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2262: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2263: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2264: l_imm_premium_pay ghr_api.premium_pay_type;

Line 2261: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

2257: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
2258: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2259: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2260: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2261: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2262: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2263: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2264: l_imm_premium_pay ghr_api.premium_pay_type;
2265: l_imm_retirement_annuity ghr_api.retirement_annuity_type;

Line 2262: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;

2258: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
2259: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2260: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2261: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2262: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2263: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2264: l_imm_premium_pay ghr_api.premium_pay_type;
2265: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2266: l_imm_severance_pay ghr_api.severance_pay_type;

Line 2263: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;

2259: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
2260: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2261: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2262: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2263: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2264: l_imm_premium_pay ghr_api.premium_pay_type;
2265: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2266: l_imm_severance_pay ghr_api.severance_pay_type;
2267: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;

Line 2264: l_imm_premium_pay ghr_api.premium_pay_type;

2260: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
2261: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2262: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2263: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2264: l_imm_premium_pay ghr_api.premium_pay_type;
2265: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2266: l_imm_severance_pay ghr_api.severance_pay_type;
2267: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2268: l_imm_retention_allow_review ghr_api.retention_allow_review_type;

Line 2265: l_imm_retirement_annuity ghr_api.retirement_annuity_type;

2261: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
2262: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2263: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2264: l_imm_premium_pay ghr_api.premium_pay_type;
2265: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2266: l_imm_severance_pay ghr_api.severance_pay_type;
2267: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2268: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2269: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

Line 2266: l_imm_severance_pay ghr_api.severance_pay_type;

2262: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
2263: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2264: l_imm_premium_pay ghr_api.premium_pay_type;
2265: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2266: l_imm_severance_pay ghr_api.severance_pay_type;
2267: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2268: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2269: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2270: l_rpa_type ghr_pa_requests.rpa_type%type;

Line 2267: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;

2263: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
2264: l_imm_premium_pay ghr_api.premium_pay_type;
2265: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2266: l_imm_severance_pay ghr_api.severance_pay_type;
2267: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2268: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2269: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2270: l_rpa_type ghr_pa_requests.rpa_type%type;
2271: l_mass_action_id ghr_pa_requests.mass_action_id%type;

Line 2268: l_imm_retention_allow_review ghr_api.retention_allow_review_type;

2264: l_imm_premium_pay ghr_api.premium_pay_type;
2265: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2266: l_imm_severance_pay ghr_api.severance_pay_type;
2267: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2268: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2269: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2270: l_rpa_type ghr_pa_requests.rpa_type%type;
2271: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2272: l_imm_per_benefit_info ghr_api.per_benefit_info_type;

Line 2269: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

2265: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
2266: l_imm_severance_pay ghr_api.severance_pay_type;
2267: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2268: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2269: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2270: l_rpa_type ghr_pa_requests.rpa_type%type;
2271: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2272: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
2273: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104

Line 2272: l_imm_per_benefit_info ghr_api.per_benefit_info_type;

2268: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2269: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2270: l_rpa_type ghr_pa_requests.rpa_type%type;
2271: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2272: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
2273: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
2274:
2275:
2276: CURSOR c_cnt_history IS

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

2269: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2270: l_rpa_type ghr_pa_requests.rpa_type%type;
2271: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2272: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
2273: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
2274:
2275:
2276: CURSOR c_cnt_history IS
2277: SELECT count(*) cnt

Line 3831: ghr_api.call_workflow

3827: p_par_object_version_number => l_rec.object_version_number);
3828: end if;
3829: end if;
3830: if (l_action_taken not in ('UPDATE_HR','END_ROUTING')) then
3831: ghr_api.call_workflow
3832: (p_pa_request_id => p_pa_request_id,
3833: p_action_taken => l_action_taken
3834: );
3835: end if;

Line 4448: ghr_api.call_workflow

4444: End if;
4445:
4446:
4447: -- call work flow
4448: ghr_api.call_workflow
4449: (p_pa_request_id => p_pa_Request_id,
4450: p_action_taken => p_action_taken,
4451: p_old_action_taken => l_old_action_taken
4452: );