DBA Data[Home] [Help]

APPS.OKL_CAH_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 25: , a3 JTF_VARCHAR2_TABLE_100

21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_cah_pvt.cah_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_2000
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_500

Line 28: , a6 JTF_VARCHAR2_TABLE_100

24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_2000
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_500
30: , a8 JTF_VARCHAR2_TABLE_500
31: , a9 JTF_VARCHAR2_TABLE_500
32: , a10 JTF_VARCHAR2_TABLE_500

Line 98: , a3 out nocopy JTF_VARCHAR2_TABLE_100

94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t okl_cah_pvt.cah_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_200
97: , a2 out nocopy JTF_NUMBER_TABLE
98: , a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , a4 out nocopy JTF_NUMBER_TABLE
100: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a6 out nocopy JTF_VARCHAR2_TABLE_100
102: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 101: , a6 out nocopy JTF_VARCHAR2_TABLE_100

97: , a2 out nocopy JTF_NUMBER_TABLE
98: , a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , a4 out nocopy JTF_NUMBER_TABLE
100: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a6 out nocopy JTF_VARCHAR2_TABLE_100
102: , a7 out nocopy JTF_VARCHAR2_TABLE_500
103: , a8 out nocopy JTF_VARCHAR2_TABLE_500
104: , a9 out nocopy JTF_VARCHAR2_TABLE_500
105: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 130: a3 := JTF_VARCHAR2_TABLE_100();

126: if t is null or t.count = 0 then
127: a0 := JTF_NUMBER_TABLE();
128: a1 := JTF_VARCHAR2_TABLE_200();
129: a2 := JTF_NUMBER_TABLE();
130: a3 := JTF_VARCHAR2_TABLE_100();
131: a4 := JTF_NUMBER_TABLE();
132: a5 := JTF_VARCHAR2_TABLE_2000();
133: a6 := JTF_VARCHAR2_TABLE_100();
134: a7 := JTF_VARCHAR2_TABLE_500();

Line 133: a6 := JTF_VARCHAR2_TABLE_100();

129: a2 := JTF_NUMBER_TABLE();
130: a3 := JTF_VARCHAR2_TABLE_100();
131: a4 := JTF_NUMBER_TABLE();
132: a5 := JTF_VARCHAR2_TABLE_2000();
133: a6 := JTF_VARCHAR2_TABLE_100();
134: a7 := JTF_VARCHAR2_TABLE_500();
135: a8 := JTF_VARCHAR2_TABLE_500();
136: a9 := JTF_VARCHAR2_TABLE_500();
137: a10 := JTF_VARCHAR2_TABLE_500();

Line 159: a3 := JTF_VARCHAR2_TABLE_100();

155: else
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_VARCHAR2_TABLE_200();
158: a2 := JTF_NUMBER_TABLE();
159: a3 := JTF_VARCHAR2_TABLE_100();
160: a4 := JTF_NUMBER_TABLE();
161: a5 := JTF_VARCHAR2_TABLE_2000();
162: a6 := JTF_VARCHAR2_TABLE_100();
163: a7 := JTF_VARCHAR2_TABLE_500();

Line 162: a6 := JTF_VARCHAR2_TABLE_100();

158: a2 := JTF_NUMBER_TABLE();
159: a3 := JTF_VARCHAR2_TABLE_100();
160: a4 := JTF_NUMBER_TABLE();
161: a5 := JTF_VARCHAR2_TABLE_2000();
162: a6 := JTF_VARCHAR2_TABLE_100();
163: a7 := JTF_VARCHAR2_TABLE_500();
164: a8 := JTF_VARCHAR2_TABLE_500();
165: a9 := JTF_VARCHAR2_TABLE_500();
166: a10 := JTF_VARCHAR2_TABLE_500();

Line 259: , a5 JTF_VARCHAR2_TABLE_100

255: , a1 JTF_NUMBER_TABLE
256: , a2 JTF_VARCHAR2_TABLE_200
257: , a3 JTF_VARCHAR2_TABLE_2000
258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_VARCHAR2_TABLE_100
260: , a6 JTF_VARCHAR2_TABLE_500
261: , a7 JTF_VARCHAR2_TABLE_500
262: , a8 JTF_VARCHAR2_TABLE_500
263: , a9 JTF_VARCHAR2_TABLE_500

Line 276: , a22 JTF_VARCHAR2_TABLE_100

272: , a18 JTF_VARCHAR2_TABLE_500
273: , a19 JTF_VARCHAR2_TABLE_500
274: , a20 JTF_VARCHAR2_TABLE_500
275: , a21 JTF_NUMBER_TABLE
276: , a22 JTF_VARCHAR2_TABLE_100
277: , a23 JTF_NUMBER_TABLE
278: , a24 JTF_DATE_TABLE
279: , a25 JTF_NUMBER_TABLE
280: , a26 JTF_DATE_TABLE

Line 332: , a5 out nocopy JTF_VARCHAR2_TABLE_100

328: , a1 out nocopy JTF_NUMBER_TABLE
329: , a2 out nocopy JTF_VARCHAR2_TABLE_200
330: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
331: , a4 out nocopy JTF_NUMBER_TABLE
332: , a5 out nocopy JTF_VARCHAR2_TABLE_100
333: , a6 out nocopy JTF_VARCHAR2_TABLE_500
334: , a7 out nocopy JTF_VARCHAR2_TABLE_500
335: , a8 out nocopy JTF_VARCHAR2_TABLE_500
336: , a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 349: , a22 out nocopy JTF_VARCHAR2_TABLE_100

345: , a18 out nocopy JTF_VARCHAR2_TABLE_500
346: , a19 out nocopy JTF_VARCHAR2_TABLE_500
347: , a20 out nocopy JTF_VARCHAR2_TABLE_500
348: , a21 out nocopy JTF_NUMBER_TABLE
349: , a22 out nocopy JTF_VARCHAR2_TABLE_100
350: , a23 out nocopy JTF_NUMBER_TABLE
351: , a24 out nocopy JTF_DATE_TABLE
352: , a25 out nocopy JTF_NUMBER_TABLE
353: , a26 out nocopy JTF_DATE_TABLE

Line 364: a5 := JTF_VARCHAR2_TABLE_100();

360: a1 := JTF_NUMBER_TABLE();
361: a2 := JTF_VARCHAR2_TABLE_200();
362: a3 := JTF_VARCHAR2_TABLE_2000();
363: a4 := JTF_NUMBER_TABLE();
364: a5 := JTF_VARCHAR2_TABLE_100();
365: a6 := JTF_VARCHAR2_TABLE_500();
366: a7 := JTF_VARCHAR2_TABLE_500();
367: a8 := JTF_VARCHAR2_TABLE_500();
368: a9 := JTF_VARCHAR2_TABLE_500();

Line 381: a22 := JTF_VARCHAR2_TABLE_100();

377: a18 := JTF_VARCHAR2_TABLE_500();
378: a19 := JTF_VARCHAR2_TABLE_500();
379: a20 := JTF_VARCHAR2_TABLE_500();
380: a21 := JTF_NUMBER_TABLE();
381: a22 := JTF_VARCHAR2_TABLE_100();
382: a23 := JTF_NUMBER_TABLE();
383: a24 := JTF_DATE_TABLE();
384: a25 := JTF_NUMBER_TABLE();
385: a26 := JTF_DATE_TABLE();

Line 393: a5 := JTF_VARCHAR2_TABLE_100();

389: a1 := JTF_NUMBER_TABLE();
390: a2 := JTF_VARCHAR2_TABLE_200();
391: a3 := JTF_VARCHAR2_TABLE_2000();
392: a4 := JTF_NUMBER_TABLE();
393: a5 := JTF_VARCHAR2_TABLE_100();
394: a6 := JTF_VARCHAR2_TABLE_500();
395: a7 := JTF_VARCHAR2_TABLE_500();
396: a8 := JTF_VARCHAR2_TABLE_500();
397: a9 := JTF_VARCHAR2_TABLE_500();

Line 410: a22 := JTF_VARCHAR2_TABLE_100();

406: a18 := JTF_VARCHAR2_TABLE_500();
407: a19 := JTF_VARCHAR2_TABLE_500();
408: a20 := JTF_VARCHAR2_TABLE_500();
409: a21 := JTF_NUMBER_TABLE();
410: a22 := JTF_VARCHAR2_TABLE_100();
411: a23 := JTF_NUMBER_TABLE();
412: a24 := JTF_DATE_TABLE();
413: a25 := JTF_NUMBER_TABLE();
414: a26 := JTF_DATE_TABLE();

Line 647: , p5_a5 JTF_VARCHAR2_TABLE_100

643: , p5_a1 JTF_NUMBER_TABLE
644: , p5_a2 JTF_VARCHAR2_TABLE_200
645: , p5_a3 JTF_VARCHAR2_TABLE_2000
646: , p5_a4 JTF_NUMBER_TABLE
647: , p5_a5 JTF_VARCHAR2_TABLE_100
648: , p5_a6 JTF_VARCHAR2_TABLE_500
649: , p5_a7 JTF_VARCHAR2_TABLE_500
650: , p5_a8 JTF_VARCHAR2_TABLE_500
651: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 664: , p5_a22 JTF_VARCHAR2_TABLE_100

660: , p5_a18 JTF_VARCHAR2_TABLE_500
661: , p5_a19 JTF_VARCHAR2_TABLE_500
662: , p5_a20 JTF_VARCHAR2_TABLE_500
663: , p5_a21 JTF_NUMBER_TABLE
664: , p5_a22 JTF_VARCHAR2_TABLE_100
665: , p5_a23 JTF_NUMBER_TABLE
666: , p5_a24 JTF_DATE_TABLE
667: , p5_a25 JTF_NUMBER_TABLE
668: , p5_a26 JTF_DATE_TABLE

Line 675: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

671: , p6_a1 out nocopy JTF_NUMBER_TABLE
672: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
673: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
674: , p6_a4 out nocopy JTF_NUMBER_TABLE
675: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
676: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
677: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
678: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
679: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 692: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

688: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
689: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
690: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
691: , p6_a21 out nocopy JTF_NUMBER_TABLE
692: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a23 out nocopy JTF_NUMBER_TABLE
694: , p6_a24 out nocopy JTF_DATE_TABLE
695: , p6_a25 out nocopy JTF_NUMBER_TABLE
696: , p6_a26 out nocopy JTF_DATE_TABLE

Line 891: , p5_a5 JTF_VARCHAR2_TABLE_100

887: , p5_a1 JTF_NUMBER_TABLE
888: , p5_a2 JTF_VARCHAR2_TABLE_200
889: , p5_a3 JTF_VARCHAR2_TABLE_2000
890: , p5_a4 JTF_NUMBER_TABLE
891: , p5_a5 JTF_VARCHAR2_TABLE_100
892: , p5_a6 JTF_VARCHAR2_TABLE_500
893: , p5_a7 JTF_VARCHAR2_TABLE_500
894: , p5_a8 JTF_VARCHAR2_TABLE_500
895: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 908: , p5_a22 JTF_VARCHAR2_TABLE_100

904: , p5_a18 JTF_VARCHAR2_TABLE_500
905: , p5_a19 JTF_VARCHAR2_TABLE_500
906: , p5_a20 JTF_VARCHAR2_TABLE_500
907: , p5_a21 JTF_NUMBER_TABLE
908: , p5_a22 JTF_VARCHAR2_TABLE_100
909: , p5_a23 JTF_NUMBER_TABLE
910: , p5_a24 JTF_DATE_TABLE
911: , p5_a25 JTF_NUMBER_TABLE
912: , p5_a26 JTF_DATE_TABLE

Line 1134: , p5_a5 JTF_VARCHAR2_TABLE_100

1130: , p5_a1 JTF_NUMBER_TABLE
1131: , p5_a2 JTF_VARCHAR2_TABLE_200
1132: , p5_a3 JTF_VARCHAR2_TABLE_2000
1133: , p5_a4 JTF_NUMBER_TABLE
1134: , p5_a5 JTF_VARCHAR2_TABLE_100
1135: , p5_a6 JTF_VARCHAR2_TABLE_500
1136: , p5_a7 JTF_VARCHAR2_TABLE_500
1137: , p5_a8 JTF_VARCHAR2_TABLE_500
1138: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 1151: , p5_a22 JTF_VARCHAR2_TABLE_100

1147: , p5_a18 JTF_VARCHAR2_TABLE_500
1148: , p5_a19 JTF_VARCHAR2_TABLE_500
1149: , p5_a20 JTF_VARCHAR2_TABLE_500
1150: , p5_a21 JTF_NUMBER_TABLE
1151: , p5_a22 JTF_VARCHAR2_TABLE_100
1152: , p5_a23 JTF_NUMBER_TABLE
1153: , p5_a24 JTF_DATE_TABLE
1154: , p5_a25 JTF_NUMBER_TABLE
1155: , p5_a26 JTF_DATE_TABLE

Line 1162: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

1158: , p6_a1 out nocopy JTF_NUMBER_TABLE
1159: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1160: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1161: , p6_a4 out nocopy JTF_NUMBER_TABLE
1162: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1163: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1164: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1165: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1166: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 1179: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

1175: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1176: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1177: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1178: , p6_a21 out nocopy JTF_NUMBER_TABLE
1179: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1180: , p6_a23 out nocopy JTF_NUMBER_TABLE
1181: , p6_a24 out nocopy JTF_DATE_TABLE
1182: , p6_a25 out nocopy JTF_NUMBER_TABLE
1183: , p6_a26 out nocopy JTF_DATE_TABLE

Line 1378: , p5_a5 JTF_VARCHAR2_TABLE_100

1374: , p5_a1 JTF_NUMBER_TABLE
1375: , p5_a2 JTF_VARCHAR2_TABLE_200
1376: , p5_a3 JTF_VARCHAR2_TABLE_2000
1377: , p5_a4 JTF_NUMBER_TABLE
1378: , p5_a5 JTF_VARCHAR2_TABLE_100
1379: , p5_a6 JTF_VARCHAR2_TABLE_500
1380: , p5_a7 JTF_VARCHAR2_TABLE_500
1381: , p5_a8 JTF_VARCHAR2_TABLE_500
1382: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 1395: , p5_a22 JTF_VARCHAR2_TABLE_100

1391: , p5_a18 JTF_VARCHAR2_TABLE_500
1392: , p5_a19 JTF_VARCHAR2_TABLE_500
1393: , p5_a20 JTF_VARCHAR2_TABLE_500
1394: , p5_a21 JTF_NUMBER_TABLE
1395: , p5_a22 JTF_VARCHAR2_TABLE_100
1396: , p5_a23 JTF_NUMBER_TABLE
1397: , p5_a24 JTF_DATE_TABLE
1398: , p5_a25 JTF_NUMBER_TABLE
1399: , p5_a26 JTF_DATE_TABLE

Line 1561: , p5_a5 JTF_VARCHAR2_TABLE_100

1557: , p5_a1 JTF_NUMBER_TABLE
1558: , p5_a2 JTF_VARCHAR2_TABLE_200
1559: , p5_a3 JTF_VARCHAR2_TABLE_2000
1560: , p5_a4 JTF_NUMBER_TABLE
1561: , p5_a5 JTF_VARCHAR2_TABLE_100
1562: , p5_a6 JTF_VARCHAR2_TABLE_500
1563: , p5_a7 JTF_VARCHAR2_TABLE_500
1564: , p5_a8 JTF_VARCHAR2_TABLE_500
1565: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 1578: , p5_a22 JTF_VARCHAR2_TABLE_100

1574: , p5_a18 JTF_VARCHAR2_TABLE_500
1575: , p5_a19 JTF_VARCHAR2_TABLE_500
1576: , p5_a20 JTF_VARCHAR2_TABLE_500
1577: , p5_a21 JTF_NUMBER_TABLE
1578: , p5_a22 JTF_VARCHAR2_TABLE_100
1579: , p5_a23 JTF_NUMBER_TABLE
1580: , p5_a24 JTF_DATE_TABLE
1581: , p5_a25 JTF_NUMBER_TABLE
1582: , p5_a26 JTF_DATE_TABLE