APPS.FA_ADJUSTMENT_PVT dependencies on FA_BOOKS

Line 375: fa_books_pkg.deactivate_row

371: end if;
372: end if;
373:
374: -- terminate the active row
375: fa_books_pkg.deactivate_row
376: (X_asset_id => px_asset_hdr_rec.asset_id,
377: X_book_type_code => px_asset_hdr_rec.book_type_code,
378: X_transaction_header_id_out => px_trans_rec.transaction_header_id,
379: X_date_ineffective => px_trans_rec.who_info.last_update_date,

Line 385: -- fa books

381: X_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
382: X_Calling_Fn => l_calling_fn
383: , p_log_level_rec => p_log_level_rec);
384:
385: -- fa books
386: fa_books_pkg.insert_row
387: (X_Rowid => l_bks_rowid,
388: X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
389: X_Asset_Id => px_asset_hdr_rec.asset_id,

Line 386: fa_books_pkg.insert_row

382: X_Calling_Fn => l_calling_fn
383: , p_log_level_rec => p_log_level_rec);
384:
385: -- fa books
386: fa_books_pkg.insert_row
387: (X_Rowid => l_bks_rowid,
388: X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
389: X_Asset_Id => px_asset_hdr_rec.asset_id,
390: X_Date_Placed_In_Service => x_asset_fin_rec_new.date_placed_in_service,

Line 598: UPDATE FA_BOOKS

594: if (l_rate_in_use <> l_Revised_Rate) THEN
595: l_nbv_at_switch_var := 'X';
596: end if;
597:
598: UPDATE FA_BOOKS
599: SET rate_in_use = l_rate_in_use
600: ,nbv_at_switch = Decode(l_nbv_at_switch_var,'X',NULL,nbv_at_switch)
601: WHERE book_type_code = px_asset_hdr_rec.book_type_code
602: AND asset_id = px_asset_hdr_rec.asset_id

Line 928: fa_books_pkg.update_row

924: p_calling_fn => l_calling_fn
925: , p_log_level_rec => p_log_level_rec) then raise adj_err;
926: end if;
927:
928: fa_books_pkg.update_row
929: (X_asset_id => px_asset_hdr_rec.asset_id,
930: X_book_type_code => px_asset_hdr_rec.book_type_code,
931: X_rate_adjustment_factor => x_asset_fin_rec_new.rate_adjustment_factor,
932: X_reval_amortization_basis => x_asset_fin_rec_new.reval_amortization_basis,

Line 1071: (select 'x' from fa_books

1067:
1068: CURSOR c_group_mem_no_depreciate is
1069: select 1 from dual
1070: where exists
1071: (select 'x' from fa_books
1072: where book_type_code = p_asset_hdr_rec.book_type_code
1073: and group_asset_id = h_asset_id
1074: and transaction_header_id_out is null
1075: and depreciate_flag = 'NO');