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