[Home] [Help]
PACKAGE BODY: APPS.OKC_PRICE_ADJUSTMENT_PVT
Source
1 package body okc_price_adjustment_PVT AS
2 /* $Header: OKCCPATB.pls 120.0 2005/05/25 19:11:45 appldev noship $*/
3
4 l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5
6 -- Complex API for Price Adjusments
7
8 PROCEDURE create_price_adjustment(
9 p_api_version IN NUMBER,
10 p_init_msg_list IN VARCHAR2 ,
11 x_return_status OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER,
13 x_msg_data OUT NOCOPY VARCHAR2,
14 p_patv_rec IN patv_rec_type,
15 x_patv_rec OUT NOCOPY patv_rec_type) IS
16 BEGIN
17
18 okc_pat_pvt.insert_row(
19 p_api_version,
20 p_init_msg_list,
21 x_return_status,
22 x_msg_count,
23 x_msg_data,
24 p_patv_rec,
25 x_patv_rec);
26
27 END create_price_adjustment;
28
29 PROCEDURE create_price_adjustment(
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 ,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 p_patv_tbl IN patv_tbl_type,
36 x_patv_tbl OUT NOCOPY patv_tbl_type) IS
37 BEGIN
38 okc_pat_pvt.insert_row(
39 p_api_version,
40 p_init_msg_list,
41 x_return_status,
42 x_msg_count,
43 x_msg_data,
44 p_patv_tbl,
45 x_patv_tbl);
46
47 END create_price_adjustment;
48
49
50 PROCEDURE update_price_adjustment(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 ,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_patv_rec IN patv_rec_type,
57 x_patv_rec OUT NOCOPY patv_rec_type) IS
58 BEGIN
59
60 okc_pat_pvt.update_row(
61 p_api_version,
62 p_init_msg_list,
63 x_return_status,
64 x_msg_count,
65 x_msg_data,
66 p_patv_rec,
67 x_patv_rec);
68
69 END update_price_adjustment;
70
71 PROCEDURE update_price_adjustment(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 ,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_patv_tbl IN patv_tbl_type,
78 x_patv_tbl OUT NOCOPY patv_tbl_type)IS
79 BEGIN
80
81 okc_pat_pvt.update_row(
82 p_api_version,
83 p_init_msg_list,
84 x_return_status,
85 x_msg_count,
86 x_msg_data,
87 p_patv_tbl,
88 x_patv_tbl);
89
90 END update_price_adjustment;
91 ---****************************************************************************************
92 PROCEDURE delete_price_adjustment(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 ,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_patv_rec IN patv_rec_type) IS
99
100 l_patv_rec okc_price_adjustment_PUB.patv_rec_type; --for price adjustments
101 l_pacv_rec okc_price_adjustment_PUB.pacv_rec_type; --for price adjustment assoc
102 l_pavv_rec okc_price_adjustment_PUB.paav_rec_type; --for price adjustment attributes
103
104 --cursor to fetch the child lines
105 CURSOR l_padj_csr IS
106 SELECT A.id,A.chr_id,A.cle_id
107 FROM OKC_PRICE_ADJUSTMENTS_V A,
108 OKC_PRICE_ADJ_ASSOCS_V B
109 WHERE B.pat_id_from = p_patv_rec.id
110 AND A.ID = B.PAT_ID
111 AND (A.chr_id = p_patv_rec.chr_id
112 OR A.cle_id = p_patv_rec.cle_id);
113 --
114 CURSOR l_assoc_csr IS
115 SELECT id
116 FROM OKC_PRICE_ADJ_ASSOCS_V
117 WHERE pat_id_from = p_patv_rec.id;
118 --
119
120 CURSOR l_attrib_csr IS
121 SELECT id
122 FROM OKC_PRICE_ADJ_ATTRIBS_V
123 WHERE pat_id = p_patv_rec.id;
124 --
125
126 BEGIN
127
128 -- delete parent record from OKC_PRICE_ADJUSTMENTS.
129 okc_pat_pvt.delete_row(
130 p_api_version,
131 p_init_msg_list,
132 x_return_status,
133 x_msg_count,
134 x_msg_data,
135 p_patv_rec );
136
137 If (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
138
139 For padj_rec In l_padj_csr Loop
140 l_patv_rec.id := padj_rec.id;
141 l_patv_rec.chr_id := padj_rec.chr_id;
142 l_patv_rec.cle_id := padj_rec.cle_id;
143
144 -- Delete all child records from OKC__PRICE_ADJUSTMENTS.
145 OKC_PRICE_ADJUSTMENT_PUB.delete_price_adjustment(
146 p_api_version => p_api_version,
147 p_init_msg_list => p_init_msg_list,
148 x_return_status => x_return_status,
149 x_msg_count => x_msg_count,
150 x_msg_data => x_msg_data,
151 p_patv_rec => l_patv_rec);
152
153 IF (X_return_status <> 'S') Then
154 EXIT;
155 END IF;
156 END LOOP;
157 End If;
158
159 If (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
160 For assoc_rec In l_assoc_csr Loop
161 l_pacv_rec.id := assoc_rec.id;
162
163 -- Delete related records from OKC_PRICE_ADJ_ASSOCS_V
164 OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_assoc(
165 p_api_version => p_api_version,
166 p_init_msg_list => p_init_msg_list,
167 x_return_status => x_return_status,
168 x_msg_count => x_msg_count,
169 x_msg_data => x_msg_data,
170 p_pacv_rec => l_pacv_rec );
171 IF (X_return_status <> 'S') Then
172 EXIT;
173 END IF;
174 END LOOP;
175 End if;
176
177 If (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
178
179 For attrib_rec In l_attrib_csr Loop
180 l_pavv_rec.id := attrib_rec.id;
181
182 --Delete related records in OKC_PRICE_ADJ_ATTRIBS_V
183 OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_attrib(
184 p_api_version => p_api_version,
185 p_init_msg_list => p_init_msg_list,
186 x_return_status => x_return_status,
187 x_msg_count => x_msg_count,
188 x_msg_data => x_msg_data,
189 p_paav_rec => l_pavv_rec);
190 IF (X_return_status <> 'S') Then
191 EXIT;
192 END IF;
193 END LOOP;
194 END IF;
195 END delete_price_adjustment;
196 ---
197 PROCEDURE delete_price_adjustment(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 ,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_patv_tbl IN patv_tbl_type)IS
204 BEGIN
205
206 okc_pat_pvt.delete_row(
207 p_api_version,
208 p_init_msg_list,
209 x_return_status,
210 x_msg_count,
211 x_msg_data,
212 p_patv_tbl);
213
214 END delete_price_adjustment;
215
216 PROCEDURE validate_price_adjustment(
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 ,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222 p_patv_rec IN patv_rec_type)IS
223 BEGIN
224
225 okc_pat_pvt.validate_row(
226 p_api_version,
227 p_init_msg_list,
228 x_return_status,
229 x_msg_count,
230 x_msg_data,
231 p_patv_rec);
232
233 END validate_price_adjustment;
234
235 PROCEDURE validate_price_adjustment(
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2 ,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241 p_patv_tbl IN patv_tbl_type)IS
242 BEGIN
243
244 okc_pat_pvt.validate_row(
245 p_api_version,
246 p_init_msg_list,
247 x_return_status,
248 x_msg_count,
249 x_msg_data,
250 p_patv_tbl);
251
252 END validate_price_adjustment;
253
254 PROCEDURE lock_price_adjustment(
255 p_api_version IN NUMBER,
256 p_init_msg_list IN VARCHAR2 ,
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_count OUT NOCOPY NUMBER,
259 x_msg_data OUT NOCOPY VARCHAR2,
260 p_patv_rec IN patv_rec_type)IS
261
262 BEGIN
263
264 okc_pat_pvt.lock_row(
265 p_api_version,
266 p_init_msg_list,
267 x_return_status,
268 x_msg_count,
269 x_msg_data,
270 p_patv_rec);
271
272 END lock_price_adjustment;
273
274 PROCEDURE lock_price_adjustment(
275 p_api_version IN NUMBER,
276 p_init_msg_list IN VARCHAR2 ,
277 x_return_status OUT NOCOPY VARCHAR2,
278 x_msg_count OUT NOCOPY NUMBER,
279 x_msg_data OUT NOCOPY VARCHAR2,
280 p_patv_tbl IN patv_tbl_type)IS
281
282 BEGIN
283
284 okc_pat_pvt.lock_row(
285 p_api_version,
286 p_init_msg_list,
287 x_return_status,
288 x_msg_count,
289 x_msg_data,
290 p_patv_tbl);
291
292 END lock_price_adjustment;
293
294
295
296 PROCEDURE create_price_adj_assoc(
297 p_api_version IN NUMBER,
298 p_init_msg_list IN VARCHAR2 ,
299 x_return_status OUT NOCOPY VARCHAR2,
300 x_msg_count OUT NOCOPY NUMBER,
301 x_msg_data OUT NOCOPY VARCHAR2,
302 p_pacv_rec IN pacv_rec_type,
303 x_pacv_rec OUT NOCOPY pacv_rec_type) IS
304 BEGIN
305
306 okc_pac_pvt.insert_row(
307 p_api_version,
308 p_init_msg_list,
309 x_return_status,
310 x_msg_count,
311 x_msg_data,
312 p_pacv_rec,
313 x_pacv_rec);
314
315 END create_price_adj_assoc;
316
317 PROCEDURE create_price_adj_assoc(
318 p_api_version IN NUMBER,
319 p_init_msg_list IN VARCHAR2 ,
320 x_return_status OUT NOCOPY VARCHAR2,
321 x_msg_count OUT NOCOPY NUMBER,
322 x_msg_data OUT NOCOPY VARCHAR2,
323 p_pacv_tbl IN pacv_tbl_type,
324 x_pacv_tbl OUT NOCOPY pacv_tbl_type) IS
325 BEGIN
326 okc_pac_pvt.insert_row(
327 p_api_version,
328 p_init_msg_list,
329 x_return_status,
330 x_msg_count,
331 x_msg_data,
332 p_pacv_tbl,
333 x_pacv_tbl);
334
335 END create_price_adj_assoc;
336
337
338 PROCEDURE update_price_adj_assoc(
339 p_api_version IN NUMBER,
340 p_init_msg_list IN VARCHAR2 ,
341 x_return_status OUT NOCOPY VARCHAR2,
342 x_msg_count OUT NOCOPY NUMBER,
343 x_msg_data OUT NOCOPY VARCHAR2,
344 p_pacv_rec IN pacv_rec_type,
345 x_pacv_rec OUT NOCOPY pacv_rec_type) IS
346 BEGIN
347
348 okc_pac_pvt.update_row(
349 p_api_version,
350 p_init_msg_list,
351 x_return_status,
352 x_msg_count,
353 x_msg_data,
354 p_pacv_rec,
355 x_pacv_rec);
356
357 END update_price_adj_assoc;
358
359 PROCEDURE update_price_adj_assoc(
360 p_api_version IN NUMBER,
361 p_init_msg_list IN VARCHAR2 ,
362 x_return_status OUT NOCOPY VARCHAR2,
363 x_msg_count OUT NOCOPY NUMBER,
364 x_msg_data OUT NOCOPY VARCHAR2,
365 p_pacv_tbl IN pacv_tbl_type,
366 x_pacv_tbl OUT NOCOPY pacv_tbl_type)IS
367 BEGIN
368
369 okc_pac_pvt.update_row(
370 p_api_version,
371 p_init_msg_list,
372 x_return_status,
373 x_msg_count,
374 x_msg_data,
375 p_pacv_tbl,
376 x_pacv_tbl);
377
378 END update_price_adj_assoc;
379
380
381 PROCEDURE delete_price_adj_assoc(
382 p_api_version IN NUMBER,
383 p_init_msg_list IN VARCHAR2 ,
384 x_return_status OUT NOCOPY VARCHAR2,
385 x_msg_count OUT NOCOPY NUMBER,
386 x_msg_data OUT NOCOPY VARCHAR2,
387 p_pacv_rec IN pacv_rec_type)IS
388 BEGIN
389
390 okc_pac_pvt.delete_row(
391 p_api_version,
392 p_init_msg_list,
393 x_return_status,
394 x_msg_count,
395 x_msg_data,
396 p_pacv_rec );
397
398 END delete_price_adj_assoc;
399
400 PROCEDURE delete_price_adj_assoc(
401 p_api_version IN NUMBER,
402 p_init_msg_list IN VARCHAR2 ,
403 x_return_status OUT NOCOPY VARCHAR2,
404 x_msg_count OUT NOCOPY NUMBER,
405 x_msg_data OUT NOCOPY VARCHAR2,
406 p_pacv_tbl IN pacv_tbl_type)IS
407 BEGIN
408
409 okc_pac_pvt.delete_row(
410 p_api_version,
411 p_init_msg_list,
412 x_return_status,
413 x_msg_count,
414 x_msg_data,
415 p_pacv_tbl);
416
417 END delete_price_adj_assoc;
418
419 PROCEDURE validate_price_adj_assoc(
420 p_api_version IN NUMBER,
421 p_init_msg_list IN VARCHAR2 ,
422 x_return_status OUT NOCOPY VARCHAR2,
423 x_msg_count OUT NOCOPY NUMBER,
424 x_msg_data OUT NOCOPY VARCHAR2,
425 p_pacv_rec IN pacv_rec_type)IS
426 BEGIN
427
428 okc_pac_pvt.validate_row(
429 p_api_version,
430 p_init_msg_list,
431 x_return_status,
432 x_msg_count,
433 x_msg_data,
434 p_pacv_rec);
435
436 END validate_price_adj_assoc;
437
438 PROCEDURE validate_price_adj_assoc(
439 p_api_version IN NUMBER,
440 p_init_msg_list IN VARCHAR2 ,
441 x_return_status OUT NOCOPY VARCHAR2,
442 x_msg_count OUT NOCOPY NUMBER,
443 x_msg_data OUT NOCOPY VARCHAR2,
444 p_pacv_tbl IN pacv_tbl_type)IS
445 BEGIN
446
447 okc_pac_pvt.validate_row(
448 p_api_version,
449 p_init_msg_list,
450 x_return_status,
451 x_msg_count,
452 x_msg_data,
453 p_pacv_tbl);
454
455 END validate_price_adj_assoc;
456
457 PROCEDURE lock_price_adj_assoc(
458 p_api_version IN NUMBER,
459 p_init_msg_list IN VARCHAR2 ,
460 x_return_status OUT NOCOPY VARCHAR2,
461 x_msg_count OUT NOCOPY NUMBER,
462 x_msg_data OUT NOCOPY VARCHAR2,
463 p_pacv_rec IN pacv_rec_type)IS
464
465 BEGIN
466
467 okc_pac_pvt.lock_row(
468 p_api_version,
469 p_init_msg_list,
470 x_return_status,
471 x_msg_count,
472 x_msg_data,
473 p_pacv_rec);
474
475 END lock_price_adj_assoc;
476
477 PROCEDURE lock_price_adj_assoc(
478 p_api_version IN NUMBER,
479 p_init_msg_list IN VARCHAR2 ,
480 x_return_status OUT NOCOPY VARCHAR2,
481 x_msg_count OUT NOCOPY NUMBER,
482 x_msg_data OUT NOCOPY VARCHAR2,
483 p_pacv_tbl IN pacv_tbl_type)IS
484
485 BEGIN
486
487 okc_pac_pvt.lock_row(
488 p_api_version,
489 p_init_msg_list,
490 x_return_status,
491 x_msg_count,
492 x_msg_data,
493 p_pacv_tbl);
494
495 END lock_price_adj_assoc;
496
497 PROCEDURE create_price_adj_attrib(
498 p_api_version IN NUMBER,
499 p_init_msg_list IN VARCHAR2 ,
500 x_return_status OUT NOCOPY VARCHAR2,
501 x_msg_count OUT NOCOPY NUMBER,
502 x_msg_data OUT NOCOPY VARCHAR2,
503 p_paav_rec IN paav_rec_type,
504 x_paav_rec OUT NOCOPY paav_rec_type) IS
505 BEGIN
506
507 okc_paa_pvt.insert_row(
508 p_api_version,
509 p_init_msg_list,
510 x_return_status,
511 x_msg_count,
512 x_msg_data,
513 p_paav_rec,
514 x_paav_rec);
515
516 END create_price_adj_attrib;
517
518 PROCEDURE create_price_adj_attrib(
519 p_api_version IN NUMBER,
520 p_init_msg_list IN VARCHAR2 ,
521 x_return_status OUT NOCOPY VARCHAR2,
522 x_msg_count OUT NOCOPY NUMBER,
523 x_msg_data OUT NOCOPY VARCHAR2,
524 p_paav_tbl IN paav_tbl_type,
525 x_paav_tbl OUT NOCOPY paav_tbl_type) IS
526 BEGIN
527 okc_paa_pvt.insert_row(
528 p_api_version ,
529 p_init_msg_list ,
530 x_return_status ,
531 x_msg_count ,
532 x_msg_data ,
533 p_paav_tbl ,
534 x_paav_tbl );
535
536
537 END create_price_adj_attrib;
538
539
540 PROCEDURE update_price_adj_attrib(
541 p_api_version IN NUMBER,
542 p_init_msg_list IN VARCHAR2 ,
543 x_return_status OUT NOCOPY VARCHAR2,
544 x_msg_count OUT NOCOPY NUMBER,
545 x_msg_data OUT NOCOPY VARCHAR2,
546 p_paav_rec IN paav_rec_type,
547 x_paav_rec OUT NOCOPY paav_rec_type) IS
548 BEGIN
549
550 okc_paa_pvt.update_row(
551 p_api_version,
552 p_init_msg_list,
553 x_return_status,
554 x_msg_count,
555 x_msg_data,
556 p_paav_rec,
557 x_paav_rec);
558
559 END update_price_adj_attrib;
560
561 PROCEDURE update_price_adj_attrib(
562 p_api_version IN NUMBER,
563 p_init_msg_list IN VARCHAR2 ,
564 x_return_status OUT NOCOPY VARCHAR2,
565 x_msg_count OUT NOCOPY NUMBER,
566 x_msg_data OUT NOCOPY VARCHAR2,
567 p_paav_tbl IN paav_tbl_type,
568 x_paav_tbl OUT NOCOPY paav_tbl_type)IS
569 BEGIN
570
571 okc_paa_pvt.update_row(
572 p_api_version,
573 p_init_msg_list,
574 x_return_status,
575 x_msg_count,
576 x_msg_data,
577 p_paav_tbl,
578 x_paav_tbl);
579
580 END update_price_adj_attrib;
581
582
583 PROCEDURE delete_price_adj_attrib(
584 p_api_version IN NUMBER,
585 p_init_msg_list IN VARCHAR2 ,
586 x_return_status OUT NOCOPY VARCHAR2,
587 x_msg_count OUT NOCOPY NUMBER,
588 x_msg_data OUT NOCOPY VARCHAR2,
589 p_paav_rec IN paav_rec_type)IS
590 BEGIN
591
592 okc_paa_pvt.delete_row(
593 p_api_version,
594 p_init_msg_list,
595 x_return_status,
596 x_msg_count,
597 x_msg_data,
598 p_paav_rec );
599
600 END delete_price_adj_attrib;
601
602 PROCEDURE delete_price_adj_attrib(
603 p_api_version IN NUMBER,
604 p_init_msg_list IN VARCHAR2 ,
605 x_return_status OUT NOCOPY VARCHAR2,
606 x_msg_count OUT NOCOPY NUMBER,
607 x_msg_data OUT NOCOPY VARCHAR2,
608 p_paav_tbl IN paav_tbl_type)IS
609 BEGIN
610
611 okc_paa_pvt.delete_row(
612 p_api_version,
613 p_init_msg_list,
614 x_return_status,
615 x_msg_count,
616 x_msg_data,
617 p_paav_tbl);
618
619 END delete_price_adj_attrib;
620
621 PROCEDURE validate_price_adj_attrib(
622 p_api_version IN NUMBER,
623 p_init_msg_list IN VARCHAR2 ,
624 x_return_status OUT NOCOPY VARCHAR2,
625 x_msg_count OUT NOCOPY NUMBER,
626 x_msg_data OUT NOCOPY VARCHAR2,
627 p_paav_rec IN paav_rec_type)IS
628 BEGIN
629
630 okc_paa_pvt.validate_row(
631 p_api_version,
632 p_init_msg_list,
633 x_return_status,
634 x_msg_count,
635 x_msg_data,
636 p_paav_rec);
637
638 END validate_price_adj_attrib;
639
640 PROCEDURE validate_price_adj_attrib(
641 p_api_version IN NUMBER,
642 p_init_msg_list IN VARCHAR2 ,
643 x_return_status OUT NOCOPY VARCHAR2,
644 x_msg_count OUT NOCOPY NUMBER,
645 x_msg_data OUT NOCOPY VARCHAR2,
646 p_paav_tbl IN paav_tbl_type)IS
647 BEGIN
648
649 okc_paa_pvt.validate_row(
650 p_api_version,
651 p_init_msg_list,
652 x_return_status,
653 x_msg_count,
654 x_msg_data,
655 p_paav_tbl);
656
657 END validate_price_adj_attrib;
658
659 PROCEDURE lock_price_adj_attrib(
660 p_api_version IN NUMBER,
661 p_init_msg_list IN VARCHAR2 ,
662 x_return_status OUT NOCOPY VARCHAR2,
663 x_msg_count OUT NOCOPY NUMBER,
664 x_msg_data OUT NOCOPY VARCHAR2,
665 p_paav_rec IN paav_rec_type)IS
666
667 BEGIN
668
669 okc_paa_pvt.lock_row(
670 p_api_version,
671 p_init_msg_list,
672 x_return_status,
673 x_msg_count,
674 x_msg_data,
675 p_paav_rec);
676
677 END lock_price_adj_attrib;
678
679 PROCEDURE lock_price_adj_attrib(
680 p_api_version IN NUMBER,
681 p_init_msg_list IN VARCHAR2 ,
682 x_return_status OUT NOCOPY VARCHAR2,
683 x_msg_count OUT NOCOPY NUMBER,
684 x_msg_data OUT NOCOPY VARCHAR2,
685 p_paav_tbl IN paav_tbl_type)IS
686
687 BEGIN
688
689 okc_paa_pvt.lock_row(
690 p_api_version,
691 p_init_msg_list,
692 x_return_status,
693 x_msg_count,
694 x_msg_data,
695 p_paav_tbl);
696
697 END lock_price_adj_attrib;
698
699 PROCEDURE create_price_att_value(
700 p_api_version IN NUMBER,
701 p_init_msg_list IN VARCHAR2 ,
702 x_return_status OUT NOCOPY VARCHAR2,
703 x_msg_count OUT NOCOPY NUMBER,
704 x_msg_data OUT NOCOPY VARCHAR2,
705 p_pavv_rec IN pavv_rec_type,
706 x_pavv_rec OUT NOCOPY pavv_rec_type) IS
707 BEGIN
708
709 okc_pav_pvt.insert_row(
710 p_api_version,
711 p_init_msg_list,
712 x_return_status,
713 x_msg_count,
714 x_msg_data,
715 p_pavv_rec,
716 x_pavv_rec);
717
718 END create_price_att_value;
719
720 PROCEDURE create_price_att_value(
721 p_api_version IN NUMBER,
722 p_init_msg_list IN VARCHAR2 ,
723 x_return_status OUT NOCOPY VARCHAR2,
724 x_msg_count OUT NOCOPY NUMBER,
725 x_msg_data OUT NOCOPY VARCHAR2,
726 p_pavv_tbl IN pavv_tbl_type,
727 x_pavv_tbl OUT NOCOPY pavv_tbl_type) IS
728 BEGIN
729 okc_pav_pvt.insert_row(
730 p_api_version,
731 p_init_msg_list,
732 x_return_status,
733 x_msg_count,
734 x_msg_data,
735 p_pavv_tbl,
736 x_pavv_tbl);
737
738 END create_price_att_value;
739
740
741 PROCEDURE update_price_att_value(
742 p_api_version IN NUMBER,
743 p_init_msg_list IN VARCHAR2 ,
744 x_return_status OUT NOCOPY VARCHAR2,
745 x_msg_count OUT NOCOPY NUMBER,
746 x_msg_data OUT NOCOPY VARCHAR2,
747 p_pavv_rec IN pavv_rec_type,
748 x_pavv_rec OUT NOCOPY pavv_rec_type) IS
749 BEGIN
750
751 okc_pav_pvt.update_row(
752 p_api_version,
753 p_init_msg_list,
754 x_return_status,
755 x_msg_count,
756 x_msg_data,
757 p_pavv_rec,
758 x_pavv_rec);
759
760 END update_price_att_value;
761
762 PROCEDURE update_price_att_value(
763 p_api_version IN NUMBER,
764 p_init_msg_list IN VARCHAR2 ,
765 x_return_status OUT NOCOPY VARCHAR2,
766 x_msg_count OUT NOCOPY NUMBER,
767 x_msg_data OUT NOCOPY VARCHAR2,
768 p_pavv_tbl IN pavv_tbl_type,
769 x_pavv_tbl OUT NOCOPY pavv_tbl_type)IS
770 BEGIN
771
772 okc_pav_pvt.update_row(
773 p_api_version,
774 p_init_msg_list,
775 x_return_status,
776 x_msg_count,
777 x_msg_data,
778 p_pavv_tbl,
779 x_pavv_tbl);
780
781 END update_price_att_value;
782
783
784 PROCEDURE delete_price_att_value(
785 p_api_version IN NUMBER,
786 p_init_msg_list IN VARCHAR2 ,
787 x_return_status OUT NOCOPY VARCHAR2,
788 x_msg_count OUT NOCOPY NUMBER,
789 x_msg_data OUT NOCOPY VARCHAR2,
790 p_pavv_rec IN pavv_rec_type)IS
791 BEGIN
792
793 okc_pav_pvt.delete_row(
794 p_api_version,
795 p_init_msg_list,
796 x_return_status,
797 x_msg_count,
798 x_msg_data,
799 p_pavv_rec );
800
801 END delete_price_att_value;
802
803 PROCEDURE delete_price_att_value(
804 p_api_version IN NUMBER,
805 p_init_msg_list IN VARCHAR2 ,
806 x_return_status OUT NOCOPY VARCHAR2,
807 x_msg_count OUT NOCOPY NUMBER,
808 x_msg_data OUT NOCOPY VARCHAR2,
809 p_pavv_tbl IN pavv_tbl_type)IS
810 BEGIN
811
812 okc_pav_pvt.delete_row(
813 p_api_version,
814 p_init_msg_list,
815 x_return_status,
816 x_msg_count,
817 x_msg_data,
818 p_pavv_tbl);
819
820 END delete_price_att_value;
821
822 PROCEDURE validate_price_att_value(
823 p_api_version IN NUMBER,
824 p_init_msg_list IN VARCHAR2 ,
825 x_return_status OUT NOCOPY VARCHAR2,
826 x_msg_count OUT NOCOPY NUMBER,
827 x_msg_data OUT NOCOPY VARCHAR2,
828 p_pavv_rec IN pavv_rec_type)IS
829 BEGIN
830
831 okc_pav_pvt.validate_row(
832 p_api_version,
833 p_init_msg_list,
834 x_return_status,
835 x_msg_count,
836 x_msg_data,
837 p_pavv_rec);
838
839 END validate_price_att_value;
840
841 PROCEDURE validate_price_att_value(
842 p_api_version IN NUMBER,
843 p_init_msg_list IN VARCHAR2 ,
844 x_return_status OUT NOCOPY VARCHAR2,
845 x_msg_count OUT NOCOPY NUMBER,
846 x_msg_data OUT NOCOPY VARCHAR2,
847 p_pavv_tbl IN pavv_tbl_type)IS
848 BEGIN
849
850 okc_pav_pvt.validate_row(
851 p_api_version,
852 p_init_msg_list,
853 x_return_status,
854 x_msg_count,
855 x_msg_data,
856 p_pavv_tbl);
857
858 END validate_price_att_value;
859
860 PROCEDURE lock_price_att_value(
861 p_api_version IN NUMBER,
862 p_init_msg_list IN VARCHAR2 ,
863 x_return_status OUT NOCOPY VARCHAR2,
864 x_msg_count OUT NOCOPY NUMBER,
865 x_msg_data OUT NOCOPY VARCHAR2,
866 p_pavv_rec IN pavv_rec_type)IS
867
868 BEGIN
869
870 okc_pav_pvt.lock_row(
871 p_api_version,
872 p_init_msg_list,
873 x_return_status,
874 x_msg_count,
875 x_msg_data,
876 p_pavv_rec);
877
878 END lock_price_att_value;
879
880 PROCEDURE lock_price_att_value(
881 p_api_version IN NUMBER,
882 p_init_msg_list IN VARCHAR2 ,
883 x_return_status OUT NOCOPY VARCHAR2,
884 x_msg_count OUT NOCOPY NUMBER,
885 x_msg_data OUT NOCOPY VARCHAR2,
886 p_pavv_tbl IN pavv_tbl_type)IS
887
888 BEGIN
889
890 okc_pav_pvt.lock_row(
891 p_api_version,
892 p_init_msg_list,
893 x_return_status,
894 x_msg_count,
895 x_msg_data,
896 p_pavv_tbl);
897
898 END lock_price_att_value;
899
900 END okc_price_adjustment_pvt;