23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_DATE_TABLE
28: , a15 JTF_DATE_TABLE
29: , a16 JTF_NUMBER_TABLE
30: ) as
31: ddindx binary_integer; indx binary_integer;
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_DATE_TABLE
28: , a15 JTF_DATE_TABLE
29: , a16 JTF_NUMBER_TABLE
30: ) as
31: ddindx binary_integer; indx binary_integer;
32: begin
74: , a10 out nocopy JTF_VARCHAR2_TABLE_100
75: , a11 out nocopy JTF_VARCHAR2_TABLE_100
76: , a12 out nocopy JTF_VARCHAR2_TABLE_100
77: , a13 out nocopy JTF_VARCHAR2_TABLE_100
78: , a14 out nocopy JTF_DATE_TABLE
79: , a15 out nocopy JTF_DATE_TABLE
80: , a16 out nocopy JTF_NUMBER_TABLE
81: ) as
82: ddindx binary_integer; indx binary_integer;
75: , a11 out nocopy JTF_VARCHAR2_TABLE_100
76: , a12 out nocopy JTF_VARCHAR2_TABLE_100
77: , a13 out nocopy JTF_VARCHAR2_TABLE_100
78: , a14 out nocopy JTF_DATE_TABLE
79: , a15 out nocopy JTF_DATE_TABLE
80: , a16 out nocopy JTF_NUMBER_TABLE
81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_100();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: a13 := JTF_VARCHAR2_TABLE_100();
99: a14 := JTF_DATE_TABLE();
100: a15 := JTF_DATE_TABLE();
101: a16 := JTF_NUMBER_TABLE();
102: else
103: a0 := JTF_NUMBER_TABLE();
96: a11 := JTF_VARCHAR2_TABLE_100();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: a13 := JTF_VARCHAR2_TABLE_100();
99: a14 := JTF_DATE_TABLE();
100: a15 := JTF_DATE_TABLE();
101: a16 := JTF_NUMBER_TABLE();
102: else
103: a0 := JTF_NUMBER_TABLE();
104: a1 := JTF_VARCHAR2_TABLE_400();
113: a10 := JTF_VARCHAR2_TABLE_100();
114: a11 := JTF_VARCHAR2_TABLE_100();
115: a12 := JTF_VARCHAR2_TABLE_100();
116: a13 := JTF_VARCHAR2_TABLE_100();
117: a14 := JTF_DATE_TABLE();
118: a15 := JTF_DATE_TABLE();
119: a16 := JTF_NUMBER_TABLE();
120: if t.count > 0 then
121: a0.extend(t.count);
114: a11 := JTF_VARCHAR2_TABLE_100();
115: a12 := JTF_VARCHAR2_TABLE_100();
116: a13 := JTF_VARCHAR2_TABLE_100();
117: a14 := JTF_DATE_TABLE();
118: a15 := JTF_DATE_TABLE();
119: a16 := JTF_NUMBER_TABLE();
120: if t.count > 0 then
121: a0.extend(t.count);
122: a1.extend(t.count);
189: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
190: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
191: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
192: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
193: , p11_a14 out nocopy JTF_DATE_TABLE
194: , p11_a15 out nocopy JTF_DATE_TABLE
195: , p11_a16 out nocopy JTF_NUMBER_TABLE
196: , x_total_rows out nocopy NUMBER
197: )
190: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
191: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
192: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
193: , p11_a14 out nocopy JTF_DATE_TABLE
194: , p11_a15 out nocopy JTF_DATE_TABLE
195: , p11_a16 out nocopy JTF_NUMBER_TABLE
196: , x_total_rows out nocopy NUMBER
197: )
198:
290: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
291: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
292: , p12_a12 out nocopy JTF_VARCHAR2_TABLE_100
293: , p12_a13 out nocopy JTF_VARCHAR2_TABLE_100
294: , p12_a14 out nocopy JTF_DATE_TABLE
295: , p12_a15 out nocopy JTF_DATE_TABLE
296: , p12_a16 out nocopy JTF_NUMBER_TABLE
297: , x_total_rows out nocopy NUMBER
298: )
291: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
292: , p12_a12 out nocopy JTF_VARCHAR2_TABLE_100
293: , p12_a13 out nocopy JTF_VARCHAR2_TABLE_100
294: , p12_a14 out nocopy JTF_DATE_TABLE
295: , p12_a15 out nocopy JTF_DATE_TABLE
296: , p12_a16 out nocopy JTF_NUMBER_TABLE
297: , x_total_rows out nocopy NUMBER
298: )
299: