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
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
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
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
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
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:
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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