eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_TERMS_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_TERM_CODE         IN     VARCHAR2
, X_TERM_TYPE_CODE    IN     VARCHAR2
, X_TERM_NAME         IN     VARCHAR2
, X_DESCRIPTION       IN     VARCHAR2
, X_USER_DEFINED_FLAG IN     VARCHAR2
, X_VIEW_APPL_ID      IN     NUMBER
, X_LOOKUP_TYPE       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
) IS

  cursor C is
    select ROWID from OKE_TERMS_B
    where TERM_CODE = X_TERM_CODE;

Line: 26


  INSERT INTO OKE_TERMS_B
  ( TERM_CODE
  , TERM_TYPE_CODE
  , CREATION_DATE
  , CREATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_LOGIN
  , USER_DEFINED_FLAG
  , VIEW_APPLICATION_ID
  , LOOKUP_TYPE
  ) VALUES
  ( X_TERM_CODE
  , X_TERM_TYPE_CODE
  , X_CREATION_DATE
  , X_CREATED_BY
  , X_LAST_UPDATE_DATE
  , X_LAST_UPDATED_BY
  , X_LAST_UPDATE_LOGIN
  , X_USER_DEFINED_FLAG
  , X_VIEW_APPL_ID
  , X_LOOKUP_TYPE
  );

Line: 50


  INSERT INTO OKE_TERMS_TL
  ( TERM_CODE
  , CREATION_DATE
  , CREATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_LOGIN
  , TERM_NAME
  , DESCRIPTION
  , LANGUAGE
  , SOURCE_LANG
  )
  SELECT
    X_TERM_CODE
  , X_CREATION_DATE
  , X_CREATED_BY
  , X_LAST_UPDATE_DATE
  , X_LAST_UPDATED_BY
  , X_LAST_UPDATE_LOGIN
  , X_TERM_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_TERMS_TL T
     WHERE T.TERM_CODE = X_TERM_CODE
     AND T.LANGUAGE = L.LANGUAGE_CODE
  );

Line: 90


END INSERT_ROW;

Line: 104


    SELECT TERM_TYPE_CODE
    ,      USER_DEFINED_FLAG
    ,      VIEW_APPLICATION_ID
    ,      LOOKUP_TYPE
    FROM   OKE_TERMS_B
    WHERE  TERM_CODE = X_TERM_CODE
    FOR UPDATE OF TERM_CODE NOWAIT;

Line: 114


    SELECT TERM_NAME
    ,      DESCRIPTION
    ,      DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
    FROM   OKE_TERMS_TL
    WHERE  TERM_CODE = X_TERM_CODE
    AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
    FOR UPDATE OF TERM_CODE NOWAIT;

Line: 128


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

Line: 170


PROCEDURE UPDATE_ROW
( X_TERM_CODE         IN VARCHAR2
, X_TERM_TYPE_CODE    IN VARCHAR2
, X_TERM_NAME         IN VARCHAR2
, X_DESCRIPTION       IN VARCHAR2
, X_USER_DEFINED_FLAG IN VARCHAR2
, X_VIEW_APPL_ID      IN NUMBER
, X_LOOKUP_TYPE       IN VARCHAR2
, X_LAST_UPDATE_DATE  IN DATE
, X_LAST_UPDATED_BY   IN NUMBER
, X_LAST_UPDATE_LOGIN IN NUMBER
) IS

BEGIN

  UPDATE OKE_TERMS_B
  SET TERM_TYPE_CODE    = X_TERM_TYPE_CODE
  ,   USER_DEFINED_FLAG = X_USER_DEFINED_FLAG
  ,   VIEW_APPLICATION_ID = X_VIEW_APPL_ID
  ,   LOOKUP_TYPE       = X_LOOKUP_TYPE
  ,   LAST_UPDATE_DATE  = X_LAST_UPDATE_DATE
  ,   LAST_UPDATED_BY   = X_LAST_UPDATED_BY
  ,   LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  WHERE TERM_CODE = X_TERM_CODE;

Line: 199


  UPDATE OKE_TERMS_TL
  SET TERM_NAME         = X_TERM_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 TERM_CODE = X_TERM_CODE
  AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 213


END UPDATE_ROW;

Line: 216


PROCEDURE DELETE_ROW
( X_TERM_CODE IN VARCHAR2
) IS

BEGIN
  DELETE FROM OKE_TERMS_TL
  WHERE TERM_CODE = X_TERM_CODE;

Line: 228


  DELETE FROM OKE_TERMS_B
  WHERE TERM_CODE = X_TERM_CODE;

Line: 235


END DELETE_ROW;

Line: 242


  DELETE FROM OKE_TERMS_TL T
  WHERE NOT EXISTS (
    SELECT NULL
    FROM OKE_TERMS_B B
    WHERE B.TERM_CODE = T.TERM_CODE
  );

Line: 249


  UPDATE OKE_TERMS_TL T
  SET ( TERM_NAME , DESCRIPTION ) = (
    SELECT B.TERM_NAME
    ,      B.DESCRIPTION
    FROM   OKE_TERMS_TL B
    WHERE  B.TERM_CODE = T.TERM_CODE
    AND    B.LANGUAGE = T.SOURCE_LANG)
  WHERE ( T.TERM_CODE , T.LANGUAGE ) IN (
    SELECT SUBT.TERM_CODE
    ,      SUBT.LANGUAGE
    FROM   OKE_TERMS_TL SUBB
    ,      OKE_TERMS_TL SUBT
    WHERE  SUBB.TERM_CODE = SUBT.TERM_CODE
    AND    SUBB.LANGUAGE = SUBT.SOURCE_LANG
    AND    (  SUBB.TERM_NAME <> SUBT.TERM_NAME
           OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
           OR (   SUBB.DESCRIPTION IS NULL
              AND SUBT.DESCRIPTION IS NOT NULL
              )
           OR (   SUBB.DESCRIPTION IS NOT NULL
              AND SUBT.DESCRIPTION IS NULL)
           )
    );

Line: 273


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

Line: 312


, X_LAST_UPDATE_DATE  IN     DATE
, X_CUSTOM_MODE       IN     VARCHAR2
, X_TERM_TYPE_CODE    IN     VARCHAR2
, X_TERM_NAME         IN     VARCHAR2
, X_DESCRIPTION       IN     VARCHAR2
, X_USER_DEFINED_FLAG IN     VARCHAR2
, X_VIEW_APPL_ID      IN     NUMBER
, X_LOOKUP_TYPE       IN     VARCHAR2
) IS

  Row_ID VARCHAR2(30);

Line: 335


  UPDATE OKE_TERMS_B
  SET    TERM_TYPE_CODE      = NVL(X_TERM_TYPE_CODE , TERM_TYPE_CODE)
  ,      USER_DEFINED_FLAG   = X_USER_DEFINED_FLAG
  ,      VIEW_APPLICATION_ID = X_VIEW_APPL_ID
  ,      LOOKUP_TYPE         = X_LOOKUP_TYPE
  ,      LAST_UPDATE_DATE    = SYSDATE
  ,      LAST_UPDATED_BY     = f_luby
  WHERE  TERM_CODE = X_TERM_CODE;

Line: 346


    INSERT_ROW
    ( Row_ID
    , X_TERM_CODE
    , X_TERM_TYPE_CODE
    , X_TERM_NAME
    , X_DESCRIPTION
    , X_USER_DEFINED_FLAG
    , X_VIEW_APPL_ID
    , X_LOOKUP_TYPE
    , X_LAST_UPDATE_DATE
    , f_luby
    , X_LAST_UPDATE_DATE
    , f_luby
    , 0
    );

Line: 364


  UPDATE OKE_TERMS_TL
  SET    TERM_NAME        = X_TERM_NAME
  ,      DESCRIPTION      = X_DESCRIPTION
  ,      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
  ,      LAST_UPDATED_BY  = f_luby
  ,      SOURCE_LANG      = USERENV('LANG')
  WHERE  TERM_CODE = X_TERM_CODE
  AND    USERENV('LANG') IN ( LANGUAGE , SOURCE_LANG );

Line: 375


    INSERT INTO OKE_TERMS_TL
    ( TERM_CODE
    , CREATION_DATE
    , CREATED_BY
    , LAST_UPDATE_DATE
    , LAST_UPDATED_BY
    , LAST_UPDATE_LOGIN
    , TERM_NAME
    , DESCRIPTION
    , LANGUAGE
    , SOURCE_LANG
    )
    SELECT
      X_TERM_CODE
    , X_LAST_UPDATE_DATE
    , f_luby
    , X_LAST_UPDATE_DATE
    , f_luby
    , 0
    , X_TERM_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_TERMS_TL T
       WHERE T.TERM_CODE = X_TERM_CODE
       AND T.LANGUAGE = L.LANGUAGE_CODE
    );

Line: 415


, X_LAST_UPDATE_DATE  IN     DATE
, X_TERM_NAME         IN     VARCHAR2
, X_DESCRIPTION       IN     VARCHAR2
) IS

  f_luby   NUMBER;

Line: 428


  UPDATE OKE_TERMS_TL
  SET    TERM_NAME        = X_TERM_NAME
  ,      DESCRIPTION      = X_DESCRIPTION
  ,      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
  ,      LAST_UPDATED_BY  = f_luby
  ,      SOURCE_LANG      = USERENV('LANG')
  WHERE  TERM_CODE = X_TERM_CODE
  AND    USERENV('LANG') IN ( LANGUAGE , SOURCE_LANG );