1: package body okl_vrr_pvt_w as
2: /* $Header: OKLIVRRB.pls 120.0 2005/08/03 07:54:37 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400
1: package body okl_vrr_pvt_w as
2: /* $Header: OKLIVRRB.pls 120.0 2005/08/03 07:54:37 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_2000
1: package body okl_vrr_pvt_w as
2: /* $Header: OKLIVRRB.pls 120.0 2005/08/03 07:54:37 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: ) as
35: ddindx binary_integer; indx binary_integer;
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: ) as
35: ddindx binary_integer; indx binary_integer;
36: begin
37: if a0 is not null and a0.count > 0 then
78: end loop;
79: end if;
80: end if;
81: end rosetta_table_copy_in_p2;
82: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_VARCHAR2_TABLE_100
86: , a4 out nocopy JTF_VARCHAR2_TABLE_400
79: end if;
80: end if;
81: end rosetta_table_copy_in_p2;
82: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_VARCHAR2_TABLE_100
86: , a4 out nocopy JTF_VARCHAR2_TABLE_400
87: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
80: end if;
81: end rosetta_table_copy_in_p2;
82: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_VARCHAR2_TABLE_100
86: , a4 out nocopy JTF_VARCHAR2_TABLE_400
87: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
88: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a18 out nocopy JTF_VARCHAR2_TABLE_500
101: , a19 out nocopy JTF_VARCHAR2_TABLE_500
102: , a20 out nocopy JTF_VARCHAR2_TABLE_500
103: , a21 out nocopy JTF_VARCHAR2_TABLE_500
104: , a22 out nocopy JTF_NUMBER_TABLE
105: , a23 out nocopy JTF_NUMBER_TABLE
106: , a24 out nocopy JTF_NUMBER_TABLE
107: , a25 out nocopy JTF_DATE_TABLE
108: , a26 out nocopy JTF_NUMBER_TABLE
101: , a19 out nocopy JTF_VARCHAR2_TABLE_500
102: , a20 out nocopy JTF_VARCHAR2_TABLE_500
103: , a21 out nocopy JTF_VARCHAR2_TABLE_500
104: , a22 out nocopy JTF_NUMBER_TABLE
105: , a23 out nocopy JTF_NUMBER_TABLE
106: , a24 out nocopy JTF_NUMBER_TABLE
107: , a25 out nocopy JTF_DATE_TABLE
108: , a26 out nocopy JTF_NUMBER_TABLE
109: , a27 out nocopy JTF_DATE_TABLE
102: , a20 out nocopy JTF_VARCHAR2_TABLE_500
103: , a21 out nocopy JTF_VARCHAR2_TABLE_500
104: , a22 out nocopy JTF_NUMBER_TABLE
105: , a23 out nocopy JTF_NUMBER_TABLE
106: , a24 out nocopy JTF_NUMBER_TABLE
107: , a25 out nocopy JTF_DATE_TABLE
108: , a26 out nocopy JTF_NUMBER_TABLE
109: , a27 out nocopy JTF_DATE_TABLE
110: , a28 out nocopy JTF_NUMBER_TABLE
104: , a22 out nocopy JTF_NUMBER_TABLE
105: , a23 out nocopy JTF_NUMBER_TABLE
106: , a24 out nocopy JTF_NUMBER_TABLE
107: , a25 out nocopy JTF_DATE_TABLE
108: , a26 out nocopy JTF_NUMBER_TABLE
109: , a27 out nocopy JTF_DATE_TABLE
110: , a28 out nocopy JTF_NUMBER_TABLE
111: , a29 out nocopy JTF_DATE_TABLE
112: , a30 out nocopy JTF_NUMBER_TABLE
106: , a24 out nocopy JTF_NUMBER_TABLE
107: , a25 out nocopy JTF_DATE_TABLE
108: , a26 out nocopy JTF_NUMBER_TABLE
109: , a27 out nocopy JTF_DATE_TABLE
110: , a28 out nocopy JTF_NUMBER_TABLE
111: , a29 out nocopy JTF_DATE_TABLE
112: , a30 out nocopy JTF_NUMBER_TABLE
113: ) as
114: ddindx binary_integer; indx binary_integer;
108: , a26 out nocopy JTF_NUMBER_TABLE
109: , a27 out nocopy JTF_DATE_TABLE
110: , a28 out nocopy JTF_NUMBER_TABLE
111: , a29 out nocopy JTF_DATE_TABLE
112: , a30 out nocopy JTF_NUMBER_TABLE
113: ) as
114: ddindx binary_integer; indx binary_integer;
115: begin
116: if t is null or t.count = 0 then
113: ) as
114: ddindx binary_integer; indx binary_integer;
115: begin
116: if t is null or t.count = 0 then
117: a0 := JTF_NUMBER_TABLE();
118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_NUMBER_TABLE();
120: a3 := JTF_VARCHAR2_TABLE_100();
121: a4 := JTF_VARCHAR2_TABLE_400();
114: ddindx binary_integer; indx binary_integer;
115: begin
116: if t is null or t.count = 0 then
117: a0 := JTF_NUMBER_TABLE();
118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_NUMBER_TABLE();
120: a3 := JTF_VARCHAR2_TABLE_100();
121: a4 := JTF_VARCHAR2_TABLE_400();
122: a5 := JTF_VARCHAR2_TABLE_2000();
115: begin
116: if t is null or t.count = 0 then
117: a0 := JTF_NUMBER_TABLE();
118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_NUMBER_TABLE();
120: a3 := JTF_VARCHAR2_TABLE_100();
121: a4 := JTF_VARCHAR2_TABLE_400();
122: a5 := JTF_VARCHAR2_TABLE_2000();
123: a6 := JTF_VARCHAR2_TABLE_100();
135: a18 := JTF_VARCHAR2_TABLE_500();
136: a19 := JTF_VARCHAR2_TABLE_500();
137: a20 := JTF_VARCHAR2_TABLE_500();
138: a21 := JTF_VARCHAR2_TABLE_500();
139: a22 := JTF_NUMBER_TABLE();
140: a23 := JTF_NUMBER_TABLE();
141: a24 := JTF_NUMBER_TABLE();
142: a25 := JTF_DATE_TABLE();
143: a26 := JTF_NUMBER_TABLE();
136: a19 := JTF_VARCHAR2_TABLE_500();
137: a20 := JTF_VARCHAR2_TABLE_500();
138: a21 := JTF_VARCHAR2_TABLE_500();
139: a22 := JTF_NUMBER_TABLE();
140: a23 := JTF_NUMBER_TABLE();
141: a24 := JTF_NUMBER_TABLE();
142: a25 := JTF_DATE_TABLE();
143: a26 := JTF_NUMBER_TABLE();
144: a27 := JTF_DATE_TABLE();
137: a20 := JTF_VARCHAR2_TABLE_500();
138: a21 := JTF_VARCHAR2_TABLE_500();
139: a22 := JTF_NUMBER_TABLE();
140: a23 := JTF_NUMBER_TABLE();
141: a24 := JTF_NUMBER_TABLE();
142: a25 := JTF_DATE_TABLE();
143: a26 := JTF_NUMBER_TABLE();
144: a27 := JTF_DATE_TABLE();
145: a28 := JTF_NUMBER_TABLE();
139: a22 := JTF_NUMBER_TABLE();
140: a23 := JTF_NUMBER_TABLE();
141: a24 := JTF_NUMBER_TABLE();
142: a25 := JTF_DATE_TABLE();
143: a26 := JTF_NUMBER_TABLE();
144: a27 := JTF_DATE_TABLE();
145: a28 := JTF_NUMBER_TABLE();
146: a29 := JTF_DATE_TABLE();
147: a30 := JTF_NUMBER_TABLE();
141: a24 := JTF_NUMBER_TABLE();
142: a25 := JTF_DATE_TABLE();
143: a26 := JTF_NUMBER_TABLE();
144: a27 := JTF_DATE_TABLE();
145: a28 := JTF_NUMBER_TABLE();
146: a29 := JTF_DATE_TABLE();
147: a30 := JTF_NUMBER_TABLE();
148: else
149: a0 := JTF_NUMBER_TABLE();
143: a26 := JTF_NUMBER_TABLE();
144: a27 := JTF_DATE_TABLE();
145: a28 := JTF_NUMBER_TABLE();
146: a29 := JTF_DATE_TABLE();
147: a30 := JTF_NUMBER_TABLE();
148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_NUMBER_TABLE();
151: a2 := JTF_NUMBER_TABLE();
145: a28 := JTF_NUMBER_TABLE();
146: a29 := JTF_DATE_TABLE();
147: a30 := JTF_NUMBER_TABLE();
148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_NUMBER_TABLE();
151: a2 := JTF_NUMBER_TABLE();
152: a3 := JTF_VARCHAR2_TABLE_100();
153: a4 := JTF_VARCHAR2_TABLE_400();
146: a29 := JTF_DATE_TABLE();
147: a30 := JTF_NUMBER_TABLE();
148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_NUMBER_TABLE();
151: a2 := JTF_NUMBER_TABLE();
152: a3 := JTF_VARCHAR2_TABLE_100();
153: a4 := JTF_VARCHAR2_TABLE_400();
154: a5 := JTF_VARCHAR2_TABLE_2000();
147: a30 := JTF_NUMBER_TABLE();
148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_NUMBER_TABLE();
151: a2 := JTF_NUMBER_TABLE();
152: a3 := JTF_VARCHAR2_TABLE_100();
153: a4 := JTF_VARCHAR2_TABLE_400();
154: a5 := JTF_VARCHAR2_TABLE_2000();
155: a6 := JTF_VARCHAR2_TABLE_100();
167: a18 := JTF_VARCHAR2_TABLE_500();
168: a19 := JTF_VARCHAR2_TABLE_500();
169: a20 := JTF_VARCHAR2_TABLE_500();
170: a21 := JTF_VARCHAR2_TABLE_500();
171: a22 := JTF_NUMBER_TABLE();
172: a23 := JTF_NUMBER_TABLE();
173: a24 := JTF_NUMBER_TABLE();
174: a25 := JTF_DATE_TABLE();
175: a26 := JTF_NUMBER_TABLE();
168: a19 := JTF_VARCHAR2_TABLE_500();
169: a20 := JTF_VARCHAR2_TABLE_500();
170: a21 := JTF_VARCHAR2_TABLE_500();
171: a22 := JTF_NUMBER_TABLE();
172: a23 := JTF_NUMBER_TABLE();
173: a24 := JTF_NUMBER_TABLE();
174: a25 := JTF_DATE_TABLE();
175: a26 := JTF_NUMBER_TABLE();
176: a27 := JTF_DATE_TABLE();
169: a20 := JTF_VARCHAR2_TABLE_500();
170: a21 := JTF_VARCHAR2_TABLE_500();
171: a22 := JTF_NUMBER_TABLE();
172: a23 := JTF_NUMBER_TABLE();
173: a24 := JTF_NUMBER_TABLE();
174: a25 := JTF_DATE_TABLE();
175: a26 := JTF_NUMBER_TABLE();
176: a27 := JTF_DATE_TABLE();
177: a28 := JTF_NUMBER_TABLE();
171: a22 := JTF_NUMBER_TABLE();
172: a23 := JTF_NUMBER_TABLE();
173: a24 := JTF_NUMBER_TABLE();
174: a25 := JTF_DATE_TABLE();
175: a26 := JTF_NUMBER_TABLE();
176: a27 := JTF_DATE_TABLE();
177: a28 := JTF_NUMBER_TABLE();
178: a29 := JTF_DATE_TABLE();
179: a30 := JTF_NUMBER_TABLE();
173: a24 := JTF_NUMBER_TABLE();
174: a25 := JTF_DATE_TABLE();
175: a26 := JTF_NUMBER_TABLE();
176: a27 := JTF_DATE_TABLE();
177: a28 := JTF_NUMBER_TABLE();
178: a29 := JTF_DATE_TABLE();
179: a30 := JTF_NUMBER_TABLE();
180: if t.count > 0 then
181: a0.extend(t.count);
175: a26 := JTF_NUMBER_TABLE();
176: a27 := JTF_DATE_TABLE();
177: a28 := JTF_NUMBER_TABLE();
178: a29 := JTF_DATE_TABLE();
179: a30 := JTF_NUMBER_TABLE();
180: if t.count > 0 then
181: a0.extend(t.count);
182: a1.extend(t.count);
183: a2.extend(t.count);
252: end if;
253: end if;
254: end rosetta_table_copy_out_p2;
255:
256: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
257: , a1 JTF_NUMBER_TABLE
258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_VARCHAR2_TABLE_100
260: , a4 JTF_VARCHAR2_TABLE_400
253: end if;
254: end rosetta_table_copy_out_p2;
255:
256: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
257: , a1 JTF_NUMBER_TABLE
258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_VARCHAR2_TABLE_100
260: , a4 JTF_VARCHAR2_TABLE_400
261: , a5 JTF_VARCHAR2_TABLE_2000
254: end rosetta_table_copy_out_p2;
255:
256: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
257: , a1 JTF_NUMBER_TABLE
258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_VARCHAR2_TABLE_100
260: , a4 JTF_VARCHAR2_TABLE_400
261: , a5 JTF_VARCHAR2_TABLE_2000
262: , a6 JTF_VARCHAR2_TABLE_100
274: , a18 JTF_VARCHAR2_TABLE_500
275: , a19 JTF_VARCHAR2_TABLE_500
276: , a20 JTF_VARCHAR2_TABLE_500
277: , a21 JTF_VARCHAR2_TABLE_500
278: , a22 JTF_NUMBER_TABLE
279: , a23 JTF_NUMBER_TABLE
280: , a24 JTF_NUMBER_TABLE
281: , a25 JTF_DATE_TABLE
282: , a26 JTF_NUMBER_TABLE
275: , a19 JTF_VARCHAR2_TABLE_500
276: , a20 JTF_VARCHAR2_TABLE_500
277: , a21 JTF_VARCHAR2_TABLE_500
278: , a22 JTF_NUMBER_TABLE
279: , a23 JTF_NUMBER_TABLE
280: , a24 JTF_NUMBER_TABLE
281: , a25 JTF_DATE_TABLE
282: , a26 JTF_NUMBER_TABLE
283: , a27 JTF_DATE_TABLE
276: , a20 JTF_VARCHAR2_TABLE_500
277: , a21 JTF_VARCHAR2_TABLE_500
278: , a22 JTF_NUMBER_TABLE
279: , a23 JTF_NUMBER_TABLE
280: , a24 JTF_NUMBER_TABLE
281: , a25 JTF_DATE_TABLE
282: , a26 JTF_NUMBER_TABLE
283: , a27 JTF_DATE_TABLE
284: , a28 JTF_NUMBER_TABLE
278: , a22 JTF_NUMBER_TABLE
279: , a23 JTF_NUMBER_TABLE
280: , a24 JTF_NUMBER_TABLE
281: , a25 JTF_DATE_TABLE
282: , a26 JTF_NUMBER_TABLE
283: , a27 JTF_DATE_TABLE
284: , a28 JTF_NUMBER_TABLE
285: , a29 JTF_DATE_TABLE
286: , a30 JTF_NUMBER_TABLE
280: , a24 JTF_NUMBER_TABLE
281: , a25 JTF_DATE_TABLE
282: , a26 JTF_NUMBER_TABLE
283: , a27 JTF_DATE_TABLE
284: , a28 JTF_NUMBER_TABLE
285: , a29 JTF_DATE_TABLE
286: , a30 JTF_NUMBER_TABLE
287: ) as
288: ddindx binary_integer; indx binary_integer;
282: , a26 JTF_NUMBER_TABLE
283: , a27 JTF_DATE_TABLE
284: , a28 JTF_NUMBER_TABLE
285: , a29 JTF_DATE_TABLE
286: , a30 JTF_NUMBER_TABLE
287: ) as
288: ddindx binary_integer; indx binary_integer;
289: begin
290: if a0 is not null and a0.count > 0 then
331: end loop;
332: end if;
333: end if;
334: end rosetta_table_copy_in_p5;
335: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
336: , a1 out nocopy JTF_NUMBER_TABLE
337: , a2 out nocopy JTF_NUMBER_TABLE
338: , a3 out nocopy JTF_VARCHAR2_TABLE_100
339: , a4 out nocopy JTF_VARCHAR2_TABLE_400
332: end if;
333: end if;
334: end rosetta_table_copy_in_p5;
335: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
336: , a1 out nocopy JTF_NUMBER_TABLE
337: , a2 out nocopy JTF_NUMBER_TABLE
338: , a3 out nocopy JTF_VARCHAR2_TABLE_100
339: , a4 out nocopy JTF_VARCHAR2_TABLE_400
340: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
333: end if;
334: end rosetta_table_copy_in_p5;
335: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
336: , a1 out nocopy JTF_NUMBER_TABLE
337: , a2 out nocopy JTF_NUMBER_TABLE
338: , a3 out nocopy JTF_VARCHAR2_TABLE_100
339: , a4 out nocopy JTF_VARCHAR2_TABLE_400
340: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
341: , a6 out nocopy JTF_VARCHAR2_TABLE_100
353: , a18 out nocopy JTF_VARCHAR2_TABLE_500
354: , a19 out nocopy JTF_VARCHAR2_TABLE_500
355: , a20 out nocopy JTF_VARCHAR2_TABLE_500
356: , a21 out nocopy JTF_VARCHAR2_TABLE_500
357: , a22 out nocopy JTF_NUMBER_TABLE
358: , a23 out nocopy JTF_NUMBER_TABLE
359: , a24 out nocopy JTF_NUMBER_TABLE
360: , a25 out nocopy JTF_DATE_TABLE
361: , a26 out nocopy JTF_NUMBER_TABLE
354: , a19 out nocopy JTF_VARCHAR2_TABLE_500
355: , a20 out nocopy JTF_VARCHAR2_TABLE_500
356: , a21 out nocopy JTF_VARCHAR2_TABLE_500
357: , a22 out nocopy JTF_NUMBER_TABLE
358: , a23 out nocopy JTF_NUMBER_TABLE
359: , a24 out nocopy JTF_NUMBER_TABLE
360: , a25 out nocopy JTF_DATE_TABLE
361: , a26 out nocopy JTF_NUMBER_TABLE
362: , a27 out nocopy JTF_DATE_TABLE
355: , a20 out nocopy JTF_VARCHAR2_TABLE_500
356: , a21 out nocopy JTF_VARCHAR2_TABLE_500
357: , a22 out nocopy JTF_NUMBER_TABLE
358: , a23 out nocopy JTF_NUMBER_TABLE
359: , a24 out nocopy JTF_NUMBER_TABLE
360: , a25 out nocopy JTF_DATE_TABLE
361: , a26 out nocopy JTF_NUMBER_TABLE
362: , a27 out nocopy JTF_DATE_TABLE
363: , a28 out nocopy JTF_NUMBER_TABLE
357: , a22 out nocopy JTF_NUMBER_TABLE
358: , a23 out nocopy JTF_NUMBER_TABLE
359: , a24 out nocopy JTF_NUMBER_TABLE
360: , a25 out nocopy JTF_DATE_TABLE
361: , a26 out nocopy JTF_NUMBER_TABLE
362: , a27 out nocopy JTF_DATE_TABLE
363: , a28 out nocopy JTF_NUMBER_TABLE
364: , a29 out nocopy JTF_DATE_TABLE
365: , a30 out nocopy JTF_NUMBER_TABLE
359: , a24 out nocopy JTF_NUMBER_TABLE
360: , a25 out nocopy JTF_DATE_TABLE
361: , a26 out nocopy JTF_NUMBER_TABLE
362: , a27 out nocopy JTF_DATE_TABLE
363: , a28 out nocopy JTF_NUMBER_TABLE
364: , a29 out nocopy JTF_DATE_TABLE
365: , a30 out nocopy JTF_NUMBER_TABLE
366: ) as
367: ddindx binary_integer; indx binary_integer;
361: , a26 out nocopy JTF_NUMBER_TABLE
362: , a27 out nocopy JTF_DATE_TABLE
363: , a28 out nocopy JTF_NUMBER_TABLE
364: , a29 out nocopy JTF_DATE_TABLE
365: , a30 out nocopy JTF_NUMBER_TABLE
366: ) as
367: ddindx binary_integer; indx binary_integer;
368: begin
369: if t is null or t.count = 0 then
366: ) as
367: ddindx binary_integer; indx binary_integer;
368: begin
369: if t is null or t.count = 0 then
370: a0 := JTF_NUMBER_TABLE();
371: a1 := JTF_NUMBER_TABLE();
372: a2 := JTF_NUMBER_TABLE();
373: a3 := JTF_VARCHAR2_TABLE_100();
374: a4 := JTF_VARCHAR2_TABLE_400();
367: ddindx binary_integer; indx binary_integer;
368: begin
369: if t is null or t.count = 0 then
370: a0 := JTF_NUMBER_TABLE();
371: a1 := JTF_NUMBER_TABLE();
372: a2 := JTF_NUMBER_TABLE();
373: a3 := JTF_VARCHAR2_TABLE_100();
374: a4 := JTF_VARCHAR2_TABLE_400();
375: a5 := JTF_VARCHAR2_TABLE_2000();
368: begin
369: if t is null or t.count = 0 then
370: a0 := JTF_NUMBER_TABLE();
371: a1 := JTF_NUMBER_TABLE();
372: a2 := JTF_NUMBER_TABLE();
373: a3 := JTF_VARCHAR2_TABLE_100();
374: a4 := JTF_VARCHAR2_TABLE_400();
375: a5 := JTF_VARCHAR2_TABLE_2000();
376: a6 := JTF_VARCHAR2_TABLE_100();
388: a18 := JTF_VARCHAR2_TABLE_500();
389: a19 := JTF_VARCHAR2_TABLE_500();
390: a20 := JTF_VARCHAR2_TABLE_500();
391: a21 := JTF_VARCHAR2_TABLE_500();
392: a22 := JTF_NUMBER_TABLE();
393: a23 := JTF_NUMBER_TABLE();
394: a24 := JTF_NUMBER_TABLE();
395: a25 := JTF_DATE_TABLE();
396: a26 := JTF_NUMBER_TABLE();
389: a19 := JTF_VARCHAR2_TABLE_500();
390: a20 := JTF_VARCHAR2_TABLE_500();
391: a21 := JTF_VARCHAR2_TABLE_500();
392: a22 := JTF_NUMBER_TABLE();
393: a23 := JTF_NUMBER_TABLE();
394: a24 := JTF_NUMBER_TABLE();
395: a25 := JTF_DATE_TABLE();
396: a26 := JTF_NUMBER_TABLE();
397: a27 := JTF_DATE_TABLE();
390: a20 := JTF_VARCHAR2_TABLE_500();
391: a21 := JTF_VARCHAR2_TABLE_500();
392: a22 := JTF_NUMBER_TABLE();
393: a23 := JTF_NUMBER_TABLE();
394: a24 := JTF_NUMBER_TABLE();
395: a25 := JTF_DATE_TABLE();
396: a26 := JTF_NUMBER_TABLE();
397: a27 := JTF_DATE_TABLE();
398: a28 := JTF_NUMBER_TABLE();
392: a22 := JTF_NUMBER_TABLE();
393: a23 := JTF_NUMBER_TABLE();
394: a24 := JTF_NUMBER_TABLE();
395: a25 := JTF_DATE_TABLE();
396: a26 := JTF_NUMBER_TABLE();
397: a27 := JTF_DATE_TABLE();
398: a28 := JTF_NUMBER_TABLE();
399: a29 := JTF_DATE_TABLE();
400: a30 := JTF_NUMBER_TABLE();
394: a24 := JTF_NUMBER_TABLE();
395: a25 := JTF_DATE_TABLE();
396: a26 := JTF_NUMBER_TABLE();
397: a27 := JTF_DATE_TABLE();
398: a28 := JTF_NUMBER_TABLE();
399: a29 := JTF_DATE_TABLE();
400: a30 := JTF_NUMBER_TABLE();
401: else
402: a0 := JTF_NUMBER_TABLE();
396: a26 := JTF_NUMBER_TABLE();
397: a27 := JTF_DATE_TABLE();
398: a28 := JTF_NUMBER_TABLE();
399: a29 := JTF_DATE_TABLE();
400: a30 := JTF_NUMBER_TABLE();
401: else
402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: a2 := JTF_NUMBER_TABLE();
398: a28 := JTF_NUMBER_TABLE();
399: a29 := JTF_DATE_TABLE();
400: a30 := JTF_NUMBER_TABLE();
401: else
402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: a2 := JTF_NUMBER_TABLE();
405: a3 := JTF_VARCHAR2_TABLE_100();
406: a4 := JTF_VARCHAR2_TABLE_400();
399: a29 := JTF_DATE_TABLE();
400: a30 := JTF_NUMBER_TABLE();
401: else
402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: a2 := JTF_NUMBER_TABLE();
405: a3 := JTF_VARCHAR2_TABLE_100();
406: a4 := JTF_VARCHAR2_TABLE_400();
407: a5 := JTF_VARCHAR2_TABLE_2000();
400: a30 := JTF_NUMBER_TABLE();
401: else
402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: a2 := JTF_NUMBER_TABLE();
405: a3 := JTF_VARCHAR2_TABLE_100();
406: a4 := JTF_VARCHAR2_TABLE_400();
407: a5 := JTF_VARCHAR2_TABLE_2000();
408: a6 := JTF_VARCHAR2_TABLE_100();
420: a18 := JTF_VARCHAR2_TABLE_500();
421: a19 := JTF_VARCHAR2_TABLE_500();
422: a20 := JTF_VARCHAR2_TABLE_500();
423: a21 := JTF_VARCHAR2_TABLE_500();
424: a22 := JTF_NUMBER_TABLE();
425: a23 := JTF_NUMBER_TABLE();
426: a24 := JTF_NUMBER_TABLE();
427: a25 := JTF_DATE_TABLE();
428: a26 := JTF_NUMBER_TABLE();
421: a19 := JTF_VARCHAR2_TABLE_500();
422: a20 := JTF_VARCHAR2_TABLE_500();
423: a21 := JTF_VARCHAR2_TABLE_500();
424: a22 := JTF_NUMBER_TABLE();
425: a23 := JTF_NUMBER_TABLE();
426: a24 := JTF_NUMBER_TABLE();
427: a25 := JTF_DATE_TABLE();
428: a26 := JTF_NUMBER_TABLE();
429: a27 := JTF_DATE_TABLE();
422: a20 := JTF_VARCHAR2_TABLE_500();
423: a21 := JTF_VARCHAR2_TABLE_500();
424: a22 := JTF_NUMBER_TABLE();
425: a23 := JTF_NUMBER_TABLE();
426: a24 := JTF_NUMBER_TABLE();
427: a25 := JTF_DATE_TABLE();
428: a26 := JTF_NUMBER_TABLE();
429: a27 := JTF_DATE_TABLE();
430: a28 := JTF_NUMBER_TABLE();
424: a22 := JTF_NUMBER_TABLE();
425: a23 := JTF_NUMBER_TABLE();
426: a24 := JTF_NUMBER_TABLE();
427: a25 := JTF_DATE_TABLE();
428: a26 := JTF_NUMBER_TABLE();
429: a27 := JTF_DATE_TABLE();
430: a28 := JTF_NUMBER_TABLE();
431: a29 := JTF_DATE_TABLE();
432: a30 := JTF_NUMBER_TABLE();
426: a24 := JTF_NUMBER_TABLE();
427: a25 := JTF_DATE_TABLE();
428: a26 := JTF_NUMBER_TABLE();
429: a27 := JTF_DATE_TABLE();
430: a28 := JTF_NUMBER_TABLE();
431: a29 := JTF_DATE_TABLE();
432: a30 := JTF_NUMBER_TABLE();
433: if t.count > 0 then
434: a0.extend(t.count);
428: a26 := JTF_NUMBER_TABLE();
429: a27 := JTF_DATE_TABLE();
430: a28 := JTF_NUMBER_TABLE();
431: a29 := JTF_DATE_TABLE();
432: a30 := JTF_NUMBER_TABLE();
433: if t.count > 0 then
434: a0.extend(t.count);
435: a1.extend(t.count);
436: a2.extend(t.count);
673: , p_init_msg_list VARCHAR2
674: , x_return_status out nocopy VARCHAR2
675: , x_msg_count out nocopy NUMBER
676: , x_msg_data out nocopy VARCHAR2
677: , p5_a0 JTF_NUMBER_TABLE
678: , p5_a1 JTF_NUMBER_TABLE
679: , p5_a2 JTF_NUMBER_TABLE
680: , p5_a3 JTF_VARCHAR2_TABLE_100
681: , p5_a4 JTF_VARCHAR2_TABLE_400
674: , x_return_status out nocopy VARCHAR2
675: , x_msg_count out nocopy NUMBER
676: , x_msg_data out nocopy VARCHAR2
677: , p5_a0 JTF_NUMBER_TABLE
678: , p5_a1 JTF_NUMBER_TABLE
679: , p5_a2 JTF_NUMBER_TABLE
680: , p5_a3 JTF_VARCHAR2_TABLE_100
681: , p5_a4 JTF_VARCHAR2_TABLE_400
682: , p5_a5 JTF_VARCHAR2_TABLE_2000
675: , x_msg_count out nocopy NUMBER
676: , x_msg_data out nocopy VARCHAR2
677: , p5_a0 JTF_NUMBER_TABLE
678: , p5_a1 JTF_NUMBER_TABLE
679: , p5_a2 JTF_NUMBER_TABLE
680: , p5_a3 JTF_VARCHAR2_TABLE_100
681: , p5_a4 JTF_VARCHAR2_TABLE_400
682: , p5_a5 JTF_VARCHAR2_TABLE_2000
683: , p5_a6 JTF_VARCHAR2_TABLE_100
695: , p5_a18 JTF_VARCHAR2_TABLE_500
696: , p5_a19 JTF_VARCHAR2_TABLE_500
697: , p5_a20 JTF_VARCHAR2_TABLE_500
698: , p5_a21 JTF_VARCHAR2_TABLE_500
699: , p5_a22 JTF_NUMBER_TABLE
700: , p5_a23 JTF_NUMBER_TABLE
701: , p5_a24 JTF_NUMBER_TABLE
702: , p5_a25 JTF_DATE_TABLE
703: , p5_a26 JTF_NUMBER_TABLE
696: , p5_a19 JTF_VARCHAR2_TABLE_500
697: , p5_a20 JTF_VARCHAR2_TABLE_500
698: , p5_a21 JTF_VARCHAR2_TABLE_500
699: , p5_a22 JTF_NUMBER_TABLE
700: , p5_a23 JTF_NUMBER_TABLE
701: , p5_a24 JTF_NUMBER_TABLE
702: , p5_a25 JTF_DATE_TABLE
703: , p5_a26 JTF_NUMBER_TABLE
704: , p5_a27 JTF_DATE_TABLE
697: , p5_a20 JTF_VARCHAR2_TABLE_500
698: , p5_a21 JTF_VARCHAR2_TABLE_500
699: , p5_a22 JTF_NUMBER_TABLE
700: , p5_a23 JTF_NUMBER_TABLE
701: , p5_a24 JTF_NUMBER_TABLE
702: , p5_a25 JTF_DATE_TABLE
703: , p5_a26 JTF_NUMBER_TABLE
704: , p5_a27 JTF_DATE_TABLE
705: , p5_a28 JTF_NUMBER_TABLE
699: , p5_a22 JTF_NUMBER_TABLE
700: , p5_a23 JTF_NUMBER_TABLE
701: , p5_a24 JTF_NUMBER_TABLE
702: , p5_a25 JTF_DATE_TABLE
703: , p5_a26 JTF_NUMBER_TABLE
704: , p5_a27 JTF_DATE_TABLE
705: , p5_a28 JTF_NUMBER_TABLE
706: , p5_a29 JTF_DATE_TABLE
707: , p5_a30 JTF_NUMBER_TABLE
701: , p5_a24 JTF_NUMBER_TABLE
702: , p5_a25 JTF_DATE_TABLE
703: , p5_a26 JTF_NUMBER_TABLE
704: , p5_a27 JTF_DATE_TABLE
705: , p5_a28 JTF_NUMBER_TABLE
706: , p5_a29 JTF_DATE_TABLE
707: , p5_a30 JTF_NUMBER_TABLE
708: , p6_a0 out nocopy JTF_NUMBER_TABLE
709: , p6_a1 out nocopy JTF_NUMBER_TABLE
703: , p5_a26 JTF_NUMBER_TABLE
704: , p5_a27 JTF_DATE_TABLE
705: , p5_a28 JTF_NUMBER_TABLE
706: , p5_a29 JTF_DATE_TABLE
707: , p5_a30 JTF_NUMBER_TABLE
708: , p6_a0 out nocopy JTF_NUMBER_TABLE
709: , p6_a1 out nocopy JTF_NUMBER_TABLE
710: , p6_a2 out nocopy JTF_NUMBER_TABLE
711: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
704: , p5_a27 JTF_DATE_TABLE
705: , p5_a28 JTF_NUMBER_TABLE
706: , p5_a29 JTF_DATE_TABLE
707: , p5_a30 JTF_NUMBER_TABLE
708: , p6_a0 out nocopy JTF_NUMBER_TABLE
709: , p6_a1 out nocopy JTF_NUMBER_TABLE
710: , p6_a2 out nocopy JTF_NUMBER_TABLE
711: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
712: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
705: , p5_a28 JTF_NUMBER_TABLE
706: , p5_a29 JTF_DATE_TABLE
707: , p5_a30 JTF_NUMBER_TABLE
708: , p6_a0 out nocopy JTF_NUMBER_TABLE
709: , p6_a1 out nocopy JTF_NUMBER_TABLE
710: , p6_a2 out nocopy JTF_NUMBER_TABLE
711: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
712: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
713: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
706: , p5_a29 JTF_DATE_TABLE
707: , p5_a30 JTF_NUMBER_TABLE
708: , p6_a0 out nocopy JTF_NUMBER_TABLE
709: , p6_a1 out nocopy JTF_NUMBER_TABLE
710: , p6_a2 out nocopy JTF_NUMBER_TABLE
711: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
712: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
713: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
714: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
726: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
727: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
728: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
729: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
730: , p6_a22 out nocopy JTF_NUMBER_TABLE
731: , p6_a23 out nocopy JTF_NUMBER_TABLE
732: , p6_a24 out nocopy JTF_NUMBER_TABLE
733: , p6_a25 out nocopy JTF_DATE_TABLE
734: , p6_a26 out nocopy JTF_NUMBER_TABLE
727: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
728: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
729: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
730: , p6_a22 out nocopy JTF_NUMBER_TABLE
731: , p6_a23 out nocopy JTF_NUMBER_TABLE
732: , p6_a24 out nocopy JTF_NUMBER_TABLE
733: , p6_a25 out nocopy JTF_DATE_TABLE
734: , p6_a26 out nocopy JTF_NUMBER_TABLE
735: , p6_a27 out nocopy JTF_DATE_TABLE
728: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
729: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
730: , p6_a22 out nocopy JTF_NUMBER_TABLE
731: , p6_a23 out nocopy JTF_NUMBER_TABLE
732: , p6_a24 out nocopy JTF_NUMBER_TABLE
733: , p6_a25 out nocopy JTF_DATE_TABLE
734: , p6_a26 out nocopy JTF_NUMBER_TABLE
735: , p6_a27 out nocopy JTF_DATE_TABLE
736: , p6_a28 out nocopy JTF_NUMBER_TABLE
730: , p6_a22 out nocopy JTF_NUMBER_TABLE
731: , p6_a23 out nocopy JTF_NUMBER_TABLE
732: , p6_a24 out nocopy JTF_NUMBER_TABLE
733: , p6_a25 out nocopy JTF_DATE_TABLE
734: , p6_a26 out nocopy JTF_NUMBER_TABLE
735: , p6_a27 out nocopy JTF_DATE_TABLE
736: , p6_a28 out nocopy JTF_NUMBER_TABLE
737: , p6_a29 out nocopy JTF_DATE_TABLE
738: , p6_a30 out nocopy JTF_NUMBER_TABLE
732: , p6_a24 out nocopy JTF_NUMBER_TABLE
733: , p6_a25 out nocopy JTF_DATE_TABLE
734: , p6_a26 out nocopy JTF_NUMBER_TABLE
735: , p6_a27 out nocopy JTF_DATE_TABLE
736: , p6_a28 out nocopy JTF_NUMBER_TABLE
737: , p6_a29 out nocopy JTF_DATE_TABLE
738: , p6_a30 out nocopy JTF_NUMBER_TABLE
739: , p7_a0 in out nocopy JTF_NUMBER_TABLE
740: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
734: , p6_a26 out nocopy JTF_NUMBER_TABLE
735: , p6_a27 out nocopy JTF_DATE_TABLE
736: , p6_a28 out nocopy JTF_NUMBER_TABLE
737: , p6_a29 out nocopy JTF_DATE_TABLE
738: , p6_a30 out nocopy JTF_NUMBER_TABLE
739: , p7_a0 in out nocopy JTF_NUMBER_TABLE
740: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p7_a2 in out nocopy JTF_NUMBER_TABLE
742: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
735: , p6_a27 out nocopy JTF_DATE_TABLE
736: , p6_a28 out nocopy JTF_NUMBER_TABLE
737: , p6_a29 out nocopy JTF_DATE_TABLE
738: , p6_a30 out nocopy JTF_NUMBER_TABLE
739: , p7_a0 in out nocopy JTF_NUMBER_TABLE
740: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p7_a2 in out nocopy JTF_NUMBER_TABLE
742: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
743: , p7_a4 in out nocopy JTF_NUMBER_TABLE
737: , p6_a29 out nocopy JTF_DATE_TABLE
738: , p6_a30 out nocopy JTF_NUMBER_TABLE
739: , p7_a0 in out nocopy JTF_NUMBER_TABLE
740: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p7_a2 in out nocopy JTF_NUMBER_TABLE
742: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
743: , p7_a4 in out nocopy JTF_NUMBER_TABLE
744: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
739: , p7_a0 in out nocopy JTF_NUMBER_TABLE
740: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p7_a2 in out nocopy JTF_NUMBER_TABLE
742: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
743: , p7_a4 in out nocopy JTF_NUMBER_TABLE
744: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
746: )
747:
865: , p_init_msg_list VARCHAR2
866: , x_return_status out nocopy VARCHAR2
867: , x_msg_count out nocopy NUMBER
868: , x_msg_data out nocopy VARCHAR2
869: , p5_a0 JTF_NUMBER_TABLE
870: , p5_a1 JTF_NUMBER_TABLE
871: , p5_a2 JTF_NUMBER_TABLE
872: , p5_a3 JTF_VARCHAR2_TABLE_100
873: , p5_a4 JTF_VARCHAR2_TABLE_400
866: , x_return_status out nocopy VARCHAR2
867: , x_msg_count out nocopy NUMBER
868: , x_msg_data out nocopy VARCHAR2
869: , p5_a0 JTF_NUMBER_TABLE
870: , p5_a1 JTF_NUMBER_TABLE
871: , p5_a2 JTF_NUMBER_TABLE
872: , p5_a3 JTF_VARCHAR2_TABLE_100
873: , p5_a4 JTF_VARCHAR2_TABLE_400
874: , p5_a5 JTF_VARCHAR2_TABLE_2000
867: , x_msg_count out nocopy NUMBER
868: , x_msg_data out nocopy VARCHAR2
869: , p5_a0 JTF_NUMBER_TABLE
870: , p5_a1 JTF_NUMBER_TABLE
871: , p5_a2 JTF_NUMBER_TABLE
872: , p5_a3 JTF_VARCHAR2_TABLE_100
873: , p5_a4 JTF_VARCHAR2_TABLE_400
874: , p5_a5 JTF_VARCHAR2_TABLE_2000
875: , p5_a6 JTF_VARCHAR2_TABLE_100
887: , p5_a18 JTF_VARCHAR2_TABLE_500
888: , p5_a19 JTF_VARCHAR2_TABLE_500
889: , p5_a20 JTF_VARCHAR2_TABLE_500
890: , p5_a21 JTF_VARCHAR2_TABLE_500
891: , p5_a22 JTF_NUMBER_TABLE
892: , p5_a23 JTF_NUMBER_TABLE
893: , p5_a24 JTF_NUMBER_TABLE
894: , p5_a25 JTF_DATE_TABLE
895: , p5_a26 JTF_NUMBER_TABLE
888: , p5_a19 JTF_VARCHAR2_TABLE_500
889: , p5_a20 JTF_VARCHAR2_TABLE_500
890: , p5_a21 JTF_VARCHAR2_TABLE_500
891: , p5_a22 JTF_NUMBER_TABLE
892: , p5_a23 JTF_NUMBER_TABLE
893: , p5_a24 JTF_NUMBER_TABLE
894: , p5_a25 JTF_DATE_TABLE
895: , p5_a26 JTF_NUMBER_TABLE
896: , p5_a27 JTF_DATE_TABLE
889: , p5_a20 JTF_VARCHAR2_TABLE_500
890: , p5_a21 JTF_VARCHAR2_TABLE_500
891: , p5_a22 JTF_NUMBER_TABLE
892: , p5_a23 JTF_NUMBER_TABLE
893: , p5_a24 JTF_NUMBER_TABLE
894: , p5_a25 JTF_DATE_TABLE
895: , p5_a26 JTF_NUMBER_TABLE
896: , p5_a27 JTF_DATE_TABLE
897: , p5_a28 JTF_NUMBER_TABLE
891: , p5_a22 JTF_NUMBER_TABLE
892: , p5_a23 JTF_NUMBER_TABLE
893: , p5_a24 JTF_NUMBER_TABLE
894: , p5_a25 JTF_DATE_TABLE
895: , p5_a26 JTF_NUMBER_TABLE
896: , p5_a27 JTF_DATE_TABLE
897: , p5_a28 JTF_NUMBER_TABLE
898: , p5_a29 JTF_DATE_TABLE
899: , p5_a30 JTF_NUMBER_TABLE
893: , p5_a24 JTF_NUMBER_TABLE
894: , p5_a25 JTF_DATE_TABLE
895: , p5_a26 JTF_NUMBER_TABLE
896: , p5_a27 JTF_DATE_TABLE
897: , p5_a28 JTF_NUMBER_TABLE
898: , p5_a29 JTF_DATE_TABLE
899: , p5_a30 JTF_NUMBER_TABLE
900: , p6_a0 out nocopy JTF_NUMBER_TABLE
901: , p6_a1 out nocopy JTF_NUMBER_TABLE
895: , p5_a26 JTF_NUMBER_TABLE
896: , p5_a27 JTF_DATE_TABLE
897: , p5_a28 JTF_NUMBER_TABLE
898: , p5_a29 JTF_DATE_TABLE
899: , p5_a30 JTF_NUMBER_TABLE
900: , p6_a0 out nocopy JTF_NUMBER_TABLE
901: , p6_a1 out nocopy JTF_NUMBER_TABLE
902: , p6_a2 out nocopy JTF_NUMBER_TABLE
903: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
896: , p5_a27 JTF_DATE_TABLE
897: , p5_a28 JTF_NUMBER_TABLE
898: , p5_a29 JTF_DATE_TABLE
899: , p5_a30 JTF_NUMBER_TABLE
900: , p6_a0 out nocopy JTF_NUMBER_TABLE
901: , p6_a1 out nocopy JTF_NUMBER_TABLE
902: , p6_a2 out nocopy JTF_NUMBER_TABLE
903: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
904: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
897: , p5_a28 JTF_NUMBER_TABLE
898: , p5_a29 JTF_DATE_TABLE
899: , p5_a30 JTF_NUMBER_TABLE
900: , p6_a0 out nocopy JTF_NUMBER_TABLE
901: , p6_a1 out nocopy JTF_NUMBER_TABLE
902: , p6_a2 out nocopy JTF_NUMBER_TABLE
903: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
904: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
905: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
898: , p5_a29 JTF_DATE_TABLE
899: , p5_a30 JTF_NUMBER_TABLE
900: , p6_a0 out nocopy JTF_NUMBER_TABLE
901: , p6_a1 out nocopy JTF_NUMBER_TABLE
902: , p6_a2 out nocopy JTF_NUMBER_TABLE
903: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
904: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
905: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
906: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
918: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
919: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
920: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
921: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
922: , p6_a22 out nocopy JTF_NUMBER_TABLE
923: , p6_a23 out nocopy JTF_NUMBER_TABLE
924: , p6_a24 out nocopy JTF_NUMBER_TABLE
925: , p6_a25 out nocopy JTF_DATE_TABLE
926: , p6_a26 out nocopy JTF_NUMBER_TABLE
919: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
920: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
921: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
922: , p6_a22 out nocopy JTF_NUMBER_TABLE
923: , p6_a23 out nocopy JTF_NUMBER_TABLE
924: , p6_a24 out nocopy JTF_NUMBER_TABLE
925: , p6_a25 out nocopy JTF_DATE_TABLE
926: , p6_a26 out nocopy JTF_NUMBER_TABLE
927: , p6_a27 out nocopy JTF_DATE_TABLE
920: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
921: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
922: , p6_a22 out nocopy JTF_NUMBER_TABLE
923: , p6_a23 out nocopy JTF_NUMBER_TABLE
924: , p6_a24 out nocopy JTF_NUMBER_TABLE
925: , p6_a25 out nocopy JTF_DATE_TABLE
926: , p6_a26 out nocopy JTF_NUMBER_TABLE
927: , p6_a27 out nocopy JTF_DATE_TABLE
928: , p6_a28 out nocopy JTF_NUMBER_TABLE
922: , p6_a22 out nocopy JTF_NUMBER_TABLE
923: , p6_a23 out nocopy JTF_NUMBER_TABLE
924: , p6_a24 out nocopy JTF_NUMBER_TABLE
925: , p6_a25 out nocopy JTF_DATE_TABLE
926: , p6_a26 out nocopy JTF_NUMBER_TABLE
927: , p6_a27 out nocopy JTF_DATE_TABLE
928: , p6_a28 out nocopy JTF_NUMBER_TABLE
929: , p6_a29 out nocopy JTF_DATE_TABLE
930: , p6_a30 out nocopy JTF_NUMBER_TABLE
924: , p6_a24 out nocopy JTF_NUMBER_TABLE
925: , p6_a25 out nocopy JTF_DATE_TABLE
926: , p6_a26 out nocopy JTF_NUMBER_TABLE
927: , p6_a27 out nocopy JTF_DATE_TABLE
928: , p6_a28 out nocopy JTF_NUMBER_TABLE
929: , p6_a29 out nocopy JTF_DATE_TABLE
930: , p6_a30 out nocopy JTF_NUMBER_TABLE
931: )
932:
926: , p6_a26 out nocopy JTF_NUMBER_TABLE
927: , p6_a27 out nocopy JTF_DATE_TABLE
928: , p6_a28 out nocopy JTF_NUMBER_TABLE
929: , p6_a29 out nocopy JTF_DATE_TABLE
930: , p6_a30 out nocopy JTF_NUMBER_TABLE
931: )
932:
933: as
934: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1127: , p_init_msg_list VARCHAR2
1128: , x_return_status out nocopy VARCHAR2
1129: , x_msg_count out nocopy NUMBER
1130: , x_msg_data out nocopy VARCHAR2
1131: , p5_a0 JTF_NUMBER_TABLE
1132: , p5_a1 JTF_NUMBER_TABLE
1133: , p5_a2 JTF_NUMBER_TABLE
1134: , p5_a3 JTF_VARCHAR2_TABLE_100
1135: , p5_a4 JTF_VARCHAR2_TABLE_400
1128: , x_return_status out nocopy VARCHAR2
1129: , x_msg_count out nocopy NUMBER
1130: , x_msg_data out nocopy VARCHAR2
1131: , p5_a0 JTF_NUMBER_TABLE
1132: , p5_a1 JTF_NUMBER_TABLE
1133: , p5_a2 JTF_NUMBER_TABLE
1134: , p5_a3 JTF_VARCHAR2_TABLE_100
1135: , p5_a4 JTF_VARCHAR2_TABLE_400
1136: , p5_a5 JTF_VARCHAR2_TABLE_2000
1129: , x_msg_count out nocopy NUMBER
1130: , x_msg_data out nocopy VARCHAR2
1131: , p5_a0 JTF_NUMBER_TABLE
1132: , p5_a1 JTF_NUMBER_TABLE
1133: , p5_a2 JTF_NUMBER_TABLE
1134: , p5_a3 JTF_VARCHAR2_TABLE_100
1135: , p5_a4 JTF_VARCHAR2_TABLE_400
1136: , p5_a5 JTF_VARCHAR2_TABLE_2000
1137: , p5_a6 JTF_VARCHAR2_TABLE_100
1149: , p5_a18 JTF_VARCHAR2_TABLE_500
1150: , p5_a19 JTF_VARCHAR2_TABLE_500
1151: , p5_a20 JTF_VARCHAR2_TABLE_500
1152: , p5_a21 JTF_VARCHAR2_TABLE_500
1153: , p5_a22 JTF_NUMBER_TABLE
1154: , p5_a23 JTF_NUMBER_TABLE
1155: , p5_a24 JTF_NUMBER_TABLE
1156: , p5_a25 JTF_DATE_TABLE
1157: , p5_a26 JTF_NUMBER_TABLE
1150: , p5_a19 JTF_VARCHAR2_TABLE_500
1151: , p5_a20 JTF_VARCHAR2_TABLE_500
1152: , p5_a21 JTF_VARCHAR2_TABLE_500
1153: , p5_a22 JTF_NUMBER_TABLE
1154: , p5_a23 JTF_NUMBER_TABLE
1155: , p5_a24 JTF_NUMBER_TABLE
1156: , p5_a25 JTF_DATE_TABLE
1157: , p5_a26 JTF_NUMBER_TABLE
1158: , p5_a27 JTF_DATE_TABLE
1151: , p5_a20 JTF_VARCHAR2_TABLE_500
1152: , p5_a21 JTF_VARCHAR2_TABLE_500
1153: , p5_a22 JTF_NUMBER_TABLE
1154: , p5_a23 JTF_NUMBER_TABLE
1155: , p5_a24 JTF_NUMBER_TABLE
1156: , p5_a25 JTF_DATE_TABLE
1157: , p5_a26 JTF_NUMBER_TABLE
1158: , p5_a27 JTF_DATE_TABLE
1159: , p5_a28 JTF_NUMBER_TABLE
1153: , p5_a22 JTF_NUMBER_TABLE
1154: , p5_a23 JTF_NUMBER_TABLE
1155: , p5_a24 JTF_NUMBER_TABLE
1156: , p5_a25 JTF_DATE_TABLE
1157: , p5_a26 JTF_NUMBER_TABLE
1158: , p5_a27 JTF_DATE_TABLE
1159: , p5_a28 JTF_NUMBER_TABLE
1160: , p5_a29 JTF_DATE_TABLE
1161: , p5_a30 JTF_NUMBER_TABLE
1155: , p5_a24 JTF_NUMBER_TABLE
1156: , p5_a25 JTF_DATE_TABLE
1157: , p5_a26 JTF_NUMBER_TABLE
1158: , p5_a27 JTF_DATE_TABLE
1159: , p5_a28 JTF_NUMBER_TABLE
1160: , p5_a29 JTF_DATE_TABLE
1161: , p5_a30 JTF_NUMBER_TABLE
1162: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1157: , p5_a26 JTF_NUMBER_TABLE
1158: , p5_a27 JTF_DATE_TABLE
1159: , p5_a28 JTF_NUMBER_TABLE
1160: , p5_a29 JTF_DATE_TABLE
1161: , p5_a30 JTF_NUMBER_TABLE
1162: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1158: , p5_a27 JTF_DATE_TABLE
1159: , p5_a28 JTF_NUMBER_TABLE
1160: , p5_a29 JTF_DATE_TABLE
1161: , p5_a30 JTF_NUMBER_TABLE
1162: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1166: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1160: , p5_a29 JTF_DATE_TABLE
1161: , p5_a30 JTF_NUMBER_TABLE
1162: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1166: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1167: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1168: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1162: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1166: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1167: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1168: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1169: )
1170:
1252: , p_init_msg_list VARCHAR2
1253: , x_return_status out nocopy VARCHAR2
1254: , x_msg_count out nocopy NUMBER
1255: , x_msg_data out nocopy VARCHAR2
1256: , p5_a0 JTF_NUMBER_TABLE
1257: , p5_a1 JTF_NUMBER_TABLE
1258: , p5_a2 JTF_NUMBER_TABLE
1259: , p5_a3 JTF_VARCHAR2_TABLE_100
1260: , p5_a4 JTF_VARCHAR2_TABLE_400
1253: , x_return_status out nocopy VARCHAR2
1254: , x_msg_count out nocopy NUMBER
1255: , x_msg_data out nocopy VARCHAR2
1256: , p5_a0 JTF_NUMBER_TABLE
1257: , p5_a1 JTF_NUMBER_TABLE
1258: , p5_a2 JTF_NUMBER_TABLE
1259: , p5_a3 JTF_VARCHAR2_TABLE_100
1260: , p5_a4 JTF_VARCHAR2_TABLE_400
1261: , p5_a5 JTF_VARCHAR2_TABLE_2000
1254: , x_msg_count out nocopy NUMBER
1255: , x_msg_data out nocopy VARCHAR2
1256: , p5_a0 JTF_NUMBER_TABLE
1257: , p5_a1 JTF_NUMBER_TABLE
1258: , p5_a2 JTF_NUMBER_TABLE
1259: , p5_a3 JTF_VARCHAR2_TABLE_100
1260: , p5_a4 JTF_VARCHAR2_TABLE_400
1261: , p5_a5 JTF_VARCHAR2_TABLE_2000
1262: , p5_a6 JTF_VARCHAR2_TABLE_100
1274: , p5_a18 JTF_VARCHAR2_TABLE_500
1275: , p5_a19 JTF_VARCHAR2_TABLE_500
1276: , p5_a20 JTF_VARCHAR2_TABLE_500
1277: , p5_a21 JTF_VARCHAR2_TABLE_500
1278: , p5_a22 JTF_NUMBER_TABLE
1279: , p5_a23 JTF_NUMBER_TABLE
1280: , p5_a24 JTF_NUMBER_TABLE
1281: , p5_a25 JTF_DATE_TABLE
1282: , p5_a26 JTF_NUMBER_TABLE
1275: , p5_a19 JTF_VARCHAR2_TABLE_500
1276: , p5_a20 JTF_VARCHAR2_TABLE_500
1277: , p5_a21 JTF_VARCHAR2_TABLE_500
1278: , p5_a22 JTF_NUMBER_TABLE
1279: , p5_a23 JTF_NUMBER_TABLE
1280: , p5_a24 JTF_NUMBER_TABLE
1281: , p5_a25 JTF_DATE_TABLE
1282: , p5_a26 JTF_NUMBER_TABLE
1283: , p5_a27 JTF_DATE_TABLE
1276: , p5_a20 JTF_VARCHAR2_TABLE_500
1277: , p5_a21 JTF_VARCHAR2_TABLE_500
1278: , p5_a22 JTF_NUMBER_TABLE
1279: , p5_a23 JTF_NUMBER_TABLE
1280: , p5_a24 JTF_NUMBER_TABLE
1281: , p5_a25 JTF_DATE_TABLE
1282: , p5_a26 JTF_NUMBER_TABLE
1283: , p5_a27 JTF_DATE_TABLE
1284: , p5_a28 JTF_NUMBER_TABLE
1278: , p5_a22 JTF_NUMBER_TABLE
1279: , p5_a23 JTF_NUMBER_TABLE
1280: , p5_a24 JTF_NUMBER_TABLE
1281: , p5_a25 JTF_DATE_TABLE
1282: , p5_a26 JTF_NUMBER_TABLE
1283: , p5_a27 JTF_DATE_TABLE
1284: , p5_a28 JTF_NUMBER_TABLE
1285: , p5_a29 JTF_DATE_TABLE
1286: , p5_a30 JTF_NUMBER_TABLE
1280: , p5_a24 JTF_NUMBER_TABLE
1281: , p5_a25 JTF_DATE_TABLE
1282: , p5_a26 JTF_NUMBER_TABLE
1283: , p5_a27 JTF_DATE_TABLE
1284: , p5_a28 JTF_NUMBER_TABLE
1285: , p5_a29 JTF_DATE_TABLE
1286: , p5_a30 JTF_NUMBER_TABLE
1287: )
1288:
1282: , p5_a26 JTF_NUMBER_TABLE
1283: , p5_a27 JTF_DATE_TABLE
1284: , p5_a28 JTF_NUMBER_TABLE
1285: , p5_a29 JTF_DATE_TABLE
1286: , p5_a30 JTF_NUMBER_TABLE
1287: )
1288:
1289: as
1290: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1513: , p_init_msg_list VARCHAR2
1514: , x_return_status out nocopy VARCHAR2
1515: , x_msg_count out nocopy NUMBER
1516: , x_msg_data out nocopy VARCHAR2
1517: , p5_a0 JTF_NUMBER_TABLE
1518: , p5_a1 JTF_NUMBER_TABLE
1519: , p5_a2 JTF_NUMBER_TABLE
1520: , p5_a3 JTF_VARCHAR2_TABLE_100
1521: , p5_a4 JTF_VARCHAR2_TABLE_400
1514: , x_return_status out nocopy VARCHAR2
1515: , x_msg_count out nocopy NUMBER
1516: , x_msg_data out nocopy VARCHAR2
1517: , p5_a0 JTF_NUMBER_TABLE
1518: , p5_a1 JTF_NUMBER_TABLE
1519: , p5_a2 JTF_NUMBER_TABLE
1520: , p5_a3 JTF_VARCHAR2_TABLE_100
1521: , p5_a4 JTF_VARCHAR2_TABLE_400
1522: , p5_a5 JTF_VARCHAR2_TABLE_2000
1515: , x_msg_count out nocopy NUMBER
1516: , x_msg_data out nocopy VARCHAR2
1517: , p5_a0 JTF_NUMBER_TABLE
1518: , p5_a1 JTF_NUMBER_TABLE
1519: , p5_a2 JTF_NUMBER_TABLE
1520: , p5_a3 JTF_VARCHAR2_TABLE_100
1521: , p5_a4 JTF_VARCHAR2_TABLE_400
1522: , p5_a5 JTF_VARCHAR2_TABLE_2000
1523: , p5_a6 JTF_VARCHAR2_TABLE_100
1535: , p5_a18 JTF_VARCHAR2_TABLE_500
1536: , p5_a19 JTF_VARCHAR2_TABLE_500
1537: , p5_a20 JTF_VARCHAR2_TABLE_500
1538: , p5_a21 JTF_VARCHAR2_TABLE_500
1539: , p5_a22 JTF_NUMBER_TABLE
1540: , p5_a23 JTF_NUMBER_TABLE
1541: , p5_a24 JTF_NUMBER_TABLE
1542: , p5_a25 JTF_DATE_TABLE
1543: , p5_a26 JTF_NUMBER_TABLE
1536: , p5_a19 JTF_VARCHAR2_TABLE_500
1537: , p5_a20 JTF_VARCHAR2_TABLE_500
1538: , p5_a21 JTF_VARCHAR2_TABLE_500
1539: , p5_a22 JTF_NUMBER_TABLE
1540: , p5_a23 JTF_NUMBER_TABLE
1541: , p5_a24 JTF_NUMBER_TABLE
1542: , p5_a25 JTF_DATE_TABLE
1543: , p5_a26 JTF_NUMBER_TABLE
1544: , p5_a27 JTF_DATE_TABLE
1537: , p5_a20 JTF_VARCHAR2_TABLE_500
1538: , p5_a21 JTF_VARCHAR2_TABLE_500
1539: , p5_a22 JTF_NUMBER_TABLE
1540: , p5_a23 JTF_NUMBER_TABLE
1541: , p5_a24 JTF_NUMBER_TABLE
1542: , p5_a25 JTF_DATE_TABLE
1543: , p5_a26 JTF_NUMBER_TABLE
1544: , p5_a27 JTF_DATE_TABLE
1545: , p5_a28 JTF_NUMBER_TABLE
1539: , p5_a22 JTF_NUMBER_TABLE
1540: , p5_a23 JTF_NUMBER_TABLE
1541: , p5_a24 JTF_NUMBER_TABLE
1542: , p5_a25 JTF_DATE_TABLE
1543: , p5_a26 JTF_NUMBER_TABLE
1544: , p5_a27 JTF_DATE_TABLE
1545: , p5_a28 JTF_NUMBER_TABLE
1546: , p5_a29 JTF_DATE_TABLE
1547: , p5_a30 JTF_NUMBER_TABLE
1541: , p5_a24 JTF_NUMBER_TABLE
1542: , p5_a25 JTF_DATE_TABLE
1543: , p5_a26 JTF_NUMBER_TABLE
1544: , p5_a27 JTF_DATE_TABLE
1545: , p5_a28 JTF_NUMBER_TABLE
1546: , p5_a29 JTF_DATE_TABLE
1547: , p5_a30 JTF_NUMBER_TABLE
1548: , p6_a0 out nocopy JTF_NUMBER_TABLE
1549: , p6_a1 out nocopy JTF_NUMBER_TABLE
1543: , p5_a26 JTF_NUMBER_TABLE
1544: , p5_a27 JTF_DATE_TABLE
1545: , p5_a28 JTF_NUMBER_TABLE
1546: , p5_a29 JTF_DATE_TABLE
1547: , p5_a30 JTF_NUMBER_TABLE
1548: , p6_a0 out nocopy JTF_NUMBER_TABLE
1549: , p6_a1 out nocopy JTF_NUMBER_TABLE
1550: , p6_a2 out nocopy JTF_NUMBER_TABLE
1551: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1544: , p5_a27 JTF_DATE_TABLE
1545: , p5_a28 JTF_NUMBER_TABLE
1546: , p5_a29 JTF_DATE_TABLE
1547: , p5_a30 JTF_NUMBER_TABLE
1548: , p6_a0 out nocopy JTF_NUMBER_TABLE
1549: , p6_a1 out nocopy JTF_NUMBER_TABLE
1550: , p6_a2 out nocopy JTF_NUMBER_TABLE
1551: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
1545: , p5_a28 JTF_NUMBER_TABLE
1546: , p5_a29 JTF_DATE_TABLE
1547: , p5_a30 JTF_NUMBER_TABLE
1548: , p6_a0 out nocopy JTF_NUMBER_TABLE
1549: , p6_a1 out nocopy JTF_NUMBER_TABLE
1550: , p6_a2 out nocopy JTF_NUMBER_TABLE
1551: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
1553: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1546: , p5_a29 JTF_DATE_TABLE
1547: , p5_a30 JTF_NUMBER_TABLE
1548: , p6_a0 out nocopy JTF_NUMBER_TABLE
1549: , p6_a1 out nocopy JTF_NUMBER_TABLE
1550: , p6_a2 out nocopy JTF_NUMBER_TABLE
1551: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
1553: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1554: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1566: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1567: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1568: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1569: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1570: , p6_a22 out nocopy JTF_NUMBER_TABLE
1571: , p6_a23 out nocopy JTF_NUMBER_TABLE
1572: , p6_a24 out nocopy JTF_NUMBER_TABLE
1573: , p6_a25 out nocopy JTF_DATE_TABLE
1574: , p6_a26 out nocopy JTF_NUMBER_TABLE
1567: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1568: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1569: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1570: , p6_a22 out nocopy JTF_NUMBER_TABLE
1571: , p6_a23 out nocopy JTF_NUMBER_TABLE
1572: , p6_a24 out nocopy JTF_NUMBER_TABLE
1573: , p6_a25 out nocopy JTF_DATE_TABLE
1574: , p6_a26 out nocopy JTF_NUMBER_TABLE
1575: , p6_a27 out nocopy JTF_DATE_TABLE
1568: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1569: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1570: , p6_a22 out nocopy JTF_NUMBER_TABLE
1571: , p6_a23 out nocopy JTF_NUMBER_TABLE
1572: , p6_a24 out nocopy JTF_NUMBER_TABLE
1573: , p6_a25 out nocopy JTF_DATE_TABLE
1574: , p6_a26 out nocopy JTF_NUMBER_TABLE
1575: , p6_a27 out nocopy JTF_DATE_TABLE
1576: , p6_a28 out nocopy JTF_NUMBER_TABLE
1570: , p6_a22 out nocopy JTF_NUMBER_TABLE
1571: , p6_a23 out nocopy JTF_NUMBER_TABLE
1572: , p6_a24 out nocopy JTF_NUMBER_TABLE
1573: , p6_a25 out nocopy JTF_DATE_TABLE
1574: , p6_a26 out nocopy JTF_NUMBER_TABLE
1575: , p6_a27 out nocopy JTF_DATE_TABLE
1576: , p6_a28 out nocopy JTF_NUMBER_TABLE
1577: , p6_a29 out nocopy JTF_DATE_TABLE
1578: , p6_a30 out nocopy JTF_NUMBER_TABLE
1572: , p6_a24 out nocopy JTF_NUMBER_TABLE
1573: , p6_a25 out nocopy JTF_DATE_TABLE
1574: , p6_a26 out nocopy JTF_NUMBER_TABLE
1575: , p6_a27 out nocopy JTF_DATE_TABLE
1576: , p6_a28 out nocopy JTF_NUMBER_TABLE
1577: , p6_a29 out nocopy JTF_DATE_TABLE
1578: , p6_a30 out nocopy JTF_NUMBER_TABLE
1579: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1580: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1574: , p6_a26 out nocopy JTF_NUMBER_TABLE
1575: , p6_a27 out nocopy JTF_DATE_TABLE
1576: , p6_a28 out nocopy JTF_NUMBER_TABLE
1577: , p6_a29 out nocopy JTF_DATE_TABLE
1578: , p6_a30 out nocopy JTF_NUMBER_TABLE
1579: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1580: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1581: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1582: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1575: , p6_a27 out nocopy JTF_DATE_TABLE
1576: , p6_a28 out nocopy JTF_NUMBER_TABLE
1577: , p6_a29 out nocopy JTF_DATE_TABLE
1578: , p6_a30 out nocopy JTF_NUMBER_TABLE
1579: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1580: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1581: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1582: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1583: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1577: , p6_a29 out nocopy JTF_DATE_TABLE
1578: , p6_a30 out nocopy JTF_NUMBER_TABLE
1579: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1580: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1581: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1582: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1583: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1584: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1585: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1579: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1580: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1581: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1582: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1583: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1584: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1585: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1586: )
1587:
1705: , p_init_msg_list VARCHAR2
1706: , x_return_status out nocopy VARCHAR2
1707: , x_msg_count out nocopy NUMBER
1708: , x_msg_data out nocopy VARCHAR2
1709: , p5_a0 JTF_NUMBER_TABLE
1710: , p5_a1 JTF_NUMBER_TABLE
1711: , p5_a2 JTF_NUMBER_TABLE
1712: , p5_a3 JTF_VARCHAR2_TABLE_100
1713: , p5_a4 JTF_VARCHAR2_TABLE_400
1706: , x_return_status out nocopy VARCHAR2
1707: , x_msg_count out nocopy NUMBER
1708: , x_msg_data out nocopy VARCHAR2
1709: , p5_a0 JTF_NUMBER_TABLE
1710: , p5_a1 JTF_NUMBER_TABLE
1711: , p5_a2 JTF_NUMBER_TABLE
1712: , p5_a3 JTF_VARCHAR2_TABLE_100
1713: , p5_a4 JTF_VARCHAR2_TABLE_400
1714: , p5_a5 JTF_VARCHAR2_TABLE_2000
1707: , x_msg_count out nocopy NUMBER
1708: , x_msg_data out nocopy VARCHAR2
1709: , p5_a0 JTF_NUMBER_TABLE
1710: , p5_a1 JTF_NUMBER_TABLE
1711: , p5_a2 JTF_NUMBER_TABLE
1712: , p5_a3 JTF_VARCHAR2_TABLE_100
1713: , p5_a4 JTF_VARCHAR2_TABLE_400
1714: , p5_a5 JTF_VARCHAR2_TABLE_2000
1715: , p5_a6 JTF_VARCHAR2_TABLE_100
1727: , p5_a18 JTF_VARCHAR2_TABLE_500
1728: , p5_a19 JTF_VARCHAR2_TABLE_500
1729: , p5_a20 JTF_VARCHAR2_TABLE_500
1730: , p5_a21 JTF_VARCHAR2_TABLE_500
1731: , p5_a22 JTF_NUMBER_TABLE
1732: , p5_a23 JTF_NUMBER_TABLE
1733: , p5_a24 JTF_NUMBER_TABLE
1734: , p5_a25 JTF_DATE_TABLE
1735: , p5_a26 JTF_NUMBER_TABLE
1728: , p5_a19 JTF_VARCHAR2_TABLE_500
1729: , p5_a20 JTF_VARCHAR2_TABLE_500
1730: , p5_a21 JTF_VARCHAR2_TABLE_500
1731: , p5_a22 JTF_NUMBER_TABLE
1732: , p5_a23 JTF_NUMBER_TABLE
1733: , p5_a24 JTF_NUMBER_TABLE
1734: , p5_a25 JTF_DATE_TABLE
1735: , p5_a26 JTF_NUMBER_TABLE
1736: , p5_a27 JTF_DATE_TABLE
1729: , p5_a20 JTF_VARCHAR2_TABLE_500
1730: , p5_a21 JTF_VARCHAR2_TABLE_500
1731: , p5_a22 JTF_NUMBER_TABLE
1732: , p5_a23 JTF_NUMBER_TABLE
1733: , p5_a24 JTF_NUMBER_TABLE
1734: , p5_a25 JTF_DATE_TABLE
1735: , p5_a26 JTF_NUMBER_TABLE
1736: , p5_a27 JTF_DATE_TABLE
1737: , p5_a28 JTF_NUMBER_TABLE
1731: , p5_a22 JTF_NUMBER_TABLE
1732: , p5_a23 JTF_NUMBER_TABLE
1733: , p5_a24 JTF_NUMBER_TABLE
1734: , p5_a25 JTF_DATE_TABLE
1735: , p5_a26 JTF_NUMBER_TABLE
1736: , p5_a27 JTF_DATE_TABLE
1737: , p5_a28 JTF_NUMBER_TABLE
1738: , p5_a29 JTF_DATE_TABLE
1739: , p5_a30 JTF_NUMBER_TABLE
1733: , p5_a24 JTF_NUMBER_TABLE
1734: , p5_a25 JTF_DATE_TABLE
1735: , p5_a26 JTF_NUMBER_TABLE
1736: , p5_a27 JTF_DATE_TABLE
1737: , p5_a28 JTF_NUMBER_TABLE
1738: , p5_a29 JTF_DATE_TABLE
1739: , p5_a30 JTF_NUMBER_TABLE
1740: , p6_a0 out nocopy JTF_NUMBER_TABLE
1741: , p6_a1 out nocopy JTF_NUMBER_TABLE
1735: , p5_a26 JTF_NUMBER_TABLE
1736: , p5_a27 JTF_DATE_TABLE
1737: , p5_a28 JTF_NUMBER_TABLE
1738: , p5_a29 JTF_DATE_TABLE
1739: , p5_a30 JTF_NUMBER_TABLE
1740: , p6_a0 out nocopy JTF_NUMBER_TABLE
1741: , p6_a1 out nocopy JTF_NUMBER_TABLE
1742: , p6_a2 out nocopy JTF_NUMBER_TABLE
1743: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1736: , p5_a27 JTF_DATE_TABLE
1737: , p5_a28 JTF_NUMBER_TABLE
1738: , p5_a29 JTF_DATE_TABLE
1739: , p5_a30 JTF_NUMBER_TABLE
1740: , p6_a0 out nocopy JTF_NUMBER_TABLE
1741: , p6_a1 out nocopy JTF_NUMBER_TABLE
1742: , p6_a2 out nocopy JTF_NUMBER_TABLE
1743: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1744: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
1737: , p5_a28 JTF_NUMBER_TABLE
1738: , p5_a29 JTF_DATE_TABLE
1739: , p5_a30 JTF_NUMBER_TABLE
1740: , p6_a0 out nocopy JTF_NUMBER_TABLE
1741: , p6_a1 out nocopy JTF_NUMBER_TABLE
1742: , p6_a2 out nocopy JTF_NUMBER_TABLE
1743: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1744: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
1745: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1738: , p5_a29 JTF_DATE_TABLE
1739: , p5_a30 JTF_NUMBER_TABLE
1740: , p6_a0 out nocopy JTF_NUMBER_TABLE
1741: , p6_a1 out nocopy JTF_NUMBER_TABLE
1742: , p6_a2 out nocopy JTF_NUMBER_TABLE
1743: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1744: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
1745: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1746: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1758: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1759: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1760: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1761: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1762: , p6_a22 out nocopy JTF_NUMBER_TABLE
1763: , p6_a23 out nocopy JTF_NUMBER_TABLE
1764: , p6_a24 out nocopy JTF_NUMBER_TABLE
1765: , p6_a25 out nocopy JTF_DATE_TABLE
1766: , p6_a26 out nocopy JTF_NUMBER_TABLE
1759: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1760: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1761: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1762: , p6_a22 out nocopy JTF_NUMBER_TABLE
1763: , p6_a23 out nocopy JTF_NUMBER_TABLE
1764: , p6_a24 out nocopy JTF_NUMBER_TABLE
1765: , p6_a25 out nocopy JTF_DATE_TABLE
1766: , p6_a26 out nocopy JTF_NUMBER_TABLE
1767: , p6_a27 out nocopy JTF_DATE_TABLE
1760: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1761: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1762: , p6_a22 out nocopy JTF_NUMBER_TABLE
1763: , p6_a23 out nocopy JTF_NUMBER_TABLE
1764: , p6_a24 out nocopy JTF_NUMBER_TABLE
1765: , p6_a25 out nocopy JTF_DATE_TABLE
1766: , p6_a26 out nocopy JTF_NUMBER_TABLE
1767: , p6_a27 out nocopy JTF_DATE_TABLE
1768: , p6_a28 out nocopy JTF_NUMBER_TABLE
1762: , p6_a22 out nocopy JTF_NUMBER_TABLE
1763: , p6_a23 out nocopy JTF_NUMBER_TABLE
1764: , p6_a24 out nocopy JTF_NUMBER_TABLE
1765: , p6_a25 out nocopy JTF_DATE_TABLE
1766: , p6_a26 out nocopy JTF_NUMBER_TABLE
1767: , p6_a27 out nocopy JTF_DATE_TABLE
1768: , p6_a28 out nocopy JTF_NUMBER_TABLE
1769: , p6_a29 out nocopy JTF_DATE_TABLE
1770: , p6_a30 out nocopy JTF_NUMBER_TABLE
1764: , p6_a24 out nocopy JTF_NUMBER_TABLE
1765: , p6_a25 out nocopy JTF_DATE_TABLE
1766: , p6_a26 out nocopy JTF_NUMBER_TABLE
1767: , p6_a27 out nocopy JTF_DATE_TABLE
1768: , p6_a28 out nocopy JTF_NUMBER_TABLE
1769: , p6_a29 out nocopy JTF_DATE_TABLE
1770: , p6_a30 out nocopy JTF_NUMBER_TABLE
1771: )
1772:
1766: , p6_a26 out nocopy JTF_NUMBER_TABLE
1767: , p6_a27 out nocopy JTF_DATE_TABLE
1768: , p6_a28 out nocopy JTF_NUMBER_TABLE
1769: , p6_a29 out nocopy JTF_DATE_TABLE
1770: , p6_a30 out nocopy JTF_NUMBER_TABLE
1771: )
1772:
1773: as
1774: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
1967: , p_init_msg_list VARCHAR2
1968: , x_return_status out nocopy VARCHAR2
1969: , x_msg_count out nocopy NUMBER
1970: , x_msg_data out nocopy VARCHAR2
1971: , p5_a0 JTF_NUMBER_TABLE
1972: , p5_a1 JTF_NUMBER_TABLE
1973: , p5_a2 JTF_NUMBER_TABLE
1974: , p5_a3 JTF_VARCHAR2_TABLE_100
1975: , p5_a4 JTF_VARCHAR2_TABLE_400
1968: , x_return_status out nocopy VARCHAR2
1969: , x_msg_count out nocopy NUMBER
1970: , x_msg_data out nocopy VARCHAR2
1971: , p5_a0 JTF_NUMBER_TABLE
1972: , p5_a1 JTF_NUMBER_TABLE
1973: , p5_a2 JTF_NUMBER_TABLE
1974: , p5_a3 JTF_VARCHAR2_TABLE_100
1975: , p5_a4 JTF_VARCHAR2_TABLE_400
1976: , p5_a5 JTF_VARCHAR2_TABLE_2000
1969: , x_msg_count out nocopy NUMBER
1970: , x_msg_data out nocopy VARCHAR2
1971: , p5_a0 JTF_NUMBER_TABLE
1972: , p5_a1 JTF_NUMBER_TABLE
1973: , p5_a2 JTF_NUMBER_TABLE
1974: , p5_a3 JTF_VARCHAR2_TABLE_100
1975: , p5_a4 JTF_VARCHAR2_TABLE_400
1976: , p5_a5 JTF_VARCHAR2_TABLE_2000
1977: , p5_a6 JTF_VARCHAR2_TABLE_100
1989: , p5_a18 JTF_VARCHAR2_TABLE_500
1990: , p5_a19 JTF_VARCHAR2_TABLE_500
1991: , p5_a20 JTF_VARCHAR2_TABLE_500
1992: , p5_a21 JTF_VARCHAR2_TABLE_500
1993: , p5_a22 JTF_NUMBER_TABLE
1994: , p5_a23 JTF_NUMBER_TABLE
1995: , p5_a24 JTF_NUMBER_TABLE
1996: , p5_a25 JTF_DATE_TABLE
1997: , p5_a26 JTF_NUMBER_TABLE
1990: , p5_a19 JTF_VARCHAR2_TABLE_500
1991: , p5_a20 JTF_VARCHAR2_TABLE_500
1992: , p5_a21 JTF_VARCHAR2_TABLE_500
1993: , p5_a22 JTF_NUMBER_TABLE
1994: , p5_a23 JTF_NUMBER_TABLE
1995: , p5_a24 JTF_NUMBER_TABLE
1996: , p5_a25 JTF_DATE_TABLE
1997: , p5_a26 JTF_NUMBER_TABLE
1998: , p5_a27 JTF_DATE_TABLE
1991: , p5_a20 JTF_VARCHAR2_TABLE_500
1992: , p5_a21 JTF_VARCHAR2_TABLE_500
1993: , p5_a22 JTF_NUMBER_TABLE
1994: , p5_a23 JTF_NUMBER_TABLE
1995: , p5_a24 JTF_NUMBER_TABLE
1996: , p5_a25 JTF_DATE_TABLE
1997: , p5_a26 JTF_NUMBER_TABLE
1998: , p5_a27 JTF_DATE_TABLE
1999: , p5_a28 JTF_NUMBER_TABLE
1993: , p5_a22 JTF_NUMBER_TABLE
1994: , p5_a23 JTF_NUMBER_TABLE
1995: , p5_a24 JTF_NUMBER_TABLE
1996: , p5_a25 JTF_DATE_TABLE
1997: , p5_a26 JTF_NUMBER_TABLE
1998: , p5_a27 JTF_DATE_TABLE
1999: , p5_a28 JTF_NUMBER_TABLE
2000: , p5_a29 JTF_DATE_TABLE
2001: , p5_a30 JTF_NUMBER_TABLE
1995: , p5_a24 JTF_NUMBER_TABLE
1996: , p5_a25 JTF_DATE_TABLE
1997: , p5_a26 JTF_NUMBER_TABLE
1998: , p5_a27 JTF_DATE_TABLE
1999: , p5_a28 JTF_NUMBER_TABLE
2000: , p5_a29 JTF_DATE_TABLE
2001: , p5_a30 JTF_NUMBER_TABLE
2002: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2003: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1997: , p5_a26 JTF_NUMBER_TABLE
1998: , p5_a27 JTF_DATE_TABLE
1999: , p5_a28 JTF_NUMBER_TABLE
2000: , p5_a29 JTF_DATE_TABLE
2001: , p5_a30 JTF_NUMBER_TABLE
2002: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2003: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2004: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2005: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1998: , p5_a27 JTF_DATE_TABLE
1999: , p5_a28 JTF_NUMBER_TABLE
2000: , p5_a29 JTF_DATE_TABLE
2001: , p5_a30 JTF_NUMBER_TABLE
2002: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2003: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2004: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2005: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2006: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2000: , p5_a29 JTF_DATE_TABLE
2001: , p5_a30 JTF_NUMBER_TABLE
2002: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2003: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2004: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2005: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2006: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2007: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2008: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2002: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2003: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2004: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2005: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2006: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2007: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2008: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2009: )
2010:
2092: , p_init_msg_list VARCHAR2
2093: , x_return_status out nocopy VARCHAR2
2094: , x_msg_count out nocopy NUMBER
2095: , x_msg_data out nocopy VARCHAR2
2096: , p5_a0 JTF_NUMBER_TABLE
2097: , p5_a1 JTF_NUMBER_TABLE
2098: , p5_a2 JTF_NUMBER_TABLE
2099: , p5_a3 JTF_VARCHAR2_TABLE_100
2100: , p5_a4 JTF_VARCHAR2_TABLE_400
2093: , x_return_status out nocopy VARCHAR2
2094: , x_msg_count out nocopy NUMBER
2095: , x_msg_data out nocopy VARCHAR2
2096: , p5_a0 JTF_NUMBER_TABLE
2097: , p5_a1 JTF_NUMBER_TABLE
2098: , p5_a2 JTF_NUMBER_TABLE
2099: , p5_a3 JTF_VARCHAR2_TABLE_100
2100: , p5_a4 JTF_VARCHAR2_TABLE_400
2101: , p5_a5 JTF_VARCHAR2_TABLE_2000
2094: , x_msg_count out nocopy NUMBER
2095: , x_msg_data out nocopy VARCHAR2
2096: , p5_a0 JTF_NUMBER_TABLE
2097: , p5_a1 JTF_NUMBER_TABLE
2098: , p5_a2 JTF_NUMBER_TABLE
2099: , p5_a3 JTF_VARCHAR2_TABLE_100
2100: , p5_a4 JTF_VARCHAR2_TABLE_400
2101: , p5_a5 JTF_VARCHAR2_TABLE_2000
2102: , p5_a6 JTF_VARCHAR2_TABLE_100
2114: , p5_a18 JTF_VARCHAR2_TABLE_500
2115: , p5_a19 JTF_VARCHAR2_TABLE_500
2116: , p5_a20 JTF_VARCHAR2_TABLE_500
2117: , p5_a21 JTF_VARCHAR2_TABLE_500
2118: , p5_a22 JTF_NUMBER_TABLE
2119: , p5_a23 JTF_NUMBER_TABLE
2120: , p5_a24 JTF_NUMBER_TABLE
2121: , p5_a25 JTF_DATE_TABLE
2122: , p5_a26 JTF_NUMBER_TABLE
2115: , p5_a19 JTF_VARCHAR2_TABLE_500
2116: , p5_a20 JTF_VARCHAR2_TABLE_500
2117: , p5_a21 JTF_VARCHAR2_TABLE_500
2118: , p5_a22 JTF_NUMBER_TABLE
2119: , p5_a23 JTF_NUMBER_TABLE
2120: , p5_a24 JTF_NUMBER_TABLE
2121: , p5_a25 JTF_DATE_TABLE
2122: , p5_a26 JTF_NUMBER_TABLE
2123: , p5_a27 JTF_DATE_TABLE
2116: , p5_a20 JTF_VARCHAR2_TABLE_500
2117: , p5_a21 JTF_VARCHAR2_TABLE_500
2118: , p5_a22 JTF_NUMBER_TABLE
2119: , p5_a23 JTF_NUMBER_TABLE
2120: , p5_a24 JTF_NUMBER_TABLE
2121: , p5_a25 JTF_DATE_TABLE
2122: , p5_a26 JTF_NUMBER_TABLE
2123: , p5_a27 JTF_DATE_TABLE
2124: , p5_a28 JTF_NUMBER_TABLE
2118: , p5_a22 JTF_NUMBER_TABLE
2119: , p5_a23 JTF_NUMBER_TABLE
2120: , p5_a24 JTF_NUMBER_TABLE
2121: , p5_a25 JTF_DATE_TABLE
2122: , p5_a26 JTF_NUMBER_TABLE
2123: , p5_a27 JTF_DATE_TABLE
2124: , p5_a28 JTF_NUMBER_TABLE
2125: , p5_a29 JTF_DATE_TABLE
2126: , p5_a30 JTF_NUMBER_TABLE
2120: , p5_a24 JTF_NUMBER_TABLE
2121: , p5_a25 JTF_DATE_TABLE
2122: , p5_a26 JTF_NUMBER_TABLE
2123: , p5_a27 JTF_DATE_TABLE
2124: , p5_a28 JTF_NUMBER_TABLE
2125: , p5_a29 JTF_DATE_TABLE
2126: , p5_a30 JTF_NUMBER_TABLE
2127: )
2128:
2122: , p5_a26 JTF_NUMBER_TABLE
2123: , p5_a27 JTF_DATE_TABLE
2124: , p5_a28 JTF_NUMBER_TABLE
2125: , p5_a29 JTF_DATE_TABLE
2126: , p5_a30 JTF_NUMBER_TABLE
2127: )
2128:
2129: as
2130: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;
2287: , p_init_msg_list VARCHAR2
2288: , x_return_status out nocopy VARCHAR2
2289: , x_msg_count out nocopy NUMBER
2290: , x_msg_data out nocopy VARCHAR2
2291: , p5_a0 JTF_NUMBER_TABLE
2292: , p5_a1 JTF_NUMBER_TABLE
2293: , p5_a2 JTF_NUMBER_TABLE
2294: , p5_a3 JTF_VARCHAR2_TABLE_100
2295: , p5_a4 JTF_VARCHAR2_TABLE_400
2288: , x_return_status out nocopy VARCHAR2
2289: , x_msg_count out nocopy NUMBER
2290: , x_msg_data out nocopy VARCHAR2
2291: , p5_a0 JTF_NUMBER_TABLE
2292: , p5_a1 JTF_NUMBER_TABLE
2293: , p5_a2 JTF_NUMBER_TABLE
2294: , p5_a3 JTF_VARCHAR2_TABLE_100
2295: , p5_a4 JTF_VARCHAR2_TABLE_400
2296: , p5_a5 JTF_VARCHAR2_TABLE_2000
2289: , x_msg_count out nocopy NUMBER
2290: , x_msg_data out nocopy VARCHAR2
2291: , p5_a0 JTF_NUMBER_TABLE
2292: , p5_a1 JTF_NUMBER_TABLE
2293: , p5_a2 JTF_NUMBER_TABLE
2294: , p5_a3 JTF_VARCHAR2_TABLE_100
2295: , p5_a4 JTF_VARCHAR2_TABLE_400
2296: , p5_a5 JTF_VARCHAR2_TABLE_2000
2297: , p5_a6 JTF_VARCHAR2_TABLE_100
2309: , p5_a18 JTF_VARCHAR2_TABLE_500
2310: , p5_a19 JTF_VARCHAR2_TABLE_500
2311: , p5_a20 JTF_VARCHAR2_TABLE_500
2312: , p5_a21 JTF_VARCHAR2_TABLE_500
2313: , p5_a22 JTF_NUMBER_TABLE
2314: , p5_a23 JTF_NUMBER_TABLE
2315: , p5_a24 JTF_NUMBER_TABLE
2316: , p5_a25 JTF_DATE_TABLE
2317: , p5_a26 JTF_NUMBER_TABLE
2310: , p5_a19 JTF_VARCHAR2_TABLE_500
2311: , p5_a20 JTF_VARCHAR2_TABLE_500
2312: , p5_a21 JTF_VARCHAR2_TABLE_500
2313: , p5_a22 JTF_NUMBER_TABLE
2314: , p5_a23 JTF_NUMBER_TABLE
2315: , p5_a24 JTF_NUMBER_TABLE
2316: , p5_a25 JTF_DATE_TABLE
2317: , p5_a26 JTF_NUMBER_TABLE
2318: , p5_a27 JTF_DATE_TABLE
2311: , p5_a20 JTF_VARCHAR2_TABLE_500
2312: , p5_a21 JTF_VARCHAR2_TABLE_500
2313: , p5_a22 JTF_NUMBER_TABLE
2314: , p5_a23 JTF_NUMBER_TABLE
2315: , p5_a24 JTF_NUMBER_TABLE
2316: , p5_a25 JTF_DATE_TABLE
2317: , p5_a26 JTF_NUMBER_TABLE
2318: , p5_a27 JTF_DATE_TABLE
2319: , p5_a28 JTF_NUMBER_TABLE
2313: , p5_a22 JTF_NUMBER_TABLE
2314: , p5_a23 JTF_NUMBER_TABLE
2315: , p5_a24 JTF_NUMBER_TABLE
2316: , p5_a25 JTF_DATE_TABLE
2317: , p5_a26 JTF_NUMBER_TABLE
2318: , p5_a27 JTF_DATE_TABLE
2319: , p5_a28 JTF_NUMBER_TABLE
2320: , p5_a29 JTF_DATE_TABLE
2321: , p5_a30 JTF_NUMBER_TABLE
2315: , p5_a24 JTF_NUMBER_TABLE
2316: , p5_a25 JTF_DATE_TABLE
2317: , p5_a26 JTF_NUMBER_TABLE
2318: , p5_a27 JTF_DATE_TABLE
2319: , p5_a28 JTF_NUMBER_TABLE
2320: , p5_a29 JTF_DATE_TABLE
2321: , p5_a30 JTF_NUMBER_TABLE
2322: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2323: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2317: , p5_a26 JTF_NUMBER_TABLE
2318: , p5_a27 JTF_DATE_TABLE
2319: , p5_a28 JTF_NUMBER_TABLE
2320: , p5_a29 JTF_DATE_TABLE
2321: , p5_a30 JTF_NUMBER_TABLE
2322: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2323: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2324: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2325: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2318: , p5_a27 JTF_DATE_TABLE
2319: , p5_a28 JTF_NUMBER_TABLE
2320: , p5_a29 JTF_DATE_TABLE
2321: , p5_a30 JTF_NUMBER_TABLE
2322: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2323: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2324: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2325: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2326: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2320: , p5_a29 JTF_DATE_TABLE
2321: , p5_a30 JTF_NUMBER_TABLE
2322: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2323: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2324: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2325: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2326: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2327: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2328: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2322: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2323: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2324: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2325: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2326: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2327: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2328: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2329: )
2330:
2412: , p_init_msg_list VARCHAR2
2413: , x_return_status out nocopy VARCHAR2
2414: , x_msg_count out nocopy NUMBER
2415: , x_msg_data out nocopy VARCHAR2
2416: , p5_a0 JTF_NUMBER_TABLE
2417: , p5_a1 JTF_NUMBER_TABLE
2418: , p5_a2 JTF_NUMBER_TABLE
2419: , p5_a3 JTF_VARCHAR2_TABLE_100
2420: , p5_a4 JTF_VARCHAR2_TABLE_400
2413: , x_return_status out nocopy VARCHAR2
2414: , x_msg_count out nocopy NUMBER
2415: , x_msg_data out nocopy VARCHAR2
2416: , p5_a0 JTF_NUMBER_TABLE
2417: , p5_a1 JTF_NUMBER_TABLE
2418: , p5_a2 JTF_NUMBER_TABLE
2419: , p5_a3 JTF_VARCHAR2_TABLE_100
2420: , p5_a4 JTF_VARCHAR2_TABLE_400
2421: , p5_a5 JTF_VARCHAR2_TABLE_2000
2414: , x_msg_count out nocopy NUMBER
2415: , x_msg_data out nocopy VARCHAR2
2416: , p5_a0 JTF_NUMBER_TABLE
2417: , p5_a1 JTF_NUMBER_TABLE
2418: , p5_a2 JTF_NUMBER_TABLE
2419: , p5_a3 JTF_VARCHAR2_TABLE_100
2420: , p5_a4 JTF_VARCHAR2_TABLE_400
2421: , p5_a5 JTF_VARCHAR2_TABLE_2000
2422: , p5_a6 JTF_VARCHAR2_TABLE_100
2434: , p5_a18 JTF_VARCHAR2_TABLE_500
2435: , p5_a19 JTF_VARCHAR2_TABLE_500
2436: , p5_a20 JTF_VARCHAR2_TABLE_500
2437: , p5_a21 JTF_VARCHAR2_TABLE_500
2438: , p5_a22 JTF_NUMBER_TABLE
2439: , p5_a23 JTF_NUMBER_TABLE
2440: , p5_a24 JTF_NUMBER_TABLE
2441: , p5_a25 JTF_DATE_TABLE
2442: , p5_a26 JTF_NUMBER_TABLE
2435: , p5_a19 JTF_VARCHAR2_TABLE_500
2436: , p5_a20 JTF_VARCHAR2_TABLE_500
2437: , p5_a21 JTF_VARCHAR2_TABLE_500
2438: , p5_a22 JTF_NUMBER_TABLE
2439: , p5_a23 JTF_NUMBER_TABLE
2440: , p5_a24 JTF_NUMBER_TABLE
2441: , p5_a25 JTF_DATE_TABLE
2442: , p5_a26 JTF_NUMBER_TABLE
2443: , p5_a27 JTF_DATE_TABLE
2436: , p5_a20 JTF_VARCHAR2_TABLE_500
2437: , p5_a21 JTF_VARCHAR2_TABLE_500
2438: , p5_a22 JTF_NUMBER_TABLE
2439: , p5_a23 JTF_NUMBER_TABLE
2440: , p5_a24 JTF_NUMBER_TABLE
2441: , p5_a25 JTF_DATE_TABLE
2442: , p5_a26 JTF_NUMBER_TABLE
2443: , p5_a27 JTF_DATE_TABLE
2444: , p5_a28 JTF_NUMBER_TABLE
2438: , p5_a22 JTF_NUMBER_TABLE
2439: , p5_a23 JTF_NUMBER_TABLE
2440: , p5_a24 JTF_NUMBER_TABLE
2441: , p5_a25 JTF_DATE_TABLE
2442: , p5_a26 JTF_NUMBER_TABLE
2443: , p5_a27 JTF_DATE_TABLE
2444: , p5_a28 JTF_NUMBER_TABLE
2445: , p5_a29 JTF_DATE_TABLE
2446: , p5_a30 JTF_NUMBER_TABLE
2440: , p5_a24 JTF_NUMBER_TABLE
2441: , p5_a25 JTF_DATE_TABLE
2442: , p5_a26 JTF_NUMBER_TABLE
2443: , p5_a27 JTF_DATE_TABLE
2444: , p5_a28 JTF_NUMBER_TABLE
2445: , p5_a29 JTF_DATE_TABLE
2446: , p5_a30 JTF_NUMBER_TABLE
2447: )
2448:
2442: , p5_a26 JTF_NUMBER_TABLE
2443: , p5_a27 JTF_DATE_TABLE
2444: , p5_a28 JTF_NUMBER_TABLE
2445: , p5_a29 JTF_DATE_TABLE
2446: , p5_a30 JTF_NUMBER_TABLE
2447: )
2448:
2449: as
2450: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;