APPS.EGO_ITEM_CATALOG_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 68: l_parent_group_id mtl_item_catalog_groups_b.parent_catalog_group_id%TYPE;

64: FUNCTION is_parent_updated (p_catalog_group_id IN NUMBER,
65: p_parent_group_id IN NUMBER,
66: p_parent_group_name IN VARCHAR2) RETURN BOOLEAN IS
67:
68: l_parent_group_id mtl_item_catalog_groups_b.parent_catalog_group_id%TYPE;
69: l_parent_group_name mtl_item_catalog_groups_v.catalog_concat_segs%TYPE;
70:
71: CURSOR c IS
72: SELECT parent.item_catalog_group_id, parent.catalog_concat_segs

Line 73: FROM mtl_item_catalog_groups_b cat,

69: l_parent_group_name mtl_item_catalog_groups_v.catalog_concat_segs%TYPE;
70:
71: CURSOR c IS
72: SELECT parent.item_catalog_group_id, parent.catalog_concat_segs
73: FROM mtl_item_catalog_groups_b cat,
74: mtl_item_catalog_groups_v parent
75: WHERE cat.item_catalog_group_id = p_catalog_group_id
76: AND cat.parent_catalog_group_id = parent.item_catalog_group_id ;
77:

Line 154: item_catalog_group_id = (SELECT item_catalog_group_id FROM mtl_item_catalog_groups_b WHERE segment1=EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name)

150:
151: if profile_value = 'Y' AND EGO_Globals.G_Catalog_Group_Rec.transaction_type = Ego_Globals.G_OPR_UPDATE THEN
152: SELECT Count(*) INTO version_count FROM EGO_MTL_CATALOG_GRP_VERS_B
153: WHERE
154: item_catalog_group_id = (SELECT item_catalog_group_id FROM mtl_item_catalog_groups_b WHERE segment1=EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name)
155: AND version_seq_id>0;
156: --dbms_output.put_line('Processing catalog group id: '||EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name ||' version count: ' || version_count);
157: if VERSION_COUNT <> 0 THEN
158: x_return_status := 'U';