APPS.FA_CDE_PKG dependencies on FA_DEPRN_OVERRIDE

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

3107: fa_debug_pkg.ADD('faxcde', 'perd_deprn_exp',perd_deprn_exp, p_log_level_rec => p_log_level_rec);
3108: END IF;
3109:
3110: --
3111: -- if the profile option:FA_DEPRN_OVERRIDE_ENABLED = 'Y' and
3112: -- this is not for what-if analysis, call FAODDA funtion to
3113: -- upload the override depreciation data
3114: --
3115: override_depr_amt:= NULL;

Line 3122: IF (fa_cache_pkg.fa_deprn_override_enabled) AND (nvl(l_request_short_name,'X') <> 'FAWDPR') THEN

3118: /* As mentioned above we should not override deprn value for what-if-analysis
3119: So, added check for What-If analysis bug 7645269*/
3120:
3121: -- Bug 8211842: Added nvl
3122: IF (fa_cache_pkg.fa_deprn_override_enabled) AND (nvl(l_request_short_name,'X') <> 'FAWDPR') THEN
3123: whatif_override_enable := 'Y';
3124: ELSE
3125: whatif_override_enable := 'N';
3126: END IF;

Line 3129: fa_debug_pkg.ADD('faxcde', 'FA_DEPRN_OVERRIDE_ENABLED', whatif_override_enable, p_log_level_rec => p_log_level_rec);

3125: whatif_override_enable := 'N';
3126: END IF;
3127:
3128: IF (p_log_level_rec.statement_level) THEN
3129: fa_debug_pkg.ADD('faxcde', 'FA_DEPRN_OVERRIDE_ENABLED', whatif_override_enable, p_log_level_rec => p_log_level_rec);
3130: END IF;
3131:
3132: IF whatif_override_enable = 'Y' AND
3133: NVL(dpr_in.deprn_override_flag, fa_std_types.FA_NO_OVERRIDE) <> fa_std_types.FA_OVERRIDE_RECURSIVE THEN

Line 4940: FROM FA_DEPRN_OVERRIDE

4936: (l_period_counter < p_override_period_counter) then
4937:
4938: SELECT deprn_amount, bonus_deprn_amount, subtract_ytd_flag, deprn_override_id
4939: INTO override_depr_amt, override_bonus_amt, subtract_ytd_flag, h_deprn_override_id
4940: FROM FA_DEPRN_OVERRIDE
4941: WHERE book_type_code = book
4942: AND asset_id = h_asset_id
4943: AND period_name = perd_name
4944: AND used_by = 'DEPRECIATION'

Line 4958: FROM FA_DEPRN_OVERRIDE

4954: INTO override_depr_amt
4955: , override_bonus_amt
4956: , subtract_ytd_flag
4957: , h_deprn_override_id
4958: FROM FA_DEPRN_OVERRIDE
4959: WHERE book_type_code = book
4960: AND asset_id = h_asset_id
4961: AND period_name = perd_name
4962: AND used_by = 'ADJUSTMENT'

Line 4973: FROM FA_DEPRN_OVERRIDE

4969: INTO override_depr_amt
4970: , override_bonus_amt
4971: , subtract_ytd_flag
4972: , h_deprn_override_id
4973: FROM FA_DEPRN_OVERRIDE
4974: WHERE book_type_code = book
4975: AND asset_id = h_asset_id
4976: AND period_name = perd_name
4977: AND used_by = 'RETIREMENT'

Line 4988: FROM FA_DEPRN_OVERRIDE

4984: INTO override_depr_amt
4985: , override_bonus_amt
4986: , subtract_ytd_flag
4987: , h_deprn_override_id
4988: FROM FA_DEPRN_OVERRIDE
4989: WHERE book_type_code = book
4990: AND asset_id = h_asset_id
4991: AND period_name = perd_name
4992: AND used_by = 'DEPRECIATION'

Line 5139: UPDATE fa_deprn_override

5135:
5136: fa_std_types.deprn_override_trigger_enabled:= FALSE;
5137:
5138: IF nvl(deprn_override_used_by, 'DEP') <> 'ADJ' THEN --Bug11886090
5139: UPDATE fa_deprn_override
5140: SET status = 'POSTED'
5141: WHERE deprn_override_id = h_deprn_override_id;
5142:
5143: ELSIF p_update_override_status THEN

Line 5144: UPDATE fa_deprn_override

5140: SET status = 'POSTED'
5141: WHERE deprn_override_id = h_deprn_override_id;
5142:
5143: ELSIF p_update_override_status THEN
5144: UPDATE fa_deprn_override
5145: SET status = 'SELECTED'
5146: WHERE deprn_override_id = h_deprn_override_id;
5147:
5148: END IF;