[Home] [Help]
PACKAGE: APPS.GHR_CPDF_CHECK6
Source
1 package GHR_CPDF_CHECK6 as
2 /* $Header: ghcpdf06.pkh 120.2.12010000.1 2008/07/28 10:25:59 appldev 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 );
72
73
74 --
75 -- <Precedure Info>
76 -- Name:
77 -- Staffing Differential
78 -- Sections in CPDF:
79 -- C89
80 -- Note:
81 --
82
83 procedure chk_staffing_differential
84 (p_staffing_differential in varchar2
85 ,p_first_noac_lookup_code in varchar2
86 ,p_first_action_noa_la_code1 in varchar2
87 ,p_first_action_noa_la_code2 in varchar2
88 );
89
90
91 --
92 -- <Precedure Info>
93 -- Name:
94 -- Supervisor Differential
95 -- Sections in CPDF:
96 -- C89
97 -- Note:
98 --
99 procedure chk_supervisory_differential
100 (p_supervisory_differential in varchar2 --non SF52
101 ,p_first_noac_lookup_code in varchar2
102 ,p_first_action_noa_la_code1 in varchar2
103 ,p_first_action_noa_la_code2 in varchar2
104 ,p_effective_date in date
105 );
106
107
108 --
109 -- <Precedure Info>
110 -- Name:
111 -- Service Computation Date
112 -- Sections in CPDF:
113 -- C90
114 -- Note:
115 --
116
117 procedure chk_service_comp_date
118 (p_service_computation_date in date
119 ,p_effective_date in date
120 ,p_employee_date_of_birth in date
121 ,p_duty_station_lookup_code in varchar2
122 ,p_first_noac_lookup_code in varchar2
123 ,p_credit_mil_svc in varchar2 --non SF52
124 ,p_submission_date in date --non SF52
125 );
126
127
128
129 --
130 --
131 -- <Precedure Info>
132 -- Name:
133 -- Social Security
134 -- Sections in CPDF:
135 -- Note
136 -- Note:
137 --
138
139
140 procedure chk_Social_Security
141 ( p_agency_sub in varchar2 --non SF52
142 ,p_employee_National_ID in varchar2
143 ,p_personnel_officer_ID in varchar2 --non SF52
144 ,p_effective_date in date --Bug 5487271
145 );
146
147 --
148 -- <Precedure Info>
149 -- Name:
150 -- Step or Rate
151 -- Sections in CPDF:
152 -- C91 - C94
153 -- Note:
154 --
155 procedure chk_step_or_rate
156 (p_step_or_rate in varchar2
157 ,p_pay_rate_determinant in varchar2
158 ,p_to_pay_plan in varchar2
159 ,p_to_grade_or_level in varchar2
160 ,p_first_action_noa_la_code1 in varchar2
161 ,p_first_action_noa_la_code2 in varchar2
162 ,p_Cur_Appt_Auth_1 in varchar2 --non SF52 item
163 ,p_Cur_Appt_Auth_2 in varchar2 --non SF52 item
164 ,p_effective_date in date
165 ,p_rpa_step_or_rate in varchar2
166 );
167
168 --
169 -- <Precedure Info>
170 -- Name:
171 -- Supervisory Status
172 -- Sections in CPDF:
173 -- C95
174 -- Note:
175 --
176 procedure chk_supervisory_status
177 (p_supervisory_status_code in varchar2
178 ,p_to_pay_plan in varchar2
179 ,p_effective_date in date
180 );
181
182
183 --
184 -- <Precedure Info>
185 -- Name:
186 -- Tenure
187 -- Sections in CPDF:
188 -- C96 - C98
189 -- Note:
190 --
191
192 procedure chk_tenure
193 (p_tenure_group_code in varchar2
194 ,p_to_pay_plan in varchar2
195 ,p_first_action_noa_la_code1 in varchar2
196 ,p_first_action_noa_la_code2 in varchar2
197 ,p_first_noac_lookup_code in varchar2
198 ,p_Cur_Appt_Auth_1 in varchar2 --non SF52 item
199 ,p_Cur_Appt_Auth_2 in varchar2 --non SF52 item
200 ,p_effective_date in date
201 );
202
203 --
204 --
205 -- <Precedure Info>
206 -- Name:
207 -- Veterans Preference
208 -- Sections in CPDF:
209 -- C99
210 -- Note:
211 --
212 procedure chk_veterans_pref
213 (p_veterans_preference_code in varchar2
214 ,p_first_action_noa_la_code1 in varchar2
215 ,p_first_action_noa_la_code2 in varchar2
216 );
217
218
219 --
220 -- <Precedure Info>
221 -- Name:
222 -- Veterans Status
223 -- Sections in CPDF:
224 -- C99
225 -- Note:
226 --
227 procedure chk_veterans_status
228 (p_veterans_status_code in varchar2
229 ,p_veterans_preference_code in varchar2
230 ,p_first_noac_lookup_code in varchar2
231 ,p_agency_sub in varchar2 --non SF52
232 ,p_first_action_noa_la_code1 in varchar2
233
234 );
235
236
237 --
238 -- <Precedure Info>
239 -- Name:
240 -- Work Schedule
241 -- Sections in CPDF:
242 -- C99
243 -- Note:
244 --
245 procedure chk_work_schedule
246 (p_work_schedule_code in varchar2
247 ,p_first_noac_lookup_code in varchar2
248 );
249
250 procedure chk_degree_attained
251 ( p_effective_date in date
252 ,p_year_degree_attained in varchar2
253 ,p_as_of_date in date
254 );
255
256 End GHR_CPDF_CHECK6;