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_DTLS_B

Line 1535: FROM xla_analytical_dtls_b s

1531: WHERE amb_context_code = g_amb_context_code
1532: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1533: AND NOT EXISTS
1534: (SELECT 1
1535: FROM xla_analytical_dtls_b s
1536: WHERE s.amb_context_code = g_staging_context_code
1537: AND s.analytical_criterion_type_code = C_OWNER_SYSTEM
1538: AND s.analytical_criterion_code = w.analytical_criterion_code
1539: AND s.analytical_detail_code = w.analytical_detail_code);

Line 1547: DELETE FROM xla_analytical_dtls_b w

1543: p_module => l_log_module,
1544: p_level => C_LEVEL_STATEMENT);
1545: END IF;
1546:
1547: DELETE FROM xla_analytical_dtls_b w
1548: WHERE amb_context_code = g_amb_context_code
1549: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1550: AND NOT EXISTS
1551: (SELECT 1

Line 1552: FROM xla_analytical_dtls_b s

1548: WHERE amb_context_code = g_amb_context_code
1549: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1550: AND NOT EXISTS
1551: (SELECT 1
1552: FROM xla_analytical_dtls_b s
1553: WHERE s.amb_context_code = g_staging_context_code
1554: AND s.analytical_criterion_type_code = C_OWNER_SYSTEM
1555: AND s.analytical_criterion_code = w.analytical_criterion_code
1556: AND s.analytical_detail_code = w.analytical_detail_code);

Line 1559: trace(p_msg => '# xla_analytical_dtls_b deleted = '||SQL%ROWCOUNT,

1555: AND s.analytical_criterion_code = w.analytical_criterion_code
1556: AND s.analytical_detail_code = w.analytical_detail_code);
1557:
1558: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1559: trace(p_msg => '# xla_analytical_dtls_b deleted = '||SQL%ROWCOUNT,
1560: p_module => l_log_module,
1561: p_level => C_LEVEL_STATEMENT);
1562: END IF;
1563:

Line 2820: FROM xla_analytical_dtls_b s

2816: -- Added cursor for DTLs as part of bug 7243326 - This is mainly for AR where AR does not have a HDR and following DELETES and UPDATES dont loop
2817:
2818: CURSOR c_ac_dtls IS
2819: SELECT s.analytical_criterion_type_code, s.analytical_criterion_code,s.ANALYTICAL_DETAIL_CODE
2820: FROM xla_analytical_dtls_b s
2821: , xla_analytical_dtls_b w
2822: WHERE s.amb_context_code = g_staging_context_code
2823: AND w.amb_context_code(+) = g_amb_context_code
2824: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code(+)

Line 2821: , xla_analytical_dtls_b w

2817:
2818: CURSOR c_ac_dtls IS
2819: SELECT s.analytical_criterion_type_code, s.analytical_criterion_code,s.ANALYTICAL_DETAIL_CODE
2820: FROM xla_analytical_dtls_b s
2821: , xla_analytical_dtls_b w
2822: WHERE s.amb_context_code = g_staging_context_code
2823: AND w.amb_context_code(+) = g_amb_context_code
2824: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code(+)
2825: AND s.analytical_criterion_code = w.analytical_criterion_code(+)

Line 2932: DELETE FROM xla_analytical_dtls_b w

2928: END IF;
2929:
2930: -- Delete the AC dtlss from the working area for the AC dtls to be merged
2931: FORALL i IN 1..l_ac_dtl_codes.COUNT
2932: DELETE FROM xla_analytical_dtls_b w
2933: WHERE amb_context_code = g_amb_context_code
2934: AND analytical_criterion_type_code = l_ac_dtl_type_codes(i)
2935: AND analytical_criterion_code = l_ac_dtl_codes(i)
2936: AND analytical_detail_code = l_ac_detail_code(i)

Line 2939: FROM xla_analytical_dtls_b s

2935: AND analytical_criterion_code = l_ac_dtl_codes(i)
2936: AND analytical_detail_code = l_ac_detail_code(i)
2937: AND EXISTS
2938: ( SELECT 1
2939: FROM xla_analytical_dtls_b s
2940: WHERE s.amb_context_code = g_staging_context_code
2941: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
2942: AND s.analytical_criterion_code = w.analytical_criterion_code
2943: AND s.analytical_detail_code = w.analytical_detail_code);

Line 2946: trace(p_msg => '# xla_analytical_dtls_b delete : '||SQL%ROWCOUNT,

2942: AND s.analytical_criterion_code = w.analytical_criterion_code
2943: AND s.analytical_detail_code = w.analytical_detail_code);
2944:
2945: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2946: trace(p_msg => '# xla_analytical_dtls_b delete : '||SQL%ROWCOUNT,
2947: p_module => l_log_module,
2948: p_level => C_LEVEL_STATEMENT);
2949: END IF;
2950:

Line 3054: UPDATE xla_analytical_dtls_b

3050: p_level => C_LEVEL_STATEMENT);
3051: END IF;
3052:
3053: FORALL i IN 1..l_ac_dtl_codes.COUNT
3054: UPDATE xla_analytical_dtls_b
3055: SET amb_context_code = g_amb_context_code
3056: WHERE amb_context_code = g_staging_context_code
3057: AND analytical_criterion_type_code = l_ac_dtl_type_codes(i)
3058: AND analytical_criterion_code = l_ac_dtl_codes(i)

Line 3062: trace(p_msg => '# xla_analytical_dtls_b updated : '||SQL%ROWCOUNT,

3058: AND analytical_criterion_code = l_ac_dtl_codes(i)
3059: AND analytical_detail_code = l_ac_detail_code(i);
3060:
3061: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3062: trace(p_msg => '# xla_analytical_dtls_b updated : '||SQL%ROWCOUNT,
3063: p_module => l_log_module,
3064: p_level => C_LEVEL_STATEMENT);
3065: END IF;
3066:

Line 3860: DELETE FROM xla_analytical_dtls_b

3856: p_module => l_log_module,
3857: p_level => C_LEVEL_STATEMENT);
3858: END IF;
3859:
3860: DELETE FROM xla_analytical_dtls_b
3861: WHERE amb_context_code = g_staging_context_code;
3862:
3863: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3864: trace(p_msg => '# xla_analytical_dtls_b delete : '||SQL%ROWCOUNT,

Line 3864: trace(p_msg => '# xla_analytical_dtls_b delete : '||SQL%ROWCOUNT,

3860: DELETE FROM xla_analytical_dtls_b
3861: WHERE amb_context_code = g_staging_context_code;
3862:
3863: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3864: trace(p_msg => '# xla_analytical_dtls_b delete : '||SQL%ROWCOUNT,
3865: p_module => l_log_module,
3866: p_level => C_LEVEL_STATEMENT);
3867: END IF;
3868: