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_OVERWRITE_PVT dependencies on XLA_ANALYTICAL_HDRS_B

Line 132: FROM xla_analytical_hdrs_b w

128: AND s.amb_context_code = g_staging_context_code;
129:
130: CURSOR c_ac IS
131: SELECT t.name
132: FROM xla_analytical_hdrs_b w
133: ,xla_analytical_hdrs_b s
134: ,xla_analytical_hdrs_tl t
135: WHERE s.version_num < w.version_num
136: AND t.language = USERENV('LANG')

Line 133: ,xla_analytical_hdrs_b s

129:
130: CURSOR c_ac IS
131: SELECT t.name
132: FROM xla_analytical_hdrs_b w
133: ,xla_analytical_hdrs_b s
134: ,xla_analytical_hdrs_tl t
135: WHERE s.version_num < w.version_num
136: AND t.language = USERENV('LANG')
137: AND t.amb_context_code = w.amb_context_code

Line 672: FROM xla_analytical_hdrs_b s

668: SELECT s.analytical_criterion_type_code
669: ,s.analytical_criterion_code
670: ,w.version_num version_from
671: ,s.version_num version_to
672: FROM xla_analytical_hdrs_b s
673: ,xla_analytical_hdrs_b w
674: WHERE s.analytical_criterion_type_code = w.analytical_criterion_type_code
675: AND s.analytical_criterion_code = w.analytical_criterion_code
676: AND s.amb_context_code = g_staging_context_code

Line 673: ,xla_analytical_hdrs_b w

669: ,s.analytical_criterion_code
670: ,w.version_num version_from
671: ,s.version_num version_to
672: FROM xla_analytical_hdrs_b s
673: ,xla_analytical_hdrs_b w
674: WHERE s.analytical_criterion_type_code = w.analytical_criterion_type_code
675: AND s.analytical_criterion_code = w.analytical_criterion_code
676: AND s.amb_context_code = g_staging_context_code
677: AND w.amb_context_code = g_amb_context_code

Line 683: FROM xla_analytical_hdrs_b w

679: SELECT w.analytical_criterion_type_code
680: ,w.analytical_criterion_code
681: ,NULL
682: ,NULL
683: FROM xla_analytical_hdrs_b w
684: WHERE w.application_id = g_application_id
685: AND w.amb_context_code = g_amb_context_code;
686:
687: l_analytical_criteria xla_component_tbl_type;

Line 870: DELETE FROM xla_analytical_hdrs_b

866: p_level => C_LEVEL_STATEMENT);
867: END IF;
868:
869: FORALL i IN 1 .. l_ac_codes.COUNT
870: DELETE FROM xla_analytical_hdrs_b
871: WHERE analytical_criterion_type_code = l_ac_type_codes(i)
872: AND analytical_criterion_code = l_ac_codes(i)
873: AND amb_context_code = g_amb_context_code;
874:

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

872: AND analytical_criterion_code = l_ac_codes(i)
873: AND amb_context_code = g_amb_context_code;
874:
875: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
876: trace(p_msg => '# row deleted into xla_analytical_hdrs_b = '||SQL%ROWCOUNT,
877: p_module => l_log_module,
878: p_level => C_LEVEL_STATEMENT);
879: END IF;
880:

Line 1425: UPDATE xla_analytical_hdrs_b

1421: p_level => C_LEVEL_STATEMENT);
1422: END IF;
1423:
1424: -- Move analytical criteria
1425: UPDATE xla_analytical_hdrs_b
1426: SET amb_context_code = g_amb_context_code
1427: WHERE amb_context_code = g_staging_context_code;
1428:
1429: l_count := SQL%ROWCOUNT;

Line 1435: trace(p_msg => '# row moved in xla_analytical_hdrs_b = '||l_count,

1431: g_ac_updated := TRUE;
1432: END IF;
1433:
1434: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1435: trace(p_msg => '# row moved in xla_analytical_hdrs_b = '||l_count,
1436: p_module => l_log_module,
1437: p_level => C_LEVEL_STATEMENT);
1438: END IF;
1439: