APPS.XLA_DATAFIXES_PUB dependencies on XLA_AE_LINES

Line 461: FROM xla_ae_lines

457: /* Bug 7011889 - Modified the SQL to handle multiple header ids */
458:
459: SELECT MAX(NVL(MPA_ACCRUAL_ENTRY_FLAG,'N'))
460: INTO l_mpa_acc_rev_flag
461: FROM xla_ae_lines
462: WHERE application_id = p_application_id
463: AND ae_header_id in (SELECT ae_header_id
464: FROM xla_ae_headers
465: WHERE event_id = p_event_id

Line 506: DELETE xla_ae_lines

502: END IF;
503: -------------------------------------------------
504: -- delete incomplete MPA/Accrual Reversal Entries
505: -------------------------------------------------
506: DELETE xla_ae_lines
507: WHERE application_id = p_application_id
508: AND ae_header_id = i.ae_header_id;
509: --
510: DELETE xla_distribution_links

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

838: AND event_id = p_event_id
839: RETURNING ae_header_id BULK COLLECT INTO l_array_ae_header_id;
840:
841: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
842: trace(p_msg => 'Update xla_ae_lines',
843: p_module => l_log_module,
844: p_level => C_LEVEL_STATEMENT);
845: END IF;
846: FORALL i in 1..l_array_ae_header_id.COUNT

Line 847: UPDATE xla_ae_lines

843: p_module => l_log_module,
844: p_level => C_LEVEL_STATEMENT);
845: END IF;
846: FORALL i in 1..l_array_ae_header_id.COUNT
847: UPDATE xla_ae_lines
848: SET description = 'Data fix entry: event_id of '||p_event_id
849: -- business_class_code = NULL -- This is not needed to prevent use by bflow since the entity_code is now 'MANUAL'
850: WHERE application_id = p_application_id
851: AND ae_header_id = l_array_ae_header_id(i);

Line 894: UPDATE xla_ae_lines

890: AND event_id = x_rev_event_id
891: RETURNING ae_header_id BULK COLLECT INTO l_array_ae_header_id;
892:
893: FORALL i in 1..l_array_ae_header_id.COUNT
894: UPDATE xla_ae_lines
895: SET description = 'Data fix reversal entry: event_id of '||x_new_event_id
896: WHERE application_id = p_application_id
897: AND ae_header_id = l_array_ae_header_id(i);
898:

Line 1368: -- audit xla_ae_lines

1364: AND ae_header_id = p_ae_header_id;
1365: END IF;
1366:
1367: -----------------------------------------------------
1368: -- audit xla_ae_lines
1369: -----------------------------------------------------
1370: IF p_ae_line_num IS NOT NULL THEN
1371: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1372: trace(p_msg => 'Audit xla_ae_lines.',

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

1368: -- audit xla_ae_lines
1369: -----------------------------------------------------
1370: IF p_ae_line_num IS NOT NULL THEN
1371: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1372: trace(p_msg => 'Audit xla_ae_lines.',
1373: p_module => l_log_module,
1374: p_level => C_LEVEL_STATEMENT);
1375: END IF;
1376: UPDATE XLA_AE_LINES

Line 1376: UPDATE XLA_AE_LINES

1372: trace(p_msg => 'Audit xla_ae_lines.',
1373: p_module => l_log_module,
1374: p_level => C_LEVEL_STATEMENT);
1375: END IF;
1376: UPDATE XLA_AE_LINES
1377: SET LAST_UPDATE_DATE = sysdate
1378: ,UPG_BATCH_ID = -9999
1379: WHERE application_id = p_application_id
1380: AND ae_header_id = p_ae_header_id

Line 1413: UPDATE XLA_AE_LINES

1409: AND event_id = p_event_id
1410: RETURNING ae_header_id BULK COLLECT INTO l_array_ae_header_id;
1411:
1412: FORALL i in 1..l_array_ae_header_id.COUNT
1413: UPDATE XLA_AE_LINES
1414: SET LAST_UPDATE_DATE = sysdate
1415: ,UPG_BATCH_ID = -9999
1416: WHERE application_id = p_application_id
1417: AND ae_header_id = l_array_ae_header_id(i);