DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PVT dependencies on FA_RETIREMENT_PVT

Line 1: PACKAGE BODY FA_RETIREMENT_PVT as

1: PACKAGE BODY FA_RETIREMENT_PVT as
2: /* $Header: FAVRETB.pls 120.89.12020000.4 2013/03/19 18:04:01 dvjoshi ship $ */
3:
4: -- +++++ Global Variables +++++
5: --Adding for 3440308

Line 103: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.do_retirement';

99: where asset_id = p_asset_fin_rec.group_asset_id
100: and book_type_code = p_asset_hdr_rec.book_type_code
101: and member_transaction_header_id = p_trans_rec.transaction_header_id;
102:
103: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.do_retirement';
104:
105: l_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE;
106:
107: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;

Line 542: if not FA_RETIREMENT_PVT.Do_Allocation(

538: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.reserve_retired, p_log_level_rec => p_log_level_rec);
539: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation : l_recapture_amount', l_recapture_amount, p_log_level_rec => p_log_level_rec);
540: end if;
541:
542: if not FA_RETIREMENT_PVT.Do_Allocation(
543: p_trans_rec => l_trans_rec,
544: p_asset_hdr_rec => l_asset_hdr_rec,
545: p_asset_fin_rec => l_asset_fin_rec_new,
546: p_asset_deprn_rec_new => l_asset_deprn_rec_new, -- group new deprn rec

Line 1453: if not FA_RETIREMENT_PVT.Do_Allocation(

1449: nvl(p_asset_retire_rec.cost_of_removal, 0) -
1450: nvl(p_asset_retire_rec.reserve_retired, 0)+
1451: nvl(p_asset_retire_rec.detail_info.recapture_amount, 0);
1452:
1453: if not FA_RETIREMENT_PVT.Do_Allocation(
1454: p_trans_rec => l_trans_rec,
1455: p_asset_hdr_rec => l_asset_hdr_rec,
1456: p_asset_fin_rec => l_asset_fin_rec_new,
1457: p_asset_deprn_rec_new => l_asset_deprn_rec_new,

Line 1552: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.calc_gain_loss_for_ret';

1548: and bk.deprn_method_code = mt.method_code -- ENERGY
1549: and nvl(bk.life_in_months, -99) = nvl(mt.life_in_months, -99) -- ENERGY
1550: and mt.deprn_basis_rule_id = db.deprn_basis_rule_id; -- ENERGY
1551:
1552: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.calc_gain_loss_for_ret';
1553:
1554: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1555: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1556:

Line 3174: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Retirement_in_CGL';

3170: from fa_mc_retirements
3171: where retirement_id = p_ret.retirement_id
3172: and set_of_books_id = p_ret.set_of_books_id;
3173:
3174: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Retirement_in_CGL';
3175:
3176: l_trans_rec FA_API_TYPES.trans_rec_type;
3177: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3178: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;

Line 3688: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Reinstatement_in_CGL';

3684: and th.book_type_code = p_ret.book
3685: and th.member_transaction_header_id = p_ret.th_id_in
3686: and aj.set_of_books_id = p_ret.set_of_books_id;
3687:
3688: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Reinstatement_in_CGL';
3689:
3690: l_trans_rec FA_API_TYPES.trans_rec_type;
3691: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3692: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;

Line 4023: l_calling_fn VARCHAR2(50) := 'FA_RETIREMENT_PVT.Do_Terminal_Gain_Loss_All_Bk';

4019: p_mrc_sob_type_code VARCHAR2,
4020: p_set_of_books_id NUMBER,
4021: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)RETURN BOOLEAN IS
4022:
4023: l_calling_fn VARCHAR2(50) := 'FA_RETIREMENT_PVT.Do_Terminal_Gain_Loss_All_Bk';
4024:
4025: cursor c_member_exists IS
4026: select 'Y'
4027: from fa_books

Line 4292: l_calling_fn VARCHAR2(50) := 'FA_RETIREMENT_PVT.Do_Terminal_Gain_Loss';

4288: p_total_requests NUMBER,
4289: p_request_number NUMBER,
4290: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)RETURN BOOLEAN IS
4291:
4292: l_calling_fn VARCHAR2(50) := 'FA_RETIREMENT_PVT.Do_Terminal_Gain_Loss';
4293:
4294: l_period_rec FA_API_TYPES.period_rec_type;
4295:
4296: cursor c_get_groups is

Line 4460: l_calling_fn VARCHAR2(50) := 'FA_RETIREMENT_PVT.Check_Terminal_Gain_Loss';

4456: p_mrc_sob_type_code IN VARCHAR2,
4457: p_calling_fn IN VARCHAR2
4458: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4459:
4460: l_calling_fn VARCHAR2(50) := 'FA_RETIREMENT_PVT.Check_Terminal_Gain_Loss';
4461:
4462: --
4463: -- This cursor tries to find not full retired member of given group asset
4464: -- if there is any.

Line 4696: l_calling_fn varchar2(40) := 'FA_RETIREMENT_PVT.Do_Allocation';

4692: p_mrc_sob_type_code IN VARCHAR2,
4693: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
4694: RETURN BOOLEAN IS
4695:
4696: l_calling_fn varchar2(40) := 'FA_RETIREMENT_PVT.Do_Allocation';
4697: /* bug 8633654 starts*/
4698: h_rein_mem_asset_id number;
4699: l_ind number;
4700: bln_rein_mem_reqd boolean := FALSE;

Line 6864: END FA_RETIREMENT_PVT;

6860: END MOVE_RESERVE_TO_ACT_DIST;
6861: /*bug#15897249 end */
6862:
6863:
6864: END FA_RETIREMENT_PVT;