APPS.PON_AUCTION_PO_PKG dependencies on PON_BID_PRICE_ELEMENTS

Line 613: x_bidValue pon_bid_price_elements.bid_currency_value%TYPE;

609: tab varchar2(256);
610: x_item_description pon_auction_item_prices_all.item_description%TYPE;
611: x_has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE;
612: x_price_element_name pon_price_element_types_tl.name%TYPE;
613: x_bidValue pon_bid_price_elements.bid_currency_value%TYPE;
614: x_negative_cost_factor_flag pon_bid_price_elements.NEGATIVE_COST_FACTOR_FLAG%TYPE;
615: x_pricing_basis_display varchar2(2000);
616: x_msg_suffix VARCHAR2(3) := '';
617: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

Line 614: x_negative_cost_factor_flag pon_bid_price_elements.NEGATIVE_COST_FACTOR_FLAG%TYPE;

610: x_item_description pon_auction_item_prices_all.item_description%TYPE;
611: x_has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE;
612: x_price_element_name pon_price_element_types_tl.name%TYPE;
613: x_bidValue pon_bid_price_elements.bid_currency_value%TYPE;
614: x_negative_cost_factor_flag pon_bid_price_elements.NEGATIVE_COST_FACTOR_FLAG%TYPE;
615: x_pricing_basis_display varchar2(2000);
616: x_msg_suffix VARCHAR2(3) := '';
617: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
618:

Line 625: FROM pon_bid_price_elements pbpe, pon_price_element_types_tl ppet, fnd_lookup_values flv

621: SELECT ppet.name,
622: flv.meaning,
623: pbpe.bid_currency_value,
624: pbpe.NEGATIVE_COST_FACTOR_FLAG
625: FROM pon_bid_price_elements pbpe, pon_price_element_types_tl ppet, fnd_lookup_values flv
626: WHERE pbpe.bid_number = p_bid_number and
627: pbpe.auction_header_id = p_auction_header_id and
628: pbpe.line_number = p_line_number and
629: pbpe.price_element_type_id <> -10 and