APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_MAPPING_SETS_B

Line 101: FROM xla_mapping_sets_b w

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')

Line 102: ,xla_mapping_sets_b s

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

Line 493: FROM xla_mapping_sets_b bs

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;

Line 494: ,xla_mapping_sets_b bw

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:

Line 626: DELETE FROM xla_mapping_sets_b

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

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

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:

Line 1394: UPDATE xla_mapping_sets_b

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

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

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: