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_MAPPING_SETS_TL

Line 5927: DELETE FROM xla_mapping_sets_tl w

5923: p_encoded_message => '# xla_conditions updated : '||l_num_rows,
5924: p_component_code => 'merge_mapping_sets');
5925:
5926: FORALL i in 1 .. l_ms.count
5927: DELETE FROM xla_mapping_sets_tl w
5928: WHERE amb_context_code = g_amb_context_code
5929: AND mapping_set_code = l_ms(i)
5930: AND EXISTS (SELECT 1
5931: FROM xla_mapping_sets_tl s

Line 5931: FROM xla_mapping_sets_tl s

5927: DELETE FROM xla_mapping_sets_tl w
5928: WHERE amb_context_code = g_amb_context_code
5929: AND mapping_set_code = l_ms(i)
5930: AND EXISTS (SELECT 1
5931: FROM xla_mapping_sets_tl s
5932: WHERE s.amb_context_code = g_staging_context_code
5933: AND s.mapping_set_code = w.mapping_set_code
5934: AND s.language = w.language);
5935: l_num_rows := SQL%ROWCOUNT;

Line 5937: trace(p_msg => '# xla_mapping_sets_tl delete : '||l_num_rows,

5933: AND s.mapping_set_code = w.mapping_set_code
5934: AND s.language = w.language);
5935: l_num_rows := SQL%ROWCOUNT;
5936: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5937: trace(p_msg => '# xla_mapping_sets_tl delete : '||l_num_rows,
5938: p_module => l_log_module,
5939: p_level => C_LEVEL_STATEMENT);
5940: END IF;
5941: -- Bug : 9923803

Line 5948: p_encoded_message => '# xla_mapping_sets_tl delete : '||l_num_rows,

5944: p_amb_context_code => g_amb_context_code,
5945: p_application_id => g_application_id,
5946: p_request_code => 'IMPORT' ,
5947: p_log_type_code => 'MERGE',
5948: p_encoded_message => '# xla_mapping_sets_tl delete : '||l_num_rows,
5949: p_component_code => 'merge_mapping_sets');
5950:
5951: FORALL i in 1 .. l_ms.count
5952: DELETE FROM xla_mapping_set_values w

Line 5995: UPDATE xla_mapping_sets_tl s

5991: p_encoded_message => '# xla_mapping_sets_b updated : '||l_num_rows,
5992: p_component_code => 'merge_mapping_sets');
5993:
5994: FORALL i in 1 .. l_ms.count
5995: UPDATE xla_mapping_sets_tl s
5996: SET amb_context_code = g_amb_context_code
5997: WHERE amb_context_code = g_staging_context_code
5998: AND mapping_set_code = l_ms(i)
5999: AND NOT EXISTS (SELECT 1

Line 6000: FROM xla_mapping_sets_tl w

5996: SET amb_context_code = g_amb_context_code
5997: WHERE amb_context_code = g_staging_context_code
5998: AND mapping_set_code = l_ms(i)
5999: AND NOT EXISTS (SELECT 1
6000: FROM xla_mapping_sets_tl w
6001: WHERE w.amb_context_code = g_amb_context_code
6002: AND w.name = s.name
6003: AND w.language = s.language);
6004: l_num_rows := SQL%ROWCOUNT;

Line 6006: trace(p_msg => '# xla_mapping_sets_tl 1 updated : '||l_num_rows,

6002: AND w.name = s.name
6003: AND w.language = s.language);
6004: l_num_rows := SQL%ROWCOUNT;
6005: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6006: trace(p_msg => '# xla_mapping_sets_tl 1 updated : '||l_num_rows,
6007: p_module => l_log_module,
6008: p_level => C_LEVEL_STATEMENT);
6009: END IF;
6010: -- Bug : 9923803

Line 6017: p_encoded_message => '# xla_mapping_sets_tl 1 updated : '||l_num_rows,

6013: p_amb_context_code => g_amb_context_code,
6014: p_application_id => g_application_id,
6015: p_request_code => 'IMPORT' ,
6016: p_log_type_code => 'MERGE',
6017: p_encoded_message => '# xla_mapping_sets_tl 1 updated : '||l_num_rows,
6018: p_component_code => 'merge_mapping_sets');
6019:
6020: FORALL i in 1 .. l_ms.count
6021: UPDATE xla_mapping_sets_tl s

Line 6021: UPDATE xla_mapping_sets_tl s

6017: p_encoded_message => '# xla_mapping_sets_tl 1 updated : '||l_num_rows,
6018: p_component_code => 'merge_mapping_sets');
6019:
6020: FORALL i in 1 .. l_ms.count
6021: UPDATE xla_mapping_sets_tl s
6022: SET amb_context_code = g_amb_context_code
6023: , name = substr('('||s.mapping_set_code||') '||name,1,80)
6024: WHERE amb_context_code = g_staging_context_code
6025: AND mapping_set_code = l_ms(i)

Line 6027: FROM xla_mapping_sets_tl w

6023: , name = substr('('||s.mapping_set_code||') '||name,1,80)
6024: WHERE amb_context_code = g_staging_context_code
6025: AND mapping_set_code = l_ms(i)
6026: AND EXISTS (SELECT 1
6027: FROM xla_mapping_sets_tl w
6028: WHERE w.amb_context_code = g_amb_context_code
6029: AND w.name = s.name
6030: AND w.language = s.language);
6031: l_num_rows := SQL%ROWCOUNT;

Line 6033: trace(p_msg => '# xla_mapping_sets_tl 2 updated : '||l_num_rows,

6029: AND w.name = s.name
6030: AND w.language = s.language);
6031: l_num_rows := SQL%ROWCOUNT;
6032: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6033: trace(p_msg => '# xla_mapping_sets_tl 2 updated : '||l_num_rows,
6034: p_module => l_log_module,
6035: p_level => C_LEVEL_STATEMENT);
6036: END IF;
6037: -- Bug : 9923803

Line 6044: p_encoded_message => '# xla_mapping_sets_tl 2 updated : '||l_num_rows,

6040: p_amb_context_code => g_amb_context_code,
6041: p_application_id => g_application_id,
6042: p_request_code => 'IMPORT' ,
6043: p_log_type_code => 'MERGE',
6044: p_encoded_message => '# xla_mapping_sets_tl 2 updated : '||l_num_rows,
6045: p_component_code => 'merge_mapping_sets');
6046:
6047: FORALL i in 1 .. l_ms.count
6048: UPDATE xla_mapping_set_values

Line 6488: DELETE FROM xla_mapping_sets_tl

6484: p_request_code => 'IMPORT' ,
6485: p_log_type_code => 'MERGE',
6486: p_encoded_message => '# xla_mapping_set_values delete : '||l_num_rows,
6487: p_component_code => 'purge_mapping_sets');
6488: DELETE FROM xla_mapping_sets_tl
6489: WHERE amb_context_code = g_staging_context_code;
6490: l_num_rows := SQL%ROWCOUNT;
6491: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6492: trace(p_msg => '# xla_mapping_sets_tl delete : '||l_num_rows,

Line 6492: trace(p_msg => '# xla_mapping_sets_tl delete : '||l_num_rows,

6488: DELETE FROM xla_mapping_sets_tl
6489: WHERE amb_context_code = g_staging_context_code;
6490: l_num_rows := SQL%ROWCOUNT;
6491: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6492: trace(p_msg => '# xla_mapping_sets_tl delete : '||l_num_rows,
6493: p_module => l_log_module,
6494: p_level => C_LEVEL_STATEMENT);
6495: END IF;
6496: -- Bug : 9923803

Line 6503: p_encoded_message => '# xla_mapping_sets_tl delete : '||l_num_rows,

6499: p_amb_context_code => g_amb_context_code,
6500: p_application_id => g_application_id,
6501: p_request_code => 'IMPORT' ,
6502: p_log_type_code => 'MERGE',
6503: p_encoded_message => '# xla_mapping_sets_tl delete : '||l_num_rows,
6504: p_component_code => 'purge_mapping_sets');
6505: DELETE FROM xla_mapping_sets_b
6506: WHERE amb_context_code = g_staging_context_code;
6507: l_num_rows := SQL%ROWCOUNT;