[Home] [Help]
PACKAGE: APPS.OKC_STD_ARTICLE_PUB
Source
1 package okc_std_article_pub AUTHID CURRENT_USER 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;