The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
nvl(cbd.recognize_gain_loss,'NO'),
nvl(cbd.terminal_gain_loss,'YES'),
cbd.tracking_method,
cbd.excess_allocation_option,
cbd.allocate_to_fully_rsv_flag,
cbd.Recapture_Reserve_Flag,
decode(nvl(cbd.recognize_gain_loss,'NO'),'NO',cbd.LIMIT_PROCEEDS_FLAG,NULL),
cbd.depreciation_option,
cbd.member_rollup_flag
FROM
fa_categories cat,
fa_category_book_defaults cbd,
fa_methods mth,
fa_deprn_periods dp,
fa_deprn_basis_rules dbr
WHERE
dp.book_type_code = c_book_type_code and
dp.period_close_date is null
AND
cbd.category_id = c_category_id and
cbd.book_type_code = c_book_type_code and
nvl(c_date_placed_in_service,
greatest(dp.calendar_period_open_date,
least(sysdate,
nvl(dp.calendar_period_close_date,sysdate))))
>= cbd.start_dpis and
nvl(c_date_placed_in_service,
greatest(dp.calendar_period_open_date,
least(sysdate,
nvl(dp.calendar_period_close_date,sysdate))))
<= nvl(cbd.end_dpis,greatest(dp.calendar_period_open_date,
least(sysdate, dp.calendar_period_close_date))) and
cat.category_id = c_category_id and
mth.method_code = cbd.deprn_method and
decode(mth.rate_source_rule,'PRODUCTION','PROD',
'FLAT','FLAT',mth.life_in_months)
= decode(mth.rate_source_rule,
'PRODUCTION','PROD',
'FLAT','FLAT',cbd.life_in_months) and
mth.deprn_basis_rule_id = dbr.deprn_basis_rule_id(+);
select greatest(calendar_period_open_date,
least(sysdate, calendar_period_close_date))
from fa_deprn_periods
where book_type_code = c_book_type_code
and period_close_date is null;
select rate_source_rule,rule_name
from fa_methods mt,fa_deprn_basis_rules dbr
where mt.method_code = c_method_code
and mt.deprn_basis_rule_id = dbr.deprn_basis_rule_id(+);
select fa_additions_s.nextval
into px_asset_hdr_rec.asset_id
from dual;
select nvl(px_asset_fin_rec.cost, cost),
nvl(px_asset_fin_rec.date_placed_in_service, date_placed_in_service)
into px_asset_fin_rec.cost,
px_asset_fin_rec.date_placed_in_service
from fa_books bks
where book_type_code =
fa_cache_pkg.fazcbc_record.distribution_source_book
and asset_id = px_asset_hdr_rec.asset_id
and transaction_header_id_out is null;
px_asset_dist_tbl.delete;
if (px_inv_tbl(i).deleted_flag is NULL) then
px_inv_tbl(i).deleted_flag := 'NO';
select nvl(salvage_value, 0)
into px_asset_fin_rec.salvage_value
from fa_books
where transaction_header_id_in = px_trans_rec.source_transaction_header_id;
function insert_asset (
p_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
p_dist_trans_rec IN fa_api_types.trans_rec_type,
p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
p_asset_type_rec IN fa_api_types.asset_type_rec_type,
p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
p_inv_trans_rec IN fa_api_types.inv_trans_rec_type,
p_primary_cost IN NUMBER,
p_exchange_rate IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
p_mrc_sob_type_code IN VARCHAR2,
p_period_rec IN fa_api_types.period_rec_type,
p_calling_fn IN VARCHAR2,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean as
l_rowid ROWID;
select source_line_id,
asset_invoice_id,
payables_cost,
nvl(payables_code_combination_id, 0)
from fa_asset_invoices
where asset_id = p_asset_id
and invoice_transaction_id_in = p_invoice_transaction_id
and nvl(payables_cost, 0) <> 0;
select source_line_id,
asset_invoice_id,
payables_cost,
nvl(payables_code_combination_id, 0)
from fa_asset_invoices_mrc_v
where asset_id = p_asset_id
and invoice_transaction_id_in = p_invoice_transaction_id
and nvl(payables_cost, 0) <> 0;
l_date_effective := p_trans_rec.who_info.last_update_date;
l_deprn_run_date := p_trans_rec.who_info.last_update_date;
fa_additions_pkg.insert_row (
X_Rowid => l_rowid,
X_Asset_Id => l_asset_id,
X_Asset_Number => l_asset_number,
X_Asset_Key_Ccid => p_asset_desc_rec.asset_key_ccid,
X_Current_Units => p_asset_desc_rec.current_units,
X_Asset_Type => upper(p_asset_type_rec.asset_type),
X_Tag_Number => upper(p_asset_desc_rec.tag_number),
X_Description => p_asset_desc_rec.description,
X_Asset_Category_Id => p_asset_cat_rec.category_id,
X_Parent_Asset_Id => p_asset_desc_rec.parent_asset_id,
X_Manufacturer_Name => p_asset_desc_rec.manufacturer_name,
X_Serial_Number => p_asset_desc_rec.serial_number,
X_Model_Number => p_asset_desc_rec.model_number,
X_Property_Type_Code => upper(p_asset_desc_rec.property_type_code),
X_Property_1245_1250_Code
=>
p_asset_desc_rec.property_1245_1250_code,
X_In_Use_Flag => upper(p_asset_desc_rec.in_use_flag),
X_Owned_Leased => upper(p_asset_desc_rec.owned_leased),
X_New_Used => upper(p_asset_desc_rec.new_used),
X_Unit_Adjustment_Flag => upper(p_asset_desc_rec.unit_adjustment_flag),
X_Add_Cost_Je_Flag => upper(p_asset_desc_rec.add_cost_je_flag),
X_attribute1 => p_asset_cat_rec.desc_flex.attribute1,
X_attribute2 => p_asset_cat_rec.desc_flex.attribute2,
X_attribute3 => p_asset_cat_rec.desc_flex.attribute3,
X_attribute4 => p_asset_cat_rec.desc_flex.attribute4,
X_attribute5 => p_asset_cat_rec.desc_flex.attribute5,
X_attribute6 => p_asset_cat_rec.desc_flex.attribute6,
X_attribute7 => p_asset_cat_rec.desc_flex.attribute7,
X_attribute8 => p_asset_cat_rec.desc_flex.attribute8,
X_attribute9 => p_asset_cat_rec.desc_flex.attribute9,
X_attribute10 => p_asset_cat_rec.desc_flex.attribute10,
X_attribute11 => p_asset_cat_rec.desc_flex.attribute11,
X_attribute12 => p_asset_cat_rec.desc_flex.attribute12,
X_attribute13 => p_asset_cat_rec.desc_flex.attribute13,
X_attribute14 => p_asset_cat_rec.desc_flex.attribute14,
X_attribute15 => p_asset_cat_rec.desc_flex.attribute15,
X_attribute16 => p_asset_cat_rec.desc_flex.attribute16,
X_attribute17 => p_asset_cat_rec.desc_flex.attribute17,
X_attribute18 => p_asset_cat_rec.desc_flex.attribute18,
X_attribute19 => p_asset_cat_rec.desc_flex.attribute19,
X_attribute20 => p_asset_cat_rec.desc_flex.attribute20,
X_attribute21 => p_asset_cat_rec.desc_flex.attribute21,
X_attribute22 => p_asset_cat_rec.desc_flex.attribute22,
X_attribute23 => p_asset_cat_rec.desc_flex.attribute23,
X_attribute24 => p_asset_cat_rec.desc_flex.attribute24,
X_attribute25 => p_asset_cat_rec.desc_flex.attribute25,
X_attribute26 => p_asset_cat_rec.desc_flex.attribute26,
X_attribute27 => p_asset_cat_rec.desc_flex.attribute27,
X_attribute28 => p_asset_cat_rec.desc_flex.attribute28,
X_attribute29 => p_asset_cat_rec.desc_flex.attribute29,
X_attribute30 => p_asset_cat_rec.desc_flex.attribute30,
X_attribute_Category_Code
=>
p_asset_cat_rec.desc_flex.attribute_category_code,
X_gf_attribute1 =>
p_asset_desc_rec.global_desc_flex.attribute1,
X_gf_attribute2 =>
p_asset_desc_rec.global_desc_flex.attribute2,
X_gf_attribute3 =>
p_asset_desc_rec.global_desc_flex.attribute3,
X_gf_attribute4 =>
p_asset_desc_rec.global_desc_flex.attribute4,
X_gf_attribute5 =>
p_asset_desc_rec.global_desc_flex.attribute5,
X_gf_attribute6 =>
p_asset_desc_rec.global_desc_flex.attribute6,
X_gf_attribute7 =>
p_asset_desc_rec.global_desc_flex.attribute7,
X_gf_attribute8 =>
p_asset_desc_rec.global_desc_flex.attribute8,
X_gf_attribute9 =>
p_asset_desc_rec.global_desc_flex.attribute9,
X_gf_attribute10 =>
p_asset_desc_rec.global_desc_flex.attribute10,
X_gf_attribute11 =>
p_asset_desc_rec.global_desc_flex.attribute11,
X_gf_attribute12 =>
p_asset_desc_rec.global_desc_flex.attribute12,
X_gf_attribute13 =>
p_asset_desc_rec.global_desc_flex.attribute13,
X_gf_attribute14 =>
p_asset_desc_rec.global_desc_flex.attribute14,
X_gf_attribute15 =>
p_asset_desc_rec.global_desc_flex.attribute15,
X_gf_attribute16 =>
p_asset_desc_rec.global_desc_flex.attribute16,
X_gf_attribute17 =>
p_asset_desc_rec.global_desc_flex.attribute17,
X_gf_attribute18 =>
p_asset_desc_rec.global_desc_flex.attribute18,
X_gf_attribute19 =>
p_asset_desc_rec.global_desc_flex.attribute19,
X_gf_attribute20 =>
p_asset_desc_rec.global_desc_flex.attribute20,
X_gf_attribute_Category_Code
=>
p_asset_desc_rec.global_desc_flex.attribute_category_code,
X_Context => p_asset_cat_rec.desc_flex.context,
X_Lease_Id => p_asset_desc_rec.lease_id,
X_Inventorial => upper(p_asset_desc_rec.inventorial),
X_Commitment => p_asset_desc_rec.commitment,
X_Investment_Law => p_asset_desc_rec.investment_law,
X_Status => upper(p_asset_desc_rec.status),
X_Last_Update_Date => p_trans_rec.who_info.last_update_date,
X_Last_Updated_By => p_trans_rec.who_info.last_updated_by,
X_Created_By => p_trans_rec.who_info.created_by,
X_Creation_Date => p_trans_rec.who_info.creation_date,
X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
X_Calling_Fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec
);
UPDATE fa_leases
SET
last_update_date = p_trans_rec.who_info.last_update_date,
last_updated_by = p_trans_rec.who_info.last_updated_by,
last_update_login = p_trans_rec.who_info.last_update_login,
attribute1 = p_asset_desc_rec.lease_desc_flex.attribute1,
attribute2 = p_asset_desc_rec.lease_desc_flex.attribute2,
attribute3 = p_asset_desc_rec.lease_desc_flex.attribute3,
attribute4 = p_asset_desc_rec.lease_desc_flex.attribute4,
attribute5 = p_asset_desc_rec.lease_desc_flex.attribute5,
attribute6 = p_asset_desc_rec.lease_desc_flex.attribute6,
attribute7 = p_asset_desc_rec.lease_desc_flex.attribute7,
attribute8 = p_asset_desc_rec.lease_desc_flex.attribute8,
attribute9 = p_asset_desc_rec.lease_desc_flex.attribute9,
attribute10 = p_asset_desc_rec.lease_desc_flex.attribute10,
attribute11 = p_asset_desc_rec.lease_desc_flex.attribute11,
attribute12 = p_asset_desc_rec.lease_desc_flex.attribute12,
attribute13 = p_asset_desc_rec.lease_desc_flex.attribute13,
attribute14 = p_asset_desc_rec.lease_desc_flex.attribute14,
attribute15 = p_asset_desc_rec.lease_desc_flex.attribute15,
attribute_category_code
=
p_asset_desc_rec.lease_desc_flex.attribute_category_code
WHERE lease_id = p_asset_desc_rec.lease_id;
INSERT INTO fa_add_warranties (
warranty_id,
asset_id,
date_effective,
last_update_date,
last_updated_by,
created_by,
creation_date,
last_update_login
) VALUES (
p_asset_desc_rec.warranty_id,
p_asset_hdr_rec.asset_id,
l_date_effective,
p_trans_rec.who_info.last_update_date,
p_trans_rec.who_info.last_updated_by,
p_trans_rec.who_info.created_by,
p_trans_rec.who_info.creation_date,
p_trans_rec.who_info.last_update_login
);
p_calling_fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec) then
raise general_error;
fa_transaction_headers_pkg.insert_row (
X_Rowid => l_rowid,
X_Transaction_header_Id => l_transaction_header_id,
X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
X_Asset_Id => p_asset_hdr_rec.asset_id,
X_Transaction_Type_Code => p_trans_rec.transaction_type_code,
X_Transaction_Date_Entered => p_trans_rec.transaction_date_entered,
X_Date_Effective => l_date_effective,
X_Last_Update_Date => p_trans_rec.who_info.last_update_date,
X_Last_Updated_By => p_trans_rec.who_info.last_updated_by,
X_Transaction_Name => p_trans_rec.transaction_name,
X_Invoice_Transaction_Id => p_inv_trans_rec.invoice_transaction_id,
X_Source_Transaction_Header_Id
=> p_trans_rec.source_transaction_header_id,
X_Mass_Reference_Id => p_trans_rec.mass_reference_id,
X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
X_Transaction_Subtype => p_trans_rec.transaction_subtype,
X_attribute1 => p_trans_rec.desc_flex.attribute1,
X_attribute2 => p_trans_rec.desc_flex.attribute2,
X_attribute3 => p_trans_rec.desc_flex.attribute3,
X_attribute4 => p_trans_rec.desc_flex.attribute4,
X_attribute5 => p_trans_rec.desc_flex.attribute5,
X_attribute6 => p_trans_rec.desc_flex.attribute6,
X_attribute7 => p_trans_rec.desc_flex.attribute7,
X_attribute8 => p_trans_rec.desc_flex.attribute8,
X_attribute9 => p_trans_rec.desc_flex.attribute9,
X_attribute10 => p_trans_rec.desc_flex.attribute10,
X_attribute11 => p_trans_rec.desc_flex.attribute11,
X_attribute12 => p_trans_rec.desc_flex.attribute12,
X_attribute13 => p_trans_rec.desc_flex.attribute13,
X_attribute14 => p_trans_rec.desc_flex.attribute14,
X_attribute15 => p_trans_rec.desc_flex.attribute15,
X_attribute_Category_Code =>
p_trans_rec.desc_flex.attribute_category_code,
X_Transaction_Key => p_trans_rec.transaction_key,
X_Amortization_Start_Date => p_trans_rec.amortization_start_date,
X_Calling_Interface => p_trans_rec.calling_interface,
X_Mass_Transaction_ID => p_trans_rec.mass_transaction_id,
X_Trx_Reference_Id => p_trans_rec.trx_reference_id,
X_Event_Id => p_trans_rec.event_id,
X_Return_Status => l_return_status,
X_Calling_Fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec);
fa_transaction_headers_pkg.insert_row (
X_Rowid => l_rowid,
X_Transaction_Header_Id => l_trans_in_header_id,
X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
X_Asset_Id => p_asset_hdr_rec.asset_id,
X_Transaction_Type_Code => p_dist_trans_rec.transaction_type_code,
X_Transaction_Date_Entered
=> p_dist_trans_rec.transaction_date_entered,
X_Date_Effective => l_date_effective,
X_Last_Update_Date =>
p_dist_trans_rec.who_info.last_update_date,
X_Last_Updated_By => p_dist_trans_rec.who_info.last_updated_by,
X_Transaction_Name => p_dist_trans_rec.transaction_name,
X_Invoice_Transaction_Id
=> p_inv_trans_rec.invoice_transaction_id,
X_Source_Transaction_Header_Id
=>
p_dist_trans_rec.source_transaction_header_id,
X_Mass_Reference_Id => p_dist_trans_rec.mass_reference_id,
X_Last_Update_Login =>
p_dist_trans_rec.who_info.last_update_login,
X_Transaction_Subtype => p_dist_trans_rec.transaction_subtype,
X_attribute1 => p_dist_trans_rec.desc_flex.attribute1,
X_attribute2 => p_dist_trans_rec.desc_flex.attribute2,
X_attribute3 => p_dist_trans_rec.desc_flex.attribute3,
X_attribute4 => p_dist_trans_rec.desc_flex.attribute4,
X_attribute5 => p_dist_trans_rec.desc_flex.attribute5,
X_attribute6 => p_dist_trans_rec.desc_flex.attribute6,
X_attribute7 => p_dist_trans_rec.desc_flex.attribute7,
X_attribute8 => p_dist_trans_rec.desc_flex.attribute8,
X_attribute9 => p_dist_trans_rec.desc_flex.attribute9,
X_attribute10 => p_dist_trans_rec.desc_flex.attribute10,
X_attribute11 => p_dist_trans_rec.desc_flex.attribute11,
X_attribute12 => p_dist_trans_rec.desc_flex.attribute12,
X_attribute13 => p_dist_trans_rec.desc_flex.attribute13,
X_attribute14 => p_dist_trans_rec.desc_flex.attribute14,
X_attribute15 => p_dist_trans_rec.desc_flex.attribute15,
X_attribute_Category_Code
=>
p_dist_trans_rec.desc_flex.attribute_category_code,
X_Transaction_Key => p_dist_trans_rec.transaction_key,
X_Amortization_Start_Date
=> p_dist_trans_rec.amortization_start_date,
X_Calling_Interface => p_dist_trans_rec.calling_interface,
X_Mass_Transaction_ID => p_trans_rec.mass_transaction_id,
X_Return_Status => l_return_status,
X_Calling_Fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec);
fa_books_pkg.insert_row (
X_Rowid => l_rowid,
X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
X_Asset_Id => p_asset_hdr_rec.asset_id,
X_Date_Placed_In_Service => p_asset_fin_rec.date_placed_in_service,
X_Date_Effective => l_date_effective,
X_Deprn_Start_Date => p_asset_fin_rec.deprn_start_date,
X_Deprn_Method_Code => p_asset_fin_rec.deprn_method_code,
X_Life_In_Months => p_asset_fin_rec.life_in_months,
X_Rate_Adjustment_Factor => p_asset_fin_rec.rate_adjustment_factor,
X_Adjusted_Cost => p_asset_fin_rec.adjusted_cost,
X_Cost => p_asset_fin_rec.cost,
X_Original_Cost => p_asset_fin_rec.original_cost,
X_Salvage_Value => p_asset_fin_rec.salvage_value,
X_Prorate_Convention_Code => p_asset_fin_rec.prorate_convention_code,
X_Prorate_Date => p_asset_fin_rec.prorate_date,
X_Cost_Change_Flag => p_asset_fin_rec.cost_change_flag,
X_Adjustment_Required_Status => p_asset_fin_rec.adjustment_required_status,
X_Capitalize_Flag => p_asset_fin_rec.capitalize_flag,
X_Retirement_Pending_Flag => p_asset_fin_rec.retirement_pending_flag,
X_Depreciate_Flag => p_asset_fin_rec.depreciate_flag,
X_Disabled_Flag => p_asset_fin_rec.disabled_flag,--HH
X_Last_Update_Date => p_trans_rec.who_info.last_update_date,
X_Last_Updated_By => p_trans_rec.who_info.last_updated_by,
X_Date_Ineffective => NULL,
X_Transaction_Header_Id_In => p_trans_rec.transaction_header_id,
X_Transaction_Header_Id_Out => NULL,
X_Itc_Amount_Id => p_asset_fin_rec.itc_amount_id,
X_Itc_Amount => p_asset_fin_rec.itc_amount,
X_Retirement_Id => p_asset_fin_rec.retirement_id,
X_Tax_Request_Id => p_asset_fin_rec.tax_request_id,
X_Itc_Basis => p_asset_fin_rec.itc_basis,
X_Basic_Rate => p_asset_fin_rec.basic_rate,
X_Adjusted_Rate => p_asset_fin_rec.adjusted_rate,
X_Bonus_Rule => p_asset_fin_rec.bonus_rule,
X_Ceiling_Name => p_asset_fin_rec.ceiling_name,
X_Recoverable_Cost => p_asset_fin_rec.recoverable_cost,
X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
X_Adjusted_Capacity => p_asset_fin_rec.adjusted_capacity,
X_Fully_Rsvd_Revals_Counter => p_asset_fin_rec.period_counter_capitalized,
X_PC_Fully_Reserved => p_asset_fin_rec.period_counter_fully_reserved,
X_Period_Counter_Fully_Retired => p_asset_fin_rec.period_counter_fully_retired,
X_Production_Capacity => p_asset_fin_rec.production_capacity,
X_Reval_Amortization_Basis => p_asset_fin_rec.reval_amortization_basis,
X_Reval_Ceiling => p_asset_fin_rec.reval_ceiling,
X_Unit_Of_Measure => p_asset_fin_rec.unit_of_measure,
X_Unrevalued_Cost => p_asset_fin_rec.unrevalued_cost,
X_Annual_Deprn_Rounding_Flag => p_asset_fin_rec.annual_deprn_rounding_flag,
X_Percent_Salvage_Value => p_asset_fin_rec.percent_salvage_value,
X_Allowed_Deprn_Limit => p_asset_fin_rec.allowed_deprn_limit,
X_Allowed_Deprn_Limit_Amount => p_asset_fin_rec.allowed_deprn_limit_amount,
X_Period_Counter_Life_Complete => p_asset_fin_rec.period_counter_life_complete,
X_Adjusted_Recoverable_Cost => p_asset_fin_rec.adjusted_recoverable_cost,
X_Short_Fiscal_Year_Flag => p_asset_fin_rec.short_fiscal_year_flag,
X_Conversion_Date => p_asset_fin_rec.conversion_date,
X_Orig_Deprn_Start_Date => p_asset_fin_rec.orig_deprn_start_date,
X_Remaining_Life1 => p_asset_fin_rec.remaining_life1,
X_Remaining_Life2 => p_asset_fin_rec.remaining_life2,
X_Old_Adj_Cost => p_asset_fin_rec.old_adjusted_cost,
X_Formula_Factor => p_asset_fin_rec.formula_factor,
X_gf_attribute1 => p_asset_fin_rec.global_attribute1,
X_gf_attribute2 => p_asset_fin_rec.global_attribute2,
X_gf_attribute3 => p_asset_fin_rec.global_attribute3,
X_gf_attribute4 => p_asset_fin_rec.global_attribute4,
X_gf_attribute5 => p_asset_fin_rec.global_attribute5,
X_gf_attribute6 => p_asset_fin_rec.global_attribute6,
X_gf_attribute7 => p_asset_fin_rec.global_attribute7,
X_gf_attribute8 => p_asset_fin_rec.global_attribute8,
X_gf_attribute9 => p_asset_fin_rec.global_attribute9,
X_gf_attribute10 => p_asset_fin_rec.global_attribute10,
X_gf_attribute11 => p_asset_fin_rec.global_attribute11,
X_gf_attribute12 => p_asset_fin_rec.global_attribute12,
X_gf_attribute13 => p_asset_fin_rec.global_attribute13,
X_gf_attribute14 => p_asset_fin_rec.global_attribute14,
X_gf_attribute15 => p_asset_fin_rec.global_attribute15,
X_gf_attribute16 => p_asset_fin_rec.global_attribute16,
X_gf_attribute17 => p_asset_fin_rec.global_attribute17,
X_gf_attribute18 => p_asset_fin_rec.global_attribute18,
X_gf_attribute19 => p_asset_fin_rec.global_attribute19,
X_gf_attribute20 => p_asset_fin_rec.global_attribute20,
X_global_attribute_category => p_asset_fin_rec.global_attribute_category,
X_group_asset_id => p_asset_fin_rec.group_asset_id,
X_salvage_type => p_asset_fin_rec.salvage_type,
X_deprn_limit_type => p_asset_fin_rec.deprn_limit_type,
X_over_depreciate_option => p_asset_fin_rec.over_depreciate_option,
X_super_group_id => p_asset_fin_rec.super_group_id,
X_reduction_rate => p_asset_fin_rec.reduction_rate,
X_reduce_addition_flag => p_asset_fin_rec.reduce_addition_flag,
X_reduce_adjustment_flag => p_asset_fin_rec.reduce_adjustment_flag,
X_reduce_retirement_flag => p_asset_fin_rec.reduce_retirement_flag,
X_recognize_gain_loss => p_asset_fin_rec.recognize_gain_loss,
X_recapture_reserve_flag => p_asset_fin_rec.recapture_reserve_flag,
X_limit_proceeds_flag => p_asset_fin_rec.limit_proceeds_flag,
X_terminal_gain_loss => p_asset_fin_rec.terminal_gain_loss,
X_exclude_proceeds_from_basis => p_asset_fin_rec.exclude_proceeds_from_basis,
X_retirement_deprn_option => p_asset_fin_rec.retirement_deprn_option,
X_tracking_method => p_asset_fin_rec.tracking_method,
X_allocate_to_fully_rsv_flag => p_asset_fin_rec.allocate_to_fully_rsv_flag,
X_allocate_to_fully_ret_flag => p_asset_fin_rec.allocate_to_fully_ret_flag,
X_exclude_fully_rsv_flag => p_asset_fin_rec.exclude_fully_rsv_flag,
X_excess_allocation_option => p_asset_fin_rec.excess_allocation_option,
X_depreciation_option => p_asset_fin_rec.depreciation_option,
X_member_rollup_flag => p_asset_fin_rec.member_rollup_flag,
X_ytd_proceeds => p_asset_fin_rec.ytd_proceeds,
X_ltd_proceeds => p_asset_fin_rec.ltd_proceeds,
X_eofy_reserve => p_asset_fin_rec.eofy_reserve,
X_terminal_gain_loss_amount => p_asset_fin_rec.terminal_gain_loss_amount,
X_ltd_cost_of_removal => p_asset_fin_rec.ltd_cost_of_removal,
X_cip_cost => p_asset_fin_rec.cip_cost,
X_contract_id => p_asset_fin_rec.contract_id, -- Bug:6021567
X_mrc_sob_type_code => p_mrc_sob_type_code,
X_Return_Status => l_return_status,
X_Calling_Fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec);
fa_asset_history_pkg.insert_row (
X_Rowid => l_rowid,
X_Asset_Id => p_asset_hdr_rec.asset_id,
X_Category_Id => p_asset_cat_rec.category_id,
X_Asset_Type => upper(p_asset_type_rec.asset_type),
X_Units => p_asset_desc_rec.current_units,
X_Date_Effective => l_date_effective,
X_Transaction_Header_Id_In
=> p_trans_rec.transaction_header_id,
X_Transaction_Header_Id_Out
=> NULL,
X_Last_Update_Date => p_trans_rec.who_info.last_update_date,
X_Last_Updated_By => p_trans_rec.who_info.last_updated_by,
X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
X_Return_Status => l_return_status,
X_Calling_Fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec
);
fa_distribution_history_pkg.insert_row (
X_Rowid => l_rowid,
X_Distribution_Id => l_distribution_id,
X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
X_Asset_Id => p_asset_hdr_rec.asset_id,
X_Units_Assigned => px_asset_dist_tbl(i).units_assigned,
X_Date_Effective => l_date_effective,
X_Code_Combination_Id => px_asset_dist_tbl(i).expense_ccid,
X_Location_Id => px_asset_dist_tbl(i).location_ccid,
X_Transaction_Header_Id_In
=> p_dist_trans_rec.transaction_header_id,
X_Last_Update_Date =>
p_dist_trans_rec.who_info.last_update_date,
X_Last_Updated_By =>
p_dist_trans_rec.who_info.last_updated_by,
X_Date_Ineffective => NULL,
X_Assigned_To => px_asset_dist_tbl(i).assigned_to,
X_Transaction_Header_Id_Out
=> NULL,
X_Transaction_Units => NULL,
X_Retirement_Id => p_asset_fin_rec.retirement_id,
X_Last_Update_Login =>
p_dist_trans_rec.who_info.last_update_login,
X_Calling_Fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec
);
fa_deprn_summary_pkg.insert_row (
X_Rowid => l_ds_rowid,
X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
X_Asset_Id => p_asset_hdr_rec.asset_id,
X_Deprn_Run_Date => l_deprn_run_date,
X_Deprn_Amount => nvl(p_asset_deprn_rec.deprn_amount,0),
X_Ytd_Deprn => nvl(p_asset_deprn_rec.ytd_deprn,0),
X_Deprn_Reserve => nvl(p_asset_deprn_rec.deprn_reserve,0),
X_Deprn_Source_Code => 'BOOKS',
X_Adjusted_Cost => nvl(p_asset_fin_rec.adjusted_cost,0),
X_Bonus_Rate => l_bonus_rate,
X_Ltd_Production => p_asset_deprn_rec.ltd_production,
X_Period_Counter => l_period_counter,
X_Production => p_asset_deprn_rec.production,
X_Reval_Amortization => p_asset_deprn_rec.reval_amortization,
X_Reval_Amortization_Basis
=> p_asset_deprn_rec.reval_amortization_basis,
X_Reval_Deprn_Expense => p_asset_deprn_rec.reval_deprn_expense,
X_Reval_Reserve => p_asset_deprn_rec.reval_deprn_reserve,
X_Ytd_Production => p_asset_deprn_rec.ytd_production,
X_Ytd_Reval_Deprn_Expense
=> p_asset_deprn_rec.reval_ytd_deprn,
X_Bonus_Deprn_Amount => p_asset_deprn_rec.bonus_deprn_amount,
X_Bonus_Ytd_Deprn => p_asset_deprn_rec.bonus_ytd_deprn,
X_Bonus_Deprn_Reserve => p_asset_deprn_rec.bonus_deprn_reserve,
X_mrc_sob_type_code => p_mrc_sob_type_code,
X_Calling_Fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec
);
fa_books_summary_pkg.insert_row (
X_Rowid => l_rowid,
X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
X_Asset_Id => p_asset_hdr_rec.asset_id,
X_Period_Counter => l_period_counter + 1,
X_Calendar_Period_Open_Date =>
l_period_rec.calendar_period_open_date,
X_Calendar_Period_Close_Date =>
l_period_rec.calendar_period_close_date,
X_Reset_Adjusted_Cost_Flag => 'Y',
X_Change_In_Cost => 0,
X_Change_In_Additions_Cost => 0,
X_Change_In_Adjustments_Cost => 0,
X_Change_In_Retirements_Cost => 0,
X_Change_In_Group_Rec_Cost => 0,
X_Change_In_CIP_Cost => 0,
X_Cost => p_asset_fin_rec.cost,
X_CIP_Cost => p_asset_fin_rec.cip_cost,
X_Salvage_Type => p_asset_fin_rec.salvage_type,
X_Percent_Salvage_Value => p_asset_fin_rec.percent_salvage_value,
X_Salvage_Value => p_asset_fin_rec.salvage_value,
X_Member_Salvage_Value => 0,
X_Recoverable_Cost => p_asset_fin_rec.recoverable_cost,
X_Deprn_Limit_Type => p_asset_fin_rec.deprn_limit_type,
X_Allowed_Deprn_Limit => p_asset_fin_rec.allowed_deprn_limit,
X_Allowed_Deprn_Limit_Amount =>
p_asset_fin_rec.allowed_deprn_limit_amount,
X_Member_Deprn_Limit_Amount => 0,
X_Adjusted_Recoverable_Cost =>
p_asset_fin_rec.adjusted_recoverable_cost,
X_Adjusted_Cost => p_asset_fin_rec.adjusted_cost,
X_Depreciate_Flag => p_asset_fin_rec.depreciate_flag,
X_Disabled_Flag => p_asset_fin_rec.disabled_flag,
X_Date_Placed_In_Service => p_asset_fin_rec.date_placed_in_service,
X_Deprn_Method_Code => p_asset_fin_rec.deprn_method_code,
X_Life_In_Months => p_asset_fin_rec.life_in_months,
X_Rate_Adjustment_Factor => p_asset_fin_rec.rate_adjustment_factor,
X_Adjusted_Rate => p_asset_fin_rec.adjusted_rate,
X_Bonus_Rule => p_asset_fin_rec.bonus_rule,
X_Adjusted_Capacity => p_asset_fin_rec.adjusted_capacity,
X_Production_Capacity => p_asset_fin_rec.production_capacity,
X_Unit_Of_Measure => p_asset_fin_rec.unit_of_measure,
X_Remaining_Life1 => p_asset_fin_rec.remaining_life1,
X_Remaining_Life2 => p_asset_fin_rec.remaining_life2,
X_Formula_Factor => p_asset_fin_rec.formula_factor,
X_Unrevalued_Cost => p_asset_fin_rec.unrevalued_cost,
X_Reval_Amortization_Basis =>
p_asset_fin_rec.reval_amortization_basis,
X_Reval_Ceiling => p_asset_fin_rec.reval_ceiling,
X_Ceiling_Name => p_asset_fin_rec.ceiling_name,
X_Eofy_Adj_Cost => nvl(p_asset_fin_rec.eofy_adj_cost, 0),
X_Eofy_Formula_Factor =>
nvl(p_asset_fin_rec.eofy_formula_factor, 1),
X_Eofy_Reserve => nvl(p_asset_fin_rec.eofy_reserve, 0),
X_Eop_Adj_Cost => nvl(p_asset_fin_rec.eop_adj_cost, 0),
X_Eop_Formula_Factor =>
nvl(p_asset_fin_rec.eop_formula_factor, 1),
X_Short_Fiscal_Year_Flag => p_asset_fin_rec.short_fiscal_year_flag,
X_Group_Asset_ID => p_asset_fin_rec.group_asset_id,
X_Super_Group_ID => p_asset_fin_rec.super_group_id,
X_Over_Depreciate_Option => p_asset_fin_rec.over_depreciate_option,
X_Fully_Rsvd_Revals_Counter =>
p_asset_fin_rec.period_counter_capitalized,
X_Capitalized_Flag => l_capitalized_flag,
X_Fully_Reserved_Flag => l_fully_reserved_flag,
X_Fully_Retired_Flag => l_fully_retired_flag,
X_Life_Complete_Flag => l_life_complete_flag,
X_Terminal_Gain_Loss_Amount =>
nvl(p_asset_fin_rec.terminal_gain_loss_amount, 0),
X_Terminal_Gain_Loss_Flag =>
nvl(p_asset_fin_rec.terminal_gain_loss_flag, 'N'),
X_Deprn_Amount => nvl(p_asset_deprn_rec.deprn_amount,0),
X_Ytd_Deprn => nvl(p_asset_deprn_rec.ytd_deprn,0),
X_Deprn_Reserve => nvl(p_asset_deprn_rec.deprn_reserve,0),
X_Bonus_Deprn_Amount => p_asset_deprn_rec.bonus_deprn_amount,
X_Bonus_Ytd_Deprn => p_asset_deprn_rec.bonus_ytd_deprn,
X_Bonus_Deprn_Reserve => p_asset_deprn_rec.bonus_deprn_reserve,
X_Bonus_Rate => l_bonus_rate,
X_Ltd_Production => p_asset_deprn_rec.ltd_production,
X_Ytd_Production => p_asset_deprn_rec.ytd_production,
X_Production => p_asset_deprn_rec.production,
X_Reval_Amortization => p_asset_deprn_rec.reval_amortization,
X_Reval_Deprn_Expense => p_asset_deprn_rec.reval_deprn_expense,
X_Reval_Reserve => p_asset_deprn_rec.reval_deprn_reserve,
X_Ytd_Reval_Deprn_Expense => p_asset_deprn_rec.reval_ytd_deprn,
X_Deprn_Override_Flag => deprn_override_flag_default,
X_System_Deprn_Amount => 0,
X_System_Bonus_Deprn_Amount => 0,
X_Ytd_Proceeds_Of_Sale => p_asset_fin_rec.ytd_proceeds,
X_Ltd_Proceeds_Of_Sale => p_asset_fin_rec.ltd_proceeds,
X_Ytd_Cost_Of_Removal => 0,
X_Ltd_Cost_Of_Removal =>
nvl(p_asset_fin_rec.ltd_cost_of_removal, 0),
X_Deprn_Adjustment_Amount => 0,
X_Expense_Adjustment_Amount => 0,
X_Unplanned_Amount => 0,
X_Reserve_Adjustment_Amount => 0,
X_Last_Update_Date => p_trans_rec.who_info.last_update_date,
X_Last_Updated_By => p_trans_rec.who_info.last_updated_by,
X_Created_By => p_trans_rec.who_info.created_by,
X_Creation_Date => p_trans_rec.who_info.creation_date,
X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
X_Change_In_Eofy_Reserve => 0,
X_Switch_Code => NULL, -- derived at depreciation
X_mrc_sob_type_code => p_mrc_sob_type_code,
X_Return_Status => l_return_status,
X_Calling_Fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec);
fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'trx_subtype', p_trans_rec.transaction_subtype
,p_log_level_rec => p_log_level_rec);
fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'asset_type', p_asset_type_rec.asset_type
,p_log_level_rec => p_log_level_rec);
fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'group asset id', p_asset_fin_rec.group_asset_id
,p_log_level_rec => p_log_level_rec);
fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'annaul round flag', p_asset_fin_rec.annual_deprn_rounding_flag
,p_log_level_rec => p_log_level_rec);
fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'p_trans_rec.transaction_date_entered', p_trans_rec.transaction_date_entered
,p_log_level_rec => p_log_level_rec);
fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'p_period_rec.calendar_period_open_date', p_period_rec.calendar_period_open_date
,p_log_level_rec => p_log_level_rec);
fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'l_deprn_exp after faxexp',
l_deprn_exp, p_log_level_rec => p_log_level_rec);
fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'l_bonus_deprn_exp after faxexp',
l_bonus_deprn_exp, p_log_level_rec => p_log_level_rec);
fa_debug_pkg.add('fa_addition_pvt.insert_asset', 'Calling fa_books_pkg.update_row',
'after calling faxexp', p_log_level_rec => p_log_level_rec);
fa_books_pkg.update_row
(X_asset_id => p_asset_hdr_rec.asset_id,
X_book_type_code => p_asset_hdr_rec.book_type_code,
X_rate_adjustment_factor => p_asset_fin_rec.rate_adjustment_factor,
X_reval_amortization_basis => p_asset_fin_rec.reval_amortization_basis,
X_adjusted_cost => p_asset_fin_rec.adjusted_cost,
X_adjusted_capacity => p_asset_fin_rec.adjusted_capacity,
X_formula_factor => p_asset_fin_rec.formula_factor,
X_eofy_reserve => p_asset_fin_rec.eofy_reserve,
X_mrc_sob_type_code => p_mrc_sob_type_code,
X_calling_fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec);
FA_DEPRN_SUMMARY_PKG.Update_Row (
X_Rowid => l_ds_rowid,
X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
X_Asset_Id => p_asset_hdr_rec.asset_id,
X_Deprn_Run_Date => p_trans_rec.who_info.last_update_date,
X_Deprn_Amount => p_asset_deprn_rec.deprn_amount,
X_Ytd_Deprn => p_asset_deprn_rec.ytd_deprn,
X_Deprn_Reserve => p_asset_deprn_rec.deprn_reserve,
X_Deprn_Source_Code => 'BOOKS',
X_Adjusted_Cost => p_asset_fin_rec.adjusted_cost,
X_Bonus_Rate => NULL,
X_Ltd_Production => NULL,
X_Period_Counter => l_period_counter,
X_Production => NULL,
X_Reval_Amortization => p_asset_deprn_rec.reval_amortization,
X_Reval_Amortization_Basis => l_reval_amortization_basis,
X_Reval_Deprn_Expense => p_asset_deprn_rec.reval_deprn_expense,
X_Reval_Reserve => p_asset_deprn_rec.reval_deprn_reserve,
X_Ytd_Production => NULL,
X_Ytd_Reval_Deprn_Expense => p_asset_deprn_rec.reval_ytd_deprn,
X_mrc_sob_type_code => p_mrc_sob_type_code,
X_Calling_Fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec);
fa_books_pkg.update_row
(X_asset_id => p_asset_hdr_rec.asset_id,
X_book_type_code => p_asset_hdr_rec.book_type_code,
X_rate_adjustment_factor => p_asset_fin_rec.rate_adjustment_factor,
X_reval_amortization_basis => p_asset_fin_rec.reval_amortization_basis,
X_adjusted_cost => p_asset_fin_rec.adjusted_cost,
X_adjusted_capacity => p_asset_fin_rec.adjusted_capacity,
X_formula_factor => p_asset_fin_rec.formula_factor,
X_eofy_reserve => p_asset_fin_rec.eofy_reserve,
X_mrc_sob_type_code => p_mrc_sob_type_code,
X_calling_fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec);
delete from fa_adjustments
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and adjustment_type in ('COST', 'COST CLEARING');
delete from fa_adjustments_mrc_v
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and adjustment_type in ('COST', 'COST CLEARING');
FA_DEPRN_SUMMARY_PKG.Update_Row (
X_Rowid => l_ds_rowid,
X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
X_Asset_Id => p_asset_hdr_rec.asset_id,
X_Deprn_Run_Date => p_trans_rec.who_info.last_update_date,
X_Deprn_Amount => p_asset_deprn_rec.deprn_amount,
X_Ytd_Deprn => p_asset_deprn_rec.ytd_deprn,
X_Deprn_Reserve => p_asset_deprn_rec.deprn_reserve,
X_Deprn_Source_Code => 'BOOKS',
X_Adjusted_Cost => p_asset_fin_rec.adjusted_cost,
X_Bonus_Rate => NULL,
X_Ltd_Production => NULL,
X_Period_Counter => l_period_counter,
X_Production => NULL,
X_Reval_Amortization => p_asset_deprn_rec.reval_amortization,
X_Reval_Amortization_Basis => l_reval_amortization_basis,
X_Reval_Deprn_Expense => p_asset_deprn_rec.reval_deprn_expense,
X_Reval_Reserve => p_asset_deprn_rec.reval_deprn_reserve,
X_Ytd_Production => NULL,
X_Ytd_Reval_Deprn_Expense => p_asset_deprn_rec.reval_ytd_deprn,
X_mrc_sob_type_code => p_mrc_sob_type_code,
X_Calling_Fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec);
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 general_error;
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 general_error;
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 general_error;
p_calling_fn => 'fa_addition_pvt.insert_asset',
p_log_level_rec => p_log_level_rec) then raise general_error;
fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.insert_asset',
name => 'FA_ADD_SWITCH_NBV_WITHOUT_RSV');
fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.insert_asset');
select count(*)
into l_revised_count
from fa_methods mt,
fa_formulas f
where mt.method_code = p_asset_fin_rec.deprn_method_code
and mt.life_in_months = p_asset_fin_rec.life_in_months
and mt.method_id = f.method_id
and f.revised_rate = l_rate_in_use;
fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.insert_asset',
name => 'FA_ADD_REVISED_WITHOUT_SWITCH');
fa_srvr_msg.add_message(calling_fn => 'fa_addition_pvt.insert_asset',
name => 'FA_ADD_SWITCH_NBV_ORIGINAL_RAT');
UPDATE FA_BOOKS
SET adjusted_cost = p_asset_fin_rec.nbv_at_switch
WHERE book_type_code = p_asset_hdr_rec.book_type_code
AND asset_id = p_asset_hdr_rec.asset_id
AND date_ineffective is null;
UPDATE FA_DEPRN_SUMMARY
SET adjusted_cost = p_asset_fin_rec.nbv_at_switch
WHERE book_type_code = p_asset_hdr_rec.book_type_code
AND asset_id = p_asset_hdr_rec.asset_id
AND DEPRN_SOURCE_CODE = 'BOOKS';
UPDATE FA_BOOKS
SET rate_in_use = l_rate_in_use
WHERE book_type_code = p_asset_hdr_rec.book_type_code
AND asset_id = p_asset_hdr_rec.asset_id
AND date_ineffective is null;
mc_fa_utilities_pkg.insert_books_rates (
p_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
p_asset_id => p_asset_hdr_rec.asset_id,
p_book_type_code => p_asset_hdr_rec.book_type_code,
p_transaction_header_id => p_trans_rec.transaction_header_id,
p_invoice_transaction_id => p_inv_trans_rec.invoice_transaction_id,
p_exchange_date => p_trans_rec.transaction_date_entered,
p_cost => p_primary_cost,
p_exchange_rate => p_exchange_rate,
p_avg_exchange_rate => p_exchange_rate,
p_last_updated_by => p_trans_rec.who_info.last_updated_by,
p_last_update_date => p_trans_rec.who_info.last_update_date,
p_last_update_login => p_trans_rec.who_info.last_update_login,
p_complete => 'Y',
p_trigger => 'fa_addition_pvt.insert_asset',
p_currency_code => to_char(p_asset_hdr_rec.set_of_books_id),
p_log_level_rec => p_log_level_rec
);
calling_fn => 'fa_addition_pvt.insert_asset'
,p_log_level_rec => p_log_level_rec);
calling_fn => 'fa_addition_pvt.insert_asset'
,p_log_level_rec => p_log_level_rec);
calling_fn => 'fa_addition_pvt.insert_asset'
,p_log_level_rec => p_log_level_rec);
end insert_asset;