1 PACKAGE dom_security_pub AS
2 /* $Header: DOMDATASECS.pls 120.6 2006/11/08 14:01:02 ysireesh noship $ */
3
4
5 PROCEDURE Grant_Document_Role
6 (
7 p_api_version IN NUMBER,
8 p_init_msg_list IN VARCHAR2,
9 p_commit IN VARCHAR2 := FND_API.G_FALSE,
10 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11 p_object_name IN VARCHAR2,
12 p_pk1_value IN VARCHAR2, -- Document_Id
13 p_pk2_value IN VARCHAR2, -- Revision_Id
14 p_pk3_value IN VARCHAR2, -- Change_Id
15 p_pk4_value IN VARCHAR2,
16 p_pk5_value IN VARCHAR2,
17 p_party_ids IN FND_TABLE_OF_NUMBER,
18 p_role_id IN NUMBER,
19 p_start_date IN DATE := SYSDATE,
20 p_end_date IN DATE := NULL,
21 p_api_caller IN VARCHAR2 := NULL,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 x_return_status OUT NOCOPY VARCHAR2
25 );
26 -- Start OF comments
27 -- API name : Grant_Document_Role
28 -- TYPE : Public
29 -- Pre-reqs : None
30 -- FUNCTION : Grant a Role on object to a given set of users.
31 -- If this operation fails then the grant is not
32 -- done and error code is returned.
33 -- Parameters:
34 -- p_api_version IN NUMBER
35 -- p_init_msg_list IN VARCHAR2 FND_API.G_FALSE / FND_API.G_TRUE
36 -- p_commit IN VARCHAR2 FND_API.G_FALSE / FND_API.G_TRUE
37 -- p_validation_level IN NUMBER FND_API.G_VALID_LEVEL_FULL
38 -- p_object_name IN VARCHAR2 Object_Name Required
39 -- p_pk1_value IN VARCHAR2 Required
40 -- p_pk2_value IN VARCHAR2 Required
41 -- p_pk3_value IN VARCHAR2 Required
42 -- p_pk4_value IN VARCHAR2 Required
43 -- p_pk5_value IN VARCHAR2 Required
44 -- p_party_ids IN FND_TABLE_OF_NUMBER Array of Person's HZ_PARTIES.PARTY_IDs
45 -- p_role_id IN NUMBER FND_MENUS.MENU_ID, Role Id to be granted
46 -- p_start_date IN DATE
47 -- p_end_date IN DATE
48 -- p_api_caller IN VARCHAR2
49 --
50 -- Returns:
51 -- x_msg_count NUMBER
52 -- x_msg_data VARCHAR2
53 -- x_return_status VARCHAR2
54 --
55 -- Version : Current Version 0.1
56 -- Previous
57 -- Version : None
58 -- Notes :
59 --
60 -- END OF comments
61
62
63 PROCEDURE Revoke_Document_Role
64 (
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2,
67 p_commit IN VARCHAR2 := FND_API.G_FALSE,
68 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69 p_object_name IN VARCHAR2,
70 p_pk1_value IN VARCHAR2,
71 p_pk2_value IN VARCHAR2,
72 p_pk3_value IN VARCHAR2,
73 p_pk4_value IN VARCHAR2,
74 p_pk5_value IN VARCHAR2,
75 p_party_ids IN FND_TABLE_OF_NUMBER,
76 p_role_id IN NUMBER,
77 p_api_caller IN VARCHAR2 := NULL,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 x_return_status OUT NOCOPY VARCHAR2
81 );
82 -- Start OF comments
83 -- API name : Revoke_Document_Role
84 -- TYPE : Public
85 -- Pre-reqs : None
86 -- FUNCTION : Revoke a Role for a given set of users on an object.
87 -- If this operation fails then the revoke operation
88 -- is not done and error code is returned.
89 -- Parameters:
90 -- p_api_version IN NUMBER
91 -- p_init_msg_list IN VARCHAR2 FND_API.G_FALSE / FND_API.G_TRUE
92 -- p_commit IN VARCHAR2 FND_API.G_FALSE / FND_API.G_TRUE
93 -- p_validation_level IN NUMBER FND_API.G_VALID_LEVEL_FULL
94 -- p_object_name IN VARCHAR2 Object_Name Required
95 -- p_pk1_value IN VARCHAR2 Required
96 -- p_pk2_value IN VARCHAR2 Required
97 -- p_pk3_value IN VARCHAR2 Required
98 -- p_pk4_value IN VARCHAR2 Required
99 -- p_pk5_value IN VARCHAR2 Required
100 -- p_party_ids IN FND_TABLE_OF_NUMBER Array of Person's HZ_PARTIES.PARTY_IDs
101 -- p_role_id IN NUMBER FND_MENUS.MENU_ID, Role Id to be revoked
102 -- p_api_caller IN VARCHAR2
103 --
104 -- Returns:
105 -- x_msg_count NUMBER
106 -- x_msg_data VARCHAR2
107 -- x_return_status VARCHAR2
108 --
109 -- Version : Current Version 0.1
110 -- Previous
111 -- Version : None
112 -- Notes :
113 --
114 -- END OF comments
115
116
117 PROCEDURE Get_User_Roles
118 (
119 p_object_id IN NUMBER,
120 p_document_id IN NUMBER,
121 p_revision_id IN NUMBER,
122 p_change_id IN NUMBER,
123 p_change_line_id IN NUMBER,
124 p_party_id IN NUMBER,
125 x_role_ids OUT NOCOPY FND_ARRAY_OF_NUMBER_25
126 ) ;
127
128
129 FUNCTION check_user_privilege
130 (
131 p_api_version IN NUMBER,
132 p_privilege IN VARCHAR2,
133 p_object_name IN VARCHAR2,
134 p_instance_pk1_value IN VARCHAR2,
135 p_instance_pk2_value IN VARCHAR2,
136 p_instance_pk3_value IN VARCHAR2,
137 p_instance_pk4_value IN VARCHAR2,
138 p_instance_pk5_value IN VARCHAR2,
139 p_party_id IN NUMBER
140 )
141 RETURN VARCHAR2;
142
143
144
145 PROCEDURE Grant_Attachments_OCSRole
146 (
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2,
149 p_commit IN VARCHAR2 := FND_API.G_FALSE,
150 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151 p_entity_name IN VARCHAR2,
152 p_pk1_value IN VARCHAR2,
153 p_pk2_value IN VARCHAR2,
154 p_pk3_value IN VARCHAR2,
155 p_pk4_value IN VARCHAR2,
156 p_pk5_value IN VARCHAR2,
157 p_ocs_role IN VARCHAR2,
158 p_party_ids IN FND_TABLE_OF_NUMBER,
159 p_api_caller IN VARCHAR2 := NULL,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 x_return_status OUT NOCOPY VARCHAR2
163 );
164
165
166 PROCEDURE Grant_Attachment_Access
167 (
168 p_api_version IN NUMBER,
169 p_attached_document_id IN NUMBER := NULL,
170 p_source_media_id IN NUMBER,
171 p_repository_id IN NUMBER,
172 p_ocs_role IN VARCHAR2,
173 p_party_ids IN FND_TABLE_OF_NUMBER,
174 p_submitted_by IN NUMBER,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 x_return_status OUT NOCOPY VARCHAR2
178 );
179
180
181 PROCEDURE Revoke_Attachments_OCSRole
182 (
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2,
185 p_commit IN VARCHAR2 := FND_API.G_FALSE,
186 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187 p_entity_name IN VARCHAR2,
188 p_pk1_value IN VARCHAR2,
189 p_pk2_value IN VARCHAR2,
190 p_pk3_value IN VARCHAR2,
191 p_pk4_value IN VARCHAR2,
192 p_pk5_value IN VARCHAR2,
193 p_ocs_role IN VARCHAR2,
194 p_party_ids IN FND_TABLE_OF_NUMBER,
195 p_api_caller IN VARCHAR2 := NULL,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 x_return_status OUT NOCOPY VARCHAR2
199 );
200
201
202 FUNCTION Check_For_Duplicate_Grant
203 (
204 p_entity_name IN VARCHAR2,
205 p_pk1_value IN VARCHAR2,
206 p_pk2_value IN VARCHAR2,
207 p_pk3_value IN VARCHAR2,
208 p_pk4_value IN VARCHAR2,
209 p_pk5_value IN VARCHAR2,
210 p_file_id IN NUMBER,
211 p_repos_id IN NUMBER,
212 p_party_id IN NUMBER
213 )
214 RETURN NUMBER;
215
216
217 END DOM_SECURITY_PUB;