eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.HRDPP_CREATE_COUNTY_TAX_RULE

Source


1 package body hrdpp_CREATE_COUNTY_TAX_RULE as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2007/01/03 23:01:43
4  * Generated for API: PAY_COUNTY_TAX_RULE_API.CREATE_COUNTY_TAX_RULE
5  */
6 --
7 dh constant date := hr_api.g_date;
8 nh constant number := hr_api.g_number;
9 vh constant varchar2(64) := hr_api.g_varchar2;
10 c_sot constant date := to_date('01010001','DDMMYYYY');
11 cn constant varchar2(32) := '<NULL>';
12 dn constant date := null;
13 nn constant number := null;
14 vn constant varchar2(1) := null;
15 --
16 function dc(p in date) return varchar2 is
17 begin
18 if p<c_sot then
19  if p<>trunc(p) then
20   return to_char(p,'SYYYY/MM/DD HH24:MI:SS');
21  end if;
22  return to_char(p,'SYYYY/MM/DD');
23 elsif p<>trunc(p) then
24  return to_char(p,'YYYY/MM/DD HH24:MI:SS');
25 end if;
26 return to_char(p,'YYYY/MM/DD');
27 end dc;
28 function d(p in varchar2) return date is
29 begin
30 if length(p)=10 then
31 return to_date(p,'YYYY/MM/DD');
32 elsif length(p)=19 then
33 return to_date(p,'YYYY/MM/DD HH24:MI:SS');
34 elsif length(p)=11 then
35 return to_date(p,'SYYYY/MM/DD');
36 elsif length(p)=20 then
37 return to_date(p,'SYYYY/MM/DD HH24:MI:SS');
38 end if;
39 -- Try default format as last resort.
40 return to_date(p,'YYYY/MM/DD');
41 end d;
42 function n(p in varchar2) return number is
43 begin
44 return to_number(p);
45 end n;
46 function dd(p in date,i in varchar2)
47 return varchar2 is
48 begin
49 if upper(i) = 'N' then return dc(p);
50 else return cn; end if;
51 end dd;
52 function nd(p in number,i in varchar2)
53 return varchar2 is
54 begin
55 if upper(i) = 'N' then return to_char(p);
56 else return cn; end if;
57 end nd;
58 --
59 procedure iuk
60 (p_batch_line_id  in number,
61 p_user_key_value in varchar2,
62 p_unique_key_id  in number)
63 is
64 begin
65 hr_data_pump.entry('ins_user_key');
66 insert into hr_pump_batch_line_user_keys
67 (user_key_id, batch_line_id,user_key_value,unique_key_id)
68 values
69 (hr_pump_batch_line_user_keys_s.nextval,
70 p_batch_line_id,
71 p_user_key_value,
72 p_unique_key_id);
73 hr_data_pump.exit('ins_user_key');
74 end iuk;
75 --
76 procedure insert_batch_lines
77 (p_batch_id      in number
78 ,p_data_pump_batch_line_id in number default null
79 ,p_data_pump_business_grp_name in varchar2 default null
80 ,p_user_sequence in number default null
81 ,p_link_value    in number default null
82 ,P_EMP_COUNTY_TAX_RULE_USER_KEY in varchar2
83 ,P_ASSIGNMENT_ID in number
84 ,P_STATE_CODE in varchar2
85 ,P_COUNTY_CODE in varchar2
86 ,P_ADDITIONAL_WA_RATE in number
87 ,P_FILING_STATUS_CODE in varchar2
88 ,P_LIT_ADDITIONAL_TAX in number
89 ,P_LIT_OVERRIDE_AMOUNT in number
90 ,P_LIT_OVERRIDE_RATE in number
91 ,P_WITHHOLDING_ALLOWANCES in number
92 ,P_LIT_EXEMPT in varchar2 default null
93 ,P_SD_EXEMPT in varchar2 default null
94 ,P_HT_EXEMPT in varchar2 default null
95 ,P_SCHOOL_DISTRICT_CODE in varchar2 default null
96 ,P_EFFECTIVE_DATE in date
97 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
98 ,P_ATTRIBUTE1 in varchar2 default null
99 ,P_ATTRIBUTE2 in varchar2 default null
100 ,P_ATTRIBUTE3 in varchar2 default null
101 ,P_ATTRIBUTE4 in varchar2 default null
102 ,P_ATTRIBUTE5 in varchar2 default null
103 ,P_ATTRIBUTE6 in varchar2 default null
104 ,P_ATTRIBUTE7 in varchar2 default null
105 ,P_ATTRIBUTE8 in varchar2 default null
106 ,P_ATTRIBUTE9 in varchar2 default null
107 ,P_ATTRIBUTE10 in varchar2 default null
108 ,P_ATTRIBUTE11 in varchar2 default null
109 ,P_ATTRIBUTE12 in varchar2 default null
110 ,P_ATTRIBUTE13 in varchar2 default null
111 ,P_ATTRIBUTE14 in varchar2 default null
112 ,P_ATTRIBUTE15 in varchar2 default null
113 ,P_ATTRIBUTE16 in varchar2 default null
114 ,P_ATTRIBUTE17 in varchar2 default null
115 ,P_ATTRIBUTE18 in varchar2 default null
116 ,P_ATTRIBUTE19 in varchar2 default null
117 ,P_ATTRIBUTE20 in varchar2 default null
118 ,P_ATTRIBUTE21 in varchar2 default null
119 ,P_ATTRIBUTE22 in varchar2 default null
120 ,P_ATTRIBUTE23 in varchar2 default null
121 ,P_ATTRIBUTE24 in varchar2 default null
122 ,P_ATTRIBUTE25 in varchar2 default null
123 ,P_ATTRIBUTE26 in varchar2 default null
124 ,P_ATTRIBUTE27 in varchar2 default null
125 ,P_ATTRIBUTE28 in varchar2 default null
126 ,P_ATTRIBUTE29 in varchar2 default null
127 ,P_ATTRIBUTE30 in varchar2 default null
128 ,P_CNT_INFORMATION_CATEGORY in varchar2 default null
129 ,P_CNT_INFORMATION1 in varchar2 default null
130 ,P_CNT_INFORMATION2 in varchar2 default null
131 ,P_CNT_INFORMATION3 in varchar2 default null
132 ,P_CNT_INFORMATION4 in varchar2 default null
133 ,P_CNT_INFORMATION5 in varchar2 default null
134 ,P_CNT_INFORMATION6 in varchar2 default null
135 ,P_CNT_INFORMATION7 in varchar2 default null
136 ,P_CNT_INFORMATION8 in varchar2 default null
137 ,P_CNT_INFORMATION9 in varchar2 default null
138 ,P_CNT_INFORMATION10 in varchar2 default null
139 ,P_CNT_INFORMATION11 in varchar2 default null
140 ,P_CNT_INFORMATION12 in varchar2 default null
141 ,P_CNT_INFORMATION13 in varchar2 default null
142 ,P_CNT_INFORMATION14 in varchar2 default null
143 ,P_CNT_INFORMATION15 in varchar2 default null
144 ,P_CNT_INFORMATION16 in varchar2 default null
145 ,P_CNT_INFORMATION17 in varchar2 default null
146 ,P_CNT_INFORMATION18 in varchar2 default null
147 ,P_CNT_INFORMATION19 in varchar2 default null
148 ,P_CNT_INFORMATION20 in varchar2 default null
149 ,P_CNT_INFORMATION21 in varchar2 default null
150 ,P_CNT_INFORMATION22 in varchar2 default null
151 ,P_CNT_INFORMATION23 in varchar2 default null
152 ,P_CNT_INFORMATION24 in varchar2 default null
153 ,P_CNT_INFORMATION25 in varchar2 default null
154 ,P_CNT_INFORMATION26 in varchar2 default null
155 ,P_CNT_INFORMATION27 in varchar2 default null
156 ,P_CNT_INFORMATION28 in varchar2 default null
157 ,P_CNT_INFORMATION29 in varchar2 default null
158 ,P_CNT_INFORMATION30 in varchar2 default null) is
159 blid number := p_data_pump_batch_line_id;
160 begin
161 if blid is not null then
162 delete from hr_pump_batch_lines where batch_line_id = blid;
163 delete from hr_pump_batch_exceptions
164 where source_type = 'BATCH_LINE' and source_id = blid;
165 end if;
166 insert into hr_pump_batch_lines
167 (batch_id
168 ,batch_line_id
169 ,business_group_name
170 ,api_module_id
171 ,line_status
172 ,user_sequence
173 ,link_value
174 ,pval001
175 ,pval004
176 ,pval005
177 ,pval006
178 ,pval007
179 ,pval008
180 ,pval009
181 ,pval010
182 ,pval011
183 ,pval012
184 ,pval013
185 ,pval014
186 ,pval015
187 ,pval016
188 ,pval018
189 ,pval019
190 ,pval020
191 ,pval021
192 ,pval022
193 ,pval023
194 ,pval024
195 ,pval025
196 ,pval026
197 ,pval027
198 ,pval028
199 ,pval029
200 ,pval030
201 ,pval031
202 ,pval032
203 ,pval033
204 ,pval034
205 ,pval035
206 ,pval036
207 ,pval037
208 ,pval038
209 ,pval039
210 ,pval040
211 ,pval041
212 ,pval042
213 ,pval043
214 ,pval044
215 ,pval045
216 ,pval046
217 ,pval047
218 ,pval048
219 ,pval049
220 ,pval050
221 ,pval051
222 ,pval052
223 ,pval053
224 ,pval054
225 ,pval055
226 ,pval056
227 ,pval057
228 ,pval058
229 ,pval059
230 ,pval060
231 ,pval061
232 ,pval062
233 ,pval063
234 ,pval064
235 ,pval065
236 ,pval066
237 ,pval067
238 ,pval068
239 ,pval069
240 ,pval070
241 ,pval071
242 ,pval072
243 ,pval073
244 ,pval074
245 ,pval075
246 ,pval076
247 ,pval077
248 ,pval078
249 ,pval079
250 ,pval080)
251 values
252 (p_batch_id
253 ,nvl(blid,hr_pump_batch_lines_s.nextval)
254 ,p_data_pump_business_grp_name
255 ,1702
256 ,'U'
257 ,p_user_sequence
258 ,p_link_value
259 ,P_EMP_COUNTY_TAX_RULE_USER_KEY
260 ,P_ASSIGNMENT_ID
261 ,P_STATE_CODE
262 ,P_COUNTY_CODE
263 ,P_ADDITIONAL_WA_RATE
264 ,P_FILING_STATUS_CODE
265 ,P_LIT_ADDITIONAL_TAX
266 ,P_LIT_OVERRIDE_AMOUNT
267 ,P_LIT_OVERRIDE_RATE
268 ,P_WITHHOLDING_ALLOWANCES
269 ,P_LIT_EXEMPT
270 ,P_SD_EXEMPT
271 ,P_HT_EXEMPT
272 ,P_SCHOOL_DISTRICT_CODE
273 ,dc(P_EFFECTIVE_DATE)
274 ,P_ATTRIBUTE_CATEGORY
275 ,P_ATTRIBUTE1
276 ,P_ATTRIBUTE2
277 ,P_ATTRIBUTE3
278 ,P_ATTRIBUTE4
279 ,P_ATTRIBUTE5
280 ,P_ATTRIBUTE6
281 ,P_ATTRIBUTE7
282 ,P_ATTRIBUTE8
283 ,P_ATTRIBUTE9
284 ,P_ATTRIBUTE10
285 ,P_ATTRIBUTE11
286 ,P_ATTRIBUTE12
287 ,P_ATTRIBUTE13
288 ,P_ATTRIBUTE14
289 ,P_ATTRIBUTE15
290 ,P_ATTRIBUTE16
291 ,P_ATTRIBUTE17
292 ,P_ATTRIBUTE18
293 ,P_ATTRIBUTE19
294 ,P_ATTRIBUTE20
295 ,P_ATTRIBUTE21
296 ,P_ATTRIBUTE22
297 ,P_ATTRIBUTE23
298 ,P_ATTRIBUTE24
299 ,P_ATTRIBUTE25
300 ,P_ATTRIBUTE26
301 ,P_ATTRIBUTE27
302 ,P_ATTRIBUTE28
303 ,P_ATTRIBUTE29
304 ,P_ATTRIBUTE30
305 ,P_CNT_INFORMATION_CATEGORY
306 ,P_CNT_INFORMATION1
307 ,P_CNT_INFORMATION2
308 ,P_CNT_INFORMATION3
309 ,P_CNT_INFORMATION4
310 ,P_CNT_INFORMATION5
311 ,P_CNT_INFORMATION6
312 ,P_CNT_INFORMATION7
313 ,P_CNT_INFORMATION8
314 ,P_CNT_INFORMATION9
315 ,P_CNT_INFORMATION10
316 ,P_CNT_INFORMATION11
317 ,P_CNT_INFORMATION12
318 ,P_CNT_INFORMATION13
319 ,P_CNT_INFORMATION14
320 ,P_CNT_INFORMATION15
321 ,P_CNT_INFORMATION16
322 ,P_CNT_INFORMATION17
323 ,P_CNT_INFORMATION18
324 ,P_CNT_INFORMATION19
325 ,P_CNT_INFORMATION20
326 ,P_CNT_INFORMATION21
327 ,P_CNT_INFORMATION22
328 ,P_CNT_INFORMATION23
329 ,P_CNT_INFORMATION24
330 ,P_CNT_INFORMATION25
331 ,P_CNT_INFORMATION26
332 ,P_CNT_INFORMATION27
333 ,P_CNT_INFORMATION28
334 ,P_CNT_INFORMATION29
335 ,P_CNT_INFORMATION30);
336 end insert_batch_lines;
337 --
338 procedure call
339 (p_business_group_id in number,
340 p_batch_line_id     in number) is
341 cursor cr is
342 select l.rowid myrowid,
343 l.pval001 p1,
344 decode(l.pval002,cn,dn,d(l.pval002)) p2,
345 decode(l.pval003,cn,dn,d(l.pval003)) p3,
346 decode(l.pval004,cn,nn,n(l.pval004)) p4,
347 decode(l.pval005,cn,vn,l.pval005) p5,
348 decode(l.pval006,cn,vn,l.pval006) p6,
349 decode(l.pval007,cn,nn,n(l.pval007)) p7,
350 decode(l.pval008,cn,vn,
351  hr_pump_get.gl(l.pval008,'US_LIT_FILING_STATUS',d(l.pval018),vn)) p8,
352 decode(l.pval009,cn,nn,n(l.pval009)) p9,
353 decode(l.pval010,cn,nn,n(l.pval010)) p10,
354 decode(l.pval011,cn,nn,n(l.pval011)) p11,
355 decode(l.pval012,cn,nn,n(l.pval012)) p12,
356 decode(l.pval013,cn,vn,vn,vn,
357  hr_pump_get.gl(l.pval013,'YES_NO',d(l.pval018),vn)) p13,
358 l.pval013 d13,
359 decode(l.pval014,cn,vn,vn,vn,
360  hr_pump_get.gl(l.pval014,'YES_NO',d(l.pval018),vn)) p14,
361 l.pval014 d14,
362 decode(l.pval015,cn,vn,vn,vn,
363  hr_pump_get.gl(l.pval015,'YES_NO',d(l.pval018),vn)) p15,
364 l.pval015 d15,
365 decode(l.pval016,cn,vn,vn,vn,l.pval016) p16,
366 l.pval016 d16,
367 l.pval017 p17,
368 decode(l.pval018,cn,dn,d(l.pval018)) p18,
369 decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
370 l.pval019 d19,
371 decode(l.pval020,cn,vn,vn,vn,l.pval020) p20,
372 l.pval020 d20,
373 decode(l.pval021,cn,vn,vn,vn,l.pval021) p21,
374 l.pval021 d21,
375 decode(l.pval022,cn,vn,vn,vn,l.pval022) p22,
376 l.pval022 d22,
377 decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
378 l.pval023 d23,
379 decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,
380 l.pval024 d24,
381 decode(l.pval025,cn,vn,vn,vn,l.pval025) p25,
382 l.pval025 d25,
383 decode(l.pval026,cn,vn,vn,vn,l.pval026) p26,
384 l.pval026 d26,
385 decode(l.pval027,cn,vn,vn,vn,l.pval027) p27,
386 l.pval027 d27,
387 decode(l.pval028,cn,vn,vn,vn,l.pval028) p28,
388 l.pval028 d28,
389 decode(l.pval029,cn,vn,vn,vn,l.pval029) p29,
390 l.pval029 d29,
391 decode(l.pval030,cn,vn,vn,vn,l.pval030) p30,
392 l.pval030 d30,
393 decode(l.pval031,cn,vn,vn,vn,l.pval031) p31,
394 l.pval031 d31,
398 l.pval033 d33,
395 decode(l.pval032,cn,vn,vn,vn,l.pval032) p32,
396 l.pval032 d32,
397 decode(l.pval033,cn,vn,vn,vn,l.pval033) p33,
399 decode(l.pval034,cn,vn,vn,vn,l.pval034) p34,
400 l.pval034 d34,
401 decode(l.pval035,cn,vn,vn,vn,l.pval035) p35,
402 l.pval035 d35,
403 decode(l.pval036,cn,vn,vn,vn,l.pval036) p36,
404 l.pval036 d36,
405 decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
406 l.pval037 d37,
407 decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
408 l.pval038 d38,
409 decode(l.pval039,cn,vn,vn,vn,l.pval039) p39,
410 l.pval039 d39,
411 decode(l.pval040,cn,vn,vn,vn,l.pval040) p40,
412 l.pval040 d40,
413 decode(l.pval041,cn,vn,vn,vn,l.pval041) p41,
414 l.pval041 d41,
415 decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
416 l.pval042 d42,
417 decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
418 l.pval043 d43,
419 decode(l.pval044,cn,vn,vn,vn,l.pval044) p44,
420 l.pval044 d44,
421 decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
422 l.pval045 d45,
423 decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
424 l.pval046 d46,
425 decode(l.pval047,cn,vn,vn,vn,l.pval047) p47,
426 l.pval047 d47,
427 decode(l.pval048,cn,vn,vn,vn,l.pval048) p48,
428 l.pval048 d48,
429 decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
430 l.pval049 d49,
431 decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
432 l.pval050 d50,
433 decode(l.pval051,cn,vn,vn,vn,l.pval051) p51,
434 l.pval051 d51,
435 decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,
436 l.pval052 d52,
437 decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
438 l.pval053 d53,
439 decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
440 l.pval054 d54,
441 decode(l.pval055,cn,vn,vn,vn,l.pval055) p55,
442 l.pval055 d55,
443 decode(l.pval056,cn,vn,vn,vn,l.pval056) p56,
444 l.pval056 d56,
445 decode(l.pval057,cn,vn,vn,vn,l.pval057) p57,
446 l.pval057 d57,
447 decode(l.pval058,cn,vn,vn,vn,l.pval058) p58,
448 l.pval058 d58,
449 decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,
450 l.pval059 d59,
451 decode(l.pval060,cn,vn,vn,vn,l.pval060) p60,
452 l.pval060 d60,
453 decode(l.pval061,cn,vn,vn,vn,l.pval061) p61,
454 l.pval061 d61,
455 decode(l.pval062,cn,vn,vn,vn,l.pval062) p62,
456 l.pval062 d62,
457 decode(l.pval063,cn,vn,vn,vn,l.pval063) p63,
458 l.pval063 d63,
459 decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
460 l.pval064 d64,
461 decode(l.pval065,cn,vn,vn,vn,l.pval065) p65,
462 l.pval065 d65,
463 decode(l.pval066,cn,vn,vn,vn,l.pval066) p66,
464 l.pval066 d66,
465 decode(l.pval067,cn,vn,vn,vn,l.pval067) p67,
466 l.pval067 d67,
467 decode(l.pval068,cn,vn,vn,vn,l.pval068) p68,
468 l.pval068 d68,
469 decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
470 l.pval069 d69,
471 decode(l.pval070,cn,vn,vn,vn,l.pval070) p70,
472 l.pval070 d70,
473 decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
474 l.pval071 d71,
475 decode(l.pval072,cn,vn,vn,vn,l.pval072) p72,
476 l.pval072 d72,
477 decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
478 l.pval073 d73,
479 decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
480 l.pval074 d74,
481 decode(l.pval075,cn,vn,vn,vn,l.pval075) p75,
482 l.pval075 d75,
483 decode(l.pval076,cn,vn,vn,vn,l.pval076) p76,
484 l.pval076 d76,
485 decode(l.pval077,cn,vn,vn,vn,l.pval077) p77,
486 l.pval077 d77,
487 decode(l.pval078,cn,vn,vn,vn,l.pval078) p78,
488 l.pval078 d78,
489 decode(l.pval079,cn,vn,vn,vn,l.pval079) p79,
490 l.pval079 d79,
491 decode(l.pval080,cn,vn,vn,vn,l.pval080) p80,
492 l.pval080 d80
493 from hr_pump_batch_lines l
494 where l.batch_line_id = p_batch_line_id;
495 --
496 c cr%rowtype;
497 l_validate boolean := false;
498 L_EMP_COUNTY_TAX_RULE_ID number;
499 --
500 begin
501 hr_data_pump.entry('call');
502 open cr;
503 fetch cr into c;
504 if cr%notfound then
505 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
506 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
507 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
508 hr_utility.set_message_token('VALUE',p_batch_line_id);
509 hr_utility.raise_error;
510 end if;
511 --
512 hr_data_pump.api_trc_on;
513 PAY_COUNTY_TAX_RULE_API.CREATE_COUNTY_TAX_RULE
514 (p_validate => l_validate
515 ,P_EMP_COUNTY_TAX_RULE_ID => L_EMP_COUNTY_TAX_RULE_ID
516 ,P_EFFECTIVE_START_DATE => c.p2
517 ,P_EFFECTIVE_END_DATE => c.p3
518 ,P_ASSIGNMENT_ID => c.p4
519 ,P_STATE_CODE => c.p5
520 ,P_COUNTY_CODE => c.p6
521 ,P_ADDITIONAL_WA_RATE => c.p7
522 ,P_FILING_STATUS_CODE => c.p8
523 ,P_LIT_ADDITIONAL_TAX => c.p9
524 ,P_LIT_OVERRIDE_AMOUNT => c.p10
525 ,P_LIT_OVERRIDE_RATE => c.p11
526 ,P_WITHHOLDING_ALLOWANCES => c.p12
527 ,P_LIT_EXEMPT => c.p13
528 ,P_SD_EXEMPT => c.p14
529 ,P_HT_EXEMPT => c.p15
530 ,P_SCHOOL_DISTRICT_CODE => c.p16
531 ,P_OBJECT_VERSION_NUMBER => c.p17
532 ,P_EFFECTIVE_DATE => c.p18
533 ,P_ATTRIBUTE_CATEGORY => c.p19
534 ,P_ATTRIBUTE1 => c.p20
535 ,P_ATTRIBUTE2 => c.p21
536 ,P_ATTRIBUTE3 => c.p22
537 ,P_ATTRIBUTE4 => c.p23
538 ,P_ATTRIBUTE5 => c.p24
539 ,P_ATTRIBUTE6 => c.p25
540 ,P_ATTRIBUTE7 => c.p26
541 ,P_ATTRIBUTE8 => c.p27
542 ,P_ATTRIBUTE9 => c.p28
543 ,P_ATTRIBUTE10 => c.p29
544 ,P_ATTRIBUTE11 => c.p30
545 ,P_ATTRIBUTE12 => c.p31
546 ,P_ATTRIBUTE13 => c.p32
547 ,P_ATTRIBUTE14 => c.p33
548 ,P_ATTRIBUTE15 => c.p34
549 ,P_ATTRIBUTE16 => c.p35
550 ,P_ATTRIBUTE17 => c.p36
551 ,P_ATTRIBUTE18 => c.p37
552 ,P_ATTRIBUTE19 => c.p38
553 ,P_ATTRIBUTE20 => c.p39
554 ,P_ATTRIBUTE21 => c.p40
555 ,P_ATTRIBUTE22 => c.p41
556 ,P_ATTRIBUTE23 => c.p42
557 ,P_ATTRIBUTE24 => c.p43
558 ,P_ATTRIBUTE25 => c.p44
562 ,P_ATTRIBUTE29 => c.p48
559 ,P_ATTRIBUTE26 => c.p45
560 ,P_ATTRIBUTE27 => c.p46
561 ,P_ATTRIBUTE28 => c.p47
563 ,P_ATTRIBUTE30 => c.p49
564 ,P_CNT_INFORMATION_CATEGORY => c.p50
565 ,P_CNT_INFORMATION1 => c.p51
566 ,P_CNT_INFORMATION2 => c.p52
567 ,P_CNT_INFORMATION3 => c.p53
568 ,P_CNT_INFORMATION4 => c.p54
569 ,P_CNT_INFORMATION5 => c.p55
570 ,P_CNT_INFORMATION6 => c.p56
571 ,P_CNT_INFORMATION7 => c.p57
572 ,P_CNT_INFORMATION8 => c.p58
573 ,P_CNT_INFORMATION9 => c.p59
574 ,P_CNT_INFORMATION10 => c.p60
575 ,P_CNT_INFORMATION11 => c.p61
576 ,P_CNT_INFORMATION12 => c.p62
577 ,P_CNT_INFORMATION13 => c.p63
578 ,P_CNT_INFORMATION14 => c.p64
579 ,P_CNT_INFORMATION15 => c.p65
580 ,P_CNT_INFORMATION16 => c.p66
581 ,P_CNT_INFORMATION17 => c.p67
582 ,P_CNT_INFORMATION18 => c.p68
583 ,P_CNT_INFORMATION19 => c.p69
584 ,P_CNT_INFORMATION20 => c.p70
585 ,P_CNT_INFORMATION21 => c.p71
586 ,P_CNT_INFORMATION22 => c.p72
587 ,P_CNT_INFORMATION23 => c.p73
588 ,P_CNT_INFORMATION24 => c.p74
589 ,P_CNT_INFORMATION25 => c.p75
590 ,P_CNT_INFORMATION26 => c.p76
591 ,P_CNT_INFORMATION27 => c.p77
592 ,P_CNT_INFORMATION28 => c.p78
593 ,P_CNT_INFORMATION29 => c.p79
594 ,P_CNT_INFORMATION30 => c.p80);
595 hr_data_pump.api_trc_off;
596 --
597 iuk(p_batch_line_id,c.p1,L_EMP_COUNTY_TAX_RULE_ID);
598 --
599 update hr_pump_batch_lines l set
600 l.pval001 = decode(c.p1,null,cn,c.p1),
601 l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
602 l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
603 l.pval017 = decode(c.p17,null,cn,c.p17)
604 where l.rowid = c.myrowid;
605 --
606 close cr;
607 --
608 hr_data_pump.exit('call');
609 exception
610  when hr_multi_message.error_message_exist then
611    if cr%isopen then
612     close cr;
613    end if;
614    hr_pump_utils.set_multi_msg_error_flag(true);
615  when others then
616  if cr%isopen then
617   close cr;
618  end if;
619  raise;
620 end call;
621 end hrdpp_CREATE_COUNTY_TAX_RULE;