APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_DEPRN_EVENTS

Line 461: update fa_deprn_events

457: and ds.period_counter = p_period_rec.period_counter
458: and ds.deprn_source_code in ('D','T');
459:
460: -- flag the header table too
461: update fa_deprn_events
462: set reversal_event_id = P_REVERSAL_EVENT_ID,
463: reversal_date = p_reversal_date
464: where asset_id = p_asset_hdr_rec.asset_id
465: and book_type_code = p_asset_hdr_rec.book_type_code

Line 471: delete from fa_deprn_events

467: and deprn_run_id = p_deprn_run_id;
468:
469: end if;
470: else -- event was not final -0 need to delete the dpern event
471: delete from fa_deprn_events
472: where asset_id = p_asset_hdr_rec.asset_id
473: and book_type_code = p_asset_hdr_rec.book_type_code
474: and period_counter = p_period_rec.period_counter
475: and reversal_event_id is null;