APPS.IGI_IAC_REVAL_IMPL_CRUD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

     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
     ;

Line: 56

     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
     ;

Line: 61

     select asset_number
     into   l_asset_number
     from   fa_additions
     where   asset_id = fp_reval_params.reval_asset_params.asset_id
     ;

Line: 67

     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
         ) ;

Line: 155

	  igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+implementation : create, update or delete is not allowed.');

Line: 162

	  igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+implementation : create, update or delete is not allowed.');