APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_LINE_DEFINITIONS_B

Line 259: DELETE FROM xla_line_definitions_b

255: p_module => l_log_module,
256: p_level => C_LEVEL_STATEMENT);
257: END IF;
258:
259: DELETE FROM xla_line_definitions_b
260: WHERE application_id = p_application_id
261: AND amb_context_code = p_amb_context_code;
262:
263: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

260: WHERE application_id = p_application_id
261: AND amb_context_code = p_amb_context_code;
262:
263: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
264: trace(p_msg => '# record deleted from xla_line_definitions_b = '||SQL%ROWCOUNT,
265: p_module => l_log_module,
266: p_level => C_LEVEL_STATEMENT);
267: END IF;
268:

Line 627: FROM xla_line_definitions_b

623: FOR UPDATE NOWAIT;
624:
625: CURSOR c_line_definitions_b IS
626: SELECT *
627: FROM xla_line_definitions_b
628: WHERE application_id = p_application_id
629: AND amb_context_code = p_amb_context_code
630: FOR UPDATE NOWAIT;
631:

Line 2642: DELETE FROM xla_line_definitions_b

2638: p_module => l_log_module,
2639: p_level => C_LEVEL_PROCEDURE);
2640: END IF;
2641:
2642: DELETE FROM xla_line_definitions_b
2643: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2644: AND application_id = p_application_id;
2645:
2646: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2647: trace(p_msg => '# xla_line_definitions_b deleted = '||SQL%ROWCOUNT,

2643: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2644: AND application_id = p_application_id;
2645:
2646: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2647: trace(p_msg => '# xla_line_definitions_b deleted = '||SQL%ROWCOUNT,
2648: p_module => l_log_module,
2649: p_level => C_LEVEL_PROCEDURE);
2650: END IF;
2651: