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_ACCT_LINE_TYPES_TL

Line 1200: DELETE FROM xla_acct_line_types_tl w

1196: p_encoded_message => '# xla_acct_line_types_b deleted = '||l_num_rows,
1197: p_component_code => 'clean_oracle_jlts');
1198:
1199: FORALL i IN 1..l_codes.COUNT
1200: DELETE FROM xla_acct_line_types_tl w
1201: WHERE application_id = g_application_id
1202: AND amb_context_code = g_amb_context_code
1203: AND event_class_code = l_event_class_codes(i)
1204: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 1208: trace(p_msg => '# xla_acct_line_types_tl deleted = '||l_num_rows,

1204: AND accounting_line_type_code = C_OWNER_SYSTEM
1205: AND accounting_line_code = l_codes(i);
1206: l_num_rows := SQL%ROWCOUNT;
1207: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1208: trace(p_msg => '# xla_acct_line_types_tl deleted = '||l_num_rows,
1209: p_module => l_log_module,
1210: p_level => C_LEVEL_STATEMENT);
1211: END IF;
1212: -- Bug : 9923803

Line 1219: p_encoded_message => '# xla_acct_line_types_tl deleted = '||l_num_rows,

1215: p_amb_context_code => g_amb_context_code,
1216: p_application_id => g_application_id,
1217: p_request_code => 'IMPORT' ,
1218: p_log_type_code => 'MERGE',
1219: p_encoded_message => '# xla_acct_line_types_tl deleted = '||l_num_rows,
1220: p_component_code => 'clean_oracle_jlts');
1221:
1222: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1223: trace(p_msg => 'BEGIN of procedure clean_oracle_jlts',

Line 4103: DELETE FROM xla_acct_line_types_tl w

4099: p_log_type_code => 'MERGE',
4100: p_encoded_message => '# xla_acct_line_types_b delete : '||l_num_rows,
4101: p_component_code => 'merge_journal_line_types');
4102:
4103: DELETE FROM xla_acct_line_types_tl w
4104: WHERE application_id = g_application_id
4105: AND amb_context_code = g_amb_context_code
4106: AND EXISTS (SELECT 1
4107: FROM xla_acct_line_types_tl s

Line 4107: FROM xla_acct_line_types_tl s

4103: DELETE FROM xla_acct_line_types_tl w
4104: WHERE application_id = g_application_id
4105: AND amb_context_code = g_amb_context_code
4106: AND EXISTS (SELECT 1
4107: FROM xla_acct_line_types_tl s
4108: WHERE s.application_id = g_application_id
4109: AND s.amb_context_code = g_staging_context_code
4110: AND s.event_class_code = w.event_class_code
4111: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 4116: trace(p_msg => '# xla_acct_line_types_tl delete : '||l_num_rows,

4112: AND s.accounting_line_code = w.accounting_line_code
4113: AND s.language = w.language);
4114: l_num_rows := SQL%ROWCOUNT;
4115: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4116: trace(p_msg => '# xla_acct_line_types_tl delete : '||l_num_rows,
4117: p_module => l_log_module,
4118: p_level => C_LEVEL_STATEMENT);
4119: END IF;
4120: -- Bug : 9923803

Line 4127: p_encoded_message => '# xla_acct_line_types_tl delete : '||l_num_rows,

4123: p_amb_context_code => g_amb_context_code,
4124: p_application_id => g_application_id,
4125: p_request_code => 'IMPORT' ,
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

Line 4204: UPDATE xla_acct_line_types_tl w

4200: p_log_type_code => 'MERGE',
4201: p_encoded_message => '# xla_acct_line_types_b updated : '||l_num_rows,
4202: p_component_code => 'merge_journal_line_types');
4203:
4204: UPDATE xla_acct_line_types_tl w
4205: SET amb_context_code = g_amb_context_code
4206: WHERE application_id = g_application_id
4207: AND amb_context_code = g_staging_context_code
4208: AND NOT EXISTS (SELECT 1

Line 4209: FROM xla_acct_line_types_tl s

4205: SET amb_context_code = g_amb_context_code
4206: WHERE application_id = g_application_id
4207: AND amb_context_code = g_staging_context_code
4208: AND NOT EXISTS (SELECT 1
4209: FROM xla_acct_line_types_tl s
4210: WHERE s.application_id = g_application_id
4211: AND s.amb_context_code = g_amb_context_code
4212: AND s.event_class_code = w.event_class_code
4213: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 4219: trace(p_msg => '# xla_acct_line_types_tl 1 updated : '||l_num_rows,

4215: AND s.language = w.language);
4216: l_num_rows := SQL%ROWCOUNT;
4217:
4218: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4219: trace(p_msg => '# xla_acct_line_types_tl 1 updated : '||l_num_rows,
4220: p_module => l_log_module,
4221: p_level => C_LEVEL_STATEMENT);
4222: END IF;
4223: -- Bug : 9923803

Line 4230: p_encoded_message => '# xla_acct_line_types_tl 1 updated : '||l_num_rows,

4226: p_amb_context_code => g_amb_context_code,
4227: p_application_id => g_application_id,
4228: p_request_code => 'IMPORT' ,
4229: p_log_type_code => 'MERGE',
4230: p_encoded_message => '# xla_acct_line_types_tl 1 updated : '||l_num_rows,
4231: p_component_code => 'merge_journal_line_types');
4232:
4233: UPDATE xla_acct_line_types_tl w
4234: SET amb_context_code = g_amb_context_code

Line 4233: UPDATE xla_acct_line_types_tl w

4229: p_log_type_code => 'MERGE',
4230: p_encoded_message => '# xla_acct_line_types_tl 1 updated : '||l_num_rows,
4231: p_component_code => 'merge_journal_line_types');
4232:
4233: UPDATE xla_acct_line_types_tl w
4234: SET amb_context_code = g_amb_context_code
4235: , name = substr('('||w.accounting_line_code||') '||name,1,80)
4236: WHERE application_id = g_application_id
4237: AND amb_context_code = g_staging_context_code

Line 4239: FROM xla_acct_line_types_tl s

4235: , name = substr('('||w.accounting_line_code||') '||name,1,80)
4236: WHERE application_id = g_application_id
4237: AND amb_context_code = g_staging_context_code
4238: AND EXISTS (SELECT 1
4239: FROM xla_acct_line_types_tl s
4240: WHERE s.application_id = g_application_id
4241: AND s.amb_context_code = g_amb_context_code
4242: AND s.event_class_code = w.event_class_code
4243: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 4248: trace(p_msg => '# xla_acct_line_types_tl 2 updated : '||l_num_rows,

4244: AND s.name = w.name
4245: AND s.language = w.language);
4246: l_num_rows := SQL%ROWCOUNT;
4247: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4248: trace(p_msg => '# xla_acct_line_types_tl 2 updated : '||l_num_rows,
4249: p_module => l_log_module,
4250: p_level => C_LEVEL_STATEMENT);
4251: END IF;
4252: -- Bug : 9923803

Line 4259: p_encoded_message => '# xla_acct_line_types_tl 2 updated : '||l_num_rows,

4255: p_amb_context_code => g_amb_context_code,
4256: p_application_id => g_application_id,
4257: p_request_code => 'IMPORT' ,
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