APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AAD_LINE_DEFN_ASSGNS

Line 279: DELETE FROM xla_aad_line_defn_assgns

275: p_module => l_log_module,
276: p_level => C_LEVEL_STATEMENT);
277: END IF;
278:
279: DELETE FROM xla_aad_line_defn_assgns
280: WHERE application_id = p_application_id
281: AND amb_context_code = p_amb_context_code;
282:
283: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

280: WHERE application_id = p_application_id
281: AND amb_context_code = p_amb_context_code;
282:
283: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
284: trace(p_msg => '# record deleted from xla_aad_line_defn_assgns = '||SQL%ROWCOUNT,
285: p_module => l_log_module,
286: p_level => C_LEVEL_STATEMENT);
287: END IF;
288:

Line 620: FROM xla_aad_line_defn_assgns

616: FOR UPDATE NOWAIT;
617:
618: CURSOR c_aad_line_defn_assgns IS
619: SELECT *
620: FROM xla_aad_line_defn_assgns
621: WHERE application_id = p_application_id
622: AND amb_context_code = p_amb_context_code
623: FOR UPDATE NOWAIT;
624:

Line 2582: DELETE FROM xla_aad_line_defn_assgns

2578: p_module => l_log_module,
2579: p_level => C_LEVEL_PROCEDURE);
2580: END IF;
2581:
2582: DELETE FROM xla_aad_line_defn_assgns
2583: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2584: AND application_id = p_application_id;
2585:
2586: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2587: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||SQL%ROWCOUNT,

2583: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2584: AND application_id = p_application_id;
2585:
2586: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2587: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||SQL%ROWCOUNT,
2588: p_module => l_log_module,
2589: p_level => C_LEVEL_PROCEDURE);
2590: END IF;
2591: