APPS.OKL_FUNDING_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 336: , p5_a2 JTF_VARCHAR2_TABLE_100

332: , x_msg_count out nocopy NUMBER
333: , x_msg_data out nocopy VARCHAR2
334: , p5_a0 JTF_NUMBER_TABLE
335: , p5_a1 JTF_NUMBER_TABLE
336: , p5_a2 JTF_VARCHAR2_TABLE_100
337: , p5_a3 JTF_NUMBER_TABLE
338: , p5_a4 JTF_NUMBER_TABLE
339: , p5_a5 JTF_VARCHAR2_TABLE_100
340: , p5_a6 JTF_NUMBER_TABLE

Line 339: , p5_a5 JTF_VARCHAR2_TABLE_100

335: , p5_a1 JTF_NUMBER_TABLE
336: , p5_a2 JTF_VARCHAR2_TABLE_100
337: , p5_a3 JTF_NUMBER_TABLE
338: , p5_a4 JTF_NUMBER_TABLE
339: , p5_a5 JTF_VARCHAR2_TABLE_100
340: , p5_a6 JTF_NUMBER_TABLE
341: , p5_a7 JTF_NUMBER_TABLE
342: , p5_a8 JTF_NUMBER_TABLE
343: , p5_a9 JTF_NUMBER_TABLE

Line 345: , p5_a11 JTF_VARCHAR2_TABLE_100

341: , p5_a7 JTF_NUMBER_TABLE
342: , p5_a8 JTF_NUMBER_TABLE
343: , p5_a9 JTF_NUMBER_TABLE
344: , p5_a10 JTF_NUMBER_TABLE
345: , p5_a11 JTF_VARCHAR2_TABLE_100
346: , p5_a12 JTF_NUMBER_TABLE
347: , p5_a13 JTF_NUMBER_TABLE
348: , p5_a14 JTF_DATE_TABLE
349: , p5_a15 JTF_NUMBER_TABLE

Line 356: , p5_a22 JTF_VARCHAR2_TABLE_100

352: , p5_a18 JTF_NUMBER_TABLE
353: , p5_a19 JTF_NUMBER_TABLE
354: , p5_a20 JTF_VARCHAR2_TABLE_2000
355: , p5_a21 JTF_VARCHAR2_TABLE_3000
356: , p5_a22 JTF_VARCHAR2_TABLE_100
357: , p5_a23 JTF_VARCHAR2_TABLE_500
358: , p5_a24 JTF_VARCHAR2_TABLE_500
359: , p5_a25 JTF_VARCHAR2_TABLE_500
360: , p5_a26 JTF_VARCHAR2_TABLE_500

Line 382: , p5_a48 JTF_VARCHAR2_TABLE_100

378: , p5_a44 JTF_DATE_TABLE
379: , p5_a45 JTF_NUMBER_TABLE
380: , p5_a46 JTF_DATE_TABLE
381: , p5_a47 JTF_NUMBER_TABLE
382: , p5_a48 JTF_VARCHAR2_TABLE_100
383: , p5_a49 JTF_VARCHAR2_TABLE_100
384: , p5_a50 JTF_NUMBER_TABLE
385: , p5_a51 JTF_NUMBER_TABLE
386: , p5_a52 JTF_VARCHAR2_TABLE_100

Line 383: , p5_a49 JTF_VARCHAR2_TABLE_100

379: , p5_a45 JTF_NUMBER_TABLE
380: , p5_a46 JTF_DATE_TABLE
381: , p5_a47 JTF_NUMBER_TABLE
382: , p5_a48 JTF_VARCHAR2_TABLE_100
383: , p5_a49 JTF_VARCHAR2_TABLE_100
384: , p5_a50 JTF_NUMBER_TABLE
385: , p5_a51 JTF_NUMBER_TABLE
386: , p5_a52 JTF_VARCHAR2_TABLE_100
387: , p5_a53 JTF_NUMBER_TABLE

Line 386: , p5_a52 JTF_VARCHAR2_TABLE_100

382: , p5_a48 JTF_VARCHAR2_TABLE_100
383: , p5_a49 JTF_VARCHAR2_TABLE_100
384: , p5_a50 JTF_NUMBER_TABLE
385: , p5_a51 JTF_NUMBER_TABLE
386: , p5_a52 JTF_VARCHAR2_TABLE_100
387: , p5_a53 JTF_NUMBER_TABLE
388: , p6_a0 out nocopy JTF_NUMBER_TABLE
389: , p6_a1 out nocopy JTF_NUMBER_TABLE
390: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 390: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

386: , p5_a52 JTF_VARCHAR2_TABLE_100
387: , p5_a53 JTF_NUMBER_TABLE
388: , p6_a0 out nocopy JTF_NUMBER_TABLE
389: , p6_a1 out nocopy JTF_NUMBER_TABLE
390: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
391: , p6_a3 out nocopy JTF_NUMBER_TABLE
392: , p6_a4 out nocopy JTF_NUMBER_TABLE
393: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
394: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 393: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

389: , p6_a1 out nocopy JTF_NUMBER_TABLE
390: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
391: , p6_a3 out nocopy JTF_NUMBER_TABLE
392: , p6_a4 out nocopy JTF_NUMBER_TABLE
393: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
394: , p6_a6 out nocopy JTF_NUMBER_TABLE
395: , p6_a7 out nocopy JTF_NUMBER_TABLE
396: , p6_a8 out nocopy JTF_NUMBER_TABLE
397: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 399: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

395: , p6_a7 out nocopy JTF_NUMBER_TABLE
396: , p6_a8 out nocopy JTF_NUMBER_TABLE
397: , p6_a9 out nocopy JTF_NUMBER_TABLE
398: , p6_a10 out nocopy JTF_NUMBER_TABLE
399: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
400: , p6_a12 out nocopy JTF_NUMBER_TABLE
401: , p6_a13 out nocopy JTF_NUMBER_TABLE
402: , p6_a14 out nocopy JTF_DATE_TABLE
403: , p6_a15 out nocopy JTF_NUMBER_TABLE

Line 410: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

406: , p6_a18 out nocopy JTF_NUMBER_TABLE
407: , p6_a19 out nocopy JTF_NUMBER_TABLE
408: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
409: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_3000
410: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
412: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
413: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
414: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500

Line 436: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100

432: , p6_a44 out nocopy JTF_DATE_TABLE
433: , p6_a45 out nocopy JTF_NUMBER_TABLE
434: , p6_a46 out nocopy JTF_DATE_TABLE
435: , p6_a47 out nocopy JTF_NUMBER_TABLE
436: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
437: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
438: , p6_a50 out nocopy JTF_NUMBER_TABLE
439: , p6_a51 out nocopy JTF_NUMBER_TABLE
440: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100

Line 437: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100

433: , p6_a45 out nocopy JTF_NUMBER_TABLE
434: , p6_a46 out nocopy JTF_DATE_TABLE
435: , p6_a47 out nocopy JTF_NUMBER_TABLE
436: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
437: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
438: , p6_a50 out nocopy JTF_NUMBER_TABLE
439: , p6_a51 out nocopy JTF_NUMBER_TABLE
440: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
441: , p6_a53 out nocopy JTF_NUMBER_TABLE

Line 440: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100

436: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
437: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
438: , p6_a50 out nocopy JTF_NUMBER_TABLE
439: , p6_a51 out nocopy JTF_NUMBER_TABLE
440: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
441: , p6_a53 out nocopy JTF_NUMBER_TABLE
442: );
443: procedure create_funding_lines(p_api_version NUMBER
444: , p_init_msg_list VARCHAR2

Line 453: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

449: , p_khr_id NUMBER
450: , p_vendor_site_id NUMBER
451: , p8_a0 out nocopy JTF_NUMBER_TABLE
452: , p8_a1 out nocopy JTF_NUMBER_TABLE
453: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
454: , p8_a3 out nocopy JTF_NUMBER_TABLE
455: , p8_a4 out nocopy JTF_NUMBER_TABLE
456: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
457: , p8_a6 out nocopy JTF_NUMBER_TABLE

Line 456: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

452: , p8_a1 out nocopy JTF_NUMBER_TABLE
453: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
454: , p8_a3 out nocopy JTF_NUMBER_TABLE
455: , p8_a4 out nocopy JTF_NUMBER_TABLE
456: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
457: , p8_a6 out nocopy JTF_NUMBER_TABLE
458: , p8_a7 out nocopy JTF_NUMBER_TABLE
459: , p8_a8 out nocopy JTF_NUMBER_TABLE
460: , p8_a9 out nocopy JTF_NUMBER_TABLE

Line 462: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100

458: , p8_a7 out nocopy JTF_NUMBER_TABLE
459: , p8_a8 out nocopy JTF_NUMBER_TABLE
460: , p8_a9 out nocopy JTF_NUMBER_TABLE
461: , p8_a10 out nocopy JTF_NUMBER_TABLE
462: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
463: , p8_a12 out nocopy JTF_NUMBER_TABLE
464: , p8_a13 out nocopy JTF_NUMBER_TABLE
465: , p8_a14 out nocopy JTF_DATE_TABLE
466: , p8_a15 out nocopy JTF_NUMBER_TABLE

Line 473: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100

469: , p8_a18 out nocopy JTF_NUMBER_TABLE
470: , p8_a19 out nocopy JTF_NUMBER_TABLE
471: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_2000
472: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_3000
473: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100
474: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_500
475: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_500
476: , p8_a25 out nocopy JTF_VARCHAR2_TABLE_500
477: , p8_a26 out nocopy JTF_VARCHAR2_TABLE_500

Line 499: , p8_a48 out nocopy JTF_VARCHAR2_TABLE_100

495: , p8_a44 out nocopy JTF_DATE_TABLE
496: , p8_a45 out nocopy JTF_NUMBER_TABLE
497: , p8_a46 out nocopy JTF_DATE_TABLE
498: , p8_a47 out nocopy JTF_NUMBER_TABLE
499: , p8_a48 out nocopy JTF_VARCHAR2_TABLE_100
500: , p8_a49 out nocopy JTF_VARCHAR2_TABLE_100
501: , p8_a50 out nocopy JTF_NUMBER_TABLE
502: , p8_a51 out nocopy JTF_NUMBER_TABLE
503: , p8_a52 out nocopy JTF_VARCHAR2_TABLE_100

Line 500: , p8_a49 out nocopy JTF_VARCHAR2_TABLE_100

496: , p8_a45 out nocopy JTF_NUMBER_TABLE
497: , p8_a46 out nocopy JTF_DATE_TABLE
498: , p8_a47 out nocopy JTF_NUMBER_TABLE
499: , p8_a48 out nocopy JTF_VARCHAR2_TABLE_100
500: , p8_a49 out nocopy JTF_VARCHAR2_TABLE_100
501: , p8_a50 out nocopy JTF_NUMBER_TABLE
502: , p8_a51 out nocopy JTF_NUMBER_TABLE
503: , p8_a52 out nocopy JTF_VARCHAR2_TABLE_100
504: , p8_a53 out nocopy JTF_NUMBER_TABLE

Line 503: , p8_a52 out nocopy JTF_VARCHAR2_TABLE_100

499: , p8_a48 out nocopy JTF_VARCHAR2_TABLE_100
500: , p8_a49 out nocopy JTF_VARCHAR2_TABLE_100
501: , p8_a50 out nocopy JTF_NUMBER_TABLE
502: , p8_a51 out nocopy JTF_NUMBER_TABLE
503: , p8_a52 out nocopy JTF_VARCHAR2_TABLE_100
504: , p8_a53 out nocopy JTF_NUMBER_TABLE
505: );
506: procedure update_funding_lines(p_api_version NUMBER
507: , p_init_msg_list VARCHAR2

Line 513: , p5_a2 JTF_VARCHAR2_TABLE_100

509: , x_msg_count out nocopy NUMBER
510: , x_msg_data out nocopy VARCHAR2
511: , p5_a0 JTF_NUMBER_TABLE
512: , p5_a1 JTF_NUMBER_TABLE
513: , p5_a2 JTF_VARCHAR2_TABLE_100
514: , p5_a3 JTF_NUMBER_TABLE
515: , p5_a4 JTF_NUMBER_TABLE
516: , p5_a5 JTF_VARCHAR2_TABLE_100
517: , p5_a6 JTF_NUMBER_TABLE

Line 516: , p5_a5 JTF_VARCHAR2_TABLE_100

512: , p5_a1 JTF_NUMBER_TABLE
513: , p5_a2 JTF_VARCHAR2_TABLE_100
514: , p5_a3 JTF_NUMBER_TABLE
515: , p5_a4 JTF_NUMBER_TABLE
516: , p5_a5 JTF_VARCHAR2_TABLE_100
517: , p5_a6 JTF_NUMBER_TABLE
518: , p5_a7 JTF_NUMBER_TABLE
519: , p5_a8 JTF_NUMBER_TABLE
520: , p5_a9 JTF_NUMBER_TABLE

Line 522: , p5_a11 JTF_VARCHAR2_TABLE_100

518: , p5_a7 JTF_NUMBER_TABLE
519: , p5_a8 JTF_NUMBER_TABLE
520: , p5_a9 JTF_NUMBER_TABLE
521: , p5_a10 JTF_NUMBER_TABLE
522: , p5_a11 JTF_VARCHAR2_TABLE_100
523: , p5_a12 JTF_NUMBER_TABLE
524: , p5_a13 JTF_NUMBER_TABLE
525: , p5_a14 JTF_DATE_TABLE
526: , p5_a15 JTF_NUMBER_TABLE

Line 533: , p5_a22 JTF_VARCHAR2_TABLE_100

529: , p5_a18 JTF_NUMBER_TABLE
530: , p5_a19 JTF_NUMBER_TABLE
531: , p5_a20 JTF_VARCHAR2_TABLE_2000
532: , p5_a21 JTF_VARCHAR2_TABLE_3000
533: , p5_a22 JTF_VARCHAR2_TABLE_100
534: , p5_a23 JTF_VARCHAR2_TABLE_500
535: , p5_a24 JTF_VARCHAR2_TABLE_500
536: , p5_a25 JTF_VARCHAR2_TABLE_500
537: , p5_a26 JTF_VARCHAR2_TABLE_500

Line 559: , p5_a48 JTF_VARCHAR2_TABLE_100

555: , p5_a44 JTF_DATE_TABLE
556: , p5_a45 JTF_NUMBER_TABLE
557: , p5_a46 JTF_DATE_TABLE
558: , p5_a47 JTF_NUMBER_TABLE
559: , p5_a48 JTF_VARCHAR2_TABLE_100
560: , p5_a49 JTF_VARCHAR2_TABLE_100
561: , p5_a50 JTF_NUMBER_TABLE
562: , p5_a51 JTF_NUMBER_TABLE
563: , p5_a52 JTF_VARCHAR2_TABLE_100

Line 560: , p5_a49 JTF_VARCHAR2_TABLE_100

556: , p5_a45 JTF_NUMBER_TABLE
557: , p5_a46 JTF_DATE_TABLE
558: , p5_a47 JTF_NUMBER_TABLE
559: , p5_a48 JTF_VARCHAR2_TABLE_100
560: , p5_a49 JTF_VARCHAR2_TABLE_100
561: , p5_a50 JTF_NUMBER_TABLE
562: , p5_a51 JTF_NUMBER_TABLE
563: , p5_a52 JTF_VARCHAR2_TABLE_100
564: , p5_a53 JTF_NUMBER_TABLE

Line 563: , p5_a52 JTF_VARCHAR2_TABLE_100

559: , p5_a48 JTF_VARCHAR2_TABLE_100
560: , p5_a49 JTF_VARCHAR2_TABLE_100
561: , p5_a50 JTF_NUMBER_TABLE
562: , p5_a51 JTF_NUMBER_TABLE
563: , p5_a52 JTF_VARCHAR2_TABLE_100
564: , p5_a53 JTF_NUMBER_TABLE
565: , p6_a0 out nocopy JTF_NUMBER_TABLE
566: , p6_a1 out nocopy JTF_NUMBER_TABLE
567: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 567: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

563: , p5_a52 JTF_VARCHAR2_TABLE_100
564: , p5_a53 JTF_NUMBER_TABLE
565: , p6_a0 out nocopy JTF_NUMBER_TABLE
566: , p6_a1 out nocopy JTF_NUMBER_TABLE
567: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a3 out nocopy JTF_NUMBER_TABLE
569: , p6_a4 out nocopy JTF_NUMBER_TABLE
570: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
571: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 570: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

566: , p6_a1 out nocopy JTF_NUMBER_TABLE
567: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a3 out nocopy JTF_NUMBER_TABLE
569: , p6_a4 out nocopy JTF_NUMBER_TABLE
570: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
571: , p6_a6 out nocopy JTF_NUMBER_TABLE
572: , p6_a7 out nocopy JTF_NUMBER_TABLE
573: , p6_a8 out nocopy JTF_NUMBER_TABLE
574: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 576: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

572: , p6_a7 out nocopy JTF_NUMBER_TABLE
573: , p6_a8 out nocopy JTF_NUMBER_TABLE
574: , p6_a9 out nocopy JTF_NUMBER_TABLE
575: , p6_a10 out nocopy JTF_NUMBER_TABLE
576: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
577: , p6_a12 out nocopy JTF_NUMBER_TABLE
578: , p6_a13 out nocopy JTF_NUMBER_TABLE
579: , p6_a14 out nocopy JTF_DATE_TABLE
580: , p6_a15 out nocopy JTF_NUMBER_TABLE

Line 587: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

583: , p6_a18 out nocopy JTF_NUMBER_TABLE
584: , p6_a19 out nocopy JTF_NUMBER_TABLE
585: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
586: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_3000
587: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
589: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
590: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
591: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500

Line 613: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100

609: , p6_a44 out nocopy JTF_DATE_TABLE
610: , p6_a45 out nocopy JTF_NUMBER_TABLE
611: , p6_a46 out nocopy JTF_DATE_TABLE
612: , p6_a47 out nocopy JTF_NUMBER_TABLE
613: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
614: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
615: , p6_a50 out nocopy JTF_NUMBER_TABLE
616: , p6_a51 out nocopy JTF_NUMBER_TABLE
617: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100

Line 614: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100

610: , p6_a45 out nocopy JTF_NUMBER_TABLE
611: , p6_a46 out nocopy JTF_DATE_TABLE
612: , p6_a47 out nocopy JTF_NUMBER_TABLE
613: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
614: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
615: , p6_a50 out nocopy JTF_NUMBER_TABLE
616: , p6_a51 out nocopy JTF_NUMBER_TABLE
617: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
618: , p6_a53 out nocopy JTF_NUMBER_TABLE

Line 617: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100

613: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
614: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
615: , p6_a50 out nocopy JTF_NUMBER_TABLE
616: , p6_a51 out nocopy JTF_NUMBER_TABLE
617: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
618: , p6_a53 out nocopy JTF_NUMBER_TABLE
619: );
620: procedure sync_header_amount(p_api_version NUMBER
621: , p_init_msg_list VARCHAR2

Line 627: , p5_a2 JTF_VARCHAR2_TABLE_100

623: , x_msg_count out nocopy NUMBER
624: , x_msg_data out nocopy VARCHAR2
625: , p5_a0 JTF_NUMBER_TABLE
626: , p5_a1 JTF_NUMBER_TABLE
627: , p5_a2 JTF_VARCHAR2_TABLE_100
628: , p5_a3 JTF_NUMBER_TABLE
629: , p5_a4 JTF_NUMBER_TABLE
630: , p5_a5 JTF_VARCHAR2_TABLE_100
631: , p5_a6 JTF_NUMBER_TABLE

Line 630: , p5_a5 JTF_VARCHAR2_TABLE_100

626: , p5_a1 JTF_NUMBER_TABLE
627: , p5_a2 JTF_VARCHAR2_TABLE_100
628: , p5_a3 JTF_NUMBER_TABLE
629: , p5_a4 JTF_NUMBER_TABLE
630: , p5_a5 JTF_VARCHAR2_TABLE_100
631: , p5_a6 JTF_NUMBER_TABLE
632: , p5_a7 JTF_NUMBER_TABLE
633: , p5_a8 JTF_NUMBER_TABLE
634: , p5_a9 JTF_NUMBER_TABLE

Line 636: , p5_a11 JTF_VARCHAR2_TABLE_100

632: , p5_a7 JTF_NUMBER_TABLE
633: , p5_a8 JTF_NUMBER_TABLE
634: , p5_a9 JTF_NUMBER_TABLE
635: , p5_a10 JTF_NUMBER_TABLE
636: , p5_a11 JTF_VARCHAR2_TABLE_100
637: , p5_a12 JTF_NUMBER_TABLE
638: , p5_a13 JTF_NUMBER_TABLE
639: , p5_a14 JTF_DATE_TABLE
640: , p5_a15 JTF_NUMBER_TABLE

Line 647: , p5_a22 JTF_VARCHAR2_TABLE_100

643: , p5_a18 JTF_NUMBER_TABLE
644: , p5_a19 JTF_NUMBER_TABLE
645: , p5_a20 JTF_VARCHAR2_TABLE_2000
646: , p5_a21 JTF_VARCHAR2_TABLE_3000
647: , p5_a22 JTF_VARCHAR2_TABLE_100
648: , p5_a23 JTF_VARCHAR2_TABLE_500
649: , p5_a24 JTF_VARCHAR2_TABLE_500
650: , p5_a25 JTF_VARCHAR2_TABLE_500
651: , p5_a26 JTF_VARCHAR2_TABLE_500

Line 673: , p5_a48 JTF_VARCHAR2_TABLE_100

669: , p5_a44 JTF_DATE_TABLE
670: , p5_a45 JTF_NUMBER_TABLE
671: , p5_a46 JTF_DATE_TABLE
672: , p5_a47 JTF_NUMBER_TABLE
673: , p5_a48 JTF_VARCHAR2_TABLE_100
674: , p5_a49 JTF_VARCHAR2_TABLE_100
675: , p5_a50 JTF_NUMBER_TABLE
676: , p5_a51 JTF_NUMBER_TABLE
677: , p5_a52 JTF_VARCHAR2_TABLE_100

Line 674: , p5_a49 JTF_VARCHAR2_TABLE_100

670: , p5_a45 JTF_NUMBER_TABLE
671: , p5_a46 JTF_DATE_TABLE
672: , p5_a47 JTF_NUMBER_TABLE
673: , p5_a48 JTF_VARCHAR2_TABLE_100
674: , p5_a49 JTF_VARCHAR2_TABLE_100
675: , p5_a50 JTF_NUMBER_TABLE
676: , p5_a51 JTF_NUMBER_TABLE
677: , p5_a52 JTF_VARCHAR2_TABLE_100
678: , p5_a53 JTF_NUMBER_TABLE

Line 677: , p5_a52 JTF_VARCHAR2_TABLE_100

673: , p5_a48 JTF_VARCHAR2_TABLE_100
674: , p5_a49 JTF_VARCHAR2_TABLE_100
675: , p5_a50 JTF_NUMBER_TABLE
676: , p5_a51 JTF_NUMBER_TABLE
677: , p5_a52 JTF_VARCHAR2_TABLE_100
678: , p5_a53 JTF_NUMBER_TABLE
679: );
680: function get_chr_exp_canbe_funded_amt(p_contract_id NUMBER
681: , p_vendor_site_id NUMBER

Line 689: , p0_a2 JTF_VARCHAR2_TABLE_100

685: , p_due_date date
686: ) return number;
687: function is_kle_id_unique(p0_a0 JTF_NUMBER_TABLE
688: , p0_a1 JTF_NUMBER_TABLE
689: , p0_a2 JTF_VARCHAR2_TABLE_100
690: , p0_a3 JTF_NUMBER_TABLE
691: , p0_a4 JTF_NUMBER_TABLE
692: , p0_a5 JTF_VARCHAR2_TABLE_100
693: , p0_a6 JTF_NUMBER_TABLE

Line 692: , p0_a5 JTF_VARCHAR2_TABLE_100

688: , p0_a1 JTF_NUMBER_TABLE
689: , p0_a2 JTF_VARCHAR2_TABLE_100
690: , p0_a3 JTF_NUMBER_TABLE
691: , p0_a4 JTF_NUMBER_TABLE
692: , p0_a5 JTF_VARCHAR2_TABLE_100
693: , p0_a6 JTF_NUMBER_TABLE
694: , p0_a7 JTF_NUMBER_TABLE
695: , p0_a8 JTF_NUMBER_TABLE
696: , p0_a9 JTF_NUMBER_TABLE

Line 698: , p0_a11 JTF_VARCHAR2_TABLE_100

694: , p0_a7 JTF_NUMBER_TABLE
695: , p0_a8 JTF_NUMBER_TABLE
696: , p0_a9 JTF_NUMBER_TABLE
697: , p0_a10 JTF_NUMBER_TABLE
698: , p0_a11 JTF_VARCHAR2_TABLE_100
699: , p0_a12 JTF_NUMBER_TABLE
700: , p0_a13 JTF_NUMBER_TABLE
701: , p0_a14 JTF_DATE_TABLE
702: , p0_a15 JTF_NUMBER_TABLE

Line 709: , p0_a22 JTF_VARCHAR2_TABLE_100

705: , p0_a18 JTF_NUMBER_TABLE
706: , p0_a19 JTF_NUMBER_TABLE
707: , p0_a20 JTF_VARCHAR2_TABLE_2000
708: , p0_a21 JTF_VARCHAR2_TABLE_3000
709: , p0_a22 JTF_VARCHAR2_TABLE_100
710: , p0_a23 JTF_VARCHAR2_TABLE_500
711: , p0_a24 JTF_VARCHAR2_TABLE_500
712: , p0_a25 JTF_VARCHAR2_TABLE_500
713: , p0_a26 JTF_VARCHAR2_TABLE_500

Line 735: , p0_a48 JTF_VARCHAR2_TABLE_100

731: , p0_a44 JTF_DATE_TABLE
732: , p0_a45 JTF_NUMBER_TABLE
733: , p0_a46 JTF_DATE_TABLE
734: , p0_a47 JTF_NUMBER_TABLE
735: , p0_a48 JTF_VARCHAR2_TABLE_100
736: , p0_a49 JTF_VARCHAR2_TABLE_100
737: , p0_a50 JTF_NUMBER_TABLE
738: , p0_a51 JTF_NUMBER_TABLE
739: , p0_a52 JTF_VARCHAR2_TABLE_100

Line 736: , p0_a49 JTF_VARCHAR2_TABLE_100

732: , p0_a45 JTF_NUMBER_TABLE
733: , p0_a46 JTF_DATE_TABLE
734: , p0_a47 JTF_NUMBER_TABLE
735: , p0_a48 JTF_VARCHAR2_TABLE_100
736: , p0_a49 JTF_VARCHAR2_TABLE_100
737: , p0_a50 JTF_NUMBER_TABLE
738: , p0_a51 JTF_NUMBER_TABLE
739: , p0_a52 JTF_VARCHAR2_TABLE_100
740: , p0_a53 JTF_NUMBER_TABLE

Line 739: , p0_a52 JTF_VARCHAR2_TABLE_100

735: , p0_a48 JTF_VARCHAR2_TABLE_100
736: , p0_a49 JTF_VARCHAR2_TABLE_100
737: , p0_a50 JTF_NUMBER_TABLE
738: , p0_a51 JTF_NUMBER_TABLE
739: , p0_a52 JTF_VARCHAR2_TABLE_100
740: , p0_a53 JTF_NUMBER_TABLE
741: ) return varchar2;
742: procedure contract_fee_canbe_funded(p_api_version NUMBER
743: , p_init_msg_list VARCHAR2