[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
750: -- NOTE: does not apply for spreadsheet upload, only if currency changed
751: --comment this out for price tier: IF (v_contract_type <> 'STANDARD') THEN
752:
753: -- (1) apply BPF formula
754: UPDATE pon_bid_shipments pbs
755: SET pbs.bid_currency_price = nvl(
756: (SELECT (pbs.bid_currency_unit_price * ppsf.percentage) +
757: ppsf.unit_price*v_rate +
758: (ppsf.fixed_amount*v_rate / decode(v_is_spo_transformed,
777: AND pbs.line_number <= v_batch_end;
778:
779:
780: -- (2) apply SPF values
781: UPDATE pon_bid_shipments pbs
782: SET pbs.bid_currency_price =
783: (SELECT pbs.bid_currency_price +
784: nvl(sum(decode(spf.pricing_basis,
785: 'PER_UNIT', spf.bid_currency_value,
812: -- * price: recalculate from untruncated
813: -- bid_currency_price. (not rounded)
814: -- * bid_currency_price: truncate the untruncated
815: -- bid_currency_price
816: UPDATE pon_bid_shipments pbs
817: SET pbs.unit_price = pbs.bid_currency_unit_price / v_rate,
818: pbs.price = pbs.bid_currency_price / v_rate,
819: pbs.bid_currency_price = DECODE(v_supplier_view_type,
820: 'TRANSFORMED', round(pbs.bid_currency_price, v_precision),
1504:
1505:
1506: -- remove:
1507: -- 1) shipments for lines with hasBid=N
1508: DELETE FROM pon_bid_shipments pbs
1509: WHERE pbs.bid_number = p_bid_number
1510: AND EXISTS (SELECT null
1511: FROM pon_bid_item_prices pbip
1512: WHERE pbip.bid_number = pbs.bid_number