1 PACKAGE GHR_SF52_DO_UPDATE AUTHID CURRENT_USER AS
2 /* $Header: gh52doup.pkh 120.5.12020000.2 2012/07/05 13:44:57 amnaraya ship $ */
3 --
4 g_retained_grade_info ghr_pay_calc.retained_grade_rec_type;
5 --
6 --
7 procedure Process_Family
8 (P_PA_REQUEST_REC in out nocopy ghr_pa_requests%rowtype,
9 P_AGENCY_CODE in varchar2
10 );
11
12 Procedure call_extra_info_api
13 (P_PA_REQUEST_REC in ghr_pa_requests%rowtype,
14 P_Asg_Sf52 in out nocopy ghr_api.asg_Sf52_TYPE,
15 P_Asg_non_Sf52 in out nocopy ghr_api.asg_non_Sf52_TYPE,
16 P_Asg_nte_dates in out nocopy ghr_api.asg_nte_dates_TYPE,
17 p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
18 P_Per_Sf52 in out nocopy ghr_api.per_Sf52_TYPE,
19 P_Per_Group1 in out nocopy ghr_api.per_Group1_TYPE,
20 P_Per_Group2 in out nocopy ghr_api.per_Group2_TYPE,
21 P_Per_scd_info in out nocopy ghr_api.per_scd_info_TYPE,
22 P_Per_retained_grade in out nocopy ghr_api.per_retained_grade_TYPE,
23 P_Per_probations in out nocopy ghr_api.per_probations_TYPE,
24 P_Per_sep_retire in out nocopy ghr_api.per_sep_retire_TYPE,
25 P_Per_security in out nocopy ghr_api.per_security_TYPE,
26 --Bug#4486823 RRR Changes
27 p_per_service_oblig IN OUT NOCOPY GHR_API.Per_service_oblig_TYPE,
28 P_Per_conversions in out nocopy ghr_api.per_conversions_TYPE,
29 -- BEN_EIT Changes
30 p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
31 P_Per_uniformed_services in out nocopy ghr_api.per_uniformed_services_TYPE,
32 P_Pos_oblig in out nocopy ghr_api.pos_oblig_TYPE,
33 P_Pos_Grp2 in out nocopy ghr_api.pos_Grp2_TYPE,
34 P_Pos_Grp1 in out nocopy ghr_api.pos_Grp1_TYPE,
35 P_Pos_valid_grade in out nocopy ghr_api.pos_valid_grade_TYPE,
36 P_Pos_car_prog in out nocopy ghr_api.pos_car_prog_TYPE,
37 p_perf_appraisal in out nocopy ghr_api.performance_appraisal_type,
38 p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
39 P_Loc_Info in out nocopy ghr_api.Loc_Info_TYPE,
40 P_generic_Extra_Info_Rec in out nocopy ghr_api.generic_Extra_Info_Rec_Type,
41 P_par_term_retained_grade IN out nocopy GHR_api.par_term_retained_grade_type,
42 p_per_race_ethnic_info IN out nocopy ghr_api.per_race_ethnic_type,
43 --6312144 added new parameters for RPA EIT Benefits.
44 p_ipa_benefits_cont IN out nocopy ghr_api.per_ipa_ben_cont_info_type,
45 p_retirement_info IN out nocopy ghr_api.per_retirement_info_type
46 );
47
48 Procedure Process_salary_Info
49 (p_pa_request_rec in ghr_pa_requests%rowtype
50 ,p_wgi in out nocopy ghr_api.within_grade_increase_type
51 ,p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type
52 ,p_capped_other_pay in number default null
53 );
54
55 Procedure Process_non_salary_Info
56 (p_pa_request_rec in ghr_pa_requests%rowtype
57 ,p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type
58 ,p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type
59 ,p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type
60 --Pradeep
61 ,p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type
62 ,p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type
63
64 ,p_gov_award in out nocopy ghr_api.government_awards_type
65 ,p_entitlement in out nocopy ghr_api.entitlement_type
66 -- Bug#2759379 Added extra parameter p_fegli
67 ,p_fegli in out nocopy ghr_api.fegli_type
68 ,p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type
69 -- Bug#3385386 Added extra parameter p_fta
70 ,p_fta in out nocopy ghr_api.fta_type
71 ,p_edp_pay in out nocopy ghr_api.edp_pay_type
72 ,p_hazard_pay in out nocopy ghr_api.hazard_pay_type
73 ,p_health_benefits in out nocopy ghr_api.health_benefits_type
74 ,p_danger_pay in out nocopy ghr_api.danger_pay_type
75 ,p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type
76 ,p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type
77 ,p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type
78 ,p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type
79 ,p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type
80 ,p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type
81 ,p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type
82 ,p_premium_pay in out nocopy ghr_api.premium_pay_type
83 ,p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type
84 ,p_severance_pay in out nocopy ghr_api.severance_pay_type
85 ,p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan
86 ,p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type
87 --Bug # 13571004
88 ,p_tsp_roth in out nocopy ghr_api.tsp_roth_type
89 );
90
91 Procedure get_wgi_dates
92 (p_pa_request_rec in ghr_pa_requests%rowtype,
93 p_wgi_due_date in out nocopy date,
94 p_wgi_pay_date out nocopy date,
95 p_retained_grade_rec out nocopy ghr_pay_calc.retained_grade_rec_type,
96 p_dlei in date
97 );
98
99 Procedure generic_update_sit
100 (p_pa_request_rec in ghr_pa_requests%rowtype,
101 p_special_information_type in fnd_id_flex_structures_tl.id_flex_structure_name%type,
102 p_segment_rec in ghr_api.special_information_type
103 );
104
105 end GHR_SF52_DO_UPDATE;