DBA Data[Home] [Help]

APPS.OKL_VRR_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 4: , a1 JTF_NUMBER_TABLE

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

Line 5: , a2 JTF_NUMBER_TABLE

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

Line 25: , a22 JTF_NUMBER_TABLE

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

Line 26: , a23 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

Line 27: , a24 JTF_NUMBER_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

Line 29: , a26 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

Line 31: , a28 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;

Line 33: , a30 JTF_NUMBER_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;
36: begin
37: if a0 is not null and a0.count > 0 then

Line 82: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 83: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 84: , a2 out nocopy JTF_NUMBER_TABLE

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

Line 104: , a22 out nocopy JTF_NUMBER_TABLE

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

Line 105: , a23 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

Line 106: , a24 out nocopy JTF_NUMBER_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

Line 108: , a26 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

Line 110: , a28 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;

Line 112: , a30 out nocopy JTF_NUMBER_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;
115: begin
116: if t is null or t.count = 0 then

Line 117: a0 := JTF_NUMBER_TABLE();

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();

Line 118: a1 := JTF_NUMBER_TABLE();

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();

Line 119: a2 := JTF_NUMBER_TABLE();

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();

Line 139: a22 := JTF_NUMBER_TABLE();

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();

Line 140: a23 := 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();

Line 141: a24 := JTF_NUMBER_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();

Line 143: a26 := 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();

Line 145: a28 := 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();

Line 147: a30 := 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();

Line 149: a0 := 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();

Line 150: a1 := 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();
154: a5 := JTF_VARCHAR2_TABLE_2000();

Line 151: a2 := JTF_NUMBER_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();
155: a6 := JTF_VARCHAR2_TABLE_100();

Line 171: a22 := JTF_NUMBER_TABLE();

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();

Line 172: a23 := 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();

Line 173: a24 := JTF_NUMBER_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();

Line 175: a26 := 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();

Line 177: a28 := 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);

Line 179: a30 := JTF_NUMBER_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);
182: a1.extend(t.count);
183: a2.extend(t.count);

Line 256: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 257: , a1 JTF_NUMBER_TABLE

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

Line 258: , a2 JTF_NUMBER_TABLE

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

Line 278: , a22 JTF_NUMBER_TABLE

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

Line 279: , a23 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

Line 280: , a24 JTF_NUMBER_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

Line 282: , a26 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

Line 284: , a28 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;

Line 286: , a30 JTF_NUMBER_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;
289: begin
290: if a0 is not null and a0.count > 0 then

Line 335: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 336: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 337: , a2 out nocopy JTF_NUMBER_TABLE

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

Line 357: , a22 out nocopy JTF_NUMBER_TABLE

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

Line 358: , a23 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

Line 359: , a24 out nocopy JTF_NUMBER_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

Line 361: , a26 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

Line 363: , a28 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;

Line 365: , a30 out nocopy JTF_NUMBER_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;
368: begin
369: if t is null or t.count = 0 then

Line 370: a0 := JTF_NUMBER_TABLE();

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();

Line 371: a1 := JTF_NUMBER_TABLE();

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();

Line 372: a2 := JTF_NUMBER_TABLE();

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();

Line 392: a22 := JTF_NUMBER_TABLE();

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();

Line 393: a23 := 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();

Line 394: a24 := JTF_NUMBER_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();

Line 396: a26 := 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();

Line 398: a28 := 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();

Line 400: a30 := 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();

Line 402: a0 := 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();

Line 403: a1 := 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();
407: a5 := JTF_VARCHAR2_TABLE_2000();

Line 404: a2 := JTF_NUMBER_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();
408: a6 := JTF_VARCHAR2_TABLE_100();

Line 424: a22 := JTF_NUMBER_TABLE();

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();

Line 425: a23 := 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();

Line 426: a24 := JTF_NUMBER_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();

Line 428: a26 := 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();

Line 430: a28 := 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);

Line 432: a30 := JTF_NUMBER_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);
435: a1.extend(t.count);
436: a2.extend(t.count);

Line 677: , p5_a0 JTF_NUMBER_TABLE

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

Line 678: , p5_a1 JTF_NUMBER_TABLE

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

Line 679: , p5_a2 JTF_NUMBER_TABLE

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

Line 699: , p5_a22 JTF_NUMBER_TABLE

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

Line 700: , p5_a23 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

Line 701: , p5_a24 JTF_NUMBER_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

Line 703: , p5_a26 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

Line 705: , p5_a28 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

Line 707: , p5_a30 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

Line 708: , p6_a0 out nocopy 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
712: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 709: , p6_a1 out nocopy JTF_NUMBER_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
713: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 710: , p6_a2 out nocopy 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
714: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 730: , p6_a22 out nocopy JTF_NUMBER_TABLE

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

Line 731: , p6_a23 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

Line 732: , p6_a24 out nocopy JTF_NUMBER_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

Line 734: , p6_a26 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

Line 736: , p6_a28 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

Line 738: , p6_a30 out nocopy JTF_NUMBER_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
741: , p7_a2 in out nocopy JTF_NUMBER_TABLE
742: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 739: , p7_a0 in 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
743: , p7_a4 in out nocopy JTF_NUMBER_TABLE

Line 741: , p7_a2 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

Line 743: , p7_a4 in 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
746: )
747:

Line 869: , p5_a0 JTF_NUMBER_TABLE

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

Line 870: , p5_a1 JTF_NUMBER_TABLE

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

Line 871: , p5_a2 JTF_NUMBER_TABLE

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

Line 891: , p5_a22 JTF_NUMBER_TABLE

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

Line 892: , p5_a23 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

Line 893: , p5_a24 JTF_NUMBER_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

Line 895: , p5_a26 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

Line 897: , p5_a28 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

Line 899: , p5_a30 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

Line 900: , p6_a0 out nocopy 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
904: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 901: , p6_a1 out nocopy JTF_NUMBER_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
905: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 902: , p6_a2 out nocopy 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
906: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 922: , p6_a22 out nocopy JTF_NUMBER_TABLE

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

Line 923: , p6_a23 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

Line 924: , p6_a24 out nocopy JTF_NUMBER_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

Line 926: , p6_a26 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

Line 928: , p6_a28 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:

Line 930: , p6_a30 out nocopy JTF_NUMBER_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:
933: as
934: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

Line 1131: , p5_a0 JTF_NUMBER_TABLE

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

Line 1132: , p5_a1 JTF_NUMBER_TABLE

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

Line 1133: , p5_a2 JTF_NUMBER_TABLE

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

Line 1153: , p5_a22 JTF_NUMBER_TABLE

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

Line 1154: , p5_a23 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

Line 1155: , p5_a24 JTF_NUMBER_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

Line 1157: , p5_a26 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

Line 1159: , p5_a28 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

Line 1161: , p5_a30 JTF_NUMBER_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
1164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 1162: , p6_a0 in out nocopy 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
1166: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 1164: , p6_a2 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

Line 1166: , p6_a4 in out nocopy 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
1169: )
1170:

Line 1256: , p5_a0 JTF_NUMBER_TABLE

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

Line 1257: , p5_a1 JTF_NUMBER_TABLE

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

Line 1258: , p5_a2 JTF_NUMBER_TABLE

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

Line 1278: , p5_a22 JTF_NUMBER_TABLE

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

Line 1279: , p5_a23 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

Line 1280: , p5_a24 JTF_NUMBER_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

Line 1282: , p5_a26 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

Line 1284: , p5_a28 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:

Line 1286: , p5_a30 JTF_NUMBER_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:
1289: as
1290: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

Line 1517: , p5_a0 JTF_NUMBER_TABLE

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

Line 1518: , p5_a1 JTF_NUMBER_TABLE

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

Line 1519: , p5_a2 JTF_NUMBER_TABLE

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

Line 1539: , p5_a22 JTF_NUMBER_TABLE

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

Line 1540: , p5_a23 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

Line 1541: , p5_a24 JTF_NUMBER_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

Line 1543: , p5_a26 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

Line 1545: , p5_a28 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

Line 1547: , p5_a30 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

Line 1548: , p6_a0 out nocopy 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
1552: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 1549: , p6_a1 out nocopy JTF_NUMBER_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
1553: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1550: , p6_a2 out nocopy 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
1554: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1570: , p6_a22 out nocopy JTF_NUMBER_TABLE

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

Line 1571: , p6_a23 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

Line 1572: , p6_a24 out nocopy JTF_NUMBER_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

Line 1574: , p6_a26 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

Line 1576: , p6_a28 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

Line 1578: , p6_a30 out nocopy JTF_NUMBER_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
1581: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1582: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 1579: , p7_a0 in 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
1583: , p7_a4 in out nocopy JTF_NUMBER_TABLE

Line 1581: , p7_a2 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

Line 1583: , p7_a4 in 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
1586: )
1587:

Line 1709: , p5_a0 JTF_NUMBER_TABLE

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

Line 1710: , p5_a1 JTF_NUMBER_TABLE

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

Line 1711: , p5_a2 JTF_NUMBER_TABLE

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

Line 1731: , p5_a22 JTF_NUMBER_TABLE

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

Line 1732: , p5_a23 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

Line 1733: , p5_a24 JTF_NUMBER_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

Line 1735: , p5_a26 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

Line 1737: , p5_a28 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

Line 1739: , p5_a30 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

Line 1740: , p6_a0 out nocopy 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
1744: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 1741: , p6_a1 out nocopy JTF_NUMBER_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
1745: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1742: , p6_a2 out nocopy 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
1746: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1762: , p6_a22 out nocopy JTF_NUMBER_TABLE

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

Line 1763: , p6_a23 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

Line 1764: , p6_a24 out nocopy JTF_NUMBER_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

Line 1766: , p6_a26 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

Line 1768: , p6_a28 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:

Line 1770: , p6_a30 out nocopy JTF_NUMBER_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:
1773: as
1774: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

Line 1971: , p5_a0 JTF_NUMBER_TABLE

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

Line 1972: , p5_a1 JTF_NUMBER_TABLE

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

Line 1973: , p5_a2 JTF_NUMBER_TABLE

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

Line 1993: , p5_a22 JTF_NUMBER_TABLE

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

Line 1994: , p5_a23 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

Line 1995: , p5_a24 JTF_NUMBER_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

Line 1997: , p5_a26 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

Line 1999: , p5_a28 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

Line 2001: , p5_a30 JTF_NUMBER_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
2004: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2005: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 2002: , p6_a0 in out nocopy 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
2006: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 2004: , p6_a2 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

Line 2006: , p6_a4 in out nocopy 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
2009: )
2010:

Line 2096: , p5_a0 JTF_NUMBER_TABLE

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

Line 2097: , p5_a1 JTF_NUMBER_TABLE

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

Line 2098: , p5_a2 JTF_NUMBER_TABLE

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

Line 2118: , p5_a22 JTF_NUMBER_TABLE

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

Line 2119: , p5_a23 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

Line 2120: , p5_a24 JTF_NUMBER_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

Line 2122: , p5_a26 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

Line 2124: , p5_a28 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:

Line 2126: , p5_a30 JTF_NUMBER_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:
2129: as
2130: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

Line 2291: , p5_a0 JTF_NUMBER_TABLE

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

Line 2292: , p5_a1 JTF_NUMBER_TABLE

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

Line 2293: , p5_a2 JTF_NUMBER_TABLE

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

Line 2313: , p5_a22 JTF_NUMBER_TABLE

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

Line 2314: , p5_a23 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

Line 2315: , p5_a24 JTF_NUMBER_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

Line 2317: , p5_a26 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

Line 2319: , p5_a28 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

Line 2321: , p5_a30 JTF_NUMBER_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
2324: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2325: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 2322: , p6_a0 in out nocopy 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
2326: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 2324: , p6_a2 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

Line 2326: , p6_a4 in out nocopy 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
2329: )
2330:

Line 2416: , p5_a0 JTF_NUMBER_TABLE

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

Line 2417: , p5_a1 JTF_NUMBER_TABLE

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

Line 2418: , p5_a2 JTF_NUMBER_TABLE

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

Line 2438: , p5_a22 JTF_NUMBER_TABLE

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

Line 2439: , p5_a23 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

Line 2440: , p5_a24 JTF_NUMBER_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

Line 2442: , p5_a26 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

Line 2444: , p5_a28 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:

Line 2446: , p5_a30 JTF_NUMBER_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:
2449: as
2450: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;