DBA Data[Home] [Help]

APPS.IGI_EXP_POSITION_ACTION_PKG SQL Statements

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

Line: 3

 PROCEDURE INSERT_ROW(
        X_ROWID IN OUT NOCOPY VARCHAR2,
        X_WKF_ID        NUMBER,
        X_FLOW_ID       NUMBER,
        X_STEP_NO       NUMBER,
        X_POSITION_ID   NUMBER,
        X_POSITION_STRUCTURE_ID NUMBER,
        X_CREATE_DOC    VARCHAR2,
        X_APPROVE       VARCHAR2,
        X_REJECT        VARCHAR2,
        X_HOLD          VARCHAR2,
        X_PEC           VARCHAR2,
        X_REQUISITION   VARCHAR2,
        X_CREATION_DATE DATE,
        X_CREATED_BY    NUMBER,
        X_LAST_UPDATE_LOGIN NUMBER,
        X_LAST_UPDATE_DATE DATE,
        X_LAST_UPDATED_BY NUMBER ) IS
 BEGIN
NULL;
Line: 23

END  INSERT_ROW;
Line: 40

        X_LAST_UPDATE_LOGIN NUMBER,
        X_LAST_UPDATE_DATE DATE,
        X_LAST_UPDATED_BY NUMBER ) IS
  BEGIN
NULL;
Line: 48

  PROCEDURE UPDATE_ROW(
        X_ROWID IN OUT NOCOPY VARCHAR2,
        X_WKF_ID        NUMBER,
        X_FLOW_ID       NUMBER,
        X_STEP_NO       NUMBER,
        X_POSITION_ID   NUMBER,
        X_POSITION_STRUCTURE_ID NUMBER,
        X_CREATE_DOC    VARCHAR2,
        X_APPROVE       VARCHAR2,
        X_REJECT        VARCHAR2,
        X_HOLD          VARCHAR2,
        X_PEC           VARCHAR2,
        X_REQUISITION   VARCHAR2,
        X_CREATION_DATE DATE,
        X_CREATED_BY    NUMBER,
        X_LAST_UPDATE_LOGIN NUMBER,
        X_LAST_UPDATE_DATE DATE,
        X_LAST_UPDATED_BY NUMBER ) IS
 BEGIN
NULL;
Line: 68

 END UPDATE_ROW;
Line: 70

  PROCEDURE DELETE_ROW(X_ROWID VARCHAR2)
  IS
 BEGIN
   NULL;
Line: 74

 END DELETE_ROW;