'
-- -- @param target_id The item which the symlink will point to
-- -- @param parent_id The parent folder for the symlink. This must actually be a folder
-- -- and not a generic content item.
-- -- @param symlink_id The id of the new symlink. A new id will be allocated by default
-- -- @param creation_date As in acs_object.new
-- -- @param creation_ip As in acs_object.new
-- -- @param creation_user As in acs_object.new
-- -- @return The id of the newly created symlink
-- -- @see {acs_object.new}, {content_item.new}, {content_symlink.resolve}
-- --*/
-- name in cr_items.name%TYPE default null,
-- label in cr_symlinks.label%TYPE default null,
-- target_id in cr_items.item_id%TYPE,
-- parent_id in cr_items.parent_id%TYPE,
-- symlink_id in cr_symlinks.symlink_id%TYPE default null,
-- creation_date in acs_objects.creation_date%TYPE
-- default sysdate,
-- creation_user in acs_objects.creation_user%TYPE
-- default null,
-- creation_ip in acs_objects.creation_ip%TYPE default null
-- ) return cr_symlinks.symlink_id%TYPE;
--
--
-- procedure delete (
-- --/** Deletes the symlink
-- -- @author Karl Goldstein
-- -- @param symlink_id The id of the symlink to delete
-- -- @see {content_symlink.new}, {acs_object.delete}
-- --*/
-- symlink_id in cr_symlinks.symlink_id%TYPE
-- );
--
--
-- procedure copy (
-- --/** Copies the symlink itself to another folder, without resolving the symlink
-- -- @author Karl Goldstein
-- -- @param symlink_id The id of the symlink to copy
-- -- @param target_folder_id The id of the folder where the symlink is to be copied
-- -- @param creation_user The id of the creation user
-- -- @param creation_ip The IP address of the creation user (defualt null)
-- -- @see {content_symlink.new}, {content_item.copy}
-- --*/
-- symlink_id in cr_symlinks.symlink_id%TYPE,
-- target_folder_id in cr_folders.folder_id%TYPE,
-- creation_user in acs_objects.creation_user%TYPE,
-- creation_ip in acs_objects.creation_ip%TYPE default null
-- );
--
-- function is_symlink (
-- --/** Determines if the item is a symlink
-- -- @author Karl Goldstein
-- -- @param item_id The item id
-- -- @return 't' if the item is a symlink, 'f' otherwise
-- -- @see {content_symlink.new}, {content_symlink.resolve}
-- --*/
-- item_id in cr_items.item_id%TYPE
-- ) return char;
--
--
-- function resolve (
-- --/** Resolves the symlink and returns the target item id.
-- -- @author Karl Goldstein
-- -- @param item_id The item id to be resolved
-- -- @return The target item of the symlink, or the original item id if
-- -- the item is not in fact a symlink
-- -- @see {content_symlink.new}, {content_symlink.is_symlink}
-- --*/
-- item_id in cr_items.item_id%TYPE
-- ) return cr_items.item_id%TYPE;
--
--
-- function resolve_content_type (
-- --/** Gets the content type of the target item.
-- -- @author Michael Pih
-- -- @param item_id The item id to be resolved
-- -- @return The content type of the symlink target, otherwise null.
-- -- the item is not in fact a symlink
-- -- @see {content_symlink.resolve}
-- --*/
-- item_id in cr_items.item_id%TYPE
-- ) return cr_items.content_type%TYPE;
--
--
-- end content_symlink;
-- show errors
-- create or replace package content_extlink
-- as
--
-- function new (
-- --/** Create a new extlink, an item pointing to an off-site resource
-- -- @author Karl Goldstein
-- -- @param name The name for the new extlink, defaults to the name of the
-- -- target item
-- -- @param url The URL of the item
-- -- @param label The text label or title of the item
-- -- @param description A brief description of the item
-- -- @param parent_id The parent folder for the extlink. This must actually be a folder
-- -- and not a generic content item.
-- -- @param extlink_id The id of the new extlink. A new id will be allocated by default
-- -- @param creation_date As in acs_object.new
-- -- @param creation_ip As in acs_object.new
-- -- @param creation_user As in acs_object.new
-- -- @return The id of the newly created extlink
-- -- @see {acs_object.new}, {content_item.new}, {content_extlink.resolve}
-- --*/
-- name in cr_items.name%TYPE default null,
-- url in cr_extlinks.url%TYPE,
-- label in cr_extlinks.label%TYPE default null,
-- description in cr_extlinks.description%TYPE default null,
-- parent_id in cr_items.parent_id%TYPE,
-- extlink_id in cr_extlinks.extlink_id%TYPE default null,
-- creation_date in acs_objects.creation_date%TYPE
-- default sysdate,
-- creation_user in acs_objects.creation_user%TYPE
-- default null,
-- creation_ip in acs_objects.creation_ip%TYPE default null
-- ) return cr_extlinks.extlink_id%TYPE;
--
--
-- procedure delete (
-- --/** Deletes the extlink
-- -- @author Karl Goldstein
-- -- @param extlink_id The id of the extlink to delete
-- -- @see {content_extlink.new}, {acs_object.delete}
-- --*/
-- extlink_id in cr_extlinks.extlink_id%TYPE
-- );
--
--
-- function is_extlink (
-- --/** Determines if the item is a extlink
-- -- @author Karl Goldstein
-- -- @param item_id The item id
-- -- @return 't' if the item is a extlink, 'f' otherwise
-- -- @see {content_extlink.new}, {content_extlink.resolve}
-- --*/
-- item_id in cr_items.item_id%TYPE
-- ) return char;
--
--
-- end content_extlink;
-- show errors
-- create or replace package content_folder
-- as
--
-- function new (
-- --/** Create a new folder
-- -- @author Karl Goldstein
-- -- @param label The label for the folder
-- -- @param description A short description of the folder, 4000 characters maximum
-- -- @param parent_id The parent of the folder
-- -- @param folder_id The id of the new folder. A new id will be allocated by default
-- -- @param context_id The context id. The parent id will be used as the default context
-- -- @param creation_date As in acs_object.new
-- -- @param creation_ip As in acs_object.new
-- -- @param creation_user As in acs_object.new
-- -- @return The id of the newly created folder
-- -- @see {acs_object.new}, {content_item.new}
-- --*/
-- name in cr_items.name%TYPE,
-- label in cr_folders.label%TYPE,
-- description in cr_folders.description%TYPE default null,
-- parent_id in cr_items.parent_id%TYPE default null,
-- context_id in acs_objects.context_id%TYPE default null,
-- folder_id in cr_folders.folder_id%TYPE default null,
-- creation_date in acs_objects.creation_date%TYPE default sysdate,
-- creation_user in acs_objects.creation_user%TYPE default null,
-- creation_ip in acs_objects.creation_ip%TYPE default null
-- ) return cr_folders.folder_id%TYPE;
--
-- procedure delete (
-- --/** Delete a folder. An error is thrown if the folder is not empty
-- -- @author Karl Goldstein
-- -- @param folder_id The id of the folder to delete
-- -- @see {acs_object.delete}, {content_item.delete}
-- --*/
-- folder_id in cr_folders.folder_id%TYPE
-- );
--
-- procedure rename (
-- --/** Change the name, label and/or description of the folder
-- -- @author Karl Goldstein
-- -- @param folder_id The id of the folder to modify
-- -- @param name The new name for the folder. An error will be thrown if
-- -- an item with this name already exists under this folder's
-- -- parent. If this parameter is null, the old name will be preserved
-- -- @param label The new label for the folder. The old label will be preserved if
-- -- this parameter is null
-- -- @param label The new description for the folder. The old description
-- -- will be preserved if this parameter is null
-- -- @see {content_folder.new}
-- --*/
-- folder_id in cr_folders.folder_id%TYPE,
-- name in cr_items.name%TYPE default null,
-- label in cr_folders.label%TYPE default null,
-- description in cr_folders.description%TYPE default null
-- );
--
-- procedure move (
-- --/** Recursively move the folder and all items in into a new location.
-- -- An error is thrown if either of the parameters is not a folder.
-- -- The root folder of the sitemap and the root folder of the
-- -- templates cannot be moved.
-- -- @author Karl Goldstein
-- -- @param folder_id The id of the folder to move
-- -- @param target_folder_id The destination folder
-- -- @see {content_folder.new}, {content_folder.copy}
-- --*/
-- folder_id in cr_folders.folder_id%TYPE,
-- target_folder_id in cr_folders.folder_id%TYPE
-- );
--
-- procedure copy (
-- --/** Recursively copy the folder and all items in into a new location.
-- -- An error is thrown if either of the parameters is not a folder.
-- -- The root folder of the sitemap and the root folder of the
-- -- templates cannot be copied
-- -- @author Karl Goldstein
-- -- @param folder_id The id of the folder to copy
-- -- @param target_folder_id The destination folder
-- -- @param creation_user The id of the creation user
-- -- @param creation_ip The IP address of the creation user (defaults to null)
-- -- @see {content_folder.new}, {content_folder.copy}
-- --*/
-- folder_id in cr_folders.folder_id%TYPE,
-- target_folder_id in cr_folders.folder_id%TYPE,
-- creation_user in acs_objects.creation_user%TYPE,
-- creation_ip in acs_objects.creation_ip%TYPE default null
-- );
--
-- function is_folder (
-- --/** Determine if the item is a folder
-- -- @author Karl Goldstein
-- -- @param item_id The item id
-- -- @return 't' if the item is a folder, 'f' otherwise
-- -- @see {content_folder.new}, {content_folder.is_sub_folder}
-- --*/
-- item_id in cr_items.item_id%TYPE
-- ) return char;
--
-- function is_sub_folder (
-- --/** Determine if the item target_folder_id is a subfolder of
-- -- the item folder_id
-- -- @author Karl Goldstein
-- -- @param folder_id The superfolder id
-- -- @param target_folder_id The subfolder id
-- -- @return 't' if the item target_folder_id is a subfolder of
-- -- the item folder_id, 'f' otherwise
-- -- @see {content_folder.is_folder}
-- --*/
-- folder_id in cr_folders.folder_id%TYPE,
-- target_folder_id in cr_folders.folder_id%TYPE
-- ) return char;
--
-- function is_empty (
-- --/** Determine if the folder is empty
-- -- @author Karl Goldstein
-- -- @param folder_id The folder id
-- -- @return 't' if the folder contains no subfolders or items, 'f' otherwise
-- -- @see {content_folder.is_folder}
-- --*/
-- folder_id in cr_folders.folder_id%TYPE
-- ) return varchar2;
--
-- function is_root (
-- --/** Determine whether the folder is a root (has a parent_id of 0)
-- -- @author Karl Goldstein
-- -- @param folder_id The folder ID
-- -- @return 't' if the folder is a root or 'f' otherwise
-- --*/
-- folder_id in cr_folders.folder_id%TYPE
-- ) return char;
--
-- procedure register_content_type (
-- --/** Register a content type to the folder, if it is not already registered.
-- -- Only items of the registered type(s) may be added to the folder.
-- -- @author Karl Goldstein
-- -- @param folder_id The folder id
-- -- @param content_type The content type to be registered
-- -- @see {content_folder.unregister_content_type},
-- -- {content_folder.is_registered}
-- --*/
-- folder_id in cr_folders.folder_id%TYPE,
-- content_type in cr_folder_type_map.content_type%TYPE,
-- include_subtypes in varchar2 default 'f'
-- );
--
-- procedure unregister_content_type (
-- --/** Unregister a content type from the folder, if it has been registered.
-- -- Only items of the registered type(s) may be added to the folder.
-- -- If the folder already contains items of the type to be unregistered, the
-- -- items remain in the folder.
-- -- @author Karl Goldstein
-- -- @param folder_id The folder id
-- -- @param content_type The content type to be unregistered
-- -- @param include_subtypes If 't', all subtypes of content_type will be
-- -- unregistered as well
-- -- @see {content_folder.register_content_type}, {content_folder.is_registered}
-- --*/
-- folder_id in cr_folders.folder_id%TYPE,
-- content_type in cr_folder_type_map.content_type%TYPE,
-- include_subtypes in varchar2 default 'f'
-- );
--
-- -- change this to is_type_registered
-- function is_registered (
-- --/** Determines if a content type is registered to the folder
-- -- Only items of the registered type(s) may be added to the folder.
-- -- @author Karl Goldstein
-- -- @param folder_id The folder id
-- -- @param content_type The content type to be checked
-- -- @param include_subtypes If 't', all subtypes of the content_type
-- -- will be checked, returning 't' if all of them are registered. If 'f',
-- -- only an exact match with content_type will be
-- -- performed.
-- -- @return 't' if the type is registered to this folder, 'f' otherwise
-- -- @see {content_folder.register_content_type}, {content_folder.unregister_content_type},
-- --*/
-- folder_id in cr_folders.folder_id%TYPE,
-- content_type in cr_folder_type_map.content_type%TYPE,
-- include_subtypes in varchar2 default 'f'
-- ) return varchar2;
--
--
-- function get_label (
-- --/** Returns the label for the folder. This function is the default name method
-- -- for the folder object.
-- -- @author Karl Goldstein
-- -- @param folder_id The folder id
-- -- @return The folder's label
-- -- @see {acs_object_type.create_type}, the docs for the name_method parameter
-- --*/
-- folder_id in cr_folders.folder_id%TYPE
-- ) return cr_folders.label%TYPE;
--
--
-- function get_index_page (
-- --/** Returns the item ID of the index page of the folder, null otherwise
-- -- @author Michael Pih
-- -- @param folder_id The folder id
-- -- @return The item ID of the index page
-- --*/
-- folder_id in cr_folders.folder_id%TYPE
-- ) return cr_items.item_id%TYPE;
--
--
--
-- end content_folder;
-- show errors
-- create or replace package content_template
-- as
--
-- c_root_folder_id constant integer := -200;
--
-- function get_root_folder return cr_folders.folder_id%TYPE;
--
-- function new (
-- --/** Creates a new content template which can be used to render content items.
-- -- @author Karl Goldstein
-- -- @param name The name for the template, must be a valid UNIX-like filename.
-- -- If a template with this name already exists under the specified
-- -- parent item, an error is thrown
-- -- @param parent_id The parent of this item, defaults to null
-- -- @param template_id The id of the new template. A new id will be allocated if this
-- -- parameter is null
-- -- @param creation_date As in acs_object.new
-- -- @param creation_ip As in acs_object.new
-- -- @param creation_user As in acs_object.new
-- -- @return The id of the newly created template
-- -- @see {acs_object.new}, {content_item.new}, {content_item.register_template},
-- -- {content_type.register_template}
-- --*/
-- name in cr_items.name%TYPE,
-- parent_id in cr_items.parent_id%TYPE default null,
-- template_id in cr_templates.template_id%TYPE default null,
-- creation_date in acs_objects.creation_date%TYPE
-- default sysdate,
-- creation_user in acs_objects.creation_user%TYPE
-- default null,
-- creation_ip in acs_objects.creation_ip%TYPE default null
-- ) return cr_templates.template_id%TYPE;
--
-- procedure delete (
-- --/** Deletes the specified template, and unregisters the template from
-- -- all content types and content items.
-- -- Use with caution - this operation cannot be undone.
-- -- @author Karl Goldstein
-- -- @param template_id The id of the template to delete
-- -- @see {acs_object.delete}, {content_item.unregister_template},
-- -- {content_type.unregister_template},
-- --*/
-- template_id in cr_templates.template_id%TYPE
-- );
--
-- function is_template (
-- --/** Determine if an item is a template.
-- -- @author Karl Goldstein
-- -- @param item_id The item id
-- -- @return 't' if the item is a template, 'f' otherwise
-- -- @see {content_template.new}
-- --*/
-- template_id in cr_templates.template_id%TYPE
-- ) return varchar2;
--
-- function get_path (
-- --/** Retrieves the full path to the template, as described in content_item.get_path
-- -- @author Karl Goldstein
-- -- @param template_id The id of the template for which the path is to
-- -- be retrieved
-- -- @param root_folder_id Starts path resolution at this folder
-- -- @return The path to the template, starting with the specified root folder
-- -- @see {content_item.get_path}
-- --*/
-- template_id in cr_templates.template_id%TYPE,
-- root_folder_id in cr_folders.folder_id%TYPE default c_root_folder_id
-- ) return varchar2;
--
-- end content_template;
-- show errors
-- create or replace package content_keyword
-- as
--
-- function new (
-- --/** Creates a new keyword (also known as "subject category").
-- -- @author Karl Goldstein
-- -- @param heading The heading for the new keyword
-- -- @param description The description for the new keyword
-- -- @param parent_id The parent of this keyword, defaults to null.
-- -- @param keyword_id The id of the new keyword. A new id will be allocated if this
-- -- parameter is null
-- -- @param object_type The type for the new keyword, defaults to 'content_keyword'.
-- -- This parameter may be used by subclasses of
-- -- content_keyword to initialize the superclass.
-- -- @param creation_date As in acs_object.new
-- -- @param creation_ip As in acs_object.new
-- -- @param creation_user As in acs_object.new
-- -- @return The id of the newly created keyword
-- -- @see {acs_object.new}, {content_item.new}, {content_keyword.item_assign},
-- -- {content_keyword.delete}
-- --*/
-- heading in cr_keywords.heading%TYPE,
-- description in cr_keywords.description%TYPE default null,
-- parent_id in cr_keywords.parent_id%TYPE default null,
-- keyword_id in cr_keywords.keyword_id%TYPE default null,
-- creation_date in acs_objects.creation_date%TYPE
-- default sysdate,
-- creation_user in acs_objects.creation_user%TYPE
-- default null,
-- creation_ip in acs_objects.creation_ip%TYPE default null,
-- object_type in acs_object_types.object_type%TYPE default 'content_keyword'
-- ) return cr_keywords.keyword_id%TYPE;
--
-- procedure delete (
-- --/** Deletes the specified keyword, which must be a leaf. Unassigns the
-- -- keyword from all content items. Use with caution - this
-- -- operation cannot be undone.
-- -- @author Karl Goldstein
-- -- @param keyword_id The id of the keyword to be deleted
-- -- @see {acs_object.delete}, {content_keyword.item_unassign}
-- --*/
-- keyword_id in cr_keywords.keyword_id%TYPE
-- );
--
-- function get_heading (
-- --/** Retrieves the heading of the content keyword
-- -- @author Karl Goldstein
-- -- @param keyword_id The keyword id
-- -- @return The heading for the specified keyword
-- -- @see {content_keyword.set_heading}, {content_keyword.get_description}
-- --*/
-- keyword_id in cr_keywords.keyword_id%TYPE
-- ) return varchar2;
--
-- function get_description (
-- --/** Retrieves the description of the content keyword
-- -- @author Karl Goldstein
-- -- @param keyword_id The keyword id
-- -- @return The description for the specified keyword
-- -- @see {content_keyword.get_heading}, {content_keyword.set_description}
-- --*/
-- keyword_id in cr_keywords.keyword_id%TYPE
-- ) return varchar2;
--
-- procedure set_heading (
-- --/** Sets a new heading for the keyword
-- -- @author Karl Goldstein
-- -- @param keyword_id The keyword id
-- -- @param heading The new heading
-- -- @see {content_keyword.get_heading}, {content_keyword.set_description}
-- --*/
-- keyword_id in cr_keywords.keyword_id%TYPE,
-- heading in cr_keywords.heading%TYPE
-- );
--
-- procedure set_description (
-- --/** Sets a new description for the keyword
-- -- @author Karl Goldstein
-- -- @param keyword_id The keyword id
-- -- @param description The new description
-- -- @see {content_keyword.set_heading}, {content_keyword.get_description}
-- --*/
-- keyword_id in cr_keywords.keyword_id%TYPE,
-- description in cr_keywords.description%TYPE
-- );
--
-- function is_leaf (
-- --/** Determines if the keyword has no sub-keywords associated with it
-- -- @author Karl Goldstein
-- -- @param keyword_id The keyword id
-- -- @return 't' if the keyword has no descendants, 'f' otherwise
-- -- @see {content_keyword.new}
-- --*/
-- keyword_id in cr_keywords.keyword_id%TYPE
-- ) return varchar2;
--
-- procedure item_assign (
-- --/** Assigns this keyword to a content item, creating a relationship between them
-- -- @author Karl Goldstein
-- -- @param item_id The item to be assigned to
-- -- @param keyword_id The keyword to be assigned
-- -- @param context_id As in acs_rel.new, deprecated
-- -- @param creation_ip As in acs_rel.new, deprecated
-- -- @param creation_user As in acs_rel.new, deprecated
-- -- @see {acs_rel.new}, {content_keyword.item_unassign}
-- --*/
-- item_id in cr_items.item_id%TYPE,
-- keyword_id in cr_keywords.keyword_id%TYPE,
-- context_id in acs_objects.context_id%TYPE default null,
-- creation_user in acs_objects.creation_user%TYPE default null,
-- creation_ip in acs_objects.creation_ip%TYPE default null
-- );
--
-- procedure item_unassign (
-- --/** Unassigns this keyword to a content item, removing a relationship between them
-- -- @author Karl Goldstein
-- -- @param item_id The item to be unassigned from
-- -- @param keyword_id The keyword to be unassigned
-- -- @see {acs_rel.delete}, {content_keyword.item_assign}
-- --*/
-- item_id in cr_items.item_id%TYPE,
-- keyword_id in cr_keywords.keyword_id%TYPE
-- );
--
-- function is_assigned (
-- --/** Determines if the keyword is assigned to the item
-- -- @author Karl Goldstein
-- -- @param item_id The item id
-- -- @param keyword_id The keyword id to be checked for assignment
-- -- @param recurse Specifies if the keyword search is
-- -- recursive. May be set to one of the following
-- -- values:
-- -- - none: Not recursive. Look for an exact match.
-- -- - up: Recursive from specific to general. A search for
-- -- "attack dogs" will also match "dogs", "animals", "mammals", etc.
-- -- - down: Recursive from general to specific. A search for
-- -- "mammals" will also match "dogs", "attack dogs", "cats", "siamese cats",
-- -- etc.
-- -- @return 't' if the keyword may be matched to an item, 'f' otherwise
-- -- @see {content_keyword.item_assign}
-- --*/
-- item_id in cr_items.item_id%TYPE,
-- keyword_id in cr_keywords.keyword_id%TYPE,
-- recurse in varchar2 default 'none'
-- ) return varchar2;
--
-- function get_path (
-- --/** Retreives a path to the keyword/subject category, with the most general
-- -- category at the root of the path
-- -- @author Karl Goldstein
-- -- @param keyword_id The keyword id
-- -- @return The path to the keyword, or null if no such keyword exists
-- -- @see {content_keyword.new}
-- --*/
-- keyword_id in cr_keywords.keyword_id%TYPE
-- ) return varchar2;
--
-- end content_keyword;
-- show errors
-- create or replace package content_permission
-- is
--
-- procedure inherit_permissions (
-- --/** Make the child object inherit all of the permissions of the parent
-- -- object. Typically, this function is called whenever a new object
-- -- is created under a given parent
-- -- @author Karl Goldstein
-- -- @param parent_object_id The parent object id
-- -- @param child_object_id The child object id
-- -- @see {content_permission.grant}, {acs_permission.grant_permission}
-- --*/
-- parent_object_id in acs_objects.object_id%TYPE,
-- child_object_id in acs_objects.object_id%TYPE,
-- child_creator_id in parties.party_id%TYPE default null
-- );
--
-- function has_grant_authority (
-- --/** Determine if the user may grant a certain permission to another
-- -- user. The permission may only be granted if the user has
-- -- the permission himself and posesses the cm_perm access, or if the
-- -- user posesses the cm_perm_admin access.
-- -- @author Karl Goldstein
-- -- @param object_id The object whose permissions are to be changed
-- -- @param holder_id The person who is attempting to grant the permissions
-- -- @param privilege The privilege to be granted
-- -- @return 't' if the donation is possible, 'f' otherwise
-- -- @see {content_permission.grant_permission}, {content_permission.is_has_revoke_authority},
-- -- {acs_permission.grant_permission}
-- --*/
-- object_id in acs_objects.object_id%TYPE,
-- holder_id in parties.party_id%TYPE,
-- privilege in acs_privileges.privilege%TYPE
-- ) return varchar2;
--
-- procedure grant_permission_h (
-- --/** This is a helper function for content_permission.grant_permission and
-- -- should not be called individually.
-- -- Grants a permission and revokes all descendants of the permission, since
-- -- they are no longer relevant.
-- -- @author Karl Goldstein
-- -- @param object_id The object whose permissions are to be changed
-- -- @param grantee_id The person who should gain the parent privilege
-- -- @param privilege The parent privilege to be granted
-- -- @see {content_permission.grant_permission}
-- --*/
-- object_id in acs_objects.object_id%TYPE,
-- grantee_id in parties.party_id%TYPE,
-- privilege in acs_privileges.privilege%TYPE
-- );
--
-- procedure grant_permission (
-- --/** Grant the specified privilege to another user. If the donation is
-- -- not possible, the procedure does nothing.
-- -- @author Karl Goldstein
-- -- @param object_id The object whose permissions are to be changed
-- -- @param holder_id The person who is attempting to grant the permissions
-- -- @param privilege The privilege to be granted
-- -- @param recepient_id The person who will gain the privilege
-- -- @param is_recursive If 't', applies the donation recursively to
-- -- all child objects of the object (equivalent to UNIX's chmod -r).
-- -- If 'f', only affects the objects itself.
-- -- @see {content_permission.has_grant_authority}, {content_permission.revoke_permission},
-- -- {acs_permission.grant_permission}
-- --*/
-- object_id in acs_objects.object_id%TYPE,
-- holder_id in parties.party_id%TYPE,
-- privilege in acs_privileges.privilege%TYPE,
-- recepient_id in parties.party_id%TYPE,
-- is_recursive in varchar2 default 'f',
-- object_type in acs_objects.object_type%TYPE default 'content_item'
-- );
--
-- function has_revoke_authority (
-- --/** Determine if the user may take a certain permission away from another
-- -- user. The permission may only be revoked if the user has
-- -- the permission himself and posesses the cm_perm access, while the
-- -- other user does not, or if the user posesses the cm_perm_admin access.
-- -- @author Karl Goldstein
-- -- @param object_id The object whose permissions are to be changed
-- -- @param holder_id The person who is attempting to revoke the permissions
-- -- @param privilege The privilege to be revoked
-- -- @param revokee_id The user from whom the privilege is to be taken away
-- -- @return 't' if it is possible to revoke the privilege, 'f' otherwise
-- -- @see {content_permission.has_grant_authority}, {content_permission.revoke_permission},
-- -- {acs_permission.revoke_permission}
-- --*/
-- object_id in acs_objects.object_id%TYPE,
-- holder_id in parties.party_id%TYPE,
-- privilege in acs_privileges.privilege%TYPE,
-- revokee_id in parties.party_id%TYPE
-- ) return varchar2;
--
-- procedure revoke_permission_h (
-- --/** This is a helper function for content_permission.revoke_permission and
-- -- should not be called individually.
-- -- Revokes a permission but grants all child permissions to the holder, to
-- -- ensure that the permission is not permanently lost
-- -- @author Karl Goldstein
-- -- @param object_id The object whose permissions are to be changed
-- -- @param revokee_id The person who should lose the parent permission
-- -- @param privilege The parent privilege to be revoked
-- -- @see {content_permission.revoke_permission}
-- --*/
-- object_id in acs_objects.object_id%TYPE,
-- revokee_id in parties.party_id%TYPE,
-- privilege in acs_privileges.privilege%TYPE
-- );
--
-- procedure revoke_permission (
-- --/** Take the specified privilege away from another user. If the operation is
-- -- not possible, the procedure does nothing.
-- -- @author Karl Goldstein
-- -- @param object_id The object whose permissions are to be changed
-- -- @param holder_id The person who is attempting to revoke the permissions
-- -- @param privilege The privilege to be revoked
-- -- @param recepient_id The person who will lose the privilege
-- -- @param is_recursive If 't', applies the operation recursively to
-- -- all child objects of the object (equivalent to UNIX's chmod -r).
-- -- If 'f', only affects the objects itself.
-- -- @see {content_permission.grant_permission}, {content_permission.has_revoke_authority},
-- -- {acs_permission.revoke_permission}
-- --*/
-- object_id in acs_objects.object_id%TYPE,
-- holder_id in parties.party_id%TYPE,
-- privilege in acs_privileges.privilege%TYPE,
-- revokee_id in parties.party_id%TYPE,
-- is_recursive in varchar2 default 'f',
-- object_type in acs_objects.object_type%TYPE default 'content_item'
-- );
--
-- function permission_p (
-- --/** Determine if the user has the specified permission on the specified
-- -- object. Does NOT check objects recursively: that is, if the user has
-- -- the permission on the parent object, he does not automatically gain
-- -- the permission on all the child objects.
-- -- @author Karl Goldstein
-- -- @param object_id The object whose permissions are to be checked
-- -- @param holder_id The person whose permissions are to be examined
-- -- @param privilege The privilege to be checked
-- -- @return 't' if the user has the specified permission on the object,
-- -- 'f' otherwise
-- -- @see {content_permission.grant_permission}, {content_permission.revoke_permission},
-- -- {acs_permission.permission_p}
-- --*/
-- object_id in acs_objects.object_id%TYPE,
-- holder_id in parties.party_id%TYPE,
-- privilege in acs_privileges.privilege%TYPE
-- ) return varchar2;
--
-- function cm_admin_exists
-- -- /** Determine if there exists a user who has administrative
-- -- privileges on the entire content repository.
-- -- @author Stanislav Freidin
-- -- @return 't' if an administrator exists, 'f' otherwise
-- -- @see {content_permission.grant_permission}
-- return varchar2;
--
-- end content_permission;
-- show errors
\i content-type.sql
\i content-item.sql
\i content-revision.sql
\i content-symlink.sql
\i content-extlink.sql
\i content-folder.sql
\i content-template.sql
\i content-keyword.sql