Advanced Interactive Reporting - Expert Oracle Application Express - page 556

Once created, I edited the TO DELETE column to change it to a Standard Report Column. Figure 13-36
shows what the resulting page looks like.
Figure 13-36. All public, non-primary interactive reports within an application
To delete these, I just use the following in a procedure that is invoked with the delete button:
for i in 1..apex application.g f01.count loop
apex util.ir delete report (
p report id => to number(apex application.g f01(i)));
end loop;
IR_DELETE_SUBSCRIPTION
IR DELETE SUBSCRIPTION is fairly self explanatory. It is an alternate to using the Subscriptions report
described previously.
APEX UTIL.IR DELETE SUBSCRIPTION (
p subscription id IN NUMBER );
You can access all the subscriptions for an application using the APEX APPLICATION PAGE IR SUB
view and then create a loop to remove just the ones that match your criteria. The following example
deletes the subscriptions to all interactive reports within the workspace that are being sent to
[e-mail] . Note that in this view, you will need to query the NOTIFY ID to pass into
P SUBSCRIPTION ID .
for c1 in (
select NOTIFY ID
from APEX APPLICATION PAGE IR SUB
where upper(EMAIL ADDRESS) = '[e-mail]' )
loop
apex util.ir delete subscription (p subscription id => c1.notify id);
end loop;
You might be wondering why you select “notify” to pass to “subscription”. Well, during
development, Subscriptions were called Notifications. One day before release, we decided to change the