bm_get_root_folder_id (public)

 bm_get_root_folder_id package_id user_id

Defined in packages/bookmarks/tcl/bookmarks-procs.tcl

Returns the id of the bookmark root folder of a user in a package instance. This root folder is used for default access permissioning of a users bookmarks (bookmarks will inherit permissions).

Parameters:

package_id (required)

user_id (required)

Testcases:

No testcase defined.

Source code:

      set root_folder_id [db_exec_plsql fs_root_folder "
      begin
          :1 := bookmark.get_root_folder(
                package_id => :package_id,
                user_id    => :user_id);
      end;"]

      return $root_folder_id

Generic XQL file:

packages/bookmarks/tcl/bookmarks-procs.xql

PostgreSQL XQL file:

<fullquery name="bm_get_root_folder_id.fs_root_folder">
    <querytext>

          select bookmark__get_root_folder (:package_id, :user_id);

      </querytext>
</fullquery>

packages/bookmarks/tcl/bookmarks-procs-postgresql.xql

Oracle XQL file:

<fullquery name="bm_get_root_folder_id.fs_root_folder">
    <querytext>
      
      begin
          :1 := bookmark.get_root_folder(
                package_id => :package_id,
                user_id    => :user_id);
      end;
      </querytext>
</fullquery>

packages/bookmarks/tcl/bookmarks-procs-oracle.xql