DBA Data[Home] [Help]

APPS.JL_CO_FA_TA_REVAL_PKG dependencies on FND_NUMBER

Line 146: fnd_number.canonical_to_number(nvl(ab.global_attribute2,0)) prev_revaluation,

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,

Line 1242: global_attribute2 = fnd_number.number_to_canonical(x_appr_revaluation),

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),

Line 1243: global_attribute3 = fnd_number.number_to_canonical(x_prev_revaluation),

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,

Line 1246: global_attribute6 = fnd_number.number_to_canonical(rec_asset.appraisal_value),

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