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.FA_RETIREMENT_PUB dependencies on FA_ASSET_HISTORY

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

493: raise FND_API.G_EXC_UNEXPECTED_ERROR;
494: end if;
495:
496:
497: -- get the current units of the asset from fa_asset_history table
498: -- ? call the following get_current_units function
499: -- to make sure that the current_units
500: -- of asset_desc_rec is correct.
501: -- => this call shouldn't be necessary

Line 4119: FROM fa_asset_history prev,

4115: if l_asset_retire_rec.units_retired is not null then
4116: BEGIN
4117: SELECT prev.units
4118: INTO l_old_units
4119: FROM fa_asset_history prev,
4120: fa_retirements ret
4121: WHERE prev.asset_id = l_asset_hdr_rec.asset_id
4122: AND prev.transaction_header_id_out = ret.transaction_header_id_in
4123: AND ret.retirement_id = l_asset_retire_rec.retirement_id;

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

4125: WHEN NO_DATA_FOUND THEN
4126: l_old_units := l_asset_retire_rec.units_retired;
4127: END;
4128: else
4129: -- added for Bug# 5098320 get the current units of the asset from fa_asset_history table
4130: if not FA_UTIL_PVT.get_current_units
4131: (p_calling_fn => l_calling_fn
4132: ,p_asset_id => l_asset_hdr_rec.asset_id
4133: ,x_current_units => l_old_units

Line 4259: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ASSET_HISTORY_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;

4255: X_Asset_Id => l_asset_hdr_rec.Asset_Id,
4256: X_Book_Type_Code=> l_asset_hdr_rec.Book_Type_Code,
4257: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4258:
4259: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ASSET_HISTORY_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4260: FA_ASSET_HISTORY_PKG.DELETE_ROW
4261: (X_Transaction_Header_Id_In =>
4262: l_asset_retire_rec.detail_info.transaction_header_id_in,
4263: X_Asset_Id => l_asset_hdr_rec.Asset_Id,

Line 4260: FA_ASSET_HISTORY_PKG.DELETE_ROW

4256: X_Book_Type_Code=> l_asset_hdr_rec.Book_Type_Code,
4257: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4258:
4259: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ASSET_HISTORY_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4260: FA_ASSET_HISTORY_PKG.DELETE_ROW
4261: (X_Transaction_Header_Id_In =>
4262: l_asset_retire_rec.detail_info.transaction_header_id_in,
4263: X_Asset_Id => l_asset_hdr_rec.Asset_Id,
4264: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 4266: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ASSET_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec); end if;

4262: l_asset_retire_rec.detail_info.transaction_header_id_in,
4263: X_Asset_Id => l_asset_hdr_rec.Asset_Id,
4264: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4265:
4266: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ASSET_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4267: FA_ASSET_HISTORY_PKG.REACTIVATE_ROW
4268: (X_Transaction_Header_Id_Out =>
4269: l_asset_retire_rec.detail_info.transaction_header_id_in,
4270: X_Asset_Id => l_asset_hdr_rec.Asset_Id,

Line 4267: FA_ASSET_HISTORY_PKG.REACTIVATE_ROW

4263: X_Asset_Id => l_asset_hdr_rec.Asset_Id,
4264: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4265:
4266: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ASSET_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4267: FA_ASSET_HISTORY_PKG.REACTIVATE_ROW
4268: (X_Transaction_Header_Id_Out =>
4269: l_asset_retire_rec.detail_info.transaction_header_id_in,
4270: X_Asset_Id => l_asset_hdr_rec.Asset_Id,
4271: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

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

6864: g_token1 := null;
6865: raise FND_API.G_EXC_ERROR;
6866: end if;
6867:
6868: -- get the current units of the asset from fa_asset_history table
6869: if not FA_UTIL_PVT.get_current_units
6870: (p_calling_fn => l_calling_fn
6871: ,p_asset_id => l_asset_hdr_rec.asset_id
6872: ,x_current_units => l_asset_desc_rec.current_units