15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_route_pvt.mr_route_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_2000
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_2000
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_2000
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_2000
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200
34: , a18 JTF_VARCHAR2_TABLE_200
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_DATE_TABLE
49: , a33 JTF_NUMBER_TABLE
50: , a34 JTF_NUMBER_TABLE
51: , a35 JTF_VARCHAR2_TABLE_100
52: ) as
53: ddindx binary_integer; indx binary_integer;
54: begin
55: if a0 is not null and a0.count > 0 then
104: end rosetta_table_copy_in_p1;
105: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_route_pvt.mr_route_tbl, a0 out nocopy JTF_NUMBER_TABLE
106: , a1 out nocopy JTF_NUMBER_TABLE
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_VARCHAR2_TABLE_100
109: , a4 out nocopy JTF_NUMBER_TABLE
110: , a5 out nocopy JTF_NUMBER_TABLE
111: , a6 out nocopy JTF_VARCHAR2_TABLE_100
112: , a7 out nocopy JTF_NUMBER_TABLE
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_VARCHAR2_TABLE_100
109: , a4 out nocopy JTF_NUMBER_TABLE
110: , a5 out nocopy JTF_NUMBER_TABLE
111: , a6 out nocopy JTF_VARCHAR2_TABLE_100
112: , a7 out nocopy JTF_NUMBER_TABLE
113: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
114: , a9 out nocopy JTF_VARCHAR2_TABLE_100
115: , a10 out nocopy JTF_VARCHAR2_TABLE_100
110: , a5 out nocopy JTF_NUMBER_TABLE
111: , a6 out nocopy JTF_VARCHAR2_TABLE_100
112: , a7 out nocopy JTF_NUMBER_TABLE
113: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
114: , a9 out nocopy JTF_VARCHAR2_TABLE_100
115: , a10 out nocopy JTF_VARCHAR2_TABLE_100
116: , a11 out nocopy JTF_NUMBER_TABLE
117: , a12 out nocopy JTF_VARCHAR2_TABLE_100
118: , a13 out nocopy JTF_VARCHAR2_TABLE_100
111: , a6 out nocopy JTF_VARCHAR2_TABLE_100
112: , a7 out nocopy JTF_NUMBER_TABLE
113: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
114: , a9 out nocopy JTF_VARCHAR2_TABLE_100
115: , a10 out nocopy JTF_VARCHAR2_TABLE_100
116: , a11 out nocopy JTF_NUMBER_TABLE
117: , a12 out nocopy JTF_VARCHAR2_TABLE_100
118: , a13 out nocopy JTF_VARCHAR2_TABLE_100
119: , a14 out nocopy JTF_VARCHAR2_TABLE_100
113: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
114: , a9 out nocopy JTF_VARCHAR2_TABLE_100
115: , a10 out nocopy JTF_VARCHAR2_TABLE_100
116: , a11 out nocopy JTF_NUMBER_TABLE
117: , a12 out nocopy JTF_VARCHAR2_TABLE_100
118: , a13 out nocopy JTF_VARCHAR2_TABLE_100
119: , a14 out nocopy JTF_VARCHAR2_TABLE_100
120: , a15 out nocopy JTF_VARCHAR2_TABLE_200
121: , a16 out nocopy JTF_VARCHAR2_TABLE_200
114: , a9 out nocopy JTF_VARCHAR2_TABLE_100
115: , a10 out nocopy JTF_VARCHAR2_TABLE_100
116: , a11 out nocopy JTF_NUMBER_TABLE
117: , a12 out nocopy JTF_VARCHAR2_TABLE_100
118: , a13 out nocopy JTF_VARCHAR2_TABLE_100
119: , a14 out nocopy JTF_VARCHAR2_TABLE_100
120: , a15 out nocopy JTF_VARCHAR2_TABLE_200
121: , a16 out nocopy JTF_VARCHAR2_TABLE_200
122: , a17 out nocopy JTF_VARCHAR2_TABLE_200
115: , a10 out nocopy JTF_VARCHAR2_TABLE_100
116: , a11 out nocopy JTF_NUMBER_TABLE
117: , a12 out nocopy JTF_VARCHAR2_TABLE_100
118: , a13 out nocopy JTF_VARCHAR2_TABLE_100
119: , a14 out nocopy JTF_VARCHAR2_TABLE_100
120: , a15 out nocopy JTF_VARCHAR2_TABLE_200
121: , a16 out nocopy JTF_VARCHAR2_TABLE_200
122: , a17 out nocopy JTF_VARCHAR2_TABLE_200
123: , a18 out nocopy JTF_VARCHAR2_TABLE_200
136: , a31 out nocopy JTF_NUMBER_TABLE
137: , a32 out nocopy JTF_DATE_TABLE
138: , a33 out nocopy JTF_NUMBER_TABLE
139: , a34 out nocopy JTF_NUMBER_TABLE
140: , a35 out nocopy JTF_VARCHAR2_TABLE_100
141: ) as
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_NUMBER_TABLE();
148: a3 := JTF_VARCHAR2_TABLE_100();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_VARCHAR2_TABLE_100();
152: a7 := JTF_NUMBER_TABLE();
147: a2 := JTF_NUMBER_TABLE();
148: a3 := JTF_VARCHAR2_TABLE_100();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_VARCHAR2_TABLE_100();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_VARCHAR2_TABLE_2000();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_VARCHAR2_TABLE_100();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_VARCHAR2_TABLE_100();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_VARCHAR2_TABLE_2000();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_VARCHAR2_TABLE_100();
156: a11 := JTF_NUMBER_TABLE();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();
151: a6 := JTF_VARCHAR2_TABLE_100();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_VARCHAR2_TABLE_2000();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_VARCHAR2_TABLE_100();
156: a11 := JTF_NUMBER_TABLE();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();
159: a14 := JTF_VARCHAR2_TABLE_100();
153: a8 := JTF_VARCHAR2_TABLE_2000();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_VARCHAR2_TABLE_100();
156: a11 := JTF_NUMBER_TABLE();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();
159: a14 := JTF_VARCHAR2_TABLE_100();
160: a15 := JTF_VARCHAR2_TABLE_200();
161: a16 := JTF_VARCHAR2_TABLE_200();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_VARCHAR2_TABLE_100();
156: a11 := JTF_NUMBER_TABLE();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();
159: a14 := JTF_VARCHAR2_TABLE_100();
160: a15 := JTF_VARCHAR2_TABLE_200();
161: a16 := JTF_VARCHAR2_TABLE_200();
162: a17 := JTF_VARCHAR2_TABLE_200();
155: a10 := JTF_VARCHAR2_TABLE_100();
156: a11 := JTF_NUMBER_TABLE();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();
159: a14 := JTF_VARCHAR2_TABLE_100();
160: a15 := JTF_VARCHAR2_TABLE_200();
161: a16 := JTF_VARCHAR2_TABLE_200();
162: a17 := JTF_VARCHAR2_TABLE_200();
163: a18 := JTF_VARCHAR2_TABLE_200();
176: a31 := JTF_NUMBER_TABLE();
177: a32 := JTF_DATE_TABLE();
178: a33 := JTF_NUMBER_TABLE();
179: a34 := JTF_NUMBER_TABLE();
180: a35 := JTF_VARCHAR2_TABLE_100();
181: else
182: a0 := JTF_NUMBER_TABLE();
183: a1 := JTF_NUMBER_TABLE();
184: a2 := JTF_NUMBER_TABLE();
181: else
182: a0 := JTF_NUMBER_TABLE();
183: a1 := JTF_NUMBER_TABLE();
184: a2 := JTF_NUMBER_TABLE();
185: a3 := JTF_VARCHAR2_TABLE_100();
186: a4 := JTF_NUMBER_TABLE();
187: a5 := JTF_NUMBER_TABLE();
188: a6 := JTF_VARCHAR2_TABLE_100();
189: a7 := JTF_NUMBER_TABLE();
184: a2 := JTF_NUMBER_TABLE();
185: a3 := JTF_VARCHAR2_TABLE_100();
186: a4 := JTF_NUMBER_TABLE();
187: a5 := JTF_NUMBER_TABLE();
188: a6 := JTF_VARCHAR2_TABLE_100();
189: a7 := JTF_NUMBER_TABLE();
190: a8 := JTF_VARCHAR2_TABLE_2000();
191: a9 := JTF_VARCHAR2_TABLE_100();
192: a10 := JTF_VARCHAR2_TABLE_100();
187: a5 := JTF_NUMBER_TABLE();
188: a6 := JTF_VARCHAR2_TABLE_100();
189: a7 := JTF_NUMBER_TABLE();
190: a8 := JTF_VARCHAR2_TABLE_2000();
191: a9 := JTF_VARCHAR2_TABLE_100();
192: a10 := JTF_VARCHAR2_TABLE_100();
193: a11 := JTF_NUMBER_TABLE();
194: a12 := JTF_VARCHAR2_TABLE_100();
195: a13 := JTF_VARCHAR2_TABLE_100();
188: a6 := JTF_VARCHAR2_TABLE_100();
189: a7 := JTF_NUMBER_TABLE();
190: a8 := JTF_VARCHAR2_TABLE_2000();
191: a9 := JTF_VARCHAR2_TABLE_100();
192: a10 := JTF_VARCHAR2_TABLE_100();
193: a11 := JTF_NUMBER_TABLE();
194: a12 := JTF_VARCHAR2_TABLE_100();
195: a13 := JTF_VARCHAR2_TABLE_100();
196: a14 := JTF_VARCHAR2_TABLE_100();
190: a8 := JTF_VARCHAR2_TABLE_2000();
191: a9 := JTF_VARCHAR2_TABLE_100();
192: a10 := JTF_VARCHAR2_TABLE_100();
193: a11 := JTF_NUMBER_TABLE();
194: a12 := JTF_VARCHAR2_TABLE_100();
195: a13 := JTF_VARCHAR2_TABLE_100();
196: a14 := JTF_VARCHAR2_TABLE_100();
197: a15 := JTF_VARCHAR2_TABLE_200();
198: a16 := JTF_VARCHAR2_TABLE_200();
191: a9 := JTF_VARCHAR2_TABLE_100();
192: a10 := JTF_VARCHAR2_TABLE_100();
193: a11 := JTF_NUMBER_TABLE();
194: a12 := JTF_VARCHAR2_TABLE_100();
195: a13 := JTF_VARCHAR2_TABLE_100();
196: a14 := JTF_VARCHAR2_TABLE_100();
197: a15 := JTF_VARCHAR2_TABLE_200();
198: a16 := JTF_VARCHAR2_TABLE_200();
199: a17 := JTF_VARCHAR2_TABLE_200();
192: a10 := JTF_VARCHAR2_TABLE_100();
193: a11 := JTF_NUMBER_TABLE();
194: a12 := JTF_VARCHAR2_TABLE_100();
195: a13 := JTF_VARCHAR2_TABLE_100();
196: a14 := JTF_VARCHAR2_TABLE_100();
197: a15 := JTF_VARCHAR2_TABLE_200();
198: a16 := JTF_VARCHAR2_TABLE_200();
199: a17 := JTF_VARCHAR2_TABLE_200();
200: a18 := JTF_VARCHAR2_TABLE_200();
213: a31 := JTF_NUMBER_TABLE();
214: a32 := JTF_DATE_TABLE();
215: a33 := JTF_NUMBER_TABLE();
216: a34 := JTF_NUMBER_TABLE();
217: a35 := JTF_VARCHAR2_TABLE_100();
218: if t.count > 0 then
219: a0.extend(t.count);
220: a1.extend(t.count);
221: a2.extend(t.count);
312: , x_msg_data out nocopy VARCHAR2
313: , p9_a0 in out nocopy JTF_NUMBER_TABLE
314: , p9_a1 in out nocopy JTF_NUMBER_TABLE
315: , p9_a2 in out nocopy JTF_NUMBER_TABLE
316: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p9_a4 in out nocopy JTF_NUMBER_TABLE
318: , p9_a5 in out nocopy JTF_NUMBER_TABLE
319: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
320: , p9_a7 in out nocopy JTF_NUMBER_TABLE
315: , p9_a2 in out nocopy JTF_NUMBER_TABLE
316: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p9_a4 in out nocopy JTF_NUMBER_TABLE
318: , p9_a5 in out nocopy JTF_NUMBER_TABLE
319: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
320: , p9_a7 in out nocopy JTF_NUMBER_TABLE
321: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_2000
322: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p9_a5 in out nocopy JTF_NUMBER_TABLE
319: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
320: , p9_a7 in out nocopy JTF_NUMBER_TABLE
321: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_2000
322: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
324: , p9_a11 in out nocopy JTF_NUMBER_TABLE
325: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
319: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
320: , p9_a7 in out nocopy JTF_NUMBER_TABLE
321: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_2000
322: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
324: , p9_a11 in out nocopy JTF_NUMBER_TABLE
325: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
327: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
321: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_2000
322: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
324: , p9_a11 in out nocopy JTF_NUMBER_TABLE
325: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
327: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
328: , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200
329: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_200
322: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
324: , p9_a11 in out nocopy JTF_NUMBER_TABLE
325: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
327: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
328: , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200
329: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_200
330: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
323: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
324: , p9_a11 in out nocopy JTF_NUMBER_TABLE
325: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
327: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
328: , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200
329: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_200
330: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
331: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
344: , p9_a31 in out nocopy JTF_NUMBER_TABLE
345: , p9_a32 in out nocopy JTF_DATE_TABLE
346: , p9_a33 in out nocopy JTF_NUMBER_TABLE
347: , p9_a34 in out nocopy JTF_NUMBER_TABLE
348: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
349: )
350:
351: as
352: ddp_x_mr_route_tbl ahl_fmp_mr_route_pvt.mr_route_tbl;