DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_LINE_DEFINITIONS_TL

Line 269: DELETE FROM xla_line_definitions_tl

265: p_module => l_log_module,
266: p_level => C_LEVEL_STATEMENT);
267: END IF;
268:
269: DELETE FROM xla_line_definitions_tl
270: WHERE application_id = p_application_id
271: AND amb_context_code = p_amb_context_code;
272:
273: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

270: WHERE application_id = p_application_id
271: AND amb_context_code = p_amb_context_code;
272:
273: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
274: trace(p_msg => '# record deleted from xla_line_definitions_tl = '||SQL%ROWCOUNT,
275: p_module => l_log_module,
276: p_level => C_LEVEL_STATEMENT);
277: END IF;
278:

Line 634: FROM xla_line_definitions_tl

630: FOR UPDATE NOWAIT;
631:
632: CURSOR c_line_definitions_tl IS
633: SELECT *
634: FROM xla_line_definitions_tl
635: WHERE application_id = p_application_id
636: AND amb_context_code = p_amb_context_code
637: FOR UPDATE NOWAIT;
638:

Line 2632: DELETE FROM xla_line_definitions_tl

2628: p_module => l_log_module,
2629: p_level => C_LEVEL_PROCEDURE);
2630: END IF;
2631:
2632: DELETE FROM xla_line_definitions_tl
2633: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2634: AND application_id = p_application_id;
2635:
2636: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2637: trace(p_msg => '# xla_line_definitions_tl deleted = '||SQL%ROWCOUNT,

2633: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2634: AND application_id = p_application_id;
2635:
2636: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2637: trace(p_msg => '# xla_line_definitions_tl deleted = '||SQL%ROWCOUNT,
2638: p_module => l_log_module,
2639: p_level => C_LEVEL_PROCEDURE);
2640: END IF;
2641: