19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: ) as
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: ) as
32: ddindx binary_integer; indx binary_integer;
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin
34: if a0 is not null and a0.count > 0 then
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_DATE_TABLE
68: , a5 out nocopy JTF_NUMBER_TABLE
69: , a6 out nocopy JTF_NUMBER_TABLE
70: , a7 out nocopy JTF_VARCHAR2_TABLE_100
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
73: , a10 out nocopy JTF_VARCHAR2_TABLE_100
74: , a11 out nocopy JTF_VARCHAR2_TABLE_100
67: , a4 out nocopy JTF_DATE_TABLE
68: , a5 out nocopy JTF_NUMBER_TABLE
69: , a6 out nocopy JTF_NUMBER_TABLE
70: , a7 out nocopy JTF_VARCHAR2_TABLE_100
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
73: , a10 out nocopy JTF_VARCHAR2_TABLE_100
74: , a11 out nocopy JTF_VARCHAR2_TABLE_100
75: , a12 out nocopy JTF_VARCHAR2_TABLE_100
68: , a5 out nocopy JTF_NUMBER_TABLE
69: , a6 out nocopy JTF_NUMBER_TABLE
70: , a7 out nocopy JTF_VARCHAR2_TABLE_100
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
73: , a10 out nocopy JTF_VARCHAR2_TABLE_100
74: , a11 out nocopy JTF_VARCHAR2_TABLE_100
75: , a12 out nocopy JTF_VARCHAR2_TABLE_100
76: , a13 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_NUMBER_TABLE
70: , a7 out nocopy JTF_VARCHAR2_TABLE_100
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
73: , a10 out nocopy JTF_VARCHAR2_TABLE_100
74: , a11 out nocopy JTF_VARCHAR2_TABLE_100
75: , a12 out nocopy JTF_VARCHAR2_TABLE_100
76: , a13 out nocopy JTF_VARCHAR2_TABLE_100
77: , a14 out nocopy JTF_VARCHAR2_TABLE_100
70: , a7 out nocopy JTF_VARCHAR2_TABLE_100
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
73: , a10 out nocopy JTF_VARCHAR2_TABLE_100
74: , a11 out nocopy JTF_VARCHAR2_TABLE_100
75: , a12 out nocopy JTF_VARCHAR2_TABLE_100
76: , a13 out nocopy JTF_VARCHAR2_TABLE_100
77: , a14 out nocopy JTF_VARCHAR2_TABLE_100
78: ) as
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
73: , a10 out nocopy JTF_VARCHAR2_TABLE_100
74: , a11 out nocopy JTF_VARCHAR2_TABLE_100
75: , a12 out nocopy JTF_VARCHAR2_TABLE_100
76: , a13 out nocopy JTF_VARCHAR2_TABLE_100
77: , a14 out nocopy JTF_VARCHAR2_TABLE_100
78: ) as
79: ddindx binary_integer; indx binary_integer;
72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
73: , a10 out nocopy JTF_VARCHAR2_TABLE_100
74: , a11 out nocopy JTF_VARCHAR2_TABLE_100
75: , a12 out nocopy JTF_VARCHAR2_TABLE_100
76: , a13 out nocopy JTF_VARCHAR2_TABLE_100
77: , a14 out nocopy JTF_VARCHAR2_TABLE_100
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
73: , a10 out nocopy JTF_VARCHAR2_TABLE_100
74: , a11 out nocopy JTF_VARCHAR2_TABLE_100
75: , a12 out nocopy JTF_VARCHAR2_TABLE_100
76: , a13 out nocopy JTF_VARCHAR2_TABLE_100
77: , a14 out nocopy JTF_VARCHAR2_TABLE_100
78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if t is null or t.count = 0 then
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_DATE_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_DATE_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: a13 := JTF_VARCHAR2_TABLE_100();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: a13 := JTF_VARCHAR2_TABLE_100();
96: a14 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: a13 := JTF_VARCHAR2_TABLE_100();
96: a14 := JTF_VARCHAR2_TABLE_100();
97: else
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: a13 := JTF_VARCHAR2_TABLE_100();
96: a14 := JTF_VARCHAR2_TABLE_100();
97: else
98: a0 := JTF_NUMBER_TABLE();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: a13 := JTF_VARCHAR2_TABLE_100();
96: a14 := JTF_VARCHAR2_TABLE_100();
97: else
98: a0 := JTF_NUMBER_TABLE();
99: a1 := JTF_NUMBER_TABLE();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: a11 := JTF_VARCHAR2_TABLE_100();
94: a12 := JTF_VARCHAR2_TABLE_100();
95: a13 := JTF_VARCHAR2_TABLE_100();
96: a14 := JTF_VARCHAR2_TABLE_100();
97: else
98: a0 := JTF_NUMBER_TABLE();
99: a1 := JTF_NUMBER_TABLE();
100: a2 := JTF_DATE_TABLE();
101: a3 := JTF_NUMBER_TABLE();
102: a4 := JTF_DATE_TABLE();
103: a5 := JTF_NUMBER_TABLE();
104: a6 := JTF_NUMBER_TABLE();
105: a7 := JTF_VARCHAR2_TABLE_100();
106: a8 := JTF_VARCHAR2_TABLE_100();
107: a9 := JTF_VARCHAR2_TABLE_100();
108: a10 := JTF_VARCHAR2_TABLE_100();
109: a11 := JTF_VARCHAR2_TABLE_100();
102: a4 := JTF_DATE_TABLE();
103: a5 := JTF_NUMBER_TABLE();
104: a6 := JTF_NUMBER_TABLE();
105: a7 := JTF_VARCHAR2_TABLE_100();
106: a8 := JTF_VARCHAR2_TABLE_100();
107: a9 := JTF_VARCHAR2_TABLE_100();
108: a10 := JTF_VARCHAR2_TABLE_100();
109: a11 := JTF_VARCHAR2_TABLE_100();
110: a12 := JTF_VARCHAR2_TABLE_100();
103: a5 := JTF_NUMBER_TABLE();
104: a6 := JTF_NUMBER_TABLE();
105: a7 := JTF_VARCHAR2_TABLE_100();
106: a8 := JTF_VARCHAR2_TABLE_100();
107: a9 := JTF_VARCHAR2_TABLE_100();
108: a10 := JTF_VARCHAR2_TABLE_100();
109: a11 := JTF_VARCHAR2_TABLE_100();
110: a12 := JTF_VARCHAR2_TABLE_100();
111: a13 := JTF_VARCHAR2_TABLE_100();
104: a6 := JTF_NUMBER_TABLE();
105: a7 := JTF_VARCHAR2_TABLE_100();
106: a8 := JTF_VARCHAR2_TABLE_100();
107: a9 := JTF_VARCHAR2_TABLE_100();
108: a10 := JTF_VARCHAR2_TABLE_100();
109: a11 := JTF_VARCHAR2_TABLE_100();
110: a12 := JTF_VARCHAR2_TABLE_100();
111: a13 := JTF_VARCHAR2_TABLE_100();
112: a14 := JTF_VARCHAR2_TABLE_100();
105: a7 := JTF_VARCHAR2_TABLE_100();
106: a8 := JTF_VARCHAR2_TABLE_100();
107: a9 := JTF_VARCHAR2_TABLE_100();
108: a10 := JTF_VARCHAR2_TABLE_100();
109: a11 := JTF_VARCHAR2_TABLE_100();
110: a12 := JTF_VARCHAR2_TABLE_100();
111: a13 := JTF_VARCHAR2_TABLE_100();
112: a14 := JTF_VARCHAR2_TABLE_100();
113: if t.count > 0 then
106: a8 := JTF_VARCHAR2_TABLE_100();
107: a9 := JTF_VARCHAR2_TABLE_100();
108: a10 := JTF_VARCHAR2_TABLE_100();
109: a11 := JTF_VARCHAR2_TABLE_100();
110: a12 := JTF_VARCHAR2_TABLE_100();
111: a13 := JTF_VARCHAR2_TABLE_100();
112: a14 := JTF_VARCHAR2_TABLE_100();
113: if t.count > 0 then
114: a0.extend(t.count);
107: a9 := JTF_VARCHAR2_TABLE_100();
108: a10 := JTF_VARCHAR2_TABLE_100();
109: a11 := JTF_VARCHAR2_TABLE_100();
110: a12 := JTF_VARCHAR2_TABLE_100();
111: a13 := JTF_VARCHAR2_TABLE_100();
112: a14 := JTF_VARCHAR2_TABLE_100();
113: if t.count > 0 then
114: a0.extend(t.count);
115: a1.extend(t.count);
108: a10 := JTF_VARCHAR2_TABLE_100();
109: a11 := JTF_VARCHAR2_TABLE_100();
110: a12 := JTF_VARCHAR2_TABLE_100();
111: a13 := JTF_VARCHAR2_TABLE_100();
112: a14 := JTF_VARCHAR2_TABLE_100();
113: if t.count > 0 then
114: a0.extend(t.count);
115: a1.extend(t.count);
116: a2.extend(t.count);
164: , p4_a3 in out nocopy JTF_NUMBER_TABLE
165: , p4_a4 in out nocopy JTF_DATE_TABLE
166: , p4_a5 in out nocopy JTF_NUMBER_TABLE
167: , p4_a6 in out nocopy JTF_NUMBER_TABLE
168: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
169: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
171: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
172: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
165: , p4_a4 in out nocopy JTF_DATE_TABLE
166: , p4_a5 in out nocopy JTF_NUMBER_TABLE
167: , p4_a6 in out nocopy JTF_NUMBER_TABLE
168: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
169: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
171: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
172: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
166: , p4_a5 in out nocopy JTF_NUMBER_TABLE
167: , p4_a6 in out nocopy JTF_NUMBER_TABLE
168: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
169: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
171: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
172: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
174: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
167: , p4_a6 in out nocopy JTF_NUMBER_TABLE
168: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
169: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
171: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
172: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
174: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
175: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
169: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
171: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
172: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
174: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
175: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
176: , x_return_status out nocopy VARCHAR2
169: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
171: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
172: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
174: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
175: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
176: , x_return_status out nocopy VARCHAR2
177: , x_msg_count out nocopy NUMBER
170: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
171: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
172: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
174: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
175: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
176: , x_return_status out nocopy VARCHAR2
177: , x_msg_count out nocopy NUMBER
178: , x_msg_data out nocopy VARCHAR2
171: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
172: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
174: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
175: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
176: , x_return_status out nocopy VARCHAR2
177: , x_msg_count out nocopy NUMBER
178: , x_msg_data out nocopy VARCHAR2
179: )