DBA Data[Home] [Help]

APPS.FA_TERMINAL_GAIN_LOSS_PVT dependencies on FA_BOOKS_SUMMARY

Line 479: -- Update FA_BOOKS_SUMMARY

475: end if;
476: raise tgl_err;
477: end if;
478:
479: -- Update FA_BOOKS_SUMMARY
480: if (p_log_level_rec.statement_level) then
481: fa_debug_pkg.add(l_db_title, 'Update', 'FA_BOOKS_SUMMARY: '||p_mrc_sob_type_code,
482: p_log_level_rec => p_log_level_rec);
483: end if;

Line 481: fa_debug_pkg.add(l_db_title, 'Update', 'FA_BOOKS_SUMMARY: '||p_mrc_sob_type_code,

477: end if;
478:
479: -- Update FA_BOOKS_SUMMARY
480: if (p_log_level_rec.statement_level) then
481: fa_debug_pkg.add(l_db_title, 'Update', 'FA_BOOKS_SUMMARY: '||p_mrc_sob_type_code,
482: p_log_level_rec => p_log_level_rec);
483: end if;
484:
485: if (p_mrc_sob_type_code = 'R') then

Line 486: UPDATE FA_BOOKS_SUMMARY_MRC_V

482: p_log_level_rec => p_log_level_rec);
483: end if;
484:
485: if (p_mrc_sob_type_code = 'R') then
486: UPDATE FA_BOOKS_SUMMARY_MRC_V
487: SET TERMINAL_GAIN_LOSS_AMOUNT = p_deprn_reserve
488: , TERMINAL_GAIN_LOSS_FLAG = 'C'
489: , RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + p_deprn_reserve
490: , DEPRN_RESERVE = DEPRN_RESERVE + p_deprn_reserve

Line 495: UPDATE FA_BOOKS_SUMMARY

491: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
492: AND BOOK_TYPE_CODE = l_asset_hdr_rec.book_type_code
493: AND PERIOD_COUNTER = l_period_rec.period_counter;
494: else
495: UPDATE FA_BOOKS_SUMMARY
496: SET TERMINAL_GAIN_LOSS_AMOUNT = p_deprn_reserve
497: , TERMINAL_GAIN_LOSS_FLAG = 'C'
498: , RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + p_deprn_reserve
499: , DEPRN_RESERVE = DEPRN_RESERVE + p_deprn_reserve