18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ovd_pvt.ovd_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ovd_pvt.ovd_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ovd_pvt.ovd_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_VARCHAR2_TABLE_2000
36: , a14 JTF_NUMBER_TABLE
37: ) as
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_VARCHAR2_TABLE_2000
36: , a14 JTF_NUMBER_TABLE
37: ) as
38: ddindx binary_integer; indx binary_integer;
39: begin
40: if a0 is not null and a0.count > 0 then
65: end loop;
66: end if;
67: end if;
68: end rosetta_table_copy_in_p2;
69: procedure rosetta_table_copy_out_p2(t okl_ovd_pvt.ovd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
67: end if;
68: end rosetta_table_copy_in_p2;
69: procedure rosetta_table_copy_out_p2(t okl_ovd_pvt.ovd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
68: end rosetta_table_copy_in_p2;
69: procedure rosetta_table_copy_out_p2(t okl_ovd_pvt.ovd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_VARCHAR2_TABLE_100
78: , a9 out nocopy JTF_NUMBER_TABLE
71: , a2 out nocopy JTF_NUMBER_TABLE
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_VARCHAR2_TABLE_100
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_DATE_TABLE
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_VARCHAR2_TABLE_100
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_DATE_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_VARCHAR2_TABLE_100
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_DATE_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_DATE_TABLE
82: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_VARCHAR2_TABLE_100
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_DATE_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_DATE_TABLE
82: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
83: , a14 out nocopy JTF_NUMBER_TABLE
84: ) as
79: , a10 out nocopy JTF_DATE_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_DATE_TABLE
82: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
83: , a14 out nocopy JTF_NUMBER_TABLE
84: ) as
85: ddindx binary_integer; indx binary_integer;
86: begin
87: if t is null or t.count = 0 then
84: ) as
85: ddindx binary_integer; indx binary_integer;
86: begin
87: if t is null or t.count = 0 then
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
86: begin
87: if t is null or t.count = 0 then
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
87: if t is null or t.count = 0 then
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_VARCHAR2_TABLE_100();
97: a9 := JTF_NUMBER_TABLE();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_VARCHAR2_TABLE_100();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_DATE_TABLE();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_VARCHAR2_TABLE_100();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_DATE_TABLE();
99: a11 := JTF_NUMBER_TABLE();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_VARCHAR2_TABLE_100();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_DATE_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_DATE_TABLE();
101: a13 := JTF_VARCHAR2_TABLE_2000();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_VARCHAR2_TABLE_100();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_DATE_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_DATE_TABLE();
101: a13 := JTF_VARCHAR2_TABLE_2000();
102: a14 := JTF_NUMBER_TABLE();
103: else
98: a10 := JTF_DATE_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_DATE_TABLE();
101: a13 := JTF_VARCHAR2_TABLE_2000();
102: a14 := JTF_NUMBER_TABLE();
103: else
104: a0 := JTF_NUMBER_TABLE();
105: a1 := JTF_VARCHAR2_TABLE_100();
106: a2 := JTF_NUMBER_TABLE();
100: a12 := JTF_DATE_TABLE();
101: a13 := JTF_VARCHAR2_TABLE_2000();
102: a14 := JTF_NUMBER_TABLE();
103: else
104: a0 := JTF_NUMBER_TABLE();
105: a1 := JTF_VARCHAR2_TABLE_100();
106: a2 := JTF_NUMBER_TABLE();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
102: a14 := JTF_NUMBER_TABLE();
103: else
104: a0 := JTF_NUMBER_TABLE();
105: a1 := JTF_VARCHAR2_TABLE_100();
106: a2 := JTF_NUMBER_TABLE();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
103: else
104: a0 := JTF_NUMBER_TABLE();
105: a1 := JTF_VARCHAR2_TABLE_100();
106: a2 := JTF_NUMBER_TABLE();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
105: a1 := JTF_VARCHAR2_TABLE_100();
106: a2 := JTF_NUMBER_TABLE();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_VARCHAR2_TABLE_100();
113: a9 := JTF_NUMBER_TABLE();
106: a2 := JTF_NUMBER_TABLE();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_VARCHAR2_TABLE_100();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_DATE_TABLE();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_VARCHAR2_TABLE_100();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_DATE_TABLE();
115: a11 := JTF_NUMBER_TABLE();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_VARCHAR2_TABLE_100();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_DATE_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_DATE_TABLE();
117: a13 := JTF_VARCHAR2_TABLE_2000();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_VARCHAR2_TABLE_100();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_DATE_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_DATE_TABLE();
117: a13 := JTF_VARCHAR2_TABLE_2000();
118: a14 := JTF_NUMBER_TABLE();
119: if t.count > 0 then
114: a10 := JTF_DATE_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_DATE_TABLE();
117: a13 := JTF_VARCHAR2_TABLE_2000();
118: a14 := JTF_NUMBER_TABLE();
119: if t.count > 0 then
120: a0.extend(t.count);
121: a1.extend(t.count);
122: a2.extend(t.count);
159: end if;
160: end if;
161: end rosetta_table_copy_out_p2;
162:
163: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovd_pvt.ovdv_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_VARCHAR2_TABLE_100
165: , a2 JTF_NUMBER_TABLE
166: , a3 JTF_NUMBER_TABLE
167: , a4 JTF_NUMBER_TABLE
161: end rosetta_table_copy_out_p2;
162:
163: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovd_pvt.ovdv_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_VARCHAR2_TABLE_100
165: , a2 JTF_NUMBER_TABLE
166: , a3 JTF_NUMBER_TABLE
167: , a4 JTF_NUMBER_TABLE
168: , a5 JTF_VARCHAR2_TABLE_2000
169: , a6 JTF_VARCHAR2_TABLE_100
162:
163: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovd_pvt.ovdv_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_VARCHAR2_TABLE_100
165: , a2 JTF_NUMBER_TABLE
166: , a3 JTF_NUMBER_TABLE
167: , a4 JTF_NUMBER_TABLE
168: , a5 JTF_VARCHAR2_TABLE_2000
169: , a6 JTF_VARCHAR2_TABLE_100
170: , a7 JTF_NUMBER_TABLE
163: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovd_pvt.ovdv_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_VARCHAR2_TABLE_100
165: , a2 JTF_NUMBER_TABLE
166: , a3 JTF_NUMBER_TABLE
167: , a4 JTF_NUMBER_TABLE
168: , a5 JTF_VARCHAR2_TABLE_2000
169: , a6 JTF_VARCHAR2_TABLE_100
170: , a7 JTF_NUMBER_TABLE
171: , a8 JTF_NUMBER_TABLE
166: , a3 JTF_NUMBER_TABLE
167: , a4 JTF_NUMBER_TABLE
168: , a5 JTF_VARCHAR2_TABLE_2000
169: , a6 JTF_VARCHAR2_TABLE_100
170: , a7 JTF_NUMBER_TABLE
171: , a8 JTF_NUMBER_TABLE
172: , a9 JTF_VARCHAR2_TABLE_100
173: , a10 JTF_NUMBER_TABLE
174: , a11 JTF_DATE_TABLE
167: , a4 JTF_NUMBER_TABLE
168: , a5 JTF_VARCHAR2_TABLE_2000
169: , a6 JTF_VARCHAR2_TABLE_100
170: , a7 JTF_NUMBER_TABLE
171: , a8 JTF_NUMBER_TABLE
172: , a9 JTF_VARCHAR2_TABLE_100
173: , a10 JTF_NUMBER_TABLE
174: , a11 JTF_DATE_TABLE
175: , a12 JTF_NUMBER_TABLE
169: , a6 JTF_VARCHAR2_TABLE_100
170: , a7 JTF_NUMBER_TABLE
171: , a8 JTF_NUMBER_TABLE
172: , a9 JTF_VARCHAR2_TABLE_100
173: , a10 JTF_NUMBER_TABLE
174: , a11 JTF_DATE_TABLE
175: , a12 JTF_NUMBER_TABLE
176: , a13 JTF_DATE_TABLE
177: , a14 JTF_NUMBER_TABLE
171: , a8 JTF_NUMBER_TABLE
172: , a9 JTF_VARCHAR2_TABLE_100
173: , a10 JTF_NUMBER_TABLE
174: , a11 JTF_DATE_TABLE
175: , a12 JTF_NUMBER_TABLE
176: , a13 JTF_DATE_TABLE
177: , a14 JTF_NUMBER_TABLE
178: ) as
179: ddindx binary_integer; indx binary_integer;
173: , a10 JTF_NUMBER_TABLE
174: , a11 JTF_DATE_TABLE
175: , a12 JTF_NUMBER_TABLE
176: , a13 JTF_DATE_TABLE
177: , a14 JTF_NUMBER_TABLE
178: ) as
179: ddindx binary_integer; indx binary_integer;
180: begin
181: if a0 is not null and a0.count > 0 then
206: end loop;
207: end if;
208: end if;
209: end rosetta_table_copy_in_p5;
210: procedure rosetta_table_copy_out_p5(t okl_ovd_pvt.ovdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
211: , a1 out nocopy JTF_VARCHAR2_TABLE_100
212: , a2 out nocopy JTF_NUMBER_TABLE
213: , a3 out nocopy JTF_NUMBER_TABLE
214: , a4 out nocopy JTF_NUMBER_TABLE
208: end if;
209: end rosetta_table_copy_in_p5;
210: procedure rosetta_table_copy_out_p5(t okl_ovd_pvt.ovdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
211: , a1 out nocopy JTF_VARCHAR2_TABLE_100
212: , a2 out nocopy JTF_NUMBER_TABLE
213: , a3 out nocopy JTF_NUMBER_TABLE
214: , a4 out nocopy JTF_NUMBER_TABLE
215: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
216: , a6 out nocopy JTF_VARCHAR2_TABLE_100
209: end rosetta_table_copy_in_p5;
210: procedure rosetta_table_copy_out_p5(t okl_ovd_pvt.ovdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
211: , a1 out nocopy JTF_VARCHAR2_TABLE_100
212: , a2 out nocopy JTF_NUMBER_TABLE
213: , a3 out nocopy JTF_NUMBER_TABLE
214: , a4 out nocopy JTF_NUMBER_TABLE
215: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
216: , a6 out nocopy JTF_VARCHAR2_TABLE_100
217: , a7 out nocopy JTF_NUMBER_TABLE
210: procedure rosetta_table_copy_out_p5(t okl_ovd_pvt.ovdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
211: , a1 out nocopy JTF_VARCHAR2_TABLE_100
212: , a2 out nocopy JTF_NUMBER_TABLE
213: , a3 out nocopy JTF_NUMBER_TABLE
214: , a4 out nocopy JTF_NUMBER_TABLE
215: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
216: , a6 out nocopy JTF_VARCHAR2_TABLE_100
217: , a7 out nocopy JTF_NUMBER_TABLE
218: , a8 out nocopy JTF_NUMBER_TABLE
213: , a3 out nocopy JTF_NUMBER_TABLE
214: , a4 out nocopy JTF_NUMBER_TABLE
215: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
216: , a6 out nocopy JTF_VARCHAR2_TABLE_100
217: , a7 out nocopy JTF_NUMBER_TABLE
218: , a8 out nocopy JTF_NUMBER_TABLE
219: , a9 out nocopy JTF_VARCHAR2_TABLE_100
220: , a10 out nocopy JTF_NUMBER_TABLE
221: , a11 out nocopy JTF_DATE_TABLE
214: , a4 out nocopy JTF_NUMBER_TABLE
215: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
216: , a6 out nocopy JTF_VARCHAR2_TABLE_100
217: , a7 out nocopy JTF_NUMBER_TABLE
218: , a8 out nocopy JTF_NUMBER_TABLE
219: , a9 out nocopy JTF_VARCHAR2_TABLE_100
220: , a10 out nocopy JTF_NUMBER_TABLE
221: , a11 out nocopy JTF_DATE_TABLE
222: , a12 out nocopy JTF_NUMBER_TABLE
216: , a6 out nocopy JTF_VARCHAR2_TABLE_100
217: , a7 out nocopy JTF_NUMBER_TABLE
218: , a8 out nocopy JTF_NUMBER_TABLE
219: , a9 out nocopy JTF_VARCHAR2_TABLE_100
220: , a10 out nocopy JTF_NUMBER_TABLE
221: , a11 out nocopy JTF_DATE_TABLE
222: , a12 out nocopy JTF_NUMBER_TABLE
223: , a13 out nocopy JTF_DATE_TABLE
224: , a14 out nocopy JTF_NUMBER_TABLE
218: , a8 out nocopy JTF_NUMBER_TABLE
219: , a9 out nocopy JTF_VARCHAR2_TABLE_100
220: , a10 out nocopy JTF_NUMBER_TABLE
221: , a11 out nocopy JTF_DATE_TABLE
222: , a12 out nocopy JTF_NUMBER_TABLE
223: , a13 out nocopy JTF_DATE_TABLE
224: , a14 out nocopy JTF_NUMBER_TABLE
225: ) as
226: ddindx binary_integer; indx binary_integer;
220: , a10 out nocopy JTF_NUMBER_TABLE
221: , a11 out nocopy JTF_DATE_TABLE
222: , a12 out nocopy JTF_NUMBER_TABLE
223: , a13 out nocopy JTF_DATE_TABLE
224: , a14 out nocopy JTF_NUMBER_TABLE
225: ) as
226: ddindx binary_integer; indx binary_integer;
227: begin
228: if t is null or t.count = 0 then
225: ) as
226: ddindx binary_integer; indx binary_integer;
227: begin
228: if t is null or t.count = 0 then
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_VARCHAR2_TABLE_100();
231: a2 := JTF_NUMBER_TABLE();
232: a3 := JTF_NUMBER_TABLE();
233: a4 := JTF_NUMBER_TABLE();
227: begin
228: if t is null or t.count = 0 then
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_VARCHAR2_TABLE_100();
231: a2 := JTF_NUMBER_TABLE();
232: a3 := JTF_NUMBER_TABLE();
233: a4 := JTF_NUMBER_TABLE();
234: a5 := JTF_VARCHAR2_TABLE_2000();
235: a6 := JTF_VARCHAR2_TABLE_100();
228: if t is null or t.count = 0 then
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_VARCHAR2_TABLE_100();
231: a2 := JTF_NUMBER_TABLE();
232: a3 := JTF_NUMBER_TABLE();
233: a4 := JTF_NUMBER_TABLE();
234: a5 := JTF_VARCHAR2_TABLE_2000();
235: a6 := JTF_VARCHAR2_TABLE_100();
236: a7 := JTF_NUMBER_TABLE();
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_VARCHAR2_TABLE_100();
231: a2 := JTF_NUMBER_TABLE();
232: a3 := JTF_NUMBER_TABLE();
233: a4 := JTF_NUMBER_TABLE();
234: a5 := JTF_VARCHAR2_TABLE_2000();
235: a6 := JTF_VARCHAR2_TABLE_100();
236: a7 := JTF_NUMBER_TABLE();
237: a8 := JTF_NUMBER_TABLE();
232: a3 := JTF_NUMBER_TABLE();
233: a4 := JTF_NUMBER_TABLE();
234: a5 := JTF_VARCHAR2_TABLE_2000();
235: a6 := JTF_VARCHAR2_TABLE_100();
236: a7 := JTF_NUMBER_TABLE();
237: a8 := JTF_NUMBER_TABLE();
238: a9 := JTF_VARCHAR2_TABLE_100();
239: a10 := JTF_NUMBER_TABLE();
240: a11 := JTF_DATE_TABLE();
233: a4 := JTF_NUMBER_TABLE();
234: a5 := JTF_VARCHAR2_TABLE_2000();
235: a6 := JTF_VARCHAR2_TABLE_100();
236: a7 := JTF_NUMBER_TABLE();
237: a8 := JTF_NUMBER_TABLE();
238: a9 := JTF_VARCHAR2_TABLE_100();
239: a10 := JTF_NUMBER_TABLE();
240: a11 := JTF_DATE_TABLE();
241: a12 := JTF_NUMBER_TABLE();
235: a6 := JTF_VARCHAR2_TABLE_100();
236: a7 := JTF_NUMBER_TABLE();
237: a8 := JTF_NUMBER_TABLE();
238: a9 := JTF_VARCHAR2_TABLE_100();
239: a10 := JTF_NUMBER_TABLE();
240: a11 := JTF_DATE_TABLE();
241: a12 := JTF_NUMBER_TABLE();
242: a13 := JTF_DATE_TABLE();
243: a14 := JTF_NUMBER_TABLE();
237: a8 := JTF_NUMBER_TABLE();
238: a9 := JTF_VARCHAR2_TABLE_100();
239: a10 := JTF_NUMBER_TABLE();
240: a11 := JTF_DATE_TABLE();
241: a12 := JTF_NUMBER_TABLE();
242: a13 := JTF_DATE_TABLE();
243: a14 := JTF_NUMBER_TABLE();
244: else
245: a0 := JTF_NUMBER_TABLE();
239: a10 := JTF_NUMBER_TABLE();
240: a11 := JTF_DATE_TABLE();
241: a12 := JTF_NUMBER_TABLE();
242: a13 := JTF_DATE_TABLE();
243: a14 := JTF_NUMBER_TABLE();
244: else
245: a0 := JTF_NUMBER_TABLE();
246: a1 := JTF_VARCHAR2_TABLE_100();
247: a2 := JTF_NUMBER_TABLE();
241: a12 := JTF_NUMBER_TABLE();
242: a13 := JTF_DATE_TABLE();
243: a14 := JTF_NUMBER_TABLE();
244: else
245: a0 := JTF_NUMBER_TABLE();
246: a1 := JTF_VARCHAR2_TABLE_100();
247: a2 := JTF_NUMBER_TABLE();
248: a3 := JTF_NUMBER_TABLE();
249: a4 := JTF_NUMBER_TABLE();
243: a14 := JTF_NUMBER_TABLE();
244: else
245: a0 := JTF_NUMBER_TABLE();
246: a1 := JTF_VARCHAR2_TABLE_100();
247: a2 := JTF_NUMBER_TABLE();
248: a3 := JTF_NUMBER_TABLE();
249: a4 := JTF_NUMBER_TABLE();
250: a5 := JTF_VARCHAR2_TABLE_2000();
251: a6 := JTF_VARCHAR2_TABLE_100();
244: else
245: a0 := JTF_NUMBER_TABLE();
246: a1 := JTF_VARCHAR2_TABLE_100();
247: a2 := JTF_NUMBER_TABLE();
248: a3 := JTF_NUMBER_TABLE();
249: a4 := JTF_NUMBER_TABLE();
250: a5 := JTF_VARCHAR2_TABLE_2000();
251: a6 := JTF_VARCHAR2_TABLE_100();
252: a7 := JTF_NUMBER_TABLE();
245: a0 := JTF_NUMBER_TABLE();
246: a1 := JTF_VARCHAR2_TABLE_100();
247: a2 := JTF_NUMBER_TABLE();
248: a3 := JTF_NUMBER_TABLE();
249: a4 := JTF_NUMBER_TABLE();
250: a5 := JTF_VARCHAR2_TABLE_2000();
251: a6 := JTF_VARCHAR2_TABLE_100();
252: a7 := JTF_NUMBER_TABLE();
253: a8 := JTF_NUMBER_TABLE();
248: a3 := JTF_NUMBER_TABLE();
249: a4 := JTF_NUMBER_TABLE();
250: a5 := JTF_VARCHAR2_TABLE_2000();
251: a6 := JTF_VARCHAR2_TABLE_100();
252: a7 := JTF_NUMBER_TABLE();
253: a8 := JTF_NUMBER_TABLE();
254: a9 := JTF_VARCHAR2_TABLE_100();
255: a10 := JTF_NUMBER_TABLE();
256: a11 := JTF_DATE_TABLE();
249: a4 := JTF_NUMBER_TABLE();
250: a5 := JTF_VARCHAR2_TABLE_2000();
251: a6 := JTF_VARCHAR2_TABLE_100();
252: a7 := JTF_NUMBER_TABLE();
253: a8 := JTF_NUMBER_TABLE();
254: a9 := JTF_VARCHAR2_TABLE_100();
255: a10 := JTF_NUMBER_TABLE();
256: a11 := JTF_DATE_TABLE();
257: a12 := JTF_NUMBER_TABLE();
251: a6 := JTF_VARCHAR2_TABLE_100();
252: a7 := JTF_NUMBER_TABLE();
253: a8 := JTF_NUMBER_TABLE();
254: a9 := JTF_VARCHAR2_TABLE_100();
255: a10 := JTF_NUMBER_TABLE();
256: a11 := JTF_DATE_TABLE();
257: a12 := JTF_NUMBER_TABLE();
258: a13 := JTF_DATE_TABLE();
259: a14 := JTF_NUMBER_TABLE();
253: a8 := JTF_NUMBER_TABLE();
254: a9 := JTF_VARCHAR2_TABLE_100();
255: a10 := JTF_NUMBER_TABLE();
256: a11 := JTF_DATE_TABLE();
257: a12 := JTF_NUMBER_TABLE();
258: a13 := JTF_DATE_TABLE();
259: a14 := JTF_NUMBER_TABLE();
260: if t.count > 0 then
261: a0.extend(t.count);
255: a10 := JTF_NUMBER_TABLE();
256: a11 := JTF_DATE_TABLE();
257: a12 := JTF_NUMBER_TABLE();
258: a13 := JTF_DATE_TABLE();
259: a14 := JTF_NUMBER_TABLE();
260: if t.count > 0 then
261: a0.extend(t.count);
262: a1.extend(t.count);
263: a2.extend(t.count);
404: , p_init_msg_list VARCHAR2
405: , x_return_status out nocopy VARCHAR2
406: , x_msg_count out nocopy NUMBER
407: , x_msg_data out nocopy VARCHAR2
408: , p5_a0 JTF_NUMBER_TABLE
409: , p5_a1 JTF_VARCHAR2_TABLE_100
410: , p5_a2 JTF_NUMBER_TABLE
411: , p5_a3 JTF_NUMBER_TABLE
412: , p5_a4 JTF_NUMBER_TABLE
406: , x_msg_count out nocopy NUMBER
407: , x_msg_data out nocopy VARCHAR2
408: , p5_a0 JTF_NUMBER_TABLE
409: , p5_a1 JTF_VARCHAR2_TABLE_100
410: , p5_a2 JTF_NUMBER_TABLE
411: , p5_a3 JTF_NUMBER_TABLE
412: , p5_a4 JTF_NUMBER_TABLE
413: , p5_a5 JTF_VARCHAR2_TABLE_2000
414: , p5_a6 JTF_VARCHAR2_TABLE_100
407: , x_msg_data out nocopy VARCHAR2
408: , p5_a0 JTF_NUMBER_TABLE
409: , p5_a1 JTF_VARCHAR2_TABLE_100
410: , p5_a2 JTF_NUMBER_TABLE
411: , p5_a3 JTF_NUMBER_TABLE
412: , p5_a4 JTF_NUMBER_TABLE
413: , p5_a5 JTF_VARCHAR2_TABLE_2000
414: , p5_a6 JTF_VARCHAR2_TABLE_100
415: , p5_a7 JTF_NUMBER_TABLE
408: , p5_a0 JTF_NUMBER_TABLE
409: , p5_a1 JTF_VARCHAR2_TABLE_100
410: , p5_a2 JTF_NUMBER_TABLE
411: , p5_a3 JTF_NUMBER_TABLE
412: , p5_a4 JTF_NUMBER_TABLE
413: , p5_a5 JTF_VARCHAR2_TABLE_2000
414: , p5_a6 JTF_VARCHAR2_TABLE_100
415: , p5_a7 JTF_NUMBER_TABLE
416: , p5_a8 JTF_NUMBER_TABLE
411: , p5_a3 JTF_NUMBER_TABLE
412: , p5_a4 JTF_NUMBER_TABLE
413: , p5_a5 JTF_VARCHAR2_TABLE_2000
414: , p5_a6 JTF_VARCHAR2_TABLE_100
415: , p5_a7 JTF_NUMBER_TABLE
416: , p5_a8 JTF_NUMBER_TABLE
417: , p5_a9 JTF_VARCHAR2_TABLE_100
418: , p5_a10 JTF_NUMBER_TABLE
419: , p5_a11 JTF_DATE_TABLE
412: , p5_a4 JTF_NUMBER_TABLE
413: , p5_a5 JTF_VARCHAR2_TABLE_2000
414: , p5_a6 JTF_VARCHAR2_TABLE_100
415: , p5_a7 JTF_NUMBER_TABLE
416: , p5_a8 JTF_NUMBER_TABLE
417: , p5_a9 JTF_VARCHAR2_TABLE_100
418: , p5_a10 JTF_NUMBER_TABLE
419: , p5_a11 JTF_DATE_TABLE
420: , p5_a12 JTF_NUMBER_TABLE
414: , p5_a6 JTF_VARCHAR2_TABLE_100
415: , p5_a7 JTF_NUMBER_TABLE
416: , p5_a8 JTF_NUMBER_TABLE
417: , p5_a9 JTF_VARCHAR2_TABLE_100
418: , p5_a10 JTF_NUMBER_TABLE
419: , p5_a11 JTF_DATE_TABLE
420: , p5_a12 JTF_NUMBER_TABLE
421: , p5_a13 JTF_DATE_TABLE
422: , p5_a14 JTF_NUMBER_TABLE
416: , p5_a8 JTF_NUMBER_TABLE
417: , p5_a9 JTF_VARCHAR2_TABLE_100
418: , p5_a10 JTF_NUMBER_TABLE
419: , p5_a11 JTF_DATE_TABLE
420: , p5_a12 JTF_NUMBER_TABLE
421: , p5_a13 JTF_DATE_TABLE
422: , p5_a14 JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
418: , p5_a10 JTF_NUMBER_TABLE
419: , p5_a11 JTF_DATE_TABLE
420: , p5_a12 JTF_NUMBER_TABLE
421: , p5_a13 JTF_DATE_TABLE
422: , p5_a14 JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a2 out nocopy JTF_NUMBER_TABLE
426: , p6_a3 out nocopy JTF_NUMBER_TABLE
419: , p5_a11 JTF_DATE_TABLE
420: , p5_a12 JTF_NUMBER_TABLE
421: , p5_a13 JTF_DATE_TABLE
422: , p5_a14 JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a2 out nocopy JTF_NUMBER_TABLE
426: , p6_a3 out nocopy JTF_NUMBER_TABLE
427: , p6_a4 out nocopy JTF_NUMBER_TABLE
421: , p5_a13 JTF_DATE_TABLE
422: , p5_a14 JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a2 out nocopy JTF_NUMBER_TABLE
426: , p6_a3 out nocopy JTF_NUMBER_TABLE
427: , p6_a4 out nocopy JTF_NUMBER_TABLE
428: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
429: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
422: , p5_a14 JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a2 out nocopy JTF_NUMBER_TABLE
426: , p6_a3 out nocopy JTF_NUMBER_TABLE
427: , p6_a4 out nocopy JTF_NUMBER_TABLE
428: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
429: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a7 out nocopy JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a2 out nocopy JTF_NUMBER_TABLE
426: , p6_a3 out nocopy JTF_NUMBER_TABLE
427: , p6_a4 out nocopy JTF_NUMBER_TABLE
428: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
429: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a7 out nocopy JTF_NUMBER_TABLE
431: , p6_a8 out nocopy JTF_NUMBER_TABLE
426: , p6_a3 out nocopy JTF_NUMBER_TABLE
427: , p6_a4 out nocopy JTF_NUMBER_TABLE
428: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
429: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a7 out nocopy JTF_NUMBER_TABLE
431: , p6_a8 out nocopy JTF_NUMBER_TABLE
432: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
433: , p6_a10 out nocopy JTF_NUMBER_TABLE
434: , p6_a11 out nocopy JTF_DATE_TABLE
427: , p6_a4 out nocopy JTF_NUMBER_TABLE
428: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
429: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a7 out nocopy JTF_NUMBER_TABLE
431: , p6_a8 out nocopy JTF_NUMBER_TABLE
432: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
433: , p6_a10 out nocopy JTF_NUMBER_TABLE
434: , p6_a11 out nocopy JTF_DATE_TABLE
435: , p6_a12 out nocopy JTF_NUMBER_TABLE
429: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a7 out nocopy JTF_NUMBER_TABLE
431: , p6_a8 out nocopy JTF_NUMBER_TABLE
432: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
433: , p6_a10 out nocopy JTF_NUMBER_TABLE
434: , p6_a11 out nocopy JTF_DATE_TABLE
435: , p6_a12 out nocopy JTF_NUMBER_TABLE
436: , p6_a13 out nocopy JTF_DATE_TABLE
437: , p6_a14 out nocopy JTF_NUMBER_TABLE
431: , p6_a8 out nocopy JTF_NUMBER_TABLE
432: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
433: , p6_a10 out nocopy JTF_NUMBER_TABLE
434: , p6_a11 out nocopy JTF_DATE_TABLE
435: , p6_a12 out nocopy JTF_NUMBER_TABLE
436: , p6_a13 out nocopy JTF_DATE_TABLE
437: , p6_a14 out nocopy JTF_NUMBER_TABLE
438: )
439:
433: , p6_a10 out nocopy JTF_NUMBER_TABLE
434: , p6_a11 out nocopy JTF_DATE_TABLE
435: , p6_a12 out nocopy JTF_NUMBER_TABLE
436: , p6_a13 out nocopy JTF_DATE_TABLE
437: , p6_a14 out nocopy JTF_NUMBER_TABLE
438: )
439:
440: as
441: ddp_ovdv_tbl okl_ovd_pvt.ovdv_tbl_type;
570: , p_init_msg_list VARCHAR2
571: , x_return_status out nocopy VARCHAR2
572: , x_msg_count out nocopy NUMBER
573: , x_msg_data out nocopy VARCHAR2
574: , p5_a0 JTF_NUMBER_TABLE
575: , p5_a1 JTF_VARCHAR2_TABLE_100
576: , p5_a2 JTF_NUMBER_TABLE
577: , p5_a3 JTF_NUMBER_TABLE
578: , p5_a4 JTF_NUMBER_TABLE
572: , x_msg_count out nocopy NUMBER
573: , x_msg_data out nocopy VARCHAR2
574: , p5_a0 JTF_NUMBER_TABLE
575: , p5_a1 JTF_VARCHAR2_TABLE_100
576: , p5_a2 JTF_NUMBER_TABLE
577: , p5_a3 JTF_NUMBER_TABLE
578: , p5_a4 JTF_NUMBER_TABLE
579: , p5_a5 JTF_VARCHAR2_TABLE_2000
580: , p5_a6 JTF_VARCHAR2_TABLE_100
573: , x_msg_data out nocopy VARCHAR2
574: , p5_a0 JTF_NUMBER_TABLE
575: , p5_a1 JTF_VARCHAR2_TABLE_100
576: , p5_a2 JTF_NUMBER_TABLE
577: , p5_a3 JTF_NUMBER_TABLE
578: , p5_a4 JTF_NUMBER_TABLE
579: , p5_a5 JTF_VARCHAR2_TABLE_2000
580: , p5_a6 JTF_VARCHAR2_TABLE_100
581: , p5_a7 JTF_NUMBER_TABLE
574: , p5_a0 JTF_NUMBER_TABLE
575: , p5_a1 JTF_VARCHAR2_TABLE_100
576: , p5_a2 JTF_NUMBER_TABLE
577: , p5_a3 JTF_NUMBER_TABLE
578: , p5_a4 JTF_NUMBER_TABLE
579: , p5_a5 JTF_VARCHAR2_TABLE_2000
580: , p5_a6 JTF_VARCHAR2_TABLE_100
581: , p5_a7 JTF_NUMBER_TABLE
582: , p5_a8 JTF_NUMBER_TABLE
577: , p5_a3 JTF_NUMBER_TABLE
578: , p5_a4 JTF_NUMBER_TABLE
579: , p5_a5 JTF_VARCHAR2_TABLE_2000
580: , p5_a6 JTF_VARCHAR2_TABLE_100
581: , p5_a7 JTF_NUMBER_TABLE
582: , p5_a8 JTF_NUMBER_TABLE
583: , p5_a9 JTF_VARCHAR2_TABLE_100
584: , p5_a10 JTF_NUMBER_TABLE
585: , p5_a11 JTF_DATE_TABLE
578: , p5_a4 JTF_NUMBER_TABLE
579: , p5_a5 JTF_VARCHAR2_TABLE_2000
580: , p5_a6 JTF_VARCHAR2_TABLE_100
581: , p5_a7 JTF_NUMBER_TABLE
582: , p5_a8 JTF_NUMBER_TABLE
583: , p5_a9 JTF_VARCHAR2_TABLE_100
584: , p5_a10 JTF_NUMBER_TABLE
585: , p5_a11 JTF_DATE_TABLE
586: , p5_a12 JTF_NUMBER_TABLE
580: , p5_a6 JTF_VARCHAR2_TABLE_100
581: , p5_a7 JTF_NUMBER_TABLE
582: , p5_a8 JTF_NUMBER_TABLE
583: , p5_a9 JTF_VARCHAR2_TABLE_100
584: , p5_a10 JTF_NUMBER_TABLE
585: , p5_a11 JTF_DATE_TABLE
586: , p5_a12 JTF_NUMBER_TABLE
587: , p5_a13 JTF_DATE_TABLE
588: , p5_a14 JTF_NUMBER_TABLE
582: , p5_a8 JTF_NUMBER_TABLE
583: , p5_a9 JTF_VARCHAR2_TABLE_100
584: , p5_a10 JTF_NUMBER_TABLE
585: , p5_a11 JTF_DATE_TABLE
586: , p5_a12 JTF_NUMBER_TABLE
587: , p5_a13 JTF_DATE_TABLE
588: , p5_a14 JTF_NUMBER_TABLE
589: )
590:
584: , p5_a10 JTF_NUMBER_TABLE
585: , p5_a11 JTF_DATE_TABLE
586: , p5_a12 JTF_NUMBER_TABLE
587: , p5_a13 JTF_DATE_TABLE
588: , p5_a14 JTF_NUMBER_TABLE
589: )
590:
591: as
592: ddp_ovdv_tbl okl_ovd_pvt.ovdv_tbl_type;
735: , p_init_msg_list VARCHAR2
736: , x_return_status out nocopy VARCHAR2
737: , x_msg_count out nocopy NUMBER
738: , x_msg_data out nocopy VARCHAR2
739: , p5_a0 JTF_NUMBER_TABLE
740: , p5_a1 JTF_VARCHAR2_TABLE_100
741: , p5_a2 JTF_NUMBER_TABLE
742: , p5_a3 JTF_NUMBER_TABLE
743: , p5_a4 JTF_NUMBER_TABLE
737: , x_msg_count out nocopy NUMBER
738: , x_msg_data out nocopy VARCHAR2
739: , p5_a0 JTF_NUMBER_TABLE
740: , p5_a1 JTF_VARCHAR2_TABLE_100
741: , p5_a2 JTF_NUMBER_TABLE
742: , p5_a3 JTF_NUMBER_TABLE
743: , p5_a4 JTF_NUMBER_TABLE
744: , p5_a5 JTF_VARCHAR2_TABLE_2000
745: , p5_a6 JTF_VARCHAR2_TABLE_100
738: , x_msg_data out nocopy VARCHAR2
739: , p5_a0 JTF_NUMBER_TABLE
740: , p5_a1 JTF_VARCHAR2_TABLE_100
741: , p5_a2 JTF_NUMBER_TABLE
742: , p5_a3 JTF_NUMBER_TABLE
743: , p5_a4 JTF_NUMBER_TABLE
744: , p5_a5 JTF_VARCHAR2_TABLE_2000
745: , p5_a6 JTF_VARCHAR2_TABLE_100
746: , p5_a7 JTF_NUMBER_TABLE
739: , p5_a0 JTF_NUMBER_TABLE
740: , p5_a1 JTF_VARCHAR2_TABLE_100
741: , p5_a2 JTF_NUMBER_TABLE
742: , p5_a3 JTF_NUMBER_TABLE
743: , p5_a4 JTF_NUMBER_TABLE
744: , p5_a5 JTF_VARCHAR2_TABLE_2000
745: , p5_a6 JTF_VARCHAR2_TABLE_100
746: , p5_a7 JTF_NUMBER_TABLE
747: , p5_a8 JTF_NUMBER_TABLE
742: , p5_a3 JTF_NUMBER_TABLE
743: , p5_a4 JTF_NUMBER_TABLE
744: , p5_a5 JTF_VARCHAR2_TABLE_2000
745: , p5_a6 JTF_VARCHAR2_TABLE_100
746: , p5_a7 JTF_NUMBER_TABLE
747: , p5_a8 JTF_NUMBER_TABLE
748: , p5_a9 JTF_VARCHAR2_TABLE_100
749: , p5_a10 JTF_NUMBER_TABLE
750: , p5_a11 JTF_DATE_TABLE
743: , p5_a4 JTF_NUMBER_TABLE
744: , p5_a5 JTF_VARCHAR2_TABLE_2000
745: , p5_a6 JTF_VARCHAR2_TABLE_100
746: , p5_a7 JTF_NUMBER_TABLE
747: , p5_a8 JTF_NUMBER_TABLE
748: , p5_a9 JTF_VARCHAR2_TABLE_100
749: , p5_a10 JTF_NUMBER_TABLE
750: , p5_a11 JTF_DATE_TABLE
751: , p5_a12 JTF_NUMBER_TABLE
745: , p5_a6 JTF_VARCHAR2_TABLE_100
746: , p5_a7 JTF_NUMBER_TABLE
747: , p5_a8 JTF_NUMBER_TABLE
748: , p5_a9 JTF_VARCHAR2_TABLE_100
749: , p5_a10 JTF_NUMBER_TABLE
750: , p5_a11 JTF_DATE_TABLE
751: , p5_a12 JTF_NUMBER_TABLE
752: , p5_a13 JTF_DATE_TABLE
753: , p5_a14 JTF_NUMBER_TABLE
747: , p5_a8 JTF_NUMBER_TABLE
748: , p5_a9 JTF_VARCHAR2_TABLE_100
749: , p5_a10 JTF_NUMBER_TABLE
750: , p5_a11 JTF_DATE_TABLE
751: , p5_a12 JTF_NUMBER_TABLE
752: , p5_a13 JTF_DATE_TABLE
753: , p5_a14 JTF_NUMBER_TABLE
754: , p6_a0 out nocopy JTF_NUMBER_TABLE
755: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
749: , p5_a10 JTF_NUMBER_TABLE
750: , p5_a11 JTF_DATE_TABLE
751: , p5_a12 JTF_NUMBER_TABLE
752: , p5_a13 JTF_DATE_TABLE
753: , p5_a14 JTF_NUMBER_TABLE
754: , p6_a0 out nocopy JTF_NUMBER_TABLE
755: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a2 out nocopy JTF_NUMBER_TABLE
757: , p6_a3 out nocopy JTF_NUMBER_TABLE
750: , p5_a11 JTF_DATE_TABLE
751: , p5_a12 JTF_NUMBER_TABLE
752: , p5_a13 JTF_DATE_TABLE
753: , p5_a14 JTF_NUMBER_TABLE
754: , p6_a0 out nocopy JTF_NUMBER_TABLE
755: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a2 out nocopy JTF_NUMBER_TABLE
757: , p6_a3 out nocopy JTF_NUMBER_TABLE
758: , p6_a4 out nocopy JTF_NUMBER_TABLE
752: , p5_a13 JTF_DATE_TABLE
753: , p5_a14 JTF_NUMBER_TABLE
754: , p6_a0 out nocopy JTF_NUMBER_TABLE
755: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a2 out nocopy JTF_NUMBER_TABLE
757: , p6_a3 out nocopy JTF_NUMBER_TABLE
758: , p6_a4 out nocopy JTF_NUMBER_TABLE
759: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
760: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
753: , p5_a14 JTF_NUMBER_TABLE
754: , p6_a0 out nocopy JTF_NUMBER_TABLE
755: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a2 out nocopy JTF_NUMBER_TABLE
757: , p6_a3 out nocopy JTF_NUMBER_TABLE
758: , p6_a4 out nocopy JTF_NUMBER_TABLE
759: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
760: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
761: , p6_a7 out nocopy JTF_NUMBER_TABLE
754: , p6_a0 out nocopy JTF_NUMBER_TABLE
755: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a2 out nocopy JTF_NUMBER_TABLE
757: , p6_a3 out nocopy JTF_NUMBER_TABLE
758: , p6_a4 out nocopy JTF_NUMBER_TABLE
759: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
760: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
761: , p6_a7 out nocopy JTF_NUMBER_TABLE
762: , p6_a8 out nocopy JTF_NUMBER_TABLE
757: , p6_a3 out nocopy JTF_NUMBER_TABLE
758: , p6_a4 out nocopy JTF_NUMBER_TABLE
759: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
760: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
761: , p6_a7 out nocopy JTF_NUMBER_TABLE
762: , p6_a8 out nocopy JTF_NUMBER_TABLE
763: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
764: , p6_a10 out nocopy JTF_NUMBER_TABLE
765: , p6_a11 out nocopy JTF_DATE_TABLE
758: , p6_a4 out nocopy JTF_NUMBER_TABLE
759: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
760: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
761: , p6_a7 out nocopy JTF_NUMBER_TABLE
762: , p6_a8 out nocopy JTF_NUMBER_TABLE
763: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
764: , p6_a10 out nocopy JTF_NUMBER_TABLE
765: , p6_a11 out nocopy JTF_DATE_TABLE
766: , p6_a12 out nocopy JTF_NUMBER_TABLE
760: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
761: , p6_a7 out nocopy JTF_NUMBER_TABLE
762: , p6_a8 out nocopy JTF_NUMBER_TABLE
763: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
764: , p6_a10 out nocopy JTF_NUMBER_TABLE
765: , p6_a11 out nocopy JTF_DATE_TABLE
766: , p6_a12 out nocopy JTF_NUMBER_TABLE
767: , p6_a13 out nocopy JTF_DATE_TABLE
768: , p6_a14 out nocopy JTF_NUMBER_TABLE
762: , p6_a8 out nocopy JTF_NUMBER_TABLE
763: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
764: , p6_a10 out nocopy JTF_NUMBER_TABLE
765: , p6_a11 out nocopy JTF_DATE_TABLE
766: , p6_a12 out nocopy JTF_NUMBER_TABLE
767: , p6_a13 out nocopy JTF_DATE_TABLE
768: , p6_a14 out nocopy JTF_NUMBER_TABLE
769: )
770:
764: , p6_a10 out nocopy JTF_NUMBER_TABLE
765: , p6_a11 out nocopy JTF_DATE_TABLE
766: , p6_a12 out nocopy JTF_NUMBER_TABLE
767: , p6_a13 out nocopy JTF_DATE_TABLE
768: , p6_a14 out nocopy JTF_NUMBER_TABLE
769: )
770:
771: as
772: ddp_ovdv_tbl okl_ovd_pvt.ovdv_tbl_type;
901: , p_init_msg_list VARCHAR2
902: , x_return_status out nocopy VARCHAR2
903: , x_msg_count out nocopy NUMBER
904: , x_msg_data out nocopy VARCHAR2
905: , p5_a0 JTF_NUMBER_TABLE
906: , p5_a1 JTF_VARCHAR2_TABLE_100
907: , p5_a2 JTF_NUMBER_TABLE
908: , p5_a3 JTF_NUMBER_TABLE
909: , p5_a4 JTF_NUMBER_TABLE
903: , x_msg_count out nocopy NUMBER
904: , x_msg_data out nocopy VARCHAR2
905: , p5_a0 JTF_NUMBER_TABLE
906: , p5_a1 JTF_VARCHAR2_TABLE_100
907: , p5_a2 JTF_NUMBER_TABLE
908: , p5_a3 JTF_NUMBER_TABLE
909: , p5_a4 JTF_NUMBER_TABLE
910: , p5_a5 JTF_VARCHAR2_TABLE_2000
911: , p5_a6 JTF_VARCHAR2_TABLE_100
904: , x_msg_data out nocopy VARCHAR2
905: , p5_a0 JTF_NUMBER_TABLE
906: , p5_a1 JTF_VARCHAR2_TABLE_100
907: , p5_a2 JTF_NUMBER_TABLE
908: , p5_a3 JTF_NUMBER_TABLE
909: , p5_a4 JTF_NUMBER_TABLE
910: , p5_a5 JTF_VARCHAR2_TABLE_2000
911: , p5_a6 JTF_VARCHAR2_TABLE_100
912: , p5_a7 JTF_NUMBER_TABLE
905: , p5_a0 JTF_NUMBER_TABLE
906: , p5_a1 JTF_VARCHAR2_TABLE_100
907: , p5_a2 JTF_NUMBER_TABLE
908: , p5_a3 JTF_NUMBER_TABLE
909: , p5_a4 JTF_NUMBER_TABLE
910: , p5_a5 JTF_VARCHAR2_TABLE_2000
911: , p5_a6 JTF_VARCHAR2_TABLE_100
912: , p5_a7 JTF_NUMBER_TABLE
913: , p5_a8 JTF_NUMBER_TABLE
908: , p5_a3 JTF_NUMBER_TABLE
909: , p5_a4 JTF_NUMBER_TABLE
910: , p5_a5 JTF_VARCHAR2_TABLE_2000
911: , p5_a6 JTF_VARCHAR2_TABLE_100
912: , p5_a7 JTF_NUMBER_TABLE
913: , p5_a8 JTF_NUMBER_TABLE
914: , p5_a9 JTF_VARCHAR2_TABLE_100
915: , p5_a10 JTF_NUMBER_TABLE
916: , p5_a11 JTF_DATE_TABLE
909: , p5_a4 JTF_NUMBER_TABLE
910: , p5_a5 JTF_VARCHAR2_TABLE_2000
911: , p5_a6 JTF_VARCHAR2_TABLE_100
912: , p5_a7 JTF_NUMBER_TABLE
913: , p5_a8 JTF_NUMBER_TABLE
914: , p5_a9 JTF_VARCHAR2_TABLE_100
915: , p5_a10 JTF_NUMBER_TABLE
916: , p5_a11 JTF_DATE_TABLE
917: , p5_a12 JTF_NUMBER_TABLE
911: , p5_a6 JTF_VARCHAR2_TABLE_100
912: , p5_a7 JTF_NUMBER_TABLE
913: , p5_a8 JTF_NUMBER_TABLE
914: , p5_a9 JTF_VARCHAR2_TABLE_100
915: , p5_a10 JTF_NUMBER_TABLE
916: , p5_a11 JTF_DATE_TABLE
917: , p5_a12 JTF_NUMBER_TABLE
918: , p5_a13 JTF_DATE_TABLE
919: , p5_a14 JTF_NUMBER_TABLE
913: , p5_a8 JTF_NUMBER_TABLE
914: , p5_a9 JTF_VARCHAR2_TABLE_100
915: , p5_a10 JTF_NUMBER_TABLE
916: , p5_a11 JTF_DATE_TABLE
917: , p5_a12 JTF_NUMBER_TABLE
918: , p5_a13 JTF_DATE_TABLE
919: , p5_a14 JTF_NUMBER_TABLE
920: )
921:
915: , p5_a10 JTF_NUMBER_TABLE
916: , p5_a11 JTF_DATE_TABLE
917: , p5_a12 JTF_NUMBER_TABLE
918: , p5_a13 JTF_DATE_TABLE
919: , p5_a14 JTF_NUMBER_TABLE
920: )
921:
922: as
923: ddp_ovdv_tbl okl_ovd_pvt.ovdv_tbl_type;
1032: , p_init_msg_list VARCHAR2
1033: , x_return_status out nocopy VARCHAR2
1034: , x_msg_count out nocopy NUMBER
1035: , x_msg_data out nocopy VARCHAR2
1036: , p5_a0 JTF_NUMBER_TABLE
1037: , p5_a1 JTF_VARCHAR2_TABLE_100
1038: , p5_a2 JTF_NUMBER_TABLE
1039: , p5_a3 JTF_NUMBER_TABLE
1040: , p5_a4 JTF_NUMBER_TABLE
1034: , x_msg_count out nocopy NUMBER
1035: , x_msg_data out nocopy VARCHAR2
1036: , p5_a0 JTF_NUMBER_TABLE
1037: , p5_a1 JTF_VARCHAR2_TABLE_100
1038: , p5_a2 JTF_NUMBER_TABLE
1039: , p5_a3 JTF_NUMBER_TABLE
1040: , p5_a4 JTF_NUMBER_TABLE
1041: , p5_a5 JTF_VARCHAR2_TABLE_2000
1042: , p5_a6 JTF_VARCHAR2_TABLE_100
1035: , x_msg_data out nocopy VARCHAR2
1036: , p5_a0 JTF_NUMBER_TABLE
1037: , p5_a1 JTF_VARCHAR2_TABLE_100
1038: , p5_a2 JTF_NUMBER_TABLE
1039: , p5_a3 JTF_NUMBER_TABLE
1040: , p5_a4 JTF_NUMBER_TABLE
1041: , p5_a5 JTF_VARCHAR2_TABLE_2000
1042: , p5_a6 JTF_VARCHAR2_TABLE_100
1043: , p5_a7 JTF_NUMBER_TABLE
1036: , p5_a0 JTF_NUMBER_TABLE
1037: , p5_a1 JTF_VARCHAR2_TABLE_100
1038: , p5_a2 JTF_NUMBER_TABLE
1039: , p5_a3 JTF_NUMBER_TABLE
1040: , p5_a4 JTF_NUMBER_TABLE
1041: , p5_a5 JTF_VARCHAR2_TABLE_2000
1042: , p5_a6 JTF_VARCHAR2_TABLE_100
1043: , p5_a7 JTF_NUMBER_TABLE
1044: , p5_a8 JTF_NUMBER_TABLE
1039: , p5_a3 JTF_NUMBER_TABLE
1040: , p5_a4 JTF_NUMBER_TABLE
1041: , p5_a5 JTF_VARCHAR2_TABLE_2000
1042: , p5_a6 JTF_VARCHAR2_TABLE_100
1043: , p5_a7 JTF_NUMBER_TABLE
1044: , p5_a8 JTF_NUMBER_TABLE
1045: , p5_a9 JTF_VARCHAR2_TABLE_100
1046: , p5_a10 JTF_NUMBER_TABLE
1047: , p5_a11 JTF_DATE_TABLE
1040: , p5_a4 JTF_NUMBER_TABLE
1041: , p5_a5 JTF_VARCHAR2_TABLE_2000
1042: , p5_a6 JTF_VARCHAR2_TABLE_100
1043: , p5_a7 JTF_NUMBER_TABLE
1044: , p5_a8 JTF_NUMBER_TABLE
1045: , p5_a9 JTF_VARCHAR2_TABLE_100
1046: , p5_a10 JTF_NUMBER_TABLE
1047: , p5_a11 JTF_DATE_TABLE
1048: , p5_a12 JTF_NUMBER_TABLE
1042: , p5_a6 JTF_VARCHAR2_TABLE_100
1043: , p5_a7 JTF_NUMBER_TABLE
1044: , p5_a8 JTF_NUMBER_TABLE
1045: , p5_a9 JTF_VARCHAR2_TABLE_100
1046: , p5_a10 JTF_NUMBER_TABLE
1047: , p5_a11 JTF_DATE_TABLE
1048: , p5_a12 JTF_NUMBER_TABLE
1049: , p5_a13 JTF_DATE_TABLE
1050: , p5_a14 JTF_NUMBER_TABLE
1044: , p5_a8 JTF_NUMBER_TABLE
1045: , p5_a9 JTF_VARCHAR2_TABLE_100
1046: , p5_a10 JTF_NUMBER_TABLE
1047: , p5_a11 JTF_DATE_TABLE
1048: , p5_a12 JTF_NUMBER_TABLE
1049: , p5_a13 JTF_DATE_TABLE
1050: , p5_a14 JTF_NUMBER_TABLE
1051: )
1052:
1046: , p5_a10 JTF_NUMBER_TABLE
1047: , p5_a11 JTF_DATE_TABLE
1048: , p5_a12 JTF_NUMBER_TABLE
1049: , p5_a13 JTF_DATE_TABLE
1050: , p5_a14 JTF_NUMBER_TABLE
1051: )
1052:
1053: as
1054: ddp_ovdv_tbl okl_ovd_pvt.ovdv_tbl_type;