APPS.PON_TRANSFORM_BIDDING_PKG dependencies on STANDARD

Line 197: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *

193:
194: IF (p_supplier_view_type = 'TRANSFORMED') THEN
195:
196: SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,
197: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
198: nvl(pbip.price,0)) bid_total
199: INTO v_bid_total
200: FROM pon_bid_item_prices pbip,
201: pon_auction_item_prices_all paip

Line 212: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *

208:
209: ELSE -- UNTRANSFORMED
210:
211: SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,
212: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
213: nvl(untransform_one_price(paip.auction_header_id, paip.line_number, pbip.price,
214: paip.quantity, p_tpid, p_site),0)) bid_total
215: INTO v_bid_total
216: FROM pon_bid_item_prices pbip,

Line 872: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *

868:
869:
870:
871: SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,
872: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
873: nvl(pbip.price,0)) bid_total
874: INTO v_bid_total
875: FROM pon_bid_item_prices pbip,
876: pon_auction_item_prices_all paip

Line 893: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *

889:
890:
891:
892: SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,
893: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
894: nvl(untransform_one_price(paip.auction_header_id, paip.line_number, pbip.price,
895: paip.quantity, p_tpid, p_site),0)) bid_total
896: INTO v_bid_total
897: FROM pon_bid_item_prices pbip,