DBA Data[Home] [Help]

APPS.ICX_NONCAT_TEMPLATES_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID             in out NOCOPY VARCHAR2,
  X_TEMPLATE_ID       in NUMBER,
  X_ORG_ID            in NUMBER,
  X_TEMPLATE_NAME     in VARCHAR2,
  X_ITEM_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 POR_NONCAT_TEMPLATES_ALL_B
    where TEMPLATE_ID = X_TEMPLATE_ID;
Line: 20

  insert into POR_NONCAT_TEMPLATES_ALL_B (
    TEMPLATE_ID,
    ORG_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    RFQ_REQUIRED_FLAG,
    RFQ_REQ_EDITABLE_FLAG
  ) values (
    X_TEMPLATE_ID,
    X_ORG_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    'N',
    'Y'
  );
Line: 42

  insert into POR_NONCAT_TEMPLATES_ALL_TL (
    TEMPLATE_ID,
    TEMPLATE_NAME,
    ITEM_DESCRIPTION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_TEMPLATE_ID,
    X_TEMPLATE_NAME,
    X_ITEM_DESCRIPTION,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    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  POR_NONCAT_TEMPLATES_ALL_TL T
    where T.TEMPLATE_ID = X_TEMPLATE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);
Line: 80

end INSERT_ROW;
Line: 82

procedure UPDATE_ROW (
  X_TEMPLATE_ID       in NUMBER,
  X_ORG_ID            in NUMBER,
  X_TEMPLATE_NAME     in VARCHAR2,
  X_ITEM_DESCRIPTION  in VARCHAR2,
  X_LAST_UPDATE_DATE  in DATE,
  X_LAST_UPDATED_BY   in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update POR_NONCAT_TEMPLATES_ALL_B set
    ORG_ID = X_ORG_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where TEMPLATE_ID = X_TEMPLATE_ID;
Line: 103

  update POR_NONCAT_TEMPLATES_ALL_TL set
    TEMPLATE_NAME = X_TEMPLATE_NAME,
    ITEM_DESCRIPTION = X_ITEM_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 TEMPLATE_ID = X_TEMPLATE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
Line: 114

    insert into POR_NONCAT_TEMPLATES_ALL_TL (
      TEMPLATE_ID,
      TEMPLATE_NAME,
      ITEM_DESCRIPTION,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      LANGUAGE,
      SOURCE_LANG
    ) values (
      X_TEMPLATE_ID,
      X_TEMPLATE_NAME,
      X_ITEM_DESCRIPTION,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN,
      userenv('LANG'),
      userenv('LANG'));
Line: 137

end UPDATE_ROW;
Line: 145

  X_LAST_UPDATE_DATE  in VARCHAR2) IS
begin
  declare
    f_luby	number;	-- entity owner in file
Line: 149

    f_ludate  date;  -- entity update in file
Line: 151

    db_ludate	date;   -- entity update in db
Line: 155

    f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
Line: 157

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into   db_luby, db_ludate
    from   POR_NONCAT_TEMPLATES_ALL_TL
    where  LANGUAGE = userenv('LANG')
    and    TEMPLATE_ID = to_number(X_TEMPLATE_ID);
Line: 175

      update POR_NONCAT_TEMPLATES_ALL_TL set
        TEMPLATE_NAME          = nvl(X_TEMPLATE_NAME, TEMPLATE_NAME),
        ITEM_DESCRIPTION   = nvl(X_ITEM_DESCRIPTION, ITEM_DESCRIPTION),
        last_update_date    = f_ludate,
        last_updated_by     = f_luby,
        last_update_login   = 0,
        source_lang         = userenv('LANG')
      where TEMPLATE_ID  = to_number(X_TEMPLATE_ID)
        and userenv('LANG') in (language, source_lang);
Line: 197

  X_LAST_UPDATE_DATE  in VARCHAR2) IS
begin

  declare
    row_id  varchar2(64);
Line: 203

    f_ludate  date;  -- entity update in file
Line: 205

    db_ludate	date;   -- entity update in db
Line: 210

    f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
Line: 212

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into   db_luby, db_ludate
    from   POR_NONCAT_TEMPLATES_ALL_TL
    where  LANGUAGE = userenv('LANG')
    and    TEMPLATE_ID = to_number(X_TEMPLATE_ID);
Line: 230

      ICX_NONCAT_TEMPLATES_PKG.UPDATE_ROW (
        X_TEMPLATE_ID	=> to_number(X_TEMPLATE_ID),
        X_ORG_ID        => to_number(X_ORG_ID),
        X_TEMPLATE_NAME        => X_TEMPLATE_NAME,
        X_ITEM_DESCRIPTION => X_ITEM_DESCRIPTION,
      	X_LAST_UPDATE_DATE	=> f_ludate,
        X_LAST_UPDATED_BY	  => f_luby,
       	X_LAST_UPDATE_LOGIN	=> 0 );
Line: 242

       ICX_NONCAT_TEMPLATES_PKG.INSERT_ROW (
          X_ROWID			=> row_id,
          X_TEMPLATE_ID	=> to_number(X_TEMPLATE_ID),
          X_ORG_ID   => to_number(X_ORG_ID),
          X_TEMPLATE_NAME        => X_TEMPLATE_NAME,
          X_ITEM_DESCRIPTION => X_ITEM_DESCRIPTION,
          X_CREATION_DATE		=> f_ludate,
          X_CREATED_BY		=> f_luby,
          X_LAST_UPDATE_DATE	=> f_ludate,
          X_LAST_UPDATED_BY	=> f_luby,
          X_LAST_UPDATE_LOGIN	=> 0 );
Line: 260

  delete from POR_NONCAT_TEMPLATES_ALL_TL T
  where not exists
    (select NULL
    from POR_NONCAT_TEMPLATES_ALL_B B
    where B.TEMPLATE_ID = T.TEMPLATE_ID
    );
Line: 267

  insert into POR_NONCAT_TEMPLATES_ALL_TL (
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    TEMPLATE_ID,
    TEMPLATE_NAME,
    ITEM_DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.LAST_UPDATE_LOGIN,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.TEMPLATE_ID,
    B.TEMPLATE_NAME,
    B.ITEM_DESCRIPTION,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from POR_NONCAT_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 POR_NONCAT_TEMPLATES_ALL_TL T
    where T.TEMPLATE_ID = B.TEMPLATE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);