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_HDRS_B

Line 1421: FROM xla_analytical_hdrs_b w

1417: PROCEDURE clean_oracle_acs
1418: IS
1419: /*CURSOR c_all_comps IS
1420: SELECT w.analytical_criterion_code
1421: FROM xla_analytical_hdrs_b w
1422: WHERE w.amb_context_code = g_amb_context_code
1423: AND w.application_id = g_application_id
1424: AND w.analytical_criterion_type_code = C_OWNER_SYSTEM
1425: AND NOT EXISTS ( SELECT 1

Line 1426: FROM xla_analytical_hdrs_b s

1422: WHERE w.amb_context_code = g_amb_context_code
1423: AND w.application_id = g_application_id
1424: AND w.analytical_criterion_type_code = C_OWNER_SYSTEM
1425: AND NOT EXISTS ( SELECT 1
1426: FROM xla_analytical_hdrs_b s
1427: WHERE s.amb_context_code = g_staging_context_code
1428: AND s.application_id = g_application_id
1429: AND s.analytical_criterion_type_code = C_OWNER_SYSTEM
1430: AND s.analytical_criterion_code = w.analytical_criterion_code);

Line 1577: DELETE FROM xla_analytical_hdrs_b w

1573: p_level => C_LEVEL_STATEMENT);
1574: END IF;
1575:
1576: FORALL i IN 1..l_codes.COUNT
1577: DELETE FROM xla_analytical_hdrs_b w
1578: WHERE amb_context_code = g_amb_context_code
1579: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1580: AND analytical_criterion_code = l_codes(i);
1581:

Line 1583: trace(p_msg => '# xla_analytical_hdrs_b deleted = '||SQL%ROWCOUNT,

1579: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1580: AND analytical_criterion_code = l_codes(i);
1581:
1582: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1583: trace(p_msg => '# xla_analytical_hdrs_b deleted = '||SQL%ROWCOUNT,
1584: p_module => l_log_module,
1585: p_level => C_LEVEL_STATEMENT);
1586: END IF;*/ -- commented bug6696939
1587:

Line 2808: FROM xla_analytical_hdrs_b s

2804: IS
2805: -- Retrieve the AC to be merged
2806: CURSOR c_ac IS
2807: SELECT s.analytical_criterion_type_code, s.analytical_criterion_code
2808: FROM xla_analytical_hdrs_b s
2809: , xla_analytical_hdrs_b w
2810: WHERE s.amb_context_code = g_staging_context_code
2811: AND w.amb_context_code(+) = g_amb_context_code
2812: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code(+)

Line 2809: , xla_analytical_hdrs_b w

2805: -- Retrieve the AC to be merged
2806: CURSOR c_ac IS
2807: SELECT s.analytical_criterion_type_code, s.analytical_criterion_code
2808: FROM xla_analytical_hdrs_b s
2809: , xla_analytical_hdrs_b w
2810: WHERE s.amb_context_code = g_staging_context_code
2811: AND w.amb_context_code(+) = g_amb_context_code
2812: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code(+)
2813: AND s.analytical_criterion_code = w.analytical_criterion_code(+)

Line 2894: DELETE FROM xla_analytical_hdrs_b w

2890: CLOSE c_ac_src ;
2891:
2892: -- Delete the ACs from the working area for the AC to be merged
2893: FORALL i IN 1..l_ac_codes.COUNT
2894: DELETE FROM xla_analytical_hdrs_b w
2895: WHERE amb_context_code = g_amb_context_code
2896: AND analytical_criterion_type_code = l_ac_type_codes(i)
2897: AND analytical_criterion_code = l_ac_codes(i)
2898: AND EXISTS

Line 2900: FROM xla_analytical_hdrs_b s

2896: AND analytical_criterion_type_code = l_ac_type_codes(i)
2897: AND analytical_criterion_code = l_ac_codes(i)
2898: AND EXISTS
2899: ( SELECT 1
2900: FROM xla_analytical_hdrs_b s
2901: WHERE s.amb_context_code = g_staging_context_code
2902: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
2903: AND s.analytical_criterion_code = w.analytical_criterion_code );
2904:

Line 2906: trace(p_msg => '# xla_analytical_hdrs_b delete : '||SQL%ROWCOUNT,

2902: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
2903: AND s.analytical_criterion_code = w.analytical_criterion_code );
2904:
2905: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2906: trace(p_msg => '# xla_analytical_hdrs_b delete : '||SQL%ROWCOUNT,
2907: p_module => l_log_module,
2908: p_level => C_LEVEL_STATEMENT);
2909: END IF;
2910:

Line 3001: UPDATE xla_analytical_hdrs_b

2997: END IF;
2998:
2999: -- Move the analytical criteria from staging area to working area
3000: FORALL i IN 1..l_ac_codes.COUNT
3001: UPDATE xla_analytical_hdrs_b
3002: SET amb_context_code = g_amb_context_code
3003: WHERE amb_context_code = g_staging_context_code
3004: AND analytical_criterion_type_code = l_ac_type_codes(i)
3005: AND analytical_criterion_code = l_ac_codes(i);

Line 3009: trace(p_msg => '# xla_analytical_hdrs_b updated : '||SQL%ROWCOUNT,

3005: AND analytical_criterion_code = l_ac_codes(i);
3006:
3007:
3008: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3009: trace(p_msg => '# xla_analytical_hdrs_b updated : '||SQL%ROWCOUNT,
3010: p_module => l_log_module,
3011: p_level => C_LEVEL_STATEMENT);
3012: END IF;
3013:

Line 3878: DELETE FROM xla_analytical_hdrs_b

3874: p_module => l_log_module,
3875: p_level => C_LEVEL_STATEMENT);
3876: END IF;
3877:
3878: DELETE FROM xla_analytical_hdrs_b
3879: WHERE amb_context_code = g_staging_context_code;
3880:
3881: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3882: trace(p_msg => '# xla_analytical_hdrs_b delete : '||SQL%ROWCOUNT,

Line 3882: trace(p_msg => '# xla_analytical_hdrs_b delete : '||SQL%ROWCOUNT,

3878: DELETE FROM xla_analytical_hdrs_b
3879: WHERE amb_context_code = g_staging_context_code;
3880:
3881: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3882: trace(p_msg => '# xla_analytical_hdrs_b delete : '||SQL%ROWCOUNT,
3883: p_module => l_log_module,
3884: p_level => C_LEVEL_STATEMENT);
3885: END IF;
3886: