[Home] [Help]
695: and dd.period_counter = p_period_rec.period_counter
696: and dd.deprn_source_code in ('D','T');
697: end if;
698:
699: -- Delete from FA_BOOKS_SUMMARY
700:
701: if (p_log_level_rec.statement_level) then
702: fa_debug_pkg.add(l_calling_fn,
703: 'Deleting FA_BOOKS_SUMMARY rows, next period ctr',
699: -- Delete from FA_BOOKS_SUMMARY
700:
701: if (p_log_level_rec.statement_level) then
702: fa_debug_pkg.add(l_calling_fn,
703: 'Deleting FA_BOOKS_SUMMARY rows, next period ctr',
704: p_period_rec.period_counter + 1
705: ,p_log_level_rec => p_log_level_rec);
706: end if;
707:
733: and bs.set_of_books_id = p_asset_hdr_rec.set_of_books_id ;
734:
735: else
736:
737: delete from fa_books_summary bs
738: where bs.asset_id = p_asset_hdr_rec.asset_id
739: and bs.book_type_code = p_asset_hdr_rec.book_type_code
740: and bs.period_counter = p_period_rec.period_counter + 1;
741:
738: where bs.asset_id = p_asset_hdr_rec.asset_id
739: and bs.book_type_code = p_asset_hdr_rec.book_type_code
740: and bs.period_counter = p_period_rec.period_counter + 1;
741:
742: update fa_books_summary bs
743: set deprn_amount = expense_adjustment_amount,
744: ytd_deprn = ytd_deprn - nvl(deprn_amount,0) + nvl(expense_adjustment_amount,0), --Bug8244128
745: deprn_reserve = deprn_reserve - nvl(deprn_amount,0) + nvl(expense_adjustment_amount,0), --Bug8244128
746: bonus_deprn_amount = 0,
1435: end if; -- (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED)
1436:
1437: -- Common for both situations (reverse, delete)
1438: if (p_mrc_sob_type_code <> 'R') then
1439: update fa_books_summary
1440: set terminal_gain_loss_flag = 'Y',
1441: terminal_gain_loss_amount = null,
1442: reserve_adjustment_amount = reserve_adjustment_amount - terminal_gain_loss_amount,
1443: deprn_reserve = deprn_reserve - terminal_gain_loss_amount,