1 package body GHR_AGENCY_CHECK AS
2 /* $Header: ghragncy.pkb 120.2.12010000.2 2008/08/05 15:11:06 ubhat ship $ */
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 )
61 IS
62 l_test number;
63
64 Begin
65 Null;
66 end AGENCY_CHECK;
67
68 procedure open_events_check
69 (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
70 p_message_set in out NOCOPY boolean
71 )
72 is
73
74 Begin
75 Null;
76 End open_events_check;
77
78 function print_sf50
79 (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
80 p_pa_notification_id in ghr_pa_requests.pa_notification_id%type
81 ) return boolean
82 is
83 Begin
84 return true;
85 End print_sf50;
86
87 procedure mass_salary_lacs_remarks
88 (p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,
89 p_prd in ghr_pa_requests.pay_rate_determinant%TYPE,
90 p_eo_number in ghr_mass_salaries.executive_order_number%TYPE,
91 p_eo_date in ghr_mass_salaries.executive_order_date%TYPE,
92 p_opm_number in ghr_mass_salaries.opm_issuance_number%TYPE,
93 p_opm_date in ghr_mass_salaries.opm_issuance_date%TYPE,
94 p_retcode in out NOCOPY NUMBER,
95 p_errbuf in out NOCOPY VARCHAR2
96 ) is
97 Begin
98 NULL;
99 End;
100
101 procedure CANCEL_HIRE_CAO
102 (
103 p_pa_request_rec in ghr_pa_requests%rowtype,
104 p_asg_sf52 in ghr_api.asg_sf52_type,
105 p_asg_non_sf52 in ghr_api.asg_non_sf52_type,
106 p_asg_nte_dates in ghr_api.asg_nte_dates_type,
107 p_per_sf52 in ghr_api.per_sf52_type,
108 p_per_group1 in ghr_api.per_group1_type,
109 p_per_group2 in ghr_api.per_group2_type,
110 p_per_scd_info in ghr_api.per_scd_info_type,
111 p_per_retained_grade in ghr_api.per_retained_grade_type,
112 p_per_probations in ghr_api.per_probations_type,
113 p_per_sep_retire in ghr_api.per_sep_retire_type,
114 p_per_security in ghr_api.per_security_type,
115 p_per_conversions in ghr_api.per_conversions_type,
116 p_per_uniformed_services in ghr_api.per_uniformed_services_type,
117 p_pos_oblig in ghr_api.pos_oblig_type,
118 p_pos_grp2 in ghr_api.pos_grp2_type,
119 p_pos_grp1 in ghr_api.pos_grp1_type,
120 p_pos_valid_grade in ghr_api.pos_valid_grade_type,
121 p_pos_car_prog in ghr_api.pos_car_prog_type,
122 p_loc_info in ghr_api.loc_info_type,
123 p_wgi in ghr_api.within_grade_increase_type ,
124 p_recruitment_bonus in ghr_api.recruitment_bonus_type ,
125 p_relocation_bonus in ghr_api.relocation_bonus_type,
126 p_sf52_from_data in ghr_api.prior_sf52_data_type,
127 p_personal_info in ghr_api.personal_info_type,
128 p_gov_awards_type in ghr_api.government_awards_type,
129 p_perf_appraisal_type in ghr_api.performance_appraisal_type,
130 p_payroll_type in ghr_api.government_payroll_type,
131 p_conduct_perf_type in ghr_api.conduct_performance_type,
132 p_agency_sf52 in ghr_api.agency_sf52_type,
133 p_agency_code in varchar2,
134 p_health_plan in varchar2,
135 p_entitlement in ghr_api.entitlement_type,
136 p_foreign_lang_prof_pay in ghr_api.foreign_lang_prof_pay_type,
137 p_edp_pay in ghr_api.edp_pay_type,
138 p_hazard_pay in ghr_api.hazard_pay_type,
139 p_health_benefits in ghr_api.health_benefits_type,
140 p_danger_pay in ghr_api.danger_pay_type,
141 p_imminent_danger_pay in ghr_api.imminent_danger_pay_type,
142 p_living_quarters_allow in ghr_api.living_quarters_allow_type,
143 p_post_diff_amt in ghr_api.post_diff_amt_type,
144 p_post_diff_percent in ghr_api.post_diff_percent_type,
145 p_sep_maintenance_allow in ghr_api.sep_maintenance_allow_type,
146 p_supplemental_post_allow in ghr_api.supplemental_post_allow_type,
147 p_temp_lodge_allow in ghr_api.temp_lodge_allow_type,
148 p_premium_pay in ghr_api.premium_pay_type,
149 p_retirement_annuity in ghr_api.retirement_annuity_type,
150 p_severance_pay in ghr_api.severance_pay_type,
151 p_thrift_saving_plan in ghr_api.thrift_saving_plan,
152 p_retention_allow_review in ghr_api.retention_allow_review_type,
153 p_health_ben_pre_tax in ghr_api.health_ben_pre_tax_type,
154 p_cao_effective_date out NOCOPY date
155 )
156 IS
157
158 Begin
159 NULL;
160 End CANCEL_HIRE_CAO;
161
162
163 end GHR_AGENCY_CHECK;