APPS.XLA_AAD_MERGE_PVT dependencies on XLA_AAD_HDR_ACCT_ATTRS

Line 421: DELETE FROM xla_aad_hdr_acct_attrs w

417: p_module => l_log_module,
418: p_level => C_LEVEL_STATEMENT);
419: END IF;
420:
421: DELETE FROM xla_aad_hdr_acct_attrs w
422: WHERE application_id = g_application_id
423: AND amb_context_code = g_amb_context_code
424: AND product_rule_type_code = C_OWNER_SYSTEM
425: AND NOT EXISTS

Line 427: FROM xla_aad_hdr_acct_attrs s

423: AND amb_context_code = g_amb_context_code
424: AND product_rule_type_code = C_OWNER_SYSTEM
425: AND NOT EXISTS
426: (SELECT 1
427: FROM xla_aad_hdr_acct_attrs s
428: WHERE s.application_id = g_application_id
429: AND s.amb_context_code = g_staging_context_code
430: AND s.product_rule_type_code = C_OWNER_SYSTEM
431: AND s.product_rule_code = w.product_rule_code

Line 437: trace(p_msg => '# xla_aad_hdr_acct_attrs deleted = '||SQL%ROWCOUNT,

433: AND s.event_type_code = w.event_type_code
434: AND s.accounting_attribute_code = w.accounting_attribute_code);
435:
436: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
437: trace(p_msg => '# xla_aad_hdr_acct_attrs deleted = '||SQL%ROWCOUNT,
438: p_module => l_log_module,
439: p_level => C_LEVEL_STATEMENT);
440: END IF;
441:

Line 1801: DELETE FROM xla_aad_hdr_acct_attrs w

1797: p_module => l_log_module,
1798: p_level => C_LEVEL_STATEMENT);
1799: END IF;
1800:
1801: DELETE FROM xla_aad_hdr_acct_attrs w
1802: WHERE application_id = g_application_id
1803: AND amb_context_code = g_amb_context_code
1804: AND EXISTS (SELECT 1
1805: FROM xla_aad_hdr_acct_attrs s

Line 1805: FROM xla_aad_hdr_acct_attrs s

1801: DELETE FROM xla_aad_hdr_acct_attrs w
1802: WHERE application_id = g_application_id
1803: AND amb_context_code = g_amb_context_code
1804: AND EXISTS (SELECT 1
1805: FROM xla_aad_hdr_acct_attrs s
1806: WHERE s.application_id = g_application_id
1807: AND s.amb_context_code = g_staging_context_code
1808: AND s.product_rule_type_code = w.product_rule_type_code
1809: AND s.product_rule_code = w.product_rule_code

Line 1907: UPDATE xla_aad_hdr_acct_attrs

1903: p_module => l_log_module,
1904: p_level => C_LEVEL_STATEMENT);
1905: END IF;
1906:
1907: UPDATE xla_aad_hdr_acct_attrs
1908: SET amb_context_code = g_amb_context_code
1909: WHERE application_id = g_application_id
1910: AND amb_context_code = g_staging_context_code;
1911:

Line 1913: trace(p_msg => '# xla_aad_hdr_acct_attrs updated : '||SQL%ROWCOUNT,

1909: WHERE application_id = g_application_id
1910: AND amb_context_code = g_staging_context_code;
1911:
1912: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1913: trace(p_msg => '# xla_aad_hdr_acct_attrs updated : '||SQL%ROWCOUNT,
1914: p_module => l_log_module,
1915: p_level => C_LEVEL_STATEMENT);
1916: END IF;
1917: