APPS.AMS_WEB_TRACK_PVT_W dependencies on FND_API

Line 7: a number := fnd_api.g_miss_num;

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;

Line 18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; 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

Line 553: , p7_a2 VARCHAR2 := fnd_api.g_miss_char

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

Line 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

Line 559: , p7_a8 DATE := fnd_api.g_miss_date

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

Line 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

Line 564: , p7_a13 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

Line 565: , p7_a14 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

Line 566: , p7_a15 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

Line 567: , p7_a16 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

Line 568: , p7_a17 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

Line 569: , p7_a18 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

Line 570: , p7_a19 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

Line 571: , p7_a20 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

Line 572: , p7_a21 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

Line 573: , p7_a22 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

Line 574: , p7_a23 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

Line 575: , p7_a24 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: )

Line 576: , p7_a25 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: )
580: as

Line 577: , p7_a26 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
581: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;

Line 578: , p7_a27 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;
582: ddindx binary_integer; indx binary_integer;

Line 654: , p7_a2 VARCHAR2 := fnd_api.g_miss_char

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

Line 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

Line 660: , p7_a8 DATE := fnd_api.g_miss_date

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

Line 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

Line 665: , p7_a13 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

Line 666: , p7_a14 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

Line 667: , p7_a15 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

Line 668: , p7_a16 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

Line 669: , p7_a17 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

Line 670: , p7_a18 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

Line 671: , p7_a19 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

Line 672: , p7_a20 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

Line 673: , p7_a21 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

Line 674: , p7_a22 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

Line 675: , p7_a23 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

Line 676: , p7_a24 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: )

Line 677: , p7_a25 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: )
681: as

Line 678: , p7_a26 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
682: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;

Line 679: , p7_a27 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;
683: ddindx binary_integer; indx binary_integer;

Line 752: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

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

Line 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

Line 758: , p3_a8 DATE := fnd_api.g_miss_date

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

Line 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

Line 763: , p3_a13 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

Line 764: , p3_a14 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

Line 765: , p3_a15 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

Line 766: , p3_a16 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

Line 767: , p3_a17 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

Line 768: , p3_a18 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

Line 769: , p3_a19 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

Line 770: , p3_a20 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

Line 771: , p3_a21 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

Line 772: , p3_a22 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

Line 773: , p3_a23 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

Line 774: , p3_a24 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: )

Line 775: , p3_a25 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: )
779: as

Line 776: , p3_a26 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
780: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;

Line 777: , p3_a27 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;
781: ddindx binary_integer; indx binary_integer;

Line 845: , p0_a2 VARCHAR2 := fnd_api.g_miss_char

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

Line 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

Line 851: , p0_a8 DATE := fnd_api.g_miss_date

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

Line 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

Line 856: , p0_a13 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

Line 857: , p0_a14 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

Line 858: , p0_a15 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

Line 859: , p0_a16 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

Line 860: , p0_a17 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

Line 861: , p0_a18 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

Line 862: , p0_a19 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

Line 863: , p0_a20 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

Line 864: , p0_a21 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

Line 865: , p0_a22 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

Line 866: , p0_a23 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

Line 867: , p0_a24 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: )

Line 868: , p0_a25 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: )
872: as

Line 869: , p0_a26 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
873: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;

Line 870: , p0_a27 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;
874: ddindx binary_integer; indx binary_integer;

Line 926: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

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

Line 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

Line 932: , p5_a8 DATE := fnd_api.g_miss_date

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

Line 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

Line 937: , p5_a13 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

Line 938: , p5_a14 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

Line 939: , p5_a15 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

Line 940: , p5_a16 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

Line 941: , p5_a17 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

Line 942: , p5_a18 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

Line 943: , p5_a19 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

Line 944: , p5_a20 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

Line 945: , p5_a21 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

Line 946: , p5_a22 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

Line 947: , p5_a23 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

Line 948: , p5_a24 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: )

Line 949: , p5_a25 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: )
953: as

Line 950: , p5_a26 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
954: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;

Line 951: , p5_a27 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;
955: ddindx binary_integer; indx binary_integer;

Line 1020: , p7_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 1023: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

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

Line 1024: , p7_a7 DATE := fnd_api.g_miss_date

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

Line 1026: , p7_a9 DATE := fnd_api.g_miss_date

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

Line 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

Line 1031: , p7_a14 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

Line 1032: , p7_a15 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

Line 1033: , p7_a16 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

Line 1034: , p7_a17 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

Line 1035: , p7_a18 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

Line 1036: , p7_a19 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

Line 1037: , p7_a20 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

Line 1038: , p7_a21 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

Line 1039: , p7_a22 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

Line 1040: , p7_a23 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

Line 1041: , p7_a24 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

Line 1042: , p7_a25 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: )

Line 1043: , p7_a26 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: )
1047: as

Line 1044: , p7_a27 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
1048: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;

Line 1045: , p7_a28 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;
1049: ddindx binary_integer; indx binary_integer;

Line 1123: , p7_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 1126: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

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

Line 1127: , p7_a7 DATE := fnd_api.g_miss_date

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

Line 1129: , p7_a9 DATE := fnd_api.g_miss_date

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

Line 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

Line 1134: , p7_a14 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

Line 1135: , p7_a15 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

Line 1136: , p7_a16 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

Line 1137: , p7_a17 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

Line 1138: , p7_a18 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

Line 1139: , p7_a19 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

Line 1140: , p7_a20 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

Line 1141: , p7_a21 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

Line 1142: , p7_a22 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

Line 1143: , p7_a23 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

Line 1144: , p7_a24 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

Line 1145: , p7_a25 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: )

Line 1146: , p7_a26 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: )
1150: as

Line 1147: , p7_a27 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
1151: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;

Line 1148: , p7_a28 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;
1152: ddindx binary_integer; indx binary_integer;

Line 1223: , p3_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 1226: , p3_a6 VARCHAR2 := fnd_api.g_miss_char

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

Line 1227: , p3_a7 DATE := fnd_api.g_miss_date

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

Line 1229: , p3_a9 DATE := fnd_api.g_miss_date

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

Line 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

Line 1234: , p3_a14 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

Line 1235: , p3_a15 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

Line 1236: , p3_a16 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

Line 1237: , p3_a17 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

Line 1238: , p3_a18 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

Line 1239: , p3_a19 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

Line 1240: , p3_a20 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

Line 1241: , p3_a21 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

Line 1242: , p3_a22 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

Line 1243: , p3_a23 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

Line 1244: , p3_a24 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

Line 1245: , p3_a25 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: )

Line 1246: , p3_a26 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: )
1250: as

Line 1247: , p3_a27 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
1251: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;

Line 1248: , p3_a28 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;
1252: ddindx binary_integer; indx binary_integer;

Line 1318: , p0_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 1321: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

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

Line 1322: , p0_a7 DATE := fnd_api.g_miss_date

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

Line 1324: , p0_a9 DATE := fnd_api.g_miss_date

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

Line 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

Line 1329: , p0_a14 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

Line 1330: , p0_a15 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

Line 1331: , p0_a16 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

Line 1332: , p0_a17 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

Line 1333: , p0_a18 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

Line 1334: , p0_a19 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

Line 1335: , p0_a20 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

Line 1336: , p0_a21 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

Line 1337: , p0_a22 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

Line 1338: , p0_a23 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

Line 1339: , p0_a24 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

Line 1340: , p0_a25 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: )

Line 1341: , p0_a26 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: )
1345: as

Line 1342: , p0_a27 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
1346: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;

Line 1343: , p0_a28 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;
1347: ddindx binary_integer; indx binary_integer;

Line 1401: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 1404: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

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

Line 1405: , p5_a7 DATE := fnd_api.g_miss_date

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

Line 1407: , p5_a9 DATE := fnd_api.g_miss_date

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

Line 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

Line 1412: , p5_a14 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

Line 1413: , p5_a15 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

Line 1414: , p5_a16 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

Line 1415: , p5_a17 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

Line 1416: , p5_a18 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

Line 1417: , p5_a19 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

Line 1418: , p5_a20 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

Line 1419: , p5_a21 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

Line 1420: , p5_a22 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

Line 1421: , p5_a23 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

Line 1422: , p5_a24 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

Line 1423: , p5_a25 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: )

Line 1424: , p5_a26 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: )
1428: as

Line 1425: , p5_a27 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
1429: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;

Line 1426: , p5_a28 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;
1430: ddindx binary_integer; indx binary_integer;

Line 1525: , p4_a2 VARCHAR2 := fnd_api.g_miss_char

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

Line 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

Line 1531: , p4_a8 DATE := fnd_api.g_miss_date

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

Line 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

Line 1536: , p4_a13 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

Line 1537: , p4_a14 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

Line 1538: , p4_a15 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

Line 1539: , p4_a16 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

Line 1540: , p4_a17 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

Line 1541: , p4_a18 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

Line 1542: , p4_a19 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

Line 1543: , p4_a20 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

Line 1544: , p4_a21 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

Line 1545: , p4_a22 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

Line 1546: , p4_a23 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

Line 1547: , p4_a24 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: )

Line 1548: , p4_a25 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: )
1552: as

Line 1549: , p4_a26 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
1553: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;

Line 1550: , p4_a27 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;
1554: ddp_web_recomms_tbl ams_web_track_pvt.web_recomms_tbl_type;