1 PACKAGE pay_state_tax_rule_api AS
2 /* $Header: pystaapi.pkh 120.2.12010000.1 2008/07/27 23:43:17 appldev ship $ */
3 /*#
4 * This package contains state tax rules APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname State Tax Rule
8 */
9 --
10 --
11 -- ----------------------------------------------------------------------------
12 -- |----------------------------------< lck >---------------------------------|
13 -- ----------------------------------------------------------------------------
14 -- {Start Of Comments}
15 --
16 -- Description:
17 -- The Lck process for datetrack is complicated and comprises of the
18 -- following processing
19 -- The processing steps are as follows:
20 -- 1) The row to be updated or deleted must be locked.
21 -- By locking this row, the g_old_rec record data type is populated.
22 -- 2) The datetrack mode is then validated to ensure the operation is
23 -- valid. If the mode is valid the validation start and end dates for
24 -- the mode will be derived and returned. Any required locking is
25 -- completed when the datetrack mode is validated.
26 --
27 -- Prerequisites:
28 --
29 --
30 -- In Parameters:
31 -- Name Reqd Type Description
32 -- p_emp_county_tax_rule_id Yes number PK of record
33 -- p_object_version_number Yes number OVN of record
34 -- p_effective_date Yes date Session Date.
35 -- p_datetrack_mode Yes varchar2 Datetrack mode.
36 --
37 -- Post Success:
38 -- On successful completion of the Lck process the row to be updated or
39 -- deleted will be locked and selected into the global data structure
40 -- g_old_rec.
41 --
42 -- Name Type Description
43 -- p_validation_start_date Yes Derived Effective Start Date.
44 -- p_validation_end_date Yes Derived Effective End Date.
45 --
46 -- Post Failure:
47 -- The Lck process can fail for three reasons:
48 -- 1) When attempting to lock the row the row could already be locked by
49 -- another user. This will raise the HR_Api.Object_Locked exception.
50 -- 2) The row which is required to be locked doesn't exist in the HR Schema.
51 -- This error is trapped and reported using the message name
52 -- 'HR_7220_INVALID_PRIMARY_KEY'.
53 -- 3) The row although existing in the HR Schema has a different object
54 -- version number than the object version number specified.
55 -- This error is trapped and reported using the message name
56 -- 'HR_7155_OBJECT_INVALID'.
57 --
58 -- Access Status:
59 -- Public.
60 --
61 -- {End Of Comments}
62 --
63 procedure lck
64 (
65 p_emp_state_tax_rule_id in number
66 ,p_object_version_number in number
67 ,p_effective_date in date
68 ,p_datetrack_mode in varchar2
69 ,p_validation_start_date out nocopy date
70 ,p_validation_end_date out nocopy date
71 );
72 --
73 -- ----------------------------------------------------------------------------
74 -- |--------------------------< create_state_tax_rule >-----------------------|
75 -- ----------------------------------------------------------------------------
76 --
77 -- {Start Of Comments}
78 /*#
79 * This API creates a new state tax rule for a given assignment.
80 *
81 * It also creates a new state tax percentage element entry. The API may be
82 * called by providing all of the values for the new tax rule. It can also be
83 * called with a flag that instructs the API to insert default values. This API
84 * is licensed for use with Human Resources.
85 *
86 * <p><b>Licensing</b><br>
87 * This API is licensed for use with Human Resources.
88 *
89 * <p><b>Prerequisites</b><br>
90 * A federal tax rule must exist for an assignment.
91 *
92 * <p><b>Post Success</b><br>
93 * The state tax details will be successfully inserted into the database.
94 *
95 * <p><b>Post Failure</b><br>
96 * The state tax rules will not be created and an error will be raised.
97 * @param p_validate If true, then validation alone will be performed and the
98 * database will remain unchanged. If false and all validation checks pass,
99 * then the database will be modified.
100 * @param p_effective_date Determines when the DateTrack operation comes into
101 * force.
102 * @param p_default_flag Determines whether default values are provided by the
103 * API: 'Y' Insert default values, 'N': no default values. pyacplsa.xml 1733
104 * @param p_assignment_id Identifies the assignment for which you create the
105 * state tax rule record.
106 * @param p_state_code Two digit state code.
107 * @param p_additional_wa_amount Additional W4 withholding allowance amount.
108 * @param p_filing_status_code Filing status code. Valid values are identified
109 * by 'US_FS_nn' where nn is the state code.
110 * @param p_remainder_percent {@rep:casecolumn
111 * PAY_US_EMP_STATE_TAX_RULES_F.REMAINDER_PERCENT}
112 * @param p_secondary_wa {@rep:casecolumn
113 * PAY_US_EMP_STATE_TAX_RULES_F.SECONDARY_WA}
114 * @param p_sit_additional_tax {@rep:casecolumn
115 * PAY_US_EMP_STATE_TAX_RULES_F.SIT_ADDITIONAL_TAX}
116 * @param p_sit_override_amount {@rep:casecolumn
117 * PAY_US_EMP_STATE_TAX_RULES_F.SIT_OVERRIDE_AMOUNT}
118 * @param p_sit_override_rate {@rep:casecolumn
119 * PAY_US_EMP_STATE_TAX_RULES_F.SIT_OVERRIDE_RATE}
120 * @param p_withholding_allowances {@rep:casecolumn
121 * PAY_US_EMP_STATE_TAX_RULES_F.WITHHOLDING_ALLOWANCES}
122 * @param p_excessive_wa_reject_date {@rep:casecolumn
123 * PAY_US_EMP_STATE_TAX_RULES_F.EXCESSIVE_WA_REJECT_DATE}
124 * @param p_sdi_exempt SDI exempt flag. Valid values are defined by 'YES_NO'
125 * lookup type.
126 * @param p_sit_exempt State income tax exempt flag. Valid values are defined
127 * by 'YES_NO' lookup type.
128 * @param p_sit_optional_calc_ind {@rep:casecolumn
129 * PAY_US_EMP_STATE_TAX_RULES_F.SIT_OPTIONAL_CALC_IND}
130 * @param p_state_non_resident_cert Determines whether the assignment has a
131 * state non-resident certificate. Valid values are defined by 'YES_NO' lookup
132 * type.
133 * @param p_sui_exempt SUI exempt flag. Valid values are defined by 'YES_NO'
134 * lookup type.
135 * @param p_wc_exempt Workers Compensation exemption flag .Valid values are
136 * defined by 'YES_NO' lookup type.
137 * @param p_wage_exempt Wage Reporting Exemption flag .Valid values are
138 * defined by 'YES_NO' lookup type.
139 * @param p_sui_wage_base_override_amoun {@rep:casecolumn
140 * PAY_US_EMP_STATE_TAX_RULES_F.SUI_WAGE_BASE_OVERRIDE_AMOUNT}
141 * @param p_supp_tax_override_rate {@rep:casecolumn
142 * PAY_US_EMP_STATE_TAX_RULES_F.SUPP_TAX_OVERRIDE_RATE}
143 * @param p_attribute_category This context value determines which flexfield
144 * structure to use with the descriptive flexfield segments.
145 * @param p_attribute1 Descriptive flexfield segment.
146 * @param p_attribute2 Descriptive flexfield segment.
147 * @param p_attribute3 Descriptive flexfield segment.
148 * @param p_attribute4 Descriptive flexfield segment.
149 * @param p_attribute5 Descriptive flexfield segment.
150 * @param p_attribute6 Descriptive flexfield segment.
151 * @param p_attribute7 Descriptive flexfield segment.
152 * @param p_attribute8 Descriptive flexfield segment.
153 * @param p_attribute9 Descriptive flexfield segment.
154 * @param p_attribute10 Descriptive flexfield segment.
155 * @param p_attribute11 Descriptive flexfield segment.
156 * @param p_attribute12 Descriptive flexfield segment.
157 * @param p_attribute13 Descriptive flexfield segment.
158 * @param p_attribute14 Descriptive flexfield segment.
159 * @param p_attribute15 Descriptive flexfield segment.
160 * @param p_attribute16 Descriptive flexfield segment.
161 * @param p_attribute17 Descriptive flexfield segment.
162 * @param p_attribute18 Descriptive flexfield segment.
163 * @param p_attribute19 Descriptive flexfield segment.
164 * @param p_attribute20 Descriptive flexfield segment.
165 * @param p_attribute21 Descriptive flexfield segment.
166 * @param p_attribute22 Descriptive flexfield segment.
167 * @param p_attribute23 Descriptive flexfield segment.
168 * @param p_attribute24 Descriptive flexfield segment.
169 * @param p_attribute25 Descriptive flexfield segment.
170 * @param p_attribute26 Descriptive flexfield segment.
171 * @param p_attribute27 Descriptive flexfield segment.
172 * @param p_attribute28 Descriptive flexfield segment.
173 * @param p_attribute29 Descriptive flexfield segment.
174 * @param p_attribute30 Descriptive flexfield segment.
175 * @param p_sta_information_category {@rep:casecolumn
176 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION_CATEGORY}
177 * @param p_sta_information1 {@rep:casecolumn
178 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION1}
179 * @param p_sta_information2 {@rep:casecolumn
180 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION2}
181 * @param p_sta_information3 {@rep:casecolumn
182 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION3}
183 * @param p_sta_information4 {@rep:casecolumn
184 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION4}
185 * @param p_sta_information5 {@rep:casecolumn
186 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION5}
187 * @param p_sta_information6 {@rep:casecolumn
188 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION6}
189 * @param p_sta_information7 {@rep:casecolumn
190 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION7}
191 * @param p_sta_information8 {@rep:casecolumn
192 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION8}
193 * @param p_sta_information9 {@rep:casecolumn
194 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION9}
195 * @param p_sta_information10 {@rep:casecolumn
196 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION10}
197 * @param p_sta_information11 {@rep:casecolumn
198 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION11}
199 * @param p_sta_information12 {@rep:casecolumn
200 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION12}
201 * @param p_sta_information13 {@rep:casecolumn
202 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION13}
203 * @param p_sta_information14 {@rep:casecolumn
204 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION14}
205 * @param p_sta_information15 {@rep:casecolumn
206 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION15}
207 * @param p_sta_information16 {@rep:casecolumn
208 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION16}
209 * @param p_sta_information17 {@rep:casecolumn
210 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION17}
211 * @param p_sta_information18 {@rep:casecolumn
212 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION18}
213 * @param p_sta_information19 {@rep:casecolumn
214 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION19}
215 * @param p_sta_information20 {@rep:casecolumn
216 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION20}
217 * @param p_sta_information21 {@rep:casecolumn
218 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION21}
219 * @param p_sta_information22 {@rep:casecolumn
220 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION22}
221 * @param p_sta_information23 {@rep:casecolumn
222 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION23}
223 * @param p_sta_information24 {@rep:casecolumn
224 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION24}
225 * @param p_sta_information25 {@rep:casecolumn
226 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION25}
227 * @param p_sta_information26 {@rep:casecolumn
228 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION26}
229 * @param p_sta_information27 {@rep:casecolumn
230 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION27}
231 * @param p_sta_information28 {@rep:casecolumn
232 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION28}
233 * @param p_sta_information29 {@rep:casecolumn
234 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION29}
235 * @param p_sta_information30 {@rep:casecolumn
236 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION30}
237 * @param p_emp_state_tax_rule_id {@rep:casecolumn
238 * PAY_US_EMP_STATE_TAX_RULES_F.EMP_STATE_TAX_RULE_ID}
239 * @param p_object_version_number If P_VALIDATE is false, then set to the
240 * version number of the created state tax rule. If p_validate is true, then
241 * the value will be null.
242 * @param p_effective_start_date If P_VALIDATE is false, then set to the
243 * earliest effective start date for the created state tax rule. If p_validate
244 * is true, then set to null.
245 * @param p_effective_end_date If P_VALIDATE is false, then set to the
246 * effective end date for the created state tax rule. If p_validate is true,
247 * then set to null.
248 * @rep:displayname Create State Tax Rule
249 * @rep:category BUSINESS_ENTITY PAY_EMP_TAX_INFO
250 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
251 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
252 * @rep:scope public
253 * @rep:lifecycle active
254 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
255 */
256 --
257 -- {End Of Comments}
258 --
259 procedure create_state_tax_rule
260 (
261 p_validate IN boolean default false
262 ,p_effective_date IN date
263 ,p_default_flag IN varchar2 default null
264 ,p_assignment_id IN number
265 ,p_state_code IN varchar2
266 ,p_additional_wa_amount IN number default null
267 ,p_filing_status_code IN varchar2 default null
268 ,p_remainder_percent IN number default null
269 ,p_secondary_wa IN number default null
270 ,p_sit_additional_tax IN number default null
271 ,p_sit_override_amount IN number default null
272 ,p_sit_override_rate IN number default null
273 ,p_withholding_allowances IN number default null
274 ,p_excessive_wa_reject_date IN date default null
275 ,p_sdi_exempt IN varchar2 default null
276 ,p_sit_exempt IN varchar2 default null
277 ,p_sit_optional_calc_ind IN varchar2 default null
278 ,p_state_non_resident_cert IN varchar2 default null
279 ,p_sui_exempt IN varchar2 default null
280 ,p_wc_exempt IN varchar2 default null
281 ,p_wage_exempt IN varchar2 default null
282 ,p_sui_wage_base_override_amoun IN number default null
283 ,p_supp_tax_override_rate IN number default null
284 ,p_attribute_category in varchar2 default null
285 ,p_attribute1 in varchar2 default null
286 ,p_attribute2 in varchar2 default null
287 ,p_attribute3 in varchar2 default null
288 ,p_attribute4 in varchar2 default null
289 ,p_attribute5 in varchar2 default null
290 ,p_attribute6 in varchar2 default null
291 ,p_attribute7 in varchar2 default null
292 ,p_attribute8 in varchar2 default null
293 ,p_attribute9 in varchar2 default null
294 ,p_attribute10 in varchar2 default null
295 ,p_attribute11 in varchar2 default null
296 ,p_attribute12 in varchar2 default null
297 ,p_attribute13 in varchar2 default null
298 ,p_attribute14 in varchar2 default null
299 ,p_attribute15 in varchar2 default null
300 ,p_attribute16 in varchar2 default null
301 ,p_attribute17 in varchar2 default null
302 ,p_attribute18 in varchar2 default null
303 ,p_attribute19 in varchar2 default null
304 ,p_attribute20 in varchar2 default null
305 ,p_attribute21 in varchar2 default null
306 ,p_attribute22 in varchar2 default null
307 ,p_attribute23 in varchar2 default null
308 ,p_attribute24 in varchar2 default null
309 ,p_attribute25 in varchar2 default null
310 ,p_attribute26 in varchar2 default null
311 ,p_attribute27 in varchar2 default null
312 ,p_attribute28 in varchar2 default null
313 ,p_attribute29 in varchar2 default null
314 ,p_attribute30 in varchar2 default null
315 ,p_sta_information_category in varchar2 default null
316 ,p_sta_information1 in varchar2 default null
317 ,p_sta_information2 in varchar2 default null
318 ,p_sta_information3 in varchar2 default null
319 ,p_sta_information4 in varchar2 default null
320 ,p_sta_information5 in varchar2 default null
321 ,p_sta_information6 in varchar2 default null
322 ,p_sta_information7 in varchar2 default null
323 ,p_sta_information8 in varchar2 default null
324 ,p_sta_information9 in varchar2 default null
325 ,p_sta_information10 in varchar2 default null
326 ,p_sta_information11 in varchar2 default null
327 ,p_sta_information12 in varchar2 default null
328 ,p_sta_information13 in varchar2 default null
329 ,p_sta_information14 in varchar2 default null
330 ,p_sta_information15 in varchar2 default null
331 ,p_sta_information16 in varchar2 default null
332 ,p_sta_information17 in varchar2 default null
333 ,p_sta_information18 in varchar2 default null
334 ,p_sta_information19 in varchar2 default null
335 ,p_sta_information20 in varchar2 default null
336 ,p_sta_information21 in varchar2 default null
337 ,p_sta_information22 in varchar2 default null
338 ,p_sta_information23 in varchar2 default null
339 ,p_sta_information24 in varchar2 default null
340 ,p_sta_information25 in varchar2 default null
341 ,p_sta_information26 in varchar2 default null
342 ,p_sta_information27 in varchar2 default null
343 ,p_sta_information28 in varchar2 default null
344 ,p_sta_information29 in varchar2 default null
345 ,p_sta_information30 in varchar2 default null
346 ,p_emp_state_tax_rule_id OUT nocopy number
347 ,p_object_version_number OUT nocopy number
348 ,p_effective_start_date OUT nocopy date
349 ,p_effective_end_date OUT nocopy date
350 );
351 --
352 -- ----------------------------------------------------------------------------
353 -- |--------------------------< update_state_tax_rule >-----------------------|
354 -- ----------------------------------------------------------------------------
355 --
356 -- {Start Of Comments}
357 /*#
358 * This API updates the state tax details for an employee assignment.
359 *
360 * This API is licensed for use with Human Resources.
361 *
362 * <p><b>Licensing</b><br>
363 * This API is licensed for use with Human Resources.
364 *
365 * <p><b>Prerequisites</b><br>
366 * A valid state tax rule record must exist on the effective date.
367 *
368 * <p><b>Post Success</b><br>
369 * The state tax details will be successfully updated.
370 *
371 * <p><b>Post Failure</b><br>
372 * The state tax rule will not be updated and an error raised.
373 * @param p_validate If true, then validation alone will be performed and the
374 * database will remain unchanged. If false and all validation checks pass,
375 * then the database will be modified.
376 * @param p_effective_date Determines when the DateTrack operation comes into
377 * force.
378 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
379 * updating the record. You must set to either UPDATE, CORRECTION,
380 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
381 * particular record depend on the dates of previous record changes and the
382 * effective date of this change.
383 * @param p_emp_state_tax_rule_id {@rep:casecolumn
384 * PAY_US_EMP_STATE_TAX_RULES_F.EMP_STATE_TAX_RULE_ID}
385 * @param p_object_version_number Pass in the current version number of the
386 * state tax rule to be updated. When the API completes, if P_VALIDATE is
387 * false, then it will be set to the new version number of the updated state
388 * tax rule. If P_VALIDATE is true, then it will be set to the same value which
389 * was passed in.
390 * @param p_additional_wa_amount Additional W4 withholding allowance amount.
391 * @param p_filing_status_code Filing status code. Valid values are identified
392 * by 'US_FS_nn' where nn is the state code.
393 * @param p_remainder_percent {@rep:casecolumn
394 * PAY_US_EMP_STATE_TAX_RULES_F.REMAINDER_PERCENT}
395 * @param p_secondary_wa {@rep:casecolumn
396 * PAY_US_EMP_STATE_TAX_RULES_F.SECONDARY_WA}
397 * @param p_sit_additional_tax {@rep:casecolumn
398 * PAY_US_EMP_STATE_TAX_RULES_F.SIT_ADDITIONAL_TAX}
399 * @param p_sit_override_amount {@rep:casecolumn
400 * PAY_US_EMP_STATE_TAX_RULES_F.SIT_OVERRIDE_AMOUNT}
401 * @param p_sit_override_rate {@rep:casecolumn
402 * PAY_US_EMP_STATE_TAX_RULES_F.SIT_OVERRIDE_RATE}
403 * @param p_withholding_allowances {@rep:casecolumn
404 * PAY_US_EMP_STATE_TAX_RULES_F.WITHHOLDING_ALLOWANCES}
405 * @param p_excessive_wa_reject_date {@rep:casecolumn
406 * PAY_US_EMP_STATE_TAX_RULES_F.EXCESSIVE_WA_REJECT_DATE}
407 * @param p_sdi_exempt SDI exempt flag. Valid values are defined by 'YES_NO'
408 * lookup type.
409 * @param p_sit_exempt State income tax exempt flag. Valid values are defined
410 * by 'YES_NO' lookup type.
411 * @param p_sit_optional_calc_ind {@rep:casecolumn
415 * type.
412 * PAY_US_EMP_STATE_TAX_RULES_F.SIT_OPTIONAL_CALC_IND}
413 * @param p_state_non_resident_cert Determines whether the assignment has a
414 * state non-resident certificate. Valid values are defined by 'YES_NO' lookup
416 * @param p_sui_exempt SUI exempt flag. Valid values are defined by 'YES_NO'
417 * lookup type.
418 * @param p_wc_exempt Workers Compensation exemption flag .Valid values are
419 * defined by 'YES_NO' lookup type.
420 * @param p_wage_exempt Wage Reporting exemption flag .Valid values are
421 * defined by 'YES_NO' lookup type.
422 * @param p_sui_wage_base_override_amoun {@rep:casecolumn
423 * PAY_US_EMP_STATE_TAX_RULES_F.SUI_WAGE_BASE_OVERRIDE_AMOUNT}
424 * @param p_supp_tax_override_rate {@rep:casecolumn
425 * PAY_US_EMP_STATE_TAX_RULES_F.SUPP_TAX_OVERRIDE_RATE}
426 * @param p_attribute_category This context value determines which flexfield
427 * structure to use with the descriptive flexfield segments.
428 * @param p_attribute1 Descriptive flexfield segment.
429 * @param p_attribute2 Descriptive flexfield segment.
430 * @param p_attribute3 Descriptive flexfield segment.
431 * @param p_attribute4 Descriptive flexfield segment.
432 * @param p_attribute5 Descriptive flexfield segment.
433 * @param p_attribute6 Descriptive flexfield segment.
434 * @param p_attribute7 Descriptive flexfield segment.
435 * @param p_attribute8 Descriptive flexfield segment.
436 * @param p_attribute9 Descriptive flexfield segment.
437 * @param p_attribute10 Descriptive flexfield segment.
438 * @param p_attribute11 Descriptive flexfield segment.
439 * @param p_attribute12 Descriptive flexfield segment.
440 * @param p_attribute13 Descriptive flexfield segment.
441 * @param p_attribute14 Descriptive flexfield segment.
442 * @param p_attribute15 Descriptive flexfield segment.
443 * @param p_attribute16 Descriptive flexfield segment.
444 * @param p_attribute17 Descriptive flexfield segment.
445 * @param p_attribute18 Descriptive flexfield segment.
446 * @param p_attribute19 Descriptive flexfield segment.
447 * @param p_attribute20 Descriptive flexfield segment.
448 * @param p_attribute21 Descriptive flexfield segment.
449 * @param p_attribute22 Descriptive flexfield segment.
450 * @param p_attribute23 Descriptive flexfield segment.
451 * @param p_attribute24 Descriptive flexfield segment.
452 * @param p_attribute25 Descriptive flexfield segment.
453 * @param p_attribute26 Descriptive flexfield segment.
454 * @param p_attribute27 Descriptive flexfield segment.
455 * @param p_attribute28 Descriptive flexfield segment.
456 * @param p_attribute29 Descriptive flexfield segment.
457 * @param p_attribute30 Descriptive flexfield segment.
458 * @param p_sta_information_category {@rep:casecolumn
459 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION_CATEGORY}
460 * @param p_sta_information1 {@rep:casecolumn
461 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION1}
462 * @param p_sta_information2 {@rep:casecolumn
463 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION2}
464 * @param p_sta_information3 {@rep:casecolumn
465 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION3}
466 * @param p_sta_information4 {@rep:casecolumn
467 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION4}
468 * @param p_sta_information5 {@rep:casecolumn
469 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION5}
470 * @param p_sta_information6 {@rep:casecolumn
471 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION6}
472 * @param p_sta_information7 {@rep:casecolumn
473 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION7}
474 * @param p_sta_information8 {@rep:casecolumn
475 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION8}
476 * @param p_sta_information9 {@rep:casecolumn
477 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION9}
478 * @param p_sta_information10 {@rep:casecolumn
479 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION10}
480 * @param p_sta_information11 {@rep:casecolumn
481 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION11}
482 * @param p_sta_information12 {@rep:casecolumn
483 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION12}
484 * @param p_sta_information13 {@rep:casecolumn
485 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION13}
486 * @param p_sta_information14 {@rep:casecolumn
487 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION14}
488 * @param p_sta_information15 {@rep:casecolumn
489 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION15}
490 * @param p_sta_information16 {@rep:casecolumn
491 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION16}
492 * @param p_sta_information17 {@rep:casecolumn
493 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION17}
494 * @param p_sta_information18 {@rep:casecolumn
495 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION18}
496 * @param p_sta_information19 {@rep:casecolumn
497 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION19}
498 * @param p_sta_information20 {@rep:casecolumn
499 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION20}
500 * @param p_sta_information21 {@rep:casecolumn
501 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION21}
502 * @param p_sta_information22 {@rep:casecolumn
503 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION22}
504 * @param p_sta_information23 {@rep:casecolumn
505 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION23}
506 * @param p_sta_information24 {@rep:casecolumn
507 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION24}
508 * @param p_sta_information25 {@rep:casecolumn
509 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION25}
510 * @param p_sta_information26 {@rep:casecolumn
511 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION26}
512 * @param p_sta_information27 {@rep:casecolumn
513 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION27}
517 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION29}
514 * @param p_sta_information28 {@rep:casecolumn
515 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION28}
516 * @param p_sta_information29 {@rep:casecolumn
518 * @param p_sta_information30 {@rep:casecolumn
519 * PAY_US_EMP_STATE_TAX_RULES_F.STA_INFORMATION30}
520 * @param p_effective_start_date If P_VALIDATE is false, then set to the
521 * effective start date on the updated state tax rule row which now exists as
522 * of the effective date. If p_validate is true, then set to null.
523 * @param p_effective_end_date If P_VALIDATE is false, then set to the
524 * effective end date on the updated state tax rule row which now exists as of
525 * the effective date. If p_validate is true, then set to null.
526 * @rep:displayname Update State Tax Rule
527 * @rep:category BUSINESS_ENTITY PAY_EMP_TAX_INFO
528 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
529 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
530 * @rep:scope public
531 * @rep:lifecycle active
532 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
533 */
534 --
535 -- {End Of Comments}
536 --
537 procedure update_state_tax_rule
538 (
539 p_validate in boolean default false
540 ,p_effective_date in date
541 ,p_datetrack_update_mode in varchar2
542 ,p_emp_state_tax_rule_id in number
543 ,p_object_version_number in out nocopy number
544 ,p_additional_wa_amount in number default hr_api.g_number
545 ,p_filing_status_code in varchar2 default hr_api.g_varchar2
546 ,p_remainder_percent in number default hr_api.g_number
547 ,p_secondary_wa in number default hr_api.g_number
548 ,p_sit_additional_tax in number default hr_api.g_number
549 ,p_sit_override_amount in number default hr_api.g_number
550 ,p_sit_override_rate in number default hr_api.g_number
551 ,p_withholding_allowances in number default hr_api.g_number
552 ,p_excessive_wa_reject_date in date default hr_api.g_date
553 ,p_sdi_exempt in varchar2 default hr_api.g_varchar2
554 ,p_sit_exempt in varchar2 default hr_api.g_varchar2
555 ,p_sit_optional_calc_ind in varchar2 default hr_api.g_varchar2
556 ,p_state_non_resident_cert in varchar2 default hr_api.g_varchar2
557 ,p_sui_exempt in varchar2 default hr_api.g_varchar2
558 ,p_wc_exempt in varchar2 default hr_api.g_varchar2
559 ,p_wage_exempt in varchar2 default hr_api.g_varchar2
560 ,p_sui_wage_base_override_amoun in number default hr_api.g_number
561 ,p_supp_tax_override_rate in number default hr_api.g_number
562 ,p_attribute_category in varchar2 default hr_api.g_varchar2
563 ,p_attribute1 in varchar2 default hr_api.g_varchar2
564 ,p_attribute2 in varchar2 default hr_api.g_varchar2
565 ,p_attribute3 in varchar2 default hr_api.g_varchar2
566 ,p_attribute4 in varchar2 default hr_api.g_varchar2
567 ,p_attribute5 in varchar2 default hr_api.g_varchar2
568 ,p_attribute6 in varchar2 default hr_api.g_varchar2
569 ,p_attribute7 in varchar2 default hr_api.g_varchar2
570 ,p_attribute8 in varchar2 default hr_api.g_varchar2
571 ,p_attribute9 in varchar2 default hr_api.g_varchar2
572 ,p_attribute10 in varchar2 default hr_api.g_varchar2
573 ,p_attribute11 in varchar2 default hr_api.g_varchar2
574 ,p_attribute12 in varchar2 default hr_api.g_varchar2
575 ,p_attribute13 in varchar2 default hr_api.g_varchar2
576 ,p_attribute14 in varchar2 default hr_api.g_varchar2
577 ,p_attribute15 in varchar2 default hr_api.g_varchar2
578 ,p_attribute16 in varchar2 default hr_api.g_varchar2
579 ,p_attribute17 in varchar2 default hr_api.g_varchar2
580 ,p_attribute18 in varchar2 default hr_api.g_varchar2
581 ,p_attribute19 in varchar2 default hr_api.g_varchar2
582 ,p_attribute20 in varchar2 default hr_api.g_varchar2
583 ,p_attribute21 in varchar2 default hr_api.g_varchar2
584 ,p_attribute22 in varchar2 default hr_api.g_varchar2
585 ,p_attribute23 in varchar2 default hr_api.g_varchar2
586 ,p_attribute24 in varchar2 default hr_api.g_varchar2
587 ,p_attribute25 in varchar2 default hr_api.g_varchar2
588 ,p_attribute26 in varchar2 default hr_api.g_varchar2
589 ,p_attribute27 in varchar2 default hr_api.g_varchar2
590 ,p_attribute28 in varchar2 default hr_api.g_varchar2
591 ,p_attribute29 in varchar2 default hr_api.g_varchar2
592 ,p_attribute30 in varchar2 default hr_api.g_varchar2
593 ,p_sta_information_category in varchar2 default hr_api.g_varchar2
594 ,p_sta_information1 in varchar2 default hr_api.g_varchar2
595 ,p_sta_information2 in varchar2 default hr_api.g_varchar2
596 ,p_sta_information3 in varchar2 default hr_api.g_varchar2
597 ,p_sta_information4 in varchar2 default hr_api.g_varchar2
598 ,p_sta_information5 in varchar2 default hr_api.g_varchar2
599 ,p_sta_information6 in varchar2 default hr_api.g_varchar2
600 ,p_sta_information7 in varchar2 default hr_api.g_varchar2
601 ,p_sta_information8 in varchar2 default hr_api.g_varchar2
602 ,p_sta_information9 in varchar2 default hr_api.g_varchar2
603 ,p_sta_information10 in varchar2 default hr_api.g_varchar2
604 ,p_sta_information11 in varchar2 default hr_api.g_varchar2
605 ,p_sta_information12 in varchar2 default hr_api.g_varchar2
606 ,p_sta_information13 in varchar2 default hr_api.g_varchar2
607 ,p_sta_information14 in varchar2 default hr_api.g_varchar2
608 ,p_sta_information15 in varchar2 default hr_api.g_varchar2
609 ,p_sta_information16 in varchar2 default hr_api.g_varchar2
610 ,p_sta_information17 in varchar2 default hr_api.g_varchar2
611 ,p_sta_information18 in varchar2 default hr_api.g_varchar2
612 ,p_sta_information19 in varchar2 default hr_api.g_varchar2
613 ,p_sta_information20 in varchar2 default hr_api.g_varchar2
614 ,p_sta_information21 in varchar2 default hr_api.g_varchar2
615 ,p_sta_information22 in varchar2 default hr_api.g_varchar2
616 ,p_sta_information23 in varchar2 default hr_api.g_varchar2
617 ,p_sta_information24 in varchar2 default hr_api.g_varchar2
618 ,p_sta_information25 in varchar2 default hr_api.g_varchar2
619 ,p_sta_information26 in varchar2 default hr_api.g_varchar2
620 ,p_sta_information27 in varchar2 default hr_api.g_varchar2
621 ,p_sta_information28 in varchar2 default hr_api.g_varchar2
622 ,p_sta_information29 in varchar2 default hr_api.g_varchar2
623 ,p_sta_information30 in varchar2 default hr_api.g_varchar2
624 ,p_effective_start_date out nocopy date
625 ,p_effective_end_date out nocopy date
626 );
627
628 --
629 end pay_state_tax_rule_api ;
[Home] [Help]