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;
848: , p6_a41 out nocopy VARCHAR2
849: , p6_a42 out nocopy NUMBER
850: , p6_a43 out nocopy DATE
851: , p5_a0 NUMBER := 0-1962.0724
852: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a2 NUMBER := 0-1962.0724
854: , p5_a3 DATE := fnd_api.g_miss_date
855: , p5_a4 DATE := fnd_api.g_miss_date
856: , p5_a5 DATE := fnd_api.g_miss_date
850: , p6_a43 out nocopy DATE
851: , p5_a0 NUMBER := 0-1962.0724
852: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a2 NUMBER := 0-1962.0724
854: , p5_a3 DATE := fnd_api.g_miss_date
855: , p5_a4 DATE := fnd_api.g_miss_date
856: , p5_a5 DATE := fnd_api.g_miss_date
857: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
851: , p5_a0 NUMBER := 0-1962.0724
852: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a2 NUMBER := 0-1962.0724
854: , p5_a3 DATE := fnd_api.g_miss_date
855: , p5_a4 DATE := fnd_api.g_miss_date
856: , p5_a5 DATE := fnd_api.g_miss_date
857: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a8 NUMBER := 0-1962.0724
852: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a2 NUMBER := 0-1962.0724
854: , p5_a3 DATE := fnd_api.g_miss_date
855: , p5_a4 DATE := fnd_api.g_miss_date
856: , p5_a5 DATE := fnd_api.g_miss_date
857: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a8 NUMBER := 0-1962.0724
860: , p5_a9 NUMBER := 0-1962.0724
853: , p5_a2 NUMBER := 0-1962.0724
854: , p5_a3 DATE := fnd_api.g_miss_date
855: , p5_a4 DATE := fnd_api.g_miss_date
856: , p5_a5 DATE := fnd_api.g_miss_date
857: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a8 NUMBER := 0-1962.0724
860: , p5_a9 NUMBER := 0-1962.0724
861: , p5_a10 NUMBER := 0-1962.0724
854: , p5_a3 DATE := fnd_api.g_miss_date
855: , p5_a4 DATE := fnd_api.g_miss_date
856: , p5_a5 DATE := fnd_api.g_miss_date
857: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a8 NUMBER := 0-1962.0724
860: , p5_a9 NUMBER := 0-1962.0724
861: , p5_a10 NUMBER := 0-1962.0724
862: , p5_a11 NUMBER := 0-1962.0724
859: , p5_a8 NUMBER := 0-1962.0724
860: , p5_a9 NUMBER := 0-1962.0724
861: , p5_a10 NUMBER := 0-1962.0724
862: , p5_a11 NUMBER := 0-1962.0724
863: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a13 NUMBER := 0-1962.0724
865: , p5_a14 NUMBER := 0-1962.0724
866: , p5_a15 NUMBER := 0-1962.0724
867: , p5_a16 NUMBER := 0-1962.0724
864: , p5_a13 NUMBER := 0-1962.0724
865: , p5_a14 NUMBER := 0-1962.0724
866: , p5_a15 NUMBER := 0-1962.0724
867: , p5_a16 NUMBER := 0-1962.0724
868: , p5_a17 DATE := fnd_api.g_miss_date
869: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a14 NUMBER := 0-1962.0724
866: , p5_a15 NUMBER := 0-1962.0724
867: , p5_a16 NUMBER := 0-1962.0724
868: , p5_a17 DATE := fnd_api.g_miss_date
869: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a15 NUMBER := 0-1962.0724
867: , p5_a16 NUMBER := 0-1962.0724
868: , p5_a17 DATE := fnd_api.g_miss_date
869: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a16 NUMBER := 0-1962.0724
868: , p5_a17 DATE := fnd_api.g_miss_date
869: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a17 DATE := fnd_api.g_miss_date
869: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
869: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
870: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
870: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
871: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
871: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
872: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
879: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
872: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
873: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
879: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
880: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
873: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
874: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
879: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
880: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
881: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
874: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
875: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
879: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
880: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
881: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
882: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
875: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
879: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
880: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
881: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
882: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
883: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
879: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
880: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
881: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
882: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
883: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
884: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
879: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
880: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
881: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
882: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
883: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
884: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
885: , p5_a34 NUMBER := 0-1962.0724
878: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
879: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
880: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
881: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
882: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
883: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
884: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
885: , p5_a34 NUMBER := 0-1962.0724
886: , p5_a35 DATE := fnd_api.g_miss_date
879: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
880: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
881: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
882: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
883: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
884: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
885: , p5_a34 NUMBER := 0-1962.0724
886: , p5_a35 DATE := fnd_api.g_miss_date
887: , p5_a36 NUMBER := 0-1962.0724
880: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
881: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
882: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
883: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
884: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
885: , p5_a34 NUMBER := 0-1962.0724
886: , p5_a35 DATE := fnd_api.g_miss_date
887: , p5_a36 NUMBER := 0-1962.0724
888: , p5_a37 DATE := fnd_api.g_miss_date
882: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
883: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
884: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
885: , p5_a34 NUMBER := 0-1962.0724
886: , p5_a35 DATE := fnd_api.g_miss_date
887: , p5_a36 NUMBER := 0-1962.0724
888: , p5_a37 DATE := fnd_api.g_miss_date
889: , p5_a38 NUMBER := 0-1962.0724
890: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
884: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
885: , p5_a34 NUMBER := 0-1962.0724
886: , p5_a35 DATE := fnd_api.g_miss_date
887: , p5_a36 NUMBER := 0-1962.0724
888: , p5_a37 DATE := fnd_api.g_miss_date
889: , p5_a38 NUMBER := 0-1962.0724
890: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
891: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
892: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
886: , p5_a35 DATE := fnd_api.g_miss_date
887: , p5_a36 NUMBER := 0-1962.0724
888: , p5_a37 DATE := fnd_api.g_miss_date
889: , p5_a38 NUMBER := 0-1962.0724
890: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
891: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
892: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
893: , p5_a42 NUMBER := 0-1962.0724
894: , p5_a43 DATE := fnd_api.g_miss_date
887: , p5_a36 NUMBER := 0-1962.0724
888: , p5_a37 DATE := fnd_api.g_miss_date
889: , p5_a38 NUMBER := 0-1962.0724
890: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
891: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
892: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
893: , p5_a42 NUMBER := 0-1962.0724
894: , p5_a43 DATE := fnd_api.g_miss_date
895: )
888: , p5_a37 DATE := fnd_api.g_miss_date
889: , p5_a38 NUMBER := 0-1962.0724
890: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
891: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
892: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
893: , p5_a42 NUMBER := 0-1962.0724
894: , p5_a43 DATE := fnd_api.g_miss_date
895: )
896:
890: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
891: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
892: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
893: , p5_a42 NUMBER := 0-1962.0724
894: , p5_a43 DATE := fnd_api.g_miss_date
895: )
896:
897: as
898: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;
1236: , x_return_status out nocopy VARCHAR2
1237: , x_msg_count out nocopy NUMBER
1238: , x_msg_data out nocopy VARCHAR2
1239: , p5_a0 NUMBER := 0-1962.0724
1240: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a2 NUMBER := 0-1962.0724
1242: , p5_a3 DATE := fnd_api.g_miss_date
1243: , p5_a4 DATE := fnd_api.g_miss_date
1244: , p5_a5 DATE := fnd_api.g_miss_date
1238: , x_msg_data out nocopy VARCHAR2
1239: , p5_a0 NUMBER := 0-1962.0724
1240: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a2 NUMBER := 0-1962.0724
1242: , p5_a3 DATE := fnd_api.g_miss_date
1243: , p5_a4 DATE := fnd_api.g_miss_date
1244: , p5_a5 DATE := fnd_api.g_miss_date
1245: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a0 NUMBER := 0-1962.0724
1240: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a2 NUMBER := 0-1962.0724
1242: , p5_a3 DATE := fnd_api.g_miss_date
1243: , p5_a4 DATE := fnd_api.g_miss_date
1244: , p5_a5 DATE := fnd_api.g_miss_date
1245: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1247: , p5_a8 NUMBER := 0-1962.0724
1240: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a2 NUMBER := 0-1962.0724
1242: , p5_a3 DATE := fnd_api.g_miss_date
1243: , p5_a4 DATE := fnd_api.g_miss_date
1244: , p5_a5 DATE := fnd_api.g_miss_date
1245: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1247: , p5_a8 NUMBER := 0-1962.0724
1248: , p5_a9 NUMBER := 0-1962.0724
1241: , p5_a2 NUMBER := 0-1962.0724
1242: , p5_a3 DATE := fnd_api.g_miss_date
1243: , p5_a4 DATE := fnd_api.g_miss_date
1244: , p5_a5 DATE := fnd_api.g_miss_date
1245: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1247: , p5_a8 NUMBER := 0-1962.0724
1248: , p5_a9 NUMBER := 0-1962.0724
1249: , p5_a10 NUMBER := 0-1962.0724
1242: , p5_a3 DATE := fnd_api.g_miss_date
1243: , p5_a4 DATE := fnd_api.g_miss_date
1244: , p5_a5 DATE := fnd_api.g_miss_date
1245: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1247: , p5_a8 NUMBER := 0-1962.0724
1248: , p5_a9 NUMBER := 0-1962.0724
1249: , p5_a10 NUMBER := 0-1962.0724
1250: , p5_a11 NUMBER := 0-1962.0724
1247: , p5_a8 NUMBER := 0-1962.0724
1248: , p5_a9 NUMBER := 0-1962.0724
1249: , p5_a10 NUMBER := 0-1962.0724
1250: , p5_a11 NUMBER := 0-1962.0724
1251: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1252: , p5_a13 NUMBER := 0-1962.0724
1253: , p5_a14 NUMBER := 0-1962.0724
1254: , p5_a15 NUMBER := 0-1962.0724
1255: , p5_a16 NUMBER := 0-1962.0724
1252: , p5_a13 NUMBER := 0-1962.0724
1253: , p5_a14 NUMBER := 0-1962.0724
1254: , p5_a15 NUMBER := 0-1962.0724
1255: , p5_a16 NUMBER := 0-1962.0724
1256: , p5_a17 DATE := fnd_api.g_miss_date
1257: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1253: , p5_a14 NUMBER := 0-1962.0724
1254: , p5_a15 NUMBER := 0-1962.0724
1255: , p5_a16 NUMBER := 0-1962.0724
1256: , p5_a17 DATE := fnd_api.g_miss_date
1257: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1254: , p5_a15 NUMBER := 0-1962.0724
1255: , p5_a16 NUMBER := 0-1962.0724
1256: , p5_a17 DATE := fnd_api.g_miss_date
1257: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1255: , p5_a16 NUMBER := 0-1962.0724
1256: , p5_a17 DATE := fnd_api.g_miss_date
1257: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1256: , p5_a17 DATE := fnd_api.g_miss_date
1257: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1257: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1258: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1262: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a34 NUMBER := 0-1962.0724
1266: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a34 NUMBER := 0-1962.0724
1274: , p5_a35 DATE := fnd_api.g_miss_date
1267: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a34 NUMBER := 0-1962.0724
1274: , p5_a35 DATE := fnd_api.g_miss_date
1275: , p5_a36 NUMBER := 0-1962.0724
1268: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a34 NUMBER := 0-1962.0724
1274: , p5_a35 DATE := fnd_api.g_miss_date
1275: , p5_a36 NUMBER := 0-1962.0724
1276: , p5_a37 DATE := fnd_api.g_miss_date
1270: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a34 NUMBER := 0-1962.0724
1274: , p5_a35 DATE := fnd_api.g_miss_date
1275: , p5_a36 NUMBER := 0-1962.0724
1276: , p5_a37 DATE := fnd_api.g_miss_date
1277: , p5_a38 NUMBER := 0-1962.0724
1278: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a34 NUMBER := 0-1962.0724
1274: , p5_a35 DATE := fnd_api.g_miss_date
1275: , p5_a36 NUMBER := 0-1962.0724
1276: , p5_a37 DATE := fnd_api.g_miss_date
1277: , p5_a38 NUMBER := 0-1962.0724
1278: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1274: , p5_a35 DATE := fnd_api.g_miss_date
1275: , p5_a36 NUMBER := 0-1962.0724
1276: , p5_a37 DATE := fnd_api.g_miss_date
1277: , p5_a38 NUMBER := 0-1962.0724
1278: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a42 NUMBER := 0-1962.0724
1282: , p5_a43 DATE := fnd_api.g_miss_date
1275: , p5_a36 NUMBER := 0-1962.0724
1276: , p5_a37 DATE := fnd_api.g_miss_date
1277: , p5_a38 NUMBER := 0-1962.0724
1278: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a42 NUMBER := 0-1962.0724
1282: , p5_a43 DATE := fnd_api.g_miss_date
1283: )
1276: , p5_a37 DATE := fnd_api.g_miss_date
1277: , p5_a38 NUMBER := 0-1962.0724
1278: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a42 NUMBER := 0-1962.0724
1282: , p5_a43 DATE := fnd_api.g_miss_date
1283: )
1284:
1278: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a42 NUMBER := 0-1962.0724
1282: , p5_a43 DATE := fnd_api.g_miss_date
1283: )
1284:
1285: as
1286: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;
1527: , p6_a41 out nocopy VARCHAR2
1528: , p6_a42 out nocopy NUMBER
1529: , p6_a43 out nocopy DATE
1530: , p5_a0 NUMBER := 0-1962.0724
1531: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1532: , p5_a2 NUMBER := 0-1962.0724
1533: , p5_a3 DATE := fnd_api.g_miss_date
1534: , p5_a4 DATE := fnd_api.g_miss_date
1535: , p5_a5 DATE := fnd_api.g_miss_date
1529: , p6_a43 out nocopy DATE
1530: , p5_a0 NUMBER := 0-1962.0724
1531: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1532: , p5_a2 NUMBER := 0-1962.0724
1533: , p5_a3 DATE := fnd_api.g_miss_date
1534: , p5_a4 DATE := fnd_api.g_miss_date
1535: , p5_a5 DATE := fnd_api.g_miss_date
1536: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1537: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1530: , p5_a0 NUMBER := 0-1962.0724
1531: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1532: , p5_a2 NUMBER := 0-1962.0724
1533: , p5_a3 DATE := fnd_api.g_miss_date
1534: , p5_a4 DATE := fnd_api.g_miss_date
1535: , p5_a5 DATE := fnd_api.g_miss_date
1536: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1537: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1538: , p5_a8 NUMBER := 0-1962.0724
1531: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1532: , p5_a2 NUMBER := 0-1962.0724
1533: , p5_a3 DATE := fnd_api.g_miss_date
1534: , p5_a4 DATE := fnd_api.g_miss_date
1535: , p5_a5 DATE := fnd_api.g_miss_date
1536: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1537: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1538: , p5_a8 NUMBER := 0-1962.0724
1539: , p5_a9 NUMBER := 0-1962.0724
1532: , p5_a2 NUMBER := 0-1962.0724
1533: , p5_a3 DATE := fnd_api.g_miss_date
1534: , p5_a4 DATE := fnd_api.g_miss_date
1535: , p5_a5 DATE := fnd_api.g_miss_date
1536: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1537: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1538: , p5_a8 NUMBER := 0-1962.0724
1539: , p5_a9 NUMBER := 0-1962.0724
1540: , p5_a10 NUMBER := 0-1962.0724
1533: , p5_a3 DATE := fnd_api.g_miss_date
1534: , p5_a4 DATE := fnd_api.g_miss_date
1535: , p5_a5 DATE := fnd_api.g_miss_date
1536: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1537: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1538: , p5_a8 NUMBER := 0-1962.0724
1539: , p5_a9 NUMBER := 0-1962.0724
1540: , p5_a10 NUMBER := 0-1962.0724
1541: , p5_a11 NUMBER := 0-1962.0724
1538: , p5_a8 NUMBER := 0-1962.0724
1539: , p5_a9 NUMBER := 0-1962.0724
1540: , p5_a10 NUMBER := 0-1962.0724
1541: , p5_a11 NUMBER := 0-1962.0724
1542: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1543: , p5_a13 NUMBER := 0-1962.0724
1544: , p5_a14 NUMBER := 0-1962.0724
1545: , p5_a15 NUMBER := 0-1962.0724
1546: , p5_a16 NUMBER := 0-1962.0724
1543: , p5_a13 NUMBER := 0-1962.0724
1544: , p5_a14 NUMBER := 0-1962.0724
1545: , p5_a15 NUMBER := 0-1962.0724
1546: , p5_a16 NUMBER := 0-1962.0724
1547: , p5_a17 DATE := fnd_api.g_miss_date
1548: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1549: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1550: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1551: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1544: , p5_a14 NUMBER := 0-1962.0724
1545: , p5_a15 NUMBER := 0-1962.0724
1546: , p5_a16 NUMBER := 0-1962.0724
1547: , p5_a17 DATE := fnd_api.g_miss_date
1548: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1549: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1550: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1551: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1552: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1545: , p5_a15 NUMBER := 0-1962.0724
1546: , p5_a16 NUMBER := 0-1962.0724
1547: , p5_a17 DATE := fnd_api.g_miss_date
1548: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1549: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1550: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1551: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1552: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1553: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1546: , p5_a16 NUMBER := 0-1962.0724
1547: , p5_a17 DATE := fnd_api.g_miss_date
1548: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1549: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1550: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1551: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1552: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1553: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1554: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1547: , p5_a17 DATE := fnd_api.g_miss_date
1548: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1549: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1550: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1551: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1552: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1553: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1554: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1555: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1548: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1549: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1550: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1551: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1552: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1553: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1554: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1555: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1556: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1549: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1550: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1551: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1552: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1553: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1554: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1555: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1556: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1557: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1550: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1551: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1552: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1553: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1554: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1555: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1556: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1557: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1558: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1551: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1552: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1553: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1554: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1555: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1556: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1557: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1558: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1559: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1552: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1553: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1554: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1555: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1556: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1557: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1558: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1559: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1553: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1554: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1555: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1556: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1557: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1558: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1559: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1561: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1554: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1555: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1556: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1557: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1558: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1559: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1561: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1562: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1555: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1556: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1557: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1558: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1559: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1561: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1562: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1556: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1557: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1558: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1559: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1561: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1562: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a34 NUMBER := 0-1962.0724
1557: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1558: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1559: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1561: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1562: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a34 NUMBER := 0-1962.0724
1565: , p5_a35 DATE := fnd_api.g_miss_date
1558: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1559: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1561: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1562: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a34 NUMBER := 0-1962.0724
1565: , p5_a35 DATE := fnd_api.g_miss_date
1566: , p5_a36 NUMBER := 0-1962.0724
1559: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1561: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1562: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a34 NUMBER := 0-1962.0724
1565: , p5_a35 DATE := fnd_api.g_miss_date
1566: , p5_a36 NUMBER := 0-1962.0724
1567: , p5_a37 DATE := fnd_api.g_miss_date
1561: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1562: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a34 NUMBER := 0-1962.0724
1565: , p5_a35 DATE := fnd_api.g_miss_date
1566: , p5_a36 NUMBER := 0-1962.0724
1567: , p5_a37 DATE := fnd_api.g_miss_date
1568: , p5_a38 NUMBER := 0-1962.0724
1569: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a34 NUMBER := 0-1962.0724
1565: , p5_a35 DATE := fnd_api.g_miss_date
1566: , p5_a36 NUMBER := 0-1962.0724
1567: , p5_a37 DATE := fnd_api.g_miss_date
1568: , p5_a38 NUMBER := 0-1962.0724
1569: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a35 DATE := fnd_api.g_miss_date
1566: , p5_a36 NUMBER := 0-1962.0724
1567: , p5_a37 DATE := fnd_api.g_miss_date
1568: , p5_a38 NUMBER := 0-1962.0724
1569: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a42 NUMBER := 0-1962.0724
1573: , p5_a43 DATE := fnd_api.g_miss_date
1566: , p5_a36 NUMBER := 0-1962.0724
1567: , p5_a37 DATE := fnd_api.g_miss_date
1568: , p5_a38 NUMBER := 0-1962.0724
1569: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a42 NUMBER := 0-1962.0724
1573: , p5_a43 DATE := fnd_api.g_miss_date
1574: )
1567: , p5_a37 DATE := fnd_api.g_miss_date
1568: , p5_a38 NUMBER := 0-1962.0724
1569: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a42 NUMBER := 0-1962.0724
1573: , p5_a43 DATE := fnd_api.g_miss_date
1574: )
1575:
1569: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a42 NUMBER := 0-1962.0724
1573: , p5_a43 DATE := fnd_api.g_miss_date
1574: )
1575:
1576: as
1577: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;
1915: , x_return_status out nocopy VARCHAR2
1916: , x_msg_count out nocopy NUMBER
1917: , x_msg_data out nocopy VARCHAR2
1918: , p5_a0 NUMBER := 0-1962.0724
1919: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1920: , p5_a2 NUMBER := 0-1962.0724
1921: , p5_a3 DATE := fnd_api.g_miss_date
1922: , p5_a4 DATE := fnd_api.g_miss_date
1923: , p5_a5 DATE := fnd_api.g_miss_date
1917: , x_msg_data out nocopy VARCHAR2
1918: , p5_a0 NUMBER := 0-1962.0724
1919: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1920: , p5_a2 NUMBER := 0-1962.0724
1921: , p5_a3 DATE := fnd_api.g_miss_date
1922: , p5_a4 DATE := fnd_api.g_miss_date
1923: , p5_a5 DATE := fnd_api.g_miss_date
1924: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1918: , p5_a0 NUMBER := 0-1962.0724
1919: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1920: , p5_a2 NUMBER := 0-1962.0724
1921: , p5_a3 DATE := fnd_api.g_miss_date
1922: , p5_a4 DATE := fnd_api.g_miss_date
1923: , p5_a5 DATE := fnd_api.g_miss_date
1924: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a8 NUMBER := 0-1962.0724
1919: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1920: , p5_a2 NUMBER := 0-1962.0724
1921: , p5_a3 DATE := fnd_api.g_miss_date
1922: , p5_a4 DATE := fnd_api.g_miss_date
1923: , p5_a5 DATE := fnd_api.g_miss_date
1924: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a8 NUMBER := 0-1962.0724
1927: , p5_a9 NUMBER := 0-1962.0724
1920: , p5_a2 NUMBER := 0-1962.0724
1921: , p5_a3 DATE := fnd_api.g_miss_date
1922: , p5_a4 DATE := fnd_api.g_miss_date
1923: , p5_a5 DATE := fnd_api.g_miss_date
1924: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a8 NUMBER := 0-1962.0724
1927: , p5_a9 NUMBER := 0-1962.0724
1928: , p5_a10 NUMBER := 0-1962.0724
1921: , p5_a3 DATE := fnd_api.g_miss_date
1922: , p5_a4 DATE := fnd_api.g_miss_date
1923: , p5_a5 DATE := fnd_api.g_miss_date
1924: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a8 NUMBER := 0-1962.0724
1927: , p5_a9 NUMBER := 0-1962.0724
1928: , p5_a10 NUMBER := 0-1962.0724
1929: , p5_a11 NUMBER := 0-1962.0724
1926: , p5_a8 NUMBER := 0-1962.0724
1927: , p5_a9 NUMBER := 0-1962.0724
1928: , p5_a10 NUMBER := 0-1962.0724
1929: , p5_a11 NUMBER := 0-1962.0724
1930: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1931: , p5_a13 NUMBER := 0-1962.0724
1932: , p5_a14 NUMBER := 0-1962.0724
1933: , p5_a15 NUMBER := 0-1962.0724
1934: , p5_a16 NUMBER := 0-1962.0724
1931: , p5_a13 NUMBER := 0-1962.0724
1932: , p5_a14 NUMBER := 0-1962.0724
1933: , p5_a15 NUMBER := 0-1962.0724
1934: , p5_a16 NUMBER := 0-1962.0724
1935: , p5_a17 DATE := fnd_api.g_miss_date
1936: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1932: , p5_a14 NUMBER := 0-1962.0724
1933: , p5_a15 NUMBER := 0-1962.0724
1934: , p5_a16 NUMBER := 0-1962.0724
1935: , p5_a17 DATE := fnd_api.g_miss_date
1936: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1933: , p5_a15 NUMBER := 0-1962.0724
1934: , p5_a16 NUMBER := 0-1962.0724
1935: , p5_a17 DATE := fnd_api.g_miss_date
1936: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1934: , p5_a16 NUMBER := 0-1962.0724
1935: , p5_a17 DATE := fnd_api.g_miss_date
1936: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1935: , p5_a17 DATE := fnd_api.g_miss_date
1936: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1936: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1946: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1946: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1946: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1946: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1946: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1950: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1946: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1950: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1951: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1946: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1950: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1951: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a34 NUMBER := 0-1962.0724
1945: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1946: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1950: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1951: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a34 NUMBER := 0-1962.0724
1953: , p5_a35 DATE := fnd_api.g_miss_date
1946: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1950: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1951: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a34 NUMBER := 0-1962.0724
1953: , p5_a35 DATE := fnd_api.g_miss_date
1954: , p5_a36 NUMBER := 0-1962.0724
1947: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1950: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1951: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a34 NUMBER := 0-1962.0724
1953: , p5_a35 DATE := fnd_api.g_miss_date
1954: , p5_a36 NUMBER := 0-1962.0724
1955: , p5_a37 DATE := fnd_api.g_miss_date
1949: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1950: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1951: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a34 NUMBER := 0-1962.0724
1953: , p5_a35 DATE := fnd_api.g_miss_date
1954: , p5_a36 NUMBER := 0-1962.0724
1955: , p5_a37 DATE := fnd_api.g_miss_date
1956: , p5_a38 NUMBER := 0-1962.0724
1957: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1951: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a34 NUMBER := 0-1962.0724
1953: , p5_a35 DATE := fnd_api.g_miss_date
1954: , p5_a36 NUMBER := 0-1962.0724
1955: , p5_a37 DATE := fnd_api.g_miss_date
1956: , p5_a38 NUMBER := 0-1962.0724
1957: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1953: , p5_a35 DATE := fnd_api.g_miss_date
1954: , p5_a36 NUMBER := 0-1962.0724
1955: , p5_a37 DATE := fnd_api.g_miss_date
1956: , p5_a38 NUMBER := 0-1962.0724
1957: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a42 NUMBER := 0-1962.0724
1961: , p5_a43 DATE := fnd_api.g_miss_date
1954: , p5_a36 NUMBER := 0-1962.0724
1955: , p5_a37 DATE := fnd_api.g_miss_date
1956: , p5_a38 NUMBER := 0-1962.0724
1957: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a42 NUMBER := 0-1962.0724
1961: , p5_a43 DATE := fnd_api.g_miss_date
1962: )
1955: , p5_a37 DATE := fnd_api.g_miss_date
1956: , p5_a38 NUMBER := 0-1962.0724
1957: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a42 NUMBER := 0-1962.0724
1961: , p5_a43 DATE := fnd_api.g_miss_date
1962: )
1963:
1957: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a42 NUMBER := 0-1962.0724
1961: , p5_a43 DATE := fnd_api.g_miss_date
1962: )
1963:
1964: as
1965: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;
2162: , x_return_status out nocopy VARCHAR2
2163: , x_msg_count out nocopy NUMBER
2164: , x_msg_data out nocopy VARCHAR2
2165: , p5_a0 NUMBER := 0-1962.0724
2166: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
2167: , p5_a2 NUMBER := 0-1962.0724
2168: , p5_a3 DATE := fnd_api.g_miss_date
2169: , p5_a4 DATE := fnd_api.g_miss_date
2170: , p5_a5 DATE := fnd_api.g_miss_date
2164: , x_msg_data out nocopy VARCHAR2
2165: , p5_a0 NUMBER := 0-1962.0724
2166: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
2167: , p5_a2 NUMBER := 0-1962.0724
2168: , p5_a3 DATE := fnd_api.g_miss_date
2169: , p5_a4 DATE := fnd_api.g_miss_date
2170: , p5_a5 DATE := fnd_api.g_miss_date
2171: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2172: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2165: , p5_a0 NUMBER := 0-1962.0724
2166: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
2167: , p5_a2 NUMBER := 0-1962.0724
2168: , p5_a3 DATE := fnd_api.g_miss_date
2169: , p5_a4 DATE := fnd_api.g_miss_date
2170: , p5_a5 DATE := fnd_api.g_miss_date
2171: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2172: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2173: , p5_a8 NUMBER := 0-1962.0724
2166: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
2167: , p5_a2 NUMBER := 0-1962.0724
2168: , p5_a3 DATE := fnd_api.g_miss_date
2169: , p5_a4 DATE := fnd_api.g_miss_date
2170: , p5_a5 DATE := fnd_api.g_miss_date
2171: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2172: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2173: , p5_a8 NUMBER := 0-1962.0724
2174: , p5_a9 NUMBER := 0-1962.0724
2167: , p5_a2 NUMBER := 0-1962.0724
2168: , p5_a3 DATE := fnd_api.g_miss_date
2169: , p5_a4 DATE := fnd_api.g_miss_date
2170: , p5_a5 DATE := fnd_api.g_miss_date
2171: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2172: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2173: , p5_a8 NUMBER := 0-1962.0724
2174: , p5_a9 NUMBER := 0-1962.0724
2175: , p5_a10 NUMBER := 0-1962.0724
2168: , p5_a3 DATE := fnd_api.g_miss_date
2169: , p5_a4 DATE := fnd_api.g_miss_date
2170: , p5_a5 DATE := fnd_api.g_miss_date
2171: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2172: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2173: , p5_a8 NUMBER := 0-1962.0724
2174: , p5_a9 NUMBER := 0-1962.0724
2175: , p5_a10 NUMBER := 0-1962.0724
2176: , p5_a11 NUMBER := 0-1962.0724
2173: , p5_a8 NUMBER := 0-1962.0724
2174: , p5_a9 NUMBER := 0-1962.0724
2175: , p5_a10 NUMBER := 0-1962.0724
2176: , p5_a11 NUMBER := 0-1962.0724
2177: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2178: , p5_a13 NUMBER := 0-1962.0724
2179: , p5_a14 NUMBER := 0-1962.0724
2180: , p5_a15 NUMBER := 0-1962.0724
2181: , p5_a16 NUMBER := 0-1962.0724
2178: , p5_a13 NUMBER := 0-1962.0724
2179: , p5_a14 NUMBER := 0-1962.0724
2180: , p5_a15 NUMBER := 0-1962.0724
2181: , p5_a16 NUMBER := 0-1962.0724
2182: , p5_a17 DATE := fnd_api.g_miss_date
2183: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2184: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2185: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2186: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2179: , p5_a14 NUMBER := 0-1962.0724
2180: , p5_a15 NUMBER := 0-1962.0724
2181: , p5_a16 NUMBER := 0-1962.0724
2182: , p5_a17 DATE := fnd_api.g_miss_date
2183: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2184: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2185: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2186: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2187: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2180: , p5_a15 NUMBER := 0-1962.0724
2181: , p5_a16 NUMBER := 0-1962.0724
2182: , p5_a17 DATE := fnd_api.g_miss_date
2183: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2184: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2185: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2186: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2187: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2188: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2181: , p5_a16 NUMBER := 0-1962.0724
2182: , p5_a17 DATE := fnd_api.g_miss_date
2183: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2184: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2185: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2186: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2187: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2188: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2189: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2182: , p5_a17 DATE := fnd_api.g_miss_date
2183: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2184: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2185: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2186: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2187: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2188: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2189: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2190: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2183: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2184: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2185: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2186: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2187: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2188: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2189: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2190: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2191: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2184: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2185: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2186: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2187: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2188: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2189: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2190: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2191: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2192: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2185: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2186: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2187: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2188: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2189: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2190: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2191: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2192: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2193: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2186: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2187: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2188: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2189: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2190: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2191: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2192: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2193: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2194: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2187: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2188: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2189: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2190: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2191: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2192: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2193: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2194: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2195: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2188: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2189: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2190: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2191: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2192: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2193: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2194: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2195: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2196: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2189: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2190: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2191: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2192: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2193: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2194: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2195: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2196: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2197: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2190: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2191: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2192: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2193: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2194: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2195: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2196: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2197: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2198: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2191: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2192: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2193: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2194: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2195: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2196: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2197: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2198: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2199: , p5_a34 NUMBER := 0-1962.0724
2192: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2193: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2194: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2195: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2196: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2197: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2198: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2199: , p5_a34 NUMBER := 0-1962.0724
2200: , p5_a35 DATE := fnd_api.g_miss_date
2193: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2194: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2195: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2196: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2197: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2198: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2199: , p5_a34 NUMBER := 0-1962.0724
2200: , p5_a35 DATE := fnd_api.g_miss_date
2201: , p5_a36 NUMBER := 0-1962.0724
2194: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2195: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2196: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2197: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2198: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2199: , p5_a34 NUMBER := 0-1962.0724
2200: , p5_a35 DATE := fnd_api.g_miss_date
2201: , p5_a36 NUMBER := 0-1962.0724
2202: , p5_a37 DATE := fnd_api.g_miss_date
2196: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2197: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2198: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2199: , p5_a34 NUMBER := 0-1962.0724
2200: , p5_a35 DATE := fnd_api.g_miss_date
2201: , p5_a36 NUMBER := 0-1962.0724
2202: , p5_a37 DATE := fnd_api.g_miss_date
2203: , p5_a38 NUMBER := 0-1962.0724
2204: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2198: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2199: , p5_a34 NUMBER := 0-1962.0724
2200: , p5_a35 DATE := fnd_api.g_miss_date
2201: , p5_a36 NUMBER := 0-1962.0724
2202: , p5_a37 DATE := fnd_api.g_miss_date
2203: , p5_a38 NUMBER := 0-1962.0724
2204: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2205: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2206: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2200: , p5_a35 DATE := fnd_api.g_miss_date
2201: , p5_a36 NUMBER := 0-1962.0724
2202: , p5_a37 DATE := fnd_api.g_miss_date
2203: , p5_a38 NUMBER := 0-1962.0724
2204: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2205: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2206: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2207: , p5_a42 NUMBER := 0-1962.0724
2208: , p5_a43 DATE := fnd_api.g_miss_date
2201: , p5_a36 NUMBER := 0-1962.0724
2202: , p5_a37 DATE := fnd_api.g_miss_date
2203: , p5_a38 NUMBER := 0-1962.0724
2204: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2205: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2206: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2207: , p5_a42 NUMBER := 0-1962.0724
2208: , p5_a43 DATE := fnd_api.g_miss_date
2209: )
2202: , p5_a37 DATE := fnd_api.g_miss_date
2203: , p5_a38 NUMBER := 0-1962.0724
2204: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2205: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2206: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2207: , p5_a42 NUMBER := 0-1962.0724
2208: , p5_a43 DATE := fnd_api.g_miss_date
2209: )
2210:
2204: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2205: , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2206: , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2207: , p5_a42 NUMBER := 0-1962.0724
2208: , p5_a43 DATE := fnd_api.g_miss_date
2209: )
2210:
2211: as
2212: ddp_pflv_rec okl_pfl_pvt.pflv_rec_type;