[Home] [Help]
123: , 0 reval_loss_balance
124: FROM fa_additions_b ad,
125: fa_methods mt,
126: fa_books bk,
127: fa_itf_impairments imp
128: WHERE bk.book_type_code = p_book_type_code
129: AND (bk.period_counter_fully_retired is null OR
130: bk.adjustment_required_status <> 'NONE')
131: --phase5 AND bk.depreciate_flag = 'YES'
1118: , REVAL_LOSS_BALANCE = t_reval_loss_balance(i)
1119: WHERE ROWID = t_imp_rowid(i);
1120: else
1121: FORALL i in 1..t_asset_id.count
1122: UPDATE FA_ITF_IMPAIRMENTS
1123: SET NET_BOOK_VALUE = t_net_book_value(i)
1124: , YTD_IMPAIRMENT = t_ytd_impairment(i)
1125: , impairment_reserve = t_impairment_reserve(i)
1126: , DEPRN_RUN_DATE = t_deprn_run_date(i)
1231: , nvl(books.sorp_enabled_flag, 'N') -- Bug 6666666
1232: , imp.net_selling_price --Bug# 7511258
1233: , imp.value_in_use --Bug# 7511258
1234: from fa_impairments imp
1235: , fa_itf_impairments itf
1236: , fa_book_controls books
1237: where imp.request_id = p_request_id
1238: and imp.book_type_code = p_book_type_code
1239: and imp.impairment_id = itf.impairment_id
1283: , imp.value_in_use; --Bug# 7511258
1284:
1285: CURSOR c_get_sum(c_impairment_id number) IS
1286: select sum(impairment_amount)
1287: from fa_itf_impairments
1288: where impairment_id = c_impairment_id
1289: and nvl(goodwill_asset_flag, 'N') <> 'Y';
1290:
1291: CURSOR c_mc_get_sum(c_impairment_id number) IS
1300: , net_book_value
1301: , impairment_amount
1302: , ytd_impairment
1303: , impairment_reserve
1304: from fa_itf_impairments
1305: where impairment_id = c_impairment_id
1306: and net_book_value <> 0
1307: and nvl(goodwill_asset_flag, 'N') <> 'Y';
1308:
1322: --in the same request.
1323: /*Bug#9182681 - Modified for CGU) */
1324: CURSOR c_get_itf(c_asset_id number,c_cgu_id number) is
1325: select impairment_id
1326: from fa_itf_impairments
1327: where request_id = p_request_id
1328: and (asset_id = c_asset_id or cash_generating_unit_id = c_cgu_id) order by impairment_id;
1329:
1330: CURSOR c_mc_get_itf(c_asset_id number,c_cgu_id number) is
1484: --
1485: -- Allocate
1486: --
1487: if (p_log_level_rec.statement_level) then
1488: fa_debug_pkg.add(l_calling_fn,'Updating', 'FA_ITF_IMPAIRMENTS', p_log_level_rec => p_log_level_rec);
1489: end if;
1490:
1491: if (p_mrc_sob_type_code = 'R') then
1492: FORALL i in 1..t_impairment_id.count
1519: AND set_of_books_id = p_set_of_books_id;
1520:
1521: else
1522: FORALL i in 1..t_impairment_id.count
1523: UPDATE FA_ITF_IMPAIRMENTS ITF
1524: SET IMPAIRMENT_AMOUNT = least(round(t_impairment_amount(i) *
1525: (NET_BOOK_VALUE/t_net_book_value(i)), l_precision),
1526: NET_BOOK_VALUE)
1527: , YTD_IMPAIRMENT = YTD_IMPAIRMENT + least(round(t_impairment_amount(i) *
1539: WHERE IMPAIRMENT_ID = t_impairment_id(i)
1540: AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
1541: AND t_net_book_value(i) <> 0; -- Bug# 6920854
1542: FORALL i in 1..t_impairment_id.count
1543: UPDATE FA_ITF_IMPAIRMENTS ITF
1544: SET NET_BOOK_VALUE = COST - DEPRN_RESERVE - impairment_reserve
1545: WHERE IMPAIRMENT_ID = t_impairment_id(i)
1546: AND GOODWILL_ASSET_FLAG = 'Y';
1547:
1683: , NET_BOOK_VALUE = ti_net_book_value(j)
1684: WHERE ROWID = ti_rowid(j);
1685: else
1686: FORALL j in 1..ti_rowid.count
1687: UPDATE FA_ITF_IMPAIRMENTS
1688: SET IMPAIRMENT_AMOUNT = ti_impairment_amount(j)
1689: , YTD_IMPAIRMENT = ti_ytd_impairment(j)
1690: , impairment_reserve = ti_impairment_reserve(j)
1691: , NET_BOOK_VALUE = ti_net_book_value(j)
1720: --
1721: -- Adjusting impairment amount and reval reserve
1722: --
1723: if (p_log_level_rec.statement_level) then
1724: fa_debug_pkg.add(l_calling_fn,'Updating impairment for reval', 'FA_ITF_IMPAIRMENTS', p_log_level_rec => p_log_level_rec);
1725: end if;
1726:
1727: if (p_mrc_sob_type_code = 'R') then
1728: FORALL i in 1..t_impairment_id.count
1738: AND set_of_books_id = p_set_of_books_id; -- Bug 6666666
1739:
1740: else
1741: FORALL i in 1..t_impairment_id.count
1742: UPDATE FA_ITF_IMPAIRMENTS ITF
1743: SET IMPAIRMENT_AMOUNT = IMPAIRMENT_AMOUNT - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
1744: , YTD_IMPAIRMENT = YTD_IMPAIRMENT - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
1745: , REVAL_RESERVE = REVAL_RESERVE - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
1746: , REVAL_RESERVE_ADJ_AMOUNT = least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
1792: --Bug# 7045739 end
1793: else
1794: --Bug# 7045739 start - when impairment_amount > NBV,basically to sync Asset Impairment report and Preview form.
1795: FORALL i in 1..t_impairment_id.count
1796: UPDATE FA_ITF_IMPAIRMENTS ITF
1797: SET DEPRN_RESERVE = DEPRN_RESERVE + (nvl(impairment_reserve,0) - NET_BOOK_VALUE),
1798: IMPAIRMENT_AMOUNT = t_impairment_amount(i),
1799: impairment_reserve = t_impairment_amount(i),
1800: NET_BOOK_VALUE = t_net_book_value(i)
1802: AND p_nbv(i) =0;
1803:
1804: --To set status to deprn failed when multiple rows are uploaded for an asset.
1805: FORALL i in 1..t_impairment_id.count
1806: UPDATE FA_ITF_IMPAIRMENTS ITF
1807: SET PERIOD_OF_ADDITION_FLAG = 'F'
1808: WHERE IMPAIRMENT_ID = t_impairment_id(i)
1809: AND p_nbv(i) in (-1,-2,-3,-4) ; --Bug#7594562 Added -2
1810: --Bug# 7045739 end
3264: SELECT
3265: imp.asset_id
3266: , imp.impairment_amount
3267: , imp.rowid
3268: FROM fa_itf_impairments imp
3269: WHERE imp.book_type_code = p_book_type_code
3270: AND imp.request_id = p_request_id
3271: AND imp.period_counter <= p_period_rec.period_counter
3272: AND imp.worker_id = p_worker_id;
4050: --
4051: -- Store catchup amount
4052: --
4053: FORALL k in 1..t_asset_id.count
4054: UPDATE FA_ITF_IMPAIRMENTS
4055: SET DEPRN_ADJUSTMENT_AMOUNT = t_catchup(k)
4056: , ADJUSTED_COST = t_adjusted_cost(k)
4057: , RATE_ADJUSTMENT_FACTOR = t_raf(k)
4058: , FORMULA_FACTOR = t_formula_factor(k)