[Home] [Help]
1: PACKAGE BODY FA_UNPLANNED_PVT as
2: /* $Header: FAVUNPLB.pls 120.33.12020000.3 2012/11/30 14:10:04 spooyath ship $ */
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:
6: FUNCTION do_unplanned
7: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
79: l_transaction_subtype := p_unplanned_deprn_rec.unplanned_type;
80:
81: deprn_override_flag_default:= fa_std_types.FA_NO_OVERRIDE;
82:
83: if not FA_CACHE_PKG.fazccmt(p_asset_fin_rec.deprn_method_code,
84: p_asset_fin_rec.life_in_months,
85: p_log_level_rec => p_log_level_rec) then
86: raise unp_err;
87: end if;
90: -- check that method is valid for unplanned - only need to due this for primary
91:
92: if (p_mrc_sob_type_code <> 'R') then
93:
94: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
95: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
96:
97: if (l_rate_source_rule = 'TABLE' or
98: (l_deprn_basis_rule = 'NBV' and
91:
92: if (p_mrc_sob_type_code <> 'R') then
93:
94: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
95: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
96:
97: if (l_rate_source_rule = 'TABLE' or
98: (l_deprn_basis_rule = 'NBV' and
99: l_rate_source_rule <> 'FLAT')) and
98: (l_deprn_basis_rule = 'NBV' and
99: l_rate_source_rule <> 'FLAT')) and
100: (not (l_deprn_basis_rule = 'NBV' and
101: l_rate_source_rule = 'PRODUCTION' and
102: fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE')) then
103:
104: -- Bug:5930979:Japan Tax Reform Project
105: if not (l_rate_source_rule = 'FORMULA') then
106: fa_srvr_msg.add_message
128: /* Added for Bug 12334717 Start */
129: If (p_asset_type_rec.asset_type = 'GROUP' and
130: l_deprn_basis_rule = 'NBV' and
131: l_rate_source_rule = 'PRODUCTION' and
132: fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then
133:
134: SELECT SUM(recoverable_cost) -
135: SUM (FA_UTIL_PVT.get_asset_deprn_resv (p_asset_hdr_rec.book_type_code,
136: asset_id,
420: p_asset_type_rec.asset_type = 'GROUP'))
421: or
422: ((p_asset_type_rec.asset_type <> 'GROUP') and
423: (l_asset_fin_rec.group_asset_id is not null) and
424: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and
425: (nvl(l_asset_fin_rec.tracking_method, 'NO TRACK') = 'CALCULATE')) then
426:
427: l_asset_fin_rec.rate_adjustment_factor := l_temp_raf;
428:
453: -- A condition refering 'ENERGY PERIOD END BALANCE' can be removed from rel 12.
454: if (px_trans_rec.calling_interface = 'FAXASSET') and
455: (l_asset_fin_rec.group_asset_id is null and
456: nvl(l_asset_fin_rec.tracking_method, 'NO TRACK') = 'ALLOCATE')
457: and (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE')
458: then
459: l_asset_fin_rec.adjustment_required_status := 'GADJ';
460:
461: if (p_mrc_sob_type_code <> 'R') then
599: raise unp_err;
600: end if;
601:
602: -- Bug:5930979:Japan Tax Reform Project
603: if fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' then
604: if (p_mrc_sob_type_code <> 'R') then
605: FA_CDE_PKG.faxgfr (X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
606: X_Asset_Id => p_asset_hdr_rec.asset_id,
607: X_Short_Fiscal_Year_Flag => l_asset_fin_rec.short_fiscal_year_flag,
695: FA_DEPRN_SUMMARY_PKG.Update_Row
696: (X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
697: X_Asset_Id => p_asset_hdr_rec.asset_id,
698: X_Adjusted_Cost => l_asset_fin_rec.adjusted_cost,
699: X_Period_Counter => FA_CACHE_PKG.fazcbc_record.last_period_counter,
700: X_mrc_sob_type_code => p_mrc_sob_type_code,
701: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
702: X_Calling_Fn => l_calling_fn,
703: p_log_level_rec => p_log_level_rec