APPS.AMS_LISTENTRY_PUB SQL Statements

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

Line: 148

PROCEDURE update_listentry(
   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_entry_rec          IN  AMS_LISTENTRY_PVT.entry_rec_type
) IS

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

Line: 171

   SAVEPOINT update_listentry_pub;

Line: 179

   AMS_LISTENTRY_PVT.update_listentry
   ( p_api_version      => p_api_version,
     p_init_msg_list    => FND_API.g_false,
     p_commit           => FND_API.g_false,
     p_validation_level => FND_API.g_valid_level_full,
     x_return_status    => l_return_status,
     x_msg_count        => x_msg_count,
     x_msg_data         => x_msg_data,
     p_entry_rec        => l_listentry_rec);

Line: 209

      ROLLBACK TO update_listentry_pub;

Line: 218

      ROLLBACK TO update_listentry_pub;

Line: 228

      ROLLBACK TO update_listentry_pub;

Line: 243

  END update_listentry;

Line: 259

PROCEDURE delete_listentry(
   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_entry_id                IN  NUMBER,
   p_object_version_number   IN  NUMBER
) IS

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

Line: 283

   SAVEPOINT delete_listentry_pub;

Line: 291

   AMS_LISTENTRY_PVT.delete_listentry(
   p_api_version           => p_api_version,
   p_init_msg_list         => FND_API.g_false,
   p_commit                => FND_API.g_false,
   p_validation_level      => FND_API.g_valid_level_full,

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

   p_entry_id              => l_entry_id,
   p_object_version_number => l_object_version_number);

Line: 324

      ROLLBACK TO delete_listentry_pub;

Line: 333

      ROLLBACK TO delete_listentry_pub;

Line: 343

      ROLLBACK TO delete_listentry_pub;

Line: 356

  END delete_listentry;