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