DBA Data[Home] [Help]

APPS.OKL_ACD_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

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

Line 35: , a13 JTF_VARCHAR2_TABLE_100

31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_500
37: , a15 JTF_VARCHAR2_TABLE_500
38: , a16 JTF_VARCHAR2_TABLE_500
39: , a17 JTF_VARCHAR2_TABLE_500

Line 109: , a2 out nocopy JTF_VARCHAR2_TABLE_100

105: end if;
106: end rosetta_table_copy_in_p2;
107: procedure rosetta_table_copy_out_p2(t okl_acd_pvt.acd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_DATE_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_NUMBER_TABLE
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_NUMBER_TABLE

Line 120: , a13 out nocopy JTF_VARCHAR2_TABLE_100

116: , a9 out nocopy JTF_NUMBER_TABLE
117: , a10 out nocopy JTF_NUMBER_TABLE
118: , a11 out nocopy JTF_NUMBER_TABLE
119: , a12 out nocopy JTF_DATE_TABLE
120: , a13 out nocopy JTF_VARCHAR2_TABLE_100
121: , a14 out nocopy JTF_VARCHAR2_TABLE_500
122: , a15 out nocopy JTF_VARCHAR2_TABLE_500
123: , a16 out nocopy JTF_VARCHAR2_TABLE_500
124: , a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 147: a2 := JTF_VARCHAR2_TABLE_100();

143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_DATE_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();

Line 158: a13 := JTF_VARCHAR2_TABLE_100();

154: a9 := JTF_NUMBER_TABLE();
155: a10 := JTF_NUMBER_TABLE();
156: a11 := JTF_NUMBER_TABLE();
157: a12 := JTF_DATE_TABLE();
158: a13 := JTF_VARCHAR2_TABLE_100();
159: a14 := JTF_VARCHAR2_TABLE_500();
160: a15 := JTF_VARCHAR2_TABLE_500();
161: a16 := JTF_VARCHAR2_TABLE_500();
162: a17 := JTF_VARCHAR2_TABLE_500();

Line 182: a2 := JTF_VARCHAR2_TABLE_100();

178: a33 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_DATE_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_NUMBER_TABLE();
184: a4 := JTF_NUMBER_TABLE();
185: a5 := JTF_NUMBER_TABLE();
186: a6 := JTF_NUMBER_TABLE();

Line 193: a13 := JTF_VARCHAR2_TABLE_100();

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

Line 298: , a2 JTF_VARCHAR2_TABLE_100

294: end rosetta_table_copy_out_p2;
295:
296: procedure rosetta_table_copy_in_p5(t out nocopy okl_acd_pvt.acdv_tbl_type, a0 JTF_NUMBER_TABLE
297: , a1 JTF_NUMBER_TABLE
298: , a2 JTF_VARCHAR2_TABLE_100
299: , a3 JTF_NUMBER_TABLE
300: , a4 JTF_NUMBER_TABLE
301: , a5 JTF_NUMBER_TABLE
302: , a6 JTF_NUMBER_TABLE

Line 304: , a8 JTF_VARCHAR2_TABLE_100

300: , a4 JTF_NUMBER_TABLE
301: , a5 JTF_NUMBER_TABLE
302: , a6 JTF_NUMBER_TABLE
303: , a7 JTF_DATE_TABLE
304: , a8 JTF_VARCHAR2_TABLE_100
305: , a9 JTF_VARCHAR2_TABLE_500
306: , a10 JTF_VARCHAR2_TABLE_500
307: , a11 JTF_VARCHAR2_TABLE_500
308: , a12 JTF_VARCHAR2_TABLE_500

Line 383: , a2 out nocopy JTF_VARCHAR2_TABLE_100

379: end if;
380: end rosetta_table_copy_in_p5;
381: procedure rosetta_table_copy_out_p5(t okl_acd_pvt.acdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
382: , a1 out nocopy JTF_NUMBER_TABLE
383: , a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , a3 out nocopy JTF_NUMBER_TABLE
385: , a4 out nocopy JTF_NUMBER_TABLE
386: , a5 out nocopy JTF_NUMBER_TABLE
387: , a6 out nocopy JTF_NUMBER_TABLE

Line 389: , a8 out nocopy JTF_VARCHAR2_TABLE_100

385: , a4 out nocopy JTF_NUMBER_TABLE
386: , a5 out nocopy JTF_NUMBER_TABLE
387: , a6 out nocopy JTF_NUMBER_TABLE
388: , a7 out nocopy JTF_DATE_TABLE
389: , a8 out nocopy JTF_VARCHAR2_TABLE_100
390: , a9 out nocopy JTF_VARCHAR2_TABLE_500
391: , a10 out nocopy JTF_VARCHAR2_TABLE_500
392: , a11 out nocopy JTF_VARCHAR2_TABLE_500
393: , a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 421: a2 := JTF_VARCHAR2_TABLE_100();

417: begin
418: if t is null or t.count = 0 then
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_VARCHAR2_TABLE_100();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_NUMBER_TABLE();
424: a5 := JTF_NUMBER_TABLE();
425: a6 := JTF_NUMBER_TABLE();

Line 427: a8 := JTF_VARCHAR2_TABLE_100();

423: a4 := JTF_NUMBER_TABLE();
424: a5 := JTF_NUMBER_TABLE();
425: a6 := JTF_NUMBER_TABLE();
426: a7 := JTF_DATE_TABLE();
427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_VARCHAR2_TABLE_500();
429: a10 := JTF_VARCHAR2_TABLE_500();
430: a11 := JTF_VARCHAR2_TABLE_500();
431: a12 := JTF_VARCHAR2_TABLE_500();

Line 456: a2 := JTF_VARCHAR2_TABLE_100();

452: a33 := JTF_NUMBER_TABLE();
453: else
454: a0 := JTF_NUMBER_TABLE();
455: a1 := JTF_NUMBER_TABLE();
456: a2 := JTF_VARCHAR2_TABLE_100();
457: a3 := JTF_NUMBER_TABLE();
458: a4 := JTF_NUMBER_TABLE();
459: a5 := JTF_NUMBER_TABLE();
460: a6 := JTF_NUMBER_TABLE();

Line 462: a8 := JTF_VARCHAR2_TABLE_100();

458: a4 := JTF_NUMBER_TABLE();
459: a5 := JTF_NUMBER_TABLE();
460: a6 := JTF_NUMBER_TABLE();
461: a7 := JTF_DATE_TABLE();
462: a8 := JTF_VARCHAR2_TABLE_100();
463: a9 := JTF_VARCHAR2_TABLE_500();
464: a10 := JTF_VARCHAR2_TABLE_500();
465: a11 := JTF_VARCHAR2_TABLE_500();
466: a12 := JTF_VARCHAR2_TABLE_500();

Line 752: , p5_a2 JTF_VARCHAR2_TABLE_100

748: , x_msg_count out nocopy NUMBER
749: , x_msg_data out nocopy VARCHAR2
750: , p5_a0 JTF_NUMBER_TABLE
751: , p5_a1 JTF_NUMBER_TABLE
752: , p5_a2 JTF_VARCHAR2_TABLE_100
753: , p5_a3 JTF_NUMBER_TABLE
754: , p5_a4 JTF_NUMBER_TABLE
755: , p5_a5 JTF_NUMBER_TABLE
756: , p5_a6 JTF_NUMBER_TABLE

Line 758: , p5_a8 JTF_VARCHAR2_TABLE_100

754: , p5_a4 JTF_NUMBER_TABLE
755: , p5_a5 JTF_NUMBER_TABLE
756: , p5_a6 JTF_NUMBER_TABLE
757: , p5_a7 JTF_DATE_TABLE
758: , p5_a8 JTF_VARCHAR2_TABLE_100
759: , p5_a9 JTF_VARCHAR2_TABLE_500
760: , p5_a10 JTF_VARCHAR2_TABLE_500
761: , p5_a11 JTF_VARCHAR2_TABLE_500
762: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 786: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

782: , p5_a32 JTF_DATE_TABLE
783: , p5_a33 JTF_NUMBER_TABLE
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_NUMBER_TABLE
786: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
787: , p6_a3 out nocopy JTF_NUMBER_TABLE
788: , p6_a4 out nocopy JTF_NUMBER_TABLE
789: , p6_a5 out nocopy JTF_NUMBER_TABLE
790: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 792: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

788: , p6_a4 out nocopy JTF_NUMBER_TABLE
789: , p6_a5 out nocopy JTF_NUMBER_TABLE
790: , p6_a6 out nocopy JTF_NUMBER_TABLE
791: , p6_a7 out nocopy JTF_DATE_TABLE
792: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
793: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
794: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
795: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
796: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 1032: , p5_a2 JTF_VARCHAR2_TABLE_100

1028: , x_msg_count out nocopy NUMBER
1029: , x_msg_data out nocopy VARCHAR2
1030: , p5_a0 JTF_NUMBER_TABLE
1031: , p5_a1 JTF_NUMBER_TABLE
1032: , p5_a2 JTF_VARCHAR2_TABLE_100
1033: , p5_a3 JTF_NUMBER_TABLE
1034: , p5_a4 JTF_NUMBER_TABLE
1035: , p5_a5 JTF_NUMBER_TABLE
1036: , p5_a6 JTF_NUMBER_TABLE

Line 1038: , p5_a8 JTF_VARCHAR2_TABLE_100

1034: , p5_a4 JTF_NUMBER_TABLE
1035: , p5_a5 JTF_NUMBER_TABLE
1036: , p5_a6 JTF_NUMBER_TABLE
1037: , p5_a7 JTF_DATE_TABLE
1038: , p5_a8 JTF_VARCHAR2_TABLE_100
1039: , p5_a9 JTF_VARCHAR2_TABLE_500
1040: , p5_a10 JTF_VARCHAR2_TABLE_500
1041: , p5_a11 JTF_VARCHAR2_TABLE_500
1042: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 1311: , p5_a2 JTF_VARCHAR2_TABLE_100

1307: , x_msg_count out nocopy NUMBER
1308: , x_msg_data out nocopy VARCHAR2
1309: , p5_a0 JTF_NUMBER_TABLE
1310: , p5_a1 JTF_NUMBER_TABLE
1311: , p5_a2 JTF_VARCHAR2_TABLE_100
1312: , p5_a3 JTF_NUMBER_TABLE
1313: , p5_a4 JTF_NUMBER_TABLE
1314: , p5_a5 JTF_NUMBER_TABLE
1315: , p5_a6 JTF_NUMBER_TABLE

Line 1317: , p5_a8 JTF_VARCHAR2_TABLE_100

1313: , p5_a4 JTF_NUMBER_TABLE
1314: , p5_a5 JTF_NUMBER_TABLE
1315: , p5_a6 JTF_NUMBER_TABLE
1316: , p5_a7 JTF_DATE_TABLE
1317: , p5_a8 JTF_VARCHAR2_TABLE_100
1318: , p5_a9 JTF_VARCHAR2_TABLE_500
1319: , p5_a10 JTF_VARCHAR2_TABLE_500
1320: , p5_a11 JTF_VARCHAR2_TABLE_500
1321: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 1345: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

1341: , p5_a32 JTF_DATE_TABLE
1342: , p5_a33 JTF_NUMBER_TABLE
1343: , p6_a0 out nocopy JTF_NUMBER_TABLE
1344: , p6_a1 out nocopy JTF_NUMBER_TABLE
1345: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1346: , p6_a3 out nocopy JTF_NUMBER_TABLE
1347: , p6_a4 out nocopy JTF_NUMBER_TABLE
1348: , p6_a5 out nocopy JTF_NUMBER_TABLE
1349: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 1351: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

1347: , p6_a4 out nocopy JTF_NUMBER_TABLE
1348: , p6_a5 out nocopy JTF_NUMBER_TABLE
1349: , p6_a6 out nocopy JTF_NUMBER_TABLE
1350: , p6_a7 out nocopy JTF_DATE_TABLE
1351: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1352: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
1353: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1354: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1355: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 1591: , p5_a2 JTF_VARCHAR2_TABLE_100

1587: , x_msg_count out nocopy NUMBER
1588: , x_msg_data out nocopy VARCHAR2
1589: , p5_a0 JTF_NUMBER_TABLE
1590: , p5_a1 JTF_NUMBER_TABLE
1591: , p5_a2 JTF_VARCHAR2_TABLE_100
1592: , p5_a3 JTF_NUMBER_TABLE
1593: , p5_a4 JTF_NUMBER_TABLE
1594: , p5_a5 JTF_NUMBER_TABLE
1595: , p5_a6 JTF_NUMBER_TABLE

Line 1597: , p5_a8 JTF_VARCHAR2_TABLE_100

1593: , p5_a4 JTF_NUMBER_TABLE
1594: , p5_a5 JTF_NUMBER_TABLE
1595: , p5_a6 JTF_NUMBER_TABLE
1596: , p5_a7 JTF_DATE_TABLE
1597: , p5_a8 JTF_VARCHAR2_TABLE_100
1598: , p5_a9 JTF_VARCHAR2_TABLE_500
1599: , p5_a10 JTF_VARCHAR2_TABLE_500
1600: , p5_a11 JTF_VARCHAR2_TABLE_500
1601: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 1798: , p5_a2 JTF_VARCHAR2_TABLE_100

1794: , x_msg_count out nocopy NUMBER
1795: , x_msg_data out nocopy VARCHAR2
1796: , p5_a0 JTF_NUMBER_TABLE
1797: , p5_a1 JTF_NUMBER_TABLE
1798: , p5_a2 JTF_VARCHAR2_TABLE_100
1799: , p5_a3 JTF_NUMBER_TABLE
1800: , p5_a4 JTF_NUMBER_TABLE
1801: , p5_a5 JTF_NUMBER_TABLE
1802: , p5_a6 JTF_NUMBER_TABLE

Line 1804: , p5_a8 JTF_VARCHAR2_TABLE_100

1800: , p5_a4 JTF_NUMBER_TABLE
1801: , p5_a5 JTF_NUMBER_TABLE
1802: , p5_a6 JTF_NUMBER_TABLE
1803: , p5_a7 JTF_DATE_TABLE
1804: , p5_a8 JTF_VARCHAR2_TABLE_100
1805: , p5_a9 JTF_VARCHAR2_TABLE_500
1806: , p5_a10 JTF_VARCHAR2_TABLE_500
1807: , p5_a11 JTF_VARCHAR2_TABLE_500
1808: , p5_a12 JTF_VARCHAR2_TABLE_500