81: end if;
82: end if;
83: end rosetta_table_copy_out_p19;
84:
85: procedure rosetta_table_copy_in_p20(t out nocopy okl_ec_uptake_pvt.okl_date_tabe_type, a0 JTF_DATE_TABLE) as
86: ddindx binary_integer; indx binary_integer;
87: begin
88: if a0 is not null and a0.count > 0 then
89: if a0.count > 0 then
99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p20;
103: procedure rosetta_table_copy_out_p20(t okl_ec_uptake_pvt.okl_date_tabe_type, a0 out nocopy JTF_DATE_TABLE) as
104: ddindx binary_integer; indx binary_integer;
105: begin
106: if t is null or t.count = 0 then
107: a0 := JTF_DATE_TABLE();
103: procedure rosetta_table_copy_out_p20(t okl_ec_uptake_pvt.okl_date_tabe_type, a0 out nocopy JTF_DATE_TABLE) as
104: ddindx binary_integer; indx binary_integer;
105: begin
106: if t is null or t.count = 0 then
107: a0 := JTF_DATE_TABLE();
108: else
109: a0 := JTF_DATE_TABLE();
110: if t.count > 0 then
111: a0.extend(t.count);
105: begin
106: if t is null or t.count = 0 then
107: a0 := JTF_DATE_TABLE();
108: else
109: a0 := JTF_DATE_TABLE();
110: if t.count > 0 then
111: a0.extend(t.count);
112: ddindx := t.first;
113: indx := 1;
177: , a1 JTF_NUMBER_TABLE
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_VARCHAR2_TABLE_200
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
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_VARCHAR2_TABLE_200
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
216: , a1 out nocopy JTF_NUMBER_TABLE
217: , a2 out nocopy JTF_NUMBER_TABLE
218: , a3 out nocopy JTF_VARCHAR2_TABLE_200
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
217: , a2 out nocopy JTF_NUMBER_TABLE
218: , a3 out nocopy JTF_VARCHAR2_TABLE_200
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
231: a1 := JTF_NUMBER_TABLE();
232: a2 := JTF_NUMBER_TABLE();
233: a3 := JTF_VARCHAR2_TABLE_200();
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();
232: a2 := JTF_NUMBER_TABLE();
233: a3 := JTF_VARCHAR2_TABLE_200();
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();
243: a1 := JTF_NUMBER_TABLE();
244: a2 := JTF_NUMBER_TABLE();
245: a3 := JTF_VARCHAR2_TABLE_200();
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();
244: a2 := JTF_NUMBER_TABLE();
245: a3 := JTF_VARCHAR2_TABLE_200();
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();
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
299: , a10 JTF_VARCHAR2_TABLE_100
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
299: , a10 JTF_VARCHAR2_TABLE_100
300: , a11 JTF_VARCHAR2_TABLE_300
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
340: , a10 out nocopy JTF_VARCHAR2_TABLE_100
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
340: , a10 out nocopy JTF_VARCHAR2_TABLE_100
341: , a11 out nocopy JTF_VARCHAR2_TABLE_300
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();
356: a10 := JTF_VARCHAR2_TABLE_100();
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();
356: a10 := JTF_VARCHAR2_TABLE_100();
357: a11 := JTF_VARCHAR2_TABLE_300();
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();
369: a10 := JTF_VARCHAR2_TABLE_100();
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();
369: a10 := JTF_VARCHAR2_TABLE_100();
370: a11 := JTF_VARCHAR2_TABLE_300();
499: end rosetta_table_copy_out_p28;
500:
501: procedure rosetta_table_copy_in_p30(t out nocopy okl_ec_uptake_pvt.okl_vp_tbl_type, a0 JTF_NUMBER_TABLE
502: , a1 JTF_VARCHAR2_TABLE_200
503: , a2 JTF_DATE_TABLE
504: , a3 JTF_DATE_TABLE
505: ) as
506: ddindx binary_integer; indx binary_integer;
507: begin
500:
501: procedure rosetta_table_copy_in_p30(t out nocopy okl_ec_uptake_pvt.okl_vp_tbl_type, a0 JTF_NUMBER_TABLE
502: , a1 JTF_VARCHAR2_TABLE_200
503: , a2 JTF_DATE_TABLE
504: , a3 JTF_DATE_TABLE
505: ) as
506: ddindx binary_integer; indx binary_integer;
507: begin
508: if a0 is not null and a0.count > 0 then
524: end if;
525: end rosetta_table_copy_in_p30;
526: procedure rosetta_table_copy_out_p30(t okl_ec_uptake_pvt.okl_vp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
527: , a1 out nocopy JTF_VARCHAR2_TABLE_200
528: , a2 out nocopy JTF_DATE_TABLE
529: , a3 out nocopy JTF_DATE_TABLE
530: ) as
531: ddindx binary_integer; indx binary_integer;
532: begin
525: end rosetta_table_copy_in_p30;
526: procedure rosetta_table_copy_out_p30(t okl_ec_uptake_pvt.okl_vp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
527: , a1 out nocopy JTF_VARCHAR2_TABLE_200
528: , a2 out nocopy JTF_DATE_TABLE
529: , a3 out nocopy JTF_DATE_TABLE
530: ) as
531: ddindx binary_integer; indx binary_integer;
532: begin
533: if t is null or t.count = 0 then
532: begin
533: if t is null or t.count = 0 then
534: a0 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_200();
536: a2 := JTF_DATE_TABLE();
537: a3 := JTF_DATE_TABLE();
538: else
539: a0 := JTF_NUMBER_TABLE();
540: a1 := JTF_VARCHAR2_TABLE_200();
533: if t is null or t.count = 0 then
534: a0 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_200();
536: a2 := JTF_DATE_TABLE();
537: a3 := JTF_DATE_TABLE();
538: else
539: a0 := JTF_NUMBER_TABLE();
540: a1 := JTF_VARCHAR2_TABLE_200();
541: a2 := JTF_DATE_TABLE();
537: a3 := JTF_DATE_TABLE();
538: else
539: a0 := JTF_NUMBER_TABLE();
540: a1 := JTF_VARCHAR2_TABLE_200();
541: a2 := JTF_DATE_TABLE();
542: a3 := JTF_DATE_TABLE();
543: if t.count > 0 then
544: a0.extend(t.count);
545: a1.extend(t.count);
538: else
539: a0 := JTF_NUMBER_TABLE();
540: a1 := JTF_VARCHAR2_TABLE_200();
541: a2 := JTF_DATE_TABLE();
542: a3 := JTF_DATE_TABLE();
543: if t.count > 0 then
544: a0.extend(t.count);
545: a1.extend(t.count);
546: a2.extend(t.count);
570: , p4_a1 out nocopy JTF_NUMBER_TABLE
571: , p4_a2 out nocopy JTF_NUMBER_TABLE
572: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_200
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
571: , p4_a2 out nocopy JTF_NUMBER_TABLE
572: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_200
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
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
645: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
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
645: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
646: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
715: , p15_a1 out nocopy JTF_NUMBER_TABLE
716: , p15_a2 out nocopy JTF_NUMBER_TABLE
717: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_200
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
716: , p15_a2 out nocopy JTF_NUMBER_TABLE
717: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_200
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
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
838: , p15_a10 out nocopy JTF_VARCHAR2_TABLE_100
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
838: , p15_a10 out nocopy JTF_VARCHAR2_TABLE_100
839: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_300
1001: , p_item_table JTF_NUMBER_TABLE
1002: , p_item_categories_table JTF_NUMBER_TABLE
1003: , p14_a0 out nocopy JTF_NUMBER_TABLE
1004: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_200
1005: , p14_a2 out nocopy JTF_DATE_TABLE
1006: , p14_a3 out nocopy JTF_DATE_TABLE
1007: , x_return_status out nocopy VARCHAR2
1008: , x_msg_count out nocopy NUMBER
1009: , x_msg_data out nocopy VARCHAR2
1002: , p_item_categories_table JTF_NUMBER_TABLE
1003: , p14_a0 out nocopy JTF_NUMBER_TABLE
1004: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_200
1005: , p14_a2 out nocopy JTF_DATE_TABLE
1006: , p14_a3 out nocopy JTF_DATE_TABLE
1007: , x_return_status out nocopy VARCHAR2
1008: , x_msg_count out nocopy NUMBER
1009: , x_msg_data out nocopy VARCHAR2
1010: )