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_TA_REVAL_PKG dependencies on JL_CO_FA_ASSET_APPRS

Line 84: x_appr_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;

80: x_user_je_source_name gl_je_sources.user_je_source_name%TYPE;
81: x_period_counter fa_book_controls.last_period_counter%TYPE;
82: x_count1 NUMBER;
83: x_end_date fa_calendar_periods.end_date%TYPE;
84: x_appr_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
85: x_prev_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
86: x_net_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
87: x_category_id fa_additions.asset_category_id%TYPE := 0;
88: x_revaluation_account fa_category_books.global_attribute11%TYPE := 0;

Line 85: x_prev_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;

81: x_period_counter fa_book_controls.last_period_counter%TYPE;
82: x_count1 NUMBER;
83: x_end_date fa_calendar_periods.end_date%TYPE;
84: x_appr_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
85: x_prev_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
86: x_net_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
87: x_category_id fa_additions.asset_category_id%TYPE := 0;
88: x_revaluation_account fa_category_books.global_attribute11%TYPE := 0;
89: x_surplus_account fa_category_books.global_attribute12%TYPE := 0;

Line 86: x_net_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;

82: x_count1 NUMBER;
83: x_end_date fa_calendar_periods.end_date%TYPE;
84: x_appr_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
85: x_prev_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
86: x_net_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
87: x_category_id fa_additions.asset_category_id%TYPE := 0;
88: x_revaluation_account fa_category_books.global_attribute11%TYPE := 0;
89: x_surplus_account fa_category_books.global_attribute12%TYPE := 0;
90: x_reserve_account fa_category_books.global_attribute13%TYPE := 0;

Line 149: FROM jl_co_fa_asset_apprs ap,

145: ab.cost,
146: fnd_number.canonical_to_number(nvl(ab.global_attribute2,0)) prev_revaluation,
147: dr.deprn_reserve,
148: ab.date_placed_in_service
149: FROM jl_co_fa_asset_apprs ap,
150: fa_additions ad,
151: fa_books ab,
152: fa_deprn_summary dr
153: WHERE ap.asset_number = ad.asset_number

Line 1218: fnd_file.put_line( 1, 'Updating JL_CO_FA_ASSET_APPRS');

1214: -- Update jl_co_fa_appr_assts. For each asset set --
1215: -- status = 'P' ie. processed --
1216: ---------------------------------------------------------
1217: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1218: fnd_file.put_line( 1, 'Updating JL_CO_FA_ASSET_APPRS');
1219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating JL_CO_FA_ASSET_APPRS');
1220: END IF;
1221:
1222: UPDATE jl_co_fa_asset_apprs SET status = 'P',

Line 1219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating JL_CO_FA_ASSET_APPRS');

1215: -- status = 'P' ie. processed --
1216: ---------------------------------------------------------
1217: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1218: fnd_file.put_line( 1, 'Updating JL_CO_FA_ASSET_APPRS');
1219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating JL_CO_FA_ASSET_APPRS');
1220: END IF;
1221:
1222: UPDATE jl_co_fa_asset_apprs SET status = 'P',
1223: last_update_date = x_sysdate,

Line 1222: UPDATE jl_co_fa_asset_apprs SET status = 'P',

1218: fnd_file.put_line( 1, 'Updating JL_CO_FA_ASSET_APPRS');
1219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating JL_CO_FA_ASSET_APPRS');
1220: END IF;
1221:
1222: UPDATE jl_co_fa_asset_apprs SET status = 'P',
1223: last_update_date = x_sysdate,
1224: last_updated_by = x_last_updated_by,
1225: last_update_login = x_last_update_login
1226: WHERE CURRENT OF c_asset;

Line 1229: fnd_file.put_line( 1, 'Updated JL_CO_FA_ASSET_APPRS');

1225: last_update_login = x_last_update_login
1226: WHERE CURRENT OF c_asset;
1227:
1228: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1229: fnd_file.put_line( 1, 'Updated JL_CO_FA_ASSET_APPRS');
1230: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated JL_CO_FA_ASSET_APPRS');
1231: END IF;*/
1232: ---------------------------------------------------------
1233: -- Update fa_book for each asset --

Line 1230: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated JL_CO_FA_ASSET_APPRS');

1226: WHERE CURRENT OF c_asset;
1227:
1228: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1229: fnd_file.put_line( 1, 'Updated JL_CO_FA_ASSET_APPRS');
1230: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated JL_CO_FA_ASSET_APPRS');
1231: END IF;*/
1232: ---------------------------------------------------------
1233: -- Update fa_book for each asset --
1234: ---------------------------------------------------------

Line 1725: FROM jl_co_fa_asset_apprs

1721: x_count number := 0;
1722: x_status boolean;
1723: CURSOR c_asset IS
1724: SELECT asset_number
1725: FROM jl_co_fa_asset_apprs
1726: WHERE appraisal_id = p_appraisal_id
1727: AND asset_number NOT IN (SELECT ap.asset_number
1728: FROM jl_co_fa_asset_apprs ap,
1729: fa_additions ad,

Line 1728: FROM jl_co_fa_asset_apprs ap,

1724: SELECT asset_number
1725: FROM jl_co_fa_asset_apprs
1726: WHERE appraisal_id = p_appraisal_id
1727: AND asset_number NOT IN (SELECT ap.asset_number
1728: FROM jl_co_fa_asset_apprs ap,
1729: fa_additions ad,
1730: fa_books ab
1731: WHERE ap.asset_number = ad.asset_number
1732: AND ap.appraisal_id = p_appraisal_id