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_JLT_ACCT_ATTRS

Line 1153: DELETE FROM xla_jlt_acct_attrs w

1149: p_encoded_message => '# xla_line_defn_jlt_assgns deleted = '||l_num_rows,
1150: p_component_code => 'clean_oracle_jlts');
1151:
1152: FORALL i IN 1..l_codes.COUNT
1153: DELETE FROM xla_jlt_acct_attrs w
1154: WHERE application_id = g_application_id
1155: AND amb_context_code = g_amb_context_code
1156: AND event_class_code = l_event_class_codes(i)
1157: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 1162: trace(p_msg => '# xla_jlt_acct_attrs deleted = '||l_num_rows,

1158: AND accounting_line_code = l_codes(i);
1159: l_num_rows := SQL%ROWCOUNT;
1160:
1161: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1162: trace(p_msg => '# xla_jlt_acct_attrs deleted = '||l_num_rows,
1163: p_module => l_log_module,
1164: p_level => C_LEVEL_STATEMENT);
1165: END IF;
1166: -- Bug : 9923803

Line 1173: p_encoded_message => '# xla_jlt_acct_attrs deleted = '||l_num_rows,

1169: p_amb_context_code => g_amb_context_code,
1170: p_application_id => g_application_id,
1171: p_request_code => 'IMPORT' ,
1172: p_log_type_code => 'MERGE',
1173: p_encoded_message => '# xla_jlt_acct_attrs deleted = '||l_num_rows,
1174: p_component_code => 'clean_oracle_jlts');
1175:
1176: FORALL i IN 1..l_codes.COUNT
1177: DELETE FROM xla_acct_line_types_b w

Line 3962: ,'xla_jlt_acct_attrs'

3958: select jlt_acct_attrs.event_class_code
3959: ,jlt_acct_attrs.accounting_line_code
3960: ,jlt_acct_attrs.accounting_attribute_code
3961: ,jlt_acct_attrs.source_code
3962: ,'xla_jlt_acct_attrs'
3963: from xla_jlt_acct_attrs jlt_acct_attrs
3964: where jlt_acct_attrs.application_id = g_application_id
3965: and jlt_acct_attrs.amb_context_code = g_staging_context_code
3966: and (EXISTS(SELECT 1

Line 3963: from xla_jlt_acct_attrs jlt_acct_attrs

3959: ,jlt_acct_attrs.accounting_line_code
3960: ,jlt_acct_attrs.accounting_attribute_code
3961: ,jlt_acct_attrs.source_code
3962: ,'xla_jlt_acct_attrs'
3963: from xla_jlt_acct_attrs jlt_acct_attrs
3964: where jlt_acct_attrs.application_id = g_application_id
3965: and jlt_acct_attrs.amb_context_code = g_staging_context_code
3966: and (EXISTS(SELECT 1
3967: FROM xla_jlt_acct_attrs jlt_acct_attrs1

Line 3967: FROM xla_jlt_acct_attrs jlt_acct_attrs1

3963: from xla_jlt_acct_attrs jlt_acct_attrs
3964: where jlt_acct_attrs.application_id = g_application_id
3965: and jlt_acct_attrs.amb_context_code = g_staging_context_code
3966: and (EXISTS(SELECT 1
3967: FROM xla_jlt_acct_attrs jlt_acct_attrs1
3968: WHERE jlt_acct_attrs.event_class_code = jlt_acct_attrs1.event_class_code
3969: and jlt_acct_attrs.accounting_line_code = jlt_acct_attrs1.accounting_line_code
3970: and jlt_acct_attrs.accounting_line_type_code = jlt_acct_attrs1.accounting_line_type_code
3971: and nvl(jlt_acct_attrs.accounting_attribute_code,' ') = nvl(jlt_acct_attrs1.accounting_attribute_code,' ')

Line 3979: FROM xla_jlt_acct_attrs jlt_acct_attrs1

3975: and to_char(jlt_acct_attrs.last_update_date,'DD-MON-YYYY') <> to_char(jlt_acct_attrs1.last_update_date,'DD-MON-YYYY')
3976: )
3977: OR
3978: NOT EXISTS(SELECT 1
3979: FROM xla_jlt_acct_attrs jlt_acct_attrs1
3980: WHERE jlt_acct_attrs.event_class_code = jlt_acct_attrs1.event_class_code
3981: and jlt_acct_attrs.accounting_line_code = jlt_acct_attrs1.accounting_line_code
3982: and jlt_acct_attrs.accounting_line_type_code = jlt_acct_attrs1.accounting_line_type_code
3983: and nvl(jlt_acct_attrs.accounting_attribute_code,' ') = nvl(jlt_acct_attrs1.accounting_attribute_code,' ')

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

3987: )
3988: );
3989: l_num_rows := SQL%ROWCOUNT;
3990: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3991: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_jlt_acct_attrs is :'||l_num_rows,
3992: p_module => l_log_module,
3993: p_level => C_LEVEL_PROCEDURE);
3994: END IF;
3995: -- Bug : 9923803

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

3998: p_amb_context_code => g_amb_context_code,
3999: p_application_id => g_application_id,
4000: p_request_code => 'IMPORT' ,
4001: p_log_type_code => 'MERGE',
4002: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_jlt_acct_attrs is :'||l_num_rows,
4003: p_component_code => 'merge_journal_line_types');
4004:
4005: INSERT INTO xla_aads_gt
4006: ( entity_code

Line 4130: DELETE FROM xla_jlt_acct_attrs w

4126: p_log_type_code => 'MERGE',
4127: p_encoded_message => '# xla_acct_line_types_tl delete : '||l_num_rows,
4128: p_component_code => 'merge_journal_line_types');
4129:
4130: DELETE FROM xla_jlt_acct_attrs w
4131: WHERE application_id = g_application_id
4132: AND amb_context_code = g_amb_context_code
4133: AND EXISTS (SELECT 1
4134: FROM xla_jlt_acct_attrs s

Line 4134: FROM xla_jlt_acct_attrs s

4130: DELETE FROM xla_jlt_acct_attrs w
4131: WHERE application_id = g_application_id
4132: AND amb_context_code = g_amb_context_code
4133: AND EXISTS (SELECT 1
4134: FROM xla_jlt_acct_attrs s
4135: WHERE s.application_id = g_application_id
4136: AND s.amb_context_code = g_staging_context_code
4137: AND s.event_class_code = w.event_class_code
4138: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 4142: trace(p_msg => '# xla_jlt_acct_attrs delete : '||l_num_rows,

4138: AND s.accounting_line_type_code = w.accounting_line_type_code
4139: AND s.accounting_line_code = w.accounting_line_code);
4140: l_num_rows := SQL%ROWCOUNT;
4141: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4142: trace(p_msg => '# xla_jlt_acct_attrs delete : '||l_num_rows,
4143: p_module => l_log_module,
4144: p_level => C_LEVEL_STATEMENT);
4145: END IF;
4146: -- Bug : 9923803

Line 4153: p_encoded_message => '# xla_jlt_acct_attrs delete : '||l_num_rows,

4149: p_amb_context_code => g_amb_context_code,
4150: p_application_id => g_application_id,
4151: p_request_code => 'IMPORT' ,
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

Line 4168: trace(p_msg => '# xla_jlt_acct_attrs delete : '||l_num_rows,

4164: AND s.accounting_line_type_code = w.accounting_line_type_code
4165: AND s.accounting_line_code = w.accounting_line_code);
4166: l_num_rows := SQL%ROWCOUNT;
4167: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4168: trace(p_msg => '# xla_jlt_acct_attrs delete : '||l_num_rows,
4169: p_module => l_log_module,
4170: p_level => C_LEVEL_STATEMENT);
4171: END IF;
4172: -- Bug : 9923803

Line 4179: p_encoded_message => '# xla_jlt_acct_attrs delete : '||l_num_rows,

4175: p_amb_context_code => g_amb_context_code,
4176: p_application_id => g_application_id,
4177: p_request_code => 'IMPORT' ,
4178: p_log_type_code => 'MERGE',
4179: p_encoded_message => '# xla_jlt_acct_attrs delete : '||l_num_rows,
4180: p_component_code => 'merge_journal_line_types');
4181: END IF;
4182:
4183: -- Move the journal line types from staging area to working area

Line 4262: UPDATE xla_jlt_acct_attrs

4258: p_log_type_code => 'MERGE',
4259: p_encoded_message => '# xla_acct_line_types_tl 2 updated : '||l_num_rows,
4260: p_component_code => 'merge_journal_line_types');
4261:
4262: UPDATE xla_jlt_acct_attrs
4263: SET amb_context_code = g_amb_context_code
4264: WHERE application_id = g_application_id
4265: AND amb_context_code = g_staging_context_code;
4266: l_num_rows := SQL%ROWCOUNT;

Line 4268: trace(p_msg => '# xla_jlt_acct_attrs updated : '||l_num_rows,

4264: WHERE application_id = g_application_id
4265: AND amb_context_code = g_staging_context_code;
4266: l_num_rows := SQL%ROWCOUNT;
4267: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4268: trace(p_msg => '# xla_jlt_acct_attrs updated : '||l_num_rows,
4269: p_module => l_log_module,
4270: p_level => C_LEVEL_STATEMENT);
4271: END IF;
4272: -- Bug : 9923803

Line 4279: p_encoded_message => '# xla_jlt_acct_attrs updated : '||l_num_rows,

4275: p_amb_context_code => g_amb_context_code,
4276: p_application_id => g_application_id,
4277: p_request_code => 'IMPORT' ,
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