152: x_msg_data OUT NOCOPY VARCHAR2
153: );
154:
155: PROCEDURE Calculate_Total_Qty
156: ( formula_id IN GMD_RECIPES.Formula_id%TYPE ,
157: x_product_qty OUT NOCOPY NUMBER ,
158: x_ingredient_qty OUT NOCOPY NUMBER ,
159: x_uom IN OUT NOCOPY VARCHAR2 ,
160: x_return_status OUT NOCOPY VARCHAR2 ,
215: pRevision IN VARCHAR2 DEFAULT NULL);
216:
217: -- Kapil ME Auto-Prod Bug# 5716318
218: -- Added the Procedure.
219: PROCEDURE Calculate_Total_Product_Qty ( p_formula_id IN gmd_recipes.formula_id%TYPE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2);
223: END; /* Package Specification GMD_COMMON_VAL*/