1 PACKAGE CS_Knowledge_Grp AS
2 /* $Header: csgkbs.pls 120.0 2005/06/01 13:09:56 appldev noship $ */
3 --
4 -- CONSTANTS
5 --
6 G_PKG_NAME CONSTANT VARCHAR2(50) := 'CS_Knowledge_GRP';
7 --
8 -- Public
9 --
10 -- Start of comments
11 -- API Name : Construct_Text_Query
12 -- Type : Public
13 --
14 -- Parameters :
15 -- IN :
16 -- p_api_version IN NUMBER Required
17 -- p_init_msg_list IN VARCHAR2(1) Optional
18 -- Default = FND_API.G_FALSE
19 -- p_commit IN VARCHAR2(1) Optional
20 -- Default = FND_API.G_FALSE
21 -- p_validation_level IN NUMBER Optional
22 -- Default = FND_API.G_VALID_LEVEL_FULL
23 -- p_qry_string IN
24 -- String of keywords
25 -- p_search_option IN
26 -- Search option such as and, or, not, theme
27 --
28 -- OUT :
29 -- x_return_status OUT VARCHAR2(1)
30 -- x_msg_count OUT NUMBER
31 -- x_msg_data OUT VARCHAR2(2000)
32 -- x_qry_string OUT VARCHAR2(30000)
33 --
34 --
35 -- Version : Initial Version 1.0
36 --
37 -- Notes : (Post 8/10/01) x_qry_string return result of the construct
38 --
39 --
40 -- End of comments
41
42 PROCEDURE Construct_Text_Query(
43 p_api_version in number,
44 p_init_msg_list in varchar2 := FND_API.G_FALSE,
45 p_commit in varchar2 := FND_API.G_FALSE,
46 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
47 x_return_status OUT NOCOPY varchar2,
48 x_msg_count OUT NOCOPY number,
49 x_msg_data OUT NOCOPY varchar2,
50 p_qry_string in varchar2,
51 p_search_option in number,
52 x_qry_string OUT NOCOPY varchar2
53 );
54
55 -- Start of comments
56 -- API Name : Delete_Set_Link
57 -- Type : Group
58 -- Function : Delete set_link from set_id, object_code, other_id
59 -- Pre-reqs : Must have valid set_id/object_code/other_id
60 --
61 -- Parameters :
62 -- IN :
63 -- p_api_version IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2(1) Optional
65 -- Default = FND_API.G_FALSE
66 -- p_commit IN VARCHAR2(1) Optional
67 -- Default = FND_API.G_FALSE
68 -- p_validation_level IN NUMBER Optional
69 -- Default = FND_API.G_VALID_LEVEL_FULL
70 -- p_set_id IN NUMBER Required
71 -- p_object_code IN VARCHAR2 Required
72 -- p_other_id IN NUMBER Required
73 -- OUT :
74 -- x_return_status OUT VARCHAR2(1)
75 -- x_msg_count OUT NUMBER
76 -- x_msg_data OUT VARCHAR2(2000)
77
78 --
79 -- Version : Initial Version 1.0
80 --
81 -- Notes :
82 --
83 -- End of comments
84
85 PROCEDURE Delete_Set_Link(
86 p_api_version in number,
87 p_init_msg_list in varchar2 := FND_API.G_FALSE,
88 p_commit in varchar2 := FND_API.G_FALSE,
89 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
90 x_return_status OUT NOCOPY varchar2,
91 x_msg_count OUT NOCOPY number,
92 x_msg_data OUT NOCOPY varchar2,
93 p_set_id in number,
94 p_object_code in varchar2,
95 p_other_id in number
96 );
97
98 -- Start of comments
99 -- API Name : Delete_Element_Link
100 -- Type : Group
101 -- Function : Delete element_link from set_id, object_code, other_id
102 -- Pre-reqs : Must have valid element_id/object_code/other_id
103 --
104 -- Parameters :
105 -- IN :
106 -- p_api_version IN NUMBER Required
107 -- p_init_msg_list IN VARCHAR2(1) Optional
108 -- Default = FND_API.G_FALSE
109 -- p_commit IN VARCHAR2(1) Optional
110 -- Default = FND_API.G_FALSE
111 -- p_validation_level IN NUMBER Optional
112 -- Default = FND_API.G_VALID_LEVEL_FULL
113 -- p_element_id IN NUMBER Required
114 -- p_object_code IN VARCHAR2 Required
115 -- p_other_id IN NUMBER Required
116 -- OUT :
117 -- x_return_status OUT VARCHAR2(1)
118 -- x_msg_count OUT NUMBER
119 -- x_msg_data OUT VARCHAR2(2000)
120
121 --
122 -- Version : Initial Version 1.0
123 --
124 -- Notes :
125 --
126 -- End of comments
127
128 PROCEDURE Delete_Element_Link(
129 p_api_version in number,
130 p_init_msg_list in varchar2 := FND_API.G_FALSE,
131 p_commit in varchar2 := FND_API.G_FALSE,
132 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
133 x_return_status OUT NOCOPY varchar2,
134 x_msg_count OUT NOCOPY number,
135 x_msg_data OUT NOCOPY varchar2,
136 p_element_id in number,
137 p_object_code in varchar2,
138 p_other_id in number
139 );
140
141 -- Start of comments
142 -- API Name : Create_Set_And_Elements
143 -- Type : Group
144 -- Function : Create a set using given elements
145 -- Pre-reqs : Must have valid set/element types
146 --
147 -- Parameters :
148 -- IN :
149 -- p_api_version IN NUMBER Required
150 -- p_init_msg_list IN VARCHAR2(1) Optional
151 -- Default = FND_API.G_FALSE
152 -- p_commit IN VARCHAR2(1) Optional
153 -- Default = FND_API.G_FALSE
154 -- p_validation_level IN NUMBER Optional
155 -- Default = FND_API.G_VALID_LEVEL_FULL
156 -- p_set_def_rec IN
157 -- CS_Knowledge_PUB.set_def_rec_type Required
158 -- Definition of the set. Must have set type, status, name.
159 -- p_ele_def_tbl IN
160 -- CS_Knowledge_PUB.ele_def_tbl_type Required
161 -- Each record defines an element. If element id is given,
162 -- it is used, otherwise the api uses other fields to
163 -- create the element.
164 --
165 -- OUT :
166 -- x_return_status OUT VARCHAR2(1)
167 -- x_msg_count OUT NUMBER
168 -- x_msg_data OUT VARCHAR2(2000)
169 -- x_set_id OUT NUMBER
170 -- The created set id.
171 --
172 --
173 -- Version : Initial Version 1.0
174 --
175 -- Notes :
176 --
177 --
178 -- End of comments
179
180 PROCEDURE Create_Set_And_Elements(
181 p_api_version in number,
182 p_init_msg_list in varchar2 := FND_API.G_FALSE,
183 p_commit in varchar2 := FND_API.G_FALSE,
184 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
185 x_return_status OUT NOCOPY varchar2,
186 x_msg_count OUT NOCOPY number,
187 x_msg_data OUT NOCOPY varchar2,
188 p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
189 p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
190 x_set_id OUT NOCOPY number
191 );
192
193
194 -- Start of comments
195 -- API Name : Create_Set_And_Elements
196 -- Type : Group
197 -- Function : Create a set using given elements
198 -- Pre-reqs : Must have valid set/element types
199 --
200 -- Parameters :
201 -- IN :
202 -- p_api_version IN NUMBER Required
203 -- p_init_msg_list IN VARCHAR2(1) Optional
204 -- Default = FND_API.G_FALSE
205 -- p_commit IN VARCHAR2(1) Optional
206 -- Default = FND_API.G_FALSE
207 -- p_validation_level IN NUMBER Optional
208 -- Default = FND_API.G_VALID_LEVEL_FULL
209 -- p_set_def_rec IN
210 -- CS_Knowledge_PUB.set_def_rec_type Required
211 -- Definition of the set. Must have set type, status, name.
212 -- p_ele_def_tbl IN
213 -- CS_Knowledge_PUB.ele_def_tbl_type Required
214 -- Each record defines an element. If element id is given,
215 -- it is used, otherwise the api uses other fields to
216 -- create the element.
217 --
218 -- OUT :
219 -- x_return_status OUT VARCHAR2(1)
220 -- x_msg_count OUT NUMBER
221 -- x_msg_data OUT VARCHAR2(2000)
222 -- x_set_id OUT NUMBER
223 -- The created set id.
224 -- x_element_id_tbl OUT CS_Knowledge_PUB.number15_tbl_type
225 -- Table of element ids associated with the statements contributed
226 --
227 --
228 -- Version : Initial Version 1.0
229 --
230 -- Notes : (Post 8/03/00) Contributed element ids passed back
231 --
232 --
233 -- End of comments
234
235 PROCEDURE Create_Set_And_Elements(
236 p_api_version in number,
237 p_init_msg_list in varchar2 := FND_API.G_FALSE,
238 p_commit in varchar2 := FND_API.G_FALSE,
239 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
240 x_return_status OUT NOCOPY varchar2,
241 x_msg_count OUT NOCOPY number,
242 x_msg_data OUT NOCOPY varchar2,
243 p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
244 p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
245 x_set_id OUT NOCOPY number,
246 x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
247 );
248
249
250
251 -- Start of comments
252 -- API Name : Create_Set
253 -- Type : Group
254 -- Function : Create a set using given elements
255 -- Pre-reqs : Must have valid set/element types
256 --
257 -- Parameters :
258 -- IN :
259 -- p_api_version IN NUMBER Required
260 -- p_init_msg_list IN VARCHAR2(1) Optional
261 -- Default = FND_API.G_FALSE
262 -- p_commit IN VARCHAR2(1) Optional
263 -- Default = FND_API.G_FALSE
264 -- p_validation_level IN NUMBER Optional
265 -- Default = FND_API.G_VALID_LEVEL_FULL
266 -- p_set_def_rec IN
267 -- CS_Knowledge_PUB.set_def_rec_type Required
268 -- Definition of the set. Must have set type, status, name.
269 -- p_ele_id_tbl IN
270 -- CS_Knowledge_PUB.number15_tbl_type Required
271 -- Element ids for creating the solution set.
272 --
273 -- OUT :
274 -- x_return_status OUT VARCHAR2(1)
275 -- x_msg_count OUT NUMBER
276 -- x_msg_data OUT VARCHAR2(2000)
277 -- x_set_id OUT NUMBER
278 -- The created set id.
279 --
280 --
281 -- Version : Initial Version 1.0
282 --
283 -- Notes :
284 --
285 --
286 -- End of comments
287
288 PROCEDURE Create_Set(
289 p_api_version in number,
290 p_init_msg_list in varchar2 := FND_API.G_FALSE,
291 p_commit in varchar2 := FND_API.G_FALSE,
292 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
293 x_return_status OUT NOCOPY varchar2,
294 x_msg_count OUT NOCOPY number,
295 x_msg_data OUT NOCOPY varchar2,
296 p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
297 p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
298 x_set_id OUT NOCOPY number
299 );
300
301
302 -- Start of comments
303 -- API Name : Create_Element
304 -- Type : Group
305 -- Function : Create element
306 -- Pre-reqs :
307 --
308 -- Parameters :
309 -- IN :
310 -- p_api_version IN NUMBER Required
311 -- p_init_msg_list IN VARCHAR2(1) Optional
312 -- Default = FND_API.G_FALSE
313 -- p_commit IN VARCHAR2(1) Optional
314 -- Default = FND_API.G_FALSE
315 -- p_validation_level IN NUMBER Optional
316 -- Default = FND_API.G_VALID_LEVEL_FULL
317 -- p_ele_def_rec IN
318 -- CS_Knowledge_PUB.ele_def_rec_type Required
319 -- Definition of element.
320 --
321 -- OUT :
322 -- x_return_status OUT VARCHAR2(1)
323 -- x_msg_count OUT NUMBER
324 -- x_msg_data OUT VARCHAR2(2000)
325 -- x_element_id OUT NUMBER
326 -- The created element id.
327 --
328 --
329 -- Version : Initial Version 1.0
330 --
331 -- Notes :
332 --
333 --
334 -- End of comments
335
336 PROCEDURE Create_Element(
337 p_api_version in number,
338 p_init_msg_list in varchar2 := FND_API.G_FALSE,
339 p_commit in varchar2 := FND_API.G_FALSE,
340 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
341 x_return_status OUT NOCOPY varchar2,
342 x_msg_count OUT NOCOPY number,
343 x_msg_data OUT NOCOPY varchar2,
344 p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,
345 x_element_id OUT NOCOPY number
346 );
347
348 -- Start of comments
349 -- API Name : Find_Sets_Matching
350 -- Type : Group
351 -- Function : Search for sets with elements matching given search string
352 -- Pre-reqs :
353 --
354 -- Parameters :
355 -- IN :
356 -- p_api_version IN NUMBER Required
357 -- p_init_msg_list IN VARCHAR2(1) Optional
358 -- Default = FND_API.G_FALSE
359 -- p_validation_level IN NUMBER Optional
360 -- Default = FND_API.G_VALID_LEVEL_FULL
361 -- p_pos_query_str IN VARCHAR2 Required
362 -- p_neg_query_str IN VARCHAR2 Optional
363 -- Default = null
364 -- p_type_id_tbl IN
365 -- CS_Knowledge_PUB.number15_tbl_type Required
366 -- Ids of set types to look for.
367 -- p_other_criteria IN VARCHAR2 Optional
368 -- Default = NULL
369 -- p_rows IN NUMBER Required
370 -- p_start_score IN NUMBER Optional
371 -- Default = NULL
372 -- p_start_id IN NUMBER Optional
373 -- Default = NULL
374 --
375 -- OUT :
376 -- x_return_status OUT VARCHAR2(1)
377 -- x_msg_count OUT NUMBER
378 -- x_msg_data OUT VARCHAR2(2000)
379 -- x_set_tbl IN OUT CS_Knowledge_PUB.set_res_tbl_type
380 --
381 --
382 -- Version : Initial Version 1.0
383 --
384 -- Notes : Search for sets containing elements matching given
385 -- query string.
386 -- Query string is used to do about() search.
387 -- Results are returned in x_set_tbl
388 -- ordered by descending score and id.
389 -- User may specify starting score and id, along with
390 -- number of rows, to fetch into result set.
391 --
392 --
393 -- End of comments
394
395 PROCEDURE Find_Sets_Matching (
396 p_api_version in number,
397 p_init_msg_list in varchar2 := FND_API.G_FALSE,
398 --p_commit in varchar2 := FND_API.G_FALSE,
399 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
400 x_return_status OUT NOCOPY varchar2,
401 x_msg_count OUT NOCOPY number,
402 x_msg_data OUT NOCOPY varchar2,
403 p_pos_query_str in varchar2,
404 p_neg_query_str in varchar2 := null,
405 p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
406 p_other_criteria in varchar2 := NULL,
407 p_rows in number,
408 p_start_score in number := null,
409 p_start_id in number := null,
410 x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type
411 );
412
413 -- Start of comments
414 -- API Name : Create_Element_Link
415 -- Type : Group
416 -- Function : Create element link
417 -- Pre-reqs :
418 --
419 -- Parameters :
420 -- IN :
421 -- p_api_version IN NUMBER Required
422 -- p_init_msg_list IN VARCHAR2(1) Optional
423 -- Default = FND_API.G_FALSE
424 -- p_commit IN VARCHAR2(1) Optional
425 -- Default = FND_API.G_FALSE
426 -- p_validation_level IN NUMBER Optional
427 -- Default = FND_API.G_VALID_LEVEL_FULL
428 -- p_element_link_rec IN
429 -- CS_KB_ELEMENT_LINKS%ROWTYPE Required
430 -- Definition of element link
431 --
432 -- OUT :
433 -- x_return_status OUT VARCHAR2(1)
434 -- x_msg_count OUT NUMBER
435 -- x_msg_data OUT VARCHAR2(2000)
436 -- x_element_link_id OUT NUMBER
437 -- The created id.
438 --
439 -- Version : Initial Version 1.0
440 -- Notes :
441 --
442 -- End of comments
443
444 PROCEDURE Create_Element_Link(
445 p_api_version in number,
449 x_return_status OUT NOCOPY varchar2,
446 p_init_msg_list in varchar2 := FND_API.G_FALSE,
447 p_commit in varchar2 := FND_API.G_FALSE,
448 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
450 x_msg_count OUT NOCOPY number,
451 x_msg_data OUT NOCOPY varchar2,
452 p_element_link_rec in CS_KB_ELEMENT_LINKS%ROWTYPE,
453 x_element_link_id OUT NOCOPY number
454 );
455
456 -- Start of comments
457 -- API Name : Create_Set_Link
458 -- Type : Group
459 -- Function : Create set link
460 -- Pre-reqs :
461 --
462 -- Parameters :
463 -- IN :
464 -- p_api_version IN NUMBER Required
465 -- p_init_msg_list IN VARCHAR2(1) Optional
466 -- Default = FND_API.G_FALSE
467 -- p_commit IN VARCHAR2(1) Optional
468 -- Default = FND_API.G_FALSE
469 -- p_validation_level IN NUMBER Optional
470 -- Default = FND_API.G_VALID_LEVEL_FULL
471 -- p_set_link_rec IN
472 -- CS_KB_SET_LINKS%ROWTYPE Required
473 -- Definition of set link
474 --
475 -- OUT :
476 -- x_return_status OUT VARCHAR2(1)
477 -- x_msg_count OUT NUMBER
478 -- x_msg_data OUT VARCHAR2(2000)
479 -- x_set_link_id OUT NUMBER
480 -- The created id.
481 --
482 -- Version : Initial Version 1.0
483 -- Notes :
484 --
485 -- End of comments
486
487 PROCEDURE Create_Set_Link(
488 p_api_version in number,
489 p_init_msg_list in varchar2 := FND_API.G_FALSE,
490 p_commit in varchar2 := FND_API.G_FALSE,
491 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
492 x_return_status OUT NOCOPY varchar2,
493 x_msg_count OUT NOCOPY number,
494 x_msg_data OUT NOCOPY varchar2,
495 p_set_link_rec in CS_KB_SET_LINKS%ROWTYPE,
496 x_set_link_id OUT NOCOPY number
497 );
498
499 PROCEDURE Update_Set_Link(
500 p_api_version in number,
501 p_init_msg_list in varchar2 := FND_API.G_FALSE,
502 p_commit in varchar2 := FND_API.G_FALSE,
503 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
504 x_return_status OUT NOCOPY varchar2,
505 x_msg_count OUT NOCOPY number,
506 x_msg_data OUT NOCOPY varchar2,
507 p_set_link_rec in CS_KB_SET_LINKS%ROWTYPE
508 );
509
510 -- This api is called by java.
511 -- It takes object params, convert to amv record types and call
512 -- the record type api.
513 --
514 PROCEDURE Specific_Search(
515 p_api_version IN NUMBER,
516 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
517 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
518 x_return_status OUT NOCOPY VARCHAR2,
519 x_msg_count OUT NOCOPY NUMBER,
520 x_msg_data OUT NOCOPY VARCHAR2,
521 p_repository_tbl IN cs_kb_varchar100_tbl_type,
522 p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
523 p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
524 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
525 p_application_id IN NUMBER,
526 p_area_array IN JTF_VARCHAR2_TABLE_4000 := null,
527 p_content_array IN JTF_VARCHAR2_TABLE_4000 := null,
528 p_param_operator_array IN JTF_VARCHAR2_TABLE_100 := null,
529 p_param_searchstring_array IN JTF_VARCHAR2_TABLE_400 := null,
530 p_user_id IN NUMBER := FND_API.G_MISS_NUM,
531 p_category_id IN JTF_NUMBER_TABLE,
532 p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
533 p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
534 p_rows_requested_tbl IN cs_kb_number_tbl_type,
535 p_start_row_pos_tbl IN cs_kb_number_tbl_type,
536 p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
537 x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
538 x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
539 x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
540 x_result_array OUT NOCOPY cs_kb_result_varray_type,
541 p_search_option IN NUMBER := NULL
542
543 );
544
545 -- Start of comments
546 -- API Name : Specific_Search
547 -- Type : Group
548 -- Function : Search MES and SMS
549 -- Pre-reqs : Must have SMS and MES
550 --
551 -- Parameters :
552 -- IN : p_api_version IN NUMBER Required
553 -- p_init_msg_list IN VARCHAR2(1) Optional
554 -- Default = FND_API.G_FALSE
555 -- p_validation_level IN NUMBER Optional
556 -- Default = FND_API.G_VALID_LEVEL_FULL
557 -- p_repository_tbl IN
558 -- cs_kb_varchar100_tbl_type Required
559 -- valid values are MES, SMS, ALL
560 -- p_search_string IN VARCHAR2 Optional
561 -- := FND_API.G_MISS_CHAR
562 -- used for interMedia search on SMS or MES contents.
563 -- p_updated_in_days IN NUMBER Optional
564 -- := FND_API.G_MISS_NUM
565 -- days since last updated. For MES.
566 -- p_check_login_user IN VARCHAR2 Optional
567 -- := FND_API.G_TRUE
568 -- whether or not to check login user's access privilege. For MES.
569 -- p_application_id IN NUMBER Required
570 -- p_area_array IN
571 -- AMV_SEARCH_PVT.amv_char_varray_type Optional
575 -- AMV_SEARCH_PVT.amv_char_varray_type Optional
572 -- := AMV_SEARCH_PVT.amv_char_varray_type()
573 -- valid values are ITEM, CATEGORY. For MES
574 -- p_content_array IN
576 -- := AMV_SEARCH_PVT.amv_char_varray_type()
577 -- valid values are KEYWORD, AUTHOR, TITLE_DESC, CONTENT. for MES
578 -- p_param_array IN
579 -- AMV_SEARCH_PVT.amv_searchpar_varray_type Optional
580 -- := AMV_SEARCH_PVT.amv_searchpar_varray_type()
581 -- For MES. Consists of operator and search string
582 -- valid values for operator are
583 -- CAN_CONTAIN, MUST_CONTAIN, MUST_NOT_CONTAIN
584 -- Do not use this for interMedia search on content.
585 -- This is only for searching keyword, author, title_desc.
586 -- p_user_id IN NUMBER Optional
587 -- := FND_API.G_MISS_NUM
588 -- For MES
589 -- p_category_id IN
590 -- AMV_SEARCH_PVT.amv_number_varray_type Optioanl
591 -- := AMV_SEARCH_PVT.amv_number_varray_type()
592 -- MES category identifier. Empty obj to search all MES categories.
593 -- p_include_subcats IN VARCHAR2 Optional
594 -- := FND_API.G_FALSE
595 -- Include sub categories. MES
596 -- p_external_contents IN VARCHAR2 Optional
597 -- := FND_API.G_FALSE
598 -- Include external contents. MES
599 -- p_rows_requested_tbl IN cs_kb_number_tbl_type Required
600 -- Number of rows requested
601 -- p_start_row_pos_tbl IN cs_kb_number_tbl_type Required
602 -- Start row position
603 -- p_get_total_cnt_flag IN VARCHAR2 Optional
604 -- := fnd_api.g_true
605 -- Whether to get total count
606 --
607 --
608 -- OUT :
609 -- x_return_status OUT VARCHAR2(1)
610 -- x_msg_count OUT NUMBER
611 -- x_msg_data OUT VARCHAR2(2000)
612 -- x_rows_returned_tbl OUT cs_kb_number_tbl_type,
613 -- Number of rows returned
614 -- x_next_row_pos_tbl OUT cs_kb_number_tbl_type,
615 -- Next row position
616 -- x_total_row_cnt_tbl OUT cs_kb_number_tbl_type,
617 -- Total row count
618 -- x_result_array OUT cs_kb_result_varray_type
619 --
620 -- Version : Initial Version 1.0
621 --
622 -- Notes : For object types, use empty objects instead of nulls
623 -- for the api(and MES apis) to work correctly.
624 --
625 --
626 -- End of comments
627 --
628 PROCEDURE Specific_Search(
629 p_api_version IN NUMBER,
630 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
631 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632 x_return_status OUT NOCOPY VARCHAR2,
633 x_msg_count OUT NOCOPY NUMBER,
634 x_msg_data OUT NOCOPY VARCHAR2,
635 p_repository_tbl IN cs_kb_varchar100_tbl_type,
636 p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
637 p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
638 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
639 p_application_id IN NUMBER,
640 p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
641 := AMV_SEARCH_PVT.amv_char_varray_type(),
642 p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
643 := AMV_SEARCH_PVT.amv_char_varray_type(),
644 p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
645 := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
646 p_user_id IN NUMBER := FND_API.G_MISS_NUM,
647 p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
648 := AMV_SEARCH_PVT.amv_number_varray_type(),
649 p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
650 p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
651 p_rows_requested_tbl IN cs_kb_number_tbl_type,
652 p_start_row_pos_tbl IN cs_kb_number_tbl_type,
653 p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
654 x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
655 x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
656 x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
657 x_result_array OUT NOCOPY cs_kb_result_varray_type,
658 p_search_option IN NUMBER := NULL
659
660 );
661
662
663 --
664 -- Main Specific search
665 -- Same as above. With x_amv_result_array out parameter returned from Amv.
666 --
667 PROCEDURE Specific_Search(
668 p_api_version IN NUMBER,
669 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
670 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
671 x_return_status OUT NOCOPY VARCHAR2,
672 x_msg_count OUT NOCOPY NUMBER,
673 x_msg_data OUT NOCOPY VARCHAR2,
674 p_repository_tbl IN cs_kb_varchar100_tbl_type,
675 p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
676 p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
677 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
678 p_application_id IN NUMBER,
679 p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
680 := AMV_SEARCH_PVT.amv_char_varray_type(),
681 p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
682 := AMV_SEARCH_PVT.amv_char_varray_type(),
686 p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
683 p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
684 := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
685 p_user_id IN NUMBER := FND_API.G_MISS_NUM,
687 := AMV_SEARCH_PVT.amv_number_varray_type(),
688 p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
689 p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
690 p_rows_requested_tbl IN cs_kb_number_tbl_type,
691 p_start_row_pos_tbl IN cs_kb_number_tbl_type,
692 p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
693 x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
694 x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
695 x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
696 x_result_array OUT NOCOPY cs_kb_result_varray_type,
697 x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type,
698 p_search_option IN NUMBER := NULL
699
700 );
701
702 -- Start of comments
703 -- API name : Purge_Knowledge_Links
704 -- Type : Group
705 -- Pre-reqs : None
706 -- Function : Performs a Purge of Knowledge Links for a given object
707 -- Parameters :
708 -- IN p_api_version Required
709 -- p_init_msg_list Optional - Default False
710 -- P_COMMIT Optional - Default False
711 -- P_PROCESSING_SET_ID Required - Processing Set - identifies rows to be purged
712 -- P_OBJECT_TYPE Required - The Object (FK Jtf_Objects_vl.object_code)
713 -- OUT : x_return_status
714 -- x_msg_count
715 -- x_msg_data
716 -- Version : Initial version 1.0
717 -- Notes :
718 -- End of comments
719 PROCEDURE Purge_Knowledge_Links (
720 P_API_VERSION IN NUMBER,
721 P_INIT_MSG_LIST IN VARCHAR2,
722 P_COMMIT IN VARCHAR2,
723 P_PROCESSING_SET_ID IN NUMBER,
724 P_OBJECT_TYPE IN VARCHAR2,
725 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
726 X_MSG_COUNT OUT NOCOPY NUMBER,
727 X_MSG_DATA OUT NOCOPY VARCHAR2);
728
729
730 end CS_Knowledge_Grp;