APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ANALYTICAL_DTLS_B

Line 1060: FROM xla_analytical_dtls_b b

1056: FOR UPDATE NOWAIT;*/
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

Line 3573: DELETE FROM xla_analytical_dtls_b b

3569: p_module => l_log_module,
3570: p_level => C_LEVEL_PROCEDURE);
3571: END IF;
3572:
3573: DELETE FROM xla_analytical_dtls_b b
3574: WHERE EXISTS (SELECT 1
3575: FROM xla_analytical_hdrs_b h
3576: WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
3577: AND b.analytical_criterion_code = h.analytical_criterion_code

Line 3589: p_encoded_message => '# delete (xla_analytical_dtls_b) = '||SQL%ROWCOUNT,

3585: p_amb_context_code => p_amb_context_code,
3586: p_application_id => p_application_id,
3587: p_request_code => 'IMPORT' ,
3588: p_log_type_code => 'MERGE',
3589: p_encoded_message => '# delete (xla_analytical_dtls_b) = '||SQL%ROWCOUNT,
3590: p_component_code => 'purge_aad');
3591:
3592:
3593: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 3594: trace(p_msg => '# xla_analytical_dtls_b deleted = '||SQL%ROWCOUNT,

3590: p_component_code => 'purge_aad');
3591:
3592:
3593: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3594: trace(p_msg => '# xla_analytical_dtls_b deleted = '||SQL%ROWCOUNT,
3595: p_module => l_log_module,
3596: p_level => C_LEVEL_PROCEDURE);
3597: END IF;
3598: