DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_LINE_DEFINITIONS_TL

Line 319: DELETE FROM xla_line_definitions_tl

315: p_module => l_log_module,
316: p_level => C_LEVEL_STATEMENT);
317: END IF;
318:
319: DELETE FROM xla_line_definitions_tl
320: WHERE application_id = p_application_id
321: AND amb_context_code = p_amb_context_code;
322:
323: -- Bug : 16208537

Line 330: p_encoded_message => '# delete (xla_line_definitions_tl) = '||SQL%ROWCOUNT,

326: p_amb_context_code => p_amb_context_code,
327: p_application_id => p_application_id,
328: p_request_code => 'IMPORT' ,
329: p_log_type_code => 'MERGE',
330: p_encoded_message => '# delete (xla_line_definitions_tl) = '||SQL%ROWCOUNT,
331: p_component_code => 'purge');
332:
333: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
334: trace(p_msg => '# record deleted from xla_line_definitions_tl = '||SQL%ROWCOUNT,

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

330: p_encoded_message => '# delete (xla_line_definitions_tl) = '||SQL%ROWCOUNT,
331: p_component_code => 'purge');
332:
333: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
334: trace(p_msg => '# record deleted from xla_line_definitions_tl = '||SQL%ROWCOUNT,
335: p_module => l_log_module,
336: p_level => C_LEVEL_STATEMENT);
337: END IF;
338:

Line 884: FROM xla_line_definitions_tl

880: FOR UPDATE NOWAIT;
881:
882: CURSOR c_line_definitions_tl IS
883: SELECT *
884: FROM xla_line_definitions_tl
885: WHERE application_id = p_application_id
886: AND amb_context_code = p_amb_context_code
887: FOR UPDATE NOWAIT;
888:

Line 3401: DELETE FROM xla_line_definitions_tl

3397: p_module => l_log_module,
3398: p_level => C_LEVEL_PROCEDURE);
3399: END IF;
3400:
3401: DELETE FROM xla_line_definitions_tl
3402: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3403: AND application_id = p_application_id;
3404:
3405: -- Bug 16208537

Line 3412: p_encoded_message => '# delete (xla_line_definitions_tl) = '||SQL%ROWCOUNT,

3408: p_amb_context_code => p_amb_context_code,
3409: p_application_id => p_application_id,
3410: p_request_code => 'IMPORT' ,
3411: p_log_type_code => 'MERGE',
3412: p_encoded_message => '# delete (xla_line_definitions_tl) = '||SQL%ROWCOUNT,
3413: p_component_code => 'purge_aad');
3414:
3415: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3416: trace(p_msg => '# xla_line_definitions_tl deleted = '||SQL%ROWCOUNT,

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

3412: p_encoded_message => '# delete (xla_line_definitions_tl) = '||SQL%ROWCOUNT,
3413: p_component_code => 'purge_aad');
3414:
3415: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3416: trace(p_msg => '# xla_line_definitions_tl deleted = '||SQL%ROWCOUNT,
3417: p_module => l_log_module,
3418: p_level => C_LEVEL_PROCEDURE);
3419: END IF;
3420: