1 PACKAGE CS_KNOWLEDGE_AUDIT_PVT AUTHID CURRENT_USER AS
2 /* $Header: cskbaps.pls 120.1.12010000.2 2009/10/21 12:47:12 amganapa ship $ */
3
4 /* for RETURN status */
5 ERROR_STATUS CONSTANT NUMBER := -1;
6 OKAY_STATUS CONSTANT NUMBER := 0;
7
8 /* for cs_kb_set_eles.assoc_degree */
9 POSITIVE_ASSOC CONSTANT NUMBER := 1;
10 NEGATIVE_ASSOC CONSTANT NUMBER := -1;
11
12 /* DEFAULT increment for count */
13 COUNT_INCR CONSTANT NUMBER := 1;
14 COUNT_INIT CONSTANT NUMBER := 1;
15
16 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18
19 VALIDATION_ERROR EXCEPTION;
20 INVALID_FLOW EXCEPTION;
21 INVALID_SET_NUMBER EXCEPTION;
22 INVALID_SET_TYPE_NAME EXCEPTION;
23 INVALID_ELEMENT_TYPE_NAME EXCEPTION;
24 INVALID_ELEMENT_TYPE EXCEPTION;
25 INVALID_SET_ELEMENT_TYPE_MAP EXCEPTION;
26 INVALID_VISIBILITY_LEVEL EXCEPTION;
27 INVALID_ACCESS_LEVEL EXCEPTION;
28 INVALID_PRODUCT_NAME EXCEPTION;
29 INVALID_PRODUCT_SEGMENT EXCEPTION;
30 INVALID_PLATFORM_NAME EXCEPTION;
31 INVALID_PLATFORM_SEGMENT EXCEPTION;
32 INVALID_CATEGORY_NAME EXCEPTION;
33 INVALID_ELEMENT_CONTENT_TYPE EXCEPTION;
34 INVALID_ELEMENT_NUMBER EXCEPTION;
35 DUPLICATE_ELEMENT_NAME EXCEPTION;
36 DUPLICATE_SET_NAME EXCEPTION;
37 PRODUCT_LINK_ERROR EXCEPTION;
38 PLATFORM_LINK_ERROR EXCEPTION;
39 CATEGORY_LINK_ERROR EXCEPTION;
40 SET_ELEMENT_LINK_ERROR EXCEPTION;
41 MANDATORY_STATEMENT_MISSING EXCEPTION;
42 MANDATORY_CATEGORY_MISSING EXCEPTION;
43
44 --klou (SRCHEFF)
45 INVALID_USAGE_TIME_SPAN_ERROR EXCEPTION;
46 INVALID_COEFFICIENT_FACTOR EXCEPTION;
47
48 FUNCTION Is_Element_Updatable
49 (
50 p_element_number IN VARCHAR2,
51 p_set_number IN VARCHAR2
52 )
53 RETURN VARCHAR2;
54
55 FUNCTION Get_Missing_Ele_Type
56 (
57 p_set_id IN NUMBER--,
58 )
59 RETURN VARCHAR2;
60
61 FUNCTION Decrypt
62 (
63 KEY IN VARCHAR2,
64 VALUE IN VARCHAR2
65 )
66 RETURN VARCHAR2;
67
68
69 PROCEDURE Get_Who
70 (
71 x_sysdate OUT NOCOPY DATE,
72 x_user_id OUT NOCOPY NUMBER,
73 x_login_id OUT NOCOPY NUMBER
74 );
75
76 FUNCTION Is_Set_Ele_Type_Valid
77 (
78 p_set_number IN VARCHAR2 := NULL,
79 p_set_type_id IN NUMBER :=NULL,
80 p_element_number IN VARCHAR2 := NULL,
81 p_ele_type_id IN NUMBER :=NULL
82 ) RETURN VARCHAR2;
83
84 FUNCTION Del_Element_From_Set
85 (
86 p_element_id IN NUMBER,
87 p_set_id IN NUMBER
88 ) RETURN NUMBER;
89
90 FUNCTION Add_Element_To_Set
91 (
92 p_element_number IN VARCHAR2,
93 p_set_id IN NUMBER,
94 p_assoc_degree IN NUMBER := CS_KNOWLEDGE_PUB.G_POSITIVE_ASSOC
95 ) RETURN NUMBER;
96
97 FUNCTION Create_Element_And_Link_To_Set
98 (
99 p_element_type_id IN NUMBER,
100 p_desc IN VARCHAR2,
101 p_name IN VARCHAR2,
102 p_status IN VARCHAR2 DEFAULT NULL,
103 p_access_level IN NUMBER DEFAULT NULL,
104 p_attribute_category IN VARCHAR2 DEFAULT NULL,
105 p_attribute1 IN VARCHAR2 DEFAULT NULL,
106 p_attribute2 IN VARCHAR2 DEFAULT NULL,
107 p_attribute3 IN VARCHAR2 DEFAULT NULL,
108 p_attribute4 IN VARCHAR2 DEFAULT NULL,
109 p_attribute5 IN VARCHAR2 DEFAULT NULL,
110 p_attribute6 IN VARCHAR2 DEFAULT NULL,
111 p_attribute7 IN VARCHAR2 DEFAULT NULL,
112 p_attribute8 IN VARCHAR2 DEFAULT NULL,
113 p_attribute9 IN VARCHAR2 DEFAULT NULL,
114 p_attribute10 IN VARCHAR2 DEFAULT NULL,
115 p_attribute11 IN VARCHAR2 DEFAULT NULL,
116 p_attribute12 IN VARCHAR2 DEFAULT NULL,
117 p_attribute13 IN VARCHAR2 DEFAULT NULL,
118 p_attribute14 IN VARCHAR2 DEFAULT NULL,
119 p_attribute15 IN VARCHAR2 DEFAULT NULL,
120 p_set_id IN NUMBER,
121 p_assoc_degree IN NUMBER := CS_Knowledge_PUB.G_POSITIVE_ASSOC,
122 p_locked_by IN NUMBER DEFAULT NULL,
123 p_start_active_date IN DATE DEFAULT NULL,
124 p_end_active_date IN DATE DEFAULT NULL,
125 p_content_type IN VARCHAR2 DEFAULT NULL
126 ) RETURN NUMBER;
127
128 -- Sort elements IN a solution
129 -- based on the element_type_order defined IN cs.cs_kb_set_ele_types
130 FUNCTION Sort_Element_Order(p_set_number IN VARCHAR2)
131 RETURN NUMBER;
132
133 PROCEDURE Auto_Obsolete_Draft_Stmts(p_set_number IN VARCHAR2,
134 p_max_set_id IN NUMBER);
135
136 PROCEDURE Auto_Obsolete_For_Solution_Pub(p_set_number IN VARCHAR2,
137 p_max_set_id IN NUMBER);
138
139 PROCEDURE Auto_Obsolete_For_Solution_Obs(p_set_number IN VARCHAR2,
140 p_max_set_id IN NUMBER);
141
142 FUNCTION Is_Pub_Element_Obsoletable(p_element_id IN NUMBER) RETURN NUMBER;
143
144 PROCEDURE Obs_Elmt_Status_With_Check(p_element_id IN NUMBER);
145
146 PROCEDURE Transfer_Note_To_Element(p_note_id IN NUMBER, p_element_id IN NUMBER);
147
148 FUNCTION Get_Concatenated_Elmt_Details(p_set_id IN NUMBER) RETURN CLOB;
149
150 FUNCTION Create_Set_With_Validation
151 (
152 p_api_version in number,
153 p_init_msg_list in varchar2 := FND_API.G_FALSE,
154 p_commit in varchar2 := FND_API.G_FALSE,
155 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
156 x_return_status OUT NOCOPY varchar2,
157 x_msg_count OUT NOCOPY number,
158 x_msg_data OUT NOCOPY varchar2,
159 p_set_type_name in varchar2,
160 p_set_visibility in varchar2,
161 p_set_title in varchar2,
162 p_set_flow_name in VARCHAR2 DEFAULT NULL,
163 p_set_flow_stepcode in VARCHAR2 DEFAULT NULL,
164 p_set_products in JTF_VARCHAR2_TABLE_2000,
165 p_set_platforms in JTF_VARCHAR2_TABLE_2000,
166 p_set_categories in JTF_VARCHAR2_TABLE_2000,
167 p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
168 p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
169 p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
170 p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
171 p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
172 p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
173 p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
174 p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
175 p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
176 p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
177 x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
178 x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
179 x_set_number OUT NOCOPY VARCHAR2) RETURN NUMBER;
180
181 FUNCTION Update_Set_With_Validation
182 (
183 p_api_version in number,
184 p_init_msg_list in varchar2 := FND_API.G_FALSE,
185 p_commit in varchar2 := FND_API.G_FALSE,
186 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
187 x_return_status OUT NOCOPY varchar2,
188 x_msg_count OUT NOCOPY number,
189 x_msg_data OUT NOCOPY varchar2,
190 p_set_number in varchar2,
191 p_set_type_name in varchar2,
192 p_set_visibility in varchar2,
193 p_set_title in varchar2,
194 p_set_products in JTF_VARCHAR2_TABLE_2000,
195 p_set_platforms in JTF_VARCHAR2_TABLE_2000,
196 p_set_categories in JTF_VARCHAR2_TABLE_2000,
197 p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
198 p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
199 p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
200 p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
201 p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
202 p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
203 p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
204 p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
205 p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
206 p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
207 x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
208 x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
209 x_set_id OUT NOCOPY number) RETURN NUMBER;
210
211 FUNCTION Validate_Set_Type_Name_Create
212 (
213 p_set_type_name IN VARCHAR2,
214 x_set_type_id OUT NOCOPY NUMBER
215 ) RETURN NUMBER;
216
217 FUNCTION Validate_Set_Type_Name_Update
218 (
219 p_set_id IN NUMBER,
220 p_set_type_name IN VARCHAR2,
221 x_set_type_id OUT NOCOPY NUMBER
222 ) RETURN NUMBER;
223
224 FUNCTION Validate_Flow
225 (
226 p_flow_name IN VARCHAR2,
227 p_flow_step IN VARCHAR2,
228 x_flow_details_id OUT NOCOPY NUMBER
229 ) RETURN NUMBER;
230
231 FUNCTION Validate_Set_Number
232 (
233 p_set_number IN varchar2,
234 x_set_id OUT NOCOPY NUMBER
235 ) RETURN NUMBER;
236
237 FUNCTION Validate_Element_Type_Name
238 (
239 p_Element_type_name IN VARCHAR2,
240 x_element_type_id OUT NOCOPY NUMBER
241 ) RETURN NUMBER;
242
243 FUNCTION Resolve_Element_Type_ID
244 (
245 p_Element_number IN VARCHAR2,
246 x_element_type_id OUT NOCOPY NUMBER
247 ) RETURN NUMBER;
248
249 FUNCTION Validate_Set_Element_Type_Ids
250 (
251 p_set_type_id IN NUMBER,
252 p_element_type_ids IN JTF_NUMBER_TABLE
253
254 ) RETURN NUMBER;
255
256 FUNCTION VALIDATE_VISIBILITY_LEVEL
257 (
258 p_visibility_name IN VARCHAR2,
259 x_visibility_id OUT NOCOPY NUMBER
260 ) RETURN VARCHAR2;
261
262 FUNCTION VALIDATE_ACCESS_LEVEL
263 (
264 p_access_level_name IN VARCHAR2,
265 x_access_level_value OUT NOCOPY VARCHAR2
266 ) RETURN NUMBER;
267
268 FUNCTION VALIDATE_ELEMENT_NO
269 (
270 p_ele_no IN VARCHAR2,
271 x_latest_id OUT NOCOPY NUMBER
272 ) RETURN NUMBER;
273
274 FUNCTION VALIDATE_ELEMENT_CONTENT_TYPE
275 (
276 p_ele_content_type IN VARCHAR2,
277 p_ele_content_type_code OUT NOCOPY VARCHAR2
278 ) RETURN NUMBER;
279
280 FUNCTION VALIDATE_PRODUCT_NAME
281 (
282 p_name IN VARCHAR2,
283 x_number OUT NOCOPY NUMBER
284 ) RETURN NUMBER;
285
286 FUNCTION VALIDATE_PRODUCT_SEGMENT
287 (
288 p_segment IN VARCHAR2,
289 x_number OUT NOCOPY NUMBER
290 ) RETURN NUMBER;
291
292 FUNCTION VALIDATE_PLATFORM_NAME
293 (
294 p_name IN VARCHAR2,
295 x_number OUT NOCOPY NUMBER
296 ) RETURN NUMBER;
297
298 FUNCTION VALIDATE_PLATFORM_SEGMENT
299 (
300 p_segment IN VARCHAR2,
301 x_number OUT NOCOPY NUMBER
302 ) RETURN NUMBER;
303
304 FUNCTION VALIDATE_CATEGORY_NAME
305 (
306 p_name IN VARCHAR2,
307 p_last_name IN VARCHAR2,
308 x_number OUT NOCOPY NUMBER
309 ) RETURN NUMBER;
310
311 FUNCTION VALIDATE_SOLN_ATTRIBUTES
312 (
313 p_set_type_id IN NUMBER,
314 p_visibility_name IN VARCHAR2,
315 p_product_names IN JTF_VARCHAR2_TABLE_2000,
316 p_platform_names IN JTF_VARCHAR2_TABLE_2000,
317 p_category_names IN JTF_VARCHAR2_TABLE_2000,
318 p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
319 p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
320 p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
321 p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
322 p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
323 p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
324 p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
325 p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
326 x_visibility_id OUT NOCOPY NUMBER,
327 x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
328 x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
329 x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
330 x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
331 x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
332 x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
333 x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
334 x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
335 x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
336 x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
337 x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
338 x_return_status OUT NOCOPY varchar2,
339 x_msg_count OUT NOCOPY number,
340 x_msg_data OUT NOCOPY varchar2
341 ) RETURN NUMBER;
342
343 FUNCTION Link_Soln_Attributes
344 (
345 p_validate_type IN VARCHAR2,
346 p_set_id IN NUMBER,
347 p_given_element_ids IN JTF_NUMBER_TABLE,
348 p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
349 p_given_ele_type_ids in JTF_NUMBER_TABLE,
350 p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
351 p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
352 p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
353 p_element_ids IN JTF_NUMBER_TABLE,
354 p_element_type_ids IN JTF_NUMBER_TABLE,
355 p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
356 p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
357 p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
358 p_element_dummy_detail IN CLOB,
359 p_set_product_ids IN JTF_NUMBER_TABLE,
360 p_set_platform_ids IN JTF_NUMBER_TABLE,
361 p_set_category_ids IN JTF_NUMBER_TABLE,
362 x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
363 x_return_status OUT NOCOPY varchar2,
364 x_msg_count OUT NOCOPY number,
365 x_msg_data OUT NOCOPY varchar2
366 ) RETURN NUMBER;
367
368
369 FUNCTION Get_Category_Name
370 (
371 p_category_name IN varchar2
372 ) RETURN VARCHAR2;
373
374 FUNCTION Encode_Text(p_text IN VARCHAR2) RETURN VARCHAR2 ;
375
376 PROCEDURE WRITE_CLOB_TO_FILE
377 (
378 p_clob IN CLOB,
379 p_file IN NUMBER
380 );
381
382 PROCEDURE EXPORT_SOLUTIONS
383 (
384 errbuf OUT NOCOPY VARCHAR2,
385 retcode OUT NOCOPY NUMBER,
386 p_category_name IN VARCHAR2,
387 p_sol_status IN VARCHAR2
388 );
389
390 PROCEDURE GET_USER_ACCESS_LEVEL(
391 p_user_name IN VARCHAR2,
392 x_access_level OUT NOCOPY NUMBER);
393
394 FUNCTION GET_USER_NAME (V_USER_ID NUMBER)
395 RETURN VARCHAR2;
396
397 -- (SRCHEFF)
398 PROCEDURE Update_Solution_Usage_Score(
399 p_commit IN VARCHAR2 := FND_API.G_FALSE);
400
401 FUNCTION VALIDATE_SOLN_ATTRIBUTES_2
402 (
403 p_set_type_id IN NUMBER,
404 p_visibility_name IN VARCHAR2,
405 p_product_names IN JTF_VARCHAR2_TABLE_2000,
406 p_platform_names IN JTF_VARCHAR2_TABLE_2000,
407 p_category_names IN JTF_VARCHAR2_TABLE_2000,
408 p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
409 p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
410 p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
411 p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
415 p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
412 p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
413 p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
414 p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
416 x_visibility_id OUT NOCOPY NUMBER,
417 x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
418 x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
419 x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
420 x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
421 x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
422 x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
423 x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
424 x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
425 x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
426 x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
427 x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
428 x_return_status OUT NOCOPY varchar2,
429 x_msg_count OUT NOCOPY number,
430 x_msg_data OUT NOCOPY varchar2,
431 p_delim IN VARCHAR2
432
433 ) RETURN NUMBER;
434
435 FUNCTION VALIDATE_SOLN_ATTRIBUTES_3
436 (
437 p_set_type_id IN NUMBER,
438 p_visibility_name IN VARCHAR2,
439 p_product_names IN JTF_VARCHAR2_TABLE_2000,
440 p_product_segments IN JTF_VARCHAR2_TABLE_2000,
441 p_platform_names IN JTF_VARCHAR2_TABLE_2000,
442 p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
443 p_category_names IN JTF_VARCHAR2_TABLE_2000,
444 p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
445 p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
446 p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
447 p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
448 p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
449 p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
450 p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
451 p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
452 x_visibility_id OUT NOCOPY NUMBER,
453 x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
454 x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
455 x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
456 x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
457 x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
458 x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
459 x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
460 x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
461 x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
462 x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
463 x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
464 x_return_status OUT NOCOPY varchar2,
465 x_msg_count OUT NOCOPY number,
466 x_msg_data OUT NOCOPY varchar2,
467 p_delim IN VARCHAR2
468
469 ) RETURN NUMBER;
470
471 FUNCTION Create_Set_With_Validation_2
472 (
473 p_api_version in number,
474 p_init_msg_list in varchar2 := FND_API.G_FALSE,
475 p_commit in varchar2 := FND_API.G_FALSE,
476 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
477 x_return_status OUT NOCOPY varchar2,
478 x_msg_count OUT NOCOPY number,
479 x_msg_data OUT NOCOPY varchar2,
480 p_set_type_name in varchar2,
481 p_set_visibility in varchar2,
482 p_set_title in varchar2,
483 p_set_flow_name in VARCHAR2,
484 p_set_flow_stepcode in VARCHAR2,
485 p_set_products in JTF_VARCHAR2_TABLE_2000,
486 p_set_platforms in JTF_VARCHAR2_TABLE_2000,
487 p_set_categories in JTF_VARCHAR2_TABLE_2000,
488 p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
489 p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
490 p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
491 p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
492 p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
493 p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
494 p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
495 p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
496 p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
497 p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
498 x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
499 x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
500 x_set_number OUT NOCOPY VARCHAR2,
501 p_delim IN VARCHAR2
502 ) RETURN NUMBER;
503
504 FUNCTION Create_Set_With_Validation_3
505 (
506 p_api_version in number,
507 p_init_msg_list in varchar2 := FND_API.G_FALSE,
508 p_commit in varchar2 := FND_API.G_FALSE,
509 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
510 x_return_status OUT NOCOPY varchar2,
511 x_msg_count OUT NOCOPY number,
512 x_msg_data OUT NOCOPY varchar2,
513 p_set_type_name in varchar2,
514 p_set_visibility in varchar2,
515 p_set_title in varchar2,
516 p_set_flow_name in VARCHAR2,
517 p_set_flow_stepcode in VARCHAR2,
518 p_set_products in JTF_VARCHAR2_TABLE_2000,
519 p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
520 p_set_platforms in JTF_VARCHAR2_TABLE_2000,
521 p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
522 p_set_categories in JTF_VARCHAR2_TABLE_2000,
526 p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
523 p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
524 p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
525 p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
527 p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
528 p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
529 p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
530 p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
531 p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
532 p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
533 x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
534 x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
535 x_set_number OUT NOCOPY VARCHAR2,
536 p_delim IN VARCHAR2
537 ) RETURN NUMBER;
538
539
540 PROCEDURE EXPORT_SOLUTIONS_2
541 (
542 errbuf OUT NOCOPY VARCHAR2,
543 retcode OUT NOCOPY NUMBER,
544 p_category_name IN VARCHAR2,
545 p_sol_status IN VARCHAR2,
546 p_delim IN VARCHAR2
547 );
548
549 FUNCTION Get_Category_Full_Name
550 (
551 p_catid IN NUMBER,
552 p_delim IN VARCHAR2,
553 p_verify IN BOOLEAN DEFAULT FALSE
554 -- full_cat_name OUT VARCHAR2
555 ) RETURN VARCHAR2;
556
557 FUNCTION Get_Category_Name_2
558 (
559 p_category_name IN varchar2,
560 p_delim IN VARCHAR2
561 ) RETURN VARCHAR2;
562
563 FUNCTION Update_Set_With_Validation_2
564 (
565 p_api_version in number,
566 p_init_msg_list in varchar2 := FND_API.G_FALSE,
567 p_commit in varchar2 := FND_API.G_FALSE,
568 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
569 x_return_status OUT NOCOPY varchar2,
570 x_msg_count OUT NOCOPY number,
571 x_msg_data OUT NOCOPY varchar2,
572 p_set_number in varchar2,
573 p_set_type_name in varchar2,
574 p_set_visibility in varchar2,
575 p_set_title in varchar2,
576 p_set_products in JTF_VARCHAR2_TABLE_2000,
577 p_set_platforms in JTF_VARCHAR2_TABLE_2000,
578 p_set_categories in JTF_VARCHAR2_TABLE_2000,
579 p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
580 p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
581 p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
582 p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
583 p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
584 p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
585 p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
586 p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
587 p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
588 p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
589 x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
590 x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
591 x_set_id OUT NOCOPY number,
592 p_delim IN VARCHAR2
593 ) RETURN NUMBER;
594
595 FUNCTION Update_Set_With_Validation_3
596 (
597 p_api_version in number,
598 p_init_msg_list in varchar2 := FND_API.G_FALSE,
599 p_commit in varchar2 := FND_API.G_FALSE,
600 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
601 x_return_status OUT NOCOPY varchar2,
602 x_msg_count OUT NOCOPY number,
603 x_msg_data OUT NOCOPY varchar2,
604 p_set_number in varchar2,
605 p_set_type_name in varchar2,
606 p_set_visibility in varchar2,
607 p_set_title in varchar2,
608 p_set_products in JTF_VARCHAR2_TABLE_2000,
609 p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
610 p_set_platforms in JTF_VARCHAR2_TABLE_2000,
611 p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
612 p_set_categories in JTF_VARCHAR2_TABLE_2000,
613 p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
614 p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
615 p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
616 p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
617 p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
618 p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
619 p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
620 p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
621 p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
622 p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
623 x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
624 x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
625 x_set_id OUT NOCOPY number,
626 p_delim IN VARCHAR2
627 ) RETURN NUMBER;
628
629 FUNCTION VALIDATE_CATEGORY_NAME_2
630 (
631 p_name IN VARCHAR2,
632 p_last_name IN VARCHAR2,
633 x_number OUT NOCOPY NUMBER,
634 p_delim IN VARCHAR2
635 ) RETURN NUMBER;
639 x_return_status OUT NOCOPY varchar2,
636
637 PROCEDURE Clone_Soln_After_Import
638 (
640 x_msg_count OUT NOCOPY number,
641 x_msg_data OUT NOCOPY varchar2,
642 p_set_flow_name IN VARCHAR2,
646
643 p_set_flow_stepcode IN VARCHAR2,
644 p_set_number IN VARCHAR2
645 ) ;
647 END CS_KNOWLEDGE_AUDIT_PVT;