DBA Data[Home] [Help]

APPS.OKL_STA_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_sta_pvt.sta_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
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_NUMBER_TABLE
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 96: , a3 out nocopy JTF_VARCHAR2_TABLE_100

92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t okl_sta_pvt.sta_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_NUMBER_TABLE
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_NUMBER_TABLE
98: , a5 out nocopy JTF_NUMBER_TABLE
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 99: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 127: a3 := JTF_VARCHAR2_TABLE_100();

123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_VARCHAR2_TABLE_500();

Line 130: a6 := JTF_VARCHAR2_TABLE_100();

126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_VARCHAR2_TABLE_500();
132: a8 := JTF_VARCHAR2_TABLE_500();
133: a9 := JTF_VARCHAR2_TABLE_500();
134: a10 := JTF_VARCHAR2_TABLE_500();

Line 155: a3 := JTF_VARCHAR2_TABLE_100();

151: else
152: a0 := JTF_NUMBER_TABLE();
153: a1 := JTF_NUMBER_TABLE();
154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_VARCHAR2_TABLE_100();
156: a4 := JTF_NUMBER_TABLE();
157: a5 := JTF_NUMBER_TABLE();
158: a6 := JTF_VARCHAR2_TABLE_100();
159: a7 := JTF_VARCHAR2_TABLE_500();

Line 158: a6 := JTF_VARCHAR2_TABLE_100();

154: a2 := JTF_NUMBER_TABLE();
155: a3 := JTF_VARCHAR2_TABLE_100();
156: a4 := JTF_NUMBER_TABLE();
157: a5 := JTF_NUMBER_TABLE();
158: a6 := JTF_VARCHAR2_TABLE_100();
159: a7 := JTF_VARCHAR2_TABLE_500();
160: a8 := JTF_VARCHAR2_TABLE_500();
161: a9 := JTF_VARCHAR2_TABLE_500();
162: a10 := JTF_VARCHAR2_TABLE_500();

Line 252: , a5 JTF_VARCHAR2_TABLE_100

248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_NUMBER_TABLE
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE
252: , a5 JTF_VARCHAR2_TABLE_100
253: , a6 JTF_VARCHAR2_TABLE_500
254: , a7 JTF_VARCHAR2_TABLE_500
255: , a8 JTF_VARCHAR2_TABLE_500
256: , a9 JTF_VARCHAR2_TABLE_500

Line 268: , a21 JTF_VARCHAR2_TABLE_100

264: , a17 JTF_VARCHAR2_TABLE_500
265: , a18 JTF_VARCHAR2_TABLE_500
266: , a19 JTF_VARCHAR2_TABLE_500
267: , a20 JTF_VARCHAR2_TABLE_500
268: , a21 JTF_VARCHAR2_TABLE_100
269: , a22 JTF_NUMBER_TABLE
270: , a23 JTF_DATE_TABLE
271: , a24 JTF_NUMBER_TABLE
272: , a25 JTF_DATE_TABLE

Line 323: , a5 out nocopy JTF_VARCHAR2_TABLE_100

319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE
323: , a5 out nocopy JTF_VARCHAR2_TABLE_100
324: , a6 out nocopy JTF_VARCHAR2_TABLE_500
325: , a7 out nocopy JTF_VARCHAR2_TABLE_500
326: , a8 out nocopy JTF_VARCHAR2_TABLE_500
327: , a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 339: , a21 out nocopy JTF_VARCHAR2_TABLE_100

335: , a17 out nocopy JTF_VARCHAR2_TABLE_500
336: , a18 out nocopy JTF_VARCHAR2_TABLE_500
337: , a19 out nocopy JTF_VARCHAR2_TABLE_500
338: , a20 out nocopy JTF_VARCHAR2_TABLE_500
339: , a21 out nocopy JTF_VARCHAR2_TABLE_100
340: , a22 out nocopy JTF_NUMBER_TABLE
341: , a23 out nocopy JTF_DATE_TABLE
342: , a24 out nocopy JTF_NUMBER_TABLE
343: , a25 out nocopy JTF_DATE_TABLE

Line 354: a5 := JTF_VARCHAR2_TABLE_100();

350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_NUMBER_TABLE();
353: a4 := JTF_NUMBER_TABLE();
354: a5 := JTF_VARCHAR2_TABLE_100();
355: a6 := JTF_VARCHAR2_TABLE_500();
356: a7 := JTF_VARCHAR2_TABLE_500();
357: a8 := JTF_VARCHAR2_TABLE_500();
358: a9 := JTF_VARCHAR2_TABLE_500();

Line 370: a21 := JTF_VARCHAR2_TABLE_100();

366: a17 := JTF_VARCHAR2_TABLE_500();
367: a18 := JTF_VARCHAR2_TABLE_500();
368: a19 := JTF_VARCHAR2_TABLE_500();
369: a20 := JTF_VARCHAR2_TABLE_500();
370: a21 := JTF_VARCHAR2_TABLE_100();
371: a22 := JTF_NUMBER_TABLE();
372: a23 := JTF_DATE_TABLE();
373: a24 := JTF_NUMBER_TABLE();
374: a25 := JTF_DATE_TABLE();

Line 382: a5 := JTF_VARCHAR2_TABLE_100();

378: a1 := JTF_NUMBER_TABLE();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_NUMBER_TABLE();
382: a5 := JTF_VARCHAR2_TABLE_100();
383: a6 := JTF_VARCHAR2_TABLE_500();
384: a7 := JTF_VARCHAR2_TABLE_500();
385: a8 := JTF_VARCHAR2_TABLE_500();
386: a9 := JTF_VARCHAR2_TABLE_500();

Line 398: a21 := JTF_VARCHAR2_TABLE_100();

394: a17 := JTF_VARCHAR2_TABLE_500();
395: a18 := JTF_VARCHAR2_TABLE_500();
396: a19 := JTF_VARCHAR2_TABLE_500();
397: a20 := JTF_VARCHAR2_TABLE_500();
398: a21 := JTF_VARCHAR2_TABLE_100();
399: a22 := JTF_NUMBER_TABLE();
400: a23 := JTF_DATE_TABLE();
401: a24 := JTF_NUMBER_TABLE();
402: a25 := JTF_DATE_TABLE();

Line 629: , p5_a5 JTF_VARCHAR2_TABLE_100

625: , p5_a1 JTF_NUMBER_TABLE
626: , p5_a2 JTF_NUMBER_TABLE
627: , p5_a3 JTF_NUMBER_TABLE
628: , p5_a4 JTF_NUMBER_TABLE
629: , p5_a5 JTF_VARCHAR2_TABLE_100
630: , p5_a6 JTF_VARCHAR2_TABLE_500
631: , p5_a7 JTF_VARCHAR2_TABLE_500
632: , p5_a8 JTF_VARCHAR2_TABLE_500
633: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 645: , p5_a21 JTF_VARCHAR2_TABLE_100

641: , p5_a17 JTF_VARCHAR2_TABLE_500
642: , p5_a18 JTF_VARCHAR2_TABLE_500
643: , p5_a19 JTF_VARCHAR2_TABLE_500
644: , p5_a20 JTF_VARCHAR2_TABLE_500
645: , p5_a21 JTF_VARCHAR2_TABLE_100
646: , p5_a22 JTF_NUMBER_TABLE
647: , p5_a23 JTF_DATE_TABLE
648: , p5_a24 JTF_NUMBER_TABLE
649: , p5_a25 JTF_DATE_TABLE

Line 656: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

652: , p6_a1 out nocopy JTF_NUMBER_TABLE
653: , p6_a2 out nocopy JTF_NUMBER_TABLE
654: , p6_a3 out nocopy JTF_NUMBER_TABLE
655: , p6_a4 out nocopy JTF_NUMBER_TABLE
656: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
657: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
658: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
659: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
660: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 672: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

668: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
669: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
670: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
671: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
672: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
673: , p6_a22 out nocopy JTF_NUMBER_TABLE
674: , p6_a23 out nocopy JTF_DATE_TABLE
675: , p6_a24 out nocopy JTF_NUMBER_TABLE
676: , p6_a25 out nocopy JTF_DATE_TABLE

Line 867: , p5_a5 JTF_VARCHAR2_TABLE_100

863: , p5_a1 JTF_NUMBER_TABLE
864: , p5_a2 JTF_NUMBER_TABLE
865: , p5_a3 JTF_NUMBER_TABLE
866: , p5_a4 JTF_NUMBER_TABLE
867: , p5_a5 JTF_VARCHAR2_TABLE_100
868: , p5_a6 JTF_VARCHAR2_TABLE_500
869: , p5_a7 JTF_VARCHAR2_TABLE_500
870: , p5_a8 JTF_VARCHAR2_TABLE_500
871: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 883: , p5_a21 JTF_VARCHAR2_TABLE_100

879: , p5_a17 JTF_VARCHAR2_TABLE_500
880: , p5_a18 JTF_VARCHAR2_TABLE_500
881: , p5_a19 JTF_VARCHAR2_TABLE_500
882: , p5_a20 JTF_VARCHAR2_TABLE_500
883: , p5_a21 JTF_VARCHAR2_TABLE_100
884: , p5_a22 JTF_NUMBER_TABLE
885: , p5_a23 JTF_DATE_TABLE
886: , p5_a24 JTF_NUMBER_TABLE
887: , p5_a25 JTF_DATE_TABLE

Line 1104: , p5_a5 JTF_VARCHAR2_TABLE_100

1100: , p5_a1 JTF_NUMBER_TABLE
1101: , p5_a2 JTF_NUMBER_TABLE
1102: , p5_a3 JTF_NUMBER_TABLE
1103: , p5_a4 JTF_NUMBER_TABLE
1104: , p5_a5 JTF_VARCHAR2_TABLE_100
1105: , p5_a6 JTF_VARCHAR2_TABLE_500
1106: , p5_a7 JTF_VARCHAR2_TABLE_500
1107: , p5_a8 JTF_VARCHAR2_TABLE_500
1108: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 1120: , p5_a21 JTF_VARCHAR2_TABLE_100

1116: , p5_a17 JTF_VARCHAR2_TABLE_500
1117: , p5_a18 JTF_VARCHAR2_TABLE_500
1118: , p5_a19 JTF_VARCHAR2_TABLE_500
1119: , p5_a20 JTF_VARCHAR2_TABLE_500
1120: , p5_a21 JTF_VARCHAR2_TABLE_100
1121: , p5_a22 JTF_NUMBER_TABLE
1122: , p5_a23 JTF_DATE_TABLE
1123: , p5_a24 JTF_NUMBER_TABLE
1124: , p5_a25 JTF_DATE_TABLE

Line 1131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_NUMBER_TABLE
1130: , p6_a4 out nocopy JTF_NUMBER_TABLE
1131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1132: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1133: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1134: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1135: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 1147: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

1143: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1144: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1145: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1146: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1147: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1148: , p6_a22 out nocopy JTF_NUMBER_TABLE
1149: , p6_a23 out nocopy JTF_DATE_TABLE
1150: , p6_a24 out nocopy JTF_NUMBER_TABLE
1151: , p6_a25 out nocopy JTF_DATE_TABLE

Line 1342: , p5_a5 JTF_VARCHAR2_TABLE_100

1338: , p5_a1 JTF_NUMBER_TABLE
1339: , p5_a2 JTF_NUMBER_TABLE
1340: , p5_a3 JTF_NUMBER_TABLE
1341: , p5_a4 JTF_NUMBER_TABLE
1342: , p5_a5 JTF_VARCHAR2_TABLE_100
1343: , p5_a6 JTF_VARCHAR2_TABLE_500
1344: , p5_a7 JTF_VARCHAR2_TABLE_500
1345: , p5_a8 JTF_VARCHAR2_TABLE_500
1346: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 1358: , p5_a21 JTF_VARCHAR2_TABLE_100

1354: , p5_a17 JTF_VARCHAR2_TABLE_500
1355: , p5_a18 JTF_VARCHAR2_TABLE_500
1356: , p5_a19 JTF_VARCHAR2_TABLE_500
1357: , p5_a20 JTF_VARCHAR2_TABLE_500
1358: , p5_a21 JTF_VARCHAR2_TABLE_100
1359: , p5_a22 JTF_NUMBER_TABLE
1360: , p5_a23 JTF_DATE_TABLE
1361: , p5_a24 JTF_NUMBER_TABLE
1362: , p5_a25 JTF_DATE_TABLE

Line 1521: , p5_a5 JTF_VARCHAR2_TABLE_100

1517: , p5_a1 JTF_NUMBER_TABLE
1518: , p5_a2 JTF_NUMBER_TABLE
1519: , p5_a3 JTF_NUMBER_TABLE
1520: , p5_a4 JTF_NUMBER_TABLE
1521: , p5_a5 JTF_VARCHAR2_TABLE_100
1522: , p5_a6 JTF_VARCHAR2_TABLE_500
1523: , p5_a7 JTF_VARCHAR2_TABLE_500
1524: , p5_a8 JTF_VARCHAR2_TABLE_500
1525: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 1537: , p5_a21 JTF_VARCHAR2_TABLE_100

1533: , p5_a17 JTF_VARCHAR2_TABLE_500
1534: , p5_a18 JTF_VARCHAR2_TABLE_500
1535: , p5_a19 JTF_VARCHAR2_TABLE_500
1536: , p5_a20 JTF_VARCHAR2_TABLE_500
1537: , p5_a21 JTF_VARCHAR2_TABLE_100
1538: , p5_a22 JTF_NUMBER_TABLE
1539: , p5_a23 JTF_DATE_TABLE
1540: , p5_a24 JTF_NUMBER_TABLE
1541: , p5_a25 JTF_DATE_TABLE