APPS.GMD_RECIPE_HEADER_PVT dependencies on GMD_RECIPES_B

Line 720: ( p_old_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE ,

716: /* End of comments */
717: /* ===================================================*/
718:
719: PROCEDURE COPY_RECIPE_HEADER
720: ( p_old_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE ,
721: p_recipe_header_rec IN GMD_RECIPE_HEADER.recipe_hdr ,
722: p_recipe_hdr_flex_rec IN GMD_RECIPE_HEADER.flex ,
723: x_return_status OUT NOCOPY VARCHAR2
724: ) IS

Line 726: CURSOR get_old_recipe_record(vRecipe_id GMD_RECIPES_B.recipe_id%TYPE) IS

722: p_recipe_hdr_flex_rec IN GMD_RECIPE_HEADER.flex ,
723: x_return_status OUT NOCOPY VARCHAR2
724: ) IS
725:
726: CURSOR get_old_recipe_record(vRecipe_id GMD_RECIPES_B.recipe_id%TYPE) IS
727: SELECT *
728: FROM gmd_recipes
729: WHERE recipe_id = vRecipe_id;
730:

Line 731: CURSOR get_next_recipe_version (vRecipe_no GMD_RECIPES_B.recipe_no%TYPE) IS

727: SELECT *
728: FROM gmd_recipes
729: WHERE recipe_id = vRecipe_id;
730:
731: CURSOR get_next_recipe_version (vRecipe_no GMD_RECIPES_B.recipe_no%TYPE) IS
732: SELECT max(Recipe_version) + 1
733: FROM gmd_recipes_b
734: WHERE Recipe_no = vRecipe_no;
735:

Line 733: FROM gmd_recipes_b

729: WHERE recipe_id = vRecipe_id;
730:
731: CURSOR get_next_recipe_version (vRecipe_no GMD_RECIPES_B.recipe_no%TYPE) IS
732: SELECT max(Recipe_version) + 1
733: FROM gmd_recipes_b
734: WHERE Recipe_no = vRecipe_no;
735:
736: CURSOR get_formula_no_and_vers(vFormula_id FM_FORM_MST_B.formula_id%TYPE) IS
737: SELECT formula_no, formula_vers