7:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;
1002: , p6_a52 out nocopy VARCHAR2
1003: , p6_a53 out nocopy NUMBER
1004: , p5_a0 NUMBER := 0-1962.0724
1005: , p5_a1 NUMBER := 0-1962.0724
1006: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1007: , p5_a3 NUMBER := 0-1962.0724
1008: , p5_a4 NUMBER := 0-1962.0724
1009: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a6 NUMBER := 0-1962.0724
1005: , p5_a1 NUMBER := 0-1962.0724
1006: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1007: , p5_a3 NUMBER := 0-1962.0724
1008: , p5_a4 NUMBER := 0-1962.0724
1009: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a6 NUMBER := 0-1962.0724
1011: , p5_a7 NUMBER := 0-1962.0724
1012: , p5_a8 NUMBER := 0-1962.0724
1013: , p5_a9 NUMBER := 0-1962.0724
1011: , p5_a7 NUMBER := 0-1962.0724
1012: , p5_a8 NUMBER := 0-1962.0724
1013: , p5_a9 NUMBER := 0-1962.0724
1014: , p5_a10 NUMBER := 0-1962.0724
1015: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a12 NUMBER := 0-1962.0724
1017: , p5_a13 NUMBER := 0-1962.0724
1018: , p5_a14 DATE := fnd_api.g_miss_date
1019: , p5_a15 NUMBER := 0-1962.0724
1014: , p5_a10 NUMBER := 0-1962.0724
1015: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a12 NUMBER := 0-1962.0724
1017: , p5_a13 NUMBER := 0-1962.0724
1018: , p5_a14 DATE := fnd_api.g_miss_date
1019: , p5_a15 NUMBER := 0-1962.0724
1020: , p5_a16 NUMBER := 0-1962.0724
1021: , p5_a17 NUMBER := 0-1962.0724
1022: , p5_a18 NUMBER := 0-1962.0724
1020: , p5_a16 NUMBER := 0-1962.0724
1021: , p5_a17 NUMBER := 0-1962.0724
1022: , p5_a18 NUMBER := 0-1962.0724
1023: , p5_a19 NUMBER := 0-1962.0724
1024: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a17 NUMBER := 0-1962.0724
1022: , p5_a18 NUMBER := 0-1962.0724
1023: , p5_a19 NUMBER := 0-1962.0724
1024: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a18 NUMBER := 0-1962.0724
1023: , p5_a19 NUMBER := 0-1962.0724
1024: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a19 NUMBER := 0-1962.0724
1024: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a38 NUMBER := 0-1962.0724
1035: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a38 NUMBER := 0-1962.0724
1043: , p5_a39 NUMBER := 0-1962.0724
1036: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a38 NUMBER := 0-1962.0724
1043: , p5_a39 NUMBER := 0-1962.0724
1044: , p5_a40 NUMBER := 0-1962.0724
1037: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a38 NUMBER := 0-1962.0724
1043: , p5_a39 NUMBER := 0-1962.0724
1044: , p5_a40 NUMBER := 0-1962.0724
1045: , p5_a41 DATE := fnd_api.g_miss_date
1041: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a38 NUMBER := 0-1962.0724
1043: , p5_a39 NUMBER := 0-1962.0724
1044: , p5_a40 NUMBER := 0-1962.0724
1045: , p5_a41 DATE := fnd_api.g_miss_date
1046: , p5_a42 NUMBER := 0-1962.0724
1047: , p5_a43 NUMBER := 0-1962.0724
1048: , p5_a44 DATE := fnd_api.g_miss_date
1049: , p5_a45 NUMBER := 0-1962.0724
1044: , p5_a40 NUMBER := 0-1962.0724
1045: , p5_a41 DATE := fnd_api.g_miss_date
1046: , p5_a42 NUMBER := 0-1962.0724
1047: , p5_a43 NUMBER := 0-1962.0724
1048: , p5_a44 DATE := fnd_api.g_miss_date
1049: , p5_a45 NUMBER := 0-1962.0724
1050: , p5_a46 DATE := fnd_api.g_miss_date
1051: , p5_a47 NUMBER := 0-1962.0724
1052: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1046: , p5_a42 NUMBER := 0-1962.0724
1047: , p5_a43 NUMBER := 0-1962.0724
1048: , p5_a44 DATE := fnd_api.g_miss_date
1049: , p5_a45 NUMBER := 0-1962.0724
1050: , p5_a46 DATE := fnd_api.g_miss_date
1051: , p5_a47 NUMBER := 0-1962.0724
1052: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a50 NUMBER := 0-1962.0724
1048: , p5_a44 DATE := fnd_api.g_miss_date
1049: , p5_a45 NUMBER := 0-1962.0724
1050: , p5_a46 DATE := fnd_api.g_miss_date
1051: , p5_a47 NUMBER := 0-1962.0724
1052: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a50 NUMBER := 0-1962.0724
1055: , p5_a51 NUMBER := 0-1962.0724
1056: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1049: , p5_a45 NUMBER := 0-1962.0724
1050: , p5_a46 DATE := fnd_api.g_miss_date
1051: , p5_a47 NUMBER := 0-1962.0724
1052: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a50 NUMBER := 0-1962.0724
1055: , p5_a51 NUMBER := 0-1962.0724
1056: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1057: , p5_a53 NUMBER := 0-1962.0724
1052: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1053: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1054: , p5_a50 NUMBER := 0-1962.0724
1055: , p5_a51 NUMBER := 0-1962.0724
1056: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1057: , p5_a53 NUMBER := 0-1962.0724
1058: )
1059:
1060: as
1460: , x_msg_count out nocopy NUMBER
1461: , x_msg_data out nocopy VARCHAR2
1462: , p5_a0 NUMBER := 0-1962.0724
1463: , p5_a1 NUMBER := 0-1962.0724
1464: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a3 NUMBER := 0-1962.0724
1466: , p5_a4 NUMBER := 0-1962.0724
1467: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a6 NUMBER := 0-1962.0724
1463: , p5_a1 NUMBER := 0-1962.0724
1464: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a3 NUMBER := 0-1962.0724
1466: , p5_a4 NUMBER := 0-1962.0724
1467: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a6 NUMBER := 0-1962.0724
1469: , p5_a7 NUMBER := 0-1962.0724
1470: , p5_a8 NUMBER := 0-1962.0724
1471: , p5_a9 NUMBER := 0-1962.0724
1469: , p5_a7 NUMBER := 0-1962.0724
1470: , p5_a8 NUMBER := 0-1962.0724
1471: , p5_a9 NUMBER := 0-1962.0724
1472: , p5_a10 NUMBER := 0-1962.0724
1473: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a12 NUMBER := 0-1962.0724
1475: , p5_a13 NUMBER := 0-1962.0724
1476: , p5_a14 DATE := fnd_api.g_miss_date
1477: , p5_a15 NUMBER := 0-1962.0724
1472: , p5_a10 NUMBER := 0-1962.0724
1473: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a12 NUMBER := 0-1962.0724
1475: , p5_a13 NUMBER := 0-1962.0724
1476: , p5_a14 DATE := fnd_api.g_miss_date
1477: , p5_a15 NUMBER := 0-1962.0724
1478: , p5_a16 NUMBER := 0-1962.0724
1479: , p5_a17 NUMBER := 0-1962.0724
1480: , p5_a18 NUMBER := 0-1962.0724
1478: , p5_a16 NUMBER := 0-1962.0724
1479: , p5_a17 NUMBER := 0-1962.0724
1480: , p5_a18 NUMBER := 0-1962.0724
1481: , p5_a19 NUMBER := 0-1962.0724
1482: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a17 NUMBER := 0-1962.0724
1480: , p5_a18 NUMBER := 0-1962.0724
1481: , p5_a19 NUMBER := 0-1962.0724
1482: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a18 NUMBER := 0-1962.0724
1481: , p5_a19 NUMBER := 0-1962.0724
1482: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1488: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a19 NUMBER := 0-1962.0724
1482: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1488: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1489: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1482: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1488: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1489: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1490: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1488: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1489: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1490: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1491: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1488: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1489: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1490: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1491: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1488: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1489: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1490: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1491: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1493: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1488: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1489: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1490: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1491: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1493: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1494: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1488: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1489: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1490: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1491: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1493: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1494: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1495: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1488: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1489: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1490: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1491: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1493: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1494: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1495: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1496: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1489: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1490: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1491: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1493: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1494: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1495: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1496: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1497: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1490: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1491: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1493: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1494: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1495: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1496: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1497: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1498: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1491: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1493: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1494: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1495: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1496: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1497: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1498: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1499: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1493: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1494: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1495: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1496: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1497: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1498: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1499: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1500: , p5_a38 NUMBER := 0-1962.0724
1493: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1494: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1495: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1496: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1497: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1498: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1499: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1500: , p5_a38 NUMBER := 0-1962.0724
1501: , p5_a39 NUMBER := 0-1962.0724
1494: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1495: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1496: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1497: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1498: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1499: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1500: , p5_a38 NUMBER := 0-1962.0724
1501: , p5_a39 NUMBER := 0-1962.0724
1502: , p5_a40 NUMBER := 0-1962.0724
1495: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1496: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1497: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1498: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1499: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1500: , p5_a38 NUMBER := 0-1962.0724
1501: , p5_a39 NUMBER := 0-1962.0724
1502: , p5_a40 NUMBER := 0-1962.0724
1503: , p5_a41 DATE := fnd_api.g_miss_date
1499: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1500: , p5_a38 NUMBER := 0-1962.0724
1501: , p5_a39 NUMBER := 0-1962.0724
1502: , p5_a40 NUMBER := 0-1962.0724
1503: , p5_a41 DATE := fnd_api.g_miss_date
1504: , p5_a42 NUMBER := 0-1962.0724
1505: , p5_a43 NUMBER := 0-1962.0724
1506: , p5_a44 DATE := fnd_api.g_miss_date
1507: , p5_a45 NUMBER := 0-1962.0724
1502: , p5_a40 NUMBER := 0-1962.0724
1503: , p5_a41 DATE := fnd_api.g_miss_date
1504: , p5_a42 NUMBER := 0-1962.0724
1505: , p5_a43 NUMBER := 0-1962.0724
1506: , p5_a44 DATE := fnd_api.g_miss_date
1507: , p5_a45 NUMBER := 0-1962.0724
1508: , p5_a46 DATE := fnd_api.g_miss_date
1509: , p5_a47 NUMBER := 0-1962.0724
1510: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1504: , p5_a42 NUMBER := 0-1962.0724
1505: , p5_a43 NUMBER := 0-1962.0724
1506: , p5_a44 DATE := fnd_api.g_miss_date
1507: , p5_a45 NUMBER := 0-1962.0724
1508: , p5_a46 DATE := fnd_api.g_miss_date
1509: , p5_a47 NUMBER := 0-1962.0724
1510: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1511: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1512: , p5_a50 NUMBER := 0-1962.0724
1506: , p5_a44 DATE := fnd_api.g_miss_date
1507: , p5_a45 NUMBER := 0-1962.0724
1508: , p5_a46 DATE := fnd_api.g_miss_date
1509: , p5_a47 NUMBER := 0-1962.0724
1510: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1511: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1512: , p5_a50 NUMBER := 0-1962.0724
1513: , p5_a51 NUMBER := 0-1962.0724
1514: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1507: , p5_a45 NUMBER := 0-1962.0724
1508: , p5_a46 DATE := fnd_api.g_miss_date
1509: , p5_a47 NUMBER := 0-1962.0724
1510: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1511: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1512: , p5_a50 NUMBER := 0-1962.0724
1513: , p5_a51 NUMBER := 0-1962.0724
1514: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1515: , p5_a53 NUMBER := 0-1962.0724
1510: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1511: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1512: , p5_a50 NUMBER := 0-1962.0724
1513: , p5_a51 NUMBER := 0-1962.0724
1514: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1515: , p5_a53 NUMBER := 0-1962.0724
1516: )
1517:
1518: as
1801: , p6_a52 out nocopy VARCHAR2
1802: , p6_a53 out nocopy NUMBER
1803: , p5_a0 NUMBER := 0-1962.0724
1804: , p5_a1 NUMBER := 0-1962.0724
1805: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a3 NUMBER := 0-1962.0724
1807: , p5_a4 NUMBER := 0-1962.0724
1808: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a6 NUMBER := 0-1962.0724
1804: , p5_a1 NUMBER := 0-1962.0724
1805: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a3 NUMBER := 0-1962.0724
1807: , p5_a4 NUMBER := 0-1962.0724
1808: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a6 NUMBER := 0-1962.0724
1810: , p5_a7 NUMBER := 0-1962.0724
1811: , p5_a8 NUMBER := 0-1962.0724
1812: , p5_a9 NUMBER := 0-1962.0724
1810: , p5_a7 NUMBER := 0-1962.0724
1811: , p5_a8 NUMBER := 0-1962.0724
1812: , p5_a9 NUMBER := 0-1962.0724
1813: , p5_a10 NUMBER := 0-1962.0724
1814: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a12 NUMBER := 0-1962.0724
1816: , p5_a13 NUMBER := 0-1962.0724
1817: , p5_a14 DATE := fnd_api.g_miss_date
1818: , p5_a15 NUMBER := 0-1962.0724
1813: , p5_a10 NUMBER := 0-1962.0724
1814: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a12 NUMBER := 0-1962.0724
1816: , p5_a13 NUMBER := 0-1962.0724
1817: , p5_a14 DATE := fnd_api.g_miss_date
1818: , p5_a15 NUMBER := 0-1962.0724
1819: , p5_a16 NUMBER := 0-1962.0724
1820: , p5_a17 NUMBER := 0-1962.0724
1821: , p5_a18 NUMBER := 0-1962.0724
1819: , p5_a16 NUMBER := 0-1962.0724
1820: , p5_a17 NUMBER := 0-1962.0724
1821: , p5_a18 NUMBER := 0-1962.0724
1822: , p5_a19 NUMBER := 0-1962.0724
1823: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1820: , p5_a17 NUMBER := 0-1962.0724
1821: , p5_a18 NUMBER := 0-1962.0724
1822: , p5_a19 NUMBER := 0-1962.0724
1823: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1821: , p5_a18 NUMBER := 0-1962.0724
1822: , p5_a19 NUMBER := 0-1962.0724
1823: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1822: , p5_a19 NUMBER := 0-1962.0724
1823: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1823: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1825: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1826: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1828: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1836: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1829: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1836: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1837: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1830: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1836: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1837: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1838: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1831: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1836: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1837: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1838: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1839: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1832: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1836: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1837: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1838: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1839: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1840: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1833: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1834: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1836: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1837: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1838: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1839: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1840: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1841: , p5_a38 NUMBER := 0-1962.0724
1834: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1835: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1836: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1837: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1838: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1839: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1840: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1841: , p5_a38 NUMBER := 0-1962.0724
1842: , p5_a39 NUMBER := 0-1962.0724
1835: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1836: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1837: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1838: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1839: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1840: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1841: , p5_a38 NUMBER := 0-1962.0724
1842: , p5_a39 NUMBER := 0-1962.0724
1843: , p5_a40 NUMBER := 0-1962.0724
1836: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1837: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1838: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1839: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1840: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1841: , p5_a38 NUMBER := 0-1962.0724
1842: , p5_a39 NUMBER := 0-1962.0724
1843: , p5_a40 NUMBER := 0-1962.0724
1844: , p5_a41 DATE := fnd_api.g_miss_date
1840: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1841: , p5_a38 NUMBER := 0-1962.0724
1842: , p5_a39 NUMBER := 0-1962.0724
1843: , p5_a40 NUMBER := 0-1962.0724
1844: , p5_a41 DATE := fnd_api.g_miss_date
1845: , p5_a42 NUMBER := 0-1962.0724
1846: , p5_a43 NUMBER := 0-1962.0724
1847: , p5_a44 DATE := fnd_api.g_miss_date
1848: , p5_a45 NUMBER := 0-1962.0724
1843: , p5_a40 NUMBER := 0-1962.0724
1844: , p5_a41 DATE := fnd_api.g_miss_date
1845: , p5_a42 NUMBER := 0-1962.0724
1846: , p5_a43 NUMBER := 0-1962.0724
1847: , p5_a44 DATE := fnd_api.g_miss_date
1848: , p5_a45 NUMBER := 0-1962.0724
1849: , p5_a46 DATE := fnd_api.g_miss_date
1850: , p5_a47 NUMBER := 0-1962.0724
1851: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1845: , p5_a42 NUMBER := 0-1962.0724
1846: , p5_a43 NUMBER := 0-1962.0724
1847: , p5_a44 DATE := fnd_api.g_miss_date
1848: , p5_a45 NUMBER := 0-1962.0724
1849: , p5_a46 DATE := fnd_api.g_miss_date
1850: , p5_a47 NUMBER := 0-1962.0724
1851: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1852: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1853: , p5_a50 NUMBER := 0-1962.0724
1847: , p5_a44 DATE := fnd_api.g_miss_date
1848: , p5_a45 NUMBER := 0-1962.0724
1849: , p5_a46 DATE := fnd_api.g_miss_date
1850: , p5_a47 NUMBER := 0-1962.0724
1851: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1852: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1853: , p5_a50 NUMBER := 0-1962.0724
1854: , p5_a51 NUMBER := 0-1962.0724
1855: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1848: , p5_a45 NUMBER := 0-1962.0724
1849: , p5_a46 DATE := fnd_api.g_miss_date
1850: , p5_a47 NUMBER := 0-1962.0724
1851: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1852: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1853: , p5_a50 NUMBER := 0-1962.0724
1854: , p5_a51 NUMBER := 0-1962.0724
1855: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1856: , p5_a53 NUMBER := 0-1962.0724
1851: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1852: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1853: , p5_a50 NUMBER := 0-1962.0724
1854: , p5_a51 NUMBER := 0-1962.0724
1855: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1856: , p5_a53 NUMBER := 0-1962.0724
1857: )
1858:
1859: as
2259: , x_msg_count out nocopy NUMBER
2260: , x_msg_data out nocopy VARCHAR2
2261: , p5_a0 NUMBER := 0-1962.0724
2262: , p5_a1 NUMBER := 0-1962.0724
2263: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2264: , p5_a3 NUMBER := 0-1962.0724
2265: , p5_a4 NUMBER := 0-1962.0724
2266: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2267: , p5_a6 NUMBER := 0-1962.0724
2262: , p5_a1 NUMBER := 0-1962.0724
2263: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2264: , p5_a3 NUMBER := 0-1962.0724
2265: , p5_a4 NUMBER := 0-1962.0724
2266: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2267: , p5_a6 NUMBER := 0-1962.0724
2268: , p5_a7 NUMBER := 0-1962.0724
2269: , p5_a8 NUMBER := 0-1962.0724
2270: , p5_a9 NUMBER := 0-1962.0724
2268: , p5_a7 NUMBER := 0-1962.0724
2269: , p5_a8 NUMBER := 0-1962.0724
2270: , p5_a9 NUMBER := 0-1962.0724
2271: , p5_a10 NUMBER := 0-1962.0724
2272: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2273: , p5_a12 NUMBER := 0-1962.0724
2274: , p5_a13 NUMBER := 0-1962.0724
2275: , p5_a14 DATE := fnd_api.g_miss_date
2276: , p5_a15 NUMBER := 0-1962.0724
2271: , p5_a10 NUMBER := 0-1962.0724
2272: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2273: , p5_a12 NUMBER := 0-1962.0724
2274: , p5_a13 NUMBER := 0-1962.0724
2275: , p5_a14 DATE := fnd_api.g_miss_date
2276: , p5_a15 NUMBER := 0-1962.0724
2277: , p5_a16 NUMBER := 0-1962.0724
2278: , p5_a17 NUMBER := 0-1962.0724
2279: , p5_a18 NUMBER := 0-1962.0724
2277: , p5_a16 NUMBER := 0-1962.0724
2278: , p5_a17 NUMBER := 0-1962.0724
2279: , p5_a18 NUMBER := 0-1962.0724
2280: , p5_a19 NUMBER := 0-1962.0724
2281: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2282: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2283: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2284: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2285: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2278: , p5_a17 NUMBER := 0-1962.0724
2279: , p5_a18 NUMBER := 0-1962.0724
2280: , p5_a19 NUMBER := 0-1962.0724
2281: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2282: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2283: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2284: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2285: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2286: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2279: , p5_a18 NUMBER := 0-1962.0724
2280: , p5_a19 NUMBER := 0-1962.0724
2281: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2282: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2283: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2284: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2285: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2286: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2287: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2280: , p5_a19 NUMBER := 0-1962.0724
2281: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2282: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2283: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2284: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2285: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2286: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2287: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2288: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2281: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2282: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2283: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2284: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2285: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2286: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2287: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2288: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2289: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2282: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2283: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2284: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2285: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2286: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2287: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2288: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2289: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2290: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2283: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2284: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2285: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2286: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2287: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2288: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2289: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2290: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2291: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2284: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2285: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2286: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2287: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2288: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2289: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2290: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2291: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2292: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2285: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2286: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2287: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2288: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2289: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2290: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2291: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2292: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2286: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2287: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2288: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2289: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2290: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2291: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2292: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2287: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2288: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2289: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2290: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2291: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2292: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2288: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2289: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2290: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2291: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2292: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2289: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2290: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2291: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2292: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2290: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2291: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2292: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2291: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2292: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a38 NUMBER := 0-1962.0724
2292: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2293: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a38 NUMBER := 0-1962.0724
2300: , p5_a39 NUMBER := 0-1962.0724
2293: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2294: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a38 NUMBER := 0-1962.0724
2300: , p5_a39 NUMBER := 0-1962.0724
2301: , p5_a40 NUMBER := 0-1962.0724
2294: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2295: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2296: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2297: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2298: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a38 NUMBER := 0-1962.0724
2300: , p5_a39 NUMBER := 0-1962.0724
2301: , p5_a40 NUMBER := 0-1962.0724
2302: , p5_a41 DATE := fnd_api.g_miss_date
2298: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2299: , p5_a38 NUMBER := 0-1962.0724
2300: , p5_a39 NUMBER := 0-1962.0724
2301: , p5_a40 NUMBER := 0-1962.0724
2302: , p5_a41 DATE := fnd_api.g_miss_date
2303: , p5_a42 NUMBER := 0-1962.0724
2304: , p5_a43 NUMBER := 0-1962.0724
2305: , p5_a44 DATE := fnd_api.g_miss_date
2306: , p5_a45 NUMBER := 0-1962.0724
2301: , p5_a40 NUMBER := 0-1962.0724
2302: , p5_a41 DATE := fnd_api.g_miss_date
2303: , p5_a42 NUMBER := 0-1962.0724
2304: , p5_a43 NUMBER := 0-1962.0724
2305: , p5_a44 DATE := fnd_api.g_miss_date
2306: , p5_a45 NUMBER := 0-1962.0724
2307: , p5_a46 DATE := fnd_api.g_miss_date
2308: , p5_a47 NUMBER := 0-1962.0724
2309: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2303: , p5_a42 NUMBER := 0-1962.0724
2304: , p5_a43 NUMBER := 0-1962.0724
2305: , p5_a44 DATE := fnd_api.g_miss_date
2306: , p5_a45 NUMBER := 0-1962.0724
2307: , p5_a46 DATE := fnd_api.g_miss_date
2308: , p5_a47 NUMBER := 0-1962.0724
2309: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2310: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2311: , p5_a50 NUMBER := 0-1962.0724
2305: , p5_a44 DATE := fnd_api.g_miss_date
2306: , p5_a45 NUMBER := 0-1962.0724
2307: , p5_a46 DATE := fnd_api.g_miss_date
2308: , p5_a47 NUMBER := 0-1962.0724
2309: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2310: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2311: , p5_a50 NUMBER := 0-1962.0724
2312: , p5_a51 NUMBER := 0-1962.0724
2313: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2306: , p5_a45 NUMBER := 0-1962.0724
2307: , p5_a46 DATE := fnd_api.g_miss_date
2308: , p5_a47 NUMBER := 0-1962.0724
2309: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2310: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2311: , p5_a50 NUMBER := 0-1962.0724
2312: , p5_a51 NUMBER := 0-1962.0724
2313: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2314: , p5_a53 NUMBER := 0-1962.0724
2309: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2310: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2311: , p5_a50 NUMBER := 0-1962.0724
2312: , p5_a51 NUMBER := 0-1962.0724
2313: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2314: , p5_a53 NUMBER := 0-1962.0724
2315: )
2316:
2317: as
2546: , x_msg_count out nocopy NUMBER
2547: , x_msg_data out nocopy VARCHAR2
2548: , p5_a0 NUMBER := 0-1962.0724
2549: , p5_a1 NUMBER := 0-1962.0724
2550: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2551: , p5_a3 NUMBER := 0-1962.0724
2552: , p5_a4 NUMBER := 0-1962.0724
2553: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2554: , p5_a6 NUMBER := 0-1962.0724
2549: , p5_a1 NUMBER := 0-1962.0724
2550: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2551: , p5_a3 NUMBER := 0-1962.0724
2552: , p5_a4 NUMBER := 0-1962.0724
2553: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2554: , p5_a6 NUMBER := 0-1962.0724
2555: , p5_a7 NUMBER := 0-1962.0724
2556: , p5_a8 NUMBER := 0-1962.0724
2557: , p5_a9 NUMBER := 0-1962.0724
2555: , p5_a7 NUMBER := 0-1962.0724
2556: , p5_a8 NUMBER := 0-1962.0724
2557: , p5_a9 NUMBER := 0-1962.0724
2558: , p5_a10 NUMBER := 0-1962.0724
2559: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2560: , p5_a12 NUMBER := 0-1962.0724
2561: , p5_a13 NUMBER := 0-1962.0724
2562: , p5_a14 DATE := fnd_api.g_miss_date
2563: , p5_a15 NUMBER := 0-1962.0724
2558: , p5_a10 NUMBER := 0-1962.0724
2559: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2560: , p5_a12 NUMBER := 0-1962.0724
2561: , p5_a13 NUMBER := 0-1962.0724
2562: , p5_a14 DATE := fnd_api.g_miss_date
2563: , p5_a15 NUMBER := 0-1962.0724
2564: , p5_a16 NUMBER := 0-1962.0724
2565: , p5_a17 NUMBER := 0-1962.0724
2566: , p5_a18 NUMBER := 0-1962.0724
2564: , p5_a16 NUMBER := 0-1962.0724
2565: , p5_a17 NUMBER := 0-1962.0724
2566: , p5_a18 NUMBER := 0-1962.0724
2567: , p5_a19 NUMBER := 0-1962.0724
2568: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2569: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2570: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2571: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2572: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2565: , p5_a17 NUMBER := 0-1962.0724
2566: , p5_a18 NUMBER := 0-1962.0724
2567: , p5_a19 NUMBER := 0-1962.0724
2568: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2569: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2570: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2571: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2572: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2573: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2566: , p5_a18 NUMBER := 0-1962.0724
2567: , p5_a19 NUMBER := 0-1962.0724
2568: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2569: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2570: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2571: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2572: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2573: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2574: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2567: , p5_a19 NUMBER := 0-1962.0724
2568: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2569: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2570: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2571: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2572: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2573: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2574: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2575: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2568: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2569: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2570: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2571: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2572: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2573: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2574: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2575: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2576: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2569: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2570: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2571: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2572: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2573: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2574: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2575: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2576: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2577: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2570: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2571: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2572: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2573: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2574: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2575: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2576: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2577: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2571: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2572: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2573: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2574: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2575: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2576: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2577: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2579: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2572: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2573: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2574: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2575: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2576: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2577: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2579: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2573: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2574: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2575: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2576: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2577: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2579: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2581: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2574: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2575: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2576: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2577: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2579: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2581: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2582: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2575: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2576: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2577: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2579: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2581: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2582: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2583: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2576: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2577: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2579: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2581: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2582: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2583: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2584: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2577: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2579: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2581: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2582: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2583: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2584: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2585: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2578: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2579: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2581: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2582: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2583: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2584: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2585: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2586: , p5_a38 NUMBER := 0-1962.0724
2579: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2581: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2582: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2583: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2584: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2585: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2586: , p5_a38 NUMBER := 0-1962.0724
2587: , p5_a39 NUMBER := 0-1962.0724
2580: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2581: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2582: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2583: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2584: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2585: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2586: , p5_a38 NUMBER := 0-1962.0724
2587: , p5_a39 NUMBER := 0-1962.0724
2588: , p5_a40 NUMBER := 0-1962.0724
2581: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2582: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2583: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2584: , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2585: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2586: , p5_a38 NUMBER := 0-1962.0724
2587: , p5_a39 NUMBER := 0-1962.0724
2588: , p5_a40 NUMBER := 0-1962.0724
2589: , p5_a41 DATE := fnd_api.g_miss_date
2585: , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2586: , p5_a38 NUMBER := 0-1962.0724
2587: , p5_a39 NUMBER := 0-1962.0724
2588: , p5_a40 NUMBER := 0-1962.0724
2589: , p5_a41 DATE := fnd_api.g_miss_date
2590: , p5_a42 NUMBER := 0-1962.0724
2591: , p5_a43 NUMBER := 0-1962.0724
2592: , p5_a44 DATE := fnd_api.g_miss_date
2593: , p5_a45 NUMBER := 0-1962.0724
2588: , p5_a40 NUMBER := 0-1962.0724
2589: , p5_a41 DATE := fnd_api.g_miss_date
2590: , p5_a42 NUMBER := 0-1962.0724
2591: , p5_a43 NUMBER := 0-1962.0724
2592: , p5_a44 DATE := fnd_api.g_miss_date
2593: , p5_a45 NUMBER := 0-1962.0724
2594: , p5_a46 DATE := fnd_api.g_miss_date
2595: , p5_a47 NUMBER := 0-1962.0724
2596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2590: , p5_a42 NUMBER := 0-1962.0724
2591: , p5_a43 NUMBER := 0-1962.0724
2592: , p5_a44 DATE := fnd_api.g_miss_date
2593: , p5_a45 NUMBER := 0-1962.0724
2594: , p5_a46 DATE := fnd_api.g_miss_date
2595: , p5_a47 NUMBER := 0-1962.0724
2596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2598: , p5_a50 NUMBER := 0-1962.0724
2592: , p5_a44 DATE := fnd_api.g_miss_date
2593: , p5_a45 NUMBER := 0-1962.0724
2594: , p5_a46 DATE := fnd_api.g_miss_date
2595: , p5_a47 NUMBER := 0-1962.0724
2596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2598: , p5_a50 NUMBER := 0-1962.0724
2599: , p5_a51 NUMBER := 0-1962.0724
2600: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2593: , p5_a45 NUMBER := 0-1962.0724
2594: , p5_a46 DATE := fnd_api.g_miss_date
2595: , p5_a47 NUMBER := 0-1962.0724
2596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2598: , p5_a50 NUMBER := 0-1962.0724
2599: , p5_a51 NUMBER := 0-1962.0724
2600: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2601: , p5_a53 NUMBER := 0-1962.0724
2596: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2597: , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2598: , p5_a50 NUMBER := 0-1962.0724
2599: , p5_a51 NUMBER := 0-1962.0724
2600: , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2601: , p5_a53 NUMBER := 0-1962.0724
2602: )
2603:
2604: as