APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_MPA_JLT_ADR_ASSGNS

Line 399: DELETE FROM xla_mpa_jlt_adr_assgns

395: p_module => l_log_module,
396: p_level => C_LEVEL_STATEMENT);
397: END IF;
398:
399: DELETE FROM xla_mpa_jlt_adr_assgns
400: WHERE application_id = p_application_id
401: AND amb_context_code = p_amb_context_code;
402:
403: -- Bug : 16208537

Line 410: p_encoded_message => '# delete (xla_mpa_jlt_adr_assgns) = '||SQL%ROWCOUNT,

406: p_amb_context_code => p_amb_context_code,
407: p_application_id => p_application_id,
408: p_request_code => 'IMPORT' ,
409: p_log_type_code => 'MERGE',
410: p_encoded_message => '# delete (xla_mpa_jlt_adr_assgns) = '||SQL%ROWCOUNT,
411: p_component_code => 'purge');
412:
413: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
414: trace(p_msg => '# record deleted from xla_mpa_jlt_adr_assgns = '||SQL%ROWCOUNT,

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

410: p_encoded_message => '# delete (xla_mpa_jlt_adr_assgns) = '||SQL%ROWCOUNT,
411: p_component_code => 'purge');
412:
413: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
414: trace(p_msg => '# record deleted from xla_mpa_jlt_adr_assgns = '||SQL%ROWCOUNT,
415: p_module => l_log_module,
416: p_level => C_LEVEL_STATEMENT);
417: END IF;
418:

Line 856: FROM xla_mpa_jlt_adr_assgns

852: FOR UPDATE NOWAIT;
853:
854: CURSOR c_mpa_jlt_adr_assgns IS
855: SELECT *
856: FROM xla_mpa_jlt_adr_assgns
857: WHERE application_id = p_application_id
858: AND amb_context_code = p_amb_context_code
859: FOR UPDATE NOWAIT;
860:

Line 3241: DELETE FROM xla_mpa_jlt_adr_assgns

3237: p_module => l_log_module,
3238: p_level => C_LEVEL_PROCEDURE);
3239: END IF;
3240:
3241: DELETE FROM xla_mpa_jlt_adr_assgns
3242: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3243: AND application_id = p_application_id;
3244:
3245: -- Bug 16208537

Line 3252: p_encoded_message => '# delete (xla_mpa_jlt_adr_assgns) = '||SQL%ROWCOUNT,

3248: p_amb_context_code => p_amb_context_code,
3249: p_application_id => p_application_id,
3250: p_request_code => 'IMPORT' ,
3251: p_log_type_code => 'MERGE',
3252: p_encoded_message => '# delete (xla_mpa_jlt_adr_assgns) = '||SQL%ROWCOUNT,
3253: p_component_code => 'purge_aad');
3254:
3255: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3256: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||SQL%ROWCOUNT,

Line 3256: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||SQL%ROWCOUNT,

3252: p_encoded_message => '# delete (xla_mpa_jlt_adr_assgns) = '||SQL%ROWCOUNT,
3253: p_component_code => 'purge_aad');
3254:
3255: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3256: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||SQL%ROWCOUNT,
3257: p_module => l_log_module,
3258: p_level => C_LEVEL_PROCEDURE);
3259: END IF;
3260: