APPS.XLA_AAD_EXPORT_PVT dependencies on XLA_ANALYTICAL_HDRS_B

Line 238: ,xla_analytical_hdrs_b b

234: /*
235: CURSOR c_ac IS
236: SELECT distinct t.name
237: FROM xla_amb_components_h h
238: ,xla_analytical_hdrs_b b
239: ,xla_analytical_hdrs_tl t
240: WHERE t.amb_context_code = b.amb_context_code
241: AND t.analytical_criterion_type_code = b.analytical_criterion_type_code
242: AND t.analytical_criterion_code = b.analytical_criterion_code

Line 1667: FROM xla_analytical_hdrs_b b

1663: SELECT b.analytical_criterion_type_code
1664: ,b.analytical_criterion_code
1665: ,b.version_num version_from
1666: ,MAX(NVL(h.version_num,0))+1 version_to
1667: FROM xla_analytical_hdrs_b b
1668: ,xla_amb_components_h h
1669: WHERE h.component_owner_code(+) = b.analytical_criterion_type_code
1670: AND h.component_code(+) = b.analytical_criterion_code
1671: AND h.component_type_code(+) = 'ANALYTICAL_CRITERION'

Line 1787: UPDATE xla_analytical_hdrs_b

1783: p_level => C_LEVEL_STATEMENT);
1784: END IF;
1785:
1786: FORALL i IN 1 .. l_ac_codes.COUNT
1787: UPDATE xla_analytical_hdrs_b
1788: SET version_num = l_ac_version_to(i)
1789: ,updated_flag = 'N'
1790: ,creation_date = sysdate
1791: ,created_by = xla_environment_pkg.g_usr_id

Line 1800: trace(p_msg => '# row updated in xla_analytical_hdrs_b = '||SQL%ROWCOUNT,

1796: AND analytical_criterion_code = l_ac_codes(i)
1797: AND amb_context_code = p_amb_context_code;
1798:
1799: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1800: trace(p_msg => '# row updated in xla_analytical_hdrs_b = '||SQL%ROWCOUNT,
1801: p_module => l_log_module,
1802: p_level => C_LEVEL_STATEMENT);
1803: END IF;
1804: