DBA Data[Home] [Help]

APPS.GMD_SPREADSHEET_UPDATE dependencies on GME_MATERIAL_DETAILS_DBL

Line 502: IF (GME_MATERIAL_DETAILS_DBL.FETCH_ROW (P_material, X_material)) THEN

498: WHERE parent_line_id = l_matl_rec.parent_line_id;
499: END IF;
500: ELSE
501: P_material.material_detail_id := l_matl_rec.material_detail_id;
502: IF (GME_MATERIAL_DETAILS_DBL.FETCH_ROW (P_material, X_material)) THEN
503: X_material.dtl_um := l_matl_rec.detail_uom;
504: IF (l_batch_row.batch_status = 1) THEN
505: X_material.plan_qty := l_matl_rec.qty;
506: ELSIF (l_batch_row.batch_status = 2) THEN