DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_POST_PVT dependencies on FA_STD_TYPES

Line 648: fa_std_types.deprn_override_trigger_enabled := FALSE; --16275774 start

644: end if;
645:
646: l_period_counter := t_period_counter(1);
647:
648: fa_std_types.deprn_override_trigger_enabled := FALSE; --16275774 start
649:
650: FORALL i in 1..t_request_id.count
651: UPDATE fa_deprn_override
652: SET status = 'POSTED'

Line 656: AND t_deprn_override_flag(i) <> fa_std_types.FA_NO_OVERRIDE;

652: SET status = 'POSTED'
653: WHERE asset_id = t_asset_id(i)
654: AND book_type_code = p_book_type_code
655: AND period_name = p_period_rec.period_name
656: AND t_deprn_override_flag(i) <> fa_std_types.FA_NO_OVERRIDE;
657:
658: fa_std_types.deprn_override_trigger_enabled := TRUE; --16275774 end
659:
660: -- Insert th

Line 658: fa_std_types.deprn_override_trigger_enabled := TRUE; --16275774 end

654: AND book_type_code = p_book_type_code
655: AND period_name = p_period_rec.period_name
656: AND t_deprn_override_flag(i) <> fa_std_types.FA_NO_OVERRIDE;
657:
658: fa_std_types.deprn_override_trigger_enabled := TRUE; --16275774 end
659:
660: -- Insert th
661: if (p_mrc_sob_type_code = 'R') then
662: -- select impairment thid of primary book

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

969: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
970: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
971: end if;
972:
973: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
974: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
975: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'Y') = 'Y') and
976: NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'XX') <> 'YES' then
977: l_asset_deprn_rec.impairment_reserve := l_asset_deprn_rec.deprn_reserve +

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

970: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
971: end if;
972:
973: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
974: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
975: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'Y') = 'Y') and
976: NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'XX') <> 'YES' then
977: l_asset_deprn_rec.impairment_reserve := l_asset_deprn_rec.deprn_reserve +
978: l_asset_deprn_rec.impairment_reserve;

Line 2322: l_dpr_in FA_STD_TYPES.dpr_struct;

2318: l_rate_source_rule VARCHAR2(25);
2319: l_deprn_basis_rule VARCHAR2(25);
2320:
2321: --+++++++++++++++ For calling faxcde +++++++++++++++
2322: l_dpr_in FA_STD_TYPES.dpr_struct;
2323: l_dpr_out FA_STD_TYPES.dpr_out_struct;
2324: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
2325: l_running_mode NUMBER;
2326:

Line 2323: l_dpr_out FA_STD_TYPES.dpr_out_struct;

2319: l_deprn_basis_rule VARCHAR2(25);
2320:
2321: --+++++++++++++++ For calling faxcde +++++++++++++++
2322: l_dpr_in FA_STD_TYPES.dpr_struct;
2323: l_dpr_out FA_STD_TYPES.dpr_out_struct;
2324: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
2325: l_running_mode NUMBER;
2326:
2327: l_deprn_reserve NUMBER;

Line 2324: l_dpr_arr FA_STD_TYPES.dpr_arr_type;

2320:
2321: --+++++++++++++++ For calling faxcde +++++++++++++++
2322: l_dpr_in FA_STD_TYPES.dpr_struct;
2323: l_dpr_out FA_STD_TYPES.dpr_out_struct;
2324: l_dpr_arr FA_STD_TYPES.dpr_arr_type;
2325: l_running_mode NUMBER;
2326:
2327: l_deprn_reserve NUMBER;
2328: l_temp_integer BINARY_INTEGER;

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

2384:
2385: -- Skipping call to faxcde because it is unnecessary for flat-cost with period end balance,
2386: -- use recoverable cost, period average, and beginning balance basis rules
2387: -- There are more cases which calling this function unnecessary but not include for this time.
2388: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
2389: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
2390: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
2391: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
2392: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then

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

2385: -- Skipping call to faxcde because it is unnecessary for flat-cost with period end balance,
2386: -- use recoverable cost, period average, and beginning balance basis rules
2387: -- There are more cases which calling this function unnecessary but not include for this time.
2388: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
2389: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
2390: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
2391: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
2392: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then
2393:

Line 2392: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then

2388: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
2389: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
2390: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
2391: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
2392: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then
2393:
2394: l_dpr_in.asset_num := p_asset_desc_rec.asset_number;
2395: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
2396: l_dpr_in.book := p_asset_hdr_rec.book_type_code;

Line 2453: l_running_mode := fa_std_types.FA_DPR_NORMAL;

2449:
2450: --
2451: -- Not for what-if yet
2452: --
2453: l_running_mode := fa_std_types.FA_DPR_NORMAL;
2454:
2455: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then
2456: if (p_log_level_rec.statement_level) then
2457: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazcct', p_log_level_rec => p_log_level_rec);

Line 2525: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)

2521: -- 1. formula; or
2522: -- 2. (calc or table) and cost
2523:
2524: l_dpr_in.update_override_status :=
2525: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
2526: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
2527: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
2528: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
2529: end if;

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

2522: -- 2. (calc or table) and cost
2523:
2524: l_dpr_in.update_override_status :=
2525: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
2526: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
2527: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
2528: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
2529: end if;
2530:

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

2523:
2524: l_dpr_in.update_override_status :=
2525: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
2526: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
2527: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
2528: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
2529: end if;
2530:
2531: --+++++++ Call Depreciation engine for rate adjustment factor +++++++

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

2524: l_dpr_in.update_override_status :=
2525: ((l_rate_source_rule = fa_std_types.FAD_RSR_FORMULA)
2526: OR (((l_rate_source_rule = fa_std_types.FAD_RSR_CALC)
2527: OR (l_rate_source_rule = fa_std_types.FAD_RSR_TABLE))
2528: AND (l_deprn_basis_rule = fa_std_types.FAD_DBR_COST)));
2529: end if;
2530:
2531: --+++++++ Call Depreciation engine for rate adjustment factor +++++++
2532: if not FA_CDE_PKG.faxcde(l_dpr_in,