notification::request::delete_all (public)

 notification::request::delete_all -object_id object_id

Defined in packages/notifications/tcl/notification-request-procs.tcl

remove all requests for a particular object ID usually because the object is getting deleted.

Switches:

-object_id (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

        # Do it
        db_exec_plsql delete_all_requests {}

Generic XQL file:

packages/notifications/tcl/notification-request-procs.xql

PostgreSQL XQL file:

<fullquery name="notification::request::delete_all.delete_all_requests">
    <querytext>
            select notification_request__delete_all(:object_id);
        </querytext>
</fullquery>

packages/notifications/tcl/notification-request-procs-postgresql.xql

Oracle XQL file:

<fullquery name="notification::request::delete_all.delete_all_requests">
    <querytext>
            declare begin
                notification_request.delete_all(object_id => :object_id);
            end;
        </querytext>
</fullquery>

packages/notifications/tcl/notification-request-procs-oracle.xql