eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LEGISLATION_BENEFITS dependencies on HR_LEGISLATION

Line 1: PACKAGE body hr_legislation_benefits AS

1: PACKAGE body hr_legislation_benefits AS
2: /* $Header: pelegben.pkb 120.2.12000000.1 2007/01/21 23:59:22 appldev ship $ */
3: --
4: -- Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.
5: --

Line 42: -- hr_legislation.insert_hr_stu_exceptions

38: -- (R10 version # 70.10)
39: -- 11.5.4 tmathers 07/20/99 Made v_seq_number and others size
40: -- 15, as 9 creates numeric overflow.
41: -- 115.5 T.Battoo 08-Feb-2000 changed crt_exc so calls
42: -- hr_legislation.insert_hr_stu_exceptions
43: -- 115.6 D.Vickers May 2001 Support for parallel hrglobal and
44: -- better debugging into HR_STU_EXCEPTIONS
45: -- 115.7 D.Vickers 14-Jun-2001 Bug fix 1803867
46: -- 115.8 D.Vickers 18-Jun-2001 to_chars on hr_s_app_ownerships

Line 76: l_current_proc varchar2(80) := 'hr_legislation.install_cobra_qfying_events';

72: -- details transferred into live tables. The parameter p_phase holds
73: -- the phase number.
74:
75: row_in_error exception;
76: l_current_proc varchar2(80) := 'hr_legislation.install_cobra_qfying_events';
77: l_new_cqe_id number(15);
78: l_null_return varchar2(1);
79:
80: CURSOR c_distinct

Line 216: hr_legislation.insert_hr_stu_exceptions('per_cobra_qfying_events_f'

212:
213:
214: rollback to new_qualifying_event;
215:
216: hr_legislation.insert_hr_stu_exceptions('per_cobra_qfying_events_f'
217: , r_distinct.c_surrogate_key
218: , exception_type
219: , r_distinct.c_true_key);
220:

Line 267: hr_legislation.hrrunprc_trace_on;

263: into l_new_cqe_id
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:

Line 269: hr_legislation.hrrunprc_trace_off;

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:
273: END;

Line 422: from hr_legislation_subgroups d

418: or
419: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
420: and exists (
421: select null
422: from hr_legislation_subgroups d
423: where d.legislation_code = r_distinct.c_leg_code
424: and d.legislation_subgroup = r_distinct.c_leg_sgrp
425: and d.active_inactive_flag = 'A' );
426: end if;

Line 702: hr_legislation.insert_hr_stu_exceptions('ben_benefit_classifications'

698: -- not be raised more than once.
699:
700: rollback to new_classification_name;
701:
702: hr_legislation.insert_hr_stu_exceptions('ben_benefit_classifications'
703: , stu_rec.c_surrogate_key
704: , exception_type
705: , stu_rec.c_true_key);
706:

Line 1108: hr_legislation.insert_hr_stu_exceptions('ben_valid_dependent_types'

1104: -- not be raised more than once.
1105:
1106: rollback to vdt;
1107:
1108: hr_legislation.insert_hr_stu_exceptions('ben_valid_dependent_types'
1109: , stu_rec.c_surrogate_key
1110: , exception_type
1111: , stu_rec.c_true_key);
1112:

Line 1436: hr_legislation.hrrunprc_trace_on;

1432: BEGIN
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;

Line 1440: hr_legislation.hrrunprc_trace_off;

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:
1444: hr_legislation.hrrunprc_trace_on;

Line 1444: hr_legislation.hrrunprc_trace_on;

1440: hr_legislation.hrrunprc_trace_off;
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

Line 1446: hr_legislation.hrrunprc_trace_off;

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:
1450: hr_legislation.hrrunprc_trace_on;

Line 1450: hr_legislation.hrrunprc_trace_on;

1446: hr_legislation.hrrunprc_trace_off;
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

Line 1452: hr_legislation.hrrunprc_trace_off;

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:
1456: hr_legislation.hrrunprc_trace_on;

Line 1456: hr_legislation.hrrunprc_trace_on;

1452: hr_legislation.hrrunprc_trace_off;
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;

Line 1458: hr_legislation.hrrunprc_trace_off;

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:
1462: END install;

Line 1464: end hr_legislation_benefits;

1460: END IF;
1461:
1462: END install;
1463:
1464: end hr_legislation_benefits;