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

Line 127: , a1 JTF_VARCHAR2_TABLE_100

123: end if;
124: end rosetta_table_copy_out_p20;
125:
126: procedure rosetta_table_copy_in_p22(t out nocopy okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 JTF_VARCHAR2_TABLE_300
127: , a1 JTF_VARCHAR2_TABLE_100
128: ) as
129: ddindx binary_integer; indx binary_integer;
130: begin
131: if a0 is not null and a0.count > 0 then

Line 148: , a1 out nocopy JTF_VARCHAR2_TABLE_100

144: end if;
145: end if;
146: end rosetta_table_copy_in_p22;
147: procedure rosetta_table_copy_out_p22(t okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
148: , a1 out nocopy JTF_VARCHAR2_TABLE_100
149: ) as
150: ddindx binary_integer; indx binary_integer;
151: begin
152: if t is null or t.count = 0 then

Line 154: a1 := JTF_VARCHAR2_TABLE_100();

150: ddindx binary_integer; indx binary_integer;
151: begin
152: if t is null or t.count = 0 then
153: a0 := JTF_VARCHAR2_TABLE_300();
154: a1 := JTF_VARCHAR2_TABLE_100();
155: else
156: a0 := JTF_VARCHAR2_TABLE_300();
157: a1 := JTF_VARCHAR2_TABLE_100();
158: if t.count > 0 then

Line 157: a1 := JTF_VARCHAR2_TABLE_100();

153: a0 := JTF_VARCHAR2_TABLE_300();
154: a1 := JTF_VARCHAR2_TABLE_100();
155: else
156: a0 := JTF_VARCHAR2_TABLE_300();
157: a1 := JTF_VARCHAR2_TABLE_100();
158: if t.count > 0 then
159: a0.extend(t.count);
160: a1.extend(t.count);
161: ddindx := t.first;

Line 184: , a8 JTF_VARCHAR2_TABLE_100

180: , a4 JTF_VARCHAR2_TABLE_2000
181: , a5 JTF_DATE_TABLE
182: , a6 JTF_DATE_TABLE
183: , a7 JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: , a10 JTF_VARCHAR2_TABLE_300
187: ) as
188: ddindx binary_integer; indx binary_integer;

Line 185: , a9 JTF_VARCHAR2_TABLE_100

181: , a5 JTF_DATE_TABLE
182: , a6 JTF_DATE_TABLE
183: , a7 JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: , a10 JTF_VARCHAR2_TABLE_300
187: ) as
188: ddindx binary_integer; indx binary_integer;
189: begin

Line 223: , a8 out nocopy JTF_VARCHAR2_TABLE_100

219: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
220: , a5 out nocopy JTF_DATE_TABLE
221: , a6 out nocopy JTF_DATE_TABLE
222: , a7 out nocopy JTF_NUMBER_TABLE
223: , a8 out nocopy JTF_VARCHAR2_TABLE_100
224: , a9 out nocopy JTF_VARCHAR2_TABLE_100
225: , a10 out nocopy JTF_VARCHAR2_TABLE_300
226: ) as
227: ddindx binary_integer; indx binary_integer;

Line 224: , a9 out nocopy JTF_VARCHAR2_TABLE_100

220: , a5 out nocopy JTF_DATE_TABLE
221: , a6 out nocopy JTF_DATE_TABLE
222: , a7 out nocopy JTF_NUMBER_TABLE
223: , a8 out nocopy JTF_VARCHAR2_TABLE_100
224: , a9 out nocopy JTF_VARCHAR2_TABLE_100
225: , a10 out nocopy JTF_VARCHAR2_TABLE_300
226: ) as
227: ddindx binary_integer; indx binary_integer;
228: begin

Line 238: a8 := JTF_VARCHAR2_TABLE_100();

234: a4 := JTF_VARCHAR2_TABLE_2000();
235: a5 := JTF_DATE_TABLE();
236: a6 := JTF_DATE_TABLE();
237: a7 := JTF_NUMBER_TABLE();
238: a8 := JTF_VARCHAR2_TABLE_100();
239: a9 := JTF_VARCHAR2_TABLE_100();
240: a10 := JTF_VARCHAR2_TABLE_300();
241: else
242: a0 := JTF_NUMBER_TABLE();

Line 239: a9 := JTF_VARCHAR2_TABLE_100();

235: a5 := JTF_DATE_TABLE();
236: a6 := JTF_DATE_TABLE();
237: a7 := JTF_NUMBER_TABLE();
238: a8 := JTF_VARCHAR2_TABLE_100();
239: a9 := JTF_VARCHAR2_TABLE_100();
240: a10 := JTF_VARCHAR2_TABLE_300();
241: else
242: a0 := JTF_NUMBER_TABLE();
243: a1 := JTF_NUMBER_TABLE();

Line 250: a8 := JTF_VARCHAR2_TABLE_100();

246: a4 := JTF_VARCHAR2_TABLE_2000();
247: a5 := JTF_DATE_TABLE();
248: a6 := JTF_DATE_TABLE();
249: a7 := JTF_NUMBER_TABLE();
250: a8 := JTF_VARCHAR2_TABLE_100();
251: a9 := JTF_VARCHAR2_TABLE_100();
252: a10 := JTF_VARCHAR2_TABLE_300();
253: if t.count > 0 then
254: a0.extend(t.count);

Line 251: a9 := JTF_VARCHAR2_TABLE_100();

247: a5 := JTF_DATE_TABLE();
248: a6 := JTF_DATE_TABLE();
249: a7 := JTF_NUMBER_TABLE();
250: a8 := JTF_VARCHAR2_TABLE_100();
251: a9 := JTF_VARCHAR2_TABLE_100();
252: a10 := JTF_VARCHAR2_TABLE_300();
253: if t.count > 0 then
254: a0.extend(t.count);
255: a1.extend(t.count);

Line 294: , a5 JTF_VARCHAR2_TABLE_100

290: , a1 JTF_NUMBER_TABLE
291: , a2 JTF_NUMBER_TABLE
292: , a3 JTF_VARCHAR2_TABLE_300
293: , a4 JTF_VARCHAR2_TABLE_2000
294: , a5 JTF_VARCHAR2_TABLE_100
295: , a6 JTF_DATE_TABLE
296: , a7 JTF_DATE_TABLE
297: , a8 JTF_NUMBER_TABLE
298: , a9 JTF_VARCHAR2_TABLE_100

Line 298: , a9 JTF_VARCHAR2_TABLE_100

294: , a5 JTF_VARCHAR2_TABLE_100
295: , a6 JTF_DATE_TABLE
296: , a7 JTF_DATE_TABLE
297: , a8 JTF_NUMBER_TABLE
298: , a9 JTF_VARCHAR2_TABLE_100
299: , a10 JTF_VARCHAR2_TABLE_100
300: , a11 JTF_VARCHAR2_TABLE_300
301: ) as
302: ddindx binary_integer; indx binary_integer;

Line 299: , a10 JTF_VARCHAR2_TABLE_100

295: , a6 JTF_DATE_TABLE
296: , a7 JTF_DATE_TABLE
297: , a8 JTF_NUMBER_TABLE
298: , a9 JTF_VARCHAR2_TABLE_100
299: , a10 JTF_VARCHAR2_TABLE_100
300: , a11 JTF_VARCHAR2_TABLE_300
301: ) as
302: ddindx binary_integer; indx binary_integer;
303: begin

Line 335: , a5 out nocopy JTF_VARCHAR2_TABLE_100

331: , a1 out nocopy JTF_NUMBER_TABLE
332: , a2 out nocopy JTF_NUMBER_TABLE
333: , a3 out nocopy JTF_VARCHAR2_TABLE_300
334: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
335: , a5 out nocopy JTF_VARCHAR2_TABLE_100
336: , a6 out nocopy JTF_DATE_TABLE
337: , a7 out nocopy JTF_DATE_TABLE
338: , a8 out nocopy JTF_NUMBER_TABLE
339: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 339: , a9 out nocopy JTF_VARCHAR2_TABLE_100

335: , a5 out nocopy JTF_VARCHAR2_TABLE_100
336: , a6 out nocopy JTF_DATE_TABLE
337: , a7 out nocopy JTF_DATE_TABLE
338: , a8 out nocopy JTF_NUMBER_TABLE
339: , a9 out nocopy JTF_VARCHAR2_TABLE_100
340: , a10 out nocopy JTF_VARCHAR2_TABLE_100
341: , a11 out nocopy JTF_VARCHAR2_TABLE_300
342: ) as
343: ddindx binary_integer; indx binary_integer;

Line 340: , a10 out nocopy JTF_VARCHAR2_TABLE_100

336: , a6 out nocopy JTF_DATE_TABLE
337: , a7 out nocopy JTF_DATE_TABLE
338: , a8 out nocopy JTF_NUMBER_TABLE
339: , a9 out nocopy JTF_VARCHAR2_TABLE_100
340: , a10 out nocopy JTF_VARCHAR2_TABLE_100
341: , a11 out nocopy JTF_VARCHAR2_TABLE_300
342: ) as
343: ddindx binary_integer; indx binary_integer;
344: begin

Line 351: a5 := JTF_VARCHAR2_TABLE_100();

347: a1 := JTF_NUMBER_TABLE();
348: a2 := JTF_NUMBER_TABLE();
349: a3 := JTF_VARCHAR2_TABLE_300();
350: a4 := JTF_VARCHAR2_TABLE_2000();
351: a5 := JTF_VARCHAR2_TABLE_100();
352: a6 := JTF_DATE_TABLE();
353: a7 := JTF_DATE_TABLE();
354: a8 := JTF_NUMBER_TABLE();
355: a9 := JTF_VARCHAR2_TABLE_100();

Line 355: a9 := JTF_VARCHAR2_TABLE_100();

351: a5 := JTF_VARCHAR2_TABLE_100();
352: a6 := JTF_DATE_TABLE();
353: a7 := JTF_DATE_TABLE();
354: a8 := JTF_NUMBER_TABLE();
355: a9 := JTF_VARCHAR2_TABLE_100();
356: a10 := JTF_VARCHAR2_TABLE_100();
357: a11 := JTF_VARCHAR2_TABLE_300();
358: else
359: a0 := JTF_NUMBER_TABLE();

Line 356: a10 := JTF_VARCHAR2_TABLE_100();

352: a6 := JTF_DATE_TABLE();
353: a7 := JTF_DATE_TABLE();
354: a8 := JTF_NUMBER_TABLE();
355: a9 := JTF_VARCHAR2_TABLE_100();
356: a10 := JTF_VARCHAR2_TABLE_100();
357: a11 := JTF_VARCHAR2_TABLE_300();
358: else
359: a0 := JTF_NUMBER_TABLE();
360: a1 := JTF_NUMBER_TABLE();

Line 364: a5 := JTF_VARCHAR2_TABLE_100();

360: a1 := JTF_NUMBER_TABLE();
361: a2 := JTF_NUMBER_TABLE();
362: a3 := JTF_VARCHAR2_TABLE_300();
363: a4 := JTF_VARCHAR2_TABLE_2000();
364: a5 := JTF_VARCHAR2_TABLE_100();
365: a6 := JTF_DATE_TABLE();
366: a7 := JTF_DATE_TABLE();
367: a8 := JTF_NUMBER_TABLE();
368: a9 := JTF_VARCHAR2_TABLE_100();

Line 368: a9 := JTF_VARCHAR2_TABLE_100();

364: a5 := JTF_VARCHAR2_TABLE_100();
365: a6 := JTF_DATE_TABLE();
366: a7 := JTF_DATE_TABLE();
367: a8 := JTF_NUMBER_TABLE();
368: a9 := JTF_VARCHAR2_TABLE_100();
369: a10 := JTF_VARCHAR2_TABLE_100();
370: a11 := JTF_VARCHAR2_TABLE_300();
371: if t.count > 0 then
372: a0.extend(t.count);

Line 369: a10 := JTF_VARCHAR2_TABLE_100();

365: a6 := JTF_DATE_TABLE();
366: a7 := JTF_DATE_TABLE();
367: a8 := JTF_NUMBER_TABLE();
368: a9 := JTF_VARCHAR2_TABLE_100();
369: a10 := JTF_VARCHAR2_TABLE_100();
370: a11 := JTF_VARCHAR2_TABLE_300();
371: if t.count > 0 then
372: a0.extend(t.count);
373: a1.extend(t.count);

Line 414: , a5 JTF_VARCHAR2_TABLE_100

410: , a1 JTF_VARCHAR2_TABLE_200
411: , a2 JTF_VARCHAR2_TABLE_200
412: , a3 JTF_NUMBER_TABLE
413: , a4 JTF_VARCHAR2_TABLE_2000
414: , a5 JTF_VARCHAR2_TABLE_100
415: , a6 JTF_VARCHAR2_TABLE_200
416: , a7 JTF_VARCHAR2_TABLE_4000
417: ) as
418: ddindx binary_integer; indx binary_integer;

Line 447: , a5 out nocopy JTF_VARCHAR2_TABLE_100

443: , a1 out nocopy JTF_VARCHAR2_TABLE_200
444: , a2 out nocopy JTF_VARCHAR2_TABLE_200
445: , a3 out nocopy JTF_NUMBER_TABLE
446: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
447: , a5 out nocopy JTF_VARCHAR2_TABLE_100
448: , a6 out nocopy JTF_VARCHAR2_TABLE_200
449: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
450: ) as
451: ddindx binary_integer; indx binary_integer;

Line 459: a5 := JTF_VARCHAR2_TABLE_100();

455: a1 := JTF_VARCHAR2_TABLE_200();
456: a2 := JTF_VARCHAR2_TABLE_200();
457: a3 := JTF_NUMBER_TABLE();
458: a4 := JTF_VARCHAR2_TABLE_2000();
459: a5 := JTF_VARCHAR2_TABLE_100();
460: a6 := JTF_VARCHAR2_TABLE_200();
461: a7 := JTF_VARCHAR2_TABLE_4000();
462: else
463: a0 := JTF_NUMBER_TABLE();

Line 468: a5 := JTF_VARCHAR2_TABLE_100();

464: a1 := JTF_VARCHAR2_TABLE_200();
465: a2 := JTF_VARCHAR2_TABLE_200();
466: a3 := JTF_NUMBER_TABLE();
467: a4 := JTF_VARCHAR2_TABLE_2000();
468: a5 := JTF_VARCHAR2_TABLE_100();
469: a6 := JTF_VARCHAR2_TABLE_200();
470: a7 := JTF_VARCHAR2_TABLE_4000();
471: if t.count > 0 then
472: a0.extend(t.count);

Line 577: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

573: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
574: , p4_a5 out nocopy JTF_DATE_TABLE
575: , p4_a6 out nocopy JTF_DATE_TABLE
576: , p4_a7 out nocopy JTF_NUMBER_TABLE
577: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
578: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
579: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_300
580: , x_return_status out nocopy VARCHAR2
581: , x_msg_count out nocopy NUMBER

Line 578: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

574: , p4_a5 out nocopy JTF_DATE_TABLE
575: , p4_a6 out nocopy JTF_DATE_TABLE
576: , p4_a7 out nocopy JTF_NUMBER_TABLE
577: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
578: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
579: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_300
580: , x_return_status out nocopy VARCHAR2
581: , x_msg_count out nocopy NUMBER
582: , x_msg_data out nocopy VARCHAR2

Line 640: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

636: , p4_a1 out nocopy JTF_NUMBER_TABLE
637: , p4_a2 out nocopy JTF_NUMBER_TABLE
638: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
639: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
640: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
641: , p4_a6 out nocopy JTF_DATE_TABLE
642: , p4_a7 out nocopy JTF_DATE_TABLE
643: , p4_a8 out nocopy JTF_NUMBER_TABLE
644: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 644: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

640: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
641: , p4_a6 out nocopy JTF_DATE_TABLE
642: , p4_a7 out nocopy JTF_DATE_TABLE
643: , p4_a8 out nocopy JTF_NUMBER_TABLE
644: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
645: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
646: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
647: , x_return_status out nocopy VARCHAR2
648: , x_msg_count out nocopy NUMBER

Line 645: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100

641: , p4_a6 out nocopy JTF_DATE_TABLE
642: , p4_a7 out nocopy JTF_DATE_TABLE
643: , p4_a8 out nocopy JTF_NUMBER_TABLE
644: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
645: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
646: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
647: , x_return_status out nocopy VARCHAR2
648: , x_msg_count out nocopy NUMBER
649: , x_msg_data out nocopy VARCHAR2

Line 722: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_100

718: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
719: , p15_a5 out nocopy JTF_DATE_TABLE
720: , p15_a6 out nocopy JTF_DATE_TABLE
721: , p15_a7 out nocopy JTF_NUMBER_TABLE
722: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_100
723: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
724: , p15_a10 out nocopy JTF_VARCHAR2_TABLE_300
725: , x_return_status out nocopy VARCHAR2
726: , x_msg_count out nocopy NUMBER

Line 723: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100

719: , p15_a5 out nocopy JTF_DATE_TABLE
720: , p15_a6 out nocopy JTF_DATE_TABLE
721: , p15_a7 out nocopy JTF_NUMBER_TABLE
722: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_100
723: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
724: , p15_a10 out nocopy JTF_VARCHAR2_TABLE_300
725: , x_return_status out nocopy VARCHAR2
726: , x_msg_count out nocopy NUMBER
727: , x_msg_data out nocopy VARCHAR2

Line 833: , p15_a5 out nocopy JTF_VARCHAR2_TABLE_100

829: , p15_a1 out nocopy JTF_NUMBER_TABLE
830: , p15_a2 out nocopy JTF_NUMBER_TABLE
831: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_300
832: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
833: , p15_a5 out nocopy JTF_VARCHAR2_TABLE_100
834: , p15_a6 out nocopy JTF_DATE_TABLE
835: , p15_a7 out nocopy JTF_DATE_TABLE
836: , p15_a8 out nocopy JTF_NUMBER_TABLE
837: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 837: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100

833: , p15_a5 out nocopy JTF_VARCHAR2_TABLE_100
834: , p15_a6 out nocopy JTF_DATE_TABLE
835: , p15_a7 out nocopy JTF_DATE_TABLE
836: , p15_a8 out nocopy JTF_NUMBER_TABLE
837: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
838: , p15_a10 out nocopy JTF_VARCHAR2_TABLE_100
839: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_300
840: , x_return_status out nocopy VARCHAR2
841: , x_msg_count out nocopy NUMBER

Line 838: , p15_a10 out nocopy JTF_VARCHAR2_TABLE_100

834: , p15_a6 out nocopy JTF_DATE_TABLE
835: , p15_a7 out nocopy JTF_DATE_TABLE
836: , p15_a8 out nocopy JTF_NUMBER_TABLE
837: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
838: , p15_a10 out nocopy JTF_VARCHAR2_TABLE_100
839: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_300
840: , x_return_status out nocopy VARCHAR2
841: , x_msg_count out nocopy NUMBER
842: , x_msg_data out nocopy VARCHAR2

Line 938: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

934: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_200
935: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
936: , p4_a3 out nocopy JTF_NUMBER_TABLE
937: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
938: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
939: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_200
940: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_4000
941: , x_return_status out nocopy VARCHAR2
942: , x_msg_count out nocopy NUMBER