DBA Data[Home] [Help]

APPS.PAY_DYT_DURATION_SUMMARY_PKG dependencies on HR_UTILITY

Line 64: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PQP_GAP_DURATION_SUMMARY_ARD');

60: L_DATE_START DATE;
61:
62: L_LEGISLATION_CODE VARCHAR2(30);
63: BEGIN
64: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PQP_GAP_DURATION_SUMMARY_ARD');
65: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
66: RETURN;
67: END IF;
68: /* INITIALISING LOCAL

Line 114: HR_UTILITY.SET_LOCATION('PQP_GAP_DURATION_SUMMARY_A_ARD',ABS(SQLCODE));

110: SPECIFIC COMPONENT CALLS */
111: --
112: EXCEPTION
113: WHEN OTHERS THEN
114: HR_UTILITY.SET_LOCATION('PQP_GAP_DURATION_SUMMARY_A_ARD',ABS(SQLCODE));
115: RAISE;
116: --
117: END PQP_GAP_DURATION_SUMMARY_A_ARD;
118:

Line 161: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PQP_GAP_DURATION_SUMMARY_ARI');

157: L_DATE_START
158: DATE;
159: L_LEGISLATION_CODE VARCHAR2(30);
160: BEGIN
161: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PQP_GAP_DURATION_SUMMARY_ARI');
162: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
163: RETURN;
164: END IF;
165:

Line 211: HR_UTILITY.SET_LOCATION('PQP_GAP_DURATION_SUMMARY_A_ARI',ABS(SQLCODE));

207: /* PAYROLL SPECIFIC COMPONENT CALLS */
208: --
209: EXCEPTION
210: WHEN OTHERS THEN
211: HR_UTILITY.SET_LOCATION('PQP_GAP_DURATION_SUMMARY_A_ARI',ABS(SQLCODE));
212: RAISE;
213: --
214: END PQP_GAP_DURATION_SUMMARY_A_ARI;
215:

Line 266: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE

262: L_BUSINESS_GROUP_ID NUMBER;
263: L_DATE_START DATE;
264: L_LEGISLATION_CODE VARCHAR2(30);
265: BEGIN
266: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE
267: VERSION OF DYNAMIC TRIGGER: PQP_GAP_DURATION_SUMMARY_ARU');
268: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
269: RETURN;
270: END IF;

Line 326: HR_UTILITY.SET_LOCATION('PQP_GAP_DURATION_SUMMARY_A_ARU',ABS(SQLCODE));

322: /* PAYROLL SPECIFIC COMPONENT CALLS */
323: --
324: EXCEPTION
325: WHEN OTHERS THEN
326: HR_UTILITY.SET_LOCATION('PQP_GAP_DURATION_SUMMARY_A_ARU',ABS(SQLCODE));
327:
328: RAISE;
329: --
330: END PQP_GAP_DURATION_SUMMARY_A_ARU;

Line 373: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');

369: --
370: BEGIN
371:
372: --
373: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
374:
375: /* Mechanism for event capture to know whats occurred */
376: l_mode := pay_dyn_triggers.g_dyt_mode;
377: pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;

Line 403: hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));

399: --
400: EXCEPTION
401: WHEN OTHERS THEN
402:
403: hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
404: pay_dyn_triggers.g_dyt_mode := l_mode;
405: RAISE;
406: --
407: END AFTER_INSERT;

Line 461: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');

457: --
458: BEGIN
459:
460: --
461: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
462:
463: /* Mechanism for event capture to know whats occurred */
464: l_mode := pay_dyn_triggers.g_dyt_mode;
465: pay_dyn_triggers.g_dyt_mode := hr_api.g_correction;

Line 500: hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));

496: --
497: EXCEPTION
498: WHEN OTHERS THEN
499:
500: hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
501: pay_dyn_triggers.g_dyt_mode := l_mode;
502: RAISE;
503: --
504: END AFTER_UPDATE;

Line 547: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_DELETE');

543: --
544: BEGIN
545:
546: --
547: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_DELETE');
548:
549: /* Mechanism for event capture to know whats occurred */
550: l_mode := pay_dyn_triggers.g_dyt_mode;
551: pay_dyn_triggers.g_dyt_mode := hr_api.g_zap;

Line 570: hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));

566:
567: --
568: EXCEPTION
569: WHEN OTHERS THEN
570: hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
571:
572: pay_dyn_triggers.g_dyt_mode := l_mode;
573: RAISE;
574: --