1 PACKAGE UMX_ACCESS_ROLES_PVT AS
2 /*$Header: UMXVARPS.pls 120.2 2005/10/28 16:16:44 kching noship $*/
3
4 function getParentRoles(p_role_name varchar2) return varchar2;
5
6 function getAffectedRoles(p_role_name varchar2) return varchar2;
7
8 PROCEDURE insert_role(p_role_name in varchar2,
9 p_orig_system in varchar2,
10 p_orig_system_id in number,
11 p_start_date in date,
12 p_expiration_date in date,
13 p_display_name in varchar2,
14 p_owner_tag in varchar2,
15 p_description in varchar2);
16
17 PROCEDURE update_role(p_role_name in varchar2,
18 p_orig_system in varchar2,
19 p_orig_system_id in number,
20 p_start_date in date,
21 p_expiration_date in date,
22 p_display_name in varchar2,
23 p_owner_tag in varchar2,
24 p_description in varchar2);
25
26 /* Wrapper on top of WF_LOCAL_SYNC.propagateUserRole which passes the hardcoded overwrite boolean flag */
27 PROCEDURE propagateUserRole(p_user_name in varchar2,
28 p_role_name in varchar2,
29 p_start_date in date,
30 p_expiration_date in date);
31
32 /* Wrapper on top of WF_ROLE_HIERARCHY.propagateUserRole which passes the hardcoded overwrite boolean flag */
33 function HierarchyEnabled (p_origSystem in VARCHAR2) return varchar2;
34
35 --
36 -- TEST
37 -- Wrapper to Test if function is accessible under current responsibility.
38 -- IN
39 -- p_function_name - function to test
40 -- p_TEST_MAINT_AVAILABILTY - 'Y' (default) means check if available for
41 -- current value of profile APPS_MAINTENANCE_MODE
42 -- 'N' means the caller is checking so it's
43 -- unnecessary to check.
44 -- RETURNS
45 -- 'Y' if function is accessible
46 --
47 function test (p_function_name in varchar2,
48 p_test_maint_availability in varchar2 default 'Y') return varchar2;
49
50 end UMX_ACCESS_ROLES_PVT;
[Home] [Help]