353:
354: --
355: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
356: /* Mechanism for event capture to know whats occurred */
357: l_mode := pay_dyn_triggers.g_dyt_mode;
358: pay_dyn_triggers.g_dyt_mode :=
359: hr_api.g_insert;
360:
361: --
354: --
355: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
356: /* Mechanism for event capture to know whats occurred */
357: l_mode := pay_dyn_triggers.g_dyt_mode;
358: pay_dyn_triggers.g_dyt_mode :=
359: hr_api.g_insert;
360:
361: --
362:
381: end if;
382:
383: --
384:
385: pay_dyn_triggers.g_dyt_mode := l_mode;
386:
387: --
388: EXCEPTION
389: WHEN OTHERS THEN
387: --
388: EXCEPTION
389: WHEN OTHERS THEN
390: hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
391: pay_dyn_triggers.g_dyt_mode := l_mode;
392: RAISE;
393: --
394: END AFTER_INSERT;
395:
440: --
441: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
442: /* Mechanism for event capture to know whats occurred */
443: l_mode :=
444: pay_dyn_triggers.g_dyt_mode;
445: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
446:
447: --
448:
441: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
442: /* Mechanism for event capture to know whats occurred */
443: l_mode :=
444: pay_dyn_triggers.g_dyt_mode;
445: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
446:
447: --
448:
449: if (paywsdyg_pkg.trigger_enabled('PAY_ELEMENT_ENTRY_VALUES_F_ARU')) then
490: end if;
491:
492: --
493:
494: pay_dyn_triggers.g_dyt_mode := l_mode;
495:
496: --
497: EXCEPTION
498: WHEN OTHERS THEN
496: --
497: EXCEPTION
498: WHEN OTHERS THEN
499: hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
500: pay_dyn_triggers.g_dyt_mode := l_mode;
501: RAISE;
502: --
503: END AFTER_UPDATE;
504:
549: --
550: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_DELETE');
551: /* Mechanism for event capture to know whats occurred */
552: l_mode :=
553: pay_dyn_triggers.g_dyt_mode;
554: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
555:
556: --
557: /* no calls => no dynamic triggers of this type on this table */
550: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_DELETE');
551: /* Mechanism for event capture to know whats occurred */
552: l_mode :=
553: pay_dyn_triggers.g_dyt_mode;
554: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
555:
556: --
557: /* no calls => no dynamic triggers of this type on this table */
558: null;
557: /* no calls => no dynamic triggers of this type on this table */
558: null;
559:
560: --
561: pay_dyn_triggers.g_dyt_mode := l_mode;
562:
563: --
564: EXCEPTION
565: WHEN OTHERS THEN
564: EXCEPTION
565: WHEN OTHERS THEN
566:
567: hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
568: pay_dyn_triggers.g_dyt_mode := l_mode;
569: RAISE;
570: --
571: END AFTER_DELETE;
572: