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

Line 65: l_formula_id fm_form_mst.formula_id%TYPE := 0;

61: /* Recipe variables */
62: l_recipe_id gmd_recipes.recipe_id%TYPE := 0;
63:
64: /* Formula variables */
65: l_formula_id fm_form_mst.formula_id%TYPE := 0;
66: l_formula_no fm_form_mst.formula_no%TYPE;
67: l_formula_vers fm_form_mst.formula_vers%TYPE;
68:
69: /* Routing variables */

Line 66: l_formula_no fm_form_mst.formula_no%TYPE;

62: l_recipe_id gmd_recipes.recipe_id%TYPE := 0;
63:
64: /* Formula variables */
65: l_formula_id fm_form_mst.formula_id%TYPE := 0;
66: l_formula_no fm_form_mst.formula_no%TYPE;
67: l_formula_vers fm_form_mst.formula_vers%TYPE;
68:
69: /* Routing variables */
70: l_routing_id fm_rout_hdr.routing_id%TYPE := 0;

Line 67: l_formula_vers fm_form_mst.formula_vers%TYPE;

63:
64: /* Formula variables */
65: l_formula_id fm_form_mst.formula_id%TYPE := 0;
66: l_formula_no fm_form_mst.formula_no%TYPE;
67: l_formula_vers fm_form_mst.formula_vers%TYPE;
68:
69: /* Routing variables */
70: l_routing_id fm_rout_hdr.routing_id%TYPE := 0;
71: l_routing_no fm_rout_hdr.routing_no%TYPE;

Line 364: l_formula_id fm_form_mst.formula_id%TYPE := 0;

360: l_meaning GMD_STATUS.meaning%TYPE;
361: l_description GMD_STATUS.description%TYPE;
362:
363: /* Formula variables */
364: l_formula_id fm_form_mst.formula_id%TYPE := 0;
365: l_formula_no fm_form_mst.formula_no%TYPE;
366: l_formula_vers fm_form_mst.formula_vers%TYPE;
367:
368: /* Routing variables */

Line 365: l_formula_no fm_form_mst.formula_no%TYPE;

361: l_description GMD_STATUS.description%TYPE;
362:
363: /* Formula variables */
364: l_formula_id fm_form_mst.formula_id%TYPE := 0;
365: l_formula_no fm_form_mst.formula_no%TYPE;
366: l_formula_vers fm_form_mst.formula_vers%TYPE;
367:
368: /* Routing variables */
369: l_routing_id fm_rout_hdr.routing_id%TYPE := 0;

Line 366: l_formula_vers fm_form_mst.formula_vers%TYPE;

362:
363: /* Formula variables */
364: l_formula_id fm_form_mst.formula_id%TYPE := 0;
365: l_formula_no fm_form_mst.formula_no%TYPE;
366: l_formula_vers fm_form_mst.formula_vers%TYPE;
367:
368: /* Routing variables */
369: l_routing_id fm_rout_hdr.routing_id%TYPE := 0;
370: l_routing_no fm_rout_hdr.routing_no%TYPE;

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: