APPS.PA_CI_COMMENTS_PKG SQL Statements

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

Line: 6

procedure INSERT_ROW (
    P_CI_COMMENT_ID             out NOCOPY NUMBER, --File.Sql.39 bug 4440895
    P_CI_ID                     in NUMBER,
    P_TYPE_CODE                 in VARCHAR2,
    P_COMMENT_TEXT              in VARCHAR2,
    P_LAST_UPDATED_BY		    in NUMBER,
    P_CREATED_BY			    in NUMBER,
    P_CREATION_DATE			    in DATE,
    P_LAST_UPDATE_DATE		    in DATE,
    P_LAST_UPDATE_LOGIN		    in NUMBER,
    P_CI_ACTION_ID              in NUMBER
) IS
      -- Enter the procedure variables here. As shown below
    CURSOR  c1 IS
     SELECT rowid
     FROM   PA_CI_COMMENTS
     WHERE  ci_comment_id = p_ci_comment_id;

Line: 28

   Insert into PA_CI_COMMENTS (
    CI_COMMENT_ID,
    CI_ID,
    TYPE_CODE,
    COMMENT_TEXT,
    RECORD_VERSION_NUMBER,
    LAST_UPDATED_BY,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    CI_ACTION_ID
    ) VALUES
  (  PA_CI_COMMENTS_S.NEXTVAL ,
    P_CI_ID,
    P_TYPE_CODE,
    P_COMMENT_TEXT,
    1,
    P_LAST_UPDATED_BY,
    P_CREATED_BY,
    P_CREATION_DATE,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATE_LOGIN,
    P_CI_ACTION_ID
  ) returning ci_comment_id INTO p_ci_comment_id;

Line: 59

  END INSERT_ROW;

Line: 61

procedure UPDATE_ROW (
    P_CI_COMMENT_ID             in NUMBER,
    P_CI_ID                     in NUMBER,
    P_TYPE_CODE                 in VARCHAR2,
    P_COMMENT_TEXT              in VARCHAR2,
    P_LAST_UPDATED_BY		    in NUMBER,
    P_CREATED_BY			    in NUMBER,
    P_CREATION_DATE			    in DATE,
    P_LAST_UPDATE_DATE		    in DATE,
    P_LAST_UPDATE_LOGIN		    in NUMBER,
    P_RECORD_VERSION_NUMBER     in NUMBER,
    P_CI_ACTION_ID              in NUMBER
) IS
 BEGIN
   UPDATE PA_CI_COMMENTS
   SET
    CI_ID           = P_CI_ID,
    TYPE_CODE       = P_TYPE_CODE,
    COMMENT_TEXT    = P_COMMENT_TEXT,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    CREATED_BY      = P_CREATED_BY,
    CREATION_DATE   = P_CREATION_DATE,
    LAST_UPDATE_DATE    = P_LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN   = P_LAST_UPDATE_LOGIN,
    RECORD_VERSION_NUMBER = P_RECORD_VERSION_NUMBER+1,
    CI_ACTION_ID    = P_CI_ACTION_ID
   WHERE CI_COMMENT_ID  =  P_CI_COMMENT_ID;

Line: 91

 END UPDATE_ROW;

Line: 95

procedure DELETE_ROW (
		      P_CI_COMMENT_ID in NUMBER )
 IS
 BEGIN
   DELETE FROM PA_CI_COMMENTS
   WHERE CI_COMMENT_ID = P_CI_COMMENT_ID;

Line: 105

 END DELETE_ROW;