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_AMORT_PVT dependencies on FA_API_TYPES

Line 51: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

47: g_deprn_ch_trx_id NUMBER;
48:
49: --Bug 5149789
50: FUNCTION check_member_existence (
51: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
52: RETURN BOOLEAN;
53:
54: --Bug4938977: Adding a private function.
55: FUNCTION check_dpis_change (

Line 59: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

55: FUNCTION check_dpis_change (
56: p_book_type_code VARCHAR2,
57: p_transaction_header_id NUMBER,
58: p_group_asset_id NUMBER,
59: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
60: x_period_counter_out OUT NOCOPY NUMBER,
61: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
62: RETURN BOOLEAN;
63:

Line 61: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

57: p_transaction_header_id NUMBER,
58: p_group_asset_id NUMBER,
59: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
60: x_period_counter_out OUT NOCOPY NUMBER,
61: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
62: RETURN BOOLEAN;
63:
64: -- Bug 8398064
65: -- To identify overlapping retirements, we need fn to convert txn date

Line 68: FUNCTION get_dcal_pc ( pp_book_type_code in varchar2, pp_date in date, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

64: -- Bug 8398064
65: -- To identify overlapping retirements, we need fn to convert txn date
66: -- to corresponding deprn period ctr
67: --
68: FUNCTION get_dcal_pc ( pp_book_type_code in varchar2, pp_date in date, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
69: return number is
70: l_pc number := 0;
71: l_calling_fn varchar2(40) := 'FA_AMORT_PVT.get_dcal_pc';
72: BEGIN

Line 95: p_period_counter number default 0, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

91: -- End Bug 8398064
92:
93: PROCEDURE printBooksSummary(p_asset_id number,
94: p_book_type_code varchar2,
95: p_period_counter number default 0, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
96:
97: CURSOR c_get_books_summary IS
98: select period_counter
99: , cost

Line 150: x_period_rec OUT NOCOPY FA_API_TYPES.period_rec_type

146: p_jdate NUMBER,
147: p_book_type_code VARCHAR2,
148: p_mrc_sob_type_code VARCHAR2,
149: p_set_of_books_id NUMBER,
150: x_period_rec OUT NOCOPY FA_API_TYPES.period_rec_type
151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
152:
153: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.GetPeriodInfo';
154: get_err EXCEPTION;

Line 151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS

147: p_book_type_code VARCHAR2,
148: p_mrc_sob_type_code VARCHAR2,
149: p_set_of_books_id NUMBER,
150: x_period_rec OUT NOCOPY FA_API_TYPES.period_rec_type
151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
152:
153: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.GetPeriodInfo';
154: get_err EXCEPTION;
155:

Line 316: p_trans_rec FA_API_TYPES.trans_rec_type,

312: -- This function will create missing records from period where last record
313: -- exists up to current period.
314: --+==============================================================================
315: FUNCTION catchupBooksSummary (
316: p_trans_rec FA_API_TYPES.trans_rec_type,
317: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
318: p_period_rec FA_API_TYPES.period_rec_type,
319: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
320: p_depreciate_flag_change BOOLEAN,

Line 317: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

313: -- exists up to current period.
314: --+==============================================================================
315: FUNCTION catchupBooksSummary (
316: p_trans_rec FA_API_TYPES.trans_rec_type,
317: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
318: p_period_rec FA_API_TYPES.period_rec_type,
319: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
320: p_depreciate_flag_change BOOLEAN,
321: p_disabled_flag_change BOOLEAN,

Line 318: p_period_rec FA_API_TYPES.period_rec_type,

314: --+==============================================================================
315: FUNCTION catchupBooksSummary (
316: p_trans_rec FA_API_TYPES.trans_rec_type,
317: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
318: p_period_rec FA_API_TYPES.period_rec_type,
319: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
320: p_depreciate_flag_change BOOLEAN,
321: p_disabled_flag_change BOOLEAN,
322: p_mrc_sob_type_code VARCHAR2,

Line 319: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,

315: FUNCTION catchupBooksSummary (
316: p_trans_rec FA_API_TYPES.trans_rec_type,
317: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
318: p_period_rec FA_API_TYPES.period_rec_type,
319: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
320: p_depreciate_flag_change BOOLEAN,
321: p_disabled_flag_change BOOLEAN,
322: p_mrc_sob_type_code VARCHAR2,
323: p_calling_fn VARCHAR

Line 324: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

320: p_depreciate_flag_change BOOLEAN,
321: p_disabled_flag_change BOOLEAN,
322: p_mrc_sob_type_code VARCHAR2,
323: p_calling_fn VARCHAR
324: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
325:
326: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.catchupBooksSummary';
327:
328: CURSOR c_get_mc_last_period_counter IS

Line 1016: p_trans_rec FA_API_TYPES.trans_rec_type,

1012: -- deleting all of them and reinsert all of them.
1013: --
1014: --+==============================================================================
1015: FUNCTION createGroup(
1016: p_trans_rec FA_API_TYPES.trans_rec_type,
1017: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
1018: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
1019: p_period_rec FA_API_TYPES.period_rec_type,
1020: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,

Line 1017: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

1013: --
1014: --+==============================================================================
1015: FUNCTION createGroup(
1016: p_trans_rec FA_API_TYPES.trans_rec_type,
1017: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
1018: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
1019: p_period_rec FA_API_TYPES.period_rec_type,
1020: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
1021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,

Line 1018: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,

1014: --+==============================================================================
1015: FUNCTION createGroup(
1016: p_trans_rec FA_API_TYPES.trans_rec_type,
1017: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
1018: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
1019: p_period_rec FA_API_TYPES.period_rec_type,
1020: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
1021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
1022: p_mrc_sob_type_code VARCHAR2,

Line 1019: p_period_rec FA_API_TYPES.period_rec_type,

1015: FUNCTION createGroup(
1016: p_trans_rec FA_API_TYPES.trans_rec_type,
1017: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
1018: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
1019: p_period_rec FA_API_TYPES.period_rec_type,
1020: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
1021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
1022: p_mrc_sob_type_code VARCHAR2,
1023: p_calling_fn VARCHAR

Line 1020: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,

1016: p_trans_rec FA_API_TYPES.trans_rec_type,
1017: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
1018: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
1019: p_period_rec FA_API_TYPES.period_rec_type,
1020: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
1021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
1022: p_mrc_sob_type_code VARCHAR2,
1023: p_calling_fn VARCHAR
1024: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS

Line 1021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,

1017: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
1018: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
1019: p_period_rec FA_API_TYPES.period_rec_type,
1020: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
1021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
1022: p_mrc_sob_type_code VARCHAR2,
1023: p_calling_fn VARCHAR
1024: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
1025:

Line 1024: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS

1020: p_asset_fin_rec FA_API_TYPES.asset_fin_rec_type,
1021: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
1022: p_mrc_sob_type_code VARCHAR2,
1023: p_calling_fn VARCHAR
1024: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
1025:
1026: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.createGroup';
1027:
1028: --

Line 1502: p_trans_rec FA_API_TYPES.trans_rec_type,

1498: -- Function: buildMemberTable
1499: --
1500: --+==============================================================================
1501: FUNCTION buildMemberTable(
1502: p_trans_rec FA_API_TYPES.trans_rec_type,
1503: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
1504: p_period_rec FA_API_TYPES.period_rec_type,
1505: p_date_placed_in_service DATE,
1506: p_group_asset_id NUMBER,

Line 1503: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

1499: --
1500: --+==============================================================================
1501: FUNCTION buildMemberTable(
1502: p_trans_rec FA_API_TYPES.trans_rec_type,
1503: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
1504: p_period_rec FA_API_TYPES.period_rec_type,
1505: p_date_placed_in_service DATE,
1506: p_group_asset_id NUMBER,
1507: p_reclass_multiplier NUMBER,

Line 1504: p_period_rec FA_API_TYPES.period_rec_type,

1500: --+==============================================================================
1501: FUNCTION buildMemberTable(
1502: p_trans_rec FA_API_TYPES.trans_rec_type,
1503: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
1504: p_period_rec FA_API_TYPES.period_rec_type,
1505: p_date_placed_in_service DATE,
1506: p_group_asset_id NUMBER,
1507: p_reclass_multiplier NUMBER,
1508: p_reclass_src_dest VARCHAR2,

Line 1515: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

1511: x_td_cost OUT NOCOPY fa_amort_pvt.tab_num_type,
1512: x_td_cip_cost OUT NOCOPY fa_amort_pvt.tab_num_type,
1513: x_td_salvage_value OUT NOCOPY fa_amort_pvt.tab_num_type,
1514: x_td_deprn_limit_amount OUT NOCOPY fa_amort_pvt.tab_num_type,
1515: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1516: x_asset_fin_rec_reclass OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1517: p_mrc_sob_type_code VARCHAR2
1518: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)return BOOLEAN IS
1519:

Line 1516: x_asset_fin_rec_reclass OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

1512: x_td_cip_cost OUT NOCOPY fa_amort_pvt.tab_num_type,
1513: x_td_salvage_value OUT NOCOPY fa_amort_pvt.tab_num_type,
1514: x_td_deprn_limit_amount OUT NOCOPY fa_amort_pvt.tab_num_type,
1515: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1516: x_asset_fin_rec_reclass OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1517: p_mrc_sob_type_code VARCHAR2
1518: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)return BOOLEAN IS
1519:
1520: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.buildMemberTable';

Line 1518: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)return BOOLEAN IS

1514: x_td_deprn_limit_amount OUT NOCOPY fa_amort_pvt.tab_num_type,
1515: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1516: x_asset_fin_rec_reclass OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1517: p_mrc_sob_type_code VARCHAR2
1518: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)return BOOLEAN IS
1519:
1520: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.buildMemberTable';
1521:
1522: --

Line 1764: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

1760: l_sal_thid NUMBER(15) := 0;
1761: l_limit_thid NUMBER(15) := 0;
1762:
1763: -- Bug4958977: Adding following 4 new variables
1764: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1765: l_period_counter NUMBER;
1766: bld_err EXCEPTION;
1767: l_cur_trx_period_counter NUMBER;
1768:

Line 2538: p_trans_rec FA_API_TYPES.trans_rec_type,

2534: --
2535: --
2536: --+==============================================================================
2537: FUNCTION CurrentPeriodAdj(
2538: p_trans_rec FA_API_TYPES.trans_rec_type,
2539: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
2540: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2541: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2542: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,

Line 2539: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

2535: --
2536: --+==============================================================================
2537: FUNCTION CurrentPeriodAdj(
2538: p_trans_rec FA_API_TYPES.trans_rec_type,
2539: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
2540: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2541: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2542: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2543: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 2540: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,

2536: --+==============================================================================
2537: FUNCTION CurrentPeriodAdj(
2538: p_trans_rec FA_API_TYPES.trans_rec_type,
2539: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
2540: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2541: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2542: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2543: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2544: p_period_rec FA_API_TYPES.period_rec_type,

Line 2541: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,

2537: FUNCTION CurrentPeriodAdj(
2538: p_trans_rec FA_API_TYPES.trans_rec_type,
2539: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
2540: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2541: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2542: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2543: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2544: p_period_rec FA_API_TYPES.period_rec_type,
2545: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,

Line 2542: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,

2538: p_trans_rec FA_API_TYPES.trans_rec_type,
2539: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
2540: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2541: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2542: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2543: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2544: p_period_rec FA_API_TYPES.period_rec_type,
2545: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
2546: p_proceeds_of_sale NUMBER default 0,

Line 2543: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

2539: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
2540: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2541: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2542: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2543: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2544: p_period_rec FA_API_TYPES.period_rec_type,
2545: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
2546: p_proceeds_of_sale NUMBER default 0,
2547: p_cost_of_removal NUMBER default 0,

Line 2544: p_period_rec FA_API_TYPES.period_rec_type,

2540: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
2541: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2542: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2543: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2544: p_period_rec FA_API_TYPES.period_rec_type,
2545: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
2546: p_proceeds_of_sale NUMBER default 0,
2547: p_cost_of_removal NUMBER default 0,
2548: p_calling_fn VARCHAR2,

Line 2545: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,

2541: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
2542: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
2543: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2544: p_period_rec FA_API_TYPES.period_rec_type,
2545: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
2546: p_proceeds_of_sale NUMBER default 0,
2547: p_cost_of_removal NUMBER default 0,
2548: p_calling_fn VARCHAR2,
2549: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

Line 2549: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

2545: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
2546: p_proceeds_of_sale NUMBER default 0,
2547: p_cost_of_removal NUMBER default 0,
2548: p_calling_fn VARCHAR2,
2549: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
2550: return BOOLEAN is
2551:
2552: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.CurrentPeriodAdj';
2553:

Line 3148: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

3144: -- 3.3: Call Deprn Basis function to get new adjusted_cost, raf and formula_factor.
3145: -- 4: Return catch-up amount.
3146: --+==============================================================================
3147: FUNCTION bsRecalculate(
3148: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
3149: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3150: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3151: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3152: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,

Line 3149: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

3145: -- 4: Return catch-up amount.
3146: --+==============================================================================
3147: FUNCTION bsRecalculate(
3148: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
3149: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3150: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3151: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3152: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3153: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,

Line 3150: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,

3146: --+==============================================================================
3147: FUNCTION bsRecalculate(
3148: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
3149: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3150: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3151: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3152: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3153: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3154: p_period_rec FA_API_TYPES.period_rec_type,

Line 3151: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,

3147: FUNCTION bsRecalculate(
3148: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
3149: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3150: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3151: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3152: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3153: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3154: p_period_rec FA_API_TYPES.period_rec_type,
3155: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 3152: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,

3148: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
3149: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3150: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3151: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3152: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3153: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3154: p_period_rec FA_API_TYPES.period_rec_type,
3155: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3156: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,

Line 3153: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,

3149: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3150: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3151: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3152: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3153: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3154: p_period_rec FA_API_TYPES.period_rec_type,
3155: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3156: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
3157: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,

Line 3154: p_period_rec FA_API_TYPES.period_rec_type,

3150: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
3151: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3152: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3153: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3154: p_period_rec FA_API_TYPES.period_rec_type,
3155: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3156: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
3157: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
3158: x_deprn_expense OUT NOCOPY NUMBER,

Line 3155: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

3151: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
3152: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3153: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3154: p_period_rec FA_API_TYPES.period_rec_type,
3155: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3156: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
3157: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
3158: x_deprn_expense OUT NOCOPY NUMBER,
3159: x_bonus_expense OUT NOCOPY NUMBER,

Line 3156: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,

3152: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
3153: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3154: p_period_rec FA_API_TYPES.period_rec_type,
3155: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3156: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
3157: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
3158: x_deprn_expense OUT NOCOPY NUMBER,
3159: x_bonus_expense OUT NOCOPY NUMBER,
3160: x_impairment_expense OUT NOCOPY NUMBER,

Line 3157: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,

3153: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
3154: p_period_rec FA_API_TYPES.period_rec_type,
3155: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3156: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
3157: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
3158: x_deprn_expense OUT NOCOPY NUMBER,
3159: x_bonus_expense OUT NOCOPY NUMBER,
3160: x_impairment_expense OUT NOCOPY NUMBER,
3161: x_deprn_reserve OUT NOCOPY NUMBER,

Line 3169: p_calling_fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

3165: p_reclass_src_dest VARCHAR2,
3166: p_reclassed_asset_dpis DATE,
3167: p_update_books_summary BOOLEAN default FALSE,
3168: p_mrc_sob_type_code VARCHAR2,
3169: p_calling_fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3170:
3171: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.bsRecalculate';
3172:
3173: --

Line 3450: l_period_rec FA_API_TYPES.period_rec_type; -- Store period information of

3446:
3447: l_mem_trx BOOLEAN := FALSE; -- FALSE if this is group trx
3448: l_temp_num NUMBER; -- temporary numbers for calculation
3449:
3450: l_period_rec FA_API_TYPES.period_rec_type; -- Store period information of
3451: -- the period where trx date
3452: -- falls into
3453: -- the period where trx date
3454: -- falls into, then

Line 3457: l_trx_period_rec FA_API_TYPES.period_rec_type; -- Store period information of

3453: -- the period where trx date
3454: -- falls into, then
3455: -- store period info for
3456: -- each period processed.
3457: l_trx_period_rec FA_API_TYPES.period_rec_type; -- Store period information of
3458: -- the period where trx date
3459: -- falls into
3460:
3461: l_ind BINARY_INTEGER; -- Used to find delta amounts for each period

Line 3493: l_trans_rec FA_API_TYPES.trans_rec_type; -- Not used

3489: l_adjusted_ind BINARY_INTEGER;
3490: l_count BINARY_INTEGER := 0; -- Stores count of tbs tables
3491:
3492: --+++++ Store data related to each transactions +++++
3493: l_trans_rec FA_API_TYPES.trans_rec_type; -- Not used
3494: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3495: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3496: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis
3497: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

Line 3494: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis

3490: l_count BINARY_INTEGER := 0; -- Stores count of tbs tables
3491:
3492: --+++++ Store data related to each transactions +++++
3493: l_trans_rec FA_API_TYPES.trans_rec_type; -- Not used
3494: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3495: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3496: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis
3497: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3498:

Line 3495: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis

3491:
3492: --+++++ Store data related to each transactions +++++
3493: l_trans_rec FA_API_TYPES.trans_rec_type; -- Not used
3494: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3495: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3496: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis
3497: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3498:
3499: --+++++ Variables for calling buildMemberTable function +++++

Line 3496: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis

3492: --+++++ Store data related to each transactions +++++
3493: l_trans_rec FA_API_TYPES.trans_rec_type; -- Not used
3494: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3495: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3496: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis
3497: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3498:
3499: --+++++ Variables for calling buildMemberTable function +++++
3500: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type; -- Store member info

Line 3497: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

3493: l_trans_rec FA_API_TYPES.trans_rec_type; -- Not used
3494: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3495: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type; -- For Deprn Basis
3496: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis
3497: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3498:
3499: --+++++ Variables for calling buildMemberTable function +++++
3500: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type; -- Store member info
3501: t_period_counter fa_amort_pvt.tab_num15_type;

Line 3500: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type; -- Store member info

3496: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type; -- For Deprn Basis
3497: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3498:
3499: --+++++ Variables for calling buildMemberTable function +++++
3500: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type; -- Store member info
3501: t_period_counter fa_amort_pvt.tab_num15_type;
3502: t_delta_cost fa_amort_pvt.tab_num_type;
3503: t_delta_cip_cost fa_amort_pvt.tab_num_type;
3504: t_delta_salvage_value fa_amort_pvt.tab_num_type;

Line 3508: l_m_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type; -- member's delta info

3504: t_delta_salvage_value fa_amort_pvt.tab_num_type;
3505: t_delta_deprn_limit_amount fa_amort_pvt.tab_num_type;
3506: l_member_dpis DATE;
3507: l_multiplier NUMBER := 1;
3508: l_m_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type; -- member's delta info
3509: l_asset_fin_rec_reclass FA_API_TYPES.asset_fin_rec_type; -- correct fin rec adj for
3510: l_salvage_limit_type VARCHAR2(30);
3511: -- reclass
3512:

Line 3509: l_asset_fin_rec_reclass FA_API_TYPES.asset_fin_rec_type; -- correct fin rec adj for

3505: t_delta_deprn_limit_amount fa_amort_pvt.tab_num_type;
3506: l_member_dpis DATE;
3507: l_multiplier NUMBER := 1;
3508: l_m_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type; -- member's delta info
3509: l_asset_fin_rec_reclass FA_API_TYPES.asset_fin_rec_type; -- correct fin rec adj for
3510: l_salvage_limit_type VARCHAR2(30);
3511: -- reclass
3512:
3513: --+++++ Variables for CURSOR c_get_rein_info +++++

Line 3562: l_gr_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Reclass

3558: --++++++++ variables for calling catchupBooksSummary ++++++++
3559: l_depreciate_flag_change BOOLEAN := FALSE;
3560: l_disabled_flag_change BOOLEAN := FALSE;
3561:
3562: l_gr_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; -- For Reclass
3563: l_gr_ind BINARY_INTEGER;
3564:
3565: --+ HHIRAGA added on Oct/Nov in 2003
3566: --++++++++ variables for Trackking Member Feature ++++++++

Line 6914: p_trans_rec FA_API_TYPES.trans_rec_type,

6910: -- This procedure popualte asset_fin_rec_adj in case it is not provided.
6911: --
6912: --+==============================================================================
6913: PROCEDURE populate_fin_rec(
6914: p_trans_rec FA_API_TYPES.trans_rec_type,
6915: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
6916: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
6917: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
6918: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

Line 6915: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,

6911: --
6912: --+==============================================================================
6913: PROCEDURE populate_fin_rec(
6914: p_trans_rec FA_API_TYPES.trans_rec_type,
6915: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
6916: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
6917: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
6918: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
6919:

Line 6916: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,

6912: --+==============================================================================
6913: PROCEDURE populate_fin_rec(
6914: p_trans_rec FA_API_TYPES.trans_rec_type,
6915: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
6916: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
6917: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
6918: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
6919:
6920: BEGIN

Line 6917: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,

6913: PROCEDURE populate_fin_rec(
6914: p_trans_rec FA_API_TYPES.trans_rec_type,
6915: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
6916: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
6917: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
6918: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
6919:
6920: BEGIN
6921: /*

Line 6918: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

6914: p_trans_rec FA_API_TYPES.trans_rec_type,
6915: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
6916: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
6917: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
6918: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
6919:
6920: BEGIN
6921: /*
6922: if (nvl(p_asset_fin_rec_old.cost, 0) = nvl(p_asset_fin_rec_new.cost, 0) and

Line 7129: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

7125:
7126: ---------------------------------------------------------------------------
7127:
7128: FUNCTION faxama
7129: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7130: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7131: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7132: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7133: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,

Line 7130: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

7126: ---------------------------------------------------------------------------
7127:
7128: FUNCTION faxama
7129: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7130: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7131: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7132: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7133: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7134: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,

Line 7131: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,

7127:
7128: FUNCTION faxama
7129: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7130: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7131: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7132: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7133: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7134: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7135: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,

Line 7132: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,

7128: FUNCTION faxama
7129: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7130: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7131: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7132: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7133: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7134: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7135: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7136: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 7133: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,

7129: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7130: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7131: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7132: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7133: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7134: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7135: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7136: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7137: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,

Line 7134: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,

7130: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7131: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7132: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7133: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7134: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7135: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7136: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7137: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7138: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,

Line 7135: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,

7131: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
7132: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7133: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7134: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7135: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7136: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7137: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7138: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
7139: p_period_rec FA_API_TYPES.period_rec_type,

Line 7136: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

7132: p_asset_cat_rec FA_API_TYPES.asset_cat_rec_type,
7133: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7134: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7135: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7136: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7137: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7138: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
7139: p_period_rec FA_API_TYPES.period_rec_type,
7140: p_mrc_sob_type_code VARCHAR2,

Line 7137: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,

7133: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
7134: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7135: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7136: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7137: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7138: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
7139: p_period_rec FA_API_TYPES.period_rec_type,
7140: p_mrc_sob_type_code VARCHAR2,
7141: p_running_mode NUMBER,

Line 7138: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,

7134: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
7135: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7136: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7137: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7138: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
7139: p_period_rec FA_API_TYPES.period_rec_type,
7140: p_mrc_sob_type_code VARCHAR2,
7141: p_running_mode NUMBER,
7142: p_used_by_revaluation NUMBER,

Line 7139: p_period_rec FA_API_TYPES.period_rec_type,

7135: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
7136: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7137: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
7138: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
7139: p_period_rec FA_API_TYPES.period_rec_type,
7140: p_mrc_sob_type_code VARCHAR2,
7141: p_running_mode NUMBER,
7142: p_used_by_revaluation NUMBER,
7143: p_reclassed_asset_id NUMBER default null,

Line 7153: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

7149: x_deprn_exp OUT NOCOPY NUMBER,
7150: x_bonus_deprn_exp OUT NOCOPY NUMBER,
7151: x_impairment_exp OUT NOCOPY NUMBER,
7152: x_deprn_rsv OUT NOCOPY NUMBER
7153: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
7154:
7155: l_calling_fn varchar2(50) := 'newFA_AMORT_PVT.faxama';
7156: l_reval_deprn_rsv_adj number :=0;
7157: l_afn_zero number:=0;

Line 7159: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

7155: l_calling_fn varchar2(50) := 'newFA_AMORT_PVT.faxama';
7156: l_reval_deprn_rsv_adj number :=0;
7157: l_afn_zero number:=0;
7158:
7159: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
7160:
7161: -- Bug4958977: Adding following cursor and 2 new variables
7162: CURSOR c_check_dpis_change is
7163: select inbk.transaction_header_id_in

Line 7537: p_trans_rec FA_API_TYPES.trans_rec_type,

7533: -- Unplanned Depreciation UA or UE
7534: --
7535: --+==============================================================================
7536: FUNCTION GetExpRsv(
7537: p_trans_rec FA_API_TYPES.trans_rec_type,
7538: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7539: p_period_rec FA_API_TYPES.period_rec_type,
7540: p_mrc_sob_type_code VARCHAR2,
7541: x_exp_rsv_amount OUT NOCOPY NUMBER

Line 7538: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

7534: --
7535: --+==============================================================================
7536: FUNCTION GetExpRsv(
7537: p_trans_rec FA_API_TYPES.trans_rec_type,
7538: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7539: p_period_rec FA_API_TYPES.period_rec_type,
7540: p_mrc_sob_type_code VARCHAR2,
7541: x_exp_rsv_amount OUT NOCOPY NUMBER
7542: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS

Line 7539: p_period_rec FA_API_TYPES.period_rec_type,

7535: --+==============================================================================
7536: FUNCTION GetExpRsv(
7537: p_trans_rec FA_API_TYPES.trans_rec_type,
7538: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7539: p_period_rec FA_API_TYPES.period_rec_type,
7540: p_mrc_sob_type_code VARCHAR2,
7541: x_exp_rsv_amount OUT NOCOPY NUMBER
7542: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
7543:

Line 7542: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS

7538: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7539: p_period_rec FA_API_TYPES.period_rec_type,
7540: p_mrc_sob_type_code VARCHAR2,
7541: x_exp_rsv_amount OUT NOCOPY NUMBER
7542: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
7543:
7544: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.GetExpRsv';
7545:
7546: --

Line 7618: -- The function returns FA_API_TYPES.asset_deprn_rec_type.

7614:
7615: --+==============================================================================
7616: -- Function: GetDeprnRec
7617: --
7618: -- The function returns FA_API_TYPES.asset_deprn_rec_type.
7619: -- This will be the starting point for recalculating depreciation.
7620: --
7621: --+==============================================================================
7622: FUNCTION GetDeprnRec (

Line 7623: p_trans_rec FA_API_TYPES.trans_rec_type,

7619: -- This will be the starting point for recalculating depreciation.
7620: --
7621: --+==============================================================================
7622: FUNCTION GetDeprnRec (
7623: p_trans_rec FA_API_TYPES.trans_rec_type,
7624: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7625: p_period_rec FA_API_TYPES.period_rec_type,
7626: p_incoming_trx_type_code VARCHAR2 default 'NULL',
7627: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

Line 7624: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

7620: --
7621: --+==============================================================================
7622: FUNCTION GetDeprnRec (
7623: p_trans_rec FA_API_TYPES.trans_rec_type,
7624: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7625: p_period_rec FA_API_TYPES.period_rec_type,
7626: p_incoming_trx_type_code VARCHAR2 default 'NULL',
7627: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
7628: p_mrc_sob_type_code VARCHAR2,

Line 7625: p_period_rec FA_API_TYPES.period_rec_type,

7621: --+==============================================================================
7622: FUNCTION GetDeprnRec (
7623: p_trans_rec FA_API_TYPES.trans_rec_type,
7624: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7625: p_period_rec FA_API_TYPES.period_rec_type,
7626: p_incoming_trx_type_code VARCHAR2 default 'NULL',
7627: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
7628: p_mrc_sob_type_code VARCHAR2,
7629: p_unplanned_exp IN OUT NOCOPY NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

Line 7627: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

7623: p_trans_rec FA_API_TYPES.trans_rec_type,
7624: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
7625: p_period_rec FA_API_TYPES.period_rec_type,
7626: p_incoming_trx_type_code VARCHAR2 default 'NULL',
7627: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
7628: p_mrc_sob_type_code VARCHAR2,
7629: p_unplanned_exp IN OUT NOCOPY NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
7630:
7631: CURSOR c_check_period IS

Line 7629: p_unplanned_exp IN OUT NOCOPY NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

7625: p_period_rec FA_API_TYPES.period_rec_type,
7626: p_incoming_trx_type_code VARCHAR2 default 'NULL',
7627: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
7628: p_mrc_sob_type_code VARCHAR2,
7629: p_unplanned_exp IN OUT NOCOPY NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
7630:
7631: CURSOR c_check_period IS
7632: select 'Y'
7633: from fa_deprn_summary

Line 8165: p_trans_rec FA_API_TYPES.trans_rec_type,

8161: -- Function: GetEofyReserve
8162: --
8163: --+==============================================================================
8164: FUNCTION GetEofyReserve(
8165: p_trans_rec FA_API_TYPES.trans_rec_type,
8166: p_trans_rec_cur FA_API_TYPES.trans_rec_type,
8167: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8168: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8169: p_period_rec FA_API_TYPES.period_rec_type,

Line 8166: p_trans_rec_cur FA_API_TYPES.trans_rec_type,

8162: --
8163: --+==============================================================================
8164: FUNCTION GetEofyReserve(
8165: p_trans_rec FA_API_TYPES.trans_rec_type,
8166: p_trans_rec_cur FA_API_TYPES.trans_rec_type,
8167: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8168: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8169: p_period_rec FA_API_TYPES.period_rec_type,
8170: x_eofy_reserve OUT NOCOPY NUMBER,

Line 8167: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

8163: --+==============================================================================
8164: FUNCTION GetEofyReserve(
8165: p_trans_rec FA_API_TYPES.trans_rec_type,
8166: p_trans_rec_cur FA_API_TYPES.trans_rec_type,
8167: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8168: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8169: p_period_rec FA_API_TYPES.period_rec_type,
8170: x_eofy_reserve OUT NOCOPY NUMBER,
8171: x_transaction_header_id OUT NOCOPY NUMBER,

Line 8168: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,

8164: FUNCTION GetEofyReserve(
8165: p_trans_rec FA_API_TYPES.trans_rec_type,
8166: p_trans_rec_cur FA_API_TYPES.trans_rec_type,
8167: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8168: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8169: p_period_rec FA_API_TYPES.period_rec_type,
8170: x_eofy_reserve OUT NOCOPY NUMBER,
8171: x_transaction_header_id OUT NOCOPY NUMBER,
8172: x_transaction_date_entered OUT NOCOPY DATE,

Line 8169: p_period_rec FA_API_TYPES.period_rec_type,

8165: p_trans_rec FA_API_TYPES.trans_rec_type,
8166: p_trans_rec_cur FA_API_TYPES.trans_rec_type,
8167: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8168: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8169: p_period_rec FA_API_TYPES.period_rec_type,
8170: x_eofy_reserve OUT NOCOPY NUMBER,
8171: x_transaction_header_id OUT NOCOPY NUMBER,
8172: x_transaction_date_entered OUT NOCOPY DATE,
8173: x_date_effective OUT NOCOPY DATE,

Line 8176: p_calling_fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS

8172: x_transaction_date_entered OUT NOCOPY DATE,
8173: x_date_effective OUT NOCOPY DATE,
8174: x_transaction_type_code OUT NOCOPY VARCHAR2,
8175: p_mrc_sob_type_code VARCHAR2,
8176: p_calling_fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
8177:
8178: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.GetEofyReserve';
8179: get_err EXCEPTION;
8180:

Line 8399: l_period_rec FA_API_TYPES.period_rec_type;

8395: l_transaction_date_entered DATE;
8396: l_date_effective DATE;
8397: l_transaction_type_code VARCHAR2(30);
8398:
8399: l_period_rec FA_API_TYPES.period_rec_type;
8400: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
8401:
8402: l_unplanned_exp NUMBER := 0;
8403: l_reserve_retired NUMBER := 0;

Line 8400: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

8396: l_date_effective DATE;
8397: l_transaction_type_code VARCHAR2(30);
8398:
8399: l_period_rec FA_API_TYPES.period_rec_type;
8400: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
8401:
8402: l_unplanned_exp NUMBER := 0;
8403: l_reserve_retired NUMBER := 0;
8404: l_eofy_reserve_retired NUMBER := 0;

Line 8579: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

8575: --
8576: --
8577: --+==============================================================================
8578: FUNCTION GetFinAdjRec(
8579: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8580: p_reclass_src_dest VARCHAR2,
8581: p_transaction_date_entered DATE,
8582: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8583: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

Line 8582: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

8578: FUNCTION GetFinAdjRec(
8579: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8580: p_reclass_src_dest VARCHAR2,
8581: p_transaction_date_entered DATE,
8582: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8583: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
8584: return BOOLEAN is
8585:
8586: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.GetFinAdjRec';

Line 8583: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

8579: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8580: p_reclass_src_dest VARCHAR2,
8581: p_transaction_date_entered DATE,
8582: x_asset_fin_rec_adj OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8583: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
8584: return BOOLEAN is
8585:
8586: l_calling_fn VARCHAR2(50) := 'FA_AMORT_PVT.GetFinAdjRec';
8587: get_err EXCEPTION;

Line 8766: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

8762: --
8763: --
8764: --+==============================================================================
8765: FUNCTION GetFinRec(
8766: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8767: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8768: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8769: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8770: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,

Line 8767: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

8763: --
8764: --+==============================================================================
8765: FUNCTION GetFinRec(
8766: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8767: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8768: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8769: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8770: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8771: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,

Line 8768: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,

8764: --+==============================================================================
8765: FUNCTION GetFinRec(
8766: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8767: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8768: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8769: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8770: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8771: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8772: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 8769: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

8765: FUNCTION GetFinRec(
8766: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8767: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8768: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8769: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8770: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8771: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8772: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8773: p_init_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE,

Line 8770: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,

8766: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8767: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8768: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8769: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8770: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8771: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8772: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8773: p_init_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE,
8774: p_use_fin_rec_adj BOOLEAN,

Line 8771: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,

8767: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
8768: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8769: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8770: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8771: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8772: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8773: p_init_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE,
8774: p_use_fin_rec_adj BOOLEAN,
8775: p_use_new_deprn_rule BOOLEAN,

Line 8772: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

8768: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
8769: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8770: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8771: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8772: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8773: p_init_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE,
8774: p_use_fin_rec_adj BOOLEAN,
8775: p_use_new_deprn_rule BOOLEAN,
8776: p_process_this_trx BOOLEAN,

Line 8779: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

8775: p_use_new_deprn_rule BOOLEAN,
8776: p_process_this_trx BOOLEAN,
8777: x_dpis_change OUT NOCOPY BOOLEAN,
8778: p_mrc_sob_type_code VARCHAR2
8779: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
8780: ) return BOOLEAN IS
8781:
8782: Cursor c_get_init_bk IS
8783: select date_placed_in_service

Line 10016: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

10012: from fa_transaction_headers
10013: where transaction_header_id = p_trans_rec.member_transaction_header_id;
10014:
10015: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.GetFinRec';
10016: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
10017: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10018: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10019: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
10020: l_period_rec FA_API_TYPES.period_rec_type;

Line 10017: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

10013: where transaction_header_id = p_trans_rec.member_transaction_header_id;
10014:
10015: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.GetFinRec';
10016: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
10017: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10018: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10019: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
10020: l_period_rec FA_API_TYPES.period_rec_type;
10021:

Line 10018: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

10014:
10015: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.GetFinRec';
10016: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
10017: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10018: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10019: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
10020: l_period_rec FA_API_TYPES.period_rec_type;
10021:
10022: l_is_member_trx_for_group BOOLEAN := FALSE;

Line 10019: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

10015: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.GetFinRec';
10016: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
10017: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10018: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10019: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
10020: l_period_rec FA_API_TYPES.period_rec_type;
10021:
10022: l_is_member_trx_for_group BOOLEAN := FALSE;
10023: l_asset_id NUMBER;

Line 10020: l_period_rec FA_API_TYPES.period_rec_type;

10016: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
10017: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10018: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10019: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
10020: l_period_rec FA_API_TYPES.period_rec_type;
10021:
10022: l_is_member_trx_for_group BOOLEAN := FALSE;
10023: l_asset_id NUMBER;
10024: l_transaction_header_id NUMBER;

Line 11579: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

11575: -- NOTE: Retirement which has been reinstated will not be processed at all.
11576: -- 4: Return catch-up amount.
11577: --+==============================================================================
11578: FUNCTION Recalculate(
11579: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
11580: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
11581: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11582: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11583: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,

Line 11580: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,

11576: -- 4: Return catch-up amount.
11577: --+==============================================================================
11578: FUNCTION Recalculate(
11579: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
11580: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
11581: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11582: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11583: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11584: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,

Line 11581: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,

11577: --+==============================================================================
11578: FUNCTION Recalculate(
11579: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
11580: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
11581: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11582: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11583: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11584: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11585: p_period_rec FA_API_TYPES.period_rec_type,

Line 11582: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,

11578: FUNCTION Recalculate(
11579: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
11580: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
11581: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11582: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11583: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11584: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11585: p_period_rec FA_API_TYPES.period_rec_type,
11586: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 11583: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,

11579: p_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
11580: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
11581: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11582: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11583: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11584: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11585: p_period_rec FA_API_TYPES.period_rec_type,
11586: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11587: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,

Line 11584: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,

11580: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
11581: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11582: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11583: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11584: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11585: p_period_rec FA_API_TYPES.period_rec_type,
11586: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11587: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11588: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,

Line 11585: p_period_rec FA_API_TYPES.period_rec_type,

11581: p_asset_type_rec FA_API_TYPES.asset_type_rec_type,
11582: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11583: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11584: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11585: p_period_rec FA_API_TYPES.period_rec_type,
11586: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11587: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11588: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11589: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,

Line 11586: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

11582: p_asset_desc_rec FA_API_TYPES.asset_desc_rec_type,
11583: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11584: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11585: p_period_rec FA_API_TYPES.period_rec_type,
11586: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11587: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11588: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11589: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,
11590: x_bonus_expense OUT NOCOPY FA_DEPRN_SUMMARY.BONUS_DEPRN_AMOUNT%TYPE,

Line 11587: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,

11583: p_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type,
11584: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11585: p_period_rec FA_API_TYPES.period_rec_type,
11586: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11587: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11588: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11589: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,
11590: x_bonus_expense OUT NOCOPY FA_DEPRN_SUMMARY.BONUS_DEPRN_AMOUNT%TYPE,
11591: x_impairment_expense OUT NOCOPY FA_DEPRN_SUMMARY.IMPAIRMENT_AMOUNT%TYPE,

Line 11588: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,

11584: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type default null,
11585: p_period_rec FA_API_TYPES.period_rec_type,
11586: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11587: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11588: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11589: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,
11590: x_bonus_expense OUT NOCOPY FA_DEPRN_SUMMARY.BONUS_DEPRN_AMOUNT%TYPE,
11591: x_impairment_expense OUT NOCOPY FA_DEPRN_SUMMARY.IMPAIRMENT_AMOUNT%TYPE,
11592: p_running_mode IN NUMBER,

Line 11600: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

11596: p_reclassed_asset_dpis DATE,
11597: p_source_transaction_type_code VARCHAR2,
11598: p_mrc_sob_type_code VARCHAR2,
11599: p_calling_fn VARCHAR2
11600: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
11601: ) RETURN BOOLEAN IS
11602:
11603: l_calling_fn VARCHAR2(100) := 'FA_AMORT_CALC_PVT.Recalculate';
11604:

Line 12437: l_override_limit_period_rec FA_API_TYPES.period_rec_type;

12433: and ret.retirement_prorate_convention = con.prorate_convention_code
12434: and ret.date_retired between con.start_date and con.end_date;
12435:
12436: l_override_limit_date date;
12437: l_override_limit_period_rec FA_API_TYPES.period_rec_type;
12438:
12439: --++++++++++++++++++ Table types ++++++++++++++++++
12440: TYPE tab_date_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
12441: TYPE tab_num_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 12479: l_trans_rec FA_API_TYPES.trans_rec_type;

12475:
12476: l_row_count NUMBER := 0;
12477:
12478: --+++++ Store data related to each transactions +++++
12479: l_trans_rec FA_API_TYPES.trans_rec_type;
12480: l_invoice_transaction_id NUMBER;
12481: l_period_rec FA_API_TYPES.period_rec_type;
12482: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12483: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;

Line 12481: l_period_rec FA_API_TYPES.period_rec_type;

12477:
12478: --+++++ Store data related to each transactions +++++
12479: l_trans_rec FA_API_TYPES.trans_rec_type;
12480: l_invoice_transaction_id NUMBER;
12481: l_period_rec FA_API_TYPES.period_rec_type;
12482: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12483: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
12484: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
12485: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

Line 12482: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

12478: --+++++ Store data related to each transactions +++++
12479: l_trans_rec FA_API_TYPES.trans_rec_type;
12480: l_invoice_transaction_id NUMBER;
12481: l_period_rec FA_API_TYPES.period_rec_type;
12482: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12483: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
12484: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
12485: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12486: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

Line 12483: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;

12479: l_trans_rec FA_API_TYPES.trans_rec_type;
12480: l_invoice_transaction_id NUMBER;
12481: l_period_rec FA_API_TYPES.period_rec_type;
12482: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12483: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
12484: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
12485: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12486: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12487: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 12484: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;

12480: l_invoice_transaction_id NUMBER;
12481: l_period_rec FA_API_TYPES.period_rec_type;
12482: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12483: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
12484: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
12485: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12486: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12487: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
12488:

Line 12485: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

12481: l_period_rec FA_API_TYPES.period_rec_type;
12482: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12483: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
12484: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
12485: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12486: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12487: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
12488:
12489: l_least_thid number(15); -- Stored least transaction_header_id

Line 12486: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

12482: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12483: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
12484: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
12485: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12486: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12487: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
12488:
12489: l_least_thid number(15); -- Stored least transaction_header_id
12490: -- to find starting fa_books record

Line 12487: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

12483: l_asset_deprn_rec_raf FA_API_TYPES.asset_deprn_rec_type;
12484: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
12485: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12486: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12487: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
12488:
12489: l_least_thid number(15); -- Stored least transaction_header_id
12490: -- to find starting fa_books record
12491: l_member_asset_id number(15) := to_number(null); -- Store member asset id

Line 12493: l_member_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

12489: l_least_thid number(15); -- Stored least transaction_header_id
12490: -- to find starting fa_books record
12491: l_member_asset_id number(15) := to_number(null); -- Store member asset id
12492: l_member_trx_key varchar2(2); -- member transaction key
12493: l_member_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12494: l_next_period_rec FA_API_TYPES.period_rec_type;
12495: l_transaction_type_code varchar2(30); -- Used to find reinstatement
12496:
12497: l_temp_period_counter number(15); -- This is to store period counter because GetDeprnRec needs

Line 12494: l_next_period_rec FA_API_TYPES.period_rec_type;

12490: -- to find starting fa_books record
12491: l_member_asset_id number(15) := to_number(null); -- Store member asset id
12492: l_member_trx_key varchar2(2); -- member transaction key
12493: l_member_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12494: l_next_period_rec FA_API_TYPES.period_rec_type;
12495: l_transaction_type_code varchar2(30); -- Used to find reinstatement
12496:
12497: l_temp_period_counter number(15); -- This is to store period counter because GetDeprnRec needs
12498: -- period counter = period_counter - 1

Line 12636: l_catchup_begin_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

12632: l_start_from_first BOOLEAN := TRUE;
12633:
12634: -- Bug PKO
12635: l_retirement_thid NUMBER := -1;
12636: l_catchup_begin_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12637: l_temp_reserve NUMBER;
12638:
12639: l_cost_frac NUMBER; -- Bug 5893429
12640:

Line 15448: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

15444:
15445: ---------------------------------------------------------------------------
15446:
15447: FUNCTION faxama
15448: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15449: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15450: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15451: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15452: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

Line 15449: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

15445: ---------------------------------------------------------------------------
15446:
15447: FUNCTION faxama
15448: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15449: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15450: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15451: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15452: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15453: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,

Line 15450: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

15446:
15447: FUNCTION faxama
15448: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15449: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15450: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15451: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15452: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15453: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15454: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,

Line 15451: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

15447: FUNCTION faxama
15448: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15449: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15450: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15451: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15452: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15453: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15454: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
15455: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 15452: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

15448: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15449: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15450: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15451: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15452: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15453: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15454: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
15455: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15456: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,

Line 15453: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,

15449: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15450: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15451: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15452: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15453: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15454: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
15455: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15456: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
15457: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,

Line 15454: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,

15450: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15451: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15452: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15453: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15454: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
15455: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15456: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
15457: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
15458: p_period_rec IN FA_API_TYPES.period_rec_type,

Line 15455: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

15451: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15452: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15453: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15454: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
15455: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15456: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
15457: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
15458: p_period_rec IN FA_API_TYPES.period_rec_type,
15459: p_mrc_sob_type_code IN VARCHAR2,

Line 15456: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,

15452: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15453: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15454: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
15455: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15456: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
15457: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
15458: p_period_rec IN FA_API_TYPES.period_rec_type,
15459: p_mrc_sob_type_code IN VARCHAR2,
15460: p_running_mode IN NUMBER,

Line 15457: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,

15453: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15454: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
15455: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15456: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
15457: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
15458: p_period_rec IN FA_API_TYPES.period_rec_type,
15459: p_mrc_sob_type_code IN VARCHAR2,
15460: p_running_mode IN NUMBER,
15461: p_used_by_revaluation IN NUMBER,

Line 15458: p_period_rec IN FA_API_TYPES.period_rec_type,

15454: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
15455: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15456: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
15457: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
15458: p_period_rec IN FA_API_TYPES.period_rec_type,
15459: p_mrc_sob_type_code IN VARCHAR2,
15460: p_running_mode IN NUMBER,
15461: p_used_by_revaluation IN NUMBER,
15462: p_reclassed_asset_id NUMBER default null,

Line 15468: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

15464: p_reclassed_asset_dpis DATE default null,
15465: x_deprn_exp OUT NOCOPY NUMBER,
15466: x_bonus_deprn_exp OUT NOCOPY NUMBER,
15467: x_impairment_exp OUT NOCOPY NUMBER
15468: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
15469:
15470: l_calling_fn varchar2(50) := 'FA_AMORT_PVT.faxama';
15471: l_reval_deprn_rsv_adj number :=0;
15472: l_afn_zero number:=0;

Line 15474: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

15470: l_calling_fn varchar2(50) := 'FA_AMORT_PVT.faxama';
15471: l_reval_deprn_rsv_adj number :=0;
15472: l_afn_zero number:=0;
15473:
15474: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
15475: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type; -- Added to call calc_raf_adj
15476:
15477: calc_err EXCEPTION;
15478:

Line 15475: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type; -- Added to call calc_raf_adj

15471: l_reval_deprn_rsv_adj number :=0;
15472: l_afn_zero number:=0;
15473:
15474: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
15475: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type; -- Added to call calc_raf_adj
15476:
15477: calc_err EXCEPTION;
15478:
15479: /*

Line 15694: FUNCTION get_reserve(px_trans_rec in out nocopy FA_API_TYPES.trans_rec_type,

15690: -- this function will get books row of addition transaction
15691: -- and call faxcde to calculate what the actual reserve is from the
15692: -- prorate period upto right before the amortization period
15693:
15694: FUNCTION get_reserve(px_trans_rec in out nocopy FA_API_TYPES.trans_rec_type,
15695: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
15696: p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type,
15697: px_asset_fin_rec in out nocopy FA_API_TYPES.asset_fin_rec_type,
15698: p_add_txn_id in number,

Line 15695: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,

15691: -- and call faxcde to calculate what the actual reserve is from the
15692: -- prorate period upto right before the amortization period
15693:
15694: FUNCTION get_reserve(px_trans_rec in out nocopy FA_API_TYPES.trans_rec_type,
15695: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
15696: p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type,
15697: px_asset_fin_rec in out nocopy FA_API_TYPES.asset_fin_rec_type,
15698: p_add_txn_id in number,
15699: p_amortize_fy in integer,

Line 15696: p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type,

15692: -- prorate period upto right before the amortization period
15693:
15694: FUNCTION get_reserve(px_trans_rec in out nocopy FA_API_TYPES.trans_rec_type,
15695: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
15696: p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type,
15697: px_asset_fin_rec in out nocopy FA_API_TYPES.asset_fin_rec_type,
15698: p_add_txn_id in number,
15699: p_amortize_fy in integer,
15700: p_amortize_per_num in integer,

Line 15697: px_asset_fin_rec in out nocopy FA_API_TYPES.asset_fin_rec_type,

15693:
15694: FUNCTION get_reserve(px_trans_rec in out nocopy FA_API_TYPES.trans_rec_type,
15695: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
15696: p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type,
15697: px_asset_fin_rec in out nocopy FA_API_TYPES.asset_fin_rec_type,
15698: p_add_txn_id in number,
15699: p_amortize_fy in integer,
15700: p_amortize_per_num in integer,
15701: p_pers_per_yr in integer,

Line 15705: x_impairment_rsv out nocopy number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

15701: p_pers_per_yr in integer,
15702: p_mrc_sob_type_code in varchar2,
15703: x_deprn_rsv out nocopy number,
15704: x_bonus_deprn_rsv out nocopy number,
15705: x_impairment_rsv out nocopy number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
15706: return boolean is
15707:
15708: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
15709: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 15708: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

15704: x_bonus_deprn_rsv out nocopy number,
15705: x_impairment_rsv out nocopy number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
15706: return boolean is
15707:
15708: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
15709: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
15710:
15711: l_dpr_row FA_STD_TYPES.dpr_struct;
15712: l_dpr_arr FA_STD_TYPES.dpr_arr_type;

Line 15709: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

15705: x_impairment_rsv out nocopy number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
15706: return boolean is
15707:
15708: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
15709: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
15710:
15711: l_dpr_row FA_STD_TYPES.dpr_struct;
15712: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
15713: l_dpr_out FA_STD_TYPES.dpr_out_struct;

Line 15881: px_adj_cost in out nocopy number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is

15877: p_rec_cost in number,
15878: p_prior_fy_exp in number,
15879: p_deprn_rsv in number,
15880: p_ytd_deprn in number,
15881: px_adj_cost in out nocopy number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
15882:
15883: l_deprn_basis_formula varchar2(30);
15884: l_rate_source_rule varchar2(10);
15885: l_deprn_basis_rule varchar2(4);

Line 15948: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

15944:
15945: end faxnac;
15946:
15947: FUNCTION faxraf
15948: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15949: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15950: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15951: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15952: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

Line 15949: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

15945: end faxnac;
15946:
15947: FUNCTION faxraf
15948: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15949: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15950: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15951: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15952: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15953: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,

Line 15950: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

15946:
15947: FUNCTION faxraf
15948: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15949: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15950: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15951: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15952: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15953: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15954: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 15951: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

15947: FUNCTION faxraf
15948: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15949: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15950: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15951: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15952: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15953: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15954: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15955: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,

Line 15952: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

15948: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
15949: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15950: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15951: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15952: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15953: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15954: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15955: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
15956: p_period_rec IN FA_API_TYPES.period_rec_type,

Line 15953: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,

15949: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15950: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15951: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15952: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15953: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15954: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15955: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
15956: p_period_rec IN FA_API_TYPES.period_rec_type,
15957: px_deprn_exp IN OUT NOCOPY number,

Line 15954: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

15950: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15951: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15952: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15953: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15954: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15955: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
15956: p_period_rec IN FA_API_TYPES.period_rec_type,
15957: px_deprn_exp IN OUT NOCOPY number,
15958: px_bonus_deprn_exp IN OUT NOCOPY number,

Line 15955: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,

15951: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15952: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15953: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15954: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15955: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
15956: p_period_rec IN FA_API_TYPES.period_rec_type,
15957: px_deprn_exp IN OUT NOCOPY number,
15958: px_bonus_deprn_exp IN OUT NOCOPY number,
15959: px_impairment_exp IN OUT NOCOPY number,

Line 15956: p_period_rec IN FA_API_TYPES.period_rec_type,

15952: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15953: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15954: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15955: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
15956: p_period_rec IN FA_API_TYPES.period_rec_type,
15957: px_deprn_exp IN OUT NOCOPY number,
15958: px_bonus_deprn_exp IN OUT NOCOPY number,
15959: px_impairment_exp IN OUT NOCOPY number,
15960: px_reval_deprn_rsv_adj IN out NOCOPY number,

Line 15964: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

15960: px_reval_deprn_rsv_adj IN out NOCOPY number,
15961: p_mrc_sob_type_code IN VARCHAR2,
15962: p_running_mode IN NUMBER,
15963: p_used_by_revaluation IN NUMBER
15964: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
15965:
15966: l_dpr_row FA_STD_TYPES.dpr_struct;
15967: l_dpr_out FA_STD_TYPES.dpr_out_struct;
15968: l_dpr_arr FA_STD_TYPES.dpr_arr_type;

Line 16737: (p_trans_rec IN FA_API_TYPES.trans_rec_type,

16733: return FALSE;
16734: end faxraf;
16735:
16736: FUNCTION calc_raf_adj_cost
16737: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
16738: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
16739: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16740: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16741: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,

Line 16738: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

16734: end faxraf;
16735:
16736: FUNCTION calc_raf_adj_cost
16737: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
16738: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
16739: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16740: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16741: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16742: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 16739: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

16735:
16736: FUNCTION calc_raf_adj_cost
16737: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
16738: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
16739: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16740: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16741: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16742: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
16743: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,

Line 16740: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

16736: FUNCTION calc_raf_adj_cost
16737: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
16738: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
16739: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16740: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16741: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16742: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
16743: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16744: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,

Line 16741: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,

16737: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
16738: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
16739: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16740: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16741: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16742: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
16743: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16744: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
16745: p_period_rec IN FA_API_TYPES.period_rec_type,

Line 16742: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

16738: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
16739: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16740: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16741: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16742: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
16743: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16744: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
16745: p_period_rec IN FA_API_TYPES.period_rec_type,
16746: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,

Line 16743: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,

16739: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16740: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16741: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16742: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
16743: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16744: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
16745: p_period_rec IN FA_API_TYPES.period_rec_type,
16746: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,
16747: p_mrc_sob_type_code IN VARCHAR2

Line 16744: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,

16740: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16741: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16742: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
16743: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16744: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
16745: p_period_rec IN FA_API_TYPES.period_rec_type,
16746: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,
16747: p_mrc_sob_type_code IN VARCHAR2
16748: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

Line 16745: p_period_rec IN FA_API_TYPES.period_rec_type,

16741: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16742: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
16743: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16744: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
16745: p_period_rec IN FA_API_TYPES.period_rec_type,
16746: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,
16747: p_mrc_sob_type_code IN VARCHAR2
16748: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
16749:

Line 16746: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,

16742: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
16743: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16744: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
16745: p_period_rec IN FA_API_TYPES.period_rec_type,
16746: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,
16747: p_mrc_sob_type_code IN VARCHAR2
16748: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
16749:
16750:

Line 16748: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

16744: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
16745: p_period_rec IN FA_API_TYPES.period_rec_type,
16746: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type default null,
16747: p_mrc_sob_type_code IN VARCHAR2
16748: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
16749:
16750:
16751: l_calling_fn VARCHAR2(50) := 'fa_amort_pvt.calc_raf_adj_cost';
16752:

Line 16798: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

16794: and group_asset_id = p_asset_hdr_rec.asset_id
16795: and asset_id <> group_asset_id
16796: and period_counter = l_recalc_start_period_counter - 1;
16797:
16798: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
16799:
16800: --Bug6988399
16801: Cursor c_year_switch is
16802: select 'N'

Line 17388: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

17384: FUNCTION check_dpis_change (
17385: p_book_type_code VARCHAR2,
17386: p_transaction_header_id NUMBER,
17387: p_group_asset_id NUMBER,
17388: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
17389: x_period_counter_out OUT NOCOPY NUMBER,
17390: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
17391: RETURN BOOLEAN is
17392:

Line 17390: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

17386: p_transaction_header_id NUMBER,
17387: p_group_asset_id NUMBER,
17388: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
17389: x_period_counter_out OUT NOCOPY NUMBER,
17390: p_mrc_sob_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
17391: RETURN BOOLEAN is
17392:
17393: l_calling_fn varchar2(100) := 'FA_AMORT_PVT.check_dpis_change';
17394:

Line 17461: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

17457:
17458: END check_dpis_change;
17459:
17460: FUNCTION check_member_existence (
17461: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
17462: RETURN BOOLEAN is
17463:
17464: l_calling_fn varchar2(100) := 'FA_AMORT_PVT.check_member_existence';
17465: