APPS.GMD_SUBSTITUTION_PVT dependencies on FM_MATL_DTL

Line 362: UPDATE fm_matl_dtl

358: FETCH Cur_check_substitute INTO l_start_date;
359: CLOSE Cur_check_substitute;
360:
361: IF (NVL(l_start_date,l_subs_start_date) >= l_subs_start_date) THEN
362: UPDATE fm_matl_dtl
363: SET ingredient_end_date = l_subs_start_date
364: WHERE formula_id = p_formula_substitution_tbl(i).formula_id
365: AND line_type = -1
366: AND inventory_item_id = l_original_item_id;

Line 534: UPDATE fm_matl_dtl

530: CLOSE Cur_check_substitute;
531:
532: IF (NVL(l_start_date,p_substitution_hdr_rec.start_date) >=
533: p_substitution_hdr_rec.start_date) THEN
534: UPDATE fm_matl_dtl
535: SET ingredient_end_date = p_substitution_hdr_rec.start_date
536: WHERE formula_id = l_rec.formula_id
537: AND line_type = -1
538: AND inventory_item_id = l_rec.original_inventory_item_id;

Line 695: UPDATE fm_matl_dtl

691: l_substitution_id);
692: FETCH cur_get_sub_end_date into l_end_date;
693: CLOSE cur_get_sub_end_date;
694:
695: UPDATE fm_matl_dtl
696: SET ingredient_end_date = l_end_date
697: WHERE formula_id = l_formula_id
698: AND inventory_item_id = l_original_item_id
699: AND line_type = -1;