DBA Data[Home] [Help]

APPS.GMD_RECIPE_HEADER_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 404: FROM gmd_recipe_validity_rules a

400: AND b.formula_id <>vFormula_id ;
401:
402: CURSOR Cur_get_formula_val(vRecipe_id NUMBER, vFormula_id NUMBER) IS
403: SELECT 1
404: FROM gmd_recipe_validity_rules a
405: WHERE a.recipe_id = vRecipe_id
406: AND item_id not in (select item_id
407: from fm_matl_dtl
408: where line_type = 1

Line 609: update GMD_RECIPE_VALIDITY_RULES

605: # While the recipe is deleted set the
606: # validity rules as deleted.
607: -------------------------------------------*/
608: IF p_recipe_header_rec.delete_mark =1 then
609: update GMD_RECIPE_VALIDITY_RULES
610: set DELETE_MARK = p_recipe_header_rec.delete_mark
611: WHERE recipe_id = p_recipe_header_rec.recipe_id;
612: END IF;
613:

Line 658: delete from gmd_recipe_validity_rules

654:
655: END IF;
656:
657: IF l_delValRule THEN
658: delete from gmd_recipe_validity_rules
659: where recipe_id =p_recipe_header_rec.recipe_id;
660: END IF;
661: --End bug 5138316 KSHUKLA
662: