APPS.FA_RETIREMENT_PVT dependencies on FA_MC_BOOKS_SUMMARY

Line 4608: UPDATE FA_MC_BOOKS_SUMMARY

4604: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4605: AND TRANSACTION_HEADER_ID_OUT is null
4606: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
4607:
4608: UPDATE FA_MC_BOOKS_SUMMARY
4609: SET TERMINAL_GAIN_LOSS_FLAG = 'Y'
4610: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
4611: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4612: AND PERIOD_COUNTER = p_period_rec.period_counter

Line 4781: FROM FA_MC_BOOKS_SUMMARY

4777: AND PERIOD_COUNTER = p_period_rec.period_counter;
4778:
4779: CURSOR C_MC_GET_BS_SUM_ADJ_COST IS
4780: SELECT SUM(ADJUSTED_COST)
4781: FROM FA_MC_BOOKS_SUMMARY
4782: WHERE BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4783: AND TRANSACTION_HEADER_ID_OUT is null
4784: AND nvl(FULLY_RESERVED_FLAG, 'N') = 'N'
4785: AND nvl(FULLY_RETIRED_FLAG, 'N') = 'N'

Line 5817: UPDATE FA_MC_BOOKS_SUMMARY

5813: l_loc := 'Before MRC BS';
5814: -- Update FA_MC_BOOKS_SUMAMRY table with new reserve adjustment amount and
5815: -- related columns. Return new adjusted_cost and deprn reserve for later use
5816: FORALL i in t_asset_id.first..t_asset_id.last
5817: UPDATE FA_MC_BOOKS_SUMMARY
5818: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjustment_amount(i)
5819: , DEPRN_RESERVE = DEPRN_RESERVE + t_adjustment_amount(i)
5820: , ADJUSTED_COST = RECOVERABLE_COST - DEPRN_RESERVE - t_adjustment_amount(i)
5821: WHERE ASSET_ID = t_asset_id(i)

Line 6463: UPDATE FA_MC_BOOKS_SUMMARY

6459: AND TRANSACTION_HEADER_ID = l_last_thid
6460: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id)
6461: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
6462:
6463: UPDATE FA_MC_BOOKS_SUMMARY
6464: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + ( l_reallocate_amount * sign(p_reserve_amount) * -1 )
6465: , DEPRN_RESERVE = DEPRN_RESERVE + ( l_reallocate_amount * sign(p_reserve_amount) * -1 )
6466: , ADJUSTED_COST = ADJUSTED_COST - ( l_reallocate_amount * sign(p_reserve_amount) * -1 )
6467: WHERE ASSET_ID = l_last_asset_id

Line 6588: UPDATE FA_MC_BOOKS_SUMMARY

6584: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6585: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id
6586: AND TRANSACTION_HEADER_ID = t_thid(i));
6587:
6588: UPDATE FA_MC_BOOKS_SUMMARY
6589: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + (l_reallocate_amount * sign(p_reserve_amount) * -1)
6590: , DEPRN_RESERVE = DEPRN_RESERVE + (l_reallocate_amount * sign(p_reserve_amount) * -1)
6591: , ADJUSTED_COST = ADJUSTED_COST + l_reallocate_amount
6592: WHERE ASSET_ID = t_asset_id(i)

Line 6652: UPDATE FA_MC_BOOKS_SUMMARY

6648: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6649: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id
6650: AND TRANSACTION_HEADER_ID = t_thid(i));
6651:
6652: UPDATE FA_MC_BOOKS_SUMMARY
6653: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjusted_cost(i)
6654: , DEPRN_RESERVE = ADJUSTED_RECOVERABLE_COST
6655: , ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST
6656: WHERE ASSET_ID = t_asset_id(i)