APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_DESCRIPTIONS_TL

Line 673: DELETE FROM xla_descriptions_tl

669: p_module => l_log_module,
670: p_level => C_LEVEL_STATEMENT);
671: END IF;
672:
673: DELETE FROM xla_descriptions_tl
674: WHERE application_id = p_application_id
675: AND amb_context_code = p_amb_context_code;
676:
677: -- Bug : 16208537

Line 684: p_encoded_message => '# delete (xla_descriptions_tl) = '||SQL%ROWCOUNT,

680: p_amb_context_code => p_amb_context_code,
681: p_application_id => p_application_id,
682: p_request_code => 'IMPORT' ,
683: p_log_type_code => 'MERGE',
684: p_encoded_message => '# delete (xla_descriptions_tl) = '||SQL%ROWCOUNT,
685: p_component_code => 'purge');
686:
687: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
688: trace(p_msg => '# record deleted from xla_descriptions_tl = '||SQL%ROWCOUNT,

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

684: p_encoded_message => '# delete (xla_descriptions_tl) = '||SQL%ROWCOUNT,
685: p_component_code => 'purge');
686:
687: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
688: trace(p_msg => '# record deleted from xla_descriptions_tl = '||SQL%ROWCOUNT,
689: p_module => l_log_module,
690: p_level => C_LEVEL_STATEMENT);
691: END IF;
692:

Line 961: FROM xla_descriptions_tl

957: FOR UPDATE NOWAIT;
958:
959: CURSOR c_descriptions_tl IS
960: SELECT *
961: FROM xla_descriptions_tl
962: WHERE application_id = p_application_id
963: AND amb_context_code = p_amb_context_code
964: FOR UPDATE NOWAIT;
965:

Line 3774: DELETE FROM xla_descriptions_tl

3770: p_module => l_log_module,
3771: p_level => C_LEVEL_PROCEDURE);
3772: END IF;
3773:
3774: DELETE FROM xla_descriptions_tl
3775: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3776: AND application_id = p_application_id;
3777:
3778: -- Bug 16208537

Line 3785: p_encoded_message => '# delete (xla_descriptions_tl) = '||SQL%ROWCOUNT,

3781: p_amb_context_code => p_amb_context_code,
3782: p_application_id => p_application_id,
3783: p_request_code => 'IMPORT' ,
3784: p_log_type_code => 'MERGE',
3785: p_encoded_message => '# delete (xla_descriptions_tl) = '||SQL%ROWCOUNT,
3786: p_component_code => 'purge_aad');
3787:
3788: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3789: trace(p_msg => '# xla_descriptions_tl deleted = '||SQL%ROWCOUNT,

Line 3789: trace(p_msg => '# xla_descriptions_tl deleted = '||SQL%ROWCOUNT,

3785: p_encoded_message => '# delete (xla_descriptions_tl) = '||SQL%ROWCOUNT,
3786: p_component_code => 'purge_aad');
3787:
3788: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3789: trace(p_msg => '# xla_descriptions_tl deleted = '||SQL%ROWCOUNT,
3790: p_module => l_log_module,
3791: p_level => C_LEVEL_PROCEDURE);
3792: END IF;
3793: