APPS.IGW_PROP_COMMENTS_TBH SQL Statements

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

Line: 10

   PROCEDURE Insert_Row
   (
      x_rowid              OUT NOCOPY VARCHAR2,
      p_proposal_id        IN NUMBER,
      p_comments           IN VARCHAR2,
      x_return_status      OUT NOCOPY VARCHAR2,
      p_mode               IN VARCHAR2
   ) IS

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

Line: 21

      l_last_update_date  DATE         := SYSDATE;

Line: 22

      l_last_updated_by   NUMBER       := Nvl(Fnd_Global.User_Id,-1);

Line: 23

      l_last_update_login NUMBER       := Nvl(Fnd_Global.Login_Id,-1);

Line: 26

      SELECT rowid
      FROM   igw_prop_comments
      WHERE  proposal_id = p_proposal_id AND
             comments = p_comments AND
             trunc(last_update_date) = trunc(SYSDATE);

Line: 38

         l_last_updated_by := 1;

Line: 39

         l_last_update_login := 0;

Line: 48

      INSERT INTO igw_prop_comments
      (
         proposal_id,
         comment_id,
         comments,
         record_version_number,
         creation_date,
         created_by,
         last_update_date,
         last_updated_by,
         last_update_login
      )
      VALUES
      (
         p_proposal_id,                             /* proposal_id */
         igw_prop_comments_s.nextval,                /* comment_id */
         p_comments,                                   /* comments */
         1,                               /* record_version_number */
         l_last_update_date,                      /* creation_date */
         l_last_updated_by,                          /* created_by */
         l_last_update_date,                   /* last_update_date */
         l_last_updated_by,                     /* last_updated_by */
         l_last_update_login                  /* last_update_login */
      );

Line: 99

   END Insert_Row;

Line: 103

   PROCEDURE Update_Row
   (
      p_rowid                 IN VARCHAR2,
      p_proposal_id           IN NUMBER,
      p_comment_id            IN NUMBER,
      p_comments              IN VARCHAR2,
      p_record_version_number IN NUMBER,
      x_return_status         OUT NOCOPY VARCHAR2,
      p_mode                  IN VARCHAR2
   ) IS

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

Line: 116

      l_last_update_date  DATE         := SYSDATE;

Line: 117

      l_last_updated_by   NUMBER       := Nvl(Fnd_Global.User_Id,-1);

Line: 118

      l_last_update_login NUMBER       := Nvl(Fnd_Global.Login_Id,-1);

Line: 126

         l_last_updated_by := 1;

Line: 127

         l_last_update_login := 0;

Line: 137

      UPDATE igw_prop_comments
      SET    comments = p_comments,
             record_version_number = record_version_number + 1,
             last_update_date = l_last_update_date,
             last_updated_by = l_last_updated_by,
             last_update_login = l_last_update_login
      WHERE  ((rowid = p_rowid) OR
              (proposal_id = p_proposal_id AND comment_id = p_comment_id))
      AND    record_version_number = p_record_version_number;

Line: 169

   END Update_Row;

Line: 173

   PROCEDURE Delete_Row
   (
      p_rowid                  IN VARCHAR2,
      p_record_version_number  IN NUMBER,
      x_return_status          OUT NOCOPY VARCHAR2
   ) IS

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

Line: 186

      DELETE igw_prop_comments
      WHERE  rowid = p_rowid
      AND    record_version_number = p_record_version_number;

Line: 212

   END Delete_Row;