233:
234: L_BUSINESS_GROUP_ID NUMBER;
235: L_LEGISLATION_CODE VARCHAR2(10);
236: BEGIN
237: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_ELEMENT_ENTRIES_F_ARU');
238: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
239:
240: RETURN;
241: END IF;
271: /* PAYROLL SPECIFIC COMPONENT CALLS */
272: --
273: EXCEPTION
274: WHEN OTHERS THEN
275: HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRIES_F_ARU_ARU',ABS(SQLCODE));
276: RAISE;
277: --
278: END PAY_ELEMENT_ENTRIES_F_ARU_ARU;
279:
400: /* LOCAL VARIABLE DECLARATIONS */
401: L_BUSINESS_GROUP_ID NUMBER;
402: L_LEGISLATION_CODE VARCHAR2(10);
403: BEGIN
404: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER:
405: PAY_ELEMENT_ENTRIES_F_ARD');
406: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
407: RETURN;
408: END IF;
438: /* PAYROLL SPECIFIC COMPONENT CALLS */
439: --
440: EXCEPTION
441: WHEN OTHERS THEN
442: HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRIES_F_ARD_ARD',ABS(SQLCODE));
443: RAISE;
444: --
445: END
446: PAY_ELEMENT_ENTRIES_F_ARD_ARD;
566: L_BUSINESS_GROUP_ID NUMBER;
567:
568: L_LEGISLATION_CODE VARCHAR2(10);
569: BEGIN
570: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_ELEMENT_ENTRIES_F_ARI');
571: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
572: RETURN;
573: END IF;
574: /* INITIALISING LOCAL
604: --
605:
606: EXCEPTION
607: WHEN OTHERS THEN
608: HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRIES_F_ARI_ARI',ABS(SQLCODE));
609: RAISE;
610: --
611: END PAY_ELEMENT_ENTRIES_F_ARI_ARI;
612:
733: NUMBER;
734: L_EFFECTIVE_START_DATE DATE;
735: L_LEGISLATION_CODE VARCHAR2(30);
736: BEGIN
737: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PQP_PEE_LOG_ARI');
738: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
739: RETURN;
740:
741: END IF;
783: /* PAYROLL SPECIFIC COMPONENT CALLS */
784: --
785: EXCEPTION
786: WHEN OTHERS THEN
787: HR_UTILITY.SET_LOCATION('PQP_PEE_LOG_ARI_ARI',ABS(SQLCODE));
788: RAISE;
789:
790: --
791: END PQP_PEE_LOG_ARI_ARI;
915: --
916: BEGIN
917:
918: --
919: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
920: /* Mechanism for event capture to know whats occurred */
921: l_mode :=
922: pay_dyn_triggers.g_dyt_mode;
923: pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;
1133:
1134: --
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
1138: pay_dyn_triggers.g_dyt_mode := l_mode;
1139: RAISE;
1140: --
1141: END AFTER_INSERT;
1355: --
1356: BEGIN
1357:
1358: --
1359: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
1360: /* Mechanism for event capture to know whats occurred */
1361: l_mode := pay_dyn_triggers.g_dyt_mode;
1362: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
1363:
1560:
1561: --
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
1565: pay_dyn_triggers.g_dyt_mode := l_mode;
1566: RAISE;
1567: --
1568: END
1697: --
1698: BEGIN
1699:
1700: --
1701: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_DELETE');
1702: /* Mechanism for event capture to know whats occurred */
1703: l_mode := pay_dyn_triggers.g_dyt_mode;
1704: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
1705:
1814:
1815: --
1816: EXCEPTION
1817: WHEN OTHERS THEN
1818: hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
1819: pay_dyn_triggers.g_dyt_mode
1820: := l_mode;
1821: RAISE;
1822: --