APPS.AMS_CAMPAIGN_PUB SQL Statements

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

Line: 183

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

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

Line: 204

   SAVEPOINT delete_campaign_pub;

Line: 215

      AMS_Campaign_CUHK.delete_campaign_pre(
         l_camp_id,
         l_object_version,
         l_return_status
      );

Line: 231

      AMS_Campaign_VUHK.delete_campaign_pre(
         l_camp_id,
         l_object_version,
         l_return_status
      );

Line: 245

   AMS_Campaign_PVT.delete_campaign(
      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_camp_id          => l_camp_id,
      p_object_version   => l_object_version
   );

Line: 267

      AMS_Campaign_VUHK.delete_campaign_post(
         l_camp_id,
         l_object_version,
         l_return_status
      );

Line: 283

      AMS_Campaign_CUHK.delete_campaign_post(
         l_camp_id,
         l_object_version,
         l_return_status
      );

Line: 310

      ROLLBACK TO delete_campaign_pub;

Line: 319

      ROLLBACK TO delete_campaign_pub;

Line: 329

      ROLLBACK TO delete_campaign_pub;

Line: 343

END delete_campaign;

Line: 517

PROCEDURE update_campaign(
   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_camp_rec          IN  AMS_Campaign_PVT.camp_rec_type
)
IS

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

Line: 537

   SAVEPOINT update_campaign_pub;

Line: 548

      AMS_Campaign_CUHK.update_campaign_pre(
         l_camp_rec,
         l_return_status
      );

Line: 563

      AMS_Campaign_VUHK.update_campaign_pre(
         l_camp_rec,
         l_return_status
      );

Line: 576

   AMS_Campaign_PVT.update_campaign(
      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_camp_rec         => l_camp_rec
   );

Line: 598

      AMS_Campaign_VUHK.update_campaign_post(
         l_camp_rec,
         l_return_status
      );

Line: 613

      AMS_Campaign_CUHK.update_campaign_post(
         l_camp_rec,
         l_return_status
      );

Line: 638

      ROLLBACK TO update_campaign_pub;

Line: 647

      ROLLBACK TO update_campaign_pub;

Line: 657

      ROLLBACK TO update_campaign_pub;

Line: 671

END update_campaign;