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_DESC_PRIORITIES

Line 1350: , xla_desc_priorities p

1346: DELETE FROM xla_descript_details_tl w
1347: WHERE description_detail_id IN
1348: (SELECT description_detail_id
1349: FROM xla_descript_details_b d
1350: , xla_desc_priorities p
1351: WHERE d.description_prio_id = p.description_prio_id
1352: AND p.application_id = g_application_id
1353: AND p.amb_context_code = g_amb_context_code
1354: AND p.description_type_code = C_OWNER_SYSTEM

Line 1376: FROM xla_desc_priorities p

1372: FORALL i IN 1..l_codes.COUNT
1373: DELETE FROM xla_descript_details_b w
1374: WHERE description_prio_id IN
1375: (SELECT description_prio_id
1376: FROM xla_desc_priorities p
1377: WHERE p.application_id = g_application_id
1378: AND p.amb_context_code = g_amb_context_code
1379: AND p.description_type_code = C_OWNER_SYSTEM
1380: AND p.description_code = l_codes(i));

Line 1398: DELETE FROM xla_desc_priorities w

1394: p_encoded_message => '# xla_descript_details_b deleted = '||l_num_rows,
1395: p_component_code => 'clean_oracle_descriptions');
1396:
1397: FORALL i IN 1..l_codes.COUNT
1398: DELETE FROM xla_desc_priorities w
1399: WHERE application_id = g_application_id
1400: AND amb_context_code = g_amb_context_code
1401: AND description_type_code = C_OWNER_SYSTEM
1402: AND description_code = l_codes(i);

Line 1405: trace(p_msg => '# xla_desc_priorities deleted = '||l_num_rows,

1401: AND description_type_code = C_OWNER_SYSTEM
1402: AND description_code = l_codes(i);
1403: l_num_rows := SQL%ROWCOUNT;
1404: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1405: trace(p_msg => '# xla_desc_priorities deleted = '||l_num_rows,
1406: p_module => l_log_module,
1407: p_level => C_LEVEL_STATEMENT);
1408: END IF;
1409: -- Bug : 9923803

Line 1416: p_encoded_message => '# xla_desc_priorities deleted = '||l_num_rows,

1412: p_amb_context_code => g_amb_context_code,
1413: p_application_id => g_application_id,
1414: p_request_code => 'IMPORT' ,
1415: p_log_type_code => 'MERGE',
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

Line 4398: 'XLA_DESC_PRIORITIES'

4394: ( description_code,
4395: table_name
4396: )
4397: select description_code,
4398: 'XLA_DESC_PRIORITIES'
4399: from
4400: (select description_code,
4401: 'XLA_DESC_PRIORITIES',
4402: amb_context_code,

Line 4401: 'XLA_DESC_PRIORITIES',

4397: select description_code,
4398: 'XLA_DESC_PRIORITIES'
4399: from
4400: (select description_code,
4401: 'XLA_DESC_PRIORITIES',
4402: amb_context_code,
4403: last_update_date ,
4404: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
4405: from

Line 4407: 'XLA_DESC_PRIORITIES',

4403: last_update_date ,
4404: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
4405: from
4406: (select description_code,
4407: 'XLA_DESC_PRIORITIES',
4408: amb_context_code,
4409: last_update_date ,
4410: lag(last_update_date) over (PARTITION by application_id,
4411: description_code,

Line 4415: from xla_desc_priorities

4411: description_code,
4412: description_type_code
4413: order by amb_context_code
4414: ) lag_date
4415: from xla_desc_priorities
4416: order by amb_context_code
4417: ) x
4418: where x.amb_context_code = g_staging_context_code
4419: )

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

4419: )
4420: where flag = 'False';
4421: l_num_rows := SQL%ROWCOUNT;
4422: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4423: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_desc_priorities is :'||l_num_rows,
4424: p_module => l_log_module,
4425: p_level => C_LEVEL_PROCEDURE);
4426: END IF;
4427: -- Bug : 9923803

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

4430: p_amb_context_code => g_amb_context_code,
4431: p_application_id => g_application_id,
4432: p_request_code => 'IMPORT' ,
4433: p_log_type_code => 'MERGE',
4434: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_desc_priorities is :'||l_num_rows,
4435: p_component_code => 'merge_descriptions');
4436:
4437: INSERT INTO xla_aads_gt
4438: ( source_code,

Line 4447: FROM xla_desc_priorities w

4443: FROM xla_descript_details_b desc_details
4444: WHERE desc_details.amb_context_code = g_staging_context_code
4445: AND desc_details.description_prio_id IN
4446: (SELECT w.description_prio_id
4447: FROM xla_desc_priorities w
4448: ,xla_desc_priorities s
4449: WHERE s.application_id = g_application_id
4450: AND s.amb_context_code = g_staging_context_code
4451: AND w.application_id = g_application_id

Line 4448: ,xla_desc_priorities s

4444: WHERE desc_details.amb_context_code = g_staging_context_code
4445: AND desc_details.description_prio_id IN
4446: (SELECT w.description_prio_id
4447: FROM xla_desc_priorities w
4448: ,xla_desc_priorities s
4449: WHERE s.application_id = g_application_id
4450: AND s.amb_context_code = g_staging_context_code
4451: AND w.application_id = g_application_id
4452: AND w.amb_context_code = g_amb_context_code

Line 4544: DELETE FROM xla_desc_priorities w

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
4546: AND amb_context_code = g_amb_context_code
4547: AND EXISTS (SELECT 1
4548: FROM xla_desc_priorities s

Line 4548: FROM xla_desc_priorities s

4544: DELETE FROM xla_desc_priorities w
4545: WHERE application_id = g_application_id
4546: AND amb_context_code = g_amb_context_code
4547: AND EXISTS (SELECT 1
4548: FROM xla_desc_priorities s
4549: WHERE s.application_id = g_application_id
4550: AND s.amb_context_code = g_staging_context_code
4551: AND s.description_type_code = w.description_type_code
4552: AND s.description_code = w.description_code);

Line 4555: trace(p_msg => '# xla_desc_priorities delete : '||l_num_rows,

4551: AND s.description_type_code = w.description_type_code
4552: AND s.description_code = w.description_code);
4553: l_num_rows := SQL%ROWCOUNT;
4554: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4555: trace(p_msg => '# xla_desc_priorities delete : '||l_num_rows,
4556: p_module => l_log_module,
4557: p_level => C_LEVEL_STATEMENT);
4558: END IF;
4559: -- Bug : 9923803

Line 4566: p_encoded_message => '# xla_desc_priorities delete : '||l_num_rows,

4562: p_amb_context_code => g_amb_context_code,
4563: p_application_id => g_application_id,
4564: p_request_code => 'IMPORT' ,
4565: p_log_type_code => 'MERGE',
4566: p_encoded_message => '# xla_desc_priorities delete : '||l_num_rows,
4567: p_component_code => 'merge_descriptions');
4568:
4569: DELETE FROM xla_conditions
4570: WHERE description_prio_id IN

Line 4572: FROM xla_desc_priorities w

4568:
4569: DELETE FROM xla_conditions
4570: WHERE description_prio_id IN
4571: (SELECT w.description_prio_id
4572: FROM xla_desc_priorities w
4573: , xla_desc_priorities s
4574: WHERE s.application_id = g_application_id
4575: AND s.amb_context_code = g_staging_context_code
4576: AND w.application_id = g_application_id

Line 4573: , xla_desc_priorities s

4569: DELETE FROM xla_conditions
4570: WHERE description_prio_id IN
4571: (SELECT w.description_prio_id
4572: FROM xla_desc_priorities w
4573: , xla_desc_priorities s
4574: WHERE s.application_id = g_application_id
4575: AND s.amb_context_code = g_staging_context_code
4576: AND w.application_id = g_application_id
4577: AND w.amb_context_code = g_amb_context_code

Line 4600: FROM xla_desc_priorities w

4596:
4597: DELETE FROM xla_descript_details_b
4598: WHERE description_prio_id IN
4599: (SELECT w.description_prio_id
4600: FROM xla_desc_priorities w
4601: , xla_desc_priorities s
4602: WHERE s.application_id = g_application_id
4603: AND s.amb_context_code = g_staging_context_code
4604: AND w.application_id = g_application_id

Line 4601: , xla_desc_priorities s

4597: DELETE FROM xla_descript_details_b
4598: WHERE description_prio_id IN
4599: (SELECT w.description_prio_id
4600: FROM xla_desc_priorities w
4601: , xla_desc_priorities s
4602: WHERE s.application_id = g_application_id
4603: AND s.amb_context_code = g_staging_context_code
4604: AND w.application_id = g_application_id
4605: AND w.amb_context_code = g_amb_context_code

Line 4628: , xla_desc_priorities w

4624: DELETE FROM xla_descript_details_tl w
4625: WHERE description_detail_id IN
4626: (SELECT description_detail_id
4627: FROM xla_descript_details_b d
4628: , xla_desc_priorities w
4629: , xla_desc_priorities s
4630: WHERE d.description_prio_id = w.description_prio_id
4631: AND s.application_id = g_application_id
4632: AND s.amb_context_code = g_staging_context_code

Line 4629: , xla_desc_priorities s

4625: WHERE description_detail_id IN
4626: (SELECT description_detail_id
4627: FROM xla_descript_details_b d
4628: , xla_desc_priorities w
4629: , xla_desc_priorities s
4630: WHERE d.description_prio_id = w.description_prio_id
4631: AND s.application_id = g_application_id
4632: AND s.amb_context_code = g_staging_context_code
4633: AND s.application_id = g_application_id

Line 4730: UPDATE xla_desc_priorities

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
4733: AND amb_context_code = g_staging_context_code;
4734: l_num_rows := SQL%ROWCOUNT;

Line 4736: trace(p_msg => '# xla_desc_priorities updated : '||l_num_rows,

4732: WHERE application_id = g_application_id
4733: AND amb_context_code = g_staging_context_code;
4734: l_num_rows := SQL%ROWCOUNT;
4735: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4736: trace(p_msg => '# xla_desc_priorities updated : '||l_num_rows,
4737: p_module => l_log_module,
4738: p_level => C_LEVEL_STATEMENT);
4739: END IF;
4740: -- Bug : 9923803

Line 4747: p_encoded_message => '# xla_desc_priorities updated : '||l_num_rows,

4743: p_amb_context_code => g_amb_context_code,
4744: p_application_id => g_application_id,
4745: p_request_code => 'IMPORT' ,
4746: p_log_type_code => 'MERGE',
4747: p_encoded_message => '# xla_desc_priorities updated : '||l_num_rows,
4748: p_component_code => 'merge_descriptions');
4749:
4750: UPDATE xla_conditions
4751: SET amb_context_code = g_amb_context_code