OAF - Create VO on FLY.

String s = "select parameter_id from ap_expense_report_params_all erp where erp.expense_type_code = :1";

ViewObject viewobject = getDBTransaction().createViewObjectFromQueryStmt(s); viewobject.setWhereClauseParam(0, "ROUNDING");

viewobject.executeQuery();

OAViewRowImpl row = (OAViewRowImpl)viewobject.first();

if(row == null)

mRoundingParameterId = null;

else

mRoundingParameterId = (Number)row.getAttribute(0);

viewobject.remove();