The following lines contain the word 'select', 'insert', 'update' or 'delete':
select fa_transaction_headers_s.nextval
into px_trans_rec.transaction_header_id
from dual;
px_trans_rec.who_info.last_update_date := sysdate;
fa_transaction_headers_pkg.insert_row
(x_rowid => l_rowid,
x_transaction_header_id => px_trans_rec.transaction_header_id,
x_book_type_code => px_asset_hdr_rec.book_type_code,
x_asset_id => px_asset_hdr_rec.asset_id,
x_transaction_type_code => px_trans_rec.transaction_type_code,
x_transaction_date_entered => px_trans_rec.transaction_date_entered,
x_date_effective => px_trans_rec.who_info.last_update_date,
x_last_update_date => px_trans_rec.who_info.last_update_date,
x_last_updated_by => px_trans_rec.who_info.last_updated_by,
x_transaction_name => px_trans_rec.transaction_name,
x_last_update_login => px_trans_rec.who_info.last_update_login,
x_transaction_key => px_trans_rec.transaction_key,
x_transaction_subtype => px_trans_rec.transaction_subtype,
x_amortization_start_date => px_trans_rec.amortization_start_date,
x_calling_interface => px_trans_rec.calling_interface,
x_mass_transaction_id => px_trans_rec.mass_transaction_id,
x_trx_reference_id => px_trans_rec.trx_reference_id,
x_event_id => px_trans_rec.event_id,
x_return_status => l_return_status,
x_calling_fn => l_calling_fn,
p_log_level_rec => p_log_level_rec);