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_ELEMENTS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 4: -- INSTALLATION PROCEDURE FOR : PAY_ELEMENT_CLASSIFICATIONS

1: PACKAGE body hr_legislation_elements AS
2: /* $Header: pelegele.pkb 120.8.12000000.1 2007/01/21 23:59:27 appldev ship $ */
3: --****************************************************************************
4: -- INSTALLATION PROCEDURE FOR : PAY_ELEMENT_CLASSIFICATIONS
5: --****************************************************************************
6:
7: PROCEDURE install_ele_class(p_phase IN number)
8: ----------------------------------------------

Line 61: hr_legislation.insert_hr_stu_exceptions('pay_element_classifications'

57: -- not be raised more than once.
58:
59: rollback to new_classification_name;
60:
61: hr_legislation.insert_hr_stu_exceptions('pay_element_classifications'
62: , stu_rec.c_surrogate_key
63: , exception_type
64: , stu_rec.c_true_key);
65:

Line 104: from pay_element_classifications a

100:
101:
102: select distinct null
103: into l_null_return
104: from pay_element_classifications a
105: where exists
106: (select null
107: from hr_s_element_classifications b
108: where a.classification_id = b.classification_id

Line 153: select pay_element_classifications_s.nextval

149: into v_min_delivered
150: , v_max_delivered
151: from hr_s_element_classifications;
152:
153: select pay_element_classifications_s.nextval
154: into v_sequence_number
155: from dual;
156:
157: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered) THEN

Line 159: hr_legislation.munge_sequence('PAY_ELEMENT_CLASSIFICATIONS_S',

155: from dual;
156:
157: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered) THEN
158:
159: hr_legislation.munge_sequence('PAY_ELEMENT_CLASSIFICATIONS_S',
160: v_sequence_number,
161: v_max_delivered);
162: END IF;
163:

Line 223: from pay_element_classifications

219: BEGIN
220:
221: select null
222: into l_null_return
223: from pay_element_classifications
224: where classification_id = stu_rec.parent_classification_id;
225:
226: return TRUE;
227:

Line 251: from pay_element_classifications

247:
248:
249: select distinct classification_id
250: into l_new_surrogate_key
251: from pay_element_classifications
252: where classification_name = stu_rec.c_true_key
253: and business_group_id is null
254: and ( (legislation_code is null
255: and stu_rec.c_leg_code is null)

Line 261: select pay_element_classifications_s.nextval

257:
258: EXCEPTION WHEN NO_DATA_FOUND THEN
259:
260:
261: select pay_element_classifications_s.nextval
262: into l_new_surrogate_key
263: from dual;
264:
265: WHEN TOO_MANY_ROWS THEN

Line 268: hr_utility.trace('sel pay_element_classifications TMR');

264:
265: WHEN TOO_MANY_ROWS THEN
266:
267: hr_legislation.hrrunprc_trace_on;
268: hr_utility.trace('sel pay_element_classifications TMR');
269:
270: hr_utility.trace('classification_name ' ||
271: stu_rec.c_true_key);
272: hr_utility.trace(':lc: ' || ':' ||

Line 442: from pay_element_classifications a

438: -- already been created by a user.
439:
440: select distinct null
441: into l_null_return
442: from pay_element_classifications a
443: where a.classification_name = stu_rec.c_true_key
444: and a.business_group_id is not null
445: and exists (select null from per_business_groups b
446: where b.business_group_id = a.business_group_id

Line 476: from pay_element_classifications

472: BEGIN
473:
474: select distinct null
475: into l_null_return
476: from pay_element_classifications
477: where classification_name = stu_rec.c_true_key
478: and nvl(legislation_code,'x') <> nvl(stu_rec.c_leg_code,'x')
479: and (legislation_code is null or stu_rec.c_leg_code is null )
480: and business_group_id is null;

Line 529: update pay_element_classifications

525: return;
526: END IF;
527:
528:
529: update pay_element_classifications
530: set classification_name = stu_rec.c_true_key
531: , legislation_code = stu_rec.c_leg_code
532: , legislation_subgroup = stu_rec.c_leg_sgrp
533: , business_group_id = stu_rec.business_group_id

Line 556: insert into pay_element_classifications

552:
553: IF SQL%NOTFOUND THEN
554:
555: BEGIN
556: insert into pay_element_classifications
557: (classification_name
558: ,classification_id
559: ,legislation_code
560: ,legislation_subgroup

Line 605: hr_utility.trace('ins pay_element_classifications');

601: ,stu_rec.balance_initialization_flag
602: ,stu_rec.FREQ_RULE_ENABLED);
603: EXCEPTION WHEN OTHERS THEN
604: hr_legislation.hrrunprc_trace_on;
605: hr_utility.trace('ins pay_element_classifications');
606: hr_utility.trace('classification_name ' ||
607: stu_rec.c_true_key);
608: hr_utility.trace('classification_id ' ||
609: to_char(stu_rec.c_surrogate_key));

Line 1644: from pay_element_classifications

1640:
1641:
1642: select null
1643: into l_null_return
1644: from pay_element_classifications
1645: where classification_id = r_each_row.classification_id;
1646:
1647: EXCEPTION WHEN NO_DATA_FOUND THEN
1648:

Line 2394: from pay_element_classifications

2390: FOR s_rules IN sub_rules(r_distinct.c_surrogate_key) LOOP
2391:
2392: select null
2393: into l_null_return
2394: from pay_element_classifications
2395: where classification_id = s_rules.classification_id;
2396:
2397: BEGIN
2398: insert into pay_sub_classification_rules_f

Line 3189: from pay_element_classifications

3185:
3186:
3187: select null
3188: into l_null_return
3189: from pay_element_classifications
3190: where classification_id = ele_class.classification_id;
3191:
3192: BEGIN
3193: insert into pay_ele_classification_rules