APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_RECIPES_B

Line 538: l_recipe_no GMD_RECIPES_B.recipe_no%TYPE;

534: l_item_default_grade_code MTL_SYSTEM_ITEMS_B.DEFAULT_GRADE%TYPE ;
535: l_check_for_given_grade VARCHAR2(1) := 'N';
536: l_check_for_null_grade VARCHAR2(1) := 'N';
537: l_check_for_default_grade VARCHAR2(1) := 'N';
538: l_recipe_no GMD_RECIPES_B.recipe_no%TYPE;
539: l_formula_no FM_FORM_MST_B.formula_no%TYPE;
540: l_routing_no GMD_ROUTINGS_B.routing_no%TYPE;
541: l_oprn_no GMD_OPERATIONS_B.oprn_no%TYPE;
542: l_recipe_version GMD_RECIPES_B.recipe_version%TYPE;

Line 542: l_recipe_version GMD_RECIPES_B.recipe_version%TYPE;

538: l_recipe_no GMD_RECIPES_B.recipe_no%TYPE;
539: l_formula_no FM_FORM_MST_B.formula_no%TYPE;
540: l_routing_no GMD_ROUTINGS_B.routing_no%TYPE;
541: l_oprn_no GMD_OPERATIONS_B.oprn_no%TYPE;
542: l_recipe_version GMD_RECIPES_B.recipe_version%TYPE;
543: l_formula_vers FM_FORM_MST_B.formula_vers%TYPE;
544: l_routing_vers GMD_ROUTINGS_B.routing_vers%TYPE;
545: l_oprn_vers GMD_OPERATIONS_B.oprn_vers%TYPE;
546: l_step_no NUMBER(10);

Line 659: FROM GMD_RECIPES_B

655:
656: IF p_wip_spec_rec.recipe_id IS NOT NULL AND p_wip_spec_rec.recipe_no IS NULL AND p_wip_spec_rec.recipe_version IS NULL THEN
657: BEGIN
658: SELECT recipe_no,recipe_version INTO l_recipe_no,l_recipe_version
659: FROM GMD_RECIPES_B
660: WHERE recipe_id = p_wip_spec_rec.recipe_id ;
661:
662: EXCEPTION
663: WHEN OTHERS THEN