APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_JLT_ACCT_ATTRS

Line 496: DELETE FROM xla_jlt_acct_attrs

492:
493: --
494: -- Delete journal line types
495: --
496: DELETE FROM xla_jlt_acct_attrs
497: WHERE application_id = p_application_id
498: AND amb_context_code = p_amb_context_code;
499:
500: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

497: WHERE application_id = p_application_id
498: AND amb_context_code = p_amb_context_code;
499:
500: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
501: trace(p_msg => '# record deleted from xla_jlt_acct_attrs = '||SQL%ROWCOUNT,
502: p_module => l_log_module,
503: p_level => C_LEVEL_STATEMENT);
504: END IF;
505:

Line 697: FROM xla_jlt_acct_attrs

693: FOR UPDATE NOWAIT;
694:
695: CURSOR c_jlt_acct_attrs IS
696: SELECT *
697: FROM xla_jlt_acct_attrs
698: WHERE application_id = p_application_id
699: AND amb_context_code = p_amb_context_code
700: FOR UPDATE NOWAIT;
701:

Line 2592: DELETE FROM xla_jlt_acct_attrs

2588: p_module => l_log_module,
2589: p_level => C_LEVEL_PROCEDURE);
2590: END IF;
2591:
2592: DELETE FROM xla_jlt_acct_attrs
2593: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2594: AND application_id = p_application_id;
2595:
2596: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2597: trace(p_msg => '# xla_jlt_acct_attrs deleted = '||SQL%ROWCOUNT,

2593: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2594: AND application_id = p_application_id;
2595:
2596: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2597: trace(p_msg => '# xla_jlt_acct_attrs deleted = '||SQL%ROWCOUNT,
2598: p_module => l_log_module,
2599: p_level => C_LEVEL_PROCEDURE);
2600: END IF;
2601: