preference::set_package_default (public)

 preference::set_package_default -preference_type preference_type \
    -package_id package_id -default_value default_value

Defined in packages/user-preferences/tcl/preference-procs.tcl

Sets the default preference value for a package ID

Switches:

-preference_type (required)

Corresponds to the short_name parameter to preference::type::new

-package_id (required)

-default_value (required)

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

Testcases:

No testcase defined.

Source code:

        # get the preference type id
        set preference_type_id [get_preference_type_id -preference_type $preference_type]
        
        # simply exec the PL/SQL
        db_exec_plsql set_package_default {}

Generic XQL file:

packages/user-preferences/tcl/preference-procs.xql

PostgreSQL XQL file:

<fullquery name="preference::set_package_default.set_package_default">
    <querytext>
select user_pref_type__set_package_default(
       :preference_type_id,
       :package_id,
       :default_value
);
</querytext>
</fullquery>

packages/user-preferences/tcl/preference-procs-postgresql.xql

Oracle XQL file:

<fullquery name="preference::set_package_default.set_package_default">
    <querytext>
declare begin
  user_pref_type.set_package_default(
       preference_type_id => :preference_type_id,
       package_id => :package_id,
       default_value => :default_value
  );
end;
</querytext>
</fullquery>

packages/user-preferences/tcl/preference-procs-oracle.xql