11: --
12: PROCEDURE set_form_item_name(p_value IN VARCHAR2);
13: --
14: PROCEDURE main_validation(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
15: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
16: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
17: ,p_per_group1_type IN ghr_api.per_group1_type
18: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
19: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
12: PROCEDURE set_form_item_name(p_value IN VARCHAR2);
13: --
14: PROCEDURE main_validation(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
15: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
16: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
17: ,p_per_group1_type IN ghr_api.per_group1_type
18: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
19: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
20: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
13: --
14: PROCEDURE main_validation(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
15: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
16: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
17: ,p_per_group1_type IN ghr_api.per_group1_type
18: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
19: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
20: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
21: ,p_per_probations_type IN ghr_api.per_probations_type
14: PROCEDURE main_validation(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
15: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
16: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
17: ,p_per_group1_type IN ghr_api.per_group1_type
18: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
19: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
20: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
21: ,p_per_probations_type IN ghr_api.per_probations_type
22: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
15: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
16: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
17: ,p_per_group1_type IN ghr_api.per_group1_type
18: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
19: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
20: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
21: ,p_per_probations_type IN ghr_api.per_probations_type
22: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
23: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
16: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
17: ,p_per_group1_type IN ghr_api.per_group1_type
18: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
19: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
20: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
21: ,p_per_probations_type IN ghr_api.per_probations_type
22: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
23: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
24: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
17: ,p_per_group1_type IN ghr_api.per_group1_type
18: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
19: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
20: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
21: ,p_per_probations_type IN ghr_api.per_probations_type
22: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
23: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
24: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
25: ,p_government_awards_type IN ghr_api.government_awards_type
18: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
19: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
20: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
21: ,p_per_probations_type IN ghr_api.per_probations_type
22: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
23: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
24: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
25: ,p_government_awards_type IN ghr_api.government_awards_type
26: ,p_government_payroll_type IN ghr_api.government_payroll_type
19: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type
20: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
21: ,p_per_probations_type IN ghr_api.per_probations_type
22: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
23: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
24: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
25: ,p_government_awards_type IN ghr_api.government_awards_type
26: ,p_government_payroll_type IN ghr_api.government_payroll_type
27: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
20: ,p_per_sep_retire_type IN ghr_api.per_sep_retire_type
21: ,p_per_probations_type IN ghr_api.per_probations_type
22: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
23: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
24: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
25: ,p_government_awards_type IN ghr_api.government_awards_type
26: ,p_government_payroll_type IN ghr_api.government_payroll_type
27: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
28: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
21: ,p_per_probations_type IN ghr_api.per_probations_type
22: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
23: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
24: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
25: ,p_government_awards_type IN ghr_api.government_awards_type
26: ,p_government_payroll_type IN ghr_api.government_payroll_type
27: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
28: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
29: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
22: ,p_pos_grp1_type IN ghr_api.pos_grp1_type
23: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
24: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
25: ,p_government_awards_type IN ghr_api.government_awards_type
26: ,p_government_payroll_type IN ghr_api.government_payroll_type
27: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
28: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
29: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
30: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
23: ,p_pos_grp2_type IN ghr_api.pos_grp2_type
24: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
25: ,p_government_awards_type IN ghr_api.government_awards_type
26: ,p_government_payroll_type IN ghr_api.government_payroll_type
27: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
28: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
29: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
30: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
31: --Pradeep
24: ,p_within_grade_increase_type IN ghr_api.within_grade_increase_type
25: ,p_government_awards_type IN ghr_api.government_awards_type
26: ,p_government_payroll_type IN ghr_api.government_payroll_type
27: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
28: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
29: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
30: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
31: --Pradeep
32: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
25: ,p_government_awards_type IN ghr_api.government_awards_type
26: ,p_government_payroll_type IN ghr_api.government_payroll_type
27: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
28: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
29: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
30: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
31: --Pradeep
32: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
33: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
26: ,p_government_payroll_type IN ghr_api.government_payroll_type
27: ,p_performance_appraisal_type IN ghr_api.performance_appraisal_type
28: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
29: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
30: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
31: --Pradeep
32: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
33: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
34: ,p_per_conversions_type IN ghr_api.per_conversions_type
28: ,p_recruitment_bonus_type IN ghr_api.recruitment_bonus_type
29: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
30: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
31: --Pradeep
32: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
33: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
34: ,p_per_conversions_type IN ghr_api.per_conversions_type
35: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
36: -- Sundar Bug 4582970 Added for Benefits EIT validation
29: ,p_relocation_bonus_type IN ghr_api.relocation_bonus_type
30: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
31: --Pradeep
32: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
33: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
34: ,p_per_conversions_type IN ghr_api.per_conversions_type
35: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
36: -- Sundar Bug 4582970 Added for Benefits EIT validation
37: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
30: ,p_student_loan_repay_type IN ghr_api.student_loan_repay_type
31: --Pradeep
32: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
33: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
34: ,p_per_conversions_type IN ghr_api.per_conversions_type
35: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
36: -- Sundar Bug 4582970 Added for Benefits EIT validation
37: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
38: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
31: --Pradeep
32: ,p_mddds_special_pay IN ghr_api.mddds_special_pay_type
33: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
34: ,p_per_conversions_type IN ghr_api.per_conversions_type
35: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
36: -- Sundar Bug 4582970 Added for Benefits EIT validation
37: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
38: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
39: ,p_per_scd_info_type IN ghr_api.per_scd_info_type
33: ,p_premium_pay_ind IN ghr_api.premium_pay_ind_type
34: ,p_per_conversions_type IN ghr_api.per_conversions_type
35: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
36: -- Sundar Bug 4582970 Added for Benefits EIT validation
37: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
38: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
39: ,p_per_scd_info_type IN ghr_api.per_scd_info_type
40:
41: );
34: ,p_per_conversions_type IN ghr_api.per_conversions_type
35: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
36: -- Sundar Bug 4582970 Added for Benefits EIT validation
37: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
38: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
39: ,p_per_scd_info_type IN ghr_api.per_scd_info_type
40:
41: );
42: --
35: ,p_conduct_performance_type IN ghr_api.conduct_performance_type
36: -- Sundar Bug 4582970 Added for Benefits EIT validation
37: ,p_thrift_savings_plan IN ghr_api.thrift_saving_plan
38: ,p_per_benefit_info IN ghr_api.per_benefit_info_type
39: ,p_per_scd_info_type IN ghr_api.per_scd_info_type
40:
41: );
42: --
43: FUNCTION get_exemp_award_date(p_pa_request_id IN NUMBER)