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.OKL_REP_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 4: , a1 JTF_VARCHAR2_TABLE_300

1: package body okl_rep_pvt_w as
2: /* $Header: OKLIREPB.pls 120.0 2007/12/10 18:28:25 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rep_pvt.repv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100

Line 61: , a1 out nocopy JTF_VARCHAR2_TABLE_300

57: end if;
58: end if;
59: end rosetta_table_copy_in_p2;
60: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_VARCHAR2_TABLE_300
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 85: a1 := JTF_VARCHAR2_TABLE_300();

81: ddindx binary_integer; indx binary_integer;
82: begin
83: if t is null or t.count = 0 then
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_VARCHAR2_TABLE_300();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_NUMBER_TABLE();
89: a5 := JTF_VARCHAR2_TABLE_100();

Line 106: a1 := JTF_VARCHAR2_TABLE_300();

102: a18 := JTF_VARCHAR2_TABLE_100();
103: a19 := JTF_VARCHAR2_TABLE_100();
104: else
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_VARCHAR2_TABLE_300();
107: a2 := JTF_NUMBER_TABLE();
108: a3 := JTF_VARCHAR2_TABLE_100();
109: a4 := JTF_NUMBER_TABLE();
110: a5 := JTF_VARCHAR2_TABLE_100();

Line 180: , a1 JTF_VARCHAR2_TABLE_300

176: end if;
177: end rosetta_table_copy_out_p2;
178:
179: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE
180: , a1 JTF_VARCHAR2_TABLE_300
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_VARCHAR2_TABLE_100
183: , a4 JTF_NUMBER_TABLE
184: , a5 JTF_VARCHAR2_TABLE_100

Line 229: , a1 out nocopy JTF_VARCHAR2_TABLE_300

225: end if;
226: end if;
227: end rosetta_table_copy_in_p5;
228: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
229: , a1 out nocopy JTF_VARCHAR2_TABLE_300
230: , a2 out nocopy JTF_NUMBER_TABLE
231: , a3 out nocopy JTF_VARCHAR2_TABLE_100
232: , a4 out nocopy JTF_NUMBER_TABLE
233: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 249: a1 := JTF_VARCHAR2_TABLE_300();

245: ddindx binary_integer; indx binary_integer;
246: begin
247: if t is null or t.count = 0 then
248: a0 := JTF_NUMBER_TABLE();
249: a1 := JTF_VARCHAR2_TABLE_300();
250: a2 := JTF_NUMBER_TABLE();
251: a3 := JTF_VARCHAR2_TABLE_100();
252: a4 := JTF_NUMBER_TABLE();
253: a5 := JTF_VARCHAR2_TABLE_100();

Line 266: a1 := JTF_VARCHAR2_TABLE_300();

262: a14 := JTF_DATE_TABLE();
263: a15 := JTF_NUMBER_TABLE();
264: else
265: a0 := JTF_NUMBER_TABLE();
266: a1 := JTF_VARCHAR2_TABLE_300();
267: a2 := JTF_NUMBER_TABLE();
268: a3 := JTF_VARCHAR2_TABLE_100();
269: a4 := JTF_NUMBER_TABLE();
270: a5 := JTF_VARCHAR2_TABLE_100();

Line 331: , a4 JTF_VARCHAR2_TABLE_300

327: procedure rosetta_table_copy_in_p8(t out nocopy okl_rep_pvt.okl_reports_tl_tbl_type, a0 JTF_NUMBER_TABLE
328: , a1 JTF_VARCHAR2_TABLE_100
329: , a2 JTF_VARCHAR2_TABLE_100
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_300
332: , a5 JTF_VARCHAR2_TABLE_2000
333: , a6 JTF_NUMBER_TABLE
334: , a7 JTF_DATE_TABLE
335: , a8 JTF_NUMBER_TABLE

Line 370: , a4 out nocopy JTF_VARCHAR2_TABLE_300

366: procedure rosetta_table_copy_out_p8(t okl_rep_pvt.okl_reports_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_VARCHAR2_TABLE_100
368: , a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , a3 out nocopy JTF_VARCHAR2_TABLE_100
370: , a4 out nocopy JTF_VARCHAR2_TABLE_300
371: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
372: , a6 out nocopy JTF_NUMBER_TABLE
373: , a7 out nocopy JTF_DATE_TABLE
374: , a8 out nocopy JTF_NUMBER_TABLE

Line 385: a4 := JTF_VARCHAR2_TABLE_300();

381: a0 := JTF_NUMBER_TABLE();
382: a1 := JTF_VARCHAR2_TABLE_100();
383: a2 := JTF_VARCHAR2_TABLE_100();
384: a3 := JTF_VARCHAR2_TABLE_100();
385: a4 := JTF_VARCHAR2_TABLE_300();
386: a5 := JTF_VARCHAR2_TABLE_2000();
387: a6 := JTF_NUMBER_TABLE();
388: a7 := JTF_DATE_TABLE();
389: a8 := JTF_NUMBER_TABLE();

Line 397: a4 := JTF_VARCHAR2_TABLE_300();

393: a0 := JTF_NUMBER_TABLE();
394: a1 := JTF_VARCHAR2_TABLE_100();
395: a2 := JTF_VARCHAR2_TABLE_100();
396: a3 := JTF_VARCHAR2_TABLE_100();
397: a4 := JTF_VARCHAR2_TABLE_300();
398: a5 := JTF_VARCHAR2_TABLE_2000();
399: a6 := JTF_NUMBER_TABLE();
400: a7 := JTF_DATE_TABLE();
401: a8 := JTF_NUMBER_TABLE();

Line 565: , p5_a1 JTF_VARCHAR2_TABLE_300

561: , x_return_status out nocopy VARCHAR2
562: , x_msg_count out nocopy NUMBER
563: , x_msg_data out nocopy VARCHAR2
564: , p5_a0 JTF_NUMBER_TABLE
565: , p5_a1 JTF_VARCHAR2_TABLE_300
566: , p5_a2 JTF_NUMBER_TABLE
567: , p5_a3 JTF_VARCHAR2_TABLE_100
568: , p5_a4 JTF_NUMBER_TABLE
569: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 585: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300

581: , p5_a17 JTF_VARCHAR2_TABLE_100
582: , p5_a18 JTF_VARCHAR2_TABLE_100
583: , p5_a19 JTF_VARCHAR2_TABLE_100
584: , p6_a0 out nocopy JTF_NUMBER_TABLE
585: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
586: , p6_a2 out nocopy JTF_NUMBER_TABLE
587: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a4 out nocopy JTF_NUMBER_TABLE
589: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 713: , p5_a1 JTF_VARCHAR2_TABLE_300

709: , x_return_status out nocopy VARCHAR2
710: , x_msg_count out nocopy NUMBER
711: , x_msg_data out nocopy VARCHAR2
712: , p5_a0 JTF_NUMBER_TABLE
713: , p5_a1 JTF_VARCHAR2_TABLE_300
714: , p5_a2 JTF_NUMBER_TABLE
715: , p5_a3 JTF_VARCHAR2_TABLE_100
716: , p5_a4 JTF_NUMBER_TABLE
717: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 733: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300

729: , p5_a17 JTF_VARCHAR2_TABLE_100
730: , p5_a18 JTF_VARCHAR2_TABLE_100
731: , p5_a19 JTF_VARCHAR2_TABLE_100
732: , p6_a0 out nocopy JTF_NUMBER_TABLE
733: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
734: , p6_a2 out nocopy JTF_NUMBER_TABLE
735: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
736: , p6_a4 out nocopy JTF_NUMBER_TABLE
737: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 909: , p5_a1 JTF_VARCHAR2_TABLE_300

905: , x_return_status out nocopy VARCHAR2
906: , x_msg_count out nocopy NUMBER
907: , x_msg_data out nocopy VARCHAR2
908: , p5_a0 JTF_NUMBER_TABLE
909: , p5_a1 JTF_VARCHAR2_TABLE_300
910: , p5_a2 JTF_NUMBER_TABLE
911: , p5_a3 JTF_VARCHAR2_TABLE_100
912: , p5_a4 JTF_NUMBER_TABLE
913: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1012: , p5_a1 JTF_VARCHAR2_TABLE_300

1008: , x_return_status out nocopy VARCHAR2
1009: , x_msg_count out nocopy NUMBER
1010: , x_msg_data out nocopy VARCHAR2
1011: , p5_a0 JTF_NUMBER_TABLE
1012: , p5_a1 JTF_VARCHAR2_TABLE_300
1013: , p5_a2 JTF_NUMBER_TABLE
1014: , p5_a3 JTF_VARCHAR2_TABLE_100
1015: , p5_a4 JTF_NUMBER_TABLE
1016: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1207: , p5_a1 JTF_VARCHAR2_TABLE_300

1203: , x_return_status out nocopy VARCHAR2
1204: , x_msg_count out nocopy NUMBER
1205: , x_msg_data out nocopy VARCHAR2
1206: , p5_a0 JTF_NUMBER_TABLE
1207: , p5_a1 JTF_VARCHAR2_TABLE_300
1208: , p5_a2 JTF_NUMBER_TABLE
1209: , p5_a3 JTF_VARCHAR2_TABLE_100
1210: , p5_a4 JTF_NUMBER_TABLE
1211: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1227: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300

1223: , p5_a17 JTF_VARCHAR2_TABLE_100
1224: , p5_a18 JTF_VARCHAR2_TABLE_100
1225: , p5_a19 JTF_VARCHAR2_TABLE_100
1226: , p6_a0 out nocopy JTF_NUMBER_TABLE
1227: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1228: , p6_a2 out nocopy JTF_NUMBER_TABLE
1229: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1230: , p6_a4 out nocopy JTF_NUMBER_TABLE
1231: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1355: , p5_a1 JTF_VARCHAR2_TABLE_300

1351: , x_return_status out nocopy VARCHAR2
1352: , x_msg_count out nocopy NUMBER
1353: , x_msg_data out nocopy VARCHAR2
1354: , p5_a0 JTF_NUMBER_TABLE
1355: , p5_a1 JTF_VARCHAR2_TABLE_300
1356: , p5_a2 JTF_NUMBER_TABLE
1357: , p5_a3 JTF_VARCHAR2_TABLE_100
1358: , p5_a4 JTF_NUMBER_TABLE
1359: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1375: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300

1371: , p5_a17 JTF_VARCHAR2_TABLE_100
1372: , p5_a18 JTF_VARCHAR2_TABLE_100
1373: , p5_a19 JTF_VARCHAR2_TABLE_100
1374: , p6_a0 out nocopy JTF_NUMBER_TABLE
1375: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1376: , p6_a2 out nocopy JTF_NUMBER_TABLE
1377: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1378: , p6_a4 out nocopy JTF_NUMBER_TABLE
1379: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1551: , p5_a1 JTF_VARCHAR2_TABLE_300

1547: , x_return_status out nocopy VARCHAR2
1548: , x_msg_count out nocopy NUMBER
1549: , x_msg_data out nocopy VARCHAR2
1550: , p5_a0 JTF_NUMBER_TABLE
1551: , p5_a1 JTF_VARCHAR2_TABLE_300
1552: , p5_a2 JTF_NUMBER_TABLE
1553: , p5_a3 JTF_VARCHAR2_TABLE_100
1554: , p5_a4 JTF_NUMBER_TABLE
1555: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1654: , p5_a1 JTF_VARCHAR2_TABLE_300

1650: , x_return_status out nocopy VARCHAR2
1651: , x_msg_count out nocopy NUMBER
1652: , x_msg_data out nocopy VARCHAR2
1653: , p5_a0 JTF_NUMBER_TABLE
1654: , p5_a1 JTF_VARCHAR2_TABLE_300
1655: , p5_a2 JTF_NUMBER_TABLE
1656: , p5_a3 JTF_VARCHAR2_TABLE_100
1657: , p5_a4 JTF_NUMBER_TABLE
1658: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1805: , p5_a1 JTF_VARCHAR2_TABLE_300

1801: , x_return_status out nocopy VARCHAR2
1802: , x_msg_count out nocopy NUMBER
1803: , x_msg_data out nocopy VARCHAR2
1804: , p5_a0 JTF_NUMBER_TABLE
1805: , p5_a1 JTF_VARCHAR2_TABLE_300
1806: , p5_a2 JTF_NUMBER_TABLE
1807: , p5_a3 JTF_VARCHAR2_TABLE_100
1808: , p5_a4 JTF_NUMBER_TABLE
1809: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1908: , p5_a1 JTF_VARCHAR2_TABLE_300

1904: , x_return_status out nocopy VARCHAR2
1905: , x_msg_count out nocopy NUMBER
1906: , x_msg_data out nocopy VARCHAR2
1907: , p5_a0 JTF_NUMBER_TABLE
1908: , p5_a1 JTF_VARCHAR2_TABLE_300
1909: , p5_a2 JTF_NUMBER_TABLE
1910: , p5_a3 JTF_VARCHAR2_TABLE_100
1911: , p5_a4 JTF_NUMBER_TABLE
1912: , p5_a5 JTF_VARCHAR2_TABLE_100