APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_LINE_DEFINITIONS_B

Line 299: DELETE FROM xla_line_definitions_b

295: p_module => l_log_module,
296: p_level => C_LEVEL_STATEMENT);
297: END IF;
298:
299: DELETE FROM xla_line_definitions_b
300: WHERE application_id = p_application_id
301: AND amb_context_code = p_amb_context_code;
302:
303: -- Bug : 16208537

Line 310: p_encoded_message => '# delete (xla_line_definitions_b) = '||SQL%ROWCOUNT,

306: p_amb_context_code => p_amb_context_code,
307: p_application_id => p_application_id,
308: p_request_code => 'IMPORT' ,
309: p_log_type_code => 'MERGE',
310: p_encoded_message => '# delete (xla_line_definitions_b) = '||SQL%ROWCOUNT,
311: p_component_code => 'purge');
312:
313: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
314: trace(p_msg => '# record deleted from xla_line_definitions_b = '||SQL%ROWCOUNT,

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

310: p_encoded_message => '# delete (xla_line_definitions_b) = '||SQL%ROWCOUNT,
311: p_component_code => 'purge');
312:
313: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
314: trace(p_msg => '# record deleted from xla_line_definitions_b = '||SQL%ROWCOUNT,
315: p_module => l_log_module,
316: p_level => C_LEVEL_STATEMENT);
317: END IF;
318:

Line 877: FROM xla_line_definitions_b

873: FOR UPDATE NOWAIT;
874:
875: CURSOR c_line_definitions_b IS
876: SELECT *
877: FROM xla_line_definitions_b
878: WHERE application_id = p_application_id
879: AND amb_context_code = p_amb_context_code
880: FOR UPDATE NOWAIT;
881:

Line 3421: DELETE FROM xla_line_definitions_b

3417: p_module => l_log_module,
3418: p_level => C_LEVEL_PROCEDURE);
3419: END IF;
3420:
3421: DELETE FROM xla_line_definitions_b
3422: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3423: AND application_id = p_application_id;
3424:
3425: -- Bug 16208537

Line 3432: p_encoded_message => '# delete (xla_line_definitions_b) = '||SQL%ROWCOUNT,

3428: p_amb_context_code => p_amb_context_code,
3429: p_application_id => p_application_id,
3430: p_request_code => 'IMPORT' ,
3431: p_log_type_code => 'MERGE',
3432: p_encoded_message => '# delete (xla_line_definitions_b) = '||SQL%ROWCOUNT,
3433: p_component_code => 'purge_aad');
3434:
3435: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3436: trace(p_msg => '# xla_line_definitions_b deleted = '||SQL%ROWCOUNT,

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

3432: p_encoded_message => '# delete (xla_line_definitions_b) = '||SQL%ROWCOUNT,
3433: p_component_code => 'purge_aad');
3434:
3435: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3436: trace(p_msg => '# xla_line_definitions_b deleted = '||SQL%ROWCOUNT,
3437: p_module => l_log_module,
3438: p_level => C_LEVEL_PROCEDURE);
3439: END IF;
3440: