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.

APPS.PON_RESPONSE_PVT dependencies on PON_BID_PAYMENTS_SHIPMENTS

Line 833: UPDATE pon_bid_payments_shipments pbps

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

Line 1520: DELETE FROM pon_bid_payments_shipments pbps

1516: AND pbs.line_number <= p_batch_end;
1517:
1518: -- remove:
1519: -- 1) Payments for lines with hasBid=N
1520: DELETE FROM pon_bid_payments_shipments pbps
1521: WHERE pbps.bid_number = p_bid_number
1522: AND EXISTS (SELECT null
1523: FROM pon_bid_item_prices pbip
1524: WHERE pbip.bid_number = pbps.bid_number