APPS.AMS_METRIC_PUB SQL Statements

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

Line: 134

PROCEDURE Delete_Metric(
   p_api_version       IN  NUMBER,
   p_init_msg_list     IN  VARCHAR2 := FND_API.g_false,
   p_commit            IN  VARCHAR2 := FND_API.g_false,

   x_return_status     OUT NOCOPY VARCHAR2,
   x_msg_count         OUT NOCOPY NUMBER,
   x_msg_data          OUT NOCOPY VARCHAR2,

   p_metric_id         IN  NUMBER,
   p_object_version    IN  NUMBER
)
IS

   l_api_name       CONSTANT VARCHAR2(30) := 'Delete_Metric';

Line: 155

   SAVEPOINT delete_metric_pub;

Line: 164

   AMS_Metric_PVT.Delete_Metric(
      p_api_version      		=> p_api_version,
      p_init_msg_list    		=> FND_API.g_false, --has done before
      p_commit           		=> FND_API.g_false, -- will do after

      x_return_status    		=> l_return_status,
      x_msg_count        		=> x_msg_count,
      x_msg_data         		=> x_msg_data,

      p_metric_id        		=> l_metric_id,
      p_object_version_number   => l_object_version
   );

Line: 198

      ROLLBACK TO delete_metric_pub;

Line: 207

      ROLLBACK TO delete_metric_pub;

Line: 217

      ROLLBACK TO delete_metric_pub;

Line: 231

END Delete_Metric;

Line: 349

PROCEDURE Update_Metric(
   p_api_version       IN  NUMBER,
   p_init_msg_list     IN  VARCHAR2  := FND_API.g_false,
   p_commit            IN  VARCHAR2  := FND_API.g_false,
   p_validation_level  IN  NUMBER    := FND_API.g_valid_level_full,

   x_return_status     OUT NOCOPY VARCHAR2,
   x_msg_count         OUT NOCOPY NUMBER,
   x_msg_data          OUT NOCOPY VARCHAR2,

   p_metric_rec        IN  AMS_Metric_PVT.metric_rec_type
)
IS

   l_api_name       CONSTANT VARCHAR2(30) := 'Update_Metric';

Line: 369

   SAVEPOINT update_metric_pub;

Line: 378

   AMS_Metric_PVT.Update_Metric(
      p_api_version      => p_api_version,
      p_init_msg_list    => FND_API.g_false, --has done before
      p_commit           => FND_API.g_false, -- will do after
      p_validation_level => p_validation_level,

      x_return_status    => l_return_status,
      x_msg_count        => x_msg_count,
      x_msg_data         => x_msg_data,

      p_metric_rec       => l_metric_rec
   );

Line: 411

      ROLLBACK TO update_metric_pub;

Line: 420

      ROLLBACK TO update_metric_pub;

Line: 430

      ROLLBACK TO update_metric_pub;

Line: 444

END Update_Metric;