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 86: from fa_books bks,

82: select bks.rowid,
83: bks.asset_id,
84: bks.deprn_method_code,
85: bks.life_in_months
86: from fa_books bks,
87: fa_methods mt
88: where bks.asset_id = p_asset_hdr_rec.asset_id
89: and bks.book_type_code = p_asset_hdr_rec.book_type_code
90: and bks.transaction_header_id_out is null

Line 102: from fa_books_mrc_v bks,

98: select bks.rowid,
99: bks.asset_id,
100: bks.deprn_method_code,
101: bks.life_in_months
102: from fa_books_mrc_v bks,
103: fa_methods mt
104: where bks.asset_id = p_asset_hdr_rec.asset_id
105: and bks.book_type_code = p_asset_hdr_rec.book_type_code
106: and bks.transaction_header_id_out is null

Line 413: update fa_books_mrc_v bk

409:
410: if (p_mrc_sob_type_code = 'R') then
411:
412: -- Bug:5701095
413: update fa_books_mrc_v bk
414: set (adjusted_cost, eofy_reserve, formula_factor, adjusted_capacity) =
415: (Select Decode(ds2.deprn_source_code,
416: 'BOOKS', ds2.adjusted_cost,
417: decode(p_period_rec.period_num - pers_per_yr,

Line 454: From fa_deprn_summary_mrc_v ds2, fa_deprn_summary_mrc_v ds1, fa_books_mrc_v bk2

450: bk2.eop_formula_factor)),
451: Decode(bk2.eop_adj_cost,
452: null, bk2.adjusted_capacity,
453: bk2.old_adjusted_capacity)
454: From fa_deprn_summary_mrc_v ds2, fa_deprn_summary_mrc_v ds1, fa_books_mrc_v bk2
455: where bk2.transaction_header_id_in = bk.transaction_header_id_in
456: and ds2.asset_id(+) = bk2.asset_id
457: and ds2.book_type_code(+) = bk2.book_type_code
458: and ds2.period_counter(+) = (p_period_rec.period_counter - 1)

Line 488: update fa_books bk

484:
485: else -- if (p_mrc_sob_type_code = 'R') then
486:
487: -- Bug:5701095
488: update fa_books bk
489: set (adjusted_cost, eofy_reserve, formula_factor, adjusted_capacity) =
490: (Select Decode(ds2.deprn_source_code,
491: 'BOOKS', ds2.adjusted_cost,
492: decode(p_period_rec.period_num - pers_per_yr,

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

525: bk2.eop_formula_factor)),
526: Decode(bk2.eop_adj_cost,
527: null, bk2.adjusted_capacity,
528: bk2.old_adjusted_capacity)
529: From fa_deprn_summary ds2, fa_deprn_summary ds1, fa_books bk2
530: where bk2.transaction_header_id_in = bk.transaction_header_id_in
531: and ds2.asset_id(+) = bk2.asset_id
532: and ds2.book_type_code(+) = bk2.book_type_code
533: and ds2.period_counter(+) = (p_period_rec.period_counter - 1)

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 1023: fa_books_pkg.deactivate_row

1019: ;
1020:
1021: end if; -- (p_mrc_sob_type_code <> 'R')
1022:
1023: fa_books_pkg.deactivate_row
1024: (X_asset_id => p_asset_hdr_rec.asset_id,
1025: X_book_type_code => p_asset_hdr_rec.book_type_code,
1026: X_transaction_header_id_out => l_trans_rec.transaction_header_id,
1027: X_date_ineffective => l_trans_rec.who_info.last_update_date,

Line 1032: fa_books_pkg.insert_row

1028: X_mrc_sob_type_code => p_mrc_sob_type_code,
1029: X_Calling_Fn => l_calling_fn
1030: ,p_log_level_rec => p_log_level_rec);
1031:
1032: fa_books_pkg.insert_row
1033: (X_Rowid => l_bks_rowid,
1034: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
1035: X_Asset_Id => p_asset_hdr_rec.asset_id,
1036: X_Date_Placed_In_Service => l_asset_fin_rec.date_placed_in_service,

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

1146: X_Calling_Fn => l_calling_fn
1147: ,p_log_level_rec => p_log_level_rec);
1148:
1149: if not l_status then
1150: fa_debug_pkg.add(l_calling_fn, 'Failed to insert ', 'FA_BOOKS'
1151: ,p_log_level_rec => p_log_level_rec);
1152: raise rb_error;
1153: end if;
1154:

Line 1178: delete from fa_books

1174: where asset_id = p_asset_hdr_rec.asset_id
1175: and book_type_code = p_asset_hdr_rec.book_type_code
1176: and transaction_header_id = l_thid;
1177:
1178: delete from fa_books
1179: where asset_id = p_asset_hdr_rec.asset_id
1180: and book_type_code = p_asset_hdr_rec.book_type_code
1181: and transaction_header_id_in = l_thid;
1182:

Line 1183: update fa_books

1179: where asset_id = p_asset_hdr_rec.asset_id
1180: and book_type_code = p_asset_hdr_rec.book_type_code
1181: and transaction_header_id_in = l_thid;
1182:
1183: update fa_books
1184: set transaction_header_id_out = null,
1185: date_ineffective = null
1186: where asset_id = p_asset_hdr_rec.asset_id
1187: and book_type_code = p_asset_hdr_rec.book_type_code

Line 1197: delete from fa_books_mrc_v

1193: where asset_id = p_asset_hdr_rec.asset_id
1194: and book_type_code = p_asset_hdr_rec.book_type_code
1195: and transaction_header_id = l_thid;
1196:
1197: delete from fa_books_mrc_v
1198: where asset_id = p_asset_hdr_rec.asset_id
1199: and book_type_code = p_asset_hdr_rec.book_type_code
1200: and transaction_header_id_in = l_thid;
1201:

Line 1202: update fa_books_mrc_v

1198: where asset_id = p_asset_hdr_rec.asset_id
1199: and book_type_code = p_asset_hdr_rec.book_type_code
1200: and transaction_header_id_in = l_thid;
1201:
1202: update fa_books_mrc_v
1203: set transaction_header_id_out = null,
1204: date_ineffective = null
1205: where asset_id = p_asset_hdr_rec.asset_id
1206: and book_type_code = p_asset_hdr_rec.book_type_code

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,

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

1306: raise rb_error;
1307: end if;
1308: end loop;
1309:
1310: fa_debug_pkg.add('FAVDRBB', 'update fa_books.rate_in_use', l_bks_rowid_tbl2.count);
1311:
1312: forall i IN 1..l_bks_rowid_tbl2.count
1313: update fa_books
1314: set rate_in_use = l_rate_in_use_tbl(i)

Line 1313: update fa_books

1309:
1310: fa_debug_pkg.add('FAVDRBB', 'update fa_books.rate_in_use', l_bks_rowid_tbl2.count);
1311:
1312: forall i IN 1..l_bks_rowid_tbl2.count
1313: update fa_books
1314: set rate_in_use = l_rate_in_use_tbl(i)
1315: where rowid = l_bks_rowid_tbl2(i);
1316: end if;
1317: end loop;