1 PACKAGE pay_county_tax_rule_api AS
2 /* $Header: pycntapi.pkh 120.2 2007/05/01 22:37:03 ahanda noship $ */
3 /*#
4 * This package contains county tax rules APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname County Tax Rule
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< create_county_tax_rule >----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a county tax rule record and the county tax percentage
17 * element entry for an employee assignment.
18 *
19 * This API is licensed for use with Human Resources.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 * A federal tax rule must exist for the assignment.
26 *
27 * <p><b>Post Success</b><br>
28 * The county tax rule and percentage records will be successfully inserted
29 * into the database.
30 *
31 * <p><b>Post Failure</b><br>
32 * The county tax rule will not be created and an error will be raised.
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_emp_county_tax_rule_id System generated primary key column.
37 * @param p_effective_start_date If P_VALIDATE is false, then set to the
38 * earliest effective start date for the created county tax rule. If p_validate
39 * is true, then set to null.
40 * @param p_effective_end_date If P_VALIDATE is false, then set to the
41 * effective end date for the created county tax rule. If p_validate is true,
42 * then set to null.
43 * @param p_assignment_id Identifies the assignment for which the county tax
44 * rule record is created.
45 * @param p_state_code Two digit state code.
46 * @param p_county_code Three digit county code.
47 * @param p_additional_wa_rate Additional W4 withholding allowance percentage
48 * rate.
49 * @param p_filing_status_code Filing status code. Valid values are identified
50 * by 'US_FS_nn' where nn is the state code.
51 * @param p_lit_additional_tax {@rep:casecolumn
52 * PAY_US_EMP_COUNTY_TAX_RULES_F.LIT_ADDITIONAL_TAX}
53 * @param p_lit_override_amount {@rep:casecolumn
54 * PAY_US_EMP_COUNTY_TAX_RULES_F.LIT_OVERRIDE_AMOUNT}
55 * @param p_lit_override_rate {@rep:casecolumn
56 * PAY_US_EMP_COUNTY_TAX_RULES_F.LIT_OVERRIDE_RATE}
57 * @param p_withholding_allowances {@rep:casecolumn
58 * PAY_US_EMP_COUNTY_TAX_RULES_F.WITHHOLDING_ALLOWANCES}
59 * @param p_lit_exempt Local income tax exempt flag - Y if exempt, N if not.
60 * @param p_sd_exempt {@rep:casecolumn PAY_US_EMP_COUNTY_TAX_RULES_F.SD_EXEMPT}
61 * @param p_ht_exempt {@rep:casecolumn PAY_US_EMP_COUNTY_TAX_RULES_F.HT_EXEMPT}
62 * @param p_wage_exempt {@rep:casecolumn PAY_US_EMP_COUNTY_TAX_RULES_F.WAGE_EXEMPT}
63 * @param p_school_district_code School District code. It must be NULL if a
64 * school district code already exists for the specified assignment.
65 * @param p_object_version_number If O_VALIDATE is false, then set to the
66 * version number of the created county tax rule. If p_validate is true, then
67 * the value will be null.
68 * @param p_effective_date Determines when the DateTrack operation comes into
69 * force.
70 * @param p_attribute_category This context value determines which flexfield
71 * structure to use with the descriptive flexfield segments.
72 * @param p_attribute1 Descriptive flexfield segment.
73 * @param p_attribute2 Descriptive flexfield segment.
74 * @param p_attribute3 Descriptive flexfield segment.
75 * @param p_attribute4 Descriptive flexfield segment.
76 * @param p_attribute5 Descriptive flexfield segment.
77 * @param p_attribute6 Descriptive flexfield segment.
78 * @param p_attribute7 Descriptive flexfield segment.
79 * @param p_attribute8 Descriptive flexfield segment.
80 * @param p_attribute9 Descriptive flexfield segment.
81 * @param p_attribute10 Descriptive flexfield segment.
82 * @param p_attribute11 Descriptive flexfield segment.
83 * @param p_attribute12 Descriptive flexfield segment.
84 * @param p_attribute13 Descriptive flexfield segment.
85 * @param p_attribute14 Descriptive flexfield segment.
86 * @param p_attribute15 Descriptive flexfield segment.
87 * @param p_attribute16 Descriptive flexfield segment.
88 * @param p_attribute17 Descriptive flexfield segment.
89 * @param p_attribute18 Descriptive flexfield segment.
90 * @param p_attribute19 Descriptive flexfield segment.
91 * @param p_attribute20 Descriptive flexfield segment.
92 * @param p_attribute21 Descriptive flexfield segment.
93 * @param p_attribute22 Descriptive flexfield segment.
94 * @param p_attribute23 Descriptive flexfield segment.
95 * @param p_attribute24 Descriptive flexfield segment.
96 * @param p_attribute25 Descriptive flexfield segment.
97 * @param p_attribute26 Descriptive flexfield segment.
98 * @param p_attribute27 Descriptive flexfield segment.
99 * @param p_attribute28 Descriptive flexfield segment.
100 * @param p_attribute29 Descriptive flexfield segment.
101 * @param p_attribute30 Descriptive flexfield segment.
102 * @param p_cnt_information_category {@rep:casecolumn
103 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION_CATEGORY}
104 * @param p_cnt_information1 {@rep:casecolumn
105 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION1}
106 * @param p_cnt_information2 {@rep:casecolumn
107 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION2}
108 * @param p_cnt_information3 {@rep:casecolumn
109 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION3}
110 * @param p_cnt_information4 {@rep:casecolumn
111 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION4}
112 * @param p_cnt_information5 {@rep:casecolumn
113 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION5}
114 * @param p_cnt_information6 {@rep:casecolumn
115 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION6}
116 * @param p_cnt_information7 {@rep:casecolumn
117 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION7}
118 * @param p_cnt_information8 {@rep:casecolumn
119 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION8}
120 * @param p_cnt_information9 {@rep:casecolumn
121 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION9}
122 * @param p_cnt_information10 {@rep:casecolumn
123 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION10}
124 * @param p_cnt_information11 {@rep:casecolumn
125 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION11}
126 * @param p_cnt_information12 {@rep:casecolumn
127 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION12}
128 * @param p_cnt_information13 {@rep:casecolumn
129 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION13}
130 * @param p_cnt_information14 {@rep:casecolumn
131 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION14}
132 * @param p_cnt_information15 {@rep:casecolumn
133 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION15}
134 * @param p_cnt_information16 {@rep:casecolumn
135 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION16}
136 * @param p_cnt_information17 {@rep:casecolumn
137 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION17}
138 * @param p_cnt_information18 {@rep:casecolumn
139 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION18}
140 * @param p_cnt_information19 {@rep:casecolumn
141 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION19}
142 * @param p_cnt_information20 {@rep:casecolumn
143 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION20}
144 * @param p_cnt_information21 {@rep:casecolumn
145 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION21}
146 * @param p_cnt_information22 {@rep:casecolumn
147 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION22}
148 * @param p_cnt_information23 {@rep:casecolumn
149 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION23}
150 * @param p_cnt_information24 {@rep:casecolumn
151 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION24}
152 * @param p_cnt_information25 {@rep:casecolumn
153 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION25}
154 * @param p_cnt_information26 {@rep:casecolumn
155 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION26}
156 * @param p_cnt_information27 {@rep:casecolumn
157 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION27}
158 * @param p_cnt_information28 {@rep:casecolumn
159 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION28}
160 * @param p_cnt_information29 {@rep:casecolumn
161 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION29}
162 * @param p_cnt_information30 {@rep:casecolumn
163 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION30}
164 * @rep:displayname Create County Tax Rule
165 * @rep:category BUSINESS_ENTITY PAY_EMP_TAX_INFO
166 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
167 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
168 * @rep:scope public
169 * @rep:lifecycle active
170 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
171 */
172 --
173 -- {End Of Comments}
174 --
175 procedure create_county_tax_rule
176 (
177 p_validate in boolean default false
178 ,p_emp_county_tax_rule_id out nocopy number
179 ,p_effective_start_date out nocopy date
180 ,p_effective_end_date out nocopy date
181 ,p_assignment_id in number
182 ,p_state_code in varchar2
183 ,p_county_code in varchar2
184 ,p_additional_wa_rate in number
185 ,p_filing_status_code in varchar2
186 ,p_lit_additional_tax in number
187 ,p_lit_override_amount in number
188 ,p_lit_override_rate in number
189 ,p_withholding_allowances in number
190 ,p_lit_exempt in varchar2 default null
191 ,p_sd_exempt in varchar2 default null
192 ,p_ht_exempt in varchar2 default null
193 ,p_wage_exempt in varchar2 default null
194 ,p_school_district_code in varchar2 default null
195 ,p_object_version_number out nocopy number
196 ,p_effective_date in date
197 ,p_attribute_category in varchar2 default null
198 ,p_attribute1 in varchar2 default null
199 ,p_attribute2 in varchar2 default null
200 ,p_attribute3 in varchar2 default null
201 ,p_attribute4 in varchar2 default null
202 ,p_attribute5 in varchar2 default null
203 ,p_attribute6 in varchar2 default null
204 ,p_attribute7 in varchar2 default null
205 ,p_attribute8 in varchar2 default null
206 ,p_attribute9 in varchar2 default null
207 ,p_attribute10 in varchar2 default null
208 ,p_attribute11 in varchar2 default null
209 ,p_attribute12 in varchar2 default null
210 ,p_attribute13 in varchar2 default null
211 ,p_attribute14 in varchar2 default null
212 ,p_attribute15 in varchar2 default null
213 ,p_attribute16 in varchar2 default null
214 ,p_attribute17 in varchar2 default null
215 ,p_attribute18 in varchar2 default null
216 ,p_attribute19 in varchar2 default null
217 ,p_attribute20 in varchar2 default null
218 ,p_attribute21 in varchar2 default null
219 ,p_attribute22 in varchar2 default null
220 ,p_attribute23 in varchar2 default null
221 ,p_attribute24 in varchar2 default null
222 ,p_attribute25 in varchar2 default null
223 ,p_attribute26 in varchar2 default null
224 ,p_attribute27 in varchar2 default null
225 ,p_attribute28 in varchar2 default null
226 ,p_attribute29 in varchar2 default null
227 ,p_attribute30 in varchar2 default null
228 ,p_cnt_information_category in varchar2 default null
229 ,p_cnt_information1 in varchar2 default null
230 ,p_cnt_information2 in varchar2 default null
231 ,p_cnt_information3 in varchar2 default null
232 ,p_cnt_information4 in varchar2 default null
233 ,p_cnt_information5 in varchar2 default null
234 ,p_cnt_information6 in varchar2 default null
235 ,p_cnt_information7 in varchar2 default null
236 ,p_cnt_information8 in varchar2 default null
237 ,p_cnt_information9 in varchar2 default null
238 ,p_cnt_information10 in varchar2 default null
239 ,p_cnt_information11 in varchar2 default null
240 ,p_cnt_information12 in varchar2 default null
241 ,p_cnt_information13 in varchar2 default null
242 ,p_cnt_information14 in varchar2 default null
243 ,p_cnt_information15 in varchar2 default null
244 ,p_cnt_information16 in varchar2 default null
245 ,p_cnt_information17 in varchar2 default null
246 ,p_cnt_information18 in varchar2 default null
247 ,p_cnt_information19 in varchar2 default null
248 ,p_cnt_information20 in varchar2 default null
249 ,p_cnt_information21 in varchar2 default null
250 ,p_cnt_information22 in varchar2 default null
251 ,p_cnt_information23 in varchar2 default null
252 ,p_cnt_information24 in varchar2 default null
253 ,p_cnt_information25 in varchar2 default null
254 ,p_cnt_information26 in varchar2 default null
255 ,p_cnt_information27 in varchar2 default null
256 ,p_cnt_information28 in varchar2 default null
257 ,p_cnt_information29 in varchar2 default null
258 ,p_cnt_information30 in varchar2 default null
259 );
260 --
261 -- ----------------------------------------------------------------------------
262 -- |--------------------------< update_county_tax_rule >----------------------|
263 -- ----------------------------------------------------------------------------
264 --
265 -- {Start Of Comments}
266 /*#
267 * This API updates a county tax rule record and the county tax percentage for
268 * an employee assignment.
269 *
270 * This API is licensed for use with Human Resources.
271 *
272 * <p><b>Licensing</b><br>
273 * This API is licensed for use with Human Resources.
274 *
275 * <p><b>Prerequisites</b><br>
276 * A valid county tax rule record must exist on the effective date.
277 *
278 * <p><b>Post Success</b><br>
279 * The county tax rule will be successfully updated.
280 *
281 * <p><b>Post Failure</b><br>
282 * The county tax rule will not be updated and an error will be raised.
283 * @param p_validate If true, then validation alone will be performed and the
284 * database will remain unchanged. If false and all validation checks pass,
285 * then the database will be modified.
286 * @param p_emp_county_tax_rule_id System generated primary key column.
287 * @param p_effective_start_date If P_VALIDATE is false, then set to the
288 * effective start date on the updated county tax rule row which now exists as
289 * of the effective date. If p_validate is true, then set to null.
290 * @param p_effective_end_date If P_VALIDATE is false, then set to the
291 * effective end date on the updated county tax rule row which now exists as of
292 * the effective date. If p_validate is true, then set to null.
293 * @param p_additional_wa_rate Additional W4 withholding allowance percentage
294 * rate.
295 * @param p_filing_status_code Filing status code. Valid values are identified
296 * by 'US_FS_nn' where nn is the state code.
297 * @param p_lit_additional_tax {@rep:casecolumn
298 * PAY_US_EMP_COUNTY_TAX_RULES_F.LIT_ADDITIONAL_TAX}
299 * @param p_lit_override_amount {@rep:casecolumn
300 * PAY_US_EMP_COUNTY_TAX_RULES_F.LIT_OVERRIDE_AMOUNT}
301 * @param p_lit_override_rate {@rep:casecolumn
302 * PAY_US_EMP_COUNTY_TAX_RULES_F.LIT_OVERRIDE_RATE}
303 * @param p_withholding_allowances {@rep:casecolumn
304 * PAY_US_EMP_COUNTY_TAX_RULES_F.WITHHOLDING_ALLOWANCES}
305 * @param p_lit_exempt Local income tax exempt flag - Y if exempt, N if not.
306 * @param p_sd_exempt {@rep:casecolumn PAY_US_EMP_COUNTY_TAX_RULES_F.SD_EXEMPT}
307 * @param p_ht_exempt {@rep:casecolumn PAY_US_EMP_COUNTY_TAX_RULES_F.HT_EXEMPT}
308 * @param p_wage_exempt {@rep:casecolumn PAY_US_EMP_COUNTY_TAX_RULES_F.WAGE_EXEMPT}
309 * @param p_school_district_code School District code. It must be NULL if a
310 * school district code already exists for the specified assignment.
311 * @param p_object_version_number Pass in the current version number of the
312 * county tax rule to be updated. When the API completes, if P_VALIDATE is
313 * false, then set to the new version number of the updated county tax rule. If
314 * P_VALIDATE is true, then set to the same value which was passed in.
315 * @param p_effective_date Determines when the DateTrack operation comes into
316 * force.
317 * @param p_datetrack_mode Indicates which DateTrack mode to use when updating
318 * the record. You must set to either UPDATE, CORRECTION, UPDATE_OVERRIDE or
319 * UPDATE_CHANGE_INSERT. Modes available for use with a particular record
320 * depend on the dates of previous record changes and the effective date of
321 * this change.
322 * @param p_attribute_category This context value determines which flexfield
323 * structure to use with the descriptive flexfield segments.
324 * @param p_attribute1 Descriptive flexfield segment.
325 * @param p_attribute2 Descriptive flexfield segment.
326 * @param p_attribute3 Descriptive flexfield segment.
327 * @param p_attribute4 Descriptive flexfield segment.
328 * @param p_attribute5 Descriptive flexfield segment.
329 * @param p_attribute6 Descriptive flexfield segment.
330 * @param p_attribute7 Descriptive flexfield segment.
331 * @param p_attribute8 Descriptive flexfield segment.
332 * @param p_attribute9 Descriptive flexfield segment.
333 * @param p_attribute10 Descriptive flexfield segment.
334 * @param p_attribute11 Descriptive flexfield segment.
335 * @param p_attribute12 Descriptive flexfield segment.
336 * @param p_attribute13 Descriptive flexfield segment.
337 * @param p_attribute14 Descriptive flexfield segment.
338 * @param p_attribute15 Descriptive flexfield segment.
339 * @param p_attribute16 Descriptive flexfield segment.
340 * @param p_attribute17 Descriptive flexfield segment.
341 * @param p_attribute18 Descriptive flexfield segment.
342 * @param p_attribute19 Descriptive flexfield segment.
343 * @param p_attribute20 Descriptive flexfield segment.
344 * @param p_attribute21 Descriptive flexfield segment.
345 * @param p_attribute22 Descriptive flexfield segment.
346 * @param p_attribute23 Descriptive flexfield segment.
347 * @param p_attribute24 Descriptive flexfield segment.
348 * @param p_attribute25 Descriptive flexfield segment.
349 * @param p_attribute26 Descriptive flexfield segment.
350 * @param p_attribute27 Descriptive flexfield segment.
351 * @param p_attribute28 Descriptive flexfield segment.
352 * @param p_attribute29 Descriptive flexfield segment.
353 * @param p_attribute30 Descriptive flexfield segment.
354 * @param p_cnt_information_category {@rep:casecolumn
355 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION_CATEGORY}
356 * @param p_cnt_information1 {@rep:casecolumn
357 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION1}
358 * @param p_cnt_information2 {@rep:casecolumn
359 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION2}
360 * @param p_cnt_information3 {@rep:casecolumn
361 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION3}
362 * @param p_cnt_information4 {@rep:casecolumn
363 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION4}
364 * @param p_cnt_information5 {@rep:casecolumn
365 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION5}
366 * @param p_cnt_information6 {@rep:casecolumn
367 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION6}
368 * @param p_cnt_information7 {@rep:casecolumn
369 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION7}
370 * @param p_cnt_information8 {@rep:casecolumn
371 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION8}
372 * @param p_cnt_information9 {@rep:casecolumn
373 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION9}
374 * @param p_cnt_information10 {@rep:casecolumn
375 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION10}
376 * @param p_cnt_information11 {@rep:casecolumn
377 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION11}
378 * @param p_cnt_information12 {@rep:casecolumn
379 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION12}
380 * @param p_cnt_information13 {@rep:casecolumn
381 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION13}
382 * @param p_cnt_information14 {@rep:casecolumn
383 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION14}
384 * @param p_cnt_information15 {@rep:casecolumn
385 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION15}
386 * @param p_cnt_information16 {@rep:casecolumn
387 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION16}
388 * @param p_cnt_information17 {@rep:casecolumn
389 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION17}
390 * @param p_cnt_information18 {@rep:casecolumn
391 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION18}
392 * @param p_cnt_information19 {@rep:casecolumn
393 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION19}
394 * @param p_cnt_information20 {@rep:casecolumn
395 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION20}
396 * @param p_cnt_information21 {@rep:casecolumn
397 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION21}
398 * @param p_cnt_information22 {@rep:casecolumn
399 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION22}
400 * @param p_cnt_information23 {@rep:casecolumn
401 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION23}
402 * @param p_cnt_information24 {@rep:casecolumn
403 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION24}
404 * @param p_cnt_information25 {@rep:casecolumn
405 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION25}
406 * @param p_cnt_information26 {@rep:casecolumn
407 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION26}
408 * @param p_cnt_information27 {@rep:casecolumn
409 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION27}
410 * @param p_cnt_information28 {@rep:casecolumn
411 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION28}
412 * @param p_cnt_information29 {@rep:casecolumn
413 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION29}
414 * @param p_cnt_information30 {@rep:casecolumn
415 * PAY_US_EMP_COUNTY_TAX_RULES_F.CNT_INFORMATION30}
416 * @rep:displayname Update County Tax Rule
417 * @rep:category BUSINESS_ENTITY PAY_EMP_TAX_INFO
418 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
419 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
420 * @rep:scope public
421 * @rep:lifecycle active
422 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
423 */
424 --
425 -- {End Of Comments}
426 --
427 procedure update_county_tax_rule
428 (
429 p_validate in boolean default false
430 ,p_emp_county_tax_rule_id in number
431 ,p_effective_start_date out nocopy date
432 ,p_effective_end_date out nocopy date
433 ,p_additional_wa_rate in number default hr_api.g_number
434 ,p_filing_status_code in varchar2 default hr_api.g_varchar2
435 ,p_lit_additional_tax in number default hr_api.g_number
436 ,p_lit_override_amount in number default hr_api.g_number
437 ,p_lit_override_rate in number default hr_api.g_number
438 ,p_withholding_allowances in number default hr_api.g_number
439 ,p_lit_exempt in varchar2 default hr_api.g_varchar2
440 ,p_sd_exempt in varchar2 default hr_api.g_varchar2
441 ,p_ht_exempt in varchar2 default hr_api.g_varchar2
442 ,p_wage_exempt in varchar2 default hr_api.g_varchar2
443 ,p_school_district_code in varchar2 default hr_api.g_varchar2
444 ,p_object_version_number in out nocopy number
445 ,p_effective_date in date
446 ,p_datetrack_mode in varchar2
447 ,p_attribute_category in varchar2 default hr_api.g_varchar2
448 ,p_attribute1 in varchar2 default hr_api.g_varchar2
449 ,p_attribute2 in varchar2 default hr_api.g_varchar2
450 ,p_attribute3 in varchar2 default hr_api.g_varchar2
451 ,p_attribute4 in varchar2 default hr_api.g_varchar2
452 ,p_attribute5 in varchar2 default hr_api.g_varchar2
453 ,p_attribute6 in varchar2 default hr_api.g_varchar2
454 ,p_attribute7 in varchar2 default hr_api.g_varchar2
455 ,p_attribute8 in varchar2 default hr_api.g_varchar2
456 ,p_attribute9 in varchar2 default hr_api.g_varchar2
457 ,p_attribute10 in varchar2 default hr_api.g_varchar2
458 ,p_attribute11 in varchar2 default hr_api.g_varchar2
459 ,p_attribute12 in varchar2 default hr_api.g_varchar2
460 ,p_attribute13 in varchar2 default hr_api.g_varchar2
461 ,p_attribute14 in varchar2 default hr_api.g_varchar2
462 ,p_attribute15 in varchar2 default hr_api.g_varchar2
463 ,p_attribute16 in varchar2 default hr_api.g_varchar2
464 ,p_attribute17 in varchar2 default hr_api.g_varchar2
465 ,p_attribute18 in varchar2 default hr_api.g_varchar2
466 ,p_attribute19 in varchar2 default hr_api.g_varchar2
467 ,p_attribute20 in varchar2 default hr_api.g_varchar2
468 ,p_attribute21 in varchar2 default hr_api.g_varchar2
472 ,p_attribute25 in varchar2 default hr_api.g_varchar2
469 ,p_attribute22 in varchar2 default hr_api.g_varchar2
470 ,p_attribute23 in varchar2 default hr_api.g_varchar2
471 ,p_attribute24 in varchar2 default hr_api.g_varchar2
473 ,p_attribute26 in varchar2 default hr_api.g_varchar2
474 ,p_attribute27 in varchar2 default hr_api.g_varchar2
475 ,p_attribute28 in varchar2 default hr_api.g_varchar2
476 ,p_attribute29 in varchar2 default hr_api.g_varchar2
477 ,p_attribute30 in varchar2 default hr_api.g_varchar2
478 ,p_cnt_information_category in varchar2 default hr_api.g_varchar2
479 ,p_cnt_information1 in varchar2 default hr_api.g_varchar2
480 ,p_cnt_information2 in varchar2 default hr_api.g_varchar2
481 ,p_cnt_information3 in varchar2 default hr_api.g_varchar2
482 ,p_cnt_information4 in varchar2 default hr_api.g_varchar2
483 ,p_cnt_information5 in varchar2 default hr_api.g_varchar2
484 ,p_cnt_information6 in varchar2 default hr_api.g_varchar2
485 ,p_cnt_information7 in varchar2 default hr_api.g_varchar2
486 ,p_cnt_information8 in varchar2 default hr_api.g_varchar2
487 ,p_cnt_information9 in varchar2 default hr_api.g_varchar2
488 ,p_cnt_information10 in varchar2 default hr_api.g_varchar2
489 ,p_cnt_information11 in varchar2 default hr_api.g_varchar2
490 ,p_cnt_information12 in varchar2 default hr_api.g_varchar2
491 ,p_cnt_information13 in varchar2 default hr_api.g_varchar2
492 ,p_cnt_information14 in varchar2 default hr_api.g_varchar2
493 ,p_cnt_information15 in varchar2 default hr_api.g_varchar2
494 ,p_cnt_information16 in varchar2 default hr_api.g_varchar2
495 ,p_cnt_information17 in varchar2 default hr_api.g_varchar2
496 ,p_cnt_information18 in varchar2 default hr_api.g_varchar2
497 ,p_cnt_information19 in varchar2 default hr_api.g_varchar2
498 ,p_cnt_information20 in varchar2 default hr_api.g_varchar2
499 ,p_cnt_information21 in varchar2 default hr_api.g_varchar2
500 ,p_cnt_information22 in varchar2 default hr_api.g_varchar2
501 ,p_cnt_information23 in varchar2 default hr_api.g_varchar2
502 ,p_cnt_information24 in varchar2 default hr_api.g_varchar2
503 ,p_cnt_information25 in varchar2 default hr_api.g_varchar2
504 ,p_cnt_information26 in varchar2 default hr_api.g_varchar2
505 ,p_cnt_information27 in varchar2 default hr_api.g_varchar2
506 ,p_cnt_information28 in varchar2 default hr_api.g_varchar2
507 ,p_cnt_information29 in varchar2 default hr_api.g_varchar2
508 ,p_cnt_information30 in varchar2 default hr_api.g_varchar2
509 );
510 --
511 -- ----------------------------------------------------------------------------
512 -- |----------------------------------< lck >---------------------------------|
513 -- ----------------------------------------------------------------------------
514 -- {Start Of Comments}
515 --
516 -- Description:
517 -- The Lck process for datetrack is complicated and comprises of the
518 -- following processing
519 -- The processing steps are as follows:
520 -- 1) The row to be updated or deleted must be locked.
521 -- By locking this row, the g_old_rec record data type is populated.
522 -- 2) The datetrack mode is then validated to ensure the operation is
523 -- valid. If the mode is valid the validation start and end dates for
524 -- the mode will be derived and returned. Any required locking is
525 -- completed when the datetrack mode is validated.
526 --
527 -- Prerequisites:
528 --
529 --
530 -- In Parameters:
531 -- Name Reqd Type Description
532 -- p_emp_county_tax_rule_id Yes number PK of record
533 -- p_object_version_number Yes number OVN of record
534 -- p_effective_date Yes date Session Date.
535 -- p_datetrack_mode Yes varchar2 Datetrack mode.
536 --
537 -- Post Success:
538 -- On successful completion of the Lck process the row to be updated or
539 -- deleted will be locked and selected into the global data structure
540 -- g_old_rec.
541 --
542 -- Name Type Description
543 -- p_validation_start_date Yes Derived Effective Start Date.
544 -- p_validation_end_date Yes Derived Effective End Date.
545 --
546 -- Post Failure:
547 -- The Lck process can fail for three reasons:
548 -- 1) When attempting to lock the row the row could already be locked by
549 -- another user. This will raise the HR_Api.Object_Locked exception.
550 -- 2) The row which is required to be locked doesn't exist in the HR Schema.
551 -- This error is trapped and reported using the message name
552 -- 'HR_7220_INVALID_PRIMARY_KEY'.
553 -- 3) The row although existing in the HR Schema has a different object
554 -- version number than the object version number specified.
555 -- This error is trapped and reported using the message name
556 -- 'HR_7155_OBJECT_INVALID'.
557 --
558 -- Access Status:
559 -- Public.
560 --
561 -- {End Of Comments}
562 --
563 procedure lck
564 (
565 p_emp_county_tax_rule_id in number
566 ,p_object_version_number in number
567 ,p_effective_date in date
568 ,p_datetrack_mode in varchar2
569 ,p_validation_start_date out nocopy date
570 ,p_validation_end_date out nocopy date
571 );
572 --
573 end pay_county_tax_rule_api;
[Home] [Help]