Calling utc package from within agent

Marc,

Our inbound orders are assigned a pickup time window of <date>235900 in the inbound xml.  When an order gets updated an Order Modified agent runs triggering a Direct SQL update to set the early pickup date to 6am and the late pickup date to 6pm.  This calls the utc package to get the utc offset and the utc local date.  I see the agent running the call in my logs but the order is still reflecting the original 235900 date.

This is the Direct SQL statement.

update order_release o set early_pickup_date = utc.get_utc_date(trunc(utc.get_local_date(early_pickup_date, o.source_location_gid)) + 6 / 24, o.source_location_gid), late_pickup_date = utc.get_utc_date(trunc(utc.get_local_date(early_pickup_date, o.source_location_gid)) + 18 / 24, o.source_location_gid) where order_release_gid = $gid