APPS.OKC_UDA_TEMPLATES_ALL_PKG SQL Statements

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

Line: 3

  procedure INSERT_ROW (
    X_ROWID in out nocopy VARCHAR2,
    X_UDA_TEMPLATE_ID in NUMBER,
    X_UDA_TEMPLATE_NAME in VARCHAR2,
    X_START_DATE in DATE,
    X_END_DATE in DATE,
    X_VERSION_NUMBER in NUMBER,
    X_STATUS_FLAG in VARCHAR2,
    X_ORG_ID in NUMBER,
    X_TEMPLATE_CATEGORY in VARCHAR2,
    X_CATEGORY_VALUE in VARCHAR2,
    X_COMMENTS in VARCHAR2,
    X_ORIG_TEMPLATE_ID in NUMBER,
    X_CREATED_BY in NUMBER,
    X_LAST_UPDATED_BY in NUMBER,
    X_LAST_UPDATE_LOGIN in NUMBER,
    X_CREATION_DATE in DATE,
    X_LAST_UPDATE_DATE in DATE,
    X_UDA_TEMPLATE_DISP_NAME in VARCHAR2
  ) is
    cursor C is select ROWID from OKC_UDA_TEMPLATES_ALL
      where UDA_TEMPLATE_ID = X_UDA_TEMPLATE_ID
      ;

Line: 27

    insert into OKC_UDA_TEMPLATES_ALL (
      UDA_TEMPLATE_ID,
      START_DATE,
      END_DATE,
      VERSION_NUMBER,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN
    ) values (
      X_UDA_TEMPLATE_ID,
      X_START_DATE,
      X_END_DATE,
      X_VERSION_NUMBER,
      X_CREATION_DATE,
      X_CREATED_BY,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN
    );

Line: 49

    insert into OKC_UDA_TEMPLATES_ALL_TL (
      UDA_TEMPLATE_ID,
      UDA_TEMPLATE_DISP_NAME,
      COMMENTS,
      CREATED_BY,
      CREATION_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      LANGUAGE,
      SOURCE_LANG
    ) select
      X_UDA_TEMPLATE_ID,
      X_UDA_TEMPLATE_DISP_NAME,
      X_COMMENTS,
      X_CREATED_BY,
      X_CREATION_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_DATE,
      X_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 OKC_UDA_TEMPLATES_ALL_TL T
      where T.UDA_TEMPLATE_ID = X_UDA_TEMPLATE_ID
      and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 87

  end INSERT_ROW;

Line: 97

    cursor c is select
        END_DATE,
        VERSION_NUMBER,
        START_DATE
      from OKC_UDA_TEMPLATES_ALL
      where UDA_TEMPLATE_ID = X_UDA_TEMPLATE_ID
      for update of UDA_TEMPLATE_ID nowait;

Line: 106

    cursor c1 is select
        UDA_TEMPLATE_DISP_NAME,
        COMMENTS,
        decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
      from OKC_UDA_TEMPLATES_ALL_TL
      where UDA_TEMPLATE_ID = X_UDA_TEMPLATE_ID
      and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
      for update of UDA_TEMPLATE_ID nowait;

Line: 119

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

Line: 150

  procedure UPDATE_ROW (
    X_UDA_TEMPLATE_ID in NUMBER,
    X_UDA_TEMPLATE_NAME in VARCHAR2,
    X_START_DATE in DATE,
    X_END_DATE in DATE,
    X_VERSION_NUMBER in NUMBER,
    X_STATUS_FLAG in VARCHAR2,
    X_ORG_ID in NUMBER,
    X_TEMPLATE_CATEGORY in VARCHAR2,
    X_CATEGORY_VALUE in VARCHAR2,
    X_COMMENTS in VARCHAR2,
    X_ORIG_TEMPLATE_ID in NUMBER,
    X_LAST_UPDATED_BY in NUMBER,
    X_LAST_UPDATE_LOGIN in NUMBER,
    X_LAST_UPDATE_DATE in DATE,
    X_UDA_TEMPLATE_DISP_NAME in VARCHAR2
  ) is
  begin
    update OKC_UDA_TEMPLATES_ALL set
      UDA_TEMPLATE_NAME = X_UDA_TEMPLATE_NAME,
      STATUS_FLAG = X_STATUS_FLAG ,
      ORG_ID = X_ORG_ID,
      TEMPLATE_CATEGORY = X_TEMPLATE_CATEGORY,
      CATEGORY_VALUE = X_CATEGORY_VALUE ,
      COMMENTS = X_COMMENTS,
      ORIG_TEMPLATE_ID = X_ORIG_TEMPLATE_ID,
      END_DATE = X_END_DATE,
      VERSION_NUMBER = X_VERSION_NUMBER,
      START_DATE = X_START_DATE,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
    where UDA_TEMPLATE_ID = X_UDA_TEMPLATE_ID;

Line: 188

    update OKC_UDA_TEMPLATES_ALL_TL set
      UDA_TEMPLATE_DISP_NAME = X_UDA_TEMPLATE_DISP_NAME,
      COMMENTS = X_COMMENTS,
      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 UDA_TEMPLATE_ID = X_UDA_TEMPLATE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 201

  end UPDATE_ROW;

Line: 203

  procedure DELETE_ROW (
    X_UDA_TEMPLATE_ID in NUMBER
  ) is
  begin
    delete from OKC_UDA_TEMPLATES_ALL_TL
    where UDA_TEMPLATE_ID = X_UDA_TEMPLATE_ID;

Line: 214

    delete from OKC_UDA_TEMPLATES_ALL
    where UDA_TEMPLATE_ID = X_UDA_TEMPLATE_ID;

Line: 220

  end DELETE_ROW;

Line: 225

    delete from OKC_UDA_TEMPLATES_ALL_TL T
    where not exists
      (select NULL
      from OKC_UDA_TEMPLATES_ALL B
      where B.UDA_TEMPLATE_ID = T.UDA_TEMPLATE_ID
      );

Line: 232

    update OKC_UDA_TEMPLATES_ALL_TL T set (
        UDA_TEMPLATE_DISP_NAME,
        COMMENTS
      ) = (select
        B.UDA_TEMPLATE_DISP_NAME,
        B.COMMENTS
      from OKC_UDA_TEMPLATES_ALL_TL B
      where B.UDA_TEMPLATE_ID = T.UDA_TEMPLATE_ID
      and B.LANGUAGE = T.SOURCE_LANG)
    where (
        T.UDA_TEMPLATE_ID,
        T.LANGUAGE
    ) in (select
        SUBT.UDA_TEMPLATE_ID,
        SUBT.LANGUAGE
      from OKC_UDA_TEMPLATES_ALL_TL SUBB, OKC_UDA_TEMPLATES_ALL_TL SUBT
      where SUBB.UDA_TEMPLATE_ID = SUBT.UDA_TEMPLATE_ID
      and SUBB.LANGUAGE = SUBT.SOURCE_LANG
      and (SUBB.UDA_TEMPLATE_DISP_NAME <> SUBT.UDA_TEMPLATE_DISP_NAME
        or SUBB.COMMENTS <> SUBT.COMMENTS
        or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
        or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
    ));

Line: 256

    insert into OKC_UDA_TEMPLATES_ALL_TL (
      UDA_TEMPLATE_ID,
      UDA_TEMPLATE_DISP_NAME,
      COMMENTS,
      CREATED_BY,
      CREATION_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      LANGUAGE,
      SOURCE_LANG
    ) select /*+ ORDERED */
      B.UDA_TEMPLATE_ID,
      B.UDA_TEMPLATE_DISP_NAME,
      B.COMMENTS,
      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 OKC_UDA_TEMPLATES_ALL_TL B, FND_LANGUAGES L
    where L.INSTALLED_FLAG in ('I', 'B')
    and B.LANGUAGE = userenv('LANG')
    and not exists
      (select NULL
      from OKC_UDA_TEMPLATES_ALL_TL T
      where T.UDA_TEMPLATE_ID = B.UDA_TEMPLATE_ID
      and T.LANGUAGE = L.LANGUAGE_CODE);