[Home] [Help]
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
10: , a7 JTF_NUMBER_TABLE
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
10: , a7 JTF_NUMBER_TABLE
11: , a8 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
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 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
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
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
18: , a15 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
18: , a15 JTF_NUMBER_TABLE
19: , a16 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
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 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
24: , a21 JTF_NUMBER_TABLE
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
24: , a21 JTF_NUMBER_TABLE
25: , a22 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
29: if a0 is not null and a0.count > 0 then
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
73: , a7 out nocopy JTF_NUMBER_TABLE
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
73: , a7 out nocopy JTF_NUMBER_TABLE
74: , a8 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
73: , a7 out nocopy JTF_NUMBER_TABLE
74: , a8 out nocopy JTF_NUMBER_TABLE
75: , a9 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
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
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
81: , a15 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
81: , a15 out nocopy JTF_NUMBER_TABLE
82: , a16 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
81: , a15 out nocopy JTF_NUMBER_TABLE
82: , a16 out nocopy JTF_NUMBER_TABLE
83: , a17 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
87: , a21 out nocopy JTF_NUMBER_TABLE
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
87: , a21 out nocopy JTF_NUMBER_TABLE
88: , a22 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
92: if t is null or t.count = 0 then
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();
100: a7 := JTF_NUMBER_TABLE();
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();
100: a7 := JTF_NUMBER_TABLE();
101: a8 := 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();
100: a7 := JTF_NUMBER_TABLE();
101: a8 := JTF_NUMBER_TABLE();
102: a9 := 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();
100: a7 := JTF_NUMBER_TABLE();
101: a8 := JTF_NUMBER_TABLE();
102: a9 := JTF_NUMBER_TABLE();
103: a10 := JTF_NUMBER_TABLE();
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();
108: a15 := 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();
108: a15 := JTF_NUMBER_TABLE();
109: a16 := 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();
108: a15 := JTF_NUMBER_TABLE();
109: a16 := JTF_NUMBER_TABLE();
110: a17 := 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();
114: a21 := JTF_NUMBER_TABLE();
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();
114: a21 := JTF_NUMBER_TABLE();
115: a22 := 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();
119: a2 := JTF_NUMBER_TABLE();
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();
124: a7 := JTF_NUMBER_TABLE();
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();
124: a7 := JTF_NUMBER_TABLE();
125: a8 := 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();
124: a7 := JTF_NUMBER_TABLE();
125: a8 := JTF_NUMBER_TABLE();
126: a9 := 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();
124: a7 := JTF_NUMBER_TABLE();
125: a8 := JTF_NUMBER_TABLE();
126: a9 := JTF_NUMBER_TABLE();
127: a10 := JTF_NUMBER_TABLE();
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();
132: a15 := 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();
132: a15 := JTF_NUMBER_TABLE();
133: a16 := 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();
132: a15 := JTF_NUMBER_TABLE();
133: a16 := JTF_NUMBER_TABLE();
134: a17 := 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();
138: a21 := JTF_NUMBER_TABLE();
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();
138: a21 := JTF_NUMBER_TABLE();
139: a22 := 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);
143: a2.extend(t.count);
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
208: , a8 JTF_VARCHAR2_TABLE_100
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
208: , a8 JTF_VARCHAR2_TABLE_100
209: , a9 JTF_VARCHAR2_TABLE_100
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
208: , a8 JTF_VARCHAR2_TABLE_100
209: , a9 JTF_VARCHAR2_TABLE_100
210: , a10 JTF_VARCHAR2_TABLE_100
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
212: , a12 JTF_NUMBER_TABLE
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
212: , a12 JTF_NUMBER_TABLE
213: , a13 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
212: , a12 JTF_NUMBER_TABLE
213: , a13 JTF_VARCHAR2_TABLE_100
214: , a14 JTF_NUMBER_TABLE
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
212: , a12 JTF_NUMBER_TABLE
213: , a13 JTF_VARCHAR2_TABLE_100
214: , a14 JTF_NUMBER_TABLE
215: , a15 JTF_NUMBER_TABLE
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
217: , a17 JTF_NUMBER_TABLE
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
222: , a22 JTF_DATE_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
222: , a22 JTF_DATE_TABLE
223: , a23 JTF_NUMBER_TABLE
224: , a24 JTF_DATE_TABLE
225: , a25 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
235: ) as
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;
237: begin
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;
237: begin
238: if a0 is not null and a0.count > 0 then
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
295: , a8 out nocopy JTF_VARCHAR2_TABLE_100
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
295: , a8 out nocopy JTF_VARCHAR2_TABLE_100
296: , a9 out nocopy JTF_VARCHAR2_TABLE_100
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
295: , a8 out nocopy JTF_VARCHAR2_TABLE_100
296: , a9 out nocopy JTF_VARCHAR2_TABLE_100
297: , a10 out nocopy JTF_VARCHAR2_TABLE_100
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
299: , a12 out nocopy JTF_NUMBER_TABLE
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
299: , a12 out nocopy JTF_NUMBER_TABLE
300: , a13 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
299: , a12 out nocopy JTF_NUMBER_TABLE
300: , a13 out nocopy JTF_VARCHAR2_TABLE_100
301: , a14 out nocopy JTF_NUMBER_TABLE
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
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
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
304: , a17 out nocopy JTF_NUMBER_TABLE
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
309: , a22 out nocopy JTF_DATE_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
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
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
322: ) as
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;
324: begin
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;
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();
333: a7 := JTF_NUMBER_TABLE();
334: a8 := JTF_VARCHAR2_TABLE_100();
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();
334: a8 := JTF_VARCHAR2_TABLE_100();
335: a9 := JTF_VARCHAR2_TABLE_100();
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();
334: a8 := JTF_VARCHAR2_TABLE_100();
335: a9 := JTF_VARCHAR2_TABLE_100();
336: a10 := JTF_VARCHAR2_TABLE_100();
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();
338: a12 := JTF_NUMBER_TABLE();
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();
338: a12 := JTF_NUMBER_TABLE();
339: a13 := 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();
338: a12 := JTF_NUMBER_TABLE();
339: a13 := JTF_VARCHAR2_TABLE_100();
340: a14 := JTF_NUMBER_TABLE();
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();
338: a12 := JTF_NUMBER_TABLE();
339: a13 := JTF_VARCHAR2_TABLE_100();
340: a14 := JTF_NUMBER_TABLE();
341: a15 := JTF_NUMBER_TABLE();
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();
343: a17 := JTF_NUMBER_TABLE();
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();
348: a22 := JTF_DATE_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();
348: a22 := JTF_DATE_TABLE();
349: a23 := JTF_NUMBER_TABLE();
350: a24 := JTF_DATE_TABLE();
351: a25 := 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();
361: else
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();
363: a1 := 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();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
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();
370: a8 := JTF_VARCHAR2_TABLE_100();
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();
370: a8 := JTF_VARCHAR2_TABLE_100();
371: a9 := JTF_VARCHAR2_TABLE_100();
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();
370: a8 := JTF_VARCHAR2_TABLE_100();
371: a9 := JTF_VARCHAR2_TABLE_100();
372: a10 := JTF_VARCHAR2_TABLE_100();
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();
374: a12 := JTF_NUMBER_TABLE();
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();
374: a12 := JTF_NUMBER_TABLE();
375: a13 := 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();
374: a12 := JTF_NUMBER_TABLE();
375: a13 := JTF_VARCHAR2_TABLE_100();
376: a14 := JTF_NUMBER_TABLE();
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();
374: a12 := JTF_NUMBER_TABLE();
375: a13 := JTF_VARCHAR2_TABLE_100();
376: a14 := JTF_NUMBER_TABLE();
377: a15 := JTF_NUMBER_TABLE();
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();
379: a17 := JTF_NUMBER_TABLE();
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();
384: a22 := JTF_DATE_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();
384: a22 := JTF_DATE_TABLE();
385: a23 := JTF_NUMBER_TABLE();
386: a24 := JTF_DATE_TABLE();
387: a25 := 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();
397: if t.count > 0 then
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);
399: a1.extend(t.count);
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);
399: a1.extend(t.count);
400: a2.extend(t.count);
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
487: , a6 JTF_DATE_TABLE
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
489: , a8 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
489: , a8 JTF_NUMBER_TABLE
490: , a9 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
501: if a0 is not null and a0.count > 0 then
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
538: , a6 out nocopy JTF_DATE_TABLE
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
540: , a8 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
540: , a8 out nocopy JTF_NUMBER_TABLE
541: , a9 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
552: if t is null or t.count = 0 then
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();
559: a6 := JTF_DATE_TABLE();
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();
561: a8 := 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();
561: a8 := JTF_NUMBER_TABLE();
562: a9 := 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();
573: a2 := JTF_VARCHAR2_TABLE_100();
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();
577: a6 := JTF_DATE_TABLE();
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();
579: a8 := 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();
579: a8 := JTF_NUMBER_TABLE();
580: a9 := 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);
591: a2.extend(t.count);
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
642: , a6 JTF_DATE_TABLE
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
645: ddindx binary_integer; indx binary_integer;
646: begin
647: if a0 is not null and a0.count > 0 then
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
675: , a6 out nocopy JTF_DATE_TABLE
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
678: ddindx binary_integer; indx binary_integer;
679: begin
680: if t is null or t.count = 0 then
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();
687: a6 := JTF_DATE_TABLE();
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
690: a0 := JTF_NUMBER_TABLE();
691: a1 := JTF_NUMBER_TABLE();
692: a2 := JTF_VARCHAR2_TABLE_100();
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();
696: a6 := JTF_DATE_TABLE();
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
699: a0.extend(t.count);
700: a1.extend(t.count);
701: a2.extend(t.count);
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
737: , a9 JTF_VARCHAR2_TABLE_100
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
737: , a9 JTF_VARCHAR2_TABLE_100
738: , a10 JTF_DATE_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
737: , a9 JTF_VARCHAR2_TABLE_100
738: , a10 JTF_DATE_TABLE
739: , a11 JTF_DATE_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
741: , a13 JTF_NUMBER_TABLE
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
741: , a13 JTF_NUMBER_TABLE
742: , a14 JTF_VARCHAR2_TABLE_100
743: ) as
744: ddindx binary_integer; indx binary_integer;
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
746: if a0 is not null and a0.count > 0 then
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
784: , a9 out nocopy JTF_VARCHAR2_TABLE_100
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
784: , a9 out nocopy JTF_VARCHAR2_TABLE_100
785: , a10 out nocopy JTF_DATE_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
784: , a9 out nocopy JTF_VARCHAR2_TABLE_100
785: , a10 out nocopy JTF_DATE_TABLE
786: , a11 out nocopy JTF_DATE_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
788: , a13 out nocopy JTF_NUMBER_TABLE
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
788: , a13 out nocopy JTF_NUMBER_TABLE
789: , a14 out nocopy JTF_VARCHAR2_TABLE_100
790: ) as
791: ddindx binary_integer; indx binary_integer;
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
793: if t is null or t.count = 0 then
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();
803: a9 := JTF_VARCHAR2_TABLE_100();
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();
803: a9 := JTF_VARCHAR2_TABLE_100();
804: a10 := JTF_DATE_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();
803: a9 := JTF_VARCHAR2_TABLE_100();
804: a10 := JTF_DATE_TABLE();
805: a11 := JTF_DATE_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();
807: a13 := JTF_NUMBER_TABLE();
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();
807: a13 := JTF_NUMBER_TABLE();
808: a14 := JTF_VARCHAR2_TABLE_100();
809: else
810: a0 := JTF_NUMBER_TABLE();
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();
812: a2 := 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();
819: a9 := JTF_VARCHAR2_TABLE_100();
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();
819: a9 := JTF_VARCHAR2_TABLE_100();
820: a10 := JTF_DATE_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();
819: a9 := JTF_VARCHAR2_TABLE_100();
820: a10 := JTF_DATE_TABLE();
821: a11 := JTF_DATE_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();
823: a13 := JTF_NUMBER_TABLE();
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();
823: a13 := JTF_NUMBER_TABLE();
824: a14 := JTF_VARCHAR2_TABLE_100();
825: if t.count > 0 then
826: a0.extend(t.count);
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);
828: a2.extend(t.count);
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
880: , a11 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
880: , a11 JTF_DATE_TABLE
881: , a12 JTF_NUMBER_TABLE
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
887: , a18 JTF_VARCHAR2_TABLE_300
895: , a26 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;
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
905: if a0 is not null and a0.count > 0 then
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
963: , a11 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
963: , a11 out nocopy JTF_DATE_TABLE
964: , a12 out nocopy JTF_NUMBER_TABLE
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
970: , a18 out nocopy JTF_VARCHAR2_TABLE_300
978: , a26 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;
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
988: if t is null or t.count = 0 then
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();
1000: a11 := 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();
1000: a11 := JTF_DATE_TABLE();
1001: a12 := JTF_NUMBER_TABLE();
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();
1007: a18 := JTF_VARCHAR2_TABLE_300();
1015: a26 := 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();
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();
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();
1034: a11 := 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();
1034: a11 := JTF_DATE_TABLE();
1035: a12 := JTF_NUMBER_TABLE();
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();
1041: a18 := JTF_VARCHAR2_TABLE_300();
1049: a26 := 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);
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);
1059: a2.extend(t.count);
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
1143: if a0 is not null and a0.count > 0 then
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
1168: if t is null or t.count = 0 then
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();
1176: a2 := JTF_NUMBER_TABLE();
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);
1181: a2.extend(t.count);
1196: end if;
1197: end if;
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
1197: end if;
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
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
1208: , a8 JTF_VARCHAR2_TABLE_100
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
1210: , a10 JTF_NUMBER_TABLE
1211: , a11 JTF_VARCHAR2_TABLE_100
1212: , a12 JTF_NUMBER_TABLE
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
1210: , a10 JTF_NUMBER_TABLE
1211: , a11 JTF_VARCHAR2_TABLE_100
1212: , a12 JTF_NUMBER_TABLE
1213: , a13 JTF_NUMBER_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
1215: , a15 JTF_NUMBER_TABLE
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
1218: , a18 JTF_NUMBER_TABLE
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
1220: , a20 JTF_NUMBER_TABLE
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
1225: , a25 JTF_VARCHAR2_TABLE_100
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
1225: , a25 JTF_VARCHAR2_TABLE_100
1226: , a26 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
1225: , a25 JTF_VARCHAR2_TABLE_100
1226: , a26 JTF_NUMBER_TABLE
1227: , a27 JTF_VARCHAR2_TABLE_100
1221: , a21 JTF_VARCHAR2_TABLE_100
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
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
1231: , a31 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
1231: , a31 JTF_VARCHAR2_TABLE_100
1232: , a32 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
1231: , a31 JTF_VARCHAR2_TABLE_100
1232: , a32 JTF_VARCHAR2_TABLE_100
1233: , a33 JTF_VARCHAR2_TABLE_300
1234: , a34 JTF_VARCHAR2_TABLE_300
1227: , a27 JTF_VARCHAR2_TABLE_100
1228: , a28 JTF_VARCHAR2_TABLE_100
1229: , a29 JTF_VARCHAR2_TABLE_300
1230: , a30 JTF_VARCHAR2_TABLE_100
1231: , a31 JTF_VARCHAR2_TABLE_100
1232: , a32 JTF_VARCHAR2_TABLE_100
1233: , a33 JTF_VARCHAR2_TABLE_300
1234: , a34 JTF_VARCHAR2_TABLE_300
1235: , a35 JTF_VARCHAR2_TABLE_100
1228: , a28 JTF_VARCHAR2_TABLE_100
1229: , a29 JTF_VARCHAR2_TABLE_300
1230: , a30 JTF_VARCHAR2_TABLE_100
1231: , a31 JTF_VARCHAR2_TABLE_100
1232: , a32 JTF_VARCHAR2_TABLE_100
1233: , a33 JTF_VARCHAR2_TABLE_300
1234: , a34 JTF_VARCHAR2_TABLE_300
1235: , a35 JTF_VARCHAR2_TABLE_100
1236: , a36 JTF_VARCHAR2_TABLE_300
1231: , a31 JTF_VARCHAR2_TABLE_100
1232: , a32 JTF_VARCHAR2_TABLE_100
1233: , a33 JTF_VARCHAR2_TABLE_300
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
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
1243: , a43 JTF_VARCHAR2_TABLE_300
1244: , a44 JTF_VARCHAR2_TABLE_300
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
1270: , a70 JTF_VARCHAR2_TABLE_300
1355: end loop;
1356: end if;
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
1356: end if;
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
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
1367: , a8 out nocopy JTF_VARCHAR2_TABLE_100
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
1369: , a10 out nocopy JTF_NUMBER_TABLE
1370: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1371: , a12 out nocopy JTF_NUMBER_TABLE
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
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
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
1374: , a15 out nocopy JTF_NUMBER_TABLE
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
1377: , a18 out nocopy JTF_NUMBER_TABLE
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
1379: , a20 out nocopy JTF_NUMBER_TABLE
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
1384: , a25 out nocopy JTF_VARCHAR2_TABLE_100
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
1384: , a25 out nocopy JTF_VARCHAR2_TABLE_100
1385: , a26 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
1384: , a25 out nocopy JTF_VARCHAR2_TABLE_100
1385: , a26 out nocopy JTF_NUMBER_TABLE
1386: , a27 out nocopy JTF_VARCHAR2_TABLE_100
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
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
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
1390: , a31 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
1390: , a31 out nocopy JTF_VARCHAR2_TABLE_100
1391: , a32 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
1390: , a31 out nocopy JTF_VARCHAR2_TABLE_100
1391: , a32 out nocopy JTF_VARCHAR2_TABLE_100
1392: , a33 out nocopy JTF_VARCHAR2_TABLE_300
1393: , a34 out nocopy JTF_VARCHAR2_TABLE_300
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
1390: , a31 out nocopy JTF_VARCHAR2_TABLE_100
1391: , a32 out nocopy JTF_VARCHAR2_TABLE_100
1392: , a33 out nocopy JTF_VARCHAR2_TABLE_300
1393: , a34 out nocopy JTF_VARCHAR2_TABLE_300
1394: , a35 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
1390: , a31 out nocopy JTF_VARCHAR2_TABLE_100
1391: , a32 out nocopy JTF_VARCHAR2_TABLE_100
1392: , a33 out nocopy JTF_VARCHAR2_TABLE_300
1393: , a34 out nocopy JTF_VARCHAR2_TABLE_300
1394: , a35 out nocopy JTF_VARCHAR2_TABLE_100
1395: , a36 out nocopy JTF_VARCHAR2_TABLE_300
1390: , a31 out nocopy JTF_VARCHAR2_TABLE_100
1391: , a32 out nocopy JTF_VARCHAR2_TABLE_100
1392: , a33 out nocopy JTF_VARCHAR2_TABLE_300
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
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
1402: , a43 out nocopy JTF_VARCHAR2_TABLE_300
1403: , a44 out nocopy JTF_VARCHAR2_TABLE_300
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
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();
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();
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();
1442: a8 := JTF_VARCHAR2_TABLE_100();
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();
1444: a10 := JTF_NUMBER_TABLE();
1445: a11 := JTF_VARCHAR2_TABLE_100();
1446: a12 := JTF_NUMBER_TABLE();
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();
1444: a10 := JTF_NUMBER_TABLE();
1445: a11 := JTF_VARCHAR2_TABLE_100();
1446: a12 := JTF_NUMBER_TABLE();
1447: a13 := JTF_NUMBER_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();
1449: a15 := JTF_NUMBER_TABLE();
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();
1452: a18 := JTF_NUMBER_TABLE();
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();
1454: a20 := JTF_NUMBER_TABLE();
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();
1459: a25 := JTF_VARCHAR2_TABLE_100();
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();
1459: a25 := JTF_VARCHAR2_TABLE_100();
1460: a26 := 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();
1459: a25 := JTF_VARCHAR2_TABLE_100();
1460: a26 := JTF_NUMBER_TABLE();
1461: a27 := JTF_VARCHAR2_TABLE_100();
1455: a21 := JTF_VARCHAR2_TABLE_100();
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();
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();
1465: a31 := 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();
1465: a31 := JTF_VARCHAR2_TABLE_100();
1466: a32 := 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();
1465: a31 := JTF_VARCHAR2_TABLE_100();
1466: a32 := JTF_VARCHAR2_TABLE_100();
1467: a33 := JTF_VARCHAR2_TABLE_300();
1468: a34 := JTF_VARCHAR2_TABLE_300();
1461: a27 := JTF_VARCHAR2_TABLE_100();
1462: a28 := JTF_VARCHAR2_TABLE_100();
1463: a29 := JTF_VARCHAR2_TABLE_300();
1464: a30 := JTF_VARCHAR2_TABLE_100();
1465: a31 := JTF_VARCHAR2_TABLE_100();
1466: a32 := JTF_VARCHAR2_TABLE_100();
1467: a33 := JTF_VARCHAR2_TABLE_300();
1468: a34 := JTF_VARCHAR2_TABLE_300();
1469: a35 := JTF_VARCHAR2_TABLE_100();
1462: a28 := JTF_VARCHAR2_TABLE_100();
1463: a29 := JTF_VARCHAR2_TABLE_300();
1464: a30 := JTF_VARCHAR2_TABLE_100();
1465: a31 := JTF_VARCHAR2_TABLE_100();
1466: a32 := JTF_VARCHAR2_TABLE_100();
1467: a33 := JTF_VARCHAR2_TABLE_300();
1468: a34 := JTF_VARCHAR2_TABLE_300();
1469: a35 := JTF_VARCHAR2_TABLE_100();
1470: a36 := JTF_VARCHAR2_TABLE_300();
1465: a31 := JTF_VARCHAR2_TABLE_100();
1466: a32 := JTF_VARCHAR2_TABLE_100();
1467: a33 := JTF_VARCHAR2_TABLE_300();
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();
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();
1477: a43 := JTF_VARCHAR2_TABLE_300();
1478: a44 := JTF_VARCHAR2_TABLE_300();
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();
1504: a70 := JTF_VARCHAR2_TABLE_300();
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();
1507: a1 := JTF_VARCHAR2_TABLE_100();
1508: a2 := JTF_NUMBER_TABLE();
1509: a3 := JTF_NUMBER_TABLE();
1510: a4 := JTF_VARCHAR2_TABLE_100();
1503: a69 := JTF_VARCHAR2_TABLE_300();
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();
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();
1514: a8 := JTF_VARCHAR2_TABLE_100();
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();
1516: a10 := JTF_NUMBER_TABLE();
1517: a11 := JTF_VARCHAR2_TABLE_100();
1518: a12 := JTF_NUMBER_TABLE();
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();
1516: a10 := JTF_NUMBER_TABLE();
1517: a11 := JTF_VARCHAR2_TABLE_100();
1518: a12 := JTF_NUMBER_TABLE();
1519: a13 := JTF_NUMBER_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();
1521: a15 := JTF_NUMBER_TABLE();
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();
1524: a18 := JTF_NUMBER_TABLE();
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();
1526: a20 := JTF_NUMBER_TABLE();
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();
1531: a25 := JTF_VARCHAR2_TABLE_100();
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();
1531: a25 := JTF_VARCHAR2_TABLE_100();
1532: a26 := 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();
1531: a25 := JTF_VARCHAR2_TABLE_100();
1532: a26 := JTF_NUMBER_TABLE();
1533: a27 := JTF_VARCHAR2_TABLE_100();
1527: a21 := JTF_VARCHAR2_TABLE_100();
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();
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();
1537: a31 := 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();
1537: a31 := JTF_VARCHAR2_TABLE_100();
1538: a32 := 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();
1537: a31 := JTF_VARCHAR2_TABLE_100();
1538: a32 := JTF_VARCHAR2_TABLE_100();
1539: a33 := JTF_VARCHAR2_TABLE_300();
1540: a34 := JTF_VARCHAR2_TABLE_300();
1533: a27 := JTF_VARCHAR2_TABLE_100();
1534: a28 := JTF_VARCHAR2_TABLE_100();
1535: a29 := JTF_VARCHAR2_TABLE_300();
1536: a30 := JTF_VARCHAR2_TABLE_100();
1537: a31 := JTF_VARCHAR2_TABLE_100();
1538: a32 := JTF_VARCHAR2_TABLE_100();
1539: a33 := JTF_VARCHAR2_TABLE_300();
1540: a34 := JTF_VARCHAR2_TABLE_300();
1541: a35 := JTF_VARCHAR2_TABLE_100();
1534: a28 := JTF_VARCHAR2_TABLE_100();
1535: a29 := JTF_VARCHAR2_TABLE_300();
1536: a30 := JTF_VARCHAR2_TABLE_100();
1537: a31 := JTF_VARCHAR2_TABLE_100();
1538: a32 := JTF_VARCHAR2_TABLE_100();
1539: a33 := JTF_VARCHAR2_TABLE_300();
1540: a34 := JTF_VARCHAR2_TABLE_300();
1541: a35 := JTF_VARCHAR2_TABLE_100();
1542: a36 := JTF_VARCHAR2_TABLE_300();
1537: a31 := JTF_VARCHAR2_TABLE_100();
1538: a32 := JTF_VARCHAR2_TABLE_100();
1539: a33 := JTF_VARCHAR2_TABLE_300();
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();
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();
1549: a43 := JTF_VARCHAR2_TABLE_300();
1550: a44 := JTF_VARCHAR2_TABLE_300();
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();
1576: a70 := JTF_VARCHAR2_TABLE_300();
1729: end if;
1730: end if;
1731: end rosetta_table_copy_out_p17;
1732:
1733: procedure rosetta_table_copy_in_p19(t out nocopy ozf_offer_pub.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1734: , a1 JTF_VARCHAR2_TABLE_100
1735: , a2 JTF_VARCHAR2_TABLE_300
1736: , a3 JTF_VARCHAR2_TABLE_300
1737: , a4 JTF_VARCHAR2_TABLE_100
1730: end if;
1731: end rosetta_table_copy_out_p17;
1732:
1733: procedure rosetta_table_copy_in_p19(t out nocopy ozf_offer_pub.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
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
1733: procedure rosetta_table_copy_in_p19(t out nocopy ozf_offer_pub.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
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
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
1749: , a16 JTF_VARCHAR2_TABLE_300
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
1749: , a16 JTF_VARCHAR2_TABLE_300
1750: , a17 JTF_VARCHAR2_TABLE_300
1804: end loop;
1805: end if;
1806: end if;
1807: end rosetta_table_copy_in_p19;
1808: procedure rosetta_table_copy_out_p19(t ozf_offer_pub.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
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
1805: end if;
1806: end if;
1807: end rosetta_table_copy_in_p19;
1808: procedure rosetta_table_copy_out_p19(t ozf_offer_pub.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
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
1808: procedure rosetta_table_copy_out_p19(t ozf_offer_pub.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
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
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
1824: , a16 out nocopy JTF_VARCHAR2_TABLE_300
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
1824: , a16 out nocopy JTF_VARCHAR2_TABLE_300
1825: , a17 out nocopy JTF_VARCHAR2_TABLE_300
1837: ) as
1838: ddindx binary_integer; indx binary_integer;
1839: begin
1840: if t is null or t.count = 0 then
1841: a0 := JTF_VARCHAR2_TABLE_100();
1842: a1 := JTF_VARCHAR2_TABLE_100();
1843: a2 := JTF_VARCHAR2_TABLE_300();
1844: a3 := JTF_VARCHAR2_TABLE_300();
1845: a4 := JTF_VARCHAR2_TABLE_100();
1838: ddindx binary_integer; indx binary_integer;
1839: begin
1840: if t is null or t.count = 0 then
1841: a0 := JTF_VARCHAR2_TABLE_100();
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();
1841: a0 := JTF_VARCHAR2_TABLE_100();
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();
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();
1857: a16 := JTF_VARCHAR2_TABLE_300();
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();
1857: a16 := JTF_VARCHAR2_TABLE_300();
1858: a17 := JTF_VARCHAR2_TABLE_300();
1867: a26 := JTF_VARCHAR2_TABLE_300();
1868: a27 := JTF_VARCHAR2_TABLE_300();
1869: a28 := JTF_VARCHAR2_TABLE_300();
1870: else
1871: a0 := JTF_VARCHAR2_TABLE_100();
1872: a1 := JTF_VARCHAR2_TABLE_100();
1873: a2 := JTF_VARCHAR2_TABLE_300();
1874: a3 := JTF_VARCHAR2_TABLE_300();
1875: a4 := JTF_VARCHAR2_TABLE_100();
1868: a27 := JTF_VARCHAR2_TABLE_300();
1869: a28 := JTF_VARCHAR2_TABLE_300();
1870: else
1871: a0 := JTF_VARCHAR2_TABLE_100();
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();
1871: a0 := JTF_VARCHAR2_TABLE_100();
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();
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();
1887: a16 := JTF_VARCHAR2_TABLE_300();
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();
1887: a16 := JTF_VARCHAR2_TABLE_300();
1888: a17 := JTF_VARCHAR2_TABLE_300();
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
1980: , a8 JTF_VARCHAR2_TABLE_100
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
1980: , a8 JTF_VARCHAR2_TABLE_100
1981: , a9 JTF_VARCHAR2_TABLE_100
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
1980: , a8 JTF_VARCHAR2_TABLE_100
1981: , a9 JTF_VARCHAR2_TABLE_100
1982: , a10 JTF_VARCHAR2_TABLE_100
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
1984: , a12 JTF_NUMBER_TABLE
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
1984: , a12 JTF_NUMBER_TABLE
1985: , a13 JTF_NUMBER_TABLE
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
1984: , a12 JTF_NUMBER_TABLE
1985: , a13 JTF_NUMBER_TABLE
1986: , a14 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
1984: , a12 JTF_NUMBER_TABLE
1985: , a13 JTF_NUMBER_TABLE
1986: , a14 JTF_VARCHAR2_TABLE_100
1987: , a15 JTF_NUMBER_TABLE
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
1990: , a18 JTF_VARCHAR2_TABLE_2000
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
1993: ) as
1994: ddindx binary_integer; indx binary_integer;
1995: begin
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
2039: , a8 out nocopy JTF_VARCHAR2_TABLE_100
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
2039: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2040: , a9 out nocopy JTF_VARCHAR2_TABLE_100
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
2039: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2040: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2041: , a10 out nocopy JTF_VARCHAR2_TABLE_100
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
2043: , a12 out nocopy JTF_NUMBER_TABLE
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
2043: , a12 out nocopy JTF_NUMBER_TABLE
2044: , a13 out nocopy JTF_NUMBER_TABLE
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
2043: , a12 out nocopy JTF_NUMBER_TABLE
2044: , a13 out nocopy JTF_NUMBER_TABLE
2045: , a14 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
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
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
2049: , a18 out nocopy JTF_VARCHAR2_TABLE_2000
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
2052: ) as
2053: ddindx binary_integer; indx binary_integer;
2054: begin
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();
2064: a8 := JTF_VARCHAR2_TABLE_100();
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();
2064: a8 := JTF_VARCHAR2_TABLE_100();
2065: a9 := JTF_VARCHAR2_TABLE_100();
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();
2064: a8 := JTF_VARCHAR2_TABLE_100();
2065: a9 := JTF_VARCHAR2_TABLE_100();
2066: a10 := JTF_VARCHAR2_TABLE_100();
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();
2068: a12 := JTF_NUMBER_TABLE();
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();
2068: a12 := JTF_NUMBER_TABLE();
2069: a13 := JTF_NUMBER_TABLE();
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();
2068: a12 := JTF_NUMBER_TABLE();
2069: a13 := JTF_NUMBER_TABLE();
2070: a14 := 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();
2068: a12 := JTF_NUMBER_TABLE();
2069: a13 := JTF_NUMBER_TABLE();
2070: a14 := JTF_VARCHAR2_TABLE_100();
2071: a15 := JTF_NUMBER_TABLE();
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();
2074: a18 := JTF_VARCHAR2_TABLE_2000();
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();
2077: else
2078: a0 := JTF_NUMBER_TABLE();
2079: a1 := JTF_NUMBER_TABLE();
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();
2086: a8 := JTF_VARCHAR2_TABLE_100();
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();
2086: a8 := JTF_VARCHAR2_TABLE_100();
2087: a9 := JTF_VARCHAR2_TABLE_100();
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();
2086: a8 := JTF_VARCHAR2_TABLE_100();
2087: a9 := JTF_VARCHAR2_TABLE_100();
2088: a10 := JTF_VARCHAR2_TABLE_100();
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();
2090: a12 := JTF_NUMBER_TABLE();
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();
2090: a12 := JTF_NUMBER_TABLE();
2091: a13 := JTF_NUMBER_TABLE();
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();
2090: a12 := JTF_NUMBER_TABLE();
2091: a13 := JTF_NUMBER_TABLE();
2092: a14 := 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();
2090: a12 := JTF_NUMBER_TABLE();
2091: a13 := JTF_NUMBER_TABLE();
2092: a14 := JTF_VARCHAR2_TABLE_100();
2093: a15 := JTF_NUMBER_TABLE();
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();
2096: a18 := JTF_VARCHAR2_TABLE_2000();
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();
2099: if t.count > 0 then
2100: a0.extend(t.count);
2101: a1.extend(t.count);
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
2160: , a5 JTF_VARCHAR2_TABLE_100
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
2164: , a9 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
2164: , a9 JTF_VARCHAR2_TABLE_100
2165: , a10 JTF_VARCHAR2_TABLE_100
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
2164: , a9 JTF_VARCHAR2_TABLE_100
2165: , a10 JTF_VARCHAR2_TABLE_100
2166: , a11 JTF_NUMBER_TABLE
2167: ) as
2160: , a5 JTF_VARCHAR2_TABLE_100
2161: , a6 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;
2161: , a6 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
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
2201: , a5 out nocopy JTF_VARCHAR2_TABLE_100
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
2205: , a9 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
2205: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2206: , a10 out nocopy JTF_VARCHAR2_TABLE_100
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
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
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
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;
2202: , a6 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
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();
2217: a5 := JTF_VARCHAR2_TABLE_100();
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();
2221: a9 := 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();
2221: a9 := JTF_VARCHAR2_TABLE_100();
2222: a10 := JTF_VARCHAR2_TABLE_100();
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();
2221: a9 := JTF_VARCHAR2_TABLE_100();
2222: a10 := JTF_VARCHAR2_TABLE_100();
2223: a11 := JTF_NUMBER_TABLE();
2224: else
2217: a5 := JTF_VARCHAR2_TABLE_100();
2218: a6 := 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();
2218: a6 := 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();
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();
2230: a5 := JTF_VARCHAR2_TABLE_100();
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();
2234: a9 := 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();
2234: a9 := JTF_VARCHAR2_TABLE_100();
2235: a10 := JTF_VARCHAR2_TABLE_100();
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();
2234: a9 := JTF_VARCHAR2_TABLE_100();
2235: a10 := JTF_VARCHAR2_TABLE_100();
2236: a11 := JTF_NUMBER_TABLE();
2237: if t.count > 0 then
2230: a5 := JTF_VARCHAR2_TABLE_100();
2231: a6 := 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);
2231: a6 := 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);
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
2283: , a8 JTF_VARCHAR2_TABLE_100
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
2285: , a10 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
2285: , a10 JTF_NUMBER_TABLE
2286: , a11 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
2285: , a10 JTF_NUMBER_TABLE
2286: , a11 JTF_NUMBER_TABLE
2287: , a12 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
2291: if a0 is not null and a0.count > 0 then
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
2326: , a8 out nocopy JTF_VARCHAR2_TABLE_100
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
2328: , a10 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
2328: , a10 out nocopy JTF_NUMBER_TABLE
2329: , a11 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
2328: , a10 out nocopy JTF_NUMBER_TABLE
2329: , a11 out nocopy JTF_NUMBER_TABLE
2330: , a12 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
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();
2343: a8 := JTF_VARCHAR2_TABLE_100();
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();
2345: a10 := 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();
2345: a10 := JTF_NUMBER_TABLE();
2346: a11 := 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();
2345: a10 := JTF_NUMBER_TABLE();
2346: a11 := JTF_NUMBER_TABLE();
2347: a12 := 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();
2351: a2 := JTF_NUMBER_TABLE();
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();
2357: a8 := JTF_VARCHAR2_TABLE_100();
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();
2359: a10 := 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();
2359: a10 := JTF_NUMBER_TABLE();
2360: a11 := 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();
2359: a10 := JTF_NUMBER_TABLE();
2360: a11 := JTF_NUMBER_TABLE();
2361: a12 := 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);
2365: a2.extend(t.count);
2488: , p7_a79 NUMBER
2489: , p7_a80 VARCHAR2
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
2489: , p7_a80 VARCHAR2
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
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
2500: , p8_a8 JTF_VARCHAR2_TABLE_100
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
2502: , p8_a10 JTF_NUMBER_TABLE
2503: , p8_a11 JTF_VARCHAR2_TABLE_100
2504: , p8_a12 JTF_NUMBER_TABLE
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
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
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
2507: , p8_a15 JTF_NUMBER_TABLE
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
2510: , p8_a18 JTF_NUMBER_TABLE
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
2512: , p8_a20 JTF_NUMBER_TABLE
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
2517: , p8_a25 JTF_VARCHAR2_TABLE_100
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
2517: , p8_a25 JTF_VARCHAR2_TABLE_100
2518: , p8_a26 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
2517: , p8_a25 JTF_VARCHAR2_TABLE_100
2518: , p8_a26 JTF_NUMBER_TABLE
2519: , p8_a27 JTF_VARCHAR2_TABLE_100
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
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
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
2523: , p8_a31 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
2523: , p8_a31 JTF_VARCHAR2_TABLE_100
2524: , p8_a32 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
2523: , p8_a31 JTF_VARCHAR2_TABLE_100
2524: , p8_a32 JTF_VARCHAR2_TABLE_100
2525: , p8_a33 JTF_VARCHAR2_TABLE_300
2526: , p8_a34 JTF_VARCHAR2_TABLE_300
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
2523: , p8_a31 JTF_VARCHAR2_TABLE_100
2524: , p8_a32 JTF_VARCHAR2_TABLE_100
2525: , p8_a33 JTF_VARCHAR2_TABLE_300
2526: , p8_a34 JTF_VARCHAR2_TABLE_300
2527: , p8_a35 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
2523: , p8_a31 JTF_VARCHAR2_TABLE_100
2524: , p8_a32 JTF_VARCHAR2_TABLE_100
2525: , p8_a33 JTF_VARCHAR2_TABLE_300
2526: , p8_a34 JTF_VARCHAR2_TABLE_300
2527: , p8_a35 JTF_VARCHAR2_TABLE_100
2528: , p8_a36 JTF_VARCHAR2_TABLE_300
2523: , p8_a31 JTF_VARCHAR2_TABLE_100
2524: , p8_a32 JTF_VARCHAR2_TABLE_100
2525: , p8_a33 JTF_VARCHAR2_TABLE_300
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
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
2535: , p8_a43 JTF_VARCHAR2_TABLE_300
2536: , p8_a44 JTF_VARCHAR2_TABLE_300
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
2562: , p8_a70 JTF_VARCHAR2_TABLE_300
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
2565: , p9_a2 JTF_VARCHAR2_TABLE_300
2566: , p9_a3 JTF_VARCHAR2_TABLE_300
2567: , p9_a4 JTF_VARCHAR2_TABLE_100
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
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
2563: , p9_a0 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
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
2579: , p9_a16 JTF_VARCHAR2_TABLE_300
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
2579: , p9_a16 JTF_VARCHAR2_TABLE_300
2580: , p9_a17 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
2599: , p11_a3 JTF_VARCHAR2_TABLE_100
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
2603: , p11_a7 JTF_NUMBER_TABLE
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
2603: , p11_a7 JTF_NUMBER_TABLE
2604: , p11_a8 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
2603: , p11_a7 JTF_NUMBER_TABLE
2604: , p11_a8 JTF_NUMBER_TABLE
2605: , p11_a9 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
2603: , p11_a7 JTF_NUMBER_TABLE
2604: , p11_a8 JTF_NUMBER_TABLE
2605: , p11_a9 JTF_NUMBER_TABLE
2606: , p11_a10 JTF_NUMBER_TABLE
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
2611: , p11_a15 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
2611: , p11_a15 JTF_NUMBER_TABLE
2612: , p11_a16 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
2611: , p11_a15 JTF_NUMBER_TABLE
2612: , p11_a16 JTF_NUMBER_TABLE
2613: , p11_a17 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
2617: , p11_a21 JTF_NUMBER_TABLE
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
2617: , p11_a21 JTF_NUMBER_TABLE
2618: , p11_a22 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
2622: , p12_a3 JTF_NUMBER_TABLE
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
2627: , p12_a8 JTF_VARCHAR2_TABLE_100
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
2627: , p12_a8 JTF_VARCHAR2_TABLE_100
2628: , p12_a9 JTF_VARCHAR2_TABLE_100
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
2627: , p12_a8 JTF_VARCHAR2_TABLE_100
2628: , p12_a9 JTF_VARCHAR2_TABLE_100
2629: , p12_a10 JTF_VARCHAR2_TABLE_100
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
2631: , p12_a12 JTF_NUMBER_TABLE
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
2631: , p12_a12 JTF_NUMBER_TABLE
2632: , p12_a13 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
2631: , p12_a12 JTF_NUMBER_TABLE
2632: , p12_a13 JTF_VARCHAR2_TABLE_100
2633: , p12_a14 JTF_NUMBER_TABLE
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
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
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
2636: , p12_a17 JTF_NUMBER_TABLE
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
2641: , p12_a22 JTF_DATE_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
2641: , p12_a22 JTF_DATE_TABLE
2642: , p12_a23 JTF_NUMBER_TABLE
2643: , p12_a24 JTF_DATE_TABLE
2644: , p12_a25 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
2654: , p13_a0 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
2656: , p13_a2 JTF_VARCHAR2_TABLE_100
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
2656: , p13_a2 JTF_VARCHAR2_TABLE_100
2657: , p13_a3 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
2660: , p13_a6 JTF_DATE_TABLE
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
2663: , p14_a1 JTF_NUMBER_TABLE
2664: , p14_a2 JTF_NUMBER_TABLE
2665: , p14_a3 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
2671: , p14_a9 JTF_VARCHAR2_TABLE_100
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
2671: , p14_a9 JTF_VARCHAR2_TABLE_100
2672: , p14_a10 JTF_DATE_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
2671: , p14_a9 JTF_VARCHAR2_TABLE_100
2672: , p14_a10 JTF_DATE_TABLE
2673: , p14_a11 JTF_DATE_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
2675: , p14_a13 JTF_NUMBER_TABLE
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
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
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
2680: , p15_a3 JTF_NUMBER_TABLE
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
2683: , p15_a6 JTF_DATE_TABLE
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
2685: , p15_a8 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
2685: , p15_a8 JTF_NUMBER_TABLE
2686: , p15_a9 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
2697: , p16_a3 JTF_DATE_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
2705: , p16_a11 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
2705: , p16_a11 JTF_DATE_TABLE
2706: , p16_a12 JTF_NUMBER_TABLE
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
2712: , p16_a18 JTF_VARCHAR2_TABLE_300
2720: , p16_a26 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
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: )
2730:
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
3231: , p7_a8 JTF_VARCHAR2_TABLE_100
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
3231: , p7_a8 JTF_VARCHAR2_TABLE_100
3232: , p7_a9 JTF_VARCHAR2_TABLE_100
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
3231: , p7_a8 JTF_VARCHAR2_TABLE_100
3232: , p7_a9 JTF_VARCHAR2_TABLE_100
3233: , p7_a10 JTF_VARCHAR2_TABLE_100
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
3235: , p7_a12 JTF_NUMBER_TABLE
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
3235: , p7_a12 JTF_NUMBER_TABLE
3236: , p7_a13 JTF_NUMBER_TABLE
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
3235: , p7_a12 JTF_NUMBER_TABLE
3236: , p7_a13 JTF_NUMBER_TABLE
3237: , p7_a14 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
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
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
3241: , p7_a18 JTF_VARCHAR2_TABLE_2000
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
3244: , p8_a0 JTF_NUMBER_TABLE
3245: , p8_a1 JTF_NUMBER_TABLE
3246: , p8_a2 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
3252: , p8_a8 JTF_VARCHAR2_TABLE_100
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
3252: , p8_a8 JTF_VARCHAR2_TABLE_100
3253: , p8_a9 JTF_VARCHAR2_TABLE_100
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
3252: , p8_a8 JTF_VARCHAR2_TABLE_100
3253: , p8_a9 JTF_VARCHAR2_TABLE_100
3254: , p8_a10 JTF_VARCHAR2_TABLE_100
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
3256: , p8_a12 JTF_NUMBER_TABLE
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
3256: , p8_a12 JTF_NUMBER_TABLE
3257: , p8_a13 JTF_NUMBER_TABLE
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
3256: , p8_a12 JTF_NUMBER_TABLE
3257: , p8_a13 JTF_NUMBER_TABLE
3258: , p8_a14 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
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
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
3262: , p8_a18 JTF_VARCHAR2_TABLE_2000
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
3265: , p9_a0 JTF_NUMBER_TABLE
3266: , p9_a1 JTF_VARCHAR2_TABLE_100
3267: , p9_a2 JTF_NUMBER_TABLE
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
3270: , p9_a5 JTF_VARCHAR2_TABLE_100
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
3274: , p9_a9 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
3274: , p9_a9 JTF_VARCHAR2_TABLE_100
3275: , p9_a10 JTF_VARCHAR2_TABLE_100
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
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
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
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
3271: , p9_a6 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
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
3281: , p10_a4 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
3281: , p10_a4 JTF_VARCHAR2_TABLE_100
3282: , p10_a5 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
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
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
3293: , p10_a16 JTF_VARCHAR2_TABLE_300
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
3293: , p10_a16 JTF_VARCHAR2_TABLE_300
3294: , p10_a17 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
3314: , p11_a8 JTF_VARCHAR2_TABLE_100
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
3316: , p11_a10 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
3316: , p11_a10 JTF_NUMBER_TABLE
3317: , p11_a11 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
3316: , p11_a10 JTF_NUMBER_TABLE
3317: , p11_a11 JTF_NUMBER_TABLE
3318: , p11_a12 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
3322: , p12_a3 JTF_VARCHAR2_TABLE_100
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: )
3326: