APPS.XLA_AAD_MERGE_PVT dependencies on XLA_MAPPING_SETS_B

Line 3357: FROM xla_mapping_sets_b s

3353: IS
3354: -- Retrieve the mapping sets to be merged
3355: CURSOR c_ms IS
3356: SELECT s.mapping_set_code
3357: FROM xla_mapping_sets_b s
3358: , xla_mapping_sets_b w
3359: WHERE s.amb_context_code = g_staging_context_code
3360: AND w.amb_context_code(+) = g_amb_context_code
3361: AND s.mapping_set_code = w.mapping_set_code(+)

Line 3358: , xla_mapping_sets_b w

3354: -- Retrieve the mapping sets to be merged
3355: CURSOR c_ms IS
3356: SELECT s.mapping_set_code
3357: FROM xla_mapping_sets_b s
3358: , xla_mapping_sets_b w
3359: WHERE s.amb_context_code = g_staging_context_code
3360: AND w.amb_context_code(+) = g_amb_context_code
3361: AND s.mapping_set_code = w.mapping_set_code(+)
3362: AND s.version_num >= w.version_num(+);

Line 3388: DELETE FROM xla_mapping_sets_b w

3384: CLOSE c_ms;
3385:
3386: -- Delete the MSs from the working area to be merged
3387: FORALL i in 1 .. l_ms.count
3388: DELETE FROM xla_mapping_sets_b w
3389: WHERE amb_context_code = g_amb_context_code
3390: AND mapping_set_code = l_ms(i);
3391:
3392: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 3393: trace(p_msg => '# xla_mapping_sets_b delete : '||SQL%ROWCOUNT,

3389: WHERE amb_context_code = g_amb_context_code
3390: AND mapping_set_code = l_ms(i);
3391:
3392: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3393: trace(p_msg => '# xla_mapping_sets_b delete : '||SQL%ROWCOUNT,
3394: p_module => l_log_module,
3395: p_level => C_LEVEL_STATEMENT);
3396: END IF;
3397:

Line 3429: UPDATE xla_mapping_sets_b

3425: END IF;
3426:
3427: -- Move the mapping sets from staging area to working area
3428: FORALL i in 1 .. l_ms.count
3429: UPDATE xla_mapping_sets_b
3430: SET amb_context_code = g_amb_context_code
3431: WHERE amb_context_code = g_staging_context_code
3432: AND mapping_set_code = l_ms(i);
3433:

Line 3435: trace(p_msg => '# xla_mapping_sets_b updated : '||SQL%ROWCOUNT,

3431: WHERE amb_context_code = g_staging_context_code
3432: AND mapping_set_code = l_ms(i);
3433:
3434: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3435: trace(p_msg => '# xla_mapping_sets_b updated : '||SQL%ROWCOUNT,
3436: p_module => l_log_module,
3437: p_level => C_LEVEL_STATEMENT);
3438: END IF;
3439:

Line 3793: DELETE FROM xla_mapping_sets_b

3789: p_module => l_log_module,
3790: p_level => C_LEVEL_STATEMENT);
3791: END IF;
3792:
3793: DELETE FROM xla_mapping_sets_b
3794: WHERE amb_context_code = g_staging_context_code;
3795:
3796: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3797: trace(p_msg => '# xla_mapping_sets_b delete : '||SQL%ROWCOUNT,

Line 3797: trace(p_msg => '# xla_mapping_sets_b delete : '||SQL%ROWCOUNT,

3793: DELETE FROM xla_mapping_sets_b
3794: WHERE amb_context_code = g_staging_context_code;
3795:
3796: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3797: trace(p_msg => '# xla_mapping_sets_b delete : '||SQL%ROWCOUNT,
3798: p_module => l_log_module,
3799: p_level => C_LEVEL_STATEMENT);
3800: END IF;
3801: