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_B

Line 1918: FROM xla_analytical_dtls_b s

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
1918: FROM xla_analytical_dtls_b s
1919: WHERE s.amb_context_code = g_staging_context_code
1920: AND s.analytical_criterion_type_code = C_OWNER_SYSTEM
1921: AND s.analytical_criterion_code = w.analytical_criterion_code
1922: AND s.analytical_detail_code = w.analytical_detail_code);

Line 1930: DELETE FROM xla_analytical_dtls_b w

1926: p_module => l_log_module,
1927: p_level => C_LEVEL_STATEMENT);
1928: END IF;
1929:
1930: DELETE FROM xla_analytical_dtls_b w
1931: WHERE amb_context_code = g_amb_context_code
1932: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1933: AND NOT EXISTS
1934: (SELECT 1

Line 1935: FROM xla_analytical_dtls_b s

1931: WHERE amb_context_code = g_amb_context_code
1932: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1933: AND NOT EXISTS
1934: (SELECT 1
1935: FROM xla_analytical_dtls_b s
1936: WHERE s.amb_context_code = g_staging_context_code
1937: AND s.analytical_criterion_type_code = C_OWNER_SYSTEM
1938: AND s.analytical_criterion_code = w.analytical_criterion_code
1939: AND s.analytical_detail_code = w.analytical_detail_code);

Line 1942: trace(p_msg => '# xla_analytical_dtls_b deleted = '||SQL%ROWCOUNT,

1938: AND s.analytical_criterion_code = w.analytical_criterion_code
1939: AND s.analytical_detail_code = w.analytical_detail_code);
1940:
1941: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1942: trace(p_msg => '# xla_analytical_dtls_b deleted = '||SQL%ROWCOUNT,
1943: p_module => l_log_module,
1944: p_level => C_LEVEL_STATEMENT);
1945: END IF;
1946:

Line 4852: FROM xla_analytical_dtls_b s

4848: -- Added cursor for DTLs as part of bug 7243326 - This is mainly for AR where AR does not have a HDR and following DELETES and UPDATES dont loop
4849:
4850: CURSOR c_ac_dtls IS
4851: SELECT s.analytical_criterion_type_code, s.analytical_criterion_code,s.ANALYTICAL_DETAIL_CODE
4852: FROM xla_analytical_dtls_b s
4853: , xla_analytical_dtls_b w
4854: WHERE s.amb_context_code = g_staging_context_code
4855: AND w.amb_context_code(+) = g_amb_context_code
4856: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code(+)

Line 4853: , xla_analytical_dtls_b w

4849:
4850: CURSOR c_ac_dtls IS
4851: SELECT s.analytical_criterion_type_code, s.analytical_criterion_code,s.ANALYTICAL_DETAIL_CODE
4852: FROM xla_analytical_dtls_b s
4853: , xla_analytical_dtls_b w
4854: WHERE s.amb_context_code = g_staging_context_code
4855: AND w.amb_context_code(+) = g_amb_context_code
4856: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code(+)
4857: AND s.analytical_criterion_code = w.analytical_criterion_code(+)

Line 4963: 'XLA_ANALYTICAL_DTLS_B'

4959: table_name
4960: )
4961: select analytical_criterion_code,
4962: analytical_detail_code,
4963: 'XLA_ANALYTICAL_DTLS_B'
4964: from
4965: (select analytical_criterion_code,
4966: analytical_detail_code,
4967: 'XLA_ANALYTICAL_DTLS_B',

Line 4967: 'XLA_ANALYTICAL_DTLS_B',

4963: 'XLA_ANALYTICAL_DTLS_B'
4964: from
4965: (select analytical_criterion_code,
4966: analytical_detail_code,
4967: 'XLA_ANALYTICAL_DTLS_B',
4968: amb_context_code,
4969: last_update_date ,
4970: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
4971: from

Line 4974: 'XLA_ANALYTICAL_DTLS_B',

4970: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
4971: from
4972: (select analytical_criterion_code,
4973: analytical_detail_code,
4974: 'XLA_ANALYTICAL_DTLS_B',
4975: amb_context_code,
4976: last_update_date ,
4977: lag(last_update_date) over (PARTITION by analytical_criterion_code,
4978: analytical_criterion_type_code,

Line 4982: from xla_analytical_dtls_b

4978: analytical_criterion_type_code,
4979: analytical_detail_code
4980: order by amb_context_code
4981: ) lag_date
4982: from xla_analytical_dtls_b
4983: order by amb_context_code
4984: ) x
4985: where x.amb_context_code = g_staging_context_code
4986: )

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

4987: where flag = 'False';
4988:
4989: l_num_rows := SQL%ROWCOUNT;
4990: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4991: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_analytical_dtls_b is :'||l_num_rows,
4992: p_module => l_log_module,
4993: p_level => C_LEVEL_PROCEDURE);
4994: END IF;
4995: -- Bug : 9923803

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

4998: p_amb_context_code => g_amb_context_code,
4999: p_application_id => g_application_id,
5000: p_request_code => 'IMPORT' ,
5001: p_log_type_code => 'MERGE',
5002: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_analytical_dtls_b is :'||l_num_rows,
5003: p_component_code => 'merge_analytical_criteria');
5004:
5005: INSERT INTO xla_aads_gt
5006: ( analytical_criterion_code,

Line 5158: DELETE FROM xla_analytical_dtls_b w

5154: p_component_code => 'merge_analytical_criteria');
5155:
5156: -- Delete the AC dtlss from the working area for the AC dtls to be merged
5157: FORALL i IN 1..l_ac_dtl_codes.COUNT
5158: DELETE FROM xla_analytical_dtls_b w
5159: WHERE amb_context_code = g_amb_context_code
5160: AND analytical_criterion_type_code = l_ac_dtl_type_codes(i)
5161: AND analytical_criterion_code = l_ac_dtl_codes(i)
5162: AND analytical_detail_code = l_ac_detail_code(i)

Line 5165: FROM xla_analytical_dtls_b s

5161: AND analytical_criterion_code = l_ac_dtl_codes(i)
5162: AND analytical_detail_code = l_ac_detail_code(i)
5163: AND EXISTS
5164: ( SELECT 1
5165: FROM xla_analytical_dtls_b s
5166: WHERE s.amb_context_code = g_staging_context_code
5167: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
5168: AND s.analytical_criterion_code = w.analytical_criterion_code
5169: AND s.analytical_detail_code = w.analytical_detail_code);

Line 5172: trace(p_msg => '# xla_analytical_dtls_b delete : '||l_num_rows,

5168: AND s.analytical_criterion_code = w.analytical_criterion_code
5169: AND s.analytical_detail_code = w.analytical_detail_code);
5170: l_num_rows := SQL%ROWCOUNT;
5171: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5172: trace(p_msg => '# xla_analytical_dtls_b delete : '||l_num_rows,
5173: p_module => l_log_module,
5174: p_level => C_LEVEL_STATEMENT);
5175: END IF;
5176:

Line 5337: UPDATE xla_analytical_dtls_b

5333: p_encoded_message => '# xla_analytical_hdrs_tl 2 updated : '||l_num_rows,
5334: p_component_code => 'merge_analytical_criteria');
5335:
5336: FORALL i IN 1..l_ac_dtl_codes.COUNT
5337: UPDATE xla_analytical_dtls_b
5338: SET amb_context_code = g_amb_context_code
5339: WHERE amb_context_code = g_staging_context_code
5340: AND analytical_criterion_type_code = l_ac_dtl_type_codes(i)
5341: AND analytical_criterion_code = l_ac_dtl_codes(i)

Line 5345: trace(p_msg => '# xla_analytical_dtls_b updated : '||l_num_rows,

5341: AND analytical_criterion_code = l_ac_dtl_codes(i)
5342: AND analytical_detail_code = l_ac_detail_code(i);
5343: l_num_rows := SQL%ROWCOUNT;
5344: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5345: trace(p_msg => '# xla_analytical_dtls_b updated : '||l_num_rows,
5346: p_module => l_log_module,
5347: p_level => C_LEVEL_STATEMENT);
5348: END IF;
5349: -- Bug : 9923803

Line 5356: p_encoded_message => '# xla_analytical_dtls_b updated : '||l_num_rows,

5352: p_amb_context_code => g_amb_context_code,
5353: p_application_id => g_application_id,
5354: p_request_code => 'IMPORT' ,
5355: p_log_type_code => 'MERGE',
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

Line 6597: DELETE FROM xla_analytical_dtls_b

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

Line 6601: trace(p_msg => '# xla_analytical_dtls_b delete : '||l_num_rows,

6597: DELETE FROM xla_analytical_dtls_b
6598: WHERE amb_context_code = g_staging_context_code;
6599: l_num_rows := SQL%ROWCOUNT;
6600: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6601: trace(p_msg => '# xla_analytical_dtls_b delete : '||l_num_rows,
6602: p_module => l_log_module,
6603: p_level => C_LEVEL_STATEMENT);
6604: END IF;
6605: -- Bug : 9923803

Line 6612: p_encoded_message => '# xla_analytical_dtls_b delete : '||l_num_rows,

6608: p_amb_context_code => g_amb_context_code,
6609: p_application_id => g_application_id,
6610: p_request_code => 'IMPORT' ,
6611: p_log_type_code => 'MERGE',
6612: p_encoded_message => '# xla_analytical_dtls_b delete : '||l_num_rows,
6613: p_component_code => 'purge_analytical_criteria');
6614: DELETE FROM xla_analytical_hdrs_tl
6615: WHERE amb_context_code = g_staging_context_code;
6616: l_num_rows := SQL%ROWCOUNT;