DBA Data[Home] [Help]

APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_DEPRN_EVENTS

Line 368: update fa_deprn_events

364: and ds.period_counter = p_period_rec.period_counter
365: and ds.deprn_source_code in ('D','T');
366:
367: -- flag the header table too
368: update fa_deprn_events
369: set reversal_event_id = P_REVERSAL_EVENT_ID,
370: reversal_date = p_reversal_date
371: where asset_id = p_asset_hdr_rec.asset_id
372: and book_type_code = p_asset_hdr_rec.book_type_code

Line 378: delete from fa_deprn_events

374: and deprn_run_id = p_deprn_run_id;
375:
376: end if;
377: else -- event was not final -0 need to delete the dpern event
378: delete from fa_deprn_events
379: where asset_id = p_asset_hdr_rec.asset_id
380: and book_type_code = p_asset_hdr_rec.book_type_code
381: and period_counter = p_period_rec.period_counter
382: and reversal_event_id is null;