APPS.FA_RETIREMENT_PUB dependencies on FA_MC_ASSET_INVOICES

Line 4047: DELETE FROM FA_MC_ASSET_INVOICES

4043:
4044: if (l_invoice_transaction_id is not null) then
4045: if (p_mrc_sob_type_code = 'R') then
4046:
4047: DELETE FROM FA_MC_ASSET_INVOICES
4048: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
4049: AND INVOICE_TRANSACTION_ID_IN = l_invoice_transaction_id;
4050:
4051: UPDATE FA_MC_ASSET_INVOICES

Line 4051: UPDATE FA_MC_ASSET_INVOICES

4047: DELETE FROM FA_MC_ASSET_INVOICES
4048: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
4049: AND INVOICE_TRANSACTION_ID_IN = l_invoice_transaction_id;
4050:
4051: UPDATE FA_MC_ASSET_INVOICES
4052: SET INVOICE_TRANSACTION_ID_OUT = '',
4053: DATE_INEFFECTIVE = ''
4054: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
4055: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id;

Line 6462: DELETE FROM FA_MC_ASSET_INVOICES

6458: CLOSE c_inv_trx_id;
6459:
6460: if (l_invoice_transaction_id is not null) then
6461: if (p_mrc_sob_type_code = 'R') then
6462: DELETE FROM FA_MC_ASSET_INVOICES
6463: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6464: AND INVOICE_TRANSACTION_ID_IN = l_invoice_transaction_id
6465: AND INVOICE_TRANSACTION_ID_OUT is null
6466: AND SET_OF_BOOKS_ID = l_asset_hdr_rec.set_of_books_id;

Line 6472: UPDATE FA_MC_ASSET_INVOICES

6468: /*
6469: * This reactivate record with FIXED_ASSETS_COST <> 0
6470: * since 0 cost row should not be appeared on source line window.
6471: */
6472: UPDATE FA_MC_ASSET_INVOICES
6473: SET INVOICE_TRANSACTION_ID_OUT = '',
6474: DATE_INEFFECTIVE = ''
6475: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6476: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id

Line 6486: UPDATE FA_MC_ASSET_INVOICES

6482: * After retirement, if cost is 0, INVOICE_TRANSACTION_ID_OUT
6483: * and DATE_INEFFECTIVE is populated with the same value as
6484: * INVOICE_TRANSACTION_ID_IN and DATE_EFFECTIVE.
6485: */
6486: UPDATE FA_MC_ASSET_INVOICES
6487: SET INVOICE_TRANSACTION_ID_OUT = INVOICE_TRANSACTION_ID_IN,
6488: DATE_INEFFECTIVE = DATE_EFFECTIVE
6489: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6490: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id