DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PUB dependencies on FA_ASSET_HISTORY

Line 435: -- get the current units of the asset from fa_asset_history table

431: raise FND_API.G_EXC_UNEXPECTED_ERROR;
432: end if;
433:
434:
435: -- get the current units of the asset from fa_asset_history table
436: -- ? call the following get_current_units function
437: -- to make sure that the current_units
438: -- of asset_desc_rec is correct.
439: -- => this call shouldn't be necessary

Line 3703: from fa_asset_history

3699:
3700: --bug 5489382: Added cursor to fetch the units before retirement
3701: cursor get_units_before_ret(c_thid number, c_asset_id number) is
3702: select units
3703: from fa_asset_history
3704: where transaction_header_id_out = c_thid
3705: and asset_id = c_asset_id;
3706:
3707: l_invoice_transaction_id number; -- Local variable to store return value of c_inv_trx_id

Line 3830: -- added for Bug# 5098320 get the current units of the asset from fa_asset_history table

3826: FETCH get_cost_before_ret into l_old_cost;
3827: CLOSE get_cost_before_ret;
3828:
3829: /* bug 5489382: commented following code as it was giving current units instead of old units
3830: -- added for Bug# 5098320 get the current units of the asset from fa_asset_history table
3831: if not FA_UTIL_PVT.get_current_units
3832: (p_calling_fn => l_calling_fn
3833: ,p_asset_id => l_asset_hdr_rec.asset_id
3834: ,x_current_units => l_old_units

Line 3974: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ASSET_HISTORY_PKG.DELETE_ROW', '', p_log_level_rec); end if;

3970: X_Book_Type_Code=> l_asset_hdr_rec.Book_Type_Code,
3971: X_Calling_Fn => l_calling_fn
3972: ,p_log_level_rec => p_log_level_rec);
3973:
3974: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ASSET_HISTORY_PKG.DELETE_ROW', '', p_log_level_rec); end if;
3975: FA_ASSET_HISTORY_PKG.DELETE_ROW
3976: (X_Transaction_Header_Id_In =>
3977: l_asset_retire_rec.detail_info.transaction_header_id_in,
3978: X_Asset_Id => l_asset_hdr_rec.Asset_Id,

Line 3975: FA_ASSET_HISTORY_PKG.DELETE_ROW

3971: X_Calling_Fn => l_calling_fn
3972: ,p_log_level_rec => p_log_level_rec);
3973:
3974: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ASSET_HISTORY_PKG.DELETE_ROW', '', p_log_level_rec); end if;
3975: FA_ASSET_HISTORY_PKG.DELETE_ROW
3976: (X_Transaction_Header_Id_In =>
3977: l_asset_retire_rec.detail_info.transaction_header_id_in,
3978: X_Asset_Id => l_asset_hdr_rec.Asset_Id,
3979: X_Calling_Fn => l_calling_fn

Line 3982: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ASSET_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec); end if;

3978: X_Asset_Id => l_asset_hdr_rec.Asset_Id,
3979: X_Calling_Fn => l_calling_fn
3980: ,p_log_level_rec => p_log_level_rec);
3981:
3982: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ASSET_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec); end if;
3983: FA_ASSET_HISTORY_PKG.REACTIVATE_ROW
3984: (X_Transaction_Header_Id_Out =>
3985: l_asset_retire_rec.detail_info.transaction_header_id_in,
3986: X_Asset_Id => l_asset_hdr_rec.Asset_Id,

Line 3983: FA_ASSET_HISTORY_PKG.REACTIVATE_ROW

3979: X_Calling_Fn => l_calling_fn
3980: ,p_log_level_rec => p_log_level_rec);
3981:
3982: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ASSET_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec); end if;
3983: FA_ASSET_HISTORY_PKG.REACTIVATE_ROW
3984: (X_Transaction_Header_Id_Out =>
3985: l_asset_retire_rec.detail_info.transaction_header_id_in,
3986: X_Asset_Id => l_asset_hdr_rec.Asset_Id,
3987: X_Calling_Fn => l_calling_fn

Line 6495: -- get the current units of the asset from fa_asset_history table

6491: g_token1 := null;
6492: raise FND_API.G_EXC_ERROR;
6493: end if;
6494:
6495: -- get the current units of the asset from fa_asset_history table
6496: if not FA_UTIL_PVT.get_current_units
6497: (p_calling_fn => l_calling_fn
6498: ,p_asset_id => l_asset_hdr_rec.asset_id
6499: ,x_current_units => l_asset_desc_rec.current_units