1 PACKAGE UMX_ACCESS_ROLES_PVT AUTHID CURRENT_USER AS
2 /*$Header: UMXVARPS.pls 120.2.12010000.2 2009/12/02 18:25:10 jstyles ship $*/
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_LOCAL_SYNC.propagateUserRole which passes the hardcoded overwrite boolean flag */
33 /* This one allows assignmentReason to be overwritten */
34 PROCEDURE propagateUserRole(p_user_name in varchar2,
35 p_role_name in varchar2,
36 p_start_date in date,
37 p_expiration_date in date,
38 p_assignmentReason in varchar2);
39
40 /* Wrapper on top of WF_ROLE_HIERARCHY.propagateUserRole which passes the hardcoded overwrite boolean flag */
41 function HierarchyEnabled (p_origSystem in VARCHAR2) return varchar2;
42
43 --
44 -- TEST
45 -- Wrapper to Test if function is accessible under current responsibility.
46 -- IN
47 -- p_function_name - function to test
48 -- p_TEST_MAINT_AVAILABILTY - 'Y' (default) means check if available for
49 -- current value of profile APPS_MAINTENANCE_MODE
50 -- 'N' means the caller is checking so it's
51 -- unnecessary to check.
52 -- RETURNS
53 -- 'Y' if function is accessible
54 --
55 function test (p_function_name in varchar2,
56 p_test_maint_availability in varchar2 default 'Y') return varchar2;
57
58 end UMX_ACCESS_ROLES_PVT;