UPDATE PURCHLINE SET CONFIRMEDDLV=:in1, MODIFIEDDATE=:in2, MODIFIEDTIME=:in3, MODIFIEDBY=:in4, RECVERSION=:in5 WHERE ((SUBSTR(NLS_LOWER(DATAAREAID),1,3)=NLS_LOWER(:in6)) AND (RECID=:in7))