APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AAD_HEADER_AC_ASSGNS

Line 289: DELETE FROM xla_aad_header_ac_assgns

285: p_module => l_log_module,
286: p_level => C_LEVEL_STATEMENT);
287: END IF;
288:
289: DELETE FROM xla_aad_header_ac_assgns
290: WHERE application_id = p_application_id
291: AND amb_context_code = p_amb_context_code;
292:
293: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

290: WHERE application_id = p_application_id
291: AND amb_context_code = p_amb_context_code;
292:
293: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
294: trace(p_msg => '# record deleted from xla_aad_header_ac_assgns = '||SQL%ROWCOUNT,
295: p_module => l_log_module,
296: p_level => C_LEVEL_STATEMENT);
297: END IF;
298:

Line 585: FROM xla_aad_header_ac_assgns

581: FOR UPDATE NOWAIT;
582:
583: CURSOR c_aad_header_ac_assgns IS
584: SELECT *
585: FROM xla_aad_header_ac_assgns
586: WHERE application_id = p_application_id
587: AND amb_context_code = p_amb_context_code
588: FOR UPDATE NOWAIT;
589:

Line 770: FROM xla_aad_header_ac_assgns xah

766: AND t.analytical_criterion_code = b.analytical_criterion_code
767: AND t.amb_context_code = b.amb_context_code
768: AND b.amb_context_code = p_amb_context_code
769: AND EXISTS (SELECT 1
770: FROM xla_aad_header_ac_assgns xah
771: WHERE xah.analytical_criterion_type_code = b.analytical_criterion_type_code
772: AND xah.analytical_criterion_code = b.analytical_criterion_code
773: AND xah.amb_context_code = b.amb_context_code
774: AND xah.application_id = p_application_id

Line 811: FROM xla_aad_header_ac_assgns xah

807: AND t.analytical_criterion_code = b.analytical_criterion_code
808: AND t.amb_context_code = b.amb_context_code
809: AND b.amb_context_code = p_amb_context_code
810: AND EXISTS (SELECT 1
811: FROM xla_aad_header_ac_assgns xah
812: WHERE xah.analytical_criterion_type_code = b.analytical_criterion_type_code
813: AND xah.analytical_criterion_code = b.analytical_criterion_code
814: AND xah.amb_context_code = b.amb_context_code
815: AND xah.application_id = p_application_id

Line 848: FROM xla_aad_header_ac_assgns xah

844: SELECT *
845: FROM xla_analytical_sources b
846: WHERE b.amb_context_code = p_amb_context_code
847: AND EXISTS (SELECT 1
848: FROM xla_aad_header_ac_assgns xah
849: WHERE xah.analytical_criterion_type_code = b.analytical_criterion_type_code
850: AND xah.analytical_criterion_code = b.analytical_criterion_code
851: AND xah.amb_context_code = b.amb_context_code
852: AND xah.application_id = p_application_id

Line 2532: DELETE FROM xla_aad_header_ac_assgns

2528: p_module => l_log_module,
2529: p_level => C_LEVEL_PROCEDURE);
2530: END IF;
2531:
2532: DELETE FROM xla_aad_header_ac_assgns
2533: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2534: AND application_id = p_application_id;
2535:
2536: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2537: trace(p_msg => '# xla_aad_header_ac_assgns deleted = '||SQL%ROWCOUNT,

2533: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2534: AND application_id = p_application_id;
2535:
2536: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2537: trace(p_msg => '# xla_aad_header_ac_assgns deleted = '||SQL%ROWCOUNT,
2538: p_module => l_log_module,
2539: p_level => C_LEVEL_PROCEDURE);
2540: END IF;
2541: