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

Line 73: where cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

69: select cp.period_num
70: , fy.fiscal_year
71: from fa_fiscal_year fy
72: , fa_calendar_periods cp
73: where cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
74: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
75: and cp.start_date between fy.start_date and fy.end_date
76: and c_start_date between cp.start_date and cp.end_date;
77:

Line 74: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

70: , fy.fiscal_year
71: from fa_fiscal_year fy
72: , fa_calendar_periods cp
73: where cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
74: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
75: and cp.start_date between fy.start_date and fy.end_date
76: and c_start_date between cp.start_date and cp.end_date;
77:
78: CURSOR c_get_open_period_rec IS

Line 130: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

126: fa_debug_pkg.ADD (l_calling_fn,'l_impairment_amount',l_impairment_amount, p_log_level_rec => p_log_level_rec);
127: end if;
128: x_impair_split_flag := l_split_impair_flag;
129: /*+++++++ Populating l_dpr_in to call faxcde ++++++++++*/
130: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
131: l_dpr_in.book := p_book_type_code;
132: l_dpr_in.asset_id := p_asset_id;
133:
134: l_dpr_row.asset_id := p_asset_id;

Line 220: fa_debug_pkg.add(l_calling_fn, 'Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);

216: l_dpr_in.set_of_books_id := p_set_of_books_id;
217: l_running_mode := fa_std_types.FA_DPR_NORMAL;
218:
219: if (p_log_level_rec.statement_level) then
220: fa_debug_pkg.add(l_calling_fn, 'Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
221: end if;
222:
223: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
224: fa_cache_pkg.fazcbc_record.fiscal_year_name,

Line 223: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,

219: if (p_log_level_rec.statement_level) then
220: fa_debug_pkg.add(l_calling_fn, 'Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
221: end if;
222:
223: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
224: fa_cache_pkg.fazcbc_record.fiscal_year_name,
225: l_dpr_in.prorate_jdate,
226: g_temp_number,
227: l_dpr_in.y_begin,

Line 224: fa_cache_pkg.fazcbc_record.fiscal_year_name,

220: fa_debug_pkg.add(l_calling_fn, 'Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
221: end if;
222:
223: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
224: fa_cache_pkg.fazcbc_record.fiscal_year_name,
225: l_dpr_in.prorate_jdate,
226: g_temp_number,
227: l_dpr_in.y_begin,
228: g_temp_integer, p_log_level_rec => p_log_level_rec) then

Line 231: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);

227: l_dpr_in.y_begin,
228: g_temp_integer, p_log_level_rec => p_log_level_rec) then
229: if (p_log_level_rec.statement_level) then
230: fa_debug_pkg.add(l_calling_fn, 'Error calling',
231: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
233: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
234: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
235: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);

Line 232: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',

228: g_temp_integer, p_log_level_rec => p_log_level_rec) then
229: if (p_log_level_rec.statement_level) then
230: fa_debug_pkg.add(l_calling_fn, 'Error calling',
231: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
233: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
234: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
235: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
236:

Line 233: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);

229: if (p_log_level_rec.statement_level) then
230: fa_debug_pkg.add(l_calling_fn, 'Error calling',
231: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
233: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
234: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
235: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
236:
237: end if;

Line 234: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

230: fa_debug_pkg.add(l_calling_fn, 'Error calling',
231: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
233: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
234: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
235: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
236:
237: end if;
238:

Line 235: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);

231: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
233: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
234: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
235: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
236:
237: end if;
238:
239: --raise dpr_err;

Line 644: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;

640: AND imp.asset_id = itf.asset_id
641: AND imp.impairment_id =
642: fa_sorp_process_imp_id_fn (p_impairment_id);
643: BEGIN
644: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
645:
646: IF p_reval_imp_flag = 'C'
647: THEN
648: OPEN c_deprn_common_cur;

Line 847: v_impair_loss_acct := fa_cache_pkg.fazccb_record.impair_expense_acct;

843: v_rsv_reverse_amt, v_rsv_reverse_deprn_effect;
844:
845: IF v_impair_loss_acct = 'N'
846: THEN
847: v_impair_loss_acct := fa_cache_pkg.fazccb_record.impair_expense_acct;
848: END IF;
849:
850: fa_debug_pkg.ADD ('SORP_ACCOUNTING',
851: 'v_impair_loss_acct',

Line 924: px_adj.ACCOUNT := fa_cache_pkg.fazccb_record.deprn_expense_acct;

920:
921: px_adj.adjustment_amount := ROUND ((v_calc_imp_rev_deprn_effect), 2);
922: px_adj.adjustment_type := 'IMPAIR OFF EXP';
923: px_adj.account_type := 'DEPRN_EXPENSE_ACCT';
924: px_adj.ACCOUNT := fa_cache_pkg.fazccb_record.deprn_expense_acct;
925: px_adj.debit_credit_flag := 'DR';
926:
927: IF NOT fa_ins_adjust_pkg.faxinaj (px_adj,
928: p_creation_date,

Line 955: px_adj.ACCOUNT := fa_cache_pkg.fazccb_record.deprn_expense_acct;

951: THEN
952: px_adj.adjustment_amount := ROUND ((v_rsv_reverse_deprn_effect), 2);
953: px_adj.adjustment_type := 'IMPAIR OFF EXP';
954: px_adj.account_type := 'DEPRN_EXPENSE_ACCT';
955: px_adj.ACCOUNT := fa_cache_pkg.fazccb_record.deprn_expense_acct;
956: px_adj.debit_credit_flag := 'DR';
957:
958: IF NOT fa_ins_adjust_pkg.faxinaj (px_adj,
959: p_creation_date,

Line 983: px_adj.ACCOUNT := fa_cache_pkg.fazccb_record.reval_reserve_acct;

979:
980: px_adj.adjustment_amount := ROUND ((v_rsv_reverse_deprn_effect), 2);
981: px_adj.adjustment_type := 'REVAL RESERVE';
982: px_adj.account_type := 'REVAL_RESERVE_ACCT';
983: px_adj.ACCOUNT := fa_cache_pkg.fazccb_record.reval_reserve_acct;
984: px_adj.debit_credit_flag := 'CR';
985:
986: IF NOT fa_ins_adjust_pkg.faxinaj (px_adj,
987: p_creation_date,

Line 2381: if not FA_CACHE_PKG.fazcbc(X_book => p_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then

2377: dpr_err exception;
2378:
2379: BEGIN
2380:
2381: if not FA_CACHE_PKG.fazcbc(X_book => p_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then
2382: raise dpr_err;
2383: end if;
2384:
2385: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then

Line 2385: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then

2381: if not FA_CACHE_PKG.fazcbc(X_book => p_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then
2382: raise dpr_err;
2383: end if;
2384:
2385: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then
2386: raise dpr_err;
2387: end if;
2388:
2389:

Line 2414: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

2410: open c_mc_get_pr_asset_rec;
2411: fetch c_mc_get_pr_asset_rec into c_fin_rec;
2412: close c_mc_get_pr_asset_rec;
2413: end if;
2414: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
2415: l_dpr_in.book := c_fin_rec.book_type_code;
2416: l_dpr_in.asset_id := c_fin_rec.asset_id;
2417: l_dpr_in.rec_cost := c_fin_rec.recoverable_cost;
2418: l_dpr_in.salvage_value := c_fin_rec.salvage_value;

Line 2470: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

2466: l_dpr_in.y_end := p_period_rec.fiscal_year;
2467: l_dpr_in.p_cl_end := p_period_rec.period_num ;
2468:
2469: if l_dpr_in.p_cl_end = 1 then
2470: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
2471: l_dpr_in.y_end := l_dpr_in.y_end - 1;
2472: else
2473: l_dpr_in.p_cl_end := l_dpr_in.p_cl_end - 1;
2474: end if;

Line 2516: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

2512: open c_mc_get_asset_rec;
2513: fetch c_mc_get_asset_rec into c_fin_rec;
2514: close c_mc_get_asset_rec;
2515: end if;
2516: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
2517: l_dpr_in.book := c_fin_rec.book_type_code;
2518: l_dpr_in.asset_id := c_fin_rec.asset_id;
2519: l_dpr_in.rec_cost := c_fin_rec.recoverable_cost;
2520: l_dpr_in.salvage_value := c_fin_rec.salvage_value;

Line 2570: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

2566: l_dpr_in.y_end := p_period_rec.fiscal_year;
2567: l_dpr_in.p_cl_end := p_period_rec.period_num ;
2568:
2569: if l_dpr_in.p_cl_end = 1 then
2570: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
2571: l_dpr_in.y_end := l_dpr_in.y_end - 1;
2572: else
2573: l_dpr_in.p_cl_end := l_dpr_in.p_cl_end - 1;
2574: end if;