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