APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_MPA_JLT_AC_ASSGNS

Line 319: DELETE FROM xla_mpa_jlt_ac_assgns

315: p_module => l_log_module,
316: p_level => C_LEVEL_STATEMENT);
317: END IF;
318:
319: DELETE FROM xla_mpa_jlt_ac_assgns
320: WHERE application_id = p_application_id
321: AND amb_context_code = p_amb_context_code;
322:
323: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

320: WHERE application_id = p_application_id
321: AND amb_context_code = p_amb_context_code;
322:
323: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
324: trace(p_msg => '# record deleted from xla_mpa_jlt_ac_assgns = '||SQL%ROWCOUNT,
325: p_module => l_log_module,
326: p_level => C_LEVEL_STATEMENT);
327: END IF;
328:

Line 599: FROM xla_mpa_jlt_ac_assgns

595: FOR UPDATE NOWAIT;
596:
597: CURSOR c_mpa_jlt_ac_assgns IS
598: SELECT *
599: FROM xla_mpa_jlt_ac_assgns
600: WHERE application_id = p_application_id
601: AND amb_context_code = p_amb_context_code
602: FOR UPDATE NOWAIT;
603:

Line 794: FROM xla_mpa_jlt_ac_assgns xld

790: AND xld.application_id = p_application_id
791: AND xld.amb_context_code = p_amb_context_code
792: UNION
793: SELECT 1
794: FROM xla_mpa_jlt_ac_assgns xld
795: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
796: AND xld.analytical_criterion_code = b.analytical_criterion_code
797: AND xld.amb_context_code = b.amb_context_code
798: AND xld.application_id = p_application_id

Line 835: FROM xla_mpa_jlt_ac_assgns xld

831: AND xld.application_id = p_application_id
832: AND xld.amb_context_code = p_amb_context_code
833: UNION
834: SELECT 1
835: FROM xla_mpa_jlt_ac_assgns xld
836: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
837: AND xld.analytical_criterion_code = b.analytical_criterion_code
838: AND xld.amb_context_code = b.amb_context_code
839: AND xld.application_id = p_application_id

Line 872: FROM xla_mpa_jlt_ac_assgns xld

868: AND xld.application_id = p_application_id
869: AND xld.amb_context_code = p_amb_context_code
870: UNION
871: SELECT 1
872: FROM xla_mpa_jlt_ac_assgns xld
873: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
874: AND xld.analytical_criterion_code = b.analytical_criterion_code
875: AND xld.amb_context_code = b.amb_context_code
876: AND xld.application_id = p_application_id

Line 2562: DELETE FROM xla_mpa_jlt_ac_assgns

2558: p_module => l_log_module,
2559: p_level => C_LEVEL_PROCEDURE);
2560: END IF;
2561:
2562: DELETE FROM xla_mpa_jlt_ac_assgns
2563: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2564: AND application_id = p_application_id;
2565:
2566: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2567: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted = '||SQL%ROWCOUNT,

2563: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2564: AND application_id = p_application_id;
2565:
2566: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2567: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted = '||SQL%ROWCOUNT,
2568: p_module => l_log_module,
2569: p_level => C_LEVEL_PROCEDURE);
2570: END IF;
2571: