Previous	Next		Contents	Index	Glossary

procedure PropagateUserRole

     (p_user_name in varchar2,

      p_role_name in varchar2,

      p_user_orig_system in varchar2 default null,

      p_user_orig_system_id in number default null,

      p_role_orig_system in varchar2 default null,

      p_role_orig_system_id in number default null,

      p_start_date in date default null, 

      p_expiration_date in date default null, 

      p_overwrite in boolean default FALSE, 

      p_raiseErrors in boolean default FALSE,

      p_parent_orig_system in varchar2 default null,

      p_parent_orig_system_id in varchar2 default null,

      p_ownerTag in varchar2 default null,

      p_createdBy in number default null,

      p_lastUpdatedBy in number default null,

      p_lastUpdateLogin in number default null,

      p_creationDate in date default null,

      p_lastUpdateDate in date default null);

Description

Synchronizes the information for an association of a user and a role from an application table with the WF_LOCAL_USER_ROLES table.

Arguments (input)

p_user_name	The internal name of the user.
p_role_name	The internal name of the role.
p_user_orig_ system	A code that you assign to the directory repository that is the source of the user information.
p_user_orig_ system_id	The primary key that identifies the user in this repository system.
p_role_orig_ system	A code that you assign to the directory repository that is the source of the role information.
p_role_orig_ system_id	The primary key that identifies the role in this repository system.
p_start_date	The date at which the association of this user with this role becomes valid in the directory service.
p_expiration_ date	The date at which the association of this user with this role is no longer valid in the directory service.
p_overwrite	Specify TRUE or FALSE to determine whether to propagate the information in overwrite mode. In overwrite mode, if any attribute is not passed or is null, the procedure sets the value of the corresponding field in WF_LOCAL_USER_ROLES to null, deleting the previous value.

Note: Overwrite mode does not affect the user name and role name attributes. You must pass values for these parameters, because they are required for this procedure, and because the USER_NAME and ROLE_NAME columns in the WF_LOCAL_USER_ROLES table have a NOT NULL constraint.

p_raiseErrors	Specify TRUE or FALSE to determine whether the procedure should raise an exception if it encounters an error.
p_parent_orig_ system	A code for the originating system of an entity that you want to mark as being related to the association of this user with this role.
p_parent_orig_ system_id	The primary key that identifies the parent entity in the parent originating system.
p_ownerTag	A code to identify the program or application that owns the information for the association of this user with this role.
p_createdBy	Standard Who column.
p_lastUpdatedBy	Standard Who column.
p_lastUpdate Login	Standard Who column.
p_creationDate	Standard Who column.
p_lastUpdate Date	Standard Who column.