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_MERGE_PVT dependencies on XLA_ANALYTICAL_SOURCES

Line 1879: DELETE FROM xla_analytical_sources w

1875: p_level => C_LEVEL_STATEMENT);
1876: END IF;*/ -- commented bug6696939
1877:
1878: -- Delete the AC
1879: DELETE FROM xla_analytical_sources w
1880: WHERE amb_context_code = g_amb_context_code
1881: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1882: AND application_id = g_application_id -- added bug6696939
1883: AND NOT EXISTS

Line 1885: FROM xla_analytical_sources s

1881: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1882: AND application_id = g_application_id -- added bug6696939
1883: AND NOT EXISTS
1884: (SELECT 1
1885: FROM xla_analytical_sources s
1886: WHERE s.amb_context_code = g_staging_context_code
1887: AND s.application_id = g_application_id
1888: AND s.entity_code = w.entity_code
1889: AND s.event_class_code = w.event_class_code

Line 1898: trace(p_msg => '# xla_analytical_sources deleted = '||l_num_rows,

1894: AND s.analytical_criterion_code = w.analytical_criterion_code
1895: AND s.analytical_detail_code = w.analytical_detail_code);
1896: l_num_rows := SQL%ROWCOUNT;
1897: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1898: trace(p_msg => '# xla_analytical_sources deleted = '||l_num_rows,
1899: p_module => l_log_module,
1900: p_level => C_LEVEL_STATEMENT);
1901: END IF;
1902:

Line 1910: p_encoded_message =>'# xla_analytical_sources deleted = '||l_num_rows,

1906: p_amb_context_code => g_amb_context_code,
1907: p_application_id => g_application_id,
1908: p_request_code => 'IMPORT' ,
1909: p_log_type_code => 'MERGE',
1910: p_encoded_message =>'# xla_analytical_sources deleted = '||l_num_rows,
1911: p_component_code => 'clean_oracle_acs');
1912:
1913: /*DELETE FROM xla_analytical_dtls_tl w
1914: WHERE amb_context_code = g_amb_context_code

Line 4863: FROM xla_analytical_sources s

4859:
4860: CURSOR c_ac_src IS
4861: SELECT s.analytical_criterion_type_code, s.analytical_criterion_code,s.ANALYTICAL_DETAIL_CODE,
4862: s.event_class_code,s.entity_code,s.source_code,s.source_type_code
4863: FROM xla_analytical_sources s
4864: , xla_analytical_sources w
4865: WHERE s.amb_context_code = g_staging_context_code
4866: AND w.amb_context_code(+) = g_amb_context_code
4867: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code(+)

Line 4864: , xla_analytical_sources w

4860: CURSOR c_ac_src IS
4861: SELECT s.analytical_criterion_type_code, s.analytical_criterion_code,s.ANALYTICAL_DETAIL_CODE,
4862: s.event_class_code,s.entity_code,s.source_code,s.source_type_code
4863: FROM xla_analytical_sources s
4864: , xla_analytical_sources w
4865: WHERE s.amb_context_code = g_staging_context_code
4866: AND w.amb_context_code(+) = g_amb_context_code
4867: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code(+)
4868: AND s.analytical_criterion_code = w.analytical_criterion_code(+)

Line 5018: 'XLA_ANALYTICAL_SOURCES'

5014: analytical_detail_code,
5015: entity_code,
5016: event_class_code,
5017: source_code,
5018: 'XLA_ANALYTICAL_SOURCES'
5019: from
5020: (select analytical_criterion_code,
5021: analytical_detail_code,
5022: entity_code,

Line 5025: 'XLA_ANALYTICAL_SOURCES',

5021: analytical_detail_code,
5022: entity_code,
5023: event_class_code,
5024: source_code,
5025: 'XLA_ANALYTICAL_SOURCES',
5026: amb_context_code,
5027: last_update_date ,
5028: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
5029: from

Line 5035: 'XLA_ANALYTICAL_SOURCES',

5031: analytical_detail_code,
5032: entity_code,
5033: event_class_code,
5034: source_code,
5035: 'XLA_ANALYTICAL_SOURCES',
5036: amb_context_code,
5037: last_update_date ,
5038: lag(last_update_date) over (PARTITION by application_id,
5039: analytical_criterion_code,

Line 5048: from xla_analytical_sources

5044: source_code,
5045: source_type_code
5046: order by amb_context_code
5047: ) lag_date
5048: from xla_analytical_sources
5049: order by amb_context_code
5050: ) x
5051: where x.amb_context_code = g_staging_context_code
5052: )

Line 5059: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_analytical_sources is :'||l_num_rows,

5055: l_num_rows := SQL%ROWCOUNT;
5056:
5057:
5058: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
5059: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_analytical_sources is :'||l_num_rows,
5060: p_module => l_log_module,
5061: p_level => C_LEVEL_PROCEDURE);
5062: END IF;
5063:

Line 5071: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_analytical_sources is :'||l_num_rows,

5067: p_amb_context_code => g_amb_context_code,
5068: p_application_id => g_application_id,
5069: p_request_code => 'IMPORT' ,
5070: p_log_type_code => 'MERGE',
5071: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_analytical_sources is :'||l_num_rows,
5072: p_component_code => 'merge_analytical_criteria');
5073:
5074: IF (g_analyzed_flag = 'Y') THEN
5075: null;

Line 5218: DELETE FROM xla_analytical_sources w

5214: p_encoded_message => '# xla_analytical_dtls_tl delete : '||l_num_rows,
5215: p_component_code => 'merge_analytical_criteria');
5216:
5217: FORALL i IN 1..l_ac_src_event_class.COUNT
5218: DELETE FROM xla_analytical_sources w
5219: WHERE amb_context_code = g_amb_context_code
5220: AND analytical_criterion_type_code = l_ac_src_type_codes(i) --Bug 10060589
5221: AND analytical_criterion_code = l_ac_src_codes(i) --Bug 10060589
5222: AND analytical_detail_code = l_ac_src_detail_code(i) --Bug 10060589 -- Added for bug 8268819

Line 5229: FROM xla_analytical_sources s

5225: AND SOURCE_CODE =l_ac_src_source_code(i)
5226: AND SOURCE_TYPE_CODE =l_ac_src_source_type_code(i)
5227: AND EXISTS
5228: ( SELECT 1
5229: FROM xla_analytical_sources s
5230: WHERE s.amb_context_code = g_staging_context_code
5231: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
5232: AND s.analytical_criterion_code = w.analytical_criterion_code
5233: AND s.analytical_detail_code = w.analytical_detail_code -- Added for bug 8268819

Line 5240: trace(p_msg => '# xla_analytical_sources delete : '||l_num_rows,

5236: AND s.source_code = w.source_code
5237: AND s.source_type_code = w.source_type_code);
5238: l_num_rows := SQL%ROWCOUNT;
5239: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5240: trace(p_msg => '# xla_analytical_sources delete : '||l_num_rows,
5241: p_module => l_log_module,
5242: p_level => C_LEVEL_STATEMENT);
5243: END IF;
5244: -- Bug : 9923803

Line 5251: p_encoded_message => '# xla_analytical_sources delete : '||l_num_rows,

5247: p_amb_context_code => g_amb_context_code,
5248: p_application_id => g_application_id,
5249: p_request_code => 'IMPORT' ,
5250: p_log_type_code => 'MERGE',
5251: p_encoded_message => '# xla_analytical_sources delete : '||l_num_rows,
5252: p_component_code => 'merge_analytical_criteria');
5253: END IF;
5254:
5255: -- Move the analytical criteria from staging area to working area

Line 5424: UPDATE xla_analytical_sources

5420: p_encoded_message => '# xla_analytical_dtls_tl 2 updated : '||l_num_rows,
5421: p_component_code => 'merge_analytical_criteria');
5422:
5423: FORALL i IN 1..l_ac_src_event_class.COUNT
5424: UPDATE xla_analytical_sources
5425: SET amb_context_code = g_amb_context_code
5426: WHERE amb_context_code = g_staging_context_code
5427: AND analytical_criterion_type_code = l_ac_src_type_codes(i)--Bug 10060589
5428: AND analytical_criterion_code = l_ac_src_codes(i) --Bug 10060589

Line 5437: trace(p_msg => '# xla_analytical_sources updated : '||l_num_rows,

5433: AND SOURCE_TYPE_CODE =l_ac_src_source_type_code(i);
5434:
5435: l_num_rows := SQL%ROWCOUNT;
5436: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5437: trace(p_msg => '# xla_analytical_sources updated : '||l_num_rows,
5438: p_module => l_log_module,
5439: p_level => C_LEVEL_STATEMENT);
5440: END IF;
5441: -- Bug : 9923803

Line 5448: p_encoded_message => '# xla_analytical_sources updated : '||l_num_rows,

5444: p_amb_context_code => g_amb_context_code,
5445: p_application_id => g_application_id,
5446: p_request_code => 'IMPORT' ,
5447: p_log_type_code => 'MERGE',
5448: p_encoded_message => '# xla_analytical_sources updated : '||l_num_rows,
5449: p_component_code => 'merge_analytical_criteria');
5450:
5451: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
5452: trace(p_msg => 'END of procedure merge_analytical_criteria',

Line 6563: DELETE FROM xla_analytical_sources

6559: p_module => l_log_module,
6560: p_level => C_LEVEL_PROCEDURE);
6561: END IF;
6562:
6563: DELETE FROM xla_analytical_sources
6564: WHERE amb_context_code = g_staging_context_code;
6565: l_num_rows := SQL%ROWCOUNT;
6566: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6567: trace(p_msg => '# xla_analytical_sources delete : '||l_num_rows,

Line 6567: trace(p_msg => '# xla_analytical_sources delete : '||l_num_rows,

6563: DELETE FROM xla_analytical_sources
6564: WHERE amb_context_code = g_staging_context_code;
6565: l_num_rows := SQL%ROWCOUNT;
6566: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6567: trace(p_msg => '# xla_analytical_sources delete : '||l_num_rows,
6568: p_module => l_log_module,
6569: p_level => C_LEVEL_STATEMENT);
6570: END IF;
6571: -- Bug : 9923803

Line 6578: p_encoded_message => '# xla_analytical_sources delete : '||l_num_rows,

6574: p_amb_context_code => g_amb_context_code,
6575: p_application_id => g_application_id,
6576: p_request_code => 'IMPORT' ,
6577: p_log_type_code => 'MERGE',
6578: p_encoded_message => '# xla_analytical_sources delete : '||l_num_rows,
6579: p_component_code => 'purge_analytical_criteria');
6580: DELETE FROM xla_analytical_dtls_tl
6581: WHERE amb_context_code = g_staging_context_code;
6582: l_num_rows := SQL%ROWCOUNT;