[Home] [Help]
206: | 30-Nov-2005 V.Swapna 4745309 - Added Payroll |
207: | to handle_accounting_hooks |
208: | 30-Nov-2005 V. Kumar Bug#4769388/4769270 Added hints |
209: | 12-Dec-2005 S. Singhania Bug 4883192. Modified the delete statement|
210: | that deletes from xla_distribution_links|
211: | 14-Dec-2005 V. Kumar Bug#4727703 Added condition to avoid unne-|
212: | -cessary execution of DELETE statements |
213: | 29-Dec-2005 V. Kumar Bug#4879954 Added hint for performance |
214: | 12-Jan-2006 V. Kumar Modified the logic to call GL transfer API|
4126: ,p_module => l_log_module);
4127: END IF;
4128:
4129: --
4130: -- Delete from xla_distribution_links
4131: --
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
4128:
4129: --
4130: -- Delete from xla_distribution_links
4131: --
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
7668: CLOSE c_headers;
7669:
7670: IF (l_array_header_id.COUNT > 0) THEN
7671: FORALL i IN 1..l_array_header_id.COUNT
7672: DELETE FROM xla_distribution_links
7673: WHERE application_id = g_application_id
7674: AND ae_header_id = l_array_header_id(i);
7675:
7676: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7673: WHERE application_id = g_application_id
7674: AND ae_header_id = l_array_header_id(i);
7675:
7676: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7677: trace(p_msg => '# xla_distribution_links deleted = '||SQL%ROWCOUNT
7678: ,p_level => C_LEVEL_STATEMENT
7679: ,p_module => l_log_module);
7680: END IF;
7681: