APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ANALYTICAL_DTLS_TL

Line 1061: ,xla_analytical_dtls_tl t

1057:
1058: /* CURSOR c_analytical_dtls IS
1059: SELECT *
1060: FROM xla_analytical_dtls_b b
1061: ,xla_analytical_dtls_tl t
1062: WHERE t.analytical_criterion_type_code = b.analytical_criterion_type_code
1063: AND t.analytical_criterion_code = b.analytical_criterion_code
1064: AND t.amb_context_code = b.amb_context_code
1065: AND b.amb_context_code = p_amb_context_code

Line 3548: DELETE FROM xla_analytical_dtls_tl b

3544: p_module => l_log_module,
3545: p_level => C_LEVEL_PROCEDURE);
3546: END IF;
3547:
3548: DELETE FROM xla_analytical_dtls_tl b
3549: WHERE EXISTS (SELECT 1
3550: FROM xla_analytical_hdrs_b h
3551: WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
3552: AND b.analytical_criterion_code = h.analytical_criterion_code

Line 3564: p_encoded_message => '# delete (xla_analytical_dtls_tl) = '||SQL%ROWCOUNT,

3560: p_amb_context_code => p_amb_context_code,
3561: p_application_id => p_application_id,
3562: p_request_code => 'IMPORT' ,
3563: p_log_type_code => 'MERGE',
3564: p_encoded_message => '# delete (xla_analytical_dtls_tl) = '||SQL%ROWCOUNT,
3565: p_component_code => 'purge_aad');
3566:
3567: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3568: trace(p_msg => '# xla_analytical_dtls_tl deleted = '||SQL%ROWCOUNT,

Line 3568: trace(p_msg => '# xla_analytical_dtls_tl deleted = '||SQL%ROWCOUNT,

3564: p_encoded_message => '# delete (xla_analytical_dtls_tl) = '||SQL%ROWCOUNT,
3565: p_component_code => 'purge_aad');
3566:
3567: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3568: trace(p_msg => '# xla_analytical_dtls_tl deleted = '||SQL%ROWCOUNT,
3569: p_module => l_log_module,
3570: p_level => C_LEVEL_PROCEDURE);
3571: END IF;
3572: