18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy ibu_order_capture.header_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy ibu_order_capture.header_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy ibu_order_capture.header_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
22: procedure rosetta_table_copy_in_p1(t out nocopy ibu_order_capture.header_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_300
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_DATE_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: ) as
36: ddindx binary_integer; indx binary_integer;
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin
61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t ibu_order_capture.header_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_VARCHAR2_TABLE_300
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_NUMBER_TABLE
62: end if;
63: end if;
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t ibu_order_capture.header_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_VARCHAR2_TABLE_300
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_NUMBER_TABLE
70: , a5 out nocopy JTF_NUMBER_TABLE
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t ibu_order_capture.header_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_VARCHAR2_TABLE_300
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_NUMBER_TABLE
70: , a5 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_NUMBER_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
65: procedure rosetta_table_copy_out_p1(t ibu_order_capture.header_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_VARCHAR2_TABLE_300
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_NUMBER_TABLE
70: , a5 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_NUMBER_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_VARCHAR2_TABLE_300
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_VARCHAR2_TABLE_300
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_NUMBER_TABLE
70: , a5 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_NUMBER_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_VARCHAR2_TABLE_300
74: , a9 out nocopy JTF_DATE_TABLE
67: , a2 out nocopy JTF_VARCHAR2_TABLE_300
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_NUMBER_TABLE
70: , a5 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_NUMBER_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_VARCHAR2_TABLE_300
74: , a9 out nocopy JTF_DATE_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_NUMBER_TABLE
70: , a5 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_NUMBER_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_VARCHAR2_TABLE_300
74: , a9 out nocopy JTF_DATE_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: , a11 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_NUMBER_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_VARCHAR2_TABLE_300
74: , a9 out nocopy JTF_DATE_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: , a11 out nocopy JTF_NUMBER_TABLE
77: , a12 out nocopy JTF_VARCHAR2_TABLE_100
78: ) as
79: ddindx binary_integer; indx binary_integer;
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_VARCHAR2_TABLE_300
74: , a9 out nocopy JTF_DATE_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: , a11 out nocopy JTF_NUMBER_TABLE
77: , a12 out nocopy JTF_VARCHAR2_TABLE_100
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_VARCHAR2_TABLE_300();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_VARCHAR2_TABLE_300();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_VARCHAR2_TABLE_300();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_VARCHAR2_TABLE_300();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_VARCHAR2_TABLE_300();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_VARCHAR2_TABLE_300();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_VARCHAR2_TABLE_300();
91: a9 := JTF_DATE_TABLE();
84: a2 := JTF_VARCHAR2_TABLE_300();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_VARCHAR2_TABLE_300();
91: a9 := JTF_DATE_TABLE();
92: a10 := JTF_NUMBER_TABLE();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_VARCHAR2_TABLE_300();
91: a9 := JTF_DATE_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_VARCHAR2_TABLE_300();
91: a9 := JTF_DATE_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_VARCHAR2_TABLE_300();
91: a9 := JTF_DATE_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_300();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_NUMBER_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_300();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_300();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_300();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_VARCHAR2_TABLE_300();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_300();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_VARCHAR2_TABLE_300();
105: a9 := JTF_DATE_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_300();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_VARCHAR2_TABLE_300();
105: a9 := JTF_DATE_TABLE();
106: a10 := JTF_NUMBER_TABLE();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_VARCHAR2_TABLE_300();
105: a9 := JTF_DATE_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_VARCHAR2_TABLE_300();
105: a9 := JTF_DATE_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_NUMBER_TABLE();
108: a12 := JTF_VARCHAR2_TABLE_100();
109: if t.count > 0 then
110: a0.extend(t.count);
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_VARCHAR2_TABLE_300();
105: a9 := JTF_DATE_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_NUMBER_TABLE();
108: a12 := JTF_VARCHAR2_TABLE_100();
109: if t.count > 0 then
110: a0.extend(t.count);
111: a1.extend(t.count);
145: end if;
146: end if;
147: end rosetta_table_copy_out_p1;
148:
149: procedure rosetta_table_copy_in_p4(t out nocopy ibu_order_capture.line_tbl_type, a0 JTF_NUMBER_TABLE
150: , a1 JTF_VARCHAR2_TABLE_100
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_VARCHAR2_TABLE_100
153: , a4 JTF_NUMBER_TABLE
147: end rosetta_table_copy_out_p1;
148:
149: procedure rosetta_table_copy_in_p4(t out nocopy ibu_order_capture.line_tbl_type, a0 JTF_NUMBER_TABLE
150: , a1 JTF_VARCHAR2_TABLE_100
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_VARCHAR2_TABLE_100
153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_NUMBER_TABLE
155: , a6 JTF_NUMBER_TABLE
149: procedure rosetta_table_copy_in_p4(t out nocopy ibu_order_capture.line_tbl_type, a0 JTF_NUMBER_TABLE
150: , a1 JTF_VARCHAR2_TABLE_100
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_VARCHAR2_TABLE_100
153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_NUMBER_TABLE
155: , a6 JTF_NUMBER_TABLE
156: , a7 JTF_NUMBER_TABLE
157: , a8 JTF_NUMBER_TABLE
150: , a1 JTF_VARCHAR2_TABLE_100
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_VARCHAR2_TABLE_100
153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_NUMBER_TABLE
155: , a6 JTF_NUMBER_TABLE
156: , a7 JTF_NUMBER_TABLE
157: , a8 JTF_NUMBER_TABLE
158: , a9 JTF_NUMBER_TABLE
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_VARCHAR2_TABLE_100
153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_NUMBER_TABLE
155: , a6 JTF_NUMBER_TABLE
156: , a7 JTF_NUMBER_TABLE
157: , a8 JTF_NUMBER_TABLE
158: , a9 JTF_NUMBER_TABLE
159: , a10 JTF_VARCHAR2_TABLE_100
152: , a3 JTF_VARCHAR2_TABLE_100
153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_NUMBER_TABLE
155: , a6 JTF_NUMBER_TABLE
156: , a7 JTF_NUMBER_TABLE
157: , a8 JTF_NUMBER_TABLE
158: , a9 JTF_NUMBER_TABLE
159: , a10 JTF_VARCHAR2_TABLE_100
160: , a11 JTF_NUMBER_TABLE
153: , a4 JTF_NUMBER_TABLE
154: , a5 JTF_NUMBER_TABLE
155: , a6 JTF_NUMBER_TABLE
156: , a7 JTF_NUMBER_TABLE
157: , a8 JTF_NUMBER_TABLE
158: , a9 JTF_NUMBER_TABLE
159: , a10 JTF_VARCHAR2_TABLE_100
160: , a11 JTF_NUMBER_TABLE
161: , a12 JTF_VARCHAR2_TABLE_100
154: , a5 JTF_NUMBER_TABLE
155: , a6 JTF_NUMBER_TABLE
156: , a7 JTF_NUMBER_TABLE
157: , a8 JTF_NUMBER_TABLE
158: , a9 JTF_NUMBER_TABLE
159: , a10 JTF_VARCHAR2_TABLE_100
160: , a11 JTF_NUMBER_TABLE
161: , a12 JTF_VARCHAR2_TABLE_100
162: , a13 JTF_NUMBER_TABLE
156: , a7 JTF_NUMBER_TABLE
157: , a8 JTF_NUMBER_TABLE
158: , a9 JTF_NUMBER_TABLE
159: , a10 JTF_VARCHAR2_TABLE_100
160: , a11 JTF_NUMBER_TABLE
161: , a12 JTF_VARCHAR2_TABLE_100
162: , a13 JTF_NUMBER_TABLE
163: , a14 JTF_NUMBER_TABLE
164: ) as
158: , a9 JTF_NUMBER_TABLE
159: , a10 JTF_VARCHAR2_TABLE_100
160: , a11 JTF_NUMBER_TABLE
161: , a12 JTF_VARCHAR2_TABLE_100
162: , a13 JTF_NUMBER_TABLE
163: , a14 JTF_NUMBER_TABLE
164: ) as
165: ddindx binary_integer; indx binary_integer;
166: begin
159: , a10 JTF_VARCHAR2_TABLE_100
160: , a11 JTF_NUMBER_TABLE
161: , a12 JTF_VARCHAR2_TABLE_100
162: , a13 JTF_NUMBER_TABLE
163: , a14 JTF_NUMBER_TABLE
164: ) as
165: ddindx binary_integer; indx binary_integer;
166: begin
167: if a0 is not null and a0.count > 0 then
192: end loop;
193: end if;
194: end if;
195: end rosetta_table_copy_in_p4;
196: procedure rosetta_table_copy_out_p4(t ibu_order_capture.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_VARCHAR2_TABLE_100
200: , a4 out nocopy JTF_NUMBER_TABLE
194: end if;
195: end rosetta_table_copy_in_p4;
196: procedure rosetta_table_copy_out_p4(t ibu_order_capture.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_VARCHAR2_TABLE_100
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_NUMBER_TABLE
202: , a6 out nocopy JTF_NUMBER_TABLE
196: procedure rosetta_table_copy_out_p4(t ibu_order_capture.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_VARCHAR2_TABLE_100
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_NUMBER_TABLE
202: , a6 out nocopy JTF_NUMBER_TABLE
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_VARCHAR2_TABLE_100
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_NUMBER_TABLE
202: , a6 out nocopy JTF_NUMBER_TABLE
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_VARCHAR2_TABLE_100
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_NUMBER_TABLE
202: , a6 out nocopy JTF_NUMBER_TABLE
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_VARCHAR2_TABLE_100
199: , a3 out nocopy JTF_VARCHAR2_TABLE_100
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_NUMBER_TABLE
202: , a6 out nocopy JTF_NUMBER_TABLE
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_VARCHAR2_TABLE_100
207: , a11 out nocopy JTF_NUMBER_TABLE
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_NUMBER_TABLE
202: , a6 out nocopy JTF_NUMBER_TABLE
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_VARCHAR2_TABLE_100
207: , a11 out nocopy JTF_NUMBER_TABLE
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
201: , a5 out nocopy JTF_NUMBER_TABLE
202: , a6 out nocopy JTF_NUMBER_TABLE
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_VARCHAR2_TABLE_100
207: , a11 out nocopy JTF_NUMBER_TABLE
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
209: , a13 out nocopy JTF_NUMBER_TABLE
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_VARCHAR2_TABLE_100
207: , a11 out nocopy JTF_NUMBER_TABLE
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
209: , a13 out nocopy JTF_NUMBER_TABLE
210: , a14 out nocopy JTF_NUMBER_TABLE
211: ) as
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_VARCHAR2_TABLE_100
207: , a11 out nocopy JTF_NUMBER_TABLE
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
209: , a13 out nocopy JTF_NUMBER_TABLE
210: , a14 out nocopy JTF_NUMBER_TABLE
211: ) as
212: ddindx binary_integer; indx binary_integer;
213: begin
206: , a10 out nocopy JTF_VARCHAR2_TABLE_100
207: , a11 out nocopy JTF_NUMBER_TABLE
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
209: , a13 out nocopy JTF_NUMBER_TABLE
210: , a14 out nocopy JTF_NUMBER_TABLE
211: ) as
212: ddindx binary_integer; indx binary_integer;
213: begin
214: if t is null or t.count = 0 then
211: ) as
212: ddindx binary_integer; indx binary_integer;
213: begin
214: if t is null or t.count = 0 then
215: a0 := JTF_NUMBER_TABLE();
216: a1 := JTF_VARCHAR2_TABLE_100();
217: a2 := JTF_NUMBER_TABLE();
218: a3 := JTF_VARCHAR2_TABLE_100();
219: a4 := JTF_NUMBER_TABLE();
213: begin
214: if t is null or t.count = 0 then
215: a0 := JTF_NUMBER_TABLE();
216: a1 := JTF_VARCHAR2_TABLE_100();
217: a2 := JTF_NUMBER_TABLE();
218: a3 := JTF_VARCHAR2_TABLE_100();
219: a4 := JTF_NUMBER_TABLE();
220: a5 := JTF_NUMBER_TABLE();
221: a6 := JTF_NUMBER_TABLE();
215: a0 := JTF_NUMBER_TABLE();
216: a1 := JTF_VARCHAR2_TABLE_100();
217: a2 := JTF_NUMBER_TABLE();
218: a3 := JTF_VARCHAR2_TABLE_100();
219: a4 := JTF_NUMBER_TABLE();
220: a5 := JTF_NUMBER_TABLE();
221: a6 := JTF_NUMBER_TABLE();
222: a7 := JTF_NUMBER_TABLE();
223: a8 := JTF_NUMBER_TABLE();
216: a1 := JTF_VARCHAR2_TABLE_100();
217: a2 := JTF_NUMBER_TABLE();
218: a3 := JTF_VARCHAR2_TABLE_100();
219: a4 := JTF_NUMBER_TABLE();
220: a5 := JTF_NUMBER_TABLE();
221: a6 := JTF_NUMBER_TABLE();
222: a7 := JTF_NUMBER_TABLE();
223: a8 := JTF_NUMBER_TABLE();
224: a9 := JTF_NUMBER_TABLE();
217: a2 := JTF_NUMBER_TABLE();
218: a3 := JTF_VARCHAR2_TABLE_100();
219: a4 := JTF_NUMBER_TABLE();
220: a5 := JTF_NUMBER_TABLE();
221: a6 := JTF_NUMBER_TABLE();
222: a7 := JTF_NUMBER_TABLE();
223: a8 := JTF_NUMBER_TABLE();
224: a9 := JTF_NUMBER_TABLE();
225: a10 := JTF_VARCHAR2_TABLE_100();
218: a3 := JTF_VARCHAR2_TABLE_100();
219: a4 := JTF_NUMBER_TABLE();
220: a5 := JTF_NUMBER_TABLE();
221: a6 := JTF_NUMBER_TABLE();
222: a7 := JTF_NUMBER_TABLE();
223: a8 := JTF_NUMBER_TABLE();
224: a9 := JTF_NUMBER_TABLE();
225: a10 := JTF_VARCHAR2_TABLE_100();
226: a11 := JTF_NUMBER_TABLE();
219: a4 := JTF_NUMBER_TABLE();
220: a5 := JTF_NUMBER_TABLE();
221: a6 := JTF_NUMBER_TABLE();
222: a7 := JTF_NUMBER_TABLE();
223: a8 := JTF_NUMBER_TABLE();
224: a9 := JTF_NUMBER_TABLE();
225: a10 := JTF_VARCHAR2_TABLE_100();
226: a11 := JTF_NUMBER_TABLE();
227: a12 := JTF_VARCHAR2_TABLE_100();
220: a5 := JTF_NUMBER_TABLE();
221: a6 := JTF_NUMBER_TABLE();
222: a7 := JTF_NUMBER_TABLE();
223: a8 := JTF_NUMBER_TABLE();
224: a9 := JTF_NUMBER_TABLE();
225: a10 := JTF_VARCHAR2_TABLE_100();
226: a11 := JTF_NUMBER_TABLE();
227: a12 := JTF_VARCHAR2_TABLE_100();
228: a13 := JTF_NUMBER_TABLE();
222: a7 := JTF_NUMBER_TABLE();
223: a8 := JTF_NUMBER_TABLE();
224: a9 := JTF_NUMBER_TABLE();
225: a10 := JTF_VARCHAR2_TABLE_100();
226: a11 := JTF_NUMBER_TABLE();
227: a12 := JTF_VARCHAR2_TABLE_100();
228: a13 := JTF_NUMBER_TABLE();
229: a14 := JTF_NUMBER_TABLE();
230: else
224: a9 := JTF_NUMBER_TABLE();
225: a10 := JTF_VARCHAR2_TABLE_100();
226: a11 := JTF_NUMBER_TABLE();
227: a12 := JTF_VARCHAR2_TABLE_100();
228: a13 := JTF_NUMBER_TABLE();
229: a14 := JTF_NUMBER_TABLE();
230: else
231: a0 := JTF_NUMBER_TABLE();
232: a1 := JTF_VARCHAR2_TABLE_100();
225: a10 := JTF_VARCHAR2_TABLE_100();
226: a11 := JTF_NUMBER_TABLE();
227: a12 := JTF_VARCHAR2_TABLE_100();
228: a13 := JTF_NUMBER_TABLE();
229: a14 := JTF_NUMBER_TABLE();
230: else
231: a0 := JTF_NUMBER_TABLE();
232: a1 := JTF_VARCHAR2_TABLE_100();
233: a2 := JTF_NUMBER_TABLE();
227: a12 := JTF_VARCHAR2_TABLE_100();
228: a13 := JTF_NUMBER_TABLE();
229: a14 := JTF_NUMBER_TABLE();
230: else
231: a0 := JTF_NUMBER_TABLE();
232: a1 := JTF_VARCHAR2_TABLE_100();
233: a2 := JTF_NUMBER_TABLE();
234: a3 := JTF_VARCHAR2_TABLE_100();
235: a4 := JTF_NUMBER_TABLE();
229: a14 := JTF_NUMBER_TABLE();
230: else
231: a0 := JTF_NUMBER_TABLE();
232: a1 := JTF_VARCHAR2_TABLE_100();
233: a2 := JTF_NUMBER_TABLE();
234: a3 := JTF_VARCHAR2_TABLE_100();
235: a4 := JTF_NUMBER_TABLE();
236: a5 := JTF_NUMBER_TABLE();
237: a6 := JTF_NUMBER_TABLE();
231: a0 := JTF_NUMBER_TABLE();
232: a1 := JTF_VARCHAR2_TABLE_100();
233: a2 := JTF_NUMBER_TABLE();
234: a3 := JTF_VARCHAR2_TABLE_100();
235: a4 := JTF_NUMBER_TABLE();
236: a5 := JTF_NUMBER_TABLE();
237: a6 := JTF_NUMBER_TABLE();
238: a7 := JTF_NUMBER_TABLE();
239: a8 := JTF_NUMBER_TABLE();
232: a1 := JTF_VARCHAR2_TABLE_100();
233: a2 := JTF_NUMBER_TABLE();
234: a3 := JTF_VARCHAR2_TABLE_100();
235: a4 := JTF_NUMBER_TABLE();
236: a5 := JTF_NUMBER_TABLE();
237: a6 := JTF_NUMBER_TABLE();
238: a7 := JTF_NUMBER_TABLE();
239: a8 := JTF_NUMBER_TABLE();
240: a9 := JTF_NUMBER_TABLE();
233: a2 := JTF_NUMBER_TABLE();
234: a3 := JTF_VARCHAR2_TABLE_100();
235: a4 := JTF_NUMBER_TABLE();
236: a5 := JTF_NUMBER_TABLE();
237: a6 := JTF_NUMBER_TABLE();
238: a7 := JTF_NUMBER_TABLE();
239: a8 := JTF_NUMBER_TABLE();
240: a9 := JTF_NUMBER_TABLE();
241: a10 := JTF_VARCHAR2_TABLE_100();
234: a3 := JTF_VARCHAR2_TABLE_100();
235: a4 := JTF_NUMBER_TABLE();
236: a5 := JTF_NUMBER_TABLE();
237: a6 := JTF_NUMBER_TABLE();
238: a7 := JTF_NUMBER_TABLE();
239: a8 := JTF_NUMBER_TABLE();
240: a9 := JTF_NUMBER_TABLE();
241: a10 := JTF_VARCHAR2_TABLE_100();
242: a11 := JTF_NUMBER_TABLE();
235: a4 := JTF_NUMBER_TABLE();
236: a5 := JTF_NUMBER_TABLE();
237: a6 := JTF_NUMBER_TABLE();
238: a7 := JTF_NUMBER_TABLE();
239: a8 := JTF_NUMBER_TABLE();
240: a9 := JTF_NUMBER_TABLE();
241: a10 := JTF_VARCHAR2_TABLE_100();
242: a11 := JTF_NUMBER_TABLE();
243: a12 := JTF_VARCHAR2_TABLE_100();
236: a5 := JTF_NUMBER_TABLE();
237: a6 := JTF_NUMBER_TABLE();
238: a7 := JTF_NUMBER_TABLE();
239: a8 := JTF_NUMBER_TABLE();
240: a9 := JTF_NUMBER_TABLE();
241: a10 := JTF_VARCHAR2_TABLE_100();
242: a11 := JTF_NUMBER_TABLE();
243: a12 := JTF_VARCHAR2_TABLE_100();
244: a13 := JTF_NUMBER_TABLE();
238: a7 := JTF_NUMBER_TABLE();
239: a8 := JTF_NUMBER_TABLE();
240: a9 := JTF_NUMBER_TABLE();
241: a10 := JTF_VARCHAR2_TABLE_100();
242: a11 := JTF_NUMBER_TABLE();
243: a12 := JTF_VARCHAR2_TABLE_100();
244: a13 := JTF_NUMBER_TABLE();
245: a14 := JTF_NUMBER_TABLE();
246: if t.count > 0 then
240: a9 := JTF_NUMBER_TABLE();
241: a10 := JTF_VARCHAR2_TABLE_100();
242: a11 := JTF_NUMBER_TABLE();
243: a12 := JTF_VARCHAR2_TABLE_100();
244: a13 := JTF_NUMBER_TABLE();
245: a14 := JTF_NUMBER_TABLE();
246: if t.count > 0 then
247: a0.extend(t.count);
248: a1.extend(t.count);
241: a10 := JTF_VARCHAR2_TABLE_100();
242: a11 := JTF_NUMBER_TABLE();
243: a12 := JTF_VARCHAR2_TABLE_100();
244: a13 := JTF_NUMBER_TABLE();
245: a14 := JTF_NUMBER_TABLE();
246: if t.count > 0 then
247: a0.extend(t.count);
248: a1.extend(t.count);
249: a2.extend(t.count);
287: end if;
288: end rosetta_table_copy_out_p4;
289:
290: procedure rosetta_table_copy_in_p6(t out nocopy ibu_order_capture.line_dtl_tbl_type, a0 JTF_VARCHAR2_TABLE_100
291: , a1 JTF_NUMBER_TABLE
292: , a2 JTF_VARCHAR2_TABLE_100
293: , a3 JTF_NUMBER_TABLE
294: , a4 JTF_NUMBER_TABLE
295: , a5 JTF_VARCHAR2_TABLE_300
289:
290: procedure rosetta_table_copy_in_p6(t out nocopy ibu_order_capture.line_dtl_tbl_type, a0 JTF_VARCHAR2_TABLE_100
291: , a1 JTF_NUMBER_TABLE
292: , a2 JTF_VARCHAR2_TABLE_100
293: , a3 JTF_NUMBER_TABLE
294: , a4 JTF_NUMBER_TABLE
295: , a5 JTF_VARCHAR2_TABLE_300
296: , a6 JTF_VARCHAR2_TABLE_300
297: , a7 JTF_VARCHAR2_TABLE_300
290: procedure rosetta_table_copy_in_p6(t out nocopy ibu_order_capture.line_dtl_tbl_type, a0 JTF_VARCHAR2_TABLE_100
291: , a1 JTF_NUMBER_TABLE
292: , a2 JTF_VARCHAR2_TABLE_100
293: , a3 JTF_NUMBER_TABLE
294: , a4 JTF_NUMBER_TABLE
295: , a5 JTF_VARCHAR2_TABLE_300
296: , a6 JTF_VARCHAR2_TABLE_300
297: , a7 JTF_VARCHAR2_TABLE_300
298: , a8 JTF_VARCHAR2_TABLE_300
324: end if;
325: end if;
326: end rosetta_table_copy_in_p6;
327: procedure rosetta_table_copy_out_p6(t ibu_order_capture.line_dtl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
328: , a1 out nocopy JTF_NUMBER_TABLE
329: , a2 out nocopy JTF_VARCHAR2_TABLE_100
330: , a3 out nocopy JTF_NUMBER_TABLE
331: , a4 out nocopy JTF_NUMBER_TABLE
332: , a5 out nocopy JTF_VARCHAR2_TABLE_300
326: end rosetta_table_copy_in_p6;
327: procedure rosetta_table_copy_out_p6(t ibu_order_capture.line_dtl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
328: , a1 out nocopy JTF_NUMBER_TABLE
329: , a2 out nocopy JTF_VARCHAR2_TABLE_100
330: , a3 out nocopy JTF_NUMBER_TABLE
331: , a4 out nocopy JTF_NUMBER_TABLE
332: , a5 out nocopy JTF_VARCHAR2_TABLE_300
333: , a6 out nocopy JTF_VARCHAR2_TABLE_300
334: , a7 out nocopy JTF_VARCHAR2_TABLE_300
327: procedure rosetta_table_copy_out_p6(t ibu_order_capture.line_dtl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
328: , a1 out nocopy JTF_NUMBER_TABLE
329: , a2 out nocopy JTF_VARCHAR2_TABLE_100
330: , a3 out nocopy JTF_NUMBER_TABLE
331: , a4 out nocopy JTF_NUMBER_TABLE
332: , a5 out nocopy JTF_VARCHAR2_TABLE_300
333: , a6 out nocopy JTF_VARCHAR2_TABLE_300
334: , a7 out nocopy JTF_VARCHAR2_TABLE_300
335: , a8 out nocopy JTF_VARCHAR2_TABLE_300
338: ddindx binary_integer; indx binary_integer;
339: begin
340: if t is null or t.count = 0 then
341: a0 := JTF_VARCHAR2_TABLE_100();
342: a1 := JTF_NUMBER_TABLE();
343: a2 := JTF_VARCHAR2_TABLE_100();
344: a3 := JTF_NUMBER_TABLE();
345: a4 := JTF_NUMBER_TABLE();
346: a5 := JTF_VARCHAR2_TABLE_300();
340: if t is null or t.count = 0 then
341: a0 := JTF_VARCHAR2_TABLE_100();
342: a1 := JTF_NUMBER_TABLE();
343: a2 := JTF_VARCHAR2_TABLE_100();
344: a3 := JTF_NUMBER_TABLE();
345: a4 := JTF_NUMBER_TABLE();
346: a5 := JTF_VARCHAR2_TABLE_300();
347: a6 := JTF_VARCHAR2_TABLE_300();
348: a7 := JTF_VARCHAR2_TABLE_300();
341: a0 := JTF_VARCHAR2_TABLE_100();
342: a1 := JTF_NUMBER_TABLE();
343: a2 := JTF_VARCHAR2_TABLE_100();
344: a3 := JTF_NUMBER_TABLE();
345: a4 := JTF_NUMBER_TABLE();
346: a5 := JTF_VARCHAR2_TABLE_300();
347: a6 := JTF_VARCHAR2_TABLE_300();
348: a7 := JTF_VARCHAR2_TABLE_300();
349: a8 := JTF_VARCHAR2_TABLE_300();
349: a8 := JTF_VARCHAR2_TABLE_300();
350: a9 := JTF_VARCHAR2_TABLE_100();
351: else
352: a0 := JTF_VARCHAR2_TABLE_100();
353: a1 := JTF_NUMBER_TABLE();
354: a2 := JTF_VARCHAR2_TABLE_100();
355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_NUMBER_TABLE();
357: a5 := JTF_VARCHAR2_TABLE_300();
351: else
352: a0 := JTF_VARCHAR2_TABLE_100();
353: a1 := JTF_NUMBER_TABLE();
354: a2 := JTF_VARCHAR2_TABLE_100();
355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_NUMBER_TABLE();
357: a5 := JTF_VARCHAR2_TABLE_300();
358: a6 := JTF_VARCHAR2_TABLE_300();
359: a7 := JTF_VARCHAR2_TABLE_300();
352: a0 := JTF_VARCHAR2_TABLE_100();
353: a1 := JTF_NUMBER_TABLE();
354: a2 := JTF_VARCHAR2_TABLE_100();
355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_NUMBER_TABLE();
357: a5 := JTF_VARCHAR2_TABLE_300();
358: a6 := JTF_VARCHAR2_TABLE_300();
359: a7 := JTF_VARCHAR2_TABLE_300();
360: a8 := JTF_VARCHAR2_TABLE_300();
393: end if;
394: end rosetta_table_copy_out_p6;
395:
396: procedure rosetta_table_copy_in_p8(t out nocopy ibu_order_capture.line_shipment_tbl_type, a0 JTF_VARCHAR2_TABLE_100
397: , a1 JTF_NUMBER_TABLE
398: , a2 JTF_DATE_TABLE
399: , a3 JTF_DATE_TABLE
400: , a4 JTF_NUMBER_TABLE
401: , a5 JTF_NUMBER_TABLE
396: procedure rosetta_table_copy_in_p8(t out nocopy ibu_order_capture.line_shipment_tbl_type, a0 JTF_VARCHAR2_TABLE_100
397: , a1 JTF_NUMBER_TABLE
398: , a2 JTF_DATE_TABLE
399: , a3 JTF_DATE_TABLE
400: , a4 JTF_NUMBER_TABLE
401: , a5 JTF_NUMBER_TABLE
402: , a6 JTF_VARCHAR2_TABLE_100
403: , a7 JTF_NUMBER_TABLE
404: ) as
397: , a1 JTF_NUMBER_TABLE
398: , a2 JTF_DATE_TABLE
399: , a3 JTF_DATE_TABLE
400: , a4 JTF_NUMBER_TABLE
401: , a5 JTF_NUMBER_TABLE
402: , a6 JTF_VARCHAR2_TABLE_100
403: , a7 JTF_NUMBER_TABLE
404: ) as
405: ddindx binary_integer; indx binary_integer;
399: , a3 JTF_DATE_TABLE
400: , a4 JTF_NUMBER_TABLE
401: , a5 JTF_NUMBER_TABLE
402: , a6 JTF_VARCHAR2_TABLE_100
403: , a7 JTF_NUMBER_TABLE
404: ) as
405: ddindx binary_integer; indx binary_integer;
406: begin
407: if a0 is not null and a0.count > 0 then
426: end if;
427: end if;
428: end rosetta_table_copy_in_p8;
429: procedure rosetta_table_copy_out_p8(t ibu_order_capture.line_shipment_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_DATE_TABLE
432: , a3 out nocopy JTF_DATE_TABLE
433: , a4 out nocopy JTF_NUMBER_TABLE
434: , a5 out nocopy JTF_NUMBER_TABLE
429: procedure rosetta_table_copy_out_p8(t ibu_order_capture.line_shipment_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_DATE_TABLE
432: , a3 out nocopy JTF_DATE_TABLE
433: , a4 out nocopy JTF_NUMBER_TABLE
434: , a5 out nocopy JTF_NUMBER_TABLE
435: , a6 out nocopy JTF_VARCHAR2_TABLE_100
436: , a7 out nocopy JTF_NUMBER_TABLE
437: ) as
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_DATE_TABLE
432: , a3 out nocopy JTF_DATE_TABLE
433: , a4 out nocopy JTF_NUMBER_TABLE
434: , a5 out nocopy JTF_NUMBER_TABLE
435: , a6 out nocopy JTF_VARCHAR2_TABLE_100
436: , a7 out nocopy JTF_NUMBER_TABLE
437: ) as
438: ddindx binary_integer; indx binary_integer;
432: , a3 out nocopy JTF_DATE_TABLE
433: , a4 out nocopy JTF_NUMBER_TABLE
434: , a5 out nocopy JTF_NUMBER_TABLE
435: , a6 out nocopy JTF_VARCHAR2_TABLE_100
436: , a7 out nocopy JTF_NUMBER_TABLE
437: ) as
438: ddindx binary_integer; indx binary_integer;
439: begin
440: if t is null or t.count = 0 then
438: ddindx binary_integer; indx binary_integer;
439: begin
440: if t is null or t.count = 0 then
441: a0 := JTF_VARCHAR2_TABLE_100();
442: a1 := JTF_NUMBER_TABLE();
443: a2 := JTF_DATE_TABLE();
444: a3 := JTF_DATE_TABLE();
445: a4 := JTF_NUMBER_TABLE();
446: a5 := JTF_NUMBER_TABLE();
441: a0 := JTF_VARCHAR2_TABLE_100();
442: a1 := JTF_NUMBER_TABLE();
443: a2 := JTF_DATE_TABLE();
444: a3 := JTF_DATE_TABLE();
445: a4 := JTF_NUMBER_TABLE();
446: a5 := JTF_NUMBER_TABLE();
447: a6 := JTF_VARCHAR2_TABLE_100();
448: a7 := JTF_NUMBER_TABLE();
449: else
442: a1 := JTF_NUMBER_TABLE();
443: a2 := JTF_DATE_TABLE();
444: a3 := JTF_DATE_TABLE();
445: a4 := JTF_NUMBER_TABLE();
446: a5 := JTF_NUMBER_TABLE();
447: a6 := JTF_VARCHAR2_TABLE_100();
448: a7 := JTF_NUMBER_TABLE();
449: else
450: a0 := JTF_VARCHAR2_TABLE_100();
444: a3 := JTF_DATE_TABLE();
445: a4 := JTF_NUMBER_TABLE();
446: a5 := JTF_NUMBER_TABLE();
447: a6 := JTF_VARCHAR2_TABLE_100();
448: a7 := JTF_NUMBER_TABLE();
449: else
450: a0 := JTF_VARCHAR2_TABLE_100();
451: a1 := JTF_NUMBER_TABLE();
452: a2 := JTF_DATE_TABLE();
447: a6 := JTF_VARCHAR2_TABLE_100();
448: a7 := JTF_NUMBER_TABLE();
449: else
450: a0 := JTF_VARCHAR2_TABLE_100();
451: a1 := JTF_NUMBER_TABLE();
452: a2 := JTF_DATE_TABLE();
453: a3 := JTF_DATE_TABLE();
454: a4 := JTF_NUMBER_TABLE();
455: a5 := JTF_NUMBER_TABLE();
450: a0 := JTF_VARCHAR2_TABLE_100();
451: a1 := JTF_NUMBER_TABLE();
452: a2 := JTF_DATE_TABLE();
453: a3 := JTF_DATE_TABLE();
454: a4 := JTF_NUMBER_TABLE();
455: a5 := JTF_NUMBER_TABLE();
456: a6 := JTF_VARCHAR2_TABLE_100();
457: a7 := JTF_NUMBER_TABLE();
458: if t.count > 0 then
451: a1 := JTF_NUMBER_TABLE();
452: a2 := JTF_DATE_TABLE();
453: a3 := JTF_DATE_TABLE();
454: a4 := JTF_NUMBER_TABLE();
455: a5 := JTF_NUMBER_TABLE();
456: a6 := JTF_VARCHAR2_TABLE_100();
457: a7 := JTF_NUMBER_TABLE();
458: if t.count > 0 then
459: a0.extend(t.count);
453: a3 := JTF_DATE_TABLE();
454: a4 := JTF_NUMBER_TABLE();
455: a5 := JTF_NUMBER_TABLE();
456: a6 := JTF_VARCHAR2_TABLE_100();
457: a7 := JTF_NUMBER_TABLE();
458: if t.count > 0 then
459: a0.extend(t.count);
460: a1.extend(t.count);
461: a2.extend(t.count);
484: end if;
485: end if;
486: end rosetta_table_copy_out_p8;
487:
488: procedure rosetta_table_copy_in_p11(t out nocopy ibu_order_capture.return_line_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_VARCHAR2_TABLE_200
491: ) as
492: ddindx binary_integer; indx binary_integer;
485: end if;
486: end rosetta_table_copy_out_p8;
487:
488: procedure rosetta_table_copy_in_p11(t out nocopy ibu_order_capture.return_line_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_VARCHAR2_TABLE_200
491: ) as
492: ddindx binary_integer; indx binary_integer;
493: begin
507: end loop;
508: end if;
509: end if;
510: end rosetta_table_copy_in_p11;
511: procedure rosetta_table_copy_out_p11(t ibu_order_capture.return_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
512: , a1 out nocopy JTF_NUMBER_TABLE
513: , a2 out nocopy JTF_VARCHAR2_TABLE_200
514: ) as
515: ddindx binary_integer; indx binary_integer;
508: end if;
509: end if;
510: end rosetta_table_copy_in_p11;
511: procedure rosetta_table_copy_out_p11(t ibu_order_capture.return_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
512: , a1 out nocopy JTF_NUMBER_TABLE
513: , a2 out nocopy JTF_VARCHAR2_TABLE_200
514: ) as
515: ddindx binary_integer; indx binary_integer;
516: begin
514: ) as
515: ddindx binary_integer; indx binary_integer;
516: begin
517: if t is null or t.count = 0 then
518: a0 := JTF_NUMBER_TABLE();
519: a1 := JTF_NUMBER_TABLE();
520: a2 := JTF_VARCHAR2_TABLE_200();
521: else
522: a0 := JTF_NUMBER_TABLE();
515: ddindx binary_integer; indx binary_integer;
516: begin
517: if t is null or t.count = 0 then
518: a0 := JTF_NUMBER_TABLE();
519: a1 := JTF_NUMBER_TABLE();
520: a2 := JTF_VARCHAR2_TABLE_200();
521: else
522: a0 := JTF_NUMBER_TABLE();
523: a1 := JTF_NUMBER_TABLE();
518: a0 := JTF_NUMBER_TABLE();
519: a1 := JTF_NUMBER_TABLE();
520: a2 := JTF_VARCHAR2_TABLE_200();
521: else
522: a0 := JTF_NUMBER_TABLE();
523: a1 := JTF_NUMBER_TABLE();
524: a2 := JTF_VARCHAR2_TABLE_200();
525: if t.count > 0 then
526: a0.extend(t.count);
519: a1 := JTF_NUMBER_TABLE();
520: a2 := JTF_VARCHAR2_TABLE_200();
521: else
522: a0 := JTF_NUMBER_TABLE();
523: a1 := JTF_NUMBER_TABLE();
524: a2 := JTF_VARCHAR2_TABLE_200();
525: if t.count > 0 then
526: a0.extend(t.count);
527: a1.extend(t.count);
545: procedure create_return(p_api_version_number NUMBER
546: , p_init_msg_list VARCHAR2
547: , p_commit VARCHAR
548: , p_header_id NUMBER
549: , p6_a0 JTF_NUMBER_TABLE
550: , p6_a1 JTF_VARCHAR2_TABLE_100
551: , p6_a2 JTF_NUMBER_TABLE
552: , p6_a3 JTF_VARCHAR2_TABLE_100
553: , p6_a4 JTF_NUMBER_TABLE
547: , p_commit VARCHAR
548: , p_header_id NUMBER
549: , p6_a0 JTF_NUMBER_TABLE
550: , p6_a1 JTF_VARCHAR2_TABLE_100
551: , p6_a2 JTF_NUMBER_TABLE
552: , p6_a3 JTF_VARCHAR2_TABLE_100
553: , p6_a4 JTF_NUMBER_TABLE
554: , p6_a5 JTF_NUMBER_TABLE
555: , p6_a6 JTF_NUMBER_TABLE
549: , p6_a0 JTF_NUMBER_TABLE
550: , p6_a1 JTF_VARCHAR2_TABLE_100
551: , p6_a2 JTF_NUMBER_TABLE
552: , p6_a3 JTF_VARCHAR2_TABLE_100
553: , p6_a4 JTF_NUMBER_TABLE
554: , p6_a5 JTF_NUMBER_TABLE
555: , p6_a6 JTF_NUMBER_TABLE
556: , p6_a7 JTF_NUMBER_TABLE
557: , p6_a8 JTF_NUMBER_TABLE
550: , p6_a1 JTF_VARCHAR2_TABLE_100
551: , p6_a2 JTF_NUMBER_TABLE
552: , p6_a3 JTF_VARCHAR2_TABLE_100
553: , p6_a4 JTF_NUMBER_TABLE
554: , p6_a5 JTF_NUMBER_TABLE
555: , p6_a6 JTF_NUMBER_TABLE
556: , p6_a7 JTF_NUMBER_TABLE
557: , p6_a8 JTF_NUMBER_TABLE
558: , p6_a9 JTF_NUMBER_TABLE
551: , p6_a2 JTF_NUMBER_TABLE
552: , p6_a3 JTF_VARCHAR2_TABLE_100
553: , p6_a4 JTF_NUMBER_TABLE
554: , p6_a5 JTF_NUMBER_TABLE
555: , p6_a6 JTF_NUMBER_TABLE
556: , p6_a7 JTF_NUMBER_TABLE
557: , p6_a8 JTF_NUMBER_TABLE
558: , p6_a9 JTF_NUMBER_TABLE
559: , p6_a10 JTF_VARCHAR2_TABLE_100
552: , p6_a3 JTF_VARCHAR2_TABLE_100
553: , p6_a4 JTF_NUMBER_TABLE
554: , p6_a5 JTF_NUMBER_TABLE
555: , p6_a6 JTF_NUMBER_TABLE
556: , p6_a7 JTF_NUMBER_TABLE
557: , p6_a8 JTF_NUMBER_TABLE
558: , p6_a9 JTF_NUMBER_TABLE
559: , p6_a10 JTF_VARCHAR2_TABLE_100
560: , p6_a11 JTF_NUMBER_TABLE
553: , p6_a4 JTF_NUMBER_TABLE
554: , p6_a5 JTF_NUMBER_TABLE
555: , p6_a6 JTF_NUMBER_TABLE
556: , p6_a7 JTF_NUMBER_TABLE
557: , p6_a8 JTF_NUMBER_TABLE
558: , p6_a9 JTF_NUMBER_TABLE
559: , p6_a10 JTF_VARCHAR2_TABLE_100
560: , p6_a11 JTF_NUMBER_TABLE
561: , p6_a12 JTF_VARCHAR2_TABLE_100
554: , p6_a5 JTF_NUMBER_TABLE
555: , p6_a6 JTF_NUMBER_TABLE
556: , p6_a7 JTF_NUMBER_TABLE
557: , p6_a8 JTF_NUMBER_TABLE
558: , p6_a9 JTF_NUMBER_TABLE
559: , p6_a10 JTF_VARCHAR2_TABLE_100
560: , p6_a11 JTF_NUMBER_TABLE
561: , p6_a12 JTF_VARCHAR2_TABLE_100
562: , p6_a13 JTF_NUMBER_TABLE
556: , p6_a7 JTF_NUMBER_TABLE
557: , p6_a8 JTF_NUMBER_TABLE
558: , p6_a9 JTF_NUMBER_TABLE
559: , p6_a10 JTF_VARCHAR2_TABLE_100
560: , p6_a11 JTF_NUMBER_TABLE
561: , p6_a12 JTF_VARCHAR2_TABLE_100
562: , p6_a13 JTF_NUMBER_TABLE
563: , p6_a14 JTF_NUMBER_TABLE
564: , p7_a0 JTF_VARCHAR2_TABLE_100
558: , p6_a9 JTF_NUMBER_TABLE
559: , p6_a10 JTF_VARCHAR2_TABLE_100
560: , p6_a11 JTF_NUMBER_TABLE
561: , p6_a12 JTF_VARCHAR2_TABLE_100
562: , p6_a13 JTF_NUMBER_TABLE
563: , p6_a14 JTF_NUMBER_TABLE
564: , p7_a0 JTF_VARCHAR2_TABLE_100
565: , p7_a1 JTF_NUMBER_TABLE
566: , p7_a2 JTF_VARCHAR2_TABLE_100
559: , p6_a10 JTF_VARCHAR2_TABLE_100
560: , p6_a11 JTF_NUMBER_TABLE
561: , p6_a12 JTF_VARCHAR2_TABLE_100
562: , p6_a13 JTF_NUMBER_TABLE
563: , p6_a14 JTF_NUMBER_TABLE
564: , p7_a0 JTF_VARCHAR2_TABLE_100
565: , p7_a1 JTF_NUMBER_TABLE
566: , p7_a2 JTF_VARCHAR2_TABLE_100
567: , p7_a3 JTF_NUMBER_TABLE
561: , p6_a12 JTF_VARCHAR2_TABLE_100
562: , p6_a13 JTF_NUMBER_TABLE
563: , p6_a14 JTF_NUMBER_TABLE
564: , p7_a0 JTF_VARCHAR2_TABLE_100
565: , p7_a1 JTF_NUMBER_TABLE
566: , p7_a2 JTF_VARCHAR2_TABLE_100
567: , p7_a3 JTF_NUMBER_TABLE
568: , p7_a4 JTF_NUMBER_TABLE
569: , p7_a5 JTF_VARCHAR2_TABLE_300
563: , p6_a14 JTF_NUMBER_TABLE
564: , p7_a0 JTF_VARCHAR2_TABLE_100
565: , p7_a1 JTF_NUMBER_TABLE
566: , p7_a2 JTF_VARCHAR2_TABLE_100
567: , p7_a3 JTF_NUMBER_TABLE
568: , p7_a4 JTF_NUMBER_TABLE
569: , p7_a5 JTF_VARCHAR2_TABLE_300
570: , p7_a6 JTF_VARCHAR2_TABLE_300
571: , p7_a7 JTF_VARCHAR2_TABLE_300
564: , p7_a0 JTF_VARCHAR2_TABLE_100
565: , p7_a1 JTF_NUMBER_TABLE
566: , p7_a2 JTF_VARCHAR2_TABLE_100
567: , p7_a3 JTF_NUMBER_TABLE
568: , p7_a4 JTF_NUMBER_TABLE
569: , p7_a5 JTF_VARCHAR2_TABLE_300
570: , p7_a6 JTF_VARCHAR2_TABLE_300
571: , p7_a7 JTF_VARCHAR2_TABLE_300
572: , p7_a8 JTF_VARCHAR2_TABLE_300
571: , p7_a7 JTF_VARCHAR2_TABLE_300
572: , p7_a8 JTF_VARCHAR2_TABLE_300
573: , p7_a9 JTF_VARCHAR2_TABLE_100
574: , p8_a0 JTF_VARCHAR2_TABLE_100
575: , p8_a1 JTF_NUMBER_TABLE
576: , p8_a2 JTF_DATE_TABLE
577: , p8_a3 JTF_DATE_TABLE
578: , p8_a4 JTF_NUMBER_TABLE
579: , p8_a5 JTF_NUMBER_TABLE
574: , p8_a0 JTF_VARCHAR2_TABLE_100
575: , p8_a1 JTF_NUMBER_TABLE
576: , p8_a2 JTF_DATE_TABLE
577: , p8_a3 JTF_DATE_TABLE
578: , p8_a4 JTF_NUMBER_TABLE
579: , p8_a5 JTF_NUMBER_TABLE
580: , p8_a6 JTF_VARCHAR2_TABLE_100
581: , p8_a7 JTF_NUMBER_TABLE
582: , x_msg_count out nocopy NUMBER
575: , p8_a1 JTF_NUMBER_TABLE
576: , p8_a2 JTF_DATE_TABLE
577: , p8_a3 JTF_DATE_TABLE
578: , p8_a4 JTF_NUMBER_TABLE
579: , p8_a5 JTF_NUMBER_TABLE
580: , p8_a6 JTF_VARCHAR2_TABLE_100
581: , p8_a7 JTF_NUMBER_TABLE
582: , x_msg_count out nocopy NUMBER
583: , x_msg_data out nocopy VARCHAR2
577: , p8_a3 JTF_DATE_TABLE
578: , p8_a4 JTF_NUMBER_TABLE
579: , p8_a5 JTF_NUMBER_TABLE
580: , p8_a6 JTF_VARCHAR2_TABLE_100
581: , p8_a7 JTF_NUMBER_TABLE
582: , x_msg_count out nocopy NUMBER
583: , x_msg_data out nocopy VARCHAR2
584: , x_return_status out nocopy VARCHAR2
585: , p12_a0 out nocopy NUMBER
584: , x_return_status out nocopy VARCHAR2
585: , p12_a0 out nocopy NUMBER
586: , p12_a1 out nocopy NUMBER
587: , p12_a2 out nocopy VARCHAR2
588: , p13_a0 out nocopy JTF_NUMBER_TABLE
589: , p13_a1 out nocopy JTF_NUMBER_TABLE
590: , p13_a2 out nocopy JTF_VARCHAR2_TABLE_200
591: , p4_a0 NUMBER := 0-1962.0724
592: , p4_a1 NUMBER := 0-1962.0724
585: , p12_a0 out nocopy NUMBER
586: , p12_a1 out nocopy NUMBER
587: , p12_a2 out nocopy VARCHAR2
588: , p13_a0 out nocopy JTF_NUMBER_TABLE
589: , p13_a1 out nocopy JTF_NUMBER_TABLE
590: , p13_a2 out nocopy JTF_VARCHAR2_TABLE_200
591: , p4_a0 NUMBER := 0-1962.0724
592: , p4_a1 NUMBER := 0-1962.0724
593: , p4_a2 VARCHAR2 := fnd_api.g_miss_char