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 160: where fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

156: , cp.period_num period_num
157: , fy.fiscal_year fiscal_year
158: from fa_fiscal_year fy
159: , fa_calendar_periods cp
160: where fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
161: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
162: and cp.start_date between fy.start_date and fy.end_date
163: and l_st_period_counter <= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
164: and l_ed_period_counter >= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM

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

157: , fy.fiscal_year fiscal_year
158: from fa_fiscal_year fy
159: , fa_calendar_periods cp
160: where fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
161: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
162: and cp.start_date between fy.start_date and fy.end_date
163: and l_st_period_counter <= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
164: and l_ed_period_counter >= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
165: order by fiscal_year, period_num;

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

159: , fa_calendar_periods cp
160: where fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
161: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
162: and cp.start_date between fy.start_date and fy.end_date
163: and l_st_period_counter <= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
164: and l_ed_period_counter >= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
165: order by fiscal_year, period_num;
166:
167: cache_err exception;

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

160: where fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
161: and cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
162: and cp.start_date between fy.start_date and fy.end_date
163: and l_st_period_counter <= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
164: and l_ed_period_counter >= fy.fiscal_year * fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
165: order by fiscal_year, period_num;
166:
167: cache_err exception;
168: h_deprn_run varchar2(1);

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

517:
518: --
519: -- Bug3330163: Replacing with cache call.
520: --
521: if not fa_cache_pkg.fazcdp(x_book_type_code => X_book,
522: x_period_counter => null,
523: x_effective_date => null) then
524: raise cache_err;
525: end if;

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

523: x_effective_date => null) then
524: raise cache_err;
525: end if;
526:
527: dpr_row.period_ctr := fa_cache_pkg.fazcdp_record.period_counter;
528: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
529: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
530: h_deprn_run := fa_cache_pkg.fazcdp_record.deprn_run;
531:

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

524: raise cache_err;
525: end if;
526:
527: dpr_row.period_ctr := fa_cache_pkg.fazcdp_record.period_counter;
528: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
529: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
530: h_deprn_run := fa_cache_pkg.fazcdp_record.deprn_run;
531:
532: --fa_rx_conc_mesg_pkg.log('step 2111');

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

525: end if;
526:
527: dpr_row.period_ctr := fa_cache_pkg.fazcdp_record.period_counter;
528: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
529: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
530: h_deprn_run := fa_cache_pkg.fazcdp_record.deprn_run;
531:
532: --fa_rx_conc_mesg_pkg.log('step 2111');
533:

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

526:
527: dpr_row.period_ctr := fa_cache_pkg.fazcdp_record.period_counter;
528: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
529: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
530: h_deprn_run := fa_cache_pkg.fazcdp_record.deprn_run;
531:
532: --fa_rx_conc_mesg_pkg.log('step 2111');
533:
534: if X_mode in ('EXPENSED','AMORTIZED') then

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

731: dpr_row.set_of_books_id := FARX_C_WD.sob_id;
732:
733: --fa_rx_conc_mesg_pkg.log('step 4');
734:
735: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then
736: return (FALSE);
737: end if;
738:
739: if not fa_cache_pkg.fazcbc(X_BOOK => X_BOOK) then

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

735: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then
736: return (FALSE);
737: end if;
738:
739: if not fa_cache_pkg.fazcbc(X_BOOK => X_BOOK) then
740: return (FALSE);
741: end if;
742:
743: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then

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

739: if not fa_cache_pkg.fazcbc(X_BOOK => X_BOOK) then
740: return (FALSE);
741: end if;
742:
743: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
744: return (FALSE);
745: end if;
746:
747: -- CALL QUERY BALANCES.

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

824:
825: --
826: -- Replace sql with cache call.
827: --
828: if (not fa_cache_pkg.fazccmt(fin_info.method_code,
829: fin_info.life)) then
830: raise cache_err;
831: end if;
832:

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

829: fin_info.life)) then
830: raise cache_err;
831: end if;
832:
833: h_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
834:
835: fin_info.adj_cost := fin_info.rec_cost;
836:
837: -- ADJ_REC_COST DEPENDENT ON WHETHER WE'RE USING DEPRN_LIMITS

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

1030: --dpr_row.mrc_sob_type_code := 'P';
1031: dpr_row.mrc_sob_type_code := FARX_C_WD.mrc_sob_type; -- Enhancement Bug 3037321
1032: dpr_row.set_of_books_id := FARX_C_WD.sob_id;
1033:
1034: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then
1035: return (FALSE);
1036: end if;
1037:
1038: if not fa_cache_pkg.fazcbc(X_BOOK => X_BOOK) then

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

1034: if not fa_cache_pkg.fazcbc_clr(X_BOOK => X_BOOK) then
1035: return (FALSE);
1036: end if;
1037:
1038: if not fa_cache_pkg.fazcbc(X_BOOK => X_BOOK) then
1039: return (FALSE);
1040: end if;
1041: -- dpr_in.y_begin = 2002
1042: -- dpr_in.p_cl_begin = 2

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

1132:
1133: --
1134: -- Modified to use cache
1135: --
1136: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
1137: raise cache_err;
1138: end if;
1139:
1140: h_calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

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

1136: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar) then
1137: raise cache_err;
1138: end if;
1139:
1140: h_calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
1141: h_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1142: h_num_per_fy := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
1143:
1144: dpr_in.calendar_type := h_calendar_type;

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

1137: raise cache_err;
1138: end if;
1139:
1140: h_calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
1141: h_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1142: h_num_per_fy := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
1143:
1144: dpr_in.calendar_type := h_calendar_type;
1145:

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

1138: end if;
1139:
1140: h_calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
1141: h_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1142: h_num_per_fy := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
1143:
1144: dpr_in.calendar_type := h_calendar_type;
1145:
1146:

Line 1155: if (not fa_cache_pkg.fazccmt(dpr_in.method_code,

1151:
1152: h_mesg_name := 'FA_AMT_SEL_CALENDARS_1';
1153:
1154: --- Added as part of the Bug# 7234390. to cache the Deprn Details.
1155: if (not fa_cache_pkg.fazccmt(dpr_in.method_code,
1156: dpr_in.life)) then
1157: raise cache_err;
1158: end if;
1159: --- End of the addition BUG# 7234390

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

1212: AND fk.date_ineffective IS NULL
1213: AND fk.extended_depreciation_period = cal.period_num + (cal.fiscal_year * h_num_per_fy);
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
1217: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
1218: END;
1219:
1220: end if;

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

1213: AND fk.extended_depreciation_period = cal.period_num + (cal.fiscal_year * h_num_per_fy);
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
1217: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
1218: END;
1219:
1220: end if;
1221:

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

1241: --if (not((dpr_in.y_begin = h_start_per_fy) and
1242: -- (dpr_in.p_cl_begin = h_start_per_num))) then
1243: -- dpr_in.deprn_rounding_flag := fa_std_types.FA_DPR_ROUND_RES;
1244: --end if;
1245: if (to_number(to_char(fa_cache_pkg.fazcdp_record.calendar_period_open_date, 'J')) >
1246: dpr_in.jdate_in_service) and
1247: (l_adjustment_required_status = 'ADD') then
1248: dpr_in.deprn_rounding_flag := fa_std_types.FA_DPR_ROUND_ADJ;
1249: end if;

Line 1341: and period_counter = fa_cache_pkg.fazcdp_record.period_counter --Bug#16045341

1337: into h_deprn_run
1338: from fa_deprn_summary
1339: where asset_id = dpr_in.asset_id
1340: and book_type_code = dpr_in.book
1341: and period_counter = fa_cache_pkg.fazcdp_record.period_counter --Bug#16045341
1342: and deprn_source_code = 'DEPRN';
1343: exception
1344: WHEN NO_DATA_FOUND THEN
1345: h_deprn_run := 'N';

Line 1364: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV' then

1360: end if;
1361:
1362: -- bug 10205614 need to reset the adj cost if this is the last period of fiscl year
1363: if dpr_in.p_cl_begin = h_num_per_fy and
1364: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV' then
1365: dpr_in.adj_cost := dpr_in.adj_cost + dpr_in.ytd_deprn;
1366: end if;
1367: dpr_in.deprn_rsv := dpr_in.deprn_rsv - nvl(adj_amt,0);
1368: dpr_in.ytd_deprn := dpr_in.ytd_deprn - nvl(adj_amt,0);

Line 1382: and period_counter = fa_cache_pkg.fazcdp_record.period_counter - 1;

1378: INTO h_count
1379: from fa_deprn_summary
1380: where book_type_code = dpr_in.book
1381: and asset_id = dpr_in.asset_id
1382: and period_counter = fa_cache_pkg.fazcdp_record.period_counter - 1;
1383: exception
1384: when others then
1385: h_count := 0;
1386: end;

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

1385: h_count := 0;
1386: end;
1387:
1388: if h_count > 0 then
1389: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
1390: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
1391: end if;
1392: h_fmode := fa_std_types.FA_DPR_NORMAL;
1393: dpr_in.deprn_rounding_flag := 'ADJ' ; -- Added as part of the bug 7290365.

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

1386: end;
1387:
1388: if h_count > 0 then
1389: dpr_in.p_cl_begin := fa_cache_pkg.fazcdp_record.period_num;
1390: dpr_in.y_begin := fa_cache_pkg.fazcdp_record.fiscal_year;
1391: end if;
1392: h_fmode := fa_std_types.FA_DPR_NORMAL;
1393: dpr_in.deprn_rounding_flag := 'ADJ' ; -- Added as part of the bug 7290365.
1394: END IF;

Line 1399: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES' then --- for Method JP-250db XX

1395:
1396: -- BUG # 7193797 : the deprn amount is calculated wrongly with fmode parameter
1397: -- as fa_std_types.FA_DPR_PROJECT.
1398: -- Hence fmode parameter is passed as fa_std_types.FA_DPR_NORMAL for JP-250DB XX.
1399: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES' then --- for Method JP-250db XX
1400: h_fmode := fa_std_types.FA_DPR_NORMAL;
1401: dpr_in.deprn_rounding_flag := 'ADJ'; -- Added as part of the bug 7290365. The Year end rounding was wrongly calculated.
1402: end if;
1403: --- BUG # 7193797: End of Addition

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

1454:
1455:
1456: -- fa_rx_conc_mesg_pkg.log('orig.fiscal_year: ' || dpr_arr(0).fiscal_year);
1457: -- fa_rx_conc_mesg_pkg.log('new.fiscal_year: ' || h_start_per_fy);
1458: -- fa_rx_conc_mesg_pkg.log('num per fy: ' || fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR);
1459: -- fa_rx_conc_mesg_pkg.log('h_start_per_num: ' || h_start_per_num );
1460:
1461: l_st_period_counter := h_start_per_fy *
1462: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +

Line 1462: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +

1458: -- fa_rx_conc_mesg_pkg.log('num per fy: ' || fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR);
1459: -- fa_rx_conc_mesg_pkg.log('h_start_per_num: ' || h_start_per_num );
1460:
1461: l_st_period_counter := h_start_per_fy *
1462: fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR +
1463: h_start_per_num;
1464:
1465: --fa_rx_conc_mesg_pkg.log('l_st_period_counter: ' || l_st_period_counter);
1466:

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

1724: and dh.date_ineffective is null;
1725:
1726: i BINARY_INTEGER;
1727: old_i BINARY_INTEGER;
1728: l_limit BINARY_INTEGER := nvl(fa_cache_pkg.fa_batch_size, 500);
1729:
1730: begin
1731:
1732: l_last_dist := FALSE; --Bug 12695030

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

1817: --Open dist_book;
1818: --fetch dist_book into h_dist_book;
1819: --close dist_book;
1820:
1821: h_dist_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
1822:
1823: --tk_util.debug('t_ind1: '||to_char(t_ind));
1824: old_i := t_ind;
1825: i := t_ind;