Best method for inactivating an bank account instrument and re-activating on approval?
I'm looking for the Oracle supported method of inactivating a new bank account assignment and re-activating the assignment. The use case would be using GRC to deactivate new assignments, and then re-activate upon approval.
I believe this boils down to the IBY_PMT_INSTR_USES_ALL table...I notice there is an end-date field which I assume is for this purpose? Is there an API that could be used?
The closest I can find is the IBY_INSTRREG_PUB package and the OraInstrDel, as this does a soft delete and essentially inactivates the assignment, as per http://docs.oracle.com/cd/B11454_01/11.5.9/acrobat/iby115ig.pdf