4171: ,p_module => l_log_module);
4172: END IF;
4173:
4174: --
4175: -- Delete from xla_ae_line_acs
4176: --
4177: DELETE /*+ use_nl_with_index(XLA_AE_LINE_ACS,XLA_AE_LINE_ACS_U1) leading(VW_NSO_1) */
4178: FROM xla_ae_line_acs
4179:
4173:
4174: --
4175: -- Delete from xla_ae_line_acs
4176: --
4177: DELETE /*+ use_nl_with_index(XLA_AE_LINE_ACS,XLA_AE_LINE_ACS_U1) leading(VW_NSO_1) */
4178: FROM xla_ae_line_acs
4179:
4180: WHERE ae_header_id IN
4181: (SELECT/*+ cardinality(evt,10) unnest */ aeh.ae_header_id
4174: --
4175: -- Delete from xla_ae_line_acs
4176: --
4177: DELETE /*+ use_nl_with_index(XLA_AE_LINE_ACS,XLA_AE_LINE_ACS_U1) leading(VW_NSO_1) */
4178: FROM xla_ae_line_acs
4179:
4180: WHERE ae_header_id IN
4181: (SELECT/*+ cardinality(evt,10) unnest */ aeh.ae_header_id
4182: FROM xla_events_gt evt
7689: ,p_module => l_log_module);
7690: END IF;
7691:
7692: FORALL i IN 1..l_array_header_id.COUNT
7693: DELETE FROM xla_ae_line_acs
7694: WHERE ae_header_id = l_array_header_id(i);
7695:
7696: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7697: trace (p_msg => '# xla_ae_line_acs deleted = '||SQL%ROWCOUNT
7693: DELETE FROM xla_ae_line_acs
7694: WHERE ae_header_id = l_array_header_id(i);
7695:
7696: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7697: trace (p_msg => '# xla_ae_line_acs deleted = '||SQL%ROWCOUNT
7698: ,p_level => C_LEVEL_STATEMENT
7699: ,p_module => l_log_module);
7700: END IF;
7701: