DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ACCTG_METHOD_RULES

Line 216: DELETE FROM xla_acctg_method_rules

212:
213: --
214: -- Delete accounting method rules
215: --
216: DELETE FROM xla_acctg_method_rules
217: WHERE application_id = p_application_id
218: AND amb_context_code = p_amb_context_code;
219:
220: -- Bug : --Bug 16208537

Line 227: p_encoded_message => '# delete (xla_acctg_method_rules) = '||SQL%ROWCOUNT,

223: p_amb_context_code => p_amb_context_code,
224: p_application_id => p_application_id,
225: p_request_code => 'IMPORT' ,
226: p_log_type_code => 'MERGE',
227: p_encoded_message => '# delete (xla_acctg_method_rules) = '||SQL%ROWCOUNT,
228: p_component_code => 'purge');
229:
230: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
231: trace(p_msg => '# record deleted from xla_acctg_method_rules = '||SQL%ROWCOUNT,

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

227: p_encoded_message => '# delete (xla_acctg_method_rules) = '||SQL%ROWCOUNT,
228: p_component_code => 'purge');
229:
230: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
231: trace(p_msg => '# record deleted from xla_acctg_method_rules = '||SQL%ROWCOUNT,
232: p_module => l_log_module,
233: p_level => C_LEVEL_STATEMENT);
234: END IF;
235:

Line 3161: DELETE FROM xla_acctg_method_rules

3157: p_module => l_log_module,
3158: p_level => C_LEVEL_PROCEDURE);
3159: END IF;
3160:
3161: DELETE FROM xla_acctg_method_rules
3162: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3163: AND application_id = p_application_id;
3164:
3165: -- Bug 16208537

Line 3172: p_encoded_message => '# delete (xla_acctg_method_rules) = '||SQL%ROWCOUNT,

3168: p_amb_context_code => p_amb_context_code,
3169: p_application_id => p_application_id,
3170: p_request_code => 'IMPORT' ,
3171: p_log_type_code => 'MERGE',
3172: p_encoded_message => '# delete (xla_acctg_method_rules) = '||SQL%ROWCOUNT,
3173: p_component_code => 'purge_aad');
3174:
3175: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3176: trace(p_msg => '# xla_acctg_method_rules deleted = '||SQL%ROWCOUNT,

Line 3176: trace(p_msg => '# xla_acctg_method_rules deleted = '||SQL%ROWCOUNT,

3172: p_encoded_message => '# delete (xla_acctg_method_rules) = '||SQL%ROWCOUNT,
3173: p_component_code => 'purge_aad');
3174:
3175: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3176: trace(p_msg => '# xla_acctg_method_rules deleted = '||SQL%ROWCOUNT,
3177: p_module => l_log_module,
3178: p_level => C_LEVEL_PROCEDURE);
3179: END IF;
3180: