The following lines contain the word 'select', 'insert', 'update' or 'delete':
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_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_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_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_CUSTOMERS_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
;
insert into FEM_DIS_CUSTOMERS_HIER_B (
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,
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,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
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_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_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);
insert into FEM_DIS_CUSTOMERS_HIER_TL (
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,
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,
LANGUAGE,
SOURCE_LANG
) select
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,
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,
L.LANGUAGE_CODE,
userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from FEM_DIS_CUSTOMERS_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);
end INSERT_ROW;
cursor c is select
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,
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
from FEM_DIS_CUSTOMERS_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;
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_CUSTOMERS_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;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
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_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_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_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_CUSTOMERS_HIER_B set
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,
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,
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;
update FEM_DIS_CUSTOMERS_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);
end UPDATE_ROW;
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_CUSTOMERS_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;
delete from FEM_DIS_CUSTOMERS_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;
end DELETE_ROW;
delete from FEM_DIS_CUSTOMERS_HIER_TL T
where not exists
(select NULL
from FEM_DIS_CUSTOMERS_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
);
update FEM_DIS_CUSTOMERS_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_CUSTOMERS_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_CUSTOMERS_HIER_TL SUBB, FEM_DIS_CUSTOMERS_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)
));
insert into FEM_DIS_CUSTOMERS_HIER_TL (
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,
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,
LANGUAGE,
SOURCE_LANG
) select /*+ ORDERED */
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,
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,
L.LANGUAGE_CODE,
B.SOURCE_LANG
from FEM_DIS_CUSTOMERS_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_CUSTOMERS_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);
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;
f_ludate date; -- entity update date in file
db_ludate date; -- entity update date in db
f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
select LAST_UPDATED_BY, LAST_UPDATE_DATE
into db_luby, db_ludate
from FEM_DIS_CUSTOMERS_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');
update FEM_DIS_CUSTOMERS_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;