APPS.OKS_ENTITLEMENTS_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 104: , a6 JTF_VARCHAR2_TABLE_100

100: , a2 JTF_VARCHAR2_TABLE_200
101: , a3 JTF_VARCHAR2_TABLE_200
102: , a4 JTF_VARCHAR2_TABLE_600
103: , a5 JTF_NUMBER_TABLE
104: , a6 JTF_VARCHAR2_TABLE_100
105: , a7 JTF_VARCHAR2_TABLE_100
106: , a8 JTF_NUMBER_TABLE
107: , a9 JTF_VARCHAR2_TABLE_100
108: , a10 JTF_VARCHAR2_TABLE_200

Line 105: , a7 JTF_VARCHAR2_TABLE_100

101: , a3 JTF_VARCHAR2_TABLE_200
102: , a4 JTF_VARCHAR2_TABLE_600
103: , a5 JTF_NUMBER_TABLE
104: , a6 JTF_VARCHAR2_TABLE_100
105: , a7 JTF_VARCHAR2_TABLE_100
106: , a8 JTF_NUMBER_TABLE
107: , a9 JTF_VARCHAR2_TABLE_100
108: , a10 JTF_VARCHAR2_TABLE_200
109: , a11 JTF_NUMBER_TABLE

Line 107: , a9 JTF_VARCHAR2_TABLE_100

103: , a5 JTF_NUMBER_TABLE
104: , a6 JTF_VARCHAR2_TABLE_100
105: , a7 JTF_VARCHAR2_TABLE_100
106: , a8 JTF_NUMBER_TABLE
107: , a9 JTF_VARCHAR2_TABLE_100
108: , a10 JTF_VARCHAR2_TABLE_200
109: , a11 JTF_NUMBER_TABLE
110: , a12 JTF_VARCHAR2_TABLE_100
111: , a13 JTF_DATE_TABLE

Line 110: , a12 JTF_VARCHAR2_TABLE_100

106: , a8 JTF_NUMBER_TABLE
107: , a9 JTF_VARCHAR2_TABLE_100
108: , a10 JTF_VARCHAR2_TABLE_200
109: , a11 JTF_NUMBER_TABLE
110: , a12 JTF_VARCHAR2_TABLE_100
111: , a13 JTF_DATE_TABLE
112: , a14 JTF_DATE_TABLE
113: , a15 JTF_NUMBER_TABLE
114: , a16 JTF_NUMBER_TABLE

Line 118: , a20 JTF_VARCHAR2_TABLE_100

114: , a16 JTF_NUMBER_TABLE
115: , a17 JTF_NUMBER_TABLE
116: , a18 JTF_NUMBER_TABLE
117: , a19 JTF_NUMBER_TABLE
118: , a20 JTF_VARCHAR2_TABLE_100
119: , a21 JTF_NUMBER_TABLE
120: , a22 JTF_NUMBER_TABLE
121: , a23 JTF_NUMBER_TABLE
122: , a24 JTF_VARCHAR2_TABLE_200

Line 124: , a26 JTF_VARCHAR2_TABLE_100

120: , a22 JTF_NUMBER_TABLE
121: , a23 JTF_NUMBER_TABLE
122: , a24 JTF_VARCHAR2_TABLE_200
123: , a25 JTF_NUMBER_TABLE
124: , a26 JTF_VARCHAR2_TABLE_100
125: , a27 JTF_VARCHAR2_TABLE_100
126: , a28 JTF_NUMBER_TABLE
127: , a29 JTF_DATE_TABLE
128: , a30 JTF_DATE_TABLE

Line 125: , a27 JTF_VARCHAR2_TABLE_100

121: , a23 JTF_NUMBER_TABLE
122: , a24 JTF_VARCHAR2_TABLE_200
123: , a25 JTF_NUMBER_TABLE
124: , a26 JTF_VARCHAR2_TABLE_100
125: , a27 JTF_VARCHAR2_TABLE_100
126: , a28 JTF_NUMBER_TABLE
127: , a29 JTF_DATE_TABLE
128: , a30 JTF_DATE_TABLE
129: , a31 JTF_NUMBER_TABLE

Line 197: , a6 out nocopy JTF_VARCHAR2_TABLE_100

193: , a2 out nocopy JTF_VARCHAR2_TABLE_200
194: , a3 out nocopy JTF_VARCHAR2_TABLE_200
195: , a4 out nocopy JTF_VARCHAR2_TABLE_600
196: , a5 out nocopy JTF_NUMBER_TABLE
197: , a6 out nocopy JTF_VARCHAR2_TABLE_100
198: , a7 out nocopy JTF_VARCHAR2_TABLE_100
199: , a8 out nocopy JTF_NUMBER_TABLE
200: , a9 out nocopy JTF_VARCHAR2_TABLE_100
201: , a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 198: , a7 out nocopy JTF_VARCHAR2_TABLE_100

194: , a3 out nocopy JTF_VARCHAR2_TABLE_200
195: , a4 out nocopy JTF_VARCHAR2_TABLE_600
196: , a5 out nocopy JTF_NUMBER_TABLE
197: , a6 out nocopy JTF_VARCHAR2_TABLE_100
198: , a7 out nocopy JTF_VARCHAR2_TABLE_100
199: , a8 out nocopy JTF_NUMBER_TABLE
200: , a9 out nocopy JTF_VARCHAR2_TABLE_100
201: , a10 out nocopy JTF_VARCHAR2_TABLE_200
202: , a11 out nocopy JTF_NUMBER_TABLE

Line 200: , a9 out nocopy JTF_VARCHAR2_TABLE_100

196: , a5 out nocopy JTF_NUMBER_TABLE
197: , a6 out nocopy JTF_VARCHAR2_TABLE_100
198: , a7 out nocopy JTF_VARCHAR2_TABLE_100
199: , a8 out nocopy JTF_NUMBER_TABLE
200: , a9 out nocopy JTF_VARCHAR2_TABLE_100
201: , a10 out nocopy JTF_VARCHAR2_TABLE_200
202: , a11 out nocopy JTF_NUMBER_TABLE
203: , a12 out nocopy JTF_VARCHAR2_TABLE_100
204: , a13 out nocopy JTF_DATE_TABLE

Line 203: , a12 out nocopy JTF_VARCHAR2_TABLE_100

199: , a8 out nocopy JTF_NUMBER_TABLE
200: , a9 out nocopy JTF_VARCHAR2_TABLE_100
201: , a10 out nocopy JTF_VARCHAR2_TABLE_200
202: , a11 out nocopy JTF_NUMBER_TABLE
203: , a12 out nocopy JTF_VARCHAR2_TABLE_100
204: , a13 out nocopy JTF_DATE_TABLE
205: , a14 out nocopy JTF_DATE_TABLE
206: , a15 out nocopy JTF_NUMBER_TABLE
207: , a16 out nocopy JTF_NUMBER_TABLE

Line 211: , a20 out nocopy JTF_VARCHAR2_TABLE_100

207: , a16 out nocopy JTF_NUMBER_TABLE
208: , a17 out nocopy JTF_NUMBER_TABLE
209: , a18 out nocopy JTF_NUMBER_TABLE
210: , a19 out nocopy JTF_NUMBER_TABLE
211: , a20 out nocopy JTF_VARCHAR2_TABLE_100
212: , a21 out nocopy JTF_NUMBER_TABLE
213: , a22 out nocopy JTF_NUMBER_TABLE
214: , a23 out nocopy JTF_NUMBER_TABLE
215: , a24 out nocopy JTF_VARCHAR2_TABLE_200

Line 217: , a26 out nocopy JTF_VARCHAR2_TABLE_100

213: , a22 out nocopy JTF_NUMBER_TABLE
214: , a23 out nocopy JTF_NUMBER_TABLE
215: , a24 out nocopy JTF_VARCHAR2_TABLE_200
216: , a25 out nocopy JTF_NUMBER_TABLE
217: , a26 out nocopy JTF_VARCHAR2_TABLE_100
218: , a27 out nocopy JTF_VARCHAR2_TABLE_100
219: , a28 out nocopy JTF_NUMBER_TABLE
220: , a29 out nocopy JTF_DATE_TABLE
221: , a30 out nocopy JTF_DATE_TABLE

Line 218: , a27 out nocopy JTF_VARCHAR2_TABLE_100

214: , a23 out nocopy JTF_NUMBER_TABLE
215: , a24 out nocopy JTF_VARCHAR2_TABLE_200
216: , a25 out nocopy JTF_NUMBER_TABLE
217: , a26 out nocopy JTF_VARCHAR2_TABLE_100
218: , a27 out nocopy JTF_VARCHAR2_TABLE_100
219: , a28 out nocopy JTF_NUMBER_TABLE
220: , a29 out nocopy JTF_DATE_TABLE
221: , a30 out nocopy JTF_DATE_TABLE
222: , a31 out nocopy JTF_NUMBER_TABLE

Line 239: a6 := JTF_VARCHAR2_TABLE_100();

235: a2 := JTF_VARCHAR2_TABLE_200();
236: a3 := JTF_VARCHAR2_TABLE_200();
237: a4 := JTF_VARCHAR2_TABLE_600();
238: a5 := JTF_NUMBER_TABLE();
239: a6 := JTF_VARCHAR2_TABLE_100();
240: a7 := JTF_VARCHAR2_TABLE_100();
241: a8 := JTF_NUMBER_TABLE();
242: a9 := JTF_VARCHAR2_TABLE_100();
243: a10 := JTF_VARCHAR2_TABLE_200();

Line 240: a7 := JTF_VARCHAR2_TABLE_100();

236: a3 := JTF_VARCHAR2_TABLE_200();
237: a4 := JTF_VARCHAR2_TABLE_600();
238: a5 := JTF_NUMBER_TABLE();
239: a6 := JTF_VARCHAR2_TABLE_100();
240: a7 := JTF_VARCHAR2_TABLE_100();
241: a8 := JTF_NUMBER_TABLE();
242: a9 := JTF_VARCHAR2_TABLE_100();
243: a10 := JTF_VARCHAR2_TABLE_200();
244: a11 := JTF_NUMBER_TABLE();

Line 242: a9 := JTF_VARCHAR2_TABLE_100();

238: a5 := JTF_NUMBER_TABLE();
239: a6 := JTF_VARCHAR2_TABLE_100();
240: a7 := JTF_VARCHAR2_TABLE_100();
241: a8 := JTF_NUMBER_TABLE();
242: a9 := JTF_VARCHAR2_TABLE_100();
243: a10 := JTF_VARCHAR2_TABLE_200();
244: a11 := JTF_NUMBER_TABLE();
245: a12 := JTF_VARCHAR2_TABLE_100();
246: a13 := JTF_DATE_TABLE();

Line 245: a12 := JTF_VARCHAR2_TABLE_100();

241: a8 := JTF_NUMBER_TABLE();
242: a9 := JTF_VARCHAR2_TABLE_100();
243: a10 := JTF_VARCHAR2_TABLE_200();
244: a11 := JTF_NUMBER_TABLE();
245: a12 := JTF_VARCHAR2_TABLE_100();
246: a13 := JTF_DATE_TABLE();
247: a14 := JTF_DATE_TABLE();
248: a15 := JTF_NUMBER_TABLE();
249: a16 := JTF_NUMBER_TABLE();

Line 253: a20 := JTF_VARCHAR2_TABLE_100();

249: a16 := JTF_NUMBER_TABLE();
250: a17 := JTF_NUMBER_TABLE();
251: a18 := JTF_NUMBER_TABLE();
252: a19 := JTF_NUMBER_TABLE();
253: a20 := JTF_VARCHAR2_TABLE_100();
254: a21 := JTF_NUMBER_TABLE();
255: a22 := JTF_NUMBER_TABLE();
256: a23 := JTF_NUMBER_TABLE();
257: a24 := JTF_VARCHAR2_TABLE_200();

Line 259: a26 := JTF_VARCHAR2_TABLE_100();

255: a22 := JTF_NUMBER_TABLE();
256: a23 := JTF_NUMBER_TABLE();
257: a24 := JTF_VARCHAR2_TABLE_200();
258: a25 := JTF_NUMBER_TABLE();
259: a26 := JTF_VARCHAR2_TABLE_100();
260: a27 := JTF_VARCHAR2_TABLE_100();
261: a28 := JTF_NUMBER_TABLE();
262: a29 := JTF_DATE_TABLE();
263: a30 := JTF_DATE_TABLE();

Line 260: a27 := JTF_VARCHAR2_TABLE_100();

256: a23 := JTF_NUMBER_TABLE();
257: a24 := JTF_VARCHAR2_TABLE_200();
258: a25 := JTF_NUMBER_TABLE();
259: a26 := JTF_VARCHAR2_TABLE_100();
260: a27 := JTF_VARCHAR2_TABLE_100();
261: a28 := JTF_NUMBER_TABLE();
262: a29 := JTF_DATE_TABLE();
263: a30 := JTF_DATE_TABLE();
264: a31 := JTF_NUMBER_TABLE();

Line 278: a6 := JTF_VARCHAR2_TABLE_100();

274: a2 := JTF_VARCHAR2_TABLE_200();
275: a3 := JTF_VARCHAR2_TABLE_200();
276: a4 := JTF_VARCHAR2_TABLE_600();
277: a5 := JTF_NUMBER_TABLE();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_VARCHAR2_TABLE_100();
280: a8 := JTF_NUMBER_TABLE();
281: a9 := JTF_VARCHAR2_TABLE_100();
282: a10 := JTF_VARCHAR2_TABLE_200();

Line 279: a7 := JTF_VARCHAR2_TABLE_100();

275: a3 := JTF_VARCHAR2_TABLE_200();
276: a4 := JTF_VARCHAR2_TABLE_600();
277: a5 := JTF_NUMBER_TABLE();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_VARCHAR2_TABLE_100();
280: a8 := JTF_NUMBER_TABLE();
281: a9 := JTF_VARCHAR2_TABLE_100();
282: a10 := JTF_VARCHAR2_TABLE_200();
283: a11 := JTF_NUMBER_TABLE();

Line 281: a9 := JTF_VARCHAR2_TABLE_100();

277: a5 := JTF_NUMBER_TABLE();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_VARCHAR2_TABLE_100();
280: a8 := JTF_NUMBER_TABLE();
281: a9 := JTF_VARCHAR2_TABLE_100();
282: a10 := JTF_VARCHAR2_TABLE_200();
283: a11 := JTF_NUMBER_TABLE();
284: a12 := JTF_VARCHAR2_TABLE_100();
285: a13 := JTF_DATE_TABLE();

Line 284: a12 := JTF_VARCHAR2_TABLE_100();

280: a8 := JTF_NUMBER_TABLE();
281: a9 := JTF_VARCHAR2_TABLE_100();
282: a10 := JTF_VARCHAR2_TABLE_200();
283: a11 := JTF_NUMBER_TABLE();
284: a12 := JTF_VARCHAR2_TABLE_100();
285: a13 := JTF_DATE_TABLE();
286: a14 := JTF_DATE_TABLE();
287: a15 := JTF_NUMBER_TABLE();
288: a16 := JTF_NUMBER_TABLE();

Line 292: a20 := JTF_VARCHAR2_TABLE_100();

288: a16 := JTF_NUMBER_TABLE();
289: a17 := JTF_NUMBER_TABLE();
290: a18 := JTF_NUMBER_TABLE();
291: a19 := JTF_NUMBER_TABLE();
292: a20 := JTF_VARCHAR2_TABLE_100();
293: a21 := JTF_NUMBER_TABLE();
294: a22 := JTF_NUMBER_TABLE();
295: a23 := JTF_NUMBER_TABLE();
296: a24 := JTF_VARCHAR2_TABLE_200();

Line 298: a26 := JTF_VARCHAR2_TABLE_100();

294: a22 := JTF_NUMBER_TABLE();
295: a23 := JTF_NUMBER_TABLE();
296: a24 := JTF_VARCHAR2_TABLE_200();
297: a25 := JTF_NUMBER_TABLE();
298: a26 := JTF_VARCHAR2_TABLE_100();
299: a27 := JTF_VARCHAR2_TABLE_100();
300: a28 := JTF_NUMBER_TABLE();
301: a29 := JTF_DATE_TABLE();
302: a30 := JTF_DATE_TABLE();

Line 299: a27 := JTF_VARCHAR2_TABLE_100();

295: a23 := JTF_NUMBER_TABLE();
296: a24 := JTF_VARCHAR2_TABLE_200();
297: a25 := JTF_NUMBER_TABLE();
298: a26 := JTF_VARCHAR2_TABLE_100();
299: a27 := JTF_VARCHAR2_TABLE_100();
300: a28 := JTF_NUMBER_TABLE();
301: a29 := JTF_DATE_TABLE();
302: a30 := JTF_DATE_TABLE();
303: a31 := JTF_NUMBER_TABLE();

Line 403: , a3 JTF_VARCHAR2_TABLE_100

399:
400: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_pub.line_tbl_type, a0 JTF_NUMBER_TABLE
401: , a1 JTF_NUMBER_TABLE
402: , a2 JTF_NUMBER_TABLE
403: , a3 JTF_VARCHAR2_TABLE_100
404: , a4 JTF_NUMBER_TABLE
405: , a5 JTF_VARCHAR2_TABLE_100
406: , a6 JTF_DATE_TABLE
407: , a7 JTF_DATE_TABLE

Line 405: , a5 JTF_VARCHAR2_TABLE_100

401: , a1 JTF_NUMBER_TABLE
402: , a2 JTF_NUMBER_TABLE
403: , a3 JTF_VARCHAR2_TABLE_100
404: , a4 JTF_NUMBER_TABLE
405: , a5 JTF_VARCHAR2_TABLE_100
406: , a6 JTF_DATE_TABLE
407: , a7 JTF_DATE_TABLE
408: , a8 JTF_VARCHAR2_TABLE_200
409: , a9 JTF_NUMBER_TABLE

Line 416: , a16 JTF_VARCHAR2_TABLE_100

412: , a12 JTF_NUMBER_TABLE
413: , a13 JTF_NUMBER_TABLE
414: , a14 JTF_NUMBER_TABLE
415: , a15 JTF_NUMBER_TABLE
416: , a16 JTF_VARCHAR2_TABLE_100
417: , a17 JTF_VARCHAR2_TABLE_100
418: , a18 JTF_NUMBER_TABLE
419: , a19 JTF_DATE_TABLE
420: , a20 JTF_DATE_TABLE

Line 417: , a17 JTF_VARCHAR2_TABLE_100

413: , a13 JTF_NUMBER_TABLE
414: , a14 JTF_NUMBER_TABLE
415: , a15 JTF_NUMBER_TABLE
416: , a16 JTF_VARCHAR2_TABLE_100
417: , a17 JTF_VARCHAR2_TABLE_100
418: , a18 JTF_NUMBER_TABLE
419: , a19 JTF_DATE_TABLE
420: , a20 JTF_DATE_TABLE
421: , a21 JTF_DATE_TABLE

Line 464: , a3 out nocopy JTF_VARCHAR2_TABLE_100

460: end rosetta_table_copy_in_p19;
461: procedure rosetta_table_copy_out_p19(t oks_entitlements_pub.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
462: , a1 out nocopy JTF_NUMBER_TABLE
463: , a2 out nocopy JTF_NUMBER_TABLE
464: , a3 out nocopy JTF_VARCHAR2_TABLE_100
465: , a4 out nocopy JTF_NUMBER_TABLE
466: , a5 out nocopy JTF_VARCHAR2_TABLE_100
467: , a6 out nocopy JTF_DATE_TABLE
468: , a7 out nocopy JTF_DATE_TABLE

Line 466: , a5 out nocopy JTF_VARCHAR2_TABLE_100

462: , a1 out nocopy JTF_NUMBER_TABLE
463: , a2 out nocopy JTF_NUMBER_TABLE
464: , a3 out nocopy JTF_VARCHAR2_TABLE_100
465: , a4 out nocopy JTF_NUMBER_TABLE
466: , a5 out nocopy JTF_VARCHAR2_TABLE_100
467: , a6 out nocopy JTF_DATE_TABLE
468: , a7 out nocopy JTF_DATE_TABLE
469: , a8 out nocopy JTF_VARCHAR2_TABLE_200
470: , a9 out nocopy JTF_NUMBER_TABLE

Line 477: , a16 out nocopy JTF_VARCHAR2_TABLE_100

473: , a12 out nocopy JTF_NUMBER_TABLE
474: , a13 out nocopy JTF_NUMBER_TABLE
475: , a14 out nocopy JTF_NUMBER_TABLE
476: , a15 out nocopy JTF_NUMBER_TABLE
477: , a16 out nocopy JTF_VARCHAR2_TABLE_100
478: , a17 out nocopy JTF_VARCHAR2_TABLE_100
479: , a18 out nocopy JTF_NUMBER_TABLE
480: , a19 out nocopy JTF_DATE_TABLE
481: , a20 out nocopy JTF_DATE_TABLE

Line 478: , a17 out nocopy JTF_VARCHAR2_TABLE_100

474: , a13 out nocopy JTF_NUMBER_TABLE
475: , a14 out nocopy JTF_NUMBER_TABLE
476: , a15 out nocopy JTF_NUMBER_TABLE
477: , a16 out nocopy JTF_VARCHAR2_TABLE_100
478: , a17 out nocopy JTF_VARCHAR2_TABLE_100
479: , a18 out nocopy JTF_NUMBER_TABLE
480: , a19 out nocopy JTF_DATE_TABLE
481: , a20 out nocopy JTF_DATE_TABLE
482: , a21 out nocopy JTF_DATE_TABLE

Line 490: a3 := JTF_VARCHAR2_TABLE_100();

486: if t is null or t.count = 0 then
487: a0 := JTF_NUMBER_TABLE();
488: a1 := JTF_NUMBER_TABLE();
489: a2 := JTF_NUMBER_TABLE();
490: a3 := JTF_VARCHAR2_TABLE_100();
491: a4 := JTF_NUMBER_TABLE();
492: a5 := JTF_VARCHAR2_TABLE_100();
493: a6 := JTF_DATE_TABLE();
494: a7 := JTF_DATE_TABLE();

Line 492: a5 := JTF_VARCHAR2_TABLE_100();

488: a1 := JTF_NUMBER_TABLE();
489: a2 := JTF_NUMBER_TABLE();
490: a3 := JTF_VARCHAR2_TABLE_100();
491: a4 := JTF_NUMBER_TABLE();
492: a5 := JTF_VARCHAR2_TABLE_100();
493: a6 := JTF_DATE_TABLE();
494: a7 := JTF_DATE_TABLE();
495: a8 := JTF_VARCHAR2_TABLE_200();
496: a9 := JTF_NUMBER_TABLE();

Line 503: a16 := JTF_VARCHAR2_TABLE_100();

499: a12 := JTF_NUMBER_TABLE();
500: a13 := JTF_NUMBER_TABLE();
501: a14 := JTF_NUMBER_TABLE();
502: a15 := JTF_NUMBER_TABLE();
503: a16 := JTF_VARCHAR2_TABLE_100();
504: a17 := JTF_VARCHAR2_TABLE_100();
505: a18 := JTF_NUMBER_TABLE();
506: a19 := JTF_DATE_TABLE();
507: a20 := JTF_DATE_TABLE();

Line 504: a17 := JTF_VARCHAR2_TABLE_100();

500: a13 := JTF_NUMBER_TABLE();
501: a14 := JTF_NUMBER_TABLE();
502: a15 := JTF_NUMBER_TABLE();
503: a16 := JTF_VARCHAR2_TABLE_100();
504: a17 := JTF_VARCHAR2_TABLE_100();
505: a18 := JTF_NUMBER_TABLE();
506: a19 := JTF_DATE_TABLE();
507: a20 := JTF_DATE_TABLE();
508: a21 := JTF_DATE_TABLE();

Line 513: a3 := JTF_VARCHAR2_TABLE_100();

509: else
510: a0 := JTF_NUMBER_TABLE();
511: a1 := JTF_NUMBER_TABLE();
512: a2 := JTF_NUMBER_TABLE();
513: a3 := JTF_VARCHAR2_TABLE_100();
514: a4 := JTF_NUMBER_TABLE();
515: a5 := JTF_VARCHAR2_TABLE_100();
516: a6 := JTF_DATE_TABLE();
517: a7 := JTF_DATE_TABLE();

Line 515: a5 := JTF_VARCHAR2_TABLE_100();

511: a1 := JTF_NUMBER_TABLE();
512: a2 := JTF_NUMBER_TABLE();
513: a3 := JTF_VARCHAR2_TABLE_100();
514: a4 := JTF_NUMBER_TABLE();
515: a5 := JTF_VARCHAR2_TABLE_100();
516: a6 := JTF_DATE_TABLE();
517: a7 := JTF_DATE_TABLE();
518: a8 := JTF_VARCHAR2_TABLE_200();
519: a9 := JTF_NUMBER_TABLE();

Line 526: a16 := JTF_VARCHAR2_TABLE_100();

522: a12 := JTF_NUMBER_TABLE();
523: a13 := JTF_NUMBER_TABLE();
524: a14 := JTF_NUMBER_TABLE();
525: a15 := JTF_NUMBER_TABLE();
526: a16 := JTF_VARCHAR2_TABLE_100();
527: a17 := JTF_VARCHAR2_TABLE_100();
528: a18 := JTF_NUMBER_TABLE();
529: a19 := JTF_DATE_TABLE();
530: a20 := JTF_DATE_TABLE();

Line 527: a17 := JTF_VARCHAR2_TABLE_100();

523: a13 := JTF_NUMBER_TABLE();
524: a14 := JTF_NUMBER_TABLE();
525: a15 := JTF_NUMBER_TABLE();
526: a16 := JTF_VARCHAR2_TABLE_100();
527: a17 := JTF_VARCHAR2_TABLE_100();
528: a18 := JTF_NUMBER_TABLE();
529: a19 := JTF_DATE_TABLE();
530: a20 := JTF_DATE_TABLE();
531: a21 := JTF_DATE_TABLE();

Line 590: procedure rosetta_table_copy_in_p22(t out nocopy oks_entitlements_pub.clvl_tbl_type, a0 JTF_VARCHAR2_TABLE_100

586: end if;
587: end if;
588: end rosetta_table_copy_out_p19;
589:
590: procedure rosetta_table_copy_in_p22(t out nocopy oks_entitlements_pub.clvl_tbl_type, a0 JTF_VARCHAR2_TABLE_100
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_VARCHAR2_TABLE_200

Line 611: , a21 JTF_VARCHAR2_TABLE_100

607: , a17 JTF_NUMBER_TABLE
608: , a18 JTF_NUMBER_TABLE
609: , a19 JTF_NUMBER_TABLE
610: , a20 JTF_VARCHAR2_TABLE_200
611: , a21 JTF_VARCHAR2_TABLE_100
612: , a22 JTF_NUMBER_TABLE
613: , a23 JTF_VARCHAR2_TABLE_100
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_VARCHAR2_TABLE_100

Line 613: , a23 JTF_VARCHAR2_TABLE_100

609: , a19 JTF_NUMBER_TABLE
610: , a20 JTF_VARCHAR2_TABLE_200
611: , a21 JTF_VARCHAR2_TABLE_100
612: , a22 JTF_NUMBER_TABLE
613: , a23 JTF_VARCHAR2_TABLE_100
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_VARCHAR2_TABLE_100
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_VARCHAR2_TABLE_100

Line 615: , a25 JTF_VARCHAR2_TABLE_100

611: , a21 JTF_VARCHAR2_TABLE_100
612: , a22 JTF_NUMBER_TABLE
613: , a23 JTF_VARCHAR2_TABLE_100
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_VARCHAR2_TABLE_100
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_VARCHAR2_TABLE_100
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_VARCHAR2_TABLE_100

Line 617: , a27 JTF_VARCHAR2_TABLE_100

613: , a23 JTF_VARCHAR2_TABLE_100
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_VARCHAR2_TABLE_100
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_VARCHAR2_TABLE_100
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_VARCHAR2_TABLE_100
620: , a30 JTF_NUMBER_TABLE
621: , a31 JTF_VARCHAR2_TABLE_100

Line 619: , a29 JTF_VARCHAR2_TABLE_100

615: , a25 JTF_VARCHAR2_TABLE_100
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_VARCHAR2_TABLE_100
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_VARCHAR2_TABLE_100
620: , a30 JTF_NUMBER_TABLE
621: , a31 JTF_VARCHAR2_TABLE_100
622: , a32 JTF_NUMBER_TABLE
623: , a33 JTF_VARCHAR2_TABLE_100

Line 621: , a31 JTF_VARCHAR2_TABLE_100

617: , a27 JTF_VARCHAR2_TABLE_100
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_VARCHAR2_TABLE_100
620: , a30 JTF_NUMBER_TABLE
621: , a31 JTF_VARCHAR2_TABLE_100
622: , a32 JTF_NUMBER_TABLE
623: , a33 JTF_VARCHAR2_TABLE_100
624: , a34 JTF_VARCHAR2_TABLE_100
625: ) as

Line 623: , a33 JTF_VARCHAR2_TABLE_100

619: , a29 JTF_VARCHAR2_TABLE_100
620: , a30 JTF_NUMBER_TABLE
621: , a31 JTF_VARCHAR2_TABLE_100
622: , a32 JTF_NUMBER_TABLE
623: , a33 JTF_VARCHAR2_TABLE_100
624: , a34 JTF_VARCHAR2_TABLE_100
625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin

Line 624: , a34 JTF_VARCHAR2_TABLE_100

620: , a30 JTF_NUMBER_TABLE
621: , a31 JTF_VARCHAR2_TABLE_100
622: , a32 JTF_NUMBER_TABLE
623: , a33 JTF_VARCHAR2_TABLE_100
624: , a34 JTF_VARCHAR2_TABLE_100
625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin
628: if a0 is not null and a0.count > 0 then

Line 677: procedure rosetta_table_copy_out_p22(t oks_entitlements_pub.clvl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

673: end loop;
674: end if;
675: end if;
676: end rosetta_table_copy_in_p22;
677: procedure rosetta_table_copy_out_p22(t oks_entitlements_pub.clvl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
678: , a1 out nocopy JTF_NUMBER_TABLE
679: , a2 out nocopy JTF_NUMBER_TABLE
680: , a3 out nocopy JTF_NUMBER_TABLE
681: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 698: , a21 out nocopy JTF_VARCHAR2_TABLE_100

694: , a17 out nocopy JTF_NUMBER_TABLE
695: , a18 out nocopy JTF_NUMBER_TABLE
696: , a19 out nocopy JTF_NUMBER_TABLE
697: , a20 out nocopy JTF_VARCHAR2_TABLE_200
698: , a21 out nocopy JTF_VARCHAR2_TABLE_100
699: , a22 out nocopy JTF_NUMBER_TABLE
700: , a23 out nocopy JTF_VARCHAR2_TABLE_100
701: , a24 out nocopy JTF_NUMBER_TABLE
702: , a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 700: , a23 out nocopy JTF_VARCHAR2_TABLE_100

696: , a19 out nocopy JTF_NUMBER_TABLE
697: , a20 out nocopy JTF_VARCHAR2_TABLE_200
698: , a21 out nocopy JTF_VARCHAR2_TABLE_100
699: , a22 out nocopy JTF_NUMBER_TABLE
700: , a23 out nocopy JTF_VARCHAR2_TABLE_100
701: , a24 out nocopy JTF_NUMBER_TABLE
702: , a25 out nocopy JTF_VARCHAR2_TABLE_100
703: , a26 out nocopy JTF_NUMBER_TABLE
704: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 702: , a25 out nocopy JTF_VARCHAR2_TABLE_100

698: , a21 out nocopy JTF_VARCHAR2_TABLE_100
699: , a22 out nocopy JTF_NUMBER_TABLE
700: , a23 out nocopy JTF_VARCHAR2_TABLE_100
701: , a24 out nocopy JTF_NUMBER_TABLE
702: , a25 out nocopy JTF_VARCHAR2_TABLE_100
703: , a26 out nocopy JTF_NUMBER_TABLE
704: , a27 out nocopy JTF_VARCHAR2_TABLE_100
705: , a28 out nocopy JTF_NUMBER_TABLE
706: , a29 out nocopy JTF_VARCHAR2_TABLE_100

Line 704: , a27 out nocopy JTF_VARCHAR2_TABLE_100

700: , a23 out nocopy JTF_VARCHAR2_TABLE_100
701: , a24 out nocopy JTF_NUMBER_TABLE
702: , a25 out nocopy JTF_VARCHAR2_TABLE_100
703: , a26 out nocopy JTF_NUMBER_TABLE
704: , a27 out nocopy JTF_VARCHAR2_TABLE_100
705: , a28 out nocopy JTF_NUMBER_TABLE
706: , a29 out nocopy JTF_VARCHAR2_TABLE_100
707: , a30 out nocopy JTF_NUMBER_TABLE
708: , a31 out nocopy JTF_VARCHAR2_TABLE_100

Line 706: , a29 out nocopy JTF_VARCHAR2_TABLE_100

702: , a25 out nocopy JTF_VARCHAR2_TABLE_100
703: , a26 out nocopy JTF_NUMBER_TABLE
704: , a27 out nocopy JTF_VARCHAR2_TABLE_100
705: , a28 out nocopy JTF_NUMBER_TABLE
706: , a29 out nocopy JTF_VARCHAR2_TABLE_100
707: , a30 out nocopy JTF_NUMBER_TABLE
708: , a31 out nocopy JTF_VARCHAR2_TABLE_100
709: , a32 out nocopy JTF_NUMBER_TABLE
710: , a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 708: , a31 out nocopy JTF_VARCHAR2_TABLE_100

704: , a27 out nocopy JTF_VARCHAR2_TABLE_100
705: , a28 out nocopy JTF_NUMBER_TABLE
706: , a29 out nocopy JTF_VARCHAR2_TABLE_100
707: , a30 out nocopy JTF_NUMBER_TABLE
708: , a31 out nocopy JTF_VARCHAR2_TABLE_100
709: , a32 out nocopy JTF_NUMBER_TABLE
710: , a33 out nocopy JTF_VARCHAR2_TABLE_100
711: , a34 out nocopy JTF_VARCHAR2_TABLE_100
712: ) as

Line 710: , a33 out nocopy JTF_VARCHAR2_TABLE_100

706: , a29 out nocopy JTF_VARCHAR2_TABLE_100
707: , a30 out nocopy JTF_NUMBER_TABLE
708: , a31 out nocopy JTF_VARCHAR2_TABLE_100
709: , a32 out nocopy JTF_NUMBER_TABLE
710: , a33 out nocopy JTF_VARCHAR2_TABLE_100
711: , a34 out nocopy JTF_VARCHAR2_TABLE_100
712: ) as
713: ddindx binary_integer; indx binary_integer;
714: begin

Line 711: , a34 out nocopy JTF_VARCHAR2_TABLE_100

707: , a30 out nocopy JTF_NUMBER_TABLE
708: , a31 out nocopy JTF_VARCHAR2_TABLE_100
709: , a32 out nocopy JTF_NUMBER_TABLE
710: , a33 out nocopy JTF_VARCHAR2_TABLE_100
711: , a34 out nocopy JTF_VARCHAR2_TABLE_100
712: ) as
713: ddindx binary_integer; indx binary_integer;
714: begin
715: if t is null or t.count = 0 then

Line 716: a0 := JTF_VARCHAR2_TABLE_100();

712: ) as
713: ddindx binary_integer; indx binary_integer;
714: begin
715: if t is null or t.count = 0 then
716: a0 := JTF_VARCHAR2_TABLE_100();
717: a1 := JTF_NUMBER_TABLE();
718: a2 := JTF_NUMBER_TABLE();
719: a3 := JTF_NUMBER_TABLE();
720: a4 := JTF_VARCHAR2_TABLE_200();

Line 737: a21 := JTF_VARCHAR2_TABLE_100();

733: a17 := JTF_NUMBER_TABLE();
734: a18 := JTF_NUMBER_TABLE();
735: a19 := JTF_NUMBER_TABLE();
736: a20 := JTF_VARCHAR2_TABLE_200();
737: a21 := JTF_VARCHAR2_TABLE_100();
738: a22 := JTF_NUMBER_TABLE();
739: a23 := JTF_VARCHAR2_TABLE_100();
740: a24 := JTF_NUMBER_TABLE();
741: a25 := JTF_VARCHAR2_TABLE_100();

Line 739: a23 := JTF_VARCHAR2_TABLE_100();

735: a19 := JTF_NUMBER_TABLE();
736: a20 := JTF_VARCHAR2_TABLE_200();
737: a21 := JTF_VARCHAR2_TABLE_100();
738: a22 := JTF_NUMBER_TABLE();
739: a23 := JTF_VARCHAR2_TABLE_100();
740: a24 := JTF_NUMBER_TABLE();
741: a25 := JTF_VARCHAR2_TABLE_100();
742: a26 := JTF_NUMBER_TABLE();
743: a27 := JTF_VARCHAR2_TABLE_100();

Line 741: a25 := JTF_VARCHAR2_TABLE_100();

737: a21 := JTF_VARCHAR2_TABLE_100();
738: a22 := JTF_NUMBER_TABLE();
739: a23 := JTF_VARCHAR2_TABLE_100();
740: a24 := JTF_NUMBER_TABLE();
741: a25 := JTF_VARCHAR2_TABLE_100();
742: a26 := JTF_NUMBER_TABLE();
743: a27 := JTF_VARCHAR2_TABLE_100();
744: a28 := JTF_NUMBER_TABLE();
745: a29 := JTF_VARCHAR2_TABLE_100();

Line 743: a27 := JTF_VARCHAR2_TABLE_100();

739: a23 := JTF_VARCHAR2_TABLE_100();
740: a24 := JTF_NUMBER_TABLE();
741: a25 := JTF_VARCHAR2_TABLE_100();
742: a26 := JTF_NUMBER_TABLE();
743: a27 := JTF_VARCHAR2_TABLE_100();
744: a28 := JTF_NUMBER_TABLE();
745: a29 := JTF_VARCHAR2_TABLE_100();
746: a30 := JTF_NUMBER_TABLE();
747: a31 := JTF_VARCHAR2_TABLE_100();

Line 745: a29 := JTF_VARCHAR2_TABLE_100();

741: a25 := JTF_VARCHAR2_TABLE_100();
742: a26 := JTF_NUMBER_TABLE();
743: a27 := JTF_VARCHAR2_TABLE_100();
744: a28 := JTF_NUMBER_TABLE();
745: a29 := JTF_VARCHAR2_TABLE_100();
746: a30 := JTF_NUMBER_TABLE();
747: a31 := JTF_VARCHAR2_TABLE_100();
748: a32 := JTF_NUMBER_TABLE();
749: a33 := JTF_VARCHAR2_TABLE_100();

Line 747: a31 := JTF_VARCHAR2_TABLE_100();

743: a27 := JTF_VARCHAR2_TABLE_100();
744: a28 := JTF_NUMBER_TABLE();
745: a29 := JTF_VARCHAR2_TABLE_100();
746: a30 := JTF_NUMBER_TABLE();
747: a31 := JTF_VARCHAR2_TABLE_100();
748: a32 := JTF_NUMBER_TABLE();
749: a33 := JTF_VARCHAR2_TABLE_100();
750: a34 := JTF_VARCHAR2_TABLE_100();
751: else

Line 749: a33 := JTF_VARCHAR2_TABLE_100();

745: a29 := JTF_VARCHAR2_TABLE_100();
746: a30 := JTF_NUMBER_TABLE();
747: a31 := JTF_VARCHAR2_TABLE_100();
748: a32 := JTF_NUMBER_TABLE();
749: a33 := JTF_VARCHAR2_TABLE_100();
750: a34 := JTF_VARCHAR2_TABLE_100();
751: else
752: a0 := JTF_VARCHAR2_TABLE_100();
753: a1 := JTF_NUMBER_TABLE();

Line 750: a34 := JTF_VARCHAR2_TABLE_100();

746: a30 := JTF_NUMBER_TABLE();
747: a31 := JTF_VARCHAR2_TABLE_100();
748: a32 := JTF_NUMBER_TABLE();
749: a33 := JTF_VARCHAR2_TABLE_100();
750: a34 := JTF_VARCHAR2_TABLE_100();
751: else
752: a0 := JTF_VARCHAR2_TABLE_100();
753: a1 := JTF_NUMBER_TABLE();
754: a2 := JTF_NUMBER_TABLE();

Line 752: a0 := JTF_VARCHAR2_TABLE_100();

748: a32 := JTF_NUMBER_TABLE();
749: a33 := JTF_VARCHAR2_TABLE_100();
750: a34 := JTF_VARCHAR2_TABLE_100();
751: else
752: a0 := JTF_VARCHAR2_TABLE_100();
753: a1 := JTF_NUMBER_TABLE();
754: a2 := JTF_NUMBER_TABLE();
755: a3 := JTF_NUMBER_TABLE();
756: a4 := JTF_VARCHAR2_TABLE_200();

Line 773: a21 := JTF_VARCHAR2_TABLE_100();

769: a17 := JTF_NUMBER_TABLE();
770: a18 := JTF_NUMBER_TABLE();
771: a19 := JTF_NUMBER_TABLE();
772: a20 := JTF_VARCHAR2_TABLE_200();
773: a21 := JTF_VARCHAR2_TABLE_100();
774: a22 := JTF_NUMBER_TABLE();
775: a23 := JTF_VARCHAR2_TABLE_100();
776: a24 := JTF_NUMBER_TABLE();
777: a25 := JTF_VARCHAR2_TABLE_100();

Line 775: a23 := JTF_VARCHAR2_TABLE_100();

771: a19 := JTF_NUMBER_TABLE();
772: a20 := JTF_VARCHAR2_TABLE_200();
773: a21 := JTF_VARCHAR2_TABLE_100();
774: a22 := JTF_NUMBER_TABLE();
775: a23 := JTF_VARCHAR2_TABLE_100();
776: a24 := JTF_NUMBER_TABLE();
777: a25 := JTF_VARCHAR2_TABLE_100();
778: a26 := JTF_NUMBER_TABLE();
779: a27 := JTF_VARCHAR2_TABLE_100();

Line 777: a25 := JTF_VARCHAR2_TABLE_100();

773: a21 := JTF_VARCHAR2_TABLE_100();
774: a22 := JTF_NUMBER_TABLE();
775: a23 := JTF_VARCHAR2_TABLE_100();
776: a24 := JTF_NUMBER_TABLE();
777: a25 := JTF_VARCHAR2_TABLE_100();
778: a26 := JTF_NUMBER_TABLE();
779: a27 := JTF_VARCHAR2_TABLE_100();
780: a28 := JTF_NUMBER_TABLE();
781: a29 := JTF_VARCHAR2_TABLE_100();

Line 779: a27 := JTF_VARCHAR2_TABLE_100();

775: a23 := JTF_VARCHAR2_TABLE_100();
776: a24 := JTF_NUMBER_TABLE();
777: a25 := JTF_VARCHAR2_TABLE_100();
778: a26 := JTF_NUMBER_TABLE();
779: a27 := JTF_VARCHAR2_TABLE_100();
780: a28 := JTF_NUMBER_TABLE();
781: a29 := JTF_VARCHAR2_TABLE_100();
782: a30 := JTF_NUMBER_TABLE();
783: a31 := JTF_VARCHAR2_TABLE_100();

Line 781: a29 := JTF_VARCHAR2_TABLE_100();

777: a25 := JTF_VARCHAR2_TABLE_100();
778: a26 := JTF_NUMBER_TABLE();
779: a27 := JTF_VARCHAR2_TABLE_100();
780: a28 := JTF_NUMBER_TABLE();
781: a29 := JTF_VARCHAR2_TABLE_100();
782: a30 := JTF_NUMBER_TABLE();
783: a31 := JTF_VARCHAR2_TABLE_100();
784: a32 := JTF_NUMBER_TABLE();
785: a33 := JTF_VARCHAR2_TABLE_100();

Line 783: a31 := JTF_VARCHAR2_TABLE_100();

779: a27 := JTF_VARCHAR2_TABLE_100();
780: a28 := JTF_NUMBER_TABLE();
781: a29 := JTF_VARCHAR2_TABLE_100();
782: a30 := JTF_NUMBER_TABLE();
783: a31 := JTF_VARCHAR2_TABLE_100();
784: a32 := JTF_NUMBER_TABLE();
785: a33 := JTF_VARCHAR2_TABLE_100();
786: a34 := JTF_VARCHAR2_TABLE_100();
787: if t.count > 0 then

Line 785: a33 := JTF_VARCHAR2_TABLE_100();

781: a29 := JTF_VARCHAR2_TABLE_100();
782: a30 := JTF_NUMBER_TABLE();
783: a31 := JTF_VARCHAR2_TABLE_100();
784: a32 := JTF_NUMBER_TABLE();
785: a33 := JTF_VARCHAR2_TABLE_100();
786: a34 := JTF_VARCHAR2_TABLE_100();
787: if t.count > 0 then
788: a0.extend(t.count);
789: a1.extend(t.count);

Line 786: a34 := JTF_VARCHAR2_TABLE_100();

782: a30 := JTF_NUMBER_TABLE();
783: a31 := JTF_VARCHAR2_TABLE_100();
784: a32 := JTF_NUMBER_TABLE();
785: a33 := JTF_VARCHAR2_TABLE_100();
786: a34 := JTF_VARCHAR2_TABLE_100();
787: if t.count > 0 then
788: a0.extend(t.count);
789: a1.extend(t.count);
790: a2.extend(t.count);

Line 880: , a9 JTF_VARCHAR2_TABLE_100

876: , a5 JTF_VARCHAR2_TABLE_300
877: , a6 JTF_NUMBER_TABLE
878: , a7 JTF_VARCHAR2_TABLE_200
879: , a8 JTF_VARCHAR2_TABLE_2000
880: , a9 JTF_VARCHAR2_TABLE_100
881: , a10 JTF_VARCHAR2_TABLE_100
882: , a11 JTF_NUMBER_TABLE
883: , a12 JTF_NUMBER_TABLE
884: , a13 JTF_VARCHAR2_TABLE_200

Line 881: , a10 JTF_VARCHAR2_TABLE_100

877: , a6 JTF_NUMBER_TABLE
878: , a7 JTF_VARCHAR2_TABLE_200
879: , a8 JTF_VARCHAR2_TABLE_2000
880: , a9 JTF_VARCHAR2_TABLE_100
881: , a10 JTF_VARCHAR2_TABLE_100
882: , a11 JTF_NUMBER_TABLE
883: , a12 JTF_NUMBER_TABLE
884: , a13 JTF_VARCHAR2_TABLE_200
885: , a14 JTF_VARCHAR2_TABLE_100

Line 885: , a14 JTF_VARCHAR2_TABLE_100

881: , a10 JTF_VARCHAR2_TABLE_100
882: , a11 JTF_NUMBER_TABLE
883: , a12 JTF_NUMBER_TABLE
884: , a13 JTF_VARCHAR2_TABLE_200
885: , a14 JTF_VARCHAR2_TABLE_100
886: , a15 JTF_DATE_TABLE
887: , a16 JTF_DATE_TABLE
888: , a17 JTF_NUMBER_TABLE
889: , a18 JTF_VARCHAR2_TABLE_100

Line 889: , a18 JTF_VARCHAR2_TABLE_100

885: , a14 JTF_VARCHAR2_TABLE_100
886: , a15 JTF_DATE_TABLE
887: , a16 JTF_DATE_TABLE
888: , a17 JTF_NUMBER_TABLE
889: , a18 JTF_VARCHAR2_TABLE_100
890: , a19 JTF_VARCHAR2_TABLE_100
891: ) as
892: ddindx binary_integer; indx binary_integer;
893: begin

Line 890: , a19 JTF_VARCHAR2_TABLE_100

886: , a15 JTF_DATE_TABLE
887: , a16 JTF_DATE_TABLE
888: , a17 JTF_NUMBER_TABLE
889: , a18 JTF_VARCHAR2_TABLE_100
890: , a19 JTF_VARCHAR2_TABLE_100
891: ) as
892: ddindx binary_integer; indx binary_integer;
893: begin
894: if a0 is not null and a0.count > 0 then

Line 937: , a9 out nocopy JTF_VARCHAR2_TABLE_100

933: , a5 out nocopy JTF_VARCHAR2_TABLE_300
934: , a6 out nocopy JTF_NUMBER_TABLE
935: , a7 out nocopy JTF_VARCHAR2_TABLE_200
936: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
937: , a9 out nocopy JTF_VARCHAR2_TABLE_100
938: , a10 out nocopy JTF_VARCHAR2_TABLE_100
939: , a11 out nocopy JTF_NUMBER_TABLE
940: , a12 out nocopy JTF_NUMBER_TABLE
941: , a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 938: , a10 out nocopy JTF_VARCHAR2_TABLE_100

934: , a6 out nocopy JTF_NUMBER_TABLE
935: , a7 out nocopy JTF_VARCHAR2_TABLE_200
936: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
937: , a9 out nocopy JTF_VARCHAR2_TABLE_100
938: , a10 out nocopy JTF_VARCHAR2_TABLE_100
939: , a11 out nocopy JTF_NUMBER_TABLE
940: , a12 out nocopy JTF_NUMBER_TABLE
941: , a13 out nocopy JTF_VARCHAR2_TABLE_200
942: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 942: , a14 out nocopy JTF_VARCHAR2_TABLE_100

938: , a10 out nocopy JTF_VARCHAR2_TABLE_100
939: , a11 out nocopy JTF_NUMBER_TABLE
940: , a12 out nocopy JTF_NUMBER_TABLE
941: , a13 out nocopy JTF_VARCHAR2_TABLE_200
942: , a14 out nocopy JTF_VARCHAR2_TABLE_100
943: , a15 out nocopy JTF_DATE_TABLE
944: , a16 out nocopy JTF_DATE_TABLE
945: , a17 out nocopy JTF_NUMBER_TABLE
946: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 946: , a18 out nocopy JTF_VARCHAR2_TABLE_100

942: , a14 out nocopy JTF_VARCHAR2_TABLE_100
943: , a15 out nocopy JTF_DATE_TABLE
944: , a16 out nocopy JTF_DATE_TABLE
945: , a17 out nocopy JTF_NUMBER_TABLE
946: , a18 out nocopy JTF_VARCHAR2_TABLE_100
947: , a19 out nocopy JTF_VARCHAR2_TABLE_100
948: ) as
949: ddindx binary_integer; indx binary_integer;
950: begin

Line 947: , a19 out nocopy JTF_VARCHAR2_TABLE_100

943: , a15 out nocopy JTF_DATE_TABLE
944: , a16 out nocopy JTF_DATE_TABLE
945: , a17 out nocopy JTF_NUMBER_TABLE
946: , a18 out nocopy JTF_VARCHAR2_TABLE_100
947: , a19 out nocopy JTF_VARCHAR2_TABLE_100
948: ) as
949: ddindx binary_integer; indx binary_integer;
950: begin
951: if t is null or t.count = 0 then

Line 961: a9 := JTF_VARCHAR2_TABLE_100();

957: a5 := JTF_VARCHAR2_TABLE_300();
958: a6 := JTF_NUMBER_TABLE();
959: a7 := JTF_VARCHAR2_TABLE_200();
960: a8 := JTF_VARCHAR2_TABLE_2000();
961: a9 := JTF_VARCHAR2_TABLE_100();
962: a10 := JTF_VARCHAR2_TABLE_100();
963: a11 := JTF_NUMBER_TABLE();
964: a12 := JTF_NUMBER_TABLE();
965: a13 := JTF_VARCHAR2_TABLE_200();

Line 962: a10 := JTF_VARCHAR2_TABLE_100();

958: a6 := JTF_NUMBER_TABLE();
959: a7 := JTF_VARCHAR2_TABLE_200();
960: a8 := JTF_VARCHAR2_TABLE_2000();
961: a9 := JTF_VARCHAR2_TABLE_100();
962: a10 := JTF_VARCHAR2_TABLE_100();
963: a11 := JTF_NUMBER_TABLE();
964: a12 := JTF_NUMBER_TABLE();
965: a13 := JTF_VARCHAR2_TABLE_200();
966: a14 := JTF_VARCHAR2_TABLE_100();

Line 966: a14 := JTF_VARCHAR2_TABLE_100();

962: a10 := JTF_VARCHAR2_TABLE_100();
963: a11 := JTF_NUMBER_TABLE();
964: a12 := JTF_NUMBER_TABLE();
965: a13 := JTF_VARCHAR2_TABLE_200();
966: a14 := JTF_VARCHAR2_TABLE_100();
967: a15 := JTF_DATE_TABLE();
968: a16 := JTF_DATE_TABLE();
969: a17 := JTF_NUMBER_TABLE();
970: a18 := JTF_VARCHAR2_TABLE_100();

Line 970: a18 := JTF_VARCHAR2_TABLE_100();

966: a14 := JTF_VARCHAR2_TABLE_100();
967: a15 := JTF_DATE_TABLE();
968: a16 := JTF_DATE_TABLE();
969: a17 := JTF_NUMBER_TABLE();
970: a18 := JTF_VARCHAR2_TABLE_100();
971: a19 := JTF_VARCHAR2_TABLE_100();
972: else
973: a0 := JTF_NUMBER_TABLE();
974: a1 := JTF_VARCHAR2_TABLE_200();

Line 971: a19 := JTF_VARCHAR2_TABLE_100();

967: a15 := JTF_DATE_TABLE();
968: a16 := JTF_DATE_TABLE();
969: a17 := JTF_NUMBER_TABLE();
970: a18 := JTF_VARCHAR2_TABLE_100();
971: a19 := JTF_VARCHAR2_TABLE_100();
972: else
973: a0 := JTF_NUMBER_TABLE();
974: a1 := JTF_VARCHAR2_TABLE_200();
975: a2 := JTF_VARCHAR2_TABLE_200();

Line 982: a9 := JTF_VARCHAR2_TABLE_100();

978: a5 := JTF_VARCHAR2_TABLE_300();
979: a6 := JTF_NUMBER_TABLE();
980: a7 := JTF_VARCHAR2_TABLE_200();
981: a8 := JTF_VARCHAR2_TABLE_2000();
982: a9 := JTF_VARCHAR2_TABLE_100();
983: a10 := JTF_VARCHAR2_TABLE_100();
984: a11 := JTF_NUMBER_TABLE();
985: a12 := JTF_NUMBER_TABLE();
986: a13 := JTF_VARCHAR2_TABLE_200();

Line 983: a10 := JTF_VARCHAR2_TABLE_100();

979: a6 := JTF_NUMBER_TABLE();
980: a7 := JTF_VARCHAR2_TABLE_200();
981: a8 := JTF_VARCHAR2_TABLE_2000();
982: a9 := JTF_VARCHAR2_TABLE_100();
983: a10 := JTF_VARCHAR2_TABLE_100();
984: a11 := JTF_NUMBER_TABLE();
985: a12 := JTF_NUMBER_TABLE();
986: a13 := JTF_VARCHAR2_TABLE_200();
987: a14 := JTF_VARCHAR2_TABLE_100();

Line 987: a14 := JTF_VARCHAR2_TABLE_100();

983: a10 := JTF_VARCHAR2_TABLE_100();
984: a11 := JTF_NUMBER_TABLE();
985: a12 := JTF_NUMBER_TABLE();
986: a13 := JTF_VARCHAR2_TABLE_200();
987: a14 := JTF_VARCHAR2_TABLE_100();
988: a15 := JTF_DATE_TABLE();
989: a16 := JTF_DATE_TABLE();
990: a17 := JTF_NUMBER_TABLE();
991: a18 := JTF_VARCHAR2_TABLE_100();

Line 991: a18 := JTF_VARCHAR2_TABLE_100();

987: a14 := JTF_VARCHAR2_TABLE_100();
988: a15 := JTF_DATE_TABLE();
989: a16 := JTF_DATE_TABLE();
990: a17 := JTF_NUMBER_TABLE();
991: a18 := JTF_VARCHAR2_TABLE_100();
992: a19 := JTF_VARCHAR2_TABLE_100();
993: if t.count > 0 then
994: a0.extend(t.count);
995: a1.extend(t.count);

Line 992: a19 := JTF_VARCHAR2_TABLE_100();

988: a15 := JTF_DATE_TABLE();
989: a16 := JTF_DATE_TABLE();
990: a17 := JTF_NUMBER_TABLE();
991: a18 := JTF_VARCHAR2_TABLE_100();
992: a19 := JTF_VARCHAR2_TABLE_100();
993: if t.count > 0 then
994: a0.extend(t.count);
995: a1.extend(t.count);
996: a2.extend(t.count);

Line 1050: , a3 JTF_VARCHAR2_TABLE_100

1046:
1047: procedure rosetta_table_copy_in_p30(t out nocopy oks_entitlements_pub.get_contop_tbl, a0 JTF_NUMBER_TABLE
1048: , a1 JTF_VARCHAR2_TABLE_200
1049: , a2 JTF_VARCHAR2_TABLE_200
1050: , a3 JTF_VARCHAR2_TABLE_100
1051: , a4 JTF_NUMBER_TABLE
1052: , a5 JTF_VARCHAR2_TABLE_300
1053: , a6 JTF_VARCHAR2_TABLE_300
1054: , a7 JTF_NUMBER_TABLE

Line 1057: , a10 JTF_VARCHAR2_TABLE_100

1053: , a6 JTF_VARCHAR2_TABLE_300
1054: , a7 JTF_NUMBER_TABLE
1055: , a8 JTF_VARCHAR2_TABLE_200
1056: , a9 JTF_VARCHAR2_TABLE_2000
1057: , a10 JTF_VARCHAR2_TABLE_100
1058: , a11 JTF_VARCHAR2_TABLE_100
1059: , a12 JTF_NUMBER_TABLE
1060: , a13 JTF_DATE_TABLE
1061: , a14 JTF_DATE_TABLE

Line 1058: , a11 JTF_VARCHAR2_TABLE_100

1054: , a7 JTF_NUMBER_TABLE
1055: , a8 JTF_VARCHAR2_TABLE_200
1056: , a9 JTF_VARCHAR2_TABLE_2000
1057: , a10 JTF_VARCHAR2_TABLE_100
1058: , a11 JTF_VARCHAR2_TABLE_100
1059: , a12 JTF_NUMBER_TABLE
1060: , a13 JTF_DATE_TABLE
1061: , a14 JTF_DATE_TABLE
1062: , a15 JTF_VARCHAR2_TABLE_100

Line 1062: , a15 JTF_VARCHAR2_TABLE_100

1058: , a11 JTF_VARCHAR2_TABLE_100
1059: , a12 JTF_NUMBER_TABLE
1060: , a13 JTF_DATE_TABLE
1061: , a14 JTF_DATE_TABLE
1062: , a15 JTF_VARCHAR2_TABLE_100
1063: , a16 JTF_VARCHAR2_TABLE_100
1064: , a17 JTF_DATE_TABLE
1065: , a18 JTF_DATE_TABLE
1066: , a19 JTF_VARCHAR2_TABLE_100

Line 1063: , a16 JTF_VARCHAR2_TABLE_100

1059: , a12 JTF_NUMBER_TABLE
1060: , a13 JTF_DATE_TABLE
1061: , a14 JTF_DATE_TABLE
1062: , a15 JTF_VARCHAR2_TABLE_100
1063: , a16 JTF_VARCHAR2_TABLE_100
1064: , a17 JTF_DATE_TABLE
1065: , a18 JTF_DATE_TABLE
1066: , a19 JTF_VARCHAR2_TABLE_100
1067: , a20 JTF_VARCHAR2_TABLE_2000

Line 1066: , a19 JTF_VARCHAR2_TABLE_100

1062: , a15 JTF_VARCHAR2_TABLE_100
1063: , a16 JTF_VARCHAR2_TABLE_100
1064: , a17 JTF_DATE_TABLE
1065: , a18 JTF_DATE_TABLE
1066: , a19 JTF_VARCHAR2_TABLE_100
1067: , a20 JTF_VARCHAR2_TABLE_2000
1068: , a21 JTF_DATE_TABLE
1069: , a22 JTF_VARCHAR2_TABLE_100
1070: , a23 JTF_VARCHAR2_TABLE_500

Line 1069: , a22 JTF_VARCHAR2_TABLE_100

1065: , a18 JTF_DATE_TABLE
1066: , a19 JTF_VARCHAR2_TABLE_100
1067: , a20 JTF_VARCHAR2_TABLE_2000
1068: , a21 JTF_DATE_TABLE
1069: , a22 JTF_VARCHAR2_TABLE_100
1070: , a23 JTF_VARCHAR2_TABLE_500
1071: , a24 JTF_VARCHAR2_TABLE_100
1072: , a25 JTF_VARCHAR2_TABLE_500
1073: , a26 JTF_VARCHAR2_TABLE_100

Line 1071: , a24 JTF_VARCHAR2_TABLE_100

1067: , a20 JTF_VARCHAR2_TABLE_2000
1068: , a21 JTF_DATE_TABLE
1069: , a22 JTF_VARCHAR2_TABLE_100
1070: , a23 JTF_VARCHAR2_TABLE_500
1071: , a24 JTF_VARCHAR2_TABLE_100
1072: , a25 JTF_VARCHAR2_TABLE_500
1073: , a26 JTF_VARCHAR2_TABLE_100
1074: , a27 JTF_NUMBER_TABLE
1075: ) as

Line 1073: , a26 JTF_VARCHAR2_TABLE_100

1069: , a22 JTF_VARCHAR2_TABLE_100
1070: , a23 JTF_VARCHAR2_TABLE_500
1071: , a24 JTF_VARCHAR2_TABLE_100
1072: , a25 JTF_VARCHAR2_TABLE_500
1073: , a26 JTF_VARCHAR2_TABLE_100
1074: , a27 JTF_NUMBER_TABLE
1075: ) as
1076: ddindx binary_integer; indx binary_integer;
1077: begin

Line 1123: , a3 out nocopy JTF_VARCHAR2_TABLE_100

1119: end rosetta_table_copy_in_p30;
1120: procedure rosetta_table_copy_out_p30(t oks_entitlements_pub.get_contop_tbl, a0 out nocopy JTF_NUMBER_TABLE
1121: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1122: , a2 out nocopy JTF_VARCHAR2_TABLE_200
1123: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1124: , a4 out nocopy JTF_NUMBER_TABLE
1125: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1126: , a6 out nocopy JTF_VARCHAR2_TABLE_300
1127: , a7 out nocopy JTF_NUMBER_TABLE

Line 1130: , a10 out nocopy JTF_VARCHAR2_TABLE_100

1126: , a6 out nocopy JTF_VARCHAR2_TABLE_300
1127: , a7 out nocopy JTF_NUMBER_TABLE
1128: , a8 out nocopy JTF_VARCHAR2_TABLE_200
1129: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
1130: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1131: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1132: , a12 out nocopy JTF_NUMBER_TABLE
1133: , a13 out nocopy JTF_DATE_TABLE
1134: , a14 out nocopy JTF_DATE_TABLE

Line 1131: , a11 out nocopy JTF_VARCHAR2_TABLE_100

1127: , a7 out nocopy JTF_NUMBER_TABLE
1128: , a8 out nocopy JTF_VARCHAR2_TABLE_200
1129: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
1130: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1131: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1132: , a12 out nocopy JTF_NUMBER_TABLE
1133: , a13 out nocopy JTF_DATE_TABLE
1134: , a14 out nocopy JTF_DATE_TABLE
1135: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1135: , a15 out nocopy JTF_VARCHAR2_TABLE_100

1131: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1132: , a12 out nocopy JTF_NUMBER_TABLE
1133: , a13 out nocopy JTF_DATE_TABLE
1134: , a14 out nocopy JTF_DATE_TABLE
1135: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1136: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1137: , a17 out nocopy JTF_DATE_TABLE
1138: , a18 out nocopy JTF_DATE_TABLE
1139: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 1136: , a16 out nocopy JTF_VARCHAR2_TABLE_100

1132: , a12 out nocopy JTF_NUMBER_TABLE
1133: , a13 out nocopy JTF_DATE_TABLE
1134: , a14 out nocopy JTF_DATE_TABLE
1135: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1136: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1137: , a17 out nocopy JTF_DATE_TABLE
1138: , a18 out nocopy JTF_DATE_TABLE
1139: , a19 out nocopy JTF_VARCHAR2_TABLE_100
1140: , a20 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1139: , a19 out nocopy JTF_VARCHAR2_TABLE_100

1135: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1136: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1137: , a17 out nocopy JTF_DATE_TABLE
1138: , a18 out nocopy JTF_DATE_TABLE
1139: , a19 out nocopy JTF_VARCHAR2_TABLE_100
1140: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
1141: , a21 out nocopy JTF_DATE_TABLE
1142: , a22 out nocopy JTF_VARCHAR2_TABLE_100
1143: , a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 1142: , a22 out nocopy JTF_VARCHAR2_TABLE_100

1138: , a18 out nocopy JTF_DATE_TABLE
1139: , a19 out nocopy JTF_VARCHAR2_TABLE_100
1140: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
1141: , a21 out nocopy JTF_DATE_TABLE
1142: , a22 out nocopy JTF_VARCHAR2_TABLE_100
1143: , a23 out nocopy JTF_VARCHAR2_TABLE_500
1144: , a24 out nocopy JTF_VARCHAR2_TABLE_100
1145: , a25 out nocopy JTF_VARCHAR2_TABLE_500
1146: , a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 1144: , a24 out nocopy JTF_VARCHAR2_TABLE_100

1140: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
1141: , a21 out nocopy JTF_DATE_TABLE
1142: , a22 out nocopy JTF_VARCHAR2_TABLE_100
1143: , a23 out nocopy JTF_VARCHAR2_TABLE_500
1144: , a24 out nocopy JTF_VARCHAR2_TABLE_100
1145: , a25 out nocopy JTF_VARCHAR2_TABLE_500
1146: , a26 out nocopy JTF_VARCHAR2_TABLE_100
1147: , a27 out nocopy JTF_NUMBER_TABLE
1148: ) as

Line 1146: , a26 out nocopy JTF_VARCHAR2_TABLE_100

1142: , a22 out nocopy JTF_VARCHAR2_TABLE_100
1143: , a23 out nocopy JTF_VARCHAR2_TABLE_500
1144: , a24 out nocopy JTF_VARCHAR2_TABLE_100
1145: , a25 out nocopy JTF_VARCHAR2_TABLE_500
1146: , a26 out nocopy JTF_VARCHAR2_TABLE_100
1147: , a27 out nocopy JTF_NUMBER_TABLE
1148: ) as
1149: ddindx binary_integer; indx binary_integer;
1150: begin

Line 1155: a3 := JTF_VARCHAR2_TABLE_100();

1151: if t is null or t.count = 0 then
1152: a0 := JTF_NUMBER_TABLE();
1153: a1 := JTF_VARCHAR2_TABLE_200();
1154: a2 := JTF_VARCHAR2_TABLE_200();
1155: a3 := JTF_VARCHAR2_TABLE_100();
1156: a4 := JTF_NUMBER_TABLE();
1157: a5 := JTF_VARCHAR2_TABLE_300();
1158: a6 := JTF_VARCHAR2_TABLE_300();
1159: a7 := JTF_NUMBER_TABLE();

Line 1162: a10 := JTF_VARCHAR2_TABLE_100();

1158: a6 := JTF_VARCHAR2_TABLE_300();
1159: a7 := JTF_NUMBER_TABLE();
1160: a8 := JTF_VARCHAR2_TABLE_200();
1161: a9 := JTF_VARCHAR2_TABLE_2000();
1162: a10 := JTF_VARCHAR2_TABLE_100();
1163: a11 := JTF_VARCHAR2_TABLE_100();
1164: a12 := JTF_NUMBER_TABLE();
1165: a13 := JTF_DATE_TABLE();
1166: a14 := JTF_DATE_TABLE();

Line 1163: a11 := JTF_VARCHAR2_TABLE_100();

1159: a7 := JTF_NUMBER_TABLE();
1160: a8 := JTF_VARCHAR2_TABLE_200();
1161: a9 := JTF_VARCHAR2_TABLE_2000();
1162: a10 := JTF_VARCHAR2_TABLE_100();
1163: a11 := JTF_VARCHAR2_TABLE_100();
1164: a12 := JTF_NUMBER_TABLE();
1165: a13 := JTF_DATE_TABLE();
1166: a14 := JTF_DATE_TABLE();
1167: a15 := JTF_VARCHAR2_TABLE_100();

Line 1167: a15 := JTF_VARCHAR2_TABLE_100();

1163: a11 := JTF_VARCHAR2_TABLE_100();
1164: a12 := JTF_NUMBER_TABLE();
1165: a13 := JTF_DATE_TABLE();
1166: a14 := JTF_DATE_TABLE();
1167: a15 := JTF_VARCHAR2_TABLE_100();
1168: a16 := JTF_VARCHAR2_TABLE_100();
1169: a17 := JTF_DATE_TABLE();
1170: a18 := JTF_DATE_TABLE();
1171: a19 := JTF_VARCHAR2_TABLE_100();

Line 1168: a16 := JTF_VARCHAR2_TABLE_100();

1164: a12 := JTF_NUMBER_TABLE();
1165: a13 := JTF_DATE_TABLE();
1166: a14 := JTF_DATE_TABLE();
1167: a15 := JTF_VARCHAR2_TABLE_100();
1168: a16 := JTF_VARCHAR2_TABLE_100();
1169: a17 := JTF_DATE_TABLE();
1170: a18 := JTF_DATE_TABLE();
1171: a19 := JTF_VARCHAR2_TABLE_100();
1172: a20 := JTF_VARCHAR2_TABLE_2000();

Line 1171: a19 := JTF_VARCHAR2_TABLE_100();

1167: a15 := JTF_VARCHAR2_TABLE_100();
1168: a16 := JTF_VARCHAR2_TABLE_100();
1169: a17 := JTF_DATE_TABLE();
1170: a18 := JTF_DATE_TABLE();
1171: a19 := JTF_VARCHAR2_TABLE_100();
1172: a20 := JTF_VARCHAR2_TABLE_2000();
1173: a21 := JTF_DATE_TABLE();
1174: a22 := JTF_VARCHAR2_TABLE_100();
1175: a23 := JTF_VARCHAR2_TABLE_500();

Line 1174: a22 := JTF_VARCHAR2_TABLE_100();

1170: a18 := JTF_DATE_TABLE();
1171: a19 := JTF_VARCHAR2_TABLE_100();
1172: a20 := JTF_VARCHAR2_TABLE_2000();
1173: a21 := JTF_DATE_TABLE();
1174: a22 := JTF_VARCHAR2_TABLE_100();
1175: a23 := JTF_VARCHAR2_TABLE_500();
1176: a24 := JTF_VARCHAR2_TABLE_100();
1177: a25 := JTF_VARCHAR2_TABLE_500();
1178: a26 := JTF_VARCHAR2_TABLE_100();

Line 1176: a24 := JTF_VARCHAR2_TABLE_100();

1172: a20 := JTF_VARCHAR2_TABLE_2000();
1173: a21 := JTF_DATE_TABLE();
1174: a22 := JTF_VARCHAR2_TABLE_100();
1175: a23 := JTF_VARCHAR2_TABLE_500();
1176: a24 := JTF_VARCHAR2_TABLE_100();
1177: a25 := JTF_VARCHAR2_TABLE_500();
1178: a26 := JTF_VARCHAR2_TABLE_100();
1179: a27 := JTF_NUMBER_TABLE();
1180: else

Line 1178: a26 := JTF_VARCHAR2_TABLE_100();

1174: a22 := JTF_VARCHAR2_TABLE_100();
1175: a23 := JTF_VARCHAR2_TABLE_500();
1176: a24 := JTF_VARCHAR2_TABLE_100();
1177: a25 := JTF_VARCHAR2_TABLE_500();
1178: a26 := JTF_VARCHAR2_TABLE_100();
1179: a27 := JTF_NUMBER_TABLE();
1180: else
1181: a0 := JTF_NUMBER_TABLE();
1182: a1 := JTF_VARCHAR2_TABLE_200();

Line 1184: a3 := JTF_VARCHAR2_TABLE_100();

1180: else
1181: a0 := JTF_NUMBER_TABLE();
1182: a1 := JTF_VARCHAR2_TABLE_200();
1183: a2 := JTF_VARCHAR2_TABLE_200();
1184: a3 := JTF_VARCHAR2_TABLE_100();
1185: a4 := JTF_NUMBER_TABLE();
1186: a5 := JTF_VARCHAR2_TABLE_300();
1187: a6 := JTF_VARCHAR2_TABLE_300();
1188: a7 := JTF_NUMBER_TABLE();

Line 1191: a10 := JTF_VARCHAR2_TABLE_100();

1187: a6 := JTF_VARCHAR2_TABLE_300();
1188: a7 := JTF_NUMBER_TABLE();
1189: a8 := JTF_VARCHAR2_TABLE_200();
1190: a9 := JTF_VARCHAR2_TABLE_2000();
1191: a10 := JTF_VARCHAR2_TABLE_100();
1192: a11 := JTF_VARCHAR2_TABLE_100();
1193: a12 := JTF_NUMBER_TABLE();
1194: a13 := JTF_DATE_TABLE();
1195: a14 := JTF_DATE_TABLE();

Line 1192: a11 := JTF_VARCHAR2_TABLE_100();

1188: a7 := JTF_NUMBER_TABLE();
1189: a8 := JTF_VARCHAR2_TABLE_200();
1190: a9 := JTF_VARCHAR2_TABLE_2000();
1191: a10 := JTF_VARCHAR2_TABLE_100();
1192: a11 := JTF_VARCHAR2_TABLE_100();
1193: a12 := JTF_NUMBER_TABLE();
1194: a13 := JTF_DATE_TABLE();
1195: a14 := JTF_DATE_TABLE();
1196: a15 := JTF_VARCHAR2_TABLE_100();

Line 1196: a15 := JTF_VARCHAR2_TABLE_100();

1192: a11 := JTF_VARCHAR2_TABLE_100();
1193: a12 := JTF_NUMBER_TABLE();
1194: a13 := JTF_DATE_TABLE();
1195: a14 := JTF_DATE_TABLE();
1196: a15 := JTF_VARCHAR2_TABLE_100();
1197: a16 := JTF_VARCHAR2_TABLE_100();
1198: a17 := JTF_DATE_TABLE();
1199: a18 := JTF_DATE_TABLE();
1200: a19 := JTF_VARCHAR2_TABLE_100();

Line 1197: a16 := JTF_VARCHAR2_TABLE_100();

1193: a12 := JTF_NUMBER_TABLE();
1194: a13 := JTF_DATE_TABLE();
1195: a14 := JTF_DATE_TABLE();
1196: a15 := JTF_VARCHAR2_TABLE_100();
1197: a16 := JTF_VARCHAR2_TABLE_100();
1198: a17 := JTF_DATE_TABLE();
1199: a18 := JTF_DATE_TABLE();
1200: a19 := JTF_VARCHAR2_TABLE_100();
1201: a20 := JTF_VARCHAR2_TABLE_2000();

Line 1200: a19 := JTF_VARCHAR2_TABLE_100();

1196: a15 := JTF_VARCHAR2_TABLE_100();
1197: a16 := JTF_VARCHAR2_TABLE_100();
1198: a17 := JTF_DATE_TABLE();
1199: a18 := JTF_DATE_TABLE();
1200: a19 := JTF_VARCHAR2_TABLE_100();
1201: a20 := JTF_VARCHAR2_TABLE_2000();
1202: a21 := JTF_DATE_TABLE();
1203: a22 := JTF_VARCHAR2_TABLE_100();
1204: a23 := JTF_VARCHAR2_TABLE_500();

Line 1203: a22 := JTF_VARCHAR2_TABLE_100();

1199: a18 := JTF_DATE_TABLE();
1200: a19 := JTF_VARCHAR2_TABLE_100();
1201: a20 := JTF_VARCHAR2_TABLE_2000();
1202: a21 := JTF_DATE_TABLE();
1203: a22 := JTF_VARCHAR2_TABLE_100();
1204: a23 := JTF_VARCHAR2_TABLE_500();
1205: a24 := JTF_VARCHAR2_TABLE_100();
1206: a25 := JTF_VARCHAR2_TABLE_500();
1207: a26 := JTF_VARCHAR2_TABLE_100();

Line 1205: a24 := JTF_VARCHAR2_TABLE_100();

1201: a20 := JTF_VARCHAR2_TABLE_2000();
1202: a21 := JTF_DATE_TABLE();
1203: a22 := JTF_VARCHAR2_TABLE_100();
1204: a23 := JTF_VARCHAR2_TABLE_500();
1205: a24 := JTF_VARCHAR2_TABLE_100();
1206: a25 := JTF_VARCHAR2_TABLE_500();
1207: a26 := JTF_VARCHAR2_TABLE_100();
1208: a27 := JTF_NUMBER_TABLE();
1209: if t.count > 0 then

Line 1207: a26 := JTF_VARCHAR2_TABLE_100();

1203: a22 := JTF_VARCHAR2_TABLE_100();
1204: a23 := JTF_VARCHAR2_TABLE_500();
1205: a24 := JTF_VARCHAR2_TABLE_100();
1206: a25 := JTF_VARCHAR2_TABLE_500();
1207: a26 := JTF_VARCHAR2_TABLE_100();
1208: a27 := JTF_NUMBER_TABLE();
1209: if t.count > 0 then
1210: a0.extend(t.count);
1211: a1.extend(t.count);

Line 1282: , a3 JTF_VARCHAR2_TABLE_100

1278:
1279: procedure rosetta_table_copy_in_p34(t out nocopy oks_entitlements_pub.output_tbl_ib, a0 JTF_NUMBER_TABLE
1280: , a1 JTF_VARCHAR2_TABLE_200
1281: , a2 JTF_VARCHAR2_TABLE_200
1282: , a3 JTF_VARCHAR2_TABLE_100
1283: , a4 JTF_NUMBER_TABLE
1284: , a5 JTF_VARCHAR2_TABLE_300
1285: , a6 JTF_VARCHAR2_TABLE_300
1286: , a7 JTF_NUMBER_TABLE

Line 1289: , a10 JTF_VARCHAR2_TABLE_100

1285: , a6 JTF_VARCHAR2_TABLE_300
1286: , a7 JTF_NUMBER_TABLE
1287: , a8 JTF_VARCHAR2_TABLE_200
1288: , a9 JTF_VARCHAR2_TABLE_2000
1289: , a10 JTF_VARCHAR2_TABLE_100
1290: , a11 JTF_NUMBER_TABLE
1291: , a12 JTF_DATE_TABLE
1292: , a13 JTF_DATE_TABLE
1293: , a14 JTF_VARCHAR2_TABLE_100

Line 1293: , a14 JTF_VARCHAR2_TABLE_100

1289: , a10 JTF_VARCHAR2_TABLE_100
1290: , a11 JTF_NUMBER_TABLE
1291: , a12 JTF_DATE_TABLE
1292: , a13 JTF_DATE_TABLE
1293: , a14 JTF_VARCHAR2_TABLE_100
1294: , a15 JTF_VARCHAR2_TABLE_100
1295: , a16 JTF_DATE_TABLE
1296: , a17 JTF_DATE_TABLE
1297: , a18 JTF_VARCHAR2_TABLE_100

Line 1294: , a15 JTF_VARCHAR2_TABLE_100

1290: , a11 JTF_NUMBER_TABLE
1291: , a12 JTF_DATE_TABLE
1292: , a13 JTF_DATE_TABLE
1293: , a14 JTF_VARCHAR2_TABLE_100
1294: , a15 JTF_VARCHAR2_TABLE_100
1295: , a16 JTF_DATE_TABLE
1296: , a17 JTF_DATE_TABLE
1297: , a18 JTF_VARCHAR2_TABLE_100
1298: , a19 JTF_VARCHAR2_TABLE_2000

Line 1297: , a18 JTF_VARCHAR2_TABLE_100

1293: , a14 JTF_VARCHAR2_TABLE_100
1294: , a15 JTF_VARCHAR2_TABLE_100
1295: , a16 JTF_DATE_TABLE
1296: , a17 JTF_DATE_TABLE
1297: , a18 JTF_VARCHAR2_TABLE_100
1298: , a19 JTF_VARCHAR2_TABLE_2000
1299: , a20 JTF_DATE_TABLE
1300: , a21 JTF_NUMBER_TABLE
1301: ) as

Line 1343: , a3 out nocopy JTF_VARCHAR2_TABLE_100

1339: end rosetta_table_copy_in_p34;
1340: procedure rosetta_table_copy_out_p34(t oks_entitlements_pub.output_tbl_ib, a0 out nocopy JTF_NUMBER_TABLE
1341: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1342: , a2 out nocopy JTF_VARCHAR2_TABLE_200
1343: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1344: , a4 out nocopy JTF_NUMBER_TABLE
1345: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1346: , a6 out nocopy JTF_VARCHAR2_TABLE_300
1347: , a7 out nocopy JTF_NUMBER_TABLE

Line 1350: , a10 out nocopy JTF_VARCHAR2_TABLE_100

1346: , a6 out nocopy JTF_VARCHAR2_TABLE_300
1347: , a7 out nocopy JTF_NUMBER_TABLE
1348: , a8 out nocopy JTF_VARCHAR2_TABLE_200
1349: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
1350: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1351: , a11 out nocopy JTF_NUMBER_TABLE
1352: , a12 out nocopy JTF_DATE_TABLE
1353: , a13 out nocopy JTF_DATE_TABLE
1354: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 1354: , a14 out nocopy JTF_VARCHAR2_TABLE_100

1350: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1351: , a11 out nocopy JTF_NUMBER_TABLE
1352: , a12 out nocopy JTF_DATE_TABLE
1353: , a13 out nocopy JTF_DATE_TABLE
1354: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1355: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1356: , a16 out nocopy JTF_DATE_TABLE
1357: , a17 out nocopy JTF_DATE_TABLE
1358: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 1355: , a15 out nocopy JTF_VARCHAR2_TABLE_100

1351: , a11 out nocopy JTF_NUMBER_TABLE
1352: , a12 out nocopy JTF_DATE_TABLE
1353: , a13 out nocopy JTF_DATE_TABLE
1354: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1355: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1356: , a16 out nocopy JTF_DATE_TABLE
1357: , a17 out nocopy JTF_DATE_TABLE
1358: , a18 out nocopy JTF_VARCHAR2_TABLE_100
1359: , a19 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1358: , a18 out nocopy JTF_VARCHAR2_TABLE_100

1354: , a14 out nocopy JTF_VARCHAR2_TABLE_100
1355: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1356: , a16 out nocopy JTF_DATE_TABLE
1357: , a17 out nocopy JTF_DATE_TABLE
1358: , a18 out nocopy JTF_VARCHAR2_TABLE_100
1359: , a19 out nocopy JTF_VARCHAR2_TABLE_2000
1360: , a20 out nocopy JTF_DATE_TABLE
1361: , a21 out nocopy JTF_NUMBER_TABLE
1362: ) as

Line 1369: a3 := JTF_VARCHAR2_TABLE_100();

1365: if t is null or t.count = 0 then
1366: a0 := JTF_NUMBER_TABLE();
1367: a1 := JTF_VARCHAR2_TABLE_200();
1368: a2 := JTF_VARCHAR2_TABLE_200();
1369: a3 := JTF_VARCHAR2_TABLE_100();
1370: a4 := JTF_NUMBER_TABLE();
1371: a5 := JTF_VARCHAR2_TABLE_300();
1372: a6 := JTF_VARCHAR2_TABLE_300();
1373: a7 := JTF_NUMBER_TABLE();

Line 1376: a10 := JTF_VARCHAR2_TABLE_100();

1372: a6 := JTF_VARCHAR2_TABLE_300();
1373: a7 := JTF_NUMBER_TABLE();
1374: a8 := JTF_VARCHAR2_TABLE_200();
1375: a9 := JTF_VARCHAR2_TABLE_2000();
1376: a10 := JTF_VARCHAR2_TABLE_100();
1377: a11 := JTF_NUMBER_TABLE();
1378: a12 := JTF_DATE_TABLE();
1379: a13 := JTF_DATE_TABLE();
1380: a14 := JTF_VARCHAR2_TABLE_100();

Line 1380: a14 := JTF_VARCHAR2_TABLE_100();

1376: a10 := JTF_VARCHAR2_TABLE_100();
1377: a11 := JTF_NUMBER_TABLE();
1378: a12 := JTF_DATE_TABLE();
1379: a13 := JTF_DATE_TABLE();
1380: a14 := JTF_VARCHAR2_TABLE_100();
1381: a15 := JTF_VARCHAR2_TABLE_100();
1382: a16 := JTF_DATE_TABLE();
1383: a17 := JTF_DATE_TABLE();
1384: a18 := JTF_VARCHAR2_TABLE_100();

Line 1381: a15 := JTF_VARCHAR2_TABLE_100();

1377: a11 := JTF_NUMBER_TABLE();
1378: a12 := JTF_DATE_TABLE();
1379: a13 := JTF_DATE_TABLE();
1380: a14 := JTF_VARCHAR2_TABLE_100();
1381: a15 := JTF_VARCHAR2_TABLE_100();
1382: a16 := JTF_DATE_TABLE();
1383: a17 := JTF_DATE_TABLE();
1384: a18 := JTF_VARCHAR2_TABLE_100();
1385: a19 := JTF_VARCHAR2_TABLE_2000();

Line 1384: a18 := JTF_VARCHAR2_TABLE_100();

1380: a14 := JTF_VARCHAR2_TABLE_100();
1381: a15 := JTF_VARCHAR2_TABLE_100();
1382: a16 := JTF_DATE_TABLE();
1383: a17 := JTF_DATE_TABLE();
1384: a18 := JTF_VARCHAR2_TABLE_100();
1385: a19 := JTF_VARCHAR2_TABLE_2000();
1386: a20 := JTF_DATE_TABLE();
1387: a21 := JTF_NUMBER_TABLE();
1388: else

Line 1392: a3 := JTF_VARCHAR2_TABLE_100();

1388: else
1389: a0 := JTF_NUMBER_TABLE();
1390: a1 := JTF_VARCHAR2_TABLE_200();
1391: a2 := JTF_VARCHAR2_TABLE_200();
1392: a3 := JTF_VARCHAR2_TABLE_100();
1393: a4 := JTF_NUMBER_TABLE();
1394: a5 := JTF_VARCHAR2_TABLE_300();
1395: a6 := JTF_VARCHAR2_TABLE_300();
1396: a7 := JTF_NUMBER_TABLE();

Line 1399: a10 := JTF_VARCHAR2_TABLE_100();

1395: a6 := JTF_VARCHAR2_TABLE_300();
1396: a7 := JTF_NUMBER_TABLE();
1397: a8 := JTF_VARCHAR2_TABLE_200();
1398: a9 := JTF_VARCHAR2_TABLE_2000();
1399: a10 := JTF_VARCHAR2_TABLE_100();
1400: a11 := JTF_NUMBER_TABLE();
1401: a12 := JTF_DATE_TABLE();
1402: a13 := JTF_DATE_TABLE();
1403: a14 := JTF_VARCHAR2_TABLE_100();

Line 1403: a14 := JTF_VARCHAR2_TABLE_100();

1399: a10 := JTF_VARCHAR2_TABLE_100();
1400: a11 := JTF_NUMBER_TABLE();
1401: a12 := JTF_DATE_TABLE();
1402: a13 := JTF_DATE_TABLE();
1403: a14 := JTF_VARCHAR2_TABLE_100();
1404: a15 := JTF_VARCHAR2_TABLE_100();
1405: a16 := JTF_DATE_TABLE();
1406: a17 := JTF_DATE_TABLE();
1407: a18 := JTF_VARCHAR2_TABLE_100();

Line 1404: a15 := JTF_VARCHAR2_TABLE_100();

1400: a11 := JTF_NUMBER_TABLE();
1401: a12 := JTF_DATE_TABLE();
1402: a13 := JTF_DATE_TABLE();
1403: a14 := JTF_VARCHAR2_TABLE_100();
1404: a15 := JTF_VARCHAR2_TABLE_100();
1405: a16 := JTF_DATE_TABLE();
1406: a17 := JTF_DATE_TABLE();
1407: a18 := JTF_VARCHAR2_TABLE_100();
1408: a19 := JTF_VARCHAR2_TABLE_2000();

Line 1407: a18 := JTF_VARCHAR2_TABLE_100();

1403: a14 := JTF_VARCHAR2_TABLE_100();
1404: a15 := JTF_VARCHAR2_TABLE_100();
1405: a16 := JTF_DATE_TABLE();
1406: a17 := JTF_DATE_TABLE();
1407: a18 := JTF_VARCHAR2_TABLE_100();
1408: a19 := JTF_VARCHAR2_TABLE_2000();
1409: a20 := JTF_DATE_TABLE();
1410: a21 := JTF_NUMBER_TABLE();
1411: if t.count > 0 then

Line 1474: , a5 JTF_VARCHAR2_TABLE_100

1470: , a1 JTF_VARCHAR2_TABLE_200
1471: , a2 JTF_VARCHAR2_TABLE_200
1472: , a3 JTF_VARCHAR2_TABLE_300
1473: , a4 JTF_VARCHAR2_TABLE_600
1474: , a5 JTF_VARCHAR2_TABLE_100
1475: , a6 JTF_DATE_TABLE
1476: , a7 JTF_DATE_TABLE
1477: , a8 JTF_DATE_TABLE
1478: ) as

Line 1509: , a5 out nocopy JTF_VARCHAR2_TABLE_100

1505: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1506: , a2 out nocopy JTF_VARCHAR2_TABLE_200
1507: , a3 out nocopy JTF_VARCHAR2_TABLE_300
1508: , a4 out nocopy JTF_VARCHAR2_TABLE_600
1509: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1510: , a6 out nocopy JTF_DATE_TABLE
1511: , a7 out nocopy JTF_DATE_TABLE
1512: , a8 out nocopy JTF_DATE_TABLE
1513: ) as

Line 1522: a5 := JTF_VARCHAR2_TABLE_100();

1518: a1 := JTF_VARCHAR2_TABLE_200();
1519: a2 := JTF_VARCHAR2_TABLE_200();
1520: a3 := JTF_VARCHAR2_TABLE_300();
1521: a4 := JTF_VARCHAR2_TABLE_600();
1522: a5 := JTF_VARCHAR2_TABLE_100();
1523: a6 := JTF_DATE_TABLE();
1524: a7 := JTF_DATE_TABLE();
1525: a8 := JTF_DATE_TABLE();
1526: else

Line 1532: a5 := JTF_VARCHAR2_TABLE_100();

1528: a1 := JTF_VARCHAR2_TABLE_200();
1529: a2 := JTF_VARCHAR2_TABLE_200();
1530: a3 := JTF_VARCHAR2_TABLE_300();
1531: a4 := JTF_VARCHAR2_TABLE_600();
1532: a5 := JTF_VARCHAR2_TABLE_100();
1533: a6 := JTF_DATE_TABLE();
1534: a7 := JTF_DATE_TABLE();
1535: a8 := JTF_DATE_TABLE();
1536: if t.count > 0 then

Line 1568: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_pub.covlevel_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1564: end if;
1565: end if;
1566: end rosetta_table_copy_out_p38;
1567:
1568: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_pub.covlevel_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1569: , a1 JTF_NUMBER_TABLE
1570: , a2 JTF_NUMBER_TABLE
1571: , a3 JTF_VARCHAR2_TABLE_100
1572: ) as

Line 1571: , a3 JTF_VARCHAR2_TABLE_100

1567:
1568: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_pub.covlevel_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1569: , a1 JTF_NUMBER_TABLE
1570: , a2 JTF_NUMBER_TABLE
1571: , a3 JTF_VARCHAR2_TABLE_100
1572: ) as
1573: ddindx binary_integer; indx binary_integer;
1574: begin
1575: if a0 is not null and a0.count > 0 then

Line 1593: procedure rosetta_table_copy_out_p41(t oks_entitlements_pub.covlevel_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

1589: end loop;
1590: end if;
1591: end if;
1592: end rosetta_table_copy_in_p41;
1593: procedure rosetta_table_copy_out_p41(t oks_entitlements_pub.covlevel_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1594: , a1 out nocopy JTF_NUMBER_TABLE
1595: , a2 out nocopy JTF_NUMBER_TABLE
1596: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1597: ) as

Line 1596: , a3 out nocopy JTF_VARCHAR2_TABLE_100

1592: end rosetta_table_copy_in_p41;
1593: procedure rosetta_table_copy_out_p41(t oks_entitlements_pub.covlevel_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1594: , a1 out nocopy JTF_NUMBER_TABLE
1595: , a2 out nocopy JTF_NUMBER_TABLE
1596: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1597: ) as
1598: ddindx binary_integer; indx binary_integer;
1599: begin
1600: if t is null or t.count = 0 then

Line 1601: a0 := JTF_VARCHAR2_TABLE_100();

1597: ) as
1598: ddindx binary_integer; indx binary_integer;
1599: begin
1600: if t is null or t.count = 0 then
1601: a0 := JTF_VARCHAR2_TABLE_100();
1602: a1 := JTF_NUMBER_TABLE();
1603: a2 := JTF_NUMBER_TABLE();
1604: a3 := JTF_VARCHAR2_TABLE_100();
1605: else

Line 1604: a3 := JTF_VARCHAR2_TABLE_100();

1600: if t is null or t.count = 0 then
1601: a0 := JTF_VARCHAR2_TABLE_100();
1602: a1 := JTF_NUMBER_TABLE();
1603: a2 := JTF_NUMBER_TABLE();
1604: a3 := JTF_VARCHAR2_TABLE_100();
1605: else
1606: a0 := JTF_VARCHAR2_TABLE_100();
1607: a1 := JTF_NUMBER_TABLE();
1608: a2 := JTF_NUMBER_TABLE();

Line 1606: a0 := JTF_VARCHAR2_TABLE_100();

1602: a1 := JTF_NUMBER_TABLE();
1603: a2 := JTF_NUMBER_TABLE();
1604: a3 := JTF_VARCHAR2_TABLE_100();
1605: else
1606: a0 := JTF_VARCHAR2_TABLE_100();
1607: a1 := JTF_NUMBER_TABLE();
1608: a2 := JTF_NUMBER_TABLE();
1609: a3 := JTF_VARCHAR2_TABLE_100();
1610: if t.count > 0 then

Line 1609: a3 := JTF_VARCHAR2_TABLE_100();

1605: else
1606: a0 := JTF_VARCHAR2_TABLE_100();
1607: a1 := JTF_NUMBER_TABLE();
1608: a2 := JTF_NUMBER_TABLE();
1609: a3 := JTF_VARCHAR2_TABLE_100();
1610: if t.count > 0 then
1611: a0.extend(t.count);
1612: a1.extend(t.count);
1613: a2.extend(t.count);

Line 1633: , a1 JTF_VARCHAR2_TABLE_100

1629: end if;
1630: end rosetta_table_copy_out_p41;
1631:
1632: procedure rosetta_table_copy_in_p44(t out nocopy oks_entitlements_pub.covlvl_id_tbl, a0 JTF_NUMBER_TABLE
1633: , a1 JTF_VARCHAR2_TABLE_100
1634: ) as
1635: ddindx binary_integer; indx binary_integer;
1636: begin
1637: if a0 is not null and a0.count > 0 then

Line 1654: , a1 out nocopy JTF_VARCHAR2_TABLE_100

1650: end if;
1651: end if;
1652: end rosetta_table_copy_in_p44;
1653: procedure rosetta_table_copy_out_p44(t oks_entitlements_pub.covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
1654: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1655: ) as
1656: ddindx binary_integer; indx binary_integer;
1657: begin
1658: if t is null or t.count = 0 then

Line 1660: a1 := JTF_VARCHAR2_TABLE_100();

1656: ddindx binary_integer; indx binary_integer;
1657: begin
1658: if t is null or t.count = 0 then
1659: a0 := JTF_NUMBER_TABLE();
1660: a1 := JTF_VARCHAR2_TABLE_100();
1661: else
1662: a0 := JTF_NUMBER_TABLE();
1663: a1 := JTF_VARCHAR2_TABLE_100();
1664: if t.count > 0 then

Line 1663: a1 := JTF_VARCHAR2_TABLE_100();

1659: a0 := JTF_NUMBER_TABLE();
1660: a1 := JTF_VARCHAR2_TABLE_100();
1661: else
1662: a0 := JTF_NUMBER_TABLE();
1663: a1 := JTF_VARCHAR2_TABLE_100();
1664: if t.count > 0 then
1665: a0.extend(t.count);
1666: a1.extend(t.count);
1667: ddindx := t.first;

Line 1684: , a2 JTF_VARCHAR2_TABLE_100

1680: end rosetta_table_copy_out_p44;
1681:
1682: procedure rosetta_table_copy_in_p47(t out nocopy oks_entitlements_pub.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
1683: , a1 JTF_VARCHAR2_TABLE_200
1684: , a2 JTF_VARCHAR2_TABLE_100
1685: , a3 JTF_VARCHAR2_TABLE_100
1686: , a4 JTF_VARCHAR2_TABLE_300
1687: , a5 JTF_VARCHAR2_TABLE_2000
1688: , a6 JTF_DATE_TABLE

Line 1685: , a3 JTF_VARCHAR2_TABLE_100

1681:
1682: procedure rosetta_table_copy_in_p47(t out nocopy oks_entitlements_pub.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
1683: , a1 JTF_VARCHAR2_TABLE_200
1684: , a2 JTF_VARCHAR2_TABLE_100
1685: , a3 JTF_VARCHAR2_TABLE_100
1686: , a4 JTF_VARCHAR2_TABLE_300
1687: , a5 JTF_VARCHAR2_TABLE_2000
1688: , a6 JTF_DATE_TABLE
1689: , a7 JTF_DATE_TABLE

Line 1692: , a10 JTF_VARCHAR2_TABLE_100

1688: , a6 JTF_DATE_TABLE
1689: , a7 JTF_DATE_TABLE
1690: , a8 JTF_DATE_TABLE
1691: , a9 JTF_NUMBER_TABLE
1692: , a10 JTF_VARCHAR2_TABLE_100
1693: , a11 JTF_VARCHAR2_TABLE_100
1694: , a12 JTF_VARCHAR2_TABLE_100
1695: ) as
1696: ddindx binary_integer; indx binary_integer;

Line 1693: , a11 JTF_VARCHAR2_TABLE_100

1689: , a7 JTF_DATE_TABLE
1690: , a8 JTF_DATE_TABLE
1691: , a9 JTF_NUMBER_TABLE
1692: , a10 JTF_VARCHAR2_TABLE_100
1693: , a11 JTF_VARCHAR2_TABLE_100
1694: , a12 JTF_VARCHAR2_TABLE_100
1695: ) as
1696: ddindx binary_integer; indx binary_integer;
1697: begin

Line 1694: , a12 JTF_VARCHAR2_TABLE_100

1690: , a8 JTF_DATE_TABLE
1691: , a9 JTF_NUMBER_TABLE
1692: , a10 JTF_VARCHAR2_TABLE_100
1693: , a11 JTF_VARCHAR2_TABLE_100
1694: , a12 JTF_VARCHAR2_TABLE_100
1695: ) as
1696: ddindx binary_integer; indx binary_integer;
1697: begin
1698: if a0 is not null and a0.count > 0 then

Line 1727: , a2 out nocopy JTF_VARCHAR2_TABLE_100

1723: end if;
1724: end rosetta_table_copy_in_p47;
1725: procedure rosetta_table_copy_out_p47(t oks_entitlements_pub.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
1726: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1727: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1728: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1729: , a4 out nocopy JTF_VARCHAR2_TABLE_300
1730: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
1731: , a6 out nocopy JTF_DATE_TABLE

Line 1728: , a3 out nocopy JTF_VARCHAR2_TABLE_100

1724: end rosetta_table_copy_in_p47;
1725: procedure rosetta_table_copy_out_p47(t oks_entitlements_pub.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
1726: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1727: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1728: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1729: , a4 out nocopy JTF_VARCHAR2_TABLE_300
1730: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
1731: , a6 out nocopy JTF_DATE_TABLE
1732: , a7 out nocopy JTF_DATE_TABLE

Line 1735: , a10 out nocopy JTF_VARCHAR2_TABLE_100

1731: , a6 out nocopy JTF_DATE_TABLE
1732: , a7 out nocopy JTF_DATE_TABLE
1733: , a8 out nocopy JTF_DATE_TABLE
1734: , a9 out nocopy JTF_NUMBER_TABLE
1735: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1736: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1737: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1738: ) as
1739: ddindx binary_integer; indx binary_integer;

Line 1736: , a11 out nocopy JTF_VARCHAR2_TABLE_100

1732: , a7 out nocopy JTF_DATE_TABLE
1733: , a8 out nocopy JTF_DATE_TABLE
1734: , a9 out nocopy JTF_NUMBER_TABLE
1735: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1736: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1737: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1738: ) as
1739: ddindx binary_integer; indx binary_integer;
1740: begin

Line 1737: , a12 out nocopy JTF_VARCHAR2_TABLE_100

1733: , a8 out nocopy JTF_DATE_TABLE
1734: , a9 out nocopy JTF_NUMBER_TABLE
1735: , a10 out nocopy JTF_VARCHAR2_TABLE_100
1736: , a11 out nocopy JTF_VARCHAR2_TABLE_100
1737: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1738: ) as
1739: ddindx binary_integer; indx binary_integer;
1740: begin
1741: if t is null or t.count = 0 then

Line 1744: a2 := JTF_VARCHAR2_TABLE_100();

1740: begin
1741: if t is null or t.count = 0 then
1742: a0 := JTF_VARCHAR2_TABLE_200();
1743: a1 := JTF_VARCHAR2_TABLE_200();
1744: a2 := JTF_VARCHAR2_TABLE_100();
1745: a3 := JTF_VARCHAR2_TABLE_100();
1746: a4 := JTF_VARCHAR2_TABLE_300();
1747: a5 := JTF_VARCHAR2_TABLE_2000();
1748: a6 := JTF_DATE_TABLE();

Line 1745: a3 := JTF_VARCHAR2_TABLE_100();

1741: if t is null or t.count = 0 then
1742: a0 := JTF_VARCHAR2_TABLE_200();
1743: a1 := JTF_VARCHAR2_TABLE_200();
1744: a2 := JTF_VARCHAR2_TABLE_100();
1745: a3 := JTF_VARCHAR2_TABLE_100();
1746: a4 := JTF_VARCHAR2_TABLE_300();
1747: a5 := JTF_VARCHAR2_TABLE_2000();
1748: a6 := JTF_DATE_TABLE();
1749: a7 := JTF_DATE_TABLE();

Line 1752: a10 := JTF_VARCHAR2_TABLE_100();

1748: a6 := JTF_DATE_TABLE();
1749: a7 := JTF_DATE_TABLE();
1750: a8 := JTF_DATE_TABLE();
1751: a9 := JTF_NUMBER_TABLE();
1752: a10 := JTF_VARCHAR2_TABLE_100();
1753: a11 := JTF_VARCHAR2_TABLE_100();
1754: a12 := JTF_VARCHAR2_TABLE_100();
1755: else
1756: a0 := JTF_VARCHAR2_TABLE_200();

Line 1753: a11 := JTF_VARCHAR2_TABLE_100();

1749: a7 := JTF_DATE_TABLE();
1750: a8 := JTF_DATE_TABLE();
1751: a9 := JTF_NUMBER_TABLE();
1752: a10 := JTF_VARCHAR2_TABLE_100();
1753: a11 := JTF_VARCHAR2_TABLE_100();
1754: a12 := JTF_VARCHAR2_TABLE_100();
1755: else
1756: a0 := JTF_VARCHAR2_TABLE_200();
1757: a1 := JTF_VARCHAR2_TABLE_200();

Line 1754: a12 := JTF_VARCHAR2_TABLE_100();

1750: a8 := JTF_DATE_TABLE();
1751: a9 := JTF_NUMBER_TABLE();
1752: a10 := JTF_VARCHAR2_TABLE_100();
1753: a11 := JTF_VARCHAR2_TABLE_100();
1754: a12 := JTF_VARCHAR2_TABLE_100();
1755: else
1756: a0 := JTF_VARCHAR2_TABLE_200();
1757: a1 := JTF_VARCHAR2_TABLE_200();
1758: a2 := JTF_VARCHAR2_TABLE_100();

Line 1758: a2 := JTF_VARCHAR2_TABLE_100();

1754: a12 := JTF_VARCHAR2_TABLE_100();
1755: else
1756: a0 := JTF_VARCHAR2_TABLE_200();
1757: a1 := JTF_VARCHAR2_TABLE_200();
1758: a2 := JTF_VARCHAR2_TABLE_100();
1759: a3 := JTF_VARCHAR2_TABLE_100();
1760: a4 := JTF_VARCHAR2_TABLE_300();
1761: a5 := JTF_VARCHAR2_TABLE_2000();
1762: a6 := JTF_DATE_TABLE();

Line 1759: a3 := JTF_VARCHAR2_TABLE_100();

1755: else
1756: a0 := JTF_VARCHAR2_TABLE_200();
1757: a1 := JTF_VARCHAR2_TABLE_200();
1758: a2 := JTF_VARCHAR2_TABLE_100();
1759: a3 := JTF_VARCHAR2_TABLE_100();
1760: a4 := JTF_VARCHAR2_TABLE_300();
1761: a5 := JTF_VARCHAR2_TABLE_2000();
1762: a6 := JTF_DATE_TABLE();
1763: a7 := JTF_DATE_TABLE();

Line 1766: a10 := JTF_VARCHAR2_TABLE_100();

1762: a6 := JTF_DATE_TABLE();
1763: a7 := JTF_DATE_TABLE();
1764: a8 := JTF_DATE_TABLE();
1765: a9 := JTF_NUMBER_TABLE();
1766: a10 := JTF_VARCHAR2_TABLE_100();
1767: a11 := JTF_VARCHAR2_TABLE_100();
1768: a12 := JTF_VARCHAR2_TABLE_100();
1769: if t.count > 0 then
1770: a0.extend(t.count);

Line 1767: a11 := JTF_VARCHAR2_TABLE_100();

1763: a7 := JTF_DATE_TABLE();
1764: a8 := JTF_DATE_TABLE();
1765: a9 := JTF_NUMBER_TABLE();
1766: a10 := JTF_VARCHAR2_TABLE_100();
1767: a11 := JTF_VARCHAR2_TABLE_100();
1768: a12 := JTF_VARCHAR2_TABLE_100();
1769: if t.count > 0 then
1770: a0.extend(t.count);
1771: a1.extend(t.count);

Line 1768: a12 := JTF_VARCHAR2_TABLE_100();

1764: a8 := JTF_DATE_TABLE();
1765: a9 := JTF_NUMBER_TABLE();
1766: a10 := JTF_VARCHAR2_TABLE_100();
1767: a11 := JTF_VARCHAR2_TABLE_100();
1768: a12 := JTF_VARCHAR2_TABLE_100();
1769: if t.count > 0 then
1770: a0.extend(t.count);
1771: a1.extend(t.count);
1772: a2.extend(t.count);

Line 1812: , a3 JTF_VARCHAR2_TABLE_100

1808:
1809: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_pub.ent_contact_tbl, a0 JTF_NUMBER_TABLE
1810: , a1 JTF_NUMBER_TABLE
1811: , a2 JTF_NUMBER_TABLE
1812: , a3 JTF_VARCHAR2_TABLE_100
1813: , a4 JTF_NUMBER_TABLE
1814: , a5 JTF_VARCHAR2_TABLE_100
1815: , a6 JTF_VARCHAR2_TABLE_100
1816: ) as

Line 1814: , a5 JTF_VARCHAR2_TABLE_100

1810: , a1 JTF_NUMBER_TABLE
1811: , a2 JTF_NUMBER_TABLE
1812: , a3 JTF_VARCHAR2_TABLE_100
1813: , a4 JTF_NUMBER_TABLE
1814: , a5 JTF_VARCHAR2_TABLE_100
1815: , a6 JTF_VARCHAR2_TABLE_100
1816: ) as
1817: ddindx binary_integer; indx binary_integer;
1818: begin

Line 1815: , a6 JTF_VARCHAR2_TABLE_100

1811: , a2 JTF_NUMBER_TABLE
1812: , a3 JTF_VARCHAR2_TABLE_100
1813: , a4 JTF_NUMBER_TABLE
1814: , a5 JTF_VARCHAR2_TABLE_100
1815: , a6 JTF_VARCHAR2_TABLE_100
1816: ) as
1817: ddindx binary_integer; indx binary_integer;
1818: begin
1819: if a0 is not null and a0.count > 0 then

Line 1843: , a3 out nocopy JTF_VARCHAR2_TABLE_100

1839: end rosetta_table_copy_in_p60;
1840: procedure rosetta_table_copy_out_p60(t oks_entitlements_pub.ent_contact_tbl, a0 out nocopy JTF_NUMBER_TABLE
1841: , a1 out nocopy JTF_NUMBER_TABLE
1842: , a2 out nocopy JTF_NUMBER_TABLE
1843: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1844: , a4 out nocopy JTF_NUMBER_TABLE
1845: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1846: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1847: ) as

Line 1845: , a5 out nocopy JTF_VARCHAR2_TABLE_100

1841: , a1 out nocopy JTF_NUMBER_TABLE
1842: , a2 out nocopy JTF_NUMBER_TABLE
1843: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1844: , a4 out nocopy JTF_NUMBER_TABLE
1845: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1846: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1847: ) as
1848: ddindx binary_integer; indx binary_integer;
1849: begin

Line 1846: , a6 out nocopy JTF_VARCHAR2_TABLE_100

1842: , a2 out nocopy JTF_NUMBER_TABLE
1843: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1844: , a4 out nocopy JTF_NUMBER_TABLE
1845: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1846: , a6 out nocopy JTF_VARCHAR2_TABLE_100
1847: ) as
1848: ddindx binary_integer; indx binary_integer;
1849: begin
1850: if t is null or t.count = 0 then

Line 1854: a3 := JTF_VARCHAR2_TABLE_100();

1850: if t is null or t.count = 0 then
1851: a0 := JTF_NUMBER_TABLE();
1852: a1 := JTF_NUMBER_TABLE();
1853: a2 := JTF_NUMBER_TABLE();
1854: a3 := JTF_VARCHAR2_TABLE_100();
1855: a4 := JTF_NUMBER_TABLE();
1856: a5 := JTF_VARCHAR2_TABLE_100();
1857: a6 := JTF_VARCHAR2_TABLE_100();
1858: else

Line 1856: a5 := JTF_VARCHAR2_TABLE_100();

1852: a1 := JTF_NUMBER_TABLE();
1853: a2 := JTF_NUMBER_TABLE();
1854: a3 := JTF_VARCHAR2_TABLE_100();
1855: a4 := JTF_NUMBER_TABLE();
1856: a5 := JTF_VARCHAR2_TABLE_100();
1857: a6 := JTF_VARCHAR2_TABLE_100();
1858: else
1859: a0 := JTF_NUMBER_TABLE();
1860: a1 := JTF_NUMBER_TABLE();

Line 1857: a6 := JTF_VARCHAR2_TABLE_100();

1853: a2 := JTF_NUMBER_TABLE();
1854: a3 := JTF_VARCHAR2_TABLE_100();
1855: a4 := JTF_NUMBER_TABLE();
1856: a5 := JTF_VARCHAR2_TABLE_100();
1857: a6 := JTF_VARCHAR2_TABLE_100();
1858: else
1859: a0 := JTF_NUMBER_TABLE();
1860: a1 := JTF_NUMBER_TABLE();
1861: a2 := JTF_NUMBER_TABLE();

Line 1862: a3 := JTF_VARCHAR2_TABLE_100();

1858: else
1859: a0 := JTF_NUMBER_TABLE();
1860: a1 := JTF_NUMBER_TABLE();
1861: a2 := JTF_NUMBER_TABLE();
1862: a3 := JTF_VARCHAR2_TABLE_100();
1863: a4 := JTF_NUMBER_TABLE();
1864: a5 := JTF_VARCHAR2_TABLE_100();
1865: a6 := JTF_VARCHAR2_TABLE_100();
1866: if t.count > 0 then

Line 1864: a5 := JTF_VARCHAR2_TABLE_100();

1860: a1 := JTF_NUMBER_TABLE();
1861: a2 := JTF_NUMBER_TABLE();
1862: a3 := JTF_VARCHAR2_TABLE_100();
1863: a4 := JTF_NUMBER_TABLE();
1864: a5 := JTF_VARCHAR2_TABLE_100();
1865: a6 := JTF_VARCHAR2_TABLE_100();
1866: if t.count > 0 then
1867: a0.extend(t.count);
1868: a1.extend(t.count);

Line 1865: a6 := JTF_VARCHAR2_TABLE_100();

1861: a2 := JTF_NUMBER_TABLE();
1862: a3 := JTF_VARCHAR2_TABLE_100();
1863: a4 := JTF_NUMBER_TABLE();
1864: a5 := JTF_VARCHAR2_TABLE_100();
1865: a6 := JTF_VARCHAR2_TABLE_100();
1866: if t.count > 0 then
1867: a0.extend(t.count);
1868: a1.extend(t.count);
1869: a2.extend(t.count);

Line 1896: , a2 JTF_VARCHAR2_TABLE_100

1892: end rosetta_table_copy_out_p60;
1893:
1894: procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
1895: , a1 JTF_NUMBER_TABLE
1896: , a2 JTF_VARCHAR2_TABLE_100
1897: , a3 JTF_VARCHAR2_TABLE_100
1898: , a4 JTF_VARCHAR2_TABLE_100
1899: ) as
1900: ddindx binary_integer; indx binary_integer;

Line 1897: , a3 JTF_VARCHAR2_TABLE_100

1893:
1894: procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
1895: , a1 JTF_NUMBER_TABLE
1896: , a2 JTF_VARCHAR2_TABLE_100
1897: , a3 JTF_VARCHAR2_TABLE_100
1898: , a4 JTF_VARCHAR2_TABLE_100
1899: ) as
1900: ddindx binary_integer; indx binary_integer;
1901: begin

Line 1898: , a4 JTF_VARCHAR2_TABLE_100

1894: procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
1895: , a1 JTF_NUMBER_TABLE
1896: , a2 JTF_VARCHAR2_TABLE_100
1897: , a3 JTF_VARCHAR2_TABLE_100
1898: , a4 JTF_VARCHAR2_TABLE_100
1899: ) as
1900: ddindx binary_integer; indx binary_integer;
1901: begin
1902: if a0 is not null and a0.count > 0 then

Line 1923: , a2 out nocopy JTF_VARCHAR2_TABLE_100

1919: end if;
1920: end rosetta_table_copy_in_p63;
1921: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1922: , a1 out nocopy JTF_NUMBER_TABLE
1923: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1924: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1925: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1926: ) as
1927: ddindx binary_integer; indx binary_integer;

Line 1924: , a3 out nocopy JTF_VARCHAR2_TABLE_100

1920: end rosetta_table_copy_in_p63;
1921: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1922: , a1 out nocopy JTF_NUMBER_TABLE
1923: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1924: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1925: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1926: ) as
1927: ddindx binary_integer; indx binary_integer;
1928: begin

Line 1925: , a4 out nocopy JTF_VARCHAR2_TABLE_100

1921: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1922: , a1 out nocopy JTF_NUMBER_TABLE
1923: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1924: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1925: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1926: ) as
1927: ddindx binary_integer; indx binary_integer;
1928: begin
1929: if t is null or t.count = 0 then

Line 1932: a2 := JTF_VARCHAR2_TABLE_100();

1928: begin
1929: if t is null or t.count = 0 then
1930: a0 := JTF_NUMBER_TABLE();
1931: a1 := JTF_NUMBER_TABLE();
1932: a2 := JTF_VARCHAR2_TABLE_100();
1933: a3 := JTF_VARCHAR2_TABLE_100();
1934: a4 := JTF_VARCHAR2_TABLE_100();
1935: else
1936: a0 := JTF_NUMBER_TABLE();

Line 1933: a3 := JTF_VARCHAR2_TABLE_100();

1929: if t is null or t.count = 0 then
1930: a0 := JTF_NUMBER_TABLE();
1931: a1 := JTF_NUMBER_TABLE();
1932: a2 := JTF_VARCHAR2_TABLE_100();
1933: a3 := JTF_VARCHAR2_TABLE_100();
1934: a4 := JTF_VARCHAR2_TABLE_100();
1935: else
1936: a0 := JTF_NUMBER_TABLE();
1937: a1 := JTF_NUMBER_TABLE();

Line 1934: a4 := JTF_VARCHAR2_TABLE_100();

1930: a0 := JTF_NUMBER_TABLE();
1931: a1 := JTF_NUMBER_TABLE();
1932: a2 := JTF_VARCHAR2_TABLE_100();
1933: a3 := JTF_VARCHAR2_TABLE_100();
1934: a4 := JTF_VARCHAR2_TABLE_100();
1935: else
1936: a0 := JTF_NUMBER_TABLE();
1937: a1 := JTF_NUMBER_TABLE();
1938: a2 := JTF_VARCHAR2_TABLE_100();

Line 1938: a2 := JTF_VARCHAR2_TABLE_100();

1934: a4 := JTF_VARCHAR2_TABLE_100();
1935: else
1936: a0 := JTF_NUMBER_TABLE();
1937: a1 := JTF_NUMBER_TABLE();
1938: a2 := JTF_VARCHAR2_TABLE_100();
1939: a3 := JTF_VARCHAR2_TABLE_100();
1940: a4 := JTF_VARCHAR2_TABLE_100();
1941: if t.count > 0 then
1942: a0.extend(t.count);

Line 1939: a3 := JTF_VARCHAR2_TABLE_100();

1935: else
1936: a0 := JTF_NUMBER_TABLE();
1937: a1 := JTF_NUMBER_TABLE();
1938: a2 := JTF_VARCHAR2_TABLE_100();
1939: a3 := JTF_VARCHAR2_TABLE_100();
1940: a4 := JTF_VARCHAR2_TABLE_100();
1941: if t.count > 0 then
1942: a0.extend(t.count);
1943: a1.extend(t.count);

Line 1940: a4 := JTF_VARCHAR2_TABLE_100();

1936: a0 := JTF_NUMBER_TABLE();
1937: a1 := JTF_NUMBER_TABLE();
1938: a2 := JTF_VARCHAR2_TABLE_100();
1939: a3 := JTF_VARCHAR2_TABLE_100();
1940: a4 := JTF_VARCHAR2_TABLE_100();
1941: if t.count > 0 then
1942: a0.extend(t.count);
1943: a1.extend(t.count);
1944: a2.extend(t.count);

Line 2096: , a3 JTF_VARCHAR2_TABLE_100

2092:
2093: procedure rosetta_table_copy_in_p75(t out nocopy oks_entitlements_pub.output_tbl_br, a0 JTF_NUMBER_TABLE
2094: , a1 JTF_NUMBER_TABLE
2095: , a2 JTF_NUMBER_TABLE
2096: , a3 JTF_VARCHAR2_TABLE_100
2097: , a4 JTF_NUMBER_TABLE
2098: , a5 JTF_VARCHAR2_TABLE_100
2099: , a6 JTF_NUMBER_TABLE
2100: , a7 JTF_NUMBER_TABLE

Line 2098: , a5 JTF_VARCHAR2_TABLE_100

2094: , a1 JTF_NUMBER_TABLE
2095: , a2 JTF_NUMBER_TABLE
2096: , a3 JTF_VARCHAR2_TABLE_100
2097: , a4 JTF_NUMBER_TABLE
2098: , a5 JTF_VARCHAR2_TABLE_100
2099: , a6 JTF_NUMBER_TABLE
2100: , a7 JTF_NUMBER_TABLE
2101: , a8 JTF_NUMBER_TABLE
2102: , a9 JTF_NUMBER_TABLE

Line 2104: , a11 JTF_VARCHAR2_TABLE_100

2100: , a7 JTF_NUMBER_TABLE
2101: , a8 JTF_NUMBER_TABLE
2102: , a9 JTF_NUMBER_TABLE
2103: , a10 JTF_NUMBER_TABLE
2104: , a11 JTF_VARCHAR2_TABLE_100
2105: , a12 JTF_VARCHAR2_TABLE_100
2106: , a13 JTF_VARCHAR2_TABLE_100
2107: , a14 JTF_VARCHAR2_TABLE_100
2108: , a15 JTF_VARCHAR2_TABLE_100

Line 2105: , a12 JTF_VARCHAR2_TABLE_100

2101: , a8 JTF_NUMBER_TABLE
2102: , a9 JTF_NUMBER_TABLE
2103: , a10 JTF_NUMBER_TABLE
2104: , a11 JTF_VARCHAR2_TABLE_100
2105: , a12 JTF_VARCHAR2_TABLE_100
2106: , a13 JTF_VARCHAR2_TABLE_100
2107: , a14 JTF_VARCHAR2_TABLE_100
2108: , a15 JTF_VARCHAR2_TABLE_100
2109: , a16 JTF_VARCHAR2_TABLE_100

Line 2106: , a13 JTF_VARCHAR2_TABLE_100

2102: , a9 JTF_NUMBER_TABLE
2103: , a10 JTF_NUMBER_TABLE
2104: , a11 JTF_VARCHAR2_TABLE_100
2105: , a12 JTF_VARCHAR2_TABLE_100
2106: , a13 JTF_VARCHAR2_TABLE_100
2107: , a14 JTF_VARCHAR2_TABLE_100
2108: , a15 JTF_VARCHAR2_TABLE_100
2109: , a16 JTF_VARCHAR2_TABLE_100
2110: , a17 JTF_VARCHAR2_TABLE_100

Line 2107: , a14 JTF_VARCHAR2_TABLE_100

2103: , a10 JTF_NUMBER_TABLE
2104: , a11 JTF_VARCHAR2_TABLE_100
2105: , a12 JTF_VARCHAR2_TABLE_100
2106: , a13 JTF_VARCHAR2_TABLE_100
2107: , a14 JTF_VARCHAR2_TABLE_100
2108: , a15 JTF_VARCHAR2_TABLE_100
2109: , a16 JTF_VARCHAR2_TABLE_100
2110: , a17 JTF_VARCHAR2_TABLE_100
2111: , a18 JTF_NUMBER_TABLE

Line 2108: , a15 JTF_VARCHAR2_TABLE_100

2104: , a11 JTF_VARCHAR2_TABLE_100
2105: , a12 JTF_VARCHAR2_TABLE_100
2106: , a13 JTF_VARCHAR2_TABLE_100
2107: , a14 JTF_VARCHAR2_TABLE_100
2108: , a15 JTF_VARCHAR2_TABLE_100
2109: , a16 JTF_VARCHAR2_TABLE_100
2110: , a17 JTF_VARCHAR2_TABLE_100
2111: , a18 JTF_NUMBER_TABLE
2112: , a19 JTF_NUMBER_TABLE

Line 2109: , a16 JTF_VARCHAR2_TABLE_100

2105: , a12 JTF_VARCHAR2_TABLE_100
2106: , a13 JTF_VARCHAR2_TABLE_100
2107: , a14 JTF_VARCHAR2_TABLE_100
2108: , a15 JTF_VARCHAR2_TABLE_100
2109: , a16 JTF_VARCHAR2_TABLE_100
2110: , a17 JTF_VARCHAR2_TABLE_100
2111: , a18 JTF_NUMBER_TABLE
2112: , a19 JTF_NUMBER_TABLE
2113: , a20 JTF_VARCHAR2_TABLE_100

Line 2110: , a17 JTF_VARCHAR2_TABLE_100

2106: , a13 JTF_VARCHAR2_TABLE_100
2107: , a14 JTF_VARCHAR2_TABLE_100
2108: , a15 JTF_VARCHAR2_TABLE_100
2109: , a16 JTF_VARCHAR2_TABLE_100
2110: , a17 JTF_VARCHAR2_TABLE_100
2111: , a18 JTF_NUMBER_TABLE
2112: , a19 JTF_NUMBER_TABLE
2113: , a20 JTF_VARCHAR2_TABLE_100
2114: ) as

Line 2113: , a20 JTF_VARCHAR2_TABLE_100

2109: , a16 JTF_VARCHAR2_TABLE_100
2110: , a17 JTF_VARCHAR2_TABLE_100
2111: , a18 JTF_NUMBER_TABLE
2112: , a19 JTF_NUMBER_TABLE
2113: , a20 JTF_VARCHAR2_TABLE_100
2114: ) as
2115: ddindx binary_integer; indx binary_integer;
2116: begin
2117: if a0 is not null and a0.count > 0 then

Line 2155: , a3 out nocopy JTF_VARCHAR2_TABLE_100

2151: end rosetta_table_copy_in_p75;
2152: procedure rosetta_table_copy_out_p75(t oks_entitlements_pub.output_tbl_br, a0 out nocopy JTF_NUMBER_TABLE
2153: , a1 out nocopy JTF_NUMBER_TABLE
2154: , a2 out nocopy JTF_NUMBER_TABLE
2155: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2156: , a4 out nocopy JTF_NUMBER_TABLE
2157: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2158: , a6 out nocopy JTF_NUMBER_TABLE
2159: , a7 out nocopy JTF_NUMBER_TABLE

Line 2157: , a5 out nocopy JTF_VARCHAR2_TABLE_100

2153: , a1 out nocopy JTF_NUMBER_TABLE
2154: , a2 out nocopy JTF_NUMBER_TABLE
2155: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2156: , a4 out nocopy JTF_NUMBER_TABLE
2157: , a5 out nocopy JTF_VARCHAR2_TABLE_100
2158: , a6 out nocopy JTF_NUMBER_TABLE
2159: , a7 out nocopy JTF_NUMBER_TABLE
2160: , a8 out nocopy JTF_NUMBER_TABLE
2161: , a9 out nocopy JTF_NUMBER_TABLE

Line 2163: , a11 out nocopy JTF_VARCHAR2_TABLE_100

2159: , a7 out nocopy JTF_NUMBER_TABLE
2160: , a8 out nocopy JTF_NUMBER_TABLE
2161: , a9 out nocopy JTF_NUMBER_TABLE
2162: , a10 out nocopy JTF_NUMBER_TABLE
2163: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2164: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2165: , a13 out nocopy JTF_VARCHAR2_TABLE_100
2166: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2167: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 2164: , a12 out nocopy JTF_VARCHAR2_TABLE_100

2160: , a8 out nocopy JTF_NUMBER_TABLE
2161: , a9 out nocopy JTF_NUMBER_TABLE
2162: , a10 out nocopy JTF_NUMBER_TABLE
2163: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2164: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2165: , a13 out nocopy JTF_VARCHAR2_TABLE_100
2166: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2167: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2168: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 2165: , a13 out nocopy JTF_VARCHAR2_TABLE_100

2161: , a9 out nocopy JTF_NUMBER_TABLE
2162: , a10 out nocopy JTF_NUMBER_TABLE
2163: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2164: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2165: , a13 out nocopy JTF_VARCHAR2_TABLE_100
2166: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2167: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2168: , a16 out nocopy JTF_VARCHAR2_TABLE_100
2169: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 2166: , a14 out nocopy JTF_VARCHAR2_TABLE_100

2162: , a10 out nocopy JTF_NUMBER_TABLE
2163: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2164: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2165: , a13 out nocopy JTF_VARCHAR2_TABLE_100
2166: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2167: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2168: , a16 out nocopy JTF_VARCHAR2_TABLE_100
2169: , a17 out nocopy JTF_VARCHAR2_TABLE_100
2170: , a18 out nocopy JTF_NUMBER_TABLE

Line 2167: , a15 out nocopy JTF_VARCHAR2_TABLE_100

2163: , a11 out nocopy JTF_VARCHAR2_TABLE_100
2164: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2165: , a13 out nocopy JTF_VARCHAR2_TABLE_100
2166: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2167: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2168: , a16 out nocopy JTF_VARCHAR2_TABLE_100
2169: , a17 out nocopy JTF_VARCHAR2_TABLE_100
2170: , a18 out nocopy JTF_NUMBER_TABLE
2171: , a19 out nocopy JTF_NUMBER_TABLE

Line 2168: , a16 out nocopy JTF_VARCHAR2_TABLE_100

2164: , a12 out nocopy JTF_VARCHAR2_TABLE_100
2165: , a13 out nocopy JTF_VARCHAR2_TABLE_100
2166: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2167: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2168: , a16 out nocopy JTF_VARCHAR2_TABLE_100
2169: , a17 out nocopy JTF_VARCHAR2_TABLE_100
2170: , a18 out nocopy JTF_NUMBER_TABLE
2171: , a19 out nocopy JTF_NUMBER_TABLE
2172: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 2169: , a17 out nocopy JTF_VARCHAR2_TABLE_100

2165: , a13 out nocopy JTF_VARCHAR2_TABLE_100
2166: , a14 out nocopy JTF_VARCHAR2_TABLE_100
2167: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2168: , a16 out nocopy JTF_VARCHAR2_TABLE_100
2169: , a17 out nocopy JTF_VARCHAR2_TABLE_100
2170: , a18 out nocopy JTF_NUMBER_TABLE
2171: , a19 out nocopy JTF_NUMBER_TABLE
2172: , a20 out nocopy JTF_VARCHAR2_TABLE_100
2173: ) as

Line 2172: , a20 out nocopy JTF_VARCHAR2_TABLE_100

2168: , a16 out nocopy JTF_VARCHAR2_TABLE_100
2169: , a17 out nocopy JTF_VARCHAR2_TABLE_100
2170: , a18 out nocopy JTF_NUMBER_TABLE
2171: , a19 out nocopy JTF_NUMBER_TABLE
2172: , a20 out nocopy JTF_VARCHAR2_TABLE_100
2173: ) as
2174: ddindx binary_integer; indx binary_integer;
2175: begin
2176: if t is null or t.count = 0 then

Line 2180: a3 := JTF_VARCHAR2_TABLE_100();

2176: if t is null or t.count = 0 then
2177: a0 := JTF_NUMBER_TABLE();
2178: a1 := JTF_NUMBER_TABLE();
2179: a2 := JTF_NUMBER_TABLE();
2180: a3 := JTF_VARCHAR2_TABLE_100();
2181: a4 := JTF_NUMBER_TABLE();
2182: a5 := JTF_VARCHAR2_TABLE_100();
2183: a6 := JTF_NUMBER_TABLE();
2184: a7 := JTF_NUMBER_TABLE();

Line 2182: a5 := JTF_VARCHAR2_TABLE_100();

2178: a1 := JTF_NUMBER_TABLE();
2179: a2 := JTF_NUMBER_TABLE();
2180: a3 := JTF_VARCHAR2_TABLE_100();
2181: a4 := JTF_NUMBER_TABLE();
2182: a5 := JTF_VARCHAR2_TABLE_100();
2183: a6 := JTF_NUMBER_TABLE();
2184: a7 := JTF_NUMBER_TABLE();
2185: a8 := JTF_NUMBER_TABLE();
2186: a9 := JTF_NUMBER_TABLE();

Line 2188: a11 := JTF_VARCHAR2_TABLE_100();

2184: a7 := JTF_NUMBER_TABLE();
2185: a8 := JTF_NUMBER_TABLE();
2186: a9 := JTF_NUMBER_TABLE();
2187: a10 := JTF_NUMBER_TABLE();
2188: a11 := JTF_VARCHAR2_TABLE_100();
2189: a12 := JTF_VARCHAR2_TABLE_100();
2190: a13 := JTF_VARCHAR2_TABLE_100();
2191: a14 := JTF_VARCHAR2_TABLE_100();
2192: a15 := JTF_VARCHAR2_TABLE_100();

Line 2189: a12 := JTF_VARCHAR2_TABLE_100();

2185: a8 := JTF_NUMBER_TABLE();
2186: a9 := JTF_NUMBER_TABLE();
2187: a10 := JTF_NUMBER_TABLE();
2188: a11 := JTF_VARCHAR2_TABLE_100();
2189: a12 := JTF_VARCHAR2_TABLE_100();
2190: a13 := JTF_VARCHAR2_TABLE_100();
2191: a14 := JTF_VARCHAR2_TABLE_100();
2192: a15 := JTF_VARCHAR2_TABLE_100();
2193: a16 := JTF_VARCHAR2_TABLE_100();

Line 2190: a13 := JTF_VARCHAR2_TABLE_100();

2186: a9 := JTF_NUMBER_TABLE();
2187: a10 := JTF_NUMBER_TABLE();
2188: a11 := JTF_VARCHAR2_TABLE_100();
2189: a12 := JTF_VARCHAR2_TABLE_100();
2190: a13 := JTF_VARCHAR2_TABLE_100();
2191: a14 := JTF_VARCHAR2_TABLE_100();
2192: a15 := JTF_VARCHAR2_TABLE_100();
2193: a16 := JTF_VARCHAR2_TABLE_100();
2194: a17 := JTF_VARCHAR2_TABLE_100();

Line 2191: a14 := JTF_VARCHAR2_TABLE_100();

2187: a10 := JTF_NUMBER_TABLE();
2188: a11 := JTF_VARCHAR2_TABLE_100();
2189: a12 := JTF_VARCHAR2_TABLE_100();
2190: a13 := JTF_VARCHAR2_TABLE_100();
2191: a14 := JTF_VARCHAR2_TABLE_100();
2192: a15 := JTF_VARCHAR2_TABLE_100();
2193: a16 := JTF_VARCHAR2_TABLE_100();
2194: a17 := JTF_VARCHAR2_TABLE_100();
2195: a18 := JTF_NUMBER_TABLE();

Line 2192: a15 := JTF_VARCHAR2_TABLE_100();

2188: a11 := JTF_VARCHAR2_TABLE_100();
2189: a12 := JTF_VARCHAR2_TABLE_100();
2190: a13 := JTF_VARCHAR2_TABLE_100();
2191: a14 := JTF_VARCHAR2_TABLE_100();
2192: a15 := JTF_VARCHAR2_TABLE_100();
2193: a16 := JTF_VARCHAR2_TABLE_100();
2194: a17 := JTF_VARCHAR2_TABLE_100();
2195: a18 := JTF_NUMBER_TABLE();
2196: a19 := JTF_NUMBER_TABLE();

Line 2193: a16 := JTF_VARCHAR2_TABLE_100();

2189: a12 := JTF_VARCHAR2_TABLE_100();
2190: a13 := JTF_VARCHAR2_TABLE_100();
2191: a14 := JTF_VARCHAR2_TABLE_100();
2192: a15 := JTF_VARCHAR2_TABLE_100();
2193: a16 := JTF_VARCHAR2_TABLE_100();
2194: a17 := JTF_VARCHAR2_TABLE_100();
2195: a18 := JTF_NUMBER_TABLE();
2196: a19 := JTF_NUMBER_TABLE();
2197: a20 := JTF_VARCHAR2_TABLE_100();

Line 2194: a17 := JTF_VARCHAR2_TABLE_100();

2190: a13 := JTF_VARCHAR2_TABLE_100();
2191: a14 := JTF_VARCHAR2_TABLE_100();
2192: a15 := JTF_VARCHAR2_TABLE_100();
2193: a16 := JTF_VARCHAR2_TABLE_100();
2194: a17 := JTF_VARCHAR2_TABLE_100();
2195: a18 := JTF_NUMBER_TABLE();
2196: a19 := JTF_NUMBER_TABLE();
2197: a20 := JTF_VARCHAR2_TABLE_100();
2198: else

Line 2197: a20 := JTF_VARCHAR2_TABLE_100();

2193: a16 := JTF_VARCHAR2_TABLE_100();
2194: a17 := JTF_VARCHAR2_TABLE_100();
2195: a18 := JTF_NUMBER_TABLE();
2196: a19 := JTF_NUMBER_TABLE();
2197: a20 := JTF_VARCHAR2_TABLE_100();
2198: else
2199: a0 := JTF_NUMBER_TABLE();
2200: a1 := JTF_NUMBER_TABLE();
2201: a2 := JTF_NUMBER_TABLE();

Line 2202: a3 := JTF_VARCHAR2_TABLE_100();

2198: else
2199: a0 := JTF_NUMBER_TABLE();
2200: a1 := JTF_NUMBER_TABLE();
2201: a2 := JTF_NUMBER_TABLE();
2202: a3 := JTF_VARCHAR2_TABLE_100();
2203: a4 := JTF_NUMBER_TABLE();
2204: a5 := JTF_VARCHAR2_TABLE_100();
2205: a6 := JTF_NUMBER_TABLE();
2206: a7 := JTF_NUMBER_TABLE();

Line 2204: a5 := JTF_VARCHAR2_TABLE_100();

2200: a1 := JTF_NUMBER_TABLE();
2201: a2 := JTF_NUMBER_TABLE();
2202: a3 := JTF_VARCHAR2_TABLE_100();
2203: a4 := JTF_NUMBER_TABLE();
2204: a5 := JTF_VARCHAR2_TABLE_100();
2205: a6 := JTF_NUMBER_TABLE();
2206: a7 := JTF_NUMBER_TABLE();
2207: a8 := JTF_NUMBER_TABLE();
2208: a9 := JTF_NUMBER_TABLE();

Line 2210: a11 := JTF_VARCHAR2_TABLE_100();

2206: a7 := JTF_NUMBER_TABLE();
2207: a8 := JTF_NUMBER_TABLE();
2208: a9 := JTF_NUMBER_TABLE();
2209: a10 := JTF_NUMBER_TABLE();
2210: a11 := JTF_VARCHAR2_TABLE_100();
2211: a12 := JTF_VARCHAR2_TABLE_100();
2212: a13 := JTF_VARCHAR2_TABLE_100();
2213: a14 := JTF_VARCHAR2_TABLE_100();
2214: a15 := JTF_VARCHAR2_TABLE_100();

Line 2211: a12 := JTF_VARCHAR2_TABLE_100();

2207: a8 := JTF_NUMBER_TABLE();
2208: a9 := JTF_NUMBER_TABLE();
2209: a10 := JTF_NUMBER_TABLE();
2210: a11 := JTF_VARCHAR2_TABLE_100();
2211: a12 := JTF_VARCHAR2_TABLE_100();
2212: a13 := JTF_VARCHAR2_TABLE_100();
2213: a14 := JTF_VARCHAR2_TABLE_100();
2214: a15 := JTF_VARCHAR2_TABLE_100();
2215: a16 := JTF_VARCHAR2_TABLE_100();

Line 2212: a13 := JTF_VARCHAR2_TABLE_100();

2208: a9 := JTF_NUMBER_TABLE();
2209: a10 := JTF_NUMBER_TABLE();
2210: a11 := JTF_VARCHAR2_TABLE_100();
2211: a12 := JTF_VARCHAR2_TABLE_100();
2212: a13 := JTF_VARCHAR2_TABLE_100();
2213: a14 := JTF_VARCHAR2_TABLE_100();
2214: a15 := JTF_VARCHAR2_TABLE_100();
2215: a16 := JTF_VARCHAR2_TABLE_100();
2216: a17 := JTF_VARCHAR2_TABLE_100();

Line 2213: a14 := JTF_VARCHAR2_TABLE_100();

2209: a10 := JTF_NUMBER_TABLE();
2210: a11 := JTF_VARCHAR2_TABLE_100();
2211: a12 := JTF_VARCHAR2_TABLE_100();
2212: a13 := JTF_VARCHAR2_TABLE_100();
2213: a14 := JTF_VARCHAR2_TABLE_100();
2214: a15 := JTF_VARCHAR2_TABLE_100();
2215: a16 := JTF_VARCHAR2_TABLE_100();
2216: a17 := JTF_VARCHAR2_TABLE_100();
2217: a18 := JTF_NUMBER_TABLE();

Line 2214: a15 := JTF_VARCHAR2_TABLE_100();

2210: a11 := JTF_VARCHAR2_TABLE_100();
2211: a12 := JTF_VARCHAR2_TABLE_100();
2212: a13 := JTF_VARCHAR2_TABLE_100();
2213: a14 := JTF_VARCHAR2_TABLE_100();
2214: a15 := JTF_VARCHAR2_TABLE_100();
2215: a16 := JTF_VARCHAR2_TABLE_100();
2216: a17 := JTF_VARCHAR2_TABLE_100();
2217: a18 := JTF_NUMBER_TABLE();
2218: a19 := JTF_NUMBER_TABLE();

Line 2215: a16 := JTF_VARCHAR2_TABLE_100();

2211: a12 := JTF_VARCHAR2_TABLE_100();
2212: a13 := JTF_VARCHAR2_TABLE_100();
2213: a14 := JTF_VARCHAR2_TABLE_100();
2214: a15 := JTF_VARCHAR2_TABLE_100();
2215: a16 := JTF_VARCHAR2_TABLE_100();
2216: a17 := JTF_VARCHAR2_TABLE_100();
2217: a18 := JTF_NUMBER_TABLE();
2218: a19 := JTF_NUMBER_TABLE();
2219: a20 := JTF_VARCHAR2_TABLE_100();

Line 2216: a17 := JTF_VARCHAR2_TABLE_100();

2212: a13 := JTF_VARCHAR2_TABLE_100();
2213: a14 := JTF_VARCHAR2_TABLE_100();
2214: a15 := JTF_VARCHAR2_TABLE_100();
2215: a16 := JTF_VARCHAR2_TABLE_100();
2216: a17 := JTF_VARCHAR2_TABLE_100();
2217: a18 := JTF_NUMBER_TABLE();
2218: a19 := JTF_NUMBER_TABLE();
2219: a20 := JTF_VARCHAR2_TABLE_100();
2220: if t.count > 0 then

Line 2219: a20 := JTF_VARCHAR2_TABLE_100();

2215: a16 := JTF_VARCHAR2_TABLE_100();
2216: a17 := JTF_VARCHAR2_TABLE_100();
2217: a18 := JTF_NUMBER_TABLE();
2218: a19 := JTF_NUMBER_TABLE();
2219: a20 := JTF_VARCHAR2_TABLE_100();
2220: if t.count > 0 then
2221: a0.extend(t.count);
2222: a1.extend(t.count);
2223: a2.extend(t.count);

Line 2277: , a1 JTF_VARCHAR2_TABLE_100

2273: end if;
2274: end rosetta_table_copy_out_p75;
2275:
2276: procedure rosetta_table_copy_in_p79(t out nocopy oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 JTF_NUMBER_TABLE
2277: , a1 JTF_VARCHAR2_TABLE_100
2278: , a2 JTF_VARCHAR2_TABLE_100
2279: , a3 JTF_DATE_TABLE
2280: , a4 JTF_DATE_TABLE
2281: , a5 JTF_DATE_TABLE

Line 2278: , a2 JTF_VARCHAR2_TABLE_100

2274: end rosetta_table_copy_out_p75;
2275:
2276: procedure rosetta_table_copy_in_p79(t out nocopy oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 JTF_NUMBER_TABLE
2277: , a1 JTF_VARCHAR2_TABLE_100
2278: , a2 JTF_VARCHAR2_TABLE_100
2279: , a3 JTF_DATE_TABLE
2280: , a4 JTF_DATE_TABLE
2281: , a5 JTF_DATE_TABLE
2282: , a6 JTF_DATE_TABLE

Line 2285: , a9 JTF_VARCHAR2_TABLE_100

2281: , a5 JTF_DATE_TABLE
2282: , a6 JTF_DATE_TABLE
2283: , a7 JTF_NUMBER_TABLE
2284: , a8 JTF_NUMBER_TABLE
2285: , a9 JTF_VARCHAR2_TABLE_100
2286: ) as
2287: ddindx binary_integer; indx binary_integer;
2288: begin
2289: if a0 is not null and a0.count > 0 then

Line 2314: , a1 out nocopy JTF_VARCHAR2_TABLE_100

2310: end if;
2311: end if;
2312: end rosetta_table_copy_in_p79;
2313: procedure rosetta_table_copy_out_p79(t oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 out nocopy JTF_NUMBER_TABLE
2314: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2315: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2316: , a3 out nocopy JTF_DATE_TABLE
2317: , a4 out nocopy JTF_DATE_TABLE
2318: , a5 out nocopy JTF_DATE_TABLE

Line 2315: , a2 out nocopy JTF_VARCHAR2_TABLE_100

2311: end if;
2312: end rosetta_table_copy_in_p79;
2313: procedure rosetta_table_copy_out_p79(t oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 out nocopy JTF_NUMBER_TABLE
2314: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2315: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2316: , a3 out nocopy JTF_DATE_TABLE
2317: , a4 out nocopy JTF_DATE_TABLE
2318: , a5 out nocopy JTF_DATE_TABLE
2319: , a6 out nocopy JTF_DATE_TABLE

Line 2322: , a9 out nocopy JTF_VARCHAR2_TABLE_100

2318: , a5 out nocopy JTF_DATE_TABLE
2319: , a6 out nocopy JTF_DATE_TABLE
2320: , a7 out nocopy JTF_NUMBER_TABLE
2321: , a8 out nocopy JTF_NUMBER_TABLE
2322: , a9 out nocopy JTF_VARCHAR2_TABLE_100
2323: ) as
2324: ddindx binary_integer; indx binary_integer;
2325: begin
2326: if t is null or t.count = 0 then

Line 2328: a1 := JTF_VARCHAR2_TABLE_100();

2324: ddindx binary_integer; indx binary_integer;
2325: begin
2326: if t is null or t.count = 0 then
2327: a0 := JTF_NUMBER_TABLE();
2328: a1 := JTF_VARCHAR2_TABLE_100();
2329: a2 := JTF_VARCHAR2_TABLE_100();
2330: a3 := JTF_DATE_TABLE();
2331: a4 := JTF_DATE_TABLE();
2332: a5 := JTF_DATE_TABLE();

Line 2329: a2 := JTF_VARCHAR2_TABLE_100();

2325: begin
2326: if t is null or t.count = 0 then
2327: a0 := JTF_NUMBER_TABLE();
2328: a1 := JTF_VARCHAR2_TABLE_100();
2329: a2 := JTF_VARCHAR2_TABLE_100();
2330: a3 := JTF_DATE_TABLE();
2331: a4 := JTF_DATE_TABLE();
2332: a5 := JTF_DATE_TABLE();
2333: a6 := JTF_DATE_TABLE();

Line 2336: a9 := JTF_VARCHAR2_TABLE_100();

2332: a5 := JTF_DATE_TABLE();
2333: a6 := JTF_DATE_TABLE();
2334: a7 := JTF_NUMBER_TABLE();
2335: a8 := JTF_NUMBER_TABLE();
2336: a9 := JTF_VARCHAR2_TABLE_100();
2337: else
2338: a0 := JTF_NUMBER_TABLE();
2339: a1 := JTF_VARCHAR2_TABLE_100();
2340: a2 := JTF_VARCHAR2_TABLE_100();

Line 2339: a1 := JTF_VARCHAR2_TABLE_100();

2335: a8 := JTF_NUMBER_TABLE();
2336: a9 := JTF_VARCHAR2_TABLE_100();
2337: else
2338: a0 := JTF_NUMBER_TABLE();
2339: a1 := JTF_VARCHAR2_TABLE_100();
2340: a2 := JTF_VARCHAR2_TABLE_100();
2341: a3 := JTF_DATE_TABLE();
2342: a4 := JTF_DATE_TABLE();
2343: a5 := JTF_DATE_TABLE();

Line 2340: a2 := JTF_VARCHAR2_TABLE_100();

2336: a9 := JTF_VARCHAR2_TABLE_100();
2337: else
2338: a0 := JTF_NUMBER_TABLE();
2339: a1 := JTF_VARCHAR2_TABLE_100();
2340: a2 := JTF_VARCHAR2_TABLE_100();
2341: a3 := JTF_DATE_TABLE();
2342: a4 := JTF_DATE_TABLE();
2343: a5 := JTF_DATE_TABLE();
2344: a6 := JTF_DATE_TABLE();

Line 2347: a9 := JTF_VARCHAR2_TABLE_100();

2343: a5 := JTF_DATE_TABLE();
2344: a6 := JTF_DATE_TABLE();
2345: a7 := JTF_NUMBER_TABLE();
2346: a8 := JTF_NUMBER_TABLE();
2347: a9 := JTF_VARCHAR2_TABLE_100();
2348: if t.count > 0 then
2349: a0.extend(t.count);
2350: a1.extend(t.count);
2351: a2.extend(t.count);

Line 2384: , a2 JTF_VARCHAR2_TABLE_100

2380: end rosetta_table_copy_out_p79;
2381:
2382: procedure rosetta_table_copy_in_p81(t out nocopy oks_entitlements_pub.srchline_covlvl_id_tbl, a0 JTF_NUMBER_TABLE
2383: , a1 JTF_NUMBER_TABLE
2384: , a2 JTF_VARCHAR2_TABLE_100
2385: ) as
2386: ddindx binary_integer; indx binary_integer;
2387: begin
2388: if a0 is not null and a0.count > 0 then

Line 2407: , a2 out nocopy JTF_VARCHAR2_TABLE_100

2403: end if;
2404: end rosetta_table_copy_in_p81;
2405: procedure rosetta_table_copy_out_p81(t oks_entitlements_pub.srchline_covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
2406: , a1 out nocopy JTF_NUMBER_TABLE
2407: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2408: ) as
2409: ddindx binary_integer; indx binary_integer;
2410: begin
2411: if t is null or t.count = 0 then

Line 2414: a2 := JTF_VARCHAR2_TABLE_100();

2410: begin
2411: if t is null or t.count = 0 then
2412: a0 := JTF_NUMBER_TABLE();
2413: a1 := JTF_NUMBER_TABLE();
2414: a2 := JTF_VARCHAR2_TABLE_100();
2415: else
2416: a0 := JTF_NUMBER_TABLE();
2417: a1 := JTF_NUMBER_TABLE();
2418: a2 := JTF_VARCHAR2_TABLE_100();

Line 2418: a2 := JTF_VARCHAR2_TABLE_100();

2414: a2 := JTF_VARCHAR2_TABLE_100();
2415: else
2416: a0 := JTF_NUMBER_TABLE();
2417: a1 := JTF_NUMBER_TABLE();
2418: a2 := JTF_VARCHAR2_TABLE_100();
2419: if t.count > 0 then
2420: a0.extend(t.count);
2421: a1.extend(t.count);
2422: a2.extend(t.count);

Line 2447: , a8 JTF_VARCHAR2_TABLE_100

2443: , a4 JTF_VARCHAR2_TABLE_2000
2444: , a5 JTF_VARCHAR2_TABLE_2000
2445: , a6 JTF_DATE_TABLE
2446: , a7 JTF_DATE_TABLE
2447: , a8 JTF_VARCHAR2_TABLE_100
2448: , a9 JTF_VARCHAR2_TABLE_200
2449: , a10 JTF_NUMBER_TABLE
2450: , a11 JTF_NUMBER_TABLE
2451: , a12 JTF_NUMBER_TABLE

Line 2454: , a15 JTF_VARCHAR2_TABLE_100

2450: , a11 JTF_NUMBER_TABLE
2451: , a12 JTF_NUMBER_TABLE
2452: , a13 JTF_NUMBER_TABLE
2453: , a14 JTF_NUMBER_TABLE
2454: , a15 JTF_VARCHAR2_TABLE_100
2455: , a16 JTF_NUMBER_TABLE
2456: , a17 JTF_VARCHAR2_TABLE_300
2457: ) as
2458: ddindx binary_integer; indx binary_integer;

Line 2500: , a8 out nocopy JTF_VARCHAR2_TABLE_100

2496: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
2497: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
2498: , a6 out nocopy JTF_DATE_TABLE
2499: , a7 out nocopy JTF_DATE_TABLE
2500: , a8 out nocopy JTF_VARCHAR2_TABLE_100
2501: , a9 out nocopy JTF_VARCHAR2_TABLE_200
2502: , a10 out nocopy JTF_NUMBER_TABLE
2503: , a11 out nocopy JTF_NUMBER_TABLE
2504: , a12 out nocopy JTF_NUMBER_TABLE

Line 2507: , a15 out nocopy JTF_VARCHAR2_TABLE_100

2503: , a11 out nocopy JTF_NUMBER_TABLE
2504: , a12 out nocopy JTF_NUMBER_TABLE
2505: , a13 out nocopy JTF_NUMBER_TABLE
2506: , a14 out nocopy JTF_NUMBER_TABLE
2507: , a15 out nocopy JTF_VARCHAR2_TABLE_100
2508: , a16 out nocopy JTF_NUMBER_TABLE
2509: , a17 out nocopy JTF_VARCHAR2_TABLE_300
2510: ) as
2511: ddindx binary_integer; indx binary_integer;

Line 2522: a8 := JTF_VARCHAR2_TABLE_100();

2518: a4 := JTF_VARCHAR2_TABLE_2000();
2519: a5 := JTF_VARCHAR2_TABLE_2000();
2520: a6 := JTF_DATE_TABLE();
2521: a7 := JTF_DATE_TABLE();
2522: a8 := JTF_VARCHAR2_TABLE_100();
2523: a9 := JTF_VARCHAR2_TABLE_200();
2524: a10 := JTF_NUMBER_TABLE();
2525: a11 := JTF_NUMBER_TABLE();
2526: a12 := JTF_NUMBER_TABLE();

Line 2529: a15 := JTF_VARCHAR2_TABLE_100();

2525: a11 := JTF_NUMBER_TABLE();
2526: a12 := JTF_NUMBER_TABLE();
2527: a13 := JTF_NUMBER_TABLE();
2528: a14 := JTF_NUMBER_TABLE();
2529: a15 := JTF_VARCHAR2_TABLE_100();
2530: a16 := JTF_NUMBER_TABLE();
2531: a17 := JTF_VARCHAR2_TABLE_300();
2532: else
2533: a0 := JTF_VARCHAR2_TABLE_200();

Line 2541: a8 := JTF_VARCHAR2_TABLE_100();

2537: a4 := JTF_VARCHAR2_TABLE_2000();
2538: a5 := JTF_VARCHAR2_TABLE_2000();
2539: a6 := JTF_DATE_TABLE();
2540: a7 := JTF_DATE_TABLE();
2541: a8 := JTF_VARCHAR2_TABLE_100();
2542: a9 := JTF_VARCHAR2_TABLE_200();
2543: a10 := JTF_NUMBER_TABLE();
2544: a11 := JTF_NUMBER_TABLE();
2545: a12 := JTF_NUMBER_TABLE();

Line 2548: a15 := JTF_VARCHAR2_TABLE_100();

2544: a11 := JTF_NUMBER_TABLE();
2545: a12 := JTF_NUMBER_TABLE();
2546: a13 := JTF_NUMBER_TABLE();
2547: a14 := JTF_NUMBER_TABLE();
2548: a15 := JTF_VARCHAR2_TABLE_100();
2549: a16 := JTF_NUMBER_TABLE();
2550: a17 := JTF_VARCHAR2_TABLE_300();
2551: if t.count > 0 then
2552: a0.extend(t.count);

Line 2617: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

2613: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
2614: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
2615: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
2616: , p6_a5 out nocopy JTF_NUMBER_TABLE
2617: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2618: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2619: , p6_a8 out nocopy JTF_NUMBER_TABLE
2620: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2621: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 2618: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

2614: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
2615: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
2616: , p6_a5 out nocopy JTF_NUMBER_TABLE
2617: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2618: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2619: , p6_a8 out nocopy JTF_NUMBER_TABLE
2620: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2621: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
2622: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 2620: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

2616: , p6_a5 out nocopy JTF_NUMBER_TABLE
2617: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2618: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2619: , p6_a8 out nocopy JTF_NUMBER_TABLE
2620: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2621: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
2622: , p6_a11 out nocopy JTF_NUMBER_TABLE
2623: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2624: , p6_a13 out nocopy JTF_DATE_TABLE

Line 2623: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

2619: , p6_a8 out nocopy JTF_NUMBER_TABLE
2620: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2621: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
2622: , p6_a11 out nocopy JTF_NUMBER_TABLE
2623: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2624: , p6_a13 out nocopy JTF_DATE_TABLE
2625: , p6_a14 out nocopy JTF_DATE_TABLE
2626: , p6_a15 out nocopy JTF_NUMBER_TABLE
2627: , p6_a16 out nocopy JTF_NUMBER_TABLE

Line 2631: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

2627: , p6_a16 out nocopy JTF_NUMBER_TABLE
2628: , p6_a17 out nocopy JTF_NUMBER_TABLE
2629: , p6_a18 out nocopy JTF_NUMBER_TABLE
2630: , p6_a19 out nocopy JTF_NUMBER_TABLE
2631: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2632: , p6_a21 out nocopy JTF_NUMBER_TABLE
2633: , p6_a22 out nocopy JTF_NUMBER_TABLE
2634: , p6_a23 out nocopy JTF_NUMBER_TABLE
2635: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200

Line 2637: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100

2633: , p6_a22 out nocopy JTF_NUMBER_TABLE
2634: , p6_a23 out nocopy JTF_NUMBER_TABLE
2635: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
2636: , p6_a25 out nocopy JTF_NUMBER_TABLE
2637: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2638: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2639: , p6_a28 out nocopy JTF_NUMBER_TABLE
2640: , p6_a29 out nocopy JTF_DATE_TABLE
2641: , p6_a30 out nocopy JTF_DATE_TABLE

Line 2638: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

2634: , p6_a23 out nocopy JTF_NUMBER_TABLE
2635: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
2636: , p6_a25 out nocopy JTF_NUMBER_TABLE
2637: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
2638: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2639: , p6_a28 out nocopy JTF_NUMBER_TABLE
2640: , p6_a29 out nocopy JTF_DATE_TABLE
2641: , p6_a30 out nocopy JTF_DATE_TABLE
2642: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 2736: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

2732: , x_msg_data out nocopy VARCHAR2
2733: , p6_a0 out nocopy JTF_NUMBER_TABLE
2734: , p6_a1 out nocopy JTF_NUMBER_TABLE
2735: , p6_a2 out nocopy JTF_NUMBER_TABLE
2736: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2737: , p6_a4 out nocopy JTF_NUMBER_TABLE
2738: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2739: , p6_a6 out nocopy JTF_DATE_TABLE
2740: , p6_a7 out nocopy JTF_DATE_TABLE

Line 2738: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

2734: , p6_a1 out nocopy JTF_NUMBER_TABLE
2735: , p6_a2 out nocopy JTF_NUMBER_TABLE
2736: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2737: , p6_a4 out nocopy JTF_NUMBER_TABLE
2738: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2739: , p6_a6 out nocopy JTF_DATE_TABLE
2740: , p6_a7 out nocopy JTF_DATE_TABLE
2741: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
2742: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 2749: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

2745: , p6_a12 out nocopy JTF_NUMBER_TABLE
2746: , p6_a13 out nocopy JTF_NUMBER_TABLE
2747: , p6_a14 out nocopy JTF_NUMBER_TABLE
2748: , p6_a15 out nocopy JTF_NUMBER_TABLE
2749: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2750: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
2751: , p6_a18 out nocopy JTF_NUMBER_TABLE
2752: , p6_a19 out nocopy JTF_DATE_TABLE
2753: , p6_a20 out nocopy JTF_DATE_TABLE

Line 2750: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

2746: , p6_a13 out nocopy JTF_NUMBER_TABLE
2747: , p6_a14 out nocopy JTF_NUMBER_TABLE
2748: , p6_a15 out nocopy JTF_NUMBER_TABLE
2749: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2750: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
2751: , p6_a18 out nocopy JTF_NUMBER_TABLE
2752: , p6_a19 out nocopy JTF_DATE_TABLE
2753: , p6_a20 out nocopy JTF_DATE_TABLE
2754: , p6_a21 out nocopy JTF_DATE_TABLE

Line 2817: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100

2813: , p_contract_line_id NUMBER
2814: , x_return_status out nocopy VARCHAR2
2815: , x_msg_count out nocopy NUMBER
2816: , x_msg_data out nocopy VARCHAR2
2817: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
2818: , p6_a1 out nocopy JTF_NUMBER_TABLE
2819: , p6_a2 out nocopy JTF_NUMBER_TABLE
2820: , p6_a3 out nocopy JTF_NUMBER_TABLE
2821: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 2838: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

2834: , p6_a17 out nocopy JTF_NUMBER_TABLE
2835: , p6_a18 out nocopy JTF_NUMBER_TABLE
2836: , p6_a19 out nocopy JTF_NUMBER_TABLE
2837: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
2838: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2839: , p6_a22 out nocopy JTF_NUMBER_TABLE
2840: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2841: , p6_a24 out nocopy JTF_NUMBER_TABLE
2842: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 2840: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100

2836: , p6_a19 out nocopy JTF_NUMBER_TABLE
2837: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
2838: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2839: , p6_a22 out nocopy JTF_NUMBER_TABLE
2840: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2841: , p6_a24 out nocopy JTF_NUMBER_TABLE
2842: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2843: , p6_a26 out nocopy JTF_NUMBER_TABLE
2844: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 2842: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

2838: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2839: , p6_a22 out nocopy JTF_NUMBER_TABLE
2840: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2841: , p6_a24 out nocopy JTF_NUMBER_TABLE
2842: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2843: , p6_a26 out nocopy JTF_NUMBER_TABLE
2844: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2845: , p6_a28 out nocopy JTF_NUMBER_TABLE
2846: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100

Line 2844: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

2840: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2841: , p6_a24 out nocopy JTF_NUMBER_TABLE
2842: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2843: , p6_a26 out nocopy JTF_NUMBER_TABLE
2844: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2845: , p6_a28 out nocopy JTF_NUMBER_TABLE
2846: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
2847: , p6_a30 out nocopy JTF_NUMBER_TABLE
2848: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

Line 2846: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100

2842: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
2843: , p6_a26 out nocopy JTF_NUMBER_TABLE
2844: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2845: , p6_a28 out nocopy JTF_NUMBER_TABLE
2846: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
2847: , p6_a30 out nocopy JTF_NUMBER_TABLE
2848: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
2849: , p6_a32 out nocopy JTF_NUMBER_TABLE
2850: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 2848: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

2844: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
2845: , p6_a28 out nocopy JTF_NUMBER_TABLE
2846: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
2847: , p6_a30 out nocopy JTF_NUMBER_TABLE
2848: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
2849: , p6_a32 out nocopy JTF_NUMBER_TABLE
2850: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
2851: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
2852: )

Line 2850: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100

2846: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
2847: , p6_a30 out nocopy JTF_NUMBER_TABLE
2848: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
2849: , p6_a32 out nocopy JTF_NUMBER_TABLE
2850: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
2851: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
2852: )
2853:
2854: as

Line 2851: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100

2847: , p6_a30 out nocopy JTF_NUMBER_TABLE
2848: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
2849: , p6_a32 out nocopy JTF_NUMBER_TABLE
2850: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
2851: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
2852: )
2853:
2854: as
2855: ddx_covered_levels oks_entitlements_pub.clvl_tbl_type;

Line 2946: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

2942: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
2943: , p6_a6 out nocopy JTF_NUMBER_TABLE
2944: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
2945: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
2946: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2947: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2948: , p6_a11 out nocopy JTF_NUMBER_TABLE
2949: , p6_a12 out nocopy JTF_NUMBER_TABLE
2950: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 2947: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

2943: , p6_a6 out nocopy JTF_NUMBER_TABLE
2944: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
2945: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
2946: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2947: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2948: , p6_a11 out nocopy JTF_NUMBER_TABLE
2949: , p6_a12 out nocopy JTF_NUMBER_TABLE
2950: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
2951: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 2951: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

2947: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2948: , p6_a11 out nocopy JTF_NUMBER_TABLE
2949: , p6_a12 out nocopy JTF_NUMBER_TABLE
2950: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
2951: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2952: , p6_a15 out nocopy JTF_DATE_TABLE
2953: , p6_a16 out nocopy JTF_DATE_TABLE
2954: , p6_a17 out nocopy JTF_NUMBER_TABLE
2955: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 2955: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

2951: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2952: , p6_a15 out nocopy JTF_DATE_TABLE
2953: , p6_a16 out nocopy JTF_DATE_TABLE
2954: , p6_a17 out nocopy JTF_NUMBER_TABLE
2955: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
2956: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2957: )
2958:
2959: as

Line 2956: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

2952: , p6_a15 out nocopy JTF_DATE_TABLE
2953: , p6_a16 out nocopy JTF_DATE_TABLE
2954: , p6_a17 out nocopy JTF_NUMBER_TABLE
2955: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
2956: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2957: )
2958:
2959: as
2960: ddp_inp_rec oks_entitlements_pub.inp_cont_rec;

Line 3049: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

3045: , x_msg_data out nocopy VARCHAR2
3046: , p6_a0 out nocopy JTF_NUMBER_TABLE
3047: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
3048: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
3049: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
3050: , p6_a4 out nocopy JTF_NUMBER_TABLE
3051: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
3052: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
3053: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 3056: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

3052: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
3053: , p6_a7 out nocopy JTF_NUMBER_TABLE
3054: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
3055: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
3056: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
3057: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
3058: , p6_a12 out nocopy JTF_NUMBER_TABLE
3059: , p6_a13 out nocopy JTF_DATE_TABLE
3060: , p6_a14 out nocopy JTF_DATE_TABLE

Line 3057: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

3053: , p6_a7 out nocopy JTF_NUMBER_TABLE
3054: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
3055: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
3056: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
3057: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
3058: , p6_a12 out nocopy JTF_NUMBER_TABLE
3059: , p6_a13 out nocopy JTF_DATE_TABLE
3060: , p6_a14 out nocopy JTF_DATE_TABLE
3061: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 3061: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

3057: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
3058: , p6_a12 out nocopy JTF_NUMBER_TABLE
3059: , p6_a13 out nocopy JTF_DATE_TABLE
3060: , p6_a14 out nocopy JTF_DATE_TABLE
3061: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
3062: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
3063: , p6_a17 out nocopy JTF_DATE_TABLE
3064: , p6_a18 out nocopy JTF_DATE_TABLE
3065: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 3062: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

3058: , p6_a12 out nocopy JTF_NUMBER_TABLE
3059: , p6_a13 out nocopy JTF_DATE_TABLE
3060: , p6_a14 out nocopy JTF_DATE_TABLE
3061: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
3062: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
3063: , p6_a17 out nocopy JTF_DATE_TABLE
3064: , p6_a18 out nocopy JTF_DATE_TABLE
3065: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
3066: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000

Line 3065: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

3061: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
3062: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
3063: , p6_a17 out nocopy JTF_DATE_TABLE
3064: , p6_a18 out nocopy JTF_DATE_TABLE
3065: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
3066: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
3067: , p6_a21 out nocopy JTF_DATE_TABLE
3068: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
3069: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 3068: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

3064: , p6_a18 out nocopy JTF_DATE_TABLE
3065: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
3066: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
3067: , p6_a21 out nocopy JTF_DATE_TABLE
3068: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
3069: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
3070: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
3071: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
3072: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 3070: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100

3066: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
3067: , p6_a21 out nocopy JTF_DATE_TABLE
3068: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
3069: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
3070: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
3071: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
3072: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
3073: , p6_a27 out nocopy JTF_NUMBER_TABLE
3074: )

Line 3072: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100

3068: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
3069: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
3070: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
3071: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
3072: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
3073: , p6_a27 out nocopy JTF_NUMBER_TABLE
3074: )
3075:
3076: as

Line 3178: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

3174: , x_msg_data out nocopy VARCHAR2
3175: , p6_a0 out nocopy JTF_NUMBER_TABLE
3176: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
3177: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
3178: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
3179: , p6_a4 out nocopy JTF_NUMBER_TABLE
3180: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
3181: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
3182: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 3185: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

3181: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
3182: , p6_a7 out nocopy JTF_NUMBER_TABLE
3183: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
3184: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
3185: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
3186: , p6_a11 out nocopy JTF_NUMBER_TABLE
3187: , p6_a12 out nocopy JTF_DATE_TABLE
3188: , p6_a13 out nocopy JTF_DATE_TABLE
3189: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 3189: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

3185: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
3186: , p6_a11 out nocopy JTF_NUMBER_TABLE
3187: , p6_a12 out nocopy JTF_DATE_TABLE
3188: , p6_a13 out nocopy JTF_DATE_TABLE
3189: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
3190: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
3191: , p6_a16 out nocopy JTF_DATE_TABLE
3192: , p6_a17 out nocopy JTF_DATE_TABLE
3193: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 3190: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

3186: , p6_a11 out nocopy JTF_NUMBER_TABLE
3187: , p6_a12 out nocopy JTF_DATE_TABLE
3188: , p6_a13 out nocopy JTF_DATE_TABLE
3189: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
3190: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
3191: , p6_a16 out nocopy JTF_DATE_TABLE
3192: , p6_a17 out nocopy JTF_DATE_TABLE
3193: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
3194: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_2000

Line 3193: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

3189: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
3190: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
3191: , p6_a16 out nocopy JTF_DATE_TABLE
3192: , p6_a17 out nocopy JTF_DATE_TABLE
3193: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
3194: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_2000
3195: , p6_a20 out nocopy JTF_DATE_TABLE
3196: , p6_a21 out nocopy JTF_NUMBER_TABLE
3197: )

Line 3291: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

3287: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
3288: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
3289: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
3290: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
3291: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
3292: , p6_a6 out nocopy JTF_DATE_TABLE
3293: , p6_a7 out nocopy JTF_DATE_TABLE
3294: , p6_a8 out nocopy JTF_DATE_TABLE
3295: )

Line 3356: , p5_a0 JTF_VARCHAR2_TABLE_100

3352: , p_init_msg_list VARCHAR2
3353: , p_contract_line_id NUMBER
3354: , p_busiproc_id NUMBER
3355: , p_request_date date
3356: , p5_a0 JTF_VARCHAR2_TABLE_100
3357: , p5_a1 JTF_NUMBER_TABLE
3358: , p5_a2 JTF_NUMBER_TABLE
3359: , p5_a3 JTF_VARCHAR2_TABLE_100
3360: , p_verify_combination VARCHAR2

Line 3359: , p5_a3 JTF_VARCHAR2_TABLE_100

3355: , p_request_date date
3356: , p5_a0 JTF_VARCHAR2_TABLE_100
3357: , p5_a1 JTF_NUMBER_TABLE
3358: , p5_a2 JTF_NUMBER_TABLE
3359: , p5_a3 JTF_VARCHAR2_TABLE_100
3360: , p_verify_combination VARCHAR2
3361: , x_return_status out nocopy VARCHAR2
3362: , x_msg_count out nocopy NUMBER
3363: , x_msg_data out nocopy VARCHAR2

Line 3364: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_100

3360: , p_verify_combination VARCHAR2
3361: , x_return_status out nocopy VARCHAR2
3362: , x_msg_count out nocopy NUMBER
3363: , x_msg_data out nocopy VARCHAR2
3364: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_100
3365: , p10_a1 out nocopy JTF_NUMBER_TABLE
3366: , p10_a2 out nocopy JTF_NUMBER_TABLE
3367: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
3368: , x_combination_valid out nocopy VARCHAR2

Line 3367: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100

3363: , x_msg_data out nocopy VARCHAR2
3364: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_100
3365: , p10_a1 out nocopy JTF_NUMBER_TABLE
3366: , p10_a2 out nocopy JTF_NUMBER_TABLE
3367: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
3368: , x_combination_valid out nocopy VARCHAR2
3369: )
3370:
3371: as

Line 3445: , p3_a1 JTF_VARCHAR2_TABLE_100

3441: , p2_a9 NUMBER
3442: , p2_a10 DATE
3443: , p2_a11 VARCHAR2
3444: , p3_a0 JTF_NUMBER_TABLE
3445: , p3_a1 JTF_VARCHAR2_TABLE_100
3446: , x_return_status out nocopy VARCHAR2
3447: , x_msg_count out nocopy NUMBER
3448: , x_msg_data out nocopy VARCHAR2
3449: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_200

Line 3451: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

3447: , x_msg_count out nocopy NUMBER
3448: , x_msg_data out nocopy VARCHAR2
3449: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_200
3450: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
3451: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
3452: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
3453: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
3454: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_2000
3455: , p7_a6 out nocopy JTF_DATE_TABLE

Line 3452: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

3448: , x_msg_data out nocopy VARCHAR2
3449: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_200
3450: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
3451: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
3452: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
3453: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
3454: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_2000
3455: , p7_a6 out nocopy JTF_DATE_TABLE
3456: , p7_a7 out nocopy JTF_DATE_TABLE

Line 3459: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

3455: , p7_a6 out nocopy JTF_DATE_TABLE
3456: , p7_a7 out nocopy JTF_DATE_TABLE
3457: , p7_a8 out nocopy JTF_DATE_TABLE
3458: , p7_a9 out nocopy JTF_NUMBER_TABLE
3459: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
3460: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
3461: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
3462: )
3463:

Line 3460: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100

3456: , p7_a7 out nocopy JTF_DATE_TABLE
3457: , p7_a8 out nocopy JTF_DATE_TABLE
3458: , p7_a9 out nocopy JTF_NUMBER_TABLE
3459: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
3460: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
3461: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
3462: )
3463:
3464: as

Line 3461: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100

3457: , p7_a8 out nocopy JTF_DATE_TABLE
3458: , p7_a9 out nocopy JTF_NUMBER_TABLE
3459: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
3460: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
3461: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
3462: )
3463:
3464: as
3465: ddp_contract_rec oks_entitlements_pub.inp_cont_rec_type;

Line 3842: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

3838: , x_msg_data out nocopy VARCHAR2
3839: , p7_a0 out nocopy JTF_NUMBER_TABLE
3840: , p7_a1 out nocopy JTF_NUMBER_TABLE
3841: , p7_a2 out nocopy JTF_NUMBER_TABLE
3842: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
3843: , p7_a4 out nocopy JTF_NUMBER_TABLE
3844: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
3845: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
3846: )

Line 3844: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

3840: , p7_a1 out nocopy JTF_NUMBER_TABLE
3841: , p7_a2 out nocopy JTF_NUMBER_TABLE
3842: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
3843: , p7_a4 out nocopy JTF_NUMBER_TABLE
3844: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
3845: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
3846: )
3847:
3848: as

Line 3845: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

3841: , p7_a2 out nocopy JTF_NUMBER_TABLE
3842: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
3843: , p7_a4 out nocopy JTF_NUMBER_TABLE
3844: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
3845: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
3846: )
3847:
3848: as
3849: ddx_ent_contacts oks_entitlements_pub.ent_contact_tbl;

Line 3900: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

3896: , x_msg_count out nocopy NUMBER
3897: , x_msg_data out nocopy VARCHAR2
3898: , p8_a0 out nocopy JTF_NUMBER_TABLE
3899: , p8_a1 out nocopy JTF_NUMBER_TABLE
3900: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
3901: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
3902: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
3903: )
3904:

Line 3901: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100

3897: , x_msg_data out nocopy VARCHAR2
3898: , p8_a0 out nocopy JTF_NUMBER_TABLE
3899: , p8_a1 out nocopy JTF_NUMBER_TABLE
3900: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
3901: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
3902: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
3903: )
3904:
3905: as

Line 3902: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100

3898: , p8_a0 out nocopy JTF_NUMBER_TABLE
3899: , p8_a1 out nocopy JTF_NUMBER_TABLE
3900: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
3901: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
3902: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
3903: )
3904:
3905: as
3906: ddp_request_date date;

Line 4172: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100

4168: , p7_a3 out nocopy JTF_NUMBER_TABLE
4169: , p8_a0 out nocopy JTF_NUMBER_TABLE
4170: , p8_a1 out nocopy JTF_NUMBER_TABLE
4171: , p8_a2 out nocopy JTF_NUMBER_TABLE
4172: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
4173: , p8_a4 out nocopy JTF_NUMBER_TABLE
4174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
4175: , p8_a6 out nocopy JTF_NUMBER_TABLE
4176: , p8_a7 out nocopy JTF_NUMBER_TABLE

Line 4174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

4170: , p8_a1 out nocopy JTF_NUMBER_TABLE
4171: , p8_a2 out nocopy JTF_NUMBER_TABLE
4172: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
4173: , p8_a4 out nocopy JTF_NUMBER_TABLE
4174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
4175: , p8_a6 out nocopy JTF_NUMBER_TABLE
4176: , p8_a7 out nocopy JTF_NUMBER_TABLE
4177: , p8_a8 out nocopy JTF_NUMBER_TABLE
4178: , p8_a9 out nocopy JTF_NUMBER_TABLE

Line 4180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100

4176: , p8_a7 out nocopy JTF_NUMBER_TABLE
4177: , p8_a8 out nocopy JTF_NUMBER_TABLE
4178: , p8_a9 out nocopy JTF_NUMBER_TABLE
4179: , p8_a10 out nocopy JTF_NUMBER_TABLE
4180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
4181: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
4182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
4183: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
4184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 4181: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100

4177: , p8_a8 out nocopy JTF_NUMBER_TABLE
4178: , p8_a9 out nocopy JTF_NUMBER_TABLE
4179: , p8_a10 out nocopy JTF_NUMBER_TABLE
4180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
4181: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
4182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
4183: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
4184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 4182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100

4178: , p8_a9 out nocopy JTF_NUMBER_TABLE
4179: , p8_a10 out nocopy JTF_NUMBER_TABLE
4180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
4181: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
4182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
4183: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
4184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
4186: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 4183: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100

4179: , p8_a10 out nocopy JTF_NUMBER_TABLE
4180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
4181: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
4182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
4183: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
4184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
4186: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
4187: , p8_a18 out nocopy JTF_NUMBER_TABLE

Line 4184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100

4180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
4181: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
4182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
4183: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
4184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
4186: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
4187: , p8_a18 out nocopy JTF_NUMBER_TABLE
4188: , p8_a19 out nocopy JTF_NUMBER_TABLE

Line 4185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100

4181: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
4182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
4183: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
4184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
4186: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
4187: , p8_a18 out nocopy JTF_NUMBER_TABLE
4188: , p8_a19 out nocopy JTF_NUMBER_TABLE
4189: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 4186: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100

4182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
4183: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
4184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
4186: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
4187: , p8_a18 out nocopy JTF_NUMBER_TABLE
4188: , p8_a19 out nocopy JTF_NUMBER_TABLE
4189: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
4190: )

Line 4189: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100

4185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
4186: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
4187: , p8_a18 out nocopy JTF_NUMBER_TABLE
4188: , p8_a19 out nocopy JTF_NUMBER_TABLE
4189: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
4190: )
4191:
4192: as
4193: ddx_txn_bill_types oks_entitlements_pub.output_tbl_bt;

Line 4287: , p4_a2 JTF_VARCHAR2_TABLE_100

4283: , p3_a8 NUMBER
4284: , p3_a9 VARCHAR2
4285: , p4_a0 JTF_NUMBER_TABLE
4286: , p4_a1 JTF_NUMBER_TABLE
4287: , p4_a2 JTF_VARCHAR2_TABLE_100
4288: , x_return_status out nocopy VARCHAR2
4289: , x_msg_count out nocopy NUMBER
4290: , x_msg_data out nocopy VARCHAR2
4291: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_200

Line 4299: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100

4295: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
4296: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_2000
4297: , p8_a6 out nocopy JTF_DATE_TABLE
4298: , p8_a7 out nocopy JTF_DATE_TABLE
4299: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
4300: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_200
4301: , p8_a10 out nocopy JTF_NUMBER_TABLE
4302: , p8_a11 out nocopy JTF_NUMBER_TABLE
4303: , p8_a12 out nocopy JTF_NUMBER_TABLE

Line 4306: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100

4302: , p8_a11 out nocopy JTF_NUMBER_TABLE
4303: , p8_a12 out nocopy JTF_NUMBER_TABLE
4304: , p8_a13 out nocopy JTF_NUMBER_TABLE
4305: , p8_a14 out nocopy JTF_NUMBER_TABLE
4306: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
4307: , p8_a16 out nocopy JTF_NUMBER_TABLE
4308: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_300
4309: )
4310: