DBA Data[Home] [Help]

APPS.JL_CO_FA_ACCOUNTING_PKG dependencies on FND_NUMBER

Line 336: fnd_number.canonical_to_number(nvl (bk.global_attribute2,0)) appraisal_balance,

332: nvl (ah.units,0) units,
333: bk.date_placed_in_service,
334: bk.period_counter_capitalized,
335: nvl (bk.cost,0) adj_cost,
336: fnd_number.canonical_to_number(nvl (bk.global_attribute2,0)) appraisal_balance,
337: fnd_number.canonical_to_number(nvl (bk.global_attribute7,0)) deprn_to_cost,
338: bk.rowid book_rowid
339: FROM fa_transaction_headers th,
340: fa_deprn_periods dp,

Line 337: fnd_number.canonical_to_number(nvl (bk.global_attribute7,0)) deprn_to_cost,

333: bk.date_placed_in_service,
334: bk.period_counter_capitalized,
335: nvl (bk.cost,0) adj_cost,
336: fnd_number.canonical_to_number(nvl (bk.global_attribute2,0)) appraisal_balance,
337: fnd_number.canonical_to_number(nvl (bk.global_attribute7,0)) deprn_to_cost,
338: bk.rowid book_rowid
339: FROM fa_transaction_headers th,
340: fa_deprn_periods dp,
341: fa_additions ad,

Line 382: fnd_number.canonical_to_number(nvl (bk.global_attribute2,0)),

378: nvl (ah.units,0),
379: bk.date_placed_in_service,
380: bk.period_counter_capitalized,
381: nvl (bk.cost,0),
382: fnd_number.canonical_to_number(nvl (bk.global_attribute2,0)),
383: fnd_number.canonical_to_number(nvl (bk.global_attribute7,0)),
384: bk.rowid
385: FROM fa_transaction_headers th,
386: fa_deprn_periods dp,

Line 383: fnd_number.canonical_to_number(nvl (bk.global_attribute7,0)),

379: bk.date_placed_in_service,
380: bk.period_counter_capitalized,
381: nvl (bk.cost,0),
382: fnd_number.canonical_to_number(nvl (bk.global_attribute2,0)),
383: fnd_number.canonical_to_number(nvl (bk.global_attribute7,0)),
384: bk.rowid
385: FROM fa_transaction_headers th,
386: fa_deprn_periods dp,
387: fa_additions ad,

Line 709: fnd_number.canonical_to_number(nvl (global_attribute7,0))

705:
706: CURSOR c_prior_retirement (pc_transaction_header_id IN NUMBER)
707: IS
708: SELECT transaction_header_id_in,
709: fnd_number.canonical_to_number(nvl (global_attribute7,0))
710: FROM fa_books
711: WHERE transaction_header_id_out = pc_transaction_header_id;
712:
713: -------------------------------------------------------------------------------

Line 728: fnd_number.canonical_to_number(nvl (bk.global_attribute7,0)) deprn_to_cost,

724: SELECT ah.category_id,
725: ds.asset_id,
726: ad.asset_number,
727: bk.transaction_header_id_in,
728: fnd_number.canonical_to_number(nvl (bk.global_attribute7,0)) deprn_to_cost,
729: bk.rowid book_rowid
730: FROM fa_additions ad,
731: fa_asset_history ah,
732: fa_books bk,

Line 4589: SET global_attribute7 = fnd_number.number_to_canonical(x_deprn_to_cost)

4585: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
4586: END IF;
4587:
4588: UPDATE fa_books
4589: SET global_attribute7 = fnd_number.number_to_canonical(x_deprn_to_cost)
4590: WHERE rowid = tr.book_rowid ;
4591:
4592: END LOOP;
4593:

Line 4765: SET global_attribute7 = fnd_number.number_to_canonical(x_deprn_to_cost)

4761: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
4762: END IF;
4763:
4764: UPDATE fa_books
4765: SET global_attribute7 = fnd_number.number_to_canonical(x_deprn_to_cost)
4766: WHERE rowid = ad.book_rowid ;
4767:
4768: END LOOP;
4769: