APPS.OKE_APPROVAL_STEPS_PKG SQL Statements

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

Line: 4

PROCEDURE INSERT_ROW
( X_ROWID                  IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
, X_APPROVAL_PATH_ID       IN     NUMBER
, X_APPROVAL_SEQUENCE      IN     NUMBER
, X_APPROVER_ROLE_ID       IN     NUMBER
, X_REQUIRED_FLAG          IN     VARCHAR2
, X_CREATION_DATE          IN     DATE
, X_CREATED_BY             IN     NUMBER
, X_LAST_UPDATE_DATE       IN     DATE
, X_LAST_UPDATED_BY        IN     NUMBER
, X_LAST_UPDATE_LOGIN      IN     NUMBER
, X_RECORD_VERSION_NUMBER  IN OUT NOCOPY /* file.sql.39 change */ NUMBER
) IS

CURSOR c IS
  SELECT ROWID
  FROM OKE_APPROVAL_STEPS
  WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
  AND   APPROVAL_SEQUENCE = X_APPROVAL_SEQUENCE;

Line: 28

  INSERT INTO OKE_APPROVAL_STEPS
  ( APPROVAL_PATH_ID
  , APPROVAL_SEQUENCE
  , APPROVER_ROLE_ID
  , REQUIRED_FLAG
  , RECORD_VERSION_NUMBER
  , CREATION_DATE
  , CREATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_LOGIN
  ) VALUES
  ( X_APPROVAL_PATH_ID
  , X_APPROVAL_SEQUENCE
  , X_APPROVER_ROLE_ID
  , X_REQUIRED_FLAG
  , X_RECORD_VERSION_NUMBER
  , X_CREATION_DATE
  , X_CREATED_BY
  , X_LAST_UPDATE_DATE
  , X_LAST_UPDATED_BY
  , X_LAST_UPDATE_LOGIN
  );

Line: 60

END INSERT_ROW;

Line: 69

  SELECT RECORD_VERSION_NUMBER
  FROM OKE_APPROVAL_STEPS
  WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
  AND APPROVAL_SEQUENCE = X_APPROVAL_SEQUENCE
  FOR UPDATE OF APPROVAL_PATH_ID NOWAIT;

Line: 81

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

Line: 96

PROCEDURE UPDATE_ROW
( X_APPROVAL_PATH_ID       IN     NUMBER
, X_APPROVAL_SEQUENCE      IN     NUMBER
, X_APPROVER_ROLE_ID       IN     NUMBER
, X_REQUIRED_FLAG          IN     VARCHAR2
, X_LAST_UPDATE_DATE       IN     DATE
, X_LAST_UPDATED_BY        IN     NUMBER
, X_LAST_UPDATE_LOGIN      IN     NUMBER
, X_RECORD_VERSION_NUMBER  IN OUT NOCOPY /* file.sql.39 change */ NUMBER
) IS

CURSOR c IS
  SELECT RECORD_VERSION_NUMBER
  FROM OKE_APPROVAL_STEPS
  WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
  AND   APPROVAL_SEQUENCE = X_APPROVAL_SEQUENCE;

Line: 114

  UPDATE OKE_APPROVAL_STEPS
  SET APPROVER_ROLE_ID      = X_APPROVER_ROLE_ID
  ,   REQUIRED_FLAG         = X_REQUIRED_FLAG
  ,   LAST_UPDATE_DATE      = X_LAST_UPDATE_DATE
  ,   LAST_UPDATED_BY       = X_LAST_UPDATED_BY
  ,   LAST_UPDATE_LOGIN     = X_LAST_UPDATE_LOGIN
  ,   RECORD_VERSION_NUMBER = RECORD_VERSION_NUMBER + 1
  WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
  AND APPROVAL_SEQUENCE = X_APPROVAL_SEQUENCE;

Line: 128

END UPDATE_ROW;

Line: 130

PROCEDURE DELETE_ROW
( X_APPROVAL_PATH_ID       IN     NUMBER
, X_APPROVAL_SEQUENCE      IN     NUMBER
) IS
BEGIN

  DELETE FROM OKE_APPROVAL_STEPS
  WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
  AND APPROVAL_SEQUENCE = X_APPROVAL_SEQUENCE;

Line: 144

END DELETE_ROW;

Line: 151

, X_LAST_UPDATE_DATE       IN     DATE
, X_LAST_UPDATED_BY        IN     NUMBER
) IS
BEGIN

  INSERT INTO OKE_APPROVAL_STEPS
  ( APPROVAL_PATH_ID
  , APPROVAL_SEQUENCE
  , APPROVER_ROLE_ID
  , REQUIRED_FLAG
  , RECORD_VERSION_NUMBER
  , CREATION_DATE
  , CREATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_LOGIN
  )
  SELECT X_APPROVAL_PATH_ID
  ,      X_APPROVAL_SEQUENCE
  ,      X_APPROVER_ROLE_ID
  ,      X_REQUIRED_FLAG
  ,      1
  ,      X_LAST_UPDATE_DATE
  ,      X_LAST_UPDATED_BY
  ,      X_LAST_UPDATE_DATE
  ,      X_LAST_UPDATED_BY
  ,      NULL
  FROM DUAL
  WHERE NOT EXISTS (
    SELECT NULL
    FROM   OKE_APPROVAL_STEPS
    WHERE  APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
    AND (  APPROVAL_SEQUENCE = X_APPROVAL_SEQUENCE
        OR APPROVER_ROLE_ID = X_APPROVER_ROLE_ID )
  );