DBA Data[Home] [Help]

APPS.OKL_RGRP_RULES_PROCESS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 23: , a1 JTF_NUMBER_TABLE

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

Line 24: , a2 JTF_NUMBER_TABLE

20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100

Line 35: , a13 JTF_NUMBER_TABLE

31: , a9 JTF_VARCHAR2_TABLE_200
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_2000

Line 36: , a14 JTF_NUMBER_TABLE

32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_2000
40: , a18 JTF_VARCHAR2_TABLE_100

Line 37: , a15 JTF_NUMBER_TABLE

33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_2000
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100

Line 57: , a35 JTF_NUMBER_TABLE

53: , a31 JTF_VARCHAR2_TABLE_500
54: , a32 JTF_VARCHAR2_TABLE_500
55: , a33 JTF_VARCHAR2_TABLE_500
56: , a34 JTF_VARCHAR2_TABLE_500
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_DATE_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_DATE_TABLE
61: , a39 JTF_NUMBER_TABLE

Line 59: , a37 JTF_NUMBER_TABLE

55: , a33 JTF_VARCHAR2_TABLE_500
56: , a34 JTF_VARCHAR2_TABLE_500
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_DATE_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_DATE_TABLE
61: , a39 JTF_NUMBER_TABLE
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_VARCHAR2_TABLE_500

Line 61: , a39 JTF_NUMBER_TABLE

57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_DATE_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_DATE_TABLE
61: , a39 JTF_NUMBER_TABLE
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_VARCHAR2_TABLE_500
64: , a42 JTF_VARCHAR2_TABLE_500
65: , a43 JTF_VARCHAR2_TABLE_500

Line 82: , a60 JTF_NUMBER_TABLE

78: , a56 JTF_VARCHAR2_TABLE_100
79: , a57 JTF_VARCHAR2_TABLE_100
80: , a58 JTF_VARCHAR2_TABLE_100
81: , a59 JTF_VARCHAR2_TABLE_100
82: , a60 JTF_NUMBER_TABLE
83: ) as
84: ddindx binary_integer; indx binary_integer;
85: begin
86: if a0 is not null and a0.count > 0 then

Line 162: , a1 out nocopy JTF_NUMBER_TABLE

158: end if;
159: end if;
160: end rosetta_table_copy_in_p2;
161: procedure rosetta_table_copy_out_p2(t okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
162: , a1 out nocopy JTF_NUMBER_TABLE
163: , a2 out nocopy JTF_NUMBER_TABLE
164: , a3 out nocopy JTF_VARCHAR2_TABLE_100
165: , a4 out nocopy JTF_VARCHAR2_TABLE_100
166: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 163: , a2 out nocopy JTF_NUMBER_TABLE

159: end if;
160: end rosetta_table_copy_in_p2;
161: procedure rosetta_table_copy_out_p2(t okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
162: , a1 out nocopy JTF_NUMBER_TABLE
163: , a2 out nocopy JTF_NUMBER_TABLE
164: , a3 out nocopy JTF_VARCHAR2_TABLE_100
165: , a4 out nocopy JTF_VARCHAR2_TABLE_100
166: , a5 out nocopy JTF_VARCHAR2_TABLE_100
167: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 174: , a13 out nocopy JTF_NUMBER_TABLE

170: , a9 out nocopy JTF_VARCHAR2_TABLE_200
171: , a10 out nocopy JTF_VARCHAR2_TABLE_100
172: , a11 out nocopy JTF_VARCHAR2_TABLE_100
173: , a12 out nocopy JTF_VARCHAR2_TABLE_100
174: , a13 out nocopy JTF_NUMBER_TABLE
175: , a14 out nocopy JTF_NUMBER_TABLE
176: , a15 out nocopy JTF_NUMBER_TABLE
177: , a16 out nocopy JTF_VARCHAR2_TABLE_100
178: , a17 out nocopy JTF_VARCHAR2_TABLE_2000

Line 175: , a14 out nocopy JTF_NUMBER_TABLE

171: , a10 out nocopy JTF_VARCHAR2_TABLE_100
172: , a11 out nocopy JTF_VARCHAR2_TABLE_100
173: , a12 out nocopy JTF_VARCHAR2_TABLE_100
174: , a13 out nocopy JTF_NUMBER_TABLE
175: , a14 out nocopy JTF_NUMBER_TABLE
176: , a15 out nocopy JTF_NUMBER_TABLE
177: , a16 out nocopy JTF_VARCHAR2_TABLE_100
178: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
179: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 176: , a15 out nocopy JTF_NUMBER_TABLE

172: , a11 out nocopy JTF_VARCHAR2_TABLE_100
173: , a12 out nocopy JTF_VARCHAR2_TABLE_100
174: , a13 out nocopy JTF_NUMBER_TABLE
175: , a14 out nocopy JTF_NUMBER_TABLE
176: , a15 out nocopy JTF_NUMBER_TABLE
177: , a16 out nocopy JTF_VARCHAR2_TABLE_100
178: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
179: , a18 out nocopy JTF_VARCHAR2_TABLE_100
180: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 196: , a35 out nocopy JTF_NUMBER_TABLE

192: , a31 out nocopy JTF_VARCHAR2_TABLE_500
193: , a32 out nocopy JTF_VARCHAR2_TABLE_500
194: , a33 out nocopy JTF_VARCHAR2_TABLE_500
195: , a34 out nocopy JTF_VARCHAR2_TABLE_500
196: , a35 out nocopy JTF_NUMBER_TABLE
197: , a36 out nocopy JTF_DATE_TABLE
198: , a37 out nocopy JTF_NUMBER_TABLE
199: , a38 out nocopy JTF_DATE_TABLE
200: , a39 out nocopy JTF_NUMBER_TABLE

Line 198: , a37 out nocopy JTF_NUMBER_TABLE

194: , a33 out nocopy JTF_VARCHAR2_TABLE_500
195: , a34 out nocopy JTF_VARCHAR2_TABLE_500
196: , a35 out nocopy JTF_NUMBER_TABLE
197: , a36 out nocopy JTF_DATE_TABLE
198: , a37 out nocopy JTF_NUMBER_TABLE
199: , a38 out nocopy JTF_DATE_TABLE
200: , a39 out nocopy JTF_NUMBER_TABLE
201: , a40 out nocopy JTF_VARCHAR2_TABLE_100
202: , a41 out nocopy JTF_VARCHAR2_TABLE_500

Line 200: , a39 out nocopy JTF_NUMBER_TABLE

196: , a35 out nocopy JTF_NUMBER_TABLE
197: , a36 out nocopy JTF_DATE_TABLE
198: , a37 out nocopy JTF_NUMBER_TABLE
199: , a38 out nocopy JTF_DATE_TABLE
200: , a39 out nocopy JTF_NUMBER_TABLE
201: , a40 out nocopy JTF_VARCHAR2_TABLE_100
202: , a41 out nocopy JTF_VARCHAR2_TABLE_500
203: , a42 out nocopy JTF_VARCHAR2_TABLE_500
204: , a43 out nocopy JTF_VARCHAR2_TABLE_500

Line 221: , a60 out nocopy JTF_NUMBER_TABLE

217: , a56 out nocopy JTF_VARCHAR2_TABLE_100
218: , a57 out nocopy JTF_VARCHAR2_TABLE_100
219: , a58 out nocopy JTF_VARCHAR2_TABLE_100
220: , a59 out nocopy JTF_VARCHAR2_TABLE_100
221: , a60 out nocopy JTF_NUMBER_TABLE
222: ) as
223: ddindx binary_integer; indx binary_integer;
224: begin
225: if t is null or t.count = 0 then

Line 227: a1 := JTF_NUMBER_TABLE();

223: ddindx binary_integer; indx binary_integer;
224: begin
225: if t is null or t.count = 0 then
226: a0 := JTF_VARCHAR2_TABLE_100();
227: a1 := JTF_NUMBER_TABLE();
228: a2 := JTF_NUMBER_TABLE();
229: a3 := JTF_VARCHAR2_TABLE_100();
230: a4 := JTF_VARCHAR2_TABLE_100();
231: a5 := JTF_VARCHAR2_TABLE_100();

Line 228: a2 := JTF_NUMBER_TABLE();

224: begin
225: if t is null or t.count = 0 then
226: a0 := JTF_VARCHAR2_TABLE_100();
227: a1 := JTF_NUMBER_TABLE();
228: a2 := JTF_NUMBER_TABLE();
229: a3 := JTF_VARCHAR2_TABLE_100();
230: a4 := JTF_VARCHAR2_TABLE_100();
231: a5 := JTF_VARCHAR2_TABLE_100();
232: a6 := JTF_VARCHAR2_TABLE_100();

Line 239: a13 := JTF_NUMBER_TABLE();

235: a9 := JTF_VARCHAR2_TABLE_200();
236: a10 := JTF_VARCHAR2_TABLE_100();
237: a11 := JTF_VARCHAR2_TABLE_100();
238: a12 := JTF_VARCHAR2_TABLE_100();
239: a13 := JTF_NUMBER_TABLE();
240: a14 := JTF_NUMBER_TABLE();
241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_VARCHAR2_TABLE_100();
243: a17 := JTF_VARCHAR2_TABLE_2000();

Line 240: a14 := JTF_NUMBER_TABLE();

236: a10 := JTF_VARCHAR2_TABLE_100();
237: a11 := JTF_VARCHAR2_TABLE_100();
238: a12 := JTF_VARCHAR2_TABLE_100();
239: a13 := JTF_NUMBER_TABLE();
240: a14 := JTF_NUMBER_TABLE();
241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_VARCHAR2_TABLE_100();
243: a17 := JTF_VARCHAR2_TABLE_2000();
244: a18 := JTF_VARCHAR2_TABLE_100();

Line 241: a15 := JTF_NUMBER_TABLE();

237: a11 := JTF_VARCHAR2_TABLE_100();
238: a12 := JTF_VARCHAR2_TABLE_100();
239: a13 := JTF_NUMBER_TABLE();
240: a14 := JTF_NUMBER_TABLE();
241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_VARCHAR2_TABLE_100();
243: a17 := JTF_VARCHAR2_TABLE_2000();
244: a18 := JTF_VARCHAR2_TABLE_100();
245: a19 := JTF_VARCHAR2_TABLE_100();

Line 261: a35 := JTF_NUMBER_TABLE();

257: a31 := JTF_VARCHAR2_TABLE_500();
258: a32 := JTF_VARCHAR2_TABLE_500();
259: a33 := JTF_VARCHAR2_TABLE_500();
260: a34 := JTF_VARCHAR2_TABLE_500();
261: a35 := JTF_NUMBER_TABLE();
262: a36 := JTF_DATE_TABLE();
263: a37 := JTF_NUMBER_TABLE();
264: a38 := JTF_DATE_TABLE();
265: a39 := JTF_NUMBER_TABLE();

Line 263: a37 := JTF_NUMBER_TABLE();

259: a33 := JTF_VARCHAR2_TABLE_500();
260: a34 := JTF_VARCHAR2_TABLE_500();
261: a35 := JTF_NUMBER_TABLE();
262: a36 := JTF_DATE_TABLE();
263: a37 := JTF_NUMBER_TABLE();
264: a38 := JTF_DATE_TABLE();
265: a39 := JTF_NUMBER_TABLE();
266: a40 := JTF_VARCHAR2_TABLE_100();
267: a41 := JTF_VARCHAR2_TABLE_500();

Line 265: a39 := JTF_NUMBER_TABLE();

261: a35 := JTF_NUMBER_TABLE();
262: a36 := JTF_DATE_TABLE();
263: a37 := JTF_NUMBER_TABLE();
264: a38 := JTF_DATE_TABLE();
265: a39 := JTF_NUMBER_TABLE();
266: a40 := JTF_VARCHAR2_TABLE_100();
267: a41 := JTF_VARCHAR2_TABLE_500();
268: a42 := JTF_VARCHAR2_TABLE_500();
269: a43 := JTF_VARCHAR2_TABLE_500();

Line 286: a60 := JTF_NUMBER_TABLE();

282: a56 := JTF_VARCHAR2_TABLE_100();
283: a57 := JTF_VARCHAR2_TABLE_100();
284: a58 := JTF_VARCHAR2_TABLE_100();
285: a59 := JTF_VARCHAR2_TABLE_100();
286: a60 := JTF_NUMBER_TABLE();
287: else
288: a0 := JTF_VARCHAR2_TABLE_100();
289: a1 := JTF_NUMBER_TABLE();
290: a2 := JTF_NUMBER_TABLE();

Line 289: a1 := JTF_NUMBER_TABLE();

285: a59 := JTF_VARCHAR2_TABLE_100();
286: a60 := JTF_NUMBER_TABLE();
287: else
288: a0 := JTF_VARCHAR2_TABLE_100();
289: a1 := JTF_NUMBER_TABLE();
290: a2 := JTF_NUMBER_TABLE();
291: a3 := JTF_VARCHAR2_TABLE_100();
292: a4 := JTF_VARCHAR2_TABLE_100();
293: a5 := JTF_VARCHAR2_TABLE_100();

Line 290: a2 := JTF_NUMBER_TABLE();

286: a60 := JTF_NUMBER_TABLE();
287: else
288: a0 := JTF_VARCHAR2_TABLE_100();
289: a1 := JTF_NUMBER_TABLE();
290: a2 := JTF_NUMBER_TABLE();
291: a3 := JTF_VARCHAR2_TABLE_100();
292: a4 := JTF_VARCHAR2_TABLE_100();
293: a5 := JTF_VARCHAR2_TABLE_100();
294: a6 := JTF_VARCHAR2_TABLE_100();

Line 301: a13 := JTF_NUMBER_TABLE();

297: a9 := JTF_VARCHAR2_TABLE_200();
298: a10 := JTF_VARCHAR2_TABLE_100();
299: a11 := JTF_VARCHAR2_TABLE_100();
300: a12 := JTF_VARCHAR2_TABLE_100();
301: a13 := JTF_NUMBER_TABLE();
302: a14 := JTF_NUMBER_TABLE();
303: a15 := JTF_NUMBER_TABLE();
304: a16 := JTF_VARCHAR2_TABLE_100();
305: a17 := JTF_VARCHAR2_TABLE_2000();

Line 302: a14 := JTF_NUMBER_TABLE();

298: a10 := JTF_VARCHAR2_TABLE_100();
299: a11 := JTF_VARCHAR2_TABLE_100();
300: a12 := JTF_VARCHAR2_TABLE_100();
301: a13 := JTF_NUMBER_TABLE();
302: a14 := JTF_NUMBER_TABLE();
303: a15 := JTF_NUMBER_TABLE();
304: a16 := JTF_VARCHAR2_TABLE_100();
305: a17 := JTF_VARCHAR2_TABLE_2000();
306: a18 := JTF_VARCHAR2_TABLE_100();

Line 303: a15 := JTF_NUMBER_TABLE();

299: a11 := JTF_VARCHAR2_TABLE_100();
300: a12 := JTF_VARCHAR2_TABLE_100();
301: a13 := JTF_NUMBER_TABLE();
302: a14 := JTF_NUMBER_TABLE();
303: a15 := JTF_NUMBER_TABLE();
304: a16 := JTF_VARCHAR2_TABLE_100();
305: a17 := JTF_VARCHAR2_TABLE_2000();
306: a18 := JTF_VARCHAR2_TABLE_100();
307: a19 := JTF_VARCHAR2_TABLE_100();

Line 323: a35 := JTF_NUMBER_TABLE();

319: a31 := JTF_VARCHAR2_TABLE_500();
320: a32 := JTF_VARCHAR2_TABLE_500();
321: a33 := JTF_VARCHAR2_TABLE_500();
322: a34 := JTF_VARCHAR2_TABLE_500();
323: a35 := JTF_NUMBER_TABLE();
324: a36 := JTF_DATE_TABLE();
325: a37 := JTF_NUMBER_TABLE();
326: a38 := JTF_DATE_TABLE();
327: a39 := JTF_NUMBER_TABLE();

Line 325: a37 := JTF_NUMBER_TABLE();

321: a33 := JTF_VARCHAR2_TABLE_500();
322: a34 := JTF_VARCHAR2_TABLE_500();
323: a35 := JTF_NUMBER_TABLE();
324: a36 := JTF_DATE_TABLE();
325: a37 := JTF_NUMBER_TABLE();
326: a38 := JTF_DATE_TABLE();
327: a39 := JTF_NUMBER_TABLE();
328: a40 := JTF_VARCHAR2_TABLE_100();
329: a41 := JTF_VARCHAR2_TABLE_500();

Line 327: a39 := JTF_NUMBER_TABLE();

323: a35 := JTF_NUMBER_TABLE();
324: a36 := JTF_DATE_TABLE();
325: a37 := JTF_NUMBER_TABLE();
326: a38 := JTF_DATE_TABLE();
327: a39 := JTF_NUMBER_TABLE();
328: a40 := JTF_VARCHAR2_TABLE_100();
329: a41 := JTF_VARCHAR2_TABLE_500();
330: a42 := JTF_VARCHAR2_TABLE_500();
331: a43 := JTF_VARCHAR2_TABLE_500();

Line 348: a60 := JTF_NUMBER_TABLE();

344: a56 := JTF_VARCHAR2_TABLE_100();
345: a57 := JTF_VARCHAR2_TABLE_100();
346: a58 := JTF_VARCHAR2_TABLE_100();
347: a59 := JTF_VARCHAR2_TABLE_100();
348: a60 := JTF_NUMBER_TABLE();
349: if t.count > 0 then
350: a0.extend(t.count);
351: a1.extend(t.count);
352: a2.extend(t.count);

Line 485: procedure rosetta_table_copy_in_p3(t out nocopy okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 JTF_NUMBER_TABLE

481: end if;
482: end if;
483: end rosetta_table_copy_out_p2;
484:
485: procedure rosetta_table_copy_in_p3(t out nocopy okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 JTF_NUMBER_TABLE
486: , a1 JTF_VARCHAR2_TABLE_100
487: , a2 JTF_VARCHAR2_TABLE_100
488: , a3 JTF_VARCHAR2_TABLE_100
489: ) as

Line 510: procedure rosetta_table_copy_out_p3(t okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

506: end loop;
507: end if;
508: end if;
509: end rosetta_table_copy_in_p3;
510: procedure rosetta_table_copy_out_p3(t okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
511: , a1 out nocopy JTF_VARCHAR2_TABLE_100
512: , a2 out nocopy JTF_VARCHAR2_TABLE_100
513: , a3 out nocopy JTF_VARCHAR2_TABLE_100
514: ) as

Line 518: a0 := JTF_NUMBER_TABLE();

514: ) as
515: ddindx binary_integer; indx binary_integer;
516: begin
517: if t is null or t.count = 0 then
518: a0 := JTF_NUMBER_TABLE();
519: a1 := JTF_VARCHAR2_TABLE_100();
520: a2 := JTF_VARCHAR2_TABLE_100();
521: a3 := JTF_VARCHAR2_TABLE_100();
522: else

Line 523: a0 := JTF_NUMBER_TABLE();

519: a1 := JTF_VARCHAR2_TABLE_100();
520: a2 := JTF_VARCHAR2_TABLE_100();
521: a3 := JTF_VARCHAR2_TABLE_100();
522: else
523: a0 := JTF_NUMBER_TABLE();
524: a1 := JTF_VARCHAR2_TABLE_100();
525: a2 := JTF_VARCHAR2_TABLE_100();
526: a3 := JTF_VARCHAR2_TABLE_100();
527: if t.count > 0 then

Line 559: , p9_a1 JTF_NUMBER_TABLE

555: , p_line_id NUMBER
556: , p_cpl_id NUMBER
557: , p_rrd_id NUMBER
558: , p9_a0 JTF_VARCHAR2_TABLE_100
559: , p9_a1 JTF_NUMBER_TABLE
560: , p9_a2 JTF_NUMBER_TABLE
561: , p9_a3 JTF_VARCHAR2_TABLE_100
562: , p9_a4 JTF_VARCHAR2_TABLE_100
563: , p9_a5 JTF_VARCHAR2_TABLE_100

Line 560: , p9_a2 JTF_NUMBER_TABLE

556: , p_cpl_id NUMBER
557: , p_rrd_id NUMBER
558: , p9_a0 JTF_VARCHAR2_TABLE_100
559: , p9_a1 JTF_NUMBER_TABLE
560: , p9_a2 JTF_NUMBER_TABLE
561: , p9_a3 JTF_VARCHAR2_TABLE_100
562: , p9_a4 JTF_VARCHAR2_TABLE_100
563: , p9_a5 JTF_VARCHAR2_TABLE_100
564: , p9_a6 JTF_VARCHAR2_TABLE_100

Line 571: , p9_a13 JTF_NUMBER_TABLE

567: , p9_a9 JTF_VARCHAR2_TABLE_200
568: , p9_a10 JTF_VARCHAR2_TABLE_100
569: , p9_a11 JTF_VARCHAR2_TABLE_100
570: , p9_a12 JTF_VARCHAR2_TABLE_100
571: , p9_a13 JTF_NUMBER_TABLE
572: , p9_a14 JTF_NUMBER_TABLE
573: , p9_a15 JTF_NUMBER_TABLE
574: , p9_a16 JTF_VARCHAR2_TABLE_100
575: , p9_a17 JTF_VARCHAR2_TABLE_2000

Line 572: , p9_a14 JTF_NUMBER_TABLE

568: , p9_a10 JTF_VARCHAR2_TABLE_100
569: , p9_a11 JTF_VARCHAR2_TABLE_100
570: , p9_a12 JTF_VARCHAR2_TABLE_100
571: , p9_a13 JTF_NUMBER_TABLE
572: , p9_a14 JTF_NUMBER_TABLE
573: , p9_a15 JTF_NUMBER_TABLE
574: , p9_a16 JTF_VARCHAR2_TABLE_100
575: , p9_a17 JTF_VARCHAR2_TABLE_2000
576: , p9_a18 JTF_VARCHAR2_TABLE_100

Line 573: , p9_a15 JTF_NUMBER_TABLE

569: , p9_a11 JTF_VARCHAR2_TABLE_100
570: , p9_a12 JTF_VARCHAR2_TABLE_100
571: , p9_a13 JTF_NUMBER_TABLE
572: , p9_a14 JTF_NUMBER_TABLE
573: , p9_a15 JTF_NUMBER_TABLE
574: , p9_a16 JTF_VARCHAR2_TABLE_100
575: , p9_a17 JTF_VARCHAR2_TABLE_2000
576: , p9_a18 JTF_VARCHAR2_TABLE_100
577: , p9_a19 JTF_VARCHAR2_TABLE_100

Line 593: , p9_a35 JTF_NUMBER_TABLE

589: , p9_a31 JTF_VARCHAR2_TABLE_500
590: , p9_a32 JTF_VARCHAR2_TABLE_500
591: , p9_a33 JTF_VARCHAR2_TABLE_500
592: , p9_a34 JTF_VARCHAR2_TABLE_500
593: , p9_a35 JTF_NUMBER_TABLE
594: , p9_a36 JTF_DATE_TABLE
595: , p9_a37 JTF_NUMBER_TABLE
596: , p9_a38 JTF_DATE_TABLE
597: , p9_a39 JTF_NUMBER_TABLE

Line 595: , p9_a37 JTF_NUMBER_TABLE

591: , p9_a33 JTF_VARCHAR2_TABLE_500
592: , p9_a34 JTF_VARCHAR2_TABLE_500
593: , p9_a35 JTF_NUMBER_TABLE
594: , p9_a36 JTF_DATE_TABLE
595: , p9_a37 JTF_NUMBER_TABLE
596: , p9_a38 JTF_DATE_TABLE
597: , p9_a39 JTF_NUMBER_TABLE
598: , p9_a40 JTF_VARCHAR2_TABLE_100
599: , p9_a41 JTF_VARCHAR2_TABLE_500

Line 597: , p9_a39 JTF_NUMBER_TABLE

593: , p9_a35 JTF_NUMBER_TABLE
594: , p9_a36 JTF_DATE_TABLE
595: , p9_a37 JTF_NUMBER_TABLE
596: , p9_a38 JTF_DATE_TABLE
597: , p9_a39 JTF_NUMBER_TABLE
598: , p9_a40 JTF_VARCHAR2_TABLE_100
599: , p9_a41 JTF_VARCHAR2_TABLE_500
600: , p9_a42 JTF_VARCHAR2_TABLE_500
601: , p9_a43 JTF_VARCHAR2_TABLE_500

Line 618: , p9_a60 JTF_NUMBER_TABLE

614: , p9_a56 JTF_VARCHAR2_TABLE_100
615: , p9_a57 JTF_VARCHAR2_TABLE_100
616: , p9_a58 JTF_VARCHAR2_TABLE_100
617: , p9_a59 JTF_VARCHAR2_TABLE_100
618: , p9_a60 JTF_NUMBER_TABLE
619: )
620:
621: as
622: ddp_rgr_tbl okl_rgrp_rules_process_pvt.rgr_tbl_type;

Line 730: , p6_a1 JTF_NUMBER_TABLE

726: , x_msg_count out nocopy NUMBER
727: , x_msg_data out nocopy VARCHAR2
728: , p_id NUMBER
729: , p6_a0 JTF_VARCHAR2_TABLE_100
730: , p6_a1 JTF_NUMBER_TABLE
731: , p6_a2 JTF_NUMBER_TABLE
732: , p6_a3 JTF_VARCHAR2_TABLE_100
733: , p6_a4 JTF_VARCHAR2_TABLE_100
734: , p6_a5 JTF_VARCHAR2_TABLE_100

Line 731: , p6_a2 JTF_NUMBER_TABLE

727: , x_msg_data out nocopy VARCHAR2
728: , p_id NUMBER
729: , p6_a0 JTF_VARCHAR2_TABLE_100
730: , p6_a1 JTF_NUMBER_TABLE
731: , p6_a2 JTF_NUMBER_TABLE
732: , p6_a3 JTF_VARCHAR2_TABLE_100
733: , p6_a4 JTF_VARCHAR2_TABLE_100
734: , p6_a5 JTF_VARCHAR2_TABLE_100
735: , p6_a6 JTF_VARCHAR2_TABLE_100

Line 742: , p6_a13 JTF_NUMBER_TABLE

738: , p6_a9 JTF_VARCHAR2_TABLE_200
739: , p6_a10 JTF_VARCHAR2_TABLE_100
740: , p6_a11 JTF_VARCHAR2_TABLE_100
741: , p6_a12 JTF_VARCHAR2_TABLE_100
742: , p6_a13 JTF_NUMBER_TABLE
743: , p6_a14 JTF_NUMBER_TABLE
744: , p6_a15 JTF_NUMBER_TABLE
745: , p6_a16 JTF_VARCHAR2_TABLE_100
746: , p6_a17 JTF_VARCHAR2_TABLE_2000

Line 743: , p6_a14 JTF_NUMBER_TABLE

739: , p6_a10 JTF_VARCHAR2_TABLE_100
740: , p6_a11 JTF_VARCHAR2_TABLE_100
741: , p6_a12 JTF_VARCHAR2_TABLE_100
742: , p6_a13 JTF_NUMBER_TABLE
743: , p6_a14 JTF_NUMBER_TABLE
744: , p6_a15 JTF_NUMBER_TABLE
745: , p6_a16 JTF_VARCHAR2_TABLE_100
746: , p6_a17 JTF_VARCHAR2_TABLE_2000
747: , p6_a18 JTF_VARCHAR2_TABLE_100

Line 744: , p6_a15 JTF_NUMBER_TABLE

740: , p6_a11 JTF_VARCHAR2_TABLE_100
741: , p6_a12 JTF_VARCHAR2_TABLE_100
742: , p6_a13 JTF_NUMBER_TABLE
743: , p6_a14 JTF_NUMBER_TABLE
744: , p6_a15 JTF_NUMBER_TABLE
745: , p6_a16 JTF_VARCHAR2_TABLE_100
746: , p6_a17 JTF_VARCHAR2_TABLE_2000
747: , p6_a18 JTF_VARCHAR2_TABLE_100
748: , p6_a19 JTF_VARCHAR2_TABLE_100

Line 764: , p6_a35 JTF_NUMBER_TABLE

760: , p6_a31 JTF_VARCHAR2_TABLE_500
761: , p6_a32 JTF_VARCHAR2_TABLE_500
762: , p6_a33 JTF_VARCHAR2_TABLE_500
763: , p6_a34 JTF_VARCHAR2_TABLE_500
764: , p6_a35 JTF_NUMBER_TABLE
765: , p6_a36 JTF_DATE_TABLE
766: , p6_a37 JTF_NUMBER_TABLE
767: , p6_a38 JTF_DATE_TABLE
768: , p6_a39 JTF_NUMBER_TABLE

Line 766: , p6_a37 JTF_NUMBER_TABLE

762: , p6_a33 JTF_VARCHAR2_TABLE_500
763: , p6_a34 JTF_VARCHAR2_TABLE_500
764: , p6_a35 JTF_NUMBER_TABLE
765: , p6_a36 JTF_DATE_TABLE
766: , p6_a37 JTF_NUMBER_TABLE
767: , p6_a38 JTF_DATE_TABLE
768: , p6_a39 JTF_NUMBER_TABLE
769: , p6_a40 JTF_VARCHAR2_TABLE_100
770: , p6_a41 JTF_VARCHAR2_TABLE_500

Line 768: , p6_a39 JTF_NUMBER_TABLE

764: , p6_a35 JTF_NUMBER_TABLE
765: , p6_a36 JTF_DATE_TABLE
766: , p6_a37 JTF_NUMBER_TABLE
767: , p6_a38 JTF_DATE_TABLE
768: , p6_a39 JTF_NUMBER_TABLE
769: , p6_a40 JTF_VARCHAR2_TABLE_100
770: , p6_a41 JTF_VARCHAR2_TABLE_500
771: , p6_a42 JTF_VARCHAR2_TABLE_500
772: , p6_a43 JTF_VARCHAR2_TABLE_500

Line 789: , p6_a60 JTF_NUMBER_TABLE

785: , p6_a56 JTF_VARCHAR2_TABLE_100
786: , p6_a57 JTF_VARCHAR2_TABLE_100
787: , p6_a58 JTF_VARCHAR2_TABLE_100
788: , p6_a59 JTF_VARCHAR2_TABLE_100
789: , p6_a60 JTF_NUMBER_TABLE
790: , p7_a0 out nocopy JTF_NUMBER_TABLE
791: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
792: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
793: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 790: , p7_a0 out nocopy JTF_NUMBER_TABLE

786: , p6_a57 JTF_VARCHAR2_TABLE_100
787: , p6_a58 JTF_VARCHAR2_TABLE_100
788: , p6_a59 JTF_VARCHAR2_TABLE_100
789: , p6_a60 JTF_NUMBER_TABLE
790: , p7_a0 out nocopy JTF_NUMBER_TABLE
791: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
792: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
793: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
794: )