APPS.XLA_AAD_MERGE_PVT dependencies on XLA_MPA_HEADER_AC_ASSGNS

Line 676: DELETE FROM xla_mpa_header_ac_assgns w

672: p_module => l_log_module,
673: p_level => C_LEVEL_STATEMENT);
674: END IF;
675:
676: DELETE FROM xla_mpa_header_ac_assgns w
677: WHERE application_id = g_application_id
678: AND amb_context_code = g_amb_context_code
679: AND line_definition_owner_code = C_OWNER_SYSTEM
680: AND NOT EXISTS

Line 682: FROM xla_mpa_header_ac_assgns s

678: AND amb_context_code = g_amb_context_code
679: AND line_definition_owner_code = C_OWNER_SYSTEM
680: AND NOT EXISTS
681: (SELECT 1
682: FROM xla_mpa_header_ac_assgns s
683: WHERE s.application_id = g_application_id
684: AND s.amb_context_code = g_staging_context_code
685: AND s.event_class_code = w.event_class_code
686: AND s.event_type_code = w.event_type_code

Line 695: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||SQL%ROWCOUNT,

691: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
692: AND s.analytical_criterion_code = w.analytical_criterion_code);
693:
694: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
695: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||SQL%ROWCOUNT,
696: p_module => l_log_module,
697: p_level => C_LEVEL_STATEMENT);
698: END IF;
699:

Line 874: DELETE FROM xla_mpa_header_ac_assgns w

870: p_level => C_LEVEL_STATEMENT);
871: END IF;
872:
873: FORALL i IN 1..l_codes.COUNT
874: DELETE FROM xla_mpa_header_ac_assgns w
875: WHERE application_id = g_application_id
876: AND amb_context_code = g_amb_context_code
877: AND event_class_code = l_event_class_codes(i)
878: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 882: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||SQL%ROWCOUNT,

878: AND accounting_line_type_code = C_OWNER_SYSTEM
879: AND accounting_line_code = l_codes(i);
880:
881: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
882: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||SQL%ROWCOUNT,
883: p_module => l_log_module,
884: p_level => C_LEVEL_STATEMENT);
885: END IF;
886:

Line 1482: DELETE FROM xla_mpa_header_ac_assgns w

1478: p_level => C_LEVEL_STATEMENT);
1479: END IF;
1480:
1481: FORALL i IN 1..l_codes.COUNT
1482: DELETE FROM xla_mpa_header_ac_assgns w
1483: WHERE amb_context_code = g_amb_context_code
1484: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1485: AND analytical_criterion_code = l_codes(i);
1486:

Line 1488: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||SQL%ROWCOUNT,

1484: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1485: AND analytical_criterion_code = l_codes(i);
1486:
1487: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1488: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||SQL%ROWCOUNT,
1489: p_module => l_log_module,
1490: p_level => C_LEVEL_STATEMENT);
1491: END IF;
1492:

Line 2097: DELETE FROM xla_mpa_header_ac_assgns w

2093: p_module => l_log_module,
2094: p_level => C_LEVEL_STATEMENT);
2095: END IF;
2096:
2097: DELETE FROM xla_mpa_header_ac_assgns w
2098: WHERE application_id = g_application_id
2099: AND amb_context_code = g_amb_context_code
2100: AND EXISTS (
2101: SELECT 1

Line 2102: FROM xla_mpa_header_ac_assgns s

2098: WHERE application_id = g_application_id
2099: AND amb_context_code = g_amb_context_code
2100: AND EXISTS (
2101: SELECT 1
2102: FROM xla_mpa_header_ac_assgns s
2103: WHERE s.application_id = g_application_id
2104: AND s.amb_context_code = g_staging_context_code
2105: AND s.event_class_code = w.event_class_code
2106: AND s.event_type_code = w.event_type_code

Line 2124: trace(p_msg => '# xla_mpa_header_ac_assgns deleted : '||SQL%ROWCOUNT,

2120: AND s.accounting_line_code = w.accounting_line_code
2121: AND s.mpa_option_code = 'NONE');
2122:
2123: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2124: trace(p_msg => '# xla_mpa_header_ac_assgns deleted : '||SQL%ROWCOUNT,
2125: p_module => l_log_module,
2126: p_level => C_LEVEL_STATEMENT);
2127: END IF;
2128:

Line 2296: UPDATE xla_mpa_header_ac_assgns

2292: p_module => l_log_module,
2293: p_level => C_LEVEL_STATEMENT);
2294: END IF;
2295:
2296: UPDATE xla_mpa_header_ac_assgns
2297: SET amb_context_code = g_amb_context_code
2298: WHERE application_id = g_application_id
2299: AND amb_context_code = g_staging_context_code;
2300:

Line 2302: trace(p_msg => '# xla_mpa_header_ac_assgns updated : '||SQL%ROWCOUNT,

2298: WHERE application_id = g_application_id
2299: AND amb_context_code = g_staging_context_code;
2300:
2301: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2302: trace(p_msg => '# xla_mpa_header_ac_assgns updated : '||SQL%ROWCOUNT,
2303: p_module => l_log_module,
2304: p_level => C_LEVEL_STATEMENT);
2305: END IF;
2306: