APPS.FA_XLA_EXTRACT_UTIL_PKG dependencies on FA_BOOK_CONTROLS

Line 31: l_last_book_used FA_BOOK_CONTROLS.Book_Type_Code%TYPE := ' ';

27: t_book_type_code tab_varchar;
28: t_event_type_code tab_varchar;
29: t_entity_code tab_varchar;
30:
31: l_last_book_used FA_BOOK_CONTROLS.Book_Type_Code%TYPE := ' ';
32: l_special_secondary_count number := 0;
33:
34: cursor c_events is
35: select distinct valuation_method,

Line 41: l_corp_book_rec FA_BOOK_CONTROLS%RowType;

37: EVENT_TYPE_CODE
38: from xla_events_gt;
39:
40: l_procedure_name varchar2(80) := 'check_events';
41: l_corp_book_rec FA_BOOK_CONTROLS%RowType;
42:
43: begin
44:
45: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 257: update fa_book_controls

253:
254: END IF;
255:
256: if (p_book_type_code is null) then
257: update fa_book_controls
258: set create_accounting_request_id = fnd_global.conc_request_id
259: where set_of_books_id = p_ledger_id
260: and book_class <> 'BUDGET';
261: else

Line 262: update fa_book_controls

258: set create_accounting_request_id = fnd_global.conc_request_id
259: where set_of_books_id = p_ledger_id
260: and book_class <> 'BUDGET';
261: else
262: update fa_book_controls
263: set create_accounting_request_id = fnd_global.conc_request_id
264: where book_type_code = p_book_type_code;
265: end if;
266:

Line 319: update fa_book_controls

315:
316: END IF;
317:
318: if (p_book_type_code is null) then
319: update fa_book_controls
320: set create_accounting_request_id = null
321: where set_of_books_id = p_ledger_id
322: and book_class <> 'BUDGET';
323: else

Line 324: update fa_book_controls

320: set create_accounting_request_id = null
321: where set_of_books_id = p_ledger_id
322: and book_class <> 'BUDGET';
323: else
324: update fa_book_controls
325: set create_accounting_request_id = null
326: where book_type_code = p_book_type_code;
327: end if;
328:

Line 444: fa_book_controls bc

440: bc.book_type_code
441: from xla_transaction_entities te,
442: xla_events ev,
443: fa_transaction_headers th,
444: fa_book_controls bc
445: where te.application_id = l_appl_id
446: and te.ledger_id = p_ledger_id
447: and te.entity_code = 'TRANSACTIONS'
448: and te.valuation_method = nvl(p_book_type_code, te.valuation_method)

Line 493: fa_book_controls bc

489: bc.book_type_code
490: from xla_transaction_entities te,
491: xla_events ev,
492: fa_transaction_headers th,
493: fa_book_controls bc
494: where te.application_id = l_appl_id
495: and te.ledger_id = p_ledger_id
496: and te.entity_code = 'TRANSACTIONS'
497: and te.valuation_method = nvl(p_book_type_code, te.valuation_method)

Line 540: fa_book_controls bc

536: bc.book_type_code
537: from xla_events ev,
538: xla_transaction_entities te,
539: fa_trx_references trx,
540: fa_book_controls bc
541: where te.application_id = l_appl_id
542: and te.ledger_id = p_ledger_id
543: and te.entity_code = 'INTER_ASSET_TRANSACTIONS'
544: and te.valuation_method = nvl(p_book_type_code, te.valuation_method)