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_HDRS_B

Line 1793: FROM xla_analytical_hdrs_b w

1789: PROCEDURE clean_oracle_acs
1790: IS
1791: /*CURSOR c_all_comps IS
1792: SELECT w.analytical_criterion_code
1793: FROM xla_analytical_hdrs_b w
1794: WHERE w.amb_context_code = g_amb_context_code
1795: AND w.application_id = g_application_id
1796: AND w.analytical_criterion_type_code = C_OWNER_SYSTEM
1797: AND NOT EXISTS ( SELECT 1

Line 1798: FROM xla_analytical_hdrs_b s

1794: WHERE w.amb_context_code = g_amb_context_code
1795: AND w.application_id = g_application_id
1796: AND w.analytical_criterion_type_code = C_OWNER_SYSTEM
1797: AND NOT EXISTS ( SELECT 1
1798: FROM xla_analytical_hdrs_b s
1799: WHERE s.amb_context_code = g_staging_context_code
1800: AND s.application_id = g_application_id
1801: AND s.analytical_criterion_type_code = C_OWNER_SYSTEM
1802: AND s.analytical_criterion_code = w.analytical_criterion_code);

Line 1960: DELETE FROM xla_analytical_hdrs_b w

1956: p_level => C_LEVEL_STATEMENT);
1957: END IF;
1958:
1959: FORALL i IN 1..l_codes.COUNT
1960: DELETE FROM xla_analytical_hdrs_b w
1961: WHERE amb_context_code = g_amb_context_code
1962: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1963: AND analytical_criterion_code = l_codes(i);
1964:

Line 1966: trace(p_msg => '# xla_analytical_hdrs_b deleted = '||SQL%ROWCOUNT,

1962: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1963: AND analytical_criterion_code = l_codes(i);
1964:
1965: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1966: trace(p_msg => '# xla_analytical_hdrs_b deleted = '||SQL%ROWCOUNT,
1967: p_module => l_log_module,
1968: p_level => C_LEVEL_STATEMENT);
1969: END IF;*/ -- commented bug6696939
1970:

Line 4840: FROM xla_analytical_hdrs_b s

4836: IS
4837: -- Retrieve the AC to be merged
4838: CURSOR c_ac IS
4839: SELECT s.analytical_criterion_type_code, s.analytical_criterion_code
4840: FROM xla_analytical_hdrs_b s
4841: , xla_analytical_hdrs_b w
4842: WHERE s.amb_context_code = g_staging_context_code
4843: AND w.amb_context_code(+) = g_amb_context_code
4844: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code(+)

Line 4841: , xla_analytical_hdrs_b w

4837: -- Retrieve the AC to be merged
4838: CURSOR c_ac IS
4839: SELECT s.analytical_criterion_type_code, s.analytical_criterion_code
4840: FROM xla_analytical_hdrs_b s
4841: , xla_analytical_hdrs_b w
4842: WHERE s.amb_context_code = g_staging_context_code
4843: AND w.amb_context_code(+) = g_amb_context_code
4844: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code(+)
4845: AND s.analytical_criterion_code = w.analytical_criterion_code(+)

Line 4915: 'XLA_ANALYTICAL_HDRS_B'

4911: ( analytical_criterion_code,
4912: table_name
4913: )
4914: select analytical_criterion_code,
4915: 'XLA_ANALYTICAL_HDRS_B'
4916: from
4917: (select analytical_criterion_code,
4918: 'XLA_ANALYTICAL_HDRS_B',
4919: amb_context_code,

Line 4918: 'XLA_ANALYTICAL_HDRS_B',

4914: select analytical_criterion_code,
4915: 'XLA_ANALYTICAL_HDRS_B'
4916: from
4917: (select analytical_criterion_code,
4918: 'XLA_ANALYTICAL_HDRS_B',
4919: amb_context_code,
4920: last_update_date ,
4921: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
4922: from

Line 4924: 'XLA_ANALYTICAL_HDRS_B',

4920: last_update_date ,
4921: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
4922: from
4923: (select analytical_criterion_code,
4924: 'XLA_ANALYTICAL_HDRS_B',
4925: amb_context_code,
4926: last_update_date ,
4927: lag(last_update_date) over (PARTITION by application_id,
4928: analytical_criterion_code,

Line 4932: from xla_analytical_hdrs_b

4928: analytical_criterion_code,
4929: analytical_criterion_type_code
4930: order by amb_context_code
4931: ) lag_date
4932: from xla_analytical_hdrs_b
4933: order by amb_context_code
4934: ) x
4935: where x.amb_context_code = g_staging_context_code
4936: )

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

4937: where flag = 'False';
4938: l_num_rows := SQL%ROWCOUNT;
4939:
4940: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4941: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_analytical_hdrs_b is :'||l_num_rows,
4942: p_module => l_log_module,
4943: p_level => C_LEVEL_PROCEDURE);
4944: END IF;
4945:

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

4949: p_amb_context_code => g_amb_context_code,
4950: p_application_id => g_application_id,
4951: p_request_code => 'IMPORT' ,
4952: p_log_type_code => 'MERGE',
4953: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_analytical_hdrs_b is :'||l_num_rows,
4954: p_component_code => 'merge_analytical_criteria');
4955:
4956: INSERT INTO xla_aads_gt
4957: ( analytical_criterion_code,

Line 5102: DELETE FROM xla_analytical_hdrs_b w

5098: CLOSE c_ac_src ;
5099:
5100: -- Delete the ACs from the working area for the AC to be merged
5101: FORALL i IN 1..l_ac_codes.COUNT
5102: DELETE FROM xla_analytical_hdrs_b w
5103: WHERE amb_context_code = g_amb_context_code
5104: AND analytical_criterion_type_code = l_ac_type_codes(i)
5105: AND analytical_criterion_code = l_ac_codes(i)
5106: AND EXISTS

Line 5108: FROM xla_analytical_hdrs_b s

5104: AND analytical_criterion_type_code = l_ac_type_codes(i)
5105: AND analytical_criterion_code = l_ac_codes(i)
5106: AND EXISTS
5107: ( SELECT 1
5108: FROM xla_analytical_hdrs_b s
5109: WHERE s.amb_context_code = g_staging_context_code
5110: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
5111: AND s.analytical_criterion_code = w.analytical_criterion_code );
5112: l_num_rows := SQL%ROWCOUNT;

Line 5114: trace(p_msg => '# xla_analytical_hdrs_b delete : '||l_num_rows,

5110: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
5111: AND s.analytical_criterion_code = w.analytical_criterion_code );
5112: l_num_rows := SQL%ROWCOUNT;
5113: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5114: trace(p_msg => '# xla_analytical_hdrs_b delete : '||l_num_rows,
5115: p_module => l_log_module,
5116: p_level => C_LEVEL_STATEMENT);
5117: END IF;
5118: -- Bug : 9923803

Line 5125: p_encoded_message => '# xla_analytical_hdrs_b delete : '||l_num_rows,

5121: p_amb_context_code => g_amb_context_code,
5122: p_application_id => g_application_id,
5123: p_request_code => 'IMPORT' ,
5124: p_log_type_code => 'MERGE',
5125: p_encoded_message => '# xla_analytical_hdrs_b delete : '||l_num_rows,
5126: p_component_code => 'merge_analytical_criteria');
5127:
5128: FORALL i IN 1..l_ac_codes.COUNT
5129: DELETE FROM xla_analytical_hdrs_tl w

Line 5257: UPDATE xla_analytical_hdrs_b

5253: END IF;
5254:
5255: -- Move the analytical criteria from staging area to working area
5256: FORALL i IN 1..l_ac_codes.COUNT
5257: UPDATE xla_analytical_hdrs_b
5258: SET amb_context_code = g_amb_context_code
5259: WHERE amb_context_code = g_staging_context_code
5260: AND analytical_criterion_type_code = l_ac_type_codes(i)
5261: AND analytical_criterion_code = l_ac_codes(i);

Line 5265: trace(p_msg => '# xla_analytical_hdrs_b updated : '||l_num_rows,

5261: AND analytical_criterion_code = l_ac_codes(i);
5262:
5263: l_num_rows := SQL%ROWCOUNT;
5264: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5265: trace(p_msg => '# xla_analytical_hdrs_b updated : '||l_num_rows,
5266: p_module => l_log_module,
5267: p_level => C_LEVEL_STATEMENT);
5268: END IF;
5269: -- Bug : 9923803

Line 5276: p_encoded_message => '# xla_analytical_hdrs_b updated : '||l_num_rows,

5272: p_amb_context_code => g_amb_context_code,
5273: p_application_id => g_application_id,
5274: p_request_code => 'IMPORT' ,
5275: p_log_type_code => 'MERGE',
5276: p_encoded_message => '# xla_analytical_hdrs_b updated : '||l_num_rows,
5277: p_component_code => 'merge_analytical_criteria');
5278:
5279: FORALL i IN 1..l_ac_codes.COUNT
5280: UPDATE xla_analytical_hdrs_tl s

Line 6631: DELETE FROM xla_analytical_hdrs_b

6627: p_request_code => 'IMPORT' ,
6628: p_log_type_code => 'MERGE',
6629: p_encoded_message => '# xla_analytical_hdrs_tl delete : '||l_num_rows,
6630: p_component_code => 'purge_analytical_criteria');
6631: DELETE FROM xla_analytical_hdrs_b
6632: WHERE amb_context_code = g_staging_context_code;
6633: l_num_rows := SQL%ROWCOUNT;
6634: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6635: trace(p_msg => '# xla_analytical_hdrs_b delete : '||l_num_rows,

Line 6635: trace(p_msg => '# xla_analytical_hdrs_b delete : '||l_num_rows,

6631: DELETE FROM xla_analytical_hdrs_b
6632: WHERE amb_context_code = g_staging_context_code;
6633: l_num_rows := SQL%ROWCOUNT;
6634: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6635: trace(p_msg => '# xla_analytical_hdrs_b delete : '||l_num_rows,
6636: p_module => l_log_module,
6637: p_level => C_LEVEL_STATEMENT);
6638: END IF;
6639: -- Bug : 9923803

Line 6646: p_encoded_message => '# xla_analytical_hdrs_b delete : '||l_num_rows,

6642: p_amb_context_code => g_amb_context_code,
6643: p_application_id => g_application_id,
6644: p_request_code => 'IMPORT' ,
6645: p_log_type_code => 'MERGE',
6646: p_encoded_message => '# xla_analytical_hdrs_b delete : '||l_num_rows,
6647: p_component_code => 'purge_analytical_criteria');
6648: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
6649: trace(p_msg => 'END of procedure purge_analytical_criteria',
6650: p_module => l_log_module,