1: package body ozf_offer_pub_oaw as
2: /* $Header: ozfaofpb.pls 120.1 2005/09/29 10:48 gramanat noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pub.act_product_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
1: package body ozf_offer_pub_oaw as
2: /* $Header: ozfaofpb.pls 120.1 2005/09/29 10:48 gramanat noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pub.act_product_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
1: package body ozf_offer_pub_oaw as
2: /* $Header: ozfaofpb.pls 120.1 2005/09/29 10:48 gramanat noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pub.act_product_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
26: ) as
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
26: ) as
27: ddindx binary_integer; indx binary_integer;
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
62: end loop;
63: end if;
64: end if;
65: end rosetta_table_copy_in_p2;
66: procedure rosetta_table_copy_out_p2(t ozf_offer_pub.act_product_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_NUMBER_TABLE
68: , a2 out nocopy JTF_NUMBER_TABLE
69: , a3 out nocopy JTF_VARCHAR2_TABLE_100
70: , a4 out nocopy JTF_VARCHAR2_TABLE_100
63: end if;
64: end if;
65: end rosetta_table_copy_in_p2;
66: procedure rosetta_table_copy_out_p2(t ozf_offer_pub.act_product_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_NUMBER_TABLE
68: , a2 out nocopy JTF_NUMBER_TABLE
69: , a3 out nocopy JTF_VARCHAR2_TABLE_100
70: , a4 out nocopy JTF_VARCHAR2_TABLE_100
71: , a5 out nocopy JTF_VARCHAR2_TABLE_100
64: end if;
65: end rosetta_table_copy_in_p2;
66: procedure rosetta_table_copy_out_p2(t ozf_offer_pub.act_product_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_NUMBER_TABLE
68: , a2 out nocopy JTF_NUMBER_TABLE
69: , a3 out nocopy JTF_VARCHAR2_TABLE_100
70: , a4 out nocopy JTF_VARCHAR2_TABLE_100
71: , a5 out nocopy JTF_VARCHAR2_TABLE_100
72: , a6 out nocopy JTF_VARCHAR2_TABLE_100
69: , a3 out nocopy JTF_VARCHAR2_TABLE_100
70: , a4 out nocopy JTF_VARCHAR2_TABLE_100
71: , a5 out nocopy JTF_VARCHAR2_TABLE_100
72: , a6 out nocopy JTF_VARCHAR2_TABLE_100
73: , a7 out nocopy JTF_NUMBER_TABLE
74: , a8 out nocopy JTF_NUMBER_TABLE
75: , a9 out nocopy JTF_NUMBER_TABLE
76: , a10 out nocopy JTF_NUMBER_TABLE
77: , a11 out nocopy JTF_VARCHAR2_TABLE_100
70: , a4 out nocopy JTF_VARCHAR2_TABLE_100
71: , a5 out nocopy JTF_VARCHAR2_TABLE_100
72: , a6 out nocopy JTF_VARCHAR2_TABLE_100
73: , a7 out nocopy JTF_NUMBER_TABLE
74: , a8 out nocopy JTF_NUMBER_TABLE
75: , a9 out nocopy JTF_NUMBER_TABLE
76: , a10 out nocopy JTF_NUMBER_TABLE
77: , a11 out nocopy JTF_VARCHAR2_TABLE_100
78: , a12 out nocopy JTF_VARCHAR2_TABLE_100
71: , a5 out nocopy JTF_VARCHAR2_TABLE_100
72: , a6 out nocopy JTF_VARCHAR2_TABLE_100
73: , a7 out nocopy JTF_NUMBER_TABLE
74: , a8 out nocopy JTF_NUMBER_TABLE
75: , a9 out nocopy JTF_NUMBER_TABLE
76: , a10 out nocopy JTF_NUMBER_TABLE
77: , a11 out nocopy JTF_VARCHAR2_TABLE_100
78: , a12 out nocopy JTF_VARCHAR2_TABLE_100
79: , a13 out nocopy JTF_VARCHAR2_TABLE_100
72: , a6 out nocopy JTF_VARCHAR2_TABLE_100
73: , a7 out nocopy JTF_NUMBER_TABLE
74: , a8 out nocopy JTF_NUMBER_TABLE
75: , a9 out nocopy JTF_NUMBER_TABLE
76: , a10 out nocopy JTF_NUMBER_TABLE
77: , a11 out nocopy JTF_VARCHAR2_TABLE_100
78: , a12 out nocopy JTF_VARCHAR2_TABLE_100
79: , a13 out nocopy JTF_VARCHAR2_TABLE_100
80: , a14 out nocopy JTF_NUMBER_TABLE
76: , a10 out nocopy JTF_NUMBER_TABLE
77: , a11 out nocopy JTF_VARCHAR2_TABLE_100
78: , a12 out nocopy JTF_VARCHAR2_TABLE_100
79: , a13 out nocopy JTF_VARCHAR2_TABLE_100
80: , a14 out nocopy JTF_NUMBER_TABLE
81: , a15 out nocopy JTF_NUMBER_TABLE
82: , a16 out nocopy JTF_NUMBER_TABLE
83: , a17 out nocopy JTF_VARCHAR2_TABLE_100
84: , a18 out nocopy JTF_VARCHAR2_TABLE_100
77: , a11 out nocopy JTF_VARCHAR2_TABLE_100
78: , a12 out nocopy JTF_VARCHAR2_TABLE_100
79: , a13 out nocopy JTF_VARCHAR2_TABLE_100
80: , a14 out nocopy JTF_NUMBER_TABLE
81: , a15 out nocopy JTF_NUMBER_TABLE
82: , a16 out nocopy JTF_NUMBER_TABLE
83: , a17 out nocopy JTF_VARCHAR2_TABLE_100
84: , a18 out nocopy JTF_VARCHAR2_TABLE_100
85: , a19 out nocopy JTF_NUMBER_TABLE
78: , a12 out nocopy JTF_VARCHAR2_TABLE_100
79: , a13 out nocopy JTF_VARCHAR2_TABLE_100
80: , a14 out nocopy JTF_NUMBER_TABLE
81: , a15 out nocopy JTF_NUMBER_TABLE
82: , a16 out nocopy JTF_NUMBER_TABLE
83: , a17 out nocopy JTF_VARCHAR2_TABLE_100
84: , a18 out nocopy JTF_VARCHAR2_TABLE_100
85: , a19 out nocopy JTF_NUMBER_TABLE
86: , a20 out nocopy JTF_NUMBER_TABLE
81: , a15 out nocopy JTF_NUMBER_TABLE
82: , a16 out nocopy JTF_NUMBER_TABLE
83: , a17 out nocopy JTF_VARCHAR2_TABLE_100
84: , a18 out nocopy JTF_VARCHAR2_TABLE_100
85: , a19 out nocopy JTF_NUMBER_TABLE
86: , a20 out nocopy JTF_NUMBER_TABLE
87: , a21 out nocopy JTF_NUMBER_TABLE
88: , a22 out nocopy JTF_VARCHAR2_TABLE_100
89: ) as
82: , a16 out nocopy JTF_NUMBER_TABLE
83: , a17 out nocopy JTF_VARCHAR2_TABLE_100
84: , a18 out nocopy JTF_VARCHAR2_TABLE_100
85: , a19 out nocopy JTF_NUMBER_TABLE
86: , a20 out nocopy JTF_NUMBER_TABLE
87: , a21 out nocopy JTF_NUMBER_TABLE
88: , a22 out nocopy JTF_VARCHAR2_TABLE_100
89: ) as
90: ddindx binary_integer; indx binary_integer;
83: , a17 out nocopy JTF_VARCHAR2_TABLE_100
84: , a18 out nocopy JTF_VARCHAR2_TABLE_100
85: , a19 out nocopy JTF_NUMBER_TABLE
86: , a20 out nocopy JTF_NUMBER_TABLE
87: , a21 out nocopy JTF_NUMBER_TABLE
88: , a22 out nocopy JTF_VARCHAR2_TABLE_100
89: ) as
90: ddindx binary_integer; indx binary_integer;
91: begin
89: ) as
90: ddindx binary_integer; indx binary_integer;
91: begin
92: if t is null or t.count = 0 then
93: a0 := JTF_NUMBER_TABLE();
94: a1 := JTF_NUMBER_TABLE();
95: a2 := JTF_NUMBER_TABLE();
96: a3 := JTF_VARCHAR2_TABLE_100();
97: a4 := JTF_VARCHAR2_TABLE_100();
90: ddindx binary_integer; indx binary_integer;
91: begin
92: if t is null or t.count = 0 then
93: a0 := JTF_NUMBER_TABLE();
94: a1 := JTF_NUMBER_TABLE();
95: a2 := JTF_NUMBER_TABLE();
96: a3 := JTF_VARCHAR2_TABLE_100();
97: a4 := JTF_VARCHAR2_TABLE_100();
98: a5 := JTF_VARCHAR2_TABLE_100();
91: begin
92: if t is null or t.count = 0 then
93: a0 := JTF_NUMBER_TABLE();
94: a1 := JTF_NUMBER_TABLE();
95: a2 := JTF_NUMBER_TABLE();
96: a3 := JTF_VARCHAR2_TABLE_100();
97: a4 := JTF_VARCHAR2_TABLE_100();
98: a5 := JTF_VARCHAR2_TABLE_100();
99: a6 := JTF_VARCHAR2_TABLE_100();
96: a3 := JTF_VARCHAR2_TABLE_100();
97: a4 := JTF_VARCHAR2_TABLE_100();
98: a5 := JTF_VARCHAR2_TABLE_100();
99: a6 := JTF_VARCHAR2_TABLE_100();
100: a7 := JTF_NUMBER_TABLE();
101: a8 := JTF_NUMBER_TABLE();
102: a9 := JTF_NUMBER_TABLE();
103: a10 := JTF_NUMBER_TABLE();
104: a11 := JTF_VARCHAR2_TABLE_100();
97: a4 := JTF_VARCHAR2_TABLE_100();
98: a5 := JTF_VARCHAR2_TABLE_100();
99: a6 := JTF_VARCHAR2_TABLE_100();
100: a7 := JTF_NUMBER_TABLE();
101: a8 := JTF_NUMBER_TABLE();
102: a9 := JTF_NUMBER_TABLE();
103: a10 := JTF_NUMBER_TABLE();
104: a11 := JTF_VARCHAR2_TABLE_100();
105: a12 := JTF_VARCHAR2_TABLE_100();
98: a5 := JTF_VARCHAR2_TABLE_100();
99: a6 := JTF_VARCHAR2_TABLE_100();
100: a7 := JTF_NUMBER_TABLE();
101: a8 := JTF_NUMBER_TABLE();
102: a9 := JTF_NUMBER_TABLE();
103: a10 := JTF_NUMBER_TABLE();
104: a11 := JTF_VARCHAR2_TABLE_100();
105: a12 := JTF_VARCHAR2_TABLE_100();
106: a13 := JTF_VARCHAR2_TABLE_100();
99: a6 := JTF_VARCHAR2_TABLE_100();
100: a7 := JTF_NUMBER_TABLE();
101: a8 := JTF_NUMBER_TABLE();
102: a9 := JTF_NUMBER_TABLE();
103: a10 := JTF_NUMBER_TABLE();
104: a11 := JTF_VARCHAR2_TABLE_100();
105: a12 := JTF_VARCHAR2_TABLE_100();
106: a13 := JTF_VARCHAR2_TABLE_100();
107: a14 := JTF_NUMBER_TABLE();
103: a10 := JTF_NUMBER_TABLE();
104: a11 := JTF_VARCHAR2_TABLE_100();
105: a12 := JTF_VARCHAR2_TABLE_100();
106: a13 := JTF_VARCHAR2_TABLE_100();
107: a14 := JTF_NUMBER_TABLE();
108: a15 := JTF_NUMBER_TABLE();
109: a16 := JTF_NUMBER_TABLE();
110: a17 := JTF_VARCHAR2_TABLE_100();
111: a18 := JTF_VARCHAR2_TABLE_100();
104: a11 := JTF_VARCHAR2_TABLE_100();
105: a12 := JTF_VARCHAR2_TABLE_100();
106: a13 := JTF_VARCHAR2_TABLE_100();
107: a14 := JTF_NUMBER_TABLE();
108: a15 := JTF_NUMBER_TABLE();
109: a16 := JTF_NUMBER_TABLE();
110: a17 := JTF_VARCHAR2_TABLE_100();
111: a18 := JTF_VARCHAR2_TABLE_100();
112: a19 := JTF_NUMBER_TABLE();
105: a12 := JTF_VARCHAR2_TABLE_100();
106: a13 := JTF_VARCHAR2_TABLE_100();
107: a14 := JTF_NUMBER_TABLE();
108: a15 := JTF_NUMBER_TABLE();
109: a16 := JTF_NUMBER_TABLE();
110: a17 := JTF_VARCHAR2_TABLE_100();
111: a18 := JTF_VARCHAR2_TABLE_100();
112: a19 := JTF_NUMBER_TABLE();
113: a20 := JTF_NUMBER_TABLE();
108: a15 := JTF_NUMBER_TABLE();
109: a16 := JTF_NUMBER_TABLE();
110: a17 := JTF_VARCHAR2_TABLE_100();
111: a18 := JTF_VARCHAR2_TABLE_100();
112: a19 := JTF_NUMBER_TABLE();
113: a20 := JTF_NUMBER_TABLE();
114: a21 := JTF_NUMBER_TABLE();
115: a22 := JTF_VARCHAR2_TABLE_100();
116: else
109: a16 := JTF_NUMBER_TABLE();
110: a17 := JTF_VARCHAR2_TABLE_100();
111: a18 := JTF_VARCHAR2_TABLE_100();
112: a19 := JTF_NUMBER_TABLE();
113: a20 := JTF_NUMBER_TABLE();
114: a21 := JTF_NUMBER_TABLE();
115: a22 := JTF_VARCHAR2_TABLE_100();
116: else
117: a0 := JTF_NUMBER_TABLE();
110: a17 := JTF_VARCHAR2_TABLE_100();
111: a18 := JTF_VARCHAR2_TABLE_100();
112: a19 := JTF_NUMBER_TABLE();
113: a20 := JTF_NUMBER_TABLE();
114: a21 := JTF_NUMBER_TABLE();
115: a22 := JTF_VARCHAR2_TABLE_100();
116: else
117: a0 := JTF_NUMBER_TABLE();
118: a1 := JTF_NUMBER_TABLE();
113: a20 := JTF_NUMBER_TABLE();
114: a21 := JTF_NUMBER_TABLE();
115: a22 := JTF_VARCHAR2_TABLE_100();
116: else
117: a0 := JTF_NUMBER_TABLE();
118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_NUMBER_TABLE();
120: a3 := JTF_VARCHAR2_TABLE_100();
121: a4 := JTF_VARCHAR2_TABLE_100();
114: a21 := JTF_NUMBER_TABLE();
115: a22 := JTF_VARCHAR2_TABLE_100();
116: else
117: a0 := JTF_NUMBER_TABLE();
118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_NUMBER_TABLE();
120: a3 := JTF_VARCHAR2_TABLE_100();
121: a4 := JTF_VARCHAR2_TABLE_100();
122: a5 := JTF_VARCHAR2_TABLE_100();
115: a22 := JTF_VARCHAR2_TABLE_100();
116: else
117: a0 := JTF_NUMBER_TABLE();
118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_NUMBER_TABLE();
120: a3 := JTF_VARCHAR2_TABLE_100();
121: a4 := JTF_VARCHAR2_TABLE_100();
122: a5 := JTF_VARCHAR2_TABLE_100();
123: a6 := JTF_VARCHAR2_TABLE_100();
120: a3 := JTF_VARCHAR2_TABLE_100();
121: a4 := JTF_VARCHAR2_TABLE_100();
122: a5 := JTF_VARCHAR2_TABLE_100();
123: a6 := JTF_VARCHAR2_TABLE_100();
124: a7 := JTF_NUMBER_TABLE();
125: a8 := JTF_NUMBER_TABLE();
126: a9 := JTF_NUMBER_TABLE();
127: a10 := JTF_NUMBER_TABLE();
128: a11 := JTF_VARCHAR2_TABLE_100();
121: a4 := JTF_VARCHAR2_TABLE_100();
122: a5 := JTF_VARCHAR2_TABLE_100();
123: a6 := JTF_VARCHAR2_TABLE_100();
124: a7 := JTF_NUMBER_TABLE();
125: a8 := JTF_NUMBER_TABLE();
126: a9 := JTF_NUMBER_TABLE();
127: a10 := JTF_NUMBER_TABLE();
128: a11 := JTF_VARCHAR2_TABLE_100();
129: a12 := JTF_VARCHAR2_TABLE_100();
122: a5 := JTF_VARCHAR2_TABLE_100();
123: a6 := JTF_VARCHAR2_TABLE_100();
124: a7 := JTF_NUMBER_TABLE();
125: a8 := JTF_NUMBER_TABLE();
126: a9 := JTF_NUMBER_TABLE();
127: a10 := JTF_NUMBER_TABLE();
128: a11 := JTF_VARCHAR2_TABLE_100();
129: a12 := JTF_VARCHAR2_TABLE_100();
130: a13 := JTF_VARCHAR2_TABLE_100();
123: a6 := JTF_VARCHAR2_TABLE_100();
124: a7 := JTF_NUMBER_TABLE();
125: a8 := JTF_NUMBER_TABLE();
126: a9 := JTF_NUMBER_TABLE();
127: a10 := JTF_NUMBER_TABLE();
128: a11 := JTF_VARCHAR2_TABLE_100();
129: a12 := JTF_VARCHAR2_TABLE_100();
130: a13 := JTF_VARCHAR2_TABLE_100();
131: a14 := JTF_NUMBER_TABLE();
127: a10 := JTF_NUMBER_TABLE();
128: a11 := JTF_VARCHAR2_TABLE_100();
129: a12 := JTF_VARCHAR2_TABLE_100();
130: a13 := JTF_VARCHAR2_TABLE_100();
131: a14 := JTF_NUMBER_TABLE();
132: a15 := JTF_NUMBER_TABLE();
133: a16 := JTF_NUMBER_TABLE();
134: a17 := JTF_VARCHAR2_TABLE_100();
135: a18 := JTF_VARCHAR2_TABLE_100();
128: a11 := JTF_VARCHAR2_TABLE_100();
129: a12 := JTF_VARCHAR2_TABLE_100();
130: a13 := JTF_VARCHAR2_TABLE_100();
131: a14 := JTF_NUMBER_TABLE();
132: a15 := JTF_NUMBER_TABLE();
133: a16 := JTF_NUMBER_TABLE();
134: a17 := JTF_VARCHAR2_TABLE_100();
135: a18 := JTF_VARCHAR2_TABLE_100();
136: a19 := JTF_NUMBER_TABLE();
129: a12 := JTF_VARCHAR2_TABLE_100();
130: a13 := JTF_VARCHAR2_TABLE_100();
131: a14 := JTF_NUMBER_TABLE();
132: a15 := JTF_NUMBER_TABLE();
133: a16 := JTF_NUMBER_TABLE();
134: a17 := JTF_VARCHAR2_TABLE_100();
135: a18 := JTF_VARCHAR2_TABLE_100();
136: a19 := JTF_NUMBER_TABLE();
137: a20 := JTF_NUMBER_TABLE();
132: a15 := JTF_NUMBER_TABLE();
133: a16 := JTF_NUMBER_TABLE();
134: a17 := JTF_VARCHAR2_TABLE_100();
135: a18 := JTF_VARCHAR2_TABLE_100();
136: a19 := JTF_NUMBER_TABLE();
137: a20 := JTF_NUMBER_TABLE();
138: a21 := JTF_NUMBER_TABLE();
139: a22 := JTF_VARCHAR2_TABLE_100();
140: if t.count > 0 then
133: a16 := JTF_NUMBER_TABLE();
134: a17 := JTF_VARCHAR2_TABLE_100();
135: a18 := JTF_VARCHAR2_TABLE_100();
136: a19 := JTF_NUMBER_TABLE();
137: a20 := JTF_NUMBER_TABLE();
138: a21 := JTF_NUMBER_TABLE();
139: a22 := JTF_VARCHAR2_TABLE_100();
140: if t.count > 0 then
141: a0.extend(t.count);
134: a17 := JTF_VARCHAR2_TABLE_100();
135: a18 := JTF_VARCHAR2_TABLE_100();
136: a19 := JTF_NUMBER_TABLE();
137: a20 := JTF_NUMBER_TABLE();
138: a21 := JTF_NUMBER_TABLE();
139: a22 := JTF_VARCHAR2_TABLE_100();
140: if t.count > 0 then
141: a0.extend(t.count);
142: a1.extend(t.count);
196: end if;
197: end if;
198: end rosetta_table_copy_out_p2;
199:
200: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
201: , a1 JTF_NUMBER_TABLE
202: , a2 JTF_NUMBER_TABLE
203: , a3 JTF_NUMBER_TABLE
204: , a4 JTF_VARCHAR2_TABLE_100
197: end if;
198: end rosetta_table_copy_out_p2;
199:
200: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
201: , a1 JTF_NUMBER_TABLE
202: , a2 JTF_NUMBER_TABLE
203: , a3 JTF_NUMBER_TABLE
204: , a4 JTF_VARCHAR2_TABLE_100
205: , a5 JTF_VARCHAR2_TABLE_100
198: end rosetta_table_copy_out_p2;
199:
200: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
201: , a1 JTF_NUMBER_TABLE
202: , a2 JTF_NUMBER_TABLE
203: , a3 JTF_NUMBER_TABLE
204: , a4 JTF_VARCHAR2_TABLE_100
205: , a5 JTF_VARCHAR2_TABLE_100
206: , a6 JTF_VARCHAR2_TABLE_100
199:
200: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
201: , a1 JTF_NUMBER_TABLE
202: , a2 JTF_NUMBER_TABLE
203: , a3 JTF_NUMBER_TABLE
204: , a4 JTF_VARCHAR2_TABLE_100
205: , a5 JTF_VARCHAR2_TABLE_100
206: , a6 JTF_VARCHAR2_TABLE_100
207: , a7 JTF_NUMBER_TABLE
203: , a3 JTF_NUMBER_TABLE
204: , a4 JTF_VARCHAR2_TABLE_100
205: , a5 JTF_VARCHAR2_TABLE_100
206: , a6 JTF_VARCHAR2_TABLE_100
207: , a7 JTF_NUMBER_TABLE
208: , a8 JTF_VARCHAR2_TABLE_100
209: , a9 JTF_VARCHAR2_TABLE_100
210: , a10 JTF_VARCHAR2_TABLE_100
211: , a11 JTF_VARCHAR2_TABLE_100
208: , a8 JTF_VARCHAR2_TABLE_100
209: , a9 JTF_VARCHAR2_TABLE_100
210: , a10 JTF_VARCHAR2_TABLE_100
211: , a11 JTF_VARCHAR2_TABLE_100
212: , a12 JTF_NUMBER_TABLE
213: , a13 JTF_VARCHAR2_TABLE_100
214: , a14 JTF_NUMBER_TABLE
215: , a15 JTF_NUMBER_TABLE
216: , a16 JTF_NUMBER_TABLE
210: , a10 JTF_VARCHAR2_TABLE_100
211: , a11 JTF_VARCHAR2_TABLE_100
212: , a12 JTF_NUMBER_TABLE
213: , a13 JTF_VARCHAR2_TABLE_100
214: , a14 JTF_NUMBER_TABLE
215: , a15 JTF_NUMBER_TABLE
216: , a16 JTF_NUMBER_TABLE
217: , a17 JTF_NUMBER_TABLE
218: , a18 JTF_VARCHAR2_TABLE_100
211: , a11 JTF_VARCHAR2_TABLE_100
212: , a12 JTF_NUMBER_TABLE
213: , a13 JTF_VARCHAR2_TABLE_100
214: , a14 JTF_NUMBER_TABLE
215: , a15 JTF_NUMBER_TABLE
216: , a16 JTF_NUMBER_TABLE
217: , a17 JTF_NUMBER_TABLE
218: , a18 JTF_VARCHAR2_TABLE_100
219: , a19 JTF_DATE_TABLE
212: , a12 JTF_NUMBER_TABLE
213: , a13 JTF_VARCHAR2_TABLE_100
214: , a14 JTF_NUMBER_TABLE
215: , a15 JTF_NUMBER_TABLE
216: , a16 JTF_NUMBER_TABLE
217: , a17 JTF_NUMBER_TABLE
218: , a18 JTF_VARCHAR2_TABLE_100
219: , a19 JTF_DATE_TABLE
220: , a20 JTF_DATE_TABLE
213: , a13 JTF_VARCHAR2_TABLE_100
214: , a14 JTF_NUMBER_TABLE
215: , a15 JTF_NUMBER_TABLE
216: , a16 JTF_NUMBER_TABLE
217: , a17 JTF_NUMBER_TABLE
218: , a18 JTF_VARCHAR2_TABLE_100
219: , a19 JTF_DATE_TABLE
220: , a20 JTF_DATE_TABLE
221: , a21 JTF_VARCHAR2_TABLE_100
219: , a19 JTF_DATE_TABLE
220: , a20 JTF_DATE_TABLE
221: , a21 JTF_VARCHAR2_TABLE_100
222: , a22 JTF_DATE_TABLE
223: , a23 JTF_NUMBER_TABLE
224: , a24 JTF_DATE_TABLE
225: , a25 JTF_NUMBER_TABLE
226: , a26 JTF_NUMBER_TABLE
227: , a27 JTF_NUMBER_TABLE
221: , a21 JTF_VARCHAR2_TABLE_100
222: , a22 JTF_DATE_TABLE
223: , a23 JTF_NUMBER_TABLE
224: , a24 JTF_DATE_TABLE
225: , a25 JTF_NUMBER_TABLE
226: , a26 JTF_NUMBER_TABLE
227: , a27 JTF_NUMBER_TABLE
228: , a28 JTF_NUMBER_TABLE
229: , a29 JTF_NUMBER_TABLE
222: , a22 JTF_DATE_TABLE
223: , a23 JTF_NUMBER_TABLE
224: , a24 JTF_DATE_TABLE
225: , a25 JTF_NUMBER_TABLE
226: , a26 JTF_NUMBER_TABLE
227: , a27 JTF_NUMBER_TABLE
228: , a28 JTF_NUMBER_TABLE
229: , a29 JTF_NUMBER_TABLE
230: , a30 JTF_NUMBER_TABLE
223: , a23 JTF_NUMBER_TABLE
224: , a24 JTF_DATE_TABLE
225: , a25 JTF_NUMBER_TABLE
226: , a26 JTF_NUMBER_TABLE
227: , a27 JTF_NUMBER_TABLE
228: , a28 JTF_NUMBER_TABLE
229: , a29 JTF_NUMBER_TABLE
230: , a30 JTF_NUMBER_TABLE
231: , a31 JTF_VARCHAR2_TABLE_100
224: , a24 JTF_DATE_TABLE
225: , a25 JTF_NUMBER_TABLE
226: , a26 JTF_NUMBER_TABLE
227: , a27 JTF_NUMBER_TABLE
228: , a28 JTF_NUMBER_TABLE
229: , a29 JTF_NUMBER_TABLE
230: , a30 JTF_NUMBER_TABLE
231: , a31 JTF_VARCHAR2_TABLE_100
232: , a32 JTF_NUMBER_TABLE
225: , a25 JTF_NUMBER_TABLE
226: , a26 JTF_NUMBER_TABLE
227: , a27 JTF_NUMBER_TABLE
228: , a28 JTF_NUMBER_TABLE
229: , a29 JTF_NUMBER_TABLE
230: , a30 JTF_NUMBER_TABLE
231: , a31 JTF_VARCHAR2_TABLE_100
232: , a32 JTF_NUMBER_TABLE
233: , a33 JTF_VARCHAR2_TABLE_100
226: , a26 JTF_NUMBER_TABLE
227: , a27 JTF_NUMBER_TABLE
228: , a28 JTF_NUMBER_TABLE
229: , a29 JTF_NUMBER_TABLE
230: , a30 JTF_NUMBER_TABLE
231: , a31 JTF_VARCHAR2_TABLE_100
232: , a32 JTF_NUMBER_TABLE
233: , a33 JTF_VARCHAR2_TABLE_100
234: , a34 JTF_VARCHAR2_TABLE_100
228: , a28 JTF_NUMBER_TABLE
229: , a29 JTF_NUMBER_TABLE
230: , a30 JTF_NUMBER_TABLE
231: , a31 JTF_VARCHAR2_TABLE_100
232: , a32 JTF_NUMBER_TABLE
233: , a33 JTF_VARCHAR2_TABLE_100
234: , a34 JTF_VARCHAR2_TABLE_100
235: ) as
236: ddindx binary_integer; indx binary_integer;
283: end loop;
284: end if;
285: end if;
286: end rosetta_table_copy_in_p4;
287: procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
288: , a1 out nocopy JTF_NUMBER_TABLE
289: , a2 out nocopy JTF_NUMBER_TABLE
290: , a3 out nocopy JTF_NUMBER_TABLE
291: , a4 out nocopy JTF_VARCHAR2_TABLE_100
284: end if;
285: end if;
286: end rosetta_table_copy_in_p4;
287: procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
288: , a1 out nocopy JTF_NUMBER_TABLE
289: , a2 out nocopy JTF_NUMBER_TABLE
290: , a3 out nocopy JTF_NUMBER_TABLE
291: , a4 out nocopy JTF_VARCHAR2_TABLE_100
292: , a5 out nocopy JTF_VARCHAR2_TABLE_100
285: end if;
286: end rosetta_table_copy_in_p4;
287: procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
288: , a1 out nocopy JTF_NUMBER_TABLE
289: , a2 out nocopy JTF_NUMBER_TABLE
290: , a3 out nocopy JTF_NUMBER_TABLE
291: , a4 out nocopy JTF_VARCHAR2_TABLE_100
292: , a5 out nocopy JTF_VARCHAR2_TABLE_100
293: , a6 out nocopy JTF_VARCHAR2_TABLE_100
286: end rosetta_table_copy_in_p4;
287: procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
288: , a1 out nocopy JTF_NUMBER_TABLE
289: , a2 out nocopy JTF_NUMBER_TABLE
290: , a3 out nocopy JTF_NUMBER_TABLE
291: , a4 out nocopy JTF_VARCHAR2_TABLE_100
292: , a5 out nocopy JTF_VARCHAR2_TABLE_100
293: , a6 out nocopy JTF_VARCHAR2_TABLE_100
294: , a7 out nocopy JTF_NUMBER_TABLE
290: , a3 out nocopy JTF_NUMBER_TABLE
291: , a4 out nocopy JTF_VARCHAR2_TABLE_100
292: , a5 out nocopy JTF_VARCHAR2_TABLE_100
293: , a6 out nocopy JTF_VARCHAR2_TABLE_100
294: , a7 out nocopy JTF_NUMBER_TABLE
295: , a8 out nocopy JTF_VARCHAR2_TABLE_100
296: , a9 out nocopy JTF_VARCHAR2_TABLE_100
297: , a10 out nocopy JTF_VARCHAR2_TABLE_100
298: , a11 out nocopy JTF_VARCHAR2_TABLE_100
295: , a8 out nocopy JTF_VARCHAR2_TABLE_100
296: , a9 out nocopy JTF_VARCHAR2_TABLE_100
297: , a10 out nocopy JTF_VARCHAR2_TABLE_100
298: , a11 out nocopy JTF_VARCHAR2_TABLE_100
299: , a12 out nocopy JTF_NUMBER_TABLE
300: , a13 out nocopy JTF_VARCHAR2_TABLE_100
301: , a14 out nocopy JTF_NUMBER_TABLE
302: , a15 out nocopy JTF_NUMBER_TABLE
303: , a16 out nocopy JTF_NUMBER_TABLE
297: , a10 out nocopy JTF_VARCHAR2_TABLE_100
298: , a11 out nocopy JTF_VARCHAR2_TABLE_100
299: , a12 out nocopy JTF_NUMBER_TABLE
300: , a13 out nocopy JTF_VARCHAR2_TABLE_100
301: , a14 out nocopy JTF_NUMBER_TABLE
302: , a15 out nocopy JTF_NUMBER_TABLE
303: , a16 out nocopy JTF_NUMBER_TABLE
304: , a17 out nocopy JTF_NUMBER_TABLE
305: , a18 out nocopy JTF_VARCHAR2_TABLE_100
298: , a11 out nocopy JTF_VARCHAR2_TABLE_100
299: , a12 out nocopy JTF_NUMBER_TABLE
300: , a13 out nocopy JTF_VARCHAR2_TABLE_100
301: , a14 out nocopy JTF_NUMBER_TABLE
302: , a15 out nocopy JTF_NUMBER_TABLE
303: , a16 out nocopy JTF_NUMBER_TABLE
304: , a17 out nocopy JTF_NUMBER_TABLE
305: , a18 out nocopy JTF_VARCHAR2_TABLE_100
306: , a19 out nocopy JTF_DATE_TABLE
299: , a12 out nocopy JTF_NUMBER_TABLE
300: , a13 out nocopy JTF_VARCHAR2_TABLE_100
301: , a14 out nocopy JTF_NUMBER_TABLE
302: , a15 out nocopy JTF_NUMBER_TABLE
303: , a16 out nocopy JTF_NUMBER_TABLE
304: , a17 out nocopy JTF_NUMBER_TABLE
305: , a18 out nocopy JTF_VARCHAR2_TABLE_100
306: , a19 out nocopy JTF_DATE_TABLE
307: , a20 out nocopy JTF_DATE_TABLE
300: , a13 out nocopy JTF_VARCHAR2_TABLE_100
301: , a14 out nocopy JTF_NUMBER_TABLE
302: , a15 out nocopy JTF_NUMBER_TABLE
303: , a16 out nocopy JTF_NUMBER_TABLE
304: , a17 out nocopy JTF_NUMBER_TABLE
305: , a18 out nocopy JTF_VARCHAR2_TABLE_100
306: , a19 out nocopy JTF_DATE_TABLE
307: , a20 out nocopy JTF_DATE_TABLE
308: , a21 out nocopy JTF_VARCHAR2_TABLE_100
306: , a19 out nocopy JTF_DATE_TABLE
307: , a20 out nocopy JTF_DATE_TABLE
308: , a21 out nocopy JTF_VARCHAR2_TABLE_100
309: , a22 out nocopy JTF_DATE_TABLE
310: , a23 out nocopy JTF_NUMBER_TABLE
311: , a24 out nocopy JTF_DATE_TABLE
312: , a25 out nocopy JTF_NUMBER_TABLE
313: , a26 out nocopy JTF_NUMBER_TABLE
314: , a27 out nocopy JTF_NUMBER_TABLE
308: , a21 out nocopy JTF_VARCHAR2_TABLE_100
309: , a22 out nocopy JTF_DATE_TABLE
310: , a23 out nocopy JTF_NUMBER_TABLE
311: , a24 out nocopy JTF_DATE_TABLE
312: , a25 out nocopy JTF_NUMBER_TABLE
313: , a26 out nocopy JTF_NUMBER_TABLE
314: , a27 out nocopy JTF_NUMBER_TABLE
315: , a28 out nocopy JTF_NUMBER_TABLE
316: , a29 out nocopy JTF_NUMBER_TABLE
309: , a22 out nocopy JTF_DATE_TABLE
310: , a23 out nocopy JTF_NUMBER_TABLE
311: , a24 out nocopy JTF_DATE_TABLE
312: , a25 out nocopy JTF_NUMBER_TABLE
313: , a26 out nocopy JTF_NUMBER_TABLE
314: , a27 out nocopy JTF_NUMBER_TABLE
315: , a28 out nocopy JTF_NUMBER_TABLE
316: , a29 out nocopy JTF_NUMBER_TABLE
317: , a30 out nocopy JTF_NUMBER_TABLE
310: , a23 out nocopy JTF_NUMBER_TABLE
311: , a24 out nocopy JTF_DATE_TABLE
312: , a25 out nocopy JTF_NUMBER_TABLE
313: , a26 out nocopy JTF_NUMBER_TABLE
314: , a27 out nocopy JTF_NUMBER_TABLE
315: , a28 out nocopy JTF_NUMBER_TABLE
316: , a29 out nocopy JTF_NUMBER_TABLE
317: , a30 out nocopy JTF_NUMBER_TABLE
318: , a31 out nocopy JTF_VARCHAR2_TABLE_100
311: , a24 out nocopy JTF_DATE_TABLE
312: , a25 out nocopy JTF_NUMBER_TABLE
313: , a26 out nocopy JTF_NUMBER_TABLE
314: , a27 out nocopy JTF_NUMBER_TABLE
315: , a28 out nocopy JTF_NUMBER_TABLE
316: , a29 out nocopy JTF_NUMBER_TABLE
317: , a30 out nocopy JTF_NUMBER_TABLE
318: , a31 out nocopy JTF_VARCHAR2_TABLE_100
319: , a32 out nocopy JTF_NUMBER_TABLE
312: , a25 out nocopy JTF_NUMBER_TABLE
313: , a26 out nocopy JTF_NUMBER_TABLE
314: , a27 out nocopy JTF_NUMBER_TABLE
315: , a28 out nocopy JTF_NUMBER_TABLE
316: , a29 out nocopy JTF_NUMBER_TABLE
317: , a30 out nocopy JTF_NUMBER_TABLE
318: , a31 out nocopy JTF_VARCHAR2_TABLE_100
319: , a32 out nocopy JTF_NUMBER_TABLE
320: , a33 out nocopy JTF_VARCHAR2_TABLE_100
313: , a26 out nocopy JTF_NUMBER_TABLE
314: , a27 out nocopy JTF_NUMBER_TABLE
315: , a28 out nocopy JTF_NUMBER_TABLE
316: , a29 out nocopy JTF_NUMBER_TABLE
317: , a30 out nocopy JTF_NUMBER_TABLE
318: , a31 out nocopy JTF_VARCHAR2_TABLE_100
319: , a32 out nocopy JTF_NUMBER_TABLE
320: , a33 out nocopy JTF_VARCHAR2_TABLE_100
321: , a34 out nocopy JTF_VARCHAR2_TABLE_100
315: , a28 out nocopy JTF_NUMBER_TABLE
316: , a29 out nocopy JTF_NUMBER_TABLE
317: , a30 out nocopy JTF_NUMBER_TABLE
318: , a31 out nocopy JTF_VARCHAR2_TABLE_100
319: , a32 out nocopy JTF_NUMBER_TABLE
320: , a33 out nocopy JTF_VARCHAR2_TABLE_100
321: , a34 out nocopy JTF_VARCHAR2_TABLE_100
322: ) as
323: ddindx binary_integer; indx binary_integer;
322: ) as
323: ddindx binary_integer; indx binary_integer;
324: begin
325: if t is null or t.count = 0 then
326: a0 := JTF_NUMBER_TABLE();
327: a1 := JTF_NUMBER_TABLE();
328: a2 := JTF_NUMBER_TABLE();
329: a3 := JTF_NUMBER_TABLE();
330: a4 := JTF_VARCHAR2_TABLE_100();
323: ddindx binary_integer; indx binary_integer;
324: begin
325: if t is null or t.count = 0 then
326: a0 := JTF_NUMBER_TABLE();
327: a1 := JTF_NUMBER_TABLE();
328: a2 := JTF_NUMBER_TABLE();
329: a3 := JTF_NUMBER_TABLE();
330: a4 := JTF_VARCHAR2_TABLE_100();
331: a5 := JTF_VARCHAR2_TABLE_100();
324: begin
325: if t is null or t.count = 0 then
326: a0 := JTF_NUMBER_TABLE();
327: a1 := JTF_NUMBER_TABLE();
328: a2 := JTF_NUMBER_TABLE();
329: a3 := JTF_NUMBER_TABLE();
330: a4 := JTF_VARCHAR2_TABLE_100();
331: a5 := JTF_VARCHAR2_TABLE_100();
332: a6 := JTF_VARCHAR2_TABLE_100();
325: if t is null or t.count = 0 then
326: a0 := JTF_NUMBER_TABLE();
327: a1 := JTF_NUMBER_TABLE();
328: a2 := JTF_NUMBER_TABLE();
329: a3 := JTF_NUMBER_TABLE();
330: a4 := JTF_VARCHAR2_TABLE_100();
331: a5 := JTF_VARCHAR2_TABLE_100();
332: a6 := JTF_VARCHAR2_TABLE_100();
333: a7 := JTF_NUMBER_TABLE();
329: a3 := JTF_NUMBER_TABLE();
330: a4 := JTF_VARCHAR2_TABLE_100();
331: a5 := JTF_VARCHAR2_TABLE_100();
332: a6 := JTF_VARCHAR2_TABLE_100();
333: a7 := JTF_NUMBER_TABLE();
334: a8 := JTF_VARCHAR2_TABLE_100();
335: a9 := JTF_VARCHAR2_TABLE_100();
336: a10 := JTF_VARCHAR2_TABLE_100();
337: a11 := JTF_VARCHAR2_TABLE_100();
334: a8 := JTF_VARCHAR2_TABLE_100();
335: a9 := JTF_VARCHAR2_TABLE_100();
336: a10 := JTF_VARCHAR2_TABLE_100();
337: a11 := JTF_VARCHAR2_TABLE_100();
338: a12 := JTF_NUMBER_TABLE();
339: a13 := JTF_VARCHAR2_TABLE_100();
340: a14 := JTF_NUMBER_TABLE();
341: a15 := JTF_NUMBER_TABLE();
342: a16 := JTF_NUMBER_TABLE();
336: a10 := JTF_VARCHAR2_TABLE_100();
337: a11 := JTF_VARCHAR2_TABLE_100();
338: a12 := JTF_NUMBER_TABLE();
339: a13 := JTF_VARCHAR2_TABLE_100();
340: a14 := JTF_NUMBER_TABLE();
341: a15 := JTF_NUMBER_TABLE();
342: a16 := JTF_NUMBER_TABLE();
343: a17 := JTF_NUMBER_TABLE();
344: a18 := JTF_VARCHAR2_TABLE_100();
337: a11 := JTF_VARCHAR2_TABLE_100();
338: a12 := JTF_NUMBER_TABLE();
339: a13 := JTF_VARCHAR2_TABLE_100();
340: a14 := JTF_NUMBER_TABLE();
341: a15 := JTF_NUMBER_TABLE();
342: a16 := JTF_NUMBER_TABLE();
343: a17 := JTF_NUMBER_TABLE();
344: a18 := JTF_VARCHAR2_TABLE_100();
345: a19 := JTF_DATE_TABLE();
338: a12 := JTF_NUMBER_TABLE();
339: a13 := JTF_VARCHAR2_TABLE_100();
340: a14 := JTF_NUMBER_TABLE();
341: a15 := JTF_NUMBER_TABLE();
342: a16 := JTF_NUMBER_TABLE();
343: a17 := JTF_NUMBER_TABLE();
344: a18 := JTF_VARCHAR2_TABLE_100();
345: a19 := JTF_DATE_TABLE();
346: a20 := JTF_DATE_TABLE();
339: a13 := JTF_VARCHAR2_TABLE_100();
340: a14 := JTF_NUMBER_TABLE();
341: a15 := JTF_NUMBER_TABLE();
342: a16 := JTF_NUMBER_TABLE();
343: a17 := JTF_NUMBER_TABLE();
344: a18 := JTF_VARCHAR2_TABLE_100();
345: a19 := JTF_DATE_TABLE();
346: a20 := JTF_DATE_TABLE();
347: a21 := JTF_VARCHAR2_TABLE_100();
345: a19 := JTF_DATE_TABLE();
346: a20 := JTF_DATE_TABLE();
347: a21 := JTF_VARCHAR2_TABLE_100();
348: a22 := JTF_DATE_TABLE();
349: a23 := JTF_NUMBER_TABLE();
350: a24 := JTF_DATE_TABLE();
351: a25 := JTF_NUMBER_TABLE();
352: a26 := JTF_NUMBER_TABLE();
353: a27 := JTF_NUMBER_TABLE();
347: a21 := JTF_VARCHAR2_TABLE_100();
348: a22 := JTF_DATE_TABLE();
349: a23 := JTF_NUMBER_TABLE();
350: a24 := JTF_DATE_TABLE();
351: a25 := JTF_NUMBER_TABLE();
352: a26 := JTF_NUMBER_TABLE();
353: a27 := JTF_NUMBER_TABLE();
354: a28 := JTF_NUMBER_TABLE();
355: a29 := JTF_NUMBER_TABLE();
348: a22 := JTF_DATE_TABLE();
349: a23 := JTF_NUMBER_TABLE();
350: a24 := JTF_DATE_TABLE();
351: a25 := JTF_NUMBER_TABLE();
352: a26 := JTF_NUMBER_TABLE();
353: a27 := JTF_NUMBER_TABLE();
354: a28 := JTF_NUMBER_TABLE();
355: a29 := JTF_NUMBER_TABLE();
356: a30 := JTF_NUMBER_TABLE();
349: a23 := JTF_NUMBER_TABLE();
350: a24 := JTF_DATE_TABLE();
351: a25 := JTF_NUMBER_TABLE();
352: a26 := JTF_NUMBER_TABLE();
353: a27 := JTF_NUMBER_TABLE();
354: a28 := JTF_NUMBER_TABLE();
355: a29 := JTF_NUMBER_TABLE();
356: a30 := JTF_NUMBER_TABLE();
357: a31 := JTF_VARCHAR2_TABLE_100();
350: a24 := JTF_DATE_TABLE();
351: a25 := JTF_NUMBER_TABLE();
352: a26 := JTF_NUMBER_TABLE();
353: a27 := JTF_NUMBER_TABLE();
354: a28 := JTF_NUMBER_TABLE();
355: a29 := JTF_NUMBER_TABLE();
356: a30 := JTF_NUMBER_TABLE();
357: a31 := JTF_VARCHAR2_TABLE_100();
358: a32 := JTF_NUMBER_TABLE();
351: a25 := JTF_NUMBER_TABLE();
352: a26 := JTF_NUMBER_TABLE();
353: a27 := JTF_NUMBER_TABLE();
354: a28 := JTF_NUMBER_TABLE();
355: a29 := JTF_NUMBER_TABLE();
356: a30 := JTF_NUMBER_TABLE();
357: a31 := JTF_VARCHAR2_TABLE_100();
358: a32 := JTF_NUMBER_TABLE();
359: a33 := JTF_VARCHAR2_TABLE_100();
352: a26 := JTF_NUMBER_TABLE();
353: a27 := JTF_NUMBER_TABLE();
354: a28 := JTF_NUMBER_TABLE();
355: a29 := JTF_NUMBER_TABLE();
356: a30 := JTF_NUMBER_TABLE();
357: a31 := JTF_VARCHAR2_TABLE_100();
358: a32 := JTF_NUMBER_TABLE();
359: a33 := JTF_VARCHAR2_TABLE_100();
360: a34 := JTF_VARCHAR2_TABLE_100();
354: a28 := JTF_NUMBER_TABLE();
355: a29 := JTF_NUMBER_TABLE();
356: a30 := JTF_NUMBER_TABLE();
357: a31 := JTF_VARCHAR2_TABLE_100();
358: a32 := JTF_NUMBER_TABLE();
359: a33 := JTF_VARCHAR2_TABLE_100();
360: a34 := JTF_VARCHAR2_TABLE_100();
361: else
362: a0 := JTF_NUMBER_TABLE();
358: a32 := JTF_NUMBER_TABLE();
359: a33 := JTF_VARCHAR2_TABLE_100();
360: a34 := JTF_VARCHAR2_TABLE_100();
361: else
362: a0 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_NUMBER_TABLE();
366: a4 := JTF_VARCHAR2_TABLE_100();
359: a33 := JTF_VARCHAR2_TABLE_100();
360: a34 := JTF_VARCHAR2_TABLE_100();
361: else
362: a0 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_NUMBER_TABLE();
366: a4 := JTF_VARCHAR2_TABLE_100();
367: a5 := JTF_VARCHAR2_TABLE_100();
360: a34 := JTF_VARCHAR2_TABLE_100();
361: else
362: a0 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_NUMBER_TABLE();
366: a4 := JTF_VARCHAR2_TABLE_100();
367: a5 := JTF_VARCHAR2_TABLE_100();
368: a6 := JTF_VARCHAR2_TABLE_100();
361: else
362: a0 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_NUMBER_TABLE();
366: a4 := JTF_VARCHAR2_TABLE_100();
367: a5 := JTF_VARCHAR2_TABLE_100();
368: a6 := JTF_VARCHAR2_TABLE_100();
369: a7 := JTF_NUMBER_TABLE();
365: a3 := JTF_NUMBER_TABLE();
366: a4 := JTF_VARCHAR2_TABLE_100();
367: a5 := JTF_VARCHAR2_TABLE_100();
368: a6 := JTF_VARCHAR2_TABLE_100();
369: a7 := JTF_NUMBER_TABLE();
370: a8 := JTF_VARCHAR2_TABLE_100();
371: a9 := JTF_VARCHAR2_TABLE_100();
372: a10 := JTF_VARCHAR2_TABLE_100();
373: a11 := JTF_VARCHAR2_TABLE_100();
370: a8 := JTF_VARCHAR2_TABLE_100();
371: a9 := JTF_VARCHAR2_TABLE_100();
372: a10 := JTF_VARCHAR2_TABLE_100();
373: a11 := JTF_VARCHAR2_TABLE_100();
374: a12 := JTF_NUMBER_TABLE();
375: a13 := JTF_VARCHAR2_TABLE_100();
376: a14 := JTF_NUMBER_TABLE();
377: a15 := JTF_NUMBER_TABLE();
378: a16 := JTF_NUMBER_TABLE();
372: a10 := JTF_VARCHAR2_TABLE_100();
373: a11 := JTF_VARCHAR2_TABLE_100();
374: a12 := JTF_NUMBER_TABLE();
375: a13 := JTF_VARCHAR2_TABLE_100();
376: a14 := JTF_NUMBER_TABLE();
377: a15 := JTF_NUMBER_TABLE();
378: a16 := JTF_NUMBER_TABLE();
379: a17 := JTF_NUMBER_TABLE();
380: a18 := JTF_VARCHAR2_TABLE_100();
373: a11 := JTF_VARCHAR2_TABLE_100();
374: a12 := JTF_NUMBER_TABLE();
375: a13 := JTF_VARCHAR2_TABLE_100();
376: a14 := JTF_NUMBER_TABLE();
377: a15 := JTF_NUMBER_TABLE();
378: a16 := JTF_NUMBER_TABLE();
379: a17 := JTF_NUMBER_TABLE();
380: a18 := JTF_VARCHAR2_TABLE_100();
381: a19 := JTF_DATE_TABLE();
374: a12 := JTF_NUMBER_TABLE();
375: a13 := JTF_VARCHAR2_TABLE_100();
376: a14 := JTF_NUMBER_TABLE();
377: a15 := JTF_NUMBER_TABLE();
378: a16 := JTF_NUMBER_TABLE();
379: a17 := JTF_NUMBER_TABLE();
380: a18 := JTF_VARCHAR2_TABLE_100();
381: a19 := JTF_DATE_TABLE();
382: a20 := JTF_DATE_TABLE();
375: a13 := JTF_VARCHAR2_TABLE_100();
376: a14 := JTF_NUMBER_TABLE();
377: a15 := JTF_NUMBER_TABLE();
378: a16 := JTF_NUMBER_TABLE();
379: a17 := JTF_NUMBER_TABLE();
380: a18 := JTF_VARCHAR2_TABLE_100();
381: a19 := JTF_DATE_TABLE();
382: a20 := JTF_DATE_TABLE();
383: a21 := JTF_VARCHAR2_TABLE_100();
381: a19 := JTF_DATE_TABLE();
382: a20 := JTF_DATE_TABLE();
383: a21 := JTF_VARCHAR2_TABLE_100();
384: a22 := JTF_DATE_TABLE();
385: a23 := JTF_NUMBER_TABLE();
386: a24 := JTF_DATE_TABLE();
387: a25 := JTF_NUMBER_TABLE();
388: a26 := JTF_NUMBER_TABLE();
389: a27 := JTF_NUMBER_TABLE();
383: a21 := JTF_VARCHAR2_TABLE_100();
384: a22 := JTF_DATE_TABLE();
385: a23 := JTF_NUMBER_TABLE();
386: a24 := JTF_DATE_TABLE();
387: a25 := JTF_NUMBER_TABLE();
388: a26 := JTF_NUMBER_TABLE();
389: a27 := JTF_NUMBER_TABLE();
390: a28 := JTF_NUMBER_TABLE();
391: a29 := JTF_NUMBER_TABLE();
384: a22 := JTF_DATE_TABLE();
385: a23 := JTF_NUMBER_TABLE();
386: a24 := JTF_DATE_TABLE();
387: a25 := JTF_NUMBER_TABLE();
388: a26 := JTF_NUMBER_TABLE();
389: a27 := JTF_NUMBER_TABLE();
390: a28 := JTF_NUMBER_TABLE();
391: a29 := JTF_NUMBER_TABLE();
392: a30 := JTF_NUMBER_TABLE();
385: a23 := JTF_NUMBER_TABLE();
386: a24 := JTF_DATE_TABLE();
387: a25 := JTF_NUMBER_TABLE();
388: a26 := JTF_NUMBER_TABLE();
389: a27 := JTF_NUMBER_TABLE();
390: a28 := JTF_NUMBER_TABLE();
391: a29 := JTF_NUMBER_TABLE();
392: a30 := JTF_NUMBER_TABLE();
393: a31 := JTF_VARCHAR2_TABLE_100();
386: a24 := JTF_DATE_TABLE();
387: a25 := JTF_NUMBER_TABLE();
388: a26 := JTF_NUMBER_TABLE();
389: a27 := JTF_NUMBER_TABLE();
390: a28 := JTF_NUMBER_TABLE();
391: a29 := JTF_NUMBER_TABLE();
392: a30 := JTF_NUMBER_TABLE();
393: a31 := JTF_VARCHAR2_TABLE_100();
394: a32 := JTF_NUMBER_TABLE();
387: a25 := JTF_NUMBER_TABLE();
388: a26 := JTF_NUMBER_TABLE();
389: a27 := JTF_NUMBER_TABLE();
390: a28 := JTF_NUMBER_TABLE();
391: a29 := JTF_NUMBER_TABLE();
392: a30 := JTF_NUMBER_TABLE();
393: a31 := JTF_VARCHAR2_TABLE_100();
394: a32 := JTF_NUMBER_TABLE();
395: a33 := JTF_VARCHAR2_TABLE_100();
388: a26 := JTF_NUMBER_TABLE();
389: a27 := JTF_NUMBER_TABLE();
390: a28 := JTF_NUMBER_TABLE();
391: a29 := JTF_NUMBER_TABLE();
392: a30 := JTF_NUMBER_TABLE();
393: a31 := JTF_VARCHAR2_TABLE_100();
394: a32 := JTF_NUMBER_TABLE();
395: a33 := JTF_VARCHAR2_TABLE_100();
396: a34 := JTF_VARCHAR2_TABLE_100();
390: a28 := JTF_NUMBER_TABLE();
391: a29 := JTF_NUMBER_TABLE();
392: a30 := JTF_NUMBER_TABLE();
393: a31 := JTF_VARCHAR2_TABLE_100();
394: a32 := JTF_NUMBER_TABLE();
395: a33 := JTF_VARCHAR2_TABLE_100();
396: a34 := JTF_VARCHAR2_TABLE_100();
397: if t.count > 0 then
398: a0.extend(t.count);
477: end if;
478: end if;
479: end rosetta_table_copy_out_p4;
480:
481: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pub.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
482: , a1 JTF_NUMBER_TABLE
483: , a2 JTF_VARCHAR2_TABLE_100
484: , a3 JTF_NUMBER_TABLE
485: , a4 JTF_VARCHAR2_TABLE_100
478: end if;
479: end rosetta_table_copy_out_p4;
480:
481: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pub.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
482: , a1 JTF_NUMBER_TABLE
483: , a2 JTF_VARCHAR2_TABLE_100
484: , a3 JTF_NUMBER_TABLE
485: , a4 JTF_VARCHAR2_TABLE_100
486: , a5 JTF_VARCHAR2_TABLE_100
480:
481: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pub.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
482: , a1 JTF_NUMBER_TABLE
483: , a2 JTF_VARCHAR2_TABLE_100
484: , a3 JTF_NUMBER_TABLE
485: , a4 JTF_VARCHAR2_TABLE_100
486: , a5 JTF_VARCHAR2_TABLE_100
487: , a6 JTF_DATE_TABLE
488: , a7 JTF_DATE_TABLE
485: , a4 JTF_VARCHAR2_TABLE_100
486: , a5 JTF_VARCHAR2_TABLE_100
487: , a6 JTF_DATE_TABLE
488: , a7 JTF_DATE_TABLE
489: , a8 JTF_NUMBER_TABLE
490: , a9 JTF_NUMBER_TABLE
491: , a10 JTF_DATE_TABLE
492: , a11 JTF_NUMBER_TABLE
493: , a12 JTF_DATE_TABLE
486: , a5 JTF_VARCHAR2_TABLE_100
487: , a6 JTF_DATE_TABLE
488: , a7 JTF_DATE_TABLE
489: , a8 JTF_NUMBER_TABLE
490: , a9 JTF_NUMBER_TABLE
491: , a10 JTF_DATE_TABLE
492: , a11 JTF_NUMBER_TABLE
493: , a12 JTF_DATE_TABLE
494: , a13 JTF_NUMBER_TABLE
488: , a7 JTF_DATE_TABLE
489: , a8 JTF_NUMBER_TABLE
490: , a9 JTF_NUMBER_TABLE
491: , a10 JTF_DATE_TABLE
492: , a11 JTF_NUMBER_TABLE
493: , a12 JTF_DATE_TABLE
494: , a13 JTF_NUMBER_TABLE
495: , a14 JTF_NUMBER_TABLE
496: , a15 JTF_NUMBER_TABLE
490: , a9 JTF_NUMBER_TABLE
491: , a10 JTF_DATE_TABLE
492: , a11 JTF_NUMBER_TABLE
493: , a12 JTF_DATE_TABLE
494: , a13 JTF_NUMBER_TABLE
495: , a14 JTF_NUMBER_TABLE
496: , a15 JTF_NUMBER_TABLE
497: , a16 JTF_VARCHAR2_TABLE_100
498: ) as
491: , a10 JTF_DATE_TABLE
492: , a11 JTF_NUMBER_TABLE
493: , a12 JTF_DATE_TABLE
494: , a13 JTF_NUMBER_TABLE
495: , a14 JTF_NUMBER_TABLE
496: , a15 JTF_NUMBER_TABLE
497: , a16 JTF_VARCHAR2_TABLE_100
498: ) as
499: ddindx binary_integer; indx binary_integer;
492: , a11 JTF_NUMBER_TABLE
493: , a12 JTF_DATE_TABLE
494: , a13 JTF_NUMBER_TABLE
495: , a14 JTF_NUMBER_TABLE
496: , a15 JTF_NUMBER_TABLE
497: , a16 JTF_VARCHAR2_TABLE_100
498: ) as
499: ddindx binary_integer; indx binary_integer;
500: begin
528: end loop;
529: end if;
530: end if;
531: end rosetta_table_copy_in_p6;
532: procedure rosetta_table_copy_out_p6(t ozf_offer_pub.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
533: , a1 out nocopy JTF_NUMBER_TABLE
534: , a2 out nocopy JTF_VARCHAR2_TABLE_100
535: , a3 out nocopy JTF_NUMBER_TABLE
536: , a4 out nocopy JTF_VARCHAR2_TABLE_100
529: end if;
530: end if;
531: end rosetta_table_copy_in_p6;
532: procedure rosetta_table_copy_out_p6(t ozf_offer_pub.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
533: , a1 out nocopy JTF_NUMBER_TABLE
534: , a2 out nocopy JTF_VARCHAR2_TABLE_100
535: , a3 out nocopy JTF_NUMBER_TABLE
536: , a4 out nocopy JTF_VARCHAR2_TABLE_100
537: , a5 out nocopy JTF_VARCHAR2_TABLE_100
531: end rosetta_table_copy_in_p6;
532: procedure rosetta_table_copy_out_p6(t ozf_offer_pub.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
533: , a1 out nocopy JTF_NUMBER_TABLE
534: , a2 out nocopy JTF_VARCHAR2_TABLE_100
535: , a3 out nocopy JTF_NUMBER_TABLE
536: , a4 out nocopy JTF_VARCHAR2_TABLE_100
537: , a5 out nocopy JTF_VARCHAR2_TABLE_100
538: , a6 out nocopy JTF_DATE_TABLE
539: , a7 out nocopy JTF_DATE_TABLE
536: , a4 out nocopy JTF_VARCHAR2_TABLE_100
537: , a5 out nocopy JTF_VARCHAR2_TABLE_100
538: , a6 out nocopy JTF_DATE_TABLE
539: , a7 out nocopy JTF_DATE_TABLE
540: , a8 out nocopy JTF_NUMBER_TABLE
541: , a9 out nocopy JTF_NUMBER_TABLE
542: , a10 out nocopy JTF_DATE_TABLE
543: , a11 out nocopy JTF_NUMBER_TABLE
544: , a12 out nocopy JTF_DATE_TABLE
537: , a5 out nocopy JTF_VARCHAR2_TABLE_100
538: , a6 out nocopy JTF_DATE_TABLE
539: , a7 out nocopy JTF_DATE_TABLE
540: , a8 out nocopy JTF_NUMBER_TABLE
541: , a9 out nocopy JTF_NUMBER_TABLE
542: , a10 out nocopy JTF_DATE_TABLE
543: , a11 out nocopy JTF_NUMBER_TABLE
544: , a12 out nocopy JTF_DATE_TABLE
545: , a13 out nocopy JTF_NUMBER_TABLE
539: , a7 out nocopy JTF_DATE_TABLE
540: , a8 out nocopy JTF_NUMBER_TABLE
541: , a9 out nocopy JTF_NUMBER_TABLE
542: , a10 out nocopy JTF_DATE_TABLE
543: , a11 out nocopy JTF_NUMBER_TABLE
544: , a12 out nocopy JTF_DATE_TABLE
545: , a13 out nocopy JTF_NUMBER_TABLE
546: , a14 out nocopy JTF_NUMBER_TABLE
547: , a15 out nocopy JTF_NUMBER_TABLE
541: , a9 out nocopy JTF_NUMBER_TABLE
542: , a10 out nocopy JTF_DATE_TABLE
543: , a11 out nocopy JTF_NUMBER_TABLE
544: , a12 out nocopy JTF_DATE_TABLE
545: , a13 out nocopy JTF_NUMBER_TABLE
546: , a14 out nocopy JTF_NUMBER_TABLE
547: , a15 out nocopy JTF_NUMBER_TABLE
548: , a16 out nocopy JTF_VARCHAR2_TABLE_100
549: ) as
542: , a10 out nocopy JTF_DATE_TABLE
543: , a11 out nocopy JTF_NUMBER_TABLE
544: , a12 out nocopy JTF_DATE_TABLE
545: , a13 out nocopy JTF_NUMBER_TABLE
546: , a14 out nocopy JTF_NUMBER_TABLE
547: , a15 out nocopy JTF_NUMBER_TABLE
548: , a16 out nocopy JTF_VARCHAR2_TABLE_100
549: ) as
550: ddindx binary_integer; indx binary_integer;
543: , a11 out nocopy JTF_NUMBER_TABLE
544: , a12 out nocopy JTF_DATE_TABLE
545: , a13 out nocopy JTF_NUMBER_TABLE
546: , a14 out nocopy JTF_NUMBER_TABLE
547: , a15 out nocopy JTF_NUMBER_TABLE
548: , a16 out nocopy JTF_VARCHAR2_TABLE_100
549: ) as
550: ddindx binary_integer; indx binary_integer;
551: begin
549: ) as
550: ddindx binary_integer; indx binary_integer;
551: begin
552: if t is null or t.count = 0 then
553: a0 := JTF_NUMBER_TABLE();
554: a1 := JTF_NUMBER_TABLE();
555: a2 := JTF_VARCHAR2_TABLE_100();
556: a3 := JTF_NUMBER_TABLE();
557: a4 := JTF_VARCHAR2_TABLE_100();
550: ddindx binary_integer; indx binary_integer;
551: begin
552: if t is null or t.count = 0 then
553: a0 := JTF_NUMBER_TABLE();
554: a1 := JTF_NUMBER_TABLE();
555: a2 := JTF_VARCHAR2_TABLE_100();
556: a3 := JTF_NUMBER_TABLE();
557: a4 := JTF_VARCHAR2_TABLE_100();
558: a5 := JTF_VARCHAR2_TABLE_100();
552: if t is null or t.count = 0 then
553: a0 := JTF_NUMBER_TABLE();
554: a1 := JTF_NUMBER_TABLE();
555: a2 := JTF_VARCHAR2_TABLE_100();
556: a3 := JTF_NUMBER_TABLE();
557: a4 := JTF_VARCHAR2_TABLE_100();
558: a5 := JTF_VARCHAR2_TABLE_100();
559: a6 := JTF_DATE_TABLE();
560: a7 := JTF_DATE_TABLE();
557: a4 := JTF_VARCHAR2_TABLE_100();
558: a5 := JTF_VARCHAR2_TABLE_100();
559: a6 := JTF_DATE_TABLE();
560: a7 := JTF_DATE_TABLE();
561: a8 := JTF_NUMBER_TABLE();
562: a9 := JTF_NUMBER_TABLE();
563: a10 := JTF_DATE_TABLE();
564: a11 := JTF_NUMBER_TABLE();
565: a12 := JTF_DATE_TABLE();
558: a5 := JTF_VARCHAR2_TABLE_100();
559: a6 := JTF_DATE_TABLE();
560: a7 := JTF_DATE_TABLE();
561: a8 := JTF_NUMBER_TABLE();
562: a9 := JTF_NUMBER_TABLE();
563: a10 := JTF_DATE_TABLE();
564: a11 := JTF_NUMBER_TABLE();
565: a12 := JTF_DATE_TABLE();
566: a13 := JTF_NUMBER_TABLE();
560: a7 := JTF_DATE_TABLE();
561: a8 := JTF_NUMBER_TABLE();
562: a9 := JTF_NUMBER_TABLE();
563: a10 := JTF_DATE_TABLE();
564: a11 := JTF_NUMBER_TABLE();
565: a12 := JTF_DATE_TABLE();
566: a13 := JTF_NUMBER_TABLE();
567: a14 := JTF_NUMBER_TABLE();
568: a15 := JTF_NUMBER_TABLE();
562: a9 := JTF_NUMBER_TABLE();
563: a10 := JTF_DATE_TABLE();
564: a11 := JTF_NUMBER_TABLE();
565: a12 := JTF_DATE_TABLE();
566: a13 := JTF_NUMBER_TABLE();
567: a14 := JTF_NUMBER_TABLE();
568: a15 := JTF_NUMBER_TABLE();
569: a16 := JTF_VARCHAR2_TABLE_100();
570: else
563: a10 := JTF_DATE_TABLE();
564: a11 := JTF_NUMBER_TABLE();
565: a12 := JTF_DATE_TABLE();
566: a13 := JTF_NUMBER_TABLE();
567: a14 := JTF_NUMBER_TABLE();
568: a15 := JTF_NUMBER_TABLE();
569: a16 := JTF_VARCHAR2_TABLE_100();
570: else
571: a0 := JTF_NUMBER_TABLE();
564: a11 := JTF_NUMBER_TABLE();
565: a12 := JTF_DATE_TABLE();
566: a13 := JTF_NUMBER_TABLE();
567: a14 := JTF_NUMBER_TABLE();
568: a15 := JTF_NUMBER_TABLE();
569: a16 := JTF_VARCHAR2_TABLE_100();
570: else
571: a0 := JTF_NUMBER_TABLE();
572: a1 := JTF_NUMBER_TABLE();
567: a14 := JTF_NUMBER_TABLE();
568: a15 := JTF_NUMBER_TABLE();
569: a16 := JTF_VARCHAR2_TABLE_100();
570: else
571: a0 := JTF_NUMBER_TABLE();
572: a1 := JTF_NUMBER_TABLE();
573: a2 := JTF_VARCHAR2_TABLE_100();
574: a3 := JTF_NUMBER_TABLE();
575: a4 := JTF_VARCHAR2_TABLE_100();
568: a15 := JTF_NUMBER_TABLE();
569: a16 := JTF_VARCHAR2_TABLE_100();
570: else
571: a0 := JTF_NUMBER_TABLE();
572: a1 := JTF_NUMBER_TABLE();
573: a2 := JTF_VARCHAR2_TABLE_100();
574: a3 := JTF_NUMBER_TABLE();
575: a4 := JTF_VARCHAR2_TABLE_100();
576: a5 := JTF_VARCHAR2_TABLE_100();
570: else
571: a0 := JTF_NUMBER_TABLE();
572: a1 := JTF_NUMBER_TABLE();
573: a2 := JTF_VARCHAR2_TABLE_100();
574: a3 := JTF_NUMBER_TABLE();
575: a4 := JTF_VARCHAR2_TABLE_100();
576: a5 := JTF_VARCHAR2_TABLE_100();
577: a6 := JTF_DATE_TABLE();
578: a7 := JTF_DATE_TABLE();
575: a4 := JTF_VARCHAR2_TABLE_100();
576: a5 := JTF_VARCHAR2_TABLE_100();
577: a6 := JTF_DATE_TABLE();
578: a7 := JTF_DATE_TABLE();
579: a8 := JTF_NUMBER_TABLE();
580: a9 := JTF_NUMBER_TABLE();
581: a10 := JTF_DATE_TABLE();
582: a11 := JTF_NUMBER_TABLE();
583: a12 := JTF_DATE_TABLE();
576: a5 := JTF_VARCHAR2_TABLE_100();
577: a6 := JTF_DATE_TABLE();
578: a7 := JTF_DATE_TABLE();
579: a8 := JTF_NUMBER_TABLE();
580: a9 := JTF_NUMBER_TABLE();
581: a10 := JTF_DATE_TABLE();
582: a11 := JTF_NUMBER_TABLE();
583: a12 := JTF_DATE_TABLE();
584: a13 := JTF_NUMBER_TABLE();
578: a7 := JTF_DATE_TABLE();
579: a8 := JTF_NUMBER_TABLE();
580: a9 := JTF_NUMBER_TABLE();
581: a10 := JTF_DATE_TABLE();
582: a11 := JTF_NUMBER_TABLE();
583: a12 := JTF_DATE_TABLE();
584: a13 := JTF_NUMBER_TABLE();
585: a14 := JTF_NUMBER_TABLE();
586: a15 := JTF_NUMBER_TABLE();
580: a9 := JTF_NUMBER_TABLE();
581: a10 := JTF_DATE_TABLE();
582: a11 := JTF_NUMBER_TABLE();
583: a12 := JTF_DATE_TABLE();
584: a13 := JTF_NUMBER_TABLE();
585: a14 := JTF_NUMBER_TABLE();
586: a15 := JTF_NUMBER_TABLE();
587: a16 := JTF_VARCHAR2_TABLE_100();
588: if t.count > 0 then
581: a10 := JTF_DATE_TABLE();
582: a11 := JTF_NUMBER_TABLE();
583: a12 := JTF_DATE_TABLE();
584: a13 := JTF_NUMBER_TABLE();
585: a14 := JTF_NUMBER_TABLE();
586: a15 := JTF_NUMBER_TABLE();
587: a16 := JTF_VARCHAR2_TABLE_100();
588: if t.count > 0 then
589: a0.extend(t.count);
582: a11 := JTF_NUMBER_TABLE();
583: a12 := JTF_DATE_TABLE();
584: a13 := JTF_NUMBER_TABLE();
585: a14 := JTF_NUMBER_TABLE();
586: a15 := JTF_NUMBER_TABLE();
587: a16 := JTF_VARCHAR2_TABLE_100();
588: if t.count > 0 then
589: a0.extend(t.count);
590: a1.extend(t.count);
632: end if;
633: end if;
634: end rosetta_table_copy_out_p6;
635:
636: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
637: , a1 JTF_NUMBER_TABLE
638: , a2 JTF_VARCHAR2_TABLE_100
639: , a3 JTF_NUMBER_TABLE
640: , a4 JTF_NUMBER_TABLE
633: end if;
634: end rosetta_table_copy_out_p6;
635:
636: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
637: , a1 JTF_NUMBER_TABLE
638: , a2 JTF_VARCHAR2_TABLE_100
639: , a3 JTF_NUMBER_TABLE
640: , a4 JTF_NUMBER_TABLE
641: , a5 JTF_DATE_TABLE
635:
636: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
637: , a1 JTF_NUMBER_TABLE
638: , a2 JTF_VARCHAR2_TABLE_100
639: , a3 JTF_NUMBER_TABLE
640: , a4 JTF_NUMBER_TABLE
641: , a5 JTF_DATE_TABLE
642: , a6 JTF_DATE_TABLE
643: , a7 JTF_VARCHAR2_TABLE_100
636: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
637: , a1 JTF_NUMBER_TABLE
638: , a2 JTF_VARCHAR2_TABLE_100
639: , a3 JTF_NUMBER_TABLE
640: , a4 JTF_NUMBER_TABLE
641: , a5 JTF_DATE_TABLE
642: , a6 JTF_DATE_TABLE
643: , a7 JTF_VARCHAR2_TABLE_100
644: ) as
665: end loop;
666: end if;
667: end if;
668: end rosetta_table_copy_in_p8;
669: procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
670: , a1 out nocopy JTF_NUMBER_TABLE
671: , a2 out nocopy JTF_VARCHAR2_TABLE_100
672: , a3 out nocopy JTF_NUMBER_TABLE
673: , a4 out nocopy JTF_NUMBER_TABLE
666: end if;
667: end if;
668: end rosetta_table_copy_in_p8;
669: procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
670: , a1 out nocopy JTF_NUMBER_TABLE
671: , a2 out nocopy JTF_VARCHAR2_TABLE_100
672: , a3 out nocopy JTF_NUMBER_TABLE
673: , a4 out nocopy JTF_NUMBER_TABLE
674: , a5 out nocopy JTF_DATE_TABLE
668: end rosetta_table_copy_in_p8;
669: procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
670: , a1 out nocopy JTF_NUMBER_TABLE
671: , a2 out nocopy JTF_VARCHAR2_TABLE_100
672: , a3 out nocopy JTF_NUMBER_TABLE
673: , a4 out nocopy JTF_NUMBER_TABLE
674: , a5 out nocopy JTF_DATE_TABLE
675: , a6 out nocopy JTF_DATE_TABLE
676: , a7 out nocopy JTF_VARCHAR2_TABLE_100
669: procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
670: , a1 out nocopy JTF_NUMBER_TABLE
671: , a2 out nocopy JTF_VARCHAR2_TABLE_100
672: , a3 out nocopy JTF_NUMBER_TABLE
673: , a4 out nocopy JTF_NUMBER_TABLE
674: , a5 out nocopy JTF_DATE_TABLE
675: , a6 out nocopy JTF_DATE_TABLE
676: , a7 out nocopy JTF_VARCHAR2_TABLE_100
677: ) as
677: ) as
678: ddindx binary_integer; indx binary_integer;
679: begin
680: if t is null or t.count = 0 then
681: a0 := JTF_NUMBER_TABLE();
682: a1 := JTF_NUMBER_TABLE();
683: a2 := JTF_VARCHAR2_TABLE_100();
684: a3 := JTF_NUMBER_TABLE();
685: a4 := JTF_NUMBER_TABLE();
678: ddindx binary_integer; indx binary_integer;
679: begin
680: if t is null or t.count = 0 then
681: a0 := JTF_NUMBER_TABLE();
682: a1 := JTF_NUMBER_TABLE();
683: a2 := JTF_VARCHAR2_TABLE_100();
684: a3 := JTF_NUMBER_TABLE();
685: a4 := JTF_NUMBER_TABLE();
686: a5 := JTF_DATE_TABLE();
680: if t is null or t.count = 0 then
681: a0 := JTF_NUMBER_TABLE();
682: a1 := JTF_NUMBER_TABLE();
683: a2 := JTF_VARCHAR2_TABLE_100();
684: a3 := JTF_NUMBER_TABLE();
685: a4 := JTF_NUMBER_TABLE();
686: a5 := JTF_DATE_TABLE();
687: a6 := JTF_DATE_TABLE();
688: a7 := JTF_VARCHAR2_TABLE_100();
681: a0 := JTF_NUMBER_TABLE();
682: a1 := JTF_NUMBER_TABLE();
683: a2 := JTF_VARCHAR2_TABLE_100();
684: a3 := JTF_NUMBER_TABLE();
685: a4 := JTF_NUMBER_TABLE();
686: a5 := JTF_DATE_TABLE();
687: a6 := JTF_DATE_TABLE();
688: a7 := JTF_VARCHAR2_TABLE_100();
689: else
686: a5 := JTF_DATE_TABLE();
687: a6 := JTF_DATE_TABLE();
688: a7 := JTF_VARCHAR2_TABLE_100();
689: else
690: a0 := JTF_NUMBER_TABLE();
691: a1 := JTF_NUMBER_TABLE();
692: a2 := JTF_VARCHAR2_TABLE_100();
693: a3 := JTF_NUMBER_TABLE();
694: a4 := JTF_NUMBER_TABLE();
687: a6 := JTF_DATE_TABLE();
688: a7 := JTF_VARCHAR2_TABLE_100();
689: else
690: a0 := JTF_NUMBER_TABLE();
691: a1 := JTF_NUMBER_TABLE();
692: a2 := JTF_VARCHAR2_TABLE_100();
693: a3 := JTF_NUMBER_TABLE();
694: a4 := JTF_NUMBER_TABLE();
695: a5 := JTF_DATE_TABLE();
689: else
690: a0 := JTF_NUMBER_TABLE();
691: a1 := JTF_NUMBER_TABLE();
692: a2 := JTF_VARCHAR2_TABLE_100();
693: a3 := JTF_NUMBER_TABLE();
694: a4 := JTF_NUMBER_TABLE();
695: a5 := JTF_DATE_TABLE();
696: a6 := JTF_DATE_TABLE();
697: a7 := JTF_VARCHAR2_TABLE_100();
690: a0 := JTF_NUMBER_TABLE();
691: a1 := JTF_NUMBER_TABLE();
692: a2 := JTF_VARCHAR2_TABLE_100();
693: a3 := JTF_NUMBER_TABLE();
694: a4 := JTF_NUMBER_TABLE();
695: a5 := JTF_DATE_TABLE();
696: a6 := JTF_DATE_TABLE();
697: a7 := JTF_VARCHAR2_TABLE_100();
698: if t.count > 0 then
724: end if;
725: end if;
726: end rosetta_table_copy_out_p8;
727:
728: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
729: , a1 JTF_NUMBER_TABLE
730: , a2 JTF_NUMBER_TABLE
731: , a3 JTF_NUMBER_TABLE
732: , a4 JTF_NUMBER_TABLE
725: end if;
726: end rosetta_table_copy_out_p8;
727:
728: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
729: , a1 JTF_NUMBER_TABLE
730: , a2 JTF_NUMBER_TABLE
731: , a3 JTF_NUMBER_TABLE
732: , a4 JTF_NUMBER_TABLE
733: , a5 JTF_VARCHAR2_TABLE_100
726: end rosetta_table_copy_out_p8;
727:
728: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
729: , a1 JTF_NUMBER_TABLE
730: , a2 JTF_NUMBER_TABLE
731: , a3 JTF_NUMBER_TABLE
732: , a4 JTF_NUMBER_TABLE
733: , a5 JTF_VARCHAR2_TABLE_100
734: , a6 JTF_VARCHAR2_TABLE_100
727:
728: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
729: , a1 JTF_NUMBER_TABLE
730: , a2 JTF_NUMBER_TABLE
731: , a3 JTF_NUMBER_TABLE
732: , a4 JTF_NUMBER_TABLE
733: , a5 JTF_VARCHAR2_TABLE_100
734: , a6 JTF_VARCHAR2_TABLE_100
735: , a7 JTF_VARCHAR2_TABLE_100
728: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
729: , a1 JTF_NUMBER_TABLE
730: , a2 JTF_NUMBER_TABLE
731: , a3 JTF_NUMBER_TABLE
732: , a4 JTF_NUMBER_TABLE
733: , a5 JTF_VARCHAR2_TABLE_100
734: , a6 JTF_VARCHAR2_TABLE_100
735: , a7 JTF_VARCHAR2_TABLE_100
736: , a8 JTF_NUMBER_TABLE
732: , a4 JTF_NUMBER_TABLE
733: , a5 JTF_VARCHAR2_TABLE_100
734: , a6 JTF_VARCHAR2_TABLE_100
735: , a7 JTF_VARCHAR2_TABLE_100
736: , a8 JTF_NUMBER_TABLE
737: , a9 JTF_VARCHAR2_TABLE_100
738: , a10 JTF_DATE_TABLE
739: , a11 JTF_DATE_TABLE
740: , a12 JTF_VARCHAR2_TABLE_100
737: , a9 JTF_VARCHAR2_TABLE_100
738: , a10 JTF_DATE_TABLE
739: , a11 JTF_DATE_TABLE
740: , a12 JTF_VARCHAR2_TABLE_100
741: , a13 JTF_NUMBER_TABLE
742: , a14 JTF_VARCHAR2_TABLE_100
743: ) as
744: ddindx binary_integer; indx binary_integer;
745: begin
771: end loop;
772: end if;
773: end if;
774: end rosetta_table_copy_in_p10;
775: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
776: , a1 out nocopy JTF_NUMBER_TABLE
777: , a2 out nocopy JTF_NUMBER_TABLE
778: , a3 out nocopy JTF_NUMBER_TABLE
779: , a4 out nocopy JTF_NUMBER_TABLE
772: end if;
773: end if;
774: end rosetta_table_copy_in_p10;
775: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
776: , a1 out nocopy JTF_NUMBER_TABLE
777: , a2 out nocopy JTF_NUMBER_TABLE
778: , a3 out nocopy JTF_NUMBER_TABLE
779: , a4 out nocopy JTF_NUMBER_TABLE
780: , a5 out nocopy JTF_VARCHAR2_TABLE_100
773: end if;
774: end rosetta_table_copy_in_p10;
775: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
776: , a1 out nocopy JTF_NUMBER_TABLE
777: , a2 out nocopy JTF_NUMBER_TABLE
778: , a3 out nocopy JTF_NUMBER_TABLE
779: , a4 out nocopy JTF_NUMBER_TABLE
780: , a5 out nocopy JTF_VARCHAR2_TABLE_100
781: , a6 out nocopy JTF_VARCHAR2_TABLE_100
774: end rosetta_table_copy_in_p10;
775: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
776: , a1 out nocopy JTF_NUMBER_TABLE
777: , a2 out nocopy JTF_NUMBER_TABLE
778: , a3 out nocopy JTF_NUMBER_TABLE
779: , a4 out nocopy JTF_NUMBER_TABLE
780: , a5 out nocopy JTF_VARCHAR2_TABLE_100
781: , a6 out nocopy JTF_VARCHAR2_TABLE_100
782: , a7 out nocopy JTF_VARCHAR2_TABLE_100
775: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
776: , a1 out nocopy JTF_NUMBER_TABLE
777: , a2 out nocopy JTF_NUMBER_TABLE
778: , a3 out nocopy JTF_NUMBER_TABLE
779: , a4 out nocopy JTF_NUMBER_TABLE
780: , a5 out nocopy JTF_VARCHAR2_TABLE_100
781: , a6 out nocopy JTF_VARCHAR2_TABLE_100
782: , a7 out nocopy JTF_VARCHAR2_TABLE_100
783: , a8 out nocopy JTF_NUMBER_TABLE
779: , a4 out nocopy JTF_NUMBER_TABLE
780: , a5 out nocopy JTF_VARCHAR2_TABLE_100
781: , a6 out nocopy JTF_VARCHAR2_TABLE_100
782: , a7 out nocopy JTF_VARCHAR2_TABLE_100
783: , a8 out nocopy JTF_NUMBER_TABLE
784: , a9 out nocopy JTF_VARCHAR2_TABLE_100
785: , a10 out nocopy JTF_DATE_TABLE
786: , a11 out nocopy JTF_DATE_TABLE
787: , a12 out nocopy JTF_VARCHAR2_TABLE_100
784: , a9 out nocopy JTF_VARCHAR2_TABLE_100
785: , a10 out nocopy JTF_DATE_TABLE
786: , a11 out nocopy JTF_DATE_TABLE
787: , a12 out nocopy JTF_VARCHAR2_TABLE_100
788: , a13 out nocopy JTF_NUMBER_TABLE
789: , a14 out nocopy JTF_VARCHAR2_TABLE_100
790: ) as
791: ddindx binary_integer; indx binary_integer;
792: begin
790: ) as
791: ddindx binary_integer; indx binary_integer;
792: begin
793: if t is null or t.count = 0 then
794: a0 := JTF_NUMBER_TABLE();
795: a1 := JTF_NUMBER_TABLE();
796: a2 := JTF_NUMBER_TABLE();
797: a3 := JTF_NUMBER_TABLE();
798: a4 := JTF_NUMBER_TABLE();
791: ddindx binary_integer; indx binary_integer;
792: begin
793: if t is null or t.count = 0 then
794: a0 := JTF_NUMBER_TABLE();
795: a1 := JTF_NUMBER_TABLE();
796: a2 := JTF_NUMBER_TABLE();
797: a3 := JTF_NUMBER_TABLE();
798: a4 := JTF_NUMBER_TABLE();
799: a5 := JTF_VARCHAR2_TABLE_100();
792: begin
793: if t is null or t.count = 0 then
794: a0 := JTF_NUMBER_TABLE();
795: a1 := JTF_NUMBER_TABLE();
796: a2 := JTF_NUMBER_TABLE();
797: a3 := JTF_NUMBER_TABLE();
798: a4 := JTF_NUMBER_TABLE();
799: a5 := JTF_VARCHAR2_TABLE_100();
800: a6 := JTF_VARCHAR2_TABLE_100();
793: if t is null or t.count = 0 then
794: a0 := JTF_NUMBER_TABLE();
795: a1 := JTF_NUMBER_TABLE();
796: a2 := JTF_NUMBER_TABLE();
797: a3 := JTF_NUMBER_TABLE();
798: a4 := JTF_NUMBER_TABLE();
799: a5 := JTF_VARCHAR2_TABLE_100();
800: a6 := JTF_VARCHAR2_TABLE_100();
801: a7 := JTF_VARCHAR2_TABLE_100();
794: a0 := JTF_NUMBER_TABLE();
795: a1 := JTF_NUMBER_TABLE();
796: a2 := JTF_NUMBER_TABLE();
797: a3 := JTF_NUMBER_TABLE();
798: a4 := JTF_NUMBER_TABLE();
799: a5 := JTF_VARCHAR2_TABLE_100();
800: a6 := JTF_VARCHAR2_TABLE_100();
801: a7 := JTF_VARCHAR2_TABLE_100();
802: a8 := JTF_NUMBER_TABLE();
798: a4 := JTF_NUMBER_TABLE();
799: a5 := JTF_VARCHAR2_TABLE_100();
800: a6 := JTF_VARCHAR2_TABLE_100();
801: a7 := JTF_VARCHAR2_TABLE_100();
802: a8 := JTF_NUMBER_TABLE();
803: a9 := JTF_VARCHAR2_TABLE_100();
804: a10 := JTF_DATE_TABLE();
805: a11 := JTF_DATE_TABLE();
806: a12 := JTF_VARCHAR2_TABLE_100();
803: a9 := JTF_VARCHAR2_TABLE_100();
804: a10 := JTF_DATE_TABLE();
805: a11 := JTF_DATE_TABLE();
806: a12 := JTF_VARCHAR2_TABLE_100();
807: a13 := JTF_NUMBER_TABLE();
808: a14 := JTF_VARCHAR2_TABLE_100();
809: else
810: a0 := JTF_NUMBER_TABLE();
811: a1 := JTF_NUMBER_TABLE();
806: a12 := JTF_VARCHAR2_TABLE_100();
807: a13 := JTF_NUMBER_TABLE();
808: a14 := JTF_VARCHAR2_TABLE_100();
809: else
810: a0 := JTF_NUMBER_TABLE();
811: a1 := JTF_NUMBER_TABLE();
812: a2 := JTF_NUMBER_TABLE();
813: a3 := JTF_NUMBER_TABLE();
814: a4 := JTF_NUMBER_TABLE();
807: a13 := JTF_NUMBER_TABLE();
808: a14 := JTF_VARCHAR2_TABLE_100();
809: else
810: a0 := JTF_NUMBER_TABLE();
811: a1 := JTF_NUMBER_TABLE();
812: a2 := JTF_NUMBER_TABLE();
813: a3 := JTF_NUMBER_TABLE();
814: a4 := JTF_NUMBER_TABLE();
815: a5 := JTF_VARCHAR2_TABLE_100();
808: a14 := JTF_VARCHAR2_TABLE_100();
809: else
810: a0 := JTF_NUMBER_TABLE();
811: a1 := JTF_NUMBER_TABLE();
812: a2 := JTF_NUMBER_TABLE();
813: a3 := JTF_NUMBER_TABLE();
814: a4 := JTF_NUMBER_TABLE();
815: a5 := JTF_VARCHAR2_TABLE_100();
816: a6 := JTF_VARCHAR2_TABLE_100();
809: else
810: a0 := JTF_NUMBER_TABLE();
811: a1 := JTF_NUMBER_TABLE();
812: a2 := JTF_NUMBER_TABLE();
813: a3 := JTF_NUMBER_TABLE();
814: a4 := JTF_NUMBER_TABLE();
815: a5 := JTF_VARCHAR2_TABLE_100();
816: a6 := JTF_VARCHAR2_TABLE_100();
817: a7 := JTF_VARCHAR2_TABLE_100();
810: a0 := JTF_NUMBER_TABLE();
811: a1 := JTF_NUMBER_TABLE();
812: a2 := JTF_NUMBER_TABLE();
813: a3 := JTF_NUMBER_TABLE();
814: a4 := JTF_NUMBER_TABLE();
815: a5 := JTF_VARCHAR2_TABLE_100();
816: a6 := JTF_VARCHAR2_TABLE_100();
817: a7 := JTF_VARCHAR2_TABLE_100();
818: a8 := JTF_NUMBER_TABLE();
814: a4 := JTF_NUMBER_TABLE();
815: a5 := JTF_VARCHAR2_TABLE_100();
816: a6 := JTF_VARCHAR2_TABLE_100();
817: a7 := JTF_VARCHAR2_TABLE_100();
818: a8 := JTF_NUMBER_TABLE();
819: a9 := JTF_VARCHAR2_TABLE_100();
820: a10 := JTF_DATE_TABLE();
821: a11 := JTF_DATE_TABLE();
822: a12 := JTF_VARCHAR2_TABLE_100();
819: a9 := JTF_VARCHAR2_TABLE_100();
820: a10 := JTF_DATE_TABLE();
821: a11 := JTF_DATE_TABLE();
822: a12 := JTF_VARCHAR2_TABLE_100();
823: a13 := JTF_NUMBER_TABLE();
824: a14 := JTF_VARCHAR2_TABLE_100();
825: if t.count > 0 then
826: a0.extend(t.count);
827: a1.extend(t.count);
865: end if;
866: end if;
867: end rosetta_table_copy_out_p10;
868:
869: procedure rosetta_table_copy_in_p12(t out nocopy ozf_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
870: , a1 JTF_DATE_TABLE
871: , a2 JTF_NUMBER_TABLE
872: , a3 JTF_DATE_TABLE
873: , a4 JTF_NUMBER_TABLE
867: end rosetta_table_copy_out_p10;
868:
869: procedure rosetta_table_copy_in_p12(t out nocopy ozf_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
870: , a1 JTF_DATE_TABLE
871: , a2 JTF_NUMBER_TABLE
872: , a3 JTF_DATE_TABLE
873: , a4 JTF_NUMBER_TABLE
874: , a5 JTF_NUMBER_TABLE
875: , a6 JTF_NUMBER_TABLE
869: procedure rosetta_table_copy_in_p12(t out nocopy ozf_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
870: , a1 JTF_DATE_TABLE
871: , a2 JTF_NUMBER_TABLE
872: , a3 JTF_DATE_TABLE
873: , a4 JTF_NUMBER_TABLE
874: , a5 JTF_NUMBER_TABLE
875: , a6 JTF_NUMBER_TABLE
876: , a7 JTF_VARCHAR2_TABLE_100
877: , a8 JTF_VARCHAR2_TABLE_100
870: , a1 JTF_DATE_TABLE
871: , a2 JTF_NUMBER_TABLE
872: , a3 JTF_DATE_TABLE
873: , a4 JTF_NUMBER_TABLE
874: , a5 JTF_NUMBER_TABLE
875: , a6 JTF_NUMBER_TABLE
876: , a7 JTF_VARCHAR2_TABLE_100
877: , a8 JTF_VARCHAR2_TABLE_100
878: , a9 JTF_VARCHAR2_TABLE_300
871: , a2 JTF_NUMBER_TABLE
872: , a3 JTF_DATE_TABLE
873: , a4 JTF_NUMBER_TABLE
874: , a5 JTF_NUMBER_TABLE
875: , a6 JTF_NUMBER_TABLE
876: , a7 JTF_VARCHAR2_TABLE_100
877: , a8 JTF_VARCHAR2_TABLE_100
878: , a9 JTF_VARCHAR2_TABLE_300
879: , a10 JTF_DATE_TABLE
877: , a8 JTF_VARCHAR2_TABLE_100
878: , a9 JTF_VARCHAR2_TABLE_300
879: , a10 JTF_DATE_TABLE
880: , a11 JTF_DATE_TABLE
881: , a12 JTF_NUMBER_TABLE
882: , a13 JTF_NUMBER_TABLE
883: , a14 JTF_VARCHAR2_TABLE_100
884: , a15 JTF_VARCHAR2_TABLE_300
885: , a16 JTF_VARCHAR2_TABLE_300
878: , a9 JTF_VARCHAR2_TABLE_300
879: , a10 JTF_DATE_TABLE
880: , a11 JTF_DATE_TABLE
881: , a12 JTF_NUMBER_TABLE
882: , a13 JTF_NUMBER_TABLE
883: , a14 JTF_VARCHAR2_TABLE_100
884: , a15 JTF_VARCHAR2_TABLE_300
885: , a16 JTF_VARCHAR2_TABLE_300
886: , a17 JTF_VARCHAR2_TABLE_300
896: , a27 JTF_VARCHAR2_TABLE_300
897: , a28 JTF_VARCHAR2_TABLE_300
898: , a29 JTF_VARCHAR2_TABLE_300
899: , a30 JTF_VARCHAR2_TABLE_100
900: , a31 JTF_NUMBER_TABLE
901: , a32 JTF_VARCHAR2_TABLE_100
902: ) as
903: ddindx binary_integer; indx binary_integer;
904: begin
948: end loop;
949: end if;
950: end if;
951: end rosetta_table_copy_in_p12;
952: procedure rosetta_table_copy_out_p12(t ozf_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
953: , a1 out nocopy JTF_DATE_TABLE
954: , a2 out nocopy JTF_NUMBER_TABLE
955: , a3 out nocopy JTF_DATE_TABLE
956: , a4 out nocopy JTF_NUMBER_TABLE
950: end if;
951: end rosetta_table_copy_in_p12;
952: procedure rosetta_table_copy_out_p12(t ozf_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
953: , a1 out nocopy JTF_DATE_TABLE
954: , a2 out nocopy JTF_NUMBER_TABLE
955: , a3 out nocopy JTF_DATE_TABLE
956: , a4 out nocopy JTF_NUMBER_TABLE
957: , a5 out nocopy JTF_NUMBER_TABLE
958: , a6 out nocopy JTF_NUMBER_TABLE
952: procedure rosetta_table_copy_out_p12(t ozf_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
953: , a1 out nocopy JTF_DATE_TABLE
954: , a2 out nocopy JTF_NUMBER_TABLE
955: , a3 out nocopy JTF_DATE_TABLE
956: , a4 out nocopy JTF_NUMBER_TABLE
957: , a5 out nocopy JTF_NUMBER_TABLE
958: , a6 out nocopy JTF_NUMBER_TABLE
959: , a7 out nocopy JTF_VARCHAR2_TABLE_100
960: , a8 out nocopy JTF_VARCHAR2_TABLE_100
953: , a1 out nocopy JTF_DATE_TABLE
954: , a2 out nocopy JTF_NUMBER_TABLE
955: , a3 out nocopy JTF_DATE_TABLE
956: , a4 out nocopy JTF_NUMBER_TABLE
957: , a5 out nocopy JTF_NUMBER_TABLE
958: , a6 out nocopy JTF_NUMBER_TABLE
959: , a7 out nocopy JTF_VARCHAR2_TABLE_100
960: , a8 out nocopy JTF_VARCHAR2_TABLE_100
961: , a9 out nocopy JTF_VARCHAR2_TABLE_300
954: , a2 out nocopy JTF_NUMBER_TABLE
955: , a3 out nocopy JTF_DATE_TABLE
956: , a4 out nocopy JTF_NUMBER_TABLE
957: , a5 out nocopy JTF_NUMBER_TABLE
958: , a6 out nocopy JTF_NUMBER_TABLE
959: , a7 out nocopy JTF_VARCHAR2_TABLE_100
960: , a8 out nocopy JTF_VARCHAR2_TABLE_100
961: , a9 out nocopy JTF_VARCHAR2_TABLE_300
962: , a10 out nocopy JTF_DATE_TABLE
960: , a8 out nocopy JTF_VARCHAR2_TABLE_100
961: , a9 out nocopy JTF_VARCHAR2_TABLE_300
962: , a10 out nocopy JTF_DATE_TABLE
963: , a11 out nocopy JTF_DATE_TABLE
964: , a12 out nocopy JTF_NUMBER_TABLE
965: , a13 out nocopy JTF_NUMBER_TABLE
966: , a14 out nocopy JTF_VARCHAR2_TABLE_100
967: , a15 out nocopy JTF_VARCHAR2_TABLE_300
968: , a16 out nocopy JTF_VARCHAR2_TABLE_300
961: , a9 out nocopy JTF_VARCHAR2_TABLE_300
962: , a10 out nocopy JTF_DATE_TABLE
963: , a11 out nocopy JTF_DATE_TABLE
964: , a12 out nocopy JTF_NUMBER_TABLE
965: , a13 out nocopy JTF_NUMBER_TABLE
966: , a14 out nocopy JTF_VARCHAR2_TABLE_100
967: , a15 out nocopy JTF_VARCHAR2_TABLE_300
968: , a16 out nocopy JTF_VARCHAR2_TABLE_300
969: , a17 out nocopy JTF_VARCHAR2_TABLE_300
979: , a27 out nocopy JTF_VARCHAR2_TABLE_300
980: , a28 out nocopy JTF_VARCHAR2_TABLE_300
981: , a29 out nocopy JTF_VARCHAR2_TABLE_300
982: , a30 out nocopy JTF_VARCHAR2_TABLE_100
983: , a31 out nocopy JTF_NUMBER_TABLE
984: , a32 out nocopy JTF_VARCHAR2_TABLE_100
985: ) as
986: ddindx binary_integer; indx binary_integer;
987: begin
985: ) as
986: ddindx binary_integer; indx binary_integer;
987: begin
988: if t is null or t.count = 0 then
989: a0 := JTF_NUMBER_TABLE();
990: a1 := JTF_DATE_TABLE();
991: a2 := JTF_NUMBER_TABLE();
992: a3 := JTF_DATE_TABLE();
993: a4 := JTF_NUMBER_TABLE();
987: begin
988: if t is null or t.count = 0 then
989: a0 := JTF_NUMBER_TABLE();
990: a1 := JTF_DATE_TABLE();
991: a2 := JTF_NUMBER_TABLE();
992: a3 := JTF_DATE_TABLE();
993: a4 := JTF_NUMBER_TABLE();
994: a5 := JTF_NUMBER_TABLE();
995: a6 := JTF_NUMBER_TABLE();
989: a0 := JTF_NUMBER_TABLE();
990: a1 := JTF_DATE_TABLE();
991: a2 := JTF_NUMBER_TABLE();
992: a3 := JTF_DATE_TABLE();
993: a4 := JTF_NUMBER_TABLE();
994: a5 := JTF_NUMBER_TABLE();
995: a6 := JTF_NUMBER_TABLE();
996: a7 := JTF_VARCHAR2_TABLE_100();
997: a8 := JTF_VARCHAR2_TABLE_100();
990: a1 := JTF_DATE_TABLE();
991: a2 := JTF_NUMBER_TABLE();
992: a3 := JTF_DATE_TABLE();
993: a4 := JTF_NUMBER_TABLE();
994: a5 := JTF_NUMBER_TABLE();
995: a6 := JTF_NUMBER_TABLE();
996: a7 := JTF_VARCHAR2_TABLE_100();
997: a8 := JTF_VARCHAR2_TABLE_100();
998: a9 := JTF_VARCHAR2_TABLE_300();
991: a2 := JTF_NUMBER_TABLE();
992: a3 := JTF_DATE_TABLE();
993: a4 := JTF_NUMBER_TABLE();
994: a5 := JTF_NUMBER_TABLE();
995: a6 := JTF_NUMBER_TABLE();
996: a7 := JTF_VARCHAR2_TABLE_100();
997: a8 := JTF_VARCHAR2_TABLE_100();
998: a9 := JTF_VARCHAR2_TABLE_300();
999: a10 := JTF_DATE_TABLE();
997: a8 := JTF_VARCHAR2_TABLE_100();
998: a9 := JTF_VARCHAR2_TABLE_300();
999: a10 := JTF_DATE_TABLE();
1000: a11 := JTF_DATE_TABLE();
1001: a12 := JTF_NUMBER_TABLE();
1002: a13 := JTF_NUMBER_TABLE();
1003: a14 := JTF_VARCHAR2_TABLE_100();
1004: a15 := JTF_VARCHAR2_TABLE_300();
1005: a16 := JTF_VARCHAR2_TABLE_300();
998: a9 := JTF_VARCHAR2_TABLE_300();
999: a10 := JTF_DATE_TABLE();
1000: a11 := JTF_DATE_TABLE();
1001: a12 := JTF_NUMBER_TABLE();
1002: a13 := JTF_NUMBER_TABLE();
1003: a14 := JTF_VARCHAR2_TABLE_100();
1004: a15 := JTF_VARCHAR2_TABLE_300();
1005: a16 := JTF_VARCHAR2_TABLE_300();
1006: a17 := JTF_VARCHAR2_TABLE_300();
1016: a27 := JTF_VARCHAR2_TABLE_300();
1017: a28 := JTF_VARCHAR2_TABLE_300();
1018: a29 := JTF_VARCHAR2_TABLE_300();
1019: a30 := JTF_VARCHAR2_TABLE_100();
1020: a31 := JTF_NUMBER_TABLE();
1021: a32 := JTF_VARCHAR2_TABLE_100();
1022: else
1023: a0 := JTF_NUMBER_TABLE();
1024: a1 := JTF_DATE_TABLE();
1019: a30 := JTF_VARCHAR2_TABLE_100();
1020: a31 := JTF_NUMBER_TABLE();
1021: a32 := JTF_VARCHAR2_TABLE_100();
1022: else
1023: a0 := JTF_NUMBER_TABLE();
1024: a1 := JTF_DATE_TABLE();
1025: a2 := JTF_NUMBER_TABLE();
1026: a3 := JTF_DATE_TABLE();
1027: a4 := JTF_NUMBER_TABLE();
1021: a32 := JTF_VARCHAR2_TABLE_100();
1022: else
1023: a0 := JTF_NUMBER_TABLE();
1024: a1 := JTF_DATE_TABLE();
1025: a2 := JTF_NUMBER_TABLE();
1026: a3 := JTF_DATE_TABLE();
1027: a4 := JTF_NUMBER_TABLE();
1028: a5 := JTF_NUMBER_TABLE();
1029: a6 := JTF_NUMBER_TABLE();
1023: a0 := JTF_NUMBER_TABLE();
1024: a1 := JTF_DATE_TABLE();
1025: a2 := JTF_NUMBER_TABLE();
1026: a3 := JTF_DATE_TABLE();
1027: a4 := JTF_NUMBER_TABLE();
1028: a5 := JTF_NUMBER_TABLE();
1029: a6 := JTF_NUMBER_TABLE();
1030: a7 := JTF_VARCHAR2_TABLE_100();
1031: a8 := JTF_VARCHAR2_TABLE_100();
1024: a1 := JTF_DATE_TABLE();
1025: a2 := JTF_NUMBER_TABLE();
1026: a3 := JTF_DATE_TABLE();
1027: a4 := JTF_NUMBER_TABLE();
1028: a5 := JTF_NUMBER_TABLE();
1029: a6 := JTF_NUMBER_TABLE();
1030: a7 := JTF_VARCHAR2_TABLE_100();
1031: a8 := JTF_VARCHAR2_TABLE_100();
1032: a9 := JTF_VARCHAR2_TABLE_300();
1025: a2 := JTF_NUMBER_TABLE();
1026: a3 := JTF_DATE_TABLE();
1027: a4 := JTF_NUMBER_TABLE();
1028: a5 := JTF_NUMBER_TABLE();
1029: a6 := JTF_NUMBER_TABLE();
1030: a7 := JTF_VARCHAR2_TABLE_100();
1031: a8 := JTF_VARCHAR2_TABLE_100();
1032: a9 := JTF_VARCHAR2_TABLE_300();
1033: a10 := JTF_DATE_TABLE();
1031: a8 := JTF_VARCHAR2_TABLE_100();
1032: a9 := JTF_VARCHAR2_TABLE_300();
1033: a10 := JTF_DATE_TABLE();
1034: a11 := JTF_DATE_TABLE();
1035: a12 := JTF_NUMBER_TABLE();
1036: a13 := JTF_NUMBER_TABLE();
1037: a14 := JTF_VARCHAR2_TABLE_100();
1038: a15 := JTF_VARCHAR2_TABLE_300();
1039: a16 := JTF_VARCHAR2_TABLE_300();
1032: a9 := JTF_VARCHAR2_TABLE_300();
1033: a10 := JTF_DATE_TABLE();
1034: a11 := JTF_DATE_TABLE();
1035: a12 := JTF_NUMBER_TABLE();
1036: a13 := JTF_NUMBER_TABLE();
1037: a14 := JTF_VARCHAR2_TABLE_100();
1038: a15 := JTF_VARCHAR2_TABLE_300();
1039: a16 := JTF_VARCHAR2_TABLE_300();
1040: a17 := JTF_VARCHAR2_TABLE_300();
1050: a27 := JTF_VARCHAR2_TABLE_300();
1051: a28 := JTF_VARCHAR2_TABLE_300();
1052: a29 := JTF_VARCHAR2_TABLE_300();
1053: a30 := JTF_VARCHAR2_TABLE_100();
1054: a31 := JTF_NUMBER_TABLE();
1055: a32 := JTF_VARCHAR2_TABLE_100();
1056: if t.count > 0 then
1057: a0.extend(t.count);
1058: a1.extend(t.count);
1132: end if;
1133: end if;
1134: end rosetta_table_copy_out_p12;
1135:
1136: procedure rosetta_table_copy_in_p14(t out nocopy ozf_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
1137: , a1 JTF_NUMBER_TABLE
1138: , a2 JTF_NUMBER_TABLE
1139: , a3 JTF_VARCHAR2_TABLE_100
1140: ) as
1133: end if;
1134: end rosetta_table_copy_out_p12;
1135:
1136: procedure rosetta_table_copy_in_p14(t out nocopy ozf_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
1137: , a1 JTF_NUMBER_TABLE
1138: , a2 JTF_NUMBER_TABLE
1139: , a3 JTF_VARCHAR2_TABLE_100
1140: ) as
1141: ddindx binary_integer; indx binary_integer;
1134: end rosetta_table_copy_out_p12;
1135:
1136: procedure rosetta_table_copy_in_p14(t out nocopy ozf_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
1137: , a1 JTF_NUMBER_TABLE
1138: , a2 JTF_NUMBER_TABLE
1139: , a3 JTF_VARCHAR2_TABLE_100
1140: ) as
1141: ddindx binary_integer; indx binary_integer;
1142: begin
1157: end loop;
1158: end if;
1159: end if;
1160: end rosetta_table_copy_in_p14;
1161: procedure rosetta_table_copy_out_p14(t ozf_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1162: , a1 out nocopy JTF_NUMBER_TABLE
1163: , a2 out nocopy JTF_NUMBER_TABLE
1164: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1165: ) as
1158: end if;
1159: end if;
1160: end rosetta_table_copy_in_p14;
1161: procedure rosetta_table_copy_out_p14(t ozf_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1162: , a1 out nocopy JTF_NUMBER_TABLE
1163: , a2 out nocopy JTF_NUMBER_TABLE
1164: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1165: ) as
1166: ddindx binary_integer; indx binary_integer;
1159: end if;
1160: end rosetta_table_copy_in_p14;
1161: procedure rosetta_table_copy_out_p14(t ozf_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1162: , a1 out nocopy JTF_NUMBER_TABLE
1163: , a2 out nocopy JTF_NUMBER_TABLE
1164: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1165: ) as
1166: ddindx binary_integer; indx binary_integer;
1167: begin
1165: ) as
1166: ddindx binary_integer; indx binary_integer;
1167: begin
1168: if t is null or t.count = 0 then
1169: a0 := JTF_NUMBER_TABLE();
1170: a1 := JTF_NUMBER_TABLE();
1171: a2 := JTF_NUMBER_TABLE();
1172: a3 := JTF_VARCHAR2_TABLE_100();
1173: else
1166: ddindx binary_integer; indx binary_integer;
1167: begin
1168: if t is null or t.count = 0 then
1169: a0 := JTF_NUMBER_TABLE();
1170: a1 := JTF_NUMBER_TABLE();
1171: a2 := JTF_NUMBER_TABLE();
1172: a3 := JTF_VARCHAR2_TABLE_100();
1173: else
1174: a0 := JTF_NUMBER_TABLE();
1167: begin
1168: if t is null or t.count = 0 then
1169: a0 := JTF_NUMBER_TABLE();
1170: a1 := JTF_NUMBER_TABLE();
1171: a2 := JTF_NUMBER_TABLE();
1172: a3 := JTF_VARCHAR2_TABLE_100();
1173: else
1174: a0 := JTF_NUMBER_TABLE();
1175: a1 := JTF_NUMBER_TABLE();
1170: a1 := JTF_NUMBER_TABLE();
1171: a2 := JTF_NUMBER_TABLE();
1172: a3 := JTF_VARCHAR2_TABLE_100();
1173: else
1174: a0 := JTF_NUMBER_TABLE();
1175: a1 := JTF_NUMBER_TABLE();
1176: a2 := JTF_NUMBER_TABLE();
1177: a3 := JTF_VARCHAR2_TABLE_100();
1178: if t.count > 0 then
1171: a2 := JTF_NUMBER_TABLE();
1172: a3 := JTF_VARCHAR2_TABLE_100();
1173: else
1174: a0 := JTF_NUMBER_TABLE();
1175: a1 := JTF_NUMBER_TABLE();
1176: a2 := JTF_NUMBER_TABLE();
1177: a3 := JTF_VARCHAR2_TABLE_100();
1178: if t.count > 0 then
1179: a0.extend(t.count);
1172: a3 := JTF_VARCHAR2_TABLE_100();
1173: else
1174: a0 := JTF_NUMBER_TABLE();
1175: a1 := JTF_NUMBER_TABLE();
1176: a2 := JTF_NUMBER_TABLE();
1177: a3 := JTF_VARCHAR2_TABLE_100();
1178: if t.count > 0 then
1179: a0.extend(t.count);
1180: a1.extend(t.count);
1198: end rosetta_table_copy_out_p14;
1199:
1200: procedure rosetta_table_copy_in_p17(t out nocopy ozf_offer_pub.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1201: , a1 JTF_VARCHAR2_TABLE_100
1202: , a2 JTF_NUMBER_TABLE
1203: , a3 JTF_NUMBER_TABLE
1204: , a4 JTF_VARCHAR2_TABLE_100
1205: , a5 JTF_NUMBER_TABLE
1206: , a6 JTF_DATE_TABLE
1199:
1200: procedure rosetta_table_copy_in_p17(t out nocopy ozf_offer_pub.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1201: , a1 JTF_VARCHAR2_TABLE_100
1202: , a2 JTF_NUMBER_TABLE
1203: , a3 JTF_NUMBER_TABLE
1204: , a4 JTF_VARCHAR2_TABLE_100
1205: , a5 JTF_NUMBER_TABLE
1206: , a6 JTF_DATE_TABLE
1207: , a7 JTF_DATE_TABLE
1201: , a1 JTF_VARCHAR2_TABLE_100
1202: , a2 JTF_NUMBER_TABLE
1203: , a3 JTF_NUMBER_TABLE
1204: , a4 JTF_VARCHAR2_TABLE_100
1205: , a5 JTF_NUMBER_TABLE
1206: , a6 JTF_DATE_TABLE
1207: , a7 JTF_DATE_TABLE
1208: , a8 JTF_VARCHAR2_TABLE_100
1209: , a9 JTF_VARCHAR2_TABLE_100
1206: , a6 JTF_DATE_TABLE
1207: , a7 JTF_DATE_TABLE
1208: , a8 JTF_VARCHAR2_TABLE_100
1209: , a9 JTF_VARCHAR2_TABLE_100
1210: , a10 JTF_NUMBER_TABLE
1211: , a11 JTF_VARCHAR2_TABLE_100
1212: , a12 JTF_NUMBER_TABLE
1213: , a13 JTF_NUMBER_TABLE
1214: , a14 JTF_VARCHAR2_TABLE_100
1208: , a8 JTF_VARCHAR2_TABLE_100
1209: , a9 JTF_VARCHAR2_TABLE_100
1210: , a10 JTF_NUMBER_TABLE
1211: , a11 JTF_VARCHAR2_TABLE_100
1212: , a12 JTF_NUMBER_TABLE
1213: , a13 JTF_NUMBER_TABLE
1214: , a14 JTF_VARCHAR2_TABLE_100
1215: , a15 JTF_NUMBER_TABLE
1216: , a16 JTF_VARCHAR2_TABLE_100
1209: , a9 JTF_VARCHAR2_TABLE_100
1210: , a10 JTF_NUMBER_TABLE
1211: , a11 JTF_VARCHAR2_TABLE_100
1212: , a12 JTF_NUMBER_TABLE
1213: , a13 JTF_NUMBER_TABLE
1214: , a14 JTF_VARCHAR2_TABLE_100
1215: , a15 JTF_NUMBER_TABLE
1216: , a16 JTF_VARCHAR2_TABLE_100
1217: , a17 JTF_NUMBER_TABLE
1211: , a11 JTF_VARCHAR2_TABLE_100
1212: , a12 JTF_NUMBER_TABLE
1213: , a13 JTF_NUMBER_TABLE
1214: , a14 JTF_VARCHAR2_TABLE_100
1215: , a15 JTF_NUMBER_TABLE
1216: , a16 JTF_VARCHAR2_TABLE_100
1217: , a17 JTF_NUMBER_TABLE
1218: , a18 JTF_NUMBER_TABLE
1219: , a19 JTF_NUMBER_TABLE
1213: , a13 JTF_NUMBER_TABLE
1214: , a14 JTF_VARCHAR2_TABLE_100
1215: , a15 JTF_NUMBER_TABLE
1216: , a16 JTF_VARCHAR2_TABLE_100
1217: , a17 JTF_NUMBER_TABLE
1218: , a18 JTF_NUMBER_TABLE
1219: , a19 JTF_NUMBER_TABLE
1220: , a20 JTF_NUMBER_TABLE
1221: , a21 JTF_VARCHAR2_TABLE_100
1214: , a14 JTF_VARCHAR2_TABLE_100
1215: , a15 JTF_NUMBER_TABLE
1216: , a16 JTF_VARCHAR2_TABLE_100
1217: , a17 JTF_NUMBER_TABLE
1218: , a18 JTF_NUMBER_TABLE
1219: , a19 JTF_NUMBER_TABLE
1220: , a20 JTF_NUMBER_TABLE
1221: , a21 JTF_VARCHAR2_TABLE_100
1222: , a22 JTF_VARCHAR2_TABLE_100
1215: , a15 JTF_NUMBER_TABLE
1216: , a16 JTF_VARCHAR2_TABLE_100
1217: , a17 JTF_NUMBER_TABLE
1218: , a18 JTF_NUMBER_TABLE
1219: , a19 JTF_NUMBER_TABLE
1220: , a20 JTF_NUMBER_TABLE
1221: , a21 JTF_VARCHAR2_TABLE_100
1222: , a22 JTF_VARCHAR2_TABLE_100
1223: , a23 JTF_VARCHAR2_TABLE_100
1216: , a16 JTF_VARCHAR2_TABLE_100
1217: , a17 JTF_NUMBER_TABLE
1218: , a18 JTF_NUMBER_TABLE
1219: , a19 JTF_NUMBER_TABLE
1220: , a20 JTF_NUMBER_TABLE
1221: , a21 JTF_VARCHAR2_TABLE_100
1222: , a22 JTF_VARCHAR2_TABLE_100
1223: , a23 JTF_VARCHAR2_TABLE_100
1224: , a24 JTF_VARCHAR2_TABLE_300
1222: , a22 JTF_VARCHAR2_TABLE_100
1223: , a23 JTF_VARCHAR2_TABLE_100
1224: , a24 JTF_VARCHAR2_TABLE_300
1225: , a25 JTF_VARCHAR2_TABLE_100
1226: , a26 JTF_NUMBER_TABLE
1227: , a27 JTF_VARCHAR2_TABLE_100
1228: , a28 JTF_VARCHAR2_TABLE_100
1229: , a29 JTF_VARCHAR2_TABLE_300
1230: , a30 JTF_VARCHAR2_TABLE_100
1234: , a34 JTF_VARCHAR2_TABLE_300
1235: , a35 JTF_VARCHAR2_TABLE_100
1236: , a36 JTF_VARCHAR2_TABLE_300
1237: , a37 JTF_VARCHAR2_TABLE_300
1238: , a38 JTF_NUMBER_TABLE
1239: , a39 JTF_VARCHAR2_TABLE_2000
1240: , a40 JTF_VARCHAR2_TABLE_100
1241: , a41 JTF_VARCHAR2_TABLE_300
1242: , a42 JTF_VARCHAR2_TABLE_300
1252: , a52 JTF_VARCHAR2_TABLE_300
1253: , a53 JTF_VARCHAR2_TABLE_300
1254: , a54 JTF_VARCHAR2_TABLE_300
1255: , a55 JTF_VARCHAR2_TABLE_300
1256: , a56 JTF_NUMBER_TABLE
1257: , a57 JTF_NUMBER_TABLE
1258: , a58 JTF_NUMBER_TABLE
1259: , a59 JTF_NUMBER_TABLE
1260: , a60 JTF_NUMBER_TABLE
1253: , a53 JTF_VARCHAR2_TABLE_300
1254: , a54 JTF_VARCHAR2_TABLE_300
1255: , a55 JTF_VARCHAR2_TABLE_300
1256: , a56 JTF_NUMBER_TABLE
1257: , a57 JTF_NUMBER_TABLE
1258: , a58 JTF_NUMBER_TABLE
1259: , a59 JTF_NUMBER_TABLE
1260: , a60 JTF_NUMBER_TABLE
1261: , a61 JTF_NUMBER_TABLE
1254: , a54 JTF_VARCHAR2_TABLE_300
1255: , a55 JTF_VARCHAR2_TABLE_300
1256: , a56 JTF_NUMBER_TABLE
1257: , a57 JTF_NUMBER_TABLE
1258: , a58 JTF_NUMBER_TABLE
1259: , a59 JTF_NUMBER_TABLE
1260: , a60 JTF_NUMBER_TABLE
1261: , a61 JTF_NUMBER_TABLE
1262: , a62 JTF_NUMBER_TABLE
1255: , a55 JTF_VARCHAR2_TABLE_300
1256: , a56 JTF_NUMBER_TABLE
1257: , a57 JTF_NUMBER_TABLE
1258: , a58 JTF_NUMBER_TABLE
1259: , a59 JTF_NUMBER_TABLE
1260: , a60 JTF_NUMBER_TABLE
1261: , a61 JTF_NUMBER_TABLE
1262: , a62 JTF_NUMBER_TABLE
1263: , a63 JTF_NUMBER_TABLE
1256: , a56 JTF_NUMBER_TABLE
1257: , a57 JTF_NUMBER_TABLE
1258: , a58 JTF_NUMBER_TABLE
1259: , a59 JTF_NUMBER_TABLE
1260: , a60 JTF_NUMBER_TABLE
1261: , a61 JTF_NUMBER_TABLE
1262: , a62 JTF_NUMBER_TABLE
1263: , a63 JTF_NUMBER_TABLE
1264: , a64 JTF_NUMBER_TABLE
1257: , a57 JTF_NUMBER_TABLE
1258: , a58 JTF_NUMBER_TABLE
1259: , a59 JTF_NUMBER_TABLE
1260: , a60 JTF_NUMBER_TABLE
1261: , a61 JTF_NUMBER_TABLE
1262: , a62 JTF_NUMBER_TABLE
1263: , a63 JTF_NUMBER_TABLE
1264: , a64 JTF_NUMBER_TABLE
1265: , a65 JTF_NUMBER_TABLE
1258: , a58 JTF_NUMBER_TABLE
1259: , a59 JTF_NUMBER_TABLE
1260: , a60 JTF_NUMBER_TABLE
1261: , a61 JTF_NUMBER_TABLE
1262: , a62 JTF_NUMBER_TABLE
1263: , a63 JTF_NUMBER_TABLE
1264: , a64 JTF_NUMBER_TABLE
1265: , a65 JTF_NUMBER_TABLE
1266: , a66 JTF_VARCHAR2_TABLE_100
1259: , a59 JTF_NUMBER_TABLE
1260: , a60 JTF_NUMBER_TABLE
1261: , a61 JTF_NUMBER_TABLE
1262: , a62 JTF_NUMBER_TABLE
1263: , a63 JTF_NUMBER_TABLE
1264: , a64 JTF_NUMBER_TABLE
1265: , a65 JTF_NUMBER_TABLE
1266: , a66 JTF_VARCHAR2_TABLE_100
1267: , a67 JTF_NUMBER_TABLE
1260: , a60 JTF_NUMBER_TABLE
1261: , a61 JTF_NUMBER_TABLE
1262: , a62 JTF_NUMBER_TABLE
1263: , a63 JTF_NUMBER_TABLE
1264: , a64 JTF_NUMBER_TABLE
1265: , a65 JTF_NUMBER_TABLE
1266: , a66 JTF_VARCHAR2_TABLE_100
1267: , a67 JTF_NUMBER_TABLE
1268: , a68 JTF_NUMBER_TABLE
1261: , a61 JTF_NUMBER_TABLE
1262: , a62 JTF_NUMBER_TABLE
1263: , a63 JTF_NUMBER_TABLE
1264: , a64 JTF_NUMBER_TABLE
1265: , a65 JTF_NUMBER_TABLE
1266: , a66 JTF_VARCHAR2_TABLE_100
1267: , a67 JTF_NUMBER_TABLE
1268: , a68 JTF_NUMBER_TABLE
1269: , a69 JTF_VARCHAR2_TABLE_300
1263: , a63 JTF_NUMBER_TABLE
1264: , a64 JTF_NUMBER_TABLE
1265: , a65 JTF_NUMBER_TABLE
1266: , a66 JTF_VARCHAR2_TABLE_100
1267: , a67 JTF_NUMBER_TABLE
1268: , a68 JTF_NUMBER_TABLE
1269: , a69 JTF_VARCHAR2_TABLE_300
1270: , a70 JTF_VARCHAR2_TABLE_300
1271: ) as
1264: , a64 JTF_NUMBER_TABLE
1265: , a65 JTF_NUMBER_TABLE
1266: , a66 JTF_VARCHAR2_TABLE_100
1267: , a67 JTF_NUMBER_TABLE
1268: , a68 JTF_NUMBER_TABLE
1269: , a69 JTF_VARCHAR2_TABLE_300
1270: , a70 JTF_VARCHAR2_TABLE_300
1271: ) as
1272: ddindx binary_integer; indx binary_integer;
1357: end if;
1358: end rosetta_table_copy_in_p17;
1359: procedure rosetta_table_copy_out_p17(t ozf_offer_pub.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1360: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1361: , a2 out nocopy JTF_NUMBER_TABLE
1362: , a3 out nocopy JTF_NUMBER_TABLE
1363: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1364: , a5 out nocopy JTF_NUMBER_TABLE
1365: , a6 out nocopy JTF_DATE_TABLE
1358: end rosetta_table_copy_in_p17;
1359: procedure rosetta_table_copy_out_p17(t ozf_offer_pub.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1360: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1361: , a2 out nocopy JTF_NUMBER_TABLE
1362: , a3 out nocopy JTF_NUMBER_TABLE
1363: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1364: , a5 out nocopy JTF_NUMBER_TABLE
1365: , a6 out nocopy JTF_DATE_TABLE
1366: , a7 out nocopy JTF_DATE_TABLE
1360: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1361: , a2 out nocopy JTF_NUMBER_TABLE
1362: , a3 out nocopy JTF_NUMBER_TABLE
1363: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1364: , a5 out nocopy JTF_NUMBER_TABLE
1365: , a6 out nocopy JTF_DATE_TABLE
1366: , a7 out nocopy JTF_DATE_TABLE
1367: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1368: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1365: , a6 out nocopy JTF_DATE_TABLE
1366: , a7 out nocopy JTF_DATE_TABLE
1367: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1368: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1369: , a10 out nocopy JTF_NUMBER_TABLE
1370: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1371: , a12 out nocopy JTF_NUMBER_TABLE
1372: , a13 out nocopy JTF_NUMBER_TABLE
1373: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1367: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1368: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1369: , a10 out nocopy JTF_NUMBER_TABLE
1370: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1371: , a12 out nocopy JTF_NUMBER_TABLE
1372: , a13 out nocopy JTF_NUMBER_TABLE
1373: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1374: , a15 out nocopy JTF_NUMBER_TABLE
1375: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1368: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1369: , a10 out nocopy JTF_NUMBER_TABLE
1370: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1371: , a12 out nocopy JTF_NUMBER_TABLE
1372: , a13 out nocopy JTF_NUMBER_TABLE
1373: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1374: , a15 out nocopy JTF_NUMBER_TABLE
1375: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1376: , a17 out nocopy JTF_NUMBER_TABLE
1370: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1371: , a12 out nocopy JTF_NUMBER_TABLE
1372: , a13 out nocopy JTF_NUMBER_TABLE
1373: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1374: , a15 out nocopy JTF_NUMBER_TABLE
1375: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1376: , a17 out nocopy JTF_NUMBER_TABLE
1377: , a18 out nocopy JTF_NUMBER_TABLE
1378: , a19 out nocopy JTF_NUMBER_TABLE
1372: , a13 out nocopy JTF_NUMBER_TABLE
1373: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1374: , a15 out nocopy JTF_NUMBER_TABLE
1375: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1376: , a17 out nocopy JTF_NUMBER_TABLE
1377: , a18 out nocopy JTF_NUMBER_TABLE
1378: , a19 out nocopy JTF_NUMBER_TABLE
1379: , a20 out nocopy JTF_NUMBER_TABLE
1380: , a21 out nocopy JTF_VARCHAR2_TABLE_100
1373: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1374: , a15 out nocopy JTF_NUMBER_TABLE
1375: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1376: , a17 out nocopy JTF_NUMBER_TABLE
1377: , a18 out nocopy JTF_NUMBER_TABLE
1378: , a19 out nocopy JTF_NUMBER_TABLE
1379: , a20 out nocopy JTF_NUMBER_TABLE
1380: , a21 out nocopy JTF_VARCHAR2_TABLE_100
1381: , a22 out nocopy JTF_VARCHAR2_TABLE_100
1374: , a15 out nocopy JTF_NUMBER_TABLE
1375: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1376: , a17 out nocopy JTF_NUMBER_TABLE
1377: , a18 out nocopy JTF_NUMBER_TABLE
1378: , a19 out nocopy JTF_NUMBER_TABLE
1379: , a20 out nocopy JTF_NUMBER_TABLE
1380: , a21 out nocopy JTF_VARCHAR2_TABLE_100
1381: , a22 out nocopy JTF_VARCHAR2_TABLE_100
1382: , a23 out nocopy JTF_VARCHAR2_TABLE_100
1375: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1376: , a17 out nocopy JTF_NUMBER_TABLE
1377: , a18 out nocopy JTF_NUMBER_TABLE
1378: , a19 out nocopy JTF_NUMBER_TABLE
1379: , a20 out nocopy JTF_NUMBER_TABLE
1380: , a21 out nocopy JTF_VARCHAR2_TABLE_100
1381: , a22 out nocopy JTF_VARCHAR2_TABLE_100
1382: , a23 out nocopy JTF_VARCHAR2_TABLE_100
1383: , a24 out nocopy JTF_VARCHAR2_TABLE_300
1381: , a22 out nocopy JTF_VARCHAR2_TABLE_100
1382: , a23 out nocopy JTF_VARCHAR2_TABLE_100
1383: , a24 out nocopy JTF_VARCHAR2_TABLE_300
1384: , a25 out nocopy JTF_VARCHAR2_TABLE_100
1385: , a26 out nocopy JTF_NUMBER_TABLE
1386: , a27 out nocopy JTF_VARCHAR2_TABLE_100
1387: , a28 out nocopy JTF_VARCHAR2_TABLE_100
1388: , a29 out nocopy JTF_VARCHAR2_TABLE_300
1389: , a30 out nocopy JTF_VARCHAR2_TABLE_100
1393: , a34 out nocopy JTF_VARCHAR2_TABLE_300
1394: , a35 out nocopy JTF_VARCHAR2_TABLE_100
1395: , a36 out nocopy JTF_VARCHAR2_TABLE_300
1396: , a37 out nocopy JTF_VARCHAR2_TABLE_300
1397: , a38 out nocopy JTF_NUMBER_TABLE
1398: , a39 out nocopy JTF_VARCHAR2_TABLE_2000
1399: , a40 out nocopy JTF_VARCHAR2_TABLE_100
1400: , a41 out nocopy JTF_VARCHAR2_TABLE_300
1401: , a42 out nocopy JTF_VARCHAR2_TABLE_300
1411: , a52 out nocopy JTF_VARCHAR2_TABLE_300
1412: , a53 out nocopy JTF_VARCHAR2_TABLE_300
1413: , a54 out nocopy JTF_VARCHAR2_TABLE_300
1414: , a55 out nocopy JTF_VARCHAR2_TABLE_300
1415: , a56 out nocopy JTF_NUMBER_TABLE
1416: , a57 out nocopy JTF_NUMBER_TABLE
1417: , a58 out nocopy JTF_NUMBER_TABLE
1418: , a59 out nocopy JTF_NUMBER_TABLE
1419: , a60 out nocopy JTF_NUMBER_TABLE
1412: , a53 out nocopy JTF_VARCHAR2_TABLE_300
1413: , a54 out nocopy JTF_VARCHAR2_TABLE_300
1414: , a55 out nocopy JTF_VARCHAR2_TABLE_300
1415: , a56 out nocopy JTF_NUMBER_TABLE
1416: , a57 out nocopy JTF_NUMBER_TABLE
1417: , a58 out nocopy JTF_NUMBER_TABLE
1418: , a59 out nocopy JTF_NUMBER_TABLE
1419: , a60 out nocopy JTF_NUMBER_TABLE
1420: , a61 out nocopy JTF_NUMBER_TABLE
1413: , a54 out nocopy JTF_VARCHAR2_TABLE_300
1414: , a55 out nocopy JTF_VARCHAR2_TABLE_300
1415: , a56 out nocopy JTF_NUMBER_TABLE
1416: , a57 out nocopy JTF_NUMBER_TABLE
1417: , a58 out nocopy JTF_NUMBER_TABLE
1418: , a59 out nocopy JTF_NUMBER_TABLE
1419: , a60 out nocopy JTF_NUMBER_TABLE
1420: , a61 out nocopy JTF_NUMBER_TABLE
1421: , a62 out nocopy JTF_NUMBER_TABLE
1414: , a55 out nocopy JTF_VARCHAR2_TABLE_300
1415: , a56 out nocopy JTF_NUMBER_TABLE
1416: , a57 out nocopy JTF_NUMBER_TABLE
1417: , a58 out nocopy JTF_NUMBER_TABLE
1418: , a59 out nocopy JTF_NUMBER_TABLE
1419: , a60 out nocopy JTF_NUMBER_TABLE
1420: , a61 out nocopy JTF_NUMBER_TABLE
1421: , a62 out nocopy JTF_NUMBER_TABLE
1422: , a63 out nocopy JTF_NUMBER_TABLE
1415: , a56 out nocopy JTF_NUMBER_TABLE
1416: , a57 out nocopy JTF_NUMBER_TABLE
1417: , a58 out nocopy JTF_NUMBER_TABLE
1418: , a59 out nocopy JTF_NUMBER_TABLE
1419: , a60 out nocopy JTF_NUMBER_TABLE
1420: , a61 out nocopy JTF_NUMBER_TABLE
1421: , a62 out nocopy JTF_NUMBER_TABLE
1422: , a63 out nocopy JTF_NUMBER_TABLE
1423: , a64 out nocopy JTF_NUMBER_TABLE
1416: , a57 out nocopy JTF_NUMBER_TABLE
1417: , a58 out nocopy JTF_NUMBER_TABLE
1418: , a59 out nocopy JTF_NUMBER_TABLE
1419: , a60 out nocopy JTF_NUMBER_TABLE
1420: , a61 out nocopy JTF_NUMBER_TABLE
1421: , a62 out nocopy JTF_NUMBER_TABLE
1422: , a63 out nocopy JTF_NUMBER_TABLE
1423: , a64 out nocopy JTF_NUMBER_TABLE
1424: , a65 out nocopy JTF_NUMBER_TABLE
1417: , a58 out nocopy JTF_NUMBER_TABLE
1418: , a59 out nocopy JTF_NUMBER_TABLE
1419: , a60 out nocopy JTF_NUMBER_TABLE
1420: , a61 out nocopy JTF_NUMBER_TABLE
1421: , a62 out nocopy JTF_NUMBER_TABLE
1422: , a63 out nocopy JTF_NUMBER_TABLE
1423: , a64 out nocopy JTF_NUMBER_TABLE
1424: , a65 out nocopy JTF_NUMBER_TABLE
1425: , a66 out nocopy JTF_VARCHAR2_TABLE_100
1418: , a59 out nocopy JTF_NUMBER_TABLE
1419: , a60 out nocopy JTF_NUMBER_TABLE
1420: , a61 out nocopy JTF_NUMBER_TABLE
1421: , a62 out nocopy JTF_NUMBER_TABLE
1422: , a63 out nocopy JTF_NUMBER_TABLE
1423: , a64 out nocopy JTF_NUMBER_TABLE
1424: , a65 out nocopy JTF_NUMBER_TABLE
1425: , a66 out nocopy JTF_VARCHAR2_TABLE_100
1426: , a67 out nocopy JTF_NUMBER_TABLE
1419: , a60 out nocopy JTF_NUMBER_TABLE
1420: , a61 out nocopy JTF_NUMBER_TABLE
1421: , a62 out nocopy JTF_NUMBER_TABLE
1422: , a63 out nocopy JTF_NUMBER_TABLE
1423: , a64 out nocopy JTF_NUMBER_TABLE
1424: , a65 out nocopy JTF_NUMBER_TABLE
1425: , a66 out nocopy JTF_VARCHAR2_TABLE_100
1426: , a67 out nocopy JTF_NUMBER_TABLE
1427: , a68 out nocopy JTF_NUMBER_TABLE
1420: , a61 out nocopy JTF_NUMBER_TABLE
1421: , a62 out nocopy JTF_NUMBER_TABLE
1422: , a63 out nocopy JTF_NUMBER_TABLE
1423: , a64 out nocopy JTF_NUMBER_TABLE
1424: , a65 out nocopy JTF_NUMBER_TABLE
1425: , a66 out nocopy JTF_VARCHAR2_TABLE_100
1426: , a67 out nocopy JTF_NUMBER_TABLE
1427: , a68 out nocopy JTF_NUMBER_TABLE
1428: , a69 out nocopy JTF_VARCHAR2_TABLE_300
1422: , a63 out nocopy JTF_NUMBER_TABLE
1423: , a64 out nocopy JTF_NUMBER_TABLE
1424: , a65 out nocopy JTF_NUMBER_TABLE
1425: , a66 out nocopy JTF_VARCHAR2_TABLE_100
1426: , a67 out nocopy JTF_NUMBER_TABLE
1427: , a68 out nocopy JTF_NUMBER_TABLE
1428: , a69 out nocopy JTF_VARCHAR2_TABLE_300
1429: , a70 out nocopy JTF_VARCHAR2_TABLE_300
1430: ) as
1423: , a64 out nocopy JTF_NUMBER_TABLE
1424: , a65 out nocopy JTF_NUMBER_TABLE
1425: , a66 out nocopy JTF_VARCHAR2_TABLE_100
1426: , a67 out nocopy JTF_NUMBER_TABLE
1427: , a68 out nocopy JTF_NUMBER_TABLE
1428: , a69 out nocopy JTF_VARCHAR2_TABLE_300
1429: , a70 out nocopy JTF_VARCHAR2_TABLE_300
1430: ) as
1431: ddindx binary_integer; indx binary_integer;
1432: begin
1433: if t is null or t.count = 0 then
1434: a0 := JTF_VARCHAR2_TABLE_100();
1435: a1 := JTF_VARCHAR2_TABLE_100();
1436: a2 := JTF_NUMBER_TABLE();
1437: a3 := JTF_NUMBER_TABLE();
1438: a4 := JTF_VARCHAR2_TABLE_100();
1439: a5 := JTF_NUMBER_TABLE();
1440: a6 := JTF_DATE_TABLE();
1433: if t is null or t.count = 0 then
1434: a0 := JTF_VARCHAR2_TABLE_100();
1435: a1 := JTF_VARCHAR2_TABLE_100();
1436: a2 := JTF_NUMBER_TABLE();
1437: a3 := JTF_NUMBER_TABLE();
1438: a4 := JTF_VARCHAR2_TABLE_100();
1439: a5 := JTF_NUMBER_TABLE();
1440: a6 := JTF_DATE_TABLE();
1441: a7 := JTF_DATE_TABLE();
1435: a1 := JTF_VARCHAR2_TABLE_100();
1436: a2 := JTF_NUMBER_TABLE();
1437: a3 := JTF_NUMBER_TABLE();
1438: a4 := JTF_VARCHAR2_TABLE_100();
1439: a5 := JTF_NUMBER_TABLE();
1440: a6 := JTF_DATE_TABLE();
1441: a7 := JTF_DATE_TABLE();
1442: a8 := JTF_VARCHAR2_TABLE_100();
1443: a9 := JTF_VARCHAR2_TABLE_100();
1440: a6 := JTF_DATE_TABLE();
1441: a7 := JTF_DATE_TABLE();
1442: a8 := JTF_VARCHAR2_TABLE_100();
1443: a9 := JTF_VARCHAR2_TABLE_100();
1444: a10 := JTF_NUMBER_TABLE();
1445: a11 := JTF_VARCHAR2_TABLE_100();
1446: a12 := JTF_NUMBER_TABLE();
1447: a13 := JTF_NUMBER_TABLE();
1448: a14 := JTF_VARCHAR2_TABLE_100();
1442: a8 := JTF_VARCHAR2_TABLE_100();
1443: a9 := JTF_VARCHAR2_TABLE_100();
1444: a10 := JTF_NUMBER_TABLE();
1445: a11 := JTF_VARCHAR2_TABLE_100();
1446: a12 := JTF_NUMBER_TABLE();
1447: a13 := JTF_NUMBER_TABLE();
1448: a14 := JTF_VARCHAR2_TABLE_100();
1449: a15 := JTF_NUMBER_TABLE();
1450: a16 := JTF_VARCHAR2_TABLE_100();
1443: a9 := JTF_VARCHAR2_TABLE_100();
1444: a10 := JTF_NUMBER_TABLE();
1445: a11 := JTF_VARCHAR2_TABLE_100();
1446: a12 := JTF_NUMBER_TABLE();
1447: a13 := JTF_NUMBER_TABLE();
1448: a14 := JTF_VARCHAR2_TABLE_100();
1449: a15 := JTF_NUMBER_TABLE();
1450: a16 := JTF_VARCHAR2_TABLE_100();
1451: a17 := JTF_NUMBER_TABLE();
1445: a11 := JTF_VARCHAR2_TABLE_100();
1446: a12 := JTF_NUMBER_TABLE();
1447: a13 := JTF_NUMBER_TABLE();
1448: a14 := JTF_VARCHAR2_TABLE_100();
1449: a15 := JTF_NUMBER_TABLE();
1450: a16 := JTF_VARCHAR2_TABLE_100();
1451: a17 := JTF_NUMBER_TABLE();
1452: a18 := JTF_NUMBER_TABLE();
1453: a19 := JTF_NUMBER_TABLE();
1447: a13 := JTF_NUMBER_TABLE();
1448: a14 := JTF_VARCHAR2_TABLE_100();
1449: a15 := JTF_NUMBER_TABLE();
1450: a16 := JTF_VARCHAR2_TABLE_100();
1451: a17 := JTF_NUMBER_TABLE();
1452: a18 := JTF_NUMBER_TABLE();
1453: a19 := JTF_NUMBER_TABLE();
1454: a20 := JTF_NUMBER_TABLE();
1455: a21 := JTF_VARCHAR2_TABLE_100();
1448: a14 := JTF_VARCHAR2_TABLE_100();
1449: a15 := JTF_NUMBER_TABLE();
1450: a16 := JTF_VARCHAR2_TABLE_100();
1451: a17 := JTF_NUMBER_TABLE();
1452: a18 := JTF_NUMBER_TABLE();
1453: a19 := JTF_NUMBER_TABLE();
1454: a20 := JTF_NUMBER_TABLE();
1455: a21 := JTF_VARCHAR2_TABLE_100();
1456: a22 := JTF_VARCHAR2_TABLE_100();
1449: a15 := JTF_NUMBER_TABLE();
1450: a16 := JTF_VARCHAR2_TABLE_100();
1451: a17 := JTF_NUMBER_TABLE();
1452: a18 := JTF_NUMBER_TABLE();
1453: a19 := JTF_NUMBER_TABLE();
1454: a20 := JTF_NUMBER_TABLE();
1455: a21 := JTF_VARCHAR2_TABLE_100();
1456: a22 := JTF_VARCHAR2_TABLE_100();
1457: a23 := JTF_VARCHAR2_TABLE_100();
1450: a16 := JTF_VARCHAR2_TABLE_100();
1451: a17 := JTF_NUMBER_TABLE();
1452: a18 := JTF_NUMBER_TABLE();
1453: a19 := JTF_NUMBER_TABLE();
1454: a20 := JTF_NUMBER_TABLE();
1455: a21 := JTF_VARCHAR2_TABLE_100();
1456: a22 := JTF_VARCHAR2_TABLE_100();
1457: a23 := JTF_VARCHAR2_TABLE_100();
1458: a24 := JTF_VARCHAR2_TABLE_300();
1456: a22 := JTF_VARCHAR2_TABLE_100();
1457: a23 := JTF_VARCHAR2_TABLE_100();
1458: a24 := JTF_VARCHAR2_TABLE_300();
1459: a25 := JTF_VARCHAR2_TABLE_100();
1460: a26 := JTF_NUMBER_TABLE();
1461: a27 := JTF_VARCHAR2_TABLE_100();
1462: a28 := JTF_VARCHAR2_TABLE_100();
1463: a29 := JTF_VARCHAR2_TABLE_300();
1464: a30 := JTF_VARCHAR2_TABLE_100();
1468: a34 := JTF_VARCHAR2_TABLE_300();
1469: a35 := JTF_VARCHAR2_TABLE_100();
1470: a36 := JTF_VARCHAR2_TABLE_300();
1471: a37 := JTF_VARCHAR2_TABLE_300();
1472: a38 := JTF_NUMBER_TABLE();
1473: a39 := JTF_VARCHAR2_TABLE_2000();
1474: a40 := JTF_VARCHAR2_TABLE_100();
1475: a41 := JTF_VARCHAR2_TABLE_300();
1476: a42 := JTF_VARCHAR2_TABLE_300();
1486: a52 := JTF_VARCHAR2_TABLE_300();
1487: a53 := JTF_VARCHAR2_TABLE_300();
1488: a54 := JTF_VARCHAR2_TABLE_300();
1489: a55 := JTF_VARCHAR2_TABLE_300();
1490: a56 := JTF_NUMBER_TABLE();
1491: a57 := JTF_NUMBER_TABLE();
1492: a58 := JTF_NUMBER_TABLE();
1493: a59 := JTF_NUMBER_TABLE();
1494: a60 := JTF_NUMBER_TABLE();
1487: a53 := JTF_VARCHAR2_TABLE_300();
1488: a54 := JTF_VARCHAR2_TABLE_300();
1489: a55 := JTF_VARCHAR2_TABLE_300();
1490: a56 := JTF_NUMBER_TABLE();
1491: a57 := JTF_NUMBER_TABLE();
1492: a58 := JTF_NUMBER_TABLE();
1493: a59 := JTF_NUMBER_TABLE();
1494: a60 := JTF_NUMBER_TABLE();
1495: a61 := JTF_NUMBER_TABLE();
1488: a54 := JTF_VARCHAR2_TABLE_300();
1489: a55 := JTF_VARCHAR2_TABLE_300();
1490: a56 := JTF_NUMBER_TABLE();
1491: a57 := JTF_NUMBER_TABLE();
1492: a58 := JTF_NUMBER_TABLE();
1493: a59 := JTF_NUMBER_TABLE();
1494: a60 := JTF_NUMBER_TABLE();
1495: a61 := JTF_NUMBER_TABLE();
1496: a62 := JTF_NUMBER_TABLE();
1489: a55 := JTF_VARCHAR2_TABLE_300();
1490: a56 := JTF_NUMBER_TABLE();
1491: a57 := JTF_NUMBER_TABLE();
1492: a58 := JTF_NUMBER_TABLE();
1493: a59 := JTF_NUMBER_TABLE();
1494: a60 := JTF_NUMBER_TABLE();
1495: a61 := JTF_NUMBER_TABLE();
1496: a62 := JTF_NUMBER_TABLE();
1497: a63 := JTF_NUMBER_TABLE();
1490: a56 := JTF_NUMBER_TABLE();
1491: a57 := JTF_NUMBER_TABLE();
1492: a58 := JTF_NUMBER_TABLE();
1493: a59 := JTF_NUMBER_TABLE();
1494: a60 := JTF_NUMBER_TABLE();
1495: a61 := JTF_NUMBER_TABLE();
1496: a62 := JTF_NUMBER_TABLE();
1497: a63 := JTF_NUMBER_TABLE();
1498: a64 := JTF_NUMBER_TABLE();
1491: a57 := JTF_NUMBER_TABLE();
1492: a58 := JTF_NUMBER_TABLE();
1493: a59 := JTF_NUMBER_TABLE();
1494: a60 := JTF_NUMBER_TABLE();
1495: a61 := JTF_NUMBER_TABLE();
1496: a62 := JTF_NUMBER_TABLE();
1497: a63 := JTF_NUMBER_TABLE();
1498: a64 := JTF_NUMBER_TABLE();
1499: a65 := JTF_NUMBER_TABLE();
1492: a58 := JTF_NUMBER_TABLE();
1493: a59 := JTF_NUMBER_TABLE();
1494: a60 := JTF_NUMBER_TABLE();
1495: a61 := JTF_NUMBER_TABLE();
1496: a62 := JTF_NUMBER_TABLE();
1497: a63 := JTF_NUMBER_TABLE();
1498: a64 := JTF_NUMBER_TABLE();
1499: a65 := JTF_NUMBER_TABLE();
1500: a66 := JTF_VARCHAR2_TABLE_100();
1493: a59 := JTF_NUMBER_TABLE();
1494: a60 := JTF_NUMBER_TABLE();
1495: a61 := JTF_NUMBER_TABLE();
1496: a62 := JTF_NUMBER_TABLE();
1497: a63 := JTF_NUMBER_TABLE();
1498: a64 := JTF_NUMBER_TABLE();
1499: a65 := JTF_NUMBER_TABLE();
1500: a66 := JTF_VARCHAR2_TABLE_100();
1501: a67 := JTF_NUMBER_TABLE();
1494: a60 := JTF_NUMBER_TABLE();
1495: a61 := JTF_NUMBER_TABLE();
1496: a62 := JTF_NUMBER_TABLE();
1497: a63 := JTF_NUMBER_TABLE();
1498: a64 := JTF_NUMBER_TABLE();
1499: a65 := JTF_NUMBER_TABLE();
1500: a66 := JTF_VARCHAR2_TABLE_100();
1501: a67 := JTF_NUMBER_TABLE();
1502: a68 := JTF_NUMBER_TABLE();
1495: a61 := JTF_NUMBER_TABLE();
1496: a62 := JTF_NUMBER_TABLE();
1497: a63 := JTF_NUMBER_TABLE();
1498: a64 := JTF_NUMBER_TABLE();
1499: a65 := JTF_NUMBER_TABLE();
1500: a66 := JTF_VARCHAR2_TABLE_100();
1501: a67 := JTF_NUMBER_TABLE();
1502: a68 := JTF_NUMBER_TABLE();
1503: a69 := JTF_VARCHAR2_TABLE_300();
1497: a63 := JTF_NUMBER_TABLE();
1498: a64 := JTF_NUMBER_TABLE();
1499: a65 := JTF_NUMBER_TABLE();
1500: a66 := JTF_VARCHAR2_TABLE_100();
1501: a67 := JTF_NUMBER_TABLE();
1502: a68 := JTF_NUMBER_TABLE();
1503: a69 := JTF_VARCHAR2_TABLE_300();
1504: a70 := JTF_VARCHAR2_TABLE_300();
1505: else
1498: a64 := JTF_NUMBER_TABLE();
1499: a65 := JTF_NUMBER_TABLE();
1500: a66 := JTF_VARCHAR2_TABLE_100();
1501: a67 := JTF_NUMBER_TABLE();
1502: a68 := JTF_NUMBER_TABLE();
1503: a69 := JTF_VARCHAR2_TABLE_300();
1504: a70 := JTF_VARCHAR2_TABLE_300();
1505: else
1506: a0 := JTF_VARCHAR2_TABLE_100();
1504: a70 := JTF_VARCHAR2_TABLE_300();
1505: else
1506: a0 := JTF_VARCHAR2_TABLE_100();
1507: a1 := JTF_VARCHAR2_TABLE_100();
1508: a2 := JTF_NUMBER_TABLE();
1509: a3 := JTF_NUMBER_TABLE();
1510: a4 := JTF_VARCHAR2_TABLE_100();
1511: a5 := JTF_NUMBER_TABLE();
1512: a6 := JTF_DATE_TABLE();
1505: else
1506: a0 := JTF_VARCHAR2_TABLE_100();
1507: a1 := JTF_VARCHAR2_TABLE_100();
1508: a2 := JTF_NUMBER_TABLE();
1509: a3 := JTF_NUMBER_TABLE();
1510: a4 := JTF_VARCHAR2_TABLE_100();
1511: a5 := JTF_NUMBER_TABLE();
1512: a6 := JTF_DATE_TABLE();
1513: a7 := JTF_DATE_TABLE();
1507: a1 := JTF_VARCHAR2_TABLE_100();
1508: a2 := JTF_NUMBER_TABLE();
1509: a3 := JTF_NUMBER_TABLE();
1510: a4 := JTF_VARCHAR2_TABLE_100();
1511: a5 := JTF_NUMBER_TABLE();
1512: a6 := JTF_DATE_TABLE();
1513: a7 := JTF_DATE_TABLE();
1514: a8 := JTF_VARCHAR2_TABLE_100();
1515: a9 := JTF_VARCHAR2_TABLE_100();
1512: a6 := JTF_DATE_TABLE();
1513: a7 := JTF_DATE_TABLE();
1514: a8 := JTF_VARCHAR2_TABLE_100();
1515: a9 := JTF_VARCHAR2_TABLE_100();
1516: a10 := JTF_NUMBER_TABLE();
1517: a11 := JTF_VARCHAR2_TABLE_100();
1518: a12 := JTF_NUMBER_TABLE();
1519: a13 := JTF_NUMBER_TABLE();
1520: a14 := JTF_VARCHAR2_TABLE_100();
1514: a8 := JTF_VARCHAR2_TABLE_100();
1515: a9 := JTF_VARCHAR2_TABLE_100();
1516: a10 := JTF_NUMBER_TABLE();
1517: a11 := JTF_VARCHAR2_TABLE_100();
1518: a12 := JTF_NUMBER_TABLE();
1519: a13 := JTF_NUMBER_TABLE();
1520: a14 := JTF_VARCHAR2_TABLE_100();
1521: a15 := JTF_NUMBER_TABLE();
1522: a16 := JTF_VARCHAR2_TABLE_100();
1515: a9 := JTF_VARCHAR2_TABLE_100();
1516: a10 := JTF_NUMBER_TABLE();
1517: a11 := JTF_VARCHAR2_TABLE_100();
1518: a12 := JTF_NUMBER_TABLE();
1519: a13 := JTF_NUMBER_TABLE();
1520: a14 := JTF_VARCHAR2_TABLE_100();
1521: a15 := JTF_NUMBER_TABLE();
1522: a16 := JTF_VARCHAR2_TABLE_100();
1523: a17 := JTF_NUMBER_TABLE();
1517: a11 := JTF_VARCHAR2_TABLE_100();
1518: a12 := JTF_NUMBER_TABLE();
1519: a13 := JTF_NUMBER_TABLE();
1520: a14 := JTF_VARCHAR2_TABLE_100();
1521: a15 := JTF_NUMBER_TABLE();
1522: a16 := JTF_VARCHAR2_TABLE_100();
1523: a17 := JTF_NUMBER_TABLE();
1524: a18 := JTF_NUMBER_TABLE();
1525: a19 := JTF_NUMBER_TABLE();
1519: a13 := JTF_NUMBER_TABLE();
1520: a14 := JTF_VARCHAR2_TABLE_100();
1521: a15 := JTF_NUMBER_TABLE();
1522: a16 := JTF_VARCHAR2_TABLE_100();
1523: a17 := JTF_NUMBER_TABLE();
1524: a18 := JTF_NUMBER_TABLE();
1525: a19 := JTF_NUMBER_TABLE();
1526: a20 := JTF_NUMBER_TABLE();
1527: a21 := JTF_VARCHAR2_TABLE_100();
1520: a14 := JTF_VARCHAR2_TABLE_100();
1521: a15 := JTF_NUMBER_TABLE();
1522: a16 := JTF_VARCHAR2_TABLE_100();
1523: a17 := JTF_NUMBER_TABLE();
1524: a18 := JTF_NUMBER_TABLE();
1525: a19 := JTF_NUMBER_TABLE();
1526: a20 := JTF_NUMBER_TABLE();
1527: a21 := JTF_VARCHAR2_TABLE_100();
1528: a22 := JTF_VARCHAR2_TABLE_100();
1521: a15 := JTF_NUMBER_TABLE();
1522: a16 := JTF_VARCHAR2_TABLE_100();
1523: a17 := JTF_NUMBER_TABLE();
1524: a18 := JTF_NUMBER_TABLE();
1525: a19 := JTF_NUMBER_TABLE();
1526: a20 := JTF_NUMBER_TABLE();
1527: a21 := JTF_VARCHAR2_TABLE_100();
1528: a22 := JTF_VARCHAR2_TABLE_100();
1529: a23 := JTF_VARCHAR2_TABLE_100();
1522: a16 := JTF_VARCHAR2_TABLE_100();
1523: a17 := JTF_NUMBER_TABLE();
1524: a18 := JTF_NUMBER_TABLE();
1525: a19 := JTF_NUMBER_TABLE();
1526: a20 := JTF_NUMBER_TABLE();
1527: a21 := JTF_VARCHAR2_TABLE_100();
1528: a22 := JTF_VARCHAR2_TABLE_100();
1529: a23 := JTF_VARCHAR2_TABLE_100();
1530: a24 := JTF_VARCHAR2_TABLE_300();
1528: a22 := JTF_VARCHAR2_TABLE_100();
1529: a23 := JTF_VARCHAR2_TABLE_100();
1530: a24 := JTF_VARCHAR2_TABLE_300();
1531: a25 := JTF_VARCHAR2_TABLE_100();
1532: a26 := JTF_NUMBER_TABLE();
1533: a27 := JTF_VARCHAR2_TABLE_100();
1534: a28 := JTF_VARCHAR2_TABLE_100();
1535: a29 := JTF_VARCHAR2_TABLE_300();
1536: a30 := JTF_VARCHAR2_TABLE_100();
1540: a34 := JTF_VARCHAR2_TABLE_300();
1541: a35 := JTF_VARCHAR2_TABLE_100();
1542: a36 := JTF_VARCHAR2_TABLE_300();
1543: a37 := JTF_VARCHAR2_TABLE_300();
1544: a38 := JTF_NUMBER_TABLE();
1545: a39 := JTF_VARCHAR2_TABLE_2000();
1546: a40 := JTF_VARCHAR2_TABLE_100();
1547: a41 := JTF_VARCHAR2_TABLE_300();
1548: a42 := JTF_VARCHAR2_TABLE_300();
1558: a52 := JTF_VARCHAR2_TABLE_300();
1559: a53 := JTF_VARCHAR2_TABLE_300();
1560: a54 := JTF_VARCHAR2_TABLE_300();
1561: a55 := JTF_VARCHAR2_TABLE_300();
1562: a56 := JTF_NUMBER_TABLE();
1563: a57 := JTF_NUMBER_TABLE();
1564: a58 := JTF_NUMBER_TABLE();
1565: a59 := JTF_NUMBER_TABLE();
1566: a60 := JTF_NUMBER_TABLE();
1559: a53 := JTF_VARCHAR2_TABLE_300();
1560: a54 := JTF_VARCHAR2_TABLE_300();
1561: a55 := JTF_VARCHAR2_TABLE_300();
1562: a56 := JTF_NUMBER_TABLE();
1563: a57 := JTF_NUMBER_TABLE();
1564: a58 := JTF_NUMBER_TABLE();
1565: a59 := JTF_NUMBER_TABLE();
1566: a60 := JTF_NUMBER_TABLE();
1567: a61 := JTF_NUMBER_TABLE();
1560: a54 := JTF_VARCHAR2_TABLE_300();
1561: a55 := JTF_VARCHAR2_TABLE_300();
1562: a56 := JTF_NUMBER_TABLE();
1563: a57 := JTF_NUMBER_TABLE();
1564: a58 := JTF_NUMBER_TABLE();
1565: a59 := JTF_NUMBER_TABLE();
1566: a60 := JTF_NUMBER_TABLE();
1567: a61 := JTF_NUMBER_TABLE();
1568: a62 := JTF_NUMBER_TABLE();
1561: a55 := JTF_VARCHAR2_TABLE_300();
1562: a56 := JTF_NUMBER_TABLE();
1563: a57 := JTF_NUMBER_TABLE();
1564: a58 := JTF_NUMBER_TABLE();
1565: a59 := JTF_NUMBER_TABLE();
1566: a60 := JTF_NUMBER_TABLE();
1567: a61 := JTF_NUMBER_TABLE();
1568: a62 := JTF_NUMBER_TABLE();
1569: a63 := JTF_NUMBER_TABLE();
1562: a56 := JTF_NUMBER_TABLE();
1563: a57 := JTF_NUMBER_TABLE();
1564: a58 := JTF_NUMBER_TABLE();
1565: a59 := JTF_NUMBER_TABLE();
1566: a60 := JTF_NUMBER_TABLE();
1567: a61 := JTF_NUMBER_TABLE();
1568: a62 := JTF_NUMBER_TABLE();
1569: a63 := JTF_NUMBER_TABLE();
1570: a64 := JTF_NUMBER_TABLE();
1563: a57 := JTF_NUMBER_TABLE();
1564: a58 := JTF_NUMBER_TABLE();
1565: a59 := JTF_NUMBER_TABLE();
1566: a60 := JTF_NUMBER_TABLE();
1567: a61 := JTF_NUMBER_TABLE();
1568: a62 := JTF_NUMBER_TABLE();
1569: a63 := JTF_NUMBER_TABLE();
1570: a64 := JTF_NUMBER_TABLE();
1571: a65 := JTF_NUMBER_TABLE();
1564: a58 := JTF_NUMBER_TABLE();
1565: a59 := JTF_NUMBER_TABLE();
1566: a60 := JTF_NUMBER_TABLE();
1567: a61 := JTF_NUMBER_TABLE();
1568: a62 := JTF_NUMBER_TABLE();
1569: a63 := JTF_NUMBER_TABLE();
1570: a64 := JTF_NUMBER_TABLE();
1571: a65 := JTF_NUMBER_TABLE();
1572: a66 := JTF_VARCHAR2_TABLE_100();
1565: a59 := JTF_NUMBER_TABLE();
1566: a60 := JTF_NUMBER_TABLE();
1567: a61 := JTF_NUMBER_TABLE();
1568: a62 := JTF_NUMBER_TABLE();
1569: a63 := JTF_NUMBER_TABLE();
1570: a64 := JTF_NUMBER_TABLE();
1571: a65 := JTF_NUMBER_TABLE();
1572: a66 := JTF_VARCHAR2_TABLE_100();
1573: a67 := JTF_NUMBER_TABLE();
1566: a60 := JTF_NUMBER_TABLE();
1567: a61 := JTF_NUMBER_TABLE();
1568: a62 := JTF_NUMBER_TABLE();
1569: a63 := JTF_NUMBER_TABLE();
1570: a64 := JTF_NUMBER_TABLE();
1571: a65 := JTF_NUMBER_TABLE();
1572: a66 := JTF_VARCHAR2_TABLE_100();
1573: a67 := JTF_NUMBER_TABLE();
1574: a68 := JTF_NUMBER_TABLE();
1567: a61 := JTF_NUMBER_TABLE();
1568: a62 := JTF_NUMBER_TABLE();
1569: a63 := JTF_NUMBER_TABLE();
1570: a64 := JTF_NUMBER_TABLE();
1571: a65 := JTF_NUMBER_TABLE();
1572: a66 := JTF_VARCHAR2_TABLE_100();
1573: a67 := JTF_NUMBER_TABLE();
1574: a68 := JTF_NUMBER_TABLE();
1575: a69 := JTF_VARCHAR2_TABLE_300();
1569: a63 := JTF_NUMBER_TABLE();
1570: a64 := JTF_NUMBER_TABLE();
1571: a65 := JTF_NUMBER_TABLE();
1572: a66 := JTF_VARCHAR2_TABLE_100();
1573: a67 := JTF_NUMBER_TABLE();
1574: a68 := JTF_NUMBER_TABLE();
1575: a69 := JTF_VARCHAR2_TABLE_300();
1576: a70 := JTF_VARCHAR2_TABLE_300();
1577: if t.count > 0 then
1570: a64 := JTF_NUMBER_TABLE();
1571: a65 := JTF_NUMBER_TABLE();
1572: a66 := JTF_VARCHAR2_TABLE_100();
1573: a67 := JTF_NUMBER_TABLE();
1574: a68 := JTF_NUMBER_TABLE();
1575: a69 := JTF_VARCHAR2_TABLE_300();
1576: a70 := JTF_VARCHAR2_TABLE_300();
1577: if t.count > 0 then
1578: a0.extend(t.count);
1734: , a1 JTF_VARCHAR2_TABLE_100
1735: , a2 JTF_VARCHAR2_TABLE_300
1736: , a3 JTF_VARCHAR2_TABLE_300
1737: , a4 JTF_VARCHAR2_TABLE_100
1738: , a5 JTF_NUMBER_TABLE
1739: , a6 JTF_NUMBER_TABLE
1740: , a7 JTF_NUMBER_TABLE
1741: , a8 JTF_NUMBER_TABLE
1742: , a9 JTF_DATE_TABLE
1735: , a2 JTF_VARCHAR2_TABLE_300
1736: , a3 JTF_VARCHAR2_TABLE_300
1737: , a4 JTF_VARCHAR2_TABLE_100
1738: , a5 JTF_NUMBER_TABLE
1739: , a6 JTF_NUMBER_TABLE
1740: , a7 JTF_NUMBER_TABLE
1741: , a8 JTF_NUMBER_TABLE
1742: , a9 JTF_DATE_TABLE
1743: , a10 JTF_DATE_TABLE
1736: , a3 JTF_VARCHAR2_TABLE_300
1737: , a4 JTF_VARCHAR2_TABLE_100
1738: , a5 JTF_NUMBER_TABLE
1739: , a6 JTF_NUMBER_TABLE
1740: , a7 JTF_NUMBER_TABLE
1741: , a8 JTF_NUMBER_TABLE
1742: , a9 JTF_DATE_TABLE
1743: , a10 JTF_DATE_TABLE
1744: , a11 JTF_NUMBER_TABLE
1737: , a4 JTF_VARCHAR2_TABLE_100
1738: , a5 JTF_NUMBER_TABLE
1739: , a6 JTF_NUMBER_TABLE
1740: , a7 JTF_NUMBER_TABLE
1741: , a8 JTF_NUMBER_TABLE
1742: , a9 JTF_DATE_TABLE
1743: , a10 JTF_DATE_TABLE
1744: , a11 JTF_NUMBER_TABLE
1745: , a12 JTF_VARCHAR2_TABLE_100
1740: , a7 JTF_NUMBER_TABLE
1741: , a8 JTF_NUMBER_TABLE
1742: , a9 JTF_DATE_TABLE
1743: , a10 JTF_DATE_TABLE
1744: , a11 JTF_NUMBER_TABLE
1745: , a12 JTF_VARCHAR2_TABLE_100
1746: , a13 JTF_VARCHAR2_TABLE_100
1747: , a14 JTF_VARCHAR2_TABLE_300
1748: , a15 JTF_VARCHAR2_TABLE_300
1809: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1810: , a2 out nocopy JTF_VARCHAR2_TABLE_300
1811: , a3 out nocopy JTF_VARCHAR2_TABLE_300
1812: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1813: , a5 out nocopy JTF_NUMBER_TABLE
1814: , a6 out nocopy JTF_NUMBER_TABLE
1815: , a7 out nocopy JTF_NUMBER_TABLE
1816: , a8 out nocopy JTF_NUMBER_TABLE
1817: , a9 out nocopy JTF_DATE_TABLE
1810: , a2 out nocopy JTF_VARCHAR2_TABLE_300
1811: , a3 out nocopy JTF_VARCHAR2_TABLE_300
1812: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1813: , a5 out nocopy JTF_NUMBER_TABLE
1814: , a6 out nocopy JTF_NUMBER_TABLE
1815: , a7 out nocopy JTF_NUMBER_TABLE
1816: , a8 out nocopy JTF_NUMBER_TABLE
1817: , a9 out nocopy JTF_DATE_TABLE
1818: , a10 out nocopy JTF_DATE_TABLE
1811: , a3 out nocopy JTF_VARCHAR2_TABLE_300
1812: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1813: , a5 out nocopy JTF_NUMBER_TABLE
1814: , a6 out nocopy JTF_NUMBER_TABLE
1815: , a7 out nocopy JTF_NUMBER_TABLE
1816: , a8 out nocopy JTF_NUMBER_TABLE
1817: , a9 out nocopy JTF_DATE_TABLE
1818: , a10 out nocopy JTF_DATE_TABLE
1819: , a11 out nocopy JTF_NUMBER_TABLE
1812: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1813: , a5 out nocopy JTF_NUMBER_TABLE
1814: , a6 out nocopy JTF_NUMBER_TABLE
1815: , a7 out nocopy JTF_NUMBER_TABLE
1816: , a8 out nocopy JTF_NUMBER_TABLE
1817: , a9 out nocopy JTF_DATE_TABLE
1818: , a10 out nocopy JTF_DATE_TABLE
1819: , a11 out nocopy JTF_NUMBER_TABLE
1820: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1815: , a7 out nocopy JTF_NUMBER_TABLE
1816: , a8 out nocopy JTF_NUMBER_TABLE
1817: , a9 out nocopy JTF_DATE_TABLE
1818: , a10 out nocopy JTF_DATE_TABLE
1819: , a11 out nocopy JTF_NUMBER_TABLE
1820: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1821: , a13 out nocopy JTF_VARCHAR2_TABLE_100
1822: , a14 out nocopy JTF_VARCHAR2_TABLE_300
1823: , a15 out nocopy JTF_VARCHAR2_TABLE_300
1842: a1 := JTF_VARCHAR2_TABLE_100();
1843: a2 := JTF_VARCHAR2_TABLE_300();
1844: a3 := JTF_VARCHAR2_TABLE_300();
1845: a4 := JTF_VARCHAR2_TABLE_100();
1846: a5 := JTF_NUMBER_TABLE();
1847: a6 := JTF_NUMBER_TABLE();
1848: a7 := JTF_NUMBER_TABLE();
1849: a8 := JTF_NUMBER_TABLE();
1850: a9 := JTF_DATE_TABLE();
1843: a2 := JTF_VARCHAR2_TABLE_300();
1844: a3 := JTF_VARCHAR2_TABLE_300();
1845: a4 := JTF_VARCHAR2_TABLE_100();
1846: a5 := JTF_NUMBER_TABLE();
1847: a6 := JTF_NUMBER_TABLE();
1848: a7 := JTF_NUMBER_TABLE();
1849: a8 := JTF_NUMBER_TABLE();
1850: a9 := JTF_DATE_TABLE();
1851: a10 := JTF_DATE_TABLE();
1844: a3 := JTF_VARCHAR2_TABLE_300();
1845: a4 := JTF_VARCHAR2_TABLE_100();
1846: a5 := JTF_NUMBER_TABLE();
1847: a6 := JTF_NUMBER_TABLE();
1848: a7 := JTF_NUMBER_TABLE();
1849: a8 := JTF_NUMBER_TABLE();
1850: a9 := JTF_DATE_TABLE();
1851: a10 := JTF_DATE_TABLE();
1852: a11 := JTF_NUMBER_TABLE();
1845: a4 := JTF_VARCHAR2_TABLE_100();
1846: a5 := JTF_NUMBER_TABLE();
1847: a6 := JTF_NUMBER_TABLE();
1848: a7 := JTF_NUMBER_TABLE();
1849: a8 := JTF_NUMBER_TABLE();
1850: a9 := JTF_DATE_TABLE();
1851: a10 := JTF_DATE_TABLE();
1852: a11 := JTF_NUMBER_TABLE();
1853: a12 := JTF_VARCHAR2_TABLE_100();
1848: a7 := JTF_NUMBER_TABLE();
1849: a8 := JTF_NUMBER_TABLE();
1850: a9 := JTF_DATE_TABLE();
1851: a10 := JTF_DATE_TABLE();
1852: a11 := JTF_NUMBER_TABLE();
1853: a12 := JTF_VARCHAR2_TABLE_100();
1854: a13 := JTF_VARCHAR2_TABLE_100();
1855: a14 := JTF_VARCHAR2_TABLE_300();
1856: a15 := JTF_VARCHAR2_TABLE_300();
1872: a1 := JTF_VARCHAR2_TABLE_100();
1873: a2 := JTF_VARCHAR2_TABLE_300();
1874: a3 := JTF_VARCHAR2_TABLE_300();
1875: a4 := JTF_VARCHAR2_TABLE_100();
1876: a5 := JTF_NUMBER_TABLE();
1877: a6 := JTF_NUMBER_TABLE();
1878: a7 := JTF_NUMBER_TABLE();
1879: a8 := JTF_NUMBER_TABLE();
1880: a9 := JTF_DATE_TABLE();
1873: a2 := JTF_VARCHAR2_TABLE_300();
1874: a3 := JTF_VARCHAR2_TABLE_300();
1875: a4 := JTF_VARCHAR2_TABLE_100();
1876: a5 := JTF_NUMBER_TABLE();
1877: a6 := JTF_NUMBER_TABLE();
1878: a7 := JTF_NUMBER_TABLE();
1879: a8 := JTF_NUMBER_TABLE();
1880: a9 := JTF_DATE_TABLE();
1881: a10 := JTF_DATE_TABLE();
1874: a3 := JTF_VARCHAR2_TABLE_300();
1875: a4 := JTF_VARCHAR2_TABLE_100();
1876: a5 := JTF_NUMBER_TABLE();
1877: a6 := JTF_NUMBER_TABLE();
1878: a7 := JTF_NUMBER_TABLE();
1879: a8 := JTF_NUMBER_TABLE();
1880: a9 := JTF_DATE_TABLE();
1881: a10 := JTF_DATE_TABLE();
1882: a11 := JTF_NUMBER_TABLE();
1875: a4 := JTF_VARCHAR2_TABLE_100();
1876: a5 := JTF_NUMBER_TABLE();
1877: a6 := JTF_NUMBER_TABLE();
1878: a7 := JTF_NUMBER_TABLE();
1879: a8 := JTF_NUMBER_TABLE();
1880: a9 := JTF_DATE_TABLE();
1881: a10 := JTF_DATE_TABLE();
1882: a11 := JTF_NUMBER_TABLE();
1883: a12 := JTF_VARCHAR2_TABLE_100();
1878: a7 := JTF_NUMBER_TABLE();
1879: a8 := JTF_NUMBER_TABLE();
1880: a9 := JTF_DATE_TABLE();
1881: a10 := JTF_DATE_TABLE();
1882: a11 := JTF_NUMBER_TABLE();
1883: a12 := JTF_VARCHAR2_TABLE_100();
1884: a13 := JTF_VARCHAR2_TABLE_100();
1885: a14 := JTF_VARCHAR2_TABLE_300();
1886: a15 := JTF_VARCHAR2_TABLE_300();
1968: end if;
1969: end if;
1970: end rosetta_table_copy_out_p19;
1971:
1972: procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
1973: , a1 JTF_NUMBER_TABLE
1974: , a2 JTF_NUMBER_TABLE
1975: , a3 JTF_NUMBER_TABLE
1976: , a4 JTF_VARCHAR2_TABLE_100
1969: end if;
1970: end rosetta_table_copy_out_p19;
1971:
1972: procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
1973: , a1 JTF_NUMBER_TABLE
1974: , a2 JTF_NUMBER_TABLE
1975: , a3 JTF_NUMBER_TABLE
1976: , a4 JTF_VARCHAR2_TABLE_100
1977: , a5 JTF_VARCHAR2_TABLE_100
1970: end rosetta_table_copy_out_p19;
1971:
1972: procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
1973: , a1 JTF_NUMBER_TABLE
1974: , a2 JTF_NUMBER_TABLE
1975: , a3 JTF_NUMBER_TABLE
1976: , a4 JTF_VARCHAR2_TABLE_100
1977: , a5 JTF_VARCHAR2_TABLE_100
1978: , a6 JTF_VARCHAR2_TABLE_100
1971:
1972: procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
1973: , a1 JTF_NUMBER_TABLE
1974: , a2 JTF_NUMBER_TABLE
1975: , a3 JTF_NUMBER_TABLE
1976: , a4 JTF_VARCHAR2_TABLE_100
1977: , a5 JTF_VARCHAR2_TABLE_100
1978: , a6 JTF_VARCHAR2_TABLE_100
1979: , a7 JTF_NUMBER_TABLE
1975: , a3 JTF_NUMBER_TABLE
1976: , a4 JTF_VARCHAR2_TABLE_100
1977: , a5 JTF_VARCHAR2_TABLE_100
1978: , a6 JTF_VARCHAR2_TABLE_100
1979: , a7 JTF_NUMBER_TABLE
1980: , a8 JTF_VARCHAR2_TABLE_100
1981: , a9 JTF_VARCHAR2_TABLE_100
1982: , a10 JTF_VARCHAR2_TABLE_100
1983: , a11 JTF_VARCHAR2_TABLE_100
1980: , a8 JTF_VARCHAR2_TABLE_100
1981: , a9 JTF_VARCHAR2_TABLE_100
1982: , a10 JTF_VARCHAR2_TABLE_100
1983: , a11 JTF_VARCHAR2_TABLE_100
1984: , a12 JTF_NUMBER_TABLE
1985: , a13 JTF_NUMBER_TABLE
1986: , a14 JTF_VARCHAR2_TABLE_100
1987: , a15 JTF_NUMBER_TABLE
1988: , a16 JTF_NUMBER_TABLE
1981: , a9 JTF_VARCHAR2_TABLE_100
1982: , a10 JTF_VARCHAR2_TABLE_100
1983: , a11 JTF_VARCHAR2_TABLE_100
1984: , a12 JTF_NUMBER_TABLE
1985: , a13 JTF_NUMBER_TABLE
1986: , a14 JTF_VARCHAR2_TABLE_100
1987: , a15 JTF_NUMBER_TABLE
1988: , a16 JTF_NUMBER_TABLE
1989: , a17 JTF_VARCHAR2_TABLE_300
1983: , a11 JTF_VARCHAR2_TABLE_100
1984: , a12 JTF_NUMBER_TABLE
1985: , a13 JTF_NUMBER_TABLE
1986: , a14 JTF_VARCHAR2_TABLE_100
1987: , a15 JTF_NUMBER_TABLE
1988: , a16 JTF_NUMBER_TABLE
1989: , a17 JTF_VARCHAR2_TABLE_300
1990: , a18 JTF_VARCHAR2_TABLE_2000
1991: , a19 JTF_VARCHAR2_TABLE_100
1984: , a12 JTF_NUMBER_TABLE
1985: , a13 JTF_NUMBER_TABLE
1986: , a14 JTF_VARCHAR2_TABLE_100
1987: , a15 JTF_NUMBER_TABLE
1988: , a16 JTF_NUMBER_TABLE
1989: , a17 JTF_VARCHAR2_TABLE_300
1990: , a18 JTF_VARCHAR2_TABLE_2000
1991: , a19 JTF_VARCHAR2_TABLE_100
1992: , a20 JTF_NUMBER_TABLE
1988: , a16 JTF_NUMBER_TABLE
1989: , a17 JTF_VARCHAR2_TABLE_300
1990: , a18 JTF_VARCHAR2_TABLE_2000
1991: , a19 JTF_VARCHAR2_TABLE_100
1992: , a20 JTF_NUMBER_TABLE
1993: ) as
1994: ddindx binary_integer; indx binary_integer;
1995: begin
1996: if a0 is not null and a0.count > 0 then
2027: end loop;
2028: end if;
2029: end if;
2030: end rosetta_table_copy_in_p21;
2031: procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2032: , a1 out nocopy JTF_NUMBER_TABLE
2033: , a2 out nocopy JTF_NUMBER_TABLE
2034: , a3 out nocopy JTF_NUMBER_TABLE
2035: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2028: end if;
2029: end if;
2030: end rosetta_table_copy_in_p21;
2031: procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2032: , a1 out nocopy JTF_NUMBER_TABLE
2033: , a2 out nocopy JTF_NUMBER_TABLE
2034: , a3 out nocopy JTF_NUMBER_TABLE
2035: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2036: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2029: end if;
2030: end rosetta_table_copy_in_p21;
2031: procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2032: , a1 out nocopy JTF_NUMBER_TABLE
2033: , a2 out nocopy JTF_NUMBER_TABLE
2034: , a3 out nocopy JTF_NUMBER_TABLE
2035: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2036: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2037: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2030: end rosetta_table_copy_in_p21;
2031: procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2032: , a1 out nocopy JTF_NUMBER_TABLE
2033: , a2 out nocopy JTF_NUMBER_TABLE
2034: , a3 out nocopy JTF_NUMBER_TABLE
2035: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2036: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2037: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2038: , a7 out nocopy JTF_NUMBER_TABLE
2034: , a3 out nocopy JTF_NUMBER_TABLE
2035: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2036: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2037: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2038: , a7 out nocopy JTF_NUMBER_TABLE
2039: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2040: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2041: , a10 out nocopy JTF_VARCHAR2_TABLE_100
2042: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2039: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2040: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2041: , a10 out nocopy JTF_VARCHAR2_TABLE_100
2042: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2043: , a12 out nocopy JTF_NUMBER_TABLE
2044: , a13 out nocopy JTF_NUMBER_TABLE
2045: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2046: , a15 out nocopy JTF_NUMBER_TABLE
2047: , a16 out nocopy JTF_NUMBER_TABLE
2040: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2041: , a10 out nocopy JTF_VARCHAR2_TABLE_100
2042: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2043: , a12 out nocopy JTF_NUMBER_TABLE
2044: , a13 out nocopy JTF_NUMBER_TABLE
2045: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2046: , a15 out nocopy JTF_NUMBER_TABLE
2047: , a16 out nocopy JTF_NUMBER_TABLE
2048: , a17 out nocopy JTF_VARCHAR2_TABLE_300
2042: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2043: , a12 out nocopy JTF_NUMBER_TABLE
2044: , a13 out nocopy JTF_NUMBER_TABLE
2045: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2046: , a15 out nocopy JTF_NUMBER_TABLE
2047: , a16 out nocopy JTF_NUMBER_TABLE
2048: , a17 out nocopy JTF_VARCHAR2_TABLE_300
2049: , a18 out nocopy JTF_VARCHAR2_TABLE_2000
2050: , a19 out nocopy JTF_VARCHAR2_TABLE_100
2043: , a12 out nocopy JTF_NUMBER_TABLE
2044: , a13 out nocopy JTF_NUMBER_TABLE
2045: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2046: , a15 out nocopy JTF_NUMBER_TABLE
2047: , a16 out nocopy JTF_NUMBER_TABLE
2048: , a17 out nocopy JTF_VARCHAR2_TABLE_300
2049: , a18 out nocopy JTF_VARCHAR2_TABLE_2000
2050: , a19 out nocopy JTF_VARCHAR2_TABLE_100
2051: , a20 out nocopy JTF_NUMBER_TABLE
2047: , a16 out nocopy JTF_NUMBER_TABLE
2048: , a17 out nocopy JTF_VARCHAR2_TABLE_300
2049: , a18 out nocopy JTF_VARCHAR2_TABLE_2000
2050: , a19 out nocopy JTF_VARCHAR2_TABLE_100
2051: , a20 out nocopy JTF_NUMBER_TABLE
2052: ) as
2053: ddindx binary_integer; indx binary_integer;
2054: begin
2055: if t is null or t.count = 0 then
2052: ) as
2053: ddindx binary_integer; indx binary_integer;
2054: begin
2055: if t is null or t.count = 0 then
2056: a0 := JTF_NUMBER_TABLE();
2057: a1 := JTF_NUMBER_TABLE();
2058: a2 := JTF_NUMBER_TABLE();
2059: a3 := JTF_NUMBER_TABLE();
2060: a4 := JTF_VARCHAR2_TABLE_100();
2053: ddindx binary_integer; indx binary_integer;
2054: begin
2055: if t is null or t.count = 0 then
2056: a0 := JTF_NUMBER_TABLE();
2057: a1 := JTF_NUMBER_TABLE();
2058: a2 := JTF_NUMBER_TABLE();
2059: a3 := JTF_NUMBER_TABLE();
2060: a4 := JTF_VARCHAR2_TABLE_100();
2061: a5 := JTF_VARCHAR2_TABLE_100();
2054: begin
2055: if t is null or t.count = 0 then
2056: a0 := JTF_NUMBER_TABLE();
2057: a1 := JTF_NUMBER_TABLE();
2058: a2 := JTF_NUMBER_TABLE();
2059: a3 := JTF_NUMBER_TABLE();
2060: a4 := JTF_VARCHAR2_TABLE_100();
2061: a5 := JTF_VARCHAR2_TABLE_100();
2062: a6 := JTF_VARCHAR2_TABLE_100();
2055: if t is null or t.count = 0 then
2056: a0 := JTF_NUMBER_TABLE();
2057: a1 := JTF_NUMBER_TABLE();
2058: a2 := JTF_NUMBER_TABLE();
2059: a3 := JTF_NUMBER_TABLE();
2060: a4 := JTF_VARCHAR2_TABLE_100();
2061: a5 := JTF_VARCHAR2_TABLE_100();
2062: a6 := JTF_VARCHAR2_TABLE_100();
2063: a7 := JTF_NUMBER_TABLE();
2059: a3 := JTF_NUMBER_TABLE();
2060: a4 := JTF_VARCHAR2_TABLE_100();
2061: a5 := JTF_VARCHAR2_TABLE_100();
2062: a6 := JTF_VARCHAR2_TABLE_100();
2063: a7 := JTF_NUMBER_TABLE();
2064: a8 := JTF_VARCHAR2_TABLE_100();
2065: a9 := JTF_VARCHAR2_TABLE_100();
2066: a10 := JTF_VARCHAR2_TABLE_100();
2067: a11 := JTF_VARCHAR2_TABLE_100();
2064: a8 := JTF_VARCHAR2_TABLE_100();
2065: a9 := JTF_VARCHAR2_TABLE_100();
2066: a10 := JTF_VARCHAR2_TABLE_100();
2067: a11 := JTF_VARCHAR2_TABLE_100();
2068: a12 := JTF_NUMBER_TABLE();
2069: a13 := JTF_NUMBER_TABLE();
2070: a14 := JTF_VARCHAR2_TABLE_100();
2071: a15 := JTF_NUMBER_TABLE();
2072: a16 := JTF_NUMBER_TABLE();
2065: a9 := JTF_VARCHAR2_TABLE_100();
2066: a10 := JTF_VARCHAR2_TABLE_100();
2067: a11 := JTF_VARCHAR2_TABLE_100();
2068: a12 := JTF_NUMBER_TABLE();
2069: a13 := JTF_NUMBER_TABLE();
2070: a14 := JTF_VARCHAR2_TABLE_100();
2071: a15 := JTF_NUMBER_TABLE();
2072: a16 := JTF_NUMBER_TABLE();
2073: a17 := JTF_VARCHAR2_TABLE_300();
2067: a11 := JTF_VARCHAR2_TABLE_100();
2068: a12 := JTF_NUMBER_TABLE();
2069: a13 := JTF_NUMBER_TABLE();
2070: a14 := JTF_VARCHAR2_TABLE_100();
2071: a15 := JTF_NUMBER_TABLE();
2072: a16 := JTF_NUMBER_TABLE();
2073: a17 := JTF_VARCHAR2_TABLE_300();
2074: a18 := JTF_VARCHAR2_TABLE_2000();
2075: a19 := JTF_VARCHAR2_TABLE_100();
2068: a12 := JTF_NUMBER_TABLE();
2069: a13 := JTF_NUMBER_TABLE();
2070: a14 := JTF_VARCHAR2_TABLE_100();
2071: a15 := JTF_NUMBER_TABLE();
2072: a16 := JTF_NUMBER_TABLE();
2073: a17 := JTF_VARCHAR2_TABLE_300();
2074: a18 := JTF_VARCHAR2_TABLE_2000();
2075: a19 := JTF_VARCHAR2_TABLE_100();
2076: a20 := JTF_NUMBER_TABLE();
2072: a16 := JTF_NUMBER_TABLE();
2073: a17 := JTF_VARCHAR2_TABLE_300();
2074: a18 := JTF_VARCHAR2_TABLE_2000();
2075: a19 := JTF_VARCHAR2_TABLE_100();
2076: a20 := JTF_NUMBER_TABLE();
2077: else
2078: a0 := JTF_NUMBER_TABLE();
2079: a1 := JTF_NUMBER_TABLE();
2080: a2 := JTF_NUMBER_TABLE();
2074: a18 := JTF_VARCHAR2_TABLE_2000();
2075: a19 := JTF_VARCHAR2_TABLE_100();
2076: a20 := JTF_NUMBER_TABLE();
2077: else
2078: a0 := JTF_NUMBER_TABLE();
2079: a1 := JTF_NUMBER_TABLE();
2080: a2 := JTF_NUMBER_TABLE();
2081: a3 := JTF_NUMBER_TABLE();
2082: a4 := JTF_VARCHAR2_TABLE_100();
2075: a19 := JTF_VARCHAR2_TABLE_100();
2076: a20 := JTF_NUMBER_TABLE();
2077: else
2078: a0 := JTF_NUMBER_TABLE();
2079: a1 := JTF_NUMBER_TABLE();
2080: a2 := JTF_NUMBER_TABLE();
2081: a3 := JTF_NUMBER_TABLE();
2082: a4 := JTF_VARCHAR2_TABLE_100();
2083: a5 := JTF_VARCHAR2_TABLE_100();
2076: a20 := JTF_NUMBER_TABLE();
2077: else
2078: a0 := JTF_NUMBER_TABLE();
2079: a1 := JTF_NUMBER_TABLE();
2080: a2 := JTF_NUMBER_TABLE();
2081: a3 := JTF_NUMBER_TABLE();
2082: a4 := JTF_VARCHAR2_TABLE_100();
2083: a5 := JTF_VARCHAR2_TABLE_100();
2084: a6 := JTF_VARCHAR2_TABLE_100();
2077: else
2078: a0 := JTF_NUMBER_TABLE();
2079: a1 := JTF_NUMBER_TABLE();
2080: a2 := JTF_NUMBER_TABLE();
2081: a3 := JTF_NUMBER_TABLE();
2082: a4 := JTF_VARCHAR2_TABLE_100();
2083: a5 := JTF_VARCHAR2_TABLE_100();
2084: a6 := JTF_VARCHAR2_TABLE_100();
2085: a7 := JTF_NUMBER_TABLE();
2081: a3 := JTF_NUMBER_TABLE();
2082: a4 := JTF_VARCHAR2_TABLE_100();
2083: a5 := JTF_VARCHAR2_TABLE_100();
2084: a6 := JTF_VARCHAR2_TABLE_100();
2085: a7 := JTF_NUMBER_TABLE();
2086: a8 := JTF_VARCHAR2_TABLE_100();
2087: a9 := JTF_VARCHAR2_TABLE_100();
2088: a10 := JTF_VARCHAR2_TABLE_100();
2089: a11 := JTF_VARCHAR2_TABLE_100();
2086: a8 := JTF_VARCHAR2_TABLE_100();
2087: a9 := JTF_VARCHAR2_TABLE_100();
2088: a10 := JTF_VARCHAR2_TABLE_100();
2089: a11 := JTF_VARCHAR2_TABLE_100();
2090: a12 := JTF_NUMBER_TABLE();
2091: a13 := JTF_NUMBER_TABLE();
2092: a14 := JTF_VARCHAR2_TABLE_100();
2093: a15 := JTF_NUMBER_TABLE();
2094: a16 := JTF_NUMBER_TABLE();
2087: a9 := JTF_VARCHAR2_TABLE_100();
2088: a10 := JTF_VARCHAR2_TABLE_100();
2089: a11 := JTF_VARCHAR2_TABLE_100();
2090: a12 := JTF_NUMBER_TABLE();
2091: a13 := JTF_NUMBER_TABLE();
2092: a14 := JTF_VARCHAR2_TABLE_100();
2093: a15 := JTF_NUMBER_TABLE();
2094: a16 := JTF_NUMBER_TABLE();
2095: a17 := JTF_VARCHAR2_TABLE_300();
2089: a11 := JTF_VARCHAR2_TABLE_100();
2090: a12 := JTF_NUMBER_TABLE();
2091: a13 := JTF_NUMBER_TABLE();
2092: a14 := JTF_VARCHAR2_TABLE_100();
2093: a15 := JTF_NUMBER_TABLE();
2094: a16 := JTF_NUMBER_TABLE();
2095: a17 := JTF_VARCHAR2_TABLE_300();
2096: a18 := JTF_VARCHAR2_TABLE_2000();
2097: a19 := JTF_VARCHAR2_TABLE_100();
2090: a12 := JTF_NUMBER_TABLE();
2091: a13 := JTF_NUMBER_TABLE();
2092: a14 := JTF_VARCHAR2_TABLE_100();
2093: a15 := JTF_NUMBER_TABLE();
2094: a16 := JTF_NUMBER_TABLE();
2095: a17 := JTF_VARCHAR2_TABLE_300();
2096: a18 := JTF_VARCHAR2_TABLE_2000();
2097: a19 := JTF_VARCHAR2_TABLE_100();
2098: a20 := JTF_NUMBER_TABLE();
2094: a16 := JTF_NUMBER_TABLE();
2095: a17 := JTF_VARCHAR2_TABLE_300();
2096: a18 := JTF_VARCHAR2_TABLE_2000();
2097: a19 := JTF_VARCHAR2_TABLE_100();
2098: a20 := JTF_NUMBER_TABLE();
2099: if t.count > 0 then
2100: a0.extend(t.count);
2101: a1.extend(t.count);
2102: a2.extend(t.count);
2151: end if;
2152: end if;
2153: end rosetta_table_copy_out_p21;
2154:
2155: procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE
2156: , a1 JTF_VARCHAR2_TABLE_100
2157: , a2 JTF_NUMBER_TABLE
2158: , a3 JTF_NUMBER_TABLE
2159: , a4 JTF_NUMBER_TABLE
2153: end rosetta_table_copy_out_p21;
2154:
2155: procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE
2156: , a1 JTF_VARCHAR2_TABLE_100
2157: , a2 JTF_NUMBER_TABLE
2158: , a3 JTF_NUMBER_TABLE
2159: , a4 JTF_NUMBER_TABLE
2160: , a5 JTF_VARCHAR2_TABLE_100
2161: , a6 JTF_VARCHAR2_TABLE_100
2154:
2155: procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE
2156: , a1 JTF_VARCHAR2_TABLE_100
2157: , a2 JTF_NUMBER_TABLE
2158: , a3 JTF_NUMBER_TABLE
2159: , a4 JTF_NUMBER_TABLE
2160: , a5 JTF_VARCHAR2_TABLE_100
2161: , a6 JTF_VARCHAR2_TABLE_100
2162: , a7 JTF_VARCHAR2_TABLE_300
2155: procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE
2156: , a1 JTF_VARCHAR2_TABLE_100
2157: , a2 JTF_NUMBER_TABLE
2158: , a3 JTF_NUMBER_TABLE
2159: , a4 JTF_NUMBER_TABLE
2160: , a5 JTF_VARCHAR2_TABLE_100
2161: , a6 JTF_VARCHAR2_TABLE_100
2162: , a7 JTF_VARCHAR2_TABLE_300
2163: , a8 JTF_VARCHAR2_TABLE_100
2162: , a7 JTF_VARCHAR2_TABLE_300
2163: , a8 JTF_VARCHAR2_TABLE_100
2164: , a9 JTF_VARCHAR2_TABLE_100
2165: , a10 JTF_VARCHAR2_TABLE_100
2166: , a11 JTF_NUMBER_TABLE
2167: ) as
2168: ddindx binary_integer; indx binary_integer;
2169: begin
2170: if a0 is not null and a0.count > 0 then
2192: end loop;
2193: end if;
2194: end if;
2195: end rosetta_table_copy_in_p23;
2196: procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2198: , a2 out nocopy JTF_NUMBER_TABLE
2199: , a3 out nocopy JTF_NUMBER_TABLE
2200: , a4 out nocopy JTF_NUMBER_TABLE
2194: end if;
2195: end rosetta_table_copy_in_p23;
2196: procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2198: , a2 out nocopy JTF_NUMBER_TABLE
2199: , a3 out nocopy JTF_NUMBER_TABLE
2200: , a4 out nocopy JTF_NUMBER_TABLE
2201: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2202: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2195: end rosetta_table_copy_in_p23;
2196: procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2198: , a2 out nocopy JTF_NUMBER_TABLE
2199: , a3 out nocopy JTF_NUMBER_TABLE
2200: , a4 out nocopy JTF_NUMBER_TABLE
2201: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2202: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2203: , a7 out nocopy JTF_VARCHAR2_TABLE_300
2196: procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2198: , a2 out nocopy JTF_NUMBER_TABLE
2199: , a3 out nocopy JTF_NUMBER_TABLE
2200: , a4 out nocopy JTF_NUMBER_TABLE
2201: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2202: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2203: , a7 out nocopy JTF_VARCHAR2_TABLE_300
2204: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2203: , a7 out nocopy JTF_VARCHAR2_TABLE_300
2204: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2205: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2206: , a10 out nocopy JTF_VARCHAR2_TABLE_100
2207: , a11 out nocopy JTF_NUMBER_TABLE
2208: ) as
2209: ddindx binary_integer; indx binary_integer;
2210: begin
2211: if t is null or t.count = 0 then
2208: ) as
2209: ddindx binary_integer; indx binary_integer;
2210: begin
2211: if t is null or t.count = 0 then
2212: a0 := JTF_NUMBER_TABLE();
2213: a1 := JTF_VARCHAR2_TABLE_100();
2214: a2 := JTF_NUMBER_TABLE();
2215: a3 := JTF_NUMBER_TABLE();
2216: a4 := JTF_NUMBER_TABLE();
2210: begin
2211: if t is null or t.count = 0 then
2212: a0 := JTF_NUMBER_TABLE();
2213: a1 := JTF_VARCHAR2_TABLE_100();
2214: a2 := JTF_NUMBER_TABLE();
2215: a3 := JTF_NUMBER_TABLE();
2216: a4 := JTF_NUMBER_TABLE();
2217: a5 := JTF_VARCHAR2_TABLE_100();
2218: a6 := JTF_VARCHAR2_TABLE_100();
2211: if t is null or t.count = 0 then
2212: a0 := JTF_NUMBER_TABLE();
2213: a1 := JTF_VARCHAR2_TABLE_100();
2214: a2 := JTF_NUMBER_TABLE();
2215: a3 := JTF_NUMBER_TABLE();
2216: a4 := JTF_NUMBER_TABLE();
2217: a5 := JTF_VARCHAR2_TABLE_100();
2218: a6 := JTF_VARCHAR2_TABLE_100();
2219: a7 := JTF_VARCHAR2_TABLE_300();
2212: a0 := JTF_NUMBER_TABLE();
2213: a1 := JTF_VARCHAR2_TABLE_100();
2214: a2 := JTF_NUMBER_TABLE();
2215: a3 := JTF_NUMBER_TABLE();
2216: a4 := JTF_NUMBER_TABLE();
2217: a5 := JTF_VARCHAR2_TABLE_100();
2218: a6 := JTF_VARCHAR2_TABLE_100();
2219: a7 := JTF_VARCHAR2_TABLE_300();
2220: a8 := JTF_VARCHAR2_TABLE_100();
2219: a7 := JTF_VARCHAR2_TABLE_300();
2220: a8 := JTF_VARCHAR2_TABLE_100();
2221: a9 := JTF_VARCHAR2_TABLE_100();
2222: a10 := JTF_VARCHAR2_TABLE_100();
2223: a11 := JTF_NUMBER_TABLE();
2224: else
2225: a0 := JTF_NUMBER_TABLE();
2226: a1 := JTF_VARCHAR2_TABLE_100();
2227: a2 := JTF_NUMBER_TABLE();
2221: a9 := JTF_VARCHAR2_TABLE_100();
2222: a10 := JTF_VARCHAR2_TABLE_100();
2223: a11 := JTF_NUMBER_TABLE();
2224: else
2225: a0 := JTF_NUMBER_TABLE();
2226: a1 := JTF_VARCHAR2_TABLE_100();
2227: a2 := JTF_NUMBER_TABLE();
2228: a3 := JTF_NUMBER_TABLE();
2229: a4 := JTF_NUMBER_TABLE();
2223: a11 := JTF_NUMBER_TABLE();
2224: else
2225: a0 := JTF_NUMBER_TABLE();
2226: a1 := JTF_VARCHAR2_TABLE_100();
2227: a2 := JTF_NUMBER_TABLE();
2228: a3 := JTF_NUMBER_TABLE();
2229: a4 := JTF_NUMBER_TABLE();
2230: a5 := JTF_VARCHAR2_TABLE_100();
2231: a6 := JTF_VARCHAR2_TABLE_100();
2224: else
2225: a0 := JTF_NUMBER_TABLE();
2226: a1 := JTF_VARCHAR2_TABLE_100();
2227: a2 := JTF_NUMBER_TABLE();
2228: a3 := JTF_NUMBER_TABLE();
2229: a4 := JTF_NUMBER_TABLE();
2230: a5 := JTF_VARCHAR2_TABLE_100();
2231: a6 := JTF_VARCHAR2_TABLE_100();
2232: a7 := JTF_VARCHAR2_TABLE_300();
2225: a0 := JTF_NUMBER_TABLE();
2226: a1 := JTF_VARCHAR2_TABLE_100();
2227: a2 := JTF_NUMBER_TABLE();
2228: a3 := JTF_NUMBER_TABLE();
2229: a4 := JTF_NUMBER_TABLE();
2230: a5 := JTF_VARCHAR2_TABLE_100();
2231: a6 := JTF_VARCHAR2_TABLE_100();
2232: a7 := JTF_VARCHAR2_TABLE_300();
2233: a8 := JTF_VARCHAR2_TABLE_100();
2232: a7 := JTF_VARCHAR2_TABLE_300();
2233: a8 := JTF_VARCHAR2_TABLE_100();
2234: a9 := JTF_VARCHAR2_TABLE_100();
2235: a10 := JTF_VARCHAR2_TABLE_100();
2236: a11 := JTF_NUMBER_TABLE();
2237: if t.count > 0 then
2238: a0.extend(t.count);
2239: a1.extend(t.count);
2240: a2.extend(t.count);
2271: end if;
2272: end if;
2273: end rosetta_table_copy_out_p23;
2274:
2275: procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE
2276: , a1 JTF_NUMBER_TABLE
2277: , a2 JTF_NUMBER_TABLE
2278: , a3 JTF_NUMBER_TABLE
2279: , a4 JTF_VARCHAR2_TABLE_100
2272: end if;
2273: end rosetta_table_copy_out_p23;
2274:
2275: procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE
2276: , a1 JTF_NUMBER_TABLE
2277: , a2 JTF_NUMBER_TABLE
2278: , a3 JTF_NUMBER_TABLE
2279: , a4 JTF_VARCHAR2_TABLE_100
2280: , a5 JTF_NUMBER_TABLE
2273: end rosetta_table_copy_out_p23;
2274:
2275: procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE
2276: , a1 JTF_NUMBER_TABLE
2277: , a2 JTF_NUMBER_TABLE
2278: , a3 JTF_NUMBER_TABLE
2279: , a4 JTF_VARCHAR2_TABLE_100
2280: , a5 JTF_NUMBER_TABLE
2281: , a6 JTF_VARCHAR2_TABLE_100
2274:
2275: procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE
2276: , a1 JTF_NUMBER_TABLE
2277: , a2 JTF_NUMBER_TABLE
2278: , a3 JTF_NUMBER_TABLE
2279: , a4 JTF_VARCHAR2_TABLE_100
2280: , a5 JTF_NUMBER_TABLE
2281: , a6 JTF_VARCHAR2_TABLE_100
2282: , a7 JTF_VARCHAR2_TABLE_100
2276: , a1 JTF_NUMBER_TABLE
2277: , a2 JTF_NUMBER_TABLE
2278: , a3 JTF_NUMBER_TABLE
2279: , a4 JTF_VARCHAR2_TABLE_100
2280: , a5 JTF_NUMBER_TABLE
2281: , a6 JTF_VARCHAR2_TABLE_100
2282: , a7 JTF_VARCHAR2_TABLE_100
2283: , a8 JTF_VARCHAR2_TABLE_100
2284: , a9 JTF_NUMBER_TABLE
2280: , a5 JTF_NUMBER_TABLE
2281: , a6 JTF_VARCHAR2_TABLE_100
2282: , a7 JTF_VARCHAR2_TABLE_100
2283: , a8 JTF_VARCHAR2_TABLE_100
2284: , a9 JTF_NUMBER_TABLE
2285: , a10 JTF_NUMBER_TABLE
2286: , a11 JTF_NUMBER_TABLE
2287: , a12 JTF_VARCHAR2_TABLE_100
2288: ) as
2281: , a6 JTF_VARCHAR2_TABLE_100
2282: , a7 JTF_VARCHAR2_TABLE_100
2283: , a8 JTF_VARCHAR2_TABLE_100
2284: , a9 JTF_NUMBER_TABLE
2285: , a10 JTF_NUMBER_TABLE
2286: , a11 JTF_NUMBER_TABLE
2287: , a12 JTF_VARCHAR2_TABLE_100
2288: ) as
2289: ddindx binary_integer; indx binary_integer;
2282: , a7 JTF_VARCHAR2_TABLE_100
2283: , a8 JTF_VARCHAR2_TABLE_100
2284: , a9 JTF_NUMBER_TABLE
2285: , a10 JTF_NUMBER_TABLE
2286: , a11 JTF_NUMBER_TABLE
2287: , a12 JTF_VARCHAR2_TABLE_100
2288: ) as
2289: ddindx binary_integer; indx binary_integer;
2290: begin
2314: end loop;
2315: end if;
2316: end if;
2317: end rosetta_table_copy_in_p25;
2318: procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2319: , a1 out nocopy JTF_NUMBER_TABLE
2320: , a2 out nocopy JTF_NUMBER_TABLE
2321: , a3 out nocopy JTF_NUMBER_TABLE
2322: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2315: end if;
2316: end if;
2317: end rosetta_table_copy_in_p25;
2318: procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2319: , a1 out nocopy JTF_NUMBER_TABLE
2320: , a2 out nocopy JTF_NUMBER_TABLE
2321: , a3 out nocopy JTF_NUMBER_TABLE
2322: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2323: , a5 out nocopy JTF_NUMBER_TABLE
2316: end if;
2317: end rosetta_table_copy_in_p25;
2318: procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2319: , a1 out nocopy JTF_NUMBER_TABLE
2320: , a2 out nocopy JTF_NUMBER_TABLE
2321: , a3 out nocopy JTF_NUMBER_TABLE
2322: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2323: , a5 out nocopy JTF_NUMBER_TABLE
2324: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2317: end rosetta_table_copy_in_p25;
2318: procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2319: , a1 out nocopy JTF_NUMBER_TABLE
2320: , a2 out nocopy JTF_NUMBER_TABLE
2321: , a3 out nocopy JTF_NUMBER_TABLE
2322: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2323: , a5 out nocopy JTF_NUMBER_TABLE
2324: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2325: , a7 out nocopy JTF_VARCHAR2_TABLE_100
2319: , a1 out nocopy JTF_NUMBER_TABLE
2320: , a2 out nocopy JTF_NUMBER_TABLE
2321: , a3 out nocopy JTF_NUMBER_TABLE
2322: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2323: , a5 out nocopy JTF_NUMBER_TABLE
2324: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2325: , a7 out nocopy JTF_VARCHAR2_TABLE_100
2326: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2327: , a9 out nocopy JTF_NUMBER_TABLE
2323: , a5 out nocopy JTF_NUMBER_TABLE
2324: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2325: , a7 out nocopy JTF_VARCHAR2_TABLE_100
2326: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2327: , a9 out nocopy JTF_NUMBER_TABLE
2328: , a10 out nocopy JTF_NUMBER_TABLE
2329: , a11 out nocopy JTF_NUMBER_TABLE
2330: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2331: ) as
2324: , a6 out nocopy JTF_VARCHAR2_TABLE_100
2325: , a7 out nocopy JTF_VARCHAR2_TABLE_100
2326: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2327: , a9 out nocopy JTF_NUMBER_TABLE
2328: , a10 out nocopy JTF_NUMBER_TABLE
2329: , a11 out nocopy JTF_NUMBER_TABLE
2330: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2331: ) as
2332: ddindx binary_integer; indx binary_integer;
2325: , a7 out nocopy JTF_VARCHAR2_TABLE_100
2326: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2327: , a9 out nocopy JTF_NUMBER_TABLE
2328: , a10 out nocopy JTF_NUMBER_TABLE
2329: , a11 out nocopy JTF_NUMBER_TABLE
2330: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2331: ) as
2332: ddindx binary_integer; indx binary_integer;
2333: begin
2331: ) as
2332: ddindx binary_integer; indx binary_integer;
2333: begin
2334: if t is null or t.count = 0 then
2335: a0 := JTF_NUMBER_TABLE();
2336: a1 := JTF_NUMBER_TABLE();
2337: a2 := JTF_NUMBER_TABLE();
2338: a3 := JTF_NUMBER_TABLE();
2339: a4 := JTF_VARCHAR2_TABLE_100();
2332: ddindx binary_integer; indx binary_integer;
2333: begin
2334: if t is null or t.count = 0 then
2335: a0 := JTF_NUMBER_TABLE();
2336: a1 := JTF_NUMBER_TABLE();
2337: a2 := JTF_NUMBER_TABLE();
2338: a3 := JTF_NUMBER_TABLE();
2339: a4 := JTF_VARCHAR2_TABLE_100();
2340: a5 := JTF_NUMBER_TABLE();
2333: begin
2334: if t is null or t.count = 0 then
2335: a0 := JTF_NUMBER_TABLE();
2336: a1 := JTF_NUMBER_TABLE();
2337: a2 := JTF_NUMBER_TABLE();
2338: a3 := JTF_NUMBER_TABLE();
2339: a4 := JTF_VARCHAR2_TABLE_100();
2340: a5 := JTF_NUMBER_TABLE();
2341: a6 := JTF_VARCHAR2_TABLE_100();
2334: if t is null or t.count = 0 then
2335: a0 := JTF_NUMBER_TABLE();
2336: a1 := JTF_NUMBER_TABLE();
2337: a2 := JTF_NUMBER_TABLE();
2338: a3 := JTF_NUMBER_TABLE();
2339: a4 := JTF_VARCHAR2_TABLE_100();
2340: a5 := JTF_NUMBER_TABLE();
2341: a6 := JTF_VARCHAR2_TABLE_100();
2342: a7 := JTF_VARCHAR2_TABLE_100();
2336: a1 := JTF_NUMBER_TABLE();
2337: a2 := JTF_NUMBER_TABLE();
2338: a3 := JTF_NUMBER_TABLE();
2339: a4 := JTF_VARCHAR2_TABLE_100();
2340: a5 := JTF_NUMBER_TABLE();
2341: a6 := JTF_VARCHAR2_TABLE_100();
2342: a7 := JTF_VARCHAR2_TABLE_100();
2343: a8 := JTF_VARCHAR2_TABLE_100();
2344: a9 := JTF_NUMBER_TABLE();
2340: a5 := JTF_NUMBER_TABLE();
2341: a6 := JTF_VARCHAR2_TABLE_100();
2342: a7 := JTF_VARCHAR2_TABLE_100();
2343: a8 := JTF_VARCHAR2_TABLE_100();
2344: a9 := JTF_NUMBER_TABLE();
2345: a10 := JTF_NUMBER_TABLE();
2346: a11 := JTF_NUMBER_TABLE();
2347: a12 := JTF_VARCHAR2_TABLE_100();
2348: else
2341: a6 := JTF_VARCHAR2_TABLE_100();
2342: a7 := JTF_VARCHAR2_TABLE_100();
2343: a8 := JTF_VARCHAR2_TABLE_100();
2344: a9 := JTF_NUMBER_TABLE();
2345: a10 := JTF_NUMBER_TABLE();
2346: a11 := JTF_NUMBER_TABLE();
2347: a12 := JTF_VARCHAR2_TABLE_100();
2348: else
2349: a0 := JTF_NUMBER_TABLE();
2342: a7 := JTF_VARCHAR2_TABLE_100();
2343: a8 := JTF_VARCHAR2_TABLE_100();
2344: a9 := JTF_NUMBER_TABLE();
2345: a10 := JTF_NUMBER_TABLE();
2346: a11 := JTF_NUMBER_TABLE();
2347: a12 := JTF_VARCHAR2_TABLE_100();
2348: else
2349: a0 := JTF_NUMBER_TABLE();
2350: a1 := JTF_NUMBER_TABLE();
2345: a10 := JTF_NUMBER_TABLE();
2346: a11 := JTF_NUMBER_TABLE();
2347: a12 := JTF_VARCHAR2_TABLE_100();
2348: else
2349: a0 := JTF_NUMBER_TABLE();
2350: a1 := JTF_NUMBER_TABLE();
2351: a2 := JTF_NUMBER_TABLE();
2352: a3 := JTF_NUMBER_TABLE();
2353: a4 := JTF_VARCHAR2_TABLE_100();
2346: a11 := JTF_NUMBER_TABLE();
2347: a12 := JTF_VARCHAR2_TABLE_100();
2348: else
2349: a0 := JTF_NUMBER_TABLE();
2350: a1 := JTF_NUMBER_TABLE();
2351: a2 := JTF_NUMBER_TABLE();
2352: a3 := JTF_NUMBER_TABLE();
2353: a4 := JTF_VARCHAR2_TABLE_100();
2354: a5 := JTF_NUMBER_TABLE();
2347: a12 := JTF_VARCHAR2_TABLE_100();
2348: else
2349: a0 := JTF_NUMBER_TABLE();
2350: a1 := JTF_NUMBER_TABLE();
2351: a2 := JTF_NUMBER_TABLE();
2352: a3 := JTF_NUMBER_TABLE();
2353: a4 := JTF_VARCHAR2_TABLE_100();
2354: a5 := JTF_NUMBER_TABLE();
2355: a6 := JTF_VARCHAR2_TABLE_100();
2348: else
2349: a0 := JTF_NUMBER_TABLE();
2350: a1 := JTF_NUMBER_TABLE();
2351: a2 := JTF_NUMBER_TABLE();
2352: a3 := JTF_NUMBER_TABLE();
2353: a4 := JTF_VARCHAR2_TABLE_100();
2354: a5 := JTF_NUMBER_TABLE();
2355: a6 := JTF_VARCHAR2_TABLE_100();
2356: a7 := JTF_VARCHAR2_TABLE_100();
2350: a1 := JTF_NUMBER_TABLE();
2351: a2 := JTF_NUMBER_TABLE();
2352: a3 := JTF_NUMBER_TABLE();
2353: a4 := JTF_VARCHAR2_TABLE_100();
2354: a5 := JTF_NUMBER_TABLE();
2355: a6 := JTF_VARCHAR2_TABLE_100();
2356: a7 := JTF_VARCHAR2_TABLE_100();
2357: a8 := JTF_VARCHAR2_TABLE_100();
2358: a9 := JTF_NUMBER_TABLE();
2354: a5 := JTF_NUMBER_TABLE();
2355: a6 := JTF_VARCHAR2_TABLE_100();
2356: a7 := JTF_VARCHAR2_TABLE_100();
2357: a8 := JTF_VARCHAR2_TABLE_100();
2358: a9 := JTF_NUMBER_TABLE();
2359: a10 := JTF_NUMBER_TABLE();
2360: a11 := JTF_NUMBER_TABLE();
2361: a12 := JTF_VARCHAR2_TABLE_100();
2362: if t.count > 0 then
2355: a6 := JTF_VARCHAR2_TABLE_100();
2356: a7 := JTF_VARCHAR2_TABLE_100();
2357: a8 := JTF_VARCHAR2_TABLE_100();
2358: a9 := JTF_NUMBER_TABLE();
2359: a10 := JTF_NUMBER_TABLE();
2360: a11 := JTF_NUMBER_TABLE();
2361: a12 := JTF_VARCHAR2_TABLE_100();
2362: if t.count > 0 then
2363: a0.extend(t.count);
2356: a7 := JTF_VARCHAR2_TABLE_100();
2357: a8 := JTF_VARCHAR2_TABLE_100();
2358: a9 := JTF_NUMBER_TABLE();
2359: a10 := JTF_NUMBER_TABLE();
2360: a11 := JTF_NUMBER_TABLE();
2361: a12 := JTF_VARCHAR2_TABLE_100();
2362: if t.count > 0 then
2363: a0.extend(t.count);
2364: a1.extend(t.count);
2490: , p7_a81 VARCHAR2
2491: , p7_a82 NUMBER
2492: , p8_a0 JTF_VARCHAR2_TABLE_100
2493: , p8_a1 JTF_VARCHAR2_TABLE_100
2494: , p8_a2 JTF_NUMBER_TABLE
2495: , p8_a3 JTF_NUMBER_TABLE
2496: , p8_a4 JTF_VARCHAR2_TABLE_100
2497: , p8_a5 JTF_NUMBER_TABLE
2498: , p8_a6 JTF_DATE_TABLE
2491: , p7_a82 NUMBER
2492: , p8_a0 JTF_VARCHAR2_TABLE_100
2493: , p8_a1 JTF_VARCHAR2_TABLE_100
2494: , p8_a2 JTF_NUMBER_TABLE
2495: , p8_a3 JTF_NUMBER_TABLE
2496: , p8_a4 JTF_VARCHAR2_TABLE_100
2497: , p8_a5 JTF_NUMBER_TABLE
2498: , p8_a6 JTF_DATE_TABLE
2499: , p8_a7 JTF_DATE_TABLE
2493: , p8_a1 JTF_VARCHAR2_TABLE_100
2494: , p8_a2 JTF_NUMBER_TABLE
2495: , p8_a3 JTF_NUMBER_TABLE
2496: , p8_a4 JTF_VARCHAR2_TABLE_100
2497: , p8_a5 JTF_NUMBER_TABLE
2498: , p8_a6 JTF_DATE_TABLE
2499: , p8_a7 JTF_DATE_TABLE
2500: , p8_a8 JTF_VARCHAR2_TABLE_100
2501: , p8_a9 JTF_VARCHAR2_TABLE_100
2498: , p8_a6 JTF_DATE_TABLE
2499: , p8_a7 JTF_DATE_TABLE
2500: , p8_a8 JTF_VARCHAR2_TABLE_100
2501: , p8_a9 JTF_VARCHAR2_TABLE_100
2502: , p8_a10 JTF_NUMBER_TABLE
2503: , p8_a11 JTF_VARCHAR2_TABLE_100
2504: , p8_a12 JTF_NUMBER_TABLE
2505: , p8_a13 JTF_NUMBER_TABLE
2506: , p8_a14 JTF_VARCHAR2_TABLE_100
2500: , p8_a8 JTF_VARCHAR2_TABLE_100
2501: , p8_a9 JTF_VARCHAR2_TABLE_100
2502: , p8_a10 JTF_NUMBER_TABLE
2503: , p8_a11 JTF_VARCHAR2_TABLE_100
2504: , p8_a12 JTF_NUMBER_TABLE
2505: , p8_a13 JTF_NUMBER_TABLE
2506: , p8_a14 JTF_VARCHAR2_TABLE_100
2507: , p8_a15 JTF_NUMBER_TABLE
2508: , p8_a16 JTF_VARCHAR2_TABLE_100
2501: , p8_a9 JTF_VARCHAR2_TABLE_100
2502: , p8_a10 JTF_NUMBER_TABLE
2503: , p8_a11 JTF_VARCHAR2_TABLE_100
2504: , p8_a12 JTF_NUMBER_TABLE
2505: , p8_a13 JTF_NUMBER_TABLE
2506: , p8_a14 JTF_VARCHAR2_TABLE_100
2507: , p8_a15 JTF_NUMBER_TABLE
2508: , p8_a16 JTF_VARCHAR2_TABLE_100
2509: , p8_a17 JTF_NUMBER_TABLE
2503: , p8_a11 JTF_VARCHAR2_TABLE_100
2504: , p8_a12 JTF_NUMBER_TABLE
2505: , p8_a13 JTF_NUMBER_TABLE
2506: , p8_a14 JTF_VARCHAR2_TABLE_100
2507: , p8_a15 JTF_NUMBER_TABLE
2508: , p8_a16 JTF_VARCHAR2_TABLE_100
2509: , p8_a17 JTF_NUMBER_TABLE
2510: , p8_a18 JTF_NUMBER_TABLE
2511: , p8_a19 JTF_NUMBER_TABLE
2505: , p8_a13 JTF_NUMBER_TABLE
2506: , p8_a14 JTF_VARCHAR2_TABLE_100
2507: , p8_a15 JTF_NUMBER_TABLE
2508: , p8_a16 JTF_VARCHAR2_TABLE_100
2509: , p8_a17 JTF_NUMBER_TABLE
2510: , p8_a18 JTF_NUMBER_TABLE
2511: , p8_a19 JTF_NUMBER_TABLE
2512: , p8_a20 JTF_NUMBER_TABLE
2513: , p8_a21 JTF_VARCHAR2_TABLE_100
2506: , p8_a14 JTF_VARCHAR2_TABLE_100
2507: , p8_a15 JTF_NUMBER_TABLE
2508: , p8_a16 JTF_VARCHAR2_TABLE_100
2509: , p8_a17 JTF_NUMBER_TABLE
2510: , p8_a18 JTF_NUMBER_TABLE
2511: , p8_a19 JTF_NUMBER_TABLE
2512: , p8_a20 JTF_NUMBER_TABLE
2513: , p8_a21 JTF_VARCHAR2_TABLE_100
2514: , p8_a22 JTF_VARCHAR2_TABLE_100
2507: , p8_a15 JTF_NUMBER_TABLE
2508: , p8_a16 JTF_VARCHAR2_TABLE_100
2509: , p8_a17 JTF_NUMBER_TABLE
2510: , p8_a18 JTF_NUMBER_TABLE
2511: , p8_a19 JTF_NUMBER_TABLE
2512: , p8_a20 JTF_NUMBER_TABLE
2513: , p8_a21 JTF_VARCHAR2_TABLE_100
2514: , p8_a22 JTF_VARCHAR2_TABLE_100
2515: , p8_a23 JTF_VARCHAR2_TABLE_100
2508: , p8_a16 JTF_VARCHAR2_TABLE_100
2509: , p8_a17 JTF_NUMBER_TABLE
2510: , p8_a18 JTF_NUMBER_TABLE
2511: , p8_a19 JTF_NUMBER_TABLE
2512: , p8_a20 JTF_NUMBER_TABLE
2513: , p8_a21 JTF_VARCHAR2_TABLE_100
2514: , p8_a22 JTF_VARCHAR2_TABLE_100
2515: , p8_a23 JTF_VARCHAR2_TABLE_100
2516: , p8_a24 JTF_VARCHAR2_TABLE_300
2514: , p8_a22 JTF_VARCHAR2_TABLE_100
2515: , p8_a23 JTF_VARCHAR2_TABLE_100
2516: , p8_a24 JTF_VARCHAR2_TABLE_300
2517: , p8_a25 JTF_VARCHAR2_TABLE_100
2518: , p8_a26 JTF_NUMBER_TABLE
2519: , p8_a27 JTF_VARCHAR2_TABLE_100
2520: , p8_a28 JTF_VARCHAR2_TABLE_100
2521: , p8_a29 JTF_VARCHAR2_TABLE_300
2522: , p8_a30 JTF_VARCHAR2_TABLE_100
2526: , p8_a34 JTF_VARCHAR2_TABLE_300
2527: , p8_a35 JTF_VARCHAR2_TABLE_100
2528: , p8_a36 JTF_VARCHAR2_TABLE_300
2529: , p8_a37 JTF_VARCHAR2_TABLE_300
2530: , p8_a38 JTF_NUMBER_TABLE
2531: , p8_a39 JTF_VARCHAR2_TABLE_2000
2532: , p8_a40 JTF_VARCHAR2_TABLE_100
2533: , p8_a41 JTF_VARCHAR2_TABLE_300
2534: , p8_a42 JTF_VARCHAR2_TABLE_300
2544: , p8_a52 JTF_VARCHAR2_TABLE_300
2545: , p8_a53 JTF_VARCHAR2_TABLE_300
2546: , p8_a54 JTF_VARCHAR2_TABLE_300
2547: , p8_a55 JTF_VARCHAR2_TABLE_300
2548: , p8_a56 JTF_NUMBER_TABLE
2549: , p8_a57 JTF_NUMBER_TABLE
2550: , p8_a58 JTF_NUMBER_TABLE
2551: , p8_a59 JTF_NUMBER_TABLE
2552: , p8_a60 JTF_NUMBER_TABLE
2545: , p8_a53 JTF_VARCHAR2_TABLE_300
2546: , p8_a54 JTF_VARCHAR2_TABLE_300
2547: , p8_a55 JTF_VARCHAR2_TABLE_300
2548: , p8_a56 JTF_NUMBER_TABLE
2549: , p8_a57 JTF_NUMBER_TABLE
2550: , p8_a58 JTF_NUMBER_TABLE
2551: , p8_a59 JTF_NUMBER_TABLE
2552: , p8_a60 JTF_NUMBER_TABLE
2553: , p8_a61 JTF_NUMBER_TABLE
2546: , p8_a54 JTF_VARCHAR2_TABLE_300
2547: , p8_a55 JTF_VARCHAR2_TABLE_300
2548: , p8_a56 JTF_NUMBER_TABLE
2549: , p8_a57 JTF_NUMBER_TABLE
2550: , p8_a58 JTF_NUMBER_TABLE
2551: , p8_a59 JTF_NUMBER_TABLE
2552: , p8_a60 JTF_NUMBER_TABLE
2553: , p8_a61 JTF_NUMBER_TABLE
2554: , p8_a62 JTF_NUMBER_TABLE
2547: , p8_a55 JTF_VARCHAR2_TABLE_300
2548: , p8_a56 JTF_NUMBER_TABLE
2549: , p8_a57 JTF_NUMBER_TABLE
2550: , p8_a58 JTF_NUMBER_TABLE
2551: , p8_a59 JTF_NUMBER_TABLE
2552: , p8_a60 JTF_NUMBER_TABLE
2553: , p8_a61 JTF_NUMBER_TABLE
2554: , p8_a62 JTF_NUMBER_TABLE
2555: , p8_a63 JTF_NUMBER_TABLE
2548: , p8_a56 JTF_NUMBER_TABLE
2549: , p8_a57 JTF_NUMBER_TABLE
2550: , p8_a58 JTF_NUMBER_TABLE
2551: , p8_a59 JTF_NUMBER_TABLE
2552: , p8_a60 JTF_NUMBER_TABLE
2553: , p8_a61 JTF_NUMBER_TABLE
2554: , p8_a62 JTF_NUMBER_TABLE
2555: , p8_a63 JTF_NUMBER_TABLE
2556: , p8_a64 JTF_NUMBER_TABLE
2549: , p8_a57 JTF_NUMBER_TABLE
2550: , p8_a58 JTF_NUMBER_TABLE
2551: , p8_a59 JTF_NUMBER_TABLE
2552: , p8_a60 JTF_NUMBER_TABLE
2553: , p8_a61 JTF_NUMBER_TABLE
2554: , p8_a62 JTF_NUMBER_TABLE
2555: , p8_a63 JTF_NUMBER_TABLE
2556: , p8_a64 JTF_NUMBER_TABLE
2557: , p8_a65 JTF_NUMBER_TABLE
2550: , p8_a58 JTF_NUMBER_TABLE
2551: , p8_a59 JTF_NUMBER_TABLE
2552: , p8_a60 JTF_NUMBER_TABLE
2553: , p8_a61 JTF_NUMBER_TABLE
2554: , p8_a62 JTF_NUMBER_TABLE
2555: , p8_a63 JTF_NUMBER_TABLE
2556: , p8_a64 JTF_NUMBER_TABLE
2557: , p8_a65 JTF_NUMBER_TABLE
2558: , p8_a66 JTF_VARCHAR2_TABLE_100
2551: , p8_a59 JTF_NUMBER_TABLE
2552: , p8_a60 JTF_NUMBER_TABLE
2553: , p8_a61 JTF_NUMBER_TABLE
2554: , p8_a62 JTF_NUMBER_TABLE
2555: , p8_a63 JTF_NUMBER_TABLE
2556: , p8_a64 JTF_NUMBER_TABLE
2557: , p8_a65 JTF_NUMBER_TABLE
2558: , p8_a66 JTF_VARCHAR2_TABLE_100
2559: , p8_a67 JTF_NUMBER_TABLE
2552: , p8_a60 JTF_NUMBER_TABLE
2553: , p8_a61 JTF_NUMBER_TABLE
2554: , p8_a62 JTF_NUMBER_TABLE
2555: , p8_a63 JTF_NUMBER_TABLE
2556: , p8_a64 JTF_NUMBER_TABLE
2557: , p8_a65 JTF_NUMBER_TABLE
2558: , p8_a66 JTF_VARCHAR2_TABLE_100
2559: , p8_a67 JTF_NUMBER_TABLE
2560: , p8_a68 JTF_NUMBER_TABLE
2553: , p8_a61 JTF_NUMBER_TABLE
2554: , p8_a62 JTF_NUMBER_TABLE
2555: , p8_a63 JTF_NUMBER_TABLE
2556: , p8_a64 JTF_NUMBER_TABLE
2557: , p8_a65 JTF_NUMBER_TABLE
2558: , p8_a66 JTF_VARCHAR2_TABLE_100
2559: , p8_a67 JTF_NUMBER_TABLE
2560: , p8_a68 JTF_NUMBER_TABLE
2561: , p8_a69 JTF_VARCHAR2_TABLE_300
2555: , p8_a63 JTF_NUMBER_TABLE
2556: , p8_a64 JTF_NUMBER_TABLE
2557: , p8_a65 JTF_NUMBER_TABLE
2558: , p8_a66 JTF_VARCHAR2_TABLE_100
2559: , p8_a67 JTF_NUMBER_TABLE
2560: , p8_a68 JTF_NUMBER_TABLE
2561: , p8_a69 JTF_VARCHAR2_TABLE_300
2562: , p8_a70 JTF_VARCHAR2_TABLE_300
2563: , p9_a0 JTF_VARCHAR2_TABLE_100
2556: , p8_a64 JTF_NUMBER_TABLE
2557: , p8_a65 JTF_NUMBER_TABLE
2558: , p8_a66 JTF_VARCHAR2_TABLE_100
2559: , p8_a67 JTF_NUMBER_TABLE
2560: , p8_a68 JTF_NUMBER_TABLE
2561: , p8_a69 JTF_VARCHAR2_TABLE_300
2562: , p8_a70 JTF_VARCHAR2_TABLE_300
2563: , p9_a0 JTF_VARCHAR2_TABLE_100
2564: , p9_a1 JTF_VARCHAR2_TABLE_100
2564: , p9_a1 JTF_VARCHAR2_TABLE_100
2565: , p9_a2 JTF_VARCHAR2_TABLE_300
2566: , p9_a3 JTF_VARCHAR2_TABLE_300
2567: , p9_a4 JTF_VARCHAR2_TABLE_100
2568: , p9_a5 JTF_NUMBER_TABLE
2569: , p9_a6 JTF_NUMBER_TABLE
2570: , p9_a7 JTF_NUMBER_TABLE
2571: , p9_a8 JTF_NUMBER_TABLE
2572: , p9_a9 JTF_DATE_TABLE
2565: , p9_a2 JTF_VARCHAR2_TABLE_300
2566: , p9_a3 JTF_VARCHAR2_TABLE_300
2567: , p9_a4 JTF_VARCHAR2_TABLE_100
2568: , p9_a5 JTF_NUMBER_TABLE
2569: , p9_a6 JTF_NUMBER_TABLE
2570: , p9_a7 JTF_NUMBER_TABLE
2571: , p9_a8 JTF_NUMBER_TABLE
2572: , p9_a9 JTF_DATE_TABLE
2573: , p9_a10 JTF_DATE_TABLE
2566: , p9_a3 JTF_VARCHAR2_TABLE_300
2567: , p9_a4 JTF_VARCHAR2_TABLE_100
2568: , p9_a5 JTF_NUMBER_TABLE
2569: , p9_a6 JTF_NUMBER_TABLE
2570: , p9_a7 JTF_NUMBER_TABLE
2571: , p9_a8 JTF_NUMBER_TABLE
2572: , p9_a9 JTF_DATE_TABLE
2573: , p9_a10 JTF_DATE_TABLE
2574: , p9_a11 JTF_NUMBER_TABLE
2567: , p9_a4 JTF_VARCHAR2_TABLE_100
2568: , p9_a5 JTF_NUMBER_TABLE
2569: , p9_a6 JTF_NUMBER_TABLE
2570: , p9_a7 JTF_NUMBER_TABLE
2571: , p9_a8 JTF_NUMBER_TABLE
2572: , p9_a9 JTF_DATE_TABLE
2573: , p9_a10 JTF_DATE_TABLE
2574: , p9_a11 JTF_NUMBER_TABLE
2575: , p9_a12 JTF_VARCHAR2_TABLE_100
2570: , p9_a7 JTF_NUMBER_TABLE
2571: , p9_a8 JTF_NUMBER_TABLE
2572: , p9_a9 JTF_DATE_TABLE
2573: , p9_a10 JTF_DATE_TABLE
2574: , p9_a11 JTF_NUMBER_TABLE
2575: , p9_a12 JTF_VARCHAR2_TABLE_100
2576: , p9_a13 JTF_VARCHAR2_TABLE_100
2577: , p9_a14 JTF_VARCHAR2_TABLE_300
2578: , p9_a15 JTF_VARCHAR2_TABLE_300
2588: , p9_a25 JTF_VARCHAR2_TABLE_300
2589: , p9_a26 JTF_VARCHAR2_TABLE_300
2590: , p9_a27 JTF_VARCHAR2_TABLE_300
2591: , p9_a28 JTF_VARCHAR2_TABLE_300
2592: , p10_a0 JTF_NUMBER_TABLE
2593: , p10_a1 JTF_NUMBER_TABLE
2594: , p10_a2 JTF_NUMBER_TABLE
2595: , p10_a3 JTF_VARCHAR2_TABLE_100
2596: , p11_a0 JTF_NUMBER_TABLE
2589: , p9_a26 JTF_VARCHAR2_TABLE_300
2590: , p9_a27 JTF_VARCHAR2_TABLE_300
2591: , p9_a28 JTF_VARCHAR2_TABLE_300
2592: , p10_a0 JTF_NUMBER_TABLE
2593: , p10_a1 JTF_NUMBER_TABLE
2594: , p10_a2 JTF_NUMBER_TABLE
2595: , p10_a3 JTF_VARCHAR2_TABLE_100
2596: , p11_a0 JTF_NUMBER_TABLE
2597: , p11_a1 JTF_NUMBER_TABLE
2590: , p9_a27 JTF_VARCHAR2_TABLE_300
2591: , p9_a28 JTF_VARCHAR2_TABLE_300
2592: , p10_a0 JTF_NUMBER_TABLE
2593: , p10_a1 JTF_NUMBER_TABLE
2594: , p10_a2 JTF_NUMBER_TABLE
2595: , p10_a3 JTF_VARCHAR2_TABLE_100
2596: , p11_a0 JTF_NUMBER_TABLE
2597: , p11_a1 JTF_NUMBER_TABLE
2598: , p11_a2 JTF_NUMBER_TABLE
2592: , p10_a0 JTF_NUMBER_TABLE
2593: , p10_a1 JTF_NUMBER_TABLE
2594: , p10_a2 JTF_NUMBER_TABLE
2595: , p10_a3 JTF_VARCHAR2_TABLE_100
2596: , p11_a0 JTF_NUMBER_TABLE
2597: , p11_a1 JTF_NUMBER_TABLE
2598: , p11_a2 JTF_NUMBER_TABLE
2599: , p11_a3 JTF_VARCHAR2_TABLE_100
2600: , p11_a4 JTF_VARCHAR2_TABLE_100
2593: , p10_a1 JTF_NUMBER_TABLE
2594: , p10_a2 JTF_NUMBER_TABLE
2595: , p10_a3 JTF_VARCHAR2_TABLE_100
2596: , p11_a0 JTF_NUMBER_TABLE
2597: , p11_a1 JTF_NUMBER_TABLE
2598: , p11_a2 JTF_NUMBER_TABLE
2599: , p11_a3 JTF_VARCHAR2_TABLE_100
2600: , p11_a4 JTF_VARCHAR2_TABLE_100
2601: , p11_a5 JTF_VARCHAR2_TABLE_100
2594: , p10_a2 JTF_NUMBER_TABLE
2595: , p10_a3 JTF_VARCHAR2_TABLE_100
2596: , p11_a0 JTF_NUMBER_TABLE
2597: , p11_a1 JTF_NUMBER_TABLE
2598: , p11_a2 JTF_NUMBER_TABLE
2599: , p11_a3 JTF_VARCHAR2_TABLE_100
2600: , p11_a4 JTF_VARCHAR2_TABLE_100
2601: , p11_a5 JTF_VARCHAR2_TABLE_100
2602: , p11_a6 JTF_VARCHAR2_TABLE_100
2599: , p11_a3 JTF_VARCHAR2_TABLE_100
2600: , p11_a4 JTF_VARCHAR2_TABLE_100
2601: , p11_a5 JTF_VARCHAR2_TABLE_100
2602: , p11_a6 JTF_VARCHAR2_TABLE_100
2603: , p11_a7 JTF_NUMBER_TABLE
2604: , p11_a8 JTF_NUMBER_TABLE
2605: , p11_a9 JTF_NUMBER_TABLE
2606: , p11_a10 JTF_NUMBER_TABLE
2607: , p11_a11 JTF_VARCHAR2_TABLE_100
2600: , p11_a4 JTF_VARCHAR2_TABLE_100
2601: , p11_a5 JTF_VARCHAR2_TABLE_100
2602: , p11_a6 JTF_VARCHAR2_TABLE_100
2603: , p11_a7 JTF_NUMBER_TABLE
2604: , p11_a8 JTF_NUMBER_TABLE
2605: , p11_a9 JTF_NUMBER_TABLE
2606: , p11_a10 JTF_NUMBER_TABLE
2607: , p11_a11 JTF_VARCHAR2_TABLE_100
2608: , p11_a12 JTF_VARCHAR2_TABLE_100
2601: , p11_a5 JTF_VARCHAR2_TABLE_100
2602: , p11_a6 JTF_VARCHAR2_TABLE_100
2603: , p11_a7 JTF_NUMBER_TABLE
2604: , p11_a8 JTF_NUMBER_TABLE
2605: , p11_a9 JTF_NUMBER_TABLE
2606: , p11_a10 JTF_NUMBER_TABLE
2607: , p11_a11 JTF_VARCHAR2_TABLE_100
2608: , p11_a12 JTF_VARCHAR2_TABLE_100
2609: , p11_a13 JTF_VARCHAR2_TABLE_100
2602: , p11_a6 JTF_VARCHAR2_TABLE_100
2603: , p11_a7 JTF_NUMBER_TABLE
2604: , p11_a8 JTF_NUMBER_TABLE
2605: , p11_a9 JTF_NUMBER_TABLE
2606: , p11_a10 JTF_NUMBER_TABLE
2607: , p11_a11 JTF_VARCHAR2_TABLE_100
2608: , p11_a12 JTF_VARCHAR2_TABLE_100
2609: , p11_a13 JTF_VARCHAR2_TABLE_100
2610: , p11_a14 JTF_NUMBER_TABLE
2606: , p11_a10 JTF_NUMBER_TABLE
2607: , p11_a11 JTF_VARCHAR2_TABLE_100
2608: , p11_a12 JTF_VARCHAR2_TABLE_100
2609: , p11_a13 JTF_VARCHAR2_TABLE_100
2610: , p11_a14 JTF_NUMBER_TABLE
2611: , p11_a15 JTF_NUMBER_TABLE
2612: , p11_a16 JTF_NUMBER_TABLE
2613: , p11_a17 JTF_VARCHAR2_TABLE_100
2614: , p11_a18 JTF_VARCHAR2_TABLE_100
2607: , p11_a11 JTF_VARCHAR2_TABLE_100
2608: , p11_a12 JTF_VARCHAR2_TABLE_100
2609: , p11_a13 JTF_VARCHAR2_TABLE_100
2610: , p11_a14 JTF_NUMBER_TABLE
2611: , p11_a15 JTF_NUMBER_TABLE
2612: , p11_a16 JTF_NUMBER_TABLE
2613: , p11_a17 JTF_VARCHAR2_TABLE_100
2614: , p11_a18 JTF_VARCHAR2_TABLE_100
2615: , p11_a19 JTF_NUMBER_TABLE
2608: , p11_a12 JTF_VARCHAR2_TABLE_100
2609: , p11_a13 JTF_VARCHAR2_TABLE_100
2610: , p11_a14 JTF_NUMBER_TABLE
2611: , p11_a15 JTF_NUMBER_TABLE
2612: , p11_a16 JTF_NUMBER_TABLE
2613: , p11_a17 JTF_VARCHAR2_TABLE_100
2614: , p11_a18 JTF_VARCHAR2_TABLE_100
2615: , p11_a19 JTF_NUMBER_TABLE
2616: , p11_a20 JTF_NUMBER_TABLE
2611: , p11_a15 JTF_NUMBER_TABLE
2612: , p11_a16 JTF_NUMBER_TABLE
2613: , p11_a17 JTF_VARCHAR2_TABLE_100
2614: , p11_a18 JTF_VARCHAR2_TABLE_100
2615: , p11_a19 JTF_NUMBER_TABLE
2616: , p11_a20 JTF_NUMBER_TABLE
2617: , p11_a21 JTF_NUMBER_TABLE
2618: , p11_a22 JTF_VARCHAR2_TABLE_100
2619: , p12_a0 JTF_NUMBER_TABLE
2612: , p11_a16 JTF_NUMBER_TABLE
2613: , p11_a17 JTF_VARCHAR2_TABLE_100
2614: , p11_a18 JTF_VARCHAR2_TABLE_100
2615: , p11_a19 JTF_NUMBER_TABLE
2616: , p11_a20 JTF_NUMBER_TABLE
2617: , p11_a21 JTF_NUMBER_TABLE
2618: , p11_a22 JTF_VARCHAR2_TABLE_100
2619: , p12_a0 JTF_NUMBER_TABLE
2620: , p12_a1 JTF_NUMBER_TABLE
2613: , p11_a17 JTF_VARCHAR2_TABLE_100
2614: , p11_a18 JTF_VARCHAR2_TABLE_100
2615: , p11_a19 JTF_NUMBER_TABLE
2616: , p11_a20 JTF_NUMBER_TABLE
2617: , p11_a21 JTF_NUMBER_TABLE
2618: , p11_a22 JTF_VARCHAR2_TABLE_100
2619: , p12_a0 JTF_NUMBER_TABLE
2620: , p12_a1 JTF_NUMBER_TABLE
2621: , p12_a2 JTF_NUMBER_TABLE
2615: , p11_a19 JTF_NUMBER_TABLE
2616: , p11_a20 JTF_NUMBER_TABLE
2617: , p11_a21 JTF_NUMBER_TABLE
2618: , p11_a22 JTF_VARCHAR2_TABLE_100
2619: , p12_a0 JTF_NUMBER_TABLE
2620: , p12_a1 JTF_NUMBER_TABLE
2621: , p12_a2 JTF_NUMBER_TABLE
2622: , p12_a3 JTF_NUMBER_TABLE
2623: , p12_a4 JTF_VARCHAR2_TABLE_100
2616: , p11_a20 JTF_NUMBER_TABLE
2617: , p11_a21 JTF_NUMBER_TABLE
2618: , p11_a22 JTF_VARCHAR2_TABLE_100
2619: , p12_a0 JTF_NUMBER_TABLE
2620: , p12_a1 JTF_NUMBER_TABLE
2621: , p12_a2 JTF_NUMBER_TABLE
2622: , p12_a3 JTF_NUMBER_TABLE
2623: , p12_a4 JTF_VARCHAR2_TABLE_100
2624: , p12_a5 JTF_VARCHAR2_TABLE_100
2617: , p11_a21 JTF_NUMBER_TABLE
2618: , p11_a22 JTF_VARCHAR2_TABLE_100
2619: , p12_a0 JTF_NUMBER_TABLE
2620: , p12_a1 JTF_NUMBER_TABLE
2621: , p12_a2 JTF_NUMBER_TABLE
2622: , p12_a3 JTF_NUMBER_TABLE
2623: , p12_a4 JTF_VARCHAR2_TABLE_100
2624: , p12_a5 JTF_VARCHAR2_TABLE_100
2625: , p12_a6 JTF_VARCHAR2_TABLE_100
2618: , p11_a22 JTF_VARCHAR2_TABLE_100
2619: , p12_a0 JTF_NUMBER_TABLE
2620: , p12_a1 JTF_NUMBER_TABLE
2621: , p12_a2 JTF_NUMBER_TABLE
2622: , p12_a3 JTF_NUMBER_TABLE
2623: , p12_a4 JTF_VARCHAR2_TABLE_100
2624: , p12_a5 JTF_VARCHAR2_TABLE_100
2625: , p12_a6 JTF_VARCHAR2_TABLE_100
2626: , p12_a7 JTF_NUMBER_TABLE
2622: , p12_a3 JTF_NUMBER_TABLE
2623: , p12_a4 JTF_VARCHAR2_TABLE_100
2624: , p12_a5 JTF_VARCHAR2_TABLE_100
2625: , p12_a6 JTF_VARCHAR2_TABLE_100
2626: , p12_a7 JTF_NUMBER_TABLE
2627: , p12_a8 JTF_VARCHAR2_TABLE_100
2628: , p12_a9 JTF_VARCHAR2_TABLE_100
2629: , p12_a10 JTF_VARCHAR2_TABLE_100
2630: , p12_a11 JTF_VARCHAR2_TABLE_100
2627: , p12_a8 JTF_VARCHAR2_TABLE_100
2628: , p12_a9 JTF_VARCHAR2_TABLE_100
2629: , p12_a10 JTF_VARCHAR2_TABLE_100
2630: , p12_a11 JTF_VARCHAR2_TABLE_100
2631: , p12_a12 JTF_NUMBER_TABLE
2632: , p12_a13 JTF_VARCHAR2_TABLE_100
2633: , p12_a14 JTF_NUMBER_TABLE
2634: , p12_a15 JTF_NUMBER_TABLE
2635: , p12_a16 JTF_NUMBER_TABLE
2629: , p12_a10 JTF_VARCHAR2_TABLE_100
2630: , p12_a11 JTF_VARCHAR2_TABLE_100
2631: , p12_a12 JTF_NUMBER_TABLE
2632: , p12_a13 JTF_VARCHAR2_TABLE_100
2633: , p12_a14 JTF_NUMBER_TABLE
2634: , p12_a15 JTF_NUMBER_TABLE
2635: , p12_a16 JTF_NUMBER_TABLE
2636: , p12_a17 JTF_NUMBER_TABLE
2637: , p12_a18 JTF_VARCHAR2_TABLE_100
2630: , p12_a11 JTF_VARCHAR2_TABLE_100
2631: , p12_a12 JTF_NUMBER_TABLE
2632: , p12_a13 JTF_VARCHAR2_TABLE_100
2633: , p12_a14 JTF_NUMBER_TABLE
2634: , p12_a15 JTF_NUMBER_TABLE
2635: , p12_a16 JTF_NUMBER_TABLE
2636: , p12_a17 JTF_NUMBER_TABLE
2637: , p12_a18 JTF_VARCHAR2_TABLE_100
2638: , p12_a19 JTF_DATE_TABLE
2631: , p12_a12 JTF_NUMBER_TABLE
2632: , p12_a13 JTF_VARCHAR2_TABLE_100
2633: , p12_a14 JTF_NUMBER_TABLE
2634: , p12_a15 JTF_NUMBER_TABLE
2635: , p12_a16 JTF_NUMBER_TABLE
2636: , p12_a17 JTF_NUMBER_TABLE
2637: , p12_a18 JTF_VARCHAR2_TABLE_100
2638: , p12_a19 JTF_DATE_TABLE
2639: , p12_a20 JTF_DATE_TABLE
2632: , p12_a13 JTF_VARCHAR2_TABLE_100
2633: , p12_a14 JTF_NUMBER_TABLE
2634: , p12_a15 JTF_NUMBER_TABLE
2635: , p12_a16 JTF_NUMBER_TABLE
2636: , p12_a17 JTF_NUMBER_TABLE
2637: , p12_a18 JTF_VARCHAR2_TABLE_100
2638: , p12_a19 JTF_DATE_TABLE
2639: , p12_a20 JTF_DATE_TABLE
2640: , p12_a21 JTF_VARCHAR2_TABLE_100
2638: , p12_a19 JTF_DATE_TABLE
2639: , p12_a20 JTF_DATE_TABLE
2640: , p12_a21 JTF_VARCHAR2_TABLE_100
2641: , p12_a22 JTF_DATE_TABLE
2642: , p12_a23 JTF_NUMBER_TABLE
2643: , p12_a24 JTF_DATE_TABLE
2644: , p12_a25 JTF_NUMBER_TABLE
2645: , p12_a26 JTF_NUMBER_TABLE
2646: , p12_a27 JTF_NUMBER_TABLE
2640: , p12_a21 JTF_VARCHAR2_TABLE_100
2641: , p12_a22 JTF_DATE_TABLE
2642: , p12_a23 JTF_NUMBER_TABLE
2643: , p12_a24 JTF_DATE_TABLE
2644: , p12_a25 JTF_NUMBER_TABLE
2645: , p12_a26 JTF_NUMBER_TABLE
2646: , p12_a27 JTF_NUMBER_TABLE
2647: , p12_a28 JTF_NUMBER_TABLE
2648: , p12_a29 JTF_NUMBER_TABLE
2641: , p12_a22 JTF_DATE_TABLE
2642: , p12_a23 JTF_NUMBER_TABLE
2643: , p12_a24 JTF_DATE_TABLE
2644: , p12_a25 JTF_NUMBER_TABLE
2645: , p12_a26 JTF_NUMBER_TABLE
2646: , p12_a27 JTF_NUMBER_TABLE
2647: , p12_a28 JTF_NUMBER_TABLE
2648: , p12_a29 JTF_NUMBER_TABLE
2649: , p12_a30 JTF_NUMBER_TABLE
2642: , p12_a23 JTF_NUMBER_TABLE
2643: , p12_a24 JTF_DATE_TABLE
2644: , p12_a25 JTF_NUMBER_TABLE
2645: , p12_a26 JTF_NUMBER_TABLE
2646: , p12_a27 JTF_NUMBER_TABLE
2647: , p12_a28 JTF_NUMBER_TABLE
2648: , p12_a29 JTF_NUMBER_TABLE
2649: , p12_a30 JTF_NUMBER_TABLE
2650: , p12_a31 JTF_VARCHAR2_TABLE_100
2643: , p12_a24 JTF_DATE_TABLE
2644: , p12_a25 JTF_NUMBER_TABLE
2645: , p12_a26 JTF_NUMBER_TABLE
2646: , p12_a27 JTF_NUMBER_TABLE
2647: , p12_a28 JTF_NUMBER_TABLE
2648: , p12_a29 JTF_NUMBER_TABLE
2649: , p12_a30 JTF_NUMBER_TABLE
2650: , p12_a31 JTF_VARCHAR2_TABLE_100
2651: , p12_a32 JTF_NUMBER_TABLE
2644: , p12_a25 JTF_NUMBER_TABLE
2645: , p12_a26 JTF_NUMBER_TABLE
2646: , p12_a27 JTF_NUMBER_TABLE
2647: , p12_a28 JTF_NUMBER_TABLE
2648: , p12_a29 JTF_NUMBER_TABLE
2649: , p12_a30 JTF_NUMBER_TABLE
2650: , p12_a31 JTF_VARCHAR2_TABLE_100
2651: , p12_a32 JTF_NUMBER_TABLE
2652: , p12_a33 JTF_VARCHAR2_TABLE_100
2645: , p12_a26 JTF_NUMBER_TABLE
2646: , p12_a27 JTF_NUMBER_TABLE
2647: , p12_a28 JTF_NUMBER_TABLE
2648: , p12_a29 JTF_NUMBER_TABLE
2649: , p12_a30 JTF_NUMBER_TABLE
2650: , p12_a31 JTF_VARCHAR2_TABLE_100
2651: , p12_a32 JTF_NUMBER_TABLE
2652: , p12_a33 JTF_VARCHAR2_TABLE_100
2653: , p12_a34 JTF_VARCHAR2_TABLE_100
2647: , p12_a28 JTF_NUMBER_TABLE
2648: , p12_a29 JTF_NUMBER_TABLE
2649: , p12_a30 JTF_NUMBER_TABLE
2650: , p12_a31 JTF_VARCHAR2_TABLE_100
2651: , p12_a32 JTF_NUMBER_TABLE
2652: , p12_a33 JTF_VARCHAR2_TABLE_100
2653: , p12_a34 JTF_VARCHAR2_TABLE_100
2654: , p13_a0 JTF_NUMBER_TABLE
2655: , p13_a1 JTF_NUMBER_TABLE
2650: , p12_a31 JTF_VARCHAR2_TABLE_100
2651: , p12_a32 JTF_NUMBER_TABLE
2652: , p12_a33 JTF_VARCHAR2_TABLE_100
2653: , p12_a34 JTF_VARCHAR2_TABLE_100
2654: , p13_a0 JTF_NUMBER_TABLE
2655: , p13_a1 JTF_NUMBER_TABLE
2656: , p13_a2 JTF_VARCHAR2_TABLE_100
2657: , p13_a3 JTF_NUMBER_TABLE
2658: , p13_a4 JTF_NUMBER_TABLE
2651: , p12_a32 JTF_NUMBER_TABLE
2652: , p12_a33 JTF_VARCHAR2_TABLE_100
2653: , p12_a34 JTF_VARCHAR2_TABLE_100
2654: , p13_a0 JTF_NUMBER_TABLE
2655: , p13_a1 JTF_NUMBER_TABLE
2656: , p13_a2 JTF_VARCHAR2_TABLE_100
2657: , p13_a3 JTF_NUMBER_TABLE
2658: , p13_a4 JTF_NUMBER_TABLE
2659: , p13_a5 JTF_DATE_TABLE
2653: , p12_a34 JTF_VARCHAR2_TABLE_100
2654: , p13_a0 JTF_NUMBER_TABLE
2655: , p13_a1 JTF_NUMBER_TABLE
2656: , p13_a2 JTF_VARCHAR2_TABLE_100
2657: , p13_a3 JTF_NUMBER_TABLE
2658: , p13_a4 JTF_NUMBER_TABLE
2659: , p13_a5 JTF_DATE_TABLE
2660: , p13_a6 JTF_DATE_TABLE
2661: , p13_a7 JTF_VARCHAR2_TABLE_100
2654: , p13_a0 JTF_NUMBER_TABLE
2655: , p13_a1 JTF_NUMBER_TABLE
2656: , p13_a2 JTF_VARCHAR2_TABLE_100
2657: , p13_a3 JTF_NUMBER_TABLE
2658: , p13_a4 JTF_NUMBER_TABLE
2659: , p13_a5 JTF_DATE_TABLE
2660: , p13_a6 JTF_DATE_TABLE
2661: , p13_a7 JTF_VARCHAR2_TABLE_100
2662: , p14_a0 JTF_NUMBER_TABLE
2658: , p13_a4 JTF_NUMBER_TABLE
2659: , p13_a5 JTF_DATE_TABLE
2660: , p13_a6 JTF_DATE_TABLE
2661: , p13_a7 JTF_VARCHAR2_TABLE_100
2662: , p14_a0 JTF_NUMBER_TABLE
2663: , p14_a1 JTF_NUMBER_TABLE
2664: , p14_a2 JTF_NUMBER_TABLE
2665: , p14_a3 JTF_NUMBER_TABLE
2666: , p14_a4 JTF_NUMBER_TABLE
2659: , p13_a5 JTF_DATE_TABLE
2660: , p13_a6 JTF_DATE_TABLE
2661: , p13_a7 JTF_VARCHAR2_TABLE_100
2662: , p14_a0 JTF_NUMBER_TABLE
2663: , p14_a1 JTF_NUMBER_TABLE
2664: , p14_a2 JTF_NUMBER_TABLE
2665: , p14_a3 JTF_NUMBER_TABLE
2666: , p14_a4 JTF_NUMBER_TABLE
2667: , p14_a5 JTF_VARCHAR2_TABLE_100
2660: , p13_a6 JTF_DATE_TABLE
2661: , p13_a7 JTF_VARCHAR2_TABLE_100
2662: , p14_a0 JTF_NUMBER_TABLE
2663: , p14_a1 JTF_NUMBER_TABLE
2664: , p14_a2 JTF_NUMBER_TABLE
2665: , p14_a3 JTF_NUMBER_TABLE
2666: , p14_a4 JTF_NUMBER_TABLE
2667: , p14_a5 JTF_VARCHAR2_TABLE_100
2668: , p14_a6 JTF_VARCHAR2_TABLE_100
2661: , p13_a7 JTF_VARCHAR2_TABLE_100
2662: , p14_a0 JTF_NUMBER_TABLE
2663: , p14_a1 JTF_NUMBER_TABLE
2664: , p14_a2 JTF_NUMBER_TABLE
2665: , p14_a3 JTF_NUMBER_TABLE
2666: , p14_a4 JTF_NUMBER_TABLE
2667: , p14_a5 JTF_VARCHAR2_TABLE_100
2668: , p14_a6 JTF_VARCHAR2_TABLE_100
2669: , p14_a7 JTF_VARCHAR2_TABLE_100
2662: , p14_a0 JTF_NUMBER_TABLE
2663: , p14_a1 JTF_NUMBER_TABLE
2664: , p14_a2 JTF_NUMBER_TABLE
2665: , p14_a3 JTF_NUMBER_TABLE
2666: , p14_a4 JTF_NUMBER_TABLE
2667: , p14_a5 JTF_VARCHAR2_TABLE_100
2668: , p14_a6 JTF_VARCHAR2_TABLE_100
2669: , p14_a7 JTF_VARCHAR2_TABLE_100
2670: , p14_a8 JTF_NUMBER_TABLE
2666: , p14_a4 JTF_NUMBER_TABLE
2667: , p14_a5 JTF_VARCHAR2_TABLE_100
2668: , p14_a6 JTF_VARCHAR2_TABLE_100
2669: , p14_a7 JTF_VARCHAR2_TABLE_100
2670: , p14_a8 JTF_NUMBER_TABLE
2671: , p14_a9 JTF_VARCHAR2_TABLE_100
2672: , p14_a10 JTF_DATE_TABLE
2673: , p14_a11 JTF_DATE_TABLE
2674: , p14_a12 JTF_VARCHAR2_TABLE_100
2671: , p14_a9 JTF_VARCHAR2_TABLE_100
2672: , p14_a10 JTF_DATE_TABLE
2673: , p14_a11 JTF_DATE_TABLE
2674: , p14_a12 JTF_VARCHAR2_TABLE_100
2675: , p14_a13 JTF_NUMBER_TABLE
2676: , p14_a14 JTF_VARCHAR2_TABLE_100
2677: , p15_a0 JTF_NUMBER_TABLE
2678: , p15_a1 JTF_NUMBER_TABLE
2679: , p15_a2 JTF_VARCHAR2_TABLE_100
2673: , p14_a11 JTF_DATE_TABLE
2674: , p14_a12 JTF_VARCHAR2_TABLE_100
2675: , p14_a13 JTF_NUMBER_TABLE
2676: , p14_a14 JTF_VARCHAR2_TABLE_100
2677: , p15_a0 JTF_NUMBER_TABLE
2678: , p15_a1 JTF_NUMBER_TABLE
2679: , p15_a2 JTF_VARCHAR2_TABLE_100
2680: , p15_a3 JTF_NUMBER_TABLE
2681: , p15_a4 JTF_VARCHAR2_TABLE_100
2674: , p14_a12 JTF_VARCHAR2_TABLE_100
2675: , p14_a13 JTF_NUMBER_TABLE
2676: , p14_a14 JTF_VARCHAR2_TABLE_100
2677: , p15_a0 JTF_NUMBER_TABLE
2678: , p15_a1 JTF_NUMBER_TABLE
2679: , p15_a2 JTF_VARCHAR2_TABLE_100
2680: , p15_a3 JTF_NUMBER_TABLE
2681: , p15_a4 JTF_VARCHAR2_TABLE_100
2682: , p15_a5 JTF_VARCHAR2_TABLE_100
2676: , p14_a14 JTF_VARCHAR2_TABLE_100
2677: , p15_a0 JTF_NUMBER_TABLE
2678: , p15_a1 JTF_NUMBER_TABLE
2679: , p15_a2 JTF_VARCHAR2_TABLE_100
2680: , p15_a3 JTF_NUMBER_TABLE
2681: , p15_a4 JTF_VARCHAR2_TABLE_100
2682: , p15_a5 JTF_VARCHAR2_TABLE_100
2683: , p15_a6 JTF_DATE_TABLE
2684: , p15_a7 JTF_DATE_TABLE
2681: , p15_a4 JTF_VARCHAR2_TABLE_100
2682: , p15_a5 JTF_VARCHAR2_TABLE_100
2683: , p15_a6 JTF_DATE_TABLE
2684: , p15_a7 JTF_DATE_TABLE
2685: , p15_a8 JTF_NUMBER_TABLE
2686: , p15_a9 JTF_NUMBER_TABLE
2687: , p15_a10 JTF_DATE_TABLE
2688: , p15_a11 JTF_NUMBER_TABLE
2689: , p15_a12 JTF_DATE_TABLE
2682: , p15_a5 JTF_VARCHAR2_TABLE_100
2683: , p15_a6 JTF_DATE_TABLE
2684: , p15_a7 JTF_DATE_TABLE
2685: , p15_a8 JTF_NUMBER_TABLE
2686: , p15_a9 JTF_NUMBER_TABLE
2687: , p15_a10 JTF_DATE_TABLE
2688: , p15_a11 JTF_NUMBER_TABLE
2689: , p15_a12 JTF_DATE_TABLE
2690: , p15_a13 JTF_NUMBER_TABLE
2684: , p15_a7 JTF_DATE_TABLE
2685: , p15_a8 JTF_NUMBER_TABLE
2686: , p15_a9 JTF_NUMBER_TABLE
2687: , p15_a10 JTF_DATE_TABLE
2688: , p15_a11 JTF_NUMBER_TABLE
2689: , p15_a12 JTF_DATE_TABLE
2690: , p15_a13 JTF_NUMBER_TABLE
2691: , p15_a14 JTF_NUMBER_TABLE
2692: , p15_a15 JTF_NUMBER_TABLE
2686: , p15_a9 JTF_NUMBER_TABLE
2687: , p15_a10 JTF_DATE_TABLE
2688: , p15_a11 JTF_NUMBER_TABLE
2689: , p15_a12 JTF_DATE_TABLE
2690: , p15_a13 JTF_NUMBER_TABLE
2691: , p15_a14 JTF_NUMBER_TABLE
2692: , p15_a15 JTF_NUMBER_TABLE
2693: , p15_a16 JTF_VARCHAR2_TABLE_100
2694: , p16_a0 JTF_NUMBER_TABLE
2687: , p15_a10 JTF_DATE_TABLE
2688: , p15_a11 JTF_NUMBER_TABLE
2689: , p15_a12 JTF_DATE_TABLE
2690: , p15_a13 JTF_NUMBER_TABLE
2691: , p15_a14 JTF_NUMBER_TABLE
2692: , p15_a15 JTF_NUMBER_TABLE
2693: , p15_a16 JTF_VARCHAR2_TABLE_100
2694: , p16_a0 JTF_NUMBER_TABLE
2695: , p16_a1 JTF_DATE_TABLE
2688: , p15_a11 JTF_NUMBER_TABLE
2689: , p15_a12 JTF_DATE_TABLE
2690: , p15_a13 JTF_NUMBER_TABLE
2691: , p15_a14 JTF_NUMBER_TABLE
2692: , p15_a15 JTF_NUMBER_TABLE
2693: , p15_a16 JTF_VARCHAR2_TABLE_100
2694: , p16_a0 JTF_NUMBER_TABLE
2695: , p16_a1 JTF_DATE_TABLE
2696: , p16_a2 JTF_NUMBER_TABLE
2690: , p15_a13 JTF_NUMBER_TABLE
2691: , p15_a14 JTF_NUMBER_TABLE
2692: , p15_a15 JTF_NUMBER_TABLE
2693: , p15_a16 JTF_VARCHAR2_TABLE_100
2694: , p16_a0 JTF_NUMBER_TABLE
2695: , p16_a1 JTF_DATE_TABLE
2696: , p16_a2 JTF_NUMBER_TABLE
2697: , p16_a3 JTF_DATE_TABLE
2698: , p16_a4 JTF_NUMBER_TABLE
2692: , p15_a15 JTF_NUMBER_TABLE
2693: , p15_a16 JTF_VARCHAR2_TABLE_100
2694: , p16_a0 JTF_NUMBER_TABLE
2695: , p16_a1 JTF_DATE_TABLE
2696: , p16_a2 JTF_NUMBER_TABLE
2697: , p16_a3 JTF_DATE_TABLE
2698: , p16_a4 JTF_NUMBER_TABLE
2699: , p16_a5 JTF_NUMBER_TABLE
2700: , p16_a6 JTF_NUMBER_TABLE
2694: , p16_a0 JTF_NUMBER_TABLE
2695: , p16_a1 JTF_DATE_TABLE
2696: , p16_a2 JTF_NUMBER_TABLE
2697: , p16_a3 JTF_DATE_TABLE
2698: , p16_a4 JTF_NUMBER_TABLE
2699: , p16_a5 JTF_NUMBER_TABLE
2700: , p16_a6 JTF_NUMBER_TABLE
2701: , p16_a7 JTF_VARCHAR2_TABLE_100
2702: , p16_a8 JTF_VARCHAR2_TABLE_100
2695: , p16_a1 JTF_DATE_TABLE
2696: , p16_a2 JTF_NUMBER_TABLE
2697: , p16_a3 JTF_DATE_TABLE
2698: , p16_a4 JTF_NUMBER_TABLE
2699: , p16_a5 JTF_NUMBER_TABLE
2700: , p16_a6 JTF_NUMBER_TABLE
2701: , p16_a7 JTF_VARCHAR2_TABLE_100
2702: , p16_a8 JTF_VARCHAR2_TABLE_100
2703: , p16_a9 JTF_VARCHAR2_TABLE_300
2696: , p16_a2 JTF_NUMBER_TABLE
2697: , p16_a3 JTF_DATE_TABLE
2698: , p16_a4 JTF_NUMBER_TABLE
2699: , p16_a5 JTF_NUMBER_TABLE
2700: , p16_a6 JTF_NUMBER_TABLE
2701: , p16_a7 JTF_VARCHAR2_TABLE_100
2702: , p16_a8 JTF_VARCHAR2_TABLE_100
2703: , p16_a9 JTF_VARCHAR2_TABLE_300
2704: , p16_a10 JTF_DATE_TABLE
2702: , p16_a8 JTF_VARCHAR2_TABLE_100
2703: , p16_a9 JTF_VARCHAR2_TABLE_300
2704: , p16_a10 JTF_DATE_TABLE
2705: , p16_a11 JTF_DATE_TABLE
2706: , p16_a12 JTF_NUMBER_TABLE
2707: , p16_a13 JTF_NUMBER_TABLE
2708: , p16_a14 JTF_VARCHAR2_TABLE_100
2709: , p16_a15 JTF_VARCHAR2_TABLE_300
2710: , p16_a16 JTF_VARCHAR2_TABLE_300
2703: , p16_a9 JTF_VARCHAR2_TABLE_300
2704: , p16_a10 JTF_DATE_TABLE
2705: , p16_a11 JTF_DATE_TABLE
2706: , p16_a12 JTF_NUMBER_TABLE
2707: , p16_a13 JTF_NUMBER_TABLE
2708: , p16_a14 JTF_VARCHAR2_TABLE_100
2709: , p16_a15 JTF_VARCHAR2_TABLE_300
2710: , p16_a16 JTF_VARCHAR2_TABLE_300
2711: , p16_a17 JTF_VARCHAR2_TABLE_300
2721: , p16_a27 JTF_VARCHAR2_TABLE_300
2722: , p16_a28 JTF_VARCHAR2_TABLE_300
2723: , p16_a29 JTF_VARCHAR2_TABLE_300
2724: , p16_a30 JTF_VARCHAR2_TABLE_100
2725: , p16_a31 JTF_NUMBER_TABLE
2726: , p16_a32 JTF_VARCHAR2_TABLE_100
2727: , x_qp_list_header_id out nocopy NUMBER
2728: , x_error_location out nocopy NUMBER
2729: )
3219: , p6_a79 NUMBER
3220: , p6_a80 VARCHAR2
3221: , p6_a81 VARCHAR2
3222: , p6_a82 NUMBER
3223: , p7_a0 JTF_NUMBER_TABLE
3224: , p7_a1 JTF_NUMBER_TABLE
3225: , p7_a2 JTF_NUMBER_TABLE
3226: , p7_a3 JTF_NUMBER_TABLE
3227: , p7_a4 JTF_VARCHAR2_TABLE_100
3220: , p6_a80 VARCHAR2
3221: , p6_a81 VARCHAR2
3222: , p6_a82 NUMBER
3223: , p7_a0 JTF_NUMBER_TABLE
3224: , p7_a1 JTF_NUMBER_TABLE
3225: , p7_a2 JTF_NUMBER_TABLE
3226: , p7_a3 JTF_NUMBER_TABLE
3227: , p7_a4 JTF_VARCHAR2_TABLE_100
3228: , p7_a5 JTF_VARCHAR2_TABLE_100
3221: , p6_a81 VARCHAR2
3222: , p6_a82 NUMBER
3223: , p7_a0 JTF_NUMBER_TABLE
3224: , p7_a1 JTF_NUMBER_TABLE
3225: , p7_a2 JTF_NUMBER_TABLE
3226: , p7_a3 JTF_NUMBER_TABLE
3227: , p7_a4 JTF_VARCHAR2_TABLE_100
3228: , p7_a5 JTF_VARCHAR2_TABLE_100
3229: , p7_a6 JTF_VARCHAR2_TABLE_100
3222: , p6_a82 NUMBER
3223: , p7_a0 JTF_NUMBER_TABLE
3224: , p7_a1 JTF_NUMBER_TABLE
3225: , p7_a2 JTF_NUMBER_TABLE
3226: , p7_a3 JTF_NUMBER_TABLE
3227: , p7_a4 JTF_VARCHAR2_TABLE_100
3228: , p7_a5 JTF_VARCHAR2_TABLE_100
3229: , p7_a6 JTF_VARCHAR2_TABLE_100
3230: , p7_a7 JTF_NUMBER_TABLE
3226: , p7_a3 JTF_NUMBER_TABLE
3227: , p7_a4 JTF_VARCHAR2_TABLE_100
3228: , p7_a5 JTF_VARCHAR2_TABLE_100
3229: , p7_a6 JTF_VARCHAR2_TABLE_100
3230: , p7_a7 JTF_NUMBER_TABLE
3231: , p7_a8 JTF_VARCHAR2_TABLE_100
3232: , p7_a9 JTF_VARCHAR2_TABLE_100
3233: , p7_a10 JTF_VARCHAR2_TABLE_100
3234: , p7_a11 JTF_VARCHAR2_TABLE_100
3231: , p7_a8 JTF_VARCHAR2_TABLE_100
3232: , p7_a9 JTF_VARCHAR2_TABLE_100
3233: , p7_a10 JTF_VARCHAR2_TABLE_100
3234: , p7_a11 JTF_VARCHAR2_TABLE_100
3235: , p7_a12 JTF_NUMBER_TABLE
3236: , p7_a13 JTF_NUMBER_TABLE
3237: , p7_a14 JTF_VARCHAR2_TABLE_100
3238: , p7_a15 JTF_NUMBER_TABLE
3239: , p7_a16 JTF_NUMBER_TABLE
3232: , p7_a9 JTF_VARCHAR2_TABLE_100
3233: , p7_a10 JTF_VARCHAR2_TABLE_100
3234: , p7_a11 JTF_VARCHAR2_TABLE_100
3235: , p7_a12 JTF_NUMBER_TABLE
3236: , p7_a13 JTF_NUMBER_TABLE
3237: , p7_a14 JTF_VARCHAR2_TABLE_100
3238: , p7_a15 JTF_NUMBER_TABLE
3239: , p7_a16 JTF_NUMBER_TABLE
3240: , p7_a17 JTF_VARCHAR2_TABLE_300
3234: , p7_a11 JTF_VARCHAR2_TABLE_100
3235: , p7_a12 JTF_NUMBER_TABLE
3236: , p7_a13 JTF_NUMBER_TABLE
3237: , p7_a14 JTF_VARCHAR2_TABLE_100
3238: , p7_a15 JTF_NUMBER_TABLE
3239: , p7_a16 JTF_NUMBER_TABLE
3240: , p7_a17 JTF_VARCHAR2_TABLE_300
3241: , p7_a18 JTF_VARCHAR2_TABLE_2000
3242: , p7_a19 JTF_VARCHAR2_TABLE_100
3235: , p7_a12 JTF_NUMBER_TABLE
3236: , p7_a13 JTF_NUMBER_TABLE
3237: , p7_a14 JTF_VARCHAR2_TABLE_100
3238: , p7_a15 JTF_NUMBER_TABLE
3239: , p7_a16 JTF_NUMBER_TABLE
3240: , p7_a17 JTF_VARCHAR2_TABLE_300
3241: , p7_a18 JTF_VARCHAR2_TABLE_2000
3242: , p7_a19 JTF_VARCHAR2_TABLE_100
3243: , p7_a20 JTF_NUMBER_TABLE
3239: , p7_a16 JTF_NUMBER_TABLE
3240: , p7_a17 JTF_VARCHAR2_TABLE_300
3241: , p7_a18 JTF_VARCHAR2_TABLE_2000
3242: , p7_a19 JTF_VARCHAR2_TABLE_100
3243: , p7_a20 JTF_NUMBER_TABLE
3244: , p8_a0 JTF_NUMBER_TABLE
3245: , p8_a1 JTF_NUMBER_TABLE
3246: , p8_a2 JTF_NUMBER_TABLE
3247: , p8_a3 JTF_NUMBER_TABLE
3240: , p7_a17 JTF_VARCHAR2_TABLE_300
3241: , p7_a18 JTF_VARCHAR2_TABLE_2000
3242: , p7_a19 JTF_VARCHAR2_TABLE_100
3243: , p7_a20 JTF_NUMBER_TABLE
3244: , p8_a0 JTF_NUMBER_TABLE
3245: , p8_a1 JTF_NUMBER_TABLE
3246: , p8_a2 JTF_NUMBER_TABLE
3247: , p8_a3 JTF_NUMBER_TABLE
3248: , p8_a4 JTF_VARCHAR2_TABLE_100
3241: , p7_a18 JTF_VARCHAR2_TABLE_2000
3242: , p7_a19 JTF_VARCHAR2_TABLE_100
3243: , p7_a20 JTF_NUMBER_TABLE
3244: , p8_a0 JTF_NUMBER_TABLE
3245: , p8_a1 JTF_NUMBER_TABLE
3246: , p8_a2 JTF_NUMBER_TABLE
3247: , p8_a3 JTF_NUMBER_TABLE
3248: , p8_a4 JTF_VARCHAR2_TABLE_100
3249: , p8_a5 JTF_VARCHAR2_TABLE_100
3242: , p7_a19 JTF_VARCHAR2_TABLE_100
3243: , p7_a20 JTF_NUMBER_TABLE
3244: , p8_a0 JTF_NUMBER_TABLE
3245: , p8_a1 JTF_NUMBER_TABLE
3246: , p8_a2 JTF_NUMBER_TABLE
3247: , p8_a3 JTF_NUMBER_TABLE
3248: , p8_a4 JTF_VARCHAR2_TABLE_100
3249: , p8_a5 JTF_VARCHAR2_TABLE_100
3250: , p8_a6 JTF_VARCHAR2_TABLE_100
3243: , p7_a20 JTF_NUMBER_TABLE
3244: , p8_a0 JTF_NUMBER_TABLE
3245: , p8_a1 JTF_NUMBER_TABLE
3246: , p8_a2 JTF_NUMBER_TABLE
3247: , p8_a3 JTF_NUMBER_TABLE
3248: , p8_a4 JTF_VARCHAR2_TABLE_100
3249: , p8_a5 JTF_VARCHAR2_TABLE_100
3250: , p8_a6 JTF_VARCHAR2_TABLE_100
3251: , p8_a7 JTF_NUMBER_TABLE
3247: , p8_a3 JTF_NUMBER_TABLE
3248: , p8_a4 JTF_VARCHAR2_TABLE_100
3249: , p8_a5 JTF_VARCHAR2_TABLE_100
3250: , p8_a6 JTF_VARCHAR2_TABLE_100
3251: , p8_a7 JTF_NUMBER_TABLE
3252: , p8_a8 JTF_VARCHAR2_TABLE_100
3253: , p8_a9 JTF_VARCHAR2_TABLE_100
3254: , p8_a10 JTF_VARCHAR2_TABLE_100
3255: , p8_a11 JTF_VARCHAR2_TABLE_100
3252: , p8_a8 JTF_VARCHAR2_TABLE_100
3253: , p8_a9 JTF_VARCHAR2_TABLE_100
3254: , p8_a10 JTF_VARCHAR2_TABLE_100
3255: , p8_a11 JTF_VARCHAR2_TABLE_100
3256: , p8_a12 JTF_NUMBER_TABLE
3257: , p8_a13 JTF_NUMBER_TABLE
3258: , p8_a14 JTF_VARCHAR2_TABLE_100
3259: , p8_a15 JTF_NUMBER_TABLE
3260: , p8_a16 JTF_NUMBER_TABLE
3253: , p8_a9 JTF_VARCHAR2_TABLE_100
3254: , p8_a10 JTF_VARCHAR2_TABLE_100
3255: , p8_a11 JTF_VARCHAR2_TABLE_100
3256: , p8_a12 JTF_NUMBER_TABLE
3257: , p8_a13 JTF_NUMBER_TABLE
3258: , p8_a14 JTF_VARCHAR2_TABLE_100
3259: , p8_a15 JTF_NUMBER_TABLE
3260: , p8_a16 JTF_NUMBER_TABLE
3261: , p8_a17 JTF_VARCHAR2_TABLE_300
3255: , p8_a11 JTF_VARCHAR2_TABLE_100
3256: , p8_a12 JTF_NUMBER_TABLE
3257: , p8_a13 JTF_NUMBER_TABLE
3258: , p8_a14 JTF_VARCHAR2_TABLE_100
3259: , p8_a15 JTF_NUMBER_TABLE
3260: , p8_a16 JTF_NUMBER_TABLE
3261: , p8_a17 JTF_VARCHAR2_TABLE_300
3262: , p8_a18 JTF_VARCHAR2_TABLE_2000
3263: , p8_a19 JTF_VARCHAR2_TABLE_100
3256: , p8_a12 JTF_NUMBER_TABLE
3257: , p8_a13 JTF_NUMBER_TABLE
3258: , p8_a14 JTF_VARCHAR2_TABLE_100
3259: , p8_a15 JTF_NUMBER_TABLE
3260: , p8_a16 JTF_NUMBER_TABLE
3261: , p8_a17 JTF_VARCHAR2_TABLE_300
3262: , p8_a18 JTF_VARCHAR2_TABLE_2000
3263: , p8_a19 JTF_VARCHAR2_TABLE_100
3264: , p8_a20 JTF_NUMBER_TABLE
3260: , p8_a16 JTF_NUMBER_TABLE
3261: , p8_a17 JTF_VARCHAR2_TABLE_300
3262: , p8_a18 JTF_VARCHAR2_TABLE_2000
3263: , p8_a19 JTF_VARCHAR2_TABLE_100
3264: , p8_a20 JTF_NUMBER_TABLE
3265: , p9_a0 JTF_NUMBER_TABLE
3266: , p9_a1 JTF_VARCHAR2_TABLE_100
3267: , p9_a2 JTF_NUMBER_TABLE
3268: , p9_a3 JTF_NUMBER_TABLE
3261: , p8_a17 JTF_VARCHAR2_TABLE_300
3262: , p8_a18 JTF_VARCHAR2_TABLE_2000
3263: , p8_a19 JTF_VARCHAR2_TABLE_100
3264: , p8_a20 JTF_NUMBER_TABLE
3265: , p9_a0 JTF_NUMBER_TABLE
3266: , p9_a1 JTF_VARCHAR2_TABLE_100
3267: , p9_a2 JTF_NUMBER_TABLE
3268: , p9_a3 JTF_NUMBER_TABLE
3269: , p9_a4 JTF_NUMBER_TABLE
3263: , p8_a19 JTF_VARCHAR2_TABLE_100
3264: , p8_a20 JTF_NUMBER_TABLE
3265: , p9_a0 JTF_NUMBER_TABLE
3266: , p9_a1 JTF_VARCHAR2_TABLE_100
3267: , p9_a2 JTF_NUMBER_TABLE
3268: , p9_a3 JTF_NUMBER_TABLE
3269: , p9_a4 JTF_NUMBER_TABLE
3270: , p9_a5 JTF_VARCHAR2_TABLE_100
3271: , p9_a6 JTF_VARCHAR2_TABLE_100
3264: , p8_a20 JTF_NUMBER_TABLE
3265: , p9_a0 JTF_NUMBER_TABLE
3266: , p9_a1 JTF_VARCHAR2_TABLE_100
3267: , p9_a2 JTF_NUMBER_TABLE
3268: , p9_a3 JTF_NUMBER_TABLE
3269: , p9_a4 JTF_NUMBER_TABLE
3270: , p9_a5 JTF_VARCHAR2_TABLE_100
3271: , p9_a6 JTF_VARCHAR2_TABLE_100
3272: , p9_a7 JTF_VARCHAR2_TABLE_300
3265: , p9_a0 JTF_NUMBER_TABLE
3266: , p9_a1 JTF_VARCHAR2_TABLE_100
3267: , p9_a2 JTF_NUMBER_TABLE
3268: , p9_a3 JTF_NUMBER_TABLE
3269: , p9_a4 JTF_NUMBER_TABLE
3270: , p9_a5 JTF_VARCHAR2_TABLE_100
3271: , p9_a6 JTF_VARCHAR2_TABLE_100
3272: , p9_a7 JTF_VARCHAR2_TABLE_300
3273: , p9_a8 JTF_VARCHAR2_TABLE_100
3272: , p9_a7 JTF_VARCHAR2_TABLE_300
3273: , p9_a8 JTF_VARCHAR2_TABLE_100
3274: , p9_a9 JTF_VARCHAR2_TABLE_100
3275: , p9_a10 JTF_VARCHAR2_TABLE_100
3276: , p9_a11 JTF_NUMBER_TABLE
3277: , p10_a0 JTF_VARCHAR2_TABLE_100
3278: , p10_a1 JTF_VARCHAR2_TABLE_100
3279: , p10_a2 JTF_VARCHAR2_TABLE_300
3280: , p10_a3 JTF_VARCHAR2_TABLE_300
3278: , p10_a1 JTF_VARCHAR2_TABLE_100
3279: , p10_a2 JTF_VARCHAR2_TABLE_300
3280: , p10_a3 JTF_VARCHAR2_TABLE_300
3281: , p10_a4 JTF_VARCHAR2_TABLE_100
3282: , p10_a5 JTF_NUMBER_TABLE
3283: , p10_a6 JTF_NUMBER_TABLE
3284: , p10_a7 JTF_NUMBER_TABLE
3285: , p10_a8 JTF_NUMBER_TABLE
3286: , p10_a9 JTF_DATE_TABLE
3279: , p10_a2 JTF_VARCHAR2_TABLE_300
3280: , p10_a3 JTF_VARCHAR2_TABLE_300
3281: , p10_a4 JTF_VARCHAR2_TABLE_100
3282: , p10_a5 JTF_NUMBER_TABLE
3283: , p10_a6 JTF_NUMBER_TABLE
3284: , p10_a7 JTF_NUMBER_TABLE
3285: , p10_a8 JTF_NUMBER_TABLE
3286: , p10_a9 JTF_DATE_TABLE
3287: , p10_a10 JTF_DATE_TABLE
3280: , p10_a3 JTF_VARCHAR2_TABLE_300
3281: , p10_a4 JTF_VARCHAR2_TABLE_100
3282: , p10_a5 JTF_NUMBER_TABLE
3283: , p10_a6 JTF_NUMBER_TABLE
3284: , p10_a7 JTF_NUMBER_TABLE
3285: , p10_a8 JTF_NUMBER_TABLE
3286: , p10_a9 JTF_DATE_TABLE
3287: , p10_a10 JTF_DATE_TABLE
3288: , p10_a11 JTF_NUMBER_TABLE
3281: , p10_a4 JTF_VARCHAR2_TABLE_100
3282: , p10_a5 JTF_NUMBER_TABLE
3283: , p10_a6 JTF_NUMBER_TABLE
3284: , p10_a7 JTF_NUMBER_TABLE
3285: , p10_a8 JTF_NUMBER_TABLE
3286: , p10_a9 JTF_DATE_TABLE
3287: , p10_a10 JTF_DATE_TABLE
3288: , p10_a11 JTF_NUMBER_TABLE
3289: , p10_a12 JTF_VARCHAR2_TABLE_100
3284: , p10_a7 JTF_NUMBER_TABLE
3285: , p10_a8 JTF_NUMBER_TABLE
3286: , p10_a9 JTF_DATE_TABLE
3287: , p10_a10 JTF_DATE_TABLE
3288: , p10_a11 JTF_NUMBER_TABLE
3289: , p10_a12 JTF_VARCHAR2_TABLE_100
3290: , p10_a13 JTF_VARCHAR2_TABLE_100
3291: , p10_a14 JTF_VARCHAR2_TABLE_300
3292: , p10_a15 JTF_VARCHAR2_TABLE_300
3302: , p10_a25 JTF_VARCHAR2_TABLE_300
3303: , p10_a26 JTF_VARCHAR2_TABLE_300
3304: , p10_a27 JTF_VARCHAR2_TABLE_300
3305: , p10_a28 JTF_VARCHAR2_TABLE_300
3306: , p11_a0 JTF_NUMBER_TABLE
3307: , p11_a1 JTF_NUMBER_TABLE
3308: , p11_a2 JTF_NUMBER_TABLE
3309: , p11_a3 JTF_NUMBER_TABLE
3310: , p11_a4 JTF_VARCHAR2_TABLE_100
3303: , p10_a26 JTF_VARCHAR2_TABLE_300
3304: , p10_a27 JTF_VARCHAR2_TABLE_300
3305: , p10_a28 JTF_VARCHAR2_TABLE_300
3306: , p11_a0 JTF_NUMBER_TABLE
3307: , p11_a1 JTF_NUMBER_TABLE
3308: , p11_a2 JTF_NUMBER_TABLE
3309: , p11_a3 JTF_NUMBER_TABLE
3310: , p11_a4 JTF_VARCHAR2_TABLE_100
3311: , p11_a5 JTF_NUMBER_TABLE
3304: , p10_a27 JTF_VARCHAR2_TABLE_300
3305: , p10_a28 JTF_VARCHAR2_TABLE_300
3306: , p11_a0 JTF_NUMBER_TABLE
3307: , p11_a1 JTF_NUMBER_TABLE
3308: , p11_a2 JTF_NUMBER_TABLE
3309: , p11_a3 JTF_NUMBER_TABLE
3310: , p11_a4 JTF_VARCHAR2_TABLE_100
3311: , p11_a5 JTF_NUMBER_TABLE
3312: , p11_a6 JTF_VARCHAR2_TABLE_100
3305: , p10_a28 JTF_VARCHAR2_TABLE_300
3306: , p11_a0 JTF_NUMBER_TABLE
3307: , p11_a1 JTF_NUMBER_TABLE
3308: , p11_a2 JTF_NUMBER_TABLE
3309: , p11_a3 JTF_NUMBER_TABLE
3310: , p11_a4 JTF_VARCHAR2_TABLE_100
3311: , p11_a5 JTF_NUMBER_TABLE
3312: , p11_a6 JTF_VARCHAR2_TABLE_100
3313: , p11_a7 JTF_VARCHAR2_TABLE_100
3307: , p11_a1 JTF_NUMBER_TABLE
3308: , p11_a2 JTF_NUMBER_TABLE
3309: , p11_a3 JTF_NUMBER_TABLE
3310: , p11_a4 JTF_VARCHAR2_TABLE_100
3311: , p11_a5 JTF_NUMBER_TABLE
3312: , p11_a6 JTF_VARCHAR2_TABLE_100
3313: , p11_a7 JTF_VARCHAR2_TABLE_100
3314: , p11_a8 JTF_VARCHAR2_TABLE_100
3315: , p11_a9 JTF_NUMBER_TABLE
3311: , p11_a5 JTF_NUMBER_TABLE
3312: , p11_a6 JTF_VARCHAR2_TABLE_100
3313: , p11_a7 JTF_VARCHAR2_TABLE_100
3314: , p11_a8 JTF_VARCHAR2_TABLE_100
3315: , p11_a9 JTF_NUMBER_TABLE
3316: , p11_a10 JTF_NUMBER_TABLE
3317: , p11_a11 JTF_NUMBER_TABLE
3318: , p11_a12 JTF_VARCHAR2_TABLE_100
3319: , p12_a0 JTF_NUMBER_TABLE
3312: , p11_a6 JTF_VARCHAR2_TABLE_100
3313: , p11_a7 JTF_VARCHAR2_TABLE_100
3314: , p11_a8 JTF_VARCHAR2_TABLE_100
3315: , p11_a9 JTF_NUMBER_TABLE
3316: , p11_a10 JTF_NUMBER_TABLE
3317: , p11_a11 JTF_NUMBER_TABLE
3318: , p11_a12 JTF_VARCHAR2_TABLE_100
3319: , p12_a0 JTF_NUMBER_TABLE
3320: , p12_a1 JTF_NUMBER_TABLE
3313: , p11_a7 JTF_VARCHAR2_TABLE_100
3314: , p11_a8 JTF_VARCHAR2_TABLE_100
3315: , p11_a9 JTF_NUMBER_TABLE
3316: , p11_a10 JTF_NUMBER_TABLE
3317: , p11_a11 JTF_NUMBER_TABLE
3318: , p11_a12 JTF_VARCHAR2_TABLE_100
3319: , p12_a0 JTF_NUMBER_TABLE
3320: , p12_a1 JTF_NUMBER_TABLE
3321: , p12_a2 JTF_NUMBER_TABLE
3315: , p11_a9 JTF_NUMBER_TABLE
3316: , p11_a10 JTF_NUMBER_TABLE
3317: , p11_a11 JTF_NUMBER_TABLE
3318: , p11_a12 JTF_VARCHAR2_TABLE_100
3319: , p12_a0 JTF_NUMBER_TABLE
3320: , p12_a1 JTF_NUMBER_TABLE
3321: , p12_a2 JTF_NUMBER_TABLE
3322: , p12_a3 JTF_VARCHAR2_TABLE_100
3323: , x_qp_list_header_id out nocopy NUMBER
3316: , p11_a10 JTF_NUMBER_TABLE
3317: , p11_a11 JTF_NUMBER_TABLE
3318: , p11_a12 JTF_VARCHAR2_TABLE_100
3319: , p12_a0 JTF_NUMBER_TABLE
3320: , p12_a1 JTF_NUMBER_TABLE
3321: , p12_a2 JTF_NUMBER_TABLE
3322: , p12_a3 JTF_VARCHAR2_TABLE_100
3323: , x_qp_list_header_id out nocopy NUMBER
3324: , x_error_location out nocopy NUMBER
3317: , p11_a11 JTF_NUMBER_TABLE
3318: , p11_a12 JTF_VARCHAR2_TABLE_100
3319: , p12_a0 JTF_NUMBER_TABLE
3320: , p12_a1 JTF_NUMBER_TABLE
3321: , p12_a2 JTF_NUMBER_TABLE
3322: , p12_a3 JTF_VARCHAR2_TABLE_100
3323: , x_qp_list_header_id out nocopy NUMBER
3324: , x_error_location out nocopy NUMBER
3325: )