DBA Data[Home] [Help]

PACKAGE: APPS.WF_MAINTENANCE

Source


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;