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.PON_CONSOLE_PVT dependencies on PON_BID_ITEM_PRICES

Line 1456: TYPE line_number_tbl_type IS TABLE OF pon_bid_item_prices.line_number%TYPE;

1452: x_no_bid_lines OUT NOCOPY NUMBER
1453: )
1454: IS
1455:
1456: TYPE line_number_tbl_type IS TABLE OF pon_bid_item_prices.line_number%TYPE;
1457: TYPE bid_price_tbl_type IS TABLE OF pon_bid_item_prices.price%TYPE;
1458: TYPE bid_qty_tbl_type IS TABLE OF pon_bid_item_prices.quantity%TYPE;
1459: TYPE current_price_tbl_type IS TABLE OF pon_auction_item_prices_all.current_price%TYPE;
1460: TYPE auction_qty_tbl_type IS TABLE OF pon_auction_item_prices_all.quantity%TYPE;

Line 1457: TYPE bid_price_tbl_type IS TABLE OF pon_bid_item_prices.price%TYPE;

1453: )
1454: IS
1455:
1456: TYPE line_number_tbl_type IS TABLE OF pon_bid_item_prices.line_number%TYPE;
1457: TYPE bid_price_tbl_type IS TABLE OF pon_bid_item_prices.price%TYPE;
1458: TYPE bid_qty_tbl_type IS TABLE OF pon_bid_item_prices.quantity%TYPE;
1459: TYPE current_price_tbl_type IS TABLE OF pon_auction_item_prices_all.current_price%TYPE;
1460: TYPE auction_qty_tbl_type IS TABLE OF pon_auction_item_prices_all.quantity%TYPE;
1461:

Line 1458: TYPE bid_qty_tbl_type IS TABLE OF pon_bid_item_prices.quantity%TYPE;

1454: IS
1455:
1456: TYPE line_number_tbl_type IS TABLE OF pon_bid_item_prices.line_number%TYPE;
1457: TYPE bid_price_tbl_type IS TABLE OF pon_bid_item_prices.price%TYPE;
1458: TYPE bid_qty_tbl_type IS TABLE OF pon_bid_item_prices.quantity%TYPE;
1459: TYPE current_price_tbl_type IS TABLE OF pon_auction_item_prices_all.current_price%TYPE;
1460: TYPE auction_qty_tbl_type IS TABLE OF pon_auction_item_prices_all.quantity%TYPE;
1461:
1462: l_line_number_tbl line_number_tbl_type;

Line 1467: l_line_number PON_BID_ITEM_PRICES.line_number%TYPE;

1463: l_bid_price_tbl bid_price_tbl_type;
1464: l_bid_qty_tbl bid_qty_tbl_type;
1465: l_current_price_tbl current_price_tbl_type;
1466: l_auction_qty_tbl auction_qty_tbl_type;
1467: l_line_number PON_BID_ITEM_PRICES.line_number%TYPE;
1468: l_qty_remaining NUMBER;
1469: l_current_value NUMBER := 0;
1470: l_optimal_value NUMBER := 0;
1471: l_no_bid_lines NUMBER := 0;

Line 1515: pon_bid_item_prices bl,

1511: ai.current_price,
1512: nvl(ai.quantity,1) auction_qty
1513: BULK COLLECT INTO l_line_number_tbl, l_bid_price_tbl, l_bid_qty_tbl, l_current_price_tbl, l_auction_qty_tbl
1514: FROM pon_bid_headers bh,
1515: pon_bid_item_prices bl,
1516: pon_auction_headers_all ah,
1517: pon_auction_item_prices_all ai
1518: WHERE ah.auction_header_id = bh.auction_header_id
1519: and bh.auction_header_id = bl.auction_header_id