APPS.FA_CDE_PKG dependencies on FA_DEPRN_OVERRIDE

Line 2654: -- if the profile option:FA_DEPRN_OVERRIDE_ENABLED = 'Y' and

2650: fa_debug_pkg.add('faxcde', 'perd_deprn_exp',perd_deprn_exp, p_log_level_rec);
2651: end if;
2652:
2653: --
2654: -- if the profile option:FA_DEPRN_OVERRIDE_ENABLED = 'Y' and
2655: -- this is not for what-if analysis, call FAODDA funtion to
2656: -- upload the override depreciation data
2657: --
2658: override_depr_amt:= NULL;

Line 2661: if (fa_cache_pkg.fa_deprn_override_enabled) then

2657: --
2658: override_depr_amt:= NULL;
2659: override_bonus_amt:= NULL;
2660:
2661: if (fa_cache_pkg.fa_deprn_override_enabled) then
2662: value := 'Y';
2663: else
2664: value := 'N';
2665: end if;

Line 2668: fa_debug_pkg.add('faxcde', 'FA_DEPRN_OVERRIDE_ENABLED', value, p_log_level_rec);

2664: value := 'N';
2665: end if;
2666:
2667: if (p_log_level_rec.statement_level) then
2668: fa_debug_pkg.add('faxcde', 'FA_DEPRN_OVERRIDE_ENABLED', value, p_log_level_rec);
2669: end if;
2670:
2671: if value = 'Y' and
2672: nvl(dpr_in.deprn_override_flag, fa_std_types.FA_NO_OVERRIDE) <> fa_std_types.FA_OVERRIDE_RECURSIVE then

Line 4302: FROM FA_DEPRN_OVERRIDE

4298:
4299: if used_by_adjustment = TRUE then
4300: SELECT deprn_amount, bonus_deprn_amount, subtract_ytd_flag, deprn_override_id
4301: INTO override_depr_amt, override_bonus_amt, subtract_ytd_flag, h_deprn_override_id
4302: FROM FA_DEPRN_OVERRIDE
4303: WHERE
4304: book_type_code = book and
4305: asset_id = h_asset_id and
4306: period_name = perd_name and

Line 4312: FROM FA_DEPRN_OVERRIDE

4308: status = 'POST';
4309: else
4310: SELECT deprn_amount, bonus_deprn_amount, subtract_ytd_flag, deprn_override_id
4311: INTO override_depr_amt, override_bonus_amt, subtract_ytd_flag, h_deprn_override_id
4312: FROM FA_DEPRN_OVERRIDE
4313: WHERE
4314: book_type_code = book and
4315: asset_id = h_asset_id and
4316: period_name = perd_name and

Line 4428: UPDATE fa_deprn_override

4424:
4425: fa_std_types.deprn_override_trigger_enabled:= FALSE;
4426:
4427: IF used_by_adjustment = FALSE THEN
4428: UPDATE fa_deprn_override
4429: SET status = 'POSTED'
4430: WHERE deprn_override_id = h_deprn_override_id;
4431:
4432: ELSIF p_update_override_status THEN

Line 4433: UPDATE fa_deprn_override

4429: SET status = 'POSTED'
4430: WHERE deprn_override_id = h_deprn_override_id;
4431:
4432: ELSIF p_update_override_status THEN
4433: UPDATE fa_deprn_override
4434: SET status = 'SELECTED'
4435: WHERE deprn_override_id = h_deprn_override_id;
4436: END IF;
4437: