eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_SORP_IMPAIRMENT_PVT dependencies on FA_ITF_IMPAIRMENTS

Line 439: from fa_itf_impairments

435: , ASSET_ID
436: , SPLIT1_IMPAIR_CLASS
437: , SPLIT2_IMPAIR_CLASS
438: , SPLIT3_IMPAIR_CLASS
439: from fa_itf_impairments
440: where impairment_id = c_impairment_id
441: and book_type_code = c_book_type_code
442: and nvl(goodwill_asset_flag, 'N') <> 'Y';
443:

Line 512: fa_debug_pkg.add(l_calling_fn,'Unexpected error at c_mc_impairment_details', 'FA_ITF_IMPAIRMENTS', p_log_level_rec => p_log_level_rec);

508:
509: IF t_asset_id.count = 0 THEN
510: fa_debug_pkg.add(l_calling_fn,'p_impairment_id', p_impairment_id, p_log_level_rec => p_log_level_rec);
511: fa_debug_pkg.add(l_calling_fn,'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
512: fa_debug_pkg.add(l_calling_fn,'Unexpected error at c_mc_impairment_details', 'FA_ITF_IMPAIRMENTS', p_log_level_rec => p_log_level_rec);
513: CLOSE c_mc_impairment_details;
514: RETURN FALSE;
515: END IF;
516:

Line 535: fa_debug_pkg.add(l_calling_fn,'Unexpected error at c_impairment_details', 'FA_ITF_IMPAIRMENTS', p_log_level_rec => p_log_level_rec);

531:
532: IF t_asset_id.count = 0 THEN
533: fa_debug_pkg.add(l_calling_fn,'p_impairment_id', p_impairment_id, p_log_level_rec => p_log_level_rec);
534: fa_debug_pkg.add(l_calling_fn,'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
535: fa_debug_pkg.add(l_calling_fn,'Unexpected error at c_impairment_details', 'FA_ITF_IMPAIRMENTS', p_log_level_rec => p_log_level_rec);
536: CLOSE c_impairment_details;
537: RETURN FALSE;
538: END IF;
539:

Line 741: UPDATE FA_ITF_IMPAIRMENTS ITF

737: AND asset_id = t_asset_id(i)
738: AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
739: and set_of_books_id = p_set_of_books_id;
740: ELSE
741: UPDATE FA_ITF_IMPAIRMENTS ITF
742: SET SPLIT1_LOSS_AMOUNT = l_split1_loss_amount
743: , SPLIT2_LOSS_AMOUNT = l_split2_loss_amount
744: , SPLIT3_LOSS_AMOUNT = l_split3_loss_amount
745: , CAPITAL_ADJUSTMENT = NVL(CAPITAL_ADJUSTMENT,0) + NVL(IMPAIRMENT_AMOUNT,0)

Line 761: fa_debug_pkg.add(l_calling_fn,'Updated FA_ITF_IMPAIRMENTS', 'UPDATED', p_log_level_rec => p_log_level_rec);

757: END IF;
758:
759: IF (p_log_level_rec.statement_level) THEN
760: fa_debug_pkg.add(l_calling_fn,'t_reval_reserve(i)', t_reval_reserve(i));
761: fa_debug_pkg.add(l_calling_fn,'Updated FA_ITF_IMPAIRMENTS', 'UPDATED', p_log_level_rec => p_log_level_rec);
762: END IF;
763:
764: ELSE -- t_reval_reserve(i) <> 0
765: IF t_reval_reserve(i) > 0 THEN

Line 818: UPDATE FA_ITF_IMPAIRMENTS ITF

814: AND asset_id = t_asset_id(i)
815: AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
816: and set_of_books_id = p_set_of_books_id;
817: ELSE
818: UPDATE FA_ITF_IMPAIRMENTS ITF
819: SET SPLIT1_LOSS_AMOUNT = t_split_process_order(j).split_loss_amount
820: - t_split_process_order(j).reval_reserve
821: , SPLIT1_REVAL_RESERVE = t_split_process_order(j).reval_reserve
822: , SPLIT1_PROCESS_ORDER = j

Line 842: UPDATE FA_ITF_IMPAIRMENTS ITF

838: AND asset_id = t_asset_id(i)
839: AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
840: and set_of_books_id = p_set_of_books_id;
841: ELSE
842: UPDATE FA_ITF_IMPAIRMENTS ITF
843: SET SPLIT2_LOSS_AMOUNT = t_split_process_order(j).split_loss_amount
844: - t_split_process_order(j).reval_reserve
845: , SPLIT2_REVAL_RESERVE = t_split_process_order(j).reval_reserve
846: , SPLIT2_PROCESS_ORDER = j

Line 866: UPDATE FA_ITF_IMPAIRMENTS ITF

862: AND asset_id = t_asset_id(i)
863: AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
864: and set_of_books_id = p_set_of_books_id;
865: ELSE
866: UPDATE FA_ITF_IMPAIRMENTS ITF
867: SET SPLIT3_LOSS_AMOUNT = t_split_process_order(j).split_loss_amount
868: - t_split_process_order(j).reval_reserve
869: , SPLIT3_REVAL_RESERVE = t_split_process_order(j).reval_reserve
870: , SPLIT3_PROCESS_ORDER = j

Line 898: UPDATE FA_ITF_IMPAIRMENTS ITF

894: AND asset_id = t_asset_id(i)
895: AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
896: and set_of_books_id = p_set_of_books_id;
897: ELSE
898: UPDATE FA_ITF_IMPAIRMENTS ITF
899: SET YTD_IMPAIRMENT = NVL(YTD_IMPAIRMENT,0) - (IMPAIRMENT_AMOUNT-
900: (NVL(SPLIT1_LOSS_AMOUNT,0) + NVL(SPLIT2_LOSS_AMOUNT,0) + NVL(SPLIT3_LOSS_AMOUNT,0)))
901: , IMPAIRMENT_AMOUNT = NVL(SPLIT1_LOSS_AMOUNT,0) + NVL(SPLIT2_LOSS_AMOUNT,0) + NVL(SPLIT3_LOSS_AMOUNT,0)
902: , REVAL_RESERVE_ADJ_AMOUNT = REVAL_RESERVE - t_reval_reserve(i)

Line 954: UPDATE FA_ITF_IMPAIRMENTS ITF

950: AND nvl(REVAL_RESERVE, 0) <> 0
951: AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
952: and set_of_books_id = p_set_of_books_id;
953: ELSE
954: UPDATE FA_ITF_IMPAIRMENTS ITF
955: SET
956: REVAL_RESERVE = NVL(REVAL_RESERVE,0) - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
957: , REVAL_RESERVE_ADJ_AMOUNT = least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
958: , CAPITAL_ADJUSTMENT = NVL(CAPITAL_ADJUSTMENT,0) + NVL(IMPAIRMENT_AMOUNT,0) - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)

Line 994: UPDATE FA_ITF_IMPAIRMENTS ITF

990: AND nvl(REVAL_RESERVE,0) = 0
991: AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
992: and set_of_books_id = p_set_of_books_id;
993: ELSE
994: UPDATE FA_ITF_IMPAIRMENTS ITF
995: SET CAPITAL_ADJUSTMENT = NVL(CAPITAL_ADJUSTMENT,0) + NVL(IMPAIRMENT_AMOUNT,0)
996: + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
997: , GENERAL_FUND = NVL(GENERAL_FUND,0) + NVL(IMPAIRMENT_AMOUNT,0)
998: + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)