APPS.IGW_PROP_COMMENTS_PVT SQL Statements

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

Line: 10

   PROCEDURE Check_Comment_Update_Rights
   (
      p_rowid         IN VARCHAR2,
      x_return_status OUT NOCOPY VARCHAR2
   ) IS

      l_last_updated_by   NUMBER;

Line: 20

      SELECT last_updated_by
      INTO   l_last_updated_by
      FROM   igw_prop_comments
      WHERE  rowid = p_rowid;

Line: 25

      IF l_last_updated_by <> Fnd_Global.User_Id THEN

         x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line: 38

   END Check_Comment_Update_Rights;

Line: 63

         SELECT 'N'
         INTO   l_locked
         FROM   igw_prop_comments
         WHERE  rowid = p_rowid
         AND    record_version_number  = p_record_version_number;

Line: 186

      **   Invoke Table Handler to insert data
      */

      Igw_Prop_Comments_Tbh.Insert_Row
      (
         x_rowid                  => x_rowid,
         p_proposal_id            => l_proposal_id,
         p_comments               => p_comments,
         x_return_status          => l_return_status
      );

Line: 257

   PROCEDURE Update_Prop_Comment
   (
      p_init_msg_list         IN VARCHAR2   := Fnd_Api.G_False,
      p_validate_only         IN VARCHAR2   := Fnd_Api.G_False,
      p_commit                IN VARCHAR2   := Fnd_Api.G_False,
      p_rowid                 IN VARCHAR2,
      p_proposal_id           IN NUMBER,
      p_proposal_number       IN VARCHAR2,
      p_comment_id            IN NUMBER,
      p_comments              IN VARCHAR2,
      p_record_version_number IN NUMBER,
      x_return_status         OUT NOCOPY VARCHAR2,
      x_msg_count             OUT NOCOPY NUMBER,
      x_msg_data              OUT NOCOPY VARCHAR2
   ) IS

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

Line: 285

      SAVEPOINT Update_Prop_Comment_Pvt;

Line: 348

      Check_Comment_Update_Rights
      (
         p_rowid         => p_rowid,
         x_return_status => l_return_status
      );

Line: 417

      **   Invoke Table Handler to Update data
      */

      Igw_Prop_Comments_Tbh.Update_Row
      (
         p_rowid                 => p_rowid,
         p_proposal_id           => l_proposal_id,
         p_comment_id            => p_comment_id,
         p_comments              => p_comments,
         p_record_version_number => p_record_version_number,
         x_return_status         => x_return_status
      );

Line: 446

         ROLLBACK TO Update_Prop_Comment_Pvt;

Line: 458

         ROLLBACK TO Update_Prop_Comment_Pvt;

Line: 470

         ROLLBACK TO Update_Prop_Comment_Pvt;

Line: 486

   END Update_Prop_Comment;

Line: 490

   PROCEDURE Delete_Prop_Comment
   (
      p_init_msg_list         IN VARCHAR2   := Fnd_Api.G_False,
      p_validate_only         IN VARCHAR2   := Fnd_Api.G_False,
      p_commit                IN VARCHAR2   := Fnd_Api.G_False,
      p_rowid                 IN VARCHAR2,
      p_proposal_id           IN NUMBER,
      p_record_version_number IN NUMBER,
      x_return_status         OUT NOCOPY VARCHAR2,
      x_msg_count             OUT NOCOPY NUMBER,
      x_msg_data              OUT NOCOPY VARCHAR2
   ) IS

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

Line: 513

      SAVEPOINT Delete_Prop_Comment_Pvt;

Line: 550

      Check_Comment_Update_Rights
      (
         p_rowid         => p_rowid,
         x_return_status => l_return_status
      );

Line: 603

      **   Invoke Table Handler to Delete data
      */

      Igw_Prop_Comments_Tbh.Delete_Row
      (
         p_rowid                  => p_rowid,
         p_record_version_number  => p_record_version_number,
         x_return_status          => x_return_status
      );

Line: 629

         ROLLBACK TO Delete_Prop_Comment_Pvt;

Line: 641

         ROLLBACK TO Delete_Prop_Comment_Pvt;

Line: 653

         ROLLBACK TO Delete_Prop_Comment_Pvt;

Line: 669

   END Delete_Prop_Comment;