[Home] [Help]
12: p_precision IN NUMBER) IS
13:
14: l_count number;
15: /* ************************************************************************
16: This procedure will select all the rows in fa_books for each asset being
17: converted and insert them into fa_mc_books. All amount columns will be
18: converted either with the exchange rate or a derived rate of
19: cost/primary_cur_cost based on the conversion basis of R or C.
20: The converted amounts will also be rounded using the precision and
24: BEGIN
25:
26: if (g_print_debug) then
27: fa_debug_pkg.add('convert_assets',
28: 'Converting FA_BOOKS records',
29: 'start');
30: end if;
31:
32: INSERT INTO fa_mc_books(
480: bk.terminal_gain_loss,
481: bk.terminal_gain_loss_flag,
482: bk.tracking_method
483: FROM
484: fa_books bk,
485: fa_mc_conversion_rates cr
486: WHERE
487: cr.asset_id = bk.asset_id AND
488: cr.set_of_books_id = p_rsob_id AND
491: cr.status = 'S';
492:
493: if (g_print_debug) then
494: fa_debug_pkg.add('convert_assets',
495: 'Converted FA_BOOKS records',
496: 'success');
497: end if;
498:
499:
772: p_precision IN NUMBER) IS
773: /* ************************************************************************
774: This procedure will insert a row for each asset converted to reporting
775: book. It will contain the transaction_header_id_in from the active row
776: fa_books at the time of conversion and has the rate that was used
777: to convert the asset transactions. This is the ratio of the cost in
778: reporting book divided by the cost in primary book. For assets that
779: have a cost of 0 we will use the exchange_rate as of the initial
780: conversion date for the Reporting Book
836: mcbk.last_update_login,
837: 'Y'
838: FROM
839: fa_mc_books mcbk,
840: fa_books bk,
841: fa_mc_conversion_rates cr
842:
843: WHERE
844: cr.status = 'S' AND
1763: convert_order is L, only the last DEPRN in a prior fiscal year is
1764: converted.
1765: The rows in fa_deprn_summary are fetched one at a time and ordered by
1766: asset_id and period_counter. The deprn_amount column for pc is
1767: calculated using a ratio of cost in fa_mc_books * cost in fa_books/
1768: deprn_amount in primary currency. deprn_reserve and ytd_deprn for the
1769: first period_counter in the current year are also calulated the same way.
1770: For subsequent period counters the deprn_amount for current period is
1771: added to deprn_reserve of previous period. This is necessary to round
1905: FROM
1906: fa_deprn_summary ds,
1907: fa_deprn_periods dp,
1908: fa_mc_books mcbk,
1909: fa_books bk,
1910: fa_mc_conversion_rates cr
1911: WHERE
1912: ds.asset_id = mcbk.asset_id AND
1913: cr.book_type_code = p_book_type_code AND
2064: FROM
2065: fa_deprn_summary ds,
2066: fa_deprn_periods dp,
2067: fa_mc_books mcbk,
2068: fa_books bk,
2069: fa_mc_conversion_rates cr
2070: WHERE
2071: ds.asset_id = mcbk.asset_id AND
2072: ds.deprn_source_code = 'BOOKS' AND
2342: FROM
2343: fa_deprn_summary ds,
2344: fa_deprn_periods dp,
2345: fa_mc_books mcbk,
2346: fa_books bk,
2347: fa_mc_conversion_rates cr
2348: WHERE
2349: cr.book_type_code = p_book_type_code AND
2350: cr.set_of_books_id = p_rsob_id AND
2464: index(ds fa_mc_deprn_summary_u1)
2465: index(dd fa_deprn_detail_n1)
2466: index(dh fa_distribution_history_u1)
2467: index(dp fa_deprn_periods_u3)
2468: index(bk fa_books_n1)
2469: index(mcbk fa_mc_books_u1)
2470: index(ah fa_asset_history_n2) */
2471: dd.book_type_code,
2472: dd.asset_id,
2536: FROM
2537: fa_mc_deprn_summary ds,
2538: fa_deprn_detail dd,
2539: fa_deprn_periods dp,
2540: fa_books bk,
2541: fa_mc_books mcbk,
2542: fa_distribution_history dh,
2543: fa_asset_history ah,
2544: fa_mc_conversion_rates cr