DBA Data[Home] [Help]

APPS.OKL_ART_PVT_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 475: , a4 JTF_VARCHAR2_TABLE_2000

471: procedure rosetta_table_copy_in_p5(t out nocopy okl_art_pvt.okl_asset_returns_tl_tbl_type, a0 JTF_NUMBER_TABLE
472: , a1 JTF_VARCHAR2_TABLE_100
473: , a2 JTF_VARCHAR2_TABLE_100
474: , a3 JTF_VARCHAR2_TABLE_100
475: , a4 JTF_VARCHAR2_TABLE_2000
476: , a5 JTF_NUMBER_TABLE
477: , a6 JTF_DATE_TABLE
478: , a7 JTF_NUMBER_TABLE
479: , a8 JTF_DATE_TABLE

Line 481: , a10 JTF_VARCHAR2_TABLE_2000

477: , a6 JTF_DATE_TABLE
478: , a7 JTF_NUMBER_TABLE
479: , a8 JTF_DATE_TABLE
480: , a9 JTF_NUMBER_TABLE
481: , a10 JTF_VARCHAR2_TABLE_2000
482: ) as
483: ddindx binary_integer; indx binary_integer;
484: begin
485: if a0 is not null and a0.count > 0 then

Line 514: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

510: procedure rosetta_table_copy_out_p5(t okl_art_pvt.okl_asset_returns_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
511: , a1 out nocopy JTF_VARCHAR2_TABLE_100
512: , a2 out nocopy JTF_VARCHAR2_TABLE_100
513: , a3 out nocopy JTF_VARCHAR2_TABLE_100
514: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
515: , a5 out nocopy JTF_NUMBER_TABLE
516: , a6 out nocopy JTF_DATE_TABLE
517: , a7 out nocopy JTF_NUMBER_TABLE
518: , a8 out nocopy JTF_DATE_TABLE

Line 520: , a10 out nocopy JTF_VARCHAR2_TABLE_2000

516: , a6 out nocopy JTF_DATE_TABLE
517: , a7 out nocopy JTF_NUMBER_TABLE
518: , a8 out nocopy JTF_DATE_TABLE
519: , a9 out nocopy JTF_NUMBER_TABLE
520: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
521: ) as
522: ddindx binary_integer; indx binary_integer;
523: begin
524: if t is null or t.count = 0 then

Line 529: a4 := JTF_VARCHAR2_TABLE_2000();

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

Line 535: a10 := JTF_VARCHAR2_TABLE_2000();

531: a6 := JTF_DATE_TABLE();
532: a7 := JTF_NUMBER_TABLE();
533: a8 := JTF_DATE_TABLE();
534: a9 := JTF_NUMBER_TABLE();
535: a10 := JTF_VARCHAR2_TABLE_2000();
536: else
537: a0 := JTF_NUMBER_TABLE();
538: a1 := JTF_VARCHAR2_TABLE_100();
539: a2 := JTF_VARCHAR2_TABLE_100();

Line 541: a4 := JTF_VARCHAR2_TABLE_2000();

537: a0 := JTF_NUMBER_TABLE();
538: a1 := JTF_VARCHAR2_TABLE_100();
539: a2 := JTF_VARCHAR2_TABLE_100();
540: a3 := JTF_VARCHAR2_TABLE_100();
541: a4 := JTF_VARCHAR2_TABLE_2000();
542: a5 := JTF_NUMBER_TABLE();
543: a6 := JTF_DATE_TABLE();
544: a7 := JTF_NUMBER_TABLE();
545: a8 := JTF_DATE_TABLE();

Line 547: a10 := JTF_VARCHAR2_TABLE_2000();

543: a6 := JTF_DATE_TABLE();
544: a7 := JTF_NUMBER_TABLE();
545: a8 := JTF_DATE_TABLE();
546: a9 := JTF_NUMBER_TABLE();
547: a10 := JTF_VARCHAR2_TABLE_2000();
548: if t.count > 0 then
549: a0.extend(t.count);
550: a1.extend(t.count);
551: a2.extend(t.count);

Line 605: , a21 JTF_VARCHAR2_TABLE_2000

601: , a17 JTF_DATE_TABLE
602: , a18 JTF_DATE_TABLE
603: , a19 JTF_DATE_TABLE
604: , a20 JTF_VARCHAR2_TABLE_100
605: , a21 JTF_VARCHAR2_TABLE_2000
606: , a22 JTF_VARCHAR2_TABLE_100
607: , a23 JTF_VARCHAR2_TABLE_500
608: , a24 JTF_VARCHAR2_TABLE_500
609: , a25 JTF_VARCHAR2_TABLE_500

Line 636: , a52 JTF_VARCHAR2_TABLE_2000

632: , a48 JTF_NUMBER_TABLE
633: , a49 JTF_VARCHAR2_TABLE_100
634: , a50 JTF_NUMBER_TABLE
635: , a51 JTF_VARCHAR2_TABLE_100
636: , a52 JTF_VARCHAR2_TABLE_2000
637: , a53 JTF_VARCHAR2_TABLE_100
638: , a54 JTF_VARCHAR2_TABLE_100
639: , a55 JTF_VARCHAR2_TABLE_100
640: , a56 JTF_VARCHAR2_TABLE_100

Line 746: , a21 out nocopy JTF_VARCHAR2_TABLE_2000

742: , a17 out nocopy JTF_DATE_TABLE
743: , a18 out nocopy JTF_DATE_TABLE
744: , a19 out nocopy JTF_DATE_TABLE
745: , a20 out nocopy JTF_VARCHAR2_TABLE_100
746: , a21 out nocopy JTF_VARCHAR2_TABLE_2000
747: , a22 out nocopy JTF_VARCHAR2_TABLE_100
748: , a23 out nocopy JTF_VARCHAR2_TABLE_500
749: , a24 out nocopy JTF_VARCHAR2_TABLE_500
750: , a25 out nocopy JTF_VARCHAR2_TABLE_500

Line 777: , a52 out nocopy JTF_VARCHAR2_TABLE_2000

773: , a48 out nocopy JTF_NUMBER_TABLE
774: , a49 out nocopy JTF_VARCHAR2_TABLE_100
775: , a50 out nocopy JTF_NUMBER_TABLE
776: , a51 out nocopy JTF_VARCHAR2_TABLE_100
777: , a52 out nocopy JTF_VARCHAR2_TABLE_2000
778: , a53 out nocopy JTF_VARCHAR2_TABLE_100
779: , a54 out nocopy JTF_VARCHAR2_TABLE_100
780: , a55 out nocopy JTF_VARCHAR2_TABLE_100
781: , a56 out nocopy JTF_VARCHAR2_TABLE_100

Line 812: a21 := JTF_VARCHAR2_TABLE_2000();

808: a17 := JTF_DATE_TABLE();
809: a18 := JTF_DATE_TABLE();
810: a19 := JTF_DATE_TABLE();
811: a20 := JTF_VARCHAR2_TABLE_100();
812: a21 := JTF_VARCHAR2_TABLE_2000();
813: a22 := JTF_VARCHAR2_TABLE_100();
814: a23 := JTF_VARCHAR2_TABLE_500();
815: a24 := JTF_VARCHAR2_TABLE_500();
816: a25 := JTF_VARCHAR2_TABLE_500();

Line 843: a52 := JTF_VARCHAR2_TABLE_2000();

839: a48 := JTF_NUMBER_TABLE();
840: a49 := JTF_VARCHAR2_TABLE_100();
841: a50 := JTF_NUMBER_TABLE();
842: a51 := JTF_VARCHAR2_TABLE_100();
843: a52 := JTF_VARCHAR2_TABLE_2000();
844: a53 := JTF_VARCHAR2_TABLE_100();
845: a54 := JTF_VARCHAR2_TABLE_100();
846: a55 := JTF_VARCHAR2_TABLE_100();
847: a56 := JTF_VARCHAR2_TABLE_100();

Line 875: a21 := JTF_VARCHAR2_TABLE_2000();

871: a17 := JTF_DATE_TABLE();
872: a18 := JTF_DATE_TABLE();
873: a19 := JTF_DATE_TABLE();
874: a20 := JTF_VARCHAR2_TABLE_100();
875: a21 := JTF_VARCHAR2_TABLE_2000();
876: a22 := JTF_VARCHAR2_TABLE_100();
877: a23 := JTF_VARCHAR2_TABLE_500();
878: a24 := JTF_VARCHAR2_TABLE_500();
879: a25 := JTF_VARCHAR2_TABLE_500();

Line 906: a52 := JTF_VARCHAR2_TABLE_2000();

902: a48 := JTF_NUMBER_TABLE();
903: a49 := JTF_VARCHAR2_TABLE_100();
904: a50 := JTF_NUMBER_TABLE();
905: a51 := JTF_VARCHAR2_TABLE_100();
906: a52 := JTF_VARCHAR2_TABLE_2000();
907: a53 := JTF_VARCHAR2_TABLE_100();
908: a54 := JTF_VARCHAR2_TABLE_100();
909: a55 := JTF_VARCHAR2_TABLE_100();
910: a56 := JTF_VARCHAR2_TABLE_100();

Line 1367: , p5_a21 JTF_VARCHAR2_TABLE_2000

1363: , p5_a17 JTF_DATE_TABLE
1364: , p5_a18 JTF_DATE_TABLE
1365: , p5_a19 JTF_DATE_TABLE
1366: , p5_a20 JTF_VARCHAR2_TABLE_100
1367: , p5_a21 JTF_VARCHAR2_TABLE_2000
1368: , p5_a22 JTF_VARCHAR2_TABLE_100
1369: , p5_a23 JTF_VARCHAR2_TABLE_500
1370: , p5_a24 JTF_VARCHAR2_TABLE_500
1371: , p5_a25 JTF_VARCHAR2_TABLE_500

Line 1398: , p5_a52 JTF_VARCHAR2_TABLE_2000

1394: , p5_a48 JTF_NUMBER_TABLE
1395: , p5_a49 JTF_VARCHAR2_TABLE_100
1396: , p5_a50 JTF_NUMBER_TABLE
1397: , p5_a51 JTF_VARCHAR2_TABLE_100
1398: , p5_a52 JTF_VARCHAR2_TABLE_2000
1399: , p5_a53 JTF_VARCHAR2_TABLE_100
1400: , p5_a54 JTF_VARCHAR2_TABLE_100
1401: , p5_a55 JTF_VARCHAR2_TABLE_100
1402: , p5_a56 JTF_VARCHAR2_TABLE_100

Line 1429: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_2000

1425: , p6_a17 out nocopy JTF_DATE_TABLE
1426: , p6_a18 out nocopy JTF_DATE_TABLE
1427: , p6_a19 out nocopy JTF_DATE_TABLE
1428: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1429: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_2000
1430: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1431: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1432: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1433: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500

Line 1460: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000

1456: , p6_a48 out nocopy JTF_NUMBER_TABLE
1457: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
1458: , p6_a50 out nocopy JTF_NUMBER_TABLE
1459: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_100
1460: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
1461: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
1462: , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
1463: , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
1464: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100

Line 1815: , p5_a21 JTF_VARCHAR2_TABLE_2000

1811: , p5_a17 JTF_DATE_TABLE
1812: , p5_a18 JTF_DATE_TABLE
1813: , p5_a19 JTF_DATE_TABLE
1814: , p5_a20 JTF_VARCHAR2_TABLE_100
1815: , p5_a21 JTF_VARCHAR2_TABLE_2000
1816: , p5_a22 JTF_VARCHAR2_TABLE_100
1817: , p5_a23 JTF_VARCHAR2_TABLE_500
1818: , p5_a24 JTF_VARCHAR2_TABLE_500
1819: , p5_a25 JTF_VARCHAR2_TABLE_500

Line 1846: , p5_a52 JTF_VARCHAR2_TABLE_2000

1842: , p5_a48 JTF_NUMBER_TABLE
1843: , p5_a49 JTF_VARCHAR2_TABLE_100
1844: , p5_a50 JTF_NUMBER_TABLE
1845: , p5_a51 JTF_VARCHAR2_TABLE_100
1846: , p5_a52 JTF_VARCHAR2_TABLE_2000
1847: , p5_a53 JTF_VARCHAR2_TABLE_100
1848: , p5_a54 JTF_VARCHAR2_TABLE_100
1849: , p5_a55 JTF_VARCHAR2_TABLE_100
1850: , p5_a56 JTF_VARCHAR2_TABLE_100

Line 2262: , p5_a21 JTF_VARCHAR2_TABLE_2000

2258: , p5_a17 JTF_DATE_TABLE
2259: , p5_a18 JTF_DATE_TABLE
2260: , p5_a19 JTF_DATE_TABLE
2261: , p5_a20 JTF_VARCHAR2_TABLE_100
2262: , p5_a21 JTF_VARCHAR2_TABLE_2000
2263: , p5_a22 JTF_VARCHAR2_TABLE_100
2264: , p5_a23 JTF_VARCHAR2_TABLE_500
2265: , p5_a24 JTF_VARCHAR2_TABLE_500
2266: , p5_a25 JTF_VARCHAR2_TABLE_500

Line 2293: , p5_a52 JTF_VARCHAR2_TABLE_2000

2289: , p5_a48 JTF_NUMBER_TABLE
2290: , p5_a49 JTF_VARCHAR2_TABLE_100
2291: , p5_a50 JTF_NUMBER_TABLE
2292: , p5_a51 JTF_VARCHAR2_TABLE_100
2293: , p5_a52 JTF_VARCHAR2_TABLE_2000
2294: , p5_a53 JTF_VARCHAR2_TABLE_100
2295: , p5_a54 JTF_VARCHAR2_TABLE_100
2296: , p5_a55 JTF_VARCHAR2_TABLE_100
2297: , p5_a56 JTF_VARCHAR2_TABLE_100

Line 2324: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_2000

2320: , p6_a17 out nocopy JTF_DATE_TABLE
2321: , p6_a18 out nocopy JTF_DATE_TABLE
2322: , p6_a19 out nocopy JTF_DATE_TABLE
2323: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2324: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_2000
2325: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
2326: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
2327: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
2328: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500

Line 2355: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000

2351: , p6_a48 out nocopy JTF_NUMBER_TABLE
2352: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
2353: , p6_a50 out nocopy JTF_NUMBER_TABLE
2354: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_100
2355: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
2356: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
2357: , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
2358: , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
2359: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100

Line 2710: , p5_a21 JTF_VARCHAR2_TABLE_2000

2706: , p5_a17 JTF_DATE_TABLE
2707: , p5_a18 JTF_DATE_TABLE
2708: , p5_a19 JTF_DATE_TABLE
2709: , p5_a20 JTF_VARCHAR2_TABLE_100
2710: , p5_a21 JTF_VARCHAR2_TABLE_2000
2711: , p5_a22 JTF_VARCHAR2_TABLE_100
2712: , p5_a23 JTF_VARCHAR2_TABLE_500
2713: , p5_a24 JTF_VARCHAR2_TABLE_500
2714: , p5_a25 JTF_VARCHAR2_TABLE_500

Line 2741: , p5_a52 JTF_VARCHAR2_TABLE_2000

2737: , p5_a48 JTF_NUMBER_TABLE
2738: , p5_a49 JTF_VARCHAR2_TABLE_100
2739: , p5_a50 JTF_NUMBER_TABLE
2740: , p5_a51 JTF_VARCHAR2_TABLE_100
2741: , p5_a52 JTF_VARCHAR2_TABLE_2000
2742: , p5_a53 JTF_VARCHAR2_TABLE_100
2743: , p5_a54 JTF_VARCHAR2_TABLE_100
2744: , p5_a55 JTF_VARCHAR2_TABLE_100
2745: , p5_a56 JTF_VARCHAR2_TABLE_100

Line 3029: , p5_a21 JTF_VARCHAR2_TABLE_2000

3025: , p5_a17 JTF_DATE_TABLE
3026: , p5_a18 JTF_DATE_TABLE
3027: , p5_a19 JTF_DATE_TABLE
3028: , p5_a20 JTF_VARCHAR2_TABLE_100
3029: , p5_a21 JTF_VARCHAR2_TABLE_2000
3030: , p5_a22 JTF_VARCHAR2_TABLE_100
3031: , p5_a23 JTF_VARCHAR2_TABLE_500
3032: , p5_a24 JTF_VARCHAR2_TABLE_500
3033: , p5_a25 JTF_VARCHAR2_TABLE_500

Line 3060: , p5_a52 JTF_VARCHAR2_TABLE_2000

3056: , p5_a48 JTF_NUMBER_TABLE
3057: , p5_a49 JTF_VARCHAR2_TABLE_100
3058: , p5_a50 JTF_NUMBER_TABLE
3059: , p5_a51 JTF_VARCHAR2_TABLE_100
3060: , p5_a52 JTF_VARCHAR2_TABLE_2000
3061: , p5_a53 JTF_VARCHAR2_TABLE_100
3062: , p5_a54 JTF_VARCHAR2_TABLE_100
3063: , p5_a55 JTF_VARCHAR2_TABLE_100
3064: , p5_a56 JTF_VARCHAR2_TABLE_100