APPS.XLA_AAD_MERGE_PVT dependencies on XLA_DESCRIPT_DETAILS_TL

Line 1089: DELETE FROM xla_descript_details_tl w

1085: p_level => C_LEVEL_STATEMENT);
1086: END IF;
1087:
1088: FORALL i IN 1..l_codes.COUNT
1089: DELETE FROM xla_descript_details_tl w
1090: WHERE description_detail_id IN
1091: (SELECT description_detail_id
1092: FROM xla_descript_details_b d
1093: , xla_desc_priorities p

Line 1101: trace(p_msg => '# xla_descript_details_tl deleted = '||SQL%ROWCOUNT,

1097: AND p.description_type_code = C_OWNER_SYSTEM
1098: AND p.description_code = l_codes(i));
1099:
1100: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1101: trace(p_msg => '# xla_descript_details_tl deleted = '||SQL%ROWCOUNT,
1102: p_module => l_log_module,
1103: p_level => C_LEVEL_STATEMENT);
1104: END IF;
1105:

Line 2661: DELETE FROM xla_descript_details_tl w

2657: p_module => l_log_module,
2658: p_level => C_LEVEL_STATEMENT);
2659: END IF;
2660:
2661: DELETE FROM xla_descript_details_tl w
2662: WHERE description_detail_id IN
2663: (SELECT description_detail_id
2664: FROM xla_descript_details_b d
2665: , xla_desc_priorities w

Line 2676: trace(p_msg => '# xla_descript_details_tl delete : '||SQL%ROWCOUNT,

2672: AND w.description_type_code = s.description_type_code
2673: AND w.description_code = s.description_code);
2674:
2675: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2676: trace(p_msg => '# xla_descript_details_tl delete : '||SQL%ROWCOUNT,
2677: p_module => l_log_module,
2678: p_level => C_LEVEL_STATEMENT);
2679: END IF;
2680:

Line 2766: UPDATE xla_descript_details_tl

2762: p_module => l_log_module,
2763: p_level => C_LEVEL_STATEMENT);
2764: END IF;
2765:
2766: UPDATE xla_descript_details_tl
2767: SET amb_context_code = g_amb_context_code
2768: WHERE amb_context_code = g_staging_context_code;
2769:
2770: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2771: trace(p_msg => '# xla_descript_details_tl updated : '||SQL%ROWCOUNT,

2767: SET amb_context_code = g_amb_context_code
2768: WHERE amb_context_code = g_staging_context_code;
2769:
2770: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2771: trace(p_msg => '# xla_descript_details_tl updated : '||SQL%ROWCOUNT,
2772: p_module => l_log_module,
2773: p_level => C_LEVEL_STATEMENT);
2774: END IF;
2775: