APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_RECIPES

Line 602: FROM gmd_recipes

598: X_cnt NUMBER; --Bug 3037410 Mohit Kapoor
599:
600: CURSOR Cur_get_hdr IS
601: SELECT *
602: FROM gmd_recipes
603: WHERE recipe_id = p_recipe_id;
604: X_hdr_rec Cur_get_hdr%ROWTYPE;
605:
606: CURSOR Cur_process_loss IS

Line 658: FROM gmd_recipes

654: X_stepmtl_tbl step_mtl;
655:
656: CURSOR Cur_recipe_vers IS
657: SELECT MAX(recipe_version) + 1
658: FROM gmd_recipes
659: WHERE recipe_no = X_hdr_rec.recipe_no;
660: CURSOR Cur_recipe_id IS
661: SELECT gmd_recipe_id_s.NEXTVAL
662: FROM FND_DUAL;

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

731:
732: OPEN Cur_recipe_id;
733: FETCH Cur_recipe_id INTO x_recipe_id;
734: CLOSE Cur_recipe_id;
735: gmd_recipes_mls.insert_row(X_ROWID => l_rowid,
736: X_RECIPE_ID => x_recipe_id,
737: X_OWNER_ID => NVL(powner_id,X_hdr_rec.owner_id),
738: X_OWNER_LAB_TYPE => X_hdr_rec.owner_lab_type,
739: X_DELETE_MARK => 0,