DBA Data[Home] [Help]

APPS.OKL_CAH_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_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

Line 27: , a5 JTF_VARCHAR2_TABLE_2000

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
30: , a8 JTF_VARCHAR2_TABLE_500
31: , a9 JTF_VARCHAR2_TABLE_500

Line 96: , a1 out nocopy JTF_VARCHAR2_TABLE_200

92: end if;
93: end if;
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

Line 100: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

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
103: , a8 out nocopy JTF_VARCHAR2_TABLE_500
104: , a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 128: a1 := JTF_VARCHAR2_TABLE_200();

124: ddindx binary_integer; indx binary_integer;
125: begin
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();

Line 132: a5 := JTF_VARCHAR2_TABLE_2000();

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();
135: a8 := JTF_VARCHAR2_TABLE_500();
136: a9 := JTF_VARCHAR2_TABLE_500();

Line 157: a1 := JTF_VARCHAR2_TABLE_200();

153: a26 := JTF_DATE_TABLE();
154: a27 := JTF_NUMBER_TABLE();
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();

Line 161: a5 := JTF_VARCHAR2_TABLE_2000();

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();
164: a8 := JTF_VARCHAR2_TABLE_500();
165: a9 := JTF_VARCHAR2_TABLE_500();

Line 256: , a2 JTF_VARCHAR2_TABLE_200

252: end rosetta_table_copy_out_p2;
253:
254: procedure rosetta_table_copy_in_p5(t out nocopy okl_cah_pvt.cahv_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 257: , a3 JTF_VARCHAR2_TABLE_2000

253:
254: procedure rosetta_table_copy_in_p5(t out nocopy okl_cah_pvt.cahv_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 329: , a2 out nocopy JTF_VARCHAR2_TABLE_200

325: end if;
326: end rosetta_table_copy_in_p5;
327: procedure rosetta_table_copy_out_p5(t okl_cah_pvt.cahv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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

Line 330: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

326: end rosetta_table_copy_in_p5;
327: procedure rosetta_table_copy_out_p5(t okl_cah_pvt.cahv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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

Line 361: a2 := JTF_VARCHAR2_TABLE_200();

357: begin
358: if t is null or t.count = 0 then
359: a0 := JTF_NUMBER_TABLE();
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();

Line 362: a3 := JTF_VARCHAR2_TABLE_2000();

358: if t is null or t.count = 0 then
359: a0 := JTF_NUMBER_TABLE();
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();

Line 390: a2 := JTF_VARCHAR2_TABLE_200();

386: a27 := JTF_NUMBER_TABLE();
387: else
388: a0 := JTF_NUMBER_TABLE();
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();

Line 391: a3 := JTF_VARCHAR2_TABLE_2000();

387: else
388: a0 := JTF_NUMBER_TABLE();
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();

Line 644: , p5_a2 JTF_VARCHAR2_TABLE_200

640: , x_msg_count out nocopy NUMBER
641: , x_msg_data out nocopy VARCHAR2
642: , p5_a0 JTF_NUMBER_TABLE
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

Line 645: , p5_a3 JTF_VARCHAR2_TABLE_2000

641: , x_msg_data out nocopy VARCHAR2
642: , p5_a0 JTF_NUMBER_TABLE
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

Line 672: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

668: , p5_a26 JTF_DATE_TABLE
669: , p5_a27 JTF_NUMBER_TABLE
670: , p6_a0 out nocopy JTF_NUMBER_TABLE
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

Line 673: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

669: , p5_a27 JTF_NUMBER_TABLE
670: , p6_a0 out nocopy JTF_NUMBER_TABLE
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

Line 888: , p5_a2 JTF_VARCHAR2_TABLE_200

884: , x_msg_count out nocopy NUMBER
885: , x_msg_data out nocopy VARCHAR2
886: , p5_a0 JTF_NUMBER_TABLE
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

Line 889: , p5_a3 JTF_VARCHAR2_TABLE_2000

885: , x_msg_data out nocopy VARCHAR2
886: , p5_a0 JTF_NUMBER_TABLE
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

Line 1131: , p5_a2 JTF_VARCHAR2_TABLE_200

1127: , x_msg_count out nocopy NUMBER
1128: , x_msg_data out nocopy VARCHAR2
1129: , p5_a0 JTF_NUMBER_TABLE
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

Line 1132: , p5_a3 JTF_VARCHAR2_TABLE_2000

1128: , x_msg_data out nocopy VARCHAR2
1129: , p5_a0 JTF_NUMBER_TABLE
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

Line 1159: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

1155: , p5_a26 JTF_DATE_TABLE
1156: , p5_a27 JTF_NUMBER_TABLE
1157: , p6_a0 out nocopy JTF_NUMBER_TABLE
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

Line 1160: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

1156: , p5_a27 JTF_NUMBER_TABLE
1157: , p6_a0 out nocopy JTF_NUMBER_TABLE
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

Line 1375: , p5_a2 JTF_VARCHAR2_TABLE_200

1371: , x_msg_count out nocopy NUMBER
1372: , x_msg_data out nocopy VARCHAR2
1373: , p5_a0 JTF_NUMBER_TABLE
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

Line 1376: , p5_a3 JTF_VARCHAR2_TABLE_2000

1372: , x_msg_data out nocopy VARCHAR2
1373: , p5_a0 JTF_NUMBER_TABLE
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

Line 1558: , p5_a2 JTF_VARCHAR2_TABLE_200

1554: , x_msg_count out nocopy NUMBER
1555: , x_msg_data out nocopy VARCHAR2
1556: , p5_a0 JTF_NUMBER_TABLE
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

Line 1559: , p5_a3 JTF_VARCHAR2_TABLE_2000

1555: , x_msg_data out nocopy VARCHAR2
1556: , p5_a0 JTF_NUMBER_TABLE
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