DBA Data[Home] [Help]

APPS.OKL_EC_UPTAKE_PVT_W dependencies on JTF_DATE_TABLE

Line 85: procedure rosetta_table_copy_in_p20(t out nocopy okl_ec_uptake_pvt.okl_date_tabe_type, a0 JTF_DATE_TABLE) as

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

Line 103: procedure rosetta_table_copy_out_p20(t okl_ec_uptake_pvt.okl_date_tabe_type, a0 out nocopy JTF_DATE_TABLE) as

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();

Line 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);

Line 109: a0 := JTF_DATE_TABLE();

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;

Line 181: , a5 JTF_DATE_TABLE

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

Line 182: , a6 JTF_DATE_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
186: , a10 JTF_VARCHAR2_TABLE_300

Line 220: , a5 out nocopy JTF_DATE_TABLE

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

Line 221: , a6 out nocopy JTF_DATE_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
225: , a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 235: a5 := JTF_DATE_TABLE();

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();

Line 236: a6 := JTF_DATE_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();
240: a10 := JTF_VARCHAR2_TABLE_300();

Line 247: a5 := JTF_DATE_TABLE();

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();

Line 248: a6 := JTF_DATE_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();
252: a10 := JTF_VARCHAR2_TABLE_300();

Line 295: , a6 JTF_DATE_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
299: , a10 JTF_VARCHAR2_TABLE_100

Line 296: , a7 JTF_DATE_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
300: , a11 JTF_VARCHAR2_TABLE_300

Line 336: , a6 out nocopy JTF_DATE_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
340: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 337: , a7 out nocopy JTF_DATE_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
341: , a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 352: a6 := JTF_DATE_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();
356: a10 := JTF_VARCHAR2_TABLE_100();

Line 353: a7 := JTF_DATE_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();
357: a11 := JTF_VARCHAR2_TABLE_300();

Line 365: a6 := JTF_DATE_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();
369: a10 := JTF_VARCHAR2_TABLE_100();

Line 366: a7 := JTF_DATE_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();
370: a11 := JTF_VARCHAR2_TABLE_300();

Line 503: , a2 JTF_DATE_TABLE

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

Line 504: , a3 JTF_DATE_TABLE

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

Line 528: , a2 out nocopy JTF_DATE_TABLE

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

Line 529: , a3 out nocopy JTF_DATE_TABLE

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

Line 536: a2 := JTF_DATE_TABLE();

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();

Line 537: a3 := JTF_DATE_TABLE();

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();

Line 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);

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

Line 574: , p4_a5 out nocopy JTF_DATE_TABLE

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

Line 575: , p4_a6 out nocopy JTF_DATE_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
579: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 641: , p4_a6 out nocopy JTF_DATE_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
645: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 642: , p4_a7 out nocopy JTF_DATE_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
646: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 719: , p15_a5 out nocopy JTF_DATE_TABLE

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

Line 720: , p15_a6 out nocopy JTF_DATE_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
724: , p15_a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 834: , p15_a6 out nocopy JTF_DATE_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
838: , p15_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 835: , p15_a7 out nocopy JTF_DATE_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
839: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 1005: , p14_a2 out nocopy JTF_DATE_TABLE

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

Line 1006: , p14_a3 out nocopy JTF_DATE_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
1010: )