eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AS_OPPORTUNITY_PUB_W4

Source


1 package as_opportunity_pub_w4 AUTHID CURRENT_USER as
2   /* $Header: asxwop4s.pls 120.2 2005/08/04 03:06 appldev ship $ */
3   procedure create_contacts(p_api_version_number  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p_commit  VARCHAR2
6     , p_validation_level  NUMBER
7     , p_identity_salesforce_id  NUMBER
8     , p5_a0 JTF_DATE_TABLE
9     , p5_a1 JTF_NUMBER_TABLE
10     , p5_a2 JTF_DATE_TABLE
11     , p5_a3 JTF_NUMBER_TABLE
12     , p5_a4 JTF_NUMBER_TABLE
13     , p5_a5 JTF_NUMBER_TABLE
14     , p5_a6 JTF_NUMBER_TABLE
15     , p5_a7 JTF_NUMBER_TABLE
16     , p5_a8 JTF_DATE_TABLE
17     , p5_a9 JTF_NUMBER_TABLE
18     , p5_a10 JTF_NUMBER_TABLE
19     , p5_a11 JTF_NUMBER_TABLE
20     , p5_a12 JTF_NUMBER_TABLE
21     , p5_a13 JTF_NUMBER_TABLE
22     , p5_a14 JTF_VARCHAR2_TABLE_100
23     , p5_a15 JTF_VARCHAR2_TABLE_100
24     , p5_a16 JTF_VARCHAR2_TABLE_100
25     , p5_a17 JTF_VARCHAR2_TABLE_300
26     , p5_a18 JTF_NUMBER_TABLE
27     , p5_a19 JTF_VARCHAR2_TABLE_100
28     , p5_a20 JTF_VARCHAR2_TABLE_100
29     , p5_a21 JTF_VARCHAR2_TABLE_100
30     , p5_a22 JTF_VARCHAR2_TABLE_100
31     , p5_a23 JTF_VARCHAR2_TABLE_100
32     , p5_a24 JTF_NUMBER_TABLE
33     , p5_a25 JTF_VARCHAR2_TABLE_100
34     , p5_a26 JTF_VARCHAR2_TABLE_100
35     , p5_a27 JTF_NUMBER_TABLE
36     , p5_a28 JTF_VARCHAR2_TABLE_100
37     , p5_a29 JTF_VARCHAR2_TABLE_200
38     , p5_a30 JTF_VARCHAR2_TABLE_200
39     , p5_a31 JTF_VARCHAR2_TABLE_200
40     , p5_a32 JTF_VARCHAR2_TABLE_200
41     , p5_a33 JTF_VARCHAR2_TABLE_200
42     , p5_a34 JTF_VARCHAR2_TABLE_200
43     , p5_a35 JTF_VARCHAR2_TABLE_200
44     , p5_a36 JTF_VARCHAR2_TABLE_200
45     , p5_a37 JTF_VARCHAR2_TABLE_200
46     , p5_a38 JTF_VARCHAR2_TABLE_200
47     , p5_a39 JTF_VARCHAR2_TABLE_200
48     , p5_a40 JTF_VARCHAR2_TABLE_200
49     , p5_a41 JTF_VARCHAR2_TABLE_200
50     , p5_a42 JTF_VARCHAR2_TABLE_200
51     , p5_a43 JTF_VARCHAR2_TABLE_200
52     , p_check_access_flag  VARCHAR2
53     , p_admin_flag  VARCHAR2
54     , p_admin_group_id  NUMBER
55     , p_partner_cont_party_id  NUMBER
56     , p11_a0 JTF_VARCHAR2_TABLE_100
57     , p11_a1 JTF_VARCHAR2_TABLE_300
58     , p12_a0 out nocopy JTF_NUMBER_TABLE
59     , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
60     , x_return_status out nocopy  VARCHAR2
61     , x_msg_count out nocopy  NUMBER
62     , x_msg_data out nocopy  VARCHAR2
63     , p6_a0  DATE := fnd_api.g_miss_date
64     , p6_a1  NUMBER := 0-1962.0724
65     , p6_a2  DATE := fnd_api.g_miss_date
66     , p6_a3  NUMBER := 0-1962.0724
67     , p6_a4  NUMBER := 0-1962.0724
68     , p6_a5  NUMBER := 0-1962.0724
69     , p6_a6  NUMBER := 0-1962.0724
70     , p6_a7  NUMBER := 0-1962.0724
71     , p6_a8  DATE := fnd_api.g_miss_date
72     , p6_a9  NUMBER := 0-1962.0724
73     , p6_a10  VARCHAR2 := fnd_api.g_miss_char
74     , p6_a11  VARCHAR2 := fnd_api.g_miss_char
75     , p6_a12  VARCHAR2 := fnd_api.g_miss_char
76     , p6_a13  VARCHAR2 := fnd_api.g_miss_char
77     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
78     , p6_a15  NUMBER := 0-1962.0724
79     , p6_a16  VARCHAR2 := fnd_api.g_miss_char
80     , p6_a17  NUMBER := 0-1962.0724
81     , p6_a18  VARCHAR2 := fnd_api.g_miss_char
82     , p6_a19  VARCHAR2 := fnd_api.g_miss_char
83     , p6_a20  NUMBER := 0-1962.0724
84     , p6_a21  VARCHAR2 := fnd_api.g_miss_char
85     , p6_a22  VARCHAR2 := fnd_api.g_miss_char
86     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
87     , p6_a24  VARCHAR2 := fnd_api.g_miss_char
88     , p6_a25  VARCHAR2 := fnd_api.g_miss_char
89     , p6_a26  VARCHAR2 := fnd_api.g_miss_char
90     , p6_a27  VARCHAR2 := fnd_api.g_miss_char
91     , p6_a28  VARCHAR2 := fnd_api.g_miss_char
92     , p6_a29  NUMBER := 0-1962.0724
93     , p6_a30  VARCHAR2 := fnd_api.g_miss_char
94     , p6_a31  NUMBER := 0-1962.0724
95     , p6_a32  VARCHAR2 := fnd_api.g_miss_char
96     , p6_a33  VARCHAR2 := fnd_api.g_miss_char
97     , p6_a34  NUMBER := 0-1962.0724
98     , p6_a35  NUMBER := 0-1962.0724
99     , p6_a36  VARCHAR2 := fnd_api.g_miss_char
100     , p6_a37  VARCHAR2 := fnd_api.g_miss_char
101     , p6_a38  DATE := fnd_api.g_miss_date
102     , p6_a39  VARCHAR2 := fnd_api.g_miss_char
103     , p6_a40  VARCHAR2 := fnd_api.g_miss_char
104     , p6_a41  VARCHAR2 := fnd_api.g_miss_char
105     , p6_a42  VARCHAR2 := fnd_api.g_miss_char
106     , p6_a43  VARCHAR2 := fnd_api.g_miss_char
107     , p6_a44  NUMBER := 0-1962.0724
108     , p6_a45  VARCHAR2 := fnd_api.g_miss_char
109     , p6_a46  VARCHAR2 := fnd_api.g_miss_char
110     , p6_a47  NUMBER := 0-1962.0724
111     , p6_a48  VARCHAR2 := fnd_api.g_miss_char
112     , p6_a49  NUMBER := 0-1962.0724
113     , p6_a50  NUMBER := 0-1962.0724
114     , p6_a51  NUMBER := 0-1962.0724
115     , p6_a52  VARCHAR2 := fnd_api.g_miss_char
116     , p6_a53  VARCHAR2 := fnd_api.g_miss_char
117     , p6_a54  VARCHAR2 := fnd_api.g_miss_char
118     , p6_a55  NUMBER := 0-1962.0724
119     , p6_a56  NUMBER := 0-1962.0724
120     , p6_a57  VARCHAR2 := fnd_api.g_miss_char
121     , p6_a58  VARCHAR2 := fnd_api.g_miss_char
122     , p6_a59  VARCHAR2 := fnd_api.g_miss_char
123     , p6_a60  VARCHAR2 := fnd_api.g_miss_char
124     , p6_a61  VARCHAR2 := fnd_api.g_miss_char
125     , p6_a62  VARCHAR2 := fnd_api.g_miss_char
126     , p6_a63  NUMBER := 0-1962.0724
127     , p6_a64  VARCHAR2 := fnd_api.g_miss_char
128     , p6_a65  NUMBER := 0-1962.0724
129     , p6_a66  NUMBER := 0-1962.0724
130     , p6_a67  VARCHAR2 := fnd_api.g_miss_char
131     , p6_a68  NUMBER := 0-1962.0724
132     , p6_a69  NUMBER := 0-1962.0724
133     , p6_a70  NUMBER := 0-1962.0724
134     , p6_a71  VARCHAR2 := fnd_api.g_miss_char
135     , p6_a72  VARCHAR2 := fnd_api.g_miss_char
136     , p6_a73  DATE := fnd_api.g_miss_date
137     , p6_a74  VARCHAR2 := fnd_api.g_miss_char
138     , p6_a75  VARCHAR2 := fnd_api.g_miss_char
139     , p6_a76  VARCHAR2 := fnd_api.g_miss_char
140     , p6_a77  VARCHAR2 := fnd_api.g_miss_char
141     , p6_a78  VARCHAR2 := fnd_api.g_miss_char
142     , p6_a79  VARCHAR2 := fnd_api.g_miss_char
143     , p6_a80  NUMBER := 0-1962.0724
144     , p6_a81  VARCHAR2 := fnd_api.g_miss_char
145     , p6_a82  VARCHAR2 := fnd_api.g_miss_char
146     , p6_a83  VARCHAR2 := fnd_api.g_miss_char
147     , p6_a84  VARCHAR2 := fnd_api.g_miss_char
148     , p6_a85  VARCHAR2 := fnd_api.g_miss_char
149     , p6_a86  VARCHAR2 := fnd_api.g_miss_char
150     , p6_a87  VARCHAR2 := fnd_api.g_miss_char
151     , p6_a88  VARCHAR2 := fnd_api.g_miss_char
152     , p6_a89  VARCHAR2 := fnd_api.g_miss_char
153     , p6_a90  VARCHAR2 := fnd_api.g_miss_char
154     , p6_a91  VARCHAR2 := fnd_api.g_miss_char
155     , p6_a92  VARCHAR2 := fnd_api.g_miss_char
156     , p6_a93  VARCHAR2 := fnd_api.g_miss_char
157     , p6_a94  VARCHAR2 := fnd_api.g_miss_char
158     , p6_a95  VARCHAR2 := fnd_api.g_miss_char
159     , p6_a96  VARCHAR2 := fnd_api.g_miss_char
160     , p6_a97  VARCHAR2 := fnd_api.g_miss_char
161     , p6_a98  VARCHAR2 := fnd_api.g_miss_char
162     , p6_a99  NUMBER := 0-1962.0724
163   );
164   procedure update_contacts(p_api_version_number  NUMBER
165     , p_init_msg_list  VARCHAR2
166     , p_commit  VARCHAR2
167     , p_validation_level  NUMBER
168     , p_identity_salesforce_id  NUMBER
169     , p5_a0 JTF_DATE_TABLE
170     , p5_a1 JTF_NUMBER_TABLE
171     , p5_a2 JTF_DATE_TABLE
172     , p5_a3 JTF_NUMBER_TABLE
173     , p5_a4 JTF_NUMBER_TABLE
174     , p5_a5 JTF_NUMBER_TABLE
175     , p5_a6 JTF_NUMBER_TABLE
176     , p5_a7 JTF_NUMBER_TABLE
177     , p5_a8 JTF_DATE_TABLE
178     , p5_a9 JTF_NUMBER_TABLE
179     , p5_a10 JTF_NUMBER_TABLE
180     , p5_a11 JTF_NUMBER_TABLE
181     , p5_a12 JTF_NUMBER_TABLE
182     , p5_a13 JTF_NUMBER_TABLE
183     , p5_a14 JTF_VARCHAR2_TABLE_100
184     , p5_a15 JTF_VARCHAR2_TABLE_100
185     , p5_a16 JTF_VARCHAR2_TABLE_100
186     , p5_a17 JTF_VARCHAR2_TABLE_300
187     , p5_a18 JTF_NUMBER_TABLE
188     , p5_a19 JTF_VARCHAR2_TABLE_100
189     , p5_a20 JTF_VARCHAR2_TABLE_100
190     , p5_a21 JTF_VARCHAR2_TABLE_100
191     , p5_a22 JTF_VARCHAR2_TABLE_100
192     , p5_a23 JTF_VARCHAR2_TABLE_100
193     , p5_a24 JTF_NUMBER_TABLE
194     , p5_a25 JTF_VARCHAR2_TABLE_100
195     , p5_a26 JTF_VARCHAR2_TABLE_100
196     , p5_a27 JTF_NUMBER_TABLE
197     , p5_a28 JTF_VARCHAR2_TABLE_100
198     , p5_a29 JTF_VARCHAR2_TABLE_200
199     , p5_a30 JTF_VARCHAR2_TABLE_200
200     , p5_a31 JTF_VARCHAR2_TABLE_200
201     , p5_a32 JTF_VARCHAR2_TABLE_200
202     , p5_a33 JTF_VARCHAR2_TABLE_200
203     , p5_a34 JTF_VARCHAR2_TABLE_200
204     , p5_a35 JTF_VARCHAR2_TABLE_200
205     , p5_a36 JTF_VARCHAR2_TABLE_200
206     , p5_a37 JTF_VARCHAR2_TABLE_200
207     , p5_a38 JTF_VARCHAR2_TABLE_200
208     , p5_a39 JTF_VARCHAR2_TABLE_200
209     , p5_a40 JTF_VARCHAR2_TABLE_200
210     , p5_a41 JTF_VARCHAR2_TABLE_200
211     , p5_a42 JTF_VARCHAR2_TABLE_200
212     , p5_a43 JTF_VARCHAR2_TABLE_200
213     , p_check_access_flag  VARCHAR2
214     , p_admin_flag  VARCHAR2
215     , p_admin_group_id  NUMBER
216     , p_partner_cont_party_id  NUMBER
217     , p10_a0 JTF_VARCHAR2_TABLE_100
218     , p10_a1 JTF_VARCHAR2_TABLE_300
219     , p11_a0 out nocopy JTF_NUMBER_TABLE
220     , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
221     , x_return_status out nocopy  VARCHAR2
222     , x_msg_count out nocopy  NUMBER
223     , x_msg_data out nocopy  VARCHAR2
224   );
225   procedure delete_contacts(p_api_version_number  NUMBER
226     , p_init_msg_list  VARCHAR2
227     , p_commit  VARCHAR2
228     , p_validation_level  NUMBER
229     , p_identity_salesforce_id  NUMBER
230     , p5_a0 JTF_DATE_TABLE
231     , p5_a1 JTF_NUMBER_TABLE
232     , p5_a2 JTF_DATE_TABLE
233     , p5_a3 JTF_NUMBER_TABLE
234     , p5_a4 JTF_NUMBER_TABLE
235     , p5_a5 JTF_NUMBER_TABLE
236     , p5_a6 JTF_NUMBER_TABLE
237     , p5_a7 JTF_NUMBER_TABLE
238     , p5_a8 JTF_DATE_TABLE
239     , p5_a9 JTF_NUMBER_TABLE
240     , p5_a10 JTF_NUMBER_TABLE
241     , p5_a11 JTF_NUMBER_TABLE
242     , p5_a12 JTF_NUMBER_TABLE
243     , p5_a13 JTF_NUMBER_TABLE
244     , p5_a14 JTF_VARCHAR2_TABLE_100
245     , p5_a15 JTF_VARCHAR2_TABLE_100
246     , p5_a16 JTF_VARCHAR2_TABLE_100
247     , p5_a17 JTF_VARCHAR2_TABLE_300
248     , p5_a18 JTF_NUMBER_TABLE
249     , p5_a19 JTF_VARCHAR2_TABLE_100
250     , p5_a20 JTF_VARCHAR2_TABLE_100
251     , p5_a21 JTF_VARCHAR2_TABLE_100
252     , p5_a22 JTF_VARCHAR2_TABLE_100
253     , p5_a23 JTF_VARCHAR2_TABLE_100
254     , p5_a24 JTF_NUMBER_TABLE
255     , p5_a25 JTF_VARCHAR2_TABLE_100
256     , p5_a26 JTF_VARCHAR2_TABLE_100
257     , p5_a27 JTF_NUMBER_TABLE
258     , p5_a28 JTF_VARCHAR2_TABLE_100
259     , p5_a29 JTF_VARCHAR2_TABLE_200
260     , p5_a30 JTF_VARCHAR2_TABLE_200
261     , p5_a31 JTF_VARCHAR2_TABLE_200
262     , p5_a32 JTF_VARCHAR2_TABLE_200
263     , p5_a33 JTF_VARCHAR2_TABLE_200
264     , p5_a34 JTF_VARCHAR2_TABLE_200
265     , p5_a35 JTF_VARCHAR2_TABLE_200
266     , p5_a36 JTF_VARCHAR2_TABLE_200
267     , p5_a37 JTF_VARCHAR2_TABLE_200
268     , p5_a38 JTF_VARCHAR2_TABLE_200
269     , p5_a39 JTF_VARCHAR2_TABLE_200
270     , p5_a40 JTF_VARCHAR2_TABLE_200
271     , p5_a41 JTF_VARCHAR2_TABLE_200
272     , p5_a42 JTF_VARCHAR2_TABLE_200
273     , p5_a43 JTF_VARCHAR2_TABLE_200
274     , p_check_access_flag  VARCHAR2
275     , p_admin_flag  VARCHAR2
276     , p_admin_group_id  NUMBER
277     , p_partner_cont_party_id  NUMBER
278     , p10_a0 JTF_VARCHAR2_TABLE_100
279     , p10_a1 JTF_VARCHAR2_TABLE_300
280     , p11_a0 out nocopy JTF_NUMBER_TABLE
281     , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
282     , x_return_status out nocopy  VARCHAR2
283     , x_msg_count out nocopy  NUMBER
284     , x_msg_data out nocopy  VARCHAR2
285   );
286   procedure delete_salesteams(p_api_version_number  NUMBER
287     , p_init_msg_list  VARCHAR2
288     , p_commit  VARCHAR2
289     , p_validation_level  NUMBER
290     , p4_a0 JTF_NUMBER_TABLE
291     , p4_a1 JTF_DATE_TABLE
292     , p4_a2 JTF_NUMBER_TABLE
293     , p4_a3 JTF_DATE_TABLE
294     , p4_a4 JTF_NUMBER_TABLE
295     , p4_a5 JTF_NUMBER_TABLE
296     , p4_a6 JTF_VARCHAR2_TABLE_100
297     , p4_a7 JTF_VARCHAR2_TABLE_100
298     , p4_a8 JTF_VARCHAR2_TABLE_100
299     , p4_a9 JTF_NUMBER_TABLE
300     , p4_a10 JTF_NUMBER_TABLE
301     , p4_a11 JTF_NUMBER_TABLE
302     , p4_a12 JTF_NUMBER_TABLE
303     , p4_a13 JTF_VARCHAR2_TABLE_300
304     , p4_a14 JTF_VARCHAR2_TABLE_100
305     , p4_a15 JTF_VARCHAR2_TABLE_100
306     , p4_a16 JTF_VARCHAR2_TABLE_300
307     , p4_a17 JTF_VARCHAR2_TABLE_100
308     , p4_a18 JTF_NUMBER_TABLE
309     , p4_a19 JTF_VARCHAR2_TABLE_100
310     , p4_a20 JTF_NUMBER_TABLE
311     , p4_a21 JTF_NUMBER_TABLE
312     , p4_a22 JTF_VARCHAR2_TABLE_100
313     , p4_a23 JTF_VARCHAR2_TABLE_100
314     , p4_a24 JTF_VARCHAR2_TABLE_100
315     , p4_a25 JTF_VARCHAR2_TABLE_100
316     , p4_a26 JTF_VARCHAR2_TABLE_100
317     , p4_a27 JTF_VARCHAR2_TABLE_100
318     , p4_a28 JTF_NUMBER_TABLE
319     , p4_a29 JTF_NUMBER_TABLE
320     , p4_a30 JTF_DATE_TABLE
321     , p4_a31 JTF_VARCHAR2_TABLE_300
322     , p4_a32 JTF_DATE_TABLE
323     , p4_a33 JTF_NUMBER_TABLE
324     , p4_a34 JTF_VARCHAR2_TABLE_100
325     , p4_a35 JTF_VARCHAR2_TABLE_100
326     , p4_a36 JTF_VARCHAR2_TABLE_200
327     , p4_a37 JTF_VARCHAR2_TABLE_200
328     , p4_a38 JTF_VARCHAR2_TABLE_200
329     , p4_a39 JTF_VARCHAR2_TABLE_200
330     , p4_a40 JTF_VARCHAR2_TABLE_200
331     , p4_a41 JTF_VARCHAR2_TABLE_200
332     , p4_a42 JTF_VARCHAR2_TABLE_200
333     , p4_a43 JTF_VARCHAR2_TABLE_200
334     , p4_a44 JTF_VARCHAR2_TABLE_200
335     , p4_a45 JTF_VARCHAR2_TABLE_200
336     , p4_a46 JTF_VARCHAR2_TABLE_200
337     , p4_a47 JTF_VARCHAR2_TABLE_200
338     , p4_a48 JTF_VARCHAR2_TABLE_200
339     , p4_a49 JTF_VARCHAR2_TABLE_200
340     , p4_a50 JTF_VARCHAR2_TABLE_200
341     , p4_a51 JTF_VARCHAR2_TABLE_100
342     , p4_a52 JTF_VARCHAR2_TABLE_100
343     , p4_a53 JTF_VARCHAR2_TABLE_100
344     , p4_a54 JTF_NUMBER_TABLE
345     , p4_a55 JTF_NUMBER_TABLE
346     , p4_a56 JTF_VARCHAR2_TABLE_100
350     , p_check_access_flag  VARCHAR2
347     , p4_a57 JTF_VARCHAR2_TABLE_100
348     , p4_a58 JTF_VARCHAR2_TABLE_100
349     , p4_a59 JTF_VARCHAR2_TABLE_100
351     , p_admin_flag  VARCHAR2
352     , p_admin_group_id  NUMBER
353     , p_identity_salesforce_id  NUMBER
354     , p_partner_cont_party_id  NUMBER
355     , p10_a0 JTF_VARCHAR2_TABLE_100
356     , p10_a1 JTF_VARCHAR2_TABLE_300
357     , x_return_status out nocopy  VARCHAR2
358     , x_msg_count out nocopy  NUMBER
359     , x_msg_data out nocopy  VARCHAR2
360   );
361   procedure copy_opportunity(p_api_version_number  NUMBER
362     , p_init_msg_list  VARCHAR2
363     , p_commit  VARCHAR2
364     , p_validation_level  NUMBER
365     , p_lead_id  NUMBER
366     , p_description  VARCHAR2
367     , p_copy_salesteam  VARCHAR2
368     , p_copy_opp_lines  VARCHAR2
369     , p_copy_lead_contacts  VARCHAR2
370     , p_copy_lead_competitors  VARCHAR2
371     , p_copy_sales_credits  VARCHAR2
372     , p_copy_methodology  VARCHAR2
373     , p_new_customer_id  NUMBER
374     , p_new_address_id  NUMBER
375     , p_check_access_flag  VARCHAR2
376     , p_admin_flag  VARCHAR2
377     , p_admin_group_id  NUMBER
378     , p_identity_salesforce_id  NUMBER
379     , p_salesgroup_id  NUMBER
380     , p_partner_cont_party_id  NUMBER
381     , p20_a0 JTF_VARCHAR2_TABLE_100
382     , p20_a1 JTF_VARCHAR2_TABLE_300
383     , x_return_status out nocopy  VARCHAR2
384     , x_msg_count out nocopy  NUMBER
385     , x_msg_data out nocopy  VARCHAR2
386     , x_lead_id out nocopy  NUMBER
387   );
388   procedure get_access_profiles(p0_a0 JTF_VARCHAR2_TABLE_100
389     , p0_a1 JTF_VARCHAR2_TABLE_300
390     , p1_a0 out nocopy  VARCHAR2
391     , p1_a1 out nocopy  VARCHAR2
392     , p1_a2 out nocopy  VARCHAR2
393     , p1_a3 out nocopy  VARCHAR2
394     , p1_a4 out nocopy  VARCHAR2
395   );
396   function get_profile(p0_a0 JTF_VARCHAR2_TABLE_100
397     , p0_a1 JTF_VARCHAR2_TABLE_300
398     , p_profile_name  VARCHAR2
399   ) return varchar2;
400 end as_opportunity_pub_w4;