21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_agn_pvt.agn_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_agn_pvt.agn_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_DATE_TABLE
36: , a11 JTF_DATE_TABLE
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_DATE_TABLE
36: , a11 JTF_DATE_TABLE
37: , a12 JTF_NUMBER_TABLE
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_DATE_TABLE
40: , a15 JTF_NUMBER_TABLE
41: , a16 JTF_DATE_TABLE
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_DATE_TABLE
36: , a11 JTF_DATE_TABLE
37: , a12 JTF_NUMBER_TABLE
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_DATE_TABLE
40: , a15 JTF_NUMBER_TABLE
41: , a16 JTF_DATE_TABLE
42: , a17 JTF_NUMBER_TABLE
36: , a11 JTF_DATE_TABLE
37: , a12 JTF_NUMBER_TABLE
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_DATE_TABLE
40: , a15 JTF_NUMBER_TABLE
41: , a16 JTF_DATE_TABLE
42: , a17 JTF_NUMBER_TABLE
43: ) as
44: ddindx binary_integer; indx binary_integer;
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_DATE_TABLE
40: , a15 JTF_NUMBER_TABLE
41: , a16 JTF_DATE_TABLE
42: , a17 JTF_NUMBER_TABLE
43: ) as
44: ddindx binary_integer; indx binary_integer;
45: begin
46: if a0 is not null and a0.count > 0 then
74: end loop;
75: end if;
76: end if;
77: end rosetta_table_copy_in_p2;
78: procedure rosetta_table_copy_out_p2(t okl_agn_pvt.agn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , a3 out nocopy JTF_VARCHAR2_TABLE_100
82: , a4 out nocopy JTF_VARCHAR2_TABLE_100
75: end if;
76: end if;
77: end rosetta_table_copy_in_p2;
78: procedure rosetta_table_copy_out_p2(t okl_agn_pvt.agn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , a3 out nocopy JTF_VARCHAR2_TABLE_100
82: , a4 out nocopy JTF_VARCHAR2_TABLE_100
83: , a5 out nocopy JTF_VARCHAR2_TABLE_100
81: , a3 out nocopy JTF_VARCHAR2_TABLE_100
82: , a4 out nocopy JTF_VARCHAR2_TABLE_100
83: , a5 out nocopy JTF_VARCHAR2_TABLE_100
84: , a6 out nocopy JTF_VARCHAR2_TABLE_100
85: , a7 out nocopy JTF_NUMBER_TABLE
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100
87: , a9 out nocopy JTF_VARCHAR2_TABLE_100
88: , a10 out nocopy JTF_DATE_TABLE
89: , a11 out nocopy JTF_DATE_TABLE
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100
87: , a9 out nocopy JTF_VARCHAR2_TABLE_100
88: , a10 out nocopy JTF_DATE_TABLE
89: , a11 out nocopy JTF_DATE_TABLE
90: , a12 out nocopy JTF_NUMBER_TABLE
91: , a13 out nocopy JTF_NUMBER_TABLE
92: , a14 out nocopy JTF_DATE_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
94: , a16 out nocopy JTF_DATE_TABLE
87: , a9 out nocopy JTF_VARCHAR2_TABLE_100
88: , a10 out nocopy JTF_DATE_TABLE
89: , a11 out nocopy JTF_DATE_TABLE
90: , a12 out nocopy JTF_NUMBER_TABLE
91: , a13 out nocopy JTF_NUMBER_TABLE
92: , a14 out nocopy JTF_DATE_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
94: , a16 out nocopy JTF_DATE_TABLE
95: , a17 out nocopy JTF_NUMBER_TABLE
89: , a11 out nocopy JTF_DATE_TABLE
90: , a12 out nocopy JTF_NUMBER_TABLE
91: , a13 out nocopy JTF_NUMBER_TABLE
92: , a14 out nocopy JTF_DATE_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
94: , a16 out nocopy JTF_DATE_TABLE
95: , a17 out nocopy JTF_NUMBER_TABLE
96: ) as
97: ddindx binary_integer; indx binary_integer;
91: , a13 out nocopy JTF_NUMBER_TABLE
92: , a14 out nocopy JTF_DATE_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
94: , a16 out nocopy JTF_DATE_TABLE
95: , a17 out nocopy JTF_NUMBER_TABLE
96: ) as
97: ddindx binary_integer; indx binary_integer;
98: begin
99: if t is null or t.count = 0 then
96: ) as
97: ddindx binary_integer; indx binary_integer;
98: begin
99: if t is null or t.count = 0 then
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_VARCHAR2_TABLE_100();
103: a3 := JTF_VARCHAR2_TABLE_100();
104: a4 := JTF_VARCHAR2_TABLE_100();
97: ddindx binary_integer; indx binary_integer;
98: begin
99: if t is null or t.count = 0 then
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_VARCHAR2_TABLE_100();
103: a3 := JTF_VARCHAR2_TABLE_100();
104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_VARCHAR2_TABLE_100();
103: a3 := JTF_VARCHAR2_TABLE_100();
104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_VARCHAR2_TABLE_100();
106: a6 := JTF_VARCHAR2_TABLE_100();
107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_VARCHAR2_TABLE_100();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_DATE_TABLE();
111: a11 := JTF_DATE_TABLE();
108: a8 := JTF_VARCHAR2_TABLE_100();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_DATE_TABLE();
111: a11 := JTF_DATE_TABLE();
112: a12 := JTF_NUMBER_TABLE();
113: a13 := JTF_NUMBER_TABLE();
114: a14 := JTF_DATE_TABLE();
115: a15 := JTF_NUMBER_TABLE();
116: a16 := JTF_DATE_TABLE();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_DATE_TABLE();
111: a11 := JTF_DATE_TABLE();
112: a12 := JTF_NUMBER_TABLE();
113: a13 := JTF_NUMBER_TABLE();
114: a14 := JTF_DATE_TABLE();
115: a15 := JTF_NUMBER_TABLE();
116: a16 := JTF_DATE_TABLE();
117: a17 := JTF_NUMBER_TABLE();
111: a11 := JTF_DATE_TABLE();
112: a12 := JTF_NUMBER_TABLE();
113: a13 := JTF_NUMBER_TABLE();
114: a14 := JTF_DATE_TABLE();
115: a15 := JTF_NUMBER_TABLE();
116: a16 := JTF_DATE_TABLE();
117: a17 := JTF_NUMBER_TABLE();
118: else
119: a0 := JTF_NUMBER_TABLE();
113: a13 := JTF_NUMBER_TABLE();
114: a14 := JTF_DATE_TABLE();
115: a15 := JTF_NUMBER_TABLE();
116: a16 := JTF_DATE_TABLE();
117: a17 := JTF_NUMBER_TABLE();
118: else
119: a0 := JTF_NUMBER_TABLE();
120: a1 := JTF_NUMBER_TABLE();
121: a2 := JTF_VARCHAR2_TABLE_100();
115: a15 := JTF_NUMBER_TABLE();
116: a16 := JTF_DATE_TABLE();
117: a17 := JTF_NUMBER_TABLE();
118: else
119: a0 := JTF_NUMBER_TABLE();
120: a1 := JTF_NUMBER_TABLE();
121: a2 := JTF_VARCHAR2_TABLE_100();
122: a3 := JTF_VARCHAR2_TABLE_100();
123: a4 := JTF_VARCHAR2_TABLE_100();
116: a16 := JTF_DATE_TABLE();
117: a17 := JTF_NUMBER_TABLE();
118: else
119: a0 := JTF_NUMBER_TABLE();
120: a1 := JTF_NUMBER_TABLE();
121: a2 := JTF_VARCHAR2_TABLE_100();
122: a3 := JTF_VARCHAR2_TABLE_100();
123: a4 := JTF_VARCHAR2_TABLE_100();
124: a5 := JTF_VARCHAR2_TABLE_100();
122: a3 := JTF_VARCHAR2_TABLE_100();
123: a4 := JTF_VARCHAR2_TABLE_100();
124: a5 := JTF_VARCHAR2_TABLE_100();
125: a6 := JTF_VARCHAR2_TABLE_100();
126: a7 := JTF_NUMBER_TABLE();
127: a8 := JTF_VARCHAR2_TABLE_100();
128: a9 := JTF_VARCHAR2_TABLE_100();
129: a10 := JTF_DATE_TABLE();
130: a11 := JTF_DATE_TABLE();
127: a8 := JTF_VARCHAR2_TABLE_100();
128: a9 := JTF_VARCHAR2_TABLE_100();
129: a10 := JTF_DATE_TABLE();
130: a11 := JTF_DATE_TABLE();
131: a12 := JTF_NUMBER_TABLE();
132: a13 := JTF_NUMBER_TABLE();
133: a14 := JTF_DATE_TABLE();
134: a15 := JTF_NUMBER_TABLE();
135: a16 := JTF_DATE_TABLE();
128: a9 := JTF_VARCHAR2_TABLE_100();
129: a10 := JTF_DATE_TABLE();
130: a11 := JTF_DATE_TABLE();
131: a12 := JTF_NUMBER_TABLE();
132: a13 := JTF_NUMBER_TABLE();
133: a14 := JTF_DATE_TABLE();
134: a15 := JTF_NUMBER_TABLE();
135: a16 := JTF_DATE_TABLE();
136: a17 := JTF_NUMBER_TABLE();
130: a11 := JTF_DATE_TABLE();
131: a12 := JTF_NUMBER_TABLE();
132: a13 := JTF_NUMBER_TABLE();
133: a14 := JTF_DATE_TABLE();
134: a15 := JTF_NUMBER_TABLE();
135: a16 := JTF_DATE_TABLE();
136: a17 := JTF_NUMBER_TABLE();
137: if t.count > 0 then
138: a0.extend(t.count);
132: a13 := JTF_NUMBER_TABLE();
133: a14 := JTF_DATE_TABLE();
134: a15 := JTF_NUMBER_TABLE();
135: a16 := JTF_DATE_TABLE();
136: a17 := JTF_NUMBER_TABLE();
137: if t.count > 0 then
138: a0.extend(t.count);
139: a1.extend(t.count);
140: a2.extend(t.count);
183: end if;
184: end if;
185: end rosetta_table_copy_out_p2;
186:
187: procedure rosetta_table_copy_in_p5(t out nocopy okl_agn_pvt.agnv_tbl_type, a0 JTF_NUMBER_TABLE
188: , a1 JTF_NUMBER_TABLE
189: , a2 JTF_VARCHAR2_TABLE_100
190: , a3 JTF_VARCHAR2_TABLE_100
191: , a4 JTF_VARCHAR2_TABLE_100
184: end if;
185: end rosetta_table_copy_out_p2;
186:
187: procedure rosetta_table_copy_in_p5(t out nocopy okl_agn_pvt.agnv_tbl_type, a0 JTF_NUMBER_TABLE
188: , a1 JTF_NUMBER_TABLE
189: , a2 JTF_VARCHAR2_TABLE_100
190: , a3 JTF_VARCHAR2_TABLE_100
191: , a4 JTF_VARCHAR2_TABLE_100
192: , a5 JTF_NUMBER_TABLE
188: , a1 JTF_NUMBER_TABLE
189: , a2 JTF_VARCHAR2_TABLE_100
190: , a3 JTF_VARCHAR2_TABLE_100
191: , a4 JTF_VARCHAR2_TABLE_100
192: , a5 JTF_NUMBER_TABLE
193: , a6 JTF_VARCHAR2_TABLE_100
194: , a7 JTF_VARCHAR2_TABLE_100
195: , a8 JTF_VARCHAR2_TABLE_100
196: , a9 JTF_VARCHAR2_TABLE_100
195: , a8 JTF_VARCHAR2_TABLE_100
196: , a9 JTF_VARCHAR2_TABLE_100
197: , a10 JTF_DATE_TABLE
198: , a11 JTF_DATE_TABLE
199: , a12 JTF_NUMBER_TABLE
200: , a13 JTF_NUMBER_TABLE
201: , a14 JTF_DATE_TABLE
202: , a15 JTF_NUMBER_TABLE
203: , a16 JTF_DATE_TABLE
196: , a9 JTF_VARCHAR2_TABLE_100
197: , a10 JTF_DATE_TABLE
198: , a11 JTF_DATE_TABLE
199: , a12 JTF_NUMBER_TABLE
200: , a13 JTF_NUMBER_TABLE
201: , a14 JTF_DATE_TABLE
202: , a15 JTF_NUMBER_TABLE
203: , a16 JTF_DATE_TABLE
204: , a17 JTF_NUMBER_TABLE
198: , a11 JTF_DATE_TABLE
199: , a12 JTF_NUMBER_TABLE
200: , a13 JTF_NUMBER_TABLE
201: , a14 JTF_DATE_TABLE
202: , a15 JTF_NUMBER_TABLE
203: , a16 JTF_DATE_TABLE
204: , a17 JTF_NUMBER_TABLE
205: ) as
206: ddindx binary_integer; indx binary_integer;
200: , a13 JTF_NUMBER_TABLE
201: , a14 JTF_DATE_TABLE
202: , a15 JTF_NUMBER_TABLE
203: , a16 JTF_DATE_TABLE
204: , a17 JTF_NUMBER_TABLE
205: ) as
206: ddindx binary_integer; indx binary_integer;
207: begin
208: if a0 is not null and a0.count > 0 then
236: end loop;
237: end if;
238: end if;
239: end rosetta_table_copy_in_p5;
240: procedure rosetta_table_copy_out_p5(t okl_agn_pvt.agnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
241: , a1 out nocopy JTF_NUMBER_TABLE
242: , a2 out nocopy JTF_VARCHAR2_TABLE_100
243: , a3 out nocopy JTF_VARCHAR2_TABLE_100
244: , a4 out nocopy JTF_VARCHAR2_TABLE_100
237: end if;
238: end if;
239: end rosetta_table_copy_in_p5;
240: procedure rosetta_table_copy_out_p5(t okl_agn_pvt.agnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
241: , a1 out nocopy JTF_NUMBER_TABLE
242: , a2 out nocopy JTF_VARCHAR2_TABLE_100
243: , a3 out nocopy JTF_VARCHAR2_TABLE_100
244: , a4 out nocopy JTF_VARCHAR2_TABLE_100
245: , a5 out nocopy JTF_NUMBER_TABLE
241: , a1 out nocopy JTF_NUMBER_TABLE
242: , a2 out nocopy JTF_VARCHAR2_TABLE_100
243: , a3 out nocopy JTF_VARCHAR2_TABLE_100
244: , a4 out nocopy JTF_VARCHAR2_TABLE_100
245: , a5 out nocopy JTF_NUMBER_TABLE
246: , a6 out nocopy JTF_VARCHAR2_TABLE_100
247: , a7 out nocopy JTF_VARCHAR2_TABLE_100
248: , a8 out nocopy JTF_VARCHAR2_TABLE_100
249: , a9 out nocopy JTF_VARCHAR2_TABLE_100
248: , a8 out nocopy JTF_VARCHAR2_TABLE_100
249: , a9 out nocopy JTF_VARCHAR2_TABLE_100
250: , a10 out nocopy JTF_DATE_TABLE
251: , a11 out nocopy JTF_DATE_TABLE
252: , a12 out nocopy JTF_NUMBER_TABLE
253: , a13 out nocopy JTF_NUMBER_TABLE
254: , a14 out nocopy JTF_DATE_TABLE
255: , a15 out nocopy JTF_NUMBER_TABLE
256: , a16 out nocopy JTF_DATE_TABLE
249: , a9 out nocopy JTF_VARCHAR2_TABLE_100
250: , a10 out nocopy JTF_DATE_TABLE
251: , a11 out nocopy JTF_DATE_TABLE
252: , a12 out nocopy JTF_NUMBER_TABLE
253: , a13 out nocopy JTF_NUMBER_TABLE
254: , a14 out nocopy JTF_DATE_TABLE
255: , a15 out nocopy JTF_NUMBER_TABLE
256: , a16 out nocopy JTF_DATE_TABLE
257: , a17 out nocopy JTF_NUMBER_TABLE
251: , a11 out nocopy JTF_DATE_TABLE
252: , a12 out nocopy JTF_NUMBER_TABLE
253: , a13 out nocopy JTF_NUMBER_TABLE
254: , a14 out nocopy JTF_DATE_TABLE
255: , a15 out nocopy JTF_NUMBER_TABLE
256: , a16 out nocopy JTF_DATE_TABLE
257: , a17 out nocopy JTF_NUMBER_TABLE
258: ) as
259: ddindx binary_integer; indx binary_integer;
253: , a13 out nocopy JTF_NUMBER_TABLE
254: , a14 out nocopy JTF_DATE_TABLE
255: , a15 out nocopy JTF_NUMBER_TABLE
256: , a16 out nocopy JTF_DATE_TABLE
257: , a17 out nocopy JTF_NUMBER_TABLE
258: ) as
259: ddindx binary_integer; indx binary_integer;
260: begin
261: if t is null or t.count = 0 then
258: ) as
259: ddindx binary_integer; indx binary_integer;
260: begin
261: if t is null or t.count = 0 then
262: a0 := JTF_NUMBER_TABLE();
263: a1 := JTF_NUMBER_TABLE();
264: a2 := JTF_VARCHAR2_TABLE_100();
265: a3 := JTF_VARCHAR2_TABLE_100();
266: a4 := JTF_VARCHAR2_TABLE_100();
259: ddindx binary_integer; indx binary_integer;
260: begin
261: if t is null or t.count = 0 then
262: a0 := JTF_NUMBER_TABLE();
263: a1 := JTF_NUMBER_TABLE();
264: a2 := JTF_VARCHAR2_TABLE_100();
265: a3 := JTF_VARCHAR2_TABLE_100();
266: a4 := JTF_VARCHAR2_TABLE_100();
267: a5 := JTF_NUMBER_TABLE();
263: a1 := JTF_NUMBER_TABLE();
264: a2 := JTF_VARCHAR2_TABLE_100();
265: a3 := JTF_VARCHAR2_TABLE_100();
266: a4 := JTF_VARCHAR2_TABLE_100();
267: a5 := JTF_NUMBER_TABLE();
268: a6 := JTF_VARCHAR2_TABLE_100();
269: a7 := JTF_VARCHAR2_TABLE_100();
270: a8 := JTF_VARCHAR2_TABLE_100();
271: a9 := JTF_VARCHAR2_TABLE_100();
270: a8 := JTF_VARCHAR2_TABLE_100();
271: a9 := JTF_VARCHAR2_TABLE_100();
272: a10 := JTF_DATE_TABLE();
273: a11 := JTF_DATE_TABLE();
274: a12 := JTF_NUMBER_TABLE();
275: a13 := JTF_NUMBER_TABLE();
276: a14 := JTF_DATE_TABLE();
277: a15 := JTF_NUMBER_TABLE();
278: a16 := JTF_DATE_TABLE();
271: a9 := JTF_VARCHAR2_TABLE_100();
272: a10 := JTF_DATE_TABLE();
273: a11 := JTF_DATE_TABLE();
274: a12 := JTF_NUMBER_TABLE();
275: a13 := JTF_NUMBER_TABLE();
276: a14 := JTF_DATE_TABLE();
277: a15 := JTF_NUMBER_TABLE();
278: a16 := JTF_DATE_TABLE();
279: a17 := JTF_NUMBER_TABLE();
273: a11 := JTF_DATE_TABLE();
274: a12 := JTF_NUMBER_TABLE();
275: a13 := JTF_NUMBER_TABLE();
276: a14 := JTF_DATE_TABLE();
277: a15 := JTF_NUMBER_TABLE();
278: a16 := JTF_DATE_TABLE();
279: a17 := JTF_NUMBER_TABLE();
280: else
281: a0 := JTF_NUMBER_TABLE();
275: a13 := JTF_NUMBER_TABLE();
276: a14 := JTF_DATE_TABLE();
277: a15 := JTF_NUMBER_TABLE();
278: a16 := JTF_DATE_TABLE();
279: a17 := JTF_NUMBER_TABLE();
280: else
281: a0 := JTF_NUMBER_TABLE();
282: a1 := JTF_NUMBER_TABLE();
283: a2 := JTF_VARCHAR2_TABLE_100();
277: a15 := JTF_NUMBER_TABLE();
278: a16 := JTF_DATE_TABLE();
279: a17 := JTF_NUMBER_TABLE();
280: else
281: a0 := JTF_NUMBER_TABLE();
282: a1 := JTF_NUMBER_TABLE();
283: a2 := JTF_VARCHAR2_TABLE_100();
284: a3 := JTF_VARCHAR2_TABLE_100();
285: a4 := JTF_VARCHAR2_TABLE_100();
278: a16 := JTF_DATE_TABLE();
279: a17 := JTF_NUMBER_TABLE();
280: else
281: a0 := JTF_NUMBER_TABLE();
282: a1 := JTF_NUMBER_TABLE();
283: a2 := JTF_VARCHAR2_TABLE_100();
284: a3 := JTF_VARCHAR2_TABLE_100();
285: a4 := JTF_VARCHAR2_TABLE_100();
286: a5 := JTF_NUMBER_TABLE();
282: a1 := JTF_NUMBER_TABLE();
283: a2 := JTF_VARCHAR2_TABLE_100();
284: a3 := JTF_VARCHAR2_TABLE_100();
285: a4 := JTF_VARCHAR2_TABLE_100();
286: a5 := JTF_NUMBER_TABLE();
287: a6 := JTF_VARCHAR2_TABLE_100();
288: a7 := JTF_VARCHAR2_TABLE_100();
289: a8 := JTF_VARCHAR2_TABLE_100();
290: a9 := JTF_VARCHAR2_TABLE_100();
289: a8 := JTF_VARCHAR2_TABLE_100();
290: a9 := JTF_VARCHAR2_TABLE_100();
291: a10 := JTF_DATE_TABLE();
292: a11 := JTF_DATE_TABLE();
293: a12 := JTF_NUMBER_TABLE();
294: a13 := JTF_NUMBER_TABLE();
295: a14 := JTF_DATE_TABLE();
296: a15 := JTF_NUMBER_TABLE();
297: a16 := JTF_DATE_TABLE();
290: a9 := JTF_VARCHAR2_TABLE_100();
291: a10 := JTF_DATE_TABLE();
292: a11 := JTF_DATE_TABLE();
293: a12 := JTF_NUMBER_TABLE();
294: a13 := JTF_NUMBER_TABLE();
295: a14 := JTF_DATE_TABLE();
296: a15 := JTF_NUMBER_TABLE();
297: a16 := JTF_DATE_TABLE();
298: a17 := JTF_NUMBER_TABLE();
292: a11 := JTF_DATE_TABLE();
293: a12 := JTF_NUMBER_TABLE();
294: a13 := JTF_NUMBER_TABLE();
295: a14 := JTF_DATE_TABLE();
296: a15 := JTF_NUMBER_TABLE();
297: a16 := JTF_DATE_TABLE();
298: a17 := JTF_NUMBER_TABLE();
299: if t.count > 0 then
300: a0.extend(t.count);
294: a13 := JTF_NUMBER_TABLE();
295: a14 := JTF_DATE_TABLE();
296: a15 := JTF_NUMBER_TABLE();
297: a16 := JTF_DATE_TABLE();
298: a17 := JTF_NUMBER_TABLE();
299: if t.count > 0 then
300: a0.extend(t.count);
301: a1.extend(t.count);
302: a2.extend(t.count);
461: , p_init_msg_list VARCHAR2
462: , x_return_status out nocopy VARCHAR2
463: , x_msg_count out nocopy NUMBER
464: , x_msg_data out nocopy VARCHAR2
465: , p5_a0 JTF_NUMBER_TABLE
466: , p5_a1 JTF_NUMBER_TABLE
467: , p5_a2 JTF_VARCHAR2_TABLE_100
468: , p5_a3 JTF_VARCHAR2_TABLE_100
469: , p5_a4 JTF_VARCHAR2_TABLE_100
462: , x_return_status out nocopy VARCHAR2
463: , x_msg_count out nocopy NUMBER
464: , x_msg_data out nocopy VARCHAR2
465: , p5_a0 JTF_NUMBER_TABLE
466: , p5_a1 JTF_NUMBER_TABLE
467: , p5_a2 JTF_VARCHAR2_TABLE_100
468: , p5_a3 JTF_VARCHAR2_TABLE_100
469: , p5_a4 JTF_VARCHAR2_TABLE_100
470: , p5_a5 JTF_NUMBER_TABLE
466: , p5_a1 JTF_NUMBER_TABLE
467: , p5_a2 JTF_VARCHAR2_TABLE_100
468: , p5_a3 JTF_VARCHAR2_TABLE_100
469: , p5_a4 JTF_VARCHAR2_TABLE_100
470: , p5_a5 JTF_NUMBER_TABLE
471: , p5_a6 JTF_VARCHAR2_TABLE_100
472: , p5_a7 JTF_VARCHAR2_TABLE_100
473: , p5_a8 JTF_VARCHAR2_TABLE_100
474: , p5_a9 JTF_VARCHAR2_TABLE_100
473: , p5_a8 JTF_VARCHAR2_TABLE_100
474: , p5_a9 JTF_VARCHAR2_TABLE_100
475: , p5_a10 JTF_DATE_TABLE
476: , p5_a11 JTF_DATE_TABLE
477: , p5_a12 JTF_NUMBER_TABLE
478: , p5_a13 JTF_NUMBER_TABLE
479: , p5_a14 JTF_DATE_TABLE
480: , p5_a15 JTF_NUMBER_TABLE
481: , p5_a16 JTF_DATE_TABLE
474: , p5_a9 JTF_VARCHAR2_TABLE_100
475: , p5_a10 JTF_DATE_TABLE
476: , p5_a11 JTF_DATE_TABLE
477: , p5_a12 JTF_NUMBER_TABLE
478: , p5_a13 JTF_NUMBER_TABLE
479: , p5_a14 JTF_DATE_TABLE
480: , p5_a15 JTF_NUMBER_TABLE
481: , p5_a16 JTF_DATE_TABLE
482: , p5_a17 JTF_NUMBER_TABLE
476: , p5_a11 JTF_DATE_TABLE
477: , p5_a12 JTF_NUMBER_TABLE
478: , p5_a13 JTF_NUMBER_TABLE
479: , p5_a14 JTF_DATE_TABLE
480: , p5_a15 JTF_NUMBER_TABLE
481: , p5_a16 JTF_DATE_TABLE
482: , p5_a17 JTF_NUMBER_TABLE
483: , p6_a0 out nocopy JTF_NUMBER_TABLE
484: , p6_a1 out nocopy JTF_NUMBER_TABLE
478: , p5_a13 JTF_NUMBER_TABLE
479: , p5_a14 JTF_DATE_TABLE
480: , p5_a15 JTF_NUMBER_TABLE
481: , p5_a16 JTF_DATE_TABLE
482: , p5_a17 JTF_NUMBER_TABLE
483: , p6_a0 out nocopy JTF_NUMBER_TABLE
484: , p6_a1 out nocopy JTF_NUMBER_TABLE
485: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
486: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
479: , p5_a14 JTF_DATE_TABLE
480: , p5_a15 JTF_NUMBER_TABLE
481: , p5_a16 JTF_DATE_TABLE
482: , p5_a17 JTF_NUMBER_TABLE
483: , p6_a0 out nocopy JTF_NUMBER_TABLE
484: , p6_a1 out nocopy JTF_NUMBER_TABLE
485: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
486: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
480: , p5_a15 JTF_NUMBER_TABLE
481: , p5_a16 JTF_DATE_TABLE
482: , p5_a17 JTF_NUMBER_TABLE
483: , p6_a0 out nocopy JTF_NUMBER_TABLE
484: , p6_a1 out nocopy JTF_NUMBER_TABLE
485: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
486: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
488: , p6_a5 out nocopy JTF_NUMBER_TABLE
484: , p6_a1 out nocopy JTF_NUMBER_TABLE
485: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
486: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
488: , p6_a5 out nocopy JTF_NUMBER_TABLE
489: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
490: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
492: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
492: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
493: , p6_a10 out nocopy JTF_DATE_TABLE
494: , p6_a11 out nocopy JTF_DATE_TABLE
495: , p6_a12 out nocopy JTF_NUMBER_TABLE
496: , p6_a13 out nocopy JTF_NUMBER_TABLE
497: , p6_a14 out nocopy JTF_DATE_TABLE
498: , p6_a15 out nocopy JTF_NUMBER_TABLE
499: , p6_a16 out nocopy JTF_DATE_TABLE
492: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
493: , p6_a10 out nocopy JTF_DATE_TABLE
494: , p6_a11 out nocopy JTF_DATE_TABLE
495: , p6_a12 out nocopy JTF_NUMBER_TABLE
496: , p6_a13 out nocopy JTF_NUMBER_TABLE
497: , p6_a14 out nocopy JTF_DATE_TABLE
498: , p6_a15 out nocopy JTF_NUMBER_TABLE
499: , p6_a16 out nocopy JTF_DATE_TABLE
500: , p6_a17 out nocopy JTF_NUMBER_TABLE
494: , p6_a11 out nocopy JTF_DATE_TABLE
495: , p6_a12 out nocopy JTF_NUMBER_TABLE
496: , p6_a13 out nocopy JTF_NUMBER_TABLE
497: , p6_a14 out nocopy JTF_DATE_TABLE
498: , p6_a15 out nocopy JTF_NUMBER_TABLE
499: , p6_a16 out nocopy JTF_DATE_TABLE
500: , p6_a17 out nocopy JTF_NUMBER_TABLE
501: )
502:
496: , p6_a13 out nocopy JTF_NUMBER_TABLE
497: , p6_a14 out nocopy JTF_DATE_TABLE
498: , p6_a15 out nocopy JTF_NUMBER_TABLE
499: , p6_a16 out nocopy JTF_DATE_TABLE
500: , p6_a17 out nocopy JTF_NUMBER_TABLE
501: )
502:
503: as
504: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;
645: , p_init_msg_list VARCHAR2
646: , x_return_status out nocopy VARCHAR2
647: , x_msg_count out nocopy NUMBER
648: , x_msg_data out nocopy VARCHAR2
649: , p5_a0 JTF_NUMBER_TABLE
650: , p5_a1 JTF_NUMBER_TABLE
651: , p5_a2 JTF_VARCHAR2_TABLE_100
652: , p5_a3 JTF_VARCHAR2_TABLE_100
653: , p5_a4 JTF_VARCHAR2_TABLE_100
646: , x_return_status out nocopy VARCHAR2
647: , x_msg_count out nocopy NUMBER
648: , x_msg_data out nocopy VARCHAR2
649: , p5_a0 JTF_NUMBER_TABLE
650: , p5_a1 JTF_NUMBER_TABLE
651: , p5_a2 JTF_VARCHAR2_TABLE_100
652: , p5_a3 JTF_VARCHAR2_TABLE_100
653: , p5_a4 JTF_VARCHAR2_TABLE_100
654: , p5_a5 JTF_NUMBER_TABLE
650: , p5_a1 JTF_NUMBER_TABLE
651: , p5_a2 JTF_VARCHAR2_TABLE_100
652: , p5_a3 JTF_VARCHAR2_TABLE_100
653: , p5_a4 JTF_VARCHAR2_TABLE_100
654: , p5_a5 JTF_NUMBER_TABLE
655: , p5_a6 JTF_VARCHAR2_TABLE_100
656: , p5_a7 JTF_VARCHAR2_TABLE_100
657: , p5_a8 JTF_VARCHAR2_TABLE_100
658: , p5_a9 JTF_VARCHAR2_TABLE_100
657: , p5_a8 JTF_VARCHAR2_TABLE_100
658: , p5_a9 JTF_VARCHAR2_TABLE_100
659: , p5_a10 JTF_DATE_TABLE
660: , p5_a11 JTF_DATE_TABLE
661: , p5_a12 JTF_NUMBER_TABLE
662: , p5_a13 JTF_NUMBER_TABLE
663: , p5_a14 JTF_DATE_TABLE
664: , p5_a15 JTF_NUMBER_TABLE
665: , p5_a16 JTF_DATE_TABLE
658: , p5_a9 JTF_VARCHAR2_TABLE_100
659: , p5_a10 JTF_DATE_TABLE
660: , p5_a11 JTF_DATE_TABLE
661: , p5_a12 JTF_NUMBER_TABLE
662: , p5_a13 JTF_NUMBER_TABLE
663: , p5_a14 JTF_DATE_TABLE
664: , p5_a15 JTF_NUMBER_TABLE
665: , p5_a16 JTF_DATE_TABLE
666: , p5_a17 JTF_NUMBER_TABLE
660: , p5_a11 JTF_DATE_TABLE
661: , p5_a12 JTF_NUMBER_TABLE
662: , p5_a13 JTF_NUMBER_TABLE
663: , p5_a14 JTF_DATE_TABLE
664: , p5_a15 JTF_NUMBER_TABLE
665: , p5_a16 JTF_DATE_TABLE
666: , p5_a17 JTF_NUMBER_TABLE
667: )
668:
662: , p5_a13 JTF_NUMBER_TABLE
663: , p5_a14 JTF_DATE_TABLE
664: , p5_a15 JTF_NUMBER_TABLE
665: , p5_a16 JTF_DATE_TABLE
666: , p5_a17 JTF_NUMBER_TABLE
667: )
668:
669: as
670: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;
828: , p_init_msg_list VARCHAR2
829: , x_return_status out nocopy VARCHAR2
830: , x_msg_count out nocopy NUMBER
831: , x_msg_data out nocopy VARCHAR2
832: , p5_a0 JTF_NUMBER_TABLE
833: , p5_a1 JTF_NUMBER_TABLE
834: , p5_a2 JTF_VARCHAR2_TABLE_100
835: , p5_a3 JTF_VARCHAR2_TABLE_100
836: , p5_a4 JTF_VARCHAR2_TABLE_100
829: , x_return_status out nocopy VARCHAR2
830: , x_msg_count out nocopy NUMBER
831: , x_msg_data out nocopy VARCHAR2
832: , p5_a0 JTF_NUMBER_TABLE
833: , p5_a1 JTF_NUMBER_TABLE
834: , p5_a2 JTF_VARCHAR2_TABLE_100
835: , p5_a3 JTF_VARCHAR2_TABLE_100
836: , p5_a4 JTF_VARCHAR2_TABLE_100
837: , p5_a5 JTF_NUMBER_TABLE
833: , p5_a1 JTF_NUMBER_TABLE
834: , p5_a2 JTF_VARCHAR2_TABLE_100
835: , p5_a3 JTF_VARCHAR2_TABLE_100
836: , p5_a4 JTF_VARCHAR2_TABLE_100
837: , p5_a5 JTF_NUMBER_TABLE
838: , p5_a6 JTF_VARCHAR2_TABLE_100
839: , p5_a7 JTF_VARCHAR2_TABLE_100
840: , p5_a8 JTF_VARCHAR2_TABLE_100
841: , p5_a9 JTF_VARCHAR2_TABLE_100
840: , p5_a8 JTF_VARCHAR2_TABLE_100
841: , p5_a9 JTF_VARCHAR2_TABLE_100
842: , p5_a10 JTF_DATE_TABLE
843: , p5_a11 JTF_DATE_TABLE
844: , p5_a12 JTF_NUMBER_TABLE
845: , p5_a13 JTF_NUMBER_TABLE
846: , p5_a14 JTF_DATE_TABLE
847: , p5_a15 JTF_NUMBER_TABLE
848: , p5_a16 JTF_DATE_TABLE
841: , p5_a9 JTF_VARCHAR2_TABLE_100
842: , p5_a10 JTF_DATE_TABLE
843: , p5_a11 JTF_DATE_TABLE
844: , p5_a12 JTF_NUMBER_TABLE
845: , p5_a13 JTF_NUMBER_TABLE
846: , p5_a14 JTF_DATE_TABLE
847: , p5_a15 JTF_NUMBER_TABLE
848: , p5_a16 JTF_DATE_TABLE
849: , p5_a17 JTF_NUMBER_TABLE
843: , p5_a11 JTF_DATE_TABLE
844: , p5_a12 JTF_NUMBER_TABLE
845: , p5_a13 JTF_NUMBER_TABLE
846: , p5_a14 JTF_DATE_TABLE
847: , p5_a15 JTF_NUMBER_TABLE
848: , p5_a16 JTF_DATE_TABLE
849: , p5_a17 JTF_NUMBER_TABLE
850: , p6_a0 out nocopy JTF_NUMBER_TABLE
851: , p6_a1 out nocopy JTF_NUMBER_TABLE
845: , p5_a13 JTF_NUMBER_TABLE
846: , p5_a14 JTF_DATE_TABLE
847: , p5_a15 JTF_NUMBER_TABLE
848: , p5_a16 JTF_DATE_TABLE
849: , p5_a17 JTF_NUMBER_TABLE
850: , p6_a0 out nocopy JTF_NUMBER_TABLE
851: , p6_a1 out nocopy JTF_NUMBER_TABLE
852: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
853: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
846: , p5_a14 JTF_DATE_TABLE
847: , p5_a15 JTF_NUMBER_TABLE
848: , p5_a16 JTF_DATE_TABLE
849: , p5_a17 JTF_NUMBER_TABLE
850: , p6_a0 out nocopy JTF_NUMBER_TABLE
851: , p6_a1 out nocopy JTF_NUMBER_TABLE
852: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
853: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
847: , p5_a15 JTF_NUMBER_TABLE
848: , p5_a16 JTF_DATE_TABLE
849: , p5_a17 JTF_NUMBER_TABLE
850: , p6_a0 out nocopy JTF_NUMBER_TABLE
851: , p6_a1 out nocopy JTF_NUMBER_TABLE
852: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
853: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
855: , p6_a5 out nocopy JTF_NUMBER_TABLE
851: , p6_a1 out nocopy JTF_NUMBER_TABLE
852: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
853: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
855: , p6_a5 out nocopy JTF_NUMBER_TABLE
856: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
858: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
859: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
858: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
859: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
860: , p6_a10 out nocopy JTF_DATE_TABLE
861: , p6_a11 out nocopy JTF_DATE_TABLE
862: , p6_a12 out nocopy JTF_NUMBER_TABLE
863: , p6_a13 out nocopy JTF_NUMBER_TABLE
864: , p6_a14 out nocopy JTF_DATE_TABLE
865: , p6_a15 out nocopy JTF_NUMBER_TABLE
866: , p6_a16 out nocopy JTF_DATE_TABLE
859: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
860: , p6_a10 out nocopy JTF_DATE_TABLE
861: , p6_a11 out nocopy JTF_DATE_TABLE
862: , p6_a12 out nocopy JTF_NUMBER_TABLE
863: , p6_a13 out nocopy JTF_NUMBER_TABLE
864: , p6_a14 out nocopy JTF_DATE_TABLE
865: , p6_a15 out nocopy JTF_NUMBER_TABLE
866: , p6_a16 out nocopy JTF_DATE_TABLE
867: , p6_a17 out nocopy JTF_NUMBER_TABLE
861: , p6_a11 out nocopy JTF_DATE_TABLE
862: , p6_a12 out nocopy JTF_NUMBER_TABLE
863: , p6_a13 out nocopy JTF_NUMBER_TABLE
864: , p6_a14 out nocopy JTF_DATE_TABLE
865: , p6_a15 out nocopy JTF_NUMBER_TABLE
866: , p6_a16 out nocopy JTF_DATE_TABLE
867: , p6_a17 out nocopy JTF_NUMBER_TABLE
868: )
869:
863: , p6_a13 out nocopy JTF_NUMBER_TABLE
864: , p6_a14 out nocopy JTF_DATE_TABLE
865: , p6_a15 out nocopy JTF_NUMBER_TABLE
866: , p6_a16 out nocopy JTF_DATE_TABLE
867: , p6_a17 out nocopy JTF_NUMBER_TABLE
868: )
869:
870: as
871: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;
1012: , p_init_msg_list VARCHAR2
1013: , x_return_status out nocopy VARCHAR2
1014: , x_msg_count out nocopy NUMBER
1015: , x_msg_data out nocopy VARCHAR2
1016: , p5_a0 JTF_NUMBER_TABLE
1017: , p5_a1 JTF_NUMBER_TABLE
1018: , p5_a2 JTF_VARCHAR2_TABLE_100
1019: , p5_a3 JTF_VARCHAR2_TABLE_100
1020: , p5_a4 JTF_VARCHAR2_TABLE_100
1013: , x_return_status out nocopy VARCHAR2
1014: , x_msg_count out nocopy NUMBER
1015: , x_msg_data out nocopy VARCHAR2
1016: , p5_a0 JTF_NUMBER_TABLE
1017: , p5_a1 JTF_NUMBER_TABLE
1018: , p5_a2 JTF_VARCHAR2_TABLE_100
1019: , p5_a3 JTF_VARCHAR2_TABLE_100
1020: , p5_a4 JTF_VARCHAR2_TABLE_100
1021: , p5_a5 JTF_NUMBER_TABLE
1017: , p5_a1 JTF_NUMBER_TABLE
1018: , p5_a2 JTF_VARCHAR2_TABLE_100
1019: , p5_a3 JTF_VARCHAR2_TABLE_100
1020: , p5_a4 JTF_VARCHAR2_TABLE_100
1021: , p5_a5 JTF_NUMBER_TABLE
1022: , p5_a6 JTF_VARCHAR2_TABLE_100
1023: , p5_a7 JTF_VARCHAR2_TABLE_100
1024: , p5_a8 JTF_VARCHAR2_TABLE_100
1025: , p5_a9 JTF_VARCHAR2_TABLE_100
1024: , p5_a8 JTF_VARCHAR2_TABLE_100
1025: , p5_a9 JTF_VARCHAR2_TABLE_100
1026: , p5_a10 JTF_DATE_TABLE
1027: , p5_a11 JTF_DATE_TABLE
1028: , p5_a12 JTF_NUMBER_TABLE
1029: , p5_a13 JTF_NUMBER_TABLE
1030: , p5_a14 JTF_DATE_TABLE
1031: , p5_a15 JTF_NUMBER_TABLE
1032: , p5_a16 JTF_DATE_TABLE
1025: , p5_a9 JTF_VARCHAR2_TABLE_100
1026: , p5_a10 JTF_DATE_TABLE
1027: , p5_a11 JTF_DATE_TABLE
1028: , p5_a12 JTF_NUMBER_TABLE
1029: , p5_a13 JTF_NUMBER_TABLE
1030: , p5_a14 JTF_DATE_TABLE
1031: , p5_a15 JTF_NUMBER_TABLE
1032: , p5_a16 JTF_DATE_TABLE
1033: , p5_a17 JTF_NUMBER_TABLE
1027: , p5_a11 JTF_DATE_TABLE
1028: , p5_a12 JTF_NUMBER_TABLE
1029: , p5_a13 JTF_NUMBER_TABLE
1030: , p5_a14 JTF_DATE_TABLE
1031: , p5_a15 JTF_NUMBER_TABLE
1032: , p5_a16 JTF_DATE_TABLE
1033: , p5_a17 JTF_NUMBER_TABLE
1034: )
1035:
1029: , p5_a13 JTF_NUMBER_TABLE
1030: , p5_a14 JTF_DATE_TABLE
1031: , p5_a15 JTF_NUMBER_TABLE
1032: , p5_a16 JTF_DATE_TABLE
1033: , p5_a17 JTF_NUMBER_TABLE
1034: )
1035:
1036: as
1037: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;
1155: , p_init_msg_list VARCHAR2
1156: , x_return_status out nocopy VARCHAR2
1157: , x_msg_count out nocopy NUMBER
1158: , x_msg_data out nocopy VARCHAR2
1159: , p5_a0 JTF_NUMBER_TABLE
1160: , p5_a1 JTF_NUMBER_TABLE
1161: , p5_a2 JTF_VARCHAR2_TABLE_100
1162: , p5_a3 JTF_VARCHAR2_TABLE_100
1163: , p5_a4 JTF_VARCHAR2_TABLE_100
1156: , x_return_status out nocopy VARCHAR2
1157: , x_msg_count out nocopy NUMBER
1158: , x_msg_data out nocopy VARCHAR2
1159: , p5_a0 JTF_NUMBER_TABLE
1160: , p5_a1 JTF_NUMBER_TABLE
1161: , p5_a2 JTF_VARCHAR2_TABLE_100
1162: , p5_a3 JTF_VARCHAR2_TABLE_100
1163: , p5_a4 JTF_VARCHAR2_TABLE_100
1164: , p5_a5 JTF_NUMBER_TABLE
1160: , p5_a1 JTF_NUMBER_TABLE
1161: , p5_a2 JTF_VARCHAR2_TABLE_100
1162: , p5_a3 JTF_VARCHAR2_TABLE_100
1163: , p5_a4 JTF_VARCHAR2_TABLE_100
1164: , p5_a5 JTF_NUMBER_TABLE
1165: , p5_a6 JTF_VARCHAR2_TABLE_100
1166: , p5_a7 JTF_VARCHAR2_TABLE_100
1167: , p5_a8 JTF_VARCHAR2_TABLE_100
1168: , p5_a9 JTF_VARCHAR2_TABLE_100
1167: , p5_a8 JTF_VARCHAR2_TABLE_100
1168: , p5_a9 JTF_VARCHAR2_TABLE_100
1169: , p5_a10 JTF_DATE_TABLE
1170: , p5_a11 JTF_DATE_TABLE
1171: , p5_a12 JTF_NUMBER_TABLE
1172: , p5_a13 JTF_NUMBER_TABLE
1173: , p5_a14 JTF_DATE_TABLE
1174: , p5_a15 JTF_NUMBER_TABLE
1175: , p5_a16 JTF_DATE_TABLE
1168: , p5_a9 JTF_VARCHAR2_TABLE_100
1169: , p5_a10 JTF_DATE_TABLE
1170: , p5_a11 JTF_DATE_TABLE
1171: , p5_a12 JTF_NUMBER_TABLE
1172: , p5_a13 JTF_NUMBER_TABLE
1173: , p5_a14 JTF_DATE_TABLE
1174: , p5_a15 JTF_NUMBER_TABLE
1175: , p5_a16 JTF_DATE_TABLE
1176: , p5_a17 JTF_NUMBER_TABLE
1170: , p5_a11 JTF_DATE_TABLE
1171: , p5_a12 JTF_NUMBER_TABLE
1172: , p5_a13 JTF_NUMBER_TABLE
1173: , p5_a14 JTF_DATE_TABLE
1174: , p5_a15 JTF_NUMBER_TABLE
1175: , p5_a16 JTF_DATE_TABLE
1176: , p5_a17 JTF_NUMBER_TABLE
1177: )
1178:
1172: , p5_a13 JTF_NUMBER_TABLE
1173: , p5_a14 JTF_DATE_TABLE
1174: , p5_a15 JTF_NUMBER_TABLE
1175: , p5_a16 JTF_DATE_TABLE
1176: , p5_a17 JTF_NUMBER_TABLE
1177: )
1178:
1179: as
1180: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;