[Home] [Help]
PACKAGE: APPS.GHR_CPDF_CHECK6
Source
1 package GHR_CPDF_CHECK6 AUTHID CURRENT_USER as
2 /* $Header: ghcpdf06.pkh 120.4 2011/02/14 10:39:03 utokachi ship $ */
3
4
5 --
6 -- <Precedure Info>
7 -- Name:
8 -- Prior Work Schedule
9 -- Sections in CPDF:
10 -- C74 - C75
11 -- Note:
12 --
13
14 procedure chk_prior_work_schedule
15 (p_prior_work_schedule in varchar2 --non SF52
16 ,p_work_schedule_code in varchar2
17 ,p_first_noac_lookup_code in varchar2
18 );
19
20
21 -- Race or National Origin
22 -- <Precedure Info>
23 -- Name:
24 -- Race or National Origin
25 -- Sections in CPDF:
26 -- C75 - C76
27 -- Note:
28 --
29
30 procedure chk_race_or_natnl_origin
31 (p_race_or_natnl_origin in varchar2 --non SF52
32 ,p_duty_station_lookup_code in varchar2
33 ,p_ethnic_race_info in varchar2
34 ,p_first_action_noa_la_code1 in varchar2
35 ,p_first_action_noa_la_code2 in varchar2
36 ,p_effective_date in date
37 );
38
39
40
41 -- <Precedure Info>
42 -- Name:
43 -- Prior Duty Station
44 -- Sections in CPDF:
45 -- C87
46 -- Note:
47 --
48
49 procedure chk_prior_duty_station
50 (p_prior_duty_station in varchar2
51 ,p_agency_subelement in varchar2
52 );
53
54
55 --
56 -- <Precedure Info>
57 -- Name:
58 -- Retention Allowance
59 -- Sections in CPDF:
60 -- C88
61 -- Note:
62 --
63
64 procedure chk_retention_allowance
65 (p_retention_allowance in varchar2 --non SF52
66 ,p_to_pay_plan in varchar2
67 ,p_to_basic_pay in varchar2
68 ,p_first_noac_lookup_code in varchar2
69 ,p_first_action_noa_la_code1 in varchar2
70 ,p_first_action_noa_la_code2 in varchar2
71 ,p_effective_date in date --Bug# 8309414
72 );
73
74
75 --
76 -- <Precedure Info>
77 -- Name:
78 -- Staffing Differential
79 -- Sections in CPDF:
80 -- C89
81 -- Note:
82 --
83
84 procedure chk_staffing_differential
85 (p_staffing_differential in varchar2
86 ,p_first_noac_lookup_code in varchar2
87 ,p_first_action_noa_la_code1 in varchar2
88 ,p_first_action_noa_la_code2 in varchar2
89 );
90
91
92 --
93 -- <Precedure Info>
94 -- Name:
95 -- Supervisor Differential
96 -- Sections in CPDF:
97 -- C89
98 -- Note:
99 --
100 procedure chk_supervisory_differential
101 (p_supervisory_differential in varchar2 --non SF52
102 ,p_first_noac_lookup_code in varchar2
103 ,p_first_action_noa_la_code1 in varchar2
104 ,p_first_action_noa_la_code2 in varchar2
105 ,p_effective_date in date
106 );
107
108
109 --
110 -- <Precedure Info>
111 -- Name:
112 -- Service Computation Date
113 -- Sections in CPDF:
114 -- C90
115 -- Note:
116 --
117
118 procedure chk_service_comp_date
119 (p_service_computation_date in date
120 ,p_effective_date in date
121 ,p_employee_date_of_birth in date
122 ,p_duty_station_lookup_code in varchar2
123 ,p_first_noac_lookup_code in varchar2
124 ,p_credit_mil_svc in varchar2 --non SF52
125 ,p_submission_date in date --non SF52
126 );
127
128 --Begin Bug# 11726461
129 procedure chk_scd_info
130 (p_scd_leave in date
131 ,p_scd_retirement in date
132 ,p_effective_date in date
133 ,p_employee_date_of_birth in date
134 );
135 --End Bug# 11726461
136
137 --
138 --
139 -- <Precedure Info>
140 -- Name:
141 -- Social Security
142 -- Sections in CPDF:
143 -- Note
144 -- Note:
145 --
146
147
148 procedure chk_Social_Security
149 ( p_agency_sub in varchar2 --non SF52
150 ,p_employee_National_ID in varchar2
151 ,p_personnel_officer_ID in varchar2 --non SF52
152 ,p_effective_date in date --Bug 5487271
153 );
154
155 --
156 -- <Precedure Info>
157 -- Name:
158 -- Step or Rate
159 -- Sections in CPDF:
160 -- C91 - C94
161 -- Note:
162 --
163 procedure chk_step_or_rate
164 (p_step_or_rate in varchar2
165 ,p_pay_rate_determinant in varchar2
166 ,p_to_pay_plan in varchar2
167 ,p_to_grade_or_level in varchar2
168 ,p_first_action_noa_la_code1 in varchar2
169 ,p_first_action_noa_la_code2 in varchar2
170 ,p_Cur_Appt_Auth_1 in varchar2 --non SF52 item
171 ,p_Cur_Appt_Auth_2 in varchar2 --non SF52 item
172 ,p_effective_date in date
173 ,p_rpa_step_or_rate in varchar2
174 );
175
176 --
177 -- <Precedure Info>
178 -- Name:
179 -- Supervisory Status
180 -- Sections in CPDF:
181 -- C95
182 -- Note:
183 --
184 procedure chk_supervisory_status
185 (p_supervisory_status_code in varchar2
186 ,p_to_pay_plan in varchar2
187 ,p_effective_date in date
188 );
189
190
191 --
192 -- <Precedure Info>
193 -- Name:
194 -- Tenure
195 -- Sections in CPDF:
196 -- C96 - C98
197 -- Note:
198 --
199
200 procedure chk_tenure
201 (p_tenure_group_code in varchar2
202 ,p_to_pay_plan in varchar2
203 ,p_first_action_noa_la_code1 in varchar2
204 ,p_first_action_noa_la_code2 in varchar2
205 ,p_first_noac_lookup_code in varchar2
206 ,p_Cur_Appt_Auth_1 in varchar2 --non SF52 item
207 ,p_Cur_Appt_Auth_2 in varchar2 --non SF52 item
208 ,p_effective_date in date
209 );
210
211 --
212 --
213 -- <Precedure Info>
214 -- Name:
215 -- Veterans Preference
216 -- Sections in CPDF:
217 -- C99
218 -- Note:
219 --
220 procedure chk_veterans_pref
221 (p_veterans_preference_code in varchar2
222 ,p_first_action_noa_la_code1 in varchar2
223 ,p_first_action_noa_la_code2 in varchar2
224 );
225
226
227 --
228 -- <Precedure Info>
229 -- Name:
230 -- Veterans Status
231 -- Sections in CPDF:
232 -- C99
233 -- Note:
234 --
235 procedure chk_veterans_status
236 (p_veterans_status_code in varchar2
237 ,p_veterans_preference_code in varchar2
238 ,p_first_noac_lookup_code in varchar2
239 ,p_agency_sub in varchar2 --non SF52
240 ,p_first_action_noa_la_code1 in varchar2
241
242 );
243
244
245 --
246 -- <Precedure Info>
247 -- Name:
248 -- Work Schedule
249 -- Sections in CPDF:
250 -- C99
251 -- Note:
252 --
253 procedure chk_work_schedule
254 (p_work_schedule_code in varchar2
255 ,p_first_noac_lookup_code in varchar2
256 );
257
258 procedure chk_degree_attained
259 ( p_effective_date in date
260 ,p_year_degree_attained in varchar2
261 ,p_as_of_date in date
262 );
263
264 End GHR_CPDF_CHECK6;