97: AND s.amb_context_code = g_staging_context_code;
98:
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')
98:
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
489: CURSOR c_ms IS
490: SELECT bs.mapping_set_code
491: ,bw.version_num version_from
492: ,bs.version_num version_to
493: FROM xla_mapping_sets_b bs
494: ,xla_mapping_sets_b bw
495: WHERE bs.mapping_set_code = bw.mapping_set_code
496: AND bs.amb_context_code = g_staging_context_code
497: AND bw.amb_context_code = g_amb_context_code;
490: SELECT bs.mapping_set_code
491: ,bw.version_num version_from
492: ,bs.version_num version_to
493: FROM xla_mapping_sets_b bs
494: ,xla_mapping_sets_b bw
495: WHERE bs.mapping_set_code = bw.mapping_set_code
496: AND bs.amb_context_code = g_staging_context_code
497: AND bw.amb_context_code = g_amb_context_code;
498:
622: p_level => C_LEVEL_STATEMENT);
623: END IF;
624:
625: FORALL i IN 1 .. l_ms_codes.COUNT
626: DELETE FROM xla_mapping_sets_b
627: WHERE mapping_set_code = l_ms_codes(i)
628: AND amb_context_code = g_amb_context_code;
629:
630: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
627: WHERE mapping_set_code = l_ms_codes(i)
628: AND amb_context_code = g_amb_context_code;
629:
630: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
631: trace(p_msg => '# row deleted into xla_mapping_sets_b = '||SQL%ROWCOUNT,
632: p_module => l_log_module,
633: p_level => C_LEVEL_STATEMENT);
634: END IF;
635:
1390: p_level => C_LEVEL_STATEMENT);
1391: END IF;
1392:
1393: -- Move mapping sets
1394: UPDATE xla_mapping_sets_b
1395: SET amb_context_code = g_amb_context_code
1396: WHERE amb_context_code = g_staging_context_code;
1397:
1398: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1395: SET amb_context_code = g_amb_context_code
1396: WHERE amb_context_code = g_staging_context_code;
1397:
1398: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1399: trace(p_msg => '# row moved in xla_mapping_sets_b = '||SQL%ROWCOUNT,
1400: p_module => l_log_module,
1401: p_level => C_LEVEL_STATEMENT);
1402: END IF;
1403: