APPS.GMD_VERSION_CONTROL dependencies on GMD_RECIPES

Line 799: FROM gmd_recipes

795: -- Bug #2673008 (JKB) Added l_text_code above.
796:
797: CURSOR Cur_get_hdr IS
798: SELECT *
799: FROM gmd_recipes
800: WHERE recipe_id = p_recipe_id;
801: X_hdr_rec Cur_get_hdr%ROWTYPE;
802:
803: CURSOR Cur_process_loss IS

Line 854: FROM gmd_recipes

850: X_stepmtl_tbl step_mtl;
851:
852: CURSOR Cur_recipe_vers IS
853: SELECT MAX(recipe_version) + 1
854: FROM gmd_recipes
855: WHERE recipe_no = X_hdr_rec.recipe_no;
856: CURSOR Cur_recipe_id IS
857: SELECT gmd_recipe_id_s.NEXTVAL
858: FROM FND_DUAL;

Line 862: FROM gmd_recipes_b

858: FROM FND_DUAL;
859:
860: CURSOR Cur_get_old_recipe_det (V_recipe_id NUMBER) IS
861: SELECT formula_id, routing_id
862: FROM gmd_recipes_b
863: WHERE recipe_id = v_recipe_id;
864:
865: l_msg_count NUMBER;
866: l_msg_data VARCHAR2(2000);

Line 945: gmd_recipes_mls.insert_row(X_ROWID => l_rowid,

941: ELSE
942: l_text_code := NULL;
943: END IF;
944: -- Bug #2673008 (JKB) Added call to copy_text above.
945: gmd_recipes_mls.insert_row(X_ROWID => l_rowid,
946: X_RECIPE_ID => x_recipe_id,
947: X_OWNER_ID => X_hdr_rec.owner_id,
948: X_OWNER_LAB_TYPE => X_hdr_rec.owner_lab_type,
949: X_DELETE_MARK => 0,