APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_DESC_PRIORITIES

Line 439: ,xla_desc_priorities dp

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
440: WHERE dd.description_prio_id = dp.description_prio_id
441: AND dp.application_id = p_application_id
442: AND dp.amb_context_code = p_amb_context_code);
443:

Line 453: FROM xla_desc_priorities

449:
450: DELETE FROM xla_descript_details_b
451: WHERE description_prio_id IN
452: (SELECT description_prio_id
453: FROM xla_desc_priorities
454: WHERE application_id = p_application_id
455: AND amb_context_code = p_amb_context_code);
456:
457: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 463: DELETE FROM xla_desc_priorities

459: p_module => l_log_module,
460: p_level => C_LEVEL_STATEMENT);
461: END IF;
462:
463: DELETE FROM xla_desc_priorities
464: WHERE application_id = p_application_id
465: AND amb_context_code = p_amb_context_code;
466:
467: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

464: WHERE application_id = p_application_id
465: AND amb_context_code = p_amb_context_code;
466:
467: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
468: trace(p_msg => '# record deleted from xla_desc_priorities = '||SQL%ROWCOUNT,
469: p_module => l_log_module,
470: p_level => C_LEVEL_STATEMENT);
471: END IF;
472:

Line 718: FROM xla_desc_priorities

714: FOR UPDATE NOWAIT;
715:
716: CURSOR c_desc_priorities IS
717: SELECT *
718: FROM xla_desc_priorities
719: WHERE application_id = p_application_id
720: AND amb_context_code = p_amb_context_code
721: FOR UPDATE NOWAIT;
722:

Line 727: ,xla_desc_priorities p

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
731: AND p.amb_context_code = p_amb_context_code

Line 2796: ,xla_desc_priorities p

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
2797: WHERE d.description_prio_id = p.description_prio_id
2798: AND p.application_id = p_application_id
2799: AND p.amb_context_code IN (p_amb_context_code, l_staging_context_code));
2800:

Line 2810: FROM xla_desc_priorities

2806:
2807: DELETE FROM xla_descript_details_b
2808: WHERE description_prio_id IN
2809: (SELECT description_prio_id
2810: FROM xla_desc_priorities
2811: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2812: AND application_id = p_application_id);
2813:
2814: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2820: DELETE FROM xla_desc_priorities

2816: p_module => l_log_module,
2817: p_level => C_LEVEL_PROCEDURE);
2818: END IF;
2819:
2820: DELETE FROM xla_desc_priorities
2821: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2822: AND application_id = p_application_id;
2823:
2824: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2825: trace(p_msg => '# xla_desc_priorities deleted = '||SQL%ROWCOUNT,

2821: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2822: AND application_id = p_application_id;
2823:
2824: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2825: trace(p_msg => '# xla_desc_priorities deleted = '||SQL%ROWCOUNT,
2826: p_module => l_log_module,
2827: p_level => C_LEVEL_PROCEDURE);
2828: END IF;
2829: