APPS.GMD_FORMULA_PUB dependencies on FM_MATL_DTL

Line 122: l_line_type fm_matl_dtl.line_type%TYPE;

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

Line 1671: update FM_MATL_DTL

1667:
1668:
1669: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1670: p_formula_header_rec.auto_product_calc = 'N' THEN
1671: update FM_MATL_DTL
1672: SET PROD_PERCENT = NULL
1673: where formula_id = l_formula_id
1674: and line_type = 1
1675: and scale_type = 1;

Line 1677: UPDATE FM_MATL_DTL

1673: where formula_id = l_formula_id
1674: and line_type = 1
1675: and scale_type = 1;
1676: IF p_formula_header_rec.scale_type_hdr = 0 THEN
1677: UPDATE FM_MATL_DTL
1678: SET SCALE_TYPE = 0
1679: WHERE formula_id = l_formula_id;
1680: END IF;
1681: END IF;