1 package body GHR_AGENCY_CHECK AS
2 /* $Header: ghragncy.pkb 120.4 2011/01/27 08:45:25 utokachi noship $ */
3
4
5 procedure AGENCY_CHECK
6 (
7 p_pa_request_rec in ghr_pa_requests%rowtype,
8 p_asg_sf52 in ghr_api.asg_sf52_type,
9 p_asg_non_sf52 in ghr_api.asg_non_sf52_type,
10 p_asg_nte_dates in ghr_api.asg_nte_dates_type,
11 p_per_sf52 in ghr_api.per_sf52_type,
12 p_per_group1 in ghr_api.per_group1_type,
13 p_per_group2 in ghr_api.per_group2_type,
14 p_per_scd_info in ghr_api.per_scd_info_type,
15 p_per_retained_grade in ghr_api.per_retained_grade_type,
16 p_per_probations in ghr_api.per_probations_type,
17 p_per_sep_retire in ghr_api.per_sep_retire_type,
18 p_per_security in ghr_api.per_security_type,
19 p_per_conversions in ghr_api.per_conversions_type,
20 p_per_uniformed_services in ghr_api.per_uniformed_services_type,
21 p_pos_oblig in ghr_api.pos_oblig_type,
22 p_pos_grp2 in ghr_api.pos_grp2_type,
23 p_pos_grp1 in ghr_api.pos_grp1_type,
24 p_pos_valid_grade in ghr_api.pos_valid_grade_type,
25 p_pos_car_prog in ghr_api.pos_car_prog_type,
26 p_loc_info in ghr_api.loc_info_type,
27 p_wgi in ghr_api.within_grade_increase_type ,
28 p_recruitment_bonus in ghr_api.recruitment_bonus_type ,
29 p_relocation_bonus in ghr_api.relocation_bonus_type,
30 p_sf52_from_data in ghr_api.prior_sf52_data_type,
31 p_personal_info in ghr_api.personal_info_type,
32 p_gov_awards_type in ghr_api.government_awards_type,
33 p_perf_appraisal_type in ghr_api.performance_appraisal_type,
34 p_payroll_type in ghr_api.government_payroll_type,
35 p_conduct_perf_type in ghr_api.conduct_performance_type,
36 p_agency_sf52 in ghr_api.agency_sf52_type,
37 p_agency_code in varchar2,
38 p_health_plan in varchar2,
39 p_entitlement in ghr_api.entitlement_type,
40 p_foreign_lang_prof_pay in ghr_api.foreign_lang_prof_pay_type,
41 p_edp_pay in ghr_api.edp_pay_type,
42 p_hazard_pay in ghr_api.hazard_pay_type,
43 p_health_benefits in ghr_api.health_benefits_type,
44 p_danger_pay in ghr_api.danger_pay_type,
45 p_imminent_danger_pay in ghr_api.imminent_danger_pay_type,
46 p_living_quarters_allow in ghr_api.living_quarters_allow_type,
47 p_post_diff_amt in ghr_api.post_diff_amt_type,
48 p_post_diff_percent in ghr_api.post_diff_percent_type,
49 p_sep_maintenance_allow in ghr_api.sep_maintenance_allow_type,
50 p_supplemental_post_allow in ghr_api.supplemental_post_allow_type,
51 p_temp_lodge_allow in ghr_api.temp_lodge_allow_type,
52 p_premium_pay in ghr_api.premium_pay_type,
53 p_retirement_annuity in ghr_api.retirement_annuity_type,
54 p_severance_pay in ghr_api.severance_pay_type,
55 p_thrift_saving_plan in ghr_api.thrift_saving_plan,
56 p_retention_allow_review in ghr_api.retention_allow_review_type,
57 p_health_ben_pre_tax in ghr_api.health_ben_pre_tax_type,
58 p_per_benefit_info in ghr_api.per_benefit_info_type, -- TAR 4646592.993
59 p_imm_retirement_info in ghr_api.per_retirement_info_type, --Bug# 7131104
60 --Begin Bug# 10181661
61 p_asg_detail_info in ghr_api.asg_detail_info_type,
62 p_ipa_detail_ben_cont_info in ghr_api.per_ipa_ben_cont_info_type
63 --End Bug# 10181661
64 )
65 IS
66 l_test number;
67
68 Begin
69 Null;
70 end AGENCY_CHECK;
71
72 procedure open_events_check
73 (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
74 p_message_set in out NOCOPY boolean
75 )
76 is
77
78 Begin
79 Null;
80 End open_events_check;
81
82 function print_sf50
83 (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
84 p_pa_notification_id in ghr_pa_requests.pa_notification_id%type
85 ) return boolean
86 is
87 Begin
88 return true;
89 End print_sf50;
90
91 procedure mass_salary_lacs_remarks
92 (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,
93 p_prd in ghr_pa_requests.pay_rate_determinant%TYPE,
94 p_eo_number in ghr_mass_salaries.executive_order_number%TYPE,
95 p_eo_date in ghr_mass_salaries.executive_order_date%TYPE,
96 p_opm_number in ghr_mass_salaries.opm_issuance_number%TYPE,
97 p_opm_date in ghr_mass_salaries.opm_issuance_date%TYPE,
98 p_retcode in out NOCOPY NUMBER,
99 p_errbuf in out NOCOPY VARCHAR2
100 ) is
101 Begin
102 NULL;
103 End;
104
105 procedure CANCEL_HIRE_CAO
106 (
107 p_pa_request_rec in ghr_pa_requests%rowtype,
108 p_asg_sf52 in ghr_api.asg_sf52_type,
109 p_asg_non_sf52 in ghr_api.asg_non_sf52_type,
110 p_asg_nte_dates in ghr_api.asg_nte_dates_type,
111 p_per_sf52 in ghr_api.per_sf52_type,
112 p_per_group1 in ghr_api.per_group1_type,
113 p_per_group2 in ghr_api.per_group2_type,
114 p_per_scd_info in ghr_api.per_scd_info_type,
115 p_per_retained_grade in ghr_api.per_retained_grade_type,
116 p_per_probations in ghr_api.per_probations_type,
117 p_per_sep_retire in ghr_api.per_sep_retire_type,
118 p_per_security in ghr_api.per_security_type,
119 p_per_conversions in ghr_api.per_conversions_type,
123 p_pos_grp1 in ghr_api.pos_grp1_type,
120 p_per_uniformed_services in ghr_api.per_uniformed_services_type,
121 p_pos_oblig in ghr_api.pos_oblig_type,
122 p_pos_grp2 in ghr_api.pos_grp2_type,
124 p_pos_valid_grade in ghr_api.pos_valid_grade_type,
125 p_pos_car_prog in ghr_api.pos_car_prog_type,
126 p_loc_info in ghr_api.loc_info_type,
127 p_wgi in ghr_api.within_grade_increase_type ,
128 p_recruitment_bonus in ghr_api.recruitment_bonus_type ,
129 p_relocation_bonus in ghr_api.relocation_bonus_type,
130 p_sf52_from_data in ghr_api.prior_sf52_data_type,
131 p_personal_info in ghr_api.personal_info_type,
132 p_gov_awards_type in ghr_api.government_awards_type,
133 p_perf_appraisal_type in ghr_api.performance_appraisal_type,
134 p_payroll_type in ghr_api.government_payroll_type,
135 p_conduct_perf_type in ghr_api.conduct_performance_type,
136 p_agency_sf52 in ghr_api.agency_sf52_type,
137 p_agency_code in varchar2,
138 p_health_plan in varchar2,
139 p_entitlement in ghr_api.entitlement_type,
140 p_foreign_lang_prof_pay in ghr_api.foreign_lang_prof_pay_type,
141 p_edp_pay in ghr_api.edp_pay_type,
142 p_hazard_pay in ghr_api.hazard_pay_type,
143 p_health_benefits in ghr_api.health_benefits_type,
144 p_danger_pay in ghr_api.danger_pay_type,
145 p_imminent_danger_pay in ghr_api.imminent_danger_pay_type,
146 p_living_quarters_allow in ghr_api.living_quarters_allow_type,
147 p_post_diff_amt in ghr_api.post_diff_amt_type,
148 p_post_diff_percent in ghr_api.post_diff_percent_type,
149 p_sep_maintenance_allow in ghr_api.sep_maintenance_allow_type,
150 p_supplemental_post_allow in ghr_api.supplemental_post_allow_type,
151 p_temp_lodge_allow in ghr_api.temp_lodge_allow_type,
152 p_premium_pay in ghr_api.premium_pay_type,
153 p_retirement_annuity in ghr_api.retirement_annuity_type,
154 p_severance_pay in ghr_api.severance_pay_type,
155 p_thrift_saving_plan in ghr_api.thrift_saving_plan,
156 p_retention_allow_review in ghr_api.retention_allow_review_type,
157 p_health_ben_pre_tax in ghr_api.health_ben_pre_tax_type,
158 p_cao_effective_date out NOCOPY date
159 )
160 IS
161
162 Begin
163 NULL;
164 End CANCEL_HIRE_CAO;
165
166
167 end GHR_AGENCY_CHECK;