Morning all,I’ve recently had a request to delete subsequent approvals if a specific approval has been rejected. e.g. below: If the PROC REVIEW Request is rejected then the 3 approvals below would be deleted.I’ve managed to create a custom event as per below, which executes a package to handle the removal:SQL Package: PROCEDURE Remove_Supplier_Approvals(i_Key_Ref VARCHAR2) ISPRAGMA AUTONOMOUS_TRANSACTION; -- p0 -> __lsResult p0_ VARCHAR2(32000) := NULL; -- p4 -> __sAction p4_ VARCHAR2(32000) := 'DO'; /*Created by RK to automatically remove values from the approvals screen*/ cursor GET_DATA ISSelect distinctOBJID,OBJVERSION from approval_routingwhere LU_NAME = 'SupplierInfoGeneral'and KEY_REF = i_Key_Refand description in ('Supp Reactivation - Acc Payable Review','Supp Reactivation - Procurement Confirm','Supp Reactivation - Reactivate Account')and APPROVAL_STATUS is null;BEGIN --IFSAPP.Language_SYS.Set_Language('gb'); -- This requires logged in user to have privi
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.