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_DTLS_TL

Line 1913: /*DELETE FROM xla_analytical_dtls_tl w

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
1915: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1916: AND NOT EXISTS
1917: (SELECT 1

Line 1925: trace(p_msg => '# xla_analytical_dtls_tl deleted = '||SQL%ROWCOUNT,

1921: AND s.analytical_criterion_code = w.analytical_criterion_code
1922: AND s.analytical_detail_code = w.analytical_detail_code);
1923:
1924: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1925: trace(p_msg => '# xla_analytical_dtls_tl deleted = '||SQL%ROWCOUNT,
1926: p_module => l_log_module,
1927: p_level => C_LEVEL_STATEMENT);
1928: END IF;
1929:

Line 5188: DELETE FROM xla_analytical_dtls_tl w

5184: p_encoded_message => '# row populated in XLA_STAGING_COMPONENTS_H = '||l_num_rows,
5185: p_component_code => 'populate_history');
5186:
5187: FORALL i IN 1..l_ac_dtl_codes.COUNT
5188: DELETE FROM xla_analytical_dtls_tl w
5189: WHERE amb_context_code = g_amb_context_code
5190: AND analytical_criterion_type_code = l_ac_dtl_type_codes(i)
5191: AND analytical_criterion_code = l_ac_dtl_codes(i)
5192: AND analytical_detail_code = l_ac_detail_code(i)

Line 5195: FROM xla_analytical_dtls_tl s

5191: AND analytical_criterion_code = l_ac_dtl_codes(i)
5192: AND analytical_detail_code = l_ac_detail_code(i)
5193: AND EXISTS
5194: ( SELECT 1
5195: FROM xla_analytical_dtls_tl s
5196: WHERE s.amb_context_code = g_staging_context_code
5197: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
5198: AND s.analytical_criterion_code = w.analytical_criterion_code
5199: AND s.analytical_detail_code = w.analytical_detail_code

Line 5203: trace(p_msg => '# xla_analytical_dtls_tl delete : '||l_num_rows,

5199: AND s.analytical_detail_code = w.analytical_detail_code
5200: AND s.language = w.language);
5201: l_num_rows := SQL%ROWCOUNT;
5202: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5203: trace(p_msg => '# xla_analytical_dtls_tl delete : '||l_num_rows,
5204: p_module => l_log_module,
5205: p_level => C_LEVEL_STATEMENT);
5206: END IF;
5207: -- Bug : 9923803

Line 5214: p_encoded_message => '# xla_analytical_dtls_tl delete : '||l_num_rows,

5210: p_amb_context_code => g_amb_context_code,
5211: p_application_id => g_application_id,
5212: p_request_code => 'IMPORT' ,
5213: p_log_type_code => 'MERGE',
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

Line 5360: UPDATE xla_analytical_dtls_tl s

5356: p_encoded_message => '# xla_analytical_dtls_b updated : '||l_num_rows,
5357: p_component_code => 'merge_analytical_criteria');
5358:
5359: FORALL i IN 1..l_ac_dtl_codes.COUNT
5360: UPDATE xla_analytical_dtls_tl s
5361: SET amb_context_code = g_amb_context_code
5362: WHERE amb_context_code = g_staging_context_code
5363: AND analytical_criterion_type_code = l_ac_dtl_type_codes(i)
5364: AND analytical_criterion_code = l_ac_dtl_codes(i)

Line 5367: FROM xla_analytical_dtls_tl w

5363: AND analytical_criterion_type_code = l_ac_dtl_type_codes(i)
5364: AND analytical_criterion_code = l_ac_dtl_codes(i)
5365: AND analytical_detail_code = l_ac_detail_code(i)
5366: AND NOT EXISTS (SELECT 1
5367: FROM xla_analytical_dtls_tl w
5368: WHERE w.amb_context_code = g_amb_context_code
5369: AND w.analytical_criterion_type_code = s.analytical_criterion_type_code
5370: AND s.analytical_criterion_code = s.analytical_criterion_code
5371: AND s.analytical_detail_code = s.analytical_detail_code

Line 5376: trace(p_msg => '# xla_analytical_dtls_tl 1 updated : '||l_num_rows,

5372: AND w.name = s.name
5373: AND w.language = s.language);
5374: l_num_rows := SQL%ROWCOUNT;
5375: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5376: trace(p_msg => '# xla_analytical_dtls_tl 1 updated : '||l_num_rows,
5377: p_module => l_log_module,
5378: p_level => C_LEVEL_STATEMENT);
5379: END IF;
5380:

Line 5388: p_encoded_message => '# xla_analytical_dtls_tl 1 updated : '||l_num_rows,

5384: p_amb_context_code => g_amb_context_code,
5385: p_application_id => g_application_id,
5386: p_request_code => 'IMPORT' ,
5387: p_log_type_code => 'MERGE',
5388: p_encoded_message => '# xla_analytical_dtls_tl 1 updated : '||l_num_rows,
5389: p_component_code => 'merge_analytical_criteria');
5390:
5391: FORALL i IN 1..l_ac_dtl_codes.COUNT
5392: UPDATE xla_analytical_dtls_tl w

Line 5392: UPDATE xla_analytical_dtls_tl w

5388: p_encoded_message => '# xla_analytical_dtls_tl 1 updated : '||l_num_rows,
5389: p_component_code => 'merge_analytical_criteria');
5390:
5391: FORALL i IN 1..l_ac_dtl_codes.COUNT
5392: UPDATE xla_analytical_dtls_tl w
5393: SET amb_context_code = g_amb_context_code
5394: , name = substr('('||w.analytical_detail_code||') '||name,1,80)
5395: WHERE amb_context_code = g_staging_context_code
5396: AND analytical_criterion_type_code = l_ac_dtl_type_codes(i)

Line 5400: FROM xla_analytical_dtls_tl s

5396: AND analytical_criterion_type_code = l_ac_dtl_type_codes(i)
5397: AND analytical_criterion_code = l_ac_dtl_codes(i)
5398: AND analytical_detail_code = l_ac_detail_code(i)
5399: AND EXISTS (SELECT 1
5400: FROM xla_analytical_dtls_tl s
5401: WHERE s.amb_context_code = g_amb_context_code
5402: AND w.analytical_criterion_type_code = s.analytical_criterion_type_code
5403: AND s.analytical_criterion_code = s.analytical_criterion_code
5404: AND s.analytical_detail_code = s.analytical_detail_code

Line 5409: trace(p_msg => '# xla_analytical_dtls_tl 2 updated : '||l_num_rows,

5405: AND s.name = w.name
5406: AND s.language = w.language);
5407: l_num_rows := SQL%ROWCOUNT;
5408: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5409: trace(p_msg => '# xla_analytical_dtls_tl 2 updated : '||l_num_rows,
5410: p_module => l_log_module,
5411: p_level => C_LEVEL_STATEMENT);
5412: END IF;
5413: -- Bug : 9923803

Line 5420: p_encoded_message => '# xla_analytical_dtls_tl 2 updated : '||l_num_rows,

5416: p_amb_context_code => g_amb_context_code,
5417: p_application_id => g_application_id,
5418: p_request_code => 'IMPORT' ,
5419: p_log_type_code => 'MERGE',
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

Line 6580: DELETE FROM xla_analytical_dtls_tl

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;
6583: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6584: trace(p_msg => '# xla_analytical_dtls_tl delete : '||l_num_rows,

Line 6584: trace(p_msg => '# xla_analytical_dtls_tl delete : '||l_num_rows,

6580: DELETE FROM xla_analytical_dtls_tl
6581: WHERE amb_context_code = g_staging_context_code;
6582: l_num_rows := SQL%ROWCOUNT;
6583: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6584: trace(p_msg => '# xla_analytical_dtls_tl delete : '||l_num_rows,
6585: p_module => l_log_module,
6586: p_level => C_LEVEL_STATEMENT);
6587: END IF;
6588: -- Bug : 9923803

Line 6595: p_encoded_message => '# xla_analytical_dtls_tl delete : '||l_num_rows,

6591: p_amb_context_code => g_amb_context_code,
6592: p_application_id => g_application_id,
6593: p_request_code => 'IMPORT' ,
6594: p_log_type_code => 'MERGE',
6595: p_encoded_message => '# xla_analytical_dtls_tl delete : '||l_num_rows,
6596: p_component_code => 'purge_analytical_criteria');
6597: DELETE FROM xla_analytical_dtls_b
6598: WHERE amb_context_code = g_staging_context_code;
6599: l_num_rows := SQL%ROWCOUNT;