APPS.JL_CO_FA_TA_REVAL_PKG dependencies on JL_CO_FA_APPRAISALS

Line 133: FROM jl_co_fa_appraisals

129: SELECT appraisal_id,
130: currency_code,
131: appraisal_date,
132: fiscal_year
133: FROM jl_co_fa_appraisals
134: WHERE appraisal_id = p_appraisal_id
135: FOR UPDATE OF appraisal_status;
136:
137: CURSOR c_asset(p_appr_id NUMBER,

Line 1277: -- Update jl_co_fa_appraisals table --

1273:
1274: END IF;
1275: END LOOP assets;
1276: ---------------------------------------------------------
1277: -- Update jl_co_fa_appraisals table --
1278: ---------------------------------------------------------
1279:
1280: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1281: fnd_file.put_line( 1, 'Updating JL_CO_FA_APPRAISALS');

Line 1281: fnd_file.put_line( 1, 'Updating JL_CO_FA_APPRAISALS');

1277: -- Update jl_co_fa_appraisals table --
1278: ---------------------------------------------------------
1279:
1280: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1281: fnd_file.put_line( 1, 'Updating JL_CO_FA_APPRAISALS');
1282: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating JL_CO_FA_APPRAISALS');
1283: END IF;
1284:
1285: UPDATE jl_co_fa_appraisals SET appraisal_status = 'P',

Line 1282: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating JL_CO_FA_APPRAISALS');

1278: ---------------------------------------------------------
1279:
1280: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1281: fnd_file.put_line( 1, 'Updating JL_CO_FA_APPRAISALS');
1282: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating JL_CO_FA_APPRAISALS');
1283: END IF;
1284:
1285: UPDATE jl_co_fa_appraisals SET appraisal_status = 'P',
1286: last_update_date = x_sysdate,

Line 1285: UPDATE jl_co_fa_appraisals SET appraisal_status = 'P',

1281: fnd_file.put_line( 1, 'Updating JL_CO_FA_APPRAISALS');
1282: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating JL_CO_FA_APPRAISALS');
1283: END IF;
1284:
1285: UPDATE jl_co_fa_appraisals SET appraisal_status = 'P',
1286: last_update_date = x_sysdate,
1287: last_updated_by = x_last_updated_by,
1288: last_update_login = x_last_update_login
1289:

Line 1293: fnd_file.put_line( 1, 'Updated JL_CO_FA_APPRAISALS');

1289:
1290: WHERE CURRENT OF c_appraisal;
1291:
1292: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1293: fnd_file.put_line( 1, 'Updated JL_CO_FA_APPRAISALS');
1294: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated JL_CO_FA_APPRAISALS');
1295: END IF;
1296:
1297: ---------------------------------------------------------

Line 1294: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated JL_CO_FA_APPRAISALS');

1290: WHERE CURRENT OF c_appraisal;
1291:
1292: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1293: fnd_file.put_line( 1, 'Updated JL_CO_FA_APPRAISALS');
1294: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated JL_CO_FA_APPRAISALS');
1295: END IF;
1296:
1297: ---------------------------------------------------------
1298: -- Insert a row into table JL_CO_FA_APPRAISAL_BOOKS --