1 package WF_MAINTENANCE AUTHID CURRENT_USER as
2 /* $Header: wfmtns.pls 120.8.12020000.2 2012/07/13 20:54:14 alsosa 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_username in varchar2 default null,
28 p_rolename in varchar2 default null,
29 p_check_dangling in BOOLEAN default null,
30 p_check_missing_ura in BOOLEAN default null,
31 p_UpdateWho in BOOLEAN default null,
32 p_parallel_processes in number default null);
33
34 TYPE wfcount_type IS RECORD (table_name USER_TABLES.TABLE_NAME%TYPE,
35 user_name WF_LOCAL_ROLES.NAME%TYPE,
36 rec_cnt NUMBER);
37 TYPE wfcount_tab IS TABLE OF wfcount_type;
38 /*
39 ** GetUsernameChangeCounts
40 ** This procedure is created off bug 12365810 which is used by FND
41 ** team to assess the processing required to change the name of a user.
42 ** It will read the WFDS and WF Runtime tables to determine these counts.
43 */
44 function GetUsernameChangeCounts(p_name VARCHAR2) RETURN wfcount_tab pipelined;
45
46 end WF_MAINTENANCE;