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_AC_EMPTAXRULE

Source


6 --
1 package body hrdpp_CREATE_AC_EMPTAXRULE as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2013/08/13 18:08:40
4  * Generated for API: PAY_RI_AC_TAX_RULE.CREATE_AC_EMPTAXRULE
5  */
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_BUSINESS_GROUP in number default null
83 ,P_EFFECTIVE_DATE in date default null
84 ,P_EMPLOYEE in varchar2 default null
85 ,P_ASSIGNMENT in varchar2 default null
86 ,P_LEGISLATION in varchar2 default null
87 ,P_SPREADSHEET_IDENTIFIER in varchar2 default null
88 ,P_SUI_STATE in varchar2 default null
89 ,P_STATE_PROV_CODE in varchar2 default null
90 ,P_COUNTY in varchar2 default null
91 ,P_CITY in varchar2 default null
92 ,P_OVERRIDE_PROV_OF_EMPLT in varchar2 default null
93 ,P_BASIC_AMT_FLAG in varchar2 default null
94 ,P_BASIC_AMT in number default null
95 ,P_TAX_CREDIT in number default null
96 ,P_FILING_STATUS_CODE in varchar2 default null
97 ,P_ALLOWANCES in number default null
98 ,P_ADDITIONAL_TAX in number default null
99 ,P_SECONDARY_ALLOWANCES in number default null
100 ,P_EXEMPTION_AMT in number default null
101 ,P_SIT_OPTIONAL_CALC_IND in varchar2 default null
102 ,P_ADDTL_ALLOWANCE_RATE in number default null
103 ,P_PRES_ZONE_DEDN in number default null
104 ,P_TAX_EXEMPT1 in varchar2 default null
105 ,P_TAX_EXEMPT2 in varchar2 default null
106 ,P_TAX_EXEMPT3 in varchar2 default null
107 ,P_TAX_EXEMPT4 in varchar2 default null
108 ,P_OVERRIDE_RATE in number default null
109 ,P_OVERRIDE_AMOUNT in number default null
110 ,P_OVERRIDE_SUPP_RATE in number default null
111 ,P_ANNUAL_DEDN in number default null
112 ,P_LABOR_FUND_CONTR in number default null
113 ,P_ALLOWANCE_REJECT_DATE in date default null
114 ,P_EIC_FILING_STATUS in varchar2 default null
115 ,P_STATUTORY_EMPLOYEE in varchar2 default null
116 ,P_CUMULATIVE_TAXATION in varchar2 default null
117 ,P_NON_RESIDENT in varchar2 default null
118 ,P_SUI_BASE_OVERRIDE_AMOUNT in number default null
119 ,P_SCHOOL_DISTRICT in varchar2 default null
120 ,P_COMM_RENUMERATION in number default null
121 ,P_COMM_EXPENSES in number default null
122 ,P_SPOUSE_OR_EQUIVALENT in varchar2 default null
123 ,P_DISABILITY_STATUS in varchar2 default null
124 ,P_NUMBER_OF_DEPENDENTS in number default null
125 ,P_NUMBER_OF_INFIRM_DEPENDENTS in number default null
126 ,P_STA_INFORMATION_CATEGORY in varchar2 default null
127 ,P_STA_INFORMATION1 in varchar2 default null
128 ,P_STA_INFORMATION2 in varchar2 default null
129 ,P_STA_INFORMATION3 in varchar2 default null
130 ,P_STA_INFORMATION4 in varchar2 default null
131 ,P_STA_INFORMATION5 in varchar2 default null
132 ,P_STA_INFORMATION6 in varchar2 default null
133 ,P_STA_INFORMATION7 in varchar2 default null
134 ,P_STA_INFORMATION8 in varchar2 default null
135 ,P_STA_INFORMATION9 in varchar2 default null
136 ,P_STA_INFORMATION10 in varchar2 default null
137 ,P_STA_INFORMATION11 in varchar2 default null
138 ,P_STA_INFORMATION12 in varchar2 default null
139 ,P_STA_INFORMATION13 in varchar2 default null
140 ,P_STA_INFORMATION14 in varchar2 default null
141 ,P_STA_INFORMATION15 in varchar2 default null
142 ,P_STA_INFORMATION16 in varchar2 default null
143 ,P_STA_INFORMATION17 in varchar2 default null
144 ,P_STA_INFORMATION18 in varchar2 default null
145 ,P_STA_INFORMATION19 in varchar2 default null
146 ,P_STA_INFORMATION20 in varchar2 default null
147 ,P_STA_INFORMATION21 in varchar2 default null
148 ,P_STA_INFORMATION22 in varchar2 default null
149 ,P_STA_INFORMATION23 in varchar2 default null
150 ,P_STA_INFORMATION24 in varchar2 default null
151 ,P_STA_INFORMATION25 in varchar2 default null
152 ,P_STA_INFORMATION26 in varchar2 default null
153 ,P_STA_INFORMATION27 in varchar2 default null
154 ,P_STA_INFORMATION28 in varchar2 default null
155 ,P_STA_INFORMATION29 in varchar2 default null
156 ,P_STA_INFORMATION30 in varchar2 default null
157 ,P_CA_TAX_INFORMATION_CATEGORY in varchar2 default null
158 ,P_CA_TAX_INFORMATION1 in varchar2 default null
159 ,P_CA_TAX_INFORMATION2 in varchar2 default null
160 ,P_CA_TAX_INFORMATION3 in varchar2 default null
161 ,P_CA_TAX_INFORMATION4 in varchar2 default null
162 ,P_CA_TAX_INFORMATION5 in varchar2 default null
163 ,P_CA_TAX_INFORMATION6 in varchar2 default null
164 ,P_CA_TAX_INFORMATION7 in varchar2 default null
165 ,P_CA_TAX_INFORMATION8 in varchar2 default null
166 ,P_CA_TAX_INFORMATION9 in varchar2 default null
167 ,P_CA_TAX_INFORMATION10 in varchar2 default null
168 ,P_CA_TAX_INFORMATION11 in varchar2 default null
169 ,P_CA_TAX_INFORMATION12 in varchar2 default null
170 ,P_CA_TAX_INFORMATION13 in varchar2 default null
171 ,P_CA_TAX_INFORMATION14 in varchar2 default null
172 ,P_CA_TAX_INFORMATION15 in varchar2 default null
173 ,P_CA_TAX_INFORMATION16 in varchar2 default null
174 ,P_CA_TAX_INFORMATION17 in varchar2 default null
175 ,P_CA_TAX_INFORMATION18 in varchar2 default null
176 ,P_CA_TAX_INFORMATION19 in varchar2 default null
177 ,P_CA_TAX_INFORMATION20 in varchar2 default null
178 ,P_CA_TAX_INFORMATION21 in varchar2 default null
179 ,P_CA_TAX_INFORMATION22 in varchar2 default null
180 ,P_CA_TAX_INFORMATION23 in varchar2 default null
181 ,P_CA_TAX_INFORMATION24 in varchar2 default null
182 ,P_CA_TAX_INFORMATION25 in varchar2 default null
183 ,P_CA_TAX_INFORMATION26 in varchar2 default null
184 ,P_CA_TAX_INFORMATION27 in varchar2 default null
185 ,P_CA_TAX_INFORMATION28 in varchar2 default null
186 ,P_CA_TAX_INFORMATION29 in varchar2 default null
187 ,P_CA_TAX_INFORMATION30 in varchar2 default null
188 ,P_ADDITIONAL_INFO1 in varchar2 default null
189 ,P_ADDITIONAL_INFO2 in varchar2 default null
190 ,P_ADDITIONAL_INFO3 in varchar2 default null
191 ,P_ADDITIONAL_INFO4 in varchar2 default null
192 ,P_ADDITIONAL_INFO5 in varchar2 default null
193 ,P_ADDITIONAL_INFO6 in number default null
194 ,P_ADDITIONAL_INFO7 in number default null
195 ,P_ADDITIONAL_INFO8 in number default null
196 ,P_ADDITIONAL_INFO9 in number default null
197 ,P_ADDITIONAL_INFO10 in number default null) is
198 blid number := p_data_pump_batch_line_id;
199 begin
200 if blid is not null then
201 delete from hr_pump_batch_lines where batch_line_id = blid;
202 delete from hr_pump_batch_exceptions
203 where source_type = 'BATCH_LINE' and source_id = blid;
204 end if;
205 insert into hr_pump_batch_lines
206 (batch_id
207 ,batch_line_id
208 ,business_group_name
209 ,api_module_id
210 ,line_status
211 ,user_sequence
212 ,link_value
213 ,pval001
214 ,pval002
215 ,pval003
216 ,pval004
217 ,pval005
218 ,pval006
219 ,pval007
220 ,pval008
221 ,pval009
222 ,pval010
223 ,pval011
224 ,pval012
225 ,pval013
226 ,pval014
227 ,pval015
228 ,pval016
229 ,pval017
230 ,pval018
231 ,pval019
232 ,pval020
233 ,pval021
234 ,pval022
235 ,pval023
236 ,pval024
237 ,pval025
238 ,pval026
239 ,pval027
240 ,pval028
241 ,pval029
242 ,pval030
243 ,pval031
244 ,pval032
245 ,pval033
246 ,pval034
247 ,pval035
248 ,pval036
249 ,pval037
250 ,pval038
251 ,pval039
252 ,pval040
253 ,pval041
254 ,pval042
255 ,pval043
256 ,pval044
257 ,pval045
258 ,pval046
259 ,pval047
260 ,pval048
261 ,pval049
262 ,pval050
263 ,pval051
264 ,pval052
265 ,pval053
266 ,pval054
267 ,pval055
268 ,pval056
269 ,pval057
270 ,pval058
271 ,pval059
272 ,pval060
273 ,pval061
274 ,pval062
275 ,pval063
276 ,pval064
277 ,pval065
278 ,pval066
279 ,pval067
280 ,pval068
281 ,pval069
282 ,pval070
283 ,pval071
284 ,pval072
285 ,pval073
286 ,pval074
287 ,pval075
288 ,pval076
289 ,pval077
290 ,pval078
291 ,pval079
292 ,pval080
293 ,pval081
294 ,pval082
295 ,pval083
296 ,pval084
297 ,pval085
298 ,pval086
299 ,pval087
300 ,pval088
301 ,pval089
302 ,pval090
303 ,pval091
304 ,pval092
305 ,pval093
306 ,pval094
307 ,pval095
308 ,pval096
309 ,pval097
310 ,pval098
311 ,pval099
312 ,pval100
313 ,pval101
314 ,pval102
315 ,pval103
316 ,pval104
317 ,pval105
318 ,pval106
319 ,pval107
320 ,pval108
321 ,pval109
322 ,pval110
323 ,pval111
324 ,pval112
325 ,pval113
326 ,pval114
327 ,pval115
328 ,pval116)
329 values
330 (p_batch_id
331 ,nvl(blid,hr_pump_batch_lines_s.nextval)
332 ,p_data_pump_business_grp_name
333 ,3848
334 ,'U'
335 ,p_user_sequence
336 ,p_link_value
337 ,P_BUSINESS_GROUP
338 ,dc(P_EFFECTIVE_DATE)
339 ,P_EMPLOYEE
340 ,P_ASSIGNMENT
341 ,P_LEGISLATION
342 ,P_SPREADSHEET_IDENTIFIER
343 ,P_SUI_STATE
344 ,P_STATE_PROV_CODE
345 ,P_COUNTY
346 ,P_CITY
347 ,P_OVERRIDE_PROV_OF_EMPLT
348 ,P_BASIC_AMT_FLAG
349 ,P_BASIC_AMT
350 ,P_TAX_CREDIT
351 ,P_FILING_STATUS_CODE
352 ,P_ALLOWANCES
353 ,P_ADDITIONAL_TAX
354 ,P_SECONDARY_ALLOWANCES
355 ,P_EXEMPTION_AMT
356 ,P_SIT_OPTIONAL_CALC_IND
357 ,P_ADDTL_ALLOWANCE_RATE
358 ,P_PRES_ZONE_DEDN
359 ,P_TAX_EXEMPT1
360 ,P_TAX_EXEMPT2
361 ,P_TAX_EXEMPT3
362 ,P_TAX_EXEMPT4
363 ,P_OVERRIDE_RATE
364 ,P_OVERRIDE_AMOUNT
365 ,P_OVERRIDE_SUPP_RATE
366 ,P_ANNUAL_DEDN
367 ,P_LABOR_FUND_CONTR
368 ,dc(P_ALLOWANCE_REJECT_DATE)
369 ,P_EIC_FILING_STATUS
370 ,P_STATUTORY_EMPLOYEE
371 ,P_CUMULATIVE_TAXATION
372 ,P_NON_RESIDENT
373 ,P_SUI_BASE_OVERRIDE_AMOUNT
374 ,P_SCHOOL_DISTRICT
375 ,P_COMM_RENUMERATION
376 ,P_COMM_EXPENSES
377 ,P_SPOUSE_OR_EQUIVALENT
378 ,P_DISABILITY_STATUS
379 ,P_NUMBER_OF_DEPENDENTS
380 ,P_NUMBER_OF_INFIRM_DEPENDENTS
381 ,P_STA_INFORMATION_CATEGORY
382 ,P_STA_INFORMATION1
383 ,P_STA_INFORMATION2
384 ,P_STA_INFORMATION3
385 ,P_STA_INFORMATION4
386 ,P_STA_INFORMATION5
387 ,P_STA_INFORMATION6
388 ,P_STA_INFORMATION7
389 ,P_STA_INFORMATION8
390 ,P_STA_INFORMATION9
391 ,P_STA_INFORMATION10
392 ,P_STA_INFORMATION11
393 ,P_STA_INFORMATION12
394 ,P_STA_INFORMATION13
395 ,P_STA_INFORMATION14
396 ,P_STA_INFORMATION15
397 ,P_STA_INFORMATION16
398 ,P_STA_INFORMATION17
399 ,P_STA_INFORMATION18
400 ,P_STA_INFORMATION19
401 ,P_STA_INFORMATION20
402 ,P_STA_INFORMATION21
403 ,P_STA_INFORMATION22
404 ,P_STA_INFORMATION23
405 ,P_STA_INFORMATION24
406 ,P_STA_INFORMATION25
407 ,P_STA_INFORMATION26
408 ,P_STA_INFORMATION27
409 ,P_STA_INFORMATION28
410 ,P_STA_INFORMATION29
411 ,P_STA_INFORMATION30
412 ,P_CA_TAX_INFORMATION_CATEGORY
413 ,P_CA_TAX_INFORMATION1
414 ,P_CA_TAX_INFORMATION2
415 ,P_CA_TAX_INFORMATION3
416 ,P_CA_TAX_INFORMATION4
417 ,P_CA_TAX_INFORMATION5
418 ,P_CA_TAX_INFORMATION6
419 ,P_CA_TAX_INFORMATION7
420 ,P_CA_TAX_INFORMATION8
421 ,P_CA_TAX_INFORMATION9
422 ,P_CA_TAX_INFORMATION10
423 ,P_CA_TAX_INFORMATION11
424 ,P_CA_TAX_INFORMATION12
425 ,P_CA_TAX_INFORMATION13
426 ,P_CA_TAX_INFORMATION14
427 ,P_CA_TAX_INFORMATION15
428 ,P_CA_TAX_INFORMATION16
429 ,P_CA_TAX_INFORMATION17
430 ,P_CA_TAX_INFORMATION18
431 ,P_CA_TAX_INFORMATION19
432 ,P_CA_TAX_INFORMATION20
433 ,P_CA_TAX_INFORMATION21
434 ,P_CA_TAX_INFORMATION22
435 ,P_CA_TAX_INFORMATION23
436 ,P_CA_TAX_INFORMATION24
437 ,P_CA_TAX_INFORMATION25
438 ,P_CA_TAX_INFORMATION26
439 ,P_CA_TAX_INFORMATION27
440 ,P_CA_TAX_INFORMATION28
441 ,P_CA_TAX_INFORMATION29
442 ,P_CA_TAX_INFORMATION30
443 ,P_ADDITIONAL_INFO1
444 ,P_ADDITIONAL_INFO2
445 ,P_ADDITIONAL_INFO3
446 ,P_ADDITIONAL_INFO4
447 ,P_ADDITIONAL_INFO5
448 ,P_ADDITIONAL_INFO6
449 ,P_ADDITIONAL_INFO7
450 ,P_ADDITIONAL_INFO8
451 ,P_ADDITIONAL_INFO9
452 ,P_ADDITIONAL_INFO10);
453 end insert_batch_lines;
454 --
455 procedure call
456 (p_business_group_id in number,
457 p_batch_line_id     in number) is
458 cursor cr is
459 select l.rowid myrowid,
463 l.pval002 d2,
460 decode(l.pval001,cn,nn,vn,nn,n(l.pval001)) p1,
461 l.pval001 d1,
462 decode(l.pval002,cn,dn,vn,dn,d(l.pval002)) p2,
464 decode(l.pval003,cn,vn,vn,vn,l.pval003) p3,
465 l.pval003 d3,
466 decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
467 l.pval004 d4,
468 decode(l.pval005,cn,vn,vn,vn,l.pval005) p5,
469 l.pval005 d5,
470 decode(l.pval006,cn,vn,vn,vn,l.pval006) p6,
471 l.pval006 d6,
472 decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
473 l.pval007 d7,
474 decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
475 l.pval008 d8,
476 decode(l.pval009,cn,vn,vn,vn,l.pval009) p9,
477 l.pval009 d9,
478 decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
479 l.pval010 d10,
480 decode(l.pval011,cn,vn,vn,vn,l.pval011) p11,
481 l.pval011 d11,
482 decode(l.pval012,cn,vn,vn,vn,
483  hr_pump_get.gl(l.pval012,'YES_NO',d(l.pval002),vn)) p12,
484 l.pval012 d12,
485 decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
486 l.pval013 d13,
487 decode(l.pval014,cn,nn,vn,nn,n(l.pval014)) p14,
488 l.pval014 d14,
489 decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,
490 l.pval015 d15,
491 decode(l.pval016,cn,nn,vn,nn,n(l.pval016)) p16,
492 l.pval016 d16,
493 decode(l.pval017,cn,nn,vn,nn,n(l.pval017)) p17,
494 l.pval017 d17,
495 decode(l.pval018,cn,nn,vn,nn,n(l.pval018)) p18,
496 l.pval018 d18,
497 decode(l.pval019,cn,nn,vn,nn,n(l.pval019)) p19,
498 l.pval019 d19,
499 decode(l.pval020,cn,vn,vn,vn,l.pval020) p20,
500 l.pval020 d20,
501 decode(l.pval021,cn,nn,vn,nn,n(l.pval021)) p21,
502 l.pval021 d21,
503 decode(l.pval022,cn,nn,vn,nn,n(l.pval022)) p22,
504 l.pval022 d22,
505 decode(l.pval023,cn,vn,vn,vn,
506  hr_pump_get.gl(l.pval023,'YES_NO',d(l.pval002),vn)) p23,
507 l.pval023 d23,
508 decode(l.pval024,cn,vn,vn,vn,
509  hr_pump_get.gl(l.pval024,'YES_NO',d(l.pval002),vn)) p24,
510 l.pval024 d24,
511 decode(l.pval025,cn,vn,vn,vn,
512  hr_pump_get.gl(l.pval025,'YES_NO',d(l.pval002),vn)) p25,
513 l.pval025 d25,
514 decode(l.pval026,cn,vn,vn,vn,
515  hr_pump_get.gl(l.pval026,'YES_NO',d(l.pval002),vn)) p26,
516 l.pval026 d26,
517 decode(l.pval027,cn,nn,vn,nn,n(l.pval027)) p27,
518 l.pval027 d27,
519 decode(l.pval028,cn,nn,vn,nn,n(l.pval028)) p28,
520 l.pval028 d28,
521 decode(l.pval029,cn,nn,vn,nn,n(l.pval029)) p29,
522 l.pval029 d29,
523 decode(l.pval030,cn,nn,vn,nn,n(l.pval030)) p30,
524 l.pval030 d30,
525 decode(l.pval031,cn,nn,vn,nn,n(l.pval031)) p31,
526 l.pval031 d31,
527 decode(l.pval032,cn,dn,vn,dn,d(l.pval032)) p32,
528 l.pval032 d32,
529 decode(l.pval033,cn,vn,vn,vn,l.pval033) p33,
530 l.pval033 d33,
531 decode(l.pval034,cn,vn,vn,vn,
532  hr_pump_get.gl(l.pval034,'YES_NO',d(l.pval002),vn)) p34,
533 l.pval034 d34,
534 decode(l.pval035,cn,vn,vn,vn,
535  hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval002),vn)) p35,
536 l.pval035 d35,
537 decode(l.pval036,cn,vn,vn,vn,
538  hr_pump_get.gl(l.pval036,'YES_NO',d(l.pval002),vn)) p36,
539 l.pval036 d36,
540 decode(l.pval037,cn,nn,vn,nn,n(l.pval037)) p37,
541 l.pval037 d37,
542 decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
543 l.pval038 d38,
544 decode(l.pval039,cn,nn,vn,nn,n(l.pval039)) p39,
545 l.pval039 d39,
546 decode(l.pval040,cn,nn,vn,nn,n(l.pval040)) p40,
547 l.pval040 d40,
548 decode(l.pval041,cn,vn,vn,vn,
549  hr_pump_get.gl(l.pval041,'YES_NO',d(l.pval002),vn)) p41,
550 l.pval041 d41,
551 decode(l.pval042,cn,vn,vn,vn,
552  hr_pump_get.gl(l.pval042,'YES_NO',d(l.pval002),vn)) p42,
553 l.pval042 d42,
554 decode(l.pval043,cn,nn,vn,nn,n(l.pval043)) p43,
555 l.pval043 d43,
556 decode(l.pval044,cn,nn,vn,nn,n(l.pval044)) p44,
557 l.pval044 d44,
558 decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
559 l.pval045 d45,
560 decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
561 l.pval046 d46,
562 decode(l.pval047,cn,vn,vn,vn,l.pval047) p47,
563 l.pval047 d47,
564 decode(l.pval048,cn,vn,vn,vn,l.pval048) p48,
565 l.pval048 d48,
566 decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
567 l.pval049 d49,
568 decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
569 l.pval050 d50,
570 decode(l.pval051,cn,vn,vn,vn,l.pval051) p51,
571 l.pval051 d51,
572 decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,
573 l.pval052 d52,
574 decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
575 l.pval053 d53,
576 decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
577 l.pval054 d54,
578 decode(l.pval055,cn,vn,vn,vn,l.pval055) p55,
579 l.pval055 d55,
580 decode(l.pval056,cn,vn,vn,vn,l.pval056) p56,
581 l.pval056 d56,
582 decode(l.pval057,cn,vn,vn,vn,l.pval057) p57,
583 l.pval057 d57,
584 decode(l.pval058,cn,vn,vn,vn,l.pval058) p58,
585 l.pval058 d58,
586 decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,
587 l.pval059 d59,
588 decode(l.pval060,cn,vn,vn,vn,l.pval060) p60,
589 l.pval060 d60,
590 decode(l.pval061,cn,vn,vn,vn,l.pval061) p61,
591 l.pval061 d61,
592 decode(l.pval062,cn,vn,vn,vn,l.pval062) p62,
593 l.pval062 d62,
594 decode(l.pval063,cn,vn,vn,vn,l.pval063) p63,
595 l.pval063 d63,
596 decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
597 l.pval064 d64,
598 decode(l.pval065,cn,vn,vn,vn,l.pval065) p65,
599 l.pval065 d65,
600 decode(l.pval066,cn,vn,vn,vn,l.pval066) p66,
601 l.pval066 d66,
602 decode(l.pval067,cn,vn,vn,vn,l.pval067) p67,
603 l.pval067 d67,
604 decode(l.pval068,cn,vn,vn,vn,l.pval068) p68,
605 l.pval068 d68,
606 decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
607 l.pval069 d69,
608 decode(l.pval070,cn,vn,vn,vn,l.pval070) p70,
609 l.pval070 d70,
610 decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
611 l.pval071 d71,
612 decode(l.pval072,cn,vn,vn,vn,l.pval072) p72,
613 l.pval072 d72,
614 decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
615 l.pval073 d73,
616 decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
617 l.pval074 d74,
618 decode(l.pval075,cn,vn,vn,vn,l.pval075) p75,
619 l.pval075 d75,
620 decode(l.pval076,cn,vn,vn,vn,l.pval076) p76,
621 l.pval076 d76,
622 decode(l.pval077,cn,vn,vn,vn,l.pval077) p77,
623 l.pval077 d77,
624 decode(l.pval078,cn,vn,vn,vn,l.pval078) p78,
625 l.pval078 d78,
626 decode(l.pval079,cn,vn,vn,vn,l.pval079) p79,
627 l.pval079 d79,
628 decode(l.pval080,cn,vn,vn,vn,l.pval080) p80,
629 l.pval080 d80,
630 decode(l.pval081,cn,vn,vn,vn,l.pval081) p81,
631 l.pval081 d81,
632 decode(l.pval082,cn,vn,vn,vn,l.pval082) p82,
633 l.pval082 d82,
634 decode(l.pval083,cn,vn,vn,vn,l.pval083) p83,
635 l.pval083 d83,
636 decode(l.pval084,cn,vn,vn,vn,l.pval084) p84,
637 l.pval084 d84,
638 decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,
639 l.pval085 d85,
640 decode(l.pval086,cn,vn,vn,vn,l.pval086) p86,
641 l.pval086 d86,
642 decode(l.pval087,cn,vn,vn,vn,l.pval087) p87,
643 l.pval087 d87,
644 decode(l.pval088,cn,vn,vn,vn,l.pval088) p88,
645 l.pval088 d88,
646 decode(l.pval089,cn,vn,vn,vn,l.pval089) p89,
647 l.pval089 d89,
648 decode(l.pval090,cn,vn,vn,vn,l.pval090) p90,
649 l.pval090 d90,
650 decode(l.pval091,cn,vn,vn,vn,l.pval091) p91,
651 l.pval091 d91,
652 decode(l.pval092,cn,vn,vn,vn,l.pval092) p92,
653 l.pval092 d92,
654 decode(l.pval093,cn,vn,vn,vn,l.pval093) p93,
655 l.pval093 d93,
656 decode(l.pval094,cn,vn,vn,vn,l.pval094) p94,
657 l.pval094 d94,
658 decode(l.pval095,cn,vn,vn,vn,l.pval095) p95,
659 l.pval095 d95,
660 decode(l.pval096,cn,vn,vn,vn,l.pval096) p96,
661 l.pval096 d96,
662 decode(l.pval097,cn,vn,vn,vn,l.pval097) p97,
663 l.pval097 d97,
664 decode(l.pval098,cn,vn,vn,vn,l.pval098) p98,
665 l.pval098 d98,
666 decode(l.pval099,cn,vn,vn,vn,l.pval099) p99,
667 l.pval099 d99,
668 decode(l.pval100,cn,vn,vn,vn,l.pval100) p100,
669 l.pval100 d100,
670 decode(l.pval101,cn,vn,vn,vn,l.pval101) p101,
671 l.pval101 d101,
672 decode(l.pval102,cn,vn,vn,vn,l.pval102) p102,
673 l.pval102 d102,
674 decode(l.pval103,cn,vn,vn,vn,l.pval103) p103,
675 l.pval103 d103,
676 decode(l.pval104,cn,vn,vn,vn,l.pval104) p104,
677 l.pval104 d104,
678 decode(l.pval105,cn,vn,vn,vn,l.pval105) p105,
679 l.pval105 d105,
680 decode(l.pval106,cn,vn,vn,vn,l.pval106) p106,
681 l.pval106 d106,
682 decode(l.pval107,cn,vn,vn,vn,l.pval107) p107,
683 l.pval107 d107,
684 decode(l.pval108,cn,vn,vn,vn,l.pval108) p108,
685 l.pval108 d108,
686 decode(l.pval109,cn,vn,vn,vn,l.pval109) p109,
687 l.pval109 d109,
688 decode(l.pval110,cn,vn,vn,vn,l.pval110) p110,
689 l.pval110 d110,
690 decode(l.pval111,cn,vn,vn,vn,l.pval111) p111,
691 l.pval111 d111,
692 decode(l.pval112,cn,nn,vn,nn,n(l.pval112)) p112,
693 l.pval112 d112,
694 decode(l.pval113,cn,nn,vn,nn,n(l.pval113)) p113,
695 l.pval113 d113,
696 decode(l.pval114,cn,nn,vn,nn,n(l.pval114)) p114,
697 l.pval114 d114,
701 l.pval116 d116
698 decode(l.pval115,cn,nn,vn,nn,n(l.pval115)) p115,
699 l.pval115 d115,
700 decode(l.pval116,cn,nn,vn,nn,n(l.pval116)) p116,
702 from hr_pump_batch_lines l
703 where l.batch_line_id = p_batch_line_id;
704 --
705 c cr%rowtype;
706 l_validate boolean := false;
707 --
708 begin
709 hr_data_pump.entry('call');
710 open cr;
711 fetch cr into c;
712 if cr%notfound then
713 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
714 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
715 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
716 hr_utility.set_message_token('VALUE',p_batch_line_id);
717 hr_utility.raise_error;
718 end if;
719 --
720 hr_data_pump.api_trc_on;
721 PAY_RI_AC_TAX_RULE.CREATE_AC_EMPTAXRULE
722 (P_BUSINESS_GROUP => c.p1
723 ,P_EFFECTIVE_DATE => c.p2
724 ,P_EMPLOYEE => c.p3
725 ,P_ASSIGNMENT => c.p4
726 ,P_LEGISLATION => c.p5
727 ,P_SPREADSHEET_IDENTIFIER => c.p6
728 ,P_SUI_STATE => c.p7
729 ,P_STATE_PROV_CODE => c.p8
730 ,P_COUNTY => c.p9
731 ,P_CITY => c.p10
732 ,P_OVERRIDE_PROV_OF_EMPLT => c.p11
733 ,P_BASIC_AMT_FLAG => c.p12
734 ,P_BASIC_AMT => c.p13
735 ,P_TAX_CREDIT => c.p14
736 ,P_FILING_STATUS_CODE => c.p15
737 ,P_ALLOWANCES => c.p16
738 ,P_ADDITIONAL_TAX => c.p17
739 ,P_SECONDARY_ALLOWANCES => c.p18
740 ,P_EXEMPTION_AMT => c.p19
741 ,P_SIT_OPTIONAL_CALC_IND => c.p20
742 ,P_ADDTL_ALLOWANCE_RATE => c.p21
743 ,P_PRES_ZONE_DEDN => c.p22
744 ,P_TAX_EXEMPT1 => c.p23
745 ,P_TAX_EXEMPT2 => c.p24
746 ,P_TAX_EXEMPT3 => c.p25
747 ,P_TAX_EXEMPT4 => c.p26
748 ,P_OVERRIDE_RATE => c.p27
749 ,P_OVERRIDE_AMOUNT => c.p28
750 ,P_OVERRIDE_SUPP_RATE => c.p29
751 ,P_ANNUAL_DEDN => c.p30
752 ,P_LABOR_FUND_CONTR => c.p31
753 ,P_ALLOWANCE_REJECT_DATE => c.p32
754 ,P_EIC_FILING_STATUS => c.p33
755 ,P_STATUTORY_EMPLOYEE => c.p34
756 ,P_CUMULATIVE_TAXATION => c.p35
757 ,P_NON_RESIDENT => c.p36
758 ,P_SUI_BASE_OVERRIDE_AMOUNT => c.p37
759 ,P_SCHOOL_DISTRICT => c.p38
760 ,P_COMM_RENUMERATION => c.p39
761 ,P_COMM_EXPENSES => c.p40
762 ,P_SPOUSE_OR_EQUIVALENT => c.p41
763 ,P_DISABILITY_STATUS => c.p42
764 ,P_NUMBER_OF_DEPENDENTS => c.p43
765 ,P_NUMBER_OF_INFIRM_DEPENDENTS => c.p44
766 ,P_STA_INFORMATION_CATEGORY => c.p45
767 ,P_STA_INFORMATION1 => c.p46
768 ,P_STA_INFORMATION2 => c.p47
769 ,P_STA_INFORMATION3 => c.p48
770 ,P_STA_INFORMATION4 => c.p49
771 ,P_STA_INFORMATION5 => c.p50
772 ,P_STA_INFORMATION6 => c.p51
773 ,P_STA_INFORMATION7 => c.p52
774 ,P_STA_INFORMATION8 => c.p53
775 ,P_STA_INFORMATION9 => c.p54
776 ,P_STA_INFORMATION10 => c.p55
777 ,P_STA_INFORMATION11 => c.p56
778 ,P_STA_INFORMATION12 => c.p57
779 ,P_STA_INFORMATION13 => c.p58
780 ,P_STA_INFORMATION14 => c.p59
781 ,P_STA_INFORMATION15 => c.p60
782 ,P_STA_INFORMATION16 => c.p61
783 ,P_STA_INFORMATION17 => c.p62
784 ,P_STA_INFORMATION18 => c.p63
785 ,P_STA_INFORMATION19 => c.p64
786 ,P_STA_INFORMATION20 => c.p65
787 ,P_STA_INFORMATION21 => c.p66
788 ,P_STA_INFORMATION22 => c.p67
789 ,P_STA_INFORMATION23 => c.p68
790 ,P_STA_INFORMATION24 => c.p69
791 ,P_STA_INFORMATION25 => c.p70
792 ,P_STA_INFORMATION26 => c.p71
793 ,P_STA_INFORMATION27 => c.p72
794 ,P_STA_INFORMATION28 => c.p73
795 ,P_STA_INFORMATION29 => c.p74
796 ,P_STA_INFORMATION30 => c.p75
797 ,P_CA_TAX_INFORMATION_CATEGORY => c.p76
798 ,P_CA_TAX_INFORMATION1 => c.p77
799 ,P_CA_TAX_INFORMATION2 => c.p78
800 ,P_CA_TAX_INFORMATION3 => c.p79
801 ,P_CA_TAX_INFORMATION4 => c.p80
802 ,P_CA_TAX_INFORMATION5 => c.p81
803 ,P_CA_TAX_INFORMATION6 => c.p82
804 ,P_CA_TAX_INFORMATION7 => c.p83
805 ,P_CA_TAX_INFORMATION8 => c.p84
806 ,P_CA_TAX_INFORMATION9 => c.p85
807 ,P_CA_TAX_INFORMATION10 => c.p86
808 ,P_CA_TAX_INFORMATION11 => c.p87
809 ,P_CA_TAX_INFORMATION12 => c.p88
810 ,P_CA_TAX_INFORMATION13 => c.p89
811 ,P_CA_TAX_INFORMATION14 => c.p90
812 ,P_CA_TAX_INFORMATION15 => c.p91
813 ,P_CA_TAX_INFORMATION16 => c.p92
814 ,P_CA_TAX_INFORMATION17 => c.p93
815 ,P_CA_TAX_INFORMATION18 => c.p94
816 ,P_CA_TAX_INFORMATION19 => c.p95
817 ,P_CA_TAX_INFORMATION20 => c.p96
818 ,P_CA_TAX_INFORMATION21 => c.p97
819 ,P_CA_TAX_INFORMATION22 => c.p98
820 ,P_CA_TAX_INFORMATION23 => c.p99
821 ,P_CA_TAX_INFORMATION24 => c.p100
822 ,P_CA_TAX_INFORMATION25 => c.p101
823 ,P_CA_TAX_INFORMATION26 => c.p102
824 ,P_CA_TAX_INFORMATION27 => c.p103
825 ,P_CA_TAX_INFORMATION28 => c.p104
826 ,P_CA_TAX_INFORMATION29 => c.p105
827 ,P_CA_TAX_INFORMATION30 => c.p106
828 ,P_ADDITIONAL_INFO1 => c.p107
829 ,P_ADDITIONAL_INFO2 => c.p108
830 ,P_ADDITIONAL_INFO3 => c.p109
831 ,P_ADDITIONAL_INFO4 => c.p110
832 ,P_ADDITIONAL_INFO5 => c.p111
833 ,P_ADDITIONAL_INFO6 => c.p112
834 ,P_ADDITIONAL_INFO7 => c.p113
835 ,P_ADDITIONAL_INFO8 => c.p114
836 ,P_ADDITIONAL_INFO9 => c.p115
837 ,P_ADDITIONAL_INFO10 => c.p116);
838 hr_data_pump.api_trc_off;
839 
840 --
841 
842 --
843 close cr;
844 --
845 hr_data_pump.exit('call');
846 exception
847  when hr_multi_message.error_message_exist then
848    if cr%isopen then
849     close cr;
850    end if;
851    hr_pump_utils.set_multi_msg_error_flag(true);
852  when others then
853  if cr%isopen then
854   close cr;
855  end if;
856  raise;
857 end call;
858 end hrdpp_CREATE_AC_EMPTAXRULE;