69: L_BUSINESS_GROUP_ID NUMBER;
70: L_LEGISLATION_CODE VARCHAR2(10);
71: BEGIN
72:
73: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_ELEMENT_ENTRY_VALUES_F_ARU');
74: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
75: RETURN;
76: END IF;
77: /* INITIALISING LOCAL VARIABLES */
108: --
109: EXCEPTION
110: WHEN OTHERS THEN
111:
112: HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRY_VALUES_F_ARU',ABS(SQLCODE));
113: RAISE;
114: --
115: END PAY_ELEMENT_ENTRY_VALUES_F_ARU;
116:
157: /* LOCAL VARIABLE DECLARATIONS */
158: L_BUSINESS_GROUP_ID NUMBER;
159: L_LEGISLATION_CODE VARCHAR2(30);
160: BEGIN
161: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF
162: DYNAMIC TRIGGER: ES_SS_REP_ELEMENT_I');
163: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
164: RETURN;
165: END IF;
205: /* PAYROLL SPECIFIC COMPONENT CALLS */
206: --
207: EXCEPTION
208: WHEN OTHERS THEN
209: HR_UTILITY.SET_LOCATION('ES_SS_REP_ELEMENT_I_I',ABS(SQLCODE));
210: RAISE;
211: --
212: END ES_SS_REP_ELEMENT_I_I;
213:
254: /* LOCAL VARIABLE DECLARATIONS */
255: L_BUSINESS_GROUP_ID NUMBER;
256: L_LEGISLATION_CODE VARCHAR2(30);
257: BEGIN
258: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF
259: DYNAMIC TRIGGER: ES_SS_REP_ELEMENT_U');
260: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
261: RETURN;
262: END IF;
302: /* PAYROLL SPECIFIC COMPONENT CALLS */
303: --
304: EXCEPTION
305: WHEN OTHERS THEN
306: HR_UTILITY.SET_LOCATION('ES_SS_REP_ELEMENT_U_U',ABS(SQLCODE));
307: RAISE;
308: --
309: END ES_SS_REP_ELEMENT_U_U;
310:
351: --
352: BEGIN
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;
386:
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;
437: --
438: BEGIN
439:
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;
495:
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;
546: --
547: BEGIN
548:
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;
563: --
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;