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,
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,
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,
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);
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,
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,
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);
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