APPS.AS_SALES_LEAD_RANKS_PKG SQL Statements

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

Line: 9

procedure INSERT_ROW (
  X_RANK_ID in OUT NOCOPY NUMBER,
  X_MIN_SCORE in NUMBER,
  X_MAX_SCORE in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_MEANING in VARCHAR2,
  X_DESCRIPTION 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 AS_SALES_LEAD_RANKS_B
    where RANK_ID = X_RANK_ID
    ;

Line: 28

  insert into AS_SALES_LEAD_RANKS_B (
    RANK_ID,
    MIN_SCORE,
    MAX_SCORE,
    ENABLED_FLAG,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_RANK_ID,
    X_MIN_SCORE,
    X_MAX_SCORE,
    X_ENABLED_FLAG,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 50

  insert into AS_SALES_LEAD_RANKS_TL (
    RANK_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    MEANING,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_RANK_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_MEANING,
    X_DESCRIPTION,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AS_SALES_LEAD_RANKS_TL T
    where T.RANK_ID = X_RANK_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 89

end INSERT_ROW;

Line: 98

  cursor c is select
      MIN_SCORE,
      MAX_SCORE,
      ENABLED_FLAG
    from AS_SALES_LEAD_RANKS_B
    where RANK_ID = X_RANK_ID
    for update of RANK_ID nowait;

Line: 107

  cursor c1 is select
      MEANING,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AS_SALES_LEAD_RANKS_TL
    where RANK_ID = X_RANK_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of RANK_ID nowait;

Line: 119

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

Line: 147

procedure UPDATE_ROW (
  X_RANK_ID in NUMBER,
  X_MIN_SCORE in NUMBER,
  X_MAX_SCORE in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_MEANING in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AS_SALES_LEAD_RANKS_B set
    MIN_SCORE = X_MIN_SCORE,
    MAX_SCORE = X_MAX_SCORE,
    ENABLED_FLAG = X_ENABLED_FLAG,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where RANK_ID = X_RANK_ID;

Line: 172

  update AS_SALES_LEAD_RANKS_TL set
    MEANING = X_MEANING,
    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 RANK_ID = X_RANK_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 185

end UPDATE_ROW;

Line: 187

procedure DELETE_ROW (
  X_RANK_ID in NUMBER
) is
begin
  delete from AS_SALES_LEAD_RANKS_TL
  where RANK_ID = X_RANK_ID;

Line: 198

  delete from AS_SALES_LEAD_RANKS_B
  where RANK_ID = X_RANK_ID;

Line: 204

end DELETE_ROW;

Line: 209

  delete from AS_SALES_LEAD_RANKS_TL T
  where not exists
    (select NULL
    from AS_SALES_LEAD_RANKS_B B
    where B.RANK_ID = T.RANK_ID
    );

Line: 216

  update AS_SALES_LEAD_RANKS_TL T set (
      MEANING
    ) = (select
      B.MEANING
    from AS_SALES_LEAD_RANKS_TL B
    where B.RANK_ID = T.RANK_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.RANK_ID,
      T.LANGUAGE
  ) in (select
      SUBT.RANK_ID,
      SUBT.LANGUAGE
    from AS_SALES_LEAD_RANKS_TL SUBB, AS_SALES_LEAD_RANKS_TL SUBT
    where SUBB.RANK_ID = SUBT.RANK_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.MEANING <> SUBT.MEANING
  ));

Line: 235

  insert into AS_SALES_LEAD_RANKS_TL (
    --SECURITY_GROUP_ID,
    RANK_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    MEANING,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
   -- B.SECURITY_GROUP_ID,
    B.RANK_ID,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.MEANING,
    B.DESCRIPTION,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AS_SALES_LEAD_RANKS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AS_SALES_LEAD_RANKS_TL T
    where T.RANK_ID = B.RANK_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 282

    CURSOR c_get_last_updated (c_rank_id NUMBER) IS
        SELECT last_updated_by
        FROM AS_SALES_LEAD_RANKS_B
        WHERE rank_id = c_rank_id;

Line: 286

    l_last_updated_by  NUMBER;

Line: 293

    OPEN c_get_last_updated (x_RANK_ID);

Line: 294

    FETCH c_get_last_updated INTO l_last_updated_by;

Line: 295

    CLOSE c_get_last_updated;

Line: 297

    IF nvl(l_last_updated_by, 1) = 1
    THEN
        if (X_OWNER = 'SEED') then
            user_id := 1;

Line: 303

        Update_Row(x_RANK_ID            => x_RANK_ID,
                   x_MIN_SCORE          => x_MIN_SCORE,
                   x_MAX_SCORE          => x_MAX_SCORE,
                   x_enabled_flag       => x_enabled_flag,
                   x_meaning            => x_meaning,
                   x_description        => x_description,
                   X_LAST_UPDATE_DATE   => sysdate,
                   X_LAST_UPDATED_BY    => user_id,
                   X_LAST_UPDATE_LOGIN  => 0
                   );

Line: 317

            Insert_Row(x_RANK_ID            => x_RANK_ID,
                       x_MIN_SCORE          => x_MIN_SCORE,
                       x_MAX_SCORE          => x_MAX_SCORE,
                       x_enabled_flag       => x_enabled_flag,
                       x_meaning            => x_meaning,
                       x_description        => x_description,
                       x_creation_date      => sysdate,
                       x_created_by         => 0,
                       X_LAST_UPDATE_DATE   => sysdate,
                       X_LAST_UPDATED_BY    => user_id,
                       X_LAST_UPDATE_LOGIN  => 0
                       );

Line: 340

      UPDATE AS_SALES_LEAD_RANKS_TL SET
        meaning = p_meaning,
        source_lang = userenv('LANG'),
        last_update_date = sysdate,
        last_updated_by = decode(p_owner, 'SEED', -1, 0),
        last_update_login = 0
      WHERE rank_id = P_sales_lead_rank_id
      AND   userenv('LANG') IN (language, source_lang);