APPS.XLA_AAD_MERGE_PVT dependencies on XLA_DESCRIPTIONS_TL

Line 1136: DELETE FROM xla_descriptions_tl w

1132: p_level => C_LEVEL_STATEMENT);
1133: END IF;
1134:
1135: FORALL i IN 1..l_codes.COUNT
1136: DELETE FROM xla_descriptions_tl w
1137: WHERE application_id = g_application_id
1138: AND amb_context_code = g_amb_context_code
1139: AND description_type_code = C_OWNER_SYSTEM
1140: AND description_code = l_codes(i);

Line 1143: trace(p_msg => '# xla_descriptions_tl deleted = '||SQL%ROWCOUNT,

1139: AND description_type_code = C_OWNER_SYSTEM
1140: AND description_code = l_codes(i);
1141:
1142: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1143: trace(p_msg => '# xla_descriptions_tl deleted = '||SQL%ROWCOUNT,
1144: p_module => l_log_module,
1145: p_level => C_LEVEL_STATEMENT);
1146: END IF;
1147:

Line 2592: DELETE FROM xla_descriptions_tl w

2588: p_module => l_log_module,
2589: p_level => C_LEVEL_STATEMENT);
2590: END IF;
2591:
2592: DELETE FROM xla_descriptions_tl w
2593: WHERE application_id = g_application_id
2594: AND amb_context_code = g_amb_context_code
2595: AND EXISTS (SELECT 1
2596: FROM xla_descriptions_tl s

Line 2596: FROM xla_descriptions_tl s

2592: DELETE FROM xla_descriptions_tl w
2593: WHERE application_id = g_application_id
2594: AND amb_context_code = g_amb_context_code
2595: AND EXISTS (SELECT 1
2596: FROM xla_descriptions_tl s
2597: WHERE s.application_id = g_application_id
2598: AND s.amb_context_code = g_staging_context_code
2599: AND s.description_type_code = w.description_type_code
2600: AND s.description_code = w.description_code

Line 2604: trace(p_msg => '# xla_descriptions_tl delete : '||SQL%ROWCOUNT,

2600: AND s.description_code = w.description_code
2601: AND s.language = w.language);
2602:
2603: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2604: trace(p_msg => '# xla_descriptions_tl delete : '||SQL%ROWCOUNT,
2605: p_module => l_log_module,
2606: p_level => C_LEVEL_STATEMENT);
2607: END IF;
2608:

Line 2695: UPDATE xla_descriptions_tl w

2691: p_module => l_log_module,
2692: p_level => C_LEVEL_STATEMENT);
2693: END IF;
2694:
2695: UPDATE xla_descriptions_tl w
2696: SET amb_context_code = g_amb_context_code
2697: WHERE application_id = g_application_id
2698: AND amb_context_code = g_staging_context_code
2699: AND NOT EXISTS (SELECT 1

Line 2700: FROM xla_descriptions_tl s

2696: SET amb_context_code = g_amb_context_code
2697: WHERE application_id = g_application_id
2698: AND amb_context_code = g_staging_context_code
2699: AND NOT EXISTS (SELECT 1
2700: FROM xla_descriptions_tl s
2701: WHERE s.application_id = g_application_id
2702: AND s.amb_context_code = g_amb_context_code
2703: AND s.description_type_code = w.description_type_code
2704: AND s.name = w.name

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

2704: AND s.name = w.name
2705: AND s.language = w.language);
2706:
2707: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2708: trace(p_msg => '# xla_descriptions_tl 1 updated : '||SQL%ROWCOUNT,
2709: p_module => l_log_module,
2710: p_level => C_LEVEL_STATEMENT);
2711: END IF;
2712:

Line 2713: UPDATE xla_descriptions_tl w

2709: p_module => l_log_module,
2710: p_level => C_LEVEL_STATEMENT);
2711: END IF;
2712:
2713: UPDATE xla_descriptions_tl w
2714: SET amb_context_code = g_amb_context_code
2715: , name = substr('('||w.description_code||') '||name,1,80)
2716: WHERE application_id = g_application_id
2717: AND amb_context_code = g_staging_context_code

Line 2719: FROM xla_descriptions_tl s

2715: , name = substr('('||w.description_code||') '||name,1,80)
2716: WHERE application_id = g_application_id
2717: AND amb_context_code = g_staging_context_code
2718: AND EXISTS (SELECT 1
2719: FROM xla_descriptions_tl s
2720: WHERE s.application_id = g_application_id
2721: AND s.amb_context_code = g_amb_context_code
2722: AND s.description_type_code = w.description_type_code
2723: AND s.name = w.name

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

2724: AND s.language = w.language);
2725:
2726:
2727: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2728: trace(p_msg => '# xla_descriptions_tl 2 updated : '||SQL%ROWCOUNT,
2729: p_module => l_log_module,
2730: p_level => C_LEVEL_STATEMENT);
2731: END IF;
2732: