APPS.AMS_EVENTOFFER_PUB SQL Statements

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

Line: 187

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

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

Line: 208

   SAVEPOINT delete_EventOffer_pub;

Line: 219

      AMS_EventOffer_CUHK.delete_EventOffer_pre(
         l_evo_id,
         l_object_version,
         l_return_status
      );

Line: 235

      AMS_EventOffer_VUHK.delete_EventOffer_pre(
         l_evo_id,
         l_object_version,
         l_return_status
      );

Line: 249

   AMS_EventOffer_PVT.delete_Event_Offer(
      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_evo_id          => l_evo_id,
      p_object_version   => l_object_version
   );

Line: 271

      AMS_EventOffer_VUHK.delete_EventOffer_post(
         l_evo_id,
         l_object_version,
         l_return_status
      );

Line: 287

      AMS_EventOffer_CUHK.delete_EventOffer_post(
         l_evo_id,
         l_object_version,
         l_return_status
      );

Line: 314

      ROLLBACK TO delete_EventOffer_pub;

Line: 323

      ROLLBACK TO delete_EventOffer_pub;

Line: 333

      ROLLBACK TO delete_EventOffer_pub;

Line: 347

END delete_EventOffer;

Line: 521

PROCEDURE update_EventOffer(
   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_evo_rec          IN  AMS_EventOffer_PVT.evo_rec_type
)
IS

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

Line: 541

   SAVEPOINT update_EventOffer_pub;

Line: 552

      AMS_EventOffer_CUHK.update_EventOffer_pre(
         l_evo_rec,
         l_return_status
      );

Line: 567

      AMS_EventOffer_VUHK.update_EventOffer_pre(
         l_evo_rec,
         l_return_status
      );

Line: 580

   AMS_EventOffer_PVT.update_Event_Offer(
      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_evo_rec         => l_evo_rec
   );

Line: 602

      AMS_EventOffer_VUHK.update_EventOffer_post(
         l_evo_rec,
         l_return_status
      );

Line: 617

      AMS_EventOffer_CUHK.update_EventOffer_post(
         l_evo_rec,
         l_return_status
      );

Line: 642

      ROLLBACK TO update_EventOffer_pub;

Line: 651

      ROLLBACK TO update_EventOffer_pub;

Line: 661

      ROLLBACK TO update_EventOffer_pub;

Line: 675

END update_EventOffer;