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_CA_EMP_PRVTAX_INF

Source


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