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_300

Line 44: procedure rosetta_table_copy_in_p19(t out nocopy okl_ec_uptake_pvt.okl_varchar2_table_type, a0 JTF_VARCHAR2_TABLE_300) as

40: end if;
41: end if;
42: end rosetta_table_copy_out_p18;
43:
44: procedure rosetta_table_copy_in_p19(t out nocopy okl_ec_uptake_pvt.okl_varchar2_table_type, a0 JTF_VARCHAR2_TABLE_300) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if a0 is not null and a0.count > 0 then
48: if a0.count > 0 then

Line 62: procedure rosetta_table_copy_out_p19(t okl_ec_uptake_pvt.okl_varchar2_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_300) as

58: end loop;
59: end if;
60: end if;
61: end rosetta_table_copy_in_p19;
62: procedure rosetta_table_copy_out_p19(t okl_ec_uptake_pvt.okl_varchar2_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_300) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_VARCHAR2_TABLE_300();

Line 66: a0 := JTF_VARCHAR2_TABLE_300();

62: procedure rosetta_table_copy_out_p19(t okl_ec_uptake_pvt.okl_varchar2_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_300) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_VARCHAR2_TABLE_300();
67: else
68: a0 := JTF_VARCHAR2_TABLE_300();
69: if t.count > 0 then
70: a0.extend(t.count);

Line 68: a0 := JTF_VARCHAR2_TABLE_300();

64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_VARCHAR2_TABLE_300();
67: else
68: a0 := JTF_VARCHAR2_TABLE_300();
69: if t.count > 0 then
70: a0.extend(t.count);
71: ddindx := t.first;
72: indx := 1;

Line 126: procedure rosetta_table_copy_in_p22(t out nocopy okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 JTF_VARCHAR2_TABLE_300

122: end if;
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

Line 147: procedure rosetta_table_copy_out_p22(t okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

143: end loop;
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

Line 153: a0 := JTF_VARCHAR2_TABLE_300();

149: ) as
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();

Line 156: a0 := JTF_VARCHAR2_TABLE_300();

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
159: a0.extend(t.count);
160: a1.extend(t.count);

Line 186: , a10 JTF_VARCHAR2_TABLE_300

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
190: if a0 is not null and a0.count > 0 then

Line 225: , a10 out nocopy JTF_VARCHAR2_TABLE_300

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
229: if t is null or t.count = 0 then

Line 240: a10 := JTF_VARCHAR2_TABLE_300();

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();
244: a2 := JTF_NUMBER_TABLE();

Line 252: a10 := JTF_VARCHAR2_TABLE_300();

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);
256: a2.extend(t.count);

Line 292: , a3 JTF_VARCHAR2_TABLE_300

288:
289: procedure rosetta_table_copy_in_p26(t out nocopy okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 300: , a11 JTF_VARCHAR2_TABLE_300

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
304: if a0 is not null and a0.count > 0 then

Line 333: , a3 out nocopy JTF_VARCHAR2_TABLE_300

329: end rosetta_table_copy_in_p26;
330: procedure rosetta_table_copy_out_p26(t okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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

Line 341: , a11 out nocopy JTF_VARCHAR2_TABLE_300

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
345: if t is null or t.count = 0 then

Line 349: a3 := JTF_VARCHAR2_TABLE_300();

345: if t is null or t.count = 0 then
346: a0 := JTF_NUMBER_TABLE();
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();

Line 357: a11 := JTF_VARCHAR2_TABLE_300();

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();
361: a2 := JTF_NUMBER_TABLE();

Line 362: a3 := JTF_VARCHAR2_TABLE_300();

358: else
359: a0 := JTF_NUMBER_TABLE();
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();

Line 370: a11 := JTF_VARCHAR2_TABLE_300();

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);
374: a2.extend(t.count);

Line 579: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_300

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
583: )

Line 638: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300

634: , p_target_type VARCHAR2
635: , p4_a0 out nocopy JTF_NUMBER_TABLE
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

Line 646: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300

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
650: )

Line 724: , p15_a10 out nocopy JTF_VARCHAR2_TABLE_300

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
728: )

Line 831: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_300

827: , p_item_categories_table JTF_NUMBER_TABLE
828: , p15_a0 out nocopy JTF_NUMBER_TABLE
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

Line 839: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_300

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
843: )