APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_LINE_DEFN_JLT_ASSGNS

Line 249: DELETE FROM xla_line_defn_jlt_assgns

245: p_module => l_log_module,
246: p_level => C_LEVEL_STATEMENT);
247: END IF;
248:
249: DELETE FROM xla_line_defn_jlt_assgns
250: WHERE application_id = p_application_id
251: AND amb_context_code = p_amb_context_code;
252:
253: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

250: WHERE application_id = p_application_id
251: AND amb_context_code = p_amb_context_code;
252:
253: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
254: trace(p_msg => '# record deleted from xla_line_defn_jlt_assgns = '||SQL%ROWCOUNT,
255: p_module => l_log_module,
256: p_level => C_LEVEL_STATEMENT);
257: END IF;
258:

Line 641: FROM xla_line_defn_jlt_assgns

637: FOR UPDATE NOWAIT;
638:
639: CURSOR c_line_defn_jlt_assgns IS
640: SELECT *
641: FROM xla_line_defn_jlt_assgns
642: WHERE application_id = p_application_id
643: AND amb_context_code = p_amb_context_code
644: FOR UPDATE NOWAIT;
645:

Line 2622: DELETE FROM xla_line_defn_jlt_assgns

2618: p_module => l_log_module,
2619: p_level => C_LEVEL_PROCEDURE);
2620: END IF;
2621:
2622: DELETE FROM xla_line_defn_jlt_assgns
2623: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2624: AND application_id = p_application_id;
2625:
2626: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2627: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||SQL%ROWCOUNT,

2623: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2624: AND application_id = p_application_id;
2625:
2626: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2627: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||SQL%ROWCOUNT,
2628: p_module => l_log_module,
2629: p_level => C_LEVEL_PROCEDURE);
2630: END IF;
2631: