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_EXP_PVT dependencies on FA_CACHE_PKG

Line 4: g_release number := fa_cache_pkg.fazarel_release;

1: PACKAGE BODY FA_EXP_PVT as
2: /* $Header: FAVEXAJB.pls 120.29.12020000.2 2012/11/07 11:38:07 deemitta ship $ */
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:
6: Function faxbds
7: (
8: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

Line 46: if (not FA_CACHE_PKG.fazccmt(px_asset_fin_rec_new.deprn_method_code,

42: l_dummy_varch varchar2(16);
43:
44: begin <>
45:
46: if (not FA_CACHE_PKG.fazccmt(px_asset_fin_rec_new.deprn_method_code,
47: px_asset_fin_rec_new.life_in_months,
48: p_log_level_rec => p_log_level_rec)) then
49: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);
50: return FALSE;

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

49: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);
50: return FALSE;
51: end if;
52:
53: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
54:
55: X_dpr_ptr.adj_cost := px_asset_fin_rec_new.adjusted_cost;
56: X_dpr_ptr.rec_cost := px_asset_fin_rec_new.recoverable_cost;
57: X_dpr_ptr.reval_amo_basis := px_asset_fin_rec_new.reval_amortization_basis;

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

82: else
83: X_dpr_ptr.rate_adj_factor := px_asset_fin_rec_new.rate_adjustment_factor;
84: end if;
85:
86: l_last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
87: l_cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
88: l_cur_per_num := mod((l_last_per_ctr+1),l_cur_fy);
89: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;
90: l_prorate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;

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

83: X_dpr_ptr.rate_adj_factor := px_asset_fin_rec_new.rate_adjustment_factor;
84: end if;
85:
86: l_last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
87: l_cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
88: l_cur_per_num := mod((l_last_per_ctr+1),l_cur_fy);
89: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;
90: l_prorate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;
91: l_prorate_jdate := to_number(to_char(px_asset_fin_rec_new.prorate_date, 'J'));

Line 89: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;

85:
86: l_last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
87: l_cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
88: l_cur_per_num := mod((l_last_per_ctr+1),l_cur_fy);
89: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;
90: l_prorate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;
91: l_prorate_jdate := to_number(to_char(px_asset_fin_rec_new.prorate_date, 'J'));
92: l_deprn_start_jdate := to_number(to_char(px_asset_fin_rec_new.deprn_start_date, 'J'));
93: l_jdate_in_svc := to_number(to_char(px_asset_fin_rec_new.date_placed_in_service, 'J'));

Line 90: l_prorate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;

86: l_last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
87: l_cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
88: l_cur_per_num := mod((l_last_per_ctr+1),l_cur_fy);
89: l_deprn_calendar := fa_cache_pkg.fazcbc_record.deprn_calendar;
90: l_prorate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;
91: l_prorate_jdate := to_number(to_char(px_asset_fin_rec_new.prorate_date, 'J'));
92: l_deprn_start_jdate := to_number(to_char(px_asset_fin_rec_new.deprn_start_date, 'J'));
93: l_jdate_in_svc := to_number(to_char(px_asset_fin_rec_new.date_placed_in_service, 'J'));
94:

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

91: l_prorate_jdate := to_number(to_char(px_asset_fin_rec_new.prorate_date, 'J'));
92: l_deprn_start_jdate := to_number(to_char(px_asset_fin_rec_new.deprn_start_date, 'J'));
93: l_jdate_in_svc := to_number(to_char(px_asset_fin_rec_new.date_placed_in_service, 'J'));
94:
95: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
96:
97: if not fa_cache_pkg.fazccp(l_prorate_calendar,
98: l_fy_name,
99: l_prorate_jdate,

Line 97: if not fa_cache_pkg.fazccp(l_prorate_calendar,

93: l_jdate_in_svc := to_number(to_char(px_asset_fin_rec_new.date_placed_in_service, 'J'));
94:
95: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
96:
97: if not fa_cache_pkg.fazccp(l_prorate_calendar,
98: l_fy_name,
99: l_prorate_jdate,
100: l_dummy_per_num,
101: l_prorate_fy,

Line 115: if not fa_cache_pkg.fazccp(l_deprn_calendar,

111: else
112: l_use_jdate := l_deprn_start_jdate;
113: end if;
114:
115: if not fa_cache_pkg.fazccp(l_deprn_calendar,
116: l_fy_name,
117: l_use_jdate,
118: l_deprn_period,
119: l_deprn_fy,

Line 126: if not fa_cache_pkg.fazcct (l_deprn_calendar, p_log_level_rec => p_log_level_rec) then

122: fa_srvr_msg.add_message (calling_fn => 'fa_exp_pkg.faxbds', p_log_level_rec => p_log_level_rec);
123: return (FALSE);
124: end if;
125:
126: if not fa_cache_pkg.fazcct (l_deprn_calendar, p_log_level_rec => p_log_level_rec) then
127: fa_srvr_msg.add_message (calling_fn => 'fa_exp_pkg.faxbds', p_log_level_rec => p_log_level_rec);
128: return (FALSE);
129: end if;
130:

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

127: fa_srvr_msg.add_message (calling_fn => 'fa_exp_pkg.faxbds', p_log_level_rec => p_log_level_rec);
128: return (FALSE);
129: end if;
130:
131: l_pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
132: X_dpr_ptr.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
133: X_dpr_ptr.prorate_jdate := l_prorate_jdate;
134: X_dpr_ptr.deprn_start_jdate := l_deprn_start_jdate;
135: X_dpr_ptr.jdate_retired := 0;

Line 132: X_dpr_ptr.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

128: return (FALSE);
129: end if;
130:
131: l_pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
132: X_dpr_ptr.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
133: X_dpr_ptr.prorate_jdate := l_prorate_jdate;
134: X_dpr_ptr.deprn_start_jdate := l_deprn_start_jdate;
135: X_dpr_ptr.jdate_retired := 0;
136: X_dpr_ptr.ret_prorate_jdate := 0;

Line 267: l_pers_per_yr integer := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

263: l_dpr_ceil_name varchar2(31);
264: l_dummy_dpr_arr fa_std_types.dpr_arr_type;
265: l_dummy_int integer;
266: l_dummy_bool boolean;
267: l_pers_per_yr integer := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
268: l_start_per_num integer := 1;
269:
270: -- NOTE: Fixed to bug#1583869 - hsugimot
271: -- This solve the problem that you do expensed adjustment

Line 630: if (not FA_CACHE_PKG.fazccmt(px_asset_fin_rec_new.deprn_method_code,

626: -- expensed change. -Dave
627: --
628: -- this is handled in faxiat now
629:
630: if (not FA_CACHE_PKG.fazccmt(px_asset_fin_rec_new.deprn_method_code,
631: px_asset_fin_rec_new.life_in_months,
632: p_log_level_rec => p_log_level_rec)) then
633: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);
634: return FALSE;

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

633: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);
634: return FALSE;
635: end if;
636:
637: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
638: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
639:
640:
641: -- Added for the Depreciable Basis Formula.

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

634: return FALSE;
635: end if;
636:
637: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
638: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
639:
640:
641: -- Added for the Depreciable Basis Formula.
642: l_cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;

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

638: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
639:
640:
641: -- Added for the Depreciable Basis Formula.
642: l_cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
643: l_cur_per_num := mod(p_period_rec.period_counter,l_cur_fy);
644:
645:
646: ----------------------------------------------

Line 673: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV' AND

669: l_hyp_rsv := nvl(l_dpr_out.new_deprn_rsv,0) - nvl(l_dpr_out.new_bonus_deprn_rsv,0);
670: l_hyp_total_ytd := nvl(l_hyp_total_ytd,0);
671: if p_asset_hdr_rec.period_of_addition = 'Y' AND
672: px_trans_rec.transaction_type_code = 'ADDITION' AND
673: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV' AND
674: ( fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' or --Bug#12603641
675: (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' AND
676: fa_cache_pkg.fazccmt_record.rate_source_rule <> 'TABLE') ) AND --bug 14724296
677: nvl(fa_cache_pkg.fazccmt_record.deprn_basis_formula,'X') <> 'STRICT_FLAT' then

Line 674: ( fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' or --Bug#12603641

670: l_hyp_total_ytd := nvl(l_hyp_total_ytd,0);
671: if p_asset_hdr_rec.period_of_addition = 'Y' AND
672: px_trans_rec.transaction_type_code = 'ADDITION' AND
673: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV' AND
674: ( fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' or --Bug#12603641
675: (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' AND
676: fa_cache_pkg.fazccmt_record.rate_source_rule <> 'TABLE') ) AND --bug 14724296
677: nvl(fa_cache_pkg.fazccmt_record.deprn_basis_formula,'X') <> 'STRICT_FLAT' then
678:

Line 675: (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' AND

671: if p_asset_hdr_rec.period_of_addition = 'Y' AND
672: px_trans_rec.transaction_type_code = 'ADDITION' AND
673: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV' AND
674: ( fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' or --Bug#12603641
675: (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' AND
676: fa_cache_pkg.fazccmt_record.rate_source_rule <> 'TABLE') ) AND --bug 14724296
677: nvl(fa_cache_pkg.fazccmt_record.deprn_basis_formula,'X') <> 'STRICT_FLAT' then
678:
679: -- During catchup we force normal flat mode to strict flat mode

Line 676: fa_cache_pkg.fazccmt_record.rate_source_rule <> 'TABLE') ) AND --bug 14724296

672: px_trans_rec.transaction_type_code = 'ADDITION' AND
673: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV' AND
674: ( fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' or --Bug#12603641
675: (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' AND
676: fa_cache_pkg.fazccmt_record.rate_source_rule <> 'TABLE') ) AND --bug 14724296
677: nvl(fa_cache_pkg.fazccmt_record.deprn_basis_formula,'X') <> 'STRICT_FLAT' then
678:
679: -- During catchup we force normal flat mode to strict flat mode
680: l_hyp_total_rsv := l_hyp_total_rsv - l_hyp_total_ytd;

Line 677: nvl(fa_cache_pkg.fazccmt_record.deprn_basis_formula,'X') <> 'STRICT_FLAT' then

673: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV' AND
674: ( fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' or --Bug#12603641
675: (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' AND
676: fa_cache_pkg.fazccmt_record.rate_source_rule <> 'TABLE') ) AND --bug 14724296
677: nvl(fa_cache_pkg.fazccmt_record.deprn_basis_formula,'X') <> 'STRICT_FLAT' then
678:
679: -- During catchup we force normal flat mode to strict flat mode
680: l_hyp_total_rsv := l_hyp_total_rsv - l_hyp_total_ytd;
681: l_hyp_rsv := l_hyp_rsv - l_hyp_total_ytd;