eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_PAGE_FIELDS_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_PAGE_ID in NUMBER,
  X_FIELD_ID in NUMBER,
  X_FIELD_NAME in VARCHAR2,
  X_FIELD_DISP_SEQUENCE_NUMBER in NUMBER,
  X_FIELD_PROMPT in VARCHAR2,
  X_FIELD_TYPE in VARCHAR2,
  X_FIELD_CONSTRUCTOR_PARAM in VARCHAR2,
  X_FIELD_CATEGORY in VARCHAR2,
  X_FIELD_IS_CONFIGURABLE in VARCHAR2,
  X_FIELD_IS_VISIBLE in VARCHAR2,
  X_FIELD_PROPERTY1_DEFAULT_VALU in NUMBER,
  X_FIELD_PROPERTY2_DEFAULT_VALU in NUMBER,
  X_FIELD_USER_NAME 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 WMS_PAGE_FIELDS_B
    where PAGE_ID = X_PAGE_ID
    and FIELD_ID = X_FIELD_ID
    ;

Line: 30


  insert into WMS_PAGE_FIELDS_B (
    PAGE_ID,
    FIELD_ID,
    FIELD_NAME,
    FIELD_DISP_SEQUENCE_NUMBER,
    FIELD_PROMPT,
    FIELD_TYPE,
    FIELD_CONSTRUCTOR_PARAM,
    FIELD_CATEGORY,
    FIELD_IS_CONFIGURABLE,
    FIELD_IS_VISIBLE,
    FIELD_PROPERTY1_DEFAULT_VALUE,
    FIELD_PROPERTY2_DEFAULT_VALUE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_PAGE_ID,
    X_FIELD_ID,
    X_FIELD_NAME,
    X_FIELD_DISP_SEQUENCE_NUMBER,
    X_FIELD_PROMPT,
    X_FIELD_TYPE,
    X_FIELD_CONSTRUCTOR_PARAM,
    X_FIELD_CATEGORY,
    X_FIELD_IS_CONFIGURABLE,
    X_FIELD_IS_VISIBLE,
    X_FIELD_PROPERTY1_DEFAULT_VALU,
    X_FIELD_PROPERTY2_DEFAULT_VALU,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 68


  insert into WMS_PAGE_FIELDS_TL (
    PAGE_ID,
    FIELD_ID,
    FIELD_USER_NAME,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_PAGE_ID,
    X_FIELD_ID,
    X_FIELD_USER_NAME,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_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 WMS_PAGE_FIELDS_TL T
    where T.PAGE_ID = X_PAGE_ID
    and T.FIELD_ID = X_FIELD_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 107


end INSERT_ROW;

Line: 124


  cursor c is select
      FIELD_NAME,
      FIELD_DISP_SEQUENCE_NUMBER,
      FIELD_PROMPT,
      FIELD_TYPE,
      FIELD_CONSTRUCTOR_PARAM,
      FIELD_CATEGORY,
      FIELD_IS_CONFIGURABLE,
      FIELD_IS_VISIBLE,
      FIELD_PROPERTY1_DEFAULT_VALUE,
      FIELD_PROPERTY2_DEFAULT_VALUE
    from WMS_PAGE_FIELDS_B
    where PAGE_ID = X_PAGE_ID
    and FIELD_ID = X_FIELD_ID
    for update of PAGE_ID nowait;

Line: 141


  cursor c1 is select
      FIELD_USER_NAME,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from WMS_PAGE_FIELDS_TL
    where PAGE_ID = X_PAGE_ID
    and FIELD_ID = X_FIELD_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of PAGE_ID nowait;

Line: 154


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

Line: 199


procedure UPDATE_ROW (
  X_PAGE_ID in NUMBER,
  X_FIELD_ID in NUMBER,
  X_FIELD_NAME in VARCHAR2,
  X_FIELD_DISP_SEQUENCE_NUMBER in NUMBER,
  X_FIELD_PROMPT in VARCHAR2,
  X_FIELD_TYPE in VARCHAR2,
  X_FIELD_CONSTRUCTOR_PARAM in VARCHAR2,
  X_FIELD_CATEGORY in VARCHAR2,
  X_FIELD_IS_CONFIGURABLE in VARCHAR2,
  X_FIELD_IS_VISIBLE in VARCHAR2,
  X_FIELD_PROPERTY1_DEFAULT_VALU in NUMBER,
  X_FIELD_PROPERTY2_DEFAULT_VALU in NUMBER,
  X_FIELD_USER_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update WMS_PAGE_FIELDS_B set
    FIELD_NAME = X_FIELD_NAME,
    FIELD_DISP_SEQUENCE_NUMBER = X_FIELD_DISP_SEQUENCE_NUMBER,
    FIELD_PROMPT = X_FIELD_PROMPT,
    FIELD_TYPE = X_FIELD_TYPE,
    FIELD_CONSTRUCTOR_PARAM = X_FIELD_CONSTRUCTOR_PARAM,
    FIELD_CATEGORY = X_FIELD_CATEGORY,
    FIELD_IS_CONFIGURABLE = X_FIELD_IS_CONFIGURABLE,
    FIELD_IS_VISIBLE = X_FIELD_IS_VISIBLE,
    FIELD_PROPERTY1_DEFAULT_VALUE = X_FIELD_PROPERTY1_DEFAULT_VALU,
    FIELD_PROPERTY2_DEFAULT_VALUE = X_FIELD_PROPERTY2_DEFAULT_VALU,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PAGE_ID = X_PAGE_ID
  and FIELD_ID = X_FIELD_ID;

Line: 239


  update WMS_PAGE_FIELDS_TL set
    FIELD_USER_NAME = X_FIELD_USER_NAME,
    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 PAGE_ID = X_PAGE_ID
  and FIELD_ID = X_FIELD_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 252


end UPDATE_ROW;

Line: 258


  X_LAST_UPDATE_DATE in DATE,
  X_FIELD_USER_NAME in VARCHAR2) is
begin

  update WMS_PAGE_FIELDS_TL tl set
    FIELD_USER_NAME = nvl(X_FIELD_USER_NAME,
                                   FIELD_USER_NAME),
    SOURCE_LANG              = userenv('LANG'),
    LAST_UPDATE_DATE         = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY          = fnd_load_util.owner_id(X_OWNER) ,
    LAST_UPDATE_LOGIN        = 0
  where tl.PAGE_ID = X_PAGE_ID
  and tl.FIELD_ID = (select b.field_id from WMS_PAGE_FIELDS_B b where b.field_name = X_FIELD_NAME)
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 279


  X_LAST_UPDATE_DATE in DATE,
  X_FIELD_DISP_SEQUENCE_NUMBER in NUMBER,
  X_FIELD_PROMPT in VARCHAR2,
  X_FIELD_TYPE in VARCHAR2,
  X_FIELD_CONSTRUCTOR_PARAM in VARCHAR2,
  X_FIELD_CATEGORY in VARCHAR2,
  X_FIELD_IS_CONFIGURABLE in VARCHAR2,
  X_FIELD_IS_VISIBLE in VARCHAR2,
  X_FIELD_PROPERTY1_DEFAULT_VALU in NUMBER,
  X_FIELD_PROPERTY2_DEFAULT_VALU in NUMBER,
  X_FIELD_USER_NAME in VARCHAR2) is
begin

  declare
     l_field_id 	number := 0;

Line: 298


     select field_id into l_field_id
     from   WMS_PAGE_FIELDS_VL
     where  PAGE_ID = X_PAGE_ID AND FIELD_NAME = X_FIELD_NAME;

Line: 302


  WMS_PAGE_FIELDS_PKG.UPDATE_ROW(
    X_PAGE_ID => X_PAGE_ID,
    X_FIELD_ID => l_field_id,
    X_FIELD_NAME => X_FIELD_NAME,
    X_FIELD_DISP_SEQUENCE_NUMBER => X_FIELD_DISP_SEQUENCE_NUMBER,
    X_FIELD_PROMPT => X_FIELD_PROMPT,
    X_FIELD_TYPE => X_FIELD_TYPE,
    X_FIELD_CONSTRUCTOR_PARAM => X_FIELD_CONSTRUCTOR_PARAM,
    X_FIELD_CATEGORY => X_FIELD_CATEGORY,
    X_FIELD_IS_CONFIGURABLE => X_FIELD_IS_CONFIGURABLE,
    X_FIELD_IS_VISIBLE => X_FIELD_IS_VISIBLE,
    X_FIELD_PROPERTY1_DEFAULT_VALU => X_FIELD_PROPERTY1_DEFAULT_VALU,
    X_FIELD_PROPERTY2_DEFAULT_VALU => X_FIELD_PROPERTY2_DEFAULT_VALU,
    X_FIELD_USER_NAME => X_FIELD_USER_NAME,
    X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => user_id,
    X_LAST_UPDATE_LOGIN => 0);

Line: 323


       select WMS_PAGE_FIELDS_S.nextval into l_field_id from dual;

Line: 325


     WMS_PAGE_FIELDS_PKG.INSERT_ROW(
    X_ROWID => row_id,
    X_PAGE_ID => X_PAGE_ID,
    X_FIELD_ID => l_field_id,
    X_FIELD_NAME => X_FIELD_NAME,
    X_FIELD_DISP_SEQUENCE_NUMBER => X_FIELD_DISP_SEQUENCE_NUMBER,
    X_FIELD_PROMPT => X_FIELD_PROMPT,
    X_FIELD_TYPE => X_FIELD_TYPE,
    X_FIELD_CONSTRUCTOR_PARAM => X_FIELD_CONSTRUCTOR_PARAM,
    X_FIELD_CATEGORY => X_FIELD_CATEGORY,
    X_FIELD_IS_CONFIGURABLE => X_FIELD_IS_CONFIGURABLE,
    X_FIELD_IS_VISIBLE => X_FIELD_IS_VISIBLE,
    X_FIELD_PROPERTY1_DEFAULT_VALU => X_FIELD_PROPERTY1_DEFAULT_VALU,
    X_FIELD_PROPERTY2_DEFAULT_VALU => X_FIELD_PROPERTY2_DEFAULT_VALU,
    X_FIELD_USER_NAME => X_FIELD_USER_NAME,
    X_CREATION_DATE => X_LAST_UPDATE_DATE,
    X_CREATED_BY => user_id,
    X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => user_id,
    X_LAST_UPDATE_LOGIN => 0);

Line: 349


procedure DELETE_ROW (
  X_PAGE_ID in NUMBER,
  X_FIELD_ID in NUMBER
) is
begin
  delete from WMS_PAGE_FIELDS_TL
  where PAGE_ID = X_PAGE_ID
  and FIELD_ID = X_FIELD_ID;

Line: 362


  delete from WMS_PAGE_FIELDS_B
  where PAGE_ID = X_PAGE_ID
  and FIELD_ID = X_FIELD_ID;

Line: 369


end DELETE_ROW;

Line: 374


  delete from WMS_PAGE_FIELDS_TL T
  where not exists
    (select NULL
    from WMS_PAGE_FIELDS_B B
    where B.PAGE_ID = T.PAGE_ID
    and B.FIELD_ID = T.FIELD_ID
    );

Line: 382


  update WMS_PAGE_FIELDS_TL T set (
      FIELD_USER_NAME
    ) = (select
      B.FIELD_USER_NAME
    from WMS_PAGE_FIELDS_TL B
    where B.PAGE_ID = T.PAGE_ID
    and B.FIELD_ID = T.FIELD_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.PAGE_ID,
      T.FIELD_ID,
      T.LANGUAGE
  ) in (select
      SUBT.PAGE_ID,
      SUBT.FIELD_ID,
      SUBT.LANGUAGE
    from WMS_PAGE_FIELDS_TL SUBB, WMS_PAGE_FIELDS_TL SUBT
    where SUBB.PAGE_ID = SUBT.PAGE_ID
    and SUBB.FIELD_ID = SUBT.FIELD_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.FIELD_USER_NAME <> SUBT.FIELD_USER_NAME
      or (SUBB.FIELD_USER_NAME is null and SUBT.FIELD_USER_NAME is not null)
      or (SUBB.FIELD_USER_NAME is not null and SUBT.FIELD_USER_NAME is null)
  ));

Line: 407


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