APPS.OKL_FUNDING_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 335: , p5_a2 JTF_VARCHAR2_TABLE_100

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

Line 338: , p5_a5 JTF_VARCHAR2_TABLE_100

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

Line 344: , p5_a11 JTF_VARCHAR2_TABLE_100

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

Line 355: , p5_a22 JTF_VARCHAR2_TABLE_100

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

Line 381: , p5_a48 JTF_VARCHAR2_TABLE_100

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

Line 382: , p5_a49 JTF_VARCHAR2_TABLE_100

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

Line 385: , p5_a52 JTF_VARCHAR2_TABLE_100

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

Line 389: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 392: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 398: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 409: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 435: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 436: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 439: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 452: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 455: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 461: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 472: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 498: , p8_a48 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 499: , p8_a49 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 502: , p8_a52 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 512: , p5_a2 JTF_VARCHAR2_TABLE_100

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

Line 515: , p5_a5 JTF_VARCHAR2_TABLE_100

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

Line 521: , p5_a11 JTF_VARCHAR2_TABLE_100

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

Line 532: , p5_a22 JTF_VARCHAR2_TABLE_100

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

Line 558: , p5_a48 JTF_VARCHAR2_TABLE_100

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

Line 559: , p5_a49 JTF_VARCHAR2_TABLE_100

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

Line 562: , p5_a52 JTF_VARCHAR2_TABLE_100

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

Line 566: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 569: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 575: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 586: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 612: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 613: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 616: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 626: , p5_a2 JTF_VARCHAR2_TABLE_100

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

Line 629: , p5_a5 JTF_VARCHAR2_TABLE_100

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

Line 635: , p5_a11 JTF_VARCHAR2_TABLE_100

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

Line 646: , p5_a22 JTF_VARCHAR2_TABLE_100

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

Line 672: , p5_a48 JTF_VARCHAR2_TABLE_100

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

Line 673: , p5_a49 JTF_VARCHAR2_TABLE_100

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

Line 676: , p5_a52 JTF_VARCHAR2_TABLE_100

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

Line 688: , p0_a2 JTF_VARCHAR2_TABLE_100

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

Line 691: , p0_a5 JTF_VARCHAR2_TABLE_100

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

Line 697: , p0_a11 JTF_VARCHAR2_TABLE_100

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

Line 708: , p0_a22 JTF_VARCHAR2_TABLE_100

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

Line 734: , p0_a48 JTF_VARCHAR2_TABLE_100

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

Line 735: , p0_a49 JTF_VARCHAR2_TABLE_100

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

Line 738: , p0_a52 JTF_VARCHAR2_TABLE_100

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