APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_LINE_DEFN_AC_ASSGNS

Line 229: DELETE FROM xla_line_defn_ac_assgns

225:
226: --
227: -- Delete application accounting definition assignments
228: --
229: DELETE FROM xla_line_defn_ac_assgns
230: WHERE application_id = p_application_id
231: AND amb_context_code = p_amb_context_code;
232:
233: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

230: WHERE application_id = p_application_id
231: AND amb_context_code = p_amb_context_code;
232:
233: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
234: trace(p_msg => '# record deleted from xla_line_defn_ac_assgns = '||SQL%ROWCOUNT,
235: p_module => l_log_module,
236: p_level => C_LEVEL_STATEMENT);
237: END IF;
238:

Line 655: FROM xla_line_defn_ac_assgns

651: FOR UPDATE NOWAIT;
652:
653: CURSOR c_line_defn_ac_assgns IS
654: SELECT *
655: FROM xla_line_defn_ac_assgns
656: WHERE application_id = p_application_id
657: AND amb_context_code = p_amb_context_code
658: FOR UPDATE NOWAIT;
659:

Line 778: FROM xla_line_defn_ac_assgns xld

774: AND xah.application_id = p_application_id
775: AND xah.amb_context_code = p_amb_context_code
776: UNION
777: SELECT 1
778: FROM xla_line_defn_ac_assgns xld
779: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
780: AND xld.analytical_criterion_code = b.analytical_criterion_code
781: AND xld.amb_context_code = b.amb_context_code
782: AND xld.application_id = p_application_id

Line 819: FROM xla_line_defn_ac_assgns xld

815: AND xah.application_id = p_application_id
816: AND xah.amb_context_code = p_amb_context_code
817: UNION
818: SELECT 1
819: FROM xla_line_defn_ac_assgns xld
820: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
821: AND xld.analytical_criterion_code = b.analytical_criterion_code
822: AND xld.amb_context_code = b.amb_context_code
823: AND xld.application_id = p_application_id

Line 856: FROM xla_line_defn_ac_assgns xld

852: AND xah.application_id = p_application_id
853: AND xah.amb_context_code = p_amb_context_code
854: UNION
855: SELECT 1
856: FROM xla_line_defn_ac_assgns xld
857: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
858: AND xld.analytical_criterion_code = b.analytical_criterion_code
859: AND xld.amb_context_code = b.amb_context_code
860: AND xld.application_id = p_application_id

Line 2602: DELETE FROM xla_line_defn_ac_assgns

2598: p_module => l_log_module,
2599: p_level => C_LEVEL_PROCEDURE);
2600: END IF;
2601:
2602: DELETE FROM xla_line_defn_ac_assgns
2603: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2604: AND application_id = p_application_id;
2605:
2606: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2607: trace(p_msg => '# xla_line_defn_ac_assgns deleted = '||SQL%ROWCOUNT,

2603: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2604: AND application_id = p_application_id;
2605:
2606: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2607: trace(p_msg => '# xla_line_defn_ac_assgns deleted = '||SQL%ROWCOUNT,
2608: p_module => l_log_module,
2609: p_level => C_LEVEL_PROCEDURE);
2610: END IF;
2611: