1 PACKAGE hr_legislation AS
2 /* $Header: pelegins.pkh 120.1.12000000.2 2007/02/20 17:25:54 divicker ship $ */
3 --
4 -- Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.
5 --
6 -- ---------------------------------------------------------------------------
7 -- NAME : pelegins.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 is the main driving package to call all other startup delivery
13 -- packages and procedures.
14 --
15 -- MODIFIED
16 -- 80.1 Ian Carline 14-09-1993 - Cretaed
17 -- 80.2 Ian Carline 15-11-1993 - Debugged for US Bechtel delivery
18 -- 80.3 Ian Carline 13-12-1993 - Corrected header
19 -- 80.4 Rod Fine 16-12-1993 - Put AS on same line as CREATE stmt
20 -- to workaround export WWBUG #178613.
21 -- 70.4 Ian Carline 09-06-1994 - Reworked header layout
22 -- 70.5 Ian Carline 13-06-1994 - Added a new entry level install
23 -- procedure.
24 -- 70.6 Tim Eyres 02-01-1997 - Moved arcs header to directly after
25 -- 'create or replace' line
26 -- Fix to bug 434902
27 -- 70.8 Tim Eyres 02-01-1997 - Correction to arcs version number
28 -- 115.1 T.Battoo 08-Feb-2000 defined hr_legislation.insert_hr_stu_exceptions
29 -- 115.2 Divicker 31-May-2001 - Added p_true_key parameter
30 -- 115.3 Divicker 26-Jul-2001 - Added public procedure munge_sequence
31 -- to take away the time cost of incrementing a
32 -- sequence to a specific value by increment by 1
33 -- 115.4 Divicker 19-Mar-2002 - Added dbdrv checkfile lines
34 -- 115.6 Divicker 10-AUG-2005 - Add debug var
35 -- 115.7 DIVICKER 21-JUN-2006 - Add g_product_install
36 -- 115.8 divicker 20-FEB-2006 - add comment to force dm into 12 br
37 -- ===========================================================================
38 PROCEDURE install
39 (p_phase number);
40 --
41 PROCEDURE install;
42 PROCEDURE hrrunprc_trace_on;
43 PROCEDURE hrrunprc_trace_off;
44 PROCEDURE insert_hr_stu_exceptions (p_table_name varchar2,
45 p_surrogate_id number,
46 p_text varchar2,
47 p_true_key varchar2 default null);
48 PROCEDURE munge_sequence(p_seq_name varchar2,
49 p_seq_val number,
50 p_req_val number);
51 --
52 g_debug_cnt number;
53 --
54 /* g_product_install
55 For use in hrglobal lcts that need to check on ownership
56 information to decide whether to upload row or not */
57 g_product_install number;
58
59 end hr_legislation;