APPS.EGO_ITEMCAT_VAL_TO_ID dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 42: SELECT mtl_item_catalog_groups_b_s.NEXTVAL

38: RETURN NUMBER IS
39: l_ccid NUMBER;
40: BEGIN
41:
42: SELECT mtl_item_catalog_groups_b_s.NEXTVAL
43: INTO l_ccid from dual;
44:
45: Return l_ccid;
46:

Line 63: FROM mtl_Item_Catalog_Groups_b WHERE

59: l_ccid NUMBER;
60: BEGIN
61:
62: SELECT item_catalog_group_id INTO l_ccid
63: FROM mtl_Item_Catalog_Groups_b WHERE
64: item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id;
65:
66: Return TRUE;
67:

Line 275: SELECT mtl_item_catalog_groups_b_s.nextval

271: end loop;
272:
273: IF (p_create_new)
274: THEN
275: SELECT mtl_item_catalog_groups_b_s.nextval
276: INTO ccid
277: FROM dual;
278: END IF;
279: