34: h_dummy_bool boolean;
35: h_dummy_varch varchar2(16);
36: begin <
37:
38: if not fa_cache_pkg.fazccmt
39: (X_fin_info_ptr.method_code,
40: X_fin_info_ptr.life, p_log_level_rec) then
41: fa_srvr_msg.add_message (calling_fn => 'fa_exp_pkg.faxbds',
42: p_log_level_rec => p_log_level_rec);
42: p_log_level_rec => p_log_level_rec);
43: return (FALSE);
44: end if;
45:
46: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
47:
48:
49: X_dpr_ptr.adj_cost := X_fin_info_ptr.adj_cost;
50: X_dpr_ptr.rec_cost := X_fin_info_ptr.rec_cost;
88: --
89: -- note there is no need to call the cache again here as it would already be loaded
90: --
91:
92: last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
93: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
94: cur_per_num := mod((last_per_ctr+1),cur_fy);
95: X_dpr_ptr.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
96: calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
89: -- note there is no need to call the cache again here as it would already be loaded
90: --
91:
92: last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
93: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
94: cur_per_num := mod((last_per_ctr+1),cur_fy);
95: X_dpr_ptr.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
96: calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
97: rate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;
91:
92: last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
93: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
94: cur_per_num := mod((last_per_ctr+1),cur_fy);
95: X_dpr_ptr.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
96: calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
97: rate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;
98: X_dist_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
99:
92: last_per_ctr := fa_cache_pkg.fazcbc_record.last_period_counter;
93: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
94: cur_per_num := mod((last_per_ctr+1),cur_fy);
95: X_dpr_ptr.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
96: calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
97: rate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;
98: X_dist_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
99:
100: prorate_jdate := to_number(to_char(X_fin_info_ptr.prorate_date, 'J'));
93: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
94: cur_per_num := mod((last_per_ctr+1),cur_fy);
95: X_dpr_ptr.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
96: calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
97: rate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;
98: X_dist_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
99:
100: prorate_jdate := to_number(to_char(X_fin_info_ptr.prorate_date, 'J'));
101: deprn_start_jdate := to_number(to_char(X_fin_info_ptr.deprn_start_date, 'J'));
94: cur_per_num := mod((last_per_ctr+1),cur_fy);
95: X_dpr_ptr.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
96: calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
97: rate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;
98: X_dist_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
99:
100: prorate_jdate := to_number(to_char(X_fin_info_ptr.prorate_date, 'J'));
101: deprn_start_jdate := to_number(to_char(X_fin_info_ptr.deprn_start_date, 'J'));
102: jdate_in_svc := to_number(to_char(X_fin_info_ptr.date_placed_in_svc, 'J'));
100: prorate_jdate := to_number(to_char(X_fin_info_ptr.prorate_date, 'J'));
101: deprn_start_jdate := to_number(to_char(X_fin_info_ptr.deprn_start_date, 'J'));
102: jdate_in_svc := to_number(to_char(X_fin_info_ptr.date_placed_in_svc, 'J'));
103:
104: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
105:
106: if not fa_cache_pkg.fazccp (
107: rate_calendar, fy_name, prorate_jdate,
108: period_num, prorate_fy, start_jdate, p_log_level_rec) then
102: jdate_in_svc := to_number(to_char(X_fin_info_ptr.date_placed_in_svc, 'J'));
103:
104: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
105:
106: if not fa_cache_pkg.fazccp (
107: rate_calendar, fy_name, prorate_jdate,
108: period_num, prorate_fy, start_jdate, p_log_level_rec) then
109: fa_srvr_msg.add_message (calling_fn => 'fa_exp_pkg.faxbds',
110: p_log_level_rec => p_log_level_rec);
117: else
118: use_jdate := deprn_start_jdate;
119: end if;
120:
121: if not fa_cache_pkg.fazccp (
122: calendar_type, fy_name, use_jdate,
123: deprn_period, deprn_fy, start_jdate, p_log_level_rec) then
124: fa_srvr_msg.add_message (calling_fn => 'fa_exp_pkg.faxbds',
125: p_log_level_rec => p_log_level_rec);
125: p_log_level_rec => p_log_level_rec);
126: return (FALSE);
127: end if;
128:
129: if not fa_cache_pkg.fazcct (calendar_type, p_log_level_rec) then
130: fa_srvr_msg.add_message (calling_fn => 'fa_exp_pkg.faxbds',
131: p_log_level_rec => p_log_level_rec);
132: return (FALSE);
133: end if;
130: fa_srvr_msg.add_message (calling_fn => 'fa_exp_pkg.faxbds',
131: p_log_level_rec => p_log_level_rec);
132: return (FALSE);
133: end if;
134: pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
135:
136: X_dpr_ptr.prorate_jdate := prorate_jdate;
137: X_dpr_ptr.deprn_start_jdate := deprn_start_jdate;
138: X_dpr_ptr.jdate_retired := 0;
399: return (FALSE);
400: end if;
401: end if;
402:
403: if not fa_cache_pkg.fazccmt (
404: X_fin_info_ptr.method_code,
405: X_fin_info_ptr.life,
406: p_log_level_rec) then
407:
409: p_log_level_rec => p_log_level_rec);
410: return (FALSE);
411: end if;
412:
413: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
414: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
415:
416:
417: -- Added for the Depreciable Basis Formula.
410: return (FALSE);
411: end if;
412:
413: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
414: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
415:
416:
417: -- Added for the Depreciable Basis Formula.
418: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
414: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
415:
416:
417: -- Added for the Depreciable Basis Formula.
418: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
419: cur_per_num := mod(X_fin_info_ptr.period_ctr,cur_fy);
420:
421: if (fa_cache_pkg.fa_enabled_deprn_basis_formula) then
422: -- Depreciable Basis Formula
417: -- Added for the Depreciable Basis Formula.
418: cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
419: cur_per_num := mod(X_fin_info_ptr.period_ctr,cur_fy);
420:
421: if (fa_cache_pkg.fa_enabled_deprn_basis_formula) then
422: -- Depreciable Basis Formula
423: -- set h_rule_in paremters
424:
425: h_rule_in.asset_id := X_fin_info_ptr.asset_id;
510: (X_fin_info_ptr.Adj_cost = 0 and NOT(X_fin_info_ptr.dep_flag)) then
511:
512: -- Fixed to bug#1762518 - hsugimot
513:
514: -- cur_fy := fa_cache_pkg.fazcbc_record.current_fiscal_year;
515: -- cur_per_num := mod(X_fin_info_ptr.period_ctr,cur_fy);
516:
517: if (p_log_level_rec.statement_level) then
518: fa_debug_pkg.add('faxexp','X_fin_info_ptr.period_ctr',