142: ad.asset_category_id,
143: ad.asset_id,
144: ad.current_units,
145: nvl(ab.cost,0) cost,
146: fnd_number.canonical_to_number(nvl(ab.global_attribute2,0)) prev_revaluation,
147: nvl(dr.deprn_reserve,0) deprn_reserve,
148: ab.date_placed_in_service
149: FROM jl_co_fa_asset_apprs ap,
150: fa_additions ad,
1238: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating FA_BOOKS');
1239: END IF;
1240:
1241: UPDATE fa_books SET
1242: global_attribute2 = fnd_number.number_to_canonical(x_appr_revaluation),
1243: global_attribute3 = fnd_number.number_to_canonical(x_prev_revaluation),
1244: global_attribute4 = rec_appraisal.appraisal_id,
1245: global_attribute5 = fnd_date.date_to_canonical(rec_appraisal.appraisal_date),
1246: global_attribute6 = fnd_number.number_to_canonical(rec_asset.appraisal_value),
1239: END IF;
1240:
1241: UPDATE fa_books SET
1242: global_attribute2 = fnd_number.number_to_canonical(x_appr_revaluation),
1243: global_attribute3 = fnd_number.number_to_canonical(x_prev_revaluation),
1244: global_attribute4 = rec_appraisal.appraisal_id,
1245: global_attribute5 = fnd_date.date_to_canonical(rec_appraisal.appraisal_date),
1246: global_attribute6 = fnd_number.number_to_canonical(rec_asset.appraisal_value),
1247: last_update_date = x_sysdate,
1242: global_attribute2 = fnd_number.number_to_canonical(x_appr_revaluation),
1243: global_attribute3 = fnd_number.number_to_canonical(x_prev_revaluation),
1244: global_attribute4 = rec_appraisal.appraisal_id,
1245: global_attribute5 = fnd_date.date_to_canonical(rec_appraisal.appraisal_date),
1246: global_attribute6 = fnd_number.number_to_canonical(rec_asset.appraisal_value),
1247: last_update_date = x_sysdate,
1248: last_updated_by = x_last_updated_by,
1249: last_update_login = x_last_update_login
1250: WHERE book_type_code = p_book