[Home] [Help]
PACKAGE BODY: APPS.PQP_GB_TP_EXTRACT_TRIGGERS
Source
1 PACKAGE BODY pqp_gb_tp_extract_triggers AS
2 -- /* $Header: pqpgbtpt.pkb 120.1.12000000.2 2007/03/30 10:24:34 ckesanap noship $ */
3 --
4 --
5 --
6 PROCEDURE pqp_assignment_attribute_f_aru
7 (p_business_group_id in number
8 ,p_legislation_code in varchar2
9 ,p_effective_date in date
10 ,p_old_AAT_ATTRIBUTE1 in VARCHAR2
11 ,p_new_AAT_ATTRIBUTE1 in VARCHAR2
12 ,p_old_AAT_ATTRIBUTE10 in VARCHAR2
13 ,p_new_AAT_ATTRIBUTE10 in VARCHAR2
14 ,p_old_AAT_ATTRIBUTE11 in VARCHAR2
15 ,p_new_AAT_ATTRIBUTE11 in VARCHAR2
16 ,p_old_AAT_ATTRIBUTE12 in VARCHAR2
17 ,p_new_AAT_ATTRIBUTE12 in VARCHAR2
18 ,p_old_AAT_ATTRIBUTE13 in VARCHAR2
19 ,p_new_AAT_ATTRIBUTE13 in VARCHAR2
20 ,p_old_AAT_ATTRIBUTE14 in VARCHAR2
21 ,p_new_AAT_ATTRIBUTE14 in VARCHAR2
22 ,p_old_AAT_ATTRIBUTE15 in VARCHAR2
23 ,p_new_AAT_ATTRIBUTE15 in VARCHAR2
24 ,p_old_AAT_ATTRIBUTE16 in VARCHAR2
25 ,p_new_AAT_ATTRIBUTE16 in VARCHAR2
26 ,p_old_AAT_ATTRIBUTE17 in VARCHAR2
27 ,p_new_AAT_ATTRIBUTE17 in VARCHAR2
28 ,p_old_AAT_ATTRIBUTE18 in VARCHAR2
29 ,p_new_AAT_ATTRIBUTE18 in VARCHAR2
30 ,p_old_AAT_ATTRIBUTE19 in VARCHAR2
31 ,p_new_AAT_ATTRIBUTE19 in VARCHAR2
32 ,p_old_AAT_ATTRIBUTE2 in VARCHAR2
33 ,p_new_AAT_ATTRIBUTE2 in VARCHAR2
34 ,p_old_AAT_ATTRIBUTE20 in VARCHAR2
35 ,p_new_AAT_ATTRIBUTE20 in VARCHAR2
36 ,p_old_AAT_ATTRIBUTE3 in VARCHAR2
37 ,p_new_AAT_ATTRIBUTE3 in VARCHAR2
38 ,p_old_AAT_ATTRIBUTE4 in VARCHAR2
39 ,p_new_AAT_ATTRIBUTE4 in VARCHAR2
40 ,p_old_AAT_ATTRIBUTE5 in VARCHAR2
41 ,p_new_AAT_ATTRIBUTE5 in VARCHAR2
42 ,p_old_AAT_ATTRIBUTE6 in VARCHAR2
43 ,p_new_AAT_ATTRIBUTE6 in VARCHAR2
44 ,p_old_AAT_ATTRIBUTE7 in VARCHAR2
45 ,p_new_AAT_ATTRIBUTE7 in VARCHAR2
46 ,p_old_AAT_ATTRIBUTE8 in VARCHAR2
47 ,p_new_AAT_ATTRIBUTE8 in VARCHAR2
48 ,p_old_AAT_ATTRIBUTE9 in VARCHAR2
49 ,p_new_AAT_ATTRIBUTE9 in VARCHAR2
50 ,p_old_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
51 ,p_new_AAT_ATTRIBUTE_CATEGORY in VARCHAR2
52 ,p_old_AAT_INFORMATION1 in VARCHAR2
53 ,p_new_AAT_INFORMATION1 in VARCHAR2
54 ,p_old_AAT_INFORMATION10 in VARCHAR2
55 ,p_new_AAT_INFORMATION10 in VARCHAR2
56 ,p_old_AAT_INFORMATION11 in VARCHAR2
57 ,p_new_AAT_INFORMATION11 in VARCHAR2
58 ,p_old_AAT_INFORMATION12 in VARCHAR2
59 ,p_new_AAT_INFORMATION12 in VARCHAR2
60 ,p_old_AAT_INFORMATION13 in VARCHAR2
61 ,p_new_AAT_INFORMATION13 in VARCHAR2
62 ,p_old_AAT_INFORMATION14 in VARCHAR2
63 ,p_new_AAT_INFORMATION14 in VARCHAR2
64 ,p_old_AAT_INFORMATION15 in VARCHAR2
65 ,p_new_AAT_INFORMATION15 in VARCHAR2
66 ,p_old_AAT_INFORMATION16 in VARCHAR2
67 ,p_new_AAT_INFORMATION16 in VARCHAR2
68 ,p_old_AAT_INFORMATION17 in VARCHAR2
69 ,p_new_AAT_INFORMATION17 in VARCHAR2
70 ,p_old_AAT_INFORMATION18 in VARCHAR2
71 ,p_new_AAT_INFORMATION18 in VARCHAR2
72 ,p_old_AAT_INFORMATION19 in VARCHAR2
73 ,p_new_AAT_INFORMATION19 in VARCHAR2
74 ,p_old_AAT_INFORMATION2 in VARCHAR2
75 ,p_new_AAT_INFORMATION2 in VARCHAR2
76 ,p_old_AAT_INFORMATION20 in VARCHAR2
77 ,p_new_AAT_INFORMATION20 in VARCHAR2
78 ,p_old_AAT_INFORMATION3 in VARCHAR2
79 ,p_new_AAT_INFORMATION3 in VARCHAR2
80 ,p_old_AAT_INFORMATION4 in VARCHAR2
81 ,p_new_AAT_INFORMATION4 in VARCHAR2
82 ,p_old_AAT_INFORMATION5 in VARCHAR2
83 ,p_new_AAT_INFORMATION5 in VARCHAR2
84 ,p_old_AAT_INFORMATION6 in VARCHAR2
85 ,p_new_AAT_INFORMATION6 in VARCHAR2
86 ,p_old_AAT_INFORMATION7 in VARCHAR2
87 ,p_new_AAT_INFORMATION7 in VARCHAR2
88 ,p_old_AAT_INFORMATION8 in VARCHAR2
89 ,p_new_AAT_INFORMATION8 in VARCHAR2
90 ,p_old_AAT_INFORMATION9 in VARCHAR2
91 ,p_new_AAT_INFORMATION9 in VARCHAR2
92 ,p_old_AAT_INFORMATION_CATEGORY in VARCHAR2
93 ,p_new_AAT_INFORMATION_CATEGORY in VARCHAR2
94 ,p_old_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
95 ,p_new_ASSIGNMENT_ATTRIBUTE_ID in NUMBER
96 ,p_old_ASSIGNMENT_ID in NUMBER
97 ,p_new_ASSIGNMENT_ID in NUMBER
98 ,p_old_BUSINESS_GROUP_ID in NUMBER
99 ,p_new_BUSINESS_GROUP_ID in NUMBER
100 ,p_old_COMPANY_CAR_CALC_METHOD in VARCHAR2
101 ,p_new_COMPANY_CAR_CALC_METHOD in VARCHAR2
102 ,p_old_COMPANY_CAR_RATES_TABLE_ in NUMBER
103 ,p_new_COMPANY_CAR_RATES_TABLE_ in NUMBER
104 ,p_old_COMPANY_CAR_SECONDARY_TA in NUMBER
105 ,p_new_COMPANY_CAR_SECONDARY_TA in NUMBER
106 ,p_old_CONTRACT_TYPE in VARCHAR2
107 ,p_new_CONTRACT_TYPE in VARCHAR2
108 ,p_old_PRIMARY_CAPITAL_CONTRIBU in NUMBER
109 ,p_new_PRIMARY_CAPITAL_CONTRIBU in NUMBER
110 ,p_old_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
111 ,p_new_PRIMARY_CAR_FUEL_BENEFIT in VARCHAR2
112 ,p_old_PRIMARY_CLASS_1A in VARCHAR2
113 ,p_new_PRIMARY_CLASS_1A in VARCHAR2
114 ,p_old_PRIMARY_COMPANY_CAR in NUMBER
115 ,p_new_PRIMARY_COMPANY_CAR in NUMBER
116 ,p_old_PRIMARY_PRIVATE_CONTRIBU in NUMBER
117 ,p_new_PRIMARY_PRIVATE_CONTRIBU in NUMBER
118 ,p_old_PRIVATE_CAR in NUMBER
119 ,p_new_PRIVATE_CAR in NUMBER
120 ,p_old_PRIVATE_CAR_CALC_METHOD in VARCHAR2
121 ,p_new_PRIVATE_CAR_CALC_METHOD in VARCHAR2
122 ,p_old_PRIVATE_CAR_ESSENTIAL_TA in NUMBER
123 ,p_new_PRIVATE_CAR_ESSENTIAL_TA in NUMBER
124 ,p_old_PRIVATE_CAR_RATES_TABLE_ in NUMBER
125 ,p_new_PRIVATE_CAR_RATES_TABLE_ in NUMBER
126 ,p_old_SECONDARY_CAPITAL_CONTRI in NUMBER
127 ,p_new_SECONDARY_CAPITAL_CONTRI in NUMBER
128 ,p_old_SECONDARY_CAR_FUEL_BENEF in VARCHAR2
129 ,p_new_SECONDARY_CAR_FUEL_BENEF in VARCHAR2
130 ,p_old_SECONDARY_CLASS_1A in VARCHAR2
131 ,p_new_SECONDARY_CLASS_1A in VARCHAR2
132 ,p_old_SECONDARY_COMPANY_CAR in NUMBER
133 ,p_new_SECONDARY_COMPANY_CAR in NUMBER
134 ,p_old_SECONDARY_PRIVATE_CONTRI in NUMBER
135 ,p_new_SECONDARY_PRIVATE_CONTRI in NUMBER
136 ,p_old_START_DAY in VARCHAR2
137 ,p_new_START_DAY in VARCHAR2
138 ,p_old_TP_ELECTED_PENSION in VARCHAR2
139 ,p_new_TP_ELECTED_PENSION in VARCHAR2
140 ,p_old_TP_FAST_TRACK in VARCHAR2
141 ,p_new_TP_FAST_TRACK in VARCHAR2
142 ,p_old_TP_IS_TEACHER in VARCHAR2
143 ,p_new_TP_IS_TEACHER in VARCHAR2
144 ,p_old_TP_SAFEGUARDED_GRADE in VARCHAR2
145 ,p_new_TP_SAFEGUARDED_GRADE in VARCHAR2
146 ,p_old_TP_SAFEGUARDED_RATE_ID in NUMBER
147 ,p_new_TP_SAFEGUARDED_RATE_ID in NUMBER
148 ,p_old_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
149 ,p_new_TP_SAFEGUARDED_RATE_TYPE in VARCHAR2
150 ,p_old_TP_SAFEGUARDED_SPINAL_PO in NUMBER
151 ,p_new_TP_SAFEGUARDED_SPINAL_PO in NUMBER
152 ,p_old_WORK_PATTERN in VARCHAR2
153 ,p_new_WORK_PATTERN in VARCHAR2
154 ,p_old_EFFECTIVE_END_DATE in DATE
155 ,p_new_EFFECTIVE_END_DATE in DATE
156 ,p_old_EFFECTIVE_START_DATE in DATE
157 ,p_new_EFFECTIVE_START_DATE in DATE
158 )
159 is
160 --
161 begin
162 /* If the continuous calc is overriden then do nothing */
163 if (pay_continuous_calc.g_override_cc = TRUE) then
164 return;
165 end if;
166 --
167 /* If the dates havent changed it must be a correction */
168 if (p_old_EFFECTIVE_END_DATE = p_new_EFFECTIVE_END_DATE
169 and p_old_EFFECTIVE_START_DATE = p_new_EFFECTIVE_START_DATE) then
170 --
171 pay_continuous_calc.event_update(p_business_group_id
172 ,p_legislation_code
173 ,'PQP_ASSIGNMENT_ATTRIBUTES_F'
174 ,'AAT_ATTRIBUTE1'
175 ,p_old_AAT_ATTRIBUTE1
176 ,p_new_AAT_ATTRIBUTE1
177 ,p_effective_date
178 );
179 --
180 pay_continuous_calc.event_update(p_business_group_id,
181 p_legislation_code,
182 'PQP_ASSIGNMENT_ATTRIBUTES_F',
183 'AAT_ATTRIBUTE10',
184 p_old_AAT_ATTRIBUTE10,
185 p_new_AAT_ATTRIBUTE10,
186 p_effective_date
187 );
188 --
189 pay_continuous_calc.event_update(p_business_group_id,
190 p_legislation_code,
191 'PQP_ASSIGNMENT_ATTRIBUTES_F',
192 'AAT_ATTRIBUTE11',
193 p_old_AAT_ATTRIBUTE11,
194 p_new_AAT_ATTRIBUTE11,
195 p_effective_date
196 );
197 --
198 pay_continuous_calc.event_update(p_business_group_id,
199 p_legislation_code,
200 'PQP_ASSIGNMENT_ATTRIBUTES_F',
201 'AAT_ATTRIBUTE12',
202 p_old_AAT_ATTRIBUTE12,
203 p_new_AAT_ATTRIBUTE12,
204 p_effective_date
205 );
206 --
207 pay_continuous_calc.event_update(p_business_group_id,
208 p_legislation_code,
209 'PQP_ASSIGNMENT_ATTRIBUTES_F',
210 'AAT_ATTRIBUTE13',
211 p_old_AAT_ATTRIBUTE13,
212 p_new_AAT_ATTRIBUTE13,
213 p_effective_date
214 );
215 --
216 pay_continuous_calc.event_update(p_business_group_id,
217 p_legislation_code,
218 'PQP_ASSIGNMENT_ATTRIBUTES_F',
219 'AAT_ATTRIBUTE14',
220 p_old_AAT_ATTRIBUTE14,
221 p_new_AAT_ATTRIBUTE14,
222 p_effective_date
223 );
224 --
225 pay_continuous_calc.event_update(p_business_group_id,
226 p_legislation_code,
227 'PQP_ASSIGNMENT_ATTRIBUTES_F',
228 'AAT_ATTRIBUTE15',
229 p_old_AAT_ATTRIBUTE15,
230 p_new_AAT_ATTRIBUTE15,
231 p_effective_date
232 );
233 --
234 pay_continuous_calc.event_update(p_business_group_id,
235 p_legislation_code,
236 'PQP_ASSIGNMENT_ATTRIBUTES_F',
237 'AAT_ATTRIBUTE16',
238 p_old_AAT_ATTRIBUTE16,
239 p_new_AAT_ATTRIBUTE16,
240 p_effective_date
241 );
242 --
243 pay_continuous_calc.event_update(p_business_group_id,
244 p_legislation_code,
245 'PQP_ASSIGNMENT_ATTRIBUTES_F',
246 'AAT_ATTRIBUTE17',
247 p_old_AAT_ATTRIBUTE17,
248 p_new_AAT_ATTRIBUTE17,
249 p_effective_date
250 );
251 --
252 pay_continuous_calc.event_update(p_business_group_id,
253 p_legislation_code,
254 'PQP_ASSIGNMENT_ATTRIBUTES_F',
255 'AAT_ATTRIBUTE18',
256 p_old_AAT_ATTRIBUTE18,
257 p_new_AAT_ATTRIBUTE18,
258 p_effective_date
259 );
260 --
261 pay_continuous_calc.event_update(p_business_group_id,
262 p_legislation_code,
263 'PQP_ASSIGNMENT_ATTRIBUTES_F',
264 'AAT_ATTRIBUTE19',
265 p_old_AAT_ATTRIBUTE19,
266 p_new_AAT_ATTRIBUTE19,
267 p_effective_date
268 );
269 --
270 pay_continuous_calc.event_update(p_business_group_id,
271 p_legislation_code,
272 'PQP_ASSIGNMENT_ATTRIBUTES_F',
273 'AAT_ATTRIBUTE2',
274 p_old_AAT_ATTRIBUTE2,
275 p_new_AAT_ATTRIBUTE2,
276 p_effective_date
277 );
278 --
279 pay_continuous_calc.event_update(p_business_group_id,
280 p_legislation_code,
281 'PQP_ASSIGNMENT_ATTRIBUTES_F',
282 'AAT_ATTRIBUTE20',
283 p_old_AAT_ATTRIBUTE20,
284 p_new_AAT_ATTRIBUTE20,
285 p_effective_date
286 );
287 --
288 pay_continuous_calc.event_update(p_business_group_id,
289 p_legislation_code,
290 'PQP_ASSIGNMENT_ATTRIBUTES_F',
291 'AAT_ATTRIBUTE3',
292 p_old_AAT_ATTRIBUTE3,
293 p_new_AAT_ATTRIBUTE3,
294 p_effective_date
295 );
296 --
297 pay_continuous_calc.event_update(p_business_group_id,
298 p_legislation_code,
299 'PQP_ASSIGNMENT_ATTRIBUTES_F',
300 'AAT_ATTRIBUTE4',
301 p_old_AAT_ATTRIBUTE4,
302 p_new_AAT_ATTRIBUTE4,
303 p_effective_date
304 );
305 --
306 pay_continuous_calc.event_update(p_business_group_id,
307 p_legislation_code,
308 'PQP_ASSIGNMENT_ATTRIBUTES_F',
309 'AAT_ATTRIBUTE5',
310 p_old_AAT_ATTRIBUTE5,
311 p_new_AAT_ATTRIBUTE5,
312 p_effective_date
313 );
314 --
315 pay_continuous_calc.event_update(p_business_group_id,
316 p_legislation_code,
317 'PQP_ASSIGNMENT_ATTRIBUTES_F',
318 'AAT_ATTRIBUTE6',
319 p_old_AAT_ATTRIBUTE6,
320 p_new_AAT_ATTRIBUTE6,
321 p_effective_date
322 );
323 --
324 pay_continuous_calc.event_update(p_business_group_id,
325 p_legislation_code,
326 'PQP_ASSIGNMENT_ATTRIBUTES_F',
327 'AAT_ATTRIBUTE7',
328 p_old_AAT_ATTRIBUTE7,
329 p_new_AAT_ATTRIBUTE7,
330 p_effective_date
331 );
332 --
333 pay_continuous_calc.event_update(p_business_group_id,
334 p_legislation_code,
335 'PQP_ASSIGNMENT_ATTRIBUTES_F',
336 'AAT_ATTRIBUTE8',
337 p_old_AAT_ATTRIBUTE8,
338 p_new_AAT_ATTRIBUTE8,
339 p_effective_date
340 );
341 --
342 pay_continuous_calc.event_update(p_business_group_id,
343 p_legislation_code,
344 'PQP_ASSIGNMENT_ATTRIBUTES_F',
345 'AAT_ATTRIBUTE9',
346 p_old_AAT_ATTRIBUTE9,
347 p_new_AAT_ATTRIBUTE9,
348 p_effective_date
349 );
350 --
351 pay_continuous_calc.event_update(p_business_group_id,
352 p_legislation_code,
353 'PQP_ASSIGNMENT_ATTRIBUTES_F',
354 'AAT_ATTRIBUTE_CATEGORY',
355 p_old_AAT_ATTRIBUTE_CATEGORY,
356 p_new_AAT_ATTRIBUTE_CATEGORY,
357 p_effective_date
358 );
359 --
360 pay_continuous_calc.event_update(p_business_group_id,
361 p_legislation_code,
362 'PQP_ASSIGNMENT_ATTRIBUTES_F',
363 'AAT_INFORMATION1',
364 p_old_AAT_INFORMATION1,
365 p_new_AAT_INFORMATION1,
366 p_effective_date
367 );
368 --
369 pay_continuous_calc.event_update(p_business_group_id,
370 p_legislation_code,
371 'PQP_ASSIGNMENT_ATTRIBUTES_F',
372 'AAT_INFORMATION10',
373 p_old_AAT_INFORMATION10,
374 p_new_AAT_INFORMATION10,
375 p_effective_date
376 );
377 --
378 pay_continuous_calc.event_update(p_business_group_id,
379 p_legislation_code,
380 'PQP_ASSIGNMENT_ATTRIBUTES_F',
381 'AAT_INFORMATION11',
382 p_old_AAT_INFORMATION11,
383 p_new_AAT_INFORMATION11,
384 p_effective_date
385 );
386 --
387 pay_continuous_calc.event_update(p_business_group_id,
388 p_legislation_code,
389 'PQP_ASSIGNMENT_ATTRIBUTES_F',
390 'AAT_INFORMATION12',
391 p_old_AAT_INFORMATION12,
392 p_new_AAT_INFORMATION12,
393 p_effective_date
394 );
395 --
396 pay_continuous_calc.event_update(p_business_group_id,
397 p_legislation_code,
398 'PQP_ASSIGNMENT_ATTRIBUTES_F',
399 'AAT_INFORMATION13',
400 p_old_AAT_INFORMATION13,
401 p_new_AAT_INFORMATION13,
402 p_effective_date
403 );
404 --
405 pay_continuous_calc.event_update(p_business_group_id,
406 p_legislation_code,
407 'PQP_ASSIGNMENT_ATTRIBUTES_F',
408 'AAT_INFORMATION14',
409 p_old_AAT_INFORMATION14,
410 p_new_AAT_INFORMATION14,
411 p_effective_date
412 );
413 --
414 pay_continuous_calc.event_update(p_business_group_id,
415 p_legislation_code,
416 'PQP_ASSIGNMENT_ATTRIBUTES_F',
417 'AAT_INFORMATION15',
418 p_old_AAT_INFORMATION15,
419 p_new_AAT_INFORMATION15,
420 p_effective_date
421 );
422 --
423 pay_continuous_calc.event_update(p_business_group_id,
424 p_legislation_code,
425 'PQP_ASSIGNMENT_ATTRIBUTES_F',
426 'AAT_INFORMATION16',
427 p_old_AAT_INFORMATION16,
428 p_new_AAT_INFORMATION16,
429 p_effective_date
430 );
431 --
432 pay_continuous_calc.event_update(p_business_group_id,
433 p_legislation_code,
434 'PQP_ASSIGNMENT_ATTRIBUTES_F',
435 'AAT_INFORMATION17',
436 p_old_AAT_INFORMATION17,
437 p_new_AAT_INFORMATION17,
438 p_effective_date
439 );
440 --
441 pay_continuous_calc.event_update(p_business_group_id,
442 p_legislation_code,
443 'PQP_ASSIGNMENT_ATTRIBUTES_F',
444 'AAT_INFORMATION18',
445 p_old_AAT_INFORMATION18,
446 p_new_AAT_INFORMATION18,
447 p_effective_date
448 );
449 --
450 pay_continuous_calc.event_update(p_business_group_id,
451 p_legislation_code,
452 'PQP_ASSIGNMENT_ATTRIBUTES_F',
453 'AAT_INFORMATION19',
454 p_old_AAT_INFORMATION19,
455 p_new_AAT_INFORMATION19,
456 p_effective_date
457 );
458 --
459 pay_continuous_calc.event_update(p_business_group_id,
460 p_legislation_code,
461 'PQP_ASSIGNMENT_ATTRIBUTES_F',
462 'AAT_INFORMATION2',
463 p_old_AAT_INFORMATION2,
464 p_new_AAT_INFORMATION2,
465 p_effective_date
466 );
467 --
468 pay_continuous_calc.event_update(p_business_group_id,
469 p_legislation_code,
470 'PQP_ASSIGNMENT_ATTRIBUTES_F',
471 'AAT_INFORMATION20',
472 p_old_AAT_INFORMATION20,
473 p_new_AAT_INFORMATION20,
474 p_effective_date
475 );
476 --
477 pay_continuous_calc.event_update(p_business_group_id,
478 p_legislation_code,
479 'PQP_ASSIGNMENT_ATTRIBUTES_F',
480 'AAT_INFORMATION3',
481 p_old_AAT_INFORMATION3,
482 p_new_AAT_INFORMATION3,
483 p_effective_date
484 );
485 --
486 pay_continuous_calc.event_update(p_business_group_id,
487 p_legislation_code,
488 'PQP_ASSIGNMENT_ATTRIBUTES_F',
489 'AAT_INFORMATION4',
490 p_old_AAT_INFORMATION4,
491 p_new_AAT_INFORMATION4,
492 p_effective_date
493 );
494 --
495 pay_continuous_calc.event_update(p_business_group_id,
496 p_legislation_code,
497 'PQP_ASSIGNMENT_ATTRIBUTES_F',
498 'AAT_INFORMATION5',
499 p_old_AAT_INFORMATION5,
500 p_new_AAT_INFORMATION5,
501 p_effective_date
502 );
503 --
504 pay_continuous_calc.event_update(p_business_group_id,
505 p_legislation_code,
506 'PQP_ASSIGNMENT_ATTRIBUTES_F',
507 'AAT_INFORMATION6',
508 p_old_AAT_INFORMATION6,
509 p_new_AAT_INFORMATION6,
510 p_effective_date
511 );
512 --
513 pay_continuous_calc.event_update(p_business_group_id,
514 p_legislation_code,
515 'PQP_ASSIGNMENT_ATTRIBUTES_F',
516 'AAT_INFORMATION7',
517 p_old_AAT_INFORMATION7,
518 p_new_AAT_INFORMATION7,
519 p_effective_date
520 );
521 --
522 pay_continuous_calc.event_update(p_business_group_id,
523 p_legislation_code,
524 'PQP_ASSIGNMENT_ATTRIBUTES_F',
525 'AAT_INFORMATION8',
526 p_old_AAT_INFORMATION8,
527 p_new_AAT_INFORMATION8,
528 p_effective_date
529 );
530 --
531 pay_continuous_calc.event_update(p_business_group_id,
532 p_legislation_code,
533 'PQP_ASSIGNMENT_ATTRIBUTES_F',
534 'AAT_INFORMATION9',
535 p_old_AAT_INFORMATION9,
536 p_new_AAT_INFORMATION9,
537 p_effective_date
538 );
539 --
540 pay_continuous_calc.event_update(p_business_group_id,
541 p_legislation_code,
542 'PQP_ASSIGNMENT_ATTRIBUTES_F',
543 'AAT_INFORMATION_CATEGORY',
544 p_old_AAT_INFORMATION_CATEGORY,
545 p_new_AAT_INFORMATION_CATEGORY,
546 p_effective_date
547 );
548 --
549 pay_continuous_calc.event_update(p_business_group_id,
550 p_legislation_code,
551 'PQP_ASSIGNMENT_ATTRIBUTES_F',
552 'ASSIGNMENT_ATTRIBUTE_ID',
553 p_old_ASSIGNMENT_ATTRIBUTE_ID,
554 p_new_ASSIGNMENT_ATTRIBUTE_ID,
555 p_effective_date
556 );
557 --
558 pay_continuous_calc.event_update(p_business_group_id,
559 p_legislation_code,
560 'PQP_ASSIGNMENT_ATTRIBUTES_F',
561 'ASSIGNMENT_ID',
562 p_old_ASSIGNMENT_ID,
563 p_new_ASSIGNMENT_ID,
564 p_effective_date
565 );
566 --
567 pay_continuous_calc.event_update(p_business_group_id,
568 p_legislation_code,
569 'PQP_ASSIGNMENT_ATTRIBUTES_F',
570 'BUSINESS_GROUP_ID',
571 p_old_BUSINESS_GROUP_ID,
572 p_new_BUSINESS_GROUP_ID,
573 p_effective_date
574 );
575 --
576 pay_continuous_calc.event_update(p_business_group_id,
577 p_legislation_code,
578 'PQP_ASSIGNMENT_ATTRIBUTES_F',
579 'COMPANY_CAR_CALC_METHOD',
580 p_old_COMPANY_CAR_CALC_METHOD,
581 p_new_COMPANY_CAR_CALC_METHOD,
582 p_effective_date
583 );
584 --
585 pay_continuous_calc.event_update(p_business_group_id,
586 p_legislation_code,
587 'PQP_ASSIGNMENT_ATTRIBUTES_F',
588 'COMPANY_CAR_RATES_TABLE_ID',
589 p_old_COMPANY_CAR_RATES_TABLE_,
590 p_new_COMPANY_CAR_RATES_TABLE_,
591 p_effective_date
592 );
593 --
594 pay_continuous_calc.event_update(p_business_group_id,
595 p_legislation_code,
596 'PQP_ASSIGNMENT_ATTRIBUTES_F',
597 'COMPANY_CAR_SECONDARY_TABLE_ID',
598 p_old_COMPANY_CAR_SECONDARY_TA,
599 p_new_COMPANY_CAR_SECONDARY_TA,
600 p_effective_date
601 );
602 --
603 pay_continuous_calc.event_update(p_business_group_id,
604 p_legislation_code,
605 'PQP_ASSIGNMENT_ATTRIBUTES_F',
606 'CONTRACT_TYPE',
607 p_old_CONTRACT_TYPE,
608 p_new_CONTRACT_TYPE,
609 p_effective_date
610 );
611 --
612 pay_continuous_calc.event_update(p_business_group_id,
613 p_legislation_code,
614 'PQP_ASSIGNMENT_ATTRIBUTES_F',
615 'PRIMARY_CAPITAL_CONTRIBUTION',
616 p_old_PRIMARY_CAPITAL_CONTRIBU,
617 p_new_PRIMARY_CAPITAL_CONTRIBU,
618 p_effective_date
619 );
620 --
621 pay_continuous_calc.event_update(p_business_group_id,
622 p_legislation_code,
623 'PQP_ASSIGNMENT_ATTRIBUTES_F',
624 'PRIMARY_CAR_FUEL_BENEFIT',
625 p_old_PRIMARY_CAR_FUEL_BENEFIT,
626 p_new_PRIMARY_CAR_FUEL_BENEFIT,
627 p_effective_date
628 );
629 --
630 pay_continuous_calc.event_update(p_business_group_id,
631 p_legislation_code,
632 'PQP_ASSIGNMENT_ATTRIBUTES_F',
633 'PRIMARY_CLASS_1A',
634 p_old_PRIMARY_CLASS_1A,
635 p_new_PRIMARY_CLASS_1A,
636 p_effective_date
637 );
638 --
639 pay_continuous_calc.event_update(p_business_group_id,
640 p_legislation_code,
641 'PQP_ASSIGNMENT_ATTRIBUTES_F',
642 'PRIMARY_COMPANY_CAR',
643 p_old_PRIMARY_COMPANY_CAR,
644 p_new_PRIMARY_COMPANY_CAR,
645 p_effective_date
646 );
647 --
648 pay_continuous_calc.event_update(p_business_group_id,
649 p_legislation_code,
650 'PQP_ASSIGNMENT_ATTRIBUTES_F',
651 'PRIMARY_PRIVATE_CONTRIBUTION',
652 p_old_PRIMARY_PRIVATE_CONTRIBU,
653 p_new_PRIMARY_PRIVATE_CONTRIBU,
654 p_effective_date
655 );
656 --
657 pay_continuous_calc.event_update(p_business_group_id,
658 p_legislation_code,
659 'PQP_ASSIGNMENT_ATTRIBUTES_F',
660 'PRIVATE_CAR',
661 p_old_PRIVATE_CAR,
662 p_new_PRIVATE_CAR,
663 p_effective_date
664 );
665 --
666 pay_continuous_calc.event_update(p_business_group_id,
667 p_legislation_code,
668 'PQP_ASSIGNMENT_ATTRIBUTES_F',
669 'PRIVATE_CAR_CALC_METHOD',
670 p_old_PRIVATE_CAR_CALC_METHOD,
671 p_new_PRIVATE_CAR_CALC_METHOD,
672 p_effective_date
673 );
674 --
675 pay_continuous_calc.event_update(p_business_group_id,
676 p_legislation_code,
677 'PQP_ASSIGNMENT_ATTRIBUTES_F',
678 'PRIVATE_CAR_ESSENTIAL_TABLE_ID',
679 p_old_PRIVATE_CAR_ESSENTIAL_TA,
680 p_new_PRIVATE_CAR_ESSENTIAL_TA,
681 p_effective_date
682 );
683 --
684 pay_continuous_calc.event_update(p_business_group_id,
685 p_legislation_code,
686 'PQP_ASSIGNMENT_ATTRIBUTES_F',
687 'PRIVATE_CAR_RATES_TABLE_ID',
688 p_old_PRIVATE_CAR_RATES_TABLE_,
689 p_new_PRIVATE_CAR_RATES_TABLE_,
690 p_effective_date
691 );
692 --
693 pay_continuous_calc.event_update(p_business_group_id,
694 p_legislation_code,
695 'PQP_ASSIGNMENT_ATTRIBUTES_F',
696 'SECONDARY_CAPITAL_CONTRIBUTION',
697 p_old_SECONDARY_CAPITAL_CONTRI,
698 p_new_SECONDARY_CAPITAL_CONTRI,
699 p_effective_date
700 );
701 --
702 pay_continuous_calc.event_update(p_business_group_id,
703 p_legislation_code,
704 'PQP_ASSIGNMENT_ATTRIBUTES_F',
705 'SECONDARY_CAR_FUEL_BENEFIT',
706 p_old_SECONDARY_CAR_FUEL_BENEF,
707 p_new_SECONDARY_CAR_FUEL_BENEF,
708 p_effective_date
709 );
710 --
711 pay_continuous_calc.event_update(p_business_group_id,
712 p_legislation_code,
713 'PQP_ASSIGNMENT_ATTRIBUTES_F',
714 'SECONDARY_CLASS_1A',
715 p_old_SECONDARY_CLASS_1A,
716 p_new_SECONDARY_CLASS_1A,
717 p_effective_date
718 );
719 --
720 pay_continuous_calc.event_update(p_business_group_id,
721 p_legislation_code,
722 'PQP_ASSIGNMENT_ATTRIBUTES_F',
723 'SECONDARY_COMPANY_CAR',
724 p_old_SECONDARY_COMPANY_CAR,
725 p_new_SECONDARY_COMPANY_CAR,
726 p_effective_date
727 );
728 --
729 pay_continuous_calc.event_update(p_business_group_id,
730 p_legislation_code,
731 'PQP_ASSIGNMENT_ATTRIBUTES_F',
732 'SECONDARY_PRIVATE_CONTRIBUTION',
733 p_old_SECONDARY_PRIVATE_CONTRI,
734 p_new_SECONDARY_PRIVATE_CONTRI,
735 p_effective_date
736 );
737 --
738 pay_continuous_calc.event_update(p_business_group_id,
739 p_legislation_code,
740 'PQP_ASSIGNMENT_ATTRIBUTES_F',
741 'START_DAY',
742 p_old_START_DAY,
743 p_new_START_DAY,
744 p_effective_date
745 );
746 --
747 pay_continuous_calc.event_update(p_business_group_id,
748 p_legislation_code,
749 'PQP_ASSIGNMENT_ATTRIBUTES_F',
750 'TP_ELECTED_PENSION',
751 p_old_TP_ELECTED_PENSION,
752 p_new_TP_ELECTED_PENSION,
753 p_effective_date
754 );
755 --
756 pay_continuous_calc.event_update(p_business_group_id,
757 p_legislation_code,
758 'PQP_ASSIGNMENT_ATTRIBUTES_F',
759 'TP_FAST_TRACK',
760 p_old_TP_FAST_TRACK,
761 p_new_TP_FAST_TRACK,
762 p_effective_date
763 );
764 --
765 pay_continuous_calc.event_update(p_business_group_id,
766 p_legislation_code,
767 'PQP_ASSIGNMENT_ATTRIBUTES_F',
768 'TP_IS_TEACHER',
769 p_old_TP_IS_TEACHER,
770 p_new_TP_IS_TEACHER,
771 p_effective_date
772 );
773 --
774 pay_continuous_calc.event_update(p_business_group_id,
775 p_legislation_code,
776 'PQP_ASSIGNMENT_ATTRIBUTES_F',
777 'TP_SAFEGUARDED_GRADE',
778 p_old_TP_SAFEGUARDED_GRADE,
779 p_new_TP_SAFEGUARDED_GRADE,
780 p_effective_date
781 );
782 --
783 pay_continuous_calc.event_update(p_business_group_id,
784 p_legislation_code,
785 'PQP_ASSIGNMENT_ATTRIBUTES_F',
786 'TP_SAFEGUARDED_RATE_ID',
787 p_old_TP_SAFEGUARDED_RATE_ID,
788 p_new_TP_SAFEGUARDED_RATE_ID,
789 p_effective_date
790 );
791 --
792 pay_continuous_calc.event_update(p_business_group_id,
793 p_legislation_code,
794 'PQP_ASSIGNMENT_ATTRIBUTES_F',
795 'TP_SAFEGUARDED_RATE_TYPE',
796 p_old_TP_SAFEGUARDED_RATE_TYPE,
797 p_new_TP_SAFEGUARDED_RATE_TYPE,
798 p_effective_date
799 );
800 --
801 pay_continuous_calc.event_update(p_business_group_id,
802 p_legislation_code,
803 'PQP_ASSIGNMENT_ATTRIBUTES_F',
804 'TP_SAFEGUARDED_SPINAL_POINT_ID',
805 p_old_TP_SAFEGUARDED_SPINAL_PO,
806 p_new_TP_SAFEGUARDED_SPINAL_PO,
807 p_effective_date
808 );
809 --
810 pay_continuous_calc.event_update(p_business_group_id,
811 p_legislation_code,
812 'PQP_ASSIGNMENT_ATTRIBUTES_F',
813 'WORK_PATTERN',
814 p_old_WORK_PATTERN,
815 p_new_WORK_PATTERN,
816 p_effective_date
817 );
818 --
819 pay_continuous_calc.event_update(p_business_group_id,
820 p_legislation_code,
821 'PQP_ASSIGNMENT_ATTRIBUTES_F',
822 'WORK_PATTERN',
823 p_old_WORK_PATTERN,
824 p_new_WORK_PATTERN,
825 p_effective_date
826 );
827 else
828 /* OK it must be a date track change */
829 --
830 pay_continuous_calc.event_update(p_business_group_id,
831 p_legislation_code,
832 'PQP_ASSIGNMENT_ATTRIBUTES_F',
833 'EFFECTIVE_END_DATE',
834 p_old_EFFECTIVE_END_DATE,
835 p_new_EFFECTIVE_END_DATE,
836 p_new_effective_end_date,
837 least(p_old_effective_end_date,
838 p_new_effective_end_date)
839 );
840 --
841 pay_continuous_calc.event_update(p_business_group_id,
842 p_legislation_code,
843 'PQP_ASSIGNMENT_ATTRIBUTES_F',
844 'EFFECTIVE_START_DATE',
845 p_old_EFFECTIVE_START_DATE,
846 p_new_EFFECTIVE_START_DATE,
847 p_new_effective_start_date,
848 least(p_old_effective_start_date,
849 p_new_effective_start_date)
850 );
851 end if;
852 --
853 /* Now call the API for the affected assignments */
854 declare
855 l_process_event_id number;
856 l_object_version_number number;
857 cnt number;
858 begin
859 if (pay_continuous_calc.g_event_list.sz <> 0) then
860 for cnt in 1..pay_continuous_calc.g_event_list.sz loop
861 pay_ppe_api.create_process_event(
862 p_assignment_id => p_new_assignment_id,
863 p_effective_date => pay_continuous_calc.g_event_list.effective_date(cnt),
864 p_change_type => pay_continuous_calc.g_event_list.change_type(cnt),
865 p_status => 'U',
866 p_description => pay_continuous_calc.g_event_list.description(cnt),
867 p_process_event_id => l_process_event_id,
868 p_object_version_number => l_object_version_number,
869 p_event_update_id => pay_continuous_calc.g_event_list.event_update_id(cnt),
870 p_business_group_id => p_business_group_id,
871 p_calculation_date => pay_continuous_calc.g_event_list.calc_date(cnt),
872 p_surrogate_key => p_new_assignment_attribute_id
873 );
874 end loop;
875 end if;
876 pay_continuous_calc.g_event_list.sz := 0;
877 end;
878 --
879 END PQP_ASSIGNMENT_ATTRIBUTE_F_aru;
880
881 --
882 --
883 --
884 PROCEDURE pqp_assignment_attribute_f_ari
885 (p_business_group_id IN NUMBER
886 ,p_legislation_code IN VARCHAR2
887 ,p_effective_date IN DATE
888 ,p_new_assignment_attribute_id IN NUMBER
889 ,p_new_assignment_id IN NUMBER
890 ,p_new_effective_end_date IN DATE
891 ,p_new_effective_start_date IN DATE
892 )
893 IS
894 l_process_api BOOLEAN;
895 l_process_event_id NUMBER;
896 l_object_version_number NUMBER;
897 l_proc_name VARCHAR2(61):=
898 'pqp_gb_tp_extract_triggers.pqp_assignment_attribute_f_ari';
899 BEGIN
900 --
901
902 hr_utility.set_location(l_proc_name, 10);
903
904 /* If the continuous calc is overriden then do nothing */
905 IF (pay_continuous_calc.g_override_cc = TRUE) THEN
906 RETURN;
907 END IF;
908 --
909 hr_utility.set_location(l_proc_name, 20);
910 --
911 pay_continuous_calc.event_update
912 (p_business_group_id
913 ,p_legislation_code
914 ,'PQP_ASSIGNMENT_ATTRIBUTES_F'
915 ,NULL
916 ,NULL
917 ,NULL
918 ,p_new_effective_start_date
919 ,p_new_effective_start_date
920 ,'I'
921 );
922
923 /* Now call the API for the affected assignments */
924 DECLARE
925 cnt NUMBER;
926 l_process_event_id NUMBER;
927 l_object_version_number NUMBER;
928 BEGIN
929 IF (pay_continuous_calc.g_event_list.sz <> 0) THEN
930 FOR cnt IN 1..pay_continuous_calc.g_event_list.sz
931 LOOP
932 pay_ppe_api.create_process_event
933 (p_assignment_id => p_new_assignment_id
934 ,p_effective_date =>
935 pay_continuous_calc.g_event_list.effective_date(cnt)
936 ,p_change_type =>
937 pay_continuous_calc.g_event_list.change_type(cnt)
938 ,p_status => 'U'
939 ,p_description =>
940 pay_continuous_calc.g_event_list.description(cnt)
941 ,p_process_event_id => l_process_event_id
942 ,p_object_version_number => l_object_version_number
943 ,p_event_update_id =>
944 pay_continuous_calc.g_event_list.event_update_id(cnt)
945 ,p_surrogate_key => p_new_assignment_attribute_id
946 ,p_calculation_date =>
947 pay_continuous_calc.g_event_list.calc_date(cnt)
948 ,p_business_group_id => p_business_group_id
949 );
950 END LOOP;
951 END IF;
952 pay_continuous_calc.g_event_list.sz := 0;
953 END;
954 hr_utility.set_location(l_proc_name, 50);
955 END pqp_assignment_attribute_f_ari;
956
957 --
958 --
959 --
960
961 procedure pqp_assignment_attribute_f_ard(
962 p_business_group_id in number,
963 p_legislation_code in varchar2,
964 p_old_assignment_attribute_id in number,
965 p_old_effective_start_date in date,
966 p_new_effective_start_date in date,
967 p_old_effective_end_date in date,
968 p_new_effective_end_date in date,
969 p_old_assignment_id in number
970 )
971 is
972 l_process_event_id number;
973 l_object_version_number number;
974 l_effective_date date;
975 l_proc varchar2(240) := 'pqp_gb_tp_extract_triggers.pqp_assignment_attribute_f_ard';
976
977 begin
978 hr_utility.set_location(l_proc, 10);
979 /* If the continuous calc is overriden then do nothing */
980 if (pay_continuous_calc.g_override_cc = TRUE) then
981 return;
982 end if;
983
984 pay_continuous_calc.event_update(p_business_group_id,
985 p_legislation_code,
986 'PQP_ASSIGNMENT_ATTRIBUTES_F',
987 null,
988 null,
989 null,
990 p_old_effective_start_date,
991 p_old_effective_start_date,
992 'D' --l_mode
993 );
994
995 /* Now call the API for the affected assignments */
996 declare
997 cnt number;
998 l_process_event_id number;
999 l_object_version_number number;
1000 begin
1001 if (pay_continuous_calc.g_event_list.sz <> 0) then
1002 hr_utility.trace('> With in Create Process Event: ');
1003 for cnt in 1..pay_continuous_calc.g_event_list.sz loop
1004 pay_ppe_api.create_process_event(
1005 p_assignment_id => p_old_assignment_id,
1006 p_effective_date => pay_continuous_calc.g_event_list.effective_date(cnt),
1007 p_change_type => pay_continuous_calc.g_event_list.change_type(cnt),
1008 p_status => 'U',
1009 p_description => pay_continuous_calc.g_event_list.description(cnt),
1010 p_process_event_id => l_process_event_id,
1011 p_object_version_number => l_object_version_number,
1012 p_event_update_id => pay_continuous_calc.g_event_list.event_update_id(cnt),
1013 p_surrogate_key => p_old_assignment_attribute_id,
1014 p_calculation_date => pay_continuous_calc.g_event_list.calc_date(cnt),
1015 p_business_group_id => p_business_group_id
1016 );
1017
1018
1019 end loop;
1020 end if;
1021 pay_continuous_calc.g_event_list.sz := 0;
1022 end;
1023 hr_utility.set_location(l_proc, 900);
1024 END pqp_assignment_attribute_f_ard;
1025
1026 --
1027 --
1028 --
1029 END pqp_gb_tp_extract_triggers;