APPS.AMS_RUNTIME_PROD_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 1529: AND PA.product_attr_value IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_in_prod_lst AS JTF_VARCHAR2_TABLE_100)) t)';

1525: FROM qp_list_lines PL,
1526: qp_pricing_attributes PA
1527: WHERE PA.list_header_id = :price_list_id
1528: AND PL.list_line_id = PA.list_line_id
1529: AND PA.product_attr_value IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_in_prod_lst AS JTF_VARCHAR2_TABLE_100)) t)';
1530:
1531:
1532: l_return_status VARCHAR2( 10 );
1533: l_msg_count NUMBER;

Line 1544: p_in_prod_lst JTF_VARCHAR2_TABLE_100;

1540: ll_index BINARY_INTEGER;
1541: i PLS_INTEGER := 1;
1542: j PLS_INTEGER := 1;
1543: found BOOLEAN;
1544: p_in_prod_lst JTF_VARCHAR2_TABLE_100;
1545:
1546: BEGIN
1547: -- Standard call to check for call compatibility.
1548: IF NOT FND_API.Compatible_API_Call( l_api_version,

Line 1579: p_in_prod_lst := JTF_VARCHAR2_TABLE_100();

1575: AMS_UTILITY_PVT.debug_message('Order of Sorting is : '||l_order);
1576: END IF;
1577:
1578: x_prod_lst := JTF_Number_Table();
1579: p_in_prod_lst := JTF_VARCHAR2_TABLE_100();
1580:
1581: IF(p_bus_prior = 'PROD_LIST_PRICE' AND p_price_list_id IS NOT NULL AND p_prod_lst.COUNT > 1) THEN
1582: IF (AMS_DEBUG_HIGH_ON) THEN
1583:

Line 1765: x_price_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100,

1761: x_item_csr OUT NOCOPY prod_cursor,
1762: x_category_id_csr OUT NOCOPY prod_cursor,
1763: x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE,
1764: x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE,
1765: x_price_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100,
1766: x_price_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300,
1767: x_price_return_status OUT NOCOPY VARCHAR2,
1768: x_price_return_status_text OUT NOCOPY VARCHAR2,
1769: x_item_return_status OUT NOCOPY VARCHAR2,

Line 1812: l_uomcode_tbl JTF_VARCHAR2_TABLE_100;

1808: l_itmid_tbl JTF_NUMBER_TABLE;
1809: l_index BINARY_INTEGER;
1810: l_itmid NUMBER;
1811: l_uomcode VARCHAR2(3);
1812: l_uomcode_tbl JTF_VARCHAR2_TABLE_100;
1813:
1814: BEGIN
1815: -- Standard call to check for call compatibility.
1816: IF NOT FND_API.Compatible_API_Call( l_api_version,

Line 1874: l_uomcode_tbl := JTF_VARCHAR2_TABLE_100();

1870:
1871: -- calls pricing engine APIs if retrieve price is true
1872: IF FND_API.to_Boolean(p_retrieve_price) THEN
1873:
1874: l_uomcode_tbl := JTF_VARCHAR2_TABLE_100();
1875:
1876: FOR l_Index IN 1..p_itmid_tbl.COUNT LOOP
1877:
1878: --opens uom cursor to build uom table