APPS.EGO_CATALOG_GROUP_UTIL dependencies on EGO_BROWSE_PVT

Line 304: EGO_BROWSE_PVT.Sync_ICG_Denorm_Hier_Table

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.
304: EGO_BROWSE_PVT.Sync_ICG_Denorm_Hier_Table
305: (p_catalog_group_id => EGO_Globals.G_Catalog_Group_Rec.catalog_group_id
306: ,p_old_parent_id => NULL
307: ,x_return_status => x_return_status
308: );

Line 455: EGO_BROWSE_PVT.Sync_ICG_Denorm_Hier_Table

451: END IF;
452:
453: IF NVL(l_old_parent_id,-1) <>
454: NVL(EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id,-1) THEN
455: EGO_BROWSE_PVT.Sync_ICG_Denorm_Hier_Table
456: (p_catalog_group_id => EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id
457: ,p_old_parent_id => l_old_parent_id
458: ,x_return_status => x_return_status
459: );

Line 506: EGO_BROWSE_PVT.Reload_ICG_Denorm_Hier_Table (x_return_status => x_return_status);

502:
503: DELETE FROM mtl_item_catalog_groups_b WHERE
504: item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;
505:
506: EGO_BROWSE_PVT.Reload_ICG_Denorm_Hier_Table (x_return_status => x_return_status);
507:
508: EXCEPTION WHEN OTHERS
509: THEN
510: -- dbms_output.put_line('Error while deleting : ' || SQLERRM);