APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ANALYTICAL_SOURCES

Line 1101: FROM xla_analytical_sources b

1097: FOR UPDATE NOWAIT;*/
1098:
1099: /*CURSOR c_analytical_sources IS
1100: SELECT *
1101: FROM xla_analytical_sources b
1102: WHERE b.amb_context_code = p_amb_context_code
1103: AND EXISTS (SELECT 1
1104: FROM xla_aad_header_ac_assgns xah
1105: WHERE xah.analytical_criterion_type_code = b.analytical_criterion_type_code

Line 3522: DELETE FROM xla_analytical_sources b

3518: p_module => l_log_module,
3519: p_level => C_LEVEL_PROCEDURE);
3520: END IF;
3521:
3522: DELETE FROM xla_analytical_sources b
3523: WHERE EXISTS (SELECT 1
3524: FROM xla_analytical_hdrs_b h
3525: WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
3526: AND b.analytical_criterion_code = h.analytical_criterion_code

Line 3539: p_encoded_message => '# delete (xla_analytical_sources) = '||SQL%ROWCOUNT,

3535: p_amb_context_code => p_amb_context_code,
3536: p_application_id => p_application_id,
3537: p_request_code => 'IMPORT' ,
3538: p_log_type_code => 'MERGE',
3539: p_encoded_message => '# delete (xla_analytical_sources) = '||SQL%ROWCOUNT,
3540: p_component_code => 'purge_aad');
3541:
3542: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3543: trace(p_msg => '# xla_analytical_sources deleted = '||SQL%ROWCOUNT,

Line 3543: trace(p_msg => '# xla_analytical_sources deleted = '||SQL%ROWCOUNT,

3539: p_encoded_message => '# delete (xla_analytical_sources) = '||SQL%ROWCOUNT,
3540: p_component_code => 'purge_aad');
3541:
3542: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3543: trace(p_msg => '# xla_analytical_sources deleted = '||SQL%ROWCOUNT,
3544: p_module => l_log_module,
3545: p_level => C_LEVEL_PROCEDURE);
3546: END IF;
3547: