APPS.PON_TRANSFORM_BIDDING_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 99: pon_auction_item_prices_all paip

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
103: pbip.auction_header_id = paip.auction_header_id AND

Line 151: pon_auction_item_prices_all paip

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
155: pbip.auction_header_id = paip.auction_header_id AND

Line 167: pon_auction_item_prices_all paip

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
171: pbip.auction_header_id = paip.auction_header_id AND

Line 427: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,

423: -- ------------------------------------------------------------------------
424:
425: FUNCTION calculate_quote_amount
426: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
427: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
428: p_bid_number IN pon_bid_headers.bid_number%TYPE,
429: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
430: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
431: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

Line 436: v_group_type pon_auction_item_prices_all.group_type%TYPE;

432: p_site IN pon_bid_headers.vendor_site_id%TYPE)
433: RETURN NUMBER
434: IS
435: v_quote_amount NUMBER;
436: v_group_type pon_auction_item_prices_all.group_type%TYPE;
437: BEGIN
438: SELECT group_type
439: INTO v_group_type
440: FROM pon_auction_item_prices_all

Line 440: FROM pon_auction_item_prices_all

436: v_group_type pon_auction_item_prices_all.group_type%TYPE;
437: BEGIN
438: SELECT group_type
439: INTO v_group_type
440: FROM pon_auction_item_prices_all
441: WHERE auction_header_id = p_auction_header_id
442: AND line_number = p_line_number;
443:
444: -- Transformed View: no need to reverse-transform prices

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;