Sharad,
I favor creating another stored procedure that does the other thing and calling that. This is similar to the non-database task of having a
Java method do something different. Messing with the parameters (either as nulls or magic number values) makes the code more confusing to call and harder to maintain.