eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_CO_FA_PURGE_PKG dependencies on JL_CO_FA_ASSET_APPRS

Line 860: -- jl_co_fa_asset_apprs --

856: -- purge_appraisal --
857: -- --
858: -- DESCRIPTION --
859: -- Use this procedure to purge the tables jl_co-fa_appraisals and --
860: -- jl_co_fa_asset_apprs --
861: -- PURPOSE: --
862: -- Oracle Applications Rel 11.0 --
863: -- --
864: -- PARAMETERS: --

Line 957: DELETE FROM jl_co_fa_asset_apprs

953: AND appraisal_status <> 'P';
954:
955: IF x_count <> 0 THEN
956: IF x_del_unproc_app = 'Y' THEN
957: DELETE FROM jl_co_fa_asset_apprs
958: WHERE appraisal_id IN (select appraisal_id
959: from jl_co_fa_appraisals
960: where fiscal_year = p_fiscal_year
961: and appraisal_status <> 'P');

Line 1226: x_asset_table := 'JL_CO_FA_ASSET_APPRS'||TO_CHAR(x_index);

1222: WHERE book_type_code IS NULL
1223: AND fiscal_year = p_fiscal_year;
1224:
1225: x_appr_table := 'JL_CO_FA_APPRAISALS'||TO_CHAR(x_index);
1226: x_asset_table := 'JL_CO_FA_ASSET_APPRS'||TO_CHAR(x_index);
1227: x_book_table := 'JL_CO_FA_APPRAISAL_BOOKS'||TO_CHAR(x_index);
1228:
1229:
1230: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1233: fnd_file.put_line( 1, 'Backup table for JL_CO_FA_ASSET_APPRS :'||x_asset_table);

1229:
1230: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1231: fnd_file.put_line( 1, 'Backup table for JL_CO_FA_APPRAISALS :'||x_appr_table);
1232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Backup table for JL_CO_FA_APPRAISALS :'||x_appr_table);
1233: fnd_file.put_line( 1, 'Backup table for JL_CO_FA_ASSET_APPRS :'||x_asset_table);
1234: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Backup table for JL_CO_FA_ASSET_APPRS :'||x_asset_table);
1235: END IF;
1236:
1237: ---------------------------------------------------------

Line 1234: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Backup table for JL_CO_FA_ASSET_APPRS :'||x_asset_table);

1230: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1231: fnd_file.put_line( 1, 'Backup table for JL_CO_FA_APPRAISALS :'||x_appr_table);
1232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Backup table for JL_CO_FA_APPRAISALS :'||x_appr_table);
1233: fnd_file.put_line( 1, 'Backup table for JL_CO_FA_ASSET_APPRS :'||x_asset_table);
1234: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Backup table for JL_CO_FA_ASSET_APPRS :'||x_asset_table);
1235: END IF;
1236:
1237: ---------------------------------------------------------
1238: -- Get Oracle username --

Line 1284: FROM jl_co_fa_asset_apprs

1280: SELECT count(*),
1281: SUM(NVL(appraisal_value, 0))
1282: INTO x_asset_rows,
1283: x_asset_amount
1284: FROM jl_co_fa_asset_apprs
1285: WHERE appraisal_id IN (select appraisal_id
1286: from jl_co_fa_appraisals
1287: where fiscal_year = p_fiscal_year);
1288:

Line 1354: -- Its name is jl_co_fa_asset_apprs with extension --

1350: END IF;
1351:
1352: ---------------------------------------------------------
1353: -- Check weather backup tables for assets is exists. --
1354: -- Its name is jl_co_fa_asset_apprs with extension --
1355: -- purge_id --
1356: ---------------------------------------------------------
1357:
1358: SELECT count(*)

Line 1441: IF NOT (storage_factor('JL_CO_FA_ASSET_APPRS',

1437: IF NOT (do_sql(x_string)) THEN
1438: RAISE UNABLE_TO_DO_SQL;
1439: END IF;
1440:
1441: IF NOT (storage_factor('JL_CO_FA_ASSET_APPRS',
1442: x_asset_rows,
1443: x_storage_factor)) THEN
1444:
1445: RAISE UNABLE_TO_DO_SQL;

Line 1453: ' as select * from jl_co_fa_asset_apprs'||

1449: x_string := 'create table '||x_oracle_username||'.'||ltrim(rtrim(x_asset_table))||
1450: ' STORAGE( INITIAL '||TO_CHAR(ceil(x_storage_factor))||'K '||
1451: 'NEXT '||TO_CHAR(ceil(x_storage_factor/2))||'K '||
1452: 'MINEXTENTS 1 MAXEXTENTS 20 PCTINCREASE 100) '||
1453: ' as select * from jl_co_fa_asset_apprs'||
1454: ' where appraisal_id in (select appraisal_id from jl_co_fa_appraisals'||
1455: ' where fiscal_year = '||p_fiscal_year||')';
1456: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1457: fnd_file.put_line( 1, 'SQl statement to be processed :'||x_string);

Line 1553: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleting JL_CO_FA_ASSET_APPRS');

1549: ---------------------------------------------------------
1550:
1551: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1552: fnd_file.put_line( 1, 'Deleting JL_CO_FA_APPRAISALS');
1553: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleting JL_CO_FA_ASSET_APPRS');
1554: END IF;
1555:
1556: DELETE FROM jl_co_fa_asset_apprs
1557: WHERE appraisal_id IN (select appraisal_id

Line 1556: DELETE FROM jl_co_fa_asset_apprs

1552: fnd_file.put_line( 1, 'Deleting JL_CO_FA_APPRAISALS');
1553: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleting JL_CO_FA_ASSET_APPRS');
1554: END IF;
1555:
1556: DELETE FROM jl_co_fa_asset_apprs
1557: WHERE appraisal_id IN (select appraisal_id
1558: from jl_co_fa_appraisals
1559: where fiscal_year = p_fiscal_year);
1560:

Line 1563: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleted JL_CO_FA_ASSET_APPRS');

1559: where fiscal_year = p_fiscal_year);
1560:
1561: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1562: fnd_file.put_line( 1, 'Deleted JL_CO_FA_APPRAISALS');
1563: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleted JL_CO_FA_ASSET_APPRS');
1564: END IF;
1565:
1566: DELETE FROM jl_co_fa_appraisal_books
1567: WHERE appraisal_id IN (select appraisal_id

Line 1622: x_string := 'insert into jl_co_fa_asset_apprs select * from '||x_oracle_username||'.'||ltrim(rtrim(x_asset_table));

1618: x_string := 'insert into jl_co_fa_appraisals select * from '||x_oracle_username||'.'||ltrim(rtrim(x_appr_table));
1619: IF NOT (do_sql(x_string)) THEN
1620: RAISE UNABLE_TO_DO_SQL;
1621: END IF;
1622: x_string := 'insert into jl_co_fa_asset_apprs select * from '||x_oracle_username||'.'||ltrim(rtrim(x_asset_table));
1623: IF NOT (do_sql(x_string)) THEN
1624: RAISE UNABLE_TO_DO_SQL;
1625: END IF;
1626: