APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AADS_H

Line 1821: MERGE INTO xla_aads_h h

1817: p_level => C_LEVEL_PROCEDURE);
1818: END IF;
1819:
1820: /*
1821: MERGE INTO xla_aads_h h
1822: USING xla_staging_components_h s
1823: ON (h.application_id = s.application_id
1824: AND h.product_rule_type_code = s.component_owner_code
1825: AND h.product_rule_code = s.component_code

Line 1837: UPDATE xla_aads_h h

1833: , version_comment = s.version_comment
1834: , leapfrog_flag = s.leapfrog_flag;
1835: */
1836:
1837: UPDATE xla_aads_h h
1838: SET (base_version_num
1839: ,user_version
1840: ,version_comment
1841: ,leapfrog_flag) =

Line 1846: FROM xla_aads_h h2

1842: (SELECT NVL(s.base_version_num, h2.base_version_num)
1843: ,NVL(s.product_rule_version, h2.user_version)
1844: ,NVL(s.version_comment, h2.version_comment)
1845: ,NVL(s.leapfrog_flag, h2.leapfrog_flag)
1846: FROM xla_aads_h h2
1847: , xla_staging_components_h s
1848: WHERE h.application_id = h2.application_id
1849: AND h.product_rule_type_code = h2.product_rule_type_code
1850: AND h.product_rule_code = h2.product_rule_code

Line 1862: trace(p_msg => '# xla_aads_h updated = '||SQL%ROWCOUNT,

1858: AND s.component_type_code(+) = 'AAD');
1859:
1860:
1861: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1862: trace(p_msg => '# xla_aads_h updated = '||SQL%ROWCOUNT,
1863: p_module => l_log_module,
1864: p_level => C_LEVEL_PROCEDURE);
1865: END IF;
1866:

Line 1867: INSERT INTO xla_aads_h

1863: p_module => l_log_module,
1864: p_level => C_LEVEL_PROCEDURE);
1865: END IF;
1866:
1867: INSERT INTO xla_aads_h
1868: (application_id
1869: ,product_rule_type_code
1870: ,product_rule_code
1871: ,version_num

Line 1910: FROM xla_aads_h h

1906: AND s.staging_amb_context_code = p_staging_context_code
1907: AND s.component_type_code = 'AAD'
1908: AND NOT EXISTS
1909: (SELECT 1
1910: FROM xla_aads_h h
1911: WHERE h.application_id = s.application_id
1912: AND h.product_rule_type_code = s.component_owner_code
1913: AND h.product_rule_code = s.component_code
1914: AND h.version_num = s.version_num);

Line 1917: trace(p_msg => '# xla_aads_h inserted = '||SQL%ROWCOUNT,

1913: AND h.product_rule_code = s.component_code
1914: AND h.version_num = s.version_num);
1915:
1916: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1917: trace(p_msg => '# xla_aads_h inserted = '||SQL%ROWCOUNT,
1918: p_module => l_log_module,
1919: p_level => C_LEVEL_PROCEDURE);
1920: END IF;
1921:

Line 4119: DELETE FROM xla_aads_h

4115:
4116: -- Initialize global variables
4117: x_return_status := FND_API.G_RET_STS_SUCCESS;
4118:
4119: DELETE FROM xla_aads_h
4120: WHERE application_id = p_application_id;
4121:
4122: DELETE FROM xla_amb_components_h
4123: WHERE application_id = p_application_id;