eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_GET_TX_DATA_PUB_W dependencies on JTF_VARCHAR2_TABLE_400

Line 5: , a2 JTF_VARCHAR2_TABLE_400

1: package body cn_get_tx_data_pub_w as
2: /* $Header: cnwxadjb.pls 120.4.12000000.2 2007/08/08 05:59:58 apink ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_tx_data_pub.adj_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE

Line 404: , a2 out nocopy JTF_VARCHAR2_TABLE_400

400: end if;
401: end rosetta_table_copy_in_p1;
402: procedure rosetta_table_copy_out_p1(t cn_get_tx_data_pub.adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
403: , a1 out nocopy JTF_VARCHAR2_TABLE_100
404: , a2 out nocopy JTF_VARCHAR2_TABLE_400
405: , a3 out nocopy JTF_NUMBER_TABLE
406: , a4 out nocopy JTF_NUMBER_TABLE
407: , a5 out nocopy JTF_VARCHAR2_TABLE_100
408: , a6 out nocopy JTF_DATE_TABLE

Line 599: a2 := JTF_VARCHAR2_TABLE_400();

595: begin
596: if t is null or t.count = 0 then
597: a0 := JTF_NUMBER_TABLE();
598: a1 := JTF_VARCHAR2_TABLE_100();
599: a2 := JTF_VARCHAR2_TABLE_400();
600: a3 := JTF_NUMBER_TABLE();
601: a4 := JTF_NUMBER_TABLE();
602: a5 := JTF_VARCHAR2_TABLE_100();
603: a6 := JTF_DATE_TABLE();

Line 791: a2 := JTF_VARCHAR2_TABLE_400();

787: a190 := JTF_VARCHAR2_TABLE_2000();
788: else
789: a0 := JTF_NUMBER_TABLE();
790: a1 := JTF_VARCHAR2_TABLE_100();
791: a2 := JTF_VARCHAR2_TABLE_400();
792: a3 := JTF_NUMBER_TABLE();
793: a4 := JTF_NUMBER_TABLE();
794: a5 := JTF_VARCHAR2_TABLE_100();
795: a6 := JTF_DATE_TABLE();

Line 1378: , a2 JTF_VARCHAR2_TABLE_400

1374: end rosetta_table_copy_out_p1;
1375:
1376: procedure rosetta_table_copy_in_p3(t out nocopy cn_get_tx_data_pub.tx_adj_data_tbl, a0 JTF_NUMBER_TABLE
1377: , a1 JTF_VARCHAR2_TABLE_100
1378: , a2 JTF_VARCHAR2_TABLE_400
1379: , a3 JTF_DATE_TABLE
1380: , a4 JTF_NUMBER_TABLE
1381: , a5 JTF_NUMBER_TABLE
1382: , a6 JTF_NUMBER_TABLE

Line 1425: , a2 out nocopy JTF_VARCHAR2_TABLE_400

1421: end if;
1422: end rosetta_table_copy_in_p3;
1423: procedure rosetta_table_copy_out_p3(t cn_get_tx_data_pub.tx_adj_data_tbl, a0 out nocopy JTF_NUMBER_TABLE
1424: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1425: , a2 out nocopy JTF_VARCHAR2_TABLE_400
1426: , a3 out nocopy JTF_DATE_TABLE
1427: , a4 out nocopy JTF_NUMBER_TABLE
1428: , a5 out nocopy JTF_NUMBER_TABLE
1429: , a6 out nocopy JTF_NUMBER_TABLE

Line 1444: a2 := JTF_VARCHAR2_TABLE_400();

1440: begin
1441: if t is null or t.count = 0 then
1442: a0 := JTF_NUMBER_TABLE();
1443: a1 := JTF_VARCHAR2_TABLE_100();
1444: a2 := JTF_VARCHAR2_TABLE_400();
1445: a3 := JTF_DATE_TABLE();
1446: a4 := JTF_NUMBER_TABLE();
1447: a5 := JTF_NUMBER_TABLE();
1448: a6 := JTF_NUMBER_TABLE();

Line 1460: a2 := JTF_VARCHAR2_TABLE_400();

1456: a14 := JTF_NUMBER_TABLE();
1457: else
1458: a0 := JTF_NUMBER_TABLE();
1459: a1 := JTF_VARCHAR2_TABLE_100();
1460: a2 := JTF_VARCHAR2_TABLE_400();
1461: a3 := JTF_DATE_TABLE();
1462: a4 := JTF_NUMBER_TABLE();
1463: a5 := JTF_NUMBER_TABLE();
1464: a6 := JTF_NUMBER_TABLE();

Line 1591: , a3 JTF_VARCHAR2_TABLE_400

1587:
1588: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_tx_data_pub.trx_line_tbl, a0 JTF_NUMBER_TABLE
1589: , a1 JTF_NUMBER_TABLE
1590: , a2 JTF_NUMBER_TABLE
1591: , a3 JTF_VARCHAR2_TABLE_400
1592: , a4 JTF_VARCHAR2_TABLE_100
1593: , a5 JTF_NUMBER_TABLE
1594: , a6 JTF_DATE_TABLE
1595: , a7 JTF_VARCHAR2_TABLE_100

Line 1607: , a19 JTF_VARCHAR2_TABLE_400

1603: , a15 JTF_NUMBER_TABLE
1604: , a16 JTF_VARCHAR2_TABLE_100
1605: , a17 JTF_VARCHAR2_TABLE_100
1606: , a18 JTF_VARCHAR2_TABLE_100
1607: , a19 JTF_VARCHAR2_TABLE_400
1608: ) as
1609: ddindx binary_integer; indx binary_integer;
1610: begin
1611: if a0 is not null and a0.count > 0 then

Line 1648: , a3 out nocopy JTF_VARCHAR2_TABLE_400

1644: end rosetta_table_copy_in_p7;
1645: procedure rosetta_table_copy_out_p7(t cn_get_tx_data_pub.trx_line_tbl, a0 out nocopy JTF_NUMBER_TABLE
1646: , a1 out nocopy JTF_NUMBER_TABLE
1647: , a2 out nocopy JTF_NUMBER_TABLE
1648: , a3 out nocopy JTF_VARCHAR2_TABLE_400
1649: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1650: , a5 out nocopy JTF_NUMBER_TABLE
1651: , a6 out nocopy JTF_DATE_TABLE
1652: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1664: , a19 out nocopy JTF_VARCHAR2_TABLE_400

1660: , a15 out nocopy JTF_NUMBER_TABLE
1661: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1662: , a17 out nocopy JTF_VARCHAR2_TABLE_100
1663: , a18 out nocopy JTF_VARCHAR2_TABLE_100
1664: , a19 out nocopy JTF_VARCHAR2_TABLE_400
1665: ) as
1666: ddindx binary_integer; indx binary_integer;
1667: begin
1668: if t is null or t.count = 0 then

Line 1672: a3 := JTF_VARCHAR2_TABLE_400();

1668: if t is null or t.count = 0 then
1669: a0 := JTF_NUMBER_TABLE();
1670: a1 := JTF_NUMBER_TABLE();
1671: a2 := JTF_NUMBER_TABLE();
1672: a3 := JTF_VARCHAR2_TABLE_400();
1673: a4 := JTF_VARCHAR2_TABLE_100();
1674: a5 := JTF_NUMBER_TABLE();
1675: a6 := JTF_DATE_TABLE();
1676: a7 := JTF_VARCHAR2_TABLE_100();

Line 1688: a19 := JTF_VARCHAR2_TABLE_400();

1684: a15 := JTF_NUMBER_TABLE();
1685: a16 := JTF_VARCHAR2_TABLE_100();
1686: a17 := JTF_VARCHAR2_TABLE_100();
1687: a18 := JTF_VARCHAR2_TABLE_100();
1688: a19 := JTF_VARCHAR2_TABLE_400();
1689: else
1690: a0 := JTF_NUMBER_TABLE();
1691: a1 := JTF_NUMBER_TABLE();
1692: a2 := JTF_NUMBER_TABLE();

Line 1693: a3 := JTF_VARCHAR2_TABLE_400();

1689: else
1690: a0 := JTF_NUMBER_TABLE();
1691: a1 := JTF_NUMBER_TABLE();
1692: a2 := JTF_NUMBER_TABLE();
1693: a3 := JTF_VARCHAR2_TABLE_400();
1694: a4 := JTF_VARCHAR2_TABLE_100();
1695: a5 := JTF_NUMBER_TABLE();
1696: a6 := JTF_DATE_TABLE();
1697: a7 := JTF_VARCHAR2_TABLE_100();

Line 1709: a19 := JTF_VARCHAR2_TABLE_400();

1705: a15 := JTF_NUMBER_TABLE();
1706: a16 := JTF_VARCHAR2_TABLE_100();
1707: a17 := JTF_VARCHAR2_TABLE_100();
1708: a18 := JTF_VARCHAR2_TABLE_100();
1709: a19 := JTF_VARCHAR2_TABLE_400();
1710: if t.count > 0 then
1711: a0.extend(t.count);
1712: a1.extend(t.count);
1713: a2.extend(t.count);

Line 1784: , a20 JTF_VARCHAR2_TABLE_400

1780: , a16 JTF_VARCHAR2_TABLE_100
1781: , a17 JTF_VARCHAR2_TABLE_100
1782: , a18 JTF_VARCHAR2_TABLE_100
1783: , a19 JTF_NUMBER_TABLE
1784: , a20 JTF_VARCHAR2_TABLE_400
1785: , a21 JTF_NUMBER_TABLE
1786: , a22 JTF_VARCHAR2_TABLE_400
1787: ) as
1788: ddindx binary_integer; indx binary_integer;

Line 1786: , a22 JTF_VARCHAR2_TABLE_400

1782: , a18 JTF_VARCHAR2_TABLE_100
1783: , a19 JTF_NUMBER_TABLE
1784: , a20 JTF_VARCHAR2_TABLE_400
1785: , a21 JTF_NUMBER_TABLE
1786: , a22 JTF_VARCHAR2_TABLE_400
1787: ) as
1788: ddindx binary_integer; indx binary_integer;
1789: begin
1790: if a0 is not null and a0.count > 0 then

Line 1847: , a20 out nocopy JTF_VARCHAR2_TABLE_400

1843: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1844: , a17 out nocopy JTF_VARCHAR2_TABLE_100
1845: , a18 out nocopy JTF_VARCHAR2_TABLE_100
1846: , a19 out nocopy JTF_NUMBER_TABLE
1847: , a20 out nocopy JTF_VARCHAR2_TABLE_400
1848: , a21 out nocopy JTF_NUMBER_TABLE
1849: , a22 out nocopy JTF_VARCHAR2_TABLE_400
1850: ) as
1851: ddindx binary_integer; indx binary_integer;

Line 1849: , a22 out nocopy JTF_VARCHAR2_TABLE_400

1845: , a18 out nocopy JTF_VARCHAR2_TABLE_100
1846: , a19 out nocopy JTF_NUMBER_TABLE
1847: , a20 out nocopy JTF_VARCHAR2_TABLE_400
1848: , a21 out nocopy JTF_NUMBER_TABLE
1849: , a22 out nocopy JTF_VARCHAR2_TABLE_400
1850: ) as
1851: ddindx binary_integer; indx binary_integer;
1852: begin
1853: if t is null or t.count = 0 then

Line 1874: a20 := JTF_VARCHAR2_TABLE_400();

1870: a16 := JTF_VARCHAR2_TABLE_100();
1871: a17 := JTF_VARCHAR2_TABLE_100();
1872: a18 := JTF_VARCHAR2_TABLE_100();
1873: a19 := JTF_NUMBER_TABLE();
1874: a20 := JTF_VARCHAR2_TABLE_400();
1875: a21 := JTF_NUMBER_TABLE();
1876: a22 := JTF_VARCHAR2_TABLE_400();
1877: else
1878: a0 := JTF_NUMBER_TABLE();

Line 1876: a22 := JTF_VARCHAR2_TABLE_400();

1872: a18 := JTF_VARCHAR2_TABLE_100();
1873: a19 := JTF_NUMBER_TABLE();
1874: a20 := JTF_VARCHAR2_TABLE_400();
1875: a21 := JTF_NUMBER_TABLE();
1876: a22 := JTF_VARCHAR2_TABLE_400();
1877: else
1878: a0 := JTF_NUMBER_TABLE();
1879: a1 := JTF_VARCHAR2_TABLE_100();
1880: a2 := JTF_VARCHAR2_TABLE_300();

Line 1898: a20 := JTF_VARCHAR2_TABLE_400();

1894: a16 := JTF_VARCHAR2_TABLE_100();
1895: a17 := JTF_VARCHAR2_TABLE_100();
1896: a18 := JTF_VARCHAR2_TABLE_100();
1897: a19 := JTF_NUMBER_TABLE();
1898: a20 := JTF_VARCHAR2_TABLE_400();
1899: a21 := JTF_NUMBER_TABLE();
1900: a22 := JTF_VARCHAR2_TABLE_400();
1901: if t.count > 0 then
1902: a0.extend(t.count);

Line 1900: a22 := JTF_VARCHAR2_TABLE_400();

1896: a18 := JTF_VARCHAR2_TABLE_100();
1897: a19 := JTF_NUMBER_TABLE();
1898: a20 := JTF_VARCHAR2_TABLE_400();
1899: a21 := JTF_NUMBER_TABLE();
1900: a22 := JTF_VARCHAR2_TABLE_400();
1901: if t.count > 0 then
1902: a0.extend(t.count);
1903: a1.extend(t.count);
1904: a2.extend(t.count);

Line 2014: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_400

2010:
2011: procedure get_api_data(p_comm_lines_api_id NUMBER
2012: , p1_a0 out nocopy JTF_NUMBER_TABLE
2013: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
2014: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_400
2015: , p1_a3 out nocopy JTF_NUMBER_TABLE
2016: , p1_a4 out nocopy JTF_NUMBER_TABLE
2017: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
2018: , p1_a6 out nocopy JTF_DATE_TABLE

Line 2624: , p19_a2 out nocopy JTF_VARCHAR2_TABLE_400

2620: , x_msg_data out nocopy VARCHAR2
2621: , x_loading_status out nocopy VARCHAR2
2622: , p19_a0 out nocopy JTF_NUMBER_TABLE
2623: , p19_a1 out nocopy JTF_VARCHAR2_TABLE_100
2624: , p19_a2 out nocopy JTF_VARCHAR2_TABLE_400
2625: , p19_a3 out nocopy JTF_NUMBER_TABLE
2626: , p19_a4 out nocopy JTF_NUMBER_TABLE
2627: , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
2628: , p19_a6 out nocopy JTF_DATE_TABLE

Line 3288: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400

3284: , x_msg_data out nocopy VARCHAR2
3285: , x_loading_status out nocopy VARCHAR2
3286: , p9_a0 out nocopy JTF_NUMBER_TABLE
3287: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
3288: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
3289: , p9_a3 out nocopy JTF_NUMBER_TABLE
3290: , p9_a4 out nocopy JTF_NUMBER_TABLE
3291: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
3292: , p9_a6 out nocopy JTF_DATE_TABLE

Line 5100: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_400

5096: , x_loading_status out nocopy VARCHAR2
5097: , p8_a0 out nocopy JTF_NUMBER_TABLE
5098: , p8_a1 out nocopy JTF_NUMBER_TABLE
5099: , p8_a2 out nocopy JTF_NUMBER_TABLE
5100: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_400
5101: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
5102: , p8_a5 out nocopy JTF_NUMBER_TABLE
5103: , p8_a6 out nocopy JTF_DATE_TABLE
5104: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 5116: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_400

5112: , p8_a15 out nocopy JTF_NUMBER_TABLE
5113: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
5114: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
5115: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_100
5116: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_400
5117: , x_tbl_count out nocopy NUMBER
5118: )
5119:
5120: as

Line 5191: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400

5187: , x_msg_data out nocopy VARCHAR2
5188: , x_loading_status out nocopy VARCHAR2
5189: , p8_a0 out nocopy JTF_NUMBER_TABLE
5190: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
5191: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400
5192: , p8_a3 out nocopy JTF_NUMBER_TABLE
5193: , p8_a4 out nocopy JTF_NUMBER_TABLE
5194: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
5195: , p8_a6 out nocopy JTF_DATE_TABLE