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_CONDITIONS

Line 4016: ,'xla_conditions'

4012: select condn.entity_code
4013: ,condn.event_class_code
4014: ,condn.accounting_line_code
4015: ,condn.source_code
4016: ,'xla_conditions'
4017: from xla_conditions condn
4018: where condn.application_id = g_application_id
4019: and condn.amb_context_code = g_staging_context_code
4020: and EXISTS (SELECT 1

Line 4017: from xla_conditions condn

4013: ,condn.event_class_code
4014: ,condn.accounting_line_code
4015: ,condn.source_code
4016: ,'xla_conditions'
4017: from xla_conditions condn
4018: where condn.application_id = g_application_id
4019: and condn.amb_context_code = g_staging_context_code
4020: and EXISTS (SELECT 1
4021: FROM xla_acct_line_types_b s

Line 4028: FROM xla_conditions condn1

4024: and s.event_class_code = condn.event_class_code
4025: and s.accounting_line_type_code = condn.accounting_line_type_code
4026: and s.accounting_line_code = condn.accounting_line_code)
4027: and (EXISTS(SELECT 1
4028: FROM xla_conditions condn1
4029: WHERE condn.entity_code = condn1.entity_code
4030: and condn.event_class_code = condn1.event_class_code
4031: and condn.accounting_line_code = condn1.accounting_line_code
4032: and condn.accounting_line_type_code = condn1.accounting_line_type_code

Line 4042: FROM xla_conditions condn1

4038: and to_char(condn.last_update_date,'DD-MON-YYYY') <> to_char(condn1.last_update_date,'DD-MON-YYYY')
4039: )
4040: OR
4041: NOT EXISTS(SELECT 1
4042: FROM xla_conditions condn1
4043: WHERE nvl(condn.entity_code,' ') = nvl(condn1.entity_code,' ')
4044: and nvl(condn.event_class_code,' ') = nvl(condn1.event_class_code,' ')
4045: and nvl(condn.accounting_line_code,' ') = nvl(condn1.accounting_line_code,' ')
4046: and nvl(condn.accounting_line_type_code,' ') = nvl(condn1.accounting_line_type_code,' ')

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

4052: )
4053: );
4054: l_num_rows := SQL%ROWCOUNT;
4055: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4056: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_conditions is :'||l_num_rows,
4057: p_module => l_log_module,
4058: p_level => C_LEVEL_PROCEDURE);
4059: END IF;
4060: -- Bug : 9923803

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

4063: p_amb_context_code => g_amb_context_code,
4064: p_application_id => g_application_id,
4065: p_request_code => 'IMPORT' ,
4066: p_log_type_code => 'MERGE',
4067: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_conditions is :'||l_num_rows,
4068: p_component_code => 'merge_journal_line_types');
4069:
4070: IF (g_analyzed_flag = 'Y') THEN
4071: null;

Line 4156: DELETE FROM xla_conditions w

4152: p_log_type_code => 'MERGE',
4153: p_encoded_message => '# xla_jlt_acct_attrs delete : '||l_num_rows,
4154: p_component_code => 'merge_journal_line_types');
4155:
4156: DELETE FROM xla_conditions w
4157: WHERE application_id = g_application_id
4158: AND amb_context_code = g_amb_context_code
4159: AND EXISTS (SELECT 1
4160: FROM xla_acct_line_types_b s

Line 4282: UPDATE xla_conditions

4278: p_log_type_code => 'MERGE',
4279: p_encoded_message => '# xla_jlt_acct_attrs updated : '||l_num_rows,
4280: p_component_code => 'merge_journal_line_types');
4281:
4282: UPDATE xla_conditions
4283: SET amb_context_code = g_amb_context_code
4284: WHERE amb_context_code = g_staging_context_code
4285: AND application_id = g_application_id
4286: AND accounting_line_code IS NOT NULL;

Line 4289: trace(p_msg => '# xla_conditions updated : '||l_num_rows,

4285: AND application_id = g_application_id
4286: AND accounting_line_code IS NOT NULL;
4287: l_num_rows := SQL%ROWCOUNT;
4288: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4289: trace(p_msg => '# xla_conditions updated : '||l_num_rows,
4290: p_module => l_log_module,
4291: p_level => C_LEVEL_STATEMENT);
4292: END IF;
4293: -- Bug : 9923803

Line 4300: p_encoded_message => '# xla_conditions updated : '||l_num_rows,

4296: p_amb_context_code => g_amb_context_code,
4297: p_application_id => g_application_id,
4298: p_request_code => 'IMPORT' ,
4299: p_log_type_code => 'MERGE',
4300: p_encoded_message => '# xla_conditions updated : '||l_num_rows,
4301: p_component_code => 'merge_journal_line_types');
4302:
4303: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4304: trace(p_msg => 'END of procedure merge_journal_line_types',

Line 4569: DELETE FROM xla_conditions

4565: p_log_type_code => 'MERGE',
4566: p_encoded_message => '# xla_desc_priorities delete : '||l_num_rows,
4567: p_component_code => 'merge_descriptions');
4568:
4569: DELETE FROM xla_conditions
4570: WHERE description_prio_id IN
4571: (SELECT w.description_prio_id
4572: FROM xla_desc_priorities w
4573: , xla_desc_priorities s

Line 4583: trace(p_msg => '# xla_conditions delete : '||l_num_rows,

4579: AND w.description_code = s.description_code);
4580: l_num_rows := SQL%ROWCOUNT;
4581:
4582: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4583: trace(p_msg => '# xla_conditions delete : '||l_num_rows,
4584: p_module => l_log_module,
4585: p_level => C_LEVEL_STATEMENT);
4586: END IF;
4587: -- Bug : 9923803

Line 4594: p_encoded_message => '# xla_conditions delete : '||l_num_rows,

4590: p_amb_context_code => g_amb_context_code,
4591: p_application_id => g_application_id,
4592: p_request_code => 'IMPORT' ,
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

Line 4750: UPDATE xla_conditions

4746: p_log_type_code => 'MERGE',
4747: p_encoded_message => '# xla_desc_priorities updated : '||l_num_rows,
4748: p_component_code => 'merge_descriptions');
4749:
4750: UPDATE xla_conditions
4751: SET amb_context_code = g_amb_context_code
4752: WHERE amb_context_code = g_staging_context_code
4753: AND application_id = g_application_id
4754: AND description_prio_id IS NOT NULL;

Line 4757: trace(p_msg => '# xla_conditions updated : '||l_num_rows,

4753: AND application_id = g_application_id
4754: AND description_prio_id IS NOT NULL;
4755: l_num_rows := SQL%ROWCOUNT;
4756: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4757: trace(p_msg => '# xla_conditions updated : '||l_num_rows,
4758: p_module => l_log_module,
4759: p_level => C_LEVEL_STATEMENT);
4760: END IF;
4761: -- Bug : 9923803

Line 4768: p_encoded_message => '# xla_conditions updated : '||l_num_rows,

4764: p_amb_context_code => g_amb_context_code,
4765: p_application_id => g_application_id,
4766: p_request_code => 'IMPORT' ,
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

Line 5630: DELETE FROM xla_conditions c

5626:
5627: IF (l_adr_codes.COUNT > 0) THEN
5628: -- Delete the ADRs from the working area to be merged
5629: FORALL i IN 1..l_adr_codes.COUNT
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

Line 5642: trace(p_msg => '# xla_conditions delete : '||l_num_rows,

5638: AND w.segment_rule_type_code = l_adr_type_codes(i)
5639: AND w.segment_rule_code = l_adr_codes(i));
5640: l_num_rows := SQL%ROWCOUNT;
5641: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5642: trace(p_msg => '# xla_conditions delete : '||l_num_rows,
5643: p_module => l_log_module,
5644: p_level => C_LEVEL_STATEMENT);
5645: END IF;
5646: -- Bug : 9923803

Line 5653: p_encoded_message => '# xla_conditions delete : '||l_num_rows,

5649: p_amb_context_code => g_amb_context_code,
5650: p_application_id => g_application_id,
5651: p_request_code => 'IMPORT' ,
5652: p_log_type_code => 'MERGE',
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

Line 5819: UPDATE xla_conditions

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
5821: WHERE amb_context_code = g_staging_context_code
5822: AND application_id = g_application_id
5823: AND segment_rule_detail_id IS NOT NULL;

Line 5826: trace(p_msg => '# xla_conditions updated : '||l_num_rows,

5822: AND application_id = g_application_id
5823: AND segment_rule_detail_id IS NOT NULL;
5824: l_num_rows := SQL%ROWCOUNT;
5825: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5826: trace(p_msg => '# xla_conditions updated : '||l_num_rows,
5827: p_module => l_log_module,
5828: p_level => C_LEVEL_STATEMENT);
5829: END IF;
5830: -- Bug : 9923803

Line 5837: p_encoded_message => '# xla_conditions updated : '||l_num_rows,

5833: p_amb_context_code => g_amb_context_code,
5834: p_application_id => g_application_id,
5835: p_request_code => 'IMPORT' ,
5836: p_log_type_code => 'MERGE',
5837: p_encoded_message => '# xla_conditions updated : '||l_num_rows,
5838: p_component_code => 'merge_adrs');
5839:
5840: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
5841: trace(p_msg => 'END of procedure merge_adrs',

Line 5923: p_encoded_message => '# xla_conditions updated : '||l_num_rows,

5919: p_amb_context_code => g_amb_context_code,
5920: p_application_id => g_application_id,
5921: p_request_code => 'IMPORT' ,
5922: p_log_type_code => 'MERGE',
5923: p_encoded_message => '# xla_conditions updated : '||l_num_rows,
5924: p_component_code => 'merge_mapping_sets');
5925:
5926: FORALL i in 1 .. l_ms.count
5927: DELETE FROM xla_mapping_sets_tl w

Line 6689: DELETE FROM xla_conditions

6685: p_module => l_log_module,
6686: p_level => C_LEVEL_PROCEDURE);
6687: END IF;
6688:
6689: DELETE FROM xla_conditions
6690: WHERE amb_context_code = g_staging_context_code
6691: AND segment_rule_detail_id IS NOT NULl;
6692: l_num_rows := SQL%ROWCOUNT;
6693: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 6694: trace(p_msg => '# xla_conditions delete : '||l_num_rows,

6690: WHERE amb_context_code = g_staging_context_code
6691: AND segment_rule_detail_id IS NOT NULl;
6692: l_num_rows := SQL%ROWCOUNT;
6693: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6694: trace(p_msg => '# xla_conditions delete : '||l_num_rows,
6695: p_module => l_log_module,
6696: p_level => C_LEVEL_STATEMENT);
6697: END IF;
6698: -- Bug : 9923803

Line 6705: p_encoded_message => '# xla_conditions delete : '||l_num_rows,

6701: p_amb_context_code => g_amb_context_code,
6702: p_application_id => g_application_id,
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;