APPS.BSC_DB_MEASURE_GROUPS_PKG SQL Statements

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

Line: 6

PROCEDURE INSERT_ROW
(
    X_MEASURE_GROUP_ID    OUT NOCOPY NUMBER
  , X_HELP                IN         VARCHAR2
  , X_SHORT_NAME          IN         VARCHAR2 := NULL
)IS
  l_count   NUMBER;

Line: 18

  SELECT COUNT(1)
  INTO   l_count
  FROM   bsc_db_measure_groups_tl
  WHERE  help = x_help;

Line: 27

    SELECT bsc_db_measure_groups_s.nextVal
    INTO   X_MEASURE_GROUP_ID
    FROM   dual;

Line: 31

    BSC_DB_MEASURE_GROUPS_PKG.Insert_Row_Values
    (
        x_Measure_group_id  =>  X_MEASURE_GROUP_ID
      , x_Help              =>  X_HELP
      , x_Short_name        =>  X_SHORT_NAME
    );

Line: 40

END INSERT_ROW;

Line: 46

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

Line: 69

PROCEDURE UPDATE_ROW
(
    X_MEASURE_GROUP_ID  IN NUMBER
  , X_HELP              IN VARCHAR2
  , X_SHORT_NAME        IN VARCHAR2:= NULL
)IS
BEGIN

 UPDATE bsc_db_measure_groups_tl
 SET    help        = X_HELP
      , short_name  = X_SHORT_NAME
      , source_lang = USERENV('LANG')
 WHERE measure_group_id = X_MEASURE_GROUP_ID
 AND   USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 88

END UPDATE_ROW;

Line: 95

  update BSC_DB_MEASURE_GROUPS_TL set
    HELP = nvl(X_HELP,HELP),
    SOURCE_LANG = userenv('LANG')
  where MEASURE_GROUP_ID = X_MEASURE_GROUP_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 107

procedure DELETE_ROW (
  X_MEASURE_GROUP_ID in NUMBER
) is
begin
  delete from BSC_DB_MEASURE_GROUPS_TL
  where MEASURE_GROUP_ID = X_MEASURE_GROUP_ID;

Line: 118

end DELETE_ROW;

Line: 125

  UPDATE bsc_db_measure_groups_tl t
  SET (
        help
      ) = (
           SELECT b.help
           FROM   bsc_db_measure_groups_tl b
           WHERE  b.Measure_group_id = t.Measure_group_id
           AND    b.language = t.Source_lang)
  WHERE (
      t.Measure_group_id,
      t.language
  ) IN (
        SELECT subt.Measure_group_id
              ,subt.language
        FROM  bsc_db_measure_groups_tl subb
            , bsc_db_measure_groups_tl subt
        WHERE subb.Measure_group_id = subt.Measure_group_id
        AND   subb.language = subt.Source_lang
        AND   (subb.help <> subt.help));

Line: 146

  INSERT INTO bsc_db_measure_groups_tl
  (  help
   , measure_group_id
   , language
   , source_lang
   , short_name
  ) SELECT  b.Help
          , b.Measure_group_id
          , l.Language_code
          , b.Source_lang
          , b.Short_name
    FROM  bsc_db_measure_groups_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_groups_tl t
                    WHERE  t.Measure_group_id = b.Measure_group_id
                    AND    t.language = l.language_code);

Line: 170

 Procedure    : Insert_Default_Meas_Row
 Description  : This procedure is called from bscmsgrp.lct
                file.Pls don't modify this procedure.
 Input        : Default measure group id <-1>
              :  help
 Created BY   : ashankar 27-JUL-2005
/**************************************************/

PROCEDURE Insert_Default_Meas_Row
(
    x_Measure_group_id    IN    NUMBER
  , x_Help                IN    VARCHAR2
)IS
BEGIN

      BSC_DB_MEASURE_GROUPS_PKG.Insert_Row_Values
      (
          x_Measure_group_id  =>  x_Measure_group_id
        , x_Help              =>  x_Help
        , x_Short_name        =>  NULL
      );

Line: 191

END Insert_Default_Meas_Row;

Line: 194

 Procedure    : Insert_Row_Values
 Description  : This procedure insert values into bsc_db_measure_groups_tl table.
 Input        : Measure group Id
              : help
              : short_name
 Created BY   : ashankar 27-JUL-2005
 Note         : Removed the dynamic SQL because BSC 5.2 MD/DD xdf files are included with BIS 4.0.9
                Verified BIS ARU 4122391 it contains bsc_db_measure_groups_tl.xdf version 115.3
                So SHORT_NAME column will always be there.
/***************************************************************************************************/

PROCEDURE Insert_Row_Values
(
    x_Measure_group_id    IN    NUMBER
  , x_Help                IN    VARCHAR2
  , x_Short_name          IN    VARCHAR2
)IS
BEGIN
    INSERT INTO bsc_db_measure_groups_tl
    ( short_name
     , help
     , measure_group_id
     ,language
     ,source_lang
    ) SELECT  x_Short_name
            , x_Help
            , x_Measure_group_id
            , 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_groups_tl t
                      WHERE  t.measure_group_id = x_Measure_group_id
                      AND    t.language = l.language_code);

Line: 231

END  Insert_Row_Values;