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 HR_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 652: when hr_api.cannot_find_prog_unit then

648: p_mass_action_select_flag => p_mass_action_select_flag,
649: p_mass_action_comments => p_mass_action_comments
650: );
651: exception
652: when hr_api.cannot_find_prog_unit then
653: hr_api.cannot_find_prog_unit_error
654: (p_module_name => 'create_sf52',
655: p_hook_type => 'BP'
656: );

Line 653: hr_api.cannot_find_prog_unit_error

649: p_mass_action_comments => p_mass_action_comments
650: );
651: exception
652: when hr_api.cannot_find_prog_unit then
653: hr_api.cannot_find_prog_unit_error
654: (p_module_name => 'create_sf52',
655: p_hook_type => 'BP'
656: );
657: end;

Line 680: If nvl(p_1_approval_status,hr_api.g_varchar2) = 'APPROVE' then

676: l_approval_date := p_approval_date;
677: l_approving_official_work_titl := p_approving_official_work_titl;
678: l_approving_official_full_name := p_approving_official_full_name;
679:
680: If nvl(p_1_approval_status,hr_api.g_varchar2) = 'APPROVE' then
681: If p_approval_date is null
682: then
683: hr_utility.set_location('approval date is not null',1);
684: l_effective_date := trunc(sysdate);

Line 713: If nvl(p_1_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then

709:
710: -- Update the SF50 approver details , when the user chooses to 'Update HR' (Immediate or Future)
711: -- Derive for individual actions . For Mass Actions they are the same as the SF52 approver details
712:
713: If nvl(p_1_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then
714: If p_approval_date is not null then
715: l_sf50_approval_date := p_approval_date;
716: l_sf50_approving_ofcl_work_tit := p_approving_official_work_titl;
717: l_sf50_approving_ofcl_full_nam := p_approving_official_full_name;

Line 1059: -- (nvl(p_1_action_taken,hr_api.g_varchar2) = 'NOT_ROUTED' and p_mass_action_id is null and nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' )

1055:
1056: -- Create all the noa_specific extra information
1057: l_position_id := nvl(p_to_position_id,p_from_position_id);
1058:
1059: -- (nvl(p_1_action_taken,hr_api.g_varchar2) = 'NOT_ROUTED' and p_mass_action_id is null and nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' )
1060: -- Comment above line because irrespective of p_mass_action_id value the if condn should be true (AVR)
1061:
1062: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
1063: or

Line 1062: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'

1058:
1059: -- (nvl(p_1_action_taken,hr_api.g_varchar2) = 'NOT_ROUTED' and p_mass_action_id is null and nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' )
1060: -- Comment above line because irrespective of p_mass_action_id value the if condn should be true (AVR)
1061:
1062: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
1063: or
1064: (nvl(p_1_action_taken,hr_api.g_varchar2) = 'NOT_ROUTED' and
1065: nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' )
1066: then

Line 1064: (nvl(p_1_action_taken,hr_api.g_varchar2) = 'NOT_ROUTED' and

1060: -- Comment above line because irrespective of p_mass_action_id value the if condn should be true (AVR)
1061:
1062: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
1063: or
1064: (nvl(p_1_action_taken,hr_api.g_varchar2) = 'NOT_ROUTED' and
1065: nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' )
1066: then
1067:
1068: If p_person_id is not null or p_noa_family_code = 'APP' then

Line 1065: nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' )

1061:
1062: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
1063: or
1064: (nvl(p_1_action_taken,hr_api.g_varchar2) = 'NOT_ROUTED' and
1065: nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' )
1066: then
1067:
1068: If p_person_id is not null or p_noa_family_code = 'APP' then
1069: GHR_NON_SF52_EXTRA_INFO.fetch_generic_extra_info

Line 1148: if nvl(p_authorized_by_person_id,hr_api.g_number) <>

1144:
1145: hr_utility.set_location('passed action taken ' ||p_1_action_taken,1);
1146: l_action_taken := p_1_action_taken;
1147: if l_action_taken is null then
1148: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1149: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
1150: l_action_taken := 'AUTHORIZED';
1151: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1152: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then

Line 1149: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then

1145: hr_utility.set_location('passed action taken ' ||p_1_action_taken,1);
1146: l_action_taken := p_1_action_taken;
1147: if l_action_taken is null then
1148: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1149: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
1150: l_action_taken := 'AUTHORIZED';
1151: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1152: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
1153: l_action_taken := 'REQUESTED';

Line 1151: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>

1147: if l_action_taken is null then
1148: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1149: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
1150: l_action_taken := 'AUTHORIZED';
1151: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1152: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
1153: l_action_taken := 'REQUESTED';
1154: else
1155: hr_utility.set_location('Bef c_history_exists ' ||l_pa_request_id,2);

Line 1152: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then

1148: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1149: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
1150: l_action_taken := 'AUTHORIZED';
1151: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1152: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
1153: l_action_taken := 'REQUESTED';
1154: else
1155: hr_utility.set_location('Bef c_history_exists ' ||l_pa_request_id,2);
1156: for history_exists in C_history_exists loop

Line 1212: if nvl(l_action_taken,hr_api.g_varchar2) not in

1208: end if;
1209: end if;
1210:
1211: -- write the first record into the routing history (actions done by the user)
1212: if nvl(l_action_taken,hr_api.g_varchar2) not in
1213: ('CANCELED','UPDATE_HR_COMPLETE') then
1214: ----If (p_mass_action_id is not null and nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA') or (p_mass_action_id is null) then
1215: -- Comment above line because irrespective of p_mass_action_id value the if condn should be true (AVR)
1216:

Line 1214: ----If (p_mass_action_id is not null and nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA') or (p_mass_action_id is null) then

1210:
1211: -- write the first record into the routing history (actions done by the user)
1212: if nvl(l_action_taken,hr_api.g_varchar2) not in
1213: ('CANCELED','UPDATE_HR_COMPLETE') then
1214: ----If (p_mass_action_id is not null and nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA') or (p_mass_action_id is null) then
1215: -- Comment above line because irrespective of p_mass_action_id value the if condn should be true (AVR)
1216:
1217: If nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' then
1218: if l_action_taken = 'UPDATE_HR' and trunc(p_effective_date) > trunc(sysdate) then

Line 1217: If nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' then

1213: ('CANCELED','UPDATE_HR_COMPLETE') then
1214: ----If (p_mass_action_id is not null and nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA') or (p_mass_action_id is null) then
1215: -- Comment above line because irrespective of p_mass_action_id value the if condn should be true (AVR)
1216:
1217: If nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' then
1218: if l_action_taken = 'UPDATE_HR' and trunc(p_effective_date) > trunc(sysdate) then
1219: l_action_taken := 'FUTURE_ACTION';
1220: End if;
1221:

Line 1298: if nvl(l_action_taken,hr_api.g_varchar2) not in ('NOT_ROUTED','UPDATE_HR','FUTURE_ACTION','END_ROUTING') then

1294: --Insert 2nd record into routing_history for routing details
1295: -- (exception when routing_status = 'NOT_ROUTED' or 'UPDATE_HR','FUTURE_ACTION','END_ROUTING')
1296: /***dk***/
1297: -- added END_ROUTING to the following if stmt.
1298: if nvl(l_action_taken,hr_api.g_varchar2) not in ('NOT_ROUTED','UPDATE_HR','FUTURE_ACTION','END_ROUTING') then
1299:
1300: ghr_prh_ins.ins
1301: (p_pa_routing_history_id => p_2_pa_routing_history_id,
1302: p_pa_request_id => l_pa_request_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 1941: when hr_api.cannot_find_prog_unit then

1937: p_mass_action_select_flag => p_mass_action_select_flag,
1938: p_mass_action_comments => p_mass_action_comments
1939: );
1940: exception
1941: when hr_api.cannot_find_prog_unit then
1942: hr_api.cannot_find_prog_unit_error
1943: (p_module_name => 'create_sf52',
1944: p_hook_type => 'AP'
1945: );

Line 1942: hr_api.cannot_find_prog_unit_error

1938: p_mass_action_comments => p_mass_action_comments
1939: );
1940: exception
1941: when hr_api.cannot_find_prog_unit then
1942: hr_api.cannot_find_prog_unit_error
1943: (p_module_name => 'create_sf52',
1944: p_hook_type => 'AP'
1945: );
1946: end;

Line 1953: raise hr_api.validate_enabled;

1949: --
1950: -- When in validation only mode raise the Validate_Enabled exception
1951: --
1952: if p_validate then
1953: raise hr_api.validate_enabled;
1954: end if;
1955:
1956: --
1957: -- Set all output arguments

Line 1963: when hr_api.validate_enabled then

1959: p_pa_request_id := l_pa_request_id;
1960:
1961: hr_utility.set_location(' Leaving:'||l_proc, 11);
1962: exception
1963: when hr_api.validate_enabled then
1964: -- As the Validate_Enabled exception has been raised
1965: -- we must rollback to the savepoint
1966:
1967: ROLLBACK TO create_sf52;

Line 2002: p_noa_family_code in varchar2 default hr_api.g_varchar2,

1998: -- ----------------------------------------------------------------------------
1999: procedure update_sf52
2000: (p_validate in boolean default false,
2001: p_pa_request_id in number,
2002: p_noa_family_code in varchar2 default hr_api.g_varchar2,
2003: p_routing_group_id in number default hr_api.g_number,
2004: p_par_object_version_number in out nocopy number,
2005: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
2006: p_academic_discipline in varchar2 default hr_api.g_varchar2,

Line 2003: p_routing_group_id in number default hr_api.g_number,

1999: procedure update_sf52
2000: (p_validate in boolean default false,
2001: p_pa_request_id in number,
2002: p_noa_family_code in varchar2 default hr_api.g_varchar2,
2003: p_routing_group_id in number default hr_api.g_number,
2004: p_par_object_version_number in out nocopy number,
2005: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
2006: p_academic_discipline in varchar2 default hr_api.g_varchar2,
2007: p_additional_info_person_id in number default hr_api.g_number,

Line 2005: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,

2001: p_pa_request_id in number,
2002: p_noa_family_code in varchar2 default hr_api.g_varchar2,
2003: p_routing_group_id in number default hr_api.g_number,
2004: p_par_object_version_number in out nocopy number,
2005: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
2006: p_academic_discipline in varchar2 default hr_api.g_varchar2,
2007: p_additional_info_person_id in number default hr_api.g_number,
2008: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
2009: p_altered_pa_request_id in number default hr_api.g_number,

Line 2006: p_academic_discipline in varchar2 default hr_api.g_varchar2,

2002: p_noa_family_code in varchar2 default hr_api.g_varchar2,
2003: p_routing_group_id in number default hr_api.g_number,
2004: p_par_object_version_number in out nocopy number,
2005: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
2006: p_academic_discipline in varchar2 default hr_api.g_varchar2,
2007: p_additional_info_person_id in number default hr_api.g_number,
2008: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
2009: p_altered_pa_request_id in number default hr_api.g_number,
2010: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,

Line 2007: p_additional_info_person_id in number default hr_api.g_number,

2003: p_routing_group_id in number default hr_api.g_number,
2004: p_par_object_version_number in out nocopy number,
2005: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
2006: p_academic_discipline in varchar2 default hr_api.g_varchar2,
2007: p_additional_info_person_id in number default hr_api.g_number,
2008: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
2009: p_altered_pa_request_id in number default hr_api.g_number,
2010: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
2011: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,

Line 2008: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,

2004: p_par_object_version_number in out nocopy number,
2005: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
2006: p_academic_discipline in varchar2 default hr_api.g_varchar2,
2007: p_additional_info_person_id in number default hr_api.g_number,
2008: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
2009: p_altered_pa_request_id in number default hr_api.g_number,
2010: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
2011: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
2012: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,

Line 2009: p_altered_pa_request_id in number default hr_api.g_number,

2005: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
2006: p_academic_discipline in varchar2 default hr_api.g_varchar2,
2007: p_additional_info_person_id in number default hr_api.g_number,
2008: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
2009: p_altered_pa_request_id in number default hr_api.g_number,
2010: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
2011: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
2012: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
2013: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,

Line 2010: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,

2006: p_academic_discipline in varchar2 default hr_api.g_varchar2,
2007: p_additional_info_person_id in number default hr_api.g_number,
2008: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
2009: p_altered_pa_request_id in number default hr_api.g_number,
2010: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
2011: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
2012: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
2013: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
2014: p_approval_date in date default hr_api.g_date,

Line 2011: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,

2007: p_additional_info_person_id in number default hr_api.g_number,
2008: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
2009: p_altered_pa_request_id in number default hr_api.g_number,
2010: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
2011: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
2012: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
2013: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
2014: p_approval_date in date default hr_api.g_date,
2015: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,

Line 2012: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,

2008: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
2009: p_altered_pa_request_id in number default hr_api.g_number,
2010: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
2011: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
2012: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
2013: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
2014: p_approval_date in date default hr_api.g_date,
2015: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
2016: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,

Line 2013: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,

2009: p_altered_pa_request_id in number default hr_api.g_number,
2010: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
2011: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
2012: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
2013: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
2014: p_approval_date in date default hr_api.g_date,
2015: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
2016: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
2017: p_authorized_by_person_id in number default hr_api.g_number,

Line 2014: p_approval_date in date default hr_api.g_date,

2010: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
2011: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
2012: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
2013: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
2014: p_approval_date in date default hr_api.g_date,
2015: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
2016: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
2017: p_authorized_by_person_id in number default hr_api.g_number,
2018: p_authorized_by_title in varchar2 default hr_api.g_varchar2,

Line 2015: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,

2011: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
2012: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
2013: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
2014: p_approval_date in date default hr_api.g_date,
2015: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
2016: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
2017: p_authorized_by_person_id in number default hr_api.g_number,
2018: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
2019: p_award_amount in number default hr_api.g_number,

Line 2016: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,

2012: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
2013: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
2014: p_approval_date in date default hr_api.g_date,
2015: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
2016: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
2017: p_authorized_by_person_id in number default hr_api.g_number,
2018: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
2019: p_award_amount in number default hr_api.g_number,
2020: p_award_uom in varchar2 default hr_api.g_varchar2,

Line 2017: p_authorized_by_person_id in number default hr_api.g_number,

2013: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
2014: p_approval_date in date default hr_api.g_date,
2015: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
2016: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
2017: p_authorized_by_person_id in number default hr_api.g_number,
2018: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
2019: p_award_amount in number default hr_api.g_number,
2020: p_award_uom in varchar2 default hr_api.g_varchar2,
2021: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,

Line 2018: p_authorized_by_title in varchar2 default hr_api.g_varchar2,

2014: p_approval_date in date default hr_api.g_date,
2015: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
2016: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
2017: p_authorized_by_person_id in number default hr_api.g_number,
2018: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
2019: p_award_amount in number default hr_api.g_number,
2020: p_award_uom in varchar2 default hr_api.g_varchar2,
2021: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
2022: p_citizenship in varchar2 default hr_api.g_varchar2,

Line 2019: p_award_amount in number default hr_api.g_number,

2015: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
2016: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
2017: p_authorized_by_person_id in number default hr_api.g_number,
2018: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
2019: p_award_amount in number default hr_api.g_number,
2020: p_award_uom in varchar2 default hr_api.g_varchar2,
2021: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
2022: p_citizenship in varchar2 default hr_api.g_varchar2,
2023: p_concurrence_date in date default hr_api.g_date,

Line 2020: p_award_uom in varchar2 default hr_api.g_varchar2,

2016: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
2017: p_authorized_by_person_id in number default hr_api.g_number,
2018: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
2019: p_award_amount in number default hr_api.g_number,
2020: p_award_uom in varchar2 default hr_api.g_varchar2,
2021: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
2022: p_citizenship in varchar2 default hr_api.g_varchar2,
2023: p_concurrence_date in date default hr_api.g_date,
2024: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,

Line 2021: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,

2017: p_authorized_by_person_id in number default hr_api.g_number,
2018: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
2019: p_award_amount in number default hr_api.g_number,
2020: p_award_uom in varchar2 default hr_api.g_varchar2,
2021: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
2022: p_citizenship in varchar2 default hr_api.g_varchar2,
2023: p_concurrence_date in date default hr_api.g_date,
2024: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
2025: p_duty_station_code in varchar2 default hr_api.g_varchar2,

Line 2022: p_citizenship in varchar2 default hr_api.g_varchar2,

2018: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
2019: p_award_amount in number default hr_api.g_number,
2020: p_award_uom in varchar2 default hr_api.g_varchar2,
2021: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
2022: p_citizenship in varchar2 default hr_api.g_varchar2,
2023: p_concurrence_date in date default hr_api.g_date,
2024: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
2025: p_duty_station_code in varchar2 default hr_api.g_varchar2,
2026: p_duty_station_desc in varchar2 default hr_api.g_varchar2,

Line 2023: p_concurrence_date in date default hr_api.g_date,

2019: p_award_amount in number default hr_api.g_number,
2020: p_award_uom in varchar2 default hr_api.g_varchar2,
2021: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
2022: p_citizenship in varchar2 default hr_api.g_varchar2,
2023: p_concurrence_date in date default hr_api.g_date,
2024: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
2025: p_duty_station_code in varchar2 default hr_api.g_varchar2,
2026: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
2027: p_duty_station_id in number default hr_api.g_number,

Line 2024: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,

2020: p_award_uom in varchar2 default hr_api.g_varchar2,
2021: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
2022: p_citizenship in varchar2 default hr_api.g_varchar2,
2023: p_concurrence_date in date default hr_api.g_date,
2024: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
2025: p_duty_station_code in varchar2 default hr_api.g_varchar2,
2026: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
2027: p_duty_station_id in number default hr_api.g_number,
2028: p_duty_station_location_id in number default hr_api.g_number,

Line 2025: p_duty_station_code in varchar2 default hr_api.g_varchar2,

2021: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
2022: p_citizenship in varchar2 default hr_api.g_varchar2,
2023: p_concurrence_date in date default hr_api.g_date,
2024: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
2025: p_duty_station_code in varchar2 default hr_api.g_varchar2,
2026: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
2027: p_duty_station_id in number default hr_api.g_number,
2028: p_duty_station_location_id in number default hr_api.g_number,
2029: p_education_level in varchar2 default hr_api.g_varchar2,

Line 2026: p_duty_station_desc in varchar2 default hr_api.g_varchar2,

2022: p_citizenship in varchar2 default hr_api.g_varchar2,
2023: p_concurrence_date in date default hr_api.g_date,
2024: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
2025: p_duty_station_code in varchar2 default hr_api.g_varchar2,
2026: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
2027: p_duty_station_id in number default hr_api.g_number,
2028: p_duty_station_location_id in number default hr_api.g_number,
2029: p_education_level in varchar2 default hr_api.g_varchar2,
2030: p_effective_date in date default hr_api.g_date,

Line 2027: p_duty_station_id in number default hr_api.g_number,

2023: p_concurrence_date in date default hr_api.g_date,
2024: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
2025: p_duty_station_code in varchar2 default hr_api.g_varchar2,
2026: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
2027: p_duty_station_id in number default hr_api.g_number,
2028: p_duty_station_location_id in number default hr_api.g_number,
2029: p_education_level in varchar2 default hr_api.g_varchar2,
2030: p_effective_date in date default hr_api.g_date,
2031: p_employee_assignment_id in number default hr_api.g_number,

Line 2028: p_duty_station_location_id in number default hr_api.g_number,

2024: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
2025: p_duty_station_code in varchar2 default hr_api.g_varchar2,
2026: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
2027: p_duty_station_id in number default hr_api.g_number,
2028: p_duty_station_location_id in number default hr_api.g_number,
2029: p_education_level in varchar2 default hr_api.g_varchar2,
2030: p_effective_date in date default hr_api.g_date,
2031: p_employee_assignment_id in number default hr_api.g_number,
2032: p_employee_date_of_birth in date default hr_api.g_date,

Line 2029: p_education_level in varchar2 default hr_api.g_varchar2,

2025: p_duty_station_code in varchar2 default hr_api.g_varchar2,
2026: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
2027: p_duty_station_id in number default hr_api.g_number,
2028: p_duty_station_location_id in number default hr_api.g_number,
2029: p_education_level in varchar2 default hr_api.g_varchar2,
2030: p_effective_date in date default hr_api.g_date,
2031: p_employee_assignment_id in number default hr_api.g_number,
2032: p_employee_date_of_birth in date default hr_api.g_date,
2033: p_employee_first_name in varchar2 default hr_api.g_varchar2,

Line 2030: p_effective_date in date default hr_api.g_date,

2026: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
2027: p_duty_station_id in number default hr_api.g_number,
2028: p_duty_station_location_id in number default hr_api.g_number,
2029: p_education_level in varchar2 default hr_api.g_varchar2,
2030: p_effective_date in date default hr_api.g_date,
2031: p_employee_assignment_id in number default hr_api.g_number,
2032: p_employee_date_of_birth in date default hr_api.g_date,
2033: p_employee_first_name in varchar2 default hr_api.g_varchar2,
2034: p_employee_last_name in varchar2 default hr_api.g_varchar2,

Line 2031: p_employee_assignment_id in number default hr_api.g_number,

2027: p_duty_station_id in number default hr_api.g_number,
2028: p_duty_station_location_id in number default hr_api.g_number,
2029: p_education_level in varchar2 default hr_api.g_varchar2,
2030: p_effective_date in date default hr_api.g_date,
2031: p_employee_assignment_id in number default hr_api.g_number,
2032: p_employee_date_of_birth in date default hr_api.g_date,
2033: p_employee_first_name in varchar2 default hr_api.g_varchar2,
2034: p_employee_last_name in varchar2 default hr_api.g_varchar2,
2035: p_employee_middle_names in varchar2 default hr_api.g_varchar2,

Line 2032: p_employee_date_of_birth in date default hr_api.g_date,

2028: p_duty_station_location_id in number default hr_api.g_number,
2029: p_education_level in varchar2 default hr_api.g_varchar2,
2030: p_effective_date in date default hr_api.g_date,
2031: p_employee_assignment_id in number default hr_api.g_number,
2032: p_employee_date_of_birth in date default hr_api.g_date,
2033: p_employee_first_name in varchar2 default hr_api.g_varchar2,
2034: p_employee_last_name in varchar2 default hr_api.g_varchar2,
2035: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
2036: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,

Line 2033: p_employee_first_name in varchar2 default hr_api.g_varchar2,

2029: p_education_level in varchar2 default hr_api.g_varchar2,
2030: p_effective_date in date default hr_api.g_date,
2031: p_employee_assignment_id in number default hr_api.g_number,
2032: p_employee_date_of_birth in date default hr_api.g_date,
2033: p_employee_first_name in varchar2 default hr_api.g_varchar2,
2034: p_employee_last_name in varchar2 default hr_api.g_varchar2,
2035: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
2036: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
2037: p_fegli in varchar2 default hr_api.g_varchar2,

Line 2034: p_employee_last_name in varchar2 default hr_api.g_varchar2,

2030: p_effective_date in date default hr_api.g_date,
2031: p_employee_assignment_id in number default hr_api.g_number,
2032: p_employee_date_of_birth in date default hr_api.g_date,
2033: p_employee_first_name in varchar2 default hr_api.g_varchar2,
2034: p_employee_last_name in varchar2 default hr_api.g_varchar2,
2035: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
2036: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
2037: p_fegli in varchar2 default hr_api.g_varchar2,
2038: p_fegli_desc in varchar2 default hr_api.g_varchar2,

Line 2035: p_employee_middle_names in varchar2 default hr_api.g_varchar2,

2031: p_employee_assignment_id in number default hr_api.g_number,
2032: p_employee_date_of_birth in date default hr_api.g_date,
2033: p_employee_first_name in varchar2 default hr_api.g_varchar2,
2034: p_employee_last_name in varchar2 default hr_api.g_varchar2,
2035: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
2036: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
2037: p_fegli in varchar2 default hr_api.g_varchar2,
2038: p_fegli_desc in varchar2 default hr_api.g_varchar2,
2039: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,

Line 2036: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,

2032: p_employee_date_of_birth in date default hr_api.g_date,
2033: p_employee_first_name in varchar2 default hr_api.g_varchar2,
2034: p_employee_last_name in varchar2 default hr_api.g_varchar2,
2035: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
2036: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
2037: p_fegli in varchar2 default hr_api.g_varchar2,
2038: p_fegli_desc in varchar2 default hr_api.g_varchar2,
2039: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
2040: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,

Line 2037: p_fegli in varchar2 default hr_api.g_varchar2,

2033: p_employee_first_name in varchar2 default hr_api.g_varchar2,
2034: p_employee_last_name in varchar2 default hr_api.g_varchar2,
2035: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
2036: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
2037: p_fegli in varchar2 default hr_api.g_varchar2,
2038: p_fegli_desc in varchar2 default hr_api.g_varchar2,
2039: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
2040: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
2041: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,

Line 2038: p_fegli_desc in varchar2 default hr_api.g_varchar2,

2034: p_employee_last_name in varchar2 default hr_api.g_varchar2,
2035: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
2036: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
2037: p_fegli in varchar2 default hr_api.g_varchar2,
2038: p_fegli_desc in varchar2 default hr_api.g_varchar2,
2039: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
2040: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
2041: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2042: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,

Line 2039: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,

2035: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
2036: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
2037: p_fegli in varchar2 default hr_api.g_varchar2,
2038: p_fegli_desc in varchar2 default hr_api.g_varchar2,
2039: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
2040: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
2041: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2042: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2043: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,

Line 2040: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,

2036: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
2037: p_fegli in varchar2 default hr_api.g_varchar2,
2038: p_fegli_desc in varchar2 default hr_api.g_varchar2,
2039: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
2040: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
2041: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2042: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2043: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2044: p_first_noa_code in varchar2 default hr_api.g_varchar2,

Line 2041: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,

2037: p_fegli in varchar2 default hr_api.g_varchar2,
2038: p_fegli_desc in varchar2 default hr_api.g_varchar2,
2039: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
2040: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
2041: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2042: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2043: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2044: p_first_noa_code in varchar2 default hr_api.g_varchar2,
2045: p_first_noa_desc in varchar2 default hr_api.g_varchar2,

Line 2042: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,

2038: p_fegli_desc in varchar2 default hr_api.g_varchar2,
2039: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
2040: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
2041: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2042: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2043: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2044: p_first_noa_code in varchar2 default hr_api.g_varchar2,
2045: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
2046: p_first_noa_id in number default hr_api.g_number,

Line 2043: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,

2039: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
2040: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
2041: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2042: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2043: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2044: p_first_noa_code in varchar2 default hr_api.g_varchar2,
2045: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
2046: p_first_noa_id in number default hr_api.g_number,
2047: p_first_noa_pa_request_id in number default hr_api.g_number,

Line 2044: p_first_noa_code in varchar2 default hr_api.g_varchar2,

2040: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
2041: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2042: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2043: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2044: p_first_noa_code in varchar2 default hr_api.g_varchar2,
2045: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
2046: p_first_noa_id in number default hr_api.g_number,
2047: p_first_noa_pa_request_id in number default hr_api.g_number,
2048: p_flsa_category in varchar2 default hr_api.g_varchar2,

Line 2045: p_first_noa_desc in varchar2 default hr_api.g_varchar2,

2041: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2042: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2043: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2044: p_first_noa_code in varchar2 default hr_api.g_varchar2,
2045: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
2046: p_first_noa_id in number default hr_api.g_number,
2047: p_first_noa_pa_request_id in number default hr_api.g_number,
2048: p_flsa_category in varchar2 default hr_api.g_varchar2,
2049: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,

Line 2046: p_first_noa_id in number default hr_api.g_number,

2042: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2043: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2044: p_first_noa_code in varchar2 default hr_api.g_varchar2,
2045: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
2046: p_first_noa_id in number default hr_api.g_number,
2047: p_first_noa_pa_request_id in number default hr_api.g_number,
2048: p_flsa_category in varchar2 default hr_api.g_varchar2,
2049: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
2050: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,

Line 2047: p_first_noa_pa_request_id in number default hr_api.g_number,

2043: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2044: p_first_noa_code in varchar2 default hr_api.g_varchar2,
2045: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
2046: p_first_noa_id in number default hr_api.g_number,
2047: p_first_noa_pa_request_id in number default hr_api.g_number,
2048: p_flsa_category in varchar2 default hr_api.g_varchar2,
2049: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
2050: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
2051: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,

Line 2048: p_flsa_category in varchar2 default hr_api.g_varchar2,

2044: p_first_noa_code in varchar2 default hr_api.g_varchar2,
2045: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
2046: p_first_noa_id in number default hr_api.g_number,
2047: p_first_noa_pa_request_id in number default hr_api.g_number,
2048: p_flsa_category in varchar2 default hr_api.g_varchar2,
2049: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
2050: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
2051: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
2052: p_forwarding_country in varchar2 default hr_api.g_varchar2,

Line 2049: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,

2045: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
2046: p_first_noa_id in number default hr_api.g_number,
2047: p_first_noa_pa_request_id in number default hr_api.g_number,
2048: p_flsa_category in varchar2 default hr_api.g_varchar2,
2049: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
2050: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
2051: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
2052: p_forwarding_country in varchar2 default hr_api.g_varchar2,
2053: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,

Line 2050: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,

2046: p_first_noa_id in number default hr_api.g_number,
2047: p_first_noa_pa_request_id in number default hr_api.g_number,
2048: p_flsa_category in varchar2 default hr_api.g_varchar2,
2049: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
2050: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
2051: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
2052: p_forwarding_country in varchar2 default hr_api.g_varchar2,
2053: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
2054: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,

Line 2051: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,

2047: p_first_noa_pa_request_id in number default hr_api.g_number,
2048: p_flsa_category in varchar2 default hr_api.g_varchar2,
2049: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
2050: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
2051: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
2052: p_forwarding_country in varchar2 default hr_api.g_varchar2,
2053: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
2054: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
2055: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,

Line 2052: p_forwarding_country in varchar2 default hr_api.g_varchar2,

2048: p_flsa_category in varchar2 default hr_api.g_varchar2,
2049: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
2050: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
2051: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
2052: p_forwarding_country in varchar2 default hr_api.g_varchar2,
2053: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
2054: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
2055: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
2056: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,

Line 2053: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,

2049: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
2050: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
2051: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
2052: p_forwarding_country in varchar2 default hr_api.g_varchar2,
2053: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
2054: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
2055: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
2056: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
2057: p_from_adj_basic_pay in number default hr_api.g_number,

Line 2054: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,

2050: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
2051: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
2052: p_forwarding_country in varchar2 default hr_api.g_varchar2,
2053: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
2054: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
2055: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
2056: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
2057: p_from_adj_basic_pay in number default hr_api.g_number,
2058: p_from_basic_pay in number default hr_api.g_number,

Line 2055: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,

2051: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
2052: p_forwarding_country in varchar2 default hr_api.g_varchar2,
2053: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
2054: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
2055: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
2056: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
2057: p_from_adj_basic_pay in number default hr_api.g_number,
2058: p_from_basic_pay in number default hr_api.g_number,
2059: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,

Line 2056: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,

2052: p_forwarding_country in varchar2 default hr_api.g_varchar2,
2053: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
2054: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
2055: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
2056: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
2057: p_from_adj_basic_pay in number default hr_api.g_number,
2058: p_from_basic_pay in number default hr_api.g_number,
2059: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
2060: p_from_locality_adj in number default hr_api.g_number,

Line 2057: p_from_adj_basic_pay in number default hr_api.g_number,

2053: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
2054: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
2055: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
2056: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
2057: p_from_adj_basic_pay in number default hr_api.g_number,
2058: p_from_basic_pay in number default hr_api.g_number,
2059: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
2060: p_from_locality_adj in number default hr_api.g_number,
2061: p_from_occ_code in varchar2 default hr_api.g_varchar2,

Line 2058: p_from_basic_pay in number default hr_api.g_number,

2054: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
2055: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
2056: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
2057: p_from_adj_basic_pay in number default hr_api.g_number,
2058: p_from_basic_pay in number default hr_api.g_number,
2059: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
2060: p_from_locality_adj in number default hr_api.g_number,
2061: p_from_occ_code in varchar2 default hr_api.g_varchar2,
2062: p_from_other_pay_amount in number default hr_api.g_number,

Line 2059: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,

2055: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
2056: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
2057: p_from_adj_basic_pay in number default hr_api.g_number,
2058: p_from_basic_pay in number default hr_api.g_number,
2059: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
2060: p_from_locality_adj in number default hr_api.g_number,
2061: p_from_occ_code in varchar2 default hr_api.g_varchar2,
2062: p_from_other_pay_amount in number default hr_api.g_number,
2063: p_from_pay_basis in varchar2 default hr_api.g_varchar2,

Line 2060: p_from_locality_adj in number default hr_api.g_number,

2056: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
2057: p_from_adj_basic_pay in number default hr_api.g_number,
2058: p_from_basic_pay in number default hr_api.g_number,
2059: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
2060: p_from_locality_adj in number default hr_api.g_number,
2061: p_from_occ_code in varchar2 default hr_api.g_varchar2,
2062: p_from_other_pay_amount in number default hr_api.g_number,
2063: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
2064: p_from_pay_plan in varchar2 default hr_api.g_varchar2,

Line 2061: p_from_occ_code in varchar2 default hr_api.g_varchar2,

2057: p_from_adj_basic_pay in number default hr_api.g_number,
2058: p_from_basic_pay in number default hr_api.g_number,
2059: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
2060: p_from_locality_adj in number default hr_api.g_number,
2061: p_from_occ_code in varchar2 default hr_api.g_varchar2,
2062: p_from_other_pay_amount in number default hr_api.g_number,
2063: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
2064: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
2065: -- FWFA Changes Bug#4444609

Line 2062: p_from_other_pay_amount in number default hr_api.g_number,

2058: p_from_basic_pay in number default hr_api.g_number,
2059: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
2060: p_from_locality_adj in number default hr_api.g_number,
2061: p_from_occ_code in varchar2 default hr_api.g_varchar2,
2062: p_from_other_pay_amount in number default hr_api.g_number,
2063: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
2064: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
2065: -- FWFA Changes Bug#4444609
2066: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,

Line 2063: p_from_pay_basis in varchar2 default hr_api.g_varchar2,

2059: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
2060: p_from_locality_adj in number default hr_api.g_number,
2061: p_from_occ_code in varchar2 default hr_api.g_varchar2,
2062: p_from_other_pay_amount in number default hr_api.g_number,
2063: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
2064: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
2065: -- FWFA Changes Bug#4444609
2066: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2067: p_from_pay_table_identifier in number default hr_api.g_number,

Line 2064: p_from_pay_plan in varchar2 default hr_api.g_varchar2,

2060: p_from_locality_adj in number default hr_api.g_number,
2061: p_from_occ_code in varchar2 default hr_api.g_varchar2,
2062: p_from_other_pay_amount in number default hr_api.g_number,
2063: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
2064: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
2065: -- FWFA Changes Bug#4444609
2066: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2067: p_from_pay_table_identifier in number default hr_api.g_number,
2068: -- FWFA Changes

Line 2066: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,

2062: p_from_other_pay_amount in number default hr_api.g_number,
2063: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
2064: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
2065: -- FWFA Changes Bug#4444609
2066: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2067: p_from_pay_table_identifier in number default hr_api.g_number,
2068: -- FWFA Changes
2069: p_from_position_id in number default hr_api.g_number,
2070: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,

Line 2067: p_from_pay_table_identifier in number default hr_api.g_number,

2063: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
2064: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
2065: -- FWFA Changes Bug#4444609
2066: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2067: p_from_pay_table_identifier in number default hr_api.g_number,
2068: -- FWFA Changes
2069: p_from_position_id in number default hr_api.g_number,
2070: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
2071: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,

Line 2069: p_from_position_id in number default hr_api.g_number,

2065: -- FWFA Changes Bug#4444609
2066: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2067: p_from_pay_table_identifier in number default hr_api.g_number,
2068: -- FWFA Changes
2069: p_from_position_id in number default hr_api.g_number,
2070: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
2071: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
2072: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
2073: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,

Line 2070: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,

2066: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2067: p_from_pay_table_identifier in number default hr_api.g_number,
2068: -- FWFA Changes
2069: p_from_position_id in number default hr_api.g_number,
2070: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
2071: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
2072: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
2073: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2074: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,

Line 2071: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,

2067: p_from_pay_table_identifier in number default hr_api.g_number,
2068: -- FWFA Changes
2069: p_from_position_id in number default hr_api.g_number,
2070: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
2071: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
2072: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
2073: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2074: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2075: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,

Line 2072: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,

2068: -- FWFA Changes
2069: p_from_position_id in number default hr_api.g_number,
2070: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
2071: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
2072: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
2073: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2074: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2075: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2076: p_from_position_number in varchar2 default hr_api.g_varchar2,

Line 2073: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,

2069: p_from_position_id in number default hr_api.g_number,
2070: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
2071: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
2072: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
2073: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2074: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2075: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2076: p_from_position_number in varchar2 default hr_api.g_varchar2,
2077: p_from_position_seq_no in number default hr_api.g_number,

Line 2074: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,

2070: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
2071: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
2072: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
2073: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2074: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2075: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2076: p_from_position_number in varchar2 default hr_api.g_varchar2,
2077: p_from_position_seq_no in number default hr_api.g_number,
2078: p_from_position_title in varchar2 default hr_api.g_varchar2,

Line 2075: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,

2071: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
2072: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
2073: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2074: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2075: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2076: p_from_position_number in varchar2 default hr_api.g_varchar2,
2077: p_from_position_seq_no in number default hr_api.g_number,
2078: p_from_position_title in varchar2 default hr_api.g_varchar2,
2079: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,

Line 2076: p_from_position_number in varchar2 default hr_api.g_varchar2,

2072: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
2073: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2074: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2075: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2076: p_from_position_number in varchar2 default hr_api.g_varchar2,
2077: p_from_position_seq_no in number default hr_api.g_number,
2078: p_from_position_title in varchar2 default hr_api.g_varchar2,
2079: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2080: p_from_total_salary in number default hr_api.g_number,

Line 2077: p_from_position_seq_no in number default hr_api.g_number,

2073: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2074: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2075: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2076: p_from_position_number in varchar2 default hr_api.g_varchar2,
2077: p_from_position_seq_no in number default hr_api.g_number,
2078: p_from_position_title in varchar2 default hr_api.g_varchar2,
2079: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2080: p_from_total_salary in number default hr_api.g_number,
2081: p_functional_class in varchar2 default hr_api.g_varchar2,

Line 2078: p_from_position_title in varchar2 default hr_api.g_varchar2,

2074: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2075: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2076: p_from_position_number in varchar2 default hr_api.g_varchar2,
2077: p_from_position_seq_no in number default hr_api.g_number,
2078: p_from_position_title in varchar2 default hr_api.g_varchar2,
2079: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2080: p_from_total_salary in number default hr_api.g_number,
2081: p_functional_class in varchar2 default hr_api.g_varchar2,
2082: p_notepad in varchar2 default hr_api.g_varchar2,

Line 2079: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,

2075: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2076: p_from_position_number in varchar2 default hr_api.g_varchar2,
2077: p_from_position_seq_no in number default hr_api.g_number,
2078: p_from_position_title in varchar2 default hr_api.g_varchar2,
2079: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2080: p_from_total_salary in number default hr_api.g_number,
2081: p_functional_class in varchar2 default hr_api.g_varchar2,
2082: p_notepad in varchar2 default hr_api.g_varchar2,
2083: p_part_time_hours in number default hr_api.g_number,

Line 2080: p_from_total_salary in number default hr_api.g_number,

2076: p_from_position_number in varchar2 default hr_api.g_varchar2,
2077: p_from_position_seq_no in number default hr_api.g_number,
2078: p_from_position_title in varchar2 default hr_api.g_varchar2,
2079: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2080: p_from_total_salary in number default hr_api.g_number,
2081: p_functional_class in varchar2 default hr_api.g_varchar2,
2082: p_notepad in varchar2 default hr_api.g_varchar2,
2083: p_part_time_hours in number default hr_api.g_number,
2084: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,

Line 2081: p_functional_class in varchar2 default hr_api.g_varchar2,

2077: p_from_position_seq_no in number default hr_api.g_number,
2078: p_from_position_title in varchar2 default hr_api.g_varchar2,
2079: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2080: p_from_total_salary in number default hr_api.g_number,
2081: p_functional_class in varchar2 default hr_api.g_varchar2,
2082: p_notepad in varchar2 default hr_api.g_varchar2,
2083: p_part_time_hours in number default hr_api.g_number,
2084: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2085: p_person_id in number default hr_api.g_number,

Line 2082: p_notepad in varchar2 default hr_api.g_varchar2,

2078: p_from_position_title in varchar2 default hr_api.g_varchar2,
2079: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2080: p_from_total_salary in number default hr_api.g_number,
2081: p_functional_class in varchar2 default hr_api.g_varchar2,
2082: p_notepad in varchar2 default hr_api.g_varchar2,
2083: p_part_time_hours in number default hr_api.g_number,
2084: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2085: p_person_id in number default hr_api.g_number,
2086: p_position_occupied in varchar2 default hr_api.g_varchar2,

Line 2083: p_part_time_hours in number default hr_api.g_number,

2079: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2080: p_from_total_salary in number default hr_api.g_number,
2081: p_functional_class in varchar2 default hr_api.g_varchar2,
2082: p_notepad in varchar2 default hr_api.g_varchar2,
2083: p_part_time_hours in number default hr_api.g_number,
2084: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2085: p_person_id in number default hr_api.g_number,
2086: p_position_occupied in varchar2 default hr_api.g_varchar2,
2087: p_proposed_effective_date in date default hr_api.g_date,

Line 2084: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,

2080: p_from_total_salary in number default hr_api.g_number,
2081: p_functional_class in varchar2 default hr_api.g_varchar2,
2082: p_notepad in varchar2 default hr_api.g_varchar2,
2083: p_part_time_hours in number default hr_api.g_number,
2084: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2085: p_person_id in number default hr_api.g_number,
2086: p_position_occupied in varchar2 default hr_api.g_varchar2,
2087: p_proposed_effective_date in date default hr_api.g_date,
2088: p_requested_by_person_id in number default hr_api.g_number,

Line 2085: p_person_id in number default hr_api.g_number,

2081: p_functional_class in varchar2 default hr_api.g_varchar2,
2082: p_notepad in varchar2 default hr_api.g_varchar2,
2083: p_part_time_hours in number default hr_api.g_number,
2084: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2085: p_person_id in number default hr_api.g_number,
2086: p_position_occupied in varchar2 default hr_api.g_varchar2,
2087: p_proposed_effective_date in date default hr_api.g_date,
2088: p_requested_by_person_id in number default hr_api.g_number,
2089: p_requested_by_title in varchar2 default hr_api.g_varchar2,

Line 2086: p_position_occupied in varchar2 default hr_api.g_varchar2,

2082: p_notepad in varchar2 default hr_api.g_varchar2,
2083: p_part_time_hours in number default hr_api.g_number,
2084: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2085: p_person_id in number default hr_api.g_number,
2086: p_position_occupied in varchar2 default hr_api.g_varchar2,
2087: p_proposed_effective_date in date default hr_api.g_date,
2088: p_requested_by_person_id in number default hr_api.g_number,
2089: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2090: p_requested_date in date default hr_api.g_date,

Line 2087: p_proposed_effective_date in date default hr_api.g_date,

2083: p_part_time_hours in number default hr_api.g_number,
2084: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2085: p_person_id in number default hr_api.g_number,
2086: p_position_occupied in varchar2 default hr_api.g_varchar2,
2087: p_proposed_effective_date in date default hr_api.g_date,
2088: p_requested_by_person_id in number default hr_api.g_number,
2089: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2090: p_requested_date in date default hr_api.g_date,
2091: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,

Line 2088: p_requested_by_person_id in number default hr_api.g_number,

2084: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2085: p_person_id in number default hr_api.g_number,
2086: p_position_occupied in varchar2 default hr_api.g_varchar2,
2087: p_proposed_effective_date in date default hr_api.g_date,
2088: p_requested_by_person_id in number default hr_api.g_number,
2089: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2090: p_requested_date in date default hr_api.g_date,
2091: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2092: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,

Line 2089: p_requested_by_title in varchar2 default hr_api.g_varchar2,

2085: p_person_id in number default hr_api.g_number,
2086: p_position_occupied in varchar2 default hr_api.g_varchar2,
2087: p_proposed_effective_date in date default hr_api.g_date,
2088: p_requested_by_person_id in number default hr_api.g_number,
2089: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2090: p_requested_date in date default hr_api.g_date,
2091: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2092: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2093: p_request_number in varchar2 default hr_api.g_varchar2,

Line 2090: p_requested_date in date default hr_api.g_date,

2086: p_position_occupied in varchar2 default hr_api.g_varchar2,
2087: p_proposed_effective_date in date default hr_api.g_date,
2088: p_requested_by_person_id in number default hr_api.g_number,
2089: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2090: p_requested_date in date default hr_api.g_date,
2091: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2092: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2093: p_request_number in varchar2 default hr_api.g_varchar2,
2094: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,

Line 2091: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,

2087: p_proposed_effective_date in date default hr_api.g_date,
2088: p_requested_by_person_id in number default hr_api.g_number,
2089: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2090: p_requested_date in date default hr_api.g_date,
2091: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2092: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2093: p_request_number in varchar2 default hr_api.g_varchar2,
2094: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2095: p_retirement_plan in varchar2 default hr_api.g_varchar2,

Line 2092: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,

2088: p_requested_by_person_id in number default hr_api.g_number,
2089: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2090: p_requested_date in date default hr_api.g_date,
2091: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2092: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2093: p_request_number in varchar2 default hr_api.g_varchar2,
2094: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2095: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2096: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,

Line 2093: p_request_number in varchar2 default hr_api.g_varchar2,

2089: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2090: p_requested_date in date default hr_api.g_date,
2091: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2092: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2093: p_request_number in varchar2 default hr_api.g_varchar2,
2094: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2095: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2096: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2097: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,

Line 2094: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,

2090: p_requested_date in date default hr_api.g_date,
2091: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2092: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2093: p_request_number in varchar2 default hr_api.g_varchar2,
2094: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2095: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2096: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2097: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2098: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,

Line 2095: p_retirement_plan in varchar2 default hr_api.g_varchar2,

2091: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2092: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2093: p_request_number in varchar2 default hr_api.g_varchar2,
2094: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2095: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2096: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2097: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2098: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2099: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,

Line 2096: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,

2092: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2093: p_request_number in varchar2 default hr_api.g_varchar2,
2094: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2095: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2096: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2097: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2098: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2099: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2100: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,

Line 2097: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,

2093: p_request_number in varchar2 default hr_api.g_varchar2,
2094: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2095: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2096: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2097: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2098: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2099: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2100: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2101: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,

Line 2098: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,

2094: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2095: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2096: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2097: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2098: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2099: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2100: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2101: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2102: p_second_noa_code in varchar2 default hr_api.g_varchar2,

Line 2099: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,

2095: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2096: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2097: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2098: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2099: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2100: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2101: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2102: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2103: p_second_noa_desc in varchar2 default hr_api.g_varchar2,

Line 2100: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,

2096: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2097: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2098: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2099: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2100: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2101: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2102: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2103: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2104: p_second_noa_id in number default hr_api.g_number,

Line 2101: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,

2097: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2098: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2099: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2100: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2101: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2102: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2103: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2104: p_second_noa_id in number default hr_api.g_number,
2105: p_second_noa_pa_request_id in number default hr_api.g_number,

Line 2102: p_second_noa_code in varchar2 default hr_api.g_varchar2,

2098: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2099: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2100: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2101: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2102: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2103: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2104: p_second_noa_id in number default hr_api.g_number,
2105: p_second_noa_pa_request_id in number default hr_api.g_number,
2106: p_service_comp_date in date default hr_api.g_date,

Line 2103: p_second_noa_desc in varchar2 default hr_api.g_varchar2,

2099: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2100: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2101: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2102: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2103: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2104: p_second_noa_id in number default hr_api.g_number,
2105: p_second_noa_pa_request_id in number default hr_api.g_number,
2106: p_service_comp_date in date default hr_api.g_date,
2107: p_supervisory_status in varchar2 default hr_api.g_varchar2,

Line 2104: p_second_noa_id in number default hr_api.g_number,

2100: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2101: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2102: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2103: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2104: p_second_noa_id in number default hr_api.g_number,
2105: p_second_noa_pa_request_id in number default hr_api.g_number,
2106: p_service_comp_date in date default hr_api.g_date,
2107: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2108: p_tenure in varchar2 default hr_api.g_varchar2,

Line 2105: p_second_noa_pa_request_id in number default hr_api.g_number,

2101: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2102: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2103: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2104: p_second_noa_id in number default hr_api.g_number,
2105: p_second_noa_pa_request_id in number default hr_api.g_number,
2106: p_service_comp_date in date default hr_api.g_date,
2107: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2108: p_tenure in varchar2 default hr_api.g_varchar2,
2109: p_to_adj_basic_pay in number default hr_api.g_number,

Line 2106: p_service_comp_date in date default hr_api.g_date,

2102: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2103: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2104: p_second_noa_id in number default hr_api.g_number,
2105: p_second_noa_pa_request_id in number default hr_api.g_number,
2106: p_service_comp_date in date default hr_api.g_date,
2107: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2108: p_tenure in varchar2 default hr_api.g_varchar2,
2109: p_to_adj_basic_pay in number default hr_api.g_number,
2110: p_to_basic_pay in number default hr_api.g_number,

Line 2107: p_supervisory_status in varchar2 default hr_api.g_varchar2,

2103: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2104: p_second_noa_id in number default hr_api.g_number,
2105: p_second_noa_pa_request_id in number default hr_api.g_number,
2106: p_service_comp_date in date default hr_api.g_date,
2107: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2108: p_tenure in varchar2 default hr_api.g_varchar2,
2109: p_to_adj_basic_pay in number default hr_api.g_number,
2110: p_to_basic_pay in number default hr_api.g_number,
2111: p_to_grade_id in number default hr_api.g_number,

Line 2108: p_tenure in varchar2 default hr_api.g_varchar2,

2104: p_second_noa_id in number default hr_api.g_number,
2105: p_second_noa_pa_request_id in number default hr_api.g_number,
2106: p_service_comp_date in date default hr_api.g_date,
2107: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2108: p_tenure in varchar2 default hr_api.g_varchar2,
2109: p_to_adj_basic_pay in number default hr_api.g_number,
2110: p_to_basic_pay in number default hr_api.g_number,
2111: p_to_grade_id in number default hr_api.g_number,
2112: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,

Line 2109: p_to_adj_basic_pay in number default hr_api.g_number,

2105: p_second_noa_pa_request_id in number default hr_api.g_number,
2106: p_service_comp_date in date default hr_api.g_date,
2107: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2108: p_tenure in varchar2 default hr_api.g_varchar2,
2109: p_to_adj_basic_pay in number default hr_api.g_number,
2110: p_to_basic_pay in number default hr_api.g_number,
2111: p_to_grade_id in number default hr_api.g_number,
2112: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2113: p_to_job_id in number default hr_api.g_number,

Line 2110: p_to_basic_pay in number default hr_api.g_number,

2106: p_service_comp_date in date default hr_api.g_date,
2107: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2108: p_tenure in varchar2 default hr_api.g_varchar2,
2109: p_to_adj_basic_pay in number default hr_api.g_number,
2110: p_to_basic_pay in number default hr_api.g_number,
2111: p_to_grade_id in number default hr_api.g_number,
2112: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2113: p_to_job_id in number default hr_api.g_number,
2114: p_to_locality_adj in number default hr_api.g_number,

Line 2111: p_to_grade_id in number default hr_api.g_number,

2107: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2108: p_tenure in varchar2 default hr_api.g_varchar2,
2109: p_to_adj_basic_pay in number default hr_api.g_number,
2110: p_to_basic_pay in number default hr_api.g_number,
2111: p_to_grade_id in number default hr_api.g_number,
2112: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2113: p_to_job_id in number default hr_api.g_number,
2114: p_to_locality_adj in number default hr_api.g_number,
2115: p_to_occ_code in varchar2 default hr_api.g_varchar2,

Line 2112: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,

2108: p_tenure in varchar2 default hr_api.g_varchar2,
2109: p_to_adj_basic_pay in number default hr_api.g_number,
2110: p_to_basic_pay in number default hr_api.g_number,
2111: p_to_grade_id in number default hr_api.g_number,
2112: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2113: p_to_job_id in number default hr_api.g_number,
2114: p_to_locality_adj in number default hr_api.g_number,
2115: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2116: p_to_organization_id in number default hr_api.g_number,

Line 2113: p_to_job_id in number default hr_api.g_number,

2109: p_to_adj_basic_pay in number default hr_api.g_number,
2110: p_to_basic_pay in number default hr_api.g_number,
2111: p_to_grade_id in number default hr_api.g_number,
2112: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2113: p_to_job_id in number default hr_api.g_number,
2114: p_to_locality_adj in number default hr_api.g_number,
2115: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2116: p_to_organization_id in number default hr_api.g_number,
2117: p_to_other_pay_amount in number default hr_api.g_number,

Line 2114: p_to_locality_adj in number default hr_api.g_number,

2110: p_to_basic_pay in number default hr_api.g_number,
2111: p_to_grade_id in number default hr_api.g_number,
2112: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2113: p_to_job_id in number default hr_api.g_number,
2114: p_to_locality_adj in number default hr_api.g_number,
2115: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2116: p_to_organization_id in number default hr_api.g_number,
2117: p_to_other_pay_amount in number default hr_api.g_number,
2118: p_to_au_overtime in number default hr_api.g_number,

Line 2115: p_to_occ_code in varchar2 default hr_api.g_varchar2,

2111: p_to_grade_id in number default hr_api.g_number,
2112: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2113: p_to_job_id in number default hr_api.g_number,
2114: p_to_locality_adj in number default hr_api.g_number,
2115: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2116: p_to_organization_id in number default hr_api.g_number,
2117: p_to_other_pay_amount in number default hr_api.g_number,
2118: p_to_au_overtime in number default hr_api.g_number,
2119: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,

Line 2116: p_to_organization_id in number default hr_api.g_number,

2112: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2113: p_to_job_id in number default hr_api.g_number,
2114: p_to_locality_adj in number default hr_api.g_number,
2115: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2116: p_to_organization_id in number default hr_api.g_number,
2117: p_to_other_pay_amount in number default hr_api.g_number,
2118: p_to_au_overtime in number default hr_api.g_number,
2119: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2120: p_to_availability_pay in number default hr_api.g_number,

Line 2117: p_to_other_pay_amount in number default hr_api.g_number,

2113: p_to_job_id in number default hr_api.g_number,
2114: p_to_locality_adj in number default hr_api.g_number,
2115: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2116: p_to_organization_id in number default hr_api.g_number,
2117: p_to_other_pay_amount in number default hr_api.g_number,
2118: p_to_au_overtime in number default hr_api.g_number,
2119: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2120: p_to_availability_pay in number default hr_api.g_number,
2121: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,

Line 2118: p_to_au_overtime in number default hr_api.g_number,

2114: p_to_locality_adj in number default hr_api.g_number,
2115: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2116: p_to_organization_id in number default hr_api.g_number,
2117: p_to_other_pay_amount in number default hr_api.g_number,
2118: p_to_au_overtime in number default hr_api.g_number,
2119: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2120: p_to_availability_pay in number default hr_api.g_number,
2121: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2122: p_to_retention_allowance in number default hr_api.g_number,

Line 2119: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,

2115: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2116: p_to_organization_id in number default hr_api.g_number,
2117: p_to_other_pay_amount in number default hr_api.g_number,
2118: p_to_au_overtime in number default hr_api.g_number,
2119: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2120: p_to_availability_pay in number default hr_api.g_number,
2121: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2122: p_to_retention_allowance in number default hr_api.g_number,
2123: p_to_supervisory_differential in number default hr_api.g_number,

Line 2120: p_to_availability_pay in number default hr_api.g_number,

2116: p_to_organization_id in number default hr_api.g_number,
2117: p_to_other_pay_amount in number default hr_api.g_number,
2118: p_to_au_overtime in number default hr_api.g_number,
2119: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2120: p_to_availability_pay in number default hr_api.g_number,
2121: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2122: p_to_retention_allowance in number default hr_api.g_number,
2123: p_to_supervisory_differential in number default hr_api.g_number,
2124: p_to_staffing_differential in number default hr_api.g_number,

Line 2121: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,

2117: p_to_other_pay_amount in number default hr_api.g_number,
2118: p_to_au_overtime in number default hr_api.g_number,
2119: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2120: p_to_availability_pay in number default hr_api.g_number,
2121: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2122: p_to_retention_allowance in number default hr_api.g_number,
2123: p_to_supervisory_differential in number default hr_api.g_number,
2124: p_to_staffing_differential in number default hr_api.g_number,
2125: p_to_pay_basis in varchar2 default hr_api.g_varchar2,

Line 2122: p_to_retention_allowance in number default hr_api.g_number,

2118: p_to_au_overtime in number default hr_api.g_number,
2119: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2120: p_to_availability_pay in number default hr_api.g_number,
2121: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2122: p_to_retention_allowance in number default hr_api.g_number,
2123: p_to_supervisory_differential in number default hr_api.g_number,
2124: p_to_staffing_differential in number default hr_api.g_number,
2125: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
2126: p_to_pay_plan in varchar2 default hr_api.g_varchar2,

Line 2123: p_to_supervisory_differential in number default hr_api.g_number,

2119: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2120: p_to_availability_pay in number default hr_api.g_number,
2121: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2122: p_to_retention_allowance in number default hr_api.g_number,
2123: p_to_supervisory_differential in number default hr_api.g_number,
2124: p_to_staffing_differential in number default hr_api.g_number,
2125: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
2126: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
2127: -- FWFA Changes Bug#4444609

Line 2124: p_to_staffing_differential in number default hr_api.g_number,

2120: p_to_availability_pay in number default hr_api.g_number,
2121: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2122: p_to_retention_allowance in number default hr_api.g_number,
2123: p_to_supervisory_differential in number default hr_api.g_number,
2124: p_to_staffing_differential in number default hr_api.g_number,
2125: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
2126: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
2127: -- FWFA Changes Bug#4444609
2128: p_to_pay_table_identifier in number default hr_api.g_number,

Line 2125: p_to_pay_basis in varchar2 default hr_api.g_varchar2,

2121: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2122: p_to_retention_allowance in number default hr_api.g_number,
2123: p_to_supervisory_differential in number default hr_api.g_number,
2124: p_to_staffing_differential in number default hr_api.g_number,
2125: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
2126: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
2127: -- FWFA Changes Bug#4444609
2128: p_to_pay_table_identifier in number default hr_api.g_number,
2129: -- FWFA Changes

Line 2126: p_to_pay_plan in varchar2 default hr_api.g_varchar2,

2122: p_to_retention_allowance in number default hr_api.g_number,
2123: p_to_supervisory_differential in number default hr_api.g_number,
2124: p_to_staffing_differential in number default hr_api.g_number,
2125: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
2126: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
2127: -- FWFA Changes Bug#4444609
2128: p_to_pay_table_identifier in number default hr_api.g_number,
2129: -- FWFA Changes
2130: p_to_position_id in number default hr_api.g_number,

Line 2128: p_to_pay_table_identifier in number default hr_api.g_number,

2124: p_to_staffing_differential in number default hr_api.g_number,
2125: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
2126: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
2127: -- FWFA Changes Bug#4444609
2128: p_to_pay_table_identifier in number default hr_api.g_number,
2129: -- FWFA Changes
2130: p_to_position_id in number default hr_api.g_number,
2131: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2132: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,

Line 2130: p_to_position_id in number default hr_api.g_number,

2126: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
2127: -- FWFA Changes Bug#4444609
2128: p_to_pay_table_identifier in number default hr_api.g_number,
2129: -- FWFA Changes
2130: p_to_position_id in number default hr_api.g_number,
2131: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2132: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2133: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2134: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,

Line 2131: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,

2127: -- FWFA Changes Bug#4444609
2128: p_to_pay_table_identifier in number default hr_api.g_number,
2129: -- FWFA Changes
2130: p_to_position_id in number default hr_api.g_number,
2131: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2132: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2133: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2134: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2135: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,

Line 2132: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,

2128: p_to_pay_table_identifier in number default hr_api.g_number,
2129: -- FWFA Changes
2130: p_to_position_id in number default hr_api.g_number,
2131: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2132: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2133: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2134: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2135: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2136: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,

Line 2133: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,

2129: -- FWFA Changes
2130: p_to_position_id in number default hr_api.g_number,
2131: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2132: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2133: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2134: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2135: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2136: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2137: p_to_position_number in varchar2 default hr_api.g_varchar2,

Line 2134: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,

2130: p_to_position_id in number default hr_api.g_number,
2131: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2132: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2133: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2134: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2135: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2136: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2137: p_to_position_number in varchar2 default hr_api.g_varchar2,
2138: p_to_position_seq_no in number default hr_api.g_number,

Line 2135: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,

2131: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2132: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2133: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2134: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2135: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2136: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2137: p_to_position_number in varchar2 default hr_api.g_varchar2,
2138: p_to_position_seq_no in number default hr_api.g_number,
2139: p_to_position_title in varchar2 default hr_api.g_varchar2,

Line 2136: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,

2132: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2133: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2134: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2135: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2136: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2137: p_to_position_number in varchar2 default hr_api.g_varchar2,
2138: p_to_position_seq_no in number default hr_api.g_number,
2139: p_to_position_title in varchar2 default hr_api.g_varchar2,
2140: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,

Line 2137: p_to_position_number in varchar2 default hr_api.g_varchar2,

2133: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2134: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2135: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2136: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2137: p_to_position_number in varchar2 default hr_api.g_varchar2,
2138: p_to_position_seq_no in number default hr_api.g_number,
2139: p_to_position_title in varchar2 default hr_api.g_varchar2,
2140: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2141: p_to_total_salary in number default hr_api.g_number,

Line 2138: p_to_position_seq_no in number default hr_api.g_number,

2134: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2135: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2136: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2137: p_to_position_number in varchar2 default hr_api.g_varchar2,
2138: p_to_position_seq_no in number default hr_api.g_number,
2139: p_to_position_title in varchar2 default hr_api.g_varchar2,
2140: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2141: p_to_total_salary in number default hr_api.g_number,
2142: p_veterans_preference in varchar2 default hr_api.g_varchar2,

Line 2139: p_to_position_title in varchar2 default hr_api.g_varchar2,

2135: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2136: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2137: p_to_position_number in varchar2 default hr_api.g_varchar2,
2138: p_to_position_seq_no in number default hr_api.g_number,
2139: p_to_position_title in varchar2 default hr_api.g_varchar2,
2140: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2141: p_to_total_salary in number default hr_api.g_number,
2142: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2143: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,

Line 2140: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,

2136: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2137: p_to_position_number in varchar2 default hr_api.g_varchar2,
2138: p_to_position_seq_no in number default hr_api.g_number,
2139: p_to_position_title in varchar2 default hr_api.g_varchar2,
2140: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2141: p_to_total_salary in number default hr_api.g_number,
2142: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2143: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2144: p_veterans_status in varchar2 default hr_api.g_varchar2,

Line 2141: p_to_total_salary in number default hr_api.g_number,

2137: p_to_position_number in varchar2 default hr_api.g_varchar2,
2138: p_to_position_seq_no in number default hr_api.g_number,
2139: p_to_position_title in varchar2 default hr_api.g_varchar2,
2140: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2141: p_to_total_salary in number default hr_api.g_number,
2142: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2143: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2144: p_veterans_status in varchar2 default hr_api.g_varchar2,
2145: p_work_schedule in varchar2 default hr_api.g_varchar2,

Line 2142: p_veterans_preference in varchar2 default hr_api.g_varchar2,

2138: p_to_position_seq_no in number default hr_api.g_number,
2139: p_to_position_title in varchar2 default hr_api.g_varchar2,
2140: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2141: p_to_total_salary in number default hr_api.g_number,
2142: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2143: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2144: p_veterans_status in varchar2 default hr_api.g_varchar2,
2145: p_work_schedule in varchar2 default hr_api.g_varchar2,
2146: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,

Line 2143: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,

2139: p_to_position_title in varchar2 default hr_api.g_varchar2,
2140: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2141: p_to_total_salary in number default hr_api.g_number,
2142: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2143: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2144: p_veterans_status in varchar2 default hr_api.g_varchar2,
2145: p_work_schedule in varchar2 default hr_api.g_varchar2,
2146: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2147: p_year_degree_attained in number default hr_api.g_number,

Line 2144: p_veterans_status in varchar2 default hr_api.g_varchar2,

2140: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2141: p_to_total_salary in number default hr_api.g_number,
2142: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2143: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2144: p_veterans_status in varchar2 default hr_api.g_varchar2,
2145: p_work_schedule in varchar2 default hr_api.g_varchar2,
2146: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2147: p_year_degree_attained in number default hr_api.g_number,
2148: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,

Line 2145: p_work_schedule in varchar2 default hr_api.g_varchar2,

2141: p_to_total_salary in number default hr_api.g_number,
2142: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2143: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2144: p_veterans_status in varchar2 default hr_api.g_varchar2,
2145: p_work_schedule in varchar2 default hr_api.g_varchar2,
2146: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2147: p_year_degree_attained in number default hr_api.g_number,
2148: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2149: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,

Line 2146: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,

2142: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2143: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2144: p_veterans_status in varchar2 default hr_api.g_varchar2,
2145: p_work_schedule in varchar2 default hr_api.g_varchar2,
2146: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2147: p_year_degree_attained in number default hr_api.g_number,
2148: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2149: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2150: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,

Line 2147: p_year_degree_attained in number default hr_api.g_number,

2143: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2144: p_veterans_status in varchar2 default hr_api.g_varchar2,
2145: p_work_schedule in varchar2 default hr_api.g_varchar2,
2146: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2147: p_year_degree_attained in number default hr_api.g_number,
2148: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2149: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2150: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2151: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,

Line 2148: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,

2144: p_veterans_status in varchar2 default hr_api.g_varchar2,
2145: p_work_schedule in varchar2 default hr_api.g_varchar2,
2146: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2147: p_year_degree_attained in number default hr_api.g_number,
2148: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2149: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2150: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2151: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2152: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,

Line 2149: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,

2145: p_work_schedule in varchar2 default hr_api.g_varchar2,
2146: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2147: p_year_degree_attained in number default hr_api.g_number,
2148: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2149: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2150: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2151: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2152: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2153: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,

Line 2150: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,

2146: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2147: p_year_degree_attained in number default hr_api.g_number,
2148: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2149: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2150: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2151: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2152: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2153: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2154: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,

Line 2151: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,

2147: p_year_degree_attained in number default hr_api.g_number,
2148: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2149: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2150: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2151: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2152: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2153: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2154: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2155: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,

Line 2152: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,

2148: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2149: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2150: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2151: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2152: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2153: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2154: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2155: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2156: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,

Line 2153: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,

2149: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2150: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2151: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2152: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2153: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2154: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2155: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2156: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2157: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,

Line 2154: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,

2150: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2151: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2152: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2153: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2154: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2155: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2156: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2157: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2158: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,

Line 2155: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,

2151: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2152: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2153: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2154: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2155: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2156: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2157: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2158: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2159: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,

Line 2156: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,

2152: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2153: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2154: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2155: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2156: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2157: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2158: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2159: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2160: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,

Line 2157: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,

2153: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2154: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2155: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2156: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2157: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2158: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2159: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2160: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2161: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,

Line 2158: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,

2154: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2155: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2156: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2157: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2158: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2159: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2160: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2161: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2162: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,

Line 2159: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,

2155: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2156: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2157: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2158: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2159: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2160: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2161: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2162: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2163: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,

Line 2160: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,

2156: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2157: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2158: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2159: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2160: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2161: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2162: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2163: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2164: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,

Line 2161: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,

2157: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2158: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2159: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2160: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2161: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2162: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2163: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2164: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2165: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,

Line 2162: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,

2158: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2159: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2160: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2161: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2162: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2163: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2164: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2165: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2166: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,

Line 2163: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,

2159: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2160: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2161: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2162: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2163: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2164: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2165: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2166: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2167: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,

Line 2164: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,

2160: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2161: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2162: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2163: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2164: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2165: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2166: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2167: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2168: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,

Line 2165: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,

2161: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2162: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2163: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2164: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2165: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2166: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2167: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2168: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2169: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,

Line 2166: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,

2162: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2163: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2164: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2165: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2166: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2167: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2168: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2169: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2170: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,

Line 2167: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,

2163: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2164: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2165: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2166: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2167: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2168: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2169: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2170: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2171: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,

Line 2168: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,

2164: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2165: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2166: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2167: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2168: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2169: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2170: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2171: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2172: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,

Line 2169: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,

2165: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2166: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2167: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2168: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2169: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2170: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2171: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2172: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2173: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,

Line 2170: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,

2166: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2167: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2168: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2169: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2170: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2171: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2172: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2173: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2174: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,

Line 2171: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,

2167: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2168: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2169: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2170: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2171: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2172: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2173: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2174: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2175: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,

Line 2172: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,

2168: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2169: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2170: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2171: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2172: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2173: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2174: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2175: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2176: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,

Line 2173: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,

2169: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2170: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2171: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2172: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2173: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2174: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2175: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2176: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2177: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,

Line 2174: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,

2170: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2171: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2172: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2173: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2174: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2175: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2176: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2177: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2178: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 2175: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,

2171: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2172: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2173: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2174: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2175: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2176: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2177: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2178: p_attribute_category in varchar2 default hr_api.g_varchar2,
2179: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 2176: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,

2172: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2173: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2174: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2175: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2176: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2177: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2178: p_attribute_category in varchar2 default hr_api.g_varchar2,
2179: p_attribute1 in varchar2 default hr_api.g_varchar2,
2180: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 2177: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,

2173: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2174: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2175: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2176: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2177: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2178: p_attribute_category in varchar2 default hr_api.g_varchar2,
2179: p_attribute1 in varchar2 default hr_api.g_varchar2,
2180: p_attribute2 in varchar2 default hr_api.g_varchar2,
2181: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 2178: p_attribute_category in varchar2 default hr_api.g_varchar2,

2174: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2175: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2176: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2177: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2178: p_attribute_category in varchar2 default hr_api.g_varchar2,
2179: p_attribute1 in varchar2 default hr_api.g_varchar2,
2180: p_attribute2 in varchar2 default hr_api.g_varchar2,
2181: p_attribute3 in varchar2 default hr_api.g_varchar2,
2182: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 2179: p_attribute1 in varchar2 default hr_api.g_varchar2,

2175: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2176: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2177: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2178: p_attribute_category in varchar2 default hr_api.g_varchar2,
2179: p_attribute1 in varchar2 default hr_api.g_varchar2,
2180: p_attribute2 in varchar2 default hr_api.g_varchar2,
2181: p_attribute3 in varchar2 default hr_api.g_varchar2,
2182: p_attribute4 in varchar2 default hr_api.g_varchar2,
2183: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 2180: p_attribute2 in varchar2 default hr_api.g_varchar2,

2176: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2177: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2178: p_attribute_category in varchar2 default hr_api.g_varchar2,
2179: p_attribute1 in varchar2 default hr_api.g_varchar2,
2180: p_attribute2 in varchar2 default hr_api.g_varchar2,
2181: p_attribute3 in varchar2 default hr_api.g_varchar2,
2182: p_attribute4 in varchar2 default hr_api.g_varchar2,
2183: p_attribute5 in varchar2 default hr_api.g_varchar2,
2184: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 2181: p_attribute3 in varchar2 default hr_api.g_varchar2,

2177: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2178: p_attribute_category in varchar2 default hr_api.g_varchar2,
2179: p_attribute1 in varchar2 default hr_api.g_varchar2,
2180: p_attribute2 in varchar2 default hr_api.g_varchar2,
2181: p_attribute3 in varchar2 default hr_api.g_varchar2,
2182: p_attribute4 in varchar2 default hr_api.g_varchar2,
2183: p_attribute5 in varchar2 default hr_api.g_varchar2,
2184: p_attribute6 in varchar2 default hr_api.g_varchar2,
2185: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 2182: p_attribute4 in varchar2 default hr_api.g_varchar2,

2178: p_attribute_category in varchar2 default hr_api.g_varchar2,
2179: p_attribute1 in varchar2 default hr_api.g_varchar2,
2180: p_attribute2 in varchar2 default hr_api.g_varchar2,
2181: p_attribute3 in varchar2 default hr_api.g_varchar2,
2182: p_attribute4 in varchar2 default hr_api.g_varchar2,
2183: p_attribute5 in varchar2 default hr_api.g_varchar2,
2184: p_attribute6 in varchar2 default hr_api.g_varchar2,
2185: p_attribute7 in varchar2 default hr_api.g_varchar2,
2186: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 2183: p_attribute5 in varchar2 default hr_api.g_varchar2,

2179: p_attribute1 in varchar2 default hr_api.g_varchar2,
2180: p_attribute2 in varchar2 default hr_api.g_varchar2,
2181: p_attribute3 in varchar2 default hr_api.g_varchar2,
2182: p_attribute4 in varchar2 default hr_api.g_varchar2,
2183: p_attribute5 in varchar2 default hr_api.g_varchar2,
2184: p_attribute6 in varchar2 default hr_api.g_varchar2,
2185: p_attribute7 in varchar2 default hr_api.g_varchar2,
2186: p_attribute8 in varchar2 default hr_api.g_varchar2,
2187: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 2184: p_attribute6 in varchar2 default hr_api.g_varchar2,

2180: p_attribute2 in varchar2 default hr_api.g_varchar2,
2181: p_attribute3 in varchar2 default hr_api.g_varchar2,
2182: p_attribute4 in varchar2 default hr_api.g_varchar2,
2183: p_attribute5 in varchar2 default hr_api.g_varchar2,
2184: p_attribute6 in varchar2 default hr_api.g_varchar2,
2185: p_attribute7 in varchar2 default hr_api.g_varchar2,
2186: p_attribute8 in varchar2 default hr_api.g_varchar2,
2187: p_attribute9 in varchar2 default hr_api.g_varchar2,
2188: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 2185: p_attribute7 in varchar2 default hr_api.g_varchar2,

2181: p_attribute3 in varchar2 default hr_api.g_varchar2,
2182: p_attribute4 in varchar2 default hr_api.g_varchar2,
2183: p_attribute5 in varchar2 default hr_api.g_varchar2,
2184: p_attribute6 in varchar2 default hr_api.g_varchar2,
2185: p_attribute7 in varchar2 default hr_api.g_varchar2,
2186: p_attribute8 in varchar2 default hr_api.g_varchar2,
2187: p_attribute9 in varchar2 default hr_api.g_varchar2,
2188: p_attribute10 in varchar2 default hr_api.g_varchar2,
2189: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 2186: p_attribute8 in varchar2 default hr_api.g_varchar2,

2182: p_attribute4 in varchar2 default hr_api.g_varchar2,
2183: p_attribute5 in varchar2 default hr_api.g_varchar2,
2184: p_attribute6 in varchar2 default hr_api.g_varchar2,
2185: p_attribute7 in varchar2 default hr_api.g_varchar2,
2186: p_attribute8 in varchar2 default hr_api.g_varchar2,
2187: p_attribute9 in varchar2 default hr_api.g_varchar2,
2188: p_attribute10 in varchar2 default hr_api.g_varchar2,
2189: p_attribute11 in varchar2 default hr_api.g_varchar2,
2190: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 2187: p_attribute9 in varchar2 default hr_api.g_varchar2,

2183: p_attribute5 in varchar2 default hr_api.g_varchar2,
2184: p_attribute6 in varchar2 default hr_api.g_varchar2,
2185: p_attribute7 in varchar2 default hr_api.g_varchar2,
2186: p_attribute8 in varchar2 default hr_api.g_varchar2,
2187: p_attribute9 in varchar2 default hr_api.g_varchar2,
2188: p_attribute10 in varchar2 default hr_api.g_varchar2,
2189: p_attribute11 in varchar2 default hr_api.g_varchar2,
2190: p_attribute12 in varchar2 default hr_api.g_varchar2,
2191: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 2188: p_attribute10 in varchar2 default hr_api.g_varchar2,

2184: p_attribute6 in varchar2 default hr_api.g_varchar2,
2185: p_attribute7 in varchar2 default hr_api.g_varchar2,
2186: p_attribute8 in varchar2 default hr_api.g_varchar2,
2187: p_attribute9 in varchar2 default hr_api.g_varchar2,
2188: p_attribute10 in varchar2 default hr_api.g_varchar2,
2189: p_attribute11 in varchar2 default hr_api.g_varchar2,
2190: p_attribute12 in varchar2 default hr_api.g_varchar2,
2191: p_attribute13 in varchar2 default hr_api.g_varchar2,
2192: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 2189: p_attribute11 in varchar2 default hr_api.g_varchar2,

2185: p_attribute7 in varchar2 default hr_api.g_varchar2,
2186: p_attribute8 in varchar2 default hr_api.g_varchar2,
2187: p_attribute9 in varchar2 default hr_api.g_varchar2,
2188: p_attribute10 in varchar2 default hr_api.g_varchar2,
2189: p_attribute11 in varchar2 default hr_api.g_varchar2,
2190: p_attribute12 in varchar2 default hr_api.g_varchar2,
2191: p_attribute13 in varchar2 default hr_api.g_varchar2,
2192: p_attribute14 in varchar2 default hr_api.g_varchar2,
2193: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 2190: p_attribute12 in varchar2 default hr_api.g_varchar2,

2186: p_attribute8 in varchar2 default hr_api.g_varchar2,
2187: p_attribute9 in varchar2 default hr_api.g_varchar2,
2188: p_attribute10 in varchar2 default hr_api.g_varchar2,
2189: p_attribute11 in varchar2 default hr_api.g_varchar2,
2190: p_attribute12 in varchar2 default hr_api.g_varchar2,
2191: p_attribute13 in varchar2 default hr_api.g_varchar2,
2192: p_attribute14 in varchar2 default hr_api.g_varchar2,
2193: p_attribute15 in varchar2 default hr_api.g_varchar2,
2194: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 2191: p_attribute13 in varchar2 default hr_api.g_varchar2,

2187: p_attribute9 in varchar2 default hr_api.g_varchar2,
2188: p_attribute10 in varchar2 default hr_api.g_varchar2,
2189: p_attribute11 in varchar2 default hr_api.g_varchar2,
2190: p_attribute12 in varchar2 default hr_api.g_varchar2,
2191: p_attribute13 in varchar2 default hr_api.g_varchar2,
2192: p_attribute14 in varchar2 default hr_api.g_varchar2,
2193: p_attribute15 in varchar2 default hr_api.g_varchar2,
2194: p_attribute16 in varchar2 default hr_api.g_varchar2,
2195: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 2192: p_attribute14 in varchar2 default hr_api.g_varchar2,

2188: p_attribute10 in varchar2 default hr_api.g_varchar2,
2189: p_attribute11 in varchar2 default hr_api.g_varchar2,
2190: p_attribute12 in varchar2 default hr_api.g_varchar2,
2191: p_attribute13 in varchar2 default hr_api.g_varchar2,
2192: p_attribute14 in varchar2 default hr_api.g_varchar2,
2193: p_attribute15 in varchar2 default hr_api.g_varchar2,
2194: p_attribute16 in varchar2 default hr_api.g_varchar2,
2195: p_attribute17 in varchar2 default hr_api.g_varchar2,
2196: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 2193: p_attribute15 in varchar2 default hr_api.g_varchar2,

2189: p_attribute11 in varchar2 default hr_api.g_varchar2,
2190: p_attribute12 in varchar2 default hr_api.g_varchar2,
2191: p_attribute13 in varchar2 default hr_api.g_varchar2,
2192: p_attribute14 in varchar2 default hr_api.g_varchar2,
2193: p_attribute15 in varchar2 default hr_api.g_varchar2,
2194: p_attribute16 in varchar2 default hr_api.g_varchar2,
2195: p_attribute17 in varchar2 default hr_api.g_varchar2,
2196: p_attribute18 in varchar2 default hr_api.g_varchar2,
2197: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 2194: p_attribute16 in varchar2 default hr_api.g_varchar2,

2190: p_attribute12 in varchar2 default hr_api.g_varchar2,
2191: p_attribute13 in varchar2 default hr_api.g_varchar2,
2192: p_attribute14 in varchar2 default hr_api.g_varchar2,
2193: p_attribute15 in varchar2 default hr_api.g_varchar2,
2194: p_attribute16 in varchar2 default hr_api.g_varchar2,
2195: p_attribute17 in varchar2 default hr_api.g_varchar2,
2196: p_attribute18 in varchar2 default hr_api.g_varchar2,
2197: p_attribute19 in varchar2 default hr_api.g_varchar2,
2198: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 2195: p_attribute17 in varchar2 default hr_api.g_varchar2,

2191: p_attribute13 in varchar2 default hr_api.g_varchar2,
2192: p_attribute14 in varchar2 default hr_api.g_varchar2,
2193: p_attribute15 in varchar2 default hr_api.g_varchar2,
2194: p_attribute16 in varchar2 default hr_api.g_varchar2,
2195: p_attribute17 in varchar2 default hr_api.g_varchar2,
2196: p_attribute18 in varchar2 default hr_api.g_varchar2,
2197: p_attribute19 in varchar2 default hr_api.g_varchar2,
2198: p_attribute20 in varchar2 default hr_api.g_varchar2,
2199: p_print_sf50_flag in varchar2 default 'N',

Line 2196: p_attribute18 in varchar2 default hr_api.g_varchar2,

2192: p_attribute14 in varchar2 default hr_api.g_varchar2,
2193: p_attribute15 in varchar2 default hr_api.g_varchar2,
2194: p_attribute16 in varchar2 default hr_api.g_varchar2,
2195: p_attribute17 in varchar2 default hr_api.g_varchar2,
2196: p_attribute18 in varchar2 default hr_api.g_varchar2,
2197: p_attribute19 in varchar2 default hr_api.g_varchar2,
2198: p_attribute20 in varchar2 default hr_api.g_varchar2,
2199: p_print_sf50_flag in varchar2 default 'N',
2200: p_printer_name in varchar2 default null,

Line 2197: p_attribute19 in varchar2 default hr_api.g_varchar2,

2193: p_attribute15 in varchar2 default hr_api.g_varchar2,
2194: p_attribute16 in varchar2 default hr_api.g_varchar2,
2195: p_attribute17 in varchar2 default hr_api.g_varchar2,
2196: p_attribute18 in varchar2 default hr_api.g_varchar2,
2197: p_attribute19 in varchar2 default hr_api.g_varchar2,
2198: p_attribute20 in varchar2 default hr_api.g_varchar2,
2199: p_print_sf50_flag in varchar2 default 'N',
2200: p_printer_name in varchar2 default null,
2201: p_print_back_page in varchar2 default 'Y',

Line 2198: p_attribute20 in varchar2 default hr_api.g_varchar2,

2194: p_attribute16 in varchar2 default hr_api.g_varchar2,
2195: p_attribute17 in varchar2 default hr_api.g_varchar2,
2196: p_attribute18 in varchar2 default hr_api.g_varchar2,
2197: p_attribute19 in varchar2 default hr_api.g_varchar2,
2198: p_attribute20 in varchar2 default hr_api.g_varchar2,
2199: p_print_sf50_flag in varchar2 default 'N',
2200: p_printer_name in varchar2 default null,
2201: p_print_back_page in varchar2 default 'Y',
2202: p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,

Line 2202: p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,

2198: p_attribute20 in varchar2 default hr_api.g_varchar2,
2199: p_print_sf50_flag in varchar2 default 'N',
2200: p_printer_name in varchar2 default null,
2201: p_print_back_page in varchar2 default 'Y',
2202: p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
2203: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
2204: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
2205: p_u_action_taken in varchar2 default null,
2206: p_u_approval_status in varchar2 default hr_api.g_varchar2,

Line 2203: p_u_approved_flag in varchar2 default hr_api.g_varchar2,

2199: p_print_sf50_flag in varchar2 default 'N',
2200: p_printer_name in varchar2 default null,
2201: p_print_back_page in varchar2 default 'Y',
2202: p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
2203: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
2204: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
2205: p_u_action_taken in varchar2 default null,
2206: p_u_approval_status in varchar2 default hr_api.g_varchar2,
2207: p_i_user_name_routed_to in varchar2 default null,

Line 2204: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,

2200: p_printer_name in varchar2 default null,
2201: p_print_back_page in varchar2 default 'Y',
2202: p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
2203: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
2204: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
2205: p_u_action_taken in varchar2 default null,
2206: p_u_approval_status in varchar2 default hr_api.g_varchar2,
2207: p_i_user_name_routed_to in varchar2 default null,
2208: p_i_groupbox_id in number default null,

Line 2206: p_u_approval_status in varchar2 default hr_api.g_varchar2,

2202: p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
2203: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
2204: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
2205: p_u_action_taken in varchar2 default null,
2206: p_u_approval_status in varchar2 default hr_api.g_varchar2,
2207: p_i_user_name_routed_to in varchar2 default null,
2208: p_i_groupbox_id in number default null,
2209: p_i_routing_list_id in number default null,
2210: p_i_routing_seq_number in number default null,

Line 2212: p_to_retention_allow_percentag in number default hr_api.g_number,

2208: p_i_groupbox_id in number default null,
2209: p_i_routing_list_id in number default null,
2210: p_i_routing_seq_number in number default null,
2211: p_capped_other_pay in number default null,
2212: p_to_retention_allow_percentag in number default hr_api.g_number,
2213: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2214: p_to_staffing_diff_percentage in number default hr_api.g_number,
2215: p_award_percentage in number default hr_api.g_number,
2216: p_rpa_type in varchar2 default hr_api.g_varchar2,

Line 2213: p_to_supervisory_diff_percenta in number default hr_api.g_number,

2209: p_i_routing_list_id in number default null,
2210: p_i_routing_seq_number in number default null,
2211: p_capped_other_pay in number default null,
2212: p_to_retention_allow_percentag in number default hr_api.g_number,
2213: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2214: p_to_staffing_diff_percentage in number default hr_api.g_number,
2215: p_award_percentage in number default hr_api.g_number,
2216: p_rpa_type in varchar2 default hr_api.g_varchar2,
2217: p_mass_action_id in number default hr_api.g_number,

Line 2214: p_to_staffing_diff_percentage in number default hr_api.g_number,

2210: p_i_routing_seq_number in number default null,
2211: p_capped_other_pay in number default null,
2212: p_to_retention_allow_percentag in number default hr_api.g_number,
2213: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2214: p_to_staffing_diff_percentage in number default hr_api.g_number,
2215: p_award_percentage in number default hr_api.g_number,
2216: p_rpa_type in varchar2 default hr_api.g_varchar2,
2217: p_mass_action_id in number default hr_api.g_number,
2218: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,

Line 2215: p_award_percentage in number default hr_api.g_number,

2211: p_capped_other_pay in number default null,
2212: p_to_retention_allow_percentag in number default hr_api.g_number,
2213: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2214: p_to_staffing_diff_percentage in number default hr_api.g_number,
2215: p_award_percentage in number default hr_api.g_number,
2216: p_rpa_type in varchar2 default hr_api.g_varchar2,
2217: p_mass_action_id in number default hr_api.g_number,
2218: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2219: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,

Line 2216: p_rpa_type in varchar2 default hr_api.g_varchar2,

2212: p_to_retention_allow_percentag in number default hr_api.g_number,
2213: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2214: p_to_staffing_diff_percentage in number default hr_api.g_number,
2215: p_award_percentage in number default hr_api.g_number,
2216: p_rpa_type in varchar2 default hr_api.g_varchar2,
2217: p_mass_action_id in number default hr_api.g_number,
2218: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2219: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2220: p_mass_action_comments in varchar2 default hr_api.g_varchar2,

Line 2217: p_mass_action_id in number default hr_api.g_number,

2213: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2214: p_to_staffing_diff_percentage in number default hr_api.g_number,
2215: p_award_percentage in number default hr_api.g_number,
2216: p_rpa_type in varchar2 default hr_api.g_varchar2,
2217: p_mass_action_id in number default hr_api.g_number,
2218: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2219: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2220: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2221: -- Bug#4486823 RRR Changes

Line 2218: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,

2214: p_to_staffing_diff_percentage in number default hr_api.g_number,
2215: p_award_percentage in number default hr_api.g_number,
2216: p_rpa_type in varchar2 default hr_api.g_varchar2,
2217: p_mass_action_id in number default hr_api.g_number,
2218: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2219: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2220: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2221: -- Bug#4486823 RRR Changes
2222: p_payment_option in varchar2 default null,

Line 2219: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,

2215: p_award_percentage in number default hr_api.g_number,
2216: p_rpa_type in varchar2 default hr_api.g_varchar2,
2217: p_mass_action_id in number default hr_api.g_number,
2218: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2219: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2220: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2221: -- Bug#4486823 RRR Changes
2222: p_payment_option in varchar2 default null,
2223: p_award_salary in number default hr_api.g_number,

Line 2220: p_mass_action_comments in varchar2 default hr_api.g_varchar2,

2216: p_rpa_type in varchar2 default hr_api.g_varchar2,
2217: p_mass_action_id in number default hr_api.g_number,
2218: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2219: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2220: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2221: -- Bug#4486823 RRR Changes
2222: p_payment_option in varchar2 default null,
2223: p_award_salary in number default hr_api.g_number,
2224: -- Bug#4486823 RRR Changes

Line 2223: p_award_salary in number default hr_api.g_number,

2219: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2220: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2221: -- Bug#4486823 RRR Changes
2222: p_payment_option in varchar2 default null,
2223: p_award_salary in number default hr_api.g_number,
2224: -- Bug#4486823 RRR Changes
2225: p_u_prh_object_version_number out nocopy number,
2226: p_i_pa_routing_history_id out nocopy number,
2227: p_i_prh_object_version_number out nocopy number

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 2746: when hr_api.cannot_find_prog_unit then

2742: p_mass_action_select_flag => p_mass_action_select_flag,
2743: p_mass_action_comments => p_mass_action_comments
2744: );
2745: exception
2746: when hr_api.cannot_find_prog_unit then
2747: hr_api.cannot_find_prog_unit_error
2748: (p_module_name => 'update_sf52',
2749: p_hook_type => 'BP'
2750: );

Line 2747: hr_api.cannot_find_prog_unit_error

2743: p_mass_action_comments => p_mass_action_comments
2744: );
2745: exception
2746: when hr_api.cannot_find_prog_unit then
2747: hr_api.cannot_find_prog_unit_error
2748: (p_module_name => 'update_sf52',
2749: p_hook_type => 'BP'
2750: );
2751: end;

Line 2762: If nvl(p_person_id,hr_api.g_number) <> hr_api.g_number then

2758: -- Validation in addition to Row Handlers
2759:
2760: -- If the SF52 is processed for the person same as the user, then do not allow creation
2761:
2762: If nvl(p_person_id,hr_api.g_number) <> hr_api.g_number then
2763: -- get employee_id of the user
2764: for user_id in c_names loop
2765: If user_id.employee_id = p_person_id then
2766: hr_utility.set_message(8301,'GHR_38503_CANNOT_INIT_FOR_SELF');

Line 2777: if p_routing_group_id is not null and p_routing_group_id <> hr_api.g_number then

2773: -- Routing Group _Id can be changed only in a case where the request has been initiated
2774: -- but not yet routed , for instance when the user uses the task flow button to
2775: -- naviage to another form and when he comes back he can change the routing_grouip_id
2776:
2777: if p_routing_group_id is not null and p_routing_group_id <> hr_api.g_number then
2778: for rout_group_id in c_routing_group_id loop
2779: l_routing_group_id := rout_group_id.routing_group_id;
2780: end loop;
2781: if nvl(l_routing_group_id,hr_api.g_number) <> p_routing_group_id then

Line 2781: if nvl(l_routing_group_id,hr_api.g_number) <> p_routing_group_id then

2777: if p_routing_group_id is not null and p_routing_group_id <> hr_api.g_number then
2778: for rout_group_id in c_routing_group_id loop
2779: l_routing_group_id := rout_group_id.routing_group_id;
2780: end loop;
2781: if nvl(l_routing_group_id,hr_api.g_number) <> p_routing_group_id then
2782: for cnt_of_history in c_cnt_history loop
2783: l_cnt_history := cnt_of_history.cnt;
2784: exit;
2785: end loop;

Line 2800: If nvl(p_u_approval_status,hr_api.g_varchar2) = 'APPROVE' then

2796: l_approving_official_work_titl := p_approving_official_work_titl;
2797: l_approving_official_full_name := p_approving_official_full_name;
2798:
2799: hr_utility.set_location('approval_stat ' || p_u_approval_Status,1);
2800: If nvl(p_u_approval_status,hr_api.g_varchar2) = 'APPROVE' then
2801: If p_approval_date is null or p_approval_date = hr_api.g_date
2802: then
2803: hr_utility.set_location('approval date is not null',1);
2804: l_effective_date := trunc(sysdate);

Line 2801: If p_approval_date is null or p_approval_date = hr_api.g_date

2797: l_approving_official_full_name := p_approving_official_full_name;
2798:
2799: hr_utility.set_location('approval_stat ' || p_u_approval_Status,1);
2800: If nvl(p_u_approval_status,hr_api.g_varchar2) = 'APPROVE' then
2801: If p_approval_date is null or p_approval_date = hr_api.g_date
2802: then
2803: hr_utility.set_location('approval date is not null',1);
2804: l_effective_date := trunc(sysdate);
2805: l_approval_date := sysdate;

Line 2838: l_sf50_approval_date := hr_api.g_date;

2834: -- the following the lines are for bug 715020. This is to ensure that we don't update the
2835: -- sf50 approval fields to null. Previously, the local versions of these variables would never
2836: -- have been initialized unless the action_taken was ('UPDATE_HR','FUTURE_ACTION')
2837: -- (see code immediately following.
2838: l_sf50_approval_date := hr_api.g_date;
2839: l_sf50_approving_ofcl_work_tit := hr_api.g_varchar2;
2840: l_sf50_approving_ofcl_full_nam := hr_api.g_varchar2;
2841:
2842: If nvl(p_u_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then

Line 2839: l_sf50_approving_ofcl_work_tit := hr_api.g_varchar2;

2835: -- sf50 approval fields to null. Previously, the local versions of these variables would never
2836: -- have been initialized unless the action_taken was ('UPDATE_HR','FUTURE_ACTION')
2837: -- (see code immediately following.
2838: l_sf50_approval_date := hr_api.g_date;
2839: l_sf50_approving_ofcl_work_tit := hr_api.g_varchar2;
2840: l_sf50_approving_ofcl_full_nam := hr_api.g_varchar2;
2841:
2842: If nvl(p_u_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then
2843: If p_approval_date is not null and p_approval_date <> hr_api.g_date then

Line 2840: l_sf50_approving_ofcl_full_nam := hr_api.g_varchar2;

2836: -- have been initialized unless the action_taken was ('UPDATE_HR','FUTURE_ACTION')
2837: -- (see code immediately following.
2838: l_sf50_approval_date := hr_api.g_date;
2839: l_sf50_approving_ofcl_work_tit := hr_api.g_varchar2;
2840: l_sf50_approving_ofcl_full_nam := hr_api.g_varchar2;
2841:
2842: If nvl(p_u_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then
2843: If p_approval_date is not null and p_approval_date <> hr_api.g_date then
2844: l_sf50_approval_date := p_approval_date;

Line 2842: If nvl(p_u_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then

2838: l_sf50_approval_date := hr_api.g_date;
2839: l_sf50_approving_ofcl_work_tit := hr_api.g_varchar2;
2840: l_sf50_approving_ofcl_full_nam := hr_api.g_varchar2;
2841:
2842: If nvl(p_u_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then
2843: If p_approval_date is not null and p_approval_date <> hr_api.g_date then
2844: l_sf50_approval_date := p_approval_date;
2845: l_sf50_approving_ofcl_work_tit := p_approving_official_work_titl;
2846: l_sf50_approving_ofcl_full_nam := p_approving_official_full_name;

Line 2843: If p_approval_date is not null and p_approval_date <> hr_api.g_date then

2839: l_sf50_approving_ofcl_work_tit := hr_api.g_varchar2;
2840: l_sf50_approving_ofcl_full_nam := hr_api.g_varchar2;
2841:
2842: If nvl(p_u_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then
2843: If p_approval_date is not null and p_approval_date <> hr_api.g_date then
2844: l_sf50_approval_date := p_approval_date;
2845: l_sf50_approving_ofcl_work_tit := p_approving_official_work_titl;
2846: l_sf50_approving_ofcl_full_nam := p_approving_official_full_name;
2847: Else

Line 3130: if nvl(p_first_noa_id,hr_api.g_number)

3126: -- in case of either a) first_nature_of_action is input for the first_time or (just insert new recds)
3127: -- b) first nature_of_action has changed (delete and then insert new records)
3128: --
3129:
3130: if nvl(p_first_noa_id,hr_api.g_number)
3131: <> nvl(ghr_par_shd.g_old_rec.first_noa_id,hr_api.g_number) then
3132: hr_utility.set_location(l_proc, 9);
3133:
3134: -- delete the existing remarks

Line 3131: <> nvl(ghr_par_shd.g_old_rec.first_noa_id,hr_api.g_number) then

3127: -- b) first nature_of_action has changed (delete and then insert new records)
3128: --
3129:
3130: if nvl(p_first_noa_id,hr_api.g_number)
3131: <> nvl(ghr_par_shd.g_old_rec.first_noa_id,hr_api.g_number) then
3132: hr_utility.set_location(l_proc, 9);
3133:
3134: -- delete the existing remarks
3135: delete from ghr_pa_remarks pre

Line 3171: if nvl(p_second_noa_id,hr_api.g_number)

3167: -- and nvl(rem.date_to,l_effective_date));
3168: end if;
3169: end if;
3170:
3171: if nvl(p_second_noa_id,hr_api.g_number)
3172: <> nvl(ghr_par_shd.g_old_rec.second_noa_id,hr_api.g_number) then
3173:
3174: -- delete the existing remarks
3175: delete from ghr_pa_remarks pre

Line 3172: <> nvl(ghr_par_shd.g_old_rec.second_noa_id,hr_api.g_number) then

3168: end if;
3169: end if;
3170:
3171: if nvl(p_second_noa_id,hr_api.g_number)
3172: <> nvl(ghr_par_shd.g_old_rec.second_noa_id,hr_api.g_number) then
3173:
3174: -- delete the existing remarks
3175: delete from ghr_pa_remarks pre
3176: where pre.pa_request_id = p_pa_request_id

Line 3230: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'

3226: Begin
3227: ----Bug #6127620 */
3228:
3229:
3230: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
3231: then
3232:
3233: If p_first_noa_id = hr_api.g_number then
3234: l_rec.first_noa_id := ghr_par_shd.g_old_rec.first_noa_id;

Line 3233: If p_first_noa_id = hr_api.g_number then

3229:
3230: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
3231: then
3232:
3233: If p_first_noa_id = hr_api.g_number then
3234: l_rec.first_noa_id := ghr_par_shd.g_old_rec.first_noa_id;
3235: Else
3236: l_rec.first_noa_id := p_first_noa_id;
3237: End if;

Line 3239: If p_second_noa_id = hr_api.g_number then

3235: Else
3236: l_rec.first_noa_id := p_first_noa_id;
3237: End if;
3238:
3239: If p_second_noa_id = hr_api.g_number then
3240: l_rec.second_noa_id := ghr_par_shd.g_old_rec.second_noa_id;
3241: Else
3242: l_rec.second_noa_id := p_second_noa_id;
3243: End if;

Line 3245: If p_effective_date = hr_api.g_date then

3241: Else
3242: l_rec.second_noa_id := p_second_noa_id;
3243: End if;
3244:
3245: If p_effective_date = hr_api.g_date then
3246: l_rec.effective_date := ghr_par_shd.g_old_rec.effective_date;
3247: Else
3248: l_rec.effective_date := p_effective_date;
3249: End if;

Line 3251: If p_person_id = hr_api.g_number then

3247: Else
3248: l_rec.effective_date := p_effective_date;
3249: End if;
3250:
3251: If p_person_id = hr_api.g_number then
3252: l_rec.person_id := ghr_par_shd.g_old_rec.person_id;
3253: Else
3254: l_rec.person_id := p_person_id;
3255: End if;

Line 3257: If p_employee_assignment_id = hr_api.g_number then

3253: Else
3254: l_rec.person_id := p_person_id;
3255: End if;
3256:
3257: If p_employee_assignment_id = hr_api.g_number then
3258: l_rec.employee_assignment_id := ghr_par_shd.g_old_rec.employee_assignment_id;
3259: Else
3260: l_rec.employee_assignment_id := p_employee_assignment_id;
3261: End if;

Line 3263: If p_to_position_id = hr_api.g_number then

3259: Else
3260: l_rec.employee_assignment_id := p_employee_assignment_id;
3261: End if;
3262:
3263: If p_to_position_id = hr_api.g_number then
3264: l_rec.to_position_id := ghr_par_shd.g_old_rec.to_position_id;
3265: Else
3266: l_rec.to_position_id := p_to_position_id;
3267: End if;

Line 3272: If nvl(l_rpa_type,'##') = hr_api.g_varchar2 then

3268:
3269: if p_u_action_taken = 'NOT_ROUTED' then
3270: l_rpa_type := p_rpa_type;
3271: l_mass_action_id := p_mass_action_id;
3272: If nvl(l_rpa_type,'##') = hr_api.g_varchar2 then
3273: l_rpa_type := ghr_par_shd.g_old_rec.rpa_type;
3274: End if;
3275: If nvl(l_mass_action_id,-9999) = hr_api.g_number then
3276: l_mass_action_id := ghr_par_shd.g_old_rec.mass_action_id;

Line 3275: If nvl(l_mass_action_id,-9999) = hr_api.g_number then

3271: l_mass_action_id := p_mass_action_id;
3272: If nvl(l_rpa_type,'##') = hr_api.g_varchar2 then
3273: l_rpa_type := ghr_par_shd.g_old_rec.rpa_type;
3274: End if;
3275: If nvl(l_mass_action_id,-9999) = hr_api.g_number then
3276: l_mass_action_id := ghr_par_shd.g_old_rec.mass_action_id;
3277: End if;
3278: End if;
3279:

Line 3280: If (nvl(p_effective_date,hr_api.g_date)

3276: l_mass_action_id := ghr_par_shd.g_old_rec.mass_action_id;
3277: End if;
3278: End if;
3279:
3280: If (nvl(p_effective_date,hr_api.g_date)
3281: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3282: (nvl(p_person_id,hr_api.g_number)
3283: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3284: or (p_noa_family_code = 'APP') or

Line 3281: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or

3277: End if;
3278: End if;
3279:
3280: If (nvl(p_effective_date,hr_api.g_date)
3281: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3282: (nvl(p_person_id,hr_api.g_number)
3283: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3284: or (p_noa_family_code = 'APP') or
3285: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then

Line 3282: (nvl(p_person_id,hr_api.g_number)

3278: End if;
3279:
3280: If (nvl(p_effective_date,hr_api.g_date)
3281: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3282: (nvl(p_person_id,hr_api.g_number)
3283: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3284: or (p_noa_family_code = 'APP') or
3285: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then
3286:

Line 3283: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))

3279:
3280: If (nvl(p_effective_date,hr_api.g_date)
3281: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3282: (nvl(p_person_id,hr_api.g_number)
3283: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3284: or (p_noa_family_code = 'APP') or
3285: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then
3286:
3287: GHR_NON_SF52_EXTRA_INFO.fetch_generic_extra_info

Line 3285: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then

3281: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3282: (nvl(p_person_id,hr_api.g_number)
3283: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3284: or (p_noa_family_code = 'APP') or
3285: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then
3286:
3287: GHR_NON_SF52_EXTRA_INFO.fetch_generic_extra_info
3288: (p_pa_request_id => p_pa_request_id,
3289: p_person_id => l_rec.person_id,

Line 3297: if (nvl(p_first_noa_code,hr_api.g_varchar2)

3293: );
3294: End if;
3295:
3296:
3297: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3298: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3299: (nvl(p_second_noa_code,hr_api.g_varchar2)
3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3301: (nvl(p_effective_date,hr_api.g_date)

Line 3298: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or

3294: End if;
3295:
3296:
3297: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3298: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3299: (nvl(p_second_noa_code,hr_api.g_varchar2)
3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3301: (nvl(p_effective_date,hr_api.g_date)
3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or

Line 3299: (nvl(p_second_noa_code,hr_api.g_varchar2)

3295:
3296:
3297: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3298: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3299: (nvl(p_second_noa_code,hr_api.g_varchar2)
3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3301: (nvl(p_effective_date,hr_api.g_date)
3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3303: (nvl(p_person_id,hr_api.g_number)

Line 3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or

3296:
3297: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3298: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3299: (nvl(p_second_noa_code,hr_api.g_varchar2)
3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3301: (nvl(p_effective_date,hr_api.g_date)
3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3303: (nvl(p_person_id,hr_api.g_number)
3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or

Line 3301: (nvl(p_effective_date,hr_api.g_date)

3297: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3298: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3299: (nvl(p_second_noa_code,hr_api.g_varchar2)
3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3301: (nvl(p_effective_date,hr_api.g_date)
3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3303: (nvl(p_person_id,hr_api.g_number)
3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3305: (nvl(p_to_position_id,hr_api.g_number)

Line 3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or

3298: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3299: (nvl(p_second_noa_code,hr_api.g_varchar2)
3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3301: (nvl(p_effective_date,hr_api.g_date)
3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3303: (nvl(p_person_id,hr_api.g_number)
3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3305: (nvl(p_to_position_id,hr_api.g_number)
3306: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))

Line 3303: (nvl(p_person_id,hr_api.g_number)

3299: (nvl(p_second_noa_code,hr_api.g_varchar2)
3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3301: (nvl(p_effective_date,hr_api.g_date)
3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3303: (nvl(p_person_id,hr_api.g_number)
3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3305: (nvl(p_to_position_id,hr_api.g_number)
3306: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3307: then

Line 3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or

3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3301: (nvl(p_effective_date,hr_api.g_date)
3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3303: (nvl(p_person_id,hr_api.g_number)
3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3305: (nvl(p_to_position_id,hr_api.g_number)
3306: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3307: then
3308: hr_utility.set_location('update/ delete extra info',1);

Line 3305: (nvl(p_to_position_id,hr_api.g_number)

3301: (nvl(p_effective_date,hr_api.g_date)
3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3303: (nvl(p_person_id,hr_api.g_number)
3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3305: (nvl(p_to_position_id,hr_api.g_number)
3306: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3307: then
3308: hr_utility.set_location('update/ delete extra info',1);
3309:

Line 3306: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))

3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3303: (nvl(p_person_id,hr_api.g_number)
3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3305: (nvl(p_to_position_id,hr_api.g_number)
3306: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3307: then
3308: hr_utility.set_location('update/ delete extra info',1);
3309:
3310:

Line 3347: if nvl(p_authorized_by_person_id,hr_api.g_number) <>

3343:
3344: l_action_taken := p_u_action_taken;
3345: hr_utility.set_location(l_proc, 11);
3346: if l_action_taken is null then
3347: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3348: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3349: l_action_taken := 'AUTHORIZED';
3350: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
3351: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then

Line 3348: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then

3344: l_action_taken := p_u_action_taken;
3345: hr_utility.set_location(l_proc, 11);
3346: if l_action_taken is null then
3347: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3348: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3349: l_action_taken := 'AUTHORIZED';
3350: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
3351: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
3352: l_action_taken := 'REQUESTED';

Line 3350: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>

3346: if l_action_taken is null then
3347: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3348: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3349: l_action_taken := 'AUTHORIZED';
3350: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
3351: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
3352: l_action_taken := 'REQUESTED';
3353: else
3354: for history_exists in C_history_exists loop

Line 3351: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then

3347: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3348: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3349: l_action_taken := 'AUTHORIZED';
3350: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
3351: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
3352: l_action_taken := 'REQUESTED';
3353: else
3354: for history_exists in C_history_exists loop
3355: l_exists := true;

Line 3419: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','UPDATE_HR_COMPLETE','NONE','ENDED')then

3415: hr_utility.raise_error;
3416: end if;
3417: end if;
3418:
3419: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','UPDATE_HR_COMPLETE','NONE','ENDED')then
3420: hr_utility.set_location('check ' ||l_action_taken,1);
3421: hr_utility.set_location('check ' ||l_mass_action_id,1);
3422: hr_utility.set_location('Check ' || l_rpa_type,1);
3423: -- Do not routing history if Template record for Mass Actions.

Line 3426: -- and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA') or --AVR

3422: hr_utility.set_location('Check ' || l_rpa_type,1);
3423: -- Do not routing history if Template record for Mass Actions.
3424:
3425: -- If (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is not null --AVR
3426: -- and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA') or --AVR
3427: -- (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null) then --AVR
3428:
3429: if nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' then --AVR
3430: if (nvl(l_rpa_type,hr_api.g_varchar2) = 'A' and l_action_taken = 'NOT_ROUTED' ) then --AVR

Line 3429: if nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' then --AVR

3425: -- If (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is not null --AVR
3426: -- and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA') or --AVR
3427: -- (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null) then --AVR
3428:
3429: if nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' then --AVR
3430: if (nvl(l_rpa_type,hr_api.g_varchar2) = 'A' and l_action_taken = 'NOT_ROUTED' ) then --AVR
3431: hr_utility.set_location('Form Folder Updation ..Do not route ' ,1); --AVR
3432: else --AVR
3433:

Line 3430: if (nvl(l_rpa_type,hr_api.g_varchar2) = 'A' and l_action_taken = 'NOT_ROUTED' ) then --AVR

3426: -- and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA') or --AVR
3427: -- (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null) then --AVR
3428:
3429: if nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' then --AVR
3430: if (nvl(l_rpa_type,hr_api.g_varchar2) = 'A' and l_action_taken = 'NOT_ROUTED' ) then --AVR
3431: hr_utility.set_location('Form Folder Updation ..Do not route ' ,1); --AVR
3432: else --AVR
3433:
3434: for cur_routing_history_id in C_routing_history_id loop

Line 3442: and p_u_user_name_acted_on <> hr_api.g_varchar2 then

3438: end loop;
3439: hr_utility.set_location('in update sf52 api , user acted on is ' || p_u_user_name_acted_on,1);
3440: if p_u_user_name_acted_on is not null
3441: -- RP
3442: and p_u_user_name_acted_on <> hr_api.g_varchar2 then
3443: hr_utility.set_location(l_proc, 12);
3444:
3445: ghr_pa_requests_pkg.get_roles
3446: (p_pa_request_id,

Line 3568: if nvl(l_action_taken,hr_api.g_varchar2) not in ('NOT_ROUTED','UPDATE_HR','FUTURE_ACTION','NONE','END_ROUTING') then

3564: -- Insert 2nd record into routing_history for routing details (with exceptions )
3565:
3566: /***dk***/
3567: -- Should I add ENDED and/or END_ROUTING to the following if??
3568: if nvl(l_action_taken,hr_api.g_varchar2) not in ('NOT_ROUTED','UPDATE_HR','FUTURE_ACTION','NONE','END_ROUTING') then
3569:
3570: ghr_prh_ins.ins
3571: (p_pa_routing_history_id => l_i_pa_routing_history_id,
3572: p_pa_request_id => p_pa_request_id,

Line 3604: If p_proposed_effective_asap_flag = hr_api.g_varchar2 then

3600: hr_utility.set_location(l_proc, 21);
3601: l_rec.pa_request_id := p_pa_request_id;
3602: l_rec.noa_family_code := p_noa_family_code;
3603: l_rec.routing_group_id := p_routing_group_id;
3604: If p_proposed_effective_asap_flag = hr_api.g_varchar2 then
3605: l_rec.proposed_effective_asap_flag := ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
3606: Else
3607: l_rec.proposed_effective_asap_flag := p_proposed_effective_asap_flag;
3608: End if;

Line 3627: If p_custom_pay_calc_flag = hr_api.g_varchar2 then

3623: l_rec.award_uom := p_award_uom;
3624: l_rec.bargaining_unit_status := p_bargaining_unit_status;
3625: l_rec.citizenship := p_citizenship;
3626: l_rec.concurrence_date := p_concurrence_date;
3627: If p_custom_pay_calc_flag = hr_api.g_varchar2 then
3628: l_rec.custom_pay_calc_flag := ghr_par_shd.g_old_rec.custom_pay_calc_flag;
3629: Else
3630: l_rec.custom_pay_calc_flag := p_custom_pay_calc_flag;
3631: End if;

Line 3653: If p_first_noa_code = hr_api.g_varchar2 then

3649: l_rec.first_action_la_code2 := p_first_action_la_code2;
3650: l_rec.first_action_la_desc1 := p_first_action_la_desc1;
3651: l_rec.first_action_la_desc2 := p_first_action_la_desc2;
3652: l_rec.first_noa_cancel_or_correct := p_first_noa_cancel_or_correct;
3653: If p_first_noa_code = hr_api.g_varchar2 then
3654: l_rec.first_noa_code := ghr_par_shd.g_old_rec.first_noa_code;
3655: Else
3656: l_rec.first_noa_code := p_first_noa_code;
3657: End if;

Line 3678: If p_from_pay_plan = hr_api.g_varchar2 then

3674: l_rec.from_occ_code := p_from_occ_code;
3675: l_rec.from_other_pay_amount := p_from_other_pay_amount;
3676: l_rec.from_pay_basis := p_from_pay_basis;
3677:
3678: If p_from_pay_plan = hr_api.g_varchar2 then
3679: l_rec.from_pay_plan := ghr_par_shd.g_old_rec.from_pay_plan;
3680: Else
3681: l_rec.from_pay_plan := p_from_pay_plan;
3682: End if;

Line 3701: If p_part_time_hours = hr_api.g_number then

3697: l_rec.from_step_or_rate := p_from_step_or_rate;
3698: l_rec.from_total_salary := p_from_total_salary;
3699: l_rec.functional_class := p_functional_class;
3700: l_rec.notepad := p_notepad;
3701: If p_part_time_hours = hr_api.g_number then
3702: l_rec.part_time_hours := ghr_par_shd.g_old_rec.part_time_hours;
3703: Else
3704: l_rec.part_time_hours := p_part_time_hours;
3705: End if;

Line 3714: If p_requesting_office_remarks_fl = hr_api.g_varchar2 then

3710: l_rec.requested_by_person_id := p_requested_by_person_id;
3711: l_rec.requested_by_title := p_requested_by_title;
3712: l_rec.requested_date := p_requested_date;
3713: l_rec.requesting_office_remarks_desc := p_requesting_office_remarks_de;
3714: If p_requesting_office_remarks_fl = hr_api.g_varchar2 then
3715: l_rec.requesting_office_remarks_flag := ghr_par_shd.g_old_rec.requesting_office_remarks_flag;
3716: Else
3717: l_rec.requesting_office_remarks_flag := p_requesting_office_remarks_fl;
3718: End if;

Line 3754: If p_to_pay_plan = hr_api.g_varchar2 then

3750: l_rec.to_retention_allowance := p_to_retention_allowance;
3751: l_rec.to_supervisory_differential := p_to_supervisory_differential;
3752: l_rec.to_staffing_differential := p_to_staffing_differential;
3753: l_rec.to_pay_basis := p_to_pay_basis;
3754: If p_to_pay_plan = hr_api.g_varchar2 then
3755: l_rec.to_pay_plan := ghr_par_shd.g_old_rec.to_pay_plan;
3756: Else
3757: l_rec.to_pay_plan := p_to_pay_plan;
3758: End if;

Line 3779: If p_year_degree_attained = hr_api.g_number then

3775: l_rec.veterans_pref_for_rif := p_veterans_pref_for_rif;
3776: l_rec.veterans_status := p_veterans_status;
3777: l_rec.work_schedule := p_work_schedule;
3778: l_rec.work_schedule_desc := p_work_schedule_desc;
3779: If p_year_degree_attained = hr_api.g_number then
3780: l_rec.year_degree_attained := ghr_par_shd.g_old_rec.year_degree_attained;
3781: Else
3782: l_rec.year_degree_attained := p_year_degree_attained;
3783: End if;

Line 3837: If p_to_retention_allow_percentag = hr_api.g_number then

3833: l_rec.attribute18 := p_attribute18;
3834: l_rec.attribute19 := p_attribute19;
3835: l_rec.attribute20 := p_attribute20;
3836: l_rec.object_version_number := l_par_object_version_number;
3837: If p_to_retention_allow_percentag = hr_api.g_number then
3838: l_rec.to_retention_allow_percentage := ghr_par_shd.g_old_rec.to_retention_allow_percentage;
3839: Else
3840: l_rec.to_retention_allow_percentage := p_to_retention_allow_percentag;
3841: End if;

Line 3842: If p_to_supervisory_diff_percenta = hr_api.g_number then

3838: l_rec.to_retention_allow_percentage := ghr_par_shd.g_old_rec.to_retention_allow_percentage;
3839: Else
3840: l_rec.to_retention_allow_percentage := p_to_retention_allow_percentag;
3841: End if;
3842: If p_to_supervisory_diff_percenta = hr_api.g_number then
3843: l_rec.to_supervisory_diff_percentage := ghr_par_shd.g_old_rec.to_supervisory_diff_percentage;
3844: Else
3845: l_rec.to_supervisory_diff_percentage := p_to_supervisory_diff_percenta;
3846: End if;

Line 3847: If p_to_staffing_diff_percentage = hr_api.g_number then

3843: l_rec.to_supervisory_diff_percentage := ghr_par_shd.g_old_rec.to_supervisory_diff_percentage;
3844: Else
3845: l_rec.to_supervisory_diff_percentage := p_to_supervisory_diff_percenta;
3846: End if;
3847: If p_to_staffing_diff_percentage = hr_api.g_number then
3848: l_rec.to_staffing_diff_percentage := ghr_par_shd.g_old_rec.to_staffing_diff_percentage;
3849: Else
3850: l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
3851: End if;

Line 3852: If p_award_percentage = hr_api.g_number then

3848: l_rec.to_staffing_diff_percentage := ghr_par_shd.g_old_rec.to_staffing_diff_percentage;
3849: Else
3850: l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
3851: End if;
3852: If p_award_percentage = hr_api.g_number then
3853: l_rec.award_percentage := ghr_par_shd.g_old_rec.award_percentage;
3854: Else
3855: l_rec.award_percentage := p_award_percentage;
3856: End if;

Line 3860: If p_mass_action_eligible_flag = hr_api.g_varchar2 then

3856: End if;
3857: l_rec.rpa_type := p_rpa_type;
3858: l_rec.mass_action_id := p_mass_action_id;
3859:
3860: If p_mass_action_eligible_flag = hr_api.g_varchar2 then
3861: l_rec.mass_action_eligible_flag := ghr_par_shd.g_old_rec.mass_action_eligible_flag;
3862: Else
3863: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
3864: End if;

Line 3865: If p_mass_action_select_flag = hr_api.g_varchar2 then

3861: l_rec.mass_action_eligible_flag := ghr_par_shd.g_old_rec.mass_action_eligible_flag;
3862: Else
3863: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
3864: End if;
3865: If p_mass_action_select_flag = hr_api.g_varchar2 then
3866: l_rec.mass_action_select_flag := ghr_par_shd.g_old_rec.mass_action_select_flag;
3867: Else
3868: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
3869: End if;

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 4328: when hr_api.cannot_find_prog_unit then

4324: p_mass_action_select_flag => p_mass_action_select_flag,
4325: p_mass_action_comments => p_mass_action_comments
4326: );
4327: exception
4328: when hr_api.cannot_find_prog_unit then
4329: hr_api.cannot_find_prog_unit_error
4330: (p_module_name => 'update_sf52',
4331: p_hook_type => 'AP'
4332: );

Line 4329: hr_api.cannot_find_prog_unit_error

4325: p_mass_action_comments => p_mass_action_comments
4326: );
4327: exception
4328: when hr_api.cannot_find_prog_unit then
4329: hr_api.cannot_find_prog_unit_error
4330: (p_module_name => 'update_sf52',
4331: p_hook_type => 'AP'
4332: );
4333: end;

Line 4340: raise hr_api.validate_enabled;

4336: --
4337: -- When in validation only mode raise the Validate_Enabled exception
4338: --
4339: if p_validate then
4340: raise hr_api.validate_enabled;
4341: end if;
4342:
4343: --
4344: -- Set all output arguments

Line 4352: when hr_api.validate_enabled then

4348: p_par_object_version_number := l_par_object_version_number;
4349: --
4350: hr_utility.set_location(' Leaving:'||l_proc, 11);
4351: exception
4352: when hr_api.validate_enabled then
4353: --
4354: -- As the Validate_Enabled exception has been raised
4355: -- we must rollback to the savepoint
4356: --

Line 4389: p_user_name in varchar2 default hr_api.g_varchar2,

4385:
4386: procedure end_sf52
4387: (p_validate in boolean default false,
4388: p_pa_request_id in number,
4389: p_user_name in varchar2 default hr_api.g_varchar2,
4390: p_action_taken in varchar2,
4391: p_altered_pa_request_id in number default null,
4392: p_first_noa_code in varchar2 default null,
4393: p_second_noa_code in varchar2 default null,

Line 4521: when hr_api.cannot_find_prog_unit then

4517: p_second_noa_code => p_second_noa_code,
4518: p_par_object_version_number => p_par_object_version_number
4519: );
4520: exception
4521: when hr_api.cannot_find_prog_unit then
4522: hr_api.cannot_find_prog_unit_error
4523: (p_module_name => 'end_sf52',
4524: p_hook_type => 'BP'
4525: );

Line 4522: hr_api.cannot_find_prog_unit_error

4518: p_par_object_version_number => p_par_object_version_number
4519: );
4520: exception
4521: when hr_api.cannot_find_prog_unit then
4522: hr_api.cannot_find_prog_unit_error
4523: (p_module_name => 'end_sf52',
4524: p_hook_type => 'BP'
4525: );
4526: end;

Line 4549: if nvl(p_action_taken,hr_api.g_varchar2) in ('CANCELED','UPDATE_HR_COMPLETE','ENDED') then

4545: End if;
4546:
4547: /***dk***/
4548: -- Added ENDED to the following if.
4549: if nvl(p_action_taken,hr_api.g_varchar2) in ('CANCELED','UPDATE_HR_COMPLETE','ENDED') then
4550:
4551: for request_details in c_request_details loop
4552: l_effective_date := trunc(request_details.effective_date);
4553: l_routing_group_id := request_details.routing_group_id;

Line 4633: If nvl(p_user_name,hr_api.g_varchar2) <> hr_api.g_varchar2 then

4629: -- If the Form calls end_sf52 directly to Cancel an SF52, then
4630: -- the user_name (acted_on) has to be passed. Therefore the one from
4631: -- the database may not necessarily be the correct one., in which case the p_user_name should be further used.
4632:
4633: If nvl(p_user_name,hr_api.g_varchar2) <> hr_api.g_varchar2 then
4634: l_user_name := p_user_name;
4635: End if;
4636:
4637: -- The foll. was Removed on 08/16 as per Vikram

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: );

Line 4717: when hr_api.cannot_find_prog_unit then

4713: p_second_noa_code => p_second_noa_code,
4714: p_par_object_version_number => l_par_object_version_number
4715: );
4716: exception
4717: when hr_api.cannot_find_prog_unit then
4718: hr_api.cannot_find_prog_unit_error
4719: (p_module_name => 'end_sf52',
4720: p_hook_type => 'AP'
4721: );

Line 4718: hr_api.cannot_find_prog_unit_error

4714: p_par_object_version_number => l_par_object_version_number
4715: );
4716: exception
4717: when hr_api.cannot_find_prog_unit then
4718: hr_api.cannot_find_prog_unit_error
4719: (p_module_name => 'end_sf52',
4720: p_hook_type => 'AP'
4721: );
4722: end;

Line 4727: raise hr_api.validate_enabled;

4723: --
4724: -- End of After Process User Hook call
4725: --
4726: if p_validate then
4727: raise hr_api.validate_enabled;
4728: end if;
4729:
4730:
4731: -- Set all output arguments

Line 4736: when hr_api.validate_enabled then

4732: --
4733:
4734: hr_utility.set_location(' Leaving:'||l_proc, 11);
4735: exception
4736: when hr_api.validate_enabled then
4737: --
4738: -- As the Validate_Enabled exception has been raised
4739: -- we must rollback to the savepoint
4740: --

Line 4908: If nvl(p_action_taken,hr_api.g_varchar2) = 'CANCELED' or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR_COMPLETE'

4904: p_status out nocopy varchar2
4905: )
4906: is
4907: Begin
4908: If nvl(p_action_taken,hr_api.g_varchar2) = 'CANCELED' or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR_COMPLETE'
4909: or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' then
4910: p_status := p_action_taken;
4911: If nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' and trunc(nvl(p_effective_date,hr_api.g_date)) > sysdate then
4912: p_status := 'FUTURE_ACTION';

Line 4909: or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' then

4905: )
4906: is
4907: Begin
4908: If nvl(p_action_taken,hr_api.g_varchar2) = 'CANCELED' or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR_COMPLETE'
4909: or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' then
4910: p_status := p_action_taken;
4911: If nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' and trunc(nvl(p_effective_date,hr_api.g_date)) > sysdate then
4912: p_status := 'FUTURE_ACTION';
4913: End if;

Line 4911: If nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' and trunc(nvl(p_effective_date,hr_api.g_date)) > sysdate then

4907: Begin
4908: If nvl(p_action_taken,hr_api.g_varchar2) = 'CANCELED' or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR_COMPLETE'
4909: or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' then
4910: p_status := p_action_taken;
4911: If nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' and trunc(nvl(p_effective_date,hr_api.g_date)) > sysdate then
4912: p_status := 'FUTURE_ACTION';
4913: End if;
4914: Elsif nvl(p_approval_date,hr_api.g_date) <> hr_api.g_date
4915: --8279908 added comparison for pa request id

Line 4914: Elsif nvl(p_approval_date,hr_api.g_date) <> hr_api.g_date

4910: p_status := p_action_taken;
4911: If nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' and trunc(nvl(p_effective_date,hr_api.g_date)) > sysdate then
4912: p_status := 'FUTURE_ACTION';
4913: End if;
4914: Elsif nvl(p_approval_date,hr_api.g_date) <> hr_api.g_date
4915: --8279908 added comparison for pa request id
4916: or (nvl(ghr_par_shd.g_old_rec.approval_date,hr_api.g_date) <> hr_api.g_date
4917: and ghr_par_shd.g_old_rec.pa_request_id = p_pa_request_id) then
4918: p_status := 'APPROVED';

Line 4916: or (nvl(ghr_par_shd.g_old_rec.approval_date,hr_api.g_date) <> hr_api.g_date

4912: p_status := 'FUTURE_ACTION';
4913: End if;
4914: Elsif nvl(p_approval_date,hr_api.g_date) <> hr_api.g_date
4915: --8279908 added comparison for pa request id
4916: or (nvl(ghr_par_shd.g_old_rec.approval_date,hr_api.g_date) <> hr_api.g_date
4917: and ghr_par_shd.g_old_rec.pa_request_id = p_pa_request_id) then
4918: p_status := 'APPROVED';
4919: Elsif p_authorized_by_person_id is not null then
4920: p_status := 'AUTHORIZED';

Line 4966: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or

4962: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4963: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4964: hr_utility.set_location('Action ' || (p_action_taken),1);
4965: If
4966: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or
4967: nvl(p_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION'
4968: --**dk
4969: or nvl(p_action_taken,hr_api.g_varchar2) = 'END_ROUTING'
4970:

Line 4967: nvl(p_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION'

4963: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4964: hr_utility.set_location('Action ' || (p_action_taken),1);
4965: If
4966: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or
4967: nvl(p_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION'
4968: --**dk
4969: or nvl(p_action_taken,hr_api.g_varchar2) = 'END_ROUTING'
4970:
4971: ) then

Line 4969: or nvl(p_action_taken,hr_api.g_varchar2) = 'END_ROUTING'

4965: If
4966: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or
4967: nvl(p_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION'
4968: --**dk
4969: or nvl(p_action_taken,hr_api.g_varchar2) = 'END_ROUTING'
4970:
4971: ) then
4972: -- BUG # 3420126 As per requirements in the bug need not be fired during routing
4973: /*or

Line 4975: nvl(p_user_name_acted_on,hr_api.g_varchar2) <> p_user_name_routed_to

4971: ) then
4972: -- BUG # 3420126 As per requirements in the bug need not be fired during routing
4973: /*or
4974: ( p_user_name_routed_to is not null and
4975: nvl(p_user_name_acted_on,hr_api.g_varchar2) <> p_user_name_routed_to
4976: ) or
4977: (p_groupbox_routed_to is not null )*/
4978:
4979: hr_utility.set_location(l_proc,10);