eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AAD_EXPORT_PVT dependencies on XLA_AMB_COMPONENTS_H

Line 210: FROM xla_amb_components_h h

206: -- Ensure the ADR to be exported is not modified from a leapfrog version
207: -- (h.version_num = b.version_num and leapfrog_flag = 'Y')
208: CURSOR c_adr IS
209: SELECT distinct t.name
210: FROM xla_amb_components_h h
211: ,xla_seg_rules_b b
212: ,xla_seg_rules_tl t
213: WHERE t.amb_context_code = b.amb_context_code
214: AND t.application_id = b.application_id

Line 237: FROM xla_amb_components_h h

233: -- (h.version_num = b.version_num and leapfrog_flag = 'Y')
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

Line 282: FROM xla_amb_components_h h

278: -- Ensure the MS to be exported is not modified from a leapfrog version
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

Line 495: FROM xla_amb_components_h h

491: -- or is modified from a leapfrog version
492: -- (h.version_num = b.version_num and leapfrog_flag = 'Y')
493: CURSOR c_adr IS
494: SELECT 1
495: FROM xla_amb_components_h h
496: ,xla_seg_rules_b b
497: WHERE h.component_type_code = 'AMB_ADR'
498: AND h.application_id = b.application_id
499: AND h.component_owner_code = b.segment_rule_type_code

Line 514: FROM xla_amb_components_h h

510: -- or is modified from a leapfrog version
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

Line 1668: ,xla_amb_components_h h

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'
1672: AND b.updated_flag = 'Y'

Line 1743: INSERT INTO xla_amb_components_h

1739: l_ac_version_to(i) := l_ac.version_to;
1740: END LOOP;
1741:
1742: FORALL i IN 1 .. l_ac_codes.COUNT
1743: INSERT INTO xla_amb_components_h
1744: (component_type_code
1745: ,component_owner_code
1746: ,component_code
1747: ,application_id

Line 1781: trace(p_msg => '# row inserted in xla_amb_components_h = '||SQL%ROWCOUNT,

1777: ,xla_environment_pkg.g_prog_id
1778: ,xla_environment_pkg.g_req_Id);
1779:
1780: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1781: trace(p_msg => '# row inserted in xla_amb_components_h = '||SQL%ROWCOUNT,
1782: p_module => l_log_module,
1783: p_level => C_LEVEL_STATEMENT);
1784: END IF;
1785:

Line 1848: ,xla_amb_components_h h

1844: ,b.segment_rule_code
1845: ,b.version_num version_from
1846: ,MAX(NVL(h.version_num,0))+1 version_to
1847: FROM xla_seg_rules_b b
1848: ,xla_amb_components_h h
1849: WHERE h.application_id(+) = b.application_id
1850: AND h.component_owner_code(+) = b.segment_rule_type_code
1851: AND h.component_code(+) = b.segment_rule_code
1852: AND h.component_type_code(+) = 'AMB_ADR'

Line 1903: INSERT INTO xla_amb_components_h

1899: l_adr_version_to(i) := l_adr.version_to;
1900: END LOOP;
1901:
1902: FORALL i IN 1 .. l_adr_codes.COUNT
1903: INSERT INTO xla_amb_components_h
1904: (application_id
1905: ,component_type_code
1906: ,component_owner_code
1907: ,component_code

Line 1941: trace(p_msg => '# row inserted in xla_amb_components_h = '||SQL%ROWCOUNT,

1937: ,xla_environment_pkg.g_prog_id
1938: ,xla_environment_pkg.g_req_Id);
1939:
1940: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1941: trace(p_msg => '# row inserted in xla_amb_components_h = '||SQL%ROWCOUNT,
1942: p_module => l_log_module,
1943: p_level => C_LEVEL_STATEMENT);
1944: END IF;
1945:

Line 2007: ,xla_amb_components_h h

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'
2011: AND b.amb_context_code = p_amb_context_code

Line 2062: INSERT INTO xla_amb_components_h

2058: p_level => C_LEVEL_EVENT);
2059: END IF;
2060:
2061: FORALL i IN 1 .. l_ms_codes.COUNT
2062: INSERT INTO xla_amb_components_h
2063: (component_type_code
2064: ,component_owner_code
2065: ,component_code
2066: ,application_id

Line 2100: trace(p_msg => '# row inserted in xla_amb_components_h = '||SQL%ROWCOUNT,

2096: ,xla_environment_pkg.g_prog_id
2097: ,xla_environment_pkg.g_req_Id);
2098:
2099: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2100: trace(p_msg => '# row inserted in xla_amb_components_h = '||SQL%ROWCOUNT,
2101: p_module => l_log_module,
2102: p_level => C_LEVEL_STATEMENT);
2103: END IF;
2104: