DBA Data[Home] [Help]

APPS.OKL_RCA_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 18: , a15 JTF_VARCHAR2_TABLE_100

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500

Line 111: , a15 out nocopy JTF_VARCHAR2_TABLE_100

107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_DATE_TABLE
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_VARCHAR2_TABLE_500
113: , a17 out nocopy JTF_VARCHAR2_TABLE_500
114: , a18 out nocopy JTF_VARCHAR2_TABLE_500
115: , a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 153: a15 := JTF_VARCHAR2_TABLE_100();

149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_DATE_TABLE();
152: a14 := JTF_NUMBER_TABLE();
153: a15 := JTF_VARCHAR2_TABLE_100();
154: a16 := JTF_VARCHAR2_TABLE_500();
155: a17 := JTF_VARCHAR2_TABLE_500();
156: a18 := JTF_VARCHAR2_TABLE_500();
157: a19 := JTF_VARCHAR2_TABLE_500();

Line 192: a15 := JTF_VARCHAR2_TABLE_100();

188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_DATE_TABLE();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_VARCHAR2_TABLE_500();
194: a17 := JTF_VARCHAR2_TABLE_500();
195: a18 := JTF_VARCHAR2_TABLE_500();
196: a19 := JTF_VARCHAR2_TABLE_500();

Line 306: , a1 JTF_VARCHAR2_TABLE_100

302: end if;
303: end rosetta_table_copy_out_p2;
304:
305: procedure rosetta_table_copy_in_p5(t out nocopy okl_rca_pvt.okl_txl_rcpt_apps_tl_tbl_type, a0 JTF_NUMBER_TABLE
306: , a1 JTF_VARCHAR2_TABLE_100
307: , a2 JTF_VARCHAR2_TABLE_100
308: , a3 JTF_VARCHAR2_TABLE_100
309: , a4 JTF_VARCHAR2_TABLE_2000
310: , a5 JTF_NUMBER_TABLE

Line 307: , a2 JTF_VARCHAR2_TABLE_100

303: end rosetta_table_copy_out_p2;
304:
305: procedure rosetta_table_copy_in_p5(t out nocopy okl_rca_pvt.okl_txl_rcpt_apps_tl_tbl_type, a0 JTF_NUMBER_TABLE
306: , a1 JTF_VARCHAR2_TABLE_100
307: , a2 JTF_VARCHAR2_TABLE_100
308: , a3 JTF_VARCHAR2_TABLE_100
309: , a4 JTF_VARCHAR2_TABLE_2000
310: , a5 JTF_NUMBER_TABLE
311: , a6 JTF_DATE_TABLE

Line 308: , a3 JTF_VARCHAR2_TABLE_100

304:
305: procedure rosetta_table_copy_in_p5(t out nocopy okl_rca_pvt.okl_txl_rcpt_apps_tl_tbl_type, a0 JTF_NUMBER_TABLE
306: , a1 JTF_VARCHAR2_TABLE_100
307: , a2 JTF_VARCHAR2_TABLE_100
308: , a3 JTF_VARCHAR2_TABLE_100
309: , a4 JTF_VARCHAR2_TABLE_2000
310: , a5 JTF_NUMBER_TABLE
311: , a6 JTF_DATE_TABLE
312: , a7 JTF_NUMBER_TABLE

Line 343: , a1 out nocopy JTF_VARCHAR2_TABLE_100

339: end if;
340: end if;
341: end rosetta_table_copy_in_p5;
342: procedure rosetta_table_copy_out_p5(t okl_rca_pvt.okl_txl_rcpt_apps_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
343: , a1 out nocopy JTF_VARCHAR2_TABLE_100
344: , a2 out nocopy JTF_VARCHAR2_TABLE_100
345: , a3 out nocopy JTF_VARCHAR2_TABLE_100
346: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
347: , a5 out nocopy JTF_NUMBER_TABLE

Line 344: , a2 out nocopy JTF_VARCHAR2_TABLE_100

340: end if;
341: end rosetta_table_copy_in_p5;
342: procedure rosetta_table_copy_out_p5(t okl_rca_pvt.okl_txl_rcpt_apps_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
343: , a1 out nocopy JTF_VARCHAR2_TABLE_100
344: , a2 out nocopy JTF_VARCHAR2_TABLE_100
345: , a3 out nocopy JTF_VARCHAR2_TABLE_100
346: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
347: , a5 out nocopy JTF_NUMBER_TABLE
348: , a6 out nocopy JTF_DATE_TABLE

Line 345: , a3 out nocopy JTF_VARCHAR2_TABLE_100

341: end rosetta_table_copy_in_p5;
342: procedure rosetta_table_copy_out_p5(t okl_rca_pvt.okl_txl_rcpt_apps_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
343: , a1 out nocopy JTF_VARCHAR2_TABLE_100
344: , a2 out nocopy JTF_VARCHAR2_TABLE_100
345: , a3 out nocopy JTF_VARCHAR2_TABLE_100
346: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
347: , a5 out nocopy JTF_NUMBER_TABLE
348: , a6 out nocopy JTF_DATE_TABLE
349: , a7 out nocopy JTF_NUMBER_TABLE

Line 357: a1 := JTF_VARCHAR2_TABLE_100();

353: ddindx binary_integer; indx binary_integer;
354: begin
355: if t is null or t.count = 0 then
356: a0 := JTF_NUMBER_TABLE();
357: a1 := JTF_VARCHAR2_TABLE_100();
358: a2 := JTF_VARCHAR2_TABLE_100();
359: a3 := JTF_VARCHAR2_TABLE_100();
360: a4 := JTF_VARCHAR2_TABLE_2000();
361: a5 := JTF_NUMBER_TABLE();

Line 358: a2 := JTF_VARCHAR2_TABLE_100();

354: begin
355: if t is null or t.count = 0 then
356: a0 := JTF_NUMBER_TABLE();
357: a1 := JTF_VARCHAR2_TABLE_100();
358: a2 := JTF_VARCHAR2_TABLE_100();
359: a3 := JTF_VARCHAR2_TABLE_100();
360: a4 := JTF_VARCHAR2_TABLE_2000();
361: a5 := JTF_NUMBER_TABLE();
362: a6 := JTF_DATE_TABLE();

Line 359: a3 := JTF_VARCHAR2_TABLE_100();

355: if t is null or t.count = 0 then
356: a0 := JTF_NUMBER_TABLE();
357: a1 := JTF_VARCHAR2_TABLE_100();
358: a2 := JTF_VARCHAR2_TABLE_100();
359: a3 := JTF_VARCHAR2_TABLE_100();
360: a4 := JTF_VARCHAR2_TABLE_2000();
361: a5 := JTF_NUMBER_TABLE();
362: a6 := JTF_DATE_TABLE();
363: a7 := JTF_NUMBER_TABLE();

Line 368: a1 := JTF_VARCHAR2_TABLE_100();

364: a8 := JTF_DATE_TABLE();
365: a9 := JTF_NUMBER_TABLE();
366: else
367: a0 := JTF_NUMBER_TABLE();
368: a1 := JTF_VARCHAR2_TABLE_100();
369: a2 := JTF_VARCHAR2_TABLE_100();
370: a3 := JTF_VARCHAR2_TABLE_100();
371: a4 := JTF_VARCHAR2_TABLE_2000();
372: a5 := JTF_NUMBER_TABLE();

Line 369: a2 := JTF_VARCHAR2_TABLE_100();

365: a9 := JTF_NUMBER_TABLE();
366: else
367: a0 := JTF_NUMBER_TABLE();
368: a1 := JTF_VARCHAR2_TABLE_100();
369: a2 := JTF_VARCHAR2_TABLE_100();
370: a3 := JTF_VARCHAR2_TABLE_100();
371: a4 := JTF_VARCHAR2_TABLE_2000();
372: a5 := JTF_NUMBER_TABLE();
373: a6 := JTF_DATE_TABLE();

Line 370: a3 := JTF_VARCHAR2_TABLE_100();

366: else
367: a0 := JTF_NUMBER_TABLE();
368: a1 := JTF_VARCHAR2_TABLE_100();
369: a2 := JTF_VARCHAR2_TABLE_100();
370: a3 := JTF_VARCHAR2_TABLE_100();
371: a4 := JTF_VARCHAR2_TABLE_2000();
372: a5 := JTF_NUMBER_TABLE();
373: a6 := JTF_DATE_TABLE();
374: a7 := JTF_NUMBER_TABLE();

Line 413: , a2 JTF_VARCHAR2_TABLE_100

409: end rosetta_table_copy_out_p5;
410:
411: procedure rosetta_table_copy_in_p8(t out nocopy okl_rca_pvt.rcav_tbl_type, a0 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_VARCHAR2_TABLE_100
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE

Line 423: , a12 JTF_VARCHAR2_TABLE_100

419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_VARCHAR2_TABLE_2000
422: , a11 JTF_NUMBER_TABLE
423: , a12 JTF_VARCHAR2_TABLE_100
424: , a13 JTF_VARCHAR2_TABLE_500
425: , a14 JTF_VARCHAR2_TABLE_500
426: , a15 JTF_VARCHAR2_TABLE_500
427: , a16 JTF_VARCHAR2_TABLE_500

Line 510: , a2 out nocopy JTF_VARCHAR2_TABLE_100

506: end if;
507: end rosetta_table_copy_in_p8;
508: procedure rosetta_table_copy_out_p8(t okl_rca_pvt.rcav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_VARCHAR2_TABLE_100
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_NUMBER_TABLE

Line 520: , a12 out nocopy JTF_VARCHAR2_TABLE_100

516: , a8 out nocopy JTF_NUMBER_TABLE
517: , a9 out nocopy JTF_NUMBER_TABLE
518: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
519: , a11 out nocopy JTF_NUMBER_TABLE
520: , a12 out nocopy JTF_VARCHAR2_TABLE_100
521: , a13 out nocopy JTF_VARCHAR2_TABLE_500
522: , a14 out nocopy JTF_VARCHAR2_TABLE_500
523: , a15 out nocopy JTF_VARCHAR2_TABLE_500
524: , a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 554: a2 := JTF_VARCHAR2_TABLE_100();

550: begin
551: if t is null or t.count = 0 then
552: a0 := JTF_NUMBER_TABLE();
553: a1 := JTF_NUMBER_TABLE();
554: a2 := JTF_VARCHAR2_TABLE_100();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_NUMBER_TABLE();
558: a6 := JTF_NUMBER_TABLE();

Line 564: a12 := JTF_VARCHAR2_TABLE_100();

560: a8 := JTF_NUMBER_TABLE();
561: a9 := JTF_NUMBER_TABLE();
562: a10 := JTF_VARCHAR2_TABLE_2000();
563: a11 := JTF_NUMBER_TABLE();
564: a12 := JTF_VARCHAR2_TABLE_100();
565: a13 := JTF_VARCHAR2_TABLE_500();
566: a14 := JTF_VARCHAR2_TABLE_500();
567: a15 := JTF_VARCHAR2_TABLE_500();
568: a16 := JTF_VARCHAR2_TABLE_500();

Line 595: a2 := JTF_VARCHAR2_TABLE_100();

591: a39 := JTF_NUMBER_TABLE();
592: else
593: a0 := JTF_NUMBER_TABLE();
594: a1 := JTF_NUMBER_TABLE();
595: a2 := JTF_VARCHAR2_TABLE_100();
596: a3 := JTF_NUMBER_TABLE();
597: a4 := JTF_NUMBER_TABLE();
598: a5 := JTF_NUMBER_TABLE();
599: a6 := JTF_NUMBER_TABLE();

Line 605: a12 := JTF_VARCHAR2_TABLE_100();

601: a8 := JTF_NUMBER_TABLE();
602: a9 := JTF_NUMBER_TABLE();
603: a10 := JTF_VARCHAR2_TABLE_2000();
604: a11 := JTF_NUMBER_TABLE();
605: a12 := JTF_VARCHAR2_TABLE_100();
606: a13 := JTF_VARCHAR2_TABLE_500();
607: a14 := JTF_VARCHAR2_TABLE_500();
608: a15 := JTF_VARCHAR2_TABLE_500();
609: a16 := JTF_VARCHAR2_TABLE_500();

Line 933: , p5_a2 JTF_VARCHAR2_TABLE_100

929: , x_msg_count out nocopy NUMBER
930: , x_msg_data out nocopy VARCHAR2
931: , p5_a0 JTF_NUMBER_TABLE
932: , p5_a1 JTF_NUMBER_TABLE
933: , p5_a2 JTF_VARCHAR2_TABLE_100
934: , p5_a3 JTF_NUMBER_TABLE
935: , p5_a4 JTF_NUMBER_TABLE
936: , p5_a5 JTF_NUMBER_TABLE
937: , p5_a6 JTF_NUMBER_TABLE

Line 943: , p5_a12 JTF_VARCHAR2_TABLE_100

939: , p5_a8 JTF_NUMBER_TABLE
940: , p5_a9 JTF_NUMBER_TABLE
941: , p5_a10 JTF_VARCHAR2_TABLE_2000
942: , p5_a11 JTF_NUMBER_TABLE
943: , p5_a12 JTF_VARCHAR2_TABLE_100
944: , p5_a13 JTF_VARCHAR2_TABLE_500
945: , p5_a14 JTF_VARCHAR2_TABLE_500
946: , p5_a15 JTF_VARCHAR2_TABLE_500
947: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 973: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

969: , p5_a38 JTF_NUMBER_TABLE
970: , p5_a39 JTF_NUMBER_TABLE
971: , p6_a0 out nocopy JTF_NUMBER_TABLE
972: , p6_a1 out nocopy JTF_NUMBER_TABLE
973: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
974: , p6_a3 out nocopy JTF_NUMBER_TABLE
975: , p6_a4 out nocopy JTF_NUMBER_TABLE
976: , p6_a5 out nocopy JTF_NUMBER_TABLE
977: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 983: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

979: , p6_a8 out nocopy JTF_NUMBER_TABLE
980: , p6_a9 out nocopy JTF_NUMBER_TABLE
981: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
982: , p6_a11 out nocopy JTF_NUMBER_TABLE
983: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
984: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
985: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
986: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
987: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 1249: , p5_a2 JTF_VARCHAR2_TABLE_100

1245: , x_msg_count out nocopy NUMBER
1246: , x_msg_data out nocopy VARCHAR2
1247: , p5_a0 JTF_NUMBER_TABLE
1248: , p5_a1 JTF_NUMBER_TABLE
1249: , p5_a2 JTF_VARCHAR2_TABLE_100
1250: , p5_a3 JTF_NUMBER_TABLE
1251: , p5_a4 JTF_NUMBER_TABLE
1252: , p5_a5 JTF_NUMBER_TABLE
1253: , p5_a6 JTF_NUMBER_TABLE

Line 1259: , p5_a12 JTF_VARCHAR2_TABLE_100

1255: , p5_a8 JTF_NUMBER_TABLE
1256: , p5_a9 JTF_NUMBER_TABLE
1257: , p5_a10 JTF_VARCHAR2_TABLE_2000
1258: , p5_a11 JTF_NUMBER_TABLE
1259: , p5_a12 JTF_VARCHAR2_TABLE_100
1260: , p5_a13 JTF_VARCHAR2_TABLE_500
1261: , p5_a14 JTF_VARCHAR2_TABLE_500
1262: , p5_a15 JTF_VARCHAR2_TABLE_500
1263: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 1564: , p5_a2 JTF_VARCHAR2_TABLE_100

1560: , x_msg_count out nocopy NUMBER
1561: , x_msg_data out nocopy VARCHAR2
1562: , p5_a0 JTF_NUMBER_TABLE
1563: , p5_a1 JTF_NUMBER_TABLE
1564: , p5_a2 JTF_VARCHAR2_TABLE_100
1565: , p5_a3 JTF_NUMBER_TABLE
1566: , p5_a4 JTF_NUMBER_TABLE
1567: , p5_a5 JTF_NUMBER_TABLE
1568: , p5_a6 JTF_NUMBER_TABLE

Line 1574: , p5_a12 JTF_VARCHAR2_TABLE_100

1570: , p5_a8 JTF_NUMBER_TABLE
1571: , p5_a9 JTF_NUMBER_TABLE
1572: , p5_a10 JTF_VARCHAR2_TABLE_2000
1573: , p5_a11 JTF_NUMBER_TABLE
1574: , p5_a12 JTF_VARCHAR2_TABLE_100
1575: , p5_a13 JTF_VARCHAR2_TABLE_500
1576: , p5_a14 JTF_VARCHAR2_TABLE_500
1577: , p5_a15 JTF_VARCHAR2_TABLE_500
1578: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 1604: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

1600: , p5_a38 JTF_NUMBER_TABLE
1601: , p5_a39 JTF_NUMBER_TABLE
1602: , p6_a0 out nocopy JTF_NUMBER_TABLE
1603: , p6_a1 out nocopy JTF_NUMBER_TABLE
1604: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a3 out nocopy JTF_NUMBER_TABLE
1606: , p6_a4 out nocopy JTF_NUMBER_TABLE
1607: , p6_a5 out nocopy JTF_NUMBER_TABLE
1608: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 1614: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

1610: , p6_a8 out nocopy JTF_NUMBER_TABLE
1611: , p6_a9 out nocopy JTF_NUMBER_TABLE
1612: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
1613: , p6_a11 out nocopy JTF_NUMBER_TABLE
1614: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1615: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1616: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1617: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1618: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 1880: , p5_a2 JTF_VARCHAR2_TABLE_100

1876: , x_msg_count out nocopy NUMBER
1877: , x_msg_data out nocopy VARCHAR2
1878: , p5_a0 JTF_NUMBER_TABLE
1879: , p5_a1 JTF_NUMBER_TABLE
1880: , p5_a2 JTF_VARCHAR2_TABLE_100
1881: , p5_a3 JTF_NUMBER_TABLE
1882: , p5_a4 JTF_NUMBER_TABLE
1883: , p5_a5 JTF_NUMBER_TABLE
1884: , p5_a6 JTF_NUMBER_TABLE

Line 1890: , p5_a12 JTF_VARCHAR2_TABLE_100

1886: , p5_a8 JTF_NUMBER_TABLE
1887: , p5_a9 JTF_NUMBER_TABLE
1888: , p5_a10 JTF_VARCHAR2_TABLE_2000
1889: , p5_a11 JTF_NUMBER_TABLE
1890: , p5_a12 JTF_VARCHAR2_TABLE_100
1891: , p5_a13 JTF_VARCHAR2_TABLE_500
1892: , p5_a14 JTF_VARCHAR2_TABLE_500
1893: , p5_a15 JTF_VARCHAR2_TABLE_500
1894: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 2111: , p5_a2 JTF_VARCHAR2_TABLE_100

2107: , x_msg_count out nocopy NUMBER
2108: , x_msg_data out nocopy VARCHAR2
2109: , p5_a0 JTF_NUMBER_TABLE
2110: , p5_a1 JTF_NUMBER_TABLE
2111: , p5_a2 JTF_VARCHAR2_TABLE_100
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_NUMBER_TABLE
2115: , p5_a6 JTF_NUMBER_TABLE

Line 2121: , p5_a12 JTF_VARCHAR2_TABLE_100

2117: , p5_a8 JTF_NUMBER_TABLE
2118: , p5_a9 JTF_NUMBER_TABLE
2119: , p5_a10 JTF_VARCHAR2_TABLE_2000
2120: , p5_a11 JTF_NUMBER_TABLE
2121: , p5_a12 JTF_VARCHAR2_TABLE_100
2122: , p5_a13 JTF_VARCHAR2_TABLE_500
2123: , p5_a14 JTF_VARCHAR2_TABLE_500
2124: , p5_a15 JTF_VARCHAR2_TABLE_500
2125: , p5_a16 JTF_VARCHAR2_TABLE_500