The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
X_ROWID in out nocopy VARCHAR2,
X_EXTENSION_ID in NUMBER,
X_N_EXT_ATTR17 in NUMBER,
X_N_EXT_ATTR18 in NUMBER,
X_N_EXT_ATTR19 in NUMBER,
X_N_EXT_ATTR20 in NUMBER,
X_UOM_EXT_ATTR1 in VARCHAR2,
X_UOM_EXT_ATTR2 in VARCHAR2,
X_UOM_EXT_ATTR3 in VARCHAR2,
X_UOM_EXT_ATTR4 in VARCHAR2,
X_UOM_EXT_ATTR5 in VARCHAR2,
X_UOM_EXT_ATTR6 in VARCHAR2,
X_UOM_EXT_ATTR7 in VARCHAR2,
X_UOM_EXT_ATTR8 in VARCHAR2,
X_UOM_EXT_ATTR9 in VARCHAR2,
X_UOM_EXT_ATTR10 in VARCHAR2,
X_UOM_EXT_ATTR11 in VARCHAR2,
X_UOM_EXT_ATTR12 in VARCHAR2,
X_UOM_EXT_ATTR13 in VARCHAR2,
X_UOM_EXT_ATTR14 in VARCHAR2,
X_UOM_EXT_ATTR15 in VARCHAR2,
X_UOM_EXT_ATTR16 in VARCHAR2,
X_UOM_EXT_ATTR17 in VARCHAR2,
X_UOM_EXT_ATTR18 in VARCHAR2,
X_UOM_EXT_ATTR19 in VARCHAR2,
X_UOM_EXT_ATTR20 in VARCHAR2,
X_D_EXT_ATTR6 in DATE,
X_D_EXT_ATTR7 in DATE,
X_D_EXT_ATTR8 in DATE,
X_D_EXT_ATTR9 in DATE,
X_D_EXT_ATTR10 in DATE,
X_REQUEST_ID in NUMBER,
X_SITE_ID in NUMBER,
X_SITE_USE_TYPE_CODE in VARCHAR2,
X_ATTR_GROUP_ID in NUMBER,
X_C_EXT_ATTR1 in VARCHAR2,
X_C_EXT_ATTR2 in VARCHAR2,
X_C_EXT_ATTR3 in VARCHAR2,
X_C_EXT_ATTR4 in VARCHAR2,
X_C_EXT_ATTR5 in VARCHAR2,
X_C_EXT_ATTR6 in VARCHAR2,
X_C_EXT_ATTR7 in VARCHAR2,
X_C_EXT_ATTR8 in VARCHAR2,
X_C_EXT_ATTR9 in VARCHAR2,
X_C_EXT_ATTR10 in VARCHAR2,
X_C_EXT_ATTR11 in VARCHAR2,
X_C_EXT_ATTR12 in VARCHAR2,
X_C_EXT_ATTR13 in VARCHAR2,
X_C_EXT_ATTR14 in VARCHAR2,
X_C_EXT_ATTR15 in VARCHAR2,
X_C_EXT_ATTR16 in VARCHAR2,
X_C_EXT_ATTR17 in VARCHAR2,
X_C_EXT_ATTR18 in VARCHAR2,
X_C_EXT_ATTR19 in VARCHAR2,
X_C_EXT_ATTR20 in VARCHAR2,
X_N_EXT_ATTR1 in NUMBER,
X_N_EXT_ATTR2 in NUMBER,
X_N_EXT_ATTR3 in NUMBER,
X_N_EXT_ATTR4 in NUMBER,
X_N_EXT_ATTR5 in NUMBER,
X_N_EXT_ATTR6 in NUMBER,
X_N_EXT_ATTR7 in NUMBER,
X_N_EXT_ATTR8 in NUMBER,
X_N_EXT_ATTR9 in NUMBER,
X_N_EXT_ATTR10 in NUMBER,
X_D_EXT_ATTR1 in DATE,
X_D_EXT_ATTR2 in DATE,
X_D_EXT_ATTR3 in DATE,
X_D_EXT_ATTR4 in DATE,
X_D_EXT_ATTR5 in DATE,
X_C_EXT_ATTR21 in VARCHAR2,
X_C_EXT_ATTR22 in VARCHAR2,
X_C_EXT_ATTR23 in VARCHAR2,
X_C_EXT_ATTR24 in VARCHAR2,
X_C_EXT_ATTR25 in VARCHAR2,
X_C_EXT_ATTR26 in VARCHAR2,
X_C_EXT_ATTR27 in VARCHAR2,
X_C_EXT_ATTR28 in VARCHAR2,
X_C_EXT_ATTR29 in VARCHAR2,
X_C_EXT_ATTR30 in VARCHAR2,
X_C_EXT_ATTR31 in VARCHAR2,
X_C_EXT_ATTR32 in VARCHAR2,
X_C_EXT_ATTR33 in VARCHAR2,
X_C_EXT_ATTR34 in VARCHAR2,
X_C_EXT_ATTR35 in VARCHAR2,
X_C_EXT_ATTR36 in VARCHAR2,
X_C_EXT_ATTR37 in VARCHAR2,
X_C_EXT_ATTR38 in VARCHAR2,
X_C_EXT_ATTR39 in VARCHAR2,
X_C_EXT_ATTR40 in VARCHAR2,
X_N_EXT_ATTR11 in NUMBER,
X_N_EXT_ATTR12 in NUMBER,
X_N_EXT_ATTR13 in NUMBER,
X_N_EXT_ATTR14 in NUMBER,
X_N_EXT_ATTR15 in NUMBER,
X_N_EXT_ATTR16 in NUMBER,
X_TL_EXT_ATTR1 in VARCHAR2,
X_TL_EXT_ATTR2 in VARCHAR2,
X_TL_EXT_ATTR3 in VARCHAR2,
X_TL_EXT_ATTR4 in VARCHAR2,
X_TL_EXT_ATTR5 in VARCHAR2,
X_TL_EXT_ATTR6 in VARCHAR2,
X_TL_EXT_ATTR7 in VARCHAR2,
X_TL_EXT_ATTR8 in VARCHAR2,
X_TL_EXT_ATTR9 in VARCHAR2,
X_TL_EXT_ATTR10 in VARCHAR2,
X_TL_EXT_ATTR11 in VARCHAR2,
X_TL_EXT_ATTR12 in VARCHAR2,
X_TL_EXT_ATTR13 in VARCHAR2,
X_TL_EXT_ATTR14 in VARCHAR2,
X_TL_EXT_ATTR15 in VARCHAR2,
X_TL_EXT_ATTR16 in VARCHAR2,
X_TL_EXT_ATTR17 in VARCHAR2,
X_TL_EXT_ATTR18 in VARCHAR2,
X_TL_EXT_ATTR19 in VARCHAR2,
X_TL_EXT_ATTR20 in VARCHAR2,
X_TL_EXT_ATTR21 in VARCHAR2,
X_TL_EXT_ATTR22 in VARCHAR2,
X_TL_EXT_ATTR23 in VARCHAR2,
X_TL_EXT_ATTR24 in VARCHAR2,
X_TL_EXT_ATTR25 in VARCHAR2,
X_TL_EXT_ATTR26 in VARCHAR2,
X_TL_EXT_ATTR27 in VARCHAR2,
X_TL_EXT_ATTR28 in VARCHAR2,
X_TL_EXT_ATTR29 in VARCHAR2,
X_TL_EXT_ATTR30 in VARCHAR2,
X_TL_EXT_ATTR31 in VARCHAR2,
X_TL_EXT_ATTR32 in VARCHAR2,
X_TL_EXT_ATTR33 in VARCHAR2,
X_TL_EXT_ATTR34 in VARCHAR2,
X_TL_EXT_ATTR35 in VARCHAR2,
X_TL_EXT_ATTR36 in VARCHAR2,
X_TL_EXT_ATTR37 in VARCHAR2,
X_TL_EXT_ATTR38 in VARCHAR2,
X_TL_EXT_ATTR39 in VARCHAR2,
X_TL_EXT_ATTR40 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
l_extension_id NUMBER;
cursor C is select ROWID from RRS_SITES_EXT_B
where EXTENSION_ID = l_extension_id
;
select nvl(X_EXTENSION_ID ,EGO_EXTFWK_S.nextval)
into l_extension_id
from dual;
insert into RRS_SITES_EXT_B (
EXTENSION_ID,
SITE_ID,
SITE_USE_TYPE_CODE,
ATTR_GROUP_ID,
C_EXT_ATTR1,
C_EXT_ATTR2,
C_EXT_ATTR3,
C_EXT_ATTR4,
C_EXT_ATTR5,
C_EXT_ATTR6,
C_EXT_ATTR7,
C_EXT_ATTR8,
C_EXT_ATTR9,
C_EXT_ATTR10,
C_EXT_ATTR11,
C_EXT_ATTR12,
C_EXT_ATTR13,
C_EXT_ATTR14,
C_EXT_ATTR15,
C_EXT_ATTR16,
C_EXT_ATTR17,
C_EXT_ATTR18,
C_EXT_ATTR19,
C_EXT_ATTR20,
C_EXT_ATTR21,
C_EXT_ATTR22,
C_EXT_ATTR23,
C_EXT_ATTR24,
C_EXT_ATTR25,
C_EXT_ATTR26,
C_EXT_ATTR27,
C_EXT_ATTR28,
C_EXT_ATTR29,
C_EXT_ATTR30,
C_EXT_ATTR31,
C_EXT_ATTR32,
C_EXT_ATTR33,
C_EXT_ATTR34,
C_EXT_ATTR35,
C_EXT_ATTR36,
C_EXT_ATTR37,
C_EXT_ATTR38,
C_EXT_ATTR39,
C_EXT_ATTR40,
N_EXT_ATTR1,
N_EXT_ATTR2,
N_EXT_ATTR3,
N_EXT_ATTR4,
N_EXT_ATTR5,
N_EXT_ATTR6,
N_EXT_ATTR7,
N_EXT_ATTR8,
N_EXT_ATTR9,
N_EXT_ATTR10,
N_EXT_ATTR11,
N_EXT_ATTR12,
N_EXT_ATTR13,
N_EXT_ATTR14,
N_EXT_ATTR15,
N_EXT_ATTR16,
N_EXT_ATTR17,
N_EXT_ATTR18,
N_EXT_ATTR19,
N_EXT_ATTR20,
D_EXT_ATTR1,
D_EXT_ATTR2,
D_EXT_ATTR3,
D_EXT_ATTR4,
D_EXT_ATTR5,
D_EXT_ATTR6,
D_EXT_ATTR7,
D_EXT_ATTR8,
D_EXT_ATTR9,
D_EXT_ATTR10,
UOM_EXT_ATTR1,
UOM_EXT_ATTR2,
UOM_EXT_ATTR3,
UOM_EXT_ATTR4,
UOM_EXT_ATTR5,
UOM_EXT_ATTR6,
UOM_EXT_ATTR7,
UOM_EXT_ATTR8,
UOM_EXT_ATTR9,
UOM_EXT_ATTR10,
UOM_EXT_ATTR11,
UOM_EXT_ATTR12,
UOM_EXT_ATTR13,
UOM_EXT_ATTR14,
UOM_EXT_ATTR15,
UOM_EXT_ATTR16,
UOM_EXT_ATTR17,
UOM_EXT_ATTR18,
UOM_EXT_ATTR19,
UOM_EXT_ATTR20,
REQUEST_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
l_extension_id,
X_SITE_ID,
X_SITE_USE_TYPE_CODE,
X_ATTR_GROUP_ID,
X_C_EXT_ATTR1,
X_C_EXT_ATTR2,
X_C_EXT_ATTR3,
X_C_EXT_ATTR4,
X_C_EXT_ATTR5,
X_C_EXT_ATTR6,
X_C_EXT_ATTR7,
X_C_EXT_ATTR8,
X_C_EXT_ATTR9,
X_C_EXT_ATTR10,
X_C_EXT_ATTR11,
X_C_EXT_ATTR12,
X_C_EXT_ATTR13,
X_C_EXT_ATTR14,
X_C_EXT_ATTR15,
X_C_EXT_ATTR16,
X_C_EXT_ATTR17,
X_C_EXT_ATTR18,
X_C_EXT_ATTR19,
X_C_EXT_ATTR20,
X_C_EXT_ATTR21,
X_C_EXT_ATTR22,
X_C_EXT_ATTR23,
X_C_EXT_ATTR24,
X_C_EXT_ATTR25,
X_C_EXT_ATTR26,
X_C_EXT_ATTR27,
X_C_EXT_ATTR28,
X_C_EXT_ATTR29,
X_C_EXT_ATTR30,
X_C_EXT_ATTR31,
X_C_EXT_ATTR32,
X_C_EXT_ATTR33,
X_C_EXT_ATTR34,
X_C_EXT_ATTR35,
X_C_EXT_ATTR36,
X_C_EXT_ATTR37,
X_C_EXT_ATTR38,
X_C_EXT_ATTR39,
X_C_EXT_ATTR40,
X_N_EXT_ATTR1,
X_N_EXT_ATTR2,
X_N_EXT_ATTR3,
X_N_EXT_ATTR4,
X_N_EXT_ATTR5,
X_N_EXT_ATTR6,
X_N_EXT_ATTR7,
X_N_EXT_ATTR8,
X_N_EXT_ATTR9,
X_N_EXT_ATTR10,
X_N_EXT_ATTR11,
X_N_EXT_ATTR12,
X_N_EXT_ATTR13,
X_N_EXT_ATTR14,
X_N_EXT_ATTR15,
X_N_EXT_ATTR16,
X_N_EXT_ATTR17,
X_N_EXT_ATTR18,
X_N_EXT_ATTR19,
X_N_EXT_ATTR20,
X_D_EXT_ATTR1,
X_D_EXT_ATTR2,
X_D_EXT_ATTR3,
X_D_EXT_ATTR4,
X_D_EXT_ATTR5,
X_D_EXT_ATTR6,
X_D_EXT_ATTR7,
X_D_EXT_ATTR8,
X_D_EXT_ATTR9,
X_D_EXT_ATTR10,
X_UOM_EXT_ATTR1,
X_UOM_EXT_ATTR2,
X_UOM_EXT_ATTR3,
X_UOM_EXT_ATTR4,
X_UOM_EXT_ATTR5,
X_UOM_EXT_ATTR6,
X_UOM_EXT_ATTR7,
X_UOM_EXT_ATTR8,
X_UOM_EXT_ATTR9,
X_UOM_EXT_ATTR10,
X_UOM_EXT_ATTR11,
X_UOM_EXT_ATTR12,
X_UOM_EXT_ATTR13,
X_UOM_EXT_ATTR14,
X_UOM_EXT_ATTR15,
X_UOM_EXT_ATTR16,
X_UOM_EXT_ATTR17,
X_UOM_EXT_ATTR18,
X_UOM_EXT_ATTR19,
X_UOM_EXT_ATTR20,
X_REQUEST_ID,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);
insert into RRS_SITES_EXT_TL (
EXTENSION_ID,
SITE_ID,
SITE_USE_TYPE_CODE,
ATTR_GROUP_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATED_BY,
CREATION_DATE,
TL_EXT_ATTR1,
TL_EXT_ATTR2,
TL_EXT_ATTR3,
TL_EXT_ATTR4,
TL_EXT_ATTR5,
TL_EXT_ATTR6,
TL_EXT_ATTR7,
TL_EXT_ATTR8,
TL_EXT_ATTR9,
TL_EXT_ATTR10,
TL_EXT_ATTR11,
TL_EXT_ATTR12,
TL_EXT_ATTR13,
TL_EXT_ATTR14,
TL_EXT_ATTR15,
TL_EXT_ATTR16,
TL_EXT_ATTR17,
TL_EXT_ATTR18,
TL_EXT_ATTR19,
TL_EXT_ATTR20,
TL_EXT_ATTR21,
TL_EXT_ATTR22,
TL_EXT_ATTR23,
TL_EXT_ATTR24,
TL_EXT_ATTR25,
TL_EXT_ATTR26,
TL_EXT_ATTR27,
TL_EXT_ATTR28,
TL_EXT_ATTR29,
TL_EXT_ATTR30,
TL_EXT_ATTR31,
TL_EXT_ATTR32,
TL_EXT_ATTR33,
TL_EXT_ATTR34,
TL_EXT_ATTR35,
TL_EXT_ATTR36,
TL_EXT_ATTR37,
TL_EXT_ATTR38,
TL_EXT_ATTR39,
TL_EXT_ATTR40,
LANGUAGE,
SOURCE_LANG
) select
l_extension_id,
X_SITE_ID,
X_SITE_USE_TYPE_CODE,
X_ATTR_GROUP_ID,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN,
X_CREATED_BY,
X_CREATION_DATE,
X_TL_EXT_ATTR1,
X_TL_EXT_ATTR2,
X_TL_EXT_ATTR3,
X_TL_EXT_ATTR4,
X_TL_EXT_ATTR5,
X_TL_EXT_ATTR6,
X_TL_EXT_ATTR7,
X_TL_EXT_ATTR8,
X_TL_EXT_ATTR9,
X_TL_EXT_ATTR10,
X_TL_EXT_ATTR11,
X_TL_EXT_ATTR12,
X_TL_EXT_ATTR13,
X_TL_EXT_ATTR14,
X_TL_EXT_ATTR15,
X_TL_EXT_ATTR16,
X_TL_EXT_ATTR17,
X_TL_EXT_ATTR18,
X_TL_EXT_ATTR19,
X_TL_EXT_ATTR20,
X_TL_EXT_ATTR21,
X_TL_EXT_ATTR22,
X_TL_EXT_ATTR23,
X_TL_EXT_ATTR24,
X_TL_EXT_ATTR25,
X_TL_EXT_ATTR26,
X_TL_EXT_ATTR27,
X_TL_EXT_ATTR28,
X_TL_EXT_ATTR29,
X_TL_EXT_ATTR30,
X_TL_EXT_ATTR31,
X_TL_EXT_ATTR32,
X_TL_EXT_ATTR33,
X_TL_EXT_ATTR34,
X_TL_EXT_ATTR35,
X_TL_EXT_ATTR36,
X_TL_EXT_ATTR37,
X_TL_EXT_ATTR38,
X_TL_EXT_ATTR39,
X_TL_EXT_ATTR40,
L.LANGUAGE_CODE,
userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from RRS_SITES_EXT_TL T
where T.EXTENSION_ID = l_extension_id
and T.LANGUAGE = L.LANGUAGE_CODE);
end INSERT_ROW;
cursor c is select
N_EXT_ATTR17,
N_EXT_ATTR18,
N_EXT_ATTR19,
N_EXT_ATTR20,
UOM_EXT_ATTR1,
UOM_EXT_ATTR2,
UOM_EXT_ATTR3,
UOM_EXT_ATTR4,
UOM_EXT_ATTR5,
UOM_EXT_ATTR6,
UOM_EXT_ATTR7,
UOM_EXT_ATTR8,
UOM_EXT_ATTR9,
UOM_EXT_ATTR10,
UOM_EXT_ATTR11,
UOM_EXT_ATTR12,
UOM_EXT_ATTR13,
UOM_EXT_ATTR14,
UOM_EXT_ATTR15,
UOM_EXT_ATTR16,
UOM_EXT_ATTR17,
UOM_EXT_ATTR18,
UOM_EXT_ATTR19,
UOM_EXT_ATTR20,
D_EXT_ATTR6,
D_EXT_ATTR7,
D_EXT_ATTR8,
D_EXT_ATTR9,
D_EXT_ATTR10,
REQUEST_ID,
SITE_ID,
SITE_USE_TYPE_CODE,
ATTR_GROUP_ID,
C_EXT_ATTR1,
C_EXT_ATTR2,
C_EXT_ATTR3,
C_EXT_ATTR4,
C_EXT_ATTR5,
C_EXT_ATTR6,
C_EXT_ATTR7,
C_EXT_ATTR8,
C_EXT_ATTR9,
C_EXT_ATTR10,
C_EXT_ATTR11,
C_EXT_ATTR12,
C_EXT_ATTR13,
C_EXT_ATTR14,
C_EXT_ATTR15,
C_EXT_ATTR16,
C_EXT_ATTR17,
C_EXT_ATTR18,
C_EXT_ATTR19,
C_EXT_ATTR20,
N_EXT_ATTR1,
N_EXT_ATTR2,
N_EXT_ATTR3,
N_EXT_ATTR4,
N_EXT_ATTR5,
N_EXT_ATTR6,
N_EXT_ATTR7,
N_EXT_ATTR8,
N_EXT_ATTR9,
N_EXT_ATTR10,
D_EXT_ATTR1,
D_EXT_ATTR2,
D_EXT_ATTR3,
D_EXT_ATTR4,
D_EXT_ATTR5,
C_EXT_ATTR21,
C_EXT_ATTR22,
C_EXT_ATTR23,
C_EXT_ATTR24,
C_EXT_ATTR25,
C_EXT_ATTR26,
C_EXT_ATTR27,
C_EXT_ATTR28,
C_EXT_ATTR29,
C_EXT_ATTR30,
C_EXT_ATTR31,
C_EXT_ATTR32,
C_EXT_ATTR33,
C_EXT_ATTR34,
C_EXT_ATTR35,
C_EXT_ATTR36,
C_EXT_ATTR37,
C_EXT_ATTR38,
C_EXT_ATTR39,
C_EXT_ATTR40,
N_EXT_ATTR11,
N_EXT_ATTR12,
N_EXT_ATTR13,
N_EXT_ATTR14,
N_EXT_ATTR15,
N_EXT_ATTR16
from RRS_SITES_EXT_B
where EXTENSION_ID = X_EXTENSION_ID
for update of EXTENSION_ID nowait;
cursor c1 is select
TL_EXT_ATTR1,
TL_EXT_ATTR2,
TL_EXT_ATTR3,
TL_EXT_ATTR4,
TL_EXT_ATTR5,
TL_EXT_ATTR6,
TL_EXT_ATTR7,
TL_EXT_ATTR8,
TL_EXT_ATTR9,
TL_EXT_ATTR10,
TL_EXT_ATTR11,
TL_EXT_ATTR12,
TL_EXT_ATTR13,
TL_EXT_ATTR14,
TL_EXT_ATTR15,
TL_EXT_ATTR16,
TL_EXT_ATTR17,
TL_EXT_ATTR18,
TL_EXT_ATTR19,
TL_EXT_ATTR20,
TL_EXT_ATTR21,
TL_EXT_ATTR22,
TL_EXT_ATTR23,
TL_EXT_ATTR24,
TL_EXT_ATTR25,
TL_EXT_ATTR26,
TL_EXT_ATTR27,
TL_EXT_ATTR28,
TL_EXT_ATTR29,
TL_EXT_ATTR30,
TL_EXT_ATTR31,
TL_EXT_ATTR32,
TL_EXT_ATTR33,
TL_EXT_ATTR34,
TL_EXT_ATTR35,
TL_EXT_ATTR36,
TL_EXT_ATTR37,
TL_EXT_ATTR38,
TL_EXT_ATTR39,
TL_EXT_ATTR40,
decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
from RRS_SITES_EXT_TL
where EXTENSION_ID = X_EXTENSION_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
for update of EXTENSION_ID nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
procedure UPDATE_ROW (
X_EXTENSION_ID in NUMBER,
X_N_EXT_ATTR17 in NUMBER,
X_N_EXT_ATTR18 in NUMBER,
X_N_EXT_ATTR19 in NUMBER,
X_N_EXT_ATTR20 in NUMBER,
X_UOM_EXT_ATTR1 in VARCHAR2,
X_UOM_EXT_ATTR2 in VARCHAR2,
X_UOM_EXT_ATTR3 in VARCHAR2,
X_UOM_EXT_ATTR4 in VARCHAR2,
X_UOM_EXT_ATTR5 in VARCHAR2,
X_UOM_EXT_ATTR6 in VARCHAR2,
X_UOM_EXT_ATTR7 in VARCHAR2,
X_UOM_EXT_ATTR8 in VARCHAR2,
X_UOM_EXT_ATTR9 in VARCHAR2,
X_UOM_EXT_ATTR10 in VARCHAR2,
X_UOM_EXT_ATTR11 in VARCHAR2,
X_UOM_EXT_ATTR12 in VARCHAR2,
X_UOM_EXT_ATTR13 in VARCHAR2,
X_UOM_EXT_ATTR14 in VARCHAR2,
X_UOM_EXT_ATTR15 in VARCHAR2,
X_UOM_EXT_ATTR16 in VARCHAR2,
X_UOM_EXT_ATTR17 in VARCHAR2,
X_UOM_EXT_ATTR18 in VARCHAR2,
X_UOM_EXT_ATTR19 in VARCHAR2,
X_UOM_EXT_ATTR20 in VARCHAR2,
X_D_EXT_ATTR6 in DATE,
X_D_EXT_ATTR7 in DATE,
X_D_EXT_ATTR8 in DATE,
X_D_EXT_ATTR9 in DATE,
X_D_EXT_ATTR10 in DATE,
X_REQUEST_ID in NUMBER,
X_SITE_ID in NUMBER,
X_SITE_USE_TYPE_CODE in VARCHAR2,
X_ATTR_GROUP_ID in NUMBER,
X_C_EXT_ATTR1 in VARCHAR2,
X_C_EXT_ATTR2 in VARCHAR2,
X_C_EXT_ATTR3 in VARCHAR2,
X_C_EXT_ATTR4 in VARCHAR2,
X_C_EXT_ATTR5 in VARCHAR2,
X_C_EXT_ATTR6 in VARCHAR2,
X_C_EXT_ATTR7 in VARCHAR2,
X_C_EXT_ATTR8 in VARCHAR2,
X_C_EXT_ATTR9 in VARCHAR2,
X_C_EXT_ATTR10 in VARCHAR2,
X_C_EXT_ATTR11 in VARCHAR2,
X_C_EXT_ATTR12 in VARCHAR2,
X_C_EXT_ATTR13 in VARCHAR2,
X_C_EXT_ATTR14 in VARCHAR2,
X_C_EXT_ATTR15 in VARCHAR2,
X_C_EXT_ATTR16 in VARCHAR2,
X_C_EXT_ATTR17 in VARCHAR2,
X_C_EXT_ATTR18 in VARCHAR2,
X_C_EXT_ATTR19 in VARCHAR2,
X_C_EXT_ATTR20 in VARCHAR2,
X_N_EXT_ATTR1 in NUMBER,
X_N_EXT_ATTR2 in NUMBER,
X_N_EXT_ATTR3 in NUMBER,
X_N_EXT_ATTR4 in NUMBER,
X_N_EXT_ATTR5 in NUMBER,
X_N_EXT_ATTR6 in NUMBER,
X_N_EXT_ATTR7 in NUMBER,
X_N_EXT_ATTR8 in NUMBER,
X_N_EXT_ATTR9 in NUMBER,
X_N_EXT_ATTR10 in NUMBER,
X_D_EXT_ATTR1 in DATE,
X_D_EXT_ATTR2 in DATE,
X_D_EXT_ATTR3 in DATE,
X_D_EXT_ATTR4 in DATE,
X_D_EXT_ATTR5 in DATE,
X_C_EXT_ATTR21 in VARCHAR2,
X_C_EXT_ATTR22 in VARCHAR2,
X_C_EXT_ATTR23 in VARCHAR2,
X_C_EXT_ATTR24 in VARCHAR2,
X_C_EXT_ATTR25 in VARCHAR2,
X_C_EXT_ATTR26 in VARCHAR2,
X_C_EXT_ATTR27 in VARCHAR2,
X_C_EXT_ATTR28 in VARCHAR2,
X_C_EXT_ATTR29 in VARCHAR2,
X_C_EXT_ATTR30 in VARCHAR2,
X_C_EXT_ATTR31 in VARCHAR2,
X_C_EXT_ATTR32 in VARCHAR2,
X_C_EXT_ATTR33 in VARCHAR2,
X_C_EXT_ATTR34 in VARCHAR2,
X_C_EXT_ATTR35 in VARCHAR2,
X_C_EXT_ATTR36 in VARCHAR2,
X_C_EXT_ATTR37 in VARCHAR2,
X_C_EXT_ATTR38 in VARCHAR2,
X_C_EXT_ATTR39 in VARCHAR2,
X_C_EXT_ATTR40 in VARCHAR2,
X_N_EXT_ATTR11 in NUMBER,
X_N_EXT_ATTR12 in NUMBER,
X_N_EXT_ATTR13 in NUMBER,
X_N_EXT_ATTR14 in NUMBER,
X_N_EXT_ATTR15 in NUMBER,
X_N_EXT_ATTR16 in NUMBER,
X_TL_EXT_ATTR1 in VARCHAR2,
X_TL_EXT_ATTR2 in VARCHAR2,
X_TL_EXT_ATTR3 in VARCHAR2,
X_TL_EXT_ATTR4 in VARCHAR2,
X_TL_EXT_ATTR5 in VARCHAR2,
X_TL_EXT_ATTR6 in VARCHAR2,
X_TL_EXT_ATTR7 in VARCHAR2,
X_TL_EXT_ATTR8 in VARCHAR2,
X_TL_EXT_ATTR9 in VARCHAR2,
X_TL_EXT_ATTR10 in VARCHAR2,
X_TL_EXT_ATTR11 in VARCHAR2,
X_TL_EXT_ATTR12 in VARCHAR2,
X_TL_EXT_ATTR13 in VARCHAR2,
X_TL_EXT_ATTR14 in VARCHAR2,
X_TL_EXT_ATTR15 in VARCHAR2,
X_TL_EXT_ATTR16 in VARCHAR2,
X_TL_EXT_ATTR17 in VARCHAR2,
X_TL_EXT_ATTR18 in VARCHAR2,
X_TL_EXT_ATTR19 in VARCHAR2,
X_TL_EXT_ATTR20 in VARCHAR2,
X_TL_EXT_ATTR21 in VARCHAR2,
X_TL_EXT_ATTR22 in VARCHAR2,
X_TL_EXT_ATTR23 in VARCHAR2,
X_TL_EXT_ATTR24 in VARCHAR2,
X_TL_EXT_ATTR25 in VARCHAR2,
X_TL_EXT_ATTR26 in VARCHAR2,
X_TL_EXT_ATTR27 in VARCHAR2,
X_TL_EXT_ATTR28 in VARCHAR2,
X_TL_EXT_ATTR29 in VARCHAR2,
X_TL_EXT_ATTR30 in VARCHAR2,
X_TL_EXT_ATTR31 in VARCHAR2,
X_TL_EXT_ATTR32 in VARCHAR2,
X_TL_EXT_ATTR33 in VARCHAR2,
X_TL_EXT_ATTR34 in VARCHAR2,
X_TL_EXT_ATTR35 in VARCHAR2,
X_TL_EXT_ATTR36 in VARCHAR2,
X_TL_EXT_ATTR37 in VARCHAR2,
X_TL_EXT_ATTR38 in VARCHAR2,
X_TL_EXT_ATTR39 in VARCHAR2,
X_TL_EXT_ATTR40 in VARCHAR2,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
update RRS_SITES_EXT_B set
N_EXT_ATTR17 = X_N_EXT_ATTR17,
N_EXT_ATTR18 = X_N_EXT_ATTR18,
N_EXT_ATTR19 = X_N_EXT_ATTR19,
N_EXT_ATTR20 = X_N_EXT_ATTR20,
UOM_EXT_ATTR1 = X_UOM_EXT_ATTR1,
UOM_EXT_ATTR2 = X_UOM_EXT_ATTR2,
UOM_EXT_ATTR3 = X_UOM_EXT_ATTR3,
UOM_EXT_ATTR4 = X_UOM_EXT_ATTR4,
UOM_EXT_ATTR5 = X_UOM_EXT_ATTR5,
UOM_EXT_ATTR6 = X_UOM_EXT_ATTR6,
UOM_EXT_ATTR7 = X_UOM_EXT_ATTR7,
UOM_EXT_ATTR8 = X_UOM_EXT_ATTR8,
UOM_EXT_ATTR9 = X_UOM_EXT_ATTR9,
UOM_EXT_ATTR10 = X_UOM_EXT_ATTR10,
UOM_EXT_ATTR11 = X_UOM_EXT_ATTR11,
UOM_EXT_ATTR12 = X_UOM_EXT_ATTR12,
UOM_EXT_ATTR13 = X_UOM_EXT_ATTR13,
UOM_EXT_ATTR14 = X_UOM_EXT_ATTR14,
UOM_EXT_ATTR15 = X_UOM_EXT_ATTR15,
UOM_EXT_ATTR16 = X_UOM_EXT_ATTR16,
UOM_EXT_ATTR17 = X_UOM_EXT_ATTR17,
UOM_EXT_ATTR18 = X_UOM_EXT_ATTR18,
UOM_EXT_ATTR19 = X_UOM_EXT_ATTR19,
UOM_EXT_ATTR20 = X_UOM_EXT_ATTR20,
D_EXT_ATTR6 = X_D_EXT_ATTR6,
D_EXT_ATTR7 = X_D_EXT_ATTR7,
D_EXT_ATTR8 = X_D_EXT_ATTR8,
D_EXT_ATTR9 = X_D_EXT_ATTR9,
D_EXT_ATTR10 = X_D_EXT_ATTR10,
REQUEST_ID = X_REQUEST_ID,
SITE_ID = X_SITE_ID,
SITE_USE_TYPE_CODE = X_SITE_USE_TYPE_CODE,
ATTR_GROUP_ID = X_ATTR_GROUP_ID,
C_EXT_ATTR1 = X_C_EXT_ATTR1,
C_EXT_ATTR2 = X_C_EXT_ATTR2,
C_EXT_ATTR3 = X_C_EXT_ATTR3,
C_EXT_ATTR4 = X_C_EXT_ATTR4,
C_EXT_ATTR5 = X_C_EXT_ATTR5,
C_EXT_ATTR6 = X_C_EXT_ATTR6,
C_EXT_ATTR7 = X_C_EXT_ATTR7,
C_EXT_ATTR8 = X_C_EXT_ATTR8,
C_EXT_ATTR9 = X_C_EXT_ATTR9,
C_EXT_ATTR10 = X_C_EXT_ATTR10,
C_EXT_ATTR11 = X_C_EXT_ATTR11,
C_EXT_ATTR12 = X_C_EXT_ATTR12,
C_EXT_ATTR13 = X_C_EXT_ATTR13,
C_EXT_ATTR14 = X_C_EXT_ATTR14,
C_EXT_ATTR15 = X_C_EXT_ATTR15,
C_EXT_ATTR16 = X_C_EXT_ATTR16,
C_EXT_ATTR17 = X_C_EXT_ATTR17,
C_EXT_ATTR18 = X_C_EXT_ATTR18,
C_EXT_ATTR19 = X_C_EXT_ATTR19,
C_EXT_ATTR20 = X_C_EXT_ATTR20,
N_EXT_ATTR1 = X_N_EXT_ATTR1,
N_EXT_ATTR2 = X_N_EXT_ATTR2,
N_EXT_ATTR3 = X_N_EXT_ATTR3,
N_EXT_ATTR4 = X_N_EXT_ATTR4,
N_EXT_ATTR5 = X_N_EXT_ATTR5,
N_EXT_ATTR6 = X_N_EXT_ATTR6,
N_EXT_ATTR7 = X_N_EXT_ATTR7,
N_EXT_ATTR8 = X_N_EXT_ATTR8,
N_EXT_ATTR9 = X_N_EXT_ATTR9,
N_EXT_ATTR10 = X_N_EXT_ATTR10,
D_EXT_ATTR1 = X_D_EXT_ATTR1,
D_EXT_ATTR2 = X_D_EXT_ATTR2,
D_EXT_ATTR3 = X_D_EXT_ATTR3,
D_EXT_ATTR4 = X_D_EXT_ATTR4,
D_EXT_ATTR5 = X_D_EXT_ATTR5,
C_EXT_ATTR21 = X_C_EXT_ATTR21,
C_EXT_ATTR22 = X_C_EXT_ATTR22,
C_EXT_ATTR23 = X_C_EXT_ATTR23,
C_EXT_ATTR24 = X_C_EXT_ATTR24,
C_EXT_ATTR25 = X_C_EXT_ATTR25,
C_EXT_ATTR26 = X_C_EXT_ATTR26,
C_EXT_ATTR27 = X_C_EXT_ATTR27,
C_EXT_ATTR28 = X_C_EXT_ATTR28,
C_EXT_ATTR29 = X_C_EXT_ATTR29,
C_EXT_ATTR30 = X_C_EXT_ATTR30,
C_EXT_ATTR31 = X_C_EXT_ATTR31,
C_EXT_ATTR32 = X_C_EXT_ATTR32,
C_EXT_ATTR33 = X_C_EXT_ATTR33,
C_EXT_ATTR34 = X_C_EXT_ATTR34,
C_EXT_ATTR35 = X_C_EXT_ATTR35,
C_EXT_ATTR36 = X_C_EXT_ATTR36,
C_EXT_ATTR37 = X_C_EXT_ATTR37,
C_EXT_ATTR38 = X_C_EXT_ATTR38,
C_EXT_ATTR39 = X_C_EXT_ATTR39,
C_EXT_ATTR40 = X_C_EXT_ATTR40,
N_EXT_ATTR11 = X_N_EXT_ATTR11,
N_EXT_ATTR12 = X_N_EXT_ATTR12,
N_EXT_ATTR13 = X_N_EXT_ATTR13,
N_EXT_ATTR14 = X_N_EXT_ATTR14,
N_EXT_ATTR15 = X_N_EXT_ATTR15,
N_EXT_ATTR16 = X_N_EXT_ATTR16,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
where EXTENSION_ID = X_EXTENSION_ID;
update RRS_SITES_EXT_TL set
TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
TL_EXT_ATTR4 = X_TL_EXT_ATTR4,
TL_EXT_ATTR5 = X_TL_EXT_ATTR5,
TL_EXT_ATTR6 = X_TL_EXT_ATTR6,
TL_EXT_ATTR7 = X_TL_EXT_ATTR7,
TL_EXT_ATTR8 = X_TL_EXT_ATTR8,
TL_EXT_ATTR9 = X_TL_EXT_ATTR9,
TL_EXT_ATTR10 = X_TL_EXT_ATTR10,
TL_EXT_ATTR11 = X_TL_EXT_ATTR11,
TL_EXT_ATTR12 = X_TL_EXT_ATTR12,
TL_EXT_ATTR13 = X_TL_EXT_ATTR13,
TL_EXT_ATTR14 = X_TL_EXT_ATTR14,
TL_EXT_ATTR15 = X_TL_EXT_ATTR15,
TL_EXT_ATTR16 = X_TL_EXT_ATTR16,
TL_EXT_ATTR17 = X_TL_EXT_ATTR17,
TL_EXT_ATTR18 = X_TL_EXT_ATTR18,
TL_EXT_ATTR19 = X_TL_EXT_ATTR19,
TL_EXT_ATTR20 = X_TL_EXT_ATTR20,
TL_EXT_ATTR21 = X_TL_EXT_ATTR21,
TL_EXT_ATTR22 = X_TL_EXT_ATTR22,
TL_EXT_ATTR23 = X_TL_EXT_ATTR23,
TL_EXT_ATTR24 = X_TL_EXT_ATTR24,
TL_EXT_ATTR25 = X_TL_EXT_ATTR25,
TL_EXT_ATTR26 = X_TL_EXT_ATTR26,
TL_EXT_ATTR27 = X_TL_EXT_ATTR27,
TL_EXT_ATTR28 = X_TL_EXT_ATTR28,
TL_EXT_ATTR29 = X_TL_EXT_ATTR29,
TL_EXT_ATTR30 = X_TL_EXT_ATTR30,
TL_EXT_ATTR31 = X_TL_EXT_ATTR31,
TL_EXT_ATTR32 = X_TL_EXT_ATTR32,
TL_EXT_ATTR33 = X_TL_EXT_ATTR33,
TL_EXT_ATTR34 = X_TL_EXT_ATTR34,
TL_EXT_ATTR35 = X_TL_EXT_ATTR35,
TL_EXT_ATTR36 = X_TL_EXT_ATTR36,
TL_EXT_ATTR37 = X_TL_EXT_ATTR37,
TL_EXT_ATTR38 = X_TL_EXT_ATTR38,
TL_EXT_ATTR39 = X_TL_EXT_ATTR39,
TL_EXT_ATTR40 = X_TL_EXT_ATTR40,
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 EXTENSION_ID = X_EXTENSION_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
end UPDATE_ROW;
procedure DELETE_ROW (
X_EXTENSION_ID in NUMBER
) is
begin
delete from RRS_SITES_EXT_TL
where EXTENSION_ID = X_EXTENSION_ID;
delete from RRS_SITES_EXT_B
where EXTENSION_ID = X_EXTENSION_ID;
end DELETE_ROW;
delete from RRS_SITES_EXT_TL T
where not exists
(select NULL
from RRS_SITES_EXT_B B
where B.EXTENSION_ID = T.EXTENSION_ID
);
update RRS_SITES_EXT_TL T set (
TL_EXT_ATTR1,
TL_EXT_ATTR2,
TL_EXT_ATTR3,
TL_EXT_ATTR4,
TL_EXT_ATTR5,
TL_EXT_ATTR6,
TL_EXT_ATTR7,
TL_EXT_ATTR8,
TL_EXT_ATTR9,
TL_EXT_ATTR10,
TL_EXT_ATTR11,
TL_EXT_ATTR12,
TL_EXT_ATTR13,
TL_EXT_ATTR14,
TL_EXT_ATTR15,
TL_EXT_ATTR16,
TL_EXT_ATTR17,
TL_EXT_ATTR18,
TL_EXT_ATTR19,
TL_EXT_ATTR20,
TL_EXT_ATTR21,
TL_EXT_ATTR22,
TL_EXT_ATTR23,
TL_EXT_ATTR24,
TL_EXT_ATTR25,
TL_EXT_ATTR26,
TL_EXT_ATTR27,
TL_EXT_ATTR28,
TL_EXT_ATTR29,
TL_EXT_ATTR30,
TL_EXT_ATTR31,
TL_EXT_ATTR32,
TL_EXT_ATTR33,
TL_EXT_ATTR34,
TL_EXT_ATTR35,
TL_EXT_ATTR36,
TL_EXT_ATTR37,
TL_EXT_ATTR38,
TL_EXT_ATTR39,
TL_EXT_ATTR40
) = (select
B.TL_EXT_ATTR1,
B.TL_EXT_ATTR2,
B.TL_EXT_ATTR3,
B.TL_EXT_ATTR4,
B.TL_EXT_ATTR5,
B.TL_EXT_ATTR6,
B.TL_EXT_ATTR7,
B.TL_EXT_ATTR8,
B.TL_EXT_ATTR9,
B.TL_EXT_ATTR10,
B.TL_EXT_ATTR11,
B.TL_EXT_ATTR12,
B.TL_EXT_ATTR13,
B.TL_EXT_ATTR14,
B.TL_EXT_ATTR15,
B.TL_EXT_ATTR16,
B.TL_EXT_ATTR17,
B.TL_EXT_ATTR18,
B.TL_EXT_ATTR19,
B.TL_EXT_ATTR20,
B.TL_EXT_ATTR21,
B.TL_EXT_ATTR22,
B.TL_EXT_ATTR23,
B.TL_EXT_ATTR24,
B.TL_EXT_ATTR25,
B.TL_EXT_ATTR26,
B.TL_EXT_ATTR27,
B.TL_EXT_ATTR28,
B.TL_EXT_ATTR29,
B.TL_EXT_ATTR30,
B.TL_EXT_ATTR31,
B.TL_EXT_ATTR32,
B.TL_EXT_ATTR33,
B.TL_EXT_ATTR34,
B.TL_EXT_ATTR35,
B.TL_EXT_ATTR36,
B.TL_EXT_ATTR37,
B.TL_EXT_ATTR38,
B.TL_EXT_ATTR39,
B.TL_EXT_ATTR40
from RRS_SITES_EXT_TL B
where B.EXTENSION_ID = T.EXTENSION_ID
and B.LANGUAGE = T.SOURCE_LANG)
where (
T.EXTENSION_ID,
T.LANGUAGE
) in (select
SUBT.EXTENSION_ID,
SUBT.LANGUAGE
from RRS_SITES_EXT_TL SUBB, RRS_SITES_EXT_TL SUBT
where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)
or (SUBB.TL_EXT_ATTR1 is not null and SUBT.TL_EXT_ATTR1 is null)
or SUBB.TL_EXT_ATTR2 <> SUBT.TL_EXT_ATTR2
or (SUBB.TL_EXT_ATTR2 is null and SUBT.TL_EXT_ATTR2 is not null)
or (SUBB.TL_EXT_ATTR2 is not null and SUBT.TL_EXT_ATTR2 is null)
or SUBB.TL_EXT_ATTR3 <> SUBT.TL_EXT_ATTR3
or (SUBB.TL_EXT_ATTR3 is null and SUBT.TL_EXT_ATTR3 is not null)
or (SUBB.TL_EXT_ATTR3 is not null and SUBT.TL_EXT_ATTR3 is null)
or SUBB.TL_EXT_ATTR4 <> SUBT.TL_EXT_ATTR4
or (SUBB.TL_EXT_ATTR4 is null and SUBT.TL_EXT_ATTR4 is not null)
or (SUBB.TL_EXT_ATTR4 is not null and SUBT.TL_EXT_ATTR4 is null)
or SUBB.TL_EXT_ATTR5 <> SUBT.TL_EXT_ATTR5
or (SUBB.TL_EXT_ATTR5 is null and SUBT.TL_EXT_ATTR5 is not null)
or (SUBB.TL_EXT_ATTR5 is not null and SUBT.TL_EXT_ATTR5 is null)
or SUBB.TL_EXT_ATTR6 <> SUBT.TL_EXT_ATTR6
or (SUBB.TL_EXT_ATTR6 is null and SUBT.TL_EXT_ATTR6 is not null)
or (SUBB.TL_EXT_ATTR6 is not null and SUBT.TL_EXT_ATTR6 is null)
or SUBB.TL_EXT_ATTR7 <> SUBT.TL_EXT_ATTR7
or (SUBB.TL_EXT_ATTR7 is null and SUBT.TL_EXT_ATTR7 is not null)
or (SUBB.TL_EXT_ATTR7 is not null and SUBT.TL_EXT_ATTR7 is null)
or SUBB.TL_EXT_ATTR8 <> SUBT.TL_EXT_ATTR8
or (SUBB.TL_EXT_ATTR8 is null and SUBT.TL_EXT_ATTR8 is not null)
or (SUBB.TL_EXT_ATTR8 is not null and SUBT.TL_EXT_ATTR8 is null)
or SUBB.TL_EXT_ATTR9 <> SUBT.TL_EXT_ATTR9
or (SUBB.TL_EXT_ATTR9 is null and SUBT.TL_EXT_ATTR9 is not null)
or (SUBB.TL_EXT_ATTR9 is not null and SUBT.TL_EXT_ATTR9 is null)
or SUBB.TL_EXT_ATTR10 <> SUBT.TL_EXT_ATTR10
or (SUBB.TL_EXT_ATTR10 is null and SUBT.TL_EXT_ATTR10 is not null)
or (SUBB.TL_EXT_ATTR10 is not null and SUBT.TL_EXT_ATTR10 is null)
or SUBB.TL_EXT_ATTR11 <> SUBT.TL_EXT_ATTR11
or (SUBB.TL_EXT_ATTR11 is null and SUBT.TL_EXT_ATTR11 is not null)
or (SUBB.TL_EXT_ATTR11 is not null and SUBT.TL_EXT_ATTR11 is null)
or SUBB.TL_EXT_ATTR12 <> SUBT.TL_EXT_ATTR12
or (SUBB.TL_EXT_ATTR12 is null and SUBT.TL_EXT_ATTR12 is not null)
or (SUBB.TL_EXT_ATTR12 is not null and SUBT.TL_EXT_ATTR12 is null)
or SUBB.TL_EXT_ATTR13 <> SUBT.TL_EXT_ATTR13
or (SUBB.TL_EXT_ATTR13 is null and SUBT.TL_EXT_ATTR13 is not null)
or (SUBB.TL_EXT_ATTR13 is not null and SUBT.TL_EXT_ATTR13 is null)
or SUBB.TL_EXT_ATTR14 <> SUBT.TL_EXT_ATTR14
or (SUBB.TL_EXT_ATTR14 is null and SUBT.TL_EXT_ATTR14 is not null)
or (SUBB.TL_EXT_ATTR14 is not null and SUBT.TL_EXT_ATTR14 is null)
or SUBB.TL_EXT_ATTR15 <> SUBT.TL_EXT_ATTR15
or (SUBB.TL_EXT_ATTR15 is null and SUBT.TL_EXT_ATTR15 is not null)
or (SUBB.TL_EXT_ATTR15 is not null and SUBT.TL_EXT_ATTR15 is null)
or SUBB.TL_EXT_ATTR16 <> SUBT.TL_EXT_ATTR16
or (SUBB.TL_EXT_ATTR16 is null and SUBT.TL_EXT_ATTR16 is not null)
or (SUBB.TL_EXT_ATTR16 is not null and SUBT.TL_EXT_ATTR16 is null)
or SUBB.TL_EXT_ATTR17 <> SUBT.TL_EXT_ATTR17
or (SUBB.TL_EXT_ATTR17 is null and SUBT.TL_EXT_ATTR17 is not null)
or (SUBB.TL_EXT_ATTR17 is not null and SUBT.TL_EXT_ATTR17 is null)
or SUBB.TL_EXT_ATTR18 <> SUBT.TL_EXT_ATTR18
or (SUBB.TL_EXT_ATTR18 is null and SUBT.TL_EXT_ATTR18 is not null)
or (SUBB.TL_EXT_ATTR18 is not null and SUBT.TL_EXT_ATTR18 is null)
or SUBB.TL_EXT_ATTR19 <> SUBT.TL_EXT_ATTR19
or (SUBB.TL_EXT_ATTR19 is null and SUBT.TL_EXT_ATTR19 is not null)
or (SUBB.TL_EXT_ATTR19 is not null and SUBT.TL_EXT_ATTR19 is null)
or SUBB.TL_EXT_ATTR20 <> SUBT.TL_EXT_ATTR20
or (SUBB.TL_EXT_ATTR20 is null and SUBT.TL_EXT_ATTR20 is not null)
or (SUBB.TL_EXT_ATTR20 is not null and SUBT.TL_EXT_ATTR20 is null)
or SUBB.TL_EXT_ATTR21 <> SUBT.TL_EXT_ATTR21
or (SUBB.TL_EXT_ATTR21 is null and SUBT.TL_EXT_ATTR21 is not null)
or (SUBB.TL_EXT_ATTR21 is not null and SUBT.TL_EXT_ATTR21 is null)
or SUBB.TL_EXT_ATTR22 <> SUBT.TL_EXT_ATTR22
or (SUBB.TL_EXT_ATTR22 is null and SUBT.TL_EXT_ATTR22 is not null)
or (SUBB.TL_EXT_ATTR22 is not null and SUBT.TL_EXT_ATTR22 is null)
or SUBB.TL_EXT_ATTR23 <> SUBT.TL_EXT_ATTR23
or (SUBB.TL_EXT_ATTR23 is null and SUBT.TL_EXT_ATTR23 is not null)
or (SUBB.TL_EXT_ATTR23 is not null and SUBT.TL_EXT_ATTR23 is null)
or SUBB.TL_EXT_ATTR24 <> SUBT.TL_EXT_ATTR24
or (SUBB.TL_EXT_ATTR24 is null and SUBT.TL_EXT_ATTR24 is not null)
or (SUBB.TL_EXT_ATTR24 is not null and SUBT.TL_EXT_ATTR24 is null)
or SUBB.TL_EXT_ATTR25 <> SUBT.TL_EXT_ATTR25
or (SUBB.TL_EXT_ATTR25 is null and SUBT.TL_EXT_ATTR25 is not null)
or (SUBB.TL_EXT_ATTR25 is not null and SUBT.TL_EXT_ATTR25 is null)
or SUBB.TL_EXT_ATTR26 <> SUBT.TL_EXT_ATTR26
or (SUBB.TL_EXT_ATTR26 is null and SUBT.TL_EXT_ATTR26 is not null)
or (SUBB.TL_EXT_ATTR26 is not null and SUBT.TL_EXT_ATTR26 is null)
or SUBB.TL_EXT_ATTR27 <> SUBT.TL_EXT_ATTR27
or (SUBB.TL_EXT_ATTR27 is null and SUBT.TL_EXT_ATTR27 is not null)
or (SUBB.TL_EXT_ATTR27 is not null and SUBT.TL_EXT_ATTR27 is null)
or SUBB.TL_EXT_ATTR28 <> SUBT.TL_EXT_ATTR28
or (SUBB.TL_EXT_ATTR28 is null and SUBT.TL_EXT_ATTR28 is not null)
or (SUBB.TL_EXT_ATTR28 is not null and SUBT.TL_EXT_ATTR28 is null)
or SUBB.TL_EXT_ATTR29 <> SUBT.TL_EXT_ATTR29
or (SUBB.TL_EXT_ATTR29 is null and SUBT.TL_EXT_ATTR29 is not null)
or (SUBB.TL_EXT_ATTR29 is not null and SUBT.TL_EXT_ATTR29 is null)
or SUBB.TL_EXT_ATTR30 <> SUBT.TL_EXT_ATTR30
or (SUBB.TL_EXT_ATTR30 is null and SUBT.TL_EXT_ATTR30 is not null)
or (SUBB.TL_EXT_ATTR30 is not null and SUBT.TL_EXT_ATTR30 is null)
or SUBB.TL_EXT_ATTR31 <> SUBT.TL_EXT_ATTR31
or (SUBB.TL_EXT_ATTR31 is null and SUBT.TL_EXT_ATTR31 is not null)
or (SUBB.TL_EXT_ATTR31 is not null and SUBT.TL_EXT_ATTR31 is null)
or SUBB.TL_EXT_ATTR32 <> SUBT.TL_EXT_ATTR32
or (SUBB.TL_EXT_ATTR32 is null and SUBT.TL_EXT_ATTR32 is not null)
or (SUBB.TL_EXT_ATTR32 is not null and SUBT.TL_EXT_ATTR32 is null)
or SUBB.TL_EXT_ATTR33 <> SUBT.TL_EXT_ATTR33
or (SUBB.TL_EXT_ATTR33 is null and SUBT.TL_EXT_ATTR33 is not null)
or (SUBB.TL_EXT_ATTR33 is not null and SUBT.TL_EXT_ATTR33 is null)
or SUBB.TL_EXT_ATTR34 <> SUBT.TL_EXT_ATTR34
or (SUBB.TL_EXT_ATTR34 is null and SUBT.TL_EXT_ATTR34 is not null)
or (SUBB.TL_EXT_ATTR34 is not null and SUBT.TL_EXT_ATTR34 is null)
or SUBB.TL_EXT_ATTR35 <> SUBT.TL_EXT_ATTR35
or (SUBB.TL_EXT_ATTR35 is null and SUBT.TL_EXT_ATTR35 is not null)
or (SUBB.TL_EXT_ATTR35 is not null and SUBT.TL_EXT_ATTR35 is null)
or SUBB.TL_EXT_ATTR36 <> SUBT.TL_EXT_ATTR36
or (SUBB.TL_EXT_ATTR36 is null and SUBT.TL_EXT_ATTR36 is not null)
or (SUBB.TL_EXT_ATTR36 is not null and SUBT.TL_EXT_ATTR36 is null)
or SUBB.TL_EXT_ATTR37 <> SUBT.TL_EXT_ATTR37
or (SUBB.TL_EXT_ATTR37 is null and SUBT.TL_EXT_ATTR37 is not null)
or (SUBB.TL_EXT_ATTR37 is not null and SUBT.TL_EXT_ATTR37 is null)
or SUBB.TL_EXT_ATTR38 <> SUBT.TL_EXT_ATTR38
or (SUBB.TL_EXT_ATTR38 is null and SUBT.TL_EXT_ATTR38 is not null)
or (SUBB.TL_EXT_ATTR38 is not null and SUBT.TL_EXT_ATTR38 is null)
or SUBB.TL_EXT_ATTR39 <> SUBT.TL_EXT_ATTR39
or (SUBB.TL_EXT_ATTR39 is null and SUBT.TL_EXT_ATTR39 is not null)
or (SUBB.TL_EXT_ATTR39 is not null and SUBT.TL_EXT_ATTR39 is null)
or SUBB.TL_EXT_ATTR40 <> SUBT.TL_EXT_ATTR40
or (SUBB.TL_EXT_ATTR40 is null and SUBT.TL_EXT_ATTR40 is not null)
or (SUBB.TL_EXT_ATTR40 is not null and SUBT.TL_EXT_ATTR40 is null)
));
insert into RRS_SITES_EXT_TL (
EXTENSION_ID,
SITE_ID,
SITE_USE_TYPE_CODE,
ATTR_GROUP_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATED_BY,
CREATION_DATE,
TL_EXT_ATTR1,
TL_EXT_ATTR2,
TL_EXT_ATTR3,
TL_EXT_ATTR4,
TL_EXT_ATTR5,
TL_EXT_ATTR6,
TL_EXT_ATTR7,
TL_EXT_ATTR8,
TL_EXT_ATTR9,
TL_EXT_ATTR10,
TL_EXT_ATTR11,
TL_EXT_ATTR12,
TL_EXT_ATTR13,
TL_EXT_ATTR14,
TL_EXT_ATTR15,
TL_EXT_ATTR16,
TL_EXT_ATTR17,
TL_EXT_ATTR18,
TL_EXT_ATTR19,
TL_EXT_ATTR20,
TL_EXT_ATTR21,
TL_EXT_ATTR22,
TL_EXT_ATTR23,
TL_EXT_ATTR24,
TL_EXT_ATTR25,
TL_EXT_ATTR26,
TL_EXT_ATTR27,
TL_EXT_ATTR28,
TL_EXT_ATTR29,
TL_EXT_ATTR30,
TL_EXT_ATTR31,
TL_EXT_ATTR32,
TL_EXT_ATTR33,
TL_EXT_ATTR34,
TL_EXT_ATTR35,
TL_EXT_ATTR36,
TL_EXT_ATTR37,
TL_EXT_ATTR38,
TL_EXT_ATTR39,
TL_EXT_ATTR40,
DATA_LEVEL_ID,
LANGUAGE,
SOURCE_LANG
) select /*+ ORDERED */
B.EXTENSION_ID,
B.SITE_ID,
B.SITE_USE_TYPE_CODE,
B.ATTR_GROUP_ID,
B.LAST_UPDATE_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_LOGIN,
B.CREATED_BY,
B.CREATION_DATE,
B.TL_EXT_ATTR1,
B.TL_EXT_ATTR2,
B.TL_EXT_ATTR3,
B.TL_EXT_ATTR4,
B.TL_EXT_ATTR5,
B.TL_EXT_ATTR6,
B.TL_EXT_ATTR7,
B.TL_EXT_ATTR8,
B.TL_EXT_ATTR9,
B.TL_EXT_ATTR10,
B.TL_EXT_ATTR11,
B.TL_EXT_ATTR12,
B.TL_EXT_ATTR13,
B.TL_EXT_ATTR14,
B.TL_EXT_ATTR15,
B.TL_EXT_ATTR16,
B.TL_EXT_ATTR17,
B.TL_EXT_ATTR18,
B.TL_EXT_ATTR19,
B.TL_EXT_ATTR20,
B.TL_EXT_ATTR21,
B.TL_EXT_ATTR22,
B.TL_EXT_ATTR23,
B.TL_EXT_ATTR24,
B.TL_EXT_ATTR25,
B.TL_EXT_ATTR26,
B.TL_EXT_ATTR27,
B.TL_EXT_ATTR28,
B.TL_EXT_ATTR29,
B.TL_EXT_ATTR30,
B.TL_EXT_ATTR31,
B.TL_EXT_ATTR32,
B.TL_EXT_ATTR33,
B.TL_EXT_ATTR34,
B.TL_EXT_ATTR35,
B.TL_EXT_ATTR36,
B.TL_EXT_ATTR37,
B.TL_EXT_ATTR38,
B.TL_EXT_ATTR39,
B.TL_EXT_ATTR40,
B.DATA_LEVEL_ID,
L.LANGUAGE_CODE,
B.SOURCE_LANG
from RRS_SITES_EXT_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
and not exists
(select NULL
from RRS_SITES_EXT_TL T
where T.EXTENSION_ID = B.EXTENSION_ID
and T.LANGUAGE = L.LANGUAGE_CODE);