APPS.XLA_AAD_MERGE_PVT dependencies on XLA_MAPPING_SETS_TL

Line 3399: DELETE FROM xla_mapping_sets_tl w

3395: p_level => C_LEVEL_STATEMENT);
3396: END IF;
3397:
3398: FORALL i in 1 .. l_ms.count
3399: DELETE FROM xla_mapping_sets_tl w
3400: WHERE amb_context_code = g_amb_context_code
3401: AND mapping_set_code = l_ms(i)
3402: AND EXISTS (SELECT 1
3403: FROM xla_mapping_sets_tl s

Line 3403: FROM xla_mapping_sets_tl s

3399: DELETE FROM xla_mapping_sets_tl w
3400: WHERE amb_context_code = g_amb_context_code
3401: AND mapping_set_code = l_ms(i)
3402: AND EXISTS (SELECT 1
3403: FROM xla_mapping_sets_tl s
3404: WHERE s.amb_context_code = g_staging_context_code
3405: AND s.mapping_set_code = w.mapping_set_code
3406: AND s.language = w.language);
3407:

Line 3409: trace(p_msg => '# xla_mapping_sets_tl delete : '||SQL%ROWCOUNT,

3405: AND s.mapping_set_code = w.mapping_set_code
3406: AND s.language = w.language);
3407:
3408: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3409: trace(p_msg => '# xla_mapping_sets_tl delete : '||SQL%ROWCOUNT,
3410: p_module => l_log_module,
3411: p_level => C_LEVEL_STATEMENT);
3412: END IF;
3413:

Line 3441: UPDATE xla_mapping_sets_tl s

3437: p_level => C_LEVEL_STATEMENT);
3438: END IF;
3439:
3440: FORALL i in 1 .. l_ms.count
3441: UPDATE xla_mapping_sets_tl s
3442: SET amb_context_code = g_amb_context_code
3443: WHERE amb_context_code = g_staging_context_code
3444: AND mapping_set_code = l_ms(i)
3445: AND NOT EXISTS (SELECT 1

Line 3446: FROM xla_mapping_sets_tl w

3442: SET amb_context_code = g_amb_context_code
3443: WHERE amb_context_code = g_staging_context_code
3444: AND mapping_set_code = l_ms(i)
3445: AND NOT EXISTS (SELECT 1
3446: FROM xla_mapping_sets_tl w
3447: WHERE w.amb_context_code = g_amb_context_code
3448: AND w.name = s.name
3449: AND w.language = s.language);
3450:

Line 3452: trace(p_msg => '# xla_mapping_sets_tl 1 updated : '||SQL%ROWCOUNT,

3448: AND w.name = s.name
3449: AND w.language = s.language);
3450:
3451: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3452: trace(p_msg => '# xla_mapping_sets_tl 1 updated : '||SQL%ROWCOUNT,
3453: p_module => l_log_module,
3454: p_level => C_LEVEL_STATEMENT);
3455: END IF;
3456:

Line 3458: UPDATE xla_mapping_sets_tl s

3454: p_level => C_LEVEL_STATEMENT);
3455: END IF;
3456:
3457: FORALL i in 1 .. l_ms.count
3458: UPDATE xla_mapping_sets_tl s
3459: SET amb_context_code = g_amb_context_code
3460: , name = substr('('||s.mapping_set_code||') '||name,1,80)
3461: WHERE amb_context_code = g_staging_context_code
3462: AND mapping_set_code = l_ms(i)

Line 3464: FROM xla_mapping_sets_tl w

3460: , name = substr('('||s.mapping_set_code||') '||name,1,80)
3461: WHERE amb_context_code = g_staging_context_code
3462: AND mapping_set_code = l_ms(i)
3463: AND EXISTS (SELECT 1
3464: FROM xla_mapping_sets_tl w
3465: WHERE w.amb_context_code = g_amb_context_code
3466: AND w.name = s.name
3467: AND w.language = s.language);
3468:

Line 3470: trace(p_msg => '# xla_mapping_sets_tl 2 updated : '||SQL%ROWCOUNT,

3466: AND w.name = s.name
3467: AND w.language = s.language);
3468:
3469: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3470: trace(p_msg => '# xla_mapping_sets_tl 2 updated : '||SQL%ROWCOUNT,
3471: p_module => l_log_module,
3472: p_level => C_LEVEL_STATEMENT);
3473: END IF;
3474:

Line 3784: DELETE FROM xla_mapping_sets_tl

3780: p_module => l_log_module,
3781: p_level => C_LEVEL_STATEMENT);
3782: END IF;
3783:
3784: DELETE FROM xla_mapping_sets_tl
3785: WHERE amb_context_code = g_staging_context_code;
3786:
3787: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3788: trace(p_msg => '# xla_mapping_sets_tl delete : '||SQL%ROWCOUNT,

Line 3788: trace(p_msg => '# xla_mapping_sets_tl delete : '||SQL%ROWCOUNT,

3784: DELETE FROM xla_mapping_sets_tl
3785: WHERE amb_context_code = g_staging_context_code;
3786:
3787: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3788: trace(p_msg => '# xla_mapping_sets_tl delete : '||SQL%ROWCOUNT,
3789: p_module => l_log_module,
3790: p_level => C_LEVEL_STATEMENT);
3791: END IF;
3792: