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_PVT dependencies on FA_RETIREMENTS

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

562: -- Distribution API called after FA_RETIREMENT_PUB.do_sub_regular_retirement
563: -- is expecting the status to be PENDING.
564: --
565: if (p_log_level_rec.statement_level) then
566: fa_debug_pkg.add(l_calling_fn, 'Call FA_RETIREMENTS_PKG.Update_Row', 'Begin', p_log_level_rec => p_log_level_rec);
567: end if;
568:
569: FA_RETIREMENTS_PKG.Update_Row(
570: X_Rowid => l_rowid,

Line 569: FA_RETIREMENTS_PKG.Update_Row(

565: if (p_log_level_rec.statement_level) then
566: fa_debug_pkg.add(l_calling_fn, 'Call FA_RETIREMENTS_PKG.Update_Row', 'Begin', p_log_level_rec => p_log_level_rec);
567: end if;
568:
569: FA_RETIREMENTS_PKG.Update_Row(
570: X_Rowid => l_rowid,
571: X_Retirement_Id => p_asset_retire_rec.retirement_id,
572: X_Status => 'PROCESSED',
573: X_Recapture_Amount => l_recapture_amount,

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

575: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
576: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
577:
578: if (p_log_level_rec.statement_level) then
579: fa_debug_pkg.add(l_calling_fn, 'Call FA_RETIREMENTS_PKG.Update_Row', 'End', p_log_level_rec => p_log_level_rec);
580: end if;
581:
582: -- SLA: update the event status in SLA as well to unprocessed
583: -- as original api inserted as incomplete

Line 2343: from fa_retirements

2339: and book_type_code = p_asset_hdr_rec.book_type_code
2340: and retirement_id = p_asset_retire_rec.retirement_id;
2341: bug 4411892*/
2342: select transaction_header_id_out
2343: from fa_retirements
2344: where asset_id = p_asset_hdr_rec.asset_id
2345: and retirement_id = p_asset_retire_rec.retirement_id
2346: and book_type_code = p_asset_hdr_rec.book_type_code;
2347:

Line 3165: from fa_retirements

3161: and transaction_header_id_out is null;
3162:
3163: CURSOR c_get_ret_info IS
3164: select -1 * eofy_reserve
3165: from fa_retirements
3166: where retirement_id = p_ret.retirement_id;
3167:
3168: CURSOR c_get_mc_ret_info IS
3169: select -1 * eofy_reserve

Line 3621: from fa_retirements ret

3617: , trx.calling_interface
3618: , trx.mass_reference_id
3619: , nvl(trx.amortization_start_date, trx.transaction_date_entered)
3620: , event_id
3621: from fa_retirements ret
3622: , fa_transaction_headers trx
3623: where ret.retirement_id = p_ret.retirement_id
3624: and ret.transaction_header_id_out = trx.transaction_header_id;
3625:

Line 3627: --Bug8425794: finding reserve retired if fa_retirements doesn't have it.

3623: where ret.retirement_id = p_ret.retirement_id
3624: and ret.transaction_header_id_out = trx.transaction_header_id;
3625:
3626:
3627: --Bug8425794: finding reserve retired if fa_retirements doesn't have it.
3628: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
3629: -- gets reserve retired amounts if FA_RETIREMENTS doesn't store it
3630: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
3631: CURSOR c_get_rsv_retired (c_transaction_header_id number) IS

Line 3629: -- gets reserve retired amounts if FA_RETIREMENTS doesn't store it

3625:
3626:
3627: --Bug8425794: finding reserve retired if fa_retirements doesn't have it.
3628: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
3629: -- gets reserve retired amounts if FA_RETIREMENTS doesn't store it
3630: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
3631: CURSOR c_get_rsv_retired (c_transaction_header_id number) IS
3632: select sum(decode(debit_credit_flag, 'CR', -1 * adjustment_amount,
3633: adjustment_amount))

Line 3643: -- gets reserve retired amounts if FA_RETIREMENTS doesn't store it

3639: and transaction_header_id = c_transaction_header_id;
3640:
3641: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
3642: -- For MRC
3643: -- gets reserve retired amounts if FA_RETIREMENTS doesn't store it
3644: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
3645: CURSOR c_get_mc_rsv_retired (c_transaction_header_id number) IS
3646: select sum(decode(debit_credit_flag, 'CR', -1 * adjustment_amount,
3647: adjustment_amount))

Line 3820: -- Ideally the reserve retired is stored in fa_retirements but

3816: l_asset_fin_rec_adj.ltd_cost_of_removal := p_ret.cost_of_removal;
3817:
3818:
3819: --Bug8425794: passing reserve to be reinstated
3820: -- Ideally the reserve retired is stored in fa_retirements but
3821: -- the may not be the case so fetching the value if it is null
3822: --l_asset_deprn_rec_adj.deprn_reserve := -1*p_ret.reserve_retired;
3823: if p_ret.reserve_retired is null then
3824: if (p_mrc_sob_type_code = 'R') then

Line 4037: fa_retirements ret,

4033: cursor c_max_ret_thid is
4034: select max(gth.transaction_header_id)
4035: from fa_transaction_headers gth,
4036: fa_transaction_headers mth,
4037: fa_retirements ret,
4038: fa_books bk
4039: where bk.group_asset_id = p_asset_id
4040: and bk.book_type_code = p_book_type_code
4041: and ret.asset_id = bk.asset_id