APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_MAPPING_SETS_TL

Line 103: ,xla_mapping_sets_tl t

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

Line 615: DELETE FROM xla_mapping_sets_tl

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

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

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:

Line 1404: UPDATE xla_mapping_sets_tl

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

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

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: