DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AAD_HDR_ACCT_ATTRS

Line 339: DELETE FROM xla_aad_hdr_acct_attrs

335: p_module => l_log_module,
336: p_level => C_LEVEL_STATEMENT);
337: END IF;
338:
339: DELETE FROM xla_aad_hdr_acct_attrs
340: WHERE application_id = p_application_id
341: AND amb_context_code = p_amb_context_code;
342:
343: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

340: WHERE application_id = p_application_id
341: AND amb_context_code = p_amb_context_code;
342:
343: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
344: trace(p_msg => '# record deleted from xla_aad_hdr_acct_attrs = '||SQL%ROWCOUNT,
345: p_module => l_log_module,
346: p_level => C_LEVEL_STATEMENT);
347: END IF;
348:

Line 578: FROM xla_aad_hdr_acct_attrs

574: FOR UPDATE NOWAIT;
575:
576: CURSOR c_aad_hdr_acct_attrs IS
577: SELECT *
578: FROM xla_aad_hdr_acct_attrs
579: WHERE application_id = p_application_id
580: AND amb_context_code = p_amb_context_code
581: FOR UPDATE NOWAIT;
582:

Line 2522: DELETE FROM xla_aad_hdr_acct_attrs

2518: p_module => l_log_module,
2519: p_level => C_LEVEL_PROCEDURE);
2520: END IF;
2521:
2522: DELETE FROM xla_aad_hdr_acct_attrs
2523: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2524: AND application_id = p_application_id;
2525:
2526: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2527: trace(p_msg => '# xla_aad_hdr_acct_attrs deleted = '||SQL%ROWCOUNT,

2523: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2524: AND application_id = p_application_id;
2525:
2526: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2527: trace(p_msg => '# xla_aad_hdr_acct_attrs deleted = '||SQL%ROWCOUNT,
2528: p_module => l_log_module,
2529: p_level => C_LEVEL_PROCEDURE);
2530: END IF;
2531: