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_FPR_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 25: , a3 JTF_VARCHAR2_TABLE_100

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

Line 64: , a3 out nocopy JTF_VARCHAR2_TABLE_100

60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_fpr_pvt.fpr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_NUMBER_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE

Line 79: a3 := JTF_VARCHAR2_TABLE_100();

75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_NUMBER_TABLE();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();

Line 91: a3 := JTF_VARCHAR2_TABLE_100();

87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_NUMBER_TABLE();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();

Line 136: , a1 JTF_VARCHAR2_TABLE_100

132: end if;
133: end rosetta_table_copy_out_p2;
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_VARCHAR2_TABLE_300
140: , a5 JTF_VARCHAR2_TABLE_800

Line 137: , a2 JTF_VARCHAR2_TABLE_100

133: end rosetta_table_copy_out_p2;
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_VARCHAR2_TABLE_300
140: , a5 JTF_VARCHAR2_TABLE_800
141: , a6 JTF_NUMBER_TABLE

Line 138: , a3 JTF_VARCHAR2_TABLE_100

134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_VARCHAR2_TABLE_100
139: , a4 JTF_VARCHAR2_TABLE_300
140: , a5 JTF_VARCHAR2_TABLE_800
141: , a6 JTF_NUMBER_TABLE
142: , a7 JTF_DATE_TABLE

Line 175: , a1 out nocopy JTF_VARCHAR2_TABLE_100

171: end if;
172: end if;
173: end rosetta_table_copy_in_p5;
174: procedure rosetta_table_copy_out_p5(t okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_VARCHAR2_TABLE_100
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_VARCHAR2_TABLE_300
179: , a5 out nocopy JTF_VARCHAR2_TABLE_800

Line 176: , a2 out nocopy JTF_VARCHAR2_TABLE_100

172: end if;
173: end rosetta_table_copy_in_p5;
174: procedure rosetta_table_copy_out_p5(t okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_VARCHAR2_TABLE_100
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_VARCHAR2_TABLE_300
179: , a5 out nocopy JTF_VARCHAR2_TABLE_800
180: , a6 out nocopy JTF_NUMBER_TABLE

Line 177: , a3 out nocopy JTF_VARCHAR2_TABLE_100

173: end rosetta_table_copy_in_p5;
174: procedure rosetta_table_copy_out_p5(t okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_VARCHAR2_TABLE_100
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_VARCHAR2_TABLE_300
179: , a5 out nocopy JTF_VARCHAR2_TABLE_800
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_DATE_TABLE

Line 190: a1 := JTF_VARCHAR2_TABLE_100();

186: ddindx binary_integer; indx binary_integer;
187: begin
188: if t is null or t.count = 0 then
189: a0 := JTF_NUMBER_TABLE();
190: a1 := JTF_VARCHAR2_TABLE_100();
191: a2 := JTF_VARCHAR2_TABLE_100();
192: a3 := JTF_VARCHAR2_TABLE_100();
193: a4 := JTF_VARCHAR2_TABLE_300();
194: a5 := JTF_VARCHAR2_TABLE_800();

Line 191: a2 := JTF_VARCHAR2_TABLE_100();

187: begin
188: if t is null or t.count = 0 then
189: a0 := JTF_NUMBER_TABLE();
190: a1 := JTF_VARCHAR2_TABLE_100();
191: a2 := JTF_VARCHAR2_TABLE_100();
192: a3 := JTF_VARCHAR2_TABLE_100();
193: a4 := JTF_VARCHAR2_TABLE_300();
194: a5 := JTF_VARCHAR2_TABLE_800();
195: a6 := JTF_NUMBER_TABLE();

Line 192: a3 := JTF_VARCHAR2_TABLE_100();

188: if t is null or t.count = 0 then
189: a0 := JTF_NUMBER_TABLE();
190: a1 := JTF_VARCHAR2_TABLE_100();
191: a2 := JTF_VARCHAR2_TABLE_100();
192: a3 := JTF_VARCHAR2_TABLE_100();
193: a4 := JTF_VARCHAR2_TABLE_300();
194: a5 := JTF_VARCHAR2_TABLE_800();
195: a6 := JTF_NUMBER_TABLE();
196: a7 := JTF_DATE_TABLE();

Line 202: a1 := JTF_VARCHAR2_TABLE_100();

198: a9 := JTF_DATE_TABLE();
199: a10 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_VARCHAR2_TABLE_300();
206: a5 := JTF_VARCHAR2_TABLE_800();

Line 203: a2 := JTF_VARCHAR2_TABLE_100();

199: a10 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_VARCHAR2_TABLE_300();
206: a5 := JTF_VARCHAR2_TABLE_800();
207: a6 := JTF_NUMBER_TABLE();

Line 204: a3 := JTF_VARCHAR2_TABLE_100();

200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_VARCHAR2_TABLE_100();
205: a4 := JTF_VARCHAR2_TABLE_300();
206: a5 := JTF_VARCHAR2_TABLE_800();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_DATE_TABLE();

Line 250: , a2 JTF_VARCHAR2_TABLE_100

246: end rosetta_table_copy_out_p5;
247:
248: procedure rosetta_table_copy_in_p8(t out nocopy okl_fpr_pvt.fprv_tbl_type, a0 JTF_NUMBER_TABLE
249: , a1 JTF_NUMBER_TABLE
250: , a2 JTF_VARCHAR2_TABLE_100
251: , a3 JTF_NUMBER_TABLE
252: , a4 JTF_NUMBER_TABLE
253: , a5 JTF_NUMBER_TABLE
254: , a6 JTF_VARCHAR2_TABLE_300

Line 256: , a8 JTF_VARCHAR2_TABLE_100

252: , a4 JTF_NUMBER_TABLE
253: , a5 JTF_NUMBER_TABLE
254: , a6 JTF_VARCHAR2_TABLE_300
255: , a7 JTF_VARCHAR2_TABLE_800
256: , a8 JTF_VARCHAR2_TABLE_100
257: , a9 JTF_NUMBER_TABLE
258: , a10 JTF_DATE_TABLE
259: , a11 JTF_NUMBER_TABLE
260: , a12 JTF_DATE_TABLE

Line 295: , a2 out nocopy JTF_VARCHAR2_TABLE_100

291: end if;
292: end rosetta_table_copy_in_p8;
293: procedure rosetta_table_copy_out_p8(t okl_fpr_pvt.fprv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_VARCHAR2_TABLE_100
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_NUMBER_TABLE
299: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 301: , a8 out nocopy JTF_VARCHAR2_TABLE_100

297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_NUMBER_TABLE
299: , a6 out nocopy JTF_VARCHAR2_TABLE_300
300: , a7 out nocopy JTF_VARCHAR2_TABLE_800
301: , a8 out nocopy JTF_VARCHAR2_TABLE_100
302: , a9 out nocopy JTF_NUMBER_TABLE
303: , a10 out nocopy JTF_DATE_TABLE
304: , a11 out nocopy JTF_NUMBER_TABLE
305: , a12 out nocopy JTF_DATE_TABLE

Line 313: a2 := JTF_VARCHAR2_TABLE_100();

309: begin
310: if t is null or t.count = 0 then
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_NUMBER_TABLE();
313: a2 := JTF_VARCHAR2_TABLE_100();
314: a3 := JTF_NUMBER_TABLE();
315: a4 := JTF_NUMBER_TABLE();
316: a5 := JTF_NUMBER_TABLE();
317: a6 := JTF_VARCHAR2_TABLE_300();

Line 319: a8 := JTF_VARCHAR2_TABLE_100();

315: a4 := JTF_NUMBER_TABLE();
316: a5 := JTF_NUMBER_TABLE();
317: a6 := JTF_VARCHAR2_TABLE_300();
318: a7 := JTF_VARCHAR2_TABLE_800();
319: a8 := JTF_VARCHAR2_TABLE_100();
320: a9 := JTF_NUMBER_TABLE();
321: a10 := JTF_DATE_TABLE();
322: a11 := JTF_NUMBER_TABLE();
323: a12 := JTF_DATE_TABLE();

Line 328: a2 := JTF_VARCHAR2_TABLE_100();

324: a13 := JTF_NUMBER_TABLE();
325: else
326: a0 := JTF_NUMBER_TABLE();
327: a1 := JTF_NUMBER_TABLE();
328: a2 := JTF_VARCHAR2_TABLE_100();
329: a3 := JTF_NUMBER_TABLE();
330: a4 := JTF_NUMBER_TABLE();
331: a5 := JTF_NUMBER_TABLE();
332: a6 := JTF_VARCHAR2_TABLE_300();

Line 334: a8 := JTF_VARCHAR2_TABLE_100();

330: a4 := JTF_NUMBER_TABLE();
331: a5 := JTF_NUMBER_TABLE();
332: a6 := JTF_VARCHAR2_TABLE_300();
333: a7 := JTF_VARCHAR2_TABLE_800();
334: a8 := JTF_VARCHAR2_TABLE_100();
335: a9 := JTF_NUMBER_TABLE();
336: a10 := JTF_DATE_TABLE();
337: a11 := JTF_NUMBER_TABLE();
338: a12 := JTF_DATE_TABLE();

Line 484: , p5_a2 JTF_VARCHAR2_TABLE_100

480: , x_msg_count out nocopy NUMBER
481: , x_msg_data out nocopy VARCHAR2
482: , p5_a0 JTF_NUMBER_TABLE
483: , p5_a1 JTF_NUMBER_TABLE
484: , p5_a2 JTF_VARCHAR2_TABLE_100
485: , p5_a3 JTF_NUMBER_TABLE
486: , p5_a4 JTF_NUMBER_TABLE
487: , p5_a5 JTF_NUMBER_TABLE
488: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 490: , p5_a8 JTF_VARCHAR2_TABLE_100

486: , p5_a4 JTF_NUMBER_TABLE
487: , p5_a5 JTF_NUMBER_TABLE
488: , p5_a6 JTF_VARCHAR2_TABLE_300
489: , p5_a7 JTF_VARCHAR2_TABLE_800
490: , p5_a8 JTF_VARCHAR2_TABLE_100
491: , p5_a9 JTF_NUMBER_TABLE
492: , p5_a10 JTF_DATE_TABLE
493: , p5_a11 JTF_NUMBER_TABLE
494: , p5_a12 JTF_DATE_TABLE

Line 498: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

494: , p5_a12 JTF_DATE_TABLE
495: , p5_a13 JTF_NUMBER_TABLE
496: , p6_a0 out nocopy JTF_NUMBER_TABLE
497: , p6_a1 out nocopy JTF_NUMBER_TABLE
498: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
499: , p6_a3 out nocopy JTF_NUMBER_TABLE
500: , p6_a4 out nocopy JTF_NUMBER_TABLE
501: , p6_a5 out nocopy JTF_NUMBER_TABLE
502: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 504: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

500: , p6_a4 out nocopy JTF_NUMBER_TABLE
501: , p6_a5 out nocopy JTF_NUMBER_TABLE
502: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
503: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
504: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
505: , p6_a9 out nocopy JTF_NUMBER_TABLE
506: , p6_a10 out nocopy JTF_DATE_TABLE
507: , p6_a11 out nocopy JTF_NUMBER_TABLE
508: , p6_a12 out nocopy JTF_DATE_TABLE

Line 644: , p5_a2 JTF_VARCHAR2_TABLE_100

640: , x_msg_count out nocopy NUMBER
641: , x_msg_data out nocopy VARCHAR2
642: , p5_a0 JTF_NUMBER_TABLE
643: , p5_a1 JTF_NUMBER_TABLE
644: , p5_a2 JTF_VARCHAR2_TABLE_100
645: , p5_a3 JTF_NUMBER_TABLE
646: , p5_a4 JTF_NUMBER_TABLE
647: , p5_a5 JTF_NUMBER_TABLE
648: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 650: , p5_a8 JTF_VARCHAR2_TABLE_100

646: , p5_a4 JTF_NUMBER_TABLE
647: , p5_a5 JTF_NUMBER_TABLE
648: , p5_a6 JTF_VARCHAR2_TABLE_300
649: , p5_a7 JTF_VARCHAR2_TABLE_800
650: , p5_a8 JTF_VARCHAR2_TABLE_100
651: , p5_a9 JTF_NUMBER_TABLE
652: , p5_a10 JTF_DATE_TABLE
653: , p5_a11 JTF_NUMBER_TABLE
654: , p5_a12 JTF_DATE_TABLE

Line 803: , p5_a2 JTF_VARCHAR2_TABLE_100

799: , x_msg_count out nocopy NUMBER
800: , x_msg_data out nocopy VARCHAR2
801: , p5_a0 JTF_NUMBER_TABLE
802: , p5_a1 JTF_NUMBER_TABLE
803: , p5_a2 JTF_VARCHAR2_TABLE_100
804: , p5_a3 JTF_NUMBER_TABLE
805: , p5_a4 JTF_NUMBER_TABLE
806: , p5_a5 JTF_NUMBER_TABLE
807: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 809: , p5_a8 JTF_VARCHAR2_TABLE_100

805: , p5_a4 JTF_NUMBER_TABLE
806: , p5_a5 JTF_NUMBER_TABLE
807: , p5_a6 JTF_VARCHAR2_TABLE_300
808: , p5_a7 JTF_VARCHAR2_TABLE_800
809: , p5_a8 JTF_VARCHAR2_TABLE_100
810: , p5_a9 JTF_NUMBER_TABLE
811: , p5_a10 JTF_DATE_TABLE
812: , p5_a11 JTF_NUMBER_TABLE
813: , p5_a12 JTF_DATE_TABLE

Line 817: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

813: , p5_a12 JTF_DATE_TABLE
814: , p5_a13 JTF_NUMBER_TABLE
815: , p6_a0 out nocopy JTF_NUMBER_TABLE
816: , p6_a1 out nocopy JTF_NUMBER_TABLE
817: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
818: , p6_a3 out nocopy JTF_NUMBER_TABLE
819: , p6_a4 out nocopy JTF_NUMBER_TABLE
820: , p6_a5 out nocopy JTF_NUMBER_TABLE
821: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 823: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

819: , p6_a4 out nocopy JTF_NUMBER_TABLE
820: , p6_a5 out nocopy JTF_NUMBER_TABLE
821: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
822: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
823: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
824: , p6_a9 out nocopy JTF_NUMBER_TABLE
825: , p6_a10 out nocopy JTF_DATE_TABLE
826: , p6_a11 out nocopy JTF_NUMBER_TABLE
827: , p6_a12 out nocopy JTF_DATE_TABLE

Line 963: , p5_a2 JTF_VARCHAR2_TABLE_100

959: , x_msg_count out nocopy NUMBER
960: , x_msg_data out nocopy VARCHAR2
961: , p5_a0 JTF_NUMBER_TABLE
962: , p5_a1 JTF_NUMBER_TABLE
963: , p5_a2 JTF_VARCHAR2_TABLE_100
964: , p5_a3 JTF_NUMBER_TABLE
965: , p5_a4 JTF_NUMBER_TABLE
966: , p5_a5 JTF_NUMBER_TABLE
967: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 969: , p5_a8 JTF_VARCHAR2_TABLE_100

965: , p5_a4 JTF_NUMBER_TABLE
966: , p5_a5 JTF_NUMBER_TABLE
967: , p5_a6 JTF_VARCHAR2_TABLE_300
968: , p5_a7 JTF_VARCHAR2_TABLE_800
969: , p5_a8 JTF_VARCHAR2_TABLE_100
970: , p5_a9 JTF_NUMBER_TABLE
971: , p5_a10 JTF_DATE_TABLE
972: , p5_a11 JTF_NUMBER_TABLE
973: , p5_a12 JTF_DATE_TABLE

Line 1090: , p5_a2 JTF_VARCHAR2_TABLE_100

1086: , x_msg_count out nocopy NUMBER
1087: , x_msg_data out nocopy VARCHAR2
1088: , p5_a0 JTF_NUMBER_TABLE
1089: , p5_a1 JTF_NUMBER_TABLE
1090: , p5_a2 JTF_VARCHAR2_TABLE_100
1091: , p5_a3 JTF_NUMBER_TABLE
1092: , p5_a4 JTF_NUMBER_TABLE
1093: , p5_a5 JTF_NUMBER_TABLE
1094: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 1096: , p5_a8 JTF_VARCHAR2_TABLE_100

1092: , p5_a4 JTF_NUMBER_TABLE
1093: , p5_a5 JTF_NUMBER_TABLE
1094: , p5_a6 JTF_VARCHAR2_TABLE_300
1095: , p5_a7 JTF_VARCHAR2_TABLE_800
1096: , p5_a8 JTF_VARCHAR2_TABLE_100
1097: , p5_a9 JTF_NUMBER_TABLE
1098: , p5_a10 JTF_DATE_TABLE
1099: , p5_a11 JTF_NUMBER_TABLE
1100: , p5_a12 JTF_DATE_TABLE