9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p3(t out nocopy ozf_trade_profile_pvt.trade_profile_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p3(t out nocopy ozf_trade_profile_pvt.trade_profile_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
12:
13: procedure rosetta_table_copy_in_p3(t out nocopy ozf_trade_profile_pvt.trade_profile_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_DATE_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_DATE_TABLE
23: , a10 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_DATE_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_DATE_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_DATE_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_NUMBER_TABLE
26: , a13 JTF_NUMBER_TABLE
27: , a14 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_DATE_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_NUMBER_TABLE
26: , a13 JTF_NUMBER_TABLE
27: , a14 JTF_VARCHAR2_TABLE_100
28: , a15 JTF_NUMBER_TABLE
29: , a16 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_DATE_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_NUMBER_TABLE
26: , a13 JTF_NUMBER_TABLE
27: , a14 JTF_VARCHAR2_TABLE_100
28: , a15 JTF_NUMBER_TABLE
29: , a16 JTF_VARCHAR2_TABLE_100
30: , a17 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_NUMBER_TABLE
26: , a13 JTF_NUMBER_TABLE
27: , a14 JTF_VARCHAR2_TABLE_100
28: , a15 JTF_NUMBER_TABLE
29: , a16 JTF_VARCHAR2_TABLE_100
30: , a17 JTF_VARCHAR2_TABLE_100
31: , a18 JTF_VARCHAR2_TABLE_100
32: , a19 JTF_VARCHAR2_TABLE_100
29: , a16 JTF_VARCHAR2_TABLE_100
30: , a17 JTF_VARCHAR2_TABLE_100
31: , a18 JTF_VARCHAR2_TABLE_100
32: , a19 JTF_VARCHAR2_TABLE_100
33: , a20 JTF_NUMBER_TABLE
34: , a21 JTF_VARCHAR2_TABLE_100
35: , a22 JTF_VARCHAR2_TABLE_100
36: , a23 JTF_VARCHAR2_TABLE_100
37: , a24 JTF_NUMBER_TABLE
33: , a20 JTF_NUMBER_TABLE
34: , a21 JTF_VARCHAR2_TABLE_100
35: , a22 JTF_VARCHAR2_TABLE_100
36: , a23 JTF_VARCHAR2_TABLE_100
37: , a24 JTF_NUMBER_TABLE
38: , a25 JTF_NUMBER_TABLE
39: , a26 JTF_NUMBER_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_VARCHAR2_TABLE_100
34: , a21 JTF_VARCHAR2_TABLE_100
35: , a22 JTF_VARCHAR2_TABLE_100
36: , a23 JTF_VARCHAR2_TABLE_100
37: , a24 JTF_NUMBER_TABLE
38: , a25 JTF_NUMBER_TABLE
39: , a26 JTF_NUMBER_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_VARCHAR2_TABLE_100
42: , a29 JTF_VARCHAR2_TABLE_100
35: , a22 JTF_VARCHAR2_TABLE_100
36: , a23 JTF_VARCHAR2_TABLE_100
37: , a24 JTF_NUMBER_TABLE
38: , a25 JTF_NUMBER_TABLE
39: , a26 JTF_NUMBER_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_VARCHAR2_TABLE_100
42: , a29 JTF_VARCHAR2_TABLE_100
43: , a30 JTF_VARCHAR2_TABLE_100
36: , a23 JTF_VARCHAR2_TABLE_100
37: , a24 JTF_NUMBER_TABLE
38: , a25 JTF_NUMBER_TABLE
39: , a26 JTF_NUMBER_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_VARCHAR2_TABLE_100
42: , a29 JTF_VARCHAR2_TABLE_100
43: , a30 JTF_VARCHAR2_TABLE_100
44: , a31 JTF_VARCHAR2_TABLE_200
55: , a42 JTF_VARCHAR2_TABLE_200
56: , a43 JTF_VARCHAR2_TABLE_200
57: , a44 JTF_VARCHAR2_TABLE_200
58: , a45 JTF_VARCHAR2_TABLE_200
59: , a46 JTF_NUMBER_TABLE
60: , a47 JTF_NUMBER_TABLE
61: , a48 JTF_NUMBER_TABLE
62: , a49 JTF_NUMBER_TABLE
63: , a50 JTF_VARCHAR2_TABLE_100
56: , a43 JTF_VARCHAR2_TABLE_200
57: , a44 JTF_VARCHAR2_TABLE_200
58: , a45 JTF_VARCHAR2_TABLE_200
59: , a46 JTF_NUMBER_TABLE
60: , a47 JTF_NUMBER_TABLE
61: , a48 JTF_NUMBER_TABLE
62: , a49 JTF_NUMBER_TABLE
63: , a50 JTF_VARCHAR2_TABLE_100
64: , a51 JTF_VARCHAR2_TABLE_100
57: , a44 JTF_VARCHAR2_TABLE_200
58: , a45 JTF_VARCHAR2_TABLE_200
59: , a46 JTF_NUMBER_TABLE
60: , a47 JTF_NUMBER_TABLE
61: , a48 JTF_NUMBER_TABLE
62: , a49 JTF_NUMBER_TABLE
63: , a50 JTF_VARCHAR2_TABLE_100
64: , a51 JTF_VARCHAR2_TABLE_100
65: , a52 JTF_NUMBER_TABLE
58: , a45 JTF_VARCHAR2_TABLE_200
59: , a46 JTF_NUMBER_TABLE
60: , a47 JTF_NUMBER_TABLE
61: , a48 JTF_NUMBER_TABLE
62: , a49 JTF_NUMBER_TABLE
63: , a50 JTF_VARCHAR2_TABLE_100
64: , a51 JTF_VARCHAR2_TABLE_100
65: , a52 JTF_NUMBER_TABLE
66: , a53 JTF_VARCHAR2_TABLE_100
61: , a48 JTF_NUMBER_TABLE
62: , a49 JTF_NUMBER_TABLE
63: , a50 JTF_VARCHAR2_TABLE_100
64: , a51 JTF_VARCHAR2_TABLE_100
65: , a52 JTF_NUMBER_TABLE
66: , a53 JTF_VARCHAR2_TABLE_100
67: , a54 JTF_VARCHAR2_TABLE_100
68: , a55 JTF_NUMBER_TABLE
69: , a56 JTF_VARCHAR2_TABLE_100
64: , a51 JTF_VARCHAR2_TABLE_100
65: , a52 JTF_NUMBER_TABLE
66: , a53 JTF_VARCHAR2_TABLE_100
67: , a54 JTF_VARCHAR2_TABLE_100
68: , a55 JTF_NUMBER_TABLE
69: , a56 JTF_VARCHAR2_TABLE_100
70: , a57 JTF_NUMBER_TABLE
71: ) as
72: ddindx binary_integer; indx binary_integer;
66: , a53 JTF_VARCHAR2_TABLE_100
67: , a54 JTF_VARCHAR2_TABLE_100
68: , a55 JTF_NUMBER_TABLE
69: , a56 JTF_VARCHAR2_TABLE_100
70: , a57 JTF_NUMBER_TABLE
71: ) as
72: ddindx binary_integer; indx binary_integer;
73: begin
74: if a0 is not null and a0.count > 0 then
142: end loop;
143: end if;
144: end if;
145: end rosetta_table_copy_in_p3;
146: procedure rosetta_table_copy_out_p3(t ozf_trade_profile_pvt.trade_profile_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_DATE_TABLE
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_DATE_TABLE
143: end if;
144: end if;
145: end rosetta_table_copy_in_p3;
146: procedure rosetta_table_copy_out_p3(t ozf_trade_profile_pvt.trade_profile_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_DATE_TABLE
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_DATE_TABLE
151: , a5 out nocopy JTF_NUMBER_TABLE
145: end rosetta_table_copy_in_p3;
146: procedure rosetta_table_copy_out_p3(t ozf_trade_profile_pvt.trade_profile_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_DATE_TABLE
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_DATE_TABLE
151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_NUMBER_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_NUMBER_TABLE
148: , a2 out nocopy JTF_DATE_TABLE
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_DATE_TABLE
151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_NUMBER_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
154: , a8 out nocopy JTF_NUMBER_TABLE
155: , a9 out nocopy JTF_DATE_TABLE
148: , a2 out nocopy JTF_DATE_TABLE
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_DATE_TABLE
151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_NUMBER_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
154: , a8 out nocopy JTF_NUMBER_TABLE
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_NUMBER_TABLE
149: , a3 out nocopy JTF_NUMBER_TABLE
150: , a4 out nocopy JTF_DATE_TABLE
151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_NUMBER_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
154: , a8 out nocopy JTF_NUMBER_TABLE
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_NUMBER_TABLE
157: , a11 out nocopy JTF_VARCHAR2_TABLE_100
150: , a4 out nocopy JTF_DATE_TABLE
151: , a5 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_NUMBER_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
154: , a8 out nocopy JTF_NUMBER_TABLE
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_NUMBER_TABLE
157: , a11 out nocopy JTF_VARCHAR2_TABLE_100
158: , a12 out nocopy JTF_NUMBER_TABLE
152: , a6 out nocopy JTF_NUMBER_TABLE
153: , a7 out nocopy JTF_NUMBER_TABLE
154: , a8 out nocopy JTF_NUMBER_TABLE
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_NUMBER_TABLE
157: , a11 out nocopy JTF_VARCHAR2_TABLE_100
158: , a12 out nocopy JTF_NUMBER_TABLE
159: , a13 out nocopy JTF_NUMBER_TABLE
160: , a14 out nocopy JTF_VARCHAR2_TABLE_100
154: , a8 out nocopy JTF_NUMBER_TABLE
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_NUMBER_TABLE
157: , a11 out nocopy JTF_VARCHAR2_TABLE_100
158: , a12 out nocopy JTF_NUMBER_TABLE
159: , a13 out nocopy JTF_NUMBER_TABLE
160: , a14 out nocopy JTF_VARCHAR2_TABLE_100
161: , a15 out nocopy JTF_NUMBER_TABLE
162: , a16 out nocopy JTF_VARCHAR2_TABLE_100
155: , a9 out nocopy JTF_DATE_TABLE
156: , a10 out nocopy JTF_NUMBER_TABLE
157: , a11 out nocopy JTF_VARCHAR2_TABLE_100
158: , a12 out nocopy JTF_NUMBER_TABLE
159: , a13 out nocopy JTF_NUMBER_TABLE
160: , a14 out nocopy JTF_VARCHAR2_TABLE_100
161: , a15 out nocopy JTF_NUMBER_TABLE
162: , a16 out nocopy JTF_VARCHAR2_TABLE_100
163: , a17 out nocopy JTF_VARCHAR2_TABLE_100
157: , a11 out nocopy JTF_VARCHAR2_TABLE_100
158: , a12 out nocopy JTF_NUMBER_TABLE
159: , a13 out nocopy JTF_NUMBER_TABLE
160: , a14 out nocopy JTF_VARCHAR2_TABLE_100
161: , a15 out nocopy JTF_NUMBER_TABLE
162: , a16 out nocopy JTF_VARCHAR2_TABLE_100
163: , a17 out nocopy JTF_VARCHAR2_TABLE_100
164: , a18 out nocopy JTF_VARCHAR2_TABLE_100
165: , a19 out nocopy JTF_VARCHAR2_TABLE_100
162: , a16 out nocopy JTF_VARCHAR2_TABLE_100
163: , a17 out nocopy JTF_VARCHAR2_TABLE_100
164: , a18 out nocopy JTF_VARCHAR2_TABLE_100
165: , a19 out nocopy JTF_VARCHAR2_TABLE_100
166: , a20 out nocopy JTF_NUMBER_TABLE
167: , a21 out nocopy JTF_VARCHAR2_TABLE_100
168: , a22 out nocopy JTF_VARCHAR2_TABLE_100
169: , a23 out nocopy JTF_VARCHAR2_TABLE_100
170: , a24 out nocopy JTF_NUMBER_TABLE
166: , a20 out nocopy JTF_NUMBER_TABLE
167: , a21 out nocopy JTF_VARCHAR2_TABLE_100
168: , a22 out nocopy JTF_VARCHAR2_TABLE_100
169: , a23 out nocopy JTF_VARCHAR2_TABLE_100
170: , a24 out nocopy JTF_NUMBER_TABLE
171: , a25 out nocopy JTF_NUMBER_TABLE
172: , a26 out nocopy JTF_NUMBER_TABLE
173: , a27 out nocopy JTF_NUMBER_TABLE
174: , a28 out nocopy JTF_VARCHAR2_TABLE_100
167: , a21 out nocopy JTF_VARCHAR2_TABLE_100
168: , a22 out nocopy JTF_VARCHAR2_TABLE_100
169: , a23 out nocopy JTF_VARCHAR2_TABLE_100
170: , a24 out nocopy JTF_NUMBER_TABLE
171: , a25 out nocopy JTF_NUMBER_TABLE
172: , a26 out nocopy JTF_NUMBER_TABLE
173: , a27 out nocopy JTF_NUMBER_TABLE
174: , a28 out nocopy JTF_VARCHAR2_TABLE_100
175: , a29 out nocopy JTF_VARCHAR2_TABLE_100
168: , a22 out nocopy JTF_VARCHAR2_TABLE_100
169: , a23 out nocopy JTF_VARCHAR2_TABLE_100
170: , a24 out nocopy JTF_NUMBER_TABLE
171: , a25 out nocopy JTF_NUMBER_TABLE
172: , a26 out nocopy JTF_NUMBER_TABLE
173: , a27 out nocopy JTF_NUMBER_TABLE
174: , a28 out nocopy JTF_VARCHAR2_TABLE_100
175: , a29 out nocopy JTF_VARCHAR2_TABLE_100
176: , a30 out nocopy JTF_VARCHAR2_TABLE_100
169: , a23 out nocopy JTF_VARCHAR2_TABLE_100
170: , a24 out nocopy JTF_NUMBER_TABLE
171: , a25 out nocopy JTF_NUMBER_TABLE
172: , a26 out nocopy JTF_NUMBER_TABLE
173: , a27 out nocopy JTF_NUMBER_TABLE
174: , a28 out nocopy JTF_VARCHAR2_TABLE_100
175: , a29 out nocopy JTF_VARCHAR2_TABLE_100
176: , a30 out nocopy JTF_VARCHAR2_TABLE_100
177: , a31 out nocopy JTF_VARCHAR2_TABLE_200
188: , a42 out nocopy JTF_VARCHAR2_TABLE_200
189: , a43 out nocopy JTF_VARCHAR2_TABLE_200
190: , a44 out nocopy JTF_VARCHAR2_TABLE_200
191: , a45 out nocopy JTF_VARCHAR2_TABLE_200
192: , a46 out nocopy JTF_NUMBER_TABLE
193: , a47 out nocopy JTF_NUMBER_TABLE
194: , a48 out nocopy JTF_NUMBER_TABLE
195: , a49 out nocopy JTF_NUMBER_TABLE
196: , a50 out nocopy JTF_VARCHAR2_TABLE_100
189: , a43 out nocopy JTF_VARCHAR2_TABLE_200
190: , a44 out nocopy JTF_VARCHAR2_TABLE_200
191: , a45 out nocopy JTF_VARCHAR2_TABLE_200
192: , a46 out nocopy JTF_NUMBER_TABLE
193: , a47 out nocopy JTF_NUMBER_TABLE
194: , a48 out nocopy JTF_NUMBER_TABLE
195: , a49 out nocopy JTF_NUMBER_TABLE
196: , a50 out nocopy JTF_VARCHAR2_TABLE_100
197: , a51 out nocopy JTF_VARCHAR2_TABLE_100
190: , a44 out nocopy JTF_VARCHAR2_TABLE_200
191: , a45 out nocopy JTF_VARCHAR2_TABLE_200
192: , a46 out nocopy JTF_NUMBER_TABLE
193: , a47 out nocopy JTF_NUMBER_TABLE
194: , a48 out nocopy JTF_NUMBER_TABLE
195: , a49 out nocopy JTF_NUMBER_TABLE
196: , a50 out nocopy JTF_VARCHAR2_TABLE_100
197: , a51 out nocopy JTF_VARCHAR2_TABLE_100
198: , a52 out nocopy JTF_NUMBER_TABLE
191: , a45 out nocopy JTF_VARCHAR2_TABLE_200
192: , a46 out nocopy JTF_NUMBER_TABLE
193: , a47 out nocopy JTF_NUMBER_TABLE
194: , a48 out nocopy JTF_NUMBER_TABLE
195: , a49 out nocopy JTF_NUMBER_TABLE
196: , a50 out nocopy JTF_VARCHAR2_TABLE_100
197: , a51 out nocopy JTF_VARCHAR2_TABLE_100
198: , a52 out nocopy JTF_NUMBER_TABLE
199: , a53 out nocopy JTF_VARCHAR2_TABLE_100
194: , a48 out nocopy JTF_NUMBER_TABLE
195: , a49 out nocopy JTF_NUMBER_TABLE
196: , a50 out nocopy JTF_VARCHAR2_TABLE_100
197: , a51 out nocopy JTF_VARCHAR2_TABLE_100
198: , a52 out nocopy JTF_NUMBER_TABLE
199: , a53 out nocopy JTF_VARCHAR2_TABLE_100
200: , a54 out nocopy JTF_VARCHAR2_TABLE_100
201: , a55 out nocopy JTF_NUMBER_TABLE
202: , a56 out nocopy JTF_VARCHAR2_TABLE_100
197: , a51 out nocopy JTF_VARCHAR2_TABLE_100
198: , a52 out nocopy JTF_NUMBER_TABLE
199: , a53 out nocopy JTF_VARCHAR2_TABLE_100
200: , a54 out nocopy JTF_VARCHAR2_TABLE_100
201: , a55 out nocopy JTF_NUMBER_TABLE
202: , a56 out nocopy JTF_VARCHAR2_TABLE_100
203: , a57 out nocopy JTF_NUMBER_TABLE
204: ) as
205: ddindx binary_integer; indx binary_integer;
199: , a53 out nocopy JTF_VARCHAR2_TABLE_100
200: , a54 out nocopy JTF_VARCHAR2_TABLE_100
201: , a55 out nocopy JTF_NUMBER_TABLE
202: , a56 out nocopy JTF_VARCHAR2_TABLE_100
203: , a57 out nocopy JTF_NUMBER_TABLE
204: ) as
205: ddindx binary_integer; indx binary_integer;
206: begin
207: if t is null or t.count = 0 then
204: ) as
205: ddindx binary_integer; indx binary_integer;
206: begin
207: if t is null or t.count = 0 then
208: a0 := JTF_NUMBER_TABLE();
209: a1 := JTF_NUMBER_TABLE();
210: a2 := JTF_DATE_TABLE();
211: a3 := JTF_NUMBER_TABLE();
212: a4 := JTF_DATE_TABLE();
205: ddindx binary_integer; indx binary_integer;
206: begin
207: if t is null or t.count = 0 then
208: a0 := JTF_NUMBER_TABLE();
209: a1 := JTF_NUMBER_TABLE();
210: a2 := JTF_DATE_TABLE();
211: a3 := JTF_NUMBER_TABLE();
212: a4 := JTF_DATE_TABLE();
213: a5 := JTF_NUMBER_TABLE();
207: if t is null or t.count = 0 then
208: a0 := JTF_NUMBER_TABLE();
209: a1 := JTF_NUMBER_TABLE();
210: a2 := JTF_DATE_TABLE();
211: a3 := JTF_NUMBER_TABLE();
212: a4 := JTF_DATE_TABLE();
213: a5 := JTF_NUMBER_TABLE();
214: a6 := JTF_NUMBER_TABLE();
215: a7 := JTF_NUMBER_TABLE();
209: a1 := JTF_NUMBER_TABLE();
210: a2 := JTF_DATE_TABLE();
211: a3 := JTF_NUMBER_TABLE();
212: a4 := JTF_DATE_TABLE();
213: a5 := JTF_NUMBER_TABLE();
214: a6 := JTF_NUMBER_TABLE();
215: a7 := JTF_NUMBER_TABLE();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_DATE_TABLE();
210: a2 := JTF_DATE_TABLE();
211: a3 := JTF_NUMBER_TABLE();
212: a4 := JTF_DATE_TABLE();
213: a5 := JTF_NUMBER_TABLE();
214: a6 := JTF_NUMBER_TABLE();
215: a7 := JTF_NUMBER_TABLE();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_DATE_TABLE();
218: a10 := JTF_NUMBER_TABLE();
211: a3 := JTF_NUMBER_TABLE();
212: a4 := JTF_DATE_TABLE();
213: a5 := JTF_NUMBER_TABLE();
214: a6 := JTF_NUMBER_TABLE();
215: a7 := JTF_NUMBER_TABLE();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_DATE_TABLE();
218: a10 := JTF_NUMBER_TABLE();
219: a11 := JTF_VARCHAR2_TABLE_100();
212: a4 := JTF_DATE_TABLE();
213: a5 := JTF_NUMBER_TABLE();
214: a6 := JTF_NUMBER_TABLE();
215: a7 := JTF_NUMBER_TABLE();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_DATE_TABLE();
218: a10 := JTF_NUMBER_TABLE();
219: a11 := JTF_VARCHAR2_TABLE_100();
220: a12 := JTF_NUMBER_TABLE();
214: a6 := JTF_NUMBER_TABLE();
215: a7 := JTF_NUMBER_TABLE();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_DATE_TABLE();
218: a10 := JTF_NUMBER_TABLE();
219: a11 := JTF_VARCHAR2_TABLE_100();
220: a12 := JTF_NUMBER_TABLE();
221: a13 := JTF_NUMBER_TABLE();
222: a14 := JTF_VARCHAR2_TABLE_100();
216: a8 := JTF_NUMBER_TABLE();
217: a9 := JTF_DATE_TABLE();
218: a10 := JTF_NUMBER_TABLE();
219: a11 := JTF_VARCHAR2_TABLE_100();
220: a12 := JTF_NUMBER_TABLE();
221: a13 := JTF_NUMBER_TABLE();
222: a14 := JTF_VARCHAR2_TABLE_100();
223: a15 := JTF_NUMBER_TABLE();
224: a16 := JTF_VARCHAR2_TABLE_100();
217: a9 := JTF_DATE_TABLE();
218: a10 := JTF_NUMBER_TABLE();
219: a11 := JTF_VARCHAR2_TABLE_100();
220: a12 := JTF_NUMBER_TABLE();
221: a13 := JTF_NUMBER_TABLE();
222: a14 := JTF_VARCHAR2_TABLE_100();
223: a15 := JTF_NUMBER_TABLE();
224: a16 := JTF_VARCHAR2_TABLE_100();
225: a17 := JTF_VARCHAR2_TABLE_100();
219: a11 := JTF_VARCHAR2_TABLE_100();
220: a12 := JTF_NUMBER_TABLE();
221: a13 := JTF_NUMBER_TABLE();
222: a14 := JTF_VARCHAR2_TABLE_100();
223: a15 := JTF_NUMBER_TABLE();
224: a16 := JTF_VARCHAR2_TABLE_100();
225: a17 := JTF_VARCHAR2_TABLE_100();
226: a18 := JTF_VARCHAR2_TABLE_100();
227: a19 := JTF_VARCHAR2_TABLE_100();
224: a16 := JTF_VARCHAR2_TABLE_100();
225: a17 := JTF_VARCHAR2_TABLE_100();
226: a18 := JTF_VARCHAR2_TABLE_100();
227: a19 := JTF_VARCHAR2_TABLE_100();
228: a20 := JTF_NUMBER_TABLE();
229: a21 := JTF_VARCHAR2_TABLE_100();
230: a22 := JTF_VARCHAR2_TABLE_100();
231: a23 := JTF_VARCHAR2_TABLE_100();
232: a24 := JTF_NUMBER_TABLE();
228: a20 := JTF_NUMBER_TABLE();
229: a21 := JTF_VARCHAR2_TABLE_100();
230: a22 := JTF_VARCHAR2_TABLE_100();
231: a23 := JTF_VARCHAR2_TABLE_100();
232: a24 := JTF_NUMBER_TABLE();
233: a25 := JTF_NUMBER_TABLE();
234: a26 := JTF_NUMBER_TABLE();
235: a27 := JTF_NUMBER_TABLE();
236: a28 := JTF_VARCHAR2_TABLE_100();
229: a21 := JTF_VARCHAR2_TABLE_100();
230: a22 := JTF_VARCHAR2_TABLE_100();
231: a23 := JTF_VARCHAR2_TABLE_100();
232: a24 := JTF_NUMBER_TABLE();
233: a25 := JTF_NUMBER_TABLE();
234: a26 := JTF_NUMBER_TABLE();
235: a27 := JTF_NUMBER_TABLE();
236: a28 := JTF_VARCHAR2_TABLE_100();
237: a29 := JTF_VARCHAR2_TABLE_100();
230: a22 := JTF_VARCHAR2_TABLE_100();
231: a23 := JTF_VARCHAR2_TABLE_100();
232: a24 := JTF_NUMBER_TABLE();
233: a25 := JTF_NUMBER_TABLE();
234: a26 := JTF_NUMBER_TABLE();
235: a27 := JTF_NUMBER_TABLE();
236: a28 := JTF_VARCHAR2_TABLE_100();
237: a29 := JTF_VARCHAR2_TABLE_100();
238: a30 := JTF_VARCHAR2_TABLE_100();
231: a23 := JTF_VARCHAR2_TABLE_100();
232: a24 := JTF_NUMBER_TABLE();
233: a25 := JTF_NUMBER_TABLE();
234: a26 := JTF_NUMBER_TABLE();
235: a27 := JTF_NUMBER_TABLE();
236: a28 := JTF_VARCHAR2_TABLE_100();
237: a29 := JTF_VARCHAR2_TABLE_100();
238: a30 := JTF_VARCHAR2_TABLE_100();
239: a31 := JTF_VARCHAR2_TABLE_200();
250: a42 := JTF_VARCHAR2_TABLE_200();
251: a43 := JTF_VARCHAR2_TABLE_200();
252: a44 := JTF_VARCHAR2_TABLE_200();
253: a45 := JTF_VARCHAR2_TABLE_200();
254: a46 := JTF_NUMBER_TABLE();
255: a47 := JTF_NUMBER_TABLE();
256: a48 := JTF_NUMBER_TABLE();
257: a49 := JTF_NUMBER_TABLE();
258: a50 := JTF_VARCHAR2_TABLE_100();
251: a43 := JTF_VARCHAR2_TABLE_200();
252: a44 := JTF_VARCHAR2_TABLE_200();
253: a45 := JTF_VARCHAR2_TABLE_200();
254: a46 := JTF_NUMBER_TABLE();
255: a47 := JTF_NUMBER_TABLE();
256: a48 := JTF_NUMBER_TABLE();
257: a49 := JTF_NUMBER_TABLE();
258: a50 := JTF_VARCHAR2_TABLE_100();
259: a51 := JTF_VARCHAR2_TABLE_100();
252: a44 := JTF_VARCHAR2_TABLE_200();
253: a45 := JTF_VARCHAR2_TABLE_200();
254: a46 := JTF_NUMBER_TABLE();
255: a47 := JTF_NUMBER_TABLE();
256: a48 := JTF_NUMBER_TABLE();
257: a49 := JTF_NUMBER_TABLE();
258: a50 := JTF_VARCHAR2_TABLE_100();
259: a51 := JTF_VARCHAR2_TABLE_100();
260: a52 := JTF_NUMBER_TABLE();
253: a45 := JTF_VARCHAR2_TABLE_200();
254: a46 := JTF_NUMBER_TABLE();
255: a47 := JTF_NUMBER_TABLE();
256: a48 := JTF_NUMBER_TABLE();
257: a49 := JTF_NUMBER_TABLE();
258: a50 := JTF_VARCHAR2_TABLE_100();
259: a51 := JTF_VARCHAR2_TABLE_100();
260: a52 := JTF_NUMBER_TABLE();
261: a53 := JTF_VARCHAR2_TABLE_100();
256: a48 := JTF_NUMBER_TABLE();
257: a49 := JTF_NUMBER_TABLE();
258: a50 := JTF_VARCHAR2_TABLE_100();
259: a51 := JTF_VARCHAR2_TABLE_100();
260: a52 := JTF_NUMBER_TABLE();
261: a53 := JTF_VARCHAR2_TABLE_100();
262: a54 := JTF_VARCHAR2_TABLE_100();
263: a55 := JTF_NUMBER_TABLE();
264: a56 := JTF_VARCHAR2_TABLE_100();
259: a51 := JTF_VARCHAR2_TABLE_100();
260: a52 := JTF_NUMBER_TABLE();
261: a53 := JTF_VARCHAR2_TABLE_100();
262: a54 := JTF_VARCHAR2_TABLE_100();
263: a55 := JTF_NUMBER_TABLE();
264: a56 := JTF_VARCHAR2_TABLE_100();
265: a57 := JTF_NUMBER_TABLE();
266: else
267: a0 := JTF_NUMBER_TABLE();
261: a53 := JTF_VARCHAR2_TABLE_100();
262: a54 := JTF_VARCHAR2_TABLE_100();
263: a55 := JTF_NUMBER_TABLE();
264: a56 := JTF_VARCHAR2_TABLE_100();
265: a57 := JTF_NUMBER_TABLE();
266: else
267: a0 := JTF_NUMBER_TABLE();
268: a1 := JTF_NUMBER_TABLE();
269: a2 := JTF_DATE_TABLE();
263: a55 := JTF_NUMBER_TABLE();
264: a56 := JTF_VARCHAR2_TABLE_100();
265: a57 := JTF_NUMBER_TABLE();
266: else
267: a0 := JTF_NUMBER_TABLE();
268: a1 := JTF_NUMBER_TABLE();
269: a2 := JTF_DATE_TABLE();
270: a3 := JTF_NUMBER_TABLE();
271: a4 := JTF_DATE_TABLE();
264: a56 := JTF_VARCHAR2_TABLE_100();
265: a57 := JTF_NUMBER_TABLE();
266: else
267: a0 := JTF_NUMBER_TABLE();
268: a1 := JTF_NUMBER_TABLE();
269: a2 := JTF_DATE_TABLE();
270: a3 := JTF_NUMBER_TABLE();
271: a4 := JTF_DATE_TABLE();
272: a5 := JTF_NUMBER_TABLE();
266: else
267: a0 := JTF_NUMBER_TABLE();
268: a1 := JTF_NUMBER_TABLE();
269: a2 := JTF_DATE_TABLE();
270: a3 := JTF_NUMBER_TABLE();
271: a4 := JTF_DATE_TABLE();
272: a5 := JTF_NUMBER_TABLE();
273: a6 := JTF_NUMBER_TABLE();
274: a7 := JTF_NUMBER_TABLE();
268: a1 := JTF_NUMBER_TABLE();
269: a2 := JTF_DATE_TABLE();
270: a3 := JTF_NUMBER_TABLE();
271: a4 := JTF_DATE_TABLE();
272: a5 := JTF_NUMBER_TABLE();
273: a6 := JTF_NUMBER_TABLE();
274: a7 := JTF_NUMBER_TABLE();
275: a8 := JTF_NUMBER_TABLE();
276: a9 := JTF_DATE_TABLE();
269: a2 := JTF_DATE_TABLE();
270: a3 := JTF_NUMBER_TABLE();
271: a4 := JTF_DATE_TABLE();
272: a5 := JTF_NUMBER_TABLE();
273: a6 := JTF_NUMBER_TABLE();
274: a7 := JTF_NUMBER_TABLE();
275: a8 := JTF_NUMBER_TABLE();
276: a9 := JTF_DATE_TABLE();
277: a10 := JTF_NUMBER_TABLE();
270: a3 := JTF_NUMBER_TABLE();
271: a4 := JTF_DATE_TABLE();
272: a5 := JTF_NUMBER_TABLE();
273: a6 := JTF_NUMBER_TABLE();
274: a7 := JTF_NUMBER_TABLE();
275: a8 := JTF_NUMBER_TABLE();
276: a9 := JTF_DATE_TABLE();
277: a10 := JTF_NUMBER_TABLE();
278: a11 := JTF_VARCHAR2_TABLE_100();
271: a4 := JTF_DATE_TABLE();
272: a5 := JTF_NUMBER_TABLE();
273: a6 := JTF_NUMBER_TABLE();
274: a7 := JTF_NUMBER_TABLE();
275: a8 := JTF_NUMBER_TABLE();
276: a9 := JTF_DATE_TABLE();
277: a10 := JTF_NUMBER_TABLE();
278: a11 := JTF_VARCHAR2_TABLE_100();
279: a12 := JTF_NUMBER_TABLE();
273: a6 := JTF_NUMBER_TABLE();
274: a7 := JTF_NUMBER_TABLE();
275: a8 := JTF_NUMBER_TABLE();
276: a9 := JTF_DATE_TABLE();
277: a10 := JTF_NUMBER_TABLE();
278: a11 := JTF_VARCHAR2_TABLE_100();
279: a12 := JTF_NUMBER_TABLE();
280: a13 := JTF_NUMBER_TABLE();
281: a14 := JTF_VARCHAR2_TABLE_100();
275: a8 := JTF_NUMBER_TABLE();
276: a9 := JTF_DATE_TABLE();
277: a10 := JTF_NUMBER_TABLE();
278: a11 := JTF_VARCHAR2_TABLE_100();
279: a12 := JTF_NUMBER_TABLE();
280: a13 := JTF_NUMBER_TABLE();
281: a14 := JTF_VARCHAR2_TABLE_100();
282: a15 := JTF_NUMBER_TABLE();
283: a16 := JTF_VARCHAR2_TABLE_100();
276: a9 := JTF_DATE_TABLE();
277: a10 := JTF_NUMBER_TABLE();
278: a11 := JTF_VARCHAR2_TABLE_100();
279: a12 := JTF_NUMBER_TABLE();
280: a13 := JTF_NUMBER_TABLE();
281: a14 := JTF_VARCHAR2_TABLE_100();
282: a15 := JTF_NUMBER_TABLE();
283: a16 := JTF_VARCHAR2_TABLE_100();
284: a17 := JTF_VARCHAR2_TABLE_100();
278: a11 := JTF_VARCHAR2_TABLE_100();
279: a12 := JTF_NUMBER_TABLE();
280: a13 := JTF_NUMBER_TABLE();
281: a14 := JTF_VARCHAR2_TABLE_100();
282: a15 := JTF_NUMBER_TABLE();
283: a16 := JTF_VARCHAR2_TABLE_100();
284: a17 := JTF_VARCHAR2_TABLE_100();
285: a18 := JTF_VARCHAR2_TABLE_100();
286: a19 := JTF_VARCHAR2_TABLE_100();
283: a16 := JTF_VARCHAR2_TABLE_100();
284: a17 := JTF_VARCHAR2_TABLE_100();
285: a18 := JTF_VARCHAR2_TABLE_100();
286: a19 := JTF_VARCHAR2_TABLE_100();
287: a20 := JTF_NUMBER_TABLE();
288: a21 := JTF_VARCHAR2_TABLE_100();
289: a22 := JTF_VARCHAR2_TABLE_100();
290: a23 := JTF_VARCHAR2_TABLE_100();
291: a24 := JTF_NUMBER_TABLE();
287: a20 := JTF_NUMBER_TABLE();
288: a21 := JTF_VARCHAR2_TABLE_100();
289: a22 := JTF_VARCHAR2_TABLE_100();
290: a23 := JTF_VARCHAR2_TABLE_100();
291: a24 := JTF_NUMBER_TABLE();
292: a25 := JTF_NUMBER_TABLE();
293: a26 := JTF_NUMBER_TABLE();
294: a27 := JTF_NUMBER_TABLE();
295: a28 := JTF_VARCHAR2_TABLE_100();
288: a21 := JTF_VARCHAR2_TABLE_100();
289: a22 := JTF_VARCHAR2_TABLE_100();
290: a23 := JTF_VARCHAR2_TABLE_100();
291: a24 := JTF_NUMBER_TABLE();
292: a25 := JTF_NUMBER_TABLE();
293: a26 := JTF_NUMBER_TABLE();
294: a27 := JTF_NUMBER_TABLE();
295: a28 := JTF_VARCHAR2_TABLE_100();
296: a29 := JTF_VARCHAR2_TABLE_100();
289: a22 := JTF_VARCHAR2_TABLE_100();
290: a23 := JTF_VARCHAR2_TABLE_100();
291: a24 := JTF_NUMBER_TABLE();
292: a25 := JTF_NUMBER_TABLE();
293: a26 := JTF_NUMBER_TABLE();
294: a27 := JTF_NUMBER_TABLE();
295: a28 := JTF_VARCHAR2_TABLE_100();
296: a29 := JTF_VARCHAR2_TABLE_100();
297: a30 := JTF_VARCHAR2_TABLE_100();
290: a23 := JTF_VARCHAR2_TABLE_100();
291: a24 := JTF_NUMBER_TABLE();
292: a25 := JTF_NUMBER_TABLE();
293: a26 := JTF_NUMBER_TABLE();
294: a27 := JTF_NUMBER_TABLE();
295: a28 := JTF_VARCHAR2_TABLE_100();
296: a29 := JTF_VARCHAR2_TABLE_100();
297: a30 := JTF_VARCHAR2_TABLE_100();
298: a31 := JTF_VARCHAR2_TABLE_200();
309: a42 := JTF_VARCHAR2_TABLE_200();
310: a43 := JTF_VARCHAR2_TABLE_200();
311: a44 := JTF_VARCHAR2_TABLE_200();
312: a45 := JTF_VARCHAR2_TABLE_200();
313: a46 := JTF_NUMBER_TABLE();
314: a47 := JTF_NUMBER_TABLE();
315: a48 := JTF_NUMBER_TABLE();
316: a49 := JTF_NUMBER_TABLE();
317: a50 := JTF_VARCHAR2_TABLE_100();
310: a43 := JTF_VARCHAR2_TABLE_200();
311: a44 := JTF_VARCHAR2_TABLE_200();
312: a45 := JTF_VARCHAR2_TABLE_200();
313: a46 := JTF_NUMBER_TABLE();
314: a47 := JTF_NUMBER_TABLE();
315: a48 := JTF_NUMBER_TABLE();
316: a49 := JTF_NUMBER_TABLE();
317: a50 := JTF_VARCHAR2_TABLE_100();
318: a51 := JTF_VARCHAR2_TABLE_100();
311: a44 := JTF_VARCHAR2_TABLE_200();
312: a45 := JTF_VARCHAR2_TABLE_200();
313: a46 := JTF_NUMBER_TABLE();
314: a47 := JTF_NUMBER_TABLE();
315: a48 := JTF_NUMBER_TABLE();
316: a49 := JTF_NUMBER_TABLE();
317: a50 := JTF_VARCHAR2_TABLE_100();
318: a51 := JTF_VARCHAR2_TABLE_100();
319: a52 := JTF_NUMBER_TABLE();
312: a45 := JTF_VARCHAR2_TABLE_200();
313: a46 := JTF_NUMBER_TABLE();
314: a47 := JTF_NUMBER_TABLE();
315: a48 := JTF_NUMBER_TABLE();
316: a49 := JTF_NUMBER_TABLE();
317: a50 := JTF_VARCHAR2_TABLE_100();
318: a51 := JTF_VARCHAR2_TABLE_100();
319: a52 := JTF_NUMBER_TABLE();
320: a53 := JTF_VARCHAR2_TABLE_100();
315: a48 := JTF_NUMBER_TABLE();
316: a49 := JTF_NUMBER_TABLE();
317: a50 := JTF_VARCHAR2_TABLE_100();
318: a51 := JTF_VARCHAR2_TABLE_100();
319: a52 := JTF_NUMBER_TABLE();
320: a53 := JTF_VARCHAR2_TABLE_100();
321: a54 := JTF_VARCHAR2_TABLE_100();
322: a55 := JTF_NUMBER_TABLE();
323: a56 := JTF_VARCHAR2_TABLE_100();
318: a51 := JTF_VARCHAR2_TABLE_100();
319: a52 := JTF_NUMBER_TABLE();
320: a53 := JTF_VARCHAR2_TABLE_100();
321: a54 := JTF_VARCHAR2_TABLE_100();
322: a55 := JTF_NUMBER_TABLE();
323: a56 := JTF_VARCHAR2_TABLE_100();
324: a57 := JTF_NUMBER_TABLE();
325: if t.count > 0 then
326: a0.extend(t.count);
320: a53 := JTF_VARCHAR2_TABLE_100();
321: a54 := JTF_VARCHAR2_TABLE_100();
322: a55 := JTF_NUMBER_TABLE();
323: a56 := JTF_VARCHAR2_TABLE_100();
324: a57 := JTF_NUMBER_TABLE();
325: if t.count > 0 then
326: a0.extend(t.count);
327: a1.extend(t.count);
328: a2.extend(t.count);