notification::delete (public)

 notification::delete -notification_id notification_id

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

delete a notification

Switches:

-notification_id (required)

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

Testcases:

No testcase defined.

Source code:

        db_transaction {
            # Remove the mappings
            db_dml delete_mappings {}

            # do the delete
            db_exec_plsql delete_notification {}
        }

Generic XQL file:

<fullquery name="notification::delete.delete_mappings">
    <querytext>
            delete
            from notification_user_map
            where notification_id = :notification_id
        </querytext>
</fullquery>

packages/notifications/tcl/notification-procs.xql

PostgreSQL XQL file:

<fullquery name="notification::delete.delete_notification">
    <querytext>
            select notification__delete(:notification_id)
        </querytext>
</fullquery>

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

Oracle XQL file:

<fullquery name="notification::delete.delete_notification">
    <querytext>
            declare begin
                notification.del(:notification_id);
            end;
        </querytext>
</fullquery>

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