APPS.XLA_ACCOUNTING_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 210: | that deletes from xla_distribution_links|

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|

Line 3862: -- Delete from xla_distribution_links

3858: ,p_module => l_log_module);
3859: END IF;
3860:
3861: --
3862: -- Delete from xla_distribution_links
3863: --
3864: DELETE FROM xla_distribution_links
3865: WHERE ae_header_id IN
3866: (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ xh.ae_header_id

Line 3864: DELETE FROM xla_distribution_links

3860:
3861: --
3862: -- Delete from xla_distribution_links
3863: --
3864: DELETE FROM xla_distribution_links
3865: WHERE ae_header_id IN
3866: (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ xh.ae_header_id
3867: FROM xla_events_gt xe,
3868: xla_ae_headers xh

Line 7293: DELETE FROM xla_distribution_links

7289: CLOSE c_headers;
7290:
7291: IF (l_array_header_id.COUNT > 0) THEN
7292: FORALL i IN 1..l_array_header_id.COUNT
7293: DELETE FROM xla_distribution_links
7294: WHERE application_id = g_application_id
7295: AND ae_header_id = l_array_header_id(i);
7296:
7297: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 7298: trace(p_msg => '# xla_distribution_links deleted = '||SQL%ROWCOUNT

7294: WHERE application_id = g_application_id
7295: AND ae_header_id = l_array_header_id(i);
7296:
7297: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7298: trace(p_msg => '# xla_distribution_links deleted = '||SQL%ROWCOUNT
7299: ,p_level => C_LEVEL_STATEMENT
7300: ,p_module => l_log_module);
7301: END IF;
7302: