DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PUB dependencies on FA_ADJUSTMENTS

Line 3668: from fa_adjustments

3664: where retirement_id = l_asset_retire_rec.retirement_id;
3665:
3666: cursor adj_def is
3667: select rowid
3668: from fa_adjustments
3669: where asset_id = p_asset_hdr_rec.asset_id
3670: and transaction_header_id = transfer_id
3671: and source_type_code = 'TRANSFER'
3672: and adjustment_type in ('COST', 'RESERVE'

Line 4021: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'begin - deleting fa_adjustments', '', p_log_level_rec); end if;

4017:
4018: -- Remove any cost and reserve adjustment rows
4019: -- if UNDOing PARTIAL UNIT RETIREMENT
4020:
4021: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'begin - deleting fa_adjustments', '', p_log_level_rec); end if;
4022:
4023: open adj_def;
4024:
4025: begin

Line 4032: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ADJUSTMENTS_PKG.delete_row', '', p_log_level_rec); end if;

4028: fetch adj_def into l_adj_rowid;
4029:
4030: exit when adj_def%NOTFOUND;
4031:
4032: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ADJUSTMENTS_PKG.delete_row', '', p_log_level_rec); end if;
4033: FA_ADJUSTMENTS_PKG.delete_row(
4034: X_Rowid => l_adj_rowid,
4035: X_Asset_Id => l_asset_hdr_rec.asset_id,
4036: X_Calling_Fn => l_calling_fn,

Line 4033: FA_ADJUSTMENTS_PKG.delete_row(

4029:
4030: exit when adj_def%NOTFOUND;
4031:
4032: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_ADJUSTMENTS_PKG.delete_row', '', p_log_level_rec); end if;
4033: FA_ADJUSTMENTS_PKG.delete_row(
4034: X_Rowid => l_adj_rowid,
4035: X_Asset_Id => l_asset_hdr_rec.asset_id,
4036: X_Calling_Fn => l_calling_fn,
4037: X_mrc_sob_type_code => p_mrc_sob_type_code

Line 4048: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'done - deleting fa_adjustments', '', p_log_level_rec); end if;

4044: end;
4045:
4046: close adj_def;
4047:
4048: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'done - deleting fa_adjustments', '', p_log_level_rec); end if;
4049:
4050:
4051: else -- if not partial unit retirement
4052: