APPS.OKL_SETUPFMACONSTRAINTS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 403: , p5_a0 JTF_NUMBER_TABLE

399: , p_init_msg_list VARCHAR2
400: , x_return_status out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2
403: , p5_a0 JTF_NUMBER_TABLE
404: , p5_a1 JTF_NUMBER_TABLE
405: , p5_a2 JTF_NUMBER_TABLE
406: , p5_a3 JTF_NUMBER_TABLE
407: , p5_a4 JTF_VARCHAR2_TABLE_800

Line 404: , p5_a1 JTF_NUMBER_TABLE

400: , x_return_status out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2
403: , p5_a0 JTF_NUMBER_TABLE
404: , p5_a1 JTF_NUMBER_TABLE
405: , p5_a2 JTF_NUMBER_TABLE
406: , p5_a3 JTF_NUMBER_TABLE
407: , p5_a4 JTF_VARCHAR2_TABLE_800
408: , p5_a5 JTF_NUMBER_TABLE

Line 405: , p5_a2 JTF_NUMBER_TABLE

401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2
403: , p5_a0 JTF_NUMBER_TABLE
404: , p5_a1 JTF_NUMBER_TABLE
405: , p5_a2 JTF_NUMBER_TABLE
406: , p5_a3 JTF_NUMBER_TABLE
407: , p5_a4 JTF_VARCHAR2_TABLE_800
408: , p5_a5 JTF_NUMBER_TABLE
409: , p5_a6 JTF_DATE_TABLE

Line 406: , p5_a3 JTF_NUMBER_TABLE

402: , x_msg_data out nocopy VARCHAR2
403: , p5_a0 JTF_NUMBER_TABLE
404: , p5_a1 JTF_NUMBER_TABLE
405: , p5_a2 JTF_NUMBER_TABLE
406: , p5_a3 JTF_NUMBER_TABLE
407: , p5_a4 JTF_VARCHAR2_TABLE_800
408: , p5_a5 JTF_NUMBER_TABLE
409: , p5_a6 JTF_DATE_TABLE
410: , p5_a7 JTF_NUMBER_TABLE

Line 408: , p5_a5 JTF_NUMBER_TABLE

404: , p5_a1 JTF_NUMBER_TABLE
405: , p5_a2 JTF_NUMBER_TABLE
406: , p5_a3 JTF_NUMBER_TABLE
407: , p5_a4 JTF_VARCHAR2_TABLE_800
408: , p5_a5 JTF_NUMBER_TABLE
409: , p5_a6 JTF_DATE_TABLE
410: , p5_a7 JTF_NUMBER_TABLE
411: , p5_a8 JTF_DATE_TABLE
412: , p5_a9 JTF_NUMBER_TABLE

Line 410: , p5_a7 JTF_NUMBER_TABLE

406: , p5_a3 JTF_NUMBER_TABLE
407: , p5_a4 JTF_VARCHAR2_TABLE_800
408: , p5_a5 JTF_NUMBER_TABLE
409: , p5_a6 JTF_DATE_TABLE
410: , p5_a7 JTF_NUMBER_TABLE
411: , p5_a8 JTF_DATE_TABLE
412: , p5_a9 JTF_NUMBER_TABLE
413: )
414:

Line 412: , p5_a9 JTF_NUMBER_TABLE

408: , p5_a5 JTF_NUMBER_TABLE
409: , p5_a6 JTF_DATE_TABLE
410: , p5_a7 JTF_NUMBER_TABLE
411: , p5_a8 JTF_DATE_TABLE
412: , p5_a9 JTF_NUMBER_TABLE
413: )
414:
415: as
416: ddp_fodv_tbl okl_setupfmaconstraints_pvt.fodv_tbl_type;

Line 459: , p6_a0 JTF_NUMBER_TABLE

455: , p_init_msg_list VARCHAR2
456: , x_return_status out nocopy VARCHAR2
457: , x_msg_count out nocopy NUMBER
458: , x_msg_data out nocopy VARCHAR2
459: , p6_a0 JTF_NUMBER_TABLE
460: , p6_a1 JTF_NUMBER_TABLE
461: , p6_a2 JTF_NUMBER_TABLE
462: , p6_a3 JTF_NUMBER_TABLE
463: , p6_a4 JTF_VARCHAR2_TABLE_800

Line 460: , p6_a1 JTF_NUMBER_TABLE

456: , x_return_status out nocopy VARCHAR2
457: , x_msg_count out nocopy NUMBER
458: , x_msg_data out nocopy VARCHAR2
459: , p6_a0 JTF_NUMBER_TABLE
460: , p6_a1 JTF_NUMBER_TABLE
461: , p6_a2 JTF_NUMBER_TABLE
462: , p6_a3 JTF_NUMBER_TABLE
463: , p6_a4 JTF_VARCHAR2_TABLE_800
464: , p6_a5 JTF_NUMBER_TABLE

Line 461: , p6_a2 JTF_NUMBER_TABLE

457: , x_msg_count out nocopy NUMBER
458: , x_msg_data out nocopy VARCHAR2
459: , p6_a0 JTF_NUMBER_TABLE
460: , p6_a1 JTF_NUMBER_TABLE
461: , p6_a2 JTF_NUMBER_TABLE
462: , p6_a3 JTF_NUMBER_TABLE
463: , p6_a4 JTF_VARCHAR2_TABLE_800
464: , p6_a5 JTF_NUMBER_TABLE
465: , p6_a6 JTF_DATE_TABLE

Line 462: , p6_a3 JTF_NUMBER_TABLE

458: , x_msg_data out nocopy VARCHAR2
459: , p6_a0 JTF_NUMBER_TABLE
460: , p6_a1 JTF_NUMBER_TABLE
461: , p6_a2 JTF_NUMBER_TABLE
462: , p6_a3 JTF_NUMBER_TABLE
463: , p6_a4 JTF_VARCHAR2_TABLE_800
464: , p6_a5 JTF_NUMBER_TABLE
465: , p6_a6 JTF_DATE_TABLE
466: , p6_a7 JTF_NUMBER_TABLE

Line 464: , p6_a5 JTF_NUMBER_TABLE

460: , p6_a1 JTF_NUMBER_TABLE
461: , p6_a2 JTF_NUMBER_TABLE
462: , p6_a3 JTF_NUMBER_TABLE
463: , p6_a4 JTF_VARCHAR2_TABLE_800
464: , p6_a5 JTF_NUMBER_TABLE
465: , p6_a6 JTF_DATE_TABLE
466: , p6_a7 JTF_NUMBER_TABLE
467: , p6_a8 JTF_DATE_TABLE
468: , p6_a9 JTF_NUMBER_TABLE

Line 466: , p6_a7 JTF_NUMBER_TABLE

462: , p6_a3 JTF_NUMBER_TABLE
463: , p6_a4 JTF_VARCHAR2_TABLE_800
464: , p6_a5 JTF_NUMBER_TABLE
465: , p6_a6 JTF_DATE_TABLE
466: , p6_a7 JTF_NUMBER_TABLE
467: , p6_a8 JTF_DATE_TABLE
468: , p6_a9 JTF_NUMBER_TABLE
469: , p7_a0 out nocopy JTF_NUMBER_TABLE
470: , p7_a1 out nocopy JTF_NUMBER_TABLE

Line 468: , p6_a9 JTF_NUMBER_TABLE

464: , p6_a5 JTF_NUMBER_TABLE
465: , p6_a6 JTF_DATE_TABLE
466: , p6_a7 JTF_NUMBER_TABLE
467: , p6_a8 JTF_DATE_TABLE
468: , p6_a9 JTF_NUMBER_TABLE
469: , p7_a0 out nocopy JTF_NUMBER_TABLE
470: , p7_a1 out nocopy JTF_NUMBER_TABLE
471: , p7_a2 out nocopy JTF_NUMBER_TABLE
472: , p7_a3 out nocopy JTF_NUMBER_TABLE

Line 469: , p7_a0 out nocopy JTF_NUMBER_TABLE

465: , p6_a6 JTF_DATE_TABLE
466: , p6_a7 JTF_NUMBER_TABLE
467: , p6_a8 JTF_DATE_TABLE
468: , p6_a9 JTF_NUMBER_TABLE
469: , p7_a0 out nocopy JTF_NUMBER_TABLE
470: , p7_a1 out nocopy JTF_NUMBER_TABLE
471: , p7_a2 out nocopy JTF_NUMBER_TABLE
472: , p7_a3 out nocopy JTF_NUMBER_TABLE
473: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800

Line 470: , p7_a1 out nocopy JTF_NUMBER_TABLE

466: , p6_a7 JTF_NUMBER_TABLE
467: , p6_a8 JTF_DATE_TABLE
468: , p6_a9 JTF_NUMBER_TABLE
469: , p7_a0 out nocopy JTF_NUMBER_TABLE
470: , p7_a1 out nocopy JTF_NUMBER_TABLE
471: , p7_a2 out nocopy JTF_NUMBER_TABLE
472: , p7_a3 out nocopy JTF_NUMBER_TABLE
473: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
474: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 471: , p7_a2 out nocopy JTF_NUMBER_TABLE

467: , p6_a8 JTF_DATE_TABLE
468: , p6_a9 JTF_NUMBER_TABLE
469: , p7_a0 out nocopy JTF_NUMBER_TABLE
470: , p7_a1 out nocopy JTF_NUMBER_TABLE
471: , p7_a2 out nocopy JTF_NUMBER_TABLE
472: , p7_a3 out nocopy JTF_NUMBER_TABLE
473: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
474: , p7_a5 out nocopy JTF_NUMBER_TABLE
475: , p7_a6 out nocopy JTF_DATE_TABLE

Line 472: , p7_a3 out nocopy JTF_NUMBER_TABLE

468: , p6_a9 JTF_NUMBER_TABLE
469: , p7_a0 out nocopy JTF_NUMBER_TABLE
470: , p7_a1 out nocopy JTF_NUMBER_TABLE
471: , p7_a2 out nocopy JTF_NUMBER_TABLE
472: , p7_a3 out nocopy JTF_NUMBER_TABLE
473: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
474: , p7_a5 out nocopy JTF_NUMBER_TABLE
475: , p7_a6 out nocopy JTF_DATE_TABLE
476: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 474: , p7_a5 out nocopy JTF_NUMBER_TABLE

470: , p7_a1 out nocopy JTF_NUMBER_TABLE
471: , p7_a2 out nocopy JTF_NUMBER_TABLE
472: , p7_a3 out nocopy JTF_NUMBER_TABLE
473: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
474: , p7_a5 out nocopy JTF_NUMBER_TABLE
475: , p7_a6 out nocopy JTF_DATE_TABLE
476: , p7_a7 out nocopy JTF_NUMBER_TABLE
477: , p7_a8 out nocopy JTF_DATE_TABLE
478: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 476: , p7_a7 out nocopy JTF_NUMBER_TABLE

472: , p7_a3 out nocopy JTF_NUMBER_TABLE
473: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
474: , p7_a5 out nocopy JTF_NUMBER_TABLE
475: , p7_a6 out nocopy JTF_DATE_TABLE
476: , p7_a7 out nocopy JTF_NUMBER_TABLE
477: , p7_a8 out nocopy JTF_DATE_TABLE
478: , p7_a9 out nocopy JTF_NUMBER_TABLE
479: , p5_a0 NUMBER := 0-1962.0724
480: , p5_a1 NUMBER := 0-1962.0724

Line 478: , p7_a9 out nocopy JTF_NUMBER_TABLE

474: , p7_a5 out nocopy JTF_NUMBER_TABLE
475: , p7_a6 out nocopy JTF_DATE_TABLE
476: , p7_a7 out nocopy JTF_NUMBER_TABLE
477: , p7_a8 out nocopy JTF_DATE_TABLE
478: , p7_a9 out nocopy JTF_NUMBER_TABLE
479: , p5_a0 NUMBER := 0-1962.0724
480: , p5_a1 NUMBER := 0-1962.0724
481: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a3 NUMBER := 0-1962.0724

Line 612: , p6_a0 JTF_NUMBER_TABLE

608: , p_init_msg_list VARCHAR2
609: , x_return_status out nocopy VARCHAR2
610: , x_msg_count out nocopy NUMBER
611: , x_msg_data out nocopy VARCHAR2
612: , p6_a0 JTF_NUMBER_TABLE
613: , p6_a1 JTF_NUMBER_TABLE
614: , p6_a2 JTF_NUMBER_TABLE
615: , p6_a3 JTF_NUMBER_TABLE
616: , p6_a4 JTF_VARCHAR2_TABLE_800

Line 613: , p6_a1 JTF_NUMBER_TABLE

609: , x_return_status out nocopy VARCHAR2
610: , x_msg_count out nocopy NUMBER
611: , x_msg_data out nocopy VARCHAR2
612: , p6_a0 JTF_NUMBER_TABLE
613: , p6_a1 JTF_NUMBER_TABLE
614: , p6_a2 JTF_NUMBER_TABLE
615: , p6_a3 JTF_NUMBER_TABLE
616: , p6_a4 JTF_VARCHAR2_TABLE_800
617: , p6_a5 JTF_NUMBER_TABLE

Line 614: , p6_a2 JTF_NUMBER_TABLE

610: , x_msg_count out nocopy NUMBER
611: , x_msg_data out nocopy VARCHAR2
612: , p6_a0 JTF_NUMBER_TABLE
613: , p6_a1 JTF_NUMBER_TABLE
614: , p6_a2 JTF_NUMBER_TABLE
615: , p6_a3 JTF_NUMBER_TABLE
616: , p6_a4 JTF_VARCHAR2_TABLE_800
617: , p6_a5 JTF_NUMBER_TABLE
618: , p6_a6 JTF_DATE_TABLE

Line 615: , p6_a3 JTF_NUMBER_TABLE

611: , x_msg_data out nocopy VARCHAR2
612: , p6_a0 JTF_NUMBER_TABLE
613: , p6_a1 JTF_NUMBER_TABLE
614: , p6_a2 JTF_NUMBER_TABLE
615: , p6_a3 JTF_NUMBER_TABLE
616: , p6_a4 JTF_VARCHAR2_TABLE_800
617: , p6_a5 JTF_NUMBER_TABLE
618: , p6_a6 JTF_DATE_TABLE
619: , p6_a7 JTF_NUMBER_TABLE

Line 617: , p6_a5 JTF_NUMBER_TABLE

613: , p6_a1 JTF_NUMBER_TABLE
614: , p6_a2 JTF_NUMBER_TABLE
615: , p6_a3 JTF_NUMBER_TABLE
616: , p6_a4 JTF_VARCHAR2_TABLE_800
617: , p6_a5 JTF_NUMBER_TABLE
618: , p6_a6 JTF_DATE_TABLE
619: , p6_a7 JTF_NUMBER_TABLE
620: , p6_a8 JTF_DATE_TABLE
621: , p6_a9 JTF_NUMBER_TABLE

Line 619: , p6_a7 JTF_NUMBER_TABLE

615: , p6_a3 JTF_NUMBER_TABLE
616: , p6_a4 JTF_VARCHAR2_TABLE_800
617: , p6_a5 JTF_NUMBER_TABLE
618: , p6_a6 JTF_DATE_TABLE
619: , p6_a7 JTF_NUMBER_TABLE
620: , p6_a8 JTF_DATE_TABLE
621: , p6_a9 JTF_NUMBER_TABLE
622: , p7_a0 out nocopy JTF_NUMBER_TABLE
623: , p7_a1 out nocopy JTF_NUMBER_TABLE

Line 621: , p6_a9 JTF_NUMBER_TABLE

617: , p6_a5 JTF_NUMBER_TABLE
618: , p6_a6 JTF_DATE_TABLE
619: , p6_a7 JTF_NUMBER_TABLE
620: , p6_a8 JTF_DATE_TABLE
621: , p6_a9 JTF_NUMBER_TABLE
622: , p7_a0 out nocopy JTF_NUMBER_TABLE
623: , p7_a1 out nocopy JTF_NUMBER_TABLE
624: , p7_a2 out nocopy JTF_NUMBER_TABLE
625: , p7_a3 out nocopy JTF_NUMBER_TABLE

Line 622: , p7_a0 out nocopy JTF_NUMBER_TABLE

618: , p6_a6 JTF_DATE_TABLE
619: , p6_a7 JTF_NUMBER_TABLE
620: , p6_a8 JTF_DATE_TABLE
621: , p6_a9 JTF_NUMBER_TABLE
622: , p7_a0 out nocopy JTF_NUMBER_TABLE
623: , p7_a1 out nocopy JTF_NUMBER_TABLE
624: , p7_a2 out nocopy JTF_NUMBER_TABLE
625: , p7_a3 out nocopy JTF_NUMBER_TABLE
626: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800

Line 623: , p7_a1 out nocopy JTF_NUMBER_TABLE

619: , p6_a7 JTF_NUMBER_TABLE
620: , p6_a8 JTF_DATE_TABLE
621: , p6_a9 JTF_NUMBER_TABLE
622: , p7_a0 out nocopy JTF_NUMBER_TABLE
623: , p7_a1 out nocopy JTF_NUMBER_TABLE
624: , p7_a2 out nocopy JTF_NUMBER_TABLE
625: , p7_a3 out nocopy JTF_NUMBER_TABLE
626: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
627: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 624: , p7_a2 out nocopy JTF_NUMBER_TABLE

620: , p6_a8 JTF_DATE_TABLE
621: , p6_a9 JTF_NUMBER_TABLE
622: , p7_a0 out nocopy JTF_NUMBER_TABLE
623: , p7_a1 out nocopy JTF_NUMBER_TABLE
624: , p7_a2 out nocopy JTF_NUMBER_TABLE
625: , p7_a3 out nocopy JTF_NUMBER_TABLE
626: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
627: , p7_a5 out nocopy JTF_NUMBER_TABLE
628: , p7_a6 out nocopy JTF_DATE_TABLE

Line 625: , p7_a3 out nocopy JTF_NUMBER_TABLE

621: , p6_a9 JTF_NUMBER_TABLE
622: , p7_a0 out nocopy JTF_NUMBER_TABLE
623: , p7_a1 out nocopy JTF_NUMBER_TABLE
624: , p7_a2 out nocopy JTF_NUMBER_TABLE
625: , p7_a3 out nocopy JTF_NUMBER_TABLE
626: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
627: , p7_a5 out nocopy JTF_NUMBER_TABLE
628: , p7_a6 out nocopy JTF_DATE_TABLE
629: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 627: , p7_a5 out nocopy JTF_NUMBER_TABLE

623: , p7_a1 out nocopy JTF_NUMBER_TABLE
624: , p7_a2 out nocopy JTF_NUMBER_TABLE
625: , p7_a3 out nocopy JTF_NUMBER_TABLE
626: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
627: , p7_a5 out nocopy JTF_NUMBER_TABLE
628: , p7_a6 out nocopy JTF_DATE_TABLE
629: , p7_a7 out nocopy JTF_NUMBER_TABLE
630: , p7_a8 out nocopy JTF_DATE_TABLE
631: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 629: , p7_a7 out nocopy JTF_NUMBER_TABLE

625: , p7_a3 out nocopy JTF_NUMBER_TABLE
626: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
627: , p7_a5 out nocopy JTF_NUMBER_TABLE
628: , p7_a6 out nocopy JTF_DATE_TABLE
629: , p7_a7 out nocopy JTF_NUMBER_TABLE
630: , p7_a8 out nocopy JTF_DATE_TABLE
631: , p7_a9 out nocopy JTF_NUMBER_TABLE
632: , p5_a0 NUMBER := 0-1962.0724
633: , p5_a1 NUMBER := 0-1962.0724

Line 631: , p7_a9 out nocopy JTF_NUMBER_TABLE

627: , p7_a5 out nocopy JTF_NUMBER_TABLE
628: , p7_a6 out nocopy JTF_DATE_TABLE
629: , p7_a7 out nocopy JTF_NUMBER_TABLE
630: , p7_a8 out nocopy JTF_DATE_TABLE
631: , p7_a9 out nocopy JTF_NUMBER_TABLE
632: , p5_a0 NUMBER := 0-1962.0724
633: , p5_a1 NUMBER := 0-1962.0724
634: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
635: , p5_a3 NUMBER := 0-1962.0724