APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ACCT_LINE_TYPES_TL

Line 506: DELETE FROM xla_acct_line_types_tl

502: p_module => l_log_module,
503: p_level => C_LEVEL_STATEMENT);
504: END IF;
505:
506: DELETE FROM xla_acct_line_types_tl
507: WHERE application_id = p_application_id
508: AND amb_context_code = p_amb_context_code;
509:
510: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

507: WHERE application_id = p_application_id
508: AND amb_context_code = p_amb_context_code;
509:
510: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
511: trace(p_msg => '# record deleted from xla_acct_line_types_tl = '||SQL%ROWCOUNT,
512: p_module => l_log_module,
513: p_level => C_LEVEL_STATEMENT);
514: END IF;
515:

Line 690: FROM xla_acct_line_types_tl

686: FOR UPDATE NOWAIT;
687:
688: CURSOR c_acct_line_types_tl IS
689: SELECT *
690: FROM xla_acct_line_types_tl
691: WHERE application_id = p_application_id
692: AND amb_context_code = p_amb_context_code
693: FOR UPDATE NOWAIT;
694:

Line 2850: DELETE FROM xla_acct_line_types_tl

2846: p_module => l_log_module,
2847: p_level => C_LEVEL_PROCEDURE);
2848: END IF;
2849:
2850: DELETE FROM xla_acct_line_types_tl
2851: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2852: AND application_id = p_application_id;
2853:
2854: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2855: trace(p_msg => '# xla_acct_line_types_tl deleted = '||SQL%ROWCOUNT,

2851: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2852: AND application_id = p_application_id;
2853:
2854: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2855: trace(p_msg => '# xla_acct_line_types_tl deleted = '||SQL%ROWCOUNT,
2856: p_module => l_log_module,
2857: p_level => C_LEVEL_PROCEDURE);
2858: END IF;
2859: