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_SEG_RULES_B

Line 1495: FROM xla_seg_rules_b work

1491: IS
1492: -- Retrieve the Oracle adr to be deleted
1493: CURSOR c_all_comps IS
1494: SELECT work.segment_rule_code
1495: FROM xla_seg_rules_b work
1496: WHERE work.application_id = g_application_id
1497: AND work.amb_context_code = g_amb_context_code
1498: AND work.segment_rule_type_code = C_OWNER_SYSTEM
1499: AND NOT EXISTS

Line 1501: FROM xla_seg_rules_b stage

1497: AND work.amb_context_code = g_amb_context_code
1498: AND work.segment_rule_type_code = C_OWNER_SYSTEM
1499: AND NOT EXISTS
1500: (SELECT 1
1501: FROM xla_seg_rules_b stage
1502: WHERE stage.application_id = g_application_id
1503: AND stage.amb_context_code = g_staging_context_code
1504: AND stage.segment_rule_type_code = C_OWNER_SYSTEM
1505: AND stage.segment_rule_code = work.segment_rule_code);

Line 1741: DELETE FROM xla_seg_rules_b w

1737: p_encoded_message =>'# xla_seg_rules_tl deleted = '||l_num_rows,
1738: p_component_code => 'clean_oracle_adrs');
1739:
1740: FORALL i IN 1..l_codes.COUNT
1741: DELETE FROM xla_seg_rules_b w
1742: WHERE application_id = g_application_id
1743: AND amb_context_code = g_amb_context_code
1744: AND segment_rule_type_code = C_OWNER_SYSTEM
1745: AND segment_rule_code = l_codes(i);

Line 1748: trace(p_msg => '#xla_seg_rules_b deleted = '||l_num_rows,

1744: AND segment_rule_type_code = C_OWNER_SYSTEM
1745: AND segment_rule_code = l_codes(i);
1746: l_num_rows := SQL%ROWCOUNT;
1747: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1748: trace(p_msg => '#xla_seg_rules_b deleted = '||l_num_rows,
1749: p_module => l_log_module,
1750: p_level => C_LEVEL_STATEMENT);
1751: END IF;
1752: -- Bug : 9923803

Line 1759: p_encoded_message =>'#xla_seg_rules_b deleted = '||l_num_rows,

1755: p_amb_context_code => g_amb_context_code,
1756: p_application_id => g_application_id,
1757: p_request_code => 'IMPORT' ,
1758: p_log_type_code => 'MERGE',
1759: p_encoded_message =>'#xla_seg_rules_b deleted = '||l_num_rows,
1760: p_component_code => 'clean_oracle_adrs');
1761: END IF;
1762:
1763: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 5498: FROM xla_seg_rules_b w

5494: PROCEDURE merge_adrs
5495: IS
5496: CURSOR c_adr IS
5497: SELECT s.segment_rule_type_code, s.segment_rule_code
5498: FROM xla_seg_rules_b w
5499: , xla_seg_rules_b s
5500: WHERE s.application_id = g_application_id
5501: AND s.amb_context_code = g_staging_context_code
5502: AND s.segment_rule_type_code = w.segment_rule_type_code

Line 5499: , xla_seg_rules_b s

5495: IS
5496: CURSOR c_adr IS
5497: SELECT s.segment_rule_type_code, s.segment_rule_code
5498: FROM xla_seg_rules_b w
5499: , xla_seg_rules_b s
5500: WHERE s.application_id = g_application_id
5501: AND s.amb_context_code = g_staging_context_code
5502: AND s.segment_rule_type_code = w.segment_rule_type_code
5503: AND s.segment_rule_code = w.segment_rule_code

Line 5579: 'XLA_SEG_RULES_B'

5575: ( segment_rule_code,
5576: table_name
5577: )
5578: select segment_rule_code,
5579: 'XLA_SEG_RULES_B'
5580: from
5581: (select segment_rule_code,
5582: 'XLA_SEG_RULES_B',
5583: amb_context_code,

Line 5582: 'XLA_SEG_RULES_B',

5578: select segment_rule_code,
5579: 'XLA_SEG_RULES_B'
5580: from
5581: (select segment_rule_code,
5582: 'XLA_SEG_RULES_B',
5583: amb_context_code,
5584: last_update_date ,
5585: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
5586: from

Line 5588: 'XLA_SEG_RULES_B',

5584: last_update_date ,
5585: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
5586: from
5587: (select segment_rule_code,
5588: 'XLA_SEG_RULES_B',
5589: amb_context_code,
5590: last_update_date ,
5591: lag(last_update_date) over (PARTITION by application_id,
5592: segment_rule_code,

Line 5596: from xla_seg_rules_b

5592: segment_rule_code,
5593: segment_rule_type_code
5594: order by amb_context_code
5595: ) lag_date
5596: from xla_seg_rules_b
5597: order by amb_context_code
5598: ) x
5599: where x.amb_context_code = g_staging_context_code
5600: )

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

5600: )
5601: where flag = 'False';
5602: l_num_rows := SQL%ROWCOUNT;
5603: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
5604: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_seg_rules_b is :'||l_num_rows,
5605: p_module => l_log_module,
5606: p_level => C_LEVEL_PROCEDURE);
5607: END IF;
5608: -- Bug : 9923803

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

5611: p_amb_context_code => g_amb_context_code,
5612: p_application_id => g_application_id,
5613: p_request_code => 'IMPORT' ,
5614: p_log_type_code => 'MERGE',
5615: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_seg_rules_b is :'||l_num_rows,
5616: p_component_code => 'merge_adrs');
5617:
5618: IF (g_analyzed_flag = 'Y') THEN
5619: null;

Line 5701: DELETE FROM xla_seg_rules_b w

5697: p_encoded_message => '# xla_seg_rules_tl delete : '||l_num_rows,
5698: p_component_code => 'merge_adrs');
5699:
5700: FORALL i IN 1..l_adr_codes.COUNT
5701: DELETE FROM xla_seg_rules_b w
5702: WHERE amb_context_code = g_amb_context_code
5703: AND application_id = g_application_id
5704: AND segment_rule_type_code = l_adr_type_codes(i)
5705: AND segment_rule_code = l_adr_codes(i);

Line 5708: trace(p_msg => '# xla_seg_rules_b delete : '||l_num_rows,

5704: AND segment_rule_type_code = l_adr_type_codes(i)
5705: AND segment_rule_code = l_adr_codes(i);
5706: l_num_rows := SQL%ROWCOUNT;
5707: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5708: trace(p_msg => '# xla_seg_rules_b delete : '||l_num_rows,
5709: p_module => l_log_module,
5710: p_level => C_LEVEL_STATEMENT);
5711: END IF;
5712: -- Bug : 9923803

Line 5719: p_encoded_message => '# xla_seg_rules_b delete : '||l_num_rows,

5715: p_amb_context_code => g_amb_context_code,
5716: p_application_id => g_application_id,
5717: p_request_code => 'IMPORT' ,
5718: p_log_type_code => 'MERGE',
5719: p_encoded_message => '# xla_seg_rules_b delete : '||l_num_rows,
5720: p_component_code => 'merge_adrs');
5721: END IF;
5722:
5723: END IF;

Line 5726: UPDATE xla_seg_rules_b

5722:
5723: END IF;
5724:
5725: -- Move the ADRs from staging area to working area
5726: UPDATE xla_seg_rules_b
5727: SET amb_context_code = g_amb_context_code
5728: WHERE amb_context_code = g_staging_context_code
5729: AND application_id = g_application_id;
5730: l_num_rows := SQL%ROWCOUNT;

Line 5732: trace(p_msg => '# xla_seg_rules_b updated : '||l_num_rows,

5728: WHERE amb_context_code = g_staging_context_code
5729: AND application_id = g_application_id;
5730: l_num_rows := SQL%ROWCOUNT;
5731: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5732: trace(p_msg => '# xla_seg_rules_b updated : '||l_num_rows,
5733: p_module => l_log_module,
5734: p_level => C_LEVEL_STATEMENT);
5735: END IF;
5736: -- Bug : 9923803

Line 5743: p_encoded_message => '# xla_seg_rules_b updated : '||l_num_rows,

5739: p_amb_context_code => g_amb_context_code,
5740: p_application_id => g_application_id,
5741: p_request_code => 'IMPORT' ,
5742: p_log_type_code => 'MERGE',
5743: p_encoded_message => '# xla_seg_rules_b updated : '||l_num_rows,
5744: p_component_code => 'merge_adrs');
5745:
5746: UPDATE xla_seg_rules_tl w
5747: SET amb_context_code = g_amb_context_code

Line 6743: DELETE FROM xla_seg_rules_b

6739: p_log_type_code => 'MERGE',
6740: p_encoded_message => '# xla_seg_rules_tl delete : '||l_num_rows,
6741: p_component_code => 'purge_adrs');
6742:
6743: DELETE FROM xla_seg_rules_b
6744: WHERE amb_context_code = g_staging_context_code;
6745: l_num_rows := SQL%ROWCOUNT;
6746: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6747: trace(p_msg => '# xla_seg_rules_b delete : '||l_num_rows,

Line 6747: trace(p_msg => '# xla_seg_rules_b delete : '||l_num_rows,

6743: DELETE FROM xla_seg_rules_b
6744: WHERE amb_context_code = g_staging_context_code;
6745: l_num_rows := SQL%ROWCOUNT;
6746: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6747: trace(p_msg => '# xla_seg_rules_b delete : '||l_num_rows,
6748: p_module => l_log_module,
6749: p_level => C_LEVEL_STATEMENT);
6750: END IF;
6751: -- Bug : 9923803

Line 6758: p_encoded_message => '# xla_seg_rules_b delete : '||l_num_rows,

6754: p_amb_context_code => g_amb_context_code,
6755: p_application_id => g_application_id,
6756: p_request_code => 'IMPORT' ,
6757: p_log_type_code => 'MERGE',
6758: p_encoded_message => '# xla_seg_rules_b delete : '||l_num_rows,
6759: p_component_code => 'purge_adrs');
6760:
6761: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
6762: trace(p_msg => 'END of procedure purge_adrs',