[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT bc.book_type_code
FROM fa_books bks,
fa_book_controls bc
WHERE bks.book_type_code = bc.distribution_source_book
AND bks.book_type_code = bc.book_type_code
AND bks.asset_id = p_asset_id
AND bks.transaction_header_id_out is null;
select transaction_header_id
into l_corp_thid
from fa_transaction_headers
where asset_id=px_asset_hdr_rec.asset_id
and book_type_code=px_asset_hdr_rec.book_type_code
and transaction_type_code='CIP REVERSE';
select cost,
date_placed_in_service,
group_asset_id,
salvage_type,
percent_salvage_value,
salvage_value
into l_asset_fin_rec.cost,
l_asset_fin_rec.date_placed_in_service,
l_asset_fin_rec.group_asset_id,
l_asset_fin_rec.salvage_type,
l_asset_fin_rec.percent_salvage_value,
l_asset_fin_rec.salvage_value
from fa_books
where asset_id = px_asset_hdr_rec.asset_id
and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
and transaction_header_id_in = l_corp_thid;
select br1.avg_exchange_rate
into l_avg_rate
from fa_mc_books_rates br1
where br1.asset_id = l_asset_hdr_rec.asset_id
and br1.book_type_code = l_asset_hdr_rec.book_type_code
and br1.set_of_books_id = l_asset_hdr_rec.set_of_books_id
and br1.transaction_header_id =
(select max(br2.transaction_header_id)
from fa_mc_books_rates br2
where br2.asset_id = l_asset_hdr_rec.asset_id
and br2.book_type_code = l_asset_hdr_rec.book_type_code
and br2.set_of_books_id = l_asset_hdr_rec.set_of_books_id);
MC_FA_UTILITIES_PKG.insert_books_rates
(p_set_of_books_id => l_asset_hdr_rec.set_of_books_id,
p_asset_id => l_asset_hdr_rec.asset_id,
p_book_type_code => l_asset_hdr_rec.book_type_code,
p_transaction_header_id => px_trans_rec.transaction_header_id,
p_invoice_transaction_id => null,
p_exchange_date => px_trans_rec.transaction_date_entered, -- ??? dpis
p_cost => 0,
p_exchange_rate => l_exchange_rate,
p_avg_exchange_rate => l_avg_rate,
p_last_updated_by => px_trans_rec.who_info.last_updated_by,
p_last_update_date => px_trans_rec.who_info.last_update_date,
p_last_update_login => px_trans_rec.who_info.last_update_login,
p_complete => 'Y',
p_trigger => 'l_calling_fn',
p_currency_code => l_asset_hdr_rec.set_of_books_id
,p_log_level_rec => p_log_level_rec);
select fa_transaction_headers_s.nextval
into l_group_trans_rec.transaction_header_id
from dual;