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

Line 16: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

12: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
13:
14: l_reporting_flag varchar2(1);
15: l_set_of_books_id number;
16: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
17:
18: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
19:
20: l_calling_fn varchar2(30) := 'fa_interco_pvt.do_all_books';

Line 30: if (nvl(fa_cache_pkg.fazcbc_record.intercompany_posting_flag,'Y') = 'N')then

26: if (p_log_level_rec.statement_level) then
27: fa_debug_pkg.add(l_calling_fn, 'p_claling_fn', p_calling_fn, p_log_level_rec => p_log_level_rec);
28: end if;
29: --exit from the function if intercompany posting not allowed fapost enhancement strat
30: if (nvl(fa_cache_pkg.fazcbc_record.intercompany_posting_flag,'Y') = 'N')then
31: if (p_log_level_rec.statement_level) then
32: fa_debug_pkg.add(l_calling_fn, 'Intercompany posting not allowed exiting', p_calling_fn, p_log_level_rec => p_log_level_rec);
33: end if;
34: return TRUE;

Line 50: if not FA_CACHE_PKG.fazcrsob

46: end if;
47: g_group_reclass := FALSE;
48: end if;
49: -- call the sob cache to get the table of sob_ids
50: if not FA_CACHE_PKG.fazcrsob
51: (x_book_type_code => p_src_asset_hdr_rec.book_type_code,
52: x_sob_tbl => l_sob_tbl, p_log_level_rec => p_log_level_rec) then
53: raise interco_err;
54: end if;

Line 74: if NOT fa_cache_pkg.fazcbcs(X_book => p_src_asset_hdr_rec.book_type_code,

70: END IF;
71:
72: -- call the cache to set the sob_id used for rounding and other lower
73: -- level code for each book.
74: if NOT fa_cache_pkg.fazcbcs(X_book => p_src_asset_hdr_rec.book_type_code,
75: X_set_of_books_id => l_set_of_books_id,
76: p_log_level_rec => p_log_level_rec) then
77: raise interco_err;
78: end if;

Line 193: l_account_flex := fa_cache_pkg.fazcbc_record.ACCOUNTING_FLEX_STRUCTURE;

189:
190: BEGIN
191:
192:
193: l_account_flex := fa_cache_pkg.fazcbc_record.ACCOUNTING_FLEX_STRUCTURE;
194: --exit from the function if intercompany posting not allowed fapost enhancement strat
195: if (nvl(fa_cache_pkg.fazcbc_record.intercompany_posting_flag,'Y') <> 'Y')then
196: if (p_log_level_rec.statement_level) then
197: fa_debug_pkg.add(l_calling_fn, 'Intercompany posting not allowed exiting', p_calling_fn, p_log_level_rec => p_log_level_rec);

Line 195: if (nvl(fa_cache_pkg.fazcbc_record.intercompany_posting_flag,'Y') <> 'Y')then

191:
192:
193: l_account_flex := fa_cache_pkg.fazcbc_record.ACCOUNTING_FLEX_STRUCTURE;
194: --exit from the function if intercompany posting not allowed fapost enhancement strat
195: if (nvl(fa_cache_pkg.fazcbc_record.intercompany_posting_flag,'Y') <> 'Y')then
196: if (p_log_level_rec.statement_level) then
197: fa_debug_pkg.add(l_calling_fn, 'Intercompany posting not allowed exiting', p_calling_fn, p_log_level_rec => p_log_level_rec);
198: end if;
199: return TRUE;

Line 262: -- if not fa_cache_pkg.fazccb

258:
259:
260: -- not needed
261: -- call the ccb cache for src
262: -- if not fa_cache_pkg.fazccb
263: -- (X_book => p_src_asset_hdr_rec.book_type_code,
264: -- X_cat_id => p_src_asset_cat_rec.category_id
265: -- ) then raise interco_err;
266: -- end if;

Line 268: -- l_src_cat_book_rec := fa_cache_pkg.fazccb_record;

264: -- X_cat_id => p_src_asset_cat_rec.category_id
265: -- ) then raise interco_err;
266: -- end if;
267: --
268: -- l_src_cat_book_rec := fa_cache_pkg.fazccb_record;
269:
270:
271: -- get each balancing segment and the sum of the amounts
272: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

Line 318: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);

314: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
315:
316: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);
317: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_src_asset_hdr_rec.book_type_code);
318: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
319: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
320:
321: if (p_mrc_sob_type_code = 'R') then
322: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_set_of_books_id', p_src_asset_hdr_rec.set_of_books_id);

Line 375: -- if not fa_cache_pkg.fazccb

371: l_dest_trans_rec := p_dest_trans_rec;
372:
373: -- not needed
374: -- call the ccb cache for src
375: -- if not fa_cache_pkg.fazccb
376: -- (X_book => l_dest_asset_hdr_rec.book_type_code,
377: -- X_cat_id => l_dest_asset_cat_rec.category_id
378: -- ) then raise interco_err;
379: -- end if;

Line 381: -- l_dest_cat_book_rec := fa_cache_pkg.fazccb_record;

377: -- X_cat_id => l_dest_asset_cat_rec.category_id
378: -- ) then raise interco_err;
379: -- end if;
380: --
381: -- l_dest_cat_book_rec := fa_cache_pkg.fazccb_record;
382:
383:
384: -- get each balancing segment and the sum of the amounts
385: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

Line 430: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);

426: DBMS_SQL.PARSE(l_cursor_id, l_statement, DBMS_SQL.NATIVE);
427:
428: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_dest_asset_hdr_rec.asset_id);
429: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book', p_dest_asset_hdr_rec.book_type_code);
430: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
431: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_dest_trans_rec.transaction_header_Id);
432:
433:
434: if (p_mrc_sob_type_code = 'R') then

Line 863: l_interco_ar_acct := fa_cache_pkg.fazcbc_record.ar_intercompany_acct;

859: fa_debug_pkg.add(l_calling_fn, 'setting up for: ', 'faxinaj calls', p_log_level_rec => p_log_level_rec);
860: end if;
861:
862:
863: l_interco_ar_acct := fa_cache_pkg.fazcbc_record.ar_intercompany_acct;
864: l_interco_ap_acct := fa_cache_pkg.fazcbc_record.ap_intercompany_acct;
865:
866:
867: -- set the source type code...

Line 864: l_interco_ap_acct := fa_cache_pkg.fazcbc_record.ap_intercompany_acct;

860: end if;
861:
862:
863: l_interco_ar_acct := fa_cache_pkg.fazcbc_record.ar_intercompany_acct;
864: l_interco_ap_acct := fa_cache_pkg.fazcbc_record.ap_intercompany_acct;
865:
866:
867: -- set the source type code...
868: -- currently only transaction that should call this engine

Line 906: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

902: fa_debug_pkg.add(l_calling_fn, 'src source_type_code', l_src_source_type_code, p_log_level_rec => p_log_level_rec);
903: fa_debug_pkg.add(l_calling_fn, 'dest source_type_code', l_dest_source_type_code, p_log_level_rec => p_log_level_rec);
904: end if;
905:
906: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
907: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
908: l_adj.last_update_date := p_src_trans_rec.transaction_date_entered;
909: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE;
910: l_adj.selection_thid := 0;

Line 907: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

903: fa_debug_pkg.add(l_calling_fn, 'dest source_type_code', l_dest_source_type_code, p_log_level_rec => p_log_level_rec);
904: end if;
905:
906: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
907: l_adj.period_counter_adjusted := fa_cache_pkg.fazcbc_record.last_period_counter + 1;
908: l_adj.last_update_date := p_src_trans_rec.transaction_date_entered;
909: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE;
910: l_adj.selection_thid := 0;
911: l_adj.selection_retid := 0;

Line 982: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);

978: -- need to use local for dest variable for intra-asset trxs
979: if (l_summary_tbl(l_summary_count).type = 'SRC') then
980: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', p_src_asset_hdr_rec.asset_id);
981: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', p_src_asset_hdr_rec.book_type_code);
982: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
983: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
984: else
985: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_dest_asset_hdr_rec.asset_id);
986: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', l_dest_asset_hdr_rec.book_type_code);

Line 987: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);

983: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', p_src_trans_rec.transaction_header_id);
984: else
985: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_asset_id', l_dest_asset_hdr_rec.asset_id);
986: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_book_type_code', l_dest_asset_hdr_rec.book_type_code);
987: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_period_counter_created', fa_cache_pkg.fazcbc_record.last_period_counter + 1);
988: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_thid', l_dest_trans_rec.transaction_header_id);
989: end if;
990:
991: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_balancing_segment', l_summary_tbl(l_summary_count).balancing_segment);

Line 1204: l_account_flex := fa_cache_pkg.fazcbc_record.ACCOUNTING_FLEX_STRUCTURE;

1200: if (p_log_level_rec.statement_level) then
1201: fa_debug_pkg.add(l_calling_fn, 'inside', 'validate interco code', p_log_level_rec => p_log_level_rec);
1202: end if;
1203:
1204: l_account_flex := fa_cache_pkg.fazcbc_record.ACCOUNTING_FLEX_STRUCTURE;
1205:
1206: /*
1207: l_status := fnd_flex_apis.get_qualifier_segnum(appl_id => 101,
1208: key_flex_code => 'GL#',

Line 1559: l_account_flex := fa_cache_pkg.fazcbc_record.ACCOUNTING_FLEX_STRUCTURE;

1555: if (p_log_level_rec.statement_level) then
1556: fa_debug_pkg.add(l_calling_fn, 'inside', 'validate interco code', p_log_level_rec => p_log_level_rec);
1557: end if;
1558:
1559: l_account_flex := fa_cache_pkg.fazcbc_record.ACCOUNTING_FLEX_STRUCTURE;
1560:
1561: /*
1562: l_status := fnd_flex_apis.get_qualifier_segnum(appl_id => 101,
1563: key_flex_code => 'GL#',