DBA Data[Home] [Help]

PACKAGE: APPS.JTA_NOTES_IMT_PUB

Source


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;