APPS.XLA_REVERSE_EVENTS_PVT_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 128: INSERT INTO xla_transaction_entities

124: ,p_level => C_LEVEL_PROCEDURE
125: ,p_module =>l_log_module);
126:
127: END IF;
128: INSERT INTO xla_transaction_entities
129: (entity_id
130: ,application_id
131: ,source_application_id
132: ,ledger_id

Line 157: (XLA_TRANSACTION_ENTITIES_S.NEXTVAL

153: ,source_id_char_2
154: ,source_id_char_3
155: ,source_id_char_4)
156: VALUES
157: (XLA_TRANSACTION_ENTITIES_S.NEXTVAL
158: ,g_application_id
159: ,g_application_id
160: ,g_ledger_id
161: ,NULL

Line 405: SELECT /*+ leading(evt) use_nl(evt,xah,xte) INDEX(xah,xla_ae_headers_n2)INDEX(xte,XLA_TRANSACTION_ENTITIES_U1) */

401: PROCEDURE validate_events ( x_return_status OUT NOCOPY VARCHAR2)
402: IS
403:
404: CURSOR c_errors IS
405: SELECT /*+ leading(evt) use_nl(evt,xah,xte) INDEX(xah,xla_ae_headers_n2)INDEX(xte,XLA_TRANSACTION_ENTITIES_U1) */
406: DISTINCT xte.ledger_id trx_ledger_id ,
407: xte.entity_code trx_entity_code ,
408: xah.gl_transfer_status_code ,
409: evt.*

Line 412: XLA_TRANSACTION_ENTITIES_UPG xte

408: xah.gl_transfer_status_code ,
409: evt.*
410: FROM xla_events_gt evt ,
411: xla_ae_headers xah ,
412: XLA_TRANSACTION_ENTITIES_UPG xte
413: WHERE xah.application_id(+) = evt.application_id
414: AND xah.event_id(+) = evt.event_number
415: AND xte.APPLICATION_ID(+) = xah.application_id
416: AND xte.entity_id(+) = xah.entity_id

Line 1302: UPDATE xla_transaction_entities_upg xtem

1298: -- Need the Caching for the usage of the set up in the XLA_JE_VALIDATION
1299: xla_accounting_cache_pkg.load_application_ledgers(g_application_id , g_ledger_id , l_max_event_date );
1300: g_initialized := 'Y' ;
1301:
1302: UPDATE xla_transaction_entities_upg xtem
1303: SET xtem.valuation_method = ( select xte.valuation_method
1304: from xla_transaction_entities_upg xte ,
1305: xla_events xe
1306: where xe.application_id = g_application_id

Line 1304: from xla_transaction_entities_upg xte ,

1300: g_initialized := 'Y' ;
1301:
1302: UPDATE xla_transaction_entities_upg xtem
1303: SET xtem.valuation_method = ( select xte.valuation_method
1304: from xla_transaction_entities_upg xte ,
1305: xla_events xe
1306: where xe.application_id = g_application_id
1307: and xe.event_id = l_max_event_id
1308: and xte.application_id = g_application_id

Line 1710: SELECT /*+use_nl(xeg,xe,xte) INDEX(xe,XLA_EVENTS_U1) INDEX(xte,XLA_TRANSACTION_ENTITIES_U1)*/

1706: -- 1. the application_id, entity_code, event_id is not null
1707: -- 2. the event_status_code cannot be 'P'
1708: -- 4. application_id is populated and all equals p_application_id
1709: CURSOR csr_manual_processed_events(app_id NUMBER) is
1710: SELECT /*+use_nl(xeg,xe,xte) INDEX(xe,XLA_EVENTS_U1) INDEX(xte,XLA_TRANSACTION_ENTITIES_U1)*/
1711: xe.event_status_code ,
1712: xe.event_id ,
1713: xte.entity_code
1714: FROM xla_events_gt xeg, xla_events xe, xla_transaction_entities_upg xte

Line 1714: FROM xla_events_gt xeg, xla_events xe, xla_transaction_entities_upg xte

1710: SELECT /*+use_nl(xeg,xe,xte) INDEX(xe,XLA_EVENTS_U1) INDEX(xte,XLA_TRANSACTION_ENTITIES_U1)*/
1711: xe.event_status_code ,
1712: xe.event_id ,
1713: xte.entity_code
1714: FROM xla_events_gt xeg, xla_events xe, xla_transaction_entities_upg xte
1715: WHERE xeg.application_id = xe.application_id (+)
1716: AND xeg.event_id = xe.event_id (+)
1717: AND xe.entity_id = xte.entity_id (+)
1718: AND xte.application_id(+) = app_id