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