[Home] [Help]
366: -- if price tiers indicator is not equal to either price breaks
367: -- or price tiers we don't have to proceed with the shipments
368: IF(v_price_tiers_indicator = g_price_breaks or v_price_tiers_indicator = g_quantity_based) THEN
369:
370: UPDATE pon_bid_shipments pbs
371: SET pbs.bid_currency_unit_price =
372: DECODE(pbs.price_type,
373: 'PRICE', round(pbs.bid_currency_price * (1 - p_power_percentage/100), v_precision),
374: round((SELECT pbip.bid_currency_unit_price
395: AND pbs.line_number >= v_batch_start
396: AND pbs.line_number <= v_batch_end;
397: -- AND pbs.shipment_type = 'PRICE BREAK';
398:
399: UPDATE pon_bid_shipments pbs
400: SET pbs.bid_currency_price = pbs.bid_currency_unit_price,
401: pbs.unit_price = pbs.bid_currency_unit_price / v_rate,
402: pbs.price = pbs.bid_currency_unit_price / v_rate
403: WHERE pbs.bid_number = p_bid_number
743: -- NOTE: does not apply for spreadsheet upload, only if currency changed
744: --comment this out for price tier: IF (v_contract_type <> 'STANDARD') THEN
745:
746: -- (1) apply BPF formula
747: UPDATE pon_bid_shipments pbs
748: SET pbs.bid_currency_price = nvl(
749: (SELECT (pbs.bid_currency_unit_price * ppsf.percentage) +
750: ppsf.unit_price*v_rate +
751: (ppsf.fixed_amount*v_rate / decode(v_is_spo_transformed,
770: AND pbs.line_number <= v_batch_end;
771:
772:
773: -- (2) apply SPF values
774: UPDATE pon_bid_shipments pbs
775: SET pbs.bid_currency_price =
776: (SELECT pbs.bid_currency_price +
777: nvl(sum(decode(spf.pricing_basis,
778: 'PER_UNIT', spf.bid_currency_value,
805: -- * price: recalculate from untruncated
806: -- bid_currency_price. (not rounded)
807: -- * bid_currency_price: truncate the untruncated
808: -- bid_currency_price
809: UPDATE pon_bid_shipments pbs
810: SET pbs.unit_price = pbs.bid_currency_unit_price / v_rate,
811: pbs.price = pbs.bid_currency_price / v_rate,
812: pbs.bid_currency_price = DECODE(v_supplier_view_type,
813: 'TRANSFORMED', round(pbs.bid_currency_price, v_precision),
1323:
1324:
1325: -- remove:
1326: -- 1) shipments for lines with hasBid=N
1327: DELETE FROM pon_bid_shipments pbs
1328: WHERE pbs.bid_number = p_bid_number
1329: AND EXISTS (SELECT null
1330: FROM pon_bid_item_prices pbip
1331: WHERE pbip.bid_number = pbs.bid_number