The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL (meaning, p_lookup_code)
FROM fa_lookups
WHERE lookup_code = p_lookup_code AND lookup_type = 'YESNO';
SELECT fa_transaction_headers_s.NEXTVAL
INTO px_trans_rec.transaction_header_id
FROM DUAL;
px_trans_rec.who_info.last_update_date := sysdate;
'after call to fareven insert_txn_flag',
l_reval_out_rec.insert_txn_flag
, p_log_level_rec => p_log_level_rec);
AND l_reval_out_rec.insert_txn_flag
)
THEN
-- insert transaction headers
IF (p_mrc_sob_type_code <> 'R')
THEN
IF (p_log_level_rec.statement_level)
THEN
fa_debug_pkg.ADD (l_calling_fn,
'trx_date before insert',
px_trans_rec.transaction_date_entered
, p_log_level_rec => p_log_level_rec);
create/update/delete event for secondary ledger*/
l_secondary_sob_id := FA_XLA_EVENTS_PVT.get_secondary_sob_id(px_asset_hdr_rec.book_type_code);
fa_transaction_headers_pkg.insert_row
(x_rowid => l_th_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.creation_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_invoice_transaction_id => NULL,
x_source_transaction_header_id => px_trans_rec.source_transaction_header_id,
x_mass_reference_id => px_trans_rec.mass_reference_id,
x_last_update_login => px_trans_rec.who_info.last_update_login,
x_transaction_subtype => px_trans_rec.transaction_subtype,
x_attribute1 => px_trans_rec.desc_flex.attribute1,
x_attribute2 => px_trans_rec.desc_flex.attribute2,
x_attribute3 => px_trans_rec.desc_flex.attribute3,
x_attribute4 => px_trans_rec.desc_flex.attribute4,
x_attribute5 => px_trans_rec.desc_flex.attribute5,
x_attribute6 => px_trans_rec.desc_flex.attribute6,
x_attribute7 => px_trans_rec.desc_flex.attribute7,
x_attribute8 => px_trans_rec.desc_flex.attribute8,
x_attribute9 => px_trans_rec.desc_flex.attribute9,
x_attribute10 => px_trans_rec.desc_flex.attribute10,
x_attribute11 => px_trans_rec.desc_flex.attribute11,
x_attribute12 => px_trans_rec.desc_flex.attribute12,
x_attribute13 => px_trans_rec.desc_flex.attribute13,
x_attribute14 => px_trans_rec.desc_flex.attribute14,
x_attribute15 => px_trans_rec.desc_flex.attribute15,
x_attribute_category_code => px_trans_rec.desc_flex.attribute_category_code,
x_transaction_key => px_trans_rec.transaction_key,
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_member_transaction_header_id => px_trans_rec.member_transaction_header_id,
x_trx_reference_id => px_trans_rec.trx_reference_id,
x_event_id => px_trans_rec.event_id,
x_return_status => l_status,
x_calling_fn => l_calling_fn
, p_log_level_rec => p_log_level_rec);
INSERT INTO FA_DEPRN_SUMMARY( BOOK_TYPE_CODE
, ASSET_ID
, PERIOD_COUNTER
, DEPRN_RUN_DATE
, DEPRN_AMOUNT
, YTD_DEPRN
, DEPRN_RESERVE
, DEPRN_SOURCE_CODE
, ADJUSTED_COST
, BONUS_RATE
, REVAL_AMORTIZATION
, REVAL_DEPRN_EXPENSE
, REVAL_RESERVE
, YTD_REVAL_DEPRN_EXPENSE
, PRODUCTION
, YTD_PRODUCTION
, LTD_PRODUCTION
, REVAL_AMORTIZATION_BASIS
, PRIOR_FY_EXPENSE
, BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE
, BONUS_DEPRN_ADJUSTMENT_AMOUNT
, PRIOR_FY_BONUS_EXPENSE
, DEPRN_OVERRIDE_FLAG
, SYSTEM_DEPRN_AMOUNT
, SYSTEM_BONUS_DEPRN_AMOUNT
, IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT
, IMPAIRMENT_RESERVE
, CAPITAL_ADJUSTMENT
, GENERAL_FUND
, DEPRN_ADJUSTMENT_AMOUNT
, REVAL_LOSS_BALANCE
) VALUES ( px_asset_hdr_rec.book_type_code -- BOOK_TYPE_CODE
, px_asset_hdr_rec.asset_id -- ASSET_ID
, p_period_rec.period_counter -- PERIOD_COUNTER
, px_trans_rec.who_info.last_update_date -- DEPRN_RUN_DATE
, l_asset_deprn_rec_new.deprn_amount +
nvl(l_dpr_row.deprn_exp, 0) -- DEPRN_AMOUNT
, l_asset_deprn_rec_new.ytd_deprn +
nvl(l_dpr_row.deprn_exp, 0) -- YTD_DEPRN
, l_asset_deprn_rec_new.deprn_reserve -- DEPRN_RESERVE
, 'DEPRN' -- DEPRN_SOURCE_CODE
, p_asset_fin_rec_old.adjusted_cost -- ADJUSTED_COST
, g_dpr_out.bonus_rate_used -- BONUS_RATE
, l_asset_deprn_rec_new.reval_amortization -- REVAL_AMORTIZATION
, l_asset_deprn_rec_new.reval_deprn_expense -- REVAL_DEPRN_EXPENSE
, l_asset_deprn_rec_new.reval_deprn_reserve -- REVAL_RESERVE
, l_asset_deprn_rec_new.reval_ytd_deprn -- YTD_REVAL_DEPRN_EXPENSE
, l_asset_deprn_rec_new.production -- PRODUCTION
, l_asset_deprn_rec_new.ytd_production -- YTD_PRODUCTION
, l_asset_deprn_rec_new.ltd_production -- LTD_PRODUCTION
, l_asset_deprn_rec_new.reval_amortization_basis -- REVAL_AMORTIZATION_BASIS
, l_asset_deprn_rec_new.prior_fy_expense -- PRIOR_FY_EXPENSE
, l_asset_deprn_rec_new.bonus_deprn_amount + -- BONUS_DEPRN_AMOUNT
nvl(l_dpr_row.bonus_deprn_amount, 0)
, l_asset_deprn_rec_new.bonus_ytd_deprn +
nvl(l_dpr_row.bonus_deprn_amount, 0) -- BONUS_YTD_DEPRN
, l_asset_deprn_rec_new.bonus_deprn_reserve -- BONUS_DEPRN_RESERVE
, nvl(l_dpr_row.bonus_deprn_amount, 0) -- BONUS_DEPRN_ADJUSTMENT_AMOUNT
, l_asset_deprn_rec_new.prior_fy_bonus_expense -- PRIOR_FY_BONUS_EXPENSE
, g_dpr_out.deprn_override_flag -- DEPRN_OVERRIDE_FLAG
, l_asset_deprn_rec_new.DEPRN_AMOUNT -- SYSTEM_DEPRN_AMOUNT
, l_asset_deprn_rec_new.bonus_deprn_amount -- SYSTEM_BONUS_DEPRN_AMOUNT
, l_dpr_row.impairment_amount -- IMPAIRMENT_AMOUNT
, l_asset_deprn_rec_new.ytd_impairment +
l_dpr_row.impairment_amount -- YTD_IMPAIRMENT
, l_asset_deprn_rec_new.impairment_reserve -- IMPAIRMENT_RESERVE
, l_capital_adj -- CAPITAL_ADJUSTMENT
, l_general_fund -- GENERAL_FUND
, nvl(l_dpr_row.deprn_exp, 0) -- DEPRN_ADJUSTMENT_AMOUNT
, NVL(l_asset_deprn_rec_new.reval_loss_balance,0) -- REVAL_LOSS_BALANCE
);
INSERT INTO FA_MC_DEPRN_SUMMARY(SET_OF_BOOKS_ID
, BOOK_TYPE_CODE
, ASSET_ID
, PERIOD_COUNTER
, DEPRN_RUN_DATE
, DEPRN_AMOUNT
, YTD_DEPRN
, DEPRN_RESERVE
, DEPRN_SOURCE_CODE
, ADJUSTED_COST
, BONUS_RATE
, REVAL_AMORTIZATION
, REVAL_DEPRN_EXPENSE
, REVAL_RESERVE
, YTD_REVAL_DEPRN_EXPENSE
, PRODUCTION
, YTD_PRODUCTION
, LTD_PRODUCTION
, REVAL_AMORTIZATION_BASIS
, PRIOR_FY_EXPENSE
, BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE
, BONUS_DEPRN_ADJUSTMENT_AMOUNT
, PRIOR_FY_BONUS_EXPENSE
, DEPRN_OVERRIDE_FLAG
, SYSTEM_DEPRN_AMOUNT
, SYSTEM_BONUS_DEPRN_AMOUNT
, IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT
, IMPAIRMENT_RESERVE
, CAPITAL_ADJUSTMENT
, GENERAL_FUND
, DEPRN_ADJUSTMENT_AMOUNT
, REVAL_LOSS_BALANCE
) VALUES ( px_asset_hdr_rec.set_of_books_id -- SET_OF_BOOKS_ID
, px_asset_hdr_rec.book_type_code -- BOOK_TYPE_CODE
, px_asset_hdr_rec.asset_id -- ASSET_ID
, p_period_rec.period_counter -- PERIOD_COUNTER
, px_trans_rec.who_info.last_update_date -- DEPRN_RUN_DATE
, l_asset_deprn_rec_new.deprn_amount +
nvl(l_dpr_row.deprn_exp, 0) -- DEPRN_AMOUNT
, l_asset_deprn_rec_new.ytd_deprn +
nvl(l_dpr_row.deprn_exp, 0) -- YTD_DEPRN
, l_asset_deprn_rec_new.deprn_reserve -- DEPRN_RESERVE
, 'DEPRN' -- DEPRN_SOURCE_CODE
, p_asset_fin_rec_old.adjusted_cost -- ADJUSTED_COST
, g_dpr_out.bonus_rate_used -- BONUS_RATE
, l_asset_deprn_rec_new.reval_amortization -- REVAL_AMORTIZATION
, l_asset_deprn_rec_new.reval_deprn_expense -- REVAL_DEPRN_EXPENSE
, l_asset_deprn_rec_new.reval_deprn_reserve -- REVAL_RESERVE
, l_asset_deprn_rec_new.reval_ytd_deprn -- YTD_REVAL_DEPRN_EXPENSE
, l_asset_deprn_rec_new.production -- PRODUCTION
, l_asset_deprn_rec_new.ytd_production -- YTD_PRODUCTION
, l_asset_deprn_rec_new.ltd_production -- LTD_PRODUCTION
, l_asset_deprn_rec_new.reval_amortization_basis -- REVAL_AMORTIZATION_BASIS
, l_asset_deprn_rec_new.prior_fy_expense -- PRIOR_FY_EXPENSE
, l_asset_deprn_rec_new.bonus_deprn_amount + -- BONUS_DEPRN_AMOUNT
nvl(l_dpr_row.bonus_deprn_amount, 0)
, l_asset_deprn_rec_new.bonus_ytd_deprn +
nvl(l_dpr_row.bonus_deprn_amount, 0) -- BONUS_YTD_DEPRN
, l_asset_deprn_rec_new.bonus_deprn_reserve -- BONUS_DEPRN_RESERVE
, nvl(l_dpr_row.bonus_deprn_amount, 0) -- BONUS_DEPRN_ADJUSTMENT_AMOUNT
, l_asset_deprn_rec_new.prior_fy_bonus_expense -- PRIOR_FY_BONUS_EXPENSE
, g_dpr_out.deprn_override_flag -- DEPRN_OVERRIDE_FLAG
, l_asset_deprn_rec_new.DEPRN_AMOUNT -- SYSTEM_DEPRN_AMOUNT
, l_asset_deprn_rec_new.bonus_deprn_amount -- SYSTEM_BONUS_DEPRN_AMOUNT
, l_dpr_row.impairment_amount -- IMPAIRMENT_AMOUNT
, l_asset_deprn_rec_new.ytd_impairment +
l_dpr_row.impairment_amount -- YTD_IMPAIRMENT
, l_asset_deprn_rec_new.impairment_reserve -- IMPAIRMENT_RESERVE
, l_capital_adj -- CAPITAL_ADJUSTMENT
, l_general_fund -- GENERAL_FUND
, nvl(l_dpr_row.deprn_exp, 0) -- DEPRN_ADJUSTMENT_AMOUNT
, NVL(l_asset_deprn_rec_new.reval_loss_balance,0) -- REVAL_LOSS_BALANCE
);
x_date_ineffective => px_trans_rec.who_info.last_update_date,
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 => l_calling_fn
, p_log_level_rec => p_log_level_rec);
fa_books_pkg.insert_row
(x_rowid => l_bks_rowid,
x_book_type_code => px_asset_hdr_rec.book_type_code,
x_asset_id => px_asset_hdr_rec.asset_id,
x_date_placed_in_service => l_asset_fin_rec_new.date_placed_in_service,
x_date_effective => px_trans_rec.who_info.last_update_date,
x_deprn_start_date => l_asset_fin_rec_new.deprn_start_date,
x_deprn_method_code => l_asset_fin_rec_new.deprn_method_code,
x_life_in_months => l_asset_fin_rec_new.life_in_months,
x_rate_adjustment_factor => l_asset_fin_rec_new.rate_adjustment_factor,
x_adjusted_cost => l_asset_fin_rec_new.adjusted_cost,
x_cost => l_asset_fin_rec_new.COST,
x_original_cost => l_asset_fin_rec_new.original_cost,
x_salvage_value => l_asset_fin_rec_new.salvage_value,
x_prorate_convention_code => l_asset_fin_rec_new.prorate_convention_code,
x_prorate_date => l_asset_fin_rec_new.prorate_date,
x_cost_change_flag => l_asset_fin_rec_new.cost_change_flag,
x_adjustment_required_status => l_asset_fin_rec_new.adjustment_required_status,
x_capitalize_flag => l_asset_fin_rec_new.capitalize_flag,
x_retirement_pending_flag => l_asset_fin_rec_new.retirement_pending_flag,
x_depreciate_flag => l_asset_fin_rec_new.depreciate_flag,
x_disabled_flag => l_asset_fin_rec_new.disabled_flag,
--HH
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_date_ineffective => NULL,
x_transaction_header_id_in => px_trans_rec.transaction_header_id,
x_transaction_header_id_out => NULL,
x_itc_amount_id => l_asset_fin_rec_new.itc_amount_id,
x_itc_amount => l_asset_fin_rec_new.itc_amount,
x_retirement_id => l_asset_fin_rec_new.retirement_id,
x_tax_request_id => l_asset_fin_rec_new.tax_request_id,
x_itc_basis => l_asset_fin_rec_new.itc_basis,
x_basic_rate => l_asset_fin_rec_new.basic_rate,
x_adjusted_rate => l_asset_fin_rec_new.adjusted_rate,
x_bonus_rule => l_asset_fin_rec_new.bonus_rule,
x_ceiling_name => l_asset_fin_rec_new.ceiling_name,
x_recoverable_cost => l_asset_fin_rec_new.recoverable_cost,
x_last_update_login => px_trans_rec.who_info.last_update_login,
x_adjusted_capacity => l_asset_fin_rec_new.adjusted_capacity,
x_fully_rsvd_revals_counter => l_asset_fin_rec_new.fully_rsvd_revals_counter,
x_idled_flag => l_asset_fin_rec_new.idled_flag,
x_period_counter_capitalized => l_asset_fin_rec_new.period_counter_capitalized,
x_pc_fully_reserved => l_asset_fin_rec_new.period_counter_fully_reserved,
x_period_counter_fully_retired => l_asset_fin_rec_new.period_counter_fully_retired,
x_production_capacity => l_asset_fin_rec_new.production_capacity,
x_reval_amortization_basis => l_asset_fin_rec_new.reval_amortization_basis,
x_reval_ceiling => l_asset_fin_rec_new.reval_ceiling,
x_unit_of_measure => l_asset_fin_rec_new.unit_of_measure,
x_unrevalued_cost => l_asset_fin_rec_new.unrevalued_cost,
x_annual_deprn_rounding_flag => l_asset_fin_rec_new.annual_deprn_rounding_flag,
x_percent_salvage_value => l_asset_fin_rec_new.percent_salvage_value,
x_allowed_deprn_limit => l_asset_fin_rec_new.allowed_deprn_limit,
x_allowed_deprn_limit_amount => l_asset_fin_rec_new.allowed_deprn_limit_amount,
x_period_counter_life_complete => l_asset_fin_rec_new.period_counter_life_complete,
x_adjusted_recoverable_cost => l_asset_fin_rec_new.adjusted_recoverable_cost,
x_short_fiscal_year_flag => l_asset_fin_rec_new.short_fiscal_year_flag,
x_conversion_date => l_asset_fin_rec_new.conversion_date,
x_orig_deprn_start_date => l_asset_fin_rec_new.orig_deprn_start_date,
x_remaining_life1 => l_asset_fin_rec_new.remaining_life1,
x_remaining_life2 => l_asset_fin_rec_new.remaining_life2,
x_old_adj_cost => l_asset_fin_rec_new.old_adjusted_cost,
x_formula_factor => l_asset_fin_rec_new.formula_factor,
x_gf_attribute1 => l_asset_fin_rec_new.global_attribute1,
x_gf_attribute2 => l_asset_fin_rec_new.global_attribute2,
x_gf_attribute3 => l_asset_fin_rec_new.global_attribute3,
x_gf_attribute4 => l_asset_fin_rec_new.global_attribute4,
x_gf_attribute5 => l_asset_fin_rec_new.global_attribute5,
x_gf_attribute6 => l_asset_fin_rec_new.global_attribute6,
x_gf_attribute7 => l_asset_fin_rec_new.global_attribute7,
x_gf_attribute8 => l_asset_fin_rec_new.global_attribute8,
x_gf_attribute9 => l_asset_fin_rec_new.global_attribute9,
x_gf_attribute10 => l_asset_fin_rec_new.global_attribute10,
x_gf_attribute11 => l_asset_fin_rec_new.global_attribute11,
x_gf_attribute12 => l_asset_fin_rec_new.global_attribute12,
x_gf_attribute13 => l_asset_fin_rec_new.global_attribute13,
x_gf_attribute14 => l_asset_fin_rec_new.global_attribute14,
x_gf_attribute15 => l_asset_fin_rec_new.global_attribute15,
x_gf_attribute16 => l_asset_fin_rec_new.global_attribute16,
x_gf_attribute17 => l_asset_fin_rec_new.global_attribute17,
x_gf_attribute18 => l_asset_fin_rec_new.global_attribute18,
x_gf_attribute19 => l_asset_fin_rec_new.global_attribute19,
x_gf_attribute20 => l_asset_fin_rec_new.global_attribute20,
x_global_attribute_category => l_asset_fin_rec_new.global_attribute_category,
x_group_asset_id => l_asset_fin_rec_new.group_asset_id,
x_salvage_type => l_asset_fin_rec_new.salvage_type,
x_deprn_limit_type => l_asset_fin_rec_new.deprn_limit_type,
x_over_depreciate_option => l_asset_fin_rec_new.over_depreciate_option,
x_super_group_id => l_asset_fin_rec_new.super_group_id,
x_reduction_rate => l_asset_fin_rec_new.reduction_rate,
x_reduce_addition_flag => l_asset_fin_rec_new.reduce_addition_flag,
x_reduce_adjustment_flag => l_asset_fin_rec_new.reduce_adjustment_flag,
x_reduce_retirement_flag => l_asset_fin_rec_new.reduce_retirement_flag,
x_recognize_gain_loss => l_asset_fin_rec_new.recognize_gain_loss,
x_recapture_reserve_flag => l_asset_fin_rec_new.recapture_reserve_flag,
x_limit_proceeds_flag => l_asset_fin_rec_new.limit_proceeds_flag,
x_terminal_gain_loss => l_asset_fin_rec_new.terminal_gain_loss,
x_exclude_proceeds_from_basis => l_asset_fin_rec_new.exclude_proceeds_from_basis,
x_retirement_deprn_option => l_asset_fin_rec_new.retirement_deprn_option,
x_tracking_method => l_asset_fin_rec_new.tracking_method,
x_allocate_to_fully_rsv_flag => l_asset_fin_rec_new.allocate_to_fully_rsv_flag,
x_allocate_to_fully_ret_flag => l_asset_fin_rec_new.allocate_to_fully_ret_flag,
x_exclude_fully_rsv_flag => l_asset_fin_rec_new.exclude_fully_rsv_flag,
x_excess_allocation_option => l_asset_fin_rec_new.excess_allocation_option,
x_depreciation_option => l_asset_fin_rec_new.depreciation_option,
x_member_rollup_flag => l_asset_fin_rec_new.member_rollup_flag,
x_ytd_proceeds => l_asset_fin_rec_new.ytd_proceeds,
x_ltd_proceeds => l_asset_fin_rec_new.ltd_proceeds,
x_eofy_reserve => l_asset_fin_rec_new.eofy_reserve,
x_cip_cost => l_asset_fin_rec_new.cip_cost,
x_terminal_gain_loss_amount => l_asset_fin_rec_new.terminal_gain_loss_amount,
x_ltd_cost_of_removal => l_asset_fin_rec_new.ltd_cost_of_removal,
x_cash_generating_unit_id => l_asset_fin_rec_new.cash_generating_unit_id,
x_mrc_sob_type_code => p_mrc_sob_type_code,
x_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
x_return_status => l_status,
x_calling_fn => l_calling_fn
, p_log_level_rec => p_log_level_rec);
fa_debug_pkg.ADD (l_calling_fn, 'after books insert', 1, p_log_level_rec => p_log_level_rec);
UPDATE FA_BOOKS
SET rate_in_use = l_rate_in_use
WHERE book_type_code = px_asset_hdr_rec.book_type_code
AND asset_id = px_asset_hdr_rec.asset_id
AND date_ineffective is null;
'inserting into: ',
'fa_mass_reval_rep_itf'
, p_log_level_rec => p_log_level_rec);
INSERT INTO fa_mass_reval_rep_itf
(request_id,
mass_reval_id,
book_type_code,
transaction_date_entered,
asset_id,
asset_number,
description,
asset_type,
asset_category_id, CATEGORY,
old_life,
new_life,
old_cost, new_cost,
old_deprn_reserve,
new_deprn_reserve,
old_reval_reserve,
new_reval_reserve,
reval_ceiling,
reval_percent, override_defaults,
reval_fully_rsvd,
life_extension_factor,
life_extension_ceiling,
max_fully_rsvd_revals, old_nbv,
new_nbv, last_update_date,
last_updated_by,
created_by,
creation_date,
last_update_login
)
VALUES (px_trans_rec.mass_reference_id,
px_trans_rec.mass_transaction_id,
px_asset_hdr_rec.book_type_code,
px_trans_rec.transaction_date_entered,
px_asset_hdr_rec.asset_id,
p_asset_desc_rec.asset_number,
p_asset_desc_rec.description,
p_asset_type_rec.asset_type,
p_asset_cat_rec.category_id, l_concat_cat,
p_asset_fin_rec_old.life_in_months,
l_asset_fin_rec_new.life_in_months,
p_asset_fin_rec_old.COST, l_asset_fin_rec_new.COST,
p_asset_deprn_rec_old.deprn_reserve,
l_asset_deprn_rec_new.deprn_reserve,
p_asset_deprn_rec_old.reval_deprn_reserve,
l_asset_deprn_rec_new.reval_deprn_reserve,
l_asset_fin_rec_new.reval_ceiling,
p_reval_options_rec.reval_percent, l_override_defaults,
l_reval_fully_rsvd,
p_reval_options_rec.life_extension_factor,
p_reval_options_rec.life_extension_ceiling,
p_reval_options_rec.max_fully_rsvd_revals, g_old_nbv,
g_new_nbv, px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_update_login
);
'after inserting into: ',
'fa_mass_reval_rep_itf'
, p_log_level_rec => p_log_level_rec);
select sum(decode(debit_credit_flag,'DR',adjustment_amount,-adjustment_amount))
from fa_adjustments
where asset_id = c_asset_id
and book_type_code = c_book
and adjustment_type = 'REVAL LOSS';
select sum(decode(debit_credit_flag,'DR',adjustment_amount,-adjustment_amount))
from fa_mc_adjustments
where asset_id = c_asset_id
and book_type_code = c_book
and adjustment_type = 'REVAL LOSS'
and set_of_books_id = c_sob_id;
x_reval_out.insert_txn_flag := TRUE;
x_reval_out.insert_txn_flag := FALSE;
x_reval_out.insert_txn_flag := FALSE;
x_reval_out.insert_txn_flag := FALSE;
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_date
, p_log_level_rec => p_log_level_rec);
x_reval_out.insert_txn_flag := FALSE;
p_user_id => px_trans_rec.who_info.last_updated_by,
p_curr_date => px_trans_rec.who_info.last_update_date,
px_new_life => l_recalc_life,
p_calling_fn => 'fareven'
, p_log_level_rec => p_log_level_rec)
THEN
RAISE fareven_err;
SELECT fy.fiscal_year, cp.period_num
INTO l_fy, l_period_num
FROM fa_fiscal_year fy, fa_calendar_periods cp
WHERE fy.fiscal_year_name = l_fy_name
AND cp.calendar_type = l_deprn_calendar
AND p_asset_fin_rec_old.prorate_date BETWEEN cp.start_date
AND cp.end_date
AND p_asset_fin_rec_old.prorate_date BETWEEN fy.start_date
AND fy.end_date;
SELECT dp.fiscal_year, dp.period_num
INTO l_fy, l_period_num
FROM fa_deprn_periods dp
WHERE dp.book_type_code = p_asset_hdr_rec.book_type_code
AND dp.period_counter = l_last_period_counter;
l_dpr_in.update_override_status := FALSE;
p_user_id => px_trans_rec.who_info.last_updated_by,
p_curr_date => px_trans_rec.who_info.last_update_date,
px_new_life => l_recalc_life,
p_calling_fn => 'fareven'
, p_log_level_rec => p_log_level_rec)
THEN
RAISE fareven_err;
l_adj_in.last_update_date :=
px_trans_rec.who_info.last_update_date;
l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active;
l_adj_in.selection_thid := 0;
l_adj_in.selection_retid := 0;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
l_adj_in.last_update_date :=
px_trans_rec.who_info.last_update_date;
l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active;
l_adj_in.selection_thid := 0;
l_adj_in.selection_retid := 0;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
l_adj_in.last_update_date :=
px_trans_rec.who_info.last_update_date;
l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active;
l_adj_in.selection_thid := 0;
l_adj_in.selection_retid := 0;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active_reval;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_date
, p_log_level_rec => p_log_level_rec)
THEN
fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'Failure', 'Failure', p_log_level_rec => p_log_level_rec);
l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
fa_debug_pkg.ADD ('fareven', 'failed', 'faxinaj for l_reval_loss_exp', p_log_level_rec => p_log_level_rec);
, px_trans_rec.who_info.last_updated_by
, px_trans_rec.who_info.last_update_date
, p_log_level_rec => p_log_level_rec) THEN
raise fareven_err;
l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
fa_debug_pkg.ADD ('fareven', 'failed', 'faxinaj for l_reval_deprn_exp', p_log_level_rec => p_log_level_rec);
, px_trans_rec.who_info.last_updated_by
, px_trans_rec.who_info.last_update_date
, p_log_level_rec => p_log_level_rec) THEN
raise fareven_err;
l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
fa_debug_pkg.ADD ('fareven', 'failed', 'faxinaj for l_reval_deprn_exp', p_log_level_rec => p_log_level_rec);
, px_trans_rec.who_info.last_updated_by
, px_trans_rec.who_info.last_update_date
, p_log_level_rec => p_log_level_rec) THEN
raise fareven_err;
l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
l_adj_in.selection_mode :=
fa_adjust_type_pkg.fa_aj_active_reval;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
/*Bug#12571702 - If in period of addition need to updated adj_cost in deprn_summary,
this is to calculated adj_cost correctly when auto-deprn rollback happens*/
IF p_asset_hdr_rec.period_of_addition = 'Y' THEN
IF p_mrc_sob_type_code = 'P' THEN
update fa_deprn_summary set adjusted_cost = px_asset_fin_rec_new.adjusted_cost
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and period_counter = l_adj_in.period_counter_adjusted - 1;
update fa_mc_deprn_summary set adjusted_cost = px_asset_fin_rec_new.adjusted_cost
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and set_of_books_id = p_asset_hdr_rec.set_of_books_id
and period_counter = l_adj_in.period_counter_adjusted - 1;
END IF; -- If Insert Transaction Flag = TRUE
x_reval_out.insert_txn_flag := TRUE;
x_reval_out.insert_txn_flag := FALSE;
l_adj_in.last_update_date := px_trans_rec.who_info.last_update_date;
l_adj_in.selection_mode := fa_adjust_type_pkg.fa_aj_active;
l_adj_in.selection_thid := 0;
l_adj_in.selection_retid := 0;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
, px_trans_rec.who_info.last_updated_by
, px_trans_rec.who_info.last_update_date
, p_log_level_rec => p_log_level_rec) THEN
raise farevrl_err;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
update fa_books_summary set reval_loss_balance = reval_loss_balance + ABS (l_reval_loss)
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and period_counter >= l_adj_in.period_counter_adjusted ;
update fa_mc_books_summary set reval_loss_balance = reval_loss_balance + ABS (l_reval_loss)
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and set_of_books_id = p_asset_hdr_rec.set_of_books_id
and period_counter >= l_adj_in.period_counter_adjusted ;
px_trans_rec.who_info.last_update_date,
px_trans_rec.who_info.last_updated_by,
px_trans_rec.who_info.last_update_login,
p_log_level_rec
)
)
THEN
IF (p_log_level_rec.statement_level)
THEN
NULL;
/*Bug#12571702 - If in period of addition need to updated adj_cost in deprn_summary,
this is to calculated adj_cost correctly when auto-deprn rollback happens*/
IF p_asset_hdr_rec.period_of_addition = 'Y' THEN
IF p_mrc_sob_type_code = 'P' THEN
update fa_deprn_summary set adjusted_cost = px_asset_fin_rec_new.adjusted_cost
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and period_counter = l_adj_in.period_counter_adjusted - 1;
update fa_mc_deprn_summary set adjusted_cost = px_asset_fin_rec_new.adjusted_cost
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and set_of_books_id = p_asset_hdr_rec.set_of_books_id
and period_counter = l_adj_in.period_counter_adjusted - 1;
select transaction_header_id
, date_effective
, last_updated_by
from fa_transaction_headers
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and date_effective between l_period_rec.period_open_date
and nvl(l_period_rec.period_close_date, sysdate)
and calling_interface = 'FAXRRB'
and transaction_key = 'RV'
order by transaction_header_id desc;
select count(1)
into l_reval_count
from fa_transaction_headers
where transaction_header_id = p_thid;
if l_reval_count = 0 then /* Event and Reval transaction is deleted */
l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
if not fa_xla_events_pvt.delete_transaction_event
(p_ledger_id => p_asset_hdr_rec.set_of_books_id,
p_transaction_header_id => p_thid,
p_book_type_code => p_asset_hdr_rec.book_type_code,
p_calling_fn => l_calling_fn
,p_log_level_rec => p_log_level_rec) then
if (p_log_level_rec.statement_level) then
fa_debug_pkg.add(l_calling_fn,'Failed ','delete_transaction_event',p_log_level_rec => p_log_level_rec);
delete from fa_books
where transaction_header_id_out is null
and transaction_header_id_in = p_thid
and book_type_code = p_asset_hdr_rec.book_type_code
and asset_id = p_asset_hdr_rec.asset_id ;
delete from fa_adjustments
where transaction_header_id = p_thid
and asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and period_counter_created = l_period_rec.period_counter;
/*update fa_mass_Revaluations
set status = 'ROLLBACKED'
where */
update fa_books
set date_ineffective = null
, transaction_header_id_out = null
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and transaction_header_id_out = p_thid;
delete from fa_transaction_headers
where transaction_header_id = p_thid;
delete from fa_mc_books
where transaction_header_id_out is null
and transaction_header_id_in = p_thid
and book_type_code = p_asset_hdr_rec.book_type_code
and asset_id = p_asset_hdr_rec.asset_id
and set_of_books_id = p_asset_hdr_rec.set_of_books_id;
delete from fa_mc_adjustments
where transaction_header_id = p_thid
and asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and period_counter_created = l_period_rec.period_counter
and set_of_books_id = p_asset_hdr_rec.set_of_books_id;
update fa_mc_books
set date_ineffective = null
, transaction_header_id_out = null
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and transaction_header_id_out = p_thid
and set_of_books_id = p_asset_hdr_rec.set_of_books_id;
SELECT fa_transaction_headers_s.nextval
INTO l_trans_rec.transaction_header_id
FROM DUAL;
l_trans_rec.who_info.last_update_date := sysdate;
l_trans_rec.who_info.last_updated_by := fnd_global.user_id;
create/update/delete event for secondary ledger*/
l_secondary_sob_id := FA_XLA_EVENTS_PVT.get_secondary_sob_id(p_asset_hdr_rec.book_type_code);
fa_debug_pkg.add(l_calling_fn,'Inserting new thid: '
, l_trans_rec.transaction_header_id, p_log_level_rec => p_log_level_rec);
INSERT INTO FA_TRANSACTION_HEADERS(
TRANSACTION_HEADER_ID
, BOOK_TYPE_CODE
, ASSET_ID
, TRANSACTION_TYPE_CODE
, TRANSACTION_DATE_ENTERED
, DATE_EFFECTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, TRANSACTION_NAME
, INVOICE_TRANSACTION_ID
, SOURCE_TRANSACTION_HEADER_ID
, MASS_REFERENCE_ID
, LAST_UPDATE_LOGIN
, TRANSACTION_SUBTYPE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE
, TRANSACTION_KEY
, AMORTIZATION_START_DATE
, CALLING_INTERFACE
, MASS_TRANSACTION_ID
, MEMBER_TRANSACTION_HEADER_ID
, TRX_REFERENCE_ID
, EVENT_ID
) select
l_trans_rec.transaction_header_id --TRANSACTION_HEADER_ID
, BOOK_TYPE_CODE
, ASSET_ID
, TRANSACTION_TYPE_CODE
, l_trans_rec.transaction_date_entered
, l_trans_rec.who_info.last_update_date -- DATE_EFFECTIVE
, l_trans_rec.who_info.last_update_date -- LAST_UPDATE_DATE
, l_trans_rec.who_info.last_updated_by
, TRANSACTION_NAME
, INVOICE_TRANSACTION_ID
, SOURCE_TRANSACTION_HEADER_ID
, MASS_REFERENCE_ID
, LAST_UPDATE_LOGIN
, TRANSACTION_SUBTYPE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE
, l_trans_rec.TRANSACTION_KEY
, AMORTIZATION_START_DATE
, l_trans_rec.calling_interface -- CALLING_INTERFACE
, MASS_TRANSACTION_ID
, MEMBER_TRANSACTION_HEADER_ID
, TRX_REFERENCE_ID
, l_trans_rec.event_id -- EVENT_ID
from fa_transaction_headers
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and transaction_header_id = p_thid
;
INSERT INTO FA_ADJUSTMENTS(
TRANSACTION_HEADER_ID
, SOURCE_TYPE_CODE
, ADJUSTMENT_TYPE
, DEBIT_CREDIT_FLAG
, CODE_COMBINATION_ID
, BOOK_TYPE_CODE
, ASSET_ID
, ADJUSTMENT_AMOUNT
, DISTRIBUTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ANNUALIZED_ADJUSTMENT
, PERIOD_COUNTER_ADJUSTED
, PERIOD_COUNTER_CREATED
, ASSET_INVOICE_ID
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, DEPRN_OVERRIDE_FLAG
, TRACK_MEMBER_FLAG
, ADJUSTMENT_LINE_ID
, SOURCE_LINE_ID
, SOURCE_DEST_CODE
) select
l_trans_rec.transaction_header_id -- TRANSACTION_HEADER_ID
, SOURCE_TYPE_CODE
, ADJUSTMENT_TYPE
, decode(debit_credit_flag, 'DR', 'CR', 'DR') --DEBIT_CREDIT_FLAG
, CODE_COMBINATION_ID
, BOOK_TYPE_CODE
, ASSET_ID
, ADJUSTMENT_AMOUNT
, DISTRIBUTION_ID
, l_trans_rec.who_info.last_update_date --LAST_UPDATE_DATE
, l_trans_rec.who_info.last_updated_by --LAST_UPDATED_BY
, l_trans_rec.who_info.last_updated_by --LAST_UPDATE_LOGIN
, ANNUALIZED_ADJUSTMENT
, PERIOD_COUNTER_ADJUSTED
, PERIOD_COUNTER_CREATED
, ASSET_INVOICE_ID
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, DEPRN_OVERRIDE_FLAG
, TRACK_MEMBER_FLAG
, fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
, SOURCE_LINE_ID
, SOURCE_DEST_CODE
from fa_adjustments
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and transaction_header_id = p_thid
;
UPDATE FA_BOOKS
SET DATE_INEFFECTIVE = l_trans_rec.who_info.last_update_date
, last_update_date = l_trans_rec.who_info.last_update_date
, TRANSACTION_HEADER_ID_OUT = l_trans_rec.transaction_header_id
WHERE ASSET_ID = p_asset_hdr_rec.asset_id
AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
AND TRANSACTION_HEADER_ID_in = p_thid
AND TRANSACTION_HEADER_ID_OUT is null;
INSERT INTO FA_BOOKS( BOOK_TYPE_CODE
, ASSET_ID
, DATE_PLACED_IN_SERVICE
, DATE_EFFECTIVE
, DEPRN_START_DATE
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, RATE_ADJUSTMENT_FACTOR
, ADJUSTED_COST
, COST
, ORIGINAL_COST
, SALVAGE_VALUE
, PRORATE_CONVENTION_CODE
, PRORATE_DATE
, COST_CHANGE_FLAG
, ADJUSTMENT_REQUIRED_STATUS
, CAPITALIZE_FLAG
, RETIREMENT_PENDING_FLAG
, DEPRECIATE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, TRANSACTION_HEADER_ID_IN
, ITC_AMOUNT_ID
, ITC_AMOUNT
, RETIREMENT_ID
, TAX_REQUEST_ID
, ITC_BASIS
, BASIC_RATE
, ADJUSTED_RATE
, BONUS_RULE
, CEILING_NAME
, RECOVERABLE_COST
, ADJUSTED_CAPACITY
, FULLY_RSVD_REVALS_COUNTER
, IDLED_FLAG
, PERIOD_COUNTER_CAPITALIZED
, PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_FULLY_RETIRED
, PRODUCTION_CAPACITY
, REVAL_AMORTIZATION_BASIS
, REVAL_CEILING
, UNIT_OF_MEASURE
, UNREVALUED_COST
, ANNUAL_DEPRN_ROUNDING_FLAG
, PERCENT_SALVAGE_VALUE
, ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT
, PERIOD_COUNTER_LIFE_COMPLETE
, ADJUSTED_RECOVERABLE_COST
, ANNUAL_ROUNDING_FLAG
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR
, SHORT_FISCAL_YEAR_FLAG
, CONVERSION_DATE
, ORIGINAL_DEPRN_START_DATE
, REMAINING_LIFE1
, REMAINING_LIFE2
, OLD_ADJUSTED_COST
, FORMULA_FACTOR
, GROUP_ASSET_ID
, SALVAGE_TYPE
, DEPRN_LIMIT_TYPE
, REDUCTION_RATE
, REDUCE_ADDITION_FLAG
, REDUCE_ADJUSTMENT_FLAG
, REDUCE_RETIREMENT_FLAG
, RECOGNIZE_GAIN_LOSS
, RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS
, TRACKING_METHOD
, EXCLUDE_FULLY_RSV_FLAG
, EXCESS_ALLOCATION_OPTION
, DEPRECIATION_OPTION
, MEMBER_ROLLUP_FLAG
, ALLOCATE_TO_FULLY_RSV_FLAG
, ALLOCATE_TO_FULLY_RET_FLAG
, TERMINAL_GAIN_LOSS_AMOUNT
, CIP_COST
, YTD_PROCEEDS
, LTD_PROCEEDS
, LTD_COST_OF_REMOVAL
, EOFY_RESERVE
, PRIOR_EOFY_RESERVE
, EOP_ADJ_COST
, EOP_FORMULA_FACTOR
, EXCLUDE_PROCEEDS_FROM_BASIS
, RETIREMENT_DEPRN_OPTION
, TERMINAL_GAIN_LOSS_FLAG
, SUPER_GROUP_ID
, OVER_DEPRECIATE_OPTION
, DISABLED_FLAG
, CASH_GENERATING_UNIT_ID
, RATE_IN_USE
) SELECT BOOK_TYPE_CODE
, ASSET_ID
, DATE_PLACED_IN_SERVICE
, l_trans_rec.who_info.last_update_date -- DATE_EFFECTIVE
, DEPRN_START_DATE
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, RATE_ADJUSTMENT_FACTOR --RATE_ADJUSTMENT_FACTOR
, ADJUSTED_COST -- ADJUSTED_COST
, COST
, ORIGINAL_COST
, SALVAGE_VALUE
, PRORATE_CONVENTION_CODE
, PRORATE_DATE
, COST_CHANGE_FLAG
, ADJUSTMENT_REQUIRED_STATUS
, CAPITALIZE_FLAG
, RETIREMENT_PENDING_FLAG
, DEPRECIATE_FLAG
, l_trans_rec.who_info.last_update_date -- LAST_UPDATE_DATE
, l_trans_rec.who_info.last_updated_by -- LAST_UPDATED_BY
, l_trans_rec.transaction_header_id -- TRANSACTION_HEADER_ID_IN
, ITC_AMOUNT_ID
, ITC_AMOUNT
, RETIREMENT_ID
, TAX_REQUEST_ID
, ITC_BASIS
, BASIC_RATE
, ADJUSTED_RATE
, BONUS_RULE
, CEILING_NAME
, RECOVERABLE_COST
, ADJUSTED_CAPACITY
, FULLY_RSVD_REVALS_COUNTER
, IDLED_FLAG
, PERIOD_COUNTER_CAPITALIZED
, PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_FULLY_RETIRED
, PRODUCTION_CAPACITY
, REVAL_AMORTIZATION_BASIS
, REVAL_CEILING
, UNIT_OF_MEASURE
, UNREVALUED_COST
, ANNUAL_DEPRN_ROUNDING_FLAG
, PERCENT_SALVAGE_VALUE
, ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT
, PERIOD_COUNTER_LIFE_COMPLETE
, ADJUSTED_RECOVERABLE_COST
, ANNUAL_ROUNDING_FLAG
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR
, SHORT_FISCAL_YEAR_FLAG
, CONVERSION_DATE
, ORIGINAL_DEPRN_START_DATE
, REMAINING_LIFE1
, REMAINING_LIFE2
, OLD_ADJUSTED_COST
, formula_factor --FORMULA_FACTOR
, GROUP_ASSET_ID
, SALVAGE_TYPE
, DEPRN_LIMIT_TYPE
, REDUCTION_RATE
, REDUCE_ADDITION_FLAG
, REDUCE_ADJUSTMENT_FLAG
, REDUCE_RETIREMENT_FLAG
, RECOGNIZE_GAIN_LOSS
, RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS
, TRACKING_METHOD
, EXCLUDE_FULLY_RSV_FLAG
, EXCESS_ALLOCATION_OPTION
, DEPRECIATION_OPTION
, MEMBER_ROLLUP_FLAG
, ALLOCATE_TO_FULLY_RSV_FLAG
, ALLOCATE_TO_FULLY_RET_FLAG
, TERMINAL_GAIN_LOSS_AMOUNT
, CIP_COST
, YTD_PROCEEDS
, LTD_PROCEEDS
, LTD_COST_OF_REMOVAL
, eofy_reserve --EOFY_RESERVE
, PRIOR_EOFY_RESERVE
, EOP_ADJ_COST
, EOP_FORMULA_FACTOR
, EXCLUDE_PROCEEDS_FROM_BASIS
, RETIREMENT_DEPRN_OPTION
, TERMINAL_GAIN_LOSS_FLAG
, SUPER_GROUP_ID
, OVER_DEPRECIATE_OPTION
, DISABLED_FLAG
, CASH_GENERATING_UNIT_ID
, RATE_IN_USE
FROM FA_BOOKS
WHERE TRANSACTION_HEADER_ID_out = p_thid
AND ASSET_ID = p_asset_hdr_rec.asset_id
AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code;
, l_trans_rec.who_info.last_update_date
, l_trans_rec.who_info.last_updated_by;
INSERT INTO FA_MC_ADJUSTMENTS(
SET_OF_BOOKS_ID
, TRANSACTION_HEADER_ID
, SOURCE_TYPE_CODE
, ADJUSTMENT_TYPE
, DEBIT_CREDIT_FLAG
, CODE_COMBINATION_ID
, BOOK_TYPE_CODE
, ASSET_ID
, ADJUSTMENT_AMOUNT
, DISTRIBUTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ANNUALIZED_ADJUSTMENT
, PERIOD_COUNTER_ADJUSTED
, PERIOD_COUNTER_CREATED
, ASSET_INVOICE_ID
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, DEPRN_OVERRIDE_FLAG
, TRACK_MEMBER_FLAG
, ADJUSTMENT_LINE_ID
, SOURCE_LINE_ID
, SOURCE_DEST_CODE
) select
SET_OF_BOOKS_ID
, l_trans_rec.transaction_header_id -- TRANSACTION_HEADER_ID
, SOURCE_TYPE_CODE
, ADJUSTMENT_TYPE
, decode(debit_credit_flag, 'DR', 'CR', 'DR') --DEBIT_CREDIT_FLAG
, CODE_COMBINATION_ID
, BOOK_TYPE_CODE
, ASSET_ID
, ADJUSTMENT_AMOUNT
, DISTRIBUTION_ID
, l_trans_rec.who_info.last_update_date --LAST_UPDATE_DATE
, l_trans_rec.who_info.last_updated_by --LAST_UPDATED_BY
, l_trans_rec.who_info.last_updated_by --LAST_UPDATE_LOGIN
, ANNUALIZED_ADJUSTMENT
, PERIOD_COUNTER_ADJUSTED
, PERIOD_COUNTER_CREATED
, ASSET_INVOICE_ID
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, DEPRN_OVERRIDE_FLAG
, TRACK_MEMBER_FLAG
, fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
, SOURCE_LINE_ID
, SOURCE_DEST_CODE
from fa_mc_adjustments
where asset_id = p_asset_hdr_rec.asset_id
and book_type_code = p_asset_hdr_rec.book_type_code
and transaction_header_id = p_thid
and set_of_books_id = p_asset_hdr_rec.set_of_books_id
;
UPDATE FA_MC_BOOKS
SET DATE_INEFFECTIVE = l_trans_rec.who_info.last_update_date
, last_update_date = l_trans_rec.who_info.last_update_date
, TRANSACTION_HEADER_ID_OUT = l_trans_rec.transaction_header_id
WHERE ASSET_ID = p_asset_hdr_rec.asset_id
AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
AND set_of_books_id = p_asset_hdr_rec.set_of_books_id
AND TRANSACTION_HEADER_ID_in = p_thid
AND TRANSACTION_HEADER_ID_OUT is null;
INSERT INTO FA_MC_BOOKS( SET_OF_BOOKS_ID
, BOOK_TYPE_CODE
, ASSET_ID
, DATE_PLACED_IN_SERVICE
, DATE_EFFECTIVE
, DEPRN_START_DATE
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, RATE_ADJUSTMENT_FACTOR
, ADJUSTED_COST
, COST
, ORIGINAL_COST
, SALVAGE_VALUE
, PRORATE_CONVENTION_CODE
, PRORATE_DATE
, COST_CHANGE_FLAG
, ADJUSTMENT_REQUIRED_STATUS
, CAPITALIZE_FLAG
, RETIREMENT_PENDING_FLAG
, DEPRECIATE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, TRANSACTION_HEADER_ID_IN
, ITC_AMOUNT_ID
, ITC_AMOUNT
, RETIREMENT_ID
, TAX_REQUEST_ID
, ITC_BASIS
, BASIC_RATE
, ADJUSTED_RATE
, BONUS_RULE
, CEILING_NAME
, RECOVERABLE_COST
, ADJUSTED_CAPACITY
, FULLY_RSVD_REVALS_COUNTER
, IDLED_FLAG
, PERIOD_COUNTER_CAPITALIZED
, PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_FULLY_RETIRED
, PRODUCTION_CAPACITY
, REVAL_AMORTIZATION_BASIS
, REVAL_CEILING
, UNIT_OF_MEASURE
, UNREVALUED_COST
, ANNUAL_DEPRN_ROUNDING_FLAG
, PERCENT_SALVAGE_VALUE
, ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT
, PERIOD_COUNTER_LIFE_COMPLETE
, ADJUSTED_RECOVERABLE_COST
, ANNUAL_ROUNDING_FLAG
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR
, SHORT_FISCAL_YEAR_FLAG
, CONVERSION_DATE
, ORIGINAL_DEPRN_START_DATE
, REMAINING_LIFE1
, REMAINING_LIFE2
, OLD_ADJUSTED_COST
, FORMULA_FACTOR
, GROUP_ASSET_ID
, SALVAGE_TYPE
, DEPRN_LIMIT_TYPE
, REDUCTION_RATE
, REDUCE_ADDITION_FLAG
, REDUCE_ADJUSTMENT_FLAG
, REDUCE_RETIREMENT_FLAG
, RECOGNIZE_GAIN_LOSS
, RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS
, TRACKING_METHOD
, EXCLUDE_FULLY_RSV_FLAG
, EXCESS_ALLOCATION_OPTION
, DEPRECIATION_OPTION
, MEMBER_ROLLUP_FLAG
, ALLOCATE_TO_FULLY_RSV_FLAG
, ALLOCATE_TO_FULLY_RET_FLAG
, TERMINAL_GAIN_LOSS_AMOUNT
, CIP_COST
, YTD_PROCEEDS
, LTD_PROCEEDS
, LTD_COST_OF_REMOVAL
, EOFY_RESERVE
, PRIOR_EOFY_RESERVE
, EOP_ADJ_COST
, EOP_FORMULA_FACTOR
, EXCLUDE_PROCEEDS_FROM_BASIS
, RETIREMENT_DEPRN_OPTION
, TERMINAL_GAIN_LOSS_FLAG
, SUPER_GROUP_ID
, OVER_DEPRECIATE_OPTION
, DISABLED_FLAG
, CASH_GENERATING_UNIT_ID
, RATE_IN_USE
) SELECT SET_OF_BOOKS_ID
, BOOK_TYPE_CODE
, ASSET_ID
, DATE_PLACED_IN_SERVICE
, l_trans_rec.who_info.last_update_date -- DATE_EFFECTIVE
, DEPRN_START_DATE
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, RATE_ADJUSTMENT_FACTOR --RATE_ADJUSTMENT_FACTOR
, ADJUSTED_COST -- ADJUSTED_COST
, COST
, ORIGINAL_COST
, SALVAGE_VALUE
, PRORATE_CONVENTION_CODE
, PRORATE_DATE
, COST_CHANGE_FLAG
, ADJUSTMENT_REQUIRED_STATUS
, CAPITALIZE_FLAG
, RETIREMENT_PENDING_FLAG
, DEPRECIATE_FLAG
, l_trans_rec.who_info.last_update_date -- LAST_UPDATE_DATE
, l_trans_rec.who_info.last_updated_by -- LAST_UPDATED_BY
, l_trans_rec.transaction_header_id -- TRANSACTION_HEADER_ID_IN
, ITC_AMOUNT_ID
, ITC_AMOUNT
, RETIREMENT_ID
, TAX_REQUEST_ID
, ITC_BASIS
, BASIC_RATE
, ADJUSTED_RATE
, BONUS_RULE
, CEILING_NAME
, RECOVERABLE_COST
, ADJUSTED_CAPACITY
, FULLY_RSVD_REVALS_COUNTER
, IDLED_FLAG
, PERIOD_COUNTER_CAPITALIZED
, PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_FULLY_RETIRED
, PRODUCTION_CAPACITY
, REVAL_AMORTIZATION_BASIS
, REVAL_CEILING
, UNIT_OF_MEASURE
, UNREVALUED_COST
, ANNUAL_DEPRN_ROUNDING_FLAG
, PERCENT_SALVAGE_VALUE
, ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT
, PERIOD_COUNTER_LIFE_COMPLETE
, ADJUSTED_RECOVERABLE_COST
, ANNUAL_ROUNDING_FLAG
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR
, SHORT_FISCAL_YEAR_FLAG
, CONVERSION_DATE
, ORIGINAL_DEPRN_START_DATE
, REMAINING_LIFE1
, REMAINING_LIFE2
, OLD_ADJUSTED_COST
, formula_factor --FORMULA_FACTOR
, GROUP_ASSET_ID
, SALVAGE_TYPE
, DEPRN_LIMIT_TYPE
, REDUCTION_RATE
, REDUCE_ADDITION_FLAG
, REDUCE_ADJUSTMENT_FLAG
, REDUCE_RETIREMENT_FLAG
, RECOGNIZE_GAIN_LOSS
, RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS
, TRACKING_METHOD
, EXCLUDE_FULLY_RSV_FLAG
, EXCESS_ALLOCATION_OPTION
, DEPRECIATION_OPTION
, MEMBER_ROLLUP_FLAG
, ALLOCATE_TO_FULLY_RSV_FLAG
, ALLOCATE_TO_FULLY_RET_FLAG
, TERMINAL_GAIN_LOSS_AMOUNT
, CIP_COST
, YTD_PROCEEDS
, LTD_PROCEEDS
, LTD_COST_OF_REMOVAL
, eofy_reserve --EOFY_RESERVE
, PRIOR_EOFY_RESERVE
, EOP_ADJ_COST
, EOP_FORMULA_FACTOR
, EXCLUDE_PROCEEDS_FROM_BASIS
, RETIREMENT_DEPRN_OPTION
, TERMINAL_GAIN_LOSS_FLAG
, SUPER_GROUP_ID
, OVER_DEPRECIATE_OPTION
, DISABLED_FLAG
, CASH_GENERATING_UNIT_ID
, RATE_IN_USE
FROM FA_MC_BOOKS
WHERE TRANSACTION_HEADER_ID_out = p_thid
AND ASSET_ID = p_asset_hdr_rec.asset_id
AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
AND SET_OF_BOOKS_ID = p_asset_hdr_rec.set_of_books_id ;