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 94: CURSOR fiscal_year_cr (p_book_type_code FA_BOOKS.book_type_code%TYPE, p_fiscal_year Number) is

90: l_secondary_trans_rec fa_api_types.trans_rec_type;
91: l_secondary_sob_id number;
92:
93:
94: CURSOR fiscal_year_cr (p_book_type_code FA_BOOKS.book_type_code%TYPE, p_fiscal_year Number) is
95: SELECT DP.FISCAL_YEAR, MAX(DP.PERIOD_NUM),MAX(DP.PERIOD_COUNTER)
96: FROM FA_DEPRN_PERIODS DP
97: WHERE DP.BOOK_TYPE_CODE = p_book_type_code
98: AND DP.FISCAL_YEAR > p_fiscal_year

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

702:
703: /*
704: * We're done if deprn method is not based on the net book value;
705: * (We don't want to insert any more FA_ADJUSTMENTS rows, and
706: * don't want to terminate and insert FA_BOOKS rows, for non NBV-based
707: * assets unless asset is no longer fully reserved.
708: */
709:
710: if l_deprn_basis_rule = fa_std_types.FAD_DBR_COST then

Line 722: -- terminate/insert fa_books rows

718: l_annual_deprn_rounding_flag := 'ADJ';
719: end if;
720:
721:
722: -- terminate/insert fa_books rows
723: -- terminate the active row
724:
725: fa_books_pkg.deactivate_row
726: (X_asset_id => px_asset_hdr_rec.asset_id,

Line 725: fa_books_pkg.deactivate_row

721:
722: -- terminate/insert fa_books rows
723: -- terminate the active row
724:
725: fa_books_pkg.deactivate_row
726: (X_asset_id => px_asset_hdr_rec.asset_id,
727: X_book_type_code => px_asset_hdr_rec.book_type_code,
728: X_transaction_header_id_out => px_trans_rec.transaction_header_id,
729: X_date_ineffective => px_trans_rec.who_info.last_update_date,

Line 736: -- fa books

732: X_Calling_Fn => l_calling_fn,
733: p_log_level_rec => p_log_level_rec
734: );
735:
736: -- fa books
737: fa_books_pkg.insert_row
738: (X_Rowid => l_bks_rowid,
739: X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
740: X_Asset_Id => px_asset_hdr_rec.asset_id,

Line 737: fa_books_pkg.insert_row

733: p_log_level_rec => p_log_level_rec
734: );
735:
736: -- fa books
737: fa_books_pkg.insert_row
738: (X_Rowid => l_bks_rowid,
739: X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
740: X_Asset_Id => px_asset_hdr_rec.asset_id,
741: X_Date_Placed_In_Service => l_asset_fin_rec.date_placed_in_service,

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

1062: end if;
1063:
1064:
1065: /*
1066: * terminate the current FA_BOOKS row; and insert a new one, with
1067: * the updated adjusted cost and rate adjustment factor
1068: * we only do this for assets with an NBV-based deprn method
1069: * and if this is not the year of adjustment
1070: */

Line 1082: -- terminate/insert fa_books rows

1078: else
1079: l_annual_deprn_rounding_flag := 'ADJ';
1080: end if;
1081:
1082: -- terminate/insert fa_books rows
1083: -- terminate the active row
1084: -- Bug 4597471 -- only if the run_mode is 'RUN'
1085:
1086: if (l_asset_tax_rsv_adj_rec.run_mode = 'RUN') then

Line 1088: fa_books_pkg.deactivate_row

1084: -- Bug 4597471 -- only if the run_mode is 'RUN'
1085:
1086: if (l_asset_tax_rsv_adj_rec.run_mode = 'RUN') then
1087:
1088: fa_books_pkg.deactivate_row
1089: (X_asset_id => px_asset_hdr_rec.asset_id,
1090: X_book_type_code => px_asset_hdr_rec.book_type_code,
1091: X_transaction_header_id_out => px_trans_rec.transaction_header_id,
1092: X_date_ineffective => px_trans_rec.who_info.last_update_date,

Line 1099: -- fa books

1095: X_Calling_Fn => l_calling_fn,
1096: p_log_level_rec => p_log_level_rec
1097: );
1098:
1099: -- fa books
1100:
1101: fa_books_pkg.insert_row
1102: (X_Rowid => l_bks_rowid,
1103: X_Book_Type_Code => px_asset_hdr_rec.book_type_code,

Line 1101: fa_books_pkg.insert_row

1097: );
1098:
1099: -- fa books
1100:
1101: fa_books_pkg.insert_row
1102: (X_Rowid => l_bks_rowid,
1103: X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
1104: X_Asset_Id => px_asset_hdr_rec.asset_id,
1105: X_Date_Placed_In_Service => l_asset_fin_rec.date_placed_in_service,