APPS.EGO_TL_LANG_ENABLE_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_TL

Line 93: insert into MTL_ITEM_CATALOG_GROUPS_TL (

89: begin
90:
91: --insert new row in all installed languages in the TL table
92: --IF no rows in those installed languages already exist
93: insert into MTL_ITEM_CATALOG_GROUPS_TL (
94: ITEM_CATALOG_GROUP_ID,
95: LANGUAGE,
96: SOURCE_LANG,
97: DESCRIPTION,

Line 113: from FND_LANGUAGES L, MTL_ITEM_CATALOG_GROUPS_TL TL

109: TL.LAST_UPDATED_BY,
110: TL.CREATION_DATE,
111: TL.CREATED_BY,
112: TL.LAST_UPDATE_LOGIN
113: from FND_LANGUAGES L, MTL_ITEM_CATALOG_GROUPS_TL TL
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and TL.ITEM_CATALOG_GROUP_ID = X_ITEM_CATALOG_GROUP_ID
116: and not exists
117: ( select NULL

Line 118: from MTL_ITEM_CATALOG_GROUPS_TL T

114: where L.INSTALLED_FLAG in ('I', 'B')
115: and TL.ITEM_CATALOG_GROUP_ID = X_ITEM_CATALOG_GROUP_ID
116: and not exists
117: ( select NULL
118: from MTL_ITEM_CATALOG_GROUPS_TL T
119: where T.ITEM_CATALOG_GROUP_ID = X_ITEM_CATALOG_GROUP_ID
120: and T.LANGUAGE = L.LANGUAGE_CODE );
121:
122: end handle_catgroup_language_rows;