DBA Data[Home] [Help]

APPS.OE_PRICE_ORDER_PVT_W_OBSOLETE dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p3(t out oe_price_order_pvt.price_att_tbl_type, a0 JTF_NUMBER_TABLE

1: package oe_price_order_pvt_w_obsolete AUTHID CURRENT_USER as
2: /* $Header: OERVPROS.pls 115.2 2004/05/19 21:37:39 lchen noship $ */
3: procedure rosetta_table_copy_in_p3(t out oe_price_order_pvt.price_att_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package oe_price_order_pvt_w_obsolete AUTHID CURRENT_USER as
2: /* $Header: OERVPROS.pls 115.2 2004/05/19 21:37:39 lchen noship $ */
3: procedure rosetta_table_copy_in_p3(t out oe_price_order_pvt.price_att_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300

Line 11: procedure rosetta_table_copy_out_p3(t oe_price_order_pvt.price_att_tbl_type, a0 out JTF_NUMBER_TABLE

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: );
11: procedure rosetta_table_copy_out_p3(t oe_price_order_pvt.price_att_tbl_type, a0 out JTF_NUMBER_TABLE
12: , a1 out JTF_NUMBER_TABLE
13: , a2 out JTF_VARCHAR2_TABLE_100
14: , a3 out JTF_VARCHAR2_TABLE_100
15: , a4 out JTF_VARCHAR2_TABLE_100

Line 12: , a1 out JTF_NUMBER_TABLE

8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: );
11: procedure rosetta_table_copy_out_p3(t oe_price_order_pvt.price_att_tbl_type, a0 out JTF_NUMBER_TABLE
12: , a1 out JTF_NUMBER_TABLE
13: , a2 out JTF_VARCHAR2_TABLE_100
14: , a3 out JTF_VARCHAR2_TABLE_100
15: , a4 out JTF_VARCHAR2_TABLE_100
16: , a5 out JTF_VARCHAR2_TABLE_300

Line 534: , p2_a17 in out JTF_NUMBER_TABLE

530: , p2_a13 in out JTF_VARCHAR2_TABLE_300
531: , p2_a14 in out JTF_VARCHAR2_TABLE_300
532: , p2_a15 in out JTF_VARCHAR2_TABLE_100
533: , p2_a16 in out JTF_VARCHAR2_TABLE_100
534: , p2_a17 in out JTF_NUMBER_TABLE
535: , p2_a18 in out JTF_DATE_TABLE
536: , p2_a19 in out JTF_NUMBER_TABLE
537: , p2_a20 in out JTF_NUMBER_TABLE
538: , p2_a21 in out JTF_NUMBER_TABLE

Line 536: , p2_a19 in out JTF_NUMBER_TABLE

532: , p2_a15 in out JTF_VARCHAR2_TABLE_100
533: , p2_a16 in out JTF_VARCHAR2_TABLE_100
534: , p2_a17 in out JTF_NUMBER_TABLE
535: , p2_a18 in out JTF_DATE_TABLE
536: , p2_a19 in out JTF_NUMBER_TABLE
537: , p2_a20 in out JTF_NUMBER_TABLE
538: , p2_a21 in out JTF_NUMBER_TABLE
539: , p2_a22 in out JTF_NUMBER_TABLE
540: , p2_a23 in out JTF_DATE_TABLE

Line 537: , p2_a20 in out JTF_NUMBER_TABLE

533: , p2_a16 in out JTF_VARCHAR2_TABLE_100
534: , p2_a17 in out JTF_NUMBER_TABLE
535: , p2_a18 in out JTF_DATE_TABLE
536: , p2_a19 in out JTF_NUMBER_TABLE
537: , p2_a20 in out JTF_NUMBER_TABLE
538: , p2_a21 in out JTF_NUMBER_TABLE
539: , p2_a22 in out JTF_NUMBER_TABLE
540: , p2_a23 in out JTF_DATE_TABLE
541: , p2_a24 in out JTF_NUMBER_TABLE

Line 538: , p2_a21 in out JTF_NUMBER_TABLE

534: , p2_a17 in out JTF_NUMBER_TABLE
535: , p2_a18 in out JTF_DATE_TABLE
536: , p2_a19 in out JTF_NUMBER_TABLE
537: , p2_a20 in out JTF_NUMBER_TABLE
538: , p2_a21 in out JTF_NUMBER_TABLE
539: , p2_a22 in out JTF_NUMBER_TABLE
540: , p2_a23 in out JTF_DATE_TABLE
541: , p2_a24 in out JTF_NUMBER_TABLE
542: , p2_a25 in out JTF_NUMBER_TABLE

Line 539: , p2_a22 in out JTF_NUMBER_TABLE

535: , p2_a18 in out JTF_DATE_TABLE
536: , p2_a19 in out JTF_NUMBER_TABLE
537: , p2_a20 in out JTF_NUMBER_TABLE
538: , p2_a21 in out JTF_NUMBER_TABLE
539: , p2_a22 in out JTF_NUMBER_TABLE
540: , p2_a23 in out JTF_DATE_TABLE
541: , p2_a24 in out JTF_NUMBER_TABLE
542: , p2_a25 in out JTF_NUMBER_TABLE
543: , p2_a26 in out JTF_NUMBER_TABLE

Line 541: , p2_a24 in out JTF_NUMBER_TABLE

537: , p2_a20 in out JTF_NUMBER_TABLE
538: , p2_a21 in out JTF_NUMBER_TABLE
539: , p2_a22 in out JTF_NUMBER_TABLE
540: , p2_a23 in out JTF_DATE_TABLE
541: , p2_a24 in out JTF_NUMBER_TABLE
542: , p2_a25 in out JTF_NUMBER_TABLE
543: , p2_a26 in out JTF_NUMBER_TABLE
544: , p2_a27 in out JTF_NUMBER_TABLE
545: , p2_a28 in out JTF_NUMBER_TABLE

Line 542: , p2_a25 in out JTF_NUMBER_TABLE

538: , p2_a21 in out JTF_NUMBER_TABLE
539: , p2_a22 in out JTF_NUMBER_TABLE
540: , p2_a23 in out JTF_DATE_TABLE
541: , p2_a24 in out JTF_NUMBER_TABLE
542: , p2_a25 in out JTF_NUMBER_TABLE
543: , p2_a26 in out JTF_NUMBER_TABLE
544: , p2_a27 in out JTF_NUMBER_TABLE
545: , p2_a28 in out JTF_NUMBER_TABLE
546: , p2_a29 in out JTF_NUMBER_TABLE

Line 543: , p2_a26 in out JTF_NUMBER_TABLE

539: , p2_a22 in out JTF_NUMBER_TABLE
540: , p2_a23 in out JTF_DATE_TABLE
541: , p2_a24 in out JTF_NUMBER_TABLE
542: , p2_a25 in out JTF_NUMBER_TABLE
543: , p2_a26 in out JTF_NUMBER_TABLE
544: , p2_a27 in out JTF_NUMBER_TABLE
545: , p2_a28 in out JTF_NUMBER_TABLE
546: , p2_a29 in out JTF_NUMBER_TABLE
547: , p2_a30 in out JTF_DATE_TABLE

Line 544: , p2_a27 in out JTF_NUMBER_TABLE

540: , p2_a23 in out JTF_DATE_TABLE
541: , p2_a24 in out JTF_NUMBER_TABLE
542: , p2_a25 in out JTF_NUMBER_TABLE
543: , p2_a26 in out JTF_NUMBER_TABLE
544: , p2_a27 in out JTF_NUMBER_TABLE
545: , p2_a28 in out JTF_NUMBER_TABLE
546: , p2_a29 in out JTF_NUMBER_TABLE
547: , p2_a30 in out JTF_DATE_TABLE
548: , p2_a31 in out JTF_NUMBER_TABLE

Line 545: , p2_a28 in out JTF_NUMBER_TABLE

541: , p2_a24 in out JTF_NUMBER_TABLE
542: , p2_a25 in out JTF_NUMBER_TABLE
543: , p2_a26 in out JTF_NUMBER_TABLE
544: , p2_a27 in out JTF_NUMBER_TABLE
545: , p2_a28 in out JTF_NUMBER_TABLE
546: , p2_a29 in out JTF_NUMBER_TABLE
547: , p2_a30 in out JTF_DATE_TABLE
548: , p2_a31 in out JTF_NUMBER_TABLE
549: , p2_a32 in out JTF_VARCHAR2_TABLE_100

Line 546: , p2_a29 in out JTF_NUMBER_TABLE

542: , p2_a25 in out JTF_NUMBER_TABLE
543: , p2_a26 in out JTF_NUMBER_TABLE
544: , p2_a27 in out JTF_NUMBER_TABLE
545: , p2_a28 in out JTF_NUMBER_TABLE
546: , p2_a29 in out JTF_NUMBER_TABLE
547: , p2_a30 in out JTF_DATE_TABLE
548: , p2_a31 in out JTF_NUMBER_TABLE
549: , p2_a32 in out JTF_VARCHAR2_TABLE_100
550: , p2_a33 in out JTF_VARCHAR2_TABLE_100

Line 548: , p2_a31 in out JTF_NUMBER_TABLE

544: , p2_a27 in out JTF_NUMBER_TABLE
545: , p2_a28 in out JTF_NUMBER_TABLE
546: , p2_a29 in out JTF_NUMBER_TABLE
547: , p2_a30 in out JTF_DATE_TABLE
548: , p2_a31 in out JTF_NUMBER_TABLE
549: , p2_a32 in out JTF_VARCHAR2_TABLE_100
550: , p2_a33 in out JTF_VARCHAR2_TABLE_100
551: , p2_a34 in out JTF_VARCHAR2_TABLE_100
552: , p2_a35 in out JTF_NUMBER_TABLE

Line 552: , p2_a35 in out JTF_NUMBER_TABLE

548: , p2_a31 in out JTF_NUMBER_TABLE
549: , p2_a32 in out JTF_VARCHAR2_TABLE_100
550: , p2_a33 in out JTF_VARCHAR2_TABLE_100
551: , p2_a34 in out JTF_VARCHAR2_TABLE_100
552: , p2_a35 in out JTF_NUMBER_TABLE
553: , p2_a36 in out JTF_VARCHAR2_TABLE_100
554: , p2_a37 in out JTF_VARCHAR2_TABLE_100
555: , p2_a38 in out JTF_VARCHAR2_TABLE_100
556: , p2_a39 in out JTF_NUMBER_TABLE

Line 556: , p2_a39 in out JTF_NUMBER_TABLE

552: , p2_a35 in out JTF_NUMBER_TABLE
553: , p2_a36 in out JTF_VARCHAR2_TABLE_100
554: , p2_a37 in out JTF_VARCHAR2_TABLE_100
555: , p2_a38 in out JTF_VARCHAR2_TABLE_100
556: , p2_a39 in out JTF_NUMBER_TABLE
557: , p2_a40 in out JTF_NUMBER_TABLE
558: , p2_a41 in out JTF_VARCHAR2_TABLE_100
559: , p2_a42 in out JTF_VARCHAR2_TABLE_100
560: , p2_a43 in out JTF_VARCHAR2_TABLE_300

Line 557: , p2_a40 in out JTF_NUMBER_TABLE

553: , p2_a36 in out JTF_VARCHAR2_TABLE_100
554: , p2_a37 in out JTF_VARCHAR2_TABLE_100
555: , p2_a38 in out JTF_VARCHAR2_TABLE_100
556: , p2_a39 in out JTF_NUMBER_TABLE
557: , p2_a40 in out JTF_NUMBER_TABLE
558: , p2_a41 in out JTF_VARCHAR2_TABLE_100
559: , p2_a42 in out JTF_VARCHAR2_TABLE_100
560: , p2_a43 in out JTF_VARCHAR2_TABLE_300
561: , p2_a44 in out JTF_VARCHAR2_TABLE_300

Line 567: , p2_a50 in out JTF_NUMBER_TABLE

563: , p2_a46 in out JTF_VARCHAR2_TABLE_100
564: , p2_a47 in out JTF_VARCHAR2_TABLE_100
565: , p2_a48 in out JTF_VARCHAR2_TABLE_100
566: , p2_a49 in out JTF_VARCHAR2_TABLE_2000
567: , p2_a50 in out JTF_NUMBER_TABLE
568: , p2_a51 in out JTF_NUMBER_TABLE
569: , p2_a52 in out JTF_VARCHAR2_TABLE_100
570: , p2_a53 in out JTF_NUMBER_TABLE
571: , p2_a54 in out JTF_VARCHAR2_TABLE_100

Line 568: , p2_a51 in out JTF_NUMBER_TABLE

564: , p2_a47 in out JTF_VARCHAR2_TABLE_100
565: , p2_a48 in out JTF_VARCHAR2_TABLE_100
566: , p2_a49 in out JTF_VARCHAR2_TABLE_2000
567: , p2_a50 in out JTF_NUMBER_TABLE
568: , p2_a51 in out JTF_NUMBER_TABLE
569: , p2_a52 in out JTF_VARCHAR2_TABLE_100
570: , p2_a53 in out JTF_NUMBER_TABLE
571: , p2_a54 in out JTF_VARCHAR2_TABLE_100
572: , p2_a55 in out JTF_VARCHAR2_TABLE_100

Line 570: , p2_a53 in out JTF_NUMBER_TABLE

566: , p2_a49 in out JTF_VARCHAR2_TABLE_2000
567: , p2_a50 in out JTF_NUMBER_TABLE
568: , p2_a51 in out JTF_NUMBER_TABLE
569: , p2_a52 in out JTF_VARCHAR2_TABLE_100
570: , p2_a53 in out JTF_NUMBER_TABLE
571: , p2_a54 in out JTF_VARCHAR2_TABLE_100
572: , p2_a55 in out JTF_VARCHAR2_TABLE_100
573: , p2_a56 in out JTF_VARCHAR2_TABLE_100
574: , p2_a57 in out JTF_VARCHAR2_TABLE_100

Line 575: , p2_a58 in out JTF_NUMBER_TABLE

571: , p2_a54 in out JTF_VARCHAR2_TABLE_100
572: , p2_a55 in out JTF_VARCHAR2_TABLE_100
573: , p2_a56 in out JTF_VARCHAR2_TABLE_100
574: , p2_a57 in out JTF_VARCHAR2_TABLE_100
575: , p2_a58 in out JTF_NUMBER_TABLE
576: , p2_a59 in out JTF_VARCHAR2_TABLE_100
577: , p2_a60 in out JTF_VARCHAR2_TABLE_100
578: , p2_a61 in out JTF_VARCHAR2_TABLE_100
579: , p2_a62 in out JTF_VARCHAR2_TABLE_100

Line 580: , p2_a63 in out JTF_NUMBER_TABLE

576: , p2_a59 in out JTF_VARCHAR2_TABLE_100
577: , p2_a60 in out JTF_VARCHAR2_TABLE_100
578: , p2_a61 in out JTF_VARCHAR2_TABLE_100
579: , p2_a62 in out JTF_VARCHAR2_TABLE_100
580: , p2_a63 in out JTF_NUMBER_TABLE
581: , p2_a64 in out JTF_NUMBER_TABLE
582: , p2_a65 in out JTF_NUMBER_TABLE
583: , p2_a66 in out JTF_VARCHAR2_TABLE_100
584: , p2_a67 in out JTF_VARCHAR2_TABLE_100

Line 581: , p2_a64 in out JTF_NUMBER_TABLE

577: , p2_a60 in out JTF_VARCHAR2_TABLE_100
578: , p2_a61 in out JTF_VARCHAR2_TABLE_100
579: , p2_a62 in out JTF_VARCHAR2_TABLE_100
580: , p2_a63 in out JTF_NUMBER_TABLE
581: , p2_a64 in out JTF_NUMBER_TABLE
582: , p2_a65 in out JTF_NUMBER_TABLE
583: , p2_a66 in out JTF_VARCHAR2_TABLE_100
584: , p2_a67 in out JTF_VARCHAR2_TABLE_100
585: , p2_a68 in out JTF_VARCHAR2_TABLE_300

Line 582: , p2_a65 in out JTF_NUMBER_TABLE

578: , p2_a61 in out JTF_VARCHAR2_TABLE_100
579: , p2_a62 in out JTF_VARCHAR2_TABLE_100
580: , p2_a63 in out JTF_NUMBER_TABLE
581: , p2_a64 in out JTF_NUMBER_TABLE
582: , p2_a65 in out JTF_NUMBER_TABLE
583: , p2_a66 in out JTF_VARCHAR2_TABLE_100
584: , p2_a67 in out JTF_VARCHAR2_TABLE_100
585: , p2_a68 in out JTF_VARCHAR2_TABLE_300
586: , p2_a69 in out JTF_VARCHAR2_TABLE_100

Line 587: , p2_a70 in out JTF_NUMBER_TABLE

583: , p2_a66 in out JTF_VARCHAR2_TABLE_100
584: , p2_a67 in out JTF_VARCHAR2_TABLE_100
585: , p2_a68 in out JTF_VARCHAR2_TABLE_300
586: , p2_a69 in out JTF_VARCHAR2_TABLE_100
587: , p2_a70 in out JTF_NUMBER_TABLE
588: , p2_a71 in out JTF_VARCHAR2_TABLE_100
589: , p2_a72 in out JTF_VARCHAR2_TABLE_100
590: , p2_a73 in out JTF_DATE_TABLE
591: , p2_a74 in out JTF_VARCHAR2_TABLE_100

Line 597: , p2_a80 in out JTF_NUMBER_TABLE

593: , p2_a76 in out JTF_VARCHAR2_TABLE_100
594: , p2_a77 in out JTF_DATE_TABLE
595: , p2_a78 in out JTF_VARCHAR2_TABLE_100
596: , p2_a79 in out JTF_VARCHAR2_TABLE_100
597: , p2_a80 in out JTF_NUMBER_TABLE
598: , p2_a81 in out JTF_NUMBER_TABLE
599: , p2_a82 in out JTF_NUMBER_TABLE
600: , p2_a83 in out JTF_VARCHAR2_TABLE_100
601: , p2_a84 in out JTF_VARCHAR2_TABLE_100

Line 598: , p2_a81 in out JTF_NUMBER_TABLE

594: , p2_a77 in out JTF_DATE_TABLE
595: , p2_a78 in out JTF_VARCHAR2_TABLE_100
596: , p2_a79 in out JTF_VARCHAR2_TABLE_100
597: , p2_a80 in out JTF_NUMBER_TABLE
598: , p2_a81 in out JTF_NUMBER_TABLE
599: , p2_a82 in out JTF_NUMBER_TABLE
600: , p2_a83 in out JTF_VARCHAR2_TABLE_100
601: , p2_a84 in out JTF_VARCHAR2_TABLE_100
602: , p2_a85 in out JTF_VARCHAR2_TABLE_100

Line 599: , p2_a82 in out JTF_NUMBER_TABLE

595: , p2_a78 in out JTF_VARCHAR2_TABLE_100
596: , p2_a79 in out JTF_VARCHAR2_TABLE_100
597: , p2_a80 in out JTF_NUMBER_TABLE
598: , p2_a81 in out JTF_NUMBER_TABLE
599: , p2_a82 in out JTF_NUMBER_TABLE
600: , p2_a83 in out JTF_VARCHAR2_TABLE_100
601: , p2_a84 in out JTF_VARCHAR2_TABLE_100
602: , p2_a85 in out JTF_VARCHAR2_TABLE_100
603: , p2_a86 in out JTF_VARCHAR2_TABLE_100

Line 622: , p2_a105 in out JTF_NUMBER_TABLE

618: , p2_a101 in out JTF_VARCHAR2_TABLE_300
619: , p2_a102 in out JTF_VARCHAR2_TABLE_300
620: , p2_a103 in out JTF_VARCHAR2_TABLE_300
621: , p2_a104 in out JTF_VARCHAR2_TABLE_200
622: , p2_a105 in out JTF_NUMBER_TABLE
623: , p2_a106 in out JTF_NUMBER_TABLE
624: , p2_a107 in out JTF_NUMBER_TABLE
625: , p2_a108 in out JTF_NUMBER_TABLE
626: , p3_a0 JTF_NUMBER_TABLE

Line 623: , p2_a106 in out JTF_NUMBER_TABLE

619: , p2_a102 in out JTF_VARCHAR2_TABLE_300
620: , p2_a103 in out JTF_VARCHAR2_TABLE_300
621: , p2_a104 in out JTF_VARCHAR2_TABLE_200
622: , p2_a105 in out JTF_NUMBER_TABLE
623: , p2_a106 in out JTF_NUMBER_TABLE
624: , p2_a107 in out JTF_NUMBER_TABLE
625: , p2_a108 in out JTF_NUMBER_TABLE
626: , p3_a0 JTF_NUMBER_TABLE
627: , p3_a1 JTF_NUMBER_TABLE

Line 624: , p2_a107 in out JTF_NUMBER_TABLE

620: , p2_a103 in out JTF_VARCHAR2_TABLE_300
621: , p2_a104 in out JTF_VARCHAR2_TABLE_200
622: , p2_a105 in out JTF_NUMBER_TABLE
623: , p2_a106 in out JTF_NUMBER_TABLE
624: , p2_a107 in out JTF_NUMBER_TABLE
625: , p2_a108 in out JTF_NUMBER_TABLE
626: , p3_a0 JTF_NUMBER_TABLE
627: , p3_a1 JTF_NUMBER_TABLE
628: , p3_a2 JTF_VARCHAR2_TABLE_100

Line 625: , p2_a108 in out JTF_NUMBER_TABLE

621: , p2_a104 in out JTF_VARCHAR2_TABLE_200
622: , p2_a105 in out JTF_NUMBER_TABLE
623: , p2_a106 in out JTF_NUMBER_TABLE
624: , p2_a107 in out JTF_NUMBER_TABLE
625: , p2_a108 in out JTF_NUMBER_TABLE
626: , p3_a0 JTF_NUMBER_TABLE
627: , p3_a1 JTF_NUMBER_TABLE
628: , p3_a2 JTF_VARCHAR2_TABLE_100
629: , p3_a3 JTF_VARCHAR2_TABLE_100

Line 626: , p3_a0 JTF_NUMBER_TABLE

622: , p2_a105 in out JTF_NUMBER_TABLE
623: , p2_a106 in out JTF_NUMBER_TABLE
624: , p2_a107 in out JTF_NUMBER_TABLE
625: , p2_a108 in out JTF_NUMBER_TABLE
626: , p3_a0 JTF_NUMBER_TABLE
627: , p3_a1 JTF_NUMBER_TABLE
628: , p3_a2 JTF_VARCHAR2_TABLE_100
629: , p3_a3 JTF_VARCHAR2_TABLE_100
630: , p3_a4 JTF_VARCHAR2_TABLE_100

Line 627: , p3_a1 JTF_NUMBER_TABLE

623: , p2_a106 in out JTF_NUMBER_TABLE
624: , p2_a107 in out JTF_NUMBER_TABLE
625: , p2_a108 in out JTF_NUMBER_TABLE
626: , p3_a0 JTF_NUMBER_TABLE
627: , p3_a1 JTF_NUMBER_TABLE
628: , p3_a2 JTF_VARCHAR2_TABLE_100
629: , p3_a3 JTF_VARCHAR2_TABLE_100
630: , p3_a4 JTF_VARCHAR2_TABLE_100
631: , p3_a5 JTF_VARCHAR2_TABLE_300