1 PACKAGE hr_legislation_local AUTHID CURRENT_USER AS
2 /* $Header: pelegloc.pkh 115.6 2002/06/14 16:43:09 pkm ship $ */
3 --
4 -- Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.
5 --
6 -- ---------------------------------------------------------------------------
7 -- NAME : pelegloc.pkh
8 --
9 -- DESCRIPTION
10 -- Procedures used for the delivery of legislative startup data. The
11 -- same procedures are also used for legislative refreshes.
12 -- This package is to make specific calls to localization packages
13 -- or procedures.
14 -- MODIFIED
15 -- 70.0 Ian Carline 14-09-1993 - Created
16 -- 70.1 Ian Carline 13-12-1993 - Corrected header
17 -- 70.2 Ian Carline 06-01-1994 - Place the 'AS' on the same line as
18 -- the create statement.
19 -- 70.3 Tim Eyres 02-01-1996 - Moved arcs header to directly after
20 -- 'create or replace' line
21 -- Fix to bug 434902
22 -- 110.1 J Alloun 23-07-1997 - Removed SHOW ERROR and SELECT FROM
23 --
24 -- USER_ERROR statements for Release 11.
25 -- Daniel J 03-30-1999 - added new routine install_us_new
26 -- for release 11.5
27 -- Vipin M 11-10-1999 - Added two new functions
28 --- decode_us_element_information and
29 -- translate_us_ele_dev_df
30 -- 115.4 RThirlby 11-APR-2000 Added new procedure translate_ca_ele-
31 -- _dev_df. This is a copy of us function-- translate_us_ele_dev_df, modified for
32 -- CA use.
33 -- 115.5 DVickers 09-MAY-2002 dbdrv added
34 -- 115.6 PGanguly 13-JUN-2002 Added set verify off/whenever
35 -- oserror
36 -- ===========================================================================
37 --
38 TYPE character_data_table IS TABLE OF varchar2(50)
39 INDEX BY BINARY_INTEGER;
40
41 PROCEDURE install_us_new
42 (p_phase number);
43
44 PROCEDURE install
45 (p_phase number);
46
47 FUNCTION decode_elmnt_bal_information (p_legislation_code VARCHAR2,
48 p_information_type VARCHAR2,
49 p_code NUMBER DEFAULT NULL,
50 p_meaning VARCHAR2 DEFAULT NULL)
51 RETURN VARCHAR2 ;
52
53 PROCEDURE translate_us_ele_dev_df
54 (p_mode varchar2);
55 --
56 PROCEDURE translate_ca_ele_dev_df
57 (p_mode varchar2);
58 --
59 end hr_legislation_local;