[Home] [Help]
PACKAGE: APPS.EAM_TEXT_INDEX_PVT
Source
1 PACKAGE EAM_TEXT_INDEX_PVT AUTHID DEFINER AS
2 /* $Header: EAMVTICS.pls 120.1 2005/06/12 21:49:41 appldev $*/
3 -- Start of comments
4 -- API name : EAM_TEXT_INDEX_PVT
5 -- Type : Public or Group or Private.
6 -- Function :
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN p_api_version IN NUMBER Required
10 -- p_init_msg_list IN VARCHAR2 Optional
11 -- Default = FND_API.G_FALSE
12 -- p_commit IN VARCHAR2 Optional
13 -- Default = FND_API.G_FALSE
14 -- p_validation_level IN NUMBER Optional
15 -- Default = FND_API.G_VALID_LEVEL_FULL
16 -- parameter1
17 -- parameter2
18 -- .
19 -- .
20 -- OUT x_return_status OUT VARCHAR2(1)
21 -- x_msg_count OUT NUMBER
22 -- x_msg_data OUT VARCHAR2(2000)
23 -- parameter1
24 -- parameter2
25 -- .
26 -- .
27 -- Version Current version x.x
28 -- Changed....
29 -- previous version y.y
30 -- Changed....
31 -- .
32 -- .
33 -- previous version 2.0
34 -- Changed....
35 -- Initial version 1.0
36 --
37 -- Notes : Note text
38 --
39 -- End of comments
40
41
42 -- -----------------------------------------------------------------------------
43 -- Public Globals
44 -- -----------------------------------------------------------------------------
45
46 G_FILE_NAME CONSTANT VARCHAR2(12) := 'EAMVTICS.pls';
47 G_RETCODE_SUCCESS CONSTANT NUMBER := 0;
48 G_RETCODE_WARNING CONSTANT NUMBER := 1;
49 G_RETCODE_ERROR CONSTANT NUMBER := 2;
50
51 G_MISS_NUM CONSTANT NUMBER := 9.99E125;
52 G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
53 G_MISS_DATE CONSTANT DATE := TO_DATE('1','J');
54
55 G_STATUS_SUCCESS CONSTANT VARCHAR2(1) := 'S';
56 G_STATUS_WARNING CONSTANT VARCHAR2(1) := 'W';
57 G_STATUS_ERROR CONSTANT VARCHAR2(1) := 'E';
58 G_STATUS_UNEXP_ERROR CONSTANT VARCHAR2(1) := 'U';
59
60 G_EXC_ERROR EXCEPTION;
61 G_EXC_UNEXPECTED_ERROR EXCEPTION;
62
63
64 -- -----------------------------------------------------------------------------
65 -- Procedures
66 -- -----------------------------------------------------------------------------
67 /*
68 p_text_context :
69 1 - Asset
70 2 - Work Order
71
72 p_action :
73 1 - Create
74 2 - Update / Rebuild
75 3 - Optimize
76 4 - Drop
77 */
78
79 PROCEDURE Build_Text_Index
80 (
81 ERRBUF OUT NOCOPY VARCHAR2
82 , RETCODE OUT NOCOPY NUMBER
83 , p_text_context IN NUMBER
84 , p_Action IN NUMBER
85 , p_dummy1 IN NUMBER DEFAULT NULL
86 , p_optlevel IN NUMBER DEFAULT NULL
87 , p_dummy2 IN NUMBER DEFAULT NULL
88 , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited
89 );
90
91
92 PROCEDURE Optimize_Index
93 (
94 x_return_status OUT NOCOPY VARCHAR2
95 , p_optlevel IN VARCHAR2 DEFAULT AD_CTX_DDL.Optlevel_Full
96 , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited
97 , p_index_name IN VARCHAR2
98 );
99
100
101 PROCEDURE set_Log_Mode ( p_Mode IN VARCHAR2 );
102
103 PROCEDURE Log_Line ( p_Buffer IN VARCHAR2
104 , p_Log_Type IN NUMBER
105 , p_Module IN VARCHAR2 );
106
107 -- -----------------------------------------------------------------------------
108 -- Functions
109 -- -----------------------------------------------------------------------------
110
111 FUNCTION set_Log_Mode ( p_Mode IN VARCHAR2 )
112 RETURN VARCHAR2;
113
114
115 -- -----------------------------------------------------------------------------
116 -- End of Package Spec
117 -- -----------------------------------------------------------------------------
118
119 END EAM_TEXT_INDEX_PVT;