APPS.AMS_ACTRESOURCE_PUB SQL Statements

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

Line: 32

       x_act_resource_rec_pvt.last_update_date               :=  l_act_resource_rec_pub.last_update_date;

Line: 33

       x_act_resource_rec_pvt.last_updated_by                :=  l_act_resource_rec_pub.last_updated_by ;

Line: 36

       x_act_resource_rec_pvt.last_update_login              :=  l_act_resource_rec_pub.last_update_login;

Line: 288

PROCEDURE Update_Act_Resource
( 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_act_Resource_rec IN  act_Resource_rec_type
) IS

L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Act_Resource';

Line: 309

      SAVEPOINT Update_Act_Resource_PUB;

Line: 329

      AMS_ActResource_CUHK.update_resource_pre(
         l_pub_resource_rec,
         l_return_status
      );

Line: 344

      AMS_ActResource_VUHK.update_resource_pre(
         l_pub_resource_rec,
         l_return_status
      );

Line: 357

    AMS_ActResource_PVT.Update_Act_Resource(
       p_api_version                => 1.0,
       p_init_msg_list              => p_init_msg_list,
       p_commit                     => p_commit,
       p_validation_level           => p_validation_level,
       x_return_status              => x_return_status,
       x_msg_count                  => x_msg_count,
       x_msg_data                   => x_msg_data,
       p_Act_Resource_rec           => l_pvt_resource_rec
    );

Line: 382

      AMS_ActResource_VUHK.update_resource_post(
         l_pub_resource_rec,
         l_return_status
      );

Line: 397

      AMS_ActResource_CUHK.update_resource_post(
         l_pub_resource_rec,
         l_return_status
      );

Line: 435

     ROLLBACK TO Update_Act_Resource_PUB;

Line: 445

     ROLLBACK TO Update_Act_Resource_PUB;

Line: 455

     ROLLBACK TO Update_Act_Resource_PUB;

Line: 467

End Update_Act_Resource;

Line: 484

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

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

Line: 504

      SAVEPOINT Delete_Act_Resource_PUB;

Line: 521

      AMS_ActResource_CUHK.delete_resource_pre(
         l_resource_id,
         l_object_version,
         l_return_status
      );

Line: 537

      AMS_ActResource_VUHK.delete_resource_pre(
         l_resource_id,
         l_object_version,
         l_return_status
      );

Line: 551

    AMS_ActResource_PVT.Delete_Act_Resource(
       p_api_version                => 1.0,
       p_init_msg_list              => p_init_msg_list,
       p_commit                     => p_commit,
       p_validation_level           => p_validation_level,
       x_return_status              => x_return_status,
       x_msg_count                  => x_msg_count,
       x_msg_data                   => x_msg_data,
       p_Act_Resource_id            => l_resource_id,
       p_object_version             => l_object_version
       );

Line: 577

      AMS_ActResource_VUHK.delete_resource_post(
         l_resource_id,
         l_object_version,
         l_return_status
      );

Line: 593

      AMS_ActResource_CUHK.delete_resource_post(
         l_resource_id,
         l_object_version,
         l_return_status
      );

Line: 632

     ROLLBACK TO Delete_Act_Resource_PUB;

Line: 642

     ROLLBACK TO Delete_Act_Resource_PUB;

Line: 652

     ROLLBACK TO Delete_Act_Resource_PUB;

Line: 665

END Delete_Act_Resource;