DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ANALYTICAL_HDRS_TL

Line 1020: ,xla_analytical_hdrs_tl t

1016:
1017: /*CURSOR c_analytical_hdrs IS
1018: SELECT *
1019: FROM xla_analytical_hdrs_b b
1020: ,xla_analytical_hdrs_tl t
1021: WHERE t.analytical_criterion_type_code = b.analytical_criterion_type_code
1022: AND t.analytical_criterion_code = b.analytical_criterion_code
1023: AND t.amb_context_code = b.amb_context_code
1024: AND b.amb_context_code = p_amb_context_code

Line 3599: DELETE FROM xla_analytical_hdrs_tl b

3595: p_module => l_log_module,
3596: p_level => C_LEVEL_PROCEDURE);
3597: END IF;
3598:
3599: DELETE FROM xla_analytical_hdrs_tl b
3600: WHERE EXISTS (SELECT 1
3601: FROM xla_analytical_hdrs_b h
3602: WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
3603: AND b.analytical_criterion_code = h.analytical_criterion_code

Line 3615: p_encoded_message => '# delete (xla_analytical_hdrs_tl) = '||SQL%ROWCOUNT,

3611: p_amb_context_code => p_amb_context_code,
3612: p_application_id => p_application_id,
3613: p_request_code => 'IMPORT' ,
3614: p_log_type_code => 'MERGE',
3615: p_encoded_message => '# delete (xla_analytical_hdrs_tl) = '||SQL%ROWCOUNT,
3616: p_component_code => 'purge_aad');
3617:
3618:
3619: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

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

3616: p_component_code => 'purge_aad');
3617:
3618:
3619: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3620: trace(p_msg => '# xla_analytical_hdrs_tl deleted = '||SQL%ROWCOUNT,
3621: p_module => l_log_module,
3622: p_level => C_LEVEL_PROCEDURE);
3623: END IF;
3624: