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.GMD_QC_TEST_VALUES_PVT SQL Statements

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

Line: 3


procedure INSERT_ROW (
  X_ROWID in out nocopy ROWID,
  X_TEST_VALUE_ID in out nocopy NUMBER,
  X_TEST_ID in NUMBER,
  X_MIN_NUM in NUMBER ,
  X_MAX_NUM in NUMBER ,
  X_VALUE_CHAR in VARCHAR2 ,
  X_TEXT_RANGE_SEQ in NUMBER ,
  X_EXPRESSION_REF_TEST_ID in NUMBER ,
  X_TEXT_CODE in NUMBER ,
  X_ATTRIBUTE_CATEGORY in VARCHAR2 ,
  X_ATTRIBUTE1 in VARCHAR2 ,
  X_ATTRIBUTE2 in VARCHAR2 ,
  X_ATTRIBUTE3 in VARCHAR2 ,
  X_ATTRIBUTE4 in VARCHAR2 ,
  X_ATTRIBUTE5 in VARCHAR2 ,
  X_ATTRIBUTE6 in VARCHAR2 ,
  X_ATTRIBUTE7 in VARCHAR2 ,
  X_ATTRIBUTE8 in VARCHAR2 ,
  X_ATTRIBUTE9 in VARCHAR2 ,
  X_ATTRIBUTE10 in VARCHAR2 ,
  X_ATTRIBUTE11 in VARCHAR2 ,
  X_ATTRIBUTE12 in VARCHAR2 ,
  X_ATTRIBUTE13 in VARCHAR2 ,
  X_ATTRIBUTE14 in VARCHAR2 ,
  X_ATTRIBUTE15 in VARCHAR2 ,
  X_ATTRIBUTE16 in VARCHAR2 ,
  X_ATTRIBUTE17 in VARCHAR2 ,
  X_ATTRIBUTE18 in VARCHAR2 ,
  X_ATTRIBUTE19 in VARCHAR2 ,
  X_ATTRIBUTE20 in VARCHAR2 ,
  X_ATTRIBUTE21 in VARCHAR2 ,
  X_ATTRIBUTE22 in VARCHAR2 ,
  X_ATTRIBUTE23 in VARCHAR2 ,
  X_ATTRIBUTE24 in VARCHAR2 ,
  X_ATTRIBUTE25 in VARCHAR2 ,
  X_ATTRIBUTE26 in VARCHAR2 ,
  X_ATTRIBUTE27 in VARCHAR2 ,
  X_ATTRIBUTE28 in VARCHAR2 ,
  X_ATTRIBUTE29 in VARCHAR2 ,
  X_ATTRIBUTE30 in VARCHAR2 ,
  X_DISPLAY_LABEL_NUMERIC_RANGE in VARCHAR2 ,
  X_TEST_VALUE_DESC 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 GMD_QC_TEST_VALUES_B
    where TEST_VALUE_ID = X_TEST_VALUE_ID
    ;

Line: 58


     SELECT GMD_QC_TEST_VALUE_ID_S.NEXTVAL INTO X_TEST_VALUE_ID FROM DUAL;

Line: 61


  insert into GMD_QC_TEST_VALUES_B (
    TEST_VALUE_ID,
    TEST_ID,
    MIN_NUM,
    MAX_NUM,
    VALUE_CHAR,
    TEXT_RANGE_SEQ,
    EXPRESSION_REF_TEST_ID,
    TEXT_CODE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE16,
    ATTRIBUTE17,
    ATTRIBUTE18,
    ATTRIBUTE19,
    ATTRIBUTE20,
    ATTRIBUTE21,
    ATTRIBUTE22,
    ATTRIBUTE23,
    ATTRIBUTE24,
    ATTRIBUTE25,
    ATTRIBUTE26,
    ATTRIBUTE27,
    ATTRIBUTE28,
    ATTRIBUTE29,
    ATTRIBUTE30,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_TEST_VALUE_ID,
    X_TEST_ID,
    X_MIN_NUM,
    X_MAX_NUM,
    X_VALUE_CHAR,
    X_TEXT_RANGE_SEQ,
    X_EXPRESSION_REF_TEST_ID,
    X_TEXT_CODE,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_ATTRIBUTE16,
    X_ATTRIBUTE17,
    X_ATTRIBUTE18,
    X_ATTRIBUTE19,
    X_ATTRIBUTE20,
    X_ATTRIBUTE21,
    X_ATTRIBUTE22,
    X_ATTRIBUTE23,
    X_ATTRIBUTE24,
    X_ATTRIBUTE25,
    X_ATTRIBUTE26,
    X_ATTRIBUTE27,
    X_ATTRIBUTE28,
    X_ATTRIBUTE29,
    X_ATTRIBUTE30,
    NVL(X_CREATION_DATE,SYSDATE),
    NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
    NVL(X_LAST_UPDATE_DATE,SYSDATE),
    NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
    NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
  );

Line: 153


  insert into GMD_QC_TEST_VALUES_TL (
    TEST_VALUE_ID,
    DISPLAY_LABEL_NUMERIC_RANGE,
    TEST_VALUE_DESC,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_TEST_VALUE_ID,
    X_DISPLAY_LABEL_NUMERIC_RANGE,
    X_TEST_VALUE_DESC,
    NVL(X_CREATION_DATE,SYSDATE),
    NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
    NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
    NVL(X_LAST_UPDATE_DATE,SYSDATE),
    NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from GMD_QC_TEST_VALUES_TL T
    where T.TEST_VALUE_ID = X_TEST_VALUE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 191


end INSERT_ROW;

Line: 193


FUNCTION INSERT_ROW(p_qc_test_values_rec IN OUT NOCOPY GMD_QC_TEST_VALUES%ROWTYPE) RETURN BOOLEAN IS
l_rowid		ROWID;

Line: 196


  GMD_QC_TEST_VALUES_PVT.INSERT_ROW(
    X_ROWID => l_rowid,
    X_TEST_VALUE_ID => p_qc_test_values_rec.TEST_VALUE_ID,
    X_TEST_ID => p_qc_test_values_rec.TEST_ID,
    X_MIN_NUM => p_qc_test_values_rec.MIN_NUM,
    X_MAX_NUM => p_qc_test_values_rec.MAX_NUM,
    X_VALUE_CHAR => p_qc_test_values_rec.VALUE_CHAR,
    X_TEXT_RANGE_SEQ => p_qc_test_values_rec.TEXT_RANGE_SEQ,
    X_EXPRESSION_REF_TEST_ID => p_qc_test_values_rec.EXPRESSION_REF_TEST_ID,
    X_TEXT_CODE => p_qc_test_values_rec.TEXT_CODE,
    X_ATTRIBUTE_CATEGORY => p_qc_test_values_rec.ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1 => p_qc_test_values_rec.ATTRIBUTE1,
    X_ATTRIBUTE2 => p_qc_test_values_rec.ATTRIBUTE2,
    X_ATTRIBUTE3 => p_qc_test_values_rec.ATTRIBUTE3,
    X_ATTRIBUTE4 => p_qc_test_values_rec.ATTRIBUTE4,
    X_ATTRIBUTE5 => p_qc_test_values_rec.ATTRIBUTE5,
    X_ATTRIBUTE6 => p_qc_test_values_rec.ATTRIBUTE6,
    X_ATTRIBUTE7 => p_qc_test_values_rec.ATTRIBUTE7,
    X_ATTRIBUTE8 => p_qc_test_values_rec.ATTRIBUTE8,
    X_ATTRIBUTE9 => p_qc_test_values_rec.ATTRIBUTE9,
    X_ATTRIBUTE10 => p_qc_test_values_rec.ATTRIBUTE10,
    X_ATTRIBUTE11 => p_qc_test_values_rec.ATTRIBUTE11,
    X_ATTRIBUTE12 => p_qc_test_values_rec.ATTRIBUTE12,
    X_ATTRIBUTE13 => p_qc_test_values_rec.ATTRIBUTE13,
    X_ATTRIBUTE14 => p_qc_test_values_rec.ATTRIBUTE14,
    X_ATTRIBUTE15 => p_qc_test_values_rec.ATTRIBUTE15,
    X_ATTRIBUTE16 => p_qc_test_values_rec.ATTRIBUTE16,
    X_ATTRIBUTE17 => p_qc_test_values_rec.ATTRIBUTE17,
    X_ATTRIBUTE18 => p_qc_test_values_rec.ATTRIBUTE18,
    X_ATTRIBUTE19 => p_qc_test_values_rec.ATTRIBUTE19,
    X_ATTRIBUTE20 => p_qc_test_values_rec.ATTRIBUTE20,
    X_ATTRIBUTE21 => p_qc_test_values_rec.ATTRIBUTE21,
    X_ATTRIBUTE22 => p_qc_test_values_rec.ATTRIBUTE22,
    X_ATTRIBUTE23 => p_qc_test_values_rec.ATTRIBUTE23,
    X_ATTRIBUTE24 => p_qc_test_values_rec.ATTRIBUTE24,
    X_ATTRIBUTE25 => p_qc_test_values_rec.ATTRIBUTE25,
    X_ATTRIBUTE26 => p_qc_test_values_rec.ATTRIBUTE26,
    X_ATTRIBUTE27 => p_qc_test_values_rec.ATTRIBUTE27,
    X_ATTRIBUTE28 => p_qc_test_values_rec.ATTRIBUTE28,
    X_ATTRIBUTE29 => p_qc_test_values_rec.ATTRIBUTE29,
    X_ATTRIBUTE30 => p_qc_test_values_rec.ATTRIBUTE30,
    X_DISPLAY_LABEL_NUMERIC_RANGE => p_qc_test_values_rec.DISPLAY_LABEL_NUMERIC_RANGE,
    X_TEST_VALUE_DESC => p_qc_test_values_rec.TEST_VALUE_DESC,
    X_CREATION_DATE => p_qc_test_values_rec.CREATION_DATE,
    X_CREATED_BY => p_qc_test_values_rec.CREATED_BY,
    X_LAST_UPDATE_DATE => p_qc_test_values_rec.LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => p_qc_test_values_rec.LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => p_qc_test_values_rec.LAST_UPDATE_LOGIN);

Line: 248


    gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QC_TEST_VALUES_PVT.INSERT_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

Line: 250


end INSERT_ROW;

Line: 296


  cursor c is select
      TEST_ID,
      MIN_NUM,
      MAX_NUM,
      VALUE_CHAR,
      TEXT_RANGE_SEQ,
      EXPRESSION_REF_TEST_ID,
      TEXT_CODE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      ATTRIBUTE21,
      ATTRIBUTE22,
      ATTRIBUTE23,
      ATTRIBUTE24,
      ATTRIBUTE25,
      ATTRIBUTE26,
      ATTRIBUTE27,
      ATTRIBUTE28,
      ATTRIBUTE29,
      ATTRIBUTE30
    from GMD_QC_TEST_VALUES_B
    where TEST_VALUE_ID = X_TEST_VALUE_ID
    for update of TEST_VALUE_ID nowait;

Line: 340


  cursor c1 is select
      DISPLAY_LABEL_NUMERIC_RANGE,
      TEST_VALUE_DESC,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from GMD_QC_TEST_VALUES_TL
    where TEST_VALUE_ID = X_TEST_VALUE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of TEST_VALUE_ID nowait;

Line: 353


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 457


procedure UPDATE_ROW (
  X_TEST_VALUE_ID in NUMBER,
  X_TEST_ID in NUMBER,
  X_MIN_NUM in NUMBER,
  X_MAX_NUM in NUMBER,
  X_VALUE_CHAR in VARCHAR2,
  X_TEXT_RANGE_SEQ in NUMBER,
  X_EXPRESSION_REF_TEST_ID in NUMBER,
  X_TEXT_CODE in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE16 in VARCHAR2,
  X_ATTRIBUTE17 in VARCHAR2,
  X_ATTRIBUTE18 in VARCHAR2,
  X_ATTRIBUTE19 in VARCHAR2,
  X_ATTRIBUTE20 in VARCHAR2,
  X_ATTRIBUTE21 in VARCHAR2,
  X_ATTRIBUTE22 in VARCHAR2,
  X_ATTRIBUTE23 in VARCHAR2,
  X_ATTRIBUTE24 in VARCHAR2,
  X_ATTRIBUTE25 in VARCHAR2,
  X_ATTRIBUTE26 in VARCHAR2,
  X_ATTRIBUTE27 in VARCHAR2,
  X_ATTRIBUTE28 in VARCHAR2,
  X_ATTRIBUTE29 in VARCHAR2,
  X_ATTRIBUTE30 in VARCHAR2,
  X_DISPLAY_LABEL_NUMERIC_RANGE in VARCHAR2,
  X_TEST_VALUE_DESC in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update GMD_QC_TEST_VALUES_B set
    TEST_ID = X_TEST_ID,
    MIN_NUM = X_MIN_NUM,
    MAX_NUM = X_MAX_NUM,
    VALUE_CHAR = X_VALUE_CHAR,
    TEXT_RANGE_SEQ = X_TEXT_RANGE_SEQ,
    EXPRESSION_REF_TEST_ID = X_EXPRESSION_REF_TEST_ID,
    TEXT_CODE = X_TEXT_CODE,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    ATTRIBUTE16 = X_ATTRIBUTE16,
    ATTRIBUTE17 = X_ATTRIBUTE17,
    ATTRIBUTE18 = X_ATTRIBUTE18,
    ATTRIBUTE19 = X_ATTRIBUTE19,
    ATTRIBUTE20 = X_ATTRIBUTE20,
    ATTRIBUTE21 = X_ATTRIBUTE21,
    ATTRIBUTE22 = X_ATTRIBUTE22,
    ATTRIBUTE23 = X_ATTRIBUTE23,
    ATTRIBUTE24 = X_ATTRIBUTE24,
    ATTRIBUTE25 = X_ATTRIBUTE25,
    ATTRIBUTE26 = X_ATTRIBUTE26,
    ATTRIBUTE27 = X_ATTRIBUTE27,
    ATTRIBUTE28 = X_ATTRIBUTE28,
    ATTRIBUTE29 = X_ATTRIBUTE29,
    ATTRIBUTE30 = X_ATTRIBUTE30,
    LAST_UPDATE_DATE =  NVL(X_LAST_UPDATE_DATE,SYSDATE),
    LAST_UPDATED_BY =   NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
    LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
  where TEST_VALUE_ID = X_TEST_VALUE_ID;

Line: 552


  update GMD_QC_TEST_VALUES_TL set
    DISPLAY_LABEL_NUMERIC_RANGE = X_DISPLAY_LABEL_NUMERIC_RANGE,
    TEST_VALUE_DESC = X_TEST_VALUE_DESC,
    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 TEST_VALUE_ID = X_TEST_VALUE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 565


end UPDATE_ROW;

Line: 567


FUNCTION DELETE_ROW (p_test_value_id in NUMBER) RETURN BOOLEAN IS
begin
  IF p_test_value_id IS NOT NULL THEN
     DELETE from GMD_QC_TEST_VALUES_TL
     where TEST_VALUE_ID = p_test_value_id ;

Line: 577


     delete from GMD_QC_TEST_VALUES_B
     where TEST_VALUE_ID = p_test_value_id;

Line: 597


     gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QC_TEST_VALUES_PVT.DELETE_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

Line: 599


end DELETE_ROW;

Line: 604


  delete from GMD_QC_TEST_VALUES_TL T
  where not exists
    (select NULL
    from GMD_QC_TEST_VALUES_B B
    where B.TEST_VALUE_ID = T.TEST_VALUE_ID
    );

Line: 611


  update GMD_QC_TEST_VALUES_TL T set (
      DISPLAY_LABEL_NUMERIC_RANGE,
      TEST_VALUE_DESC
    ) = (select
      B.DISPLAY_LABEL_NUMERIC_RANGE,
      B.TEST_VALUE_DESC
    from GMD_QC_TEST_VALUES_TL B
    where B.TEST_VALUE_ID = T.TEST_VALUE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.TEST_VALUE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.TEST_VALUE_ID,
      SUBT.LANGUAGE
    from GMD_QC_TEST_VALUES_TL SUBB, GMD_QC_TEST_VALUES_TL SUBT
    where SUBB.TEST_VALUE_ID = SUBT.TEST_VALUE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.DISPLAY_LABEL_NUMERIC_RANGE <> SUBT.DISPLAY_LABEL_NUMERIC_RANGE
      or (SUBB.DISPLAY_LABEL_NUMERIC_RANGE is null and SUBT.DISPLAY_LABEL_NUMERIC_RANGE is not null)
      or (SUBB.DISPLAY_LABEL_NUMERIC_RANGE is not null and SUBT.DISPLAY_LABEL_NUMERIC_RANGE is null)
      or SUBB.TEST_VALUE_DESC <> SUBT.TEST_VALUE_DESC
      or (SUBB.TEST_VALUE_DESC is null and SUBT.TEST_VALUE_DESC is not null)
      or (SUBB.TEST_VALUE_DESC is not null and SUBT.TEST_VALUE_DESC is null)
  ));

Line: 637


  insert into GMD_QC_TEST_VALUES_TL (
    TEST_VALUE_ID,
    DISPLAY_LABEL_NUMERIC_RANGE,
    TEST_VALUE_DESC,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.TEST_VALUE_ID,
    B.DISPLAY_LABEL_NUMERIC_RANGE,
    B.TEST_VALUE_DESC,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from GMD_QC_TEST_VALUES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from GMD_QC_TEST_VALUES_TL T
    where T.TEST_VALUE_ID = B.TEST_VALUE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 677


    SELECT test_value_id
    INTO   dummy
    FROM   gmd_qc_test_values_b
    WHERE  test_value_id = p_test_value_id
    FOR UPDATE OF test_value_id NOWAIT  ;