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_FEDTAX_INF

Source


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