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.

[Home] [Help]

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.17.12020000.4 2013/03/07 21:46:12 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 403: if hr_legislation.g_debug_cnt > 0 then

399: -- 120.13.12000000.5 divicker 04-MAR-2013 Pseudo seed support ------------------------------------------------------------------------------
400:
401: PROCEDURE hrrunprc_trace_on is
402: begin
403: if hr_legislation.g_debug_cnt > 0 then
404: hr_utility.trace_on(null, 'HRRUNPRC');
405: end if;
406: end;
407:

Line 410: if hr_legislation.g_debug_cnt > 0 then

406: end;
407:
408: PROCEDURE hrrunprc_trace_off is
409: begin
410: if hr_legislation.g_debug_cnt > 0 then
411: hr_utility.trace_off;
412: end if;
413: end;
414:

Line 545: IF hr_legislation.g_pseudo_enabled = 'Y' THEN

541: v_exists CHAR:='N';
542:
543: BEGIN
544:
545: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
546:
547: l_table_name := p_table_name;
548:
549: if p_trace is not null then

Line 959: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',

955: OR (v_sequence_number < v_max_live) THEN
956:
957: IF v_max_live > v_max_delivered THEN
958:
959: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',
960: v_sequence_number,
961: v_max_live);
962: ELSE
963:

Line 964: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',

960: v_sequence_number,
961: v_max_live);
962: ELSE
963:
964: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',
965: v_sequence_number,
966: v_max_delivered);
967: END IF;
968: END IF;

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

1285: PROCEDURE install_bal_categories (p_phase IN NUMBER)
1286: ----------------------------------------------------
1287: IS
1288: row_in_error exception;
1289: l_current_proc varchar2(80) := 'hr_legislation.install_bal_categories';
1290: l_new_balance_category_id number(15);
1291: l_null_return varchar2(1);
1292:
1293: CURSOR c_distinct

Line 1378: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',

1374: OR (v_sequence_number < v_max_live) THEN
1375:
1376: IF v_max_live > v_max_delivered THEN
1377:
1378: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',
1379: v_sequence_number,
1380: v_max_live);
1381: ELSE
1382:

Line 1383: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',

1379: v_sequence_number,
1380: v_max_live);
1381: ELSE
1382:
1383: hr_legislation.munge_sequence('PAY_BALANCE_CATEGORIES_S',
1384: v_sequence_number,
1385: v_max_delivered);
1386: END IF;
1387: END IF;

Line 1908: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',

1904: OR (v_sequence_number < v_max_live) THEN
1905:
1906: IF v_max_live > v_max_delivered THEN
1907:
1908: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',
1909: v_sequence_number,
1910: v_max_live);
1911: ELSE
1912:

Line 1913: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',

1909: v_sequence_number,
1910: v_max_live);
1911: ELSE
1912:
1913: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',
1914: v_sequence_number,
1915: v_max_delivered);
1916: END IF;
1917: END IF;

Line 1932: hr_legislation.munge_sequence('PAY_DEFINED_BALANCES_S',

1928: from dual;
1929:
1930: IF v_sequence_number BETWEEN v_min_delivered AND v_max_delivered THEN
1931:
1932: hr_legislation.munge_sequence('PAY_DEFINED_BALANCES_S',
1933: v_sequence_number,
1934: v_max_delivered);
1935:
1936: END IF;

Line 1968: IF hr_legislation.g_pseudo_enabled = 'Y' THEN

1964: BEGIN
1965:
1966: -- PSEUDO
1967: -- Error if we clash on delivered data to pseudo data present
1968: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
1969:
1970: -- Check if we have a pseduo seed clash if enabled
1971: -- Error handling is done in the procedure itself
1972: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => stu_rec.c_true_key,

Line 1972: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => stu_rec.c_true_key,

1968: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
1969:
1970: -- Check if we have a pseduo seed clash if enabled
1971: -- Error handling is done in the procedure itself
1972: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => stu_rec.c_true_key,
1973: P_TABLE_NAME => 'PAY_BALANCE_TYPES',
1974: P_LEGISLATION_CODE => stu_rec.c_leg_code);
1975: END IF;
1976:

Line 2157: from hr_legislation_subgroups d

2153: or
2154: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
2155: and exists (
2156: select null
2157: from hr_legislation_subgroups d
2158: where d.legislation_code = stu_rec.c_leg_code
2159: and d.legislation_subgroup = stu_rec.c_leg_sgrp
2160: and d.active_inactive_flag = 'A' );
2161: end if;

Line 2289: IF hr_legislation.g_pseudo_enabled = 'Y' THEN

2285: END;
2286:
2287: --PSEUDO
2288: -- Check to see if this will clash with pseduo seeded data only if enabled
2289: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
2290: -- Check if we have a pseduo seed clash if enabled
2291: -- Error handling is done in the procedure itself
2292: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => stu_rec.c_true_key,
2293: P_TABLE_NAME => 'PAY_BALANCE_TYPES',

Line 2292: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => stu_rec.c_true_key,

2288: -- Check to see if this will clash with pseduo seeded data only if enabled
2289: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
2290: -- Check if we have a pseduo seed clash if enabled
2291: -- Error handling is done in the procedure itself
2292: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => stu_rec.c_true_key,
2293: P_TABLE_NAME => 'PAY_BALANCE_TYPES',
2294: P_LEGISLATION_CODE => stu_rec.c_leg_code);
2295: END IF;
2296:

Line 2644: if hr_legislation.g_pseudo_enabled = 'Y' THEN

2640: -- in hr_s_balance_types but do not exist in
2641: -- hr_s_balance_feeds_f.
2642:
2643: --PSEUDO
2644: if hr_legislation.g_pseudo_enabled = 'Y' THEN
2645: -- only delete feeds that are Oracle seeded as pseudo seeded won't be redelivered
2646: delete from pay_balance_feeds_f pbf
2647: where pbf.balance_type_id = stu_rec.c_surrogate_key
2648: and pbf.business_group_id is null

Line 2928: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',

2924: OR (v_sequence_number < v_max_live) THEN
2925:
2926: IF v_max_live > v_max_delivered THEN
2927:
2928: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',
2929: v_sequence_number,
2930: v_max_live);
2931: ELSE
2932:

Line 2933: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',

2929: v_sequence_number,
2930: v_max_live);
2931: ELSE
2932:
2933: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',
2934: v_sequence_number,
2935: v_max_delivered);
2936: END IF;
2937: END IF;

Line 3086: from hr_legislation_subgroups d

3082: or
3083: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
3084: and exists (
3085: select null
3086: from hr_legislation_subgroups d
3087: where d.legislation_code = stu_rec.c_leg_code
3088: and d.legislation_subgroup = stu_rec.c_leg_sgrp
3089: and d.active_inactive_flag = 'A' );
3090: end if;

Line 4396: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',

4392: OR (v_sequence_number < v_max_live) THEN
4393:
4394: IF v_max_live > v_max_delivered THEN
4395:
4396: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',
4397: v_sequence_number,
4398: v_max_live);
4399: ELSE
4400:

Line 4401: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',

4397: v_sequence_number,
4398: v_max_live);
4399: ELSE
4400:
4401: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',
4402: v_sequence_number,
4403: v_max_delivered);
4404: END IF;
4405: END IF;

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

4607: PROCEDURE install_urows (p_phase IN NUMBER)
4608: -------------------------------------------
4609: IS
4610: row_in_error exception;
4611: l_current_proc varchar2(80) := 'hr_legislation.install_urows';
4612: l_new_user_row_id number(15);
4613: l_null_return varchar2(1);
4614: l_last_urow_id number(15);
4615:

Line 4746: hr_legislation.munge_sequence('PAY_USER_ROWS_S',

4742: OR (v_sequence_number < v_max_live) THEN
4743:
4744: IF v_max_live > v_max_delivered THEN
4745:
4746: hr_legislation.munge_sequence('PAY_USER_ROWS_S',
4747: v_sequence_number,
4748: v_max_live);
4749: ELSE
4750:

Line 4751: hr_legislation.munge_sequence('PAY_USER_ROWS_S',

4747: v_sequence_number,
4748: v_max_live);
4749: ELSE
4750:
4751: hr_legislation.munge_sequence('PAY_USER_ROWS_S',
4752: v_sequence_number,
4753: v_max_delivered);
4754: END IF;
4755: END IF;

Line 5076: from hr_legislation_subgroups d

5072: or
5073: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
5074: and exists (
5075: select null
5076: from hr_legislation_subgroups d
5077: where d.legislation_code = r_distinct.legislation_code
5078: and d.legislation_subgroup = r_distinct.legislation_subgroup
5079: and d.active_inactive_flag = 'A'
5080: );

Line 5499: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',

5495: OR (v_sequence_number < v_max_live) THEN
5496:
5497: IF v_max_live > v_max_delivered THEN
5498:
5499: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',
5500: v_sequence_number,
5501: v_max_live);
5502: ELSE
5503:

Line 5504: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',

5500: v_sequence_number,
5501: v_max_live);
5502: ELSE
5503:
5504: hr_legislation.munge_sequence('PAY_MONETARY_UNITS_S',
5505: v_sequence_number,
5506: v_max_delivered);
5507: END IF;
5508: END IF;

Line 6060: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',

6056: OR (v_sequence_number < v_max_live) THEN
6057:
6058: IF v_max_live > v_max_delivered THEN
6059:
6060: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',
6061: v_sequence_number,
6062: v_max_live);
6063: ELSE
6064:

Line 6065: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',

6061: v_sequence_number,
6062: v_max_live);
6063: ELSE
6064:
6065: hr_legislation.munge_sequence('PAY_MAGNETIC_BLOCKS_S',
6066: v_sequence_number,
6067: v_max_delivered);
6068: END IF;
6069: END IF;

Line 6472: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',

6468: OR (v_sequence_number < v_max_live) THEN
6469:
6470: IF v_max_live > v_max_delivered THEN
6471:
6472: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',
6473: v_sequence_number,
6474: v_max_live);
6475: ELSE
6476:

Line 6477: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',

6473: v_sequence_number,
6474: v_max_live);
6475: ELSE
6476:
6477: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',
6478: v_sequence_number,
6479: v_max_delivered);
6480: END IF;
6481: END IF;

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

6689: IF maintain_history(p_phase) THEN
6690:
6691: -- Install all formula ditionary
6692: hrrunprc_trace_on;
6693: hr_utility.trace('start hr_legislation.install: ' || to_char(p_phase));
6694: hr_utility.trace('start ff_data_dict.install: ' || to_char(p_phase));
6695: hrrunprc_trace_off;
6696: ff_data_dict.install(p_phase);
6697:

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

6702: install_past(p_phase);
6703:
6704: -- Benefits
6705: hrrunprc_trace_on;
6706: hr_utility.trace('start hr_legislation_benefits.install: ' || to_char(p_phase));
6707: hrrunprc_trace_off;
6708: hr_legislation_benefits.install(p_phase);
6709:
6710: -- Elements

Line 6708: hr_legislation_benefits.install(p_phase);

6704: -- Benefits
6705: hrrunprc_trace_on;
6706: hr_utility.trace('start hr_legislation_benefits.install: ' || to_char(p_phase));
6707: hrrunprc_trace_off;
6708: hr_legislation_benefits.install(p_phase);
6709:
6710: -- Elements
6711: hrrunprc_trace_on;
6712: hr_utility.trace('start hr_legislation_elements.install: ' || to_char(p_phase));

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

6708: hr_legislation_benefits.install(p_phase);
6709:
6710: -- Elements
6711: hrrunprc_trace_on;
6712: hr_utility.trace('start hr_legislation_elements.install: ' || to_char(p_phase));
6713: hrrunprc_trace_off;
6714: hr_legislation_elements.install(p_phase);
6715:
6716: -- Install payment types

Line 6714: hr_legislation_elements.install(p_phase);

6710: -- Elements
6711: hrrunprc_trace_on;
6712: hr_utility.trace('start hr_legislation_elements.install: ' || to_char(p_phase));
6713: hrrunprc_trace_off;
6714: hr_legislation_elements.install(p_phase);
6715:
6716: -- Install payment types
6717: hrrunprc_trace_on;
6718: hr_utility.trace('start install_payment_types: ' || to_char(p_phase));

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

6750: install_bal_types(p_phase);
6751:
6752: -- Localization hook
6753: hrrunprc_trace_on;
6754: hr_utility.trace('start hr_legislation_local: ' || to_char(p_phase));
6755: hrrunprc_trace_off;
6756: hr_legislation_local.install(p_phase);
6757:
6758: -- Install hr org info details

Line 6756: hr_legislation_local.install(p_phase);

6752: -- Localization hook
6753: hrrunprc_trace_on;
6754: hr_utility.trace('start hr_legislation_local: ' || to_char(p_phase));
6755: hrrunprc_trace_off;
6756: hr_legislation_local.install(p_phase);
6757:
6758: -- Install hr org info details
6759: hrrunprc_trace_on;
6760: hr_utility.trace('start install_org_info: ' || to_char(p_phase));

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

6846:
6847: END IF; -- end exception check
6848:
6849: hrrunprc_trace_on;
6850: hr_utility.trace('exit hr_legislation.install: ' || to_char(p_phase));
6851: hrrunprc_trace_off;
6852:
6853: ELSE -- error occured in maintain history
6854: rollback;

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

7847: install(1);
7848:
7849: -- check for the existance of any exceptions after phase 1
7850:
7851: hr_utility.set_Location('hr_legislation.install2',20);
7852:
7853: select count(*)
7854: into v_exception_counter
7855: from hr_stu_exceptions;

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

7863: END IF;
7864:
7865: -- perform phase 2 of the installation
7866:
7867: hr_utility.set_Location('hr_legislation.install2',40);
7868:
7869: install(2);
7870:
7871: -- check for the existance of exceptions after phase 2

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

7869: install(2);
7870:
7871: -- check for the existance of exceptions after phase 2
7872:
7873: hr_utility.set_Location('hr_legislation.install2',50);
7874:
7875: select count(*)
7876: into v_exception_counter
7877: from hr_stu_exceptions;

Line 7912: END hr_legislation;

7908: commit;
7909:
7910: END install;
7911:
7912: END hr_legislation;