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_DISTRIBUTION_HISTORY

Line 797: from fa_distribution_history hist

793: l_total_cost_retire :=0;
794: l_unit_assigned :=0;
795:
796: Select hist.units_assigned into l_unit_assigned
797: from fa_distribution_history hist
798: where hist.distribution_id = p_asset_dist_tbl(ctr).distribution_id;
799:
800: If ( l_unit_assigned + p_asset_dist_tbl(ctr).transaction_units = 0 ) then
801: fa_query_balances_pkg.query_balances(

Line 2329: from fa_distribution_history

2325: transaction_header_id_out,
2326: transaction_units,
2327: retirement_id,
2328: last_update_login
2329: from fa_distribution_history
2330: where asset_id = p_asset_id
2331: and book_type_code = p_book_type_code
2332: and date_ineffective is null;
2333:

Line 3257: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_distribution_history_pkg.update_row', '', p_log_level_rec => p_log_level_rec); end if;

3253: l_asset_hdr_rec.book_type_code) loop
3254:
3255: dh_rec.transaction_units := -1 * dh_rec.units_assigned;
3256:
3257: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_distribution_history_pkg.update_row', '', p_log_level_rec => p_log_level_rec); end if;
3258:
3259: fa_distribution_history_pkg.update_row
3260: (null,
3261: dh_rec.distribution_id,

Line 3259: fa_distribution_history_pkg.update_row

3255: dh_rec.transaction_units := -1 * dh_rec.units_assigned;
3256:
3257: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_distribution_history_pkg.update_row', '', p_log_level_rec => p_log_level_rec); end if;
3258:
3259: fa_distribution_history_pkg.update_row
3260: (null,
3261: dh_rec.distribution_id,
3262: dh_rec.book_type_code,
3263: dh_rec.asset_id,

Line 3949: from fa_distribution_history

3945: cursor get_transfer_id is
3946: select transaction_header_id_out
3947: ,transaction_units
3948: ,units_assigned
3949: from fa_distribution_history
3950: where retirement_id = l_asset_retire_rec.retirement_id;
3951:
3952: cursor adj_def is
3953: select rowid

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

4238:
4239: if (l_partial_unit_ret_flag='Y') then
4240:
4241: --delete a row only if a distribution is partially retired
4242: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_DISTRIBUTION_HISTORY_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4243: FA_DISTRIBUTION_HISTORY_PKG.DELETE_ROW
4244: (X_Asset_Id => l_asset_hdr_rec.Asset_Id,
4245: X_Book_Type_Code=> l_asset_hdr_rec.Book_Type_Code,
4246: X_Transaction_Header_Id => transfer_id,

Line 4243: FA_DISTRIBUTION_HISTORY_PKG.DELETE_ROW

4239: if (l_partial_unit_ret_flag='Y') then
4240:
4241: --delete a row only if a distribution is partially retired
4242: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_DISTRIBUTION_HISTORY_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4243: FA_DISTRIBUTION_HISTORY_PKG.DELETE_ROW
4244: (X_Asset_Id => l_asset_hdr_rec.Asset_Id,
4245: X_Book_Type_Code=> l_asset_hdr_rec.Book_Type_Code,
4246: X_Transaction_Header_Id => transfer_id,
4247: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

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

4247: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4248:
4249: end if;
4250:
4251: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4252: FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW
4253: (X_Transaction_Header_Id_Out =>
4254: transfer_id,
4255: X_Asset_Id => l_asset_hdr_rec.Asset_Id,

Line 4252: FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW

4248:
4249: end if;
4250:
4251: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4252: FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW
4253: (X_Transaction_Header_Id_Out =>
4254: transfer_id,
4255: X_Asset_Id => l_asset_hdr_rec.Asset_Id,
4256: X_Book_Type_Code=> l_asset_hdr_rec.Book_Type_Code,

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

4362:
4363: if (p_mrc_sob_type_code <> 'R') then
4364:
4365: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
4366: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4367: FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW
4368: (X_Asset_Id => l_asset_hdr_rec.asset_id,
4369: X_Book_Type_Code=> l_asset_hdr_rec.book_type_code,
4370: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 4367: FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW

4363: if (p_mrc_sob_type_code <> 'R') then
4364:
4365: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
4366: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4367: FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW
4368: (X_Asset_Id => l_asset_hdr_rec.asset_id,
4369: X_Book_Type_Code=> l_asset_hdr_rec.book_type_code,
4370: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4371: end if; -- if corporate