[Home] [Help]
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
1763: convert_order is L, only the last DEPRN in a prior fiscal year is
1943: fa_debug_pkg.add('Convert_summary','convert_order',
1944: p_convert_order);
1945: end if;
1946:
1947: INSERT INTO fa_mc_deprn_summary(set_of_books_id,
1948: book_type_code,
1949: asset_id,
1950: deprn_run_date,
1951: deprn_amount,
2173: l_last_reval_rsv := l_reval_reserve;
2174: l_last_ytd_reval_exp := l_ytd_reval_exp;
2175:
2176:
2177: INSERT INTO fa_mc_deprn_summary(set_of_books_id,
2178: book_type_code,
2179: asset_id,
2180: deprn_run_date,
2181: deprn_amount,
2221: l_deprn_override_flag);
2222: END LOOP;
2223: CLOSE ds_row;
2224: ELSIF (p_convert_order = 'L') THEN
2225: INSERT INTO fa_mc_deprn_summary(set_of_books_id,
2226: book_type_code,
2227: asset_id,
2228: deprn_run_date,
2229: deprn_amount,
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)
2466: index(dh fa_distribution_history_u1)
2467: index(dp fa_deprn_periods_u3)
2468: index(bk fa_books_n1)
2533: dd.deprn_reserve_ccid,
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,