APPS.AMS_LISTACTION_PUB SQL Statements

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

Line: 145

PROCEDURE Update_ListAction
( 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_action_rec                           IN     AMS_LISTACTION_PVT.action_rec_type
) IS

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

Line: 167

   SAVEPOINT update_listaction_pub;

Line: 175

   AMS_LISTACTION_PVT.Update_ListAction
   ( 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_action_rec       => l_action_rec);

Line: 205

      ROLLBACK TO update_listaction_pub;

Line: 224

      ROLLBACK TO update_listaction_pub;

Line: 239

End Update_ListAction;

Line: 257

PROCEDURE Delete_ListAction
( 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_action_id                           IN     NUMBER
) IS

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

Line: 279

   SAVEPOINT Delete_ListAction_pub;

Line: 287

   Delete_ListAction
   ( 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_action_id        => l_action_id);

Line: 319

      ROLLBACK TO Delete_ListAction_pub;

Line: 338

      ROLLBACK TO Delete_ListAction_pub;

Line: 351

  END Delete_ListAction;