389:
390: --
391: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
392: /* Mechanism for event capture to know whats occurred */
393: l_mode := pay_dyn_triggers.g_dyt_mode;
394: pay_dyn_triggers.g_dyt_mode :=
395: hr_api.g_insert;
396:
397: --
390: --
391: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
392: /* Mechanism for event capture to know whats occurred */
393: l_mode := pay_dyn_triggers.g_dyt_mode;
394: pay_dyn_triggers.g_dyt_mode :=
395: hr_api.g_insert;
396:
397: --
398:
416: );
417: end if;
418:
419: --
420: pay_dyn_triggers.g_dyt_mode :=
421: l_mode;
422:
423: --
424: EXCEPTION
423: --
424: EXCEPTION
425: WHEN OTHERS THEN
426: hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
427: pay_dyn_triggers.g_dyt_mode := l_mode;
428: RAISE;
429: --
430: END AFTER_INSERT;
431:
480:
481: --
482: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
483: /* Mechanism for event capture to know whats occurred */
484: l_mode := pay_dyn_triggers.g_dyt_mode;
485:
486: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
487:
488: --
482: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
483: /* Mechanism for event capture to know whats occurred */
484: l_mode := pay_dyn_triggers.g_dyt_mode;
485:
486: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
487:
488: --
489:
490: if (paywsdyg_pkg.trigger_enabled('PAY_USER_COLUMN_INSTANCES_F_ARU')) then
514: );
515: end if;
516:
517: --
518: pay_dyn_triggers.g_dyt_mode := l_mode;
519:
520: --
521: EXCEPTION
522: WHEN OTHERS THEN
520: --
521: EXCEPTION
522: WHEN OTHERS THEN
523: hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
524: pay_dyn_triggers.g_dyt_mode := l_mode;
525:
526: RAISE;
527: --
528: END AFTER_UPDATE;
576: --
577: hr_utility.trace(' >DYT: Main entry point from row handler,
578: AFTER_DELETE');
579: /* Mechanism for event capture to know whats occurred */
580: l_mode := pay_dyn_triggers.g_dyt_mode;
581: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
582:
583: --
584:
577: hr_utility.trace(' >DYT: Main entry point from row handler,
578: AFTER_DELETE');
579: /* Mechanism for event capture to know whats occurred */
580: l_mode := pay_dyn_triggers.g_dyt_mode;
581: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
582:
583: --
584:
585: if (paywsdyg_pkg.trigger_enabled('PAY_USER_COLUMN_INSTANCES_F_ARD')) then
606: );
607: end if;
608:
609: --
610: pay_dyn_triggers.g_dyt_mode := l_mode;
611:
612: --
613: EXCEPTION
614: WHEN OTHERS
613: EXCEPTION
614: WHEN OTHERS
615: THEN
616: hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
617: pay_dyn_triggers.g_dyt_mode := l_mode;
618: RAISE;
619: --
620: END AFTER_DELETE;
621: