APPS.AMS_DELIVERABLE_PUB SQL Statements

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

Line: 36

       x_deliv_rec_pvt.last_update_date               :=  l_deliv_rec_pub.last_update_date;

Line: 37

       x_deliv_rec_pvt.last_updated_by                :=  l_deliv_rec_pub.last_updated_by ;

Line: 40

       x_deliv_rec_pvt.last_update_login              :=  l_deliv_rec_pub.last_update_login;

Line: 46

x_deliv_rec_pvt.last_update_date                     :=  l_deliv_rec_pub.last_update_date;

Line: 47

x_deliv_rec_pvt.last_updated_by                      :=  l_deliv_rec_pub.last_updated_by;

Line: 50

x_deliv_rec_pvt.last_update_login                    :=  l_deliv_rec_pub.last_update_login;

Line: 465

PROCEDURE Update_Deliverable(
    p_api_version_number         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_deliv_rec                  IN  deliv_rec_type
    )

 IS

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

Line: 488

       SAVEPOINT UPDATE_Deliv_PUB;

Line: 518

      update_Deliverable(
         p_api_version_number     => p_api_version_number,
         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_deliv_rec              => l_pvt_deliv_rec );

Line: 556

      ROLLBACK TO UPDATE_Deliv_PUB;

Line: 566

      ROLLBACK TO UPDATE_Deliv_PUB;

Line: 576

      ROLLBACK TO UPDATE_Deliv_PUB;

Line: 589

End Update_Deliverable;

Line: 592

PROCEDURE Update_Deliverable(
    p_api_version_number         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_deliv_rec                  IN  AMS_Deliverable_PVT.deliv_rec_type
    )

 IS

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

Line: 614

       SAVEPOINT UPDATE_Deliverable_PUB;

Line: 642

      AMS_Deliverable_CUHK.update_deliverable_pre(
         l_pvt_deliv_rec,
         l_return_status
      );

Line: 657

      AMS_Deliverable_VUHK.update_deliverable_pre(
         l_pvt_deliv_rec,
         l_return_status
      );

Line: 672

   AMS_Deliverable_PVT.Update_Deliverable(
     p_api_version         => 1.0,
     p_init_msg_list              => FND_API.G_FALSE,
     p_commit                     => p_commit,
     p_validation_level           => FND_API.G_VALID_LEVEL_FULL,
     x_return_status              => x_return_status,
     x_msg_count                  => x_msg_count,
     x_msg_data                   => x_msg_data,
     p_deliv_rec                  =>  l_pvt_deliv_rec);

Line: 700

      AMS_Deliverable_CUHK.update_deliverable_post(
         l_pvt_deliv_rec,
         l_return_status
      );

Line: 715

      AMS_Deliverable_VUHK.update_deliverable_post(
         l_pvt_deliv_rec,
         l_return_status
      );

Line: 744

      ROLLBACK TO UPDATE_Deliverable_PUB;

Line: 754

      ROLLBACK TO UPDATE_Deliverable_PUB;

Line: 764

      ROLLBACK TO UPDATE_Deliverable_PUB;

Line: 777

End Update_Deliverable;

Line: 780

PROCEDURE Delete_Deliverable(
    p_api_version_number         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_deliv_id                   IN   NUMBER,
    p_object_version_number      IN   NUMBER
    )



 IS

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

Line: 805

       SAVEPOINT DELETE_Deliverable_PUB;

Line: 834

      AMS_Deliverable_CUHK.delete_Deliverable_pre(
         l_deliv_ID,
                 l_object_version_number,
         l_return_status
      );

Line: 850

      AMS_Deliverable_VUHK.delete_Deliverable_pre(
         l_deliv_ID,
                 l_object_version_number,
         l_return_status
      );

Line: 867

     AMS_Deliverable_PVT.Delete_Deliverable(
     p_api_version                => 1.0,
     p_init_msg_list              => FND_API.G_FALSE,
     p_commit                     => p_commit,
     x_return_status              => x_return_status,
     x_msg_count                  => x_msg_count,
     x_msg_data                   => x_msg_data,
     p_deliv_id                   => l_deliv_id,
     p_object_version             => l_object_version_number );

Line: 891

      AMS_Deliverable_CUHK.delete_Deliverable_post(
         l_deliv_ID,
                 l_object_version_number,
         l_return_status
      );

Line: 907

      AMS_Deliverable_VUHK.delete_Deliverable_post(
         l_deliv_ID,
         l_object_version_number,
         l_return_status
      );

Line: 946

      ROLLBACK TO DELETE_Deliverable_PUB;

Line: 956

      ROLLBACK TO DELETE_Deliverable_PUB;

Line: 966

      ROLLBACK TO DELETE_Deliverable_PUB;

Line: 978

 End Delete_Deliverable;