[Home] [Help]
196:
197: h_mesg_name := 'FA_WHATIF_ASSET_BOOKS';
198:
199: -- bug32118506
200: if (FARX_C_WD.mrc_sob_type in ('P','N')) then -- Enhancement Bug 3037321
201:
202: SELECT decode (mt.rate_source_rule,
203: 'CALCULATED', bk.prorate_date,
204: 'FORMULA', bk.prorate_date,
375: AND mt.method_code = bk.deprn_method_code
376: AND bk.book_type_code = X_book
377: AND bk.asset_id = X_asset_id
378: AND bk.transaction_header_id_out is null
379: AND bk.set_of_books_id = FARX_C_WD.sob_id
380: AND nvl (mt.life_in_months, -9999) = nvl (bk.life_in_months, -9999)
381: AND ad.asset_id = bk.asset_id;
382:
383: end if;
726: dpr_row.asset_id := X_asset_id;
727: dpr_row.book := X_book;
728: dpr_row.dist_id := 0;
729: --dpr_row.mrc_sob_type_code := 'P';
730: dpr_row.mrc_sob_type_code := FARX_C_WD.mrc_sob_type; -- Enhancement Bug 3037321
731: dpr_row.set_of_books_id := FARX_C_WD.sob_id;
732:
733: --fa_rx_conc_mesg_pkg.log('step 4');
734:
727: dpr_row.book := X_book;
728: dpr_row.dist_id := 0;
729: --dpr_row.mrc_sob_type_code := 'P';
730: dpr_row.mrc_sob_type_code := FARX_C_WD.mrc_sob_type; -- Enhancement Bug 3037321
731: dpr_row.set_of_books_id := FARX_C_WD.sob_id;
732:
733: --fa_rx_conc_mesg_pkg.log('step 4');
734:
735: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then
978:
979: if not fa_amort_pkg.faxama (fin_info,
980: h_new_raf, h_new_adj_cost, h_new_adj_capacity,
981: h_new_reval_amo_basis, h_new_salvage_value, h_new_formula_factor,0,
982: FALSE, 'P', FARX_C_WD.sob_id, h_deprn_exp,h_bonus_deprn_exp,h_current_time,0,0, null) then
983: fa_srvr_msg.add_message (calling_fn => 'fa_exp_pkg.fauama');
984:
985: fa_srvr_msg.get_message(mesg_count,mesg1,mesg2,mesg3,mesg4,
986: mesg5,mesg6,mesg7);
1027: dpr_row.asset_id := X_asset_id;
1028: dpr_row.book := X_book;
1029: dpr_row.dist_id := 0;
1030: --dpr_row.mrc_sob_type_code := 'P';
1031: dpr_row.mrc_sob_type_code := FARX_C_WD.mrc_sob_type; -- Enhancement Bug 3037321
1032: dpr_row.set_of_books_id := FARX_C_WD.sob_id;
1033:
1034: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then
1035: return (FALSE);
1028: dpr_row.book := X_book;
1029: dpr_row.dist_id := 0;
1030: --dpr_row.mrc_sob_type_code := 'P';
1031: dpr_row.mrc_sob_type_code := FARX_C_WD.mrc_sob_type; -- Enhancement Bug 3037321
1032: dpr_row.set_of_books_id := FARX_C_WD.sob_id;
1033:
1034: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then
1035: return (FALSE);
1036: end if;
1401: dpr_in.deprn_rounding_flag := 'ADJ'; -- Added as part of the bug 7290365. The Year end rounding was wrongly calculated.
1402: end if;
1403: --- BUG # 7193797: End of Addition
1404: /*Bug 8518086 intialized the Set of books ID to pass it in DPR_IN */
1405: dpr_in.set_of_books_id := FARX_C_WD.sob_id;
1406: ret := fa_cde_pkg.faxcde(dpr_in => dpr_in,
1407: dpr_arr => dpr_arr,
1408: dpr_out => dpr_out,
1409: fmode => h_fmode,
1750: -- SELECT CURRENT (BEFORE ADJUSTMENT) BOOK-LEVEL INFO
1751:
1752: h_mesg_name := 'FA_WHATIF_ASSET_DEPRN_INFO';
1753: -- bug32118506
1754: if(FARX_C_WD.mrc_sob_type in ('P','N')) then -- Enhancement Bug 3037321
1755:
1756: select cost, prorate_convention_code, deprn_method_code,
1757: life_in_months, basic_rate, adjusted_rate, salvage_value, bonus_rule,
1758: date_placed_in_service
1777: from fa_mc_books
1778: where asset_id = X_asset_id
1779: and book_type_code = X_book
1780: and transaction_header_id_out is null
1781: and set_of_books_id = FARX_C_WD.sob_id;
1782:
1783: end if;
1784:
1785: if (h_asset_key_id is not null) then
1887: -- Enhancement bug 3037321
1888: select currency_code
1889: into h_currency
1890: from gl_sets_of_books
1891: where set_of_books_id = FARX_C_WD.sob_id;
1892:
1893: h_count := 0;
1894: loop -- for each period
1895: