APPS.PQP_GB_TP_EXTRACT_TRIGGERS dependencies on PAY_CONTINUOUS_CALC

Line 163: if (pay_continuous_calc.g_override_cc = TRUE) then

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 */

Line 171: pay_continuous_calc.event_update(p_business_group_id

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

Line 180: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 189: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 198: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 207: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 216: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 225: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 234: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 243: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 252: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 261: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 270: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 279: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 288: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 297: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 306: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 315: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 324: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 333: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 342: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 351: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 360: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 369: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 378: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 387: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 396: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 405: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 414: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 423: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 432: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 441: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 450: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 459: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 468: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 477: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 486: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 495: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 504: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 513: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 522: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 531: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 540: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 549: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 558: pay_continuous_calc.event_update(p_business_group_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,

Line 567: pay_continuous_calc.event_update(p_business_group_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,

Line 576: pay_continuous_calc.event_update(p_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,

Line 585: pay_continuous_calc.event_update(p_business_group_id,

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_,

Line 594: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 603: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 612: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 621: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 630: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 639: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 648: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 657: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 666: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 675: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 684: pay_continuous_calc.event_update(p_business_group_id,

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_,

Line 693: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 702: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 711: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 720: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 729: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 738: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 747: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 756: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 765: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 774: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 783: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 792: pay_continuous_calc.event_update(p_business_group_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,

Line 801: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 810: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 819: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 830: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 841: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 859: if (pay_continuous_calc.g_event_list.sz <> 0) then

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),

Line 860: for cnt in 1..pay_continuous_calc.g_event_list.sz loop

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),

Line 863: p_effective_date => pay_continuous_calc.g_event_list.effective_date(cnt),

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,

Line 864: p_change_type => pay_continuous_calc.g_event_list.change_type(cnt),

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,

Line 866: p_description => pay_continuous_calc.g_event_list.description(cnt),

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,

Line 869: p_event_update_id => pay_continuous_calc.g_event_list.event_update_id(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: );

Line 871: p_calculation_date => pay_continuous_calc.g_event_list.calc_date(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;

Line 876: pay_continuous_calc.g_event_list.sz := 0;

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:

Line 905: IF (pay_continuous_calc.g_override_cc = TRUE) THEN

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);

Line 911: pay_continuous_calc.event_update

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

Line 929: IF (pay_continuous_calc.g_event_list.sz <> 0) THEN

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

Line 930: FOR cnt IN 1..pay_continuous_calc.g_event_list.sz

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 =>

Line 935: pay_continuous_calc.g_event_list.effective_date(cnt)

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 =>

Line 937: pay_continuous_calc.g_event_list.change_type(cnt)

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

Line 940: pay_continuous_calc.g_event_list.description(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)

Line 944: pay_continuous_calc.g_event_list.event_update_id(cnt)

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

Line 947: pay_continuous_calc.g_event_list.calc_date(cnt)

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;

Line 952: pay_continuous_calc.g_event_list.sz := 0;

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:

Line 980: if (pay_continuous_calc.g_override_cc = TRUE) then

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,

Line 984: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 1001: if (pay_continuous_calc.g_event_list.sz <> 0) then

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,

Line 1003: for cnt in 1..pay_continuous_calc.g_event_list.sz loop

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),

Line 1006: p_effective_date => pay_continuous_calc.g_event_list.effective_date(cnt),

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,

Line 1007: p_change_type => pay_continuous_calc.g_event_list.change_type(cnt),

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,

Line 1009: p_description => pay_continuous_calc.g_event_list.description(cnt),

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,

Line 1012: p_event_update_id => pay_continuous_calc.g_event_list.event_update_id(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: );

Line 1014: p_calculation_date => pay_continuous_calc.g_event_list.calc_date(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:

Line 1021: pay_continuous_calc.g_event_list.sz := 0;

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: