DBA Data[Home] [Help]

APPS.AHL_UMP_SR_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 99

PROCEDURE Process_SR_Updates
(
   x_return_status         OUT  NOCOPY   VARCHAR2) IS

   l_api_name               CONSTANT VARCHAR2(30) := 'Process_SR_Updates';
Line: 104

   L_DEBUG_KEY              CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Process_SR_Updates';
Line: 116

    FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'About to call AHL_UMP_SR_PVT.Process_SR_Updates');
Line: 119

  AHL_UMP_SR_PVT.Process_SR_Updates(
    x_return_status         => x_return_status
  );
Line: 124

    FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Returned from call to AHL_UMP_SR_PVT.Process_SR_Updates. x_return_status = ' || x_return_status);
Line: 142

                               p_procedure_name => 'Process_SR_Updates',
                               p_error_text     => SUBSTR(SQLERRM,1,240));
Line: 146

END Process_SR_Updates;