APPS.FA_UNPLANNED_PVT dependencies on FA_BOOKS

Line 141: FROM fa_books

137: p_asset_hdr_rec.set_of_books_id,
138: p_period_rec.period_counter,
139: p_mrc_sob_type_code ))
140: INTO l_mem_nbv_sum
141: FROM fa_books
142: WHERE group_asset_id = p_asset_hdr_rec.asset_id
143: AND book_type_code = p_asset_hdr_rec.book_type_code
144: AND transaction_header_id_out IS NULL;
145:

Line 438: fa_books_pkg.deactivate_row

434:
435: l_asset_fin_rec.period_counter_life_complete := l_asset_fin_rec.period_counter_fully_reserved;
436:
437: -- terminate the row
438: fa_books_pkg.deactivate_row
439: (X_asset_id => p_asset_hdr_rec.asset_id,
440: X_book_type_code => p_asset_hdr_rec.book_type_code,
441: X_transaction_header_id_out => px_trans_rec.transaction_header_id,
442: X_date_ineffective => px_trans_rec.who_info.last_update_date,

Line 478: fa_books_pkg.insert_row

474: end if;
475:
476:
477: -- insert the row
478: fa_books_pkg.insert_row
479: (X_Rowid => l_rowid,
480: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
481: X_Asset_Id => p_asset_hdr_rec.asset_id,
482: X_Date_Placed_In_Service => l_asset_fin_rec.date_placed_in_service,

Line 629: Update FA_BOOKS

625: fa_srvr_msg.add_message(calling_fn => 'FA_UNPLANNED_PVT.do_unplanned', p_log_level_rec => p_log_level_rec);
626: raise unp_err;
627: end if;
628:
629: Update FA_BOOKS
630: Set rate_in_use = l_rate_in_use
631: Where book_type_code = p_asset_hdr_rec.book_type_code
632: And asset_id = p_asset_hdr_rec.asset_id
633: And date_ineffective is null;