DBA Data[Home] [Help]

APPS.OKL_CRT_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 23: , a1 JTF_VARCHAR2_TABLE_200

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_crt_pvt.crtv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE

Line 30: , a8 JTF_VARCHAR2_TABLE_2000

26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_2000
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE

Line 116: , a1 out nocopy JTF_VARCHAR2_TABLE_200

112: end if;
113: end if;
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t okl_crt_pvt.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_VARCHAR2_TABLE_200
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_DATE_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE

Line 123: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

119: , a4 out nocopy JTF_NUMBER_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_VARCHAR2_TABLE_100
123: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
124: , a9 out nocopy JTF_DATE_TABLE
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_NUMBER_TABLE
127: , a12 out nocopy JTF_NUMBER_TABLE

Line 158: a1 := JTF_VARCHAR2_TABLE_200();

154: ddindx binary_integer; indx binary_integer;
155: begin
156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_VARCHAR2_TABLE_200();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_DATE_TABLE();
161: a4 := JTF_NUMBER_TABLE();
162: a5 := JTF_NUMBER_TABLE();

Line 165: a8 := JTF_VARCHAR2_TABLE_2000();

161: a4 := JTF_NUMBER_TABLE();
162: a5 := JTF_NUMBER_TABLE();
163: a6 := JTF_NUMBER_TABLE();
164: a7 := JTF_VARCHAR2_TABLE_100();
165: a8 := JTF_VARCHAR2_TABLE_2000();
166: a9 := JTF_DATE_TABLE();
167: a10 := JTF_VARCHAR2_TABLE_100();
168: a11 := JTF_NUMBER_TABLE();
169: a12 := JTF_NUMBER_TABLE();

Line 197: a1 := JTF_VARCHAR2_TABLE_200();

193: a36 := JTF_DATE_TABLE();
194: a37 := JTF_NUMBER_TABLE();
195: else
196: a0 := JTF_NUMBER_TABLE();
197: a1 := JTF_VARCHAR2_TABLE_200();
198: a2 := JTF_VARCHAR2_TABLE_100();
199: a3 := JTF_DATE_TABLE();
200: a4 := JTF_NUMBER_TABLE();
201: a5 := JTF_NUMBER_TABLE();

Line 204: a8 := JTF_VARCHAR2_TABLE_2000();

200: a4 := JTF_NUMBER_TABLE();
201: a5 := JTF_NUMBER_TABLE();
202: a6 := JTF_NUMBER_TABLE();
203: a7 := JTF_VARCHAR2_TABLE_100();
204: a8 := JTF_VARCHAR2_TABLE_2000();
205: a9 := JTF_DATE_TABLE();
206: a10 := JTF_VARCHAR2_TABLE_100();
207: a11 := JTF_NUMBER_TABLE();
208: a12 := JTF_NUMBER_TABLE();

Line 325: , a1 JTF_VARCHAR2_TABLE_200

321: end if;
322: end rosetta_table_copy_out_p2;
323:
324: procedure rosetta_table_copy_in_p5(t out nocopy okl_crt_pvt.crt_tbl_type, a0 JTF_NUMBER_TABLE
325: , a1 JTF_VARCHAR2_TABLE_200
326: , a2 JTF_VARCHAR2_TABLE_100
327: , a3 JTF_DATE_TABLE
328: , a4 JTF_NUMBER_TABLE
329: , a5 JTF_NUMBER_TABLE

Line 332: , a8 JTF_VARCHAR2_TABLE_2000

328: , a4 JTF_NUMBER_TABLE
329: , a5 JTF_NUMBER_TABLE
330: , a6 JTF_NUMBER_TABLE
331: , a7 JTF_VARCHAR2_TABLE_100
332: , a8 JTF_VARCHAR2_TABLE_2000
333: , a9 JTF_DATE_TABLE
334: , a10 JTF_NUMBER_TABLE
335: , a11 JTF_NUMBER_TABLE
336: , a12 JTF_NUMBER_TABLE

Line 418: , a1 out nocopy JTF_VARCHAR2_TABLE_200

414: end if;
415: end if;
416: end rosetta_table_copy_in_p5;
417: procedure rosetta_table_copy_out_p5(t okl_crt_pvt.crt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
418: , a1 out nocopy JTF_VARCHAR2_TABLE_200
419: , a2 out nocopy JTF_VARCHAR2_TABLE_100
420: , a3 out nocopy JTF_DATE_TABLE
421: , a4 out nocopy JTF_NUMBER_TABLE
422: , a5 out nocopy JTF_NUMBER_TABLE

Line 425: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

421: , a4 out nocopy JTF_NUMBER_TABLE
422: , a5 out nocopy JTF_NUMBER_TABLE
423: , a6 out nocopy JTF_NUMBER_TABLE
424: , a7 out nocopy JTF_VARCHAR2_TABLE_100
425: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
426: , a9 out nocopy JTF_DATE_TABLE
427: , a10 out nocopy JTF_NUMBER_TABLE
428: , a11 out nocopy JTF_NUMBER_TABLE
429: , a12 out nocopy JTF_NUMBER_TABLE

Line 460: a1 := JTF_VARCHAR2_TABLE_200();

456: ddindx binary_integer; indx binary_integer;
457: begin
458: if t is null or t.count = 0 then
459: a0 := JTF_NUMBER_TABLE();
460: a1 := JTF_VARCHAR2_TABLE_200();
461: a2 := JTF_VARCHAR2_TABLE_100();
462: a3 := JTF_DATE_TABLE();
463: a4 := JTF_NUMBER_TABLE();
464: a5 := JTF_NUMBER_TABLE();

Line 467: a8 := JTF_VARCHAR2_TABLE_2000();

463: a4 := JTF_NUMBER_TABLE();
464: a5 := JTF_NUMBER_TABLE();
465: a6 := JTF_NUMBER_TABLE();
466: a7 := JTF_VARCHAR2_TABLE_100();
467: a8 := JTF_VARCHAR2_TABLE_2000();
468: a9 := JTF_DATE_TABLE();
469: a10 := JTF_NUMBER_TABLE();
470: a11 := JTF_NUMBER_TABLE();
471: a12 := JTF_NUMBER_TABLE();

Line 499: a1 := JTF_VARCHAR2_TABLE_200();

495: a36 := JTF_DATE_TABLE();
496: a37 := JTF_NUMBER_TABLE();
497: else
498: a0 := JTF_NUMBER_TABLE();
499: a1 := JTF_VARCHAR2_TABLE_200();
500: a2 := JTF_VARCHAR2_TABLE_100();
501: a3 := JTF_DATE_TABLE();
502: a4 := JTF_NUMBER_TABLE();
503: a5 := JTF_NUMBER_TABLE();

Line 506: a8 := JTF_VARCHAR2_TABLE_2000();

502: a4 := JTF_NUMBER_TABLE();
503: a5 := JTF_NUMBER_TABLE();
504: a6 := JTF_NUMBER_TABLE();
505: a7 := JTF_VARCHAR2_TABLE_100();
506: a8 := JTF_VARCHAR2_TABLE_2000();
507: a9 := JTF_DATE_TABLE();
508: a10 := JTF_NUMBER_TABLE();
509: a11 := JTF_NUMBER_TABLE();
510: a12 := JTF_NUMBER_TABLE();

Line 823: , p5_a1 JTF_VARCHAR2_TABLE_200

819: , x_return_status out nocopy VARCHAR2
820: , x_msg_count out nocopy NUMBER
821: , x_msg_data out nocopy VARCHAR2
822: , p5_a0 JTF_NUMBER_TABLE
823: , p5_a1 JTF_VARCHAR2_TABLE_200
824: , p5_a2 JTF_VARCHAR2_TABLE_100
825: , p5_a3 JTF_DATE_TABLE
826: , p5_a4 JTF_NUMBER_TABLE
827: , p5_a5 JTF_NUMBER_TABLE

Line 830: , p5_a8 JTF_VARCHAR2_TABLE_2000

826: , p5_a4 JTF_NUMBER_TABLE
827: , p5_a5 JTF_NUMBER_TABLE
828: , p5_a6 JTF_NUMBER_TABLE
829: , p5_a7 JTF_VARCHAR2_TABLE_100
830: , p5_a8 JTF_VARCHAR2_TABLE_2000
831: , p5_a9 JTF_DATE_TABLE
832: , p5_a10 JTF_VARCHAR2_TABLE_100
833: , p5_a11 JTF_NUMBER_TABLE
834: , p5_a12 JTF_NUMBER_TABLE

Line 861: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

857: , p5_a35 JTF_NUMBER_TABLE
858: , p5_a36 JTF_DATE_TABLE
859: , p5_a37 JTF_NUMBER_TABLE
860: , p6_a0 out nocopy JTF_NUMBER_TABLE
861: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
862: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
863: , p6_a3 out nocopy JTF_DATE_TABLE
864: , p6_a4 out nocopy JTF_NUMBER_TABLE
865: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 868: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000

864: , p6_a4 out nocopy JTF_NUMBER_TABLE
865: , p6_a5 out nocopy JTF_NUMBER_TABLE
866: , p6_a6 out nocopy JTF_NUMBER_TABLE
867: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
868: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
869: , p6_a9 out nocopy JTF_DATE_TABLE
870: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a11 out nocopy JTF_NUMBER_TABLE
872: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 1127: , p5_a1 JTF_VARCHAR2_TABLE_200

1123: , x_return_status out nocopy VARCHAR2
1124: , x_msg_count out nocopy NUMBER
1125: , x_msg_data out nocopy VARCHAR2
1126: , p5_a0 JTF_NUMBER_TABLE
1127: , p5_a1 JTF_VARCHAR2_TABLE_200
1128: , p5_a2 JTF_VARCHAR2_TABLE_100
1129: , p5_a3 JTF_DATE_TABLE
1130: , p5_a4 JTF_NUMBER_TABLE
1131: , p5_a5 JTF_NUMBER_TABLE

Line 1134: , p5_a8 JTF_VARCHAR2_TABLE_2000

1130: , p5_a4 JTF_NUMBER_TABLE
1131: , p5_a5 JTF_NUMBER_TABLE
1132: , p5_a6 JTF_NUMBER_TABLE
1133: , p5_a7 JTF_VARCHAR2_TABLE_100
1134: , p5_a8 JTF_VARCHAR2_TABLE_2000
1135: , p5_a9 JTF_DATE_TABLE
1136: , p5_a10 JTF_VARCHAR2_TABLE_100
1137: , p5_a11 JTF_NUMBER_TABLE
1138: , p5_a12 JTF_NUMBER_TABLE

Line 1430: , p5_a1 JTF_VARCHAR2_TABLE_200

1426: , x_return_status out nocopy VARCHAR2
1427: , x_msg_count out nocopy NUMBER
1428: , x_msg_data out nocopy VARCHAR2
1429: , p5_a0 JTF_NUMBER_TABLE
1430: , p5_a1 JTF_VARCHAR2_TABLE_200
1431: , p5_a2 JTF_VARCHAR2_TABLE_100
1432: , p5_a3 JTF_DATE_TABLE
1433: , p5_a4 JTF_NUMBER_TABLE
1434: , p5_a5 JTF_NUMBER_TABLE

Line 1437: , p5_a8 JTF_VARCHAR2_TABLE_2000

1433: , p5_a4 JTF_NUMBER_TABLE
1434: , p5_a5 JTF_NUMBER_TABLE
1435: , p5_a6 JTF_NUMBER_TABLE
1436: , p5_a7 JTF_VARCHAR2_TABLE_100
1437: , p5_a8 JTF_VARCHAR2_TABLE_2000
1438: , p5_a9 JTF_DATE_TABLE
1439: , p5_a10 JTF_VARCHAR2_TABLE_100
1440: , p5_a11 JTF_NUMBER_TABLE
1441: , p5_a12 JTF_NUMBER_TABLE

Line 1468: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

1464: , p5_a35 JTF_NUMBER_TABLE
1465: , p5_a36 JTF_DATE_TABLE
1466: , p5_a37 JTF_NUMBER_TABLE
1467: , p6_a0 out nocopy JTF_NUMBER_TABLE
1468: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1469: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1470: , p6_a3 out nocopy JTF_DATE_TABLE
1471: , p6_a4 out nocopy JTF_NUMBER_TABLE
1472: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 1475: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000

1471: , p6_a4 out nocopy JTF_NUMBER_TABLE
1472: , p6_a5 out nocopy JTF_NUMBER_TABLE
1473: , p6_a6 out nocopy JTF_NUMBER_TABLE
1474: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1475: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
1476: , p6_a9 out nocopy JTF_DATE_TABLE
1477: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1478: , p6_a11 out nocopy JTF_NUMBER_TABLE
1479: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 1734: , p5_a1 JTF_VARCHAR2_TABLE_200

1730: , x_return_status out nocopy VARCHAR2
1731: , x_msg_count out nocopy NUMBER
1732: , x_msg_data out nocopy VARCHAR2
1733: , p5_a0 JTF_NUMBER_TABLE
1734: , p5_a1 JTF_VARCHAR2_TABLE_200
1735: , p5_a2 JTF_VARCHAR2_TABLE_100
1736: , p5_a3 JTF_DATE_TABLE
1737: , p5_a4 JTF_NUMBER_TABLE
1738: , p5_a5 JTF_NUMBER_TABLE

Line 1741: , p5_a8 JTF_VARCHAR2_TABLE_2000

1737: , p5_a4 JTF_NUMBER_TABLE
1738: , p5_a5 JTF_NUMBER_TABLE
1739: , p5_a6 JTF_NUMBER_TABLE
1740: , p5_a7 JTF_VARCHAR2_TABLE_100
1741: , p5_a8 JTF_VARCHAR2_TABLE_2000
1742: , p5_a9 JTF_DATE_TABLE
1743: , p5_a10 JTF_VARCHAR2_TABLE_100
1744: , p5_a11 JTF_NUMBER_TABLE
1745: , p5_a12 JTF_NUMBER_TABLE

Line 1957: , p5_a1 JTF_VARCHAR2_TABLE_200

1953: , x_return_status out nocopy VARCHAR2
1954: , x_msg_count out nocopy NUMBER
1955: , x_msg_data out nocopy VARCHAR2
1956: , p5_a0 JTF_NUMBER_TABLE
1957: , p5_a1 JTF_VARCHAR2_TABLE_200
1958: , p5_a2 JTF_VARCHAR2_TABLE_100
1959: , p5_a3 JTF_DATE_TABLE
1960: , p5_a4 JTF_NUMBER_TABLE
1961: , p5_a5 JTF_NUMBER_TABLE

Line 1964: , p5_a8 JTF_VARCHAR2_TABLE_2000

1960: , p5_a4 JTF_NUMBER_TABLE
1961: , p5_a5 JTF_NUMBER_TABLE
1962: , p5_a6 JTF_NUMBER_TABLE
1963: , p5_a7 JTF_VARCHAR2_TABLE_100
1964: , p5_a8 JTF_VARCHAR2_TABLE_2000
1965: , p5_a9 JTF_DATE_TABLE
1966: , p5_a10 JTF_VARCHAR2_TABLE_100
1967: , p5_a11 JTF_NUMBER_TABLE
1968: , p5_a12 JTF_NUMBER_TABLE