1 PACKAGE JTF_AMVIMT_Pub AUTHID CURRENT_USER AS
2 /* $Header: jtfpimts.pls 115.8 2002/11/26 22:30:19 stopiwal ship $ */
3 -- NAME
4 -- jtfpimts.pls
5 --
6 -- DESCRIPTION
7 -- Package specifications for JTF_AMVIMT_PUB in support of rebuilding iMT
8 -- indexes on JTF ITEM tables jtf_amv_items_b and _tl.
9 -- Expected use of this package is either through Apps Concurrent Manager
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_JTF_IMT_Indexes
20 -- Type : Public
21 -- Pre-reqs : None
22 -- Function : Package that performs an iMT Optimize on all indexes across
23 -- all JTF 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 JTF
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_JTF_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_JTF_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_JTF_IMT_Indexes
77 (ERRBUF OUT NOCOPY VARCHAR2,
78 RETCODE OUT NOCOPY NUMBER);
79
80 --
81 END JTF_AMVIMT_Pub;