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 2109: from fa_distribution_history

2105: transaction_header_id_out,
2106: transaction_units,
2107: retirement_id,
2108: last_update_login
2109: from fa_distribution_history
2110: where asset_id = p_asset_id
2111: and book_type_code = p_book_type_code
2112: and date_ineffective is null;
2113:

Line 2982: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_distribution_history_pkg.update_row', '', p_log_level_rec); end if;

2978: l_asset_hdr_rec.book_type_code) loop
2979:
2980: dh_rec.transaction_units := -1 * dh_rec.units_assigned;
2981:
2982: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_distribution_history_pkg.update_row', '', p_log_level_rec); end if;
2983:
2984: fa_distribution_history_pkg.update_row
2985: (null,
2986: dh_rec.distribution_id,

Line 2984: fa_distribution_history_pkg.update_row

2980: dh_rec.transaction_units := -1 * dh_rec.units_assigned;
2981:
2982: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_distribution_history_pkg.update_row', '', p_log_level_rec); end if;
2983:
2984: fa_distribution_history_pkg.update_row
2985: (null,
2986: dh_rec.distribution_id,
2987: dh_rec.book_type_code,
2988: dh_rec.asset_id,

Line 3663: from fa_distribution_history

3659: cursor get_transfer_id is
3660: select transaction_header_id_out
3661: ,transaction_units
3662: ,units_assigned
3663: from fa_distribution_history
3664: where retirement_id = l_asset_retire_rec.retirement_id;
3665:
3666: cursor adj_def is
3667: select rowid

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

3951:
3952: if (l_partial_unit_ret_flag='Y') then
3953:
3954: --delete a row only if a distribution is partially retired
3955: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_DISTRIBUTION_HISTORY_PKG.DELETE_ROW', '', p_log_level_rec); end if;
3956: FA_DISTRIBUTION_HISTORY_PKG.DELETE_ROW
3957: (X_Asset_Id => l_asset_hdr_rec.Asset_Id,
3958: X_Book_Type_Code=> l_asset_hdr_rec.Book_Type_Code,
3959: X_Transaction_Header_Id => transfer_id,

Line 3956: FA_DISTRIBUTION_HISTORY_PKG.DELETE_ROW

3952: if (l_partial_unit_ret_flag='Y') then
3953:
3954: --delete a row only if a distribution is partially retired
3955: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_DISTRIBUTION_HISTORY_PKG.DELETE_ROW', '', p_log_level_rec); end if;
3956: FA_DISTRIBUTION_HISTORY_PKG.DELETE_ROW
3957: (X_Asset_Id => l_asset_hdr_rec.Asset_Id,
3958: X_Book_Type_Code=> l_asset_hdr_rec.Book_Type_Code,
3959: X_Transaction_Header_Id => transfer_id,
3960: X_Calling_Fn => l_calling_fn

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

3961: ,p_log_level_rec => p_log_level_rec);
3962:
3963: end if;
3964:
3965: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec); end if;
3966: FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW
3967: (X_Transaction_Header_Id_Out =>
3968: transfer_id,
3969: X_Asset_Id => l_asset_hdr_rec.Asset_Id,

Line 3966: FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW

3962:
3963: end if;
3964:
3965: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec); end if;
3966: FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW
3967: (X_Transaction_Header_Id_Out =>
3968: transfer_id,
3969: X_Asset_Id => l_asset_hdr_rec.Asset_Id,
3970: X_Book_Type_Code=> l_asset_hdr_rec.Book_Type_Code,

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

4081:
4082: if (p_mrc_sob_type_code <> 'R') then
4083:
4084: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
4085: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec); end if;
4086: FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW
4087: (X_Asset_Id => l_asset_hdr_rec.asset_id,
4088: X_Book_Type_Code=> l_asset_hdr_rec.book_type_code,
4089: X_Calling_Fn => l_calling_fn

Line 4086: FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW

4082: if (p_mrc_sob_type_code <> 'R') then
4083:
4084: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
4085: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW', '', p_log_level_rec); end if;
4086: FA_DISTRIBUTION_HISTORY_PKG.REACTIVATE_ROW
4087: (X_Asset_Id => l_asset_hdr_rec.asset_id,
4088: X_Book_Type_Code=> l_asset_hdr_rec.book_type_code,
4089: X_Calling_Fn => l_calling_fn
4090: ,p_log_level_rec => p_log_level_rec);