APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_BOOKS_SUMMARY

Line 598: -- Delete from FA_BOOKS_SUMMARY

594: and dd.period_counter = p_period_rec.period_counter
595: and dd.deprn_source_code in ('D','T');
596: end if;
597:
598: -- Delete from FA_BOOKS_SUMMARY
599:
600: if (p_log_level_rec.statement_level) then
601: fa_debug_pkg.add(l_calling_fn,
602: 'Deleting FA_BOOKS_SUMMARY rows, next period ctr',

Line 602: 'Deleting FA_BOOKS_SUMMARY rows, next period ctr',

598: -- Delete from FA_BOOKS_SUMMARY
599:
600: if (p_log_level_rec.statement_level) then
601: fa_debug_pkg.add(l_calling_fn,
602: 'Deleting FA_BOOKS_SUMMARY rows, next period ctr',
603: p_period_rec.period_counter + 1
604: ,p_log_level_rec => p_log_level_rec);
605: end if;
606:

Line 609: delete from fa_books_summary_mrc_v bs

605: end if;
606:
607: if (p_mrc_sob_type_code = 'R') then
608:
609: delete from fa_books_summary_mrc_v bs
610: where bs.asset_id = p_asset_hdr_rec.asset_id
611: and bs.book_type_code = p_asset_hdr_rec.book_type_code
612: and bs.period_counter = p_period_rec.period_counter + 1;
613:

Line 614: update fa_books_summary_mrc_v bs

610: where bs.asset_id = p_asset_hdr_rec.asset_id
611: and bs.book_type_code = p_asset_hdr_rec.book_type_code
612: and bs.period_counter = p_period_rec.period_counter + 1;
613:
614: update fa_books_summary_mrc_v bs
615: set deprn_amount = expense_adjustment_amount,
616: ytd_deprn = ytd_deprn - deprn_amount + expense_adjustment_amount,
617: deprn_reserve = deprn_reserve - deprn_amount + expense_adjustment_amount,
618: bonus_deprn_amount = 0,

Line 635: delete from fa_books_summary bs

631: and bs.period_counter = p_period_rec.period_counter;
632:
633: else
634:
635: delete from fa_books_summary bs
636: where bs.asset_id = p_asset_hdr_rec.asset_id
637: and bs.book_type_code = p_asset_hdr_rec.book_type_code
638: and bs.period_counter = p_period_rec.period_counter + 1;
639:

Line 640: update fa_books_summary bs

636: where bs.asset_id = p_asset_hdr_rec.asset_id
637: and bs.book_type_code = p_asset_hdr_rec.book_type_code
638: and bs.period_counter = p_period_rec.period_counter + 1;
639:
640: update fa_books_summary bs
641: set deprn_amount = expense_adjustment_amount,
642: ytd_deprn = ytd_deprn - deprn_amount + expense_adjustment_amount,
643: deprn_reserve = deprn_reserve - deprn_amount + expense_adjustment_amount,
644: bonus_deprn_amount = 0,

Line 1217: update fa_books_summary

1213: end if; -- (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED)
1214:
1215: -- Common for both situations (reverse, delete)
1216: if (p_mrc_sob_type_code <> 'R') then
1217: update fa_books_summary
1218: set terminal_gain_loss_flag = 'Y',
1219: terminal_gain_loss_amount = null,
1220: reserve_adjustment_amount = reserve_adjustment_amount - terminal_gain_loss_amount,
1221: deprn_reserve = deprn_reserve - terminal_gain_loss_amount,

Line 1229: update fa_books_summary_mrc_v

1225: where book_type_code = p_asset_hdr_rec.book_type_code
1226: and asset_id = p_asset_hdr_rec.asset_id
1227: and period_counter = p_period_rec.period_counter;
1228: else
1229: update fa_books_summary_mrc_v
1230: set terminal_gain_loss_flag = 'Y',
1231: terminal_gain_loss_amount = null,
1232: reserve_adjustment_amount = reserve_adjustment_amount - terminal_gain_loss_amount,
1233: deprn_reserve = deprn_reserve - terminal_gain_loss_amount,