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 46: h_dist_book := fa_cache_pkg.fazcbc_record.distribution_source_book;

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

Line 154: IF (NOT fa_cache_pkg.fazccmt(X_Method => X_Method_Code,

150:
151: BEGIN <>
152:
153: -- Fix for Bug #2629724. Call the fazccmt cache to improve perf.
154: IF (NOT fa_cache_pkg.fazccmt(X_Method => X_Method_Code,
155: X_Life => X_Life_In_Months,
156: p_log_level_rec => p_log_level_rec)) THEN
157: RAISE cache_exception;
158: END IF;

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

156: p_log_level_rec => p_log_level_rec)) THEN
157: RAISE cache_exception;
158: END IF;
159:
160: h_method_id := fa_cache_pkg.fazccmt_record.method_id;
161: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
162: h_formula_parsed := fa_cache_pkg.fazcfor_record.formula_parsed;
163:
164: h_count1 := INSTR (h_formula_parsed, 'REMAINING_LIFE1');

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

157: RAISE cache_exception;
158: END IF;
159:
160: h_method_id := fa_cache_pkg.fazccmt_record.method_id;
161: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
162: h_formula_parsed := fa_cache_pkg.fazcfor_record.formula_parsed;
163:
164: h_count1 := INSTR (h_formula_parsed, 'REMAINING_LIFE1');
165: h_count2 := INSTR (h_formula_parsed, 'REMAINING_LIFE2');

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

158: END IF;
159:
160: h_method_id := fa_cache_pkg.fazccmt_record.method_id;
161: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
162: h_formula_parsed := fa_cache_pkg.fazcfor_record.formula_parsed;
163:
164: h_count1 := INSTR (h_formula_parsed, 'REMAINING_LIFE1');
165: h_count2 := INSTR (h_formula_parsed, 'REMAINING_LIFE2');
166: h_prod_method := INSTR (fa_cache_pkg.fazcfor_record.formula_actual, 'CAPACITY');

Line 166: h_prod_method := INSTR (fa_cache_pkg.fazcfor_record.formula_actual, 'CAPACITY');

162: h_formula_parsed := fa_cache_pkg.fazcfor_record.formula_parsed;
163:
164: h_count1 := INSTR (h_formula_parsed, 'REMAINING_LIFE1');
165: h_count2 := INSTR (h_formula_parsed, 'REMAINING_LIFE2');
166: h_prod_method := INSTR (fa_cache_pkg.fazcfor_record.formula_actual, 'CAPACITY');
167:
168: X_Method_Type := 0;
169:
170: -- Bug:5930979:Japan Tax Reform Project (Start)

Line 171: IF fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' THEN

167:
168: X_Method_Type := 0;
169:
170: -- Bug:5930979:Japan Tax Reform Project (Start)
171: IF fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' THEN
172:
173: IF (p_log_level_rec.statement_level) THEN
174: fa_debug_pkg.ADD('FAXGFR','+++ in', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);
175: fa_debug_pkg.ADD('FAXGFR','+++ X_new_cost', X_new_cost, p_log_level_rec);

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

170: -- Bug:5930979:Japan Tax Reform Project (Start)
171: IF fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' THEN
172:
173: IF (p_log_level_rec.statement_level) THEN
174: fa_debug_pkg.ADD('FAXGFR','+++ in', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);
175: fa_debug_pkg.ADD('FAXGFR','+++ X_new_cost', X_new_cost, p_log_level_rec);
176: fa_debug_pkg.ADD('FAXGFR','+++ X_adjusted_cost', X_adjusted_cost, p_log_level_rec);
177: END IF;
178:

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

335: END IF;
336:
337: -- Bug:5930979:Japan Tax Reform Project (Start)
338: IF (p_log_level_rec.statement_level) THEN
339: fa_debug_pkg.ADD('FAXGFR','+++ guarantee_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);
340: fa_debug_pkg.ADD('FAXGFR','+++ X_calling_interface', X_calling_interface, p_log_level_rec);
341: fa_debug_pkg.ADD('FAXGFR','+++ guarantee_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);
342: fa_debug_pkg.ADD('FAXGFR','+++ X_calling_interface', X_calling_interface, p_log_level_rec);
343: fa_debug_pkg.ADD('FAXGFR','+++ X_rate', X_rate, p_log_level_rec);

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

337: -- Bug:5930979:Japan Tax Reform Project (Start)
338: IF (p_log_level_rec.statement_level) THEN
339: fa_debug_pkg.ADD('FAXGFR','+++ guarantee_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);
340: fa_debug_pkg.ADD('FAXGFR','+++ X_calling_interface', X_calling_interface, p_log_level_rec);
341: fa_debug_pkg.ADD('FAXGFR','+++ guarantee_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, p_log_level_rec);
342: fa_debug_pkg.ADD('FAXGFR','+++ X_calling_interface', X_calling_interface, p_log_level_rec);
343: fa_debug_pkg.ADD('FAXGFR','+++ X_rate', X_rate, p_log_level_rec);
344: END IF;
345:

Line 346: IF fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' THEN

342: fa_debug_pkg.ADD('FAXGFR','+++ X_calling_interface', X_calling_interface, p_log_level_rec);
343: fa_debug_pkg.ADD('FAXGFR','+++ X_rate', X_rate, p_log_level_rec);
344: END IF;
345:
346: IF fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' THEN
347: IF X_calling_interface IS NULL THEN
348: IF (p_log_level_rec.statement_level) THEN
349: fa_debug_pkg.ADD('FAXGFR','+++ Fetching current rate from fa_books', 'YES', p_log_level_rec => p_log_level_rec);
350: END IF; -- _debug

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

576: NULL;
577: ELSE
578: -- fazcbc cache should have already been called, dont'd call it again
579: last_book := X_dpr.book;
580: last_pro_cal := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;
581: last_divide_evenly_flag := SUBSTR (fa_cache_pkg.fazcbc_record.DEPRN_ALLOCATION_CODE,1,1) = 'E';
582:
583: IF NOT fa_cache_pkg.fazcct (last_pro_cal, p_log_level_rec => p_log_level_rec) THEN
584: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf', p_log_level_rec => p_log_level_rec);

Line 581: last_divide_evenly_flag := SUBSTR (fa_cache_pkg.fazcbc_record.DEPRN_ALLOCATION_CODE,1,1) = 'E';

577: ELSE
578: -- fazcbc cache should have already been called, dont'd call it again
579: last_book := X_dpr.book;
580: last_pro_cal := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;
581: last_divide_evenly_flag := SUBSTR (fa_cache_pkg.fazcbc_record.DEPRN_ALLOCATION_CODE,1,1) = 'E';
582:
583: IF NOT fa_cache_pkg.fazcct (last_pro_cal, p_log_level_rec => p_log_level_rec) THEN
584: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf', p_log_level_rec => p_log_level_rec);
585: RETURN (FALSE);

Line 583: IF NOT fa_cache_pkg.fazcct (last_pro_cal, p_log_level_rec => p_log_level_rec) THEN

579: last_book := X_dpr.book;
580: last_pro_cal := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;
581: last_divide_evenly_flag := SUBSTR (fa_cache_pkg.fazcbc_record.DEPRN_ALLOCATION_CODE,1,1) = 'E';
582:
583: IF NOT fa_cache_pkg.fazcct (last_pro_cal, p_log_level_rec => p_log_level_rec) THEN
584: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf', p_log_level_rec => p_log_level_rec);
585: RETURN (FALSE);
586: END IF;
587:

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

584: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf', p_log_level_rec => p_log_level_rec);
585: RETURN (FALSE);
586: END IF;
587:
588: p_pers_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
589:
590: IF NOT fa_cache_pkg.fazcct (X_dpr.calendar_type, p_log_level_rec => p_log_level_rec) THEN
591: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf', p_log_level_rec => p_log_level_rec);
592: RETURN (FALSE);

Line 590: IF NOT fa_cache_pkg.fazcct (X_dpr.calendar_type, p_log_level_rec => p_log_level_rec) THEN

586: END IF;
587:
588: p_pers_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
589:
590: IF NOT fa_cache_pkg.fazcct (X_dpr.calendar_type, p_log_level_rec => p_log_level_rec) THEN
591: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf', p_log_level_rec => p_log_level_rec);
592: RETURN (FALSE);
593: END IF;
594: END IF;

Line 612: IF NOT fa_cache_pkg.fazcff(last_pro_cal,

608: END IF;
609:
610: h_b_temp := (X_d_pers_per_yr - X_dp_begin) / X_d_pers_per_yr;
611: ELSE
612: IF NOT fa_cache_pkg.fazcff(last_pro_cal,
613: X_dpr.book,
614: X_y_begin,
615: h_p_period_fracs,
616: p_log_level_rec) THEN

Line 621: IF NOT fa_cache_pkg.fazcff(X_dpr.calendar_type,

617: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf', p_log_level_rec => p_log_level_rec);
618: RETURN (FALSE);
619: END IF;
620:
621: IF NOT fa_cache_pkg.fazcff(X_dpr.calendar_type,
622: X_dpr.book,
623: X_y_begin,
624: h_d_period_fracs,
625: p_log_level_rec) THEN

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

682: RETURN(FALSE);
683: END IF;
684:
685: IF X_y_ret <> 0 THEN
686: h_cur_fy := fa_cache_pkg.fazcbc_record.CURRENT_FISCAL_YEAR;
687:
688: IF last_divide_evenly_flag THEN
689: --Bug8620551
690: --Added the conditon to check for daily prorate and first period.

Line 706: IF NOT fa_cache_pkg.fazcff(last_pro_cal,

702: fa_debug_pkg.ADD('faxcfyf(1.5.1)','X_ry_frac', X_ry_frac, p_log_level_rec);
703: fa_debug_pkg.ADD('faxcfyf(1.5.1)','h_r_temp', h_r_temp, p_log_level_rec);
704: END IF;
705: ELSE
706: IF NOT fa_cache_pkg.fazcff(last_pro_cal,
707: X_dpr.book,
708: X_y_ret,
709: h_p_period_fracs,
710: p_log_level_rec) THEN

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

711: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf', p_log_level_rec => p_log_level_rec);
712: RETURN (FALSE);
713: END IF;
714:
715: -- Bug#4953366: if not fa_cache_pkg.fazcff (X_dpr.calendar_type, X_dpr.book, X_y_ret,
716: IF NOT fa_cache_pkg.fazcff(X_dpr.calendar_type,
717: X_dpr.book,
718: h_cur_fy,
719: h_d_period_fracs,

Line 716: IF NOT fa_cache_pkg.fazcff(X_dpr.calendar_type,

712: RETURN (FALSE);
713: END IF;
714:
715: -- Bug#4953366: if not fa_cache_pkg.fazcff (X_dpr.calendar_type, X_dpr.book, X_y_ret,
716: IF NOT fa_cache_pkg.fazcff(X_dpr.calendar_type,
717: X_dpr.book,
718: h_cur_fy,
719: h_d_period_fracs,
720: p_log_level_rec) THEN

Line 813: IF NOT fa_cache_pkg.fazcff(last_pro_cal,

809: END IF;
810:
811: h_d_temp := (X_dp_d_ptr - 1) / X_d_pers_per_yr;
812: ELSE
813: IF NOT fa_cache_pkg.fazcff(last_pro_cal,
814: X_dpr.book,
815: X_y_dead,
816: h_p_period_fracs,
817: p_log_level_rec) THEN

Line 822: IF NOT fa_cache_pkg.fazcff(X_dpr.calendar_type,

818: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcfyf', p_log_level_rec => p_log_level_rec);
819: RETURN (FALSE);
820: END IF;
821:
822: IF NOT fa_cache_pkg.fazcff(X_dpr.calendar_type,
823: X_dpr.book,
824: X_y_dead,
825: h_d_period_fracs,
826: p_log_level_rec) THEN

Line 1443: IF NOT fa_cache_pkg.fazccmt(dpr_in.method_code,

1439: last_year_frac := 0;
1440: ret_perd_frac := 0;
1441: ret_year_frac := 0;
1442:
1443: IF NOT fa_cache_pkg.fazccmt(dpr_in.method_code,
1444: dpr_in.life,
1445: p_log_level_rec => p_log_level_rec) THEN
1446: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcde', p_log_level_rec => p_log_level_rec);
1447: RETURN (FALSE);

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

1446: fa_srvr_msg.add_message (calling_fn => 'fa_cde_pkg.faxcde', p_log_level_rec => p_log_level_rec);
1447: RETURN (FALSE);
1448: END IF;
1449:
1450: method_id := fa_cache_pkg.fazccmt_record.method_id;
1451: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1452: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1453: polish_adj_calc_basis_flag := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;
1454: p_subtract_ytd_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;

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

1447: RETURN (FALSE);
1448: END IF;
1449:
1450: method_id := fa_cache_pkg.fazccmt_record.method_id;
1451: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1452: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1453: polish_adj_calc_basis_flag := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;
1454: p_subtract_ytd_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;
1455:

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

1448: END IF;
1449:
1450: method_id := fa_cache_pkg.fazccmt_record.method_id;
1451: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1452: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1453: polish_adj_calc_basis_flag := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;
1454: p_subtract_ytd_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;
1455:
1456: IF fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' THEN

Line 1453: polish_adj_calc_basis_flag := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;

1449:
1450: method_id := fa_cache_pkg.fazccmt_record.method_id;
1451: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1452: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1453: polish_adj_calc_basis_flag := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;
1454: p_subtract_ytd_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;
1455:
1456: IF fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' THEN
1457: excl_sal_val_flag := TRUE;

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

1450: method_id := fa_cache_pkg.fazccmt_record.method_id;
1451: rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1452: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1453: polish_adj_calc_basis_flag := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;
1454: p_subtract_ytd_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;
1455:
1456: IF fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' THEN
1457: excl_sal_val_flag := TRUE;
1458: ELSE

Line 1456: IF fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' THEN

1452: deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1453: polish_adj_calc_basis_flag := fa_cache_pkg.fazccmt_record.polish_adj_calc_basis_flag;
1454: p_subtract_ytd_flag := fa_cache_pkg.fazcdrd_record.subtract_ytd_flag;
1455:
1456: IF fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag = 'YES' THEN
1457: excl_sal_val_flag := TRUE;
1458: ELSE
1459: excl_sal_val_flag := FALSE;
1460: END IF;

Line 1462: IF fa_cache_pkg.fazccmt_record.depreciate_lastyear_flag = 'YES' THEN

1458: ELSE
1459: excl_sal_val_flag := FALSE;
1460: END IF;
1461:
1462: IF fa_cache_pkg.fazccmt_record.depreciate_lastyear_flag = 'YES' THEN
1463: depr_last_year_flag := TRUE;
1464: ELSE
1465: depr_last_year_flag := FALSE;
1466: END IF;

Line 1468: IF (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id IS NOT NULL) THEN

1464: ELSE
1465: depr_last_year_flag := FALSE;
1466: END IF;
1467:
1468: IF (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id IS NOT NULL) THEN
1469: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;
1470: END IF;
1471:
1472: -- One of these will be true

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

1465: depr_last_year_flag := FALSE;
1466: END IF;
1467:
1468: IF (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id IS NOT NULL) THEN
1469: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;
1470: END IF;
1471:
1472: -- One of these will be true
1473: calc_rate_src_flag := (rate_source_rule = 'CALCULATED');

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

1548: --
1549: -- fazcbc cache should have already been called don't call again
1550: -- BUG# 4027981 - use the mrc enabled cache for nbv_amount_threshold
1551:
1552: prorate_calendar := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;
1553: nbv_frac_thresh := NVL(fa_cache_pkg.fazcbc_record.NBV_FRACTION_THRESHOLD,
1554: fa_std_types.FA_DEF_NBV_FRAC);
1555: nbv_amt_thresh := NVL(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,
1556: fa_std_types.FA_DEF_NBV_AMT);

Line 1553: nbv_frac_thresh := NVL(fa_cache_pkg.fazcbc_record.NBV_FRACTION_THRESHOLD,

1549: -- fazcbc cache should have already been called don't call again
1550: -- BUG# 4027981 - use the mrc enabled cache for nbv_amount_threshold
1551:
1552: prorate_calendar := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;
1553: nbv_frac_thresh := NVL(fa_cache_pkg.fazcbc_record.NBV_FRACTION_THRESHOLD,
1554: fa_std_types.FA_DEF_NBV_FRAC);
1555: nbv_amt_thresh := NVL(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,
1556: fa_std_types.FA_DEF_NBV_AMT);
1557: amo_reval_rsv_flag := (fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG = 'YES');

Line 1555: nbv_amt_thresh := NVL(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,

1551:
1552: prorate_calendar := fa_cache_pkg.fazcbc_record.PRORATE_CALENDAR;
1553: nbv_frac_thresh := NVL(fa_cache_pkg.fazcbc_record.NBV_FRACTION_THRESHOLD,
1554: fa_std_types.FA_DEF_NBV_FRAC);
1555: nbv_amt_thresh := NVL(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,
1556: fa_std_types.FA_DEF_NBV_AMT);
1557: amo_reval_rsv_flag := (fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG = 'YES');
1558: fy_name := fa_cache_pkg.fazcbc_record.FISCAL_YEAR_NAME;
1559: cur_fy := fa_cache_pkg.fazcbc_record.CURRENT_FISCAL_YEAR;

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

1553: nbv_frac_thresh := NVL(fa_cache_pkg.fazcbc_record.NBV_FRACTION_THRESHOLD,
1554: fa_std_types.FA_DEF_NBV_FRAC);
1555: nbv_amt_thresh := NVL(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,
1556: fa_std_types.FA_DEF_NBV_AMT);
1557: amo_reval_rsv_flag := (fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG = 'YES');
1558: fy_name := fa_cache_pkg.fazcbc_record.FISCAL_YEAR_NAME;
1559: cur_fy := fa_cache_pkg.fazcbc_record.CURRENT_FISCAL_YEAR;
1560:
1561: --

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

1554: fa_std_types.FA_DEF_NBV_FRAC);
1555: nbv_amt_thresh := NVL(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,
1556: fa_std_types.FA_DEF_NBV_AMT);
1557: amo_reval_rsv_flag := (fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG = 'YES');
1558: fy_name := fa_cache_pkg.fazcbc_record.FISCAL_YEAR_NAME;
1559: cur_fy := fa_cache_pkg.fazcbc_record.CURRENT_FISCAL_YEAR;
1560:
1561: --
1562: -- Get the number of periods per year in the depreciation calendar

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

1555: nbv_amt_thresh := NVL(fa_cache_pkg.fazcbcs_record.NBV_AMOUNT_THRESHOLD,
1556: fa_std_types.FA_DEF_NBV_AMT);
1557: amo_reval_rsv_flag := (fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG = 'YES');
1558: fy_name := fa_cache_pkg.fazcbc_record.FISCAL_YEAR_NAME;
1559: cur_fy := fa_cache_pkg.fazcbc_record.CURRENT_FISCAL_YEAR;
1560:
1561: --
1562: -- Get the number of periods per year in the depreciation calendar
1563: --

Line 1564: IF NOT fa_cache_pkg.fazcct(dpr_in.calendar_type, p_log_level_rec => p_log_level_rec) THEN

1560:
1561: --
1562: -- Get the number of periods per year in the depreciation calendar
1563: --
1564: IF NOT fa_cache_pkg.fazcct(dpr_in.calendar_type, p_log_level_rec => p_log_level_rec) THEN
1565: fa_srvr_msg.add_message(calling_fn => 'fa_cde_pkg.faxcde', p_log_level_rec => p_log_level_rec);
1566: RETURN (FALSE);
1567: END IF;
1568:

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

1565: fa_srvr_msg.add_message(calling_fn => 'fa_cde_pkg.faxcde', p_log_level_rec => p_log_level_rec);
1566: RETURN (FALSE);
1567: END IF;
1568:
1569: perds_per_yr_dcal := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
1570:
1571: --
1572: -- Get the number of periods per year in the rate calendar
1573: --

Line 1574: IF NOT fa_cache_pkg.fazcct(prorate_calendar, p_log_level_rec => p_log_level_rec) THEN

1570:
1571: --
1572: -- Get the number of periods per year in the rate calendar
1573: --
1574: IF NOT fa_cache_pkg.fazcct(prorate_calendar, p_log_level_rec => p_log_level_rec) THEN
1575: fa_srvr_msg.add_message(calling_fn => 'fa_cde_pkg.faxcde', p_log_level_rec => p_log_level_rec);
1576: RETURN (FALSE);
1577: END IF;
1578:

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

1575: fa_srvr_msg.add_message(calling_fn => 'fa_cde_pkg.faxcde', p_log_level_rec => p_log_level_rec);
1576: RETURN (FALSE);
1577: END IF;
1578:
1579: perds_per_yr_pcal := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
1580:
1581: --
1582: -- Determine the actual Deprn Start Date to use: this is the
1583: -- dpr_in.deprn_start_date, unless the method is STL (calc_rate_src_flag)

Line 1599: IF NOT fa_cache_pkg.fazccp(dpr_in.calendar_type,

1595: -- Get the depreciation start period, and the corresponding
1596: -- fiscal year. We use h_dummy to hold the returned start
1597: -- date, which we don't need.
1598: --
1599: IF NOT fa_cache_pkg.fazccp(dpr_in.calendar_type,
1600: fy_name,
1601: actual_deprn_start_jdate,
1602: deprn_period_dcal_begin,
1603: deprn_year_dcal_begin,

Line 1614: IF NOT fa_cache_pkg.fazccp(prorate_calendar

1610: --
1611: -- Get the depreciation start prorate period, and the corresponding
1612: -- fiscal year
1613: --
1614: IF NOT fa_cache_pkg.fazccp(prorate_calendar
1615: , fy_name
1616: , actual_deprn_start_jdate
1617: , deprn_period_pcal_begin
1618: , deprn_year_pcal_begin

Line 1628: IF NOT fa_cache_pkg.fazccp(prorate_calendar

1624:
1625: --
1626: -- Get the prorate period, and the corresponding fiscal year
1627: --
1628: IF NOT fa_cache_pkg.fazccp(prorate_calendar
1629: , fy_name
1630: , dpr_in.prorate_jdate
1631: , prorate_period_pcal_begin
1632: , prorate_year_pcal_begin

Line 1661: IF NOT fa_cache_pkg.fazccp(dpr_in.calendar_type

1657: END IF;
1658:
1659: IF dpr_in.jdate_retired <> 0 AND
1660: dpr_in.ret_prorate_jdate <> 0 THEN
1661: IF NOT fa_cache_pkg.fazccp(dpr_in.calendar_type
1662: , fy_name
1663: , dpr_in.jdate_retired
1664: , ret_period_dcal
1665: , ret_year_pcal

Line 1676: IF NOT fa_cache_pkg.fazccp(prorate_calendar

1672: -- assign y_ret to fy_ret as it gets overwritten in next call
1673: -- to fazccp. Fix for 1418257
1674: fy_ret := ret_year_pcal;
1675:
1676: IF NOT fa_cache_pkg.fazccp(prorate_calendar
1677: , fy_name
1678: , dpr_in.jdate_retired
1679: , ret_period_pcal
1680: , ret_year_pcal

Line 1687: IF NOT fa_cache_pkg.fazccp(prorate_calendar

1683: fa_srvr_msg.add_message(calling_fn => 'fa_cde_pkg.faxcde', p_log_level_rec => p_log_level_rec);
1684: RETURN (FALSE);
1685: END IF;
1686:
1687: IF NOT fa_cache_pkg.fazccp(prorate_calendar
1688: , fy_name
1689: , dpr_in.ret_prorate_jdate
1690: , ret_prorate_period_pcal
1691: , ret_year_pcal

Line 1895: IF fa_cache_pkg.fazcfor_record.revised_Rate = 0 THEN

1891: WHEN OTHERS THEN
1892: l_nbv_at_switch := NULL;
1893: END;
1894: --- BUG# 7290365 : If clause added becuase the program is erroring out ora-01476 for Method JP-250DB 2
1895: IF fa_cache_pkg.fazcfor_record.revised_Rate = 0 THEN
1896: l_number_of_periods := perds_per_yr_dcal;
1897: ELSIF fa_cache_pkg.fazcfor_record.revised_Rate > 0 THEN
1898: l_number_of_periods := CEIL(perds_per_yr_dcal/fa_cache_pkg.fazcfor_record.revised_Rate); --- Calculate the Approximate Number of Periods, when Switch happens.
1899: END IF;

Line 1897: ELSIF fa_cache_pkg.fazcfor_record.revised_Rate > 0 THEN

1893: END;
1894: --- BUG# 7290365 : If clause added becuase the program is erroring out ora-01476 for Method JP-250DB 2
1895: IF fa_cache_pkg.fazcfor_record.revised_Rate = 0 THEN
1896: l_number_of_periods := perds_per_yr_dcal;
1897: ELSIF fa_cache_pkg.fazcfor_record.revised_Rate > 0 THEN
1898: l_number_of_periods := CEIL(perds_per_yr_dcal/fa_cache_pkg.fazcfor_record.revised_Rate); --- Calculate the Approximate Number of Periods, when Switch happens.
1899: END IF;
1900: -- End of BUG# 7290365.
1901: -- BUG# 7304706 : the query below will get the details about whether deprn is run for a particular asset.

Line 1898: l_number_of_periods := CEIL(perds_per_yr_dcal/fa_cache_pkg.fazcfor_record.revised_Rate); --- Calculate the Approximate Number of Periods, when Switch happens.

1894: --- BUG# 7290365 : If clause added becuase the program is erroring out ora-01476 for Method JP-250DB 2
1895: IF fa_cache_pkg.fazcfor_record.revised_Rate = 0 THEN
1896: l_number_of_periods := perds_per_yr_dcal;
1897: ELSIF fa_cache_pkg.fazcfor_record.revised_Rate > 0 THEN
1898: l_number_of_periods := CEIL(perds_per_yr_dcal/fa_cache_pkg.fazcfor_record.revised_Rate); --- Calculate the Approximate Number of Periods, when Switch happens.
1899: END IF;
1900: -- End of BUG# 7290365.
1901: -- BUG# 7304706 : the query below will get the details about whether deprn is run for a particular asset.
1902: -- If deprn is already run for the Asset, follow the standard procedure of calculating the Deprn.

Line 1946: IF NOT fa_cache_pkg.fazcff(dpr.calendar_type

1942: year_prod :=0 ;
1943: actual_annual_deprn_amt := 0;
1944: actual_annual_bonus_deprn_amt := 0;
1945:
1946: IF NOT fa_cache_pkg.fazcff(dpr.calendar_type
1947: , dpr.book
1948: , fyctr
1949: , perds_fracs_arr
1950: , p_log_level_rec => p_log_level_rec) THEN

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

2012: deprn_start_perd := 1;
2013: deprn_end_perd := perds_per_yr_dcal;
2014: END IF;
2015:
2016: -- bonus: put fa_cache_pkg.fazcbf here, and erase all calls later!
2017: --
2018: -- Get rate from FA_BONUS_RATES table
2019: --
2020: IF NVL(dpr.bonus_rule, 'NONE') <> 'NONE' THEN

Line 2025: IF NOT fa_cache_pkg.fazcbr(dpr.bonus_rule

2021: --
2022: -- Get rate from FA_BONUS_RATES table
2023: --
2024:
2025: IF NOT fa_cache_pkg.fazcbr(dpr.bonus_rule
2026: , (fyctr - prorate_year_pcal_begin + 1)
2027: , dpr_out.bonus_rate_used
2028: , dpr_out.deprn_factor_used
2029: , dpr_out.alternate_deprn_factor_used

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

2054: -- to this asset.
2055: --
2056: IF (dpr.super_group_id IS NOT NULL) THEN
2057:
2058: l_period_counter := fyctr * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + perd_ctr;
2059:
2060: IF NOT fa_cache_pkg.fazcsgr(x_super_group_id => dpr.super_group_id
2061: , x_book_type_code => dpr.book
2062: , x_period_counter => l_period_counter, p_log_level_rec => p_log_level_rec) THEN

Line 2060: IF NOT fa_cache_pkg.fazcsgr(x_super_group_id => dpr.super_group_id

2056: IF (dpr.super_group_id IS NOT NULL) THEN
2057:
2058: l_period_counter := fyctr * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + perd_ctr;
2059:
2060: IF NOT fa_cache_pkg.fazcsgr(x_super_group_id => dpr.super_group_id
2061: , x_book_type_code => dpr.book
2062: , x_period_counter => l_period_counter, p_log_level_rec => p_log_level_rec) THEN
2063: RETURN (FALSE);
2064: END IF;

Line 2066: dpr.adj_rate := NVL(fa_cache_pkg.fazcsgr_record.adjusted_rate, dpr.adj_rate);

2062: , x_period_counter => l_period_counter, p_log_level_rec => p_log_level_rec) THEN
2063: RETURN (FALSE);
2064: END IF;
2065:
2066: dpr.adj_rate := NVL(fa_cache_pkg.fazcsgr_record.adjusted_rate, dpr.adj_rate);
2067: adj_rec_cost := NVL(dpr.cost * fa_cache_pkg.fazcsgr_record.percent_salvage_value, adj_rec_cost);
2068: fa_round_pkg.fa_floor(adj_rec_cost, dpr.book,p_log_level_rec);
2069:
2070: IF (p_log_level_rec.statement_level) THEN

Line 2067: adj_rec_cost := NVL(dpr.cost * fa_cache_pkg.fazcsgr_record.percent_salvage_value, adj_rec_cost);

2063: RETURN (FALSE);
2064: END IF;
2065:
2066: dpr.adj_rate := NVL(fa_cache_pkg.fazcsgr_record.adjusted_rate, dpr.adj_rate);
2067: adj_rec_cost := NVL(dpr.cost * fa_cache_pkg.fazcsgr_record.percent_salvage_value, adj_rec_cost);
2068: fa_round_pkg.fa_floor(adj_rec_cost, dpr.book,p_log_level_rec);
2069:
2070: IF (p_log_level_rec.statement_level) THEN
2071: fa_debug_pkg.ADD('faxcde', 'Super Group new adj cost', adj_rec_cost, p_log_level_rec);

Line 2126: IF NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES' THEN

2122: -- bonus: including bonus_rate for formula
2123: -- therefore not clearing bonus_rate, compare with production method.
2124:
2125: -- Bug:5930979:Japan Tax Reform Project (End)
2126: IF NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES' THEN
2127: IF (p_log_level_rec.statement_level) THEN
2128: fa_debug_pkg.ADD('faxcde', '+++ JAPAN ', 'in guarantee rate', p_log_level_rec => p_log_level_rec);
2129: END IF;
2130:

Line 2145: fa_debug_pkg.ADD('faxcde', 'fa_cache_pkg.fazcfor_record.guarantee_rate', fa_cache_pkg.fazcfor_record.guarantee_rate, p_log_level_rec);

2141:
2142: IF (p_log_level_rec.statement_level) THEN
2143: fa_debug_pkg.ADD('faxcde', 'dpr.cost', dpr.cost, p_log_level_rec);
2144: fa_debug_pkg.ADD('faxcde', 'dpr.cost - NVL(cur_eofy_reserve,0)', dpr.cost - NVL(cur_eofy_reserve,0), p_log_level_rec);
2145: fa_debug_pkg.ADD('faxcde', 'fa_cache_pkg.fazcfor_record.guarantee_rate', fa_cache_pkg.fazcfor_record.guarantee_rate, p_log_level_rec);
2146: fa_debug_pkg.ADD('faxcde', 'cur_deprn_rsv', cur_deprn_rsv, p_log_level_rec);
2147: fa_debug_pkg.ADD('faxcde', 'fa_cache_pkg.fazcfor_record.original_Rate', fa_cache_pkg.fazcfor_record.original_Rate, p_log_level_rec);
2148: END IF;
2149:

Line 2147: fa_debug_pkg.ADD('faxcde', 'fa_cache_pkg.fazcfor_record.original_Rate', fa_cache_pkg.fazcfor_record.original_Rate, p_log_level_rec);

2143: fa_debug_pkg.ADD('faxcde', 'dpr.cost', dpr.cost, p_log_level_rec);
2144: fa_debug_pkg.ADD('faxcde', 'dpr.cost - NVL(cur_eofy_reserve,0)', dpr.cost - NVL(cur_eofy_reserve,0), p_log_level_rec);
2145: fa_debug_pkg.ADD('faxcde', 'fa_cache_pkg.fazcfor_record.guarantee_rate', fa_cache_pkg.fazcfor_record.guarantee_rate, p_log_level_rec);
2146: fa_debug_pkg.ADD('faxcde', 'cur_deprn_rsv', cur_deprn_rsv, p_log_level_rec);
2147: fa_debug_pkg.ADD('faxcde', 'fa_cache_pkg.fazcfor_record.original_Rate', fa_cache_pkg.fazcfor_record.original_Rate, p_log_level_rec);
2148: END IF;
2149:
2150: -- Bug:7193797 : Wrong Adjusted Cost is passed, when Switch happens in What-if Program.
2151: -- The following code change will also work for Bug 7129262

Line 2152: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX

2148: END IF;
2149:
2150: -- Bug:7193797 : Wrong Adjusted Cost is passed, when Switch happens in What-if Program.
2151: -- The following code change will also work for Bug 7129262
2152: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX
2153: l_adjusted_cost := cur_adj_cost ;
2154: ELSE
2155: l_adjusted_cost := dpr.cost - NVL(cur_eofy_reserve,0);
2156: END IF;

Line 2278: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX

2274: -- Added the Below code to take care of the Bug# 7277598
2275: -- Below code calculates the Prorata Depreciable amount , if the asset is added with JP-250DB XX and NBV_AT_SWITCH in the middle of FY
2276: IF l_request_short_name = 'FAWDPR' then
2277: -- Removed and l_nbv_at_switch is not null clause as from the Below IF condition , as this should work for all scenarios.
2278: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX
2279: IF ann_deprn_rate = fa_cache_pkg.fazcfor_record.revised_Rate then
2280: l_count := l_count + 1;
2281: END IF;
2282: END IF;

Line 2279: IF ann_deprn_rate = fa_cache_pkg.fazcfor_record.revised_Rate then

2275: -- Below code calculates the Prorata Depreciable amount , if the asset is added with JP-250DB XX and NBV_AT_SWITCH in the middle of FY
2276: IF l_request_short_name = 'FAWDPR' then
2277: -- Removed and l_nbv_at_switch is not null clause as from the Below IF condition , as this should work for all scenarios.
2278: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX
2279: IF ann_deprn_rate = fa_cache_pkg.fazcfor_record.revised_Rate then
2280: l_count := l_count + 1;
2281: END IF;
2282: END IF;
2283: END IF;

Line 2323: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX

2319: -- Below code calculates the Prorata Depreciable amount , if the asset is added with JP-250DB XX and NBV_AT_SWITCH in the Middle of the FY
2320:
2321: IF l_request_short_name = 'FAWDPR' then
2322: -- Removed and "l_nbv_at_switch is not null" clause and "first_fy_flag = TRUE AND" clause from the Below IF condition , as this should work for all scenarios.
2323: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX
2324: IF NOT(dpr_run_flag) AND deprn_start_perd <> 1 AND deprn_start_perd <> perds_per_yr_dcal THEN
2325: -- BUG# 7304706 : NOT(dpr_run_flag) clause is added
2326:
2327: /*Bug 7539379 starts */

Line 2375: END IF; -- (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES')

2371: /*Bug 7539379 ENDS */
2372:
2373: perds_fracs_arr(perd_ctr-1).frac := (perds_per_yr_dcal/(perds_per_yr_dcal - deprn_start_perd + 1))*(1/perds_per_yr_dcal);
2374: END IF; -- NOT(dpr_run_flag)
2375: END IF; -- (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES')
2376: END IF; -- l_request_short_name = 'FAWDPR'
2377:
2378: -- End of Addition BUG# 7277598
2379: -- Bug 9863472 currency formatting for temp annual deprn amount (it should be round down/truncated)

Line 2439: IF NOT fa_cache_pkg.fazccl(dpr.ceil_name,

2435: --
2436: -- Get Ceiling Information from FA_CEILING_TYPES
2437: -- and FA_CEILINGS
2438: --
2439: IF NOT fa_cache_pkg.fazccl(dpr.ceil_name,
2440: dpr.jdate_in_service,
2441: fyctr - prorate_year_pcal_begin + 1,
2442: deprn_ceiling_amt,
2443: p_log_level_rec) THEN

Line 2547: IF SUBSTR (fa_cache_pkg.fazcbc_record.DEPRN_ALLOCATION_CODE,1,1) = 'E' then

2543: actual_annual_bonus_deprn_amt := bonus_ann_fy_deprn/adj_first_yr_frac;
2544: END IF;
2545:
2546: ELSE -- bug 14810421
2547: IF SUBSTR (fa_cache_pkg.fazcbc_record.DEPRN_ALLOCATION_CODE,1,1) = 'E' then
2548: actual_annual_deprn_amt := (actual_annual_deprn_amt/first_year_den) * first_year_num;
2549: ELSE
2550: actual_annual_deprn_amt :=
2551: actual_annual_deprn_amt * (first_year_frac/adj_first_yr_frac);

Line 2555: IF SUBSTR (fa_cache_pkg.fazcbc_record.DEPRN_ALLOCATION_CODE,1,1) = 'E' then

2551: actual_annual_deprn_amt * (first_year_frac/adj_first_yr_frac);
2552: END IF;
2553: IF NVL(dpr.bonus_rule, 'NONE') <> 'NONE' THEN
2554: -- bug 14810421
2555: IF SUBSTR (fa_cache_pkg.fazcbc_record.DEPRN_ALLOCATION_CODE,1,1) = 'E' then
2556: actual_annual_bonus_deprn_amt := (bonus_ann_fy_deprn/first_year_den) * first_year_num;
2557: ELSE
2558: actual_annual_bonus_deprn_amt :=
2559: bonus_ann_fy_deprn * (first_year_frac/adj_first_yr_frac);

Line 2915: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX

2911: -- and NBV_AT_SWITCH in the Middle of the FY
2912: IF l_request_short_name = 'FAWDPR' then
2913: -- Removed and "l_nbv_at_switch is not null" clause and "first_fy_flag = TRUE AND" clause
2914: -- from the Below IF condition , as this should work for all scenarios.
2915: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX
2916: IF NOT(dpr_run_flag) AND deprn_start_perd <> 1 AND deprn_start_perd <> perds_per_yr_dcal THEN -- BUG# 7304706 : NOT(dpr_run_flag) clause is added
2917: deprn_frac_of_yr := (perds_per_yr_dcal/(perds_per_yr_dcal - deprn_start_perd + 1))*(1/perds_per_yr_dcal);
2918: END IF;
2919: END IF;

Line 3024: fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, p_log_level_rec => p_log_level_rec);

3020: IF (NVL(p_subtract_ytd_flag,'N') = 'Y') THEN
3021:
3022: IF (p_log_level_rec.statement_level) THEN
3023: fa_debug_pkg.ADD(l_calling_fn||' OPA', 'cache: use_eofy_reserve_flag',
3024: fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, p_log_level_rec => p_log_level_rec);
3025: fa_debug_pkg.ADD(l_calling_fn||' OPA', 'cache: allow_reduction_rate_flag',
3026: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, p_log_level_rec => p_log_level_rec);
3027: fa_debug_pkg.ADD(l_calling_fn||' OPA', 'cache: rate_source_rule',
3028: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);

Line 3026: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, p_log_level_rec => p_log_level_rec);

3022: IF (p_log_level_rec.statement_level) THEN
3023: fa_debug_pkg.ADD(l_calling_fn||' OPA', 'cache: use_eofy_reserve_flag',
3024: fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, p_log_level_rec => p_log_level_rec);
3025: fa_debug_pkg.ADD(l_calling_fn||' OPA', 'cache: allow_reduction_rate_flag',
3026: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, p_log_level_rec => p_log_level_rec);
3027: fa_debug_pkg.ADD(l_calling_fn||' OPA', 'cache: rate_source_rule',
3028: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);
3029: fa_debug_pkg.ADD(l_calling_fn||' OPA', 'cache: deprn_basis_rule',
3030: fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);

Line 3028: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);

3024: fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, p_log_level_rec => p_log_level_rec);
3025: fa_debug_pkg.ADD(l_calling_fn||' OPA', 'cache: allow_reduction_rate_flag',
3026: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, p_log_level_rec => p_log_level_rec);
3027: fa_debug_pkg.ADD(l_calling_fn||' OPA', 'cache: rate_source_rule',
3028: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);
3029: fa_debug_pkg.ADD(l_calling_fn||' OPA', 'cache: deprn_basis_rule',
3030: fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
3031: END IF;
3032:

Line 3030: fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);

3026: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, p_log_level_rec => p_log_level_rec);
3027: fa_debug_pkg.ADD(l_calling_fn||' OPA', 'cache: rate_source_rule',
3028: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);
3029: fa_debug_pkg.ADD(l_calling_fn||' OPA', 'cache: deprn_basis_rule',
3030: fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
3031: END IF;
3032:
3033: --
3034: -- Change for OPA

Line 3036: IF (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' AND

3032:
3033: --
3034: -- Change for OPA
3035: --
3036: IF (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' AND
3037: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag = 'N' AND
3038: fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' AND
3039: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'COST') THEN
3040: --

Line 3037: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag = 'N' AND

3033: --
3034: -- Change for OPA
3035: --
3036: IF (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' AND
3037: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag = 'N' AND
3038: fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' AND
3039: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'COST') THEN
3040: --
3041: -- Find ytd using (reserve - eofy reserve)

Line 3038: fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' AND

3034: -- Change for OPA
3035: --
3036: IF (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' AND
3037: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag = 'N' AND
3038: fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' AND
3039: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'COST') THEN
3040: --
3041: -- Find ytd using (reserve - eofy reserve)
3042: -- find remaining period in fy using (num per in fy - period num + 1)

Line 3039: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'COST') THEN

3035: --
3036: IF (fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag = 'Y' AND
3037: fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag = 'N' AND
3038: fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' AND
3039: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'COST') THEN
3040: --
3041: -- Find ytd using (reserve - eofy reserve)
3042: -- find remaining period in fy using (num per in fy - period num + 1)
3043: -- formula to find peridic exp is

Line 3122: IF (fa_cache_pkg.fa_deprn_override_enabled) AND (nvl(l_request_short_name,'X') <> 'FAWDPR') THEN

3118: /* As mentioned above we should not override deprn value for what-if-analysis
3119: So, added check for What-If analysis bug 7645269*/
3120:
3121: -- Bug 8211842: Added nvl
3122: IF (fa_cache_pkg.fa_deprn_override_enabled) AND (nvl(l_request_short_name,'X') <> 'FAWDPR') THEN
3123: whatif_override_enable := 'Y';
3124: ELSE
3125: whatif_override_enable := 'N';
3126: END IF;

Line 3242: NVL(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' AND

3238:
3239: IF (perd_ctr=perds_per_yr_dcal AND
3240: (deprn_override_flag = fa_std_types.FA_NO_OVERRIDE OR
3241: deprn_override_flag = fa_std_types.FA_OVERRIDE_BONUS) AND
3242: NVL(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' AND
3243: NVL(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') ='N') THEN
3244:
3245: IF (dpr.deprn_rounding_flag = fa_std_types.FA_DPR_ROUND_ADD OR
3246: dpr.deprn_rounding_flag IS NULL) THEN

Line 3243: NVL(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') ='N') THEN

3239: IF (perd_ctr=perds_per_yr_dcal AND
3240: (deprn_override_flag = fa_std_types.FA_NO_OVERRIDE OR
3241: deprn_override_flag = fa_std_types.FA_OVERRIDE_BONUS) AND
3242: NVL(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' AND
3243: NVL(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') ='N') THEN
3244:
3245: IF (dpr.deprn_rounding_flag = fa_std_types.FA_DPR_ROUND_ADD OR
3246: dpr.deprn_rounding_flag IS NULL) THEN
3247: --

Line 3361: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX

3357: -- Below code calculates the Prorata Depreciable amount , if the asset is added with JP-250DB XX and NBV_AT_SWITCH in the Mid of the FY
3358:
3359: IF l_request_short_name = 'FAWDPR' then
3360: -- Removed and "l_nbv_at_switch is not null" clause and "first_fy_flag = TRUE AND" clause from the Below IF condition , as this should work for all scenarios.
3361: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX
3362: IF NOT(dpr_run_flag) AND deprn_start_perd <> 1 AND deprn_start_perd <> perds_per_yr_dcal THEN -- BUG# 7304706 : NOT(dpr_run_flag) clause is added
3363: /*Bug 7539379 changed below calculation for last period deprn amount */
3364: --perd_deprn_exp := ann_fy_deprn - ytd_deprn_sum;
3365: perd_deprn_exp := temp_round_amt - temp_round_amt1;

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

3438: END IF;
3439:
3440: IF dpr.adj_capacity < 0 THEN
3441: /* Bug#14784782: Checking for life_complete assets */
3442: l_period_counter := fyctr * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + perd_ctr;
3443:
3444: BEGIN
3445: select 'Y'
3446: into prod_life_complete

Line 3491: IF (NVL(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='Y') THEN -- ENERGY

3487: (perd_prod / dpr.adj_capacity);
3488: end if;
3489:
3490: -- Main tain adj_capacity
3491: IF (NVL(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='Y') THEN -- ENERGY
3492: dpr.adj_capacity := dpr.adj_capacity - perd_prod; -- ENERGY
3493: END IF; -- ENERGY
3494:
3495: -- bonus: Not tracking for production.

Line 3901: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX

3897:
3898: -- Added the Below code to take care of the Bug# 7277598
3899: -- Below code calculates the Prorata Depreciable amount , if the asset is added with JP-250DB XX and NBV_AT_SWITCH in the Middle of FY
3900: IF l_request_short_name = 'FAWDPR' then
3901: IF (NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES') THEN --- Checking for Methods JP-250DB XX
3902: IF l_count = l_number_of_periods then
3903: dpr_out.full_rsv_flag := TRUE;
3904: dpr_out.life_comp_flag := TRUE;
3905: END IF;

Line 4179: (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id IS NOT NULL AND

4175:
4176: --Bug#8230037 - Addition condition on deprn_basis_rule_id to check for non zero value.
4177: -- - as cache is returning zero if deprn_basis_rule_id is null
4178: IF (nbv_deprn_basis_flag OR
4179: (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id IS NOT NULL AND
4180: fa_cache_pkg.fazccmt_record.deprn_basis_rule_id <> 0 AND
4181: NOT (rate_source_rule = 'CALCULATED' AND
4182: cost_deprn_basis_flag AND
4183: NVL(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' AND

Line 4180: fa_cache_pkg.fazccmt_record.deprn_basis_rule_id <> 0 AND

4176: --Bug#8230037 - Addition condition on deprn_basis_rule_id to check for non zero value.
4177: -- - as cache is returning zero if deprn_basis_rule_id is null
4178: IF (nbv_deprn_basis_flag OR
4179: (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id IS NOT NULL AND
4180: fa_cache_pkg.fazccmt_record.deprn_basis_rule_id <> 0 AND
4181: NOT (rate_source_rule = 'CALCULATED' AND
4182: cost_deprn_basis_flag AND
4183: NVL(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' AND
4184: NVL(p_subtract_ytd_flag,'N') = 'N' AND

Line 4183: NVL(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' AND

4179: (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id IS NOT NULL AND
4180: fa_cache_pkg.fazccmt_record.deprn_basis_rule_id <> 0 AND
4181: NOT (rate_source_rule = 'CALCULATED' AND
4182: cost_deprn_basis_flag AND
4183: NVL(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' AND
4184: NVL(p_subtract_ytd_flag,'N') = 'N' AND
4185: NVL(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'N'))) THEN
4186:
4187: -- Japan Tax Reform Project

Line 4185: NVL(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'N'))) THEN

4181: NOT (rate_source_rule = 'CALCULATED' AND
4182: cost_deprn_basis_flag AND
4183: NVL(fa_cache_pkg.fazcdrd_record.period_update_flag,'N') ='N' AND
4184: NVL(p_subtract_ytd_flag,'N') = 'N' AND
4185: NVL(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'N'))) THEN
4186:
4187: -- Japan Tax Reform Project
4188: IF NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES' THEN
4189:

Line 4188: IF NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES' THEN

4184: NVL(p_subtract_ytd_flag,'N') = 'N' AND
4185: NVL(fa_cache_pkg.fazcdrd_record.use_eofy_reserve_flag, 'N') = 'N'))) THEN
4186:
4187: -- Japan Tax Reform Project
4188: IF NVL(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag, 'NO') = 'YES' THEN
4189:
4190: IF (p_log_level_rec.statement_level) THEN
4191: fa_debug_pkg.ADD('faxcde', '+++ JAPAN ', 'in guarantee rate call deprn basis', p_log_level_rec => p_log_level_rec);
4192: END IF;

Line 4795: IF fa_cache_pkg.fa_annual_round = 'ALWAYS' THEN

4791: BEGIN <>
4792:
4793: IF (NOT g_tested_use_annual_round) THEN
4794: -- fnd_profile.get('FA_ANNUAL_ROUND', value);
4795: IF fa_cache_pkg.fa_annual_round = 'ALWAYS' THEN
4796: g_use_annual_round := ROUND_ALWAYS;
4797: ELSE
4798: g_use_annual_round := ROUND_WITH_RESTRICTIONS;
4799: END IF;

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

4891: return_code:=12;
4892:
4893: -- select the corresponding period_counter for the current period: fyctr, perd_ctr
4894: -- Get calendar Info: type, fy_name and num_per_fiscal_year
4895: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;
4896: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;
4897: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
4898:
4899: return_code:= 13;

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

4892:
4893: -- select the corresponding period_counter for the current period: fyctr, perd_ctr
4894: -- Get calendar Info: type, fy_name and num_per_fiscal_year
4895: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;
4896: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;
4897: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
4898:
4899: return_code:= 13;
4900:

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

4893: -- select the corresponding period_counter for the current period: fyctr, perd_ctr
4894: -- Get calendar Info: type, fy_name and num_per_fiscal_year
4895: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;
4896: h_fy_name:= fa_cache_pkg.fazcbc_record.fiscal_year_name;
4897: h_num_per_fy:= fa_cache_pkg.fazcct_record.number_per_fiscal_year;
4898:
4899: return_code:= 13;
4900:
4901: