1 package WF_MAINTENANCE as
2 /* $Header: wfmtns.pls 120.3.12010000.2 2008/08/27 17:44:37 alepe ship $ */
3
4 g_CommitFrequency NUMBER := 500;
5
6
7 -- procedure PropagateChangedName
8 -- Locates all occurrences of an old username and changes to
9 -- the new username.
10 --
11 -- IN:
12 -- OldName - Old Username we are changing from.
13 -- NewName - New Username we are changing to.
14 -- docommit - boolean default false.
15 --
16 procedure PropagateChangedName(
17 OldName in varchar2,
18 NewName in varchar2,
19 docommit in BOOLEAN default FALSE);
20
21 ------------------------------------------------------------------------------
22 /*
23 ** ValidateUserRoles - Validates and corrects denormalized user and role
24 ** information in user/role relationships.
25 */
26 PROCEDURE ValidateUserRoles(p_BatchSize in NUMBER default null,
27 p_check_dangling in BOOLEAN default null,
28 p_check_missing_ura in BOOLEAN default null,
29 p_UpdateWho in BOOLEAN default null,
30 p_parallel_processes in number default null);
31
32 end WF_MAINTENANCE;