DBA Data[Home] [Help]

APPS.OKL_RCT_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body okl_rct_pvt_w as
2: /* $Header: OKLIRCTB.pls 120.0 2007/11/19 10:32:58 rviriyal noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rct_pvt.rct_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_rct_pvt_w as
2: /* $Header: OKLIRCTB.pls 120.0 2007/11/19 10:32:58 rviriyal noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rct_pvt.rct_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 14: , a11 JTF_VARCHAR2_TABLE_100

10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE

Line 17: , a14 JTF_VARCHAR2_TABLE_100

13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE

Line 23: , a20 JTF_VARCHAR2_TABLE_100

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

Line 44: , a41 JTF_VARCHAR2_TABLE_100

40: , a37 JTF_DATE_TABLE
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_DATE_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: ) as

Line 46: , a43 JTF_VARCHAR2_TABLE_100

42: , a39 JTF_DATE_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin

Line 47: , a44 JTF_VARCHAR2_TABLE_100

43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if a0 is not null and a0.count > 0 then

Line 111: , a1 out nocopy JTF_VARCHAR2_TABLE_100

107: end if;
108: end if;
109: end rosetta_table_copy_in_p2;
110: procedure rosetta_table_copy_out_p2(t okl_rct_pvt.rct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
111: , a1 out nocopy JTF_VARCHAR2_TABLE_100
112: , a2 out nocopy JTF_VARCHAR2_TABLE_100
113: , a3 out nocopy JTF_DATE_TABLE
114: , a4 out nocopy JTF_NUMBER_TABLE
115: , a5 out nocopy JTF_NUMBER_TABLE

Line 112: , a2 out nocopy JTF_VARCHAR2_TABLE_100

108: end if;
109: end rosetta_table_copy_in_p2;
110: procedure rosetta_table_copy_out_p2(t okl_rct_pvt.rct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
111: , a1 out nocopy JTF_VARCHAR2_TABLE_100
112: , a2 out nocopy JTF_VARCHAR2_TABLE_100
113: , a3 out nocopy JTF_DATE_TABLE
114: , a4 out nocopy JTF_NUMBER_TABLE
115: , a5 out nocopy JTF_NUMBER_TABLE
116: , a6 out nocopy JTF_NUMBER_TABLE

Line 121: , a11 out nocopy JTF_VARCHAR2_TABLE_100

117: , a7 out nocopy JTF_DATE_TABLE
118: , a8 out nocopy JTF_NUMBER_TABLE
119: , a9 out nocopy JTF_NUMBER_TABLE
120: , a10 out nocopy JTF_NUMBER_TABLE
121: , a11 out nocopy JTF_VARCHAR2_TABLE_100
122: , a12 out nocopy JTF_NUMBER_TABLE
123: , a13 out nocopy JTF_DATE_TABLE
124: , a14 out nocopy JTF_VARCHAR2_TABLE_100
125: , a15 out nocopy JTF_NUMBER_TABLE

Line 124: , a14 out nocopy JTF_VARCHAR2_TABLE_100

120: , a10 out nocopy JTF_NUMBER_TABLE
121: , a11 out nocopy JTF_VARCHAR2_TABLE_100
122: , a12 out nocopy JTF_NUMBER_TABLE
123: , a13 out nocopy JTF_DATE_TABLE
124: , a14 out nocopy JTF_VARCHAR2_TABLE_100
125: , a15 out nocopy JTF_NUMBER_TABLE
126: , a16 out nocopy JTF_NUMBER_TABLE
127: , a17 out nocopy JTF_NUMBER_TABLE
128: , a18 out nocopy JTF_DATE_TABLE

Line 130: , a20 out nocopy JTF_VARCHAR2_TABLE_100

126: , a16 out nocopy JTF_NUMBER_TABLE
127: , a17 out nocopy JTF_NUMBER_TABLE
128: , a18 out nocopy JTF_DATE_TABLE
129: , a19 out nocopy JTF_NUMBER_TABLE
130: , a20 out nocopy JTF_VARCHAR2_TABLE_100
131: , a21 out nocopy JTF_VARCHAR2_TABLE_500
132: , a22 out nocopy JTF_VARCHAR2_TABLE_500
133: , a23 out nocopy JTF_VARCHAR2_TABLE_500
134: , a24 out nocopy JTF_VARCHAR2_TABLE_500

Line 151: , a41 out nocopy JTF_VARCHAR2_TABLE_100

147: , a37 out nocopy JTF_DATE_TABLE
148: , a38 out nocopy JTF_NUMBER_TABLE
149: , a39 out nocopy JTF_DATE_TABLE
150: , a40 out nocopy JTF_NUMBER_TABLE
151: , a41 out nocopy JTF_VARCHAR2_TABLE_100
152: , a42 out nocopy JTF_NUMBER_TABLE
153: , a43 out nocopy JTF_VARCHAR2_TABLE_100
154: , a44 out nocopy JTF_VARCHAR2_TABLE_100
155: ) as

Line 153: , a43 out nocopy JTF_VARCHAR2_TABLE_100

149: , a39 out nocopy JTF_DATE_TABLE
150: , a40 out nocopy JTF_NUMBER_TABLE
151: , a41 out nocopy JTF_VARCHAR2_TABLE_100
152: , a42 out nocopy JTF_NUMBER_TABLE
153: , a43 out nocopy JTF_VARCHAR2_TABLE_100
154: , a44 out nocopy JTF_VARCHAR2_TABLE_100
155: ) as
156: ddindx binary_integer; indx binary_integer;
157: begin

Line 154: , a44 out nocopy JTF_VARCHAR2_TABLE_100

150: , a40 out nocopy JTF_NUMBER_TABLE
151: , a41 out nocopy JTF_VARCHAR2_TABLE_100
152: , a42 out nocopy JTF_NUMBER_TABLE
153: , a43 out nocopy JTF_VARCHAR2_TABLE_100
154: , a44 out nocopy JTF_VARCHAR2_TABLE_100
155: ) as
156: ddindx binary_integer; indx binary_integer;
157: begin
158: if t is null or t.count = 0 then

Line 160: a1 := JTF_VARCHAR2_TABLE_100();

156: ddindx binary_integer; indx binary_integer;
157: begin
158: if t is null or t.count = 0 then
159: a0 := JTF_NUMBER_TABLE();
160: a1 := JTF_VARCHAR2_TABLE_100();
161: a2 := JTF_VARCHAR2_TABLE_100();
162: a3 := JTF_DATE_TABLE();
163: a4 := JTF_NUMBER_TABLE();
164: a5 := JTF_NUMBER_TABLE();

Line 161: a2 := JTF_VARCHAR2_TABLE_100();

157: begin
158: if t is null or t.count = 0 then
159: a0 := JTF_NUMBER_TABLE();
160: a1 := JTF_VARCHAR2_TABLE_100();
161: a2 := JTF_VARCHAR2_TABLE_100();
162: a3 := JTF_DATE_TABLE();
163: a4 := JTF_NUMBER_TABLE();
164: a5 := JTF_NUMBER_TABLE();
165: a6 := JTF_NUMBER_TABLE();

Line 170: a11 := JTF_VARCHAR2_TABLE_100();

166: a7 := JTF_DATE_TABLE();
167: a8 := JTF_NUMBER_TABLE();
168: a9 := JTF_NUMBER_TABLE();
169: a10 := JTF_NUMBER_TABLE();
170: a11 := JTF_VARCHAR2_TABLE_100();
171: a12 := JTF_NUMBER_TABLE();
172: a13 := JTF_DATE_TABLE();
173: a14 := JTF_VARCHAR2_TABLE_100();
174: a15 := JTF_NUMBER_TABLE();

Line 173: a14 := JTF_VARCHAR2_TABLE_100();

169: a10 := JTF_NUMBER_TABLE();
170: a11 := JTF_VARCHAR2_TABLE_100();
171: a12 := JTF_NUMBER_TABLE();
172: a13 := JTF_DATE_TABLE();
173: a14 := JTF_VARCHAR2_TABLE_100();
174: a15 := JTF_NUMBER_TABLE();
175: a16 := JTF_NUMBER_TABLE();
176: a17 := JTF_NUMBER_TABLE();
177: a18 := JTF_DATE_TABLE();

Line 179: a20 := JTF_VARCHAR2_TABLE_100();

175: a16 := JTF_NUMBER_TABLE();
176: a17 := JTF_NUMBER_TABLE();
177: a18 := JTF_DATE_TABLE();
178: a19 := JTF_NUMBER_TABLE();
179: a20 := JTF_VARCHAR2_TABLE_100();
180: a21 := JTF_VARCHAR2_TABLE_500();
181: a22 := JTF_VARCHAR2_TABLE_500();
182: a23 := JTF_VARCHAR2_TABLE_500();
183: a24 := JTF_VARCHAR2_TABLE_500();

Line 200: a41 := JTF_VARCHAR2_TABLE_100();

196: a37 := JTF_DATE_TABLE();
197: a38 := JTF_NUMBER_TABLE();
198: a39 := JTF_DATE_TABLE();
199: a40 := JTF_NUMBER_TABLE();
200: a41 := JTF_VARCHAR2_TABLE_100();
201: a42 := JTF_NUMBER_TABLE();
202: a43 := JTF_VARCHAR2_TABLE_100();
203: a44 := JTF_VARCHAR2_TABLE_100();
204: else

Line 202: a43 := JTF_VARCHAR2_TABLE_100();

198: a39 := JTF_DATE_TABLE();
199: a40 := JTF_NUMBER_TABLE();
200: a41 := JTF_VARCHAR2_TABLE_100();
201: a42 := JTF_NUMBER_TABLE();
202: a43 := JTF_VARCHAR2_TABLE_100();
203: a44 := JTF_VARCHAR2_TABLE_100();
204: else
205: a0 := JTF_NUMBER_TABLE();
206: a1 := JTF_VARCHAR2_TABLE_100();

Line 203: a44 := JTF_VARCHAR2_TABLE_100();

199: a40 := JTF_NUMBER_TABLE();
200: a41 := JTF_VARCHAR2_TABLE_100();
201: a42 := JTF_NUMBER_TABLE();
202: a43 := JTF_VARCHAR2_TABLE_100();
203: a44 := JTF_VARCHAR2_TABLE_100();
204: else
205: a0 := JTF_NUMBER_TABLE();
206: a1 := JTF_VARCHAR2_TABLE_100();
207: a2 := JTF_VARCHAR2_TABLE_100();

Line 206: a1 := JTF_VARCHAR2_TABLE_100();

202: a43 := JTF_VARCHAR2_TABLE_100();
203: a44 := JTF_VARCHAR2_TABLE_100();
204: else
205: a0 := JTF_NUMBER_TABLE();
206: a1 := JTF_VARCHAR2_TABLE_100();
207: a2 := JTF_VARCHAR2_TABLE_100();
208: a3 := JTF_DATE_TABLE();
209: a4 := JTF_NUMBER_TABLE();
210: a5 := JTF_NUMBER_TABLE();

Line 207: a2 := JTF_VARCHAR2_TABLE_100();

203: a44 := JTF_VARCHAR2_TABLE_100();
204: else
205: a0 := JTF_NUMBER_TABLE();
206: a1 := JTF_VARCHAR2_TABLE_100();
207: a2 := JTF_VARCHAR2_TABLE_100();
208: a3 := JTF_DATE_TABLE();
209: a4 := JTF_NUMBER_TABLE();
210: a5 := JTF_NUMBER_TABLE();
211: a6 := JTF_NUMBER_TABLE();

Line 216: a11 := JTF_VARCHAR2_TABLE_100();

212: a7 := JTF_DATE_TABLE();
213: a8 := JTF_NUMBER_TABLE();
214: a9 := JTF_NUMBER_TABLE();
215: a10 := JTF_NUMBER_TABLE();
216: a11 := JTF_VARCHAR2_TABLE_100();
217: a12 := JTF_NUMBER_TABLE();
218: a13 := JTF_DATE_TABLE();
219: a14 := JTF_VARCHAR2_TABLE_100();
220: a15 := JTF_NUMBER_TABLE();

Line 219: a14 := JTF_VARCHAR2_TABLE_100();

215: a10 := JTF_NUMBER_TABLE();
216: a11 := JTF_VARCHAR2_TABLE_100();
217: a12 := JTF_NUMBER_TABLE();
218: a13 := JTF_DATE_TABLE();
219: a14 := JTF_VARCHAR2_TABLE_100();
220: a15 := JTF_NUMBER_TABLE();
221: a16 := JTF_NUMBER_TABLE();
222: a17 := JTF_NUMBER_TABLE();
223: a18 := JTF_DATE_TABLE();

Line 225: a20 := JTF_VARCHAR2_TABLE_100();

221: a16 := JTF_NUMBER_TABLE();
222: a17 := JTF_NUMBER_TABLE();
223: a18 := JTF_DATE_TABLE();
224: a19 := JTF_NUMBER_TABLE();
225: a20 := JTF_VARCHAR2_TABLE_100();
226: a21 := JTF_VARCHAR2_TABLE_500();
227: a22 := JTF_VARCHAR2_TABLE_500();
228: a23 := JTF_VARCHAR2_TABLE_500();
229: a24 := JTF_VARCHAR2_TABLE_500();

Line 246: a41 := JTF_VARCHAR2_TABLE_100();

242: a37 := JTF_DATE_TABLE();
243: a38 := JTF_NUMBER_TABLE();
244: a39 := JTF_DATE_TABLE();
245: a40 := JTF_NUMBER_TABLE();
246: a41 := JTF_VARCHAR2_TABLE_100();
247: a42 := JTF_NUMBER_TABLE();
248: a43 := JTF_VARCHAR2_TABLE_100();
249: a44 := JTF_VARCHAR2_TABLE_100();
250: if t.count > 0 then

Line 248: a43 := JTF_VARCHAR2_TABLE_100();

244: a39 := JTF_DATE_TABLE();
245: a40 := JTF_NUMBER_TABLE();
246: a41 := JTF_VARCHAR2_TABLE_100();
247: a42 := JTF_NUMBER_TABLE();
248: a43 := JTF_VARCHAR2_TABLE_100();
249: a44 := JTF_VARCHAR2_TABLE_100();
250: if t.count > 0 then
251: a0.extend(t.count);
252: a1.extend(t.count);

Line 249: a44 := JTF_VARCHAR2_TABLE_100();

245: a40 := JTF_NUMBER_TABLE();
246: a41 := JTF_VARCHAR2_TABLE_100();
247: a42 := JTF_NUMBER_TABLE();
248: a43 := JTF_VARCHAR2_TABLE_100();
249: a44 := JTF_VARCHAR2_TABLE_100();
250: if t.count > 0 then
251: a0.extend(t.count);
252: a1.extend(t.count);
253: a2.extend(t.count);

Line 355: , a1 JTF_VARCHAR2_TABLE_100

351: end if;
352: end rosetta_table_copy_out_p2;
353:
354: procedure rosetta_table_copy_in_p5(t out nocopy okl_rct_pvt.okltrxcshreceipttltbltype, a0 JTF_NUMBER_TABLE
355: , a1 JTF_VARCHAR2_TABLE_100
356: , a2 JTF_VARCHAR2_TABLE_100
357: , a3 JTF_VARCHAR2_TABLE_100
358: , a4 JTF_VARCHAR2_TABLE_2000
359: , a5 JTF_NUMBER_TABLE

Line 356: , a2 JTF_VARCHAR2_TABLE_100

352: end rosetta_table_copy_out_p2;
353:
354: procedure rosetta_table_copy_in_p5(t out nocopy okl_rct_pvt.okltrxcshreceipttltbltype, a0 JTF_NUMBER_TABLE
355: , a1 JTF_VARCHAR2_TABLE_100
356: , a2 JTF_VARCHAR2_TABLE_100
357: , a3 JTF_VARCHAR2_TABLE_100
358: , a4 JTF_VARCHAR2_TABLE_2000
359: , a5 JTF_NUMBER_TABLE
360: , a6 JTF_DATE_TABLE

Line 357: , a3 JTF_VARCHAR2_TABLE_100

353:
354: procedure rosetta_table_copy_in_p5(t out nocopy okl_rct_pvt.okltrxcshreceipttltbltype, a0 JTF_NUMBER_TABLE
355: , a1 JTF_VARCHAR2_TABLE_100
356: , a2 JTF_VARCHAR2_TABLE_100
357: , a3 JTF_VARCHAR2_TABLE_100
358: , a4 JTF_VARCHAR2_TABLE_2000
359: , a5 JTF_NUMBER_TABLE
360: , a6 JTF_DATE_TABLE
361: , a7 JTF_NUMBER_TABLE

Line 392: , a1 out nocopy JTF_VARCHAR2_TABLE_100

388: end if;
389: end if;
390: end rosetta_table_copy_in_p5;
391: procedure rosetta_table_copy_out_p5(t okl_rct_pvt.okltrxcshreceipttltbltype, a0 out nocopy JTF_NUMBER_TABLE
392: , a1 out nocopy JTF_VARCHAR2_TABLE_100
393: , a2 out nocopy JTF_VARCHAR2_TABLE_100
394: , a3 out nocopy JTF_VARCHAR2_TABLE_100
395: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
396: , a5 out nocopy JTF_NUMBER_TABLE

Line 393: , a2 out nocopy JTF_VARCHAR2_TABLE_100

389: end if;
390: end rosetta_table_copy_in_p5;
391: procedure rosetta_table_copy_out_p5(t okl_rct_pvt.okltrxcshreceipttltbltype, a0 out nocopy JTF_NUMBER_TABLE
392: , a1 out nocopy JTF_VARCHAR2_TABLE_100
393: , a2 out nocopy JTF_VARCHAR2_TABLE_100
394: , a3 out nocopy JTF_VARCHAR2_TABLE_100
395: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
396: , a5 out nocopy JTF_NUMBER_TABLE
397: , a6 out nocopy JTF_DATE_TABLE

Line 394: , a3 out nocopy JTF_VARCHAR2_TABLE_100

390: end rosetta_table_copy_in_p5;
391: procedure rosetta_table_copy_out_p5(t okl_rct_pvt.okltrxcshreceipttltbltype, a0 out nocopy JTF_NUMBER_TABLE
392: , a1 out nocopy JTF_VARCHAR2_TABLE_100
393: , a2 out nocopy JTF_VARCHAR2_TABLE_100
394: , a3 out nocopy JTF_VARCHAR2_TABLE_100
395: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
396: , a5 out nocopy JTF_NUMBER_TABLE
397: , a6 out nocopy JTF_DATE_TABLE
398: , a7 out nocopy JTF_NUMBER_TABLE

Line 406: a1 := JTF_VARCHAR2_TABLE_100();

402: ddindx binary_integer; indx binary_integer;
403: begin
404: if t is null or t.count = 0 then
405: a0 := JTF_NUMBER_TABLE();
406: a1 := JTF_VARCHAR2_TABLE_100();
407: a2 := JTF_VARCHAR2_TABLE_100();
408: a3 := JTF_VARCHAR2_TABLE_100();
409: a4 := JTF_VARCHAR2_TABLE_2000();
410: a5 := JTF_NUMBER_TABLE();

Line 407: a2 := JTF_VARCHAR2_TABLE_100();

403: begin
404: if t is null or t.count = 0 then
405: a0 := JTF_NUMBER_TABLE();
406: a1 := JTF_VARCHAR2_TABLE_100();
407: a2 := JTF_VARCHAR2_TABLE_100();
408: a3 := JTF_VARCHAR2_TABLE_100();
409: a4 := JTF_VARCHAR2_TABLE_2000();
410: a5 := JTF_NUMBER_TABLE();
411: a6 := JTF_DATE_TABLE();

Line 408: a3 := JTF_VARCHAR2_TABLE_100();

404: if t is null or t.count = 0 then
405: a0 := JTF_NUMBER_TABLE();
406: a1 := JTF_VARCHAR2_TABLE_100();
407: a2 := JTF_VARCHAR2_TABLE_100();
408: a3 := JTF_VARCHAR2_TABLE_100();
409: a4 := JTF_VARCHAR2_TABLE_2000();
410: a5 := JTF_NUMBER_TABLE();
411: a6 := JTF_DATE_TABLE();
412: a7 := JTF_NUMBER_TABLE();

Line 417: a1 := JTF_VARCHAR2_TABLE_100();

413: a8 := JTF_DATE_TABLE();
414: a9 := JTF_NUMBER_TABLE();
415: else
416: a0 := JTF_NUMBER_TABLE();
417: a1 := JTF_VARCHAR2_TABLE_100();
418: a2 := JTF_VARCHAR2_TABLE_100();
419: a3 := JTF_VARCHAR2_TABLE_100();
420: a4 := JTF_VARCHAR2_TABLE_2000();
421: a5 := JTF_NUMBER_TABLE();

Line 418: a2 := JTF_VARCHAR2_TABLE_100();

414: a9 := JTF_NUMBER_TABLE();
415: else
416: a0 := JTF_NUMBER_TABLE();
417: a1 := JTF_VARCHAR2_TABLE_100();
418: a2 := JTF_VARCHAR2_TABLE_100();
419: a3 := JTF_VARCHAR2_TABLE_100();
420: a4 := JTF_VARCHAR2_TABLE_2000();
421: a5 := JTF_NUMBER_TABLE();
422: a6 := JTF_DATE_TABLE();

Line 419: a3 := JTF_VARCHAR2_TABLE_100();

415: else
416: a0 := JTF_NUMBER_TABLE();
417: a1 := JTF_VARCHAR2_TABLE_100();
418: a2 := JTF_VARCHAR2_TABLE_100();
419: a3 := JTF_VARCHAR2_TABLE_100();
420: a4 := JTF_VARCHAR2_TABLE_2000();
421: a5 := JTF_NUMBER_TABLE();
422: a6 := JTF_DATE_TABLE();
423: a7 := JTF_NUMBER_TABLE();

Line 462: , a2 JTF_VARCHAR2_TABLE_100

458: end rosetta_table_copy_out_p5;
459:
460: procedure rosetta_table_copy_in_p8(t out nocopy okl_rct_pvt.rctv_tbl_type, a0 JTF_NUMBER_TABLE
461: , a1 JTF_NUMBER_TABLE
462: , a2 JTF_VARCHAR2_TABLE_100
463: , a3 JTF_NUMBER_TABLE
464: , a4 JTF_NUMBER_TABLE
465: , a5 JTF_DATE_TABLE
466: , a6 JTF_NUMBER_TABLE

Line 468: , a8 JTF_VARCHAR2_TABLE_100

464: , a4 JTF_NUMBER_TABLE
465: , a5 JTF_DATE_TABLE
466: , a6 JTF_NUMBER_TABLE
467: , a7 JTF_NUMBER_TABLE
468: , a8 JTF_VARCHAR2_TABLE_100
469: , a9 JTF_VARCHAR2_TABLE_100
470: , a10 JTF_VARCHAR2_TABLE_100
471: , a11 JTF_DATE_TABLE
472: , a12 JTF_NUMBER_TABLE

Line 469: , a9 JTF_VARCHAR2_TABLE_100

465: , a5 JTF_DATE_TABLE
466: , a6 JTF_NUMBER_TABLE
467: , a7 JTF_NUMBER_TABLE
468: , a8 JTF_VARCHAR2_TABLE_100
469: , a9 JTF_VARCHAR2_TABLE_100
470: , a10 JTF_VARCHAR2_TABLE_100
471: , a11 JTF_DATE_TABLE
472: , a12 JTF_NUMBER_TABLE
473: , a13 JTF_NUMBER_TABLE

Line 470: , a10 JTF_VARCHAR2_TABLE_100

466: , a6 JTF_NUMBER_TABLE
467: , a7 JTF_NUMBER_TABLE
468: , a8 JTF_VARCHAR2_TABLE_100
469: , a9 JTF_VARCHAR2_TABLE_100
470: , a10 JTF_VARCHAR2_TABLE_100
471: , a11 JTF_DATE_TABLE
472: , a12 JTF_NUMBER_TABLE
473: , a13 JTF_NUMBER_TABLE
474: , a14 JTF_DATE_TABLE

Line 475: , a15 JTF_VARCHAR2_TABLE_100

471: , a11 JTF_DATE_TABLE
472: , a12 JTF_NUMBER_TABLE
473: , a13 JTF_NUMBER_TABLE
474: , a14 JTF_DATE_TABLE
475: , a15 JTF_VARCHAR2_TABLE_100
476: , a16 JTF_VARCHAR2_TABLE_2000
477: , a17 JTF_VARCHAR2_TABLE_100
478: , a18 JTF_VARCHAR2_TABLE_500
479: , a19 JTF_VARCHAR2_TABLE_500

Line 477: , a17 JTF_VARCHAR2_TABLE_100

473: , a13 JTF_NUMBER_TABLE
474: , a14 JTF_DATE_TABLE
475: , a15 JTF_VARCHAR2_TABLE_100
476: , a16 JTF_VARCHAR2_TABLE_2000
477: , a17 JTF_VARCHAR2_TABLE_100
478: , a18 JTF_VARCHAR2_TABLE_500
479: , a19 JTF_VARCHAR2_TABLE_500
480: , a20 JTF_VARCHAR2_TABLE_500
481: , a21 JTF_VARCHAR2_TABLE_500

Line 503: , a43 JTF_VARCHAR2_TABLE_100

499: , a39 JTF_DATE_TABLE
500: , a40 JTF_NUMBER_TABLE
501: , a41 JTF_DATE_TABLE
502: , a42 JTF_NUMBER_TABLE
503: , a43 JTF_VARCHAR2_TABLE_100
504: , a44 JTF_NUMBER_TABLE
505: , a45 JTF_VARCHAR2_TABLE_100
506: , a46 JTF_VARCHAR2_TABLE_100
507: ) as

Line 505: , a45 JTF_VARCHAR2_TABLE_100

501: , a41 JTF_DATE_TABLE
502: , a42 JTF_NUMBER_TABLE
503: , a43 JTF_VARCHAR2_TABLE_100
504: , a44 JTF_NUMBER_TABLE
505: , a45 JTF_VARCHAR2_TABLE_100
506: , a46 JTF_VARCHAR2_TABLE_100
507: ) as
508: ddindx binary_integer; indx binary_integer;
509: begin

Line 506: , a46 JTF_VARCHAR2_TABLE_100

502: , a42 JTF_NUMBER_TABLE
503: , a43 JTF_VARCHAR2_TABLE_100
504: , a44 JTF_NUMBER_TABLE
505: , a45 JTF_VARCHAR2_TABLE_100
506: , a46 JTF_VARCHAR2_TABLE_100
507: ) as
508: ddindx binary_integer; indx binary_integer;
509: begin
510: if a0 is not null and a0.count > 0 then

Line 573: , a2 out nocopy JTF_VARCHAR2_TABLE_100

569: end if;
570: end rosetta_table_copy_in_p8;
571: procedure rosetta_table_copy_out_p8(t okl_rct_pvt.rctv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
572: , a1 out nocopy JTF_NUMBER_TABLE
573: , a2 out nocopy JTF_VARCHAR2_TABLE_100
574: , a3 out nocopy JTF_NUMBER_TABLE
575: , a4 out nocopy JTF_NUMBER_TABLE
576: , a5 out nocopy JTF_DATE_TABLE
577: , a6 out nocopy JTF_NUMBER_TABLE

Line 579: , a8 out nocopy JTF_VARCHAR2_TABLE_100

575: , a4 out nocopy JTF_NUMBER_TABLE
576: , a5 out nocopy JTF_DATE_TABLE
577: , a6 out nocopy JTF_NUMBER_TABLE
578: , a7 out nocopy JTF_NUMBER_TABLE
579: , a8 out nocopy JTF_VARCHAR2_TABLE_100
580: , a9 out nocopy JTF_VARCHAR2_TABLE_100
581: , a10 out nocopy JTF_VARCHAR2_TABLE_100
582: , a11 out nocopy JTF_DATE_TABLE
583: , a12 out nocopy JTF_NUMBER_TABLE

Line 580: , a9 out nocopy JTF_VARCHAR2_TABLE_100

576: , a5 out nocopy JTF_DATE_TABLE
577: , a6 out nocopy JTF_NUMBER_TABLE
578: , a7 out nocopy JTF_NUMBER_TABLE
579: , a8 out nocopy JTF_VARCHAR2_TABLE_100
580: , a9 out nocopy JTF_VARCHAR2_TABLE_100
581: , a10 out nocopy JTF_VARCHAR2_TABLE_100
582: , a11 out nocopy JTF_DATE_TABLE
583: , a12 out nocopy JTF_NUMBER_TABLE
584: , a13 out nocopy JTF_NUMBER_TABLE

Line 581: , a10 out nocopy JTF_VARCHAR2_TABLE_100

577: , a6 out nocopy JTF_NUMBER_TABLE
578: , a7 out nocopy JTF_NUMBER_TABLE
579: , a8 out nocopy JTF_VARCHAR2_TABLE_100
580: , a9 out nocopy JTF_VARCHAR2_TABLE_100
581: , a10 out nocopy JTF_VARCHAR2_TABLE_100
582: , a11 out nocopy JTF_DATE_TABLE
583: , a12 out nocopy JTF_NUMBER_TABLE
584: , a13 out nocopy JTF_NUMBER_TABLE
585: , a14 out nocopy JTF_DATE_TABLE

Line 586: , a15 out nocopy JTF_VARCHAR2_TABLE_100

582: , a11 out nocopy JTF_DATE_TABLE
583: , a12 out nocopy JTF_NUMBER_TABLE
584: , a13 out nocopy JTF_NUMBER_TABLE
585: , a14 out nocopy JTF_DATE_TABLE
586: , a15 out nocopy JTF_VARCHAR2_TABLE_100
587: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
588: , a17 out nocopy JTF_VARCHAR2_TABLE_100
589: , a18 out nocopy JTF_VARCHAR2_TABLE_500
590: , a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 588: , a17 out nocopy JTF_VARCHAR2_TABLE_100

584: , a13 out nocopy JTF_NUMBER_TABLE
585: , a14 out nocopy JTF_DATE_TABLE
586: , a15 out nocopy JTF_VARCHAR2_TABLE_100
587: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
588: , a17 out nocopy JTF_VARCHAR2_TABLE_100
589: , a18 out nocopy JTF_VARCHAR2_TABLE_500
590: , a19 out nocopy JTF_VARCHAR2_TABLE_500
591: , a20 out nocopy JTF_VARCHAR2_TABLE_500
592: , a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 614: , a43 out nocopy JTF_VARCHAR2_TABLE_100

610: , a39 out nocopy JTF_DATE_TABLE
611: , a40 out nocopy JTF_NUMBER_TABLE
612: , a41 out nocopy JTF_DATE_TABLE
613: , a42 out nocopy JTF_NUMBER_TABLE
614: , a43 out nocopy JTF_VARCHAR2_TABLE_100
615: , a44 out nocopy JTF_NUMBER_TABLE
616: , a45 out nocopy JTF_VARCHAR2_TABLE_100
617: , a46 out nocopy JTF_VARCHAR2_TABLE_100
618: ) as

Line 616: , a45 out nocopy JTF_VARCHAR2_TABLE_100

612: , a41 out nocopy JTF_DATE_TABLE
613: , a42 out nocopy JTF_NUMBER_TABLE
614: , a43 out nocopy JTF_VARCHAR2_TABLE_100
615: , a44 out nocopy JTF_NUMBER_TABLE
616: , a45 out nocopy JTF_VARCHAR2_TABLE_100
617: , a46 out nocopy JTF_VARCHAR2_TABLE_100
618: ) as
619: ddindx binary_integer; indx binary_integer;
620: begin

Line 617: , a46 out nocopy JTF_VARCHAR2_TABLE_100

613: , a42 out nocopy JTF_NUMBER_TABLE
614: , a43 out nocopy JTF_VARCHAR2_TABLE_100
615: , a44 out nocopy JTF_NUMBER_TABLE
616: , a45 out nocopy JTF_VARCHAR2_TABLE_100
617: , a46 out nocopy JTF_VARCHAR2_TABLE_100
618: ) as
619: ddindx binary_integer; indx binary_integer;
620: begin
621: if t is null or t.count = 0 then

Line 624: a2 := JTF_VARCHAR2_TABLE_100();

620: begin
621: if t is null or t.count = 0 then
622: a0 := JTF_NUMBER_TABLE();
623: a1 := JTF_NUMBER_TABLE();
624: a2 := JTF_VARCHAR2_TABLE_100();
625: a3 := JTF_NUMBER_TABLE();
626: a4 := JTF_NUMBER_TABLE();
627: a5 := JTF_DATE_TABLE();
628: a6 := JTF_NUMBER_TABLE();

Line 630: a8 := JTF_VARCHAR2_TABLE_100();

626: a4 := JTF_NUMBER_TABLE();
627: a5 := JTF_DATE_TABLE();
628: a6 := JTF_NUMBER_TABLE();
629: a7 := JTF_NUMBER_TABLE();
630: a8 := JTF_VARCHAR2_TABLE_100();
631: a9 := JTF_VARCHAR2_TABLE_100();
632: a10 := JTF_VARCHAR2_TABLE_100();
633: a11 := JTF_DATE_TABLE();
634: a12 := JTF_NUMBER_TABLE();

Line 631: a9 := JTF_VARCHAR2_TABLE_100();

627: a5 := JTF_DATE_TABLE();
628: a6 := JTF_NUMBER_TABLE();
629: a7 := JTF_NUMBER_TABLE();
630: a8 := JTF_VARCHAR2_TABLE_100();
631: a9 := JTF_VARCHAR2_TABLE_100();
632: a10 := JTF_VARCHAR2_TABLE_100();
633: a11 := JTF_DATE_TABLE();
634: a12 := JTF_NUMBER_TABLE();
635: a13 := JTF_NUMBER_TABLE();

Line 632: a10 := JTF_VARCHAR2_TABLE_100();

628: a6 := JTF_NUMBER_TABLE();
629: a7 := JTF_NUMBER_TABLE();
630: a8 := JTF_VARCHAR2_TABLE_100();
631: a9 := JTF_VARCHAR2_TABLE_100();
632: a10 := JTF_VARCHAR2_TABLE_100();
633: a11 := JTF_DATE_TABLE();
634: a12 := JTF_NUMBER_TABLE();
635: a13 := JTF_NUMBER_TABLE();
636: a14 := JTF_DATE_TABLE();

Line 637: a15 := JTF_VARCHAR2_TABLE_100();

633: a11 := JTF_DATE_TABLE();
634: a12 := JTF_NUMBER_TABLE();
635: a13 := JTF_NUMBER_TABLE();
636: a14 := JTF_DATE_TABLE();
637: a15 := JTF_VARCHAR2_TABLE_100();
638: a16 := JTF_VARCHAR2_TABLE_2000();
639: a17 := JTF_VARCHAR2_TABLE_100();
640: a18 := JTF_VARCHAR2_TABLE_500();
641: a19 := JTF_VARCHAR2_TABLE_500();

Line 639: a17 := JTF_VARCHAR2_TABLE_100();

635: a13 := JTF_NUMBER_TABLE();
636: a14 := JTF_DATE_TABLE();
637: a15 := JTF_VARCHAR2_TABLE_100();
638: a16 := JTF_VARCHAR2_TABLE_2000();
639: a17 := JTF_VARCHAR2_TABLE_100();
640: a18 := JTF_VARCHAR2_TABLE_500();
641: a19 := JTF_VARCHAR2_TABLE_500();
642: a20 := JTF_VARCHAR2_TABLE_500();
643: a21 := JTF_VARCHAR2_TABLE_500();

Line 665: a43 := JTF_VARCHAR2_TABLE_100();

661: a39 := JTF_DATE_TABLE();
662: a40 := JTF_NUMBER_TABLE();
663: a41 := JTF_DATE_TABLE();
664: a42 := JTF_NUMBER_TABLE();
665: a43 := JTF_VARCHAR2_TABLE_100();
666: a44 := JTF_NUMBER_TABLE();
667: a45 := JTF_VARCHAR2_TABLE_100();
668: a46 := JTF_VARCHAR2_TABLE_100();
669: else

Line 667: a45 := JTF_VARCHAR2_TABLE_100();

663: a41 := JTF_DATE_TABLE();
664: a42 := JTF_NUMBER_TABLE();
665: a43 := JTF_VARCHAR2_TABLE_100();
666: a44 := JTF_NUMBER_TABLE();
667: a45 := JTF_VARCHAR2_TABLE_100();
668: a46 := JTF_VARCHAR2_TABLE_100();
669: else
670: a0 := JTF_NUMBER_TABLE();
671: a1 := JTF_NUMBER_TABLE();

Line 668: a46 := JTF_VARCHAR2_TABLE_100();

664: a42 := JTF_NUMBER_TABLE();
665: a43 := JTF_VARCHAR2_TABLE_100();
666: a44 := JTF_NUMBER_TABLE();
667: a45 := JTF_VARCHAR2_TABLE_100();
668: a46 := JTF_VARCHAR2_TABLE_100();
669: else
670: a0 := JTF_NUMBER_TABLE();
671: a1 := JTF_NUMBER_TABLE();
672: a2 := JTF_VARCHAR2_TABLE_100();

Line 672: a2 := JTF_VARCHAR2_TABLE_100();

668: a46 := JTF_VARCHAR2_TABLE_100();
669: else
670: a0 := JTF_NUMBER_TABLE();
671: a1 := JTF_NUMBER_TABLE();
672: a2 := JTF_VARCHAR2_TABLE_100();
673: a3 := JTF_NUMBER_TABLE();
674: a4 := JTF_NUMBER_TABLE();
675: a5 := JTF_DATE_TABLE();
676: a6 := JTF_NUMBER_TABLE();

Line 678: a8 := JTF_VARCHAR2_TABLE_100();

674: a4 := JTF_NUMBER_TABLE();
675: a5 := JTF_DATE_TABLE();
676: a6 := JTF_NUMBER_TABLE();
677: a7 := JTF_NUMBER_TABLE();
678: a8 := JTF_VARCHAR2_TABLE_100();
679: a9 := JTF_VARCHAR2_TABLE_100();
680: a10 := JTF_VARCHAR2_TABLE_100();
681: a11 := JTF_DATE_TABLE();
682: a12 := JTF_NUMBER_TABLE();

Line 679: a9 := JTF_VARCHAR2_TABLE_100();

675: a5 := JTF_DATE_TABLE();
676: a6 := JTF_NUMBER_TABLE();
677: a7 := JTF_NUMBER_TABLE();
678: a8 := JTF_VARCHAR2_TABLE_100();
679: a9 := JTF_VARCHAR2_TABLE_100();
680: a10 := JTF_VARCHAR2_TABLE_100();
681: a11 := JTF_DATE_TABLE();
682: a12 := JTF_NUMBER_TABLE();
683: a13 := JTF_NUMBER_TABLE();

Line 680: a10 := JTF_VARCHAR2_TABLE_100();

676: a6 := JTF_NUMBER_TABLE();
677: a7 := JTF_NUMBER_TABLE();
678: a8 := JTF_VARCHAR2_TABLE_100();
679: a9 := JTF_VARCHAR2_TABLE_100();
680: a10 := JTF_VARCHAR2_TABLE_100();
681: a11 := JTF_DATE_TABLE();
682: a12 := JTF_NUMBER_TABLE();
683: a13 := JTF_NUMBER_TABLE();
684: a14 := JTF_DATE_TABLE();

Line 685: a15 := JTF_VARCHAR2_TABLE_100();

681: a11 := JTF_DATE_TABLE();
682: a12 := JTF_NUMBER_TABLE();
683: a13 := JTF_NUMBER_TABLE();
684: a14 := JTF_DATE_TABLE();
685: a15 := JTF_VARCHAR2_TABLE_100();
686: a16 := JTF_VARCHAR2_TABLE_2000();
687: a17 := JTF_VARCHAR2_TABLE_100();
688: a18 := JTF_VARCHAR2_TABLE_500();
689: a19 := JTF_VARCHAR2_TABLE_500();

Line 687: a17 := JTF_VARCHAR2_TABLE_100();

683: a13 := JTF_NUMBER_TABLE();
684: a14 := JTF_DATE_TABLE();
685: a15 := JTF_VARCHAR2_TABLE_100();
686: a16 := JTF_VARCHAR2_TABLE_2000();
687: a17 := JTF_VARCHAR2_TABLE_100();
688: a18 := JTF_VARCHAR2_TABLE_500();
689: a19 := JTF_VARCHAR2_TABLE_500();
690: a20 := JTF_VARCHAR2_TABLE_500();
691: a21 := JTF_VARCHAR2_TABLE_500();

Line 713: a43 := JTF_VARCHAR2_TABLE_100();

709: a39 := JTF_DATE_TABLE();
710: a40 := JTF_NUMBER_TABLE();
711: a41 := JTF_DATE_TABLE();
712: a42 := JTF_NUMBER_TABLE();
713: a43 := JTF_VARCHAR2_TABLE_100();
714: a44 := JTF_NUMBER_TABLE();
715: a45 := JTF_VARCHAR2_TABLE_100();
716: a46 := JTF_VARCHAR2_TABLE_100();
717: if t.count > 0 then

Line 715: a45 := JTF_VARCHAR2_TABLE_100();

711: a41 := JTF_DATE_TABLE();
712: a42 := JTF_NUMBER_TABLE();
713: a43 := JTF_VARCHAR2_TABLE_100();
714: a44 := JTF_NUMBER_TABLE();
715: a45 := JTF_VARCHAR2_TABLE_100();
716: a46 := JTF_VARCHAR2_TABLE_100();
717: if t.count > 0 then
718: a0.extend(t.count);
719: a1.extend(t.count);

Line 716: a46 := JTF_VARCHAR2_TABLE_100();

712: a42 := JTF_NUMBER_TABLE();
713: a43 := JTF_VARCHAR2_TABLE_100();
714: a44 := JTF_NUMBER_TABLE();
715: a45 := JTF_VARCHAR2_TABLE_100();
716: a46 := JTF_VARCHAR2_TABLE_100();
717: if t.count > 0 then
718: a0.extend(t.count);
719: a1.extend(t.count);
720: a2.extend(t.count);

Line 1059: , p5_a2 JTF_VARCHAR2_TABLE_100

1055: , x_msg_count out nocopy NUMBER
1056: , x_msg_data out nocopy VARCHAR2
1057: , p5_a0 JTF_NUMBER_TABLE
1058: , p5_a1 JTF_NUMBER_TABLE
1059: , p5_a2 JTF_VARCHAR2_TABLE_100
1060: , p5_a3 JTF_NUMBER_TABLE
1061: , p5_a4 JTF_NUMBER_TABLE
1062: , p5_a5 JTF_DATE_TABLE
1063: , p5_a6 JTF_NUMBER_TABLE

Line 1065: , p5_a8 JTF_VARCHAR2_TABLE_100

1061: , p5_a4 JTF_NUMBER_TABLE
1062: , p5_a5 JTF_DATE_TABLE
1063: , p5_a6 JTF_NUMBER_TABLE
1064: , p5_a7 JTF_NUMBER_TABLE
1065: , p5_a8 JTF_VARCHAR2_TABLE_100
1066: , p5_a9 JTF_VARCHAR2_TABLE_100
1067: , p5_a10 JTF_VARCHAR2_TABLE_100
1068: , p5_a11 JTF_DATE_TABLE
1069: , p5_a12 JTF_NUMBER_TABLE

Line 1066: , p5_a9 JTF_VARCHAR2_TABLE_100

1062: , p5_a5 JTF_DATE_TABLE
1063: , p5_a6 JTF_NUMBER_TABLE
1064: , p5_a7 JTF_NUMBER_TABLE
1065: , p5_a8 JTF_VARCHAR2_TABLE_100
1066: , p5_a9 JTF_VARCHAR2_TABLE_100
1067: , p5_a10 JTF_VARCHAR2_TABLE_100
1068: , p5_a11 JTF_DATE_TABLE
1069: , p5_a12 JTF_NUMBER_TABLE
1070: , p5_a13 JTF_NUMBER_TABLE

Line 1067: , p5_a10 JTF_VARCHAR2_TABLE_100

1063: , p5_a6 JTF_NUMBER_TABLE
1064: , p5_a7 JTF_NUMBER_TABLE
1065: , p5_a8 JTF_VARCHAR2_TABLE_100
1066: , p5_a9 JTF_VARCHAR2_TABLE_100
1067: , p5_a10 JTF_VARCHAR2_TABLE_100
1068: , p5_a11 JTF_DATE_TABLE
1069: , p5_a12 JTF_NUMBER_TABLE
1070: , p5_a13 JTF_NUMBER_TABLE
1071: , p5_a14 JTF_DATE_TABLE

Line 1072: , p5_a15 JTF_VARCHAR2_TABLE_100

1068: , p5_a11 JTF_DATE_TABLE
1069: , p5_a12 JTF_NUMBER_TABLE
1070: , p5_a13 JTF_NUMBER_TABLE
1071: , p5_a14 JTF_DATE_TABLE
1072: , p5_a15 JTF_VARCHAR2_TABLE_100
1073: , p5_a16 JTF_VARCHAR2_TABLE_2000
1074: , p5_a17 JTF_VARCHAR2_TABLE_100
1075: , p5_a18 JTF_VARCHAR2_TABLE_500
1076: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 1074: , p5_a17 JTF_VARCHAR2_TABLE_100

1070: , p5_a13 JTF_NUMBER_TABLE
1071: , p5_a14 JTF_DATE_TABLE
1072: , p5_a15 JTF_VARCHAR2_TABLE_100
1073: , p5_a16 JTF_VARCHAR2_TABLE_2000
1074: , p5_a17 JTF_VARCHAR2_TABLE_100
1075: , p5_a18 JTF_VARCHAR2_TABLE_500
1076: , p5_a19 JTF_VARCHAR2_TABLE_500
1077: , p5_a20 JTF_VARCHAR2_TABLE_500
1078: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 1100: , p5_a43 JTF_VARCHAR2_TABLE_100

1096: , p5_a39 JTF_DATE_TABLE
1097: , p5_a40 JTF_NUMBER_TABLE
1098: , p5_a41 JTF_DATE_TABLE
1099: , p5_a42 JTF_NUMBER_TABLE
1100: , p5_a43 JTF_VARCHAR2_TABLE_100
1101: , p5_a44 JTF_NUMBER_TABLE
1102: , p5_a45 JTF_VARCHAR2_TABLE_100
1103: , p5_a46 JTF_VARCHAR2_TABLE_100
1104: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 1102: , p5_a45 JTF_VARCHAR2_TABLE_100

1098: , p5_a41 JTF_DATE_TABLE
1099: , p5_a42 JTF_NUMBER_TABLE
1100: , p5_a43 JTF_VARCHAR2_TABLE_100
1101: , p5_a44 JTF_NUMBER_TABLE
1102: , p5_a45 JTF_VARCHAR2_TABLE_100
1103: , p5_a46 JTF_VARCHAR2_TABLE_100
1104: , p6_a0 out nocopy JTF_NUMBER_TABLE
1105: , p6_a1 out nocopy JTF_NUMBER_TABLE
1106: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 1103: , p5_a46 JTF_VARCHAR2_TABLE_100

1099: , p5_a42 JTF_NUMBER_TABLE
1100: , p5_a43 JTF_VARCHAR2_TABLE_100
1101: , p5_a44 JTF_NUMBER_TABLE
1102: , p5_a45 JTF_VARCHAR2_TABLE_100
1103: , p5_a46 JTF_VARCHAR2_TABLE_100
1104: , p6_a0 out nocopy JTF_NUMBER_TABLE
1105: , p6_a1 out nocopy JTF_NUMBER_TABLE
1106: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1107: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 1106: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

1102: , p5_a45 JTF_VARCHAR2_TABLE_100
1103: , p5_a46 JTF_VARCHAR2_TABLE_100
1104: , p6_a0 out nocopy JTF_NUMBER_TABLE
1105: , p6_a1 out nocopy JTF_NUMBER_TABLE
1106: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1107: , p6_a3 out nocopy JTF_NUMBER_TABLE
1108: , p6_a4 out nocopy JTF_NUMBER_TABLE
1109: , p6_a5 out nocopy JTF_DATE_TABLE
1110: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 1112: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

1108: , p6_a4 out nocopy JTF_NUMBER_TABLE
1109: , p6_a5 out nocopy JTF_DATE_TABLE
1110: , p6_a6 out nocopy JTF_NUMBER_TABLE
1111: , p6_a7 out nocopy JTF_NUMBER_TABLE
1112: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1113: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1114: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1115: , p6_a11 out nocopy JTF_DATE_TABLE
1116: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 1113: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

1109: , p6_a5 out nocopy JTF_DATE_TABLE
1110: , p6_a6 out nocopy JTF_NUMBER_TABLE
1111: , p6_a7 out nocopy JTF_NUMBER_TABLE
1112: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1113: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1114: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1115: , p6_a11 out nocopy JTF_DATE_TABLE
1116: , p6_a12 out nocopy JTF_NUMBER_TABLE
1117: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 1114: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

1110: , p6_a6 out nocopy JTF_NUMBER_TABLE
1111: , p6_a7 out nocopy JTF_NUMBER_TABLE
1112: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1113: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1114: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1115: , p6_a11 out nocopy JTF_DATE_TABLE
1116: , p6_a12 out nocopy JTF_NUMBER_TABLE
1117: , p6_a13 out nocopy JTF_NUMBER_TABLE
1118: , p6_a14 out nocopy JTF_DATE_TABLE

Line 1119: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

1115: , p6_a11 out nocopy JTF_DATE_TABLE
1116: , p6_a12 out nocopy JTF_NUMBER_TABLE
1117: , p6_a13 out nocopy JTF_NUMBER_TABLE
1118: , p6_a14 out nocopy JTF_DATE_TABLE
1119: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1120: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
1121: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1122: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1123: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 1121: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

1117: , p6_a13 out nocopy JTF_NUMBER_TABLE
1118: , p6_a14 out nocopy JTF_DATE_TABLE
1119: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1120: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
1121: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1122: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1123: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1124: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1125: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 1147: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100

1143: , p6_a39 out nocopy JTF_DATE_TABLE
1144: , p6_a40 out nocopy JTF_NUMBER_TABLE
1145: , p6_a41 out nocopy JTF_DATE_TABLE
1146: , p6_a42 out nocopy JTF_NUMBER_TABLE
1147: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1148: , p6_a44 out nocopy JTF_NUMBER_TABLE
1149: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
1150: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
1151: )

Line 1149: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100

1145: , p6_a41 out nocopy JTF_DATE_TABLE
1146: , p6_a42 out nocopy JTF_NUMBER_TABLE
1147: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1148: , p6_a44 out nocopy JTF_NUMBER_TABLE
1149: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
1150: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
1151: )
1152:
1153: as

Line 1150: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100

1146: , p6_a42 out nocopy JTF_NUMBER_TABLE
1147: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1148: , p6_a44 out nocopy JTF_NUMBER_TABLE
1149: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
1150: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
1151: )
1152:
1153: as
1154: ddp_rctv_tbl okl_rct_pvt.rctv_tbl_type;

Line 1417: , p5_a2 JTF_VARCHAR2_TABLE_100

1413: , x_msg_count out nocopy NUMBER
1414: , x_msg_data out nocopy VARCHAR2
1415: , p5_a0 JTF_NUMBER_TABLE
1416: , p5_a1 JTF_NUMBER_TABLE
1417: , p5_a2 JTF_VARCHAR2_TABLE_100
1418: , p5_a3 JTF_NUMBER_TABLE
1419: , p5_a4 JTF_NUMBER_TABLE
1420: , p5_a5 JTF_DATE_TABLE
1421: , p5_a6 JTF_NUMBER_TABLE

Line 1423: , p5_a8 JTF_VARCHAR2_TABLE_100

1419: , p5_a4 JTF_NUMBER_TABLE
1420: , p5_a5 JTF_DATE_TABLE
1421: , p5_a6 JTF_NUMBER_TABLE
1422: , p5_a7 JTF_NUMBER_TABLE
1423: , p5_a8 JTF_VARCHAR2_TABLE_100
1424: , p5_a9 JTF_VARCHAR2_TABLE_100
1425: , p5_a10 JTF_VARCHAR2_TABLE_100
1426: , p5_a11 JTF_DATE_TABLE
1427: , p5_a12 JTF_NUMBER_TABLE

Line 1424: , p5_a9 JTF_VARCHAR2_TABLE_100

1420: , p5_a5 JTF_DATE_TABLE
1421: , p5_a6 JTF_NUMBER_TABLE
1422: , p5_a7 JTF_NUMBER_TABLE
1423: , p5_a8 JTF_VARCHAR2_TABLE_100
1424: , p5_a9 JTF_VARCHAR2_TABLE_100
1425: , p5_a10 JTF_VARCHAR2_TABLE_100
1426: , p5_a11 JTF_DATE_TABLE
1427: , p5_a12 JTF_NUMBER_TABLE
1428: , p5_a13 JTF_NUMBER_TABLE

Line 1425: , p5_a10 JTF_VARCHAR2_TABLE_100

1421: , p5_a6 JTF_NUMBER_TABLE
1422: , p5_a7 JTF_NUMBER_TABLE
1423: , p5_a8 JTF_VARCHAR2_TABLE_100
1424: , p5_a9 JTF_VARCHAR2_TABLE_100
1425: , p5_a10 JTF_VARCHAR2_TABLE_100
1426: , p5_a11 JTF_DATE_TABLE
1427: , p5_a12 JTF_NUMBER_TABLE
1428: , p5_a13 JTF_NUMBER_TABLE
1429: , p5_a14 JTF_DATE_TABLE

Line 1430: , p5_a15 JTF_VARCHAR2_TABLE_100

1426: , p5_a11 JTF_DATE_TABLE
1427: , p5_a12 JTF_NUMBER_TABLE
1428: , p5_a13 JTF_NUMBER_TABLE
1429: , p5_a14 JTF_DATE_TABLE
1430: , p5_a15 JTF_VARCHAR2_TABLE_100
1431: , p5_a16 JTF_VARCHAR2_TABLE_2000
1432: , p5_a17 JTF_VARCHAR2_TABLE_100
1433: , p5_a18 JTF_VARCHAR2_TABLE_500
1434: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 1432: , p5_a17 JTF_VARCHAR2_TABLE_100

1428: , p5_a13 JTF_NUMBER_TABLE
1429: , p5_a14 JTF_DATE_TABLE
1430: , p5_a15 JTF_VARCHAR2_TABLE_100
1431: , p5_a16 JTF_VARCHAR2_TABLE_2000
1432: , p5_a17 JTF_VARCHAR2_TABLE_100
1433: , p5_a18 JTF_VARCHAR2_TABLE_500
1434: , p5_a19 JTF_VARCHAR2_TABLE_500
1435: , p5_a20 JTF_VARCHAR2_TABLE_500
1436: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 1458: , p5_a43 JTF_VARCHAR2_TABLE_100

1454: , p5_a39 JTF_DATE_TABLE
1455: , p5_a40 JTF_NUMBER_TABLE
1456: , p5_a41 JTF_DATE_TABLE
1457: , p5_a42 JTF_NUMBER_TABLE
1458: , p5_a43 JTF_VARCHAR2_TABLE_100
1459: , p5_a44 JTF_NUMBER_TABLE
1460: , p5_a45 JTF_VARCHAR2_TABLE_100
1461: , p5_a46 JTF_VARCHAR2_TABLE_100
1462: )

Line 1460: , p5_a45 JTF_VARCHAR2_TABLE_100

1456: , p5_a41 JTF_DATE_TABLE
1457: , p5_a42 JTF_NUMBER_TABLE
1458: , p5_a43 JTF_VARCHAR2_TABLE_100
1459: , p5_a44 JTF_NUMBER_TABLE
1460: , p5_a45 JTF_VARCHAR2_TABLE_100
1461: , p5_a46 JTF_VARCHAR2_TABLE_100
1462: )
1463:
1464: as

Line 1461: , p5_a46 JTF_VARCHAR2_TABLE_100

1457: , p5_a42 JTF_NUMBER_TABLE
1458: , p5_a43 JTF_VARCHAR2_TABLE_100
1459: , p5_a44 JTF_NUMBER_TABLE
1460: , p5_a45 JTF_VARCHAR2_TABLE_100
1461: , p5_a46 JTF_VARCHAR2_TABLE_100
1462: )
1463:
1464: as
1465: ddp_rctv_tbl okl_rct_pvt.rctv_tbl_type;

Line 1774: , p5_a2 JTF_VARCHAR2_TABLE_100

1770: , x_msg_count out nocopy NUMBER
1771: , x_msg_data out nocopy VARCHAR2
1772: , p5_a0 JTF_NUMBER_TABLE
1773: , p5_a1 JTF_NUMBER_TABLE
1774: , p5_a2 JTF_VARCHAR2_TABLE_100
1775: , p5_a3 JTF_NUMBER_TABLE
1776: , p5_a4 JTF_NUMBER_TABLE
1777: , p5_a5 JTF_DATE_TABLE
1778: , p5_a6 JTF_NUMBER_TABLE

Line 1780: , p5_a8 JTF_VARCHAR2_TABLE_100

1776: , p5_a4 JTF_NUMBER_TABLE
1777: , p5_a5 JTF_DATE_TABLE
1778: , p5_a6 JTF_NUMBER_TABLE
1779: , p5_a7 JTF_NUMBER_TABLE
1780: , p5_a8 JTF_VARCHAR2_TABLE_100
1781: , p5_a9 JTF_VARCHAR2_TABLE_100
1782: , p5_a10 JTF_VARCHAR2_TABLE_100
1783: , p5_a11 JTF_DATE_TABLE
1784: , p5_a12 JTF_NUMBER_TABLE

Line 1781: , p5_a9 JTF_VARCHAR2_TABLE_100

1777: , p5_a5 JTF_DATE_TABLE
1778: , p5_a6 JTF_NUMBER_TABLE
1779: , p5_a7 JTF_NUMBER_TABLE
1780: , p5_a8 JTF_VARCHAR2_TABLE_100
1781: , p5_a9 JTF_VARCHAR2_TABLE_100
1782: , p5_a10 JTF_VARCHAR2_TABLE_100
1783: , p5_a11 JTF_DATE_TABLE
1784: , p5_a12 JTF_NUMBER_TABLE
1785: , p5_a13 JTF_NUMBER_TABLE

Line 1782: , p5_a10 JTF_VARCHAR2_TABLE_100

1778: , p5_a6 JTF_NUMBER_TABLE
1779: , p5_a7 JTF_NUMBER_TABLE
1780: , p5_a8 JTF_VARCHAR2_TABLE_100
1781: , p5_a9 JTF_VARCHAR2_TABLE_100
1782: , p5_a10 JTF_VARCHAR2_TABLE_100
1783: , p5_a11 JTF_DATE_TABLE
1784: , p5_a12 JTF_NUMBER_TABLE
1785: , p5_a13 JTF_NUMBER_TABLE
1786: , p5_a14 JTF_DATE_TABLE

Line 1787: , p5_a15 JTF_VARCHAR2_TABLE_100

1783: , p5_a11 JTF_DATE_TABLE
1784: , p5_a12 JTF_NUMBER_TABLE
1785: , p5_a13 JTF_NUMBER_TABLE
1786: , p5_a14 JTF_DATE_TABLE
1787: , p5_a15 JTF_VARCHAR2_TABLE_100
1788: , p5_a16 JTF_VARCHAR2_TABLE_2000
1789: , p5_a17 JTF_VARCHAR2_TABLE_100
1790: , p5_a18 JTF_VARCHAR2_TABLE_500
1791: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 1789: , p5_a17 JTF_VARCHAR2_TABLE_100

1785: , p5_a13 JTF_NUMBER_TABLE
1786: , p5_a14 JTF_DATE_TABLE
1787: , p5_a15 JTF_VARCHAR2_TABLE_100
1788: , p5_a16 JTF_VARCHAR2_TABLE_2000
1789: , p5_a17 JTF_VARCHAR2_TABLE_100
1790: , p5_a18 JTF_VARCHAR2_TABLE_500
1791: , p5_a19 JTF_VARCHAR2_TABLE_500
1792: , p5_a20 JTF_VARCHAR2_TABLE_500
1793: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 1815: , p5_a43 JTF_VARCHAR2_TABLE_100

1811: , p5_a39 JTF_DATE_TABLE
1812: , p5_a40 JTF_NUMBER_TABLE
1813: , p5_a41 JTF_DATE_TABLE
1814: , p5_a42 JTF_NUMBER_TABLE
1815: , p5_a43 JTF_VARCHAR2_TABLE_100
1816: , p5_a44 JTF_NUMBER_TABLE
1817: , p5_a45 JTF_VARCHAR2_TABLE_100
1818: , p5_a46 JTF_VARCHAR2_TABLE_100
1819: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 1817: , p5_a45 JTF_VARCHAR2_TABLE_100

1813: , p5_a41 JTF_DATE_TABLE
1814: , p5_a42 JTF_NUMBER_TABLE
1815: , p5_a43 JTF_VARCHAR2_TABLE_100
1816: , p5_a44 JTF_NUMBER_TABLE
1817: , p5_a45 JTF_VARCHAR2_TABLE_100
1818: , p5_a46 JTF_VARCHAR2_TABLE_100
1819: , p6_a0 out nocopy JTF_NUMBER_TABLE
1820: , p6_a1 out nocopy JTF_NUMBER_TABLE
1821: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 1818: , p5_a46 JTF_VARCHAR2_TABLE_100

1814: , p5_a42 JTF_NUMBER_TABLE
1815: , p5_a43 JTF_VARCHAR2_TABLE_100
1816: , p5_a44 JTF_NUMBER_TABLE
1817: , p5_a45 JTF_VARCHAR2_TABLE_100
1818: , p5_a46 JTF_VARCHAR2_TABLE_100
1819: , p6_a0 out nocopy JTF_NUMBER_TABLE
1820: , p6_a1 out nocopy JTF_NUMBER_TABLE
1821: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1822: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 1821: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

1817: , p5_a45 JTF_VARCHAR2_TABLE_100
1818: , p5_a46 JTF_VARCHAR2_TABLE_100
1819: , p6_a0 out nocopy JTF_NUMBER_TABLE
1820: , p6_a1 out nocopy JTF_NUMBER_TABLE
1821: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1822: , p6_a3 out nocopy JTF_NUMBER_TABLE
1823: , p6_a4 out nocopy JTF_NUMBER_TABLE
1824: , p6_a5 out nocopy JTF_DATE_TABLE
1825: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 1827: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

1823: , p6_a4 out nocopy JTF_NUMBER_TABLE
1824: , p6_a5 out nocopy JTF_DATE_TABLE
1825: , p6_a6 out nocopy JTF_NUMBER_TABLE
1826: , p6_a7 out nocopy JTF_NUMBER_TABLE
1827: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1828: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1829: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1830: , p6_a11 out nocopy JTF_DATE_TABLE
1831: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 1828: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

1824: , p6_a5 out nocopy JTF_DATE_TABLE
1825: , p6_a6 out nocopy JTF_NUMBER_TABLE
1826: , p6_a7 out nocopy JTF_NUMBER_TABLE
1827: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1828: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1829: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1830: , p6_a11 out nocopy JTF_DATE_TABLE
1831: , p6_a12 out nocopy JTF_NUMBER_TABLE
1832: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 1829: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

1825: , p6_a6 out nocopy JTF_NUMBER_TABLE
1826: , p6_a7 out nocopy JTF_NUMBER_TABLE
1827: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1828: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1829: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1830: , p6_a11 out nocopy JTF_DATE_TABLE
1831: , p6_a12 out nocopy JTF_NUMBER_TABLE
1832: , p6_a13 out nocopy JTF_NUMBER_TABLE
1833: , p6_a14 out nocopy JTF_DATE_TABLE

Line 1834: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

1830: , p6_a11 out nocopy JTF_DATE_TABLE
1831: , p6_a12 out nocopy JTF_NUMBER_TABLE
1832: , p6_a13 out nocopy JTF_NUMBER_TABLE
1833: , p6_a14 out nocopy JTF_DATE_TABLE
1834: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1835: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
1836: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1837: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1838: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 1836: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

1832: , p6_a13 out nocopy JTF_NUMBER_TABLE
1833: , p6_a14 out nocopy JTF_DATE_TABLE
1834: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1835: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
1836: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1837: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1838: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1839: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1840: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 1862: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100

1858: , p6_a39 out nocopy JTF_DATE_TABLE
1859: , p6_a40 out nocopy JTF_NUMBER_TABLE
1860: , p6_a41 out nocopy JTF_DATE_TABLE
1861: , p6_a42 out nocopy JTF_NUMBER_TABLE
1862: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1863: , p6_a44 out nocopy JTF_NUMBER_TABLE
1864: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
1865: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
1866: )

Line 1864: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100

1860: , p6_a41 out nocopy JTF_DATE_TABLE
1861: , p6_a42 out nocopy JTF_NUMBER_TABLE
1862: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1863: , p6_a44 out nocopy JTF_NUMBER_TABLE
1864: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
1865: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
1866: )
1867:
1868: as

Line 1865: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100

1861: , p6_a42 out nocopy JTF_NUMBER_TABLE
1862: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1863: , p6_a44 out nocopy JTF_NUMBER_TABLE
1864: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
1865: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
1866: )
1867:
1868: as
1869: ddp_rctv_tbl okl_rct_pvt.rctv_tbl_type;

Line 2132: , p5_a2 JTF_VARCHAR2_TABLE_100

2128: , x_msg_count out nocopy NUMBER
2129: , x_msg_data out nocopy VARCHAR2
2130: , p5_a0 JTF_NUMBER_TABLE
2131: , p5_a1 JTF_NUMBER_TABLE
2132: , p5_a2 JTF_VARCHAR2_TABLE_100
2133: , p5_a3 JTF_NUMBER_TABLE
2134: , p5_a4 JTF_NUMBER_TABLE
2135: , p5_a5 JTF_DATE_TABLE
2136: , p5_a6 JTF_NUMBER_TABLE

Line 2138: , p5_a8 JTF_VARCHAR2_TABLE_100

2134: , p5_a4 JTF_NUMBER_TABLE
2135: , p5_a5 JTF_DATE_TABLE
2136: , p5_a6 JTF_NUMBER_TABLE
2137: , p5_a7 JTF_NUMBER_TABLE
2138: , p5_a8 JTF_VARCHAR2_TABLE_100
2139: , p5_a9 JTF_VARCHAR2_TABLE_100
2140: , p5_a10 JTF_VARCHAR2_TABLE_100
2141: , p5_a11 JTF_DATE_TABLE
2142: , p5_a12 JTF_NUMBER_TABLE

Line 2139: , p5_a9 JTF_VARCHAR2_TABLE_100

2135: , p5_a5 JTF_DATE_TABLE
2136: , p5_a6 JTF_NUMBER_TABLE
2137: , p5_a7 JTF_NUMBER_TABLE
2138: , p5_a8 JTF_VARCHAR2_TABLE_100
2139: , p5_a9 JTF_VARCHAR2_TABLE_100
2140: , p5_a10 JTF_VARCHAR2_TABLE_100
2141: , p5_a11 JTF_DATE_TABLE
2142: , p5_a12 JTF_NUMBER_TABLE
2143: , p5_a13 JTF_NUMBER_TABLE

Line 2140: , p5_a10 JTF_VARCHAR2_TABLE_100

2136: , p5_a6 JTF_NUMBER_TABLE
2137: , p5_a7 JTF_NUMBER_TABLE
2138: , p5_a8 JTF_VARCHAR2_TABLE_100
2139: , p5_a9 JTF_VARCHAR2_TABLE_100
2140: , p5_a10 JTF_VARCHAR2_TABLE_100
2141: , p5_a11 JTF_DATE_TABLE
2142: , p5_a12 JTF_NUMBER_TABLE
2143: , p5_a13 JTF_NUMBER_TABLE
2144: , p5_a14 JTF_DATE_TABLE

Line 2145: , p5_a15 JTF_VARCHAR2_TABLE_100

2141: , p5_a11 JTF_DATE_TABLE
2142: , p5_a12 JTF_NUMBER_TABLE
2143: , p5_a13 JTF_NUMBER_TABLE
2144: , p5_a14 JTF_DATE_TABLE
2145: , p5_a15 JTF_VARCHAR2_TABLE_100
2146: , p5_a16 JTF_VARCHAR2_TABLE_2000
2147: , p5_a17 JTF_VARCHAR2_TABLE_100
2148: , p5_a18 JTF_VARCHAR2_TABLE_500
2149: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 2147: , p5_a17 JTF_VARCHAR2_TABLE_100

2143: , p5_a13 JTF_NUMBER_TABLE
2144: , p5_a14 JTF_DATE_TABLE
2145: , p5_a15 JTF_VARCHAR2_TABLE_100
2146: , p5_a16 JTF_VARCHAR2_TABLE_2000
2147: , p5_a17 JTF_VARCHAR2_TABLE_100
2148: , p5_a18 JTF_VARCHAR2_TABLE_500
2149: , p5_a19 JTF_VARCHAR2_TABLE_500
2150: , p5_a20 JTF_VARCHAR2_TABLE_500
2151: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 2173: , p5_a43 JTF_VARCHAR2_TABLE_100

2169: , p5_a39 JTF_DATE_TABLE
2170: , p5_a40 JTF_NUMBER_TABLE
2171: , p5_a41 JTF_DATE_TABLE
2172: , p5_a42 JTF_NUMBER_TABLE
2173: , p5_a43 JTF_VARCHAR2_TABLE_100
2174: , p5_a44 JTF_NUMBER_TABLE
2175: , p5_a45 JTF_VARCHAR2_TABLE_100
2176: , p5_a46 JTF_VARCHAR2_TABLE_100
2177: )

Line 2175: , p5_a45 JTF_VARCHAR2_TABLE_100

2171: , p5_a41 JTF_DATE_TABLE
2172: , p5_a42 JTF_NUMBER_TABLE
2173: , p5_a43 JTF_VARCHAR2_TABLE_100
2174: , p5_a44 JTF_NUMBER_TABLE
2175: , p5_a45 JTF_VARCHAR2_TABLE_100
2176: , p5_a46 JTF_VARCHAR2_TABLE_100
2177: )
2178:
2179: as

Line 2176: , p5_a46 JTF_VARCHAR2_TABLE_100

2172: , p5_a42 JTF_NUMBER_TABLE
2173: , p5_a43 JTF_VARCHAR2_TABLE_100
2174: , p5_a44 JTF_NUMBER_TABLE
2175: , p5_a45 JTF_VARCHAR2_TABLE_100
2176: , p5_a46 JTF_VARCHAR2_TABLE_100
2177: )
2178:
2179: as
2180: ddp_rctv_tbl okl_rct_pvt.rctv_tbl_type;

Line 2391: , p5_a2 JTF_VARCHAR2_TABLE_100

2387: , x_msg_count out nocopy NUMBER
2388: , x_msg_data out nocopy VARCHAR2
2389: , p5_a0 JTF_NUMBER_TABLE
2390: , p5_a1 JTF_NUMBER_TABLE
2391: , p5_a2 JTF_VARCHAR2_TABLE_100
2392: , p5_a3 JTF_NUMBER_TABLE
2393: , p5_a4 JTF_NUMBER_TABLE
2394: , p5_a5 JTF_DATE_TABLE
2395: , p5_a6 JTF_NUMBER_TABLE

Line 2397: , p5_a8 JTF_VARCHAR2_TABLE_100

2393: , p5_a4 JTF_NUMBER_TABLE
2394: , p5_a5 JTF_DATE_TABLE
2395: , p5_a6 JTF_NUMBER_TABLE
2396: , p5_a7 JTF_NUMBER_TABLE
2397: , p5_a8 JTF_VARCHAR2_TABLE_100
2398: , p5_a9 JTF_VARCHAR2_TABLE_100
2399: , p5_a10 JTF_VARCHAR2_TABLE_100
2400: , p5_a11 JTF_DATE_TABLE
2401: , p5_a12 JTF_NUMBER_TABLE

Line 2398: , p5_a9 JTF_VARCHAR2_TABLE_100

2394: , p5_a5 JTF_DATE_TABLE
2395: , p5_a6 JTF_NUMBER_TABLE
2396: , p5_a7 JTF_NUMBER_TABLE
2397: , p5_a8 JTF_VARCHAR2_TABLE_100
2398: , p5_a9 JTF_VARCHAR2_TABLE_100
2399: , p5_a10 JTF_VARCHAR2_TABLE_100
2400: , p5_a11 JTF_DATE_TABLE
2401: , p5_a12 JTF_NUMBER_TABLE
2402: , p5_a13 JTF_NUMBER_TABLE

Line 2399: , p5_a10 JTF_VARCHAR2_TABLE_100

2395: , p5_a6 JTF_NUMBER_TABLE
2396: , p5_a7 JTF_NUMBER_TABLE
2397: , p5_a8 JTF_VARCHAR2_TABLE_100
2398: , p5_a9 JTF_VARCHAR2_TABLE_100
2399: , p5_a10 JTF_VARCHAR2_TABLE_100
2400: , p5_a11 JTF_DATE_TABLE
2401: , p5_a12 JTF_NUMBER_TABLE
2402: , p5_a13 JTF_NUMBER_TABLE
2403: , p5_a14 JTF_DATE_TABLE

Line 2404: , p5_a15 JTF_VARCHAR2_TABLE_100

2400: , p5_a11 JTF_DATE_TABLE
2401: , p5_a12 JTF_NUMBER_TABLE
2402: , p5_a13 JTF_NUMBER_TABLE
2403: , p5_a14 JTF_DATE_TABLE
2404: , p5_a15 JTF_VARCHAR2_TABLE_100
2405: , p5_a16 JTF_VARCHAR2_TABLE_2000
2406: , p5_a17 JTF_VARCHAR2_TABLE_100
2407: , p5_a18 JTF_VARCHAR2_TABLE_500
2408: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 2406: , p5_a17 JTF_VARCHAR2_TABLE_100

2402: , p5_a13 JTF_NUMBER_TABLE
2403: , p5_a14 JTF_DATE_TABLE
2404: , p5_a15 JTF_VARCHAR2_TABLE_100
2405: , p5_a16 JTF_VARCHAR2_TABLE_2000
2406: , p5_a17 JTF_VARCHAR2_TABLE_100
2407: , p5_a18 JTF_VARCHAR2_TABLE_500
2408: , p5_a19 JTF_VARCHAR2_TABLE_500
2409: , p5_a20 JTF_VARCHAR2_TABLE_500
2410: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 2432: , p5_a43 JTF_VARCHAR2_TABLE_100

2428: , p5_a39 JTF_DATE_TABLE
2429: , p5_a40 JTF_NUMBER_TABLE
2430: , p5_a41 JTF_DATE_TABLE
2431: , p5_a42 JTF_NUMBER_TABLE
2432: , p5_a43 JTF_VARCHAR2_TABLE_100
2433: , p5_a44 JTF_NUMBER_TABLE
2434: , p5_a45 JTF_VARCHAR2_TABLE_100
2435: , p5_a46 JTF_VARCHAR2_TABLE_100
2436: )

Line 2434: , p5_a45 JTF_VARCHAR2_TABLE_100

2430: , p5_a41 JTF_DATE_TABLE
2431: , p5_a42 JTF_NUMBER_TABLE
2432: , p5_a43 JTF_VARCHAR2_TABLE_100
2433: , p5_a44 JTF_NUMBER_TABLE
2434: , p5_a45 JTF_VARCHAR2_TABLE_100
2435: , p5_a46 JTF_VARCHAR2_TABLE_100
2436: )
2437:
2438: as

Line 2435: , p5_a46 JTF_VARCHAR2_TABLE_100

2431: , p5_a42 JTF_NUMBER_TABLE
2432: , p5_a43 JTF_VARCHAR2_TABLE_100
2433: , p5_a44 JTF_NUMBER_TABLE
2434: , p5_a45 JTF_VARCHAR2_TABLE_100
2435: , p5_a46 JTF_VARCHAR2_TABLE_100
2436: )
2437:
2438: as
2439: ddp_rctv_tbl okl_rct_pvt.rctv_tbl_type;