APPS.IGW_PROP_COMMENTS_PKG SQL Statements

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

Line: 4

  PROCEDURE Insert_Row(X_Rowid IN OUT      VARCHAR2,
                       X_Proposal_Id       NUMBER,
                       X_Comment_Id        NUMBER,
                       X_Comments          VARCHAR2,
                       X_Last_Update_Date  DATE,
                       X_Last_Updated_By   NUMBER,
                       X_Creation_Date     DATE,
                       X_Created_By        NUMBER,
                       X_Last_Update_Login NUMBER) IS

CURSOR C IS SELECT rowid FROM IGW_PROP_COMMENTS
            WHERE comment_id = X_comment_ID;

Line: 18

  INSERT INTO IGW_PROP_COMMENTS( PROPOSAL_ID,
                                 COMMENT_ID,
                                 COMMENTS,
                                 LAST_UPDATE_DATE,
                                 LAST_UPDATED_BY,
                                 CREATION_DATE,
                                 CREATED_BY,
                                 LAST_UPDATE_LOGIN) VALUES
                                 ( X_Proposal_Id,
                                  X_Comment_Id        ,
                                  X_Comments          ,
                                  X_Last_Update_Date  ,
                                  X_Last_Updated_By   ,
                                  X_Creation_Date     ,
                                  X_Created_By        ,
                                  X_Last_Update_Login );

Line: 41

END Insert_row;

Line: 47

                       X_Last_Update_Date  DATE,
                       X_Last_Updated_By   NUMBER,
                       X_Creation_Date     DATE,
                       X_Created_By        NUMBER,
                       X_Last_Update_Login NUMBER) IS
   cursor c is select * from IGW_prop_comments
                 where rowid = X_rowid
                 for update of comment_id nowait;

Line: 61

     FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

Line: 70

       AND  (Recinfo.last_update_Date = X_last_update_Date)
       AND  (Recinfo.last_updated_by = X_last_updated_by)
       AND  (Recinfo.creation_date = X_creation_date)
       AND  (Recinfo.created_by = X_created_by)
       AND  (Recinfo.last_update_login = X_last_update_login)) then
     return;

Line: 82

  PROCEDURE Update_Row(X_Rowid               VARCHAR2,
                       X_Proposal_Id       NUMBER,
                       X_Comment_Id        NUMBER,
                       X_Comments          VARCHAR2,
                       X_Last_Update_Date  DATE,
                       X_Last_Updated_By   NUMBER,
                       X_Creation_Date     DATE,
                       X_Created_By        NUMBER,
                       X_Last_Update_Login NUMBER) IS
  begin
   update igw_prop_comments
   set  proposal_id = X_proposal_id,
        comment_id = X_comment_id,
        comments  = X_comments,
        last_update_date = X_last_update_date,
        last_updated_by = X_last_updated_by,
        creation_date = X_creation_date,
        created_by = X_created_by,
        last_update_login = X_last_update_login
   where rowid = X_Rowid;

Line: 105

 End update_row;

Line: 107

  PROCEDURE Delete_Row(X_Rowid             VARCHAR2) is
  begin
  delete igw_prop_comments
  where rowid = X_Rowid;

Line: 111

  END Delete_row;