APPS.XLA_AAD_MERGE_PVT dependencies on XLA_AAD_HEADER_AC_ASSGNS

Line 399: DELETE FROM xla_aad_header_ac_assgns w

395: p_level => C_LEVEL_STATEMENT);
396: END IF;
397:
398: -- Delete AC assignment that is no longer assigned to the header
399: DELETE FROM xla_aad_header_ac_assgns w
400: WHERE application_id = g_application_id
401: AND amb_context_code = g_amb_context_code
402: AND product_rule_type_code = C_OWNER_SYSTEM
403: AND NOT EXISTS

Line 405: FROM xla_aad_header_ac_assgns s

401: AND amb_context_code = g_amb_context_code
402: AND product_rule_type_code = C_OWNER_SYSTEM
403: AND NOT EXISTS
404: (SELECT 1
405: FROM xla_aad_header_ac_assgns s
406: WHERE s.application_id = g_application_id
407: AND s.amb_context_code = g_staging_context_code
408: AND s.product_rule_type_code = C_OWNER_SYSTEM
409: AND s.product_rule_code = w.product_rule_code

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

412: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
413: AND s.analytical_criterion_code = w.analytical_criterion_code);
414:
415: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
416: trace(p_msg => '# xla_aad_header_ac_assgns deleted = '||SQL%ROWCOUNT,
417: p_module => l_log_module,
418: p_level => C_LEVEL_STATEMENT);
419: END IF;
420:

Line 1457: DELETE FROM xla_aad_header_ac_assgns w

1453: END IF;
1454:
1455: -- Delete reference to the AC
1456: FORALL i IN 1..l_codes.COUNT
1457: DELETE FROM xla_aad_header_ac_assgns w
1458: WHERE application_id = g_application_id
1459: AND amb_context_code = g_amb_context_code
1460: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1461: AND analytical_criterion_code = l_codes(i);

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

1460: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1461: AND analytical_criterion_code = l_codes(i);
1462:
1463: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1464: trace(p_msg => '# xla_aad_header_ac_assgns deleted = '||SQL%ROWCOUNT,
1465: p_module => l_log_module,
1466: p_level => C_LEVEL_STATEMENT);
1467: END IF;
1468:

Line 1814: DELETE FROM xla_aad_header_ac_assgns w

1810: AND s.event_class_code = w.event_class_code
1811: AND s.event_type_code = w.event_type_code
1812: AND s.accounting_attribute_code = w.accounting_attribute_code);
1813:
1814: DELETE FROM xla_aad_header_ac_assgns w
1815: WHERE application_id = g_application_id
1816: AND amb_context_code = g_amb_context_code
1817: AND EXISTS (SELECT 1
1818: FROM xla_aad_header_ac_assgns s

Line 1818: FROM xla_aad_header_ac_assgns s

1814: DELETE FROM xla_aad_header_ac_assgns w
1815: WHERE application_id = g_application_id
1816: AND amb_context_code = g_amb_context_code
1817: AND EXISTS (SELECT 1
1818: FROM xla_aad_header_ac_assgns s
1819: WHERE s.application_id = g_application_id
1820: AND s.amb_context_code = g_staging_context_code
1821: AND s.event_class_code = w.event_class_code
1822: AND s.event_type_code = w.event_type_code

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

1825: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
1826: AND s.analytical_criterion_code = w.analytical_criterion_code);
1827:
1828: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1829: trace(p_msg => '# xla_aad_header_ac_assgns deleted : '||SQL%ROWCOUNT,
1830: p_module => l_log_module,
1831: p_level => C_LEVEL_STATEMENT);
1832: END IF;
1833:

Line 1918: UPDATE xla_aad_header_ac_assgns

1914: p_module => l_log_module,
1915: p_level => C_LEVEL_STATEMENT);
1916: END IF;
1917:
1918: UPDATE xla_aad_header_ac_assgns
1919: SET amb_context_code = g_amb_context_code
1920: WHERE application_id = g_application_id
1921: AND amb_context_code = g_staging_context_code;
1922:

Line 1924: trace(p_msg => '# xla_aad_header_ac_assgns updated : '||SQL%ROWCOUNT,

1920: WHERE application_id = g_application_id
1921: AND amb_context_code = g_staging_context_code;
1922:
1923: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1924: trace(p_msg => '# xla_aad_header_ac_assgns updated : '||SQL%ROWCOUNT,
1925: p_module => l_log_module,
1926: p_level => C_LEVEL_STATEMENT);
1927: END IF;
1928: