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.XLA_REVERSE_EVENTS_PVT_PKG dependencies on XLA_EVENTS_GT

Line 239: ( SELECT reference_num_2 FROM xla_events_gt

235:
236: -- Delete from xla_accounting_errors
237: DELETE FROM xla_accounting_errors
238: WHERE event_id IN
239: ( SELECT reference_num_2 FROM xla_events_gt
240: WHERE reference_char_1 = 'E'
241: AND reference_num_2 IS NOT NULL );
242:
243: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 254: FROM xla_events_gt xe,

250: -- Delete from xla_distribution_links
251: DELETE FROM xla_distribution_links
252: WHERE ae_header_id IN
253: (SELECT /*+ leading(XE) use_nl(XH) unnest index(xh,XLA_AE_HEADERS_N2) */ xh.ae_header_id
254: FROM xla_events_gt xe,
255: xla_ae_headers xh
256: WHERE xe.reference_char_1 = 'E'
257: AND xh.application_id = xe.application_id
258: AND xh.event_id = xe.reference_num_2

Line 277: FROM xla_events_gt xe,

273: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */
274: FROM xla_ae_segment_values
275: WHERE ae_header_id IN
276: (SELECT /*+ leading(XE) use_nl(XH) unnest index(xh,XLA_AE_HEADERS_N2) */ xh.ae_header_id
277: FROM xla_events_gt xe,
278: xla_ae_headers xh
279: WHERE xe.reference_char_1 = 'E'
280: AND xh.application_id = xe.application_id
281: AND xh.event_id = xe.reference_num_2

Line 299: FROM xla_events_gt evt

295: DELETE /*+ index(xal_acs,XLA_AE_LINE_ACS_U1) */
296: FROM xla_ae_line_acs xal_acs
297: WHERE xal_acs.ae_header_id IN
298: (SELECT/*+ leading(evt) use_nl(aeh) unnest index(aeh,XLA_AE_HEADERS_N2) */ aeh.ae_header_id
299: FROM xla_events_gt evt
300: ,xla_ae_headers aeh
301: WHERE evt.reference_char_1 = 'E'
302: AND aeh.application_id = evt.application_id
303: AND aeh.event_id = evt.reference_num_2

Line 320: FROM xla_events_gt evt

316: -- Delete from xla_ae_header_acs
317: DELETE FROM xla_ae_header_acs
318: WHERE ae_header_id IN
319: (SELECT /*+ leading(evt) use_nl(aeh) unnest index(aeh,XLA_AE_HEADERS_N2) */ aeh.ae_header_id
320: FROM xla_events_gt evt
321: ,xla_ae_headers aeh
322: WHERE evt.reference_char_1 = 'E'
323: AND aeh.application_id = evt.application_id
324: AND aeh.event_id = evt.reference_num_2

Line 342: FROM xla_events_gt xe,

338: DELETE FROM xla_ae_lines
339: WHERE application_id = g_application_id
340: AND ae_header_id IN
341: ( SELECT /*+ leading(xe) use_nl(xh) unnest index(xh,XLA_AE_HEADERS_N2) */ xh.ae_header_id
342: FROM xla_events_gt xe,
343: xla_ae_headers xh
344: WHERE xe.reference_char_1 = 'E'
345: AND xh.application_id = xe.application_id
346: AND xh.event_id = xe.reference_num_2

Line 364: FROM xla_events_gt

360: DELETE /*+ index(aeh, xla_ae_headers_n2) */
361: FROM xla_ae_headers aeh
362: WHERE application_id = g_application_id
363: AND event_id IN (SELECT reference_num_2
364: FROM xla_events_gt
365: WHERE reference_char_1 = 'E'
366: AND reference_num_2 IS NOT NULL )
367: AND accounting_entry_status_code <> 'F' ;
368:

Line 397: --| Note: Event_Number in XLA_EVENTS_GT contains the EVENT_ID from which |

393: --| PRIVATE PROCEDURE |
394: --| Validate_Events |
395: --| Local Procedure to validate the consistency of the data that has been |
396: --| provided by the user in the Interface table |
397: --| Note: Event_Number in XLA_EVENTS_GT contains the EVENT_ID from which |
398: --| reversal accounting needs to be created. |
399: --+==========================================================================+
400:
401: PROCEDURE validate_events ( x_return_status OUT NOCOPY VARCHAR2)

Line 410: FROM xla_events_gt evt ,

406: DISTINCT xte.ledger_id trx_ledger_id ,
407: xte.entity_code trx_entity_code ,
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

Line 455: UPDATE xla_events_gt t

451: ,p_level => C_LEVEL_PROCEDURE
452: ,p_module =>l_log_module);
453:
454: END IF;
455: UPDATE xla_events_gt t
456: SET t.process_status_code = 'E'
457: WHERE t.event_id = i.event_id ;
458:
459: x_return_status := FND_API.G_RET_STS_ERROR;

Line 648: FROM xla_events_gt evt

644: evt.event_date TRANSACTION_DATE,
645: evt.BUDGETARY_CONTROL_FLAG ,
646: -9999 UPG_BATCH_ID ,
647: evt.event_number REFERENCE_NUM_1
648: FROM xla_events_gt evt
649: WHERE 1 = 1
650: AND NOT EXISTS
651: ( SELECT /*+ INDEX(xe,XLA_EVENTS_U1) */1
652: FROM xla_events xe

Line 727: ,XLA_EVENTS_GT xe

723: ,xah.AE_HEADER_ID
724: ,'N'
725: ,xah.event_id
726: FROM XLA_AE_HEADERS xah
727: ,XLA_EVENTS_GT xe
728: WHERE xe.application_id = xah.application_id
729: AND xe.event_number = xah.event_id
730: AND xah.application_id = g_application_id
731: AND xe.PROCESS_STATUS_CODE = 'U'

Line 1136: USING XLA_EVENTS_GT evt

1132:
1133: END IF;
1134:
1135: MERGE /*+ INDEX(int,XLA_REVERSE_EVENTS_INTF_U1) */ INTO XLA_REVERSE_EVENTS_INTERFACE int
1136: USING XLA_EVENTS_GT evt
1137: ON ( int.event_id = evt.event_number
1138: AND int.ledger_id = g_ledger_id
1139: AND int.batch_code = g_batch_code
1140: AND int.application_id = evt.application_id

Line 1157: USING XLA_EVENTS_GT evt

1153: ,p_module =>l_log_module);
1154: END IF;
1155:
1156: MERGE /*+ INDEX(xe,XLA_EVENTS_U1) */ INTO xla_events xe
1157: USING XLA_EVENTS_GT evt
1158: ON ( evt.event_id = xe.event_id
1159: AND evt.application_id = xe.application_id
1160: AND xe.application_id = g_application_id
1161: )

Line 1175: USING XLA_EVENTS_GT evt

1171: ,p_module =>l_log_module);
1172: END IF;
1173:
1174: MERGE /*+ INDEX(xah,XLA_AE_HEADERS_N2) */ INTO xla_ae_headers xah
1175: USING XLA_EVENTS_GT evt
1176: ON ( evt.event_id = xah.event_id
1177: AND evt.application_id = xah.application_id
1178: AND xah.accounting_batch_id = g_accounting_batch_id
1179: AND xah.application_id = g_application_id

Line 1247: INSERT INTO xla_events_gt

1243: create_manual_entity ;
1244: END IF;
1245:
1246: FORALL i IN 1..p_array_event_data.event_number.COUNT
1247: INSERT INTO xla_events_gt
1248: (entity_id
1249: ,application_id
1250: ,ledger_id
1251: ,entity_code

Line 1296: FROM xla_events_gt ;

1292:
1293: SELECT MAX(EVENT_DATE) , MAX(event_number)
1294: INTO l_max_event_Date ,
1295: l_max_event_id
1296: FROM xla_events_gt ;
1297:
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' ;

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

Line 1906: INSERT INTO xla_events_gt

1902: END IF;
1903: l_iteration_count := l_iteration_count + 1 ;
1904:
1905: FORALL i IN 1..l_array_del_event_data.application_id.COUNT
1906: INSERT INTO xla_events_gt
1907: (entity_id
1908: ,application_id
1909: ,ledger_id
1910: ,entity_code

Line 1943: (p_msg => 'Rows Inserted into XLA_EVENTS_GT' || l_rowcount_gt

1939: l_rowcount_gt := l_array_del_event_data.application_id.COUNT ;
1940:
1941: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1942: trace
1943: (p_msg => 'Rows Inserted into XLA_EVENTS_GT' || l_rowcount_gt
1944: ,p_level => C_LEVEL_PROCEDURE
1945: ,p_module =>l_log_module);
1946: END IF;
1947:

Line 2000: FROM xla_events_gt

1996: END IF;
1997:
1998: SELECT COUNT(1)
1999: INTO l_delete_count
2000: FROM xla_events_gt
2001: WHERE reference_num_2 IS NOT NULL ;
2002:
2003: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2004: trace

Line 2014: FROM xla_events_gt

2010: DELETE
2011: FROM xla_events xe
2012: WHERE application_id = g_application_id
2013: AND event_id IN (SELECT reference_num_2
2014: FROM xla_events_gt
2015: WHERE reference_char_1 = 'E'
2016: AND reference_num_2 IS NOT NULL )
2017: AND NOT EXISTS
2018: ( SELECT 1

Line 2052: FROM xla_events_gt

2048:
2049: DELETE /*+ rowid(xet) */
2050: FROM XLA_REVERSE_EVENTS_INTERFACE xet
2051: WHERE xet.rowid IN ( SELECT reference_char_2
2052: FROM xla_events_gt
2053: ) ;
2054: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2055: trace
2056: (p_msg => 'Number of rows DELETE FROM Interface = '|| SQL%ROWCOUNT

Line 2068: FROM xla_events_gt

2064: ,xet.REVERSAL_ENTITY_ID = NULL
2065: ,xet.ACCOUNTING_BATCH_ID = NULL
2066: ,xet.process_status_code = 'U'
2067: WHERE xet.rowid IN ( SELECT reference_char_2
2068: FROM xla_events_gt
2069: ) ;
2070: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2071: trace
2072: (p_msg => 'Number of rows UPDATED in Interface = '|| SQL%ROWCOUNT

Line 2079: DELETE FROM xla_events_gt;

2075: END IF;
2076:
2077: END IF;
2078:
2079: DELETE FROM xla_events_gt;
2080:
2081: END LOOP;
2082:
2083: CLOSE lock_del_events_cur;