[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select fa_transaction_headers_s.nextval
into px_src_trans_rec.transaction_header_id
from dual;
select fa_transaction_headers_s.nextval
into px_dest_trans_rec.transaction_header_id
from dual;
fa_trx_references_pkg.insert_row
(X_Rowid => l_rowid,
X_Trx_Reference_Id => px_src_trans_rec.trx_reference_id,
X_Book_Type_Code => l_src_asset_hdr_rec.book_type_code,
X_Src_Asset_Id => l_src_asset_hdr_rec.asset_id,
X_Src_Transaction_Header_Id => px_src_trans_rec.transaction_header_id,
X_Dest_Asset_Id => l_dest_asset_hdr_rec.asset_id,
X_Dest_Transaction_Header_Id => px_dest_trans_rec.transaction_header_id,
X_Member_Asset_Id => null,
X_Member_Transaction_Header_Id => null,
X_Transaction_Type => 'RESERVE TRANSFER',
X_Src_Transaction_Subtype => px_src_trans_rec.transaction_subtype,
X_Dest_Transaction_Subtype => px_dest_trans_rec.transaction_subtype,
X_Src_Amortization_Start_Date => px_src_trans_rec.amortization_start_date,
X_Dest_Amortization_Start_Date => px_dest_trans_rec.amortization_start_date,
X_Reserve_Transfer_Amount => p_amount,
X_Src_Expense_Amount => null,
X_Dest_Expense_Amount => null,
X_Src_Eofy_Reserve => null,
X_Dest_Eofy_Reserve => null,
X_Creation_Date => px_src_trans_rec.who_info.creation_date,
X_Created_By => px_src_trans_rec.who_info.created_by,
X_Last_Update_Date => px_src_trans_rec.who_info.last_update_date,
X_Last_Updated_By => px_src_trans_rec.who_info.last_updated_by,
X_Last_Update_Login => px_src_trans_rec.who_info.last_update_login,
X_Return_Status => l_return_status,
X_Calling_Fn => l_calling_fn,
p_log_level_rec => p_log_level_rec);
fa_transaction_headers_pkg.insert_row
(x_rowid => l_src_row_id,
x_transaction_header_id => px_src_trans_rec.transaction_header_id,
x_book_type_code => p_book_type_code,
x_asset_id => p_src_asset_id,
x_transaction_type_code => 'GROUP ADJUSTMENT',
x_transaction_date_entered => px_src_trans_rec.transaction_date_entered,
x_date_effective => px_src_trans_rec.who_info.last_update_date,
x_last_update_date => px_src_trans_rec.who_info.last_update_date,
x_last_updated_by => px_src_trans_rec.who_info.last_updated_by,
x_transaction_name => px_src_trans_rec.transaction_name,
x_last_update_login => px_src_trans_rec.who_info.last_update_login,
x_transaction_key => px_src_trans_rec.transaction_key,
x_transaction_subtype => px_dest_trans_rec.transaction_subtype,
x_amortization_start_date => px_src_trans_rec.amortization_start_date,
x_calling_interface => px_src_trans_rec.calling_interface,
x_mass_transaction_id => px_src_trans_rec.mass_transaction_id,
x_trx_reference_id => px_src_trans_rec.trx_reference_id,
x_event_id => px_src_trans_rec.event_id,
x_return_status => l_src_return_status,
x_calling_fn => l_calling_fn
,p_log_level_rec => p_log_level_rec);
fa_transaction_headers_pkg.insert_row
(x_rowid => l_dest_row_id,
x_transaction_header_id => px_dest_trans_rec.transaction_header_id,
x_book_type_code => p_book_type_code,
x_asset_id => p_dest_asset_id,
x_transaction_type_code => 'GROUP ADJUSTMENT',
x_transaction_date_entered => px_dest_trans_rec.transaction_date_entered,
x_date_effective => px_dest_trans_rec.who_info.last_update_date,
x_last_update_date => px_dest_trans_rec.who_info.last_update_date,
x_last_updated_by => px_dest_trans_rec.who_info.last_updated_by,
x_transaction_name => px_dest_trans_rec.transaction_name,
x_last_update_login => px_dest_trans_rec.who_info.last_update_login,
x_transaction_key => px_dest_trans_rec.transaction_key,
x_transaction_subtype => px_dest_trans_rec.transaction_subtype,
x_amortization_start_date => px_dest_trans_rec.amortization_start_date,
x_calling_interface => px_dest_trans_rec.calling_interface,
x_mass_transaction_id => px_dest_trans_rec.mass_transaction_id,
x_trx_reference_id => px_dest_trans_rec.trx_reference_id,
x_event_id => px_dest_trans_rec.event_id,
x_return_status => l_dest_return_status,
x_calling_fn => l_calling_fn
,p_log_level_rec => p_log_level_rec);