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_ANALYTICAL_SOURCES

Line 1506: DELETE FROM xla_analytical_sources w

1502: p_level => C_LEVEL_STATEMENT);
1503: END IF;*/ -- commented bug6696939
1504:
1505: -- Delete the AC
1506: DELETE FROM xla_analytical_sources w
1507: WHERE amb_context_code = g_amb_context_code
1508: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1509: AND application_id = g_application_id -- added bug6696939
1510: AND NOT EXISTS

Line 1512: FROM xla_analytical_sources s

1508: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1509: AND application_id = g_application_id -- added bug6696939
1510: AND NOT EXISTS
1511: (SELECT 1
1512: FROM xla_analytical_sources s
1513: WHERE s.amb_context_code = g_staging_context_code
1514: AND s.application_id = g_application_id
1515: AND s.entity_code = w.entity_code
1516: AND s.event_class_code = w.event_class_code

Line 1525: trace(p_msg => '# xla_analytical_sources deleted = '||SQL%ROWCOUNT,

1521: AND s.analytical_criterion_code = w.analytical_criterion_code
1522: AND s.analytical_detail_code = w.analytical_detail_code);
1523:
1524: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1525: trace(p_msg => '# xla_analytical_sources deleted = '||SQL%ROWCOUNT,
1526: p_module => l_log_module,
1527: p_level => C_LEVEL_STATEMENT);
1528: END IF;
1529:

Line 2831: FROM xla_analytical_sources s

2827:
2828: CURSOR c_ac_src IS
2829: SELECT s.analytical_criterion_type_code, s.analytical_criterion_code,s.ANALYTICAL_DETAIL_CODE,
2830: s.event_class_code,s.entity_code,s.source_code,s.source_type_code
2831: FROM xla_analytical_sources s
2832: , xla_analytical_sources w
2833: WHERE s.amb_context_code = g_staging_context_code
2834: AND w.amb_context_code(+) = g_amb_context_code
2835: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code(+)

Line 2832: , xla_analytical_sources w

2828: CURSOR c_ac_src IS
2829: SELECT s.analytical_criterion_type_code, s.analytical_criterion_code,s.ANALYTICAL_DETAIL_CODE,
2830: s.event_class_code,s.entity_code,s.source_code,s.source_type_code
2831: FROM xla_analytical_sources s
2832: , xla_analytical_sources w
2833: WHERE s.amb_context_code = g_staging_context_code
2834: AND w.amb_context_code(+) = g_amb_context_code
2835: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code(+)
2836: AND s.analytical_criterion_code = w.analytical_criterion_code(+)

Line 2973: DELETE FROM xla_analytical_sources w

2969: p_level => C_LEVEL_STATEMENT);
2970: END IF;
2971:
2972: FORALL i IN 1..l_ac_src_event_class.COUNT
2973: DELETE FROM xla_analytical_sources w
2974: WHERE amb_context_code = g_amb_context_code
2975: AND analytical_criterion_type_code = l_ac_dtl_type_codes(i)
2976: AND analytical_criterion_code = l_ac_dtl_codes(i)
2977: AND event_class_code =l_ac_src_event_class(i)

Line 2983: FROM xla_analytical_sources s

2979: AND SOURCE_CODE =l_ac_src_source_code(i)
2980: AND SOURCE_TYPE_CODE =l_ac_src_source_type_code(i)
2981: AND EXISTS
2982: ( SELECT 1
2983: FROM xla_analytical_sources s
2984: WHERE s.amb_context_code = g_staging_context_code
2985: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
2986: AND s.analytical_criterion_code = w.analytical_criterion_code
2987: AND s.entity_code = w.entity_code

Line 2992: trace(p_msg => '# xla_analytical_sources delete : '||SQL%ROWCOUNT,

2988: AND s.event_class_code = w.event_class_code
2989: AND s.source_code = w.source_code
2990: AND s.source_type_code = w.source_type_code);
2991: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2992: trace(p_msg => '# xla_analytical_sources delete : '||SQL%ROWCOUNT,
2993: p_module => l_log_module,
2994: p_level => C_LEVEL_STATEMENT);
2995: END IF;
2996:

Line 3113: UPDATE xla_analytical_sources

3109: p_level => C_LEVEL_STATEMENT);
3110: END IF;
3111:
3112: FORALL i IN 1..l_ac_src_event_class.COUNT
3113: UPDATE xla_analytical_sources
3114: SET amb_context_code = g_amb_context_code
3115: WHERE amb_context_code = g_staging_context_code
3116: AND analytical_criterion_type_code = l_ac_dtl_type_codes(i)
3117: AND analytical_criterion_code = l_ac_dtl_codes(i)

Line 3124: trace(p_msg => '# xla_analytical_sources updated : '||SQL%ROWCOUNT,

3120: AND SOURCE_CODE =l_ac_src_source_code(i)
3121: AND SOURCE_TYPE_CODE =l_ac_src_source_type_code(i);
3122:
3123: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3124: trace(p_msg => '# xla_analytical_sources updated : '||SQL%ROWCOUNT,
3125: p_module => l_log_module,
3126: p_level => C_LEVEL_STATEMENT);
3127: END IF;
3128:

Line 3842: DELETE FROM xla_analytical_sources

3838: p_module => l_log_module,
3839: p_level => C_LEVEL_PROCEDURE);
3840: END IF;
3841:
3842: DELETE FROM xla_analytical_sources
3843: WHERE amb_context_code = g_staging_context_code;
3844:
3845: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3846: trace(p_msg => '# xla_analytical_sources delete : '||SQL%ROWCOUNT,

Line 3846: trace(p_msg => '# xla_analytical_sources delete : '||SQL%ROWCOUNT,

3842: DELETE FROM xla_analytical_sources
3843: WHERE amb_context_code = g_staging_context_code;
3844:
3845: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3846: trace(p_msg => '# xla_analytical_sources delete : '||SQL%ROWCOUNT,
3847: p_module => l_log_module,
3848: p_level => C_LEVEL_STATEMENT);
3849: END IF;
3850: