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_UPDATE_CITY_TAX_RULE

Source


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