APPS.FA_RETIREMENT_PVT dependencies on FA_BOOKS_SUMMARY

Line 4635: UPDATE FA_BOOKS_SUMMARY

4631: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
4632: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4633: AND TRANSACTION_HEADER_ID_OUT is null;
4634:
4635: UPDATE FA_BOOKS_SUMMARY
4636: SET TERMINAL_GAIN_LOSS_FLAG = 'Y'
4637: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
4638: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4639: AND PERIOD_COUNTER = p_period_rec.period_counter;

Line 4770: FROM FA_BOOKS_SUMMARY

4766: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
4767:
4768: CURSOR C_GET_BS_SUM_ADJ_COST IS
4769: SELECT SUM(ADJUSTED_COST)
4770: FROM FA_BOOKS_SUMMARY
4771: WHERE BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4772: AND TRANSACTION_HEADER_ID_OUT is null
4773: AND nvl(FULLY_RESERVED_FLAG, 'N') = 'N'
4774: AND nvl(FULLY_RETIRED_FLAG, 'N') = 'N'

Line 6078: UPDATE FA_BOOKS_SUMMARY

6074: l_loc := 'Before BS';
6075: -- Update FA_BOOKS_SUMAMRY table with new reserve adjustment amount and
6076: -- related columns. Return new adjusted_cost and deprn reserve for later use
6077: FORALL i in t_asset_id.first..t_asset_id.last
6078: UPDATE FA_BOOKS_SUMMARY
6079: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjustment_amount(i)
6080: , DEPRN_RESERVE = DEPRN_RESERVE + t_adjustment_amount(i)
6081: , ADJUSTED_COST = RECOVERABLE_COST - DEPRN_RESERVE - t_adjustment_amount(i)
6082: WHERE ASSET_ID = t_asset_id(i)

Line 6490: UPDATE FA_BOOKS_SUMMARY

6486: WHERE ASSET_ID = l_last_asset_id
6487: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6488: AND TRANSACTION_HEADER_ID = l_last_thid);
6489:
6490: UPDATE FA_BOOKS_SUMMARY
6491: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + ( l_reallocate_amount * sign(p_reserve_amount) * -1 )
6492: , DEPRN_RESERVE = DEPRN_RESERVE + ( l_reallocate_amount * sign(p_reserve_amount) * -1 )
6493: , ADJUSTED_COST = ADJUSTED_COST - ( l_reallocate_amount * sign(p_reserve_amount) * -1 )
6494: WHERE ASSET_ID = l_last_asset_id

Line 6619: UPDATE FA_BOOKS_SUMMARY

6615: WHERE ASSET_ID = t_asset_id(i)
6616: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6617: AND TRANSACTION_HEADER_ID = t_thid(i));
6618:
6619: UPDATE FA_BOOKS_SUMMARY
6620: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + (l_reallocate_amount * sign(p_reserve_amount) * -1)
6621: , DEPRN_RESERVE = DEPRN_RESERVE + (l_reallocate_amount * sign(p_reserve_amount) * -1)
6622: , ADJUSTED_COST = ADJUSTED_COST + l_reallocate_amount
6623: WHERE ASSET_ID = t_asset_id(i)

Line 6678: UPDATE FA_BOOKS_SUMMARY

6674: WHERE ASSET_ID = t_asset_id(i)
6675: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
6676: AND TRANSACTION_HEADER_ID = t_thid(i));
6677:
6678: UPDATE FA_BOOKS_SUMMARY
6679: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjusted_cost(i)
6680: , DEPRN_RESERVE = ADJUSTED_RECOVERABLE_COST
6681: , ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST
6682: WHERE ASSET_ID = t_asset_id(i)