19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy as_osi_lead_pub.osi_tbl_type, a0 JTF_DATE_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy as_osi_lead_pub.osi_tbl_type, a0 JTF_DATE_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
22: procedure rosetta_table_copy_in_p2(t out nocopy as_osi_lead_pub.osi_tbl_type, a0 JTF_DATE_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_100
47: , a25 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_100
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_100
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_100
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_VARCHAR2_TABLE_100
50: , a28 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_100
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_VARCHAR2_TABLE_100
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_100
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_VARCHAR2_TABLE_100
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_100
52: , a30 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_100
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_VARCHAR2_TABLE_100
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_100
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_100
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_VARCHAR2_TABLE_100
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_100
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_100
54: , a32 JTF_VARCHAR2_TABLE_100
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_VARCHAR2_TABLE_100
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_100
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_100
54: , a32 JTF_VARCHAR2_TABLE_100
55: , a33 JTF_VARCHAR2_TABLE_2000
48: , a26 JTF_VARCHAR2_TABLE_100
49: , a27 JTF_VARCHAR2_TABLE_100
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_100
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_100
54: , a32 JTF_VARCHAR2_TABLE_100
55: , a33 JTF_VARCHAR2_TABLE_2000
56: , a34 JTF_VARCHAR2_TABLE_2000
49: , a27 JTF_VARCHAR2_TABLE_100
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_100
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_100
54: , a32 JTF_VARCHAR2_TABLE_100
55: , a33 JTF_VARCHAR2_TABLE_2000
56: , a34 JTF_VARCHAR2_TABLE_2000
57: , a35 JTF_VARCHAR2_TABLE_2000
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_100
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_100
54: , a32 JTF_VARCHAR2_TABLE_100
55: , a33 JTF_VARCHAR2_TABLE_2000
56: , a34 JTF_VARCHAR2_TABLE_2000
57: , a35 JTF_VARCHAR2_TABLE_2000
58: , a36 JTF_VARCHAR2_TABLE_2000
55: , a33 JTF_VARCHAR2_TABLE_2000
56: , a34 JTF_VARCHAR2_TABLE_2000
57: , a35 JTF_VARCHAR2_TABLE_2000
58: , a36 JTF_VARCHAR2_TABLE_2000
59: , a37 JTF_VARCHAR2_TABLE_100
60: , a38 JTF_VARCHAR2_TABLE_100
61: , a39 JTF_VARCHAR2_TABLE_100
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_VARCHAR2_TABLE_100
56: , a34 JTF_VARCHAR2_TABLE_2000
57: , a35 JTF_VARCHAR2_TABLE_2000
58: , a36 JTF_VARCHAR2_TABLE_2000
59: , a37 JTF_VARCHAR2_TABLE_100
60: , a38 JTF_VARCHAR2_TABLE_100
61: , a39 JTF_VARCHAR2_TABLE_100
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_VARCHAR2_TABLE_100
64: ) as
57: , a35 JTF_VARCHAR2_TABLE_2000
58: , a36 JTF_VARCHAR2_TABLE_2000
59: , a37 JTF_VARCHAR2_TABLE_100
60: , a38 JTF_VARCHAR2_TABLE_100
61: , a39 JTF_VARCHAR2_TABLE_100
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_VARCHAR2_TABLE_100
64: ) as
65: ddindx binary_integer; indx binary_integer;
58: , a36 JTF_VARCHAR2_TABLE_2000
59: , a37 JTF_VARCHAR2_TABLE_100
60: , a38 JTF_VARCHAR2_TABLE_100
61: , a39 JTF_VARCHAR2_TABLE_100
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_VARCHAR2_TABLE_100
64: ) as
65: ddindx binary_integer; indx binary_integer;
66: begin
59: , a37 JTF_VARCHAR2_TABLE_100
60: , a38 JTF_VARCHAR2_TABLE_100
61: , a39 JTF_VARCHAR2_TABLE_100
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_VARCHAR2_TABLE_100
64: ) as
65: ddindx binary_integer; indx binary_integer;
66: begin
67: if a0 is not null and a0.count > 0 then
120: end if;
121: end if;
122: end rosetta_table_copy_in_p2;
123: procedure rosetta_table_copy_out_p2(t as_osi_lead_pub.osi_tbl_type, a0 out nocopy JTF_DATE_TABLE
124: , a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , a2 out nocopy JTF_DATE_TABLE
126: , a3 out nocopy JTF_VARCHAR2_TABLE_100
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE
122: end rosetta_table_copy_in_p2;
123: procedure rosetta_table_copy_out_p2(t as_osi_lead_pub.osi_tbl_type, a0 out nocopy JTF_DATE_TABLE
124: , a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , a2 out nocopy JTF_DATE_TABLE
126: , a3 out nocopy JTF_VARCHAR2_TABLE_100
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE
129: , a6 out nocopy JTF_NUMBER_TABLE
130: , a7 out nocopy JTF_VARCHAR2_TABLE_100
123: procedure rosetta_table_copy_out_p2(t as_osi_lead_pub.osi_tbl_type, a0 out nocopy JTF_DATE_TABLE
124: , a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , a2 out nocopy JTF_DATE_TABLE
126: , a3 out nocopy JTF_VARCHAR2_TABLE_100
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE
129: , a6 out nocopy JTF_NUMBER_TABLE
130: , a7 out nocopy JTF_VARCHAR2_TABLE_100
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
126: , a3 out nocopy JTF_VARCHAR2_TABLE_100
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE
129: , a6 out nocopy JTF_NUMBER_TABLE
130: , a7 out nocopy JTF_VARCHAR2_TABLE_100
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_VARCHAR2_TABLE_100
133: , a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE
129: , a6 out nocopy JTF_NUMBER_TABLE
130: , a7 out nocopy JTF_VARCHAR2_TABLE_100
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_VARCHAR2_TABLE_100
133: , a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE
129: , a6 out nocopy JTF_NUMBER_TABLE
130: , a7 out nocopy JTF_VARCHAR2_TABLE_100
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_VARCHAR2_TABLE_100
133: , a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_VARCHAR2_TABLE_100
136: , a13 out nocopy JTF_VARCHAR2_TABLE_100
129: , a6 out nocopy JTF_NUMBER_TABLE
130: , a7 out nocopy JTF_VARCHAR2_TABLE_100
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_VARCHAR2_TABLE_100
133: , a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_VARCHAR2_TABLE_100
136: , a13 out nocopy JTF_VARCHAR2_TABLE_100
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
130: , a7 out nocopy JTF_VARCHAR2_TABLE_100
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_VARCHAR2_TABLE_100
133: , a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_VARCHAR2_TABLE_100
136: , a13 out nocopy JTF_VARCHAR2_TABLE_100
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_VARCHAR2_TABLE_100
133: , a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_VARCHAR2_TABLE_100
136: , a13 out nocopy JTF_VARCHAR2_TABLE_100
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: , a16 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_VARCHAR2_TABLE_100
133: , a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_VARCHAR2_TABLE_100
136: , a13 out nocopy JTF_VARCHAR2_TABLE_100
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: , a16 out nocopy JTF_VARCHAR2_TABLE_100
140: , a17 out nocopy JTF_VARCHAR2_TABLE_100
133: , a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_VARCHAR2_TABLE_100
136: , a13 out nocopy JTF_VARCHAR2_TABLE_100
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: , a16 out nocopy JTF_VARCHAR2_TABLE_100
140: , a17 out nocopy JTF_VARCHAR2_TABLE_100
141: , a18 out nocopy JTF_VARCHAR2_TABLE_100
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_VARCHAR2_TABLE_100
136: , a13 out nocopy JTF_VARCHAR2_TABLE_100
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: , a16 out nocopy JTF_VARCHAR2_TABLE_100
140: , a17 out nocopy JTF_VARCHAR2_TABLE_100
141: , a18 out nocopy JTF_VARCHAR2_TABLE_100
142: , a19 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_VARCHAR2_TABLE_100
136: , a13 out nocopy JTF_VARCHAR2_TABLE_100
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: , a16 out nocopy JTF_VARCHAR2_TABLE_100
140: , a17 out nocopy JTF_VARCHAR2_TABLE_100
141: , a18 out nocopy JTF_VARCHAR2_TABLE_100
142: , a19 out nocopy JTF_VARCHAR2_TABLE_100
143: , a20 out nocopy JTF_VARCHAR2_TABLE_100
136: , a13 out nocopy JTF_VARCHAR2_TABLE_100
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: , a16 out nocopy JTF_VARCHAR2_TABLE_100
140: , a17 out nocopy JTF_VARCHAR2_TABLE_100
141: , a18 out nocopy JTF_VARCHAR2_TABLE_100
142: , a19 out nocopy JTF_VARCHAR2_TABLE_100
143: , a20 out nocopy JTF_VARCHAR2_TABLE_100
144: , a21 out nocopy JTF_VARCHAR2_TABLE_100
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: , a16 out nocopy JTF_VARCHAR2_TABLE_100
140: , a17 out nocopy JTF_VARCHAR2_TABLE_100
141: , a18 out nocopy JTF_VARCHAR2_TABLE_100
142: , a19 out nocopy JTF_VARCHAR2_TABLE_100
143: , a20 out nocopy JTF_VARCHAR2_TABLE_100
144: , a21 out nocopy JTF_VARCHAR2_TABLE_100
145: , a22 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: , a16 out nocopy JTF_VARCHAR2_TABLE_100
140: , a17 out nocopy JTF_VARCHAR2_TABLE_100
141: , a18 out nocopy JTF_VARCHAR2_TABLE_100
142: , a19 out nocopy JTF_VARCHAR2_TABLE_100
143: , a20 out nocopy JTF_VARCHAR2_TABLE_100
144: , a21 out nocopy JTF_VARCHAR2_TABLE_100
145: , a22 out nocopy JTF_VARCHAR2_TABLE_100
146: , a23 out nocopy JTF_VARCHAR2_TABLE_100
139: , a16 out nocopy JTF_VARCHAR2_TABLE_100
140: , a17 out nocopy JTF_VARCHAR2_TABLE_100
141: , a18 out nocopy JTF_VARCHAR2_TABLE_100
142: , a19 out nocopy JTF_VARCHAR2_TABLE_100
143: , a20 out nocopy JTF_VARCHAR2_TABLE_100
144: , a21 out nocopy JTF_VARCHAR2_TABLE_100
145: , a22 out nocopy JTF_VARCHAR2_TABLE_100
146: , a23 out nocopy JTF_VARCHAR2_TABLE_100
147: , a24 out nocopy JTF_VARCHAR2_TABLE_100
140: , a17 out nocopy JTF_VARCHAR2_TABLE_100
141: , a18 out nocopy JTF_VARCHAR2_TABLE_100
142: , a19 out nocopy JTF_VARCHAR2_TABLE_100
143: , a20 out nocopy JTF_VARCHAR2_TABLE_100
144: , a21 out nocopy JTF_VARCHAR2_TABLE_100
145: , a22 out nocopy JTF_VARCHAR2_TABLE_100
146: , a23 out nocopy JTF_VARCHAR2_TABLE_100
147: , a24 out nocopy JTF_VARCHAR2_TABLE_100
148: , a25 out nocopy JTF_VARCHAR2_TABLE_100
141: , a18 out nocopy JTF_VARCHAR2_TABLE_100
142: , a19 out nocopy JTF_VARCHAR2_TABLE_100
143: , a20 out nocopy JTF_VARCHAR2_TABLE_100
144: , a21 out nocopy JTF_VARCHAR2_TABLE_100
145: , a22 out nocopy JTF_VARCHAR2_TABLE_100
146: , a23 out nocopy JTF_VARCHAR2_TABLE_100
147: , a24 out nocopy JTF_VARCHAR2_TABLE_100
148: , a25 out nocopy JTF_VARCHAR2_TABLE_100
149: , a26 out nocopy JTF_VARCHAR2_TABLE_100
142: , a19 out nocopy JTF_VARCHAR2_TABLE_100
143: , a20 out nocopy JTF_VARCHAR2_TABLE_100
144: , a21 out nocopy JTF_VARCHAR2_TABLE_100
145: , a22 out nocopy JTF_VARCHAR2_TABLE_100
146: , a23 out nocopy JTF_VARCHAR2_TABLE_100
147: , a24 out nocopy JTF_VARCHAR2_TABLE_100
148: , a25 out nocopy JTF_VARCHAR2_TABLE_100
149: , a26 out nocopy JTF_VARCHAR2_TABLE_100
150: , a27 out nocopy JTF_VARCHAR2_TABLE_100
143: , a20 out nocopy JTF_VARCHAR2_TABLE_100
144: , a21 out nocopy JTF_VARCHAR2_TABLE_100
145: , a22 out nocopy JTF_VARCHAR2_TABLE_100
146: , a23 out nocopy JTF_VARCHAR2_TABLE_100
147: , a24 out nocopy JTF_VARCHAR2_TABLE_100
148: , a25 out nocopy JTF_VARCHAR2_TABLE_100
149: , a26 out nocopy JTF_VARCHAR2_TABLE_100
150: , a27 out nocopy JTF_VARCHAR2_TABLE_100
151: , a28 out nocopy JTF_VARCHAR2_TABLE_100
144: , a21 out nocopy JTF_VARCHAR2_TABLE_100
145: , a22 out nocopy JTF_VARCHAR2_TABLE_100
146: , a23 out nocopy JTF_VARCHAR2_TABLE_100
147: , a24 out nocopy JTF_VARCHAR2_TABLE_100
148: , a25 out nocopy JTF_VARCHAR2_TABLE_100
149: , a26 out nocopy JTF_VARCHAR2_TABLE_100
150: , a27 out nocopy JTF_VARCHAR2_TABLE_100
151: , a28 out nocopy JTF_VARCHAR2_TABLE_100
152: , a29 out nocopy JTF_VARCHAR2_TABLE_100
145: , a22 out nocopy JTF_VARCHAR2_TABLE_100
146: , a23 out nocopy JTF_VARCHAR2_TABLE_100
147: , a24 out nocopy JTF_VARCHAR2_TABLE_100
148: , a25 out nocopy JTF_VARCHAR2_TABLE_100
149: , a26 out nocopy JTF_VARCHAR2_TABLE_100
150: , a27 out nocopy JTF_VARCHAR2_TABLE_100
151: , a28 out nocopy JTF_VARCHAR2_TABLE_100
152: , a29 out nocopy JTF_VARCHAR2_TABLE_100
153: , a30 out nocopy JTF_VARCHAR2_TABLE_100
146: , a23 out nocopy JTF_VARCHAR2_TABLE_100
147: , a24 out nocopy JTF_VARCHAR2_TABLE_100
148: , a25 out nocopy JTF_VARCHAR2_TABLE_100
149: , a26 out nocopy JTF_VARCHAR2_TABLE_100
150: , a27 out nocopy JTF_VARCHAR2_TABLE_100
151: , a28 out nocopy JTF_VARCHAR2_TABLE_100
152: , a29 out nocopy JTF_VARCHAR2_TABLE_100
153: , a30 out nocopy JTF_VARCHAR2_TABLE_100
154: , a31 out nocopy JTF_VARCHAR2_TABLE_100
147: , a24 out nocopy JTF_VARCHAR2_TABLE_100
148: , a25 out nocopy JTF_VARCHAR2_TABLE_100
149: , a26 out nocopy JTF_VARCHAR2_TABLE_100
150: , a27 out nocopy JTF_VARCHAR2_TABLE_100
151: , a28 out nocopy JTF_VARCHAR2_TABLE_100
152: , a29 out nocopy JTF_VARCHAR2_TABLE_100
153: , a30 out nocopy JTF_VARCHAR2_TABLE_100
154: , a31 out nocopy JTF_VARCHAR2_TABLE_100
155: , a32 out nocopy JTF_VARCHAR2_TABLE_100
148: , a25 out nocopy JTF_VARCHAR2_TABLE_100
149: , a26 out nocopy JTF_VARCHAR2_TABLE_100
150: , a27 out nocopy JTF_VARCHAR2_TABLE_100
151: , a28 out nocopy JTF_VARCHAR2_TABLE_100
152: , a29 out nocopy JTF_VARCHAR2_TABLE_100
153: , a30 out nocopy JTF_VARCHAR2_TABLE_100
154: , a31 out nocopy JTF_VARCHAR2_TABLE_100
155: , a32 out nocopy JTF_VARCHAR2_TABLE_100
156: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
149: , a26 out nocopy JTF_VARCHAR2_TABLE_100
150: , a27 out nocopy JTF_VARCHAR2_TABLE_100
151: , a28 out nocopy JTF_VARCHAR2_TABLE_100
152: , a29 out nocopy JTF_VARCHAR2_TABLE_100
153: , a30 out nocopy JTF_VARCHAR2_TABLE_100
154: , a31 out nocopy JTF_VARCHAR2_TABLE_100
155: , a32 out nocopy JTF_VARCHAR2_TABLE_100
156: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a34 out nocopy JTF_VARCHAR2_TABLE_2000
150: , a27 out nocopy JTF_VARCHAR2_TABLE_100
151: , a28 out nocopy JTF_VARCHAR2_TABLE_100
152: , a29 out nocopy JTF_VARCHAR2_TABLE_100
153: , a30 out nocopy JTF_VARCHAR2_TABLE_100
154: , a31 out nocopy JTF_VARCHAR2_TABLE_100
155: , a32 out nocopy JTF_VARCHAR2_TABLE_100
156: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a34 out nocopy JTF_VARCHAR2_TABLE_2000
158: , a35 out nocopy JTF_VARCHAR2_TABLE_2000
151: , a28 out nocopy JTF_VARCHAR2_TABLE_100
152: , a29 out nocopy JTF_VARCHAR2_TABLE_100
153: , a30 out nocopy JTF_VARCHAR2_TABLE_100
154: , a31 out nocopy JTF_VARCHAR2_TABLE_100
155: , a32 out nocopy JTF_VARCHAR2_TABLE_100
156: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a34 out nocopy JTF_VARCHAR2_TABLE_2000
158: , a35 out nocopy JTF_VARCHAR2_TABLE_2000
159: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a34 out nocopy JTF_VARCHAR2_TABLE_2000
158: , a35 out nocopy JTF_VARCHAR2_TABLE_2000
159: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
160: , a37 out nocopy JTF_VARCHAR2_TABLE_100
161: , a38 out nocopy JTF_VARCHAR2_TABLE_100
162: , a39 out nocopy JTF_VARCHAR2_TABLE_100
163: , a40 out nocopy JTF_VARCHAR2_TABLE_100
164: , a41 out nocopy JTF_VARCHAR2_TABLE_100
157: , a34 out nocopy JTF_VARCHAR2_TABLE_2000
158: , a35 out nocopy JTF_VARCHAR2_TABLE_2000
159: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
160: , a37 out nocopy JTF_VARCHAR2_TABLE_100
161: , a38 out nocopy JTF_VARCHAR2_TABLE_100
162: , a39 out nocopy JTF_VARCHAR2_TABLE_100
163: , a40 out nocopy JTF_VARCHAR2_TABLE_100
164: , a41 out nocopy JTF_VARCHAR2_TABLE_100
165: ) as
158: , a35 out nocopy JTF_VARCHAR2_TABLE_2000
159: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
160: , a37 out nocopy JTF_VARCHAR2_TABLE_100
161: , a38 out nocopy JTF_VARCHAR2_TABLE_100
162: , a39 out nocopy JTF_VARCHAR2_TABLE_100
163: , a40 out nocopy JTF_VARCHAR2_TABLE_100
164: , a41 out nocopy JTF_VARCHAR2_TABLE_100
165: ) as
166: ddindx binary_integer; indx binary_integer;
159: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
160: , a37 out nocopy JTF_VARCHAR2_TABLE_100
161: , a38 out nocopy JTF_VARCHAR2_TABLE_100
162: , a39 out nocopy JTF_VARCHAR2_TABLE_100
163: , a40 out nocopy JTF_VARCHAR2_TABLE_100
164: , a41 out nocopy JTF_VARCHAR2_TABLE_100
165: ) as
166: ddindx binary_integer; indx binary_integer;
167: begin
160: , a37 out nocopy JTF_VARCHAR2_TABLE_100
161: , a38 out nocopy JTF_VARCHAR2_TABLE_100
162: , a39 out nocopy JTF_VARCHAR2_TABLE_100
163: , a40 out nocopy JTF_VARCHAR2_TABLE_100
164: , a41 out nocopy JTF_VARCHAR2_TABLE_100
165: ) as
166: ddindx binary_integer; indx binary_integer;
167: begin
168: if t is null or t.count = 0 then
166: ddindx binary_integer; indx binary_integer;
167: begin
168: if t is null or t.count = 0 then
169: a0 := JTF_DATE_TABLE();
170: a1 := JTF_VARCHAR2_TABLE_100();
171: a2 := JTF_DATE_TABLE();
172: a3 := JTF_VARCHAR2_TABLE_100();
173: a4 := JTF_VARCHAR2_TABLE_100();
174: a5 := JTF_NUMBER_TABLE();
168: if t is null or t.count = 0 then
169: a0 := JTF_DATE_TABLE();
170: a1 := JTF_VARCHAR2_TABLE_100();
171: a2 := JTF_DATE_TABLE();
172: a3 := JTF_VARCHAR2_TABLE_100();
173: a4 := JTF_VARCHAR2_TABLE_100();
174: a5 := JTF_NUMBER_TABLE();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_VARCHAR2_TABLE_100();
169: a0 := JTF_DATE_TABLE();
170: a1 := JTF_VARCHAR2_TABLE_100();
171: a2 := JTF_DATE_TABLE();
172: a3 := JTF_VARCHAR2_TABLE_100();
173: a4 := JTF_VARCHAR2_TABLE_100();
174: a5 := JTF_NUMBER_TABLE();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_VARCHAR2_TABLE_100();
177: a8 := JTF_VARCHAR2_TABLE_100();
172: a3 := JTF_VARCHAR2_TABLE_100();
173: a4 := JTF_VARCHAR2_TABLE_100();
174: a5 := JTF_NUMBER_TABLE();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_VARCHAR2_TABLE_100();
177: a8 := JTF_VARCHAR2_TABLE_100();
178: a9 := JTF_VARCHAR2_TABLE_100();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_VARCHAR2_TABLE_100();
173: a4 := JTF_VARCHAR2_TABLE_100();
174: a5 := JTF_NUMBER_TABLE();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_VARCHAR2_TABLE_100();
177: a8 := JTF_VARCHAR2_TABLE_100();
178: a9 := JTF_VARCHAR2_TABLE_100();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_VARCHAR2_TABLE_100();
181: a12 := JTF_VARCHAR2_TABLE_100();
174: a5 := JTF_NUMBER_TABLE();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_VARCHAR2_TABLE_100();
177: a8 := JTF_VARCHAR2_TABLE_100();
178: a9 := JTF_VARCHAR2_TABLE_100();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_VARCHAR2_TABLE_100();
181: a12 := JTF_VARCHAR2_TABLE_100();
182: a13 := JTF_VARCHAR2_TABLE_100();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_VARCHAR2_TABLE_100();
177: a8 := JTF_VARCHAR2_TABLE_100();
178: a9 := JTF_VARCHAR2_TABLE_100();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_VARCHAR2_TABLE_100();
181: a12 := JTF_VARCHAR2_TABLE_100();
182: a13 := JTF_VARCHAR2_TABLE_100();
183: a14 := JTF_VARCHAR2_TABLE_100();
176: a7 := JTF_VARCHAR2_TABLE_100();
177: a8 := JTF_VARCHAR2_TABLE_100();
178: a9 := JTF_VARCHAR2_TABLE_100();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_VARCHAR2_TABLE_100();
181: a12 := JTF_VARCHAR2_TABLE_100();
182: a13 := JTF_VARCHAR2_TABLE_100();
183: a14 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_100();
177: a8 := JTF_VARCHAR2_TABLE_100();
178: a9 := JTF_VARCHAR2_TABLE_100();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_VARCHAR2_TABLE_100();
181: a12 := JTF_VARCHAR2_TABLE_100();
182: a13 := JTF_VARCHAR2_TABLE_100();
183: a14 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_100();
185: a16 := JTF_VARCHAR2_TABLE_100();
178: a9 := JTF_VARCHAR2_TABLE_100();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_VARCHAR2_TABLE_100();
181: a12 := JTF_VARCHAR2_TABLE_100();
182: a13 := JTF_VARCHAR2_TABLE_100();
183: a14 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_100();
185: a16 := JTF_VARCHAR2_TABLE_100();
186: a17 := JTF_VARCHAR2_TABLE_100();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_VARCHAR2_TABLE_100();
181: a12 := JTF_VARCHAR2_TABLE_100();
182: a13 := JTF_VARCHAR2_TABLE_100();
183: a14 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_100();
185: a16 := JTF_VARCHAR2_TABLE_100();
186: a17 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_VARCHAR2_TABLE_100();
181: a12 := JTF_VARCHAR2_TABLE_100();
182: a13 := JTF_VARCHAR2_TABLE_100();
183: a14 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_100();
185: a16 := JTF_VARCHAR2_TABLE_100();
186: a17 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
188: a19 := JTF_VARCHAR2_TABLE_100();
181: a12 := JTF_VARCHAR2_TABLE_100();
182: a13 := JTF_VARCHAR2_TABLE_100();
183: a14 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_100();
185: a16 := JTF_VARCHAR2_TABLE_100();
186: a17 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
188: a19 := JTF_VARCHAR2_TABLE_100();
189: a20 := JTF_VARCHAR2_TABLE_100();
182: a13 := JTF_VARCHAR2_TABLE_100();
183: a14 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_100();
185: a16 := JTF_VARCHAR2_TABLE_100();
186: a17 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
188: a19 := JTF_VARCHAR2_TABLE_100();
189: a20 := JTF_VARCHAR2_TABLE_100();
190: a21 := JTF_VARCHAR2_TABLE_100();
183: a14 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_100();
185: a16 := JTF_VARCHAR2_TABLE_100();
186: a17 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
188: a19 := JTF_VARCHAR2_TABLE_100();
189: a20 := JTF_VARCHAR2_TABLE_100();
190: a21 := JTF_VARCHAR2_TABLE_100();
191: a22 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_VARCHAR2_TABLE_100();
185: a16 := JTF_VARCHAR2_TABLE_100();
186: a17 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
188: a19 := JTF_VARCHAR2_TABLE_100();
189: a20 := JTF_VARCHAR2_TABLE_100();
190: a21 := JTF_VARCHAR2_TABLE_100();
191: a22 := JTF_VARCHAR2_TABLE_100();
192: a23 := JTF_VARCHAR2_TABLE_100();
185: a16 := JTF_VARCHAR2_TABLE_100();
186: a17 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
188: a19 := JTF_VARCHAR2_TABLE_100();
189: a20 := JTF_VARCHAR2_TABLE_100();
190: a21 := JTF_VARCHAR2_TABLE_100();
191: a22 := JTF_VARCHAR2_TABLE_100();
192: a23 := JTF_VARCHAR2_TABLE_100();
193: a24 := JTF_VARCHAR2_TABLE_100();
186: a17 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
188: a19 := JTF_VARCHAR2_TABLE_100();
189: a20 := JTF_VARCHAR2_TABLE_100();
190: a21 := JTF_VARCHAR2_TABLE_100();
191: a22 := JTF_VARCHAR2_TABLE_100();
192: a23 := JTF_VARCHAR2_TABLE_100();
193: a24 := JTF_VARCHAR2_TABLE_100();
194: a25 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
188: a19 := JTF_VARCHAR2_TABLE_100();
189: a20 := JTF_VARCHAR2_TABLE_100();
190: a21 := JTF_VARCHAR2_TABLE_100();
191: a22 := JTF_VARCHAR2_TABLE_100();
192: a23 := JTF_VARCHAR2_TABLE_100();
193: a24 := JTF_VARCHAR2_TABLE_100();
194: a25 := JTF_VARCHAR2_TABLE_100();
195: a26 := JTF_VARCHAR2_TABLE_100();
188: a19 := JTF_VARCHAR2_TABLE_100();
189: a20 := JTF_VARCHAR2_TABLE_100();
190: a21 := JTF_VARCHAR2_TABLE_100();
191: a22 := JTF_VARCHAR2_TABLE_100();
192: a23 := JTF_VARCHAR2_TABLE_100();
193: a24 := JTF_VARCHAR2_TABLE_100();
194: a25 := JTF_VARCHAR2_TABLE_100();
195: a26 := JTF_VARCHAR2_TABLE_100();
196: a27 := JTF_VARCHAR2_TABLE_100();
189: a20 := JTF_VARCHAR2_TABLE_100();
190: a21 := JTF_VARCHAR2_TABLE_100();
191: a22 := JTF_VARCHAR2_TABLE_100();
192: a23 := JTF_VARCHAR2_TABLE_100();
193: a24 := JTF_VARCHAR2_TABLE_100();
194: a25 := JTF_VARCHAR2_TABLE_100();
195: a26 := JTF_VARCHAR2_TABLE_100();
196: a27 := JTF_VARCHAR2_TABLE_100();
197: a28 := JTF_VARCHAR2_TABLE_100();
190: a21 := JTF_VARCHAR2_TABLE_100();
191: a22 := JTF_VARCHAR2_TABLE_100();
192: a23 := JTF_VARCHAR2_TABLE_100();
193: a24 := JTF_VARCHAR2_TABLE_100();
194: a25 := JTF_VARCHAR2_TABLE_100();
195: a26 := JTF_VARCHAR2_TABLE_100();
196: a27 := JTF_VARCHAR2_TABLE_100();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
191: a22 := JTF_VARCHAR2_TABLE_100();
192: a23 := JTF_VARCHAR2_TABLE_100();
193: a24 := JTF_VARCHAR2_TABLE_100();
194: a25 := JTF_VARCHAR2_TABLE_100();
195: a26 := JTF_VARCHAR2_TABLE_100();
196: a27 := JTF_VARCHAR2_TABLE_100();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
192: a23 := JTF_VARCHAR2_TABLE_100();
193: a24 := JTF_VARCHAR2_TABLE_100();
194: a25 := JTF_VARCHAR2_TABLE_100();
195: a26 := JTF_VARCHAR2_TABLE_100();
196: a27 := JTF_VARCHAR2_TABLE_100();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_VARCHAR2_TABLE_100();
193: a24 := JTF_VARCHAR2_TABLE_100();
194: a25 := JTF_VARCHAR2_TABLE_100();
195: a26 := JTF_VARCHAR2_TABLE_100();
196: a27 := JTF_VARCHAR2_TABLE_100();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_VARCHAR2_TABLE_100();
201: a32 := JTF_VARCHAR2_TABLE_100();
194: a25 := JTF_VARCHAR2_TABLE_100();
195: a26 := JTF_VARCHAR2_TABLE_100();
196: a27 := JTF_VARCHAR2_TABLE_100();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_VARCHAR2_TABLE_100();
201: a32 := JTF_VARCHAR2_TABLE_100();
202: a33 := JTF_VARCHAR2_TABLE_2000();
195: a26 := JTF_VARCHAR2_TABLE_100();
196: a27 := JTF_VARCHAR2_TABLE_100();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_VARCHAR2_TABLE_100();
201: a32 := JTF_VARCHAR2_TABLE_100();
202: a33 := JTF_VARCHAR2_TABLE_2000();
203: a34 := JTF_VARCHAR2_TABLE_2000();
196: a27 := JTF_VARCHAR2_TABLE_100();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_VARCHAR2_TABLE_100();
201: a32 := JTF_VARCHAR2_TABLE_100();
202: a33 := JTF_VARCHAR2_TABLE_2000();
203: a34 := JTF_VARCHAR2_TABLE_2000();
204: a35 := JTF_VARCHAR2_TABLE_2000();
197: a28 := JTF_VARCHAR2_TABLE_100();
198: a29 := JTF_VARCHAR2_TABLE_100();
199: a30 := JTF_VARCHAR2_TABLE_100();
200: a31 := JTF_VARCHAR2_TABLE_100();
201: a32 := JTF_VARCHAR2_TABLE_100();
202: a33 := JTF_VARCHAR2_TABLE_2000();
203: a34 := JTF_VARCHAR2_TABLE_2000();
204: a35 := JTF_VARCHAR2_TABLE_2000();
205: a36 := JTF_VARCHAR2_TABLE_2000();
202: a33 := JTF_VARCHAR2_TABLE_2000();
203: a34 := JTF_VARCHAR2_TABLE_2000();
204: a35 := JTF_VARCHAR2_TABLE_2000();
205: a36 := JTF_VARCHAR2_TABLE_2000();
206: a37 := JTF_VARCHAR2_TABLE_100();
207: a38 := JTF_VARCHAR2_TABLE_100();
208: a39 := JTF_VARCHAR2_TABLE_100();
209: a40 := JTF_VARCHAR2_TABLE_100();
210: a41 := JTF_VARCHAR2_TABLE_100();
203: a34 := JTF_VARCHAR2_TABLE_2000();
204: a35 := JTF_VARCHAR2_TABLE_2000();
205: a36 := JTF_VARCHAR2_TABLE_2000();
206: a37 := JTF_VARCHAR2_TABLE_100();
207: a38 := JTF_VARCHAR2_TABLE_100();
208: a39 := JTF_VARCHAR2_TABLE_100();
209: a40 := JTF_VARCHAR2_TABLE_100();
210: a41 := JTF_VARCHAR2_TABLE_100();
211: else
204: a35 := JTF_VARCHAR2_TABLE_2000();
205: a36 := JTF_VARCHAR2_TABLE_2000();
206: a37 := JTF_VARCHAR2_TABLE_100();
207: a38 := JTF_VARCHAR2_TABLE_100();
208: a39 := JTF_VARCHAR2_TABLE_100();
209: a40 := JTF_VARCHAR2_TABLE_100();
210: a41 := JTF_VARCHAR2_TABLE_100();
211: else
212: a0 := JTF_DATE_TABLE();
205: a36 := JTF_VARCHAR2_TABLE_2000();
206: a37 := JTF_VARCHAR2_TABLE_100();
207: a38 := JTF_VARCHAR2_TABLE_100();
208: a39 := JTF_VARCHAR2_TABLE_100();
209: a40 := JTF_VARCHAR2_TABLE_100();
210: a41 := JTF_VARCHAR2_TABLE_100();
211: else
212: a0 := JTF_DATE_TABLE();
213: a1 := JTF_VARCHAR2_TABLE_100();
206: a37 := JTF_VARCHAR2_TABLE_100();
207: a38 := JTF_VARCHAR2_TABLE_100();
208: a39 := JTF_VARCHAR2_TABLE_100();
209: a40 := JTF_VARCHAR2_TABLE_100();
210: a41 := JTF_VARCHAR2_TABLE_100();
211: else
212: a0 := JTF_DATE_TABLE();
213: a1 := JTF_VARCHAR2_TABLE_100();
214: a2 := JTF_DATE_TABLE();
209: a40 := JTF_VARCHAR2_TABLE_100();
210: a41 := JTF_VARCHAR2_TABLE_100();
211: else
212: a0 := JTF_DATE_TABLE();
213: a1 := JTF_VARCHAR2_TABLE_100();
214: a2 := JTF_DATE_TABLE();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_NUMBER_TABLE();
211: else
212: a0 := JTF_DATE_TABLE();
213: a1 := JTF_VARCHAR2_TABLE_100();
214: a2 := JTF_DATE_TABLE();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_NUMBER_TABLE();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_VARCHAR2_TABLE_100();
212: a0 := JTF_DATE_TABLE();
213: a1 := JTF_VARCHAR2_TABLE_100();
214: a2 := JTF_DATE_TABLE();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_NUMBER_TABLE();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_VARCHAR2_TABLE_100();
220: a8 := JTF_VARCHAR2_TABLE_100();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_NUMBER_TABLE();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_VARCHAR2_TABLE_100();
220: a8 := JTF_VARCHAR2_TABLE_100();
221: a9 := JTF_VARCHAR2_TABLE_100();
222: a10 := JTF_VARCHAR2_TABLE_100();
223: a11 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_NUMBER_TABLE();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_VARCHAR2_TABLE_100();
220: a8 := JTF_VARCHAR2_TABLE_100();
221: a9 := JTF_VARCHAR2_TABLE_100();
222: a10 := JTF_VARCHAR2_TABLE_100();
223: a11 := JTF_VARCHAR2_TABLE_100();
224: a12 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_NUMBER_TABLE();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_VARCHAR2_TABLE_100();
220: a8 := JTF_VARCHAR2_TABLE_100();
221: a9 := JTF_VARCHAR2_TABLE_100();
222: a10 := JTF_VARCHAR2_TABLE_100();
223: a11 := JTF_VARCHAR2_TABLE_100();
224: a12 := JTF_VARCHAR2_TABLE_100();
225: a13 := JTF_VARCHAR2_TABLE_100();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_VARCHAR2_TABLE_100();
220: a8 := JTF_VARCHAR2_TABLE_100();
221: a9 := JTF_VARCHAR2_TABLE_100();
222: a10 := JTF_VARCHAR2_TABLE_100();
223: a11 := JTF_VARCHAR2_TABLE_100();
224: a12 := JTF_VARCHAR2_TABLE_100();
225: a13 := JTF_VARCHAR2_TABLE_100();
226: a14 := JTF_VARCHAR2_TABLE_100();
219: a7 := JTF_VARCHAR2_TABLE_100();
220: a8 := JTF_VARCHAR2_TABLE_100();
221: a9 := JTF_VARCHAR2_TABLE_100();
222: a10 := JTF_VARCHAR2_TABLE_100();
223: a11 := JTF_VARCHAR2_TABLE_100();
224: a12 := JTF_VARCHAR2_TABLE_100();
225: a13 := JTF_VARCHAR2_TABLE_100();
226: a14 := JTF_VARCHAR2_TABLE_100();
227: a15 := JTF_VARCHAR2_TABLE_100();
220: a8 := JTF_VARCHAR2_TABLE_100();
221: a9 := JTF_VARCHAR2_TABLE_100();
222: a10 := JTF_VARCHAR2_TABLE_100();
223: a11 := JTF_VARCHAR2_TABLE_100();
224: a12 := JTF_VARCHAR2_TABLE_100();
225: a13 := JTF_VARCHAR2_TABLE_100();
226: a14 := JTF_VARCHAR2_TABLE_100();
227: a15 := JTF_VARCHAR2_TABLE_100();
228: a16 := JTF_VARCHAR2_TABLE_100();
221: a9 := JTF_VARCHAR2_TABLE_100();
222: a10 := JTF_VARCHAR2_TABLE_100();
223: a11 := JTF_VARCHAR2_TABLE_100();
224: a12 := JTF_VARCHAR2_TABLE_100();
225: a13 := JTF_VARCHAR2_TABLE_100();
226: a14 := JTF_VARCHAR2_TABLE_100();
227: a15 := JTF_VARCHAR2_TABLE_100();
228: a16 := JTF_VARCHAR2_TABLE_100();
229: a17 := JTF_VARCHAR2_TABLE_100();
222: a10 := JTF_VARCHAR2_TABLE_100();
223: a11 := JTF_VARCHAR2_TABLE_100();
224: a12 := JTF_VARCHAR2_TABLE_100();
225: a13 := JTF_VARCHAR2_TABLE_100();
226: a14 := JTF_VARCHAR2_TABLE_100();
227: a15 := JTF_VARCHAR2_TABLE_100();
228: a16 := JTF_VARCHAR2_TABLE_100();
229: a17 := JTF_VARCHAR2_TABLE_100();
230: a18 := JTF_VARCHAR2_TABLE_100();
223: a11 := JTF_VARCHAR2_TABLE_100();
224: a12 := JTF_VARCHAR2_TABLE_100();
225: a13 := JTF_VARCHAR2_TABLE_100();
226: a14 := JTF_VARCHAR2_TABLE_100();
227: a15 := JTF_VARCHAR2_TABLE_100();
228: a16 := JTF_VARCHAR2_TABLE_100();
229: a17 := JTF_VARCHAR2_TABLE_100();
230: a18 := JTF_VARCHAR2_TABLE_100();
231: a19 := JTF_VARCHAR2_TABLE_100();
224: a12 := JTF_VARCHAR2_TABLE_100();
225: a13 := JTF_VARCHAR2_TABLE_100();
226: a14 := JTF_VARCHAR2_TABLE_100();
227: a15 := JTF_VARCHAR2_TABLE_100();
228: a16 := JTF_VARCHAR2_TABLE_100();
229: a17 := JTF_VARCHAR2_TABLE_100();
230: a18 := JTF_VARCHAR2_TABLE_100();
231: a19 := JTF_VARCHAR2_TABLE_100();
232: a20 := JTF_VARCHAR2_TABLE_100();
225: a13 := JTF_VARCHAR2_TABLE_100();
226: a14 := JTF_VARCHAR2_TABLE_100();
227: a15 := JTF_VARCHAR2_TABLE_100();
228: a16 := JTF_VARCHAR2_TABLE_100();
229: a17 := JTF_VARCHAR2_TABLE_100();
230: a18 := JTF_VARCHAR2_TABLE_100();
231: a19 := JTF_VARCHAR2_TABLE_100();
232: a20 := JTF_VARCHAR2_TABLE_100();
233: a21 := JTF_VARCHAR2_TABLE_100();
226: a14 := JTF_VARCHAR2_TABLE_100();
227: a15 := JTF_VARCHAR2_TABLE_100();
228: a16 := JTF_VARCHAR2_TABLE_100();
229: a17 := JTF_VARCHAR2_TABLE_100();
230: a18 := JTF_VARCHAR2_TABLE_100();
231: a19 := JTF_VARCHAR2_TABLE_100();
232: a20 := JTF_VARCHAR2_TABLE_100();
233: a21 := JTF_VARCHAR2_TABLE_100();
234: a22 := JTF_VARCHAR2_TABLE_100();
227: a15 := JTF_VARCHAR2_TABLE_100();
228: a16 := JTF_VARCHAR2_TABLE_100();
229: a17 := JTF_VARCHAR2_TABLE_100();
230: a18 := JTF_VARCHAR2_TABLE_100();
231: a19 := JTF_VARCHAR2_TABLE_100();
232: a20 := JTF_VARCHAR2_TABLE_100();
233: a21 := JTF_VARCHAR2_TABLE_100();
234: a22 := JTF_VARCHAR2_TABLE_100();
235: a23 := JTF_VARCHAR2_TABLE_100();
228: a16 := JTF_VARCHAR2_TABLE_100();
229: a17 := JTF_VARCHAR2_TABLE_100();
230: a18 := JTF_VARCHAR2_TABLE_100();
231: a19 := JTF_VARCHAR2_TABLE_100();
232: a20 := JTF_VARCHAR2_TABLE_100();
233: a21 := JTF_VARCHAR2_TABLE_100();
234: a22 := JTF_VARCHAR2_TABLE_100();
235: a23 := JTF_VARCHAR2_TABLE_100();
236: a24 := JTF_VARCHAR2_TABLE_100();
229: a17 := JTF_VARCHAR2_TABLE_100();
230: a18 := JTF_VARCHAR2_TABLE_100();
231: a19 := JTF_VARCHAR2_TABLE_100();
232: a20 := JTF_VARCHAR2_TABLE_100();
233: a21 := JTF_VARCHAR2_TABLE_100();
234: a22 := JTF_VARCHAR2_TABLE_100();
235: a23 := JTF_VARCHAR2_TABLE_100();
236: a24 := JTF_VARCHAR2_TABLE_100();
237: a25 := JTF_VARCHAR2_TABLE_100();
230: a18 := JTF_VARCHAR2_TABLE_100();
231: a19 := JTF_VARCHAR2_TABLE_100();
232: a20 := JTF_VARCHAR2_TABLE_100();
233: a21 := JTF_VARCHAR2_TABLE_100();
234: a22 := JTF_VARCHAR2_TABLE_100();
235: a23 := JTF_VARCHAR2_TABLE_100();
236: a24 := JTF_VARCHAR2_TABLE_100();
237: a25 := JTF_VARCHAR2_TABLE_100();
238: a26 := JTF_VARCHAR2_TABLE_100();
231: a19 := JTF_VARCHAR2_TABLE_100();
232: a20 := JTF_VARCHAR2_TABLE_100();
233: a21 := JTF_VARCHAR2_TABLE_100();
234: a22 := JTF_VARCHAR2_TABLE_100();
235: a23 := JTF_VARCHAR2_TABLE_100();
236: a24 := JTF_VARCHAR2_TABLE_100();
237: a25 := JTF_VARCHAR2_TABLE_100();
238: a26 := JTF_VARCHAR2_TABLE_100();
239: a27 := JTF_VARCHAR2_TABLE_100();
232: a20 := JTF_VARCHAR2_TABLE_100();
233: a21 := JTF_VARCHAR2_TABLE_100();
234: a22 := JTF_VARCHAR2_TABLE_100();
235: a23 := JTF_VARCHAR2_TABLE_100();
236: a24 := JTF_VARCHAR2_TABLE_100();
237: a25 := JTF_VARCHAR2_TABLE_100();
238: a26 := JTF_VARCHAR2_TABLE_100();
239: a27 := JTF_VARCHAR2_TABLE_100();
240: a28 := JTF_VARCHAR2_TABLE_100();
233: a21 := JTF_VARCHAR2_TABLE_100();
234: a22 := JTF_VARCHAR2_TABLE_100();
235: a23 := JTF_VARCHAR2_TABLE_100();
236: a24 := JTF_VARCHAR2_TABLE_100();
237: a25 := JTF_VARCHAR2_TABLE_100();
238: a26 := JTF_VARCHAR2_TABLE_100();
239: a27 := JTF_VARCHAR2_TABLE_100();
240: a28 := JTF_VARCHAR2_TABLE_100();
241: a29 := JTF_VARCHAR2_TABLE_100();
234: a22 := JTF_VARCHAR2_TABLE_100();
235: a23 := JTF_VARCHAR2_TABLE_100();
236: a24 := JTF_VARCHAR2_TABLE_100();
237: a25 := JTF_VARCHAR2_TABLE_100();
238: a26 := JTF_VARCHAR2_TABLE_100();
239: a27 := JTF_VARCHAR2_TABLE_100();
240: a28 := JTF_VARCHAR2_TABLE_100();
241: a29 := JTF_VARCHAR2_TABLE_100();
242: a30 := JTF_VARCHAR2_TABLE_100();
235: a23 := JTF_VARCHAR2_TABLE_100();
236: a24 := JTF_VARCHAR2_TABLE_100();
237: a25 := JTF_VARCHAR2_TABLE_100();
238: a26 := JTF_VARCHAR2_TABLE_100();
239: a27 := JTF_VARCHAR2_TABLE_100();
240: a28 := JTF_VARCHAR2_TABLE_100();
241: a29 := JTF_VARCHAR2_TABLE_100();
242: a30 := JTF_VARCHAR2_TABLE_100();
243: a31 := JTF_VARCHAR2_TABLE_100();
236: a24 := JTF_VARCHAR2_TABLE_100();
237: a25 := JTF_VARCHAR2_TABLE_100();
238: a26 := JTF_VARCHAR2_TABLE_100();
239: a27 := JTF_VARCHAR2_TABLE_100();
240: a28 := JTF_VARCHAR2_TABLE_100();
241: a29 := JTF_VARCHAR2_TABLE_100();
242: a30 := JTF_VARCHAR2_TABLE_100();
243: a31 := JTF_VARCHAR2_TABLE_100();
244: a32 := JTF_VARCHAR2_TABLE_100();
237: a25 := JTF_VARCHAR2_TABLE_100();
238: a26 := JTF_VARCHAR2_TABLE_100();
239: a27 := JTF_VARCHAR2_TABLE_100();
240: a28 := JTF_VARCHAR2_TABLE_100();
241: a29 := JTF_VARCHAR2_TABLE_100();
242: a30 := JTF_VARCHAR2_TABLE_100();
243: a31 := JTF_VARCHAR2_TABLE_100();
244: a32 := JTF_VARCHAR2_TABLE_100();
245: a33 := JTF_VARCHAR2_TABLE_2000();
238: a26 := JTF_VARCHAR2_TABLE_100();
239: a27 := JTF_VARCHAR2_TABLE_100();
240: a28 := JTF_VARCHAR2_TABLE_100();
241: a29 := JTF_VARCHAR2_TABLE_100();
242: a30 := JTF_VARCHAR2_TABLE_100();
243: a31 := JTF_VARCHAR2_TABLE_100();
244: a32 := JTF_VARCHAR2_TABLE_100();
245: a33 := JTF_VARCHAR2_TABLE_2000();
246: a34 := JTF_VARCHAR2_TABLE_2000();
239: a27 := JTF_VARCHAR2_TABLE_100();
240: a28 := JTF_VARCHAR2_TABLE_100();
241: a29 := JTF_VARCHAR2_TABLE_100();
242: a30 := JTF_VARCHAR2_TABLE_100();
243: a31 := JTF_VARCHAR2_TABLE_100();
244: a32 := JTF_VARCHAR2_TABLE_100();
245: a33 := JTF_VARCHAR2_TABLE_2000();
246: a34 := JTF_VARCHAR2_TABLE_2000();
247: a35 := JTF_VARCHAR2_TABLE_2000();
240: a28 := JTF_VARCHAR2_TABLE_100();
241: a29 := JTF_VARCHAR2_TABLE_100();
242: a30 := JTF_VARCHAR2_TABLE_100();
243: a31 := JTF_VARCHAR2_TABLE_100();
244: a32 := JTF_VARCHAR2_TABLE_100();
245: a33 := JTF_VARCHAR2_TABLE_2000();
246: a34 := JTF_VARCHAR2_TABLE_2000();
247: a35 := JTF_VARCHAR2_TABLE_2000();
248: a36 := JTF_VARCHAR2_TABLE_2000();
245: a33 := JTF_VARCHAR2_TABLE_2000();
246: a34 := JTF_VARCHAR2_TABLE_2000();
247: a35 := JTF_VARCHAR2_TABLE_2000();
248: a36 := JTF_VARCHAR2_TABLE_2000();
249: a37 := JTF_VARCHAR2_TABLE_100();
250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
253: a41 := JTF_VARCHAR2_TABLE_100();
246: a34 := JTF_VARCHAR2_TABLE_2000();
247: a35 := JTF_VARCHAR2_TABLE_2000();
248: a36 := JTF_VARCHAR2_TABLE_2000();
249: a37 := JTF_VARCHAR2_TABLE_100();
250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
253: a41 := JTF_VARCHAR2_TABLE_100();
254: if t.count > 0 then
247: a35 := JTF_VARCHAR2_TABLE_2000();
248: a36 := JTF_VARCHAR2_TABLE_2000();
249: a37 := JTF_VARCHAR2_TABLE_100();
250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
253: a41 := JTF_VARCHAR2_TABLE_100();
254: if t.count > 0 then
255: a0.extend(t.count);
248: a36 := JTF_VARCHAR2_TABLE_2000();
249: a37 := JTF_VARCHAR2_TABLE_100();
250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
253: a41 := JTF_VARCHAR2_TABLE_100();
254: if t.count > 0 then
255: a0.extend(t.count);
256: a1.extend(t.count);
249: a37 := JTF_VARCHAR2_TABLE_100();
250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
253: a41 := JTF_VARCHAR2_TABLE_100();
254: if t.count > 0 then
255: a0.extend(t.count);
256: a1.extend(t.count);
257: a2.extend(t.count);
348: end if;
349: end if;
350: end rosetta_table_copy_out_p2;
351:
352: procedure rosetta_table_copy_in_p6(t out nocopy as_osi_lead_pub.osi_cvb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
353: , a1 JTF_VARCHAR2_TABLE_100
354: ) as
355: ddindx binary_integer; indx binary_integer;
356: begin
349: end if;
350: end rosetta_table_copy_out_p2;
351:
352: procedure rosetta_table_copy_in_p6(t out nocopy as_osi_lead_pub.osi_cvb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
353: , a1 JTF_VARCHAR2_TABLE_100
354: ) as
355: ddindx binary_integer; indx binary_integer;
356: begin
357: if a0 is not null and a0.count > 0 then
369: end loop;
370: end if;
371: end if;
372: end rosetta_table_copy_in_p6;
373: procedure rosetta_table_copy_out_p6(t as_osi_lead_pub.osi_cvb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
374: , a1 out nocopy JTF_VARCHAR2_TABLE_100
375: ) as
376: ddindx binary_integer; indx binary_integer;
377: begin
370: end if;
371: end if;
372: end rosetta_table_copy_in_p6;
373: procedure rosetta_table_copy_out_p6(t as_osi_lead_pub.osi_cvb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
374: , a1 out nocopy JTF_VARCHAR2_TABLE_100
375: ) as
376: ddindx binary_integer; indx binary_integer;
377: begin
378: if t is null or t.count = 0 then
375: ) as
376: ddindx binary_integer; indx binary_integer;
377: begin
378: if t is null or t.count = 0 then
379: a0 := JTF_VARCHAR2_TABLE_100();
380: a1 := JTF_VARCHAR2_TABLE_100();
381: else
382: a0 := JTF_VARCHAR2_TABLE_100();
383: a1 := JTF_VARCHAR2_TABLE_100();
376: ddindx binary_integer; indx binary_integer;
377: begin
378: if t is null or t.count = 0 then
379: a0 := JTF_VARCHAR2_TABLE_100();
380: a1 := JTF_VARCHAR2_TABLE_100();
381: else
382: a0 := JTF_VARCHAR2_TABLE_100();
383: a1 := JTF_VARCHAR2_TABLE_100();
384: if t.count > 0 then
378: if t is null or t.count = 0 then
379: a0 := JTF_VARCHAR2_TABLE_100();
380: a1 := JTF_VARCHAR2_TABLE_100();
381: else
382: a0 := JTF_VARCHAR2_TABLE_100();
383: a1 := JTF_VARCHAR2_TABLE_100();
384: if t.count > 0 then
385: a0.extend(t.count);
386: a1.extend(t.count);
379: a0 := JTF_VARCHAR2_TABLE_100();
380: a1 := JTF_VARCHAR2_TABLE_100();
381: else
382: a0 := JTF_VARCHAR2_TABLE_100();
383: a1 := JTF_VARCHAR2_TABLE_100();
384: if t.count > 0 then
385: a0.extend(t.count);
386: a1.extend(t.count);
387: ddindx := t.first;
398: end if;
399: end if;
400: end rosetta_table_copy_out_p6;
401:
402: procedure rosetta_table_copy_in_p10(t out nocopy as_osi_lead_pub.osi_cnb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
403: , a1 JTF_VARCHAR2_TABLE_100
404: , a2 JTF_VARCHAR2_TABLE_100
405: ) as
406: ddindx binary_integer; indx binary_integer;
399: end if;
400: end rosetta_table_copy_out_p6;
401:
402: procedure rosetta_table_copy_in_p10(t out nocopy as_osi_lead_pub.osi_cnb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
403: , a1 JTF_VARCHAR2_TABLE_100
404: , a2 JTF_VARCHAR2_TABLE_100
405: ) as
406: ddindx binary_integer; indx binary_integer;
407: begin
400: end rosetta_table_copy_out_p6;
401:
402: procedure rosetta_table_copy_in_p10(t out nocopy as_osi_lead_pub.osi_cnb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
403: , a1 JTF_VARCHAR2_TABLE_100
404: , a2 JTF_VARCHAR2_TABLE_100
405: ) as
406: ddindx binary_integer; indx binary_integer;
407: begin
408: if a0 is not null and a0.count > 0 then
421: end loop;
422: end if;
423: end if;
424: end rosetta_table_copy_in_p10;
425: procedure rosetta_table_copy_out_p10(t as_osi_lead_pub.osi_cnb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
426: , a1 out nocopy JTF_VARCHAR2_TABLE_100
427: , a2 out nocopy JTF_VARCHAR2_TABLE_100
428: ) as
429: ddindx binary_integer; indx binary_integer;
422: end if;
423: end if;
424: end rosetta_table_copy_in_p10;
425: procedure rosetta_table_copy_out_p10(t as_osi_lead_pub.osi_cnb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
426: , a1 out nocopy JTF_VARCHAR2_TABLE_100
427: , a2 out nocopy JTF_VARCHAR2_TABLE_100
428: ) as
429: ddindx binary_integer; indx binary_integer;
430: begin
423: end if;
424: end rosetta_table_copy_in_p10;
425: procedure rosetta_table_copy_out_p10(t as_osi_lead_pub.osi_cnb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
426: , a1 out nocopy JTF_VARCHAR2_TABLE_100
427: , a2 out nocopy JTF_VARCHAR2_TABLE_100
428: ) as
429: ddindx binary_integer; indx binary_integer;
430: begin
431: if t is null or t.count = 0 then
428: ) as
429: ddindx binary_integer; indx binary_integer;
430: begin
431: if t is null or t.count = 0 then
432: a0 := JTF_VARCHAR2_TABLE_100();
433: a1 := JTF_VARCHAR2_TABLE_100();
434: a2 := JTF_VARCHAR2_TABLE_100();
435: else
436: a0 := JTF_VARCHAR2_TABLE_100();
429: ddindx binary_integer; indx binary_integer;
430: begin
431: if t is null or t.count = 0 then
432: a0 := JTF_VARCHAR2_TABLE_100();
433: a1 := JTF_VARCHAR2_TABLE_100();
434: a2 := JTF_VARCHAR2_TABLE_100();
435: else
436: a0 := JTF_VARCHAR2_TABLE_100();
437: a1 := JTF_VARCHAR2_TABLE_100();
430: begin
431: if t is null or t.count = 0 then
432: a0 := JTF_VARCHAR2_TABLE_100();
433: a1 := JTF_VARCHAR2_TABLE_100();
434: a2 := JTF_VARCHAR2_TABLE_100();
435: else
436: a0 := JTF_VARCHAR2_TABLE_100();
437: a1 := JTF_VARCHAR2_TABLE_100();
438: a2 := JTF_VARCHAR2_TABLE_100();
432: a0 := JTF_VARCHAR2_TABLE_100();
433: a1 := JTF_VARCHAR2_TABLE_100();
434: a2 := JTF_VARCHAR2_TABLE_100();
435: else
436: a0 := JTF_VARCHAR2_TABLE_100();
437: a1 := JTF_VARCHAR2_TABLE_100();
438: a2 := JTF_VARCHAR2_TABLE_100();
439: if t.count > 0 then
440: a0.extend(t.count);
433: a1 := JTF_VARCHAR2_TABLE_100();
434: a2 := JTF_VARCHAR2_TABLE_100();
435: else
436: a0 := JTF_VARCHAR2_TABLE_100();
437: a1 := JTF_VARCHAR2_TABLE_100();
438: a2 := JTF_VARCHAR2_TABLE_100();
439: if t.count > 0 then
440: a0.extend(t.count);
441: a1.extend(t.count);
434: a2 := JTF_VARCHAR2_TABLE_100();
435: else
436: a0 := JTF_VARCHAR2_TABLE_100();
437: a1 := JTF_VARCHAR2_TABLE_100();
438: a2 := JTF_VARCHAR2_TABLE_100();
439: if t.count > 0 then
440: a0.extend(t.count);
441: a1.extend(t.count);
442: a2.extend(t.count);
455: end if;
456: end if;
457: end rosetta_table_copy_out_p10;
458:
459: procedure rosetta_table_copy_in_p14(t out nocopy as_osi_lead_pub.osi_lkp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
460: , a1 JTF_VARCHAR2_TABLE_100
461: , a2 JTF_VARCHAR2_TABLE_200
462: ) as
463: ddindx binary_integer; indx binary_integer;
456: end if;
457: end rosetta_table_copy_out_p10;
458:
459: procedure rosetta_table_copy_in_p14(t out nocopy as_osi_lead_pub.osi_lkp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
460: , a1 JTF_VARCHAR2_TABLE_100
461: , a2 JTF_VARCHAR2_TABLE_200
462: ) as
463: ddindx binary_integer; indx binary_integer;
464: begin
478: end loop;
479: end if;
480: end if;
481: end rosetta_table_copy_in_p14;
482: procedure rosetta_table_copy_out_p14(t as_osi_lead_pub.osi_lkp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
483: , a1 out nocopy JTF_VARCHAR2_TABLE_100
484: , a2 out nocopy JTF_VARCHAR2_TABLE_200
485: ) as
486: ddindx binary_integer; indx binary_integer;
479: end if;
480: end if;
481: end rosetta_table_copy_in_p14;
482: procedure rosetta_table_copy_out_p14(t as_osi_lead_pub.osi_lkp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
483: , a1 out nocopy JTF_VARCHAR2_TABLE_100
484: , a2 out nocopy JTF_VARCHAR2_TABLE_200
485: ) as
486: ddindx binary_integer; indx binary_integer;
487: begin
485: ) as
486: ddindx binary_integer; indx binary_integer;
487: begin
488: if t is null or t.count = 0 then
489: a0 := JTF_VARCHAR2_TABLE_100();
490: a1 := JTF_VARCHAR2_TABLE_100();
491: a2 := JTF_VARCHAR2_TABLE_200();
492: else
493: a0 := JTF_VARCHAR2_TABLE_100();
486: ddindx binary_integer; indx binary_integer;
487: begin
488: if t is null or t.count = 0 then
489: a0 := JTF_VARCHAR2_TABLE_100();
490: a1 := JTF_VARCHAR2_TABLE_100();
491: a2 := JTF_VARCHAR2_TABLE_200();
492: else
493: a0 := JTF_VARCHAR2_TABLE_100();
494: a1 := JTF_VARCHAR2_TABLE_100();
489: a0 := JTF_VARCHAR2_TABLE_100();
490: a1 := JTF_VARCHAR2_TABLE_100();
491: a2 := JTF_VARCHAR2_TABLE_200();
492: else
493: a0 := JTF_VARCHAR2_TABLE_100();
494: a1 := JTF_VARCHAR2_TABLE_100();
495: a2 := JTF_VARCHAR2_TABLE_200();
496: if t.count > 0 then
497: a0.extend(t.count);
490: a1 := JTF_VARCHAR2_TABLE_100();
491: a2 := JTF_VARCHAR2_TABLE_200();
492: else
493: a0 := JTF_VARCHAR2_TABLE_100();
494: a1 := JTF_VARCHAR2_TABLE_100();
495: a2 := JTF_VARCHAR2_TABLE_200();
496: if t.count > 0 then
497: a0.extend(t.count);
498: a1.extend(t.count);
512: end if;
513: end if;
514: end rosetta_table_copy_out_p14;
515:
516: procedure rosetta_table_copy_in_p18(t out nocopy as_osi_lead_pub.osi_nam_tbl_type, a0 JTF_VARCHAR2_TABLE_100
517: , a1 JTF_VARCHAR2_TABLE_100
518: , a2 JTF_VARCHAR2_TABLE_100
519: ) as
520: ddindx binary_integer; indx binary_integer;
513: end if;
514: end rosetta_table_copy_out_p14;
515:
516: procedure rosetta_table_copy_in_p18(t out nocopy as_osi_lead_pub.osi_nam_tbl_type, a0 JTF_VARCHAR2_TABLE_100
517: , a1 JTF_VARCHAR2_TABLE_100
518: , a2 JTF_VARCHAR2_TABLE_100
519: ) as
520: ddindx binary_integer; indx binary_integer;
521: begin
514: end rosetta_table_copy_out_p14;
515:
516: procedure rosetta_table_copy_in_p18(t out nocopy as_osi_lead_pub.osi_nam_tbl_type, a0 JTF_VARCHAR2_TABLE_100
517: , a1 JTF_VARCHAR2_TABLE_100
518: , a2 JTF_VARCHAR2_TABLE_100
519: ) as
520: ddindx binary_integer; indx binary_integer;
521: begin
522: if a0 is not null and a0.count > 0 then
535: end loop;
536: end if;
537: end if;
538: end rosetta_table_copy_in_p18;
539: procedure rosetta_table_copy_out_p18(t as_osi_lead_pub.osi_nam_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
540: , a1 out nocopy JTF_VARCHAR2_TABLE_100
541: , a2 out nocopy JTF_VARCHAR2_TABLE_100
542: ) as
543: ddindx binary_integer; indx binary_integer;
536: end if;
537: end if;
538: end rosetta_table_copy_in_p18;
539: procedure rosetta_table_copy_out_p18(t as_osi_lead_pub.osi_nam_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
540: , a1 out nocopy JTF_VARCHAR2_TABLE_100
541: , a2 out nocopy JTF_VARCHAR2_TABLE_100
542: ) as
543: ddindx binary_integer; indx binary_integer;
544: begin
537: end if;
538: end rosetta_table_copy_in_p18;
539: procedure rosetta_table_copy_out_p18(t as_osi_lead_pub.osi_nam_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
540: , a1 out nocopy JTF_VARCHAR2_TABLE_100
541: , a2 out nocopy JTF_VARCHAR2_TABLE_100
542: ) as
543: ddindx binary_integer; indx binary_integer;
544: begin
545: if t is null or t.count = 0 then
542: ) as
543: ddindx binary_integer; indx binary_integer;
544: begin
545: if t is null or t.count = 0 then
546: a0 := JTF_VARCHAR2_TABLE_100();
547: a1 := JTF_VARCHAR2_TABLE_100();
548: a2 := JTF_VARCHAR2_TABLE_100();
549: else
550: a0 := JTF_VARCHAR2_TABLE_100();
543: ddindx binary_integer; indx binary_integer;
544: begin
545: if t is null or t.count = 0 then
546: a0 := JTF_VARCHAR2_TABLE_100();
547: a1 := JTF_VARCHAR2_TABLE_100();
548: a2 := JTF_VARCHAR2_TABLE_100();
549: else
550: a0 := JTF_VARCHAR2_TABLE_100();
551: a1 := JTF_VARCHAR2_TABLE_100();
544: begin
545: if t is null or t.count = 0 then
546: a0 := JTF_VARCHAR2_TABLE_100();
547: a1 := JTF_VARCHAR2_TABLE_100();
548: a2 := JTF_VARCHAR2_TABLE_100();
549: else
550: a0 := JTF_VARCHAR2_TABLE_100();
551: a1 := JTF_VARCHAR2_TABLE_100();
552: a2 := JTF_VARCHAR2_TABLE_100();
546: a0 := JTF_VARCHAR2_TABLE_100();
547: a1 := JTF_VARCHAR2_TABLE_100();
548: a2 := JTF_VARCHAR2_TABLE_100();
549: else
550: a0 := JTF_VARCHAR2_TABLE_100();
551: a1 := JTF_VARCHAR2_TABLE_100();
552: a2 := JTF_VARCHAR2_TABLE_100();
553: if t.count > 0 then
554: a0.extend(t.count);
547: a1 := JTF_VARCHAR2_TABLE_100();
548: a2 := JTF_VARCHAR2_TABLE_100();
549: else
550: a0 := JTF_VARCHAR2_TABLE_100();
551: a1 := JTF_VARCHAR2_TABLE_100();
552: a2 := JTF_VARCHAR2_TABLE_100();
553: if t.count > 0 then
554: a0.extend(t.count);
555: a1.extend(t.count);
548: a2 := JTF_VARCHAR2_TABLE_100();
549: else
550: a0 := JTF_VARCHAR2_TABLE_100();
551: a1 := JTF_VARCHAR2_TABLE_100();
552: a2 := JTF_VARCHAR2_TABLE_100();
553: if t.count > 0 then
554: a0.extend(t.count);
555: a1.extend(t.count);
556: a2.extend(t.count);
569: end if;
570: end if;
571: end rosetta_table_copy_out_p18;
572:
573: procedure rosetta_table_copy_in_p22(t out nocopy as_osi_lead_pub.osi_ccs_tbl_type, a0 JTF_VARCHAR2_TABLE_100
574: , a1 JTF_VARCHAR2_TABLE_100
575: ) as
576: ddindx binary_integer; indx binary_integer;
577: begin
570: end if;
571: end rosetta_table_copy_out_p18;
572:
573: procedure rosetta_table_copy_in_p22(t out nocopy as_osi_lead_pub.osi_ccs_tbl_type, a0 JTF_VARCHAR2_TABLE_100
574: , a1 JTF_VARCHAR2_TABLE_100
575: ) as
576: ddindx binary_integer; indx binary_integer;
577: begin
578: if a0 is not null and a0.count > 0 then
590: end loop;
591: end if;
592: end if;
593: end rosetta_table_copy_in_p22;
594: procedure rosetta_table_copy_out_p22(t as_osi_lead_pub.osi_ccs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
595: , a1 out nocopy JTF_VARCHAR2_TABLE_100
596: ) as
597: ddindx binary_integer; indx binary_integer;
598: begin
591: end if;
592: end if;
593: end rosetta_table_copy_in_p22;
594: procedure rosetta_table_copy_out_p22(t as_osi_lead_pub.osi_ccs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
595: , a1 out nocopy JTF_VARCHAR2_TABLE_100
596: ) as
597: ddindx binary_integer; indx binary_integer;
598: begin
599: if t is null or t.count = 0 then
596: ) as
597: ddindx binary_integer; indx binary_integer;
598: begin
599: if t is null or t.count = 0 then
600: a0 := JTF_VARCHAR2_TABLE_100();
601: a1 := JTF_VARCHAR2_TABLE_100();
602: else
603: a0 := JTF_VARCHAR2_TABLE_100();
604: a1 := JTF_VARCHAR2_TABLE_100();
597: ddindx binary_integer; indx binary_integer;
598: begin
599: if t is null or t.count = 0 then
600: a0 := JTF_VARCHAR2_TABLE_100();
601: a1 := JTF_VARCHAR2_TABLE_100();
602: else
603: a0 := JTF_VARCHAR2_TABLE_100();
604: a1 := JTF_VARCHAR2_TABLE_100();
605: if t.count > 0 then
599: if t is null or t.count = 0 then
600: a0 := JTF_VARCHAR2_TABLE_100();
601: a1 := JTF_VARCHAR2_TABLE_100();
602: else
603: a0 := JTF_VARCHAR2_TABLE_100();
604: a1 := JTF_VARCHAR2_TABLE_100();
605: if t.count > 0 then
606: a0.extend(t.count);
607: a1.extend(t.count);
600: a0 := JTF_VARCHAR2_TABLE_100();
601: a1 := JTF_VARCHAR2_TABLE_100();
602: else
603: a0 := JTF_VARCHAR2_TABLE_100();
604: a1 := JTF_VARCHAR2_TABLE_100();
605: if t.count > 0 then
606: a0.extend(t.count);
607: a1.extend(t.count);
608: ddindx := t.first;
619: end if;
620: end if;
621: end rosetta_table_copy_out_p22;
622:
623: procedure rosetta_table_copy_in_p26(t out nocopy as_osi_lead_pub.osi_ovm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
624: , a1 JTF_VARCHAR2_TABLE_100
625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin
620: end if;
621: end rosetta_table_copy_out_p22;
622:
623: procedure rosetta_table_copy_in_p26(t out nocopy as_osi_lead_pub.osi_ovm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
624: , a1 JTF_VARCHAR2_TABLE_100
625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin
628: if a0 is not null and a0.count > 0 then
640: end loop;
641: end if;
642: end if;
643: end rosetta_table_copy_in_p26;
644: procedure rosetta_table_copy_out_p26(t as_osi_lead_pub.osi_ovm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
645: , a1 out nocopy JTF_VARCHAR2_TABLE_100
646: ) as
647: ddindx binary_integer; indx binary_integer;
648: begin
641: end if;
642: end if;
643: end rosetta_table_copy_in_p26;
644: procedure rosetta_table_copy_out_p26(t as_osi_lead_pub.osi_ovm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
645: , a1 out nocopy JTF_VARCHAR2_TABLE_100
646: ) as
647: ddindx binary_integer; indx binary_integer;
648: begin
649: if t is null or t.count = 0 then
646: ) as
647: ddindx binary_integer; indx binary_integer;
648: begin
649: if t is null or t.count = 0 then
650: a0 := JTF_VARCHAR2_TABLE_100();
651: a1 := JTF_VARCHAR2_TABLE_100();
652: else
653: a0 := JTF_VARCHAR2_TABLE_100();
654: a1 := JTF_VARCHAR2_TABLE_100();
647: ddindx binary_integer; indx binary_integer;
648: begin
649: if t is null or t.count = 0 then
650: a0 := JTF_VARCHAR2_TABLE_100();
651: a1 := JTF_VARCHAR2_TABLE_100();
652: else
653: a0 := JTF_VARCHAR2_TABLE_100();
654: a1 := JTF_VARCHAR2_TABLE_100();
655: if t.count > 0 then
649: if t is null or t.count = 0 then
650: a0 := JTF_VARCHAR2_TABLE_100();
651: a1 := JTF_VARCHAR2_TABLE_100();
652: else
653: a0 := JTF_VARCHAR2_TABLE_100();
654: a1 := JTF_VARCHAR2_TABLE_100();
655: if t.count > 0 then
656: a0.extend(t.count);
657: a1.extend(t.count);
650: a0 := JTF_VARCHAR2_TABLE_100();
651: a1 := JTF_VARCHAR2_TABLE_100();
652: else
653: a0 := JTF_VARCHAR2_TABLE_100();
654: a1 := JTF_VARCHAR2_TABLE_100();
655: if t.count > 0 then
656: a0.extend(t.count);
657: a1.extend(t.count);
658: ddindx := t.first;
669: end if;
670: end if;
671: end rosetta_table_copy_out_p26;
672:
673: procedure rosetta_table_copy_in_p30(t out nocopy as_osi_lead_pub.osi_ovd_tbl_type, a0 JTF_VARCHAR2_TABLE_100
674: , a1 JTF_VARCHAR2_TABLE_100
675: ) as
676: ddindx binary_integer; indx binary_integer;
677: begin
670: end if;
671: end rosetta_table_copy_out_p26;
672:
673: procedure rosetta_table_copy_in_p30(t out nocopy as_osi_lead_pub.osi_ovd_tbl_type, a0 JTF_VARCHAR2_TABLE_100
674: , a1 JTF_VARCHAR2_TABLE_100
675: ) as
676: ddindx binary_integer; indx binary_integer;
677: begin
678: if a0 is not null and a0.count > 0 then
690: end loop;
691: end if;
692: end if;
693: end rosetta_table_copy_in_p30;
694: procedure rosetta_table_copy_out_p30(t as_osi_lead_pub.osi_ovd_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
695: , a1 out nocopy JTF_VARCHAR2_TABLE_100
696: ) as
697: ddindx binary_integer; indx binary_integer;
698: begin
691: end if;
692: end if;
693: end rosetta_table_copy_in_p30;
694: procedure rosetta_table_copy_out_p30(t as_osi_lead_pub.osi_ovd_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
695: , a1 out nocopy JTF_VARCHAR2_TABLE_100
696: ) as
697: ddindx binary_integer; indx binary_integer;
698: begin
699: if t is null or t.count = 0 then
696: ) as
697: ddindx binary_integer; indx binary_integer;
698: begin
699: if t is null or t.count = 0 then
700: a0 := JTF_VARCHAR2_TABLE_100();
701: a1 := JTF_VARCHAR2_TABLE_100();
702: else
703: a0 := JTF_VARCHAR2_TABLE_100();
704: a1 := JTF_VARCHAR2_TABLE_100();
697: ddindx binary_integer; indx binary_integer;
698: begin
699: if t is null or t.count = 0 then
700: a0 := JTF_VARCHAR2_TABLE_100();
701: a1 := JTF_VARCHAR2_TABLE_100();
702: else
703: a0 := JTF_VARCHAR2_TABLE_100();
704: a1 := JTF_VARCHAR2_TABLE_100();
705: if t.count > 0 then
699: if t is null or t.count = 0 then
700: a0 := JTF_VARCHAR2_TABLE_100();
701: a1 := JTF_VARCHAR2_TABLE_100();
702: else
703: a0 := JTF_VARCHAR2_TABLE_100();
704: a1 := JTF_VARCHAR2_TABLE_100();
705: if t.count > 0 then
706: a0.extend(t.count);
707: a1.extend(t.count);
700: a0 := JTF_VARCHAR2_TABLE_100();
701: a1 := JTF_VARCHAR2_TABLE_100();
702: else
703: a0 := JTF_VARCHAR2_TABLE_100();
704: a1 := JTF_VARCHAR2_TABLE_100();
705: if t.count > 0 then
706: a0.extend(t.count);
707: a1.extend(t.count);
708: ddindx := t.first;
763: , p2_a38 out nocopy VARCHAR2
764: , p2_a39 out nocopy VARCHAR2
765: , p2_a40 out nocopy VARCHAR2
766: , p2_a41 out nocopy VARCHAR2
767: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
768: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
769: )
770:
771: as
764: , p2_a39 out nocopy VARCHAR2
765: , p2_a40 out nocopy VARCHAR2
766: , p2_a41 out nocopy VARCHAR2
767: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
768: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
769: )
770:
771: as
772: ddp_osi_rec as_osi_lead_pub.osi_rec_type;
879: , p2_a38 out nocopy VARCHAR2
880: , p2_a39 out nocopy VARCHAR2
881: , p2_a40 out nocopy VARCHAR2
882: , p2_a41 out nocopy VARCHAR2
883: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
884: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
885: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
886: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
887: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
880: , p2_a39 out nocopy VARCHAR2
881: , p2_a40 out nocopy VARCHAR2
882: , p2_a41 out nocopy VARCHAR2
883: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
884: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
885: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
886: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
887: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
888: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
881: , p2_a40 out nocopy VARCHAR2
882: , p2_a41 out nocopy VARCHAR2
883: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
884: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
885: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
886: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
887: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
888: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
889: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
882: , p2_a41 out nocopy VARCHAR2
883: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
884: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
885: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
886: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
887: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
888: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
889: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
890: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
883: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
884: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
885: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
886: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
887: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
888: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
889: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
890: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
891: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
884: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
885: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
886: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
887: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
888: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
889: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
890: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
891: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
892: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
885: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
886: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
887: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
888: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
889: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
890: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
891: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
892: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
893: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
887: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
888: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
889: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
890: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
891: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
892: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
893: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
894: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
895: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
888: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
889: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
890: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
891: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
892: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
893: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
894: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
895: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
896: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
889: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
890: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
891: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
892: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
893: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
894: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
895: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
896: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
897: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
890: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_200
891: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
892: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
893: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
894: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
895: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
896: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
897: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
898: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
891: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
892: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
893: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
894: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
895: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
896: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
897: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
898: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
899: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
892: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
893: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
894: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
895: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
896: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
897: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
898: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
899: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
900: )
893: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
894: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
895: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
896: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
897: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
898: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
899: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
900: )
901:
894: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
895: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
896: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
897: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
898: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
899: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
900: )
901:
902: as
895: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
896: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
897: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
898: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
899: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
900: )
901:
902: as
903: ddp_osi_rec as_osi_lead_pub.osi_rec_type;
1012: );
1013: end;
1014:
1015: procedure osi_lookup_fetch_all(p_api_version_number NUMBER
1016: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
1017: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1019: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
1013: end;
1014:
1015: procedure osi_lookup_fetch_all(p_api_version_number NUMBER
1016: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
1017: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1019: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
1021: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
1014:
1015: procedure osi_lookup_fetch_all(p_api_version_number NUMBER
1016: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
1017: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1019: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
1021: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1015: procedure osi_lookup_fetch_all(p_api_version_number NUMBER
1016: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
1017: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1019: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
1021: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
1016: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
1017: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1019: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
1021: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
1024: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1017: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1019: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
1021: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
1024: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1025: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1018: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1019: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
1021: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
1024: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1025: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1026: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
1021: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
1024: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1025: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1026: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
1021: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
1024: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1025: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1026: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
1029: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1022: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
1024: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1025: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1026: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
1029: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1030: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
1024: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1025: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1026: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
1029: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1030: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1031: )
1024: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1025: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1026: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
1029: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1030: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1031: )
1032:
1025: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1026: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
1029: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1030: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1031: )
1032:
1033: as
1026: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
1027: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
1029: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
1030: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1031: )
1032:
1033: as
1034: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
1089:
1090: procedure osi_lead_update(p_api_version_number NUMBER
1091: , p_init_msg_list VARCHAR2
1092: , p_commit VARCHAR2
1093: , p4_a0 JTF_VARCHAR2_TABLE_100
1094: , p4_a1 JTF_VARCHAR2_TABLE_100
1095: , x_return_status out nocopy VARCHAR2
1096: , x_msg_count out nocopy VARCHAR2
1097: , x_msg_data out nocopy VARCHAR2
1090: procedure osi_lead_update(p_api_version_number NUMBER
1091: , p_init_msg_list VARCHAR2
1092: , p_commit VARCHAR2
1093: , p4_a0 JTF_VARCHAR2_TABLE_100
1094: , p4_a1 JTF_VARCHAR2_TABLE_100
1095: , x_return_status out nocopy VARCHAR2
1096: , x_msg_count out nocopy VARCHAR2
1097: , x_msg_data out nocopy VARCHAR2
1098: , p3_a0 DATE := fnd_api.g_miss_date
1219:
1220: end;
1221:
1222: procedure osi_cvb_fetch(p_api_version_number NUMBER
1223: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
1224: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1225: )
1226:
1227: as
1220: end;
1221:
1222: procedure osi_cvb_fetch(p_api_version_number NUMBER
1223: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
1224: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1225: )
1226:
1227: as
1228: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
1243: );
1244: end;
1245:
1246: procedure osi_cnb_fetch(p_api_version_number NUMBER
1247: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
1248: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1249: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
1250: )
1251:
1244: end;
1245:
1246: procedure osi_cnb_fetch(p_api_version_number NUMBER
1247: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
1248: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1249: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
1250: )
1251:
1252: as
1245:
1246: procedure osi_cnb_fetch(p_api_version_number NUMBER
1247: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
1248: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1249: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
1250: )
1251:
1252: as
1253: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
1270: end;
1271:
1272: procedure osi_lkp_fetch(p_api_version_number NUMBER
1273: , p_osi_lkp_type VARCHAR2
1274: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1275: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1276: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
1277: )
1278:
1271:
1272: procedure osi_lkp_fetch(p_api_version_number NUMBER
1273: , p_osi_lkp_type VARCHAR2
1274: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1275: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1276: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
1277: )
1278:
1279: as
1300: end;
1301:
1302: procedure osi_nam_fetch(p_api_version_number NUMBER
1303: , p_osi_nam_type VARCHAR2
1304: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1305: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1306: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
1307: )
1308:
1301:
1302: procedure osi_nam_fetch(p_api_version_number NUMBER
1303: , p_osi_nam_type VARCHAR2
1304: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1305: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1306: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
1307: )
1308:
1309: as
1302: procedure osi_nam_fetch(p_api_version_number NUMBER
1303: , p_osi_nam_type VARCHAR2
1304: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1305: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1306: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
1307: )
1308:
1309: as
1310: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;