eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PON_RESPONSE_PVT dependencies on PON_BID_PAYMENTS_SHIPMENTS

Line 826: UPDATE pon_bid_payments_shipments pbps

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:
829: WHERE pbps.bid_number = p_bid_number
830: AND pbps.bid_line_number >= v_batch_start

Line 1339: DELETE FROM pon_bid_payments_shipments pbps

1335: AND pbs.line_number <= p_batch_end;
1336:
1337: -- remove:
1338: -- 1) Payments for lines with hasBid=N
1339: DELETE FROM pon_bid_payments_shipments pbps
1340: WHERE pbps.bid_number = p_bid_number
1341: AND EXISTS (SELECT null
1342: FROM pon_bid_item_prices pbip
1343: WHERE pbip.bid_number = pbps.bid_number