3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_osp_shipment_pub.sernum_change_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
42: procedure rosetta_table_copy_out_p1(t ahl_osp_shipment_pub.sernum_change_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_100
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_100
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
57: a0 := JTF_VARCHAR2_TABLE_100();
58: a1 := JTF_VARCHAR2_TABLE_100();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_VARCHAR2_TABLE_100();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_VARCHAR2_TABLE_100();
58: a1 := JTF_VARCHAR2_TABLE_100();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_VARCHAR2_TABLE_100();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_VARCHAR2_TABLE_100();
66: a9 := JTF_VARCHAR2_TABLE_100();
69: a0 := JTF_VARCHAR2_TABLE_100();
70: a1 := JTF_VARCHAR2_TABLE_100();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_VARCHAR2_TABLE_100();
73: a4 := JTF_NUMBER_TABLE();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_VARCHAR2_TABLE_100();
77: a8 := JTF_VARCHAR2_TABLE_100();
70: a1 := JTF_VARCHAR2_TABLE_100();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_VARCHAR2_TABLE_100();
73: a4 := JTF_NUMBER_TABLE();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_VARCHAR2_TABLE_100();
77: a8 := JTF_VARCHAR2_TABLE_100();
78: a9 := JTF_VARCHAR2_TABLE_100();
112: end if;
113: end if;
114: end rosetta_table_copy_out_p1;
115:
116: procedure rosetta_table_copy_in_p4(t out nocopy ahl_osp_shipment_pub.ship_line_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_VARCHAR2_TABLE_300
120: , a4 JTF_NUMBER_TABLE
113: end if;
114: end rosetta_table_copy_out_p1;
115:
116: procedure rosetta_table_copy_in_p4(t out nocopy ahl_osp_shipment_pub.ship_line_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_VARCHAR2_TABLE_300
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_VARCHAR2_TABLE_300
114: end rosetta_table_copy_out_p1;
115:
116: procedure rosetta_table_copy_in_p4(t out nocopy ahl_osp_shipment_pub.ship_line_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_VARCHAR2_TABLE_300
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_VARCHAR2_TABLE_300
122: , a6 JTF_VARCHAR2_TABLE_100
116: procedure rosetta_table_copy_in_p4(t out nocopy ahl_osp_shipment_pub.ship_line_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_VARCHAR2_TABLE_300
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_VARCHAR2_TABLE_300
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_NUMBER_TABLE
124: , a8 JTF_VARCHAR2_TABLE_300
119: , a3 JTF_VARCHAR2_TABLE_300
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_VARCHAR2_TABLE_300
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_NUMBER_TABLE
124: , a8 JTF_VARCHAR2_TABLE_300
125: , a9 JTF_NUMBER_TABLE
126: , a10 JTF_VARCHAR2_TABLE_300
127: , a11 JTF_VARCHAR2_TABLE_100
121: , a5 JTF_VARCHAR2_TABLE_300
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_NUMBER_TABLE
124: , a8 JTF_VARCHAR2_TABLE_300
125: , a9 JTF_NUMBER_TABLE
126: , a10 JTF_VARCHAR2_TABLE_300
127: , a11 JTF_VARCHAR2_TABLE_100
128: , a12 JTF_NUMBER_TABLE
129: , a13 JTF_NUMBER_TABLE
124: , a8 JTF_VARCHAR2_TABLE_300
125: , a9 JTF_NUMBER_TABLE
126: , a10 JTF_VARCHAR2_TABLE_300
127: , a11 JTF_VARCHAR2_TABLE_100
128: , a12 JTF_NUMBER_TABLE
129: , a13 JTF_NUMBER_TABLE
130: , a14 JTF_VARCHAR2_TABLE_300
131: , a15 JTF_VARCHAR2_TABLE_100
132: , a16 JTF_VARCHAR2_TABLE_100
125: , a9 JTF_NUMBER_TABLE
126: , a10 JTF_VARCHAR2_TABLE_300
127: , a11 JTF_VARCHAR2_TABLE_100
128: , a12 JTF_NUMBER_TABLE
129: , a13 JTF_NUMBER_TABLE
130: , a14 JTF_VARCHAR2_TABLE_300
131: , a15 JTF_VARCHAR2_TABLE_100
132: , a16 JTF_VARCHAR2_TABLE_100
133: , a17 JTF_NUMBER_TABLE
129: , a13 JTF_NUMBER_TABLE
130: , a14 JTF_VARCHAR2_TABLE_300
131: , a15 JTF_VARCHAR2_TABLE_100
132: , a16 JTF_VARCHAR2_TABLE_100
133: , a17 JTF_NUMBER_TABLE
134: , a18 JTF_VARCHAR2_TABLE_100
135: , a19 JTF_NUMBER_TABLE
136: , a20 JTF_NUMBER_TABLE
137: , a21 JTF_VARCHAR2_TABLE_100
131: , a15 JTF_VARCHAR2_TABLE_100
132: , a16 JTF_VARCHAR2_TABLE_100
133: , a17 JTF_NUMBER_TABLE
134: , a18 JTF_VARCHAR2_TABLE_100
135: , a19 JTF_NUMBER_TABLE
136: , a20 JTF_NUMBER_TABLE
137: , a21 JTF_VARCHAR2_TABLE_100
138: , a22 JTF_VARCHAR2_TABLE_100
139: , a23 JTF_VARCHAR2_TABLE_300
132: , a16 JTF_VARCHAR2_TABLE_100
133: , a17 JTF_NUMBER_TABLE
134: , a18 JTF_VARCHAR2_TABLE_100
135: , a19 JTF_NUMBER_TABLE
136: , a20 JTF_NUMBER_TABLE
137: , a21 JTF_VARCHAR2_TABLE_100
138: , a22 JTF_VARCHAR2_TABLE_100
139: , a23 JTF_VARCHAR2_TABLE_300
140: , a24 JTF_DATE_TABLE
139: , a23 JTF_VARCHAR2_TABLE_300
140: , a24 JTF_DATE_TABLE
141: , a25 JTF_VARCHAR2_TABLE_2000
142: , a26 JTF_VARCHAR2_TABLE_300
143: , a27 JTF_NUMBER_TABLE
144: , a28 JTF_VARCHAR2_TABLE_300
145: , a29 JTF_VARCHAR2_TABLE_100
146: , a30 JTF_VARCHAR2_TABLE_300
147: , a31 JTF_VARCHAR2_TABLE_100
151: , a35 JTF_VARCHAR2_TABLE_300
152: , a36 JTF_VARCHAR2_TABLE_100
153: , a37 JTF_VARCHAR2_TABLE_300
154: , a38 JTF_VARCHAR2_TABLE_100
155: , a39 JTF_NUMBER_TABLE
156: , a40 JTF_VARCHAR2_TABLE_100
157: , a41 JTF_NUMBER_TABLE
158: , a42 JTF_VARCHAR2_TABLE_100
159: , a43 JTF_NUMBER_TABLE
153: , a37 JTF_VARCHAR2_TABLE_300
154: , a38 JTF_VARCHAR2_TABLE_100
155: , a39 JTF_NUMBER_TABLE
156: , a40 JTF_VARCHAR2_TABLE_100
157: , a41 JTF_NUMBER_TABLE
158: , a42 JTF_VARCHAR2_TABLE_100
159: , a43 JTF_NUMBER_TABLE
160: , a44 JTF_VARCHAR2_TABLE_100
161: ) as
155: , a39 JTF_NUMBER_TABLE
156: , a40 JTF_VARCHAR2_TABLE_100
157: , a41 JTF_NUMBER_TABLE
158: , a42 JTF_VARCHAR2_TABLE_100
159: , a43 JTF_NUMBER_TABLE
160: , a44 JTF_VARCHAR2_TABLE_100
161: ) as
162: ddindx binary_integer; indx binary_integer;
163: begin
219: end loop;
220: end if;
221: end if;
222: end rosetta_table_copy_in_p4;
223: procedure rosetta_table_copy_out_p4(t ahl_osp_shipment_pub.ship_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
224: , a1 out nocopy JTF_NUMBER_TABLE
225: , a2 out nocopy JTF_NUMBER_TABLE
226: , a3 out nocopy JTF_VARCHAR2_TABLE_300
227: , a4 out nocopy JTF_NUMBER_TABLE
220: end if;
221: end if;
222: end rosetta_table_copy_in_p4;
223: procedure rosetta_table_copy_out_p4(t ahl_osp_shipment_pub.ship_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
224: , a1 out nocopy JTF_NUMBER_TABLE
225: , a2 out nocopy JTF_NUMBER_TABLE
226: , a3 out nocopy JTF_VARCHAR2_TABLE_300
227: , a4 out nocopy JTF_NUMBER_TABLE
228: , a5 out nocopy JTF_VARCHAR2_TABLE_300
221: end if;
222: end rosetta_table_copy_in_p4;
223: procedure rosetta_table_copy_out_p4(t ahl_osp_shipment_pub.ship_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
224: , a1 out nocopy JTF_NUMBER_TABLE
225: , a2 out nocopy JTF_NUMBER_TABLE
226: , a3 out nocopy JTF_VARCHAR2_TABLE_300
227: , a4 out nocopy JTF_NUMBER_TABLE
228: , a5 out nocopy JTF_VARCHAR2_TABLE_300
229: , a6 out nocopy JTF_VARCHAR2_TABLE_100
223: procedure rosetta_table_copy_out_p4(t ahl_osp_shipment_pub.ship_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
224: , a1 out nocopy JTF_NUMBER_TABLE
225: , a2 out nocopy JTF_NUMBER_TABLE
226: , a3 out nocopy JTF_VARCHAR2_TABLE_300
227: , a4 out nocopy JTF_NUMBER_TABLE
228: , a5 out nocopy JTF_VARCHAR2_TABLE_300
229: , a6 out nocopy JTF_VARCHAR2_TABLE_100
230: , a7 out nocopy JTF_NUMBER_TABLE
231: , a8 out nocopy JTF_VARCHAR2_TABLE_300
226: , a3 out nocopy JTF_VARCHAR2_TABLE_300
227: , a4 out nocopy JTF_NUMBER_TABLE
228: , a5 out nocopy JTF_VARCHAR2_TABLE_300
229: , a6 out nocopy JTF_VARCHAR2_TABLE_100
230: , a7 out nocopy JTF_NUMBER_TABLE
231: , a8 out nocopy JTF_VARCHAR2_TABLE_300
232: , a9 out nocopy JTF_NUMBER_TABLE
233: , a10 out nocopy JTF_VARCHAR2_TABLE_300
234: , a11 out nocopy JTF_VARCHAR2_TABLE_100
228: , a5 out nocopy JTF_VARCHAR2_TABLE_300
229: , a6 out nocopy JTF_VARCHAR2_TABLE_100
230: , a7 out nocopy JTF_NUMBER_TABLE
231: , a8 out nocopy JTF_VARCHAR2_TABLE_300
232: , a9 out nocopy JTF_NUMBER_TABLE
233: , a10 out nocopy JTF_VARCHAR2_TABLE_300
234: , a11 out nocopy JTF_VARCHAR2_TABLE_100
235: , a12 out nocopy JTF_NUMBER_TABLE
236: , a13 out nocopy JTF_NUMBER_TABLE
231: , a8 out nocopy JTF_VARCHAR2_TABLE_300
232: , a9 out nocopy JTF_NUMBER_TABLE
233: , a10 out nocopy JTF_VARCHAR2_TABLE_300
234: , a11 out nocopy JTF_VARCHAR2_TABLE_100
235: , a12 out nocopy JTF_NUMBER_TABLE
236: , a13 out nocopy JTF_NUMBER_TABLE
237: , a14 out nocopy JTF_VARCHAR2_TABLE_300
238: , a15 out nocopy JTF_VARCHAR2_TABLE_100
239: , a16 out nocopy JTF_VARCHAR2_TABLE_100
232: , a9 out nocopy JTF_NUMBER_TABLE
233: , a10 out nocopy JTF_VARCHAR2_TABLE_300
234: , a11 out nocopy JTF_VARCHAR2_TABLE_100
235: , a12 out nocopy JTF_NUMBER_TABLE
236: , a13 out nocopy JTF_NUMBER_TABLE
237: , a14 out nocopy JTF_VARCHAR2_TABLE_300
238: , a15 out nocopy JTF_VARCHAR2_TABLE_100
239: , a16 out nocopy JTF_VARCHAR2_TABLE_100
240: , a17 out nocopy JTF_NUMBER_TABLE
236: , a13 out nocopy JTF_NUMBER_TABLE
237: , a14 out nocopy JTF_VARCHAR2_TABLE_300
238: , a15 out nocopy JTF_VARCHAR2_TABLE_100
239: , a16 out nocopy JTF_VARCHAR2_TABLE_100
240: , a17 out nocopy JTF_NUMBER_TABLE
241: , a18 out nocopy JTF_VARCHAR2_TABLE_100
242: , a19 out nocopy JTF_NUMBER_TABLE
243: , a20 out nocopy JTF_NUMBER_TABLE
244: , a21 out nocopy JTF_VARCHAR2_TABLE_100
238: , a15 out nocopy JTF_VARCHAR2_TABLE_100
239: , a16 out nocopy JTF_VARCHAR2_TABLE_100
240: , a17 out nocopy JTF_NUMBER_TABLE
241: , a18 out nocopy JTF_VARCHAR2_TABLE_100
242: , a19 out nocopy JTF_NUMBER_TABLE
243: , a20 out nocopy JTF_NUMBER_TABLE
244: , a21 out nocopy JTF_VARCHAR2_TABLE_100
245: , a22 out nocopy JTF_VARCHAR2_TABLE_100
246: , a23 out nocopy JTF_VARCHAR2_TABLE_300
239: , a16 out nocopy JTF_VARCHAR2_TABLE_100
240: , a17 out nocopy JTF_NUMBER_TABLE
241: , a18 out nocopy JTF_VARCHAR2_TABLE_100
242: , a19 out nocopy JTF_NUMBER_TABLE
243: , a20 out nocopy JTF_NUMBER_TABLE
244: , a21 out nocopy JTF_VARCHAR2_TABLE_100
245: , a22 out nocopy JTF_VARCHAR2_TABLE_100
246: , a23 out nocopy JTF_VARCHAR2_TABLE_300
247: , a24 out nocopy JTF_DATE_TABLE
246: , a23 out nocopy JTF_VARCHAR2_TABLE_300
247: , a24 out nocopy JTF_DATE_TABLE
248: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
249: , a26 out nocopy JTF_VARCHAR2_TABLE_300
250: , a27 out nocopy JTF_NUMBER_TABLE
251: , a28 out nocopy JTF_VARCHAR2_TABLE_300
252: , a29 out nocopy JTF_VARCHAR2_TABLE_100
253: , a30 out nocopy JTF_VARCHAR2_TABLE_300
254: , a31 out nocopy JTF_VARCHAR2_TABLE_100
258: , a35 out nocopy JTF_VARCHAR2_TABLE_300
259: , a36 out nocopy JTF_VARCHAR2_TABLE_100
260: , a37 out nocopy JTF_VARCHAR2_TABLE_300
261: , a38 out nocopy JTF_VARCHAR2_TABLE_100
262: , a39 out nocopy JTF_NUMBER_TABLE
263: , a40 out nocopy JTF_VARCHAR2_TABLE_100
264: , a41 out nocopy JTF_NUMBER_TABLE
265: , a42 out nocopy JTF_VARCHAR2_TABLE_100
266: , a43 out nocopy JTF_NUMBER_TABLE
260: , a37 out nocopy JTF_VARCHAR2_TABLE_300
261: , a38 out nocopy JTF_VARCHAR2_TABLE_100
262: , a39 out nocopy JTF_NUMBER_TABLE
263: , a40 out nocopy JTF_VARCHAR2_TABLE_100
264: , a41 out nocopy JTF_NUMBER_TABLE
265: , a42 out nocopy JTF_VARCHAR2_TABLE_100
266: , a43 out nocopy JTF_NUMBER_TABLE
267: , a44 out nocopy JTF_VARCHAR2_TABLE_100
268: ) as
262: , a39 out nocopy JTF_NUMBER_TABLE
263: , a40 out nocopy JTF_VARCHAR2_TABLE_100
264: , a41 out nocopy JTF_NUMBER_TABLE
265: , a42 out nocopy JTF_VARCHAR2_TABLE_100
266: , a43 out nocopy JTF_NUMBER_TABLE
267: , a44 out nocopy JTF_VARCHAR2_TABLE_100
268: ) as
269: ddindx binary_integer; indx binary_integer;
270: begin
268: ) as
269: ddindx binary_integer; indx binary_integer;
270: begin
271: if t is null or t.count = 0 then
272: a0 := JTF_NUMBER_TABLE();
273: a1 := JTF_NUMBER_TABLE();
274: a2 := JTF_NUMBER_TABLE();
275: a3 := JTF_VARCHAR2_TABLE_300();
276: a4 := JTF_NUMBER_TABLE();
269: ddindx binary_integer; indx binary_integer;
270: begin
271: if t is null or t.count = 0 then
272: a0 := JTF_NUMBER_TABLE();
273: a1 := JTF_NUMBER_TABLE();
274: a2 := JTF_NUMBER_TABLE();
275: a3 := JTF_VARCHAR2_TABLE_300();
276: a4 := JTF_NUMBER_TABLE();
277: a5 := JTF_VARCHAR2_TABLE_300();
270: begin
271: if t is null or t.count = 0 then
272: a0 := JTF_NUMBER_TABLE();
273: a1 := JTF_NUMBER_TABLE();
274: a2 := JTF_NUMBER_TABLE();
275: a3 := JTF_VARCHAR2_TABLE_300();
276: a4 := JTF_NUMBER_TABLE();
277: a5 := JTF_VARCHAR2_TABLE_300();
278: a6 := JTF_VARCHAR2_TABLE_100();
272: a0 := JTF_NUMBER_TABLE();
273: a1 := JTF_NUMBER_TABLE();
274: a2 := JTF_NUMBER_TABLE();
275: a3 := JTF_VARCHAR2_TABLE_300();
276: a4 := JTF_NUMBER_TABLE();
277: a5 := JTF_VARCHAR2_TABLE_300();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_NUMBER_TABLE();
280: a8 := JTF_VARCHAR2_TABLE_300();
275: a3 := JTF_VARCHAR2_TABLE_300();
276: a4 := JTF_NUMBER_TABLE();
277: a5 := JTF_VARCHAR2_TABLE_300();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_NUMBER_TABLE();
280: a8 := JTF_VARCHAR2_TABLE_300();
281: a9 := JTF_NUMBER_TABLE();
282: a10 := JTF_VARCHAR2_TABLE_300();
283: a11 := JTF_VARCHAR2_TABLE_100();
277: a5 := JTF_VARCHAR2_TABLE_300();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_NUMBER_TABLE();
280: a8 := JTF_VARCHAR2_TABLE_300();
281: a9 := JTF_NUMBER_TABLE();
282: a10 := JTF_VARCHAR2_TABLE_300();
283: a11 := JTF_VARCHAR2_TABLE_100();
284: a12 := JTF_NUMBER_TABLE();
285: a13 := JTF_NUMBER_TABLE();
280: a8 := JTF_VARCHAR2_TABLE_300();
281: a9 := JTF_NUMBER_TABLE();
282: a10 := JTF_VARCHAR2_TABLE_300();
283: a11 := JTF_VARCHAR2_TABLE_100();
284: a12 := JTF_NUMBER_TABLE();
285: a13 := JTF_NUMBER_TABLE();
286: a14 := JTF_VARCHAR2_TABLE_300();
287: a15 := JTF_VARCHAR2_TABLE_100();
288: a16 := JTF_VARCHAR2_TABLE_100();
281: a9 := JTF_NUMBER_TABLE();
282: a10 := JTF_VARCHAR2_TABLE_300();
283: a11 := JTF_VARCHAR2_TABLE_100();
284: a12 := JTF_NUMBER_TABLE();
285: a13 := JTF_NUMBER_TABLE();
286: a14 := JTF_VARCHAR2_TABLE_300();
287: a15 := JTF_VARCHAR2_TABLE_100();
288: a16 := JTF_VARCHAR2_TABLE_100();
289: a17 := JTF_NUMBER_TABLE();
285: a13 := JTF_NUMBER_TABLE();
286: a14 := JTF_VARCHAR2_TABLE_300();
287: a15 := JTF_VARCHAR2_TABLE_100();
288: a16 := JTF_VARCHAR2_TABLE_100();
289: a17 := JTF_NUMBER_TABLE();
290: a18 := JTF_VARCHAR2_TABLE_100();
291: a19 := JTF_NUMBER_TABLE();
292: a20 := JTF_NUMBER_TABLE();
293: a21 := JTF_VARCHAR2_TABLE_100();
287: a15 := JTF_VARCHAR2_TABLE_100();
288: a16 := JTF_VARCHAR2_TABLE_100();
289: a17 := JTF_NUMBER_TABLE();
290: a18 := JTF_VARCHAR2_TABLE_100();
291: a19 := JTF_NUMBER_TABLE();
292: a20 := JTF_NUMBER_TABLE();
293: a21 := JTF_VARCHAR2_TABLE_100();
294: a22 := JTF_VARCHAR2_TABLE_100();
295: a23 := JTF_VARCHAR2_TABLE_300();
288: a16 := JTF_VARCHAR2_TABLE_100();
289: a17 := JTF_NUMBER_TABLE();
290: a18 := JTF_VARCHAR2_TABLE_100();
291: a19 := JTF_NUMBER_TABLE();
292: a20 := JTF_NUMBER_TABLE();
293: a21 := JTF_VARCHAR2_TABLE_100();
294: a22 := JTF_VARCHAR2_TABLE_100();
295: a23 := JTF_VARCHAR2_TABLE_300();
296: a24 := JTF_DATE_TABLE();
295: a23 := JTF_VARCHAR2_TABLE_300();
296: a24 := JTF_DATE_TABLE();
297: a25 := JTF_VARCHAR2_TABLE_2000();
298: a26 := JTF_VARCHAR2_TABLE_300();
299: a27 := JTF_NUMBER_TABLE();
300: a28 := JTF_VARCHAR2_TABLE_300();
301: a29 := JTF_VARCHAR2_TABLE_100();
302: a30 := JTF_VARCHAR2_TABLE_300();
303: a31 := JTF_VARCHAR2_TABLE_100();
307: a35 := JTF_VARCHAR2_TABLE_300();
308: a36 := JTF_VARCHAR2_TABLE_100();
309: a37 := JTF_VARCHAR2_TABLE_300();
310: a38 := JTF_VARCHAR2_TABLE_100();
311: a39 := JTF_NUMBER_TABLE();
312: a40 := JTF_VARCHAR2_TABLE_100();
313: a41 := JTF_NUMBER_TABLE();
314: a42 := JTF_VARCHAR2_TABLE_100();
315: a43 := JTF_NUMBER_TABLE();
309: a37 := JTF_VARCHAR2_TABLE_300();
310: a38 := JTF_VARCHAR2_TABLE_100();
311: a39 := JTF_NUMBER_TABLE();
312: a40 := JTF_VARCHAR2_TABLE_100();
313: a41 := JTF_NUMBER_TABLE();
314: a42 := JTF_VARCHAR2_TABLE_100();
315: a43 := JTF_NUMBER_TABLE();
316: a44 := JTF_VARCHAR2_TABLE_100();
317: else
311: a39 := JTF_NUMBER_TABLE();
312: a40 := JTF_VARCHAR2_TABLE_100();
313: a41 := JTF_NUMBER_TABLE();
314: a42 := JTF_VARCHAR2_TABLE_100();
315: a43 := JTF_NUMBER_TABLE();
316: a44 := JTF_VARCHAR2_TABLE_100();
317: else
318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_NUMBER_TABLE();
314: a42 := JTF_VARCHAR2_TABLE_100();
315: a43 := JTF_NUMBER_TABLE();
316: a44 := JTF_VARCHAR2_TABLE_100();
317: else
318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_NUMBER_TABLE();
320: a2 := JTF_NUMBER_TABLE();
321: a3 := JTF_VARCHAR2_TABLE_300();
322: a4 := JTF_NUMBER_TABLE();
315: a43 := JTF_NUMBER_TABLE();
316: a44 := JTF_VARCHAR2_TABLE_100();
317: else
318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_NUMBER_TABLE();
320: a2 := JTF_NUMBER_TABLE();
321: a3 := JTF_VARCHAR2_TABLE_300();
322: a4 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_300();
316: a44 := JTF_VARCHAR2_TABLE_100();
317: else
318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_NUMBER_TABLE();
320: a2 := JTF_NUMBER_TABLE();
321: a3 := JTF_VARCHAR2_TABLE_300();
322: a4 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_300();
324: a6 := JTF_VARCHAR2_TABLE_100();
318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_NUMBER_TABLE();
320: a2 := JTF_NUMBER_TABLE();
321: a3 := JTF_VARCHAR2_TABLE_300();
322: a4 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_300();
324: a6 := JTF_VARCHAR2_TABLE_100();
325: a7 := JTF_NUMBER_TABLE();
326: a8 := JTF_VARCHAR2_TABLE_300();
321: a3 := JTF_VARCHAR2_TABLE_300();
322: a4 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_300();
324: a6 := JTF_VARCHAR2_TABLE_100();
325: a7 := JTF_NUMBER_TABLE();
326: a8 := JTF_VARCHAR2_TABLE_300();
327: a9 := JTF_NUMBER_TABLE();
328: a10 := JTF_VARCHAR2_TABLE_300();
329: a11 := JTF_VARCHAR2_TABLE_100();
323: a5 := JTF_VARCHAR2_TABLE_300();
324: a6 := JTF_VARCHAR2_TABLE_100();
325: a7 := JTF_NUMBER_TABLE();
326: a8 := JTF_VARCHAR2_TABLE_300();
327: a9 := JTF_NUMBER_TABLE();
328: a10 := JTF_VARCHAR2_TABLE_300();
329: a11 := JTF_VARCHAR2_TABLE_100();
330: a12 := JTF_NUMBER_TABLE();
331: a13 := JTF_NUMBER_TABLE();
326: a8 := JTF_VARCHAR2_TABLE_300();
327: a9 := JTF_NUMBER_TABLE();
328: a10 := JTF_VARCHAR2_TABLE_300();
329: a11 := JTF_VARCHAR2_TABLE_100();
330: a12 := JTF_NUMBER_TABLE();
331: a13 := JTF_NUMBER_TABLE();
332: a14 := JTF_VARCHAR2_TABLE_300();
333: a15 := JTF_VARCHAR2_TABLE_100();
334: a16 := JTF_VARCHAR2_TABLE_100();
327: a9 := JTF_NUMBER_TABLE();
328: a10 := JTF_VARCHAR2_TABLE_300();
329: a11 := JTF_VARCHAR2_TABLE_100();
330: a12 := JTF_NUMBER_TABLE();
331: a13 := JTF_NUMBER_TABLE();
332: a14 := JTF_VARCHAR2_TABLE_300();
333: a15 := JTF_VARCHAR2_TABLE_100();
334: a16 := JTF_VARCHAR2_TABLE_100();
335: a17 := JTF_NUMBER_TABLE();
331: a13 := JTF_NUMBER_TABLE();
332: a14 := JTF_VARCHAR2_TABLE_300();
333: a15 := JTF_VARCHAR2_TABLE_100();
334: a16 := JTF_VARCHAR2_TABLE_100();
335: a17 := JTF_NUMBER_TABLE();
336: a18 := JTF_VARCHAR2_TABLE_100();
337: a19 := JTF_NUMBER_TABLE();
338: a20 := JTF_NUMBER_TABLE();
339: a21 := JTF_VARCHAR2_TABLE_100();
333: a15 := JTF_VARCHAR2_TABLE_100();
334: a16 := JTF_VARCHAR2_TABLE_100();
335: a17 := JTF_NUMBER_TABLE();
336: a18 := JTF_VARCHAR2_TABLE_100();
337: a19 := JTF_NUMBER_TABLE();
338: a20 := JTF_NUMBER_TABLE();
339: a21 := JTF_VARCHAR2_TABLE_100();
340: a22 := JTF_VARCHAR2_TABLE_100();
341: a23 := JTF_VARCHAR2_TABLE_300();
334: a16 := JTF_VARCHAR2_TABLE_100();
335: a17 := JTF_NUMBER_TABLE();
336: a18 := JTF_VARCHAR2_TABLE_100();
337: a19 := JTF_NUMBER_TABLE();
338: a20 := JTF_NUMBER_TABLE();
339: a21 := JTF_VARCHAR2_TABLE_100();
340: a22 := JTF_VARCHAR2_TABLE_100();
341: a23 := JTF_VARCHAR2_TABLE_300();
342: a24 := JTF_DATE_TABLE();
341: a23 := JTF_VARCHAR2_TABLE_300();
342: a24 := JTF_DATE_TABLE();
343: a25 := JTF_VARCHAR2_TABLE_2000();
344: a26 := JTF_VARCHAR2_TABLE_300();
345: a27 := JTF_NUMBER_TABLE();
346: a28 := JTF_VARCHAR2_TABLE_300();
347: a29 := JTF_VARCHAR2_TABLE_100();
348: a30 := JTF_VARCHAR2_TABLE_300();
349: a31 := JTF_VARCHAR2_TABLE_100();
353: a35 := JTF_VARCHAR2_TABLE_300();
354: a36 := JTF_VARCHAR2_TABLE_100();
355: a37 := JTF_VARCHAR2_TABLE_300();
356: a38 := JTF_VARCHAR2_TABLE_100();
357: a39 := JTF_NUMBER_TABLE();
358: a40 := JTF_VARCHAR2_TABLE_100();
359: a41 := JTF_NUMBER_TABLE();
360: a42 := JTF_VARCHAR2_TABLE_100();
361: a43 := JTF_NUMBER_TABLE();
355: a37 := JTF_VARCHAR2_TABLE_300();
356: a38 := JTF_VARCHAR2_TABLE_100();
357: a39 := JTF_NUMBER_TABLE();
358: a40 := JTF_VARCHAR2_TABLE_100();
359: a41 := JTF_NUMBER_TABLE();
360: a42 := JTF_VARCHAR2_TABLE_100();
361: a43 := JTF_NUMBER_TABLE();
362: a44 := JTF_VARCHAR2_TABLE_100();
363: if t.count > 0 then
357: a39 := JTF_NUMBER_TABLE();
358: a40 := JTF_VARCHAR2_TABLE_100();
359: a41 := JTF_NUMBER_TABLE();
360: a42 := JTF_VARCHAR2_TABLE_100();
361: a43 := JTF_NUMBER_TABLE();
362: a44 := JTF_VARCHAR2_TABLE_100();
363: if t.count > 0 then
364: a0.extend(t.count);
365: a1.extend(t.count);
463: end if;
464: end if;
465: end rosetta_table_copy_out_p4;
466:
467: procedure rosetta_table_copy_in_p5(t out nocopy ahl_osp_shipment_pub.ship_id_tbl_type, a0 JTF_NUMBER_TABLE) as
468: ddindx binary_integer; indx binary_integer;
469: begin
470: if a0 is not null and a0.count > 0 then
471: if a0.count > 0 then
481: end loop;
482: end if;
483: end if;
484: end rosetta_table_copy_in_p5;
485: procedure rosetta_table_copy_out_p5(t ahl_osp_shipment_pub.ship_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
486: ddindx binary_integer; indx binary_integer;
487: begin
488: if t is null or t.count = 0 then
489: a0 := JTF_NUMBER_TABLE();
485: procedure rosetta_table_copy_out_p5(t ahl_osp_shipment_pub.ship_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
486: ddindx binary_integer; indx binary_integer;
487: begin
488: if t is null or t.count = 0 then
489: a0 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: if t.count > 0 then
493: a0.extend(t.count);
487: begin
488: if t is null or t.count = 0 then
489: a0 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: if t.count > 0 then
493: a0.extend(t.count);
494: ddindx := t.first;
495: indx := 1;
545: , p5_a32 in out nocopy VARCHAR2
546: , p5_a33 in out nocopy VARCHAR2
547: , p5_a34 in out nocopy VARCHAR2
548: , p5_a35 in out nocopy VARCHAR2
549: , p6_a0 in out nocopy JTF_NUMBER_TABLE
550: , p6_a1 in out nocopy JTF_NUMBER_TABLE
551: , p6_a2 in out nocopy JTF_NUMBER_TABLE
552: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_300
553: , p6_a4 in out nocopy JTF_NUMBER_TABLE
546: , p5_a33 in out nocopy VARCHAR2
547: , p5_a34 in out nocopy VARCHAR2
548: , p5_a35 in out nocopy VARCHAR2
549: , p6_a0 in out nocopy JTF_NUMBER_TABLE
550: , p6_a1 in out nocopy JTF_NUMBER_TABLE
551: , p6_a2 in out nocopy JTF_NUMBER_TABLE
552: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_300
553: , p6_a4 in out nocopy JTF_NUMBER_TABLE
554: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
547: , p5_a34 in out nocopy VARCHAR2
548: , p5_a35 in out nocopy VARCHAR2
549: , p6_a0 in out nocopy JTF_NUMBER_TABLE
550: , p6_a1 in out nocopy JTF_NUMBER_TABLE
551: , p6_a2 in out nocopy JTF_NUMBER_TABLE
552: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_300
553: , p6_a4 in out nocopy JTF_NUMBER_TABLE
554: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
555: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
549: , p6_a0 in out nocopy JTF_NUMBER_TABLE
550: , p6_a1 in out nocopy JTF_NUMBER_TABLE
551: , p6_a2 in out nocopy JTF_NUMBER_TABLE
552: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_300
553: , p6_a4 in out nocopy JTF_NUMBER_TABLE
554: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
555: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
556: , p6_a7 in out nocopy JTF_NUMBER_TABLE
557: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_300
552: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_300
553: , p6_a4 in out nocopy JTF_NUMBER_TABLE
554: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
555: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
556: , p6_a7 in out nocopy JTF_NUMBER_TABLE
557: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_300
558: , p6_a9 in out nocopy JTF_NUMBER_TABLE
559: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300
560: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
554: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
555: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
556: , p6_a7 in out nocopy JTF_NUMBER_TABLE
557: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_300
558: , p6_a9 in out nocopy JTF_NUMBER_TABLE
559: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300
560: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
561: , p6_a12 in out nocopy JTF_NUMBER_TABLE
562: , p6_a13 in out nocopy JTF_NUMBER_TABLE
557: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_300
558: , p6_a9 in out nocopy JTF_NUMBER_TABLE
559: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300
560: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
561: , p6_a12 in out nocopy JTF_NUMBER_TABLE
562: , p6_a13 in out nocopy JTF_NUMBER_TABLE
563: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_300
564: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_100
565: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
558: , p6_a9 in out nocopy JTF_NUMBER_TABLE
559: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300
560: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
561: , p6_a12 in out nocopy JTF_NUMBER_TABLE
562: , p6_a13 in out nocopy JTF_NUMBER_TABLE
563: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_300
564: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_100
565: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
566: , p6_a17 in out nocopy JTF_NUMBER_TABLE
562: , p6_a13 in out nocopy JTF_NUMBER_TABLE
563: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_300
564: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_100
565: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
566: , p6_a17 in out nocopy JTF_NUMBER_TABLE
567: , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a19 in out nocopy JTF_NUMBER_TABLE
569: , p6_a20 in out nocopy JTF_NUMBER_TABLE
570: , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_100
564: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_100
565: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
566: , p6_a17 in out nocopy JTF_NUMBER_TABLE
567: , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a19 in out nocopy JTF_NUMBER_TABLE
569: , p6_a20 in out nocopy JTF_NUMBER_TABLE
570: , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_100
571: , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_100
572: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_300
565: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
566: , p6_a17 in out nocopy JTF_NUMBER_TABLE
567: , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a19 in out nocopy JTF_NUMBER_TABLE
569: , p6_a20 in out nocopy JTF_NUMBER_TABLE
570: , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_100
571: , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_100
572: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_300
573: , p6_a24 in out nocopy JTF_DATE_TABLE
572: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_300
573: , p6_a24 in out nocopy JTF_DATE_TABLE
574: , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_2000
575: , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_300
576: , p6_a27 in out nocopy JTF_NUMBER_TABLE
577: , p6_a28 in out nocopy JTF_VARCHAR2_TABLE_300
578: , p6_a29 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p6_a30 in out nocopy JTF_VARCHAR2_TABLE_300
580: , p6_a31 in out nocopy JTF_VARCHAR2_TABLE_100
584: , p6_a35 in out nocopy JTF_VARCHAR2_TABLE_300
585: , p6_a36 in out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a37 in out nocopy JTF_VARCHAR2_TABLE_300
587: , p6_a38 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a39 in out nocopy JTF_NUMBER_TABLE
589: , p6_a40 in out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a41 in out nocopy JTF_NUMBER_TABLE
591: , p6_a42 in out nocopy JTF_VARCHAR2_TABLE_100
592: , p6_a43 in out nocopy JTF_NUMBER_TABLE
586: , p6_a37 in out nocopy JTF_VARCHAR2_TABLE_300
587: , p6_a38 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a39 in out nocopy JTF_NUMBER_TABLE
589: , p6_a40 in out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a41 in out nocopy JTF_NUMBER_TABLE
591: , p6_a42 in out nocopy JTF_VARCHAR2_TABLE_100
592: , p6_a43 in out nocopy JTF_NUMBER_TABLE
593: , p6_a44 in out nocopy JTF_VARCHAR2_TABLE_100
594: , x_return_status out nocopy VARCHAR2
588: , p6_a39 in out nocopy JTF_NUMBER_TABLE
589: , p6_a40 in out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a41 in out nocopy JTF_NUMBER_TABLE
591: , p6_a42 in out nocopy JTF_VARCHAR2_TABLE_100
592: , p6_a43 in out nocopy JTF_NUMBER_TABLE
593: , p6_a44 in out nocopy JTF_VARCHAR2_TABLE_100
594: , x_return_status out nocopy VARCHAR2
595: , x_msg_count out nocopy NUMBER
596: , x_msg_data out nocopy VARCHAR2
804: procedure book_order(p_api_version NUMBER
805: , p_init_msg_list VARCHAR2
806: , p_commit VARCHAR2
807: , p_validation_level NUMBER
808: , p_oe_header_tbl JTF_NUMBER_TABLE
809: , x_return_status out nocopy VARCHAR2
810: , x_msg_count out nocopy NUMBER
811: , x_msg_data out nocopy VARCHAR2
812: )
850: , p_init_msg_list VARCHAR2
851: , p_commit VARCHAR2
852: , p_validation_level NUMBER
853: , p_oe_header_id NUMBER
854: , p_oe_lines_tbl JTF_NUMBER_TABLE
855: , p_cancel_flag VARCHAR2
856: , x_return_status out nocopy VARCHAR2
857: , x_msg_count out nocopy NUMBER
858: , x_msg_data out nocopy VARCHAR2