1 PACKAGE JTA_NOTES_IMT_PUB AUTHID CURRENT_USER
2 /* $Header: jtfpntis.pls 120.1 2005/07/02 00:55:27 appldev ship $ */
3 AS
4
5 PROCEDURE optimize_notes_index
6 --------------------------------------------------------------------------
7 -- Start of comments
8 -- API name : optimize_notes_index
9 -- Type : Public
10 -- Function : optimize the JTF_NOTES_TL.JTF_NOTES_TL_C1 index
11 -- Pre-reqs : None.
12 -- Parameters :
13 -- name direction type required?
14 -- ---- --------- ---- ---------
15 -- errbuf out varchar2 Yes
16 -- retcode out number Yes
17 -- p_optimize_level in varchar2 No
18 -- p_runtime in number No
19 --
20 -- Version : Current version 1.0
21 -- Previous version 1.0
22 -- Initial version 1.0
23 --
24 -- End of comments
25 --------------------------------------------------------------------------
26 ( errbuf OUT NOCOPY VARCHAR2
27 , retcode OUT NOCOPY NUMBER
28 , p_optimize_level IN VARCHAR2 := ctx_ddl.optlevel_full
29 , p_runtime IN NUMBER := ctx_ddl.maxtime_unlimited
30 );
31
32 PROCEDURE sync_notes_index
33 --------------------------------------------------------------------------
34 -- Start of comments
35 -- API name : sync_notes_index
36 -- Type : Public
37 -- Function : synchronize the JTF_NOTES_TL.JTF_NOTES_TL_C1 index
38 -- Pre-reqs : None.
39 -- Parameters :
40 -- name direction type required?
41 -- ---- --------- ---- ---------
42 -- errbuf out varchar2 Yes
43 -- retcode out number Yes
44 --
45 -- Version : Current version 1.0
46 -- Previous version 1.0
47 -- Initial version 1.0
48 --
49 -- End of comments
50 --------------------------------------------------------------------------
51 ( errbuf OUT NOCOPY VARCHAR2
52 , retcode OUT NOCOPY NUMBER
53 );
54
55 END JTA_NOTES_IMT_PUB;