1 PACKAGE okc_articles_grp AUTHID CURRENT_USER AS
2 /* $Header: OKCGARTS.pls 120.6 2011/03/23 10:28:56 kkolukul ship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7 TYPE variable_rec_type IS RECORD (
8 variable_code OKC_BUS_VARIABLES_B.variable_code%TYPE
9 );
10
11 TYPE variable_code_tbl_type is table of OKC_ARTICLE_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
12
13 PROCEDURE parse_n_replace_text(
14 p_api_version IN NUMBER,
15 p_init_msg_list IN VARCHAR2 ,
16 p_article_text IN OUT NOCOPY CLOB,
17 p_dest_clob IN OUT NOCOPY CLOB,
18 p_calling_mode IN VARCHAR2 ,
19 p_batch_number IN VARCHAR2 DEFAULT NULL, -- Bug 4659659
20 p_replace_text IN VARCHAR2 := 'N',
21 p_article_intent IN VARCHAR2,
22 p_language IN VARCHAR2,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2,
26 x_variables_tbl OUT NOCOPY variable_code_tbl_type
27 ) ;
28
29 -- This API will be used for autogenerating the article number
30 -- This API can be invoked in Information Only mode to check the
31 -- document sequence type based on the parameter p_seq_type_info_only
32 -- This will be useful from the UI to check if autonumbering is set up
33 -- otherwise open up the region for manual entry of articles.
34
35 PROCEDURE GET_ARTICLE_SEQ_NUMBER
36 (p_article_number IN VARCHAR2 := NULL,
37 p_seq_type_info_only IN VARCHAR2 := 'N',
38 p_org_id IN NUMBER,
39 x_article_number OUT NOCOPY VARCHAR2,
40 x_doc_sequence_type OUT NOCOPY VARCHAR2,
41 x_return_status OUT NOCOPY VARCHAR2
42 ) ;
43
44 PROCEDURE create_article(
45 p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 ,
47 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48 p_commit IN VARCHAR2 := FND_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_article_title IN VARCHAR2,
53 p_article_number IN VARCHAR2,
54 p_standard_yn IN VARCHAR2,
55 p_article_intent IN VARCHAR2,
56 p_article_language IN VARCHAR2,
57 p_article_type IN VARCHAR2,
58 p_orig_system_reference_code IN VARCHAR2,
59 p_orig_system_reference_id1 IN VARCHAR2,
60 p_orig_system_reference_id2 IN VARCHAR2,
61 p_cz_transfer_status_flag IN VARCHAR2,
62 x_article_id OUT NOCOPY NUMBER,
63 x_article_number OUT NOCOPY VARCHAR2,
64 -- Article Version Attributes
65 p_article_text IN CLOB,
66 p_provision_yn IN VARCHAR2,
67 p_insert_by_reference IN VARCHAR2,
68 p_lock_text IN VARCHAR2,
69 p_global_yn IN VARCHAR2,
70 p_article_status IN VARCHAR2,
71 p_sav_release IN VARCHAR2,
72 p_start_date IN DATE,
73 p_end_date IN DATE,
74 p_std_article_version_id IN NUMBER,
75 p_display_name IN VARCHAR2,
76 p_translated_yn IN VARCHAR2,
77 p_article_description IN VARCHAR2,
78 p_date_approved IN DATE,
79 p_default_section IN VARCHAR2,
80 p_reference_source IN VARCHAR2,
81 p_reference_text IN VARCHAR2,
82 p_additional_instructions IN VARCHAR2,
83 p_variation_description IN VARCHAR2,
84 p_date_published IN DATE DEFAULT NULL,
85 p_attribute_category IN VARCHAR2 := NULL,
86 p_attribute1 IN VARCHAR2 := NULL,
87 p_attribute2 IN VARCHAR2 := NULL,
88 p_attribute3 IN VARCHAR2 := NULL,
89 p_attribute4 IN VARCHAR2 := NULL,
90 p_attribute5 IN VARCHAR2 := NULL,
91 p_attribute6 IN VARCHAR2 := NULL,
92 p_attribute7 IN VARCHAR2 := NULL,
93 p_attribute8 IN VARCHAR2 := NULL,
94 p_attribute9 IN VARCHAR2 := NULL,
95 p_attribute10 IN VARCHAR2 := NULL,
96 p_attribute11 IN VARCHAR2 := NULL,
97 p_attribute12 IN VARCHAR2 := NULL,
98 p_attribute13 IN VARCHAR2 := NULL,
99 p_attribute14 IN VARCHAR2 := NULL,
100 p_attribute15 IN VARCHAR2 := NULL,
101 p_v_orig_system_reference_code IN VARCHAR2,
102 p_v_orig_system_reference_id1 IN VARCHAR2,
103 p_v_orig_system_reference_id2 IN VARCHAR2,
104 p_global_article_version_id IN NUMBER := NULL,
105 --Clause Editing
106 p_edited_in_word IN VARCHAR2 DEFAULT 'N',
107 p_article_text_in_word IN BLOB DEFAULT NULL,
108 --CLM
109 p_variable_code IN VARCHAR2 DEFAULT NULL,
110 x_article_version_id OUT NOCOPY NUMBER
111 );
112
113 PROCEDURE lock_article(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 ,
116
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120
121 p_article_id IN NUMBER,
122 p_article_version_id IN NUMBER,
123 p_object_version_number IN NUMBER := NULL
124
125 );
126
127 PROCEDURE update_article(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 ,
130 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
131 p_commit IN VARCHAR2 := FND_API.G_FALSE,
132
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136
137 p_article_id IN NUMBER,
138 p_article_title IN VARCHAR2,
139 p_article_number IN VARCHAR2,
140 p_standard_yn IN VARCHAR2,
141 p_article_intent IN VARCHAR2,
142 p_article_language IN VARCHAR2,
143 p_article_type IN VARCHAR2,
144 p_orig_system_reference_code IN VARCHAR2,
145 p_orig_system_reference_id1 IN VARCHAR2,
146 p_orig_system_reference_id2 IN VARCHAR2,
147 p_cz_transfer_status_flag IN VARCHAR2,
148 p_object_version_number IN NUMBER := NULL,
149 -- Article Version Attributes
150 p_article_version_id IN NUMBER,
151 p_article_text IN CLOB,
152 p_provision_yn IN VARCHAR2,
153 p_insert_by_reference IN VARCHAR2,
154 p_lock_text IN VARCHAR2,
155 p_global_yn IN VARCHAR2,
156 p_article_status IN VARCHAR2,
157 p_sav_release IN VARCHAR2,
158 p_start_date IN DATE,
159 p_end_date IN DATE,
160 p_std_article_version_id IN NUMBER,
161 p_display_name IN VARCHAR2,
162 p_translated_yn IN VARCHAR2,
163 p_article_description IN VARCHAR2,
164 p_date_approved IN DATE,
165 p_default_section IN VARCHAR2,
166 p_reference_source IN VARCHAR2,
167 p_reference_text IN VARCHAR2,
168 p_additional_instructions IN VARCHAR2,
169 p_variation_description IN VARCHAR2,
170 p_date_published IN DATE DEFAULT NULL,
171 p_v_orig_system_reference_code IN VARCHAR2,
172 p_v_orig_system_reference_id1 IN VARCHAR2,
173 p_v_orig_system_reference_id2 IN VARCHAR2,
174 p_attribute_category IN VARCHAR2 := NULL,
175 p_attribute1 IN VARCHAR2 := NULL,
176 p_attribute2 IN VARCHAR2 := NULL,
177 p_attribute3 IN VARCHAR2 := NULL,
178 p_attribute4 IN VARCHAR2 := NULL,
179 p_attribute5 IN VARCHAR2 := NULL,
180 p_attribute6 IN VARCHAR2 := NULL,
181 p_attribute7 IN VARCHAR2 := NULL,
182 p_attribute8 IN VARCHAR2 := NULL,
183 p_attribute9 IN VARCHAR2 := NULL,
184 p_attribute10 IN VARCHAR2 := NULL,
185 p_attribute11 IN VARCHAR2 := NULL,
186 p_attribute12 IN VARCHAR2 := NULL,
187 p_attribute13 IN VARCHAR2 := NULL,
188 p_attribute14 IN VARCHAR2 := NULL,
189 p_attribute15 IN VARCHAR2 := NULL,
190
191 p_v_object_version_number IN NUMBER := NULL,
192 --Clause Editing
193 p_edited_in_word IN VARCHAR2 DEFAULT 'N',
194 p_article_text_in_word IN BLOB DEFAULT NULL,
195 --CLM
196 p_variable_code IN VARCHAR2 DEFAULT NULL
197 );
198
199 PROCEDURE delete_article(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 ,
202 p_commit IN VARCHAR2 := FND_API.G_FALSE,
203
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207
208 p_article_id IN NUMBER,
209 p_article_version_id IN NUMBER,
210 p_object_version_number IN NUMBER := NULL
211 );
212
213 PROCEDURE validate_article(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 ,
216 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
217 p_import_action IN VARCHAR2 := NULL,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 x_earlier_adoption_type OUT NOCOPY VARCHAR2,
222 x_earlier_version_id OUT NOCOPY NUMBER,
223 x_earlier_version_number OUT NOCOPY NUMBER,
224 p_article_id IN NUMBER,
225 p_article_title IN VARCHAR2,
226 p_org_id IN NUMBER,
227 p_article_number IN VARCHAR2,
228 p_standard_yn IN VARCHAR2,
229 p_article_intent IN VARCHAR2,
230 p_article_language IN VARCHAR2,
231 p_article_type IN VARCHAR2,
232 p_orig_system_reference_code IN VARCHAR2,
233 p_orig_system_reference_id1 IN VARCHAR2,
234 p_orig_system_reference_id2 IN VARCHAR2,
235 -- Article Version Attributes
236 p_article_version_id IN NUMBER,
237 p_article_version_number IN NUMBER,
238 p_article_text IN CLOB,
239 p_provision_yn IN VARCHAR2,
240 p_insert_by_reference IN VARCHAR2,
241 p_lock_text IN VARCHAR2,
242 p_global_yn IN VARCHAR2,
243 p_article_status IN VARCHAR2,
244 p_sav_release IN VARCHAR2,
245 p_start_date IN DATE,
246 p_end_date IN DATE,
247 p_std_article_version_id IN NUMBER,
248 p_display_name IN VARCHAR2,
249 p_translated_yn IN VARCHAR2,
250 p_article_description IN VARCHAR2,
251 p_date_approved IN DATE,
252 p_default_section IN VARCHAR2,
253 p_reference_source IN VARCHAR2,
254 p_reference_text IN VARCHAR2,
255 p_additional_instructions IN VARCHAR2,
256 p_variation_description IN VARCHAR2,
257 p_date_published IN DATE DEFAULT NULL,
258 p_attribute_category IN VARCHAR2 := NULL,
259 p_attribute1 IN VARCHAR2 := NULL,
260 p_attribute2 IN VARCHAR2 := NULL,
261 p_attribute3 IN VARCHAR2 := NULL,
262 p_attribute4 IN VARCHAR2 := NULL,
263 p_attribute5 IN VARCHAR2 := NULL,
264 p_attribute6 IN VARCHAR2 := NULL,
265 p_attribute7 IN VARCHAR2 := NULL,
266 p_attribute8 IN VARCHAR2 := NULL,
267 p_attribute9 IN VARCHAR2 := NULL,
268 p_attribute10 IN VARCHAR2 := NULL,
269 p_attribute11 IN VARCHAR2 := NULL,
270 p_attribute12 IN VARCHAR2 := NULL,
271 p_attribute13 IN VARCHAR2 := NULL,
272 p_attribute14 IN VARCHAR2 := NULL,
273 p_attribute15 IN VARCHAR2 := NULL,
274 --Clause Editing
275 p_edited_in_word IN VARCHAR2 DEFAULT 'N',
276 p_article_text_in_word IN BLOB DEFAULT NULL,
277 --CLM
278 p_variable_code IN VARCHAR2 DEFAULT NULL
279 );
280
281
282 PROCEDURE create_article_version(
283 p_api_version IN NUMBER,
284 p_init_msg_list IN VARCHAR2 ,
285 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286 p_commit IN VARCHAR2 := FND_API.G_FALSE,
287 p_article_intent IN VARCHAR2 := NULL,
288 p_standard_yn IN VARCHAR2 := 'Y',
289 p_global_article_version_id IN NUMBER := NULL,
290
291 x_return_status OUT NOCOPY VARCHAR2,
292 x_msg_count OUT NOCOPY NUMBER,
293 x_msg_data OUT NOCOPY VARCHAR2,
294
295 p_article_id IN NUMBER,
296 p_article_text IN CLOB,
297 p_provision_yn IN VARCHAR2,
298 p_insert_by_reference IN VARCHAR2,
299 p_lock_text IN VARCHAR2,
300 p_global_yn IN VARCHAR2,
301 p_article_language IN VARCHAR2,
302 p_article_status IN VARCHAR2,
303 p_sav_release IN VARCHAR2,
304 p_start_date IN DATE,
305 p_end_date IN DATE,
306 p_std_article_version_id IN NUMBER,
307 p_display_name IN VARCHAR2,
308 p_translated_yn IN VARCHAR2,
309 p_article_description IN VARCHAR2,
310 p_date_approved IN DATE,
311 p_default_section IN VARCHAR2 := NULL,
312 p_reference_source IN VARCHAR2 := NULL,
316 p_orig_system_reference_id2 IN VARCHAR2 := NULL,
313 p_reference_text IN VARCHAR2 := NULL,
314 p_orig_system_reference_code IN VARCHAR2 := NULL,
315 p_orig_system_reference_id1 IN VARCHAR2 := NULL,
317 p_additional_instructions IN VARCHAR2 := NULL,
318 p_variation_description IN VARCHAR2 := NULL,
319 p_date_published IN DATE DEFAULT NULL,
320
321 p_attribute_category IN VARCHAR2 := NULL,
322 p_attribute1 IN VARCHAR2 := NULL,
323 p_attribute2 IN VARCHAR2 := NULL,
324 p_attribute3 IN VARCHAR2 := NULL,
325 p_attribute4 IN VARCHAR2 := NULL,
326 p_attribute5 IN VARCHAR2 := NULL,
327 p_attribute6 IN VARCHAR2 := NULL,
328 p_attribute7 IN VARCHAR2 := NULL,
329 p_attribute8 IN VARCHAR2 := NULL,
330 p_attribute9 IN VARCHAR2 := NULL,
331 p_attribute10 IN VARCHAR2 := NULL,
332 p_attribute11 IN VARCHAR2 := NULL,
333 p_attribute12 IN VARCHAR2 := NULL,
334 p_attribute13 IN VARCHAR2 := NULL,
335 p_attribute14 IN VARCHAR2 := NULL,
336 p_attribute15 IN VARCHAR2 := NULL,
337 --Clause Editing
338 p_edited_in_word IN VARCHAR2 DEFAULT 'N',
339 p_article_text_in_word IN BLOB DEFAULT NULL,
340 --clm
341 p_variable_code IN VARCHAR2 DEFAULT NULL,
342 x_article_version_id OUT NOCOPY NUMBER
343
344 );
345
346 PROCEDURE lock_article_version(
347 p_api_version IN NUMBER,
348 p_init_msg_list IN VARCHAR2 ,
349
350 x_return_status OUT NOCOPY VARCHAR2,
351 x_msg_count OUT NOCOPY NUMBER,
352 x_msg_data OUT NOCOPY VARCHAR2,
353
354 p_article_version_id IN NUMBER,
355
356 p_object_version_number IN NUMBER := NULL
357
358 );
359
360 PROCEDURE update_article_version(
361 p_api_version IN NUMBER,
362 p_init_msg_list IN VARCHAR2 ,
363 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
364 p_commit IN VARCHAR2 := FND_API.G_FALSE,
365 x_return_status OUT NOCOPY VARCHAR2,
366 x_msg_count OUT NOCOPY NUMBER,
367 x_msg_data OUT NOCOPY VARCHAR2,
368 p_article_intent IN VARCHAR2,
369 p_article_version_id IN NUMBER,
370 p_article_id IN NUMBER,
371 p_article_text IN CLOB,
372 p_provision_yn IN VARCHAR2,
373 p_insert_by_reference IN VARCHAR2,
374 p_lock_text IN VARCHAR2,
375 p_global_yn IN VARCHAR2,
376 p_article_language IN VARCHAR2,
377 p_article_status IN VARCHAR2,
378 p_sav_release IN VARCHAR2,
379 p_start_date IN DATE,
380 p_end_date IN DATE,
381 p_std_article_version_id IN NUMBER,
382 p_display_name IN VARCHAR2,
383 p_translated_yn IN VARCHAR2,
384 p_article_description IN VARCHAR2,
385 p_date_approved IN DATE,
386 p_default_section IN VARCHAR2,
387 p_reference_source IN VARCHAR2,
388 p_reference_text IN VARCHAR2,
389 p_orig_system_reference_code IN VARCHAR2 := NULL,
390 p_orig_system_reference_id1 IN VARCHAR2 := NULL,
391 p_orig_system_reference_id2 IN VARCHAR2 := NULL,
392 p_additional_instructions IN VARCHAR2 := NULL,
393 p_variation_description IN VARCHAR2,
394 p_date_published IN DATE DEFAULT NULL,
395 p_attribute_category IN VARCHAR2 := NULL,
396 p_attribute1 IN VARCHAR2 := NULL,
397 p_attribute2 IN VARCHAR2 := NULL,
398 p_attribute3 IN VARCHAR2 := NULL,
399 p_attribute4 IN VARCHAR2 := NULL,
400 p_attribute5 IN VARCHAR2 := NULL,
401 p_attribute6 IN VARCHAR2 := NULL,
402 p_attribute7 IN VARCHAR2 := NULL,
403 p_attribute8 IN VARCHAR2 := NULL,
404 p_attribute9 IN VARCHAR2 := NULL,
405 p_attribute10 IN VARCHAR2 := NULL,
406 p_attribute11 IN VARCHAR2 := NULL,
407 p_attribute12 IN VARCHAR2 := NULL,
408 p_attribute13 IN VARCHAR2 := NULL,
409 p_attribute14 IN VARCHAR2 := NULL,
410 p_attribute15 IN VARCHAR2 := NULL,
411 p_object_version_number IN NUMBER := NULL,
412 --Clause Editing
413 p_edited_in_word IN VARCHAR2 DEFAULT 'N',
414 p_article_text_in_word IN BLOB DEFAULT NULL,
415 --clm
416 p_variable_code IN VARCHAR2 DEFAULT NULL
417 );
418
419 PROCEDURE validate_article_version(
420 p_api_version IN NUMBER,
421 p_init_msg_list IN VARCHAR2 ,
422 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423 p_import_action IN VARCHAR2 := NULL,
424 x_return_status OUT NOCOPY VARCHAR2,
425 x_msg_count OUT NOCOPY NUMBER,
429 x_earlier_adoption_type OUT NOCOPY VARCHAR2,
426 x_msg_data OUT NOCOPY VARCHAR2,
427 x_earlier_version_id OUT NOCOPY NUMBER,
428 x_earlier_version_number OUT NOCOPY NUMBER,
430 p_article_version_id IN NUMBER,
431 p_article_id IN NUMBER,
432 p_article_version_number IN NUMBER,
433 p_article_text IN CLOB,
434 p_provision_yn IN VARCHAR2,
435 p_insert_by_reference IN VARCHAR2,
436 p_lock_text IN VARCHAR2,
437 p_global_yn IN VARCHAR2,
438 p_article_language IN VARCHAR2,
439 p_article_status IN VARCHAR2,
440 p_sav_release IN VARCHAR2,
441 p_start_date IN DATE,
442 p_end_date IN DATE,
443 p_std_article_version_id IN NUMBER,
444 p_display_name IN VARCHAR2,
445 p_translated_yn IN VARCHAR2,
446 p_article_description IN VARCHAR2,
447 p_date_approved IN DATE,
448 p_default_section IN VARCHAR2,
449 p_reference_source IN VARCHAR2,
450 p_reference_text IN VARCHAR2,
451 p_orig_system_reference_code IN VARCHAR2,
452 p_orig_system_reference_id1 IN VARCHAR2,
453 p_orig_system_reference_id2 IN VARCHAR2,
454 p_additional_instructions IN VARCHAR2,
455 p_variation_description IN VARCHAR2,
456 p_date_published IN DATE DEFAULT NULL,
457 p_attribute_category IN VARCHAR2 := NULL,
458 p_attribute1 IN VARCHAR2 := NULL,
459 p_attribute2 IN VARCHAR2 := NULL,
460 p_attribute3 IN VARCHAR2 := NULL,
461 p_attribute4 IN VARCHAR2 := NULL,
462 p_attribute5 IN VARCHAR2 := NULL,
463 p_attribute6 IN VARCHAR2 := NULL,
464 p_attribute7 IN VARCHAR2 := NULL,
465 p_attribute8 IN VARCHAR2 := NULL,
466 p_attribute9 IN VARCHAR2 := NULL,
467 p_attribute10 IN VARCHAR2 := NULL,
468 p_attribute11 IN VARCHAR2 := NULL,
469 p_attribute12 IN VARCHAR2 := NULL,
470 p_attribute13 IN VARCHAR2 := NULL,
471 p_attribute14 IN VARCHAR2 := NULL,
472 p_attribute15 IN VARCHAR2 := NULL,
473 --Clause Editing
474 p_edited_in_word IN VARCHAR2 DEFAULT 'N',
475 p_article_text_in_word IN BLOB DEFAULT NULL,
476 --clm
477 p_variable_code IN VARCHAR2 DEFAULT NULL
478 );
479
480 PROCEDURE copy_article(
481 p_api_version IN NUMBER,
482 p_init_msg_list IN VARCHAR2 ,
483 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
484 p_commit IN VARCHAR2 := FND_API.G_FALSE,
485
486 p_article_version_id IN NUMBER,
487 p_new_article_title IN VARCHAR2 := NULL,
488 p_new_article_number IN VARCHAR2 := NULL,
489 p_create_standard_yn IN VARCHAR2 := 'N',
490 p_copy_relationship_yn IN VARCHAR2 := 'N',
491 p_copy_folder_assoc_yn IN VARCHAR2 := 'N',
492
493 x_article_version_id OUT NOCOPY NUMBER,
494 x_article_id OUT NOCOPY NUMBER,
495 x_article_number OUT NOCOPY VARCHAR2,
496 x_return_status OUT NOCOPY VARCHAR2,
497 x_msg_count OUT NOCOPY NUMBER,
498 x_msg_data OUT NOCOPY VARCHAR2
499
500 );
501
502 PROCEDURE create_article_relationship(
503 p_api_version IN NUMBER,
504 p_init_msg_list IN VARCHAR2 ,
505 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506 p_commit IN VARCHAR2 := FND_API.G_FALSE,
507 x_return_status OUT NOCOPY VARCHAR2,
508 x_msg_count OUT NOCOPY NUMBER,
509 x_msg_data OUT NOCOPY VARCHAR2,
510 p_source_article_id IN NUMBER,
511 p_target_article_id IN NUMBER,
512 p_org_id IN NUMBER,
513 p_relationship_type IN VARCHAR2
514 ) ;
515
516 PROCEDURE delete_article_relationship(
517 p_api_version IN NUMBER,
518 p_init_msg_list IN VARCHAR2 ,
519 p_commit IN VARCHAR2 := FND_API.G_FALSE,
520
521 x_return_status OUT NOCOPY VARCHAR2,
522 x_msg_count OUT NOCOPY NUMBER,
523 x_msg_data OUT NOCOPY VARCHAR2,
524
525 p_source_article_id IN NUMBER,
526 p_target_article_id IN NUMBER,
527 p_org_id IN NUMBER,
528 p_object_version_number IN NUMBER := NULL
529 );
530
531 PROCEDURE update_article_variables (
532 p_article_version_id IN NUMBER,
533 p_variable_code_tbl IN variable_code_tbl_type,
534 p_do_dml IN VARCHAR2 := 'Y', -- parameter used for import.
535 x_variables_to_insert_tbl OUT NOCOPY variable_code_tbl_type,
536 x_variables_to_delete_tbl OUT NOCOPY variable_code_tbl_type,
537 x_return_status OUT NOCOPY VARCHAR2) ;
538
539 -- Bug#3722445: The following API will be used by the Update Article UI to check if future approved versions exist
543 (
540 -- in which case, the UI will prevent further update to end date.
541
542 PROCEDURE later_approved_exists
544 p_api_version IN NUMBER,
545 p_init_msg_list IN VARCHAR2 ,
546 p_article_id IN NUMBER,
547 p_start_date IN DATE,
548 x_return_status OUT NOCOPY VARCHAR2,
549 x_msg_count OUT NOCOPY NUMBER,
550 x_msg_data OUT NOCOPY VARCHAR2,
551 x_yes_no OUT NOCOPY VARCHAR2);
552
553 END OKC_ARTICLES_GRP;