APPS.FA_TAX_RSV_ADJ_PVT dependencies on FA_BOOKS

Line 65: l_annual_deprn_rounding_flag FA_BOOKS.ANNUAL_DEPRN_ROUNDING_FLAG%Type;

61: l_avg_rate Number;
62: l_old_ytd_deprn Number;
63:
64: l_deprn_basis_rule VARCHAR2(10);
65: l_annual_deprn_rounding_flag FA_BOOKS.ANNUAL_DEPRN_ROUNDING_FLAG%Type;
66:
67: l_dummy_varch varchar2(124);
68: l_dummy_bool Boolean;
69: l_dummy_dpr_arr fa_std_types.dpr_arr_type;

Line 88: CURSOR fiscal_year_cr (p_book_type_code FA_BOOKS.book_type_code%TYPE, p_fiscal_year Number) is

84:
85:
86: TAX_RSV_ADJ_ERR EXCEPTION;
87:
88: CURSOR fiscal_year_cr (p_book_type_code FA_BOOKS.book_type_code%TYPE, p_fiscal_year Number) is
89: SELECT DP.FISCAL_YEAR, MAX(DP.PERIOD_NUM),MAX(DP.PERIOD_COUNTER)
90: FROM FA_DEPRN_PERIODS DP
91: WHERE DP.BOOK_TYPE_CODE = p_book_type_code
92: AND DP.FISCAL_YEAR > p_fiscal_year

Line 666: * don't want to terminate and insert FA_BOOKS rows, for non NBV-based

662:
663: /*
664: * We're done if deprn method is not based on the net book value;
665: * (We don't want to insert any more FA_ADJUSTMENTS rows, and
666: * don't want to terminate and insert FA_BOOKS rows, for non NBV-based
667: * assets unless asset is no longer fully reserved.
668: */
669:
670: if l_deprn_basis_rule = fa_std_types.FAD_DBR_COST then

Line 682: -- terminate/insert fa_books rows

678: l_annual_deprn_rounding_flag := 'ADJ';
679: end if;
680:
681:
682: -- terminate/insert fa_books rows
683: -- terminate the active row
684:
685: fa_books_pkg.deactivate_row
686: (X_asset_id => px_asset_hdr_rec.asset_id,

Line 685: fa_books_pkg.deactivate_row

681:
682: -- terminate/insert fa_books rows
683: -- terminate the active row
684:
685: fa_books_pkg.deactivate_row
686: (X_asset_id => px_asset_hdr_rec.asset_id,
687: X_book_type_code => px_asset_hdr_rec.book_type_code,
688: X_transaction_header_id_out => px_trans_rec.transaction_header_id,
689: X_date_ineffective => px_trans_rec.who_info.last_update_date,

Line 695: -- fa books

691: X_Calling_Fn => l_calling_fn,
692: p_log_level_rec => p_log_level_rec
693: );
694:
695: -- fa books
696: fa_books_pkg.insert_row
697: (X_Rowid => l_bks_rowid,
698: X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
699: X_Asset_Id => px_asset_hdr_rec.asset_id,

Line 696: fa_books_pkg.insert_row

692: p_log_level_rec => p_log_level_rec
693: );
694:
695: -- fa books
696: fa_books_pkg.insert_row
697: (X_Rowid => l_bks_rowid,
698: X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
699: X_Asset_Id => px_asset_hdr_rec.asset_id,
700: X_Date_Placed_In_Service => l_asset_fin_rec.date_placed_in_service,

Line 1020: * terminate the current FA_BOOKS row; and insert a new one, with

1016: end if;
1017:
1018:
1019: /*
1020: * terminate the current FA_BOOKS row; and insert a new one, with
1021: * the updated adjusted cost and rate adjustment factor
1022: * we only do this for assets with an NBV-based deprn method
1023: * and if this is not the year of adjustment
1024: */

Line 1036: -- terminate/insert fa_books rows

1032: else
1033: l_annual_deprn_rounding_flag := 'ADJ';
1034: end if;
1035:
1036: -- terminate/insert fa_books rows
1037: -- terminate the active row
1038: -- Bug 4597471 -- only if the run_mode is 'RUN'
1039:
1040: if (l_asset_tax_rsv_adj_rec.run_mode = 'RUN') then

Line 1042: fa_books_pkg.deactivate_row

1038: -- Bug 4597471 -- only if the run_mode is 'RUN'
1039:
1040: if (l_asset_tax_rsv_adj_rec.run_mode = 'RUN') then
1041:
1042: fa_books_pkg.deactivate_row
1043: (X_asset_id => px_asset_hdr_rec.asset_id,
1044: X_book_type_code => px_asset_hdr_rec.book_type_code,
1045: X_transaction_header_id_out => px_trans_rec.transaction_header_id,
1046: X_date_ineffective => px_trans_rec.who_info.last_update_date,

Line 1052: -- fa books

1048: X_Calling_Fn => l_calling_fn,
1049: p_log_level_rec => p_log_level_rec
1050: );
1051:
1052: -- fa books
1053:
1054: fa_books_pkg.insert_row
1055: (X_Rowid => l_bks_rowid,
1056: X_Book_Type_Code => px_asset_hdr_rec.book_type_code,

Line 1054: fa_books_pkg.insert_row

1050: );
1051:
1052: -- fa books
1053:
1054: fa_books_pkg.insert_row
1055: (X_Rowid => l_bks_rowid,
1056: X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
1057: X_Asset_Id => px_asset_hdr_rec.asset_id,
1058: X_Date_Placed_In_Service => l_asset_fin_rec.date_placed_in_service,