APPS.PA_PLANNING_RESOURCE_UTILS dependencies on FND_FLEX_EXT

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

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

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

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

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

3010: Where
3011: Resource_Id = P_BOM_Res_Id;
3012:
3013: Cursor c_Item_Cat ( P_Item_Cat_Id IN Number ) Is
3014: Select fnd_Flex_ext.GET_SEGS('INV', 'MCAT', c.structure_id, c.category_id)
3015: From mtl_categories_v c
3016: Where c.Category_Id = P_Item_Cat_Id;
3017:
3018: /**********************************************************