[Home] [Help]
37: g_mem_bonus_deprn_reserve NUMBER;
38:
39: --Bug 5149789
40: FUNCTION check_member_existence (
41: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type
42: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
43: RETURN BOOLEAN;
44:
45: --Bug4938977: Adding a private function.
38:
39: --Bug 5149789
40: FUNCTION check_member_existence (
41: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type
42: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
43: RETURN BOOLEAN;
44:
45: --Bug4938977: Adding a private function.
46: FUNCTION check_dpis_change (
46: FUNCTION check_dpis_change (
47: p_book_type_code VARCHAR2,
48: p_transaction_header_id NUMBER,
49: p_group_asset_id NUMBER,
50: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
51: x_period_counter_out OUT NOCOPY NUMBER,
52: p_mrc_sob_type_code VARCHAR2,
53: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
54: RETURN BOOLEAN;
49: p_group_asset_id NUMBER,
50: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
51: x_period_counter_out OUT NOCOPY NUMBER,
52: p_mrc_sob_type_code VARCHAR2,
53: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
54: RETURN BOOLEAN;
55:
56: PROCEDURE printBooksSummary(p_asset_id number,
57: p_book_type_code varchar2,
55:
56: PROCEDURE printBooksSummary(p_asset_id number,
57: p_book_type_code varchar2,
58: p_period_counter number default 0,
59: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
60:
61: CURSOR c_get_books_summary IS
62: select period_counter
63: , cost
109: FUNCTION GetPeriodInfo(
110: p_jdate NUMBER,
111: p_book_type_code VARCHAR2,
112: p_mrc_sob_type_code VARCHAR2,
113: x_period_rec OUT NOCOPY FA_API_TYPES.period_rec_type,
114: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
115:
116: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.GetPeriodInfo';
117: get_err EXCEPTION;
110: p_jdate NUMBER,
111: p_book_type_code VARCHAR2,
112: p_mrc_sob_type_code VARCHAR2,
113: x_period_rec OUT NOCOPY FA_API_TYPES.period_rec_type,
114: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
115:
116: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.GetPeriodInfo';
117: get_err EXCEPTION;
118:
281: -- This function will create missing records from period where last record
282: -- exists up to current period.
283: --+==============================================================================
284: FUNCTION catchupBooksSummary (
285: p_trans_rec FA_API_TYPES.trans_rec_type,
286: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
287: p_period_rec FA_API_TYPES.period_rec_type,
288: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
289: p_depreciate_flag_change BOOLEAN,
282: -- exists up to current period.
283: --+==============================================================================
284: FUNCTION catchupBooksSummary (
285: p_trans_rec FA_API_TYPES.trans_rec_type,
286: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
287: p_period_rec FA_API_TYPES.period_rec_type,
288: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
289: p_depreciate_flag_change BOOLEAN,
290: p_disabled_flag_change BOOLEAN,
283: --+==============================================================================
284: FUNCTION catchupBooksSummary (
285: p_trans_rec FA_API_TYPES.trans_rec_type,
286: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
287: p_period_rec FA_API_TYPES.period_rec_type,
288: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
289: p_depreciate_flag_change BOOLEAN,
290: p_disabled_flag_change BOOLEAN,
291: p_mrc_sob_type_code VARCHAR2,
284: FUNCTION catchupBooksSummary (
285: p_trans_rec FA_API_TYPES.trans_rec_type,
286: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
287: p_period_rec FA_API_TYPES.period_rec_type,
288: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
289: p_depreciate_flag_change BOOLEAN,
290: p_disabled_flag_change BOOLEAN,
291: p_mrc_sob_type_code VARCHAR2,
292: p_calling_fn VARCHAR,
289: p_depreciate_flag_change BOOLEAN,
290: p_disabled_flag_change BOOLEAN,
291: p_mrc_sob_type_code VARCHAR2,
292: p_calling_fn VARCHAR,
293: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
294:
295: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.catchupBooksSummary';
296:
297: CURSOR c_get_mc_last_period_counter IS
852: -- Procedure initMemberTable
853: --
854: -- Initialize global variables defined in specification.
855: --+==============================================================================
856: PROCEDURE initMemberTable(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
857: BEGIN
858:
859: --
860: -- Initialize global variables
875: -- Procedure InitGlobeVariables
876: --
877: -- Initialize global variables defined in specification.
878: --+==============================================================================
879: PROCEDURE InitGlobeVariables (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
880: BEGIN
881:
882: --
883: -- Initialize global variables
965: -- deleting all of them and reinsert all of them.
966: --
967: --+==============================================================================
968: FUNCTION createGroup(
969: p_trans_rec FA_API_TYPES.trans_rec_type,
970: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
971: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
972: p_period_rec FA_API_TYPES.period_rec_type,
973: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
966: --
967: --+==============================================================================
968: FUNCTION createGroup(
969: p_trans_rec FA_API_TYPES.trans_rec_type,
970: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
971: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
972: p_period_rec FA_API_TYPES.period_rec_type,
973: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
974: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
967: --+==============================================================================
968: FUNCTION createGroup(
969: p_trans_rec FA_API_TYPES.trans_rec_type,
970: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
971: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
972: p_period_rec FA_API_TYPES.period_rec_type,
973: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
974: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
975: p_mrc_sob_type_code VARCHAR2,
968: FUNCTION createGroup(
969: p_trans_rec FA_API_TYPES.trans_rec_type,
970: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
971: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
972: p_period_rec FA_API_TYPES.period_rec_type,
973: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
974: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
975: p_mrc_sob_type_code VARCHAR2,
976: p_calling_fn VARCHAR,
969: p_trans_rec FA_API_TYPES.trans_rec_type,
970: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
971: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
972: p_period_rec FA_API_TYPES.period_rec_type,
973: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
974: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
975: p_mrc_sob_type_code VARCHAR2,
976: p_calling_fn VARCHAR,
977: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
970: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
971: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
972: p_period_rec FA_API_TYPES.period_rec_type,
973: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
974: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
975: p_mrc_sob_type_code VARCHAR2,
976: p_calling_fn VARCHAR,
977: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
978:
973: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
974: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
975: p_mrc_sob_type_code VARCHAR2,
976: p_calling_fn VARCHAR,
977: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
978:
979: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.createGroup';
980:
981: --
1438: -- Function: buildMemberTable
1439: --
1440: --+==============================================================================
1441: FUNCTION buildMemberTable(
1442: p_trans_rec FA_API_TYPES.trans_rec_type,
1443: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
1444: p_period_rec FA_API_TYPES.period_rec_type,
1445: p_date_placed_in_service DATE,
1446: p_group_asset_id NUMBER,
1439: --
1440: --+==============================================================================
1441: FUNCTION buildMemberTable(
1442: p_trans_rec FA_API_TYPES.trans_rec_type,
1443: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
1444: p_period_rec FA_API_TYPES.period_rec_type,
1445: p_date_placed_in_service DATE,
1446: p_group_asset_id NUMBER,
1447: p_reclass_multiplier NUMBER,
1440: --+==============================================================================
1441: FUNCTION buildMemberTable(
1442: p_trans_rec FA_API_TYPES.trans_rec_type,
1443: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
1444: p_period_rec FA_API_TYPES.period_rec_type,
1445: p_date_placed_in_service DATE,
1446: p_group_asset_id NUMBER,
1447: p_reclass_multiplier NUMBER,
1448: p_reclass_src_dest VARCHAR2,
1451: x_td_cost OUT NOCOPY fa_amort_pvt.tab_num_type,
1452: x_td_cip_cost OUT NOCOPY fa_amort_pvt.tab_num_type,
1453: x_td_salvage_value OUT NOCOPY fa_amort_pvt.tab_num_type,
1454: x_td_deprn_limit_amount OUT NOCOPY fa_amort_pvt.tab_num_type,
1455: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1456: x_asset_fin_rec_reclass OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1457: p_mrc_sob_type_code VARCHAR2,
1458: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)return BOOLEAN IS
1459:
1452: x_td_cip_cost OUT NOCOPY fa_amort_pvt.tab_num_type,
1453: x_td_salvage_value OUT NOCOPY fa_amort_pvt.tab_num_type,
1454: x_td_deprn_limit_amount OUT NOCOPY fa_amort_pvt.tab_num_type,
1455: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1456: x_asset_fin_rec_reclass OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1457: p_mrc_sob_type_code VARCHAR2,
1458: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)return BOOLEAN IS
1459:
1460: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.buildMemberTable';
1454: x_td_deprn_limit_amount OUT NOCOPY fa_amort_pvt.tab_num_type,
1455: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1456: x_asset_fin_rec_reclass OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1457: p_mrc_sob_type_code VARCHAR2,
1458: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)return BOOLEAN IS
1459:
1460: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.buildMemberTable';
1461:
1462: --
1685: l_sal_thid NUMBER(15) := 0;
1686: l_limit_thid NUMBER(15) := 0;
1687:
1688: -- Bug4958977: Adding following 4 new variables
1689: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1690: l_period_counter NUMBER;
1691: bld_err EXCEPTION;
1692: l_cur_trx_period_counter NUMBER;
1693:
2549: --
2550: --
2551: --+==============================================================================
2552: FUNCTION CurrentPeriodAdj(
2553: p_trans_rec FA_API_TYPES.trans_rec_type,
2554: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
2555: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2556: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2557: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2550: --
2551: --+==============================================================================
2552: FUNCTION CurrentPeriodAdj(
2553: p_trans_rec FA_API_TYPES.trans_rec_type,
2554: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
2555: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2556: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2557: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2558: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2551: --+==============================================================================
2552: FUNCTION CurrentPeriodAdj(
2553: p_trans_rec FA_API_TYPES.trans_rec_type,
2554: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
2555: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2556: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2557: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2558: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2559: p_period_rec FA_API_TYPES.period_rec_type,
2552: FUNCTION CurrentPeriodAdj(
2553: p_trans_rec FA_API_TYPES.trans_rec_type,
2554: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
2555: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2556: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2557: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2558: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2559: p_period_rec FA_API_TYPES.period_rec_type,
2560: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
2553: p_trans_rec FA_API_TYPES.trans_rec_type,
2554: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
2555: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2556: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2557: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2558: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2559: p_period_rec FA_API_TYPES.period_rec_type,
2560: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
2561: p_proceeds_of_sale NUMBER default 0,
2554: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
2555: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2556: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2557: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2558: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2559: p_period_rec FA_API_TYPES.period_rec_type,
2560: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
2561: p_proceeds_of_sale NUMBER default 0,
2562: p_cost_of_removal NUMBER default 0,
2555: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2556: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2557: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2558: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2559: p_period_rec FA_API_TYPES.period_rec_type,
2560: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
2561: p_proceeds_of_sale NUMBER default 0,
2562: p_cost_of_removal NUMBER default 0,
2563: p_calling_fn VARCHAR2,
2556: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2557: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2558: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2559: p_period_rec FA_API_TYPES.period_rec_type,
2560: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
2561: p_proceeds_of_sale NUMBER default 0,
2562: p_cost_of_removal NUMBER default 0,
2563: p_calling_fn VARCHAR2,
2564: p_mrc_sob_type_code VARCHAR2,
2561: p_proceeds_of_sale NUMBER default 0,
2562: p_cost_of_removal NUMBER default 0,
2563: p_calling_fn VARCHAR2,
2564: p_mrc_sob_type_code VARCHAR2,
2565: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
2566: return BOOLEAN is
2567:
2568: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.CurrentPeriodAdj';
2569:
3138: -- 3.3: Call Deprn Basis function to get new adjusted_cost, raf and formula_factor.
3139: -- 4: Return catch-up amount.
3140: --+==============================================================================
3141: FUNCTION bsRecalculate(
3142: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
3143: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3144: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3145: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3146: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3139: -- 4: Return catch-up amount.
3140: --+==============================================================================
3141: FUNCTION bsRecalculate(
3142: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
3143: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3144: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3145: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3146: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3147: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3140: --+==============================================================================
3141: FUNCTION bsRecalculate(
3142: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
3143: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3144: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3145: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3146: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3147: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3148: p_period_rec FA_API_TYPES.period_rec_type,
3141: FUNCTION bsRecalculate(
3142: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
3143: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3144: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3145: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3146: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3147: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3148: p_period_rec FA_API_TYPES.period_rec_type,
3149: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3142: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
3143: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3144: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3145: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3146: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3147: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3148: p_period_rec FA_API_TYPES.period_rec_type,
3149: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3150: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
3143: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3144: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3145: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3146: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3147: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3148: p_period_rec FA_API_TYPES.period_rec_type,
3149: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3150: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
3151: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
3144: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3145: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3146: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3147: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3148: p_period_rec FA_API_TYPES.period_rec_type,
3149: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3150: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
3151: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
3152: x_deprn_expense OUT NOCOPY NUMBER,
3145: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3146: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3147: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3148: p_period_rec FA_API_TYPES.period_rec_type,
3149: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3150: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
3151: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
3152: x_deprn_expense OUT NOCOPY NUMBER,
3153: x_bonus_expense OUT NOCOPY NUMBER,
3146: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3147: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3148: p_period_rec FA_API_TYPES.period_rec_type,
3149: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3150: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
3151: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
3152: x_deprn_expense OUT NOCOPY NUMBER,
3153: x_bonus_expense OUT NOCOPY NUMBER,
3154: x_deprn_reserve OUT NOCOPY NUMBER,
3147: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3148: p_period_rec FA_API_TYPES.period_rec_type,
3149: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3150: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
3151: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
3152: x_deprn_expense OUT NOCOPY NUMBER,
3153: x_bonus_expense OUT NOCOPY NUMBER,
3154: x_deprn_reserve OUT NOCOPY NUMBER,
3155: p_running_mode IN NUMBER,
3160: p_reclassed_asset_dpis DATE,
3161: p_update_books_summary BOOLEAN default FALSE,
3162: p_mrc_sob_type_code VARCHAR2,
3163: p_calling_fn VARCHAR2,
3164: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
3165:
3166: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.bsRecalculate';
3167:
3168: --
3419:
3420: l_mem_trx BOOLEAN := FALSE; -- FALSE if this is group trx
3421: l_temp_num NUMBER; -- temporary numbers for calculation
3422:
3423: l_period_rec FA_API_TYPES.period_rec_type; -- Store period information of
3424: -- the period where trx date
3425: -- falls into
3426: -- the period where trx date
3427: -- falls into, then
3426: -- the period where trx date
3427: -- falls into, then
3428: -- store period info for
3429: -- each period processed.
3430: l_trx_period_rec FA_API_TYPES.period_rec_type; -- Store period information of
3431: -- the period where trx date
3432: -- falls into
3433:
3434: l_ind BINARY_INTEGER; -- Used to find delta amounts for each period
3462: l_adjusted_ind BINARY_INTEGER;
3463: l_count BINARY_INTEGER := 0; -- Stores count of tbs tables
3464:
3465: --+++++ Store data related to each transactions +++++
3466: l_trans_rec FA_API_TYPES.trans_rec_type; -- Not used
3467: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3468: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3469: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis
3470: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3463: l_count BINARY_INTEGER := 0; -- Stores count of tbs tables
3464:
3465: --+++++ Store data related to each transactions +++++
3466: l_trans_rec FA_API_TYPES.trans_rec_type; -- Not used
3467: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3468: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3469: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis
3470: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3471:
3464:
3465: --+++++ Store data related to each transactions +++++
3466: l_trans_rec FA_API_TYPES.trans_rec_type; -- Not used
3467: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3468: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3469: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis
3470: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3471:
3472: --+++++ Variables for calling buildMemberTable function +++++
3465: --+++++ Store data related to each transactions +++++
3466: l_trans_rec FA_API_TYPES.trans_rec_type; -- Not used
3467: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3468: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3469: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis
3470: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3471:
3472: --+++++ Variables for calling buildMemberTable function +++++
3473: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type; -- Store member info
3466: l_trans_rec FA_API_TYPES.trans_rec_type; -- Not used
3467: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3468: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3469: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis
3470: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3471:
3472: --+++++ Variables for calling buildMemberTable function +++++
3473: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type; -- Store member info
3474: t_period_counter fa_amort_pvt.tab_num15_type;
3469: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis
3470: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3471:
3472: --+++++ Variables for calling buildMemberTable function +++++
3473: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type; -- Store member info
3474: t_period_counter fa_amort_pvt.tab_num15_type;
3475: t_delta_cost fa_amort_pvt.tab_num_type;
3476: t_delta_cip_cost fa_amort_pvt.tab_num_type;
3477: t_delta_salvage_value fa_amort_pvt.tab_num_type;
3477: t_delta_salvage_value fa_amort_pvt.tab_num_type;
3478: t_delta_deprn_limit_amount fa_amort_pvt.tab_num_type;
3479: l_member_dpis DATE;
3480: l_multiplier NUMBER := 1;
3481: l_m_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type; -- member's delta info
3482: l_asset_fin_rec_reclass FA_API_TYPES.asset_fin_rec_type; -- correct fin rec adj for
3483: -- reclass
3484: l_salvage_limit_type VARCHAR2(30);
3485:
3478: t_delta_deprn_limit_amount fa_amort_pvt.tab_num_type;
3479: l_member_dpis DATE;
3480: l_multiplier NUMBER := 1;
3481: l_m_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type; -- member's delta info
3482: l_asset_fin_rec_reclass FA_API_TYPES.asset_fin_rec_type; -- correct fin rec adj for
3483: -- reclass
3484: l_salvage_limit_type VARCHAR2(30);
3485:
3486: --+++++ Variables for CURSOR c_get_rein_info +++++
3529: --++++++++ variables for calling catchupBooksSummary ++++++++
3530: l_depreciate_flag_change BOOLEAN := FALSE;
3531: l_disabled_flag_change BOOLEAN := FALSE;
3532:
3533: l_gr_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Reclass
3534: l_gr_ind BINARY_INTEGER;
3535:
3536: --+ HHIRAGA added on Oct/Nov in 2003
3537: --++++++++ variables for Trackking Member Feature ++++++++
6793: -- This procedure popualte asset_fin_rec_adj in case it is not provided.
6794: --
6795: --+==============================================================================
6796: PROCEDURE populate_fin_rec(
6797: p_trans_rec FA_API_TYPES.trans_rec_type,
6798: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
6799: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
6800: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
6801: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
6794: --
6795: --+==============================================================================
6796: PROCEDURE populate_fin_rec(
6797: p_trans_rec FA_API_TYPES.trans_rec_type,
6798: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
6799: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
6800: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
6801: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
6802: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
6795: --+==============================================================================
6796: PROCEDURE populate_fin_rec(
6797: p_trans_rec FA_API_TYPES.trans_rec_type,
6798: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
6799: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
6800: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
6801: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
6802: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
6803:
6796: PROCEDURE populate_fin_rec(
6797: p_trans_rec FA_API_TYPES.trans_rec_type,
6798: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
6799: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
6800: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
6801: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
6802: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
6803:
6804: BEGIN
6797: p_trans_rec FA_API_TYPES.trans_rec_type,
6798: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
6799: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
6800: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
6801: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
6802: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
6803:
6804: BEGIN
6805: /*
6798: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
6799: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
6800: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
6801: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
6802: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
6803:
6804: BEGIN
6805: /*
6806: if (nvl(p_asset_fin_rec_old.cost, 0) = nvl(p_asset_fin_rec_new.cost, 0) and
7009:
7010: ---------------------------------------------------------------------------
7011:
7012: FUNCTION faxama
7013: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7014: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7015: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7016: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7017: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7010: ---------------------------------------------------------------------------
7011:
7012: FUNCTION faxama
7013: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7014: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7015: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7016: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7017: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7018: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7011:
7012: FUNCTION faxama
7013: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7014: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7015: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7016: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7017: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7018: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7019: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7012: FUNCTION faxama
7013: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7014: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7015: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7016: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7017: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7018: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7019: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7020: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7013: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7014: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7015: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7016: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7017: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7018: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7019: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7020: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7014: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7015: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7016: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7017: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7018: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7019: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7020: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7022: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
7015: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7016: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7017: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7018: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7019: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7020: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7022: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
7023: p_period_rec FA_API_TYPES.period_rec_type,
7016: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7017: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7018: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7019: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7020: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7022: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
7023: p_period_rec FA_API_TYPES.period_rec_type,
7024: p_mrc_sob_type_code VARCHAR2,
7017: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7018: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7019: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7020: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7022: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
7023: p_period_rec FA_API_TYPES.period_rec_type,
7024: p_mrc_sob_type_code VARCHAR2,
7025: p_running_mode NUMBER,
7018: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7019: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7020: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7022: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
7023: p_period_rec FA_API_TYPES.period_rec_type,
7024: p_mrc_sob_type_code VARCHAR2,
7025: p_running_mode NUMBER,
7026: p_used_by_revaluation NUMBER,
7019: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7020: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7022: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
7023: p_period_rec FA_API_TYPES.period_rec_type,
7024: p_mrc_sob_type_code VARCHAR2,
7025: p_running_mode NUMBER,
7026: p_used_by_revaluation NUMBER,
7027: p_reclassed_asset_id NUMBER default null,
7033: p_cost_of_removal NUMBER default 0,
7034: x_deprn_exp OUT NOCOPY NUMBER,
7035: x_bonus_deprn_exp OUT NOCOPY NUMBER,
7036: x_deprn_rsv OUT NOCOPY NUMBER,
7037: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
7038:
7039: l_calling_fn varchar2(50) := 'newFA_AMORT_PVT.faxama';
7040: l_reval_deprn_rsv_adj number :=0;
7041: l_afn_zero number:=0;
7039: l_calling_fn varchar2(50) := 'newFA_AMORT_PVT.faxama';
7040: l_reval_deprn_rsv_adj number :=0;
7041: l_afn_zero number:=0;
7042:
7043: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
7044:
7045: -- Bug4958977: Adding following cursor and 2 new variables
7046: CURSOR c_check_dpis_change is
7047: select inbk.transaction_header_id_in
7427: -- Unplanned Depreciation UA or UE
7428: --
7429: --+==============================================================================
7430: FUNCTION GetExpRsv(
7431: p_trans_rec FA_API_TYPES.trans_rec_type,
7432: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7433: p_period_rec FA_API_TYPES.period_rec_type,
7434: p_mrc_sob_type_code VARCHAR2,
7435: x_exp_rsv_amount OUT NOCOPY NUMBER,
7428: --
7429: --+==============================================================================
7430: FUNCTION GetExpRsv(
7431: p_trans_rec FA_API_TYPES.trans_rec_type,
7432: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7433: p_period_rec FA_API_TYPES.period_rec_type,
7434: p_mrc_sob_type_code VARCHAR2,
7435: x_exp_rsv_amount OUT NOCOPY NUMBER,
7436: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
7429: --+==============================================================================
7430: FUNCTION GetExpRsv(
7431: p_trans_rec FA_API_TYPES.trans_rec_type,
7432: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7433: p_period_rec FA_API_TYPES.period_rec_type,
7434: p_mrc_sob_type_code VARCHAR2,
7435: x_exp_rsv_amount OUT NOCOPY NUMBER,
7436: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
7437:
7432: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7433: p_period_rec FA_API_TYPES.period_rec_type,
7434: p_mrc_sob_type_code VARCHAR2,
7435: x_exp_rsv_amount OUT NOCOPY NUMBER,
7436: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
7437:
7438: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.GetExpRsv';
7439:
7440: --
7510:
7511: --+==============================================================================
7512: -- Function: GetDeprnRec
7513: --
7514: -- The function returns FA_API_TYPES.asset_deprn_rec_type.
7515: -- This will be the starting point for recalculating depreciation.
7516: --
7517: --+==============================================================================
7518: FUNCTION GetDeprnRec (
7515: -- This will be the starting point for recalculating depreciation.
7516: --
7517: --+==============================================================================
7518: FUNCTION GetDeprnRec (
7519: p_trans_rec FA_API_TYPES.trans_rec_type,
7520: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7521: p_period_rec FA_API_TYPES.period_rec_type,
7522: p_incoming_trx_type_code VARCHAR2 default 'NULL',
7523: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
7516: --
7517: --+==============================================================================
7518: FUNCTION GetDeprnRec (
7519: p_trans_rec FA_API_TYPES.trans_rec_type,
7520: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7521: p_period_rec FA_API_TYPES.period_rec_type,
7522: p_incoming_trx_type_code VARCHAR2 default 'NULL',
7523: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
7524: p_mrc_sob_type_code VARCHAR2,
7517: --+==============================================================================
7518: FUNCTION GetDeprnRec (
7519: p_trans_rec FA_API_TYPES.trans_rec_type,
7520: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7521: p_period_rec FA_API_TYPES.period_rec_type,
7522: p_incoming_trx_type_code VARCHAR2 default 'NULL',
7523: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
7524: p_mrc_sob_type_code VARCHAR2,
7525: p_unplanned_exp IN OUT NOCOPY NUMBER,
7519: p_trans_rec FA_API_TYPES.trans_rec_type,
7520: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7521: p_period_rec FA_API_TYPES.period_rec_type,
7522: p_incoming_trx_type_code VARCHAR2 default 'NULL',
7523: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
7524: p_mrc_sob_type_code VARCHAR2,
7525: p_unplanned_exp IN OUT NOCOPY NUMBER,
7526: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
7527:
7522: p_incoming_trx_type_code VARCHAR2 default 'NULL',
7523: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
7524: p_mrc_sob_type_code VARCHAR2,
7525: p_unplanned_exp IN OUT NOCOPY NUMBER,
7526: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
7527:
7528: CURSOR c_check_period IS
7529: select 'Y'
7530: from fa_deprn_summary
7950: -- Function: GetEofyReserve
7951: --
7952: --+==============================================================================
7953: FUNCTION GetEofyReserve(
7954: p_trans_rec FA_API_TYPES.trans_rec_type,
7955: p_trans_rec_cur FA_API_TYPES.trans_rec_type,
7956: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7957: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7958: p_period_rec FA_API_TYPES.period_rec_type,
7951: --
7952: --+==============================================================================
7953: FUNCTION GetEofyReserve(
7954: p_trans_rec FA_API_TYPES.trans_rec_type,
7955: p_trans_rec_cur FA_API_TYPES.trans_rec_type,
7956: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7957: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7958: p_period_rec FA_API_TYPES.period_rec_type,
7959: x_eofy_reserve OUT NOCOPY NUMBER,
7952: --+==============================================================================
7953: FUNCTION GetEofyReserve(
7954: p_trans_rec FA_API_TYPES.trans_rec_type,
7955: p_trans_rec_cur FA_API_TYPES.trans_rec_type,
7956: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7957: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7958: p_period_rec FA_API_TYPES.period_rec_type,
7959: x_eofy_reserve OUT NOCOPY NUMBER,
7960: x_transaction_header_id OUT NOCOPY NUMBER,
7953: FUNCTION GetEofyReserve(
7954: p_trans_rec FA_API_TYPES.trans_rec_type,
7955: p_trans_rec_cur FA_API_TYPES.trans_rec_type,
7956: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7957: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7958: p_period_rec FA_API_TYPES.period_rec_type,
7959: x_eofy_reserve OUT NOCOPY NUMBER,
7960: x_transaction_header_id OUT NOCOPY NUMBER,
7961: x_transaction_date_entered OUT NOCOPY DATE,
7954: p_trans_rec FA_API_TYPES.trans_rec_type,
7955: p_trans_rec_cur FA_API_TYPES.trans_rec_type,
7956: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7957: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7958: p_period_rec FA_API_TYPES.period_rec_type,
7959: x_eofy_reserve OUT NOCOPY NUMBER,
7960: x_transaction_header_id OUT NOCOPY NUMBER,
7961: x_transaction_date_entered OUT NOCOPY DATE,
7962: x_date_effective OUT NOCOPY DATE,
7962: x_date_effective OUT NOCOPY DATE,
7963: x_transaction_type_code OUT NOCOPY VARCHAR2,
7964: p_mrc_sob_type_code VARCHAR2,
7965: p_calling_fn VARCHAR2,
7966: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
7967:
7968: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.GetEofyReserve';
7969: get_err EXCEPTION;
7970:
8180: l_transaction_date_entered DATE;
8181: l_date_effective DATE;
8182: l_transaction_type_code VARCHAR2(30);
8183:
8184: l_period_rec FA_API_TYPES.period_rec_type;
8185: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
8186:
8187: l_unplanned_exp NUMBER := 0;
8188: l_reserve_retired NUMBER := 0;
8181: l_date_effective DATE;
8182: l_transaction_type_code VARCHAR2(30);
8183:
8184: l_period_rec FA_API_TYPES.period_rec_type;
8185: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
8186:
8187: l_unplanned_exp NUMBER := 0;
8188: l_reserve_retired NUMBER := 0;
8189: l_eofy_reserve_retired NUMBER := 0;
8369: --
8370: --
8371: --+==============================================================================
8372: FUNCTION GetFinAdjRec(
8373: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8374: p_reclass_src_dest VARCHAR2,
8375: p_transaction_date_entered DATE,
8376: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8377: p_mrc_sob_type_code VARCHAR2,
8372: FUNCTION GetFinAdjRec(
8373: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8374: p_reclass_src_dest VARCHAR2,
8375: p_transaction_date_entered DATE,
8376: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8377: p_mrc_sob_type_code VARCHAR2,
8378: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
8379: return BOOLEAN is
8380:
8374: p_reclass_src_dest VARCHAR2,
8375: p_transaction_date_entered DATE,
8376: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8377: p_mrc_sob_type_code VARCHAR2,
8378: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
8379: return BOOLEAN is
8380:
8381: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.GetFinAdjRec';
8382: get_err EXCEPTION;
8558: --
8559: --
8560: --+==============================================================================
8561: FUNCTION GetFinRec(
8562: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8563: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8564: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8565: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8566: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8559: --
8560: --+==============================================================================
8561: FUNCTION GetFinRec(
8562: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8563: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8564: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8565: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8566: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8567: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8560: --+==============================================================================
8561: FUNCTION GetFinRec(
8562: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8563: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8564: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8565: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8566: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8567: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8568: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8561: FUNCTION GetFinRec(
8562: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8563: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8564: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8565: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8566: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8567: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8568: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8569: p_init_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE,
8562: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8563: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8564: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8565: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8566: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8567: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8568: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8569: p_init_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE,
8570: p_use_fin_rec_adj BOOLEAN,
8563: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8564: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8565: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8566: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8567: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8568: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8569: p_init_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE,
8570: p_use_fin_rec_adj BOOLEAN,
8571: p_use_new_deprn_rule BOOLEAN,
8564: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8565: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8566: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8567: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8568: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8569: p_init_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE,
8570: p_use_fin_rec_adj BOOLEAN,
8571: p_use_new_deprn_rule BOOLEAN,
8572: p_process_this_trx BOOLEAN,
8571: p_use_new_deprn_rule BOOLEAN,
8572: p_process_this_trx BOOLEAN,
8573: x_dpis_change OUT NOCOPY BOOLEAN,
8574: p_mrc_sob_type_code VARCHAR2,
8575: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
8576:
8577: Cursor c_get_init_bk IS
8578: select date_placed_in_service
8579: , deprn_start_date
9753: from fa_transaction_headers
9754: where transaction_header_id = p_trans_rec.member_transaction_header_id;
9755:
9756: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.GetFinRec';
9757: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
9758: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
9759: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
9760: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
9761: l_period_rec FA_API_TYPES.period_rec_type;
9754: where transaction_header_id = p_trans_rec.member_transaction_header_id;
9755:
9756: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.GetFinRec';
9757: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
9758: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
9759: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
9760: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
9761: l_period_rec FA_API_TYPES.period_rec_type;
9762:
9755:
9756: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.GetFinRec';
9757: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
9758: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
9759: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
9760: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
9761: l_period_rec FA_API_TYPES.period_rec_type;
9762:
9763: l_is_member_trx_for_group BOOLEAN := FALSE;
9756: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.GetFinRec';
9757: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
9758: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
9759: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
9760: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
9761: l_period_rec FA_API_TYPES.period_rec_type;
9762:
9763: l_is_member_trx_for_group BOOLEAN := FALSE;
9764: l_asset_id NUMBER;
9757: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
9758: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
9759: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
9760: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
9761: l_period_rec FA_API_TYPES.period_rec_type;
9762:
9763: l_is_member_trx_for_group BOOLEAN := FALSE;
9764: l_asset_id NUMBER;
9765: l_transaction_header_id NUMBER;
11166: -- NOTE: Retirement which has been reinstated will not be processed at all.
11167: -- 4: Return catch-up amount.
11168: --+==============================================================================
11169: FUNCTION Recalculate(
11170: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
11171: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
11172: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11173: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11174: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11167: -- 4: Return catch-up amount.
11168: --+==============================================================================
11169: FUNCTION Recalculate(
11170: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
11171: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
11172: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11173: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11174: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11175: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11168: --+==============================================================================
11169: FUNCTION Recalculate(
11170: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
11171: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
11172: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11173: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11174: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11175: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11176: p_period_rec FA_API_TYPES.period_rec_type,
11169: FUNCTION Recalculate(
11170: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
11171: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
11172: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11173: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11174: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11175: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11176: p_period_rec FA_API_TYPES.period_rec_type,
11177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11170: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
11171: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
11172: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11173: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11174: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11175: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11176: p_period_rec FA_API_TYPES.period_rec_type,
11177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11178: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11171: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
11172: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11173: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11174: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11175: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11176: p_period_rec FA_API_TYPES.period_rec_type,
11177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11178: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11179: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11172: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11173: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11174: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11175: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11176: p_period_rec FA_API_TYPES.period_rec_type,
11177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11178: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11179: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11180: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,
11173: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11174: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11175: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11176: p_period_rec FA_API_TYPES.period_rec_type,
11177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11178: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11179: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11180: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,
11181: x_bonus_expense OUT NOCOPY FA_DEPRN_SUMMARY.BONUS_DEPRN_AMOUNT%TYPE,
11174: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11175: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11176: p_period_rec FA_API_TYPES.period_rec_type,
11177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11178: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11179: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11180: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,
11181: x_bonus_expense OUT NOCOPY FA_DEPRN_SUMMARY.BONUS_DEPRN_AMOUNT%TYPE,
11182: p_running_mode IN NUMBER,
11175: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11176: p_period_rec FA_API_TYPES.period_rec_type,
11177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11178: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11179: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11180: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,
11181: x_bonus_expense OUT NOCOPY FA_DEPRN_SUMMARY.BONUS_DEPRN_AMOUNT%TYPE,
11182: p_running_mode IN NUMBER,
11183: p_used_by_revaluation IN NUMBER,
11185: p_reclass_src_dest VARCHAR2,
11186: p_reclassed_asset_dpis DATE,
11187: p_mrc_sob_type_code VARCHAR2,
11188: p_calling_fn VARCHAR2,
11189: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
11190:
11191: l_calling_fn VARCHAR2(100) := 'FA_AMORT_CALC_PVT.Recalculate';
11192:
11193: --Bug3696765
11884:
11885: l_row_count NUMBER := 0;
11886:
11887: --+++++ Store data related to each transactions +++++
11888: l_trans_rec FA_API_TYPES.trans_rec_type;
11889: l_invoice_transaction_id NUMBER;
11890: l_period_rec FA_API_TYPES.period_rec_type;
11891: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11892: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
11886:
11887: --+++++ Store data related to each transactions +++++
11888: l_trans_rec FA_API_TYPES.trans_rec_type;
11889: l_invoice_transaction_id NUMBER;
11890: l_period_rec FA_API_TYPES.period_rec_type;
11891: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11892: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
11893: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
11894: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11887: --+++++ Store data related to each transactions +++++
11888: l_trans_rec FA_API_TYPES.trans_rec_type;
11889: l_invoice_transaction_id NUMBER;
11890: l_period_rec FA_API_TYPES.period_rec_type;
11891: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11892: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
11893: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
11894: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11895: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11888: l_trans_rec FA_API_TYPES.trans_rec_type;
11889: l_invoice_transaction_id NUMBER;
11890: l_period_rec FA_API_TYPES.period_rec_type;
11891: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11892: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
11893: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
11894: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11895: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11896: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11889: l_invoice_transaction_id NUMBER;
11890: l_period_rec FA_API_TYPES.period_rec_type;
11891: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11892: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
11893: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
11894: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11895: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11896: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11897:
11890: l_period_rec FA_API_TYPES.period_rec_type;
11891: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11892: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
11893: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
11894: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11895: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11896: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11897:
11898: l_least_thid number(15); -- Stored least transaction_header_id
11891: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11892: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
11893: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
11894: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11895: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11896: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11897:
11898: l_least_thid number(15); -- Stored least transaction_header_id
11899: -- to find starting fa_books record
11892: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
11893: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
11894: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11895: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11896: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11897:
11898: l_least_thid number(15); -- Stored least transaction_header_id
11899: -- to find starting fa_books record
11900: l_member_asset_id number(15) := to_number(null); -- Store member asset id
11898: l_least_thid number(15); -- Stored least transaction_header_id
11899: -- to find starting fa_books record
11900: l_member_asset_id number(15) := to_number(null); -- Store member asset id
11901: l_member_trx_key varchar2(2); -- member transaction key
11902: l_member_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11903: l_next_period_rec FA_API_TYPES.period_rec_type;
11904: l_transaction_type_code varchar2(30); -- Used to find reinstatement
11905:
11906: l_temp_period_counter number(15); -- This is to store period counter because GetDeprnRec needs
11899: -- to find starting fa_books record
11900: l_member_asset_id number(15) := to_number(null); -- Store member asset id
11901: l_member_trx_key varchar2(2); -- member transaction key
11902: l_member_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11903: l_next_period_rec FA_API_TYPES.period_rec_type;
11904: l_transaction_type_code varchar2(30); -- Used to find reinstatement
11905:
11906: l_temp_period_counter number(15); -- This is to store period counter because GetDeprnRec needs
11907: -- period counter = period_counter - 1
12027: l_start_from_first BOOLEAN := TRUE;
12028:
12029: -- Bug PKO
12030: l_retirement_thid NUMBER := -1;
12031: l_catchup_begin_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12032: l_temp_reserve NUMBER;
12033:
12034: l_cost_frac NUMBER; -- Bug 5948890
12035:
14325:
14326: ---------------------------------------------------------------------------
14327:
14328: FUNCTION faxama
14329: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
14330: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14332: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14326: ---------------------------------------------------------------------------
14327:
14328: FUNCTION faxama
14329: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
14330: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14332: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14334: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14327:
14328: FUNCTION faxama
14329: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
14330: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14332: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14334: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14335: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
14328: FUNCTION faxama
14329: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
14330: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14332: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14334: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14335: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
14336: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14329: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
14330: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14332: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14334: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14335: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
14336: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14337: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14330: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14332: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14334: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14335: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
14336: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14337: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14338: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
14331: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14332: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14334: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14335: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
14336: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14337: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14338: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
14339: p_period_rec IN FA_API_TYPES.period_rec_type,
14332: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14334: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14335: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
14336: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14337: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14338: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
14339: p_period_rec IN FA_API_TYPES.period_rec_type,
14340: p_mrc_sob_type_code IN VARCHAR2,
14333: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14334: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14335: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
14336: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14337: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14338: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
14339: p_period_rec IN FA_API_TYPES.period_rec_type,
14340: p_mrc_sob_type_code IN VARCHAR2,
14341: p_running_mode IN NUMBER,
14334: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14335: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
14336: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14337: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14338: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
14339: p_period_rec IN FA_API_TYPES.period_rec_type,
14340: p_mrc_sob_type_code IN VARCHAR2,
14341: p_running_mode IN NUMBER,
14342: p_used_by_revaluation IN NUMBER,
14335: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
14336: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14337: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14338: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
14339: p_period_rec IN FA_API_TYPES.period_rec_type,
14340: p_mrc_sob_type_code IN VARCHAR2,
14341: p_running_mode IN NUMBER,
14342: p_used_by_revaluation IN NUMBER,
14343: p_reclassed_asset_id NUMBER default null,
14344: p_reclass_src_dest VARCHAR2 default null,
14345: p_reclassed_asset_dpis DATE default null,
14346: x_deprn_exp OUT NOCOPY NUMBER,
14347: x_bonus_deprn_exp OUT NOCOPY NUMBER,
14348: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
14349:
14350: l_calling_fn varchar2(50) := 'FA_AMORT_PVT.faxama';
14351: l_reval_deprn_rsv_adj number :=0;
14352: l_afn_zero number:=0;
14350: l_calling_fn varchar2(50) := 'FA_AMORT_PVT.faxama';
14351: l_reval_deprn_rsv_adj number :=0;
14352: l_afn_zero number:=0;
14353:
14354: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
14355: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type; -- Added to call calc_raf_adj
14356:
14357: calc_err EXCEPTION;
14358:
14351: l_reval_deprn_rsv_adj number :=0;
14352: l_afn_zero number:=0;
14353:
14354: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
14355: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type; -- Added to call calc_raf_adj
14356:
14357: calc_err EXCEPTION;
14358:
14359: /*
14567: -- this function will get books row of addition transaction
14568: -- and call faxcde to calculate what the actual reserve is from the
14569: -- prorate period upto right before the amortization period
14570:
14571: FUNCTION get_reserve(px_trans_rec in out nocopy FA_API_TYPES.trans_rec_type,
14572: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
14573: p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type,
14574: px_asset_fin_rec in out nocopy FA_API_TYPES.asset_fin_rec_type,
14575: p_add_txn_id in number,
14568: -- and call faxcde to calculate what the actual reserve is from the
14569: -- prorate period upto right before the amortization period
14570:
14571: FUNCTION get_reserve(px_trans_rec in out nocopy FA_API_TYPES.trans_rec_type,
14572: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
14573: p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type,
14574: px_asset_fin_rec in out nocopy FA_API_TYPES.asset_fin_rec_type,
14575: p_add_txn_id in number,
14576: p_amortize_fy in integer,
14569: -- prorate period upto right before the amortization period
14570:
14571: FUNCTION get_reserve(px_trans_rec in out nocopy FA_API_TYPES.trans_rec_type,
14572: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
14573: p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type,
14574: px_asset_fin_rec in out nocopy FA_API_TYPES.asset_fin_rec_type,
14575: p_add_txn_id in number,
14576: p_amortize_fy in integer,
14577: p_amortize_per_num in integer,
14570:
14571: FUNCTION get_reserve(px_trans_rec in out nocopy FA_API_TYPES.trans_rec_type,
14572: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
14573: p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type,
14574: px_asset_fin_rec in out nocopy FA_API_TYPES.asset_fin_rec_type,
14575: p_add_txn_id in number,
14576: p_amortize_fy in integer,
14577: p_amortize_per_num in integer,
14578: p_pers_per_yr in integer,
14578: p_pers_per_yr in integer,
14579: p_mrc_sob_type_code in varchar2,
14580: x_deprn_rsv out nocopy number,
14581: x_bonus_deprn_rsv out nocopy number,
14582: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
14583: return boolean is
14584:
14585: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
14586: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
14581: x_bonus_deprn_rsv out nocopy number,
14582: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
14583: return boolean is
14584:
14585: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
14586: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
14587:
14588: l_dpr_row FA_STD_TYPES.dpr_struct;
14589: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
14582: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
14583: return boolean is
14584:
14585: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
14586: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
14587:
14588: l_dpr_row FA_STD_TYPES.dpr_struct;
14589: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
14590: l_dpr_out FA_STD_TYPES.dpr_out_struct;
14756: p_prior_fy_exp in number,
14757: p_deprn_rsv in number,
14758: p_ytd_deprn in number,
14759: px_adj_cost in out nocopy number,
14760: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is
14761:
14762: l_deprn_basis_formula varchar2(30);
14763: l_rate_source_rule varchar2(10);
14764: l_deprn_basis_rule varchar2(4);
14830:
14831: end faxnac;
14832:
14833: FUNCTION faxraf
14834: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
14835: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14836: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14837: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14838: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14831: end faxnac;
14832:
14833: FUNCTION faxraf
14834: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
14835: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14836: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14837: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14838: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14839: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14832:
14833: FUNCTION faxraf
14834: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
14835: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14836: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14837: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14838: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14839: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14840: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14833: FUNCTION faxraf
14834: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
14835: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14836: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14837: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14838: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14839: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14840: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14841: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14834: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
14835: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14836: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14837: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14838: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14839: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14840: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14841: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14842: p_period_rec IN FA_API_TYPES.period_rec_type,
14835: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14836: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14837: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14838: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14839: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14840: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14841: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14842: p_period_rec IN FA_API_TYPES.period_rec_type,
14843: px_deprn_exp IN OUT NOCOPY number,
14836: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
14837: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14838: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14839: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14840: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14841: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14842: p_period_rec IN FA_API_TYPES.period_rec_type,
14843: px_deprn_exp IN OUT NOCOPY number,
14844: px_bonus_deprn_exp IN OUT NOCOPY number,
14837: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
14838: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14839: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14840: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14841: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14842: p_period_rec IN FA_API_TYPES.period_rec_type,
14843: px_deprn_exp IN OUT NOCOPY number,
14844: px_bonus_deprn_exp IN OUT NOCOPY number,
14845: px_reval_deprn_rsv_adj IN out NOCOPY number,
14838: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14839: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
14840: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
14841: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14842: p_period_rec IN FA_API_TYPES.period_rec_type,
14843: px_deprn_exp IN OUT NOCOPY number,
14844: px_bonus_deprn_exp IN OUT NOCOPY number,
14845: px_reval_deprn_rsv_adj IN out NOCOPY number,
14846: p_mrc_sob_type_code IN VARCHAR2,
14845: px_reval_deprn_rsv_adj IN out NOCOPY number,
14846: p_mrc_sob_type_code IN VARCHAR2,
14847: p_running_mode IN NUMBER,
14848: p_used_by_revaluation IN NUMBER,
14849: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
14850:
14851: l_dpr_row FA_STD_TYPES.dpr_struct;
14852: l_dpr_out FA_STD_TYPES.dpr_out_struct;
14853: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
15631: return FALSE;
15632: end faxraf;
15633:
15634: FUNCTION calc_raf_adj_cost
15635: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
15636: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15637: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15638: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15639: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15632: end faxraf;
15633:
15634: FUNCTION calc_raf_adj_cost
15635: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
15636: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15637: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15638: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15639: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15640: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15633:
15634: FUNCTION calc_raf_adj_cost
15635: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
15636: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15637: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15638: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15639: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15640: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15641: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
15634: FUNCTION calc_raf_adj_cost
15635: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
15636: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15637: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15638: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15639: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15640: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15641: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
15642: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
15635: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
15636: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15637: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15638: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15639: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15640: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15641: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
15642: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
15643: p_period_rec IN FA_API_TYPES.period_rec_type,
15636: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15637: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15638: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15639: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15640: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15641: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
15642: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
15643: p_period_rec IN FA_API_TYPES.period_rec_type,
15644: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,
15637: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15638: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15639: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15640: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15641: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
15642: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
15643: p_period_rec IN FA_API_TYPES.period_rec_type,
15644: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,
15645: p_mrc_sob_type_code IN VARCHAR2,
15638: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15639: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15640: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15641: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
15642: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
15643: p_period_rec IN FA_API_TYPES.period_rec_type,
15644: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,
15645: p_mrc_sob_type_code IN VARCHAR2,
15646: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
15639: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15640: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15641: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
15642: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
15643: p_period_rec IN FA_API_TYPES.period_rec_type,
15644: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,
15645: p_mrc_sob_type_code IN VARCHAR2,
15646: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
15647:
15640: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15641: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
15642: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
15643: p_period_rec IN FA_API_TYPES.period_rec_type,
15644: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,
15645: p_mrc_sob_type_code IN VARCHAR2,
15646: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
15647:
15648:
15642: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
15643: p_period_rec IN FA_API_TYPES.period_rec_type,
15644: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,
15645: p_mrc_sob_type_code IN VARCHAR2,
15646: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
15647:
15648:
15649: l_calling_fn VARCHAR2(50) := 'fa_amort_pvt.calc_raf_adj_cost';
15650:
15691: and group_asset_id = p_asset_hdr_rec.asset_id
15692: and asset_id <> group_asset_id
15693: and period_counter = l_recalc_start_period_counter - 1;
15694:
15695: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
15696:
15697: calc_err EXCEPTION;
15698:
15699: BEGIN
16201: FUNCTION check_dpis_change (
16202: p_book_type_code VARCHAR2,
16203: p_transaction_header_id NUMBER,
16204: p_group_asset_id NUMBER,
16205: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
16206: x_period_counter_out OUT NOCOPY NUMBER,
16207: p_mrc_sob_type_code VARCHAR2,
16208: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
16209: RETURN BOOLEAN is
16204: p_group_asset_id NUMBER,
16205: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
16206: x_period_counter_out OUT NOCOPY NUMBER,
16207: p_mrc_sob_type_code VARCHAR2,
16208: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
16209: RETURN BOOLEAN is
16210:
16211: l_calling_fn varchar2(100) := 'FA_AMORT_PVT.check_dpis_change';
16212:
16274: END check_dpis_change;
16275:
16276: --Bug 5149789
16277: FUNCTION check_member_existence (
16278: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type
16279: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
16280: RETURN BOOLEAN is
16281:
16282: l_calling_fn varchar2(100) := 'FA_AMORT_PVT.check_member_existence';
16275:
16276: --Bug 5149789
16277: FUNCTION check_member_existence (
16278: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type
16279: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
16280: RETURN BOOLEAN is
16281:
16282: l_calling_fn varchar2(100) := 'FA_AMORT_PVT.check_member_existence';
16283: