3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;
14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_web_track_pvt.web_track_tbl_type, a0 JTF_NUMBER_TABLE
549: , x_msg_data OUT NOCOPY VARCHAR2
550: , x_web_tracking_id OUT NOCOPY NUMBER
551: , p7_a0 NUMBER := 0-1962.0724
552: , p7_a1 NUMBER := 0-1962.0724
553: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
554: , p7_a3 NUMBER := 0-1962.0724
555: , p7_a4 NUMBER := 0-1962.0724
556: , p7_a5 NUMBER := 0-1962.0724
557: , p7_a6 DATE := fnd_api.g_miss_date
553: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
554: , p7_a3 NUMBER := 0-1962.0724
555: , p7_a4 NUMBER := 0-1962.0724
556: , p7_a5 NUMBER := 0-1962.0724
557: , p7_a6 DATE := fnd_api.g_miss_date
558: , p7_a7 NUMBER := 0-1962.0724
559: , p7_a8 DATE := fnd_api.g_miss_date
560: , p7_a9 NUMBER := 0-1962.0724
561: , p7_a10 NUMBER := 0-1962.0724
555: , p7_a4 NUMBER := 0-1962.0724
556: , p7_a5 NUMBER := 0-1962.0724
557: , p7_a6 DATE := fnd_api.g_miss_date
558: , p7_a7 NUMBER := 0-1962.0724
559: , p7_a8 DATE := fnd_api.g_miss_date
560: , p7_a9 NUMBER := 0-1962.0724
561: , p7_a10 NUMBER := 0-1962.0724
562: , p7_a11 NUMBER := 0-1962.0724
563: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
559: , p7_a8 DATE := fnd_api.g_miss_date
560: , p7_a9 NUMBER := 0-1962.0724
561: , p7_a10 NUMBER := 0-1962.0724
562: , p7_a11 NUMBER := 0-1962.0724
563: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
564: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
565: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
566: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
567: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
560: , p7_a9 NUMBER := 0-1962.0724
561: , p7_a10 NUMBER := 0-1962.0724
562: , p7_a11 NUMBER := 0-1962.0724
563: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
564: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
565: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
566: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
567: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
568: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
561: , p7_a10 NUMBER := 0-1962.0724
562: , p7_a11 NUMBER := 0-1962.0724
563: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
564: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
565: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
566: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
567: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
568: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
569: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
562: , p7_a11 NUMBER := 0-1962.0724
563: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
564: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
565: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
566: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
567: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
568: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
569: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
570: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
563: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
564: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
565: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
566: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
567: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
568: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
569: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
570: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
571: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
564: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
565: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
566: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
567: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
568: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
569: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
570: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
571: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
572: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
565: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
566: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
567: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
568: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
569: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
570: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
571: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
572: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
573: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
566: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
567: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
568: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
569: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
570: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
571: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
572: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
573: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
574: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
567: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
568: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
569: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
570: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
571: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
572: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
573: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
574: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
575: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
568: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
569: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
570: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
571: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
572: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
573: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
574: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
575: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
576: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
569: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
570: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
571: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
572: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
573: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
574: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
575: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
576: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
577: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
570: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
571: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
572: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
573: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
574: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
575: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
576: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
577: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
578: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
571: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
572: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
573: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
574: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
575: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
576: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
577: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
578: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
579: )
572: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
573: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
574: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
575: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
576: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
577: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
578: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
579: )
580: as
573: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
574: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
575: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
576: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
577: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
578: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
579: )
580: as
581: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
574: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
575: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
576: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
577: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
578: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
579: )
580: as
581: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
582: ddindx binary_integer; indx binary_integer;
650: , x_msg_count OUT NOCOPY NUMBER
651: , x_msg_data OUT NOCOPY VARCHAR2
652: , p7_a0 NUMBER := 0-1962.0724
653: , p7_a1 NUMBER := 0-1962.0724
654: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
655: , p7_a3 NUMBER := 0-1962.0724
656: , p7_a4 NUMBER := 0-1962.0724
657: , p7_a5 NUMBER := 0-1962.0724
658: , p7_a6 DATE := fnd_api.g_miss_date
654: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
655: , p7_a3 NUMBER := 0-1962.0724
656: , p7_a4 NUMBER := 0-1962.0724
657: , p7_a5 NUMBER := 0-1962.0724
658: , p7_a6 DATE := fnd_api.g_miss_date
659: , p7_a7 NUMBER := 0-1962.0724
660: , p7_a8 DATE := fnd_api.g_miss_date
661: , p7_a9 NUMBER := 0-1962.0724
662: , p7_a10 NUMBER := 0-1962.0724
656: , p7_a4 NUMBER := 0-1962.0724
657: , p7_a5 NUMBER := 0-1962.0724
658: , p7_a6 DATE := fnd_api.g_miss_date
659: , p7_a7 NUMBER := 0-1962.0724
660: , p7_a8 DATE := fnd_api.g_miss_date
661: , p7_a9 NUMBER := 0-1962.0724
662: , p7_a10 NUMBER := 0-1962.0724
663: , p7_a11 NUMBER := 0-1962.0724
664: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
660: , p7_a8 DATE := fnd_api.g_miss_date
661: , p7_a9 NUMBER := 0-1962.0724
662: , p7_a10 NUMBER := 0-1962.0724
663: , p7_a11 NUMBER := 0-1962.0724
664: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
665: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
666: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
667: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
668: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
661: , p7_a9 NUMBER := 0-1962.0724
662: , p7_a10 NUMBER := 0-1962.0724
663: , p7_a11 NUMBER := 0-1962.0724
664: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
665: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
666: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
667: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
668: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
662: , p7_a10 NUMBER := 0-1962.0724
663: , p7_a11 NUMBER := 0-1962.0724
664: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
665: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
666: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
667: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
668: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
663: , p7_a11 NUMBER := 0-1962.0724
664: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
665: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
666: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
667: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
668: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
671: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
664: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
665: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
666: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
667: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
668: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
671: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
672: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
665: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
666: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
667: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
668: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
671: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
672: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
673: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
666: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
667: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
668: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
671: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
672: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
673: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
674: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
667: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
668: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
671: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
672: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
673: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
674: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
675: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
668: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
671: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
672: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
673: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
674: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
675: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
676: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
671: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
672: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
673: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
674: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
675: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
676: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
677: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
671: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
672: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
673: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
674: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
675: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
676: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
677: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
678: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
671: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
672: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
673: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
674: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
675: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
676: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
677: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
678: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
679: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
672: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
673: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
674: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
675: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
676: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
677: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
678: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
679: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
680: )
673: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
674: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
675: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
676: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
677: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
678: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
679: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
680: )
681: as
674: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
675: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
676: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
677: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
678: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
679: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
680: )
681: as
682: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
675: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
676: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
677: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
678: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
679: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
680: )
681: as
682: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
683: ddindx binary_integer; indx binary_integer;
748: , x_msg_count OUT NOCOPY NUMBER
749: , x_msg_data OUT NOCOPY VARCHAR2
750: , p3_a0 NUMBER := 0-1962.0724
751: , p3_a1 NUMBER := 0-1962.0724
752: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
753: , p3_a3 NUMBER := 0-1962.0724
754: , p3_a4 NUMBER := 0-1962.0724
755: , p3_a5 NUMBER := 0-1962.0724
756: , p3_a6 DATE := fnd_api.g_miss_date
752: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
753: , p3_a3 NUMBER := 0-1962.0724
754: , p3_a4 NUMBER := 0-1962.0724
755: , p3_a5 NUMBER := 0-1962.0724
756: , p3_a6 DATE := fnd_api.g_miss_date
757: , p3_a7 NUMBER := 0-1962.0724
758: , p3_a8 DATE := fnd_api.g_miss_date
759: , p3_a9 NUMBER := 0-1962.0724
760: , p3_a10 NUMBER := 0-1962.0724
754: , p3_a4 NUMBER := 0-1962.0724
755: , p3_a5 NUMBER := 0-1962.0724
756: , p3_a6 DATE := fnd_api.g_miss_date
757: , p3_a7 NUMBER := 0-1962.0724
758: , p3_a8 DATE := fnd_api.g_miss_date
759: , p3_a9 NUMBER := 0-1962.0724
760: , p3_a10 NUMBER := 0-1962.0724
761: , p3_a11 NUMBER := 0-1962.0724
762: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
758: , p3_a8 DATE := fnd_api.g_miss_date
759: , p3_a9 NUMBER := 0-1962.0724
760: , p3_a10 NUMBER := 0-1962.0724
761: , p3_a11 NUMBER := 0-1962.0724
762: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
759: , p3_a9 NUMBER := 0-1962.0724
760: , p3_a10 NUMBER := 0-1962.0724
761: , p3_a11 NUMBER := 0-1962.0724
762: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
760: , p3_a10 NUMBER := 0-1962.0724
761: , p3_a11 NUMBER := 0-1962.0724
762: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
761: , p3_a11 NUMBER := 0-1962.0724
762: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
762: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
763: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
771: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
764: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
771: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
772: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
765: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
771: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
772: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
773: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
766: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
771: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
772: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
773: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
774: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
767: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
771: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
772: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
773: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
774: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
775: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
768: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
771: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
772: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
773: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
774: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
775: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
776: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
769: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
771: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
772: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
773: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
774: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
775: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
776: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
777: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
770: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
771: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
772: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
773: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
774: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
775: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
776: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
777: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
778: )
771: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
772: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
773: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
774: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
775: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
776: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
777: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
778: )
779: as
772: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
773: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
774: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
775: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
776: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
777: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
778: )
779: as
780: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
773: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
774: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
775: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
776: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
777: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
778: )
779: as
780: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
781: ddindx binary_integer; indx binary_integer;
841: procedure check_web_track_items(p_validation_mode VARCHAR2
842: , x_return_status OUT NOCOPY VARCHAR2
843: , p0_a0 NUMBER := 0-1962.0724
844: , p0_a1 NUMBER := 0-1962.0724
845: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
846: , p0_a3 NUMBER := 0-1962.0724
847: , p0_a4 NUMBER := 0-1962.0724
848: , p0_a5 NUMBER := 0-1962.0724
849: , p0_a6 DATE := fnd_api.g_miss_date
845: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
846: , p0_a3 NUMBER := 0-1962.0724
847: , p0_a4 NUMBER := 0-1962.0724
848: , p0_a5 NUMBER := 0-1962.0724
849: , p0_a6 DATE := fnd_api.g_miss_date
850: , p0_a7 NUMBER := 0-1962.0724
851: , p0_a8 DATE := fnd_api.g_miss_date
852: , p0_a9 NUMBER := 0-1962.0724
853: , p0_a10 NUMBER := 0-1962.0724
847: , p0_a4 NUMBER := 0-1962.0724
848: , p0_a5 NUMBER := 0-1962.0724
849: , p0_a6 DATE := fnd_api.g_miss_date
850: , p0_a7 NUMBER := 0-1962.0724
851: , p0_a8 DATE := fnd_api.g_miss_date
852: , p0_a9 NUMBER := 0-1962.0724
853: , p0_a10 NUMBER := 0-1962.0724
854: , p0_a11 NUMBER := 0-1962.0724
855: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
851: , p0_a8 DATE := fnd_api.g_miss_date
852: , p0_a9 NUMBER := 0-1962.0724
853: , p0_a10 NUMBER := 0-1962.0724
854: , p0_a11 NUMBER := 0-1962.0724
855: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
856: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
857: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
858: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
859: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
852: , p0_a9 NUMBER := 0-1962.0724
853: , p0_a10 NUMBER := 0-1962.0724
854: , p0_a11 NUMBER := 0-1962.0724
855: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
856: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
857: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
858: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
859: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
853: , p0_a10 NUMBER := 0-1962.0724
854: , p0_a11 NUMBER := 0-1962.0724
855: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
856: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
857: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
858: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
859: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
861: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
854: , p0_a11 NUMBER := 0-1962.0724
855: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
856: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
857: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
858: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
859: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
861: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
855: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
856: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
857: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
858: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
859: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
861: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
863: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
856: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
857: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
858: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
859: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
861: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
863: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
864: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
857: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
858: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
859: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
861: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
863: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
864: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
865: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
858: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
859: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
861: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
863: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
864: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
865: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
866: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
859: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
861: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
863: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
864: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
865: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
866: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
861: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
863: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
864: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
865: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
866: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
861: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
863: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
864: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
865: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
866: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
863: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
864: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
865: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
866: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
870: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
863: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
864: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
865: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
866: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
870: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
871: )
864: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
865: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
866: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
870: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
871: )
872: as
865: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
866: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
870: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
871: )
872: as
873: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
866: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
870: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
871: )
872: as
873: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
874: ddindx binary_integer; indx binary_integer;
922: , x_msg_count OUT NOCOPY NUMBER
923: , x_msg_data OUT NOCOPY VARCHAR2
924: , p5_a0 NUMBER := 0-1962.0724
925: , p5_a1 NUMBER := 0-1962.0724
926: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a3 NUMBER := 0-1962.0724
928: , p5_a4 NUMBER := 0-1962.0724
929: , p5_a5 NUMBER := 0-1962.0724
930: , p5_a6 DATE := fnd_api.g_miss_date
926: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
927: , p5_a3 NUMBER := 0-1962.0724
928: , p5_a4 NUMBER := 0-1962.0724
929: , p5_a5 NUMBER := 0-1962.0724
930: , p5_a6 DATE := fnd_api.g_miss_date
931: , p5_a7 NUMBER := 0-1962.0724
932: , p5_a8 DATE := fnd_api.g_miss_date
933: , p5_a9 NUMBER := 0-1962.0724
934: , p5_a10 NUMBER := 0-1962.0724
928: , p5_a4 NUMBER := 0-1962.0724
929: , p5_a5 NUMBER := 0-1962.0724
930: , p5_a6 DATE := fnd_api.g_miss_date
931: , p5_a7 NUMBER := 0-1962.0724
932: , p5_a8 DATE := fnd_api.g_miss_date
933: , p5_a9 NUMBER := 0-1962.0724
934: , p5_a10 NUMBER := 0-1962.0724
935: , p5_a11 NUMBER := 0-1962.0724
936: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
932: , p5_a8 DATE := fnd_api.g_miss_date
933: , p5_a9 NUMBER := 0-1962.0724
934: , p5_a10 NUMBER := 0-1962.0724
935: , p5_a11 NUMBER := 0-1962.0724
936: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
938: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
933: , p5_a9 NUMBER := 0-1962.0724
934: , p5_a10 NUMBER := 0-1962.0724
935: , p5_a11 NUMBER := 0-1962.0724
936: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
938: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
934: , p5_a10 NUMBER := 0-1962.0724
935: , p5_a11 NUMBER := 0-1962.0724
936: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
938: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
942: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
935: , p5_a11 NUMBER := 0-1962.0724
936: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
938: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
942: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
943: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
936: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
938: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
942: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
943: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
938: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
942: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
943: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
938: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
942: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
943: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
939: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
942: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
943: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
940: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
942: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
943: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
942: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
943: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
942: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
943: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
943: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
952: )
945: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
952: )
953: as
946: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
952: )
953: as
954: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
947: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
952: )
953: as
954: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
955: ddindx binary_integer; indx binary_integer;
1016: , x_web_recomm_id OUT NOCOPY NUMBER
1017: , p7_a0 NUMBER := 0-1962.0724
1018: , p7_a1 NUMBER := 0-1962.0724
1019: , p7_a2 NUMBER := 0-1962.0724
1020: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
1021: , p7_a4 NUMBER := 0-1962.0724
1022: , p7_a5 NUMBER := 0-1962.0724
1023: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
1024: , p7_a7 DATE := fnd_api.g_miss_date
1019: , p7_a2 NUMBER := 0-1962.0724
1020: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
1021: , p7_a4 NUMBER := 0-1962.0724
1022: , p7_a5 NUMBER := 0-1962.0724
1023: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
1024: , p7_a7 DATE := fnd_api.g_miss_date
1025: , p7_a8 NUMBER := 0-1962.0724
1026: , p7_a9 DATE := fnd_api.g_miss_date
1027: , p7_a10 NUMBER := 0-1962.0724
1020: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
1021: , p7_a4 NUMBER := 0-1962.0724
1022: , p7_a5 NUMBER := 0-1962.0724
1023: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
1024: , p7_a7 DATE := fnd_api.g_miss_date
1025: , p7_a8 NUMBER := 0-1962.0724
1026: , p7_a9 DATE := fnd_api.g_miss_date
1027: , p7_a10 NUMBER := 0-1962.0724
1028: , p7_a11 NUMBER := 0-1962.0724
1022: , p7_a5 NUMBER := 0-1962.0724
1023: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
1024: , p7_a7 DATE := fnd_api.g_miss_date
1025: , p7_a8 NUMBER := 0-1962.0724
1026: , p7_a9 DATE := fnd_api.g_miss_date
1027: , p7_a10 NUMBER := 0-1962.0724
1028: , p7_a11 NUMBER := 0-1962.0724
1029: , p7_a12 NUMBER := 0-1962.0724
1030: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1026: , p7_a9 DATE := fnd_api.g_miss_date
1027: , p7_a10 NUMBER := 0-1962.0724
1028: , p7_a11 NUMBER := 0-1962.0724
1029: , p7_a12 NUMBER := 0-1962.0724
1030: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1031: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1032: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1033: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1034: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1027: , p7_a10 NUMBER := 0-1962.0724
1028: , p7_a11 NUMBER := 0-1962.0724
1029: , p7_a12 NUMBER := 0-1962.0724
1030: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1031: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1032: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1033: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1034: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1035: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1028: , p7_a11 NUMBER := 0-1962.0724
1029: , p7_a12 NUMBER := 0-1962.0724
1030: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1031: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1032: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1033: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1034: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1035: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1036: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1029: , p7_a12 NUMBER := 0-1962.0724
1030: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1031: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1032: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1033: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1034: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1035: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1036: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1037: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1030: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1031: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1032: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1033: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1034: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1035: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1036: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1037: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1038: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1031: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1032: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1033: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1034: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1035: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1036: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1037: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1038: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1039: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1032: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1033: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1034: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1035: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1036: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1037: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1038: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1039: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1040: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1033: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1034: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1035: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1036: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1037: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1038: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1039: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1040: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1041: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1034: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1035: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1036: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1037: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1038: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1039: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1040: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1041: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1042: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1035: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1036: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1037: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1038: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1039: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1040: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1041: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1042: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1043: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1036: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1037: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1038: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1039: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1040: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1041: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1042: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1043: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1044: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1037: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1038: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1039: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1040: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1041: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1042: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1043: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1044: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1045: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1038: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1039: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1040: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1041: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1042: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1043: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1044: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1045: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1046: )
1039: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1040: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1041: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1042: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1043: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1044: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1045: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1046: )
1047: as
1040: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1041: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1042: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1043: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1044: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1045: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1046: )
1047: as
1048: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1041: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1042: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1043: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1044: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1045: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1046: )
1047: as
1048: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1049: ddindx binary_integer; indx binary_integer;
1119: , x_msg_data OUT NOCOPY VARCHAR2
1120: , p7_a0 NUMBER := 0-1962.0724
1121: , p7_a1 NUMBER := 0-1962.0724
1122: , p7_a2 NUMBER := 0-1962.0724
1123: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
1124: , p7_a4 NUMBER := 0-1962.0724
1125: , p7_a5 NUMBER := 0-1962.0724
1126: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
1127: , p7_a7 DATE := fnd_api.g_miss_date
1122: , p7_a2 NUMBER := 0-1962.0724
1123: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
1124: , p7_a4 NUMBER := 0-1962.0724
1125: , p7_a5 NUMBER := 0-1962.0724
1126: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
1127: , p7_a7 DATE := fnd_api.g_miss_date
1128: , p7_a8 NUMBER := 0-1962.0724
1129: , p7_a9 DATE := fnd_api.g_miss_date
1130: , p7_a10 NUMBER := 0-1962.0724
1123: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
1124: , p7_a4 NUMBER := 0-1962.0724
1125: , p7_a5 NUMBER := 0-1962.0724
1126: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
1127: , p7_a7 DATE := fnd_api.g_miss_date
1128: , p7_a8 NUMBER := 0-1962.0724
1129: , p7_a9 DATE := fnd_api.g_miss_date
1130: , p7_a10 NUMBER := 0-1962.0724
1131: , p7_a11 NUMBER := 0-1962.0724
1125: , p7_a5 NUMBER := 0-1962.0724
1126: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
1127: , p7_a7 DATE := fnd_api.g_miss_date
1128: , p7_a8 NUMBER := 0-1962.0724
1129: , p7_a9 DATE := fnd_api.g_miss_date
1130: , p7_a10 NUMBER := 0-1962.0724
1131: , p7_a11 NUMBER := 0-1962.0724
1132: , p7_a12 NUMBER := 0-1962.0724
1133: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1129: , p7_a9 DATE := fnd_api.g_miss_date
1130: , p7_a10 NUMBER := 0-1962.0724
1131: , p7_a11 NUMBER := 0-1962.0724
1132: , p7_a12 NUMBER := 0-1962.0724
1133: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1134: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1135: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1136: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1137: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1130: , p7_a10 NUMBER := 0-1962.0724
1131: , p7_a11 NUMBER := 0-1962.0724
1132: , p7_a12 NUMBER := 0-1962.0724
1133: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1134: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1135: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1136: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1137: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1138: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1131: , p7_a11 NUMBER := 0-1962.0724
1132: , p7_a12 NUMBER := 0-1962.0724
1133: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1134: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1135: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1136: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1137: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1138: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1139: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1132: , p7_a12 NUMBER := 0-1962.0724
1133: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1134: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1135: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1136: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1137: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1138: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1139: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1140: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1133: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1134: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1135: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1136: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1137: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1138: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1139: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1140: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1141: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1134: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1135: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1136: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1137: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1138: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1139: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1140: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1141: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1142: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1135: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1136: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1137: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1138: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1139: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1140: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1141: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1142: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1143: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1136: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1137: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1138: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1139: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1140: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1141: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1142: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1143: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1144: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1137: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1138: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1139: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1140: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1141: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1142: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1143: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1144: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1145: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1138: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1139: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1140: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1141: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1142: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1143: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1144: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1145: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1146: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1139: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1140: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1141: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1142: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1143: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1144: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1145: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1146: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1147: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1140: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1141: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1142: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1143: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1144: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1145: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1146: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1147: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1148: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1141: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1142: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1143: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1144: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1145: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1146: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1147: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1148: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1149: )
1142: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1143: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1144: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1145: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1146: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1147: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1148: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1149: )
1150: as
1143: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1144: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1145: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1146: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1147: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1148: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1149: )
1150: as
1151: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1144: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1145: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1146: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1147: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1148: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1149: )
1150: as
1151: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1152: ddindx binary_integer; indx binary_integer;
1219: , x_msg_data OUT NOCOPY VARCHAR2
1220: , p3_a0 NUMBER := 0-1962.0724
1221: , p3_a1 NUMBER := 0-1962.0724
1222: , p3_a2 NUMBER := 0-1962.0724
1223: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1224: , p3_a4 NUMBER := 0-1962.0724
1225: , p3_a5 NUMBER := 0-1962.0724
1226: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
1227: , p3_a7 DATE := fnd_api.g_miss_date
1222: , p3_a2 NUMBER := 0-1962.0724
1223: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1224: , p3_a4 NUMBER := 0-1962.0724
1225: , p3_a5 NUMBER := 0-1962.0724
1226: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
1227: , p3_a7 DATE := fnd_api.g_miss_date
1228: , p3_a8 NUMBER := 0-1962.0724
1229: , p3_a9 DATE := fnd_api.g_miss_date
1230: , p3_a10 NUMBER := 0-1962.0724
1223: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1224: , p3_a4 NUMBER := 0-1962.0724
1225: , p3_a5 NUMBER := 0-1962.0724
1226: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
1227: , p3_a7 DATE := fnd_api.g_miss_date
1228: , p3_a8 NUMBER := 0-1962.0724
1229: , p3_a9 DATE := fnd_api.g_miss_date
1230: , p3_a10 NUMBER := 0-1962.0724
1231: , p3_a11 NUMBER := 0-1962.0724
1225: , p3_a5 NUMBER := 0-1962.0724
1226: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
1227: , p3_a7 DATE := fnd_api.g_miss_date
1228: , p3_a8 NUMBER := 0-1962.0724
1229: , p3_a9 DATE := fnd_api.g_miss_date
1230: , p3_a10 NUMBER := 0-1962.0724
1231: , p3_a11 NUMBER := 0-1962.0724
1232: , p3_a12 NUMBER := 0-1962.0724
1233: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
1229: , p3_a9 DATE := fnd_api.g_miss_date
1230: , p3_a10 NUMBER := 0-1962.0724
1231: , p3_a11 NUMBER := 0-1962.0724
1232: , p3_a12 NUMBER := 0-1962.0724
1233: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
1234: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
1230: , p3_a10 NUMBER := 0-1962.0724
1231: , p3_a11 NUMBER := 0-1962.0724
1232: , p3_a12 NUMBER := 0-1962.0724
1233: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
1234: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1231: , p3_a11 NUMBER := 0-1962.0724
1232: , p3_a12 NUMBER := 0-1962.0724
1233: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
1234: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
1232: , p3_a12 NUMBER := 0-1962.0724
1233: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
1234: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
1233: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
1234: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
1234: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
1235: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
1236: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
1237: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
1238: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
1239: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
1247: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
1240: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
1247: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
1248: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
1241: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
1247: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
1248: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
1249: )
1242: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
1247: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
1248: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
1249: )
1250: as
1243: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
1247: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
1248: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
1249: )
1250: as
1251: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1244: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
1247: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
1248: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
1249: )
1250: as
1251: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1252: ddindx binary_integer; indx binary_integer;
1314: , x_return_status OUT NOCOPY VARCHAR2
1315: , p0_a0 NUMBER := 0-1962.0724
1316: , p0_a1 NUMBER := 0-1962.0724
1317: , p0_a2 NUMBER := 0-1962.0724
1318: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1319: , p0_a4 NUMBER := 0-1962.0724
1320: , p0_a5 NUMBER := 0-1962.0724
1321: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
1322: , p0_a7 DATE := fnd_api.g_miss_date
1317: , p0_a2 NUMBER := 0-1962.0724
1318: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1319: , p0_a4 NUMBER := 0-1962.0724
1320: , p0_a5 NUMBER := 0-1962.0724
1321: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
1322: , p0_a7 DATE := fnd_api.g_miss_date
1323: , p0_a8 NUMBER := 0-1962.0724
1324: , p0_a9 DATE := fnd_api.g_miss_date
1325: , p0_a10 NUMBER := 0-1962.0724
1318: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1319: , p0_a4 NUMBER := 0-1962.0724
1320: , p0_a5 NUMBER := 0-1962.0724
1321: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
1322: , p0_a7 DATE := fnd_api.g_miss_date
1323: , p0_a8 NUMBER := 0-1962.0724
1324: , p0_a9 DATE := fnd_api.g_miss_date
1325: , p0_a10 NUMBER := 0-1962.0724
1326: , p0_a11 NUMBER := 0-1962.0724
1320: , p0_a5 NUMBER := 0-1962.0724
1321: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
1322: , p0_a7 DATE := fnd_api.g_miss_date
1323: , p0_a8 NUMBER := 0-1962.0724
1324: , p0_a9 DATE := fnd_api.g_miss_date
1325: , p0_a10 NUMBER := 0-1962.0724
1326: , p0_a11 NUMBER := 0-1962.0724
1327: , p0_a12 NUMBER := 0-1962.0724
1328: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1324: , p0_a9 DATE := fnd_api.g_miss_date
1325: , p0_a10 NUMBER := 0-1962.0724
1326: , p0_a11 NUMBER := 0-1962.0724
1327: , p0_a12 NUMBER := 0-1962.0724
1328: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1329: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1330: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1331: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1332: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1325: , p0_a10 NUMBER := 0-1962.0724
1326: , p0_a11 NUMBER := 0-1962.0724
1327: , p0_a12 NUMBER := 0-1962.0724
1328: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1329: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1330: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1331: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1332: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1333: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1326: , p0_a11 NUMBER := 0-1962.0724
1327: , p0_a12 NUMBER := 0-1962.0724
1328: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1329: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1330: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1331: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1332: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1333: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1334: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1327: , p0_a12 NUMBER := 0-1962.0724
1328: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1329: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1330: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1331: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1332: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1333: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1334: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1335: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1328: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1329: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1330: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1331: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1332: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1333: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1334: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1335: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1336: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1329: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1330: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1331: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1332: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1333: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1334: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1335: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1336: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1337: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1330: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1331: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1332: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1333: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1334: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1335: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1336: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1337: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1338: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1331: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1332: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1333: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1334: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1335: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1336: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1337: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1338: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1339: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1332: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1333: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1334: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1335: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1336: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1337: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1338: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1339: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1340: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
1333: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1334: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1335: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1336: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1337: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1338: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1339: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1340: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
1341: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
1334: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1335: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1336: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1337: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1338: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1339: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1340: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
1341: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
1342: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1335: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1336: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1337: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1338: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1339: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1340: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
1341: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
1342: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1343: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1336: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1337: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1338: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1339: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1340: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
1341: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
1342: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1343: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1344: )
1337: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1338: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1339: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1340: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
1341: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
1342: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1343: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1344: )
1345: as
1338: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1339: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1340: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
1341: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
1342: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1343: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1344: )
1345: as
1346: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1339: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1340: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
1341: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
1342: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1343: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1344: )
1345: as
1346: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1347: ddindx binary_integer; indx binary_integer;
1397: , x_msg_data OUT NOCOPY VARCHAR2
1398: , p5_a0 NUMBER := 0-1962.0724
1399: , p5_a1 NUMBER := 0-1962.0724
1400: , p5_a2 NUMBER := 0-1962.0724
1401: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a4 NUMBER := 0-1962.0724
1403: , p5_a5 NUMBER := 0-1962.0724
1404: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a7 DATE := fnd_api.g_miss_date
1400: , p5_a2 NUMBER := 0-1962.0724
1401: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a4 NUMBER := 0-1962.0724
1403: , p5_a5 NUMBER := 0-1962.0724
1404: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a7 DATE := fnd_api.g_miss_date
1406: , p5_a8 NUMBER := 0-1962.0724
1407: , p5_a9 DATE := fnd_api.g_miss_date
1408: , p5_a10 NUMBER := 0-1962.0724
1401: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a4 NUMBER := 0-1962.0724
1403: , p5_a5 NUMBER := 0-1962.0724
1404: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a7 DATE := fnd_api.g_miss_date
1406: , p5_a8 NUMBER := 0-1962.0724
1407: , p5_a9 DATE := fnd_api.g_miss_date
1408: , p5_a10 NUMBER := 0-1962.0724
1409: , p5_a11 NUMBER := 0-1962.0724
1403: , p5_a5 NUMBER := 0-1962.0724
1404: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a7 DATE := fnd_api.g_miss_date
1406: , p5_a8 NUMBER := 0-1962.0724
1407: , p5_a9 DATE := fnd_api.g_miss_date
1408: , p5_a10 NUMBER := 0-1962.0724
1409: , p5_a11 NUMBER := 0-1962.0724
1410: , p5_a12 NUMBER := 0-1962.0724
1411: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1407: , p5_a9 DATE := fnd_api.g_miss_date
1408: , p5_a10 NUMBER := 0-1962.0724
1409: , p5_a11 NUMBER := 0-1962.0724
1410: , p5_a12 NUMBER := 0-1962.0724
1411: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1412: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1413: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1414: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1415: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1408: , p5_a10 NUMBER := 0-1962.0724
1409: , p5_a11 NUMBER := 0-1962.0724
1410: , p5_a12 NUMBER := 0-1962.0724
1411: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1412: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1413: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1414: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1415: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1409: , p5_a11 NUMBER := 0-1962.0724
1410: , p5_a12 NUMBER := 0-1962.0724
1411: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1412: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1413: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1414: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1415: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1410: , p5_a12 NUMBER := 0-1962.0724
1411: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1412: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1413: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1414: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1415: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1411: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1412: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1413: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1414: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1415: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1412: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1413: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1414: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1415: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1413: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1414: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1415: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1414: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1415: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1415: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1427: )
1420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1427: )
1428: as
1421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1427: )
1428: as
1429: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1427: )
1428: as
1429: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1430: ddindx binary_integer; indx binary_integer;
1521: , x_msg_count OUT NOCOPY NUMBER
1522: , x_msg_data OUT NOCOPY VARCHAR2
1523: , p4_a0 NUMBER := 0-1962.0724
1524: , p4_a1 NUMBER := 0-1962.0724
1525: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
1526: , p4_a3 NUMBER := 0-1962.0724
1527: , p4_a4 NUMBER := 0-1962.0724
1528: , p4_a5 NUMBER := 0-1962.0724
1529: , p4_a6 DATE := fnd_api.g_miss_date
1525: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
1526: , p4_a3 NUMBER := 0-1962.0724
1527: , p4_a4 NUMBER := 0-1962.0724
1528: , p4_a5 NUMBER := 0-1962.0724
1529: , p4_a6 DATE := fnd_api.g_miss_date
1530: , p4_a7 NUMBER := 0-1962.0724
1531: , p4_a8 DATE := fnd_api.g_miss_date
1532: , p4_a9 NUMBER := 0-1962.0724
1533: , p4_a10 NUMBER := 0-1962.0724
1527: , p4_a4 NUMBER := 0-1962.0724
1528: , p4_a5 NUMBER := 0-1962.0724
1529: , p4_a6 DATE := fnd_api.g_miss_date
1530: , p4_a7 NUMBER := 0-1962.0724
1531: , p4_a8 DATE := fnd_api.g_miss_date
1532: , p4_a9 NUMBER := 0-1962.0724
1533: , p4_a10 NUMBER := 0-1962.0724
1534: , p4_a11 NUMBER := 0-1962.0724
1535: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
1531: , p4_a8 DATE := fnd_api.g_miss_date
1532: , p4_a9 NUMBER := 0-1962.0724
1533: , p4_a10 NUMBER := 0-1962.0724
1534: , p4_a11 NUMBER := 0-1962.0724
1535: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
1536: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
1537: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
1538: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
1539: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1532: , p4_a9 NUMBER := 0-1962.0724
1533: , p4_a10 NUMBER := 0-1962.0724
1534: , p4_a11 NUMBER := 0-1962.0724
1535: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
1536: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
1537: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
1538: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
1539: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1540: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
1533: , p4_a10 NUMBER := 0-1962.0724
1534: , p4_a11 NUMBER := 0-1962.0724
1535: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
1536: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
1537: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
1538: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
1539: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1540: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
1541: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1534: , p4_a11 NUMBER := 0-1962.0724
1535: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
1536: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
1537: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
1538: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
1539: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1540: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
1541: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1542: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1535: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
1536: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
1537: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
1538: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
1539: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1540: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
1541: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1542: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1543: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
1536: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
1537: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
1538: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
1539: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1540: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
1541: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1542: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1543: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
1544: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1537: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
1538: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
1539: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1540: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
1541: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1542: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1543: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
1544: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1545: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1538: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
1539: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1540: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
1541: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1542: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1543: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
1544: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1545: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1546: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1539: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1540: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
1541: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1542: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1543: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
1544: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1545: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1546: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1547: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
1540: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
1541: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1542: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1543: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
1544: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1545: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1546: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1547: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
1548: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
1541: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1542: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1543: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
1544: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1545: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1546: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1547: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
1548: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
1549: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
1542: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1543: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
1544: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1545: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1546: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1547: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
1548: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
1549: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
1550: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
1543: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
1544: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1545: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1546: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1547: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
1548: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
1549: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
1550: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
1551: )
1544: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1545: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1546: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1547: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
1548: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
1549: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
1550: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
1551: )
1552: as
1545: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1546: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1547: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
1548: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
1549: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
1550: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
1551: )
1552: as
1553: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
1546: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1547: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
1548: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
1549: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
1550: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
1551: )
1552: as
1553: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
1554: ddp_web_recomms_tbl ams_web_track_pvt.web_recomms_tbl_type;