DBA Data[Home] [Help]

APPS.OKL_DSF_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 24: , a2 JTF_VARCHAR2_TABLE_200

20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_dsf_pvt.dsf_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_800
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE

Line 101: , a2 out nocopy JTF_VARCHAR2_TABLE_200

97: end if;
98: end rosetta_table_copy_in_p2;
99: procedure rosetta_table_copy_out_p2(t okl_dsf_pvt.dsf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_200
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_800
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_DATE_TABLE

Line 135: a2 := JTF_VARCHAR2_TABLE_200();

131: begin
132: if t is null or t.count = 0 then
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_NUMBER_TABLE();
135: a2 := JTF_VARCHAR2_TABLE_200();
136: a3 := JTF_VARCHAR2_TABLE_100();
137: a4 := JTF_VARCHAR2_TABLE_800();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_DATE_TABLE();

Line 166: a2 := JTF_VARCHAR2_TABLE_200();

162: a29 := JTF_NUMBER_TABLE();
163: else
164: a0 := JTF_NUMBER_TABLE();
165: a1 := JTF_NUMBER_TABLE();
166: a2 := JTF_VARCHAR2_TABLE_200();
167: a3 := JTF_VARCHAR2_TABLE_100();
168: a4 := JTF_VARCHAR2_TABLE_800();
169: a5 := JTF_NUMBER_TABLE();
170: a6 := JTF_DATE_TABLE();

Line 272: , a4 JTF_VARCHAR2_TABLE_2000

268: procedure rosetta_table_copy_in_p5(t out nocopy okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 JTF_NUMBER_TABLE
269: , a1 JTF_VARCHAR2_TABLE_100
270: , a2 JTF_VARCHAR2_TABLE_100
271: , a3 JTF_VARCHAR2_TABLE_100
272: , a4 JTF_VARCHAR2_TABLE_2000
273: , a5 JTF_NUMBER_TABLE
274: , a6 JTF_DATE_TABLE
275: , a7 JTF_NUMBER_TABLE
276: , a8 JTF_DATE_TABLE

Line 309: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

305: procedure rosetta_table_copy_out_p5(t okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 out nocopy JTF_NUMBER_TABLE
306: , a1 out nocopy JTF_VARCHAR2_TABLE_100
307: , a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , a3 out nocopy JTF_VARCHAR2_TABLE_100
309: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
310: , a5 out nocopy JTF_NUMBER_TABLE
311: , a6 out nocopy JTF_DATE_TABLE
312: , a7 out nocopy JTF_NUMBER_TABLE
313: , a8 out nocopy JTF_DATE_TABLE

Line 323: a4 := JTF_VARCHAR2_TABLE_2000();

319: a0 := JTF_NUMBER_TABLE();
320: a1 := JTF_VARCHAR2_TABLE_100();
321: a2 := JTF_VARCHAR2_TABLE_100();
322: a3 := JTF_VARCHAR2_TABLE_100();
323: a4 := JTF_VARCHAR2_TABLE_2000();
324: a5 := JTF_NUMBER_TABLE();
325: a6 := JTF_DATE_TABLE();
326: a7 := JTF_NUMBER_TABLE();
327: a8 := JTF_DATE_TABLE();

Line 334: a4 := JTF_VARCHAR2_TABLE_2000();

330: a0 := JTF_NUMBER_TABLE();
331: a1 := JTF_VARCHAR2_TABLE_100();
332: a2 := JTF_VARCHAR2_TABLE_100();
333: a3 := JTF_VARCHAR2_TABLE_100();
334: a4 := JTF_VARCHAR2_TABLE_2000();
335: a5 := JTF_NUMBER_TABLE();
336: a6 := JTF_DATE_TABLE();
337: a7 := JTF_NUMBER_TABLE();
338: a8 := JTF_DATE_TABLE();

Line 378: , a4 JTF_VARCHAR2_TABLE_200

374: procedure rosetta_table_copy_in_p8(t out nocopy okl_dsf_pvt.dsfv_tbl_type, a0 JTF_NUMBER_TABLE
375: , a1 JTF_NUMBER_TABLE
376: , a2 JTF_VARCHAR2_TABLE_100
377: , a3 JTF_VARCHAR2_TABLE_100
378: , a4 JTF_VARCHAR2_TABLE_200
379: , a5 JTF_VARCHAR2_TABLE_2000
380: , a6 JTF_VARCHAR2_TABLE_100
381: , a7 JTF_DATE_TABLE
382: , a8 JTF_DATE_TABLE

Line 379: , a5 JTF_VARCHAR2_TABLE_2000

375: , a1 JTF_NUMBER_TABLE
376: , a2 JTF_VARCHAR2_TABLE_100
377: , a3 JTF_VARCHAR2_TABLE_100
378: , a4 JTF_VARCHAR2_TABLE_200
379: , a5 JTF_VARCHAR2_TABLE_2000
380: , a6 JTF_VARCHAR2_TABLE_100
381: , a7 JTF_DATE_TABLE
382: , a8 JTF_DATE_TABLE
383: , a9 JTF_VARCHAR2_TABLE_800

Line 459: , a4 out nocopy JTF_VARCHAR2_TABLE_200

455: procedure rosetta_table_copy_out_p8(t okl_dsf_pvt.dsfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
456: , a1 out nocopy JTF_NUMBER_TABLE
457: , a2 out nocopy JTF_VARCHAR2_TABLE_100
458: , a3 out nocopy JTF_VARCHAR2_TABLE_100
459: , a4 out nocopy JTF_VARCHAR2_TABLE_200
460: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
461: , a6 out nocopy JTF_VARCHAR2_TABLE_100
462: , a7 out nocopy JTF_DATE_TABLE
463: , a8 out nocopy JTF_DATE_TABLE

Line 460: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

456: , a1 out nocopy JTF_NUMBER_TABLE
457: , a2 out nocopy JTF_VARCHAR2_TABLE_100
458: , a3 out nocopy JTF_VARCHAR2_TABLE_100
459: , a4 out nocopy JTF_VARCHAR2_TABLE_200
460: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
461: , a6 out nocopy JTF_VARCHAR2_TABLE_100
462: , a7 out nocopy JTF_DATE_TABLE
463: , a8 out nocopy JTF_DATE_TABLE
464: , a9 out nocopy JTF_VARCHAR2_TABLE_800

Line 495: a4 := JTF_VARCHAR2_TABLE_200();

491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: a2 := JTF_VARCHAR2_TABLE_100();
494: a3 := JTF_VARCHAR2_TABLE_100();
495: a4 := JTF_VARCHAR2_TABLE_200();
496: a5 := JTF_VARCHAR2_TABLE_2000();
497: a6 := JTF_VARCHAR2_TABLE_100();
498: a7 := JTF_DATE_TABLE();
499: a8 := JTF_DATE_TABLE();

Line 496: a5 := JTF_VARCHAR2_TABLE_2000();

492: a1 := JTF_NUMBER_TABLE();
493: a2 := JTF_VARCHAR2_TABLE_100();
494: a3 := JTF_VARCHAR2_TABLE_100();
495: a4 := JTF_VARCHAR2_TABLE_200();
496: a5 := JTF_VARCHAR2_TABLE_2000();
497: a6 := JTF_VARCHAR2_TABLE_100();
498: a7 := JTF_DATE_TABLE();
499: a8 := JTF_DATE_TABLE();
500: a9 := JTF_VARCHAR2_TABLE_800();

Line 528: a4 := JTF_VARCHAR2_TABLE_200();

524: a0 := JTF_NUMBER_TABLE();
525: a1 := JTF_NUMBER_TABLE();
526: a2 := JTF_VARCHAR2_TABLE_100();
527: a3 := JTF_VARCHAR2_TABLE_100();
528: a4 := JTF_VARCHAR2_TABLE_200();
529: a5 := JTF_VARCHAR2_TABLE_2000();
530: a6 := JTF_VARCHAR2_TABLE_100();
531: a7 := JTF_DATE_TABLE();
532: a8 := JTF_DATE_TABLE();

Line 529: a5 := JTF_VARCHAR2_TABLE_2000();

525: a1 := JTF_NUMBER_TABLE();
526: a2 := JTF_VARCHAR2_TABLE_100();
527: a3 := JTF_VARCHAR2_TABLE_100();
528: a4 := JTF_VARCHAR2_TABLE_200();
529: a5 := JTF_VARCHAR2_TABLE_2000();
530: a6 := JTF_VARCHAR2_TABLE_100();
531: a7 := JTF_DATE_TABLE();
532: a8 := JTF_DATE_TABLE();
533: a9 := JTF_VARCHAR2_TABLE_800();

Line 810: , p5_a4 JTF_VARCHAR2_TABLE_200

806: , p5_a0 JTF_NUMBER_TABLE
807: , p5_a1 JTF_NUMBER_TABLE
808: , p5_a2 JTF_VARCHAR2_TABLE_100
809: , p5_a3 JTF_VARCHAR2_TABLE_100
810: , p5_a4 JTF_VARCHAR2_TABLE_200
811: , p5_a5 JTF_VARCHAR2_TABLE_2000
812: , p5_a6 JTF_VARCHAR2_TABLE_100
813: , p5_a7 JTF_DATE_TABLE
814: , p5_a8 JTF_DATE_TABLE

Line 811: , p5_a5 JTF_VARCHAR2_TABLE_2000

807: , p5_a1 JTF_NUMBER_TABLE
808: , p5_a2 JTF_VARCHAR2_TABLE_100
809: , p5_a3 JTF_VARCHAR2_TABLE_100
810: , p5_a4 JTF_VARCHAR2_TABLE_200
811: , p5_a5 JTF_VARCHAR2_TABLE_2000
812: , p5_a6 JTF_VARCHAR2_TABLE_100
813: , p5_a7 JTF_DATE_TABLE
814: , p5_a8 JTF_DATE_TABLE
815: , p5_a9 JTF_VARCHAR2_TABLE_800

Line 842: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

838: , p6_a0 out nocopy JTF_NUMBER_TABLE
839: , p6_a1 out nocopy JTF_NUMBER_TABLE
840: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
841: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
842: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
843: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
844: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
845: , p6_a7 out nocopy JTF_DATE_TABLE
846: , p6_a8 out nocopy JTF_DATE_TABLE

Line 843: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

839: , p6_a1 out nocopy JTF_NUMBER_TABLE
840: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
841: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
842: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
843: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
844: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
845: , p6_a7 out nocopy JTF_DATE_TABLE
846: , p6_a8 out nocopy JTF_DATE_TABLE
847: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_800

Line 1078: , p5_a4 JTF_VARCHAR2_TABLE_200

1074: , p5_a0 JTF_NUMBER_TABLE
1075: , p5_a1 JTF_NUMBER_TABLE
1076: , p5_a2 JTF_VARCHAR2_TABLE_100
1077: , p5_a3 JTF_VARCHAR2_TABLE_100
1078: , p5_a4 JTF_VARCHAR2_TABLE_200
1079: , p5_a5 JTF_VARCHAR2_TABLE_2000
1080: , p5_a6 JTF_VARCHAR2_TABLE_100
1081: , p5_a7 JTF_DATE_TABLE
1082: , p5_a8 JTF_DATE_TABLE

Line 1079: , p5_a5 JTF_VARCHAR2_TABLE_2000

1075: , p5_a1 JTF_NUMBER_TABLE
1076: , p5_a2 JTF_VARCHAR2_TABLE_100
1077: , p5_a3 JTF_VARCHAR2_TABLE_100
1078: , p5_a4 JTF_VARCHAR2_TABLE_200
1079: , p5_a5 JTF_VARCHAR2_TABLE_2000
1080: , p5_a6 JTF_VARCHAR2_TABLE_100
1081: , p5_a7 JTF_DATE_TABLE
1082: , p5_a8 JTF_DATE_TABLE
1083: , p5_a9 JTF_VARCHAR2_TABLE_800

Line 1345: , p5_a4 JTF_VARCHAR2_TABLE_200

1341: , p5_a0 JTF_NUMBER_TABLE
1342: , p5_a1 JTF_NUMBER_TABLE
1343: , p5_a2 JTF_VARCHAR2_TABLE_100
1344: , p5_a3 JTF_VARCHAR2_TABLE_100
1345: , p5_a4 JTF_VARCHAR2_TABLE_200
1346: , p5_a5 JTF_VARCHAR2_TABLE_2000
1347: , p5_a6 JTF_VARCHAR2_TABLE_100
1348: , p5_a7 JTF_DATE_TABLE
1349: , p5_a8 JTF_DATE_TABLE

Line 1346: , p5_a5 JTF_VARCHAR2_TABLE_2000

1342: , p5_a1 JTF_NUMBER_TABLE
1343: , p5_a2 JTF_VARCHAR2_TABLE_100
1344: , p5_a3 JTF_VARCHAR2_TABLE_100
1345: , p5_a4 JTF_VARCHAR2_TABLE_200
1346: , p5_a5 JTF_VARCHAR2_TABLE_2000
1347: , p5_a6 JTF_VARCHAR2_TABLE_100
1348: , p5_a7 JTF_DATE_TABLE
1349: , p5_a8 JTF_DATE_TABLE
1350: , p5_a9 JTF_VARCHAR2_TABLE_800

Line 1377: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

1373: , p6_a0 out nocopy JTF_NUMBER_TABLE
1374: , p6_a1 out nocopy JTF_NUMBER_TABLE
1375: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1376: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1377: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1378: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1379: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1380: , p6_a7 out nocopy JTF_DATE_TABLE
1381: , p6_a8 out nocopy JTF_DATE_TABLE

Line 1378: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

1374: , p6_a1 out nocopy JTF_NUMBER_TABLE
1375: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1376: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1377: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1378: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1379: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1380: , p6_a7 out nocopy JTF_DATE_TABLE
1381: , p6_a8 out nocopy JTF_DATE_TABLE
1382: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_800

Line 1613: , p5_a4 JTF_VARCHAR2_TABLE_200

1609: , p5_a0 JTF_NUMBER_TABLE
1610: , p5_a1 JTF_NUMBER_TABLE
1611: , p5_a2 JTF_VARCHAR2_TABLE_100
1612: , p5_a3 JTF_VARCHAR2_TABLE_100
1613: , p5_a4 JTF_VARCHAR2_TABLE_200
1614: , p5_a5 JTF_VARCHAR2_TABLE_2000
1615: , p5_a6 JTF_VARCHAR2_TABLE_100
1616: , p5_a7 JTF_DATE_TABLE
1617: , p5_a8 JTF_DATE_TABLE

Line 1614: , p5_a5 JTF_VARCHAR2_TABLE_2000

1610: , p5_a1 JTF_NUMBER_TABLE
1611: , p5_a2 JTF_VARCHAR2_TABLE_100
1612: , p5_a3 JTF_VARCHAR2_TABLE_100
1613: , p5_a4 JTF_VARCHAR2_TABLE_200
1614: , p5_a5 JTF_VARCHAR2_TABLE_2000
1615: , p5_a6 JTF_VARCHAR2_TABLE_100
1616: , p5_a7 JTF_DATE_TABLE
1617: , p5_a8 JTF_DATE_TABLE
1618: , p5_a9 JTF_VARCHAR2_TABLE_800

Line 1812: , p5_a4 JTF_VARCHAR2_TABLE_200

1808: , p5_a0 JTF_NUMBER_TABLE
1809: , p5_a1 JTF_NUMBER_TABLE
1810: , p5_a2 JTF_VARCHAR2_TABLE_100
1811: , p5_a3 JTF_VARCHAR2_TABLE_100
1812: , p5_a4 JTF_VARCHAR2_TABLE_200
1813: , p5_a5 JTF_VARCHAR2_TABLE_2000
1814: , p5_a6 JTF_VARCHAR2_TABLE_100
1815: , p5_a7 JTF_DATE_TABLE
1816: , p5_a8 JTF_DATE_TABLE

Line 1813: , p5_a5 JTF_VARCHAR2_TABLE_2000

1809: , p5_a1 JTF_NUMBER_TABLE
1810: , p5_a2 JTF_VARCHAR2_TABLE_100
1811: , p5_a3 JTF_VARCHAR2_TABLE_100
1812: , p5_a4 JTF_VARCHAR2_TABLE_200
1813: , p5_a5 JTF_VARCHAR2_TABLE_2000
1814: , p5_a6 JTF_VARCHAR2_TABLE_100
1815: , p5_a7 JTF_DATE_TABLE
1816: , p5_a8 JTF_DATE_TABLE
1817: , p5_a9 JTF_VARCHAR2_TABLE_800