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_RULE_DETAILS

Line 1590: FROM xla_seg_rule_details s

1586: ,xla_environment_pkg.g_prog_appl_id
1587: ,xla_environment_pkg.g_prog_id
1588: ,xla_environment_pkg.g_req_Id
1589: FROM (SELECT application_id
1590: FROM xla_seg_rule_details s
1591: WHERE application_id <> g_application_id
1592: AND amb_context_code = g_amb_context_code
1593: AND value_segment_rule_appl_id = g_application_id
1594: AND value_segment_rule_type_code = C_OWNER_SYSTEM

Line 1630: DELETE FROM xla_seg_rule_details d

1626: p_component_code => 'clean_oracle_adrs');
1627:
1628: -- Delete the reference to Oracle ADR to be deleted
1629: FORALL i IN 1..l_codes.COUNT
1630: DELETE FROM xla_seg_rule_details d
1631: WHERE amb_context_code = g_amb_context_code
1632: AND value_segment_rule_appl_id = g_application_id
1633: AND value_segment_rule_type_code = C_OWNER_SYSTEM
1634: AND value_segment_rule_code = l_codes(i);

Line 1697: DELETE FROM xla_seg_rule_details w

1693: p_component_code => 'clean_oracle_adrs');
1694:
1695: -- Delete the ADR
1696: FORALL i IN 1..l_codes.COUNT
1697: DELETE FROM xla_seg_rule_details w
1698: WHERE application_id = g_application_id
1699: AND amb_context_code = g_amb_context_code
1700: AND segment_rule_type_code = C_OWNER_SYSTEM
1701: AND segment_rule_code = l_codes(i);

Line 1704: trace(p_msg => '# xla_seg_rule_details deleted = '||l_num_rows,

1700: AND segment_rule_type_code = C_OWNER_SYSTEM
1701: AND segment_rule_code = l_codes(i);
1702: l_num_rows := SQL%ROWCOUNT;
1703: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1704: trace(p_msg => '# xla_seg_rule_details deleted = '||l_num_rows,
1705: p_module => l_log_module,
1706: p_level => C_LEVEL_STATEMENT);
1707: END IF;
1708: -- Bug : 9923803

Line 1715: p_encoded_message =>'# xla_seg_rule_details deleted = '||l_num_rows,

1711: p_amb_context_code => g_amb_context_code,
1712: p_application_id => g_application_id,
1713: p_request_code => 'IMPORT' ,
1714: p_log_type_code => 'MERGE',
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

Line 5531: 'XLA_SEG_RULE_DETAILS'

5527: ( segment_rule_code,
5528: table_name
5529: )
5530: select segment_rule_code,
5531: 'XLA_SEG_RULE_DETAILS'
5532: from
5533: (select segment_rule_code,
5534: 'XLA_SEG_RULE_DETAILS',
5535: amb_context_code,

Line 5534: 'XLA_SEG_RULE_DETAILS',

5530: select segment_rule_code,
5531: 'XLA_SEG_RULE_DETAILS'
5532: from
5533: (select segment_rule_code,
5534: 'XLA_SEG_RULE_DETAILS',
5535: amb_context_code,
5536: last_update_date ,
5537: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
5538: from

Line 5540: 'XLA_SEG_RULE_DETAILS',

5536: last_update_date ,
5537: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
5538: from
5539: (select segment_rule_code,
5540: 'XLA_SEG_RULE_DETAILS',
5541: amb_context_code,
5542: last_update_date ,
5543: lag(last_update_date) over (PARTITION by application_id,
5544: segment_rule_code,

Line 5549: from xla_seg_rule_details

5545: segment_rule_type_code,
5546: user_sequence
5547: order by amb_context_code
5548: ) lag_date
5549: from xla_seg_rule_details
5550: order by amb_context_code
5551: ) x
5552: where x.amb_context_code = g_staging_context_code
5553: )

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

5555: l_num_rows := SQL%ROWCOUNT;
5556:
5557:
5558: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
5559: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_seg_rule_details is :'||l_num_rows,
5560: p_module => l_log_module,
5561: p_level => C_LEVEL_PROCEDURE);
5562: END IF;
5563:

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

5567: p_amb_context_code => g_amb_context_code,
5568: p_application_id => g_application_id,
5569: p_request_code => 'IMPORT' ,
5570: p_log_type_code => 'MERGE',
5571: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_seg_rule_details is :'||l_num_rows,
5572: p_component_code => 'merge_adrs');
5573:
5574: INSERT INTO xla_aads_gt
5575: ( segment_rule_code,

Line 5634: FROM xla_seg_rule_details w

5630: DELETE FROM xla_conditions c
5631: WHERE amb_context_code = g_amb_context_code
5632: AND application_id = g_application_id
5633: AND EXISTS (SELECT 1
5634: FROM xla_seg_rule_details w
5635: WHERE c.segment_rule_detail_id = w.segment_rule_detail_id
5636: AND w.application_id = g_application_id
5637: AND w.amb_context_code = g_amb_context_code
5638: AND w.segment_rule_type_code = l_adr_type_codes(i)

Line 5657: DELETE FROM xla_seg_rule_details w

5653: p_encoded_message => '# xla_conditions delete : '||l_num_rows,
5654: p_component_code => 'merge_adrs');
5655:
5656: FORALL i IN 1..l_adr_codes.COUNT
5657: DELETE FROM xla_seg_rule_details w
5658: WHERE amb_context_code = g_amb_context_code
5659: AND application_id = g_application_id
5660: AND segment_rule_type_code = l_adr_type_codes(i)
5661: AND segment_rule_code = l_adr_codes(i);

Line 5664: trace(p_msg => '# xla_seg_rule_details delete : '||l_num_rows,

5660: AND segment_rule_type_code = l_adr_type_codes(i)
5661: AND segment_rule_code = l_adr_codes(i);
5662: l_num_rows := SQL%ROWCOUNT;
5663: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5664: trace(p_msg => '# xla_seg_rule_details delete : '||l_num_rows,
5665: p_module => l_log_module,
5666: p_level => C_LEVEL_STATEMENT);
5667: END IF;
5668: -- Bug : 9923803

Line 5675: p_encoded_message => '# xla_seg_rule_details delete : '||l_num_rows,

5671: p_amb_context_code => g_amb_context_code,
5672: p_application_id => g_application_id,
5673: p_request_code => 'IMPORT' ,
5674: p_log_type_code => 'MERGE',
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

Line 5799: UPDATE xla_seg_rule_details

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
5801: WHERE amb_context_code = g_staging_context_code
5802: AND application_id = g_application_id;
5803: l_num_rows := SQL%ROWCOUNT;

Line 5805: trace(p_msg => '# xla_seg_rule_details updated : '||l_num_rows,

5801: WHERE amb_context_code = g_staging_context_code
5802: AND application_id = g_application_id;
5803: l_num_rows := SQL%ROWCOUNT;
5804: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5805: trace(p_msg => '# xla_seg_rule_details updated : '||l_num_rows,
5806: p_module => l_log_module,
5807: p_level => C_LEVEL_STATEMENT);
5808: END IF;
5809: -- Bug : 9923803

Line 5816: p_encoded_message => '# xla_seg_rule_details updated : '||l_num_rows,

5812: p_amb_context_code => g_amb_context_code,
5813: p_application_id => g_application_id,
5814: p_request_code => 'IMPORT' ,
5815: p_log_type_code => 'MERGE',
5816: p_encoded_message => '# xla_seg_rule_details updated : '||l_num_rows,
5817: p_component_code => 'merge_adrs');
5818:
5819: UPDATE xla_conditions
5820: SET amb_context_code = g_amb_context_code

Line 6707: DELETE FROM xla_seg_rule_details

6703: p_request_code => 'IMPORT' ,
6704: p_log_type_code => 'MERGE',
6705: p_encoded_message => '# xla_conditions delete : '||l_num_rows,
6706: p_component_code => 'purge_adrs');
6707: DELETE FROM xla_seg_rule_details
6708: WHERE amb_context_code = g_staging_context_code;
6709: l_num_rows := SQL%ROWCOUNT;
6710: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6711: trace(p_msg => '# xla_seg_rules_details delete : '||l_num_rows,