APPS.XLA_AAD_MERGE_PVT dependencies on XLA_MPA_JLT_ADR_ASSGNS

Line 700: DELETE FROM xla_mpa_jlt_adr_assgns w

696: p_module => l_log_module,
697: p_level => C_LEVEL_STATEMENT);
698: END IF;
699:
700: DELETE FROM xla_mpa_jlt_adr_assgns w
701: WHERE application_id = g_application_id
702: AND amb_context_code = g_amb_context_code
703: AND line_definition_owner_code = C_OWNER_SYSTEM
704: AND NOT EXISTS

Line 706: FROM xla_mpa_jlt_adr_assgns s

702: AND amb_context_code = g_amb_context_code
703: AND line_definition_owner_code = C_OWNER_SYSTEM
704: AND NOT EXISTS
705: (SELECT 1
706: FROM xla_mpa_jlt_adr_assgns s
707: WHERE s.application_id = g_application_id
708: AND s.amb_context_code = g_staging_context_code
709: AND s.event_class_code = w.event_class_code
710: AND s.event_type_code = w.event_type_code

Line 720: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||SQL%ROWCOUNT,

716: AND s.mpa_accounting_line_code = w.mpa_accounting_line_code
717: AND s.flexfield_segment_code = w.flexfield_segment_code);
718:
719: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
720: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||SQL%ROWCOUNT,
721: p_module => l_log_module,
722: p_level => C_LEVEL_STATEMENT);
723: END IF;
724:

Line 846: DELETE FROM xla_mpa_jlt_adr_assgns w

842:
843: IF (l_codes.COUNT > 0) THEN
844:
845: FORALL i IN 1..l_codes.COUNT
846: DELETE FROM xla_mpa_jlt_adr_assgns w
847: WHERE application_id = g_application_id
848: AND amb_context_code = g_amb_context_code
849: AND event_class_code = l_event_class_codes(i)
850: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 854: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||SQL%ROWCOUNT,

850: AND accounting_line_type_code = C_OWNER_SYSTEM
851: AND accounting_line_code = l_codes(i);
852:
853: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
854: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||SQL%ROWCOUNT,
855: p_module => l_log_module,
856: p_level => C_LEVEL_STATEMENT);
857: END IF;
858:

Line 1296: FROM xla_mpa_jlt_adr_assgns

1292: AND segment_rule_type_code = C_OWNER_SYSTEM
1293: AND segment_rule_code = l_codes(i)
1294: UNION
1295: SELECT application_id
1296: FROM xla_mpa_jlt_adr_assgns
1297: WHERE application_id <> g_application_id
1298: AND amb_context_code = g_amb_context_code
1299: AND segment_rule_appl_id = g_application_id
1300: AND segment_rule_type_code = C_OWNER_SYSTEM

Line 1324: DELETE FROM xla_mpa_jlt_adr_assgns w

1320: p_level => C_LEVEL_STATEMENT);
1321: END IF;
1322:
1323: FORALL i IN 1..l_codes.COUNT
1324: DELETE FROM xla_mpa_jlt_adr_assgns w
1325: WHERE amb_context_code = g_amb_context_code
1326: AND segment_rule_appl_id = g_application_id
1327: AND segment_rule_type_code = C_OWNER_SYSTEM
1328: AND segment_rule_code = l_codes(i);

Line 1331: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||SQL%ROWCOUNT,

1327: AND segment_rule_type_code = C_OWNER_SYSTEM
1328: AND segment_rule_code = l_codes(i);
1329:
1330: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1331: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||SQL%ROWCOUNT,
1332: p_module => l_log_module,
1333: p_level => C_LEVEL_STATEMENT);
1334: END IF;
1335:

Line 2131: DELETE FROM xla_mpa_jlt_adr_assgns w

2127: END IF;
2128:
2129: -- ADR assignments are not merged, but overwritten, if the MPA JLT exists in
2130: -- the staging area
2131: DELETE FROM xla_mpa_jlt_adr_assgns w
2132: WHERE application_id = g_application_id
2133: AND amb_context_code = g_amb_context_code
2134: AND EXISTS (
2135: SELECT 1

Line 2158: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted : '||SQL%ROWCOUNT,

2154: AND s.accounting_line_code = w.accounting_line_code
2155: AND s.mpa_option_code = 'NONE');
2156:
2157: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2158: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted : '||SQL%ROWCOUNT,
2159: p_module => l_log_module,
2160: p_level => C_LEVEL_STATEMENT);
2161: END IF;
2162:

Line 2307: UPDATE xla_mpa_jlt_adr_assgns

2303: p_module => l_log_module,
2304: p_level => C_LEVEL_STATEMENT);
2305: END IF;
2306:
2307: UPDATE xla_mpa_jlt_adr_assgns
2308: SET amb_context_code = g_amb_context_code
2309: WHERE application_id = g_application_id
2310: AND amb_context_code = g_staging_context_code;
2311:

Line 2313: trace(p_msg => '# xla_mpa_jlt_adr_assgns updated : '||SQL%ROWCOUNT,

2309: WHERE application_id = g_application_id
2310: AND amb_context_code = g_staging_context_code;
2311:
2312: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2313: trace(p_msg => '# xla_mpa_jlt_adr_assgns updated : '||SQL%ROWCOUNT,
2314: p_module => l_log_module,
2315: p_level => C_LEVEL_STATEMENT);
2316: END IF;
2317: