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.ICX_CAT_CATEGORIES_PVT SQL Statements

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

Line: 4


procedure INSERT_ROW (
  X_RT_CATEGORY_ID in NUMBER,
  X_CATEGORY_NAME in VARCHAR2,
  X_UPPER_CATEGORY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_TYPE in NUMBER,
  X_KEY in VARCHAR2,
  X_TITLE in VARCHAR2,
  X_ITEM_COUNT in NUMBER,
  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,
  X_REQUEST_ID in NUMBER,
  X_PROGRAM_APPLICATION_ID in NUMBER,
  X_PROGRAM_ID in NUMBER,
  X_PROGRAM_UPDATE_DATE in DATE
) is
  cursor C is select ROWID from ICX_CAT_CATEGORIES_TL
    where RT_CATEGORY_ID = X_RT_CATEGORY_ID
    and LANGUAGE = userenv('LANG');

Line: 28


  insert into ICX_CAT_CATEGORIES_TL (
    RT_CATEGORY_ID,
    CATEGORY_NAME,
    UPPER_CATEGORY_NAME,
    DESCRIPTION,
    TYPE,
    KEY,
    UPPER_KEY,
    TITLE,
    ITEM_COUNT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_ID,
    PROGRAM_UPDATE_DATE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_RT_CATEGORY_ID,
    X_CATEGORY_NAME,
    upper(X_CATEGORY_NAME),
    X_DESCRIPTION,
    X_TYPE,
    X_KEY,
    upper(X_KEY),
    X_TITLE,
    X_ITEM_COUNT,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REQUEST_ID,
    X_PROGRAM_APPLICATION_ID,
    X_PROGRAM_ID,
    X_PROGRAM_UPDATE_DATE,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from ICX_CAT_CATEGORIES_TL T
    where T.RT_CATEGORY_ID = X_RT_CATEGORY_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 86


end INSERT_ROW;

Line: 100


  cursor c1 is select
      RT_CATEGORY_ID,
      CATEGORY_NAME,
      UPPER_CATEGORY_NAME,
      DESCRIPTION,
      TYPE,
      KEY,
      TITLE,
      ITEM_COUNT,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from ICX_CAT_CATEGORIES_TL
    where RT_CATEGORY_ID = X_RT_CATEGORY_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of RT_CATEGORY_ID nowait;

Line: 140


procedure UPDATE_ROW (
  X_RT_CATEGORY_ID in NUMBER,
  X_CATEGORY_NAME in VARCHAR2,
  X_UPPER_CATEGORY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_TYPE in NUMBER,
  X_KEY in VARCHAR2,
  X_TITLE in VARCHAR2,
  X_ITEM_COUNT in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_REQUEST_ID in NUMBER,
  X_PROGRAM_APPLICATION_ID in NUMBER,
  X_PROGRAM_ID in NUMBER,
  X_PROGRAM_UPDATE_DATE in DATE
) is
begin
  update ICX_CAT_CATEGORIES_TL set
    CATEGORY_NAME = X_CATEGORY_NAME,
    UPPER_CATEGORY_NAME = upper(X_CATEGORY_NAME),
    DESCRIPTION = X_DESCRIPTION,
    TYPE = X_TYPE,
    KEY = X_KEY,
    UPPER_KEY = upper(X_KEY),
    TITLE = X_TITLE,
    ITEM_COUNT = X_ITEM_COUNT,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    REQUEST_ID = X_REQUEST_ID,
    PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
    PROGRAM_ID = X_PROGRAM_ID,
    PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE,
    SOURCE_LANG = userenv('LANG')
  where RT_CATEGORY_ID = X_RT_CATEGORY_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 181


end UPDATE_ROW;

Line: 183


procedure DELETE_ROW (
  X_RT_CATEGORY_ID in NUMBER
) is
begin
  delete from ICX_CAT_CATEGORIES_TL
  where RT_CATEGORY_ID = X_RT_CATEGORY_ID;

Line: 194


end DELETE_ROW;

Line: 204


      X_LAST_UPDATE_DATE     IN VARCHAR2)
IS
BEGIN
  DECLARE
     F_LUBY     NUMBER; -- entity owner in file

Line: 209


     F_LUDATE   DATE; -- entity update in file

Line: 211


     DB_LUDATE  DATE; -- entity update in db

Line: 216


    F_LUDATE := NVL(TO_DATE(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), SYSDATE);

Line: 218


    SELECT LAST_UPDATED_BY,
           LAST_UPDATE_DATE
    INTO   DB_LUBY,
           DB_LUDATE
    FROM   ICX_CAT_CATEGORIES_TL
    WHERE  LANGUAGE = USERENV('LANG')
           AND RT_CATEGORY_ID = TO_NUMBER(X_RT_CATEGORY_ID); -- Update record, honoring customization mode.

Line: 235


      UPDATE ICX_CAT_CATEGORIES_TL
      SET    CATEGORY_NAME = X_CATEGORY_NAME,
             UPPER_CATEGORY_NAME = UPPER(X_CATEGORY_NAME),
             DESCRIPTION = X_DESCRIPTION,
             LAST_UPDATE_DATE = SYSDATE,
             LAST_UPDATED_BY = F_LUBY,
             LAST_UPDATE_LOGIN = 0,
             SOURCE_LANG = USERENV('LANG')
      WHERE  RT_CATEGORY_ID = TO_NUMBER(X_RT_CATEGORY_ID)
             AND USERENV('LANG') IN (LANGUAGE,
                                     SOURCE_LANG);

Line: 262


      X_LAST_UPDATE_DATE     IN VARCHAR2)
IS
BEGIN
  DECLARE
    ROW_ID     VARCHAR2(64);

Line: 268


     F_LUDATE   DATE; -- entity update in file

Line: 270


     DB_LUDATE  DATE; -- entity update in db

Line: 275


    F_LUDATE := NVL(TO_DATE(X_LAST_UPDATE_DATE,
                            'YYYY/MM/DD'),
                    SYSDATE);

Line: 279


    SELECT LAST_UPDATED_BY,
           LAST_UPDATE_DATE
    INTO   DB_LUBY,
           DB_LUDATE
    FROM   ICX_CAT_CATEGORIES_TL
    WHERE  LANGUAGE = USERENV('LANG')
           AND RT_CATEGORY_ID = TO_NUMBER(X_RT_CATEGORY_ID); -- Update record, honoring customization mode.

Line: 296


      ICX_CAT_CATEGORIES_PVT.UPDATE_ROW(X_RT_CATEGORY_ID => TO_NUMBER(X_RT_CATEGORY_ID),
                                        X_CATEGORY_NAME => X_CATEGORY_NAME,
                                        X_UPPER_CATEGORY_NAME => X_UPPER_CATEGORY_NAME,
                                        X_DESCRIPTION => X_DESCRIPTION,
                                        X_TYPE => TO_NUMBER(X_TYPE),
                                        X_KEY => X_KEY,
                                        X_TITLE => X_TITLE,
                                        X_ITEM_COUNT => TO_NUMBER(X_ITEM_COUNT),
                                        X_LAST_UPDATE_DATE => SYSDATE,
                                        X_LAST_UPDATED_BY => F_LUBY,
                                        X_LAST_UPDATE_LOGIN => 0,
                                        X_REQUEST_ID => NULL,
                                        X_PROGRAM_APPLICATION_ID => NULL,
                                        X_PROGRAM_ID => NULL,
                                        X_PROGRAM_UPDATE_DATE => NULL);

Line: 314


      ICX_CAT_CATEGORIES_PVT.INSERT_ROW(X_RT_CATEGORY_ID => TO_NUMBER(X_RT_CATEGORY_ID),
                                        X_CATEGORY_NAME => X_CATEGORY_NAME,
                                        X_UPPER_CATEGORY_NAME => X_UPPER_CATEGORY_NAME,
                                        X_DESCRIPTION => X_DESCRIPTION,
                                        X_TYPE => TO_NUMBER(X_TYPE),
                                        X_KEY => X_KEY,
                                        X_TITLE => X_TITLE,
                                        X_ITEM_COUNT => TO_NUMBER(X_ITEM_COUNT),
                                        X_CREATION_DATE => SYSDATE,
                                        X_CREATED_BY => F_LUBY,
                                        X_LAST_UPDATE_DATE => SYSDATE,
                                        X_LAST_UPDATED_BY => F_LUBY,
                                        X_LAST_UPDATE_LOGIN => 0,
                                        X_REQUEST_ID => NULL,
                                        X_PROGRAM_APPLICATION_ID => NULL,
                                        X_PROGRAM_ID => NULL,
                                        X_PROGRAM_UPDATE_DATE => NULL);

Line: 340


  insert into ICX_CAT_CATEGORIES_TL (
    RT_CATEGORY_ID,
    CATEGORY_NAME,
    UPPER_CATEGORY_NAME,
    DESCRIPTION,
    TYPE,
    KEY,
    UPPER_KEY,
    TITLE,
    ITEM_COUNT,
    SECTION_MAP,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_ID,
    PROGRAM_UPDATE_DATE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.RT_CATEGORY_ID,
    B.CATEGORY_NAME,
    upper(B.CATEGORY_NAME),
    B.DESCRIPTION,
    B.TYPE,
    B.KEY,
    upper(B.KEY),
    B.TITLE,
    B.ITEM_COUNT,
    B.SECTION_MAP,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.REQUEST_ID,
    B.PROGRAM_APPLICATION_ID,
    B.PROGRAM_ID,
    B.PROGRAM_UPDATE_DATE,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from ICX_CAT_CATEGORIES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from ICX_CAT_CATEGORIES_TL T
    where T.RT_CATEGORY_ID = B.RT_CATEGORY_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);