1 PACKAGE IBC_IMT_PUB AUTHID CURRENT_USER AS
2 /* $Header: ibcpimts.pls 115.2 2003/11/08 06:53:53 srrangar noship $ */
3 -- NAME
4 -- ibcpimts.pls
5 --
6 -- DESCRIPTION
7 -- Package body for IBC_IMT_PUB in support of rebuilding IMT
8 -- indexes on IBC table IBC_Attribute_bundles. Expected use of this package
9 -- is either through Apps Concurrent Manager or package DBMS_JOBS.
10 --
11 -- NOTES
12 --
13 -- HISTORY
14 -- Marzia Usman and Sri Rangarajan Created 11/07/2003
15 --
16 --------------------------------------------------------------------------------
17 -- Start of comments
18 -- API name : OPTIMIZE_IBC_IMT_INDEXES
19 -- Type : Public
20 -- Pre-reqs : None
21 -- Function : Package that performs an IMT Optimize on all indexes across
22 -- all IBC IMT-indexed columns in a time-distributed fashion.
23 -- Parameters :
24 --
25 -- IN : p_optimize_level IN VARCHAR2 Optional
26 -- Specifies the type of IMT index optimization to perform.
27 -- Valid values are 'FAST','FULL', ctx_ddl.optlevel_fast or
28 -- ctx_ddl.optlevel_full.
29 --
30 -- Default is ctx_ddl.optlevel_full.
31 --
32 -- : p_runtime IN NUMBER Optional
33 -- Integer that indicates the total run-time (in seconds) of
34 -- this optimization function call. This time will be
35 -- divided equally amongst all indexes within the IBC
36 -- subsystem. A null value implies execution until
37 -- completion of the task.
38 --
39 -- Default is ctx_ddl.maxtime_unlimited.
40 --
41 -- Version : Current version 1.0
42 -- {add comments here}
43 -- Previous version 1.0
44 -- Initial version 1.0
45 --
46 -- End of comments
47 --
48
49 PROCEDURE OPTIMIZE_IBC_IMT_INDEXES
50 (ERRBUF OUT NOCOPY VARCHAR2,
51 RETCODE OUT NOCOPY NUMBER,
52 p_optimize_level IN VARCHAR2 := ctx_ddl.optlevel_full,
53 p_runtime IN NUMBER := ctx_ddl.maxtime_unlimited);
54 --------------------------------------------------------------------------------
55 -- Start of comments
56 -- API name : SYNC_IBC_IMT_INDEXES
57 -- Type : Public
58 -- Pre-reqs : None
59 -- Function : Package that performs an IMT Sync on all indexes across
60 -- all IBC IMT-indexed columns.
61 --
62 -- Parameters : None.
63 --
64 -- Version : Current version 1.0
65 -- {add comments here}
66 -- Previous version 1.0
67 -- Initial version 1.0
68 --
69 -- End of comments
70 --
71
72 PROCEDURE SYNC_IBC_IMT_INDEXES
73 (ERRBUF OUT NOCOPY VARCHAR2,
74 RETCODE OUT NOCOPY NUMBER );
75
76 END IBC_IMT_PUB;