APPS.XLA_ACCOUNTING_PUB_PKG dependencies on XLA_ACCT_PROG_EVENTS_GT

Line 573: INSERT INTO XLA_ACCT_PROG_EVENTS_GT(event_id, ledger_id)

569: ,p_value_2 => 'xla_accounting_pub_pkg.accounting_program_doc_batch');
570:
571: END IF;
572:
573: INSERT INTO XLA_ACCT_PROG_EVENTS_GT(event_id, ledger_id)
574: SELECT xe.event_id, xte.ledger_id
575: FROM xla_acct_prog_docs_gt xap
576: ,xla_events xe
577: ,xla_transaction_entities xte

Line 590: (p_msg => '# row inserted into xla_acct_prog_events_gt = '||SQL%ROWCOUNT

586: ,'Y');
587:
588: IF (C_LEVEL_EVENT >= g_log_level) THEN
589: trace
590: (p_msg => '# row inserted into xla_acct_prog_events_gt = '||SQL%ROWCOUNT
591: ,p_level => C_LEVEL_EVENT
592: ,p_module => l_log_module);
593: END IF;
594:

Line 675: FROM xla_acct_prog_events_gt xap

671: )
672: IS
673: CURSOR c_invalid_events IS
674: SELECT 1
675: FROM xla_acct_prog_events_gt xap
676: , xla_events xe
677: WHERE xe.application_id = p_application_id
678: AND xe.event_id = xap.event_id
679: AND NVL(xe.budgetary_control_flag,'N') = DECODE(p_accounting_mode

Line 751: UPDATE xla_acct_prog_events_gt xpa

747:
748:
749:
750:
751: UPDATE xla_acct_prog_events_gt xpa
752: SET (ledger_id) =
753: (SELECT ledger_id
754: FROM xla_events xe
755: , xla_transaction_entities xte

Line 762: FROM xla_acct_prog_events_gt

758: AND xe.application_id = p_application_id
759: AND xe.event_id = xpa.event_id);
760:
761: SELECT count(*) into l_count
762: FROM xla_acct_prog_events_gt
763: WHERE ledger_id IS NULL;
764:
765: OPEN c_invalid_events;
766: FETCH c_invalid_events INTO l_dummy;