5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;
546: , p7_a35 out nocopy JTF_DATE_TABLE
547: , x_record_count out nocopy NUMBER
548: , p5_a0 NUMBER := 0-1962.0724
549: , p5_a1 NUMBER := 0-1962.0724
550: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
547: , x_record_count out nocopy NUMBER
548: , p5_a0 NUMBER := 0-1962.0724
549: , p5_a1 NUMBER := 0-1962.0724
550: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a0 NUMBER := 0-1962.0724
549: , p5_a1 NUMBER := 0-1962.0724
550: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a1 NUMBER := 0-1962.0724
550: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a9 NUMBER := 0-1962.0724
550: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a9 NUMBER := 0-1962.0724
558: , p5_a10 NUMBER := 0-1962.0724
551: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a9 NUMBER := 0-1962.0724
558: , p5_a10 NUMBER := 0-1962.0724
559: , p5_a11 NUMBER := 0-1962.0724
552: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a9 NUMBER := 0-1962.0724
558: , p5_a10 NUMBER := 0-1962.0724
559: , p5_a11 NUMBER := 0-1962.0724
560: , p5_a12 NUMBER := 0-1962.0724
557: , p5_a9 NUMBER := 0-1962.0724
558: , p5_a10 NUMBER := 0-1962.0724
559: , p5_a11 NUMBER := 0-1962.0724
560: , p5_a12 NUMBER := 0-1962.0724
561: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a16 DATE := fnd_api.g_miss_date
565: , p5_a17 DATE := fnd_api.g_miss_date
558: , p5_a10 NUMBER := 0-1962.0724
559: , p5_a11 NUMBER := 0-1962.0724
560: , p5_a12 NUMBER := 0-1962.0724
561: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a16 DATE := fnd_api.g_miss_date
565: , p5_a17 DATE := fnd_api.g_miss_date
566: , p5_a18 DATE := fnd_api.g_miss_date
559: , p5_a11 NUMBER := 0-1962.0724
560: , p5_a12 NUMBER := 0-1962.0724
561: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a16 DATE := fnd_api.g_miss_date
565: , p5_a17 DATE := fnd_api.g_miss_date
566: , p5_a18 DATE := fnd_api.g_miss_date
567: , p5_a19 DATE := fnd_api.g_miss_date
560: , p5_a12 NUMBER := 0-1962.0724
561: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a16 DATE := fnd_api.g_miss_date
565: , p5_a17 DATE := fnd_api.g_miss_date
566: , p5_a18 DATE := fnd_api.g_miss_date
567: , p5_a19 DATE := fnd_api.g_miss_date
568: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
561: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a16 DATE := fnd_api.g_miss_date
565: , p5_a17 DATE := fnd_api.g_miss_date
566: , p5_a18 DATE := fnd_api.g_miss_date
567: , p5_a19 DATE := fnd_api.g_miss_date
568: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
562: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
563: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a16 DATE := fnd_api.g_miss_date
565: , p5_a17 DATE := fnd_api.g_miss_date
566: , p5_a18 DATE := fnd_api.g_miss_date
567: , p5_a19 DATE := fnd_api.g_miss_date
568: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a22 NUMBER := 0-1962.0724
563: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
564: , p5_a16 DATE := fnd_api.g_miss_date
565: , p5_a17 DATE := fnd_api.g_miss_date
566: , p5_a18 DATE := fnd_api.g_miss_date
567: , p5_a19 DATE := fnd_api.g_miss_date
568: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a22 NUMBER := 0-1962.0724
571: , p5_a23 NUMBER := 0-1962.0724
564: , p5_a16 DATE := fnd_api.g_miss_date
565: , p5_a17 DATE := fnd_api.g_miss_date
566: , p5_a18 DATE := fnd_api.g_miss_date
567: , p5_a19 DATE := fnd_api.g_miss_date
568: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a22 NUMBER := 0-1962.0724
571: , p5_a23 NUMBER := 0-1962.0724
572: , p5_a24 NUMBER := 0-1962.0724
565: , p5_a17 DATE := fnd_api.g_miss_date
566: , p5_a18 DATE := fnd_api.g_miss_date
567: , p5_a19 DATE := fnd_api.g_miss_date
568: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a22 NUMBER := 0-1962.0724
571: , p5_a23 NUMBER := 0-1962.0724
572: , p5_a24 NUMBER := 0-1962.0724
573: , p5_a25 NUMBER := 0-1962.0724
570: , p5_a22 NUMBER := 0-1962.0724
571: , p5_a23 NUMBER := 0-1962.0724
572: , p5_a24 NUMBER := 0-1962.0724
573: , p5_a25 NUMBER := 0-1962.0724
574: , p5_a26 DATE := fnd_api.g_miss_date
575: , p5_a27 DATE := fnd_api.g_miss_date
576: , p5_a28 NUMBER := 0-1962.0724
577: , p5_a29 NUMBER := 0-1962.0724
578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a23 NUMBER := 0-1962.0724
572: , p5_a24 NUMBER := 0-1962.0724
573: , p5_a25 NUMBER := 0-1962.0724
574: , p5_a26 DATE := fnd_api.g_miss_date
575: , p5_a27 DATE := fnd_api.g_miss_date
576: , p5_a28 NUMBER := 0-1962.0724
577: , p5_a29 NUMBER := 0-1962.0724
578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a31 DATE := fnd_api.g_miss_date
574: , p5_a26 DATE := fnd_api.g_miss_date
575: , p5_a27 DATE := fnd_api.g_miss_date
576: , p5_a28 NUMBER := 0-1962.0724
577: , p5_a29 NUMBER := 0-1962.0724
578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a31 DATE := fnd_api.g_miss_date
580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a33 NUMBER := 0-1962.0724
582: , p5_a34 DATE := fnd_api.g_miss_date
575: , p5_a27 DATE := fnd_api.g_miss_date
576: , p5_a28 NUMBER := 0-1962.0724
577: , p5_a29 NUMBER := 0-1962.0724
578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a31 DATE := fnd_api.g_miss_date
580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a33 NUMBER := 0-1962.0724
582: , p5_a34 DATE := fnd_api.g_miss_date
583: , p5_a35 NUMBER := 0-1962.0724
576: , p5_a28 NUMBER := 0-1962.0724
577: , p5_a29 NUMBER := 0-1962.0724
578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a31 DATE := fnd_api.g_miss_date
580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a33 NUMBER := 0-1962.0724
582: , p5_a34 DATE := fnd_api.g_miss_date
583: , p5_a35 NUMBER := 0-1962.0724
584: , p5_a36 NUMBER := 0-1962.0724
578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a31 DATE := fnd_api.g_miss_date
580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a33 NUMBER := 0-1962.0724
582: , p5_a34 DATE := fnd_api.g_miss_date
583: , p5_a35 NUMBER := 0-1962.0724
584: , p5_a36 NUMBER := 0-1962.0724
585: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a33 NUMBER := 0-1962.0724
582: , p5_a34 DATE := fnd_api.g_miss_date
583: , p5_a35 NUMBER := 0-1962.0724
584: , p5_a36 NUMBER := 0-1962.0724
585: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a40 DATE := fnd_api.g_miss_date
589: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a34 DATE := fnd_api.g_miss_date
583: , p5_a35 NUMBER := 0-1962.0724
584: , p5_a36 NUMBER := 0-1962.0724
585: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a40 DATE := fnd_api.g_miss_date
589: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a35 NUMBER := 0-1962.0724
584: , p5_a36 NUMBER := 0-1962.0724
585: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a40 DATE := fnd_api.g_miss_date
589: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a36 NUMBER := 0-1962.0724
585: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a40 DATE := fnd_api.g_miss_date
589: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a40 DATE := fnd_api.g_miss_date
589: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a40 DATE := fnd_api.g_miss_date
589: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a46 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a40 DATE := fnd_api.g_miss_date
589: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a46 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a40 DATE := fnd_api.g_miss_date
589: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a46 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a46 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a46 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a50 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a43 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a46 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a50 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a44 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a46 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a50 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a46 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a50 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a46 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a50 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a47 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a50 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a50 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a56 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a50 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a56 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a57 DATE := fnd_api.g_miss_date
598: , p5_a50 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a56 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a57 DATE := fnd_api.g_miss_date
606: , p5_a58 NUMBER := 0-1962.0724
599: , p5_a51 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a56 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a57 DATE := fnd_api.g_miss_date
606: , p5_a58 NUMBER := 0-1962.0724
607: , p5_a59 NUMBER := 0-1962.0724
600: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a56 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a57 DATE := fnd_api.g_miss_date
606: , p5_a58 NUMBER := 0-1962.0724
607: , p5_a59 NUMBER := 0-1962.0724
608: , p5_a60 NUMBER := 0-1962.0724
601: , p5_a53 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a54 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a55 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a56 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a57 DATE := fnd_api.g_miss_date
606: , p5_a58 NUMBER := 0-1962.0724
607: , p5_a59 NUMBER := 0-1962.0724
608: , p5_a60 NUMBER := 0-1962.0724
609: , p5_a61 NUMBER := 0-1962.0724
607: , p5_a59 NUMBER := 0-1962.0724
608: , p5_a60 NUMBER := 0-1962.0724
609: , p5_a61 NUMBER := 0-1962.0724
610: , p5_a62 NUMBER := 0-1962.0724
611: , p5_a63 DATE := fnd_api.g_miss_date
612: , p5_a64 NUMBER := 0-1962.0724
613: , p5_a65 DATE := fnd_api.g_miss_date
614: , p5_a66 NUMBER := 0-1962.0724
615: , p5_a67 DATE := fnd_api.g_miss_date
609: , p5_a61 NUMBER := 0-1962.0724
610: , p5_a62 NUMBER := 0-1962.0724
611: , p5_a63 DATE := fnd_api.g_miss_date
612: , p5_a64 NUMBER := 0-1962.0724
613: , p5_a65 DATE := fnd_api.g_miss_date
614: , p5_a66 NUMBER := 0-1962.0724
615: , p5_a67 DATE := fnd_api.g_miss_date
616: , p5_a68 NUMBER := 0-1962.0724
617: , p5_a69 NUMBER := 0-1962.0724
611: , p5_a63 DATE := fnd_api.g_miss_date
612: , p5_a64 NUMBER := 0-1962.0724
613: , p5_a65 DATE := fnd_api.g_miss_date
614: , p5_a66 NUMBER := 0-1962.0724
615: , p5_a67 DATE := fnd_api.g_miss_date
616: , p5_a68 NUMBER := 0-1962.0724
617: , p5_a69 NUMBER := 0-1962.0724
618: , p5_a70 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a71 NUMBER := 0-1962.0724
614: , p5_a66 NUMBER := 0-1962.0724
615: , p5_a67 DATE := fnd_api.g_miss_date
616: , p5_a68 NUMBER := 0-1962.0724
617: , p5_a69 NUMBER := 0-1962.0724
618: , p5_a70 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a71 NUMBER := 0-1962.0724
620: , p5_a72 NUMBER := 0-1962.0724
621: , p5_a73 NUMBER := 0-1962.0724
622: , p5_a74 NUMBER := 0-1962.0724
619: , p5_a71 NUMBER := 0-1962.0724
620: , p5_a72 NUMBER := 0-1962.0724
621: , p5_a73 NUMBER := 0-1962.0724
622: , p5_a74 NUMBER := 0-1962.0724
623: , p5_a75 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a76 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a77 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a78 NUMBER := 0-1962.0724
627: , p5_a79 DATE := fnd_api.g_miss_date
620: , p5_a72 NUMBER := 0-1962.0724
621: , p5_a73 NUMBER := 0-1962.0724
622: , p5_a74 NUMBER := 0-1962.0724
623: , p5_a75 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a76 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a77 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a78 NUMBER := 0-1962.0724
627: , p5_a79 DATE := fnd_api.g_miss_date
628: )
621: , p5_a73 NUMBER := 0-1962.0724
622: , p5_a74 NUMBER := 0-1962.0724
623: , p5_a75 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a76 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a77 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a78 NUMBER := 0-1962.0724
627: , p5_a79 DATE := fnd_api.g_miss_date
628: )
629:
623: , p5_a75 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a76 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a77 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a78 NUMBER := 0-1962.0724
627: , p5_a79 DATE := fnd_api.g_miss_date
628: )
629:
630: as
631: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;
827: , p2_a19 out nocopy JTF_NUMBER_TABLE
828: , x_return_status out nocopy VARCHAR2
829: , p0_a0 NUMBER := 0-1962.0724
830: , p0_a1 NUMBER := 0-1962.0724
831: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
832: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
833: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
834: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
835: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
828: , x_return_status out nocopy VARCHAR2
829: , p0_a0 NUMBER := 0-1962.0724
830: , p0_a1 NUMBER := 0-1962.0724
831: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
832: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
833: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
834: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
835: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
836: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
829: , p0_a0 NUMBER := 0-1962.0724
830: , p0_a1 NUMBER := 0-1962.0724
831: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
832: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
833: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
834: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
835: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
836: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
837: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
830: , p0_a1 NUMBER := 0-1962.0724
831: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
832: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
833: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
834: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
835: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
836: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
837: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
838: , p0_a9 NUMBER := 0-1962.0724
831: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
832: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
833: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
834: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
835: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
836: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
837: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
838: , p0_a9 NUMBER := 0-1962.0724
839: , p0_a10 NUMBER := 0-1962.0724
832: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
833: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
834: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
835: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
836: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
837: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
838: , p0_a9 NUMBER := 0-1962.0724
839: , p0_a10 NUMBER := 0-1962.0724
840: , p0_a11 NUMBER := 0-1962.0724
833: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
834: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
835: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
836: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
837: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
838: , p0_a9 NUMBER := 0-1962.0724
839: , p0_a10 NUMBER := 0-1962.0724
840: , p0_a11 NUMBER := 0-1962.0724
841: , p0_a12 NUMBER := 0-1962.0724
838: , p0_a9 NUMBER := 0-1962.0724
839: , p0_a10 NUMBER := 0-1962.0724
840: , p0_a11 NUMBER := 0-1962.0724
841: , p0_a12 NUMBER := 0-1962.0724
842: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
843: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
844: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
845: , p0_a16 DATE := fnd_api.g_miss_date
846: , p0_a17 DATE := fnd_api.g_miss_date
839: , p0_a10 NUMBER := 0-1962.0724
840: , p0_a11 NUMBER := 0-1962.0724
841: , p0_a12 NUMBER := 0-1962.0724
842: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
843: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
844: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
845: , p0_a16 DATE := fnd_api.g_miss_date
846: , p0_a17 DATE := fnd_api.g_miss_date
847: , p0_a18 DATE := fnd_api.g_miss_date
840: , p0_a11 NUMBER := 0-1962.0724
841: , p0_a12 NUMBER := 0-1962.0724
842: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
843: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
844: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
845: , p0_a16 DATE := fnd_api.g_miss_date
846: , p0_a17 DATE := fnd_api.g_miss_date
847: , p0_a18 DATE := fnd_api.g_miss_date
848: , p0_a19 DATE := fnd_api.g_miss_date
841: , p0_a12 NUMBER := 0-1962.0724
842: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
843: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
844: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
845: , p0_a16 DATE := fnd_api.g_miss_date
846: , p0_a17 DATE := fnd_api.g_miss_date
847: , p0_a18 DATE := fnd_api.g_miss_date
848: , p0_a19 DATE := fnd_api.g_miss_date
849: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
842: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
843: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
844: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
845: , p0_a16 DATE := fnd_api.g_miss_date
846: , p0_a17 DATE := fnd_api.g_miss_date
847: , p0_a18 DATE := fnd_api.g_miss_date
848: , p0_a19 DATE := fnd_api.g_miss_date
849: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
850: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
843: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
844: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
845: , p0_a16 DATE := fnd_api.g_miss_date
846: , p0_a17 DATE := fnd_api.g_miss_date
847: , p0_a18 DATE := fnd_api.g_miss_date
848: , p0_a19 DATE := fnd_api.g_miss_date
849: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
850: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
851: , p0_a22 NUMBER := 0-1962.0724
844: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
845: , p0_a16 DATE := fnd_api.g_miss_date
846: , p0_a17 DATE := fnd_api.g_miss_date
847: , p0_a18 DATE := fnd_api.g_miss_date
848: , p0_a19 DATE := fnd_api.g_miss_date
849: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
850: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
851: , p0_a22 NUMBER := 0-1962.0724
852: , p0_a23 NUMBER := 0-1962.0724
845: , p0_a16 DATE := fnd_api.g_miss_date
846: , p0_a17 DATE := fnd_api.g_miss_date
847: , p0_a18 DATE := fnd_api.g_miss_date
848: , p0_a19 DATE := fnd_api.g_miss_date
849: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
850: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
851: , p0_a22 NUMBER := 0-1962.0724
852: , p0_a23 NUMBER := 0-1962.0724
853: , p0_a24 NUMBER := 0-1962.0724
846: , p0_a17 DATE := fnd_api.g_miss_date
847: , p0_a18 DATE := fnd_api.g_miss_date
848: , p0_a19 DATE := fnd_api.g_miss_date
849: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
850: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
851: , p0_a22 NUMBER := 0-1962.0724
852: , p0_a23 NUMBER := 0-1962.0724
853: , p0_a24 NUMBER := 0-1962.0724
854: , p0_a25 NUMBER := 0-1962.0724
851: , p0_a22 NUMBER := 0-1962.0724
852: , p0_a23 NUMBER := 0-1962.0724
853: , p0_a24 NUMBER := 0-1962.0724
854: , p0_a25 NUMBER := 0-1962.0724
855: , p0_a26 DATE := fnd_api.g_miss_date
856: , p0_a27 DATE := fnd_api.g_miss_date
857: , p0_a28 NUMBER := 0-1962.0724
858: , p0_a29 NUMBER := 0-1962.0724
859: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
852: , p0_a23 NUMBER := 0-1962.0724
853: , p0_a24 NUMBER := 0-1962.0724
854: , p0_a25 NUMBER := 0-1962.0724
855: , p0_a26 DATE := fnd_api.g_miss_date
856: , p0_a27 DATE := fnd_api.g_miss_date
857: , p0_a28 NUMBER := 0-1962.0724
858: , p0_a29 NUMBER := 0-1962.0724
859: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a31 DATE := fnd_api.g_miss_date
855: , p0_a26 DATE := fnd_api.g_miss_date
856: , p0_a27 DATE := fnd_api.g_miss_date
857: , p0_a28 NUMBER := 0-1962.0724
858: , p0_a29 NUMBER := 0-1962.0724
859: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a31 DATE := fnd_api.g_miss_date
861: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a33 NUMBER := 0-1962.0724
863: , p0_a34 DATE := fnd_api.g_miss_date
856: , p0_a27 DATE := fnd_api.g_miss_date
857: , p0_a28 NUMBER := 0-1962.0724
858: , p0_a29 NUMBER := 0-1962.0724
859: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a31 DATE := fnd_api.g_miss_date
861: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a33 NUMBER := 0-1962.0724
863: , p0_a34 DATE := fnd_api.g_miss_date
864: , p0_a35 NUMBER := 0-1962.0724
857: , p0_a28 NUMBER := 0-1962.0724
858: , p0_a29 NUMBER := 0-1962.0724
859: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a31 DATE := fnd_api.g_miss_date
861: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a33 NUMBER := 0-1962.0724
863: , p0_a34 DATE := fnd_api.g_miss_date
864: , p0_a35 NUMBER := 0-1962.0724
865: , p0_a36 NUMBER := 0-1962.0724
859: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
860: , p0_a31 DATE := fnd_api.g_miss_date
861: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a33 NUMBER := 0-1962.0724
863: , p0_a34 DATE := fnd_api.g_miss_date
864: , p0_a35 NUMBER := 0-1962.0724
865: , p0_a36 NUMBER := 0-1962.0724
866: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
862: , p0_a33 NUMBER := 0-1962.0724
863: , p0_a34 DATE := fnd_api.g_miss_date
864: , p0_a35 NUMBER := 0-1962.0724
865: , p0_a36 NUMBER := 0-1962.0724
866: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a40 DATE := fnd_api.g_miss_date
870: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
863: , p0_a34 DATE := fnd_api.g_miss_date
864: , p0_a35 NUMBER := 0-1962.0724
865: , p0_a36 NUMBER := 0-1962.0724
866: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a40 DATE := fnd_api.g_miss_date
870: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
871: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
864: , p0_a35 NUMBER := 0-1962.0724
865: , p0_a36 NUMBER := 0-1962.0724
866: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a40 DATE := fnd_api.g_miss_date
870: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
871: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
872: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
865: , p0_a36 NUMBER := 0-1962.0724
866: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a40 DATE := fnd_api.g_miss_date
870: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
871: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
872: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
873: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
866: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a40 DATE := fnd_api.g_miss_date
870: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
871: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
872: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
873: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
874: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
867: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a40 DATE := fnd_api.g_miss_date
870: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
871: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
872: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
873: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
874: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
875: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
868: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a40 DATE := fnd_api.g_miss_date
870: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
871: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
872: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
873: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
874: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
875: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
876: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
869: , p0_a40 DATE := fnd_api.g_miss_date
870: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
871: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
872: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
873: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
874: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
875: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
876: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
877: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
870: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
871: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
872: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
873: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
874: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
875: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
876: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
877: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
878: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
871: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
872: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
873: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
874: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
875: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
876: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
877: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
878: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
879: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
872: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
873: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
874: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
875: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
876: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
877: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
878: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
879: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
880: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
873: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
874: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
875: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
876: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
877: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
878: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
879: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
880: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
881: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
874: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
875: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
876: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
877: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
878: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
879: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
880: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
881: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
882: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
875: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
876: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
877: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
878: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
879: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
880: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
881: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
882: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
883: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
876: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
877: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
878: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
879: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
880: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
881: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
882: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
883: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
884: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
877: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
878: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
879: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
880: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
881: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
882: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
883: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
884: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
885: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
878: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
879: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
880: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
881: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
882: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
883: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
884: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
885: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
886: , p0_a57 DATE := fnd_api.g_miss_date
879: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
880: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
881: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
882: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
883: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
884: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
885: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
886: , p0_a57 DATE := fnd_api.g_miss_date
887: , p0_a58 NUMBER := 0-1962.0724
880: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
881: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
882: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
883: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
884: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
885: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
886: , p0_a57 DATE := fnd_api.g_miss_date
887: , p0_a58 NUMBER := 0-1962.0724
888: , p0_a59 NUMBER := 0-1962.0724
881: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
882: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
883: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
884: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
885: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
886: , p0_a57 DATE := fnd_api.g_miss_date
887: , p0_a58 NUMBER := 0-1962.0724
888: , p0_a59 NUMBER := 0-1962.0724
889: , p0_a60 NUMBER := 0-1962.0724
882: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
883: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
884: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
885: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
886: , p0_a57 DATE := fnd_api.g_miss_date
887: , p0_a58 NUMBER := 0-1962.0724
888: , p0_a59 NUMBER := 0-1962.0724
889: , p0_a60 NUMBER := 0-1962.0724
890: , p0_a61 NUMBER := 0-1962.0724
888: , p0_a59 NUMBER := 0-1962.0724
889: , p0_a60 NUMBER := 0-1962.0724
890: , p0_a61 NUMBER := 0-1962.0724
891: , p0_a62 NUMBER := 0-1962.0724
892: , p0_a63 DATE := fnd_api.g_miss_date
893: , p0_a64 NUMBER := 0-1962.0724
894: , p0_a65 DATE := fnd_api.g_miss_date
895: , p0_a66 NUMBER := 0-1962.0724
896: , p0_a67 DATE := fnd_api.g_miss_date
890: , p0_a61 NUMBER := 0-1962.0724
891: , p0_a62 NUMBER := 0-1962.0724
892: , p0_a63 DATE := fnd_api.g_miss_date
893: , p0_a64 NUMBER := 0-1962.0724
894: , p0_a65 DATE := fnd_api.g_miss_date
895: , p0_a66 NUMBER := 0-1962.0724
896: , p0_a67 DATE := fnd_api.g_miss_date
897: , p0_a68 NUMBER := 0-1962.0724
898: , p0_a69 NUMBER := 0-1962.0724
892: , p0_a63 DATE := fnd_api.g_miss_date
893: , p0_a64 NUMBER := 0-1962.0724
894: , p0_a65 DATE := fnd_api.g_miss_date
895: , p0_a66 NUMBER := 0-1962.0724
896: , p0_a67 DATE := fnd_api.g_miss_date
897: , p0_a68 NUMBER := 0-1962.0724
898: , p0_a69 NUMBER := 0-1962.0724
899: , p0_a70 VARCHAR2 := fnd_api.g_miss_char
900: , p0_a71 NUMBER := 0-1962.0724
895: , p0_a66 NUMBER := 0-1962.0724
896: , p0_a67 DATE := fnd_api.g_miss_date
897: , p0_a68 NUMBER := 0-1962.0724
898: , p0_a69 NUMBER := 0-1962.0724
899: , p0_a70 VARCHAR2 := fnd_api.g_miss_char
900: , p0_a71 NUMBER := 0-1962.0724
901: , p0_a72 NUMBER := 0-1962.0724
902: , p0_a73 NUMBER := 0-1962.0724
903: , p0_a74 NUMBER := 0-1962.0724
900: , p0_a71 NUMBER := 0-1962.0724
901: , p0_a72 NUMBER := 0-1962.0724
902: , p0_a73 NUMBER := 0-1962.0724
903: , p0_a74 NUMBER := 0-1962.0724
904: , p0_a75 VARCHAR2 := fnd_api.g_miss_char
905: , p0_a76 VARCHAR2 := fnd_api.g_miss_char
906: , p0_a77 VARCHAR2 := fnd_api.g_miss_char
907: , p0_a78 NUMBER := 0-1962.0724
908: , p0_a79 DATE := fnd_api.g_miss_date
901: , p0_a72 NUMBER := 0-1962.0724
902: , p0_a73 NUMBER := 0-1962.0724
903: , p0_a74 NUMBER := 0-1962.0724
904: , p0_a75 VARCHAR2 := fnd_api.g_miss_char
905: , p0_a76 VARCHAR2 := fnd_api.g_miss_char
906: , p0_a77 VARCHAR2 := fnd_api.g_miss_char
907: , p0_a78 NUMBER := 0-1962.0724
908: , p0_a79 DATE := fnd_api.g_miss_date
909: )
902: , p0_a73 NUMBER := 0-1962.0724
903: , p0_a74 NUMBER := 0-1962.0724
904: , p0_a75 VARCHAR2 := fnd_api.g_miss_char
905: , p0_a76 VARCHAR2 := fnd_api.g_miss_char
906: , p0_a77 VARCHAR2 := fnd_api.g_miss_char
907: , p0_a78 NUMBER := 0-1962.0724
908: , p0_a79 DATE := fnd_api.g_miss_date
909: )
910:
904: , p0_a75 VARCHAR2 := fnd_api.g_miss_char
905: , p0_a76 VARCHAR2 := fnd_api.g_miss_char
906: , p0_a77 VARCHAR2 := fnd_api.g_miss_char
907: , p0_a78 NUMBER := 0-1962.0724
908: , p0_a79 DATE := fnd_api.g_miss_date
909: )
910:
911: as
912: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;
1082: , p3_a19 out nocopy JTF_NUMBER_TABLE
1083: , x_return_status out nocopy VARCHAR2
1084: , p0_a0 NUMBER := 0-1962.0724
1085: , p0_a1 NUMBER := 0-1962.0724
1086: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
1087: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1088: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1089: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
1090: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
1083: , x_return_status out nocopy VARCHAR2
1084: , p0_a0 NUMBER := 0-1962.0724
1085: , p0_a1 NUMBER := 0-1962.0724
1086: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
1087: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1088: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1089: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
1090: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
1091: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
1084: , p0_a0 NUMBER := 0-1962.0724
1085: , p0_a1 NUMBER := 0-1962.0724
1086: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
1087: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1088: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1089: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
1090: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
1091: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
1092: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
1085: , p0_a1 NUMBER := 0-1962.0724
1086: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
1087: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1088: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1089: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
1090: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
1091: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
1092: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
1093: , p0_a9 NUMBER := 0-1962.0724
1086: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
1087: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1088: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1089: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
1090: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
1091: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
1092: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
1093: , p0_a9 NUMBER := 0-1962.0724
1094: , p0_a10 NUMBER := 0-1962.0724
1087: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1088: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1089: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
1090: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
1091: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
1092: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
1093: , p0_a9 NUMBER := 0-1962.0724
1094: , p0_a10 NUMBER := 0-1962.0724
1095: , p0_a11 NUMBER := 0-1962.0724
1088: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1089: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
1090: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
1091: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
1092: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
1093: , p0_a9 NUMBER := 0-1962.0724
1094: , p0_a10 NUMBER := 0-1962.0724
1095: , p0_a11 NUMBER := 0-1962.0724
1096: , p0_a12 NUMBER := 0-1962.0724
1093: , p0_a9 NUMBER := 0-1962.0724
1094: , p0_a10 NUMBER := 0-1962.0724
1095: , p0_a11 NUMBER := 0-1962.0724
1096: , p0_a12 NUMBER := 0-1962.0724
1097: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1098: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1099: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1100: , p0_a16 DATE := fnd_api.g_miss_date
1101: , p0_a17 DATE := fnd_api.g_miss_date
1094: , p0_a10 NUMBER := 0-1962.0724
1095: , p0_a11 NUMBER := 0-1962.0724
1096: , p0_a12 NUMBER := 0-1962.0724
1097: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1098: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1099: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1100: , p0_a16 DATE := fnd_api.g_miss_date
1101: , p0_a17 DATE := fnd_api.g_miss_date
1102: , p0_a18 DATE := fnd_api.g_miss_date
1095: , p0_a11 NUMBER := 0-1962.0724
1096: , p0_a12 NUMBER := 0-1962.0724
1097: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1098: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1099: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1100: , p0_a16 DATE := fnd_api.g_miss_date
1101: , p0_a17 DATE := fnd_api.g_miss_date
1102: , p0_a18 DATE := fnd_api.g_miss_date
1103: , p0_a19 DATE := fnd_api.g_miss_date
1096: , p0_a12 NUMBER := 0-1962.0724
1097: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1098: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1099: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1100: , p0_a16 DATE := fnd_api.g_miss_date
1101: , p0_a17 DATE := fnd_api.g_miss_date
1102: , p0_a18 DATE := fnd_api.g_miss_date
1103: , p0_a19 DATE := fnd_api.g_miss_date
1104: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1097: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1098: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1099: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1100: , p0_a16 DATE := fnd_api.g_miss_date
1101: , p0_a17 DATE := fnd_api.g_miss_date
1102: , p0_a18 DATE := fnd_api.g_miss_date
1103: , p0_a19 DATE := fnd_api.g_miss_date
1104: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1105: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1098: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1099: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1100: , p0_a16 DATE := fnd_api.g_miss_date
1101: , p0_a17 DATE := fnd_api.g_miss_date
1102: , p0_a18 DATE := fnd_api.g_miss_date
1103: , p0_a19 DATE := fnd_api.g_miss_date
1104: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1105: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1106: , p0_a22 NUMBER := 0-1962.0724
1099: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1100: , p0_a16 DATE := fnd_api.g_miss_date
1101: , p0_a17 DATE := fnd_api.g_miss_date
1102: , p0_a18 DATE := fnd_api.g_miss_date
1103: , p0_a19 DATE := fnd_api.g_miss_date
1104: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1105: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1106: , p0_a22 NUMBER := 0-1962.0724
1107: , p0_a23 NUMBER := 0-1962.0724
1100: , p0_a16 DATE := fnd_api.g_miss_date
1101: , p0_a17 DATE := fnd_api.g_miss_date
1102: , p0_a18 DATE := fnd_api.g_miss_date
1103: , p0_a19 DATE := fnd_api.g_miss_date
1104: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1105: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1106: , p0_a22 NUMBER := 0-1962.0724
1107: , p0_a23 NUMBER := 0-1962.0724
1108: , p0_a24 NUMBER := 0-1962.0724
1101: , p0_a17 DATE := fnd_api.g_miss_date
1102: , p0_a18 DATE := fnd_api.g_miss_date
1103: , p0_a19 DATE := fnd_api.g_miss_date
1104: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1105: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1106: , p0_a22 NUMBER := 0-1962.0724
1107: , p0_a23 NUMBER := 0-1962.0724
1108: , p0_a24 NUMBER := 0-1962.0724
1109: , p0_a25 NUMBER := 0-1962.0724
1106: , p0_a22 NUMBER := 0-1962.0724
1107: , p0_a23 NUMBER := 0-1962.0724
1108: , p0_a24 NUMBER := 0-1962.0724
1109: , p0_a25 NUMBER := 0-1962.0724
1110: , p0_a26 DATE := fnd_api.g_miss_date
1111: , p0_a27 DATE := fnd_api.g_miss_date
1112: , p0_a28 NUMBER := 0-1962.0724
1113: , p0_a29 NUMBER := 0-1962.0724
1114: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
1107: , p0_a23 NUMBER := 0-1962.0724
1108: , p0_a24 NUMBER := 0-1962.0724
1109: , p0_a25 NUMBER := 0-1962.0724
1110: , p0_a26 DATE := fnd_api.g_miss_date
1111: , p0_a27 DATE := fnd_api.g_miss_date
1112: , p0_a28 NUMBER := 0-1962.0724
1113: , p0_a29 NUMBER := 0-1962.0724
1114: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
1115: , p0_a31 DATE := fnd_api.g_miss_date
1110: , p0_a26 DATE := fnd_api.g_miss_date
1111: , p0_a27 DATE := fnd_api.g_miss_date
1112: , p0_a28 NUMBER := 0-1962.0724
1113: , p0_a29 NUMBER := 0-1962.0724
1114: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
1115: , p0_a31 DATE := fnd_api.g_miss_date
1116: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
1117: , p0_a33 NUMBER := 0-1962.0724
1118: , p0_a34 DATE := fnd_api.g_miss_date
1111: , p0_a27 DATE := fnd_api.g_miss_date
1112: , p0_a28 NUMBER := 0-1962.0724
1113: , p0_a29 NUMBER := 0-1962.0724
1114: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
1115: , p0_a31 DATE := fnd_api.g_miss_date
1116: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
1117: , p0_a33 NUMBER := 0-1962.0724
1118: , p0_a34 DATE := fnd_api.g_miss_date
1119: , p0_a35 NUMBER := 0-1962.0724
1112: , p0_a28 NUMBER := 0-1962.0724
1113: , p0_a29 NUMBER := 0-1962.0724
1114: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
1115: , p0_a31 DATE := fnd_api.g_miss_date
1116: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
1117: , p0_a33 NUMBER := 0-1962.0724
1118: , p0_a34 DATE := fnd_api.g_miss_date
1119: , p0_a35 NUMBER := 0-1962.0724
1120: , p0_a36 NUMBER := 0-1962.0724
1114: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
1115: , p0_a31 DATE := fnd_api.g_miss_date
1116: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
1117: , p0_a33 NUMBER := 0-1962.0724
1118: , p0_a34 DATE := fnd_api.g_miss_date
1119: , p0_a35 NUMBER := 0-1962.0724
1120: , p0_a36 NUMBER := 0-1962.0724
1121: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
1122: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1117: , p0_a33 NUMBER := 0-1962.0724
1118: , p0_a34 DATE := fnd_api.g_miss_date
1119: , p0_a35 NUMBER := 0-1962.0724
1120: , p0_a36 NUMBER := 0-1962.0724
1121: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
1122: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1123: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1124: , p0_a40 DATE := fnd_api.g_miss_date
1125: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
1118: , p0_a34 DATE := fnd_api.g_miss_date
1119: , p0_a35 NUMBER := 0-1962.0724
1120: , p0_a36 NUMBER := 0-1962.0724
1121: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
1122: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1123: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1124: , p0_a40 DATE := fnd_api.g_miss_date
1125: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
1126: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
1119: , p0_a35 NUMBER := 0-1962.0724
1120: , p0_a36 NUMBER := 0-1962.0724
1121: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
1122: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1123: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1124: , p0_a40 DATE := fnd_api.g_miss_date
1125: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
1126: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
1127: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1120: , p0_a36 NUMBER := 0-1962.0724
1121: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
1122: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1123: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1124: , p0_a40 DATE := fnd_api.g_miss_date
1125: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
1126: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
1127: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1128: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1121: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
1122: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1123: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1124: , p0_a40 DATE := fnd_api.g_miss_date
1125: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
1126: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
1127: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1128: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1129: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1122: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1123: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1124: , p0_a40 DATE := fnd_api.g_miss_date
1125: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
1126: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
1127: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1128: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1129: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1130: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1123: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1124: , p0_a40 DATE := fnd_api.g_miss_date
1125: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
1126: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
1127: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1128: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1129: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1130: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1131: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1124: , p0_a40 DATE := fnd_api.g_miss_date
1125: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
1126: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
1127: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1128: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1129: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1130: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1131: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1132: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1125: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
1126: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
1127: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1128: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1129: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1130: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1131: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1132: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1133: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1126: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
1127: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1128: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1129: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1130: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1131: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1132: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1133: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1134: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1127: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1128: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1129: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1130: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1131: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1132: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1133: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1134: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1135: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1128: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1129: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1130: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1131: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1132: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1133: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1134: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1135: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1136: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1129: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1130: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1131: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1132: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1133: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1134: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1135: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1136: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1137: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1130: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1131: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1132: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1133: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1134: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1135: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1136: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1137: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1138: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1131: , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1132: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1133: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1134: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1135: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1136: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1137: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1138: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1139: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1132: , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1133: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1134: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1135: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1136: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1137: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1138: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1139: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1140: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1133: , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1134: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1135: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1136: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1137: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1138: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1139: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1140: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1141: , p0_a57 DATE := fnd_api.g_miss_date
1134: , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1135: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1136: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1137: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1138: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1139: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1140: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1141: , p0_a57 DATE := fnd_api.g_miss_date
1142: , p0_a58 NUMBER := 0-1962.0724
1135: , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1136: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1137: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1138: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1139: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1140: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1141: , p0_a57 DATE := fnd_api.g_miss_date
1142: , p0_a58 NUMBER := 0-1962.0724
1143: , p0_a59 NUMBER := 0-1962.0724
1136: , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1137: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1138: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1139: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1140: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1141: , p0_a57 DATE := fnd_api.g_miss_date
1142: , p0_a58 NUMBER := 0-1962.0724
1143: , p0_a59 NUMBER := 0-1962.0724
1144: , p0_a60 NUMBER := 0-1962.0724
1137: , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1138: , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1139: , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1140: , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1141: , p0_a57 DATE := fnd_api.g_miss_date
1142: , p0_a58 NUMBER := 0-1962.0724
1143: , p0_a59 NUMBER := 0-1962.0724
1144: , p0_a60 NUMBER := 0-1962.0724
1145: , p0_a61 NUMBER := 0-1962.0724
1143: , p0_a59 NUMBER := 0-1962.0724
1144: , p0_a60 NUMBER := 0-1962.0724
1145: , p0_a61 NUMBER := 0-1962.0724
1146: , p0_a62 NUMBER := 0-1962.0724
1147: , p0_a63 DATE := fnd_api.g_miss_date
1148: , p0_a64 NUMBER := 0-1962.0724
1149: , p0_a65 DATE := fnd_api.g_miss_date
1150: , p0_a66 NUMBER := 0-1962.0724
1151: , p0_a67 DATE := fnd_api.g_miss_date
1145: , p0_a61 NUMBER := 0-1962.0724
1146: , p0_a62 NUMBER := 0-1962.0724
1147: , p0_a63 DATE := fnd_api.g_miss_date
1148: , p0_a64 NUMBER := 0-1962.0724
1149: , p0_a65 DATE := fnd_api.g_miss_date
1150: , p0_a66 NUMBER := 0-1962.0724
1151: , p0_a67 DATE := fnd_api.g_miss_date
1152: , p0_a68 NUMBER := 0-1962.0724
1153: , p0_a69 NUMBER := 0-1962.0724
1147: , p0_a63 DATE := fnd_api.g_miss_date
1148: , p0_a64 NUMBER := 0-1962.0724
1149: , p0_a65 DATE := fnd_api.g_miss_date
1150: , p0_a66 NUMBER := 0-1962.0724
1151: , p0_a67 DATE := fnd_api.g_miss_date
1152: , p0_a68 NUMBER := 0-1962.0724
1153: , p0_a69 NUMBER := 0-1962.0724
1154: , p0_a70 VARCHAR2 := fnd_api.g_miss_char
1155: , p0_a71 NUMBER := 0-1962.0724
1150: , p0_a66 NUMBER := 0-1962.0724
1151: , p0_a67 DATE := fnd_api.g_miss_date
1152: , p0_a68 NUMBER := 0-1962.0724
1153: , p0_a69 NUMBER := 0-1962.0724
1154: , p0_a70 VARCHAR2 := fnd_api.g_miss_char
1155: , p0_a71 NUMBER := 0-1962.0724
1156: , p0_a72 NUMBER := 0-1962.0724
1157: , p0_a73 NUMBER := 0-1962.0724
1158: , p0_a74 NUMBER := 0-1962.0724
1155: , p0_a71 NUMBER := 0-1962.0724
1156: , p0_a72 NUMBER := 0-1962.0724
1157: , p0_a73 NUMBER := 0-1962.0724
1158: , p0_a74 NUMBER := 0-1962.0724
1159: , p0_a75 VARCHAR2 := fnd_api.g_miss_char
1160: , p0_a76 VARCHAR2 := fnd_api.g_miss_char
1161: , p0_a77 VARCHAR2 := fnd_api.g_miss_char
1162: , p0_a78 NUMBER := 0-1962.0724
1163: , p0_a79 DATE := fnd_api.g_miss_date
1156: , p0_a72 NUMBER := 0-1962.0724
1157: , p0_a73 NUMBER := 0-1962.0724
1158: , p0_a74 NUMBER := 0-1962.0724
1159: , p0_a75 VARCHAR2 := fnd_api.g_miss_char
1160: , p0_a76 VARCHAR2 := fnd_api.g_miss_char
1161: , p0_a77 VARCHAR2 := fnd_api.g_miss_char
1162: , p0_a78 NUMBER := 0-1962.0724
1163: , p0_a79 DATE := fnd_api.g_miss_date
1164: )
1157: , p0_a73 NUMBER := 0-1962.0724
1158: , p0_a74 NUMBER := 0-1962.0724
1159: , p0_a75 VARCHAR2 := fnd_api.g_miss_char
1160: , p0_a76 VARCHAR2 := fnd_api.g_miss_char
1161: , p0_a77 VARCHAR2 := fnd_api.g_miss_char
1162: , p0_a78 NUMBER := 0-1962.0724
1163: , p0_a79 DATE := fnd_api.g_miss_date
1164: )
1165:
1159: , p0_a75 VARCHAR2 := fnd_api.g_miss_char
1160: , p0_a76 VARCHAR2 := fnd_api.g_miss_char
1161: , p0_a77 VARCHAR2 := fnd_api.g_miss_char
1162: , p0_a78 NUMBER := 0-1962.0724
1163: , p0_a79 DATE := fnd_api.g_miss_date
1164: )
1165:
1166: as
1167: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;
1430: , p6_a35 out nocopy JTF_DATE_TABLE
1431: , x_record_count out nocopy NUMBER
1432: , p5_a0 NUMBER := 0-1962.0724
1433: , p5_a1 NUMBER := 0-1962.0724
1434: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a3 NUMBER := 0-1962.0724
1436: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a6 DATE := fnd_api.g_miss_date
1432: , p5_a0 NUMBER := 0-1962.0724
1433: , p5_a1 NUMBER := 0-1962.0724
1434: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a3 NUMBER := 0-1962.0724
1436: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a6 DATE := fnd_api.g_miss_date
1439: , p5_a7 DATE := fnd_api.g_miss_date
1440: , p5_a8 NUMBER := 0-1962.0724
1433: , p5_a1 NUMBER := 0-1962.0724
1434: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a3 NUMBER := 0-1962.0724
1436: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a6 DATE := fnd_api.g_miss_date
1439: , p5_a7 DATE := fnd_api.g_miss_date
1440: , p5_a8 NUMBER := 0-1962.0724
1441: , p5_a9 DATE := fnd_api.g_miss_date
1434: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a3 NUMBER := 0-1962.0724
1436: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a6 DATE := fnd_api.g_miss_date
1439: , p5_a7 DATE := fnd_api.g_miss_date
1440: , p5_a8 NUMBER := 0-1962.0724
1441: , p5_a9 DATE := fnd_api.g_miss_date
1442: , p5_a10 NUMBER := 0-1962.0724
1435: , p5_a3 NUMBER := 0-1962.0724
1436: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a6 DATE := fnd_api.g_miss_date
1439: , p5_a7 DATE := fnd_api.g_miss_date
1440: , p5_a8 NUMBER := 0-1962.0724
1441: , p5_a9 DATE := fnd_api.g_miss_date
1442: , p5_a10 NUMBER := 0-1962.0724
1443: , p5_a11 DATE := fnd_api.g_miss_date
1437: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a6 DATE := fnd_api.g_miss_date
1439: , p5_a7 DATE := fnd_api.g_miss_date
1440: , p5_a8 NUMBER := 0-1962.0724
1441: , p5_a9 DATE := fnd_api.g_miss_date
1442: , p5_a10 NUMBER := 0-1962.0724
1443: , p5_a11 DATE := fnd_api.g_miss_date
1444: , p5_a12 NUMBER := 0-1962.0724
1445: , p5_a13 NUMBER := 0-1962.0724
1439: , p5_a7 DATE := fnd_api.g_miss_date
1440: , p5_a8 NUMBER := 0-1962.0724
1441: , p5_a9 DATE := fnd_api.g_miss_date
1442: , p5_a10 NUMBER := 0-1962.0724
1443: , p5_a11 DATE := fnd_api.g_miss_date
1444: , p5_a12 NUMBER := 0-1962.0724
1445: , p5_a13 NUMBER := 0-1962.0724
1446: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a10 NUMBER := 0-1962.0724
1443: , p5_a11 DATE := fnd_api.g_miss_date
1444: , p5_a12 NUMBER := 0-1962.0724
1445: , p5_a13 NUMBER := 0-1962.0724
1446: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a11 DATE := fnd_api.g_miss_date
1444: , p5_a12 NUMBER := 0-1962.0724
1445: , p5_a13 NUMBER := 0-1962.0724
1446: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a12 NUMBER := 0-1962.0724
1445: , p5_a13 NUMBER := 0-1962.0724
1446: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a13 NUMBER := 0-1962.0724
1446: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a27 NUMBER := 0-1962.0724
1452: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a27 NUMBER := 0-1962.0724
1460: , p5_a28 DATE := fnd_api.g_miss_date
1453: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a27 NUMBER := 0-1962.0724
1460: , p5_a28 DATE := fnd_api.g_miss_date
1461: , p5_a29 NUMBER := 0-1962.0724
1454: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a27 NUMBER := 0-1962.0724
1460: , p5_a28 DATE := fnd_api.g_miss_date
1461: , p5_a29 NUMBER := 0-1962.0724
1462: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a27 NUMBER := 0-1962.0724
1460: , p5_a28 DATE := fnd_api.g_miss_date
1461: , p5_a29 NUMBER := 0-1962.0724
1462: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a27 NUMBER := 0-1962.0724
1460: , p5_a28 DATE := fnd_api.g_miss_date
1461: , p5_a29 NUMBER := 0-1962.0724
1462: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a34 NUMBER := 0-1962.0724
1459: , p5_a27 NUMBER := 0-1962.0724
1460: , p5_a28 DATE := fnd_api.g_miss_date
1461: , p5_a29 NUMBER := 0-1962.0724
1462: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a34 NUMBER := 0-1962.0724
1467: , p5_a35 DATE := fnd_api.g_miss_date
1460: , p5_a28 DATE := fnd_api.g_miss_date
1461: , p5_a29 NUMBER := 0-1962.0724
1462: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a34 NUMBER := 0-1962.0724
1467: , p5_a35 DATE := fnd_api.g_miss_date
1468: )
1461: , p5_a29 NUMBER := 0-1962.0724
1462: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a34 NUMBER := 0-1962.0724
1467: , p5_a35 DATE := fnd_api.g_miss_date
1468: )
1469:
1463: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a34 NUMBER := 0-1962.0724
1467: , p5_a35 DATE := fnd_api.g_miss_date
1468: )
1469:
1470: as
1471: ddp_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
1618: , p6_a35 out nocopy JTF_DATE_TABLE
1619: , x_record_count out nocopy NUMBER
1620: , p5_a0 NUMBER := 0-1962.0724
1621: , p5_a1 NUMBER := 0-1962.0724
1622: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1623: , p5_a3 NUMBER := 0-1962.0724
1624: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1625: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1626: , p5_a6 DATE := fnd_api.g_miss_date
1620: , p5_a0 NUMBER := 0-1962.0724
1621: , p5_a1 NUMBER := 0-1962.0724
1622: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1623: , p5_a3 NUMBER := 0-1962.0724
1624: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1625: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1626: , p5_a6 DATE := fnd_api.g_miss_date
1627: , p5_a7 DATE := fnd_api.g_miss_date
1628: , p5_a8 NUMBER := 0-1962.0724
1621: , p5_a1 NUMBER := 0-1962.0724
1622: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1623: , p5_a3 NUMBER := 0-1962.0724
1624: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1625: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1626: , p5_a6 DATE := fnd_api.g_miss_date
1627: , p5_a7 DATE := fnd_api.g_miss_date
1628: , p5_a8 NUMBER := 0-1962.0724
1629: , p5_a9 DATE := fnd_api.g_miss_date
1622: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1623: , p5_a3 NUMBER := 0-1962.0724
1624: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1625: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1626: , p5_a6 DATE := fnd_api.g_miss_date
1627: , p5_a7 DATE := fnd_api.g_miss_date
1628: , p5_a8 NUMBER := 0-1962.0724
1629: , p5_a9 DATE := fnd_api.g_miss_date
1630: , p5_a10 NUMBER := 0-1962.0724
1623: , p5_a3 NUMBER := 0-1962.0724
1624: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1625: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1626: , p5_a6 DATE := fnd_api.g_miss_date
1627: , p5_a7 DATE := fnd_api.g_miss_date
1628: , p5_a8 NUMBER := 0-1962.0724
1629: , p5_a9 DATE := fnd_api.g_miss_date
1630: , p5_a10 NUMBER := 0-1962.0724
1631: , p5_a11 DATE := fnd_api.g_miss_date
1625: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1626: , p5_a6 DATE := fnd_api.g_miss_date
1627: , p5_a7 DATE := fnd_api.g_miss_date
1628: , p5_a8 NUMBER := 0-1962.0724
1629: , p5_a9 DATE := fnd_api.g_miss_date
1630: , p5_a10 NUMBER := 0-1962.0724
1631: , p5_a11 DATE := fnd_api.g_miss_date
1632: , p5_a12 NUMBER := 0-1962.0724
1633: , p5_a13 NUMBER := 0-1962.0724
1627: , p5_a7 DATE := fnd_api.g_miss_date
1628: , p5_a8 NUMBER := 0-1962.0724
1629: , p5_a9 DATE := fnd_api.g_miss_date
1630: , p5_a10 NUMBER := 0-1962.0724
1631: , p5_a11 DATE := fnd_api.g_miss_date
1632: , p5_a12 NUMBER := 0-1962.0724
1633: , p5_a13 NUMBER := 0-1962.0724
1634: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1635: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1630: , p5_a10 NUMBER := 0-1962.0724
1631: , p5_a11 DATE := fnd_api.g_miss_date
1632: , p5_a12 NUMBER := 0-1962.0724
1633: , p5_a13 NUMBER := 0-1962.0724
1634: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1635: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1636: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1637: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1638: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1631: , p5_a11 DATE := fnd_api.g_miss_date
1632: , p5_a12 NUMBER := 0-1962.0724
1633: , p5_a13 NUMBER := 0-1962.0724
1634: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1635: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1636: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1637: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1638: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1639: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1632: , p5_a12 NUMBER := 0-1962.0724
1633: , p5_a13 NUMBER := 0-1962.0724
1634: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1635: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1636: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1637: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1638: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1639: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1640: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1633: , p5_a13 NUMBER := 0-1962.0724
1634: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1635: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1636: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1637: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1638: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1639: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1640: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1641: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1634: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1635: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1636: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1637: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1638: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1639: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1640: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1641: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1642: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1635: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1636: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1637: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1638: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1639: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1640: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1641: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1642: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1643: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1636: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1637: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1638: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1639: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1640: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1641: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1642: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1643: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1644: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1637: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1638: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1639: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1640: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1641: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1642: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1643: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1644: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1645: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1638: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1639: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1640: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1641: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1642: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1643: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1644: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1645: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1646: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1639: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1640: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1641: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1642: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1643: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1644: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1645: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1646: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1647: , p5_a27 NUMBER := 0-1962.0724
1640: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1641: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1642: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1643: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1644: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1645: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1646: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1647: , p5_a27 NUMBER := 0-1962.0724
1648: , p5_a28 DATE := fnd_api.g_miss_date
1641: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1642: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1643: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1644: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1645: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1646: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1647: , p5_a27 NUMBER := 0-1962.0724
1648: , p5_a28 DATE := fnd_api.g_miss_date
1649: , p5_a29 NUMBER := 0-1962.0724
1642: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1643: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1644: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1645: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1646: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1647: , p5_a27 NUMBER := 0-1962.0724
1648: , p5_a28 DATE := fnd_api.g_miss_date
1649: , p5_a29 NUMBER := 0-1962.0724
1650: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1644: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1645: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1646: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1647: , p5_a27 NUMBER := 0-1962.0724
1648: , p5_a28 DATE := fnd_api.g_miss_date
1649: , p5_a29 NUMBER := 0-1962.0724
1650: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1651: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1652: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1646: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1647: , p5_a27 NUMBER := 0-1962.0724
1648: , p5_a28 DATE := fnd_api.g_miss_date
1649: , p5_a29 NUMBER := 0-1962.0724
1650: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1651: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1652: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1653: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1654: , p5_a34 NUMBER := 0-1962.0724
1647: , p5_a27 NUMBER := 0-1962.0724
1648: , p5_a28 DATE := fnd_api.g_miss_date
1649: , p5_a29 NUMBER := 0-1962.0724
1650: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1651: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1652: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1653: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1654: , p5_a34 NUMBER := 0-1962.0724
1655: , p5_a35 DATE := fnd_api.g_miss_date
1648: , p5_a28 DATE := fnd_api.g_miss_date
1649: , p5_a29 NUMBER := 0-1962.0724
1650: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1651: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1652: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1653: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1654: , p5_a34 NUMBER := 0-1962.0724
1655: , p5_a35 DATE := fnd_api.g_miss_date
1656: )
1649: , p5_a29 NUMBER := 0-1962.0724
1650: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1651: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1652: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1653: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1654: , p5_a34 NUMBER := 0-1962.0724
1655: , p5_a35 DATE := fnd_api.g_miss_date
1656: )
1657:
1651: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1652: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1653: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1654: , p5_a34 NUMBER := 0-1962.0724
1655: , p5_a35 DATE := fnd_api.g_miss_date
1656: )
1657:
1658: as
1659: ddp_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
1806: , p6_a35 out nocopy JTF_DATE_TABLE
1807: , x_record_count out nocopy NUMBER
1808: , p5_a0 NUMBER := 0-1962.0724
1809: , p5_a1 NUMBER := 0-1962.0724
1810: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a3 NUMBER := 0-1962.0724
1812: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a6 DATE := fnd_api.g_miss_date
1808: , p5_a0 NUMBER := 0-1962.0724
1809: , p5_a1 NUMBER := 0-1962.0724
1810: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a3 NUMBER := 0-1962.0724
1812: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a6 DATE := fnd_api.g_miss_date
1815: , p5_a7 DATE := fnd_api.g_miss_date
1816: , p5_a8 NUMBER := 0-1962.0724
1809: , p5_a1 NUMBER := 0-1962.0724
1810: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a3 NUMBER := 0-1962.0724
1812: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a6 DATE := fnd_api.g_miss_date
1815: , p5_a7 DATE := fnd_api.g_miss_date
1816: , p5_a8 NUMBER := 0-1962.0724
1817: , p5_a9 DATE := fnd_api.g_miss_date
1810: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a3 NUMBER := 0-1962.0724
1812: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a6 DATE := fnd_api.g_miss_date
1815: , p5_a7 DATE := fnd_api.g_miss_date
1816: , p5_a8 NUMBER := 0-1962.0724
1817: , p5_a9 DATE := fnd_api.g_miss_date
1818: , p5_a10 NUMBER := 0-1962.0724
1811: , p5_a3 NUMBER := 0-1962.0724
1812: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a6 DATE := fnd_api.g_miss_date
1815: , p5_a7 DATE := fnd_api.g_miss_date
1816: , p5_a8 NUMBER := 0-1962.0724
1817: , p5_a9 DATE := fnd_api.g_miss_date
1818: , p5_a10 NUMBER := 0-1962.0724
1819: , p5_a11 DATE := fnd_api.g_miss_date
1813: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a6 DATE := fnd_api.g_miss_date
1815: , p5_a7 DATE := fnd_api.g_miss_date
1816: , p5_a8 NUMBER := 0-1962.0724
1817: , p5_a9 DATE := fnd_api.g_miss_date
1818: , p5_a10 NUMBER := 0-1962.0724
1819: , p5_a11 DATE := fnd_api.g_miss_date
1820: , p5_a12 NUMBER := 0-1962.0724
1821: , p5_a13 NUMBER := 0-1962.0724
1815: , p5_a7 DATE := fnd_api.g_miss_date
1816: , p5_a8 NUMBER := 0-1962.0724
1817: , p5_a9 DATE := fnd_api.g_miss_date
1818: , p5_a10 NUMBER := 0-1962.0724
1819: , p5_a11 DATE := fnd_api.g_miss_date
1820: , p5_a12 NUMBER := 0-1962.0724
1821: , p5_a13 NUMBER := 0-1962.0724
1822: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1823: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1818: , p5_a10 NUMBER := 0-1962.0724
1819: , p5_a11 DATE := fnd_api.g_miss_date
1820: , p5_a12 NUMBER := 0-1962.0724
1821: , p5_a13 NUMBER := 0-1962.0724
1822: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1823: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1819: , p5_a11 DATE := fnd_api.g_miss_date
1820: , p5_a12 NUMBER := 0-1962.0724
1821: , p5_a13 NUMBER := 0-1962.0724
1822: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1823: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1820: , p5_a12 NUMBER := 0-1962.0724
1821: , p5_a13 NUMBER := 0-1962.0724
1822: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1823: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1821: , p5_a13 NUMBER := 0-1962.0724
1822: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1823: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1822: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1823: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1823: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a27 NUMBER := 0-1962.0724
1828: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a27 NUMBER := 0-1962.0724
1836: , p5_a28 DATE := fnd_api.g_miss_date
1829: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a27 NUMBER := 0-1962.0724
1836: , p5_a28 DATE := fnd_api.g_miss_date
1837: , p5_a29 NUMBER := 0-1962.0724
1830: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a27 NUMBER := 0-1962.0724
1836: , p5_a28 DATE := fnd_api.g_miss_date
1837: , p5_a29 NUMBER := 0-1962.0724
1838: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a27 NUMBER := 0-1962.0724
1836: , p5_a28 DATE := fnd_api.g_miss_date
1837: , p5_a29 NUMBER := 0-1962.0724
1838: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1839: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1840: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a27 NUMBER := 0-1962.0724
1836: , p5_a28 DATE := fnd_api.g_miss_date
1837: , p5_a29 NUMBER := 0-1962.0724
1838: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1839: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1840: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1841: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1842: , p5_a34 NUMBER := 0-1962.0724
1835: , p5_a27 NUMBER := 0-1962.0724
1836: , p5_a28 DATE := fnd_api.g_miss_date
1837: , p5_a29 NUMBER := 0-1962.0724
1838: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1839: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1840: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1841: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1842: , p5_a34 NUMBER := 0-1962.0724
1843: , p5_a35 DATE := fnd_api.g_miss_date
1836: , p5_a28 DATE := fnd_api.g_miss_date
1837: , p5_a29 NUMBER := 0-1962.0724
1838: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1839: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1840: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1841: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1842: , p5_a34 NUMBER := 0-1962.0724
1843: , p5_a35 DATE := fnd_api.g_miss_date
1844: )
1837: , p5_a29 NUMBER := 0-1962.0724
1838: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1839: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1840: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1841: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1842: , p5_a34 NUMBER := 0-1962.0724
1843: , p5_a35 DATE := fnd_api.g_miss_date
1844: )
1845:
1839: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1840: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1841: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1842: , p5_a34 NUMBER := 0-1962.0724
1843: , p5_a35 DATE := fnd_api.g_miss_date
1844: )
1845:
1846: as
1847: ddp_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;