76: L_BUSINESS_GROUP_ID
77: NUMBER;
78: L_LEGISLATION_CODE VARCHAR2(30);
79: BEGIN
80: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_COST_ALLOCATIONS_F_ARD');
81: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
82: RETURN;
83: END IF;
84: /*
126: /* PAYROLL SPECIFIC COMPONENT CALLS */
127: --
128: EXCEPTION
129: WHEN OTHERS THEN
130: HR_UTILITY.SET_LOCATION('PAY_COST_ALLOCATIONS_F_ARD_ARD',ABS(SQLCODE));
131: RAISE;
132: --
133: END PAY_COST_ALLOCATIONS_F_ARD_ARD;
134:
179: /* LOCAL VARIABLE DECLARATIONS */
180: L_BUSINESS_GROUP_ID NUMBER;
181: L_LEGISLATION_CODE VARCHAR2(30);
182: BEGIN
183: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER:
184: PAY_COST_ALLOCATIONS_F_ARI');
185: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
186: RETURN;
187: END IF;
226: --
227: EXCEPTION
228: WHEN OTHERS THEN
229:
230: HR_UTILITY.SET_LOCATION('PAY_COST_ALLOCATIONS_F_ARI_ARI',ABS(SQLCODE));
231: RAISE;
232: --
233: END PAY_COST_ALLOCATIONS_F_ARI_ARI;
234:
294: L_BUSINESS_GROUP_ID NUMBER;
295:
296: L_LEGISLATION_CODE VARCHAR2(10);
297: BEGIN
298: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_COST_ALLOCATIONS_F_ARU');
299: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
300: RETURN;
301: END IF;
302: /* INITIALISING LOCAL
366: --
367: EXCEPTION
368: WHEN OTHERS THEN
369:
370: HR_UTILITY.SET_LOCATION('PAY_COST_ALLOCATIONS_F_ARU_ARU',ABS(SQLCODE));
371: RAISE;
372: --
373: END PAY_COST_ALLOCATIONS_F_ARU_ARU;
374:
418: --
419: BEGIN
420:
421: --
422: hr_utility.trace(' >DYT: Main entry point from row handler,
423: AFTER_INSERT');
424: /* Mechanism for event capture to know whats occurred */
425: l_mode := pay_dyn_triggers.g_dyt_mode;
426: pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;
457: --
458: EXCEPTION
459: WHEN OTHERS THEN
460:
461: hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
462: pay_dyn_triggers.g_dyt_mode := l_mode;
463: RAISE;
464: --
465: END AFTER_INSERT;
525: --
526: BEGIN
527:
528: --
529: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
530: /* Mechanism for event capture to know whats occurred */
531: l_mode :=
532: pay_dyn_triggers.g_dyt_mode;
533: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
579:
580: --
581: EXCEPTION
582: WHEN OTHERS THEN
583: hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
584: pay_dyn_triggers.g_dyt_mode := l_mode;
585: RAISE;
586: --
587: END AFTER_UPDATE;
636: --
637: BEGIN
638:
639: --
640: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_DELETE');
641: /* Mechanism for event capture to know whats occurred */
642: l_mode :=
643: pay_dyn_triggers.g_dyt_mode;
644: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
679: --
680: EXCEPTION
681: WHEN OTHERS
682: THEN
683: hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
684: pay_dyn_triggers.g_dyt_mode := l_mode;
685: RAISE;
686: --
687: END AFTER_DELETE;