store procedure for yyz temp interface