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_LINES

Line 330: FROM xla_ae_lines xal, gl_import_references gir

326: AND event_id = p_event_id
327: -- added bug#8344908
328: AND NOT EXISTS
329: ( SELECT 1
330: FROM xla_ae_lines xal, gl_import_references gir
331: WHERE xah.ae_header_id = xal.ae_header_id
332: AND xah.application_id = xal.application_id
333: AND xal.gl_sl_link_id = gir.gl_sl_link_id
334: AND xal.gl_sl_link_table = gir.gl_sl_link_table

Line 524: FROM xla_ae_lines xal, gl_import_references gir

520: AND NVL(xah2.gl_transfer_status_code,'N') IN ('N','NT')) -- can be reversed only if it is transferred
521: --Added bug#8344908
522: AND EXISTS
523: ( SELECT 1
524: FROM xla_ae_lines xal, gl_import_references gir
525: WHERE xah.ae_header_id = xal.ae_header_id
526: AND xah.application_id = xal.application_id
527: AND xal.gl_sl_link_id = gir.gl_sl_link_id
528: AND xal.gl_sl_link_table = gir.gl_sl_link_table

Line 751: FROM xla_ae_lines

747: /* Bug 7011889 - Modified the SQL to handle multiple header ids */
748:
749: SELECT MAX(NVL(MPA_ACCRUAL_ENTRY_FLAG,'N'))
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

Line 796: DELETE xla_ae_lines

792: END IF;
793: -------------------------------------------------
794: -- delete incomplete MPA/Accrual Reversal Entries
795: -------------------------------------------------
796: DELETE xla_ae_lines
797: WHERE application_id = p_application_id
798: AND ae_header_id = i.ae_header_id;
799: --
800: DELETE xla_distribution_links

Line 1144: trace(p_msg => 'Update xla_ae_lines',

1140: AND event_id = p_event_id
1141: RETURNING ae_header_id BULK COLLECT INTO l_array_ae_header_id;
1142:
1143: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1144: trace(p_msg => 'Update xla_ae_lines',
1145: p_module => l_log_module,
1146: p_level => C_LEVEL_STATEMENT);
1147: END IF;
1148: FORALL i in 1..l_array_ae_header_id.COUNT

Line 1149: UPDATE xla_ae_lines

1145: p_module => l_log_module,
1146: p_level => C_LEVEL_STATEMENT);
1147: END IF;
1148: FORALL i in 1..l_array_ae_header_id.COUNT
1149: UPDATE xla_ae_lines
1150: SET description = l_new_description --'Data fix entry: event_id of '||p_event_id
1151: -- business_class_code = NULL -- This is not needed to prevent use by bflow since the entity_code is now 'MANUAL'
1152: WHERE application_id = p_application_id
1153: AND ae_header_id = l_array_ae_header_id(i);

Line 1171: is resulting in accounting error as the NOT EXISTS of the following select fails in xla_ae_lines_pkg

1167:
1168: /*
1169: bug#8421688:
1170: On undoing a cancelled event like invoice cancellation or payment cancellation, the redo of that event
1171: is resulting in accounting error as the NOT EXISTS of the following select fails in xla_ae_lines_pkg
1172: accounting_reversal procedure.
1173: SELECT 1 FROM xla_distribution_links xdl
1174: WHERE ref_ae_header_id = xdl.ae_header_id
1175: AND temp_line_num = xdl.temp_line_num * -1

Line 1215: UPDATE xla_ae_lines

1211: AND event_id = x_rev_event_id
1212: RETURNING ae_header_id BULK COLLECT INTO l_array_ae_header_id;
1213:
1214: FORALL i in 1..l_array_ae_header_id.COUNT
1215: UPDATE xla_ae_lines
1216: SET description = l_new_description -- 'Data fix reversal entry: event_id of '||x_new_event_id
1217: WHERE application_id = p_application_id
1218: AND ae_header_id = l_array_ae_header_id(i);
1219:

Line 1815: -- audit xla_ae_lines

1811: AND ae_header_id = p_ae_header_id;
1812: END IF;
1813:
1814: -----------------------------------------------------
1815: -- audit xla_ae_lines
1816: -----------------------------------------------------
1817: IF p_ae_line_num IS NOT NULL THEN
1818: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1819: trace(p_msg => 'Audit xla_ae_lines.',

Line 1819: trace(p_msg => 'Audit xla_ae_lines.',

1815: -- audit xla_ae_lines
1816: -----------------------------------------------------
1817: IF p_ae_line_num IS NOT NULL THEN
1818: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1819: trace(p_msg => 'Audit xla_ae_lines.',
1820: p_module => l_log_module,
1821: p_level => C_LEVEL_STATEMENT);
1822: END IF;
1823: UPDATE XLA_AE_LINES

Line 1823: UPDATE XLA_AE_LINES

1819: trace(p_msg => 'Audit xla_ae_lines.',
1820: p_module => l_log_module,
1821: p_level => C_LEVEL_STATEMENT);
1822: END IF;
1823: UPDATE XLA_AE_LINES
1824: SET LAST_UPDATE_DATE = sysdate
1825: ,UPG_BATCH_ID = -9999
1826: WHERE application_id = p_application_id
1827: AND ae_header_id = p_ae_header_id

Line 1860: UPDATE XLA_AE_LINES

1856: AND event_id = p_event_id
1857: RETURNING ae_header_id BULK COLLECT INTO l_array_ae_header_id;
1858:
1859: FORALL i in 1..l_array_ae_header_id.COUNT
1860: UPDATE XLA_AE_LINES
1861: SET LAST_UPDATE_DATE = sysdate
1862: ,UPG_BATCH_ID = -9999
1863: WHERE application_id = p_application_id
1864: AND ae_header_id = l_array_ae_header_id(i);