[Home] [Help]
PACKAGE BODY: APPS.PAY_CA_CONT_CALC
Source
1 package body pay_ca_cont_calc as
2 /* $Header: pycacoc.pkb 120.0 2005/05/29 01:57:24 appldev noship $ */
3
4 /*
5 Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
6
7 Description : Package and procedure to build sql for payroll processes.
8
9 Change List
10 -----------
11 Date Name Vers Bug No Description
12 ----------- ---------- ----- ------- -----------------------------------
13 26-MAR-2001 nbristow 115.0 Created.
14 */
15 /* Used generator to build this procedure, but removed some of that table values.
16 */
17 /* PAY_CA_EMP_FED_TAX_INFO_F */
18 /* name : PAY_CA_EMP_FED_TAX_INFO_F_aru
19 purpose : This is procedure that records any changes for updates
20 on Federal Tax Information.
21 */
22 procedure PAY_CA_EMP_FED_TAX_INFO_F_aru(
23 p_business_group_id in number,
24 p_legislation_code in varchar2,
25 p_effective_date in date ,
26 p_old_ADDITIONAL_TAX in NUMBER,
27 p_new_ADDITIONAL_TAX in NUMBER ,
28 p_old_ANNUAL_DEDN in NUMBER,
29 p_new_ANNUAL_DEDN in NUMBER ,
30 p_old_ASSIGNMENT_ID in NUMBER,
31 p_new_ASSIGNMENT_ID in NUMBER ,
32 p_old_BASIC_EXEMPTION_FLAG in VARCHAR2,
33 p_new_BASIC_EXEMPTION_FLAG in VARCHAR2 ,
34 p_old_BUSINESS_GROUP_ID in NUMBER,
35 p_new_BUSINESS_GROUP_ID in NUMBER ,
36 p_old_CA_TAX_INFORMATION1 in VARCHAR2,
37 p_new_CA_TAX_INFORMATION1 in VARCHAR2 ,
38 p_old_CA_TAX_INFORMATION10 in VARCHAR2,
39 p_new_CA_TAX_INFORMATION10 in VARCHAR2 ,
40 p_old_CA_TAX_INFORMATION11 in VARCHAR2,
41 p_new_CA_TAX_INFORMATION11 in VARCHAR2 ,
42 p_old_CA_TAX_INFORMATION12 in VARCHAR2,
43 p_new_CA_TAX_INFORMATION12 in VARCHAR2 ,
44 p_old_CA_TAX_INFORMATION13 in VARCHAR2,
45 p_new_CA_TAX_INFORMATION13 in VARCHAR2 ,
46 p_old_CA_TAX_INFORMATION14 in VARCHAR2,
47 p_new_CA_TAX_INFORMATION14 in VARCHAR2 ,
48 p_old_CA_TAX_INFORMATION15 in VARCHAR2,
49 p_new_CA_TAX_INFORMATION15 in VARCHAR2 ,
50 p_old_CA_TAX_INFORMATION16 in VARCHAR2,
51 p_new_CA_TAX_INFORMATION16 in VARCHAR2 ,
52 p_old_CA_TAX_INFORMATION17 in VARCHAR2,
53 p_new_CA_TAX_INFORMATION17 in VARCHAR2 ,
54 p_old_CA_TAX_INFORMATION18 in VARCHAR2,
55 p_new_CA_TAX_INFORMATION18 in VARCHAR2 ,
56 p_old_CA_TAX_INFORMATION19 in VARCHAR2,
57 p_new_CA_TAX_INFORMATION19 in VARCHAR2 ,
58 p_old_CA_TAX_INFORMATION2 in VARCHAR2,
59 p_new_CA_TAX_INFORMATION2 in VARCHAR2 ,
60 p_old_CA_TAX_INFORMATION20 in VARCHAR2,
61 p_new_CA_TAX_INFORMATION20 in VARCHAR2 ,
62 p_old_CA_TAX_INFORMATION21 in VARCHAR2,
63 p_new_CA_TAX_INFORMATION21 in VARCHAR2 ,
64 p_old_CA_TAX_INFORMATION22 in VARCHAR2,
65 p_new_CA_TAX_INFORMATION22 in VARCHAR2 ,
66 p_old_CA_TAX_INFORMATION23 in VARCHAR2,
67 p_new_CA_TAX_INFORMATION23 in VARCHAR2 ,
68 p_old_CA_TAX_INFORMATION24 in VARCHAR2,
69 p_new_CA_TAX_INFORMATION24 in VARCHAR2 ,
70 p_old_CA_TAX_INFORMATION25 in VARCHAR2,
71 p_new_CA_TAX_INFORMATION25 in VARCHAR2 ,
72 p_old_CA_TAX_INFORMATION26 in VARCHAR2,
73 p_new_CA_TAX_INFORMATION26 in VARCHAR2 ,
74 p_old_CA_TAX_INFORMATION27 in VARCHAR2,
75 p_new_CA_TAX_INFORMATION27 in VARCHAR2 ,
76 p_old_CA_TAX_INFORMATION28 in VARCHAR2,
77 p_new_CA_TAX_INFORMATION28 in VARCHAR2 ,
78 p_old_CA_TAX_INFORMATION29 in VARCHAR2,
79 p_new_CA_TAX_INFORMATION29 in VARCHAR2 ,
80 p_old_CA_TAX_INFORMATION3 in VARCHAR2,
81 p_new_CA_TAX_INFORMATION3 in VARCHAR2 ,
82 p_old_CA_TAX_INFORMATION30 in VARCHAR2,
83 p_new_CA_TAX_INFORMATION30 in VARCHAR2 ,
84 p_old_CA_TAX_INFORMATION4 in VARCHAR2,
85 p_new_CA_TAX_INFORMATION4 in VARCHAR2 ,
86 p_old_CA_TAX_INFORMATION5 in VARCHAR2,
87 p_new_CA_TAX_INFORMATION5 in VARCHAR2 ,
88 p_old_CA_TAX_INFORMATION6 in VARCHAR2,
89 p_new_CA_TAX_INFORMATION6 in VARCHAR2 ,
90 p_old_CA_TAX_INFORMATION7 in VARCHAR2,
91 p_new_CA_TAX_INFORMATION7 in VARCHAR2 ,
92 p_old_CA_TAX_INFORMATION8 in VARCHAR2,
93 p_new_CA_TAX_INFORMATION8 in VARCHAR2 ,
94 p_old_CA_TAX_INFORMATION9 in VARCHAR2,
95 p_new_CA_TAX_INFORMATION9 in VARCHAR2 ,
96 p_old_CA_TAX_INFORMATION_CATEG in VARCHAR2,
97 p_new_CA_TAX_INFORMATION_CATEG in VARCHAR2 ,
98 p_old_CLAIM_CODE in VARCHAR2,
99 p_new_CLAIM_CODE in VARCHAR2 ,
100 p_old_CPP_QPP_EXEMPT_FLAG in VARCHAR2,
101 p_new_CPP_QPP_EXEMPT_FLAG in VARCHAR2 ,
102 p_old_EI_EXEMPT_FLAG in VARCHAR2,
103 p_new_EI_EXEMPT_FLAG in VARCHAR2 ,
104 p_old_EMPLOYMENT_PROVINCE in VARCHAR2,
105 p_new_EMPLOYMENT_PROVINCE in VARCHAR2 ,
106 p_old_EMP_FED_TAX_INF_ID in NUMBER,
107 p_new_EMP_FED_TAX_INF_ID in NUMBER ,
108 p_old_FED_EXEMPT_FLAG in VARCHAR2,
109 p_new_FED_EXEMPT_FLAG in VARCHAR2 ,
110 p_old_FED_OVERRIDE_AMOUNT in NUMBER,
111 p_new_FED_OVERRIDE_AMOUNT in NUMBER ,
112 p_old_FED_OVERRIDE_RATE in NUMBER,
113 p_new_FED_OVERRIDE_RATE in NUMBER ,
114 p_old_LEGISLATION_CODE in VARCHAR2,
115 p_new_LEGISLATION_CODE in VARCHAR2 ,
116 p_old_OTHER_FEDTAX_CREDITS in NUMBER,
117 p_new_OTHER_FEDTAX_CREDITS in NUMBER ,
118 p_old_PRESCRIBED_ZONE_DEDN_AMT in NUMBER,
119 p_new_PRESCRIBED_ZONE_DEDN_AMT in NUMBER ,
120 p_old_TAX_CALC_METHOD in VARCHAR2,
121 p_new_TAX_CALC_METHOD in VARCHAR2 ,
122 p_old_TAX_CREDIT_AMOUNT in NUMBER,
123 p_new_TAX_CREDIT_AMOUNT in NUMBER ,
124 p_old_TOTAL_EXPENSE_BY_COMMISS in NUMBER,
125 p_new_TOTAL_EXPENSE_BY_COMMISS in NUMBER ,
126 p_old_TOTAL_REMNRTN_BY_COMMISS in NUMBER,
127 p_new_TOTAL_REMNRTN_BY_COMMISS in NUMBER ,
128 p_old_EFFECTIVE_END_DATE in DATE,
129 p_new_EFFECTIVE_END_DATE in DATE ,
130 p_old_EFFECTIVE_START_DATE in DATE,
131 p_new_EFFECTIVE_START_DATE in DATE
132 )
133 is
134 --
135 begin
136 /* If the continuous calc is overriden then do nothing */
137 if (pay_continuous_calc.g_override_cc = TRUE) then
138 return;
139 end if;
140 --
141 /* If the dates havent changed it must be a correction */
142 if (p_old_EFFECTIVE_END_DATE = p_new_EFFECTIVE_END_DATE
143 and p_old_EFFECTIVE_START_DATE = p_new_EFFECTIVE_START_DATE) then
144 --
145 pay_continuous_calc.event_update(p_business_group_id,
146 p_legislation_code,
147 'PAY_CA_EMP_FED_TAX_INFO_F',
148 'ADDITIONAL_TAX',
149 p_old_ADDITIONAL_TAX,
150 p_new_ADDITIONAL_TAX,
151 p_effective_date
152 );
153 --
154 pay_continuous_calc.event_update(p_business_group_id,
155 p_legislation_code,
156 'PAY_CA_EMP_FED_TAX_INFO_F',
157 'ANNUAL_DEDN',
158 p_old_ANNUAL_DEDN,
159 p_new_ANNUAL_DEDN,
160 p_effective_date
161 );
162 --
163 pay_continuous_calc.event_update(p_business_group_id,
164 p_legislation_code,
165 'PAY_CA_EMP_FED_TAX_INFO_F',
166 'ASSIGNMENT_ID',
167 p_old_ASSIGNMENT_ID,
168 p_new_ASSIGNMENT_ID,
169 p_effective_date
170 );
171 --
172 pay_continuous_calc.event_update(p_business_group_id,
173 p_legislation_code,
174 'PAY_CA_EMP_FED_TAX_INFO_F',
175 'BASIC_EXEMPTION_FLAG',
176 p_old_BASIC_EXEMPTION_FLAG,
177 p_new_BASIC_EXEMPTION_FLAG,
178 p_effective_date
179 );
180 --
181 pay_continuous_calc.event_update(p_business_group_id,
182 p_legislation_code,
183 'PAY_CA_EMP_FED_TAX_INFO_F',
184 'BUSINESS_GROUP_ID',
185 p_old_BUSINESS_GROUP_ID,
186 p_new_BUSINESS_GROUP_ID,
187 p_effective_date
188 );
189 --
190 pay_continuous_calc.event_update(p_business_group_id,
191 p_legislation_code,
192 'PAY_CA_EMP_FED_TAX_INFO_F',
193 'CA_TAX_INFORMATION1',
194 p_old_CA_TAX_INFORMATION1,
195 p_new_CA_TAX_INFORMATION1,
196 p_effective_date
197 );
198 --
199 pay_continuous_calc.event_update(p_business_group_id,
200 p_legislation_code,
201 'PAY_CA_EMP_FED_TAX_INFO_F',
202 'CA_TAX_INFORMATION10',
203 p_old_CA_TAX_INFORMATION10,
204 p_new_CA_TAX_INFORMATION10,
205 p_effective_date
206 );
207 --
208 pay_continuous_calc.event_update(p_business_group_id,
209 p_legislation_code,
210 'PAY_CA_EMP_FED_TAX_INFO_F',
211 'CA_TAX_INFORMATION11',
212 p_old_CA_TAX_INFORMATION11,
213 p_new_CA_TAX_INFORMATION11,
214 p_effective_date
215 );
216 --
217 pay_continuous_calc.event_update(p_business_group_id,
218 p_legislation_code,
219 'PAY_CA_EMP_FED_TAX_INFO_F',
220 'CA_TAX_INFORMATION12',
221 p_old_CA_TAX_INFORMATION12,
222 p_new_CA_TAX_INFORMATION12,
223 p_effective_date
224 );
225 --
226 pay_continuous_calc.event_update(p_business_group_id,
227 p_legislation_code,
228 'PAY_CA_EMP_FED_TAX_INFO_F',
229 'CA_TAX_INFORMATION13',
230 p_old_CA_TAX_INFORMATION13,
231 p_new_CA_TAX_INFORMATION13,
232 p_effective_date
233 );
234 --
235 pay_continuous_calc.event_update(p_business_group_id,
236 p_legislation_code,
237 'PAY_CA_EMP_FED_TAX_INFO_F',
238 'CA_TAX_INFORMATION14',
239 p_old_CA_TAX_INFORMATION14,
240 p_new_CA_TAX_INFORMATION14,
241 p_effective_date
242 );
243 --
244 pay_continuous_calc.event_update(p_business_group_id,
245 p_legislation_code,
246 'PAY_CA_EMP_FED_TAX_INFO_F',
247 'CA_TAX_INFORMATION15',
248 p_old_CA_TAX_INFORMATION15,
249 p_new_CA_TAX_INFORMATION15,
250 p_effective_date
251 );
252 --
253 pay_continuous_calc.event_update(p_business_group_id,
254 p_legislation_code,
255 'PAY_CA_EMP_FED_TAX_INFO_F',
256 'CA_TAX_INFORMATION16',
257 p_old_CA_TAX_INFORMATION16,
258 p_new_CA_TAX_INFORMATION16,
259 p_effective_date
260 );
261 --
262 pay_continuous_calc.event_update(p_business_group_id,
263 p_legislation_code,
264 'PAY_CA_EMP_FED_TAX_INFO_F',
265 'CA_TAX_INFORMATION17',
266 p_old_CA_TAX_INFORMATION17,
267 p_new_CA_TAX_INFORMATION17,
268 p_effective_date
269 );
270 --
271 pay_continuous_calc.event_update(p_business_group_id,
272 p_legislation_code,
273 'PAY_CA_EMP_FED_TAX_INFO_F',
274 'CA_TAX_INFORMATION18',
275 p_old_CA_TAX_INFORMATION18,
276 p_new_CA_TAX_INFORMATION18,
277 p_effective_date
278 );
279 --
280 pay_continuous_calc.event_update(p_business_group_id,
281 p_legislation_code,
282 'PAY_CA_EMP_FED_TAX_INFO_F',
283 'CA_TAX_INFORMATION19',
284 p_old_CA_TAX_INFORMATION19,
285 p_new_CA_TAX_INFORMATION19,
286 p_effective_date
287 );
288 --
289 pay_continuous_calc.event_update(p_business_group_id,
290 p_legislation_code,
291 'PAY_CA_EMP_FED_TAX_INFO_F',
292 'CA_TAX_INFORMATION2',
293 p_old_CA_TAX_INFORMATION2,
294 p_new_CA_TAX_INFORMATION2,
295 p_effective_date
296 );
297 --
298 pay_continuous_calc.event_update(p_business_group_id,
299 p_legislation_code,
300 'PAY_CA_EMP_FED_TAX_INFO_F',
301 'CA_TAX_INFORMATION20',
302 p_old_CA_TAX_INFORMATION20,
303 p_new_CA_TAX_INFORMATION20,
304 p_effective_date
305 );
306 --
307 pay_continuous_calc.event_update(p_business_group_id,
308 p_legislation_code,
309 'PAY_CA_EMP_FED_TAX_INFO_F',
310 'CA_TAX_INFORMATION21',
311 p_old_CA_TAX_INFORMATION21,
312 p_new_CA_TAX_INFORMATION21,
313 p_effective_date
314 );
315 --
316 pay_continuous_calc.event_update(p_business_group_id,
320 p_old_CA_TAX_INFORMATION22,
317 p_legislation_code,
318 'PAY_CA_EMP_FED_TAX_INFO_F',
319 'CA_TAX_INFORMATION22',
321 p_new_CA_TAX_INFORMATION22,
322 p_effective_date
323 );
324 --
325 pay_continuous_calc.event_update(p_business_group_id,
326 p_legislation_code,
327 'PAY_CA_EMP_FED_TAX_INFO_F',
328 'CA_TAX_INFORMATION23',
329 p_old_CA_TAX_INFORMATION23,
330 p_new_CA_TAX_INFORMATION23,
331 p_effective_date
332 );
333 --
334 pay_continuous_calc.event_update(p_business_group_id,
335 p_legislation_code,
336 'PAY_CA_EMP_FED_TAX_INFO_F',
337 'CA_TAX_INFORMATION24',
338 p_old_CA_TAX_INFORMATION24,
339 p_new_CA_TAX_INFORMATION24,
340 p_effective_date
341 );
342 --
343 pay_continuous_calc.event_update(p_business_group_id,
344 p_legislation_code,
345 'PAY_CA_EMP_FED_TAX_INFO_F',
346 'CA_TAX_INFORMATION25',
347 p_old_CA_TAX_INFORMATION25,
348 p_new_CA_TAX_INFORMATION25,
349 p_effective_date
350 );
351 --
352 pay_continuous_calc.event_update(p_business_group_id,
353 p_legislation_code,
354 'PAY_CA_EMP_FED_TAX_INFO_F',
355 'CA_TAX_INFORMATION26',
356 p_old_CA_TAX_INFORMATION26,
357 p_new_CA_TAX_INFORMATION26,
358 p_effective_date
359 );
360 --
361 pay_continuous_calc.event_update(p_business_group_id,
362 p_legislation_code,
363 'PAY_CA_EMP_FED_TAX_INFO_F',
364 'CA_TAX_INFORMATION27',
365 p_old_CA_TAX_INFORMATION27,
366 p_new_CA_TAX_INFORMATION27,
367 p_effective_date
368 );
369 --
370 pay_continuous_calc.event_update(p_business_group_id,
371 p_legislation_code,
372 'PAY_CA_EMP_FED_TAX_INFO_F',
373 'CA_TAX_INFORMATION28',
374 p_old_CA_TAX_INFORMATION28,
375 p_new_CA_TAX_INFORMATION28,
376 p_effective_date
377 );
378 --
379 pay_continuous_calc.event_update(p_business_group_id,
380 p_legislation_code,
381 'PAY_CA_EMP_FED_TAX_INFO_F',
382 'CA_TAX_INFORMATION29',
383 p_old_CA_TAX_INFORMATION29,
384 p_new_CA_TAX_INFORMATION29,
385 p_effective_date
386 );
387 --
388 pay_continuous_calc.event_update(p_business_group_id,
389 p_legislation_code,
390 'PAY_CA_EMP_FED_TAX_INFO_F',
391 'CA_TAX_INFORMATION3',
392 p_old_CA_TAX_INFORMATION3,
393 p_new_CA_TAX_INFORMATION3,
394 p_effective_date
395 );
396 --
397 pay_continuous_calc.event_update(p_business_group_id,
398 p_legislation_code,
399 'PAY_CA_EMP_FED_TAX_INFO_F',
400 'CA_TAX_INFORMATION30',
401 p_old_CA_TAX_INFORMATION30,
402 p_new_CA_TAX_INFORMATION30,
403 p_effective_date
404 );
405 --
406 pay_continuous_calc.event_update(p_business_group_id,
407 p_legislation_code,
408 'PAY_CA_EMP_FED_TAX_INFO_F',
409 'CA_TAX_INFORMATION4',
410 p_old_CA_TAX_INFORMATION4,
411 p_new_CA_TAX_INFORMATION4,
412 p_effective_date
413 );
414 --
415 pay_continuous_calc.event_update(p_business_group_id,
416 p_legislation_code,
417 'PAY_CA_EMP_FED_TAX_INFO_F',
418 'CA_TAX_INFORMATION5',
422 );
419 p_old_CA_TAX_INFORMATION5,
420 p_new_CA_TAX_INFORMATION5,
421 p_effective_date
423 --
424 pay_continuous_calc.event_update(p_business_group_id,
425 p_legislation_code,
426 'PAY_CA_EMP_FED_TAX_INFO_F',
427 'CA_TAX_INFORMATION6',
428 p_old_CA_TAX_INFORMATION6,
429 p_new_CA_TAX_INFORMATION6,
430 p_effective_date
431 );
432 --
433 pay_continuous_calc.event_update(p_business_group_id,
434 p_legislation_code,
435 'PAY_CA_EMP_FED_TAX_INFO_F',
436 'CA_TAX_INFORMATION7',
437 p_old_CA_TAX_INFORMATION7,
438 p_new_CA_TAX_INFORMATION7,
439 p_effective_date
440 );
441 --
442 pay_continuous_calc.event_update(p_business_group_id,
443 p_legislation_code,
444 'PAY_CA_EMP_FED_TAX_INFO_F',
445 'CA_TAX_INFORMATION8',
446 p_old_CA_TAX_INFORMATION8,
447 p_new_CA_TAX_INFORMATION8,
448 p_effective_date
449 );
450 --
451 pay_continuous_calc.event_update(p_business_group_id,
452 p_legislation_code,
453 'PAY_CA_EMP_FED_TAX_INFO_F',
454 'CA_TAX_INFORMATION9',
455 p_old_CA_TAX_INFORMATION9,
456 p_new_CA_TAX_INFORMATION9,
457 p_effective_date
458 );
459 --
460 pay_continuous_calc.event_update(p_business_group_id,
461 p_legislation_code,
462 'PAY_CA_EMP_FED_TAX_INFO_F',
463 'CA_TAX_INFORMATION_CATEGORY',
464 p_old_CA_TAX_INFORMATION_CATEG,
465 p_new_CA_TAX_INFORMATION_CATEG,
466 p_effective_date
467 );
468 --
469 pay_continuous_calc.event_update(p_business_group_id,
470 p_legislation_code,
471 'PAY_CA_EMP_FED_TAX_INFO_F',
472 'CLAIM_CODE',
473 p_old_CLAIM_CODE,
474 p_new_CLAIM_CODE,
475 p_effective_date
476 );
477 --
478 pay_continuous_calc.event_update(p_business_group_id,
479 p_legislation_code,
480 'PAY_CA_EMP_FED_TAX_INFO_F',
481 'CPP_QPP_EXEMPT_FLAG',
482 p_old_CPP_QPP_EXEMPT_FLAG,
483 p_new_CPP_QPP_EXEMPT_FLAG,
484 p_effective_date
485 );
486 --
487 pay_continuous_calc.event_update(p_business_group_id,
488 p_legislation_code,
489 'PAY_CA_EMP_FED_TAX_INFO_F',
490 'EI_EXEMPT_FLAG',
491 p_old_EI_EXEMPT_FLAG,
492 p_new_EI_EXEMPT_FLAG,
493 p_effective_date
494 );
495 --
496 pay_continuous_calc.event_update(p_business_group_id,
497 p_legislation_code,
498 'PAY_CA_EMP_FED_TAX_INFO_F',
499 'EMPLOYMENT_PROVINCE',
500 p_old_EMPLOYMENT_PROVINCE,
501 p_new_EMPLOYMENT_PROVINCE,
502 p_effective_date
503 );
504 --
505 pay_continuous_calc.event_update(p_business_group_id,
506 p_legislation_code,
507 'PAY_CA_EMP_FED_TAX_INFO_F',
508 'EMP_FED_TAX_INF_ID',
509 p_old_EMP_FED_TAX_INF_ID,
510 p_new_EMP_FED_TAX_INF_ID,
511 p_effective_date
512 );
513 --
514 pay_continuous_calc.event_update(p_business_group_id,
515 p_legislation_code,
516 'PAY_CA_EMP_FED_TAX_INFO_F',
517 'FED_EXEMPT_FLAG',
518 p_old_FED_EXEMPT_FLAG,
519 p_new_FED_EXEMPT_FLAG,
520 p_effective_date
521 );
522 --
526 'FED_OVERRIDE_AMOUNT',
523 pay_continuous_calc.event_update(p_business_group_id,
524 p_legislation_code,
525 'PAY_CA_EMP_FED_TAX_INFO_F',
527 p_old_FED_OVERRIDE_AMOUNT,
528 p_new_FED_OVERRIDE_AMOUNT,
529 p_effective_date
530 );
531 --
532 pay_continuous_calc.event_update(p_business_group_id,
533 p_legislation_code,
534 'PAY_CA_EMP_FED_TAX_INFO_F',
535 'FED_OVERRIDE_RATE',
536 p_old_FED_OVERRIDE_RATE,
537 p_new_FED_OVERRIDE_RATE,
538 p_effective_date
539 );
540 --
541 pay_continuous_calc.event_update(p_business_group_id,
542 p_legislation_code,
543 'PAY_CA_EMP_FED_TAX_INFO_F',
544 'LEGISLATION_CODE',
545 p_old_LEGISLATION_CODE,
546 p_new_LEGISLATION_CODE,
547 p_effective_date
548 );
549 --
550 pay_continuous_calc.event_update(p_business_group_id,
551 p_legislation_code,
552 'PAY_CA_EMP_FED_TAX_INFO_F',
553 'OTHER_FEDTAX_CREDITS',
554 p_old_OTHER_FEDTAX_CREDITS,
555 p_new_OTHER_FEDTAX_CREDITS,
556 p_effective_date
557 );
558 --
559 pay_continuous_calc.event_update(p_business_group_id,
560 p_legislation_code,
561 'PAY_CA_EMP_FED_TAX_INFO_F',
562 'PRESCRIBED_ZONE_DEDN_AMT',
563 p_old_PRESCRIBED_ZONE_DEDN_AMT,
564 p_new_PRESCRIBED_ZONE_DEDN_AMT,
565 p_effective_date
566 );
567 --
568 pay_continuous_calc.event_update(p_business_group_id,
569 p_legislation_code,
570 'PAY_CA_EMP_FED_TAX_INFO_F',
571 'TAX_CALC_METHOD',
572 p_old_TAX_CALC_METHOD,
573 p_new_TAX_CALC_METHOD,
574 p_effective_date
575 );
576 --
577 pay_continuous_calc.event_update(p_business_group_id,
578 p_legislation_code,
579 'PAY_CA_EMP_FED_TAX_INFO_F',
580 'TAX_CREDIT_AMOUNT',
581 p_old_TAX_CREDIT_AMOUNT,
582 p_new_TAX_CREDIT_AMOUNT,
583 p_effective_date
584 );
585 --
586 pay_continuous_calc.event_update(p_business_group_id,
587 p_legislation_code,
588 'PAY_CA_EMP_FED_TAX_INFO_F',
589 'TOTAL_EXPENSE_BY_COMMISSION',
590 p_old_TOTAL_EXPENSE_BY_COMMISS,
591 p_new_TOTAL_EXPENSE_BY_COMMISS,
592 p_effective_date
593 );
594 --
595 pay_continuous_calc.event_update(p_business_group_id,
596 p_legislation_code,
597 'PAY_CA_EMP_FED_TAX_INFO_F',
598 'TOTAL_REMNRTN_BY_COMMISSION',
599 p_old_TOTAL_REMNRTN_BY_COMMISS,
600 p_new_TOTAL_REMNRTN_BY_COMMISS,
601 p_effective_date
602 );
603 --
604 pay_continuous_calc.event_update(p_business_group_id,
605 p_legislation_code,
606 'PAY_CA_EMP_FED_TAX_INFO_F',
607 'TOTAL_REMNRTN_BY_COMMISSION',
608 p_old_TOTAL_REMNRTN_BY_COMMISS,
609 p_new_TOTAL_REMNRTN_BY_COMMISS,
610 p_effective_date
611 );
612 else
613 /* OK it must be a date track change */
614 --
615 pay_continuous_calc.event_update(p_business_group_id,
616 p_legislation_code,
617 'PAY_CA_EMP_FED_TAX_INFO_F',
618 'EFFECTIVE_END_DATE',
619 p_old_EFFECTIVE_END_DATE,
620 p_new_EFFECTIVE_END_DATE,
621 p_new_effective_end_date,
622 least(p_old_effective_end_date,
623 p_new_effective_end_date)
627 p_legislation_code,
624 );
625 --
626 pay_continuous_calc.event_update(p_business_group_id,
628 'PAY_CA_EMP_FED_TAX_INFO_F',
629 'EFFECTIVE_START_DATE',
630 p_old_EFFECTIVE_START_DATE,
631 p_new_EFFECTIVE_START_DATE,
632 p_new_effective_start_date,
633 least(p_old_effective_start_date,
634 p_new_effective_start_date)
635 );
636
637 end if;
638 --
639 /* Now call the API for the affected assignments */
640 declare
641 l_process_event_id number;
642 l_object_version_number number;
643 cnt number;
644 begin
645 if (pay_continuous_calc.g_event_list.sz <> 0) then
646 for cnt in 1..pay_continuous_calc.g_event_list.sz loop
647 pay_ppe_api.create_process_event(
648 p_assignment_id => p_old_assignment_id,
649 p_effective_date => pay_continuous_calc.g_event_list.effective_date(cnt),
650 p_change_type => pay_continuous_calc.g_event_list.change_type(cnt),
651 p_status => 'U',
652 p_description => pay_continuous_calc.g_event_list.description(cnt),
653 p_process_event_id => l_process_event_id,
654 p_object_version_number => l_object_version_number,
655 p_event_update_id => pay_continuous_calc.g_event_list.event_update_id(cnt),
656 p_business_group_id => p_business_group_id,
657 p_surrogate_key => p_old_EMP_FED_TAX_INF_ID
658 );
659 end loop;
660 end if;
661 pay_continuous_calc.g_event_list.sz := 0;
662 end;
663 --
664 end PAY_CA_EMP_FED_TAX_INFO_F_aru;
665 /* PAY_CA_EMP_PROV_TAX_INFO_F */
666 /* name : PAY_CA_EMP_PROV_TAX_INFO_F_aru
667 purpose : This is procedure that records any changes for updates
668 on Povincial Tax Information.
669 */
670 --
671 procedure PAY_CA_EMP_PROV_TAX_INFO_F_aru(
672 p_business_group_id in number,
673 p_legislation_code in varchar2,
674 p_effective_date in date ,
675 p_old_ADDITIONAL_TAX in NUMBER,
676 p_new_ADDITIONAL_TAX in NUMBER ,
677 p_old_ANNUAL_DEDN in NUMBER,
678 p_new_ANNUAL_DEDN in NUMBER ,
679 p_old_ASSIGNMENT_ID in NUMBER,
680 p_new_ASSIGNMENT_ID in NUMBER ,
681 p_old_BASIC_EXEMPTION_FLAG in VARCHAR2,
682 p_new_BASIC_EXEMPTION_FLAG in VARCHAR2 ,
683 p_old_BUSINESS_GROUP_ID in NUMBER,
684 p_new_BUSINESS_GROUP_ID in NUMBER ,
685 p_old_CA_TAX_INFORMATION1 in VARCHAR2,
686 p_new_CA_TAX_INFORMATION1 in VARCHAR2 ,
687 p_old_CA_TAX_INFORMATION10 in VARCHAR2,
688 p_new_CA_TAX_INFORMATION10 in VARCHAR2 ,
689 p_old_CA_TAX_INFORMATION11 in VARCHAR2,
690 p_new_CA_TAX_INFORMATION11 in VARCHAR2 ,
691 p_old_CA_TAX_INFORMATION12 in VARCHAR2,
692 p_new_CA_TAX_INFORMATION12 in VARCHAR2 ,
693 p_old_CA_TAX_INFORMATION13 in VARCHAR2,
694 p_new_CA_TAX_INFORMATION13 in VARCHAR2 ,
695 p_old_CA_TAX_INFORMATION14 in VARCHAR2,
696 p_new_CA_TAX_INFORMATION14 in VARCHAR2 ,
697 p_old_CA_TAX_INFORMATION15 in VARCHAR2,
698 p_new_CA_TAX_INFORMATION15 in VARCHAR2 ,
699 p_old_CA_TAX_INFORMATION16 in VARCHAR2,
700 p_new_CA_TAX_INFORMATION16 in VARCHAR2 ,
701 p_old_CA_TAX_INFORMATION17 in VARCHAR2,
702 p_new_CA_TAX_INFORMATION17 in VARCHAR2 ,
703 p_old_CA_TAX_INFORMATION18 in VARCHAR2,
704 p_new_CA_TAX_INFORMATION18 in VARCHAR2 ,
705 p_old_CA_TAX_INFORMATION19 in VARCHAR2,
706 p_new_CA_TAX_INFORMATION19 in VARCHAR2 ,
707 p_old_CA_TAX_INFORMATION2 in VARCHAR2,
708 p_new_CA_TAX_INFORMATION2 in VARCHAR2 ,
709 p_old_CA_TAX_INFORMATION20 in VARCHAR2,
710 p_new_CA_TAX_INFORMATION20 in VARCHAR2 ,
711 p_old_CA_TAX_INFORMATION21 in VARCHAR2,
712 p_new_CA_TAX_INFORMATION21 in VARCHAR2 ,
713 p_old_CA_TAX_INFORMATION22 in VARCHAR2,
714 p_new_CA_TAX_INFORMATION22 in VARCHAR2 ,
715 p_old_CA_TAX_INFORMATION23 in VARCHAR2,
716 p_new_CA_TAX_INFORMATION23 in VARCHAR2 ,
717 p_old_CA_TAX_INFORMATION24 in VARCHAR2,
718 p_new_CA_TAX_INFORMATION24 in VARCHAR2 ,
719 p_old_CA_TAX_INFORMATION25 in VARCHAR2,
720 p_new_CA_TAX_INFORMATION25 in VARCHAR2 ,
721 p_old_CA_TAX_INFORMATION26 in VARCHAR2,
722 p_new_CA_TAX_INFORMATION26 in VARCHAR2 ,
723 p_old_CA_TAX_INFORMATION27 in VARCHAR2,
724 p_new_CA_TAX_INFORMATION27 in VARCHAR2 ,
725 p_old_CA_TAX_INFORMATION28 in VARCHAR2,
726 p_new_CA_TAX_INFORMATION28 in VARCHAR2 ,
727 p_old_CA_TAX_INFORMATION29 in VARCHAR2,
728 p_new_CA_TAX_INFORMATION29 in VARCHAR2 ,
729 p_old_CA_TAX_INFORMATION3 in VARCHAR2,
730 p_new_CA_TAX_INFORMATION3 in VARCHAR2 ,
731 p_old_CA_TAX_INFORMATION30 in VARCHAR2,
732 p_new_CA_TAX_INFORMATION30 in VARCHAR2 ,
733 p_old_CA_TAX_INFORMATION4 in VARCHAR2,
734 p_new_CA_TAX_INFORMATION4 in VARCHAR2 ,
735 p_old_CA_TAX_INFORMATION5 in VARCHAR2,
736 p_new_CA_TAX_INFORMATION5 in VARCHAR2 ,
737 p_old_CA_TAX_INFORMATION6 in VARCHAR2,
738 p_new_CA_TAX_INFORMATION6 in VARCHAR2 ,
742 p_new_CA_TAX_INFORMATION8 in VARCHAR2 ,
739 p_old_CA_TAX_INFORMATION7 in VARCHAR2,
740 p_new_CA_TAX_INFORMATION7 in VARCHAR2 ,
741 p_old_CA_TAX_INFORMATION8 in VARCHAR2,
743 p_old_CA_TAX_INFORMATION9 in VARCHAR2,
744 p_new_CA_TAX_INFORMATION9 in VARCHAR2 ,
745 p_old_CA_TAX_INFORMATION_CATEG in VARCHAR2,
746 p_new_CA_TAX_INFORMATION_CATEG in VARCHAR2 ,
747 p_old_DEDUCTION_CODE in VARCHAR2,
748 p_new_DEDUCTION_CODE in VARCHAR2 ,
749 p_old_DISABILITY_STATUS in VARCHAR2,
750 p_new_DISABILITY_STATUS in VARCHAR2 ,
751 p_old_EMP_PROVINCE_TAX_INF_ID in NUMBER,
752 p_new_EMP_PROVINCE_TAX_INF_ID in NUMBER ,
753 p_old_EXTRA_INFO_NOT_PROVIDED in VARCHAR2,
754 p_new_EXTRA_INFO_NOT_PROVIDED in VARCHAR2 ,
755 p_old_JURISDICTION_CODE in VARCHAR2,
756 p_new_JURISDICTION_CODE in VARCHAR2 ,
757 p_old_LEGISLATION_CODE in VARCHAR2,
758 p_new_LEGISLATION_CODE in VARCHAR2 ,
759 p_old_MARRIAGE_STATUS in VARCHAR2,
760 p_new_MARRIAGE_STATUS in VARCHAR2 ,
761 p_old_NON_RESIDENT_STATUS in VARCHAR2,
762 p_new_NON_RESIDENT_STATUS in VARCHAR2 ,
763 p_old_NO_OF_DEPENDANTS in NUMBER,
764 p_new_NO_OF_DEPENDANTS in NUMBER ,
765 p_old_NO_OF_INFIRM_DEPENDANTS in NUMBER,
766 p_new_NO_OF_INFIRM_DEPENDANTS in NUMBER ,
767 p_old_OTHER_TAX_CREDIT in NUMBER,
768 p_new_OTHER_TAX_CREDIT in NUMBER ,
769 p_old_PMED_EXEMPT_FLAG in VARCHAR2,
770 p_new_PMED_EXEMPT_FLAG in VARCHAR2 ,
771 p_old_PRESCRIBED_ZONE_DEDN_AMT in NUMBER,
772 p_new_PRESCRIBED_ZONE_DEDN_AMT in NUMBER ,
773 p_old_PROVINCE_CODE in VARCHAR2,
774 p_new_PROVINCE_CODE in VARCHAR2 ,
775 p_old_PROV_EXEMPT_FLAG in VARCHAR2,
776 p_new_PROV_EXEMPT_FLAG in VARCHAR2 ,
777 p_old_PROV_OVERRIDE_AMOUNT in NUMBER,
778 p_new_PROV_OVERRIDE_AMOUNT in NUMBER ,
779 p_old_PROV_OVERRIDE_RATE in NUMBER,
780 p_new_PROV_OVERRIDE_RATE in NUMBER ,
781 p_old_QPP_EXEMPT_FLAG in VARCHAR2,
782 p_new_QPP_EXEMPT_FLAG in VARCHAR2 ,
783 p_old_TAX_CALC_METHOD in VARCHAR2,
784 p_new_TAX_CALC_METHOD in VARCHAR2 ,
785 p_old_TAX_CREDIT_AMOUNT in NUMBER,
786 p_new_TAX_CREDIT_AMOUNT in NUMBER ,
787 p_old_TOTAL_EXPENSE_BY_COMMISS in NUMBER,
788 p_new_TOTAL_EXPENSE_BY_COMMISS in NUMBER ,
789 p_old_TOTAL_REMNRTN_BY_COMMISS in NUMBER,
790 p_new_TOTAL_REMNRTN_BY_COMMISS in NUMBER ,
791 p_old_WC_EXEMPT_FLAG in VARCHAR2,
792 p_new_WC_EXEMPT_FLAG in VARCHAR2 ,
793 p_old_EFFECTIVE_END_DATE in DATE,
794 p_new_EFFECTIVE_END_DATE in DATE ,
795 p_old_EFFECTIVE_START_DATE in DATE,
796 p_new_EFFECTIVE_START_DATE in DATE
797 )
798 is
799 --
800 begin
801 /* If the continuous calc is overriden then do nothing */
802 if (pay_continuous_calc.g_override_cc = TRUE) then
803 return;
804 end if;
805 --
806 /* If the dates havent changed it must be a correction */
807 if (p_old_EFFECTIVE_END_DATE = p_new_EFFECTIVE_END_DATE
808 and p_old_EFFECTIVE_START_DATE = p_new_EFFECTIVE_START_DATE) then
809 --
810 pay_continuous_calc.event_update(p_business_group_id,
811 p_legislation_code,
812 'PAY_CA_EMP_PROV_TAX_INFO_F',
813 'ADDITIONAL_TAX',
814 p_old_ADDITIONAL_TAX,
815 p_new_ADDITIONAL_TAX,
816 p_effective_date
817 );
818 --
819 pay_continuous_calc.event_update(p_business_group_id,
820 p_legislation_code,
821 'PAY_CA_EMP_PROV_TAX_INFO_F',
822 'ANNUAL_DEDN',
823 p_old_ANNUAL_DEDN,
824 p_new_ANNUAL_DEDN,
825 p_effective_date
826 );
827 --
828 pay_continuous_calc.event_update(p_business_group_id,
829 p_legislation_code,
830 'PAY_CA_EMP_PROV_TAX_INFO_F',
831 'ASSIGNMENT_ID',
832 p_old_ASSIGNMENT_ID,
833 p_new_ASSIGNMENT_ID,
834 p_effective_date
835 );
836 --
837 pay_continuous_calc.event_update(p_business_group_id,
838 p_legislation_code,
839 'PAY_CA_EMP_PROV_TAX_INFO_F',
840 'BASIC_EXEMPTION_FLAG',
841 p_old_BASIC_EXEMPTION_FLAG,
842 p_new_BASIC_EXEMPTION_FLAG,
843 p_effective_date
844 );
845 --
846 pay_continuous_calc.event_update(p_business_group_id,
847 p_legislation_code,
848 'PAY_CA_EMP_PROV_TAX_INFO_F',
849 'BUSINESS_GROUP_ID',
850 p_old_BUSINESS_GROUP_ID,
851 p_new_BUSINESS_GROUP_ID,
852 p_effective_date
853 );
854 --
855 pay_continuous_calc.event_update(p_business_group_id,
856 p_legislation_code,
857 'PAY_CA_EMP_PROV_TAX_INFO_F',
858 'CA_TAX_INFORMATION1',
862 );
859 p_old_CA_TAX_INFORMATION1,
860 p_new_CA_TAX_INFORMATION1,
861 p_effective_date
863 --
864 pay_continuous_calc.event_update(p_business_group_id,
865 p_legislation_code,
866 'PAY_CA_EMP_PROV_TAX_INFO_F',
867 'CA_TAX_INFORMATION10',
868 p_old_CA_TAX_INFORMATION10,
869 p_new_CA_TAX_INFORMATION10,
870 p_effective_date
871 );
872 --
873 pay_continuous_calc.event_update(p_business_group_id,
874 p_legislation_code,
875 'PAY_CA_EMP_PROV_TAX_INFO_F',
876 'CA_TAX_INFORMATION11',
877 p_old_CA_TAX_INFORMATION11,
878 p_new_CA_TAX_INFORMATION11,
879 p_effective_date
880 );
881 --
882 pay_continuous_calc.event_update(p_business_group_id,
883 p_legislation_code,
884 'PAY_CA_EMP_PROV_TAX_INFO_F',
885 'CA_TAX_INFORMATION12',
886 p_old_CA_TAX_INFORMATION12,
887 p_new_CA_TAX_INFORMATION12,
888 p_effective_date
889 );
890 --
891 pay_continuous_calc.event_update(p_business_group_id,
892 p_legislation_code,
893 'PAY_CA_EMP_PROV_TAX_INFO_F',
894 'CA_TAX_INFORMATION13',
895 p_old_CA_TAX_INFORMATION13,
896 p_new_CA_TAX_INFORMATION13,
897 p_effective_date
898 );
899 --
900 pay_continuous_calc.event_update(p_business_group_id,
901 p_legislation_code,
902 'PAY_CA_EMP_PROV_TAX_INFO_F',
903 'CA_TAX_INFORMATION14',
904 p_old_CA_TAX_INFORMATION14,
905 p_new_CA_TAX_INFORMATION14,
906 p_effective_date
907 );
908 --
909 pay_continuous_calc.event_update(p_business_group_id,
910 p_legislation_code,
911 'PAY_CA_EMP_PROV_TAX_INFO_F',
912 'CA_TAX_INFORMATION15',
913 p_old_CA_TAX_INFORMATION15,
914 p_new_CA_TAX_INFORMATION15,
915 p_effective_date
916 );
917 --
918 pay_continuous_calc.event_update(p_business_group_id,
919 p_legislation_code,
920 'PAY_CA_EMP_PROV_TAX_INFO_F',
921 'CA_TAX_INFORMATION16',
922 p_old_CA_TAX_INFORMATION16,
923 p_new_CA_TAX_INFORMATION16,
924 p_effective_date
925 );
926 --
927 pay_continuous_calc.event_update(p_business_group_id,
928 p_legislation_code,
929 'PAY_CA_EMP_PROV_TAX_INFO_F',
930 'CA_TAX_INFORMATION17',
931 p_old_CA_TAX_INFORMATION17,
932 p_new_CA_TAX_INFORMATION17,
933 p_effective_date
934 );
935 --
936 pay_continuous_calc.event_update(p_business_group_id,
937 p_legislation_code,
938 'PAY_CA_EMP_PROV_TAX_INFO_F',
939 'CA_TAX_INFORMATION18',
940 p_old_CA_TAX_INFORMATION18,
941 p_new_CA_TAX_INFORMATION18,
942 p_effective_date
943 );
944 --
945 pay_continuous_calc.event_update(p_business_group_id,
946 p_legislation_code,
947 'PAY_CA_EMP_PROV_TAX_INFO_F',
948 'CA_TAX_INFORMATION19',
949 p_old_CA_TAX_INFORMATION19,
950 p_new_CA_TAX_INFORMATION19,
951 p_effective_date
952 );
953 --
954 pay_continuous_calc.event_update(p_business_group_id,
955 p_legislation_code,
956 'PAY_CA_EMP_PROV_TAX_INFO_F',
957 'CA_TAX_INFORMATION2',
958 p_old_CA_TAX_INFORMATION2,
959 p_new_CA_TAX_INFORMATION2,
960 p_effective_date
964 p_legislation_code,
961 );
962 --
963 pay_continuous_calc.event_update(p_business_group_id,
965 'PAY_CA_EMP_PROV_TAX_INFO_F',
966 'CA_TAX_INFORMATION20',
967 p_old_CA_TAX_INFORMATION20,
968 p_new_CA_TAX_INFORMATION20,
969 p_effective_date
970 );
971 --
972 pay_continuous_calc.event_update(p_business_group_id,
973 p_legislation_code,
974 'PAY_CA_EMP_PROV_TAX_INFO_F',
975 'CA_TAX_INFORMATION21',
976 p_old_CA_TAX_INFORMATION21,
977 p_new_CA_TAX_INFORMATION21,
978 p_effective_date
979 );
980 --
981 pay_continuous_calc.event_update(p_business_group_id,
982 p_legislation_code,
983 'PAY_CA_EMP_PROV_TAX_INFO_F',
984 'CA_TAX_INFORMATION22',
985 p_old_CA_TAX_INFORMATION22,
986 p_new_CA_TAX_INFORMATION22,
987 p_effective_date
988 );
989 --
990 pay_continuous_calc.event_update(p_business_group_id,
991 p_legislation_code,
992 'PAY_CA_EMP_PROV_TAX_INFO_F',
993 'CA_TAX_INFORMATION23',
994 p_old_CA_TAX_INFORMATION23,
995 p_new_CA_TAX_INFORMATION23,
996 p_effective_date
997 );
998 --
999 pay_continuous_calc.event_update(p_business_group_id,
1000 p_legislation_code,
1001 'PAY_CA_EMP_PROV_TAX_INFO_F',
1002 'CA_TAX_INFORMATION24',
1003 p_old_CA_TAX_INFORMATION24,
1004 p_new_CA_TAX_INFORMATION24,
1005 p_effective_date
1006 );
1007 --
1008 pay_continuous_calc.event_update(p_business_group_id,
1009 p_legislation_code,
1010 'PAY_CA_EMP_PROV_TAX_INFO_F',
1011 'CA_TAX_INFORMATION25',
1012 p_old_CA_TAX_INFORMATION25,
1013 p_new_CA_TAX_INFORMATION25,
1014 p_effective_date
1015 );
1016 --
1017 pay_continuous_calc.event_update(p_business_group_id,
1018 p_legislation_code,
1019 'PAY_CA_EMP_PROV_TAX_INFO_F',
1020 'CA_TAX_INFORMATION26',
1021 p_old_CA_TAX_INFORMATION26,
1022 p_new_CA_TAX_INFORMATION26,
1023 p_effective_date
1024 );
1025 --
1026 pay_continuous_calc.event_update(p_business_group_id,
1027 p_legislation_code,
1028 'PAY_CA_EMP_PROV_TAX_INFO_F',
1029 'CA_TAX_INFORMATION27',
1030 p_old_CA_TAX_INFORMATION27,
1031 p_new_CA_TAX_INFORMATION27,
1032 p_effective_date
1033 );
1034 --
1035 pay_continuous_calc.event_update(p_business_group_id,
1036 p_legislation_code,
1037 'PAY_CA_EMP_PROV_TAX_INFO_F',
1038 'CA_TAX_INFORMATION28',
1039 p_old_CA_TAX_INFORMATION28,
1040 p_new_CA_TAX_INFORMATION28,
1041 p_effective_date
1042 );
1043 --
1044 pay_continuous_calc.event_update(p_business_group_id,
1045 p_legislation_code,
1046 'PAY_CA_EMP_PROV_TAX_INFO_F',
1047 'CA_TAX_INFORMATION29',
1048 p_old_CA_TAX_INFORMATION29,
1049 p_new_CA_TAX_INFORMATION29,
1050 p_effective_date
1051 );
1052 --
1053 pay_continuous_calc.event_update(p_business_group_id,
1054 p_legislation_code,
1055 'PAY_CA_EMP_PROV_TAX_INFO_F',
1056 'CA_TAX_INFORMATION3',
1057 p_old_CA_TAX_INFORMATION3,
1058 p_new_CA_TAX_INFORMATION3,
1059 p_effective_date
1060 );
1061 --
1062 pay_continuous_calc.event_update(p_business_group_id,
1063 p_legislation_code,
1067 p_new_CA_TAX_INFORMATION30,
1064 'PAY_CA_EMP_PROV_TAX_INFO_F',
1065 'CA_TAX_INFORMATION30',
1066 p_old_CA_TAX_INFORMATION30,
1068 p_effective_date
1069 );
1070 --
1071 pay_continuous_calc.event_update(p_business_group_id,
1072 p_legislation_code,
1073 'PAY_CA_EMP_PROV_TAX_INFO_F',
1074 'CA_TAX_INFORMATION4',
1075 p_old_CA_TAX_INFORMATION4,
1076 p_new_CA_TAX_INFORMATION4,
1077 p_effective_date
1078 );
1079 --
1080 pay_continuous_calc.event_update(p_business_group_id,
1081 p_legislation_code,
1082 'PAY_CA_EMP_PROV_TAX_INFO_F',
1083 'CA_TAX_INFORMATION5',
1084 p_old_CA_TAX_INFORMATION5,
1085 p_new_CA_TAX_INFORMATION5,
1086 p_effective_date
1087 );
1088 --
1089 pay_continuous_calc.event_update(p_business_group_id,
1090 p_legislation_code,
1091 'PAY_CA_EMP_PROV_TAX_INFO_F',
1092 'CA_TAX_INFORMATION6',
1093 p_old_CA_TAX_INFORMATION6,
1094 p_new_CA_TAX_INFORMATION6,
1095 p_effective_date
1096 );
1097 --
1098 pay_continuous_calc.event_update(p_business_group_id,
1099 p_legislation_code,
1100 'PAY_CA_EMP_PROV_TAX_INFO_F',
1101 'CA_TAX_INFORMATION7',
1102 p_old_CA_TAX_INFORMATION7,
1103 p_new_CA_TAX_INFORMATION7,
1104 p_effective_date
1105 );
1106 --
1107 pay_continuous_calc.event_update(p_business_group_id,
1108 p_legislation_code,
1109 'PAY_CA_EMP_PROV_TAX_INFO_F',
1110 'CA_TAX_INFORMATION8',
1111 p_old_CA_TAX_INFORMATION8,
1112 p_new_CA_TAX_INFORMATION8,
1113 p_effective_date
1114 );
1115 --
1116 pay_continuous_calc.event_update(p_business_group_id,
1117 p_legislation_code,
1118 'PAY_CA_EMP_PROV_TAX_INFO_F',
1119 'CA_TAX_INFORMATION9',
1120 p_old_CA_TAX_INFORMATION9,
1121 p_new_CA_TAX_INFORMATION9,
1122 p_effective_date
1123 );
1124 --
1125 pay_continuous_calc.event_update(p_business_group_id,
1126 p_legislation_code,
1127 'PAY_CA_EMP_PROV_TAX_INFO_F',
1128 'CA_TAX_INFORMATION_CATEGORY',
1129 p_old_CA_TAX_INFORMATION_CATEG,
1130 p_new_CA_TAX_INFORMATION_CATEG,
1131 p_effective_date
1132 );
1133 --
1134 pay_continuous_calc.event_update(p_business_group_id,
1135 p_legislation_code,
1136 'PAY_CA_EMP_PROV_TAX_INFO_F',
1137 'DEDUCTION_CODE',
1138 p_old_DEDUCTION_CODE,
1139 p_new_DEDUCTION_CODE,
1140 p_effective_date
1141 );
1142 --
1143 pay_continuous_calc.event_update(p_business_group_id,
1144 p_legislation_code,
1145 'PAY_CA_EMP_PROV_TAX_INFO_F',
1146 'DISABILITY_STATUS',
1147 p_old_DISABILITY_STATUS,
1148 p_new_DISABILITY_STATUS,
1149 p_effective_date
1150 );
1151 --
1152 pay_continuous_calc.event_update(p_business_group_id,
1153 p_legislation_code,
1154 'PAY_CA_EMP_PROV_TAX_INFO_F',
1155 'EMP_PROVINCE_TAX_INF_ID',
1156 p_old_EMP_PROVINCE_TAX_INF_ID,
1157 p_new_EMP_PROVINCE_TAX_INF_ID,
1158 p_effective_date
1159 );
1160 --
1161 pay_continuous_calc.event_update(p_business_group_id,
1162 p_legislation_code,
1163 'PAY_CA_EMP_PROV_TAX_INFO_F',
1164 'EXTRA_INFO_NOT_PROVIDED',
1165 p_old_EXTRA_INFO_NOT_PROVIDED,
1169 --
1166 p_new_EXTRA_INFO_NOT_PROVIDED,
1167 p_effective_date
1168 );
1170 pay_continuous_calc.event_update(p_business_group_id,
1171 p_legislation_code,
1172 'PAY_CA_EMP_PROV_TAX_INFO_F',
1173 'JURISDICTION_CODE',
1174 p_old_JURISDICTION_CODE,
1175 p_new_JURISDICTION_CODE,
1176 p_effective_date
1177 );
1178 --
1179 pay_continuous_calc.event_update(p_business_group_id,
1180 p_legislation_code,
1181 'PAY_CA_EMP_PROV_TAX_INFO_F',
1182 'LEGISLATION_CODE',
1183 p_old_LEGISLATION_CODE,
1184 p_new_LEGISLATION_CODE,
1185 p_effective_date
1186 );
1187 --
1188 pay_continuous_calc.event_update(p_business_group_id,
1189 p_legislation_code,
1190 'PAY_CA_EMP_PROV_TAX_INFO_F',
1191 'MARRIAGE_STATUS',
1192 p_old_MARRIAGE_STATUS,
1193 p_new_MARRIAGE_STATUS,
1194 p_effective_date
1195 );
1196 --
1197 pay_continuous_calc.event_update(p_business_group_id,
1198 p_legislation_code,
1199 'PAY_CA_EMP_PROV_TAX_INFO_F',
1200 'NON_RESIDENT_STATUS',
1201 p_old_NON_RESIDENT_STATUS,
1202 p_new_NON_RESIDENT_STATUS,
1203 p_effective_date
1204 );
1205 --
1206 pay_continuous_calc.event_update(p_business_group_id,
1207 p_legislation_code,
1208 'PAY_CA_EMP_PROV_TAX_INFO_F',
1209 'NO_OF_DEPENDANTS',
1210 p_old_NO_OF_DEPENDANTS,
1211 p_new_NO_OF_DEPENDANTS,
1212 p_effective_date
1213 );
1214 --
1215 pay_continuous_calc.event_update(p_business_group_id,
1216 p_legislation_code,
1217 'PAY_CA_EMP_PROV_TAX_INFO_F',
1218 'NO_OF_INFIRM_DEPENDANTS',
1219 p_old_NO_OF_INFIRM_DEPENDANTS,
1220 p_new_NO_OF_INFIRM_DEPENDANTS,
1221 p_effective_date
1222 );
1223 --
1224 pay_continuous_calc.event_update(p_business_group_id,
1225 p_legislation_code,
1226 'PAY_CA_EMP_PROV_TAX_INFO_F',
1227 'OTHER_TAX_CREDIT',
1228 p_old_OTHER_TAX_CREDIT,
1229 p_new_OTHER_TAX_CREDIT,
1230 p_effective_date
1231 );
1232 --
1233 pay_continuous_calc.event_update(p_business_group_id,
1234 p_legislation_code,
1235 'PAY_CA_EMP_PROV_TAX_INFO_F',
1236 'PMED_EXEMPT_FLAG',
1237 p_old_PMED_EXEMPT_FLAG,
1238 p_new_PMED_EXEMPT_FLAG,
1239 p_effective_date
1240 );
1241 --
1242 pay_continuous_calc.event_update(p_business_group_id,
1243 p_legislation_code,
1244 'PAY_CA_EMP_PROV_TAX_INFO_F',
1245 'PRESCRIBED_ZONE_DEDN_AMT',
1246 p_old_PRESCRIBED_ZONE_DEDN_AMT,
1247 p_new_PRESCRIBED_ZONE_DEDN_AMT,
1248 p_effective_date
1249 );
1250 --
1251 pay_continuous_calc.event_update(p_business_group_id,
1252 p_legislation_code,
1253 'PAY_CA_EMP_PROV_TAX_INFO_F',
1254 'PROVINCE_CODE',
1255 p_old_PROVINCE_CODE,
1256 p_new_PROVINCE_CODE,
1257 p_effective_date
1258 );
1259 --
1260 pay_continuous_calc.event_update(p_business_group_id,
1261 p_legislation_code,
1262 'PAY_CA_EMP_PROV_TAX_INFO_F',
1263 'PROV_EXEMPT_FLAG',
1264 p_old_PROV_EXEMPT_FLAG,
1265 p_new_PROV_EXEMPT_FLAG,
1266 p_effective_date
1267 );
1268 --
1269 pay_continuous_calc.event_update(p_business_group_id,
1270 p_legislation_code,
1271 'PAY_CA_EMP_PROV_TAX_INFO_F',
1272 'PROV_OVERRIDE_AMOUNT',
1273 p_old_PROV_OVERRIDE_AMOUNT,
1274 p_new_PROV_OVERRIDE_AMOUNT,
1275 p_effective_date
1276 );
1277 --
1278 pay_continuous_calc.event_update(p_business_group_id,
1279 p_legislation_code,
1280 'PAY_CA_EMP_PROV_TAX_INFO_F',
1281 'PROV_OVERRIDE_RATE',
1282 p_old_PROV_OVERRIDE_RATE,
1283 p_new_PROV_OVERRIDE_RATE,
1284 p_effective_date
1285 );
1286 --
1287 pay_continuous_calc.event_update(p_business_group_id,
1288 p_legislation_code,
1289 'PAY_CA_EMP_PROV_TAX_INFO_F',
1290 'QPP_EXEMPT_FLAG',
1291 p_old_QPP_EXEMPT_FLAG,
1292 p_new_QPP_EXEMPT_FLAG,
1293 p_effective_date
1294 );
1295 --
1296 pay_continuous_calc.event_update(p_business_group_id,
1297 p_legislation_code,
1298 'PAY_CA_EMP_PROV_TAX_INFO_F',
1299 'TAX_CALC_METHOD',
1300 p_old_TAX_CALC_METHOD,
1301 p_new_TAX_CALC_METHOD,
1302 p_effective_date
1303 );
1304 --
1305 pay_continuous_calc.event_update(p_business_group_id,
1306 p_legislation_code,
1307 'PAY_CA_EMP_PROV_TAX_INFO_F',
1308 'TAX_CREDIT_AMOUNT',
1309 p_old_TAX_CREDIT_AMOUNT,
1310 p_new_TAX_CREDIT_AMOUNT,
1311 p_effective_date
1312 );
1313 --
1314 pay_continuous_calc.event_update(p_business_group_id,
1315 p_legislation_code,
1316 'PAY_CA_EMP_PROV_TAX_INFO_F',
1317 'TOTAL_EXPENSE_BY_COMMISSION',
1318 p_old_TOTAL_EXPENSE_BY_COMMISS,
1319 p_new_TOTAL_EXPENSE_BY_COMMISS,
1320 p_effective_date
1321 );
1322 --
1323 pay_continuous_calc.event_update(p_business_group_id,
1324 p_legislation_code,
1325 'PAY_CA_EMP_PROV_TAX_INFO_F',
1326 'TOTAL_REMNRTN_BY_COMMISSION',
1327 p_old_TOTAL_REMNRTN_BY_COMMISS,
1328 p_new_TOTAL_REMNRTN_BY_COMMISS,
1329 p_effective_date
1330 );
1331 --
1332 pay_continuous_calc.event_update(p_business_group_id,
1333 p_legislation_code,
1334 'PAY_CA_EMP_PROV_TAX_INFO_F',
1335 'WC_EXEMPT_FLAG',
1336 p_old_WC_EXEMPT_FLAG,
1337 p_new_WC_EXEMPT_FLAG,
1338 p_effective_date
1339 );
1340 --
1341 pay_continuous_calc.event_update(p_business_group_id,
1342 p_legislation_code,
1343 'PAY_CA_EMP_PROV_TAX_INFO_F',
1344 'WC_EXEMPT_FLAG',
1345 p_old_WC_EXEMPT_FLAG,
1346 p_new_WC_EXEMPT_FLAG,
1347 p_effective_date
1348 );
1349 else
1350 /* OK it must be a date track change */
1351 --
1352 pay_continuous_calc.event_update(p_business_group_id,
1353 p_legislation_code,
1354 'PAY_CA_EMP_PROV_TAX_INFO_F',
1355 'EFFECTIVE_END_DATE',
1356 p_old_EFFECTIVE_END_DATE,
1357 p_new_EFFECTIVE_END_DATE,
1358 p_new_effective_end_date,
1359 least(p_old_effective_end_date,
1360 p_new_effective_end_date)
1361 );
1362 --
1363 pay_continuous_calc.event_update(p_business_group_id,
1364 p_legislation_code,
1365 'PAY_CA_EMP_PROV_TAX_INFO_F',
1366 'EFFECTIVE_START_DATE',
1367 p_old_EFFECTIVE_START_DATE,
1368 p_new_EFFECTIVE_START_DATE,
1369 p_new_effective_start_date,
1370 least(p_old_effective_start_date,
1371 p_new_effective_start_date)
1372 );
1373
1374 end if;
1375 --
1376 /* Now call the API for the affected assignments */
1377 declare
1378 l_process_event_id number;
1379 l_object_version_number number;
1380 cnt number;
1381 begin
1382 if (pay_continuous_calc.g_event_list.sz <> 0) then
1383 for cnt in 1..pay_continuous_calc.g_event_list.sz loop
1384 pay_ppe_api.create_process_event(
1385 p_assignment_id => p_old_assignment_id,
1386 p_effective_date => pay_continuous_calc.g_event_list.effective_date(cnt),
1387 p_change_type => pay_continuous_calc.g_event_list.change_type(cnt),
1388 p_status => 'U',
1389 p_description => pay_continuous_calc.g_event_list.description(cnt),
1390 p_process_event_id => l_process_event_id,
1391 p_object_version_number => l_object_version_number,
1392 p_event_update_id => pay_continuous_calc.g_event_list.event_update_id(cnt),
1393 p_business_group_id => p_business_group_id,
1394 p_surrogate_key => p_old_EMP_PROVINCE_TAX_INF_ID
1395 );
1396 end loop;
1397 end if;
1398 pay_continuous_calc.g_event_list.sz := 0;
1399 end;
1400 --
1401 end PAY_CA_EMP_PROV_TAX_INFO_F_aru;
1402 --
1403 end pay_ca_cont_calc;