1 PACKAGE Pv_User_Resp_Pvt AUTHID CURRENT_USER AS
2 /* $Header: pvxvpurs.pls 120.0 2005/05/27 15:53:13 appldev noship $*/
3
4 -- ===============================================================
5 -- Start of Comments
6 -- Package name
7 -- PV_USER_RESP_PUB
8 -- Purpose
9 --
10 -- History
11 -- 24-OCT-2002 Jessica.Lee Created
12 -- 02-OCT-2003 Karen.Tsao Modified for 11.5.10
13 -- 12-NOV-2003 Karen.Tsao Added function manage_resp_on_address_change()
14 -- for business event subscription.
15 -- 14-NOV-2003 Karen.Tsao Split manage_store_resp_on_update into manage_store_resp_on_create and
16 -- manage_store_resp_on_delete.
17 -- 19-FEB-2004 Karen.Tsao Fixed for bug 3436285. Added adjust_user_resps() API.
18 -- 13-AUG-2004 Karen.Tsao Fixed for bug 3830319. Created manage_merged_party_memb_resp() API for party merge routine.
19 -- 18-AUG-2004 Karen.Tsao Updated the manage_merged_party_memb_resp() API by adding one extra parameter p_from_partner_id.
20 -- 14-APR-2004 Karen.Tsao Make update_resp_mapping into concurrent program call exec_cre_upd_del_resp_mapping (same as
21 -- create and delete). Therefore, change API name exec_cre_or_del_resp_mapping to exec_cre_upd_del_resp_mapping.
22 -- NOTE
23 --
24 -- End of Comments
25 -- ===============================================================
26
27 G_PRIMARY CONSTANT VARCHAR2(30) := 'PRIMARY';
28 G_BUSINESS CONSTANT VARCHAR2(30) := 'BUSINESS';
29 G_ALL CONSTANT VARCHAR2(30) := 'ALL';
30 G_PROGRAM CONSTANT VARCHAR2(30) := 'PROGRAMS';
31 G_STORE CONSTANT VARCHAR2(30) := 'STORES';
32
33 FUNCTION get_partner_users (
34 p_partner_id IN NUMBER,
35 p_user_role_code IN VARCHAR2
36 )
37 RETURN JTF_NUMBER_TABLE;
38
39 FUNCTION get_partners (
40 p_user_id IN NUMBER
41 )
42 RETURN JTF_NUMBER_TABLE;
43
44 PROCEDURE assign_resp
45 (
46 p_api_version_number IN NUMBER,
47 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
48 p_commit IN VARCHAR2 := Fnd_Api.g_false,
49 p_user_id IN NUMBER,
50 p_resp_id IN NUMBER,
51 p_app_id IN NUMBER,
52 X_Return_Status OUT NOCOPY VARCHAR2,
53 X_Msg_Count OUT NOCOPY NUMBER,
54 X_Msg_Data OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE revoke_resp(
58 p_api_version_number IN NUMBER,
59 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
60 p_commit IN VARCHAR2 := Fnd_Api.g_false,
61 p_user_id IN NUMBER,
62 p_resp_id IN NUMBER,
63 p_app_id IN NUMBER,
64 p_security_group_id IN NUMBER,
65 p_start_date IN DATE,
66 p_description IN VARCHAR2,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2
70 );
71
72 PROCEDURE revoke_resp(
73 p_api_version_number IN NUMBER,
74 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
75 p_commit IN VARCHAR2 := Fnd_Api.g_false,
76 p_user_id IN JTF_NUMBER_TABLE,
77 p_resp_id IN NUMBER,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE get_user_role_code(
84 p_user_id IN NUMBER
85 ,x_user_role_code OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE get_default_resp(
89 p_api_version_number IN NUMBER
90 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
91 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
92 ,x_return_status OUT NOCOPY VARCHAR2
93 ,x_msg_count OUT NOCOPY NUMBER
94 ,x_msg_data OUT NOCOPY VARCHAR2
95 ,p_partner_id IN NUMBER
96 ,p_user_role_code IN VARCHAR2
97 ,x_responsibility_id OUT NOCOPY NUMBER
98 ,x_resp_map_rule_id OUT NOCOPY NUMBER
99 );
100
101 PROCEDURE get_default_org_resp(
102 p_api_version_number IN NUMBER
103 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
105 ,x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 ,p_partner_org_id IN NUMBER
109 ,p_user_role_code IN VARCHAR2
110 ,x_responsibility_id OUT NOCOPY NUMBER
111 ,x_resp_map_rule_id OUT NOCOPY NUMBER
112 );
113
114 PROCEDURE get_program_resp(
115 p_api_version_number IN NUMBER
116 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
117 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
118 ,x_return_status OUT NOCOPY VARCHAR2
119 ,x_msg_count OUT NOCOPY NUMBER
120 ,x_msg_data OUT NOCOPY VARCHAR2
121 ,p_partner_id IN NUMBER
122 ,p_user_role_code IN VARCHAR2
123 ,p_program_id IN NUMBER
124 ,x_responsibility_id OUT NOCOPY NUMBER
125 ,x_resp_map_rule_id OUT NOCOPY NUMBER
126 );
127
128 PROCEDURE assign_first_user_resp(
129 p_api_version_number IN NUMBER
130 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
131 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
132 ,x_return_status OUT NOCOPY VARCHAR2
133 ,x_msg_count OUT NOCOPY NUMBER
134 ,x_msg_data OUT NOCOPY VARCHAR2
135 ,p_resp_map_rule_id IN NUMBER
136 ,p_responsibility_id IN NUMBER
137 ,p_partner_id IN NUMBER
138 ,p_user_id IN NUMBER
139 );
140
141 PROCEDURE assign_user_resps(
142 p_api_version_number IN NUMBER
143 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
144 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
145 ,x_return_status OUT NOCOPY VARCHAR2
146 ,x_msg_count OUT NOCOPY NUMBER
147 ,x_msg_data OUT NOCOPY VARCHAR2
148 ,p_user_id IN NUMBER
149 ,p_user_role_code IN VARCHAR2
150 );
151
152 PROCEDURE assign_user_resps(
153 p_api_version_number IN NUMBER
154 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
155 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
156 ,x_return_status OUT NOCOPY VARCHAR2
157 ,x_msg_count OUT NOCOPY NUMBER
158 ,x_msg_data OUT NOCOPY VARCHAR2
159 ,p_user_name IN VARCHAR2
160 );
161
162 PROCEDURE switch_user_resp(
163 p_api_version_number IN NUMBER
164 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
165 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
166 ,x_return_status OUT NOCOPY VARCHAR2
167 ,x_msg_count OUT NOCOPY NUMBER
168 ,x_msg_data OUT NOCOPY VARCHAR2
169 ,p_user_id IN NUMBER
170 ,p_from_user_role_code IN VARCHAR2
171 ,p_to_user_role_code IN VARCHAR2
172 );
173
174 PROCEDURE manage_memb_resp(
175 p_api_version_number IN NUMBER
176 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178 ,x_return_status OUT NOCOPY VARCHAR2
179 ,x_msg_count OUT NOCOPY NUMBER
180 ,x_msg_data OUT NOCOPY VARCHAR2
181 ,p_membership_id IN NUMBER
182 );
183
184 PROCEDURE delete_resp_mapping(
185 p_api_version_number IN NUMBER
186 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
187 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
188 ,x_return_status OUT NOCOPY VARCHAR2
189 ,x_msg_count OUT NOCOPY NUMBER
190 ,x_msg_data OUT NOCOPY VARCHAR2
191 ,p_source_resp_map_rule_id IN NUMBER
192 );
193
194 PROCEDURE update_resp_mapping(
195 p_api_version_number IN NUMBER
196 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
197 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
198 ,x_return_status OUT NOCOPY VARCHAR2
199 ,x_msg_count OUT NOCOPY NUMBER
200 ,x_msg_data OUT NOCOPY VARCHAR2
201 ,p_source_resp_map_rule_id IN NUMBER
202 );
203
204 PROCEDURE create_resp_mapping(
205 p_api_version_number IN NUMBER
206 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
207 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
208 ,x_return_status OUT NOCOPY VARCHAR2
209 ,x_msg_count OUT NOCOPY NUMBER
210 ,x_msg_data OUT NOCOPY VARCHAR2
211 ,p_source_resp_map_rule_id IN NUMBER
212 );
213
214 PROCEDURE manage_resp_on_address_change(
215 p_api_version_number IN NUMBER
216 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
217 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
218 ,x_return_status OUT NOCOPY VARCHAR2
219 ,x_msg_count OUT NOCOPY NUMBER
220 ,x_msg_data OUT NOCOPY VARCHAR2
221 ,p_org_party_id IN NUMBER
222 );
223
224 PROCEDURE revoke_user_resps(
225 p_api_version_number IN NUMBER
226 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
227 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
228 ,x_return_status OUT NOCOPY VARCHAR2
229 ,x_msg_count OUT NOCOPY NUMBER
230 ,x_msg_data OUT NOCOPY VARCHAR2
231 ,p_user_id IN NUMBER
232 ,p_user_role_code IN VARCHAR2
233 );
234
235 PROCEDURE revoke_user_resps(
236 p_api_version_number IN NUMBER
237 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
238 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
239 ,x_return_status OUT NOCOPY VARCHAR2
240 ,x_msg_count OUT NOCOPY NUMBER
241 ,x_msg_data OUT NOCOPY VARCHAR2
242 ,p_user_name IN VARCHAR2
243 );
244
245 PROCEDURE manage_store_resp_on_create(
246 p_api_version_number IN NUMBER
247 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
248 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
249 ,x_return_status OUT NOCOPY VARCHAR2
250 ,x_msg_count OUT NOCOPY NUMBER
251 ,x_msg_data OUT NOCOPY VARCHAR2
252 ,p_resp_map_rule_id IN NUMBER
253 ,p_resp_id IN NUMBER
254 ,p_program_id IN NUMBER
255 );
256
257 PROCEDURE manage_store_resp_on_delete(
258 p_api_version_number IN NUMBER
259 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
260 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
261 ,x_return_status OUT NOCOPY VARCHAR2
262 ,x_msg_count OUT NOCOPY NUMBER
263 ,x_msg_data OUT NOCOPY VARCHAR2
264 ,p_resp_map_rule_id IN NUMBER
265 );
266
267
268 PROCEDURE assign_default_resp (
269 p_api_version_number IN NUMBER
270 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
271 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
272 ,x_return_status OUT NOCOPY VARCHAR2
273 ,x_msg_count OUT NOCOPY NUMBER
274 ,x_msg_data OUT NOCOPY VARCHAR2
275 ,p_partner_id IN NUMBER
276 );
277
278 PROCEDURE revoke_default_resp (
279 p_api_version_number IN NUMBER
280 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
281 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
282 ,x_return_status OUT NOCOPY VARCHAR2
283 ,x_msg_count OUT NOCOPY NUMBER
284 ,x_msg_data OUT NOCOPY VARCHAR2
285 ,p_partner_id IN NUMBER
286 );
287
288 PROCEDURE adjust_user_resps
289 (
290 p_api_version_number IN NUMBER
291 ,p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false
292 ,p_commit IN VARCHAR2 := Fnd_Api.g_false
293 ,x_return_status OUT NOCOPY VARCHAR2
294 ,x_msg_count OUT NOCOPY NUMBER
295 ,x_msg_data OUT NOCOPY VARCHAR2
296 ,p_user_id IN NUMBER
297 ,p_def_resp_id IN NUMBER
298 ,p_user_role_code IN VARCHAR2
299 ,p_partner_id IN NUMBER
300 );
301
302 procedure exec_cre_upd_del_resp_mapping (
303 ERRBUF OUT NOCOPY VARCHAR2
304 ,RETCODE OUT NOCOPY VARCHAR2
305 ,p_action IN VARCHAR2
306 ,p_source_resp_map_rule_id IN NUMBER
307 );
308
309 procedure exec_asgn_or_rvok_user_resps (
310 ERRBUF OUT NOCOPY VARCHAR2
311 ,RETCODE OUT NOCOPY VARCHAR2
312 ,p_action IN VARCHAR2
313 ,p_user_name IN VARCHAR2
314 );
315
316 FUNCTION manage_resp_on_address_change
317 ( p_subscription_guid in raw,
318 p_event in out NOCOPY wf_event_t
319 )
320 RETURN VARCHAR2;
321
322 PROCEDURE manage_merged_party_memb_resp(
323 p_api_version_number IN NUMBER
324 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
325 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
326 ,x_return_status OUT NOCOPY VARCHAR2
327 ,x_msg_count OUT NOCOPY NUMBER
328 ,x_msg_data OUT NOCOPY VARCHAR2
329 ,p_from_partner_id IN NUMBER
330 ,p_to_partner_id IN NUMBER
331 );
332
333 END Pv_User_Resp_Pvt;