APPS.OKE_APPROVAL_PATHS_PKG SQL Statements

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

Line: 7

PROCEDURE INSERT_ROW
( X_ROWID                   IN OUT NOCOPY VARCHAR2
, X_APPROVAL_PATH_ID        IN OUT NOCOPY NUMBER
, X_SIGNATURE_REQUIRED_FLAG IN     VARCHAR2
, X_SIGNATORY_ROLE_ID       IN     NUMBER
, X_NAME                    IN     VARCHAR2
, X_DESCRIPTION             IN     VARCHAR2
, X_START_DATE_ACTIVE       IN     DATE
, X_END_DATE_ACTIVE         IN     DATE
, 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 NUMBER
) IS

CURSOR c IS
  SELECT ROWID
  FROM OKE_APPROVAL_PATHS
  WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID;

Line: 32

    SELECT OKE_APPROVAL_PATHS_S.NEXTVAL
    INTO   X_APPROVAL_PATH_ID
    FROM   DUAL;

Line: 39

  INSERT INTO OKE_APPROVAL_PATHS
  ( APPROVAL_PATH_ID
  , SIGNATURE_REQUIRED_FLAG
  , SIGNATORY_ROLE_ID
  , RECORD_VERSION_NUMBER
  , START_DATE_ACTIVE
  , END_DATE_ACTIVE
  , CREATION_DATE
  , CREATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_LOGIN
  ) VALUES
  ( X_APPROVAL_PATH_ID
  , X_SIGNATURE_REQUIRED_FLAG
  , X_SIGNATORY_ROLE_ID
  , X_RECORD_VERSION_NUMBER
  , X_START_DATE_ACTIVE
  , X_END_DATE_ACTIVE
  , X_CREATION_DATE
  , X_CREATED_BY
  , X_LAST_UPDATE_DATE
  , X_LAST_UPDATED_BY
  , X_LAST_UPDATE_LOGIN
  );

Line: 65

  INSERT INTO OKE_APPROVAL_PATHS_TL
  ( APPROVAL_PATH_ID
  , CREATION_DATE
  , CREATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_LOGIN
  , NAME
  , DESCRIPTION
  , LANGUAGE
  , SOURCE_LANG
  )
  SELECT X_APPROVAL_PATH_ID
  ,      X_CREATION_DATE
  ,      X_CREATED_BY
  ,      X_LAST_UPDATE_DATE
  ,      X_LAST_UPDATED_BY
  ,      X_LAST_UPDATE_LOGIN
  ,      X_NAME
  ,      X_DESCRIPTION
  ,      L.LANGUAGE_CODE
  ,      USERENV('LANG')
  FROM FND_LANGUAGES L
  WHERE L.INSTALLED_FLAG IN ('I', 'B')
  AND NOT EXISTS
    (SELECT NULL
    FROM OKE_APPROVAL_PATHS_TL T
    WHERE T.APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
    AND T.LANGUAGE = L.LANGUAGE_CODE);

Line: 103

END INSERT_ROW;

Line: 112

  SELECT RECORD_VERSION_NUMBER
  FROM OKE_APPROVAL_PATHS
  WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
  FOR UPDATE OF APPROVAL_PATH_ID NOWAIT;

Line: 123

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

Line: 139

PROCEDURE UPDATE_ROW
( X_APPROVAL_PATH_ID        IN     NUMBER
, X_SIGNATURE_REQUIRED_FLAG IN     VARCHAR2
, X_SIGNATORY_ROLE_ID       IN     NUMBER
, X_NAME                    IN     VARCHAR2
, X_DESCRIPTION             IN     VARCHAR2
, X_START_DATE_ACTIVE       IN     DATE
, X_END_DATE_ACTIVE         IN     DATE
, X_LAST_UPDATE_DATE        IN     DATE
, X_LAST_UPDATED_BY         IN     NUMBER
, X_LAST_UPDATE_LOGIN       IN     NUMBER
, X_RECORD_VERSION_NUMBER   OUT    NOCOPY NUMBER
) IS

CURSOR c IS
  SELECT RECORD_VERSION_NUMBER
  FROM OKE_APPROVAL_PATHS
  WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID;

Line: 160

  UPDATE OKE_APPROVAL_PATHS
  SET SIGNATURE_REQUIRED_FLAG = X_SIGNATURE_REQUIRED_FLAG
  ,   SIGNATORY_ROLE_ID       = X_SIGNATORY_ROLE_ID
  ,   START_DATE_ACTIVE       = X_START_DATE_ACTIVE
  ,   END_DATE_ACTIVE         = X_END_DATE_ACTIVE
  ,   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;

Line: 183

  UPDATE OKE_APPROVAL_PATHS_TL
  SET NAME              = X_NAME
  ,   DESCRIPTION       = X_DESCRIPTION
  ,   LAST_UPDATE_DATE  = X_LAST_UPDATE_DATE
  ,   LAST_UPDATED_BY   = X_LAST_UPDATED_BY
  ,   LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  ,   SOURCE_LANG       = USERENV('LANG')
  WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
  AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 197

END UPDATE_ROW;

Line: 200

PROCEDURE DELETE_ROW
( X_APPROVAL_PATH_ID        IN     NUMBER
) IS
BEGIN

  DELETE FROM OKE_APPROVAL_PATHS_TL
  WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID;

Line: 212

  DELETE FROM OKE_APPROVAL_PATHS
  WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID;

Line: 219

END DELETE_ROW;

Line: 230

, X_LAST_UPDATE_DATE        IN     DATE
, X_LAST_UPDATED_BY         IN     NUMBER
, X_CUSTOM_MODE             IN     VARCHAR2
) IS

l_approval_path_id       NUMBER := X_APPROVAL_PATH_ID;

Line: 240

db_ludate  DATE;    -- entity update date in db

Line: 246

    SELECT LAST_UPDATE_DATE , LAST_UPDATED_BY
    INTO   db_ludate , db_luby
    FROM   OKE_APPROVAL_PATHS
    WHERE  APPROVAL_PATH_ID = X_APPROVAL_PATH_ID;

Line: 259

         ( X_LAST_UPDATED_BY
         , X_LAST_UPDATE_DATE
         , db_luby
         , db_ludate
         , X_CUSTOM_MODE ) ) THEN

      UPDATE_ROW
      ( X_APPROVAL_PATH_ID        => l_approval_path_id
      , X_SIGNATURE_REQUIRED_FLAG => X_SIGNATURE_REQUIRED_FLAG
      , X_SIGNATORY_ROLE_ID       => X_SIGNATORY_ROLE_ID
      , X_NAME                    => X_NAME
      , X_DESCRIPTION             => X_DESCRIPTION
      , X_START_DATE_ACTIVE       => X_START_DATE_ACTIVE
      , X_END_DATE_ACTIVE         => X_END_DATE_ACTIVE
      , X_LAST_UPDATE_DATE        => X_LAST_UPDATE_DATE
      , X_LAST_UPDATED_BY         => X_LAST_UPDATED_BY
      , X_LAST_UPDATE_LOGIN       => NULL
      , X_RECORD_VERSION_NUMBER   => l_record_version_number
      );

Line: 284

      INSERT_ROW
      ( X_ROWID                   => l_rowid
      , X_APPROVAL_PATH_ID        => l_approval_path_id
      , X_SIGNATURE_REQUIRED_FLAG => X_SIGNATURE_REQUIRED_FLAG
      , X_SIGNATORY_ROLE_ID       => X_SIGNATORY_ROLE_ID
      , X_NAME                    => X_NAME
      , X_DESCRIPTION             => X_DESCRIPTION
      , X_START_DATE_ACTIVE       => X_START_DATE_ACTIVE
      , X_END_DATE_ACTIVE         => X_END_DATE_ACTIVE
      , X_CREATION_DATE           => X_LAST_UPDATE_DATE
      , X_CREATED_BY              => X_LAST_UPDATED_BY
      , X_LAST_UPDATE_DATE        => X_LAST_UPDATE_DATE
      , X_LAST_UPDATED_BY         => X_LAST_UPDATED_BY
      , X_LAST_UPDATE_LOGIN       => NULL
      , X_RECORD_VERSION_NUMBER   => l_record_version_number
      );

Line: 306

    DELETE FROM OKE_APPROVAL_STEPS
    WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID;

Line: 317

, X_LAST_UPDATE_DATE        IN     DATE
, X_LAST_UPDATED_BY         IN     NUMBER
, X_CUSTOM_MODE             IN     VARCHAR2
) IS

db_luby    NUMBER;  -- entity owner in db

Line: 323

db_ludate  DATE;    -- entity update date in db

Line: 327

  SELECT LAST_UPDATE_DATE , LAST_UPDATED_BY
  INTO   db_ludate , db_luby
  FROM   OKE_APPROVAL_PATHS_TL
  WHERE  APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
  AND    USERENV('LANG') = LANGUAGE;

Line: 341

       ( X_LAST_UPDATED_BY
       , X_LAST_UPDATE_DATE
       , db_luby
       , db_ludate
       , X_CUSTOM_MODE ) ) THEN

    UPDATE OKE_APPROVAL_PATHS_TL
    SET    NAME             = X_NAME
    ,      DESCRIPTION      = X_DESCRIPTION
    ,      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
    ,      LAST_UPDATED_BY  = X_LAST_UPDATED_BY
    ,      SOURCE_LANG      = USERENV('LANG')
    WHERE  APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
    AND    USERENV('LANG') IN ( LANGUAGE , SOURCE_LANG );

Line: 365

  DELETE FROM OKE_APPROVAL_PATHS_TL T
  WHERE NOT EXISTS (
    SELECT NULL
    FROM OKE_APPROVAL_PATHS B
    WHERE B.APPROVAL_PATH_ID = T.APPROVAL_PATH_ID
  );

Line: 372

  UPDATE OKE_APPROVAL_PATHS_TL T SET
  ( NAME , DESCRIPTION ) = (
    SELECT B.NAME
    ,      B.DESCRIPTION
    FROM  OKE_APPROVAL_PATHS_TL B
    WHERE B.APPROVAL_PATH_ID = T.APPROVAL_PATH_ID
    AND B.LANGUAGE = T.SOURCE_LANG)
  WHERE ( T.APPROVAL_PATH_ID , T.LANGUAGE ) IN (
    SELECT SUBT.APPROVAL_PATH_ID
    ,      SUBT.LANGUAGE
    FROM OKE_APPROVAL_PATHS_TL SUBB
    ,    OKE_APPROVAL_PATHS_TL SUBT
    WHERE SUBB.APPROVAL_PATH_ID = SUBT.APPROVAL_PATH_ID
    AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
    AND (SUBB.NAME <> SUBT.NAME
      OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION )
  );

Line: 390

  INSERT INTO OKE_APPROVAL_PATHS_TL
  ( APPROVAL_PATH_ID
  , CREATION_DATE
  , CREATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_LOGIN
  , NAME
  , DESCRIPTION
  , LANGUAGE
  , SOURCE_LANG
  )
  SELECT B.APPROVAL_PATH_ID
  ,      B.CREATION_DATE
  ,      B.CREATED_BY
  ,      B.LAST_UPDATE_DATE
  ,      B.LAST_UPDATED_BY
  ,      B.LAST_UPDATE_LOGIN
  ,      B.NAME
  ,      B.DESCRIPTION
  ,      L.LANGUAGE_CODE
  ,      B.SOURCE_LANG
  FROM OKE_APPROVAL_PATHS_TL B, FND_LANGUAGES L
  WHERE L.INSTALLED_FLAG IN ('I', 'B')
  AND B.LANGUAGE = USERENV('LANG')
  AND NOT EXISTS (
    SELECT NULL
    FROM OKE_APPROVAL_PATHS_TL T
    WHERE T.APPROVAL_PATH_ID = B.APPROVAL_PATH_ID
    AND T.LANGUAGE = L.LANGUAGE_CODE
  );

Line: 441

  SELECT approval_sequence || ',' || approver_role_id || ';' approval_step