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_CITY_TAX_RULE

Source


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