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 dependencies on HR_LEGISLATION

Line 1: PACKAGE body hr_legislation AS

1: PACKAGE body hr_legislation AS
2: /* $Header: pelegins.pkb 120.13.12000000.3 2007/07/10 11:28:50 divicker ship $ */
3: --
4: -- Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.
5: --

Line 160: -- hr_legislation_local.translate_ele_dev_df

156: -- 115.20 tbattoo 01-NOV-99 bug 1058335, moved installation of mag_records
157: -- to a seperate procedure, and not as a child
158: -- of magnetic_records
159: -- 115.21 vmehta 10-nov-1999 added the call to
160: -- hr_legislation_local.translate_ele_dev_df
161: -- for transferring the balance type ids
162: -- element_type_ids stored in the
163: -- Element Developer DF
164: -- 115.22 tbattoo 01-NOV-99 bug 1058335, moved installation of mag_records

Line 176: -- hr_legislation.insert_hr_stu_exceptions

172: -- clause in transfer_row procedure.
173: -- 115.25 ablinko 08-DEC-99 Only delete rows with no buisness group
174: -- from pay_user_column_instances_f
175: -- 115.26 tbattoo 08-Feb-00 changed crt_exc so calls
176: -- hr_legislation.insert_hr_stu_exceptions
177: -- This is an autonomous transaction procedure
178: -- , so we dont loose error messages on rollback
179: -- 115.27 mreid 24-Feb-00 Added territory code to payment types
180: -- unique key checking.

Line 396: if hr_legislation.g_debug_cnt > 0 then

392: ------------------------------------------------------------------------------
393:
394: PROCEDURE hrrunprc_trace_on is
395: begin
396: if hr_legislation.g_debug_cnt > 0 then
397: hr_utility.trace_on(null, 'HRRUNPRC');
398: end if;
399: end;
400:

Line 403: if hr_legislation.g_debug_cnt > 0 then

399: end;
400:
401: PROCEDURE hrrunprc_trace_off is
402: begin
403: if hr_legislation.g_debug_cnt > 0 then
404: hr_utility.trace_off;
405: end if;
406: end;
407:

Line 754: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',

750: OR (v_sequence_number < v_max_live) THEN
751:
752: IF v_max_live > v_max_delivered THEN
753:
754: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',
755: v_sequence_number,
756: v_max_live);
757: ELSE
758:

Line 759: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',

755: v_sequence_number,
756: v_max_live);
757: ELSE
758:
759: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',
760: v_sequence_number,
761: v_max_delivered);
762: END IF;
763: END IF;

Line 1084: l_current_proc varchar2(80) := 'hr_legislation.install_bal_categories';

1080: PROCEDURE install_bal_categories (p_phase IN NUMBER)
1081: ----------------------------------------------------
1082: IS
1083: row_in_error exception;
1084: l_current_proc varchar2(80) := 'hr_legislation.install_bal_categories';
1085: l_new_balance_category_id number(15);
1086: l_null_return varchar2(1);
1087:
1088: CURSOR c_distinct

Line 1173: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',

1169: OR (v_sequence_number < v_max_live) THEN
1170:
1171: IF v_max_live > v_max_delivered THEN
1172:
1173: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',
1174: v_sequence_number,
1175: v_max_live);
1176: ELSE
1177:

Line 1178: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',

1174: v_sequence_number,
1175: v_max_live);
1176: ELSE
1177:
1178: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',
1179: v_sequence_number,
1180: v_max_delivered);
1181: END IF;
1182: END IF;

Line 1703: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',

1699: OR (v_sequence_number < v_max_live) THEN
1700:
1701: IF v_max_live > v_max_delivered THEN
1702:
1703: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',
1704: v_sequence_number,
1705: v_max_live);
1706: ELSE
1707:

Line 1708: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',

1704: v_sequence_number,
1705: v_max_live);
1706: ELSE
1707:
1708: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',
1709: v_sequence_number,
1710: v_max_delivered);
1711: END IF;
1712: END IF;

Line 1727: hr_legislation.munge_sequence('PAY_DEFINED_BALANCES_S',

1723: from dual;
1724:
1725: IF v_sequence_number BETWEEN v_min_delivered AND v_max_delivered THEN
1726:
1727: hr_legislation.munge_sequence('PAY_DEFINED_BALANCES_S',
1728: v_sequence_number,
1729: v_max_delivered);
1730:
1731: END IF;

Line 1940: from hr_legislation_subgroups d

1936: or
1937: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
1938: and exists (
1939: select null
1940: from hr_legislation_subgroups d
1941: where d.legislation_code = stu_rec.c_leg_code
1942: and d.legislation_subgroup = stu_rec.c_leg_sgrp
1943: and d.active_inactive_flag = 'A' );
1944: end if;

Line 2682: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',

2678: OR (v_sequence_number < v_max_live) THEN
2679:
2680: IF v_max_live > v_max_delivered THEN
2681:
2682: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',
2683: v_sequence_number,
2684: v_max_live);
2685: ELSE
2686:

Line 2687: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',

2683: v_sequence_number,
2684: v_max_live);
2685: ELSE
2686:
2687: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',
2688: v_sequence_number,
2689: v_max_delivered);
2690: END IF;
2691: END IF;

Line 2840: from hr_legislation_subgroups d

2836: or
2837: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
2838: and exists (
2839: select null
2840: from hr_legislation_subgroups d
2841: where d.legislation_code = stu_rec.c_leg_code
2842: and d.legislation_subgroup = stu_rec.c_leg_sgrp
2843: and d.active_inactive_flag = 'A' );
2844: end if;

Line 4149: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',

4145: OR (v_sequence_number < v_max_live) THEN
4146:
4147: IF v_max_live > v_max_delivered THEN
4148:
4149: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',
4150: v_sequence_number,
4151: v_max_live);
4152: ELSE
4153:

Line 4154: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',

4150: v_sequence_number,
4151: v_max_live);
4152: ELSE
4153:
4154: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',
4155: v_sequence_number,
4156: v_max_delivered);
4157: END IF;
4158: END IF;

Line 4361: l_current_proc varchar2(80) := 'hr_legislation.install_urows';

4357: PROCEDURE install_urows (p_phase IN NUMBER)
4358: -------------------------------------------
4359: IS
4360: row_in_error exception;
4361: l_current_proc varchar2(80) := 'hr_legislation.install_urows';
4362: l_new_user_row_id number(15);
4363: l_null_return varchar2(1);
4364: l_last_urow_id number(15);
4365:

Line 4496: hr_legislation.munge_sequence('PAY_USER_ROWS_S',

4492: OR (v_sequence_number < v_max_live) THEN
4493:
4494: IF v_max_live > v_max_delivered THEN
4495:
4496: hr_legislation.munge_sequence('PAY_USER_ROWS_S',
4497: v_sequence_number,
4498: v_max_live);
4499: ELSE
4500:

Line 4501: hr_legislation.munge_sequence('PAY_USER_ROWS_S',

4497: v_sequence_number,
4498: v_max_live);
4499: ELSE
4500:
4501: hr_legislation.munge_sequence('PAY_USER_ROWS_S',
4502: v_sequence_number,
4503: v_max_delivered);
4504: END IF;
4505: END IF;

Line 4826: from hr_legislation_subgroups d

4822: or
4823: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
4824: and exists (
4825: select null
4826: from hr_legislation_subgroups d
4827: where d.legislation_code = r_distinct.legislation_code
4828: and d.legislation_subgroup = r_distinct.legislation_subgroup
4829: and d.active_inactive_flag = 'A'
4830: );

Line 5249: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',

5245: OR (v_sequence_number < v_max_live) THEN
5246:
5247: IF v_max_live > v_max_delivered THEN
5248:
5249: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',
5250: v_sequence_number,
5251: v_max_live);
5252: ELSE
5253:

Line 5254: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',

5250: v_sequence_number,
5251: v_max_live);
5252: ELSE
5253:
5254: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',
5255: v_sequence_number,
5256: v_max_delivered);
5257: END IF;
5258: END IF;

Line 5810: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',

5806: OR (v_sequence_number < v_max_live) THEN
5807:
5808: IF v_max_live > v_max_delivered THEN
5809:
5810: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',
5811: v_sequence_number,
5812: v_max_live);
5813: ELSE
5814:

Line 5815: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',

5811: v_sequence_number,
5812: v_max_live);
5813: ELSE
5814:
5815: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',
5816: v_sequence_number,
5817: v_max_delivered);
5818: END IF;
5819: END IF;

Line 6222: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',

6218: OR (v_sequence_number < v_max_live) THEN
6219:
6220: IF v_max_live > v_max_delivered THEN
6221:
6222: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',
6223: v_sequence_number,
6224: v_max_live);
6225: ELSE
6226:

Line 6227: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',

6223: v_sequence_number,
6224: v_max_live);
6225: ELSE
6226:
6227: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',
6228: v_sequence_number,
6229: v_max_delivered);
6230: END IF;
6231: END IF;

Line 6443: hr_utility.trace('start hr_legislation.install: ' || to_char(p_phase));

6439: IF maintain_history(p_phase) THEN
6440:
6441: -- Install all formula ditionary
6442: hrrunprc_trace_on;
6443: hr_utility.trace('start hr_legislation.install: ' || to_char(p_phase));
6444: hr_utility.trace('start ff_data_dict.install: ' || to_char(p_phase));
6445: hrrunprc_trace_off;
6446: ff_data_dict.install(p_phase);
6447:

Line 6456: hr_utility.trace('start hr_legislation_benefits.install: ' || to_char(p_phase));

6452: install_past(p_phase);
6453:
6454: -- Benefits
6455: hrrunprc_trace_on;
6456: hr_utility.trace('start hr_legislation_benefits.install: ' || to_char(p_phase));
6457: hrrunprc_trace_off;
6458: hr_legislation_benefits.install(p_phase);
6459:
6460: -- Elements

Line 6458: hr_legislation_benefits.install(p_phase);

6454: -- Benefits
6455: hrrunprc_trace_on;
6456: hr_utility.trace('start hr_legislation_benefits.install: ' || to_char(p_phase));
6457: hrrunprc_trace_off;
6458: hr_legislation_benefits.install(p_phase);
6459:
6460: -- Elements
6461: hrrunprc_trace_on;
6462: hr_utility.trace('start hr_legislation_elements.install: ' || to_char(p_phase));

Line 6462: hr_utility.trace('start hr_legislation_elements.install: ' || to_char(p_phase));

6458: hr_legislation_benefits.install(p_phase);
6459:
6460: -- Elements
6461: hrrunprc_trace_on;
6462: hr_utility.trace('start hr_legislation_elements.install: ' || to_char(p_phase));
6463: hrrunprc_trace_off;
6464: hr_legislation_elements.install(p_phase);
6465:
6466: -- Install payment types

Line 6464: hr_legislation_elements.install(p_phase);

6460: -- Elements
6461: hrrunprc_trace_on;
6462: hr_utility.trace('start hr_legislation_elements.install: ' || to_char(p_phase));
6463: hrrunprc_trace_off;
6464: hr_legislation_elements.install(p_phase);
6465:
6466: -- Install payment types
6467: hrrunprc_trace_on;
6468: hr_utility.trace('start install_payment_types: ' || to_char(p_phase));

Line 6504: hr_utility.trace('start hr_legislation_local: ' || to_char(p_phase));

6500: install_bal_types(p_phase);
6501:
6502: -- Localization hook
6503: hrrunprc_trace_on;
6504: hr_utility.trace('start hr_legislation_local: ' || to_char(p_phase));
6505: hrrunprc_trace_off;
6506: hr_legislation_local.install(p_phase);
6507:
6508: -- Install hr org info details

Line 6506: hr_legislation_local.install(p_phase);

6502: -- Localization hook
6503: hrrunprc_trace_on;
6504: hr_utility.trace('start hr_legislation_local: ' || to_char(p_phase));
6505: hrrunprc_trace_off;
6506: hr_legislation_local.install(p_phase);
6507:
6508: -- Install hr org info details
6509: hrrunprc_trace_on;
6510: hr_utility.trace('start install_org_info: ' || to_char(p_phase));

Line 6600: hr_utility.trace('exit hr_legislation.install: ' || to_char(p_phase));

6596:
6597: END IF; -- end exception check
6598:
6599: hrrunprc_trace_on;
6600: hr_utility.trace('exit hr_legislation.install: ' || to_char(p_phase));
6601: hrrunprc_trace_off;
6602:
6603: ELSE -- error occured in maintain history
6604: rollback;

Line 7593: hr_utility.set_Location('hr_legislation.install2',20);

7589: install(1);
7590:
7591: -- check for the existance of any exceptions after phase 1
7592:
7593: hr_utility.set_Location('hr_legislation.install2',20);
7594:
7595: select count(*)
7596: into v_exception_counter
7597: from hr_stu_exceptions;

Line 7609: hr_utility.set_Location('hr_legislation.install2',40);

7605: END IF;
7606:
7607: -- perform phase 2 of the installation
7608:
7609: hr_utility.set_Location('hr_legislation.install2',40);
7610:
7611: install(2);
7612:
7613: -- check for the existance of exceptions after phase 2

Line 7615: hr_utility.set_Location('hr_legislation.install2',50);

7611: install(2);
7612:
7613: -- check for the existance of exceptions after phase 2
7614:
7615: hr_utility.set_Location('hr_legislation.install2',50);
7616:
7617: select count(*)
7618: into v_exception_counter
7619: from hr_stu_exceptions;

Line 7654: END hr_legislation;

7650: commit;
7651:
7652: END install;
7653:
7654: END hr_legislation;
7655: