1 PACKAGE AS_ACCESS_PUB AUTHID CURRENT_USER as
2 /* $Header: asxpacss.pls 120.1.12010000.2 2008/08/05 08:46:00 snsarava ship $ */
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- AS_ACCESS_PUB
8 --
9 -- PURPOSE
10 -- This package is a public API for manipulating access related info in
11 -- OSM. It contains specification for pl/sql records and tables and public
12 -- APIs
13 --
14 -- Procedures:
15 --
16 -- NOTES
17 -- This package is for public use
18 --
19 --
20
21
22 -- ***********************
23 -- Composite Types
24 -- ***********************
25
26 -- Start of Comments
27 --
28 -- Sales team (access Record): sales_team_rec_type
29 --
30 -- Parameters:
31 -- access_id
32 -- job_title
33 -- ptr_mgr_last_name
34 -- ptr_mgr_first_name
35 -- freeze_flag
36 -- reassign_flag
37 -- team_leader_flag
38 -- customer_id
39 -- address_id
40 -- salesforce_id
41 -- person_id
42 -- first_name
43 -- last_name
44 -- email_address
45 -- work_telephone
46 -- sales_group_id
47 -- sales_group_name
48 -- partner_customer_id
49 -- partner_address_id
50 -- partner_name
51 -- partner_number
52 -- partner_city
53 -- partner_phone_number
54 -- partner_area_code
55 -- partner_extension
56 -- created_person_id
57 -- lead_id
58 -- freeze_date
59 -- reassign_reason
60 -- downloadable_flag - obsolete
61 -- attribute_category
62 -- attribute1 -15
63 -- salesforce_relationship_code
64 -- salesforce_relationship
65 -- <BEGIN added by ACNG>
66 -- salesforce_role_code
67 -- sales_lead_id
68 -- partner_cont_party_id
69 -- <END>
70 -- Required:
71 -- ACCESS_ID
72 -- FREEZE_FLAG
73 -- REASSIGN_FLAG
74 -- TEAM_LEADER_FLAG
75 -- CUSTOMER_ID
76 -- ADDRESS_ID
77 --
78 --
79 -- Defaults:
80 --
81 -- End of Comments
82
83 TYPE sales_team_rec_type IS RECORD
84 (
85 access_id NUMBER := NULL
86 ,last_update_date DATE := FND_API.G_MISS_DATE
87 ,last_updated_by NUMBER := FND_API.G_MISS_NUM
88 ,creation_date DATE := FND_API.G_MISS_DATE
89 ,created_by NUMBER := FND_API.G_MISS_NUM
90 ,last_update_login NUMBER := FND_API.G_MISS_NUM
91 ,freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92 ,reassign_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93 ,team_leader_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
94 ,customer_id NUMBER := NULL
95 ,address_id NUMBER := NULL
96 ,salesforce_id NUMBER := NULL
97 ,person_id NUMBER := NULL
98 ,job_title VARCHAR2(240) := NULL -- Only used for query
99 -- ,ptr_mgr_last_name VARCHAR2(40) := NULL -- Only used for query
100 -- ,ptr_mgr_first_name VARCHAR2(20) := NULL -- Only used for query
101 ,first_name VARCHAR2(150) := FND_API.G_MISS_CHAR
102 ,last_name VARCHAR2(150) := FND_API.G_MISS_CHAR
103 ,email_address VARCHAR2(240) := FND_API.G_MISS_CHAR
104 ,work_telephone VARCHAR2(60) := FND_API.G_MISS_CHAR
105 ,sales_group_id NUMBER := FND_API.G_MISS_NUM
106 ,sales_group_name VARCHAR2(60) := FND_API.G_MISS_CHAR
107 ,partner_customer_id NUMBER := NULL
108 ,partner_address_id NUMBER := NULL
109 ,partner_name VARCHAR2(50) := FND_API.G_MISS_CHAR
110 ,partner_number VARCHAR2(30) := FND_API.G_MISS_CHAR
111 ,partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR
112 ,partner_phone_number VARCHAR2(25) := FND_API.G_MISS_CHAR
113 ,partner_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR
114 ,partner_extension VARCHAR2(20) := FND_API.G_MISS_CHAR
115 ,created_person_id NUMBER := NULL
116 ,lead_id NUMBER := NULL
117 ,freeze_date DATE := NULL
118 ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
119 ,reassign_request_date DATE := FND_API.G_MISS_DATE
120 ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
121 ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
122 ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
123 ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
124 ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
125 ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
126 ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
127 ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
128 ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
129 ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
130 ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
131 ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
132 ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
133 ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
134 ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
135 ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
136 ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
137 ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
138 ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
139 ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140 ,salesforce_relationship VARCHAR2(80) := FND_API.G_MISS_CHAR
141 -- <BEGIN added by ACNG>
142 ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
143 ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
144 -- <END>
145 ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
146 ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR
147 ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR
148 ,contributor_flag varchar2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
149 );
150
151 G_MISS_SALES_TEAM_REC sales_team_rec_type;
152
153
154 -- Start of Comments
155 --
156 -- Sales Team Table: sales_team_tbl_type
157 --
158 -- End of Comments
159
160 TYPE sales_team_tbl_type IS TABLE OF sales_team_rec_type
161 INDEX BY BINARY_INTEGER;
162
163 G_MISS_SALES_TEAM_TBL sales_team_tbl_type;
164
165 TYPE access_profile_rec_type IS RECORD
166 (
167 cust_access_profile_value varchar2(1),
168 lead_access_profile_value varchar2(1),
169 opp_access_profile_value varchar2(1) ,
170 mgr_update_profile_value varchar2(1) ,
171 admin_update_profile_value varchar2(1)
172 ) ;
173
174
175
176 -- Start of Comments
177 --
178 -- API name : Create_SalesTeam
179 -- Type : Private
180 -- Function : Insert sales team member records into the
181 -- sales team (access table)
182 --
183 -- Pre-reqs : Existing Customer and Account, or Opportunity
184 --
185 -- Paramaeters :
186 -- IN :
187 -- p_api_version_number IN NUMBER,
188 -- p_init_msg_list IN VARCHAR2
189 -- p_commit IN VARCHAR2
190 -- p_validation_level IN NUMBER
191 -- OUT :
192 -- x_return_status OUT NOCOPY VARCHAR2(1)
193 -- x_msg_count OUT NOCOPY NUMBER
194 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
195 -- x_access_id OUT NOCOPY NUMBER
196 --
197 -- Version : Current version 1.0
198 -- Initial Version
199 -- Initial version 1.0
200 --
201 -- Notes: API for creating either an account or opportunity
202 -- sales team
203 --
204 --
205 -- End of Comments
206
207 PROCEDURE Create_SalesTeam
208 ( p_api_version_number IN NUMBER,
209 p_init_msg_list IN VARCHAR2
210 DEFAULT FND_API.G_FALSE,
211 p_commit IN VARCHAR2
212 DEFAULT FND_API.G_FALSE,
213 p_validation_level IN NUMBER
214 DEFAULT FND_API.G_VALID_LEVEL_FULL,
215 p_access_profile_rec IN access_profile_rec_type,
216 p_check_access_flag IN VARCHAR2,
217 p_admin_flag IN VARCHAR2,
218 p_admin_group_id IN NUMBER,
219 p_identity_salesforce_id IN NUMBER,
220 p_sales_team_rec IN SALES_TEAM_REC_TYPE,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 x_access_id OUT NOCOPY NUMBER
225 );
226
227
228 -- Start of Comments
229 --
230 -- API name : Update_SalesTeam
231 -- Type : Public
232 -- Function : Update sales team member records into the
233 -- sales team (access table)
234 --
235 -- Pre-reqs : Existing sales team record
236 --
237 -- Paramaeters :
238 -- IN :
239 -- p_api_version_number IN NUMBER,
240 -- p_init_msg_list IN VARCHAR2
241 -- p_commit IN VARCHAR2
242 -- p_validation_level IN NUMBER
243 -- OUT :
244 -- x_return_status OUT NOCOPY VARCHAR2(1)
245 -- x_msg_count OUT NOCOPY NUMBER
246 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
247 -- x_access_id OUT NOCOPY NUMBER
248 --
249 -- Version : Current version 1.0
250 -- Initial Version
251 -- Initial version 1.0
252 --
253 -- Notes: API for updating either an account or opportunity
254 -- sales team
255 --
256 --
257 -- End of Comments
258
259 PROCEDURE Update_SalesTeam
260 ( p_api_version_number IN NUMBER,
261 p_init_msg_list IN VARCHAR2
262 DEFAULT FND_API.G_FALSE,
263 p_commit IN VARCHAR2
264 DEFAULT FND_API.G_FALSE,
265 p_validation_level IN NUMBER
266 DEFAULT FND_API.G_VALID_LEVEL_FULL,
267 p_access_profile_rec IN access_profile_rec_type,
268 p_check_access_flag IN VARCHAR2,
269 p_admin_flag IN VARCHAR2,
270 p_admin_group_id IN NUMBER,
271 p_identity_salesforce_id IN NUMBER,
272 p_sales_team_rec IN SALES_TEAM_REC_TYPE,
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_msg_count OUT NOCOPY NUMBER,
275 x_msg_data OUT NOCOPY VARCHAR2,
276 x_access_id OUT NOCOPY NUMBER
277 );
278
279 -- Start of Comments
280 --
281 -- API name : Delete_SalesTeam
282 -- Type : Public
283 -- Function : Delete sales team member records from the
284 -- sales team (access table)
285 --
286 -- Pre-reqs : Existing sales team record
287 --
288 -- Paramaeters :
289 -- IN :
290 -- p_api_version_number IN NUMBER,
291 -- p_init_msg_list IN VARCHAR2
292 -- p_commit IN VARCHAR2
293 -- p_validation_level IN NUMBER
294 -- OUT :
295 -- x_return_status OUT NOCOPY VARCHAR2(1)
296 -- x_msg_count OUT NOCOPY NUMBER
297 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
298 --
299 --
300 -- Version : Current version 2.0
301 -- Initial Version
302 -- Initial version 1.0
303 --
304 -- Notes: API for delete either an customer or opportunity
305 -- sales team
306 --
307 --
308 -- End of Comments
309
310 PROCEDURE Delete_SalesTeam
311 ( p_api_version_number IN NUMBER,
312 p_init_msg_list IN VARCHAR2
313 DEFAULT FND_API.G_FALSE,
314 p_commit IN VARCHAR2
315 DEFAULT FND_API.G_FALSE,
316 p_validation_level IN NUMBER
317 DEFAULT FND_API.G_VALID_LEVEL_FULL,
318 p_access_profile_rec IN access_profile_rec_type,
319 p_check_access_flag IN VARCHAR2,
320 p_admin_flag IN VARCHAR2,
321 p_admin_group_id IN NUMBER,
322 p_identity_salesforce_id IN NUMBER,
323 p_sales_team_rec IN SALES_TEAM_REC_TYPE,
324 x_return_status OUT NOCOPY VARCHAR2,
328
325 x_msg_count OUT NOCOPY NUMBER,
326 x_msg_data OUT NOCOPY VARCHAR2
327 );
329
330 Procedure validate_accessProfiles
331 ( p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
332 p_access_profile_rec IN ACCESS_PROFILE_REC_TYPE,
333 x_return_status OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER,
335 x_msg_data OUT NOCOPY VARCHAR2
336 );
337
338 /*
339 This API is used for checking if login user has view access for the pass in
340 customer id. If the user has view access for the customer, he/she can create
341 contacts, update contacts, create sales leads and create opportunities for this
342 customer. For has view access, this API will return x_view_access_flag = 'Y',
343 otherwise return 'N'. */
344
345 procedure has_viewCustomerAccess
346 ( p_api_version_number IN NUMBER
347 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
348 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
349 ,p_access_profile_rec IN access_profile_rec_type
350 ,p_admin_flag IN VARCHAR2
351 ,p_admin_group_id IN NUMBER
352 ,p_person_id IN NUMBER
353 ,p_customer_id IN NUMBER
354 ,p_check_access_flag IN VARCHAR2
355 ,p_identity_salesforce_id IN NUMBER
356 ,p_partner_cont_party_id IN NUMBER
357 ,x_return_status OUT NOCOPY VARCHAR2
358 ,x_msg_count OUT NOCOPY NUMBER
359 ,x_msg_data OUT NOCOPY VARCHAR2
360 ,x_view_access_flag OUT NOCOPY VARCHAR2
361 );
362
363 procedure has_updateCustomerAccess
364 ( p_api_version_number IN NUMBER
365 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
366 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
367 ,p_access_profile_rec IN access_profile_rec_type
368 ,p_admin_flag IN VARCHAR2
369 ,p_admin_group_id IN NUMBER
370 ,p_person_id IN NUMBER
371 ,p_customer_id IN NUMBER
372 ,p_check_access_flag IN VARCHAR2
373 ,p_identity_salesforce_id IN NUMBER
374 ,p_partner_cont_party_id IN NUMBER
375 ,x_return_status OUT NOCOPY VARCHAR2
376 ,x_msg_count OUT NOCOPY NUMBER
377 ,x_msg_data OUT NOCOPY VARCHAR2
378 ,x_update_access_flag OUT NOCOPY VARCHAR2
379 );
380
381 procedure has_updateLeadAccess
382 ( p_api_version_number IN NUMBER
383 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
384 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
385 ,p_access_profile_rec IN access_profile_rec_type
386 ,p_admin_flag IN VARCHAR2
387 ,p_admin_group_id IN NUMBER
388 ,p_person_id IN NUMBER
389 ,p_sales_lead_id IN NUMBER
390 ,p_check_access_flag IN VARCHAR2
391 ,p_identity_salesforce_id IN NUMBER
392 ,p_partner_cont_party_id IN NUMBER
393 ,x_return_status OUT NOCOPY VARCHAR2
394 ,x_msg_count OUT NOCOPY NUMBER
395 ,x_msg_data OUT NOCOPY VARCHAR2
396 ,x_update_access_flag OUT NOCOPY VARCHAR2
397 );
398
399 procedure has_updateOpportunityAccess
400 ( p_api_version_number IN NUMBER
401 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
402 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
403 ,p_access_profile_rec IN access_profile_rec_type
404 ,p_admin_flag IN VARCHAR2
405 ,p_admin_group_id IN NUMBER
406 ,p_person_id IN NUMBER
407 ,p_opportunity_id IN NUMBER
408 ,p_check_access_flag IN VARCHAR2
409 ,p_identity_salesforce_id IN NUMBER
410 ,p_partner_cont_party_id IN NUMBER
411 ,x_return_status OUT NOCOPY VARCHAR2
412 ,x_msg_count OUT NOCOPY NUMBER
413 ,x_msg_data OUT NOCOPY VARCHAR2
414 ,x_update_access_flag OUT NOCOPY VARCHAR2
415 );
416 /* p_security_id allowed are org party_id, opportunity_id and sales_lead_id
417 p_security_type allowed are 'ORGANIZATION', 'OPPORTUNITY' and 'LEAD'
418 p_person_party_id is person's party id. This id is required to check person's
419 update access. To check consumer access, you can pass in null for
420 p_security_id and p_security_type */
421 procedure has_updatePersonAccess
422 ( p_api_version_number IN NUMBER
423 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
424 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
425 ,p_access_profile_rec IN access_profile_rec_type
426 ,p_admin_flag IN VARCHAR2
427 ,p_admin_group_id IN NUMBER
428 ,p_person_id IN NUMBER
429 ,p_security_id IN NUMBER
430 ,p_security_type IN VARCHAR2
431 ,p_person_party_id IN NUMBER
432 ,p_check_access_flag IN VARCHAR2
433 ,p_identity_salesforce_id IN NUMBER
434 ,p_partner_cont_party_id IN NUMBER
435 ,x_return_status OUT NOCOPY VARCHAR2
436 ,x_msg_count OUT NOCOPY NUMBER
437 ,x_msg_data OUT NOCOPY VARCHAR2
438 ,x_update_access_flag OUT NOCOPY VARCHAR2
439 );
440
441 procedure has_viewPersonAccess
442 ( p_api_version_number IN NUMBER
443 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
444 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
445 ,p_access_profile_rec IN access_profile_rec_type
446 ,p_admin_flag IN VARCHAR2
447 ,p_admin_group_id IN NUMBER
448 ,p_person_id IN NUMBER
449 ,p_security_id IN NUMBER
450 ,p_security_type IN VARCHAR2
451 ,p_person_party_id IN NUMBER
452 ,p_check_access_flag IN VARCHAR2
453 ,p_identity_salesforce_id IN NUMBER
457 ,x_msg_data OUT NOCOPY VARCHAR2
454 ,p_partner_cont_party_id IN NUMBER
455 ,x_return_status OUT NOCOPY VARCHAR2
456 ,x_msg_count OUT NOCOPY NUMBER
458 ,x_view_access_flag OUT NOCOPY VARCHAR2
459 );
460 procedure has_viewLeadAccess
461 ( p_api_version_number IN NUMBER
462 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
463 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
464 ,p_access_profile_rec IN access_profile_rec_type
465 ,p_admin_flag IN VARCHAR2
466 ,p_admin_group_id IN NUMBER
467 ,p_person_id IN NUMBER
468 ,p_sales_lead_id IN NUMBER
469 ,p_check_access_flag IN VARCHAR2
470 ,p_identity_salesforce_id IN NUMBER
471 ,p_partner_cont_party_id IN NUMBER
472 ,x_return_status OUT NOCOPY VARCHAR2
473 ,x_msg_count OUT NOCOPY NUMBER
474 ,x_msg_data OUT NOCOPY VARCHAR2
475 ,x_view_access_flag OUT NOCOPY VARCHAR2
476 );
477
478 procedure has_viewOpportunityAccess
479 ( p_api_version_number IN NUMBER
480 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
481 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
482 ,p_access_profile_rec IN access_profile_rec_type
483 ,p_admin_flag IN VARCHAR2
484 ,p_admin_group_id IN NUMBER
485 ,p_person_id IN NUMBER
486 ,p_opportunity_id IN NUMBER
487 ,p_check_access_flag IN VARCHAR2
488 ,p_identity_salesforce_id IN NUMBER
489 ,p_partner_cont_party_id IN NUMBER
490 ,x_return_status OUT NOCOPY VARCHAR2
491 ,x_msg_count OUT NOCOPY NUMBER
492 ,x_msg_data OUT NOCOPY VARCHAR2
493 ,x_view_access_flag OUT NOCOPY VARCHAR2
494 );
495
496 /*
497 This API is used for checking if login user has access for the pass in
498 organization party id. x_access_privilege might return one of the following
499 three values: 'N'(no access), 'R'(read only access) and 'F'(read/update access)
500 */
501
502 procedure has_organizationAccess
503 ( p_api_version_number IN NUMBER
504 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
505 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
506 ,p_access_profile_rec IN access_profile_rec_type
507 ,p_admin_flag IN VARCHAR2
508 ,p_admin_group_id IN NUMBER
509 ,p_person_id IN NUMBER
510 ,p_customer_id IN NUMBER
511 ,p_check_access_flag IN VARCHAR2
512 ,p_identity_salesforce_id IN NUMBER
513 ,p_partner_cont_party_id IN NUMBER
514 ,x_return_status OUT NOCOPY VARCHAR2
515 ,x_msg_count OUT NOCOPY NUMBER
516 ,x_msg_data OUT NOCOPY VARCHAR2
517 ,x_access_privilege OUT NOCOPY VARCHAR2
518 );
519
520
521 /* p_security_id allowed are org party_id, opportunity_id and sales_lead_id
522 p_security_type allowed are 'ORGANIZATION', 'OPPORTUNITY' and 'LEAD'
523 p_person_party_id is person's party id. This id is required to check person's
524 access. To check consumer access, you can pass in null for
525 p_security_id and p_security_type
526 x_access_privilege might return one of the following
527 three values: 'N'(no access), 'R'(read only access) and 'F'(read/update access)
528 */
529 procedure has_personAccess
530 ( p_api_version_number IN NUMBER
531 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
532 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
533 ,p_access_profile_rec IN access_profile_rec_type
534 ,p_admin_flag IN VARCHAR2
535 ,p_admin_group_id IN NUMBER
536 ,p_person_id IN NUMBER
537 ,p_security_id IN NUMBER
538 ,p_security_type IN VARCHAR2
539 ,p_person_party_id IN NUMBER
540 ,p_check_access_flag IN VARCHAR2
541 ,p_identity_salesforce_id IN NUMBER
542 ,p_partner_cont_party_id IN NUMBER
543 ,x_return_status OUT NOCOPY VARCHAR2
544 ,x_msg_count OUT NOCOPY NUMBER
545 ,x_msg_data OUT NOCOPY VARCHAR2
546 ,x_access_privilege OUT NOCOPY VARCHAR2
547 );
548
549 /*
550 Wrapper on has_viewLeadAccess and has_updateLeadAccess.
551 x_access_privilege might return one of the following
552 three values: 'N'(no access), 'R'(read only access) and 'F'(read/update access)
553 */
554 procedure has_leadAccess
555 ( p_api_version_number IN NUMBER
556 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
557 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
558 ,p_access_profile_rec IN access_profile_rec_type
559 ,p_admin_flag IN VARCHAR2
560 ,p_admin_group_id IN NUMBER
561 ,p_person_id IN NUMBER
562 ,p_sales_lead_id IN NUMBER
563 ,p_check_access_flag IN VARCHAR2
564 ,p_identity_salesforce_id IN NUMBER
565 ,p_partner_cont_party_id IN NUMBER
566 ,x_return_status OUT NOCOPY VARCHAR2
567 ,x_msg_count OUT NOCOPY NUMBER
568 ,x_msg_data OUT NOCOPY VARCHAR2
569 ,x_access_privilege OUT NOCOPY VARCHAR2
570 );
571 /*
572 Wrapper on has_viewOpportunityAccess and has_updateLeadAccess.
573 x_access_privilege might return one of the following
574 three values: 'N'(no access), 'R'(read only access) and 'F'(read/update access)
575 */
576 procedure has_opportunityAccess
577 ( p_api_version_number IN NUMBER
578 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
579 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
580 ,p_access_profile_rec IN access_profile_rec_type
581 ,p_admin_flag IN VARCHAR2
582 ,p_admin_group_id IN NUMBER
586 ,p_identity_salesforce_id IN NUMBER
583 ,p_person_id IN NUMBER
584 ,p_opportunity_id IN NUMBER
585 ,p_check_access_flag IN VARCHAR2
587 ,p_partner_cont_party_id IN NUMBER
588 ,x_return_status OUT NOCOPY VARCHAR2
589 ,x_msg_count OUT NOCOPY NUMBER
590 ,x_msg_data OUT NOCOPY VARCHAR2
591 ,x_access_privilege OUT NOCOPY VARCHAR2
592 );
593
594 END AS_ACCESS_PUB;