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_DATAFIXES_PUB dependencies on XLA_AE_HEADERS

Line 324: FROM xla_ae_headers xah

320: -- Validation
321: -----------------------------------------------------------------------------------
322: SELECT MAX(NVL(gl_transfer_status_code,'N')) -- N, NT, S, Y
323: INTO l_gl_transfer_status_code
324: FROM xla_ae_headers xah
325: WHERE application_id = p_application_id
326: AND event_id = p_event_id
327: -- added bug#8344908
328: AND NOT EXISTS

Line 483: xla_ae_headers xah,

479: xle.budgetary_control_flag
480: FROM XLA_LEDGER_OPTIONS opt,
481: XLA_LEDGER_RELATIONSHIPS_V rs,
482: xla_gl_ledgers_v gl,
483: xla_ae_headers xah,
484: xla_subledgers xsu,
485: xla_events xle,
486: xla_transaction_entities xte
487: WHERE opt.LEDGER_ID = xah.ledger_id

Line 506: AND not exists(select 1 from xla_ae_headers xah1 where xah1.entity_id=xah.entity_id

502: AND xsu.valuation_method_flag = 'Y'
503: AND opt.CAPTURE_EVENT_FLAG = 'Y')
504: --added bug 11883762
505: OR (rs.LEDGER_CATEGORY_CODE = 'SECONDARY' AND rownum=1
506: AND not exists(select 1 from xla_ae_headers xah1 where xah1.entity_id=xah.entity_id
507: AND xah1.application_id=p_application_id
508: AND xah1.event_id=xah.event_id
509: AND xah1.ledger_id=rs.primary_ledger_id)))
510:

Line 516: FROM xla_ae_headers xah2

512: AND rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
513: AND rs.ledger_id = gl.ledger_id
514: AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL
515: AND NOT EXISTS (SELECT 1
516: FROM xla_ae_headers xah2
517: WHERE xah2.application_id = p_application_id
518: AND xah2.event_id = p_event_id
519: AND xah2.accounting_entry_status_code = C_STATUS_FINAL_CODE
520: AND NVL(xah2.gl_transfer_status_code,'N') IN ('N','NT')) -- can be reversed only if it is transferred

Line 563: l_new_description xla_ae_headers.description%TYPE;

559: WHERE application_id = p_application_id
560: AND entity_id = p_orig_entity_id;
561:
562: l_orig_entity_code xla_event_types_b.entity_code%TYPE;
563: l_new_description xla_ae_headers.description%TYPE;
564:
565: l_count number;--Bug 8752657
566:
567: --end bug#8279661

Line 663: xla_ae_headers xah,

659: BULK COLLECT INTO l_array_je_header_id
660: FROM XLA_LEDGER_OPTIONS opt,
661: XLA_LEDGER_RELATIONSHIPS_V rs,
662: xla_gl_ledgers_v gl,
663: xla_ae_headers xah,
664: xla_subledgers xsu,
665: xla_events xle,
666: xla_transaction_entities xte
667: WHERE opt.LEDGER_ID = xah.ledger_id

Line 686: AND not exists(select 1 from xla_ae_headers xah1 where xah1.entity_id=xah.entity_id

682: AND xsu.valuation_method_flag = 'Y'
683: AND opt.CAPTURE_EVENT_FLAG = 'Y')
684: --added bug 11883762
685: OR (rs.LEDGER_CATEGORY_CODE = 'SECONDARY' AND rownum=1
686: AND not exists(select 1 from xla_ae_headers xah1 where xah1.entity_id=xah.entity_id
687: AND xah1.application_id=p_application_id
688: AND xah1.event_id=xah.event_id
689: AND xah1.ledger_id=rs.primary_ledger_id)))
690:

Line 695: FROM xla_ae_headers xah2

691: --end bug 11883762
692: AND rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
693: AND rs.ledger_id = gl.ledger_id
694: AND NOT EXISTS (SELECT 1
695: FROM xla_ae_headers xah2
696: WHERE xah2.application_id = p_application_id
697: AND xah2.event_id = p_event_id
698: AND xah2.accounting_entry_status_code = C_STATUS_FINAL_CODE
699: AND NVL(xah2.gl_transfer_status_code,'N') IN ('N','NT')

Line 754: FROM xla_ae_headers

750: INTO l_mpa_acc_rev_flag
751: FROM xla_ae_lines
752: WHERE application_id = p_application_id
753: AND ae_header_id in (SELECT ae_header_id
754: FROM xla_ae_headers
755: WHERE event_id = p_event_id
756: AND application_id = p_application_id);
757:
758: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 783: FROM xla_ae_headers

779: -- less work in subsequent APIs, and anyway rollback if there is error
780: -------------------------------------------------------------------------
781: IF l_mpa_acc_rev_flag = 'Y' THEN
782: FOR i in (SELECT ae_header_id
783: FROM xla_ae_headers
784: WHERE application_id = p_application_id
785: AND event_id = p_event_id
786: AND parent_ae_header_id IS NOT NULL
787: AND accounting_entry_status_code <> C_STATUS_FINAL_CODE ) LOOP

Line 804: DELETE xla_ae_headers

800: DELETE xla_distribution_links
801: WHERE application_id = p_application_id
802: AND ae_header_id = i.ae_header_id;
803: --
804: DELETE xla_ae_headers
805: WHERE application_id = p_application_id
806: AND ae_header_id = i.ae_header_id;
807: --
808: END LOOP;

Line 814: update xla_ae_headers

810:
811: -----------------------------------------------------------------------------------
812: -- Currently, xla_journal_entries_pkg.reverse_journal_entry only process MANUAL entry
813: -----------------------------------------------------------------------------------
814: update xla_ae_headers
815: set accounting_entry_type_code = 'MANUAL'
816: where application_id = p_application_id
817: and event_id = p_event_id;
818:

Line 1119: trace(p_msg => 'Update xla_ae_headers',

1115: -------------------------------------------------------------------------------
1116: -- set original entries to link to new event, entity. Also update Description
1117: -------------------------------------------------------------------------------
1118: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1119: trace(p_msg => 'Update xla_ae_headers',
1120: p_module => l_log_module,
1121: p_level => C_LEVEL_STATEMENT);
1122: END IF;
1123:

Line 1134: UPDATE xla_ae_headers

1130: /* bug#8279661 Get the entity description details for the event thats reversed */
1131: l_new_description := 'Accounting Error Correction - Initial journal entry for the event_id '||p_event_id || ' For ' ||
1132: get_transaction_details(p_application_id,l_entity_id, 'Y', l_orig_entity_code ); --9813848
1133:
1134: UPDATE xla_ae_headers
1135: SET entity_id = x_new_entity_id
1136: ,event_id = x_new_event_id
1137: ,event_type_code = 'MANUAL'
1138: ,description = l_new_description -- 'Data fix entry: event_id of '||p_event_id

Line 1208: UPDATE xla_ae_headers

1204: /* bug#8279661 Get the entity description details for the event thats reversed */
1205: l_new_description := 'Accounting Error Correction - Offsetting journal entry for the event_id '||x_new_event_id || ' For ' ||
1206: get_transaction_details(p_application_id,l_entity_id, 'Y', l_orig_entity_code ); --9813848
1207:
1208: UPDATE xla_ae_headers
1209: SET description = l_new_description --'Data fix reversal entry: event_id of '||x_new_event_id
1210: WHERE application_id = p_application_id
1211: AND event_id = x_rev_event_id
1212: RETURNING ae_header_id BULK COLLECT INTO l_array_ae_header_id;

Line 1520: UPDATE xla_ae_headers

1516:
1517: -- Initialize global variables
1518: x_return_status := FND_API.G_RET_STS_SUCCESS;
1519:
1520: UPDATE xla_ae_headers
1521: SET gl_transfer_status_code = 'NT'
1522: WHERE application_id = p_application_id
1523: AND ae_header_id = p_ae_header_id
1524: AND accounting_entry_status_code = C_STATUS_FINAL_CODE

Line 1614: FROM xla_ae_headers xah

1610: ,xah.accounting_date
1611: ,xah.ledger_id
1612: ,xah.entity_id
1613: ,xtb.definition_code
1614: FROM xla_ae_headers xah
1615: ,xla_tb_defn_je_sources xtbje
1616: ,xla_tb_definitions_vl xtb
1617: ,xla_subledgers xsl
1618: WHERE xah.application_id = p_application_id

Line 1699: FROM xla_ae_headers

1695: x_return_status := FND_API.G_RET_STS_SUCCESS;
1696:
1697: SELECT count(*)
1698: INTO l_dummy
1699: FROM xla_ae_headers
1700: WHERE application_id = p_application_id
1701: AND ae_header_id = p_ae_header_id
1702: AND accounting_entry_status_code = C_STATUS_FINAL_CODE;
1703:

Line 1799: -- audit xla_ae_headers

1795: p_level => C_LEVEL_PROCEDURE);
1796: END IF;
1797:
1798: -----------------------------------------------------
1799: -- audit xla_ae_headers
1800: -----------------------------------------------------
1801: IF p_ae_header_id IS NOT NULL THEN
1802: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1803: trace(p_msg => 'Audit xla_ae_headers.',

Line 1803: trace(p_msg => 'Audit xla_ae_headers.',

1799: -- audit xla_ae_headers
1800: -----------------------------------------------------
1801: IF p_ae_header_id IS NOT NULL THEN
1802: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1803: trace(p_msg => 'Audit xla_ae_headers.',
1804: p_module => l_log_module,
1805: p_level => C_LEVEL_STATEMENT);
1806: END IF;
1807: UPDATE XLA_AE_HEADERS

Line 1807: UPDATE XLA_AE_HEADERS

1803: trace(p_msg => 'Audit xla_ae_headers.',
1804: p_module => l_log_module,
1805: p_level => C_LEVEL_STATEMENT);
1806: END IF;
1807: UPDATE XLA_AE_HEADERS
1808: SET LAST_UPDATE_DATE = sysdate
1809: ,UPG_BATCH_ID = -9999
1810: WHERE application_id = p_application_id
1811: AND ae_header_id = p_ae_header_id;

Line 1852: UPDATE XLA_AE_HEADERS

1848: trace(p_msg => 'Audit all details of xla_events.',
1849: p_module => l_log_module,
1850: p_level => C_LEVEL_STATEMENT);
1851: END IF;
1852: UPDATE XLA_AE_HEADERS
1853: SET LAST_UPDATE_DATE = sysdate
1854: ,UPG_BATCH_ID = -9999
1855: WHERE application_id = p_application_id
1856: AND event_id = p_event_id