eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_BOOKS

Line 105: from fa_books bks,

101: select bks.rowid,
102: bks.asset_id,
103: bks.deprn_method_code,
104: bks.life_in_months
105: from fa_books bks,
106: fa_methods mt
107: where bks.asset_id = p_asset_hdr_rec.asset_id
108: and bks.book_type_code = p_asset_hdr_rec.book_type_code
109: and bks.transaction_header_id_out is null

Line 144: from fa_books bk

140: and nvl(p_period_rec.period_close_date, sysdate)
141: and th.transaction_type_code = 'REVALUATION'
142: and th.transaction_key = 'PR'
143: and exists (select 'not rollbacked'
144: from fa_books bk
145: where bk.book_type_code = p_asset_hdr_rec.book_type_code
146: and bk.asset_id = p_asset_hdr_rec.asset_id
147: and bk.transaction_header_id_in = th.transaction_header_id
148: and bk.transaction_header_id_out is null)

Line 585: update fa_books bk

581:
582: else -- if (p_mrc_sob_type_code = 'R') then
583:
584: -- Bug:5701095
585: update fa_books bk
586: set (adjusted_cost, eofy_reserve, formula_factor, adjusted_capacity) =
587: (Select Decode(p_period_rec.period_num - pers_per_yr,
588: 0, decode(bk2.eofy_adj_cost,
589: null, decode(bk2.eop_adj_cost,

Line 624: From fa_deprn_summary ds2, fa_deprn_summary ds1, fa_books bk2

620: bk2.eop_formula_factor)),
621: Decode(bk2.eop_adj_cost,
622: null, bk2.adjusted_capacity,
623: bk2.old_adjusted_capacity)
624: From fa_deprn_summary ds2, fa_deprn_summary ds1, fa_books bk2
625: where bk2.transaction_header_id_in = bk.transaction_header_id_in
626: and ds2.asset_id(+) = bk2.asset_id
627: and ds2.book_type_code(+) = bk2.book_type_code
628: and ds2.period_counter(+) = (p_period_rec.period_counter - 1)

Line 699: -- Delete from FA_BOOKS_SUMMARY

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',

Line 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:

Line 737: delete from fa_books_summary bs

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:

Line 742: update 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:
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,

Line 1224: fa_books_pkg.deactivate_row

1220: ;
1221:
1222: end if; -- (p_mrc_sob_type_code <> 'R')
1223:
1224: fa_books_pkg.deactivate_row
1225: (X_asset_id => p_asset_hdr_rec.asset_id,
1226: X_book_type_code => p_asset_hdr_rec.book_type_code,
1227: X_transaction_header_id_out => l_trans_rec.transaction_header_id,
1228: X_date_ineffective => l_trans_rec.who_info.last_update_date,

Line 1234: fa_books_pkg.insert_row

1230: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
1231: X_Calling_Fn => l_calling_fn
1232: ,p_log_level_rec => p_log_level_rec);
1233:
1234: fa_books_pkg.insert_row
1235: (X_Rowid => l_bks_rowid,
1236: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
1237: X_Asset_Id => p_asset_hdr_rec.asset_id,
1238: X_Date_Placed_In_Service => l_asset_fin_rec.date_placed_in_service,

Line 1353: fa_debug_pkg.add(l_calling_fn, 'Failed to insert ', 'FA_BOOKS'

1349: X_Calling_Fn => l_calling_fn
1350: ,p_log_level_rec => p_log_level_rec);
1351:
1352: if not l_status then
1353: fa_debug_pkg.add(l_calling_fn, 'Failed to insert ', 'FA_BOOKS'
1354: ,p_log_level_rec => p_log_level_rec);
1355: raise rb_error;
1356: end if;
1357: /* Bug#9018861 - Modified condition for reporting currency */

Line 1397: delete from fa_books

1393: where asset_id = p_asset_hdr_rec.asset_id
1394: and book_type_code = p_asset_hdr_rec.book_type_code
1395: and transaction_header_id = l_thid;
1396:
1397: delete from fa_books
1398: where asset_id = p_asset_hdr_rec.asset_id
1399: and book_type_code = p_asset_hdr_rec.book_type_code
1400: and transaction_header_id_in = l_thid;
1401:

Line 1402: update fa_books

1398: where asset_id = p_asset_hdr_rec.asset_id
1399: and book_type_code = p_asset_hdr_rec.book_type_code
1400: and transaction_header_id_in = l_thid;
1401:
1402: update fa_books
1403: set transaction_header_id_out = null,
1404: date_ineffective = null
1405: where asset_id = p_asset_hdr_rec.asset_id
1406: and book_type_code = p_asset_hdr_rec.book_type_code

Line 1439: update fa_books_summary

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,

Line 1542: fa_debug_pkg.add('FAVDRBB', 'update fa_books.rate_in_use', l_bks_rowid_tbl2.count);

1538: raise rb_error;
1539: end if;
1540: end loop;
1541:
1542: fa_debug_pkg.add('FAVDRBB', 'update fa_books.rate_in_use', l_bks_rowid_tbl2.count);
1543:
1544: forall i IN 1..l_bks_rowid_tbl2.count
1545: update fa_books
1546: set rate_in_use = l_rate_in_use_tbl(i)

Line 1545: update fa_books

1541:
1542: fa_debug_pkg.add('FAVDRBB', 'update fa_books.rate_in_use', l_bks_rowid_tbl2.count);
1543:
1544: forall i IN 1..l_bks_rowid_tbl2.count
1545: update fa_books
1546: set rate_in_use = l_rate_in_use_tbl(i)
1547: where rowid = l_bks_rowid_tbl2(i);
1548: end if;
1549: end loop;