APPS.PON_RESPONSE_PVT dependencies on STANDARD

Line 168: 'STANDARD', p2.quantity,

164: p2.price) *
165: decode(a1.order_type_lookup_code,
166: 'FIXED PRICE', 1,
167: decode(v_contract_type,
168: 'STANDARD', p2.quantity,
169: nvl(p2.quantity, a1.quantity))))
170: FROM pon_bid_item_prices p2,
171: pon_auction_item_prices_all a1
172: WHERE p2.bid_number = p_bid_number

Line 244: 'STANDARD', group_line.quantity,

240: group_line.price) *
241: decode(auc_line.order_type_lookup_code,
242: 'FIXED PRICE', 1,
243: decode(v_contract_type,
244: 'STANDARD', group_line.quantity,
245: nvl(group_line.quantity, auc_line.quantity))))
246: INTO p_group_amount
247: FROM pon_bid_item_prices groups,
248: pon_bid_item_prices group_line,

Line 591: v_contract_type = 'STANDARD') THEN

587: -- pon_bid_price_elements table and adding to the result of (1)
588:
589: -- first, calculate v_is_spo_transformed flag
590: IF (v_supplier_view_type = 'TRANSFORMED' AND
591: v_contract_type = 'STANDARD') THEN
592: v_is_spo_transformed := 'Y';
593: ELSE
594: v_is_spo_transformed := 'N';
595: END IF;

Line 751: --comment this out for price tier: IF (v_contract_type <> 'STANDARD') THEN

747: -- (2) apply SPF values by summing up all applicable SPF values from
748: -- pon_bid_price_elements table and adding to the result of (1)
749:
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(

Line 831: IF (p_curr_changed = 'Y' AND v_contract_type = 'STANDARD' AND v_progress_payment_type <> 'NONE' ) THEN

827:
828: -- RECALCULATE PAYMENT PRICES
829: -- Since Payments values are not tranformed ever, we can directly multiply by rate
830:
831: IF (p_curr_changed = 'Y' AND v_contract_type = 'STANDARD' AND v_progress_payment_type <> 'NONE' ) THEN
832:
833: UPDATE pon_bid_payments_shipments pbps
834: SET pbps.price = pbps.bid_currency_price / v_rate
835: