952: AND line_type = -1;
953:
954: CURSOR Cur_get_total_input IS
955: SELECT total_input_qty, yield_uom
956: FROM fm_form_mst
957: WHERE formula_id = p_formula_id;
958: l_formula_input NUMBER := 0;
959: l_fixed_ingred NUMBER := 0;
960: l_batch_input NUMBER := 0;
1557: x_scale_factor OUT NOCOPY NUMBER,
1558: x_return_status OUT NOCOPY VARCHAR2) IS
1559: CURSOR Cur_get_tot_qty IS
1560: SELECT f.formula_id, total_output_qty, yield_uom
1561: FROM fm_form_mst_b f, gmd_recipes_b r
1562: WHERE r.recipe_id = p_recipe_id
1563: AND r.formula_id = f.formula_id;
1564:
1565: l_form_rec Cur_get_tot_qty%ROWTYPE;