1: package body ahl_osp_shipment_pub_w as
2: /* $Header: AHLWOSHB.pls 120.1 2007/07/30 10:43:57 mpothuku ship $ */
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
1: package body ahl_osp_shipment_pub_w as
2: /* $Header: AHLWOSHB.pls 120.1 2007/07/30 10:43:57 mpothuku ship $ */
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
1: package body ahl_osp_shipment_pub_w as
2: /* $Header: AHLWOSHB.pls 120.1 2007/07/30 10:43:57 mpothuku ship $ */
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
2: /* $Header: AHLWOSHB.pls 120.1 2007/07/30 10:43:57 mpothuku ship $ */
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
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
13: , a10 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
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
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
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;
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
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;
16: begin
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;
16: begin
17: if a0 is not null and a0.count > 0 then
38: end loop;
39: end if;
40: end if;
41: end rosetta_table_copy_in_p1;
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
39: end if;
40: end if;
41: end rosetta_table_copy_in_p1;
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
40: end if;
41: end rosetta_table_copy_in_p1;
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
41: end rosetta_table_copy_in_p1;
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
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
52: , a10 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
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
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
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
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
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
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
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then
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();
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then
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();
55: begin
56: if t is null or t.count = 0 then
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();
56: if t is null or t.count = 0 then
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();
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();
67: a10 := 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();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
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();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_VARCHAR2_TABLE_100();
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();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_VARCHAR2_TABLE_100();
70: a1 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_VARCHAR2_TABLE_100();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_VARCHAR2_TABLE_100();
70: a1 := JTF_VARCHAR2_TABLE_100();
71: a2 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_VARCHAR2_TABLE_100();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
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();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
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();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
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();
68: else
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();
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();
79: a10 := 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();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
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();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);
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();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);
75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_VARCHAR2_TABLE_100();
77: a8 := JTF_VARCHAR2_TABLE_100();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);
83: a2.extend(t.count);
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
125: , a9 JTF_NUMBER_TABLE
126: , a10 JTF_VARCHAR2_TABLE_300
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
130: , a14 JTF_VARCHAR2_TABLE_300
131: , a15 JTF_VARCHAR2_TABLE_100
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
134: , a18 JTF_VARCHAR2_TABLE_100
135: , a19 JTF_NUMBER_TABLE
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
134: , a18 JTF_VARCHAR2_TABLE_100
135: , a19 JTF_NUMBER_TABLE
136: , a20 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
138: , a22 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
141: , a25 JTF_VARCHAR2_TABLE_2000
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
141: , a25 JTF_VARCHAR2_TABLE_2000
142: , a26 JTF_VARCHAR2_TABLE_300
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
148: , a32 JTF_VARCHAR2_TABLE_300
149: , a33 JTF_VARCHAR2_TABLE_100
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
148: , a32 JTF_VARCHAR2_TABLE_300
149: , a33 JTF_VARCHAR2_TABLE_100
150: , a34 JTF_VARCHAR2_TABLE_100
151: , a35 JTF_VARCHAR2_TABLE_300
145: , a29 JTF_VARCHAR2_TABLE_100
146: , a30 JTF_VARCHAR2_TABLE_300
147: , a31 JTF_VARCHAR2_TABLE_100
148: , a32 JTF_VARCHAR2_TABLE_300
149: , a33 JTF_VARCHAR2_TABLE_100
150: , a34 JTF_VARCHAR2_TABLE_100
151: , a35 JTF_VARCHAR2_TABLE_300
152: , a36 JTF_VARCHAR2_TABLE_100
153: , a37 JTF_VARCHAR2_TABLE_300
146: , a30 JTF_VARCHAR2_TABLE_300
147: , a31 JTF_VARCHAR2_TABLE_100
148: , a32 JTF_VARCHAR2_TABLE_300
149: , a33 JTF_VARCHAR2_TABLE_100
150: , a34 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
148: , a32 JTF_VARCHAR2_TABLE_300
149: , a33 JTF_VARCHAR2_TABLE_100
150: , a34 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
150: , a34 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
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
160: , a44 JTF_VARCHAR2_TABLE_100
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
162: ddindx binary_integer; indx binary_integer;
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
164: if a0 is not null and a0.count > 0 then
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
232: , a9 out nocopy JTF_NUMBER_TABLE
233: , a10 out nocopy JTF_VARCHAR2_TABLE_300
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
237: , a14 out nocopy JTF_VARCHAR2_TABLE_300
238: , a15 out nocopy JTF_VARCHAR2_TABLE_100
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
241: , a18 out nocopy JTF_VARCHAR2_TABLE_100
242: , a19 out nocopy JTF_NUMBER_TABLE
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
241: , a18 out nocopy JTF_VARCHAR2_TABLE_100
242: , a19 out nocopy JTF_NUMBER_TABLE
243: , a20 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
245: , a22 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
248: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
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
248: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
249: , a26 out nocopy JTF_VARCHAR2_TABLE_300
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
255: , a32 out nocopy JTF_VARCHAR2_TABLE_300
256: , a33 out nocopy JTF_VARCHAR2_TABLE_100
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
255: , a32 out nocopy JTF_VARCHAR2_TABLE_300
256: , a33 out nocopy JTF_VARCHAR2_TABLE_100
257: , a34 out nocopy JTF_VARCHAR2_TABLE_100
258: , a35 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
255: , a32 out nocopy JTF_VARCHAR2_TABLE_300
256: , a33 out nocopy JTF_VARCHAR2_TABLE_100
257: , a34 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
253: , a30 out nocopy JTF_VARCHAR2_TABLE_300
254: , a31 out nocopy JTF_VARCHAR2_TABLE_100
255: , a32 out nocopy JTF_VARCHAR2_TABLE_300
256: , a33 out nocopy JTF_VARCHAR2_TABLE_100
257: , a34 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
255: , a32 out nocopy JTF_VARCHAR2_TABLE_300
256: , a33 out nocopy JTF_VARCHAR2_TABLE_100
257: , a34 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
257: , a34 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
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
267: , a44 out nocopy JTF_VARCHAR2_TABLE_100
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
269: ddindx binary_integer; indx binary_integer;
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
271: if t is null or t.count = 0 then
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();
281: a9 := JTF_NUMBER_TABLE();
282: a10 := JTF_VARCHAR2_TABLE_300();
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();
286: a14 := JTF_VARCHAR2_TABLE_300();
287: a15 := JTF_VARCHAR2_TABLE_100();
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();
290: a18 := JTF_VARCHAR2_TABLE_100();
291: a19 := JTF_NUMBER_TABLE();
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();
290: a18 := JTF_VARCHAR2_TABLE_100();
291: a19 := JTF_NUMBER_TABLE();
292: a20 := 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();
294: a22 := 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();
297: a25 := JTF_VARCHAR2_TABLE_2000();
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();
297: a25 := JTF_VARCHAR2_TABLE_2000();
298: a26 := JTF_VARCHAR2_TABLE_300();
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();
304: a32 := JTF_VARCHAR2_TABLE_300();
305: a33 := JTF_VARCHAR2_TABLE_100();
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();
304: a32 := JTF_VARCHAR2_TABLE_300();
305: a33 := JTF_VARCHAR2_TABLE_100();
306: a34 := JTF_VARCHAR2_TABLE_100();
307: a35 := JTF_VARCHAR2_TABLE_300();
301: a29 := JTF_VARCHAR2_TABLE_100();
302: a30 := JTF_VARCHAR2_TABLE_300();
303: a31 := JTF_VARCHAR2_TABLE_100();
304: a32 := JTF_VARCHAR2_TABLE_300();
305: a33 := JTF_VARCHAR2_TABLE_100();
306: a34 := JTF_VARCHAR2_TABLE_100();
307: a35 := JTF_VARCHAR2_TABLE_300();
308: a36 := JTF_VARCHAR2_TABLE_100();
309: a37 := JTF_VARCHAR2_TABLE_300();
302: a30 := JTF_VARCHAR2_TABLE_300();
303: a31 := JTF_VARCHAR2_TABLE_100();
304: a32 := JTF_VARCHAR2_TABLE_300();
305: a33 := JTF_VARCHAR2_TABLE_100();
306: a34 := 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();
304: a32 := JTF_VARCHAR2_TABLE_300();
305: a33 := JTF_VARCHAR2_TABLE_100();
306: a34 := 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();
306: a34 := 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();
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();
316: a44 := JTF_VARCHAR2_TABLE_100();
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
318: a0 := 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();
320: a2 := 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();
327: a9 := JTF_NUMBER_TABLE();
328: a10 := JTF_VARCHAR2_TABLE_300();
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();
332: a14 := JTF_VARCHAR2_TABLE_300();
333: a15 := JTF_VARCHAR2_TABLE_100();
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();
336: a18 := JTF_VARCHAR2_TABLE_100();
337: a19 := JTF_NUMBER_TABLE();
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();
336: a18 := JTF_VARCHAR2_TABLE_100();
337: a19 := JTF_NUMBER_TABLE();
338: a20 := 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();
340: a22 := 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();
343: a25 := JTF_VARCHAR2_TABLE_2000();
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();
343: a25 := JTF_VARCHAR2_TABLE_2000();
344: a26 := JTF_VARCHAR2_TABLE_300();
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();
350: a32 := JTF_VARCHAR2_TABLE_300();
351: a33 := JTF_VARCHAR2_TABLE_100();
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();
350: a32 := JTF_VARCHAR2_TABLE_300();
351: a33 := JTF_VARCHAR2_TABLE_100();
352: a34 := JTF_VARCHAR2_TABLE_100();
353: a35 := JTF_VARCHAR2_TABLE_300();
347: a29 := JTF_VARCHAR2_TABLE_100();
348: a30 := JTF_VARCHAR2_TABLE_300();
349: a31 := JTF_VARCHAR2_TABLE_100();
350: a32 := JTF_VARCHAR2_TABLE_300();
351: a33 := JTF_VARCHAR2_TABLE_100();
352: a34 := JTF_VARCHAR2_TABLE_100();
353: a35 := JTF_VARCHAR2_TABLE_300();
354: a36 := JTF_VARCHAR2_TABLE_100();
355: a37 := JTF_VARCHAR2_TABLE_300();
348: a30 := JTF_VARCHAR2_TABLE_300();
349: a31 := JTF_VARCHAR2_TABLE_100();
350: a32 := JTF_VARCHAR2_TABLE_300();
351: a33 := JTF_VARCHAR2_TABLE_100();
352: a34 := 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();
350: a32 := JTF_VARCHAR2_TABLE_300();
351: a33 := JTF_VARCHAR2_TABLE_100();
352: a34 := 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();
352: a34 := 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();
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();
362: a44 := JTF_VARCHAR2_TABLE_100();
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
364: a0.extend(t.count);
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);
366: a2.extend(t.count);
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
558: , p6_a9 in out nocopy JTF_NUMBER_TABLE
559: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300
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
563: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_300
564: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_100
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
567: , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a19 in out nocopy JTF_NUMBER_TABLE
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
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
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
571: , p6_a22 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
574: , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_2000
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
574: , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_2000
575: , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_300
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
581: , p6_a32 in out nocopy JTF_VARCHAR2_TABLE_300
582: , p6_a33 in out nocopy JTF_VARCHAR2_TABLE_100
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
581: , p6_a32 in out nocopy JTF_VARCHAR2_TABLE_300
582: , p6_a33 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p6_a34 in out nocopy JTF_VARCHAR2_TABLE_100
584: , p6_a35 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
581: , p6_a32 in out nocopy JTF_VARCHAR2_TABLE_300
582: , p6_a33 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p6_a34 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
579: , p6_a30 in out nocopy JTF_VARCHAR2_TABLE_300
580: , p6_a31 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p6_a32 in out nocopy JTF_VARCHAR2_TABLE_300
582: , p6_a33 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p6_a34 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
581: , p6_a32 in out nocopy JTF_VARCHAR2_TABLE_300
582: , p6_a33 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p6_a34 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
583: , p6_a34 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
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
593: , p6_a44 in out nocopy JTF_VARCHAR2_TABLE_100
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
595: , x_msg_count out nocopy NUMBER
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
597: )