APPS.GMDFMVAL_PUB dependencies on GMD_RECIPES

Line 636: gmd_recipes_b rcp,

632: /* =================== */
633: CURSOR locked_val IS
634: SELECT rcp.formula_id
635: FROM gmd_recipe_validity_rules vr,
636: gmd_recipes_b rcp,
637: cm_cmpt_dtl cost
638: WHERE rcp.formula_id = pformula_id
639: AND vr.recipe_validity_rule_id = cost.fmeff_id
640: AND vr.recipe_id = rcp.recipe_id

Line 856: /* get the formula_id from gmd_recipes table */

852: END IF; /* End for formulaline condition */
853:
854: IF (pElement_name = 'RECIPE') THEN
855:
856: /* get the formula_id from gmd_recipes table */
857: IF (pRecord_in.Recipe_id IS NOT NULL) THEN
858: -- get the formula id
859:
860: Select formula_id

Line 862: From gmd_recipes

858: -- get the formula id
859:
860: Select formula_id
861: INTO l_formula_id
862: From gmd_recipes
863: Where recipe_id = pRecord_in.Recipe_id;
864:
865: OPEN get_formula_no(l_formula_id);
866: FETCH get_formula_no

Line 917: /* get the formula_id from gmd_recipes table */

913: xReturn := 'S';
914:
915: IF (pElement_name = 'RECIPE') THEN
916:
917: /* get the formula_id from gmd_recipes table */
918: IF (pRecord_in.Recipe_id IS NOT NULL) THEN
919: -- get the formula id
920:
921: SELECT formula_id

Line 923: FROM gmd_recipes

919: -- get the formula id
920:
921: SELECT formula_id
922: INTO l_formula_id
923: FROM gmd_recipes
924: WHERE recipe_id = pRecord_in.Recipe_id;
925:
926: -- Call substitute item codeset, Bug 4479101
927: get_substitute_items(pFormula_id => l_formula_id,