notification::request::delete_all_for_user (public)

 notification::request::delete_all_for_user -user_id user_id

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

delete all the requests for a given user

Switches:

-user_id (required)

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

Testcases:

No testcase defined.

Source code:

        # do the delete
        db_exec_plsql delete_all_for_user {}

Generic XQL file:

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

PostgreSQL XQL file:

<fullquery name="notification::request::delete_all_for_user.delete_all_for_user">
    <querytext>
            select notification_request__delete_all_for_user(:user_id);
        </querytext>
</fullquery>

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

Oracle XQL file:

<fullquery name="notification::request::delete_all_for_user.delete_all_for_user">
    <querytext>
            declare begin
                notification_request.delete_all_for_user(user_id => :user_id);
            end;
        </querytext>
</fullquery>

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