DBA Data[Home] [Help]

APPS.OKL_BTC_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 345: , a4 JTF_VARCHAR2_TABLE_200

341: procedure rosetta_table_copy_in_p5(t out nocopy okl_btc_pvt.okl_trx_csh_batch_tl_tbl_type, a0 JTF_NUMBER_TABLE
342: , a1 JTF_VARCHAR2_TABLE_100
343: , a2 JTF_VARCHAR2_TABLE_100
344: , a3 JTF_VARCHAR2_TABLE_100
345: , a4 JTF_VARCHAR2_TABLE_200
346: , a5 JTF_VARCHAR2_TABLE_2000
347: , a6 JTF_NUMBER_TABLE
348: , a7 JTF_DATE_TABLE
349: , a8 JTF_NUMBER_TABLE

Line 346: , a5 JTF_VARCHAR2_TABLE_2000

342: , a1 JTF_VARCHAR2_TABLE_100
343: , a2 JTF_VARCHAR2_TABLE_100
344: , a3 JTF_VARCHAR2_TABLE_100
345: , a4 JTF_VARCHAR2_TABLE_200
346: , a5 JTF_VARCHAR2_TABLE_2000
347: , a6 JTF_NUMBER_TABLE
348: , a7 JTF_DATE_TABLE
349: , a8 JTF_NUMBER_TABLE
350: , a9 JTF_DATE_TABLE

Line 384: , a4 out nocopy JTF_VARCHAR2_TABLE_200

380: procedure rosetta_table_copy_out_p5(t okl_btc_pvt.okl_trx_csh_batch_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
381: , a1 out nocopy JTF_VARCHAR2_TABLE_100
382: , a2 out nocopy JTF_VARCHAR2_TABLE_100
383: , a3 out nocopy JTF_VARCHAR2_TABLE_100
384: , a4 out nocopy JTF_VARCHAR2_TABLE_200
385: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
386: , a6 out nocopy JTF_NUMBER_TABLE
387: , a7 out nocopy JTF_DATE_TABLE
388: , a8 out nocopy JTF_NUMBER_TABLE

Line 385: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

381: , a1 out nocopy JTF_VARCHAR2_TABLE_100
382: , a2 out nocopy JTF_VARCHAR2_TABLE_100
383: , a3 out nocopy JTF_VARCHAR2_TABLE_100
384: , a4 out nocopy JTF_VARCHAR2_TABLE_200
385: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
386: , a6 out nocopy JTF_NUMBER_TABLE
387: , a7 out nocopy JTF_DATE_TABLE
388: , a8 out nocopy JTF_NUMBER_TABLE
389: , a9 out nocopy JTF_DATE_TABLE

Line 399: a4 := JTF_VARCHAR2_TABLE_200();

395: a0 := JTF_NUMBER_TABLE();
396: a1 := JTF_VARCHAR2_TABLE_100();
397: a2 := JTF_VARCHAR2_TABLE_100();
398: a3 := JTF_VARCHAR2_TABLE_100();
399: a4 := JTF_VARCHAR2_TABLE_200();
400: a5 := JTF_VARCHAR2_TABLE_2000();
401: a6 := JTF_NUMBER_TABLE();
402: a7 := JTF_DATE_TABLE();
403: a8 := JTF_NUMBER_TABLE();

Line 400: a5 := JTF_VARCHAR2_TABLE_2000();

396: a1 := JTF_VARCHAR2_TABLE_100();
397: a2 := JTF_VARCHAR2_TABLE_100();
398: a3 := JTF_VARCHAR2_TABLE_100();
399: a4 := JTF_VARCHAR2_TABLE_200();
400: a5 := JTF_VARCHAR2_TABLE_2000();
401: a6 := JTF_NUMBER_TABLE();
402: a7 := JTF_DATE_TABLE();
403: a8 := JTF_NUMBER_TABLE();
404: a9 := JTF_DATE_TABLE();

Line 411: a4 := JTF_VARCHAR2_TABLE_200();

407: a0 := JTF_NUMBER_TABLE();
408: a1 := JTF_VARCHAR2_TABLE_100();
409: a2 := JTF_VARCHAR2_TABLE_100();
410: a3 := JTF_VARCHAR2_TABLE_100();
411: a4 := JTF_VARCHAR2_TABLE_200();
412: a5 := JTF_VARCHAR2_TABLE_2000();
413: a6 := JTF_NUMBER_TABLE();
414: a7 := JTF_DATE_TABLE();
415: a8 := JTF_NUMBER_TABLE();

Line 412: a5 := JTF_VARCHAR2_TABLE_2000();

408: a1 := JTF_VARCHAR2_TABLE_100();
409: a2 := JTF_VARCHAR2_TABLE_100();
410: a3 := JTF_VARCHAR2_TABLE_100();
411: a4 := JTF_VARCHAR2_TABLE_200();
412: a5 := JTF_VARCHAR2_TABLE_2000();
413: a6 := JTF_NUMBER_TABLE();
414: a7 := JTF_DATE_TABLE();
415: a8 := JTF_NUMBER_TABLE();
416: a9 := JTF_DATE_TABLE();

Line 457: , a3 JTF_VARCHAR2_TABLE_200

453:
454: procedure rosetta_table_copy_in_p8(t out nocopy okl_btc_pvt.btcv_tbl_type, a0 JTF_NUMBER_TABLE
455: , a1 JTF_NUMBER_TABLE
456: , a2 JTF_VARCHAR2_TABLE_100
457: , a3 JTF_VARCHAR2_TABLE_200
458: , a4 JTF_DATE_TABLE
459: , a5 JTF_DATE_TABLE
460: , a6 JTF_DATE_TABLE
461: , a7 JTF_NUMBER_TABLE

Line 465: , a11 JTF_VARCHAR2_TABLE_2000

461: , a7 JTF_NUMBER_TABLE
462: , a8 JTF_NUMBER_TABLE
463: , a9 JTF_VARCHAR2_TABLE_100
464: , a10 JTF_NUMBER_TABLE
465: , a11 JTF_VARCHAR2_TABLE_2000
466: , a12 JTF_VARCHAR2_TABLE_100
467: , a13 JTF_VARCHAR2_TABLE_500
468: , a14 JTF_VARCHAR2_TABLE_500
469: , a15 JTF_VARCHAR2_TABLE_500

Line 560: , a3 out nocopy JTF_VARCHAR2_TABLE_200

556: end rosetta_table_copy_in_p8;
557: procedure rosetta_table_copy_out_p8(t okl_btc_pvt.btcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
558: , a1 out nocopy JTF_NUMBER_TABLE
559: , a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , a3 out nocopy JTF_VARCHAR2_TABLE_200
561: , a4 out nocopy JTF_DATE_TABLE
562: , a5 out nocopy JTF_DATE_TABLE
563: , a6 out nocopy JTF_DATE_TABLE
564: , a7 out nocopy JTF_NUMBER_TABLE

Line 568: , a11 out nocopy JTF_VARCHAR2_TABLE_2000

564: , a7 out nocopy JTF_NUMBER_TABLE
565: , a8 out nocopy JTF_NUMBER_TABLE
566: , a9 out nocopy JTF_VARCHAR2_TABLE_100
567: , a10 out nocopy JTF_NUMBER_TABLE
568: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
569: , a12 out nocopy JTF_VARCHAR2_TABLE_100
570: , a13 out nocopy JTF_VARCHAR2_TABLE_500
571: , a14 out nocopy JTF_VARCHAR2_TABLE_500
572: , a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 607: a3 := JTF_VARCHAR2_TABLE_200();

603: if t is null or t.count = 0 then
604: a0 := JTF_NUMBER_TABLE();
605: a1 := JTF_NUMBER_TABLE();
606: a2 := JTF_VARCHAR2_TABLE_100();
607: a3 := JTF_VARCHAR2_TABLE_200();
608: a4 := JTF_DATE_TABLE();
609: a5 := JTF_DATE_TABLE();
610: a6 := JTF_DATE_TABLE();
611: a7 := JTF_NUMBER_TABLE();

Line 615: a11 := JTF_VARCHAR2_TABLE_2000();

611: a7 := JTF_NUMBER_TABLE();
612: a8 := JTF_NUMBER_TABLE();
613: a9 := JTF_VARCHAR2_TABLE_100();
614: a10 := JTF_NUMBER_TABLE();
615: a11 := JTF_VARCHAR2_TABLE_2000();
616: a12 := JTF_VARCHAR2_TABLE_100();
617: a13 := JTF_VARCHAR2_TABLE_500();
618: a14 := JTF_VARCHAR2_TABLE_500();
619: a15 := JTF_VARCHAR2_TABLE_500();

Line 651: a3 := JTF_VARCHAR2_TABLE_200();

647: else
648: a0 := JTF_NUMBER_TABLE();
649: a1 := JTF_NUMBER_TABLE();
650: a2 := JTF_VARCHAR2_TABLE_100();
651: a3 := JTF_VARCHAR2_TABLE_200();
652: a4 := JTF_DATE_TABLE();
653: a5 := JTF_DATE_TABLE();
654: a6 := JTF_DATE_TABLE();
655: a7 := JTF_NUMBER_TABLE();

Line 659: a11 := JTF_VARCHAR2_TABLE_2000();

655: a7 := JTF_NUMBER_TABLE();
656: a8 := JTF_NUMBER_TABLE();
657: a9 := JTF_VARCHAR2_TABLE_100();
658: a10 := JTF_NUMBER_TABLE();
659: a11 := JTF_VARCHAR2_TABLE_2000();
660: a12 := JTF_VARCHAR2_TABLE_100();
661: a13 := JTF_VARCHAR2_TABLE_500();
662: a14 := JTF_VARCHAR2_TABLE_500();
663: a15 := JTF_VARCHAR2_TABLE_500();

Line 1010: , p5_a3 JTF_VARCHAR2_TABLE_200

1006: , x_msg_data out nocopy VARCHAR2
1007: , p5_a0 JTF_NUMBER_TABLE
1008: , p5_a1 JTF_NUMBER_TABLE
1009: , p5_a2 JTF_VARCHAR2_TABLE_100
1010: , p5_a3 JTF_VARCHAR2_TABLE_200
1011: , p5_a4 JTF_DATE_TABLE
1012: , p5_a5 JTF_DATE_TABLE
1013: , p5_a6 JTF_DATE_TABLE
1014: , p5_a7 JTF_NUMBER_TABLE

Line 1018: , p5_a11 JTF_VARCHAR2_TABLE_2000

1014: , p5_a7 JTF_NUMBER_TABLE
1015: , p5_a8 JTF_NUMBER_TABLE
1016: , p5_a9 JTF_VARCHAR2_TABLE_100
1017: , p5_a10 JTF_NUMBER_TABLE
1018: , p5_a11 JTF_VARCHAR2_TABLE_2000
1019: , p5_a12 JTF_VARCHAR2_TABLE_100
1020: , p5_a13 JTF_VARCHAR2_TABLE_500
1021: , p5_a14 JTF_VARCHAR2_TABLE_500
1022: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 1053: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

1049: , p5_a42 JTF_NUMBER_TABLE
1050: , p6_a0 out nocopy JTF_NUMBER_TABLE
1051: , p6_a1 out nocopy JTF_NUMBER_TABLE
1052: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1054: , p6_a4 out nocopy JTF_DATE_TABLE
1055: , p6_a5 out nocopy JTF_DATE_TABLE
1056: , p6_a6 out nocopy JTF_DATE_TABLE
1057: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 1061: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000

1057: , p6_a7 out nocopy JTF_NUMBER_TABLE
1058: , p6_a8 out nocopy JTF_NUMBER_TABLE
1059: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1060: , p6_a10 out nocopy JTF_NUMBER_TABLE
1061: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
1062: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1063: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1064: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1065: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 1344: , p5_a3 JTF_VARCHAR2_TABLE_200

1340: , x_msg_data out nocopy VARCHAR2
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_200
1345: , p5_a4 JTF_DATE_TABLE
1346: , p5_a5 JTF_DATE_TABLE
1347: , p5_a6 JTF_DATE_TABLE
1348: , p5_a7 JTF_NUMBER_TABLE

Line 1352: , p5_a11 JTF_VARCHAR2_TABLE_2000

1348: , p5_a7 JTF_NUMBER_TABLE
1349: , p5_a8 JTF_NUMBER_TABLE
1350: , p5_a9 JTF_VARCHAR2_TABLE_100
1351: , p5_a10 JTF_NUMBER_TABLE
1352: , p5_a11 JTF_VARCHAR2_TABLE_2000
1353: , p5_a12 JTF_VARCHAR2_TABLE_100
1354: , p5_a13 JTF_VARCHAR2_TABLE_500
1355: , p5_a14 JTF_VARCHAR2_TABLE_500
1356: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 1677: , p5_a3 JTF_VARCHAR2_TABLE_200

1673: , x_msg_data out nocopy VARCHAR2
1674: , p5_a0 JTF_NUMBER_TABLE
1675: , p5_a1 JTF_NUMBER_TABLE
1676: , p5_a2 JTF_VARCHAR2_TABLE_100
1677: , p5_a3 JTF_VARCHAR2_TABLE_200
1678: , p5_a4 JTF_DATE_TABLE
1679: , p5_a5 JTF_DATE_TABLE
1680: , p5_a6 JTF_DATE_TABLE
1681: , p5_a7 JTF_NUMBER_TABLE

Line 1685: , p5_a11 JTF_VARCHAR2_TABLE_2000

1681: , p5_a7 JTF_NUMBER_TABLE
1682: , p5_a8 JTF_NUMBER_TABLE
1683: , p5_a9 JTF_VARCHAR2_TABLE_100
1684: , p5_a10 JTF_NUMBER_TABLE
1685: , p5_a11 JTF_VARCHAR2_TABLE_2000
1686: , p5_a12 JTF_VARCHAR2_TABLE_100
1687: , p5_a13 JTF_VARCHAR2_TABLE_500
1688: , p5_a14 JTF_VARCHAR2_TABLE_500
1689: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 1720: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

1716: , p5_a42 JTF_NUMBER_TABLE
1717: , p6_a0 out nocopy JTF_NUMBER_TABLE
1718: , p6_a1 out nocopy JTF_NUMBER_TABLE
1719: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1720: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1721: , p6_a4 out nocopy JTF_DATE_TABLE
1722: , p6_a5 out nocopy JTF_DATE_TABLE
1723: , p6_a6 out nocopy JTF_DATE_TABLE
1724: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 1728: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000

1724: , p6_a7 out nocopy JTF_NUMBER_TABLE
1725: , p6_a8 out nocopy JTF_NUMBER_TABLE
1726: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1727: , p6_a10 out nocopy JTF_NUMBER_TABLE
1728: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
1729: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1730: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1731: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1732: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 2011: , p5_a3 JTF_VARCHAR2_TABLE_200

2007: , x_msg_data out nocopy VARCHAR2
2008: , p5_a0 JTF_NUMBER_TABLE
2009: , p5_a1 JTF_NUMBER_TABLE
2010: , p5_a2 JTF_VARCHAR2_TABLE_100
2011: , p5_a3 JTF_VARCHAR2_TABLE_200
2012: , p5_a4 JTF_DATE_TABLE
2013: , p5_a5 JTF_DATE_TABLE
2014: , p5_a6 JTF_DATE_TABLE
2015: , p5_a7 JTF_NUMBER_TABLE

Line 2019: , p5_a11 JTF_VARCHAR2_TABLE_2000

2015: , p5_a7 JTF_NUMBER_TABLE
2016: , p5_a8 JTF_NUMBER_TABLE
2017: , p5_a9 JTF_VARCHAR2_TABLE_100
2018: , p5_a10 JTF_NUMBER_TABLE
2019: , p5_a11 JTF_VARCHAR2_TABLE_2000
2020: , p5_a12 JTF_VARCHAR2_TABLE_100
2021: , p5_a13 JTF_VARCHAR2_TABLE_500
2022: , p5_a14 JTF_VARCHAR2_TABLE_500
2023: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 2254: , p5_a3 JTF_VARCHAR2_TABLE_200

2250: , x_msg_data out nocopy VARCHAR2
2251: , p5_a0 JTF_NUMBER_TABLE
2252: , p5_a1 JTF_NUMBER_TABLE
2253: , p5_a2 JTF_VARCHAR2_TABLE_100
2254: , p5_a3 JTF_VARCHAR2_TABLE_200
2255: , p5_a4 JTF_DATE_TABLE
2256: , p5_a5 JTF_DATE_TABLE
2257: , p5_a6 JTF_DATE_TABLE
2258: , p5_a7 JTF_NUMBER_TABLE

Line 2262: , p5_a11 JTF_VARCHAR2_TABLE_2000

2258: , p5_a7 JTF_NUMBER_TABLE
2259: , p5_a8 JTF_NUMBER_TABLE
2260: , p5_a9 JTF_VARCHAR2_TABLE_100
2261: , p5_a10 JTF_NUMBER_TABLE
2262: , p5_a11 JTF_VARCHAR2_TABLE_2000
2263: , p5_a12 JTF_VARCHAR2_TABLE_100
2264: , p5_a13 JTF_VARCHAR2_TABLE_500
2265: , p5_a14 JTF_VARCHAR2_TABLE_500
2266: , p5_a15 JTF_VARCHAR2_TABLE_500