APPS.FA_ADDITION_PVT dependencies on FA_BOOKS

Line 431: from fa_books bks

427: select nvl(px_asset_fin_rec.cost, cost),
428: nvl(px_asset_fin_rec.date_placed_in_service, date_placed_in_service)
429: into px_asset_fin_rec.cost,
430: px_asset_fin_rec.date_placed_in_service
431: from fa_books bks
432: where book_type_code =
433: fa_cache_pkg.fazcbc_record.distribution_source_book
434: and asset_id = px_asset_hdr_rec.asset_id
435: and transaction_header_id_out is null;

Line 712: from fa_books

708:
709: if (px_asset_fin_rec.cost <> 0) then
710: select nvl(salvage_value, 0)
711: into px_asset_fin_rec.salvage_value
712: from fa_books
713: where transaction_header_id_in = px_trans_rec.source_transaction_header_id;
714: else
715: px_asset_fin_rec.salvage_value := 0;
716: end if;

Line 1526: -- Insert into fa_books.

1522: end if;
1523: end if; -- end corporate
1524: end if; -- end primary book
1525:
1526: -- Insert into fa_books.
1527: l_rowid := NULL;
1528: ---Added by Satish Byreddy In order to cater the Japan tax Reforms Migration Requirements
1529:
1530: IF p_asset_fin_rec.period_counter_life_complete IS NULL AND p_asset_fin_rec.period_counter_fully_reserved IS NOT NULL THEN

Line 1536: fa_books_pkg.insert_row (

1532: END IF;
1533:
1534: -- End OF Additions
1535:
1536: fa_books_pkg.insert_row (
1537: X_Rowid => l_rowid,
1538: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
1539: X_Asset_Id => p_asset_hdr_rec.asset_id,
1540: X_Date_Placed_In_Service => p_asset_fin_rec.date_placed_in_service,

Line 1797: -- Insert into fa_books_summary if polish rule

1793: if not (l_status) then
1794: raise general_error;
1795: end if;
1796:
1797: -- Insert into fa_books_summary if polish rule
1798: if not fa_cache_pkg.fazccmt
1799: (X_method => p_asset_fin_rec.deprn_method_code,
1800: X_life => p_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec) then
1801: raise general_error;

Line 1840: fa_books_summary_pkg.insert_row (

1836: l_life_complete_flag := 'Y';
1837: end if;
1838:
1839: -- Insert into current period DEPRN row
1840: fa_books_summary_pkg.insert_row (
1841: X_Rowid => l_rowid,
1842: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
1843: X_Asset_Id => p_asset_hdr_rec.asset_id,
1844: X_Period_Counter => l_period_counter + 1,

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

2031: l_deprn_exp, p_log_level_rec => p_log_level_rec);
2032: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'l_bonus_deprn_exp after faxexp',
2033: l_bonus_deprn_exp, p_log_level_rec =>
2034: p_log_level_rec);
2035: fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'Calling fa_books_pkg.update_row',
2036: 'after calling faxexp', p_log_level_rec => p_log_level_rec);
2037: end if;
2038:
2039: --

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

2036: 'after calling faxexp', p_log_level_rec => p_log_level_rec);
2037: end if;
2038:
2039: --
2040: -- Bug4439895: Reflect post catch-up info to fa_books
2041: --
2042: fa_books_pkg.update_row
2043: (X_asset_id => p_asset_hdr_rec.asset_id,
2044: X_book_type_code => p_asset_hdr_rec.book_type_code,

Line 2042: fa_books_pkg.update_row

2038:
2039: --
2040: -- Bug4439895: Reflect post catch-up info to fa_books
2041: --
2042: fa_books_pkg.update_row
2043: (X_asset_id => p_asset_hdr_rec.asset_id,
2044: X_book_type_code => p_asset_hdr_rec.book_type_code,
2045: X_rate_adjustment_factor => p_asset_fin_rec.rate_adjustment_factor,
2046: X_reval_amortization_basis => p_asset_fin_rec.reval_amortization_basis,

Line 2139: fa_books_pkg.update_row

2135: end if;
2136:
2137: end if;
2138:
2139: fa_books_pkg.update_row
2140: (X_asset_id => p_asset_hdr_rec.asset_id,
2141: X_book_type_code => p_asset_hdr_rec.book_type_code,
2142: X_rate_adjustment_factor => p_asset_fin_rec.rate_adjustment_factor,
2143: X_reval_amortization_basis => p_asset_fin_rec.reval_amortization_basis,

Line 2433: UPDATE FA_BOOKS

2429:
2430: if (l_revised_count > 0) and -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
2431: (p_asset_deprn_rec.deprn_reserve > 0) then
2432:
2433: UPDATE FA_BOOKS
2434: SET adjusted_cost = p_asset_fin_rec.nbv_at_switch
2435: WHERE book_type_code = p_asset_hdr_rec.book_type_code
2436: AND asset_id = p_asset_hdr_rec.asset_id
2437: AND date_ineffective is null;

Line 2477: UPDATE FA_BOOKS

2473: p_asset_deprn_rec.ytd_deprn))* l_original_Rate)) THEN
2474: l_rate_in_use := l_Revised_Rate;
2475: END IF;
2476:
2477: UPDATE FA_BOOKS
2478: SET rate_in_use = l_rate_in_use
2479: WHERE book_type_code = p_asset_hdr_rec.book_type_code
2480: AND asset_id = p_asset_hdr_rec.asset_id
2481: AND date_ineffective is null;