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.LNS_DISTRIBUTIONS_PUB dependencies on XLA_ACCT_PROG_DOCS_GT

Line 3690: insert into XLA_ACCT_PROG_DOCS_GT (entity_id) VALUES (l_entity_id);

3686: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_entity_code = ' || l_entity_code);
3687: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_source_id_int_1 = ' || l_source_id_int_1);
3688: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_transaction_number = ' || l_transaction_number);
3689:
3690: insert into XLA_ACCT_PROG_DOCS_GT (entity_id) VALUES (l_entity_id);
3691: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Inserted into XLA_ACCT_PROG_DOCS_GT');
3692:
3693: end loop;
3694: close c_entities ;

Line 3691: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Inserted into XLA_ACCT_PROG_DOCS_GT');

3687: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_source_id_int_1 = ' || l_source_id_int_1);
3688: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_transaction_number = ' || l_transaction_number);
3689:
3690: insert into XLA_ACCT_PROG_DOCS_GT (entity_id) VALUES (l_entity_id);
3691: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Inserted into XLA_ACCT_PROG_DOCS_GT');
3692:
3693: end loop;
3694: close c_entities ;
3695:

Line 3697: from XLA_ACCT_PROG_DOCS_GT;

3693: end loop;
3694: close c_entities ;
3695:
3696: select count(1) into l_transactions_count
3697: from XLA_ACCT_PROG_DOCS_GT;
3698: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Inserted transaction_entities = ' || l_transactions_count);
3699:
3700: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Calling XLA_ACCOUNTING_PUB_PKG.accounting_program_doc_batch...');
3701: XLA_ACCOUNTING_PUB_PKG.accounting_program_doc_batch(p_application_id => 222

Line 4194: insert into XLA_ACCT_PROG_DOCS_GT

4190: if l_loan_class = 'ERS' then
4191:
4192: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ERS loan accounting');
4193: -- at this point in time, the INVOICES and ADJUSTMENTS MUST have already been accounted for
4194: insert into XLA_ACCT_PROG_DOCS_GT
4195: (entity_id)
4196: select entity_id from xla_transaction_entities
4197: where application_id = 206
4198: and entity_code = 'LOANS'

Line 4207: insert into XLA_ACCT_PROG_DOCS_GT

4203:
4204: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DIRECT loan accounting');
4205:
4206: -- can we make join thru lns_distributions
4207: insert into XLA_ACCT_PROG_DOCS_GT
4208: (entity_id)
4209: select entity_id from xla_transaction_entities
4210: where application_id = 206
4211: and entity_code = 'LOANS'

Line 4237: from XLA_ACCT_PROG_DOCS_GT;

4233: -- and xlee.entity_code = 'LOANS'));
4234: end if;
4235:
4236: select count(1) into l_transactions_count
4237: from XLA_ACCT_PROG_DOCS_GT;
4238: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserted transaction_entities ' || l_transactions_count);
4239: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'calling XLA_ACCOUNTING_PUB_PKG.accounting_program_doc_batch ');
4240: XLA_ACCOUNTING_PUB_PKG.accounting_program_doc_batch(p_application_id => 206
4241: ,p_accounting_mode => p_accounting_mode