DBA Data[Home] [Help]

APPS.PAY_DYT_CONTRACTS_PKG dependencies on PAY_DYN_TRIGGERS

Line 534: l_mode := pay_dyn_triggers.g_dyt_mode;

530: --
531: hr_utility.trace(' >DYT: Main entry point from
532: row handler, AFTER_INSERT');
533: /* Mechanism for event capture to know whats occurred */
534: l_mode := pay_dyn_triggers.g_dyt_mode;
535: pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;
536:
537: --
538: /* no calls => no dynamic triggers of this type on this table */

Line 535: pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;

531: hr_utility.trace(' >DYT: Main entry point from
532: row handler, AFTER_INSERT');
533: /* Mechanism for event capture to know whats occurred */
534: l_mode := pay_dyn_triggers.g_dyt_mode;
535: pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;
536:
537: --
538: /* no calls => no dynamic triggers of this type on this table */
539:

Line 543: pay_dyn_triggers.g_dyt_mode := l_mode;

539:
540: null;
541:
542: --
543: pay_dyn_triggers.g_dyt_mode := l_mode;
544:
545: --
546: EXCEPTION
547: WHEN OTHERS THEN

Line 549: pay_dyn_triggers.g_dyt_mode := l_mode;

545: --
546: EXCEPTION
547: WHEN OTHERS THEN
548: hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
549: pay_dyn_triggers.g_dyt_mode := l_mode;
550: RAISE;
551: --
552: END AFTER_INSERT;
553:

Line 745: l_mode := pay_dyn_triggers.g_dyt_mode;

741: --
742: hr_utility.trace(' >DYT: Main
743: entry point from row handler, AFTER_UPDATE');
744: /* Mechanism for event capture to know whats occurred */
745: l_mode := pay_dyn_triggers.g_dyt_mode;
746: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
747:
748: --
749:

Line 746: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;

742: hr_utility.trace(' >DYT: Main
743: entry point from row handler, AFTER_UPDATE');
744: /* Mechanism for event capture to know whats occurred */
745: l_mode := pay_dyn_triggers.g_dyt_mode;
746: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
747:
748: --
749:
750: if (paywsdyg_pkg.trigger_enabled('PER_CONTRACTS_F_ARU')) then

Line 916: pay_dyn_triggers.g_dyt_mode := l_mode;

912: );
913: end if;
914:
915: --
916: pay_dyn_triggers.g_dyt_mode := l_mode;
917:
918: --
919:
920: EXCEPTION

Line 923: pay_dyn_triggers.g_dyt_mode := l_mode;

919:
920: EXCEPTION
921: WHEN OTHERS THEN
922: hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
923: pay_dyn_triggers.g_dyt_mode := l_mode;
924: RAISE;
925: --
926: END AFTER_UPDATE;
927:

Line 1048: l_mode := pay_dyn_triggers.g_dyt_mode;

1044: --
1045: hr_utility.trace(' >DYT: Main entry
1046: point from row handler, AFTER_DELETE');
1047: /* Mechanism for event capture to know whats occurred */
1048: l_mode := pay_dyn_triggers.g_dyt_mode;
1049: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
1050:
1051: --
1052: /* no calls => no dynamic triggers of this type on this

Line 1049: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;

1045: hr_utility.trace(' >DYT: Main entry
1046: point from row handler, AFTER_DELETE');
1047: /* Mechanism for event capture to know whats occurred */
1048: l_mode := pay_dyn_triggers.g_dyt_mode;
1049: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
1050:
1051: --
1052: /* no calls => no dynamic triggers of this type on this
1053: table */

Line 1057: pay_dyn_triggers.g_dyt_mode := l_mode;

1053: table */
1054: null;
1055:
1056: --
1057: pay_dyn_triggers.g_dyt_mode := l_mode;
1058:
1059: --
1060: EXCEPTION
1061: WHEN OTHERS THEN

Line 1063: pay_dyn_triggers.g_dyt_mode := l_mode;

1059: --
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
1063: pay_dyn_triggers.g_dyt_mode := l_mode;
1064: RAISE;
1065: --
1066: END AFTER_DELETE;
1067: