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.
[Home] [Help]
PACKAGE BODY: APPS.HRDPP_UPDATE_COUNTY_TAX_RULE

Source


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