APPS.PA_PLANNING_RESOURCE_UTILS dependencies on FND_FLEX_EXT

Line 1115: AND fnd_Flex_ext.GET_SEGS('INV', 'MCAT', c.structure_id, c.category_id) =

1111: FROM mtl_categories_b c, mtl_category_set_valid_cats I
1112: WHERE i.category_set_id = p_item_category_set_id
1113: AND i.category_id = c.category_id
1114: AND nvl(c.disable_date,sysdate) >= sysdate
1115: AND fnd_Flex_ext.GET_SEGS('INV', 'MCAT', c.structure_id, c.category_id) =
1116: p_item_cat_name;
1117: --AND c.description = p_item_cat_name;
1118:
1119: BEGIN

Line 1188: AND fnd_Flex_ext.GET_SEGS('INV', 'MCAT', c.structure_id, c.category_id) = p_item_cat_name;

1184: FROM mtl_categories_b c, mtl_category_set_valid_cats I
1185: WHERE i.category_set_id = p_item_category_set_id
1186: AND i.category_id = c.category_id
1187: AND nvl(c.disable_date,sysdate) >= sysdate
1188: AND fnd_Flex_ext.GET_SEGS('INV', 'MCAT', c.structure_id, c.category_id) = p_item_cat_name;
1189: -- AND c.description = p_item_cat_name;
1190: EXCEPTION
1191: WHEN OTHERS THEN
1192: x_item_category_id := NULL;

Line 2973: Select fnd_Flex_ext.GET_SEGS('INV', 'MCAT', c.structure_id, c.category_id)

2969: Where
2970: Resource_Id = P_BOM_Res_Id;
2971:
2972: Cursor c_Item_Cat ( P_Item_Cat_Id IN Number ) Is
2973: Select fnd_Flex_ext.GET_SEGS('INV', 'MCAT', c.structure_id, c.category_id)
2974: From mtl_categories_v c
2975: Where c.Category_Id = P_Item_Cat_Id;
2976:
2977: /**********************************************************