APPS.FA_XLA_EXTRACT_UTIL_PKG dependencies on XLA_EVENTS

Line 37: from xla_events_gt;

33: cursor c_events is
34: select distinct valuation_method,
35: ENTITY_CODE,
36: EVENT_TYPE_CODE
37: from xla_events_gt;
38:
39: l_procedure_name varchar2(80) := 'check_events';
40:
41: begin

Line 341: insert into xla_events_int_gt

337: if (l_trx <> 0) then
338: -- BUG# 4439932
339: -- the following is for setting status on non-accountable events
340:
341: insert into xla_events_int_gt
342: (event_id,
343: event_status_code,
344: application_id,
345: ledger_id,

Line 356: xla_events ev,

352: bc.set_of_books_id,
353: 'TRANSACTIONS',
354: bc.book_type_code
355: from xla_transaction_entities te,
356: xla_events ev,
357: fa_transaction_headers th,
358: fa_book_controls bc
359: where te.application_id = l_appl_id
360: and te.ledger_id = bc.set_of_books_id

Line 420: -- An index exists in Xla_events table on request_id field.

416: END IF;
417: /*--------------------------------------------------------*/
418: -- Bug 7642903. A new condition based on create accounting
419: -- request id, is added in the query torun it fast.
420: -- An index exists in Xla_events table on request_id field.
421: /*--------------------------------------------------------*/
422: insert into xla_events_int_gt
423: (event_id,
424: event_status_code,

Line 422: insert into xla_events_int_gt

418: -- Bug 7642903. A new condition based on create accounting
419: -- request id, is added in the query torun it fast.
420: -- An index exists in Xla_events table on request_id field.
421: /*--------------------------------------------------------*/
422: insert into xla_events_int_gt
423: (event_id,
424: event_status_code,
425: application_id,
426: ledger_id,

Line 436: from xla_events ev,

432: 140,
433: bc.set_of_books_id,
434: 'INTER_ASSET_TRANSACTIONS',
435: bc.book_type_code
436: from xla_events ev,
437: xla_transaction_entities te,
438: fa_trx_references trx,
439: fa_book_controls bc
440: where te.application_id = l_appl_id

Line 488: 'calling: ' || 'xla_events_pub_pkg.update_bulk_event_statuses');

484: l_inter_trx_count <> 0) then
485: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
486: fnd_log.string(G_LEVEL_STATEMENT,
487: G_MODULE_NAME||l_procedure_name,
488: 'calling: ' || 'xla_events_pub_pkg.update_bulk_event_statuses');
489: END IF;
490:
491:
492: xla_events_pub_pkg.update_bulk_event_statuses(p_application_id => 140);

Line 492: xla_events_pub_pkg.update_bulk_event_statuses(p_application_id => 140);

488: 'calling: ' || 'xla_events_pub_pkg.update_bulk_event_statuses');
489: END IF;
490:
491:
492: xla_events_pub_pkg.update_bulk_event_statuses(p_application_id => 140);
493: end if;
494:
495: end if;
496: