DBA Data[Home] [Help]

APPS.FEM_DIM_ATTRIBUTES_UTIL_PKG dependencies on FND_LOOKUP_VALUES

Line 184: /* Validate that the Attribute Order Type Code exists in FND_LOOKUP_VALUES */

180: IF v_count > 0 THEN
181: RAISE e_existing_attr_name;
182: END IF; /* attr_name validation */
183:
184: /* Validate that the Attribute Order Type Code exists in FND_LOOKUP_VALUES */
185: SELECT count(*)
186: INTO v_count
187: FROM fnd_lookup_values
188: WHERE lookup_type = 'FEM_ATTRIBUTE_ORDER_TYPE_DSC'

Line 187: FROM fnd_lookup_values

183:
184: /* Validate that the Attribute Order Type Code exists in FND_LOOKUP_VALUES */
185: SELECT count(*)
186: INTO v_count
187: FROM fnd_lookup_values
188: WHERE lookup_type = 'FEM_ATTRIBUTE_ORDER_TYPE_DSC'
189: AND lookup_code = p_attr_order_type_code;
190:
191: IF v_count = 0 THEN