APPS.FA_XLA_EXTRACT_UTIL_PKG dependencies on XLA_EVENTS

Line 38: from xla_events_gt;

34: cursor c_events is
35: select distinct valuation_method,
36: ENTITY_CODE,
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:

Line 427: insert into xla_events_int_gt

423: -- Bug 13601181 : Added check for group assets
424:
425: if (G_group_enabled) then
426:
427: insert into xla_events_int_gt
428: (event_id,
429: event_status_code,
430: application_id,
431: ledger_id,

Line 442: xla_events ev,

438: bc.set_of_books_id,
439: 'TRANSACTIONS',
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

Line 476: insert into xla_events_int_gt

472: and nvl(adj.track_member_flag, 'N') <> 'Y');
473:
474: else
475:
476: insert into xla_events_int_gt
477: (event_id,
478: event_status_code,
479: application_id,
480: ledger_id,

Line 491: xla_events ev,

487: bc.set_of_books_id,
488: 'TRANSACTIONS',
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

Line 523: insert into xla_events_int_gt

519: G_MODULE_NAME||l_procedure_name,
520: 'Rows inserted into gt for non-accountable - trx: ' || to_char(l_trx_count));
521: END IF;
522:
523: insert into xla_events_int_gt
524: (event_id,
525: event_status_code,
526: application_id,
527: ledger_id,

Line 537: from xla_events ev,

533: 140,
534: bc.set_of_books_id,
535: 'INTER_ASSET_TRANSACTIONS',
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

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

580: l_inter_trx_count <> 0) then
581: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
582: fnd_log.string(G_LEVEL_STATEMENT,
583: G_MODULE_NAME||l_procedure_name,
584: 'calling: ' || 'xla_events_pub_pkg.update_bulk_event_statuses');
585: END IF;
586:
587: xla_events_pub_pkg.update_bulk_event_statuses(p_application_id => 140);
588: end if;

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

583: G_MODULE_NAME||l_procedure_name,
584: 'calling: ' || 'xla_events_pub_pkg.update_bulk_event_statuses');
585: END IF;
586:
587: xla_events_pub_pkg.update_bulk_event_statuses(p_application_id => 140);
588: end if;
589:
590: end if;
591: