[Home] [Help]
PACKAGE: APPS.OZF_DISC_LINE_PVT
Source
1 PACKAGE OZF_Disc_Line_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvodls.pls 120.1 2006/05/04 15:25:50 julou noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Disc_Line_PVT
7 -- Purpose
8 --
9 -- History
10 -- Thu Oct 02 2003:1/8 PM RSSHARMA Created
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- ozf_offer_line_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- offer_discount_line_id
29 -- parent_discount_line_id
30 -- volume_from
31 -- volume_to
32 -- volume_operator
33 -- volume_type
34 -- volume_break_type
35 -- discount
36 -- discount_type
37 -- tier_type
38 -- tier_level
39 -- incompatibility_group
40 -- precedence
41 -- bucket
42 -- scan_value
43 -- scan_data_quantity
44 -- scan_unit_forecast
45 -- channel_id
46 -- adjustment_flag
47 -- start_date_active
48 -- end_date_active
49 -- uom_code
50 -- creation_date
51 -- created_by
52 -- last_update_date
53 -- last_updated_by
54 -- last_update_login
55 -- object_version_number
56 -- offer_id
57 --
58 -- Required
59 --
60 -- Defaults
61 --
62 -- Note: This is automatic generated record definition, it includes all columns
63 -- defined in the table, developer must manually add or delete some of the attributes.
64 --
65 -- End of Comments
66
67 --===================================================================
68 TYPE ozf_offer_line_rec_type IS RECORD
69 (
70 offer_discount_line_id NUMBER,
71 parent_discount_line_id NUMBER,
72 volume_from NUMBER,
73 volume_to NUMBER,
74 volume_operator VARCHAR2(30),
75 volume_type VARCHAR2(30),
76 volume_break_type VARCHAR2(30),
77 discount NUMBER,
78 discount_type VARCHAR2(30),
79 tier_type VARCHAR2(30),
80 tier_level VARCHAR2(30),
81 incompatibility_group VARCHAR2(30),
82 precedence NUMBER,
83 bucket VARCHAR2(30),
84 scan_value NUMBER,
85 scan_data_quantity NUMBER,
86 scan_unit_forecast NUMBER,
87 channel_id NUMBER,
88 adjustment_flag VARCHAR2(1),
89 start_date_active DATE,
90 end_date_active DATE,
91 uom_code VARCHAR2(30),
92 creation_date DATE,
93 created_by NUMBER,
94 last_update_date DATE,
95 last_updated_by NUMBER,
96 last_update_login NUMBER,
97 object_version_number NUMBER,
98 context VARCHAR2(30),
99 attribute1 VARCHAR2(240),
100 attribute2 VARCHAR2(240),
101 attribute3 VARCHAR2(240),
102 attribute4 VARCHAR2(240),
103 attribute5 VARCHAR2(240),
104 attribute6 VARCHAR2(240),
105 attribute7 VARCHAR2(240),
106 attribute8 VARCHAR2(240),
107 attribute9 VARCHAR2(240),
108 attribute10 VARCHAR2(240),
109 attribute11 VARCHAR2(240),
110 attribute12 VARCHAR2(240),
111 attribute13 VARCHAR2(240),
112 attribute14 VARCHAR2(240),
113 attribute15 VARCHAR2(240),
114 offer_id NUMBER
115 );
116
117 g_miss_ozf_offer_line_rec ozf_offer_line_rec_type := NULL;
118 TYPE ozf_offer_line_tbl_type IS TABLE OF ozf_offer_line_rec_type INDEX BY BINARY_INTEGER;
119 g_miss_ozf_offer_line_tbl ozf_offer_line_tbl_type;
120
121 TYPE ozf_offer_tier_rec_type IS RECORD
122 (
123 offer_discount_line_id NUMBER,
124 parent_discount_line_id NUMBER,
125 offer_id NUMBER,
126 volume_from NUMBER,
127 volume_to NUMBER,
128 volume_operator VARCHAR2(30),
129 volume_type VARCHAR2(30),
130 volume_break_type VARCHAR2(30),
131 discount NUMBER,
132 discount_type VARCHAR2(30),
133 start_date_active DATE,
134 end_date_active DATE,
135 uom_code VARCHAR2(30),
136 object_version_number NUMBER,
137 context VARCHAR2(30),
138 attribute1 VARCHAR2(240),
139 attribute2 VARCHAR2(240),
140 attribute3 VARCHAR2(240),
141 attribute4 VARCHAR2(240),
142 attribute5 VARCHAR2(240),
143 attribute6 VARCHAR2(240),
144 attribute7 VARCHAR2(240),
145 attribute8 VARCHAR2(240),
146 attribute9 VARCHAR2(240),
147 attribute10 VARCHAR2(240),
148 attribute11 VARCHAR2(240),
149 attribute12 VARCHAR2(240),
150 attribute13 VARCHAR2(240),
151 attribute14 VARCHAR2(240),
152 attribute15 VARCHAR2(240)
153 );
154
155
156 /* tier_type VARCHAR2(10),
157 tier_level VARCHAR2(10),
158 offer_id NUMBER
159 */
160
161 g_miss_ozf_offer_tier_rec ozf_offer_tier_rec_type := NULL;
162 TYPE ozf_offer_tier_tbl_type IS TABLE OF ozf_offer_tier_rec_type INDEX BY BINARY_INTEGER;
163 g_miss_ozf_offer_tier_tbl ozf_offer_tier_tbl_type;
164
165
166
167
168 --===================================================================
169 -- Start of Comments
170 -- -------------------------------------------------------
171 -- Record name
172 -- ozf_prod_rec_type
173 -- -------------------------------------------------------
174 -- Parameters:
175 -- off_discount_product_id
176 -- product_level
177 -- product_id
178 -- excluder_flag
179 -- uom_code
180 -- start_date_active
181 -- end_date_active
182 -- offer_discount_line_id
183 -- offer_id
184 -- creation_date
185 -- created_by
186 -- last_update_date
187 -- last_updated_by
188 -- last_update_login
189 -- object_version_number
190 --
191 -- Required
192 --
193 -- Defaults
194 --
195 -- Note: This is automatic generated record definition, it includes all columns
196 -- defined in the table, developer must manually add or delete some of the attributes.
197 --
198 -- End of Comments
199
200 --===================================================================
201
202 TYPE ozf_discount_line_rec_type IS RECORD
203 (
204 offer_discount_line_id NUMBER,
205 parent_discount_line_id NUMBER,
206 volume_from NUMBER,
207 volume_to NUMBER,
208 volume_operator VARCHAR2(30),
209 volume_type VARCHAR2(30),
210 volume_break_type VARCHAR2(30),
211 discount NUMBER,
212 discount_type VARCHAR2(30),
213 tier_type VARCHAR2(30),
214 tier_level VARCHAR2(30),
215 incompatibility_group VARCHAR2(30),
216 precedence NUMBER,
217 bucket VARCHAR2(30),
218 scan_value NUMBER,
219 scan_data_quantity NUMBER,
220 scan_unit_forecast NUMBER,
221 channel_id NUMBER,
222 adjustment_flag VARCHAR2(1),
223 start_date_active DATE,
224 end_date_active DATE,
225 uom_code VARCHAR2(30),
226 creation_date DATE,
227 created_by NUMBER,
228 last_update_date DATE,
229 last_updated_by NUMBER,
230 last_update_login NUMBER,
231 object_version_number NUMBER,
232 offer_id NUMBER,
233 off_discount_product_id NUMBER,
234 parent_off_disc_prod_id NUMBER,
235 product_level VARCHAR2(30),
236 product_id NUMBER,
237 excluder_flag VARCHAR2(1),
238 context VARCHAR2(30),
239 attribute1 VARCHAR2(240),
240 attribute2 VARCHAR2(240),
241 attribute3 VARCHAR2(240),
242 attribute4 VARCHAR2(240),
243 attribute5 VARCHAR2(240),
244 attribute6 VARCHAR2(240),
245 attribute7 VARCHAR2(240),
246 attribute8 VARCHAR2(240),
247 attribute9 VARCHAR2(240),
248 attribute10 VARCHAR2(240),
249 attribute11 VARCHAR2(240),
250 attribute12 VARCHAR2(240),
251 attribute13 VARCHAR2(240),
252 attribute14 VARCHAR2(240),
253 attribute15 VARCHAR2(240)
254 );
255
256 TYPE ozf_discount_line_tbl IS TABLE OF ozf_discount_line_rec_type INDEX BY BINARY_INTEGER;
257
258
259
260
261 TYPE ozf_prod_rec_type IS RECORD
262 (
263 off_discount_product_id NUMBER,
264 parent_off_disc_prod_id NUMBER,
265 product_level VARCHAR2(30),
266 product_id NUMBER,
267 excluder_flag VARCHAR2(1),
268 uom_code VARCHAR2(30),
269 start_date_active DATE,
270 end_date_active DATE,
271 offer_discount_line_id NUMBER,
272 offer_id NUMBER,
273 creation_date DATE,
274 created_by NUMBER,
275 last_update_date DATE,
276 last_updated_by NUMBER,
277 last_update_login NUMBER,
278 object_version_number NUMBER
279 );
280 g_miss_ozf_prod_rec ozf_prod_rec_type := NULL;
281 TYPE prod_rec_tbl_type IS TABLE OF ozf_prod_rec_type INDEX BY BINARY_INTEGER;
282
283
284 TYPE ozf_excl_rec_type IS RECORD
285 (
286 off_discount_product_id NUMBER,
287 parent_off_disc_prod_id NUMBER,
288 product_level VARCHAR2(30),
289 product_id NUMBER,
290 object_version_number NUMBER,
291 start_date_active DATE,
292 end_date_active DATE
293 );
294 g_miss_ozf_excl_rec ozf_excl_rec_type := NULL;
295 TYPE excl_rec_tbl_type IS TABLE OF ozf_excl_rec_type INDEX BY BINARY_INTEGER;
296
297
298
299 --g_miss_prod_rec_tbl prod_reln_tbl_type;
300
301
302 --===================================================================
303 -- Start of Comments
304 -- -------------------------------------------------------
305 -- Record name
306 -- prod_reln_rec_type
307 -- -------------------------------------------------------
308 -- Parameters:
309 -- discount_product_reln_id
310 -- offer_discount_line_id
311 -- off_discount_product_id
312 -- creation_date
313 -- created_by
314 -- last_update_date
315 -- last_updated_by
316 -- last_update_login
317 -- object_version_number
318 --
319 -- Required
320 --
321 -- Defaults
322 --
323 -- Note: This is automatic generated record definition, it includes all columns
324 -- defined in the table, developer must manually add or delete some of the attributes.
325 --
326 -- End of Comments
327
328 --===================================================================
329 TYPE prod_reln_rec_type IS RECORD
330 (
331 discount_product_reln_id NUMBER,
332 offer_discount_line_id NUMBER,
333 off_discount_product_id NUMBER,
334 creation_date DATE,
335 created_by NUMBER,
336 last_update_date DATE,
337 last_updated_by NUMBER,
338 last_update_login NUMBER,
339 object_version_number NUMBER
340 );
341
342 g_miss_prod_reln_rec prod_reln_rec_type := NULL;
343 TYPE prod_reln_tbl_type IS TABLE OF prod_reln_rec_type INDEX BY BINARY_INTEGER;
344 g_miss_prod_reln_tbl prod_reln_tbl_type;
345
346
347
348
349
350
351
352 -- ==============================================================================
353 -- Start of Comments
354 -- ==============================================================================
355 -- API Name
356 -- Delete_Product
357 -- Type
358 -- Private
359 -- Pre-Req
360 -- Delete_Relation,OZF_Create_Ozf_Prod_Line_PKG.Delete_product
361 -- Parameters
362 --
363 -- IN
364 -- p_api_version_number IN NUMBER Required
365 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
369 --
366 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
367 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
368 -- p_offer_discount_line_id IN NUMBER Required All the products attached to this discount line will be deleted
370 -- OUT
371 -- x_return_status OUT VARCHAR2
372 -- x_msg_count OUT NUMBER
373 -- x_msg_data OUT VARCHAR2
374 -- Version : Current version 1.0
375 --
376 -- History
377 -- Wed Oct 01 2003:5/21 PM RSSHARMA Created
378 --
379 -- Description
380 -- : Helper method to Hard Delete All the Products for a given discount line
381 -- End of Comments
382 -- ==============================================================================
383
384 PROCEDURE Delete_Product(
385 p_api_version_number IN NUMBER,
386 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
387 p_commit IN VARCHAR2 := FND_API.G_FALSE,
388 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
389 x_return_status OUT NOCOPY VARCHAR2,
390 x_msg_count OUT NOCOPY NUMBER,
391 x_msg_data OUT NOCOPY VARCHAR2,
392 p_offer_discount_line_id IN NUMBER
393 );
394
395 -- ==============================================================================
396 -- Start of Comments
397 -- ==============================================================================
398 -- API Name
399 -- Delete_Offer_line
400 -- Type
401 -- Private
402 -- Pre-Req
403 -- Delete_Product,delete_Ozf_Disc_Line
404 -- Parameters
405 --
406 -- IN
407 -- p_api_version_number IN NUMBER Required
408 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
409 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
410 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
411 -- p_offer_discount_line_id IN NUMBER Required Discount Line id to be deleted
412 -- p_object_version_number IN NUMBER Required Object Version No. Of Discount Line to be deleted
413 --
414 -- OUT
415 -- x_return_status OUT VARCHAR2
416 -- x_msg_count OUT NUMBER
417 -- x_msg_data OUT VARCHAR2
418 -- x_off_discount_product_id OUT NUMBER
419 -- Version : Current version 1.0
420 --
421 -- History
422 -- Wed Oct 01 2003:5/21 PM RSSHARMA Created
423 --
424 -- Description
425 -- : Helper method to Hard Delete a Discount Line and all the Related Product Lines and relations.
426 -- End of Comments
427 -- ==============================================================================
428
429 PROCEDURE Delete_offer_line(
430 p_api_version_number IN NUMBER,
431 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
432 p_commit IN VARCHAR2 := FND_API.G_FALSE,
433 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
434
435 x_return_status OUT NOCOPY VARCHAR2,
436 x_msg_count OUT NOCOPY NUMBER,
437 x_msg_data OUT NOCOPY VARCHAR2,
438
439 p_offer_discount_line_id IN NUMBER,
440 p_object_version_number IN NUMBER
441 );
442
443
444 -- ==============================================================================
445 -- Start of Comments
446 -- ==============================================================================
447 -- API Name
448 -- Create_discount_line
449 -- Type
450 -- Private
451 -- Pre-Req
452 -- Create_Ozf_Disc_Line,Create Product
453 -- Parameters
454 --
455 -- IN
456 -- p_api_version_number IN NUMBER Required
457 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
458 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
459 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
460 -- p_ozf_offer_line_rec IN ozf_offer_line_rec_type Required Record containing Discount Line Data
461 -- p_ozf_prod_rec IN ozf_prod_rec_type Required Record containing Product Data
462 -- OUT
463 -- x_return_status OUT VARCHAR2
464 -- x_msg_count OUT NUMBER
465 -- x_msg_data OUT VARCHAR2
466 -- x_offer_discount_line_id OUT NUMBER. Discount Line Id of Discount Line Created
467 -- Version : Current version 1.0
468 --
469 -- History
470 -- Wed Oct 01 2003:5/21 PM RSSHARMA Created
471 --
472 -- Description
473 -- : Method to Create New Discount Lines.
474 -- End of Comments
475 -- ==============================================================================
476
477 PROCEDURE Create_discount_line(
478 p_api_version_number IN NUMBER,
479 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
480 p_commit IN VARCHAR2 := FND_API.G_FALSE,
484 x_msg_count OUT NOCOPY NUMBER,
481 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482
483 x_return_status OUT NOCOPY VARCHAR2,
485 x_msg_data OUT NOCOPY VARCHAR2,
486
487 p_ozf_discount_line_rec IN ozf_discount_line_rec_type ,
488 x_offer_discount_line_id OUT NOCOPY NUMBER
489 );
490
491
492 -- ==============================================================================
493 -- Start of Comments
494 -- ==============================================================================
495 -- API Name
496 -- Update_discount_line
497 -- Type
498 -- Private
499 -- Pre-Req
500 -- Create_Ozf_Disc_Line,Create Product
501 -- Parameters
502 --
503 -- IN
504 -- p_api_version_number IN NUMBER Required
505 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
506 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
507 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
508 -- p_ozf_discount_line_rec IN ozf_discount_line_rec_type Required Record Containing Discount Line Data
509 -- x_return_status OUT VARCHAR2
510 -- x_msg_count OUT NUMBER
511 -- x_msg_data OUT VARCHAR2
512 -- Version : Current version 1.0
513 --
514 -- History
515 -- Wed Oct 01 2003:5/21 PM RSSHARMA Created
516 --
517 -- Description
518 -- : Method to Update Discount Lines.
519 -- End of Comments
520 -- ==============================================================================
521 PROCEDURE Update_discount_line(
522 p_api_version_number IN NUMBER,
523 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
524 p_commit IN VARCHAR2 := FND_API.G_FALSE,
525 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
526
527 x_return_status OUT NOCOPY VARCHAR2,
528 x_msg_count OUT NOCOPY NUMBER,
529 x_msg_data OUT NOCOPY VARCHAR2,
530
531 p_ozf_discount_line_rec IN ozf_discount_line_rec_type
532 );
533
534
535
536 -- ==============================================================================
537 -- Start of Comments
538 -- ==============================================================================
539 -- API Name
540 -- Create_Product_Exclusion
541 -- Type
542 -- Private
543 -- Pre-Req
544 -- Create_Product
545 -- Parameters
546 --
547 -- IN
548 -- p_api_version_number IN NUMBER Required
549 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
550 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
551 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
552 -- p_ozf_prod_rec IN ozf_prod_rec_type Required
553 --
554 -- OUT
555 -- x_return_status OUT VARCHAR2
556 -- x_msg_count OUT NUMBER
557 -- x_msg_data OUT VARCHAR2
558 -- x_off_discount_product_id OUT NUMBER
559 -- Version : Current version 1.0
560 --
561 -- History
562 -- Wed Oct 01 2003:5/21 PM RSSHARMA Created
563 --
564 -- Description
565 -- : Helper method to create Exclusions for Discount Lines.
566 -- Does the following validations
567 -- 1)if excluder flag is not Y then it is set to Y
568 -- 2)If parent_off_disc_prod_id should not be null
569 -- 3)If parent_off_disc_prod_id should be a valid off_discount_product_id for the same offer
570 -- End of Comments
571 -- ==============================================================================
572
573 PROCEDURE Create_Product_Exclusion
574 (
575 p_api_version_number IN NUMBER,
576 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
577 p_commit IN VARCHAR2 := FND_API.G_FALSE,
578 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
579
580 x_return_status OUT NOCOPY VARCHAR2,
581 x_msg_count OUT NOCOPY NUMBER,
582 x_msg_data OUT NOCOPY VARCHAR2,
583
584 p_ozf_excl_rec IN ozf_excl_rec_type ,
585 x_off_discount_product_id OUT NOCOPY NUMBER
586 );
587
588 -- ==============================================================================
589 -- Start of Comments
590 -- ==============================================================================
591 -- API Name
592 -- Update_Product_Exclusion
593 -- Type
594 -- Private
595 -- Pre-Req
596 -- Create_Product
597 -- Parameters
598 --
599 -- IN
600 -- p_api_version_number IN NUMBER Required
601 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
602 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
606 -- OUT
603 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
604 -- p_ozf_prod_rec IN ozf_prod_rec_type Required
605 --
607 -- x_return_status OUT VARCHAR2
608 -- x_msg_count OUT NUMBER
609 -- x_msg_data OUT VARCHAR2
610 -- Version : Current version 1.0
611 --
612 -- History
613 -- Wed Oct 01 2003:5/21 PM RSSHARMA Created
614 --
615 -- Description
616 -- : Helper method to Update Exclusions for Discount Lines.
617 -- Does the following validations
618 -- 1)if excluder flag is not Y then Raises Error message saying the line is not an exclusion line.
619 -- Use Update Discount Lines to Update normal Discount lines
620 -- End of Comments
621 -- ==============================================================================
622
623 PROCEDURE Update_Product_Exclusion(
624 p_api_version_number IN NUMBER,
625 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
626 p_commit IN VARCHAR2 := FND_API.G_FALSE,
627 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
628
629 x_return_status OUT NOCOPY VARCHAR2,
630 x_msg_count OUT NOCOPY NUMBER,
631 x_msg_data OUT NOCOPY VARCHAR2,
632
633 p_ozf_excl_rec IN ozf_excl_rec_type
634 );
635
636
637 PROCEDURE Create_Disc_Tiers(
638 p_api_version_number IN NUMBER,
639 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
640 p_commit IN VARCHAR2 := FND_API.G_FALSE,
641 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
642
643 x_return_status OUT NOCOPY VARCHAR2,
644 x_msg_count OUT NOCOPY NUMBER,
645 x_msg_data OUT NOCOPY VARCHAR2,
646
647 p_tier_rec IN ozf_offer_tier_rec_type ,
648 x_offer_discount_line_id OUT NOCOPY NUMBER
649 );
650
651 PROCEDURE Update_Disc_Tiers(
652 p_api_version_number IN NUMBER,
653 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
654 p_commit IN VARCHAR2 := FND_API.G_FALSE,
655 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
656
657 x_return_status OUT NOCOPY VARCHAR2,
658 x_msg_count OUT NOCOPY NUMBER,
659 x_msg_data OUT NOCOPY VARCHAR2,
660
661 p_tier_rec IN ozf_offer_tier_rec_type
662 );
663
664 PROCEDURE Delete_Disc_tiers(
665 p_api_version_number IN NUMBER,
666 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
667 p_commit IN VARCHAR2 := FND_API.G_FALSE,
668 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
669
670 x_return_status OUT NOCOPY VARCHAR2,
671 x_msg_count OUT NOCOPY NUMBER,
672 x_msg_data OUT NOCOPY VARCHAR2,
673
674 p_parent_discount_line_id IN NUMBER
675 );
676 PROCEDURE Delete_Tier_line(
677 p_api_version_number IN NUMBER,
678 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
679 p_commit IN VARCHAR2 := FND_API.G_FALSE,
680 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
681
682 x_return_status OUT NOCOPY VARCHAR2,
683 x_msg_count OUT NOCOPY NUMBER,
684 x_msg_data OUT NOCOPY VARCHAR2,
685
686 p_offer_discount_line_id IN NUMBER,
687 p_object_version_number IN NUMBER
688 );
689
690
691 PROCEDURE Create_Ozf_Prod_Line(
692 p_api_version_number IN NUMBER,
693 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
694 p_commit IN VARCHAR2 := FND_API.G_FALSE,
695 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
696
697 x_return_status OUT NOCOPY VARCHAR2,
698 x_msg_count OUT NOCOPY NUMBER,
699 x_msg_data OUT NOCOPY VARCHAR2,
700
701 p_ozf_prod_rec IN ozf_prod_rec_type ,
702 x_off_discount_product_id OUT NOCOPY NUMBER
703 );
704
705 PROCEDURE Update_Ozf_Prod_Line(
706 p_api_version_number IN NUMBER,
707 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
708 p_commit IN VARCHAR2 := FND_API.G_FALSE,
709 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
710
711 x_return_status OUT NOCOPY VARCHAR2,
712 x_msg_count OUT NOCOPY NUMBER,
713 x_msg_data OUT NOCOPY VARCHAR2,
714
715 p_ozf_prod_rec IN ozf_prod_rec_type
716 );
717
718 PROCEDURE Delete_Ozf_Prod_Line(
719 p_api_version_number IN NUMBER,
720 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
721 p_commit IN VARCHAR2 := FND_API.G_FALSE,
722 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
723 x_return_status OUT NOCOPY VARCHAR2,
724 x_msg_count OUT NOCOPY NUMBER,
725 x_msg_data OUT NOCOPY VARCHAR2,
726 p_off_discount_product_id IN NUMBER,
727 p_object_version_number IN NUMBER
728 );
729
730
731 END OZF_Disc_Line_PVT;
732
733