APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_ANALYTICAL_HDRS_TL

Line 134: ,xla_analytical_hdrs_tl t

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
138: AND t.analytical_criterion_type_code = w.analytical_criterion_type_code

Line 858: DELETE FROM xla_analytical_hdrs_tl

854: p_level => C_LEVEL_STATEMENT);
855: END IF;
856:
857: FORALL i IN 1 .. l_ac_codes.COUNT
858: DELETE FROM xla_analytical_hdrs_tl
859: WHERE analytical_criterion_type_code = l_ac_type_codes(i)
860: AND analytical_criterion_code = l_ac_codes(i)
861: AND amb_context_code = g_amb_context_code;
862:

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

860: AND analytical_criterion_code = l_ac_codes(i)
861: AND amb_context_code = g_amb_context_code;
862:
863: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
864: trace(p_msg => '# row deleted into xla_analytical_hdrs_tl = '||SQL%ROWCOUNT,
865: p_module => l_log_module,
866: p_level => C_LEVEL_STATEMENT);
867: END IF;
868:

Line 1440: UPDATE xla_analytical_hdrs_tl

1436: p_module => l_log_module,
1437: p_level => C_LEVEL_STATEMENT);
1438: END IF;
1439:
1440: UPDATE xla_analytical_hdrs_tl
1441: SET amb_context_code = g_amb_context_code
1442: WHERE amb_context_code = g_staging_context_code;
1443:
1444: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1445: trace(p_msg => '# row moved in xla_analytical_hdrs_tl = '||SQL%ROWCOUNT,

1441: SET amb_context_code = g_amb_context_code
1442: WHERE amb_context_code = g_staging_context_code;
1443:
1444: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1445: trace(p_msg => '# row moved in xla_analytical_hdrs_tl = '||SQL%ROWCOUNT,
1446: p_module => l_log_module,
1447: p_level => C_LEVEL_STATEMENT);
1448: END IF;
1449: