eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_TP_EXTRACT_TRIGGERS dependencies on PAY_CONTINUOUS_CALC

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

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

Line 181: pay_continuous_calc.event_update(p_business_group_id

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

Line 190: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 199: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 208: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 217: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 226: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 235: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 244: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 253: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 262: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 271: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 280: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 289: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 298: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 307: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 316: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 325: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 334: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 343: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 352: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 361: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 370: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 379: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 388: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 397: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 406: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 415: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 424: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 433: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 442: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 451: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 460: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 469: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 478: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 487: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 496: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 505: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 514: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 523: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 532: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 541: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 550: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 559: pay_continuous_calc.event_update(p_business_group_id,

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,

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

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

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

Line 595: pay_continuous_calc.event_update(p_business_group_id,

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

Line 604: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 613: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 622: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 631: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 640: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 649: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 658: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 667: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 676: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 685: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 694: pay_continuous_calc.event_update(p_business_group_id,

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

Line 703: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 712: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 721: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 730: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 739: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 748: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 757: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 766: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 775: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 784: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 793: pay_continuous_calc.event_update(p_business_group_id,

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,

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

Line 811: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 820: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 829: /* pay_continuous_calc.event_update(p_business_group_id,

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,

Line 838: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 846: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 855: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 863: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 871: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 883: pay_continuous_calc.event_update(p_business_group_id,

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,

Line 894: pay_continuous_calc.event_update(p_business_group_id,

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,

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

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

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

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

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

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,

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

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,

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

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,

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

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

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

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:

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

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

Line 964: pay_continuous_calc.event_update

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

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

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

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

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

Line 988: pay_continuous_calc.g_event_list.effective_date(cnt)

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

Line 990: pay_continuous_calc.g_event_list.change_type(cnt)

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

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

Line 997: pay_continuous_calc.g_event_list.event_update_id(cnt)

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

Line 1000: pay_continuous_calc.g_event_list.calc_date(cnt)

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;

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

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:

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

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,

Line 1037: pay_continuous_calc.event_update(p_business_group_id,

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,

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

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,

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

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

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

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,

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

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,

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

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,

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

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

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

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: