APPS.PON_TRANSFORM_BIDDING_PKG dependencies on PON_BID_ITEM_PRICES

Line 98: FROM pon_bid_item_prices pbip,

94: SELECT 'N'
95: INTO v_has_est_qty_on_all_bid_lines
96: FROM dual
97: WHERE EXISTS (SELECT null
98: FROM pon_bid_item_prices pbip,
99: pon_auction_item_prices_all paip
100: WHERE pbip.auction_header_id = p_auction_header_id AND
101: pbip.bid_number = p_bid_number AND
102: nvl(pbip.has_bid_flag, 'N') = 'Y' AND

Line 150: FROM pon_bid_item_prices pbip,

146: SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,
147: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
148: nvl(pbip.price,0)) bid_total
149: INTO v_bid_total
150: FROM pon_bid_item_prices pbip,
151: pon_auction_item_prices_all paip
152: WHERE pbip.auction_header_id = p_auction_header_id AND
153: pbip.bid_number = p_bid_number AND
154: nvl(pbip.has_bid_flag, 'N') = 'Y' AND

Line 166: FROM pon_bid_item_prices pbip,

162: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
163: nvl(untransform_one_price(paip.auction_header_id, paip.line_number, pbip.price,
164: paip.quantity, p_tpid, p_site),0)) bid_total
165: INTO v_bid_total
166: FROM pon_bid_item_prices pbip,
167: pon_auction_item_prices_all paip
168: WHERE pbip.auction_header_id = p_auction_header_id AND
169: pbip.bid_number = p_bid_number AND
170: nvl(pbip.has_bid_flag, 'N') = 'Y' AND

Line 453: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

449:
450: SELECT DECODE (al.group_type, 'GROUP', bl.group_amount,
451: nvl(bl.quantity, decode(al.ORDER_TYPE_LOOKUP_CODE, 'FIXED PRICE', 1, al.quantity)) * bl.price)
452: INTO v_quote_amount
453: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
454: WHERE bl.bid_number = p_bid_number
455: AND bl.line_number = p_line_number
456: AND bl.auction_header_id = al.auction_header_id
457: AND bl.line_number = al.line_number;

Line 473: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

469: nvl(bl.quantity, decode(al.ORDER_TYPE_LOOKUP_CODE, 'FIXED PRICE', 1, al.quantity))
470: * nvl(PON_TRANSFORM_BIDDING_PKG.untransform_one_price(p_auction_header_id,
471: bl.line_number, bl.price, al.quantity, p_tpid, p_site), 0)
472: INTO v_quote_amount
473: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
474: WHERE bl.bid_number = p_bid_number
475: AND bl.line_number = p_line_number
476: AND al.auction_header_id = bl.auction_header_id
477: AND al.line_number = bl.line_number;