DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AAD_LOADER_LOGS

Line 1581: DELETE FROM xla_aad_loader_logs

1577: p_module => l_log_module,
1578: p_level => C_LEVEL_PROCEDURE);
1579: END IF;
1580:
1581: DELETE FROM xla_aad_loader_logs
1582: WHERE application_id = p_application_id
1583: AND amb_context_code = p_amb_context_code
1584: AND request_code = p_request_code;
1585:

Line 1587: trace(p_msg => '# row deleted into xla_aad_loader_logs = '||SQL%ROWCOUNT,

1583: AND amb_context_code = p_amb_context_code
1584: AND request_code = p_request_code;
1585:
1586: IF (C_LEVEL_EVENT >= g_log_level) THEN
1587: trace(p_msg => '# row deleted into xla_aad_loader_logs = '||SQL%ROWCOUNT,
1588: p_module => l_log_module,
1589: p_level => C_LEVEL_EVENT);
1590: END IF;
1591:

Line 1902: INSERT INTO xla_aad_loader_logs

1898: ,p_module => l_log_module);
1899: END IF;
1900:
1901: FORALL i IN 1 .. g_err_msgs.COUNT
1902: INSERT INTO xla_aad_loader_logs
1903: (aad_loader_log_id
1904: ,amb_context_code
1905: ,application_id
1906: ,request_code

Line 1921: (xla_aad_loader_logs_s.nextval

1917: ,program_application_id
1918: ,program_id
1919: ,request_id)
1920: VALUES
1921: (xla_aad_loader_logs_s.nextval
1922: ,p_amb_context_code
1923: ,p_application_id
1924: ,p_request_code
1925: ,'ERROR'

Line 1940: trace(p_msg => '# errors inserted into xla_aad_loader_logs = '||SQL%ROWCOUNT

1936: ,xla_environment_pkg.g_prog_id
1937: ,xla_environment_pkg.g_req_Id);
1938:
1939: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1940: trace(p_msg => '# errors inserted into xla_aad_loader_logs = '||SQL%ROWCOUNT
1941: ,p_module => l_log_module
1942: ,p_level => C_LEVEL_STATEMENT);
1943: END IF;
1944: