The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT jl_co_fa_appraisals_s.nextval
INTO x_appraisal_id
FROM DUAL;
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;
fnd_file.put_line( 1, 'Insert JL_CO_FA_APPRAISALS is complete.');
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Insert JL_CO_FA_APPRAISALS is complete.');
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;
fnd_file.put_line( 1, 'Insert JL_CO_FA_ASSET_APPRS is complete.');
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Insert JL_CO_FA_ASSET_APPRS is complete.');
DELETE FROM JL_CO_FA_APPRAISALS
WHERE appraisal_id = -1;
fnd_file.put_line( 1, 'Delete JL_CO_FA_APPRAISALS is complete.');
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Delete JL_CO_FA_APPRAISALS is complete.');
DELETE FROM JL_CO_FA_ASSET_APPRS
WHERE appraisal_id = -1;
fnd_file.put_line( 1, 'Delete JL_CO_FA_ASSET_APPRS is complete.');
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Delete JL_CO_FA_ASSET_APPRS is complete.');
SELECT 1
INTO x_count
FROM DUAL
WHERE EXISTS (SELECT * FROM JL_CO_FA_ASSET_APPRS
WHERE appraisal_id = x_appraisal_id);
DELETE FROM JL_CO_FA_ASSET_APPRS
WHERE appraisal_id = p_appraisal_id;
DELETE FROM JL_CO_FA_APPRAISALS
WHERE appraisal_id = p_appraisal_id;