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_DESCRIPT_DETAILS_B

Line 1349: FROM xla_descript_details_b d

1345: FORALL i IN 1..l_codes.COUNT
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

Line 1373: DELETE FROM xla_descript_details_b w

1369: p_encoded_message => '# xla_descript_details_tl deleted = '||l_num_rows,
1370: p_component_code => 'clean_oracle_descriptions');
1371:
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

Line 1383: trace(p_msg => '# xla_descript_details_b deleted = '||l_num_rows,

1379: AND p.description_type_code = C_OWNER_SYSTEM
1380: AND p.description_code = l_codes(i));
1381: l_num_rows := SQL%ROWCOUNT;
1382: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1383: trace(p_msg => '# xla_descript_details_b deleted = '||l_num_rows,
1384: p_module => l_log_module,
1385: p_level => C_LEVEL_STATEMENT);
1386: END IF;
1387: -- Bug : 9923803

Line 1394: p_encoded_message => '# xla_descript_details_b deleted = '||l_num_rows,

1390: p_amb_context_code => g_amb_context_code,
1391: p_application_id => g_application_id,
1392: p_request_code => 'IMPORT' ,
1393: p_log_type_code => 'MERGE',
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

Line 4442: 'xla_descript_details_b'

4438: ( source_code,
4439: table_name
4440: )
4441: SELECT desc_details.source_code,
4442: 'xla_descript_details_b'
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

Line 4443: FROM xla_descript_details_b desc_details

4439: table_name
4440: )
4441: SELECT desc_details.source_code,
4442: 'xla_descript_details_b'
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

Line 4456: FROM xla_descript_details_b desc_details1

4452: AND w.amb_context_code = g_amb_context_code
4453: AND w.description_type_code = s.description_type_code
4454: AND w.description_code = s.description_code)
4455: AND (EXISTS (SELECT 1
4456: FROM xla_descript_details_b desc_details1
4457: WHERE desc_details1.amb_context_code = g_amb_context_code
4458: AND desc_details.description_prio_id = desc_details1.description_prio_id
4459: AND to_char(desc_details.last_update_date,'DD-MON-YYYY') <> to_char(desc_details1.last_update_date,'DD-MON-YYYY')
4460: )

Line 4463: FROM xla_descript_details_b desc_details1

4459: AND to_char(desc_details.last_update_date,'DD-MON-YYYY') <> to_char(desc_details1.last_update_date,'DD-MON-YYYY')
4460: )
4461: OR
4462: NOT EXISTS (SELECT 1
4463: FROM xla_descript_details_b desc_details1
4464: WHERE desc_details1.amb_context_code = g_amb_context_code
4465: AND desc_details.description_prio_id = desc_details1.description_prio_id
4466: )
4467: );

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

4466: )
4467: );
4468: l_num_rows := SQL%ROWCOUNT;
4469: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4470: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_descript_details_b is :'||l_num_rows,
4471: p_module => l_log_module,
4472: p_level => C_LEVEL_PROCEDURE);
4473: END IF;
4474: -- Bug : 9923803

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

4477: p_amb_context_code => g_amb_context_code,
4478: p_application_id => g_application_id,
4479: p_request_code => 'IMPORT' ,
4480: p_log_type_code => 'MERGE',
4481: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_descript_details_b is :'||l_num_rows,
4482: p_component_code => 'merge_descriptions');
4483:
4484: IF (g_analyzed_flag = 'Y') THEN
4485: null;

Line 4597: DELETE FROM xla_descript_details_b

4593: p_log_type_code => 'MERGE',
4594: p_encoded_message => '# xla_conditions delete : '||l_num_rows,
4595: p_component_code => 'merge_descriptions');
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

Line 4610: trace(p_msg => '# xla_descript_details_b delete : '||l_num_rows,

4606: AND w.description_type_code = s.description_type_code
4607: AND w.description_code = s.description_code);
4608: l_num_rows := SQL%ROWCOUNT;
4609: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4610: trace(p_msg => '# xla_descript_details_b delete : '||l_num_rows,
4611: p_module => l_log_module,
4612: p_level => C_LEVEL_STATEMENT);
4613: END IF;
4614: -- Bug : 9923803

Line 4621: p_encoded_message => '# xla_descript_details_b delete : '||l_num_rows,

4617: p_amb_context_code => g_amb_context_code,
4618: p_application_id => g_application_id,
4619: p_request_code => 'IMPORT' ,
4620: p_log_type_code => 'MERGE',
4621: p_encoded_message => '# xla_descript_details_b delete : '||l_num_rows,
4622: p_component_code => 'merge_descriptions');
4623:
4624: DELETE FROM xla_descript_details_tl w
4625: WHERE description_detail_id IN

Line 4627: FROM xla_descript_details_b d

4623:
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

Line 4771: UPDATE xla_descript_details_b

4767: p_log_type_code => 'MERGE',
4768: p_encoded_message => '# xla_conditions updated : '||l_num_rows,
4769: p_component_code => 'merge_descriptions');
4770:
4771: UPDATE xla_descript_details_b
4772: SET amb_context_code = g_amb_context_code
4773: WHERE amb_context_code = g_staging_context_code;
4774: l_num_rows := SQL%ROWCOUNT;
4775: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 4776: trace(p_msg => '# xla_descript_details_b updated : '||l_num_rows,

4772: SET amb_context_code = g_amb_context_code
4773: WHERE amb_context_code = g_staging_context_code;
4774: l_num_rows := SQL%ROWCOUNT;
4775: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4776: trace(p_msg => '# xla_descript_details_b updated : '||l_num_rows,
4777: p_module => l_log_module,
4778: p_level => C_LEVEL_STATEMENT);
4779: END IF;
4780: -- Bug : 9923803

Line 4787: p_encoded_message => '# xla_descript_details_b updated : '||l_num_rows,

4783: p_amb_context_code => g_amb_context_code,
4784: p_application_id => g_application_id,
4785: p_request_code => 'IMPORT' ,
4786: p_log_type_code => 'MERGE',
4787: p_encoded_message => '# xla_descript_details_b updated : '||l_num_rows,
4788: p_component_code => 'merge_descriptions');
4789:
4790: UPDATE xla_descript_details_tl
4791: SET amb_context_code = g_amb_context_code