APPS.FA_MC_UPG2_PKG dependencies on FA_DEPRN_DETAIL

Line 1773: fa_deprn_detail

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
1772: reserve correctly as it is then used in converting and rounding
1773: fa_deprn_detail
1774: ************************************************************************ */
1775:
1776: l_last_asset_id number;
1777: l_last_deprn_rsv number;

Line 2393: This procedure will convert the rows in fa_deprn_detail for the

2389: p_book_type_code IN VARCHAR2,
2390: p_mau IN NUMBER,
2391: p_precision IN NUMBER) IS
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,

Line 2394: candidate assets. Candidate assets will have rows in fa_deprn_detail

2390: p_mau IN NUMBER,
2391: p_precision IN NUMBER) IS
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

Line 2396: fa_deprn_summary. All fa_deprn_detail rows will be fetched one by one

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

Line 2461: -- cursor to select all rows from fa_deprn_detail

2457: l_deprn_reserve_ccid number;
2458: l_reval_amort_ccid number;
2459: l_reval_reserve_ccid number;
2460:
2461: -- cursor to select all rows from fa_deprn_detail
2462: CURSOR dd_row IS
2463: SELECT /*+ ordered leading(cr)
2464: index(ds fa_mc_deprn_summary_u1)
2465: index(dd fa_deprn_detail_n1)

Line 2465: index(dd fa_deprn_detail_n1)

2461: -- cursor to select all rows from fa_deprn_detail
2462: CURSOR dd_row IS
2463: SELECT /*+ ordered leading(cr)
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)

Line 2538: fa_deprn_detail dd,

2534: dd.reval_amort_ccid,
2535: dd.reval_reserve_ccid
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,

Line 2586: 'Converting FA_DEPRN_DETAIL records',

2582: BEGIN
2583:
2584: if (g_print_debug) then
2585: fa_debug_pkg.add('convert_assets',
2586: 'Converting FA_DEPRN_DETAIL records',
2587: 'start');
2588: end if;
2589:
2590: OPEN dd_row;

Line 2811: 'Converted FA_DEPRN_DETAIL records',

2807: CLOSE dd_row;
2808:
2809: if (g_print_debug) then
2810: fa_debug_pkg.add('convert_assets',
2811: 'Converted FA_DEPRN_DETAIL records',
2812: 'success');
2813: end if;
2814:
2815: EXCEPTION