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_STATE_TAX_RULE

Source


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