DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_PKG dependencies on XLA_AE_SEGMENT_VALUES

Line 3886: -- Delete from xla_ae_segment_values

3882: END IF;
3883:
3884: IF l_delete_count > 0 THEN
3885: --
3886: -- Delete from xla_ae_segment_values
3887: --
3888: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */
3889: FROM xla_ae_segment_values
3890: WHERE ae_header_id IN

Line 3888: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */

3884: IF l_delete_count > 0 THEN
3885: --
3886: -- Delete from xla_ae_segment_values
3887: --
3888: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */
3889: FROM xla_ae_segment_values
3890: WHERE ae_header_id IN
3891: (SELECT xh.ae_header_id
3892: FROM xla_events_gt xe,

Line 3889: FROM xla_ae_segment_values

3885: --
3886: -- Delete from xla_ae_segment_values
3887: --
3888: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */
3889: FROM xla_ae_segment_values
3890: WHERE ae_header_id IN
3891: (SELECT xh.ae_header_id
3892: FROM xla_events_gt xe,
3893: xla_ae_headers xh

Line 7304: DELETE FROM xla_ae_segment_values

7300: ,p_module => l_log_module);
7301: END IF;
7302:
7303: FORALL i IN 1..l_array_header_id.COUNT
7304: DELETE FROM xla_ae_segment_values
7305: WHERE ae_header_id = l_array_header_id(i);
7306:
7307: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7308: trace (p_msg => '# xla_ae_segment_values deleted = '||SQL%ROWCOUNT

Line 7308: trace (p_msg => '# xla_ae_segment_values deleted = '||SQL%ROWCOUNT

7304: DELETE FROM xla_ae_segment_values
7305: WHERE ae_header_id = l_array_header_id(i);
7306:
7307: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7308: trace (p_msg => '# xla_ae_segment_values deleted = '||SQL%ROWCOUNT
7309: ,p_level => C_LEVEL_STATEMENT
7310: ,p_module => l_log_module);
7311: END IF;
7312: