DBA Data[Home] [Help]

APPS.PON_TRANSFORM_BIDDING_PKG dependencies on STANDARD

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

143:
144: IF (p_supplier_view_type = 'TRANSFORMED') THEN
145:
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

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

158:
159: ELSE -- UNTRANSFORMED
160:
161: SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,
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,