Person Event: SQL Trigger Code to fire
I need Banner to fire person events for some updates that it is currently not programmed to do. I've attached one of the triggers that I'm analyzing in order to figure out how to do this.
The logic makes sense to me, but I don't know what all the called stored-procedures actually do. Is this portion at the end:
icspkldi.p_save_person (pidm, action);
what actually fires the person evenet?
I'm going to run tests, but if any of you have done this before, please advise if this is correct, or if I'm leaving parts out.
thank you
Icspkldi.p_save_person builds
Icspkldi.p_save_person builds the event record and stores it in a temporary PL/SQL table.
Then you need to call
Icspkldi.p_send_person;
to actually fire the event.
You can call p_save_person several times and then call p_send_person once at the end of your processing.
events fire, but no role recalc
the triggers look solid. Thanks for your input-- helped me to understand the process better.
However, it doesn't look like the role is relcalculating -- just firing the events. Any idea on how to get it to evaluate the role changes that are occurring?
user input issue
Nevermind, it was executing correctly, the form wasn't having its data input correctly ---- which could mean a role rewrite in the next few weeks
thanks for the input.