APPS.FA_RETIREMENT_PVT dependencies on FA_RETIREMENTS

Line 524: fa_debug_pkg.add(l_calling_fn, 'Call FA_RETIREMENTS_PKG.Update_Row', 'Begin',p_log_level_rec);

520: -- Distribution API called after FA_RETIREMENT_PUB.do_sub_regular_retirement
521: -- is expecting the status to be PENDING.
522: --
523: if (p_log_level_rec.statement_level) then
524: fa_debug_pkg.add(l_calling_fn, 'Call FA_RETIREMENTS_PKG.Update_Row', 'Begin',p_log_level_rec);
525: end if;
526:
527: FA_RETIREMENTS_PKG.Update_Row(
528: X_Rowid => l_rowid,

Line 527: FA_RETIREMENTS_PKG.Update_Row(

523: if (p_log_level_rec.statement_level) then
524: fa_debug_pkg.add(l_calling_fn, 'Call FA_RETIREMENTS_PKG.Update_Row', 'Begin',p_log_level_rec);
525: end if;
526:
527: FA_RETIREMENTS_PKG.Update_Row(
528: X_Rowid => l_rowid,
529: X_Retirement_Id => p_asset_retire_rec.retirement_id,
530: X_Status => 'PROCESSED',
531: X_Recapture_Amount => l_recapture_amount,

Line 537: fa_debug_pkg.add(l_calling_fn, 'Call FA_RETIREMENTS_PKG.Update_Row', 'End',p_log_level_rec);

533: X_Calling_Fn => l_calling_fn,
534: p_log_level_rec => p_log_level_rec);
535:
536: if (p_log_level_rec.statement_level) then
537: fa_debug_pkg.add(l_calling_fn, 'Call FA_RETIREMENTS_PKG.Update_Row', 'End',p_log_level_rec);
538: end if;
539:
540: -- SLA: update the event status in SLA as well to unprocessed
541: -- as original api inserted as incomplete

Line 2209: from fa_retirements

2205: and book_type_code = p_asset_hdr_rec.book_type_code
2206: and retirement_id = p_asset_retire_rec.retirement_id;
2207: bug 4411892*/
2208: select transaction_header_id_out
2209: from fa_retirements
2210: where asset_id = p_asset_hdr_rec.asset_id
2211: and retirement_id = p_asset_retire_rec.retirement_id
2212: and book_type_code = p_asset_hdr_rec.book_type_code;
2213:

Line 2894: from fa_retirements

2890: and transaction_header_id_out is null;
2891:
2892: CURSOR c_get_ret_info IS
2893: select -1 * eofy_reserve
2894: from fa_retirements
2895: where retirement_id = p_ret.retirement_id;
2896:
2897: CURSOR c_get_mc_ret_info IS
2898: select -1 * eofy_reserve

Line 2899: from fa_retirements_mrc_v

2895: where retirement_id = p_ret.retirement_id;
2896:
2897: CURSOR c_get_mc_ret_info IS
2898: select -1 * eofy_reserve
2899: from fa_retirements_mrc_v
2900: where retirement_id = p_ret.retirement_id;
2901:
2902: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Retirement_in_CGL';
2903:

Line 3165: FA_RETIREMENTS_PKG.Update_Row(

3161: l_recapture_amount := 0;
3162:
3163: end if; -- (nvl(p_bk.recapture_reserve_flag, 'N') = 'Y') and
3164:
3165: FA_RETIREMENTS_PKG.Update_Row(
3166: X_Rowid => l_rowid,
3167: X_Retirement_Id => p_ret.retirement_id,
3168: X_Recapture_Amount => l_recapture_amount,
3169: X_mrc_sob_type_code => p_mrc_sob_type_code,

Line 3441: from fa_retirements ret

3437: , trx.mass_transaction_id
3438: , trx.calling_interface
3439: , trx.mass_reference_id
3440: , nvl(trx.amortization_start_date, trx.transaction_date_entered)
3441: from fa_retirements ret
3442: , fa_transaction_headers trx
3443: where ret.retirement_id = p_ret.retirement_id
3444: and ret.transaction_header_id_out = trx.transaction_header_id;
3445:

Line 3694: fa_retirements ret,

3690: cursor c_max_ret_thid is
3691: select max(gth.transaction_header_id)
3692: from fa_transaction_headers gth,
3693: fa_transaction_headers mth,
3694: fa_retirements ret,
3695: fa_books bk
3696: where bk.group_asset_id = p_asset_id
3697: and bk.book_type_code = p_book_type_code
3698: and ret.asset_id = bk.asset_id

Line 3719: fa_retirements_mrc_v ret,

3715: cursor c_max_mc_ret_thid is
3716: select max(gth.transaction_header_id)
3717: from fa_transaction_headers gth,
3718: fa_transaction_headers mth,
3719: fa_retirements_mrc_v ret,
3720: fa_books_mrc_v bk
3721: where bk.group_asset_id = p_asset_id
3722: and bk.book_type_code = p_book_type_code
3723: and ret.asset_id = bk.asset_id