APPS.XLA_AAD_MERGE_PVT dependencies on XLA_MPA_JLT_ASSGNS

Line 652: DELETE FROM xla_mpa_jlt_assgns w

648: p_module => l_log_module,
649: p_level => C_LEVEL_STATEMENT);
650: END IF;
651:
652: DELETE FROM xla_mpa_jlt_assgns w
653: WHERE application_id = g_application_id
654: AND amb_context_code = g_amb_context_code
655: AND line_definition_owner_code = C_OWNER_SYSTEM
656: AND NOT EXISTS

Line 658: FROM xla_mpa_jlt_assgns s

654: AND amb_context_code = g_amb_context_code
655: AND line_definition_owner_code = C_OWNER_SYSTEM
656: AND NOT EXISTS
657: (SELECT 1
658: FROM xla_mpa_jlt_assgns s
659: WHERE s.application_id = g_application_id
660: AND s.amb_context_code = g_staging_context_code
661: AND s.event_class_code = w.event_class_code
662: AND s.event_type_code = w.event_type_code

Line 671: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||SQL%ROWCOUNT,

667: AND s.mpa_accounting_line_type_code = w.mpa_accounting_line_type_code
668: AND s.mpa_accounting_line_code = w.mpa_accounting_line_code);
669:
670: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
671: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||SQL%ROWCOUNT,
672: p_module => l_log_module,
673: p_level => C_LEVEL_STATEMENT);
674: END IF;
675:

Line 888: DELETE FROM xla_mpa_jlt_assgns w

884: p_level => C_LEVEL_STATEMENT);
885: END IF;
886:
887: FORALL i IN 1..l_codes.COUNT
888: DELETE FROM xla_mpa_jlt_assgns w
889: WHERE application_id = g_application_id
890: AND amb_context_code = g_amb_context_code
891: AND event_class_code = l_event_class_codes(i)
892: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 896: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||SQL%ROWCOUNT,

892: AND accounting_line_type_code = C_OWNER_SYSTEM
893: AND accounting_line_code = l_codes(i);
894:
895: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
896: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||SQL%ROWCOUNT,
897: p_module => l_log_module,
898: p_level => C_LEVEL_STATEMENT);
899: END IF;
900:

Line 2078: DELETE FROM xla_mpa_jlt_assgns w

2074: p_module => l_log_module,
2075: p_level => C_LEVEL_STATEMENT);
2076: END IF;
2077:
2078: DELETE FROM xla_mpa_jlt_assgns w
2079: WHERE application_id = g_application_id
2080: AND amb_context_code = g_amb_context_code
2081: AND EXISTS (
2082: SELECT 1

Line 2092: trace(p_msg => '# xla_mpa_jlt_assgns deleted : '||SQL%ROWCOUNT,

2088: AND xal.accounting_line_code = w.accounting_line_code
2089: AND xal.mpa_option_code = 'ACCRUAL');
2090:
2091: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2092: trace(p_msg => '# xla_mpa_jlt_assgns deleted : '||SQL%ROWCOUNT,
2093: p_module => l_log_module,
2094: p_level => C_LEVEL_STATEMENT);
2095: END IF;
2096:

Line 2136: FROM xla_mpa_jlt_assgns s

2132: WHERE application_id = g_application_id
2133: AND amb_context_code = g_amb_context_code
2134: AND EXISTS (
2135: SELECT 1
2136: FROM xla_mpa_jlt_assgns s
2137: WHERE s.application_id = g_application_id
2138: AND s.amb_context_code = g_staging_context_code
2139: AND s.event_class_code = w.event_class_code
2140: AND s.event_type_code = w.event_type_code

Line 2285: UPDATE xla_mpa_jlt_assgns

2281: p_module => l_log_module,
2282: p_level => C_LEVEL_STATEMENT);
2283: END IF;
2284:
2285: UPDATE xla_mpa_jlt_assgns
2286: SET amb_context_code = g_amb_context_code
2287: WHERE application_id = g_application_id
2288: AND amb_context_code = g_staging_context_code;
2289:

Line 2291: trace(p_msg => '# xla_mpa_jlt_assgns updated : '||SQL%ROWCOUNT,

2287: WHERE application_id = g_application_id
2288: AND amb_context_code = g_staging_context_code;
2289:
2290: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2291: trace(p_msg => '# xla_mpa_jlt_assgns updated : '||SQL%ROWCOUNT,
2292: p_module => l_log_module,
2293: p_level => C_LEVEL_STATEMENT);
2294: END IF;
2295: