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_CA_EMP_PRVTAX_INF

Source


1 package body hrdpp_CREATE_CA_EMP_PRVTAX_INF as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2007/01/03 23:01:37
4  * Generated for API: PAY_CA_EMP_PRVTAX_INF_API.CREATE_CA_EMP_PRVTAX_INF
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_PROV_TAX_INF_USER_KEY in varchar2
83 ,P_LEGISLATION_CODE in varchar2 default null
84 ,P_ASSIGNMENT_ID in number default null
85 ,P_PROVINCE_CODE in varchar2 default null
86 ,P_JURISDICTION_CODE in varchar2 default null
87 ,P_TAX_CREDIT_AMOUNT in number default null
88 ,P_BASIC_EXEMPTION_FLAG in varchar2 default null
89 ,P_DEDUCTION_CODE in varchar2 default null
90 ,P_EXTRA_INFO_NOT_PROVIDED in varchar2 default null
91 ,P_MARRIAGE_STATUS in varchar2 default null
92 ,P_NO_OF_INFIRM_DEPENDANTS in number default null
93 ,P_NON_RESIDENT_STATUS in varchar2 default null
94 ,P_DISABILITY_STATUS in varchar2 default null
95 ,P_NO_OF_DEPENDANTS in number default null
96 ,P_ANNUAL_DEDN in number default null
97 ,P_TOTAL_EXPENSE_BY_COMMISSION in number default null
98 ,P_TOTAL_REMNRTN_BY_COMMISSION in number default null
99 ,P_PRESCRIBED_ZONE_DEDN_AMT in number default null
100 ,P_ADDITIONAL_TAX in number default null
101 ,P_PROV_OVERRIDE_RATE in number default null
102 ,P_PROV_OVERRIDE_AMOUNT in number default null
103 ,P_PROV_EXEMPT_FLAG in varchar2 default null
104 ,P_PMED_EXEMPT_FLAG in varchar2 default null
105 ,P_WC_EXEMPT_FLAG in varchar2 default null
106 ,P_QPP_EXEMPT_FLAG in varchar2 default null
107 ,P_TAX_CALC_METHOD in varchar2 default null
108 ,P_OTHER_TAX_CREDIT in number default null
109 ,P_CA_TAX_INFORMATION_CATEGORY in varchar2 default null
110 ,P_CA_TAX_INFORMATION1 in varchar2 default null
111 ,P_CA_TAX_INFORMATION2 in varchar2 default null
112 ,P_CA_TAX_INFORMATION3 in varchar2 default null
113 ,P_CA_TAX_INFORMATION4 in varchar2 default null
114 ,P_CA_TAX_INFORMATION5 in varchar2 default null
115 ,P_CA_TAX_INFORMATION6 in varchar2 default null
116 ,P_CA_TAX_INFORMATION7 in varchar2 default null
117 ,P_CA_TAX_INFORMATION8 in varchar2 default null
118 ,P_CA_TAX_INFORMATION9 in varchar2 default null
119 ,P_CA_TAX_INFORMATION10 in varchar2 default null
120 ,P_CA_TAX_INFORMATION11 in varchar2 default null
121 ,P_CA_TAX_INFORMATION12 in varchar2 default null
122 ,P_CA_TAX_INFORMATION13 in varchar2 default null
123 ,P_CA_TAX_INFORMATION14 in varchar2 default null
124 ,P_CA_TAX_INFORMATION15 in varchar2 default null
125 ,P_CA_TAX_INFORMATION16 in varchar2 default null
126 ,P_CA_TAX_INFORMATION17 in varchar2 default null
127 ,P_CA_TAX_INFORMATION18 in varchar2 default null
128 ,P_CA_TAX_INFORMATION19 in varchar2 default null
129 ,P_CA_TAX_INFORMATION20 in varchar2 default null
130 ,P_CA_TAX_INFORMATION21 in varchar2 default null
131 ,P_CA_TAX_INFORMATION22 in varchar2 default null
132 ,P_CA_TAX_INFORMATION23 in varchar2 default null
133 ,P_CA_TAX_INFORMATION24 in varchar2 default null
134 ,P_CA_TAX_INFORMATION25 in varchar2 default null
135 ,P_CA_TAX_INFORMATION26 in varchar2 default null
136 ,P_CA_TAX_INFORMATION27 in varchar2 default null
137 ,P_CA_TAX_INFORMATION28 in varchar2 default null
138 ,P_CA_TAX_INFORMATION29 in varchar2 default null
139 ,P_CA_TAX_INFORMATION30 in varchar2 default null
140 ,P_PROV_LSP_AMOUNT in number default null
141 ,P_EFFECTIVE_DATE in date
142 ,P_PPIP_EXEMPT_FLAG in varchar2 default null) is
143 blid number := p_data_pump_batch_line_id;
144 begin
145 if blid is not null then
146 delete from hr_pump_batch_lines where batch_line_id = blid;
147 delete from hr_pump_batch_exceptions
148 where source_type = 'BATCH_LINE' and source_id = blid;
149 end if;
150 insert into hr_pump_batch_lines
151 (batch_id
152 ,batch_line_id
153 ,business_group_name
154 ,api_module_id
155 ,line_status
156 ,user_sequence
157 ,link_value
158 ,pval001
159 ,pval004
160 ,pval005
161 ,pval006
162 ,pval007
163 ,pval008
164 ,pval009
165 ,pval010
166 ,pval011
167 ,pval012
168 ,pval013
169 ,pval014
170 ,pval015
171 ,pval016
172 ,pval017
173 ,pval018
174 ,pval019
175 ,pval020
176 ,pval021
177 ,pval022
178 ,pval023
179 ,pval024
180 ,pval025
181 ,pval026
182 ,pval027
183 ,pval028
184 ,pval029
185 ,pval030
186 ,pval031
187 ,pval032
188 ,pval033
189 ,pval034
190 ,pval035
191 ,pval036
192 ,pval037
193 ,pval038
194 ,pval039
195 ,pval040
196 ,pval041
197 ,pval042
198 ,pval043
199 ,pval044
200 ,pval045
201 ,pval046
202 ,pval047
203 ,pval048
204 ,pval049
205 ,pval050
206 ,pval051
207 ,pval052
208 ,pval053
209 ,pval054
210 ,pval055
211 ,pval056
212 ,pval057
213 ,pval058
214 ,pval059
215 ,pval060
216 ,pval062
217 ,pval063
218 ,pval064)
219 values
220 (p_batch_id
221 ,nvl(blid,hr_pump_batch_lines_s.nextval)
222 ,p_data_pump_business_grp_name
223 ,1155
224 ,'U'
225 ,p_user_sequence
226 ,p_link_value
227 ,P_EMP_PROV_TAX_INF_USER_KEY
228 ,P_LEGISLATION_CODE
229 ,P_ASSIGNMENT_ID
230 ,P_PROVINCE_CODE
231 ,P_JURISDICTION_CODE
232 ,P_TAX_CREDIT_AMOUNT
233 ,P_BASIC_EXEMPTION_FLAG
234 ,P_DEDUCTION_CODE
235 ,P_EXTRA_INFO_NOT_PROVIDED
236 ,P_MARRIAGE_STATUS
237 ,P_NO_OF_INFIRM_DEPENDANTS
238 ,P_NON_RESIDENT_STATUS
239 ,P_DISABILITY_STATUS
240 ,P_NO_OF_DEPENDANTS
241 ,P_ANNUAL_DEDN
242 ,P_TOTAL_EXPENSE_BY_COMMISSION
243 ,P_TOTAL_REMNRTN_BY_COMMISSION
244 ,P_PRESCRIBED_ZONE_DEDN_AMT
245 ,P_ADDITIONAL_TAX
246 ,P_PROV_OVERRIDE_RATE
247 ,P_PROV_OVERRIDE_AMOUNT
248 ,P_PROV_EXEMPT_FLAG
249 ,P_PMED_EXEMPT_FLAG
250 ,P_WC_EXEMPT_FLAG
251 ,P_QPP_EXEMPT_FLAG
252 ,P_TAX_CALC_METHOD
253 ,P_OTHER_TAX_CREDIT
254 ,P_CA_TAX_INFORMATION_CATEGORY
255 ,P_CA_TAX_INFORMATION1
256 ,P_CA_TAX_INFORMATION2
257 ,P_CA_TAX_INFORMATION3
258 ,P_CA_TAX_INFORMATION4
259 ,P_CA_TAX_INFORMATION5
260 ,P_CA_TAX_INFORMATION6
261 ,P_CA_TAX_INFORMATION7
262 ,P_CA_TAX_INFORMATION8
263 ,P_CA_TAX_INFORMATION9
264 ,P_CA_TAX_INFORMATION10
265 ,P_CA_TAX_INFORMATION11
266 ,P_CA_TAX_INFORMATION12
267 ,P_CA_TAX_INFORMATION13
268 ,P_CA_TAX_INFORMATION14
269 ,P_CA_TAX_INFORMATION15
270 ,P_CA_TAX_INFORMATION16
271 ,P_CA_TAX_INFORMATION17
272 ,P_CA_TAX_INFORMATION18
273 ,P_CA_TAX_INFORMATION19
274 ,P_CA_TAX_INFORMATION20
275 ,P_CA_TAX_INFORMATION21
276 ,P_CA_TAX_INFORMATION22
277 ,P_CA_TAX_INFORMATION23
278 ,P_CA_TAX_INFORMATION24
279 ,P_CA_TAX_INFORMATION25
280 ,P_CA_TAX_INFORMATION26
281 ,P_CA_TAX_INFORMATION27
282 ,P_CA_TAX_INFORMATION28
283 ,P_CA_TAX_INFORMATION29
284 ,P_CA_TAX_INFORMATION30
285 ,P_PROV_LSP_AMOUNT
286 ,dc(P_EFFECTIVE_DATE)
287 ,P_PPIP_EXEMPT_FLAG);
288 end insert_batch_lines;
289 --
290 procedure call
291 (p_business_group_id in number,
292 p_batch_line_id     in number) is
293 cursor cr is
294 select l.rowid myrowid,
295 l.pval001 p1,
296 decode(l.pval002,cn,dn,d(l.pval002)) p2,
297 decode(l.pval003,cn,dn,d(l.pval003)) p3,
298 decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
299 l.pval004 d4,
300 decode(l.pval005,cn,nn,vn,nn,n(l.pval005)) p5,
301 l.pval005 d5,
302 decode(l.pval006,cn,vn,vn,vn,l.pval006) p6,
303 l.pval006 d6,
304 decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
305 l.pval007 d7,
306 decode(l.pval008,cn,nn,vn,nn,n(l.pval008)) p8,
307 l.pval008 d8,
308 decode(l.pval009,cn,vn,vn,vn,l.pval009) p9,
309 l.pval009 d9,
310 decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
311 l.pval010 d10,
312 decode(l.pval011,cn,vn,vn,vn,l.pval011) p11,
313 l.pval011 d11,
314 decode(l.pval012,cn,vn,vn,vn,
315  hr_pump_get.gl(l.pval012,'YES_NO',d(l.pval063),vn)) p12,
316 l.pval012 d12,
317 decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
318 l.pval013 d13,
319 decode(l.pval014,cn,vn,vn,vn,
320  hr_pump_get.gl(l.pval014,'YES_NO',d(l.pval063),vn)) p14,
321 l.pval014 d14,
322 decode(l.pval015,cn,vn,vn,vn,
323  hr_pump_get.gl(l.pval015,'YES_NO',d(l.pval063),vn)) p15,
324 l.pval015 d15,
325 decode(l.pval016,cn,nn,vn,nn,n(l.pval016)) p16,
326 l.pval016 d16,
327 decode(l.pval017,cn,nn,vn,nn,n(l.pval017)) p17,
328 l.pval017 d17,
329 decode(l.pval018,cn,nn,vn,nn,n(l.pval018)) p18,
330 l.pval018 d18,
331 decode(l.pval019,cn,nn,vn,nn,n(l.pval019)) p19,
332 l.pval019 d19,
333 decode(l.pval020,cn,nn,vn,nn,n(l.pval020)) p20,
334 l.pval020 d20,
335 decode(l.pval021,cn,nn,vn,nn,n(l.pval021)) p21,
336 l.pval021 d21,
337 decode(l.pval022,cn,nn,vn,nn,n(l.pval022)) p22,
338 l.pval022 d22,
339 decode(l.pval023,cn,nn,vn,nn,n(l.pval023)) p23,
340 l.pval023 d23,
341 decode(l.pval024,cn,vn,vn,vn,
342  hr_pump_get.gl(l.pval024,'YES_NO',d(l.pval063),vn)) p24,
343 l.pval024 d24,
344 decode(l.pval025,cn,vn,vn,vn,
345  hr_pump_get.gl(l.pval025,'YES_NO',d(l.pval063),vn)) p25,
346 l.pval025 d25,
347 decode(l.pval026,cn,vn,vn,vn,
348  hr_pump_get.gl(l.pval026,'YES_NO',d(l.pval063),vn)) p26,
349 l.pval026 d26,
350 decode(l.pval027,cn,vn,vn,vn,
351  hr_pump_get.gl(l.pval027,'YES_NO',d(l.pval063),vn)) p27,
352 l.pval027 d27,
353 decode(l.pval028,cn,vn,vn,vn,l.pval028) p28,
354 l.pval028 d28,
355 decode(l.pval029,cn,nn,vn,nn,n(l.pval029)) p29,
356 l.pval029 d29,
357 decode(l.pval030,cn,vn,vn,vn,l.pval030) p30,
358 l.pval030 d30,
359 decode(l.pval031,cn,vn,vn,vn,l.pval031) p31,
360 l.pval031 d31,
361 decode(l.pval032,cn,vn,vn,vn,l.pval032) p32,
362 l.pval032 d32,
363 decode(l.pval033,cn,vn,vn,vn,l.pval033) p33,
364 l.pval033 d33,
365 decode(l.pval034,cn,vn,vn,vn,l.pval034) p34,
366 l.pval034 d34,
367 decode(l.pval035,cn,vn,vn,vn,l.pval035) p35,
368 l.pval035 d35,
369 decode(l.pval036,cn,vn,vn,vn,l.pval036) p36,
370 l.pval036 d36,
371 decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
372 l.pval037 d37,
373 decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
374 l.pval038 d38,
375 decode(l.pval039,cn,vn,vn,vn,l.pval039) p39,
376 l.pval039 d39,
377 decode(l.pval040,cn,vn,vn,vn,l.pval040) p40,
378 l.pval040 d40,
379 decode(l.pval041,cn,vn,vn,vn,l.pval041) p41,
380 l.pval041 d41,
381 decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
382 l.pval042 d42,
383 decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
384 l.pval043 d43,
385 decode(l.pval044,cn,vn,vn,vn,l.pval044) p44,
386 l.pval044 d44,
387 decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
388 l.pval045 d45,
389 decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
390 l.pval046 d46,
391 decode(l.pval047,cn,vn,vn,vn,l.pval047) p47,
392 l.pval047 d47,
393 decode(l.pval048,cn,vn,vn,vn,l.pval048) p48,
394 l.pval048 d48,
395 decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
396 l.pval049 d49,
397 decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
398 l.pval050 d50,
399 decode(l.pval051,cn,vn,vn,vn,l.pval051) p51,
400 l.pval051 d51,
401 decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,
402 l.pval052 d52,
403 decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
404 l.pval053 d53,
405 decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
406 l.pval054 d54,
407 decode(l.pval055,cn,vn,vn,vn,l.pval055) p55,
408 l.pval055 d55,
409 decode(l.pval056,cn,vn,vn,vn,l.pval056) p56,
410 l.pval056 d56,
411 decode(l.pval057,cn,vn,vn,vn,l.pval057) p57,
412 l.pval057 d57,
413 decode(l.pval058,cn,vn,vn,vn,l.pval058) p58,
414 l.pval058 d58,
415 decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,
416 l.pval059 d59,
417 decode(l.pval060,cn,vn,vn,vn,l.pval060) p60,
418 l.pval060 d60,
419 l.pval061 p61,
420 decode(l.pval062,cn,nn,vn,nn,n(l.pval062)) p62,
421 l.pval062 d62,
422 decode(l.pval063,cn,dn,d(l.pval063)) p63,
423 decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
424 l.pval064 d64
425 from hr_pump_batch_lines l
426 where l.batch_line_id = p_batch_line_id;
427 --
428 c cr%rowtype;
429 l_validate boolean := false;
430 L_EMP_PROVINCE_TAX_INF_ID number;
431 --
432 begin
433 hr_data_pump.entry('call');
434 open cr;
435 fetch cr into c;
436 if cr%notfound then
440 hr_utility.set_message_token('VALUE',p_batch_line_id);
437 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
438 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
439 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
441 hr_utility.raise_error;
442 end if;
443 --
444 hr_data_pump.api_trc_on;
445 PAY_CA_EMP_PRVTAX_INF_API.CREATE_CA_EMP_PRVTAX_INF
446 (p_validate => l_validate
447 ,P_EMP_PROVINCE_TAX_INF_ID => L_EMP_PROVINCE_TAX_INF_ID
448 ,P_EFFECTIVE_START_DATE => c.p2
449 ,P_EFFECTIVE_END_DATE => c.p3
450 ,P_LEGISLATION_CODE => c.p4
451 ,P_ASSIGNMENT_ID => c.p5
452 ,p_business_group_id => p_business_group_id
453 ,P_PROVINCE_CODE => c.p6
454 ,P_JURISDICTION_CODE => c.p7
455 ,P_TAX_CREDIT_AMOUNT => c.p8
456 ,P_BASIC_EXEMPTION_FLAG => c.p9
457 ,P_DEDUCTION_CODE => c.p10
458 ,P_EXTRA_INFO_NOT_PROVIDED => c.p11
459 ,P_MARRIAGE_STATUS => c.p12
460 ,P_NO_OF_INFIRM_DEPENDANTS => c.p13
461 ,P_NON_RESIDENT_STATUS => c.p14
462 ,P_DISABILITY_STATUS => c.p15
463 ,P_NO_OF_DEPENDANTS => c.p16
464 ,P_ANNUAL_DEDN => c.p17
465 ,P_TOTAL_EXPENSE_BY_COMMISSION => c.p18
466 ,P_TOTAL_REMNRTN_BY_COMMISSION => c.p19
467 ,P_PRESCRIBED_ZONE_DEDN_AMT => c.p20
468 ,P_ADDITIONAL_TAX => c.p21
469 ,P_PROV_OVERRIDE_RATE => c.p22
470 ,P_PROV_OVERRIDE_AMOUNT => c.p23
471 ,P_PROV_EXEMPT_FLAG => c.p24
472 ,P_PMED_EXEMPT_FLAG => c.p25
473 ,P_WC_EXEMPT_FLAG => c.p26
474 ,P_QPP_EXEMPT_FLAG => c.p27
475 ,P_TAX_CALC_METHOD => c.p28
476 ,P_OTHER_TAX_CREDIT => c.p29
477 ,P_CA_TAX_INFORMATION_CATEGORY => c.p30
478 ,P_CA_TAX_INFORMATION1 => c.p31
479 ,P_CA_TAX_INFORMATION2 => c.p32
480 ,P_CA_TAX_INFORMATION3 => c.p33
481 ,P_CA_TAX_INFORMATION4 => c.p34
482 ,P_CA_TAX_INFORMATION5 => c.p35
483 ,P_CA_TAX_INFORMATION6 => c.p36
484 ,P_CA_TAX_INFORMATION7 => c.p37
485 ,P_CA_TAX_INFORMATION8 => c.p38
486 ,P_CA_TAX_INFORMATION9 => c.p39
487 ,P_CA_TAX_INFORMATION10 => c.p40
488 ,P_CA_TAX_INFORMATION11 => c.p41
489 ,P_CA_TAX_INFORMATION12 => c.p42
490 ,P_CA_TAX_INFORMATION13 => c.p43
491 ,P_CA_TAX_INFORMATION14 => c.p44
492 ,P_CA_TAX_INFORMATION15 => c.p45
493 ,P_CA_TAX_INFORMATION16 => c.p46
494 ,P_CA_TAX_INFORMATION17 => c.p47
495 ,P_CA_TAX_INFORMATION18 => c.p48
496 ,P_CA_TAX_INFORMATION19 => c.p49
497 ,P_CA_TAX_INFORMATION20 => c.p50
498 ,P_CA_TAX_INFORMATION21 => c.p51
499 ,P_CA_TAX_INFORMATION22 => c.p52
500 ,P_CA_TAX_INFORMATION23 => c.p53
501 ,P_CA_TAX_INFORMATION24 => c.p54
502 ,P_CA_TAX_INFORMATION25 => c.p55
503 ,P_CA_TAX_INFORMATION26 => c.p56
504 ,P_CA_TAX_INFORMATION27 => c.p57
505 ,P_CA_TAX_INFORMATION28 => c.p58
506 ,P_CA_TAX_INFORMATION29 => c.p59
507 ,P_CA_TAX_INFORMATION30 => c.p60
508 ,P_OBJECT_VERSION_NUMBER => c.p61
509 ,P_PROV_LSP_AMOUNT => c.p62
510 ,P_EFFECTIVE_DATE => c.p63
511 ,P_PPIP_EXEMPT_FLAG => c.p64);
512 hr_data_pump.api_trc_off;
513 --
514 iuk(p_batch_line_id,c.p1,L_EMP_PROVINCE_TAX_INF_ID);
515 --
516 update hr_pump_batch_lines l set
517 l.pval001 = decode(c.p1,null,cn,c.p1),
518 l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
519 l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
520 l.pval061 = decode(c.p61,null,cn,c.p61)
521 where l.rowid = c.myrowid;
522 --
523 close cr;
524 --
525 hr_data_pump.exit('call');
526 exception
527  when hr_multi_message.error_message_exist then
528    if cr%isopen then
529     close cr;
530    end if;
531    hr_pump_utils.set_multi_msg_error_flag(true);
532  when others then
533  if cr%isopen then
534   close cr;
535  end if;
536  raise;
537 end call;
538 end hrdpp_CREATE_CA_EMP_PRVTAX_INF;