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_DESCRIPTIONS_TL

Line 1420: DELETE FROM xla_descriptions_tl w

1416: p_encoded_message => '# xla_desc_priorities deleted = '||l_num_rows,
1417: p_component_code => 'clean_oracle_descriptions');
1418:
1419: FORALL i IN 1..l_codes.COUNT
1420: DELETE FROM xla_descriptions_tl w
1421: WHERE application_id = g_application_id
1422: AND amb_context_code = g_amb_context_code
1423: AND description_type_code = C_OWNER_SYSTEM
1424: AND description_code = l_codes(i);

Line 1427: trace(p_msg => '# xla_descriptions_tl deleted = '||l_num_rows,

1423: AND description_type_code = C_OWNER_SYSTEM
1424: AND description_code = l_codes(i);
1425: l_num_rows := SQL%ROWCOUNT;
1426: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1427: trace(p_msg => '# xla_descriptions_tl deleted = '||l_num_rows,
1428: p_module => l_log_module,
1429: p_level => C_LEVEL_STATEMENT);
1430: END IF;
1431: -- Bug : 9923803

Line 1438: p_encoded_message => '# xla_descriptions_tl deleted = '||l_num_rows,

1434: p_amb_context_code => g_amb_context_code,
1435: p_application_id => g_application_id,
1436: p_request_code => 'IMPORT' ,
1437: p_log_type_code => 'MERGE',
1438: p_encoded_message => '# xla_descriptions_tl deleted = '||l_num_rows,
1439: p_component_code => 'clean_oracle_descriptions');
1440:
1441: FORALL i IN 1..l_codes.COUNT
1442: DELETE FROM xla_descriptions_b w

Line 4517: DELETE FROM xla_descriptions_tl w

4513: p_log_type_code => 'MERGE',
4514: p_encoded_message => '# xla_descriptions_b delete : '||l_num_rows,
4515: p_component_code => 'merge_descriptions');
4516:
4517: DELETE FROM xla_descriptions_tl w
4518: WHERE application_id = g_application_id
4519: AND amb_context_code = g_amb_context_code
4520: AND EXISTS (SELECT 1
4521: FROM xla_descriptions_tl s

Line 4521: FROM xla_descriptions_tl s

4517: DELETE FROM xla_descriptions_tl w
4518: WHERE application_id = g_application_id
4519: AND amb_context_code = g_amb_context_code
4520: AND EXISTS (SELECT 1
4521: FROM xla_descriptions_tl s
4522: WHERE s.application_id = g_application_id
4523: AND s.amb_context_code = g_staging_context_code
4524: AND s.description_type_code = w.description_type_code
4525: AND s.description_code = w.description_code

Line 4530: trace(p_msg => '# xla_descriptions_tl delete : '||l_num_rows,

4526: AND s.language = w.language);
4527: l_num_rows := SQL%ROWCOUNT;
4528:
4529: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4530: trace(p_msg => '# xla_descriptions_tl delete : '||l_num_rows,
4531: p_module => l_log_module,
4532: p_level => C_LEVEL_STATEMENT);
4533: END IF;
4534: -- Bug : 9923803

Line 4541: p_encoded_message => '# xla_descriptions_tl delete : '||l_num_rows,

4537: p_amb_context_code => g_amb_context_code,
4538: p_application_id => g_application_id,
4539: p_request_code => 'IMPORT' ,
4540: p_log_type_code => 'MERGE',
4541: p_encoded_message => '# xla_descriptions_tl delete : '||l_num_rows,
4542: p_component_code => 'merge_descriptions');
4543:
4544: DELETE FROM xla_desc_priorities w
4545: WHERE application_id = g_application_id

Line 4675: UPDATE xla_descriptions_tl w

4671: p_log_type_code => 'MERGE',
4672: p_encoded_message => '# xla_descriptions_b updated : '||l_num_rows,
4673: p_component_code => 'merge_descriptions');
4674:
4675: UPDATE xla_descriptions_tl w
4676: SET amb_context_code = g_amb_context_code
4677: WHERE application_id = g_application_id
4678: AND amb_context_code = g_staging_context_code
4679: AND NOT EXISTS (SELECT 1

Line 4680: FROM xla_descriptions_tl s

4676: SET amb_context_code = g_amb_context_code
4677: WHERE application_id = g_application_id
4678: AND amb_context_code = g_staging_context_code
4679: AND NOT EXISTS (SELECT 1
4680: FROM xla_descriptions_tl s
4681: WHERE s.application_id = g_application_id
4682: AND s.amb_context_code = g_amb_context_code
4683: AND s.description_type_code = w.description_type_code
4684: AND s.name = w.name

Line 4688: trace(p_msg => '# xla_descriptions_tl 1 updated : '||l_num_rows,

4684: AND s.name = w.name
4685: AND s.language = w.language);
4686: l_num_rows := SQL%ROWCOUNT;
4687: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4688: trace(p_msg => '# xla_descriptions_tl 1 updated : '||l_num_rows,
4689: p_module => l_log_module,
4690: p_level => C_LEVEL_STATEMENT);
4691: END IF;
4692: -- Bug : 9923803

Line 4699: p_encoded_message => '# xla_descriptions_tl 1 updated : '||l_num_rows,

4695: p_amb_context_code => g_amb_context_code,
4696: p_application_id => g_application_id,
4697: p_request_code => 'IMPORT' ,
4698: p_log_type_code => 'MERGE',
4699: p_encoded_message => '# xla_descriptions_tl 1 updated : '||l_num_rows,
4700: p_component_code => 'merge_descriptions');
4701:
4702: UPDATE xla_descriptions_tl w
4703: SET amb_context_code = g_amb_context_code

Line 4702: UPDATE xla_descriptions_tl w

4698: p_log_type_code => 'MERGE',
4699: p_encoded_message => '# xla_descriptions_tl 1 updated : '||l_num_rows,
4700: p_component_code => 'merge_descriptions');
4701:
4702: UPDATE xla_descriptions_tl w
4703: SET amb_context_code = g_amb_context_code
4704: , name = substr('('||w.description_code||') '||name,1,80)
4705: WHERE application_id = g_application_id
4706: AND amb_context_code = g_staging_context_code

Line 4708: FROM xla_descriptions_tl s

4704: , name = substr('('||w.description_code||') '||name,1,80)
4705: WHERE application_id = g_application_id
4706: AND amb_context_code = g_staging_context_code
4707: AND EXISTS (SELECT 1
4708: FROM xla_descriptions_tl s
4709: WHERE s.application_id = g_application_id
4710: AND s.amb_context_code = g_amb_context_code
4711: AND s.description_type_code = w.description_type_code
4712: AND s.name = w.name

Line 4717: trace(p_msg => '# xla_descriptions_tl 2 updated : '||l_num_rows,

4713: AND s.language = w.language);
4714: l_num_rows := SQL%ROWCOUNT;
4715:
4716: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4717: trace(p_msg => '# xla_descriptions_tl 2 updated : '||l_num_rows,
4718: p_module => l_log_module,
4719: p_level => C_LEVEL_STATEMENT);
4720: END IF;
4721: -- Bug : 9923803

Line 4728: p_encoded_message => '# xla_descriptions_tl 2 updated : '||l_num_rows,

4724: p_amb_context_code => g_amb_context_code,
4725: p_application_id => g_application_id,
4726: p_request_code => 'IMPORT' ,
4727: p_log_type_code => 'MERGE',
4728: p_encoded_message => '# xla_descriptions_tl 2 updated : '||l_num_rows,
4729: p_component_code => 'merge_descriptions');
4730: UPDATE xla_desc_priorities
4731: SET amb_context_code = g_amb_context_code
4732: WHERE application_id = g_application_id