APPS.OKL_LAP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_lap_pvt_w as
2: /* $Header: OKLILAPB.pls 120.4 2006/11/08 14:57:07 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_lap_pvt.lapv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500
8: , a5 JTF_VARCHAR2_TABLE_500
9: , a6 JTF_VARCHAR2_TABLE_500

Line 22: , a19 JTF_VARCHAR2_TABLE_100

18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE

Line 30: , a27 JTF_VARCHAR2_TABLE_100

26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE

Line 31: , a28 JTF_VARCHAR2_TABLE_100

27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE

Line 32: , a29 JTF_VARCHAR2_TABLE_100

28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE

Line 33: , a30 JTF_VARCHAR2_TABLE_100

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE

Line 48: , a45 JTF_VARCHAR2_TABLE_100

44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_300
46: , a43 JTF_VARCHAR2_TABLE_2000
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_100
49: , a46 JTF_VARCHAR2_TABLE_100
50: ) as
51: ddindx binary_integer; indx binary_integer;
52: begin

Line 49: , a46 JTF_VARCHAR2_TABLE_100

45: , a42 JTF_VARCHAR2_TABLE_300
46: , a43 JTF_VARCHAR2_TABLE_2000
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_100
49: , a46 JTF_VARCHAR2_TABLE_100
50: ) as
51: ddindx binary_integer; indx binary_integer;
52: begin
53: if a0 is not null and a0.count > 0 then

Line 116: , a2 out nocopy JTF_VARCHAR2_TABLE_100

112: end if;
113: end rosetta_table_copy_in_p23;
114: procedure rosetta_table_copy_out_p23(t okl_lap_pvt.lapv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_NUMBER_TABLE
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_VARCHAR2_TABLE_500
118: , a4 out nocopy JTF_VARCHAR2_TABLE_500
119: , a5 out nocopy JTF_VARCHAR2_TABLE_500
120: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 133: , a19 out nocopy JTF_VARCHAR2_TABLE_100

129: , a15 out nocopy JTF_VARCHAR2_TABLE_500
130: , a16 out nocopy JTF_VARCHAR2_TABLE_500
131: , a17 out nocopy JTF_VARCHAR2_TABLE_500
132: , a18 out nocopy JTF_VARCHAR2_TABLE_200
133: , a19 out nocopy JTF_VARCHAR2_TABLE_100
134: , a20 out nocopy JTF_DATE_TABLE
135: , a21 out nocopy JTF_DATE_TABLE
136: , a22 out nocopy JTF_NUMBER_TABLE
137: , a23 out nocopy JTF_NUMBER_TABLE

Line 141: , a27 out nocopy JTF_VARCHAR2_TABLE_100

137: , a23 out nocopy JTF_NUMBER_TABLE
138: , a24 out nocopy JTF_NUMBER_TABLE
139: , a25 out nocopy JTF_NUMBER_TABLE
140: , a26 out nocopy JTF_NUMBER_TABLE
141: , a27 out nocopy JTF_VARCHAR2_TABLE_100
142: , a28 out nocopy JTF_VARCHAR2_TABLE_100
143: , a29 out nocopy JTF_VARCHAR2_TABLE_100
144: , a30 out nocopy JTF_VARCHAR2_TABLE_100
145: , a31 out nocopy JTF_NUMBER_TABLE

Line 142: , a28 out nocopy JTF_VARCHAR2_TABLE_100

138: , a24 out nocopy JTF_NUMBER_TABLE
139: , a25 out nocopy JTF_NUMBER_TABLE
140: , a26 out nocopy JTF_NUMBER_TABLE
141: , a27 out nocopy JTF_VARCHAR2_TABLE_100
142: , a28 out nocopy JTF_VARCHAR2_TABLE_100
143: , a29 out nocopy JTF_VARCHAR2_TABLE_100
144: , a30 out nocopy JTF_VARCHAR2_TABLE_100
145: , a31 out nocopy JTF_NUMBER_TABLE
146: , a32 out nocopy JTF_DATE_TABLE

Line 143: , a29 out nocopy JTF_VARCHAR2_TABLE_100

139: , a25 out nocopy JTF_NUMBER_TABLE
140: , a26 out nocopy JTF_NUMBER_TABLE
141: , a27 out nocopy JTF_VARCHAR2_TABLE_100
142: , a28 out nocopy JTF_VARCHAR2_TABLE_100
143: , a29 out nocopy JTF_VARCHAR2_TABLE_100
144: , a30 out nocopy JTF_VARCHAR2_TABLE_100
145: , a31 out nocopy JTF_NUMBER_TABLE
146: , a32 out nocopy JTF_DATE_TABLE
147: , a33 out nocopy JTF_NUMBER_TABLE

Line 144: , a30 out nocopy JTF_VARCHAR2_TABLE_100

140: , a26 out nocopy JTF_NUMBER_TABLE
141: , a27 out nocopy JTF_VARCHAR2_TABLE_100
142: , a28 out nocopy JTF_VARCHAR2_TABLE_100
143: , a29 out nocopy JTF_VARCHAR2_TABLE_100
144: , a30 out nocopy JTF_VARCHAR2_TABLE_100
145: , a31 out nocopy JTF_NUMBER_TABLE
146: , a32 out nocopy JTF_DATE_TABLE
147: , a33 out nocopy JTF_NUMBER_TABLE
148: , a34 out nocopy JTF_NUMBER_TABLE

Line 159: , a45 out nocopy JTF_VARCHAR2_TABLE_100

155: , a41 out nocopy JTF_NUMBER_TABLE
156: , a42 out nocopy JTF_VARCHAR2_TABLE_300
157: , a43 out nocopy JTF_VARCHAR2_TABLE_2000
158: , a44 out nocopy JTF_NUMBER_TABLE
159: , a45 out nocopy JTF_VARCHAR2_TABLE_100
160: , a46 out nocopy JTF_VARCHAR2_TABLE_100
161: ) as
162: ddindx binary_integer; indx binary_integer;
163: begin

Line 160: , a46 out nocopy JTF_VARCHAR2_TABLE_100

156: , a42 out nocopy JTF_VARCHAR2_TABLE_300
157: , a43 out nocopy JTF_VARCHAR2_TABLE_2000
158: , a44 out nocopy JTF_NUMBER_TABLE
159: , a45 out nocopy JTF_VARCHAR2_TABLE_100
160: , a46 out nocopy JTF_VARCHAR2_TABLE_100
161: ) as
162: ddindx binary_integer; indx binary_integer;
163: begin
164: if t is null or t.count = 0 then

Line 167: a2 := JTF_VARCHAR2_TABLE_100();

163: begin
164: if t is null or t.count = 0 then
165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_NUMBER_TABLE();
167: a2 := JTF_VARCHAR2_TABLE_100();
168: a3 := JTF_VARCHAR2_TABLE_500();
169: a4 := JTF_VARCHAR2_TABLE_500();
170: a5 := JTF_VARCHAR2_TABLE_500();
171: a6 := JTF_VARCHAR2_TABLE_500();

Line 184: a19 := JTF_VARCHAR2_TABLE_100();

180: a15 := JTF_VARCHAR2_TABLE_500();
181: a16 := JTF_VARCHAR2_TABLE_500();
182: a17 := JTF_VARCHAR2_TABLE_500();
183: a18 := JTF_VARCHAR2_TABLE_200();
184: a19 := JTF_VARCHAR2_TABLE_100();
185: a20 := JTF_DATE_TABLE();
186: a21 := JTF_DATE_TABLE();
187: a22 := JTF_NUMBER_TABLE();
188: a23 := JTF_NUMBER_TABLE();

Line 192: a27 := JTF_VARCHAR2_TABLE_100();

188: a23 := JTF_NUMBER_TABLE();
189: a24 := JTF_NUMBER_TABLE();
190: a25 := JTF_NUMBER_TABLE();
191: a26 := JTF_NUMBER_TABLE();
192: a27 := JTF_VARCHAR2_TABLE_100();
193: a28 := JTF_VARCHAR2_TABLE_100();
194: a29 := JTF_VARCHAR2_TABLE_100();
195: a30 := JTF_VARCHAR2_TABLE_100();
196: a31 := JTF_NUMBER_TABLE();

Line 193: a28 := JTF_VARCHAR2_TABLE_100();

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

Line 194: a29 := JTF_VARCHAR2_TABLE_100();

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

Line 195: a30 := JTF_VARCHAR2_TABLE_100();

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

Line 210: a45 := JTF_VARCHAR2_TABLE_100();

206: a41 := JTF_NUMBER_TABLE();
207: a42 := JTF_VARCHAR2_TABLE_300();
208: a43 := JTF_VARCHAR2_TABLE_2000();
209: a44 := JTF_NUMBER_TABLE();
210: a45 := JTF_VARCHAR2_TABLE_100();
211: a46 := JTF_VARCHAR2_TABLE_100();
212: else
213: a0 := JTF_NUMBER_TABLE();
214: a1 := JTF_NUMBER_TABLE();

Line 211: a46 := JTF_VARCHAR2_TABLE_100();

207: a42 := JTF_VARCHAR2_TABLE_300();
208: a43 := JTF_VARCHAR2_TABLE_2000();
209: a44 := JTF_NUMBER_TABLE();
210: a45 := JTF_VARCHAR2_TABLE_100();
211: a46 := JTF_VARCHAR2_TABLE_100();
212: else
213: a0 := JTF_NUMBER_TABLE();
214: a1 := JTF_NUMBER_TABLE();
215: a2 := JTF_VARCHAR2_TABLE_100();

Line 215: a2 := JTF_VARCHAR2_TABLE_100();

211: a46 := JTF_VARCHAR2_TABLE_100();
212: else
213: a0 := JTF_NUMBER_TABLE();
214: a1 := JTF_NUMBER_TABLE();
215: a2 := JTF_VARCHAR2_TABLE_100();
216: a3 := JTF_VARCHAR2_TABLE_500();
217: a4 := JTF_VARCHAR2_TABLE_500();
218: a5 := JTF_VARCHAR2_TABLE_500();
219: a6 := JTF_VARCHAR2_TABLE_500();

Line 232: a19 := JTF_VARCHAR2_TABLE_100();

228: a15 := JTF_VARCHAR2_TABLE_500();
229: a16 := JTF_VARCHAR2_TABLE_500();
230: a17 := JTF_VARCHAR2_TABLE_500();
231: a18 := JTF_VARCHAR2_TABLE_200();
232: a19 := JTF_VARCHAR2_TABLE_100();
233: a20 := JTF_DATE_TABLE();
234: a21 := JTF_DATE_TABLE();
235: a22 := JTF_NUMBER_TABLE();
236: a23 := JTF_NUMBER_TABLE();

Line 240: a27 := JTF_VARCHAR2_TABLE_100();

236: a23 := JTF_NUMBER_TABLE();
237: a24 := JTF_NUMBER_TABLE();
238: a25 := JTF_NUMBER_TABLE();
239: a26 := JTF_NUMBER_TABLE();
240: a27 := JTF_VARCHAR2_TABLE_100();
241: a28 := JTF_VARCHAR2_TABLE_100();
242: a29 := JTF_VARCHAR2_TABLE_100();
243: a30 := JTF_VARCHAR2_TABLE_100();
244: a31 := JTF_NUMBER_TABLE();

Line 241: a28 := JTF_VARCHAR2_TABLE_100();

237: a24 := JTF_NUMBER_TABLE();
238: a25 := JTF_NUMBER_TABLE();
239: a26 := JTF_NUMBER_TABLE();
240: a27 := JTF_VARCHAR2_TABLE_100();
241: a28 := JTF_VARCHAR2_TABLE_100();
242: a29 := JTF_VARCHAR2_TABLE_100();
243: a30 := JTF_VARCHAR2_TABLE_100();
244: a31 := JTF_NUMBER_TABLE();
245: a32 := JTF_DATE_TABLE();

Line 242: a29 := JTF_VARCHAR2_TABLE_100();

238: a25 := JTF_NUMBER_TABLE();
239: a26 := JTF_NUMBER_TABLE();
240: a27 := JTF_VARCHAR2_TABLE_100();
241: a28 := JTF_VARCHAR2_TABLE_100();
242: a29 := JTF_VARCHAR2_TABLE_100();
243: a30 := JTF_VARCHAR2_TABLE_100();
244: a31 := JTF_NUMBER_TABLE();
245: a32 := JTF_DATE_TABLE();
246: a33 := JTF_NUMBER_TABLE();

Line 243: a30 := JTF_VARCHAR2_TABLE_100();

239: a26 := JTF_NUMBER_TABLE();
240: a27 := JTF_VARCHAR2_TABLE_100();
241: a28 := JTF_VARCHAR2_TABLE_100();
242: a29 := JTF_VARCHAR2_TABLE_100();
243: a30 := JTF_VARCHAR2_TABLE_100();
244: a31 := JTF_NUMBER_TABLE();
245: a32 := JTF_DATE_TABLE();
246: a33 := JTF_NUMBER_TABLE();
247: a34 := JTF_NUMBER_TABLE();

Line 258: a45 := JTF_VARCHAR2_TABLE_100();

254: a41 := JTF_NUMBER_TABLE();
255: a42 := JTF_VARCHAR2_TABLE_300();
256: a43 := JTF_VARCHAR2_TABLE_2000();
257: a44 := JTF_NUMBER_TABLE();
258: a45 := JTF_VARCHAR2_TABLE_100();
259: a46 := JTF_VARCHAR2_TABLE_100();
260: if t.count > 0 then
261: a0.extend(t.count);
262: a1.extend(t.count);

Line 259: a46 := JTF_VARCHAR2_TABLE_100();

255: a42 := JTF_VARCHAR2_TABLE_300();
256: a43 := JTF_VARCHAR2_TABLE_2000();
257: a44 := JTF_NUMBER_TABLE();
258: a45 := JTF_VARCHAR2_TABLE_100();
259: a46 := JTF_VARCHAR2_TABLE_100();
260: if t.count > 0 then
261: a0.extend(t.count);
262: a1.extend(t.count);
263: a2.extend(t.count);

Line 375: , p5_a2 JTF_VARCHAR2_TABLE_100

371: , x_msg_count out nocopy NUMBER
372: , x_msg_data out nocopy VARCHAR2
373: , p5_a0 JTF_NUMBER_TABLE
374: , p5_a1 JTF_NUMBER_TABLE
375: , p5_a2 JTF_VARCHAR2_TABLE_100
376: , p5_a3 JTF_VARCHAR2_TABLE_500
377: , p5_a4 JTF_VARCHAR2_TABLE_500
378: , p5_a5 JTF_VARCHAR2_TABLE_500
379: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 392: , p5_a19 JTF_VARCHAR2_TABLE_100

388: , p5_a15 JTF_VARCHAR2_TABLE_500
389: , p5_a16 JTF_VARCHAR2_TABLE_500
390: , p5_a17 JTF_VARCHAR2_TABLE_500
391: , p5_a18 JTF_VARCHAR2_TABLE_200
392: , p5_a19 JTF_VARCHAR2_TABLE_100
393: , p5_a20 JTF_DATE_TABLE
394: , p5_a21 JTF_DATE_TABLE
395: , p5_a22 JTF_NUMBER_TABLE
396: , p5_a23 JTF_NUMBER_TABLE

Line 400: , p5_a27 JTF_VARCHAR2_TABLE_100

396: , p5_a23 JTF_NUMBER_TABLE
397: , p5_a24 JTF_NUMBER_TABLE
398: , p5_a25 JTF_NUMBER_TABLE
399: , p5_a26 JTF_NUMBER_TABLE
400: , p5_a27 JTF_VARCHAR2_TABLE_100
401: , p5_a28 JTF_VARCHAR2_TABLE_100
402: , p5_a29 JTF_VARCHAR2_TABLE_100
403: , p5_a30 JTF_VARCHAR2_TABLE_100
404: , p5_a31 JTF_NUMBER_TABLE

Line 401: , p5_a28 JTF_VARCHAR2_TABLE_100

397: , p5_a24 JTF_NUMBER_TABLE
398: , p5_a25 JTF_NUMBER_TABLE
399: , p5_a26 JTF_NUMBER_TABLE
400: , p5_a27 JTF_VARCHAR2_TABLE_100
401: , p5_a28 JTF_VARCHAR2_TABLE_100
402: , p5_a29 JTF_VARCHAR2_TABLE_100
403: , p5_a30 JTF_VARCHAR2_TABLE_100
404: , p5_a31 JTF_NUMBER_TABLE
405: , p5_a32 JTF_DATE_TABLE

Line 402: , p5_a29 JTF_VARCHAR2_TABLE_100

398: , p5_a25 JTF_NUMBER_TABLE
399: , p5_a26 JTF_NUMBER_TABLE
400: , p5_a27 JTF_VARCHAR2_TABLE_100
401: , p5_a28 JTF_VARCHAR2_TABLE_100
402: , p5_a29 JTF_VARCHAR2_TABLE_100
403: , p5_a30 JTF_VARCHAR2_TABLE_100
404: , p5_a31 JTF_NUMBER_TABLE
405: , p5_a32 JTF_DATE_TABLE
406: , p5_a33 JTF_NUMBER_TABLE

Line 403: , p5_a30 JTF_VARCHAR2_TABLE_100

399: , p5_a26 JTF_NUMBER_TABLE
400: , p5_a27 JTF_VARCHAR2_TABLE_100
401: , p5_a28 JTF_VARCHAR2_TABLE_100
402: , p5_a29 JTF_VARCHAR2_TABLE_100
403: , p5_a30 JTF_VARCHAR2_TABLE_100
404: , p5_a31 JTF_NUMBER_TABLE
405: , p5_a32 JTF_DATE_TABLE
406: , p5_a33 JTF_NUMBER_TABLE
407: , p5_a34 JTF_NUMBER_TABLE

Line 418: , p5_a45 JTF_VARCHAR2_TABLE_100

414: , p5_a41 JTF_NUMBER_TABLE
415: , p5_a42 JTF_VARCHAR2_TABLE_300
416: , p5_a43 JTF_VARCHAR2_TABLE_2000
417: , p5_a44 JTF_NUMBER_TABLE
418: , p5_a45 JTF_VARCHAR2_TABLE_100
419: , p5_a46 JTF_VARCHAR2_TABLE_100
420: , p6_a0 out nocopy JTF_NUMBER_TABLE
421: , p6_a1 out nocopy JTF_NUMBER_TABLE
422: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 419: , p5_a46 JTF_VARCHAR2_TABLE_100

415: , p5_a42 JTF_VARCHAR2_TABLE_300
416: , p5_a43 JTF_VARCHAR2_TABLE_2000
417: , p5_a44 JTF_NUMBER_TABLE
418: , p5_a45 JTF_VARCHAR2_TABLE_100
419: , p5_a46 JTF_VARCHAR2_TABLE_100
420: , p6_a0 out nocopy JTF_NUMBER_TABLE
421: , p6_a1 out nocopy JTF_NUMBER_TABLE
422: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500

Line 422: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

418: , p5_a45 JTF_VARCHAR2_TABLE_100
419: , p5_a46 JTF_VARCHAR2_TABLE_100
420: , p6_a0 out nocopy JTF_NUMBER_TABLE
421: , p6_a1 out nocopy JTF_NUMBER_TABLE
422: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
424: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
425: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
426: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 439: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

435: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
436: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
437: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
438: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
439: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
440: , p6_a20 out nocopy JTF_DATE_TABLE
441: , p6_a21 out nocopy JTF_DATE_TABLE
442: , p6_a22 out nocopy JTF_NUMBER_TABLE
443: , p6_a23 out nocopy JTF_NUMBER_TABLE

Line 447: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

443: , p6_a23 out nocopy JTF_NUMBER_TABLE
444: , p6_a24 out nocopy JTF_NUMBER_TABLE
445: , p6_a25 out nocopy JTF_NUMBER_TABLE
446: , p6_a26 out nocopy JTF_NUMBER_TABLE
447: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
448: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
449: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
451: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 448: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100

444: , p6_a24 out nocopy JTF_NUMBER_TABLE
445: , p6_a25 out nocopy JTF_NUMBER_TABLE
446: , p6_a26 out nocopy JTF_NUMBER_TABLE
447: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
448: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
449: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
451: , p6_a31 out nocopy JTF_NUMBER_TABLE
452: , p6_a32 out nocopy JTF_DATE_TABLE

Line 449: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100

445: , p6_a25 out nocopy JTF_NUMBER_TABLE
446: , p6_a26 out nocopy JTF_NUMBER_TABLE
447: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
448: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
449: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
451: , p6_a31 out nocopy JTF_NUMBER_TABLE
452: , p6_a32 out nocopy JTF_DATE_TABLE
453: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 450: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

446: , p6_a26 out nocopy JTF_NUMBER_TABLE
447: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
448: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
449: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
451: , p6_a31 out nocopy JTF_NUMBER_TABLE
452: , p6_a32 out nocopy JTF_DATE_TABLE
453: , p6_a33 out nocopy JTF_NUMBER_TABLE
454: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 465: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100

461: , p6_a41 out nocopy JTF_NUMBER_TABLE
462: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_300
463: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_2000
464: , p6_a44 out nocopy JTF_NUMBER_TABLE
465: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
467: )
468:
469: as

Line 466: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100

462: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_300
463: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_2000
464: , p6_a44 out nocopy JTF_NUMBER_TABLE
465: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
467: )
468:
469: as
470: ddp_lapv_tbl okl_lap_pvt.lapv_tbl_type;

Line 604: , p5_a2 JTF_VARCHAR2_TABLE_100

600: , x_msg_count out nocopy NUMBER
601: , x_msg_data out nocopy VARCHAR2
602: , p5_a0 JTF_NUMBER_TABLE
603: , p5_a1 JTF_NUMBER_TABLE
604: , p5_a2 JTF_VARCHAR2_TABLE_100
605: , p5_a3 JTF_VARCHAR2_TABLE_500
606: , p5_a4 JTF_VARCHAR2_TABLE_500
607: , p5_a5 JTF_VARCHAR2_TABLE_500
608: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 621: , p5_a19 JTF_VARCHAR2_TABLE_100

617: , p5_a15 JTF_VARCHAR2_TABLE_500
618: , p5_a16 JTF_VARCHAR2_TABLE_500
619: , p5_a17 JTF_VARCHAR2_TABLE_500
620: , p5_a18 JTF_VARCHAR2_TABLE_200
621: , p5_a19 JTF_VARCHAR2_TABLE_100
622: , p5_a20 JTF_DATE_TABLE
623: , p5_a21 JTF_DATE_TABLE
624: , p5_a22 JTF_NUMBER_TABLE
625: , p5_a23 JTF_NUMBER_TABLE

Line 629: , p5_a27 JTF_VARCHAR2_TABLE_100

625: , p5_a23 JTF_NUMBER_TABLE
626: , p5_a24 JTF_NUMBER_TABLE
627: , p5_a25 JTF_NUMBER_TABLE
628: , p5_a26 JTF_NUMBER_TABLE
629: , p5_a27 JTF_VARCHAR2_TABLE_100
630: , p5_a28 JTF_VARCHAR2_TABLE_100
631: , p5_a29 JTF_VARCHAR2_TABLE_100
632: , p5_a30 JTF_VARCHAR2_TABLE_100
633: , p5_a31 JTF_NUMBER_TABLE

Line 630: , p5_a28 JTF_VARCHAR2_TABLE_100

626: , p5_a24 JTF_NUMBER_TABLE
627: , p5_a25 JTF_NUMBER_TABLE
628: , p5_a26 JTF_NUMBER_TABLE
629: , p5_a27 JTF_VARCHAR2_TABLE_100
630: , p5_a28 JTF_VARCHAR2_TABLE_100
631: , p5_a29 JTF_VARCHAR2_TABLE_100
632: , p5_a30 JTF_VARCHAR2_TABLE_100
633: , p5_a31 JTF_NUMBER_TABLE
634: , p5_a32 JTF_DATE_TABLE

Line 631: , p5_a29 JTF_VARCHAR2_TABLE_100

627: , p5_a25 JTF_NUMBER_TABLE
628: , p5_a26 JTF_NUMBER_TABLE
629: , p5_a27 JTF_VARCHAR2_TABLE_100
630: , p5_a28 JTF_VARCHAR2_TABLE_100
631: , p5_a29 JTF_VARCHAR2_TABLE_100
632: , p5_a30 JTF_VARCHAR2_TABLE_100
633: , p5_a31 JTF_NUMBER_TABLE
634: , p5_a32 JTF_DATE_TABLE
635: , p5_a33 JTF_NUMBER_TABLE

Line 632: , p5_a30 JTF_VARCHAR2_TABLE_100

628: , p5_a26 JTF_NUMBER_TABLE
629: , p5_a27 JTF_VARCHAR2_TABLE_100
630: , p5_a28 JTF_VARCHAR2_TABLE_100
631: , p5_a29 JTF_VARCHAR2_TABLE_100
632: , p5_a30 JTF_VARCHAR2_TABLE_100
633: , p5_a31 JTF_NUMBER_TABLE
634: , p5_a32 JTF_DATE_TABLE
635: , p5_a33 JTF_NUMBER_TABLE
636: , p5_a34 JTF_NUMBER_TABLE

Line 647: , p5_a45 JTF_VARCHAR2_TABLE_100

643: , p5_a41 JTF_NUMBER_TABLE
644: , p5_a42 JTF_VARCHAR2_TABLE_300
645: , p5_a43 JTF_VARCHAR2_TABLE_2000
646: , p5_a44 JTF_NUMBER_TABLE
647: , p5_a45 JTF_VARCHAR2_TABLE_100
648: , p5_a46 JTF_VARCHAR2_TABLE_100
649: , p6_a0 out nocopy JTF_NUMBER_TABLE
650: , p6_a1 out nocopy JTF_NUMBER_TABLE
651: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 648: , p5_a46 JTF_VARCHAR2_TABLE_100

644: , p5_a42 JTF_VARCHAR2_TABLE_300
645: , p5_a43 JTF_VARCHAR2_TABLE_2000
646: , p5_a44 JTF_NUMBER_TABLE
647: , p5_a45 JTF_VARCHAR2_TABLE_100
648: , p5_a46 JTF_VARCHAR2_TABLE_100
649: , p6_a0 out nocopy JTF_NUMBER_TABLE
650: , p6_a1 out nocopy JTF_NUMBER_TABLE
651: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
652: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500

Line 651: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

647: , p5_a45 JTF_VARCHAR2_TABLE_100
648: , p5_a46 JTF_VARCHAR2_TABLE_100
649: , p6_a0 out nocopy JTF_NUMBER_TABLE
650: , p6_a1 out nocopy JTF_NUMBER_TABLE
651: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
652: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
653: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
654: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
655: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 668: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

664: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
665: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
666: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
667: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
668: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
669: , p6_a20 out nocopy JTF_DATE_TABLE
670: , p6_a21 out nocopy JTF_DATE_TABLE
671: , p6_a22 out nocopy JTF_NUMBER_TABLE
672: , p6_a23 out nocopy JTF_NUMBER_TABLE

Line 676: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

672: , p6_a23 out nocopy JTF_NUMBER_TABLE
673: , p6_a24 out nocopy JTF_NUMBER_TABLE
674: , p6_a25 out nocopy JTF_NUMBER_TABLE
675: , p6_a26 out nocopy JTF_NUMBER_TABLE
676: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
677: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
678: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
679: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
680: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 677: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100

673: , p6_a24 out nocopy JTF_NUMBER_TABLE
674: , p6_a25 out nocopy JTF_NUMBER_TABLE
675: , p6_a26 out nocopy JTF_NUMBER_TABLE
676: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
677: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
678: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
679: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
680: , p6_a31 out nocopy JTF_NUMBER_TABLE
681: , p6_a32 out nocopy JTF_DATE_TABLE

Line 678: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100

674: , p6_a25 out nocopy JTF_NUMBER_TABLE
675: , p6_a26 out nocopy JTF_NUMBER_TABLE
676: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
677: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
678: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
679: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
680: , p6_a31 out nocopy JTF_NUMBER_TABLE
681: , p6_a32 out nocopy JTF_DATE_TABLE
682: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 679: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

675: , p6_a26 out nocopy JTF_NUMBER_TABLE
676: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
677: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
678: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
679: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
680: , p6_a31 out nocopy JTF_NUMBER_TABLE
681: , p6_a32 out nocopy JTF_DATE_TABLE
682: , p6_a33 out nocopy JTF_NUMBER_TABLE
683: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 694: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100

690: , p6_a41 out nocopy JTF_NUMBER_TABLE
691: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_300
692: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_2000
693: , p6_a44 out nocopy JTF_NUMBER_TABLE
694: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
695: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
696: )
697:
698: as

Line 695: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100

691: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_300
692: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_2000
693: , p6_a44 out nocopy JTF_NUMBER_TABLE
694: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
695: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
696: )
697:
698: as
699: ddp_lapv_tbl okl_lap_pvt.lapv_tbl_type;

Line 833: , p5_a2 JTF_VARCHAR2_TABLE_100

829: , x_msg_count out nocopy NUMBER
830: , x_msg_data out nocopy VARCHAR2
831: , p5_a0 JTF_NUMBER_TABLE
832: , p5_a1 JTF_NUMBER_TABLE
833: , p5_a2 JTF_VARCHAR2_TABLE_100
834: , p5_a3 JTF_VARCHAR2_TABLE_500
835: , p5_a4 JTF_VARCHAR2_TABLE_500
836: , p5_a5 JTF_VARCHAR2_TABLE_500
837: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 850: , p5_a19 JTF_VARCHAR2_TABLE_100

846: , p5_a15 JTF_VARCHAR2_TABLE_500
847: , p5_a16 JTF_VARCHAR2_TABLE_500
848: , p5_a17 JTF_VARCHAR2_TABLE_500
849: , p5_a18 JTF_VARCHAR2_TABLE_200
850: , p5_a19 JTF_VARCHAR2_TABLE_100
851: , p5_a20 JTF_DATE_TABLE
852: , p5_a21 JTF_DATE_TABLE
853: , p5_a22 JTF_NUMBER_TABLE
854: , p5_a23 JTF_NUMBER_TABLE

Line 858: , p5_a27 JTF_VARCHAR2_TABLE_100

854: , p5_a23 JTF_NUMBER_TABLE
855: , p5_a24 JTF_NUMBER_TABLE
856: , p5_a25 JTF_NUMBER_TABLE
857: , p5_a26 JTF_NUMBER_TABLE
858: , p5_a27 JTF_VARCHAR2_TABLE_100
859: , p5_a28 JTF_VARCHAR2_TABLE_100
860: , p5_a29 JTF_VARCHAR2_TABLE_100
861: , p5_a30 JTF_VARCHAR2_TABLE_100
862: , p5_a31 JTF_NUMBER_TABLE

Line 859: , p5_a28 JTF_VARCHAR2_TABLE_100

855: , p5_a24 JTF_NUMBER_TABLE
856: , p5_a25 JTF_NUMBER_TABLE
857: , p5_a26 JTF_NUMBER_TABLE
858: , p5_a27 JTF_VARCHAR2_TABLE_100
859: , p5_a28 JTF_VARCHAR2_TABLE_100
860: , p5_a29 JTF_VARCHAR2_TABLE_100
861: , p5_a30 JTF_VARCHAR2_TABLE_100
862: , p5_a31 JTF_NUMBER_TABLE
863: , p5_a32 JTF_DATE_TABLE

Line 860: , p5_a29 JTF_VARCHAR2_TABLE_100

856: , p5_a25 JTF_NUMBER_TABLE
857: , p5_a26 JTF_NUMBER_TABLE
858: , p5_a27 JTF_VARCHAR2_TABLE_100
859: , p5_a28 JTF_VARCHAR2_TABLE_100
860: , p5_a29 JTF_VARCHAR2_TABLE_100
861: , p5_a30 JTF_VARCHAR2_TABLE_100
862: , p5_a31 JTF_NUMBER_TABLE
863: , p5_a32 JTF_DATE_TABLE
864: , p5_a33 JTF_NUMBER_TABLE

Line 861: , p5_a30 JTF_VARCHAR2_TABLE_100

857: , p5_a26 JTF_NUMBER_TABLE
858: , p5_a27 JTF_VARCHAR2_TABLE_100
859: , p5_a28 JTF_VARCHAR2_TABLE_100
860: , p5_a29 JTF_VARCHAR2_TABLE_100
861: , p5_a30 JTF_VARCHAR2_TABLE_100
862: , p5_a31 JTF_NUMBER_TABLE
863: , p5_a32 JTF_DATE_TABLE
864: , p5_a33 JTF_NUMBER_TABLE
865: , p5_a34 JTF_NUMBER_TABLE

Line 876: , p5_a45 JTF_VARCHAR2_TABLE_100

872: , p5_a41 JTF_NUMBER_TABLE
873: , p5_a42 JTF_VARCHAR2_TABLE_300
874: , p5_a43 JTF_VARCHAR2_TABLE_2000
875: , p5_a44 JTF_NUMBER_TABLE
876: , p5_a45 JTF_VARCHAR2_TABLE_100
877: , p5_a46 JTF_VARCHAR2_TABLE_100
878: )
879:
880: as

Line 877: , p5_a46 JTF_VARCHAR2_TABLE_100

873: , p5_a42 JTF_VARCHAR2_TABLE_300
874: , p5_a43 JTF_VARCHAR2_TABLE_2000
875: , p5_a44 JTF_NUMBER_TABLE
876: , p5_a45 JTF_VARCHAR2_TABLE_100
877: , p5_a46 JTF_VARCHAR2_TABLE_100
878: )
879:
880: as
881: ddp_lapv_tbl okl_lap_pvt.lapv_tbl_type;