APPS.GMD_RECIPE_HEADER_PVT dependencies on GMD_ROUTINGS_B

Line 748: CURSOR get_routing_id(vRouting_no GMD_ROUTINGS_B.routing_no%TYPE,

744: FROM fm_form_mst_b
745: WHERE formula_no = vFormula_no
746: AND formula_vers = vFormula_vers;
747:
748: CURSOR get_routing_id(vRouting_no GMD_ROUTINGS_B.routing_no%TYPE,
749: vRouting_vers GMD_ROUTINGS_B.routing_vers%TYPE) IS
750: SELECT routing_id
751: FROM gmd_routings_b
752: WHERE routing_no = vRouting_no

Line 749: vRouting_vers GMD_ROUTINGS_B.routing_vers%TYPE) IS

745: WHERE formula_no = vFormula_no
746: AND formula_vers = vFormula_vers;
747:
748: CURSOR get_routing_id(vRouting_no GMD_ROUTINGS_B.routing_no%TYPE,
749: vRouting_vers GMD_ROUTINGS_B.routing_vers%TYPE) IS
750: SELECT routing_id
751: FROM gmd_routings_b
752: WHERE routing_no = vRouting_no
753: AND routing_vers = vRouting_vers;

Line 751: FROM gmd_routings_b

747:
748: CURSOR get_routing_id(vRouting_no GMD_ROUTINGS_B.routing_no%TYPE,
749: vRouting_vers GMD_ROUTINGS_B.routing_vers%TYPE) IS
750: SELECT routing_id
751: FROM gmd_routings_b
752: WHERE routing_no = vRouting_no
753: AND routing_vers = vRouting_vers;
754:
755: CURSOR get_routing_no_and_vers(vRouting_id GMD_ROUTINGS_B.routing_id%TYPE) IS

Line 755: CURSOR get_routing_no_and_vers(vRouting_id GMD_ROUTINGS_B.routing_id%TYPE) IS

751: FROM gmd_routings_b
752: WHERE routing_no = vRouting_no
753: AND routing_vers = vRouting_vers;
754:
755: CURSOR get_routing_no_and_vers(vRouting_id GMD_ROUTINGS_B.routing_id%TYPE) IS
756: SELECT routing_no, routing_vers
757: FROM gmd_routings_b
758: WHERE routing_id = vRouting_id;
759:

Line 757: FROM gmd_routings_b

753: AND routing_vers = vRouting_vers;
754:
755: CURSOR get_routing_no_and_vers(vRouting_id GMD_ROUTINGS_B.routing_id%TYPE) IS
756: SELECT routing_no, routing_vers
757: FROM gmd_routings_b
758: WHERE routing_id = vRouting_id;
759:
760: /* Defining all local variables */
761: l_api_name CONSTANT VARCHAR2(30) := 'COPY_RECIPE_HEADER';

Line 776: l_old_routing_no GMD_ROUTINGS_B.routing_no%TYPE;

772: l_recipe_hdr_flex_rec GMD_RECIPE_HEADER.flex;
773:
774: l_old_formula_no FM_FORM_MST_B.formula_no%TYPE;
775: l_old_formula_vers FM_FORM_MST_B.formula_vers%TYPE;
776: l_old_routing_no GMD_ROUTINGS_B.routing_no%TYPE;
777: l_old_routing_vers GMD_ROUTINGS_B.routing_vers%TYPE;
778: l_out_rec gmd_parameters_dtl_pkg.parameter_rec_type;
779:
780: Copy_Recipe_Err EXCEPTION;

Line 777: l_old_routing_vers GMD_ROUTINGS_B.routing_vers%TYPE;

773:
774: l_old_formula_no FM_FORM_MST_B.formula_no%TYPE;
775: l_old_formula_vers FM_FORM_MST_B.formula_vers%TYPE;
776: l_old_routing_no GMD_ROUTINGS_B.routing_no%TYPE;
777: l_old_routing_vers GMD_ROUTINGS_B.routing_vers%TYPE;
778: l_out_rec gmd_parameters_dtl_pkg.parameter_rec_type;
779:
780: Copy_Recipe_Err EXCEPTION;
781: