APPS.EGO_CATALOG_GROUP_UTIL dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 170: INSERT INTO mtl_Item_Catalog_Groups_b

166:
167: Error_Handler.Write_Debug('Inserting Catalog Group . . . ');
168: -- dbms_output.put_line('Inserting Catalog Group . . . ID' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_id);
169:
170: INSERT INTO mtl_Item_Catalog_Groups_b
171: ( item_catalog_group_id
172: , parent_catalog_group_id
173: , summary_flag
174: , enabled_flag

Line 342: SELECT item_catalog_group_id FROM mtl_item_catalog_groups_b

338:
339: l_old_parent_id NUMBER;
340:
341: CURSOR c1(p_item_catalog_group_id NUMBER) IS
342: SELECT item_catalog_group_id FROM mtl_item_catalog_groups_b
343: CONNECT BY PRIOR item_catalog_group_id = parent_catalog_group_id
344: START WITH item_catalog_group_id = p_item_catalog_group_id;
345:
346: BEGIN

Line 356: FROM mtl_item_catalog_groups_b

352: Error_Handler.Write_Debug('Updating catalog group . . . ');
353:
354: SELECT parent_catalog_group_id
355: INTO l_old_parent_id
356: FROM mtl_item_catalog_groups_b
357: WHERE item_catalog_group_id =
358: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;
359:
360: UPDATE mtl_item_catalog_groups_b

Line 360: UPDATE mtl_item_catalog_groups_b

356: FROM mtl_item_catalog_groups_b
357: WHERE item_catalog_group_id =
358: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;
359:
360: UPDATE mtl_item_catalog_groups_b
361: SET Item_Creation_Allowed_Flag = EGO_Globals.G_Catalog_Group_Rec.Item_Creation_Allowed_Flag
362: , parent_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
363: , Segment1 = EGO_Item_Catalog_Pub.G_KF_Segment_Values(1)
364: , Segment2 = EGO_Item_Catalog_Pub.G_KF_Segment_Values(2)

Line 431: UPDATE mtl_item_catalog_groups_b

427: THEN
428: /* Propagate the new end date to all the recursive childs of this catalog */
429: FOR r1 IN c1(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id)
430: LOOP
431: UPDATE mtl_item_catalog_groups_b
432: SET inactive_date = EGO_Globals.G_Catalog_Group_Rec.inactive_date
433: WHERE item_catalog_group_id = r1.item_catalog_group_id;
434: END LOOP;
435: END IF;

Line 445: UPDATE mtl_item_catalog_groups_b

441: THEN
442: /* Propagate null (remove end date) to all the recursive childs */
443: FOR r1 IN c1(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id)
444: LOOP
445: UPDATE mtl_item_catalog_groups_b
446: SET inactive_date = null
447: WHERE item_catalog_group_id = r1.item_catalog_group_id;
448: END LOOP;
449: END IF;

Line 503: DELETE FROM mtl_item_catalog_groups_b WHERE

499: AND LANGUAGE = EGO_Globals.Get_Language_Code;
500:
501: /* Delete from base table */
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: