APPS.BSC_DB_MEASURE_COLS_PKG SQL Statements

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

Line: 10

procedure INSERT_ROW (
  X_MEASURE_COL in VARCHAR2,
  X_MEASURE_GROUP_ID in NUMBER,
  X_PROJECTION_ID in NUMBER,
  X_MEASURE_TYPE in NUMBER,
  X_HELP in VARCHAR2
) is
l_count number;

Line: 30

  insert into BSC_DB_MEASURE_COLS_TL (
    MEASURE_COL,
    HELP,
    MEASURE_GROUP_ID,
    PROJECTION_ID,
    MEASURE_TYPE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_MEASURE_COL,
    nvl(X_HELP, 'Internal Column'),
    nvl(X_MEASURE_GROUP_ID, -1),
    nvl(X_PROJECTION_ID, 3),
    nvl(X_MEASURE_TYPE, 1),
    L.LANGUAGE_CODE,
    USERENV('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from BSC_DB_MEASURE_COLS_TL T
    where UPPER(T.MEASURE_COL) = UPPER(X_MEASURE_COL)
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 54

end INSERT_ROW;

Line: 63

  cursor c1 is select
      MEASURE_GROUP_ID,
      PROJECTION_ID,
      MEASURE_TYPE,
      HELP,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from BSC_DB_MEASURE_COLS_TL
    where MEASURE_COL = X_MEASURE_COL
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of MEASURE_COL nowait;

Line: 97

  update BSC_DB_MEASURE_COLS_TL set
    HELP = nvl(X_HELP,HELP),
    SOURCE_LANG = userenv('LANG')
  where MEASURE_COL = X_MEASURE_COL
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 108

procedure UPDATE_ROW (
  X_MEASURE_COL in VARCHAR2,
  X_MEASURE_GROUP_ID in NUMBER,
  X_PROJECTION_ID in NUMBER,
  X_MEASURE_TYPE in NUMBER,
  X_HELP in VARCHAR2
) is
begin

  TRANSLATE_ROW(X_MEASURE_COL, X_HELP);

Line: 119

  update BSC_DB_MEASURE_COLS_TL set
      MEASURE_GROUP_ID = X_MEASURE_GROUP_ID,
      PROJECTION_ID = X_PROJECTION_ID,
      MEASURE_TYPE = X_MEASURE_TYPE
    where MEASURE_COL = X_MEASURE_COL;

Line: 128

end UPDATE_ROW;

Line: 130

procedure DELETE_ROW (
  X_MEASURE_COL in VARCHAR2
) is
begin
  delete from BSC_DB_MEASURE_COLS_TL
  where MEASURE_COL = X_MEASURE_COL;

Line: 141

end DELETE_ROW;

Line: 146

  update BSC_DB_MEASURE_COLS_TL T set (
      HELP
    ) = (select
      B.HELP
    from BSC_DB_MEASURE_COLS_TL B
    where B.MEASURE_COL = T.MEASURE_COL
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.MEASURE_COL,
      T.LANGUAGE
  ) in (select
      SUBT.MEASURE_COL,
      SUBT.LANGUAGE
    from BSC_DB_MEASURE_COLS_TL SUBB, BSC_DB_MEASURE_COLS_TL SUBT
    where SUBB.MEASURE_COL = SUBT.MEASURE_COL
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.HELP <> SUBT.HELP
  ));

Line: 165

  insert into BSC_DB_MEASURE_COLS_TL (
    MEASURE_COL,
    HELP,
    MEASURE_GROUP_ID,
    PROJECTION_ID,
    MEASURE_TYPE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.MEASURE_COL,
    B.HELP,
    B.MEASURE_GROUP_ID,
    B.PROJECTION_ID,
    B.MEASURE_TYPE,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from BSC_DB_MEASURE_COLS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from BSC_DB_MEASURE_COLS_TL T
    where T.MEASURE_COL = B.MEASURE_COL
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 221

                dbms_sql.parse(l_cursor, 'select null ' || p_measure_col || ' from dual', dbms_sql.native);

Line: 241

 Update_Measure_Column_Help

 This API updates the help column in BSC_DB_MEASURE_COLS_TL table
 for the appropriate session language.

 Returns 'S' on successful update else returns 'E' or 'U' in x_Return_Status
 with an appropriate error message readable from x_Msg_Data
***************************************************************************/

PROCEDURE Update_Measure_Column_Help (
    p_Measure_Col    IN VARCHAR2
  , p_Help           IN VARCHAR2
  , x_Return_Status  OUT NOCOPY VARCHAR2
  , x_Msg_Count      OUT NOCOPY NUMBER
  , x_Msg_Data       OUT NOCOPY VARCHAR2
) IS
BEGIN
  SAVEPOINT UPDMEASCOLHELP;

Line: 263

  UPDATE BSC_DB_MEASURE_COLS_TL
  SET    HELP        = NVL(p_Help, HELP),
         SOURCE_LANG = USERENV('LANG')
  WHERE  MEASURE_COL = p_Measure_Col
  AND    USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 270

    FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

Line: 289

      x_msg_data      :=  'Error occured at BSC_DB_MEASURE_COLS_PKG.Update_Measure_Column_Help  - ' || SQLERRM;

Line: 290

END Update_Measure_Column_Help;