DBA Data[Home] [Help]

APPS.FA_AMORT_PVT dependencies on FA_STD_TYPES

Line 2846: (fa_cache_pkg.fazccmt_record.rate_source_rule = FA_STD_TYPES.FAD_RSR_PROD) then

2842:
2843: /*
2844: if (nvl(px_asset_fin_rec_new.tracking_method, 'NO TRACK') = 'ALLOCATE') and -- ENERGY
2845: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY
2846: (fa_cache_pkg.fazccmt_record.rate_source_rule = FA_STD_TYPES.FAD_RSR_PROD) then
2847: px_asset_fin_rec_new.adjusted_capacity := nvl(px_asset_fin_rec_new.production_capacity, 0) +
2848: nvl(p_asset_fin_rec_adj.adjusted_capacity, 0);
2849: end if;
2850: */

Line 3523: l_dpr_in FA_STD_TYPES.dpr_struct;

3519: l_recapture_amount NUMBER := 0;
3520:
3521:
3522: --+++++++++++++++ For calling faxcde +++++++++++++++
3523: l_dpr_in FA_STD_TYPES.dpr_struct;
3524: l_dpr_out FA_STD_TYPES.dpr_out_struct;
3525: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
3526: l_running_mode NUMBER;
3527:

Line 3524: l_dpr_out FA_STD_TYPES.dpr_out_struct;

3520:
3521:
3522: --+++++++++++++++ For calling faxcde +++++++++++++++
3523: l_dpr_in FA_STD_TYPES.dpr_struct;
3524: l_dpr_out FA_STD_TYPES.dpr_out_struct;
3525: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
3526: l_running_mode NUMBER;
3527:
3528: --

Line 3525: l_dpr_arr FA_STD_TYPES.dpr_arr_type;

3521:
3522: --+++++++++++++++ For calling faxcde +++++++++++++++
3523: l_dpr_in FA_STD_TYPES.dpr_struct;
3524: l_dpr_out FA_STD_TYPES.dpr_out_struct;
3525: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
3526: l_running_mode NUMBER;
3527:
3528: --
3529: -- These are used to store return values from faxcde which

Line 3652: l_dpr FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;

3648: --section in exception handling for future use.
3649: calc_failed EXCEPTION;
3650: l_adj_amt number; ----- bug# 5768759
3651: /*Bug 8765735 - Start*/
3652: l_dpr FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;
3653: l_run_mode VARCHAR2(20) := 'TRANSACTION';
3654: l_status BOOLEAN;
3655: /*Bug 8765735 - End*/
3656: l_prev_adj_cost_flag boolean := false; --bug#15897249

Line 5573: l_running_mode := fa_std_types.FA_DPR_NORMAL;

5569:
5570: --
5571: -- Not for what-if yet
5572: --
5573: l_running_mode := fa_std_types.FA_DPR_NORMAL;
5574:
5575:
5576: if (not fa_cache_pkg.fazccmt(
5577: fa_amort_pvt.t_deprn_method_code(i),

Line 5615: if (not (nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_PROD)) and

5611: -- If rate source rule is FLAT and depreciable basis is Cost
5612: -- Bug4778244 Added the NVL to avoid condition if(not(null or false)) which will
5613: -- always return NULL in place of FALSE, which is incorrect
5614: -- Bug7487450: Skip hypo reserve calculation if it is UOP
5615: if (not (nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_PROD)) and
5616: (not (nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y')) and /*bug#15897249 */
5617: (not((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
5618: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST) and
5619: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',

Line 5617: (not((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and

5613: -- always return NULL in place of FALSE, which is incorrect
5614: -- Bug7487450: Skip hypo reserve calculation if it is UOP
5615: if (not (nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_PROD)) and
5616: (not (nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y')) and /*bug#15897249 */
5617: (not((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
5618: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST) and
5619: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',
5620: 'PERIOD END AVERAGE',
5621: 'USE RECOVERABLE COST',

Line 5618: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST) and

5614: -- Bug7487450: Skip hypo reserve calculation if it is UOP
5615: if (not (nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_PROD)) and
5616: (not (nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y')) and /*bug#15897249 */
5617: (not((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
5618: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST) and
5619: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',
5620: 'PERIOD END AVERAGE',
5621: 'USE RECOVERABLE COST',
5622: 'BEGINNING PERIOD')))) then

Line 5669: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)

5665: -- 1. formula; or
5666: -- 2. (calc or table) and cost
5667:
5668: l_dpr_in.update_override_status :=
5669: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
5670: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
5671: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
5672: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
5673: end if;

Line 5670: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)

5666: -- 2. (calc or table) and cost
5667:
5668: l_dpr_in.update_override_status :=
5669: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
5670: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
5671: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
5672: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
5673: end if;
5674:

Line 5671: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))

5667:
5668: l_dpr_in.update_override_status :=
5669: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
5670: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
5671: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
5672: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
5673: end if;
5674:
5675: --* HHIRAGA modified on Oct/Nov in 2003.

Line 5672: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));

5668: l_dpr_in.update_override_status :=
5669: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
5670: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
5671: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
5672: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
5673: end if;
5674:
5675: --* HHIRAGA modified on Oct/Nov in 2003.
5676: -- Changed parameter to period counter when the recalculation of

Line 5735: p_trans_rec.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;

5731: if fa_cache_pkg.fa_deprn_override_enabled then
5732: if l_dpr_in.update_override_status then
5733: p_trans_rec.deprn_override_flag := l_dpr_out.deprn_override_flag;
5734: else
5735: p_trans_rec.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;
5736: end if;
5737: end if;
5738:
5739: l_asset_fin_rec_new.adjusted_cost := l_dpr_out.new_adj_cost;

Line 7915: l_dpr FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;

7911: and con.prorate_date > p_trans_rec.transaction_date_entered); -- Bug6899375 Added the not exists condition
7912:
7913:
7914: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.GetDeprnRec';
7915: l_dpr FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;
7916: l_run_mode VARCHAR2(20) := 'TRANSACTION';
7917: l_status BOOLEAN;
7918:
7919: l_deprn_rsv number;

Line 11852: fa_std_types.FA_NO_OVERRIDE deprn_override_flag,

11848: th.transaction_key transaction_key,
11849: th.amortization_start_date amortization_start_date,
11850: th.calling_interface calling_interface,
11851: th.mass_transaction_id mass_transaction_id,
11852: fa_std_types.FA_NO_OVERRIDE deprn_override_flag,
11853: th.member_transaction_header_id member_transaction_header_id,
11854: th.trx_reference_id trx_reference_id,
11855: th.invoice_transaction_id,
11856: '1st SELECT in c_get_ths_adj'

Line 11943: fa_std_types.FA_NO_OVERRIDE deprn_override_flag,

11939: th.transaction_key transaction_key,
11940: th.amortization_start_date amortization_start_date,
11941: th.calling_interface calling_interface,
11942: th.mass_transaction_id mass_transaction_id,
11943: fa_std_types.FA_NO_OVERRIDE deprn_override_flag,
11944: th.member_transaction_header_id member_transaction_header_id,
11945: th.trx_reference_id trx_reference_id,
11946: th.invoice_transaction_id,
11947: '2nd SELECT in c_get_ths_adj'

Line 12507: l_dpr_in FA_STD_TYPES.dpr_struct;

12503:
12504: l_limit CONSTANT BINARY_INTEGER := 1800; -- main transaction_cursor limit constant;
12505:
12506: --+++++++++++++++ For calling faxcde +++++++++++++++
12507: l_dpr_in FA_STD_TYPES.dpr_struct;
12508: l_dpr_out FA_STD_TYPES.dpr_out_struct;
12509: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
12510: l_running_mode NUMBER;
12511:

Line 12508: l_dpr_out FA_STD_TYPES.dpr_out_struct;

12504: l_limit CONSTANT BINARY_INTEGER := 1800; -- main transaction_cursor limit constant;
12505:
12506: --+++++++++++++++ For calling faxcde +++++++++++++++
12507: l_dpr_in FA_STD_TYPES.dpr_struct;
12508: l_dpr_out FA_STD_TYPES.dpr_out_struct;
12509: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
12510: l_running_mode NUMBER;
12511:
12512: --++++++++++ For storing retirement values ++++++++++

Line 12509: l_dpr_arr FA_STD_TYPES.dpr_arr_type;

12505:
12506: --+++++++++++++++ For calling faxcde +++++++++++++++
12507: l_dpr_in FA_STD_TYPES.dpr_struct;
12508: l_dpr_out FA_STD_TYPES.dpr_out_struct;
12509: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
12510: l_running_mode NUMBER;
12511:
12512: --++++++++++ For storing retirement values ++++++++++
12513: l_retirement_id NUMBER(15);

Line 12743: if p_running_mode = fa_std_types.FA_DPR_CATCHUP then

12739: fa_debug_pkg.add(l_calling_fn, 'l_process_addition: After changing', l_process_addition, p_log_level_rec => p_log_level_rec);
12740: end if;
12741:
12742: -- Bug 5726160
12743: if p_running_mode = fa_std_types.FA_DPR_CATCHUP then
12744:
12745: if p_trans_rec.transaction_type_code = 'REINSTATEMENT' then
12746:
12747: begin

Line 14158: l_running_mode := fa_std_types.FA_DPR_NORMAL;

14154:
14155: --
14156: -- Not for what-if yet
14157: --
14158: l_running_mode := fa_std_types.FA_DPR_NORMAL;
14159: --tk_util.debug('2 rec_cost: '||to_char(px_asset_fin_rec_new.recoverable_cost));
14160:
14161: if (l_process_this_trx) then
14162:

Line 14193: if (not(((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and

14189:
14190: -- skip faxcde call for raf
14191: -- Bug4778244 Added the NVL to avoid condition not(null or false) which will
14192: -- always return NULL in the place of FALSE, which is incorrect
14193: if (not(((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
14194: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule, ' ') = fa_std_types.FAD_DBR_COST) and
14195: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',
14196:
14197: 'PERIOD END AVERAGE',

Line 14194: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule, ' ') = fa_std_types.FAD_DBR_COST) and

14190: -- skip faxcde call for raf
14191: -- Bug4778244 Added the NVL to avoid condition not(null or false) which will
14192: -- always return NULL in the place of FALSE, which is incorrect
14193: if (not(((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
14194: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule, ' ') = fa_std_types.FAD_DBR_COST) and
14195: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',
14196:
14197: 'PERIOD END AVERAGE',
14198: 'USE RECOVERABLE COST',

Line 14253: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)

14249: -- 1. formula; or
14250: -- 2. (calc or table) and cost
14251:
14252: l_dpr_in.update_override_status :=
14253: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
14254: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
14255: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
14256: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
14257: end if;

Line 14254: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)

14250: -- 2. (calc or table) and cost
14251:
14252: l_dpr_in.update_override_status :=
14253: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
14254: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
14255: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
14256: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
14257: end if;
14258:

Line 14255: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))

14251:
14252: l_dpr_in.update_override_status :=
14253: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
14254: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
14255: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
14256: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
14257: end if;
14258:
14259: --+++++++ Call Tracking Function to populate Member in case ALLOCATE ++++++

Line 14256: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));

14252: l_dpr_in.update_override_status :=
14253: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
14254: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
14255: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
14256: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
14257: end if;
14258:
14259: --+++++++ Call Tracking Function to populate Member in case ALLOCATE ++++++
14260: if nvl(l_dpr_in.tracking_method,'OTHER') = 'ALLOCATE' then

Line 14311: p_trans_rec.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;

14307: if fa_cache_pkg.fa_deprn_override_enabled then
14308: if l_dpr_in.update_override_status then
14309: p_trans_rec.deprn_override_flag := l_dpr_out.deprn_override_flag;
14310: else
14311: p_trans_rec.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;
14312: end if;
14313: end if;
14314:
14315: l_asset_fin_rec_new.adjusted_cost := l_dpr_out.new_adj_cost;

Line 14813: -- Set FA_STD_TYPES.dpr_struct for depreciation(faxcde) call.

14809: fa_debug_pkg.add(l_calling_fn, 'Depreciate until ', 'Next Transaction', p_log_level_rec => p_log_level_rec);
14810: end if;
14811: --
14812: -- Find how many periods to depreciate until next transaction headers
14813: -- Set FA_STD_TYPES.dpr_struct for depreciation(faxcde) call.
14814: --
14815: if (nvl(l_next_period_rec.period_counter, p_period_rec.period_counter) = 1) then
14816: l_dpr_in.y_end := nvl(l_next_period_rec.fiscal_year, p_period_rec.fiscal_year) - 1;
14817: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

Line 15064: if p_running_mode = fa_std_types.FA_DPR_CATCHUP then

15060: fa_debug_pkg.add(l_calling_fn, '++ calc_catchup: p_trans_rec.transaction_type_code', p_trans_rec.transaction_type_code, p_log_level_rec => p_log_level_rec);
15061: end if;
15062:
15063: -- Bug 5726160
15064: if p_running_mode = fa_std_types.FA_DPR_CATCHUP then
15065:
15066: if p_trans_rec.transaction_type_code = 'REINSTATEMENT' then
15067:
15068: if l_retirement_thid = l_trans_rec.transaction_header_id then

Line 15149: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and

15145: -- We have backported Fix for Bug 7459910 so this logic is not
15146: -- needed for basis reset when deprn basis rule is used.
15147: --
15148: if (
15149: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and
15150: (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FORMULA) and
15151: (fa_cache_pkg.fazccmt_record.deprn_basis_rule is null)
15152: )
15153: then

Line 15150: (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FORMULA) and

15146: -- needed for basis reset when deprn basis rule is used.
15147: --
15148: if (
15149: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and
15150: (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FORMULA) and
15151: (fa_cache_pkg.fazccmt_record.deprn_basis_rule is null)
15152: )
15153: then
15154: -- Call Depreciable Basis Rule for Formula/NBV Basis

Line 15316: if p_running_mode = fa_std_types.FA_DPR_CATCHUP then

15312: end if;
15313: --Bug 8398064:End
15314: elsif (p_trans_rec.transaction_type_code = 'REINSTATEMENT') then
15315: -- Bug 5726160
15316: if p_running_mode = fa_std_types.FA_DPR_CATCHUP then
15317: x_deprn_expense := nvl(l_asset_deprn_rec.deprn_reserve, 0) -
15318: nvl(l_catchup_begin_deprn_rec.deprn_reserve, 0);
15319: x_bonus_expense := nvl(l_asset_deprn_rec.bonus_deprn_reserve, 0) -
15320: nvl(l_catchup_begin_deprn_rec.bonus_deprn_reserve, 0);

Line 15711: l_dpr_row FA_STD_TYPES.dpr_struct;

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;
15714:
15715: l_cur_deprn_rsv number;

Line 15712: l_dpr_arr FA_STD_TYPES.dpr_arr_type;

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;
15714:
15715: l_cur_deprn_rsv number;
15716: l_cur_bonus_deprn_rsv number;

Line 15713: l_dpr_out FA_STD_TYPES.dpr_out_struct;

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;
15714:
15715: l_cur_deprn_rsv number;
15716: l_cur_bonus_deprn_rsv number;
15717: l_cur_impairment_rsv number;

Line 15840: FA_STD_TYPES.FA_DPR_NORMAL, p_log_level_rec => p_log_level_rec)) then

15836:
15837: if (not FA_CDE_PKG.faxcde(l_dpr_row,
15838: l_dpr_arr,
15839: l_dpr_out,
15840: FA_STD_TYPES.FA_DPR_NORMAL, p_log_level_rec => p_log_level_rec)) then
15841: FA_SRVR_MSG.ADD_MESSAGE
15842: (CALLING_FN=>'faxcde3', p_log_level_rec => p_log_level_rec);
15843: FA_SRVR_MSG.ADD_MESSAGE
15844: (CALLING_FN => 'FA_AMORT_PKG.get_reserve',

Line 15909: -- if l_deprn_basis_formula = fa_std_types.FAD_DBF_FLAT then

15905: if l_deprn_basis_formula is null then
15906: return true;
15907: end if;
15908:
15909: -- if l_deprn_basis_formula = fa_std_types.FAD_DBF_FLAT then
15910: if l_deprn_basis_formula = 'STRICT_FLAT' then
15911: if (not fa_cache_pkg.fazccmt(p_method_code,
15912: p_life, p_log_level_rec => p_log_level_rec)) then
15913: fa_srvr_msg.add_message(calling_fn => 'FA_AMORT_PKG.faxnac', p_log_level_rec => p_log_level_rec);

Line 15920: if l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FLAT and

15916:
15917: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
15918: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
15919:
15920: if l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FLAT and
15921: l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_COST then
15922: if p_rec_cost is null then
15923: fa_srvr_msg.add_message(calling_fn => 'FA_AMORT_PKG.faxnac', p_log_level_rec => p_log_level_rec);
15924: return false;

Line 15921: l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_COST then

15917: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
15918: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
15919:
15920: if l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FLAT and
15921: l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_COST then
15922: if p_rec_cost is null then
15923: fa_srvr_msg.add_message(calling_fn => 'FA_AMORT_PKG.faxnac', p_log_level_rec => p_log_level_rec);
15924: return false;
15925: end if;

Line 15927: elsif l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FLAT and

15923: fa_srvr_msg.add_message(calling_fn => 'FA_AMORT_PKG.faxnac', p_log_level_rec => p_log_level_rec);
15924: return false;
15925: end if;
15926: px_adj_cost := p_rec_cost;
15927: elsif l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FLAT and
15928: l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_NBV then
15929: if p_rec_cost is null or
15930: not ((p_prior_fy_exp is not null) or
15931: (p_deprn_rsv is not null and p_ytd_deprn is not null) ) then

Line 15928: l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_NBV then

15924: return false;
15925: end if;
15926: px_adj_cost := p_rec_cost;
15927: elsif l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FLAT and
15928: l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_NBV then
15929: if p_rec_cost is null or
15930: not ((p_prior_fy_exp is not null) or
15931: (p_deprn_rsv is not null and p_ytd_deprn is not null) ) then
15932: fa_srvr_msg.add_message(calling_fn => 'FA_AMORT_PKG.faxnac', p_log_level_rec => p_log_level_rec);

Line 15966: l_dpr_row FA_STD_TYPES.dpr_struct;

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;
15969: l_add_txn_id number;
15970: l_deprn_basis_rule varchar2(25);

Line 15967: l_dpr_out FA_STD_TYPES.dpr_out_struct;

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;
15969: l_add_txn_id number;
15970: l_deprn_basis_rule varchar2(25);
15971: l_rate_source_rule varchar2(25);

Line 15968: l_dpr_arr FA_STD_TYPES.dpr_arr_type;

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;
15969: l_add_txn_id number;
15970: l_deprn_basis_rule varchar2(25);
15971: l_rate_source_rule varchar2(25);
15972: l_excl_salvage_val_flag boolean;

Line 15996: l_deprn_summary fa_std_types.fa_deprn_row_struct;

15992: l_last_per_ctr integer;
15993: l_amortize_per_ctr integer;
15994: l_adjustment_amount number;
15995: l_rsv_amount number;
15996: l_deprn_summary fa_std_types.fa_deprn_row_struct;
15997: l_dummy_bool boolean; --Used to call QUERY_BALANCES_INT
15998:
15999: l_temp_deprn_rsv number; -- reserve at the beginning of fy
16000: l_cur_total_rsv number;

Line 16032: if p_running_mode = fa_std_types.FA_DPR_PROJECT then

16028:
16029: begin <>
16030:
16031: -- override
16032: if p_running_mode = fa_std_types.FA_DPR_PROJECT then
16033: l_running_mode:= fa_std_types.FA_DPR_PROJECT;
16034: else
16035: l_running_mode:= fa_std_types.FA_DPR_NORMAL;
16036: end if;

Line 16033: l_running_mode:= fa_std_types.FA_DPR_PROJECT;

16029: begin <>
16030:
16031: -- override
16032: if p_running_mode = fa_std_types.FA_DPR_PROJECT then
16033: l_running_mode:= fa_std_types.FA_DPR_PROJECT;
16034: else
16035: l_running_mode:= fa_std_types.FA_DPR_NORMAL;
16036: end if;
16037: -- End of Manual Override

Line 16035: l_running_mode:= fa_std_types.FA_DPR_NORMAL;

16031: -- override
16032: if p_running_mode = fa_std_types.FA_DPR_PROJECT then
16033: l_running_mode:= fa_std_types.FA_DPR_PROJECT;
16034: else
16035: l_running_mode:= fa_std_types.FA_DPR_NORMAL;
16036: end if;
16037: -- End of Manual Override
16038:
16039: if (p_log_level_rec.statement_level) then

Line 16090: value => FA_STD_TYPES.FA_DPR_ROUND_ADJ, p_log_level_rec => p_log_level_rec);

16086: value => px_asset_fin_rec_new.annual_deprn_rounding_flag, p_log_level_rec => p_log_level_rec);
16087: FA_DEBUG_PKG.ADD
16088: (fname => 'FA_AMORT_PKG.faxraf',
16089: element => 'FA_STD TYPE deprn_rnd- before faxbds',
16090: value => FA_STD_TYPES.FA_DPR_ROUND_ADJ, p_log_level_rec => p_log_level_rec);
16091: end if;
16092:
16093: if not FA_EXP_PVT.faxbds
16094: (p_asset_hdr_rec => p_asset_hdr_rec,

Line 16113: l_dpr_row.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;

16109: l_cur_ytd := l_dpr_row.ytd_deprn;
16110:
16111: -- override
16112: l_dpr_row.used_by_adjustment := TRUE;
16113: l_dpr_row.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;
16114:
16115: -- l_err_string := 'FA_AMT_CAL_DP_EXP';
16116: if (p_log_level_rec.statement_level) then
16117: FA_DEBUG_PKG.ADD

Line 16206: l_use_override := ((l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FORMULA) or

16202: if l_used_by_revaluation = 1 then --16275774
16203: l_dpr_row.deprn_override_used_by := 'PRE';
16204: end if;
16205:
16206: l_use_override := ((l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FORMULA) or
16207: (((l_rate_source_rule = FA_STD_TYPES.FAD_RSR_CALC) or
16208: (l_rate_source_rule = FA_STD_TYPES.FAD_RSR_TABLE)) and
16209: (l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_COST)));
16210:

Line 16207: (((l_rate_source_rule = FA_STD_TYPES.FAD_RSR_CALC) or

16203: l_dpr_row.deprn_override_used_by := 'PRE';
16204: end if;
16205:
16206: l_use_override := ((l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FORMULA) or
16207: (((l_rate_source_rule = FA_STD_TYPES.FAD_RSR_CALC) or
16208: (l_rate_source_rule = FA_STD_TYPES.FAD_RSR_TABLE)) and
16209: (l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_COST)));
16210:
16211: -- Set Tracking related variables

Line 16208: (l_rate_source_rule = FA_STD_TYPES.FAD_RSR_TABLE)) and

16204: end if;
16205:
16206: l_use_override := ((l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FORMULA) or
16207: (((l_rate_source_rule = FA_STD_TYPES.FAD_RSR_CALC) or
16208: (l_rate_source_rule = FA_STD_TYPES.FAD_RSR_TABLE)) and
16209: (l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_COST)));
16210:
16211: -- Set Tracking related variables
16212: l_dpr_row.tracking_method := p_asset_fin_rec_old.tracking_method;

Line 16209: (l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_COST)));

16205:
16206: l_use_override := ((l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FORMULA) or
16207: (((l_rate_source_rule = FA_STD_TYPES.FAD_RSR_CALC) or
16208: (l_rate_source_rule = FA_STD_TYPES.FAD_RSR_TABLE)) and
16209: (l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_COST)));
16210:
16211: -- Set Tracking related variables
16212: l_dpr_row.tracking_method := p_asset_fin_rec_old.tracking_method;
16213: l_dpr_row.allocate_to_fully_ret_flag := p_asset_fin_rec_old.allocate_to_fully_ret_flag;

Line 16231: FA_STD_TYPES.FA_DPR_NORMAL, p_log_level_rec => p_log_level_rec)) then

16227: if (not FA_CDE_PKG.faxcde
16228: (l_dpr_row,
16229: l_dpr_arr,
16230: l_dpr_out,
16231: FA_STD_TYPES.FA_DPR_NORMAL, p_log_level_rec => p_log_level_rec)) then
16232: FA_SRVR_MSG.ADD_MESSAGE
16233: (CALLING_FN => 'FA_AMORT_PKG.faxraf',
16234: NAME=>'FA_AMT_CAL_DP_EXP', p_log_level_rec => p_log_level_rec);
16235: if (p_log_level_rec.statement_level) then

Line 16257: fa_std_types.deprn_override_trigger_enabled:= FALSE;

16253: return FALSE;
16254: end if;
16255:
16256: -- Override
16257: fa_std_types.deprn_override_trigger_enabled:= FALSE;
16258: if l_use_override then -- pass deprn_override_flag to faxiat
16259: px_trans_rec.deprn_override_flag:= l_dpr_out.deprn_override_flag;
16260: if (p_log_level_rec.statement_level) then
16261: FA_DEBUG_PKG.ADD(fname=>'FA_AMORT_PKG.faxraf',

Line 16267: px_trans_rec.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;

16263: value=>l_dpr_out.deprn_override_flag, p_log_level_rec => p_log_level_rec);
16264: end if;
16265: else
16266: -- pass fa_no_override to faxiat
16267: px_trans_rec.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;
16268: -- update the status fa_deprn_override from 'SELECTED' to 'POST'
16269: UPDATE FA_DEPRN_OVERRIDE
16270: SET status = 'POST'
16271: WHERE used_by = 'ADJUSTMENT'

Line 16276: fa_std_types.deprn_override_trigger_enabled:= TRUE;

16272: AND status = 'SELECTED'
16273: AND transaction_header_id is null;
16274: end if;
16275:
16276: fa_std_types.deprn_override_trigger_enabled:= TRUE;
16277:
16278: --
16279: -- In most cases, New Adjusted_Cost = New Net Book Value;
16280: -- New Rate_Adjustment_Factor = New Net Book Value / New Deprn_Reserve

Line 16294: if (l_rate_source_rule = FA_STD_TYPES.FAD_RSR_PROD) then

16290: -- not calculated on Depreciable Basis Formula
16291:
16292: px_asset_fin_rec_new.reval_amortization_basis := l_dpr_row.reval_rsv;
16293:
16294: if (l_rate_source_rule = FA_STD_TYPES.FAD_RSR_PROD) then
16295: px_asset_fin_rec_new.rate_adjustment_factor := 1;
16296: px_asset_fin_rec_new.adjusted_capacity
16297: := px_asset_fin_rec_new.production_capacity -
16298: l_dpr_out.new_ltd_prod;

Line 16307: if (not l_rate_source_rule = FA_STD_TYPES.FAD_RSR_CALC)

16303: -- for Amortized Adjustment of current period
16304: ----------------------------------------------
16305: /*Bug8230037 - Added condition based on sorp_enabled_flag
16306: - No need to call CALL_DEPRN_BASIS for Double Declining methods */
16307: if (not l_rate_source_rule = FA_STD_TYPES.FAD_RSR_CALC)
16308: and nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y' then
16309: if (not FA_CALC_DEPRN_BASIS1_PKG.CALL_DEPRN_BASIS (
16310: p_event_type => 'AMORT_ADJ',
16311: p_asset_fin_rec_new => px_asset_fin_rec_new,

Line 16624: FA_STD_TYPES.FA_DPR_NORMAL, p_log_level_rec => p_log_level_rec)) then

16620: if (not FA_CDE_PKG.faxcde
16621: (l_dpr_row,
16622: l_dpr_arr,
16623: l_dpr_out,
16624: FA_STD_TYPES.FA_DPR_NORMAL, p_log_level_rec => p_log_level_rec)) then
16625: FA_SRVR_MSG.ADD_MESSAGE
16626: (CALLING_FN=>'faxcde2', p_log_level_rec => p_log_level_rec);
16627: FA_SRVR_MSG.ADD_MESSAGE
16628: (CALLING_FN => 'FA_AMORT_PKG.faxraf',

Line 16766: l_dpr_in FA_STD_TYPES.dpr_struct;

16762: l_rate_source_rule VARCHAR2(25);
16763: l_deprn_basis_rule VARCHAR2(25);
16764:
16765: --+++++++++++++++ For calling faxcde +++++++++++++++
16766: l_dpr_in FA_STD_TYPES.dpr_struct;
16767: l_dpr_out FA_STD_TYPES.dpr_out_struct;
16768: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
16769: l_running_mode NUMBER;
16770:

Line 16767: l_dpr_out FA_STD_TYPES.dpr_out_struct;

16763: l_deprn_basis_rule VARCHAR2(25);
16764:
16765: --+++++++++++++++ For calling faxcde +++++++++++++++
16766: l_dpr_in FA_STD_TYPES.dpr_struct;
16767: l_dpr_out FA_STD_TYPES.dpr_out_struct;
16768: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
16769: l_running_mode NUMBER;
16770:
16771: l_deprn_reserve NUMBER;

Line 16768: l_dpr_arr FA_STD_TYPES.dpr_arr_type;

16764:
16765: --+++++++++++++++ For calling faxcde +++++++++++++++
16766: l_dpr_in FA_STD_TYPES.dpr_struct;
16767: l_dpr_out FA_STD_TYPES.dpr_out_struct;
16768: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
16769: l_running_mode NUMBER;
16770:
16771: l_deprn_reserve NUMBER;
16772: l_temp_integer BINARY_INTEGER;

Line 16850: if (not( (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_CALC)

16846:
16847: -- Skipping call to the function because it is not necessary for straight line
16848: -- or flat-cost with period end balance and use recoverable cost basis rules
16849: -- There are more cases which calling this function unnecessary but not include for this time.
16850: if (not( (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_CALC)
16851: or ((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
16852: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
16853: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE','USE RECOVERABLE COST'))))) then
16854:

Line 16851: or ((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and

16847: -- Skipping call to the function because it is not necessary for straight line
16848: -- or flat-cost with period end balance and use recoverable cost basis rules
16849: -- There are more cases which calling this function unnecessary but not include for this time.
16850: if (not( (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_CALC)
16851: or ((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
16852: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
16853: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE','USE RECOVERABLE COST'))))) then
16854:
16855: -- Get Eofy/Eop Recovearble Cost and Salvage Value

Line 16852: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and

16848: -- or flat-cost with period end balance and use recoverable cost basis rules
16849: -- There are more cases which calling this function unnecessary but not include for this time.
16850: if (not( (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_CALC)
16851: or ((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
16852: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
16853: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE','USE RECOVERABLE COST'))))) then
16854:
16855: -- Get Eofy/Eop Recovearble Cost and Salvage Value
16856: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_EOFY_EOP (

Line 16891: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and

16887:
16888: -- Skipping call to faxcde because it is unnecessary for flat-cost with period end balance,
16889: -- use recoverable cost, period average, and beginning balance basis rules
16890: -- There are more cases which calling this function unnecessary but not include for this time.
16891: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
16892: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
16893: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
16894: 'USE RECOVERABLE COST', 'BEGINNING PERIOD'))
16895: --Bug 6312866 or fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD

Line 16892: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and

16888: -- Skipping call to faxcde because it is unnecessary for flat-cost with period end balance,
16889: -- use recoverable cost, period average, and beginning balance basis rules
16890: -- There are more cases which calling this function unnecessary but not include for this time.
16891: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
16892: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
16893: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
16894: 'USE RECOVERABLE COST', 'BEGINNING PERIOD'))
16895: --Bug 6312866 or fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD
16896: ))) then

Line 16895: --Bug 6312866 or fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD

16891: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
16892: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
16893: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
16894: 'USE RECOVERABLE COST', 'BEGINNING PERIOD'))
16895: --Bug 6312866 or fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD
16896: ))) then
16897:
16898: l_dpr_in.asset_num := p_asset_desc_rec.asset_number;
16899: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

Line 16961: l_running_mode := fa_std_types.FA_DPR_NORMAL;

16957:
16958: --
16959: -- Not for what-if yet
16960: --
16961: l_running_mode := fa_std_types.FA_DPR_NORMAL;
16962:
16963: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
16964: fa_cache_pkg.fazcbc_record.fiscal_year_name,
16965: l_dpr_in.prorate_jdate,

Line 17016: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)

17012: -- 1. formula; or
17013: -- 2. (calc or table) and cost
17014:
17015: l_dpr_in.update_override_status :=
17016: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
17017: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
17018: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
17019: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
17020: end if;

Line 17017: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)

17013: -- 2. (calc or table) and cost
17014:
17015: l_dpr_in.update_override_status :=
17016: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
17017: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
17018: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
17019: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
17020: end if;
17021:

Line 17018: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))

17014:
17015: l_dpr_in.update_override_status :=
17016: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
17017: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
17018: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
17019: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
17020: end if;
17021:
17022: --* HHIRAGA modified on Oct/Nov in 2003.

Line 17019: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));

17015: l_dpr_in.update_override_status :=
17016: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
17017: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
17018: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
17019: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
17020: end if;
17021:
17022: --* HHIRAGA modified on Oct/Nov in 2003.
17023: -- Changed parameter to period counter when the recalculation of

Line 17315: (fa_cache_pkg.fazccmt_record.rate_source_rule = FA_STD_TYPES.FAD_RSR_PROD) then

17311: -- Bug7715880: BP fix for bug7446301. Removed tracking method condition so that process
17312: -- will satisfy following if condition even if the asset type is not GROUP
17313: -- if (nvl(px_asset_fin_rec_new.tracking_method, 'NO TRACK') = 'ALLOCATE') and -- ENERGY
17314: IF (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY
17315: (fa_cache_pkg.fazccmt_record.rate_source_rule = FA_STD_TYPES.FAD_RSR_PROD) then
17316: px_asset_fin_rec_new.adjusted_capacity := nvl(px_asset_fin_rec_new.production_capacity, 0) -
17317: nvl(p_asset_deprn_rec_new.ltd_production, 0);
17318: end if;
17319: