I have written a wrapper function that will call the stored procedure and return true or false and this function I was able to call in the BI Publisher Triggers and use it in Datamodel. Thanks much for the immediate help.