How to Stop the Notification for istore (Workflow – JTF Approval)

One of our recent requirements is to stop sending the email Notification to the Istore user who falls under the category of

Primary User
Business user.
Oracle has provided a Standard Workflow “JTF Approval” to handle any email notification to Istore users who register them self through customer istore web site including these 2 types of users.
Options available to me was either
1. Modified the Oracle Standard workflow. – That is not feasible at all, because that is Oracle Standard workflow.
2. Direct UPDATE statement on the table jtf_um_usertypes_b

update jtf_um_usertypes_b
set EMAIL_NOTIFICATION_FLAG='N'
where USERTYPE_KEY in ('IBE_BUSINESS','IBE_PRIMARY')
AND EMAIL_NOTIFICATION_FLAG='Y';

This is pretty straight forward and it is on time only , but we are back to square 1 , this is Direct Update on Oracle Standard table that is not recommended solution and Oracle will not support that at all.

With none of options are good choice , I executed couple of queries and found one Standard API provide for Oracle to do same thing.

API Name - JTF_UM_USERTYPES_PKG. UPDATE_ROW

This API was doing a simple update in the table
JTF_UM_USERTYPES_B &
JTF_UM_USERTYPES_TL
I then build my code to set the “ EMAIL_NOTIFICATION_FLAG='N' “ with this API , Below is Simple logic that I build

Declare
Cursor curuserB IS
Select variables
from
JTF_UM_USERTYPES_B B ,
JTF_UM_USERTYPES_TL T
Where b.usertype_id t.usertype_id
And B.USERTYPE_KEY in ('IBE_BUSINESS','IBE_PRIMARY');

BEGIN
FOR recuserB in curuserB
LOOP
JTF_UM_USERTYPES_PKG. UPDATE_ROW(
recuserB.variable1,
recuserB.variable2
recuserB.variable3,,
….
…
);
END LOOP;
END

 that all , I am done .
Hope that help you guys too.