APPS.EGO_CATALOG_GROUP_UTIL dependencies on MTL_ITEM_CATALOG_GROUPS_TL

Line 277: INSERT INTO Mtl_Item_Catalog_Groups_TL

273: ** Insert data into the translation table
274: **
275: ** ---------------------------------------------------------------*/
276:
277: INSERT INTO Mtl_Item_Catalog_Groups_TL
278: ( Item_Catalog_Group_Id
279: , Language
280: , Source_Lang
281: , Created_By

Line 299: FROM Mtl_Item_Catalog_Groups_tl TL

295: FROM FND_LANGUAGES lang
296: WHERE lang.installed_flag in ('I', 'B')
297: AND NOT EXISTS
298: ( SELECT NULL
299: FROM Mtl_Item_Catalog_Groups_tl TL
300: WHERE tl.item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id
301: AND tl.language = lang.language_code
302: );
303: -- call the sync Catalog Group function.

Line 408: UPDATE Mtl_Item_Catalog_Groups_TL

404:
405:
406: /* Update the TL table description */
407:
408: UPDATE Mtl_Item_Catalog_Groups_TL
409: SET description = EGO_Globals.G_Catalog_Group_Rec.description
410: , last_updated_by = FND_Global.User_Id
411: , last_update_date = SYSDATE
412: WHERE item_catalog_group_id =

Line 497: DELETE FROM mtl_item_catalog_groups_tl WHERE

493: BEGIN
494:
495: /* Delete from TL */
496:
497: DELETE FROM mtl_item_catalog_groups_tl WHERE
498: item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id
499: AND LANGUAGE = EGO_Globals.Get_Language_Code;
500:
501: /* Delete from base table */