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 4562: insert into XLA_ACCT_PROG_DOCS_GT (entity_id) VALUES (l_entity_id);

4558: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_entity_code = ' || l_entity_code);
4559: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_source_id_int_1 = ' || l_source_id_int_1);
4560: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_transaction_number = ' || l_transaction_number);
4561:
4562: insert into XLA_ACCT_PROG_DOCS_GT (entity_id) VALUES (l_entity_id);
4563: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Inserted into XLA_ACCT_PROG_DOCS_GT');
4564:
4565: end loop;
4566: close c_entities ;

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

4559: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_source_id_int_1 = ' || l_source_id_int_1);
4560: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_transaction_number = ' || l_transaction_number);
4561:
4562: insert into XLA_ACCT_PROG_DOCS_GT (entity_id) VALUES (l_entity_id);
4563: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Inserted into XLA_ACCT_PROG_DOCS_GT');
4564:
4565: end loop;
4566: close c_entities ;
4567:

Line 4569: from XLA_ACCT_PROG_DOCS_GT;

4565: end loop;
4566: close c_entities ;
4567:
4568: select count(1) into l_transactions_count
4569: from XLA_ACCT_PROG_DOCS_GT;
4570: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Inserted transaction_entities = ' || l_transactions_count);
4571:
4572: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Calling XLA_ACCOUNTING_PUB_PKG.accounting_program_doc_batch...');
4573: XLA_ACCOUNTING_PUB_PKG.accounting_program_doc_batch(p_application_id => 222

Line 5181: insert into XLA_ACCT_PROG_DOCS_GT

5177: if l_loan_class = 'ERS' then
5178:
5179: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ERS loan accounting');
5180: -- at this point in time, the INVOICES and ADJUSTMENTS MUST have already been accounted for
5181: insert into XLA_ACCT_PROG_DOCS_GT
5182: (entity_id)
5183: select entity_id from xla_transaction_entities
5184: where application_id = 206
5185: and entity_code = 'LOANS'

Line 5195: insert into XLA_ACCT_PROG_DOCS_GT

5191:
5192: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DIRECT loan accounting');
5193:
5194: -- can we make join thru lns_distributions
5195: insert into XLA_ACCT_PROG_DOCS_GT
5196: (entity_id)
5197: select entity_id from xla_transaction_entities
5198: where application_id = 206
5199: and entity_code = 'LOANS'

Line 5224: from XLA_ACCT_PROG_DOCS_GT;

5220: );
5221: end if;
5222:
5223: select count(1) into l_transactions_count
5224: from XLA_ACCT_PROG_DOCS_GT;
5225: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserted transaction_entities ' || l_transactions_count);
5226: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'calling XLA_ACCOUNTING_PUB_PKG.accounting_program_doc_batch ');
5227: XLA_ACCOUNTING_PUB_PKG.accounting_program_doc_batch(p_application_id => 206
5228: ,p_accounting_mode => p_accounting_mode

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

6810: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_entity_code = ' || l_entity_code);
6811: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_source_id_int_1 = ' || l_source_id_int_1);
6812: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_transaction_number = ' || l_transaction_number);
6813:
6814: insert into XLA_ACCT_PROG_DOCS_GT (entity_id) VALUES (l_entity_id);
6815: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Inserted into XLA_ACCT_PROG_DOCS_GT');
6816:
6817: end loop;
6818: close c_entities ;

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

6811: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_source_id_int_1 = ' || l_source_id_int_1);
6812: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_transaction_number = ' || l_transaction_number);
6813:
6814: insert into XLA_ACCT_PROG_DOCS_GT (entity_id) VALUES (l_entity_id);
6815: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Inserted into XLA_ACCT_PROG_DOCS_GT');
6816:
6817: end loop;
6818: close c_entities ;
6819:

Line 6821: from XLA_ACCT_PROG_DOCS_GT;

6817: end loop;
6818: close c_entities ;
6819:
6820: select count(1) into l_transactions_count
6821: from XLA_ACCT_PROG_DOCS_GT;
6822: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Inserted transaction_entities = ' || l_transactions_count);
6823:
6824: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Calling XLA_ACCOUNTING_PUB_PKG.accounting_program_doc_batch...');
6825: XLA_ACCOUNTING_PUB_PKG.accounting_program_doc_batch(p_application_id => 222