DBA Data[Home] [Help]

APPS.OKL_SETUPFMACONSTRAINTS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 407: , p5_a0 JTF_NUMBER_TABLE

403: , p_init_msg_list VARCHAR2
404: , x_return_status out nocopy VARCHAR2
405: , x_msg_count out nocopy NUMBER
406: , x_msg_data out nocopy VARCHAR2
407: , p5_a0 JTF_NUMBER_TABLE
408: , p5_a1 JTF_NUMBER_TABLE
409: , p5_a2 JTF_NUMBER_TABLE
410: , p5_a3 JTF_NUMBER_TABLE
411: , p5_a4 JTF_VARCHAR2_TABLE_800

Line 408: , p5_a1 JTF_NUMBER_TABLE

404: , x_return_status out nocopy VARCHAR2
405: , x_msg_count out nocopy NUMBER
406: , x_msg_data out nocopy VARCHAR2
407: , p5_a0 JTF_NUMBER_TABLE
408: , p5_a1 JTF_NUMBER_TABLE
409: , p5_a2 JTF_NUMBER_TABLE
410: , p5_a3 JTF_NUMBER_TABLE
411: , p5_a4 JTF_VARCHAR2_TABLE_800
412: , p5_a5 JTF_NUMBER_TABLE

Line 409: , p5_a2 JTF_NUMBER_TABLE

405: , x_msg_count out nocopy NUMBER
406: , x_msg_data out nocopy VARCHAR2
407: , p5_a0 JTF_NUMBER_TABLE
408: , p5_a1 JTF_NUMBER_TABLE
409: , p5_a2 JTF_NUMBER_TABLE
410: , p5_a3 JTF_NUMBER_TABLE
411: , p5_a4 JTF_VARCHAR2_TABLE_800
412: , p5_a5 JTF_NUMBER_TABLE
413: , p5_a6 JTF_DATE_TABLE

Line 410: , p5_a3 JTF_NUMBER_TABLE

406: , x_msg_data out nocopy VARCHAR2
407: , p5_a0 JTF_NUMBER_TABLE
408: , p5_a1 JTF_NUMBER_TABLE
409: , p5_a2 JTF_NUMBER_TABLE
410: , p5_a3 JTF_NUMBER_TABLE
411: , p5_a4 JTF_VARCHAR2_TABLE_800
412: , p5_a5 JTF_NUMBER_TABLE
413: , p5_a6 JTF_DATE_TABLE
414: , p5_a7 JTF_NUMBER_TABLE

Line 412: , p5_a5 JTF_NUMBER_TABLE

408: , p5_a1 JTF_NUMBER_TABLE
409: , p5_a2 JTF_NUMBER_TABLE
410: , p5_a3 JTF_NUMBER_TABLE
411: , p5_a4 JTF_VARCHAR2_TABLE_800
412: , p5_a5 JTF_NUMBER_TABLE
413: , p5_a6 JTF_DATE_TABLE
414: , p5_a7 JTF_NUMBER_TABLE
415: , p5_a8 JTF_DATE_TABLE
416: , p5_a9 JTF_NUMBER_TABLE

Line 414: , p5_a7 JTF_NUMBER_TABLE

410: , p5_a3 JTF_NUMBER_TABLE
411: , p5_a4 JTF_VARCHAR2_TABLE_800
412: , p5_a5 JTF_NUMBER_TABLE
413: , p5_a6 JTF_DATE_TABLE
414: , p5_a7 JTF_NUMBER_TABLE
415: , p5_a8 JTF_DATE_TABLE
416: , p5_a9 JTF_NUMBER_TABLE
417: )
418:

Line 416: , p5_a9 JTF_NUMBER_TABLE

412: , p5_a5 JTF_NUMBER_TABLE
413: , p5_a6 JTF_DATE_TABLE
414: , p5_a7 JTF_NUMBER_TABLE
415: , p5_a8 JTF_DATE_TABLE
416: , p5_a9 JTF_NUMBER_TABLE
417: )
418:
419: as
420: ddp_fodv_tbl okl_setupfmaconstraints_pub.fodv_tbl_type;

Line 463: , p6_a0 JTF_NUMBER_TABLE

459: , p_init_msg_list VARCHAR2
460: , x_return_status out nocopy VARCHAR2
461: , x_msg_count out nocopy NUMBER
462: , x_msg_data out nocopy VARCHAR2
463: , p6_a0 JTF_NUMBER_TABLE
464: , p6_a1 JTF_NUMBER_TABLE
465: , p6_a2 JTF_NUMBER_TABLE
466: , p6_a3 JTF_NUMBER_TABLE
467: , p6_a4 JTF_VARCHAR2_TABLE_800

Line 464: , p6_a1 JTF_NUMBER_TABLE

460: , x_return_status out nocopy VARCHAR2
461: , x_msg_count out nocopy NUMBER
462: , x_msg_data out nocopy VARCHAR2
463: , p6_a0 JTF_NUMBER_TABLE
464: , p6_a1 JTF_NUMBER_TABLE
465: , p6_a2 JTF_NUMBER_TABLE
466: , p6_a3 JTF_NUMBER_TABLE
467: , p6_a4 JTF_VARCHAR2_TABLE_800
468: , p6_a5 JTF_NUMBER_TABLE

Line 465: , p6_a2 JTF_NUMBER_TABLE

461: , x_msg_count out nocopy NUMBER
462: , x_msg_data out nocopy VARCHAR2
463: , p6_a0 JTF_NUMBER_TABLE
464: , p6_a1 JTF_NUMBER_TABLE
465: , p6_a2 JTF_NUMBER_TABLE
466: , p6_a3 JTF_NUMBER_TABLE
467: , p6_a4 JTF_VARCHAR2_TABLE_800
468: , p6_a5 JTF_NUMBER_TABLE
469: , p6_a6 JTF_DATE_TABLE

Line 466: , p6_a3 JTF_NUMBER_TABLE

462: , x_msg_data out nocopy VARCHAR2
463: , p6_a0 JTF_NUMBER_TABLE
464: , p6_a1 JTF_NUMBER_TABLE
465: , p6_a2 JTF_NUMBER_TABLE
466: , p6_a3 JTF_NUMBER_TABLE
467: , p6_a4 JTF_VARCHAR2_TABLE_800
468: , p6_a5 JTF_NUMBER_TABLE
469: , p6_a6 JTF_DATE_TABLE
470: , p6_a7 JTF_NUMBER_TABLE

Line 468: , p6_a5 JTF_NUMBER_TABLE

464: , p6_a1 JTF_NUMBER_TABLE
465: , p6_a2 JTF_NUMBER_TABLE
466: , p6_a3 JTF_NUMBER_TABLE
467: , p6_a4 JTF_VARCHAR2_TABLE_800
468: , p6_a5 JTF_NUMBER_TABLE
469: , p6_a6 JTF_DATE_TABLE
470: , p6_a7 JTF_NUMBER_TABLE
471: , p6_a8 JTF_DATE_TABLE
472: , p6_a9 JTF_NUMBER_TABLE

Line 470: , p6_a7 JTF_NUMBER_TABLE

466: , p6_a3 JTF_NUMBER_TABLE
467: , p6_a4 JTF_VARCHAR2_TABLE_800
468: , p6_a5 JTF_NUMBER_TABLE
469: , p6_a6 JTF_DATE_TABLE
470: , p6_a7 JTF_NUMBER_TABLE
471: , p6_a8 JTF_DATE_TABLE
472: , p6_a9 JTF_NUMBER_TABLE
473: , p7_a0 out nocopy JTF_NUMBER_TABLE
474: , p7_a1 out nocopy JTF_NUMBER_TABLE

Line 472: , p6_a9 JTF_NUMBER_TABLE

468: , p6_a5 JTF_NUMBER_TABLE
469: , p6_a6 JTF_DATE_TABLE
470: , p6_a7 JTF_NUMBER_TABLE
471: , p6_a8 JTF_DATE_TABLE
472: , p6_a9 JTF_NUMBER_TABLE
473: , p7_a0 out nocopy JTF_NUMBER_TABLE
474: , p7_a1 out nocopy JTF_NUMBER_TABLE
475: , p7_a2 out nocopy JTF_NUMBER_TABLE
476: , p7_a3 out nocopy JTF_NUMBER_TABLE

Line 473: , p7_a0 out nocopy JTF_NUMBER_TABLE

469: , p6_a6 JTF_DATE_TABLE
470: , p6_a7 JTF_NUMBER_TABLE
471: , p6_a8 JTF_DATE_TABLE
472: , p6_a9 JTF_NUMBER_TABLE
473: , p7_a0 out nocopy JTF_NUMBER_TABLE
474: , p7_a1 out nocopy JTF_NUMBER_TABLE
475: , p7_a2 out nocopy JTF_NUMBER_TABLE
476: , p7_a3 out nocopy JTF_NUMBER_TABLE
477: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800

Line 474: , p7_a1 out nocopy JTF_NUMBER_TABLE

470: , p6_a7 JTF_NUMBER_TABLE
471: , p6_a8 JTF_DATE_TABLE
472: , p6_a9 JTF_NUMBER_TABLE
473: , p7_a0 out nocopy JTF_NUMBER_TABLE
474: , p7_a1 out nocopy JTF_NUMBER_TABLE
475: , p7_a2 out nocopy JTF_NUMBER_TABLE
476: , p7_a3 out nocopy JTF_NUMBER_TABLE
477: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
478: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 475: , p7_a2 out nocopy JTF_NUMBER_TABLE

471: , p6_a8 JTF_DATE_TABLE
472: , p6_a9 JTF_NUMBER_TABLE
473: , p7_a0 out nocopy JTF_NUMBER_TABLE
474: , p7_a1 out nocopy JTF_NUMBER_TABLE
475: , p7_a2 out nocopy JTF_NUMBER_TABLE
476: , p7_a3 out nocopy JTF_NUMBER_TABLE
477: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
478: , p7_a5 out nocopy JTF_NUMBER_TABLE
479: , p7_a6 out nocopy JTF_DATE_TABLE

Line 476: , p7_a3 out nocopy JTF_NUMBER_TABLE

472: , p6_a9 JTF_NUMBER_TABLE
473: , p7_a0 out nocopy JTF_NUMBER_TABLE
474: , p7_a1 out nocopy JTF_NUMBER_TABLE
475: , p7_a2 out nocopy JTF_NUMBER_TABLE
476: , p7_a3 out nocopy JTF_NUMBER_TABLE
477: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
478: , p7_a5 out nocopy JTF_NUMBER_TABLE
479: , p7_a6 out nocopy JTF_DATE_TABLE
480: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 478: , p7_a5 out nocopy JTF_NUMBER_TABLE

474: , p7_a1 out nocopy JTF_NUMBER_TABLE
475: , p7_a2 out nocopy JTF_NUMBER_TABLE
476: , p7_a3 out nocopy JTF_NUMBER_TABLE
477: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
478: , p7_a5 out nocopy JTF_NUMBER_TABLE
479: , p7_a6 out nocopy JTF_DATE_TABLE
480: , p7_a7 out nocopy JTF_NUMBER_TABLE
481: , p7_a8 out nocopy JTF_DATE_TABLE
482: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 480: , p7_a7 out nocopy JTF_NUMBER_TABLE

476: , p7_a3 out nocopy JTF_NUMBER_TABLE
477: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
478: , p7_a5 out nocopy JTF_NUMBER_TABLE
479: , p7_a6 out nocopy JTF_DATE_TABLE
480: , p7_a7 out nocopy JTF_NUMBER_TABLE
481: , p7_a8 out nocopy JTF_DATE_TABLE
482: , p7_a9 out nocopy JTF_NUMBER_TABLE
483: , p5_a0 NUMBER := 0-1962.0724
484: , p5_a1 NUMBER := 0-1962.0724

Line 482: , p7_a9 out nocopy JTF_NUMBER_TABLE

478: , p7_a5 out nocopy JTF_NUMBER_TABLE
479: , p7_a6 out nocopy JTF_DATE_TABLE
480: , p7_a7 out nocopy JTF_NUMBER_TABLE
481: , p7_a8 out nocopy JTF_DATE_TABLE
482: , p7_a9 out nocopy JTF_NUMBER_TABLE
483: , p5_a0 NUMBER := 0-1962.0724
484: , p5_a1 NUMBER := 0-1962.0724
485: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a3 NUMBER := 0-1962.0724

Line 616: , p6_a0 JTF_NUMBER_TABLE

612: , p_init_msg_list VARCHAR2
613: , x_return_status out nocopy VARCHAR2
614: , x_msg_count out nocopy NUMBER
615: , x_msg_data out nocopy VARCHAR2
616: , p6_a0 JTF_NUMBER_TABLE
617: , p6_a1 JTF_NUMBER_TABLE
618: , p6_a2 JTF_NUMBER_TABLE
619: , p6_a3 JTF_NUMBER_TABLE
620: , p6_a4 JTF_VARCHAR2_TABLE_800

Line 617: , p6_a1 JTF_NUMBER_TABLE

613: , x_return_status out nocopy VARCHAR2
614: , x_msg_count out nocopy NUMBER
615: , x_msg_data out nocopy VARCHAR2
616: , p6_a0 JTF_NUMBER_TABLE
617: , p6_a1 JTF_NUMBER_TABLE
618: , p6_a2 JTF_NUMBER_TABLE
619: , p6_a3 JTF_NUMBER_TABLE
620: , p6_a4 JTF_VARCHAR2_TABLE_800
621: , p6_a5 JTF_NUMBER_TABLE

Line 618: , p6_a2 JTF_NUMBER_TABLE

614: , x_msg_count out nocopy NUMBER
615: , x_msg_data out nocopy VARCHAR2
616: , p6_a0 JTF_NUMBER_TABLE
617: , p6_a1 JTF_NUMBER_TABLE
618: , p6_a2 JTF_NUMBER_TABLE
619: , p6_a3 JTF_NUMBER_TABLE
620: , p6_a4 JTF_VARCHAR2_TABLE_800
621: , p6_a5 JTF_NUMBER_TABLE
622: , p6_a6 JTF_DATE_TABLE

Line 619: , p6_a3 JTF_NUMBER_TABLE

615: , x_msg_data out nocopy VARCHAR2
616: , p6_a0 JTF_NUMBER_TABLE
617: , p6_a1 JTF_NUMBER_TABLE
618: , p6_a2 JTF_NUMBER_TABLE
619: , p6_a3 JTF_NUMBER_TABLE
620: , p6_a4 JTF_VARCHAR2_TABLE_800
621: , p6_a5 JTF_NUMBER_TABLE
622: , p6_a6 JTF_DATE_TABLE
623: , p6_a7 JTF_NUMBER_TABLE

Line 621: , p6_a5 JTF_NUMBER_TABLE

617: , p6_a1 JTF_NUMBER_TABLE
618: , p6_a2 JTF_NUMBER_TABLE
619: , p6_a3 JTF_NUMBER_TABLE
620: , p6_a4 JTF_VARCHAR2_TABLE_800
621: , p6_a5 JTF_NUMBER_TABLE
622: , p6_a6 JTF_DATE_TABLE
623: , p6_a7 JTF_NUMBER_TABLE
624: , p6_a8 JTF_DATE_TABLE
625: , p6_a9 JTF_NUMBER_TABLE

Line 623: , p6_a7 JTF_NUMBER_TABLE

619: , p6_a3 JTF_NUMBER_TABLE
620: , p6_a4 JTF_VARCHAR2_TABLE_800
621: , p6_a5 JTF_NUMBER_TABLE
622: , p6_a6 JTF_DATE_TABLE
623: , p6_a7 JTF_NUMBER_TABLE
624: , p6_a8 JTF_DATE_TABLE
625: , p6_a9 JTF_NUMBER_TABLE
626: , p7_a0 out nocopy JTF_NUMBER_TABLE
627: , p7_a1 out nocopy JTF_NUMBER_TABLE

Line 625: , p6_a9 JTF_NUMBER_TABLE

621: , p6_a5 JTF_NUMBER_TABLE
622: , p6_a6 JTF_DATE_TABLE
623: , p6_a7 JTF_NUMBER_TABLE
624: , p6_a8 JTF_DATE_TABLE
625: , p6_a9 JTF_NUMBER_TABLE
626: , p7_a0 out nocopy JTF_NUMBER_TABLE
627: , p7_a1 out nocopy JTF_NUMBER_TABLE
628: , p7_a2 out nocopy JTF_NUMBER_TABLE
629: , p7_a3 out nocopy JTF_NUMBER_TABLE

Line 626: , p7_a0 out nocopy JTF_NUMBER_TABLE

622: , p6_a6 JTF_DATE_TABLE
623: , p6_a7 JTF_NUMBER_TABLE
624: , p6_a8 JTF_DATE_TABLE
625: , p6_a9 JTF_NUMBER_TABLE
626: , p7_a0 out nocopy JTF_NUMBER_TABLE
627: , p7_a1 out nocopy JTF_NUMBER_TABLE
628: , p7_a2 out nocopy JTF_NUMBER_TABLE
629: , p7_a3 out nocopy JTF_NUMBER_TABLE
630: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800

Line 627: , p7_a1 out nocopy JTF_NUMBER_TABLE

623: , p6_a7 JTF_NUMBER_TABLE
624: , p6_a8 JTF_DATE_TABLE
625: , p6_a9 JTF_NUMBER_TABLE
626: , p7_a0 out nocopy JTF_NUMBER_TABLE
627: , p7_a1 out nocopy JTF_NUMBER_TABLE
628: , p7_a2 out nocopy JTF_NUMBER_TABLE
629: , p7_a3 out nocopy JTF_NUMBER_TABLE
630: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
631: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 628: , p7_a2 out nocopy JTF_NUMBER_TABLE

624: , p6_a8 JTF_DATE_TABLE
625: , p6_a9 JTF_NUMBER_TABLE
626: , p7_a0 out nocopy JTF_NUMBER_TABLE
627: , p7_a1 out nocopy JTF_NUMBER_TABLE
628: , p7_a2 out nocopy JTF_NUMBER_TABLE
629: , p7_a3 out nocopy JTF_NUMBER_TABLE
630: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
631: , p7_a5 out nocopy JTF_NUMBER_TABLE
632: , p7_a6 out nocopy JTF_DATE_TABLE

Line 629: , p7_a3 out nocopy JTF_NUMBER_TABLE

625: , p6_a9 JTF_NUMBER_TABLE
626: , p7_a0 out nocopy JTF_NUMBER_TABLE
627: , p7_a1 out nocopy JTF_NUMBER_TABLE
628: , p7_a2 out nocopy JTF_NUMBER_TABLE
629: , p7_a3 out nocopy JTF_NUMBER_TABLE
630: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
631: , p7_a5 out nocopy JTF_NUMBER_TABLE
632: , p7_a6 out nocopy JTF_DATE_TABLE
633: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 631: , p7_a5 out nocopy JTF_NUMBER_TABLE

627: , p7_a1 out nocopy JTF_NUMBER_TABLE
628: , p7_a2 out nocopy JTF_NUMBER_TABLE
629: , p7_a3 out nocopy JTF_NUMBER_TABLE
630: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
631: , p7_a5 out nocopy JTF_NUMBER_TABLE
632: , p7_a6 out nocopy JTF_DATE_TABLE
633: , p7_a7 out nocopy JTF_NUMBER_TABLE
634: , p7_a8 out nocopy JTF_DATE_TABLE
635: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 633: , p7_a7 out nocopy JTF_NUMBER_TABLE

629: , p7_a3 out nocopy JTF_NUMBER_TABLE
630: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
631: , p7_a5 out nocopy JTF_NUMBER_TABLE
632: , p7_a6 out nocopy JTF_DATE_TABLE
633: , p7_a7 out nocopy JTF_NUMBER_TABLE
634: , p7_a8 out nocopy JTF_DATE_TABLE
635: , p7_a9 out nocopy JTF_NUMBER_TABLE
636: , p5_a0 NUMBER := 0-1962.0724
637: , p5_a1 NUMBER := 0-1962.0724

Line 635: , p7_a9 out nocopy JTF_NUMBER_TABLE

631: , p7_a5 out nocopy JTF_NUMBER_TABLE
632: , p7_a6 out nocopy JTF_DATE_TABLE
633: , p7_a7 out nocopy JTF_NUMBER_TABLE
634: , p7_a8 out nocopy JTF_DATE_TABLE
635: , p7_a9 out nocopy JTF_NUMBER_TABLE
636: , p5_a0 NUMBER := 0-1962.0724
637: , p5_a1 NUMBER := 0-1962.0724
638: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
639: , p5_a3 NUMBER := 0-1962.0724