APPS.XLA_AAD_MERGE_PVT dependencies on XLA_DESC_PRIORITIES

Line 1093: , xla_desc_priorities p

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
1094: WHERE d.description_prio_id = p.description_prio_id
1095: AND p.application_id = g_application_id
1096: AND p.amb_context_code = g_amb_context_code
1097: AND p.description_type_code = C_OWNER_SYSTEM

Line 1110: FROM xla_desc_priorities p

1106: FORALL i IN 1..l_codes.COUNT
1107: DELETE FROM xla_descript_details_b w
1108: WHERE description_prio_id IN
1109: (SELECT description_prio_id
1110: FROM xla_desc_priorities p
1111: WHERE p.application_id = g_application_id
1112: AND p.amb_context_code = g_amb_context_code
1113: AND p.description_type_code = C_OWNER_SYSTEM
1114: AND p.description_code = l_codes(i));

Line 1123: DELETE FROM xla_desc_priorities w

1119: p_level => C_LEVEL_STATEMENT);
1120: END IF;
1121:
1122: FORALL i IN 1..l_codes.COUNT
1123: DELETE FROM xla_desc_priorities w
1124: WHERE application_id = g_application_id
1125: AND amb_context_code = g_amb_context_code
1126: AND description_type_code = C_OWNER_SYSTEM
1127: AND description_code = l_codes(i);

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

1126: AND description_type_code = C_OWNER_SYSTEM
1127: AND description_code = l_codes(i);
1128:
1129: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1130: trace(p_msg => '# xla_desc_priorities deleted = '||SQL%ROWCOUNT,
1131: p_module => l_log_module,
1132: p_level => C_LEVEL_STATEMENT);
1133: END IF;
1134:

Line 2609: DELETE FROM xla_desc_priorities w

2605: p_module => l_log_module,
2606: p_level => C_LEVEL_STATEMENT);
2607: END IF;
2608:
2609: DELETE FROM xla_desc_priorities w
2610: WHERE application_id = g_application_id
2611: AND amb_context_code = g_amb_context_code
2612: AND EXISTS (SELECT 1
2613: FROM xla_desc_priorities s

Line 2613: FROM xla_desc_priorities s

2609: DELETE FROM xla_desc_priorities w
2610: WHERE application_id = g_application_id
2611: AND amb_context_code = g_amb_context_code
2612: AND EXISTS (SELECT 1
2613: FROM xla_desc_priorities s
2614: WHERE s.application_id = g_application_id
2615: AND s.amb_context_code = g_staging_context_code
2616: AND s.description_type_code = w.description_type_code
2617: AND s.description_code = w.description_code);

Line 2620: trace(p_msg => '# xla_desc_priorities delete : '||SQL%ROWCOUNT,

2616: AND s.description_type_code = w.description_type_code
2617: AND s.description_code = w.description_code);
2618:
2619: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2620: trace(p_msg => '# xla_desc_priorities delete : '||SQL%ROWCOUNT,
2621: p_module => l_log_module,
2622: p_level => C_LEVEL_STATEMENT);
2623: END IF;
2624:

Line 2628: FROM xla_desc_priorities w

2624:
2625: DELETE FROM xla_conditions
2626: WHERE description_prio_id IN
2627: (SELECT w.description_prio_id
2628: FROM xla_desc_priorities w
2629: , xla_desc_priorities s
2630: WHERE s.application_id = g_application_id
2631: AND s.amb_context_code = g_staging_context_code
2632: AND w.application_id = g_application_id

Line 2629: , xla_desc_priorities s

2625: DELETE FROM xla_conditions
2626: WHERE description_prio_id IN
2627: (SELECT w.description_prio_id
2628: FROM xla_desc_priorities w
2629: , xla_desc_priorities s
2630: WHERE s.application_id = g_application_id
2631: AND s.amb_context_code = g_staging_context_code
2632: AND w.application_id = g_application_id
2633: AND w.amb_context_code = g_amb_context_code

Line 2646: FROM xla_desc_priorities w

2642:
2643: DELETE FROM xla_descript_details_b
2644: WHERE description_prio_id IN
2645: (SELECT w.description_prio_id
2646: FROM xla_desc_priorities w
2647: , xla_desc_priorities s
2648: WHERE s.application_id = g_application_id
2649: AND s.amb_context_code = g_staging_context_code
2650: AND w.application_id = g_application_id

Line 2647: , xla_desc_priorities s

2643: DELETE FROM xla_descript_details_b
2644: WHERE description_prio_id IN
2645: (SELECT w.description_prio_id
2646: FROM xla_desc_priorities w
2647: , xla_desc_priorities s
2648: WHERE s.application_id = g_application_id
2649: AND s.amb_context_code = g_staging_context_code
2650: AND w.application_id = g_application_id
2651: AND w.amb_context_code = g_amb_context_code

Line 2665: , xla_desc_priorities w

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
2666: , xla_desc_priorities s
2667: WHERE d.description_prio_id = w.description_prio_id
2668: AND s.application_id = g_application_id
2669: AND s.amb_context_code = g_staging_context_code

Line 2666: , xla_desc_priorities s

2662: WHERE description_detail_id IN
2663: (SELECT description_detail_id
2664: FROM xla_descript_details_b d
2665: , xla_desc_priorities w
2666: , xla_desc_priorities s
2667: WHERE d.description_prio_id = w.description_prio_id
2668: AND s.application_id = g_application_id
2669: AND s.amb_context_code = g_staging_context_code
2670: AND s.application_id = g_application_id

Line 2733: UPDATE xla_desc_priorities

2729: p_module => l_log_module,
2730: p_level => C_LEVEL_STATEMENT);
2731: END IF;
2732:
2733: UPDATE xla_desc_priorities
2734: SET amb_context_code = g_amb_context_code
2735: WHERE application_id = g_application_id
2736: AND amb_context_code = g_staging_context_code;
2737:

Line 2739: trace(p_msg => '# xla_desc_priorities updated : '||SQL%ROWCOUNT,

2735: WHERE application_id = g_application_id
2736: AND amb_context_code = g_staging_context_code;
2737:
2738: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2739: trace(p_msg => '# xla_desc_priorities updated : '||SQL%ROWCOUNT,
2740: p_module => l_log_module,
2741: p_level => C_LEVEL_STATEMENT);
2742: END IF;
2743: