APPS.FA_RETIREMENT_PUB dependencies on FA_MC_ASSET_INVOICES

Line 3768: DELETE FROM FA_MC_ASSET_INVOICES

3764:
3765: if (l_invoice_transaction_id is not null) then
3766: if (p_mrc_sob_type_code = 'R') then
3767:
3768: DELETE FROM FA_MC_ASSET_INVOICES
3769: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
3770: AND INVOICE_TRANSACTION_ID_IN = l_invoice_transaction_id;
3771:
3772: UPDATE FA_MC_ASSET_INVOICES

Line 3772: UPDATE FA_MC_ASSET_INVOICES

3768: DELETE FROM FA_MC_ASSET_INVOICES
3769: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
3770: AND INVOICE_TRANSACTION_ID_IN = l_invoice_transaction_id;
3771:
3772: UPDATE FA_MC_ASSET_INVOICES
3773: SET INVOICE_TRANSACTION_ID_OUT = '',
3774: DATE_INEFFECTIVE = ''
3775: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
3776: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id;

Line 6114: DELETE FROM FA_MC_ASSET_INVOICES

6110: CLOSE c_inv_trx_id;
6111:
6112: if (l_invoice_transaction_id is not null) then
6113: if (p_mrc_sob_type_code = 'R') then
6114: DELETE FROM FA_MC_ASSET_INVOICES
6115: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6116: AND INVOICE_TRANSACTION_ID_IN = l_invoice_transaction_id
6117: AND INVOICE_TRANSACTION_ID_OUT is null
6118: AND SET_OF_BOOKS_ID = l_asset_hdr_rec.set_of_books_id;

Line 6124: UPDATE FA_MC_ASSET_INVOICES

6120: /*
6121: * This reactivate record with FIXED_ASSETS_COST <> 0
6122: * since 0 cost row should not be appeared on source line window.
6123: */
6124: UPDATE FA_MC_ASSET_INVOICES
6125: SET INVOICE_TRANSACTION_ID_OUT = '',
6126: DATE_INEFFECTIVE = ''
6127: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6128: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id

Line 6138: UPDATE FA_MC_ASSET_INVOICES

6134: * After retirement, if cost is 0, INVOICE_TRANSACTION_ID_OUT
6135: * and DATE_INEFFECTIVE is populated with the same value as
6136: * INVOICE_TRANSACTION_ID_IN and DATE_EFFECTIVE.
6137: */
6138: UPDATE FA_MC_ASSET_INVOICES
6139: SET INVOICE_TRANSACTION_ID_OUT = INVOICE_TRANSACTION_ID_IN,
6140: DATE_INEFFECTIVE = DATE_EFFECTIVE
6141: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6142: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id