APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_CONDITIONS

Line 545: DELETE FROM xla_conditions

541:
542: --
543: -- Delete conditions
544: --
545: DELETE FROM xla_conditions
546: WHERE application_id = p_application_id
547: AND amb_context_code = p_amb_context_code
548: AND segment_rule_detail_id IS NULL; -- bug 4367287: delete ADR on demand
549:

Line 557: p_encoded_message => '# delete (xla_conditions) = '||SQL%ROWCOUNT,

553: p_amb_context_code => p_amb_context_code,
554: p_application_id => p_application_id,
555: p_request_code => 'IMPORT' ,
556: p_log_type_code => 'MERGE',
557: p_encoded_message => '# delete (xla_conditions) = '||SQL%ROWCOUNT,
558: p_component_code => 'purge');
559:
560: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
561: trace(p_msg => '# record deleted from xla_conditions = '||SQL%ROWCOUNT,

Line 561: trace(p_msg => '# record deleted from xla_conditions = '||SQL%ROWCOUNT,

557: p_encoded_message => '# delete (xla_conditions) = '||SQL%ROWCOUNT,
558: p_component_code => 'purge');
559:
560: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
561: trace(p_msg => '# record deleted from xla_conditions = '||SQL%ROWCOUNT,
562: p_module => l_log_module,
563: p_level => C_LEVEL_STATEMENT);
564: END IF;
565:

Line 988: FROM xla_conditions

984: FOR UPDATE OF p.application_id NOWAIT;
985:
986: CURSOR c_conditions IS
987: SELECT *
988: FROM xla_conditions
989: WHERE application_id = p_application_id
990: AND amb_context_code = p_amb_context_code
991: FOR UPDATE NOWAIT;
992:

Line 3502: DELETE FROM xla_conditions

3498: p_module => l_log_module,
3499: p_level => C_LEVEL_PROCEDURE);
3500: END IF;
3501:
3502: DELETE FROM xla_conditions
3503: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3504: AND application_id = p_application_id;
3505:
3506: -- Bug 16208537

Line 3513: p_encoded_message => '# delete (xla_conditions) = '||SQL%ROWCOUNT,

3509: p_amb_context_code => p_amb_context_code,
3510: p_application_id => p_application_id,
3511: p_request_code => 'IMPORT' ,
3512: p_log_type_code => 'MERGE',
3513: p_encoded_message => '# delete (xla_conditions) = '||SQL%ROWCOUNT,
3514: p_component_code => 'purge_aad');
3515:
3516: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3517: trace(p_msg => '# xla_conditions deleted = '||SQL%ROWCOUNT,

Line 3517: trace(p_msg => '# xla_conditions deleted = '||SQL%ROWCOUNT,

3513: p_encoded_message => '# delete (xla_conditions) = '||SQL%ROWCOUNT,
3514: p_component_code => 'purge_aad');
3515:
3516: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3517: trace(p_msg => '# xla_conditions deleted = '||SQL%ROWCOUNT,
3518: p_module => l_log_module,
3519: p_level => C_LEVEL_PROCEDURE);
3520: END IF;
3521: