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;
1739: , p5_a41 JTF_DATE_TABLE
1740: , p7_a0 out nocopy JTF_NUMBER_TABLE
1741: , p6_a0 NUMBER := 0-1962.0724
1742: , p6_a1 NUMBER := 0-1962.0724
1743: , p6_a2 VARCHAR2 := fnd_api.g_miss_char
1744: , p6_a3 NUMBER := 0-1962.0724
1745: , p6_a4 NUMBER := 0-1962.0724
1746: , p6_a5 NUMBER := 0-1962.0724
1747: , p6_a6 NUMBER := 0-1962.0724
1749: , p6_a8 NUMBER := 0-1962.0724
1750: , p6_a9 NUMBER := 0-1962.0724
1751: , p6_a10 NUMBER := 0-1962.0724
1752: , p6_a11 NUMBER := 0-1962.0724
1753: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1754: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1755: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1756: , p6_a15 NUMBER := 0-1962.0724
1757: , p6_a16 NUMBER := 0-1962.0724
1750: , p6_a9 NUMBER := 0-1962.0724
1751: , p6_a10 NUMBER := 0-1962.0724
1752: , p6_a11 NUMBER := 0-1962.0724
1753: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1754: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1755: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1756: , p6_a15 NUMBER := 0-1962.0724
1757: , p6_a16 NUMBER := 0-1962.0724
1758: , p6_a17 NUMBER := 0-1962.0724
1751: , p6_a10 NUMBER := 0-1962.0724
1752: , p6_a11 NUMBER := 0-1962.0724
1753: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1754: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1755: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1756: , p6_a15 NUMBER := 0-1962.0724
1757: , p6_a16 NUMBER := 0-1962.0724
1758: , p6_a17 NUMBER := 0-1962.0724
1759: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1755: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1756: , p6_a15 NUMBER := 0-1962.0724
1757: , p6_a16 NUMBER := 0-1962.0724
1758: , p6_a17 NUMBER := 0-1962.0724
1759: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1760: , p6_a19 NUMBER := 0-1962.0724
1761: , p6_a20 NUMBER := 0-1962.0724
1762: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1763: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1758: , p6_a17 NUMBER := 0-1962.0724
1759: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1760: , p6_a19 NUMBER := 0-1962.0724
1761: , p6_a20 NUMBER := 0-1962.0724
1762: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1763: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1764: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
1765: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
1766: , p6_a25 DATE := fnd_api.g_miss_date
1759: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1760: , p6_a19 NUMBER := 0-1962.0724
1761: , p6_a20 NUMBER := 0-1962.0724
1762: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1763: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1764: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
1765: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
1766: , p6_a25 DATE := fnd_api.g_miss_date
1767: , p6_a26 DATE := fnd_api.g_miss_date
1760: , p6_a19 NUMBER := 0-1962.0724
1761: , p6_a20 NUMBER := 0-1962.0724
1762: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1763: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1764: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
1765: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
1766: , p6_a25 DATE := fnd_api.g_miss_date
1767: , p6_a26 DATE := fnd_api.g_miss_date
1768: , p6_a27 DATE := fnd_api.g_miss_date
1761: , p6_a20 NUMBER := 0-1962.0724
1762: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1763: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1764: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
1765: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
1766: , p6_a25 DATE := fnd_api.g_miss_date
1767: , p6_a26 DATE := fnd_api.g_miss_date
1768: , p6_a27 DATE := fnd_api.g_miss_date
1769: , p6_a28 NUMBER := 0-1962.0724
1762: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1763: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1764: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
1765: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
1766: , p6_a25 DATE := fnd_api.g_miss_date
1767: , p6_a26 DATE := fnd_api.g_miss_date
1768: , p6_a27 DATE := fnd_api.g_miss_date
1769: , p6_a28 NUMBER := 0-1962.0724
1770: , p6_a29 NUMBER := 0-1962.0724
1763: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1764: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
1765: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
1766: , p6_a25 DATE := fnd_api.g_miss_date
1767: , p6_a26 DATE := fnd_api.g_miss_date
1768: , p6_a27 DATE := fnd_api.g_miss_date
1769: , p6_a28 NUMBER := 0-1962.0724
1770: , p6_a29 NUMBER := 0-1962.0724
1771: , p6_a30 NUMBER := 0-1962.0724
1764: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
1765: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
1766: , p6_a25 DATE := fnd_api.g_miss_date
1767: , p6_a26 DATE := fnd_api.g_miss_date
1768: , p6_a27 DATE := fnd_api.g_miss_date
1769: , p6_a28 NUMBER := 0-1962.0724
1770: , p6_a29 NUMBER := 0-1962.0724
1771: , p6_a30 NUMBER := 0-1962.0724
1772: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
1768: , p6_a27 DATE := fnd_api.g_miss_date
1769: , p6_a28 NUMBER := 0-1962.0724
1770: , p6_a29 NUMBER := 0-1962.0724
1771: , p6_a30 NUMBER := 0-1962.0724
1772: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
1773: , p6_a32 NUMBER := 0-1962.0724
1774: , p6_a33 NUMBER := 0-1962.0724
1775: , p6_a34 NUMBER := 0-1962.0724
1776: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
1772: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
1773: , p6_a32 NUMBER := 0-1962.0724
1774: , p6_a33 NUMBER := 0-1962.0724
1775: , p6_a34 NUMBER := 0-1962.0724
1776: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
1777: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
1778: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
1779: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
1780: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
1773: , p6_a32 NUMBER := 0-1962.0724
1774: , p6_a33 NUMBER := 0-1962.0724
1775: , p6_a34 NUMBER := 0-1962.0724
1776: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
1777: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
1778: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
1779: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
1780: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
1781: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
1774: , p6_a33 NUMBER := 0-1962.0724
1775: , p6_a34 NUMBER := 0-1962.0724
1776: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
1777: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
1778: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
1779: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
1780: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
1781: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
1782: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
1775: , p6_a34 NUMBER := 0-1962.0724
1776: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
1777: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
1778: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
1779: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
1780: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
1781: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
1782: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
1783: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
1776: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
1777: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
1778: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
1779: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
1780: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
1781: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
1782: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
1783: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
1784: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
1777: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
1778: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
1779: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
1780: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
1781: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
1782: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
1783: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
1784: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
1785: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
1778: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
1779: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
1780: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
1781: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
1782: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
1783: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
1784: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
1785: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
1786: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
1779: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
1780: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
1781: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
1782: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
1783: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
1784: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
1785: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
1786: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
1787: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
1780: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
1781: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
1782: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
1783: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
1784: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
1785: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
1786: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
1787: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
1788: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
1781: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
1782: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
1783: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
1784: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
1785: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
1786: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
1787: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
1788: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
1789: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
1782: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
1783: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
1784: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
1785: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
1786: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
1787: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
1788: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
1789: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
1790: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
1783: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
1784: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
1785: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
1786: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
1787: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
1788: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
1789: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
1790: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
1791: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
1784: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
1785: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
1786: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
1787: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
1788: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
1789: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
1790: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
1791: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
1792: , p6_a51 NUMBER := 0-1962.0724
1785: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
1786: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
1787: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
1788: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
1789: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
1790: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
1791: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
1792: , p6_a51 NUMBER := 0-1962.0724
1793: , p6_a52 DATE := fnd_api.g_miss_date
1786: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
1787: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
1788: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
1789: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
1790: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
1791: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
1792: , p6_a51 NUMBER := 0-1962.0724
1793: , p6_a52 DATE := fnd_api.g_miss_date
1794: , p6_a53 NUMBER := 0-1962.0724
1787: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
1788: , p6_a47 VARCHAR2 := fnd_api.g_miss_char
1789: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
1790: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
1791: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
1792: , p6_a51 NUMBER := 0-1962.0724
1793: , p6_a52 DATE := fnd_api.g_miss_date
1794: , p6_a53 NUMBER := 0-1962.0724
1795: , p6_a54 DATE := fnd_api.g_miss_date
1789: , p6_a48 VARCHAR2 := fnd_api.g_miss_char
1790: , p6_a49 VARCHAR2 := fnd_api.g_miss_char
1791: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
1792: , p6_a51 NUMBER := 0-1962.0724
1793: , p6_a52 DATE := fnd_api.g_miss_date
1794: , p6_a53 NUMBER := 0-1962.0724
1795: , p6_a54 DATE := fnd_api.g_miss_date
1796: , p6_a55 NUMBER := 0-1962.0724
1797: , p6_a56 VARCHAR2 := fnd_api.g_miss_char
1791: , p6_a50 VARCHAR2 := fnd_api.g_miss_char
1792: , p6_a51 NUMBER := 0-1962.0724
1793: , p6_a52 DATE := fnd_api.g_miss_date
1794: , p6_a53 NUMBER := 0-1962.0724
1795: , p6_a54 DATE := fnd_api.g_miss_date
1796: , p6_a55 NUMBER := 0-1962.0724
1797: , p6_a56 VARCHAR2 := fnd_api.g_miss_char
1798: , p6_a57 NUMBER := 0-1962.0724
1799: , p6_a58 NUMBER := 0-1962.0724
1793: , p6_a52 DATE := fnd_api.g_miss_date
1794: , p6_a53 NUMBER := 0-1962.0724
1795: , p6_a54 DATE := fnd_api.g_miss_date
1796: , p6_a55 NUMBER := 0-1962.0724
1797: , p6_a56 VARCHAR2 := fnd_api.g_miss_char
1798: , p6_a57 NUMBER := 0-1962.0724
1799: , p6_a58 NUMBER := 0-1962.0724
1800: , p6_a59 NUMBER := 0-1962.0724
1801: , p6_a60 NUMBER := 0-1962.0724
1803: , p6_a62 NUMBER := 0-1962.0724
1804: , p6_a63 NUMBER := 0-1962.0724
1805: , p6_a64 NUMBER := 0-1962.0724
1806: , p6_a65 NUMBER := 0-1962.0724
1807: , p6_a66 DATE := fnd_api.g_miss_date
1808: , p6_a67 NUMBER := 0-1962.0724
1809: , p6_a68 NUMBER := 0-1962.0724
1810: , p6_a69 NUMBER := 0-1962.0724
1811: , p6_a70 VARCHAR2 := fnd_api.g_miss_char
1807: , p6_a66 DATE := fnd_api.g_miss_date
1808: , p6_a67 NUMBER := 0-1962.0724
1809: , p6_a68 NUMBER := 0-1962.0724
1810: , p6_a69 NUMBER := 0-1962.0724
1811: , p6_a70 VARCHAR2 := fnd_api.g_miss_char
1812: , p6_a71 NUMBER := 0-1962.0724
1813: , p6_a72 VARCHAR2 := fnd_api.g_miss_char
1814: , p6_a73 VARCHAR2 := fnd_api.g_miss_char
1815: , p6_a74 NUMBER := 0-1962.0724
1809: , p6_a68 NUMBER := 0-1962.0724
1810: , p6_a69 NUMBER := 0-1962.0724
1811: , p6_a70 VARCHAR2 := fnd_api.g_miss_char
1812: , p6_a71 NUMBER := 0-1962.0724
1813: , p6_a72 VARCHAR2 := fnd_api.g_miss_char
1814: , p6_a73 VARCHAR2 := fnd_api.g_miss_char
1815: , p6_a74 NUMBER := 0-1962.0724
1816: , p6_a75 DATE := fnd_api.g_miss_date
1817: )
1810: , p6_a69 NUMBER := 0-1962.0724
1811: , p6_a70 VARCHAR2 := fnd_api.g_miss_char
1812: , p6_a71 NUMBER := 0-1962.0724
1813: , p6_a72 VARCHAR2 := fnd_api.g_miss_char
1814: , p6_a73 VARCHAR2 := fnd_api.g_miss_char
1815: , p6_a74 NUMBER := 0-1962.0724
1816: , p6_a75 DATE := fnd_api.g_miss_date
1817: )
1818:
1812: , p6_a71 NUMBER := 0-1962.0724
1813: , p6_a72 VARCHAR2 := fnd_api.g_miss_char
1814: , p6_a73 VARCHAR2 := fnd_api.g_miss_char
1815: , p6_a74 NUMBER := 0-1962.0724
1816: , p6_a75 DATE := fnd_api.g_miss_date
1817: )
1818:
1819: as
1820: ddp_txdv_tbl okl_split_asset_pub.txdv_tbl_type;