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_TL

Line 1719: DELETE FROM xla_seg_rules_tl w

1715: p_encoded_message =>'# xla_seg_rule_details deleted = '||l_num_rows,
1716: p_component_code => 'clean_oracle_adrs');
1717:
1718: FORALL i IN 1..l_codes.COUNT
1719: DELETE FROM xla_seg_rules_tl w
1720: WHERE application_id = g_application_id
1721: AND amb_context_code = g_amb_context_code
1722: AND segment_rule_type_code = C_OWNER_SYSTEM
1723: AND segment_rule_code = l_codes(i);

Line 1726: trace(p_msg => '# xla_seg_rules_tl deleted = '||l_num_rows,

1722: AND segment_rule_type_code = C_OWNER_SYSTEM
1723: AND segment_rule_code = l_codes(i);
1724: l_num_rows := SQL%ROWCOUNT;
1725: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1726: trace(p_msg => '# xla_seg_rules_tl deleted = '||l_num_rows,
1727: p_module => l_log_module,
1728: p_level => C_LEVEL_STATEMENT);
1729: END IF;
1730: -- Bug : 9923803

Line 1737: p_encoded_message =>'# xla_seg_rules_tl deleted = '||l_num_rows,

1733: p_amb_context_code => g_amb_context_code,
1734: p_application_id => g_application_id,
1735: p_request_code => 'IMPORT' ,
1736: p_log_type_code => 'MERGE',
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

Line 5679: DELETE FROM xla_seg_rules_tl w

5675: p_encoded_message => '# xla_seg_rule_details delete : '||l_num_rows,
5676: p_component_code => 'merge_adrs');
5677:
5678: FORALL i IN 1..l_adr_codes.COUNT
5679: DELETE FROM xla_seg_rules_tl w
5680: WHERE amb_context_code = g_amb_context_code
5681: AND application_id = g_application_id
5682: AND segment_rule_type_code = l_adr_type_codes(i)
5683: AND segment_rule_code = l_adr_codes(i);

Line 5686: trace(p_msg => '# xla_seg_rules_tl delete : '||l_num_rows,

5682: AND segment_rule_type_code = l_adr_type_codes(i)
5683: AND segment_rule_code = l_adr_codes(i);
5684: l_num_rows := SQL%ROWCOUNT;
5685: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5686: trace(p_msg => '# xla_seg_rules_tl delete : '||l_num_rows,
5687: p_module => l_log_module,
5688: p_level => C_LEVEL_STATEMENT);
5689: END IF;
5690: -- Bug : 9923803

Line 5697: p_encoded_message => '# xla_seg_rules_tl delete : '||l_num_rows,

5693: p_amb_context_code => g_amb_context_code,
5694: p_application_id => g_application_id,
5695: p_request_code => 'IMPORT' ,
5696: p_log_type_code => 'MERGE',
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

Line 5746: UPDATE xla_seg_rules_tl w

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
5748: WHERE amb_context_code = g_staging_context_code
5749: AND application_id = g_application_id
5750: AND NOT EXISTS (SELECT 1

Line 5751: FROM xla_seg_rules_tl s

5747: SET amb_context_code = g_amb_context_code
5748: WHERE amb_context_code = g_staging_context_code
5749: AND application_id = g_application_id
5750: AND NOT EXISTS (SELECT 1
5751: FROM xla_seg_rules_tl s
5752: WHERE s.amb_context_code = g_amb_context_code
5753: AND s.segment_rule_type_code = w.segment_rule_type_code
5754: AND s.name = w.name
5755: AND s.language = w.language);

Line 5758: trace(p_msg => '# xla_seg_rules_tl 1 updated : '||l_num_rows,

5754: AND s.name = w.name
5755: AND s.language = w.language);
5756: l_num_rows := SQL%ROWCOUNT;
5757: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5758: trace(p_msg => '# xla_seg_rules_tl 1 updated : '||l_num_rows,
5759: p_module => l_log_module,
5760: p_level => C_LEVEL_STATEMENT);
5761: END IF;
5762: -- Bug : 9923803

Line 5769: p_encoded_message => '# xla_seg_rules_tl 1 updated : '||l_num_rows,

5765: p_amb_context_code => g_amb_context_code,
5766: p_application_id => g_application_id,
5767: p_request_code => 'IMPORT' ,
5768: p_log_type_code => 'MERGE',
5769: p_encoded_message => '# xla_seg_rules_tl 1 updated : '||l_num_rows,
5770: p_component_code => 'merge_adrs');
5771:
5772: UPDATE xla_seg_rules_tl w
5773: SET amb_context_code = g_amb_context_code

Line 5772: UPDATE xla_seg_rules_tl w

5768: p_log_type_code => 'MERGE',
5769: p_encoded_message => '# xla_seg_rules_tl 1 updated : '||l_num_rows,
5770: p_component_code => 'merge_adrs');
5771:
5772: UPDATE xla_seg_rules_tl w
5773: SET amb_context_code = g_amb_context_code
5774: , name = substr('('||w.segment_rule_code||') '||name,1,80)
5775: WHERE amb_context_code = g_staging_context_code
5776: AND application_id = g_application_id

Line 5778: FROM xla_seg_rules_tl s

5774: , name = substr('('||w.segment_rule_code||') '||name,1,80)
5775: WHERE amb_context_code = g_staging_context_code
5776: AND application_id = g_application_id
5777: AND EXISTS (SELECT 1
5778: FROM xla_seg_rules_tl s
5779: WHERE s.amb_context_code = g_amb_context_code
5780: AND s.segment_rule_type_code = w.segment_rule_type_code
5781: AND s.name = w.name
5782: AND s.language = w.language);

Line 5785: trace(p_msg => '# xla_seg_rules_tl 1 updated : '||l_num_rows,

5781: AND s.name = w.name
5782: AND s.language = w.language);
5783: l_num_rows := SQL%ROWCOUNT;
5784: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5785: trace(p_msg => '# xla_seg_rules_tl 1 updated : '||l_num_rows,
5786: p_module => l_log_module,
5787: p_level => C_LEVEL_STATEMENT);
5788: END IF;
5789: -- Bug : 9923803

Line 5796: p_encoded_message => '# xla_seg_rules_tl 1 updated : '||l_num_rows,

5792: p_amb_context_code => g_amb_context_code,
5793: p_application_id => g_application_id,
5794: p_request_code => 'IMPORT' ,
5795: p_log_type_code => 'MERGE',
5796: p_encoded_message => '# xla_seg_rules_tl 1 updated : '||l_num_rows,
5797: p_component_code => 'merge_adrs');
5798:
5799: UPDATE xla_seg_rule_details
5800: SET amb_context_code = g_amb_context_code

Line 6725: DELETE FROM xla_seg_rules_tl

6721: p_log_type_code => 'MERGE',
6722: p_encoded_message => '# xla_seg_rules_details delete : '||l_num_rows,
6723: p_component_code => 'purge_adrs');
6724:
6725: DELETE FROM xla_seg_rules_tl
6726: WHERE amb_context_code = g_staging_context_code;
6727: l_num_rows := SQL%ROWCOUNT;
6728: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6729: trace(p_msg => '# xla_seg_rules_tl delete : '||l_num_rows,

Line 6729: trace(p_msg => '# xla_seg_rules_tl delete : '||l_num_rows,

6725: DELETE FROM xla_seg_rules_tl
6726: WHERE amb_context_code = g_staging_context_code;
6727: l_num_rows := SQL%ROWCOUNT;
6728: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6729: trace(p_msg => '# xla_seg_rules_tl delete : '||l_num_rows,
6730: p_module => l_log_module,
6731: p_level => C_LEVEL_STATEMENT);
6732: END IF;
6733: -- Bug : 9923803

Line 6740: p_encoded_message => '# xla_seg_rules_tl delete : '||l_num_rows,

6736: p_amb_context_code => g_amb_context_code,
6737: p_application_id => g_application_id,
6738: p_request_code => 'IMPORT' ,
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;