APPS.GMD_FORMULA_ANALYSIS dependencies on FM_FORM_MST

Line 421: FROM fm_form_mst

417: AND line_type = 1
418: AND inventory_item_id = V_item_id;
419: CURSOR Cur_get_formula(V_formula_id NUMBER) IS
420: SELECT formula_no, formula_vers
421: FROM fm_form_mst
422: WHERE formula_id = V_formula_id;
423: CURSOR get_orgn_code IS
424: SELECT organization_code
425: FROM org_access_view

Line 772: X_formula_rec fm_form_mst%ROWTYPE;

768: --
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

Line 1129: PROCEDURE get_formula(p_recipe_id IN NUMBER, x_form_mst_rec OUT NOCOPY fm_form_mst%ROWTYPE) IS

1125: -- get_formula(X_recipe_id, X_formula_id, X_formula_status,
1126: -- X_formula_no, X_formula_vers);
1127: --
1128: --===================================================================== */
1129: PROCEDURE get_formula(p_recipe_id IN NUMBER, x_form_mst_rec OUT NOCOPY fm_form_mst%ROWTYPE) IS
1130: CURSOR Cur_get_formula IS
1131: SELECT *
1132: FROM fm_form_mst
1133: WHERE formula_id = (SELECT formula_id

Line 1132: FROM fm_form_mst

1128: --===================================================================== */
1129: PROCEDURE get_formula(p_recipe_id IN NUMBER, x_form_mst_rec OUT NOCOPY fm_form_mst%ROWTYPE) IS
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