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_LOADER_UTIL_PVT dependencies on XLA_STAGING_COMPONENTS_H

Line 1822: USING xla_staging_components_h s

1818: END IF;
1819:
1820: /*
1821: MERGE INTO xla_aads_h h
1822: USING xla_staging_components_h s
1823: ON (h.application_id = s.application_id
1824: AND h.product_rule_type_code = s.component_owner_code
1825: AND h.product_rule_code = s.component_code
1826: AND h.version_num = s.version_num

Line 1847: , xla_staging_components_h s

1843: ,NVL(s.product_rule_version, h2.user_version)
1844: ,NVL(s.version_comment, h2.version_comment)
1845: ,NVL(s.leapfrog_flag, h2.leapfrog_flag)
1846: FROM xla_aads_h h2
1847: , xla_staging_components_h s
1848: WHERE h.application_id = h2.application_id
1849: AND h.product_rule_type_code = h2.product_rule_type_code
1850: AND h.product_rule_code = h2.product_rule_code
1851: AND h.version_num = h2.version_num

Line 1904: FROM xla_staging_components_h s

1900: ,sysdate
1901: ,xla_environment_pkg.g_prog_appl_id
1902: ,xla_environment_pkg.g_prog_id
1903: ,xla_environment_pkg.g_req_Id
1904: FROM xla_staging_components_h s
1905: WHERE s.application_id = p_application_id
1906: AND s.staging_amb_context_code = p_staging_context_code
1907: AND s.component_type_code = 'AAD'
1908: AND NOT EXISTS

Line 1924: USING xla_staging_components_h s

1920: END IF;
1921:
1922: /*
1923: MERGE INTO xla_amb_components_h h
1924: USING xla_staging_components_h s
1925: ON (h.component_type_code = s.component_type_code
1926: AND h.component_owner_code = s.component_owner_code
1927: AND h.component_code = s.component_code
1928: AND h.version_num = s.version_num

Line 1939: , xla_staging_components_h s

1935: UPDATE xla_amb_components_h h
1936: SET base_version_num =
1937: (SELECT nvl(s.base_version_num, h2.base_version_num)
1938: FROM xla_amb_components_h h2
1939: , xla_staging_components_h s
1940: WHERE h.component_type_code = h2.component_type_code
1941: AND h.component_owner_code = h2.component_owner_code
1942: AND h.component_code = h2.component_code
1943: AND h.application_id = h2.application_id

Line 1995: FROM xla_staging_components_h s

1991: ,sysdate
1992: ,xla_environment_pkg.g_prog_appl_id
1993: ,xla_environment_pkg.g_prog_id
1994: ,xla_environment_pkg.g_req_Id
1995: FROM xla_staging_components_h s
1996: WHERE s.staging_amb_context_code = p_staging_context_code
1997: AND s.component_type_code <> 'AAD'
1998: AND NOT EXISTS
1999: (SELECT 1

Line 3024: DELETE FROM xla_staging_components_h

3020: p_module => l_log_module,
3021: p_level => C_LEVEL_PROCEDURE);
3022: END IF;
3023:
3024: DELETE FROM xla_staging_components_h
3025: WHERE staging_amb_context_code = l_staging_context_code;
3026:
3027: -- Bug 16208537
3028: -- API Call to Insert messages into AAD Loader Log Table.

Line 3034: p_encoded_message => '# delete (xla_staging_components_h) = '||SQL%ROWCOUNT,

3030: p_amb_context_code => l_staging_context_code,
3031: p_application_id => p_application_id,
3032: p_request_code => 'IMPORT' ,
3033: p_log_type_code => 'MERGE',
3034: p_encoded_message => '# delete (xla_staging_components_h) = '||SQL%ROWCOUNT,
3035: p_component_code => 'purge_aad');
3036:
3037: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3038: trace(p_msg => '# xla_staging_components_h deleted = '||SQL%ROWCOUNT,

Line 3038: trace(p_msg => '# xla_staging_components_h deleted = '||SQL%ROWCOUNT,

3034: p_encoded_message => '# delete (xla_staging_components_h) = '||SQL%ROWCOUNT,
3035: p_component_code => 'purge_aad');
3036:
3037: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3038: trace(p_msg => '# xla_staging_components_h deleted = '||SQL%ROWCOUNT,
3039: p_module => l_log_module,
3040: p_level => C_LEVEL_PROCEDURE);
3041: END IF;
3042:

Line 3102: DELETE FROM xla_staging_components_h

3098: p_module => l_log_module,
3099: p_level => C_LEVEL_PROCEDURE);
3100: END IF;
3101:
3102: DELETE FROM xla_staging_components_h
3103: WHERE staging_amb_context_code = p_amb_context_code;
3104:
3105: -- Bug 16208537
3106: -- API Call to Insert messages into AAD Loader Log Table.

Line 3112: p_encoded_message => '# delete (xla_staging_components_h) = '||SQL%ROWCOUNT,

3108: p_amb_context_code => p_amb_context_code,
3109: p_application_id => p_application_id,
3110: p_request_code => 'IMPORT' ,
3111: p_log_type_code => 'MERGE',
3112: p_encoded_message => '# delete (xla_staging_components_h) = '||SQL%ROWCOUNT,
3113: p_component_code => 'purge_aad');
3114:
3115: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3116: trace(p_msg => '# xla_staging_components_h deleted = '||SQL%ROWCOUNT,

Line 3116: trace(p_msg => '# xla_staging_components_h deleted = '||SQL%ROWCOUNT,

3112: p_encoded_message => '# delete (xla_staging_components_h) = '||SQL%ROWCOUNT,
3113: p_component_code => 'purge_aad');
3114:
3115: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3116: trace(p_msg => '# xla_staging_components_h deleted = '||SQL%ROWCOUNT,
3117: p_module => l_log_module,
3118: p_level => C_LEVEL_PROCEDURE);
3119: END IF;
3120: