APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_LINE_DEFN_ADR_ASSGNS

Line 239: DELETE FROM xla_line_defn_adr_assgns

235: p_module => l_log_module,
236: p_level => C_LEVEL_STATEMENT);
237: END IF;
238:
239: DELETE FROM xla_line_defn_adr_assgns
240: WHERE application_id = p_application_id
241: AND amb_context_code = p_amb_context_code;
242:
243: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

240: WHERE application_id = p_application_id
241: AND amb_context_code = p_amb_context_code;
242:
243: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
244: trace(p_msg => '# record deleted from xla_line_defn_adr_assgns = '||SQL%ROWCOUNT,
245: p_module => l_log_module,
246: p_level => C_LEVEL_STATEMENT);
247: END IF;
248:

Line 648: FROM xla_line_defn_adr_assgns

644: FOR UPDATE NOWAIT;
645:
646: CURSOR c_line_defn_adr_assgns IS
647: SELECT *
648: FROM xla_line_defn_adr_assgns
649: WHERE application_id = p_application_id
650: AND amb_context_code = p_amb_context_code
651: FOR UPDATE NOWAIT;
652:

Line 2612: DELETE FROM xla_line_defn_adr_assgns

2608: p_module => l_log_module,
2609: p_level => C_LEVEL_PROCEDURE);
2610: END IF;
2611:
2612: DELETE FROM xla_line_defn_adr_assgns
2613: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2614: AND application_id = p_application_id;
2615:
2616: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2617: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||SQL%ROWCOUNT,

2613: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2614: AND application_id = p_application_id;
2615:
2616: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2617: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||SQL%ROWCOUNT,
2618: p_module => l_log_module,
2619: p_level => C_LEVEL_PROCEDURE);
2620: END IF;
2621:

Line 2976: FROM xla_line_defn_adr_assgns xld

2972: SELECT app.application_name
2973: , xst.name segment_rule_name
2974: , lk1.meaning segment_rule_owner
2975: , xld.adr_version_num version_num
2976: FROM xla_line_defn_adr_assgns xld
2977: , xla_seg_rules_b xsr
2978: , xla_seg_rules_tl xst
2979: , fnd_application_vl app
2980: , xla_lookups lk1