[Home] [Help]
PACKAGE BODY: APPS.PAY_US_FEDERAL_TAX_INFO_F_PKG
Source
1 package body PAY_US_FEDERAL_TAX_INFO_F_PKG as
2 /* $Header: pyufti.pkb 115.1 2003/12/02 16:05:39 tmathers noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_FEDERAL_TAX_INFO_ID in NUMBER,
6 X_EFFECTIVE_START_DATE in DATE,
7 X_EFFECTIVE_END_DATE in DATE,
8 X_FUTA_WAGE_LIMIT in NUMBER,
9 X_FUTA_RATE in NUMBER,
10 X_SS_EE_WAGE_LIMIT in NUMBER,
11 X_SS_EE_RATE in NUMBER,
12 X_SS_ER_WAGE_LIMIT in NUMBER,
13 X_SS_ER_RATE in NUMBER,
14 X_MEDI_EE_RATE in NUMBER,
15 X_MEDI_ER_RATE in NUMBER,
16 X_ATTRIBUTE_CATEGORY in VARCHAR2,
17 X_FED_ATTRIBUTE1 in VARCHAR2,
18 X_FED_ATTRIBUTE2 in VARCHAR2,
19 X_FED_ATTRIBUTE3 in VARCHAR2,
20 X_FED_ATTRIBUTE4 in VARCHAR2,
21 X_FED_ATTRIBUTE5 in VARCHAR2,
22 X_FED_ATTRIBUTE6 in VARCHAR2,
23 X_FED_ATTRIBUTE7 in VARCHAR2,
24 X_FED_ATTRIBUTE8 in VARCHAR2,
25 X_FED_ATTRIBUTE9 in VARCHAR2,
26 X_FED_ATTRIBUTE10 in VARCHAR2,
27 X_FED_ATTRIBUTE11 in VARCHAR2,
28 X_FED_ATTRIBUTE12 in VARCHAR2,
29 X_FED_ATTRIBUTE13 in VARCHAR2,
30 X_FED_ATTRIBUTE14 in VARCHAR2,
31 X_FED_ATTRIBUTE15 in VARCHAR2,
32 X_FED_ATTRIBUTE16 in VARCHAR2,
33 X_FED_ATTRIBUTE17 in VARCHAR2,
34 X_FED_ATTRIBUTE18 in VARCHAR2,
35 X_FED_ATTRIBUTE19 in VARCHAR2,
36 X_FED_ATTRIBUTE20 in VARCHAR2,
37 X_FED_INFORMATION1 in VARCHAR2,
38 X_FED_INFORMATION2 in VARCHAR2,
39 X_FED_INFORMATION3 in VARCHAR2,
40 X_FED_INFORMATION4 in VARCHAR2,
41 X_FED_INFORMATION5 in VARCHAR2,
42 X_FED_INFORMATION6 in VARCHAR2,
43 X_FED_INFORMATION7 in VARCHAR2,
44 X_FED_INFORMATION8 in VARCHAR2,
45 X_FED_INFORMATION9 in VARCHAR2,
46 X_FED_INFORMATION10 in VARCHAR2,
47 X_FED_INFORMATION11 in VARCHAR2,
48 X_FED_INFORMATION12 in VARCHAR2,
49 X_FED_INFORMATION13 in VARCHAR2,
50 X_FED_INFORMATION14 in VARCHAR2,
51 X_FED_INFORMATION15 in VARCHAR2,
52 X_FED_INFORMATION16 in VARCHAR2,
53 X_FED_INFORMATION17 in VARCHAR2,
54 X_FED_INFORMATION18 in VARCHAR2,
55 X_FED_INFORMATION19 in VARCHAR2,
56 X_FED_INFORMATION20 in VARCHAR2,
57 X_FED_INFORMATION21 in VARCHAR2,
58 X_FED_INFORMATION22 in VARCHAR2,
59 X_FED_INFORMATION23 in VARCHAR2,
60 X_FED_INFORMATION24 in VARCHAR2,
61 X_FED_INFORMATION25 in VARCHAR2,
62 X_FED_INFORMATION26 in VARCHAR2,
63 X_FED_INFORMATION27 in VARCHAR2,
64 X_FED_INFORMATION28 in VARCHAR2,
65 X_FED_INFORMATION29 in VARCHAR2,
66 X_FED_INFORMATION30 in VARCHAR2,
67 X_REQUEST_ID in NUMBER,
68 X_FED_INFORMATION_CATEGORY in VARCHAR2,
69 X_CREATION_DATE in DATE,
70 X_CREATED_BY in NUMBER,
71 X_LAST_UPDATE_DATE in DATE,
72 X_LAST_UPDATED_BY in NUMBER,
73 X_LAST_UPDATE_LOGIN in NUMBER
74 ) is
75 cursor C is select ROWID from PAY_US_FEDERAL_TAX_INFO_F
76 where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
77 and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE
78 and EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE
79 ;
80 begin
81 insert into PAY_US_FEDERAL_TAX_INFO_F (
82 FEDERAL_TAX_INFO_ID,
83 EFFECTIVE_START_DATE,
84 EFFECTIVE_END_DATE,
85 FUTA_WAGE_LIMIT,
86 FUTA_RATE,
87 SS_EE_WAGE_LIMIT,
88 SS_EE_RATE,
89 SS_ER_WAGE_LIMIT,
90 SS_ER_RATE,
91 MEDI_EE_RATE,
92 MEDI_ER_RATE,
93 ATTRIBUTE_CATEGORY,
94 FED_ATTRIBUTE1,
95 FED_ATTRIBUTE2,
96 FED_ATTRIBUTE3,
97 FED_ATTRIBUTE4,
98 FED_ATTRIBUTE5,
99 FED_ATTRIBUTE6,
100 FED_ATTRIBUTE7,
101 FED_ATTRIBUTE8,
102 FED_ATTRIBUTE9,
103 FED_ATTRIBUTE10,
104 FED_ATTRIBUTE11,
105 FED_ATTRIBUTE12,
106 FED_ATTRIBUTE13,
107 FED_ATTRIBUTE14,
108 FED_ATTRIBUTE15,
109 FED_ATTRIBUTE16,
110 FED_ATTRIBUTE17,
111 FED_ATTRIBUTE18,
112 FED_ATTRIBUTE19,
113 FED_ATTRIBUTE20,
114 FED_INFORMATION_CATEGORY,
115 FED_INFORMATION1,
116 FED_INFORMATION2,
117 FED_INFORMATION3,
118 FED_INFORMATION4,
119 FED_INFORMATION5,
120 FED_INFORMATION6,
121 FED_INFORMATION7,
122 FED_INFORMATION8,
123 FED_INFORMATION9,
124 FED_INFORMATION10,
125 FED_INFORMATION11,
126 FED_INFORMATION12,
127 FED_INFORMATION13,
128 FED_INFORMATION14,
129 FED_INFORMATION15,
130 FED_INFORMATION16,
131 FED_INFORMATION17,
132 FED_INFORMATION18,
133 FED_INFORMATION19,
134 FED_INFORMATION20,
135 FED_INFORMATION21,
136 FED_INFORMATION22,
137 FED_INFORMATION23,
138 FED_INFORMATION24,
139 FED_INFORMATION25,
140 FED_INFORMATION26,
141 FED_INFORMATION27,
142 FED_INFORMATION28,
143 FED_INFORMATION29,
144 FED_INFORMATION30,
145 REQUEST_ID,
146 CREATION_DATE,
147 CREATED_BY,
148 LAST_UPDATE_DATE,
149 LAST_UPDATED_BY,
150 LAST_UPDATE_LOGIN
151 ) values (
152 X_FEDERAL_TAX_INFO_ID,
153 X_EFFECTIVE_START_DATE,
154 X_EFFECTIVE_END_DATE,
155 X_FUTA_WAGE_LIMIT,
156 X_FUTA_RATE,
157 X_SS_EE_WAGE_LIMIT,
158 X_SS_EE_RATE,
159 X_SS_ER_WAGE_LIMIT,
160 X_SS_ER_RATE,
161 X_MEDI_EE_RATE,
162 X_MEDI_ER_RATE,
163 X_ATTRIBUTE_CATEGORY,
164 X_FED_ATTRIBUTE1,
165 X_FED_ATTRIBUTE2,
166 X_FED_ATTRIBUTE3,
167 X_FED_ATTRIBUTE4,
168 X_FED_ATTRIBUTE5,
169 X_FED_ATTRIBUTE6,
170 X_FED_ATTRIBUTE7,
171 X_FED_ATTRIBUTE8,
172 X_FED_ATTRIBUTE9,
173 X_FED_ATTRIBUTE10,
174 X_FED_ATTRIBUTE11,
175 X_FED_ATTRIBUTE12,
176 X_FED_ATTRIBUTE13,
177 X_FED_ATTRIBUTE14,
178 X_FED_ATTRIBUTE15,
179 X_FED_ATTRIBUTE16,
180 X_FED_ATTRIBUTE17,
181 X_FED_ATTRIBUTE18,
182 X_FED_ATTRIBUTE19,
183 X_FED_ATTRIBUTE20,
184 X_FED_INFORMATION_CATEGORY,
185 X_FED_INFORMATION1,
186 X_FED_INFORMATION2,
187 X_FED_INFORMATION3,
188 X_FED_INFORMATION4,
189 X_FED_INFORMATION5,
190 X_FED_INFORMATION6,
191 X_FED_INFORMATION7,
192 X_FED_INFORMATION8,
193 X_FED_INFORMATION9,
194 X_FED_INFORMATION10,
195 X_FED_INFORMATION11,
196 X_FED_INFORMATION12,
197 X_FED_INFORMATION13,
198 X_FED_INFORMATION14,
199 X_FED_INFORMATION15,
200 X_FED_INFORMATION16,
201 X_FED_INFORMATION17,
202 X_FED_INFORMATION18,
203 X_FED_INFORMATION19,
204 X_FED_INFORMATION20,
205 X_FED_INFORMATION21,
206 X_FED_INFORMATION22,
207 X_FED_INFORMATION23,
208 X_FED_INFORMATION24,
209 X_FED_INFORMATION25,
210 X_FED_INFORMATION26,
211 X_FED_INFORMATION27,
212 X_FED_INFORMATION28,
213 X_FED_INFORMATION29,
214 X_FED_INFORMATION30,
215 X_REQUEST_ID,
216 X_CREATION_DATE,
217 X_CREATED_BY,
218 X_LAST_UPDATE_DATE,
219 X_LAST_UPDATED_BY,
220 X_LAST_UPDATE_LOGIN
221 );
222 Open C;
223 fetch C into X_ROWID;
224 CLOSE C;
225
226 end INSERT_ROW;
227
228 procedure UPLOAD_ROW (
229 X_FEDERAL_TAX_INFO_ID in NUMBER,
230 X_EFFECTIVE_START_DATE in DATE,
231 X_EFFECTIVE_END_DATE in DATE,
232 X_FUTA_WAGE_LIMIT in NUMBER,
233 X_FUTA_RATE in NUMBER,
234 X_SS_EE_WAGE_LIMIT in NUMBER,
235 X_SS_EE_RATE in NUMBER,
236 X_SS_ER_WAGE_LIMIT in NUMBER,
237 X_SS_ER_RATE in NUMBER,
238 X_MEDI_EE_RATE in NUMBER,
239 X_MEDI_ER_RATE in NUMBER,
240 X_ATTRIBUTE_CATEGORY in VARCHAR2,
241 X_FED_ATTRIBUTE1 in VARCHAR2,
242 X_FED_ATTRIBUTE2 in VARCHAR2,
243 X_FED_ATTRIBUTE3 in VARCHAR2,
244 X_FED_ATTRIBUTE4 in VARCHAR2,
245 X_FED_ATTRIBUTE5 in VARCHAR2,
246 X_FED_ATTRIBUTE6 in VARCHAR2,
247 X_FED_ATTRIBUTE7 in VARCHAR2,
248 X_FED_ATTRIBUTE8 in VARCHAR2,
249 X_FED_ATTRIBUTE9 in VARCHAR2,
250 X_FED_ATTRIBUTE10 in VARCHAR2,
251 X_FED_ATTRIBUTE11 in VARCHAR2,
252 X_FED_ATTRIBUTE12 in VARCHAR2,
253 X_FED_ATTRIBUTE13 in VARCHAR2,
254 X_FED_ATTRIBUTE14 in VARCHAR2,
255 X_FED_ATTRIBUTE15 in VARCHAR2,
256 X_FED_ATTRIBUTE16 in VARCHAR2,
257 X_FED_ATTRIBUTE17 in VARCHAR2,
258 X_FED_ATTRIBUTE18 in VARCHAR2,
259 X_FED_ATTRIBUTE19 in VARCHAR2,
260 X_FED_ATTRIBUTE20 in VARCHAR2,
261 X_FED_INFORMATION1 in VARCHAR2,
262 X_FED_INFORMATION2 in VARCHAR2,
263 X_FED_INFORMATION3 in VARCHAR2,
264 X_FED_INFORMATION4 in VARCHAR2,
265 X_FED_INFORMATION5 in VARCHAR2,
266 X_FED_INFORMATION6 in VARCHAR2,
267 X_FED_INFORMATION7 in VARCHAR2,
268 X_FED_INFORMATION8 in VARCHAR2,
269 X_FED_INFORMATION9 in VARCHAR2,
270 X_FED_INFORMATION10 in VARCHAR2,
271 X_FED_INFORMATION11 in VARCHAR2,
272 X_FED_INFORMATION12 in VARCHAR2,
273 X_FED_INFORMATION13 in VARCHAR2,
274 X_FED_INFORMATION14 in VARCHAR2,
275 X_FED_INFORMATION15 in VARCHAR2,
276 X_FED_INFORMATION16 in VARCHAR2,
277 X_FED_INFORMATION17 in VARCHAR2,
278 X_FED_INFORMATION18 in VARCHAR2,
279 X_FED_INFORMATION19 in VARCHAR2,
280 X_FED_INFORMATION20 in VARCHAR2,
281 X_FED_INFORMATION21 in VARCHAR2,
282 X_FED_INFORMATION22 in VARCHAR2,
283 X_FED_INFORMATION23 in VARCHAR2,
284 X_FED_INFORMATION24 in VARCHAR2,
285 X_FED_INFORMATION25 in VARCHAR2,
286 X_FED_INFORMATION26 in VARCHAR2,
287 X_FED_INFORMATION27 in VARCHAR2,
288 X_FED_INFORMATION28 in VARCHAR2,
289 X_FED_INFORMATION29 in VARCHAR2,
290 X_FED_INFORMATION30 in VARCHAR2,
291 X_REQUEST_ID in NUMBER,
292 X_FED_INFORMATION_CATEGORY in VARCHAR2,
293 X_CREATION_DATE in DATE,
294 X_CREATED_BY in NUMBER,
295 X_LAST_UPDATE_DATE in DATE,
296 X_LAST_UPDATED_BY in NUMBER,
297 X_LAST_UPDATE_LOGIN in NUMBER
298 ) is
299 cursor c1(X_FEDERAL_TAX_INFO_ID NUMBER) is
300 select 'Y'
301 from PAY_US_FEDERAL_TAX_INFO_F
302 where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID;
303 --
304 cursor c2(X_FEDERAL_TAX_INFO_ID NUMBER,X_EFFECTIVE_START_DATE DATE) is
305 select *
306 from PAY_US_FEDERAL_TAX_INFO_F
307 where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
308 and X_EFFECTIVE_START_DATE > EFFECTIVE_START_DATE
309 and X_EFFECTIVE_START_DATE < EFFECTIVE_END_DATE
310 FOR UPDATE OF EFFECTIVE_END_DATE;
311 --
312 cursor c3(X_FEDERAL_TAX_INFO_ID NUMBER, X_EFFECTIVE_END_DATE DATE) is
313 select *
314 from PAY_US_FEDERAL_TAX_INFO_F
315 where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
316 and X_EFFECTIVE_END_DATE > EFFECTIVE_START_DATE
317 and X_EFFECTIVE_END_DATE < EFFECTIVE_END_DATE
318 FOR UPDATE OF EFFECTIVE_START_DATE;
319 --
320 l_temp VARCHAR2(1);
321 l_rec PAY_US_FEDERAL_TAX_INFO_F%ROWTYPE;
322 l_rowid VARCHAR2(100);
323 begin
324 update PAY_US_FEDERAL_TAX_INFO_F set
325 FUTA_WAGE_LIMIT = X_FUTA_WAGE_LIMIT,
326 FUTA_RATE = X_FUTA_RATE,
327 SS_EE_WAGE_LIMIT = X_SS_EE_WAGE_LIMIT,
328 SS_EE_RATE = X_SS_EE_RATE,
329 SS_ER_WAGE_LIMIT = X_SS_ER_WAGE_LIMIT,
330 SS_ER_RATE = X_SS_ER_RATE,
331 MEDI_EE_RATE = X_MEDI_EE_RATE,
332 MEDI_ER_RATE = X_MEDI_ER_RATE,
333 FED_INFORMATION_CATEGORY = X_FED_INFORMATION_CATEGORY,
334 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
335 FED_ATTRIBUTE1 = X_FED_ATTRIBUTE1,
336 FED_ATTRIBUTE2 = X_FED_ATTRIBUTE2,
337 FED_ATTRIBUTE3 = X_FED_ATTRIBUTE3,
338 FED_ATTRIBUTE4 = X_FED_ATTRIBUTE4,
339 FED_ATTRIBUTE5 = X_FED_ATTRIBUTE5,
340 FED_ATTRIBUTE6 = X_FED_ATTRIBUTE6,
341 FED_ATTRIBUTE7 = X_FED_ATTRIBUTE7,
342 FED_ATTRIBUTE8 = X_FED_ATTRIBUTE8,
343 FED_ATTRIBUTE9 = X_FED_ATTRIBUTE9,
344 FED_ATTRIBUTE10 = X_FED_ATTRIBUTE10,
345 FED_ATTRIBUTE11 = X_FED_ATTRIBUTE11,
346 FED_ATTRIBUTE12 = X_FED_ATTRIBUTE12,
347 FED_ATTRIBUTE13 = X_FED_ATTRIBUTE13,
348 FED_ATTRIBUTE14 = X_FED_ATTRIBUTE14,
349 FED_ATTRIBUTE15 = X_FED_ATTRIBUTE15,
350 FED_ATTRIBUTE16 = X_FED_ATTRIBUTE16,
351 FED_ATTRIBUTE17 = X_FED_ATTRIBUTE17,
352 FED_ATTRIBUTE18 = X_FED_ATTRIBUTE18,
353 FED_ATTRIBUTE19 = X_FED_ATTRIBUTE19,
354 FED_ATTRIBUTE20 = X_FED_ATTRIBUTE20,
355 FED_INFORMATION1 = X_FED_INFORMATION1,
356 FED_INFORMATION2 = X_FED_INFORMATION2,
357 FED_INFORMATION3 = X_FED_INFORMATION3,
358 FED_INFORMATION4 = X_FED_INFORMATION4,
359 FED_INFORMATION5 = X_FED_INFORMATION5,
360 FED_INFORMATION6 = X_FED_INFORMATION6,
361 FED_INFORMATION7 = X_FED_INFORMATION7,
362 FED_INFORMATION8 = X_FED_INFORMATION8,
363 FED_INFORMATION9 = X_FED_INFORMATION9,
364 FED_INFORMATION10 = X_FED_INFORMATION10,
365 FED_INFORMATION11 = X_FED_INFORMATION11,
366 FED_INFORMATION12 = X_FED_INFORMATION12,
367 FED_INFORMATION13 = X_FED_INFORMATION13,
368 FED_INFORMATION14 = X_FED_INFORMATION14,
369 FED_INFORMATION15 = X_FED_INFORMATION15,
370 FED_INFORMATION16 = X_FED_INFORMATION16,
371 FED_INFORMATION17 = X_FED_INFORMATION17,
372 FED_INFORMATION18 = X_FED_INFORMATION18,
373 FED_INFORMATION19 = X_FED_INFORMATION19,
374 FED_INFORMATION20 = X_FED_INFORMATION20,
375 FED_INFORMATION21 = X_FED_INFORMATION21,
376 FED_INFORMATION22 = X_FED_INFORMATION22,
377 FED_INFORMATION23 = X_FED_INFORMATION23,
378 FED_INFORMATION24 = X_FED_INFORMATION24,
379 FED_INFORMATION25 = X_FED_INFORMATION25,
380 FED_INFORMATION26 = X_FED_INFORMATION26,
381 FED_INFORMATION27 = X_FED_INFORMATION27,
382 FED_INFORMATION28 = X_FED_INFORMATION28,
383 FED_INFORMATION29 = X_FED_INFORMATION29,
384 FED_INFORMATION30 = X_FED_INFORMATION30,
385 REQUEST_ID = X_REQUEST_ID,
386 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
387 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
388 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
389 where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
390 and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE
391 and EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE;
392
393 if (sql%notfound) then
394 begin
395 open c1(X_FEDERAL_TAX_INFO_ID);
396 fetch c1 into l_temp;
397 if c1%FOUND then
398 BEGIN
399 -- does the start date intersect with an existing row
400 open c2(X_FEDERAL_TAX_INFO_ID, X_EFFECTIVE_START_DATE);
401 fetch c2 into l_rec;
402 if c2%FOUND then
403 UPDATE PAY_US_FEDERAL_TAX_INFO_F
404 SET EFFECTIVE_END_DATE = X_EFFECTIVE_START_DATE -1
405 WHERE CURRENT OF c2;
406 end if;
407 close c2;
408 -- does the end date intersect with an existing row?
409 open c3(X_FEDERAL_TAX_INFO_ID, X_EFFECTIVE_END_DATE);
410 fetch c3 into l_rec;
411 if c3%FOUND then
412 UPDATE PAY_US_FEDERAL_TAX_INFO_F
413 SET EFFECTIVE_START_DATE = X_EFFECTIVE_END_DATE +1
414 WHERE CURRENT OF c3;
415 end if;
416 close c3;
417 END;
418 end if;
419 CLOSE c1;
420 -- Insert our new row.
421 PAY_US_FEDERAL_TAX_INFO_F_PKG.INSERT_ROW(
422 X_ROWID => l_rowid,
423 X_FEDERAL_TAX_INFO_ID => X_FEDERAL_TAX_INFO_ID,
424 X_EFFECTIVE_START_DATE => X_EFFECTIVE_START_DATE,
425 X_EFFECTIVE_END_DATE => X_EFFECTIVE_END_DATE,
426 X_FUTA_WAGE_LIMIT => X_FUTA_WAGE_LIMIT,
427 X_FUTA_RATE => X_FUTA_RATE,
428 X_SS_EE_WAGE_LIMIT => X_SS_EE_WAGE_LIMIT,
429 X_SS_EE_RATE => X_SS_EE_RATE,
430 X_SS_ER_WAGE_LIMIT => X_SS_ER_WAGE_LIMIT,
431 X_SS_ER_RATE => X_SS_ER_RATE,
432 X_MEDI_EE_RATE => X_MEDI_EE_RATE,
433 X_MEDI_ER_RATE => X_MEDI_ER_RATE,
434 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
435 X_FED_ATTRIBUTE1 => X_FED_ATTRIBUTE1,
436 X_FED_ATTRIBUTE2 => X_FED_ATTRIBUTE2,
437 X_FED_ATTRIBUTE3 => X_FED_ATTRIBUTE3,
438 X_FED_ATTRIBUTE4 => X_FED_ATTRIBUTE4,
439 X_FED_ATTRIBUTE5 => X_FED_ATTRIBUTE5,
440 X_FED_ATTRIBUTE6 => X_FED_ATTRIBUTE6,
441 X_FED_ATTRIBUTE7 => X_FED_ATTRIBUTE7,
442 X_FED_ATTRIBUTE8 => X_FED_ATTRIBUTE8,
443 X_FED_ATTRIBUTE9 => X_FED_ATTRIBUTE9,
444 X_FED_ATTRIBUTE10 => X_FED_ATTRIBUTE10,
445 X_FED_ATTRIBUTE11 => X_FED_ATTRIBUTE11,
446 X_FED_ATTRIBUTE12 => X_FED_ATTRIBUTE12,
447 X_FED_ATTRIBUTE13 => X_FED_ATTRIBUTE13,
448 X_FED_ATTRIBUTE14 => X_FED_ATTRIBUTE14,
449 X_FED_ATTRIBUTE15 => X_FED_ATTRIBUTE15,
450 X_FED_ATTRIBUTE16 => X_FED_ATTRIBUTE16,
451 X_FED_ATTRIBUTE17 => X_FED_ATTRIBUTE17,
452 X_FED_ATTRIBUTE18 => X_FED_ATTRIBUTE18,
453 X_FED_ATTRIBUTE19 => X_FED_ATTRIBUTE19,
454 X_FED_ATTRIBUTE20 => X_FED_ATTRIBUTE20,
455 X_FED_INFORMATION1 => X_FED_INFORMATION1,
456 X_FED_INFORMATION2 => X_FED_INFORMATION2,
457 X_FED_INFORMATION3 => X_FED_INFORMATION3,
458 X_FED_INFORMATION4 => X_FED_INFORMATION4,
459 X_FED_INFORMATION5 => X_FED_INFORMATION5,
460 X_FED_INFORMATION6 => X_FED_INFORMATION6,
461 X_FED_INFORMATION7 => X_FED_INFORMATION7,
462 X_FED_INFORMATION8 => X_FED_INFORMATION8,
463 X_FED_INFORMATION9 => X_FED_INFORMATION9,
464 X_FED_INFORMATION10 => X_FED_INFORMATION10,
465 X_FED_INFORMATION11 => X_FED_INFORMATION11,
466 X_FED_INFORMATION12 => X_FED_INFORMATION12,
467 X_FED_INFORMATION13 => X_FED_INFORMATION13,
468 X_FED_INFORMATION14 => X_FED_INFORMATION14,
469 X_FED_INFORMATION15 => X_FED_INFORMATION15,
470 X_FED_INFORMATION16 => X_FED_INFORMATION16,
471 X_FED_INFORMATION17 => X_FED_INFORMATION17,
472 X_FED_INFORMATION18 => X_FED_INFORMATION18,
473 X_FED_INFORMATION19 => X_FED_INFORMATION19,
474 X_FED_INFORMATION20 => X_FED_INFORMATION20,
475 X_FED_INFORMATION21 => X_FED_INFORMATION21,
476 X_FED_INFORMATION22 => X_FED_INFORMATION22,
477 X_FED_INFORMATION23 => X_FED_INFORMATION23,
478 X_FED_INFORMATION24 => X_FED_INFORMATION24,
479 X_FED_INFORMATION25 => X_FED_INFORMATION25,
480 X_FED_INFORMATION26 => X_FED_INFORMATION26,
481 X_FED_INFORMATION27 => X_FED_INFORMATION27,
482 X_FED_INFORMATION28 => X_FED_INFORMATION28,
483 X_FED_INFORMATION29 => X_FED_INFORMATION29,
484 X_FED_INFORMATION30 => X_FED_INFORMATION30,
485 X_REQUEST_ID => X_REQUEST_ID,
486 X_CREATION_DATE => X_CREATION_DATE,
487 X_CREATED_BY => X_CREATED_BY,
488 X_FED_INFORMATION_CATEGORY => X_FED_INFORMATION_CATEGORY,
489 X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
490 X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
491 X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN);
492 end;
493 end if;
494 end UPLOAD_ROW;
495
496 procedure DELETE_ROW (
497 X_FEDERAL_TAX_INFO_ID in NUMBER,
498 X_EFFECTIVE_START_DATE in DATE,
499 X_EFFECTIVE_END_DATE in DATE
500 ) is
501 begin
502 delete from PAY_US_FEDERAL_TAX_INFO_F
503 where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
504 and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE
505 and EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE;
506
507 if (sql%notfound) then
508 raise no_data_found;
509 end if;
510 end DELETE_ROW;
511
512 end PAY_US_FEDERAL_TAX_INFO_F_PKG;