APPS.OKL_CLH_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_clh_pvt.clhv_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_clh_pvt.clhv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_600

Line 23: , a1 JTF_NUMBER_TABLE

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_clh_pvt.clhv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_600
27: , a5 JTF_VARCHAR2_TABLE_100

Line 47: , a25 JTF_NUMBER_TABLE

43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE

Line 48: , a26 JTF_NUMBER_TABLE

44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_NUMBER_TABLE

Line 49: , a27 JTF_NUMBER_TABLE

45: , a23 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE

Line 50: , a28 JTF_NUMBER_TABLE

46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_NUMBER_TABLE

Line 52: , a30 JTF_NUMBER_TABLE

48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_DATE_TABLE
56: , a34 JTF_NUMBER_TABLE

Line 54: , a32 JTF_NUMBER_TABLE

50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_DATE_TABLE
52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_DATE_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_VARCHAR2_TABLE_100
58: , a36 JTF_DATE_TABLE

Line 56: , a34 JTF_NUMBER_TABLE

52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_DATE_TABLE
54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_DATE_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_VARCHAR2_TABLE_100
58: , a36 JTF_DATE_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_VARCHAR2_TABLE_100

Line 59: , a37 JTF_NUMBER_TABLE

55: , a33 JTF_DATE_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_VARCHAR2_TABLE_100
58: , a36 JTF_DATE_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_VARCHAR2_TABLE_100
61: , a39 JTF_NUMBER_TABLE
62: ) as
63: ddindx binary_integer; indx binary_integer;

Line 61: , a39 JTF_NUMBER_TABLE

57: , a35 JTF_VARCHAR2_TABLE_100
58: , a36 JTF_DATE_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_VARCHAR2_TABLE_100
61: , a39 JTF_NUMBER_TABLE
62: ) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if a0 is not null and a0.count > 0 then

Line 119: procedure rosetta_table_copy_out_p2(t okl_clh_pvt.clhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

115: end loop;
116: end if;
117: end if;
118: end rosetta_table_copy_in_p2;
119: procedure rosetta_table_copy_out_p2(t okl_clh_pvt.clhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_VARCHAR2_TABLE_200
122: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
123: , a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 120: , a1 out nocopy JTF_NUMBER_TABLE

116: end if;
117: end if;
118: end rosetta_table_copy_in_p2;
119: procedure rosetta_table_copy_out_p2(t okl_clh_pvt.clhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_VARCHAR2_TABLE_200
122: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
123: , a4 out nocopy JTF_VARCHAR2_TABLE_600
124: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 144: , a25 out nocopy JTF_NUMBER_TABLE

140: , a21 out nocopy JTF_VARCHAR2_TABLE_500
141: , a22 out nocopy JTF_VARCHAR2_TABLE_500
142: , a23 out nocopy JTF_VARCHAR2_TABLE_500
143: , a24 out nocopy JTF_VARCHAR2_TABLE_500
144: , a25 out nocopy JTF_NUMBER_TABLE
145: , a26 out nocopy JTF_NUMBER_TABLE
146: , a27 out nocopy JTF_NUMBER_TABLE
147: , a28 out nocopy JTF_NUMBER_TABLE
148: , a29 out nocopy JTF_DATE_TABLE

Line 145: , a26 out nocopy JTF_NUMBER_TABLE

141: , a22 out nocopy JTF_VARCHAR2_TABLE_500
142: , a23 out nocopy JTF_VARCHAR2_TABLE_500
143: , a24 out nocopy JTF_VARCHAR2_TABLE_500
144: , a25 out nocopy JTF_NUMBER_TABLE
145: , a26 out nocopy JTF_NUMBER_TABLE
146: , a27 out nocopy JTF_NUMBER_TABLE
147: , a28 out nocopy JTF_NUMBER_TABLE
148: , a29 out nocopy JTF_DATE_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE

Line 146: , a27 out nocopy JTF_NUMBER_TABLE

142: , a23 out nocopy JTF_VARCHAR2_TABLE_500
143: , a24 out nocopy JTF_VARCHAR2_TABLE_500
144: , a25 out nocopy JTF_NUMBER_TABLE
145: , a26 out nocopy JTF_NUMBER_TABLE
146: , a27 out nocopy JTF_NUMBER_TABLE
147: , a28 out nocopy JTF_NUMBER_TABLE
148: , a29 out nocopy JTF_DATE_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
150: , a31 out nocopy JTF_DATE_TABLE

Line 147: , a28 out nocopy JTF_NUMBER_TABLE

143: , a24 out nocopy JTF_VARCHAR2_TABLE_500
144: , a25 out nocopy JTF_NUMBER_TABLE
145: , a26 out nocopy JTF_NUMBER_TABLE
146: , a27 out nocopy JTF_NUMBER_TABLE
147: , a28 out nocopy JTF_NUMBER_TABLE
148: , a29 out nocopy JTF_DATE_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
150: , a31 out nocopy JTF_DATE_TABLE
151: , a32 out nocopy JTF_NUMBER_TABLE

Line 149: , a30 out nocopy JTF_NUMBER_TABLE

145: , a26 out nocopy JTF_NUMBER_TABLE
146: , a27 out nocopy JTF_NUMBER_TABLE
147: , a28 out nocopy JTF_NUMBER_TABLE
148: , a29 out nocopy JTF_DATE_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
150: , a31 out nocopy JTF_DATE_TABLE
151: , a32 out nocopy JTF_NUMBER_TABLE
152: , a33 out nocopy JTF_DATE_TABLE
153: , a34 out nocopy JTF_NUMBER_TABLE

Line 151: , a32 out nocopy JTF_NUMBER_TABLE

147: , a28 out nocopy JTF_NUMBER_TABLE
148: , a29 out nocopy JTF_DATE_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
150: , a31 out nocopy JTF_DATE_TABLE
151: , a32 out nocopy JTF_NUMBER_TABLE
152: , a33 out nocopy JTF_DATE_TABLE
153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_VARCHAR2_TABLE_100
155: , a36 out nocopy JTF_DATE_TABLE

Line 153: , a34 out nocopy JTF_NUMBER_TABLE

149: , a30 out nocopy JTF_NUMBER_TABLE
150: , a31 out nocopy JTF_DATE_TABLE
151: , a32 out nocopy JTF_NUMBER_TABLE
152: , a33 out nocopy JTF_DATE_TABLE
153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_VARCHAR2_TABLE_100
155: , a36 out nocopy JTF_DATE_TABLE
156: , a37 out nocopy JTF_NUMBER_TABLE
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 156: , a37 out nocopy JTF_NUMBER_TABLE

152: , a33 out nocopy JTF_DATE_TABLE
153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_VARCHAR2_TABLE_100
155: , a36 out nocopy JTF_DATE_TABLE
156: , a37 out nocopy JTF_NUMBER_TABLE
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_NUMBER_TABLE
159: ) as
160: ddindx binary_integer; indx binary_integer;

Line 158: , a39 out nocopy JTF_NUMBER_TABLE

154: , a35 out nocopy JTF_VARCHAR2_TABLE_100
155: , a36 out nocopy JTF_DATE_TABLE
156: , a37 out nocopy JTF_NUMBER_TABLE
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_NUMBER_TABLE
159: ) as
160: ddindx binary_integer; indx binary_integer;
161: begin
162: if t is null or t.count = 0 then

Line 163: a0 := JTF_NUMBER_TABLE();

159: ) as
160: ddindx binary_integer; indx binary_integer;
161: begin
162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_VARCHAR2_TABLE_200();
166: a3 := JTF_VARCHAR2_TABLE_2000();
167: a4 := JTF_VARCHAR2_TABLE_600();

Line 164: a1 := JTF_NUMBER_TABLE();

160: ddindx binary_integer; indx binary_integer;
161: begin
162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_VARCHAR2_TABLE_200();
166: a3 := JTF_VARCHAR2_TABLE_2000();
167: a4 := JTF_VARCHAR2_TABLE_600();
168: a5 := JTF_VARCHAR2_TABLE_100();

Line 188: a25 := JTF_NUMBER_TABLE();

184: a21 := JTF_VARCHAR2_TABLE_500();
185: a22 := JTF_VARCHAR2_TABLE_500();
186: a23 := JTF_VARCHAR2_TABLE_500();
187: a24 := JTF_VARCHAR2_TABLE_500();
188: a25 := JTF_NUMBER_TABLE();
189: a26 := JTF_NUMBER_TABLE();
190: a27 := JTF_NUMBER_TABLE();
191: a28 := JTF_NUMBER_TABLE();
192: a29 := JTF_DATE_TABLE();

Line 189: a26 := JTF_NUMBER_TABLE();

185: a22 := JTF_VARCHAR2_TABLE_500();
186: a23 := JTF_VARCHAR2_TABLE_500();
187: a24 := JTF_VARCHAR2_TABLE_500();
188: a25 := JTF_NUMBER_TABLE();
189: a26 := JTF_NUMBER_TABLE();
190: a27 := JTF_NUMBER_TABLE();
191: a28 := JTF_NUMBER_TABLE();
192: a29 := JTF_DATE_TABLE();
193: a30 := JTF_NUMBER_TABLE();

Line 190: a27 := JTF_NUMBER_TABLE();

186: a23 := JTF_VARCHAR2_TABLE_500();
187: a24 := JTF_VARCHAR2_TABLE_500();
188: a25 := JTF_NUMBER_TABLE();
189: a26 := JTF_NUMBER_TABLE();
190: a27 := JTF_NUMBER_TABLE();
191: a28 := JTF_NUMBER_TABLE();
192: a29 := JTF_DATE_TABLE();
193: a30 := JTF_NUMBER_TABLE();
194: a31 := JTF_DATE_TABLE();

Line 191: a28 := JTF_NUMBER_TABLE();

187: a24 := JTF_VARCHAR2_TABLE_500();
188: a25 := JTF_NUMBER_TABLE();
189: a26 := JTF_NUMBER_TABLE();
190: a27 := JTF_NUMBER_TABLE();
191: a28 := JTF_NUMBER_TABLE();
192: a29 := JTF_DATE_TABLE();
193: a30 := JTF_NUMBER_TABLE();
194: a31 := JTF_DATE_TABLE();
195: a32 := JTF_NUMBER_TABLE();

Line 193: a30 := JTF_NUMBER_TABLE();

189: a26 := JTF_NUMBER_TABLE();
190: a27 := JTF_NUMBER_TABLE();
191: a28 := JTF_NUMBER_TABLE();
192: a29 := JTF_DATE_TABLE();
193: a30 := JTF_NUMBER_TABLE();
194: a31 := JTF_DATE_TABLE();
195: a32 := JTF_NUMBER_TABLE();
196: a33 := JTF_DATE_TABLE();
197: a34 := JTF_NUMBER_TABLE();

Line 195: a32 := JTF_NUMBER_TABLE();

191: a28 := JTF_NUMBER_TABLE();
192: a29 := JTF_DATE_TABLE();
193: a30 := JTF_NUMBER_TABLE();
194: a31 := JTF_DATE_TABLE();
195: a32 := JTF_NUMBER_TABLE();
196: a33 := JTF_DATE_TABLE();
197: a34 := JTF_NUMBER_TABLE();
198: a35 := JTF_VARCHAR2_TABLE_100();
199: a36 := JTF_DATE_TABLE();

Line 197: a34 := JTF_NUMBER_TABLE();

193: a30 := JTF_NUMBER_TABLE();
194: a31 := JTF_DATE_TABLE();
195: a32 := JTF_NUMBER_TABLE();
196: a33 := JTF_DATE_TABLE();
197: a34 := JTF_NUMBER_TABLE();
198: a35 := JTF_VARCHAR2_TABLE_100();
199: a36 := JTF_DATE_TABLE();
200: a37 := JTF_NUMBER_TABLE();
201: a38 := JTF_VARCHAR2_TABLE_100();

Line 200: a37 := JTF_NUMBER_TABLE();

196: a33 := JTF_DATE_TABLE();
197: a34 := JTF_NUMBER_TABLE();
198: a35 := JTF_VARCHAR2_TABLE_100();
199: a36 := JTF_DATE_TABLE();
200: a37 := JTF_NUMBER_TABLE();
201: a38 := JTF_VARCHAR2_TABLE_100();
202: a39 := JTF_NUMBER_TABLE();
203: else
204: a0 := JTF_NUMBER_TABLE();

Line 202: a39 := JTF_NUMBER_TABLE();

198: a35 := JTF_VARCHAR2_TABLE_100();
199: a36 := JTF_DATE_TABLE();
200: a37 := JTF_NUMBER_TABLE();
201: a38 := JTF_VARCHAR2_TABLE_100();
202: a39 := JTF_NUMBER_TABLE();
203: else
204: a0 := JTF_NUMBER_TABLE();
205: a1 := JTF_NUMBER_TABLE();
206: a2 := JTF_VARCHAR2_TABLE_200();

Line 204: a0 := JTF_NUMBER_TABLE();

200: a37 := JTF_NUMBER_TABLE();
201: a38 := JTF_VARCHAR2_TABLE_100();
202: a39 := JTF_NUMBER_TABLE();
203: else
204: a0 := JTF_NUMBER_TABLE();
205: a1 := JTF_NUMBER_TABLE();
206: a2 := JTF_VARCHAR2_TABLE_200();
207: a3 := JTF_VARCHAR2_TABLE_2000();
208: a4 := JTF_VARCHAR2_TABLE_600();

Line 205: a1 := JTF_NUMBER_TABLE();

201: a38 := JTF_VARCHAR2_TABLE_100();
202: a39 := JTF_NUMBER_TABLE();
203: else
204: a0 := JTF_NUMBER_TABLE();
205: a1 := JTF_NUMBER_TABLE();
206: a2 := JTF_VARCHAR2_TABLE_200();
207: a3 := JTF_VARCHAR2_TABLE_2000();
208: a4 := JTF_VARCHAR2_TABLE_600();
209: a5 := JTF_VARCHAR2_TABLE_100();

Line 229: a25 := JTF_NUMBER_TABLE();

225: a21 := JTF_VARCHAR2_TABLE_500();
226: a22 := JTF_VARCHAR2_TABLE_500();
227: a23 := JTF_VARCHAR2_TABLE_500();
228: a24 := JTF_VARCHAR2_TABLE_500();
229: a25 := JTF_NUMBER_TABLE();
230: a26 := JTF_NUMBER_TABLE();
231: a27 := JTF_NUMBER_TABLE();
232: a28 := JTF_NUMBER_TABLE();
233: a29 := JTF_DATE_TABLE();

Line 230: a26 := JTF_NUMBER_TABLE();

226: a22 := JTF_VARCHAR2_TABLE_500();
227: a23 := JTF_VARCHAR2_TABLE_500();
228: a24 := JTF_VARCHAR2_TABLE_500();
229: a25 := JTF_NUMBER_TABLE();
230: a26 := JTF_NUMBER_TABLE();
231: a27 := JTF_NUMBER_TABLE();
232: a28 := JTF_NUMBER_TABLE();
233: a29 := JTF_DATE_TABLE();
234: a30 := JTF_NUMBER_TABLE();

Line 231: a27 := JTF_NUMBER_TABLE();

227: a23 := JTF_VARCHAR2_TABLE_500();
228: a24 := JTF_VARCHAR2_TABLE_500();
229: a25 := JTF_NUMBER_TABLE();
230: a26 := JTF_NUMBER_TABLE();
231: a27 := JTF_NUMBER_TABLE();
232: a28 := JTF_NUMBER_TABLE();
233: a29 := JTF_DATE_TABLE();
234: a30 := JTF_NUMBER_TABLE();
235: a31 := JTF_DATE_TABLE();

Line 232: a28 := JTF_NUMBER_TABLE();

228: a24 := JTF_VARCHAR2_TABLE_500();
229: a25 := JTF_NUMBER_TABLE();
230: a26 := JTF_NUMBER_TABLE();
231: a27 := JTF_NUMBER_TABLE();
232: a28 := JTF_NUMBER_TABLE();
233: a29 := JTF_DATE_TABLE();
234: a30 := JTF_NUMBER_TABLE();
235: a31 := JTF_DATE_TABLE();
236: a32 := JTF_NUMBER_TABLE();

Line 234: a30 := JTF_NUMBER_TABLE();

230: a26 := JTF_NUMBER_TABLE();
231: a27 := JTF_NUMBER_TABLE();
232: a28 := JTF_NUMBER_TABLE();
233: a29 := JTF_DATE_TABLE();
234: a30 := JTF_NUMBER_TABLE();
235: a31 := JTF_DATE_TABLE();
236: a32 := JTF_NUMBER_TABLE();
237: a33 := JTF_DATE_TABLE();
238: a34 := JTF_NUMBER_TABLE();

Line 236: a32 := JTF_NUMBER_TABLE();

232: a28 := JTF_NUMBER_TABLE();
233: a29 := JTF_DATE_TABLE();
234: a30 := JTF_NUMBER_TABLE();
235: a31 := JTF_DATE_TABLE();
236: a32 := JTF_NUMBER_TABLE();
237: a33 := JTF_DATE_TABLE();
238: a34 := JTF_NUMBER_TABLE();
239: a35 := JTF_VARCHAR2_TABLE_100();
240: a36 := JTF_DATE_TABLE();

Line 238: a34 := JTF_NUMBER_TABLE();

234: a30 := JTF_NUMBER_TABLE();
235: a31 := JTF_DATE_TABLE();
236: a32 := JTF_NUMBER_TABLE();
237: a33 := JTF_DATE_TABLE();
238: a34 := JTF_NUMBER_TABLE();
239: a35 := JTF_VARCHAR2_TABLE_100();
240: a36 := JTF_DATE_TABLE();
241: a37 := JTF_NUMBER_TABLE();
242: a38 := JTF_VARCHAR2_TABLE_100();

Line 241: a37 := JTF_NUMBER_TABLE();

237: a33 := JTF_DATE_TABLE();
238: a34 := JTF_NUMBER_TABLE();
239: a35 := JTF_VARCHAR2_TABLE_100();
240: a36 := JTF_DATE_TABLE();
241: a37 := JTF_NUMBER_TABLE();
242: a38 := JTF_VARCHAR2_TABLE_100();
243: a39 := JTF_NUMBER_TABLE();
244: if t.count > 0 then
245: a0.extend(t.count);

Line 243: a39 := JTF_NUMBER_TABLE();

239: a35 := JTF_VARCHAR2_TABLE_100();
240: a36 := JTF_DATE_TABLE();
241: a37 := JTF_NUMBER_TABLE();
242: a38 := JTF_VARCHAR2_TABLE_100();
243: a39 := JTF_NUMBER_TABLE();
244: if t.count > 0 then
245: a0.extend(t.count);
246: a1.extend(t.count);
247: a2.extend(t.count);

Line 338: procedure rosetta_table_copy_in_p5(t out nocopy okl_clh_pvt.clh_tbl_type, a0 JTF_NUMBER_TABLE

334: end if;
335: end if;
336: end rosetta_table_copy_out_p2;
337:
338: procedure rosetta_table_copy_in_p5(t out nocopy okl_clh_pvt.clh_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_NUMBER_TABLE
340: , a2 JTF_VARCHAR2_TABLE_200
341: , a3 JTF_VARCHAR2_TABLE_2000
342: , a4 JTF_VARCHAR2_TABLE_600

Line 339: , a1 JTF_NUMBER_TABLE

335: end if;
336: end rosetta_table_copy_out_p2;
337:
338: procedure rosetta_table_copy_in_p5(t out nocopy okl_clh_pvt.clh_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_NUMBER_TABLE
340: , a2 JTF_VARCHAR2_TABLE_200
341: , a3 JTF_VARCHAR2_TABLE_2000
342: , a4 JTF_VARCHAR2_TABLE_600
343: , a5 JTF_VARCHAR2_TABLE_100

Line 363: , a25 JTF_NUMBER_TABLE

359: , a21 JTF_VARCHAR2_TABLE_500
360: , a22 JTF_VARCHAR2_TABLE_500
361: , a23 JTF_VARCHAR2_TABLE_500
362: , a24 JTF_VARCHAR2_TABLE_500
363: , a25 JTF_NUMBER_TABLE
364: , a26 JTF_NUMBER_TABLE
365: , a27 JTF_NUMBER_TABLE
366: , a28 JTF_NUMBER_TABLE
367: , a29 JTF_DATE_TABLE

Line 364: , a26 JTF_NUMBER_TABLE

360: , a22 JTF_VARCHAR2_TABLE_500
361: , a23 JTF_VARCHAR2_TABLE_500
362: , a24 JTF_VARCHAR2_TABLE_500
363: , a25 JTF_NUMBER_TABLE
364: , a26 JTF_NUMBER_TABLE
365: , a27 JTF_NUMBER_TABLE
366: , a28 JTF_NUMBER_TABLE
367: , a29 JTF_DATE_TABLE
368: , a30 JTF_NUMBER_TABLE

Line 365: , a27 JTF_NUMBER_TABLE

361: , a23 JTF_VARCHAR2_TABLE_500
362: , a24 JTF_VARCHAR2_TABLE_500
363: , a25 JTF_NUMBER_TABLE
364: , a26 JTF_NUMBER_TABLE
365: , a27 JTF_NUMBER_TABLE
366: , a28 JTF_NUMBER_TABLE
367: , a29 JTF_DATE_TABLE
368: , a30 JTF_NUMBER_TABLE
369: , a31 JTF_DATE_TABLE

Line 366: , a28 JTF_NUMBER_TABLE

362: , a24 JTF_VARCHAR2_TABLE_500
363: , a25 JTF_NUMBER_TABLE
364: , a26 JTF_NUMBER_TABLE
365: , a27 JTF_NUMBER_TABLE
366: , a28 JTF_NUMBER_TABLE
367: , a29 JTF_DATE_TABLE
368: , a30 JTF_NUMBER_TABLE
369: , a31 JTF_DATE_TABLE
370: , a32 JTF_NUMBER_TABLE

Line 368: , a30 JTF_NUMBER_TABLE

364: , a26 JTF_NUMBER_TABLE
365: , a27 JTF_NUMBER_TABLE
366: , a28 JTF_NUMBER_TABLE
367: , a29 JTF_DATE_TABLE
368: , a30 JTF_NUMBER_TABLE
369: , a31 JTF_DATE_TABLE
370: , a32 JTF_NUMBER_TABLE
371: , a33 JTF_DATE_TABLE
372: , a34 JTF_NUMBER_TABLE

Line 370: , a32 JTF_NUMBER_TABLE

366: , a28 JTF_NUMBER_TABLE
367: , a29 JTF_DATE_TABLE
368: , a30 JTF_NUMBER_TABLE
369: , a31 JTF_DATE_TABLE
370: , a32 JTF_NUMBER_TABLE
371: , a33 JTF_DATE_TABLE
372: , a34 JTF_NUMBER_TABLE
373: , a35 JTF_VARCHAR2_TABLE_100
374: , a36 JTF_DATE_TABLE

Line 372: , a34 JTF_NUMBER_TABLE

368: , a30 JTF_NUMBER_TABLE
369: , a31 JTF_DATE_TABLE
370: , a32 JTF_NUMBER_TABLE
371: , a33 JTF_DATE_TABLE
372: , a34 JTF_NUMBER_TABLE
373: , a35 JTF_VARCHAR2_TABLE_100
374: , a36 JTF_DATE_TABLE
375: , a37 JTF_NUMBER_TABLE
376: , a38 JTF_VARCHAR2_TABLE_100

Line 375: , a37 JTF_NUMBER_TABLE

371: , a33 JTF_DATE_TABLE
372: , a34 JTF_NUMBER_TABLE
373: , a35 JTF_VARCHAR2_TABLE_100
374: , a36 JTF_DATE_TABLE
375: , a37 JTF_NUMBER_TABLE
376: , a38 JTF_VARCHAR2_TABLE_100
377: , a39 JTF_NUMBER_TABLE
378: ) as
379: ddindx binary_integer; indx binary_integer;

Line 377: , a39 JTF_NUMBER_TABLE

373: , a35 JTF_VARCHAR2_TABLE_100
374: , a36 JTF_DATE_TABLE
375: , a37 JTF_NUMBER_TABLE
376: , a38 JTF_VARCHAR2_TABLE_100
377: , a39 JTF_NUMBER_TABLE
378: ) as
379: ddindx binary_integer; indx binary_integer;
380: begin
381: if a0 is not null and a0.count > 0 then

Line 435: procedure rosetta_table_copy_out_p5(t okl_clh_pvt.clh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

431: end loop;
432: end if;
433: end if;
434: end rosetta_table_copy_in_p5;
435: procedure rosetta_table_copy_out_p5(t okl_clh_pvt.clh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
436: , a1 out nocopy JTF_NUMBER_TABLE
437: , a2 out nocopy JTF_VARCHAR2_TABLE_200
438: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
439: , a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 436: , a1 out nocopy JTF_NUMBER_TABLE

432: end if;
433: end if;
434: end rosetta_table_copy_in_p5;
435: procedure rosetta_table_copy_out_p5(t okl_clh_pvt.clh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
436: , a1 out nocopy JTF_NUMBER_TABLE
437: , a2 out nocopy JTF_VARCHAR2_TABLE_200
438: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
439: , a4 out nocopy JTF_VARCHAR2_TABLE_600
440: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 460: , a25 out nocopy JTF_NUMBER_TABLE

456: , a21 out nocopy JTF_VARCHAR2_TABLE_500
457: , a22 out nocopy JTF_VARCHAR2_TABLE_500
458: , a23 out nocopy JTF_VARCHAR2_TABLE_500
459: , a24 out nocopy JTF_VARCHAR2_TABLE_500
460: , a25 out nocopy JTF_NUMBER_TABLE
461: , a26 out nocopy JTF_NUMBER_TABLE
462: , a27 out nocopy JTF_NUMBER_TABLE
463: , a28 out nocopy JTF_NUMBER_TABLE
464: , a29 out nocopy JTF_DATE_TABLE

Line 461: , a26 out nocopy JTF_NUMBER_TABLE

457: , a22 out nocopy JTF_VARCHAR2_TABLE_500
458: , a23 out nocopy JTF_VARCHAR2_TABLE_500
459: , a24 out nocopy JTF_VARCHAR2_TABLE_500
460: , a25 out nocopy JTF_NUMBER_TABLE
461: , a26 out nocopy JTF_NUMBER_TABLE
462: , a27 out nocopy JTF_NUMBER_TABLE
463: , a28 out nocopy JTF_NUMBER_TABLE
464: , a29 out nocopy JTF_DATE_TABLE
465: , a30 out nocopy JTF_NUMBER_TABLE

Line 462: , a27 out nocopy JTF_NUMBER_TABLE

458: , a23 out nocopy JTF_VARCHAR2_TABLE_500
459: , a24 out nocopy JTF_VARCHAR2_TABLE_500
460: , a25 out nocopy JTF_NUMBER_TABLE
461: , a26 out nocopy JTF_NUMBER_TABLE
462: , a27 out nocopy JTF_NUMBER_TABLE
463: , a28 out nocopy JTF_NUMBER_TABLE
464: , a29 out nocopy JTF_DATE_TABLE
465: , a30 out nocopy JTF_NUMBER_TABLE
466: , a31 out nocopy JTF_DATE_TABLE

Line 463: , a28 out nocopy JTF_NUMBER_TABLE

459: , a24 out nocopy JTF_VARCHAR2_TABLE_500
460: , a25 out nocopy JTF_NUMBER_TABLE
461: , a26 out nocopy JTF_NUMBER_TABLE
462: , a27 out nocopy JTF_NUMBER_TABLE
463: , a28 out nocopy JTF_NUMBER_TABLE
464: , a29 out nocopy JTF_DATE_TABLE
465: , a30 out nocopy JTF_NUMBER_TABLE
466: , a31 out nocopy JTF_DATE_TABLE
467: , a32 out nocopy JTF_NUMBER_TABLE

Line 465: , a30 out nocopy JTF_NUMBER_TABLE

461: , a26 out nocopy JTF_NUMBER_TABLE
462: , a27 out nocopy JTF_NUMBER_TABLE
463: , a28 out nocopy JTF_NUMBER_TABLE
464: , a29 out nocopy JTF_DATE_TABLE
465: , a30 out nocopy JTF_NUMBER_TABLE
466: , a31 out nocopy JTF_DATE_TABLE
467: , a32 out nocopy JTF_NUMBER_TABLE
468: , a33 out nocopy JTF_DATE_TABLE
469: , a34 out nocopy JTF_NUMBER_TABLE

Line 467: , a32 out nocopy JTF_NUMBER_TABLE

463: , a28 out nocopy JTF_NUMBER_TABLE
464: , a29 out nocopy JTF_DATE_TABLE
465: , a30 out nocopy JTF_NUMBER_TABLE
466: , a31 out nocopy JTF_DATE_TABLE
467: , a32 out nocopy JTF_NUMBER_TABLE
468: , a33 out nocopy JTF_DATE_TABLE
469: , a34 out nocopy JTF_NUMBER_TABLE
470: , a35 out nocopy JTF_VARCHAR2_TABLE_100
471: , a36 out nocopy JTF_DATE_TABLE

Line 469: , a34 out nocopy JTF_NUMBER_TABLE

465: , a30 out nocopy JTF_NUMBER_TABLE
466: , a31 out nocopy JTF_DATE_TABLE
467: , a32 out nocopy JTF_NUMBER_TABLE
468: , a33 out nocopy JTF_DATE_TABLE
469: , a34 out nocopy JTF_NUMBER_TABLE
470: , a35 out nocopy JTF_VARCHAR2_TABLE_100
471: , a36 out nocopy JTF_DATE_TABLE
472: , a37 out nocopy JTF_NUMBER_TABLE
473: , a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 472: , a37 out nocopy JTF_NUMBER_TABLE

468: , a33 out nocopy JTF_DATE_TABLE
469: , a34 out nocopy JTF_NUMBER_TABLE
470: , a35 out nocopy JTF_VARCHAR2_TABLE_100
471: , a36 out nocopy JTF_DATE_TABLE
472: , a37 out nocopy JTF_NUMBER_TABLE
473: , a38 out nocopy JTF_VARCHAR2_TABLE_100
474: , a39 out nocopy JTF_NUMBER_TABLE
475: ) as
476: ddindx binary_integer; indx binary_integer;

Line 474: , a39 out nocopy JTF_NUMBER_TABLE

470: , a35 out nocopy JTF_VARCHAR2_TABLE_100
471: , a36 out nocopy JTF_DATE_TABLE
472: , a37 out nocopy JTF_NUMBER_TABLE
473: , a38 out nocopy JTF_VARCHAR2_TABLE_100
474: , a39 out nocopy JTF_NUMBER_TABLE
475: ) as
476: ddindx binary_integer; indx binary_integer;
477: begin
478: if t is null or t.count = 0 then

Line 479: a0 := JTF_NUMBER_TABLE();

475: ) as
476: ddindx binary_integer; indx binary_integer;
477: begin
478: if t is null or t.count = 0 then
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_VARCHAR2_TABLE_200();
482: a3 := JTF_VARCHAR2_TABLE_2000();
483: a4 := JTF_VARCHAR2_TABLE_600();

Line 480: a1 := JTF_NUMBER_TABLE();

476: ddindx binary_integer; indx binary_integer;
477: begin
478: if t is null or t.count = 0 then
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_VARCHAR2_TABLE_200();
482: a3 := JTF_VARCHAR2_TABLE_2000();
483: a4 := JTF_VARCHAR2_TABLE_600();
484: a5 := JTF_VARCHAR2_TABLE_100();

Line 504: a25 := JTF_NUMBER_TABLE();

500: a21 := JTF_VARCHAR2_TABLE_500();
501: a22 := JTF_VARCHAR2_TABLE_500();
502: a23 := JTF_VARCHAR2_TABLE_500();
503: a24 := JTF_VARCHAR2_TABLE_500();
504: a25 := JTF_NUMBER_TABLE();
505: a26 := JTF_NUMBER_TABLE();
506: a27 := JTF_NUMBER_TABLE();
507: a28 := JTF_NUMBER_TABLE();
508: a29 := JTF_DATE_TABLE();

Line 505: a26 := JTF_NUMBER_TABLE();

501: a22 := JTF_VARCHAR2_TABLE_500();
502: a23 := JTF_VARCHAR2_TABLE_500();
503: a24 := JTF_VARCHAR2_TABLE_500();
504: a25 := JTF_NUMBER_TABLE();
505: a26 := JTF_NUMBER_TABLE();
506: a27 := JTF_NUMBER_TABLE();
507: a28 := JTF_NUMBER_TABLE();
508: a29 := JTF_DATE_TABLE();
509: a30 := JTF_NUMBER_TABLE();

Line 506: a27 := JTF_NUMBER_TABLE();

502: a23 := JTF_VARCHAR2_TABLE_500();
503: a24 := JTF_VARCHAR2_TABLE_500();
504: a25 := JTF_NUMBER_TABLE();
505: a26 := JTF_NUMBER_TABLE();
506: a27 := JTF_NUMBER_TABLE();
507: a28 := JTF_NUMBER_TABLE();
508: a29 := JTF_DATE_TABLE();
509: a30 := JTF_NUMBER_TABLE();
510: a31 := JTF_DATE_TABLE();

Line 507: a28 := JTF_NUMBER_TABLE();

503: a24 := JTF_VARCHAR2_TABLE_500();
504: a25 := JTF_NUMBER_TABLE();
505: a26 := JTF_NUMBER_TABLE();
506: a27 := JTF_NUMBER_TABLE();
507: a28 := JTF_NUMBER_TABLE();
508: a29 := JTF_DATE_TABLE();
509: a30 := JTF_NUMBER_TABLE();
510: a31 := JTF_DATE_TABLE();
511: a32 := JTF_NUMBER_TABLE();

Line 509: a30 := JTF_NUMBER_TABLE();

505: a26 := JTF_NUMBER_TABLE();
506: a27 := JTF_NUMBER_TABLE();
507: a28 := JTF_NUMBER_TABLE();
508: a29 := JTF_DATE_TABLE();
509: a30 := JTF_NUMBER_TABLE();
510: a31 := JTF_DATE_TABLE();
511: a32 := JTF_NUMBER_TABLE();
512: a33 := JTF_DATE_TABLE();
513: a34 := JTF_NUMBER_TABLE();

Line 511: a32 := JTF_NUMBER_TABLE();

507: a28 := JTF_NUMBER_TABLE();
508: a29 := JTF_DATE_TABLE();
509: a30 := JTF_NUMBER_TABLE();
510: a31 := JTF_DATE_TABLE();
511: a32 := JTF_NUMBER_TABLE();
512: a33 := JTF_DATE_TABLE();
513: a34 := JTF_NUMBER_TABLE();
514: a35 := JTF_VARCHAR2_TABLE_100();
515: a36 := JTF_DATE_TABLE();

Line 513: a34 := JTF_NUMBER_TABLE();

509: a30 := JTF_NUMBER_TABLE();
510: a31 := JTF_DATE_TABLE();
511: a32 := JTF_NUMBER_TABLE();
512: a33 := JTF_DATE_TABLE();
513: a34 := JTF_NUMBER_TABLE();
514: a35 := JTF_VARCHAR2_TABLE_100();
515: a36 := JTF_DATE_TABLE();
516: a37 := JTF_NUMBER_TABLE();
517: a38 := JTF_VARCHAR2_TABLE_100();

Line 516: a37 := JTF_NUMBER_TABLE();

512: a33 := JTF_DATE_TABLE();
513: a34 := JTF_NUMBER_TABLE();
514: a35 := JTF_VARCHAR2_TABLE_100();
515: a36 := JTF_DATE_TABLE();
516: a37 := JTF_NUMBER_TABLE();
517: a38 := JTF_VARCHAR2_TABLE_100();
518: a39 := JTF_NUMBER_TABLE();
519: else
520: a0 := JTF_NUMBER_TABLE();

Line 518: a39 := JTF_NUMBER_TABLE();

514: a35 := JTF_VARCHAR2_TABLE_100();
515: a36 := JTF_DATE_TABLE();
516: a37 := JTF_NUMBER_TABLE();
517: a38 := JTF_VARCHAR2_TABLE_100();
518: a39 := JTF_NUMBER_TABLE();
519: else
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_VARCHAR2_TABLE_200();

Line 520: a0 := JTF_NUMBER_TABLE();

516: a37 := JTF_NUMBER_TABLE();
517: a38 := JTF_VARCHAR2_TABLE_100();
518: a39 := JTF_NUMBER_TABLE();
519: else
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_VARCHAR2_TABLE_200();
523: a3 := JTF_VARCHAR2_TABLE_2000();
524: a4 := JTF_VARCHAR2_TABLE_600();

Line 521: a1 := JTF_NUMBER_TABLE();

517: a38 := JTF_VARCHAR2_TABLE_100();
518: a39 := JTF_NUMBER_TABLE();
519: else
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_VARCHAR2_TABLE_200();
523: a3 := JTF_VARCHAR2_TABLE_2000();
524: a4 := JTF_VARCHAR2_TABLE_600();
525: a5 := JTF_VARCHAR2_TABLE_100();

Line 545: a25 := JTF_NUMBER_TABLE();

541: a21 := JTF_VARCHAR2_TABLE_500();
542: a22 := JTF_VARCHAR2_TABLE_500();
543: a23 := JTF_VARCHAR2_TABLE_500();
544: a24 := JTF_VARCHAR2_TABLE_500();
545: a25 := JTF_NUMBER_TABLE();
546: a26 := JTF_NUMBER_TABLE();
547: a27 := JTF_NUMBER_TABLE();
548: a28 := JTF_NUMBER_TABLE();
549: a29 := JTF_DATE_TABLE();

Line 546: a26 := JTF_NUMBER_TABLE();

542: a22 := JTF_VARCHAR2_TABLE_500();
543: a23 := JTF_VARCHAR2_TABLE_500();
544: a24 := JTF_VARCHAR2_TABLE_500();
545: a25 := JTF_NUMBER_TABLE();
546: a26 := JTF_NUMBER_TABLE();
547: a27 := JTF_NUMBER_TABLE();
548: a28 := JTF_NUMBER_TABLE();
549: a29 := JTF_DATE_TABLE();
550: a30 := JTF_NUMBER_TABLE();

Line 547: a27 := JTF_NUMBER_TABLE();

543: a23 := JTF_VARCHAR2_TABLE_500();
544: a24 := JTF_VARCHAR2_TABLE_500();
545: a25 := JTF_NUMBER_TABLE();
546: a26 := JTF_NUMBER_TABLE();
547: a27 := JTF_NUMBER_TABLE();
548: a28 := JTF_NUMBER_TABLE();
549: a29 := JTF_DATE_TABLE();
550: a30 := JTF_NUMBER_TABLE();
551: a31 := JTF_DATE_TABLE();

Line 548: a28 := JTF_NUMBER_TABLE();

544: a24 := JTF_VARCHAR2_TABLE_500();
545: a25 := JTF_NUMBER_TABLE();
546: a26 := JTF_NUMBER_TABLE();
547: a27 := JTF_NUMBER_TABLE();
548: a28 := JTF_NUMBER_TABLE();
549: a29 := JTF_DATE_TABLE();
550: a30 := JTF_NUMBER_TABLE();
551: a31 := JTF_DATE_TABLE();
552: a32 := JTF_NUMBER_TABLE();

Line 550: a30 := JTF_NUMBER_TABLE();

546: a26 := JTF_NUMBER_TABLE();
547: a27 := JTF_NUMBER_TABLE();
548: a28 := JTF_NUMBER_TABLE();
549: a29 := JTF_DATE_TABLE();
550: a30 := JTF_NUMBER_TABLE();
551: a31 := JTF_DATE_TABLE();
552: a32 := JTF_NUMBER_TABLE();
553: a33 := JTF_DATE_TABLE();
554: a34 := JTF_NUMBER_TABLE();

Line 552: a32 := JTF_NUMBER_TABLE();

548: a28 := JTF_NUMBER_TABLE();
549: a29 := JTF_DATE_TABLE();
550: a30 := JTF_NUMBER_TABLE();
551: a31 := JTF_DATE_TABLE();
552: a32 := JTF_NUMBER_TABLE();
553: a33 := JTF_DATE_TABLE();
554: a34 := JTF_NUMBER_TABLE();
555: a35 := JTF_VARCHAR2_TABLE_100();
556: a36 := JTF_DATE_TABLE();

Line 554: a34 := JTF_NUMBER_TABLE();

550: a30 := JTF_NUMBER_TABLE();
551: a31 := JTF_DATE_TABLE();
552: a32 := JTF_NUMBER_TABLE();
553: a33 := JTF_DATE_TABLE();
554: a34 := JTF_NUMBER_TABLE();
555: a35 := JTF_VARCHAR2_TABLE_100();
556: a36 := JTF_DATE_TABLE();
557: a37 := JTF_NUMBER_TABLE();
558: a38 := JTF_VARCHAR2_TABLE_100();

Line 557: a37 := JTF_NUMBER_TABLE();

553: a33 := JTF_DATE_TABLE();
554: a34 := JTF_NUMBER_TABLE();
555: a35 := JTF_VARCHAR2_TABLE_100();
556: a36 := JTF_DATE_TABLE();
557: a37 := JTF_NUMBER_TABLE();
558: a38 := JTF_VARCHAR2_TABLE_100();
559: a39 := JTF_NUMBER_TABLE();
560: if t.count > 0 then
561: a0.extend(t.count);

Line 559: a39 := JTF_NUMBER_TABLE();

555: a35 := JTF_VARCHAR2_TABLE_100();
556: a36 := JTF_DATE_TABLE();
557: a37 := JTF_NUMBER_TABLE();
558: a38 := JTF_VARCHAR2_TABLE_100();
559: a39 := JTF_NUMBER_TABLE();
560: if t.count > 0 then
561: a0.extend(t.count);
562: a1.extend(t.count);
563: a2.extend(t.count);

Line 858: , p5_a0 JTF_NUMBER_TABLE

854: , p_init_msg_list VARCHAR2
855: , x_return_status out nocopy VARCHAR2
856: , x_msg_count out nocopy NUMBER
857: , x_msg_data out nocopy VARCHAR2
858: , p5_a0 JTF_NUMBER_TABLE
859: , p5_a1 JTF_NUMBER_TABLE
860: , p5_a2 JTF_VARCHAR2_TABLE_200
861: , p5_a3 JTF_VARCHAR2_TABLE_2000
862: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 859: , p5_a1 JTF_NUMBER_TABLE

855: , x_return_status out nocopy VARCHAR2
856: , x_msg_count out nocopy NUMBER
857: , x_msg_data out nocopy VARCHAR2
858: , p5_a0 JTF_NUMBER_TABLE
859: , p5_a1 JTF_NUMBER_TABLE
860: , p5_a2 JTF_VARCHAR2_TABLE_200
861: , p5_a3 JTF_VARCHAR2_TABLE_2000
862: , p5_a4 JTF_VARCHAR2_TABLE_600
863: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 883: , p5_a25 JTF_NUMBER_TABLE

879: , p5_a21 JTF_VARCHAR2_TABLE_500
880: , p5_a22 JTF_VARCHAR2_TABLE_500
881: , p5_a23 JTF_VARCHAR2_TABLE_500
882: , p5_a24 JTF_VARCHAR2_TABLE_500
883: , p5_a25 JTF_NUMBER_TABLE
884: , p5_a26 JTF_NUMBER_TABLE
885: , p5_a27 JTF_NUMBER_TABLE
886: , p5_a28 JTF_NUMBER_TABLE
887: , p5_a29 JTF_DATE_TABLE

Line 884: , p5_a26 JTF_NUMBER_TABLE

880: , p5_a22 JTF_VARCHAR2_TABLE_500
881: , p5_a23 JTF_VARCHAR2_TABLE_500
882: , p5_a24 JTF_VARCHAR2_TABLE_500
883: , p5_a25 JTF_NUMBER_TABLE
884: , p5_a26 JTF_NUMBER_TABLE
885: , p5_a27 JTF_NUMBER_TABLE
886: , p5_a28 JTF_NUMBER_TABLE
887: , p5_a29 JTF_DATE_TABLE
888: , p5_a30 JTF_NUMBER_TABLE

Line 885: , p5_a27 JTF_NUMBER_TABLE

881: , p5_a23 JTF_VARCHAR2_TABLE_500
882: , p5_a24 JTF_VARCHAR2_TABLE_500
883: , p5_a25 JTF_NUMBER_TABLE
884: , p5_a26 JTF_NUMBER_TABLE
885: , p5_a27 JTF_NUMBER_TABLE
886: , p5_a28 JTF_NUMBER_TABLE
887: , p5_a29 JTF_DATE_TABLE
888: , p5_a30 JTF_NUMBER_TABLE
889: , p5_a31 JTF_DATE_TABLE

Line 886: , p5_a28 JTF_NUMBER_TABLE

882: , p5_a24 JTF_VARCHAR2_TABLE_500
883: , p5_a25 JTF_NUMBER_TABLE
884: , p5_a26 JTF_NUMBER_TABLE
885: , p5_a27 JTF_NUMBER_TABLE
886: , p5_a28 JTF_NUMBER_TABLE
887: , p5_a29 JTF_DATE_TABLE
888: , p5_a30 JTF_NUMBER_TABLE
889: , p5_a31 JTF_DATE_TABLE
890: , p5_a32 JTF_NUMBER_TABLE

Line 888: , p5_a30 JTF_NUMBER_TABLE

884: , p5_a26 JTF_NUMBER_TABLE
885: , p5_a27 JTF_NUMBER_TABLE
886: , p5_a28 JTF_NUMBER_TABLE
887: , p5_a29 JTF_DATE_TABLE
888: , p5_a30 JTF_NUMBER_TABLE
889: , p5_a31 JTF_DATE_TABLE
890: , p5_a32 JTF_NUMBER_TABLE
891: , p5_a33 JTF_DATE_TABLE
892: , p5_a34 JTF_NUMBER_TABLE

Line 890: , p5_a32 JTF_NUMBER_TABLE

886: , p5_a28 JTF_NUMBER_TABLE
887: , p5_a29 JTF_DATE_TABLE
888: , p5_a30 JTF_NUMBER_TABLE
889: , p5_a31 JTF_DATE_TABLE
890: , p5_a32 JTF_NUMBER_TABLE
891: , p5_a33 JTF_DATE_TABLE
892: , p5_a34 JTF_NUMBER_TABLE
893: , p5_a35 JTF_VARCHAR2_TABLE_100
894: , p5_a36 JTF_DATE_TABLE

Line 892: , p5_a34 JTF_NUMBER_TABLE

888: , p5_a30 JTF_NUMBER_TABLE
889: , p5_a31 JTF_DATE_TABLE
890: , p5_a32 JTF_NUMBER_TABLE
891: , p5_a33 JTF_DATE_TABLE
892: , p5_a34 JTF_NUMBER_TABLE
893: , p5_a35 JTF_VARCHAR2_TABLE_100
894: , p5_a36 JTF_DATE_TABLE
895: , p5_a37 JTF_NUMBER_TABLE
896: , p5_a38 JTF_VARCHAR2_TABLE_100

Line 895: , p5_a37 JTF_NUMBER_TABLE

891: , p5_a33 JTF_DATE_TABLE
892: , p5_a34 JTF_NUMBER_TABLE
893: , p5_a35 JTF_VARCHAR2_TABLE_100
894: , p5_a36 JTF_DATE_TABLE
895: , p5_a37 JTF_NUMBER_TABLE
896: , p5_a38 JTF_VARCHAR2_TABLE_100
897: , p5_a39 JTF_NUMBER_TABLE
898: , p6_a0 out nocopy JTF_NUMBER_TABLE
899: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 897: , p5_a39 JTF_NUMBER_TABLE

893: , p5_a35 JTF_VARCHAR2_TABLE_100
894: , p5_a36 JTF_DATE_TABLE
895: , p5_a37 JTF_NUMBER_TABLE
896: , p5_a38 JTF_VARCHAR2_TABLE_100
897: , p5_a39 JTF_NUMBER_TABLE
898: , p6_a0 out nocopy JTF_NUMBER_TABLE
899: , p6_a1 out nocopy JTF_NUMBER_TABLE
900: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
901: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 898: , p6_a0 out nocopy JTF_NUMBER_TABLE

894: , p5_a36 JTF_DATE_TABLE
895: , p5_a37 JTF_NUMBER_TABLE
896: , p5_a38 JTF_VARCHAR2_TABLE_100
897: , p5_a39 JTF_NUMBER_TABLE
898: , p6_a0 out nocopy JTF_NUMBER_TABLE
899: , p6_a1 out nocopy JTF_NUMBER_TABLE
900: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
901: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
902: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 899: , p6_a1 out nocopy JTF_NUMBER_TABLE

895: , p5_a37 JTF_NUMBER_TABLE
896: , p5_a38 JTF_VARCHAR2_TABLE_100
897: , p5_a39 JTF_NUMBER_TABLE
898: , p6_a0 out nocopy JTF_NUMBER_TABLE
899: , p6_a1 out nocopy JTF_NUMBER_TABLE
900: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
901: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
902: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
903: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 923: , p6_a25 out nocopy JTF_NUMBER_TABLE

919: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
920: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
921: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
922: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
923: , p6_a25 out nocopy JTF_NUMBER_TABLE
924: , p6_a26 out nocopy JTF_NUMBER_TABLE
925: , p6_a27 out nocopy JTF_NUMBER_TABLE
926: , p6_a28 out nocopy JTF_NUMBER_TABLE
927: , p6_a29 out nocopy JTF_DATE_TABLE

Line 924: , p6_a26 out nocopy JTF_NUMBER_TABLE

920: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
921: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
922: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
923: , p6_a25 out nocopy JTF_NUMBER_TABLE
924: , p6_a26 out nocopy JTF_NUMBER_TABLE
925: , p6_a27 out nocopy JTF_NUMBER_TABLE
926: , p6_a28 out nocopy JTF_NUMBER_TABLE
927: , p6_a29 out nocopy JTF_DATE_TABLE
928: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 925: , p6_a27 out nocopy JTF_NUMBER_TABLE

921: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
922: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
923: , p6_a25 out nocopy JTF_NUMBER_TABLE
924: , p6_a26 out nocopy JTF_NUMBER_TABLE
925: , p6_a27 out nocopy JTF_NUMBER_TABLE
926: , p6_a28 out nocopy JTF_NUMBER_TABLE
927: , p6_a29 out nocopy JTF_DATE_TABLE
928: , p6_a30 out nocopy JTF_NUMBER_TABLE
929: , p6_a31 out nocopy JTF_DATE_TABLE

Line 926: , p6_a28 out nocopy JTF_NUMBER_TABLE

922: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
923: , p6_a25 out nocopy JTF_NUMBER_TABLE
924: , p6_a26 out nocopy JTF_NUMBER_TABLE
925: , p6_a27 out nocopy JTF_NUMBER_TABLE
926: , p6_a28 out nocopy JTF_NUMBER_TABLE
927: , p6_a29 out nocopy JTF_DATE_TABLE
928: , p6_a30 out nocopy JTF_NUMBER_TABLE
929: , p6_a31 out nocopy JTF_DATE_TABLE
930: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 928: , p6_a30 out nocopy JTF_NUMBER_TABLE

924: , p6_a26 out nocopy JTF_NUMBER_TABLE
925: , p6_a27 out nocopy JTF_NUMBER_TABLE
926: , p6_a28 out nocopy JTF_NUMBER_TABLE
927: , p6_a29 out nocopy JTF_DATE_TABLE
928: , p6_a30 out nocopy JTF_NUMBER_TABLE
929: , p6_a31 out nocopy JTF_DATE_TABLE
930: , p6_a32 out nocopy JTF_NUMBER_TABLE
931: , p6_a33 out nocopy JTF_DATE_TABLE
932: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 930: , p6_a32 out nocopy JTF_NUMBER_TABLE

926: , p6_a28 out nocopy JTF_NUMBER_TABLE
927: , p6_a29 out nocopy JTF_DATE_TABLE
928: , p6_a30 out nocopy JTF_NUMBER_TABLE
929: , p6_a31 out nocopy JTF_DATE_TABLE
930: , p6_a32 out nocopy JTF_NUMBER_TABLE
931: , p6_a33 out nocopy JTF_DATE_TABLE
932: , p6_a34 out nocopy JTF_NUMBER_TABLE
933: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
934: , p6_a36 out nocopy JTF_DATE_TABLE

Line 932: , p6_a34 out nocopy JTF_NUMBER_TABLE

928: , p6_a30 out nocopy JTF_NUMBER_TABLE
929: , p6_a31 out nocopy JTF_DATE_TABLE
930: , p6_a32 out nocopy JTF_NUMBER_TABLE
931: , p6_a33 out nocopy JTF_DATE_TABLE
932: , p6_a34 out nocopy JTF_NUMBER_TABLE
933: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
934: , p6_a36 out nocopy JTF_DATE_TABLE
935: , p6_a37 out nocopy JTF_NUMBER_TABLE
936: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 935: , p6_a37 out nocopy JTF_NUMBER_TABLE

931: , p6_a33 out nocopy JTF_DATE_TABLE
932: , p6_a34 out nocopy JTF_NUMBER_TABLE
933: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
934: , p6_a36 out nocopy JTF_DATE_TABLE
935: , p6_a37 out nocopy JTF_NUMBER_TABLE
936: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
937: , p6_a39 out nocopy JTF_NUMBER_TABLE
938: )
939:

Line 937: , p6_a39 out nocopy JTF_NUMBER_TABLE

933: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
934: , p6_a36 out nocopy JTF_DATE_TABLE
935: , p6_a37 out nocopy JTF_NUMBER_TABLE
936: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
937: , p6_a39 out nocopy JTF_NUMBER_TABLE
938: )
939:
940: as
941: ddp_clhv_tbl okl_clh_pvt.clhv_tbl_type;

Line 1174: , p5_a0 JTF_NUMBER_TABLE

1170: , p_init_msg_list VARCHAR2
1171: , x_return_status out nocopy VARCHAR2
1172: , x_msg_count out nocopy NUMBER
1173: , x_msg_data out nocopy VARCHAR2
1174: , p5_a0 JTF_NUMBER_TABLE
1175: , p5_a1 JTF_NUMBER_TABLE
1176: , p5_a2 JTF_VARCHAR2_TABLE_200
1177: , p5_a3 JTF_VARCHAR2_TABLE_2000
1178: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 1175: , p5_a1 JTF_NUMBER_TABLE

1171: , x_return_status out nocopy VARCHAR2
1172: , x_msg_count out nocopy NUMBER
1173: , x_msg_data out nocopy VARCHAR2
1174: , p5_a0 JTF_NUMBER_TABLE
1175: , p5_a1 JTF_NUMBER_TABLE
1176: , p5_a2 JTF_VARCHAR2_TABLE_200
1177: , p5_a3 JTF_VARCHAR2_TABLE_2000
1178: , p5_a4 JTF_VARCHAR2_TABLE_600
1179: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1199: , p5_a25 JTF_NUMBER_TABLE

1195: , p5_a21 JTF_VARCHAR2_TABLE_500
1196: , p5_a22 JTF_VARCHAR2_TABLE_500
1197: , p5_a23 JTF_VARCHAR2_TABLE_500
1198: , p5_a24 JTF_VARCHAR2_TABLE_500
1199: , p5_a25 JTF_NUMBER_TABLE
1200: , p5_a26 JTF_NUMBER_TABLE
1201: , p5_a27 JTF_NUMBER_TABLE
1202: , p5_a28 JTF_NUMBER_TABLE
1203: , p5_a29 JTF_DATE_TABLE

Line 1200: , p5_a26 JTF_NUMBER_TABLE

1196: , p5_a22 JTF_VARCHAR2_TABLE_500
1197: , p5_a23 JTF_VARCHAR2_TABLE_500
1198: , p5_a24 JTF_VARCHAR2_TABLE_500
1199: , p5_a25 JTF_NUMBER_TABLE
1200: , p5_a26 JTF_NUMBER_TABLE
1201: , p5_a27 JTF_NUMBER_TABLE
1202: , p5_a28 JTF_NUMBER_TABLE
1203: , p5_a29 JTF_DATE_TABLE
1204: , p5_a30 JTF_NUMBER_TABLE

Line 1201: , p5_a27 JTF_NUMBER_TABLE

1197: , p5_a23 JTF_VARCHAR2_TABLE_500
1198: , p5_a24 JTF_VARCHAR2_TABLE_500
1199: , p5_a25 JTF_NUMBER_TABLE
1200: , p5_a26 JTF_NUMBER_TABLE
1201: , p5_a27 JTF_NUMBER_TABLE
1202: , p5_a28 JTF_NUMBER_TABLE
1203: , p5_a29 JTF_DATE_TABLE
1204: , p5_a30 JTF_NUMBER_TABLE
1205: , p5_a31 JTF_DATE_TABLE

Line 1202: , p5_a28 JTF_NUMBER_TABLE

1198: , p5_a24 JTF_VARCHAR2_TABLE_500
1199: , p5_a25 JTF_NUMBER_TABLE
1200: , p5_a26 JTF_NUMBER_TABLE
1201: , p5_a27 JTF_NUMBER_TABLE
1202: , p5_a28 JTF_NUMBER_TABLE
1203: , p5_a29 JTF_DATE_TABLE
1204: , p5_a30 JTF_NUMBER_TABLE
1205: , p5_a31 JTF_DATE_TABLE
1206: , p5_a32 JTF_NUMBER_TABLE

Line 1204: , p5_a30 JTF_NUMBER_TABLE

1200: , p5_a26 JTF_NUMBER_TABLE
1201: , p5_a27 JTF_NUMBER_TABLE
1202: , p5_a28 JTF_NUMBER_TABLE
1203: , p5_a29 JTF_DATE_TABLE
1204: , p5_a30 JTF_NUMBER_TABLE
1205: , p5_a31 JTF_DATE_TABLE
1206: , p5_a32 JTF_NUMBER_TABLE
1207: , p5_a33 JTF_DATE_TABLE
1208: , p5_a34 JTF_NUMBER_TABLE

Line 1206: , p5_a32 JTF_NUMBER_TABLE

1202: , p5_a28 JTF_NUMBER_TABLE
1203: , p5_a29 JTF_DATE_TABLE
1204: , p5_a30 JTF_NUMBER_TABLE
1205: , p5_a31 JTF_DATE_TABLE
1206: , p5_a32 JTF_NUMBER_TABLE
1207: , p5_a33 JTF_DATE_TABLE
1208: , p5_a34 JTF_NUMBER_TABLE
1209: , p5_a35 JTF_VARCHAR2_TABLE_100
1210: , p5_a36 JTF_DATE_TABLE

Line 1208: , p5_a34 JTF_NUMBER_TABLE

1204: , p5_a30 JTF_NUMBER_TABLE
1205: , p5_a31 JTF_DATE_TABLE
1206: , p5_a32 JTF_NUMBER_TABLE
1207: , p5_a33 JTF_DATE_TABLE
1208: , p5_a34 JTF_NUMBER_TABLE
1209: , p5_a35 JTF_VARCHAR2_TABLE_100
1210: , p5_a36 JTF_DATE_TABLE
1211: , p5_a37 JTF_NUMBER_TABLE
1212: , p5_a38 JTF_VARCHAR2_TABLE_100

Line 1211: , p5_a37 JTF_NUMBER_TABLE

1207: , p5_a33 JTF_DATE_TABLE
1208: , p5_a34 JTF_NUMBER_TABLE
1209: , p5_a35 JTF_VARCHAR2_TABLE_100
1210: , p5_a36 JTF_DATE_TABLE
1211: , p5_a37 JTF_NUMBER_TABLE
1212: , p5_a38 JTF_VARCHAR2_TABLE_100
1213: , p5_a39 JTF_NUMBER_TABLE
1214: )
1215:

Line 1213: , p5_a39 JTF_NUMBER_TABLE

1209: , p5_a35 JTF_VARCHAR2_TABLE_100
1210: , p5_a36 JTF_DATE_TABLE
1211: , p5_a37 JTF_NUMBER_TABLE
1212: , p5_a38 JTF_VARCHAR2_TABLE_100
1213: , p5_a39 JTF_NUMBER_TABLE
1214: )
1215:
1216: as
1217: ddp_clhv_tbl okl_clh_pvt.clhv_tbl_type;

Line 1489: , p5_a0 JTF_NUMBER_TABLE

1485: , p_init_msg_list VARCHAR2
1486: , x_return_status out nocopy VARCHAR2
1487: , x_msg_count out nocopy NUMBER
1488: , x_msg_data out nocopy VARCHAR2
1489: , p5_a0 JTF_NUMBER_TABLE
1490: , p5_a1 JTF_NUMBER_TABLE
1491: , p5_a2 JTF_VARCHAR2_TABLE_200
1492: , p5_a3 JTF_VARCHAR2_TABLE_2000
1493: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 1490: , p5_a1 JTF_NUMBER_TABLE

1486: , x_return_status out nocopy VARCHAR2
1487: , x_msg_count out nocopy NUMBER
1488: , x_msg_data out nocopy VARCHAR2
1489: , p5_a0 JTF_NUMBER_TABLE
1490: , p5_a1 JTF_NUMBER_TABLE
1491: , p5_a2 JTF_VARCHAR2_TABLE_200
1492: , p5_a3 JTF_VARCHAR2_TABLE_2000
1493: , p5_a4 JTF_VARCHAR2_TABLE_600
1494: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1514: , p5_a25 JTF_NUMBER_TABLE

1510: , p5_a21 JTF_VARCHAR2_TABLE_500
1511: , p5_a22 JTF_VARCHAR2_TABLE_500
1512: , p5_a23 JTF_VARCHAR2_TABLE_500
1513: , p5_a24 JTF_VARCHAR2_TABLE_500
1514: , p5_a25 JTF_NUMBER_TABLE
1515: , p5_a26 JTF_NUMBER_TABLE
1516: , p5_a27 JTF_NUMBER_TABLE
1517: , p5_a28 JTF_NUMBER_TABLE
1518: , p5_a29 JTF_DATE_TABLE

Line 1515: , p5_a26 JTF_NUMBER_TABLE

1511: , p5_a22 JTF_VARCHAR2_TABLE_500
1512: , p5_a23 JTF_VARCHAR2_TABLE_500
1513: , p5_a24 JTF_VARCHAR2_TABLE_500
1514: , p5_a25 JTF_NUMBER_TABLE
1515: , p5_a26 JTF_NUMBER_TABLE
1516: , p5_a27 JTF_NUMBER_TABLE
1517: , p5_a28 JTF_NUMBER_TABLE
1518: , p5_a29 JTF_DATE_TABLE
1519: , p5_a30 JTF_NUMBER_TABLE

Line 1516: , p5_a27 JTF_NUMBER_TABLE

1512: , p5_a23 JTF_VARCHAR2_TABLE_500
1513: , p5_a24 JTF_VARCHAR2_TABLE_500
1514: , p5_a25 JTF_NUMBER_TABLE
1515: , p5_a26 JTF_NUMBER_TABLE
1516: , p5_a27 JTF_NUMBER_TABLE
1517: , p5_a28 JTF_NUMBER_TABLE
1518: , p5_a29 JTF_DATE_TABLE
1519: , p5_a30 JTF_NUMBER_TABLE
1520: , p5_a31 JTF_DATE_TABLE

Line 1517: , p5_a28 JTF_NUMBER_TABLE

1513: , p5_a24 JTF_VARCHAR2_TABLE_500
1514: , p5_a25 JTF_NUMBER_TABLE
1515: , p5_a26 JTF_NUMBER_TABLE
1516: , p5_a27 JTF_NUMBER_TABLE
1517: , p5_a28 JTF_NUMBER_TABLE
1518: , p5_a29 JTF_DATE_TABLE
1519: , p5_a30 JTF_NUMBER_TABLE
1520: , p5_a31 JTF_DATE_TABLE
1521: , p5_a32 JTF_NUMBER_TABLE

Line 1519: , p5_a30 JTF_NUMBER_TABLE

1515: , p5_a26 JTF_NUMBER_TABLE
1516: , p5_a27 JTF_NUMBER_TABLE
1517: , p5_a28 JTF_NUMBER_TABLE
1518: , p5_a29 JTF_DATE_TABLE
1519: , p5_a30 JTF_NUMBER_TABLE
1520: , p5_a31 JTF_DATE_TABLE
1521: , p5_a32 JTF_NUMBER_TABLE
1522: , p5_a33 JTF_DATE_TABLE
1523: , p5_a34 JTF_NUMBER_TABLE

Line 1521: , p5_a32 JTF_NUMBER_TABLE

1517: , p5_a28 JTF_NUMBER_TABLE
1518: , p5_a29 JTF_DATE_TABLE
1519: , p5_a30 JTF_NUMBER_TABLE
1520: , p5_a31 JTF_DATE_TABLE
1521: , p5_a32 JTF_NUMBER_TABLE
1522: , p5_a33 JTF_DATE_TABLE
1523: , p5_a34 JTF_NUMBER_TABLE
1524: , p5_a35 JTF_VARCHAR2_TABLE_100
1525: , p5_a36 JTF_DATE_TABLE

Line 1523: , p5_a34 JTF_NUMBER_TABLE

1519: , p5_a30 JTF_NUMBER_TABLE
1520: , p5_a31 JTF_DATE_TABLE
1521: , p5_a32 JTF_NUMBER_TABLE
1522: , p5_a33 JTF_DATE_TABLE
1523: , p5_a34 JTF_NUMBER_TABLE
1524: , p5_a35 JTF_VARCHAR2_TABLE_100
1525: , p5_a36 JTF_DATE_TABLE
1526: , p5_a37 JTF_NUMBER_TABLE
1527: , p5_a38 JTF_VARCHAR2_TABLE_100

Line 1526: , p5_a37 JTF_NUMBER_TABLE

1522: , p5_a33 JTF_DATE_TABLE
1523: , p5_a34 JTF_NUMBER_TABLE
1524: , p5_a35 JTF_VARCHAR2_TABLE_100
1525: , p5_a36 JTF_DATE_TABLE
1526: , p5_a37 JTF_NUMBER_TABLE
1527: , p5_a38 JTF_VARCHAR2_TABLE_100
1528: , p5_a39 JTF_NUMBER_TABLE
1529: , p6_a0 out nocopy JTF_NUMBER_TABLE
1530: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 1528: , p5_a39 JTF_NUMBER_TABLE

1524: , p5_a35 JTF_VARCHAR2_TABLE_100
1525: , p5_a36 JTF_DATE_TABLE
1526: , p5_a37 JTF_NUMBER_TABLE
1527: , p5_a38 JTF_VARCHAR2_TABLE_100
1528: , p5_a39 JTF_NUMBER_TABLE
1529: , p6_a0 out nocopy JTF_NUMBER_TABLE
1530: , p6_a1 out nocopy JTF_NUMBER_TABLE
1531: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1532: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1529: , p6_a0 out nocopy JTF_NUMBER_TABLE

1525: , p5_a36 JTF_DATE_TABLE
1526: , p5_a37 JTF_NUMBER_TABLE
1527: , p5_a38 JTF_VARCHAR2_TABLE_100
1528: , p5_a39 JTF_NUMBER_TABLE
1529: , p6_a0 out nocopy JTF_NUMBER_TABLE
1530: , p6_a1 out nocopy JTF_NUMBER_TABLE
1531: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1532: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1533: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 1530: , p6_a1 out nocopy JTF_NUMBER_TABLE

1526: , p5_a37 JTF_NUMBER_TABLE
1527: , p5_a38 JTF_VARCHAR2_TABLE_100
1528: , p5_a39 JTF_NUMBER_TABLE
1529: , p6_a0 out nocopy JTF_NUMBER_TABLE
1530: , p6_a1 out nocopy JTF_NUMBER_TABLE
1531: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1532: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1533: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1534: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1554: , p6_a25 out nocopy JTF_NUMBER_TABLE

1550: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1551: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1552: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1553: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1554: , p6_a25 out nocopy JTF_NUMBER_TABLE
1555: , p6_a26 out nocopy JTF_NUMBER_TABLE
1556: , p6_a27 out nocopy JTF_NUMBER_TABLE
1557: , p6_a28 out nocopy JTF_NUMBER_TABLE
1558: , p6_a29 out nocopy JTF_DATE_TABLE

Line 1555: , p6_a26 out nocopy JTF_NUMBER_TABLE

1551: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1552: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1553: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1554: , p6_a25 out nocopy JTF_NUMBER_TABLE
1555: , p6_a26 out nocopy JTF_NUMBER_TABLE
1556: , p6_a27 out nocopy JTF_NUMBER_TABLE
1557: , p6_a28 out nocopy JTF_NUMBER_TABLE
1558: , p6_a29 out nocopy JTF_DATE_TABLE
1559: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 1556: , p6_a27 out nocopy JTF_NUMBER_TABLE

1552: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1553: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1554: , p6_a25 out nocopy JTF_NUMBER_TABLE
1555: , p6_a26 out nocopy JTF_NUMBER_TABLE
1556: , p6_a27 out nocopy JTF_NUMBER_TABLE
1557: , p6_a28 out nocopy JTF_NUMBER_TABLE
1558: , p6_a29 out nocopy JTF_DATE_TABLE
1559: , p6_a30 out nocopy JTF_NUMBER_TABLE
1560: , p6_a31 out nocopy JTF_DATE_TABLE

Line 1557: , p6_a28 out nocopy JTF_NUMBER_TABLE

1553: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1554: , p6_a25 out nocopy JTF_NUMBER_TABLE
1555: , p6_a26 out nocopy JTF_NUMBER_TABLE
1556: , p6_a27 out nocopy JTF_NUMBER_TABLE
1557: , p6_a28 out nocopy JTF_NUMBER_TABLE
1558: , p6_a29 out nocopy JTF_DATE_TABLE
1559: , p6_a30 out nocopy JTF_NUMBER_TABLE
1560: , p6_a31 out nocopy JTF_DATE_TABLE
1561: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 1559: , p6_a30 out nocopy JTF_NUMBER_TABLE

1555: , p6_a26 out nocopy JTF_NUMBER_TABLE
1556: , p6_a27 out nocopy JTF_NUMBER_TABLE
1557: , p6_a28 out nocopy JTF_NUMBER_TABLE
1558: , p6_a29 out nocopy JTF_DATE_TABLE
1559: , p6_a30 out nocopy JTF_NUMBER_TABLE
1560: , p6_a31 out nocopy JTF_DATE_TABLE
1561: , p6_a32 out nocopy JTF_NUMBER_TABLE
1562: , p6_a33 out nocopy JTF_DATE_TABLE
1563: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 1561: , p6_a32 out nocopy JTF_NUMBER_TABLE

1557: , p6_a28 out nocopy JTF_NUMBER_TABLE
1558: , p6_a29 out nocopy JTF_DATE_TABLE
1559: , p6_a30 out nocopy JTF_NUMBER_TABLE
1560: , p6_a31 out nocopy JTF_DATE_TABLE
1561: , p6_a32 out nocopy JTF_NUMBER_TABLE
1562: , p6_a33 out nocopy JTF_DATE_TABLE
1563: , p6_a34 out nocopy JTF_NUMBER_TABLE
1564: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
1565: , p6_a36 out nocopy JTF_DATE_TABLE

Line 1563: , p6_a34 out nocopy JTF_NUMBER_TABLE

1559: , p6_a30 out nocopy JTF_NUMBER_TABLE
1560: , p6_a31 out nocopy JTF_DATE_TABLE
1561: , p6_a32 out nocopy JTF_NUMBER_TABLE
1562: , p6_a33 out nocopy JTF_DATE_TABLE
1563: , p6_a34 out nocopy JTF_NUMBER_TABLE
1564: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
1565: , p6_a36 out nocopy JTF_DATE_TABLE
1566: , p6_a37 out nocopy JTF_NUMBER_TABLE
1567: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 1566: , p6_a37 out nocopy JTF_NUMBER_TABLE

1562: , p6_a33 out nocopy JTF_DATE_TABLE
1563: , p6_a34 out nocopy JTF_NUMBER_TABLE
1564: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
1565: , p6_a36 out nocopy JTF_DATE_TABLE
1566: , p6_a37 out nocopy JTF_NUMBER_TABLE
1567: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1568: , p6_a39 out nocopy JTF_NUMBER_TABLE
1569: )
1570:

Line 1568: , p6_a39 out nocopy JTF_NUMBER_TABLE

1564: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
1565: , p6_a36 out nocopy JTF_DATE_TABLE
1566: , p6_a37 out nocopy JTF_NUMBER_TABLE
1567: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1568: , p6_a39 out nocopy JTF_NUMBER_TABLE
1569: )
1570:
1571: as
1572: ddp_clhv_tbl okl_clh_pvt.clhv_tbl_type;

Line 1805: , p5_a0 JTF_NUMBER_TABLE

1801: , p_init_msg_list VARCHAR2
1802: , x_return_status out nocopy VARCHAR2
1803: , x_msg_count out nocopy NUMBER
1804: , x_msg_data out nocopy VARCHAR2
1805: , p5_a0 JTF_NUMBER_TABLE
1806: , p5_a1 JTF_NUMBER_TABLE
1807: , p5_a2 JTF_VARCHAR2_TABLE_200
1808: , p5_a3 JTF_VARCHAR2_TABLE_2000
1809: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 1806: , p5_a1 JTF_NUMBER_TABLE

1802: , x_return_status out nocopy VARCHAR2
1803: , x_msg_count out nocopy NUMBER
1804: , x_msg_data out nocopy VARCHAR2
1805: , p5_a0 JTF_NUMBER_TABLE
1806: , p5_a1 JTF_NUMBER_TABLE
1807: , p5_a2 JTF_VARCHAR2_TABLE_200
1808: , p5_a3 JTF_VARCHAR2_TABLE_2000
1809: , p5_a4 JTF_VARCHAR2_TABLE_600
1810: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1830: , p5_a25 JTF_NUMBER_TABLE

1826: , p5_a21 JTF_VARCHAR2_TABLE_500
1827: , p5_a22 JTF_VARCHAR2_TABLE_500
1828: , p5_a23 JTF_VARCHAR2_TABLE_500
1829: , p5_a24 JTF_VARCHAR2_TABLE_500
1830: , p5_a25 JTF_NUMBER_TABLE
1831: , p5_a26 JTF_NUMBER_TABLE
1832: , p5_a27 JTF_NUMBER_TABLE
1833: , p5_a28 JTF_NUMBER_TABLE
1834: , p5_a29 JTF_DATE_TABLE

Line 1831: , p5_a26 JTF_NUMBER_TABLE

1827: , p5_a22 JTF_VARCHAR2_TABLE_500
1828: , p5_a23 JTF_VARCHAR2_TABLE_500
1829: , p5_a24 JTF_VARCHAR2_TABLE_500
1830: , p5_a25 JTF_NUMBER_TABLE
1831: , p5_a26 JTF_NUMBER_TABLE
1832: , p5_a27 JTF_NUMBER_TABLE
1833: , p5_a28 JTF_NUMBER_TABLE
1834: , p5_a29 JTF_DATE_TABLE
1835: , p5_a30 JTF_NUMBER_TABLE

Line 1832: , p5_a27 JTF_NUMBER_TABLE

1828: , p5_a23 JTF_VARCHAR2_TABLE_500
1829: , p5_a24 JTF_VARCHAR2_TABLE_500
1830: , p5_a25 JTF_NUMBER_TABLE
1831: , p5_a26 JTF_NUMBER_TABLE
1832: , p5_a27 JTF_NUMBER_TABLE
1833: , p5_a28 JTF_NUMBER_TABLE
1834: , p5_a29 JTF_DATE_TABLE
1835: , p5_a30 JTF_NUMBER_TABLE
1836: , p5_a31 JTF_DATE_TABLE

Line 1833: , p5_a28 JTF_NUMBER_TABLE

1829: , p5_a24 JTF_VARCHAR2_TABLE_500
1830: , p5_a25 JTF_NUMBER_TABLE
1831: , p5_a26 JTF_NUMBER_TABLE
1832: , p5_a27 JTF_NUMBER_TABLE
1833: , p5_a28 JTF_NUMBER_TABLE
1834: , p5_a29 JTF_DATE_TABLE
1835: , p5_a30 JTF_NUMBER_TABLE
1836: , p5_a31 JTF_DATE_TABLE
1837: , p5_a32 JTF_NUMBER_TABLE

Line 1835: , p5_a30 JTF_NUMBER_TABLE

1831: , p5_a26 JTF_NUMBER_TABLE
1832: , p5_a27 JTF_NUMBER_TABLE
1833: , p5_a28 JTF_NUMBER_TABLE
1834: , p5_a29 JTF_DATE_TABLE
1835: , p5_a30 JTF_NUMBER_TABLE
1836: , p5_a31 JTF_DATE_TABLE
1837: , p5_a32 JTF_NUMBER_TABLE
1838: , p5_a33 JTF_DATE_TABLE
1839: , p5_a34 JTF_NUMBER_TABLE

Line 1837: , p5_a32 JTF_NUMBER_TABLE

1833: , p5_a28 JTF_NUMBER_TABLE
1834: , p5_a29 JTF_DATE_TABLE
1835: , p5_a30 JTF_NUMBER_TABLE
1836: , p5_a31 JTF_DATE_TABLE
1837: , p5_a32 JTF_NUMBER_TABLE
1838: , p5_a33 JTF_DATE_TABLE
1839: , p5_a34 JTF_NUMBER_TABLE
1840: , p5_a35 JTF_VARCHAR2_TABLE_100
1841: , p5_a36 JTF_DATE_TABLE

Line 1839: , p5_a34 JTF_NUMBER_TABLE

1835: , p5_a30 JTF_NUMBER_TABLE
1836: , p5_a31 JTF_DATE_TABLE
1837: , p5_a32 JTF_NUMBER_TABLE
1838: , p5_a33 JTF_DATE_TABLE
1839: , p5_a34 JTF_NUMBER_TABLE
1840: , p5_a35 JTF_VARCHAR2_TABLE_100
1841: , p5_a36 JTF_DATE_TABLE
1842: , p5_a37 JTF_NUMBER_TABLE
1843: , p5_a38 JTF_VARCHAR2_TABLE_100

Line 1842: , p5_a37 JTF_NUMBER_TABLE

1838: , p5_a33 JTF_DATE_TABLE
1839: , p5_a34 JTF_NUMBER_TABLE
1840: , p5_a35 JTF_VARCHAR2_TABLE_100
1841: , p5_a36 JTF_DATE_TABLE
1842: , p5_a37 JTF_NUMBER_TABLE
1843: , p5_a38 JTF_VARCHAR2_TABLE_100
1844: , p5_a39 JTF_NUMBER_TABLE
1845: )
1846:

Line 1844: , p5_a39 JTF_NUMBER_TABLE

1840: , p5_a35 JTF_VARCHAR2_TABLE_100
1841: , p5_a36 JTF_DATE_TABLE
1842: , p5_a37 JTF_NUMBER_TABLE
1843: , p5_a38 JTF_VARCHAR2_TABLE_100
1844: , p5_a39 JTF_NUMBER_TABLE
1845: )
1846:
1847: as
1848: ddp_clhv_tbl okl_clh_pvt.clhv_tbl_type;

Line 2036: , p5_a0 JTF_NUMBER_TABLE

2032: , p_init_msg_list VARCHAR2
2033: , x_return_status out nocopy VARCHAR2
2034: , x_msg_count out nocopy NUMBER
2035: , x_msg_data out nocopy VARCHAR2
2036: , p5_a0 JTF_NUMBER_TABLE
2037: , p5_a1 JTF_NUMBER_TABLE
2038: , p5_a2 JTF_VARCHAR2_TABLE_200
2039: , p5_a3 JTF_VARCHAR2_TABLE_2000
2040: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 2037: , p5_a1 JTF_NUMBER_TABLE

2033: , x_return_status out nocopy VARCHAR2
2034: , x_msg_count out nocopy NUMBER
2035: , x_msg_data out nocopy VARCHAR2
2036: , p5_a0 JTF_NUMBER_TABLE
2037: , p5_a1 JTF_NUMBER_TABLE
2038: , p5_a2 JTF_VARCHAR2_TABLE_200
2039: , p5_a3 JTF_VARCHAR2_TABLE_2000
2040: , p5_a4 JTF_VARCHAR2_TABLE_600
2041: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 2061: , p5_a25 JTF_NUMBER_TABLE

2057: , p5_a21 JTF_VARCHAR2_TABLE_500
2058: , p5_a22 JTF_VARCHAR2_TABLE_500
2059: , p5_a23 JTF_VARCHAR2_TABLE_500
2060: , p5_a24 JTF_VARCHAR2_TABLE_500
2061: , p5_a25 JTF_NUMBER_TABLE
2062: , p5_a26 JTF_NUMBER_TABLE
2063: , p5_a27 JTF_NUMBER_TABLE
2064: , p5_a28 JTF_NUMBER_TABLE
2065: , p5_a29 JTF_DATE_TABLE

Line 2062: , p5_a26 JTF_NUMBER_TABLE

2058: , p5_a22 JTF_VARCHAR2_TABLE_500
2059: , p5_a23 JTF_VARCHAR2_TABLE_500
2060: , p5_a24 JTF_VARCHAR2_TABLE_500
2061: , p5_a25 JTF_NUMBER_TABLE
2062: , p5_a26 JTF_NUMBER_TABLE
2063: , p5_a27 JTF_NUMBER_TABLE
2064: , p5_a28 JTF_NUMBER_TABLE
2065: , p5_a29 JTF_DATE_TABLE
2066: , p5_a30 JTF_NUMBER_TABLE

Line 2063: , p5_a27 JTF_NUMBER_TABLE

2059: , p5_a23 JTF_VARCHAR2_TABLE_500
2060: , p5_a24 JTF_VARCHAR2_TABLE_500
2061: , p5_a25 JTF_NUMBER_TABLE
2062: , p5_a26 JTF_NUMBER_TABLE
2063: , p5_a27 JTF_NUMBER_TABLE
2064: , p5_a28 JTF_NUMBER_TABLE
2065: , p5_a29 JTF_DATE_TABLE
2066: , p5_a30 JTF_NUMBER_TABLE
2067: , p5_a31 JTF_DATE_TABLE

Line 2064: , p5_a28 JTF_NUMBER_TABLE

2060: , p5_a24 JTF_VARCHAR2_TABLE_500
2061: , p5_a25 JTF_NUMBER_TABLE
2062: , p5_a26 JTF_NUMBER_TABLE
2063: , p5_a27 JTF_NUMBER_TABLE
2064: , p5_a28 JTF_NUMBER_TABLE
2065: , p5_a29 JTF_DATE_TABLE
2066: , p5_a30 JTF_NUMBER_TABLE
2067: , p5_a31 JTF_DATE_TABLE
2068: , p5_a32 JTF_NUMBER_TABLE

Line 2066: , p5_a30 JTF_NUMBER_TABLE

2062: , p5_a26 JTF_NUMBER_TABLE
2063: , p5_a27 JTF_NUMBER_TABLE
2064: , p5_a28 JTF_NUMBER_TABLE
2065: , p5_a29 JTF_DATE_TABLE
2066: , p5_a30 JTF_NUMBER_TABLE
2067: , p5_a31 JTF_DATE_TABLE
2068: , p5_a32 JTF_NUMBER_TABLE
2069: , p5_a33 JTF_DATE_TABLE
2070: , p5_a34 JTF_NUMBER_TABLE

Line 2068: , p5_a32 JTF_NUMBER_TABLE

2064: , p5_a28 JTF_NUMBER_TABLE
2065: , p5_a29 JTF_DATE_TABLE
2066: , p5_a30 JTF_NUMBER_TABLE
2067: , p5_a31 JTF_DATE_TABLE
2068: , p5_a32 JTF_NUMBER_TABLE
2069: , p5_a33 JTF_DATE_TABLE
2070: , p5_a34 JTF_NUMBER_TABLE
2071: , p5_a35 JTF_VARCHAR2_TABLE_100
2072: , p5_a36 JTF_DATE_TABLE

Line 2070: , p5_a34 JTF_NUMBER_TABLE

2066: , p5_a30 JTF_NUMBER_TABLE
2067: , p5_a31 JTF_DATE_TABLE
2068: , p5_a32 JTF_NUMBER_TABLE
2069: , p5_a33 JTF_DATE_TABLE
2070: , p5_a34 JTF_NUMBER_TABLE
2071: , p5_a35 JTF_VARCHAR2_TABLE_100
2072: , p5_a36 JTF_DATE_TABLE
2073: , p5_a37 JTF_NUMBER_TABLE
2074: , p5_a38 JTF_VARCHAR2_TABLE_100

Line 2073: , p5_a37 JTF_NUMBER_TABLE

2069: , p5_a33 JTF_DATE_TABLE
2070: , p5_a34 JTF_NUMBER_TABLE
2071: , p5_a35 JTF_VARCHAR2_TABLE_100
2072: , p5_a36 JTF_DATE_TABLE
2073: , p5_a37 JTF_NUMBER_TABLE
2074: , p5_a38 JTF_VARCHAR2_TABLE_100
2075: , p5_a39 JTF_NUMBER_TABLE
2076: )
2077:

Line 2075: , p5_a39 JTF_NUMBER_TABLE

2071: , p5_a35 JTF_VARCHAR2_TABLE_100
2072: , p5_a36 JTF_DATE_TABLE
2073: , p5_a37 JTF_NUMBER_TABLE
2074: , p5_a38 JTF_VARCHAR2_TABLE_100
2075: , p5_a39 JTF_NUMBER_TABLE
2076: )
2077:
2078: as
2079: ddp_clhv_tbl okl_clh_pvt.clhv_tbl_type;