DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on GHR_API

Line 58: l_extra_info_rec ghr_api.extra_info_rec_type;

54: l_ovn number;
55: l_initial_ovn number;
56: l_index varchar2(10);
57: l_extra_info_id number(15);
58: l_extra_info_rec ghr_api.extra_info_rec_type;
59: --
60: l_asg_cre_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
61: l_asg_cre_ovn per_assignment_extra_info.object_version_number%type;
62: l_per_cre_extra_info_id per_people_extra_info.person_extra_info_id%type;

Line 624: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE) IS

620: End Generic_Update_Extra_Info;
621:
622: Procedure Update_Retained_Grade
623: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE ,
624: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE) IS
625: --
626: --
627: cursor c_702_rec is
628: select rei_information3,pei_information1,

Line 678: l_per_retained_grade GHR_API.Per_retained_grade_TYPE;

674: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
675:
676: l_session ghr_history_api.g_session_var_type;
677: l_proc varchar2(70) := 'Update_Retained_Grade';
678: l_per_retained_grade GHR_API.Per_retained_grade_TYPE;
679: -- Bug#4698321 Added pei_information1 to the cursor.
680: Cursor c_retained_grade_ovn is
681: select object_version_number,
682: pei_information1,

Line 1021: l_special_info ghr_api.special_information_type;

1017: l_academic_discipline ghr_pa_requests.academic_discipline%type;
1018: l_object_version_number number(9);
1019: l_multiple varchar2(1);
1020: l_session ghr_history_api.g_session_var_type;
1021: l_special_info ghr_api.special_information_type;
1022:
1023:
1024:
1025: -- Cursor to fetch the id_flex_num for the "US Fed Education" structure

Line 1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,

1246: -- *************************
1247: --
1248: Procedure call_extra_info_api
1249: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,

Line 1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,

1247: --
1248: Procedure call_extra_info_api
1249: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,

Line 1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,

1248: Procedure call_extra_info_api
1249: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,

Line 1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,

1249: (P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE,
1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,

Line 1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,

1250: P_Asg_Sf52 IN OUT NOCOPY GHR_API.Asg_Sf52_TYPE,
1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,

Line 1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,

1251: P_Asg_non_Sf52 IN OUT NOCOPY GHR_API.Asg_non_Sf52_TYPE,
1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,

Line 1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,

1252: P_Asg_nte_dates IN OUT NOCOPY GHR_API.Asg_nte_dates_TYPE,
1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,

Line 1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,

1253: P_Per_Sf52 IN OUT NOCOPY GHR_API.Per_Sf52_TYPE,
1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1261: --Bug#4486823 RRR Changes

Line 1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,

1254: P_Per_Group1 IN OUT NOCOPY GHR_API.Per_Group1_TYPE,
1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1261: --Bug#4486823 RRR Changes
1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,

Line 1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,

1255: P_Per_Group2 IN OUT NOCOPY GHR_API.Per_Group2_TYPE,
1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1261: --Bug#4486823 RRR Changes
1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,

Line 1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,

1256: P_Per_scd_info IN OUT NOCOPY GHR_API.Per_scd_info_TYPE,
1257: P_Per_retained_grade IN OUT NOCOPY GHR_API.Per_retained_grade_TYPE,
1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1261: --Bug#4486823 RRR Changes
1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1264: -- BEN_EIT Changes

Line 1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,

1258: P_Per_probations IN OUT NOCOPY GHR_API.Per_probations_TYPE,
1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1261: --Bug#4486823 RRR Changes
1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1264: -- BEN_EIT Changes
1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,

Line 1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,

1259: P_Per_sep_retire IN OUT NOCOPY GHR_API.Per_sep_retire_TYPE,
1260: P_Per_security IN OUT NOCOPY GHR_API.Per_security_TYPE,
1261: --Bug#4486823 RRR Changes
1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1264: -- BEN_EIT Changes
1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,

Line 1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,

1261: --Bug#4486823 RRR Changes
1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1264: -- BEN_EIT Changes
1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,

Line 1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,

1262: p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1264: -- BEN_EIT Changes
1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,

Line 1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,

1263: P_Per_conversions IN OUT NOCOPY GHR_API.Per_conversions_TYPE,
1264: -- BEN_EIT Changes
1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,

Line 1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,

1264: -- BEN_EIT Changes
1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,

Line 1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,

1265: p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,

Line 1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,

1266: P_Per_uniformed_services IN OUT NOCOPY GHR_API.Per_uniformed_services_TYPE,
1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,

Line 1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,

1267: P_Pos_oblig IN OUT NOCOPY GHR_API.Pos_oblig_TYPE,
1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,

Line 1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,

1268: P_Pos_Grp2 IN OUT NOCOPY GHR_API.Pos_Grp2_TYPE,
1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,

Line 1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,

1269: P_Pos_Grp1 IN OUT NOCOPY GHR_API.Pos_Grp1_TYPE,
1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,

Line 1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,

1270: P_Pos_valid_grade IN OUT NOCOPY GHR_API.Pos_valid_grade_TYPE,
1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1278: -- Bug #6312144 New RPA EIT Benefits

Line 1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,

1271: P_Pos_car_prog IN OUT NOCOPY GHR_API.Pos_car_prog_TYPE,
1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1278: -- Bug #6312144 New RPA EIT Benefits
1279: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,

Line 1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,

1272: p_Perf_appraisal IN out nocopy ghr_api.performance_appraisal_type,
1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1278: -- Bug #6312144 New RPA EIT Benefits
1279: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
1280: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is

Line 1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,

1273: p_conduct_performance IN out nocopy ghr_api.conduct_performance_type,
1274: P_Loc_Info IN OUT NOCOPY GHR_API.Loc_Info_TYPE,
1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1278: -- Bug #6312144 New RPA EIT Benefits
1279: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
1280: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is
1281:

Line 1279: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,

1275: P_generic_Extra_Info_Rec IN out nocopy GHR_api.generic_Extra_Info_Rec_Type,
1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1278: -- Bug #6312144 New RPA EIT Benefits
1279: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
1280: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is
1281:
1282: --
1283: l_proc varchar2(70) := 'Call Extra Info';

Line 1280: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is

1276: P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
1277: p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
1278: -- Bug #6312144 New RPA EIT Benefits
1279: p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
1280: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is
1281:
1282: --
1283: l_proc varchar2(70) := 'Call Extra Info';
1284: l_segment_rec ghr_api.special_information_type;

Line 1284: l_segment_rec ghr_api.special_information_type;

1280: p_retirement_info IN out nocopy ghr_api.per_retirement_info_type) is
1281:
1282: --
1283: l_proc varchar2(70) := 'Call Extra Info';
1284: l_segment_rec ghr_api.special_information_type;
1285: l_form_field_name varchar2(50);
1286: l_posn_title_pm varchar2(50);
1287: l_WS_pm varchar2(50);
1288: l_DS_pm varchar2(50);

Line 1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;

1457: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;
1458: --Bug# 4941984(AFHR2)
1459:
1460: -- No copy Changes variables.
1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;

Line 1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;

1458: --Bug# 4941984(AFHR2)
1459:
1460: -- No copy Changes variables.
1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;

Line 1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;

1459:
1460: -- No copy Changes variables.
1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;

Line 1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;

1460: -- No copy Changes variables.
1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;

Line 1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;

1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;
1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;

Line 1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;

1462: l_Asg_non_Sf52 GHR_API.Asg_non_Sf52_TYPE;
1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;

Line 1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;

1463: l_Asg_nte_dates GHR_API.Asg_nte_dates_TYPE;
1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;

Line 1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;

1464: l_Per_Sf52 GHR_API.Per_Sf52_TYPE;
1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes

Line 1469: l_Per_probations GHR_API.Per_probations_TYPE;

1465: l_Per_Group1 GHR_API.Per_Group1_TYPE;
1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes
1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;

Line 1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;

1466: l_Per_Group2 GHR_API.Per_Group2_TYPE;
1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes
1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1474: l_Per_conversions GHR_API.Per_conversions_TYPE;

Line 1471: l_Per_security GHR_API.Per_security_TYPE;

1467: l_Per_scd_info GHR_API.Per_scd_info_TYPE;
1468: l_Per_retained_grade GHR_API.Per_retained_grade_TYPE;
1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes
1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1474: l_Per_conversions GHR_API.Per_conversions_TYPE;
1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes

Line 1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;

1469: l_Per_probations GHR_API.Per_probations_TYPE;
1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes
1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1474: l_Per_conversions GHR_API.Per_conversions_TYPE;
1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;

Line 1474: l_Per_conversions GHR_API.Per_conversions_TYPE;

1470: l_Per_sep_retire GHR_API.Per_sep_retire_TYPE;
1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes
1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1474: l_Per_conversions GHR_API.Per_conversions_TYPE;
1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;

Line 1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes

1471: l_Per_security GHR_API.Per_security_TYPE;
1472: --Bug#4486823 RRR Changes
1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1474: l_Per_conversions GHR_API.Per_conversions_TYPE;
1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;

Line 1477: l_per_benefit_info GHR_API.per_benefit_info_type;

1473: l_per_service_oblig GHR_API.Per_service_oblig_TYPE;
1474: l_Per_conversions GHR_API.Per_conversions_TYPE;
1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;

Line 1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;

1474: l_Per_conversions GHR_API.Per_conversions_TYPE;
1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;

Line 1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;

1475: l_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;

Line 1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;

1476: -- BEN_EIT Changes
1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;

Line 1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;

1477: l_per_benefit_info GHR_API.per_benefit_info_type;
1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;

Line 1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;

1478: l_Per_uniformed_services GHR_API.Per_uniformed_services_TYPE;
1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;

Line 1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;

1479: l_Pos_oblig GHR_API.Pos_oblig_TYPE;
1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;

Line 1484: l_Perf_appraisal ghr_api.performance_appraisal_type;

1480: l_Pos_Grp2 GHR_API.Pos_Grp2_TYPE;
1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;

Line 1485: l_conduct_performance ghr_api.conduct_performance_type;

1481: l_Pos_Grp1 GHR_API.Pos_Grp1_TYPE;
1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1489: ---for bug 3267632

Line 1486: l_Loc_Info GHR_API.Loc_Info_TYPE;

1482: l_Pos_valid_grade GHR_API.Pos_valid_grade_TYPE;
1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1489: ---for bug 3267632
1490: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;

Line 1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;

1483: l_Pos_car_prog GHR_API.Pos_car_prog_TYPE;
1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1489: ---for bug 3267632
1490: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;
1491: --

Line 1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;

1484: l_Perf_appraisal ghr_api.performance_appraisal_type;
1485: l_conduct_performance ghr_api.conduct_performance_type;
1486: l_Loc_Info GHR_API.Loc_Info_TYPE;
1487: l_generic_Extra_Info_Rec GHR_api.generic_Extra_Info_Rec_Type;
1488: l_par_term_retained_grade GHR_api.par_term_retained_grade_type;
1489: ---for bug 3267632
1490: l_agency_code_transfer_to ghr_pa_requests.agency_code%type;
1491: --
1492: -- Bug 3390876

Line 4743: ,p_wgi in out nocopy ghr_api.within_grade_increase_type

4739: -- ********************************
4740: --
4741: Procedure Process_salary_Info
4742: (p_pa_request_rec in ghr_pa_requests%rowtype
4743: ,p_wgi in out nocopy ghr_api.within_grade_increase_type
4744: ,p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type
4745: ,p_capped_other_pay in number default null
4746: ) is
4747:

Line 4744: ,p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type

4740: --
4741: Procedure Process_salary_Info
4742: (p_pa_request_rec in ghr_pa_requests%rowtype
4743: ,p_wgi in out nocopy ghr_api.within_grade_increase_type
4744: ,p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type
4745: ,p_capped_other_pay in number default null
4746: ) is
4747:
4748: l_proc varchar2(70) := 'Process_salary_info';

Line 4826: l_wgi ghr_api.within_grade_increase_type;

4822: pei_information9
4823: from per_people_extra_info
4824: where person_extra_info_id = l_retained_grade_rec.person_extra_info_id;
4825:
4826: l_wgi ghr_api.within_grade_increase_type;
4827: l_retention_allow_review ghr_api.retention_allow_review_type;
4828:
4829:
4830: CURSOR cur_temp_step

Line 4827: l_retention_allow_review ghr_api.retention_allow_review_type;

4823: from per_people_extra_info
4824: where person_extra_info_id = l_retained_grade_rec.person_extra_info_id;
4825:
4826: l_wgi ghr_api.within_grade_increase_type;
4827: l_retention_allow_review ghr_api.retention_allow_review_type;
4828:
4829:
4830: CURSOR cur_temp_step
4831: IS

Line 5805: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'

5801:
5802: hr_utility.trace('Pradeep l_session.noa_id_correct:'||l_session.noa_id_correct);
5803: IF l_session.noa_id_correct is null THEN
5804:
5805: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
5806: ,p_input_value_name => 'Amount'
5807: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
5808: ,p_effective_date => l_effective_date
5809: ,p_value => l_retention_allowance

Line 6511: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type

6507: -- ********************************
6508: --
6509: Procedure Process_non_salary_Info
6510: (p_pa_request_rec in ghr_pa_requests%rowtype
6511: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type

Line 6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type

6508: --
6509: Procedure Process_non_salary_Info
6510: (p_pa_request_rec in ghr_pa_requests%rowtype
6511: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type

Line 6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type

6509: Procedure Process_non_salary_Info
6510: (p_pa_request_rec in ghr_pa_requests%rowtype
6511: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6517: ,p_gov_award in out nocopy ghr_api.government_awards_type

Line 6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type

6511: ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6517: ,p_gov_award in out nocopy ghr_api.government_awards_type
6518: ,p_entitlement in out nocopy ghr_api.entitlement_type
6519: -- Bug#2759379 Added FEGLI parameter

Line 6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type

6512: ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6517: ,p_gov_award in out nocopy ghr_api.government_awards_type
6518: ,p_entitlement in out nocopy ghr_api.entitlement_type
6519: -- Bug#2759379 Added FEGLI parameter
6520: ,p_fegli in out nocopy ghr_api.fegli_type

Line 6517: ,p_gov_award in out nocopy ghr_api.government_awards_type

6513: ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6517: ,p_gov_award in out nocopy ghr_api.government_awards_type
6518: ,p_entitlement in out nocopy ghr_api.entitlement_type
6519: -- Bug#2759379 Added FEGLI parameter
6520: ,p_fegli in out nocopy ghr_api.fegli_type
6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type

Line 6518: ,p_entitlement in out nocopy ghr_api.entitlement_type

6514: --Pradeep
6515: ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6517: ,p_gov_award in out nocopy ghr_api.government_awards_type
6518: ,p_entitlement in out nocopy ghr_api.entitlement_type
6519: -- Bug#2759379 Added FEGLI parameter
6520: ,p_fegli in out nocopy ghr_api.fegli_type
6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6522: -- Bug# 3385386 Added FTA parameter

Line 6520: ,p_fegli in out nocopy ghr_api.fegli_type

6516: ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
6517: ,p_gov_award in out nocopy ghr_api.government_awards_type
6518: ,p_entitlement in out nocopy ghr_api.entitlement_type
6519: -- Bug#2759379 Added FEGLI parameter
6520: ,p_fegli in out nocopy ghr_api.fegli_type
6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6522: -- Bug# 3385386 Added FTA parameter
6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type

Line 6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type

6517: ,p_gov_award in out nocopy ghr_api.government_awards_type
6518: ,p_entitlement in out nocopy ghr_api.entitlement_type
6519: -- Bug#2759379 Added FEGLI parameter
6520: ,p_fegli in out nocopy ghr_api.fegli_type
6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6522: -- Bug# 3385386 Added FTA parameter
6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type

Line 6523: ,p_fta in out nocopy ghr_api.fta_type

6519: -- Bug#2759379 Added FEGLI parameter
6520: ,p_fegli in out nocopy ghr_api.fegli_type
6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6522: -- Bug# 3385386 Added FTA parameter
6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type

Line 6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type

6520: ,p_fegli in out nocopy ghr_api.fegli_type
6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6522: -- Bug# 3385386 Added FTA parameter
6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type

Line 6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type

6521: ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
6522: -- Bug# 3385386 Added FTA parameter
6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type

Line 6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type

6522: -- Bug# 3385386 Added FTA parameter
6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type

Line 6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type

6523: ,p_fta in out nocopy ghr_api.fta_type
6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type

Line 6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type

6524: ,p_edp_pay in out nocopy ghr_api.edp_pay_type
6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type

Line 6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type

6525: ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type

Line 6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type

6526: ,p_health_benefits in out nocopy ghr_api.health_benefits_type
6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type

Line 6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type

6527: ,p_danger_pay in out nocopy ghr_api.danger_pay_type
6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type

Line 6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type

6528: ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type

Line 6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type

6529: ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type

Line 6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type

6530: ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan

Line 6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type

6531: ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6539: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type

Line 6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type

6532: ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6539: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6540: ) is

Line 6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type

6533: ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6539: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6540: ) is
6541:

Line 6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan

6534: ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6539: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6540: ) is
6541:
6542: l_proc varchar2(70) := 'Process_Non_salary_info';

Line 6539: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type

6535: ,p_premium_pay in out nocopy ghr_api.premium_pay_type
6536: ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
6537: ,p_severance_pay in out nocopy ghr_api.severance_pay_type
6538: ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
6539: ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
6540: ) is
6541:
6542: l_proc varchar2(70) := 'Process_Non_salary_info';
6543: l_warning boolean;

Line 6547: l_recruitment_bonus ghr_api.recruitment_bonus_type;

6543: l_warning boolean;
6544: l_effective_date date;
6545: --
6546: -- No copy Changes.
6547: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6548: l_relocation_bonus ghr_api.relocation_bonus_type;
6549: l_gov_award ghr_api.government_awards_type;
6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

Line 6548: l_relocation_bonus ghr_api.relocation_bonus_type;

6544: l_effective_date date;
6545: --
6546: -- No copy Changes.
6547: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6548: l_relocation_bonus ghr_api.relocation_bonus_type;
6549: l_gov_award ghr_api.government_awards_type;
6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable

Line 6549: l_gov_award ghr_api.government_awards_type;

6545: --
6546: -- No copy Changes.
6547: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6548: l_relocation_bonus ghr_api.relocation_bonus_type;
6549: l_gov_award ghr_api.government_awards_type;
6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;

Line 6550: l_entitlement ghr_api.entitlement_type;

6546: -- No copy Changes.
6547: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6548: l_relocation_bonus ghr_api.relocation_bonus_type;
6549: l_gov_award ghr_api.government_awards_type;
6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;

Line 6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;

6547: l_recruitment_bonus ghr_api.recruitment_bonus_type;
6548: l_relocation_bonus ghr_api.relocation_bonus_type;
6549: l_gov_award ghr_api.government_awards_type;
6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;

Line 6553: l_fta ghr_api.fta_type;

6549: l_gov_award ghr_api.government_awards_type;
6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;

Line 6554: l_edp_pay ghr_api.edp_pay_type;

6550: l_entitlement ghr_api.entitlement_type;
6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;

Line 6555: l_hazard_pay ghr_api.hazard_pay_type;

6551: l_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;

Line 6556: l_health_benefits ghr_api.health_benefits_type;

6552: -- Bug# 3385386 Added l_fta variable
6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;

Line 6557: l_danger_pay ghr_api.danger_pay_type;

6553: l_fta ghr_api.fta_type;
6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;

Line 6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;

6554: l_edp_pay ghr_api.edp_pay_type;
6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

Line 6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;

6555: l_hazard_pay ghr_api.hazard_pay_type;
6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;

Line 6560: l_post_diff_amt ghr_api.post_diff_amt_type;

6556: l_health_benefits ghr_api.health_benefits_type;
6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;

Line 6561: l_post_diff_percent ghr_api.post_diff_percent_type;

6557: l_danger_pay ghr_api.danger_pay_type;
6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;

Line 6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;

6558: l_imminent_danger_pay ghr_api.imminent_danger_pay_type;
6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;

Line 6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;

6559: l_living_quarters_allow ghr_api.living_quarters_allow_type;
6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;

Line 6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;

6560: l_post_diff_amt ghr_api.post_diff_amt_type;
6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;

Line 6565: l_premium_pay ghr_api.premium_pay_type;

6561: l_post_diff_percent ghr_api.post_diff_percent_type;
6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

Line 6566: l_retirement_annuity ghr_api.retirement_annuity_type;

6562: l_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6570: l_student_loan_repay ghr_api.student_loan_repay_type;

Line 6567: l_severance_pay ghr_api.severance_pay_type;

6563: l_supplemental_post_allow ghr_api.supplemental_post_allow_type;
6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6570: l_student_loan_repay ghr_api.student_loan_repay_type;
6571: -- Bug#4486823 RRR Changes

Line 6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;

6564: l_temp_lodge_allow ghr_api.temp_lodge_allow_type;
6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6570: l_student_loan_repay ghr_api.student_loan_repay_type;
6571: -- Bug#4486823 RRR Changes
6572: l_total_salary ghr_pa_requests.to_total_salary%TYPE;

Line 6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;

6565: l_premium_pay ghr_api.premium_pay_type;
6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6570: l_student_loan_repay ghr_api.student_loan_repay_type;
6571: -- Bug#4486823 RRR Changes
6572: l_total_salary ghr_pa_requests.to_total_salary%TYPE;
6573: --

Line 6570: l_student_loan_repay ghr_api.student_loan_repay_type;

6566: l_retirement_annuity ghr_api.retirement_annuity_type;
6567: l_severance_pay ghr_api.severance_pay_type;
6568: l_thrift_saving_plan ghr_api.thrift_saving_plan;
6569: l_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
6570: l_student_loan_repay ghr_api.student_loan_repay_type;
6571: -- Bug#4486823 RRR Changes
6572: l_total_salary ghr_pa_requests.to_total_salary%TYPE;
6573: --
6574: PROCEDURE Create_incentive_Remark(p_pa_request_id IN NUMBER,

Line 8209: p_segment_rec in ghr_api.special_information_type

8205: --
8206: Procedure generic_update_sit
8207: (p_pa_request_rec in ghr_pa_requests%rowtype,
8208: p_special_information_type in fnd_id_flex_structures_tl.id_flex_structure_name%type,
8209: p_segment_rec in ghr_api.special_information_type
8210: )
8211: is
8212:
8213: l_proc varchar2(72) := 'Generic Update SIT';