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

Line 48: h_dist_book := fa_cache_pkg.fazcbc_record.distribution_source_book;

44: -- production is only stored in the corporate book.
45:
46: -- fazcbc cache should have already been called don't call again -bmr
47:
48: h_dist_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
49: X_prodn := 0;
50:
51: For h in PROD loop
52: X_prodn := X_prodn + h.prod;

Line 163: if (not fa_cache_pkg.fazccmt (

159:
160: begin <>
161:
162: -- Fix for Bug #2629724. Call the fazccmt cache to improve perf.
163: if (not fa_cache_pkg.fazccmt (
164: X_Method => X_Method_Code,
165: X_Life => X_Life_In_Months
166: ,p_log_level_rec => p_log_level_rec)) then
167: RAISE cache_exception;

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

166: ,p_log_level_rec => p_log_level_rec)) then
167: RAISE cache_exception;
168: end if;
169:
170: h_method_id := fa_cache_pkg.fazccmt_record.method_id;
171: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
172: h_formula_parsed := fa_cache_pkg.fazcfor_record.formula_parsed;
173:
174: h_count1 := instr (h_formula_parsed, 'REMAINING_LIFE1');

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

167: RAISE cache_exception;
168: end if;
169:
170: h_method_id := fa_cache_pkg.fazccmt_record.method_id;
171: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
172: h_formula_parsed := fa_cache_pkg.fazcfor_record.formula_parsed;
173:
174: h_count1 := instr (h_formula_parsed, 'REMAINING_LIFE1');
175: h_count2 := instr (h_formula_parsed, 'REMAINING_LIFE2');

Line 172: h_formula_parsed := fa_cache_pkg.fazcfor_record.formula_parsed;

168: end if;
169:
170: h_method_id := fa_cache_pkg.fazccmt_record.method_id;
171: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
172: h_formula_parsed := fa_cache_pkg.fazcfor_record.formula_parsed;
173:
174: h_count1 := instr (h_formula_parsed, 'REMAINING_LIFE1');
175: h_count2 := instr (h_formula_parsed, 'REMAINING_LIFE2');
176: h_prod_method := instr (fa_cache_pkg.fazcfor_record.formula_actual,

Line 176: h_prod_method := instr (fa_cache_pkg.fazcfor_record.formula_actual,

172: h_formula_parsed := fa_cache_pkg.fazcfor_record.formula_parsed;
173:
174: h_count1 := instr (h_formula_parsed, 'REMAINING_LIFE1');
175: h_count2 := instr (h_formula_parsed, 'REMAINING_LIFE2');
176: h_prod_method := instr (fa_cache_pkg.fazcfor_record.formula_actual,
177: 'CAPACITY');
178:
179: X_Method_Type := 0;
180:

Line 191: if fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' then

187: X_Method_Type := 0;
188: end if; */ -- commented this for bug 3357903
189:
190: -- Bug 6665510: FP: Japan Tax Reform Project (Start)
191: if fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' then
192: if (p_log_level_rec.statement_level) then
193: fa_debug_pkg.add('FAXGFR','+++ in', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);
194: end if;
195:

Line 193: fa_debug_pkg.add('FAXGFR','+++ in', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);

189:
190: -- Bug 6665510: FP: Japan Tax Reform Project (Start)
191: if fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' then
192: if (p_log_level_rec.statement_level) then
193: fa_debug_pkg.add('FAXGFR','+++ in', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);
194: end if;
195:
196: if X_calling_interface in ('FAXCDE') and (X_new_cost is not null and X_adjusted_cost is not null) then
197: h_formula_parsed := replace(h_formula_parsed, 'ADJUSTED_COST', to_char(X_adjusted_cost));

Line 323: fa_debug_pkg.add('FAXGFR','+++ guarantee_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);

319: end if;
320:
321: -- Bug 6665510: FP: Japan Tax Reform Project (Start)
322: if (p_log_level_rec.statement_level) then
323: fa_debug_pkg.add('FAXGFR','+++ guarantee_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);
324: fa_debug_pkg.add('FAXGFR','+++ X_calling_interface', X_calling_interface, p_log_level_rec);
325: end if;
326:
327: if fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' then

Line 327: if fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' then

323: fa_debug_pkg.add('FAXGFR','+++ guarantee_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);
324: fa_debug_pkg.add('FAXGFR','+++ X_calling_interface', X_calling_interface, p_log_level_rec);
325: end if;
326:
327: if fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' then
328: if X_calling_interface is null then
329: if (p_log_level_rec.statement_level) then
330: fa_debug_pkg.add('FAXGFR','+++ Fetching current rate from fa_books', 'YES', p_log_level_rec);
331: end if; -- p_log_level_rec.statement_level

Line 560: last_pro_cal := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;

556: null;
557: else
558: -- fazcbc cache should have already been called, dont'd call it again
559: last_book := X_dpr.book;
560: last_pro_cal := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;
561: last_divide_evenly_flag :=
562: substr (fa_cache_pkg.fazcbc_record.DEPRN_ALLOCATION_CODE,1,1) = 'E';
563:
564: if not fa_cache_pkg.fazcct (last_pro_cal) then

Line 562: substr (fa_cache_pkg.fazcbc_record.DEPRN_ALLOCATION_CODE,1,1) = 'E';

558: -- fazcbc cache should have already been called, dont'd call it again
559: last_book := X_dpr.book;
560: last_pro_cal := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;
561: last_divide_evenly_flag :=
562: substr (fa_cache_pkg.fazcbc_record.DEPRN_ALLOCATION_CODE,1,1) = 'E';
563:
564: if not fa_cache_pkg.fazcct (last_pro_cal) then
565: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf',
566: p_log_level_rec => p_log_level_rec);

Line 564: if not fa_cache_pkg.fazcct (last_pro_cal) then

560: last_pro_cal := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;
561: last_divide_evenly_flag :=
562: substr (fa_cache_pkg.fazcbc_record.DEPRN_ALLOCATION_CODE,1,1) = 'E';
563:
564: if not fa_cache_pkg.fazcct (last_pro_cal) then
565: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf',
566: p_log_level_rec => p_log_level_rec);
567: return (FALSE);
568: end if;

Line 569: p_pers_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

565: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf',
566: p_log_level_rec => p_log_level_rec);
567: return (FALSE);
568: end if;
569: p_pers_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
570:
571: if not fa_cache_pkg.fazcct (X_dpr.calendar_type, p_log_level_rec) then
572: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf',
573: p_log_level_rec => p_log_level_rec);

Line 571: if not fa_cache_pkg.fazcct (X_dpr.calendar_type, p_log_level_rec) then

567: return (FALSE);
568: end if;
569: p_pers_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
570:
571: if not fa_cache_pkg.fazcct (X_dpr.calendar_type, p_log_level_rec) then
572: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf',
573: p_log_level_rec => p_log_level_rec);
574: return (FALSE);
575: end if;

Line 593: if not fa_cache_pkg.fazcff (last_pro_cal, X_dpr.book, X_y_begin,h_p_period_fracs, p_log_level_rec) then

589:
590: h_b_temp := (X_d_pers_per_yr - X_dp_begin) / X_d_pers_per_yr;
591:
592: else
593: if not fa_cache_pkg.fazcff (last_pro_cal, X_dpr.book, X_y_begin,h_p_period_fracs, p_log_level_rec) then
594: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf',
595: p_log_level_rec => p_log_level_rec);
596: return (FALSE);
597: end if;

Line 599: if not fa_cache_pkg.fazcff (X_dpr.calendar_type,X_dpr.book,X_y_begin,h_d_period_fracs, p_log_level_rec) then

595: p_log_level_rec => p_log_level_rec);
596: return (FALSE);
597: end if;
598:
599: if not fa_cache_pkg.fazcff (X_dpr.calendar_type,X_dpr.book,X_y_begin,h_d_period_fracs, p_log_level_rec) then
600: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf',
601: p_log_level_rec => p_log_level_rec);
602: return (FALSE);
603: end if;

Line 664: h_cur_fy := fa_cache_pkg.fazcbc_record.CURRENT_FISCAL_YEAR;

660: return(FALSE);
661: end if;
662:
663: if X_y_ret <> 0 then
664: h_cur_fy := fa_cache_pkg.fazcbc_record.CURRENT_FISCAL_YEAR;
665:
666: if last_divide_evenly_flag then
667: --Bug6187408
668: --Added the conditon to check for daily prorate and first period.

Line 679: if not fa_cache_pkg.fazcff (last_pro_cal, X_dpr.book, X_y_ret,

675: h_r_temp := (X_dp_r_ptr - 1) / X_d_pers_per_yr;
676: end if;
677:
678: else
679: if not fa_cache_pkg.fazcff (last_pro_cal, X_dpr.book, X_y_ret,
680: h_p_period_fracs
681: ,p_log_level_rec => p_log_level_rec) then
682: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf',
683: p_log_level_rec => p_log_level_rec);

Line 687: -- Bug#4953366: if not fa_cache_pkg.fazcff (X_dpr.calendar_type, X_dpr.book, X_y_ret,

683: p_log_level_rec => p_log_level_rec);
684: return (FALSE);
685: end if;
686:
687: -- Bug#4953366: if not fa_cache_pkg.fazcff (X_dpr.calendar_type, X_dpr.book, X_y_ret,
688: if not fa_cache_pkg.fazcff (X_dpr.calendar_type, X_dpr.book, h_cur_fy,
689: h_d_period_fracs
690: ,p_log_level_rec => p_log_level_rec) then
691: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf',

Line 688: if not fa_cache_pkg.fazcff (X_dpr.calendar_type, X_dpr.book, h_cur_fy,

684: return (FALSE);
685: end if;
686:
687: -- Bug#4953366: if not fa_cache_pkg.fazcff (X_dpr.calendar_type, X_dpr.book, X_y_ret,
688: if not fa_cache_pkg.fazcff (X_dpr.calendar_type, X_dpr.book, h_cur_fy,
689: h_d_period_fracs
690: ,p_log_level_rec => p_log_level_rec) then
691: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf',
692: p_log_level_rec => p_log_level_rec);

Line 771: if not fa_cache_pkg.fazcff (last_pro_cal, X_dpr.book, X_y_dead,

767: end if;
768:
769: h_d_temp := (X_dp_d_ptr - 1) / X_d_pers_per_yr;
770: else
771: if not fa_cache_pkg.fazcff (last_pro_cal, X_dpr.book, X_y_dead,
772: h_p_period_fracs, p_log_level_rec) then
773: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf',
774: p_log_level_rec => p_log_level_rec);
775: return (FALSE);

Line 778: if not fa_cache_pkg.fazcff (X_dpr.calendar_type, X_dpr.book, X_y_dead,

774: p_log_level_rec => p_log_level_rec);
775: return (FALSE);
776: end if;
777:
778: if not fa_cache_pkg.fazcff (X_dpr.calendar_type, X_dpr.book, X_y_dead,
779: h_d_period_fracs, p_log_level_rec) then
780: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf',
781: p_log_level_rec => p_log_level_rec);
782: return (FALSE);

Line 1365: if not fa_cache_pkg.fazccmt (dpr_in.method_code,dpr_in.life, p_log_level_rec) then

1361: last_year_frac := 0;
1362: ret_perd_frac := 0;
1363: ret_year_frac := 0;
1364:
1365: if not fa_cache_pkg.fazccmt (dpr_in.method_code,dpr_in.life, p_log_level_rec) then
1366:
1367: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcde',
1368: p_log_level_rec => p_log_level_rec);
1369: return (FALSE);

Line 1372: method_id := fa_cache_pkg.fazccmt_record.method_id;

1368: p_log_level_rec => p_log_level_rec);
1369: return (FALSE);
1370: end if;
1371:
1372: method_id := fa_cache_pkg.fazccmt_record.method_id;
1373: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1374: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1375: polish_adj_calc_basis_flag
1376: := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;

Line 1373: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

1369: return (FALSE);
1370: end if;
1371:
1372: method_id := fa_cache_pkg.fazccmt_record.method_id;
1373: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1374: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1375: polish_adj_calc_basis_flag
1376: := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;
1377: p_subtract_ytd_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;

Line 1374: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

1370: end if;
1371:
1372: method_id := fa_cache_pkg.fazccmt_record.method_id;
1373: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1374: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1375: polish_adj_calc_basis_flag
1376: := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;
1377: p_subtract_ytd_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;
1378:

Line 1376: := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;

1372: method_id := fa_cache_pkg.fazccmt_record.method_id;
1373: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1374: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1375: polish_adj_calc_basis_flag
1376: := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;
1377: p_subtract_ytd_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;
1378:
1379: if fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' then
1380: excl_sal_val_flag := TRUE;

Line 1377: p_subtract_ytd_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;

1373: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1374: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1375: polish_adj_calc_basis_flag
1376: := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;
1377: p_subtract_ytd_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;
1378:
1379: if fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' then
1380: excl_sal_val_flag := TRUE;
1381: else

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

1375: polish_adj_calc_basis_flag
1376: := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;
1377: p_subtract_ytd_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;
1378:
1379: if fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' then
1380: excl_sal_val_flag := TRUE;
1381: else
1382: excl_sal_val_flag := FALSE;
1383: end if;

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

1381: else
1382: excl_sal_val_flag := FALSE;
1383: end if;
1384:
1385: if fa_cache_pkg.fazccmt_record.depreciate_lastyear_flag = 'YES' then
1386: depr_last_year_flag := TRUE;
1387: else
1388: depr_last_year_flag := FALSE;
1389: end if;

Line 1391: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then

1387: else
1388: depr_last_year_flag := FALSE;
1389: end if;
1390:
1391: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then
1392: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;
1393: end if;
1394:
1395: -- One of these will be true

Line 1392: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;

1388: depr_last_year_flag := FALSE;
1389: end if;
1390:
1391: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then
1392: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;
1393: end if;
1394:
1395: -- One of these will be true
1396: calc_rate_src_flag := (rate_source_rule = 'CALCULATED');

Line 1480: prorate_calendar := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;

1476: --
1477: -- fazcbc cache should have already been called don't call again
1478: -- BUG# 4027981 - use the mrc enabled cache for nbv_amount_threshold
1479:
1480: prorate_calendar := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;
1481: nbv_frac_thresh := nvl(fa_cache_pkg.fazcbc_record.NBV_FRACTION_THRESHOLD,
1482: fa_std_types.FA_DEF_NBV_FRAC);
1483: nbv_amt_thresh := nvl(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,
1484: fa_std_types.FA_DEF_NBV_AMT);

Line 1481: nbv_frac_thresh := nvl(fa_cache_pkg.fazcbc_record.NBV_FRACTION_THRESHOLD,

1477: -- fazcbc cache should have already been called don't call again
1478: -- BUG# 4027981 - use the mrc enabled cache for nbv_amount_threshold
1479:
1480: prorate_calendar := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;
1481: nbv_frac_thresh := nvl(fa_cache_pkg.fazcbc_record.NBV_FRACTION_THRESHOLD,
1482: fa_std_types.FA_DEF_NBV_FRAC);
1483: nbv_amt_thresh := nvl(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,
1484: fa_std_types.FA_DEF_NBV_AMT);
1485: amo_reval_rsv_flag :=

Line 1483: nbv_amt_thresh := nvl(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,

1479:
1480: prorate_calendar := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;
1481: nbv_frac_thresh := nvl(fa_cache_pkg.fazcbc_record.NBV_FRACTION_THRESHOLD,
1482: fa_std_types.FA_DEF_NBV_FRAC);
1483: nbv_amt_thresh := nvl(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,
1484: fa_std_types.FA_DEF_NBV_AMT);
1485: amo_reval_rsv_flag :=
1486: (fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG = 'YES');
1487: fy_name := fa_cache_pkg.fazcbc_record.FISCAL_YEAR_NAME;

Line 1486: (fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG = 'YES');

1482: fa_std_types.FA_DEF_NBV_FRAC);
1483: nbv_amt_thresh := nvl(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,
1484: fa_std_types.FA_DEF_NBV_AMT);
1485: amo_reval_rsv_flag :=
1486: (fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG = 'YES');
1487: fy_name := fa_cache_pkg.fazcbc_record.FISCAL_YEAR_NAME;
1488: cur_fy := fa_cache_pkg.fazcbc_record.CURRENT_FISCAL_YEAR;
1489:
1490: --

Line 1487: fy_name := fa_cache_pkg.fazcbc_record.FISCAL_YEAR_NAME;

1483: nbv_amt_thresh := nvl(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,
1484: fa_std_types.FA_DEF_NBV_AMT);
1485: amo_reval_rsv_flag :=
1486: (fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG = 'YES');
1487: fy_name := fa_cache_pkg.fazcbc_record.FISCAL_YEAR_NAME;
1488: cur_fy := fa_cache_pkg.fazcbc_record.CURRENT_FISCAL_YEAR;
1489:
1490: --
1491: -- Get the number of periods per year in the depreciation calendar

Line 1488: cur_fy := fa_cache_pkg.fazcbc_record.CURRENT_FISCAL_YEAR;

1484: fa_std_types.FA_DEF_NBV_AMT);
1485: amo_reval_rsv_flag :=
1486: (fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG = 'YES');
1487: fy_name := fa_cache_pkg.fazcbc_record.FISCAL_YEAR_NAME;
1488: cur_fy := fa_cache_pkg.fazcbc_record.CURRENT_FISCAL_YEAR;
1489:
1490: --
1491: -- Get the number of periods per year in the depreciation calendar
1492: --

Line 1493: if not fa_cache_pkg.fazcct(dpr_in.calendar_type) then

1489:
1490: --
1491: -- Get the number of periods per year in the depreciation calendar
1492: --
1493: if not fa_cache_pkg.fazcct(dpr_in.calendar_type) then
1494: fa_srvr_msg.add_message(calling_fn => 'fa_cde_pkg.faxcde',
1495: p_log_level_rec => p_log_level_rec);
1496: return (FALSE);
1497: end if;

Line 1499: perds_per_yr_dcal := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

1495: p_log_level_rec => p_log_level_rec);
1496: return (FALSE);
1497: end if;
1498:
1499: perds_per_yr_dcal := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
1500:
1501: --
1502: -- Get the number of periods per year in the rate calendar
1503: --

Line 1504: if not fa_cache_pkg.fazcct(prorate_calendar) then

1500:
1501: --
1502: -- Get the number of periods per year in the rate calendar
1503: --
1504: if not fa_cache_pkg.fazcct(prorate_calendar) then
1505: fa_srvr_msg.add_message(calling_fn => 'fa_cde_pkg.faxcde',
1506: p_log_level_rec => p_log_level_rec);
1507: return (FALSE);
1508: end if;

Line 1510: perds_per_yr_pcal := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

1506: p_log_level_rec => p_log_level_rec);
1507: return (FALSE);
1508: end if;
1509:
1510: perds_per_yr_pcal := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
1511:
1512: --
1513: -- Determine the actual Deprn Start Date to use: this is the
1514: -- dpr_in.deprn_start_date, unless the method is STL (calc_rate_src_flag)

Line 1530: if not fa_cache_pkg.fazccp(dpr_in.calendar_type,

1526: -- Get the depreciation start period, and the corresponding
1527: -- fiscal year. We use h_dummy to hold the returned start
1528: -- date, which we don't need.
1529: --
1530: if not fa_cache_pkg.fazccp(dpr_in.calendar_type,
1531: fy_name,
1532: actual_deprn_start_jdate,
1533: deprn_period_dcal_begin,
1534: deprn_year_dcal_begin,

Line 1546: if not fa_cache_pkg.fazccp(prorate_calendar

1542: --
1543: -- Get the depreciation start prorate period, and the corresponding
1544: -- fiscal year
1545: --
1546: if not fa_cache_pkg.fazccp(prorate_calendar
1547: , fy_name
1548: , actual_deprn_start_jdate
1549: , deprn_period_pcal_begin
1550: , deprn_year_pcal_begin

Line 1561: if not fa_cache_pkg.fazccp(prorate_calendar

1557:
1558: --
1559: -- Get the prorate period, and the corresponding fiscal year
1560: --
1561: if not fa_cache_pkg.fazccp(prorate_calendar
1562: , fy_name
1563: , dpr_in.prorate_jdate
1564: , prorate_period_pcal_begin
1565: , prorate_year_pcal_begin

Line 1595: if not fa_cache_pkg.fazccp(dpr_in.calendar_type

1591: end if;
1592:
1593: if dpr_in.jdate_retired <> 0 and
1594: dpr_in.ret_prorate_jdate <> 0 then
1595: if not fa_cache_pkg.fazccp(dpr_in.calendar_type
1596: , fy_name
1597: , dpr_in.jdate_retired
1598: , ret_period_dcal
1599: , ret_year_pcal

Line 1611: if not fa_cache_pkg.fazccp(prorate_calendar

1607: -- assign y_ret to fy_ret as it gets overwritten in next call
1608: -- to fazccp. Fix for 1418257
1609: fy_ret := ret_year_pcal;
1610:
1611: if not fa_cache_pkg.fazccp(prorate_calendar
1612: , fy_name
1613: , dpr_in.jdate_retired
1614: , ret_period_pcal
1615: , ret_year_pcal

Line 1623: if not fa_cache_pkg.fazccp(prorate_calendar

1619: p_log_level_rec => p_log_level_rec);
1620: return (FALSE);
1621: end if;
1622:
1623: if not fa_cache_pkg.fazccp(prorate_calendar
1624: , fy_name
1625: , dpr_in.ret_prorate_jdate
1626: , ret_prorate_period_pcal
1627: , ret_year_pcal

Line 1818: if not fa_cache_pkg.fazcff(dpr.calendar_type

1814: year_prod :=0 ;
1815: actual_annual_deprn_amt := 0;
1816: actual_annual_bonus_deprn_amt := 0;
1817:
1818: if not fa_cache_pkg.fazcff(dpr.calendar_type
1819: , dpr.book
1820: , fyctr
1821: , perds_fracs_arr
1822: , p_log_level_rec) then

Line 1882: -- bonus: put fa_cache_pkg.fazcbf here, and erase all calls later!

1878: deprn_start_perd := 1;
1879: deprn_end_perd := perds_per_yr_dcal;
1880: end if;
1881:
1882: -- bonus: put fa_cache_pkg.fazcbf here, and erase all calls later!
1883: --
1884: -- Get rate from FA_BONUS_RATES table
1885: --
1886: if nvl(dpr.bonus_rule, 'NONE') <> 'NONE' then

Line 1891: if not fa_cache_pkg.fazcbr(dpr.bonus_rule

1887: --
1888: -- Get rate from FA_BONUS_RATES table
1889: --
1890:
1891: if not fa_cache_pkg.fazcbr(dpr.bonus_rule
1892: , (fyctr - prorate_year_pcal_begin + 1)
1893: , dpr_out.bonus_rate_used
1894: , dpr_out.deprn_factor_used
1895: , dpr_out.alternate_deprn_factor_used

Line 1922: l_period_counter := fyctr * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + perd_ctr;

1918: -- to this asset.
1919: --
1920: if (dpr.super_group_id is not null) then
1921:
1922: l_period_counter := fyctr * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + perd_ctr;
1923:
1924: if not fa_cache_pkg.fazcsgr(x_super_group_id => dpr.super_group_id
1925: , x_book_type_code => dpr.book
1926: , x_period_counter => l_period_counter

Line 1924: if not fa_cache_pkg.fazcsgr(x_super_group_id => dpr.super_group_id

1920: if (dpr.super_group_id is not null) then
1921:
1922: l_period_counter := fyctr * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + perd_ctr;
1923:
1924: if not fa_cache_pkg.fazcsgr(x_super_group_id => dpr.super_group_id
1925: , x_book_type_code => dpr.book
1926: , x_period_counter => l_period_counter
1927: , p_log_level_rec => p_log_level_rec) then
1928: return (FALSE);

Line 1931: dpr.adj_rate := nvl(fa_cache_pkg.fazcsgr_record.adjusted_rate, dpr.adj_rate);

1927: , p_log_level_rec => p_log_level_rec) then
1928: return (FALSE);
1929: end if;
1930:
1931: dpr.adj_rate := nvl(fa_cache_pkg.fazcsgr_record.adjusted_rate, dpr.adj_rate);
1932: adj_rec_cost := nvl(dpr.cost * fa_cache_pkg.fazcsgr_record.percent_salvage_value, adj_rec_cost);
1933: fa_round_pkg.fa_floor(adj_rec_cost, dpr.book
1934: ,p_log_level_rec => p_log_level_rec);
1935:

Line 1932: adj_rec_cost := nvl(dpr.cost * fa_cache_pkg.fazcsgr_record.percent_salvage_value, adj_rec_cost);

1928: return (FALSE);
1929: end if;
1930:
1931: dpr.adj_rate := nvl(fa_cache_pkg.fazcsgr_record.adjusted_rate, dpr.adj_rate);
1932: adj_rec_cost := nvl(dpr.cost * fa_cache_pkg.fazcsgr_record.percent_salvage_value, adj_rec_cost);
1933: fa_round_pkg.fa_floor(adj_rec_cost, dpr.book
1934: ,p_log_level_rec => p_log_level_rec);
1935:
1936: if (p_log_level_rec.statement_level) then

Line 1996: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES' then

1992: -- bonus: including bonus_rate for formula
1993: -- therefore not clearing bonus_rate, compare with production method.
1994:
1995: -- Bug 6665510: FP: Japan Tax Reform Project (Start)
1996: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES' then
1997: if (p_log_level_rec.statement_level) then
1998: fa_debug_pkg.add('faxcde', '+++ JAPAN ', 'in guarantee rate', p_log_level_rec);
1999: end if;
2000:

Line 2211: if not fa_cache_pkg.fazccl(dpr.ceil_name, dpr.jdate_in_service

2207: --
2208: -- Get Ceiling Information from FA_CEILING_TYPES
2209: -- and FA_CEILINGS
2210: --
2211: if not fa_cache_pkg.fazccl(dpr.ceil_name, dpr.jdate_in_service
2212: , fyctr - prorate_year_pcal_begin + 1, deprn_ceiling_amt
2213: ,p_log_level_rec => p_log_level_rec) then
2214: fa_srvr_msg.add_message(calling_fn => 'fa_cde_pkg.faxcde',
2215: p_log_level_rec => p_log_level_rec);

Line 2575: fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, p_log_level_rec);

2571: if (nvl(p_subtract_ytd_flag,'N') = 'Y') then
2572:
2573: if (p_log_level_rec.statement_level) then
2574: fa_debug_pkg.add(l_calling_fn||' OPA', 'cache: use_eofy_reserve_flag',
2575: fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, p_log_level_rec);
2576: fa_debug_pkg.add(l_calling_fn||' OPA', 'cache: allow_reduction_rate_flag',
2577: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, p_log_level_rec);
2578: fa_debug_pkg.add(l_calling_fn||' OPA', 'cache: rate_source_rule',
2579: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);

Line 2577: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, p_log_level_rec);

2573: if (p_log_level_rec.statement_level) then
2574: fa_debug_pkg.add(l_calling_fn||' OPA', 'cache: use_eofy_reserve_flag',
2575: fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, p_log_level_rec);
2576: fa_debug_pkg.add(l_calling_fn||' OPA', 'cache: allow_reduction_rate_flag',
2577: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, p_log_level_rec);
2578: fa_debug_pkg.add(l_calling_fn||' OPA', 'cache: rate_source_rule',
2579: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);
2580: fa_debug_pkg.add(l_calling_fn||' OPA', 'cache: deprn_basis_rule',
2581: fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec);

Line 2579: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);

2575: fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, p_log_level_rec);
2576: fa_debug_pkg.add(l_calling_fn||' OPA', 'cache: allow_reduction_rate_flag',
2577: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, p_log_level_rec);
2578: fa_debug_pkg.add(l_calling_fn||' OPA', 'cache: rate_source_rule',
2579: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);
2580: fa_debug_pkg.add(l_calling_fn||' OPA', 'cache: deprn_basis_rule',
2581: fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec);
2582: end if;
2583:

Line 2581: fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec);

2577: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, p_log_level_rec);
2578: fa_debug_pkg.add(l_calling_fn||' OPA', 'cache: rate_source_rule',
2579: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);
2580: fa_debug_pkg.add(l_calling_fn||' OPA', 'cache: deprn_basis_rule',
2581: fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec);
2582: end if;
2583:
2584: --
2585: -- Change for OPA

Line 2587: if (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' and

2583:
2584: --
2585: -- Change for OPA
2586: --
2587: if (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' and
2588: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag = 'N' and
2589: fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' and
2590: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'COST') then
2591: --

Line 2588: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag = 'N' and

2584: --
2585: -- Change for OPA
2586: --
2587: if (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' and
2588: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag = 'N' and
2589: fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' and
2590: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'COST') then
2591: --
2592: -- Find ytd using (reserve - eofy reserve)

Line 2589: fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' and

2585: -- Change for OPA
2586: --
2587: if (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' and
2588: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag = 'N' and
2589: fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' and
2590: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'COST') then
2591: --
2592: -- Find ytd using (reserve - eofy reserve)
2593: -- find remaining period in fy using (num per in fy - period num + 1)

Line 2590: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'COST') then

2586: --
2587: if (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' and
2588: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag = 'N' and
2589: fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' and
2590: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'COST') then
2591: --
2592: -- Find ytd using (reserve - eofy reserve)
2593: -- find remaining period in fy using (num per in fy - period num + 1)
2594: -- formula to find peridic exp is

Line 2661: if (fa_cache_pkg.fa_deprn_override_enabled) then

2657: --
2658: override_depr_amt:= NULL;
2659: override_bonus_amt:= NULL;
2660:
2661: if (fa_cache_pkg.fa_deprn_override_enabled) then
2662: value := 'Y';
2663: else
2664: value := 'N';
2665: end if;

Line 2759: nvl(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' and

2755:
2756: if (perd_ctr=perds_per_yr_dcal and
2757: (deprn_override_flag = fa_std_types.FA_NO_OVERRIDE or
2758: deprn_override_flag = fa_std_types.FA_OVERRIDE_BONUS) and
2759: nvl(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' and
2760: nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') ='N') then
2761:
2762: if (dpr.deprn_rounding_flag = fa_std_types.FA_DPR_ROUND_ADD or
2763: dpr.deprn_rounding_flag is null) then

Line 2760: nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') ='N') then

2756: if (perd_ctr=perds_per_yr_dcal and
2757: (deprn_override_flag = fa_std_types.FA_NO_OVERRIDE or
2758: deprn_override_flag = fa_std_types.FA_OVERRIDE_BONUS) and
2759: nvl(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' and
2760: nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') ='N') then
2761:
2762: if (dpr.deprn_rounding_flag = fa_std_types.FA_DPR_ROUND_ADD or
2763: dpr.deprn_rounding_flag is null) then
2764: --

Line 2942: if (nvl(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='Y') then -- ENERGY

2938: perd_deprn_exp := (cur_adj_cost / dpr.rate_adj_factor) *
2939: (perd_prod / dpr.adj_capacity);
2940:
2941: -- Main tain adj_capacity
2942: if (nvl(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='Y') then -- ENERGY
2943: dpr.adj_capacity := dpr.adj_capacity - perd_prod; -- ENERGY
2944: end if; -- ENERGY
2945:
2946: -- bonus: Not tracking for production.

Line 3551: (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null and

3547: -- BUG# 3769466
3548: -- avoid deprn basis call when not needed
3549:
3550: if (nbv_deprn_basis_flag or
3551: (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null and
3552: not (rate_source_rule = 'CALCULATED' and
3553: cost_deprn_basis_flag and
3554: nvl(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' and
3555: nvl(p_subtract_ytd_flag,'N') = 'N' and

Line 3554: nvl(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' and

3550: if (nbv_deprn_basis_flag or
3551: (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null and
3552: not (rate_source_rule = 'CALCULATED' and
3553: cost_deprn_basis_flag and
3554: nvl(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' and
3555: nvl(p_subtract_ytd_flag,'N') = 'N' and
3556: nvl(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'N'))) then
3557:
3558: -- Bug 6665510: FP: Japan Tax Reform Project (Start)

Line 3556: nvl(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'N'))) then

3552: not (rate_source_rule = 'CALCULATED' and
3553: cost_deprn_basis_flag and
3554: nvl(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' and
3555: nvl(p_subtract_ytd_flag,'N') = 'N' and
3556: nvl(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'N'))) then
3557:
3558: -- Bug 6665510: FP: Japan Tax Reform Project (Start)
3559: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES' then
3560:

Line 3559: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES' then

3555: nvl(p_subtract_ytd_flag,'N') = 'N' and
3556: nvl(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'N'))) then
3557:
3558: -- Bug 6665510: FP: Japan Tax Reform Project (Start)
3559: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES' then
3560:
3561: if (p_log_level_rec.statement_level) then
3562: fa_debug_pkg.add('faxcde', '+++ JAPAN ', 'in guarantee rate call deprn basis', p_log_level_rec);
3563: end if;

Line 4147: if fa_cache_pkg.fa_annual_round = 'ALWAYS' then

4143: begin <>
4144:
4145: if (not g_tested_use_annual_round) then
4146: -- fnd_profile.get('FA_ANNUAL_ROUND', value);
4147: if fa_cache_pkg.fa_annual_round = 'ALWAYS' then
4148: g_use_annual_round := ROUND_ALWAYS;
4149: else
4150: g_use_annual_round := ROUND_WITH_RESTRICTIONS;
4151: end if;

Line 4209: if NOT fa_cache_pkg.fazcbc(X_book => book

4205: -- fa_debug_pkg.initialize;
4206:
4207: return_code:= 11;
4208: -- call the cache for the primary transaction book
4209: if NOT fa_cache_pkg.fazcbc(X_book => book
4210: ,p_log_level_rec => p_log_level_rec) then
4211: return_code:= 7;
4212: raise faodda_err;
4213: end if;

Line 4228: h_set_of_books_id := NVL(fa_cache_pkg.fazcbcs_record.set_of_books_id,

4224: -- Modified for MRC
4225: -- couldn't get set_of_books_id correctly,
4226: -- so added p_mrc_sob_type_code to paramter
4227: IF p_mrc_sob_type_code = 'R' THEN
4228: h_set_of_books_id := NVL(fa_cache_pkg.fazcbcs_record.set_of_books_id,
4229: fa_cache_pkg.fazcbc_record.set_of_books_id);
4230: h_reporting_flag := 'R';
4231: ELSE
4232: h_set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

Line 4229: fa_cache_pkg.fazcbc_record.set_of_books_id);

4225: -- couldn't get set_of_books_id correctly,
4226: -- so added p_mrc_sob_type_code to paramter
4227: IF p_mrc_sob_type_code = 'R' THEN
4228: h_set_of_books_id := NVL(fa_cache_pkg.fazcbcs_record.set_of_books_id,
4229: fa_cache_pkg.fazcbc_record.set_of_books_id);
4230: h_reporting_flag := 'R';
4231: ELSE
4232: h_set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
4233: h_reporting_flag := 'P';

Line 4232: h_set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

4228: h_set_of_books_id := NVL(fa_cache_pkg.fazcbcs_record.set_of_books_id,
4229: fa_cache_pkg.fazcbc_record.set_of_books_id);
4230: h_reporting_flag := 'R';
4231: ELSE
4232: h_set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
4233: h_reporting_flag := 'P';
4234: END IF;
4235:
4236: if (p_log_level_rec.statement_level) then

Line 4254: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;

4250: from fa_book_controls bc, fa_calendar_types ct
4251: where bc.book_type_code = book
4252: and bc.deprn_calendar = ct.calendar_type;
4253: */
4254: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;
4255: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;
4256: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
4257:
4258: return_code:= 13;

Line 4255: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;

4251: where bc.book_type_code = book
4252: and bc.deprn_calendar = ct.calendar_type;
4253: */
4254: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;
4255: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;
4256: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
4257:
4258: return_code:= 13;
4259:

Line 4256: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;

4252: and bc.deprn_calendar = ct.calendar_type;
4253: */
4254: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;
4255: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;
4256: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
4257:
4258: return_code:= 13;
4259:
4260: