APPS.AMS_EVENTHEADER_PUB SQL Statements

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

Line: 183

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

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

Line: 204

   SAVEPOINT delete_EventHeader_pub;

Line: 215

      AMS_EventHeader_CUHK.delete_EventHeader_pre(
         l_evh_id,
         l_object_version,
         l_return_status
      );

Line: 231

      AMS_EventHeader_VUHK.delete_EventHeader_pre(
         l_evh_id,
         l_object_version,
         l_return_status
      );

Line: 245

   AMS_EventHeader_PVT.delete_event_header(
      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_evh_id          => l_evh_id,
      p_object_version   => l_object_version
   );

Line: 267

      AMS_EventHeader_VUHK.delete_EventHeader_post(
         l_evh_id,
         l_object_version,
         l_return_status
      );

Line: 283

      AMS_EventHeader_CUHK.delete_EventHeader_post(
         l_evh_id,
         l_object_version,
         l_return_status
      );

Line: 310

      ROLLBACK TO delete_EventHeader_pub;

Line: 319

      ROLLBACK TO delete_EventHeader_pub;

Line: 329

      ROLLBACK TO delete_EventHeader_pub;

Line: 343

END delete_EventHeader;

Line: 517

PROCEDURE update_EventHeader(
   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_evh_rec          IN  AMS_EventHeader_PVT.evh_rec_type
)
IS

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

Line: 537

   SAVEPOINT update_EventHeader_pub;

Line: 548

      AMS_EventHeader_CUHK.update_EventHeader_pre(
         l_evh_rec,
         l_return_status
      );

Line: 563

      AMS_EventHeader_VUHK.update_EventHeader_pre(
         l_evh_rec,
         l_return_status
      );

Line: 576

   AMS_EventHeader_PVT.update_event_header(
      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_evh_rec         => l_evh_rec
   );

Line: 598

      AMS_EventHeader_VUHK.update_EventHeader_post(
         l_evh_rec,
         l_return_status
      );

Line: 613

      AMS_EventHeader_CUHK.update_EventHeader_post(
         l_evh_rec,
         l_return_status
      );

Line: 638

      ROLLBACK TO update_EventHeader_pub;

Line: 647

      ROLLBACK TO update_EventHeader_pub;

Line: 657

      ROLLBACK TO update_EventHeader_pub;

Line: 671

END update_EventHeader;