APPS.AMS_LISTHEADER_PUB SQL Statements

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

Line: 134

PROCEDURE Update_ListHeader
( 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_listheader_rec         IN     AMS_LISTHEADER_PVT.list_header_rec_type
 ) IS

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

Line: 154

  SAVEPOINT update_listheader_pub;

Line: 161

  AMS_LISTHEADER_PVT.Update_ListHeader
  ( 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_listheader_rec   =>  l_listheader_rec );

Line: 194

      ROLLBACK TO  update_listheader_pub;

Line: 204

      ROLLBACK TO  update_listheader_pub;

Line: 214

      ROLLBACK TO  update_listheader_pub;

Line: 226

End Update_ListHeader;

Line: 246

PROCEDURE Delete_ListHeader
( 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_listheader_id          IN     number) IS

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

Line: 266

  SAVEPOINT delete_listheader_pub;

Line: 274

      AMS_LISTHEADER_PVT.Delete_ListHeader
      ( 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_listheader_id     => l_listheader_id);

Line: 304

      ROLLBACK TO delete_listheader_pub;

Line: 313

      ROLLBACK TO delete_listheader_pub;

Line: 323

      ROLLBACK TO delete_listheader_pub;

Line: 337

END delete_listheader;

Line: 559

  p_copy_select_actions      IN     VARCHAR2  := 'Y',
  p_copy_list_queries        IN     VARCHAR2  := 'Y',
  p_copy_list_entries        IN     VARCHAR2  := 'Y',

  x_listheader_id            OUT NOCOPY    NUMBER
)IS

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

Line: 591

     p_copy_select_actions =>p_copy_select_actions,
     p_copy_list_queries  =>p_copy_list_queries,
     p_copy_list_entries =>p_copy_list_entries,
     x_listheader_id       => x_listheader_id);