eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_AMORT_PVT dependencies on FA_CACHE_PKG

Line 151: where calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

147: CURSOR c_get_period_info IS
148: select start_date
149: , end_date
150: from fa_calendar_periods
151: where calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
152: and to_date (to_char (p_jdate), 'J') between start_date
153: and end_date;
154:
155: BEGIN

Line 174: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then

170: , x_period_rec.period_num;
171:
172: if (c_get_mc_deprn_period_info%NOTFOUND) then
173:
174: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
175: raise get_err;
176: end if;
177:
178: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.deprn_calendar,

Line 178: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.deprn_calendar,

174: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
175: raise get_err;
176: end if;
177:
178: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.deprn_calendar,
179: fa_cache_pkg.fazcbc_record.fiscal_year_name,
180: p_jdate,
181: x_period_rec.period_num,
182: x_period_rec.fiscal_year,

Line 179: fa_cache_pkg.fazcbc_record.fiscal_year_name,

175: raise get_err;
176: end if;
177:
178: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.deprn_calendar,
179: fa_cache_pkg.fazcbc_record.fiscal_year_name,
180: p_jdate,
181: x_period_rec.period_num,
182: x_period_rec.fiscal_year,
183: g_temp_number

Line 189: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +

185: raise get_err;
186: end if;
187:
188: x_period_rec.period_counter := x_period_rec.fiscal_year *
189: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +
190: x_period_rec.period_num;
191:
192: OPEN c_get_period_info;
193: FETCH c_get_period_info INTO x_period_rec.calendar_period_open_date,

Line 215: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then

211: , x_period_rec.period_num;
212:
213: if (c_get_deprn_period_info%NOTFOUND) then
214:
215: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
216: raise get_err;
217: end if;
218:
219: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.deprn_calendar,

Line 219: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.deprn_calendar,

215: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
216: raise get_err;
217: end if;
218:
219: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.deprn_calendar,
220: fa_cache_pkg.fazcbc_record.fiscal_year_name,
221: p_jdate,
222: x_period_rec.period_num,
223: x_period_rec.fiscal_year,

Line 220: fa_cache_pkg.fazcbc_record.fiscal_year_name,

216: raise get_err;
217: end if;
218:
219: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.deprn_calendar,
220: fa_cache_pkg.fazcbc_record.fiscal_year_name,
221: p_jdate,
222: x_period_rec.period_num,
223: x_period_rec.fiscal_year,
224: g_temp_number

Line 230: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +

226: raise get_err;
227: end if;
228:
229: x_period_rec.period_counter := x_period_rec.fiscal_year *
230: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +
231: x_period_rec.period_num;
232:
233: OPEN c_get_period_info;
234: FETCH c_get_period_info INTO x_period_rec.calendar_period_open_date,

Line 994: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

990: , 'N'
991: from fa_fiscal_year fy
992: , fa_calendar_types ct
993: , fa_calendar_periods cp
994: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
995: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
996: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
997: and ct.calendar_type = cp.calendar_type
998: and cp.start_date between fy.start_date and fy.end_date

Line 995: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

991: from fa_fiscal_year fy
992: , fa_calendar_types ct
993: , fa_calendar_periods cp
994: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
995: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
996: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
997: and ct.calendar_type = cp.calendar_type
998: and cp.start_date between fy.start_date and fy.end_date
999: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=

Line 996: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

992: , fa_calendar_types ct
993: , fa_calendar_periods cp
994: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
995: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
996: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
997: and ct.calendar_type = cp.calendar_type
998: and cp.start_date between fy.start_date and fy.end_date
999: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=
1000: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM

Line 999: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=

995: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
996: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
997: and ct.calendar_type = cp.calendar_type
998: and cp.start_date between fy.start_date and fy.end_date
999: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=
1000: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
1001: and cp.end_date >= p_asset_fin_rec.date_placed_in_service
1002: order by period_counter;
1003:

Line 2839: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY

2835: --tk_util.debug('p_asset_fin_rec_adj.adjusted_capacity: '||to_char(p_asset_fin_rec_adj.adjusted_capacity));
2836:
2837: /*
2838: if (nvl(px_asset_fin_rec_new.tracking_method, 'NO TRACK') = 'ALLOCATE') and -- ENERGY
2839: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY
2840: (fa_cache_pkg.fazccmt_record.rate_source_rule = FA_STD_TYPES.FAD_RSR_PROD) then
2841: px_asset_fin_rec_new.adjusted_capacity := nvl(px_asset_fin_rec_new.production_capacity, 0) +
2842: nvl(p_asset_fin_rec_adj.adjusted_capacity, 0);
2843: end if;

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

2836:
2837: /*
2838: if (nvl(px_asset_fin_rec_new.tracking_method, 'NO TRACK') = 'ALLOCATE') and -- ENERGY
2839: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY
2840: (fa_cache_pkg.fazccmt_record.rate_source_rule = FA_STD_TYPES.FAD_RSR_PROD) then
2841: px_asset_fin_rec_new.adjusted_capacity := nvl(px_asset_fin_rec_new.production_capacity, 0) +
2842: nvl(p_asset_fin_rec_adj.adjusted_capacity, 0);
2843: end if;
2844: */

Line 3728: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then

3724: end if;
3725:
3726: l_trx_period_rec := l_period_rec;
3727:
3728: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
3729:
3730: if (p_log_level_rec.statement_level) then
3731: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazcct'
3732: ,p_log_level_rec => p_log_level_rec);

Line 3731: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazcct'

3727:
3728: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
3729:
3730: if (p_log_level_rec.statement_level) then
3731: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazcct'
3732: ,p_log_level_rec => p_log_level_rec);
3733: end if;
3734:
3735: raise calc_failed;

Line 4565: /* if (fa_cache_pkg.fazcdbr_record.rule_name = 'uNERGY PERIOD END BALANCE') and

4561: -- fa_amort_pvt.t_reset_adjusted_cost_flag(l_bs_ind) := 'Y';
4562: -- l_temp_ind := l_bs_ind;
4563: end if;
4564:
4565: /* if (fa_cache_pkg.fazcdbr_record.rule_name = 'uNERGY PERIOD END BALANCE') and
4566: (p_asset_fin_rec_old.tracking_method = 'ALLOCATE') then
4567: l_energy_member := TRUE;
4568: end if;
4569: */

Line 4592: if (fa_cache_pkg.fazcdbr_record.rule_name = 'ENERGY PERIOD END BALANCE') and

4588: (px_asset_fin_rec_new.recognize_gain_loss = 'NO') then
4589: l_reserve_retired := px_asset_fin_rec_new.cost - p_asset_fin_rec_old.cost;
4590: end if;
4591:
4592: if (fa_cache_pkg.fazcdbr_record.rule_name = 'ENERGY PERIOD END BALANCE') and
4593: (p_asset_fin_rec_old.tracking_method = 'ALLOCATE') then
4594: -- l_proceeds_of_sale and l_cost_of_removal has -1 multiplied in cursor c_get_rein_info
4595: -- so that it can be added whether the trx is ret or rein later when maintaining
4596: -- ytd and ltd for books summary table.

Line 4985: nvl(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') = 'Y') or

4981: fa_amort_pvt.t_reset_adjusted_cost_flag(i) := 'N';
4982:
4983: if (i = 2) then
4984: if (fa_amort_pvt.t_period_num(i) = 1 and
4985: nvl(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') = 'Y') or
4986: (nvl(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'Y') or
4987: ((nvl(fa_amort_pvt.t_change_in_cost(i), 0) <> 0) or
4988: (nvl(fa_amort_pvt.t_change_in_cip_cost(i), 0) <> 0)) then
4989:

Line 4986: (nvl(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'Y') or

4982:
4983: if (i = 2) then
4984: if (fa_amort_pvt.t_period_num(i) = 1 and
4985: nvl(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') = 'Y') or
4986: (nvl(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'Y') or
4987: ((nvl(fa_amort_pvt.t_change_in_cost(i), 0) <> 0) or
4988: (nvl(fa_amort_pvt.t_change_in_cip_cost(i), 0) <> 0)) then
4989:
4990: fa_amort_pvt.t_reset_adjusted_cost_flag(i) := 'Y';

Line 5303: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

5299: l_asset_fin_rec_new.formula_factor := fa_amort_pvt.t_formula_factor(i);
5300: l_asset_fin_rec_new.super_group_id := fa_amort_pvt.t_super_group_id(i);
5301:
5302: l_dpr_in.asset_num := p_asset_desc_rec.asset_number;
5303: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
5304: l_dpr_in.book := p_asset_hdr_rec.book_type_code;
5305: l_dpr_in.asset_id := p_asset_hdr_rec.asset_id;
5306:
5307: l_dpr_in.adj_cost := fa_amort_pvt.t_recoverable_cost(i);

Line 5395: if (not fa_cache_pkg.fazccmt(

5391: --
5392: l_running_mode := fa_std_types.FA_DPR_NORMAL;
5393:
5394:
5395: if (not fa_cache_pkg.fazccmt(
5396: fa_amort_pvt.t_deprn_method_code(i),
5397: fa_amort_pvt.t_life_in_months(i))) then
5398: if (p_log_level_rec.statement_level) then
5399: fa_debug_pkg.add(l_calling_fn, 'Error calling',

Line 5400: 'fa_cache_pkg.fazccmt'

5396: fa_amort_pvt.t_deprn_method_code(i),
5397: fa_amort_pvt.t_life_in_months(i))) then
5398: if (p_log_level_rec.statement_level) then
5399: fa_debug_pkg.add(l_calling_fn, 'Error calling',
5400: 'fa_cache_pkg.fazccmt'
5401: ,p_log_level_rec => p_log_level_rec);
5402: end if;
5403:
5404: raise calc_failed;

Line 5408: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,

5404: raise calc_failed;
5405: end if;
5406:
5407: if i = 1 then
5408: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
5409: fa_cache_pkg.fazcbc_record.fiscal_year_name,
5410: l_dpr_in.prorate_jdate,
5411: g_temp_number,
5412: l_dpr_in.y_begin,

Line 5409: fa_cache_pkg.fazcbc_record.fiscal_year_name,

5405: end if;
5406:
5407: if i = 1 then
5408: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
5409: fa_cache_pkg.fazcbc_record.fiscal_year_name,
5410: l_dpr_in.prorate_jdate,
5411: g_temp_number,
5412: l_dpr_in.y_begin,
5413: g_temp_integer

Line 5417: 'fa_cache_pkg.fazccp'

5413: g_temp_integer
5414: ,p_log_level_rec => p_log_level_rec) then
5415: if (p_log_level_rec.statement_level) then
5416: fa_debug_pkg.add(l_calling_fn, 'Error calling',
5417: 'fa_cache_pkg.fazccp'
5418: ,p_log_level_rec => p_log_level_rec);
5419: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
5420: fa_cache_pkg.fazcbc_record.prorate_calendar
5421: ,p_log_level_rec => p_log_level_rec);

Line 5419: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',

5415: if (p_log_level_rec.statement_level) then
5416: fa_debug_pkg.add(l_calling_fn, 'Error calling',
5417: 'fa_cache_pkg.fazccp'
5418: ,p_log_level_rec => p_log_level_rec);
5419: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
5420: fa_cache_pkg.fazcbc_record.prorate_calendar
5421: ,p_log_level_rec => p_log_level_rec);
5422: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
5423: fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 5420: fa_cache_pkg.fazcbc_record.prorate_calendar

5416: fa_debug_pkg.add(l_calling_fn, 'Error calling',
5417: 'fa_cache_pkg.fazccp'
5418: ,p_log_level_rec => p_log_level_rec);
5419: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
5420: fa_cache_pkg.fazcbc_record.prorate_calendar
5421: ,p_log_level_rec => p_log_level_rec);
5422: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
5423: fa_cache_pkg.fazcbc_record.fiscal_year_name
5424: ,p_log_level_rec => p_log_level_rec);

Line 5422: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

5418: ,p_log_level_rec => p_log_level_rec);
5419: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
5420: fa_cache_pkg.fazcbc_record.prorate_calendar
5421: ,p_log_level_rec => p_log_level_rec);
5422: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
5423: fa_cache_pkg.fazcbc_record.fiscal_year_name
5424: ,p_log_level_rec => p_log_level_rec);
5425:
5426: end if;

Line 5423: fa_cache_pkg.fazcbc_record.fiscal_year_name

5419: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
5420: fa_cache_pkg.fazcbc_record.prorate_calendar
5421: ,p_log_level_rec => p_log_level_rec);
5422: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
5423: fa_cache_pkg.fazcbc_record.fiscal_year_name
5424: ,p_log_level_rec => p_log_level_rec);
5425:
5426: end if;
5427:

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

5439: -- Skip faxcde call for raf
5440: -- If rate source rule is FLAT and depreciable basis is Cost
5441: -- Bug4778244 Added the NVL to avoid condition if(not(null or false)) which will
5442: -- always return NULL in place of FALSE, which is incorrect
5443: if (not(((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
5444: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule, ' ') = fa_std_types.FAD_DBR_COST) and
5445: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',
5446: 'PERIOD END AVERAGE',
5447: 'USE RECOVERABLE COST',

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

5440: -- If rate source rule is FLAT and depreciable basis is Cost
5441: -- Bug4778244 Added the NVL to avoid condition if(not(null or false)) which will
5442: -- always return NULL in place of FALSE, which is incorrect
5443: if (not(((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
5444: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule, ' ') = fa_std_types.FAD_DBR_COST) and
5445: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',
5446: 'PERIOD END AVERAGE',
5447: 'USE RECOVERABLE COST',
5448: 'BEGINNING PERIOD'))) or

Line 5445: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',

5441: -- Bug4778244 Added the NVL to avoid condition if(not(null or false)) which will
5442: -- always return NULL in place of FALSE, which is incorrect
5443: if (not(((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
5444: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule, ' ') = fa_std_types.FAD_DBR_COST) and
5445: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',
5446: 'PERIOD END AVERAGE',
5447: 'USE RECOVERABLE COST',
5448: 'BEGINNING PERIOD'))) or
5449: (nvl(l_trans_rec.transaction_key,'X') = 'ES') -- Japan Tax Phase3

Line 5452: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,

5448: 'BEGINNING PERIOD'))) or
5449: (nvl(l_trans_rec.transaction_key,'X') = 'ES') -- Japan Tax Phase3
5450: )) then
5451:
5452: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
5453: fa_cache_pkg.fazcbc_record.fiscal_year_name,
5454: l_dpr_in.prorate_jdate,
5455: g_temp_number,
5456: l_dpr_in.y_begin,

Line 5453: fa_cache_pkg.fazcbc_record.fiscal_year_name,

5449: (nvl(l_trans_rec.transaction_key,'X') = 'ES') -- Japan Tax Phase3
5450: )) then
5451:
5452: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
5453: fa_cache_pkg.fazcbc_record.fiscal_year_name,
5454: l_dpr_in.prorate_jdate,
5455: g_temp_number,
5456: l_dpr_in.y_begin,
5457: g_temp_integer

Line 5461: 'fa_cache_pkg.fazccp'

5457: g_temp_integer
5458: ,p_log_level_rec => p_log_level_rec) then
5459: if (p_log_level_rec.statement_level) then
5460: fa_debug_pkg.add(l_calling_fn, 'Error calling',
5461: 'fa_cache_pkg.fazccp'
5462: ,p_log_level_rec => p_log_level_rec);
5463: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
5464: fa_cache_pkg.fazcbc_record.prorate_calendar
5465: ,p_log_level_rec => p_log_level_rec);

Line 5463: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',

5459: if (p_log_level_rec.statement_level) then
5460: fa_debug_pkg.add(l_calling_fn, 'Error calling',
5461: 'fa_cache_pkg.fazccp'
5462: ,p_log_level_rec => p_log_level_rec);
5463: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
5464: fa_cache_pkg.fazcbc_record.prorate_calendar
5465: ,p_log_level_rec => p_log_level_rec);
5466: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
5467: fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 5464: fa_cache_pkg.fazcbc_record.prorate_calendar

5460: fa_debug_pkg.add(l_calling_fn, 'Error calling',
5461: 'fa_cache_pkg.fazccp'
5462: ,p_log_level_rec => p_log_level_rec);
5463: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
5464: fa_cache_pkg.fazcbc_record.prorate_calendar
5465: ,p_log_level_rec => p_log_level_rec);
5466: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
5467: fa_cache_pkg.fazcbc_record.fiscal_year_name
5468: ,p_log_level_rec => p_log_level_rec);

Line 5466: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

5462: ,p_log_level_rec => p_log_level_rec);
5463: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
5464: fa_cache_pkg.fazcbc_record.prorate_calendar
5465: ,p_log_level_rec => p_log_level_rec);
5466: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
5467: fa_cache_pkg.fazcbc_record.fiscal_year_name
5468: ,p_log_level_rec => p_log_level_rec);
5469:
5470: end if;

Line 5467: fa_cache_pkg.fazcbc_record.fiscal_year_name

5463: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
5464: fa_cache_pkg.fazcbc_record.prorate_calendar
5465: ,p_log_level_rec => p_log_level_rec);
5466: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
5467: fa_cache_pkg.fazcbc_record.fiscal_year_name
5468: ,p_log_level_rec => p_log_level_rec);
5469:
5470: end if;
5471:

Line 5479: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

5475: l_dpr_in.p_cl_begin := 1;
5476:
5477: if (fa_amort_pvt.t_period_num(i) = 1) then
5478: l_dpr_in.y_end := fa_amort_pvt.t_fiscal_year(i) - 1;
5479: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
5480: else
5481: l_dpr_in.y_end := fa_amort_pvt.t_fiscal_year(i);
5482: l_dpr_in.p_cl_end := fa_amort_pvt.t_period_num(i) - 1;
5483: end if;

Line 5488: if fa_cache_pkg.fa_deprn_override_enabled then

5484:
5485: l_dpr_in.rate_adj_factor := 1;
5486:
5487: -- manual override
5488: if fa_cache_pkg.fa_deprn_override_enabled then
5489:
5490: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
5491: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
5492:

Line 5490: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

5486:
5487: -- manual override
5488: if fa_cache_pkg.fa_deprn_override_enabled then
5489:
5490: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
5491: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
5492:
5493: -- update override status only if satisfies condintion,
5494: -- otherwise do not update status when calculating RAF

Line 5491: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

5487: -- manual override
5488: if fa_cache_pkg.fa_deprn_override_enabled then
5489:
5490: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
5491: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
5492:
5493: -- update override status only if satisfies condintion,
5494: -- otherwise do not update status when calculating RAF
5495: -- 1. formula; or

Line 5569: if fa_cache_pkg.fa_deprn_override_enabled then

5565: ,p_log_level_rec => p_log_level_rec);
5566: end if;
5567:
5568: -- manual override
5569: if fa_cache_pkg.fa_deprn_override_enabled then
5570: if l_dpr_in.update_override_status then
5571: p_trans_rec.deprn_override_flag := l_dpr_out.deprn_override_flag;
5572: else
5573: p_trans_rec.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;

Line 5650: l_recalc_start_period_num := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

5646:
5647: l_no_allocation_for_last := 'N';
5648: if fa_amort_pvt.t_period_num(i) = 1 then
5649: l_recalc_start_fy := fa_amort_pvt.t_fiscal_year(i) - 1;
5650: l_recalc_start_period_num := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
5651: else
5652: l_recalc_start_fy := fa_amort_pvt.t_fiscal_year(i);
5653: l_recalc_start_period_num := fa_amort_pvt.t_period_num(i) - 1;
5654: end if;

Line 5707: if l_old_recalc_end_period_num = fa_cache_pkg.fazcct_record.number_per_fiscal_year then

5703: ,p_log_level_rec => p_log_level_rec);
5704: end if;
5705:
5706: if l_old_recalc_end_fy is not NULL and l_old_recalc_end_period_num is not NULL then
5707: if l_old_recalc_end_period_num = fa_cache_pkg.fazcct_record.number_per_fiscal_year then
5708: l_old_recalc_end_fy := l_old_recalc_end_fy + 1;
5709: l_old_recalc_end_period_num := 1;
5710: else
5711: l_old_recalc_end_period_num := l_old_recalc_end_period_num + 1;

Line 5724: l_recalc_start_period_counter := l_recalc_start_fy*(fa_cache_pkg.fazcct_record.number_per_fiscal_year)

5720: end if;
5721:
5722: --* Calcualte recalc_start_period_counter
5723: if (l_first_process) then
5724: l_recalc_start_period_counter := l_recalc_start_fy*(fa_cache_pkg.fazcct_record.number_per_fiscal_year)
5725: + l_recalc_start_period_num;
5726:
5727: if p_mrc_sob_type_code <> 'R' then
5728: open c_chk_bs_row_exists;

Line 5903: if (fa_cache_pkg.fazcdbr_record.rule_name = 'ENERGY PERIOD END BALANCE') and

5899: -- excess_allocation_option
5900: -- depreciation_option
5901: -- member_rollup_flag
5902:
5903: if (fa_cache_pkg.fazcdbr_record.rule_name = 'ENERGY PERIOD END BALANCE') and
5904: (p_asset_fin_rec_old.tracking_method = 'ALLOCATE') and
5905: (p_trans_rec.transaction_key = 'MS') then
5906: l_reserve_retired := 0;
5907: end if;

Line 6080: l_period_num := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

6076: ((td_deprn_limit_amount(e) - td_deprn_limit_amount(e - 1)) <> 0) then
6077:
6078: if (fa_amort_pvt.t_period_num(j) = 1) then
6079: l_fiscal_year := fa_amort_pvt.t_fiscal_year(j) - 1;
6080: l_period_num := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
6081: else
6082: l_fiscal_year := fa_amort_pvt.t_fiscal_year(j);
6083: l_period_num := fa_amort_pvt.t_period_num(j) - 1;
6084: end if;

Line 6101: l_period_num := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

6097: if (fa_amort_pvt.t_reset_adjusted_cost_flag(j) = 'Y') or
6098: (j = (l_count)) then
6099: if (fa_amort_pvt.t_period_num(j) = 1) then
6100: l_fiscal_year := fa_amort_pvt.t_fiscal_year(j) - 1;
6101: l_period_num := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
6102: else
6103: l_fiscal_year := fa_amort_pvt.t_fiscal_year(j);
6104: l_period_num := fa_amort_pvt.t_period_num(j) - 1;
6105: end if;

Line 6155: if fa_cache_pkg.fa_deprn_override_enabled then

6151: --tk_util.debug('l_dpr_in.super_group_id: '||to_char(l_dpr_in.super_group_id));
6152: l_dpr_in.cost := l_asset_fin_rec_new.cost;
6153:
6154: -- manual override
6155: if fa_cache_pkg.fa_deprn_override_enabled then
6156: l_dpr_in.update_override_status := TRUE;
6157: end if;
6158:
6159: --

Line 6189: if fa_cache_pkg.fa_deprn_override_enabled then

6185: ,p_log_level_rec => p_log_level_rec);
6186: end if;
6187:
6188: -- manual override
6189: if fa_cache_pkg.fa_deprn_override_enabled then
6190: p_trans_rec.deprn_override_flag := l_dpr_out.deprn_override_flag;
6191: end if;
6192:
6193: if (l_asset_fin_rec_new.adjusted_cost <> 0) or

Line 6360: if (l_count > fa_cache_pkg.fazcct_record.number_per_fiscal_year) then

6356: --
6357: -- Need to reset eofy and eop rec cost and salvage value
6358: -- for deprn basis call
6359: --
6360: if (l_count > fa_cache_pkg.fazcct_record.number_per_fiscal_year) then
6361: l_eofy_rec_cost := fa_amort_pvt.t_recoverable_cost(l_count - fa_amort_pvt.t_period_num(l_count));
6362: l_eofy_sal_val := fa_amort_pvt.t_salvage_value(l_count - fa_amort_pvt.t_period_num(l_count));
6363:
6364: if (l_count > 1) then

Line 7554: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

7550: and ds.book_type_code = p_asset_hdr_rec.book_type_code
7551: and ds.deprn_source_code = 'BOOKS'
7552: and dp.book_type_code = p_asset_hdr_rec.book_type_code
7553: and dp.period_counter = ds.period_counter
7554: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
7555: and fy.fiscal_year = (dp.period_counter - dp.period_num)/fa_cache_pkg.fazcct_record.number_per_fiscal_year
7556: and fy.fiscal_year = (p_period_rec.period_counter + 1 - p_period_rec.period_num)/
7557: fa_cache_pkg.fazcct_record.number_per_fiscal_year;
7558:

Line 7555: and fy.fiscal_year = (dp.period_counter - dp.period_num)/fa_cache_pkg.fazcct_record.number_per_fiscal_year

7551: and ds.deprn_source_code = 'BOOKS'
7552: and dp.book_type_code = p_asset_hdr_rec.book_type_code
7553: and dp.period_counter = ds.period_counter
7554: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
7555: and fy.fiscal_year = (dp.period_counter - dp.period_num)/fa_cache_pkg.fazcct_record.number_per_fiscal_year
7556: and fy.fiscal_year = (p_period_rec.period_counter + 1 - p_period_rec.period_num)/
7557: fa_cache_pkg.fazcct_record.number_per_fiscal_year;
7558:
7559: CURSOR c_get_adjs IS

Line 7557: fa_cache_pkg.fazcct_record.number_per_fiscal_year;

7553: and dp.period_counter = ds.period_counter
7554: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
7555: and fy.fiscal_year = (dp.period_counter - dp.period_num)/fa_cache_pkg.fazcct_record.number_per_fiscal_year
7556: and fy.fiscal_year = (p_period_rec.period_counter + 1 - p_period_rec.period_num)/
7557: fa_cache_pkg.fazcct_record.number_per_fiscal_year;
7558:
7559: CURSOR c_get_adjs IS
7560: SELECT NVL(SUM(DECODE(ADJ.ADJUSTMENT_TYPE,
7561: 'RESERVE',

Line 7586: DECODE(fa_cache_pkg.fazcbc_record.book_class,'TAX',

7582: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT))),
7583: 0),
7584: NVL(SUM(DECODE(ADJ.ADJUSTMENT_TYPE,
7585: 'DEPRN ADJUST',
7586: DECODE(fa_cache_pkg.fazcbc_record.book_class,'TAX',
7587: DECODE(ADJ.DEBIT_CREDIT_FLAG,
7588: 'DR', ADJ.ADJUSTMENT_AMOUNT,
7589: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT)))),
7590: 0),

Line 7673: DECODE(fa_cache_pkg.fazcbc_record.book_class,'TAX',

7669: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT))),
7670: 0),
7671: NVL(SUM(DECODE(ADJ.ADJUSTMENT_TYPE,
7672: 'DEPRN ADJUST',
7673: DECODE(fa_cache_pkg.fazcbc_record.book_class,'TAX',
7674: DECODE(ADJ.DEBIT_CREDIT_FLAG,
7675: 'DR', ADJ.ADJUSTMENT_AMOUNT,
7676: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT)))),
7677: 0),

Line 10861: fa_cache_pkg.fazccbd_record.prorate_convention_code));

10857: --
10858: x_asset_fin_rec_new.prorate_convention_code :=
10859: nvl(l_asset_fin_rec_adj.prorate_convention_code,
10860: nvl(px_asset_fin_rec.prorate_convention_code,
10861: fa_cache_pkg.fazccbd_record.prorate_convention_code));
10862:
10863: x_asset_fin_rec_new.depreciate_flag :=
10864: nvl(l_asset_fin_rec_adj.depreciate_flag,
10865: nvl(px_asset_fin_rec.depreciate_flag,

Line 10866: fa_cache_pkg.fazccbd_record.depreciate_flag));

10862:
10863: x_asset_fin_rec_new.depreciate_flag :=
10864: nvl(l_asset_fin_rec_adj.depreciate_flag,
10865: nvl(px_asset_fin_rec.depreciate_flag,
10866: fa_cache_pkg.fazccbd_record.depreciate_flag));
10867:
10868: FA_UTIL_PVT.load_char_value
10869: (p_char_old => px_asset_fin_rec.bonus_rule,
10870: p_char_adj => l_asset_fin_rec_adj.bonus_rule,

Line 11065: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX' and

11061: end if;
11062: --tk_util.debug('adj_rec_cost: '|| to_char(x_asset_fin_rec_new.adjusted_recoverable_cost));
11063:
11064:
11065: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX' and
11066: x_asset_fin_rec_new.itc_amount_id is not null) then
11067: if not FA_ASSET_CALC_PVT.calc_itc_info
11068: (p_asset_hdr_rec => p_asset_hdr_rec,
11069: p_asset_fin_rec_adj => l_asset_fin_rec_adj,

Line 11488: and cp.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar

11484: -- and (ret.transaction_header_id_out is null or
11485: -- ret.transaction_header_id_out = l_incoming_thid)
11486: and ret.RETIREMENT_PRORATE_CONVENTION = con.PRORATE_CONVENTION_CODE
11487: and ret.date_retired between con.start_date and con.end_date
11488: and cp.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar
11489: and con.prorate_date between cp.start_date and cp.end_date
11490: and th.transaction_type_code in (G_TRX_TYPE_FUL_RET, G_TRX_TYPE_PAR_RET)
11491: -- and th.transaction_header_id >= c_transaction_header_id
11492: and th.transaction_header_id <> l_incoming_thid

Line 11493: and cptrx.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

11489: and con.prorate_date between cp.start_date and cp.end_date
11490: and th.transaction_type_code in (G_TRX_TYPE_FUL_RET, G_TRX_TYPE_PAR_RET)
11491: -- and th.transaction_header_id >= c_transaction_header_id
11492: and th.transaction_header_id <> l_incoming_thid
11493: and cptrx.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
11494: and ret.date_retired between cptrx.start_date and cptrx.end_date
11495: and th.transaction_header_id = ret.transaction_header_id_in
11496: --bug4363712
11497: -- and con.prorate_date >= c_transaction_date_entered

Line 12371: if (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y') /*and

12367: if ((p_asset_fin_rec_old.group_asset_id is null and
12368: px_asset_fin_rec_new.group_asset_id is null)) or
12369: (l_trans_rec.transaction_type_code like '%RETIREMENT') then -- ENERGY
12370:
12371: if (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y') /*and
12372: (p_asset_fin_rec_old.group_asset_id is null and -- ENERGY
12373: px_asset_fin_rec_new.group_asset_id is null) */ then -- ENERGY
12374: if not GetEofyReserve(
12375: p_trans_rec => l_trans_rec,

Line 12404: if (nvl(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'N') or

12400: fa_debug_pkg.add(l_calling_fn, '========== Recalc Step 3.3 ==========','', p_log_level_rec);
12401: end if;
12402:
12403:
12404: if (nvl(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'N') or
12405: (l_eofy_reserve is not null) then
12406: --adding the following code for bug no.4016503
12407: --the retirement transaction is ignored during recalculate
12408: -- if it is reinstated by any following transaction.

Line 12812: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

12808:
12809: --tk_util.DumpDeprnRec(l_asset_deprn_rec, 'GD');
12810:
12811: l_dpr_in.asset_num := p_asset_desc_rec.asset_number;
12812: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
12813: l_dpr_in.book := p_asset_hdr_rec.book_type_code;
12814: l_dpr_in.asset_id := p_asset_hdr_rec.asset_id;
12815:
12816: --

Line 13253: if (not fa_cache_pkg.fazccmt(

13249: --tk_util.debug('2 rec_cost: '||to_char(px_asset_fin_rec_new.recoverable_cost));
13250:
13251: if (l_process_this_trx) then
13252:
13253: if (not fa_cache_pkg.fazccmt(
13254: l_asset_fin_rec_new.deprn_method_code,
13255: l_asset_fin_rec_new.life_in_months
13256: ,p_log_level_rec => p_log_level_rec)) then
13257: if (p_log_level_rec.statement_level) then

Line 13259: 'fa_cache_pkg.fazccmt'

13255: l_asset_fin_rec_new.life_in_months
13256: ,p_log_level_rec => p_log_level_rec)) then
13257: if (p_log_level_rec.statement_level) then
13258: fa_debug_pkg.add(l_calling_fn, 'Error calling',
13259: 'fa_cache_pkg.fazccmt'
13260: ,p_log_level_rec => p_log_level_rec);
13261: end if;
13262:
13263: raise calc_failed;

Line 13267: --tk_util.debug('fa_cache_pkg.fazcdbr_record.rule_name: ' ||fa_cache_pkg.fazcdbr_record.rule_name);

13263: raise calc_failed;
13264: end if;
13265:
13266: l_energy_member := FALSE;
13267: --tk_util.debug('fa_cache_pkg.fazcdbr_record.rule_name: ' ||fa_cache_pkg.fazcdbr_record.rule_name);
13268: --tk_util.debug('p_asset_fin_rec_old.tracking_method: '||p_asset_fin_rec_old.tracking_method);
13269: --
13270: -- Set l_energy_member to skip periodic depreciation call in this functioin
13271: --

Line 13272: if (fa_cache_pkg.fazcdbr_record.rule_name = 'ENERGY PERIOD END BALANCE') and

13268: --tk_util.debug('p_asset_fin_rec_old.tracking_method: '||p_asset_fin_rec_old.tracking_method);
13269: --
13270: -- Set l_energy_member to skip periodic depreciation call in this functioin
13271: --
13272: if (fa_cache_pkg.fazcdbr_record.rule_name = 'ENERGY PERIOD END BALANCE') and
13273: (p_asset_fin_rec_old.tracking_method = 'ALLOCATE') then
13274: l_energy_member := TRUE;
13275: end if;
13276:

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

13276:
13277: -- skip faxcde call for raf
13278: -- Bug4778244 Added the NVL to avoid condition if(not(null or false)) which will
13279: -- always return NULL in place of FALSE, which is incorrect
13280: if (not(((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
13281: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule, ' ') = fa_std_types.FAD_DBR_COST) and
13282: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',
13283: 'PERIOD END AVERAGE',
13284: 'USE RECOVERABLE COST',

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

13277: -- skip faxcde call for raf
13278: -- Bug4778244 Added the NVL to avoid condition if(not(null or false)) which will
13279: -- always return NULL in place of FALSE, which is incorrect
13280: if (not(((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
13281: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule, ' ') = fa_std_types.FAD_DBR_COST) and
13282: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',
13283: 'PERIOD END AVERAGE',
13284: 'USE RECOVERABLE COST',
13285: 'BEGINNING PERIOD'))) or

Line 13282: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',

13278: -- Bug4778244 Added the NVL to avoid condition if(not(null or false)) which will
13279: -- always return NULL in place of FALSE, which is incorrect
13280: if (not(((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
13281: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule, ' ') = fa_std_types.FAD_DBR_COST) and
13282: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',
13283: 'PERIOD END AVERAGE',
13284: 'USE RECOVERABLE COST',
13285: 'BEGINNING PERIOD'))) or
13286: ((nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') = 'ENERGY PERIOD END BALANCE') and

Line 13286: ((nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') = 'ENERGY PERIOD END BALANCE') and

13282: (nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') in ('PERIOD END BALANCE',
13283: 'PERIOD END AVERAGE',
13284: 'USE RECOVERABLE COST',
13285: 'BEGINNING PERIOD'))) or
13286: ((nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') = 'ENERGY PERIOD END BALANCE') and
13287: (nvl(p_asset_fin_rec_old.tracking_method, ' ') = 'ALLOCATE')))) then
13288: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
13289: fa_cache_pkg.fazcbc_record.fiscal_year_name,
13290: l_dpr_in.prorate_jdate,

Line 13288: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,

13284: 'USE RECOVERABLE COST',
13285: 'BEGINNING PERIOD'))) or
13286: ((nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') = 'ENERGY PERIOD END BALANCE') and
13287: (nvl(p_asset_fin_rec_old.tracking_method, ' ') = 'ALLOCATE')))) then
13288: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
13289: fa_cache_pkg.fazcbc_record.fiscal_year_name,
13290: l_dpr_in.prorate_jdate,
13291: g_temp_number,
13292: l_dpr_in.y_begin,

Line 13289: fa_cache_pkg.fazcbc_record.fiscal_year_name,

13285: 'BEGINNING PERIOD'))) or
13286: ((nvl(fa_cache_pkg.fazcdbr_record.rule_name, ' ') = 'ENERGY PERIOD END BALANCE') and
13287: (nvl(p_asset_fin_rec_old.tracking_method, ' ') = 'ALLOCATE')))) then
13288: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
13289: fa_cache_pkg.fazcbc_record.fiscal_year_name,
13290: l_dpr_in.prorate_jdate,
13291: g_temp_number,
13292: l_dpr_in.y_begin,
13293: g_temp_integer

Line 13297: 'fa_cache_pkg.fazccp'

13293: g_temp_integer
13294: ,p_log_level_rec => p_log_level_rec) then
13295: if (p_log_level_rec.statement_level) then
13296: fa_debug_pkg.add(l_calling_fn, 'Error calling',
13297: 'fa_cache_pkg.fazccp'
13298: ,p_log_level_rec => p_log_level_rec);
13299: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
13300: fa_cache_pkg.fazcbc_record.prorate_calendar
13301: ,p_log_level_rec => p_log_level_rec);

Line 13299: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',

13295: if (p_log_level_rec.statement_level) then
13296: fa_debug_pkg.add(l_calling_fn, 'Error calling',
13297: 'fa_cache_pkg.fazccp'
13298: ,p_log_level_rec => p_log_level_rec);
13299: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
13300: fa_cache_pkg.fazcbc_record.prorate_calendar
13301: ,p_log_level_rec => p_log_level_rec);
13302: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
13303: fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 13300: fa_cache_pkg.fazcbc_record.prorate_calendar

13296: fa_debug_pkg.add(l_calling_fn, 'Error calling',
13297: 'fa_cache_pkg.fazccp'
13298: ,p_log_level_rec => p_log_level_rec);
13299: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
13300: fa_cache_pkg.fazcbc_record.prorate_calendar
13301: ,p_log_level_rec => p_log_level_rec);
13302: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
13303: fa_cache_pkg.fazcbc_record.fiscal_year_name
13304: ,p_log_level_rec => p_log_level_rec);

Line 13302: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

13298: ,p_log_level_rec => p_log_level_rec);
13299: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
13300: fa_cache_pkg.fazcbc_record.prorate_calendar
13301: ,p_log_level_rec => p_log_level_rec);
13302: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
13303: fa_cache_pkg.fazcbc_record.fiscal_year_name
13304: ,p_log_level_rec => p_log_level_rec);
13305:
13306: end if;

Line 13303: fa_cache_pkg.fazcbc_record.fiscal_year_name

13299: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
13300: fa_cache_pkg.fazcbc_record.prorate_calendar
13301: ,p_log_level_rec => p_log_level_rec);
13302: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
13303: fa_cache_pkg.fazcbc_record.fiscal_year_name
13304: ,p_log_level_rec => p_log_level_rec);
13305:
13306: end if;
13307:

Line 13311: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then

13307:
13308: raise calc_failed;
13309: end if;
13310:
13311: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
13312: raise calc_failed;
13313: end if;
13314:
13315: l_dpr_in.p_cl_begin := 1;

Line 13319: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

13315: l_dpr_in.p_cl_begin := 1;
13316:
13317: if (l_period_rec.period_num = 1) then
13318: l_dpr_in.y_end := l_period_rec.fiscal_year - 1;
13319: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
13320: else
13321: l_dpr_in.y_end := l_period_rec.fiscal_year;
13322: l_dpr_in.p_cl_end := l_period_rec.period_num - 1;
13323: end if;

Line 13329: if fa_cache_pkg.fa_deprn_override_enabled then

13325: l_dpr_in.rate_adj_factor := 1;
13326: l_dpr_in.eofy_reserve := 0;
13327:
13328: -- manual override
13329: if fa_cache_pkg.fa_deprn_override_enabled then
13330:
13331: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
13332: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
13333:

Line 13331: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

13327:
13328: -- manual override
13329: if fa_cache_pkg.fa_deprn_override_enabled then
13330:
13331: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
13332: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
13333:
13334: -- update override status only if satisfies condintion,
13335: -- otherwise do not update status when calculating RAF

Line 13332: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

13328: -- manual override
13329: if fa_cache_pkg.fa_deprn_override_enabled then
13330:
13331: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
13332: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
13333:
13334: -- update override status only if satisfies condintion,
13335: -- otherwise do not update status when calculating RAF
13336: -- 1. formula; or

Line 13400: if fa_cache_pkg.fa_deprn_override_enabled then

13396: ,p_log_level_rec => p_log_level_rec);
13397: end if;
13398:
13399: -- manual override
13400: if fa_cache_pkg.fa_deprn_override_enabled then
13401: if l_dpr_in.update_override_status then
13402: p_trans_rec.deprn_override_flag := l_dpr_out.deprn_override_flag;
13403: else
13404: p_trans_rec.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;

Line 13799: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

13795: -- Set FA_STD_TYPES.dpr_struct for depreciation(faxcde) call.
13796: --
13797: if (nvl(l_next_period_rec.period_counter, p_period_rec.period_counter) = 1) then
13798: l_dpr_in.y_end := nvl(l_next_period_rec.fiscal_year, p_period_rec.fiscal_year) - 1;
13799: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
13800: else
13801: l_dpr_in.y_end := nvl(l_next_period_rec.fiscal_year, p_period_rec.fiscal_year);
13802: l_dpr_in.p_cl_end := nvl(l_next_period_rec.period_num, p_period_rec.period_num) - 1;
13803: end if;

Line 13816: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

13812: -- until last period.
13813: --
13814: if (p_period_rec.period_num = 1) then
13815: l_dpr_in.y_end := p_period_rec.fiscal_year - 1;
13816: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
13817: else
13818: l_dpr_in.y_end := p_period_rec.fiscal_year;
13819: l_dpr_in.p_cl_end := p_period_rec.period_num - 1;
13820: end if;

Line 13846: if fa_cache_pkg.fa_deprn_override_enabled then

13842: l_dpr_in.super_group_id := l_asset_fin_rec_new.super_group_id;
13843: l_dpr_in.cost := l_asset_fin_rec_new.cost;
13844:
13845: -- manual override
13846: if fa_cache_pkg.fa_deprn_override_enabled then
13847: l_dpr_in.update_override_status := TRUE;
13848: end if;
13849:
13850: -- Bug fix 5948890

Line 13906: if fa_cache_pkg.fa_deprn_override_enabled then

13902: end if;
13903:
13904:
13905: -- manual override
13906: if fa_cache_pkg.fa_deprn_override_enabled then
13907: p_trans_rec.deprn_override_flag := l_dpr_out.deprn_override_flag;
13908: end if;
13909:
13910: if (l_asset_fin_rec_new.adjusted_cost <> 0)or

Line 14451: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY

14447:
14448: --
14449: -- Energy: Need to reinstate member reserve entry cre
14450: if (nvl(p_asset_fin_rec_old.tracking_method, 'NO TRACK') = 'ALLOCATE') and -- ENERGY
14451: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY
14452: (px_trans_rec.transaction_type_code = 'REINSTATEMENT') then -- ENERGY
14453: if (p_log_level_rec.statement_level) then
14454: fa_debug_pkg.add(l_calling_fn, 'calling function ',
14455: 'FA_AMORT_PVT.calc_raf_adj_cost'

Line 14777: if (not fa_cache_pkg.fazccmt(p_method_code,

14773: ,p_log_level_rec => p_log_level_rec);
14774: return false;
14775: end if;
14776:
14777: if (not fa_cache_pkg.fazccmt(p_method_code,
14778: p_life
14779: ,p_log_level_rec => p_log_level_rec)) then
14780: fa_srvr_msg.add_message(calling_fn => 'FA_AMORT_PKG.faxnac'
14781: ,p_log_level_rec => p_log_level_rec);

Line 14785: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule_id;

14781: ,p_log_level_rec => p_log_level_rec);
14782: return false;
14783: end if;
14784:
14785: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule_id;
14786:
14787: if l_deprn_basis_formula is null then
14788: return true;
14789: end if;

Line 14793: if (not fa_cache_pkg.fazccmt(p_method_code,

14789: end if;
14790:
14791: -- if l_deprn_basis_formula = fa_std_types.FAD_DBF_FLAT then
14792: if l_deprn_basis_formula = 'STRICT_FLAT' then
14793: if (not fa_cache_pkg.fazccmt(p_method_code,
14794: p_life
14795: ,p_log_level_rec => p_log_level_rec)) then
14796: fa_srvr_msg.add_message(calling_fn => 'FA_AMORT_PKG.faxnac'
14797: ,p_log_level_rec => p_log_level_rec);

Line 14801: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

14797: ,p_log_level_rec => p_log_level_rec);
14798: return false;
14799: end if;
14800:
14801: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
14802: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
14803:
14804: if l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FLAT and
14805: l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_COST then

Line 14802: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

14798: return false;
14799: end if;
14800:
14801: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
14802: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
14803:
14804: if l_rate_source_rule = FA_STD_TYPES.FAD_RSR_FLAT and
14805: l_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_COST then
14806: if p_rec_cost is null then

Line 14934: if (not FA_CACHE_PKG.fazccmt

14930: value => px_asset_fin_rec_new.life_in_months
14931: ,p_log_level_rec => p_log_level_rec);
14932: end if;
14933:
14934: if (not FA_CACHE_PKG.fazccmt
14935: (px_asset_fin_rec_new.deprn_method_code,
14936: px_asset_fin_rec_new.life_in_months
14937: ,p_log_level_rec => p_log_level_rec)) then
14938: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_AMORT_PKG.faxraf'

Line 14943: l_method_id := fa_cache_pkg.fazccmt_record.method_id;

14939: ,p_log_level_rec => p_log_level_rec);
14940: return FALSE;
14941: end if;
14942:
14943: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
14944: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
14945: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
14946:
14947: if fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' then

Line 14944: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

14940: return FALSE;
14941: end if;
14942:
14943: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
14944: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
14945: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
14946:
14947: if fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' then
14948: l_excl_salvage_val_flag := TRUE;

Line 14945: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

14941: end if;
14942:
14943: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
14944: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
14945: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
14946:
14947: if fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' then
14948: l_excl_salvage_val_flag := TRUE;
14949: else

Line 14947: if fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' then

14943: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
14944: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
14945: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
14946:
14947: if fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' then
14948: l_excl_salvage_val_flag := TRUE;
14949: else
14950: l_excl_salvage_val_flag := FALSE;
14951: end if;

Line 14953: if fa_cache_pkg.fazccmt_record.depreciate_lastyear_flag = 'YES' then

14949: else
14950: l_excl_salvage_val_flag := FALSE;
14951: end if;
14952:
14953: if fa_cache_pkg.fazccmt_record.depreciate_lastyear_flag = 'YES' then
14954: l_deprn_last_year_flag := TRUE;
14955: else
14956: l_deprn_last_year_flag := FALSE;
14957: end if;

Line 15022: if not fa_cache_pkg.fazcbc(p_asset_hdr_rec.book_type_code) then

15018:
15019: -- Added for Dated Adjustment
15020: if (px_trans_rec.amortization_start_date is not null) then
15021:
15022: if not fa_cache_pkg.fazcbc(p_asset_hdr_rec.book_type_code) then
15023: fa_srvr_msg.add_message (calling_fn => 'FA_AMORT_PKG.faxraf'
15024: ,p_log_level_rec => p_log_level_rec);
15025: return (FALSE);
15026: end if;

Line 15028: l_last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;

15024: ,p_log_level_rec => p_log_level_rec);
15025: return (FALSE);
15026: end if;
15027:
15028: l_last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
15029: l_cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
15030: l_cur_per_num := mod((l_last_per_ctr+1),l_cur_fy);
15031: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
15032: l_amortization_start_jdate := to_number(to_char(px_trans_rec.amortization_start_date, 'J')); --BMR

Line 15029: l_cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;

15025: return (FALSE);
15026: end if;
15027:
15028: l_last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
15029: l_cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
15030: l_cur_per_num := mod((l_last_per_ctr+1),l_cur_fy);
15031: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
15032: l_amortization_start_jdate := to_number(to_char(px_trans_rec.amortization_start_date, 'J')); --BMR
15033:

Line 15031: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;

15027:
15028: l_last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
15029: l_cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
15030: l_cur_per_num := mod((l_last_per_ctr+1),l_cur_fy);
15031: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
15032: l_amortization_start_jdate := to_number(to_char(px_trans_rec.amortization_start_date, 'J')); --BMR
15033:
15034: if not fa_cache_pkg.fazccp(
15035: l_dpr_row.calendar_type,

Line 15034: if not fa_cache_pkg.fazccp(

15030: l_cur_per_num := mod((l_last_per_ctr+1),l_cur_fy);
15031: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
15032: l_amortization_start_jdate := to_number(to_char(px_trans_rec.amortization_start_date, 'J')); --BMR
15033:
15034: if not fa_cache_pkg.fazccp(
15035: l_dpr_row.calendar_type,
15036: l_fy_name,
15037: l_amortization_start_jdate,
15038: l_amortize_per_num,

Line 15049: if not fa_cache_pkg.fazcct (l_dpr_row.calendar_type) then

15045: end if;
15046:
15047: if (not((l_cur_fy = l_amortize_fy) and
15048: (l_cur_per_num = l_amortize_per_num))) then
15049: if not fa_cache_pkg.fazcct (l_dpr_row.calendar_type) then
15050: fa_srvr_msg.add_message (calling_fn => 'FA_AMORT_PKG.faxraf'
15051: ,p_log_level_rec => p_log_level_rec);
15052: return (FALSE);
15053: end if;

Line 15059: l_pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

15055: -- if this transaction is not at current period, set ADJUSTMENT mode
15056: -- on Depreciable basis rule
15057: l_deprn_used_by_adjustment := 'ADJUSTMENT';
15058:
15059: l_pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
15060:
15061: if (l_amortize_per_num = 1) then
15062: l_dpr_row.y_end := l_amortize_fy - 1;
15063: else

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

15705:
15706: -- Skipping call to the function because it is not necessary for straight line
15707: -- or flat-cost with period end balance and use recoverable cost basis rules
15708: -- There are more cases which calling this function unnecessary but not include for this time.
15709: if (not( (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_CALC)
15710: or ((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
15711: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
15712: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE','USE RECOVERABLE COST'))))) then
15713:

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

15706: -- Skipping call to the function because it is not necessary for straight line
15707: -- or flat-cost with period end balance and use recoverable cost basis rules
15708: -- There are more cases which calling this function unnecessary but not include for this time.
15709: if (not( (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_CALC)
15710: or ((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
15711: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
15712: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE','USE RECOVERABLE COST'))))) then
15713:
15714: -- Get Eofy/Eop Recovearble Cost and Salvage Value

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

15707: -- or flat-cost with period end balance and use recoverable cost basis rules
15708: -- There are more cases which calling this function unnecessary but not include for this time.
15709: if (not( (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_CALC)
15710: or ((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
15711: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
15712: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE','USE RECOVERABLE COST'))))) then
15713:
15714: -- Get Eofy/Eop Recovearble Cost and Salvage Value
15715: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_EOFY_EOP (

Line 15712: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE','USE RECOVERABLE COST'))))) then

15708: -- There are more cases which calling this function unnecessary but not include for this time.
15709: if (not( (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_CALC)
15710: or ((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
15711: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
15712: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE','USE RECOVERABLE COST'))))) then
15713:
15714: -- Get Eofy/Eop Recovearble Cost and Salvage Value
15715: if (not FA_CALC_DEPRN_BASIS1_PKG.GET_EOFY_EOP (
15716: p_asset_id => p_asset_hdr_rec.asset_id,

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

15747:
15748: -- Skipping call to faxcde because it is unnecessary for flat-cost with period end balance,
15749: -- use recoverable cost, period average, and beginning balance basis rules
15750: -- There are more cases which calling this function unnecessary but not include for this time.
15751: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
15752: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
15753: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
15754: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
15755: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then

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

15748: -- Skipping call to faxcde because it is unnecessary for flat-cost with period end balance,
15749: -- use recoverable cost, period average, and beginning balance basis rules
15750: -- There are more cases which calling this function unnecessary but not include for this time.
15751: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
15752: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
15753: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
15754: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
15755: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then
15756:

Line 15753: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',

15749: -- use recoverable cost, period average, and beginning balance basis rules
15750: -- There are more cases which calling this function unnecessary but not include for this time.
15751: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
15752: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
15753: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
15754: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
15755: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then
15756:
15757: l_dpr_in.asset_num := p_asset_desc_rec.asset_number;

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

15751: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
15752: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
15753: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
15754: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
15755: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then
15756:
15757: l_dpr_in.asset_num := p_asset_desc_rec.asset_number;
15758: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
15759: l_dpr_in.book := p_asset_hdr_rec.book_type_code;

Line 15758: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

15754: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
15755: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then
15756:
15757: l_dpr_in.asset_num := p_asset_desc_rec.asset_number;
15758: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
15759: l_dpr_in.book := p_asset_hdr_rec.book_type_code;
15760: l_dpr_in.asset_id := p_asset_hdr_rec.asset_id;
15761: l_dpr_in.adj_cost := px_asset_fin_rec_new.recoverable_cost;
15762: l_dpr_in.rec_cost := px_asset_fin_rec_new.recoverable_cost;

Line 15821: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,

15817: -- Not for what-if yet
15818: --
15819: l_running_mode := fa_std_types.FA_DPR_NORMAL;
15820:
15821: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
15822: fa_cache_pkg.fazcbc_record.fiscal_year_name,
15823: l_dpr_in.prorate_jdate,
15824: l_temp_number,
15825: l_dpr_in.y_begin,

Line 15822: fa_cache_pkg.fazcbc_record.fiscal_year_name,

15818: --
15819: l_running_mode := fa_std_types.FA_DPR_NORMAL;
15820:
15821: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
15822: fa_cache_pkg.fazcbc_record.fiscal_year_name,
15823: l_dpr_in.prorate_jdate,
15824: l_temp_number,
15825: l_dpr_in.y_begin,
15826: l_temp_integer

Line 15830: 'fa_cache_pkg.fazccp'

15826: l_temp_integer
15827: ,p_log_level_rec => p_log_level_rec) then
15828: if (p_log_level_rec.statement_level) then
15829: fa_debug_pkg.add(l_calling_fn, 'Error calling',
15830: 'fa_cache_pkg.fazccp'
15831: ,p_log_level_rec => p_log_level_rec);
15832: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
15833: fa_cache_pkg.fazcbc_record.prorate_calendar
15834: ,p_log_level_rec => p_log_level_rec);

Line 15832: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',

15828: if (p_log_level_rec.statement_level) then
15829: fa_debug_pkg.add(l_calling_fn, 'Error calling',
15830: 'fa_cache_pkg.fazccp'
15831: ,p_log_level_rec => p_log_level_rec);
15832: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
15833: fa_cache_pkg.fazcbc_record.prorate_calendar
15834: ,p_log_level_rec => p_log_level_rec);
15835: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
15836: fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 15833: fa_cache_pkg.fazcbc_record.prorate_calendar

15829: fa_debug_pkg.add(l_calling_fn, 'Error calling',
15830: 'fa_cache_pkg.fazccp'
15831: ,p_log_level_rec => p_log_level_rec);
15832: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
15833: fa_cache_pkg.fazcbc_record.prorate_calendar
15834: ,p_log_level_rec => p_log_level_rec);
15835: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
15836: fa_cache_pkg.fazcbc_record.fiscal_year_name
15837: ,p_log_level_rec => p_log_level_rec);

Line 15835: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

15831: ,p_log_level_rec => p_log_level_rec);
15832: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
15833: fa_cache_pkg.fazcbc_record.prorate_calendar
15834: ,p_log_level_rec => p_log_level_rec);
15835: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
15836: fa_cache_pkg.fazcbc_record.fiscal_year_name
15837: ,p_log_level_rec => p_log_level_rec);
15838: end if;
15839:

Line 15836: fa_cache_pkg.fazcbc_record.fiscal_year_name

15832: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
15833: fa_cache_pkg.fazcbc_record.prorate_calendar
15834: ,p_log_level_rec => p_log_level_rec);
15835: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
15836: fa_cache_pkg.fazcbc_record.fiscal_year_name
15837: ,p_log_level_rec => p_log_level_rec);
15838: end if;
15839:
15840: raise calc_err;

Line 15848: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

15844: l_dpr_in.p_cl_begin := 1;
15845:
15846: if (p_period_rec.period_num = 1) then
15847: l_dpr_in.y_end := p_period_rec.fiscal_year - 1;
15848: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
15849: else
15850: l_dpr_in.y_end := p_period_rec.fiscal_year;
15851: l_dpr_in.p_cl_end := p_period_rec.period_num - 1;
15852: end if;

Line 15857: if fa_cache_pkg.fa_deprn_override_enabled then

15853:
15854: l_dpr_in.rate_adj_factor := 1;
15855:
15856: -- manual override
15857: if fa_cache_pkg.fa_deprn_override_enabled then
15858: if (not fa_cache_pkg.fazccmt(
15859: px_asset_fin_rec_new.deprn_method_code,
15860: px_asset_fin_rec_new.life_in_months
15861: ,p_log_level_rec => p_log_level_rec)) then

Line 15858: if (not fa_cache_pkg.fazccmt(

15854: l_dpr_in.rate_adj_factor := 1;
15855:
15856: -- manual override
15857: if fa_cache_pkg.fa_deprn_override_enabled then
15858: if (not fa_cache_pkg.fazccmt(
15859: px_asset_fin_rec_new.deprn_method_code,
15860: px_asset_fin_rec_new.life_in_months
15861: ,p_log_level_rec => p_log_level_rec)) then
15862: if (p_log_level_rec.statement_level) then

Line 15864: 'fa_cache_pkg.fazccmt'

15860: px_asset_fin_rec_new.life_in_months
15861: ,p_log_level_rec => p_log_level_rec)) then
15862: if (p_log_level_rec.statement_level) then
15863: fa_debug_pkg.add(l_calling_fn, 'Error calling',
15864: 'fa_cache_pkg.fazccmt'
15865: ,p_log_level_rec => p_log_level_rec);
15866: end if;
15867:
15868: raise calc_err;

Line 15871: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

15867:
15868: raise calc_err;
15869: end if;
15870:
15871: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
15872: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
15873:
15874: -- update override status only if satisfies condintion,
15875: -- otherwise do not update status when calculating RAF

Line 15872: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

15868: raise calc_err;
15869: end if;
15870:
15871: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
15872: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
15873:
15874: -- update override status only if satisfies condintion,
15875: -- otherwise do not update status when calculating RAF
15876: -- 1. formula; or

Line 15937: if ((fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG='YES') and

15933: end if;
15934:
15935: -- Bug 4129984.
15936:
15937: if ((fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG='YES') and
15938: (px_asset_fin_rec_new.Reval_Amortization_Basis is not null) and
15939: (p_asset_type_rec.asset_type = 'CAPITALIZED') and
15940: (px_asset_fin_rec_new.group_asset_id is null)) then
15941:

Line 15981: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then -- ENERGY

15977:
15978:
15979: /*code fix for bug no.3630495. added the following line to calculate the adjusted capacity*/
15980: if (nvl(px_asset_fin_rec_new.tracking_method, 'NO TRACK') = 'ALLOCATE') and -- ENERGY
15981: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then -- ENERGY
15982: null;
15983: else
15984: px_asset_fin_rec_new.adjusted_capacity:=px_asset_fin_rec_new.production_capacity- nvl(l_dpr_out.new_ltd_prod, 0);
15985: end if;

Line 16128: if (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY

16124: -- End of HHIRAGA
16125:
16126: -- Bug7446301: Redoing fix for bug7209655. Removed tracking method condition so that process
16127: -- will satisfy following if condition even if the asset type is not GROUP
16128: if (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY
16129: (fa_cache_pkg.fazccmt_record.rate_source_rule = FA_STD_TYPES.FAD_RSR_PROD) then
16130: px_asset_fin_rec_new.adjusted_capacity := nvl(px_asset_fin_rec_new.production_capacity, 0) -
16131: nvl(p_asset_deprn_rec_new.ltd_production, 0);
16132: end if;

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

16125:
16126: -- Bug7446301: Redoing fix for bug7209655. Removed tracking method condition so that process
16127: -- will satisfy following if condition even if the asset type is not GROUP
16128: if (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY
16129: (fa_cache_pkg.fazccmt_record.rate_source_rule = FA_STD_TYPES.FAD_RSR_PROD) then
16130: px_asset_fin_rec_new.adjusted_capacity := nvl(px_asset_fin_rec_new.production_capacity, 0) -
16131: nvl(p_asset_deprn_rec_new.ltd_production, 0);
16132: end if;
16133: