APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AMB_COMPONENTS_H

Line 1923: MERGE INTO xla_amb_components_h h

1919: p_level => C_LEVEL_PROCEDURE);
1920: END IF;
1921:
1922: /*
1923: MERGE INTO xla_amb_components_h h
1924: USING xla_staging_components_h s
1925: ON (h.component_type_code = s.component_type_code
1926: AND h.component_owner_code = s.component_owner_code
1927: AND h.component_code = s.component_code

Line 1935: UPDATE xla_amb_components_h h

1931: WHEN MATCHED THEN
1932: UPDATE SET base_version_num = s.base_version_num;
1933: */
1934:
1935: UPDATE xla_amb_components_h h
1936: SET base_version_num =
1937: (SELECT nvl(s.base_version_num, h2.base_version_num)
1938: FROM xla_amb_components_h h2
1939: , xla_staging_components_h s

Line 1938: FROM xla_amb_components_h h2

1934:
1935: UPDATE xla_amb_components_h h
1936: SET base_version_num =
1937: (SELECT nvl(s.base_version_num, h2.base_version_num)
1938: FROM xla_amb_components_h h2
1939: , xla_staging_components_h s
1940: WHERE h.component_type_code = h2.component_type_code
1941: AND h.component_owner_code = h2.component_owner_code
1942: AND h.component_code = h2.component_code

Line 1954: trace(p_msg => '# xla_amb_components_h updated = '||SQL%ROWCOUNT,

1950: AND s.staging_amb_context_code(+) = p_staging_context_code
1951: AND s.component_type_code(+) <> 'AAD');
1952:
1953: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1954: trace(p_msg => '# xla_amb_components_h updated = '||SQL%ROWCOUNT,
1955: p_module => l_log_module,
1956: p_level => C_LEVEL_PROCEDURE);
1957: END IF;
1958:

Line 1959: INSERT INTO xla_amb_components_h h

1955: p_module => l_log_module,
1956: p_level => C_LEVEL_PROCEDURE);
1957: END IF;
1958:
1959: INSERT INTO xla_amb_components_h h
1960: (component_type_code
1961: ,component_owner_code
1962: ,component_code
1963: ,application_id

Line 2000: FROM xla_amb_components_h h

1996: WHERE s.staging_amb_context_code = p_staging_context_code
1997: AND s.component_type_code <> 'AAD'
1998: AND NOT EXISTS
1999: (SELECT 1
2000: FROM xla_amb_components_h h
2001: WHERE h.component_type_code = s.component_type_code
2002: AND h.component_owner_code = s.component_owner_code
2003: AND h.component_code = s.component_code
2004: AND h.application_id = NVL(s.application_id,-1)

Line 2008: trace(p_msg => '# xla_amb_components_h inserted = '||SQL%ROWCOUNT,

2004: AND h.application_id = NVL(s.application_id,-1)
2005: AND h.version_num = s.version_num);
2006:
2007: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2008: trace(p_msg => '# xla_amb_components_h inserted = '||SQL%ROWCOUNT,
2009: p_module => l_log_module,
2010: p_level => C_LEVEL_PROCEDURE);
2011: END IF;
2012:

Line 4122: DELETE FROM xla_amb_components_h

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;
4124:
4125: UPDATE xla_product_rules_b
4126: SET version_num = 0