DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_PKG dependencies on XLA_AE_SEGMENT_VALUES

Line 4154: -- Delete from xla_ae_segment_values

4150: END IF;
4151:
4152: IF l_delete_count > 0 THEN
4153: --
4154: -- Delete from xla_ae_segment_values
4155: --
4156: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */
4157: FROM xla_ae_segment_values
4158: WHERE ae_header_id IN

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

4152: IF l_delete_count > 0 THEN
4153: --
4154: -- Delete from xla_ae_segment_values
4155: --
4156: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */
4157: FROM xla_ae_segment_values
4158: WHERE ae_header_id IN
4159: (SELECT xh.ae_header_id
4160: FROM xla_events_gt xe,

Line 4157: FROM xla_ae_segment_values

4153: --
4154: -- Delete from xla_ae_segment_values
4155: --
4156: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */
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

Line 7683: DELETE FROM xla_ae_segment_values

7679: ,p_module => l_log_module);
7680: END IF;
7681:
7682: FORALL i IN 1..l_array_header_id.COUNT
7683: DELETE FROM xla_ae_segment_values
7684: WHERE ae_header_id = l_array_header_id(i);
7685:
7686: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7687: trace (p_msg => '# xla_ae_segment_values deleted = '||SQL%ROWCOUNT

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

7683: DELETE FROM xla_ae_segment_values
7684: WHERE ae_header_id = l_array_header_id(i);
7685:
7686: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7687: trace (p_msg => '# xla_ae_segment_values deleted = '||SQL%ROWCOUNT
7688: ,p_level => C_LEVEL_STATEMENT
7689: ,p_module => l_log_module);
7690: END IF;
7691: