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 286: l_asg_sf52 ghr_api.asg_sf52_type;

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

Line 287: l_asg_non_sf52 ghr_api.asg_non_sf52_type;

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

Line 288: l_asg_nte_dates ghr_api.asg_nte_dates_type;

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

Line 289: l_per_sf52 ghr_api.per_sf52_type;

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

Line 290: l_per_group1 ghr_api.per_group1_type;

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

Line 291: l_per_group2 ghr_api.per_group2_type;

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

Line 292: l_per_scd_info ghr_api.per_scd_info_type;

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

Line 293: l_per_retained_grade ghr_api.per_retained_grade_type;

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

Line 294: l_per_probations ghr_api.per_probations_type;

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

Line 295: l_per_sep_retire ghr_api.per_sep_retire_type;

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

Line 296: l_per_security ghr_api.per_security_type;

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

Line 297: l_per_conversions ghr_api.per_conversions_type;

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

Line 298: l_per_uniformed_services ghr_api.per_uniformed_services_type;

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

Line 299: l_pos_oblig ghr_api.pos_oblig_type;

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

Line 300: l_pos_grp2 ghr_api.pos_grp2_type;

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

Line 301: l_pos_grp1 ghr_api.pos_grp1_type;

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

Line 302: l_pos_valid_grade ghr_api.pos_valid_grade_type;

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

Line 303: l_pos_car_prog ghr_api.pos_car_prog_type;

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

Line 304: l_loc_info ghr_api.loc_info_type;

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

Line 305: l_wgi ghr_api.within_grade_increase_type;

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

Line 306: l_recruitment_bonus ghr_api.recruitment_bonus_type;

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

Line 307: l_relocation_bonus ghr_api.relocation_bonus_type;

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

Line 310: l_mddds_special_pay ghr_api.mddds_special_pay_type;

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

Line 311: l_sf52_from_data ghr_api.prior_sf52_data_type;

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

Line 312: l_personal_info ghr_api.personal_info_type;

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

Line 313: l_gov_awards_type ghr_api.government_awards_type;

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

Line 314: l_perf_appraisal_type ghr_api.performance_appraisal_type;

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

Line 315: l_payroll_type ghr_api.government_payroll_type;

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

Line 316: l_conduct_perf_type ghr_api.conduct_performance_type;

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

Line 317: l_agency_sf52 ghr_api.agency_sf52_type;

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

Line 319: l_imm_entitlement ghr_api.entitlement_type;

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

Line 320: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

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

Line 321: l_imm_edp_pay ghr_api.edp_pay_type;

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

Line 322: l_imm_hazard_pay ghr_api.hazard_pay_type;

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

Line 323: l_imm_health_benefits ghr_api.health_benefits_type;

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

Line 324: l_imm_danger_pay ghr_api.danger_pay_type;

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

Line 325: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;

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

Line 326: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;

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

Line 327: l_imm_post_diff_amt ghr_api.post_diff_amt_type;

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

Line 328: l_imm_post_diff_percent ghr_api.post_diff_percent_type;

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

Line 329: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

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

Line 330: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;

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

Line 331: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;

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

Line 332: l_imm_premium_pay ghr_api.premium_pay_type;

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

Line 333: l_imm_retirement_annuity ghr_api.retirement_annuity_type;

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

Line 334: l_imm_severance_pay ghr_api.severance_pay_type;

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

Line 335: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;

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

Line 336: l_imm_retention_allow_review ghr_api.retention_allow_review_type;

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

Line 337: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

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

Line 338: l_imm_per_benefit_info ghr_api.per_benefit_info_type;

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

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

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

Line 628: when hr_api.cannot_find_prog_unit then

624: p_mass_action_select_flag => p_mass_action_select_flag,
625: p_mass_action_comments => p_mass_action_comments
626: );
627: exception
628: when hr_api.cannot_find_prog_unit then
629: hr_api.cannot_find_prog_unit_error
630: (p_module_name => 'create_sf52',
631: p_hook_type => 'BP'
632: );

Line 629: hr_api.cannot_find_prog_unit_error

625: p_mass_action_comments => p_mass_action_comments
626: );
627: exception
628: when hr_api.cannot_find_prog_unit then
629: hr_api.cannot_find_prog_unit_error
630: (p_module_name => 'create_sf52',
631: p_hook_type => 'BP'
632: );
633: end;

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

652: l_approval_date := p_approval_date;
653: l_approving_official_work_titl := p_approving_official_work_titl;
654: l_approving_official_full_name := p_approving_official_full_name;
655:
656: If nvl(p_1_approval_status,hr_api.g_varchar2) = 'APPROVE' then
657: If p_approval_date is null
658: then
659: hr_utility.set_location('approval date is not null',1);
660: l_effective_date := trunc(sysdate);

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

685:
686: -- Update the SF50 approver details , when the user chooses to 'Update HR' (Immediate or Future)
687: -- Derive for individual actions . For Mass Actions they are the same as the SF52 approver details
688:
689: If nvl(p_1_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then
690: If p_approval_date is not null then
691: l_sf50_approval_date := p_approval_date;
692: l_sf50_approving_ofcl_work_tit := p_approving_official_work_titl;
693: l_sf50_approving_ofcl_full_nam := p_approving_official_full_name;

Line 1016: -- (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' )

1012:
1013: -- Create all the noa_specific extra information
1014: l_position_id := nvl(p_to_position_id,p_from_position_id);
1015:
1016: -- (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' )
1017: -- Comment above line because irrespective of p_mass_action_id value the if condn should be true (AVR)
1018:
1019: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
1020: or

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

1015:
1016: -- (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' )
1017: -- Comment above line because irrespective of p_mass_action_id value the if condn should be true (AVR)
1018:
1019: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
1020: or
1021: (nvl(p_1_action_taken,hr_api.g_varchar2) = 'NOT_ROUTED' and
1022: nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' )
1023: then

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

1017: -- Comment above line because irrespective of p_mass_action_id value the if condn should be true (AVR)
1018:
1019: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
1020: or
1021: (nvl(p_1_action_taken,hr_api.g_varchar2) = 'NOT_ROUTED' and
1022: nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' )
1023: then
1024:
1025: If p_person_id is not null or p_noa_family_code = 'APP' then

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

1018:
1019: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
1020: or
1021: (nvl(p_1_action_taken,hr_api.g_varchar2) = 'NOT_ROUTED' and
1022: nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' )
1023: then
1024:
1025: If p_person_id is not null or p_noa_family_code = 'APP' then
1026: GHR_NON_SF52_EXTRA_INFO.fetch_generic_extra_info

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

1084:
1085: hr_utility.set_location('passed action taken ' ||p_1_action_taken,1);
1086: l_action_taken := p_1_action_taken;
1087: if l_action_taken is null then
1088: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1089: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
1090: l_action_taken := 'AUTHORIZED';
1091: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1092: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then

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

1085: hr_utility.set_location('passed action taken ' ||p_1_action_taken,1);
1086: l_action_taken := p_1_action_taken;
1087: if l_action_taken is null then
1088: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1089: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
1090: l_action_taken := 'AUTHORIZED';
1091: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1092: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
1093: l_action_taken := 'REQUESTED';

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

1087: if l_action_taken is null then
1088: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1089: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
1090: l_action_taken := 'AUTHORIZED';
1091: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1092: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
1093: l_action_taken := 'REQUESTED';
1094: else
1095: hr_utility.set_location('Bef c_history_exists ' ||l_pa_request_id,2);

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

1088: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1089: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
1090: l_action_taken := 'AUTHORIZED';
1091: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1092: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
1093: l_action_taken := 'REQUESTED';
1094: else
1095: hr_utility.set_location('Bef c_history_exists ' ||l_pa_request_id,2);
1096: for history_exists in C_history_exists loop

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

1146: end if;
1147: end if;
1148:
1149: -- write the first record into the routing history (actions done by the user)
1150: if nvl(l_action_taken,hr_api.g_varchar2) not in
1151: ('CANCELED','UPDATE_HR_COMPLETE') then
1152: ----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
1153: -- Comment above line because irrespective of p_mass_action_id value the if condn should be true (AVR)
1154:

Line 1152: ----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

1148:
1149: -- write the first record into the routing history (actions done by the user)
1150: if nvl(l_action_taken,hr_api.g_varchar2) not in
1151: ('CANCELED','UPDATE_HR_COMPLETE') then
1152: ----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
1153: -- Comment above line because irrespective of p_mass_action_id value the if condn should be true (AVR)
1154:
1155: If nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' then
1156: if l_action_taken = 'UPDATE_HR' and trunc(p_effective_date) > trunc(sysdate) then

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

1151: ('CANCELED','UPDATE_HR_COMPLETE') then
1152: ----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
1153: -- Comment above line because irrespective of p_mass_action_id value the if condn should be true (AVR)
1154:
1155: If nvl(p_rpa_type,hr_api.g_varchar2) <> 'TA' then
1156: if l_action_taken = 'UPDATE_HR' and trunc(p_effective_date) > trunc(sysdate) then
1157: l_action_taken := 'FUTURE_ACTION';
1158: End if;
1159:

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

1233: --Insert 2nd record into routing_history for routing details
1234: -- (exception when routing_status = 'NOT_ROUTED' or 'UPDATE_HR','FUTURE_ACTION','END_ROUTING')
1235: /***dk***/
1236: -- added END_ROUTING to the following if stmt.
1237: if nvl(l_action_taken,hr_api.g_varchar2) not in ('NOT_ROUTED','UPDATE_HR','FUTURE_ACTION','END_ROUTING') then
1238:
1239: ghr_prh_ins.ins
1240: (p_pa_routing_history_id => p_2_pa_routing_history_id,
1241: p_pa_request_id => l_pa_request_id,

Line 1611: ghr_api.call_workflow

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

Line 1867: when hr_api.cannot_find_prog_unit then

1863: p_mass_action_select_flag => p_mass_action_select_flag,
1864: p_mass_action_comments => p_mass_action_comments
1865: );
1866: exception
1867: when hr_api.cannot_find_prog_unit then
1868: hr_api.cannot_find_prog_unit_error
1869: (p_module_name => 'create_sf52',
1870: p_hook_type => 'AP'
1871: );

Line 1868: hr_api.cannot_find_prog_unit_error

1864: p_mass_action_comments => p_mass_action_comments
1865: );
1866: exception
1867: when hr_api.cannot_find_prog_unit then
1868: hr_api.cannot_find_prog_unit_error
1869: (p_module_name => 'create_sf52',
1870: p_hook_type => 'AP'
1871: );
1872: end;

Line 1879: raise hr_api.validate_enabled;

1875: --
1876: -- When in validation only mode raise the Validate_Enabled exception
1877: --
1878: if p_validate then
1879: raise hr_api.validate_enabled;
1880: end if;
1881:
1882: --
1883: -- Set all output arguments

Line 1889: when hr_api.validate_enabled then

1885: p_pa_request_id := l_pa_request_id;
1886:
1887: hr_utility.set_location(' Leaving:'||l_proc, 11);
1888: exception
1889: when hr_api.validate_enabled then
1890: -- As the Validate_Enabled exception has been raised
1891: -- we must rollback to the savepoint
1892:
1893: ROLLBACK TO create_sf52;

Line 1928: p_noa_family_code in varchar2 default hr_api.g_varchar2,

1924: -- ----------------------------------------------------------------------------
1925: procedure update_sf52
1926: (p_validate in boolean default false,
1927: p_pa_request_id in number,
1928: p_noa_family_code in varchar2 default hr_api.g_varchar2,
1929: p_routing_group_id in number default hr_api.g_number,
1930: p_par_object_version_number in out nocopy number,
1931: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1932: p_academic_discipline in varchar2 default hr_api.g_varchar2,

Line 1929: p_routing_group_id in number default hr_api.g_number,

1925: procedure update_sf52
1926: (p_validate in boolean default false,
1927: p_pa_request_id in number,
1928: p_noa_family_code in varchar2 default hr_api.g_varchar2,
1929: p_routing_group_id in number default hr_api.g_number,
1930: p_par_object_version_number in out nocopy number,
1931: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1932: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1933: p_additional_info_person_id in number default hr_api.g_number,

Line 1931: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,

1927: p_pa_request_id in number,
1928: p_noa_family_code in varchar2 default hr_api.g_varchar2,
1929: p_routing_group_id in number default hr_api.g_number,
1930: p_par_object_version_number in out nocopy number,
1931: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1932: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1933: p_additional_info_person_id in number default hr_api.g_number,
1934: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1935: p_altered_pa_request_id in number default hr_api.g_number,

Line 1932: p_academic_discipline in varchar2 default hr_api.g_varchar2,

1928: p_noa_family_code in varchar2 default hr_api.g_varchar2,
1929: p_routing_group_id in number default hr_api.g_number,
1930: p_par_object_version_number in out nocopy number,
1931: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1932: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1933: p_additional_info_person_id in number default hr_api.g_number,
1934: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1935: p_altered_pa_request_id in number default hr_api.g_number,
1936: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,

Line 1933: p_additional_info_person_id in number default hr_api.g_number,

1929: p_routing_group_id in number default hr_api.g_number,
1930: p_par_object_version_number in out nocopy number,
1931: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1932: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1933: p_additional_info_person_id in number default hr_api.g_number,
1934: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1935: p_altered_pa_request_id in number default hr_api.g_number,
1936: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1937: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,

Line 1934: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,

1930: p_par_object_version_number in out nocopy number,
1931: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1932: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1933: p_additional_info_person_id in number default hr_api.g_number,
1934: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1935: p_altered_pa_request_id in number default hr_api.g_number,
1936: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1937: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1938: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,

Line 1935: p_altered_pa_request_id in number default hr_api.g_number,

1931: p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1932: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1933: p_additional_info_person_id in number default hr_api.g_number,
1934: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1935: p_altered_pa_request_id in number default hr_api.g_number,
1936: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1937: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1938: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1939: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,

Line 1936: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,

1932: p_academic_discipline in varchar2 default hr_api.g_varchar2,
1933: p_additional_info_person_id in number default hr_api.g_number,
1934: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1935: p_altered_pa_request_id in number default hr_api.g_number,
1936: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1937: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1938: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1939: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1940: p_approval_date in date default hr_api.g_date,

Line 1937: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,

1933: p_additional_info_person_id in number default hr_api.g_number,
1934: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1935: p_altered_pa_request_id in number default hr_api.g_number,
1936: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1937: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1938: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1939: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1940: p_approval_date in date default hr_api.g_date,
1941: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,

Line 1938: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,

1934: p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1935: p_altered_pa_request_id in number default hr_api.g_number,
1936: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1937: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1938: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1939: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1940: p_approval_date in date default hr_api.g_date,
1941: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1942: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,

Line 1939: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,

1935: p_altered_pa_request_id in number default hr_api.g_number,
1936: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1937: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1938: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1939: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1940: p_approval_date in date default hr_api.g_date,
1941: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1942: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1943: p_authorized_by_person_id in number default hr_api.g_number,

Line 1940: p_approval_date in date default hr_api.g_date,

1936: p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1937: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1938: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1939: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1940: p_approval_date in date default hr_api.g_date,
1941: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1942: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1943: p_authorized_by_person_id in number default hr_api.g_number,
1944: p_authorized_by_title in varchar2 default hr_api.g_varchar2,

Line 1941: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,

1937: p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1938: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1939: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1940: p_approval_date in date default hr_api.g_date,
1941: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1942: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1943: p_authorized_by_person_id in number default hr_api.g_number,
1944: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1945: p_award_amount in number default hr_api.g_number,

Line 1942: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,

1938: p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1939: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1940: p_approval_date in date default hr_api.g_date,
1941: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1942: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1943: p_authorized_by_person_id in number default hr_api.g_number,
1944: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1945: p_award_amount in number default hr_api.g_number,
1946: p_award_uom in varchar2 default hr_api.g_varchar2,

Line 1943: p_authorized_by_person_id in number default hr_api.g_number,

1939: p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1940: p_approval_date in date default hr_api.g_date,
1941: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1942: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1943: p_authorized_by_person_id in number default hr_api.g_number,
1944: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1945: p_award_amount in number default hr_api.g_number,
1946: p_award_uom in varchar2 default hr_api.g_varchar2,
1947: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,

Line 1944: p_authorized_by_title in varchar2 default hr_api.g_varchar2,

1940: p_approval_date in date default hr_api.g_date,
1941: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1942: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1943: p_authorized_by_person_id in number default hr_api.g_number,
1944: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1945: p_award_amount in number default hr_api.g_number,
1946: p_award_uom in varchar2 default hr_api.g_varchar2,
1947: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1948: p_citizenship in varchar2 default hr_api.g_varchar2,

Line 1945: p_award_amount in number default hr_api.g_number,

1941: p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1942: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1943: p_authorized_by_person_id in number default hr_api.g_number,
1944: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1945: p_award_amount in number default hr_api.g_number,
1946: p_award_uom in varchar2 default hr_api.g_varchar2,
1947: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1948: p_citizenship in varchar2 default hr_api.g_varchar2,
1949: p_concurrence_date in date default hr_api.g_date,

Line 1946: p_award_uom in varchar2 default hr_api.g_varchar2,

1942: p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1943: p_authorized_by_person_id in number default hr_api.g_number,
1944: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1945: p_award_amount in number default hr_api.g_number,
1946: p_award_uom in varchar2 default hr_api.g_varchar2,
1947: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1948: p_citizenship in varchar2 default hr_api.g_varchar2,
1949: p_concurrence_date in date default hr_api.g_date,
1950: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,

Line 1947: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,

1943: p_authorized_by_person_id in number default hr_api.g_number,
1944: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1945: p_award_amount in number default hr_api.g_number,
1946: p_award_uom in varchar2 default hr_api.g_varchar2,
1947: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1948: p_citizenship in varchar2 default hr_api.g_varchar2,
1949: p_concurrence_date in date default hr_api.g_date,
1950: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1951: p_duty_station_code in varchar2 default hr_api.g_varchar2,

Line 1948: p_citizenship in varchar2 default hr_api.g_varchar2,

1944: p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1945: p_award_amount in number default hr_api.g_number,
1946: p_award_uom in varchar2 default hr_api.g_varchar2,
1947: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1948: p_citizenship in varchar2 default hr_api.g_varchar2,
1949: p_concurrence_date in date default hr_api.g_date,
1950: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1951: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1952: p_duty_station_desc in varchar2 default hr_api.g_varchar2,

Line 1949: p_concurrence_date in date default hr_api.g_date,

1945: p_award_amount in number default hr_api.g_number,
1946: p_award_uom in varchar2 default hr_api.g_varchar2,
1947: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1948: p_citizenship in varchar2 default hr_api.g_varchar2,
1949: p_concurrence_date in date default hr_api.g_date,
1950: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1951: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1952: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1953: p_duty_station_id in number default hr_api.g_number,

Line 1950: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,

1946: p_award_uom in varchar2 default hr_api.g_varchar2,
1947: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1948: p_citizenship in varchar2 default hr_api.g_varchar2,
1949: p_concurrence_date in date default hr_api.g_date,
1950: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1951: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1952: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1953: p_duty_station_id in number default hr_api.g_number,
1954: p_duty_station_location_id in number default hr_api.g_number,

Line 1951: p_duty_station_code in varchar2 default hr_api.g_varchar2,

1947: p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1948: p_citizenship in varchar2 default hr_api.g_varchar2,
1949: p_concurrence_date in date default hr_api.g_date,
1950: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1951: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1952: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1953: p_duty_station_id in number default hr_api.g_number,
1954: p_duty_station_location_id in number default hr_api.g_number,
1955: p_education_level in varchar2 default hr_api.g_varchar2,

Line 1952: p_duty_station_desc in varchar2 default hr_api.g_varchar2,

1948: p_citizenship in varchar2 default hr_api.g_varchar2,
1949: p_concurrence_date in date default hr_api.g_date,
1950: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1951: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1952: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1953: p_duty_station_id in number default hr_api.g_number,
1954: p_duty_station_location_id in number default hr_api.g_number,
1955: p_education_level in varchar2 default hr_api.g_varchar2,
1956: p_effective_date in date default hr_api.g_date,

Line 1953: p_duty_station_id in number default hr_api.g_number,

1949: p_concurrence_date in date default hr_api.g_date,
1950: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1951: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1952: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1953: p_duty_station_id in number default hr_api.g_number,
1954: p_duty_station_location_id in number default hr_api.g_number,
1955: p_education_level in varchar2 default hr_api.g_varchar2,
1956: p_effective_date in date default hr_api.g_date,
1957: p_employee_assignment_id in number default hr_api.g_number,

Line 1954: p_duty_station_location_id in number default hr_api.g_number,

1950: p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1951: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1952: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1953: p_duty_station_id in number default hr_api.g_number,
1954: p_duty_station_location_id in number default hr_api.g_number,
1955: p_education_level in varchar2 default hr_api.g_varchar2,
1956: p_effective_date in date default hr_api.g_date,
1957: p_employee_assignment_id in number default hr_api.g_number,
1958: p_employee_date_of_birth in date default hr_api.g_date,

Line 1955: p_education_level in varchar2 default hr_api.g_varchar2,

1951: p_duty_station_code in varchar2 default hr_api.g_varchar2,
1952: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1953: p_duty_station_id in number default hr_api.g_number,
1954: p_duty_station_location_id in number default hr_api.g_number,
1955: p_education_level in varchar2 default hr_api.g_varchar2,
1956: p_effective_date in date default hr_api.g_date,
1957: p_employee_assignment_id in number default hr_api.g_number,
1958: p_employee_date_of_birth in date default hr_api.g_date,
1959: p_employee_first_name in varchar2 default hr_api.g_varchar2,

Line 1956: p_effective_date in date default hr_api.g_date,

1952: p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1953: p_duty_station_id in number default hr_api.g_number,
1954: p_duty_station_location_id in number default hr_api.g_number,
1955: p_education_level in varchar2 default hr_api.g_varchar2,
1956: p_effective_date in date default hr_api.g_date,
1957: p_employee_assignment_id in number default hr_api.g_number,
1958: p_employee_date_of_birth in date default hr_api.g_date,
1959: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1960: p_employee_last_name in varchar2 default hr_api.g_varchar2,

Line 1957: p_employee_assignment_id in number default hr_api.g_number,

1953: p_duty_station_id in number default hr_api.g_number,
1954: p_duty_station_location_id in number default hr_api.g_number,
1955: p_education_level in varchar2 default hr_api.g_varchar2,
1956: p_effective_date in date default hr_api.g_date,
1957: p_employee_assignment_id in number default hr_api.g_number,
1958: p_employee_date_of_birth in date default hr_api.g_date,
1959: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1960: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1961: p_employee_middle_names in varchar2 default hr_api.g_varchar2,

Line 1958: p_employee_date_of_birth in date default hr_api.g_date,

1954: p_duty_station_location_id in number default hr_api.g_number,
1955: p_education_level in varchar2 default hr_api.g_varchar2,
1956: p_effective_date in date default hr_api.g_date,
1957: p_employee_assignment_id in number default hr_api.g_number,
1958: p_employee_date_of_birth in date default hr_api.g_date,
1959: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1960: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1961: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1962: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,

Line 1959: p_employee_first_name in varchar2 default hr_api.g_varchar2,

1955: p_education_level in varchar2 default hr_api.g_varchar2,
1956: p_effective_date in date default hr_api.g_date,
1957: p_employee_assignment_id in number default hr_api.g_number,
1958: p_employee_date_of_birth in date default hr_api.g_date,
1959: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1960: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1961: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1962: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1963: p_fegli in varchar2 default hr_api.g_varchar2,

Line 1960: p_employee_last_name in varchar2 default hr_api.g_varchar2,

1956: p_effective_date in date default hr_api.g_date,
1957: p_employee_assignment_id in number default hr_api.g_number,
1958: p_employee_date_of_birth in date default hr_api.g_date,
1959: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1960: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1961: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1962: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1963: p_fegli in varchar2 default hr_api.g_varchar2,
1964: p_fegli_desc in varchar2 default hr_api.g_varchar2,

Line 1961: p_employee_middle_names in varchar2 default hr_api.g_varchar2,

1957: p_employee_assignment_id in number default hr_api.g_number,
1958: p_employee_date_of_birth in date default hr_api.g_date,
1959: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1960: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1961: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1962: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1963: p_fegli in varchar2 default hr_api.g_varchar2,
1964: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1965: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,

Line 1962: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,

1958: p_employee_date_of_birth in date default hr_api.g_date,
1959: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1960: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1961: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1962: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1963: p_fegli in varchar2 default hr_api.g_varchar2,
1964: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1965: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1966: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,

Line 1963: p_fegli in varchar2 default hr_api.g_varchar2,

1959: p_employee_first_name in varchar2 default hr_api.g_varchar2,
1960: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1961: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1962: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1963: p_fegli in varchar2 default hr_api.g_varchar2,
1964: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1965: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1966: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1967: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,

Line 1964: p_fegli_desc in varchar2 default hr_api.g_varchar2,

1960: p_employee_last_name in varchar2 default hr_api.g_varchar2,
1961: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1962: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1963: p_fegli in varchar2 default hr_api.g_varchar2,
1964: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1965: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1966: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1967: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1968: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,

Line 1965: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,

1961: p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1962: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1963: p_fegli in varchar2 default hr_api.g_varchar2,
1964: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1965: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1966: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1967: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1968: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1969: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,

Line 1966: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,

1962: p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1963: p_fegli in varchar2 default hr_api.g_varchar2,
1964: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1965: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1966: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1967: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1968: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1969: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1970: p_first_noa_code in varchar2 default hr_api.g_varchar2,

Line 1967: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,

1963: p_fegli in varchar2 default hr_api.g_varchar2,
1964: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1965: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1966: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1967: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1968: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1969: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1970: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1971: p_first_noa_desc in varchar2 default hr_api.g_varchar2,

Line 1968: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,

1964: p_fegli_desc in varchar2 default hr_api.g_varchar2,
1965: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1966: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1967: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1968: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1969: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1970: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1971: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1972: p_first_noa_id in number default hr_api.g_number,

Line 1969: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,

1965: p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1966: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1967: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1968: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1969: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1970: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1971: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1972: p_first_noa_id in number default hr_api.g_number,
1973: p_first_noa_pa_request_id in number default hr_api.g_number,

Line 1970: p_first_noa_code in varchar2 default hr_api.g_varchar2,

1966: p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1967: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1968: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1969: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1970: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1971: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1972: p_first_noa_id in number default hr_api.g_number,
1973: p_first_noa_pa_request_id in number default hr_api.g_number,
1974: p_flsa_category in varchar2 default hr_api.g_varchar2,

Line 1971: p_first_noa_desc in varchar2 default hr_api.g_varchar2,

1967: p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1968: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1969: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1970: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1971: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1972: p_first_noa_id in number default hr_api.g_number,
1973: p_first_noa_pa_request_id in number default hr_api.g_number,
1974: p_flsa_category in varchar2 default hr_api.g_varchar2,
1975: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,

Line 1972: p_first_noa_id in number default hr_api.g_number,

1968: p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1969: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1970: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1971: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1972: p_first_noa_id in number default hr_api.g_number,
1973: p_first_noa_pa_request_id in number default hr_api.g_number,
1974: p_flsa_category in varchar2 default hr_api.g_varchar2,
1975: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1976: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,

Line 1973: p_first_noa_pa_request_id in number default hr_api.g_number,

1969: p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1970: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1971: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1972: p_first_noa_id in number default hr_api.g_number,
1973: p_first_noa_pa_request_id in number default hr_api.g_number,
1974: p_flsa_category in varchar2 default hr_api.g_varchar2,
1975: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1976: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1977: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,

Line 1974: p_flsa_category in varchar2 default hr_api.g_varchar2,

1970: p_first_noa_code in varchar2 default hr_api.g_varchar2,
1971: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1972: p_first_noa_id in number default hr_api.g_number,
1973: p_first_noa_pa_request_id in number default hr_api.g_number,
1974: p_flsa_category in varchar2 default hr_api.g_varchar2,
1975: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1976: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1977: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1978: p_forwarding_country in varchar2 default hr_api.g_varchar2,

Line 1975: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,

1971: p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1972: p_first_noa_id in number default hr_api.g_number,
1973: p_first_noa_pa_request_id in number default hr_api.g_number,
1974: p_flsa_category in varchar2 default hr_api.g_varchar2,
1975: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1976: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1977: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1978: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1979: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,

Line 1976: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,

1972: p_first_noa_id in number default hr_api.g_number,
1973: p_first_noa_pa_request_id in number default hr_api.g_number,
1974: p_flsa_category in varchar2 default hr_api.g_varchar2,
1975: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1976: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1977: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1978: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1979: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1980: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,

Line 1977: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,

1973: p_first_noa_pa_request_id in number default hr_api.g_number,
1974: p_flsa_category in varchar2 default hr_api.g_varchar2,
1975: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1976: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1977: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1978: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1979: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1980: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1981: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,

Line 1978: p_forwarding_country in varchar2 default hr_api.g_varchar2,

1974: p_flsa_category in varchar2 default hr_api.g_varchar2,
1975: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1976: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1977: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1978: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1979: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1980: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1981: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1982: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,

Line 1979: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,

1975: p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1976: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1977: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1978: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1979: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1980: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1981: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1982: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1983: p_from_adj_basic_pay in number default hr_api.g_number,

Line 1980: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,

1976: p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1977: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1978: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1979: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1980: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1981: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1982: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1983: p_from_adj_basic_pay in number default hr_api.g_number,
1984: p_from_basic_pay in number default hr_api.g_number,

Line 1981: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,

1977: p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1978: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1979: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1980: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1981: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1982: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1983: p_from_adj_basic_pay in number default hr_api.g_number,
1984: p_from_basic_pay in number default hr_api.g_number,
1985: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,

Line 1982: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,

1978: p_forwarding_country in varchar2 default hr_api.g_varchar2,
1979: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1980: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1981: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1982: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1983: p_from_adj_basic_pay in number default hr_api.g_number,
1984: p_from_basic_pay in number default hr_api.g_number,
1985: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1986: p_from_locality_adj in number default hr_api.g_number,

Line 1983: p_from_adj_basic_pay in number default hr_api.g_number,

1979: p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1980: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1981: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1982: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1983: p_from_adj_basic_pay in number default hr_api.g_number,
1984: p_from_basic_pay in number default hr_api.g_number,
1985: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1986: p_from_locality_adj in number default hr_api.g_number,
1987: p_from_occ_code in varchar2 default hr_api.g_varchar2,

Line 1984: p_from_basic_pay in number default hr_api.g_number,

1980: p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1981: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1982: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1983: p_from_adj_basic_pay in number default hr_api.g_number,
1984: p_from_basic_pay in number default hr_api.g_number,
1985: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1986: p_from_locality_adj in number default hr_api.g_number,
1987: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1988: p_from_other_pay_amount in number default hr_api.g_number,

Line 1985: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,

1981: p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1982: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1983: p_from_adj_basic_pay in number default hr_api.g_number,
1984: p_from_basic_pay in number default hr_api.g_number,
1985: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1986: p_from_locality_adj in number default hr_api.g_number,
1987: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1988: p_from_other_pay_amount in number default hr_api.g_number,
1989: p_from_pay_basis in varchar2 default hr_api.g_varchar2,

Line 1986: p_from_locality_adj in number default hr_api.g_number,

1982: p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1983: p_from_adj_basic_pay in number default hr_api.g_number,
1984: p_from_basic_pay in number default hr_api.g_number,
1985: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1986: p_from_locality_adj in number default hr_api.g_number,
1987: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1988: p_from_other_pay_amount in number default hr_api.g_number,
1989: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1990: p_from_pay_plan in varchar2 default hr_api.g_varchar2,

Line 1987: p_from_occ_code in varchar2 default hr_api.g_varchar2,

1983: p_from_adj_basic_pay in number default hr_api.g_number,
1984: p_from_basic_pay in number default hr_api.g_number,
1985: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1986: p_from_locality_adj in number default hr_api.g_number,
1987: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1988: p_from_other_pay_amount in number default hr_api.g_number,
1989: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1990: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1991: -- FWFA Changes Bug#4444609

Line 1988: p_from_other_pay_amount in number default hr_api.g_number,

1984: p_from_basic_pay in number default hr_api.g_number,
1985: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1986: p_from_locality_adj in number default hr_api.g_number,
1987: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1988: p_from_other_pay_amount in number default hr_api.g_number,
1989: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1990: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1991: -- FWFA Changes Bug#4444609
1992: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,

Line 1989: p_from_pay_basis in varchar2 default hr_api.g_varchar2,

1985: p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1986: p_from_locality_adj in number default hr_api.g_number,
1987: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1988: p_from_other_pay_amount in number default hr_api.g_number,
1989: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1990: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1991: -- FWFA Changes Bug#4444609
1992: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1993: p_from_pay_table_identifier in number default hr_api.g_number,

Line 1990: p_from_pay_plan in varchar2 default hr_api.g_varchar2,

1986: p_from_locality_adj in number default hr_api.g_number,
1987: p_from_occ_code in varchar2 default hr_api.g_varchar2,
1988: p_from_other_pay_amount in number default hr_api.g_number,
1989: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1990: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1991: -- FWFA Changes Bug#4444609
1992: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1993: p_from_pay_table_identifier in number default hr_api.g_number,
1994: -- FWFA Changes

Line 1992: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,

1988: p_from_other_pay_amount in number default hr_api.g_number,
1989: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1990: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1991: -- FWFA Changes Bug#4444609
1992: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1993: p_from_pay_table_identifier in number default hr_api.g_number,
1994: -- FWFA Changes
1995: p_from_position_id in number default hr_api.g_number,
1996: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,

Line 1993: p_from_pay_table_identifier in number default hr_api.g_number,

1989: p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1990: p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1991: -- FWFA Changes Bug#4444609
1992: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1993: p_from_pay_table_identifier in number default hr_api.g_number,
1994: -- FWFA Changes
1995: p_from_position_id in number default hr_api.g_number,
1996: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1997: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,

Line 1995: p_from_position_id in number default hr_api.g_number,

1991: -- FWFA Changes Bug#4444609
1992: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1993: p_from_pay_table_identifier in number default hr_api.g_number,
1994: -- FWFA Changes
1995: p_from_position_id in number default hr_api.g_number,
1996: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1997: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1998: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1999: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,

Line 1996: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,

1992: p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1993: p_from_pay_table_identifier in number default hr_api.g_number,
1994: -- FWFA Changes
1995: p_from_position_id in number default hr_api.g_number,
1996: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1997: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1998: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1999: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2000: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,

Line 1997: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,

1993: p_from_pay_table_identifier in number default hr_api.g_number,
1994: -- FWFA Changes
1995: p_from_position_id in number default hr_api.g_number,
1996: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1997: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1998: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1999: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2000: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2001: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,

Line 1998: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,

1994: -- FWFA Changes
1995: p_from_position_id in number default hr_api.g_number,
1996: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1997: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1998: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1999: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2000: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2001: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2002: p_from_position_number in varchar2 default hr_api.g_varchar2,

Line 1999: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,

1995: p_from_position_id in number default hr_api.g_number,
1996: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1997: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1998: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1999: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2000: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2001: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2002: p_from_position_number in varchar2 default hr_api.g_varchar2,
2003: p_from_position_seq_no in number default hr_api.g_number,

Line 2000: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,

1996: p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1997: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1998: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1999: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2000: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2001: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2002: p_from_position_number in varchar2 default hr_api.g_varchar2,
2003: p_from_position_seq_no in number default hr_api.g_number,
2004: p_from_position_title in varchar2 default hr_api.g_varchar2,

Line 2001: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,

1997: p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1998: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1999: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2000: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2001: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2002: p_from_position_number in varchar2 default hr_api.g_varchar2,
2003: p_from_position_seq_no in number default hr_api.g_number,
2004: p_from_position_title in varchar2 default hr_api.g_varchar2,
2005: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,

Line 2002: p_from_position_number in varchar2 default hr_api.g_varchar2,

1998: p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1999: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2000: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2001: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2002: p_from_position_number in varchar2 default hr_api.g_varchar2,
2003: p_from_position_seq_no in number default hr_api.g_number,
2004: p_from_position_title in varchar2 default hr_api.g_varchar2,
2005: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2006: p_from_total_salary in number default hr_api.g_number,

Line 2003: p_from_position_seq_no in number default hr_api.g_number,

1999: p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
2000: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2001: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2002: p_from_position_number in varchar2 default hr_api.g_varchar2,
2003: p_from_position_seq_no in number default hr_api.g_number,
2004: p_from_position_title in varchar2 default hr_api.g_varchar2,
2005: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2006: p_from_total_salary in number default hr_api.g_number,
2007: p_functional_class in varchar2 default hr_api.g_varchar2,

Line 2004: p_from_position_title in varchar2 default hr_api.g_varchar2,

2000: p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
2001: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2002: p_from_position_number in varchar2 default hr_api.g_varchar2,
2003: p_from_position_seq_no in number default hr_api.g_number,
2004: p_from_position_title in varchar2 default hr_api.g_varchar2,
2005: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2006: p_from_total_salary in number default hr_api.g_number,
2007: p_functional_class in varchar2 default hr_api.g_varchar2,
2008: p_notepad in varchar2 default hr_api.g_varchar2,

Line 2005: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,

2001: p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
2002: p_from_position_number in varchar2 default hr_api.g_varchar2,
2003: p_from_position_seq_no in number default hr_api.g_number,
2004: p_from_position_title in varchar2 default hr_api.g_varchar2,
2005: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2006: p_from_total_salary in number default hr_api.g_number,
2007: p_functional_class in varchar2 default hr_api.g_varchar2,
2008: p_notepad in varchar2 default hr_api.g_varchar2,
2009: p_part_time_hours in number default hr_api.g_number,

Line 2006: p_from_total_salary in number default hr_api.g_number,

2002: p_from_position_number in varchar2 default hr_api.g_varchar2,
2003: p_from_position_seq_no in number default hr_api.g_number,
2004: p_from_position_title in varchar2 default hr_api.g_varchar2,
2005: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2006: p_from_total_salary in number default hr_api.g_number,
2007: p_functional_class in varchar2 default hr_api.g_varchar2,
2008: p_notepad in varchar2 default hr_api.g_varchar2,
2009: p_part_time_hours in number default hr_api.g_number,
2010: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,

Line 2007: p_functional_class in varchar2 default hr_api.g_varchar2,

2003: p_from_position_seq_no in number default hr_api.g_number,
2004: p_from_position_title in varchar2 default hr_api.g_varchar2,
2005: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2006: p_from_total_salary in number default hr_api.g_number,
2007: p_functional_class in varchar2 default hr_api.g_varchar2,
2008: p_notepad in varchar2 default hr_api.g_varchar2,
2009: p_part_time_hours in number default hr_api.g_number,
2010: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2011: p_person_id in number default hr_api.g_number,

Line 2008: p_notepad in varchar2 default hr_api.g_varchar2,

2004: p_from_position_title in varchar2 default hr_api.g_varchar2,
2005: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2006: p_from_total_salary in number default hr_api.g_number,
2007: p_functional_class in varchar2 default hr_api.g_varchar2,
2008: p_notepad in varchar2 default hr_api.g_varchar2,
2009: p_part_time_hours in number default hr_api.g_number,
2010: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2011: p_person_id in number default hr_api.g_number,
2012: p_position_occupied in varchar2 default hr_api.g_varchar2,

Line 2009: p_part_time_hours in number default hr_api.g_number,

2005: p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
2006: p_from_total_salary in number default hr_api.g_number,
2007: p_functional_class in varchar2 default hr_api.g_varchar2,
2008: p_notepad in varchar2 default hr_api.g_varchar2,
2009: p_part_time_hours in number default hr_api.g_number,
2010: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2011: p_person_id in number default hr_api.g_number,
2012: p_position_occupied in varchar2 default hr_api.g_varchar2,
2013: p_proposed_effective_date in date default hr_api.g_date,

Line 2010: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,

2006: p_from_total_salary in number default hr_api.g_number,
2007: p_functional_class in varchar2 default hr_api.g_varchar2,
2008: p_notepad in varchar2 default hr_api.g_varchar2,
2009: p_part_time_hours in number default hr_api.g_number,
2010: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2011: p_person_id in number default hr_api.g_number,
2012: p_position_occupied in varchar2 default hr_api.g_varchar2,
2013: p_proposed_effective_date in date default hr_api.g_date,
2014: p_requested_by_person_id in number default hr_api.g_number,

Line 2011: p_person_id in number default hr_api.g_number,

2007: p_functional_class in varchar2 default hr_api.g_varchar2,
2008: p_notepad in varchar2 default hr_api.g_varchar2,
2009: p_part_time_hours in number default hr_api.g_number,
2010: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2011: p_person_id in number default hr_api.g_number,
2012: p_position_occupied in varchar2 default hr_api.g_varchar2,
2013: p_proposed_effective_date in date default hr_api.g_date,
2014: p_requested_by_person_id in number default hr_api.g_number,
2015: p_requested_by_title in varchar2 default hr_api.g_varchar2,

Line 2012: p_position_occupied in varchar2 default hr_api.g_varchar2,

2008: p_notepad in varchar2 default hr_api.g_varchar2,
2009: p_part_time_hours in number default hr_api.g_number,
2010: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2011: p_person_id in number default hr_api.g_number,
2012: p_position_occupied in varchar2 default hr_api.g_varchar2,
2013: p_proposed_effective_date in date default hr_api.g_date,
2014: p_requested_by_person_id in number default hr_api.g_number,
2015: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2016: p_requested_date in date default hr_api.g_date,

Line 2013: p_proposed_effective_date in date default hr_api.g_date,

2009: p_part_time_hours in number default hr_api.g_number,
2010: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2011: p_person_id in number default hr_api.g_number,
2012: p_position_occupied in varchar2 default hr_api.g_varchar2,
2013: p_proposed_effective_date in date default hr_api.g_date,
2014: p_requested_by_person_id in number default hr_api.g_number,
2015: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2016: p_requested_date in date default hr_api.g_date,
2017: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,

Line 2014: p_requested_by_person_id in number default hr_api.g_number,

2010: p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
2011: p_person_id in number default hr_api.g_number,
2012: p_position_occupied in varchar2 default hr_api.g_varchar2,
2013: p_proposed_effective_date in date default hr_api.g_date,
2014: p_requested_by_person_id in number default hr_api.g_number,
2015: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2016: p_requested_date in date default hr_api.g_date,
2017: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2018: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,

Line 2015: p_requested_by_title in varchar2 default hr_api.g_varchar2,

2011: p_person_id in number default hr_api.g_number,
2012: p_position_occupied in varchar2 default hr_api.g_varchar2,
2013: p_proposed_effective_date in date default hr_api.g_date,
2014: p_requested_by_person_id in number default hr_api.g_number,
2015: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2016: p_requested_date in date default hr_api.g_date,
2017: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2018: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2019: p_request_number in varchar2 default hr_api.g_varchar2,

Line 2016: p_requested_date in date default hr_api.g_date,

2012: p_position_occupied in varchar2 default hr_api.g_varchar2,
2013: p_proposed_effective_date in date default hr_api.g_date,
2014: p_requested_by_person_id in number default hr_api.g_number,
2015: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2016: p_requested_date in date default hr_api.g_date,
2017: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2018: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2019: p_request_number in varchar2 default hr_api.g_varchar2,
2020: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,

Line 2017: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,

2013: p_proposed_effective_date in date default hr_api.g_date,
2014: p_requested_by_person_id in number default hr_api.g_number,
2015: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2016: p_requested_date in date default hr_api.g_date,
2017: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2018: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2019: p_request_number in varchar2 default hr_api.g_varchar2,
2020: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2021: p_retirement_plan in varchar2 default hr_api.g_varchar2,

Line 2018: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,

2014: p_requested_by_person_id in number default hr_api.g_number,
2015: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2016: p_requested_date in date default hr_api.g_date,
2017: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2018: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2019: p_request_number in varchar2 default hr_api.g_varchar2,
2020: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2021: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2022: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,

Line 2019: p_request_number in varchar2 default hr_api.g_varchar2,

2015: p_requested_by_title in varchar2 default hr_api.g_varchar2,
2016: p_requested_date in date default hr_api.g_date,
2017: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2018: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2019: p_request_number in varchar2 default hr_api.g_varchar2,
2020: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2021: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2022: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2023: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,

Line 2020: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,

2016: p_requested_date in date default hr_api.g_date,
2017: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2018: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2019: p_request_number in varchar2 default hr_api.g_varchar2,
2020: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2021: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2022: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2023: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2024: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,

Line 2021: p_retirement_plan in varchar2 default hr_api.g_varchar2,

2017: p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
2018: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2019: p_request_number in varchar2 default hr_api.g_varchar2,
2020: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2021: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2022: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2023: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2024: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2025: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,

Line 2022: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,

2018: p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
2019: p_request_number in varchar2 default hr_api.g_varchar2,
2020: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2021: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2022: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2023: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2024: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2025: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2026: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,

Line 2023: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,

2019: p_request_number in varchar2 default hr_api.g_varchar2,
2020: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2021: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2022: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2023: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2024: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2025: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2026: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,

Line 2024: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,

2020: p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
2021: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2022: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2023: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2024: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2025: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2026: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2028: p_second_noa_code in varchar2 default hr_api.g_varchar2,

Line 2025: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,

2021: p_retirement_plan in varchar2 default hr_api.g_varchar2,
2022: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2023: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2024: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2025: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2026: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2028: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2029: p_second_noa_desc in varchar2 default hr_api.g_varchar2,

Line 2026: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,

2022: p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
2023: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2024: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2025: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2026: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2028: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2029: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2030: p_second_noa_id in number default hr_api.g_number,

Line 2027: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,

2023: p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
2024: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2025: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2026: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2028: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2029: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2030: p_second_noa_id in number default hr_api.g_number,
2031: p_second_noa_pa_request_id in number default hr_api.g_number,

Line 2028: p_second_noa_code in varchar2 default hr_api.g_varchar2,

2024: p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
2025: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2026: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2028: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2029: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2030: p_second_noa_id in number default hr_api.g_number,
2031: p_second_noa_pa_request_id in number default hr_api.g_number,
2032: p_service_comp_date in date default hr_api.g_date,

Line 2029: p_second_noa_desc in varchar2 default hr_api.g_varchar2,

2025: p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
2026: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2028: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2029: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2030: p_second_noa_id in number default hr_api.g_number,
2031: p_second_noa_pa_request_id in number default hr_api.g_number,
2032: p_service_comp_date in date default hr_api.g_date,
2033: p_supervisory_status in varchar2 default hr_api.g_varchar2,

Line 2030: p_second_noa_id in number default hr_api.g_number,

2026: p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
2027: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2028: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2029: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2030: p_second_noa_id in number default hr_api.g_number,
2031: p_second_noa_pa_request_id in number default hr_api.g_number,
2032: p_service_comp_date in date default hr_api.g_date,
2033: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2034: p_tenure in varchar2 default hr_api.g_varchar2,

Line 2031: p_second_noa_pa_request_id in number default hr_api.g_number,

2027: p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
2028: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2029: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2030: p_second_noa_id in number default hr_api.g_number,
2031: p_second_noa_pa_request_id in number default hr_api.g_number,
2032: p_service_comp_date in date default hr_api.g_date,
2033: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2034: p_tenure in varchar2 default hr_api.g_varchar2,
2035: p_to_adj_basic_pay in number default hr_api.g_number,

Line 2032: p_service_comp_date in date default hr_api.g_date,

2028: p_second_noa_code in varchar2 default hr_api.g_varchar2,
2029: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2030: p_second_noa_id in number default hr_api.g_number,
2031: p_second_noa_pa_request_id in number default hr_api.g_number,
2032: p_service_comp_date in date default hr_api.g_date,
2033: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2034: p_tenure in varchar2 default hr_api.g_varchar2,
2035: p_to_adj_basic_pay in number default hr_api.g_number,
2036: p_to_basic_pay in number default hr_api.g_number,

Line 2033: p_supervisory_status in varchar2 default hr_api.g_varchar2,

2029: p_second_noa_desc in varchar2 default hr_api.g_varchar2,
2030: p_second_noa_id in number default hr_api.g_number,
2031: p_second_noa_pa_request_id in number default hr_api.g_number,
2032: p_service_comp_date in date default hr_api.g_date,
2033: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2034: p_tenure in varchar2 default hr_api.g_varchar2,
2035: p_to_adj_basic_pay in number default hr_api.g_number,
2036: p_to_basic_pay in number default hr_api.g_number,
2037: p_to_grade_id in number default hr_api.g_number,

Line 2034: p_tenure in varchar2 default hr_api.g_varchar2,

2030: p_second_noa_id in number default hr_api.g_number,
2031: p_second_noa_pa_request_id in number default hr_api.g_number,
2032: p_service_comp_date in date default hr_api.g_date,
2033: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2034: p_tenure in varchar2 default hr_api.g_varchar2,
2035: p_to_adj_basic_pay in number default hr_api.g_number,
2036: p_to_basic_pay in number default hr_api.g_number,
2037: p_to_grade_id in number default hr_api.g_number,
2038: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,

Line 2035: p_to_adj_basic_pay in number default hr_api.g_number,

2031: p_second_noa_pa_request_id in number default hr_api.g_number,
2032: p_service_comp_date in date default hr_api.g_date,
2033: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2034: p_tenure in varchar2 default hr_api.g_varchar2,
2035: p_to_adj_basic_pay in number default hr_api.g_number,
2036: p_to_basic_pay in number default hr_api.g_number,
2037: p_to_grade_id in number default hr_api.g_number,
2038: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2039: p_to_job_id in number default hr_api.g_number,

Line 2036: p_to_basic_pay in number default hr_api.g_number,

2032: p_service_comp_date in date default hr_api.g_date,
2033: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2034: p_tenure in varchar2 default hr_api.g_varchar2,
2035: p_to_adj_basic_pay in number default hr_api.g_number,
2036: p_to_basic_pay in number default hr_api.g_number,
2037: p_to_grade_id in number default hr_api.g_number,
2038: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2039: p_to_job_id in number default hr_api.g_number,
2040: p_to_locality_adj in number default hr_api.g_number,

Line 2037: p_to_grade_id in number default hr_api.g_number,

2033: p_supervisory_status in varchar2 default hr_api.g_varchar2,
2034: p_tenure in varchar2 default hr_api.g_varchar2,
2035: p_to_adj_basic_pay in number default hr_api.g_number,
2036: p_to_basic_pay in number default hr_api.g_number,
2037: p_to_grade_id in number default hr_api.g_number,
2038: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2039: p_to_job_id in number default hr_api.g_number,
2040: p_to_locality_adj in number default hr_api.g_number,
2041: p_to_occ_code in varchar2 default hr_api.g_varchar2,

Line 2038: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,

2034: p_tenure in varchar2 default hr_api.g_varchar2,
2035: p_to_adj_basic_pay in number default hr_api.g_number,
2036: p_to_basic_pay in number default hr_api.g_number,
2037: p_to_grade_id in number default hr_api.g_number,
2038: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2039: p_to_job_id in number default hr_api.g_number,
2040: p_to_locality_adj in number default hr_api.g_number,
2041: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2042: p_to_organization_id in number default hr_api.g_number,

Line 2039: p_to_job_id in number default hr_api.g_number,

2035: p_to_adj_basic_pay in number default hr_api.g_number,
2036: p_to_basic_pay in number default hr_api.g_number,
2037: p_to_grade_id in number default hr_api.g_number,
2038: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2039: p_to_job_id in number default hr_api.g_number,
2040: p_to_locality_adj in number default hr_api.g_number,
2041: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2042: p_to_organization_id in number default hr_api.g_number,
2043: p_to_other_pay_amount in number default hr_api.g_number,

Line 2040: p_to_locality_adj in number default hr_api.g_number,

2036: p_to_basic_pay in number default hr_api.g_number,
2037: p_to_grade_id in number default hr_api.g_number,
2038: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2039: p_to_job_id in number default hr_api.g_number,
2040: p_to_locality_adj in number default hr_api.g_number,
2041: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2042: p_to_organization_id in number default hr_api.g_number,
2043: p_to_other_pay_amount in number default hr_api.g_number,
2044: p_to_au_overtime in number default hr_api.g_number,

Line 2041: p_to_occ_code in varchar2 default hr_api.g_varchar2,

2037: p_to_grade_id in number default hr_api.g_number,
2038: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2039: p_to_job_id in number default hr_api.g_number,
2040: p_to_locality_adj in number default hr_api.g_number,
2041: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2042: p_to_organization_id in number default hr_api.g_number,
2043: p_to_other_pay_amount in number default hr_api.g_number,
2044: p_to_au_overtime in number default hr_api.g_number,
2045: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,

Line 2042: p_to_organization_id in number default hr_api.g_number,

2038: p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
2039: p_to_job_id in number default hr_api.g_number,
2040: p_to_locality_adj in number default hr_api.g_number,
2041: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2042: p_to_organization_id in number default hr_api.g_number,
2043: p_to_other_pay_amount in number default hr_api.g_number,
2044: p_to_au_overtime in number default hr_api.g_number,
2045: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2046: p_to_availability_pay in number default hr_api.g_number,

Line 2043: p_to_other_pay_amount in number default hr_api.g_number,

2039: p_to_job_id in number default hr_api.g_number,
2040: p_to_locality_adj in number default hr_api.g_number,
2041: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2042: p_to_organization_id in number default hr_api.g_number,
2043: p_to_other_pay_amount in number default hr_api.g_number,
2044: p_to_au_overtime in number default hr_api.g_number,
2045: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2046: p_to_availability_pay in number default hr_api.g_number,
2047: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,

Line 2044: p_to_au_overtime in number default hr_api.g_number,

2040: p_to_locality_adj in number default hr_api.g_number,
2041: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2042: p_to_organization_id in number default hr_api.g_number,
2043: p_to_other_pay_amount in number default hr_api.g_number,
2044: p_to_au_overtime in number default hr_api.g_number,
2045: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2046: p_to_availability_pay in number default hr_api.g_number,
2047: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2048: p_to_retention_allowance in number default hr_api.g_number,

Line 2045: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,

2041: p_to_occ_code in varchar2 default hr_api.g_varchar2,
2042: p_to_organization_id in number default hr_api.g_number,
2043: p_to_other_pay_amount in number default hr_api.g_number,
2044: p_to_au_overtime in number default hr_api.g_number,
2045: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2046: p_to_availability_pay in number default hr_api.g_number,
2047: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2048: p_to_retention_allowance in number default hr_api.g_number,
2049: p_to_supervisory_differential in number default hr_api.g_number,

Line 2046: p_to_availability_pay in number default hr_api.g_number,

2042: p_to_organization_id in number default hr_api.g_number,
2043: p_to_other_pay_amount in number default hr_api.g_number,
2044: p_to_au_overtime in number default hr_api.g_number,
2045: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2046: p_to_availability_pay in number default hr_api.g_number,
2047: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2048: p_to_retention_allowance in number default hr_api.g_number,
2049: p_to_supervisory_differential in number default hr_api.g_number,
2050: p_to_staffing_differential in number default hr_api.g_number,

Line 2047: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,

2043: p_to_other_pay_amount in number default hr_api.g_number,
2044: p_to_au_overtime in number default hr_api.g_number,
2045: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2046: p_to_availability_pay in number default hr_api.g_number,
2047: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2048: p_to_retention_allowance in number default hr_api.g_number,
2049: p_to_supervisory_differential in number default hr_api.g_number,
2050: p_to_staffing_differential in number default hr_api.g_number,
2051: p_to_pay_basis in varchar2 default hr_api.g_varchar2,

Line 2048: p_to_retention_allowance in number default hr_api.g_number,

2044: p_to_au_overtime in number default hr_api.g_number,
2045: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2046: p_to_availability_pay in number default hr_api.g_number,
2047: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2048: p_to_retention_allowance in number default hr_api.g_number,
2049: p_to_supervisory_differential in number default hr_api.g_number,
2050: p_to_staffing_differential in number default hr_api.g_number,
2051: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
2052: p_to_pay_plan in varchar2 default hr_api.g_varchar2,

Line 2049: p_to_supervisory_differential in number default hr_api.g_number,

2045: p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2046: p_to_availability_pay in number default hr_api.g_number,
2047: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2048: p_to_retention_allowance in number default hr_api.g_number,
2049: p_to_supervisory_differential in number default hr_api.g_number,
2050: p_to_staffing_differential in number default hr_api.g_number,
2051: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
2052: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
2053: -- FWFA Changes Bug#4444609

Line 2050: p_to_staffing_differential in number default hr_api.g_number,

2046: p_to_availability_pay in number default hr_api.g_number,
2047: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2048: p_to_retention_allowance in number default hr_api.g_number,
2049: p_to_supervisory_differential in number default hr_api.g_number,
2050: p_to_staffing_differential in number default hr_api.g_number,
2051: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
2052: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
2053: -- FWFA Changes Bug#4444609
2054: p_to_pay_table_identifier in number default hr_api.g_number,

Line 2051: p_to_pay_basis in varchar2 default hr_api.g_varchar2,

2047: p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
2048: p_to_retention_allowance in number default hr_api.g_number,
2049: p_to_supervisory_differential in number default hr_api.g_number,
2050: p_to_staffing_differential in number default hr_api.g_number,
2051: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
2052: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
2053: -- FWFA Changes Bug#4444609
2054: p_to_pay_table_identifier in number default hr_api.g_number,
2055: -- FWFA Changes

Line 2052: p_to_pay_plan in varchar2 default hr_api.g_varchar2,

2048: p_to_retention_allowance in number default hr_api.g_number,
2049: p_to_supervisory_differential in number default hr_api.g_number,
2050: p_to_staffing_differential in number default hr_api.g_number,
2051: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
2052: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
2053: -- FWFA Changes Bug#4444609
2054: p_to_pay_table_identifier in number default hr_api.g_number,
2055: -- FWFA Changes
2056: p_to_position_id in number default hr_api.g_number,

Line 2054: p_to_pay_table_identifier in number default hr_api.g_number,

2050: p_to_staffing_differential in number default hr_api.g_number,
2051: p_to_pay_basis in varchar2 default hr_api.g_varchar2,
2052: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
2053: -- FWFA Changes Bug#4444609
2054: p_to_pay_table_identifier in number default hr_api.g_number,
2055: -- FWFA Changes
2056: p_to_position_id in number default hr_api.g_number,
2057: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2058: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,

Line 2056: p_to_position_id in number default hr_api.g_number,

2052: p_to_pay_plan in varchar2 default hr_api.g_varchar2,
2053: -- FWFA Changes Bug#4444609
2054: p_to_pay_table_identifier in number default hr_api.g_number,
2055: -- FWFA Changes
2056: p_to_position_id in number default hr_api.g_number,
2057: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2058: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2059: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2060: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,

Line 2057: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,

2053: -- FWFA Changes Bug#4444609
2054: p_to_pay_table_identifier in number default hr_api.g_number,
2055: -- FWFA Changes
2056: p_to_position_id in number default hr_api.g_number,
2057: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2058: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2059: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2060: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2061: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,

Line 2058: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,

2054: p_to_pay_table_identifier in number default hr_api.g_number,
2055: -- FWFA Changes
2056: p_to_position_id in number default hr_api.g_number,
2057: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2058: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2059: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2060: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2061: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2062: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,

Line 2059: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,

2055: -- FWFA Changes
2056: p_to_position_id in number default hr_api.g_number,
2057: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2058: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2059: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2060: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2061: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2062: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2063: p_to_position_number in varchar2 default hr_api.g_varchar2,

Line 2060: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,

2056: p_to_position_id in number default hr_api.g_number,
2057: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2058: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2059: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2060: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2061: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2062: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2063: p_to_position_number in varchar2 default hr_api.g_varchar2,
2064: p_to_position_seq_no in number default hr_api.g_number,

Line 2061: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,

2057: p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
2058: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2059: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2060: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2061: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2062: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2063: p_to_position_number in varchar2 default hr_api.g_varchar2,
2064: p_to_position_seq_no in number default hr_api.g_number,
2065: p_to_position_title in varchar2 default hr_api.g_varchar2,

Line 2062: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,

2058: p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
2059: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2060: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2061: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2062: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2063: p_to_position_number in varchar2 default hr_api.g_varchar2,
2064: p_to_position_seq_no in number default hr_api.g_number,
2065: p_to_position_title in varchar2 default hr_api.g_varchar2,
2066: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,

Line 2063: p_to_position_number in varchar2 default hr_api.g_varchar2,

2059: p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
2060: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2061: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2062: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2063: p_to_position_number in varchar2 default hr_api.g_varchar2,
2064: p_to_position_seq_no in number default hr_api.g_number,
2065: p_to_position_title in varchar2 default hr_api.g_varchar2,
2066: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2067: p_to_total_salary in number default hr_api.g_number,

Line 2064: p_to_position_seq_no in number default hr_api.g_number,

2060: p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
2061: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2062: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2063: p_to_position_number in varchar2 default hr_api.g_varchar2,
2064: p_to_position_seq_no in number default hr_api.g_number,
2065: p_to_position_title in varchar2 default hr_api.g_varchar2,
2066: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2067: p_to_total_salary in number default hr_api.g_number,
2068: p_veterans_preference in varchar2 default hr_api.g_varchar2,

Line 2065: p_to_position_title in varchar2 default hr_api.g_varchar2,

2061: p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
2062: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2063: p_to_position_number in varchar2 default hr_api.g_varchar2,
2064: p_to_position_seq_no in number default hr_api.g_number,
2065: p_to_position_title in varchar2 default hr_api.g_varchar2,
2066: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2067: p_to_total_salary in number default hr_api.g_number,
2068: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2069: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,

Line 2066: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,

2062: p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
2063: p_to_position_number in varchar2 default hr_api.g_varchar2,
2064: p_to_position_seq_no in number default hr_api.g_number,
2065: p_to_position_title in varchar2 default hr_api.g_varchar2,
2066: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2067: p_to_total_salary in number default hr_api.g_number,
2068: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2069: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2070: p_veterans_status in varchar2 default hr_api.g_varchar2,

Line 2067: p_to_total_salary in number default hr_api.g_number,

2063: p_to_position_number in varchar2 default hr_api.g_varchar2,
2064: p_to_position_seq_no in number default hr_api.g_number,
2065: p_to_position_title in varchar2 default hr_api.g_varchar2,
2066: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2067: p_to_total_salary in number default hr_api.g_number,
2068: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2069: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2070: p_veterans_status in varchar2 default hr_api.g_varchar2,
2071: p_work_schedule in varchar2 default hr_api.g_varchar2,

Line 2068: p_veterans_preference in varchar2 default hr_api.g_varchar2,

2064: p_to_position_seq_no in number default hr_api.g_number,
2065: p_to_position_title in varchar2 default hr_api.g_varchar2,
2066: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2067: p_to_total_salary in number default hr_api.g_number,
2068: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2069: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2070: p_veterans_status in varchar2 default hr_api.g_varchar2,
2071: p_work_schedule in varchar2 default hr_api.g_varchar2,
2072: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,

Line 2069: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,

2065: p_to_position_title in varchar2 default hr_api.g_varchar2,
2066: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2067: p_to_total_salary in number default hr_api.g_number,
2068: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2069: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2070: p_veterans_status in varchar2 default hr_api.g_varchar2,
2071: p_work_schedule in varchar2 default hr_api.g_varchar2,
2072: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2073: p_year_degree_attained in number default hr_api.g_number,

Line 2070: p_veterans_status in varchar2 default hr_api.g_varchar2,

2066: p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2067: p_to_total_salary in number default hr_api.g_number,
2068: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2069: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2070: p_veterans_status in varchar2 default hr_api.g_varchar2,
2071: p_work_schedule in varchar2 default hr_api.g_varchar2,
2072: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2073: p_year_degree_attained in number default hr_api.g_number,
2074: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,

Line 2071: p_work_schedule in varchar2 default hr_api.g_varchar2,

2067: p_to_total_salary in number default hr_api.g_number,
2068: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2069: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2070: p_veterans_status in varchar2 default hr_api.g_varchar2,
2071: p_work_schedule in varchar2 default hr_api.g_varchar2,
2072: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2073: p_year_degree_attained in number default hr_api.g_number,
2074: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2075: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,

Line 2072: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,

2068: p_veterans_preference in varchar2 default hr_api.g_varchar2,
2069: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2070: p_veterans_status in varchar2 default hr_api.g_varchar2,
2071: p_work_schedule in varchar2 default hr_api.g_varchar2,
2072: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2073: p_year_degree_attained in number default hr_api.g_number,
2074: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2075: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2076: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,

Line 2073: p_year_degree_attained in number default hr_api.g_number,

2069: p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2070: p_veterans_status in varchar2 default hr_api.g_varchar2,
2071: p_work_schedule in varchar2 default hr_api.g_varchar2,
2072: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2073: p_year_degree_attained in number default hr_api.g_number,
2074: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2075: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2076: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2077: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,

Line 2074: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,

2070: p_veterans_status in varchar2 default hr_api.g_varchar2,
2071: p_work_schedule in varchar2 default hr_api.g_varchar2,
2072: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2073: p_year_degree_attained in number default hr_api.g_number,
2074: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2075: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2076: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2077: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2078: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,

Line 2075: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,

2071: p_work_schedule in varchar2 default hr_api.g_varchar2,
2072: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2073: p_year_degree_attained in number default hr_api.g_number,
2074: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2075: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2076: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2077: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2078: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2079: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,

Line 2076: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,

2072: p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2073: p_year_degree_attained in number default hr_api.g_number,
2074: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2075: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2076: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2077: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2078: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2079: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2080: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,

Line 2077: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,

2073: p_year_degree_attained in number default hr_api.g_number,
2074: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2075: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2076: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2077: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2078: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2079: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2080: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2081: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,

Line 2078: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,

2074: p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2075: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2076: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2077: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2078: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2079: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2080: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2081: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2082: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,

Line 2079: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,

2075: p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2076: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2077: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2078: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2079: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2080: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2081: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2082: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2083: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,

Line 2080: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,

2076: p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2077: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2078: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2079: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2080: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2081: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2082: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2083: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2084: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,

Line 2081: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,

2077: p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2078: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2079: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2080: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2081: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2082: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2083: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2084: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2085: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,

Line 2082: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,

2078: p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2079: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2080: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2081: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2082: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2083: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2084: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2085: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2086: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,

Line 2083: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,

2079: p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2080: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2081: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2082: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2083: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2084: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2085: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2086: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2087: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,

Line 2084: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,

2080: p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2081: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2082: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2083: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2084: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2085: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2086: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2087: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2088: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,

Line 2085: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,

2081: p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2082: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2083: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2084: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2085: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2086: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2087: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2088: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2089: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,

Line 2086: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,

2082: p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2083: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2084: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2085: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2086: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2087: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2088: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2089: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2090: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,

Line 2087: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,

2083: p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2084: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2085: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2086: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2087: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2088: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2089: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2090: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2091: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,

Line 2088: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,

2084: p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2085: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2086: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2087: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2088: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2089: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2090: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2091: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2092: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,

Line 2089: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,

2085: p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2086: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2087: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2088: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2089: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2090: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2091: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2092: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2093: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,

Line 2090: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,

2086: p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2087: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2088: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2089: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2090: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2091: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2092: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2093: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2094: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,

Line 2091: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,

2087: p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2088: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2089: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2090: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2091: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2092: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2093: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2094: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2095: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,

Line 2092: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,

2088: p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2089: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2090: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2091: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2092: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2093: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2094: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2095: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2096: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,

Line 2093: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,

2089: p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2090: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2091: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2092: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2093: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2094: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2095: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2096: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2097: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,

Line 2094: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,

2090: p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2091: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2092: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2093: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2094: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2095: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2096: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2097: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2098: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,

Line 2095: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,

2091: p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2092: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2093: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2094: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2095: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2096: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2097: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2098: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2099: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,

Line 2096: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,

2092: p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2093: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2094: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2095: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2096: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2097: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2098: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2099: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2100: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,

Line 2097: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,

2093: p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2094: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2095: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2096: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2097: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2098: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2099: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2100: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2101: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,

Line 2098: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,

2094: p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2095: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2096: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2097: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2098: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2099: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2100: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2101: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2102: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,

Line 2099: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,

2095: p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2096: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2097: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2098: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2099: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2100: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2101: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2102: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2103: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,

Line 2100: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,

2096: p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2097: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2098: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2099: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2100: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2101: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2102: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2103: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2104: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 2101: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,

2097: p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2098: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2099: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2100: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2101: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2102: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2103: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2104: p_attribute_category in varchar2 default hr_api.g_varchar2,
2105: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 2102: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,

2098: p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2099: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2100: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2101: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2102: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2103: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2104: p_attribute_category in varchar2 default hr_api.g_varchar2,
2105: p_attribute1 in varchar2 default hr_api.g_varchar2,
2106: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 2103: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,

2099: p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2100: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2101: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2102: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2103: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2104: p_attribute_category in varchar2 default hr_api.g_varchar2,
2105: p_attribute1 in varchar2 default hr_api.g_varchar2,
2106: p_attribute2 in varchar2 default hr_api.g_varchar2,
2107: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 2104: p_attribute_category in varchar2 default hr_api.g_varchar2,

2100: p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2101: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2102: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2103: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2104: p_attribute_category in varchar2 default hr_api.g_varchar2,
2105: p_attribute1 in varchar2 default hr_api.g_varchar2,
2106: p_attribute2 in varchar2 default hr_api.g_varchar2,
2107: p_attribute3 in varchar2 default hr_api.g_varchar2,
2108: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 2105: p_attribute1 in varchar2 default hr_api.g_varchar2,

2101: p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2102: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2103: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2104: p_attribute_category in varchar2 default hr_api.g_varchar2,
2105: p_attribute1 in varchar2 default hr_api.g_varchar2,
2106: p_attribute2 in varchar2 default hr_api.g_varchar2,
2107: p_attribute3 in varchar2 default hr_api.g_varchar2,
2108: p_attribute4 in varchar2 default hr_api.g_varchar2,
2109: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 2106: p_attribute2 in varchar2 default hr_api.g_varchar2,

2102: p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2103: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2104: p_attribute_category in varchar2 default hr_api.g_varchar2,
2105: p_attribute1 in varchar2 default hr_api.g_varchar2,
2106: p_attribute2 in varchar2 default hr_api.g_varchar2,
2107: p_attribute3 in varchar2 default hr_api.g_varchar2,
2108: p_attribute4 in varchar2 default hr_api.g_varchar2,
2109: p_attribute5 in varchar2 default hr_api.g_varchar2,
2110: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 2107: p_attribute3 in varchar2 default hr_api.g_varchar2,

2103: p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2104: p_attribute_category in varchar2 default hr_api.g_varchar2,
2105: p_attribute1 in varchar2 default hr_api.g_varchar2,
2106: p_attribute2 in varchar2 default hr_api.g_varchar2,
2107: p_attribute3 in varchar2 default hr_api.g_varchar2,
2108: p_attribute4 in varchar2 default hr_api.g_varchar2,
2109: p_attribute5 in varchar2 default hr_api.g_varchar2,
2110: p_attribute6 in varchar2 default hr_api.g_varchar2,
2111: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 2108: p_attribute4 in varchar2 default hr_api.g_varchar2,

2104: p_attribute_category in varchar2 default hr_api.g_varchar2,
2105: p_attribute1 in varchar2 default hr_api.g_varchar2,
2106: p_attribute2 in varchar2 default hr_api.g_varchar2,
2107: p_attribute3 in varchar2 default hr_api.g_varchar2,
2108: p_attribute4 in varchar2 default hr_api.g_varchar2,
2109: p_attribute5 in varchar2 default hr_api.g_varchar2,
2110: p_attribute6 in varchar2 default hr_api.g_varchar2,
2111: p_attribute7 in varchar2 default hr_api.g_varchar2,
2112: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 2109: p_attribute5 in varchar2 default hr_api.g_varchar2,

2105: p_attribute1 in varchar2 default hr_api.g_varchar2,
2106: p_attribute2 in varchar2 default hr_api.g_varchar2,
2107: p_attribute3 in varchar2 default hr_api.g_varchar2,
2108: p_attribute4 in varchar2 default hr_api.g_varchar2,
2109: p_attribute5 in varchar2 default hr_api.g_varchar2,
2110: p_attribute6 in varchar2 default hr_api.g_varchar2,
2111: p_attribute7 in varchar2 default hr_api.g_varchar2,
2112: p_attribute8 in varchar2 default hr_api.g_varchar2,
2113: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 2110: p_attribute6 in varchar2 default hr_api.g_varchar2,

2106: p_attribute2 in varchar2 default hr_api.g_varchar2,
2107: p_attribute3 in varchar2 default hr_api.g_varchar2,
2108: p_attribute4 in varchar2 default hr_api.g_varchar2,
2109: p_attribute5 in varchar2 default hr_api.g_varchar2,
2110: p_attribute6 in varchar2 default hr_api.g_varchar2,
2111: p_attribute7 in varchar2 default hr_api.g_varchar2,
2112: p_attribute8 in varchar2 default hr_api.g_varchar2,
2113: p_attribute9 in varchar2 default hr_api.g_varchar2,
2114: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 2111: p_attribute7 in varchar2 default hr_api.g_varchar2,

2107: p_attribute3 in varchar2 default hr_api.g_varchar2,
2108: p_attribute4 in varchar2 default hr_api.g_varchar2,
2109: p_attribute5 in varchar2 default hr_api.g_varchar2,
2110: p_attribute6 in varchar2 default hr_api.g_varchar2,
2111: p_attribute7 in varchar2 default hr_api.g_varchar2,
2112: p_attribute8 in varchar2 default hr_api.g_varchar2,
2113: p_attribute9 in varchar2 default hr_api.g_varchar2,
2114: p_attribute10 in varchar2 default hr_api.g_varchar2,
2115: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 2112: p_attribute8 in varchar2 default hr_api.g_varchar2,

2108: p_attribute4 in varchar2 default hr_api.g_varchar2,
2109: p_attribute5 in varchar2 default hr_api.g_varchar2,
2110: p_attribute6 in varchar2 default hr_api.g_varchar2,
2111: p_attribute7 in varchar2 default hr_api.g_varchar2,
2112: p_attribute8 in varchar2 default hr_api.g_varchar2,
2113: p_attribute9 in varchar2 default hr_api.g_varchar2,
2114: p_attribute10 in varchar2 default hr_api.g_varchar2,
2115: p_attribute11 in varchar2 default hr_api.g_varchar2,
2116: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 2113: p_attribute9 in varchar2 default hr_api.g_varchar2,

2109: p_attribute5 in varchar2 default hr_api.g_varchar2,
2110: p_attribute6 in varchar2 default hr_api.g_varchar2,
2111: p_attribute7 in varchar2 default hr_api.g_varchar2,
2112: p_attribute8 in varchar2 default hr_api.g_varchar2,
2113: p_attribute9 in varchar2 default hr_api.g_varchar2,
2114: p_attribute10 in varchar2 default hr_api.g_varchar2,
2115: p_attribute11 in varchar2 default hr_api.g_varchar2,
2116: p_attribute12 in varchar2 default hr_api.g_varchar2,
2117: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 2114: p_attribute10 in varchar2 default hr_api.g_varchar2,

2110: p_attribute6 in varchar2 default hr_api.g_varchar2,
2111: p_attribute7 in varchar2 default hr_api.g_varchar2,
2112: p_attribute8 in varchar2 default hr_api.g_varchar2,
2113: p_attribute9 in varchar2 default hr_api.g_varchar2,
2114: p_attribute10 in varchar2 default hr_api.g_varchar2,
2115: p_attribute11 in varchar2 default hr_api.g_varchar2,
2116: p_attribute12 in varchar2 default hr_api.g_varchar2,
2117: p_attribute13 in varchar2 default hr_api.g_varchar2,
2118: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 2115: p_attribute11 in varchar2 default hr_api.g_varchar2,

2111: p_attribute7 in varchar2 default hr_api.g_varchar2,
2112: p_attribute8 in varchar2 default hr_api.g_varchar2,
2113: p_attribute9 in varchar2 default hr_api.g_varchar2,
2114: p_attribute10 in varchar2 default hr_api.g_varchar2,
2115: p_attribute11 in varchar2 default hr_api.g_varchar2,
2116: p_attribute12 in varchar2 default hr_api.g_varchar2,
2117: p_attribute13 in varchar2 default hr_api.g_varchar2,
2118: p_attribute14 in varchar2 default hr_api.g_varchar2,
2119: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 2116: p_attribute12 in varchar2 default hr_api.g_varchar2,

2112: p_attribute8 in varchar2 default hr_api.g_varchar2,
2113: p_attribute9 in varchar2 default hr_api.g_varchar2,
2114: p_attribute10 in varchar2 default hr_api.g_varchar2,
2115: p_attribute11 in varchar2 default hr_api.g_varchar2,
2116: p_attribute12 in varchar2 default hr_api.g_varchar2,
2117: p_attribute13 in varchar2 default hr_api.g_varchar2,
2118: p_attribute14 in varchar2 default hr_api.g_varchar2,
2119: p_attribute15 in varchar2 default hr_api.g_varchar2,
2120: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 2117: p_attribute13 in varchar2 default hr_api.g_varchar2,

2113: p_attribute9 in varchar2 default hr_api.g_varchar2,
2114: p_attribute10 in varchar2 default hr_api.g_varchar2,
2115: p_attribute11 in varchar2 default hr_api.g_varchar2,
2116: p_attribute12 in varchar2 default hr_api.g_varchar2,
2117: p_attribute13 in varchar2 default hr_api.g_varchar2,
2118: p_attribute14 in varchar2 default hr_api.g_varchar2,
2119: p_attribute15 in varchar2 default hr_api.g_varchar2,
2120: p_attribute16 in varchar2 default hr_api.g_varchar2,
2121: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 2118: p_attribute14 in varchar2 default hr_api.g_varchar2,

2114: p_attribute10 in varchar2 default hr_api.g_varchar2,
2115: p_attribute11 in varchar2 default hr_api.g_varchar2,
2116: p_attribute12 in varchar2 default hr_api.g_varchar2,
2117: p_attribute13 in varchar2 default hr_api.g_varchar2,
2118: p_attribute14 in varchar2 default hr_api.g_varchar2,
2119: p_attribute15 in varchar2 default hr_api.g_varchar2,
2120: p_attribute16 in varchar2 default hr_api.g_varchar2,
2121: p_attribute17 in varchar2 default hr_api.g_varchar2,
2122: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 2119: p_attribute15 in varchar2 default hr_api.g_varchar2,

2115: p_attribute11 in varchar2 default hr_api.g_varchar2,
2116: p_attribute12 in varchar2 default hr_api.g_varchar2,
2117: p_attribute13 in varchar2 default hr_api.g_varchar2,
2118: p_attribute14 in varchar2 default hr_api.g_varchar2,
2119: p_attribute15 in varchar2 default hr_api.g_varchar2,
2120: p_attribute16 in varchar2 default hr_api.g_varchar2,
2121: p_attribute17 in varchar2 default hr_api.g_varchar2,
2122: p_attribute18 in varchar2 default hr_api.g_varchar2,
2123: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 2120: p_attribute16 in varchar2 default hr_api.g_varchar2,

2116: p_attribute12 in varchar2 default hr_api.g_varchar2,
2117: p_attribute13 in varchar2 default hr_api.g_varchar2,
2118: p_attribute14 in varchar2 default hr_api.g_varchar2,
2119: p_attribute15 in varchar2 default hr_api.g_varchar2,
2120: p_attribute16 in varchar2 default hr_api.g_varchar2,
2121: p_attribute17 in varchar2 default hr_api.g_varchar2,
2122: p_attribute18 in varchar2 default hr_api.g_varchar2,
2123: p_attribute19 in varchar2 default hr_api.g_varchar2,
2124: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 2121: p_attribute17 in varchar2 default hr_api.g_varchar2,

2117: p_attribute13 in varchar2 default hr_api.g_varchar2,
2118: p_attribute14 in varchar2 default hr_api.g_varchar2,
2119: p_attribute15 in varchar2 default hr_api.g_varchar2,
2120: p_attribute16 in varchar2 default hr_api.g_varchar2,
2121: p_attribute17 in varchar2 default hr_api.g_varchar2,
2122: p_attribute18 in varchar2 default hr_api.g_varchar2,
2123: p_attribute19 in varchar2 default hr_api.g_varchar2,
2124: p_attribute20 in varchar2 default hr_api.g_varchar2,
2125: p_print_sf50_flag in varchar2 default 'N',

Line 2122: p_attribute18 in varchar2 default hr_api.g_varchar2,

2118: p_attribute14 in varchar2 default hr_api.g_varchar2,
2119: p_attribute15 in varchar2 default hr_api.g_varchar2,
2120: p_attribute16 in varchar2 default hr_api.g_varchar2,
2121: p_attribute17 in varchar2 default hr_api.g_varchar2,
2122: p_attribute18 in varchar2 default hr_api.g_varchar2,
2123: p_attribute19 in varchar2 default hr_api.g_varchar2,
2124: p_attribute20 in varchar2 default hr_api.g_varchar2,
2125: p_print_sf50_flag in varchar2 default 'N',
2126: p_printer_name in varchar2 default null,

Line 2123: p_attribute19 in varchar2 default hr_api.g_varchar2,

2119: p_attribute15 in varchar2 default hr_api.g_varchar2,
2120: p_attribute16 in varchar2 default hr_api.g_varchar2,
2121: p_attribute17 in varchar2 default hr_api.g_varchar2,
2122: p_attribute18 in varchar2 default hr_api.g_varchar2,
2123: p_attribute19 in varchar2 default hr_api.g_varchar2,
2124: p_attribute20 in varchar2 default hr_api.g_varchar2,
2125: p_print_sf50_flag in varchar2 default 'N',
2126: p_printer_name in varchar2 default null,
2127: p_print_back_page in varchar2 default 'Y',

Line 2124: p_attribute20 in varchar2 default hr_api.g_varchar2,

2120: p_attribute16 in varchar2 default hr_api.g_varchar2,
2121: p_attribute17 in varchar2 default hr_api.g_varchar2,
2122: p_attribute18 in varchar2 default hr_api.g_varchar2,
2123: p_attribute19 in varchar2 default hr_api.g_varchar2,
2124: p_attribute20 in varchar2 default hr_api.g_varchar2,
2125: p_print_sf50_flag in varchar2 default 'N',
2126: p_printer_name in varchar2 default null,
2127: p_print_back_page in varchar2 default 'Y',
2128: p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,

Line 2128: p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,

2124: p_attribute20 in varchar2 default hr_api.g_varchar2,
2125: p_print_sf50_flag in varchar2 default 'N',
2126: p_printer_name in varchar2 default null,
2127: p_print_back_page in varchar2 default 'Y',
2128: p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
2129: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
2130: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
2131: p_u_action_taken in varchar2 default null,
2132: p_u_approval_status in varchar2 default hr_api.g_varchar2,

Line 2129: p_u_approved_flag in varchar2 default hr_api.g_varchar2,

2125: p_print_sf50_flag in varchar2 default 'N',
2126: p_printer_name in varchar2 default null,
2127: p_print_back_page in varchar2 default 'Y',
2128: p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
2129: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
2130: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
2131: p_u_action_taken in varchar2 default null,
2132: p_u_approval_status in varchar2 default hr_api.g_varchar2,
2133: p_i_user_name_routed_to in varchar2 default null,

Line 2130: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,

2126: p_printer_name in varchar2 default null,
2127: p_print_back_page in varchar2 default 'Y',
2128: p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
2129: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
2130: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
2131: p_u_action_taken in varchar2 default null,
2132: p_u_approval_status in varchar2 default hr_api.g_varchar2,
2133: p_i_user_name_routed_to in varchar2 default null,
2134: p_i_groupbox_id in number default null,

Line 2132: p_u_approval_status in varchar2 default hr_api.g_varchar2,

2128: p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
2129: p_u_approved_flag in varchar2 default hr_api.g_varchar2,
2130: p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
2131: p_u_action_taken in varchar2 default null,
2132: p_u_approval_status in varchar2 default hr_api.g_varchar2,
2133: p_i_user_name_routed_to in varchar2 default null,
2134: p_i_groupbox_id in number default null,
2135: p_i_routing_list_id in number default null,
2136: p_i_routing_seq_number in number default null,

Line 2138: p_to_retention_allow_percentag in number default hr_api.g_number,

2134: p_i_groupbox_id in number default null,
2135: p_i_routing_list_id in number default null,
2136: p_i_routing_seq_number in number default null,
2137: p_capped_other_pay in number default null,
2138: p_to_retention_allow_percentag in number default hr_api.g_number,
2139: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2140: p_to_staffing_diff_percentage in number default hr_api.g_number,
2141: p_award_percentage in number default hr_api.g_number,
2142: p_rpa_type in varchar2 default hr_api.g_varchar2,

Line 2139: p_to_supervisory_diff_percenta in number default hr_api.g_number,

2135: p_i_routing_list_id in number default null,
2136: p_i_routing_seq_number in number default null,
2137: p_capped_other_pay in number default null,
2138: p_to_retention_allow_percentag in number default hr_api.g_number,
2139: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2140: p_to_staffing_diff_percentage in number default hr_api.g_number,
2141: p_award_percentage in number default hr_api.g_number,
2142: p_rpa_type in varchar2 default hr_api.g_varchar2,
2143: p_mass_action_id in number default hr_api.g_number,

Line 2140: p_to_staffing_diff_percentage in number default hr_api.g_number,

2136: p_i_routing_seq_number in number default null,
2137: p_capped_other_pay in number default null,
2138: p_to_retention_allow_percentag in number default hr_api.g_number,
2139: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2140: p_to_staffing_diff_percentage in number default hr_api.g_number,
2141: p_award_percentage in number default hr_api.g_number,
2142: p_rpa_type in varchar2 default hr_api.g_varchar2,
2143: p_mass_action_id in number default hr_api.g_number,
2144: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,

Line 2141: p_award_percentage in number default hr_api.g_number,

2137: p_capped_other_pay in number default null,
2138: p_to_retention_allow_percentag in number default hr_api.g_number,
2139: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2140: p_to_staffing_diff_percentage in number default hr_api.g_number,
2141: p_award_percentage in number default hr_api.g_number,
2142: p_rpa_type in varchar2 default hr_api.g_varchar2,
2143: p_mass_action_id in number default hr_api.g_number,
2144: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2145: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,

Line 2142: p_rpa_type in varchar2 default hr_api.g_varchar2,

2138: p_to_retention_allow_percentag in number default hr_api.g_number,
2139: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2140: p_to_staffing_diff_percentage in number default hr_api.g_number,
2141: p_award_percentage in number default hr_api.g_number,
2142: p_rpa_type in varchar2 default hr_api.g_varchar2,
2143: p_mass_action_id in number default hr_api.g_number,
2144: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2145: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2146: p_mass_action_comments in varchar2 default hr_api.g_varchar2,

Line 2143: p_mass_action_id in number default hr_api.g_number,

2139: p_to_supervisory_diff_percenta in number default hr_api.g_number,
2140: p_to_staffing_diff_percentage in number default hr_api.g_number,
2141: p_award_percentage in number default hr_api.g_number,
2142: p_rpa_type in varchar2 default hr_api.g_varchar2,
2143: p_mass_action_id in number default hr_api.g_number,
2144: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2145: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2146: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2147: -- Bug#4486823 RRR Changes

Line 2144: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,

2140: p_to_staffing_diff_percentage in number default hr_api.g_number,
2141: p_award_percentage in number default hr_api.g_number,
2142: p_rpa_type in varchar2 default hr_api.g_varchar2,
2143: p_mass_action_id in number default hr_api.g_number,
2144: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2145: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2146: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2147: -- Bug#4486823 RRR Changes
2148: p_payment_option in varchar2 default null,

Line 2145: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,

2141: p_award_percentage in number default hr_api.g_number,
2142: p_rpa_type in varchar2 default hr_api.g_varchar2,
2143: p_mass_action_id in number default hr_api.g_number,
2144: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2145: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2146: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2147: -- Bug#4486823 RRR Changes
2148: p_payment_option in varchar2 default null,
2149: p_award_salary in number default hr_api.g_number,

Line 2146: p_mass_action_comments in varchar2 default hr_api.g_varchar2,

2142: p_rpa_type in varchar2 default hr_api.g_varchar2,
2143: p_mass_action_id in number default hr_api.g_number,
2144: p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2145: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2146: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2147: -- Bug#4486823 RRR Changes
2148: p_payment_option in varchar2 default null,
2149: p_award_salary in number default hr_api.g_number,
2150: -- Bug#4486823 RRR Changes

Line 2149: p_award_salary in number default hr_api.g_number,

2145: p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2146: p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2147: -- Bug#4486823 RRR Changes
2148: p_payment_option in varchar2 default null,
2149: p_award_salary in number default hr_api.g_number,
2150: -- Bug#4486823 RRR Changes
2151: p_u_prh_object_version_number out nocopy number,
2152: p_i_pa_routing_history_id out nocopy number,
2153: p_i_prh_object_version_number out nocopy number

Line 2218: l_asg_sf52 ghr_api.asg_sf52_type;

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

Line 2219: l_asg_non_sf52 ghr_api.asg_non_sf52_type;

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

Line 2220: l_asg_nte_dates ghr_api.asg_nte_dates_type;

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

Line 2221: l_per_sf52 ghr_api.per_sf52_type;

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

Line 2222: l_per_group1 ghr_api.per_group1_type;

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

Line 2223: l_per_group2 ghr_api.per_group2_type;

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

Line 2224: l_per_scd_info ghr_api.per_scd_info_type;

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

Line 2225: l_per_retained_grade ghr_api.per_retained_grade_type;

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

Line 2226: l_per_probations ghr_api.per_probations_type;

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

Line 2227: l_per_sep_retire ghr_api.per_sep_retire_type;

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

Line 2228: l_per_security ghr_api.per_security_type;

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

Line 2229: l_per_conversions ghr_api.per_conversions_type;

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

Line 2230: l_per_uniformed_services ghr_api.per_uniformed_services_type;

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

Line 2231: l_pos_oblig ghr_api.pos_oblig_type;

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

Line 2232: l_pos_grp2 ghr_api.pos_grp2_type;

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

Line 2233: l_pos_grp1 ghr_api.pos_grp1_type;

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

Line 2234: l_pos_valid_grade ghr_api.pos_valid_grade_type;

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

Line 2235: l_pos_car_prog ghr_api.pos_car_prog_type;

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

Line 2236: l_loc_info ghr_api.loc_info_type;

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

Line 2237: l_wgi ghr_api.within_grade_increase_type;

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

Line 2238: l_recruitment_bonus ghr_api.recruitment_bonus_type;

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

Line 2239: l_relocation_bonus ghr_api.relocation_bonus_type;

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

Line 2242: l_mddds_special_pay ghr_api.mddds_special_pay_type;

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

Line 2243: l_sf52_from_data ghr_api.prior_sf52_data_type;

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

Line 2244: l_personal_info ghr_api.personal_info_type;

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

Line 2245: l_gov_awards_type ghr_api.government_awards_type;

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

Line 2246: l_perf_appraisal_type ghr_api.performance_appraisal_type;

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

Line 2247: l_payroll_type ghr_api.government_payroll_type;

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

Line 2248: l_conduct_perf_type ghr_api.conduct_performance_type;

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

Line 2249: l_agency_sf52 ghr_api.agency_sf52_type;

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

Line 2251: l_imm_entitlement ghr_api.entitlement_type;

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

Line 2252: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

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

Line 2253: l_imm_edp_pay ghr_api.edp_pay_type;

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

Line 2254: l_imm_hazard_pay ghr_api.hazard_pay_type;

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

Line 2255: l_imm_health_benefits ghr_api.health_benefits_type;

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

Line 2256: l_imm_danger_pay ghr_api.danger_pay_type;

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

Line 2257: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;

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

Line 2258: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;

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

Line 2259: l_imm_post_diff_amt ghr_api.post_diff_amt_type;

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

Line 2260: l_imm_post_diff_percent ghr_api.post_diff_percent_type;

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

Line 2261: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

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

Line 2262: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;

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

Line 2263: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;

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

Line 2264: l_imm_premium_pay ghr_api.premium_pay_type;

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

Line 2265: l_imm_retirement_annuity ghr_api.retirement_annuity_type;

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

Line 2266: l_imm_severance_pay ghr_api.severance_pay_type;

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

Line 2267: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;

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

Line 2268: l_imm_retention_allow_review ghr_api.retention_allow_review_type;

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

Line 2269: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

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

Line 2272: l_imm_per_benefit_info ghr_api.per_benefit_info_type;

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

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

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

Line 2602: when hr_api.cannot_find_prog_unit then

2598: p_mass_action_select_flag => p_mass_action_select_flag,
2599: p_mass_action_comments => p_mass_action_comments
2600: );
2601: exception
2602: when hr_api.cannot_find_prog_unit then
2603: hr_api.cannot_find_prog_unit_error
2604: (p_module_name => 'update_sf52',
2605: p_hook_type => 'BP'
2606: );

Line 2603: hr_api.cannot_find_prog_unit_error

2599: p_mass_action_comments => p_mass_action_comments
2600: );
2601: exception
2602: when hr_api.cannot_find_prog_unit then
2603: hr_api.cannot_find_prog_unit_error
2604: (p_module_name => 'update_sf52',
2605: p_hook_type => 'BP'
2606: );
2607: end;

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

2614: -- Validation in addition to Row Handlers
2615:
2616: -- If the SF52 is processed for the person same as the user, then do not allow creation
2617:
2618: If nvl(p_person_id,hr_api.g_number) <> hr_api.g_number then
2619: -- get employee_id of the user
2620: for user_id in c_names loop
2621: If user_id.employee_id = p_person_id then
2622: hr_utility.set_message(8301,'GHR_38503_CANNOT_INIT_FOR_SELF');

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

2629: -- Routing Group _Id can be changed only in a case where the request has been initiated
2630: -- but not yet routed , for instance when the user uses the task flow button to
2631: -- naviage to another form and when he comes back he can change the routing_grouip_id
2632:
2633: if p_routing_group_id is not null and p_routing_group_id <> hr_api.g_number then
2634: for rout_group_id in c_routing_group_id loop
2635: l_routing_group_id := rout_group_id.routing_group_id;
2636: end loop;
2637: if nvl(l_routing_group_id,hr_api.g_number) <> p_routing_group_id then

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

2633: if p_routing_group_id is not null and p_routing_group_id <> hr_api.g_number then
2634: for rout_group_id in c_routing_group_id loop
2635: l_routing_group_id := rout_group_id.routing_group_id;
2636: end loop;
2637: if nvl(l_routing_group_id,hr_api.g_number) <> p_routing_group_id then
2638: for cnt_of_history in c_cnt_history loop
2639: l_cnt_history := cnt_of_history.cnt;
2640: exit;
2641: end loop;

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

2652: l_approving_official_work_titl := p_approving_official_work_titl;
2653: l_approving_official_full_name := p_approving_official_full_name;
2654:
2655: hr_utility.set_location('approval_stat ' || p_u_approval_Status,1);
2656: If nvl(p_u_approval_status,hr_api.g_varchar2) = 'APPROVE' then
2657: If p_approval_date is null or p_approval_date = hr_api.g_date
2658: then
2659: hr_utility.set_location('approval date is not null',1);
2660: l_effective_date := trunc(sysdate);

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

2653: l_approving_official_full_name := p_approving_official_full_name;
2654:
2655: hr_utility.set_location('approval_stat ' || p_u_approval_Status,1);
2656: If nvl(p_u_approval_status,hr_api.g_varchar2) = 'APPROVE' then
2657: If p_approval_date is null or p_approval_date = hr_api.g_date
2658: then
2659: hr_utility.set_location('approval date is not null',1);
2660: l_effective_date := trunc(sysdate);
2661: l_approval_date := sysdate;

Line 2694: l_sf50_approval_date := hr_api.g_date;

2690: -- the following the lines are for bug 715020. This is to ensure that we don't update the
2691: -- sf50 approval fields to null. Previously, the local versions of these variables would never
2692: -- have been initialized unless the action_taken was ('UPDATE_HR','FUTURE_ACTION')
2693: -- (see code immediately following.
2694: l_sf50_approval_date := hr_api.g_date;
2695: l_sf50_approving_ofcl_work_tit := hr_api.g_varchar2;
2696: l_sf50_approving_ofcl_full_nam := hr_api.g_varchar2;
2697:
2698: If nvl(p_u_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then

Line 2695: l_sf50_approving_ofcl_work_tit := hr_api.g_varchar2;

2691: -- sf50 approval fields to null. Previously, the local versions of these variables would never
2692: -- have been initialized unless the action_taken was ('UPDATE_HR','FUTURE_ACTION')
2693: -- (see code immediately following.
2694: l_sf50_approval_date := hr_api.g_date;
2695: l_sf50_approving_ofcl_work_tit := hr_api.g_varchar2;
2696: l_sf50_approving_ofcl_full_nam := hr_api.g_varchar2;
2697:
2698: If nvl(p_u_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then
2699: If p_approval_date is not null and p_approval_date <> hr_api.g_date then

Line 2696: l_sf50_approving_ofcl_full_nam := hr_api.g_varchar2;

2692: -- have been initialized unless the action_taken was ('UPDATE_HR','FUTURE_ACTION')
2693: -- (see code immediately following.
2694: l_sf50_approval_date := hr_api.g_date;
2695: l_sf50_approving_ofcl_work_tit := hr_api.g_varchar2;
2696: l_sf50_approving_ofcl_full_nam := hr_api.g_varchar2;
2697:
2698: If nvl(p_u_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then
2699: If p_approval_date is not null and p_approval_date <> hr_api.g_date then
2700: l_sf50_approval_date := p_approval_date;

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

2694: l_sf50_approval_date := hr_api.g_date;
2695: l_sf50_approving_ofcl_work_tit := hr_api.g_varchar2;
2696: l_sf50_approving_ofcl_full_nam := hr_api.g_varchar2;
2697:
2698: If nvl(p_u_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then
2699: If p_approval_date is not null and p_approval_date <> hr_api.g_date then
2700: l_sf50_approval_date := p_approval_date;
2701: l_sf50_approving_ofcl_work_tit := p_approving_official_work_titl;
2702: l_sf50_approving_ofcl_full_nam := p_approving_official_full_name;

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

2695: l_sf50_approving_ofcl_work_tit := hr_api.g_varchar2;
2696: l_sf50_approving_ofcl_full_nam := hr_api.g_varchar2;
2697:
2698: If nvl(p_u_action_taken,hr_api.g_varchar2) in ('UPDATE_HR','FUTURE_ACTION') then
2699: If p_approval_date is not null and p_approval_date <> hr_api.g_date then
2700: l_sf50_approval_date := p_approval_date;
2701: l_sf50_approving_ofcl_work_tit := p_approving_official_work_titl;
2702: l_sf50_approving_ofcl_full_nam := p_approving_official_full_name;
2703: Else

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

2982: -- in case of either a) first_nature_of_action is input for the first_time or (just insert new recds)
2983: -- b) first nature_of_action has changed (delete and then insert new records)
2984: --
2985:
2986: if nvl(p_first_noa_id,hr_api.g_number)
2987: <> nvl(ghr_par_shd.g_old_rec.first_noa_id,hr_api.g_number) then
2988: hr_utility.set_location(l_proc, 9);
2989:
2990: -- delete the existing remarks

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

2983: -- b) first nature_of_action has changed (delete and then insert new records)
2984: --
2985:
2986: if nvl(p_first_noa_id,hr_api.g_number)
2987: <> nvl(ghr_par_shd.g_old_rec.first_noa_id,hr_api.g_number) then
2988: hr_utility.set_location(l_proc, 9);
2989:
2990: -- delete the existing remarks
2991: delete from ghr_pa_remarks pre

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

3023: -- and nvl(rem.date_to,l_effective_date));
3024: end if;
3025: end if;
3026:
3027: if nvl(p_second_noa_id,hr_api.g_number)
3028: <> nvl(ghr_par_shd.g_old_rec.second_noa_id,hr_api.g_number) then
3029:
3030: -- delete the existing remarks
3031: delete from ghr_pa_remarks pre

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

3024: end if;
3025: end if;
3026:
3027: if nvl(p_second_noa_id,hr_api.g_number)
3028: <> nvl(ghr_par_shd.g_old_rec.second_noa_id,hr_api.g_number) then
3029:
3030: -- delete the existing remarks
3031: delete from ghr_pa_remarks pre
3032: where pre.pa_request_id = p_pa_request_id

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

3062: end if;
3063: end if;
3064:
3065:
3066: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
3067: then
3068:
3069: If p_first_noa_id = hr_api.g_number then
3070: l_rec.first_noa_id := ghr_par_shd.g_old_rec.first_noa_id;

Line 3069: If p_first_noa_id = hr_api.g_number then

3065:
3066: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
3067: then
3068:
3069: If p_first_noa_id = hr_api.g_number then
3070: l_rec.first_noa_id := ghr_par_shd.g_old_rec.first_noa_id;
3071: Else
3072: l_rec.first_noa_id := p_first_noa_id;
3073: End if;

Line 3075: If p_second_noa_id = hr_api.g_number then

3071: Else
3072: l_rec.first_noa_id := p_first_noa_id;
3073: End if;
3074:
3075: If p_second_noa_id = hr_api.g_number then
3076: l_rec.second_noa_id := ghr_par_shd.g_old_rec.second_noa_id;
3077: Else
3078: l_rec.second_noa_id := p_second_noa_id;
3079: End if;

Line 3081: If p_effective_date = hr_api.g_date then

3077: Else
3078: l_rec.second_noa_id := p_second_noa_id;
3079: End if;
3080:
3081: If p_effective_date = hr_api.g_date then
3082: l_rec.effective_date := ghr_par_shd.g_old_rec.effective_date;
3083: Else
3084: l_rec.effective_date := p_effective_date;
3085: End if;

Line 3087: If p_person_id = hr_api.g_number then

3083: Else
3084: l_rec.effective_date := p_effective_date;
3085: End if;
3086:
3087: If p_person_id = hr_api.g_number then
3088: l_rec.person_id := ghr_par_shd.g_old_rec.person_id;
3089: Else
3090: l_rec.person_id := p_person_id;
3091: End if;

Line 3093: If p_employee_assignment_id = hr_api.g_number then

3089: Else
3090: l_rec.person_id := p_person_id;
3091: End if;
3092:
3093: If p_employee_assignment_id = hr_api.g_number then
3094: l_rec.employee_assignment_id := ghr_par_shd.g_old_rec.employee_assignment_id;
3095: Else
3096: l_rec.employee_assignment_id := p_employee_assignment_id;
3097: End if;

Line 3099: If p_to_position_id = hr_api.g_number then

3095: Else
3096: l_rec.employee_assignment_id := p_employee_assignment_id;
3097: End if;
3098:
3099: If p_to_position_id = hr_api.g_number then
3100: l_rec.to_position_id := ghr_par_shd.g_old_rec.to_position_id;
3101: Else
3102: l_rec.to_position_id := p_to_position_id;
3103: End if;

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

3104:
3105: if p_u_action_taken = 'NOT_ROUTED' then
3106: l_rpa_type := p_rpa_type;
3107: l_mass_action_id := p_mass_action_id;
3108: If nvl(l_rpa_type,'##') = hr_api.g_varchar2 then
3109: l_rpa_type := ghr_par_shd.g_old_rec.rpa_type;
3110: End if;
3111: If nvl(l_mass_action_id,-9999) = hr_api.g_number then
3112: l_mass_action_id := ghr_par_shd.g_old_rec.mass_action_id;

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

3107: l_mass_action_id := p_mass_action_id;
3108: If nvl(l_rpa_type,'##') = hr_api.g_varchar2 then
3109: l_rpa_type := ghr_par_shd.g_old_rec.rpa_type;
3110: End if;
3111: If nvl(l_mass_action_id,-9999) = hr_api.g_number then
3112: l_mass_action_id := ghr_par_shd.g_old_rec.mass_action_id;
3113: End if;
3114: End if;
3115:

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

3112: l_mass_action_id := ghr_par_shd.g_old_rec.mass_action_id;
3113: End if;
3114: End if;
3115:
3116: If (nvl(p_effective_date,hr_api.g_date)
3117: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3118: (nvl(p_person_id,hr_api.g_number)
3119: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3120: or (p_noa_family_code = 'APP') or

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

3113: End if;
3114: End if;
3115:
3116: If (nvl(p_effective_date,hr_api.g_date)
3117: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3118: (nvl(p_person_id,hr_api.g_number)
3119: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3120: or (p_noa_family_code = 'APP') or
3121: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then

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

3114: End if;
3115:
3116: If (nvl(p_effective_date,hr_api.g_date)
3117: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3118: (nvl(p_person_id,hr_api.g_number)
3119: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3120: or (p_noa_family_code = 'APP') or
3121: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then
3122:

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

3115:
3116: If (nvl(p_effective_date,hr_api.g_date)
3117: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3118: (nvl(p_person_id,hr_api.g_number)
3119: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3120: or (p_noa_family_code = 'APP') or
3121: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then
3122:
3123: GHR_NON_SF52_EXTRA_INFO.fetch_generic_extra_info

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

3117: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3118: (nvl(p_person_id,hr_api.g_number)
3119: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3120: or (p_noa_family_code = 'APP') or
3121: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then
3122:
3123: GHR_NON_SF52_EXTRA_INFO.fetch_generic_extra_info
3124: (p_pa_request_id => p_pa_request_id,
3125: p_person_id => l_rec.person_id,

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

3129: );
3130: End if;
3131:
3132:
3133: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3134: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3135: (nvl(p_second_noa_code,hr_api.g_varchar2)
3136: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3137: (nvl(p_effective_date,hr_api.g_date)

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

3130: End if;
3131:
3132:
3133: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3134: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3135: (nvl(p_second_noa_code,hr_api.g_varchar2)
3136: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3137: (nvl(p_effective_date,hr_api.g_date)
3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or

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

3131:
3132:
3133: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3134: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3135: (nvl(p_second_noa_code,hr_api.g_varchar2)
3136: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3137: (nvl(p_effective_date,hr_api.g_date)
3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3139: (nvl(p_person_id,hr_api.g_number)

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

3132:
3133: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3134: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3135: (nvl(p_second_noa_code,hr_api.g_varchar2)
3136: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3137: (nvl(p_effective_date,hr_api.g_date)
3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3139: (nvl(p_person_id,hr_api.g_number)
3140: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or

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

3133: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3134: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3135: (nvl(p_second_noa_code,hr_api.g_varchar2)
3136: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3137: (nvl(p_effective_date,hr_api.g_date)
3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3139: (nvl(p_person_id,hr_api.g_number)
3140: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3141: (nvl(p_to_position_id,hr_api.g_number)

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

3134: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3135: (nvl(p_second_noa_code,hr_api.g_varchar2)
3136: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3137: (nvl(p_effective_date,hr_api.g_date)
3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3139: (nvl(p_person_id,hr_api.g_number)
3140: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3141: (nvl(p_to_position_id,hr_api.g_number)
3142: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))

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

3135: (nvl(p_second_noa_code,hr_api.g_varchar2)
3136: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3137: (nvl(p_effective_date,hr_api.g_date)
3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3139: (nvl(p_person_id,hr_api.g_number)
3140: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3141: (nvl(p_to_position_id,hr_api.g_number)
3142: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3143: then

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

3136: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3137: (nvl(p_effective_date,hr_api.g_date)
3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3139: (nvl(p_person_id,hr_api.g_number)
3140: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3141: (nvl(p_to_position_id,hr_api.g_number)
3142: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3143: then
3144: hr_utility.set_location('update/ delete extra info',1);

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

3137: (nvl(p_effective_date,hr_api.g_date)
3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3139: (nvl(p_person_id,hr_api.g_number)
3140: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3141: (nvl(p_to_position_id,hr_api.g_number)
3142: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3143: then
3144: hr_utility.set_location('update/ delete extra info',1);
3145:

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

3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3139: (nvl(p_person_id,hr_api.g_number)
3140: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3141: (nvl(p_to_position_id,hr_api.g_number)
3142: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3143: then
3144: hr_utility.set_location('update/ delete extra info',1);
3145:
3146:

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

3166:
3167: l_action_taken := p_u_action_taken;
3168: hr_utility.set_location(l_proc, 11);
3169: if l_action_taken is null then
3170: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3171: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3172: l_action_taken := 'AUTHORIZED';
3173: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
3174: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then

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

3167: l_action_taken := p_u_action_taken;
3168: hr_utility.set_location(l_proc, 11);
3169: if l_action_taken is null then
3170: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3171: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3172: l_action_taken := 'AUTHORIZED';
3173: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
3174: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
3175: l_action_taken := 'REQUESTED';

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

3169: if l_action_taken is null then
3170: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3171: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3172: l_action_taken := 'AUTHORIZED';
3173: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
3174: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
3175: l_action_taken := 'REQUESTED';
3176: else
3177: for history_exists in C_history_exists loop

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

3170: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3171: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3172: l_action_taken := 'AUTHORIZED';
3173: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
3174: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
3175: l_action_taken := 'REQUESTED';
3176: else
3177: for history_exists in C_history_exists loop
3178: l_exists := true;

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

3236: hr_utility.raise_error;
3237: end if;
3238: end if;
3239:
3240: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','UPDATE_HR_COMPLETE','NONE','ENDED')then
3241: hr_utility.set_location('check ' ||l_action_taken,1);
3242: hr_utility.set_location('check ' ||l_mass_action_id,1);
3243: hr_utility.set_location('Check ' || l_rpa_type,1);
3244: -- Do not routing history if Template record for Mass Actions.

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

3243: hr_utility.set_location('Check ' || l_rpa_type,1);
3244: -- Do not routing history if Template record for Mass Actions.
3245:
3246: -- If (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is not null --AVR
3247: -- and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA') or --AVR
3248: -- (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null) then --AVR
3249:
3250: if nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' then --AVR
3251: if (nvl(l_rpa_type,hr_api.g_varchar2) = 'A' and l_action_taken = 'NOT_ROUTED' ) then --AVR

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

3246: -- If (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is not null --AVR
3247: -- and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA') or --AVR
3248: -- (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null) then --AVR
3249:
3250: if nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' then --AVR
3251: if (nvl(l_rpa_type,hr_api.g_varchar2) = 'A' and l_action_taken = 'NOT_ROUTED' ) then --AVR
3252: hr_utility.set_location('Form Folder Updation ..Do not route ' ,1); --AVR
3253: else --AVR
3254:

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

3247: -- and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA') or --AVR
3248: -- (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null) then --AVR
3249:
3250: if nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' then --AVR
3251: if (nvl(l_rpa_type,hr_api.g_varchar2) = 'A' and l_action_taken = 'NOT_ROUTED' ) then --AVR
3252: hr_utility.set_location('Form Folder Updation ..Do not route ' ,1); --AVR
3253: else --AVR
3254:
3255: for cur_routing_history_id in C_routing_history_id loop

Line 3263: and p_u_user_name_acted_on <> hr_api.g_varchar2 then

3259: end loop;
3260: hr_utility.set_location('in update sf52 api , user acted on is ' || p_u_user_name_acted_on,1);
3261: if p_u_user_name_acted_on is not null
3262: -- RP
3263: and p_u_user_name_acted_on <> hr_api.g_varchar2 then
3264: hr_utility.set_location(l_proc, 12);
3265:
3266: ghr_pa_requests_pkg.get_roles
3267: (p_pa_request_id,

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

3385: -- Insert 2nd record into routing_history for routing details (with exceptions )
3386:
3387: /***dk***/
3388: -- Should I add ENDED and/or END_ROUTING to the following if??
3389: if nvl(l_action_taken,hr_api.g_varchar2) not in ('NOT_ROUTED','UPDATE_HR','FUTURE_ACTION','NONE','END_ROUTING') then
3390:
3391: ghr_prh_ins.ins
3392: (p_pa_routing_history_id => l_i_pa_routing_history_id,
3393: p_pa_request_id => p_pa_request_id,

Line 3425: If p_proposed_effective_asap_flag = hr_api.g_varchar2 then

3421: hr_utility.set_location(l_proc, 21);
3422: l_rec.pa_request_id := p_pa_request_id;
3423: l_rec.noa_family_code := p_noa_family_code;
3424: l_rec.routing_group_id := p_routing_group_id;
3425: If p_proposed_effective_asap_flag = hr_api.g_varchar2 then
3426: l_rec.proposed_effective_asap_flag := ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
3427: Else
3428: l_rec.proposed_effective_asap_flag := p_proposed_effective_asap_flag;
3429: End if;

Line 3448: If p_custom_pay_calc_flag = hr_api.g_varchar2 then

3444: l_rec.award_uom := p_award_uom;
3445: l_rec.bargaining_unit_status := p_bargaining_unit_status;
3446: l_rec.citizenship := p_citizenship;
3447: l_rec.concurrence_date := p_concurrence_date;
3448: If p_custom_pay_calc_flag = hr_api.g_varchar2 then
3449: l_rec.custom_pay_calc_flag := ghr_par_shd.g_old_rec.custom_pay_calc_flag;
3450: Else
3451: l_rec.custom_pay_calc_flag := p_custom_pay_calc_flag;
3452: End if;

Line 3474: If p_first_noa_code = hr_api.g_varchar2 then

3470: l_rec.first_action_la_code2 := p_first_action_la_code2;
3471: l_rec.first_action_la_desc1 := p_first_action_la_desc1;
3472: l_rec.first_action_la_desc2 := p_first_action_la_desc2;
3473: l_rec.first_noa_cancel_or_correct := p_first_noa_cancel_or_correct;
3474: If p_first_noa_code = hr_api.g_varchar2 then
3475: l_rec.first_noa_code := ghr_par_shd.g_old_rec.first_noa_code;
3476: Else
3477: l_rec.first_noa_code := p_first_noa_code;
3478: End if;

Line 3499: If p_from_pay_plan = hr_api.g_varchar2 then

3495: l_rec.from_occ_code := p_from_occ_code;
3496: l_rec.from_other_pay_amount := p_from_other_pay_amount;
3497: l_rec.from_pay_basis := p_from_pay_basis;
3498:
3499: If p_from_pay_plan = hr_api.g_varchar2 then
3500: l_rec.from_pay_plan := ghr_par_shd.g_old_rec.from_pay_plan;
3501: Else
3502: l_rec.from_pay_plan := p_from_pay_plan;
3503: End if;

Line 3522: If p_part_time_hours = hr_api.g_number then

3518: l_rec.from_step_or_rate := p_from_step_or_rate;
3519: l_rec.from_total_salary := p_from_total_salary;
3520: l_rec.functional_class := p_functional_class;
3521: l_rec.notepad := p_notepad;
3522: If p_part_time_hours = hr_api.g_number then
3523: l_rec.part_time_hours := ghr_par_shd.g_old_rec.part_time_hours;
3524: Else
3525: l_rec.part_time_hours := p_part_time_hours;
3526: End if;

Line 3535: If p_requesting_office_remarks_fl = hr_api.g_varchar2 then

3531: l_rec.requested_by_person_id := p_requested_by_person_id;
3532: l_rec.requested_by_title := p_requested_by_title;
3533: l_rec.requested_date := p_requested_date;
3534: l_rec.requesting_office_remarks_desc := p_requesting_office_remarks_de;
3535: If p_requesting_office_remarks_fl = hr_api.g_varchar2 then
3536: l_rec.requesting_office_remarks_flag := ghr_par_shd.g_old_rec.requesting_office_remarks_flag;
3537: Else
3538: l_rec.requesting_office_remarks_flag := p_requesting_office_remarks_fl;
3539: End if;

Line 3575: If p_to_pay_plan = hr_api.g_varchar2 then

3571: l_rec.to_retention_allowance := p_to_retention_allowance;
3572: l_rec.to_supervisory_differential := p_to_supervisory_differential;
3573: l_rec.to_staffing_differential := p_to_staffing_differential;
3574: l_rec.to_pay_basis := p_to_pay_basis;
3575: If p_to_pay_plan = hr_api.g_varchar2 then
3576: l_rec.to_pay_plan := ghr_par_shd.g_old_rec.to_pay_plan;
3577: Else
3578: l_rec.to_pay_plan := p_to_pay_plan;
3579: End if;

Line 3600: If p_year_degree_attained = hr_api.g_number then

3596: l_rec.veterans_pref_for_rif := p_veterans_pref_for_rif;
3597: l_rec.veterans_status := p_veterans_status;
3598: l_rec.work_schedule := p_work_schedule;
3599: l_rec.work_schedule_desc := p_work_schedule_desc;
3600: If p_year_degree_attained = hr_api.g_number then
3601: l_rec.year_degree_attained := ghr_par_shd.g_old_rec.year_degree_attained;
3602: Else
3603: l_rec.year_degree_attained := p_year_degree_attained;
3604: End if;

Line 3658: If p_to_retention_allow_percentag = hr_api.g_number then

3654: l_rec.attribute18 := p_attribute18;
3655: l_rec.attribute19 := p_attribute19;
3656: l_rec.attribute20 := p_attribute20;
3657: l_rec.object_version_number := l_par_object_version_number;
3658: If p_to_retention_allow_percentag = hr_api.g_number then
3659: l_rec.to_retention_allow_percentage := ghr_par_shd.g_old_rec.to_retention_allow_percentage;
3660: Else
3661: l_rec.to_retention_allow_percentage := p_to_retention_allow_percentag;
3662: End if;

Line 3663: If p_to_supervisory_diff_percenta = hr_api.g_number then

3659: l_rec.to_retention_allow_percentage := ghr_par_shd.g_old_rec.to_retention_allow_percentage;
3660: Else
3661: l_rec.to_retention_allow_percentage := p_to_retention_allow_percentag;
3662: End if;
3663: If p_to_supervisory_diff_percenta = hr_api.g_number then
3664: l_rec.to_supervisory_diff_percentage := ghr_par_shd.g_old_rec.to_supervisory_diff_percentage;
3665: Else
3666: l_rec.to_supervisory_diff_percentage := p_to_supervisory_diff_percenta;
3667: End if;

Line 3668: If p_to_staffing_diff_percentage = hr_api.g_number then

3664: l_rec.to_supervisory_diff_percentage := ghr_par_shd.g_old_rec.to_supervisory_diff_percentage;
3665: Else
3666: l_rec.to_supervisory_diff_percentage := p_to_supervisory_diff_percenta;
3667: End if;
3668: If p_to_staffing_diff_percentage = hr_api.g_number then
3669: l_rec.to_staffing_diff_percentage := ghr_par_shd.g_old_rec.to_staffing_diff_percentage;
3670: Else
3671: l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
3672: End if;

Line 3673: If p_award_percentage = hr_api.g_number then

3669: l_rec.to_staffing_diff_percentage := ghr_par_shd.g_old_rec.to_staffing_diff_percentage;
3670: Else
3671: l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
3672: End if;
3673: If p_award_percentage = hr_api.g_number then
3674: l_rec.award_percentage := ghr_par_shd.g_old_rec.award_percentage;
3675: Else
3676: l_rec.award_percentage := p_award_percentage;
3677: End if;

Line 3681: If p_mass_action_eligible_flag = hr_api.g_varchar2 then

3677: End if;
3678: l_rec.rpa_type := p_rpa_type;
3679: l_rec.mass_action_id := p_mass_action_id;
3680:
3681: If p_mass_action_eligible_flag = hr_api.g_varchar2 then
3682: l_rec.mass_action_eligible_flag := ghr_par_shd.g_old_rec.mass_action_eligible_flag;
3683: Else
3684: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
3685: End if;

Line 3686: If p_mass_action_select_flag = hr_api.g_varchar2 then

3682: l_rec.mass_action_eligible_flag := ghr_par_shd.g_old_rec.mass_action_eligible_flag;
3683: Else
3684: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
3685: End if;
3686: If p_mass_action_select_flag = hr_api.g_varchar2 then
3687: l_rec.mass_action_select_flag := ghr_par_shd.g_old_rec.mass_action_select_flag;
3688: Else
3689: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
3690: End if;

Line 3831: ghr_api.call_workflow

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

Line 4085: when hr_api.cannot_find_prog_unit then

4081: p_mass_action_select_flag => p_mass_action_select_flag,
4082: p_mass_action_comments => p_mass_action_comments
4083: );
4084: exception
4085: when hr_api.cannot_find_prog_unit then
4086: hr_api.cannot_find_prog_unit_error
4087: (p_module_name => 'update_sf52',
4088: p_hook_type => 'AP'
4089: );

Line 4086: hr_api.cannot_find_prog_unit_error

4082: p_mass_action_comments => p_mass_action_comments
4083: );
4084: exception
4085: when hr_api.cannot_find_prog_unit then
4086: hr_api.cannot_find_prog_unit_error
4087: (p_module_name => 'update_sf52',
4088: p_hook_type => 'AP'
4089: );
4090: end;

Line 4097: raise hr_api.validate_enabled;

4093: --
4094: -- When in validation only mode raise the Validate_Enabled exception
4095: --
4096: if p_validate then
4097: raise hr_api.validate_enabled;
4098: end if;
4099:
4100: --
4101: -- Set all output arguments

Line 4109: when hr_api.validate_enabled then

4105: p_par_object_version_number := l_par_object_version_number;
4106: --
4107: hr_utility.set_location(' Leaving:'||l_proc, 11);
4108: exception
4109: when hr_api.validate_enabled then
4110: --
4111: -- As the Validate_Enabled exception has been raised
4112: -- we must rollback to the savepoint
4113: --

Line 4146: p_user_name in varchar2 default hr_api.g_varchar2,

4142:
4143: procedure end_sf52
4144: (p_validate in boolean default false,
4145: p_pa_request_id in number,
4146: p_user_name in varchar2 default hr_api.g_varchar2,
4147: p_action_taken in varchar2,
4148: p_altered_pa_request_id in number default null,
4149: p_first_noa_code in varchar2 default null,
4150: p_second_noa_code in varchar2 default null,

Line 4278: when hr_api.cannot_find_prog_unit then

4274: p_second_noa_code => p_second_noa_code,
4275: p_par_object_version_number => p_par_object_version_number
4276: );
4277: exception
4278: when hr_api.cannot_find_prog_unit then
4279: hr_api.cannot_find_prog_unit_error
4280: (p_module_name => 'end_sf52',
4281: p_hook_type => 'BP'
4282: );

Line 4279: hr_api.cannot_find_prog_unit_error

4275: p_par_object_version_number => p_par_object_version_number
4276: );
4277: exception
4278: when hr_api.cannot_find_prog_unit then
4279: hr_api.cannot_find_prog_unit_error
4280: (p_module_name => 'end_sf52',
4281: p_hook_type => 'BP'
4282: );
4283: end;

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

4302: End if;
4303:
4304: /***dk***/
4305: -- Added ENDED to the following if.
4306: if nvl(p_action_taken,hr_api.g_varchar2) in ('CANCELED','UPDATE_HR_COMPLETE','ENDED') then
4307:
4308: for request_details in c_request_details loop
4309: l_effective_date := trunc(request_details.effective_date);
4310: l_routing_group_id := request_details.routing_group_id;

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

4386: -- If the Form calls end_sf52 directly to Cancel an SF52, then
4387: -- the user_name (acted_on) has to be passed. Therefore the one from
4388: -- the database may not necessarily be the correct one., in which case the p_user_name should be further used.
4389:
4390: If nvl(p_user_name,hr_api.g_varchar2) <> hr_api.g_varchar2 then
4391: l_user_name := p_user_name;
4392: End if;
4393:
4394: -- The foll. was Removed on 08/16 as per Vikram

Line 4448: ghr_api.call_workflow

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

Line 4474: when hr_api.cannot_find_prog_unit then

4470: p_second_noa_code => p_second_noa_code,
4471: p_par_object_version_number => l_par_object_version_number
4472: );
4473: exception
4474: when hr_api.cannot_find_prog_unit then
4475: hr_api.cannot_find_prog_unit_error
4476: (p_module_name => 'end_sf52',
4477: p_hook_type => 'AP'
4478: );

Line 4475: hr_api.cannot_find_prog_unit_error

4471: p_par_object_version_number => l_par_object_version_number
4472: );
4473: exception
4474: when hr_api.cannot_find_prog_unit then
4475: hr_api.cannot_find_prog_unit_error
4476: (p_module_name => 'end_sf52',
4477: p_hook_type => 'AP'
4478: );
4479: end;

Line 4484: raise hr_api.validate_enabled;

4480: --
4481: -- End of After Process User Hook call
4482: --
4483: if p_validate then
4484: raise hr_api.validate_enabled;
4485: end if;
4486:
4487:
4488: -- Set all output arguments

Line 4493: when hr_api.validate_enabled then

4489: --
4490:
4491: hr_utility.set_location(' Leaving:'||l_proc, 11);
4492: exception
4493: when hr_api.validate_enabled then
4494: --
4495: -- As the Validate_Enabled exception has been raised
4496: -- we must rollback to the savepoint
4497: --

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

4659: p_status out nocopy varchar2
4660: )
4661: is
4662: Begin
4663: If nvl(p_action_taken,hr_api.g_varchar2) = 'CANCELED' or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR_COMPLETE'
4664: or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' then
4665: p_status := p_action_taken;
4666: If nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' and trunc(nvl(p_effective_date,hr_api.g_date)) > sysdate then
4667: p_status := 'FUTURE_ACTION';

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

4660: )
4661: is
4662: Begin
4663: If nvl(p_action_taken,hr_api.g_varchar2) = 'CANCELED' or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR_COMPLETE'
4664: or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' then
4665: p_status := p_action_taken;
4666: If nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' and trunc(nvl(p_effective_date,hr_api.g_date)) > sysdate then
4667: p_status := 'FUTURE_ACTION';
4668: End if;

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

4662: Begin
4663: If nvl(p_action_taken,hr_api.g_varchar2) = 'CANCELED' or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR_COMPLETE'
4664: or nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' then
4665: p_status := p_action_taken;
4666: If nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' and trunc(nvl(p_effective_date,hr_api.g_date)) > sysdate then
4667: p_status := 'FUTURE_ACTION';
4668: End if;
4669: Elsif nvl(p_approval_date,hr_api.g_date) <> hr_api.g_date
4670: or nvl(ghr_par_shd.g_old_rec.approval_date,hr_api.g_date) <> hr_api.g_date then

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

4665: p_status := p_action_taken;
4666: If nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' and trunc(nvl(p_effective_date,hr_api.g_date)) > sysdate then
4667: p_status := 'FUTURE_ACTION';
4668: End if;
4669: Elsif nvl(p_approval_date,hr_api.g_date) <> hr_api.g_date
4670: or nvl(ghr_par_shd.g_old_rec.approval_date,hr_api.g_date) <> hr_api.g_date then
4671: p_status := 'APPROVED';
4672: Elsif p_authorized_by_person_id is not null then
4673: p_status := 'AUTHORIZED';

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

4666: If nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' and trunc(nvl(p_effective_date,hr_api.g_date)) > sysdate then
4667: p_status := 'FUTURE_ACTION';
4668: End if;
4669: Elsif nvl(p_approval_date,hr_api.g_date) <> hr_api.g_date
4670: or nvl(ghr_par_shd.g_old_rec.approval_date,hr_api.g_date) <> hr_api.g_date then
4671: p_status := 'APPROVED';
4672: Elsif p_authorized_by_person_id is not null then
4673: p_status := 'AUTHORIZED';
4674: Elsif p_requested_by_person_id is not null then

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

4715: hr_utility.set_location('UN ' || (p_user_name_routed_to),1);
4716: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4717: hr_utility.set_location('Action ' || (p_action_taken),1);
4718: If
4719: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or
4720: nvl(p_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION'
4721: --**dk
4722: or nvl(p_action_taken,hr_api.g_varchar2) = 'END_ROUTING'
4723:

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

4716: hr_utility.set_location('UN acted ' || (p_user_name_acted_on),1);
4717: hr_utility.set_location('Action ' || (p_action_taken),1);
4718: If
4719: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or
4720: nvl(p_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION'
4721: --**dk
4722: or nvl(p_action_taken,hr_api.g_varchar2) = 'END_ROUTING'
4723:
4724: ) then

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

4718: If
4719: ( nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' or
4720: nvl(p_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION'
4721: --**dk
4722: or nvl(p_action_taken,hr_api.g_varchar2) = 'END_ROUTING'
4723:
4724: ) then
4725: -- BUG # 3420126 As per requirements in the bug need not be fired during routing
4726: /*or

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

4724: ) then
4725: -- BUG # 3420126 As per requirements in the bug need not be fired during routing
4726: /*or
4727: ( p_user_name_routed_to is not null and
4728: nvl(p_user_name_acted_on,hr_api.g_varchar2) <> p_user_name_routed_to
4729: ) or
4730: (p_groupbox_routed_to is not null )*/
4731:
4732: hr_utility.set_location(l_proc,10);