APPS.OZF_VOLUME_OFFER_DISC_PVT_W dependencies on FND_API

Line 9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as

Line 14: a number := fnd_api.g_miss_num;

10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;

Line 603: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

599: , p7_a0 NUMBER := 0-1962.0724
600: , p7_a1 NUMBER := 0-1962.0724
601: , p7_a2 NUMBER := 0-1962.0724
602: , p7_a3 NUMBER := 0-1962.0724
603: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
604: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
605: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
606: , p7_a7 NUMBER := 0-1962.0724
607: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

Line 604: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

600: , p7_a1 NUMBER := 0-1962.0724
601: , p7_a2 NUMBER := 0-1962.0724
602: , p7_a3 NUMBER := 0-1962.0724
603: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
604: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
605: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
606: , p7_a7 NUMBER := 0-1962.0724
607: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
608: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

Line 605: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

601: , p7_a2 NUMBER := 0-1962.0724
602: , p7_a3 NUMBER := 0-1962.0724
603: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
604: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
605: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
606: , p7_a7 NUMBER := 0-1962.0724
607: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
608: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
609: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

Line 607: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

603: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
604: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
605: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
606: , p7_a7 NUMBER := 0-1962.0724
607: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
608: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
609: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
610: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
611: , p7_a12 NUMBER := 0-1962.0724

Line 608: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

604: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
605: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
606: , p7_a7 NUMBER := 0-1962.0724
607: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
608: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
609: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
610: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
611: , p7_a12 NUMBER := 0-1962.0724
612: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 609: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

605: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
606: , p7_a7 NUMBER := 0-1962.0724
607: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
608: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
609: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
610: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
611: , p7_a12 NUMBER := 0-1962.0724
612: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
613: , p7_a14 NUMBER := 0-1962.0724

Line 610: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

606: , p7_a7 NUMBER := 0-1962.0724
607: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
608: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
609: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
610: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
611: , p7_a12 NUMBER := 0-1962.0724
612: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
613: , p7_a14 NUMBER := 0-1962.0724
614: , p7_a15 NUMBER := 0-1962.0724

Line 612: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

608: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
609: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
610: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
611: , p7_a12 NUMBER := 0-1962.0724
612: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
613: , p7_a14 NUMBER := 0-1962.0724
614: , p7_a15 NUMBER := 0-1962.0724
615: , p7_a16 NUMBER := 0-1962.0724
616: , p7_a17 NUMBER := 0-1962.0724

Line 617: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

613: , p7_a14 NUMBER := 0-1962.0724
614: , p7_a15 NUMBER := 0-1962.0724
615: , p7_a16 NUMBER := 0-1962.0724
616: , p7_a17 NUMBER := 0-1962.0724
617: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
618: , p7_a19 DATE := fnd_api.g_miss_date
619: , p7_a20 DATE := fnd_api.g_miss_date
620: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
621: , p7_a22 DATE := fnd_api.g_miss_date

Line 618: , p7_a19 DATE := fnd_api.g_miss_date

614: , p7_a15 NUMBER := 0-1962.0724
615: , p7_a16 NUMBER := 0-1962.0724
616: , p7_a17 NUMBER := 0-1962.0724
617: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
618: , p7_a19 DATE := fnd_api.g_miss_date
619: , p7_a20 DATE := fnd_api.g_miss_date
620: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
621: , p7_a22 DATE := fnd_api.g_miss_date
622: , p7_a23 NUMBER := 0-1962.0724

Line 619: , p7_a20 DATE := fnd_api.g_miss_date

615: , p7_a16 NUMBER := 0-1962.0724
616: , p7_a17 NUMBER := 0-1962.0724
617: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
618: , p7_a19 DATE := fnd_api.g_miss_date
619: , p7_a20 DATE := fnd_api.g_miss_date
620: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
621: , p7_a22 DATE := fnd_api.g_miss_date
622: , p7_a23 NUMBER := 0-1962.0724
623: , p7_a24 DATE := fnd_api.g_miss_date

Line 620: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

616: , p7_a17 NUMBER := 0-1962.0724
617: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
618: , p7_a19 DATE := fnd_api.g_miss_date
619: , p7_a20 DATE := fnd_api.g_miss_date
620: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
621: , p7_a22 DATE := fnd_api.g_miss_date
622: , p7_a23 NUMBER := 0-1962.0724
623: , p7_a24 DATE := fnd_api.g_miss_date
624: , p7_a25 NUMBER := 0-1962.0724

Line 621: , p7_a22 DATE := fnd_api.g_miss_date

617: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
618: , p7_a19 DATE := fnd_api.g_miss_date
619: , p7_a20 DATE := fnd_api.g_miss_date
620: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
621: , p7_a22 DATE := fnd_api.g_miss_date
622: , p7_a23 NUMBER := 0-1962.0724
623: , p7_a24 DATE := fnd_api.g_miss_date
624: , p7_a25 NUMBER := 0-1962.0724
625: , p7_a26 NUMBER := 0-1962.0724

Line 623: , p7_a24 DATE := fnd_api.g_miss_date

619: , p7_a20 DATE := fnd_api.g_miss_date
620: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
621: , p7_a22 DATE := fnd_api.g_miss_date
622: , p7_a23 NUMBER := 0-1962.0724
623: , p7_a24 DATE := fnd_api.g_miss_date
624: , p7_a25 NUMBER := 0-1962.0724
625: , p7_a26 NUMBER := 0-1962.0724
626: , p7_a27 NUMBER := 0-1962.0724
627: , p7_a28 NUMBER := 0-1962.0724

Line 628: , p7_a29 VARCHAR2 := fnd_api.g_miss_char

624: , p7_a25 NUMBER := 0-1962.0724
625: , p7_a26 NUMBER := 0-1962.0724
626: , p7_a27 NUMBER := 0-1962.0724
627: , p7_a28 NUMBER := 0-1962.0724
628: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
629: , p7_a30 NUMBER := 0-1962.0724
630: , p7_a31 NUMBER := 0-1962.0724
631: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
632: , p7_a33 VARCHAR2 := fnd_api.g_miss_char

Line 631: , p7_a32 VARCHAR2 := fnd_api.g_miss_char

627: , p7_a28 NUMBER := 0-1962.0724
628: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
629: , p7_a30 NUMBER := 0-1962.0724
630: , p7_a31 NUMBER := 0-1962.0724
631: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
632: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
633: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
634: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
635: , p7_a36 VARCHAR2 := fnd_api.g_miss_char

Line 632: , p7_a33 VARCHAR2 := fnd_api.g_miss_char

628: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
629: , p7_a30 NUMBER := 0-1962.0724
630: , p7_a31 NUMBER := 0-1962.0724
631: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
632: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
633: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
634: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
635: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
636: , p7_a37 VARCHAR2 := fnd_api.g_miss_char

Line 633: , p7_a34 VARCHAR2 := fnd_api.g_miss_char

629: , p7_a30 NUMBER := 0-1962.0724
630: , p7_a31 NUMBER := 0-1962.0724
631: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
632: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
633: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
634: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
635: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
636: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a38 VARCHAR2 := fnd_api.g_miss_char

Line 634: , p7_a35 VARCHAR2 := fnd_api.g_miss_char

630: , p7_a31 NUMBER := 0-1962.0724
631: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
632: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
633: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
634: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
635: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
636: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
638: , p7_a39 VARCHAR2 := fnd_api.g_miss_char

Line 635: , p7_a36 VARCHAR2 := fnd_api.g_miss_char

631: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
632: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
633: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
634: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
635: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
636: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
638: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
639: , p7_a40 VARCHAR2 := fnd_api.g_miss_char

Line 636: , p7_a37 VARCHAR2 := fnd_api.g_miss_char

632: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
633: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
634: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
635: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
636: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
638: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
639: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
640: , p7_a41 VARCHAR2 := fnd_api.g_miss_char

Line 637: , p7_a38 VARCHAR2 := fnd_api.g_miss_char

633: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
634: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
635: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
636: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
638: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
639: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
640: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
641: , p7_a42 VARCHAR2 := fnd_api.g_miss_char

Line 638: , p7_a39 VARCHAR2 := fnd_api.g_miss_char

634: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
635: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
636: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
638: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
639: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
640: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
641: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
642: , p7_a43 VARCHAR2 := fnd_api.g_miss_char

Line 639: , p7_a40 VARCHAR2 := fnd_api.g_miss_char

635: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
636: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
638: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
639: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
640: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
641: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
642: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
643: , p7_a44 VARCHAR2 := fnd_api.g_miss_char

Line 640: , p7_a41 VARCHAR2 := fnd_api.g_miss_char

636: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
638: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
639: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
640: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
641: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
642: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
643: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
644: , p7_a45 VARCHAR2 := fnd_api.g_miss_char

Line 641: , p7_a42 VARCHAR2 := fnd_api.g_miss_char

637: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
638: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
639: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
640: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
641: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
642: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
643: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
644: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
645: , p7_a46 VARCHAR2 := fnd_api.g_miss_char

Line 642: , p7_a43 VARCHAR2 := fnd_api.g_miss_char

638: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
639: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
640: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
641: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
642: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
643: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
644: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
645: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
646: , p7_a47 VARCHAR2 := fnd_api.g_miss_char

Line 643: , p7_a44 VARCHAR2 := fnd_api.g_miss_char

639: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
640: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
641: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
642: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
643: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
644: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
645: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
646: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
647: , p7_a48 VARCHAR2 := fnd_api.g_miss_char

Line 644: , p7_a45 VARCHAR2 := fnd_api.g_miss_char

640: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
641: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
642: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
643: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
644: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
645: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
646: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
647: , p7_a48 VARCHAR2 := fnd_api.g_miss_char
648: , p7_a49 VARCHAR2 := fnd_api.g_miss_char

Line 645: , p7_a46 VARCHAR2 := fnd_api.g_miss_char

641: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
642: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
643: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
644: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
645: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
646: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
647: , p7_a48 VARCHAR2 := fnd_api.g_miss_char
648: , p7_a49 VARCHAR2 := fnd_api.g_miss_char
649: )

Line 646: , p7_a47 VARCHAR2 := fnd_api.g_miss_char

642: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
643: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
644: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
645: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
646: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
647: , p7_a48 VARCHAR2 := fnd_api.g_miss_char
648: , p7_a49 VARCHAR2 := fnd_api.g_miss_char
649: )
650:

Line 647: , p7_a48 VARCHAR2 := fnd_api.g_miss_char

643: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
644: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
645: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
646: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
647: , p7_a48 VARCHAR2 := fnd_api.g_miss_char
648: , p7_a49 VARCHAR2 := fnd_api.g_miss_char
649: )
650:
651: as

Line 648: , p7_a49 VARCHAR2 := fnd_api.g_miss_char

644: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
645: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
646: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
647: , p7_a48 VARCHAR2 := fnd_api.g_miss_char
648: , p7_a49 VARCHAR2 := fnd_api.g_miss_char
649: )
650:
651: as
652: ddp_vo_disc_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;

Line 749: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

745: , p7_a0 NUMBER := 0-1962.0724
746: , p7_a1 NUMBER := 0-1962.0724
747: , p7_a2 NUMBER := 0-1962.0724
748: , p7_a3 NUMBER := 0-1962.0724
749: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
750: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
751: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
752: , p7_a7 NUMBER := 0-1962.0724
753: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

Line 750: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

746: , p7_a1 NUMBER := 0-1962.0724
747: , p7_a2 NUMBER := 0-1962.0724
748: , p7_a3 NUMBER := 0-1962.0724
749: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
750: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
751: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
752: , p7_a7 NUMBER := 0-1962.0724
753: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
754: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

Line 751: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

747: , p7_a2 NUMBER := 0-1962.0724
748: , p7_a3 NUMBER := 0-1962.0724
749: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
750: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
751: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
752: , p7_a7 NUMBER := 0-1962.0724
753: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
754: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
755: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

Line 753: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

749: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
750: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
751: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
752: , p7_a7 NUMBER := 0-1962.0724
753: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
754: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
755: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
756: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
757: , p7_a12 NUMBER := 0-1962.0724

Line 754: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

750: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
751: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
752: , p7_a7 NUMBER := 0-1962.0724
753: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
754: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
755: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
756: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
757: , p7_a12 NUMBER := 0-1962.0724
758: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 755: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

751: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
752: , p7_a7 NUMBER := 0-1962.0724
753: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
754: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
755: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
756: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
757: , p7_a12 NUMBER := 0-1962.0724
758: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
759: , p7_a14 NUMBER := 0-1962.0724

Line 756: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

752: , p7_a7 NUMBER := 0-1962.0724
753: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
754: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
755: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
756: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
757: , p7_a12 NUMBER := 0-1962.0724
758: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
759: , p7_a14 NUMBER := 0-1962.0724
760: , p7_a15 NUMBER := 0-1962.0724

Line 758: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

754: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
755: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
756: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
757: , p7_a12 NUMBER := 0-1962.0724
758: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
759: , p7_a14 NUMBER := 0-1962.0724
760: , p7_a15 NUMBER := 0-1962.0724
761: , p7_a16 NUMBER := 0-1962.0724
762: , p7_a17 NUMBER := 0-1962.0724

Line 763: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

759: , p7_a14 NUMBER := 0-1962.0724
760: , p7_a15 NUMBER := 0-1962.0724
761: , p7_a16 NUMBER := 0-1962.0724
762: , p7_a17 NUMBER := 0-1962.0724
763: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
764: , p7_a19 DATE := fnd_api.g_miss_date
765: , p7_a20 DATE := fnd_api.g_miss_date
766: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
767: , p7_a22 DATE := fnd_api.g_miss_date

Line 764: , p7_a19 DATE := fnd_api.g_miss_date

760: , p7_a15 NUMBER := 0-1962.0724
761: , p7_a16 NUMBER := 0-1962.0724
762: , p7_a17 NUMBER := 0-1962.0724
763: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
764: , p7_a19 DATE := fnd_api.g_miss_date
765: , p7_a20 DATE := fnd_api.g_miss_date
766: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
767: , p7_a22 DATE := fnd_api.g_miss_date
768: , p7_a23 NUMBER := 0-1962.0724

Line 765: , p7_a20 DATE := fnd_api.g_miss_date

761: , p7_a16 NUMBER := 0-1962.0724
762: , p7_a17 NUMBER := 0-1962.0724
763: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
764: , p7_a19 DATE := fnd_api.g_miss_date
765: , p7_a20 DATE := fnd_api.g_miss_date
766: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
767: , p7_a22 DATE := fnd_api.g_miss_date
768: , p7_a23 NUMBER := 0-1962.0724
769: , p7_a24 DATE := fnd_api.g_miss_date

Line 766: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

762: , p7_a17 NUMBER := 0-1962.0724
763: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
764: , p7_a19 DATE := fnd_api.g_miss_date
765: , p7_a20 DATE := fnd_api.g_miss_date
766: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
767: , p7_a22 DATE := fnd_api.g_miss_date
768: , p7_a23 NUMBER := 0-1962.0724
769: , p7_a24 DATE := fnd_api.g_miss_date
770: , p7_a25 NUMBER := 0-1962.0724

Line 767: , p7_a22 DATE := fnd_api.g_miss_date

763: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
764: , p7_a19 DATE := fnd_api.g_miss_date
765: , p7_a20 DATE := fnd_api.g_miss_date
766: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
767: , p7_a22 DATE := fnd_api.g_miss_date
768: , p7_a23 NUMBER := 0-1962.0724
769: , p7_a24 DATE := fnd_api.g_miss_date
770: , p7_a25 NUMBER := 0-1962.0724
771: , p7_a26 NUMBER := 0-1962.0724

Line 769: , p7_a24 DATE := fnd_api.g_miss_date

765: , p7_a20 DATE := fnd_api.g_miss_date
766: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
767: , p7_a22 DATE := fnd_api.g_miss_date
768: , p7_a23 NUMBER := 0-1962.0724
769: , p7_a24 DATE := fnd_api.g_miss_date
770: , p7_a25 NUMBER := 0-1962.0724
771: , p7_a26 NUMBER := 0-1962.0724
772: , p7_a27 NUMBER := 0-1962.0724
773: , p7_a28 NUMBER := 0-1962.0724

Line 774: , p7_a29 VARCHAR2 := fnd_api.g_miss_char

770: , p7_a25 NUMBER := 0-1962.0724
771: , p7_a26 NUMBER := 0-1962.0724
772: , p7_a27 NUMBER := 0-1962.0724
773: , p7_a28 NUMBER := 0-1962.0724
774: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
775: , p7_a30 NUMBER := 0-1962.0724
776: , p7_a31 NUMBER := 0-1962.0724
777: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
778: , p7_a33 VARCHAR2 := fnd_api.g_miss_char

Line 777: , p7_a32 VARCHAR2 := fnd_api.g_miss_char

773: , p7_a28 NUMBER := 0-1962.0724
774: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
775: , p7_a30 NUMBER := 0-1962.0724
776: , p7_a31 NUMBER := 0-1962.0724
777: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
778: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
779: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
780: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
781: , p7_a36 VARCHAR2 := fnd_api.g_miss_char

Line 778: , p7_a33 VARCHAR2 := fnd_api.g_miss_char

774: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
775: , p7_a30 NUMBER := 0-1962.0724
776: , p7_a31 NUMBER := 0-1962.0724
777: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
778: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
779: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
780: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
781: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
782: , p7_a37 VARCHAR2 := fnd_api.g_miss_char

Line 779: , p7_a34 VARCHAR2 := fnd_api.g_miss_char

775: , p7_a30 NUMBER := 0-1962.0724
776: , p7_a31 NUMBER := 0-1962.0724
777: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
778: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
779: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
780: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
781: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
782: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
783: , p7_a38 VARCHAR2 := fnd_api.g_miss_char

Line 780: , p7_a35 VARCHAR2 := fnd_api.g_miss_char

776: , p7_a31 NUMBER := 0-1962.0724
777: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
778: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
779: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
780: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
781: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
782: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
783: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
784: , p7_a39 VARCHAR2 := fnd_api.g_miss_char

Line 781: , p7_a36 VARCHAR2 := fnd_api.g_miss_char

777: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
778: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
779: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
780: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
781: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
782: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
783: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
784: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
785: , p7_a40 VARCHAR2 := fnd_api.g_miss_char

Line 782: , p7_a37 VARCHAR2 := fnd_api.g_miss_char

778: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
779: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
780: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
781: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
782: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
783: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
784: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
785: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
786: , p7_a41 VARCHAR2 := fnd_api.g_miss_char

Line 783: , p7_a38 VARCHAR2 := fnd_api.g_miss_char

779: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
780: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
781: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
782: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
783: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
784: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
785: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
786: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
787: , p7_a42 VARCHAR2 := fnd_api.g_miss_char

Line 784: , p7_a39 VARCHAR2 := fnd_api.g_miss_char

780: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
781: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
782: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
783: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
784: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
785: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
786: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
787: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
788: , p7_a43 VARCHAR2 := fnd_api.g_miss_char

Line 785: , p7_a40 VARCHAR2 := fnd_api.g_miss_char

781: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
782: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
783: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
784: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
785: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
786: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
787: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
788: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
789: , p7_a44 VARCHAR2 := fnd_api.g_miss_char

Line 786: , p7_a41 VARCHAR2 := fnd_api.g_miss_char

782: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
783: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
784: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
785: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
786: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
787: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
788: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
789: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
790: , p7_a45 VARCHAR2 := fnd_api.g_miss_char

Line 787: , p7_a42 VARCHAR2 := fnd_api.g_miss_char

783: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
784: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
785: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
786: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
787: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
788: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
789: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
790: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
791: , p7_a46 VARCHAR2 := fnd_api.g_miss_char

Line 788: , p7_a43 VARCHAR2 := fnd_api.g_miss_char

784: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
785: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
786: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
787: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
788: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
789: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
790: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
791: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
792: , p7_a47 VARCHAR2 := fnd_api.g_miss_char

Line 789: , p7_a44 VARCHAR2 := fnd_api.g_miss_char

785: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
786: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
787: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
788: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
789: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
790: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
791: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
792: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
793: , p7_a48 VARCHAR2 := fnd_api.g_miss_char

Line 790: , p7_a45 VARCHAR2 := fnd_api.g_miss_char

786: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
787: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
788: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
789: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
790: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
791: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
792: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
793: , p7_a48 VARCHAR2 := fnd_api.g_miss_char
794: , p7_a49 VARCHAR2 := fnd_api.g_miss_char

Line 791: , p7_a46 VARCHAR2 := fnd_api.g_miss_char

787: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
788: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
789: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
790: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
791: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
792: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
793: , p7_a48 VARCHAR2 := fnd_api.g_miss_char
794: , p7_a49 VARCHAR2 := fnd_api.g_miss_char
795: )

Line 792: , p7_a47 VARCHAR2 := fnd_api.g_miss_char

788: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
789: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
790: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
791: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
792: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
793: , p7_a48 VARCHAR2 := fnd_api.g_miss_char
794: , p7_a49 VARCHAR2 := fnd_api.g_miss_char
795: )
796:

Line 793: , p7_a48 VARCHAR2 := fnd_api.g_miss_char

789: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
790: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
791: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
792: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
793: , p7_a48 VARCHAR2 := fnd_api.g_miss_char
794: , p7_a49 VARCHAR2 := fnd_api.g_miss_char
795: )
796:
797: as

Line 794: , p7_a49 VARCHAR2 := fnd_api.g_miss_char

790: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
791: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
792: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
793: , p7_a48 VARCHAR2 := fnd_api.g_miss_char
794: , p7_a49 VARCHAR2 := fnd_api.g_miss_char
795: )
796:
797: as
798: ddp_vo_disc_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;

Line 890: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

886: , x_msg_count out nocopy NUMBER
887: , x_msg_data out nocopy VARCHAR2
888: , x_off_discount_product_id out nocopy NUMBER
889: , p7_a0 NUMBER := 0-1962.0724
890: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
891: , p7_a2 NUMBER := 0-1962.0724
892: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
893: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
894: , p7_a5 DATE := fnd_api.g_miss_date

Line 892: , p7_a3 VARCHAR2 := fnd_api.g_miss_char

888: , x_off_discount_product_id out nocopy NUMBER
889: , p7_a0 NUMBER := 0-1962.0724
890: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
891: , p7_a2 NUMBER := 0-1962.0724
892: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
893: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
894: , p7_a5 DATE := fnd_api.g_miss_date
895: , p7_a6 DATE := fnd_api.g_miss_date
896: , p7_a7 NUMBER := 0-1962.0724

Line 893: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

889: , p7_a0 NUMBER := 0-1962.0724
890: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
891: , p7_a2 NUMBER := 0-1962.0724
892: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
893: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
894: , p7_a5 DATE := fnd_api.g_miss_date
895: , p7_a6 DATE := fnd_api.g_miss_date
896: , p7_a7 NUMBER := 0-1962.0724
897: , p7_a8 NUMBER := 0-1962.0724

Line 894: , p7_a5 DATE := fnd_api.g_miss_date

890: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
891: , p7_a2 NUMBER := 0-1962.0724
892: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
893: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
894: , p7_a5 DATE := fnd_api.g_miss_date
895: , p7_a6 DATE := fnd_api.g_miss_date
896: , p7_a7 NUMBER := 0-1962.0724
897: , p7_a8 NUMBER := 0-1962.0724
898: , p7_a9 DATE := fnd_api.g_miss_date

Line 895: , p7_a6 DATE := fnd_api.g_miss_date

891: , p7_a2 NUMBER := 0-1962.0724
892: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
893: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
894: , p7_a5 DATE := fnd_api.g_miss_date
895: , p7_a6 DATE := fnd_api.g_miss_date
896: , p7_a7 NUMBER := 0-1962.0724
897: , p7_a8 NUMBER := 0-1962.0724
898: , p7_a9 DATE := fnd_api.g_miss_date
899: , p7_a10 NUMBER := 0-1962.0724

Line 898: , p7_a9 DATE := fnd_api.g_miss_date

894: , p7_a5 DATE := fnd_api.g_miss_date
895: , p7_a6 DATE := fnd_api.g_miss_date
896: , p7_a7 NUMBER := 0-1962.0724
897: , p7_a8 NUMBER := 0-1962.0724
898: , p7_a9 DATE := fnd_api.g_miss_date
899: , p7_a10 NUMBER := 0-1962.0724
900: , p7_a11 DATE := fnd_api.g_miss_date
901: , p7_a12 NUMBER := 0-1962.0724
902: , p7_a13 NUMBER := 0-1962.0724

Line 900: , p7_a11 DATE := fnd_api.g_miss_date

896: , p7_a7 NUMBER := 0-1962.0724
897: , p7_a8 NUMBER := 0-1962.0724
898: , p7_a9 DATE := fnd_api.g_miss_date
899: , p7_a10 NUMBER := 0-1962.0724
900: , p7_a11 DATE := fnd_api.g_miss_date
901: , p7_a12 NUMBER := 0-1962.0724
902: , p7_a13 NUMBER := 0-1962.0724
903: , p7_a14 NUMBER := 0-1962.0724
904: , p7_a15 NUMBER := 0-1962.0724

Line 905: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

901: , p7_a12 NUMBER := 0-1962.0724
902: , p7_a13 NUMBER := 0-1962.0724
903: , p7_a14 NUMBER := 0-1962.0724
904: , p7_a15 NUMBER := 0-1962.0724
905: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
906: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
907: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
908: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
909: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 906: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

902: , p7_a13 NUMBER := 0-1962.0724
903: , p7_a14 NUMBER := 0-1962.0724
904: , p7_a15 NUMBER := 0-1962.0724
905: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
906: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
907: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
908: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
909: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
910: )

Line 907: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

903: , p7_a14 NUMBER := 0-1962.0724
904: , p7_a15 NUMBER := 0-1962.0724
905: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
906: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
907: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
908: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
909: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
910: )
911:

Line 908: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

904: , p7_a15 NUMBER := 0-1962.0724
905: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
906: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
907: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
908: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
909: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
910: )
911:
912: as

Line 909: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

905: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
906: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
907: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
908: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
909: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
910: )
911:
912: as
913: ddp_vo_prod_rec ozf_volume_offer_disc_pvt.vo_prod_rec_type;

Line 978: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

974: , x_return_status out nocopy VARCHAR2
975: , x_msg_count out nocopy NUMBER
976: , x_msg_data out nocopy VARCHAR2
977: , p7_a0 NUMBER := 0-1962.0724
978: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
979: , p7_a2 NUMBER := 0-1962.0724
980: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
981: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
982: , p7_a5 DATE := fnd_api.g_miss_date

Line 980: , p7_a3 VARCHAR2 := fnd_api.g_miss_char

976: , x_msg_data out nocopy VARCHAR2
977: , p7_a0 NUMBER := 0-1962.0724
978: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
979: , p7_a2 NUMBER := 0-1962.0724
980: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
981: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
982: , p7_a5 DATE := fnd_api.g_miss_date
983: , p7_a6 DATE := fnd_api.g_miss_date
984: , p7_a7 NUMBER := 0-1962.0724

Line 981: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

977: , p7_a0 NUMBER := 0-1962.0724
978: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
979: , p7_a2 NUMBER := 0-1962.0724
980: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
981: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
982: , p7_a5 DATE := fnd_api.g_miss_date
983: , p7_a6 DATE := fnd_api.g_miss_date
984: , p7_a7 NUMBER := 0-1962.0724
985: , p7_a8 NUMBER := 0-1962.0724

Line 982: , p7_a5 DATE := fnd_api.g_miss_date

978: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
979: , p7_a2 NUMBER := 0-1962.0724
980: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
981: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
982: , p7_a5 DATE := fnd_api.g_miss_date
983: , p7_a6 DATE := fnd_api.g_miss_date
984: , p7_a7 NUMBER := 0-1962.0724
985: , p7_a8 NUMBER := 0-1962.0724
986: , p7_a9 DATE := fnd_api.g_miss_date

Line 983: , p7_a6 DATE := fnd_api.g_miss_date

979: , p7_a2 NUMBER := 0-1962.0724
980: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
981: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
982: , p7_a5 DATE := fnd_api.g_miss_date
983: , p7_a6 DATE := fnd_api.g_miss_date
984: , p7_a7 NUMBER := 0-1962.0724
985: , p7_a8 NUMBER := 0-1962.0724
986: , p7_a9 DATE := fnd_api.g_miss_date
987: , p7_a10 NUMBER := 0-1962.0724

Line 986: , p7_a9 DATE := fnd_api.g_miss_date

982: , p7_a5 DATE := fnd_api.g_miss_date
983: , p7_a6 DATE := fnd_api.g_miss_date
984: , p7_a7 NUMBER := 0-1962.0724
985: , p7_a8 NUMBER := 0-1962.0724
986: , p7_a9 DATE := fnd_api.g_miss_date
987: , p7_a10 NUMBER := 0-1962.0724
988: , p7_a11 DATE := fnd_api.g_miss_date
989: , p7_a12 NUMBER := 0-1962.0724
990: , p7_a13 NUMBER := 0-1962.0724

Line 988: , p7_a11 DATE := fnd_api.g_miss_date

984: , p7_a7 NUMBER := 0-1962.0724
985: , p7_a8 NUMBER := 0-1962.0724
986: , p7_a9 DATE := fnd_api.g_miss_date
987: , p7_a10 NUMBER := 0-1962.0724
988: , p7_a11 DATE := fnd_api.g_miss_date
989: , p7_a12 NUMBER := 0-1962.0724
990: , p7_a13 NUMBER := 0-1962.0724
991: , p7_a14 NUMBER := 0-1962.0724
992: , p7_a15 NUMBER := 0-1962.0724

Line 993: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

989: , p7_a12 NUMBER := 0-1962.0724
990: , p7_a13 NUMBER := 0-1962.0724
991: , p7_a14 NUMBER := 0-1962.0724
992: , p7_a15 NUMBER := 0-1962.0724
993: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
994: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
995: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
996: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
997: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 994: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

990: , p7_a13 NUMBER := 0-1962.0724
991: , p7_a14 NUMBER := 0-1962.0724
992: , p7_a15 NUMBER := 0-1962.0724
993: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
994: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
995: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
996: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
997: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
998: )

Line 995: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

991: , p7_a14 NUMBER := 0-1962.0724
992: , p7_a15 NUMBER := 0-1962.0724
993: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
994: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
995: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
996: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
997: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
998: )
999:

Line 996: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

992: , p7_a15 NUMBER := 0-1962.0724
993: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
994: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
995: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
996: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
997: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
998: )
999:
1000: as

Line 997: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

993: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
994: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
995: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
996: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
997: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
998: )
999:
1000: as
1001: ddp_vo_prod_rec ozf_volume_offer_disc_pvt.vo_prod_rec_type;

Line 1068: , p8_a4 VARCHAR2 := fnd_api.g_miss_char

1064: , p8_a0 NUMBER := 0-1962.0724
1065: , p8_a1 NUMBER := 0-1962.0724
1066: , p8_a2 NUMBER := 0-1962.0724
1067: , p8_a3 NUMBER := 0-1962.0724
1068: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
1069: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
1070: , p8_a6 VARCHAR2 := fnd_api.g_miss_char
1071: , p8_a7 NUMBER := 0-1962.0724
1072: , p8_a8 VARCHAR2 := fnd_api.g_miss_char

Line 1069: , p8_a5 VARCHAR2 := fnd_api.g_miss_char

1065: , p8_a1 NUMBER := 0-1962.0724
1066: , p8_a2 NUMBER := 0-1962.0724
1067: , p8_a3 NUMBER := 0-1962.0724
1068: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
1069: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
1070: , p8_a6 VARCHAR2 := fnd_api.g_miss_char
1071: , p8_a7 NUMBER := 0-1962.0724
1072: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
1073: , p8_a9 VARCHAR2 := fnd_api.g_miss_char

Line 1070: , p8_a6 VARCHAR2 := fnd_api.g_miss_char

1066: , p8_a2 NUMBER := 0-1962.0724
1067: , p8_a3 NUMBER := 0-1962.0724
1068: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
1069: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
1070: , p8_a6 VARCHAR2 := fnd_api.g_miss_char
1071: , p8_a7 NUMBER := 0-1962.0724
1072: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
1073: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
1074: , p8_a10 VARCHAR2 := fnd_api.g_miss_char

Line 1072: , p8_a8 VARCHAR2 := fnd_api.g_miss_char

1068: , p8_a4 VARCHAR2 := fnd_api.g_miss_char
1069: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
1070: , p8_a6 VARCHAR2 := fnd_api.g_miss_char
1071: , p8_a7 NUMBER := 0-1962.0724
1072: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
1073: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
1074: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
1075: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
1076: , p8_a12 NUMBER := 0-1962.0724

Line 1073: , p8_a9 VARCHAR2 := fnd_api.g_miss_char

1069: , p8_a5 VARCHAR2 := fnd_api.g_miss_char
1070: , p8_a6 VARCHAR2 := fnd_api.g_miss_char
1071: , p8_a7 NUMBER := 0-1962.0724
1072: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
1073: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
1074: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
1075: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
1076: , p8_a12 NUMBER := 0-1962.0724
1077: , p8_a13 VARCHAR2 := fnd_api.g_miss_char

Line 1074: , p8_a10 VARCHAR2 := fnd_api.g_miss_char

1070: , p8_a6 VARCHAR2 := fnd_api.g_miss_char
1071: , p8_a7 NUMBER := 0-1962.0724
1072: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
1073: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
1074: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
1075: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
1076: , p8_a12 NUMBER := 0-1962.0724
1077: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
1078: , p8_a14 NUMBER := 0-1962.0724

Line 1075: , p8_a11 VARCHAR2 := fnd_api.g_miss_char

1071: , p8_a7 NUMBER := 0-1962.0724
1072: , p8_a8 VARCHAR2 := fnd_api.g_miss_char
1073: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
1074: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
1075: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
1076: , p8_a12 NUMBER := 0-1962.0724
1077: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
1078: , p8_a14 NUMBER := 0-1962.0724
1079: , p8_a15 NUMBER := 0-1962.0724

Line 1077: , p8_a13 VARCHAR2 := fnd_api.g_miss_char

1073: , p8_a9 VARCHAR2 := fnd_api.g_miss_char
1074: , p8_a10 VARCHAR2 := fnd_api.g_miss_char
1075: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
1076: , p8_a12 NUMBER := 0-1962.0724
1077: , p8_a13 VARCHAR2 := fnd_api.g_miss_char
1078: , p8_a14 NUMBER := 0-1962.0724
1079: , p8_a15 NUMBER := 0-1962.0724
1080: , p8_a16 NUMBER := 0-1962.0724
1081: , p8_a17 NUMBER := 0-1962.0724

Line 1082: , p8_a18 VARCHAR2 := fnd_api.g_miss_char

1078: , p8_a14 NUMBER := 0-1962.0724
1079: , p8_a15 NUMBER := 0-1962.0724
1080: , p8_a16 NUMBER := 0-1962.0724
1081: , p8_a17 NUMBER := 0-1962.0724
1082: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
1083: , p8_a19 DATE := fnd_api.g_miss_date
1084: , p8_a20 DATE := fnd_api.g_miss_date
1085: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
1086: , p8_a22 DATE := fnd_api.g_miss_date

Line 1083: , p8_a19 DATE := fnd_api.g_miss_date

1079: , p8_a15 NUMBER := 0-1962.0724
1080: , p8_a16 NUMBER := 0-1962.0724
1081: , p8_a17 NUMBER := 0-1962.0724
1082: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
1083: , p8_a19 DATE := fnd_api.g_miss_date
1084: , p8_a20 DATE := fnd_api.g_miss_date
1085: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
1086: , p8_a22 DATE := fnd_api.g_miss_date
1087: , p8_a23 NUMBER := 0-1962.0724

Line 1084: , p8_a20 DATE := fnd_api.g_miss_date

1080: , p8_a16 NUMBER := 0-1962.0724
1081: , p8_a17 NUMBER := 0-1962.0724
1082: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
1083: , p8_a19 DATE := fnd_api.g_miss_date
1084: , p8_a20 DATE := fnd_api.g_miss_date
1085: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
1086: , p8_a22 DATE := fnd_api.g_miss_date
1087: , p8_a23 NUMBER := 0-1962.0724
1088: , p8_a24 DATE := fnd_api.g_miss_date

Line 1085: , p8_a21 VARCHAR2 := fnd_api.g_miss_char

1081: , p8_a17 NUMBER := 0-1962.0724
1082: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
1083: , p8_a19 DATE := fnd_api.g_miss_date
1084: , p8_a20 DATE := fnd_api.g_miss_date
1085: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
1086: , p8_a22 DATE := fnd_api.g_miss_date
1087: , p8_a23 NUMBER := 0-1962.0724
1088: , p8_a24 DATE := fnd_api.g_miss_date
1089: , p8_a25 NUMBER := 0-1962.0724

Line 1086: , p8_a22 DATE := fnd_api.g_miss_date

1082: , p8_a18 VARCHAR2 := fnd_api.g_miss_char
1083: , p8_a19 DATE := fnd_api.g_miss_date
1084: , p8_a20 DATE := fnd_api.g_miss_date
1085: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
1086: , p8_a22 DATE := fnd_api.g_miss_date
1087: , p8_a23 NUMBER := 0-1962.0724
1088: , p8_a24 DATE := fnd_api.g_miss_date
1089: , p8_a25 NUMBER := 0-1962.0724
1090: , p8_a26 NUMBER := 0-1962.0724

Line 1088: , p8_a24 DATE := fnd_api.g_miss_date

1084: , p8_a20 DATE := fnd_api.g_miss_date
1085: , p8_a21 VARCHAR2 := fnd_api.g_miss_char
1086: , p8_a22 DATE := fnd_api.g_miss_date
1087: , p8_a23 NUMBER := 0-1962.0724
1088: , p8_a24 DATE := fnd_api.g_miss_date
1089: , p8_a25 NUMBER := 0-1962.0724
1090: , p8_a26 NUMBER := 0-1962.0724
1091: , p8_a27 NUMBER := 0-1962.0724
1092: , p8_a28 NUMBER := 0-1962.0724

Line 1093: , p8_a29 VARCHAR2 := fnd_api.g_miss_char

1089: , p8_a25 NUMBER := 0-1962.0724
1090: , p8_a26 NUMBER := 0-1962.0724
1091: , p8_a27 NUMBER := 0-1962.0724
1092: , p8_a28 NUMBER := 0-1962.0724
1093: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
1094: , p8_a30 NUMBER := 0-1962.0724
1095: , p8_a31 NUMBER := 0-1962.0724
1096: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
1097: , p8_a33 VARCHAR2 := fnd_api.g_miss_char

Line 1096: , p8_a32 VARCHAR2 := fnd_api.g_miss_char

1092: , p8_a28 NUMBER := 0-1962.0724
1093: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
1094: , p8_a30 NUMBER := 0-1962.0724
1095: , p8_a31 NUMBER := 0-1962.0724
1096: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
1097: , p8_a33 VARCHAR2 := fnd_api.g_miss_char
1098: , p8_a34 VARCHAR2 := fnd_api.g_miss_char
1099: , p8_a35 VARCHAR2 := fnd_api.g_miss_char
1100: , p8_a36 VARCHAR2 := fnd_api.g_miss_char

Line 1097: , p8_a33 VARCHAR2 := fnd_api.g_miss_char

1093: , p8_a29 VARCHAR2 := fnd_api.g_miss_char
1094: , p8_a30 NUMBER := 0-1962.0724
1095: , p8_a31 NUMBER := 0-1962.0724
1096: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
1097: , p8_a33 VARCHAR2 := fnd_api.g_miss_char
1098: , p8_a34 VARCHAR2 := fnd_api.g_miss_char
1099: , p8_a35 VARCHAR2 := fnd_api.g_miss_char
1100: , p8_a36 VARCHAR2 := fnd_api.g_miss_char
1101: , p8_a37 VARCHAR2 := fnd_api.g_miss_char

Line 1098: , p8_a34 VARCHAR2 := fnd_api.g_miss_char

1094: , p8_a30 NUMBER := 0-1962.0724
1095: , p8_a31 NUMBER := 0-1962.0724
1096: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
1097: , p8_a33 VARCHAR2 := fnd_api.g_miss_char
1098: , p8_a34 VARCHAR2 := fnd_api.g_miss_char
1099: , p8_a35 VARCHAR2 := fnd_api.g_miss_char
1100: , p8_a36 VARCHAR2 := fnd_api.g_miss_char
1101: , p8_a37 VARCHAR2 := fnd_api.g_miss_char
1102: , p8_a38 VARCHAR2 := fnd_api.g_miss_char

Line 1099: , p8_a35 VARCHAR2 := fnd_api.g_miss_char

1095: , p8_a31 NUMBER := 0-1962.0724
1096: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
1097: , p8_a33 VARCHAR2 := fnd_api.g_miss_char
1098: , p8_a34 VARCHAR2 := fnd_api.g_miss_char
1099: , p8_a35 VARCHAR2 := fnd_api.g_miss_char
1100: , p8_a36 VARCHAR2 := fnd_api.g_miss_char
1101: , p8_a37 VARCHAR2 := fnd_api.g_miss_char
1102: , p8_a38 VARCHAR2 := fnd_api.g_miss_char
1103: , p8_a39 VARCHAR2 := fnd_api.g_miss_char

Line 1100: , p8_a36 VARCHAR2 := fnd_api.g_miss_char

1096: , p8_a32 VARCHAR2 := fnd_api.g_miss_char
1097: , p8_a33 VARCHAR2 := fnd_api.g_miss_char
1098: , p8_a34 VARCHAR2 := fnd_api.g_miss_char
1099: , p8_a35 VARCHAR2 := fnd_api.g_miss_char
1100: , p8_a36 VARCHAR2 := fnd_api.g_miss_char
1101: , p8_a37 VARCHAR2 := fnd_api.g_miss_char
1102: , p8_a38 VARCHAR2 := fnd_api.g_miss_char
1103: , p8_a39 VARCHAR2 := fnd_api.g_miss_char
1104: , p8_a40 VARCHAR2 := fnd_api.g_miss_char

Line 1101: , p8_a37 VARCHAR2 := fnd_api.g_miss_char

1097: , p8_a33 VARCHAR2 := fnd_api.g_miss_char
1098: , p8_a34 VARCHAR2 := fnd_api.g_miss_char
1099: , p8_a35 VARCHAR2 := fnd_api.g_miss_char
1100: , p8_a36 VARCHAR2 := fnd_api.g_miss_char
1101: , p8_a37 VARCHAR2 := fnd_api.g_miss_char
1102: , p8_a38 VARCHAR2 := fnd_api.g_miss_char
1103: , p8_a39 VARCHAR2 := fnd_api.g_miss_char
1104: , p8_a40 VARCHAR2 := fnd_api.g_miss_char
1105: , p8_a41 VARCHAR2 := fnd_api.g_miss_char

Line 1102: , p8_a38 VARCHAR2 := fnd_api.g_miss_char

1098: , p8_a34 VARCHAR2 := fnd_api.g_miss_char
1099: , p8_a35 VARCHAR2 := fnd_api.g_miss_char
1100: , p8_a36 VARCHAR2 := fnd_api.g_miss_char
1101: , p8_a37 VARCHAR2 := fnd_api.g_miss_char
1102: , p8_a38 VARCHAR2 := fnd_api.g_miss_char
1103: , p8_a39 VARCHAR2 := fnd_api.g_miss_char
1104: , p8_a40 VARCHAR2 := fnd_api.g_miss_char
1105: , p8_a41 VARCHAR2 := fnd_api.g_miss_char
1106: , p8_a42 VARCHAR2 := fnd_api.g_miss_char

Line 1103: , p8_a39 VARCHAR2 := fnd_api.g_miss_char

1099: , p8_a35 VARCHAR2 := fnd_api.g_miss_char
1100: , p8_a36 VARCHAR2 := fnd_api.g_miss_char
1101: , p8_a37 VARCHAR2 := fnd_api.g_miss_char
1102: , p8_a38 VARCHAR2 := fnd_api.g_miss_char
1103: , p8_a39 VARCHAR2 := fnd_api.g_miss_char
1104: , p8_a40 VARCHAR2 := fnd_api.g_miss_char
1105: , p8_a41 VARCHAR2 := fnd_api.g_miss_char
1106: , p8_a42 VARCHAR2 := fnd_api.g_miss_char
1107: , p8_a43 VARCHAR2 := fnd_api.g_miss_char

Line 1104: , p8_a40 VARCHAR2 := fnd_api.g_miss_char

1100: , p8_a36 VARCHAR2 := fnd_api.g_miss_char
1101: , p8_a37 VARCHAR2 := fnd_api.g_miss_char
1102: , p8_a38 VARCHAR2 := fnd_api.g_miss_char
1103: , p8_a39 VARCHAR2 := fnd_api.g_miss_char
1104: , p8_a40 VARCHAR2 := fnd_api.g_miss_char
1105: , p8_a41 VARCHAR2 := fnd_api.g_miss_char
1106: , p8_a42 VARCHAR2 := fnd_api.g_miss_char
1107: , p8_a43 VARCHAR2 := fnd_api.g_miss_char
1108: , p8_a44 VARCHAR2 := fnd_api.g_miss_char

Line 1105: , p8_a41 VARCHAR2 := fnd_api.g_miss_char

1101: , p8_a37 VARCHAR2 := fnd_api.g_miss_char
1102: , p8_a38 VARCHAR2 := fnd_api.g_miss_char
1103: , p8_a39 VARCHAR2 := fnd_api.g_miss_char
1104: , p8_a40 VARCHAR2 := fnd_api.g_miss_char
1105: , p8_a41 VARCHAR2 := fnd_api.g_miss_char
1106: , p8_a42 VARCHAR2 := fnd_api.g_miss_char
1107: , p8_a43 VARCHAR2 := fnd_api.g_miss_char
1108: , p8_a44 VARCHAR2 := fnd_api.g_miss_char
1109: , p8_a45 VARCHAR2 := fnd_api.g_miss_char

Line 1106: , p8_a42 VARCHAR2 := fnd_api.g_miss_char

1102: , p8_a38 VARCHAR2 := fnd_api.g_miss_char
1103: , p8_a39 VARCHAR2 := fnd_api.g_miss_char
1104: , p8_a40 VARCHAR2 := fnd_api.g_miss_char
1105: , p8_a41 VARCHAR2 := fnd_api.g_miss_char
1106: , p8_a42 VARCHAR2 := fnd_api.g_miss_char
1107: , p8_a43 VARCHAR2 := fnd_api.g_miss_char
1108: , p8_a44 VARCHAR2 := fnd_api.g_miss_char
1109: , p8_a45 VARCHAR2 := fnd_api.g_miss_char
1110: , p8_a46 VARCHAR2 := fnd_api.g_miss_char

Line 1107: , p8_a43 VARCHAR2 := fnd_api.g_miss_char

1103: , p8_a39 VARCHAR2 := fnd_api.g_miss_char
1104: , p8_a40 VARCHAR2 := fnd_api.g_miss_char
1105: , p8_a41 VARCHAR2 := fnd_api.g_miss_char
1106: , p8_a42 VARCHAR2 := fnd_api.g_miss_char
1107: , p8_a43 VARCHAR2 := fnd_api.g_miss_char
1108: , p8_a44 VARCHAR2 := fnd_api.g_miss_char
1109: , p8_a45 VARCHAR2 := fnd_api.g_miss_char
1110: , p8_a46 VARCHAR2 := fnd_api.g_miss_char
1111: , p8_a47 VARCHAR2 := fnd_api.g_miss_char

Line 1108: , p8_a44 VARCHAR2 := fnd_api.g_miss_char

1104: , p8_a40 VARCHAR2 := fnd_api.g_miss_char
1105: , p8_a41 VARCHAR2 := fnd_api.g_miss_char
1106: , p8_a42 VARCHAR2 := fnd_api.g_miss_char
1107: , p8_a43 VARCHAR2 := fnd_api.g_miss_char
1108: , p8_a44 VARCHAR2 := fnd_api.g_miss_char
1109: , p8_a45 VARCHAR2 := fnd_api.g_miss_char
1110: , p8_a46 VARCHAR2 := fnd_api.g_miss_char
1111: , p8_a47 VARCHAR2 := fnd_api.g_miss_char
1112: , p8_a48 VARCHAR2 := fnd_api.g_miss_char

Line 1109: , p8_a45 VARCHAR2 := fnd_api.g_miss_char

1105: , p8_a41 VARCHAR2 := fnd_api.g_miss_char
1106: , p8_a42 VARCHAR2 := fnd_api.g_miss_char
1107: , p8_a43 VARCHAR2 := fnd_api.g_miss_char
1108: , p8_a44 VARCHAR2 := fnd_api.g_miss_char
1109: , p8_a45 VARCHAR2 := fnd_api.g_miss_char
1110: , p8_a46 VARCHAR2 := fnd_api.g_miss_char
1111: , p8_a47 VARCHAR2 := fnd_api.g_miss_char
1112: , p8_a48 VARCHAR2 := fnd_api.g_miss_char
1113: , p8_a49 VARCHAR2 := fnd_api.g_miss_char

Line 1110: , p8_a46 VARCHAR2 := fnd_api.g_miss_char

1106: , p8_a42 VARCHAR2 := fnd_api.g_miss_char
1107: , p8_a43 VARCHAR2 := fnd_api.g_miss_char
1108: , p8_a44 VARCHAR2 := fnd_api.g_miss_char
1109: , p8_a45 VARCHAR2 := fnd_api.g_miss_char
1110: , p8_a46 VARCHAR2 := fnd_api.g_miss_char
1111: , p8_a47 VARCHAR2 := fnd_api.g_miss_char
1112: , p8_a48 VARCHAR2 := fnd_api.g_miss_char
1113: , p8_a49 VARCHAR2 := fnd_api.g_miss_char
1114: )

Line 1111: , p8_a47 VARCHAR2 := fnd_api.g_miss_char

1107: , p8_a43 VARCHAR2 := fnd_api.g_miss_char
1108: , p8_a44 VARCHAR2 := fnd_api.g_miss_char
1109: , p8_a45 VARCHAR2 := fnd_api.g_miss_char
1110: , p8_a46 VARCHAR2 := fnd_api.g_miss_char
1111: , p8_a47 VARCHAR2 := fnd_api.g_miss_char
1112: , p8_a48 VARCHAR2 := fnd_api.g_miss_char
1113: , p8_a49 VARCHAR2 := fnd_api.g_miss_char
1114: )
1115:

Line 1112: , p8_a48 VARCHAR2 := fnd_api.g_miss_char

1108: , p8_a44 VARCHAR2 := fnd_api.g_miss_char
1109: , p8_a45 VARCHAR2 := fnd_api.g_miss_char
1110: , p8_a46 VARCHAR2 := fnd_api.g_miss_char
1111: , p8_a47 VARCHAR2 := fnd_api.g_miss_char
1112: , p8_a48 VARCHAR2 := fnd_api.g_miss_char
1113: , p8_a49 VARCHAR2 := fnd_api.g_miss_char
1114: )
1115:
1116: as

Line 1113: , p8_a49 VARCHAR2 := fnd_api.g_miss_char

1109: , p8_a45 VARCHAR2 := fnd_api.g_miss_char
1110: , p8_a46 VARCHAR2 := fnd_api.g_miss_char
1111: , p8_a47 VARCHAR2 := fnd_api.g_miss_char
1112: , p8_a48 VARCHAR2 := fnd_api.g_miss_char
1113: , p8_a49 VARCHAR2 := fnd_api.g_miss_char
1114: )
1115:
1116: as
1117: ddp_vo_disc_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;

Line 1208: , p0_a1 VARCHAR2 := fnd_api.g_miss_char

1204: end;
1205:
1206: procedure check_vo_product_attr(x_return_status out nocopy VARCHAR2
1207: , p0_a0 NUMBER := 0-1962.0724
1208: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
1209: , p0_a2 NUMBER := 0-1962.0724
1210: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1211: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1212: , p0_a5 DATE := fnd_api.g_miss_date

Line 1210: , p0_a3 VARCHAR2 := fnd_api.g_miss_char

1206: procedure check_vo_product_attr(x_return_status out nocopy VARCHAR2
1207: , p0_a0 NUMBER := 0-1962.0724
1208: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
1209: , p0_a2 NUMBER := 0-1962.0724
1210: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1211: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1212: , p0_a5 DATE := fnd_api.g_miss_date
1213: , p0_a6 DATE := fnd_api.g_miss_date
1214: , p0_a7 NUMBER := 0-1962.0724

Line 1211: , p0_a4 VARCHAR2 := fnd_api.g_miss_char

1207: , p0_a0 NUMBER := 0-1962.0724
1208: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
1209: , p0_a2 NUMBER := 0-1962.0724
1210: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1211: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1212: , p0_a5 DATE := fnd_api.g_miss_date
1213: , p0_a6 DATE := fnd_api.g_miss_date
1214: , p0_a7 NUMBER := 0-1962.0724
1215: , p0_a8 NUMBER := 0-1962.0724

Line 1212: , p0_a5 DATE := fnd_api.g_miss_date

1208: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
1209: , p0_a2 NUMBER := 0-1962.0724
1210: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1211: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1212: , p0_a5 DATE := fnd_api.g_miss_date
1213: , p0_a6 DATE := fnd_api.g_miss_date
1214: , p0_a7 NUMBER := 0-1962.0724
1215: , p0_a8 NUMBER := 0-1962.0724
1216: , p0_a9 DATE := fnd_api.g_miss_date

Line 1213: , p0_a6 DATE := fnd_api.g_miss_date

1209: , p0_a2 NUMBER := 0-1962.0724
1210: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1211: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1212: , p0_a5 DATE := fnd_api.g_miss_date
1213: , p0_a6 DATE := fnd_api.g_miss_date
1214: , p0_a7 NUMBER := 0-1962.0724
1215: , p0_a8 NUMBER := 0-1962.0724
1216: , p0_a9 DATE := fnd_api.g_miss_date
1217: , p0_a10 NUMBER := 0-1962.0724

Line 1216: , p0_a9 DATE := fnd_api.g_miss_date

1212: , p0_a5 DATE := fnd_api.g_miss_date
1213: , p0_a6 DATE := fnd_api.g_miss_date
1214: , p0_a7 NUMBER := 0-1962.0724
1215: , p0_a8 NUMBER := 0-1962.0724
1216: , p0_a9 DATE := fnd_api.g_miss_date
1217: , p0_a10 NUMBER := 0-1962.0724
1218: , p0_a11 DATE := fnd_api.g_miss_date
1219: , p0_a12 NUMBER := 0-1962.0724
1220: , p0_a13 NUMBER := 0-1962.0724

Line 1218: , p0_a11 DATE := fnd_api.g_miss_date

1214: , p0_a7 NUMBER := 0-1962.0724
1215: , p0_a8 NUMBER := 0-1962.0724
1216: , p0_a9 DATE := fnd_api.g_miss_date
1217: , p0_a10 NUMBER := 0-1962.0724
1218: , p0_a11 DATE := fnd_api.g_miss_date
1219: , p0_a12 NUMBER := 0-1962.0724
1220: , p0_a13 NUMBER := 0-1962.0724
1221: , p0_a14 NUMBER := 0-1962.0724
1222: , p0_a15 NUMBER := 0-1962.0724

Line 1223: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

1219: , p0_a12 NUMBER := 0-1962.0724
1220: , p0_a13 NUMBER := 0-1962.0724
1221: , p0_a14 NUMBER := 0-1962.0724
1222: , p0_a15 NUMBER := 0-1962.0724
1223: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1224: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1225: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1226: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1227: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

Line 1224: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

1220: , p0_a13 NUMBER := 0-1962.0724
1221: , p0_a14 NUMBER := 0-1962.0724
1222: , p0_a15 NUMBER := 0-1962.0724
1223: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1224: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1225: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1226: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1227: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1228: )

Line 1225: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

1221: , p0_a14 NUMBER := 0-1962.0724
1222: , p0_a15 NUMBER := 0-1962.0724
1223: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1224: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1225: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1226: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1227: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1228: )
1229:

Line 1226: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

1222: , p0_a15 NUMBER := 0-1962.0724
1223: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1224: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1225: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1226: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1227: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1228: )
1229:
1230: as

Line 1227: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

1223: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1224: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1225: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1226: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1227: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1228: )
1229:
1230: as
1231: ddp_vo_prod_rec ozf_volume_offer_disc_pvt.vo_prod_rec_type;