APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on GMD_OPERATIONS_B

Line 596: l_oprn_no GMD_OPERATIONS_B.oprn_no%TYPE;

592: l_check_for_default_grade VARCHAR2(1) := 'N';
593: l_recipe_no GMD_RECIPES_B.recipe_no%TYPE;
594: l_formula_no FM_FORM_MST_B.formula_no%TYPE;
595: l_routing_no GMD_ROUTINGS_B.routing_no%TYPE;
596: l_oprn_no GMD_OPERATIONS_B.oprn_no%TYPE;
597: l_recipe_version GMD_RECIPES_B.recipe_version%TYPE;
598: l_formula_vers FM_FORM_MST_B.formula_vers%TYPE;
599: l_routing_vers GMD_ROUTINGS_B.routing_vers%TYPE;
600: l_oprn_vers GMD_OPERATIONS_B.oprn_vers%TYPE;

Line 600: l_oprn_vers GMD_OPERATIONS_B.oprn_vers%TYPE;

596: l_oprn_no GMD_OPERATIONS_B.oprn_no%TYPE;
597: l_recipe_version GMD_RECIPES_B.recipe_version%TYPE;
598: l_formula_vers FM_FORM_MST_B.formula_vers%TYPE;
599: l_routing_vers GMD_ROUTINGS_B.routing_vers%TYPE;
600: l_oprn_vers GMD_OPERATIONS_B.oprn_vers%TYPE;
601: l_step_no NUMBER(10);
602:
603: REQ_FIELDS_MISSING EXCEPTION;
604: INVALID_ITEM EXCEPTION;

Line 722: FROM gmd_operations_b

718:
719: IF p_wip_spec_rec.oprn_id IS NOT NULL AND p_wip_spec_rec.oprn_no IS NULL AND p_wip_spec_rec.oprn_vers IS NULL THEN
720: BEGIN
721: SELECT oprn_no,oprn_vers INTO l_oprn_no,l_oprn_vers
722: FROM gmd_operations_b
723: WHERE oprn_id = p_wip_spec_rec.oprn_id;
724:
725: EXCEPTION
726: WHEN OTHERS THEN