notification::type::delivery_method_enable (public)

 notification::type::delivery_method_enable -type_id type_id \
    -delivery_method_id delivery_method_id

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

Delivery methods must be enabled on a per notification type basis. For example, full forum posts may not be enabled for SMS delivery, as that would be too long. This enables a given delivery method for a given notification type.

Switches:

-type_id (required)

-delivery_method_id (required)

Testcases:

No testcase defined.

Source code:

        # perform the insert if necessary
        db_dml insert_delivery_method_map {}

Generic XQL file:

<fullquery name="notification::type::delivery_method_enable.insert_delivery_method_map">
    <querytext>
            insert
            into notification_types_del_methods
            (type_id, delivery_method_id)
            select :type_id,
                   :delivery_method_id
            from dual
            where not exists (select 1
                              from notification_types_del_methods
                              where type_id = :type_id
                              and delivery_method_id = :delivery_method_id)
        </querytext>
</fullquery>

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

PostgreSQL XQL file:

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

Oracle XQL file:

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