[Home] [Help]
PACKAGE: APPS.AS_ACCESS_PUB_W
Source
1 package as_access_pub_w AUTHID CURRENT_USER as
2 /* $Header: asxwacss.pls 120.1 2005/07/29 05:37 appldev ship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy as_access_pub.sales_team_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_DATE_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_VARCHAR2_TABLE_300
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_VARCHAR2_TABLE_300
20 , a17 JTF_VARCHAR2_TABLE_100
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_VARCHAR2_TABLE_100
23 , a20 JTF_NUMBER_TABLE
24 , a21 JTF_NUMBER_TABLE
25 , a22 JTF_VARCHAR2_TABLE_100
26 , a23 JTF_VARCHAR2_TABLE_100
27 , a24 JTF_VARCHAR2_TABLE_100
28 , a25 JTF_VARCHAR2_TABLE_100
29 , a26 JTF_VARCHAR2_TABLE_100
30 , a27 JTF_VARCHAR2_TABLE_100
31 , a28 JTF_NUMBER_TABLE
32 , a29 JTF_NUMBER_TABLE
33 , a30 JTF_DATE_TABLE
34 , a31 JTF_VARCHAR2_TABLE_300
35 , a32 JTF_DATE_TABLE
36 , a33 JTF_NUMBER_TABLE
37 , a34 JTF_VARCHAR2_TABLE_100
38 , a35 JTF_VARCHAR2_TABLE_100
39 , a36 JTF_VARCHAR2_TABLE_200
40 , a37 JTF_VARCHAR2_TABLE_200
41 , a38 JTF_VARCHAR2_TABLE_200
42 , a39 JTF_VARCHAR2_TABLE_200
43 , a40 JTF_VARCHAR2_TABLE_200
44 , a41 JTF_VARCHAR2_TABLE_200
45 , a42 JTF_VARCHAR2_TABLE_200
46 , a43 JTF_VARCHAR2_TABLE_200
47 , a44 JTF_VARCHAR2_TABLE_200
48 , a45 JTF_VARCHAR2_TABLE_200
49 , a46 JTF_VARCHAR2_TABLE_200
50 , a47 JTF_VARCHAR2_TABLE_200
51 , a48 JTF_VARCHAR2_TABLE_200
52 , a49 JTF_VARCHAR2_TABLE_200
53 , a50 JTF_VARCHAR2_TABLE_200
54 , a51 JTF_VARCHAR2_TABLE_100
55 , a52 JTF_VARCHAR2_TABLE_100
56 , a53 JTF_VARCHAR2_TABLE_100
57 , a54 JTF_NUMBER_TABLE
58 , a55 JTF_NUMBER_TABLE
59 , a56 JTF_VARCHAR2_TABLE_100
60 , a57 JTF_VARCHAR2_TABLE_100
61 , a58 JTF_VARCHAR2_TABLE_100
62 , a59 JTF_VARCHAR2_TABLE_100
63 );
64 procedure rosetta_table_copy_out_p2(t as_access_pub.sales_team_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65 , a1 out nocopy JTF_DATE_TABLE
66 , a2 out nocopy JTF_NUMBER_TABLE
67 , a3 out nocopy JTF_DATE_TABLE
68 , a4 out nocopy JTF_NUMBER_TABLE
69 , a5 out nocopy JTF_NUMBER_TABLE
70 , a6 out nocopy JTF_VARCHAR2_TABLE_100
71 , a7 out nocopy JTF_VARCHAR2_TABLE_100
72 , a8 out nocopy JTF_VARCHAR2_TABLE_100
73 , a9 out nocopy JTF_NUMBER_TABLE
74 , a10 out nocopy JTF_NUMBER_TABLE
75 , a11 out nocopy JTF_NUMBER_TABLE
76 , a12 out nocopy JTF_NUMBER_TABLE
77 , a13 out nocopy JTF_VARCHAR2_TABLE_300
78 , a14 out nocopy JTF_VARCHAR2_TABLE_100
79 , a15 out nocopy JTF_VARCHAR2_TABLE_100
80 , a16 out nocopy JTF_VARCHAR2_TABLE_300
81 , a17 out nocopy JTF_VARCHAR2_TABLE_100
82 , a18 out nocopy JTF_NUMBER_TABLE
83 , a19 out nocopy JTF_VARCHAR2_TABLE_100
84 , a20 out nocopy JTF_NUMBER_TABLE
85 , a21 out nocopy JTF_NUMBER_TABLE
86 , a22 out nocopy JTF_VARCHAR2_TABLE_100
87 , a23 out nocopy JTF_VARCHAR2_TABLE_100
88 , a24 out nocopy JTF_VARCHAR2_TABLE_100
89 , a25 out nocopy JTF_VARCHAR2_TABLE_100
90 , a26 out nocopy JTF_VARCHAR2_TABLE_100
91 , a27 out nocopy JTF_VARCHAR2_TABLE_100
92 , a28 out nocopy JTF_NUMBER_TABLE
93 , a29 out nocopy JTF_NUMBER_TABLE
94 , a30 out nocopy JTF_DATE_TABLE
95 , a31 out nocopy JTF_VARCHAR2_TABLE_300
96 , a32 out nocopy JTF_DATE_TABLE
97 , a33 out nocopy JTF_NUMBER_TABLE
98 , a34 out nocopy JTF_VARCHAR2_TABLE_100
99 , a35 out nocopy JTF_VARCHAR2_TABLE_100
100 , a36 out nocopy JTF_VARCHAR2_TABLE_200
101 , a37 out nocopy JTF_VARCHAR2_TABLE_200
102 , a38 out nocopy JTF_VARCHAR2_TABLE_200
103 , a39 out nocopy JTF_VARCHAR2_TABLE_200
104 , a40 out nocopy JTF_VARCHAR2_TABLE_200
105 , a41 out nocopy JTF_VARCHAR2_TABLE_200
106 , a42 out nocopy JTF_VARCHAR2_TABLE_200
107 , a43 out nocopy JTF_VARCHAR2_TABLE_200
108 , a44 out nocopy JTF_VARCHAR2_TABLE_200
109 , a45 out nocopy JTF_VARCHAR2_TABLE_200
110 , a46 out nocopy JTF_VARCHAR2_TABLE_200
111 , a47 out nocopy JTF_VARCHAR2_TABLE_200
112 , a48 out nocopy JTF_VARCHAR2_TABLE_200
113 , a49 out nocopy JTF_VARCHAR2_TABLE_200
114 , a50 out nocopy JTF_VARCHAR2_TABLE_200
115 , a51 out nocopy JTF_VARCHAR2_TABLE_100
116 , a52 out nocopy JTF_VARCHAR2_TABLE_100
117 , a53 out nocopy JTF_VARCHAR2_TABLE_100
118 , a54 out nocopy JTF_NUMBER_TABLE
119 , a55 out nocopy JTF_NUMBER_TABLE
120 , a56 out nocopy JTF_VARCHAR2_TABLE_100
121 , a57 out nocopy JTF_VARCHAR2_TABLE_100
122 , a58 out nocopy JTF_VARCHAR2_TABLE_100
123 , a59 out nocopy JTF_VARCHAR2_TABLE_100
124 );
125
126 procedure create_salesteam(p_api_version_number NUMBER
127 , p_init_msg_list VARCHAR2
128 , p_commit VARCHAR2
129 , p_validation_level NUMBER
130 , p_check_access_flag VARCHAR2
131 , p_admin_flag VARCHAR2
132 , p_admin_group_id NUMBER
133 , p_identity_salesforce_id NUMBER
134 , x_return_status out nocopy VARCHAR2
135 , x_msg_count out nocopy NUMBER
136 , x_msg_data out nocopy VARCHAR2
137 , x_access_id out nocopy NUMBER
138 , p4_a0 VARCHAR2 := fnd_api.g_miss_char
139 , p4_a1 VARCHAR2 := fnd_api.g_miss_char
140 , p4_a2 VARCHAR2 := fnd_api.g_miss_char
141 , p4_a3 VARCHAR2 := fnd_api.g_miss_char
142 , p4_a4 VARCHAR2 := fnd_api.g_miss_char
143 , p9_a0 NUMBER := 0-1962.0724
144 , p9_a1 DATE := fnd_api.g_miss_date
145 , p9_a2 NUMBER := 0-1962.0724
146 , p9_a3 DATE := fnd_api.g_miss_date
147 , p9_a4 NUMBER := 0-1962.0724
148 , p9_a5 NUMBER := 0-1962.0724
149 , p9_a6 VARCHAR2 := fnd_api.g_miss_char
150 , p9_a7 VARCHAR2 := fnd_api.g_miss_char
151 , p9_a8 VARCHAR2 := fnd_api.g_miss_char
152 , p9_a9 NUMBER := 0-1962.0724
153 , p9_a10 NUMBER := 0-1962.0724
154 , p9_a11 NUMBER := 0-1962.0724
155 , p9_a12 NUMBER := 0-1962.0724
156 , p9_a13 VARCHAR2 := fnd_api.g_miss_char
157 , p9_a14 VARCHAR2 := fnd_api.g_miss_char
158 , p9_a15 VARCHAR2 := fnd_api.g_miss_char
159 , p9_a16 VARCHAR2 := fnd_api.g_miss_char
160 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
161 , p9_a18 NUMBER := 0-1962.0724
162 , p9_a19 VARCHAR2 := fnd_api.g_miss_char
163 , p9_a20 NUMBER := 0-1962.0724
164 , p9_a21 NUMBER := 0-1962.0724
165 , p9_a22 VARCHAR2 := fnd_api.g_miss_char
166 , p9_a23 VARCHAR2 := fnd_api.g_miss_char
167 , p9_a24 VARCHAR2 := fnd_api.g_miss_char
168 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
169 , p9_a26 VARCHAR2 := fnd_api.g_miss_char
170 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
171 , p9_a28 NUMBER := 0-1962.0724
172 , p9_a29 NUMBER := 0-1962.0724
173 , p9_a30 DATE := fnd_api.g_miss_date
174 , p9_a31 VARCHAR2 := fnd_api.g_miss_char
175 , p9_a32 DATE := fnd_api.g_miss_date
176 , p9_a33 NUMBER := 0-1962.0724
177 , p9_a34 VARCHAR2 := fnd_api.g_miss_char
178 , p9_a35 VARCHAR2 := fnd_api.g_miss_char
179 , p9_a36 VARCHAR2 := fnd_api.g_miss_char
180 , p9_a37 VARCHAR2 := fnd_api.g_miss_char
181 , p9_a38 VARCHAR2 := fnd_api.g_miss_char
182 , p9_a39 VARCHAR2 := fnd_api.g_miss_char
183 , p9_a40 VARCHAR2 := fnd_api.g_miss_char
184 , p9_a41 VARCHAR2 := fnd_api.g_miss_char
185 , p9_a42 VARCHAR2 := fnd_api.g_miss_char
186 , p9_a43 VARCHAR2 := fnd_api.g_miss_char
187 , p9_a44 VARCHAR2 := fnd_api.g_miss_char
188 , p9_a45 VARCHAR2 := fnd_api.g_miss_char
189 , p9_a46 VARCHAR2 := fnd_api.g_miss_char
190 , p9_a47 VARCHAR2 := fnd_api.g_miss_char
191 , p9_a48 VARCHAR2 := fnd_api.g_miss_char
192 , p9_a49 VARCHAR2 := fnd_api.g_miss_char
193 , p9_a50 VARCHAR2 := fnd_api.g_miss_char
194 , p9_a51 VARCHAR2 := fnd_api.g_miss_char
195 , p9_a52 VARCHAR2 := fnd_api.g_miss_char
196 , p9_a53 VARCHAR2 := fnd_api.g_miss_char
197 , p9_a54 NUMBER := 0-1962.0724
198 , p9_a55 NUMBER := 0-1962.0724
199 , p9_a56 VARCHAR2 := fnd_api.g_miss_char
200 , p9_a57 VARCHAR2 := fnd_api.g_miss_char
201 , p9_a58 VARCHAR2 := fnd_api.g_miss_char
202 , p9_a59 VARCHAR2 := fnd_api.g_miss_char
203 );
204 procedure update_salesteam(p_api_version_number NUMBER
205 , p_init_msg_list VARCHAR2
206 , p_commit VARCHAR2
207 , p_validation_level NUMBER
208 , p_check_access_flag VARCHAR2
209 , p_admin_flag VARCHAR2
210 , p_admin_group_id NUMBER
211 , p_identity_salesforce_id NUMBER
212 , x_return_status out nocopy VARCHAR2
213 , x_msg_count out nocopy NUMBER
214 , x_msg_data out nocopy VARCHAR2
215 , x_access_id out nocopy NUMBER
216 , p4_a0 VARCHAR2 := fnd_api.g_miss_char
217 , p4_a1 VARCHAR2 := fnd_api.g_miss_char
218 , p4_a2 VARCHAR2 := fnd_api.g_miss_char
219 , p4_a3 VARCHAR2 := fnd_api.g_miss_char
220 , p4_a4 VARCHAR2 := fnd_api.g_miss_char
221 , p9_a0 NUMBER := 0-1962.0724
222 , p9_a1 DATE := fnd_api.g_miss_date
223 , p9_a2 NUMBER := 0-1962.0724
224 , p9_a3 DATE := fnd_api.g_miss_date
225 , p9_a4 NUMBER := 0-1962.0724
226 , p9_a5 NUMBER := 0-1962.0724
227 , p9_a6 VARCHAR2 := fnd_api.g_miss_char
228 , p9_a7 VARCHAR2 := fnd_api.g_miss_char
229 , p9_a8 VARCHAR2 := fnd_api.g_miss_char
230 , p9_a9 NUMBER := 0-1962.0724
231 , p9_a10 NUMBER := 0-1962.0724
232 , p9_a11 NUMBER := 0-1962.0724
233 , p9_a12 NUMBER := 0-1962.0724
234 , p9_a13 VARCHAR2 := fnd_api.g_miss_char
235 , p9_a14 VARCHAR2 := fnd_api.g_miss_char
236 , p9_a15 VARCHAR2 := fnd_api.g_miss_char
237 , p9_a16 VARCHAR2 := fnd_api.g_miss_char
238 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
239 , p9_a18 NUMBER := 0-1962.0724
240 , p9_a19 VARCHAR2 := fnd_api.g_miss_char
241 , p9_a20 NUMBER := 0-1962.0724
242 , p9_a21 NUMBER := 0-1962.0724
243 , p9_a22 VARCHAR2 := fnd_api.g_miss_char
244 , p9_a23 VARCHAR2 := fnd_api.g_miss_char
245 , p9_a24 VARCHAR2 := fnd_api.g_miss_char
246 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
247 , p9_a26 VARCHAR2 := fnd_api.g_miss_char
248 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
249 , p9_a28 NUMBER := 0-1962.0724
250 , p9_a29 NUMBER := 0-1962.0724
251 , p9_a30 DATE := fnd_api.g_miss_date
252 , p9_a31 VARCHAR2 := fnd_api.g_miss_char
253 , p9_a32 DATE := fnd_api.g_miss_date
254 , p9_a33 NUMBER := 0-1962.0724
255 , p9_a34 VARCHAR2 := fnd_api.g_miss_char
256 , p9_a35 VARCHAR2 := fnd_api.g_miss_char
257 , p9_a36 VARCHAR2 := fnd_api.g_miss_char
258 , p9_a37 VARCHAR2 := fnd_api.g_miss_char
259 , p9_a38 VARCHAR2 := fnd_api.g_miss_char
260 , p9_a39 VARCHAR2 := fnd_api.g_miss_char
261 , p9_a40 VARCHAR2 := fnd_api.g_miss_char
262 , p9_a41 VARCHAR2 := fnd_api.g_miss_char
263 , p9_a42 VARCHAR2 := fnd_api.g_miss_char
264 , p9_a43 VARCHAR2 := fnd_api.g_miss_char
265 , p9_a44 VARCHAR2 := fnd_api.g_miss_char
266 , p9_a45 VARCHAR2 := fnd_api.g_miss_char
267 , p9_a46 VARCHAR2 := fnd_api.g_miss_char
268 , p9_a47 VARCHAR2 := fnd_api.g_miss_char
269 , p9_a48 VARCHAR2 := fnd_api.g_miss_char
270 , p9_a49 VARCHAR2 := fnd_api.g_miss_char
271 , p9_a50 VARCHAR2 := fnd_api.g_miss_char
272 , p9_a51 VARCHAR2 := fnd_api.g_miss_char
273 , p9_a52 VARCHAR2 := fnd_api.g_miss_char
274 , p9_a53 VARCHAR2 := fnd_api.g_miss_char
275 , p9_a54 NUMBER := 0-1962.0724
276 , p9_a55 NUMBER := 0-1962.0724
277 , p9_a56 VARCHAR2 := fnd_api.g_miss_char
278 , p9_a57 VARCHAR2 := fnd_api.g_miss_char
279 , p9_a58 VARCHAR2 := fnd_api.g_miss_char
280 , p9_a59 VARCHAR2 := fnd_api.g_miss_char
281 );
282 procedure delete_salesteam(p_api_version_number NUMBER
283 , p_init_msg_list VARCHAR2
284 , p_commit VARCHAR2
285 , p_validation_level NUMBER
286 , p_check_access_flag VARCHAR2
287 , p_admin_flag VARCHAR2
288 , p_admin_group_id NUMBER
289 , p_identity_salesforce_id NUMBER
290 , x_return_status out nocopy VARCHAR2
291 , x_msg_count out nocopy NUMBER
292 , x_msg_data out nocopy VARCHAR2
293 , p4_a0 VARCHAR2 := fnd_api.g_miss_char
294 , p4_a1 VARCHAR2 := fnd_api.g_miss_char
295 , p4_a2 VARCHAR2 := fnd_api.g_miss_char
296 , p4_a3 VARCHAR2 := fnd_api.g_miss_char
297 , p4_a4 VARCHAR2 := fnd_api.g_miss_char
298 , p9_a0 NUMBER := 0-1962.0724
299 , p9_a1 DATE := fnd_api.g_miss_date
300 , p9_a2 NUMBER := 0-1962.0724
301 , p9_a3 DATE := fnd_api.g_miss_date
302 , p9_a4 NUMBER := 0-1962.0724
303 , p9_a5 NUMBER := 0-1962.0724
304 , p9_a6 VARCHAR2 := fnd_api.g_miss_char
305 , p9_a7 VARCHAR2 := fnd_api.g_miss_char
306 , p9_a8 VARCHAR2 := fnd_api.g_miss_char
307 , p9_a9 NUMBER := 0-1962.0724
308 , p9_a10 NUMBER := 0-1962.0724
309 , p9_a11 NUMBER := 0-1962.0724
310 , p9_a12 NUMBER := 0-1962.0724
311 , p9_a13 VARCHAR2 := fnd_api.g_miss_char
312 , p9_a14 VARCHAR2 := fnd_api.g_miss_char
313 , p9_a15 VARCHAR2 := fnd_api.g_miss_char
314 , p9_a16 VARCHAR2 := fnd_api.g_miss_char
315 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
316 , p9_a18 NUMBER := 0-1962.0724
317 , p9_a19 VARCHAR2 := fnd_api.g_miss_char
318 , p9_a20 NUMBER := 0-1962.0724
319 , p9_a21 NUMBER := 0-1962.0724
320 , p9_a22 VARCHAR2 := fnd_api.g_miss_char
321 , p9_a23 VARCHAR2 := fnd_api.g_miss_char
322 , p9_a24 VARCHAR2 := fnd_api.g_miss_char
323 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
324 , p9_a26 VARCHAR2 := fnd_api.g_miss_char
325 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
326 , p9_a28 NUMBER := 0-1962.0724
327 , p9_a29 NUMBER := 0-1962.0724
328 , p9_a30 DATE := fnd_api.g_miss_date
329 , p9_a31 VARCHAR2 := fnd_api.g_miss_char
330 , p9_a32 DATE := fnd_api.g_miss_date
331 , p9_a33 NUMBER := 0-1962.0724
332 , p9_a34 VARCHAR2 := fnd_api.g_miss_char
333 , p9_a35 VARCHAR2 := fnd_api.g_miss_char
334 , p9_a36 VARCHAR2 := fnd_api.g_miss_char
335 , p9_a37 VARCHAR2 := fnd_api.g_miss_char
336 , p9_a38 VARCHAR2 := fnd_api.g_miss_char
340 , p9_a42 VARCHAR2 := fnd_api.g_miss_char
337 , p9_a39 VARCHAR2 := fnd_api.g_miss_char
338 , p9_a40 VARCHAR2 := fnd_api.g_miss_char
339 , p9_a41 VARCHAR2 := fnd_api.g_miss_char
341 , p9_a43 VARCHAR2 := fnd_api.g_miss_char
342 , p9_a44 VARCHAR2 := fnd_api.g_miss_char
343 , p9_a45 VARCHAR2 := fnd_api.g_miss_char
344 , p9_a46 VARCHAR2 := fnd_api.g_miss_char
345 , p9_a47 VARCHAR2 := fnd_api.g_miss_char
346 , p9_a48 VARCHAR2 := fnd_api.g_miss_char
347 , p9_a49 VARCHAR2 := fnd_api.g_miss_char
348 , p9_a50 VARCHAR2 := fnd_api.g_miss_char
349 , p9_a51 VARCHAR2 := fnd_api.g_miss_char
350 , p9_a52 VARCHAR2 := fnd_api.g_miss_char
351 , p9_a53 VARCHAR2 := fnd_api.g_miss_char
352 , p9_a54 NUMBER := 0-1962.0724
353 , p9_a55 NUMBER := 0-1962.0724
354 , p9_a56 VARCHAR2 := fnd_api.g_miss_char
355 , p9_a57 VARCHAR2 := fnd_api.g_miss_char
356 , p9_a58 VARCHAR2 := fnd_api.g_miss_char
357 , p9_a59 VARCHAR2 := fnd_api.g_miss_char
358 );
359 procedure validate_accessprofiles(p_init_msg_list VARCHAR2
360 , x_return_status out nocopy VARCHAR2
361 , x_msg_count out nocopy NUMBER
362 , x_msg_data out nocopy VARCHAR2
363 , p1_a0 VARCHAR2 := fnd_api.g_miss_char
364 , p1_a1 VARCHAR2 := fnd_api.g_miss_char
365 , p1_a2 VARCHAR2 := fnd_api.g_miss_char
366 , p1_a3 VARCHAR2 := fnd_api.g_miss_char
367 , p1_a4 VARCHAR2 := fnd_api.g_miss_char
368 );
369 procedure has_viewcustomeraccess(p_api_version_number NUMBER
370 , p_init_msg_list VARCHAR2
371 , p_validation_level NUMBER
372 , p_admin_flag VARCHAR2
373 , p_admin_group_id NUMBER
374 , p_person_id NUMBER
375 , p_customer_id NUMBER
376 , p_check_access_flag VARCHAR2
377 , p_identity_salesforce_id NUMBER
378 , p_partner_cont_party_id NUMBER
379 , x_return_status out nocopy VARCHAR2
380 , x_msg_count out nocopy NUMBER
381 , x_msg_data out nocopy VARCHAR2
382 , x_view_access_flag out nocopy VARCHAR2
383 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
384 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
385 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
386 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
387 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
388 );
389 procedure has_updatecustomeraccess(p_api_version_number NUMBER
390 , p_init_msg_list VARCHAR2
391 , p_validation_level NUMBER
392 , p_admin_flag VARCHAR2
393 , p_admin_group_id NUMBER
394 , p_person_id NUMBER
395 , p_customer_id NUMBER
396 , p_check_access_flag VARCHAR2
397 , p_identity_salesforce_id NUMBER
398 , p_partner_cont_party_id NUMBER
399 , x_return_status out nocopy VARCHAR2
400 , x_msg_count out nocopy NUMBER
401 , x_msg_data out nocopy VARCHAR2
402 , x_update_access_flag out nocopy VARCHAR2
403 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
404 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
405 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
406 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
407 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
408 );
409 procedure has_updateleadaccess(p_api_version_number NUMBER
410 , p_init_msg_list VARCHAR2
411 , p_validation_level NUMBER
412 , p_admin_flag VARCHAR2
413 , p_admin_group_id NUMBER
414 , p_person_id NUMBER
415 , p_sales_lead_id NUMBER
416 , p_check_access_flag VARCHAR2
417 , p_identity_salesforce_id NUMBER
418 , p_partner_cont_party_id NUMBER
419 , x_return_status out nocopy VARCHAR2
420 , x_msg_count out nocopy NUMBER
421 , x_msg_data out nocopy VARCHAR2
422 , x_update_access_flag out nocopy VARCHAR2
423 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
424 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
425 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
426 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
427 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
428 );
429 procedure has_updateopportunityaccess(p_api_version_number NUMBER
430 , p_init_msg_list VARCHAR2
431 , p_validation_level NUMBER
432 , p_admin_flag VARCHAR2
433 , p_admin_group_id NUMBER
434 , p_person_id NUMBER
435 , p_opportunity_id NUMBER
436 , p_check_access_flag VARCHAR2
437 , p_identity_salesforce_id NUMBER
438 , p_partner_cont_party_id NUMBER
439 , x_return_status out nocopy VARCHAR2
440 , x_msg_count out nocopy NUMBER
441 , x_msg_data out nocopy VARCHAR2
442 , x_update_access_flag out nocopy VARCHAR2
443 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
444 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
445 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
446 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
447 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
448 );
449 procedure has_updatepersonaccess(p_api_version_number NUMBER
450 , p_init_msg_list VARCHAR2
451 , p_validation_level NUMBER
452 , p_admin_flag VARCHAR2
453 , p_admin_group_id NUMBER
454 , p_person_id NUMBER
455 , p_security_id NUMBER
456 , p_security_type VARCHAR2
457 , p_person_party_id NUMBER
458 , p_check_access_flag VARCHAR2
459 , p_identity_salesforce_id NUMBER
460 , p_partner_cont_party_id NUMBER
461 , x_return_status out nocopy VARCHAR2
462 , x_msg_count out nocopy NUMBER
466 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
463 , x_msg_data out nocopy VARCHAR2
464 , x_update_access_flag out nocopy VARCHAR2
465 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
467 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
468 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
469 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
470 );
471 procedure has_viewpersonaccess(p_api_version_number NUMBER
472 , p_init_msg_list VARCHAR2
473 , p_validation_level NUMBER
474 , p_admin_flag VARCHAR2
475 , p_admin_group_id NUMBER
476 , p_person_id NUMBER
477 , p_security_id NUMBER
478 , p_security_type VARCHAR2
479 , p_person_party_id NUMBER
480 , p_check_access_flag VARCHAR2
481 , p_identity_salesforce_id NUMBER
482 , p_partner_cont_party_id NUMBER
483 , x_return_status out nocopy VARCHAR2
484 , x_msg_count out nocopy NUMBER
485 , x_msg_data out nocopy VARCHAR2
486 , x_view_access_flag out nocopy VARCHAR2
487 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
488 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
489 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
490 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
491 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
492 );
493 procedure has_viewleadaccess(p_api_version_number NUMBER
494 , p_init_msg_list VARCHAR2
495 , p_validation_level NUMBER
496 , p_admin_flag VARCHAR2
497 , p_admin_group_id NUMBER
498 , p_person_id NUMBER
499 , p_sales_lead_id NUMBER
500 , p_check_access_flag VARCHAR2
501 , p_identity_salesforce_id NUMBER
502 , p_partner_cont_party_id NUMBER
503 , x_return_status out nocopy VARCHAR2
504 , x_msg_count out nocopy NUMBER
505 , x_msg_data out nocopy VARCHAR2
506 , x_view_access_flag out nocopy VARCHAR2
507 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
508 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
509 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
510 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
511 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
512 );
513 procedure has_viewopportunityaccess(p_api_version_number NUMBER
514 , p_init_msg_list VARCHAR2
515 , p_validation_level NUMBER
516 , p_admin_flag VARCHAR2
517 , p_admin_group_id NUMBER
518 , p_person_id NUMBER
519 , p_opportunity_id NUMBER
520 , p_check_access_flag VARCHAR2
521 , p_identity_salesforce_id NUMBER
522 , p_partner_cont_party_id NUMBER
523 , x_return_status out nocopy VARCHAR2
524 , x_msg_count out nocopy NUMBER
525 , x_msg_data out nocopy VARCHAR2
526 , x_view_access_flag out nocopy VARCHAR2
527 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
528 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
529 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
530 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
531 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
532 );
533 procedure has_organizationaccess(p_api_version_number NUMBER
534 , p_init_msg_list VARCHAR2
535 , p_validation_level NUMBER
536 , p_admin_flag VARCHAR2
537 , p_admin_group_id NUMBER
538 , p_person_id NUMBER
539 , p_customer_id NUMBER
540 , p_check_access_flag VARCHAR2
541 , p_identity_salesforce_id NUMBER
542 , p_partner_cont_party_id 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 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
548 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
549 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
550 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
551 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
552 );
553 procedure has_personaccess(p_api_version_number NUMBER
554 , p_init_msg_list VARCHAR2
555 , p_validation_level NUMBER
556 , p_admin_flag VARCHAR2
557 , p_admin_group_id NUMBER
558 , p_person_id NUMBER
559 , p_security_id NUMBER
560 , p_security_type VARCHAR2
561 , p_person_party_id NUMBER
562 , p_check_access_flag VARCHAR2
563 , p_identity_salesforce_id NUMBER
564 , p_partner_cont_party_id NUMBER
565 , x_return_status out nocopy VARCHAR2
566 , x_msg_count out nocopy NUMBER
567 , x_msg_data out nocopy VARCHAR2
568 , x_access_privilege out nocopy VARCHAR2
569 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
570 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
571 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
572 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
573 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
574 );
575 procedure has_leadaccess(p_api_version_number NUMBER
576 , p_init_msg_list VARCHAR2
577 , p_validation_level NUMBER
578 , p_admin_flag VARCHAR2
579 , p_admin_group_id NUMBER
580 , p_person_id NUMBER
581 , p_sales_lead_id NUMBER
582 , p_check_access_flag VARCHAR2
583 , p_identity_salesforce_id NUMBER
584 , p_partner_cont_party_id NUMBER
585 , x_return_status out nocopy VARCHAR2
586 , x_msg_count out nocopy NUMBER
587 , x_msg_data out nocopy VARCHAR2
588 , x_access_privilege out nocopy VARCHAR2
589 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
590 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
594 );
591 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
592 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
593 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
595 procedure has_opportunityaccess(p_api_version_number NUMBER
596 , p_init_msg_list VARCHAR2
597 , p_validation_level NUMBER
598 , p_admin_flag VARCHAR2
599 , p_admin_group_id NUMBER
600 , p_person_id NUMBER
601 , p_opportunity_id NUMBER
602 , p_check_access_flag VARCHAR2
606 , x_msg_count out nocopy NUMBER
603 , p_identity_salesforce_id NUMBER
604 , p_partner_cont_party_id NUMBER
605 , x_return_status out nocopy VARCHAR2
607 , x_msg_data out nocopy VARCHAR2
608 , x_access_privilege out nocopy VARCHAR2
609 , p3_a0 VARCHAR2 := fnd_api.g_miss_char
610 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
611 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
612 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
613 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
614 );
615 end as_access_pub_w;