The following lines contain the word 'select', 'insert', 'update' or 'delete':
FA_INVOICE_TRANSACTIONS_PKG.Insert_Row
(X_Rowid => l_rowid,
X_Invoice_Transaction_Id => px_inv_trans_rec.invoice_transaction_id ,
X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
X_Transaction_Type => px_inv_trans_rec.transaction_type,
X_Date_Effective => sysdate,
X_Calling_Fn => 'FA_INVOICE_API_PKG.invoice_engine'
, p_log_level_rec => p_log_level_rec);
'after get_inv_rec, deleted_flag',
l_inv_rec.deleted_flag, p_log_level_rec => p_log_level_rec);
if (px_inv_trans_rec.transaction_type = 'INVOICE DELETE') then
if (l_inv_rec.deleted_flag = 'YES') then
fa_srvr_msg.add_message(
calling_fn => l_calling_fn,
name => '***FA_INV_ALREADY_DEL***',
p_log_level_rec => p_log_level_rec);
l_inv_rec.deleted_flag := 'YES';
if (nvl(l_inv_rec.deleted_flag, 'NO') = 'NO') then
fa_srvr_msg.add_message(
calling_fn => l_calling_fn,
name => '***FA_INV_ALREADY_REINS***',
p_log_level_rec => p_log_level_rec);
l_inv_rec.deleted_flag := 'NO';
if (l_inv_rec.deleted_flag is null) then
l_inv_rec.deleted_flag := 'NO';
select decode(fixed_assets_cost + l_inv_rec.fixed_assets_cost,
0, 'NO',
'YES')
into l_create_new_row
from fa_asset_invoices
where source_line_id = l_inv_rec.source_line_id
and asset_id = px_asset_hdr_rec.asset_Id;
select 'YES'
into l_create_new_row
from fa_asset_invoices
where source_line_id = l_inv_rec.source_line_id
and asset_id = px_asset_hdr_rec.asset_id;
update fa_asset_invoices
set date_ineffective = sysdate,
invoice_transaction_id_out = px_inv_trans_rec.invoice_transaction_id
where source_line_id = l_inv_rec.source_line_id;
update fa_mc_asset_invoices
set date_ineffective = sysdate,
invoice_transaction_id_out = px_inv_trans_rec.invoice_transaction_id
where source_line_id = l_inv_rec.source_line_id;
elsif (px_inv_trans_rec.transaction_type = 'INVOICE DELETE' or
px_inv_trans_rec.transaction_type = 'INVOICE DEP' or
px_inv_trans_rec.transaction_type = 'INVOICE NO DEP') then
l_inv_rec.Fixed_Assets_Cost := l_current_fa_cost;
select FA_ASSET_INVOICES_S.nextval
into l_inv_rec.source_line_id
from dual;
select FA_MASS_ADDITIONS_S.nextval
into l_inv_rec.asset_invoice_id
from dual;
select fixed_assets_cost,
payables_cost
into l_current_fa_cost,
l_current_pa_cost
from fa_mc_asset_invoices
where source_line_id = l_current_source_line_id
and set_of_books_id = l_sob_tbl(l_sob_index);
if (px_inv_trans_rec.transaction_type = 'INVOICE DELETE') then
l_inv_rec.Fixed_Assets_Cost := -l_current_fa_cost;
l_date_ineffective := px_trans_rec.who_info.last_update_date;
FA_ASSET_INVOICES_PKG.Insert_Row
(X_Rowid => l_rowid,
X_Asset_Id => px_asset_hdr_rec.asset_id,
X_Po_Vendor_Id => px_inv_rec.po_vendor_id,
X_Asset_Invoice_Id => px_inv_rec.asset_invoice_id, -- mass_add_id
X_Fixed_Assets_Cost => px_inv_rec.fixed_assets_cost,
X_Date_Effective => px_trans_rec.who_info.last_update_date,
X_Date_Ineffective => l_date_ineffective,
X_Invoice_Transaction_Id_In => p_inv_trans_rec.invoice_transaction_id,
X_Invoice_Transaction_Id_Out => l_invoice_transaction_id_out,
X_Deleted_Flag => px_inv_rec.deleted_flag,
X_Po_Number => px_inv_rec.po_number,
X_Invoice_Number => px_inv_rec.invoice_number,
X_Payables_Batch_Name => px_inv_rec.payables_batch_name,
X_Payables_Code_Combination_Id => px_inv_rec.payables_code_combination_id,
X_Feeder_System_Name => px_inv_rec.feeder_system_name,
X_Create_Batch_Date => px_inv_rec.create_batch_date,
X_Create_Batch_Id => px_inv_rec.create_batch_id,
X_Invoice_Date => px_inv_rec.invoice_date,
X_Payables_Cost => px_inv_rec.payables_cost,
X_Post_Batch_Id => px_inv_rec.post_batch_id,
X_Invoice_Id => px_inv_rec.invoice_id,
X_Ap_Distribution_Line_Number => px_inv_rec.ap_distribution_line_number,
X_Payables_Units => px_inv_rec.payables_units,
X_Split_Merged_Code => px_inv_rec.split_merged_code,
X_Description => px_inv_rec.description,
X_Parent_Mass_Addition_Id => px_inv_rec.parent_mass_addition_id,
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_Created_By => px_trans_rec.who_info.created_by,
X_Creation_Date => px_trans_rec.who_info.creation_date,
X_Last_Update_Login => px_trans_rec.who_info.last_update_login,
X_Attribute1 => px_inv_rec.ATTRIBUTE1,
X_Attribute2 => px_inv_rec.ATTRIBUTE2,
X_Attribute3 => px_inv_rec.ATTRIBUTE3,
X_Attribute4 => px_inv_rec.ATTRIBUTE4,
X_Attribute5 => px_inv_rec.ATTRIBUTE5,
X_Attribute6 => px_inv_rec.ATTRIBUTE6,
X_Attribute7 => px_inv_rec.ATTRIBUTE7,
X_Attribute8 => px_inv_rec.ATTRIBUTE8,
X_Attribute9 => px_inv_rec.ATTRIBUTE9,
X_Attribute10 => px_inv_rec.ATTRIBUTE10,
X_Attribute11 => px_inv_rec.ATTRIBUTE11,
X_Attribute12 => px_inv_rec.ATTRIBUTE12,
X_Attribute13 => px_inv_rec.ATTRIBUTE13,
X_Attribute14 => px_inv_rec.ATTRIBUTE14,
X_Attribute15 => px_inv_rec.ATTRIBUTE15,
X_Attribute_Category_Code => px_inv_rec.ATTRIBUTE_CATEGORY_CODE,
X_Unrevalued_Cost => px_inv_rec.unrevalued_cost,
X_Merged_Code => px_inv_rec.merged_code,
X_Split_Code => px_inv_rec.split_code,
X_Merge_Parent_Mass_Add_Id => px_inv_rec.merge_parent_mass_additions_id,
X_Split_Parent_Mass_Add_Id => px_inv_rec.split_parent_mass_additions_id,
X_Project_Asset_Line_Id => px_inv_rec.project_asset_line_id,
X_Project_Id => px_inv_rec.project_id,
X_Task_Id => px_inv_rec.task_id,
X_Material_Indicator_Flag => px_inv_rec.material_indicator_flag,
X_source_line_id => px_inv_rec.source_line_id,
X_prior_source_line_id => px_inv_rec.prior_source_line_id,
X_depreciate_in_group_flag => px_inv_rec.depreciate_in_group_flag,
-- added for R12
X_invoice_distribution_id => px_inv_rec.invoice_distribution_id,
X_invoice_line_number => px_inv_rec.invoice_line_number,
X_po_distribution_id => px_inv_rec.po_distribution_id,
X_exchange_rate => p_inv_rate_rec.exchange_rate,
X_mrc_sob_type_code => p_mrc_sob_type_code,
X_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
X_Calling_Fn => 'fa_invoice_api_pkg.process_invoice'
, p_log_level_rec => p_log_level_rec);
select mcai.set_of_books_id,
mcai.exchange_rate,
mcai.fixed_assets_cost
from fa_mc_asset_invoices mcai,
fa_mc_book_controls mcbk
where mcai.source_line_id = p_source_line_id
and mcai.set_of_books_id = mcbk.set_of_books_id
and mcbk.book_type_code = p_asset_hdr_rec.book_type_code
and mcbk.enabled_flag = 'Y';
l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
l_adj.selection_thid := 0;
l_adj.selection_retid := 0;
l_adj.last_update_date := p_trans_rec.who_info.last_update_date;
p_trans_rec.who_info.last_update_date,
p_trans_rec.who_info.last_updated_by,
p_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise error_found;
p_trans_rec.who_info.last_update_date,
p_trans_rec.who_info.last_updated_by,
p_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise error_found;
p_trans_rec.who_info.last_update_date,
p_trans_rec.who_info.last_updated_by,
p_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise error_found;
p_trans_rec.who_info.last_update_date,
p_trans_rec.who_info.last_updated_by,
p_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
raise error_found;