1659:
1660:
1661: PROCEDURE retrieve_recipe(p_formula_id IN NUMBER,
1662: p_routing_id IN NUMBER DEFAULT NULL,
1663: l_recipe_tbl OUT NOCOPY GMD_RECIPE_HEADER.recipe_hdr,
1664: l_recipe_flex OUT NOCOPY GMD_RECIPE_HEADER.flex,
1665: x_return_status OUT NOCOPY VARCHAR2) IS
1666:
1667: -- Cursors
1660:
1661: PROCEDURE retrieve_recipe(p_formula_id IN NUMBER,
1662: p_routing_id IN NUMBER DEFAULT NULL,
1663: l_recipe_tbl OUT NOCOPY GMD_RECIPE_HEADER.recipe_hdr,
1664: l_recipe_flex OUT NOCOPY GMD_RECIPE_HEADER.flex,
1665: x_return_status OUT NOCOPY VARCHAR2) IS
1666:
1667: -- Cursors
1668: CURSOR c_get_formula_info IS