1 PACKAGE JTF_CAL_GRANTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvcgts.pls 115.5 2002/11/14 22:16:27 jawang ship $ */
3
4 /*******************************************************************************
5 ** Record type that holds a resource's GranteeKey, GrantType and Access Level
6 *******************************************************************************/
7 TYPE Grantee IS RECORD
8 ( GranteeKey fnd_grants.grantee_key%TYPE /*JTF_RESOURCE resource ID or Username of the logged on user */
9 ,GrantType NUMBER NOT NULL :=1 /* Grant Type, 1 for Insert */
10 ,AccessLevel VARCHAR2(30)
11 );
12
13 /*******************************************************************************
14 ** PL/SQL table TYPE definition for resource lists
15 *******************************************************************************/
16 TYPE GranteeTbl IS TABLE OF Grantee INDEX BY BINARY_INTEGER;
17
18 CALENDAR_OBJECT CONSTANT VARCHAR2(30) := 'JTF_TASK_RESOURCE';
19 CALENDAR_READ_ROLE CONSTANT VARCHAR2(30) := 'JTF_CAL_READ_ACCESS';
20 CALENDAR_FULL_ROLE CONSTANT VARCHAR2(30) := 'JTF_CAL_FULL_ACCESS';
21 CALENDAR_READ_PRIVILEGE CONSTANT VARCHAR2(30) := 'JTF_CAL_READ_ACCESS';
22 CALENDAR_FULL_PRIVILEGE CONSTANT VARCHAR2(30) := 'JTF_CAL_FULL_ACCESS';
23 CALENDAR_INSTANCE_TYPE CONSTANT VARCHAR2(30) := 'INSTANCE';
24 CALENDAR_RESOURCE_TYPE CONSTANT VARCHAR2(30) := 'RS_EMPLOYEE';
25 GRANTEE_TYPE CONSTANT VARCHAR2(30) := 'USER';
26 PROGRAM_NAME CONSTANT VARCHAR2(30) := 'CALENDAR';
27 PROGRAM_TAG CONSTANT VARCHAR2(30) := 'ACCESS LEVEL';
28
29 TASK_INSTANCE_TYPE CONSTANT VARCHAR2(30) := 'SET';
30
31 PROCEDURE UpdateGrants
32 /*******************************************************************************
33 ** Given:
34 ** - the Granter
35 ** - a list of Read Only Grantees
36 ** - a list of Full Access Grantees
37 ** This API will make sure that the proper grants are create/deleted
38 *******************************************************************************/
39 ( p_api_version IN NUMBER
40 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
41 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
42 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
43 , x_return_status OUT NOCOPY VARCHAR2
44 , x_msg_count OUT NOCOPY NUMBER
45 , x_msg_data OUT NOCOPY VARCHAR2
46 , p_GranterID IN VARCHAR2
47 , p_ReadAccess IN VARCHAR2
48 , p_FullAccess IN VARCHAR2
49 );
50
51 PROCEDURE RevokeGrants
52 /*******************************************************************************
53 ** Given:
54 ** - the resource Id
55 ** - the group calendar Id
56 ** This API will revoke the grant to the given group calendar
57 for the given resource Id
58 ********************************************************************************/
59 (
60 p_api_version IN NUMBER
61 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
62 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
63 , x_return_status OUT NOCOPY VARCHAR2
64 , x_msg_count OUT NOCOPY NUMBER
65 , x_msg_data OUT NOCOPY VARCHAR2
66 , p_resourceId IN VARCHAR2
67 , p_groupId IN VARCHAR2
68 );
69
70 PROCEDURE InvokeGrants
71 /*******************************************************************************
72 ** Given:
73 ** - the resource Id
74 ** - the group calendar Id
75 ** This API will grant the Administrator Priv. to the given group calendar
76 for the given resource Id
77 ********************************************************************************/
78 (
79 p_api_version IN NUMBER
80 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
81 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
82 , x_return_status OUT NOCOPY VARCHAR2
83 , x_msg_count OUT NOCOPY NUMBER
84 , x_msg_data OUT NOCOPY VARCHAR2
85 , p_resourceId IN VARCHAR2
86 , p_groupId IN VARCHAR2
87 , p_accesslevel In VARCHAR2
88 );
89
90 FUNCTION get_grant_guid
91 /*****************************************************************************
92 ** Given:
93 ** - the resource Id
94 ** - the group calendar Id
95 ** This API return the grant_guid for the given resource Id
96 and the group calenar Id
97 ******************************************************************************/
98 ( p_resourceId IN VARCHAR2
99 , p_groupId IN VARCHAR2
100 ) RETURN RAW;
101
102 FUNCTION has_access_level
103 /*****************************************************************************
104 ** Given:
105 ** - the resource Id
106 ** - the group calendar Id
107 ** This API returns the boolean value whether the given resource Id already has
108 ** an access level for the given group Id
109 ******************************************************************************/
110 ( p_resourceId IN VARCHAR2
111 , p_groupId IN VARCHAR2
112 ) RETURN BOOLEAN;
113
114 END JTF_CAL_GRANTS_PVT;