APPS.XLA_AAD_EXPORT_PVT dependencies on XLA_MAPPING_SETS_B

Line 283: ,xla_mapping_sets_b b

279: -- (h.version_num = b.version_num and leapfrog_flag = 'Y')
280: CURSOR c_ms IS
281: SELECT distinct t.name
282: FROM xla_amb_components_h h
283: ,xla_mapping_sets_b b
284: ,xla_mapping_sets_tl t
285: WHERE t.amb_context_code = b.amb_context_code
286: AND t.mapping_set_code = b.mapping_set_code
287: AND t.language = USERENV('LANG')

Line 515: ,xla_mapping_sets_b b

511: -- (h.version_num = b.version_num and leapfrog_flag = 'Y')
512: CURSOR c_ms IS
513: SELECT 1
514: FROM xla_amb_components_h h
515: ,xla_mapping_sets_b b
516: WHERE h.component_type_code = 'MAPPING_SET'
517: AND h.component_code = b.mapping_set_code
518: AND ((h.version_num > b.version_num AND
519: h.leapfrog_flag = 'N') OR

Line 2006: FROM xla_mapping_sets_b b

2002: CURSOR c_ms IS
2003: SELECT b.mapping_set_code
2004: ,b.version_num version_from
2005: ,MAX(NVL(h.version_num,0))+1 version_to
2006: FROM xla_mapping_sets_b b
2007: ,xla_amb_components_h h
2008: WHERE h.component_code(+) = b.mapping_set_code
2009: AND h.component_type_code(+) = 'MAPPING_SET'
2010: AND b.updated_flag = 'Y'

Line 2106: UPDATE xla_mapping_sets_b

2102: p_level => C_LEVEL_STATEMENT);
2103: END IF;
2104:
2105: FORALL i IN 1 .. l_ms_codes.COUNT
2106: UPDATE xla_mapping_sets_b
2107: SET version_num = l_ms_version_to(i)
2108: ,updated_flag = 'N'
2109: ,creation_date = sysdate
2110: ,created_by = xla_environment_pkg.g_usr_id

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

2114: WHERE mapping_set_code = l_ms_codes(i)
2115: AND amb_context_code = p_amb_context_code;
2116:
2117: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2118: trace(p_msg => '# row updated in xla_mapping_sets_b = '||SQL%ROWCOUNT,
2119: p_module => l_log_module,
2120: p_level => C_LEVEL_STATEMENT);
2121: END IF;
2122: