DBA Data[Home] [Help]

APPS.IBE_PRICE_PVT dependencies on JTF_VARCHAR2_TABLE_300

Line 533: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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

Line 684: x_status_text_tbl := JTF_VARCHAR2_TABLE_300();

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:

Line 755: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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

Line 774: l_sub_status_text_tbl JTF_VARCHAR2_TABLE_300;

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:

Line 1030: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

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:

Line 1117: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

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:

Line 1207: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

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:

Line 1307: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

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:

Line 1425: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

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:

Line 1546: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

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:

Line 1649: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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

Line 1714: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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

Line 1781: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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

Line 1849: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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

Line 1918: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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

Line 1989: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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