[Home] [Help]
PACKAGE: APPS.UMX_FGA_UTILS_PKG
Source
1 package UMX_FGA_UTILS_PKG AUTHID CURRENT_USER as
2 /* $Header: UMXFGAUTILS.pls 120.5.12010000.6 2009/09/09 10:36:51 kkasibha noship $ */
3
4 procedure convert_All_Grants_to_roleSets;
5
6 procedure create_roleSet_from_grants(adminRole varchar2);
7
8 procedure create_global_privileges(adminRole varchar2,
9 canCreate number,
10 GLOBALPRIV2 number default 1,
11 GLOBALPRIV3 number default 1,
12 GLOBALPRIV4 number default 1,
13 GLOBALPRIV5 number default 1,
14 GLOBALPRIV6 number default 1,
15 GLOBALPRIV7 number default 1,
16 GLOBALPRIV8 number default 1,
17 GLOBALPRIV9 number default 1);
18
19 procedure create_assign_roleSet(adminRole varchar2,
20 roleSetName varchar2 default null,
21 roleName varchar2 default '%',
22 roleAapl varchar2 default '',
23 roleCat varchar2 default '',
24 canUpdate number default 1,
25 canManageGrants number default 1,
26 canAlterHierarchy number default 1,
27 canAssign number default 1,
28 canRevoke number default 1,
29 securityWizard number default 1,
30 PRIVILEGE7 number default 1,
31 PRIVILEGE8 number default 1,
32 PRIVILEGE9 number default 1,
33 PRIVILEGE10 number default 1,
34 PRIVILEGE11 number default 1,
35 PRIVILEGE12 number default 1,
36 PRIVILEGE13 number default 1,
37 PRIVILEGE14 number default 1);
38
39 function create_roleSet_criteria(roleSetId number default null,
40 roleSetName varchar2 default null,
41 roleName varchar2 default '%',
42 roleAapl varchar2 default null,
43 roleCat varchar2 default null)
44 return number;
45
46 procedure assign_roleSet_to_adminRole(adminRole varchar2,
47 roleSetId number,
48 canUpdate number default 1,
49 canManageGrants number default 1,
50 canAlterHierarchy number default 1,
51 canAssign number default 1,
52 canRevoke number default 1,
53 securityWizard number default 1,
54 PRIV7 number default 1,
55 PRIV8 number default 1,
56 PRIV9 number default 1,
57 PRIV10 number default 1,
58 PRIV11 number default 1,
59 PRIV12 number default 1,
60 PRIV13 number default 1,
61 PRIV14 number default 1);
62
63 procedure create_all_roles_roleset;
64
65 procedure bulk_add_all(p_role_set_id varchar2);
66
67 procedure bulk_add_all_for_new(p_role_set_id varchar2, p_role_name varchar2, p_role_appl varchar2, p_role_cat varchar2);
68
69 procedure bulk_remove_all(p_role_set_id varchar2);
70
71 procedure delete_role_Set(p_role_set_id varchar2,p_admin_role varchar2 default null);
72
73 function get(code in varchar2) return varchar2;
74
75 procedure set(code in varchar2, value in varchar2);
76
77 procedure clearViewParams;
78
79 end;