APPS.JL_CO_FA_TA_LOAD_PKG dependencies on JL_CO_FA_ASSET_APPRS

Line 213: INSERT INTO JL_CO_FA_ASSET_APPRS(

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,
215: ASSET_NUMBER,
216: APPRAISAL_VALUE,
217: STATUS,

Line 240: FROM JL_CO_FA_ASSET_APPRS

236: fnd_global.conc_request_id,
237: fnd_global.prog_appl_id,
238: fnd_global.conc_program_id,
239: PROGRAM_UPDATE_DATE
240: FROM JL_CO_FA_ASSET_APPRS
241: WHERE appraisal_id = -1;
242:
243: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
244: fnd_file.put_line( 1, 'Insert JL_CO_FA_ASSET_APPRS is complete.');

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

240: FROM JL_CO_FA_ASSET_APPRS
241: WHERE appraisal_id = -1;
242:
243: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
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

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

241: WHERE appraisal_id = -1;
242:
243: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
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;

Line 256: DELETE FROM JL_CO_FA_ASSET_APPRS

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;
258:
259: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
260: fnd_file.put_line( 1, 'Delete JL_CO_FA_ASSET_APPRS is complete.');

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

256: DELETE FROM JL_CO_FA_ASSET_APPRS
257: WHERE appraisal_id = -1;
258:
259: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
260: fnd_file.put_line( 1, 'Delete JL_CO_FA_ASSET_APPRS is complete.');
261: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Delete JL_CO_FA_ASSET_APPRS is complete.');
262: END IF;
263:
264: ----------------------------------------------------------------------------

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

257: WHERE appraisal_id = -1;
258:
259: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
260: fnd_file.put_line( 1, 'Delete JL_CO_FA_ASSET_APPRS is complete.');
261: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Delete JL_CO_FA_ASSET_APPRS is complete.');
262: END IF;
263:
264: ----------------------------------------------------------------------------
265: -- Submit validation request only when there is atleast one asset --

Line 274: WHERE EXISTS (SELECT * FROM JL_CO_FA_ASSET_APPRS

270:
271: SELECT 1
272: INTO x_count
273: FROM DUAL
274: WHERE EXISTS (SELECT * FROM JL_CO_FA_ASSET_APPRS
275: WHERE appraisal_id = x_appraisal_id);
276:
277: EXCEPTION
278: WHEN OTHERS THEN

Line 500: DELETE FROM JL_CO_FA_ASSET_APPRS

496: ----------------------------------------------------------------------------
497: PROCEDURE rollback_process(p_appraisal_id NUMBER) IS
498: BEGIN
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;