DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_DESCRIPTIONS_B

Line 693: DELETE FROM xla_descriptions_b

689: p_module => l_log_module,
690: p_level => C_LEVEL_STATEMENT);
691: END IF;
692:
693: DELETE FROM xla_descriptions_b
694: WHERE application_id = p_application_id
695: AND amb_context_code = p_amb_context_code;
696:
697: -- Bug : 16208537

Line 704: p_encoded_message => '# delete (xla_descriptions_b) = '||SQL%ROWCOUNT,

700: p_amb_context_code => p_amb_context_code,
701: p_application_id => p_application_id,
702: p_request_code => 'IMPORT' ,
703: p_log_type_code => 'MERGE',
704: p_encoded_message => '# delete (xla_descriptions_b) = '||SQL%ROWCOUNT,
705: p_component_code => 'purge');
706:
707: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
708: trace(p_msg => '# record deleted from xla_descriptions_b = '||SQL%ROWCOUNT,

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

704: p_encoded_message => '# delete (xla_descriptions_b) = '||SQL%ROWCOUNT,
705: p_component_code => 'purge');
706:
707: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
708: trace(p_msg => '# record deleted from xla_descriptions_b = '||SQL%ROWCOUNT,
709: p_module => l_log_module,
710: p_level => C_LEVEL_STATEMENT);
711: END IF;
712:

Line 954: FROM xla_descriptions_b

950: FOR UPDATE NOWAIT;
951:
952: CURSOR c_descriptions_b IS
953: SELECT *
954: FROM xla_descriptions_b
955: WHERE application_id = p_application_id
956: AND amb_context_code = p_amb_context_code
957: FOR UPDATE NOWAIT;
958:

Line 3794: DELETE FROM xla_descriptions_b

3790: p_module => l_log_module,
3791: p_level => C_LEVEL_PROCEDURE);
3792: END IF;
3793:
3794: DELETE FROM xla_descriptions_b
3795: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3796: AND application_id = p_application_id;
3797:
3798: -- Bug 16208537

Line 3805: p_encoded_message => '# delete (xla_descriptions_b) = '||SQL%ROWCOUNT,

3801: p_amb_context_code => p_amb_context_code,
3802: p_application_id => p_application_id,
3803: p_request_code => 'IMPORT' ,
3804: p_log_type_code => 'MERGE',
3805: p_encoded_message => '# delete (xla_descriptions_b) = '||SQL%ROWCOUNT,
3806: p_component_code => 'purge_aad');
3807:
3808: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3809: trace(p_msg => '# xla_descriptions_b deleted = '||SQL%ROWCOUNT,

Line 3809: trace(p_msg => '# xla_descriptions_b deleted = '||SQL%ROWCOUNT,

3805: p_encoded_message => '# delete (xla_descriptions_b) = '||SQL%ROWCOUNT,
3806: p_component_code => 'purge_aad');
3807:
3808: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3809: trace(p_msg => '# xla_descriptions_b deleted = '||SQL%ROWCOUNT,
3810: p_module => l_log_module,
3811: p_level => C_LEVEL_PROCEDURE);
3812: END IF;
3813: