APPS.JL_CO_FA_TA_LOAD_PKG SQL Statements

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

Line: 157

   SELECT jl_co_fa_appraisals_s.nextval
     INTO x_appraisal_id
     FROM DUAL;

Line: 166

   INSERT INTO JL_CO_FA_APPRAISALS(
               APPRAISAL_ID,
               APPRAISAL_DATE,
               CURRENCY_CODE,
               FISCAL_YEAR,
               APPRAISER_NAME,
               APPRAISER_ADDRESS1,
               APPRAISER_ADDRESS2,
               APPRAISER_PHONE,
               APPRAISER_CITY,
               APPRAISAL_STATUS,
               CREATED_BY,
               CREATION_DATE,
               LAST_UPDATED_BY,
               LAST_UPDATE_DATE,
               LAST_UPDATE_LOGIN,
               REQUEST_ID,
               PROGRAM_APPLICATION_ID,
               PROGRAM_ID,
               PROGRAM_UPDATE_DATE)
   SELECT      x_appraisal_id,
               APPRAISAL_DATE,
               CURRENCY_CODE,
               FISCAL_YEAR,
               APPRAISER_NAME,
               APPRAISER_ADDRESS1,
               APPRAISER_ADDRESS2,
               APPRAISER_PHONE,
               APPRAISER_CITY,
               APPRAISAL_STATUS,
               fnd_global.user_id,
               sysdate,
               fnd_global.user_id,
               sysdate,
               fnd_global.login_id,
               fnd_global.conc_request_id,
               fnd_global.prog_appl_id,
               fnd_global.conc_program_id,
               PROGRAM_UPDATE_DATE
   FROM JL_CO_FA_APPRAISALS
   WHERE appraisal_id = -1;

Line: 209

      fnd_file.put_line( 1, 'Insert JL_CO_FA_APPRAISALS is complete.');

Line: 210

      FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Insert JL_CO_FA_APPRAISALS is complete.');

Line: 213

   INSERT INTO JL_CO_FA_ASSET_APPRS(
               APPRAISAL_ID,
               ASSET_NUMBER,
               APPRAISAL_VALUE,
               STATUS,
               LAST_UPDATE_DATE,
               LAST_UPDATED_BY,
               CREATION_DATE,
               CREATED_BY,
               LAST_UPDATE_LOGIN,
               REQUEST_ID,
               PROGRAM_APPLICATION_ID,
               PROGRAM_ID,
               PROGRAM_UPDATE_DATE)
   SELECT      x_appraisal_id,
               ASSET_NUMBER,
               APPRAISAL_VALUE,
               STATUS,
               sysdate,
               fnd_global.user_id,
               sysdate,
               fnd_global.user_id,
               fnd_global.login_id,
               fnd_global.conc_request_id,
               fnd_global.prog_appl_id,
               fnd_global.conc_program_id,
               PROGRAM_UPDATE_DATE
   FROM JL_CO_FA_ASSET_APPRS
   WHERE appraisal_id = -1;

Line: 244

      fnd_file.put_line( 1, 'Insert JL_CO_FA_ASSET_APPRS is complete.');

Line: 245

      FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Insert JL_CO_FA_ASSET_APPRS is complete.');

Line: 248

   DELETE FROM JL_CO_FA_APPRAISALS
   WHERE appraisal_id = -1;

Line: 252

      fnd_file.put_line( 1, 'Delete JL_CO_FA_APPRAISALS is complete.');

Line: 253

      FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Delete JL_CO_FA_APPRAISALS is complete.');

Line: 256

   DELETE FROM JL_CO_FA_ASSET_APPRS
   WHERE appraisal_id = -1;

Line: 260

      fnd_file.put_line( 1, 'Delete JL_CO_FA_ASSET_APPRS is complete.');

Line: 261

      FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Delete JL_CO_FA_ASSET_APPRS is complete.');

Line: 271

   SELECT 1
     INTO x_count
     FROM DUAL
   WHERE EXISTS (SELECT * FROM JL_CO_FA_ASSET_APPRS
                  WHERE  appraisal_id = x_appraisal_id);

Line: 500

   DELETE FROM JL_CO_FA_ASSET_APPRS
   WHERE appraisal_id = p_appraisal_id;

Line: 503

   DELETE FROM JL_CO_FA_APPRAISALS
   WHERE appraisal_id = p_appraisal_id;