DBA Data[Home] [Help]

APPS.FA_AMORT_PKG dependencies on FA_CACHE_PKG

Line 59: if not fa_cache_pkg.fazccb(h_book_type_code,

55:
56: -- override
57: adj_ptr_faxiat.deprn_override_flag := '';
58:
59: if not fa_cache_pkg.fazccb(h_book_type_code,
60: h_category_id, p_log_level_rec => p_log_level_rec)
61: then
62: FA_SRVR_MSG.ADD_MESSAGE
63: (CALLING_FN => 'FA_AMORT_PKG.faxiat', p_log_level_rec => p_log_level_rec);

Line 72: h_cost_acct := FA_CACHE_PKG.fazccb_record.cip_cost_acct;

68: then
69: h_cost_source := 'CIP ADJUSTMENT';
70: h_cost_acct_type := 'CIP_COST_ACCT';
71: h_clearing_acct_type := 'CIP_CLEARING_ACCT';
72: h_cost_acct := FA_CACHE_PKG.fazccb_record.cip_cost_acct;
73: h_clearing_acct := FA_CACHE_PKG.fazccb_record.cip_clearing_acct;
74: else
75: h_cost_source := 'ADJUSTMENT';
76: h_cost_acct_type := 'ASSET_COST_ACCT';

Line 73: h_clearing_acct := FA_CACHE_PKG.fazccb_record.cip_clearing_acct;

69: h_cost_source := 'CIP ADJUSTMENT';
70: h_cost_acct_type := 'CIP_COST_ACCT';
71: h_clearing_acct_type := 'CIP_CLEARING_ACCT';
72: h_cost_acct := FA_CACHE_PKG.fazccb_record.cip_cost_acct;
73: h_clearing_acct := FA_CACHE_PKG.fazccb_record.cip_clearing_acct;
74: else
75: h_cost_source := 'ADJUSTMENT';
76: h_cost_acct_type := 'ASSET_COST_ACCT';
77: h_clearing_acct_type := 'ASSET_CLEARING_ACCT';

Line 78: h_cost_acct := FA_CACHE_PKG.fazccb_record.asset_cost_acct;

74: else
75: h_cost_source := 'ADJUSTMENT';
76: h_cost_acct_type := 'ASSET_COST_ACCT';
77: h_clearing_acct_type := 'ASSET_CLEARING_ACCT';
78: h_cost_acct := FA_CACHE_PKG.fazccb_record.asset_cost_acct;
79: h_clearing_acct:=FA_CACHE_PKG.fazccb_record.asset_clearing_acct;
80: end if;
81: adj_ptr_faxiat.annualized_adjustment:=0;
82: adj_ptr_faxiat.source_type_code := h_cost_source;

Line 79: h_clearing_acct:=FA_CACHE_PKG.fazccb_record.asset_clearing_acct;

75: h_cost_source := 'ADJUSTMENT';
76: h_cost_acct_type := 'ASSET_COST_ACCT';
77: h_clearing_acct_type := 'ASSET_CLEARING_ACCT';
78: h_cost_acct := FA_CACHE_PKG.fazccb_record.asset_cost_acct;
79: h_clearing_acct:=FA_CACHE_PKG.fazccb_record.asset_clearing_acct;
80: end if;
81: adj_ptr_faxiat.annualized_adjustment:=0;
82: adj_ptr_faxiat.source_type_code := h_cost_source;
83: adj_ptr_faxiat.adjustment_amount

Line 160: h_expense_acct := FA_CACHE_PKG.fazccb_record.deprn_expense_acct;

156: end if;
157: end if; /* adjustment_amount<>0 */
158:
159: h_expense_acct_type := 'DEPRN_EXPENSE_ACCT';
160: h_expense_acct := FA_CACHE_PKG.fazccb_record.deprn_expense_acct;
161: h_expense_source:='DEPRECIATION';
162: adj_ptr_faxiat.source_type_code:=h_expense_source;
163: adj_ptr_faxiat.adjustment_type:='EXPENSE';
164: adj_ptr_faxiat.debit_credit_flag:='DR';

Line 223: h_expense_acct := FA_CACHE_PKG.fazccb_record.bonus_deprn_expense_acct;

219: if nvl(X_bonus_deprn_exp,0) <> 0 then
220:
221: h_expense_acct_type := 'BONUS_DEPRN_EXPENSE_ACCT';
222: -- account could be derived from somewhere else, derive from account generat.
223: h_expense_acct := FA_CACHE_PKG.fazccb_record.bonus_deprn_expense_acct;
224: h_expense_source:='DEPRECIATION';
225: adj_ptr_faxiat.source_type_code:=h_expense_source;
226: adj_ptr_faxiat.adjustment_type:='BONUS EXPENSE';
227: adj_ptr_faxiat.debit_credit_flag:='DR';

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

416: where th.transaction_header_id = c_thid
417: and th.date_effective between dp.period_open_date and
418: nvl(dp.period_close_date,sysdate)
419: and dp.book_type_code = X_fin_info_ptr.book
420: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
421: and cp.start_date = fy.start_date
422: and cp.period_num = 1
423: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
424: and dp.calendar_period_open_date between fy.start_date and fy.end_date

Line 423: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

419: and dp.book_type_code = X_fin_info_ptr.book
420: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
421: and cp.start_date = fy.start_date
422: and cp.period_num = 1
423: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
424: and dp.calendar_period_open_date between fy.start_date and fy.end_date
425: and X_fin_info_ptr.amortization_start_date between fy.start_date and fy.end_date;
426:
427: --

Line 472: if (not FA_CACHE_PKG.fazccmt(X_fin_info_ptr.method_code,

468: element=>'SOB_ID',
469: value=>X_set_of_books_id , p_log_level_rec => p_log_level_rec);
470: end if;
471:
472: if (not FA_CACHE_PKG.fazccmt(X_fin_info_ptr.method_code,
473: X_fin_info_ptr.life, p_log_level_rec => p_log_level_rec))
474: then
475: FA_SRVR_MSG.ADD_MESSAGE
476: (CALLING_FN => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);

Line 480: h_method_id := fa_cache_pkg.fazccmt_record.method_id;

476: (CALLING_FN => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);
477: return FALSE;
478: end if;
479:
480: h_method_id := fa_cache_pkg.fazccmt_record.method_id;
481: h_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
482: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
483:
484: -- Bug 13078100 : Initialize sob_id and mrc_sob_type to be used in faxcdb call

Line 481: h_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

477: return FALSE;
478: end if;
479:
480: h_method_id := fa_cache_pkg.fazccmt_record.method_id;
481: h_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
482: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
483:
484: -- Bug 13078100 : Initialize sob_id and mrc_sob_type to be used in faxcdb call
485: h_rule_in.mrc_sob_type_code := X_mrc_sob_type_code;

Line 482: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

478: end if;
479:
480: h_method_id := fa_cache_pkg.fazccmt_record.method_id;
481: h_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
482: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
483:
484: -- Bug 13078100 : Initialize sob_id and mrc_sob_type to be used in faxcdb call
485: h_rule_in.mrc_sob_type_code := X_mrc_sob_type_code;
486: h_rule_in.set_of_books_id := X_set_of_books_id;

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

484: -- Bug 13078100 : Initialize sob_id and mrc_sob_type to be used in faxcdb call
485: h_rule_in.mrc_sob_type_code := X_mrc_sob_type_code;
486: h_rule_in.set_of_books_id := X_set_of_books_id;
487:
488: if fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' then
489: h_excl_salvage_val_flag := TRUE;
490: else
491: h_excl_salvage_val_flag := FALSE;
492: end if;

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

490: else
491: h_excl_salvage_val_flag := FALSE;
492: end if;
493:
494: if fa_cache_pkg.fazccmt_record.depreciate_lastyear_flag = 'YES' then
495: h_deprn_last_year_flag := TRUE;
496: else
497: h_deprn_last_year_flag := FALSE;
498: end if;

Line 562: last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;

558:
559: -- Added for Dated Adjustment
560: if (X_fin_info_ptr.amortization_start_date is not null) then
561: -- removed fazcbc cache call as it should already be loaded - BMR
562: last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
563: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
564: cur_per_num := mod((last_per_ctr+1),cur_fy);
565: amortization_start_jdate := to_number(to_char(X_fin_info_ptr.amortization_start_date, 'J'));
566: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;

Line 563: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;

559: -- Added for Dated Adjustment
560: if (X_fin_info_ptr.amortization_start_date is not null) then
561: -- removed fazcbc cache call as it should already be loaded - BMR
562: last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
563: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
564: cur_per_num := mod((last_per_ctr+1),cur_fy);
565: amortization_start_jdate := to_number(to_char(X_fin_info_ptr.amortization_start_date, 'J'));
566: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
567: if not fa_cache_pkg.fazccp (

Line 566: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;

562: last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
563: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
564: cur_per_num := mod((last_per_ctr+1),cur_fy);
565: amortization_start_jdate := to_number(to_char(X_fin_info_ptr.amortization_start_date, 'J'));
566: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
567: if not fa_cache_pkg.fazccp (
568: h_dpr_row.calendar_type, fy_name,amortization_start_jdate,
569: amortize_per_num, amortize_fy, start_jdate
570: , p_log_level_rec => p_log_level_rec) then

Line 567: if not fa_cache_pkg.fazccp (

563: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
564: cur_per_num := mod((last_per_ctr+1),cur_fy);
565: amortization_start_jdate := to_number(to_char(X_fin_info_ptr.amortization_start_date, 'J'));
566: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
567: if not fa_cache_pkg.fazccp (
568: h_dpr_row.calendar_type, fy_name,amortization_start_jdate,
569: amortize_per_num, amortize_fy, start_jdate
570: , p_log_level_rec => p_log_level_rec) then
571: fa_srvr_msg.add_message (calling_fn => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);

Line 575: if not fa_cache_pkg.fazcct (h_dpr_row.calendar_type, p_log_level_rec => p_log_level_rec) then

571: fa_srvr_msg.add_message (calling_fn => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);
572: return (FALSE);
573: end if;
574: if (not((cur_fy = amortize_fy) and (cur_per_num = amortize_per_num))) then
575: if not fa_cache_pkg.fazcct (h_dpr_row.calendar_type, p_log_level_rec => p_log_level_rec) then
576: fa_srvr_msg.add_message (calling_fn => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);
577: return (FALSE);
578: end if;
579: pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

Line 579: pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

575: if not fa_cache_pkg.fazcct (h_dpr_row.calendar_type, p_log_level_rec => p_log_level_rec) then
576: fa_srvr_msg.add_message (calling_fn => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);
577: return (FALSE);
578: end if;
579: pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
580: if (amortize_per_num = 1) then
581: h_dpr_row.y_end := amortize_fy - 1;
582: else
583: h_dpr_row.y_end := amortize_fy;

Line 695: if (fa_cache_pkg.fa_enabled_deprn_basis_formula)then

691: -- Cost - Regular Reserve (without bonus deprn res) for cost assets
692:
693: -- Add the calling Depreciable Basis Formula.
694: --if (nvl(fnd_profile.value('FA_ENABLED_DEPRN_BASIS_FORMULA'), 'N') = 'Y') then
695: if (fa_cache_pkg.fa_enabled_deprn_basis_formula)then
696: -- new_raval_amo_basis and Production rate source rule are
697: -- not calculated on Depreciable Basis Formula
698:
699: X_new_reval_amo_basis := h_dpr_row.reval_rsv;

Line 882: if (not fa_cache_pkg.fa_enabled_deprn_basis_formula)then

878:
879:
880: -- Add for the Depreciable Basis Formula.
881: -- if (nvl(fnd_profile.value('FA_ENABLED_DEPRN_BASIS_FORMULA'), 'N') <> 'Y') then
882: if (not fa_cache_pkg.fa_enabled_deprn_basis_formula)then
883:
884: if (not FA_AMORT_PKG.faxnac(X_fin_info_ptr.method_code,
885: X_fin_info_ptr.life,
886: X_fin_info_ptr.rec_cost,

Line 1053: if (fa_cache_pkg.fa_print_debug) then

1049: fetch c_get_reserve into deprn_summary.deprn_rsv,
1050: deprn_summary.bonus_deprn_rsv;
1051: close c_get_reserve;
1052: end if;
1053: if (fa_cache_pkg.fa_print_debug) then
1054: fa_debug_pkg.add('FA_AMORT_PKG.faxraf',
1055: 'Got reserve using BOOKS row', 'reserve - ytd', p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_AMORT_PKG.faxraf',
1057: 'deprn_summary.deprn_rsv:deprn_summary.bonus_deprn_rsv',

Line 1079: if (fa_cache_pkg.fa_print_debug) then

1075:
1076: deprn_summary.deprn_rsv := h_deprn_rsv;
1077: deprn_summary.bonus_deprn_rsv := h_bonus_deprn_rsv;
1078:
1079: if (fa_cache_pkg.fa_print_debug) then
1080: fa_debug_pkg.add('FA_AMORT_PKG.faxraf',
1081: 'Got reserve from get_reserve function', ' ', p_log_level_rec => p_log_level_rec);
1082: fa_debug_pkg.add('FA_AMORT_PKG.faxraf',
1083: 'deprn_summary.deprn_rsv:deprn_summary.bonus_deprn_rsv',

Line 1200: if (fa_cache_pkg.fa_enabled_deprn_basis_formula) then

1196:
1197: -- Add for the Depreciable Basis Formula.
1198: -- if (nvl(fnd_profile.value('FA_ENABLED_DEPRN_BASIS_FORMULA'), 'N') = 'Y') then
1199:
1200: if (fa_cache_pkg.fa_enabled_deprn_basis_formula) then
1201: fa_rx_conc_mesg_pkg.log('x_new_raf D: ' || to_char(x_new_raf));
1202: -- Depreciable Basis Formula
1203: -- set h_rule_in paremters
1204:

Line 1383: if (fa_cache_pkg.fa_enabled_deprn_basis_formula) then

1379: -- Added for Depreciable Basis Formula.
1380: -- if (nvl(fnd_profile.value('FA_ENABLED_DEPRN_BASIS_FORMULA'), 'N') = 'Y') then
1381:
1382:
1383: if (fa_cache_pkg.fa_enabled_deprn_basis_formula) then
1384:
1385: -- Depreciable Basis Formula
1386: -- set h_rule_in paremters
1387:

Line 2002: h_deprn_basis_formula := fa_cache_pkg.fazccmt_record.deprn_basis_formula;

1998:
1999: if X_adj_cost is null then return false;
2000: end if;
2001:
2002: h_deprn_basis_formula := fa_cache_pkg.fazccmt_record.deprn_basis_formula;
2003:
2004: if h_deprn_basis_formula is null then
2005: return true;
2006: end if;

Line 2011: if ( not fa_cache_pkg.fazccmt(x_method_code,

2007:
2008: -- following cache call is redundant as cache shoudl already be loaded - BMR (double check)
2009: -- if h_deprn_basis_formula = fa_std_types.FAD_DBF_FLAT then
2010: if h_deprn_basis_formula = 'STRICT_FLAT' then
2011: if ( not fa_cache_pkg.fazccmt(x_method_code,
2012: x_life, p_log_level_rec => p_log_level_rec)) then
2013: fa_srvr_msg.add_message(calling_fn => 'FA_AMORT_PKG.faxnac', p_log_level_rec => p_log_level_rec);
2014: return false;
2015: end if;

Line 2017: h_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

2013: fa_srvr_msg.add_message(calling_fn => 'FA_AMORT_PKG.faxnac', p_log_level_rec => p_log_level_rec);
2014: return false;
2015: end if;
2016:
2017: h_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
2018: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
2019:
2020: if h_rate_source_rule = FA_STD_TYPES.FAD_RSR_FLAT and h_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_COST then
2021: if x_rec_cost is null then

Line 2018: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

2014: return false;
2015: end if;
2016:
2017: h_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
2018: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
2019:
2020: if h_rate_source_rule = FA_STD_TYPES.FAD_RSR_FLAT and h_deprn_basis_rule = FA_STD_TYPES.FAD_DBR_COST then
2021: if x_rec_cost is null then
2022: fa_srvr_msg.add_message(calling_fn => 'FA_AMORT_PKG.faxnac', p_log_level_rec => p_log_level_rec);