APPS.PA_CI_ACTIONS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
    P_CI_ACTION_ID		out NOCOPY NUMBER,
    P_CI_ID                     in NUMBER,
    P_CI_ACTION_NUMBER		in NUMBER,
    P_STATUS_CODE   		in VARCHAR2,
    P_TYPE_CODE			in VARCHAR2,
    P_ASSIGNED_TO		in NUMBER,
    P_DATE_REQUIRED 		in DATE,
    P_SIGN_OFF_REQUIRED_FLAG    in VARCHAR2,
    P_DATE_CLOSED		in DATE,
    P_SIGN_OFF_FLAG		in VARCHAR2,
    P_SOURCE_CI_ACTION_ID	in NUMBER,
    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
) IS
      -- Enter the procedure variables here. As shown below
    CURSOR  c1 IS
     SELECT rowid
     FROM   PA_CI_ACTIONS
     WHERE  ci_action_id = p_ci_action_id;

Line: 32

   Insert into PA_CI_ACTIONS (
    CI_ACTION_ID,
    CI_ID,
    CI_ACTION_NUMBER,
    STATUS_CODE,
    TYPE_CODE,
    ASSIGNED_TO,
    DATE_REQUIRED,
    SIGN_OFF_REQUIRED_FLAG,
    DATE_CLOSED,
    SIGN_OFF_FLAG,
    SOURCE_CI_ACTION_ID,
    LAST_UPDATED_BY,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    RECORD_VERSION_NUMBER
    ) VALUES
  (  PA_CI_ACTIONS_S.NEXTVAL,
    P_CI_ID,
    P_CI_ACTION_NUMBER,
    P_STATUS_CODE,
    P_TYPE_CODE,
    P_ASSIGNED_TO,
    P_DATE_REQUIRED,
    P_SIGN_OFF_REQUIRED_FLAG,
    P_DATE_CLOSED,
    P_SIGN_OFF_FLAG,
    P_SOURCE_CI_ACTION_ID,
    P_LAST_UPDATED_BY,
    P_CREATED_BY,
    P_CREATION_DATE,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATE_LOGIN,
    P_RECORD_VERSION_NUMBER
  ) returning ci_action_id INTO p_ci_action_id;

Line: 74

  END INSERT_ROW;

Line: 76

procedure UPDATE_ROW (
    P_CI_ACTION_ID		in NUMBER,
    P_CI_ID                     in NUMBER,
    P_STATUS_CODE   		in VARCHAR2,
    P_TYPE_CODE			in VARCHAR2,
    P_ASSIGNED_TO		in NUMBER,
    P_DATE_REQUIRED 		in DATE,
    P_SIGN_OFF_REQUIRED_FLAG    in VARCHAR2,
    P_DATE_CLOSED		in DATE,
    P_SIGN_OFF_FLAG		in VARCHAR2,
    P_SOURCE_CI_ACTION_ID	in NUMBER,
    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
) IS
 BEGIN
   UPDATE PA_CI_ACTIONS
   SET
    CI_ID           =   P_CI_ID,
    STATUS_CODE     =   P_STATUS_CODE,
    TYPE_CODE       =   P_TYPE_CODE,
    ASSIGNED_TO     =   P_ASSIGNED_TO,
    DATE_REQUIRED   =   P_DATE_REQUIRED,
    SIGN_OFF_REQUIRED_FLAG  =   P_SIGN_OFF_REQUIRED_FLAG,
    DATE_CLOSED     =   P_DATE_CLOSED,
    SIGN_OFF_FLAG   =   P_SIGN_OFF_FLAG,
    SOURCE_CI_ACTION_ID     =   P_SOURCE_CI_ACTION_ID,
    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
   WHERE CI_ACTION_ID  	    =  P_CI_ACTION_ID;

Line: 116

 END UPDATE_ROW;

Line: 120

procedure DELETE_ROW (
		      P_CI_ACTION_ID in NUMBER
              )
 IS
 BEGIN
   DELETE FROM PA_CI_ACTIONS
   WHERE CI_ACTION_ID = P_CI_ACTION_ID;

Line: 131

 END DELETE_ROW;