DBA Data[Home] [Help]

APPS.FA_GAINLOSS_RET_PKG dependencies on FA_RETIREMENTS

Line 1210: FA_RETIREMENTS_PKG.Update_Row(

1206: raise l_grp_err;
1207: end if;
1208:
1209: -- Bug 8674833 : Populate sob_id from p_ret
1210: FA_RETIREMENTS_PKG.Update_Row(
1211: X_Rowid => l_rowid,
1212: X_Retirement_Id => p_ret.retirement_id,
1213: X_Recapture_Amount => l_g_rsv - nvl(p_bk.current_cost - p_ret.cost_retired, 0),
1214: X_mrc_sob_type_code => p_ret.mrc_sob_type_code,

Line 2351: -- Following is NOT necessary if we can remove nvl from update fa_retirements statement in fagurt

2347: end if; --if not l_override_used then --bug13014394
2348:
2349: --Bug11886090: Following is necessary as ret.reserve_retired will not get reflected in fagurt
2350: -- if fa_(mc_)retirements.reserve_retired is not null
2351: -- Following is NOT necessary if we can remove nvl from update fa_retirements statement in fagurt
2352: if bk.tracking_method = 'CALCULATE' and
2353: nvl(bk.member_rollup_flag, 'N') = 'N' and
2354: nvl(deprn_amt_group, 0) <> 0 then
2355: if (ret.mrc_sob_type_code = 'R') then

Line 2361: update fa_retirements

2357: set reserve_retired = reserve_retired + deprn_amt_group
2358: where retirement_id = ret.retirement_id
2359: and set_of_books_id = ret.set_of_books_id;
2360: else
2361: update fa_retirements
2362: set reserve_retired = reserve_retired + deprn_amt_group
2363: where retirement_id = ret.retirement_id;
2364: end if;
2365: end if;