APPS.GMD_FORMULA_DETAIL_PVT dependencies on FM_FORM_MST_B

Line 214: UPDATE fm_form_mst_b

210: ||' TOQ = '
211: ||l_product_qty);
212: END IF;
213: /* Update formula header table with TOQ and TIQ */
214: UPDATE fm_form_mst_b
215: SET total_output_qty = l_product_qty,
216: total_input_qty = l_ing_qty,
217: yield_uom = l_uom
218: WHERE formula_id = p_formula_detail_rec.formula_id;

Line 299: FROM fm_form_mst_b

295: l_return_val NUMBER := 0;
296:
297: CURSOR C_get_orgid (V_formula_id NUMBER) IS
298: SELECT owner_organization_id
299: FROM fm_form_mst_b
300: WHERE formula_id = V_formula_id;
301: l_org_id NUMBER;
302:
303: BEGIN

Line 512: UPDATE fm_form_mst_b

508: ||l_ing_qty
509: ||' - '
510: ||x_return_status);
511: END IF;
512: UPDATE fm_form_mst_b
513: SET total_output_qty = l_product_qty,
514: total_input_qty = l_ing_qty,
515: yield_uom = l_uom
516: WHERE formula_id = p_formula_detail_rec.formula_id;

Line 632: update fm_form_mst_b

628: X_MSG_COUNT => X_msg_cnt ,
629: X_MSG_DATA => x_msg_dat );
630:
631:
632: update fm_form_mst_b
633: set total_output_qty = l_product_qty,
634: total_input_qty = l_ing_qty,
635: yield_uom = l_uom
636: where formula_id = p_formula_detail_rec.formula_id;