APPS.GMD_FORMULA_ANALYSIS dependencies on GMD_RECIPES

Line 773: X_recipe_rec gmd_recipes%ROWTYPE;

769: --===================================================================== */
770: PROCEDURE get_valid_formula(p_recipe_use NUMBER, p_vr_status VARCHAR2, p_status VARCHAR2, x_formula_id OUT NOCOPY NUMBER,
771: x_formula_no OUT NOCOPY VARCHAR2, x_formula_vers OUT NOCOPY NUMBER, x_found OUT NOCOPY NUMBER) IS
772: X_formula_rec fm_form_mst%ROWTYPE;
773: X_recipe_rec gmd_recipes%ROWTYPE;
774: BEGIN
775: x_found := 0;
776: FOR i IN 1..P_vrules_tab.count LOOP
777: IF (P_vrules_tab(i).recipe_use = p_recipe_use AND INSTR(p_vr_status,SUBSTR(P_vrules_tab(i).validity_rule_status,1,1)) > 0) THEN

Line 1134: FROM gmd_recipes

1130: CURSOR Cur_get_formula IS
1131: SELECT *
1132: FROM fm_form_mst
1133: WHERE formula_id = (SELECT formula_id
1134: FROM gmd_recipes
1135: WHERE recipe_id = p_recipe_id);
1136: BEGIN
1137: OPEN Cur_get_formula;
1138: FETCH Cur_get_formula INTO x_form_mst_rec;

Line 1157: PROCEDURE get_recipe(p_recipe_id IN NUMBER, x_recipe_rec OUT NOCOPY gmd_recipes%ROWTYPE) IS

1153: -- get_recipe(X_recipe_id, X_recipe_status,
1154: -- X_recipe_no, X_recipe_vers);
1155: --
1156: --===================================================================== */
1157: PROCEDURE get_recipe(p_recipe_id IN NUMBER, x_recipe_rec OUT NOCOPY gmd_recipes%ROWTYPE) IS
1158: CURSOR Cur_get_recipe IS
1159: SELECT *
1160: FROM gmd_recipes
1161: WHERE recipe_id = p_recipe_id;

Line 1160: FROM gmd_recipes

1156: --===================================================================== */
1157: PROCEDURE get_recipe(p_recipe_id IN NUMBER, x_recipe_rec OUT NOCOPY gmd_recipes%ROWTYPE) IS
1158: CURSOR Cur_get_recipe IS
1159: SELECT *
1160: FROM gmd_recipes
1161: WHERE recipe_id = p_recipe_id;
1162: BEGIN
1163: OPEN Cur_get_recipe;
1164: FETCH Cur_get_recipe INTO x_recipe_rec;