APPS.FA_MC_UPG2_PKG dependencies on FA_DEPRN_DETAIL

Line 1682: fa_deprn_detail

1678: first period_counter in the current year are also calulated the same way.
1679: For subsequent period counters the deprn_amount for current period is
1680: added to deprn_reserve of previous period. This is necessary to round
1681: reserve correctly as it is then used in converting and rounding
1682: fa_deprn_detail
1683: ************************************************************************ */
1684:
1685: l_last_asset_id number;
1686: l_last_deprn_rsv number;

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

2289: p_book_type_code IN VARCHAR2,
2290: p_mau IN NUMBER,
2291: p_precision IN NUMBER) IS
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,

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

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

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

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

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

2351: l_je_header_id number;
2352: l_ytd_reval_deprn_expense number;
2353: l_prev_ytd_deprn number;
2354:
2355: -- cursor to select all rows from fa_deprn_detail
2356: CURSOR dd_row IS
2357: SELECT /*+ ordered leading(cr)
2358: index(ds fa_mc_deprn_summary_u1)
2359: index(dd fa_deprn_detail_n1)

Line 2359: index(dd fa_deprn_detail_n1)

2355: -- cursor to select all rows from fa_deprn_detail
2356: CURSOR dd_row IS
2357: SELECT /*+ ordered leading(cr)
2358: index(ds fa_mc_deprn_summary_u1)
2359: index(dd fa_deprn_detail_n1)
2360: index(dh fa_distribution_history_u1)
2361: index(dp fa_deprn_periods_u3)
2362: index(bk fa_books_n1)
2363: index(mcbk fa_mc_books_u1)

Line 2426: fa_deprn_detail dd,

2422: ds.deprn_amount,
2423: dd.deprn_run_date
2424: FROM
2425: fa_mc_deprn_summary ds,
2426: fa_deprn_detail dd,
2427: fa_deprn_periods dp,
2428: fa_books bk,
2429: fa_mc_books mcbk,
2430: fa_distribution_history dh,

Line 2474: 'Converting FA_DEPRN_DETAIL records',

2470: BEGIN
2471:
2472: if (g_print_debug) then
2473: fa_debug_pkg.add('convert_assets',
2474: 'Converting FA_DEPRN_DETAIL records',
2475: 'start');
2476: end if;
2477:
2478: OPEN dd_row;

Line 2680: 'Converted FA_DEPRN_DETAIL records',

2676: CLOSE dd_row;
2677:
2678: if (g_print_debug) then
2679: fa_debug_pkg.add('convert_assets',
2680: 'Converted FA_DEPRN_DETAIL records',
2681: 'success');
2682: end if;
2683:
2684: EXCEPTION