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_OPT_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 23: , a1 JTF_VARCHAR2_TABLE_200

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_opt_pvt.opt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE

Line 25: , a3 JTF_VARCHAR2_TABLE_2000

21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_opt_pvt.opt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_500

Line 94: , a1 out nocopy JTF_VARCHAR2_TABLE_200

90: end if;
91: end if;
92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t okl_opt_pvt.opt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_200
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a4 out nocopy JTF_DATE_TABLE
98: , a5 out nocopy JTF_DATE_TABLE

Line 96: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t okl_opt_pvt.opt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_200
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a4 out nocopy JTF_DATE_TABLE
98: , a5 out nocopy JTF_DATE_TABLE
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 125: a1 := JTF_VARCHAR2_TABLE_200();

121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_VARCHAR2_TABLE_200();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_2000();
128: a4 := JTF_DATE_TABLE();
129: a5 := JTF_DATE_TABLE();

Line 127: a3 := JTF_VARCHAR2_TABLE_2000();

123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_VARCHAR2_TABLE_200();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_2000();
128: a4 := JTF_DATE_TABLE();
129: a5 := JTF_DATE_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_VARCHAR2_TABLE_500();

Line 153: a1 := JTF_VARCHAR2_TABLE_200();

149: a25 := JTF_DATE_TABLE();
150: a26 := JTF_NUMBER_TABLE();
151: else
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_VARCHAR2_TABLE_200();
154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_VARCHAR2_TABLE_2000();
156: a4 := JTF_DATE_TABLE();
157: a5 := JTF_DATE_TABLE();

Line 155: a3 := JTF_VARCHAR2_TABLE_2000();

151: else
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_VARCHAR2_TABLE_200();
154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_VARCHAR2_TABLE_2000();
156: a4 := JTF_DATE_TABLE();
157: a5 := JTF_DATE_TABLE();
158: a6 := JTF_VARCHAR2_TABLE_100();
159: a7 := JTF_VARCHAR2_TABLE_500();

Line 249: , a2 JTF_VARCHAR2_TABLE_200

245: end rosetta_table_copy_out_p2;
246:
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_opt_pvt.optv_tbl_type, a0 JTF_NUMBER_TABLE
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_VARCHAR2_TABLE_200
250: , a3 JTF_VARCHAR2_TABLE_2000
251: , a4 JTF_DATE_TABLE
252: , a5 JTF_DATE_TABLE
253: , a6 JTF_VARCHAR2_TABLE_100

Line 250: , a3 JTF_VARCHAR2_TABLE_2000

246:
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_opt_pvt.optv_tbl_type, a0 JTF_NUMBER_TABLE
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_VARCHAR2_TABLE_200
250: , a3 JTF_VARCHAR2_TABLE_2000
251: , a4 JTF_DATE_TABLE
252: , a5 JTF_DATE_TABLE
253: , a6 JTF_VARCHAR2_TABLE_100
254: , a7 JTF_VARCHAR2_TABLE_500

Line 320: , a2 out nocopy JTF_VARCHAR2_TABLE_200

316: end if;
317: end rosetta_table_copy_in_p5;
318: procedure rosetta_table_copy_out_p5(t okl_opt_pvt.optv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_VARCHAR2_TABLE_200
321: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
322: , a4 out nocopy JTF_DATE_TABLE
323: , a5 out nocopy JTF_DATE_TABLE
324: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 321: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

317: end rosetta_table_copy_in_p5;
318: procedure rosetta_table_copy_out_p5(t okl_opt_pvt.optv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_VARCHAR2_TABLE_200
321: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
322: , a4 out nocopy JTF_DATE_TABLE
323: , a5 out nocopy JTF_DATE_TABLE
324: , a6 out nocopy JTF_VARCHAR2_TABLE_100
325: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 351: a2 := JTF_VARCHAR2_TABLE_200();

347: begin
348: if t is null or t.count = 0 then
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_VARCHAR2_TABLE_200();
352: a3 := JTF_VARCHAR2_TABLE_2000();
353: a4 := JTF_DATE_TABLE();
354: a5 := JTF_DATE_TABLE();
355: a6 := JTF_VARCHAR2_TABLE_100();

Line 352: a3 := JTF_VARCHAR2_TABLE_2000();

348: if t is null or t.count = 0 then
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_VARCHAR2_TABLE_200();
352: a3 := JTF_VARCHAR2_TABLE_2000();
353: a4 := JTF_DATE_TABLE();
354: a5 := JTF_DATE_TABLE();
355: a6 := JTF_VARCHAR2_TABLE_100();
356: a7 := JTF_VARCHAR2_TABLE_500();

Line 379: a2 := JTF_VARCHAR2_TABLE_200();

375: a26 := JTF_NUMBER_TABLE();
376: else
377: a0 := JTF_NUMBER_TABLE();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_VARCHAR2_TABLE_200();
380: a3 := JTF_VARCHAR2_TABLE_2000();
381: a4 := JTF_DATE_TABLE();
382: a5 := JTF_DATE_TABLE();
383: a6 := JTF_VARCHAR2_TABLE_100();

Line 380: a3 := JTF_VARCHAR2_TABLE_2000();

376: else
377: a0 := JTF_NUMBER_TABLE();
378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_VARCHAR2_TABLE_200();
380: a3 := JTF_VARCHAR2_TABLE_2000();
381: a4 := JTF_DATE_TABLE();
382: a5 := JTF_DATE_TABLE();
383: a6 := JTF_VARCHAR2_TABLE_100();
384: a7 := JTF_VARCHAR2_TABLE_500();

Line 626: , p5_a2 JTF_VARCHAR2_TABLE_200

622: , x_msg_count out nocopy NUMBER
623: , x_msg_data out nocopy VARCHAR2
624: , p5_a0 JTF_NUMBER_TABLE
625: , p5_a1 JTF_NUMBER_TABLE
626: , p5_a2 JTF_VARCHAR2_TABLE_200
627: , p5_a3 JTF_VARCHAR2_TABLE_2000
628: , p5_a4 JTF_DATE_TABLE
629: , p5_a5 JTF_DATE_TABLE
630: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 627: , p5_a3 JTF_VARCHAR2_TABLE_2000

623: , x_msg_data out nocopy VARCHAR2
624: , p5_a0 JTF_NUMBER_TABLE
625: , p5_a1 JTF_NUMBER_TABLE
626: , p5_a2 JTF_VARCHAR2_TABLE_200
627: , p5_a3 JTF_VARCHAR2_TABLE_2000
628: , p5_a4 JTF_DATE_TABLE
629: , p5_a5 JTF_DATE_TABLE
630: , p5_a6 JTF_VARCHAR2_TABLE_100
631: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 653: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

649: , p5_a25 JTF_DATE_TABLE
650: , p5_a26 JTF_NUMBER_TABLE
651: , p6_a0 out nocopy JTF_NUMBER_TABLE
652: , p6_a1 out nocopy JTF_NUMBER_TABLE
653: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
654: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
655: , p6_a4 out nocopy JTF_DATE_TABLE
656: , p6_a5 out nocopy JTF_DATE_TABLE
657: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 654: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

650: , p5_a26 JTF_NUMBER_TABLE
651: , p6_a0 out nocopy JTF_NUMBER_TABLE
652: , p6_a1 out nocopy JTF_NUMBER_TABLE
653: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
654: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
655: , p6_a4 out nocopy JTF_DATE_TABLE
656: , p6_a5 out nocopy JTF_DATE_TABLE
657: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
658: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 864: , p5_a2 JTF_VARCHAR2_TABLE_200

860: , x_msg_count out nocopy NUMBER
861: , x_msg_data out nocopy VARCHAR2
862: , p5_a0 JTF_NUMBER_TABLE
863: , p5_a1 JTF_NUMBER_TABLE
864: , p5_a2 JTF_VARCHAR2_TABLE_200
865: , p5_a3 JTF_VARCHAR2_TABLE_2000
866: , p5_a4 JTF_DATE_TABLE
867: , p5_a5 JTF_DATE_TABLE
868: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 865: , p5_a3 JTF_VARCHAR2_TABLE_2000

861: , x_msg_data out nocopy VARCHAR2
862: , p5_a0 JTF_NUMBER_TABLE
863: , p5_a1 JTF_NUMBER_TABLE
864: , p5_a2 JTF_VARCHAR2_TABLE_200
865: , p5_a3 JTF_VARCHAR2_TABLE_2000
866: , p5_a4 JTF_DATE_TABLE
867: , p5_a5 JTF_DATE_TABLE
868: , p5_a6 JTF_VARCHAR2_TABLE_100
869: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1101: , p5_a2 JTF_VARCHAR2_TABLE_200

1097: , x_msg_count out nocopy NUMBER
1098: , x_msg_data out nocopy VARCHAR2
1099: , p5_a0 JTF_NUMBER_TABLE
1100: , p5_a1 JTF_NUMBER_TABLE
1101: , p5_a2 JTF_VARCHAR2_TABLE_200
1102: , p5_a3 JTF_VARCHAR2_TABLE_2000
1103: , p5_a4 JTF_DATE_TABLE
1104: , p5_a5 JTF_DATE_TABLE
1105: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1102: , p5_a3 JTF_VARCHAR2_TABLE_2000

1098: , x_msg_data out nocopy VARCHAR2
1099: , p5_a0 JTF_NUMBER_TABLE
1100: , p5_a1 JTF_NUMBER_TABLE
1101: , p5_a2 JTF_VARCHAR2_TABLE_200
1102: , p5_a3 JTF_VARCHAR2_TABLE_2000
1103: , p5_a4 JTF_DATE_TABLE
1104: , p5_a5 JTF_DATE_TABLE
1105: , p5_a6 JTF_VARCHAR2_TABLE_100
1106: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1128: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

1124: , p5_a25 JTF_DATE_TABLE
1125: , p5_a26 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1129: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1130: , p6_a4 out nocopy JTF_DATE_TABLE
1131: , p6_a5 out nocopy JTF_DATE_TABLE
1132: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1129: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

1125: , p5_a26 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1129: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1130: , p6_a4 out nocopy JTF_DATE_TABLE
1131: , p6_a5 out nocopy JTF_DATE_TABLE
1132: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1133: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 1339: , p5_a2 JTF_VARCHAR2_TABLE_200

1335: , x_msg_count out nocopy NUMBER
1336: , x_msg_data out nocopy VARCHAR2
1337: , p5_a0 JTF_NUMBER_TABLE
1338: , p5_a1 JTF_NUMBER_TABLE
1339: , p5_a2 JTF_VARCHAR2_TABLE_200
1340: , p5_a3 JTF_VARCHAR2_TABLE_2000
1341: , p5_a4 JTF_DATE_TABLE
1342: , p5_a5 JTF_DATE_TABLE
1343: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1340: , p5_a3 JTF_VARCHAR2_TABLE_2000

1336: , x_msg_data out nocopy VARCHAR2
1337: , p5_a0 JTF_NUMBER_TABLE
1338: , p5_a1 JTF_NUMBER_TABLE
1339: , p5_a2 JTF_VARCHAR2_TABLE_200
1340: , p5_a3 JTF_VARCHAR2_TABLE_2000
1341: , p5_a4 JTF_DATE_TABLE
1342: , p5_a5 JTF_DATE_TABLE
1343: , p5_a6 JTF_VARCHAR2_TABLE_100
1344: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1518: , p5_a2 JTF_VARCHAR2_TABLE_200

1514: , x_msg_count out nocopy NUMBER
1515: , x_msg_data out nocopy VARCHAR2
1516: , p5_a0 JTF_NUMBER_TABLE
1517: , p5_a1 JTF_NUMBER_TABLE
1518: , p5_a2 JTF_VARCHAR2_TABLE_200
1519: , p5_a3 JTF_VARCHAR2_TABLE_2000
1520: , p5_a4 JTF_DATE_TABLE
1521: , p5_a5 JTF_DATE_TABLE
1522: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1519: , p5_a3 JTF_VARCHAR2_TABLE_2000

1515: , x_msg_data out nocopy VARCHAR2
1516: , p5_a0 JTF_NUMBER_TABLE
1517: , p5_a1 JTF_NUMBER_TABLE
1518: , p5_a2 JTF_VARCHAR2_TABLE_200
1519: , p5_a3 JTF_VARCHAR2_TABLE_2000
1520: , p5_a4 JTF_DATE_TABLE
1521: , p5_a5 JTF_DATE_TABLE
1522: , p5_a6 JTF_VARCHAR2_TABLE_100
1523: , p5_a7 JTF_VARCHAR2_TABLE_500