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