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


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