APPS.GHR_UPD_HR_VALIDATION dependencies on HR_API

Line 115: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type

111: END set_form_item_name;
112: --
113: -- Sundar Bug 4582970 - Added 3 parameters for benefits eit validation
114: PROCEDURE check_required(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
115: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
116: ,p_per_group1_type IN ghr_api.per_group1_type
117: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
118: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
119: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type

Line 116: ,p_per_group1_type IN ghr_api.per_group1_type

112: --
113: -- Sundar Bug 4582970 - Added 3 parameters for benefits eit validation
114: PROCEDURE check_required(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
115: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
116: ,p_per_group1_type IN ghr_api.per_group1_type
117: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
118: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
119: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
120: ,p_per_probations_type IN ghr_api.per_probations_type

Line 117: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type

113: -- Sundar Bug 4582970 - Added 3 parameters for benefits eit validation
114: PROCEDURE check_required(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
115: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
116: ,p_per_group1_type IN ghr_api.per_group1_type
117: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
118: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
119: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
120: ,p_per_probations_type IN ghr_api.per_probations_type
121: ,p_pos_grp1_type IN ghr_api.pos_grp1_type

Line 118: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type

114: PROCEDURE check_required(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
115: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
116: ,p_per_group1_type IN ghr_api.per_group1_type
117: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
118: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
119: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
120: ,p_per_probations_type IN ghr_api.per_probations_type
121: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
122: ,p_pos_grp2_type IN ghr_api.pos_grp2_type

Line 119: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type

115: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
116: ,p_per_group1_type IN ghr_api.per_group1_type
117: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
118: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
119: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
120: ,p_per_probations_type IN ghr_api.per_probations_type
121: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
122: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
123: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type

Line 120: ,p_per_probations_type IN ghr_api.per_probations_type

116: ,p_per_group1_type IN ghr_api.per_group1_type
117: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
118: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
119: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
120: ,p_per_probations_type IN ghr_api.per_probations_type
121: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
122: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
123: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
124: ,p_government_awards_type IN ghr_api.government_awards_type

Line 121: ,p_pos_grp1_type IN ghr_api.pos_grp1_type

117: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
118: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
119: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
120: ,p_per_probations_type IN ghr_api.per_probations_type
121: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
122: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
123: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
124: ,p_government_awards_type IN ghr_api.government_awards_type
125: ,p_government_payroll_type IN ghr_api.government_payroll_type

Line 122: ,p_pos_grp2_type IN ghr_api.pos_grp2_type

118: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
119: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
120: ,p_per_probations_type IN ghr_api.per_probations_type
121: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
122: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
123: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
124: ,p_government_awards_type IN ghr_api.government_awards_type
125: ,p_government_payroll_type IN ghr_api.government_payroll_type
126: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type

Line 123: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type

119: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
120: ,p_per_probations_type IN ghr_api.per_probations_type
121: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
122: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
123: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
124: ,p_government_awards_type IN ghr_api.government_awards_type
125: ,p_government_payroll_type IN ghr_api.government_payroll_type
126: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
127: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type

Line 124: ,p_government_awards_type IN ghr_api.government_awards_type

120: ,p_per_probations_type IN ghr_api.per_probations_type
121: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
122: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
123: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
124: ,p_government_awards_type IN ghr_api.government_awards_type
125: ,p_government_payroll_type IN ghr_api.government_payroll_type
126: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
127: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
128: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type

Line 125: ,p_government_payroll_type IN ghr_api.government_payroll_type

121: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
122: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
123: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
124: ,p_government_awards_type IN ghr_api.government_awards_type
125: ,p_government_payroll_type IN ghr_api.government_payroll_type
126: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
127: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
128: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
129: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type

Line 126: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type

122: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
123: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
124: ,p_government_awards_type IN ghr_api.government_awards_type
125: ,p_government_payroll_type IN ghr_api.government_payroll_type
126: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
127: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
128: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
129: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
130: --Pradeep

Line 127: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type

123: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
124: ,p_government_awards_type IN ghr_api.government_awards_type
125: ,p_government_payroll_type IN ghr_api.government_payroll_type
126: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
127: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
128: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
129: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
130: --Pradeep
131: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type

Line 128: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type

124: ,p_government_awards_type IN ghr_api.government_awards_type
125: ,p_government_payroll_type IN ghr_api.government_payroll_type
126: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
127: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
128: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
129: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
130: --Pradeep
131: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
132: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type

Line 129: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type

125: ,p_government_payroll_type IN ghr_api.government_payroll_type
126: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
127: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
128: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
129: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
130: --Pradeep
131: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
132: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
133: ,p_per_conversions_type IN ghr_api.per_conversions_type

Line 131: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type

127: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
128: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
129: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
130: --Pradeep
131: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
132: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
133: ,p_per_conversions_type IN ghr_api.per_conversions_type
134: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
135: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan

Line 132: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type

128: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
129: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
130: --Pradeep
131: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
132: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
133: ,p_per_conversions_type IN ghr_api.per_conversions_type
134: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
135: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
136: ,p_per_benefit_info IN ghr_api.per_benefit_info_type

Line 133: ,p_per_conversions_type IN ghr_api.per_conversions_type

129: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
130: --Pradeep
131: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
132: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
133: ,p_per_conversions_type IN ghr_api.per_conversions_type
134: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
135: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
136: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
137: ,p_per_scd_info_type IN ghr_api.per_scd_info_type

Line 134: ,p_conduct_performance_type IN ghr_api.conduct_performance_type

130: --Pradeep
131: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
132: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
133: ,p_per_conversions_type IN ghr_api.per_conversions_type
134: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
135: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
136: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
137: ,p_per_scd_info_type IN ghr_api.per_scd_info_type
138: ) IS

Line 135: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan

131: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
132: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
133: ,p_per_conversions_type IN ghr_api.per_conversions_type
134: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
135: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
136: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
137: ,p_per_scd_info_type IN ghr_api.per_scd_info_type
138: ) IS
139:

Line 136: ,p_per_benefit_info IN ghr_api.per_benefit_info_type

132: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
133: ,p_per_conversions_type IN ghr_api.per_conversions_type
134: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
135: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
136: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
137: ,p_per_scd_info_type IN ghr_api.per_scd_info_type
138: ) IS
139:
140: l_proc varchar2(72) := g_package||'check_required';

Line 137: ,p_per_scd_info_type IN ghr_api.per_scd_info_type

133: ,p_per_conversions_type IN ghr_api.per_conversions_type
134: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
135: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
136: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
137: ,p_per_scd_info_type IN ghr_api.per_scd_info_type
138: ) IS
139:
140: l_proc varchar2(72) := g_package||'check_required';
141:

Line 360: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type

356: --
357: END check_insertion_values;
358: --
359: PROCEDURE main_validation(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
360: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
361: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
362: ,p_per_group1_type IN ghr_api.per_group1_type
363: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
364: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type

Line 361: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type

357: END check_insertion_values;
358: --
359: PROCEDURE main_validation(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
360: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
361: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
362: ,p_per_group1_type IN ghr_api.per_group1_type
363: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
364: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
365: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type

Line 362: ,p_per_group1_type IN ghr_api.per_group1_type

358: --
359: PROCEDURE main_validation(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
360: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
361: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
362: ,p_per_group1_type IN ghr_api.per_group1_type
363: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
364: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
365: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
366: ,p_per_probations_type IN ghr_api.per_probations_type

Line 363: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type

359: PROCEDURE main_validation(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
360: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
361: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
362: ,p_per_group1_type IN ghr_api.per_group1_type
363: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
364: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
365: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
366: ,p_per_probations_type IN ghr_api.per_probations_type
367: ,p_pos_grp1_type IN ghr_api.pos_grp1_type

Line 364: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type

360: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
361: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
362: ,p_per_group1_type IN ghr_api.per_group1_type
363: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
364: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
365: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
366: ,p_per_probations_type IN ghr_api.per_probations_type
367: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
368: ,p_pos_grp2_type IN ghr_api.pos_grp2_type

Line 365: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type

361: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
362: ,p_per_group1_type IN ghr_api.per_group1_type
363: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
364: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
365: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
366: ,p_per_probations_type IN ghr_api.per_probations_type
367: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
368: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
369: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type

Line 366: ,p_per_probations_type IN ghr_api.per_probations_type

362: ,p_per_group1_type IN ghr_api.per_group1_type
363: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
364: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
365: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
366: ,p_per_probations_type IN ghr_api.per_probations_type
367: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
368: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
369: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
370: ,p_government_awards_type IN ghr_api.government_awards_type

Line 367: ,p_pos_grp1_type IN ghr_api.pos_grp1_type

363: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
364: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
365: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
366: ,p_per_probations_type IN ghr_api.per_probations_type
367: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
368: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
369: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
370: ,p_government_awards_type IN ghr_api.government_awards_type
371: ,p_government_payroll_type IN ghr_api.government_payroll_type

Line 368: ,p_pos_grp2_type IN ghr_api.pos_grp2_type

364: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
365: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
366: ,p_per_probations_type IN ghr_api.per_probations_type
367: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
368: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
369: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
370: ,p_government_awards_type IN ghr_api.government_awards_type
371: ,p_government_payroll_type IN ghr_api.government_payroll_type
372: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type

Line 369: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type

365: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
366: ,p_per_probations_type IN ghr_api.per_probations_type
367: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
368: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
369: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
370: ,p_government_awards_type IN ghr_api.government_awards_type
371: ,p_government_payroll_type IN ghr_api.government_payroll_type
372: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
373: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type

Line 370: ,p_government_awards_type IN ghr_api.government_awards_type

366: ,p_per_probations_type IN ghr_api.per_probations_type
367: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
368: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
369: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
370: ,p_government_awards_type IN ghr_api.government_awards_type
371: ,p_government_payroll_type IN ghr_api.government_payroll_type
372: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
373: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
374: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type

Line 371: ,p_government_payroll_type IN ghr_api.government_payroll_type

367: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
368: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
369: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
370: ,p_government_awards_type IN ghr_api.government_awards_type
371: ,p_government_payroll_type IN ghr_api.government_payroll_type
372: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
373: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
374: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
375: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type

Line 372: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type

368: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
369: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
370: ,p_government_awards_type IN ghr_api.government_awards_type
371: ,p_government_payroll_type IN ghr_api.government_payroll_type
372: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
373: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
374: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
375: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
376: --Pradeep

Line 373: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type

369: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
370: ,p_government_awards_type IN ghr_api.government_awards_type
371: ,p_government_payroll_type IN ghr_api.government_payroll_type
372: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
373: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
374: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
375: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
376: --Pradeep
377: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type

Line 374: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type

370: ,p_government_awards_type IN ghr_api.government_awards_type
371: ,p_government_payroll_type IN ghr_api.government_payroll_type
372: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
373: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
374: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
375: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
376: --Pradeep
377: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
378: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type

Line 375: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type

371: ,p_government_payroll_type IN ghr_api.government_payroll_type
372: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
373: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
374: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
375: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
376: --Pradeep
377: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
378: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
379: ,p_per_conversions_type IN ghr_api.per_conversions_type

Line 377: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type

373: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
374: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
375: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
376: --Pradeep
377: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
378: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
379: ,p_per_conversions_type IN ghr_api.per_conversions_type
380: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
381: -- Sundar Bug 4582970 Added for Benefits EIT validation

Line 378: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type

374: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
375: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
376: --Pradeep
377: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
378: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
379: ,p_per_conversions_type IN ghr_api.per_conversions_type
380: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
381: -- Sundar Bug 4582970 Added for Benefits EIT validation
382: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan

Line 379: ,p_per_conversions_type IN ghr_api.per_conversions_type

375: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
376: --Pradeep
377: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
378: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
379: ,p_per_conversions_type IN ghr_api.per_conversions_type
380: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
381: -- Sundar Bug 4582970 Added for Benefits EIT validation
382: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
383: ,p_per_benefit_info IN ghr_api.per_benefit_info_type

Line 380: ,p_conduct_performance_type IN ghr_api.conduct_performance_type

376: --Pradeep
377: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
378: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
379: ,p_per_conversions_type IN ghr_api.per_conversions_type
380: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
381: -- Sundar Bug 4582970 Added for Benefits EIT validation
382: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
383: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
384: ,p_per_scd_info_type IN ghr_api.per_scd_info_type

Line 382: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan

378: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
379: ,p_per_conversions_type IN ghr_api.per_conversions_type
380: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
381: -- Sundar Bug 4582970 Added for Benefits EIT validation
382: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
383: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
384: ,p_per_scd_info_type IN ghr_api.per_scd_info_type
385: ) IS
386: l_proc varchar2(72) := g_package||'main_validation';

Line 383: ,p_per_benefit_info IN ghr_api.per_benefit_info_type

379: ,p_per_conversions_type IN ghr_api.per_conversions_type
380: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
381: -- Sundar Bug 4582970 Added for Benefits EIT validation
382: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
383: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
384: ,p_per_scd_info_type IN ghr_api.per_scd_info_type
385: ) IS
386: l_proc varchar2(72) := g_package||'main_validation';
387: BEGIN

Line 384: ,p_per_scd_info_type IN ghr_api.per_scd_info_type

380: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
381: -- Sundar Bug 4582970 Added for Benefits EIT validation
382: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
383: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
384: ,p_per_scd_info_type IN ghr_api.per_scd_info_type
385: ) IS
386: l_proc varchar2(72) := g_package||'main_validation';
387: BEGIN
388: hr_utility.set_location('Entering:'||l_proc, 1);

Line 402: set_column('AWARD_AMOUNT', hr_api.g_number);

398: set_column('AUTHORIZED_BY_PERSON_ID', p_pa_requests_type.authorized_by_person_id);
399: set_column('AUTHORIZED_BY_TITLE', p_pa_requests_type.authorized_by_title);
400: ----GPPA Update Req. for 891, 892 to bypass
401: if p_pa_requests_type.first_noa_code in ('891','892') Then
402: set_column('AWARD_AMOUNT', hr_api.g_number);
403: set_column('AWARD_UOM', hr_api.g_varchar2);
404: ----GPPA End
405: else
406: set_column('AWARD_AMOUNT', p_pa_requests_type.award_amount);

Line 403: set_column('AWARD_UOM', hr_api.g_varchar2);

399: set_column('AUTHORIZED_BY_TITLE', p_pa_requests_type.authorized_by_title);
400: ----GPPA Update Req. for 891, 892 to bypass
401: if p_pa_requests_type.first_noa_code in ('891','892') Then
402: set_column('AWARD_AMOUNT', hr_api.g_number);
403: set_column('AWARD_UOM', hr_api.g_varchar2);
404: ----GPPA End
405: else
406: set_column('AWARD_AMOUNT', p_pa_requests_type.award_amount);
407: set_column('AWARD_UOM', p_pa_requests_type.award_uom);

Line 424: -- Assigning hr_api.g_varchar2 to First Legal Authority fields

420: set_column('EMPLOYEE_NATIONAL_IDENTIFIER', p_pa_requests_type.employee_national_identifier);
421: set_column('FEGLI', p_pa_requests_type.fegli);
422: set_column('FEGLI_DESC', p_pa_requests_type.fegli_desc);
423: -- Start Bug 1379280
424: -- Assigning hr_api.g_varchar2 to First Legal Authority fields
425:
426: hr_utility.set_location('effe date ....'||to_char(p_pa_requests_type.effective_date,'DD/MM/YYYY'),9999);
427:
428: -- to avoid getting required error message for NOACs 840-847,849

Line 435: set_column('FIRST_ACTION_LA_CODE1', hr_api.g_varchar2);

431: '886','887','889')) --removed 885 and 886 for bug 5676626
432: --Added 886 for Bug # 6127577
433: OR (p_pa_requests_type.first_noa_code in ('849') and
434: p_pa_requests_type.effective_date > to_date('2007/01/06','YYYY/MM/DD'))then --bug 5482191
435: set_column('FIRST_ACTION_LA_CODE1', hr_api.g_varchar2);
436: set_column('FIRST_ACTION_LA_CODE2', hr_api.g_varchar2);
437: set_column('FIRST_ACTION_LA_DESC1', hr_api.g_varchar2);
438: set_column('FIRST_ACTION_LA_DESC2', hr_api.g_varchar2);
439: else

Line 436: set_column('FIRST_ACTION_LA_CODE2', hr_api.g_varchar2);

432: --Added 886 for Bug # 6127577
433: OR (p_pa_requests_type.first_noa_code in ('849') and
434: p_pa_requests_type.effective_date > to_date('2007/01/06','YYYY/MM/DD'))then --bug 5482191
435: set_column('FIRST_ACTION_LA_CODE1', hr_api.g_varchar2);
436: set_column('FIRST_ACTION_LA_CODE2', hr_api.g_varchar2);
437: set_column('FIRST_ACTION_LA_DESC1', hr_api.g_varchar2);
438: set_column('FIRST_ACTION_LA_DESC2', hr_api.g_varchar2);
439: else
440: set_column('FIRST_ACTION_LA_CODE1', p_pa_requests_type.first_action_la_code1);

Line 437: set_column('FIRST_ACTION_LA_DESC1', hr_api.g_varchar2);

433: OR (p_pa_requests_type.first_noa_code in ('849') and
434: p_pa_requests_type.effective_date > to_date('2007/01/06','YYYY/MM/DD'))then --bug 5482191
435: set_column('FIRST_ACTION_LA_CODE1', hr_api.g_varchar2);
436: set_column('FIRST_ACTION_LA_CODE2', hr_api.g_varchar2);
437: set_column('FIRST_ACTION_LA_DESC1', hr_api.g_varchar2);
438: set_column('FIRST_ACTION_LA_DESC2', hr_api.g_varchar2);
439: else
440: set_column('FIRST_ACTION_LA_CODE1', p_pa_requests_type.first_action_la_code1);
441: set_column('FIRST_ACTION_LA_CODE2', p_pa_requests_type.first_action_la_code2);

Line 438: set_column('FIRST_ACTION_LA_DESC2', hr_api.g_varchar2);

434: p_pa_requests_type.effective_date > to_date('2007/01/06','YYYY/MM/DD'))then --bug 5482191
435: set_column('FIRST_ACTION_LA_CODE1', hr_api.g_varchar2);
436: set_column('FIRST_ACTION_LA_CODE2', hr_api.g_varchar2);
437: set_column('FIRST_ACTION_LA_DESC1', hr_api.g_varchar2);
438: set_column('FIRST_ACTION_LA_DESC2', hr_api.g_varchar2);
439: else
440: set_column('FIRST_ACTION_LA_CODE1', p_pa_requests_type.first_action_la_code1);
441: set_column('FIRST_ACTION_LA_CODE2', p_pa_requests_type.first_action_la_code2);
442: set_column('FIRST_ACTION_LA_DESC1', p_pa_requests_type.first_action_la_desc1);

Line 555: set_column('DATE_FROM', hr_api.g_date);

551: IF NOT ( p_pa_requests_type.first_noa_code = '890' AND
552: p_pa_requests_type.input_pay_rate_determinant in ('A','B','E','F','U','V') ) THEN
553: hr_utility.set_location('Input Pay Rate Determinant ' || p_pa_requests_type.input_pay_rate_determinant, 99999);
554: hr_utility.set_location('First Noa Code ' || p_pa_requests_type.first_noa_code, 99999);
555: set_column('DATE_FROM', hr_api.g_date);
556: set_column('DATE_TO', hr_api.g_date);
557: set_column('RETAIN_GRADE', hr_api.g_varchar2);
558: set_column('RETAIN_STEP_OR_RATE', hr_api.g_varchar2);
559: set_column('RETAIN_PAY_PLAN', hr_api.g_varchar2);

Line 556: set_column('DATE_TO', hr_api.g_date);

552: p_pa_requests_type.input_pay_rate_determinant in ('A','B','E','F','U','V') ) THEN
553: hr_utility.set_location('Input Pay Rate Determinant ' || p_pa_requests_type.input_pay_rate_determinant, 99999);
554: hr_utility.set_location('First Noa Code ' || p_pa_requests_type.first_noa_code, 99999);
555: set_column('DATE_FROM', hr_api.g_date);
556: set_column('DATE_TO', hr_api.g_date);
557: set_column('RETAIN_GRADE', hr_api.g_varchar2);
558: set_column('RETAIN_STEP_OR_RATE', hr_api.g_varchar2);
559: set_column('RETAIN_PAY_PLAN', hr_api.g_varchar2);
560: set_column('RETAIN_PAY_TABLE_ID', hr_api.g_number);

Line 557: set_column('RETAIN_GRADE', hr_api.g_varchar2);

553: hr_utility.set_location('Input Pay Rate Determinant ' || p_pa_requests_type.input_pay_rate_determinant, 99999);
554: hr_utility.set_location('First Noa Code ' || p_pa_requests_type.first_noa_code, 99999);
555: set_column('DATE_FROM', hr_api.g_date);
556: set_column('DATE_TO', hr_api.g_date);
557: set_column('RETAIN_GRADE', hr_api.g_varchar2);
558: set_column('RETAIN_STEP_OR_RATE', hr_api.g_varchar2);
559: set_column('RETAIN_PAY_PLAN', hr_api.g_varchar2);
560: set_column('RETAIN_PAY_TABLE_ID', hr_api.g_number);
561: set_column('RETAIN_LOCALITY_PERCENT', hr_api.g_number);

Line 558: set_column('RETAIN_STEP_OR_RATE', hr_api.g_varchar2);

554: hr_utility.set_location('First Noa Code ' || p_pa_requests_type.first_noa_code, 99999);
555: set_column('DATE_FROM', hr_api.g_date);
556: set_column('DATE_TO', hr_api.g_date);
557: set_column('RETAIN_GRADE', hr_api.g_varchar2);
558: set_column('RETAIN_STEP_OR_RATE', hr_api.g_varchar2);
559: set_column('RETAIN_PAY_PLAN', hr_api.g_varchar2);
560: set_column('RETAIN_PAY_TABLE_ID', hr_api.g_number);
561: set_column('RETAIN_LOCALITY_PERCENT', hr_api.g_number);
562: set_column('RETAIN_PAY_BASIS', hr_api.g_varchar2);

Line 559: set_column('RETAIN_PAY_PLAN', hr_api.g_varchar2);

555: set_column('DATE_FROM', hr_api.g_date);
556: set_column('DATE_TO', hr_api.g_date);
557: set_column('RETAIN_GRADE', hr_api.g_varchar2);
558: set_column('RETAIN_STEP_OR_RATE', hr_api.g_varchar2);
559: set_column('RETAIN_PAY_PLAN', hr_api.g_varchar2);
560: set_column('RETAIN_PAY_TABLE_ID', hr_api.g_number);
561: set_column('RETAIN_LOCALITY_PERCENT', hr_api.g_number);
562: set_column('RETAIN_PAY_BASIS', hr_api.g_varchar2);
563: set_column('PERSON_EXTRA_INFO_ID' , hr_api.g_number);

Line 560: set_column('RETAIN_PAY_TABLE_ID', hr_api.g_number);

556: set_column('DATE_TO', hr_api.g_date);
557: set_column('RETAIN_GRADE', hr_api.g_varchar2);
558: set_column('RETAIN_STEP_OR_RATE', hr_api.g_varchar2);
559: set_column('RETAIN_PAY_PLAN', hr_api.g_varchar2);
560: set_column('RETAIN_PAY_TABLE_ID', hr_api.g_number);
561: set_column('RETAIN_LOCALITY_PERCENT', hr_api.g_number);
562: set_column('RETAIN_PAY_BASIS', hr_api.g_varchar2);
563: set_column('PERSON_EXTRA_INFO_ID' , hr_api.g_number);
564: ELSE

Line 561: set_column('RETAIN_LOCALITY_PERCENT', hr_api.g_number);

557: set_column('RETAIN_GRADE', hr_api.g_varchar2);
558: set_column('RETAIN_STEP_OR_RATE', hr_api.g_varchar2);
559: set_column('RETAIN_PAY_PLAN', hr_api.g_varchar2);
560: set_column('RETAIN_PAY_TABLE_ID', hr_api.g_number);
561: set_column('RETAIN_LOCALITY_PERCENT', hr_api.g_number);
562: set_column('RETAIN_PAY_BASIS', hr_api.g_varchar2);
563: set_column('PERSON_EXTRA_INFO_ID' , hr_api.g_number);
564: ELSE
565: set_column('DATE_FROM', p_per_retained_grade_type.date_from);

Line 562: set_column('RETAIN_PAY_BASIS', hr_api.g_varchar2);

558: set_column('RETAIN_STEP_OR_RATE', hr_api.g_varchar2);
559: set_column('RETAIN_PAY_PLAN', hr_api.g_varchar2);
560: set_column('RETAIN_PAY_TABLE_ID', hr_api.g_number);
561: set_column('RETAIN_LOCALITY_PERCENT', hr_api.g_number);
562: set_column('RETAIN_PAY_BASIS', hr_api.g_varchar2);
563: set_column('PERSON_EXTRA_INFO_ID' , hr_api.g_number);
564: ELSE
565: set_column('DATE_FROM', p_per_retained_grade_type.date_from);
566: set_column('DATE_TO', p_per_retained_grade_type.date_to);

Line 563: set_column('PERSON_EXTRA_INFO_ID' , hr_api.g_number);

559: set_column('RETAIN_PAY_PLAN', hr_api.g_varchar2);
560: set_column('RETAIN_PAY_TABLE_ID', hr_api.g_number);
561: set_column('RETAIN_LOCALITY_PERCENT', hr_api.g_number);
562: set_column('RETAIN_PAY_BASIS', hr_api.g_varchar2);
563: set_column('PERSON_EXTRA_INFO_ID' , hr_api.g_number);
564: ELSE
565: set_column('DATE_FROM', p_per_retained_grade_type.date_from);
566: set_column('DATE_TO', p_per_retained_grade_type.date_to);
567: set_column('RETAIN_GRADE', p_per_retained_grade_type.retain_grade);