DBA Data[Home] [Help]

APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_MAPPING_SET_VALUES

Line 604: DELETE FROM xla_mapping_set_values

600: p_level => C_LEVEL_STATEMENT);
601: END IF;
602:
603: FORALL i IN 1 .. l_ms_codes.COUNT
604: DELETE FROM xla_mapping_set_values
605: WHERE mapping_set_code = l_ms_codes(i)
606: AND amb_context_code = g_amb_context_code;
607:
608: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 609: trace(p_msg => '# row deleted into xla_mapping_set_values = '||SQL%ROWCOUNT,

605: WHERE mapping_set_code = l_ms_codes(i)
606: AND amb_context_code = g_amb_context_code;
607:
608: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
609: trace(p_msg => '# row deleted into xla_mapping_set_values = '||SQL%ROWCOUNT,
610: p_module => l_log_module,
611: p_level => C_LEVEL_STATEMENT);
612: END IF;
613:

Line 1414: UPDATE xla_mapping_set_values

1410: p_module => l_log_module,
1411: p_level => C_LEVEL_STATEMENT);
1412: END IF;
1413:
1414: UPDATE xla_mapping_set_values
1415: SET amb_context_code = g_amb_context_code
1416: WHERE amb_context_code = g_staging_context_code;
1417:
1418: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1419: trace(p_msg => '# row moved in xla_mapping_set_values = '||SQL%ROWCOUNT,

1415: SET amb_context_code = g_amb_context_code
1416: WHERE amb_context_code = g_staging_context_code;
1417:
1418: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1419: trace(p_msg => '# row moved in xla_mapping_set_values = '||SQL%ROWCOUNT,
1420: p_module => l_log_module,
1421: p_level => C_LEVEL_STATEMENT);
1422: END IF;
1423: