DBA Data[Home] [Help]

APPS.PAY_DYT_USER_COLUMN_INSTA_PKG dependencies on PAY_DYN_TRIGGERS

Line 393: l_mode := pay_dyn_triggers.g_dyt_mode;

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

Line 394: pay_dyn_triggers.g_dyt_mode :=

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:

Line 420: pay_dyn_triggers.g_dyt_mode :=

416: );
417: end if;
418:
419: --
420: pay_dyn_triggers.g_dyt_mode :=
421: l_mode;
422:
423: --
424: EXCEPTION

Line 427: pay_dyn_triggers.g_dyt_mode := l_mode;

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:

Line 484: l_mode := pay_dyn_triggers.g_dyt_mode;

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

Line 486: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;

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

Line 518: pay_dyn_triggers.g_dyt_mode := l_mode;

514: );
515: end if;
516:
517: --
518: pay_dyn_triggers.g_dyt_mode := l_mode;
519:
520: --
521: EXCEPTION
522: WHEN OTHERS THEN

Line 524: pay_dyn_triggers.g_dyt_mode := l_mode;

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;

Line 580: l_mode := pay_dyn_triggers.g_dyt_mode;

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:

Line 581: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;

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

Line 610: pay_dyn_triggers.g_dyt_mode := l_mode;

606: );
607: end if;
608:
609: --
610: pay_dyn_triggers.g_dyt_mode := l_mode;
611:
612: --
613: EXCEPTION
614: WHEN OTHERS

Line 617: pay_dyn_triggers.g_dyt_mode := l_mode;

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: