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

Line 5: g_release number := fa_cache_pkg.fazarel_release; /Bug# 8394781- /

1: PACKAGE BODY FA_PROCESS_IMPAIRMENT_PKG AS
2: /* $Header: FAPIMPB.pls 120.13.12020000.3 2012/09/12 11:21:31 gigupta ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5: g_release number := fa_cache_pkg.fazarel_release; /*Bug# 8394781- */
6:
7: --*********************** Private functions ******************************--
8: FUNCTION assign_workers (p_request_id IN NUMBER,
9: p_book_type_code IN VARCHAR2,

Line 117: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

113:
114: l_msg_count NUMBER := 0;
115: l_msg_data VARCHAR2(2000) := NULL;
116:
117: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
118: l_total_requests BINARY_INTEGER;
119: t_request_id tab_num15_type;
120: l_request_id number(15);
121: l_internal_mode VARCHAR2(30);

Line 273: if not FA_CACHE_PKG.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then

269: if (g_log_level_rec.statement_level) then
270: fa_debug_pkg.add(l_calling_fn,'Total Requests', l_total_requests, p_log_level_rec => g_log_level_rec);
271: end if;
272:
273: if not FA_CACHE_PKG.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then
274: raise imp_err;
275: end if;
276:
277: l_primary_sob := fa_cache_pkg.fazcbc_record.set_of_books_id;

Line 277: l_primary_sob := fa_cache_pkg.fazcbc_record.set_of_books_id;

273: if not FA_CACHE_PKG.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then
274: raise imp_err;
275: end if;
276:
277: l_primary_sob := fa_cache_pkg.fazcbc_record.set_of_books_id;
278: fa_debug_pkg.add(l_calling_fn,'Total l_primary_sob', l_primary_sob, p_log_level_rec => g_log_level_rec);
279:
280: -- call the sob cache to get the table of sob_ids
281: if not FA_CACHE_PKG.fazcrsob(

Line 281: if not FA_CACHE_PKG.fazcrsob(

277: l_primary_sob := fa_cache_pkg.fazcbc_record.set_of_books_id;
278: fa_debug_pkg.add(l_calling_fn,'Total l_primary_sob', l_primary_sob, p_log_level_rec => g_log_level_rec);
279:
280: -- call the sob cache to get the table of sob_ids
281: if not FA_CACHE_PKG.fazcrsob(
282: x_book_type_code => p_book_type_code,
283: x_sob_tbl => l_sob_tbl, p_log_level_rec => g_log_level_rec) then
284: raise imp_err;
285: end if;

Line 308: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type

304: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM)
305: from fa_fiscal_year fy
306: , fa_calendar_types ct
307: , fa_calendar_periods cp
308: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
309: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
310: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
311: and ct.calendar_type = cp.calendar_type
312: and cp.start_date between fy.start_date and fy.end_date

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

305: from fa_fiscal_year fy
306: , fa_calendar_types ct
307: , fa_calendar_periods cp
308: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
309: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
310: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
311: and ct.calendar_type = cp.calendar_type
312: and cp.start_date between fy.start_date and fy.end_date
313: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=

Line 310: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

306: , fa_calendar_types ct
307: , fa_calendar_periods cp
308: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
309: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
310: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
311: and ct.calendar_type = cp.calendar_type
312: and cp.start_date between fy.start_date and fy.end_date
313: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=
314: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM

Line 313: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=

309: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
310: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
311: and ct.calendar_type = cp.calendar_type
312: and cp.start_date between fy.start_date and fy.end_date
313: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=
314: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
315: and imp.impairment_date between cp.start_date and cp.end_date)
316: WHERE imp.STATUS = p_mode
317: -- Bug#7264536 - To handle situation when impairment is posted simultaneously for different books

Line 330: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type

326: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM)
327: from fa_fiscal_year fy
328: , fa_calendar_types ct
329: , fa_calendar_periods cp
330: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
331: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
332: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
333: and ct.calendar_type = cp.calendar_type
334: and cp.start_date between fy.start_date and fy.end_date

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

327: from fa_fiscal_year fy
328: , fa_calendar_types ct
329: , fa_calendar_periods cp
330: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
331: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
332: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
333: and ct.calendar_type = cp.calendar_type
334: and cp.start_date between fy.start_date and fy.end_date
335: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=

Line 332: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

328: , fa_calendar_types ct
329: , fa_calendar_periods cp
330: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
331: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
332: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
333: and ct.calendar_type = cp.calendar_type
334: and cp.start_date between fy.start_date and fy.end_date
335: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=
336: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM

Line 335: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=

331: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
332: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
333: and ct.calendar_type = cp.calendar_type
334: and cp.start_date between fy.start_date and fy.end_date
335: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=
336: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
337: and imp.impairment_date between cp.start_date and cp.end_date)
338: WHERE imp.impairment_id = p_impairment_id
339: RETURNING imp.IMPAIRMENT_DATE BULK COLLECT INTO t_imp_date;

Line 586: if NOT fa_cache_pkg.fazcbcs(X_book => p_book_type_code,

582: end if;
583:
584: -- call the cache to set the sob_id used for rounding and other lower
585: -- level code for each book.
586: if NOT fa_cache_pkg.fazcbcs(X_book => p_book_type_code,
587: X_set_of_books_id => l_set_of_books_id,
588: p_log_level_rec => g_log_level_rec) then
589: raise imp_err;
590: end if;

Line 750: if not FA_CACHE_PKG.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then

746:
747:
748: elsif (p_parent_request_id is not null) then
749:
750: if not FA_CACHE_PKG.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then
751: raise imp_err;
752: end if;
753:
754: -- call the cache to set the sob_id used for rounding and other lower

Line 756: if not FA_CACHE_PKG.fazcbcs(X_book => p_book_type_code,

752: end if;
753:
754: -- call the cache to set the sob_id used for rounding and other lower
755: -- level code for each book.
756: if not FA_CACHE_PKG.fazcbcs(X_book => p_book_type_code,
757: X_set_of_books_id => l_set_of_books_id,
758: p_log_level_rec => g_log_level_rec) then
759: raise imp_err;
760: end if;

Line 937: if nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y' then

933: if (g_log_level_rec.statement_level) then
934: fa_debug_pkg.add(l_calling_fn,'iso lang', l_iso_lang, p_log_level_rec => g_log_level_rec);
935: fa_debug_pkg.add(l_calling_fn,'iso Territory', l_iso_territory, p_log_level_rec => g_log_level_rec);
936: end if;
937: if nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y' then
938:
939: l_return_code := FND_REQUEST.add_layout (
940: template_appl_name => 'OFA'
941: , template_code => 'FAXRASIM'

Line 1197: (p_prim_set_of_books_id => fa_cache_pkg.fazcbc_record.set_of_books_id,

1193:
1194:
1195: -- Need to get exchange rate
1196: if not FA_MC_UTIL_PVT.get_trx_rate
1197: (p_prim_set_of_books_id => fa_cache_pkg.fazcbc_record.set_of_books_id,
1198: p_reporting_set_of_books_id => p_set_of_books_id,
1199: px_exchange_date => l_exchange_date,
1200: p_book_type_code => p_book_type_code,
1201: px_rate => l_rate, p_log_level_rec => g_log_level_rec)then