The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert into MTL_CATEGORY_SETS_TL (
CATEGORY_SET_ID,
LANGUAGE,
SOURCE_LANG,
CATEGORY_SET_NAME,
DESCRIPTION,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN
) select
X_CATEGORY_SET_ID,
L.LANGUAGE_CODE,
TL.SOURCE_LANG,
TL.CATEGORY_SET_NAME,
TL.DESCRIPTION,
TL.LAST_UPDATE_DATE,
TL.LAST_UPDATED_BY,
TL.CREATION_DATE,
TL.CREATED_BY,
TL.LAST_UPDATE_LOGIN
from FND_LANGUAGES L, MTL_CATEGORY_SETS_TL TL
where L.INSTALLED_FLAG in ('I', 'B')
and TL.CATEGORY_SET_ID = X_CATEGORY_SET_ID
and not exists
( select NULL
from MTL_CATEGORY_SETS_TL T
where T.CATEGORY_SET_ID = X_CATEGORY_SET_ID
and T.LANGUAGE = L.LANGUAGE_CODE );
insert into MTL_CATEGORIES_TL (
CATEGORY_ID,
LANGUAGE,
SOURCE_LANG,
DESCRIPTION,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN
) select
X_CATEGORY_ID,
L.LANGUAGE_CODE,
TL.SOURCE_LANG,
TL.DESCRIPTION,
TL.LAST_UPDATE_DATE,
TL.LAST_UPDATED_BY,
TL.CREATION_DATE,
TL.CREATED_BY,
TL.LAST_UPDATE_LOGIN
from FND_LANGUAGES L, MTL_CATEGORIES_TL TL
where L.INSTALLED_FLAG in ('I', 'B')
and TL.CATEGORY_ID = X_CATEGORY_ID
and not exists
( select NULL
from MTL_CATEGORIES_TL T
where T.CATEGORY_ID = X_CATEGORY_ID
and T.LANGUAGE = L.LANGUAGE_CODE );
insert into MTL_ITEM_CATALOG_GROUPS_TL (
ITEM_CATALOG_GROUP_ID,
LANGUAGE,
SOURCE_LANG,
DESCRIPTION,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN
) select
X_ITEM_CATALOG_GROUP_ID,
L.LANGUAGE_CODE,
TL.SOURCE_LANG,
TL.DESCRIPTION,
TL.LAST_UPDATE_DATE,
TL.LAST_UPDATED_BY,
TL.CREATION_DATE,
TL.CREATED_BY,
TL.LAST_UPDATE_LOGIN
from FND_LANGUAGES L, MTL_ITEM_CATALOG_GROUPS_TL TL
where L.INSTALLED_FLAG in ('I', 'B')
and TL.ITEM_CATALOG_GROUP_ID = X_ITEM_CATALOG_GROUP_ID
and not exists
( select NULL
from MTL_ITEM_CATALOG_GROUPS_TL T
where T.ITEM_CATALOG_GROUP_ID = X_ITEM_CATALOG_GROUP_ID
and T.LANGUAGE = L.LANGUAGE_CODE );