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

Line 154: where fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

150: , cp.period_num period_num
151: , fy.fiscal_year fiscal_year
152: from fa_fiscal_year fy
153: , fa_calendar_periods cp
154: where fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
155: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
156: and cp.start_date between fy.start_date and fy.end_date
157: and l_st_period_counter <= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
158: and l_ed_period_counter >= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM

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

151: , fy.fiscal_year fiscal_year
152: from fa_fiscal_year fy
153: , fa_calendar_periods cp
154: where fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
155: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
156: and cp.start_date between fy.start_date and fy.end_date
157: and l_st_period_counter <= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
158: and l_ed_period_counter >= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
159: order by fiscal_year, period_num;

Line 157: and l_st_period_counter <= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM

153: , fa_calendar_periods cp
154: where fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
155: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
156: and cp.start_date between fy.start_date and fy.end_date
157: and l_st_period_counter <= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
158: and l_ed_period_counter >= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
159: order by fiscal_year, period_num;
160:
161: cache_err exception;

Line 158: and l_ed_period_counter >= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM

154: where fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
155: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
156: and cp.start_date between fy.start_date and fy.end_date
157: and l_st_period_counter <= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
158: and l_ed_period_counter >= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
159: order by fiscal_year, period_num;
160:
161: cache_err exception;
162: h_deprn_run varchar2(1);

Line 492: if not fa_cache_pkg.fazcdp(x_book_type_code => X_book,

488:
489: --
490: -- Bug3330163: Replacing with cache call.
491: --
492: if not fa_cache_pkg.fazcdp(x_book_type_code => X_book,
493: x_period_counter => null,
494: x_effective_date => null) then
495: raise cache_err;
496: end if;

Line 498: dpr_row.period_ctr := fa_cache_pkg.fazcdp_record.period_counter;

494: x_effective_date => null) then
495: raise cache_err;
496: end if;
497:
498: dpr_row.period_ctr := fa_cache_pkg.fazcdp_record.period_counter;
499: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
500: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
501: h_deprn_run := fa_cache_pkg.fazcdp_record.deprn_run;
502:

Line 499: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;

495: raise cache_err;
496: end if;
497:
498: dpr_row.period_ctr := fa_cache_pkg.fazcdp_record.period_counter;
499: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
500: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
501: h_deprn_run := fa_cache_pkg.fazcdp_record.deprn_run;
502:
503: --fa_rx_conc_mesg_pkg.log('step 2111');

Line 500: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;

496: end if;
497:
498: dpr_row.period_ctr := fa_cache_pkg.fazcdp_record.period_counter;
499: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
500: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
501: h_deprn_run := fa_cache_pkg.fazcdp_record.deprn_run;
502:
503: --fa_rx_conc_mesg_pkg.log('step 2111');
504:

Line 501: h_deprn_run := fa_cache_pkg.fazcdp_record.deprn_run;

497:
498: dpr_row.period_ctr := fa_cache_pkg.fazcdp_record.period_counter;
499: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
500: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
501: h_deprn_run := fa_cache_pkg.fazcdp_record.deprn_run;
502:
503: --fa_rx_conc_mesg_pkg.log('step 2111');
504:
505: if X_mode in ('EXPENSED','AMORTIZED') then

Line 705: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then

701: dpr_row.mrc_sob_type_code := FARX_C_WD.mrc_sob_type; -- Enhancement Bug 3037321
702:
703: --fa_rx_conc_mesg_pkg.log('step 4');
704:
705: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then
706: return (FALSE);
707: end if;
708:
709: if not fa_cache_pkg.fazcbc(X_BOOK => X_BOOK) then

Line 709: if not fa_cache_pkg.fazcbc(X_BOOK => X_BOOK) then

705: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then
706: return (FALSE);
707: end if;
708:
709: if not fa_cache_pkg.fazcbc(X_BOOK => X_BOOK) then
710: return (FALSE);
711: end if;
712:
713: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then

Line 713: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then

709: if not fa_cache_pkg.fazcbc(X_BOOK => X_BOOK) then
710: return (FALSE);
711: end if;
712:
713: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
714: return (FALSE);
715: end if;
716:
717: -- CALL QUERY BALANCES.

Line 797: if (not fa_cache_pkg.fazccmt(fin_info.method_code,

793:
794: --
795: -- Replace sql with cache call.
796: --
797: if (not fa_cache_pkg.fazccmt(fin_info.method_code,
798: fin_info.life)) then
799: raise cache_err;
800: end if;
801:

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

798: fin_info.life)) then
799: raise cache_err;
800: end if;
801:
802: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
803:
804: fin_info.adj_cost := fin_info.rec_cost;
805:
806: -- ADJ_REC_COST DEPENDENT ON WHETHER WE'RE USING DEPRN_LIMITS

Line 1000: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then

996: dpr_row.dist_id := 0;
997: --dpr_row.mrc_sob_type_code := 'P';
998: dpr_row.mrc_sob_type_code := FARX_C_WD.mrc_sob_type; -- Enhancement Bug 3037321
999:
1000: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then
1001: return (FALSE);
1002: end if;
1003:
1004: if not fa_cache_pkg.fazcbc(X_BOOK => X_BOOK) then

Line 1004: if not fa_cache_pkg.fazcbc(X_BOOK => X_BOOK) then

1000: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then
1001: return (FALSE);
1002: end if;
1003:
1004: if not fa_cache_pkg.fazcbc(X_BOOK => X_BOOK) then
1005: return (FALSE);
1006: end if;
1007: -- dpr_in.y_begin = 2002
1008: -- dpr_in.p_cl_begin = 2

Line 1059: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then

1055:
1056: --
1057: -- Modified to use cache
1058: --
1059: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
1060: raise cache_err;
1061: end if;
1062:
1063: h_calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

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

1059: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
1060: raise cache_err;
1061: end if;
1062:
1063: h_calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
1064: h_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1065: h_num_per_fy := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
1066:
1067: dpr_in.calendar_type := h_calendar_type;

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

1060: raise cache_err;
1061: end if;
1062:
1063: h_calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
1064: h_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1065: h_num_per_fy := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
1066:
1067: dpr_in.calendar_type := h_calendar_type;
1068:

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

1061: end if;
1062:
1063: h_calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
1064: h_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1065: h_num_per_fy := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
1066:
1067: dpr_in.calendar_type := h_calendar_type;
1068:
1069:

Line 1107: if (to_number(to_char(fa_cache_pkg.fazcdp_record.calendar_period_open_date, 'J')) >

1103: --if (not((dpr_in.y_begin = h_start_per_fy) and
1104: -- (dpr_in.p_cl_begin = h_start_per_num))) then
1105: -- dpr_in.deprn_rounding_flag := fa_std_types.FA_DPR_ROUND_RES;
1106: --end if;
1107: if (to_number(to_char(fa_cache_pkg.fazcdp_record.calendar_period_open_date, 'J')) >
1108: dpr_in.jdate_in_service) and
1109: (l_adjustment_required_status = 'ADD') then
1110: dpr_in.deprn_rounding_flag := fa_std_types.FA_DPR_ROUND_ADJ;
1111: end if;

Line 1245: -- fa_rx_conc_mesg_pkg.log('num per fy: ' || fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR);

1241:
1242:
1243: -- fa_rx_conc_mesg_pkg.log('orig.fiscal_year: ' || dpr_arr(0).fiscal_year);
1244: -- fa_rx_conc_mesg_pkg.log('new.fiscal_year: ' || h_start_per_fy);
1245: -- fa_rx_conc_mesg_pkg.log('num per fy: ' || fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR);
1246: -- fa_rx_conc_mesg_pkg.log('h_start_per_num: ' || h_start_per_num );
1247:
1248: l_st_period_counter := h_start_per_fy *
1249: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +

Line 1249: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +

1245: -- fa_rx_conc_mesg_pkg.log('num per fy: ' || fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR);
1246: -- fa_rx_conc_mesg_pkg.log('h_start_per_num: ' || h_start_per_num );
1247:
1248: l_st_period_counter := h_start_per_fy *
1249: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +
1250: h_start_per_num;
1251:
1252: fa_rx_conc_mesg_pkg.log('l_st_period_counter: ' || l_st_period_counter);
1253:

Line 1477: l_limit BINARY_INTEGER := nvl(fa_cache_pkg.fa_batch_size, 500);

1473: and dh.date_ineffective is null;
1474:
1475: i BINARY_INTEGER;
1476: old_i BINARY_INTEGER;
1477: l_limit BINARY_INTEGER := nvl(fa_cache_pkg.fa_batch_size, 500);
1478:
1479: begin
1480:
1481: ret := TRUE;

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

1560: --Open dist_book;
1561: --fetch dist_book into h_dist_book;
1562: --close dist_book;
1563:
1564: h_dist_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
1565:
1566: --tk_util.debug('t_ind1: '||to_char(t_ind));
1567: old_i := t_ind;
1568: i := t_ind;