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