APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_PROD_ACCT_HEADERS

Line 349: DELETE FROM xla_prod_acct_headers

345: p_module => l_log_module,
346: p_level => C_LEVEL_STATEMENT);
347: END IF;
348:
349: DELETE FROM xla_prod_acct_headers
350: WHERE application_id = p_application_id
351: AND amb_context_code = p_amb_context_code;
352:
353: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

350: WHERE application_id = p_application_id
351: AND amb_context_code = p_amb_context_code;
352:
353: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
354: trace(p_msg => '# record deleted from xla_prod_acct_headers = '||SQL%ROWCOUNT,
355: p_module => l_log_module,
356: p_level => C_LEVEL_STATEMENT);
357: END IF;
358:

Line 571: FROM xla_prod_acct_headers

567: FOR UPDATE NOWAIT;
568:
569: CURSOR c_prod_acct_headers IS
570: SELECT *
571: FROM xla_prod_acct_headers
572: WHERE application_id = p_application_id
573: AND amb_context_code = p_amb_context_code
574: FOR UPDATE NOWAIT;
575:

Line 2652: DELETE FROM xla_prod_acct_headers

2648: p_module => l_log_module,
2649: p_level => C_LEVEL_PROCEDURE);
2650: END IF;
2651:
2652: DELETE FROM xla_prod_acct_headers
2653: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2654: AND application_id = p_application_id;
2655:
2656: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2657: trace(p_msg => '# xla_prod_acct_headers deleted = '||SQL%ROWCOUNT,

2653: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2654: AND application_id = p_application_id;
2655:
2656: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2657: trace(p_msg => '# xla_prod_acct_headers deleted = '||SQL%ROWCOUNT,
2658: p_module => l_log_module,
2659: p_level => C_LEVEL_PROCEDURE);
2660: END IF;
2661: