APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AAD_LINE_DEFN_ASSGNS

Line 339: DELETE FROM xla_aad_line_defn_assgns

335: p_module => l_log_module,
336: p_level => C_LEVEL_STATEMENT);
337: END IF;
338:
339: DELETE FROM xla_aad_line_defn_assgns
340: WHERE application_id = p_application_id
341: AND amb_context_code = p_amb_context_code;
342:
343: -- Bug : 16208537

Line 350: p_encoded_message => '# delete (xla_aad_line_defn_assgns) = '||SQL%ROWCOUNT,

346: p_amb_context_code => p_amb_context_code,
347: p_application_id => p_application_id,
348: p_request_code => 'IMPORT' ,
349: p_log_type_code => 'MERGE',
350: p_encoded_message => '# delete (xla_aad_line_defn_assgns) = '||SQL%ROWCOUNT,
351: p_component_code => 'purge');
352:
353: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
354: trace(p_msg => '# record deleted from xla_aad_line_defn_assgns = '||SQL%ROWCOUNT,

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

350: p_encoded_message => '# delete (xla_aad_line_defn_assgns) = '||SQL%ROWCOUNT,
351: p_component_code => 'purge');
352:
353: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
354: trace(p_msg => '# record deleted from xla_aad_line_defn_assgns = '||SQL%ROWCOUNT,
355: p_module => l_log_module,
356: p_level => C_LEVEL_STATEMENT);
357: END IF;
358:

Line 870: FROM xla_aad_line_defn_assgns

866: FOR UPDATE NOWAIT;
867:
868: CURSOR c_aad_line_defn_assgns IS
869: SELECT *
870: FROM xla_aad_line_defn_assgns
871: WHERE application_id = p_application_id
872: AND amb_context_code = p_amb_context_code
873: FOR UPDATE NOWAIT;
874:

Line 3301: DELETE FROM xla_aad_line_defn_assgns

3297: p_module => l_log_module,
3298: p_level => C_LEVEL_PROCEDURE);
3299: END IF;
3300:
3301: DELETE FROM xla_aad_line_defn_assgns
3302: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3303: AND application_id = p_application_id;
3304:
3305: -- Bug 16208537

Line 3316: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||SQL%ROWCOUNT,

3312: p_encoded_message => '# delete (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,
3313: p_component_code => 'purge_aad');
3314:
3315: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3316: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||SQL%ROWCOUNT,
3317: p_module => l_log_module,
3318: p_level => C_LEVEL_PROCEDURE);
3319: END IF;
3320: