[Home] [Help]
1754: p_convert_order IN VARCHAR2,
1755: p_mau IN NUMBER,
1756: p_precision IN NUMBER) IS
1757: /* ************************************************************************
1758: This procedure converts rows in fa_deprn_summary for each asset and
1759: inserts them into fa_mc_deprn_summary. First it selects and converts
1760: the BOOKS row for all the assets. Then depending on the convert order of
1761: of F or L it converts the DEPRN rows for the assets. When the convert_order
1762: is F, all the DEPRN rows in current year are converted and when the
1761: of F or L it converts the DEPRN rows for the assets. When the convert_order
1762: is F, all the DEPRN rows in current year are converted and when the
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.
1902: p_mau) * p_mau),
1903: ds.deprn_reserve,
1904: ds.deprn_override_flag
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
1937: BEGIN
1938:
1939: if (g_print_debug) then
1940: fa_debug_pkg.add('convert_assets',
1941: 'Converting FA_DEPRN_SUMMARY records',
1942: 'start');
1943: fa_debug_pkg.add('Convert_summary','convert_order',
1944: p_convert_order);
1945: end if;
2061: p_mau) * p_mau),
2062: 'Y',
2063: ds.deprn_override_flag
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
2339: p_mau) * p_mau),
2340: 'Y',
2341: ds.deprn_override_flag
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
2369: END IF;
2370:
2371: if (g_print_debug) then
2372: fa_debug_pkg.add('convert_assets',
2373: 'Converted FA_DEPRN_SUMMARY records',
2374: 'success');
2375: end if;
2376:
2377:
2392: /* ************************************************************************
2393: This procedure will convert the rows in fa_deprn_detail for the
2394: candidate assets. Candidate assets will have rows in fa_deprn_detail
2395: converted for the period_counters that were converted in
2396: fa_deprn_summary. All fa_deprn_detail rows will be fetched one by one
2397: and converted using logic similar to FAUPDD to round COST,
2398: DEPRN_RESERVE, REVAL_RESERVE and REVAL_AMORTIZATION to the active
2399: distributions at the end of a period. YTD_DEPRN will not be rounded
2400: as it is not used to post to GL and is used only for reporting. The