eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_PRICE_PVT dependencies on JTF_NUMBER_TABLE

Line 493: ,p_item_tbl IN JTF_NUMBER_TABLE

489: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
490: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
491: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
492: ,p_currency_code IN VARCHAR2
493: ,p_item_tbl IN JTF_NUMBER_TABLE
494: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
495: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := null
496: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := null
497: -- ,p_calculate_flag IN CHAR(1) :='Y'

Line 495: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := null

491: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
492: ,p_currency_code IN VARCHAR2
493: ,p_item_tbl IN JTF_NUMBER_TABLE
494: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
495: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := null
496: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := null
497: -- ,p_calculate_flag IN CHAR(1) :='Y'
498: ,p_request_type_code IN VARCHAR2
499: ,p_pricing_event IN VARCHAR2

Line 496: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := null

492: ,p_currency_code IN VARCHAR2
493: ,p_item_tbl IN JTF_NUMBER_TABLE
494: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
495: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := null
496: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := null
497: -- ,p_calculate_flag IN CHAR(1) :='Y'
498: ,p_request_type_code IN VARCHAR2
499: ,p_pricing_event IN VARCHAR2
500: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 500: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

496: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := null
497: -- ,p_calculate_flag IN CHAR(1) :='Y'
498: ,p_request_type_code IN VARCHAR2
499: ,p_pricing_event IN VARCHAR2
500: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
501: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
502: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
503: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
504: ,x_parentIndex_tbl OUT nocopy JTF_NUMBER_TABLE

Line 501: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

497: -- ,p_calculate_flag IN CHAR(1) :='Y'
498: ,p_request_type_code IN VARCHAR2
499: ,p_pricing_event IN VARCHAR2
500: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
501: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
502: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
503: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
504: ,x_parentIndex_tbl OUT nocopy JTF_NUMBER_TABLE
505: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE

Line 504: ,x_parentIndex_tbl OUT nocopy JTF_NUMBER_TABLE

500: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
501: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
502: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
503: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
504: ,x_parentIndex_tbl OUT nocopy JTF_NUMBER_TABLE
505: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE
506: ,x_return_status out nocopy varchar2
507: ,x_return_status_text out nocopy varchar2
508: )

Line 505: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE

501: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
502: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
503: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
504: ,x_parentIndex_tbl OUT nocopy JTF_NUMBER_TABLE
505: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE
506: ,x_return_status out nocopy varchar2
507: ,x_return_status_text out nocopy varchar2
508: )
509: IS

Line 632: x_listprice_tbl := JTF_NUMBER_TABLE();

628:
629: -- clear values in global structures that were used
630: clear_Global_Structures;
631:
632: x_listprice_tbl := JTF_NUMBER_TABLE();
633: x_bestprice_tbl := JTF_NUMBER_TABLE();
634: x_status_code_tbl := JTF_VARCHAR2_TABLE_100();
635: x_status_text_tbl := JTF_VARCHAR2_TABLE_300();
636:

Line 633: x_bestprice_tbl := JTF_NUMBER_TABLE();

629: -- clear values in global structures that were used
630: clear_Global_Structures;
631:
632: x_listprice_tbl := JTF_NUMBER_TABLE();
633: x_bestprice_tbl := JTF_NUMBER_TABLE();
634: x_status_code_tbl := JTF_VARCHAR2_TABLE_100();
635: x_status_text_tbl := JTF_VARCHAR2_TABLE_300();
636:
637: x_parentIndex_tbl := JTF_NUMBER_TABLE();

Line 637: x_parentIndex_tbl := JTF_NUMBER_TABLE();

633: x_bestprice_tbl := JTF_NUMBER_TABLE();
634: x_status_code_tbl := JTF_VARCHAR2_TABLE_100();
635: x_status_text_tbl := JTF_VARCHAR2_TABLE_300();
636:
637: x_parentIndex_tbl := JTF_NUMBER_TABLE();
638: x_childIndex_tbl := JTF_NUMBER_TABLE();
639:
640: x_listprice_tbl.extend(l_line_tbl.count);
641: x_bestprice_tbl.extend(l_line_tbl.count);

Line 638: x_childIndex_tbl := JTF_NUMBER_TABLE();

634: x_status_code_tbl := JTF_VARCHAR2_TABLE_100();
635: x_status_text_tbl := JTF_VARCHAR2_TABLE_300();
636:
637: x_parentIndex_tbl := JTF_NUMBER_TABLE();
638: x_childIndex_tbl := JTF_NUMBER_TABLE();
639:
640: x_listprice_tbl.extend(l_line_tbl.count);
641: x_bestprice_tbl.extend(l_line_tbl.count);
642: x_status_code_tbl.extend(l_line_tbl.count);

Line 680: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

676: ,x_status_code OUT NOCOPY varchar2
677: ,x_status_text OUT NOCOPY varchar2
678: )
679: IS
680: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
681: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
682: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
683: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
684: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 682: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

678: )
679: IS
680: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
681: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
682: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
683: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
684: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
685: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
686:

Line 683: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

679: IS
680: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
681: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
682: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
683: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
684: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
685: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
686:
687: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 687: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

683: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
684: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
685: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
686:
687: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
688: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
689:
690: x_return_status VARCHAR2(1);
691: x_return_status_text VARCHAR2(240);

Line 688: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

684: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
685: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
686:
687: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
688: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
689:
690: x_return_status VARCHAR2(1);
691: x_return_status_text VARCHAR2(240);
692:

Line 737: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

733: ,x_status_code OUT NOCOPY varchar2
734: ,x_status_text OUT NOCOPY varchar2
735: )
736: IS
737: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
738: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
739: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
740: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
741: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 739: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

735: )
736: IS
737: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
738: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
739: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
740: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
741: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
742: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
743:

Line 740: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

736: IS
737: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
738: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
739: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
740: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
741: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
742: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
743:
744: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 744: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

740: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
741: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
742: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
743:
744: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
745: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
746:
747:
748: x_return_status VARCHAR2(1);

Line 745: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

741: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
742: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
743:
744: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
745: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
746:
747:
748: x_return_status VARCHAR2(1);
749: x_return_status_text VARCHAR2(240);

Line 798: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

794: ,x_status_code OUT NOCOPY varchar2
795: ,x_status_text OUT NOCOPY varchar2
796: )
797: IS
798: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
799: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
800: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
801: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
802: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 800: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

796: )
797: IS
798: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
799: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
800: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
801: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
802: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
803: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
804:

Line 801: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

797: IS
798: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
799: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
800: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
801: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
802: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
803: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
804:
805: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 805: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

801: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
802: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
803: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
804:
805: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
806: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
807:
808:
809: x_return_status VARCHAR2(1);

Line 806: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

802: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
803: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
804:
805: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
806: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
807:
808:
809: x_return_status VARCHAR2(1);
810: x_return_status_text VARCHAR2(240);

Line 877: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

873: ,x_related_status_code OUT NOCOPY varchar2
874: ,x_related_status_text OUT NOCOPY varchar2
875: )
876: IS
877: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
878: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
879: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
880: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
881: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 879: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

875: )
876: IS
877: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
878: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
879: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
880: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
881: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
882: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
883:

Line 880: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

876: IS
877: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
878: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
879: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
880: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
881: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
882: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
883:
884: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 884: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

880: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
881: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
882: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
883:
884: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
885: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
886:
887: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
888: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 885: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

881: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
882: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
883:
884: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
885: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
886:
887: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
888: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
889:

Line 887: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

883:
884: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
885: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
886:
887: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
888: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
889:
890: x_return_status VARCHAR2(1);
891: x_return_status_text VARCHAR2(240);

Line 888: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

884: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
885: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
886:
887: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
888: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
889:
890: x_return_status VARCHAR2(1);
891: x_return_status_text VARCHAR2(240);
892:

Line 966: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

962: ,x_related_status_code OUT NOCOPY varchar2
963: ,x_related_status_text OUT NOCOPY varchar2
964: )
965: IS
966: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
967: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
968: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
969: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
970: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 968: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

964: )
965: IS
966: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
967: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
968: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
969: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
970: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
971: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
972:

Line 969: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

965: IS
966: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
967: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
968: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
969: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
970: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
971: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
972:
973: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 973: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

969: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
970: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
971: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
972:
973: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
974: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
975:
976: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
977: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 974: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

970: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
971: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
972:
973: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
974: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
975:
976: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
977: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
978:

Line 976: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

972:
973: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
974: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
975:
976: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
977: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
978:
979:
980: x_return_status VARCHAR2(1);

Line 977: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

973: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
974: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
975:
976: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
977: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
978:
979:
980: x_return_status VARCHAR2(1);
981: x_return_status_text VARCHAR2(240);

Line 1059: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1055: ,x_related_status_code OUT NOCOPY varchar2
1056: ,x_related_status_text OUT NOCOPY varchar2
1057: )
1058: IS
1059: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1060: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1061: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1062: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1063: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 1061: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1057: )
1058: IS
1059: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1060: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1061: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1062: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1063: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1064: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1065:

Line 1062: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1058: IS
1059: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1060: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1061: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1062: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1063: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1064: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1065:
1066: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1066: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1062: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1063: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1064: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1065:
1066: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1067: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1068:
1069: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1070: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1067: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1063: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1064: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1065:
1066: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1067: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1068:
1069: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1070: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1071:

Line 1069: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1065:
1066: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1067: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1068:
1069: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1070: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1071:
1072:
1073: x_return_status VARCHAR2(1);

Line 1070: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1066: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1067: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1068:
1069: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1070: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1071:
1072:
1073: x_return_status VARCHAR2(1);
1074: x_return_status_text VARCHAR2(240);

Line 1131: ,p_item_tbl IN JTF_NUMBER_TABLE

1127: -- 2.e [using qp] get prices for a list of items based on price_list_id
1128: PROCEDURE GetPrices(
1129: p_price_list_id IN NUMBER
1130: ,p_currency_code IN VARCHAR2
1131: ,p_item_tbl IN JTF_NUMBER_TABLE
1132: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1133: -- ,p_calculate_flag IN CHAR(1) :='Y'
1134: ,p_request_type_code IN VARCHAR2
1135: ,p_pricing_event IN VARCHAR2

Line 1136: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

1132: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1133: -- ,p_calculate_flag IN CHAR(1) :='Y'
1134: ,p_request_type_code IN VARCHAR2
1135: ,p_pricing_event IN VARCHAR2
1136: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1137: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1138: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1139: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1140: ,x_return_status out nocopy varchar2

Line 1137: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

1133: -- ,p_calculate_flag IN CHAR(1) :='Y'
1134: ,p_request_type_code IN VARCHAR2
1135: ,p_pricing_event IN VARCHAR2
1136: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1137: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1138: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1139: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1140: ,x_return_status out nocopy varchar2
1141: ,x_return_status_text out nocopy varchar2

Line 1147: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1143: )
1144: IS
1145: l_version VARCHAR2(240);
1146:
1147: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1148: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1149:
1150: BEGIN
1151: getpricesfromqp(

Line 1148: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1144: IS
1145: l_version VARCHAR2(240);
1146:
1147: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1148: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1149:
1150: BEGIN
1151: getpricesfromqp(
1152: p_price_list_id => p_price_list_id,

Line 1174: ,p_item_tbl IN JTF_NUMBER_TABLE

1170: PROCEDURE GetPrices(
1171: p_party_id IN NUMBER
1172: ,p_cust_account_id IN number
1173: ,p_currency_code IN VARCHAR2
1174: ,p_item_tbl IN JTF_NUMBER_TABLE
1175: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1176: -- ,p_calculate_flag IN CHAR(1) :='Y'
1177: ,p_request_type_code IN VARCHAR2
1178: ,p_pricing_event IN VARCHAR2

Line 1179: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

1175: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1176: -- ,p_calculate_flag IN CHAR(1) :='Y'
1177: ,p_request_type_code IN VARCHAR2
1178: ,p_pricing_event IN VARCHAR2
1179: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1180: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1181: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1182: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1183: ,x_return_status out nocopy varchar2

Line 1180: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

1176: -- ,p_calculate_flag IN CHAR(1) :='Y'
1177: ,p_request_type_code IN VARCHAR2
1178: ,p_pricing_event IN VARCHAR2
1179: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1180: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1181: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1182: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1183: ,x_return_status out nocopy varchar2
1184: ,x_return_status_text out nocopy varchar2

Line 1188: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1184: ,x_return_status_text out nocopy varchar2
1185:
1186: )
1187: IS
1188: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1189: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1190:
1191: BEGIN
1192: getpricesfromqp(

Line 1189: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1185:
1186: )
1187: IS
1188: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1189: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1190:
1191: BEGIN
1192: getpricesfromqp(
1193: p_party_id => p_party_id,

Line 1219: ,p_item_tbl IN JTF_NUMBER_TABLE

1215: p_price_list_id IN NUMBER
1216: ,p_party_id IN NUMBER
1217: ,p_cust_account_id IN number
1218: ,p_currency_code IN VARCHAR2
1219: ,p_item_tbl IN JTF_NUMBER_TABLE
1220: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1221: -- ,p_calculate_flag IN CHAR(1) :='Y'
1222: ,p_request_type_code IN VARCHAR2
1223: ,p_pricing_event IN VARCHAR2

Line 1224: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

1220: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1221: -- ,p_calculate_flag IN CHAR(1) :='Y'
1222: ,p_request_type_code IN VARCHAR2
1223: ,p_pricing_event IN VARCHAR2
1224: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1225: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1226: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1227: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1228: ,x_return_status out nocopy varchar2

Line 1225: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

1221: -- ,p_calculate_flag IN CHAR(1) :='Y'
1222: ,p_request_type_code IN VARCHAR2
1223: ,p_pricing_event IN VARCHAR2
1224: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1225: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1226: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1227: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1228: ,x_return_status out nocopy varchar2
1229: ,x_return_status_text out nocopy varchar2

Line 1233: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1229: ,x_return_status_text out nocopy varchar2
1230:
1231: )
1232: IS
1233: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1234: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1235:
1236: BEGIN
1237: getpricesfromqp(

Line 1234: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1230:
1231: )
1232: IS
1233: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1234: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1235:
1236: BEGIN
1237: getpricesfromqp(
1238: p_price_list_id => p_price_list_id,

Line 1263: ,p_item_tbl IN JTF_NUMBER_TABLE

1259: -- 2.g [using qp] get prices of a list of items based on price_list_id for service support
1260: PROCEDURE GetPrices(
1261: p_price_list_id IN NUMBER
1262: ,p_currency_code IN VARCHAR2
1263: ,p_item_tbl IN JTF_NUMBER_TABLE
1264: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1265: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1266: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1267: -- ,p_calculate_flag IN CHAR(1) :='Y'

Line 1265: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE

1261: p_price_list_id IN NUMBER
1262: ,p_currency_code IN VARCHAR2
1263: ,p_item_tbl IN JTF_NUMBER_TABLE
1264: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1265: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1266: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1267: -- ,p_calculate_flag IN CHAR(1) :='Y'
1268: ,p_request_type_code IN VARCHAR2
1269: ,p_pricing_event IN VARCHAR2

Line 1266: ,p_childIndex_tbl IN JTF_NUMBER_TABLE

1262: ,p_currency_code IN VARCHAR2
1263: ,p_item_tbl IN JTF_NUMBER_TABLE
1264: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1265: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1266: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1267: -- ,p_calculate_flag IN CHAR(1) :='Y'
1268: ,p_request_type_code IN VARCHAR2
1269: ,p_pricing_event IN VARCHAR2
1270: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 1270: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

1266: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1267: -- ,p_calculate_flag IN CHAR(1) :='Y'
1268: ,p_request_type_code IN VARCHAR2
1269: ,p_pricing_event IN VARCHAR2
1270: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1271: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1272: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1273: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1274: ,x_parentIndex_tbl out nocopy JTF_NUMBER_TABLE

Line 1271: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

1267: -- ,p_calculate_flag IN CHAR(1) :='Y'
1268: ,p_request_type_code IN VARCHAR2
1269: ,p_pricing_event IN VARCHAR2
1270: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1271: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1272: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1273: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1274: ,x_parentIndex_tbl out nocopy JTF_NUMBER_TABLE
1275: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE

Line 1274: ,x_parentIndex_tbl out nocopy JTF_NUMBER_TABLE

1270: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1271: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1272: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1273: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1274: ,x_parentIndex_tbl out nocopy JTF_NUMBER_TABLE
1275: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE
1276: ,x_return_status out nocopy varchar2
1277: ,x_return_status_text out nocopy varchar2
1278: )

Line 1275: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE

1271: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1272: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1273: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1274: ,x_parentIndex_tbl out nocopy JTF_NUMBER_TABLE
1275: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE
1276: ,x_return_status out nocopy varchar2
1277: ,x_return_status_text out nocopy varchar2
1278: )
1279: IS

Line 1310: ,p_item_tbl IN JTF_NUMBER_TABLE

1306: PROCEDURE GetPrices(
1307: p_party_id IN NUMBER
1308: ,p_cust_account_id IN number
1309: ,p_currency_code IN VARCHAR2
1310: ,p_item_tbl IN JTF_NUMBER_TABLE
1311: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1312: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1313: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1314: -- ,p_calculate_flag IN CHAR(1) :='Y'

Line 1312: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE

1308: ,p_cust_account_id IN number
1309: ,p_currency_code IN VARCHAR2
1310: ,p_item_tbl IN JTF_NUMBER_TABLE
1311: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1312: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1313: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1314: -- ,p_calculate_flag IN CHAR(1) :='Y'
1315: ,p_request_type_code IN VARCHAR2
1316: ,p_pricing_event IN VARCHAR2

Line 1313: ,p_childIndex_tbl IN JTF_NUMBER_TABLE

1309: ,p_currency_code IN VARCHAR2
1310: ,p_item_tbl IN JTF_NUMBER_TABLE
1311: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1312: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1313: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1314: -- ,p_calculate_flag IN CHAR(1) :='Y'
1315: ,p_request_type_code IN VARCHAR2
1316: ,p_pricing_event IN VARCHAR2
1317: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 1317: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

1313: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1314: -- ,p_calculate_flag IN CHAR(1) :='Y'
1315: ,p_request_type_code IN VARCHAR2
1316: ,p_pricing_event IN VARCHAR2
1317: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1318: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1319: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1320: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1321: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE

Line 1318: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

1314: -- ,p_calculate_flag IN CHAR(1) :='Y'
1315: ,p_request_type_code IN VARCHAR2
1316: ,p_pricing_event IN VARCHAR2
1317: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1318: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1319: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1320: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1321: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1322: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE

Line 1321: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE

1317: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1318: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1319: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1320: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1321: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1322: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1323: ,x_return_status out nocopy varchar2
1324: ,x_return_status_text out nocopy varchar2
1325:

Line 1322: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE

1318: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1319: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1320: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1321: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1322: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1323: ,x_return_status out nocopy varchar2
1324: ,x_return_status_text out nocopy varchar2
1325:
1326: )

Line 1359: ,p_item_tbl IN JTF_NUMBER_TABLE

1355: p_price_list_id IN NUMBER
1356: ,p_party_id IN NUMBER
1357: ,p_cust_account_id IN number
1358: ,p_currency_code IN VARCHAR2
1359: ,p_item_tbl IN JTF_NUMBER_TABLE
1360: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1361: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1362: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1363: -- ,p_calculate_flag IN CHAR(1) :='Y'

Line 1361: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE

1357: ,p_cust_account_id IN number
1358: ,p_currency_code IN VARCHAR2
1359: ,p_item_tbl IN JTF_NUMBER_TABLE
1360: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1361: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1362: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1363: -- ,p_calculate_flag IN CHAR(1) :='Y'
1364: ,p_request_type_code IN VARCHAR2
1365: ,p_pricing_event IN VARCHAR2

Line 1362: ,p_childIndex_tbl IN JTF_NUMBER_TABLE

1358: ,p_currency_code IN VARCHAR2
1359: ,p_item_tbl IN JTF_NUMBER_TABLE
1360: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1361: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1362: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1363: -- ,p_calculate_flag IN CHAR(1) :='Y'
1364: ,p_request_type_code IN VARCHAR2
1365: ,p_pricing_event IN VARCHAR2
1366: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 1366: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

1362: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1363: -- ,p_calculate_flag IN CHAR(1) :='Y'
1364: ,p_request_type_code IN VARCHAR2
1365: ,p_pricing_event IN VARCHAR2
1366: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1367: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1368: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1369: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1370: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE

Line 1367: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

1363: -- ,p_calculate_flag IN CHAR(1) :='Y'
1364: ,p_request_type_code IN VARCHAR2
1365: ,p_pricing_event IN VARCHAR2
1366: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1367: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1368: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1369: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1370: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1371: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE

Line 1370: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE

1366: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1367: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1368: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1369: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1370: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1371: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1372: ,x_return_status out nocopy varchar2
1373: ,x_return_status_text out nocopy varchar2
1374:

Line 1371: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE

1367: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1368: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1369: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1370: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1371: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1372: ,x_return_status out nocopy varchar2
1373: ,x_return_status_text out nocopy varchar2
1374:
1375: )