DBA Data[Home] [Help]

APPS.MTL_MVT_STATS_RULE_SETS_PKG SQL Statements

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

Line: 47

PROCEDURE Insert_Row
( x_rowid             IN OUT NOCOPY VARCHAR2
, p_rule_set_code         IN     VARCHAR2
, p_rule_set_display_name IN     VARCHAR2
, p_rule_set_description  IN     VARCHAR2
, p_rule_set_type     IN     VARCHAR2
, p_category_set_id   IN     NUMBER
, p_seeded_flag       IN     VARCHAR2
, p_creation_date     IN     DATE
, p_created_by        IN     NUMBER
, p_last_update_date  IN     DATE
, p_last_updated_by   IN     NUMBER
, p_last_update_login IN     NUMBER
)
IS
CURSOR c IS
  SELECT
    rowid
  FROM
    MTL_MVT_STATS_RULE_SETS_B
  WHERE Rule_Set_code = p_rule_set_code;
Line: 69

  INSERT INTO MTL_MVT_STATS_RULE_SETS_B
  ( Rule_Set_code
  , Rule_set_type
  , Seeded_Flag
  , Category_Set_Id
  , creation_date
  , created_by
  , last_update_date
  , last_updated_by
  , last_update_login
  )
  VALUES
  ( p_rule_set_code
  , p_Rule_set_type
  , p_seeded_flag
  , p_category_set_id
  , p_creation_date
  , p_created_by
  , p_last_update_date
  , p_last_updated_by
  , p_last_update_login
  );
Line: 92

  INSERT INTO MTL_MVT_STATS_RULE_SETS_TL
  ( Rule_Set_code
  , Rule_Set_display_name
  , Rule_Set_description
  , created_by
  , creation_date
  , last_updated_by
  , last_update_date
  , last_update_login
  , language
  , source_lang
  )
  SELECT
    p_rule_set_code
  , p_rule_set_display_name
  , p_rule_set_description
  , p_created_by
  , p_creation_date
  , p_last_updated_by
  , p_last_update_date
  , p_last_update_login
  , L.language_code
  , USERENV('LANG')
  FROM
    FND_LANGUAGES L
  WHERE L.installed_flag IN ('I', 'B')
    AND NOT EXISTS
       (SELECT
          NULL
        FROM
          MTL_MVT_STATS_RULE_SETS_TL T
        WHERE T.Rule_Set_code = p_rule_set_code
          AND T.language = L.language_code);
Line: 139

      FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Insert_Row');
Line: 143

END INSERT_ROW;
Line: 159

  SELECT *
  FROM
    MTL_MVT_STATS_RULE_SETS_B
  WHERE Rule_Set_code = p_rule_set_code
  FOR UPDATE OF Rule_Set_code NOWAIT;
Line: 167

  SELECT
    Rule_Set_display_name
  , Rule_Set_description
  , decode(language, USERENV('LANG'), 'Y', 'N') baselang
  FROM
    MTL_MVT_STATS_RULE_SETS_TL
  WHERE Rule_Set_code = p_rule_set_code
  FOR UPDATE OF Rule_Set_code NOWAIT;
Line: 184

    FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
Line: 209

      FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Insert_Row');
Line: 221

PROCEDURE Update_Row
( p_rule_set_code         IN VARCHAR2
, p_rule_set_display_name IN VARCHAR2
, p_rule_set_description  IN VARCHAR2
, p_rule_set_type     IN     VARCHAR2
, p_category_set_id   IN NUMBER
, p_last_update_date  IN DATE
, p_last_updated_by   IN NUMBER
, p_last_update_login IN NUMBER
)
IS
BEGIN
  UPDATE MTL_MVT_STATS_RULE_SETS_B
  SET
    last_update_date  = p_last_update_date
  , last_updated_by  = p_last_updated_by
  , last_update_login  = p_last_update_login
  , Rule_Set_type = p_rule_set_type
  , Category_Set_Id = p_category_set_id
  WHERE Rule_Set_code = p_rule_set_code;
Line: 247

  UPDATE MTL_MVT_STATS_RULE_SETS_TL
  SET
    Rule_Set_display_name  = p_rule_set_display_name
  , Rule_Set_description = p_rule_set_description
  , last_update_date  = p_last_update_date
  , last_updated_by  = p_last_updated_by
  , last_update_login  = p_last_update_login
  , source_lang = USERENV('LANG')
  WHERE Rule_Set_code = p_rule_set_code
    AND USERENV('LANG') IN (language, source_lang);
Line: 267

      FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Update_Row');
Line: 271

END Update_Row;
Line: 279

PROCEDURE Delete_Row
( p_rule_set_code IN VARCHAR2
)
IS
BEGIN
  DELETE FROM MTL_MVT_STATS_RULE_SETS_TL
  WHERE Rule_Set_code = p_rule_set_code;
Line: 292

  DELETE FROM MTL_MVT_STATS_RULE_SETS_B
  WHERE Rule_Set_code = p_rule_set_code;
Line: 304

      FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Delete_Row');
Line: 308

END DELETE_ROW;
Line: 319

  DELETE FROM MTL_MVT_STATS_RULE_SETS_TL T
  WHERE NOT EXISTS
    (SELECT
       NULL
     FROM
       MTL_MVT_STATS_RULE_SETS_B B
     WHERE B.Rule_Set_code = T.Rule_Set_code
     );
Line: 328

  UPDATE MTL_MVT_STATS_RULE_SETS_TL T
  SET (Rule_Set_display_name
       ,Rule_Set_description ) =
      (SELECT
         B.Rule_Set_display_name
         , B.Rule_Set_description
       FROM
         MTL_MVT_STATS_RULE_SETS_TL B
       WHERE B.Rule_Set_code = T.Rule_Set_code
         AND B.language = T.source_lang)
  WHERE (T.Rule_Set_code
        , T.language
     )IN (SELECT
            SUBT.Rule_Set_code
          , SUBT.language
          FROM
            MTL_MVT_STATS_RULE_SETS_TL SUBB
          , MTL_MVT_STATS_RULE_SETS_TL SUBT
          WHERE SUBB.Rule_Set_code = SUBT.Rule_Set_code
            AND SUBB.language = SUBT.source_lang
            AND (SUBB.Rule_Set_display_name  <> SUBT.Rule_Set_display_name
                 OR SUBB.Rule_Set_description <> SUBT.Rule_Set_description));
Line: 351

  INSERT INTO MTL_MVT_STATS_RULE_SETS_TL
  ( Rule_Set_code
  , Rule_Set_display_name
  , Rule_Set_description
  , created_by
  , creation_date
  , last_updated_by
  , last_update_date
  , last_update_login
  , language
  , source_lang
  )
  SELECT
      B.Rule_Set_code
    , B.Rule_Set_display_name
    , B.Rule_Set_description
    , B.created_by
    , B.creation_date
    , B.last_updated_by
    , B.last_update_date
    , B.last_update_login
    , L.language_CODE
    , B.source_lang
  FROM
    MTL_MVT_STATS_RULE_SETS_TL B
  , FND_LANGUAGES L
  WHERE L.INSTALLED_FLAG IN ('I', 'B')
    AND B.language = USERENV('LANG')
    AND NOT EXISTS
       (SELECT
          NULL
        FROM
          MTL_MVT_STATS_RULE_SETS_TL T
        WHERE T.Rule_Set_code = B.Rule_Set_code
          AND T.language = L.language_CODE);
Line: 414

  UPDATE mtl_mvt_stats_rule_sets_tl
    SET Rule_Set_display_name = p_rule_set_display_name
      , Rule_Set_description  = p_rule_set_description
      , last_update_date  = SYSDATE
      , last_updated_by   = DECODE(p_owner, 'SEED', 1, 0)
      , last_update_login = 0
      , source_lang       = userenv('LANG')
    WHERE Rule_Set_code = p_rule_set_code
      AND userenv('LANG') IN (language, source_lang);
Line: 468

    Update_Row
    ( p_rule_set_code         => p_rule_set_code
    , p_rule_set_display_name => p_rule_set_display_name
    , p_rule_set_description  => p_rule_set_description
    , p_rule_set_type  => p_rule_set_type
    , p_category_set_id  => p_category_set_id
    , p_last_update_date  => SYSDATE
    , p_last_updated_by   => l_user_id
    , p_last_update_login => 0
    );
Line: 481

      Insert_Row
      ( x_rowid             => l_row_id
      , p_rule_set_code         => p_rule_set_code
      , p_rule_set_display_name => p_rule_set_display_name
      , p_rule_set_description  => p_rule_set_description
      , p_rule_set_type  => p_rule_set_type
      , p_category_set_id  => p_category_set_id
      , p_seeded_flag      => p_seeded_flag
      , p_creation_date     => SYSDATE
      , p_created_by        => l_user_id
      , p_last_update_date  => SYSDATE
      , p_last_updated_by   => l_user_id
      , p_last_update_login => 0
      );