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_APPRAISALS

Line 859: -- Use this procedure to purge the tables jl_co-fa_appraisals and --

855: -- PROCEDURE --
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: -- --

Line 951: FROM jl_co_fa_appraisals

947: END IF;
948:
949: SELECT count(*)
950: INTO x_count
951: FROM jl_co_fa_appraisals
952: WHERE fiscal_year = p_fiscal_year
953: AND appraisal_status <> 'P';
954:
955: IF x_count <> 0 THEN

Line 959: from jl_co_fa_appraisals

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');
962: DELETE FROM jl_co_fa_appraisal_books
963: WHERE appraisal_id IN (select appraisal_id

Line 964: from jl_co_fa_appraisals

960: where fiscal_year = p_fiscal_year
961: and appraisal_status <> 'P');
962: DELETE FROM jl_co_fa_appraisal_books
963: WHERE appraisal_id IN (select appraisal_id
964: from jl_co_fa_appraisals
965: where fiscal_year = p_fiscal_year
966: and appraisal_status <> 'P');
967:
968: fnd_message.set_name('JL', 'JL_CO_FA_DELETED_APPRS');

Line 973: DELETE FROM jl_co_fa_appraisals

969: fnd_message.set_token('FISCAL_YEAR', p_fiscal_year);
970:
971: create_output_headings(p_fiscal_year);
972:
973: DELETE FROM jl_co_fa_appraisals
974: WHERE fiscal_year = p_fiscal_year
975: AND appraisal_status <> 'P';
976: ELSE
977: fnd_message.set_name('JL', 'JL_CO_FA_DEL_UNPROC_APPRS');

Line 1003: FROM jl_co_fa_appraisals

999: -- table to archive --
1000: ---------------------------------------------------------
1001: SELECT count(*)
1002: INTO x_count
1003: FROM jl_co_fa_appraisals
1004: WHERE fiscal_year = p_fiscal_year;
1005: If x_count = 0 THEN
1006: RAISE NOTHING_TO_ARCHIVE;
1007: END IF;

Line 1033: FROM jl_co_fa_appraisals

1029: ---------------------------------------------------------
1030:
1031: SELECT count(*)
1032: INTO x_count
1033: FROM jl_co_fa_appraisals
1034: WHERE fiscal_year = (p_fiscal_year - 1);
1035:
1036: IF x_count <> 0 THEN
1037:

Line 1081: FROM jl_co_fa_appraisals

1077: -- for previous fiscal year --
1078: ---------------------------------------------------------
1079: SELECT count(*)
1080: INTO x_count
1081: FROM jl_co_fa_appraisals
1082: WHERE fiscal_year = (p_fiscal_year - 1);
1083: IF x_count <> 0 THEN
1084: SELECT count(*)
1085: INTO x_count

Line 1225: x_appr_table := 'JL_CO_FA_APPRAISALS'||TO_CHAR(x_index);

1221: FROM jl_co_fa_purge
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:

Line 1231: fnd_file.put_line( 1, 'Backup table for JL_CO_FA_APPRAISALS :'||x_appr_table);

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
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;

Line 1232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Backup table for JL_CO_FA_APPRAISALS :'||x_appr_table);

1228:
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:

Line 1269: FROM jl_co_fa_appraisals

1265: SELECT count(*),
1266: SUM(NVL(appraisal_id, 0))
1267: INTO x_appraisal_rows,
1268: x_appraisal_amount
1269: FROM jl_co_fa_appraisals
1270: WHERE fiscal_year = p_fiscal_year;
1271:
1272: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1273: fnd_file.put_line( 1, 'No of appraisal rows :'||to_char(x_appraisal_rows));

Line 1286: from jl_co_fa_appraisals

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:
1289: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1290: fnd_file.put_line( 1, 'No of asset rows :'||to_char(x_asset_rows));

Line 1302: from jl_co_fa_appraisals

1298: INTO x_book_rows,
1299: x_book_amount
1300: FROM jl_co_fa_appraisal_books
1301: WHERE appraisal_id IN (select appraisal_id
1302: from jl_co_fa_appraisals
1303: where fiscal_year = p_fiscal_year);
1304:
1305: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1306: fnd_file.put_line( 1, 'No of appraisal_book rows :'||to_char(x_book_rows));

Line 1326: -- Its name is jl_co_fa_appraisals with extension --

1322: fnd_file.put_line( 1, fnd_message.get);
1323:
1324: ---------------------------------------------------------
1325: -- Check weather backup tables for appraisal is exists.--
1326: -- Its name is jl_co_fa_appraisals with extension --
1327: -- purge_id. --
1328: ---------------------------------------------------------
1329:
1330: SELECT count(*)

Line 1415: IF NOT (storage_factor('JL_CO_FA_APPRAISALS',

1411: -- Create and insert the rows to be archived into the --
1412: -- backup tables --
1413: ---------------------------------------------------------
1414:
1415: IF NOT (storage_factor('JL_CO_FA_APPRAISALS',
1416: x_appraisal_rows,
1417: x_storage_factor)) THEN
1418:
1419: RAISE UNABLE_TO_DO_SQL;

Line 1429: ' as select * from jl_co_fa_appraisals'||

1425: x_string := 'create table '||x_oracle_username||'.'||ltrim(rtrim(x_appr_table))||
1426: ' STORAGE( INITIAL '||TO_CHAR(ceil(x_storage_factor))||'K '||
1427: 'NEXT '||TO_CHAR(ceil(x_storage_factor/2))||'K '||
1428: 'MINEXTENTS 1 MAXEXTENTS 20 PCTINCREASE 100) '||
1429: ' as select * from jl_co_fa_appraisals'||
1430: ' where fiscal_year = '||p_fiscal_year;
1431:
1432: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1433: fnd_file.put_line( 1, 'SQl statement to be processed :'||x_string);

Line 1454: ' where appraisal_id in (select appraisal_id from jl_co_fa_appraisals'||

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);
1458: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'SQL statement to be processed :'||x_string);

Line 1478: ' where appraisal_id in (select appraisal_id from jl_co_fa_appraisals'||

1474: ' STORAGE( INITIAL '||TO_CHAR(ceil(x_storage_factor))||'K '||
1475: 'NEXT '||TO_CHAR(ceil(x_storage_factor/2))||'K '||
1476: 'MINEXTENTS 1 MAXEXTENTS 20 PCTINCREASE 100) '||
1477: 'as select * from jl_co_fa_appraisal_books'||
1478: ' where appraisal_id in (select appraisal_id from jl_co_fa_appraisals'||
1479: ' where fiscal_year='||p_fiscal_year||')';
1480: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1481: fnd_file.put_line( 1, 'SQl statement to be processed :'||x_string);
1482: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'SQL statement to be processed :'||x_string);

Line 1547: -- jl_co_fa_appraisals and jl_co_fa_appraisal_books --

1543: ELSE
1544:
1545: ---------------------------------------------------------
1546: -- Delete the rows from jl_co_fa_adjustments, --
1547: -- jl_co_fa_appraisals and jl_co_fa_appraisal_books --
1548: -- and change the status in jl_co_fa_purge to 'PURGED' --
1549: ---------------------------------------------------------
1550:
1551: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1552: fnd_file.put_line( 1, 'Deleting JL_CO_FA_APPRAISALS');

1548: -- and change the status in jl_co_fa_purge to 'PURGED' --
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

Line 1558: from jl_co_fa_appraisals

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:
1561: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1562: fnd_file.put_line( 1, 'Deleted JL_CO_FA_APPRAISALS');

Line 1562: fnd_file.put_line( 1, 'Deleted JL_CO_FA_APPRAISALS');

1558: from jl_co_fa_appraisals
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

Line 1568: from jl_co_fa_appraisals

1564: END IF;
1565:
1566: DELETE FROM jl_co_fa_appraisal_books
1567: WHERE appraisal_id IN (select appraisal_id
1568: from jl_co_fa_appraisals
1569: where fiscal_year = p_fiscal_year);
1570:
1571:
1572: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1573: fnd_file.put_line( 1, 'Deleting JL_CO_FA_Appraisals');

1569: where fiscal_year = p_fiscal_year);
1570:
1571:
1572: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1573: fnd_file.put_line( 1, 'Deleting JL_CO_FA_Appraisals');
1574: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleting JL_CO_FA_Appraisals');
1575: END IF;
1576:
1577:

Line 1574: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleting JL_CO_FA_Appraisals');

1570:
1571:
1572: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1573: fnd_file.put_line( 1, 'Deleting JL_CO_FA_Appraisals');
1574: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleting JL_CO_FA_Appraisals');
1575: END IF;
1576:
1577:
1578:

Line 1579: DELETE FROM jl_co_fa_appraisals

1575: END IF;
1576:
1577:
1578:
1579: DELETE FROM jl_co_fa_appraisals
1580: WHERE fiscal_year = p_fiscal_year;
1581:
1582: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1583: fnd_file.put_line( 1, 'Deleted JL_CO_FA_Appraisals');

Line 1583: fnd_file.put_line( 1, 'Deleted JL_CO_FA_Appraisals');

1579: DELETE FROM jl_co_fa_appraisals
1580: WHERE fiscal_year = p_fiscal_year;
1581:
1582: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1583: fnd_file.put_line( 1, 'Deleted JL_CO_FA_Appraisals');
1584: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleted JL_CO_FA_Appraisals');
1585: END IF;
1586: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1587: fnd_file.put_line( 1, 'Updating JL_CO_FA_PURGE');

Line 1584: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleted JL_CO_FA_Appraisals');

1580: WHERE fiscal_year = p_fiscal_year;
1581:
1582: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1583: fnd_file.put_line( 1, 'Deleted JL_CO_FA_Appraisals');
1584: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleted JL_CO_FA_Appraisals');
1585: END IF;
1586: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1587: fnd_file.put_line( 1, 'Updating JL_CO_FA_PURGE');
1588: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating JL_CO_FA_PURGE');

Line 1618: x_string := 'insert into jl_co_fa_appraisals select * from '||x_oracle_username||'.'||ltrim(rtrim(x_appr_table));

1614: ---------------------------------------------------------
1615: -- Process for the option 'RESTORE' --
1616: ---------------------------------------------------------
1617:
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));

Line 1992: FROM jl_co_fa_appraisals apprs, fnd_lookups fl

1988: SELECT apprs.appraisal_id appraisal_id,
1989: fl.meaning appraisal_status,
1990: apprs.appraiser_name appraiser_name,
1991: apprs.appraisal_date appraisal_date
1992: FROM jl_co_fa_appraisals apprs, fnd_lookups fl
1993: WHERE apprs.fiscal_year = p_fiscal_year
1994: AND apprs.appraisal_status <> 'P'
1995: AND apprs.appraisal_status = fl.lookup_code
1996: AND fl.lookup_type = 'JLCO_FA_ASSET_APPRAISAL_STATUS'