[Home] [Help]
PACKAGE: APPS.CS_KNOWLEDGE_PUB
Source
1 PACKAGE CS_Knowledge_PUB AS
2 /* $Header: cspkbs.pls 120.1 2005/08/16 10:55:45 speng noship $ */
3
4
5
6 --
7 -- CONSTANTS
8 --
9
10 G_PKG_NAME CONSTANT VARCHAR2(50) := 'CS_Knowledge_PUB';
11
12
13 -- G_ERROR_STATUS CONSTANT NUMBER(5) := -1;
14 -- G_OKAY_STATUS CONSTANT NUMBER(5) := 0;
15
16 /* for cs_kb_set_eles.assoc_degree */
17 G_POSITIVE_ASSOC CONSTANT NUMBER(5) := 1;
18 G_NEGATIVE_ASSOC CONSTANT NUMBER(5) := -1;
19
20 /* default increment for count */
21 G_COUNT_INCR CONSTANT NUMBER(5) := 1;
22 G_COUNT_INIT CONSTANT NUMBER(5) := 1;
23
24 /* for different Search options as in metalink */
25
26 MATCH_ALL CONSTANT NUMBER(5) := 0;
27 MATCH_ANY CONSTANT NUMBER(5) := 1;
28 FUZZY CONSTANT NUMBER(5) := 2;
29 INTERMEDIA_SYNTAX CONSTANT NUMBER(5) := 3;
30 THEME_BASED CONSTANT NUMBER(5) := 4;
31 MATCH_ACCUM CONSTANT NUMBER(5) := 5;
32 -- "6" is reserved for match by id at java level
33 MATCH_PHRASE CONSTANT NUMBER(5) := 7;
34
35 --
36 -- TYPES AND MISSING CONSTANTS
37 -- (All types are defined in PUB package)
38 --
39
40 /* for input query strings */
41 TYPE varchar21990_tbl_type IS TABLE OF varchar2(1990);
42
43 /* for input ids */
44 TYPE number15_tbl_type IS TABLE OF number(15);
45
46 /* weakly typed cursor for dynamic sql */
47 TYPE general_csr_type IS REF CURSOR;
48
49 /* element results */
50 TYPE ele_res_rec_type IS RECORD (
51 id number(15),
52 score number(15),
53 type_id number(15),
54 description clob ,
55 creation_date date ,
56 created_by number(15),
57 last_update_date date ,
58 last_updated_by number(15),
59 last_update_login number(15),
60 type_name varchar2(100),
61 short_description varchar2(2000)
62 );
63 TYPE ele_res_tbl_type IS TABLE OF ele_res_rec_type;
64
65
66 /* set results */
67 TYPE set_res_rec_type IS RECORD (
68 id number(15) ,
69 score number(15) ,
70 type_id number(15) ,
71 name varchar2(1000) ,
72 description varchar2(1000),
73 creation_date date ,
74 created_by number(15) ,
75 last_update_date date ,
76 last_updated_by number(15) ,
77 last_update_login number(15) ,
78 type_name varchar2(100) ,
79 solution_number varchar2(30)
80 );
81 TYPE set_res_tbl_type IS TABLE OF set_res_rec_type;
82
83
84 /* record type for element definition */
85 TYPE ele_def_rec_type IS RECORD (
86 element_id number(15) ,
87 element_type_id number(15) ,
88 name varchar2(2000) ,
89 description varchar2(2000) ,
90 attribute_category varchar2(30) ,
91 attribute1 varchar2(150),
92 attribute2 varchar2(150),
93 attribute3 varchar2(150),
94 attribute4 varchar2(150),
95 attribute5 varchar2(150),
96 attribute6 varchar2(150),
97 attribute7 varchar2(150),
98 attribute8 varchar2(150),
99 attribute9 varchar2(150),
100 attribute10 varchar2(150),
101 attribute11 varchar2(150),
102 attribute12 varchar2(150),
103 attribute13 varchar2(150),
104 attribute14 varchar2(150),
105 attribute15 varchar2(150)
106 );
107 TYPE ele_def_tbl_type IS TABLE OF ele_def_rec_type;
108 /*
109 TYPE attrval_def_rec_type IS RECORD(
110 attribute_val_id number(15),
111 attribute_id number(15),
112 num_val number,
113 date_val date,
114 string_val varchar2(1000),
115 description varchar2(1000),
116 attribute_category varchar2(30) ,
117 attribute1 varchar2(150),
118 attribute2 varchar2(150),
119 attribute3 varchar2(150),
120 attribute4 varchar2(150),
121 attribute5 varchar2(150),
122 attribute6 varchar2(150),
123 attribute7 varchar2(150),
124 attribute8 varchar2(150),
125 attribute9 varchar2(150),
126 attribute10 varchar2(150),
127 attribute11 varchar2(150),
128 attribute12 varchar2(150),
129 attribute13 varchar2(150),
130 attribute14 varchar2(150),
131 attribute15 varchar2(150)
132 );
133
134 TYPE attrval_def_tbl_type IS TABLE OF attrval_def_rec_type;
135 */
136 /* record type for set definition */
137 TYPE set_def_rec_type IS RECORD (
138 set_id number(15) ,
139 set_type_id number(15) ,
140 name varchar2(500) ,
141 description varchar2(100) ,
142 status varchar2(30),
143 attribute_category varchar2(30) ,
144 attribute1 varchar2(150),
145 attribute2 varchar2(150),
146 attribute3 varchar2(150),
147 attribute4 varchar2(150),
148 attribute5 varchar2(150),
149 attribute6 varchar2(150),
150 attribute7 varchar2(150),
151 attribute8 varchar2(150),
152 attribute9 varchar2(150),
153 attribute10 varchar2(150),
154 attribute11 varchar2(150),
155 attribute12 varchar2(150),
156 attribute13 varchar2(150),
157 attribute14 varchar2(150),
158 attribute15 varchar2(150)
159 );
160
161
162 G_MISS_ELE_DEF_REC ele_def_rec_type ;
163 G_MISS_ELE_DEF_TBL ele_def_tbl_type ;
164
165 --
166 -- Public
167 --
168 -- Start of comments
169 -- API Name : Construct_Text_Query
170 -- Type : Public
171 --
172 -- Parameters :
173 -- IN :
174 -- p_api_version IN NUMBER Required
175 -- p_init_msg_list IN VARCHAR2(1) Optional
176 -- Default = FND_API.G_FALSE
177 -- p_commit IN VARCHAR2(1) Optional
178 -- Default = FND_API.G_FALSE
179 -- p_validation_level IN NUMBER Optional
180 -- Default = FND_API.G_VALID_LEVEL_FULL
181 -- p_qry_string IN
182 -- String of keywords
183 -- p_search_option IN
184 -- Search option such as and, or, not, theme
185 --
186 -- OUT :
187 -- x_return_status OUT VARCHAR2(1)
188 -- x_msg_count OUT NUMBER
189 -- x_msg_data OUT VARCHAR2(2000)
190 -- x_qry_string OUT VARCHAR2(30000)
191 --
192 --
193 -- Version : Initial Version 1.0
194 --
195 -- Notes : (Post 8/10/01) x_qry_string return result of the construct
196 --
197 --
198 -- End of comments
199
200 PROCEDURE Construct_Text_Query(
201 p_api_version in number,
202 p_init_msg_list in varchar2 := FND_API.G_FALSE,
203 p_commit in varchar2 := FND_API.G_FALSE,
204 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
205 x_return_status OUT NOCOPY varchar2,
206 x_msg_count OUT NOCOPY number,
207 x_msg_data OUT NOCOPY varchar2,
208 p_qry_string in varchar2,
209 p_search_option in number,
210 x_qry_string OUT NOCOPY varchar2
211 );
212
213
214 -- Start of comments
215 -- API Name : Create_Set_And_Elements
216 -- Type : Public
217 -- Function : Create a set using given elements
218 -- Pre-reqs : Must have valid set/element types
219 --
220 -- Parameters :
221 -- IN :
222 -- p_api_version IN NUMBER Required
223 -- p_init_msg_list IN VARCHAR2(1) Optional
224 -- Default = FND_API.G_FALSE
225 -- p_commit IN VARCHAR2(1) Optional
226 -- Default = FND_API.G_FALSE
227 -- p_validation_level IN NUMBER Optional
228 -- Default = FND_API.G_VALID_LEVEL_FULL
229 -- p_set_def_rec IN
230 -- CS_Knowledge_PUB.set_def_rec_type Required
231 -- Definition of the set. Must have set type, status, name.
232 -- p_ele_def_tbl IN
233 -- CS_Knowledge_PUB.ele_def_tbl_type Required
234 -- Each record defines an element. If element id is given,
235 -- it is used, otherwise the api uses other fields to
236 -- create the element.
237 --
238 -- OUT :
239 -- x_return_status OUT VARCHAR2(1)
240 -- x_msg_count OUT NUMBER
241 -- x_msg_data OUT VARCHAR2(2000)
242 -- x_set_id OUT NUMBER
243 -- The created set id.
244 -- x_element_id_tbl OUT CS_Knowledge_PUB.number15_tbl_type
245 -- Table of element ids associated with the statements contributed
246 --
247 --
248 -- Version : Initial Version 1.0
249 --
250 -- Notes : (Post 8/03/00) Contributed element ids passed back
251 --
252 --
253 -- End of comments
254
255 PROCEDURE Create_Set_And_Elements(
256 p_api_version in number,
257 p_init_msg_list in varchar2 := FND_API.G_FALSE,
258 p_commit in varchar2 := FND_API.G_FALSE,
259 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
260 x_return_status OUT NOCOPY varchar2,
261 x_msg_count OUT NOCOPY number,
262 x_msg_data OUT NOCOPY varchar2,
263 p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
264 p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
265 x_set_id OUT NOCOPY number,
266 x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
267 );
268
269
270
271
272 end CS_Knowledge_PUB;