APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_DESCRIPT_DETAILS_TL

Line 435: DELETE FROM xla_descript_details_tl

431:
432: --
433: -- Delete descriptions
434: --
435: DELETE FROM xla_descript_details_tl
436: WHERE description_detail_id IN
437: (SELECT description_detail_id
438: FROM xla_descript_details_b dd
439: ,xla_desc_priorities dp

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

441: AND dp.application_id = p_application_id
442: AND dp.amb_context_code = p_amb_context_code);
443:
444: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
445: trace(p_msg => '# record deleted from xla_descript_details_tl = '||SQL%ROWCOUNT,
446: p_module => l_log_module,
447: p_level => C_LEVEL_STATEMENT);
448: END IF;
449:

Line 726: ,xla_descript_details_tl t

722:
723: CURSOR c_descript_details_tl IS
724: SELECT *
725: FROM xla_descript_details_b b
726: ,xla_descript_details_tl t
727: ,xla_desc_priorities p
728: WHERE t.description_detail_id = b.description_detail_id
729: AND b.description_prio_id = p.description_prio_id
730: AND p.application_id = p_application_id

Line 2792: DELETE FROM xla_descript_details_tl

2788: p_module => l_log_module,
2789: p_level => C_LEVEL_PROCEDURE);
2790: END IF;
2791:
2792: DELETE FROM xla_descript_details_tl
2793: WHERE description_detail_id IN
2794: (SELECT d.description_detail_id
2795: FROM xla_descript_details_b d
2796: ,xla_desc_priorities p

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

2798: AND p.application_id = p_application_id
2799: AND p.amb_context_code IN (p_amb_context_code, l_staging_context_code));
2800:
2801: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2802: trace(p_msg => '# xla_descript_details_tl deleted = '||SQL%ROWCOUNT,
2803: p_module => l_log_module,
2804: p_level => C_LEVEL_PROCEDURE);
2805: END IF;
2806: