APPS.XLA_AAD_MERGE_PVT dependencies on XLA_AAD_LINE_DEFN_ASSGNS

Line 376: DELETE FROM xla_aad_line_defn_assgns w

372: ,xla_environment_pkg.g_prog_id
373: ,xla_environment_pkg.g_req_Id);
374:
375: -- Delete JLD aasignment that is no longer assigned to the header
376: DELETE FROM xla_aad_line_defn_assgns w
377: WHERE application_id = g_application_id
378: AND amb_context_code = g_amb_context_code
379: AND product_rule_type_code = C_OWNER_SYSTEM
380: AND NOT EXISTS

Line 382: FROM xla_aad_line_defn_assgns s

378: AND amb_context_code = g_amb_context_code
379: AND product_rule_type_code = C_OWNER_SYSTEM
380: AND NOT EXISTS
381: (SELECT 1
382: FROM xla_aad_line_defn_assgns s
383: WHERE s.application_id = g_application_id
384: AND s.amb_context_code = g_staging_context_code
385: AND s.product_rule_type_code = C_OWNER_SYSTEM
386: AND s.product_rule_code = w.product_rule_code

Line 393: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||SQL%ROWCOUNT,

389: AND s.line_definition_owner_code = w.line_definition_owner_code
390: AND s.line_definition_code = w.line_definition_code);
391:
392: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
393: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||SQL%ROWCOUNT,
394: p_module => l_log_module,
395: p_level => C_LEVEL_STATEMENT);
396: END IF;
397:

Line 569: DELETE FROM xla_aad_line_defn_assgns w

565: END IF;
566:
567: -- Delete JLD assignment for those JLD no longer exist
568: FORALL i IN 1..l_codes.COUNT
569: DELETE FROM xla_aad_line_defn_assgns w
570: WHERE application_id = g_application_id
571: AND amb_context_code = g_amb_context_code
572: AND event_class_code = l_event_class_codes(i)
573: AND event_type_code = l_event_type_codes(i)

Line 578: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||SQL%ROWCOUNT,

574: AND line_definition_owner_code = C_OWNER_SYSTEM
575: AND line_definition_code = l_codes(i);
576:
577: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
578: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||SQL%ROWCOUNT,
579: p_module => l_log_module,
580: p_level => C_LEVEL_STATEMENT);
581: END IF;
582:

Line 1781: DELETE FROM xla_aad_line_defn_assgns w

1777: p_module => l_log_module,
1778: p_level => C_LEVEL_STATEMENT);
1779: END IF;
1780:
1781: DELETE FROM xla_aad_line_defn_assgns w
1782: WHERE application_id = g_application_id
1783: AND amb_context_code = g_amb_context_code
1784: AND EXISTS (SELECT 1
1785: FROM xla_aad_line_defn_assgns s

Line 1785: FROM xla_aad_line_defn_assgns s

1781: DELETE FROM xla_aad_line_defn_assgns w
1782: WHERE application_id = g_application_id
1783: AND amb_context_code = g_amb_context_code
1784: AND EXISTS (SELECT 1
1785: FROM xla_aad_line_defn_assgns s
1786: WHERE s.application_id = g_application_id
1787: AND s.amb_context_code = g_staging_context_code
1788: AND s.product_rule_type_code = w.product_rule_type_code
1789: AND s.product_rule_code = w.product_rule_code

Line 1796: trace(p_msg => '# xla_aad_line_defn_assgns deleted : '||SQL%ROWCOUNT,

1792: AND s.line_definition_owner_code = w.line_definition_owner_code
1793: AND s.line_definition_code = w.line_definition_code);
1794:
1795: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1796: trace(p_msg => '# xla_aad_line_defn_assgns deleted : '||SQL%ROWCOUNT,
1797: p_module => l_log_module,
1798: p_level => C_LEVEL_STATEMENT);
1799: END IF;
1800:

Line 1896: UPDATE xla_aad_line_defn_assgns

1892: p_module => l_log_module,
1893: p_level => C_LEVEL_STATEMENT);
1894: END IF;
1895:
1896: UPDATE xla_aad_line_defn_assgns
1897: SET amb_context_code = g_amb_context_code
1898: WHERE application_id = g_application_id
1899: AND amb_context_code = g_staging_context_code;
1900:

Line 1902: trace(p_msg => '# xla_aad_line_defn_assgns updated : '||SQL%ROWCOUNT,

1898: WHERE application_id = g_application_id
1899: AND amb_context_code = g_staging_context_code;
1900:
1901: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1902: trace(p_msg => '# xla_aad_line_defn_assgns updated : '||SQL%ROWCOUNT,
1903: p_module => l_log_module,
1904: p_level => C_LEVEL_STATEMENT);
1905: END IF;
1906: