APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_MPA_JLT_ASSGNS

Line 329: DELETE FROM xla_mpa_jlt_assgns

325: p_module => l_log_module,
326: p_level => C_LEVEL_STATEMENT);
327: END IF;
328:
329: DELETE FROM xla_mpa_jlt_assgns
330: WHERE application_id = p_application_id
331: AND amb_context_code = p_amb_context_code;
332:
333: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

330: WHERE application_id = p_application_id
331: AND amb_context_code = p_amb_context_code;
332:
333: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
334: trace(p_msg => '# record deleted from xla_mpa_jlt_assgns = '||SQL%ROWCOUNT,
335: p_module => l_log_module,
336: p_level => C_LEVEL_STATEMENT);
337: END IF;
338:

Line 613: FROM xla_mpa_jlt_assgns

609: FOR UPDATE NOWAIT;
610:
611: CURSOR c_mpa_jlt_assgns IS
612: SELECT *
613: FROM xla_mpa_jlt_assgns
614: WHERE application_id = p_application_id
615: AND amb_context_code = p_amb_context_code
616: FOR UPDATE NOWAIT;
617:

Line 2572: DELETE FROM xla_mpa_jlt_assgns

2568: p_module => l_log_module,
2569: p_level => C_LEVEL_PROCEDURE);
2570: END IF;
2571:
2572: DELETE FROM xla_mpa_jlt_assgns
2573: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2574: AND application_id = p_application_id;
2575:
2576: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2577: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||SQL%ROWCOUNT,

2573: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2574: AND application_id = p_application_id;
2575:
2576: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2577: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||SQL%ROWCOUNT,
2578: p_module => l_log_module,
2579: p_level => C_LEVEL_PROCEDURE);
2580: END IF;
2581: