[Home] [Help]
PACKAGE: APPS.CS_KNOWLEDGE_PVT
Source
1 PACKAGE CS_Knowledge_Pvt AUTHID CURRENT_USER AS
2 /* $Header: csvkbs.pls 120.0.12020000.2 2012/07/05 05:38:51 gasankar ship $ */
3
4 --
5 -- CONSTANTS
6 --
7
8 G_PKG_NAME CONSTANT VARCHAR2(50) := 'CS_Knowledge_PVT';
9
10 -- G_YES CONSTANT VARCHAR2(1) :='Y';
11 -- G_NO CONSTANT VARCHAR2(1) :='N';
12
13 G_PF CONSTANT VARCHAR2(2) :='PF'; -- triggered when user clicked "Yes", it solved my problem
14 G_NF CONSTANT VARCHAR2(2) :='NF'; -- triggered when user clicked "No", didn't solve my problem
15 G_VS CONSTANT VARCHAR2(2) :='VS'; -- triggered when solution is viewed
16
17 -- for return status
18 ERROR_STATUS CONSTANT NUMBER := -1;
19 OKAY_STATUS CONSTANT NUMBER := 0;
20
21 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
23 G_VALID_LEVEL_TYPESOK CONSTANT NUMBER := 50;
24
25 --
26 -- TYPES AND MISSING CONSTANTS
27 --
28 G_MISS_NUM15 CONSTANT NUMBER(15) := -9E14;
29
30 --
31 -- Procedures and Functions
32 --
33
34 --
35 -- Utility functions
36 --
37 FUNCTION Build_Intermedia_Query
38 (
39 p_string in varchar2,
40 p_search_option in number
41 )
42 return varchar2;
43
44 FUNCTION Build_Solution_Text_Query
45 (
46 p_raw_text in varchar2,
47 p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type
48 )
49 return varchar2;
50
51 FUNCTION Build_Solution_Text_Query
52 (
53 p_raw_text in varchar2,
54 p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
55 p_search_option in number
56 )
57 return varchar2;
58
59 FUNCTION Build_Solution_Text_Query
60 (
61 p_raw_text in varchar2,
62 p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
63 p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
64 p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
65 p_search_option in number
66 )
67 return varchar2;
68
69 FUNCTION Build_Solution_Text_Query
70 (
71 p_raw_text in varchar2,
72 p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
73 p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
74 p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
75 p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
76 p_search_option in number
77 )
78 return varchar2;
79
80 FUNCTION Build_Solution_Text_Query
81 (
82 p_raw_text in varchar2,
83 p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
84 p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
85 p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
86 p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
87 p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
88 p_search_option in number
89 )
90 return varchar2;
91
92 FUNCTION Build_Simple_Text_Query
93 (
94 p_qry_string in varchar2,
95 p_search_option in number
96 )
97 return varchar2;
98
99
100 FUNCTION Build_Statement_Text_Query
101 (
102 p_raw_text in varchar2,
103 p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type
104 )
105 return varchar2;
106
107 -- 3468629
108 FUNCTION Build_Statement_Text_Query
109 (
110 p_raw_text in varchar2,
111 p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
112 p_search_option in number
113 )
114 return varchar2;
115
116 -- Build_Keyword_Query is for KM internal use only
117 FUNCTION Build_Keyword_Query
118 (
119 p_string IN VARCHAR2,
120 p_search_option IN NUMBER
121 )
122 RETURN VARCHAR2;
123
124 FUNCTION Bind_Var_String(
125 p_start_num in number,
126 p_size in number
127 )return varchar2;
128
129
130 FUNCTION Concat_Ids(
131 p_id_tbl in cs_kb_number_tbl_type,
132 p_separator in varchar2
133 ) return varchar2;
134
135 FUNCTION Concat_Ids(
136 p_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
137 p_separator in varchar2
138 ) return varchar2;
139
140 FUNCTION Is_Set_Ele_Type_Valid(
141 p_set_id in number := null,
142 p_set_type_id in number :=null,
143 p_ele_id in number :=null,
144 p_ele_type_id in number :=null
145 ) return varchar2;
146
147 FUNCTION Does_Set_Type_Exist(
148 p_set_type_id in number
149 ) return varchar2;
150
151 FUNCTION Does_Element_Type_Exist(
152 p_ele_type_id in number
153 ) return varchar2;
154
155
156
157 PROCEDURE Get_Who(
158 x_sysdate OUT NOCOPY date,
159 x_user_id OUT NOCOPY number,
160 x_login_id OUT NOCOPY number
161 );
162
163
164 FUNCTION Do_Elements_Exist_In_Set (
165 p_ele_id_tbl in cs_kb_number_tbl_type
166 ) return varchar2;
167
168 FUNCTION Get_External_Obj_Names(
169 p_obj_code_tbl in jtf_varchar2_table_100,
170 p_sel_id_tbl in jtf_varchar2_table_100,
171 p_sel_name_tbl OUT NOCOPY jtf_varchar2_table_1000
172 ) return number;
173
174 --FUNCTION Move_Element_Order(
175 -- p_set_id in number,
176 -- p_ele_id in number,
177 -- p_mode in varchar2
178 --) return number;
179
180 --FUNCTION Change_Element_Assoc(
181 -- p_set_id in number,
182 -- p_ele_id_tbl in cs_kb_number_tbl_type,
183 -- p_assoc_tbl in cs_kb_varchar100_tbl_type --N = neg, P=positive
184 --) return number;
185
186 FUNCTION Del_Element_From_Set(
187 p_ele_id in number,
188 p_set_id in number,
189 p_update_sets_b in varchar2 default 'T'
190 ) return number;
191
192 --FUNCTION Add_Element_To_Set_Ord(
193 -- p_set_id in number,
194 -- p_ele_id in number,
195 -- p_ele_order in number,
196 -- p_assoc_degree in number := CS_Knowledge_PUB.G_POSITIVE_ASSOC
197 --) return number;
198
199
200 FUNCTION Add_Element_To_Set(
201 p_ele_id in number,
202 p_set_id in number,
203 p_assoc_degree in number := CS_Knowledge_PUB.G_POSITIVE_ASSOC,
204 p_update_sets_b in varchar2 default 'T'
205 ) return number;
206
207 PROCEDURE Add_External_Links(
208 p_api_version in number,
209 p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
210 p_commit in varchar2, -- := FND_API.G_FALSE,
211 p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
212 x_return_status OUT NOCOPY varchar2,
213 x_msg_count OUT NOCOPY number,
214 x_msg_data OUT NOCOPY varchar2,
215 p_usage_code in varchar2,
216 p_id in number,
217 p_object_code in varchar2,
218 p_other_id_tbl in cs_kb_number_tbl_type,
219 p_other_code_tbl in cs_kb_varchar100_tbl_type
220 );
221
222 --
223 -- Update or delete link
224 --
225 --PROCEDURE Change_Set_Type_Links(
226 -- p_api_version in number,
227 -- p_init_msg_list in varchar2 := FND_API.G_FALSE,
228 -- p_commit in varchar2 := FND_API.G_FALSE,
229 -- p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
230 -- x_return_status OUT NOCOPY varchar2,
231 -- x_msg_count OUT NOCOPY number,
232 -- x_msg_data OUT NOCOPY varchar2,
233 -- p_link_id_tbl in cs_kb_number_tbl_type,
234 -- p_set_type_id_tbl in cs_kb_number_tbl_type
235 --);
236
237 PROCEDURE Change_Ele_Type_Links(
238 p_api_version in number,
239 p_init_msg_list in varchar2 := FND_API.G_FALSE,
240 p_commit in varchar2 := FND_API.G_FALSE,
241 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
242 x_return_status OUT NOCOPY varchar2,
243 x_msg_count OUT NOCOPY number,
244 x_msg_data OUT NOCOPY varchar2,
245 p_link_id_tbl in cs_kb_number_tbl_type,
246 p_ele_type_id_tbl in cs_kb_number_tbl_type
247 );
248 --
249 -- Update or Delete setlinks
250 -- (used when del set)
251 --
252 PROCEDURE Change_Set_Links(
253 p_api_version in number,
254 p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
255 p_commit in varchar2, -- := FND_API.G_FALSE,
256 p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
257 x_return_status OUT NOCOPY varchar2,
258 x_msg_count OUT NOCOPY number,
259 x_msg_data OUT NOCOPY varchar2,
260 p_link_id_tbl in cs_kb_number_tbl_type,
261 p_set_id_tbl in cs_kb_number_tbl_type
262 );
263
264 PROCEDURE Change_Element_Links(
265 p_api_version in number,
266 p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
267 p_commit in varchar2, -- := FND_API.G_FALSE,
268 p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
269 x_return_status OUT NOCOPY varchar2,
270 x_msg_count OUT NOCOPY number,
271 x_msg_data OUT NOCOPY varchar2,
272 p_link_id_tbl in cs_kb_number_tbl_type,
273 p_element_id_tbl in cs_kb_number_tbl_type
274 );
275
276 PROCEDURE Change_Element_To_Sets(
277 p_api_version in number,
278 p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
279 p_commit in varchar2, -- := FND_API.G_FALSE,
280 p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
281 x_return_status OUT NOCOPY varchar2,
282 x_msg_count OUT NOCOPY number,
283 x_msg_data OUT NOCOPY varchar2,
284 p_element_id in number,
285 p_set_id_tbl in cs_kb_number_tbl_type,
286 p_new_ele_id_tbl in cs_kb_number_tbl_type
287 );
288 --
289 -- Creation APIs using records
290 --
291
292 -- Original (Pre 8/03/00) Contributed element ids not passed back
293 PROCEDURE Create_Set_And_Elements(
294 p_api_version in number,
295 p_init_msg_list in varchar2 := FND_API.G_FALSE,
296 p_commit in varchar2 := FND_API.G_FALSE,
297 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
298 x_return_status OUT NOCOPY varchar2,
299 x_msg_count OUT NOCOPY number,
300 x_msg_data OUT NOCOPY varchar2,
301 p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
302 p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
303 -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
304 x_set_id OUT NOCOPY number
305 );
306
307 -- New (Post 8/03/00) Contributed element ids passed back
308 PROCEDURE Create_Set_And_Elements(
309 p_api_version in number,
310 p_init_msg_list in varchar2 := FND_API.G_FALSE,
311 p_commit in varchar2 := FND_API.G_FALSE,
312 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
313 x_return_status OUT NOCOPY varchar2,
314 x_msg_count OUT NOCOPY number,
315 x_msg_data OUT NOCOPY varchar2,
316 p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
317 p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
318 -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
319 x_set_id OUT NOCOPY number,
320 x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
321 );
322
323 PROCEDURE Create_Set(
324 p_api_version in number,
325 p_init_msg_list in varchar2 := FND_API.G_FALSE,
326 p_commit in varchar2 := FND_API.G_FALSE,
327 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
328 x_return_status OUT NOCOPY varchar2,
329 x_msg_count OUT NOCOPY number,
333 -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
330 x_msg_data OUT NOCOPY varchar2,
331 p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
332 p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
334 x_set_id OUT NOCOPY number
335 );
336
337 PROCEDURE Create_Element(
338 p_api_version in number,
339 p_init_msg_list in varchar2 := FND_API.G_FALSE,
340 p_commit in varchar2 := FND_API.G_FALSE,
341 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
342 x_return_status OUT NOCOPY varchar2,
343 x_msg_count OUT NOCOPY number,
344 x_msg_data OUT NOCOPY varchar2,
345 p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,
346 x_element_id OUT NOCOPY number
347 );
348
349
350 --
351 -- Creation APIs using objects
352 --
353
354 -- Original (Pre 8/03/00) Contributed element ids not passed back
355 PROCEDURE Create_Set_And_Elements(
356 p_api_version in number,
357 p_init_msg_list in varchar2 := FND_API.G_FALSE,
358 p_commit in varchar2 := FND_API.G_FALSE,
359 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
360 x_return_status OUT NOCOPY varchar2,
361 x_msg_count OUT NOCOPY number,
362 x_msg_data OUT NOCOPY varchar2,
363 p_set_def_obj in cs_kb_set_def_obj_type,
364 p_ele_def_tbl in cs_kb_ele_def_tbl_type,
365 -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
366 p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
367 x_set_id OUT NOCOPY number
368 );
369
370 -- New (Post 8/03/00) Contributed element ids passed back
371 PROCEDURE Create_Set_And_Elements(
372 p_api_version in number,
373 p_init_msg_list in varchar2 := FND_API.G_FALSE,
374 p_commit in varchar2 := FND_API.G_FALSE,
375 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
376 x_return_status OUT NOCOPY varchar2,
377 x_msg_count OUT NOCOPY number,
378 x_msg_data OUT NOCOPY varchar2,
379 p_set_def_obj in cs_kb_set_def_obj_type,
380 p_ele_def_tbl in cs_kb_ele_def_tbl_type,
381 -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
382 p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
383 x_set_id OUT NOCOPY number,
384 x_element_id_tbl OUT NOCOPY cs_kb_number_tbl_type
385 );
386
387 PROCEDURE Create_Set(
388 p_api_version in number,
389 p_init_msg_list in varchar2 := FND_API.G_FALSE,
390 p_commit in varchar2 := FND_API.G_FALSE,
391 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
392 x_return_status OUT NOCOPY varchar2,
393 x_msg_count OUT NOCOPY number,
394 x_msg_data OUT NOCOPY varchar2,
395 p_set_def_obj in cs_kb_set_def_obj_type,
396 p_ele_id_tbl in cs_kb_number_tbl_type,
397 -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
398 p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
399 x_set_id OUT NOCOPY number
400 );
401
402 PROCEDURE Create_Element(
403 p_api_version in number,
404 p_init_msg_list in varchar2 := FND_API.G_FALSE,
405 p_commit in varchar2 := FND_API.G_FALSE,
406 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
407 x_return_status OUT NOCOPY varchar2,
408 x_msg_count OUT NOCOPY number,
409 x_msg_data OUT NOCOPY varchar2,
410 p_ele_def_obj in cs_kb_ele_def_obj_type,
411 x_element_id OUT NOCOPY number
412 );
413
414 --
415 -- API for recording a set is useful
416 --
417
418 PROCEDURE Incr_Set_Useful(
419 p_api_version in number,
420 p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
421 p_commit in varchar2, -- := FND_API.G_FALSE,
422 p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
423 x_return_status OUT NOCOPY varchar2,
424 x_msg_count OUT NOCOPY number,
425 x_msg_data OUT NOCOPY varchar2,
426 p_set_id in number,
427 p_user_id in number,
428 p_used_type in varchar2, -- := CS_KNOWLEDGE_PVT.G_PF,
429 p_session_id in number DEFAULT NULL
430 );
431
432 --
433 -- Search APIs
434 --
435 --PROCEDURE Find_Eles_Matching (
436 -- p_api_version in number,
437 -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
438 -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
439 -- x_return_status OUT NOCOPY varchar2,
440 -- x_msg_count OUT NOCOPY number,
441 -- x_msg_data OUT NOCOPY varchar2,
442 -- p_query_str in varchar2,
443 -- p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
444 -- p_other_criteria in varchar2 := NULL,
445 -- p_rows in number,
446 -- p_start_score in number := null,
447 -- p_start_id in number := null,
448 -- p_start_row in number, -- := 1,
449 -- x_ele_tbl in OUT NOCOPY CS_Knowledge_PUB.ele_res_tbl_type,
450 -- p_search_option in number := null
451 --);
452
453 --PROCEDURE Find_Eles_Related (
454 -- p_api_version in number,
455 -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
456 -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
457 -- x_return_status OUT NOCOPY varchar2,
458 -- x_msg_count OUT NOCOPY number,
459 -- x_msg_data OUT NOCOPY varchar2,
460 -- p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
461 -- p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
465 -- p_start_id in number := null,
462 -- p_other_criteria in varchar2 := NULL,
463 -- p_rows in number,
464 -- p_start_score in number := null,
466 -- p_start_row in number, -- := 1,
467 -- x_ele_tbl in OUT NOCOPY CS_Knowledge_PUB.ele_res_tbl_type
468 --);
469
470 PROCEDURE Find_Sets_Matching (
471 p_api_version in number,
472 p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
473 p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
474 x_return_status OUT NOCOPY varchar2,
475 x_msg_count OUT NOCOPY number,
476 x_msg_data OUT NOCOPY varchar2,
477 p_pos_query_str in varchar2,
478 p_neg_query_str in varchar2 := null,
479 p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
480 p_other_criteria in varchar2 := NULL,
481 p_rows in number,
482 p_start_score in number := null,
483 p_start_id in number := null,
484 p_start_row in number, -- := 1,
485 p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
486 x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
487 x_total_rows OUT NOCOPY number,
488 p_search_option in number := null
489 );
490
491 PROCEDURE Find_Sets_Matching2 (
492 p_api_version in number,
493 p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
494 p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
495 x_return_status OUT NOCOPY varchar2,
496 x_msg_count OUT NOCOPY number,
497 x_msg_data OUT NOCOPY varchar2,
498 p_pos_query_str in varchar2,
499 -- p_neg_query_str in varchar2 := null,
500 p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
501 p_other_criteria in varchar2,
502 p_other_value in Number,
503 p_rows in number,
504 p_start_score in number := null,
505 p_start_id in number := null,
506 p_start_row in number, -- := 1,
507 p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
508 x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
509 x_total_rows OUT NOCOPY number,
510 p_search_option in number := null
511 );
512
513 --PROCEDURE Find_Sets_Related (
514 -- p_api_version in number,
515 -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
516 -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
517 -- x_return_status OUT NOCOPY varchar2,
518 -- x_msg_count OUT NOCOPY number,
519 -- x_msg_data OUT NOCOPY varchar2,
520 -- p_pos_ele_tbl in CS_Knowledge_PUB.number15_tbl_type,
521 -- p_neg_ele_tbl in CS_Knowledge_PUB.number15_tbl_type,
522 -- p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
523 -- p_other_criteria in varchar2 := NULL,
524 -- p_rows in number,
525 -- p_start_score in number := null,
526 -- p_start_id in number := null,
527 -- p_start_row in number, -- := 1,
528 -- x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type
529 --);
530
531
532 PROCEDURE Process_Frequency_Keyword (
533 p_query_str in out nocopy varchar2,
534 p_search_option in Number);
535
536
537 FUNCTION Build_Smart_Score_Query
538 (
539 p_current_query in varchar2,
540 p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
541 p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
542 p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
543 p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
544 )
545 return varchar2;
546
547 FUNCTION Build_Related_Stmt_Text_Query
548 ( p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type )
549 Return VARCHAR2;
550
551 FUNCTION Build_SR_Text_Query
552 (
553 p_string in varchar2,
554 p_search_option in number
555 )
556 return varchar2;
557
558 -- Add item_id
559 FUNCTION Build_SR_Text_Query
560 (
561 p_string in VARCHAR2,
562 p_item_id in NUMBER,
563 p_search_option in NUMBER
564 )
565 return varchar2;
566
567 end CS_Knowledge_Pvt;