99: CURSOR c_ms IS
100: SELECT t.name
101: FROM xla_mapping_sets_b w
102: ,xla_mapping_sets_b s
103: ,xla_mapping_sets_tl t
104: WHERE s.version_num < w.version_num
105: AND t.language = USERENV('LANG')
106: AND t.amb_context_code = w.amb_context_code
107: AND t.mapping_set_code = w.mapping_set_code
611: p_level => C_LEVEL_STATEMENT);
612: END IF;
613:
614: FORALL i IN 1 .. l_ms_codes.COUNT
615: DELETE FROM xla_mapping_sets_tl
616: WHERE mapping_set_code = l_ms_codes(i)
617: AND amb_context_code = g_amb_context_code;
618:
619: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
616: WHERE mapping_set_code = l_ms_codes(i)
617: AND amb_context_code = g_amb_context_code;
618:
619: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
620: trace(p_msg => '# row deleted into xla_mapping_sets_tl = '||SQL%ROWCOUNT,
621: p_module => l_log_module,
622: p_level => C_LEVEL_STATEMENT);
623: END IF;
624:
1400: p_module => l_log_module,
1401: p_level => C_LEVEL_STATEMENT);
1402: END IF;
1403:
1404: UPDATE xla_mapping_sets_tl
1405: SET amb_context_code = g_amb_context_code
1406: WHERE amb_context_code = g_staging_context_code;
1407:
1408: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1405: SET amb_context_code = g_amb_context_code
1406: WHERE amb_context_code = g_staging_context_code;
1407:
1408: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1409: trace(p_msg => '# row moved in xla_mapping_sets_tl = '||SQL%ROWCOUNT,
1410: p_module => l_log_module,
1411: p_level => C_LEVEL_STATEMENT);
1412: END IF;
1413: