APPS.AMS_IBA_PS_FILTERS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  P_FILTER_ID in NUMBER,
  P_OBJECT_VERSION_NUMBER in NUMBER,
  P_FILTER_REF_CODE in VARCHAR2,
  P_CONTENT_TYPE in VARCHAR2,
  P_GROUP_NUM in NUMBER,
  P_FILTER_NAME 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
begin
  insert into AMS_IBA_PS_FILTERS_B (
    OBJECT_VERSION_NUMBER,
    FILTER_ID,
    FILTER_REF_CODE,
    CONTENT_TYPE,
    GROUP_NUM,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    P_OBJECT_VERSION_NUMBER,
    P_FILTER_ID,
    P_FILTER_REF_CODE,
    P_CONTENT_TYPE,
    P_GROUP_NUM,
    P_CREATION_DATE,
    P_CREATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_LOGIN
  );

Line: 41

  insert into AMS_IBA_PS_FILTERS_TL (
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER,
    FILTER_ID,
    FILTER_NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select
    P_CREATED_BY,
    P_CREATION_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATE_LOGIN,
    P_OBJECT_VERSION_NUMBER,
    P_FILTER_ID,
    P_FILTER_NAME,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AMS_IBA_PS_FILTERS_TL T
    where T.FILTER_ID = P_FILTER_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 71

end INSERT_ROW;

Line: 81

  cursor c is select
      OBJECT_VERSION_NUMBER,
      FILTER_REF_CODE,
      CONTENT_TYPE,
      GROUP_NUM
    from AMS_IBA_PS_FILTERS_B
    where FILTER_ID = X_FILTER_ID
    for update of FILTER_ID nowait;

Line: 91

  cursor c1 is select
      FILTER_NAME,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AMS_IBA_PS_FILTERS_TL
    where FILTER_ID = X_FILTER_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of FILTER_ID nowait;

Line: 103

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

Line: 137

procedure UPDATE_ROW (
  P_FILTER_ID in NUMBER,
  P_OBJECT_VERSION_NUMBER in NUMBER,
  P_FILTER_REF_CODE in VARCHAR2,
  P_CONTENT_TYPE in VARCHAR2,
  P_GROUP_NUM in NUMBER,
  P_FILTER_NAME in VARCHAR2,
  P_LAST_UPDATE_DATE in DATE,
  P_LAST_UPDATED_BY in NUMBER,
  P_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMS_IBA_PS_FILTERS_B set
    OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,
    FILTER_REF_CODE = P_FILTER_REF_CODE,
    CONTENT_TYPE = P_CONTENT_TYPE,
    GROUP_NUM = P_GROUP_NUM,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where FILTER_ID = P_FILTER_ID;

Line: 163

  update AMS_IBA_PS_FILTERS_TL set
    FILTER_NAME = P_FILTER_NAME,
    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 FILTER_ID = P_FILTER_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 176

end UPDATE_ROW;

Line: 178

procedure DELETE_ROW (
  P_FILTER_ID in NUMBER
) is
begin
  delete from AMS_IBA_PS_FILTERS_TL
  where FILTER_ID = P_FILTER_ID;

Line: 189

  delete from AMS_IBA_PS_FILTERS_B
  where FILTER_ID = P_FILTER_ID;

Line: 195

end DELETE_ROW;

Line: 200

  delete from AMS_IBA_PS_FILTERS_TL T
  where not exists
    (select NULL
    from AMS_IBA_PS_FILTERS_B B
    where B.FILTER_ID = T.FILTER_ID
    );

Line: 207

  update AMS_IBA_PS_FILTERS_TL T set (
      FILTER_NAME
    ) = (select
      B.FILTER_NAME
    from AMS_IBA_PS_FILTERS_TL B
    where B.FILTER_ID = T.FILTER_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.FILTER_ID,
      T.LANGUAGE
  ) in (select
      SUBT.FILTER_ID,
      SUBT.LANGUAGE
    from AMS_IBA_PS_FILTERS_TL SUBB, AMS_IBA_PS_FILTERS_TL SUBT
    where SUBB.FILTER_ID = SUBT.FILTER_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.FILTER_NAME <> SUBT.FILTER_NAME
  ));

Line: 226

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

Line: 266

    update ams_iba_ps_filters_tl set
       filter_name = nvl(x_filter_name, filter_name),
       source_lang = userenv('LANG'),
       last_update_date = sysdate,
       last_updated_by = decode(x_owner, 'SEED', 1, 0),
       last_update_login = 0
    where  filter_id = x_filter_id
    and      userenv('LANG') in (language, source_lang);

Line: 293

     select object_version_number
     from    ams_iba_ps_filters_b
     where  filter_id =  x_filter_id;

Line: 298

     select 'x'
     from   ams_iba_ps_filters_b
     where  filter_id = x_filter_id;

Line: 303

      select ams_iba_ps_filters_b_s.nextval
      from dual;

Line: 322

      AMS_IBA_PS_FILTERS_PKG.INSERT_ROW (
         p_filter_id => l_filter_id,
         p_object_version_number => l_obj_verno,
         p_filter_ref_code => x_filter_ref_code,
         p_content_type => x_content_type,
         p_group_num => x_group_num,
         p_filter_name => x_filter_name,
         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
      );

Line: 340

      AMS_IBA_PS_FILTERS_PKG.UPDATE_ROW (
         p_filter_id => l_filter_id,
         p_object_version_number => l_obj_verno+1,
         p_filter_ref_code => x_filter_ref_code,
         p_content_type => x_content_type,
         p_group_num => x_group_num,
         p_filter_name => x_filter_name,
         p_last_update_date => SYSDATE,
         p_last_updated_by => l_user_id,
         p_last_update_login => 0
      );