[Home] [Help]
1663: p_convert_order IN VARCHAR2,
1664: p_mau IN NUMBER,
1665: p_precision IN NUMBER) IS
1666: /* ************************************************************************
1667: This procedure converts rows in fa_deprn_summary for each asset and
1668: inserts them into fa_mc_deprn_summary. First it selects and converts
1669: the BOOKS row for all the assets. Then depending on the convert order of
1670: of F or L it converts the DEPRN rows for the assets. When the convert_order
1671: is F, all the DEPRN rows in current year are converted and when the
1670: of F or L it converts the DEPRN rows for the assets. When the convert_order
1671: is F, all the DEPRN rows in current year are converted and when the
1672: convert_order is L, only the last DEPRN in a prior fiscal year is
1673: converted.
1674: The rows in fa_deprn_summary are fetched one at a time and ordered by
1675: asset_id and period_counter. The deprn_amount column for pc is
1676: calculated using a ratio of cost in fa_mc_books * cost in fa_books/
1677: deprn_amount in primary currency. deprn_reserve and ytd_deprn for the
1678: first period_counter in the current year are also calulated the same way.
1809: decode(bk.cost,0,1,bk.cost))) /
1810: p_mau) * p_mau),
1811: ds.deprn_reserve
1812: FROM
1813: fa_deprn_summary ds,
1814: fa_deprn_periods dp,
1815: fa_mc_books mcbk,
1816: fa_books bk,
1817: fa_mc_conversion_rates cr
1844: BEGIN
1845:
1846: if (g_print_debug) then
1847: fa_debug_pkg.add('convert_assets',
1848: 'Converting FA_DEPRN_SUMMARY records',
1849: 'start');
1850: fa_debug_pkg.add('Convert_summary','convert_order',
1851: p_convert_order);
1852: end if;
1966: decode(bk.cost,0,1,bk.cost))) /
1967: p_mau) * p_mau),
1968: 'Y'
1969: FROM
1970: fa_deprn_summary ds,
1971: fa_deprn_periods dp,
1972: fa_mc_books mcbk,
1973: fa_books bk,
1974: fa_mc_conversion_rates cr
2239: decode(bk.cost,0,1,bk.cost))) /
2240: p_mau) * p_mau),
2241: 'Y'
2242: FROM
2243: fa_deprn_summary ds,
2244: fa_deprn_periods dp,
2245: fa_mc_books mcbk,
2246: fa_books bk,
2247: fa_mc_conversion_rates cr
2269: END IF;
2270:
2271: if (g_print_debug) then
2272: fa_debug_pkg.add('convert_assets',
2273: 'Converted FA_DEPRN_SUMMARY records',
2274: 'success');
2275: end if;
2276:
2277:
2292: /* ************************************************************************
2293: This procedure will convert the rows in fa_deprn_detail for the
2294: candidate assets. Candidate assets will have rows in fa_deprn_detail
2295: converted for the period_counters that were converted in
2296: fa_deprn_summary. All fa_deprn_detail rows will be fetched one by one
2297: and converted using logic similar to FAUPDD to round COST,
2298: DEPRN_RESERVE, REVAL_RESERVE and REVAL_AMORTIZATION to the active
2299: distributions at the end of a period. YTD_DEPRN will not be rounded
2300: as it is not used to post to GL and is used only for reporting. The