264: from dual;
265:
266: WHEN TOO_MANY_ROWS THEN
267: hr_legislation.hrrunprc_trace_on;
268: hr_utility.trace('qualifying_event_id TMR: ' || r_distinct.c_true_key);
269: hr_legislation.hrrunprc_trace_off;
270: raise;
271:
272:
1433:
1434: IF p_phase = 1 OR p_phase =2 THEN
1435:
1436: hr_legislation.hrrunprc_trace_on;
1437: hr_utility.trace('start ben_install: ' || to_char(p_phase));
1438:
1439: hr_utility.trace('start install_cobra_qfying_events : ' || to_char(p_phase));
1440: hr_legislation.hrrunprc_trace_off;
1441:
1435:
1436: hr_legislation.hrrunprc_trace_on;
1437: hr_utility.trace('start ben_install: ' || to_char(p_phase));
1438:
1439: hr_utility.trace('start install_cobra_qfying_events : ' || to_char(p_phase));
1440: hr_legislation.hrrunprc_trace_off;
1441:
1442: install_cobra_qfying_events(p_phase); -- Cobra Qualifying Events
1443:
1441:
1442: install_cobra_qfying_events(p_phase); -- Cobra Qualifying Events
1443:
1444: hr_legislation.hrrunprc_trace_on;
1445: hr_utility.trace('start install_ben_class : ' || to_char(p_phase));
1446: hr_legislation.hrrunprc_trace_off;
1447:
1448: install_ben_class(p_phase); -- Benefit Classifications
1449:
1447:
1448: install_ben_class(p_phase); -- Benefit Classifications
1449:
1450: hr_legislation.hrrunprc_trace_on;
1451: hr_utility.trace('start install_valid_dep_type : ' || to_char(p_phase));
1452: hr_legislation.hrrunprc_trace_off;
1453:
1454: install_valid_dep_type(p_phase); -- Valid Dependent Types
1455:
1453:
1454: install_valid_dep_type(p_phase); -- Valid Dependent Types
1455:
1456: hr_legislation.hrrunprc_trace_on;
1457: hr_utility.trace('exit ben_install: ' || to_char(p_phase));
1458: hr_legislation.hrrunprc_trace_off;
1459:
1460: END IF;
1461: