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;
698: , p6_a39 out nocopy VARCHAR2
699: , p5_a0 NUMBER := 0-1962.0724
700: , p5_a1 NUMBER := 0-1962.0724
701: , p5_a2 NUMBER := 0-1962.0724
702: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
699: , p5_a0 NUMBER := 0-1962.0724
700: , p5_a1 NUMBER := 0-1962.0724
701: , p5_a2 NUMBER := 0-1962.0724
702: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
700: , p5_a1 NUMBER := 0-1962.0724
701: , p5_a2 NUMBER := 0-1962.0724
702: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
701: , p5_a2 NUMBER := 0-1962.0724
702: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a20 NUMBER := 0-1962.0724
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a20 NUMBER := 0-1962.0724
720: , p5_a21 NUMBER := 0-1962.0724
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a20 NUMBER := 0-1962.0724
720: , p5_a21 NUMBER := 0-1962.0724
721: , p5_a22 NUMBER := 0-1962.0724
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a20 NUMBER := 0-1962.0724
720: , p5_a21 NUMBER := 0-1962.0724
721: , p5_a22 NUMBER := 0-1962.0724
722: , p5_a23 NUMBER := 0-1962.0724
719: , p5_a20 NUMBER := 0-1962.0724
720: , p5_a21 NUMBER := 0-1962.0724
721: , p5_a22 NUMBER := 0-1962.0724
722: , p5_a23 NUMBER := 0-1962.0724
723: , p5_a24 DATE := fnd_api.g_miss_date
724: , p5_a25 NUMBER := 0-1962.0724
725: , p5_a26 DATE := fnd_api.g_miss_date
726: , p5_a27 NUMBER := 0-1962.0724
727: , p5_a28 DATE := fnd_api.g_miss_date
721: , p5_a22 NUMBER := 0-1962.0724
722: , p5_a23 NUMBER := 0-1962.0724
723: , p5_a24 DATE := fnd_api.g_miss_date
724: , p5_a25 NUMBER := 0-1962.0724
725: , p5_a26 DATE := fnd_api.g_miss_date
726: , p5_a27 NUMBER := 0-1962.0724
727: , p5_a28 DATE := fnd_api.g_miss_date
728: , p5_a29 NUMBER := 0-1962.0724
729: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a24 DATE := fnd_api.g_miss_date
724: , p5_a25 NUMBER := 0-1962.0724
725: , p5_a26 DATE := fnd_api.g_miss_date
726: , p5_a27 NUMBER := 0-1962.0724
727: , p5_a28 DATE := fnd_api.g_miss_date
728: , p5_a29 NUMBER := 0-1962.0724
729: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a26 DATE := fnd_api.g_miss_date
726: , p5_a27 NUMBER := 0-1962.0724
727: , p5_a28 DATE := fnd_api.g_miss_date
728: , p5_a29 NUMBER := 0-1962.0724
729: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a34 NUMBER := 0-1962.0724
726: , p5_a27 NUMBER := 0-1962.0724
727: , p5_a28 DATE := fnd_api.g_miss_date
728: , p5_a29 NUMBER := 0-1962.0724
729: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a34 NUMBER := 0-1962.0724
734: , p5_a35 NUMBER := 0-1962.0724
727: , p5_a28 DATE := fnd_api.g_miss_date
728: , p5_a29 NUMBER := 0-1962.0724
729: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a34 NUMBER := 0-1962.0724
734: , p5_a35 NUMBER := 0-1962.0724
735: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a29 NUMBER := 0-1962.0724
729: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a34 NUMBER := 0-1962.0724
734: , p5_a35 NUMBER := 0-1962.0724
735: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a34 NUMBER := 0-1962.0724
734: , p5_a35 NUMBER := 0-1962.0724
735: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
739: )
732: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a34 NUMBER := 0-1962.0724
734: , p5_a35 NUMBER := 0-1962.0724
735: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
739: )
740:
733: , p5_a34 NUMBER := 0-1962.0724
734: , p5_a35 NUMBER := 0-1962.0724
735: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
739: )
740:
741: as
734: , p5_a35 NUMBER := 0-1962.0724
735: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
739: )
740:
741: as
742: ddp_cldv_rec okl_cld_pvt.cldv_rec_type;
1286: , x_msg_data out nocopy VARCHAR2
1287: , p5_a0 NUMBER := 0-1962.0724
1288: , p5_a1 NUMBER := 0-1962.0724
1289: , p5_a2 NUMBER := 0-1962.0724
1290: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1287: , p5_a0 NUMBER := 0-1962.0724
1288: , p5_a1 NUMBER := 0-1962.0724
1289: , p5_a2 NUMBER := 0-1962.0724
1290: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1288: , p5_a1 NUMBER := 0-1962.0724
1289: , p5_a2 NUMBER := 0-1962.0724
1290: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a2 NUMBER := 0-1962.0724
1290: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1290: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1305: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1305: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1305: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a20 NUMBER := 0-1962.0724
1300: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1305: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a20 NUMBER := 0-1962.0724
1308: , p5_a21 NUMBER := 0-1962.0724
1301: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1305: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a20 NUMBER := 0-1962.0724
1308: , p5_a21 NUMBER := 0-1962.0724
1309: , p5_a22 NUMBER := 0-1962.0724
1302: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1305: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a20 NUMBER := 0-1962.0724
1308: , p5_a21 NUMBER := 0-1962.0724
1309: , p5_a22 NUMBER := 0-1962.0724
1310: , p5_a23 NUMBER := 0-1962.0724
1307: , p5_a20 NUMBER := 0-1962.0724
1308: , p5_a21 NUMBER := 0-1962.0724
1309: , p5_a22 NUMBER := 0-1962.0724
1310: , p5_a23 NUMBER := 0-1962.0724
1311: , p5_a24 DATE := fnd_api.g_miss_date
1312: , p5_a25 NUMBER := 0-1962.0724
1313: , p5_a26 DATE := fnd_api.g_miss_date
1314: , p5_a27 NUMBER := 0-1962.0724
1315: , p5_a28 DATE := fnd_api.g_miss_date
1309: , p5_a22 NUMBER := 0-1962.0724
1310: , p5_a23 NUMBER := 0-1962.0724
1311: , p5_a24 DATE := fnd_api.g_miss_date
1312: , p5_a25 NUMBER := 0-1962.0724
1313: , p5_a26 DATE := fnd_api.g_miss_date
1314: , p5_a27 NUMBER := 0-1962.0724
1315: , p5_a28 DATE := fnd_api.g_miss_date
1316: , p5_a29 NUMBER := 0-1962.0724
1317: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1311: , p5_a24 DATE := fnd_api.g_miss_date
1312: , p5_a25 NUMBER := 0-1962.0724
1313: , p5_a26 DATE := fnd_api.g_miss_date
1314: , p5_a27 NUMBER := 0-1962.0724
1315: , p5_a28 DATE := fnd_api.g_miss_date
1316: , p5_a29 NUMBER := 0-1962.0724
1317: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1313: , p5_a26 DATE := fnd_api.g_miss_date
1314: , p5_a27 NUMBER := 0-1962.0724
1315: , p5_a28 DATE := fnd_api.g_miss_date
1316: , p5_a29 NUMBER := 0-1962.0724
1317: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1320: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1321: , p5_a34 NUMBER := 0-1962.0724
1314: , p5_a27 NUMBER := 0-1962.0724
1315: , p5_a28 DATE := fnd_api.g_miss_date
1316: , p5_a29 NUMBER := 0-1962.0724
1317: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1320: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1321: , p5_a34 NUMBER := 0-1962.0724
1322: , p5_a35 NUMBER := 0-1962.0724
1315: , p5_a28 DATE := fnd_api.g_miss_date
1316: , p5_a29 NUMBER := 0-1962.0724
1317: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1320: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1321: , p5_a34 NUMBER := 0-1962.0724
1322: , p5_a35 NUMBER := 0-1962.0724
1323: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1316: , p5_a29 NUMBER := 0-1962.0724
1317: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1320: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1321: , p5_a34 NUMBER := 0-1962.0724
1322: , p5_a35 NUMBER := 0-1962.0724
1323: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1324: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1320: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1321: , p5_a34 NUMBER := 0-1962.0724
1322: , p5_a35 NUMBER := 0-1962.0724
1323: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1324: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1325: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1326: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1327: )
1320: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1321: , p5_a34 NUMBER := 0-1962.0724
1322: , p5_a35 NUMBER := 0-1962.0724
1323: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1324: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1325: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1326: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1327: )
1328:
1321: , p5_a34 NUMBER := 0-1962.0724
1322: , p5_a35 NUMBER := 0-1962.0724
1323: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1324: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1325: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1326: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1327: )
1328:
1329: as
1322: , p5_a35 NUMBER := 0-1962.0724
1323: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1324: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1325: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1326: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1327: )
1328:
1329: as
1330: ddp_cldv_rec okl_cld_pvt.cldv_rec_type;
1700: , p6_a39 out nocopy VARCHAR2
1701: , p5_a0 NUMBER := 0-1962.0724
1702: , p5_a1 NUMBER := 0-1962.0724
1703: , p5_a2 NUMBER := 0-1962.0724
1704: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1701: , p5_a0 NUMBER := 0-1962.0724
1702: , p5_a1 NUMBER := 0-1962.0724
1703: , p5_a2 NUMBER := 0-1962.0724
1704: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1702: , p5_a1 NUMBER := 0-1962.0724
1703: , p5_a2 NUMBER := 0-1962.0724
1704: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1703: , p5_a2 NUMBER := 0-1962.0724
1704: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1704: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a20 NUMBER := 0-1962.0724
1714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a20 NUMBER := 0-1962.0724
1722: , p5_a21 NUMBER := 0-1962.0724
1715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a20 NUMBER := 0-1962.0724
1722: , p5_a21 NUMBER := 0-1962.0724
1723: , p5_a22 NUMBER := 0-1962.0724
1716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a20 NUMBER := 0-1962.0724
1722: , p5_a21 NUMBER := 0-1962.0724
1723: , p5_a22 NUMBER := 0-1962.0724
1724: , p5_a23 NUMBER := 0-1962.0724
1721: , p5_a20 NUMBER := 0-1962.0724
1722: , p5_a21 NUMBER := 0-1962.0724
1723: , p5_a22 NUMBER := 0-1962.0724
1724: , p5_a23 NUMBER := 0-1962.0724
1725: , p5_a24 DATE := fnd_api.g_miss_date
1726: , p5_a25 NUMBER := 0-1962.0724
1727: , p5_a26 DATE := fnd_api.g_miss_date
1728: , p5_a27 NUMBER := 0-1962.0724
1729: , p5_a28 DATE := fnd_api.g_miss_date
1723: , p5_a22 NUMBER := 0-1962.0724
1724: , p5_a23 NUMBER := 0-1962.0724
1725: , p5_a24 DATE := fnd_api.g_miss_date
1726: , p5_a25 NUMBER := 0-1962.0724
1727: , p5_a26 DATE := fnd_api.g_miss_date
1728: , p5_a27 NUMBER := 0-1962.0724
1729: , p5_a28 DATE := fnd_api.g_miss_date
1730: , p5_a29 NUMBER := 0-1962.0724
1731: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1725: , p5_a24 DATE := fnd_api.g_miss_date
1726: , p5_a25 NUMBER := 0-1962.0724
1727: , p5_a26 DATE := fnd_api.g_miss_date
1728: , p5_a27 NUMBER := 0-1962.0724
1729: , p5_a28 DATE := fnd_api.g_miss_date
1730: , p5_a29 NUMBER := 0-1962.0724
1731: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1727: , p5_a26 DATE := fnd_api.g_miss_date
1728: , p5_a27 NUMBER := 0-1962.0724
1729: , p5_a28 DATE := fnd_api.g_miss_date
1730: , p5_a29 NUMBER := 0-1962.0724
1731: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a34 NUMBER := 0-1962.0724
1728: , p5_a27 NUMBER := 0-1962.0724
1729: , p5_a28 DATE := fnd_api.g_miss_date
1730: , p5_a29 NUMBER := 0-1962.0724
1731: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a34 NUMBER := 0-1962.0724
1736: , p5_a35 NUMBER := 0-1962.0724
1729: , p5_a28 DATE := fnd_api.g_miss_date
1730: , p5_a29 NUMBER := 0-1962.0724
1731: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a34 NUMBER := 0-1962.0724
1736: , p5_a35 NUMBER := 0-1962.0724
1737: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1730: , p5_a29 NUMBER := 0-1962.0724
1731: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a34 NUMBER := 0-1962.0724
1736: , p5_a35 NUMBER := 0-1962.0724
1737: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a34 NUMBER := 0-1962.0724
1736: , p5_a35 NUMBER := 0-1962.0724
1737: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1741: )
1734: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a34 NUMBER := 0-1962.0724
1736: , p5_a35 NUMBER := 0-1962.0724
1737: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1741: )
1742:
1735: , p5_a34 NUMBER := 0-1962.0724
1736: , p5_a35 NUMBER := 0-1962.0724
1737: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1741: )
1742:
1743: as
1736: , p5_a35 NUMBER := 0-1962.0724
1737: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1741: )
1742:
1743: as
1744: ddp_cldv_rec okl_cld_pvt.cldv_rec_type;
2288: , x_msg_data out nocopy VARCHAR2
2289: , p5_a0 NUMBER := 0-1962.0724
2290: , p5_a1 NUMBER := 0-1962.0724
2291: , p5_a2 NUMBER := 0-1962.0724
2292: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2289: , p5_a0 NUMBER := 0-1962.0724
2290: , p5_a1 NUMBER := 0-1962.0724
2291: , p5_a2 NUMBER := 0-1962.0724
2292: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2290: , p5_a1 NUMBER := 0-1962.0724
2291: , p5_a2 NUMBER := 0-1962.0724
2292: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2291: , p5_a2 NUMBER := 0-1962.0724
2292: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2292: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2300: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2300: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2301: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2300: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2301: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2302: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2300: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2301: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2302: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2303: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2300: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2301: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2302: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2303: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2304: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2300: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2301: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2302: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2303: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2304: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2305: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2300: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2301: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2302: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2303: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2304: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2305: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2306: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2300: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2301: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2302: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2303: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2304: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2305: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2306: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2307: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2300: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2301: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2302: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2303: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2304: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2305: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2306: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2307: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2308: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2301: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2302: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2303: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2304: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2305: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2306: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2307: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2308: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2309: , p5_a20 NUMBER := 0-1962.0724
2302: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2303: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2304: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2305: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2306: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2307: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2308: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2309: , p5_a20 NUMBER := 0-1962.0724
2310: , p5_a21 NUMBER := 0-1962.0724
2303: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2304: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2305: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2306: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2307: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2308: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2309: , p5_a20 NUMBER := 0-1962.0724
2310: , p5_a21 NUMBER := 0-1962.0724
2311: , p5_a22 NUMBER := 0-1962.0724
2304: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2305: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2306: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2307: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2308: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2309: , p5_a20 NUMBER := 0-1962.0724
2310: , p5_a21 NUMBER := 0-1962.0724
2311: , p5_a22 NUMBER := 0-1962.0724
2312: , p5_a23 NUMBER := 0-1962.0724
2309: , p5_a20 NUMBER := 0-1962.0724
2310: , p5_a21 NUMBER := 0-1962.0724
2311: , p5_a22 NUMBER := 0-1962.0724
2312: , p5_a23 NUMBER := 0-1962.0724
2313: , p5_a24 DATE := fnd_api.g_miss_date
2314: , p5_a25 NUMBER := 0-1962.0724
2315: , p5_a26 DATE := fnd_api.g_miss_date
2316: , p5_a27 NUMBER := 0-1962.0724
2317: , p5_a28 DATE := fnd_api.g_miss_date
2311: , p5_a22 NUMBER := 0-1962.0724
2312: , p5_a23 NUMBER := 0-1962.0724
2313: , p5_a24 DATE := fnd_api.g_miss_date
2314: , p5_a25 NUMBER := 0-1962.0724
2315: , p5_a26 DATE := fnd_api.g_miss_date
2316: , p5_a27 NUMBER := 0-1962.0724
2317: , p5_a28 DATE := fnd_api.g_miss_date
2318: , p5_a29 NUMBER := 0-1962.0724
2319: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2313: , p5_a24 DATE := fnd_api.g_miss_date
2314: , p5_a25 NUMBER := 0-1962.0724
2315: , p5_a26 DATE := fnd_api.g_miss_date
2316: , p5_a27 NUMBER := 0-1962.0724
2317: , p5_a28 DATE := fnd_api.g_miss_date
2318: , p5_a29 NUMBER := 0-1962.0724
2319: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2320: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2321: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2315: , p5_a26 DATE := fnd_api.g_miss_date
2316: , p5_a27 NUMBER := 0-1962.0724
2317: , p5_a28 DATE := fnd_api.g_miss_date
2318: , p5_a29 NUMBER := 0-1962.0724
2319: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2320: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2321: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2322: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2323: , p5_a34 NUMBER := 0-1962.0724
2316: , p5_a27 NUMBER := 0-1962.0724
2317: , p5_a28 DATE := fnd_api.g_miss_date
2318: , p5_a29 NUMBER := 0-1962.0724
2319: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2320: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2321: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2322: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2323: , p5_a34 NUMBER := 0-1962.0724
2324: , p5_a35 NUMBER := 0-1962.0724
2317: , p5_a28 DATE := fnd_api.g_miss_date
2318: , p5_a29 NUMBER := 0-1962.0724
2319: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2320: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2321: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2322: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2323: , p5_a34 NUMBER := 0-1962.0724
2324: , p5_a35 NUMBER := 0-1962.0724
2325: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2318: , p5_a29 NUMBER := 0-1962.0724
2319: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2320: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2321: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2322: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2323: , p5_a34 NUMBER := 0-1962.0724
2324: , p5_a35 NUMBER := 0-1962.0724
2325: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2326: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2321: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2322: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2323: , p5_a34 NUMBER := 0-1962.0724
2324: , p5_a35 NUMBER := 0-1962.0724
2325: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2326: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2327: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2328: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2329: )
2322: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2323: , p5_a34 NUMBER := 0-1962.0724
2324: , p5_a35 NUMBER := 0-1962.0724
2325: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2326: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2327: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2328: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2329: )
2330:
2323: , p5_a34 NUMBER := 0-1962.0724
2324: , p5_a35 NUMBER := 0-1962.0724
2325: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2326: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2327: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2328: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2329: )
2330:
2331: as
2324: , p5_a35 NUMBER := 0-1962.0724
2325: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2326: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2327: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2328: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2329: )
2330:
2331: as
2332: ddp_cldv_rec okl_cld_pvt.cldv_rec_type;
2662: , x_msg_data out nocopy VARCHAR2
2663: , p5_a0 NUMBER := 0-1962.0724
2664: , p5_a1 NUMBER := 0-1962.0724
2665: , p5_a2 NUMBER := 0-1962.0724
2666: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2667: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2668: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2669: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2670: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2663: , p5_a0 NUMBER := 0-1962.0724
2664: , p5_a1 NUMBER := 0-1962.0724
2665: , p5_a2 NUMBER := 0-1962.0724
2666: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2667: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2668: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2669: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2670: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2671: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2664: , p5_a1 NUMBER := 0-1962.0724
2665: , p5_a2 NUMBER := 0-1962.0724
2666: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2667: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2668: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2669: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2670: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2671: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2672: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2665: , p5_a2 NUMBER := 0-1962.0724
2666: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2667: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2668: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2669: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2670: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2671: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2672: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2673: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2666: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2667: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2668: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2669: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2670: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2671: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2672: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2673: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2674: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2667: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2668: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2669: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2670: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2671: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2672: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2673: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2674: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2675: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2668: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2669: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2670: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2671: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2672: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2673: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2674: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2675: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2676: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2669: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2670: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2671: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2672: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2673: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2674: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2675: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2676: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2677: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2670: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2671: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2672: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2673: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2674: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2675: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2676: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2677: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2678: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2671: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2672: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2673: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2674: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2675: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2676: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2677: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2678: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2679: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2672: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2673: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2674: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2675: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2676: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2677: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2678: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2679: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2680: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2673: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2674: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2675: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2676: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2677: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2678: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2679: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2680: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2681: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2674: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2675: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2676: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2677: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2678: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2679: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2680: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2681: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2682: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2675: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2676: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2677: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2678: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2679: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2680: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2681: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2682: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2683: , p5_a20 NUMBER := 0-1962.0724
2676: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2677: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2678: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2679: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2680: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2681: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2682: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2683: , p5_a20 NUMBER := 0-1962.0724
2684: , p5_a21 NUMBER := 0-1962.0724
2677: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2678: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2679: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2680: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2681: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2682: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2683: , p5_a20 NUMBER := 0-1962.0724
2684: , p5_a21 NUMBER := 0-1962.0724
2685: , p5_a22 NUMBER := 0-1962.0724
2678: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2679: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2680: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2681: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2682: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2683: , p5_a20 NUMBER := 0-1962.0724
2684: , p5_a21 NUMBER := 0-1962.0724
2685: , p5_a22 NUMBER := 0-1962.0724
2686: , p5_a23 NUMBER := 0-1962.0724
2683: , p5_a20 NUMBER := 0-1962.0724
2684: , p5_a21 NUMBER := 0-1962.0724
2685: , p5_a22 NUMBER := 0-1962.0724
2686: , p5_a23 NUMBER := 0-1962.0724
2687: , p5_a24 DATE := fnd_api.g_miss_date
2688: , p5_a25 NUMBER := 0-1962.0724
2689: , p5_a26 DATE := fnd_api.g_miss_date
2690: , p5_a27 NUMBER := 0-1962.0724
2691: , p5_a28 DATE := fnd_api.g_miss_date
2685: , p5_a22 NUMBER := 0-1962.0724
2686: , p5_a23 NUMBER := 0-1962.0724
2687: , p5_a24 DATE := fnd_api.g_miss_date
2688: , p5_a25 NUMBER := 0-1962.0724
2689: , p5_a26 DATE := fnd_api.g_miss_date
2690: , p5_a27 NUMBER := 0-1962.0724
2691: , p5_a28 DATE := fnd_api.g_miss_date
2692: , p5_a29 NUMBER := 0-1962.0724
2693: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2687: , p5_a24 DATE := fnd_api.g_miss_date
2688: , p5_a25 NUMBER := 0-1962.0724
2689: , p5_a26 DATE := fnd_api.g_miss_date
2690: , p5_a27 NUMBER := 0-1962.0724
2691: , p5_a28 DATE := fnd_api.g_miss_date
2692: , p5_a29 NUMBER := 0-1962.0724
2693: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2694: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2695: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2689: , p5_a26 DATE := fnd_api.g_miss_date
2690: , p5_a27 NUMBER := 0-1962.0724
2691: , p5_a28 DATE := fnd_api.g_miss_date
2692: , p5_a29 NUMBER := 0-1962.0724
2693: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2694: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2695: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2696: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2697: , p5_a34 NUMBER := 0-1962.0724
2690: , p5_a27 NUMBER := 0-1962.0724
2691: , p5_a28 DATE := fnd_api.g_miss_date
2692: , p5_a29 NUMBER := 0-1962.0724
2693: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2694: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2695: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2696: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2697: , p5_a34 NUMBER := 0-1962.0724
2698: , p5_a35 NUMBER := 0-1962.0724
2691: , p5_a28 DATE := fnd_api.g_miss_date
2692: , p5_a29 NUMBER := 0-1962.0724
2693: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2694: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2695: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2696: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2697: , p5_a34 NUMBER := 0-1962.0724
2698: , p5_a35 NUMBER := 0-1962.0724
2699: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2692: , p5_a29 NUMBER := 0-1962.0724
2693: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2694: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2695: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2696: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2697: , p5_a34 NUMBER := 0-1962.0724
2698: , p5_a35 NUMBER := 0-1962.0724
2699: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2700: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2695: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2696: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2697: , p5_a34 NUMBER := 0-1962.0724
2698: , p5_a35 NUMBER := 0-1962.0724
2699: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2700: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2701: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2702: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2703: )
2696: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2697: , p5_a34 NUMBER := 0-1962.0724
2698: , p5_a35 NUMBER := 0-1962.0724
2699: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2700: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2701: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2702: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2703: )
2704:
2697: , p5_a34 NUMBER := 0-1962.0724
2698: , p5_a35 NUMBER := 0-1962.0724
2699: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2700: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2701: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2702: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2703: )
2704:
2705: as
2698: , p5_a35 NUMBER := 0-1962.0724
2699: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2700: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2701: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2702: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2703: )
2704:
2705: as
2706: ddp_cldv_rec okl_cld_pvt.cldv_rec_type;