APPS.GMD_FORMULA_PUB dependencies on FM_MATL_DTL

Line 124: l_line_type fm_matl_dtl.line_type%TYPE;

120:
121: /* Extra variables for validating line type existence */
122: l_formula_no fm_form_mst.formula_no%TYPE;
123: l_formula_vers fm_form_mst.formula_vers%TYPE;
124: l_line_type fm_matl_dtl.line_type%TYPE;
125: l_line_type_counter NUMBER := 0;
126:
127: /* Variables used for defining status */
128: l_return_status varchar2(1) ;

Line 1746: update FM_MATL_DTL

1742: l_lastformula_id := l_formula_id; -- Assign the last formula header updated.
1743:
1744: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1745: p_formula_header_rec.auto_product_calc = 'N' THEN
1746: update FM_MATL_DTL
1747: SET PROD_PERCENT = NULL
1748: where formula_id = l_formula_id
1749: and line_type = 1
1750: and scale_type = 1;

Line 1752: UPDATE FM_MATL_DTL

1748: where formula_id = l_formula_id
1749: and line_type = 1
1750: and scale_type = 1;
1751: IF p_formula_header_rec.scale_type_hdr = 0 THEN
1752: UPDATE FM_MATL_DTL
1753: SET SCALE_TYPE = 0
1754: WHERE formula_id = l_formula_id;
1755: END IF;
1756: END IF;