eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_TXRSV_PKG dependencies on FA_BOOKS

Line 10: * 'STRICT_FLAT', then take existing FA_BOOKS.ANNUAL_DEPRN_ROUNDING_FLAG

6: * Reserve Adjustment window "Strict Calculation Method" checkbox.
7: * If it is checked, then the form pass 'STRICT_FLAT' using the new parameter
8: * to faxtxa. Then pass to fautxa.
9: * In fautxa, when calling fautubk, pass the value and if it has value of
10: * 'STRICT_FLAT', then take existing FA_BOOKS.ANNUAL_DEPRN_ROUNDING_FLAG
11: * value, otherwise set it 'ADJ'.
12: * After comes back from fautubk, if the variable has value of 'STRICT_FLAT',
13: * then add ytd deprn amount back and subtract difference from new adjusted
14: * cost to find adjusted cost as of beginning of current fiscal year.

Line 18: X_asset_id fa_books.asset_id%type

14: * cost to find adjusted cost as of beginning of current fiscal year.
15: */
16: Function fautca
17: (
18: X_asset_id fa_books.asset_id%type
19: ,X_book fa_book_controls.book_type_code%type
20: ,X_period_counter integer
21: ,X_is_amortized out nocopy boolean
22: )

Line 66: ,X_asset_id fa_books.asset_id%type

62:
63: Function fautubk
64: (
65: X_book fa_book_controls.book_type_code%type
66: ,X_asset_id fa_books.asset_id%type
67: ,X_sysdate date
68: ,X_user_id integer
69: ,X_login_id integer
70: ,X_th_id integer

Line 110: UPDATE FA_BOOKS_MRC_V

106: * do with the problem except ANNUAL_DEPRN_ROUNDING_FLAG.
107: */
108: if (X_mrc_sob_type_code = 'R') then
109:
110: UPDATE FA_BOOKS_MRC_V
111: SET DATE_INEFFECTIVE = X_sysdate,
112: TRANSACTION_HEADER_ID_OUT = X_th_id,
113: LAST_UPDATE_DATE = X_sysdate,
114: LAST_UPDATED_BY = NVL (X_user_id, -1),

Line 120: INSERT INTO FA_BOOKS_MRC_V (

116: WHERE ASSET_ID = X_asset_id
117: AND BOOK_TYPE_CODE = X_book
118: AND DATE_INEFFECTIVE IS NULL;
119:
120: INSERT INTO FA_BOOKS_MRC_V (
121: BOOK_TYPE_CODE, ASSET_ID,
122: DATE_PLACED_IN_SERVICE, DATE_EFFECTIVE,
123: DEPRN_START_DATE, DEPRN_METHOD_CODE,
124: LIFE_IN_MONTHS, RATE_ADJUSTMENT_FACTOR,

Line 193: FROM FA_BOOKS BKS

189: ORIGINAL_DEPRN_START_DATE,
190: REMAINING_LIFE1, REMAINING_LIFE2,
191: OLD_ADJUSTED_COST, FORMULA_FACTOR,
192: SALVAGE_TYPE, DEPRN_LIMIT_TYPE
193: FROM FA_BOOKS BKS
194: WHERE ASSET_ID = X_asset_id
195: AND BOOK_TYPE_CODE = X_book
196: AND TRANSACTION_HEADER_ID_OUT = X_th_id;
197:

Line 200: UPDATE FA_BOOKS

196: AND TRANSACTION_HEADER_ID_OUT = X_th_id;
197:
198: else
199:
200: UPDATE FA_BOOKS
201: SET DATE_INEFFECTIVE = X_sysdate,
202: TRANSACTION_HEADER_ID_OUT = X_th_id,
203: LAST_UPDATE_DATE = X_sysdate,
204: LAST_UPDATED_BY = NVL (X_user_id, -1),

Line 210: INSERT INTO FA_BOOKS (

206: WHERE ASSET_ID = X_asset_id
207: AND BOOK_TYPE_CODE = X_book
208: AND DATE_INEFFECTIVE IS NULL;
209:
210: INSERT INTO FA_BOOKS (
211: BOOK_TYPE_CODE, ASSET_ID,
212: DATE_PLACED_IN_SERVICE, DATE_EFFECTIVE,
213: DEPRN_START_DATE, DEPRN_METHOD_CODE,
214: LIFE_IN_MONTHS, RATE_ADJUSTMENT_FACTOR,

Line 283: FROM FA_BOOKS BKS

279: ORIGINAL_DEPRN_START_DATE,
280: REMAINING_LIFE1, REMAINING_LIFE2,
281: OLD_ADJUSTED_COST, FORMULA_FACTOR,
282: SALVAGE_TYPE, DEPRN_LIMIT_TYPE
283: FROM FA_BOOKS BKS
284: WHERE ASSET_ID = X_asset_id
285: AND BOOK_TYPE_CODE = X_book
286: AND TRANSACTION_HEADER_ID_OUT = X_th_id;
287:

Line 303: ,X_asset_id fa_books.asset_id%type

299: Function fautgpr
300: (
301: X_old_deprn_rsv_taken OUT NOCOPY number
302: ,X_old_adj_cost OUT NOCOPY number
303: ,X_asset_id fa_books.asset_id%type
304: ,X_book fa_book_controls.book_type_code%type
305: ,X_period_ctr integer
306: ,X_mrc_sob_type_code varchar2
307: )

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: if deprn_basis_rule = fa_std_types.FAD_DBR_COST then
670: if (X_was_fully_rsv and new_deprn_rsv < X_fin_info_ptr.rec_cost) then

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

844: new_adj_cost := new_adj_cost + nvl(dpr.ytd_deprn, 0) - nvl(l_signed_adj_amount, 0);
845: end if;
846:
847: /*
848: * terminate the current FA_BOOKS row; and insert a new one, with
849: * the updated adjusted cost and rate adjustment factor
850: * we only do this for assets with an NBV-based deprn method
851: * and if this is not the year of adjustment
852: */

Line 921: ,X_salvage_value fa_books.salvage_value%type

917: ,X_current_units fa_additions.current_units%type
918: ,X_asset_category_id fa_additions.asset_category_id%type
919: ,X_asset_type fa_additions.asset_type%type
920: ,X_new_cost number
921: ,X_salvage_value fa_books.salvage_value%type
922: ,X_new_recoverable_cost number
923: ,X_recoverable_cost fa_books.recoverable_cost%type
924: ,X_adjusted_rate fa_books.adjusted_rate%type
925: ,X_ceiling_name fa_books.ceiling_name%type

Line 923: ,X_recoverable_cost fa_books.recoverable_cost%type

919: ,X_asset_type fa_additions.asset_type%type
920: ,X_new_cost number
921: ,X_salvage_value fa_books.salvage_value%type
922: ,X_new_recoverable_cost number
923: ,X_recoverable_cost fa_books.recoverable_cost%type
924: ,X_adjusted_rate fa_books.adjusted_rate%type
925: ,X_ceiling_name fa_books.ceiling_name%type
926: ,X_bonus_rule fa_books.bonus_rule%type
927: ,X_deprn_method_code fa_books.deprn_method_code%type

Line 924: ,X_adjusted_rate fa_books.adjusted_rate%type

920: ,X_new_cost number
921: ,X_salvage_value fa_books.salvage_value%type
922: ,X_new_recoverable_cost number
923: ,X_recoverable_cost fa_books.recoverable_cost%type
924: ,X_adjusted_rate fa_books.adjusted_rate%type
925: ,X_ceiling_name fa_books.ceiling_name%type
926: ,X_bonus_rule fa_books.bonus_rule%type
927: ,X_deprn_method_code fa_books.deprn_method_code%type
928: ,X_life_in_months fa_books.life_in_months%type

Line 925: ,X_ceiling_name fa_books.ceiling_name%type

921: ,X_salvage_value fa_books.salvage_value%type
922: ,X_new_recoverable_cost number
923: ,X_recoverable_cost fa_books.recoverable_cost%type
924: ,X_adjusted_rate fa_books.adjusted_rate%type
925: ,X_ceiling_name fa_books.ceiling_name%type
926: ,X_bonus_rule fa_books.bonus_rule%type
927: ,X_deprn_method_code fa_books.deprn_method_code%type
928: ,X_life_in_months fa_books.life_in_months%type
929: ,X_date_placed_in_service fa_books.date_placed_in_service%type

Line 926: ,X_bonus_rule fa_books.bonus_rule%type

922: ,X_new_recoverable_cost number
923: ,X_recoverable_cost fa_books.recoverable_cost%type
924: ,X_adjusted_rate fa_books.adjusted_rate%type
925: ,X_ceiling_name fa_books.ceiling_name%type
926: ,X_bonus_rule fa_books.bonus_rule%type
927: ,X_deprn_method_code fa_books.deprn_method_code%type
928: ,X_life_in_months fa_books.life_in_months%type
929: ,X_date_placed_in_service fa_books.date_placed_in_service%type
930: ,X_prorate_date fa_books.prorate_date%type

Line 927: ,X_deprn_method_code fa_books.deprn_method_code%type

923: ,X_recoverable_cost fa_books.recoverable_cost%type
924: ,X_adjusted_rate fa_books.adjusted_rate%type
925: ,X_ceiling_name fa_books.ceiling_name%type
926: ,X_bonus_rule fa_books.bonus_rule%type
927: ,X_deprn_method_code fa_books.deprn_method_code%type
928: ,X_life_in_months fa_books.life_in_months%type
929: ,X_date_placed_in_service fa_books.date_placed_in_service%type
930: ,X_prorate_date fa_books.prorate_date%type
931: ,X_deprn_start_date fa_books.deprn_start_date%type

Line 928: ,X_life_in_months fa_books.life_in_months%type

924: ,X_adjusted_rate fa_books.adjusted_rate%type
925: ,X_ceiling_name fa_books.ceiling_name%type
926: ,X_bonus_rule fa_books.bonus_rule%type
927: ,X_deprn_method_code fa_books.deprn_method_code%type
928: ,X_life_in_months fa_books.life_in_months%type
929: ,X_date_placed_in_service fa_books.date_placed_in_service%type
930: ,X_prorate_date fa_books.prorate_date%type
931: ,X_deprn_start_date fa_books.deprn_start_date%type
932: ,X_depreciate_flag fa_books.depreciate_flag%type

Line 929: ,X_date_placed_in_service fa_books.date_placed_in_service%type

925: ,X_ceiling_name fa_books.ceiling_name%type
926: ,X_bonus_rule fa_books.bonus_rule%type
927: ,X_deprn_method_code fa_books.deprn_method_code%type
928: ,X_life_in_months fa_books.life_in_months%type
929: ,X_date_placed_in_service fa_books.date_placed_in_service%type
930: ,X_prorate_date fa_books.prorate_date%type
931: ,X_deprn_start_date fa_books.deprn_start_date%type
932: ,X_depreciate_flag fa_books.depreciate_flag%type
933: ,X_production_capacity fa_books.production_capacity%type

Line 930: ,X_prorate_date fa_books.prorate_date%type

926: ,X_bonus_rule fa_books.bonus_rule%type
927: ,X_deprn_method_code fa_books.deprn_method_code%type
928: ,X_life_in_months fa_books.life_in_months%type
929: ,X_date_placed_in_service fa_books.date_placed_in_service%type
930: ,X_prorate_date fa_books.prorate_date%type
931: ,X_deprn_start_date fa_books.deprn_start_date%type
932: ,X_depreciate_flag fa_books.depreciate_flag%type
933: ,X_production_capacity fa_books.production_capacity%type
934: ,X_book_type_code fa_books.book_type_code%type

Line 931: ,X_deprn_start_date fa_books.deprn_start_date%type

927: ,X_deprn_method_code fa_books.deprn_method_code%type
928: ,X_life_in_months fa_books.life_in_months%type
929: ,X_date_placed_in_service fa_books.date_placed_in_service%type
930: ,X_prorate_date fa_books.prorate_date%type
931: ,X_deprn_start_date fa_books.deprn_start_date%type
932: ,X_depreciate_flag fa_books.depreciate_flag%type
933: ,X_production_capacity fa_books.production_capacity%type
934: ,X_book_type_code fa_books.book_type_code%type
935: ,X_transaction_header_id fa_transaction_headers.transaction_header_id%type

Line 932: ,X_depreciate_flag fa_books.depreciate_flag%type

928: ,X_life_in_months fa_books.life_in_months%type
929: ,X_date_placed_in_service fa_books.date_placed_in_service%type
930: ,X_prorate_date fa_books.prorate_date%type
931: ,X_deprn_start_date fa_books.deprn_start_date%type
932: ,X_depreciate_flag fa_books.depreciate_flag%type
933: ,X_production_capacity fa_books.production_capacity%type
934: ,X_book_type_code fa_books.book_type_code%type
935: ,X_transaction_header_id fa_transaction_headers.transaction_header_id%type
936: ,X_rate_adjustment_factor fa_books.rate_adjustment_factor%type

Line 933: ,X_production_capacity fa_books.production_capacity%type

929: ,X_date_placed_in_service fa_books.date_placed_in_service%type
930: ,X_prorate_date fa_books.prorate_date%type
931: ,X_deprn_start_date fa_books.deprn_start_date%type
932: ,X_depreciate_flag fa_books.depreciate_flag%type
933: ,X_production_capacity fa_books.production_capacity%type
934: ,X_book_type_code fa_books.book_type_code%type
935: ,X_transaction_header_id fa_transaction_headers.transaction_header_id%type
936: ,X_rate_adjustment_factor fa_books.rate_adjustment_factor%type
937: ,X_reval_amortization_basis fa_books.reval_amortization_basis%type

Line 934: ,X_book_type_code fa_books.book_type_code%type

930: ,X_prorate_date fa_books.prorate_date%type
931: ,X_deprn_start_date fa_books.deprn_start_date%type
932: ,X_depreciate_flag fa_books.depreciate_flag%type
933: ,X_production_capacity fa_books.production_capacity%type
934: ,X_book_type_code fa_books.book_type_code%type
935: ,X_transaction_header_id fa_transaction_headers.transaction_header_id%type
936: ,X_rate_adjustment_factor fa_books.rate_adjustment_factor%type
937: ,X_reval_amortization_basis fa_books.reval_amortization_basis%type
938: ,X_old_deprn_rsv number

Line 936: ,X_rate_adjustment_factor fa_books.rate_adjustment_factor%type

932: ,X_depreciate_flag fa_books.depreciate_flag%type
933: ,X_production_capacity fa_books.production_capacity%type
934: ,X_book_type_code fa_books.book_type_code%type
935: ,X_transaction_header_id fa_transaction_headers.transaction_header_id%type
936: ,X_rate_adjustment_factor fa_books.rate_adjustment_factor%type
937: ,X_reval_amortization_basis fa_books.reval_amortization_basis%type
938: ,X_old_deprn_rsv number
939: ,X_new_deprn_rsv number
940: ,X_fiscal_year integer

Line 937: ,X_reval_amortization_basis fa_books.reval_amortization_basis%type

933: ,X_production_capacity fa_books.production_capacity%type
934: ,X_book_type_code fa_books.book_type_code%type
935: ,X_transaction_header_id fa_transaction_headers.transaction_header_id%type
936: ,X_rate_adjustment_factor fa_books.rate_adjustment_factor%type
937: ,X_reval_amortization_basis fa_books.reval_amortization_basis%type
938: ,X_old_deprn_rsv number
939: ,X_new_deprn_rsv number
940: ,X_fiscal_year integer
941: ,X_period_counter_rsv integer

Line 1082: from fa_books bk

1078: fin_info.cost - bk.allowed_deprn_limit_amount)),
1079: fin_info.cost * bk.allowed_deprn_limit),
1080: bk.formula_factor
1081: into fin_info.old_cost, fin_info.adj_rec_cost, fin_info.formula_factor
1082: from fa_books bk
1083: where bk.asset_id = fin_info.asset_id
1084: and bk.book_type_code = fin_info.book
1085: and bk.date_ineffective is NULL;
1086:

Line 1148: from fa_books_mrc_v bk

1144: fin_info.cost - bk.allowed_deprn_limit_amount)),
1145: fin_info.cost * bk.allowed_deprn_limit),
1146: bk.formula_factor
1147: into fin_info.old_cost, fin_info.adj_rec_cost, fin_info.formula_factor
1148: from fa_books_mrc_v bk
1149: where bk.asset_id = fin_info.asset_id
1150: and bk.book_type_code = fin_info.book
1151: and bk.date_ineffective is NULL;
1152: