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_B

Line 1260: FROM xla_descriptions_b work

1256: PROCEDURE clean_oracle_descriptions
1257: IS
1258: CURSOR c_all_comps IS
1259: SELECT work.description_code
1260: FROM xla_descriptions_b work
1261: WHERE work.application_id = g_application_id
1262: AND work.amb_context_code = g_amb_context_code
1263: AND work.description_type_code = C_OWNER_SYSTEM
1264: AND NOT EXISTS ( SELECT 1

Line 1265: FROM xla_descriptions_b stage

1261: WHERE work.application_id = g_application_id
1262: AND work.amb_context_code = g_amb_context_code
1263: AND work.description_type_code = C_OWNER_SYSTEM
1264: AND NOT EXISTS ( SELECT 1
1265: FROM xla_descriptions_b stage
1266: WHERE stage.application_id = g_application_id
1267: AND stage.amb_context_code = g_staging_context_code
1268: AND stage.description_type_code = C_OWNER_SYSTEM
1269: AND stage.description_code = work.description_code);

Line 1442: DELETE FROM xla_descriptions_b w

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
1443: WHERE application_id = g_application_id
1444: AND amb_context_code = g_amb_context_code
1445: AND description_type_code = C_OWNER_SYSTEM
1446: AND description_code = l_codes(i);

Line 1449: trace(p_msg => '# xla_descriptions_b deleted = '||l_num_rows,

1445: AND description_type_code = C_OWNER_SYSTEM
1446: AND description_code = l_codes(i);
1447: l_num_rows := SQL%ROWCOUNT;
1448: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1449: trace(p_msg => '# xla_descriptions_b deleted = '||l_num_rows,
1450: p_module => l_log_module,
1451: p_level => C_LEVEL_STATEMENT);
1452: END IF;
1453: -- Bug : 9923803

Line 1460: p_encoded_message =>'# xla_descriptions_b deleted = '||l_num_rows,

1456: p_amb_context_code => g_amb_context_code,
1457: p_application_id => g_application_id,
1458: p_request_code => 'IMPORT' ,
1459: p_log_type_code => 'MERGE',
1460: p_encoded_message =>'# xla_descriptions_b deleted = '||l_num_rows,
1461: p_component_code => 'clean_oracle_descriptions');
1462: END IF;
1463:
1464: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 4353: 'XLA_DESCRIPTIONS_B'

4349: (description_code,
4350: table_name
4351: )
4352: select description_code,
4353: 'XLA_DESCRIPTIONS_B'
4354: from
4355: (select description_code,
4356: 'XLA_DESCRIPTIONS_B',
4357: amb_context_code,

Line 4356: 'XLA_DESCRIPTIONS_B',

4352: select description_code,
4353: 'XLA_DESCRIPTIONS_B'
4354: from
4355: (select description_code,
4356: 'XLA_DESCRIPTIONS_B',
4357: amb_context_code,
4358: last_update_date ,
4359: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
4360: from

Line 4362: 'XLA_DESCRIPTIONS_B',

4358: last_update_date ,
4359: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
4360: from
4361: (select description_code,
4362: 'XLA_DESCRIPTIONS_B',
4363: amb_context_code,
4364: last_update_date ,
4365: lag(last_update_date) over (PARTITION by application_id,
4366: description_code,

Line 4370: from xla_descriptions_b

4366: description_code,
4367: description_type_code
4368: order by amb_context_code
4369: ) lag_date
4370: from xla_descriptions_b
4371: order by amb_context_code
4372: ) x
4373: where x.amb_context_code = g_staging_context_code
4374: )

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

4375: where flag = 'False';
4376: l_num_rows := SQL%ROWCOUNT;
4377:
4378: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4379: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_descriptions_b is :'||l_num_rows,
4380: p_module => l_log_module,
4381: p_level => C_LEVEL_PROCEDURE);
4382: END IF;
4383: -- Bug : 9923803

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

4386: p_amb_context_code => g_amb_context_code,
4387: p_application_id => g_application_id,
4388: p_request_code => 'IMPORT' ,
4389: p_log_type_code => 'MERGE',
4390: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_descriptions_b is :'||l_num_rows,
4391: p_component_code => 'merge_descriptions');
4392:
4393: INSERT INTO xla_aads_gt
4394: ( description_code,

Line 4491: DELETE FROM xla_descriptions_b w

4487: ELSE
4488:
4489: -- Delete the descriptions from the working area if it already
4490: -- exists in the staging area
4491: DELETE FROM xla_descriptions_b w
4492: WHERE application_id = g_application_id
4493: AND amb_context_code = g_amb_context_code
4494: AND EXISTS (SELECT 1
4495: FROM xla_descriptions_b s

Line 4495: FROM xla_descriptions_b s

4491: DELETE FROM xla_descriptions_b w
4492: WHERE application_id = g_application_id
4493: AND amb_context_code = g_amb_context_code
4494: AND EXISTS (SELECT 1
4495: FROM xla_descriptions_b s
4496: WHERE s.application_id = g_application_id
4497: AND s.amb_context_code = g_staging_context_code
4498: AND s.description_type_code = w.description_type_code
4499: AND s.description_code = w.description_code);

Line 4503: trace(p_msg => '# xla_descriptions_b delete : '||l_num_rows,

4499: AND s.description_code = w.description_code);
4500:
4501: l_num_rows := SQL%ROWCOUNT;
4502: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4503: trace(p_msg => '# xla_descriptions_b delete : '||l_num_rows,
4504: p_module => l_log_module,
4505: p_level => C_LEVEL_STATEMENT);
4506: END IF;
4507: -- Bug : 9923803

Line 4514: p_encoded_message => '# xla_descriptions_b delete : '||l_num_rows,

4510: p_amb_context_code => g_amb_context_code,
4511: p_application_id => g_application_id,
4512: p_request_code => 'IMPORT' ,
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

Line 4655: UPDATE xla_descriptions_b

4651: p_component_code => 'merge_descriptions');
4652: END IF;
4653:
4654: -- Move the descriptions from staging area to working area
4655: UPDATE xla_descriptions_b
4656: SET amb_context_code = g_amb_context_code
4657: WHERE application_id = g_application_id
4658: AND amb_context_code = g_staging_context_code;
4659: l_num_rows := SQL%ROWCOUNT;

Line 4661: trace(p_msg => '# xla_descriptions_b updated : '||l_num_rows,

4657: WHERE application_id = g_application_id
4658: AND amb_context_code = g_staging_context_code;
4659: l_num_rows := SQL%ROWCOUNT;
4660: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4661: trace(p_msg => '# xla_descriptions_b updated : '||l_num_rows,
4662: p_module => l_log_module,
4663: p_level => C_LEVEL_STATEMENT);
4664: END IF;
4665: -- Bug : 9923803

Line 4672: p_encoded_message => '# xla_descriptions_b updated : '||l_num_rows,

4668: p_amb_context_code => g_amb_context_code,
4669: p_application_id => g_application_id,
4670: p_request_code => 'IMPORT' ,
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