The following lines contain the word 'select', 'insert', 'update' or 'delete':
select cumulative_reval_factor, current_reval_factor
from igi_iac_asset_balances
where asset_id = cp_asset_id
and book_type_code = cp_book_type_code
;
delete from igi_imp_iac_interface_py_add
where asset_id = fp_reval_params.reval_asset_params.asset_id
and book_type_code = fp_reval_params.reval_asset_params.book_type_code
;
select asset_number
into l_asset_number
from fa_additions
where asset_id = fp_reval_params.reval_asset_params.asset_id
;
insert into IGI_IMP_IAC_INTERFACE_PY_ADD (
ASSET_ID
, ASSET_NUMBER
, BOOK_TYPE_CODE
, CATEGORY_ID
, PERIOD_COUNTER
, NET_BOOK_VALUE
, ADJUSTED_COST
, OPERATING_ACCT
, REVAL_RESERVE
, DEPRN_AMOUNT
, DEPRN_RESERVE
, BACKLOG_DEPRN_RESERVE
, GENERAL_FUND
, LAST_REVAL_DATE
, CURRENT_REVAL_FACTOR
, CUMMULATIVE_REVAL_FACTOR
, HIST_COST
, HIST_DEPRN_EXPENSE
, HIST_YTD
, HIST_ACCUM_DEPRN
, HIST_LIFE_IN_MONTHS
, HIST_NBV
, HIST_SALVAGE_VALUE
, GENERAL_FUND_PERIODIC
, OPERATING_ACCOUNT_YTD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
) values (
fp_reval_params.reval_asset_params.asset_id
, l_asset_number
, fp_reval_params.reval_asset_params.book_type_code -- BOOK_TYPE_CODE
, fp_reval_params.reval_asset_params.category_id
, fp_reval_params.reval_asset_params.period_counter
, fp_reval_params.reval_output_asset.net_book_value
, fp_reval_params.reval_output_asset.adjusted_cost
, fp_reval_params.reval_output_asset.operating_acct
, fp_reval_params.reval_output_asset.reval_reserve
, fp_reval_params.reval_output_asset.deprn_amount
, fp_reval_params.reval_output_asset.deprn_reserve
, fp_reval_params.reval_output_asset.backlog_deprn_reserve
, fp_reval_params.reval_output_asset.general_fund
, fp_reval_params.reval_asset_params.revaluation_date
, fp_reval_params.reval_output_asset.current_reval_factor
, fp_reval_params.reval_output_asset.cumulative_reval_factor
, fp_reval_params.fa_asset_info.cost
, fp_reval_params.fa_asset_info.deprn_amount
, fp_reval_params.fa_asset_info.ytd_deprn
, fp_reval_params.fa_asset_info.deprn_reserve
, fp_reval_params.fa_asset_info.life_in_months
, fp_reval_params.fa_asset_info.cost -
fp_reval_params.fa_asset_info.deprn_reserve
, fp_reval_params.fa_asset_info.salvage_value
, fp_reval_params.reval_output_asset.GENERAL_FUND
, fp_reval_params.reval_output_asset.operating_acct
, g_user_id
, g_date
, g_user_id
, g_date
, g_login_id
, g_request_id
, 8400
, 8400
, g_date
) ;
igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+implementation : create, update or delete is not allowed.');
igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+implementation : create, update or delete is not allowed.');