1 PACKAGE JTY_TAE_INDEX_CREATION_PVT AUTHID CURRENT_USER AS
2 /*$Header: jtfyaeis.pls 120.2 2006/03/30 17:26:42 achanda noship $*/
3 /* -- =========================================================================+
4 -- | Copyright (c) 2002 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +===========================================================================
8 -- Start of Comments
9 -- ---------------------------------------------------
10 -- PACKAGE NAME: JTY_TAE_INDEX_CREATION_PVT
11 -- ---------------------------------------------------
12 -- PURPOSE
13 --
14 -- This package has public api to do the following :
15 -- a) return a list of column in order of selectivity
16 -- b) create index on interface tables
17 -- c) drop indexes on a table
18 -- d) analyze a table
19 -- e) truncate a table
20 --
21 -- Procedures:
22 -- (see below for specification)
23 --
24 -- NOTES
25 -- This package is publicly available for use
26 --
27 -- HISTORY
28 -- 06/02/2005 achanda Created
29 --
30 -- End of Comments */
31
32 Type value_varray IS VARRAY (400) of integer;
33 TYPE name_varray IS VARRAY (400) OF varchar2(30);
34
35 PROCEDURE SELECTIVITY(
36 p_TABLE_NAME IN VARCHAR2,
37 p_mode IN VARCHAR2,
38 p_source_id IN NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2);
40
41 PROCEDURE DEA_SELECTIVITY(
42 p_TABLE_NAME IN VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2);
44
45 procedure CREATE_INDEX (
46 p_table_name IN VARCHAR2,
47 p_trans_id IN NUMBER,
48 p_source_id IN NUMBER,
49 p_program_name IN VARCHAR2,
50 p_mode IN VARCHAR2,
51 x_Return_Status OUT NOCOPY VARCHAR2,
52 p_run_mode IN VARCHAR2);
53
54 PROCEDURE DROP_TABLE_INDEXES(
55 p_table_name IN VARCHAR2,
56 x_return_status OUT NOCOPY VARCHAR2 );
57
58 PROCEDURE ANALYZE_TABLE_INDEX(
59 p_TABLE_NAME IN VARCHAR2,
60 P_PERCENT IN NUMBER,
61 x_return_status OUT NOCOPY VARCHAR2 );
62
63 PROCEDURE TRUNCATE_TABLE(
64 p_TABLE_NAME IN VARCHAR2,
65 x_return_status OUT NOCOPY VARCHAR2 );
66
67 END JTY_TAE_INDEX_CREATION_PVT;