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_TL

Line 1948: DELETE FROM xla_analytical_hdrs_tl w

1944: p_level => C_LEVEL_STATEMENT);
1945: END IF;
1946:
1947: FORALL i IN 1..l_codes.COUNT
1948: DELETE FROM xla_analytical_hdrs_tl w
1949: WHERE amb_context_code = g_amb_context_code
1950: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1951: AND analytical_criterion_code = l_codes(i);
1952:

Line 1954: trace(p_msg => '# xla_analytical_hdrs_tl deleted = '||SQL%ROWCOUNT,

1950: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1951: AND analytical_criterion_code = l_codes(i);
1952:
1953: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1954: trace(p_msg => '# xla_analytical_hdrs_tl deleted = '||SQL%ROWCOUNT,
1955: p_module => l_log_module,
1956: p_level => C_LEVEL_STATEMENT);
1957: END IF;
1958:

Line 5129: DELETE FROM xla_analytical_hdrs_tl w

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
5130: WHERE amb_context_code = g_amb_context_code
5131: AND analytical_criterion_type_code = l_ac_type_codes(i)
5132: AND analytical_criterion_code = l_ac_codes(i)
5133: AND EXISTS

Line 5135: FROM xla_analytical_hdrs_tl s

5131: AND analytical_criterion_type_code = l_ac_type_codes(i)
5132: AND analytical_criterion_code = l_ac_codes(i)
5133: AND EXISTS
5134: ( SELECT 1
5135: FROM xla_analytical_hdrs_tl s
5136: WHERE s.amb_context_code = g_staging_context_code
5137: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
5138: AND s.analytical_criterion_code = w.analytical_criterion_code
5139: AND s.language = w.language);

Line 5142: trace(p_msg => '# xla_analytical_hdrs_tl delete : '||l_num_rows,

5138: AND s.analytical_criterion_code = w.analytical_criterion_code
5139: AND s.language = w.language);
5140: l_num_rows := SQL%ROWCOUNT;
5141: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5142: trace(p_msg => '# xla_analytical_hdrs_tl delete : '||l_num_rows,
5143: p_module => l_log_module,
5144: p_level => C_LEVEL_STATEMENT);
5145: END IF;
5146: -- Bug : 9923803

Line 5153: p_encoded_message => '# xla_analytical_hdrs_tl delete : '||l_num_rows,

5149: p_amb_context_code => g_amb_context_code,
5150: p_application_id => g_application_id,
5151: p_request_code => 'IMPORT' ,
5152: p_log_type_code => 'MERGE',
5153: p_encoded_message => '# xla_analytical_hdrs_tl delete : '||l_num_rows,
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

Line 5280: UPDATE xla_analytical_hdrs_tl s

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
5281: SET amb_context_code = g_amb_context_code
5282: WHERE amb_context_code = g_staging_context_code
5283: AND analytical_criterion_type_code = l_ac_type_codes(i)
5284: AND analytical_criterion_code = l_ac_codes(i)

Line 5286: FROM xla_analytical_hdrs_tl w

5282: WHERE amb_context_code = g_staging_context_code
5283: AND analytical_criterion_type_code = l_ac_type_codes(i)
5284: AND analytical_criterion_code = l_ac_codes(i)
5285: AND NOT EXISTS (SELECT 1
5286: FROM xla_analytical_hdrs_tl w
5287: WHERE w.amb_context_code = g_amb_context_code
5288: AND w.analytical_criterion_type_code = s.analytical_criterion_type_code
5289: AND w.name = s.name
5290: AND w.language = s.language);

Line 5293: trace(p_msg => '# xla_analytical_hdrs_tl 1 updated : '||l_num_rows,

5289: AND w.name = s.name
5290: AND w.language = s.language);
5291: l_num_rows := SQL%ROWCOUNT;
5292: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5293: trace(p_msg => '# xla_analytical_hdrs_tl 1 updated : '||l_num_rows,
5294: p_module => l_log_module,
5295: p_level => C_LEVEL_STATEMENT);
5296: END IF;
5297: -- Bug : 9923803

Line 5304: p_encoded_message => '# xla_analytical_hdrs_tl 1 updated : '||l_num_rows,

5300: p_amb_context_code => g_amb_context_code,
5301: p_application_id => g_application_id,
5302: p_request_code => 'IMPORT' ,
5303: p_log_type_code => 'MERGE',
5304: p_encoded_message => '# xla_analytical_hdrs_tl 1 updated : '||l_num_rows,
5305: p_component_code => 'merge_analytical_criteria');
5306:
5307: FORALL i IN 1..l_ac_codes.COUNT
5308: UPDATE xla_analytical_hdrs_tl s

Line 5308: UPDATE xla_analytical_hdrs_tl s

5304: p_encoded_message => '# xla_analytical_hdrs_tl 1 updated : '||l_num_rows,
5305: p_component_code => 'merge_analytical_criteria');
5306:
5307: FORALL i IN 1..l_ac_codes.COUNT
5308: UPDATE xla_analytical_hdrs_tl s
5309: SET amb_context_code = g_amb_context_code
5310: , name = substr('('||s.analytical_criterion_code||') '||name,1,80)
5311: WHERE amb_context_code = g_staging_context_code
5312: AND analytical_criterion_type_code = l_ac_type_codes(i)

Line 5315: FROM xla_analytical_hdrs_tl w

5311: WHERE amb_context_code = g_staging_context_code
5312: AND analytical_criterion_type_code = l_ac_type_codes(i)
5313: AND analytical_criterion_code = l_ac_codes(i)
5314: AND EXISTS (SELECT 1
5315: FROM xla_analytical_hdrs_tl w
5316: WHERE w.amb_context_code = g_amb_context_code
5317: AND w.analytical_criterion_type_code = s.analytical_criterion_type_code
5318: AND w.name = s.name
5319: AND w.language = s.language);

Line 5322: trace(p_msg => '# xla_analytical_hdrs_tl 2 updated : '||l_num_rows,

5318: AND w.name = s.name
5319: AND w.language = s.language);
5320: l_num_rows := SQL%ROWCOUNT;
5321: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5322: trace(p_msg => '# xla_analytical_hdrs_tl 2 updated : '||l_num_rows,
5323: p_module => l_log_module,
5324: p_level => C_LEVEL_STATEMENT);
5325: END IF;
5326: -- Bug : 9923803

Line 5333: p_encoded_message => '# xla_analytical_hdrs_tl 2 updated : '||l_num_rows,

5329: p_amb_context_code => g_amb_context_code,
5330: p_application_id => g_application_id,
5331: p_request_code => 'IMPORT' ,
5332: p_log_type_code => 'MERGE',
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

Line 6614: DELETE FROM xla_analytical_hdrs_tl

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

Line 6618: trace(p_msg => '# xla_analytical_hdrs_tl delete : '||l_num_rows,

6614: DELETE FROM xla_analytical_hdrs_tl
6615: WHERE amb_context_code = g_staging_context_code;
6616: l_num_rows := SQL%ROWCOUNT;
6617: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6618: trace(p_msg => '# xla_analytical_hdrs_tl delete : '||l_num_rows,
6619: p_module => l_log_module,
6620: p_level => C_LEVEL_STATEMENT);
6621: END IF;
6622: -- Bug : 9923803

Line 6629: p_encoded_message => '# xla_analytical_hdrs_tl delete : '||l_num_rows,

6625: p_amb_context_code => g_amb_context_code,
6626: p_application_id => g_application_id,
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;