DBA Data[Home] [Help]

APPS.HR_LEGISLATION_LOCAL dependencies on HR_LEGISLATION

Line 1: PACKAGE body hr_legislation_local AS

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

Line 6: -- NAME : hr_legislation_local.pkb

2: /* $Header: pelegloc.pkb 120.1.12000000.1 2007/01/21 23:59:37 appldev ship $ */
3: --
4: -- Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.
5: --
6: -- NAME : hr_legislation_local.pkb
7: --
8: -- DESCRIPTION
9: -- Procedures used for the delivery of legislative startup data. The
10: -- same procedures are also used for legislative refreshes.

Line 83: -- hr_legislation.insert_hr_stu_exceptions

79: -- 115.18 vmehta 03-feb-2000 Modified install_us_new to delete from
80: -- the tables only if need to transfer
81: -- data
82: -- 115.19 tbattoo 08-Feb-2000 changed crt_exc so calls
83: -- hr_legislation.insert_hr_stu_exceptions
84: -- 115.20 RThirlby 11-APR-2000 Added translate_ca_ele_dev_df. This is
85: -- a copy of translate_us_ele_dev_df
86: -- modified for CA use.
87: -- 115.22 RThirlby 16-JUN-2000 Modifiled install_tax_rules so that it

Line 1248: hr_legislation.insert_hr_stu_exceptions('HR_S_NEW',

1244: /* temp. workaround for unique key violation */
1245: delete HR_STU_EXCEPTIONS
1246: where table_name = 'HR_S_NEW';
1247:
1248: hr_legislation.insert_hr_stu_exceptions('HR_S_NEW',
1249: 1000,
1250: 'Error in new US tables',
1251: null);
1252:

Line 2356: hr_legislation.hrrunprc_trace_on;

2352: from hr_s_history;
2353:
2354: BEGIN
2355:
2356: hr_legislation.hrrunprc_trace_on;
2357: hr_utility.trace('start install_leg_loc: ' || to_char(p_phase));
2358: hr_legislation.hrrunprc_trace_off;
2359:
2360: FOR r_legs IN c_legs LOOP

Line 2358: hr_legislation.hrrunprc_trace_off;

2354: BEGIN
2355:
2356: hr_legislation.hrrunprc_trace_on;
2357: hr_utility.trace('start install_leg_loc: ' || to_char(p_phase));
2358: hr_legislation.hrrunprc_trace_off;
2359:
2360: FOR r_legs IN c_legs LOOP
2361:
2362: hr_legislation.hrrunprc_trace_on;

Line 2362: hr_legislation.hrrunprc_trace_on;

2358: hr_legislation.hrrunprc_trace_off;
2359:
2360: FOR r_legs IN c_legs LOOP
2361:
2362: hr_legislation.hrrunprc_trace_on;
2363: hr_utility.trace('start install_leg_loc: leg_code: ' || r_legs.legislation_code ||
2364: ': ' || to_char(p_phase));
2365: hr_legislation.hrrunprc_trace_off;
2366:

Line 2365: hr_legislation.hrrunprc_trace_off;

2361:
2362: hr_legislation.hrrunprc_trace_on;
2363: hr_utility.trace('start install_leg_loc: leg_code: ' || r_legs.legislation_code ||
2364: ': ' || to_char(p_phase));
2365: hr_legislation.hrrunprc_trace_off;
2366:
2367: driving_legislation := r_legs.legislation_code;
2368:
2369: IF p_phase = 1 OR p_phase = 2 THEN

Line 2372: hr_legislation.hrrunprc_trace_on;

2368:
2369: IF p_phase = 1 OR p_phase = 2 THEN
2370:
2371:
2372: hr_legislation.hrrunprc_trace_on;
2373: hr_utility.trace('start install_leg_rules: ' || to_char(p_phase));
2374: hr_legislation.hrrunprc_trace_off;
2375:
2376: install_leg_rules(p_phase); --install legislation rules

Line 2374: hr_legislation.hrrunprc_trace_off;

2370:
2371:
2372: hr_legislation.hrrunprc_trace_on;
2373: hr_utility.trace('start install_leg_rules: ' || to_char(p_phase));
2374: hr_legislation.hrrunprc_trace_off;
2375:
2376: install_leg_rules(p_phase); --install legislation rules
2377:
2378: IF driving_legislation = 'US' THEN

Line 2381: hr_legislation.hrrunprc_trace_on;

2377:
2378: IF driving_legislation = 'US' THEN
2379:
2380:
2381: hr_legislation.hrrunprc_trace_on;
2382: hr_utility.trace('start install_state_rules: ' || to_char(p_phase));
2383: hr_legislation.hrrunprc_trace_off;
2384:
2385: install_state_rules(p_phase); --install pay_state_rules

Line 2383: hr_legislation.hrrunprc_trace_off;

2379:
2380:
2381: hr_legislation.hrrunprc_trace_on;
2382: hr_utility.trace('start install_state_rules: ' || to_char(p_phase));
2383: hr_legislation.hrrunprc_trace_off;
2384:
2385: install_state_rules(p_phase); --install pay_state_rules
2386:
2387: hr_legislation.hrrunprc_trace_on;

Line 2387: hr_legislation.hrrunprc_trace_on;

2383: hr_legislation.hrrunprc_trace_off;
2384:
2385: install_state_rules(p_phase); --install pay_state_rules
2386:
2387: hr_legislation.hrrunprc_trace_on;
2388: hr_utility.trace('start install_tax_rules: ' || to_char(p_phase));
2389: hr_legislation.hrrunprc_trace_off;
2390:
2391: install_tax_rules(p_phase); --install pay_taxability_rules

Line 2389: hr_legislation.hrrunprc_trace_off;

2385: install_state_rules(p_phase); --install pay_state_rules
2386:
2387: hr_legislation.hrrunprc_trace_on;
2388: hr_utility.trace('start install_tax_rules: ' || to_char(p_phase));
2389: hr_legislation.hrrunprc_trace_off;
2390:
2391: install_tax_rules(p_phase); --install pay_taxability_rules
2392:
2393: hr_legislation.hrrunprc_trace_on;

Line 2393: hr_legislation.hrrunprc_trace_on;

2389: hr_legislation.hrrunprc_trace_off;
2390:
2391: install_tax_rules(p_phase); --install pay_taxability_rules
2392:
2393: hr_legislation.hrrunprc_trace_on;
2394: hr_utility.trace('start install_surcharges: ' || to_char(p_phase));
2395: hr_legislation.hrrunprc_trace_off;
2396:
2397: install_surcharges(p_phase); --install Wcomp state surcharges

Line 2395: hr_legislation.hrrunprc_trace_off;

2391: install_tax_rules(p_phase); --install pay_taxability_rules
2392:
2393: hr_legislation.hrrunprc_trace_on;
2394: hr_utility.trace('start install_surcharges: ' || to_char(p_phase));
2395: hr_legislation.hrrunprc_trace_off;
2396:
2397: install_surcharges(p_phase); --install Wcomp state surcharges
2398:
2399: hr_legislation.hrrunprc_trace_on;

Line 2399: hr_legislation.hrrunprc_trace_on;

2395: hr_legislation.hrrunprc_trace_off;
2396:
2397: install_surcharges(p_phase); --install Wcomp state surcharges
2398:
2399: hr_legislation.hrrunprc_trace_on;
2400: hr_utility.trace('start install_us_new: ' || to_char(p_phase));
2401: hr_legislation.hrrunprc_trace_off;
2402:
2403: install_us_new(p_phase); --install new US misc

Line 2401: hr_legislation.hrrunprc_trace_off;

2397: install_surcharges(p_phase); --install Wcomp state surcharges
2398:
2399: hr_legislation.hrrunprc_trace_on;
2400: hr_utility.trace('start install_us_new: ' || to_char(p_phase));
2401: hr_legislation.hrrunprc_trace_off;
2402:
2403: install_us_new(p_phase); --install new US misc
2404:
2405: END IF;

Line 2410: hr_legislation.hrrunprc_trace_on;

2406:
2407: IF driving_legislation = 'CA' THEN
2408: --
2409:
2410: hr_legislation.hrrunprc_trace_on;
2411: hr_utility.trace('start install_tax_rules: ' || to_char(p_phase));
2412: hr_legislation.hrrunprc_trace_off;
2413:
2414: install_tax_rules(p_phase); -- install pay_taxability_rules

Line 2412: hr_legislation.hrrunprc_trace_off;

2408: --
2409:
2410: hr_legislation.hrrunprc_trace_on;
2411: hr_utility.trace('start install_tax_rules: ' || to_char(p_phase));
2412: hr_legislation.hrrunprc_trace_off;
2413:
2414: install_tax_rules(p_phase); -- install pay_taxability_rules
2415: --
2416: END IF;

Line 2420: hr_legislation.hrrunprc_trace_on;

2416: END IF;
2417: --
2418: IF driving_legislation = 'GB' THEN
2419:
2420: hr_legislation.hrrunprc_trace_on;
2421: hr_utility.trace('start gb scl flex delete: ' || to_char(p_phase));
2422: hr_legislation.hrrunprc_trace_off;
2423:
2424: --the gb scl flex only needs to appear at payroll sites

Line 2422: hr_legislation.hrrunprc_trace_off;

2418: IF driving_legislation = 'GB' THEN
2419:
2420: hr_legislation.hrrunprc_trace_on;
2421: hr_utility.trace('start gb scl flex delete: ' || to_char(p_phase));
2422: hr_legislation.hrrunprc_trace_off;
2423:
2424: --the gb scl flex only needs to appear at payroll sites
2425: delete from pay_legislation_rules
2426: where legislation_code = 'GB'

Line 2452: hr_legislation.hrrunprc_trace_on;

2448:
2449:
2450: END IF; --end phase control check
2451:
2452: hr_legislation.hrrunprc_trace_on;
2453: hr_utility.trace('end install_leg_loc: leg_code: ' || r_legs.legislation_code ||
2454: ': ' || to_char(p_phase));
2455: hr_legislation.hrrunprc_trace_off;
2456:

Line 2455: hr_legislation.hrrunprc_trace_off;

2451:
2452: hr_legislation.hrrunprc_trace_on;
2453: hr_utility.trace('end install_leg_loc: leg_code: ' || r_legs.legislation_code ||
2454: ': ' || to_char(p_phase));
2455: hr_legislation.hrrunprc_trace_off;
2456:
2457: END LOOP; -- c_legs cursor
2458:
2459: hr_legislation.hrrunprc_trace_on;

Line 2459: hr_legislation.hrrunprc_trace_on;

2455: hr_legislation.hrrunprc_trace_off;
2456:
2457: END LOOP; -- c_legs cursor
2458:
2459: hr_legislation.hrrunprc_trace_on;
2460: hr_utility.trace('exit install_leg_loc: ' || to_char(p_phase));
2461: hr_legislation.hrrunprc_trace_off;
2462:
2463: END install;

Line 2461: hr_legislation.hrrunprc_trace_off;

2457: END LOOP; -- c_legs cursor
2458:
2459: hr_legislation.hrrunprc_trace_on;
2460: hr_utility.trace('exit install_leg_loc: ' || to_char(p_phase));
2461: hr_legislation.hrrunprc_trace_off;
2462:
2463: END install;
2464:
2465: END hr_legislation_local;

Line 2465: END hr_legislation_local;

2461: hr_legislation.hrrunprc_trace_off;
2462:
2463: END install;
2464:
2465: END hr_legislation_local;