APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AMB_COMPONENTS_H

Line 1384: MERGE INTO xla_amb_components_h h

1380: p_level => C_LEVEL_PROCEDURE);
1381: END IF;
1382:
1383: /*
1384: MERGE INTO xla_amb_components_h h
1385: USING xla_staging_components_h s
1386: ON (h.component_type_code = s.component_type_code
1387: AND h.component_owner_code = s.component_owner_code
1388: AND h.component_code = s.component_code

Line 1396: UPDATE xla_amb_components_h h

1392: WHEN MATCHED THEN
1393: UPDATE SET base_version_num = s.base_version_num;
1394: */
1395:
1396: UPDATE xla_amb_components_h h
1397: SET base_version_num =
1398: (SELECT nvl(s.base_version_num, h2.base_version_num)
1399: FROM xla_amb_components_h h2
1400: , xla_staging_components_h s

Line 1399: FROM xla_amb_components_h h2

1395:
1396: UPDATE xla_amb_components_h h
1397: SET base_version_num =
1398: (SELECT nvl(s.base_version_num, h2.base_version_num)
1399: FROM xla_amb_components_h h2
1400: , xla_staging_components_h s
1401: WHERE h.component_type_code = h2.component_type_code
1402: AND h.component_owner_code = h2.component_owner_code
1403: AND h.component_code = h2.component_code

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

1411: AND s.staging_amb_context_code(+) = p_staging_context_code
1412: AND s.component_type_code(+) <> 'AAD');
1413:
1414: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1415: trace(p_msg => '# xla_amb_components_h updated = '||SQL%ROWCOUNT,
1416: p_module => l_log_module,
1417: p_level => C_LEVEL_PROCEDURE);
1418: END IF;
1419:

Line 1420: INSERT INTO xla_amb_components_h h

1416: p_module => l_log_module,
1417: p_level => C_LEVEL_PROCEDURE);
1418: END IF;
1419:
1420: INSERT INTO xla_amb_components_h h
1421: (component_type_code
1422: ,component_owner_code
1423: ,component_code
1424: ,application_id

Line 1461: FROM xla_amb_components_h h

1457: WHERE s.staging_amb_context_code = p_staging_context_code
1458: AND s.component_type_code <> 'AAD'
1459: AND NOT EXISTS
1460: (SELECT 1
1461: FROM xla_amb_components_h h
1462: WHERE h.component_type_code = s.component_type_code
1463: AND h.component_owner_code = s.component_owner_code
1464: AND h.component_code = s.component_code
1465: AND h.application_id = NVL(s.application_id,-1)

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

1465: AND h.application_id = NVL(s.application_id,-1)
1466: AND h.version_num = s.version_num);
1467:
1468: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1469: trace(p_msg => '# xla_amb_components_h inserted = '||SQL%ROWCOUNT,
1470: p_module => l_log_module,
1471: p_level => C_LEVEL_PROCEDURE);
1472: END IF;
1473:

Line 3138: DELETE FROM xla_amb_components_h

3134:
3135: DELETE FROM xla_aads_h
3136: WHERE application_id = p_application_id;
3137:
3138: DELETE FROM xla_amb_components_h
3139: WHERE application_id = p_application_id;
3140:
3141: UPDATE xla_product_rules_b
3142: SET version_num = 0