APPS.GMD_RECIPE_HEADER_PVT dependencies on GMD_RECIPE_VAL

Line 96: l_val_rt_status := gmd_recipe_val.check_routing_validity

92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93: -- Bug 2099699. Sukarna Reddy dt 02/19/02.
94: -- Check if proper routing is associated with recipe
95: IF (p_recipe_header_rec.routing_id IS NOT NULL) THEN
96: l_val_rt_status := gmd_recipe_val.check_routing_validity
97: (p_recipe_header_rec.routing_id,
98: NVL(p_recipe_header_rec.recipe_Status,
99: '100'));
100: IF (NOT l_val_rt_status) THEN

Line 124: GMD_RECIPE_VAL.recipe_name

120: /* Based on Recipe_no and */
121: /* Recipe_version check if a recipe */
122: /* already exists in the database */
123: /* ================================= */
124: GMD_RECIPE_VAL.recipe_name
125: ( p_api_version => 1.0,
126: p_init_msg_list => FND_API.G_FALSE,
127: p_commit => FND_API.G_FALSE,
128: p_recipe_no => p_recipe_header_rec.recipe_no,

Line 184: GMD_RECIPE_VAL.recipe_description

180: /* Check if recipe description has been */
181: /* provided. */
182: /* ==================================== */
183: If (p_recipe_header_rec.recipe_description IS NOT NULL) THEN
184: GMD_RECIPE_VAL.recipe_description
185: ( p_api_version => 1.0,
186: p_init_msg_list => FND_API.G_FALSE,
187: p_commit => FND_API.G_FALSE,
188: p_recipe_description => p_recipe_header_rec.recipe_description,

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 442: l_val_rt_status := gmd_recipe_val.check_routing_validity

438: -- Check if new routing is different from old routing if one
439: -- is already associated with recipe.
440: -- This check will work for third party and also when called from form.
441: IF (x_routing_id IS NULL) THEN
442: l_val_rt_status := gmd_recipe_val.check_routing_validity
443: (p_recipe_header_rec.routing_id,
444: p_recipe_header_rec.recipe_Status);
445: IF (NOT l_val_rt_status) THEN
446: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');

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:

Line 819: gmd_recipe_val.recipe_exists

815: RAISE copy_recipe_err;
816: END IF;
817:
818: -- Check if this recipe id already exists in our system
819: gmd_recipe_val.recipe_exists
820: ( p_api_version => 1.0 ,
821: p_recipe_id => p_recipe_header_rec.Recipe_id ,
822: p_recipe_no => NULL ,
823: p_recipe_version => NULL ,

Line 855: gmd_recipe_val.recipe_name

851: IF p_recipe_header_rec.recipe_no IS NULL THEN
852: l_recipe_header_rec.recipe_no := old_recipe_rec.recipe_no;
853: ELSIF -- recipe_no value is different from that in db
854: p_recipe_header_rec.recipe_no <> old_recipe_rec.recipe_no THEN
855: gmd_recipe_val.recipe_name
856: ( p_api_version => 1.0
857: ,p_recipe_no => p_recipe_header_rec.recipe_no
858: ,p_recipe_version => p_recipe_header_rec.recipe_version
859: ,p_action_code => 'I'

Line 897: gmd_recipe_val.recipe_name

893: := old_recipe_rec.recipe_version;
894: ELSIF -- recipe_version value is different from that in db
895: p_recipe_header_rec.recipe_version
896: <> old_recipe_rec.recipe_version THEN
897: gmd_recipe_val.recipe_name
898: ( p_api_version => 1.0
899: ,p_recipe_no => p_recipe_header_rec.recipe_no
900: ,p_recipe_version => p_recipe_header_rec.recipe_version
901: ,p_action_code => 'I'