APPS.JL_CO_FA_TA_LOAD_PKG dependencies on JL_CO_FA_APPRAISALS

Line 157: SELECT jl_co_fa_appraisals_s.nextval

153: -- Find value for appraisal_id --
154: ---------------------------------------------------------
155:
156:
157: SELECT jl_co_fa_appraisals_s.nextval
158: INTO x_appraisal_id
159: FROM DUAL;
160:
161: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 166: INSERT INTO JL_CO_FA_APPRAISALS(

162: fnd_file.put_line( 1, 'x_appraisal_id : '||to_char(x_appraisal_id));
163: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_appraisal_id : '||to_char(x_appraisal_id));
164: END IF;
165:
166: INSERT INTO JL_CO_FA_APPRAISALS(
167: APPRAISAL_ID,
168: APPRAISAL_DATE,
169: CURRENCY_CODE,
170: FISCAL_YEAR,

Line 205: FROM JL_CO_FA_APPRAISALS

201: fnd_global.conc_request_id,
202: fnd_global.prog_appl_id,
203: fnd_global.conc_program_id,
204: PROGRAM_UPDATE_DATE
205: FROM JL_CO_FA_APPRAISALS
206: WHERE appraisal_id = -1;
207:
208: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
209: fnd_file.put_line( 1, 'Insert JL_CO_FA_APPRAISALS is complete.');

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

205: FROM JL_CO_FA_APPRAISALS
206: WHERE appraisal_id = -1;
207:
208: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
209: fnd_file.put_line( 1, 'Insert JL_CO_FA_APPRAISALS is complete.');
210: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Insert JL_CO_FA_APPRAISALS is complete.');
211: END IF;
212:
213: INSERT INTO JL_CO_FA_ASSET_APPRS(

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

206: WHERE appraisal_id = -1;
207:
208: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
209: fnd_file.put_line( 1, 'Insert JL_CO_FA_APPRAISALS is complete.');
210: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Insert JL_CO_FA_APPRAISALS is complete.');
211: END IF;
212:
213: INSERT INTO JL_CO_FA_ASSET_APPRS(
214: APPRAISAL_ID,

Line 248: DELETE FROM JL_CO_FA_APPRAISALS

244: fnd_file.put_line( 1, 'Insert JL_CO_FA_ASSET_APPRS is complete.');
245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Insert JL_CO_FA_ASSET_APPRS is complete.');
246: END IF;
247:
248: DELETE FROM JL_CO_FA_APPRAISALS
249: WHERE appraisal_id = -1;
250:
251: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
252: fnd_file.put_line( 1, 'Delete JL_CO_FA_APPRAISALS is complete.');

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

248: DELETE FROM JL_CO_FA_APPRAISALS
249: WHERE appraisal_id = -1;
250:
251: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
252: fnd_file.put_line( 1, 'Delete JL_CO_FA_APPRAISALS is complete.');
253: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Delete JL_CO_FA_APPRAISALS is complete.');
254: END IF;
255:
256: DELETE FROM JL_CO_FA_ASSET_APPRS

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

249: WHERE appraisal_id = -1;
250:
251: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
252: fnd_file.put_line( 1, 'Delete JL_CO_FA_APPRAISALS is complete.');
253: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Delete JL_CO_FA_APPRAISALS is complete.');
254: END IF;
255:
256: DELETE FROM JL_CO_FA_ASSET_APPRS
257: WHERE appraisal_id = -1;

Line 503: DELETE FROM JL_CO_FA_APPRAISALS

499:
500: DELETE FROM JL_CO_FA_ASSET_APPRS
501: WHERE appraisal_id = p_appraisal_id;
502:
503: DELETE FROM JL_CO_FA_APPRAISALS
504: WHERE appraisal_id = p_appraisal_id;
505:
506: COMMIT;
507: END;