DBA Data[Home] [Help]

APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_AAD_HEADER_AC_ASSGNS

Line 794: FROM xla_aad_header_ac_assgns a

790: ,a.analytical_criterion_type_code
791: ,a.analytical_criterion_code
792: ,ac.version_from
793: ,ac.version_to
794: FROM xla_aad_header_ac_assgns a
795: ,TABLE(CAST(l_analytical_criteria AS xla_component_tbl_type)) ac
796: WHERE a.amb_context_code = g_amb_context_code
797: AND a.application_id <> g_application_id
798: AND a.analytical_criterion_type_code = ac.component_owner_code

Line 1709: UPDATE xla_aad_header_ac_assgns

1705: p_module => l_log_module,
1706: p_level => C_LEVEL_STATEMENT);
1707: END IF;
1708:
1709: UPDATE xla_aad_header_ac_assgns
1710: SET amb_context_code = g_amb_context_code
1711: WHERE amb_context_code = g_staging_context_code;
1712:
1713: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1714: trace(p_msg => '# row moved in xla_aad_header_ac_assgns = '||SQL%ROWCOUNT,

1710: SET amb_context_code = g_amb_context_code
1711: WHERE amb_context_code = g_staging_context_code;
1712:
1713: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1714: trace(p_msg => '# row moved in xla_aad_header_ac_assgns = '||SQL%ROWCOUNT,
1715: p_module => l_log_module,
1716: p_level => C_LEVEL_STATEMENT);
1717: END IF;
1718: