1: package body ahl_cmp_pvt_w as
2: /* $Header: AHLWCMPB.pls 120.0.12020000.2 2012/12/13 05:15:14 shnatu noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package body ahl_cmp_pvt_w as
2: /* $Header: AHLWCMPB.pls 120.0.12020000.2 2012/12/13 05:15:14 shnatu noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_300
15: , a12 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_300
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: ) as
44: end loop;
45: end if;
46: end if;
47: end rosetta_table_copy_in_p4;
48: procedure rosetta_table_copy_out_p4(t ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
46: end if;
47: end rosetta_table_copy_in_p4;
48: procedure rosetta_table_copy_out_p4(t ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
48: procedure rosetta_table_copy_out_p4(t ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100
58: , a10 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100
58: , a10 out nocopy JTF_NUMBER_TABLE
59: , a11 out nocopy JTF_VARCHAR2_TABLE_300
60: , a12 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100
58: , a10 out nocopy JTF_NUMBER_TABLE
59: , a11 out nocopy JTF_VARCHAR2_TABLE_300
60: , a12 out nocopy JTF_VARCHAR2_TABLE_100
61: , a13 out nocopy JTF_VARCHAR2_TABLE_100
62: ) as
62: ) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();
67: a1 := JTF_VARCHAR2_TABLE_100();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_VARCHAR2_TABLE_100();
70: a4 := JTF_NUMBER_TABLE();
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();
67: a1 := JTF_VARCHAR2_TABLE_100();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_VARCHAR2_TABLE_100();
70: a4 := JTF_NUMBER_TABLE();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_NUMBER_TABLE();
66: a0 := JTF_NUMBER_TABLE();
67: a1 := JTF_VARCHAR2_TABLE_100();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_VARCHAR2_TABLE_100();
70: a4 := JTF_NUMBER_TABLE();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_NUMBER_TABLE();
73: a7 := JTF_VARCHAR2_TABLE_300();
74: a8 := JTF_NUMBER_TABLE();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_VARCHAR2_TABLE_100();
70: a4 := JTF_NUMBER_TABLE();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_NUMBER_TABLE();
73: a7 := JTF_VARCHAR2_TABLE_300();
74: a8 := JTF_NUMBER_TABLE();
75: a9 := JTF_VARCHAR2_TABLE_100();
76: a10 := JTF_NUMBER_TABLE();
70: a4 := JTF_NUMBER_TABLE();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_NUMBER_TABLE();
73: a7 := JTF_VARCHAR2_TABLE_300();
74: a8 := JTF_NUMBER_TABLE();
75: a9 := JTF_VARCHAR2_TABLE_100();
76: a10 := JTF_NUMBER_TABLE();
77: a11 := JTF_VARCHAR2_TABLE_300();
78: a12 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_NUMBER_TABLE();
73: a7 := JTF_VARCHAR2_TABLE_300();
74: a8 := JTF_NUMBER_TABLE();
75: a9 := JTF_VARCHAR2_TABLE_100();
76: a10 := JTF_NUMBER_TABLE();
77: a11 := JTF_VARCHAR2_TABLE_300();
78: a12 := JTF_VARCHAR2_TABLE_100();
79: a13 := JTF_VARCHAR2_TABLE_100();
80: else
77: a11 := JTF_VARCHAR2_TABLE_300();
78: a12 := JTF_VARCHAR2_TABLE_100();
79: a13 := JTF_VARCHAR2_TABLE_100();
80: else
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_VARCHAR2_TABLE_100();
83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_VARCHAR2_TABLE_100();
85: a4 := JTF_NUMBER_TABLE();
79: a13 := JTF_VARCHAR2_TABLE_100();
80: else
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_VARCHAR2_TABLE_100();
83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_VARCHAR2_TABLE_100();
85: a4 := JTF_NUMBER_TABLE();
86: a5 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_NUMBER_TABLE();
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_VARCHAR2_TABLE_100();
83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_VARCHAR2_TABLE_100();
85: a4 := JTF_NUMBER_TABLE();
86: a5 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_NUMBER_TABLE();
88: a7 := JTF_VARCHAR2_TABLE_300();
89: a8 := JTF_NUMBER_TABLE();
83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_VARCHAR2_TABLE_100();
85: a4 := JTF_NUMBER_TABLE();
86: a5 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_NUMBER_TABLE();
88: a7 := JTF_VARCHAR2_TABLE_300();
89: a8 := JTF_NUMBER_TABLE();
90: a9 := JTF_VARCHAR2_TABLE_100();
91: a10 := JTF_NUMBER_TABLE();
85: a4 := JTF_NUMBER_TABLE();
86: a5 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_NUMBER_TABLE();
88: a7 := JTF_VARCHAR2_TABLE_300();
89: a8 := JTF_NUMBER_TABLE();
90: a9 := JTF_VARCHAR2_TABLE_100();
91: a10 := JTF_NUMBER_TABLE();
92: a11 := JTF_VARCHAR2_TABLE_300();
93: a12 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_NUMBER_TABLE();
88: a7 := JTF_VARCHAR2_TABLE_300();
89: a8 := JTF_NUMBER_TABLE();
90: a9 := JTF_VARCHAR2_TABLE_100();
91: a10 := JTF_NUMBER_TABLE();
92: a11 := JTF_VARCHAR2_TABLE_300();
93: a12 := JTF_VARCHAR2_TABLE_100();
94: a13 := JTF_VARCHAR2_TABLE_100();
95: if t.count > 0 then
133: end if;
134: end if;
135: end rosetta_table_copy_out_p4;
136:
137: procedure rosetta_table_copy_in_p6(t out nocopy ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 JTF_NUMBER_TABLE
138: , a1 JTF_VARCHAR2_TABLE_300
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_VARCHAR2_TABLE_100
141: , a4 JTF_NUMBER_TABLE
135: end rosetta_table_copy_out_p4;
136:
137: procedure rosetta_table_copy_in_p6(t out nocopy ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 JTF_NUMBER_TABLE
138: , a1 JTF_VARCHAR2_TABLE_300
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_VARCHAR2_TABLE_100
141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_NUMBER_TABLE
137: procedure rosetta_table_copy_in_p6(t out nocopy ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 JTF_NUMBER_TABLE
138: , a1 JTF_VARCHAR2_TABLE_300
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_VARCHAR2_TABLE_100
141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_NUMBER_TABLE
144: , a7 JTF_VARCHAR2_TABLE_100
145: , a8 JTF_NUMBER_TABLE
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_VARCHAR2_TABLE_100
141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_NUMBER_TABLE
144: , a7 JTF_VARCHAR2_TABLE_100
145: , a8 JTF_NUMBER_TABLE
146: , a9 JTF_VARCHAR2_TABLE_300
147: , a10 JTF_NUMBER_TABLE
141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_NUMBER_TABLE
144: , a7 JTF_VARCHAR2_TABLE_100
145: , a8 JTF_NUMBER_TABLE
146: , a9 JTF_VARCHAR2_TABLE_300
147: , a10 JTF_NUMBER_TABLE
148: , a11 JTF_NUMBER_TABLE
149: , a12 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_NUMBER_TABLE
144: , a7 JTF_VARCHAR2_TABLE_100
145: , a8 JTF_NUMBER_TABLE
146: , a9 JTF_VARCHAR2_TABLE_300
147: , a10 JTF_NUMBER_TABLE
148: , a11 JTF_NUMBER_TABLE
149: , a12 JTF_VARCHAR2_TABLE_100
150: , a13 JTF_VARCHAR2_TABLE_100
151: , a14 JTF_VARCHAR2_TABLE_100
144: , a7 JTF_VARCHAR2_TABLE_100
145: , a8 JTF_NUMBER_TABLE
146: , a9 JTF_VARCHAR2_TABLE_300
147: , a10 JTF_NUMBER_TABLE
148: , a11 JTF_NUMBER_TABLE
149: , a12 JTF_VARCHAR2_TABLE_100
150: , a13 JTF_VARCHAR2_TABLE_100
151: , a14 JTF_VARCHAR2_TABLE_100
152: , a15 JTF_NUMBER_TABLE
148: , a11 JTF_NUMBER_TABLE
149: , a12 JTF_VARCHAR2_TABLE_100
150: , a13 JTF_VARCHAR2_TABLE_100
151: , a14 JTF_VARCHAR2_TABLE_100
152: , a15 JTF_NUMBER_TABLE
153: , a16 JTF_NUMBER_TABLE
154: ) as
155: ddindx binary_integer; indx binary_integer;
156: begin
149: , a12 JTF_VARCHAR2_TABLE_100
150: , a13 JTF_VARCHAR2_TABLE_100
151: , a14 JTF_VARCHAR2_TABLE_100
152: , a15 JTF_NUMBER_TABLE
153: , a16 JTF_NUMBER_TABLE
154: ) as
155: ddindx binary_integer; indx binary_integer;
156: begin
157: if a0 is not null and a0.count > 0 then
184: end loop;
185: end if;
186: end if;
187: end rosetta_table_copy_in_p6;
188: procedure rosetta_table_copy_out_p6(t ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
189: , a1 out nocopy JTF_VARCHAR2_TABLE_300
190: , a2 out nocopy JTF_NUMBER_TABLE
191: , a3 out nocopy JTF_VARCHAR2_TABLE_100
192: , a4 out nocopy JTF_NUMBER_TABLE
186: end if;
187: end rosetta_table_copy_in_p6;
188: procedure rosetta_table_copy_out_p6(t ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
189: , a1 out nocopy JTF_VARCHAR2_TABLE_300
190: , a2 out nocopy JTF_NUMBER_TABLE
191: , a3 out nocopy JTF_VARCHAR2_TABLE_100
192: , a4 out nocopy JTF_NUMBER_TABLE
193: , a5 out nocopy JTF_VARCHAR2_TABLE_100
194: , a6 out nocopy JTF_NUMBER_TABLE
188: procedure rosetta_table_copy_out_p6(t ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
189: , a1 out nocopy JTF_VARCHAR2_TABLE_300
190: , a2 out nocopy JTF_NUMBER_TABLE
191: , a3 out nocopy JTF_VARCHAR2_TABLE_100
192: , a4 out nocopy JTF_NUMBER_TABLE
193: , a5 out nocopy JTF_VARCHAR2_TABLE_100
194: , a6 out nocopy JTF_NUMBER_TABLE
195: , a7 out nocopy JTF_VARCHAR2_TABLE_100
196: , a8 out nocopy JTF_NUMBER_TABLE
190: , a2 out nocopy JTF_NUMBER_TABLE
191: , a3 out nocopy JTF_VARCHAR2_TABLE_100
192: , a4 out nocopy JTF_NUMBER_TABLE
193: , a5 out nocopy JTF_VARCHAR2_TABLE_100
194: , a6 out nocopy JTF_NUMBER_TABLE
195: , a7 out nocopy JTF_VARCHAR2_TABLE_100
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_VARCHAR2_TABLE_300
198: , a10 out nocopy JTF_NUMBER_TABLE
192: , a4 out nocopy JTF_NUMBER_TABLE
193: , a5 out nocopy JTF_VARCHAR2_TABLE_100
194: , a6 out nocopy JTF_NUMBER_TABLE
195: , a7 out nocopy JTF_VARCHAR2_TABLE_100
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_VARCHAR2_TABLE_300
198: , a10 out nocopy JTF_NUMBER_TABLE
199: , a11 out nocopy JTF_NUMBER_TABLE
200: , a12 out nocopy JTF_VARCHAR2_TABLE_100
194: , a6 out nocopy JTF_NUMBER_TABLE
195: , a7 out nocopy JTF_VARCHAR2_TABLE_100
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_VARCHAR2_TABLE_300
198: , a10 out nocopy JTF_NUMBER_TABLE
199: , a11 out nocopy JTF_NUMBER_TABLE
200: , a12 out nocopy JTF_VARCHAR2_TABLE_100
201: , a13 out nocopy JTF_VARCHAR2_TABLE_100
202: , a14 out nocopy JTF_VARCHAR2_TABLE_100
195: , a7 out nocopy JTF_VARCHAR2_TABLE_100
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_VARCHAR2_TABLE_300
198: , a10 out nocopy JTF_NUMBER_TABLE
199: , a11 out nocopy JTF_NUMBER_TABLE
200: , a12 out nocopy JTF_VARCHAR2_TABLE_100
201: , a13 out nocopy JTF_VARCHAR2_TABLE_100
202: , a14 out nocopy JTF_VARCHAR2_TABLE_100
203: , a15 out nocopy JTF_NUMBER_TABLE
199: , a11 out nocopy JTF_NUMBER_TABLE
200: , a12 out nocopy JTF_VARCHAR2_TABLE_100
201: , a13 out nocopy JTF_VARCHAR2_TABLE_100
202: , a14 out nocopy JTF_VARCHAR2_TABLE_100
203: , a15 out nocopy JTF_NUMBER_TABLE
204: , a16 out nocopy JTF_NUMBER_TABLE
205: ) as
206: ddindx binary_integer; indx binary_integer;
207: begin
200: , a12 out nocopy JTF_VARCHAR2_TABLE_100
201: , a13 out nocopy JTF_VARCHAR2_TABLE_100
202: , a14 out nocopy JTF_VARCHAR2_TABLE_100
203: , a15 out nocopy JTF_NUMBER_TABLE
204: , a16 out nocopy JTF_NUMBER_TABLE
205: ) as
206: ddindx binary_integer; indx binary_integer;
207: begin
208: if t is null or t.count = 0 then
205: ) as
206: ddindx binary_integer; indx binary_integer;
207: begin
208: if t is null or t.count = 0 then
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_VARCHAR2_TABLE_300();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();
207: begin
208: if t is null or t.count = 0 then
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_VARCHAR2_TABLE_300();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_NUMBER_TABLE();
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_VARCHAR2_TABLE_300();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_VARCHAR2_TABLE_300();
219: a10 := JTF_NUMBER_TABLE();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_VARCHAR2_TABLE_300();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_VARCHAR2_TABLE_300();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_VARCHAR2_TABLE_100();
222: a13 := JTF_VARCHAR2_TABLE_100();
223: a14 := JTF_VARCHAR2_TABLE_100();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_VARCHAR2_TABLE_300();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_VARCHAR2_TABLE_100();
222: a13 := JTF_VARCHAR2_TABLE_100();
223: a14 := JTF_VARCHAR2_TABLE_100();
224: a15 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_VARCHAR2_TABLE_100();
222: a13 := JTF_VARCHAR2_TABLE_100();
223: a14 := JTF_VARCHAR2_TABLE_100();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: else
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_300();
221: a12 := JTF_VARCHAR2_TABLE_100();
222: a13 := JTF_VARCHAR2_TABLE_100();
223: a14 := JTF_VARCHAR2_TABLE_100();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: else
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_300();
229: a2 := JTF_NUMBER_TABLE();
223: a14 := JTF_VARCHAR2_TABLE_100();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: else
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_300();
229: a2 := JTF_NUMBER_TABLE();
230: a3 := JTF_VARCHAR2_TABLE_100();
231: a4 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: else
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_300();
229: a2 := JTF_NUMBER_TABLE();
230: a3 := JTF_VARCHAR2_TABLE_100();
231: a4 := JTF_NUMBER_TABLE();
232: a5 := JTF_VARCHAR2_TABLE_100();
233: a6 := JTF_NUMBER_TABLE();
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_300();
229: a2 := JTF_NUMBER_TABLE();
230: a3 := JTF_VARCHAR2_TABLE_100();
231: a4 := JTF_NUMBER_TABLE();
232: a5 := JTF_VARCHAR2_TABLE_100();
233: a6 := JTF_NUMBER_TABLE();
234: a7 := JTF_VARCHAR2_TABLE_100();
235: a8 := JTF_NUMBER_TABLE();
229: a2 := JTF_NUMBER_TABLE();
230: a3 := JTF_VARCHAR2_TABLE_100();
231: a4 := JTF_NUMBER_TABLE();
232: a5 := JTF_VARCHAR2_TABLE_100();
233: a6 := JTF_NUMBER_TABLE();
234: a7 := JTF_VARCHAR2_TABLE_100();
235: a8 := JTF_NUMBER_TABLE();
236: a9 := JTF_VARCHAR2_TABLE_300();
237: a10 := JTF_NUMBER_TABLE();
231: a4 := JTF_NUMBER_TABLE();
232: a5 := JTF_VARCHAR2_TABLE_100();
233: a6 := JTF_NUMBER_TABLE();
234: a7 := JTF_VARCHAR2_TABLE_100();
235: a8 := JTF_NUMBER_TABLE();
236: a9 := JTF_VARCHAR2_TABLE_300();
237: a10 := JTF_NUMBER_TABLE();
238: a11 := JTF_NUMBER_TABLE();
239: a12 := JTF_VARCHAR2_TABLE_100();
233: a6 := JTF_NUMBER_TABLE();
234: a7 := JTF_VARCHAR2_TABLE_100();
235: a8 := JTF_NUMBER_TABLE();
236: a9 := JTF_VARCHAR2_TABLE_300();
237: a10 := JTF_NUMBER_TABLE();
238: a11 := JTF_NUMBER_TABLE();
239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_VARCHAR2_TABLE_100();
241: a14 := JTF_VARCHAR2_TABLE_100();
234: a7 := JTF_VARCHAR2_TABLE_100();
235: a8 := JTF_NUMBER_TABLE();
236: a9 := JTF_VARCHAR2_TABLE_300();
237: a10 := JTF_NUMBER_TABLE();
238: a11 := JTF_NUMBER_TABLE();
239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_VARCHAR2_TABLE_100();
241: a14 := JTF_VARCHAR2_TABLE_100();
242: a15 := JTF_NUMBER_TABLE();
238: a11 := JTF_NUMBER_TABLE();
239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_VARCHAR2_TABLE_100();
241: a14 := JTF_VARCHAR2_TABLE_100();
242: a15 := JTF_NUMBER_TABLE();
243: a16 := JTF_NUMBER_TABLE();
244: if t.count > 0 then
245: a0.extend(t.count);
246: a1.extend(t.count);
239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_VARCHAR2_TABLE_100();
241: a14 := JTF_VARCHAR2_TABLE_100();
242: a15 := JTF_NUMBER_TABLE();
243: a16 := JTF_NUMBER_TABLE();
244: if t.count > 0 then
245: a0.extend(t.count);
246: a1.extend(t.count);
247: a2.extend(t.count);
292: procedure perform_mtl_xfr(p_api_version NUMBER
293: , p_init_msg_list VARCHAR2
294: , p_commit VARCHAR2
295: , p_validation_level NUMBER
296: , p4_a0 in out nocopy JTF_NUMBER_TABLE
297: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
298: , p4_a2 in out nocopy JTF_NUMBER_TABLE
299: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p4_a4 in out nocopy JTF_NUMBER_TABLE
294: , p_commit VARCHAR2
295: , p_validation_level NUMBER
296: , p4_a0 in out nocopy JTF_NUMBER_TABLE
297: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
298: , p4_a2 in out nocopy JTF_NUMBER_TABLE
299: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p4_a4 in out nocopy JTF_NUMBER_TABLE
301: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p4_a6 in out nocopy JTF_NUMBER_TABLE
296: , p4_a0 in out nocopy JTF_NUMBER_TABLE
297: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
298: , p4_a2 in out nocopy JTF_NUMBER_TABLE
299: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p4_a4 in out nocopy JTF_NUMBER_TABLE
301: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p4_a6 in out nocopy JTF_NUMBER_TABLE
303: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_300
304: , p4_a8 in out nocopy JTF_NUMBER_TABLE
298: , p4_a2 in out nocopy JTF_NUMBER_TABLE
299: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p4_a4 in out nocopy JTF_NUMBER_TABLE
301: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p4_a6 in out nocopy JTF_NUMBER_TABLE
303: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_300
304: , p4_a8 in out nocopy JTF_NUMBER_TABLE
305: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
306: , p4_a10 in out nocopy JTF_NUMBER_TABLE
300: , p4_a4 in out nocopy JTF_NUMBER_TABLE
301: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p4_a6 in out nocopy JTF_NUMBER_TABLE
303: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_300
304: , p4_a8 in out nocopy JTF_NUMBER_TABLE
305: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
306: , p4_a10 in out nocopy JTF_NUMBER_TABLE
307: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_300
308: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p4_a6 in out nocopy JTF_NUMBER_TABLE
303: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_300
304: , p4_a8 in out nocopy JTF_NUMBER_TABLE
305: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
306: , p4_a10 in out nocopy JTF_NUMBER_TABLE
307: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_300
308: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
310: , x_return_status out nocopy VARCHAR2
379: procedure perform_return_txn(p_api_version NUMBER
380: , p_init_msg_list VARCHAR2
381: , p_commit VARCHAR2
382: , p_validation_level NUMBER
383: , p4_a0 in out nocopy JTF_NUMBER_TABLE
384: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_300
385: , p4_a2 in out nocopy JTF_NUMBER_TABLE
386: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a4 in out nocopy JTF_NUMBER_TABLE
381: , p_commit VARCHAR2
382: , p_validation_level NUMBER
383: , p4_a0 in out nocopy JTF_NUMBER_TABLE
384: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_300
385: , p4_a2 in out nocopy JTF_NUMBER_TABLE
386: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a4 in out nocopy JTF_NUMBER_TABLE
388: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p4_a6 in out nocopy JTF_NUMBER_TABLE
383: , p4_a0 in out nocopy JTF_NUMBER_TABLE
384: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_300
385: , p4_a2 in out nocopy JTF_NUMBER_TABLE
386: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a4 in out nocopy JTF_NUMBER_TABLE
388: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p4_a6 in out nocopy JTF_NUMBER_TABLE
390: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a8 in out nocopy JTF_NUMBER_TABLE
385: , p4_a2 in out nocopy JTF_NUMBER_TABLE
386: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a4 in out nocopy JTF_NUMBER_TABLE
388: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p4_a6 in out nocopy JTF_NUMBER_TABLE
390: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a8 in out nocopy JTF_NUMBER_TABLE
392: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_300
393: , p4_a10 in out nocopy JTF_NUMBER_TABLE
387: , p4_a4 in out nocopy JTF_NUMBER_TABLE
388: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p4_a6 in out nocopy JTF_NUMBER_TABLE
390: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a8 in out nocopy JTF_NUMBER_TABLE
392: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_300
393: , p4_a10 in out nocopy JTF_NUMBER_TABLE
394: , p4_a11 in out nocopy JTF_NUMBER_TABLE
395: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p4_a6 in out nocopy JTF_NUMBER_TABLE
390: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a8 in out nocopy JTF_NUMBER_TABLE
392: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_300
393: , p4_a10 in out nocopy JTF_NUMBER_TABLE
394: , p4_a11 in out nocopy JTF_NUMBER_TABLE
395: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
390: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a8 in out nocopy JTF_NUMBER_TABLE
392: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_300
393: , p4_a10 in out nocopy JTF_NUMBER_TABLE
394: , p4_a11 in out nocopy JTF_NUMBER_TABLE
395: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
398: , p4_a15 in out nocopy JTF_NUMBER_TABLE
394: , p4_a11 in out nocopy JTF_NUMBER_TABLE
395: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
398: , p4_a15 in out nocopy JTF_NUMBER_TABLE
399: , p4_a16 in out nocopy JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2
395: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
398: , p4_a15 in out nocopy JTF_NUMBER_TABLE
399: , p4_a16 in out nocopy JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2
403: )