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.FEM_DIS_CST_CNTRS_HIER_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_OBJECT_ID in NUMBER,
  X_OBJECT_DEFINITION_ID in NUMBER,
  X_VALUE_SET_ID in NUMBER,
  X_LEVEL1_ID in NUMBER,
  X_LEVEL2_ID in NUMBER,
  X_LEVEL3_ID in NUMBER,
  X_LEVEL4_ID in NUMBER,
  X_LEVEL5_ID in NUMBER,
  X_LEVEL6_ID in NUMBER,
  X_LEVEL7_ID in NUMBER,
  X_LEVEL8_ID in NUMBER,
  X_LEVEL9_ID in NUMBER,
  X_LEVEL10_ID in NUMBER,
  X_LEVEL11_ID in NUMBER,
  X_LEVEL12_ID in NUMBER,
  X_LEVEL13_ID in NUMBER,
  X_LEVEL14_ID in NUMBER,
  X_LEVEL15_ID in NUMBER,
  X_LEVEL16_ID in NUMBER,
  X_LEVEL17_ID in NUMBER,
  X_LEVEL18_ID in NUMBER,
  X_LEVEL19_ID in NUMBER,
  X_LEVEL20_ID in NUMBER,
  X_LEVEL1_DISPLAY_CODE in VARCHAR2,
  X_LEVEL2_DISPLAY_CODE in VARCHAR2,
  X_LEVEL3_DISPLAY_CODE in VARCHAR2,
  X_LEVEL4_DISPLAY_CODE in VARCHAR2,
  X_LEVEL5_DISPLAY_CODE in VARCHAR2,
  X_LEVEL6_DISPLAY_CODE in VARCHAR2,
  X_LEVEL7_DISPLAY_CODE in VARCHAR2,
  X_LEVEL8_DISPLAY_CODE in VARCHAR2,
  X_LEVEL9_DISPLAY_CODE in VARCHAR2,
  X_LEVEL10_DISPLAY_CODE in VARCHAR2,
  X_LEVEL11_DISPLAY_CODE in VARCHAR2,
  X_LEVEL12_DISPLAY_CODE in VARCHAR2,
  X_LEVEL13_DISPLAY_CODE in VARCHAR2,
  X_LEVEL14_DISPLAY_CODE in VARCHAR2,
  X_LEVEL15_DISPLAY_CODE in VARCHAR2,
  X_LEVEL16_DISPLAY_CODE in VARCHAR2,
  X_LEVEL17_DISPLAY_CODE in VARCHAR2,
  X_LEVEL18_DISPLAY_CODE in VARCHAR2,
  X_LEVEL19_DISPLAY_CODE in VARCHAR2,
  X_LEVEL20_DISPLAY_CODE in VARCHAR2,
  X_LEVEL1_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL2_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL3_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL4_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL5_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL6_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL7_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL8_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL9_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL10_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL11_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL12_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL13_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL14_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL15_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL16_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL17_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL18_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL19_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL20_DISPLAY_ORDER_NUM in NUMBER,
  X_OBJECT_NAME in VARCHAR2,
  X_OBJECT_DEFINITION_NAME in VARCHAR2,
  X_LEVEL1_NAME in VARCHAR2,
  X_LEVEL2_NAME in VARCHAR2,
  X_LEVEL3_NAME in VARCHAR2,
  X_LEVEL4_NAME in VARCHAR2,
  X_LEVEL5_NAME in VARCHAR2,
  X_LEVEL6_NAME in VARCHAR2,
  X_LEVEL7_NAME in VARCHAR2,
  X_LEVEL8_NAME in VARCHAR2,
  X_LEVEL9_NAME in VARCHAR2,
  X_LEVEL10_NAME in VARCHAR2,
  X_LEVEL11_NAME in VARCHAR2,
  X_LEVEL12_NAME in VARCHAR2,
  X_LEVEL13_NAME in VARCHAR2,
  X_LEVEL14_NAME in VARCHAR2,
  X_LEVEL15_NAME in VARCHAR2,
  X_LEVEL16_NAME in VARCHAR2,
  X_LEVEL17_NAME in VARCHAR2,
  X_LEVEL18_NAME in VARCHAR2,
  X_LEVEL19_NAME in VARCHAR2,
  X_LEVEL20_NAME in VARCHAR2,
  X_LEVEL1_DESCRIPTION in VARCHAR2,
  X_LEVEL2_DESCRIPTION in VARCHAR2,
  X_LEVEL3_DESCRIPTION in VARCHAR2,
  X_LEVEL4_DESCRIPTION in VARCHAR2,
  X_LEVEL5_DESCRIPTION in VARCHAR2,
  X_LEVEL6_DESCRIPTION in VARCHAR2,
  X_LEVEL7_DESCRIPTION in VARCHAR2,
  X_LEVEL8_DESCRIPTION in VARCHAR2,
  X_LEVEL9_DESCRIPTION in VARCHAR2,
  X_LEVEL10_DESCRIPTION in VARCHAR2,
  X_LEVEL11_DESCRIPTION in VARCHAR2,
  X_LEVEL12_DESCRIPTION in VARCHAR2,
  X_LEVEL13_DESCRIPTION in VARCHAR2,
  X_LEVEL14_DESCRIPTION in VARCHAR2,
  X_LEVEL15_DESCRIPTION in VARCHAR2,
  X_LEVEL16_DESCRIPTION in VARCHAR2,
  X_LEVEL17_DESCRIPTION in VARCHAR2,
  X_LEVEL18_DESCRIPTION in VARCHAR2,
  X_LEVEL19_DESCRIPTION in VARCHAR2,
  X_LEVEL20_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 FEM_DIS_CST_CNTRS_HIER_B
    where OBJECT_ID = X_OBJECT_ID
    and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
    and VALUE_SET_ID = X_VALUE_SET_ID
    and LEVEL1_ID = X_LEVEL1_ID
    and LEVEL2_ID = X_LEVEL2_ID
    and LEVEL3_ID = X_LEVEL3_ID
    and LEVEL4_ID = X_LEVEL4_ID
    and LEVEL5_ID = X_LEVEL5_ID
    and LEVEL6_ID = X_LEVEL6_ID
    and LEVEL7_ID = X_LEVEL7_ID
    and LEVEL8_ID = X_LEVEL8_ID
    and LEVEL9_ID = X_LEVEL9_ID
    and LEVEL10_ID = X_LEVEL10_ID
    and LEVEL11_ID = X_LEVEL11_ID
    and LEVEL12_ID = X_LEVEL12_ID
    and LEVEL13_ID = X_LEVEL13_ID
    and LEVEL14_ID = X_LEVEL14_ID
    and LEVEL15_ID = X_LEVEL15_ID
    and LEVEL16_ID = X_LEVEL16_ID
    and LEVEL17_ID = X_LEVEL17_ID
    and LEVEL18_ID = X_LEVEL18_ID
    and LEVEL19_ID = X_LEVEL19_ID
    and LEVEL20_ID = X_LEVEL20_ID
    ;

Line: 142


  insert into FEM_DIS_CST_CNTRS_HIER_B (
    OBJECT_DEFINITION_ID,
    VALUE_SET_ID,
    LEVEL1_ID,
    LEVEL2_ID,
    LEVEL3_ID,
    LEVEL4_ID,
    LEVEL5_ID,
    LEVEL6_ID,
    LEVEL7_ID,
    LEVEL8_ID,
    LEVEL9_ID,
    LEVEL10_ID,
    LEVEL11_ID,
    LEVEL12_ID,
    LEVEL13_ID,
    LEVEL14_ID,
    LEVEL15_ID,
    LEVEL16_ID,
    LEVEL17_ID,
    LEVEL18_ID,
    LEVEL19_ID,
    LEVEL20_ID,
    LEVEL1_DISPLAY_CODE,
    LEVEL2_DISPLAY_CODE,
    LEVEL3_DISPLAY_CODE,
    LEVEL4_DISPLAY_CODE,
    LEVEL5_DISPLAY_CODE,
    LEVEL6_DISPLAY_CODE,
    LEVEL7_DISPLAY_CODE,
    LEVEL8_DISPLAY_CODE,
    LEVEL9_DISPLAY_CODE,
    LEVEL10_DISPLAY_CODE,
    LEVEL11_DISPLAY_CODE,
    LEVEL12_DISPLAY_CODE,
    LEVEL13_DISPLAY_CODE,
    LEVEL14_DISPLAY_CODE,
    LEVEL15_DISPLAY_CODE,
    LEVEL16_DISPLAY_CODE,
    LEVEL17_DISPLAY_CODE,
    LEVEL18_DISPLAY_CODE,
    LEVEL19_DISPLAY_CODE,
    LEVEL20_DISPLAY_CODE,
    LEVEL1_DISPLAY_ORDER_NUM,
    LEVEL2_DISPLAY_ORDER_NUM,
    LEVEL3_DISPLAY_ORDER_NUM,
    LEVEL4_DISPLAY_ORDER_NUM,
    LEVEL5_DISPLAY_ORDER_NUM,
    LEVEL6_DISPLAY_ORDER_NUM,
    LEVEL7_DISPLAY_ORDER_NUM,
    LEVEL8_DISPLAY_ORDER_NUM,
    LEVEL9_DISPLAY_ORDER_NUM,
    LEVEL10_DISPLAY_ORDER_NUM,
    LEVEL11_DISPLAY_ORDER_NUM,
    LEVEL12_DISPLAY_ORDER_NUM,
    LEVEL13_DISPLAY_ORDER_NUM,
    LEVEL14_DISPLAY_ORDER_NUM,
    LEVEL15_DISPLAY_ORDER_NUM,
    LEVEL16_DISPLAY_ORDER_NUM,
    LEVEL17_DISPLAY_ORDER_NUM,
    LEVEL18_DISPLAY_ORDER_NUM,
    LEVEL19_DISPLAY_ORDER_NUM,
    LEVEL20_DISPLAY_ORDER_NUM,
    OBJECT_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_OBJECT_DEFINITION_ID,
    X_VALUE_SET_ID,
    X_LEVEL1_ID,
    X_LEVEL2_ID,
    X_LEVEL3_ID,
    X_LEVEL4_ID,
    X_LEVEL5_ID,
    X_LEVEL6_ID,
    X_LEVEL7_ID,
    X_LEVEL8_ID,
    X_LEVEL9_ID,
    X_LEVEL10_ID,
    X_LEVEL11_ID,
    X_LEVEL12_ID,
    X_LEVEL13_ID,
    X_LEVEL14_ID,
    X_LEVEL15_ID,
    X_LEVEL16_ID,
    X_LEVEL17_ID,
    X_LEVEL18_ID,
    X_LEVEL19_ID,
    X_LEVEL20_ID,
    X_LEVEL1_DISPLAY_CODE,
    X_LEVEL2_DISPLAY_CODE,
    X_LEVEL3_DISPLAY_CODE,
    X_LEVEL4_DISPLAY_CODE,
    X_LEVEL5_DISPLAY_CODE,
    X_LEVEL6_DISPLAY_CODE,
    X_LEVEL7_DISPLAY_CODE,
    X_LEVEL8_DISPLAY_CODE,
    X_LEVEL9_DISPLAY_CODE,
    X_LEVEL10_DISPLAY_CODE,
    X_LEVEL11_DISPLAY_CODE,
    X_LEVEL12_DISPLAY_CODE,
    X_LEVEL13_DISPLAY_CODE,
    X_LEVEL14_DISPLAY_CODE,
    X_LEVEL15_DISPLAY_CODE,
    X_LEVEL16_DISPLAY_CODE,
    X_LEVEL17_DISPLAY_CODE,
    X_LEVEL18_DISPLAY_CODE,
    X_LEVEL19_DISPLAY_CODE,
    X_LEVEL20_DISPLAY_CODE,
    X_LEVEL1_DISPLAY_ORDER_NUM,
    X_LEVEL2_DISPLAY_ORDER_NUM,
    X_LEVEL3_DISPLAY_ORDER_NUM,
    X_LEVEL4_DISPLAY_ORDER_NUM,
    X_LEVEL5_DISPLAY_ORDER_NUM,
    X_LEVEL6_DISPLAY_ORDER_NUM,
    X_LEVEL7_DISPLAY_ORDER_NUM,
    X_LEVEL8_DISPLAY_ORDER_NUM,
    X_LEVEL9_DISPLAY_ORDER_NUM,
    X_LEVEL10_DISPLAY_ORDER_NUM,
    X_LEVEL11_DISPLAY_ORDER_NUM,
    X_LEVEL12_DISPLAY_ORDER_NUM,
    X_LEVEL13_DISPLAY_ORDER_NUM,
    X_LEVEL14_DISPLAY_ORDER_NUM,
    X_LEVEL15_DISPLAY_ORDER_NUM,
    X_LEVEL16_DISPLAY_ORDER_NUM,
    X_LEVEL17_DISPLAY_ORDER_NUM,
    X_LEVEL18_DISPLAY_ORDER_NUM,
    X_LEVEL19_DISPLAY_ORDER_NUM,
    X_LEVEL20_DISPLAY_ORDER_NUM,
    X_OBJECT_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 282


  insert into FEM_DIS_CST_CNTRS_HIER_TL (
    OBJECT_NAME,
    OBJECT_DEFINITION_NAME,
    LEVEL1_NAME,
    LEVEL2_NAME,
    LEVEL3_NAME,
    LEVEL4_NAME,
    LEVEL5_NAME,
    LEVEL6_NAME,
    LEVEL7_NAME,
    LEVEL8_NAME,
    LEVEL9_NAME,
    LEVEL10_NAME,
    LEVEL11_NAME,
    LEVEL12_NAME,
    LEVEL13_NAME,
    LEVEL14_NAME,
    LEVEL15_NAME,
    LEVEL16_NAME,
    LEVEL17_NAME,
    LEVEL18_NAME,
    LEVEL19_NAME,
    LEVEL20_NAME,
    LEVEL1_DESCRIPTION,
    LEVEL2_DESCRIPTION,
    LEVEL3_DESCRIPTION,
    LEVEL4_DESCRIPTION,
    LEVEL5_DESCRIPTION,
    LEVEL6_DESCRIPTION,
    LEVEL7_DESCRIPTION,
    LEVEL8_DESCRIPTION,
    LEVEL9_DESCRIPTION,
    LEVEL10_DESCRIPTION,
    LEVEL11_DESCRIPTION,
    LEVEL12_DESCRIPTION,
    LEVEL13_DESCRIPTION,
    LEVEL14_DESCRIPTION,
    LEVEL15_DESCRIPTION,
    LEVEL16_DESCRIPTION,
    LEVEL17_DESCRIPTION,
    LEVEL18_DESCRIPTION,
    LEVEL19_DESCRIPTION,
    LEVEL20_DESCRIPTION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_ID,
    OBJECT_DEFINITION_ID,
    VALUE_SET_ID,
    LEVEL1_ID,
    LEVEL2_ID,
    LEVEL3_ID,
    LEVEL4_ID,
    LEVEL5_ID,
    LEVEL6_ID,
    LEVEL7_ID,
    LEVEL8_ID,
    LEVEL9_ID,
    LEVEL10_ID,
    LEVEL11_ID,
    LEVEL12_ID,
    LEVEL13_ID,
    LEVEL14_ID,
    LEVEL15_ID,
    LEVEL16_ID,
    LEVEL17_ID,
    LEVEL18_ID,
    LEVEL19_ID,
    LEVEL20_ID,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_OBJECT_NAME,
    X_OBJECT_DEFINITION_NAME,
    X_LEVEL1_NAME,
    X_LEVEL2_NAME,
    X_LEVEL3_NAME,
    X_LEVEL4_NAME,
    X_LEVEL5_NAME,
    X_LEVEL6_NAME,
    X_LEVEL7_NAME,
    X_LEVEL8_NAME,
    X_LEVEL9_NAME,
    X_LEVEL10_NAME,
    X_LEVEL11_NAME,
    X_LEVEL12_NAME,
    X_LEVEL13_NAME,
    X_LEVEL14_NAME,
    X_LEVEL15_NAME,
    X_LEVEL16_NAME,
    X_LEVEL17_NAME,
    X_LEVEL18_NAME,
    X_LEVEL19_NAME,
    X_LEVEL20_NAME,
    X_LEVEL1_DESCRIPTION,
    X_LEVEL2_DESCRIPTION,
    X_LEVEL3_DESCRIPTION,
    X_LEVEL4_DESCRIPTION,
    X_LEVEL5_DESCRIPTION,
    X_LEVEL6_DESCRIPTION,
    X_LEVEL7_DESCRIPTION,
    X_LEVEL8_DESCRIPTION,
    X_LEVEL9_DESCRIPTION,
    X_LEVEL10_DESCRIPTION,
    X_LEVEL11_DESCRIPTION,
    X_LEVEL12_DESCRIPTION,
    X_LEVEL13_DESCRIPTION,
    X_LEVEL14_DESCRIPTION,
    X_LEVEL15_DESCRIPTION,
    X_LEVEL16_DESCRIPTION,
    X_LEVEL17_DESCRIPTION,
    X_LEVEL18_DESCRIPTION,
    X_LEVEL19_DESCRIPTION,
    X_LEVEL20_DESCRIPTION,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_OBJECT_ID,
    X_OBJECT_DEFINITION_ID,
    X_VALUE_SET_ID,
    X_LEVEL1_ID,
    X_LEVEL2_ID,
    X_LEVEL3_ID,
    X_LEVEL4_ID,
    X_LEVEL5_ID,
    X_LEVEL6_ID,
    X_LEVEL7_ID,
    X_LEVEL8_ID,
    X_LEVEL9_ID,
    X_LEVEL10_ID,
    X_LEVEL11_ID,
    X_LEVEL12_ID,
    X_LEVEL13_ID,
    X_LEVEL14_ID,
    X_LEVEL15_ID,
    X_LEVEL16_ID,
    X_LEVEL17_ID,
    X_LEVEL18_ID,
    X_LEVEL19_ID,
    X_LEVEL20_ID,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from FEM_DIS_CST_CNTRS_HIER_TL T
    where T.OBJECT_ID = X_OBJECT_ID
    and T.OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
    and T.VALUE_SET_ID = X_VALUE_SET_ID
    and T.LEVEL1_ID = X_LEVEL1_ID
    and T.LEVEL2_ID = X_LEVEL2_ID
    and T.LEVEL3_ID = X_LEVEL3_ID
    and T.LEVEL4_ID = X_LEVEL4_ID
    and T.LEVEL5_ID = X_LEVEL5_ID
    and T.LEVEL6_ID = X_LEVEL6_ID
    and T.LEVEL7_ID = X_LEVEL7_ID
    and T.LEVEL8_ID = X_LEVEL8_ID
    and T.LEVEL9_ID = X_LEVEL9_ID
    and T.LEVEL10_ID = X_LEVEL10_ID
    and T.LEVEL11_ID = X_LEVEL11_ID
    and T.LEVEL12_ID = X_LEVEL12_ID
    and T.LEVEL13_ID = X_LEVEL13_ID
    and T.LEVEL14_ID = X_LEVEL14_ID
    and T.LEVEL15_ID = X_LEVEL15_ID
    and T.LEVEL16_ID = X_LEVEL16_ID
    and T.LEVEL17_ID = X_LEVEL17_ID
    and T.LEVEL18_ID = X_LEVEL18_ID
    and T.LEVEL19_ID = X_LEVEL19_ID
    and T.LEVEL20_ID = X_LEVEL20_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 466


end INSERT_ROW;

Line: 575


  cursor c is select
      LEVEL1_DISPLAY_CODE,
      LEVEL2_DISPLAY_CODE,
      LEVEL3_DISPLAY_CODE,
      LEVEL4_DISPLAY_CODE,
      LEVEL5_DISPLAY_CODE,
      LEVEL6_DISPLAY_CODE,
      LEVEL7_DISPLAY_CODE,
      LEVEL8_DISPLAY_CODE,
      LEVEL9_DISPLAY_CODE,
      LEVEL10_DISPLAY_CODE,
      LEVEL11_DISPLAY_CODE,
      LEVEL12_DISPLAY_CODE,
      LEVEL13_DISPLAY_CODE,
      LEVEL14_DISPLAY_CODE,
      LEVEL15_DISPLAY_CODE,
      LEVEL16_DISPLAY_CODE,
      LEVEL17_DISPLAY_CODE,
      LEVEL18_DISPLAY_CODE,
      LEVEL19_DISPLAY_CODE,
      LEVEL20_DISPLAY_CODE,
      LEVEL1_DISPLAY_ORDER_NUM,
      LEVEL2_DISPLAY_ORDER_NUM,
      LEVEL3_DISPLAY_ORDER_NUM,
      LEVEL4_DISPLAY_ORDER_NUM,
      LEVEL5_DISPLAY_ORDER_NUM,
      LEVEL6_DISPLAY_ORDER_NUM,
      LEVEL7_DISPLAY_ORDER_NUM,
      LEVEL8_DISPLAY_ORDER_NUM,
      LEVEL9_DISPLAY_ORDER_NUM,
      LEVEL10_DISPLAY_ORDER_NUM,
      LEVEL11_DISPLAY_ORDER_NUM,
      LEVEL12_DISPLAY_ORDER_NUM,
      LEVEL13_DISPLAY_ORDER_NUM,
      LEVEL14_DISPLAY_ORDER_NUM,
      LEVEL15_DISPLAY_ORDER_NUM,
      LEVEL16_DISPLAY_ORDER_NUM,
      LEVEL17_DISPLAY_ORDER_NUM,
      LEVEL18_DISPLAY_ORDER_NUM,
      LEVEL19_DISPLAY_ORDER_NUM,
      LEVEL20_DISPLAY_ORDER_NUM
    from FEM_DIS_CST_CNTRS_HIER_B
    where OBJECT_ID = X_OBJECT_ID
    and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
    and VALUE_SET_ID = X_VALUE_SET_ID
    and LEVEL1_ID = X_LEVEL1_ID
    and LEVEL2_ID = X_LEVEL2_ID
    and LEVEL3_ID = X_LEVEL3_ID
    and LEVEL4_ID = X_LEVEL4_ID
    and LEVEL5_ID = X_LEVEL5_ID
    and LEVEL6_ID = X_LEVEL6_ID
    and LEVEL7_ID = X_LEVEL7_ID
    and LEVEL8_ID = X_LEVEL8_ID
    and LEVEL9_ID = X_LEVEL9_ID
    and LEVEL10_ID = X_LEVEL10_ID
    and LEVEL11_ID = X_LEVEL11_ID
    and LEVEL12_ID = X_LEVEL12_ID
    and LEVEL13_ID = X_LEVEL13_ID
    and LEVEL14_ID = X_LEVEL14_ID
    and LEVEL15_ID = X_LEVEL15_ID
    and LEVEL16_ID = X_LEVEL16_ID
    and LEVEL17_ID = X_LEVEL17_ID
    and LEVEL18_ID = X_LEVEL18_ID
    and LEVEL19_ID = X_LEVEL19_ID
    and LEVEL20_ID = X_LEVEL20_ID
    for update of OBJECT_ID nowait;

Line: 643


  cursor c1 is select
      OBJECT_NAME,
      OBJECT_DEFINITION_NAME,
      LEVEL1_NAME,
      LEVEL2_NAME,
      LEVEL3_NAME,
      LEVEL4_NAME,
      LEVEL5_NAME,
      LEVEL6_NAME,
      LEVEL7_NAME,
      LEVEL8_NAME,
      LEVEL9_NAME,
      LEVEL10_NAME,
      LEVEL11_NAME,
      LEVEL12_NAME,
      LEVEL13_NAME,
      LEVEL14_NAME,
      LEVEL15_NAME,
      LEVEL16_NAME,
      LEVEL17_NAME,
      LEVEL18_NAME,
      LEVEL19_NAME,
      LEVEL20_NAME,
      LEVEL1_DESCRIPTION,
      LEVEL2_DESCRIPTION,
      LEVEL3_DESCRIPTION,
      LEVEL4_DESCRIPTION,
      LEVEL5_DESCRIPTION,
      LEVEL6_DESCRIPTION,
      LEVEL7_DESCRIPTION,
      LEVEL8_DESCRIPTION,
      LEVEL9_DESCRIPTION,
      LEVEL10_DESCRIPTION,
      LEVEL11_DESCRIPTION,
      LEVEL12_DESCRIPTION,
      LEVEL13_DESCRIPTION,
      LEVEL14_DESCRIPTION,
      LEVEL15_DESCRIPTION,
      LEVEL16_DESCRIPTION,
      LEVEL17_DESCRIPTION,
      LEVEL18_DESCRIPTION,
      LEVEL19_DESCRIPTION,
      LEVEL20_DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from FEM_DIS_CST_CNTRS_HIER_TL
    where OBJECT_ID = X_OBJECT_ID
    and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
    and VALUE_SET_ID = X_VALUE_SET_ID
    and LEVEL1_ID = X_LEVEL1_ID
    and LEVEL2_ID = X_LEVEL2_ID
    and LEVEL3_ID = X_LEVEL3_ID
    and LEVEL4_ID = X_LEVEL4_ID
    and LEVEL5_ID = X_LEVEL5_ID
    and LEVEL6_ID = X_LEVEL6_ID
    and LEVEL7_ID = X_LEVEL7_ID
    and LEVEL8_ID = X_LEVEL8_ID
    and LEVEL9_ID = X_LEVEL9_ID
    and LEVEL10_ID = X_LEVEL10_ID
    and LEVEL11_ID = X_LEVEL11_ID
    and LEVEL12_ID = X_LEVEL12_ID
    and LEVEL13_ID = X_LEVEL13_ID
    and LEVEL14_ID = X_LEVEL14_ID
    and LEVEL15_ID = X_LEVEL15_ID
    and LEVEL16_ID = X_LEVEL16_ID
    and LEVEL17_ID = X_LEVEL17_ID
    and LEVEL18_ID = X_LEVEL18_ID
    and LEVEL19_ID = X_LEVEL19_ID
    and LEVEL20_ID = X_LEVEL20_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of OBJECT_ID nowait;

Line: 718


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

Line: 844


procedure UPDATE_ROW (
  X_OBJECT_ID in NUMBER,
  X_OBJECT_DEFINITION_ID in NUMBER,
  X_VALUE_SET_ID in NUMBER,
  X_LEVEL1_ID in NUMBER,
  X_LEVEL2_ID in NUMBER,
  X_LEVEL3_ID in NUMBER,
  X_LEVEL4_ID in NUMBER,
  X_LEVEL5_ID in NUMBER,
  X_LEVEL6_ID in NUMBER,
  X_LEVEL7_ID in NUMBER,
  X_LEVEL8_ID in NUMBER,
  X_LEVEL9_ID in NUMBER,
  X_LEVEL10_ID in NUMBER,
  X_LEVEL11_ID in NUMBER,
  X_LEVEL12_ID in NUMBER,
  X_LEVEL13_ID in NUMBER,
  X_LEVEL14_ID in NUMBER,
  X_LEVEL15_ID in NUMBER,
  X_LEVEL16_ID in NUMBER,
  X_LEVEL17_ID in NUMBER,
  X_LEVEL18_ID in NUMBER,
  X_LEVEL19_ID in NUMBER,
  X_LEVEL20_ID in NUMBER,
  X_LEVEL1_DISPLAY_CODE in VARCHAR2,
  X_LEVEL2_DISPLAY_CODE in VARCHAR2,
  X_LEVEL3_DISPLAY_CODE in VARCHAR2,
  X_LEVEL4_DISPLAY_CODE in VARCHAR2,
  X_LEVEL5_DISPLAY_CODE in VARCHAR2,
  X_LEVEL6_DISPLAY_CODE in VARCHAR2,
  X_LEVEL7_DISPLAY_CODE in VARCHAR2,
  X_LEVEL8_DISPLAY_CODE in VARCHAR2,
  X_LEVEL9_DISPLAY_CODE in VARCHAR2,
  X_LEVEL10_DISPLAY_CODE in VARCHAR2,
  X_LEVEL11_DISPLAY_CODE in VARCHAR2,
  X_LEVEL12_DISPLAY_CODE in VARCHAR2,
  X_LEVEL13_DISPLAY_CODE in VARCHAR2,
  X_LEVEL14_DISPLAY_CODE in VARCHAR2,
  X_LEVEL15_DISPLAY_CODE in VARCHAR2,
  X_LEVEL16_DISPLAY_CODE in VARCHAR2,
  X_LEVEL17_DISPLAY_CODE in VARCHAR2,
  X_LEVEL18_DISPLAY_CODE in VARCHAR2,
  X_LEVEL19_DISPLAY_CODE in VARCHAR2,
  X_LEVEL20_DISPLAY_CODE in VARCHAR2,
  X_LEVEL1_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL2_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL3_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL4_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL5_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL6_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL7_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL8_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL9_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL10_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL11_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL12_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL13_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL14_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL15_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL16_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL17_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL18_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL19_DISPLAY_ORDER_NUM in NUMBER,
  X_LEVEL20_DISPLAY_ORDER_NUM in NUMBER,
  X_OBJECT_NAME in VARCHAR2,
  X_OBJECT_DEFINITION_NAME in VARCHAR2,
  X_LEVEL1_NAME in VARCHAR2,
  X_LEVEL2_NAME in VARCHAR2,
  X_LEVEL3_NAME in VARCHAR2,
  X_LEVEL4_NAME in VARCHAR2,
  X_LEVEL5_NAME in VARCHAR2,
  X_LEVEL6_NAME in VARCHAR2,
  X_LEVEL7_NAME in VARCHAR2,
  X_LEVEL8_NAME in VARCHAR2,
  X_LEVEL9_NAME in VARCHAR2,
  X_LEVEL10_NAME in VARCHAR2,
  X_LEVEL11_NAME in VARCHAR2,
  X_LEVEL12_NAME in VARCHAR2,
  X_LEVEL13_NAME in VARCHAR2,
  X_LEVEL14_NAME in VARCHAR2,
  X_LEVEL15_NAME in VARCHAR2,
  X_LEVEL16_NAME in VARCHAR2,
  X_LEVEL17_NAME in VARCHAR2,
  X_LEVEL18_NAME in VARCHAR2,
  X_LEVEL19_NAME in VARCHAR2,
  X_LEVEL20_NAME in VARCHAR2,
  X_LEVEL1_DESCRIPTION in VARCHAR2,
  X_LEVEL2_DESCRIPTION in VARCHAR2,
  X_LEVEL3_DESCRIPTION in VARCHAR2,
  X_LEVEL4_DESCRIPTION in VARCHAR2,
  X_LEVEL5_DESCRIPTION in VARCHAR2,
  X_LEVEL6_DESCRIPTION in VARCHAR2,
  X_LEVEL7_DESCRIPTION in VARCHAR2,
  X_LEVEL8_DESCRIPTION in VARCHAR2,
  X_LEVEL9_DESCRIPTION in VARCHAR2,
  X_LEVEL10_DESCRIPTION in VARCHAR2,
  X_LEVEL11_DESCRIPTION in VARCHAR2,
  X_LEVEL12_DESCRIPTION in VARCHAR2,
  X_LEVEL13_DESCRIPTION in VARCHAR2,
  X_LEVEL14_DESCRIPTION in VARCHAR2,
  X_LEVEL15_DESCRIPTION in VARCHAR2,
  X_LEVEL16_DESCRIPTION in VARCHAR2,
  X_LEVEL17_DESCRIPTION in VARCHAR2,
  X_LEVEL18_DESCRIPTION in VARCHAR2,
  X_LEVEL19_DESCRIPTION in VARCHAR2,
  X_LEVEL20_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update FEM_DIS_CST_CNTRS_HIER_B set
    LEVEL1_DISPLAY_CODE = X_LEVEL1_DISPLAY_CODE,
    LEVEL2_DISPLAY_CODE = X_LEVEL2_DISPLAY_CODE,
    LEVEL3_DISPLAY_CODE = X_LEVEL3_DISPLAY_CODE,
    LEVEL4_DISPLAY_CODE = X_LEVEL4_DISPLAY_CODE,
    LEVEL5_DISPLAY_CODE = X_LEVEL5_DISPLAY_CODE,
    LEVEL6_DISPLAY_CODE = X_LEVEL6_DISPLAY_CODE,
    LEVEL7_DISPLAY_CODE = X_LEVEL7_DISPLAY_CODE,
    LEVEL8_DISPLAY_CODE = X_LEVEL8_DISPLAY_CODE,
    LEVEL9_DISPLAY_CODE = X_LEVEL9_DISPLAY_CODE,
    LEVEL10_DISPLAY_CODE = X_LEVEL10_DISPLAY_CODE,
    LEVEL11_DISPLAY_CODE = X_LEVEL11_DISPLAY_CODE,
    LEVEL12_DISPLAY_CODE = X_LEVEL12_DISPLAY_CODE,
    LEVEL13_DISPLAY_CODE = X_LEVEL13_DISPLAY_CODE,
    LEVEL14_DISPLAY_CODE = X_LEVEL14_DISPLAY_CODE,
    LEVEL15_DISPLAY_CODE = X_LEVEL15_DISPLAY_CODE,
    LEVEL16_DISPLAY_CODE = X_LEVEL16_DISPLAY_CODE,
    LEVEL17_DISPLAY_CODE = X_LEVEL17_DISPLAY_CODE,
    LEVEL18_DISPLAY_CODE = X_LEVEL18_DISPLAY_CODE,
    LEVEL19_DISPLAY_CODE = X_LEVEL19_DISPLAY_CODE,
    LEVEL20_DISPLAY_CODE = X_LEVEL20_DISPLAY_CODE,
    LEVEL1_DISPLAY_ORDER_NUM = X_LEVEL1_DISPLAY_ORDER_NUM,
    LEVEL2_DISPLAY_ORDER_NUM = X_LEVEL2_DISPLAY_ORDER_NUM,
    LEVEL3_DISPLAY_ORDER_NUM = X_LEVEL3_DISPLAY_ORDER_NUM,
    LEVEL4_DISPLAY_ORDER_NUM = X_LEVEL4_DISPLAY_ORDER_NUM,
    LEVEL5_DISPLAY_ORDER_NUM = X_LEVEL5_DISPLAY_ORDER_NUM,
    LEVEL6_DISPLAY_ORDER_NUM = X_LEVEL6_DISPLAY_ORDER_NUM,
    LEVEL7_DISPLAY_ORDER_NUM = X_LEVEL7_DISPLAY_ORDER_NUM,
    LEVEL8_DISPLAY_ORDER_NUM = X_LEVEL8_DISPLAY_ORDER_NUM,
    LEVEL9_DISPLAY_ORDER_NUM = X_LEVEL9_DISPLAY_ORDER_NUM,
    LEVEL10_DISPLAY_ORDER_NUM = X_LEVEL10_DISPLAY_ORDER_NUM,
    LEVEL11_DISPLAY_ORDER_NUM = X_LEVEL11_DISPLAY_ORDER_NUM,
    LEVEL12_DISPLAY_ORDER_NUM = X_LEVEL12_DISPLAY_ORDER_NUM,
    LEVEL13_DISPLAY_ORDER_NUM = X_LEVEL13_DISPLAY_ORDER_NUM,
    LEVEL14_DISPLAY_ORDER_NUM = X_LEVEL14_DISPLAY_ORDER_NUM,
    LEVEL15_DISPLAY_ORDER_NUM = X_LEVEL15_DISPLAY_ORDER_NUM,
    LEVEL16_DISPLAY_ORDER_NUM = X_LEVEL16_DISPLAY_ORDER_NUM,
    LEVEL17_DISPLAY_ORDER_NUM = X_LEVEL17_DISPLAY_ORDER_NUM,
    LEVEL18_DISPLAY_ORDER_NUM = X_LEVEL18_DISPLAY_ORDER_NUM,
    LEVEL19_DISPLAY_ORDER_NUM = X_LEVEL19_DISPLAY_ORDER_NUM,
    LEVEL20_DISPLAY_ORDER_NUM = X_LEVEL20_DISPLAY_ORDER_NUM,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where OBJECT_ID = X_OBJECT_ID
  and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
  and VALUE_SET_ID = X_VALUE_SET_ID
  and LEVEL1_ID = X_LEVEL1_ID
  and LEVEL2_ID = X_LEVEL2_ID
  and LEVEL3_ID = X_LEVEL3_ID
  and LEVEL4_ID = X_LEVEL4_ID
  and LEVEL5_ID = X_LEVEL5_ID
  and LEVEL6_ID = X_LEVEL6_ID
  and LEVEL7_ID = X_LEVEL7_ID
  and LEVEL8_ID = X_LEVEL8_ID
  and LEVEL9_ID = X_LEVEL9_ID
  and LEVEL10_ID = X_LEVEL10_ID
  and LEVEL11_ID = X_LEVEL11_ID
  and LEVEL12_ID = X_LEVEL12_ID
  and LEVEL13_ID = X_LEVEL13_ID
  and LEVEL14_ID = X_LEVEL14_ID
  and LEVEL15_ID = X_LEVEL15_ID
  and LEVEL16_ID = X_LEVEL16_ID
  and LEVEL17_ID = X_LEVEL17_ID
  and LEVEL18_ID = X_LEVEL18_ID
  and LEVEL19_ID = X_LEVEL19_ID
  and LEVEL20_ID = X_LEVEL20_ID;

Line: 1027


  update FEM_DIS_CST_CNTRS_HIER_TL set
    OBJECT_NAME = X_OBJECT_NAME,
    OBJECT_DEFINITION_NAME = X_OBJECT_DEFINITION_NAME,
    LEVEL1_NAME = X_LEVEL1_NAME,
    LEVEL2_NAME = X_LEVEL2_NAME,
    LEVEL3_NAME = X_LEVEL3_NAME,
    LEVEL4_NAME = X_LEVEL4_NAME,
    LEVEL5_NAME = X_LEVEL5_NAME,
    LEVEL6_NAME = X_LEVEL6_NAME,
    LEVEL7_NAME = X_LEVEL7_NAME,
    LEVEL8_NAME = X_LEVEL8_NAME,
    LEVEL9_NAME = X_LEVEL9_NAME,
    LEVEL10_NAME = X_LEVEL10_NAME,
    LEVEL11_NAME = X_LEVEL11_NAME,
    LEVEL12_NAME = X_LEVEL12_NAME,
    LEVEL13_NAME = X_LEVEL13_NAME,
    LEVEL14_NAME = X_LEVEL14_NAME,
    LEVEL15_NAME = X_LEVEL15_NAME,
    LEVEL16_NAME = X_LEVEL16_NAME,
    LEVEL17_NAME = X_LEVEL17_NAME,
    LEVEL18_NAME = X_LEVEL18_NAME,
    LEVEL19_NAME = X_LEVEL19_NAME,
    LEVEL20_NAME = X_LEVEL20_NAME,
    LEVEL1_DESCRIPTION = X_LEVEL1_DESCRIPTION,
    LEVEL2_DESCRIPTION = X_LEVEL2_DESCRIPTION,
    LEVEL3_DESCRIPTION = X_LEVEL3_DESCRIPTION,
    LEVEL4_DESCRIPTION = X_LEVEL4_DESCRIPTION,
    LEVEL5_DESCRIPTION = X_LEVEL5_DESCRIPTION,
    LEVEL6_DESCRIPTION = X_LEVEL6_DESCRIPTION,
    LEVEL7_DESCRIPTION = X_LEVEL7_DESCRIPTION,
    LEVEL8_DESCRIPTION = X_LEVEL8_DESCRIPTION,
    LEVEL9_DESCRIPTION = X_LEVEL9_DESCRIPTION,
    LEVEL10_DESCRIPTION = X_LEVEL10_DESCRIPTION,
    LEVEL11_DESCRIPTION = X_LEVEL11_DESCRIPTION,
    LEVEL12_DESCRIPTION = X_LEVEL12_DESCRIPTION,
    LEVEL13_DESCRIPTION = X_LEVEL13_DESCRIPTION,
    LEVEL14_DESCRIPTION = X_LEVEL14_DESCRIPTION,
    LEVEL15_DESCRIPTION = X_LEVEL15_DESCRIPTION,
    LEVEL16_DESCRIPTION = X_LEVEL16_DESCRIPTION,
    LEVEL17_DESCRIPTION = X_LEVEL17_DESCRIPTION,
    LEVEL18_DESCRIPTION = X_LEVEL18_DESCRIPTION,
    LEVEL19_DESCRIPTION = X_LEVEL19_DESCRIPTION,
    LEVEL20_DESCRIPTION = X_LEVEL20_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 OBJECT_ID = X_OBJECT_ID
  and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
  and VALUE_SET_ID = X_VALUE_SET_ID
  and LEVEL1_ID = X_LEVEL1_ID
  and LEVEL2_ID = X_LEVEL2_ID
  and LEVEL3_ID = X_LEVEL3_ID
  and LEVEL4_ID = X_LEVEL4_ID
  and LEVEL5_ID = X_LEVEL5_ID
  and LEVEL6_ID = X_LEVEL6_ID
  and LEVEL7_ID = X_LEVEL7_ID
  and LEVEL8_ID = X_LEVEL8_ID
  and LEVEL9_ID = X_LEVEL9_ID
  and LEVEL10_ID = X_LEVEL10_ID
  and LEVEL11_ID = X_LEVEL11_ID
  and LEVEL12_ID = X_LEVEL12_ID
  and LEVEL13_ID = X_LEVEL13_ID
  and LEVEL14_ID = X_LEVEL14_ID
  and LEVEL15_ID = X_LEVEL15_ID
  and LEVEL16_ID = X_LEVEL16_ID
  and LEVEL17_ID = X_LEVEL17_ID
  and LEVEL18_ID = X_LEVEL18_ID
  and LEVEL19_ID = X_LEVEL19_ID
  and LEVEL20_ID = X_LEVEL20_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 1102


end UPDATE_ROW;

Line: 1104


procedure DELETE_ROW (
  X_OBJECT_ID in NUMBER,
  X_OBJECT_DEFINITION_ID in NUMBER,
  X_VALUE_SET_ID in NUMBER,
  X_LEVEL1_ID in NUMBER,
  X_LEVEL2_ID in NUMBER,
  X_LEVEL3_ID in NUMBER,
  X_LEVEL4_ID in NUMBER,
  X_LEVEL5_ID in NUMBER,
  X_LEVEL6_ID in NUMBER,
  X_LEVEL7_ID in NUMBER,
  X_LEVEL8_ID in NUMBER,
  X_LEVEL9_ID in NUMBER,
  X_LEVEL10_ID in NUMBER,
  X_LEVEL11_ID in NUMBER,
  X_LEVEL12_ID in NUMBER,
  X_LEVEL13_ID in NUMBER,
  X_LEVEL14_ID in NUMBER,
  X_LEVEL15_ID in NUMBER,
  X_LEVEL16_ID in NUMBER,
  X_LEVEL17_ID in NUMBER,
  X_LEVEL18_ID in NUMBER,
  X_LEVEL19_ID in NUMBER,
  X_LEVEL20_ID in NUMBER
) is
begin
  delete from FEM_DIS_CST_CNTRS_HIER_TL
  where OBJECT_ID = X_OBJECT_ID
  and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
  and VALUE_SET_ID = X_VALUE_SET_ID
  and LEVEL1_ID = X_LEVEL1_ID
  and LEVEL2_ID = X_LEVEL2_ID
  and LEVEL3_ID = X_LEVEL3_ID
  and LEVEL4_ID = X_LEVEL4_ID
  and LEVEL5_ID = X_LEVEL5_ID
  and LEVEL6_ID = X_LEVEL6_ID
  and LEVEL7_ID = X_LEVEL7_ID
  and LEVEL8_ID = X_LEVEL8_ID
  and LEVEL9_ID = X_LEVEL9_ID
  and LEVEL10_ID = X_LEVEL10_ID
  and LEVEL11_ID = X_LEVEL11_ID
  and LEVEL12_ID = X_LEVEL12_ID
  and LEVEL13_ID = X_LEVEL13_ID
  and LEVEL14_ID = X_LEVEL14_ID
  and LEVEL15_ID = X_LEVEL15_ID
  and LEVEL16_ID = X_LEVEL16_ID
  and LEVEL17_ID = X_LEVEL17_ID
  and LEVEL18_ID = X_LEVEL18_ID
  and LEVEL19_ID = X_LEVEL19_ID
  and LEVEL20_ID = X_LEVEL20_ID;

Line: 1159


  delete from FEM_DIS_CST_CNTRS_HIER_B
  where OBJECT_ID = X_OBJECT_ID
  and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
  and VALUE_SET_ID = X_VALUE_SET_ID
  and LEVEL1_ID = X_LEVEL1_ID
  and LEVEL2_ID = X_LEVEL2_ID
  and LEVEL3_ID = X_LEVEL3_ID
  and LEVEL4_ID = X_LEVEL4_ID
  and LEVEL5_ID = X_LEVEL5_ID
  and LEVEL6_ID = X_LEVEL6_ID
  and LEVEL7_ID = X_LEVEL7_ID
  and LEVEL8_ID = X_LEVEL8_ID
  and LEVEL9_ID = X_LEVEL9_ID
  and LEVEL10_ID = X_LEVEL10_ID
  and LEVEL11_ID = X_LEVEL11_ID
  and LEVEL12_ID = X_LEVEL12_ID
  and LEVEL13_ID = X_LEVEL13_ID
  and LEVEL14_ID = X_LEVEL14_ID
  and LEVEL15_ID = X_LEVEL15_ID
  and LEVEL16_ID = X_LEVEL16_ID
  and LEVEL17_ID = X_LEVEL17_ID
  and LEVEL18_ID = X_LEVEL18_ID
  and LEVEL19_ID = X_LEVEL19_ID
  and LEVEL20_ID = X_LEVEL20_ID;

Line: 1187


end DELETE_ROW;

Line: 1192


  delete from FEM_DIS_CST_CNTRS_HIER_TL T
  where not exists
    (select NULL
    from FEM_DIS_CST_CNTRS_HIER_B B
    where B.OBJECT_ID = T.OBJECT_ID
    and B.OBJECT_DEFINITION_ID = T.OBJECT_DEFINITION_ID
    and B.VALUE_SET_ID = T.VALUE_SET_ID
    and B.LEVEL1_ID = T.LEVEL1_ID
    and B.LEVEL2_ID = T.LEVEL2_ID
    and B.LEVEL3_ID = T.LEVEL3_ID
    and B.LEVEL4_ID = T.LEVEL4_ID
    and B.LEVEL5_ID = T.LEVEL5_ID
    and B.LEVEL6_ID = T.LEVEL6_ID
    and B.LEVEL7_ID = T.LEVEL7_ID
    and B.LEVEL8_ID = T.LEVEL8_ID
    and B.LEVEL9_ID = T.LEVEL9_ID
    and B.LEVEL10_ID = T.LEVEL10_ID
    and B.LEVEL11_ID = T.LEVEL11_ID
    and B.LEVEL12_ID = T.LEVEL12_ID
    and B.LEVEL13_ID = T.LEVEL13_ID
    and B.LEVEL14_ID = T.LEVEL14_ID
    and B.LEVEL15_ID = T.LEVEL15_ID
    and B.LEVEL16_ID = T.LEVEL16_ID
    and B.LEVEL17_ID = T.LEVEL17_ID
    and B.LEVEL18_ID = T.LEVEL18_ID
    and B.LEVEL19_ID = T.LEVEL19_ID
    and B.LEVEL20_ID = T.LEVEL20_ID
    );

Line: 1221


  update FEM_DIS_CST_CNTRS_HIER_TL T set (
      OBJECT_NAME,
      OBJECT_DEFINITION_NAME,
      LEVEL1_NAME,
      LEVEL2_NAME,
      LEVEL3_NAME,
      LEVEL4_NAME,
      LEVEL5_NAME,
      LEVEL6_NAME,
      LEVEL7_NAME,
      LEVEL8_NAME,
      LEVEL9_NAME,
      LEVEL10_NAME,
      LEVEL11_NAME,
      LEVEL12_NAME,
      LEVEL13_NAME,
      LEVEL14_NAME,
      LEVEL15_NAME,
      LEVEL16_NAME,
      LEVEL17_NAME,
      LEVEL18_NAME,
      LEVEL19_NAME,
      LEVEL20_NAME,
      LEVEL1_DESCRIPTION,
      LEVEL2_DESCRIPTION,
      LEVEL3_DESCRIPTION,
      LEVEL4_DESCRIPTION,
      LEVEL5_DESCRIPTION,
      LEVEL6_DESCRIPTION,
      LEVEL7_DESCRIPTION,
      LEVEL8_DESCRIPTION,
      LEVEL9_DESCRIPTION,
      LEVEL10_DESCRIPTION,
      LEVEL11_DESCRIPTION,
      LEVEL12_DESCRIPTION,
      LEVEL13_DESCRIPTION,
      LEVEL14_DESCRIPTION,
      LEVEL15_DESCRIPTION,
      LEVEL16_DESCRIPTION,
      LEVEL17_DESCRIPTION,
      LEVEL18_DESCRIPTION,
      LEVEL19_DESCRIPTION,
      LEVEL20_DESCRIPTION
    ) = (select
      B.OBJECT_NAME,
      B.OBJECT_DEFINITION_NAME,
      B.LEVEL1_NAME,
      B.LEVEL2_NAME,
      B.LEVEL3_NAME,
      B.LEVEL4_NAME,
      B.LEVEL5_NAME,
      B.LEVEL6_NAME,
      B.LEVEL7_NAME,
      B.LEVEL8_NAME,
      B.LEVEL9_NAME,
      B.LEVEL10_NAME,
      B.LEVEL11_NAME,
      B.LEVEL12_NAME,
      B.LEVEL13_NAME,
      B.LEVEL14_NAME,
      B.LEVEL15_NAME,
      B.LEVEL16_NAME,
      B.LEVEL17_NAME,
      B.LEVEL18_NAME,
      B.LEVEL19_NAME,
      B.LEVEL20_NAME,
      B.LEVEL1_DESCRIPTION,
      B.LEVEL2_DESCRIPTION,
      B.LEVEL3_DESCRIPTION,
      B.LEVEL4_DESCRIPTION,
      B.LEVEL5_DESCRIPTION,
      B.LEVEL6_DESCRIPTION,
      B.LEVEL7_DESCRIPTION,
      B.LEVEL8_DESCRIPTION,
      B.LEVEL9_DESCRIPTION,
      B.LEVEL10_DESCRIPTION,
      B.LEVEL11_DESCRIPTION,
      B.LEVEL12_DESCRIPTION,
      B.LEVEL13_DESCRIPTION,
      B.LEVEL14_DESCRIPTION,
      B.LEVEL15_DESCRIPTION,
      B.LEVEL16_DESCRIPTION,
      B.LEVEL17_DESCRIPTION,
      B.LEVEL18_DESCRIPTION,
      B.LEVEL19_DESCRIPTION,
      B.LEVEL20_DESCRIPTION
    from FEM_DIS_CST_CNTRS_HIER_TL B
    where B.OBJECT_ID = T.OBJECT_ID
    and B.OBJECT_DEFINITION_ID = T.OBJECT_DEFINITION_ID
    and B.VALUE_SET_ID = T.VALUE_SET_ID
    and B.LEVEL1_ID = T.LEVEL1_ID
    and B.LEVEL2_ID = T.LEVEL2_ID
    and B.LEVEL3_ID = T.LEVEL3_ID
    and B.LEVEL4_ID = T.LEVEL4_ID
    and B.LEVEL5_ID = T.LEVEL5_ID
    and B.LEVEL6_ID = T.LEVEL6_ID
    and B.LEVEL7_ID = T.LEVEL7_ID
    and B.LEVEL8_ID = T.LEVEL8_ID
    and B.LEVEL9_ID = T.LEVEL9_ID
    and B.LEVEL10_ID = T.LEVEL10_ID
    and B.LEVEL11_ID = T.LEVEL11_ID
    and B.LEVEL12_ID = T.LEVEL12_ID
    and B.LEVEL13_ID = T.LEVEL13_ID
    and B.LEVEL14_ID = T.LEVEL14_ID
    and B.LEVEL15_ID = T.LEVEL15_ID
    and B.LEVEL16_ID = T.LEVEL16_ID
    and B.LEVEL17_ID = T.LEVEL17_ID
    and B.LEVEL18_ID = T.LEVEL18_ID
    and B.LEVEL19_ID = T.LEVEL19_ID
    and B.LEVEL20_ID = T.LEVEL20_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.OBJECT_ID,
      T.OBJECT_DEFINITION_ID,
      T.VALUE_SET_ID,
      T.LEVEL1_ID,
      T.LEVEL2_ID,
      T.LEVEL3_ID,
      T.LEVEL4_ID,
      T.LEVEL5_ID,
      T.LEVEL6_ID,
      T.LEVEL7_ID,
      T.LEVEL8_ID,
      T.LEVEL9_ID,
      T.LEVEL10_ID,
      T.LEVEL11_ID,
      T.LEVEL12_ID,
      T.LEVEL13_ID,
      T.LEVEL14_ID,
      T.LEVEL15_ID,
      T.LEVEL16_ID,
      T.LEVEL17_ID,
      T.LEVEL18_ID,
      T.LEVEL19_ID,
      T.LEVEL20_ID,
      T.LANGUAGE
  ) in (select
      SUBT.OBJECT_ID,
      SUBT.OBJECT_DEFINITION_ID,
      SUBT.VALUE_SET_ID,
      SUBT.LEVEL1_ID,
      SUBT.LEVEL2_ID,
      SUBT.LEVEL3_ID,
      SUBT.LEVEL4_ID,
      SUBT.LEVEL5_ID,
      SUBT.LEVEL6_ID,
      SUBT.LEVEL7_ID,
      SUBT.LEVEL8_ID,
      SUBT.LEVEL9_ID,
      SUBT.LEVEL10_ID,
      SUBT.LEVEL11_ID,
      SUBT.LEVEL12_ID,
      SUBT.LEVEL13_ID,
      SUBT.LEVEL14_ID,
      SUBT.LEVEL15_ID,
      SUBT.LEVEL16_ID,
      SUBT.LEVEL17_ID,
      SUBT.LEVEL18_ID,
      SUBT.LEVEL19_ID,
      SUBT.LEVEL20_ID,
      SUBT.LANGUAGE
    from FEM_DIS_CST_CNTRS_HIER_TL SUBB, FEM_DIS_CST_CNTRS_HIER_TL SUBT
    where SUBB.OBJECT_ID = SUBT.OBJECT_ID
    and SUBB.OBJECT_DEFINITION_ID = SUBT.OBJECT_DEFINITION_ID
    and SUBB.VALUE_SET_ID = SUBT.VALUE_SET_ID
    and SUBB.LEVEL1_ID = SUBT.LEVEL1_ID
    and SUBB.LEVEL2_ID = SUBT.LEVEL2_ID
    and SUBB.LEVEL3_ID = SUBT.LEVEL3_ID
    and SUBB.LEVEL4_ID = SUBT.LEVEL4_ID
    and SUBB.LEVEL5_ID = SUBT.LEVEL5_ID
    and SUBB.LEVEL6_ID = SUBT.LEVEL6_ID
    and SUBB.LEVEL7_ID = SUBT.LEVEL7_ID
    and SUBB.LEVEL8_ID = SUBT.LEVEL8_ID
    and SUBB.LEVEL9_ID = SUBT.LEVEL9_ID
    and SUBB.LEVEL10_ID = SUBT.LEVEL10_ID
    and SUBB.LEVEL11_ID = SUBT.LEVEL11_ID
    and SUBB.LEVEL12_ID = SUBT.LEVEL12_ID
    and SUBB.LEVEL13_ID = SUBT.LEVEL13_ID
    and SUBB.LEVEL14_ID = SUBT.LEVEL14_ID
    and SUBB.LEVEL15_ID = SUBT.LEVEL15_ID
    and SUBB.LEVEL16_ID = SUBT.LEVEL16_ID
    and SUBB.LEVEL17_ID = SUBT.LEVEL17_ID
    and SUBB.LEVEL18_ID = SUBT.LEVEL18_ID
    and SUBB.LEVEL19_ID = SUBT.LEVEL19_ID
    and SUBB.LEVEL20_ID = SUBT.LEVEL20_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.OBJECT_NAME <> SUBT.OBJECT_NAME
      or SUBB.OBJECT_DEFINITION_NAME <> SUBT.OBJECT_DEFINITION_NAME
      or SUBB.LEVEL1_NAME <> SUBT.LEVEL1_NAME
      or SUBB.LEVEL2_NAME <> SUBT.LEVEL2_NAME
      or SUBB.LEVEL3_NAME <> SUBT.LEVEL3_NAME
      or SUBB.LEVEL4_NAME <> SUBT.LEVEL4_NAME
      or SUBB.LEVEL5_NAME <> SUBT.LEVEL5_NAME
      or SUBB.LEVEL6_NAME <> SUBT.LEVEL6_NAME
      or SUBB.LEVEL7_NAME <> SUBT.LEVEL7_NAME
      or SUBB.LEVEL8_NAME <> SUBT.LEVEL8_NAME
      or SUBB.LEVEL9_NAME <> SUBT.LEVEL9_NAME
      or SUBB.LEVEL10_NAME <> SUBT.LEVEL10_NAME
      or SUBB.LEVEL11_NAME <> SUBT.LEVEL11_NAME
      or SUBB.LEVEL12_NAME <> SUBT.LEVEL12_NAME
      or SUBB.LEVEL13_NAME <> SUBT.LEVEL13_NAME
      or SUBB.LEVEL14_NAME <> SUBT.LEVEL14_NAME
      or SUBB.LEVEL15_NAME <> SUBT.LEVEL15_NAME
      or SUBB.LEVEL16_NAME <> SUBT.LEVEL16_NAME
      or SUBB.LEVEL17_NAME <> SUBT.LEVEL17_NAME
      or SUBB.LEVEL18_NAME <> SUBT.LEVEL18_NAME
      or SUBB.LEVEL19_NAME <> SUBT.LEVEL19_NAME
      or SUBB.LEVEL20_NAME <> SUBT.LEVEL20_NAME
      or SUBB.LEVEL1_DESCRIPTION <> SUBT.LEVEL1_DESCRIPTION
      or (SUBB.LEVEL1_DESCRIPTION is null and SUBT.LEVEL1_DESCRIPTION is not null)
      or (SUBB.LEVEL1_DESCRIPTION is not null and SUBT.LEVEL1_DESCRIPTION is null)
      or SUBB.LEVEL2_DESCRIPTION <> SUBT.LEVEL2_DESCRIPTION
      or (SUBB.LEVEL2_DESCRIPTION is null and SUBT.LEVEL2_DESCRIPTION is not null)
      or (SUBB.LEVEL2_DESCRIPTION is not null and SUBT.LEVEL2_DESCRIPTION is null)
      or SUBB.LEVEL3_DESCRIPTION <> SUBT.LEVEL3_DESCRIPTION
      or (SUBB.LEVEL3_DESCRIPTION is null and SUBT.LEVEL3_DESCRIPTION is not null)
      or (SUBB.LEVEL3_DESCRIPTION is not null and SUBT.LEVEL3_DESCRIPTION is null)
      or SUBB.LEVEL4_DESCRIPTION <> SUBT.LEVEL4_DESCRIPTION
      or (SUBB.LEVEL4_DESCRIPTION is null and SUBT.LEVEL4_DESCRIPTION is not null)
      or (SUBB.LEVEL4_DESCRIPTION is not null and SUBT.LEVEL4_DESCRIPTION is null)
      or SUBB.LEVEL5_DESCRIPTION <> SUBT.LEVEL5_DESCRIPTION
      or (SUBB.LEVEL5_DESCRIPTION is null and SUBT.LEVEL5_DESCRIPTION is not null)
      or (SUBB.LEVEL5_DESCRIPTION is not null and SUBT.LEVEL5_DESCRIPTION is null)
      or SUBB.LEVEL6_DESCRIPTION <> SUBT.LEVEL6_DESCRIPTION
      or (SUBB.LEVEL6_DESCRIPTION is null and SUBT.LEVEL6_DESCRIPTION is not null)
      or (SUBB.LEVEL6_DESCRIPTION is not null and SUBT.LEVEL6_DESCRIPTION is null)
      or SUBB.LEVEL7_DESCRIPTION <> SUBT.LEVEL7_DESCRIPTION
      or (SUBB.LEVEL7_DESCRIPTION is null and SUBT.LEVEL7_DESCRIPTION is not null)
      or (SUBB.LEVEL7_DESCRIPTION is not null and SUBT.LEVEL7_DESCRIPTION is null)
      or SUBB.LEVEL8_DESCRIPTION <> SUBT.LEVEL8_DESCRIPTION
      or (SUBB.LEVEL8_DESCRIPTION is null and SUBT.LEVEL8_DESCRIPTION is not null)
      or (SUBB.LEVEL8_DESCRIPTION is not null and SUBT.LEVEL8_DESCRIPTION is null)
      or SUBB.LEVEL9_DESCRIPTION <> SUBT.LEVEL9_DESCRIPTION
      or (SUBB.LEVEL9_DESCRIPTION is null and SUBT.LEVEL9_DESCRIPTION is not null)
      or (SUBB.LEVEL9_DESCRIPTION is not null and SUBT.LEVEL9_DESCRIPTION is null)
      or SUBB.LEVEL10_DESCRIPTION <> SUBT.LEVEL10_DESCRIPTION
      or (SUBB.LEVEL10_DESCRIPTION is null and SUBT.LEVEL10_DESCRIPTION is not null)
      or (SUBB.LEVEL10_DESCRIPTION is not null and SUBT.LEVEL10_DESCRIPTION is null)
      or SUBB.LEVEL11_DESCRIPTION <> SUBT.LEVEL11_DESCRIPTION
      or (SUBB.LEVEL11_DESCRIPTION is null and SUBT.LEVEL11_DESCRIPTION is not null)
      or (SUBB.LEVEL11_DESCRIPTION is not null and SUBT.LEVEL11_DESCRIPTION is null)
      or SUBB.LEVEL12_DESCRIPTION <> SUBT.LEVEL12_DESCRIPTION
      or (SUBB.LEVEL12_DESCRIPTION is null and SUBT.LEVEL12_DESCRIPTION is not null)
      or (SUBB.LEVEL12_DESCRIPTION is not null and SUBT.LEVEL12_DESCRIPTION is null)
      or SUBB.LEVEL13_DESCRIPTION <> SUBT.LEVEL13_DESCRIPTION
      or (SUBB.LEVEL13_DESCRIPTION is null and SUBT.LEVEL13_DESCRIPTION is not null)
      or (SUBB.LEVEL13_DESCRIPTION is not null and SUBT.LEVEL13_DESCRIPTION is null)
      or SUBB.LEVEL14_DESCRIPTION <> SUBT.LEVEL14_DESCRIPTION
      or (SUBB.LEVEL14_DESCRIPTION is null and SUBT.LEVEL14_DESCRIPTION is not null)
      or (SUBB.LEVEL14_DESCRIPTION is not null and SUBT.LEVEL14_DESCRIPTION is null)
      or SUBB.LEVEL15_DESCRIPTION <> SUBT.LEVEL15_DESCRIPTION
      or (SUBB.LEVEL15_DESCRIPTION is null and SUBT.LEVEL15_DESCRIPTION is not null)
      or (SUBB.LEVEL15_DESCRIPTION is not null and SUBT.LEVEL15_DESCRIPTION is null)
      or SUBB.LEVEL16_DESCRIPTION <> SUBT.LEVEL16_DESCRIPTION
      or (SUBB.LEVEL16_DESCRIPTION is null and SUBT.LEVEL16_DESCRIPTION is not null)
      or (SUBB.LEVEL16_DESCRIPTION is not null and SUBT.LEVEL16_DESCRIPTION is null)
      or SUBB.LEVEL17_DESCRIPTION <> SUBT.LEVEL17_DESCRIPTION
      or (SUBB.LEVEL17_DESCRIPTION is null and SUBT.LEVEL17_DESCRIPTION is not null)
      or (SUBB.LEVEL17_DESCRIPTION is not null and SUBT.LEVEL17_DESCRIPTION is null)
      or SUBB.LEVEL18_DESCRIPTION <> SUBT.LEVEL18_DESCRIPTION
      or (SUBB.LEVEL18_DESCRIPTION is null and SUBT.LEVEL18_DESCRIPTION is not null)
      or (SUBB.LEVEL18_DESCRIPTION is not null and SUBT.LEVEL18_DESCRIPTION is null)
      or SUBB.LEVEL19_DESCRIPTION <> SUBT.LEVEL19_DESCRIPTION
      or (SUBB.LEVEL19_DESCRIPTION is null and SUBT.LEVEL19_DESCRIPTION is not null)
      or (SUBB.LEVEL19_DESCRIPTION is not null and SUBT.LEVEL19_DESCRIPTION is null)
      or SUBB.LEVEL20_DESCRIPTION <> SUBT.LEVEL20_DESCRIPTION
      or (SUBB.LEVEL20_DESCRIPTION is null and SUBT.LEVEL20_DESCRIPTION is not null)
      or (SUBB.LEVEL20_DESCRIPTION is not null and SUBT.LEVEL20_DESCRIPTION is null)
  ));

Line: 1491


  insert into FEM_DIS_CST_CNTRS_HIER_TL (
    OBJECT_NAME,
    OBJECT_DEFINITION_NAME,
    LEVEL1_NAME,
    LEVEL2_NAME,
    LEVEL3_NAME,
    LEVEL4_NAME,
    LEVEL5_NAME,
    LEVEL6_NAME,
    LEVEL7_NAME,
    LEVEL8_NAME,
    LEVEL9_NAME,
    LEVEL10_NAME,
    LEVEL11_NAME,
    LEVEL12_NAME,
    LEVEL13_NAME,
    LEVEL14_NAME,
    LEVEL15_NAME,
    LEVEL16_NAME,
    LEVEL17_NAME,
    LEVEL18_NAME,
    LEVEL19_NAME,
    LEVEL20_NAME,
    LEVEL1_DESCRIPTION,
    LEVEL2_DESCRIPTION,
    LEVEL3_DESCRIPTION,
    LEVEL4_DESCRIPTION,
    LEVEL5_DESCRIPTION,
    LEVEL6_DESCRIPTION,
    LEVEL7_DESCRIPTION,
    LEVEL8_DESCRIPTION,
    LEVEL9_DESCRIPTION,
    LEVEL10_DESCRIPTION,
    LEVEL11_DESCRIPTION,
    LEVEL12_DESCRIPTION,
    LEVEL13_DESCRIPTION,
    LEVEL14_DESCRIPTION,
    LEVEL15_DESCRIPTION,
    LEVEL16_DESCRIPTION,
    LEVEL17_DESCRIPTION,
    LEVEL18_DESCRIPTION,
    LEVEL19_DESCRIPTION,
    LEVEL20_DESCRIPTION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_ID,
    OBJECT_DEFINITION_ID,
    VALUE_SET_ID,
    LEVEL1_ID,
    LEVEL2_ID,
    LEVEL3_ID,
    LEVEL4_ID,
    LEVEL5_ID,
    LEVEL6_ID,
    LEVEL7_ID,
    LEVEL8_ID,
    LEVEL9_ID,
    LEVEL10_ID,
    LEVEL11_ID,
    LEVEL12_ID,
    LEVEL13_ID,
    LEVEL14_ID,
    LEVEL15_ID,
    LEVEL16_ID,
    LEVEL17_ID,
    LEVEL18_ID,
    LEVEL19_ID,
    LEVEL20_ID,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.OBJECT_NAME,
    B.OBJECT_DEFINITION_NAME,
    B.LEVEL1_NAME,
    B.LEVEL2_NAME,
    B.LEVEL3_NAME,
    B.LEVEL4_NAME,
    B.LEVEL5_NAME,
    B.LEVEL6_NAME,
    B.LEVEL7_NAME,
    B.LEVEL8_NAME,
    B.LEVEL9_NAME,
    B.LEVEL10_NAME,
    B.LEVEL11_NAME,
    B.LEVEL12_NAME,
    B.LEVEL13_NAME,
    B.LEVEL14_NAME,
    B.LEVEL15_NAME,
    B.LEVEL16_NAME,
    B.LEVEL17_NAME,
    B.LEVEL18_NAME,
    B.LEVEL19_NAME,
    B.LEVEL20_NAME,
    B.LEVEL1_DESCRIPTION,
    B.LEVEL2_DESCRIPTION,
    B.LEVEL3_DESCRIPTION,
    B.LEVEL4_DESCRIPTION,
    B.LEVEL5_DESCRIPTION,
    B.LEVEL6_DESCRIPTION,
    B.LEVEL7_DESCRIPTION,
    B.LEVEL8_DESCRIPTION,
    B.LEVEL9_DESCRIPTION,
    B.LEVEL10_DESCRIPTION,
    B.LEVEL11_DESCRIPTION,
    B.LEVEL12_DESCRIPTION,
    B.LEVEL13_DESCRIPTION,
    B.LEVEL14_DESCRIPTION,
    B.LEVEL15_DESCRIPTION,
    B.LEVEL16_DESCRIPTION,
    B.LEVEL17_DESCRIPTION,
    B.LEVEL18_DESCRIPTION,
    B.LEVEL19_DESCRIPTION,
    B.LEVEL20_DESCRIPTION,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.OBJECT_ID,
    B.OBJECT_DEFINITION_ID,
    B.VALUE_SET_ID,
    B.LEVEL1_ID,
    B.LEVEL2_ID,
    B.LEVEL3_ID,
    B.LEVEL4_ID,
    B.LEVEL5_ID,
    B.LEVEL6_ID,
    B.LEVEL7_ID,
    B.LEVEL8_ID,
    B.LEVEL9_ID,
    B.LEVEL10_ID,
    B.LEVEL11_ID,
    B.LEVEL12_ID,
    B.LEVEL13_ID,
    B.LEVEL14_ID,
    B.LEVEL15_ID,
    B.LEVEL16_ID,
    B.LEVEL17_ID,
    B.LEVEL18_ID,
    B.LEVEL19_ID,
    B.LEVEL20_ID,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from FEM_DIS_CST_CNTRS_HIER_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from FEM_DIS_CST_CNTRS_HIER_TL T
    where T.OBJECT_ID = B.OBJECT_ID
    and T.OBJECT_DEFINITION_ID = B.OBJECT_DEFINITION_ID
    and T.VALUE_SET_ID = B.VALUE_SET_ID
    and T.LEVEL1_ID = B.LEVEL1_ID
    and T.LEVEL2_ID = B.LEVEL2_ID
    and T.LEVEL3_ID = B.LEVEL3_ID
    and T.LEVEL4_ID = B.LEVEL4_ID
    and T.LEVEL5_ID = B.LEVEL5_ID
    and T.LEVEL6_ID = B.LEVEL6_ID
    and T.LEVEL7_ID = B.LEVEL7_ID
    and T.LEVEL8_ID = B.LEVEL8_ID
    and T.LEVEL9_ID = B.LEVEL9_ID
    and T.LEVEL10_ID = B.LEVEL10_ID
    and T.LEVEL11_ID = B.LEVEL11_ID
    and T.LEVEL12_ID = B.LEVEL12_ID
    and T.LEVEL13_ID = B.LEVEL13_ID
    and T.LEVEL14_ID = B.LEVEL14_ID
    and T.LEVEL15_ID = B.LEVEL15_ID
    and T.LEVEL16_ID = B.LEVEL16_ID
    and T.LEVEL17_ID = B.LEVEL17_ID
    and T.LEVEL18_ID = B.LEVEL18_ID
    and T.LEVEL19_ID = B.LEVEL19_ID
    and T.LEVEL20_ID = B.LEVEL20_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 1693


        x_last_update_date in varchar2,
        x_OBJECT_NAME in varchar2,
        x_OBJECT_DEFINITION_NAME in varchar2,
        x_LEVEL1_NAME in varchar2,
        x_LEVEL2_NAME in varchar2,
        x_LEVEL3_NAME in varchar2,
        x_LEVEL4_NAME in varchar2,
        x_LEVEL5_NAME in varchar2,
        x_LEVEL6_NAME in varchar2,
        x_LEVEL7_NAME in varchar2,
        x_LEVEL8_NAME in varchar2,
        x_LEVEL9_NAME in varchar2,
        x_LEVEL10_NAME in varchar2,
        x_LEVEL11_NAME in varchar2,
        x_LEVEL12_NAME in varchar2,
        x_LEVEL13_NAME in varchar2,
        x_LEVEL14_NAME in varchar2,
        x_LEVEL15_NAME in varchar2,
        x_LEVEL16_NAME in varchar2,
        x_LEVEL17_NAME in varchar2,
        x_LEVEL18_NAME in varchar2,
        x_LEVEL19_NAME in varchar2,
        x_LEVEL20_NAME in varchar2,
        x_custom_mode in varchar2) is

        owner_id number;

Line: 1722


        f_ludate  date;    -- entity update date in file

Line: 1724


        db_ludate date;    -- entity update date in db

Line: 1732


        f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 1734


          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from FEM_DIS_CST_CNTRS_HIER_TL
          where OBJECT_ID = x_OBJECT_ID
          and OBJECT_DEFINITION_ID = x_OBJECT_DEFINITION_ID
          and VALUE_SET_ID = x_VALUE_SET_ID
          and LEVEL1_ID = x_LEVEL1_ID
          and LEVEL2_ID = x_LEVEL2_ID
          and LEVEL3_ID = x_LEVEL3_ID
          and LEVEL4_ID = x_LEVEL4_ID
          and LEVEL5_ID = x_LEVEL5_ID
          and LEVEL6_ID = x_LEVEL6_ID
          and LEVEL7_ID = x_LEVEL7_ID
          and LEVEL8_ID = x_LEVEL8_ID
          and LEVEL9_ID = x_LEVEL9_ID
          and LEVEL10_ID = x_LEVEL10_ID
          and LEVEL11_ID = x_LEVEL11_ID
          and LEVEL12_ID = x_LEVEL12_ID
          and LEVEL13_ID = x_LEVEL13_ID
          and LEVEL14_ID = x_LEVEL14_ID
          and LEVEL15_ID = x_LEVEL15_ID
          and LEVEL16_ID = x_LEVEL16_ID
          and LEVEL17_ID = x_LEVEL17_ID
          and LEVEL18_ID = x_LEVEL18_ID
          and LEVEL19_ID = x_LEVEL19_ID
          and LEVEL20_ID = x_LEVEL20_ID
          and LANGUAGE = userenv('LANG');

Line: 1766


            update FEM_DIS_CST_CNTRS_HIER_TL set
              OBJECT_NAME = nvl(x_OBJECT_NAME, OBJECT_NAME),
              OBJECT_DEFINITION_NAME = nvl(x_OBJECT_DEFINITION_NAME, OBJECT_DEFINITION_NAME),
              LEVEL1_NAME = nvl(x_LEVEL1_NAME, LEVEL1_NAME),
              LEVEL2_NAME = nvl(x_LEVEL2_NAME, LEVEL2_NAME),
              LEVEL3_NAME = nvl(x_LEVEL3_NAME, LEVEL3_NAME),
              LEVEL4_NAME = nvl(x_LEVEL4_NAME, LEVEL4_NAME),
              LEVEL5_NAME = nvl(x_LEVEL5_NAME, LEVEL5_NAME),
              LEVEL6_NAME = nvl(x_LEVEL6_NAME, LEVEL6_NAME),
              LEVEL7_NAME = nvl(x_LEVEL7_NAME, LEVEL7_NAME),
              LEVEL8_NAME = nvl(x_LEVEL8_NAME, LEVEL8_NAME),
              LEVEL9_NAME = nvl(x_LEVEL9_NAME, LEVEL9_NAME),
              LEVEL10_NAME = nvl(x_LEVEL10_NAME, LEVEL10_NAME),
              LEVEL11_NAME = nvl(x_LEVEL11_NAME, LEVEL11_NAME),
              LEVEL12_NAME = nvl(x_LEVEL12_NAME, LEVEL12_NAME),
              LEVEL13_NAME = nvl(x_LEVEL13_NAME, LEVEL13_NAME),
              LEVEL14_NAME = nvl(x_LEVEL14_NAME, LEVEL14_NAME),
              LEVEL15_NAME = nvl(x_LEVEL15_NAME, LEVEL15_NAME),
              LEVEL16_NAME = nvl(x_LEVEL16_NAME, LEVEL16_NAME),
              LEVEL17_NAME = nvl(x_LEVEL17_NAME, LEVEL17_NAME),
              LEVEL18_NAME = nvl(x_LEVEL18_NAME, LEVEL18_NAME),
              LEVEL19_NAME = nvl(x_LEVEL19_NAME, LEVEL19_NAME),
              LEVEL20_NAME = nvl(x_LEVEL20_NAME, LEVEL20_NAME),
              LAST_UPDATE_DATE = f_ludate,
              LAST_UPDATED_BY = f_luby,
              LAST_UPDATE_LOGIN = 0,
              SOURCE_LANG = userenv('LANG')
            where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
            and OBJECT_ID = x_OBJECT_ID
            and OBJECT_DEFINITION_ID = x_OBJECT_DEFINITION_ID
            and VALUE_SET_ID = x_VALUE_SET_ID
            and LEVEL1_ID = x_LEVEL1_ID
            and LEVEL2_ID = x_LEVEL2_ID
            and LEVEL3_ID = x_LEVEL3_ID
            and LEVEL4_ID = x_LEVEL4_ID
            and LEVEL5_ID = x_LEVEL5_ID
            and LEVEL6_ID = x_LEVEL6_ID
            and LEVEL7_ID = x_LEVEL7_ID
            and LEVEL8_ID = x_LEVEL8_ID
            and LEVEL9_ID = x_LEVEL9_ID
            and LEVEL10_ID = x_LEVEL10_ID
            and LEVEL11_ID = x_LEVEL11_ID
            and LEVEL12_ID = x_LEVEL12_ID
            and LEVEL13_ID = x_LEVEL13_ID
            and LEVEL14_ID = x_LEVEL14_ID
            and LEVEL15_ID = x_LEVEL15_ID
            and LEVEL16_ID = x_LEVEL16_ID
            and LEVEL17_ID = x_LEVEL17_ID
            and LEVEL18_ID = x_LEVEL18_ID
            and LEVEL19_ID = x_LEVEL19_ID
            and LEVEL20_ID = x_LEVEL20_ID;