APPS.AMS_ACTMETRIC_PUB SQL Statements

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

Line: 134

PROCEDURE Delete_ActMetric(
   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_activity_metric_id    IN  NUMBER,
   p_object_version    	   IN  NUMBER
)
IS

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

Line: 155

   SAVEPOINT delete_actmetric_pub;

Line: 164

   AMS_ActMetric_PVT.Delete_ActMetric(
      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_activity_metric_id      => l_act_metric_id,
      p_object_version_number   => l_object_version
   );

Line: 198

      ROLLBACK TO delete_actmetric_pub;

Line: 207

      ROLLBACK TO delete_actmetric_pub;

Line: 217

      ROLLBACK TO delete_actmetric_pub;

Line: 231

END Delete_ActMetric;

Line: 349

PROCEDURE Update_ActMetric(
   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_act_metric_rec    IN  AMS_ActMetric_PVT.act_metric_rec_type
)
IS

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

Line: 369

   SAVEPOINT update_actmetric_pub;

Line: 378

   AMS_ActMetric_PVT.Update_ActMetric(
      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_act_metric_rec   => l_act_metric_rec
   );

Line: 411

      ROLLBACK TO update_actmetric_pub;

Line: 420

      ROLLBACK TO update_actmetric_pub;

Line: 430

      ROLLBACK TO update_actmetric_pub;

Line: 444

END Update_ActMetric;