eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_RECIPE_HEADER_PVT dependencies on FM_FORM_MST_B

Line 736: CURSOR get_formula_no_and_vers(vFormula_id FM_FORM_MST_B.formula_id%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
738: FROM fm_form_mst_b
739: WHERE formula_id = vFormula_id;
740:

Line 738: FROM fm_form_mst_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
738: FROM fm_form_mst_b
739: WHERE formula_id = vFormula_id;
740:
741: CURSOR get_formula_id(vFormula_no FM_FORM_MST_B.formula_no%TYPE,
742: vFormula_vers FM_FORM_MST_B.formula_vers%TYPE) IS

Line 741: CURSOR get_formula_id(vFormula_no FM_FORM_MST_B.formula_no%TYPE,

737: SELECT formula_no, formula_vers
738: FROM fm_form_mst_b
739: WHERE formula_id = vFormula_id;
740:
741: CURSOR get_formula_id(vFormula_no FM_FORM_MST_B.formula_no%TYPE,
742: vFormula_vers FM_FORM_MST_B.formula_vers%TYPE) IS
743: SELECT formula_id
744: FROM fm_form_mst_b
745: WHERE formula_no = vFormula_no

Line 742: vFormula_vers FM_FORM_MST_B.formula_vers%TYPE) IS

738: FROM fm_form_mst_b
739: WHERE formula_id = vFormula_id;
740:
741: CURSOR get_formula_id(vFormula_no FM_FORM_MST_B.formula_no%TYPE,
742: vFormula_vers FM_FORM_MST_B.formula_vers%TYPE) IS
743: SELECT formula_id
744: FROM fm_form_mst_b
745: WHERE formula_no = vFormula_no
746: AND formula_vers = vFormula_vers;

Line 744: FROM fm_form_mst_b

740:
741: CURSOR get_formula_id(vFormula_no FM_FORM_MST_B.formula_no%TYPE,
742: vFormula_vers FM_FORM_MST_B.formula_vers%TYPE) IS
743: SELECT formula_id
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,

Line 774: l_old_formula_no FM_FORM_MST_B.formula_no%TYPE;

770:
771: l_recipe_header_rec GMD_RECIPE_HEADER.recipe_hdr;
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;

Line 775: l_old_formula_vers FM_FORM_MST_B.formula_vers%TYPE;

771: l_recipe_header_rec GMD_RECIPE_HEADER.recipe_hdr;
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: