eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKC_STD_ARTICLE_PUB

Source


1 package okc_std_article_pub as
2 /* $Header: OKCPSAES.pls 120.0 2005/05/25 18:39:38 appldev noship $ */
3  subtype saev_rec_type is okc_std_article_pvt.saev_rec_type;
4  subtype saev_tbl_type is okc_std_article_pvt.saev_tbl_type;
5 
6  subtype savv_rec_type is okc_std_article_pvt.savv_rec_type;
7  subtype savv_tbl_type is okc_std_article_pvt.savv_tbl_type;
8 
9  subtype saiv_rec_type is okc_std_article_pvt.saiv_rec_type;
10  subtype saiv_tbl_type is okc_std_article_pvt.saiv_tbl_type;
11 
12  subtype samv_rec_type is okc_std_article_pvt.samv_rec_type;
13  subtype samv_tbl_type is okc_std_article_pvt.samv_tbl_type;
14 
15  subtype sacv_rec_type is okc_std_article_pvt.sacv_rec_type;
16  subtype sacv_tbl_type is okc_std_article_pvt.sacv_tbl_type;
17 
18 
19   -- GLOBAL VARIABLES
20   ---------------------------------------------------------------------------
21   G_UNEXPECTED_ERROR           CONSTANT   varchar2(200) := 'OKC_UNEXPECTED_ERROR';
22   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKC_STD_ARTICLE_PUB';
23   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
24   G_SQLERRM_TOKEN              CONSTANT   varchar2(200) := 'ERROR_MESSAGE';
25   G_SQLCODE_TOKEN              CONSTANT   varchar2(200) := 'ERROR_CODE';
26   G_EXCEPTION_HALT_PROCESSING           EXCEPTION;
27 
28 --Records for User Hooks
29      g_saev_rec                     saev_rec_type;
30      g_saiv_rec                     saiv_rec_type;
31      g_sacv_rec                     sacv_rec_type;
32      g_savv_rec                     savv_rec_type;
33      g_samv_rec                     samv_rec_type;
34 
35 
36   ---------------------------------------------------------------------------
37 
38 --Procedures pertaining to Setting up of a standard Article
39 
40  PROCEDURE add_language;
41 
42  PROCEDURE Create_std_article(
43 	p_api_version 		IN NUMBER,
44 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
45 	x_return_status		OUT NOCOPY VARCHAR2,
46 	x_msg_count		OUT NOCOPY NUMBER,
47 	x_msg_data		OUT NOCOPY VARCHAR2,
48 	p_saev_rec		IN saev_rec_type,
49 	p_savv_tbl		IN savv_tbl_type,
50 	p_saiv_tbl		IN saiv_tbl_type,
51 	p_samv_tbl		IN samv_tbl_type,
52 	x_saev_rec		OUT NOCOPY saev_rec_type,
53 	x_savv_tbl		OUT NOCOPY savv_tbl_type,
54 	x_saiv_tbl		OUT NOCOPY saiv_tbl_type,
55 	x_samv_tbl		OUT NOCOPY samv_tbl_type);
56 
57 
58 
59  PROCEDURE Update_std_article(
60 	p_api_version 		IN NUMBER,
61 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62 	x_return_status		OUT NOCOPY VARCHAR2,
63 	x_msg_count		OUT NOCOPY NUMBER,
64 	x_msg_data		OUT NOCOPY VARCHAR2,
65 	p_saev_rec		IN saev_rec_type,
66 	p_savv_tbl		IN savv_tbl_type,
67 	p_saiv_tbl		IN saiv_tbl_type,
68 	p_samv_tbl		IN samv_tbl_type,
69 	x_saev_rec		OUT NOCOPY saev_rec_type,
70 	x_savv_tbl		OUT NOCOPY savv_tbl_type,
71 	x_saiv_tbl		OUT NOCOPY saiv_tbl_type,
72 	x_samv_tbl		OUT NOCOPY samv_tbl_type);
73 
74 
75 
76  PROCEDURE Validate_std_article(
77 	p_api_version 		IN NUMBER,
78 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79 	x_return_status		OUT NOCOPY VARCHAR2,
80 	x_msg_count		OUT NOCOPY NUMBER,
81 	x_msg_data		OUT NOCOPY VARCHAR2,
82 	p_saev_rec		IN saev_rec_type,
83 	p_savv_tbl		IN savv_tbl_type,
84 	p_saiv_tbl		IN saiv_tbl_type,
85 	p_samv_tbl		IN samv_tbl_type);
86 
87 
88  PROCEDURE create_std_article(
89 	p_api_version 		IN NUMBER,
90 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91 	x_return_status		OUT NOCOPY VARCHAR2,
92 	x_msg_count		OUT NOCOPY NUMBER,
93 	x_msg_data		OUT NOCOPY VARCHAR2,
94 	p_saev_tbl		IN saev_tbl_type,
95 	x_saev_tbl		OUT NOCOPY saev_tbl_type);
96 
97 
98 PROCEDURE create_std_article(
99 	p_api_version 		IN NUMBER,
100 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101 	x_return_status		OUT NOCOPY VARCHAR2,
102 	x_msg_count		OUT NOCOPY NUMBER,
103 	x_msg_data		OUT NOCOPY VARCHAR2,
104 	p_saev_rec		IN saev_rec_type,
105 	x_saev_rec		OUT NOCOPY saev_rec_type);
106 
107 PROCEDURE lock_std_article(
108 	p_api_version 		IN NUMBER,
109 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110 	x_return_status		OUT NOCOPY VARCHAR2,
111 	x_msg_count		OUT NOCOPY NUMBER,
112 	x_msg_data		OUT NOCOPY VARCHAR2,
113 	p_saev_tbl		IN saev_tbl_type);
114 
115 
116 PROCEDURE lock_std_article(
117 	p_api_version 		IN NUMBER,
118 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 	x_return_status		OUT NOCOPY VARCHAR2,
120 	x_msg_count		OUT NOCOPY NUMBER,
121 	x_msg_data		OUT NOCOPY VARCHAR2,
122 	p_saev_rec		IN saev_rec_type);
123 
124 PROCEDURE update_std_article(
125 	p_api_version 		IN NUMBER,
126 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127 	x_return_status		OUT NOCOPY VARCHAR2,
128 	x_msg_count		OUT NOCOPY NUMBER,
129 	x_msg_data		OUT NOCOPY VARCHAR2,
130 	p_saev_tbl		IN saev_tbl_type,
131 	x_saev_tbl		OUT NOCOPY saev_tbl_type);
132 
133 
134 PROCEDURE update_std_article(
135 	p_api_version 		IN NUMBER,
136 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 	x_return_status		OUT NOCOPY VARCHAR2,
138 	x_msg_count		OUT NOCOPY NUMBER,
139 	x_msg_data		OUT NOCOPY VARCHAR2,
140 	p_saev_rec		IN saev_rec_type,
141 	x_saev_rec		OUT NOCOPY saev_rec_type);
142 
143 PROCEDURE delete_std_article(
144 	p_api_version 		IN NUMBER,
145 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146 	x_return_status		OUT NOCOPY VARCHAR2,
147 	x_msg_count		OUT NOCOPY NUMBER,
148 	x_msg_data		OUT NOCOPY VARCHAR2,
149 	p_saev_tbl		IN saev_tbl_type);
150 
151 
152 PROCEDURE delete_std_article(
153 	p_api_version 		IN NUMBER,
154 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155 	x_return_status		OUT NOCOPY VARCHAR2,
156 	x_msg_count		OUT NOCOPY NUMBER,
157 	x_msg_data		OUT NOCOPY VARCHAR2,
158 	p_saev_rec		IN saev_rec_type);
159 
160 PROCEDURE validate_std_article(
161 	p_api_version 		IN NUMBER,
162 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163 	x_return_status		OUT NOCOPY VARCHAR2,
164 	x_msg_count		OUT NOCOPY NUMBER,
165 	x_msg_data		OUT NOCOPY VARCHAR2,
166 	p_saev_tbl		IN saev_tbl_type);
167 
168 
169 PROCEDURE validate_std_article(
170 	p_api_version 		IN NUMBER,
171 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172 	x_return_status		OUT NOCOPY VARCHAR2,
173 	x_msg_count		OUT NOCOPY NUMBER,
174 	x_msg_data		OUT NOCOPY VARCHAR2,
175 	p_saev_rec		IN saev_rec_type);
176 
177 
178 PROCEDURE validate_name(
179 	p_api_version 		IN NUMBER,
180 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181 	x_return_status		OUT NOCOPY VARCHAR2,
182 	x_msg_count		OUT NOCOPY NUMBER,
183 	x_msg_data		OUT NOCOPY VARCHAR2,
184 	p_saev_rec		IN saev_rec_type);
185 
186 PROCEDURE validate_name(
187 	p_api_version 		IN NUMBER,
188 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189 	x_return_status		OUT NOCOPY VARCHAR2,
190 	x_msg_count		OUT NOCOPY NUMBER,
191 	x_msg_data		OUT NOCOPY VARCHAR2,
192 	p_saev_tbl		IN saev_tbl_type);
193 
194 PROCEDURE validate_no_k_attached(
195         p_saev_rec                     IN saev_rec_type,
196         x_return_status                OUT NOCOPY VARCHAR2);
197 
198 PROCEDURE validate_no_k_attached(
199         p_saev_tbl			   IN saev_tbl_type,
200         x_return_status                OUT NOCOPY VARCHAR2);
201 
202 
203 PROCEDURE create_std_art_version(
204 	p_api_version 		IN NUMBER,
205 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206 	x_return_status		OUT NOCOPY VARCHAR2,
207 	x_msg_count		OUT NOCOPY NUMBER,
208 	x_msg_data		OUT NOCOPY VARCHAR2,
209 	p_savv_tbl		IN savv_tbl_type,
210 	x_savv_tbl		OUT NOCOPY savv_tbl_type);
211 
212 
213 PROCEDURE create_std_art_version(
214 	p_api_version 		IN NUMBER,
215 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216 	x_return_status		OUT NOCOPY VARCHAR2,
217 	x_msg_count		OUT NOCOPY NUMBER,
218 	x_msg_data		OUT NOCOPY VARCHAR2,
219 	p_savv_rec		IN savv_rec_type,
220 	x_savv_rec		OUT NOCOPY savv_rec_type);
221 
222 PROCEDURE lock_std_art_version(
223 	p_api_version 		IN NUMBER,
224 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225 	x_return_status		OUT NOCOPY VARCHAR2,
226 	x_msg_count		OUT NOCOPY NUMBER,
227 	x_msg_data		OUT NOCOPY VARCHAR2,
228 	p_savv_tbl		IN savv_tbl_type);
229 
230 
231 PROCEDURE  lock_std_art_version(
232 	p_api_version 		IN NUMBER,
233 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234 	x_return_status		OUT NOCOPY VARCHAR2,
235 	x_msg_count		OUT NOCOPY NUMBER,
236 	x_msg_data		OUT NOCOPY VARCHAR2,
237 	p_savv_rec		IN savv_rec_type);
238 
239 PROCEDURE update_std_art_version(
240 	p_api_version 		IN NUMBER,
241 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242 	x_return_status		OUT NOCOPY VARCHAR2,
243 	x_msg_count		OUT NOCOPY NUMBER,
244 	x_msg_data		OUT NOCOPY VARCHAR2,
245 	p_savv_tbl		IN savv_tbl_type,
246 	x_savv_tbl		OUT NOCOPY savv_tbl_type);
247 
248 
249 PROCEDURE update_std_art_version(
250 	p_api_version 		IN NUMBER,
251 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
252 	x_return_status		OUT NOCOPY VARCHAR2,
253 	x_msg_count		OUT NOCOPY NUMBER,
254 	x_msg_data		OUT NOCOPY VARCHAR2,
255 	p_savv_rec		IN savv_rec_type,
256 	x_savv_rec		OUT NOCOPY savv_rec_type);
257 
258 PROCEDURE delete_std_art_version(
259 	p_api_version 		IN NUMBER,
260 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
261 	x_return_status		OUT NOCOPY VARCHAR2,
262 	x_msg_count		OUT NOCOPY NUMBER,
263 	x_msg_data		OUT NOCOPY VARCHAR2,
264 	p_savv_tbl		IN savv_tbl_type);
265 
266 
267 PROCEDURE delete_std_art_version(
268 	p_api_version 		IN NUMBER,
269 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
270 	x_return_status		OUT NOCOPY VARCHAR2,
271 	x_msg_count		OUT NOCOPY NUMBER,
272 	x_msg_data		OUT NOCOPY VARCHAR2,
273 	p_savv_rec		IN savv_rec_type);
274 
275 PROCEDURE validate_std_art_version(
276 	p_api_version 		IN NUMBER,
277 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
278 	x_return_status		OUT NOCOPY VARCHAR2,
279 	x_msg_count		OUT NOCOPY NUMBER,
280 	x_msg_data		OUT NOCOPY VARCHAR2,
281 	p_savv_tbl		IN savv_tbl_type);
282 
283 
284 PROCEDURE validate_std_art_version(
285 	p_api_version 		IN NUMBER,
286 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
287 	x_return_status		OUT NOCOPY VARCHAR2,
288 	x_msg_count		OUT NOCOPY NUMBER,
289 	x_msg_data		OUT NOCOPY VARCHAR2,
290 	p_savv_rec		IN savv_rec_type);
291 
292 
293 PROCEDURE validate_sav_release(
294 	p_api_version 		IN NUMBER,
295 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
296 	x_return_status		OUT NOCOPY VARCHAR2,
297 	x_msg_count		OUT NOCOPY NUMBER,
298 	x_msg_data		OUT NOCOPY VARCHAR2,
299 	p_savv_rec		IN savv_rec_type);
300 
301 PROCEDURE validate_sav_release(
302 	p_api_version 		IN NUMBER,
303 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
304 	x_return_status		OUT NOCOPY VARCHAR2,
305 	x_msg_count		OUT NOCOPY NUMBER,
306 	x_msg_data		OUT NOCOPY VARCHAR2,
307 	p_savv_tbl		IN savv_tbl_type);
308 PROCEDURE validate_date_active(
309 	p_api_version 		IN NUMBER,
310 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
311 	x_return_status		OUT NOCOPY VARCHAR2,
312 	x_msg_count		OUT NOCOPY NUMBER,
313 	x_msg_data		OUT NOCOPY VARCHAR2,
314 	p_savv_rec		IN savv_rec_type);
315 
316 PROCEDURE validate_date_active(
317 	p_api_version 		IN NUMBER,
318 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
319 	x_return_status		OUT NOCOPY VARCHAR2,
320 	x_msg_count		OUT NOCOPY NUMBER,
321 	x_msg_data		OUT NOCOPY VARCHAR2,
322 	p_savv_tbl		IN savv_tbl_type);
323 
324 PROCEDURE validate_updatable(
325 	p_api_version 		IN NUMBER,
326 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
327 	x_return_status		OUT NOCOPY VARCHAR2,
328 	x_msg_count		OUT NOCOPY NUMBER,
329 	x_msg_data		OUT NOCOPY VARCHAR2,
330 	p_savv_rec		IN savv_rec_type);
331 
332 PROCEDURE validate_updatable(
333 	p_api_version 		IN NUMBER,
334 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
335 	x_return_status		OUT NOCOPY VARCHAR2,
336 	x_msg_count		OUT NOCOPY NUMBER,
337 	x_msg_data		OUT NOCOPY VARCHAR2,
338 	p_savv_tbl		IN savv_tbl_type);
339 
340 PROCEDURE validate_no_k_attached(
341         p_savv_rec                     IN savv_rec_type,
342         x_return_status                OUT NOCOPY VARCHAR2);
343 
344 PROCEDURE validate_no_k_attached(
345         p_savv_tbl			   IN savv_tbl_type,
346         x_return_status                OUT NOCOPY VARCHAR2);
347 
348 PROCEDURE validate_latest(
349         p_savv_rec                     IN savv_rec_type,
350         x_return_status                OUT NOCOPY VARCHAR2);
351 
352 PROCEDURE validate_latest(
353         p_savv_tbl			   IN savv_tbl_type,
354         x_return_status                OUT NOCOPY VARCHAR2);
355 
356 /*
357 PROCEDURE validate_short_description(
358 	p_api_version 		IN NUMBER,
359 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
360 	x_return_status		OUT NOCOPY VARCHAR2,
361 	x_msg_count		OUT NOCOPY NUMBER,
362 	x_msg_data		OUT NOCOPY VARCHAR2,
363 	p_savv_rec		IN savv_rec_type);
364 
365 PROCEDURE validate_short_description(
366 	p_api_version 		IN NUMBER,
367 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
368 	x_return_status		OUT NOCOPY VARCHAR2,
369 	x_msg_count		OUT NOCOPY NUMBER,
370 	x_msg_data		OUT NOCOPY VARCHAR2,
371 	p_savv_tbl		IN savv_tbl_type);
372 */
373 
374 PROCEDURE create_std_art_incmpt(
375 	p_api_version 		IN NUMBER,
376 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
377 	x_return_status		OUT NOCOPY VARCHAR2,
378 	x_msg_count		OUT NOCOPY NUMBER,
379 	x_msg_data		OUT NOCOPY VARCHAR2,
380 	p_saiv_tbl		IN saiv_tbl_type,
381 	x_saiv_tbl		OUT NOCOPY saiv_tbl_type);
382 
383 
384 PROCEDURE create_std_art_incmpt(
385 	p_api_version 		IN NUMBER,
386 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
387 	x_return_status		OUT NOCOPY VARCHAR2,
388 	x_msg_count		OUT NOCOPY NUMBER,
389 	x_msg_data		OUT NOCOPY VARCHAR2,
390 	p_saiv_rec		IN saiv_rec_type,
391 	x_saiv_rec		OUT NOCOPY saiv_rec_type);
392 
393 PROCEDURE lock_std_art_incmpt(
394 	p_api_version 		IN NUMBER,
395 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
396 	x_return_status		OUT NOCOPY VARCHAR2,
397 	x_msg_count		OUT NOCOPY NUMBER,
398 	x_msg_data		OUT NOCOPY VARCHAR2,
399 	p_saiv_tbl		IN saiv_tbl_type);
400 
401 
402 PROCEDURE lock_std_art_incmpt(
403 	p_api_version 		IN NUMBER,
404 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
405 	x_return_status		OUT NOCOPY VARCHAR2,
406 	x_msg_count		OUT NOCOPY NUMBER,
407 	x_msg_data		OUT NOCOPY VARCHAR2,
408 	p_saiv_rec		IN saiv_rec_type);
409 
410 PROCEDURE update_std_art_incmpt(
411 	p_api_version 		IN NUMBER,
412 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
413 	x_return_status		OUT NOCOPY VARCHAR2,
414 	x_msg_count		OUT NOCOPY NUMBER,
415 	x_msg_data		OUT NOCOPY VARCHAR2,
416 	p_saiv_tbl		IN saiv_tbl_type,
417 	x_saiv_tbl		OUT NOCOPY saiv_tbl_type);
418 
419 PROCEDURE update_std_art_incmpt(
420 	p_api_version 		IN NUMBER,
421 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
422 	x_return_status		OUT NOCOPY VARCHAR2,
423 	x_msg_count		OUT NOCOPY NUMBER,
424 	x_msg_data		OUT NOCOPY VARCHAR2,
425 	p_saiv_rec		IN saiv_rec_type,
426 	x_saiv_rec		OUT NOCOPY saiv_rec_type);
427 
428 PROCEDURE delete_std_art_incmpt(
429 	p_api_version 		IN NUMBER,
430 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
431 	x_return_status		OUT NOCOPY VARCHAR2,
432 	x_msg_count		OUT NOCOPY NUMBER,
433 	x_msg_data		OUT NOCOPY VARCHAR2,
434 	p_saiv_tbl		IN saiv_tbl_type);
435 
436 
437 PROCEDURE delete_std_art_incmpt(
438 	p_api_version 		IN NUMBER,
439 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
440 	x_return_status		OUT NOCOPY VARCHAR2,
441 	x_msg_count		OUT NOCOPY NUMBER,
442 	x_msg_data		OUT NOCOPY VARCHAR2,
443 	p_saiv_rec		IN saiv_rec_type);
444 
445 PROCEDURE validate_std_art_incmpt(
446 	p_api_version 		IN NUMBER,
447 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
448 	x_return_status		OUT NOCOPY VARCHAR2,
449 	x_msg_count		OUT NOCOPY NUMBER,
450 	x_msg_data		OUT NOCOPY VARCHAR2,
451 	p_saiv_tbl		IN saiv_tbl_type);
452 
453 
454 PROCEDURE validate_std_art_incmpt(
455 	p_api_version 		IN NUMBER,
456 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
457 	x_return_status		OUT NOCOPY VARCHAR2,
458 	x_msg_count		OUT NOCOPY NUMBER,
459 	x_msg_data		OUT NOCOPY VARCHAR2,
460 	p_saiv_rec		IN saiv_rec_type);
461 
462 PROCEDURE validate_unique(
463 	p_api_version 		IN NUMBER,
464 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
465 	x_return_status		OUT NOCOPY VARCHAR2,
466 	x_msg_count		OUT NOCOPY NUMBER,
467 	x_msg_data		OUT NOCOPY VARCHAR2,
468 	p_saiv_rec		IN saiv_rec_type);
469 
470 PROCEDURE validate_unique(
471 	p_api_version 		IN NUMBER,
472 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
473 	x_return_status		OUT NOCOPY VARCHAR2,
474 	x_msg_count		OUT NOCOPY NUMBER,
475 	x_msg_data		OUT NOCOPY VARCHAR2,
476 	p_saiv_tbl		IN saiv_tbl_type);
477 
478 PROCEDURE create_std_art_classing(
479 	p_api_version 		IN NUMBER,
480 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
481 	x_return_status		OUT NOCOPY VARCHAR2,
482 	x_msg_count		OUT NOCOPY NUMBER,
483 	x_msg_data		OUT NOCOPY VARCHAR2,
484 	p_sacv_tbl		IN sacv_tbl_type,
485 	x_sacv_tbl		OUT NOCOPY sacv_tbl_type);
486 
487 PROCEDURE create_std_art_classing(
488 	p_api_version 		IN NUMBER,
489 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
490 	x_return_status		OUT NOCOPY VARCHAR2,
491 	x_msg_count		OUT NOCOPY NUMBER,
492 	x_msg_data		OUT NOCOPY VARCHAR2,
493 	p_sacv_rec		IN sacv_rec_type,
494 	x_sacv_rec		OUT NOCOPY sacv_rec_type);
495 
496 PROCEDURE lock_std_art_classing(
497 	p_api_version 		IN NUMBER,
498 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
499 	x_return_status		OUT NOCOPY VARCHAR2,
500 	x_msg_count		OUT NOCOPY NUMBER,
501 	x_msg_data		OUT NOCOPY VARCHAR2,
502 	p_sacv_tbl		IN sacv_tbl_type);
503 
504 PROCEDURE lock_std_art_classing(
505 	p_api_version 		IN NUMBER,
506 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_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_sacv_rec		IN sacv_rec_type);
511 
512 PROCEDURE update_std_art_classing(
513 	p_api_version 		IN NUMBER,
514 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
515 	x_return_status		OUT NOCOPY VARCHAR2,
516 	x_msg_count		OUT NOCOPY NUMBER,
517 	x_msg_data		OUT NOCOPY VARCHAR2,
518 	p_sacv_tbl		IN sacv_tbl_type,
519 	x_sacv_tbl		OUT NOCOPY sacv_tbl_type);
520 
521 
522 PROCEDURE update_std_art_classing(
523 	p_api_version 		IN NUMBER,
524 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
525 	x_return_status		OUT NOCOPY VARCHAR2,
526 	x_msg_count		OUT NOCOPY NUMBER,
527 	x_msg_data		OUT NOCOPY VARCHAR2,
528 	p_sacv_rec		IN sacv_rec_type,
529 	x_sacv_rec		OUT NOCOPY sacv_rec_type);
530 
531 PROCEDURE delete_std_art_classing(
532 	p_api_version 		IN NUMBER,
533 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
534 	x_return_status		OUT NOCOPY VARCHAR2,
535 	x_msg_count		OUT NOCOPY NUMBER,
536 	x_msg_data		OUT NOCOPY VARCHAR2,
537 	p_sacv_tbl		IN sacv_tbl_type);
538 
539 
540 PROCEDURE delete_std_art_classing(
541 	p_api_version 		IN NUMBER,
542 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
543 	x_return_status		OUT NOCOPY VARCHAR2,
544 	x_msg_count		OUT NOCOPY NUMBER,
545 	x_msg_data		OUT NOCOPY VARCHAR2,
546 	p_sacv_rec		IN sacv_rec_type);
547 
548 PROCEDURE validate_std_art_classing(
549 	p_api_version 		IN NUMBER,
550 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
551 	x_return_status		OUT NOCOPY VARCHAR2,
552 	x_msg_count		OUT NOCOPY NUMBER,
553 	x_msg_data		OUT NOCOPY VARCHAR2,
554 	p_sacv_tbl		IN sacv_tbl_type);
555 
556 PROCEDURE validate_std_art_classing(
557 	p_api_version 		IN NUMBER,
558 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
559 	x_return_status		OUT NOCOPY VARCHAR2,
560 	x_msg_count		OUT NOCOPY NUMBER,
561 	x_msg_data		OUT NOCOPY VARCHAR2,
562 	p_sacv_rec		IN sacv_rec_type);
563 
564 PROCEDURE validate_price_type(
565 	p_api_version 		IN NUMBER,
566 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
567 	x_return_status		OUT NOCOPY VARCHAR2,
568 	x_msg_count		OUT NOCOPY NUMBER,
569 	x_msg_data		OUT NOCOPY VARCHAR2,
570 	p_sacv_rec		IN sacv_rec_type);
571 
572 PROCEDURE validate_price_type(
573 	p_api_version 		IN NUMBER,
574 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
575 	x_return_status		OUT NOCOPY VARCHAR2,
576 	x_msg_count		OUT NOCOPY NUMBER,
577 	x_msg_data		OUT NOCOPY VARCHAR2,
578 	p_sacv_tbl		IN sacv_tbl_type);
579 
580 PROCEDURE validate_scs_code(
581 	p_api_version 		IN NUMBER,
582 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
583 	x_return_status		OUT NOCOPY VARCHAR2,
584 	x_msg_count		OUT NOCOPY NUMBER,
585 	x_msg_data		OUT NOCOPY VARCHAR2,
586 	p_sacv_rec		IN sacv_rec_type);
587 
588 PROCEDURE validate_scs_code(
589 	p_api_version 		IN NUMBER,
590 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
591 	x_return_status		OUT NOCOPY VARCHAR2,
592 	x_msg_count		OUT NOCOPY NUMBER,
593 	x_msg_data		OUT NOCOPY VARCHAR2,
594 	p_sacv_tbl		IN sacv_tbl_type);
595 
596 
597 PROCEDURE create_std_art_set_mem(
598 	p_api_version 		IN NUMBER,
599 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
600 	x_return_status		OUT NOCOPY VARCHAR2,
601 	x_msg_count		OUT NOCOPY NUMBER,
602 	x_msg_data		OUT NOCOPY VARCHAR2,
603 	p_samv_tbl		IN samv_tbl_type,
604 	x_samv_tbl		OUT NOCOPY samv_tbl_type);
605 
606 
607 PROCEDURE create_std_art_set_mem(
608 	p_api_version 		IN NUMBER,
609 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
610 	x_return_status		OUT NOCOPY VARCHAR2,
611 	x_msg_count		OUT NOCOPY NUMBER,
612 	x_msg_data		OUT NOCOPY VARCHAR2,
613 	p_samv_rec		IN samv_rec_type,
614 	x_samv_rec		OUT NOCOPY samv_rec_type);
615 
616 PROCEDURE lock_std_art_set_mem(
617 	p_api_version 		IN NUMBER,
618 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
619 	x_return_status		OUT NOCOPY VARCHAR2,
620 	x_msg_count		OUT NOCOPY NUMBER,
621 	x_msg_data		OUT NOCOPY VARCHAR2,
622 	p_samv_tbl		IN samv_tbl_type);
623 
624 
625 PROCEDURE lock_std_art_set_mem(
626 	p_api_version 		IN NUMBER,
627 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
628 	x_return_status		OUT NOCOPY VARCHAR2,
629 	x_msg_count		OUT NOCOPY NUMBER,
630 	x_msg_data		OUT NOCOPY VARCHAR2,
631 	p_samv_rec		IN samv_rec_type);
632 
633 PROCEDURE update_std_art_set_mem(
634 	p_api_version 		IN NUMBER,
635 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
636 	x_return_status		OUT NOCOPY VARCHAR2,
637 	x_msg_count		OUT NOCOPY NUMBER,
638 	x_msg_data		OUT NOCOPY VARCHAR2,
639 	p_samv_tbl		IN samv_tbl_type,
640 	x_samv_tbl		OUT NOCOPY samv_tbl_type);
641 
642 PROCEDURE update_std_art_set_mem(
643 	p_api_version 		IN NUMBER,
644 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
645 	x_return_status		OUT NOCOPY VARCHAR2,
646 	x_msg_count		OUT NOCOPY NUMBER,
647 	x_msg_data		OUT NOCOPY VARCHAR2,
648 	p_samv_rec		IN samv_rec_type,
649 	x_samv_rec		OUT NOCOPY samv_rec_type);
650 
651 PROCEDURE delete_std_art_set_mem(
652 	p_api_version 		IN NUMBER,
653 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
654 	x_return_status		OUT NOCOPY VARCHAR2,
655 	x_msg_count		OUT NOCOPY NUMBER,
656 	x_msg_data		OUT NOCOPY VARCHAR2,
657 	p_samv_tbl		IN samv_tbl_type);
658 
659 PROCEDURE delete_std_art_set_mem(
660 	p_api_version 		IN NUMBER,
661 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
662 	x_return_status		OUT NOCOPY VARCHAR2,
663 	x_msg_count		OUT NOCOPY NUMBER,
664 	x_msg_data		OUT NOCOPY VARCHAR2,
665 	p_samv_rec		IN samv_rec_type);
666 
667 PROCEDURE validate_std_art_set_mem(
668 	p_api_version 		IN NUMBER,
669 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
670 	x_return_status		OUT NOCOPY VARCHAR2,
671 	x_msg_count		OUT NOCOPY NUMBER,
672 	x_msg_data		OUT NOCOPY VARCHAR2,
673 	p_samv_tbl		IN samv_tbl_type);
674 
675 PROCEDURE validate_std_art_set_mem(
676 	p_api_version 		IN NUMBER,
677 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
678 	x_return_status		OUT NOCOPY VARCHAR2,
679 	x_msg_count		OUT NOCOPY NUMBER,
680 	x_msg_data		OUT NOCOPY VARCHAR2,
681 	p_samv_rec		IN samv_rec_type);
682 
683 PROCEDURE validate_unique(
684 	p_api_version 		IN NUMBER,
685 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
686 	x_return_status		OUT NOCOPY VARCHAR2,
687 	x_msg_count		OUT NOCOPY NUMBER,
688 	x_msg_data		OUT NOCOPY VARCHAR2,
689 	p_samv_rec		IN samv_rec_type);
690 
691 PROCEDURE validate_unique(
692 	p_api_version 		IN NUMBER,
693 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
694 	x_return_status		OUT NOCOPY VARCHAR2,
695 	x_msg_count		OUT NOCOPY NUMBER,
696 	x_msg_data		OUT NOCOPY VARCHAR2,
697 	p_samv_tbl		IN samv_tbl_type);
698 
699 
700 FUNCTION used_in_contracts
701 (
702   p_sav_sae_id               IN   okc_k_articles_b.sav_sae_id%TYPE,
703   p_sav_sav_release          IN   okc_k_articles_b.sav_sav_release%TYPE
704 )
705 RETURN VARCHAR2 ;
706 
707 FUNCTION empclob RETURN CLOB;
708 
709 FUNCTION latest_release
710 (
711   p_sav_sae_id               IN   okc_k_articles_b.sav_sae_id%TYPE
712 )
713 RETURN VARCHAR2 ;
714 -- BUG 3188215 - KOL: BACKWARD COMPATIBILITY CHANGES
715 -- Modified the Function signature.
716 FUNCTION latest_release
717 (
718   p_sav_sae_id               IN   okc_k_articles_b.sav_sae_id%TYPE,
719   p_article_version_number   IN   okc_article_versions.article_version_number%TYPE
720 )
721 RETURN VARCHAR2 ;
722 -- BUG 3188215 - KOL: BACKWARD COMPATIBILITY CHANGES
723 -- Modified the Function signature.
724 FUNCTION latest_or_future_release
725 (
726   p_sav_sae_id               IN   okc_k_articles_b.sav_sae_id%TYPE,
727   p_article_version_number   IN   okc_article_versions.article_version_number%TYPE,
728   p_date_active              IN   okc_article_versions.start_date%TYPE
729 )
730 RETURN VARCHAR2 ;
731 
732 END okc_std_article_pub;