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 744: --comment this out for price tier: IF (v_contract_type <> 'STANDARD') THEN

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

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

820:
821: -- RECALCULATE PAYMENT PRICES
822: -- Since Payments values are not tranformed ever, we can directly multiply by rate
823:
824: IF (p_curr_changed = 'Y' AND v_contract_type = 'STANDARD' AND v_progress_payment_type <> 'NONE' ) THEN
825:
826: UPDATE pon_bid_payments_shipments pbps
827: SET pbps.price = pbps.bid_currency_price / v_rate
828: