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

Line 1432: (SELECT 1 FROM xla_events xe, xla_ae_headers xah WHERE

1428: -- Set retcode as warning when ever CmboEdit returns Invalid CCID's -- 7502532
1429: IF ( nvl(fnd_profile.value('XLA_FSAH_EXT_CCID_VAL'),'N') = 'Y') THEN
1430: BEGIN
1431: SELECT 1 INTO l_code FROM dual WHERE EXISTS
1432: (SELECT 1 FROM xla_events xe, xla_ae_headers xah WHERE
1433: xe.application_id= p_application_id AND
1434: xe.application_id=xah.application_id AND
1435: xe.process_status_code in ('I','R') AND
1436: xe.event_status_code ='U' AND

Line 4136: xla_ae_headers xh

4132: DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM xla_distribution_links xdl
4133: WHERE ae_header_id IN
4134: (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ xh.ae_header_id
4135: FROM xla_events_gt xe,
4136: xla_ae_headers xh
4137: WHERE xe.process_status_code in ('D','E','R','I')
4138: AND xh.application_id = xe.application_id
4139: AND xh.event_id = xe.event_id
4140: )

Line 4161: xla_ae_headers xh

4157: FROM xla_ae_segment_values
4158: WHERE ae_header_id IN
4159: (SELECT xh.ae_header_id
4160: FROM xla_events_gt xe,
4161: xla_ae_headers xh
4162: WHERE xe.process_status_code in ('D','E','R', 'I')
4163: AND xh.application_id = xe.application_id
4164: AND xh.event_id = xe.event_id
4165: );

Line 4183: ,xla_ae_headers aeh

4179:
4180: WHERE ae_header_id IN
4181: (SELECT/*+ cardinality(evt,10) unnest */ aeh.ae_header_id
4182: FROM xla_events_gt evt
4183: ,xla_ae_headers aeh
4184: WHERE evt.process_status_code in ('D','E','R','I')
4185: AND aeh.application_id = evt.application_id
4186: AND aeh.event_id = evt.event_id);
4187:

Line 4202: ,xla_ae_headers aeh

4198: DELETE FROM xla_ae_header_acs
4199: WHERE ae_header_id IN
4200: (SELECT aeh.ae_header_id
4201: FROM xla_events_gt evt
4202: ,xla_ae_headers aeh
4203: WHERE evt.process_status_code in ('D','E','R','I')
4204: AND aeh.application_id = evt.application_id
4205: AND aeh.event_id = evt.event_id);
4206:

Line 4222: xla_ae_headers xh

4218: WHERE application_id = g_application_id
4219: AND ae_header_id IN
4220: (SELECT xh.ae_header_id
4221: FROM xla_events_gt xe,
4222: xla_ae_headers xh
4223: WHERE xe.process_status_code in ('D','E','R','I')
4224: AND xh.application_id = xe.application_id
4225: AND xh.event_id = xe.event_id
4226: );

Line 4236: -- Delete from xla_ae_headers

4232: ,p_module => l_log_module);
4233: END IF;
4234:
4235: --
4236: -- Delete from xla_ae_headers
4237: --
4238: DELETE /*+ index(aeh, xla_ae_headers_n2) */
4239: FROM xla_ae_headers aeh
4240: WHERE application_id = g_application_id

Line 4238: DELETE /+ index(aeh, xla_ae_headers_n2) /

4234:
4235: --
4236: -- Delete from xla_ae_headers
4237: --
4238: DELETE /*+ index(aeh, xla_ae_headers_n2) */
4239: FROM xla_ae_headers aeh
4240: WHERE application_id = g_application_id
4241: AND event_id IN (SELECT event_id
4242: FROM xla_events_gt

Line 4239: FROM xla_ae_headers aeh

4235: --
4236: -- Delete from xla_ae_headers
4237: --
4238: DELETE /*+ index(aeh, xla_ae_headers_n2) */
4239: FROM xla_ae_headers aeh
4240: WHERE application_id = g_application_id
4241: AND event_id IN (SELECT event_id
4242: FROM xla_events_gt
4243: WHERE process_status_code IN ('D','E','R','I'));

Line 7066: l_xla_seq_entity VARCHAR2(30) := 'XLA_AE_HEADERS';

7062: --=============================================================================
7063: PROCEDURE sequencing_batch_init
7064: (p_seq_enabled_flag IN OUT NOCOPY VARCHAR2) IS
7065: l_xla_application_id NUMBER := 602;
7066: l_xla_seq_entity VARCHAR2(30) := 'XLA_AE_HEADERS';
7067: l_seq_event_code VARCHAR2(30) := 'COMPLETION';
7068: l_seq_context_value fun_seq_batch.context_value_tbl_type;
7069:
7070: l_seq_status VARCHAR2(30);

Line 7331: DELETE FROM XLA_AE_HEADERS_GT;

7327: (p_msg => '# rows deleted XLA_AE_LINES_GT = '||SQL%ROWCOUNT
7328: ,p_level => C_LEVEL_PROCEDURE
7329: ,p_module => l_log_module);
7330: END IF;
7331: DELETE FROM XLA_AE_HEADERS_GT;
7332: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
7333: trace
7334: (p_msg => '# rows deleted XLA_AE_HEADERS_GT = '||SQL%ROWCOUNT
7335: ,p_level => C_LEVEL_PROCEDURE

Line 7334: (p_msg => '# rows deleted XLA_AE_HEADERS_GT = '||SQL%ROWCOUNT

7330: END IF;
7331: DELETE FROM XLA_AE_HEADERS_GT;
7332: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
7333: trace
7334: (p_msg => '# rows deleted XLA_AE_HEADERS_GT = '||SQL%ROWCOUNT
7335: ,p_level => C_LEVEL_PROCEDURE
7336: ,p_module => l_log_module);
7337: END IF;
7338: DELETE FROM XLA_VALIDATION_LINES_GT;

Line 7557: FROM xla_ae_headers xah

7553:
7554: CURSOR c_headers IS
7555: SELECT /*+ LEADING (XAP) USE_NL (XAP XE XAH) */
7556: xah.ae_header_id
7557: FROM xla_ae_headers xah
7558: , xla_events xe
7559: , xla_acct_prog_events_gt xap
7560: WHERE xah.application_id = xe.application_id
7561: AND xah.event_id = xe.event_id

Line 7724: DELETE FROM xla_ae_headers

7720: ,p_module => l_log_module);
7721: END IF;
7722:
7723: FORALL i IN 1..l_array_header_id.COUNT
7724: DELETE FROM xla_ae_headers
7725: WHERE application_id = g_application_id
7726: AND ae_header_id = l_array_header_id(i);
7727:
7728: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 7729: trace(p_msg => '# xla_ae_headers deleted = '||SQL%ROWCOUNT

7725: WHERE application_id = g_application_id
7726: AND ae_header_id = l_array_header_id(i);
7727:
7728: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7729: trace(p_msg => '# xla_ae_headers deleted = '||SQL%ROWCOUNT
7730: ,p_level => C_LEVEL_STATEMENT
7731: ,p_module => l_log_module);
7732: END IF;
7733: END IF;

Line 7794: l_xla_seq_entity VARCHAR2(30) := 'XLA_AE_HEADERS';

7790: l_array_assignment_id t_array_number;
7791: l_array_error_code t_array_char;
7792:
7793: l_xla_application_id NUMBER := 602;
7794: l_xla_seq_entity VARCHAR2(30) := 'XLA_AE_HEADERS';
7795: l_seq_event_code VARCHAR2(30) := 'COMPLETION';
7796: l_control_attribute_rec fun_seq.control_attribute_rec_type;
7797: l_control_date_tbl fun_seq.control_date_tbl_type;
7798:

Line 7894: FOR c1 IN (SELECT /+ leading(xsl,xeg,aeh) use_nl(aeh) index(xla_ae_headers_n2) /

7890: END;
7891: ELSIF g_processing_mode = 'DOCUMENT' THEN
7892: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Calling sequencing get_sequence_number');
7893:
7894: FOR c1 IN (SELECT /*+ leading(xsl,xeg,aeh) use_nl(aeh) index(xla_ae_headers_n2) */
7895: aeh.ae_header_id ae_header_id
7896: ,aeh.ledger_id ledger_id
7897: ,aeh.balance_type_code balance_type_code
7898: ,xsl.je_source_name je_source_name

Line 7905: FROM xla_ae_headers aeh

7901: ,aeh.event_type_code accounting_event_type_code
7902: ,aeh.accounting_entry_type_code accounting_entry_type_code
7903: ,aeh.accounting_date gl_date
7904: ,aeh.completed_date completion_date
7905: FROM xla_ae_headers aeh
7906: ,xla_events_gt xeg
7907: ,xla_subledgers xsl
7908: WHERE aeh.application_id = xeg.application_id
7909: AND aeh.event_id = xeg.event_id

Line 7998: UPDATE xla_ae_headers aeh

7994: END;
7995: END LOOP;
7996:
7997: FORALL i IN 1..l_array_ae_header_id.COUNT
7998: UPDATE xla_ae_headers aeh
7999: SET aeh.completed_date = l_array_completion_date(i)
8000: ,aeh.completion_acct_seq_assign_id = l_array_assignment_id(i)
8001: ,aeh.completion_acct_seq_version_id = l_array_seq_version_id(i)
8002: ,aeh.completion_acct_seq_value = l_array_sequence_number(i)