APPS.FA_ADDITION_PVT dependencies on FA_BOOKS

Line 424: from fa_books bks

420: select nvl(px_asset_fin_rec.cost, cost),
421: nvl(px_asset_fin_rec.date_placed_in_service, date_placed_in_service)
422: into px_asset_fin_rec.cost,
423: px_asset_fin_rec.date_placed_in_service
424: from fa_books bks
425: where book_type_code =
426: fa_cache_pkg.fazcbc_record.distribution_source_book
427: and asset_id = px_asset_hdr_rec.asset_id
428: and transaction_header_id_out is null;

Line 689: from fa_books

685:
686: if (px_asset_fin_rec.cost <> 0) then
687: select nvl(salvage_value, 0)
688: into px_asset_fin_rec.salvage_value
689: from fa_books
690: where transaction_header_id_in = px_trans_rec.source_transaction_header_id;
691: else
692: px_asset_fin_rec.salvage_value := 0;
693: end if;

Line 1449: -- Insert into fa_books.

1445: end if;
1446: end if; -- end corporate
1447: end if; -- end primary book
1448:
1449: -- Insert into fa_books.
1450: l_rowid := NULL;
1451:
1452: fa_books_pkg.insert_row (
1453: X_Rowid => l_rowid,

Line 1452: fa_books_pkg.insert_row (

1448:
1449: -- Insert into fa_books.
1450: l_rowid := NULL;
1451:
1452: fa_books_pkg.insert_row (
1453: X_Rowid => l_rowid,
1454: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
1455: X_Asset_Id => p_asset_hdr_rec.asset_id,
1456: X_Date_Placed_In_Service => p_asset_fin_rec.date_placed_in_service,

Line 1696: -- Insert into fa_books_summary if polish rule

1692: if not (l_status) then
1693: raise general_error;
1694: end if;
1695:
1696: -- Insert into fa_books_summary if polish rule
1697: if not fa_cache_pkg.fazccmt
1698: (X_method => p_asset_fin_rec.deprn_method_code,
1699: X_life => p_asset_fin_rec.life_in_months,
1700: p_log_level_rec => p_log_level_rec) then

Line 1746: fa_books_summary_pkg.insert_row (

1742: l_life_complete_flag := 'Y';
1743: end if;
1744:
1745: -- Insert into current period DEPRN row
1746: fa_books_summary_pkg.insert_row (
1747: X_Rowid => l_rowid,
1748: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
1749: X_Asset_Id => p_asset_hdr_rec.asset_id,
1750: X_Period_Counter => l_period_counter + 1,

Line 1926: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'Calling fa_books_pkg.update_row',

1922: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'l_deprn_exp after faxexp',
1923: l_deprn_exp, p_log_level_rec => p_log_level_rec);
1924: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'l_bonus_deprn_exp after faxexp',
1925: l_bonus_deprn_exp, p_log_level_rec => p_log_level_rec);
1926: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'Calling fa_books_pkg.update_row',
1927: 'after calling faxexp', p_log_level_rec => p_log_level_rec);
1928: end if;
1929:
1930: --

Line 1931: -- Bug4439895: Reflect post catch-up info to fa_books

1927: 'after calling faxexp', p_log_level_rec => p_log_level_rec);
1928: end if;
1929:
1930: --
1931: -- Bug4439895: Reflect post catch-up info to fa_books
1932: --
1933: fa_books_pkg.update_row
1934: (X_asset_id => p_asset_hdr_rec.asset_id,
1935: X_book_type_code => p_asset_hdr_rec.book_type_code,

Line 1933: fa_books_pkg.update_row

1929:
1930: --
1931: -- Bug4439895: Reflect post catch-up info to fa_books
1932: --
1933: fa_books_pkg.update_row
1934: (X_asset_id => p_asset_hdr_rec.asset_id,
1935: X_book_type_code => p_asset_hdr_rec.book_type_code,
1936: X_rate_adjustment_factor => p_asset_fin_rec.rate_adjustment_factor,
1937: X_reval_amortization_basis => p_asset_fin_rec.reval_amortization_basis,

Line 2005: fa_books_pkg.update_row

2001: end if;
2002:
2003: -- SLA: removing original faxiat call from here as we now call for all
2004:
2005: fa_books_pkg.update_row
2006: (X_asset_id => p_asset_hdr_rec.asset_id,
2007: X_book_type_code => p_asset_hdr_rec.book_type_code,
2008: X_rate_adjustment_factor => p_asset_fin_rec.rate_adjustment_factor,
2009: X_reval_amortization_basis => p_asset_fin_rec.reval_amortization_basis,

Line 2274: UPDATE FA_BOOKS

2270:
2271: if (l_revised_count > 0) and
2272: (p_asset_deprn_rec.deprn_reserve > 0) then
2273:
2274: UPDATE FA_BOOKS
2275: SET adjusted_cost = p_asset_fin_rec.nbv_at_switch
2276: WHERE book_type_code = p_asset_hdr_rec.book_type_code
2277: AND asset_id = p_asset_hdr_rec.asset_id
2278: AND date_ineffective is null;

Line 2291: UPDATE FA_BOOKS

2287: name => 'FA_ADDITION_REVISED_RATE');
2288: raise general_error; */
2289: end if;
2290:
2291: UPDATE FA_BOOKS
2292: SET rate_in_use = l_rate_in_use
2293: WHERE book_type_code = p_asset_hdr_rec.book_type_code
2294: AND asset_id = p_asset_hdr_rec.asset_id
2295: AND date_ineffective is null;