SalesAccountingModel.java

public class SalesAccountingModel {

    private EntityManager entityManager;


    public SalesAccountingModel(EntityManager entityManager) {
        this.entityManager = entityManager;
    }

    public List listAll(Date initialDate, Date finalDate) { 
         StoredProcedureQuery storedProcedureQuery = entityManager.createStoredProcedureQuery("SALES_ACCOUNTING", SalesAccounting.class) 
                         .registerStoredProcedureParameter("INITIALDATE", Date.class, ParameterMode.IN)
                         .registerStoredProcedureParameter("FINALDATE", Date.class, ParameterMode.IN); 
         return (List) storedProcedureQuery.setParameter("INITIALDATE", dataInicio).setParameter("FINALDATE", dataFim).getResultList(); 
    } 
  
}