APPS.XLA_AAD_MERGE_PVT dependencies on XLA_DESCRIPT_DETAILS_B

Line 1092: FROM xla_descript_details_b d

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
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

Line 1107: DELETE FROM xla_descript_details_b w

1103: p_level => C_LEVEL_STATEMENT);
1104: END IF;
1105:
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

Line 1117: trace(p_msg => '# xla_descript_details_b deleted = '||SQL%ROWCOUNT,

1113: AND p.description_type_code = C_OWNER_SYSTEM
1114: AND p.description_code = l_codes(i));
1115:
1116: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1117: trace(p_msg => '# xla_descript_details_b deleted = '||SQL%ROWCOUNT,
1118: p_module => l_log_module,
1119: p_level => C_LEVEL_STATEMENT);
1120: END IF;
1121:

Line 2643: DELETE FROM xla_descript_details_b

2639: p_module => l_log_module,
2640: p_level => C_LEVEL_STATEMENT);
2641: END IF;
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

Line 2656: trace(p_msg => '# xla_descript_details_b delete : '||SQL%ROWCOUNT,

2652: AND w.description_type_code = s.description_type_code
2653: AND w.description_code = s.description_code);
2654:
2655: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2656: trace(p_msg => '# xla_descript_details_b delete : '||SQL%ROWCOUNT,
2657: p_module => l_log_module,
2658: p_level => C_LEVEL_STATEMENT);
2659: END IF;
2660:

Line 2664: FROM xla_descript_details_b d

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

Line 2756: UPDATE xla_descript_details_b

2752: p_module => l_log_module,
2753: p_level => C_LEVEL_STATEMENT);
2754: END IF;
2755:
2756: UPDATE xla_descript_details_b
2757: SET amb_context_code = g_amb_context_code
2758: WHERE amb_context_code = g_staging_context_code;
2759:
2760: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2761: trace(p_msg => '# xla_descript_details_b updated : '||SQL%ROWCOUNT,

2757: SET amb_context_code = g_amb_context_code
2758: WHERE amb_context_code = g_staging_context_code;
2759:
2760: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2761: trace(p_msg => '# xla_descript_details_b updated : '||SQL%ROWCOUNT,
2762: p_module => l_log_module,
2763: p_level => C_LEVEL_STATEMENT);
2764: END IF;
2765: