529: ,p_pricing_event IN VARCHAR2
530: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
531: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
532: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
533: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
534: ,x_parentIndex_tbl OUT nocopy JTF_NUMBER_TABLE
535: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE
536: ,x_return_status out nocopy varchar2
537: ,x_return_status_text out nocopy varchar2
680:
681: x_listprice_tbl := JTF_NUMBER_TABLE();
682: x_bestprice_tbl := JTF_NUMBER_TABLE();
683: x_status_code_tbl := JTF_VARCHAR2_TABLE_100();
684: x_status_text_tbl := JTF_VARCHAR2_TABLE_300();
685:
686: x_parentIndex_tbl := JTF_NUMBER_TABLE();
687: x_childIndex_tbl := JTF_NUMBER_TABLE();
688:
751: ,p_pricing_event IN VARCHAR2
752: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
753: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
754: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
755: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
756: ,x_parentIndex_tbl OUT nocopy JTF_NUMBER_TABLE
757: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE
758: ,x_return_status out nocopy varchar2
759: ,x_return_status_text out nocopy varchar2
770: l_sub_listprice_tbl JTF_NUMBER_TABLE;
771: l_sub_bestprice_tbl JTF_NUMBER_TABLE;
772:
773: l_sub_status_code_tbl JTF_VARCHAR2_TABLE_100;
774: l_sub_status_text_tbl JTF_VARCHAR2_TABLE_300;
775:
776: l_sub_parentIndex_tbl JTF_NUMBER_TABLE;
777: l_sub_childIndex_tbl JTF_NUMBER_TABLE;
778:
1026: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1027: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1028: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1029: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1030: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1031:
1032: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1033: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1034:
1113: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1114: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1115: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1116: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1117: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1118:
1119: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1120: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1121:
1203: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1204: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1205: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1206: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1207: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1208:
1209: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1210: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1211:
1303: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1304: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1305: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1306: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1307: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1308:
1309: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1310: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1311:
1421: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1422: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1423: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1424: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1425: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1426:
1427: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1428: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1429:
1542: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1543: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1544: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1545: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1546: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1547:
1548: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1549: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1550:
1645: ,p_pricing_event IN VARCHAR2
1646: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1647: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1648: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1649: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1650: ,x_return_status out nocopy varchar2
1651: ,x_return_status_text out nocopy varchar2
1652:
1653: )
1710: ,p_pricing_event IN VARCHAR2
1711: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1712: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1713: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1714: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1715: ,x_return_status out nocopy varchar2
1716: ,x_return_status_text out nocopy varchar2
1717:
1718: )
1777: ,p_pricing_event IN VARCHAR2
1778: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1779: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1780: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1781: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1782: ,x_return_status out nocopy varchar2
1783: ,x_return_status_text out nocopy varchar2
1784:
1785: )
1845: ,p_pricing_event IN VARCHAR2
1846: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1847: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1848: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1849: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1850: ,x_parentIndex_tbl out nocopy JTF_NUMBER_TABLE
1851: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE
1852: ,x_return_status out nocopy varchar2
1853: ,x_return_status_text out nocopy varchar2
1914: ,p_pricing_event IN VARCHAR2
1915: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1916: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1917: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1918: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1919: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1920: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1921: ,x_return_status out nocopy varchar2
1922: ,x_return_status_text out nocopy varchar2
1985: ,p_pricing_event IN VARCHAR2
1986: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1987: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1988: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1989: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1990: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1991: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1992: ,x_return_status out nocopy varchar2
1993: ,x_return_status_text out nocopy varchar2