1 PACKAGE AS_LINK_LEAD_OPP_UHK AUTHID CURRENT_USER AS
2 /* $Header: asxclnks.pls 115.1 2002/11/15 01:37:04 axavier ship $ */
3
4 -- Start of Comments
5 -- Package Name : AS_LINK_LEAD_OPP_UHK
6 --
7 -- Purpose : If user want to implement custom link lead to opportunity
8 -- logic, create a package body for this spec.
9 --
10 -- NOTE : Please do not 'commit' in the package body. Once the
11 -- transaction is completed, Oracle Application code will
12 -- issue a commit.
13 --
14 -- This user hooks will be called before/after Assign
15 -- Territory Accesses
16 --
17 -- History :
18 -- 07/01/2002 FFANG Created
19 --
20 -- End of Comments
21
22 /*-------------------------------------------------------------------------*
23 |
24 | PUBLIC CONSTANTS
25 |
26 *-------------------------------------------------------------------------*/
27
28 /*-------------------------------------------------------------------------*
29 |
30 | PUBLIC DATATYPES
31 |
32 *-------------------------------------------------------------------------*/
33
34 /*-------------------------------------------------------------------------*
35 |
36 | PUBLIC VARIABLES
37 |
38 *-------------------------------------------------------------------------*/
39
40 /*-------------------------------------------------------------------------*
41 |
42 | PUBLIC ROUTINES
43 |
44 *-------------------------------------------------------------------------*/
45
46 -- Start of Comments
47 --
48 -- API name : Copy_Lead_To_Opp_Pre
49 -- Parameters :
50 -- IN :
51 -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
52 -- p_init_msg_list : Initialize message stack or not. It's
53 -- FND_API.G_FALSE by default.
54 -- p_validation_level : Validation level for pass-in values.
55 -- It's FND_API.G_VALID_LEVEL_FULL by default.
56 -- p_commit : Whether commit the whole API at the end of API.
57 -- It's FND_API.G_FALSE by default.
58 --
59 -- The above four parameters are standard input.
60 --
61 -- IN :
62 -- p_sales_lead_id : sales lead ID
63 -- p_opportunity_id : opportunity ID
64 --
65 -- OUT :
66 -- x_return_status : The return status. If your code completes
67 -- successfully, then FND_API.G_RET_STS_SUCCESS
68 -- should be returned; if you get an expected error,
69 -- then return FND_API.G_RET_STS_ERROR; otherwise
70 -- return FND_API.G_RET_STS_UNEXP_ERROR.
71 -- x_msg_count : The message count.
72 -- Call FND_MSG_PUB.Count_And_Get to get the message
73 -- count and messages.
74 -- x_msg_data : The messages.
75 -- Call FND_MSG_PUB.Count_And_Get to get the message
76 -- count and messages.
77 --
78 -- The above three parameters are standard output
79 -- parameters.
80 --
81 PROCEDURE Copy_Lead_To_Opp_Pre(
82 p_api_version_number IN NUMBER,
83 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
85 p_commit IN VARCHAR2 := FND_API.G_FALSE,
86 P_SALES_LEAD_ID IN NUMBER,
87 P_OPPORTUNITY_ID IN NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2);
91
92
93
94 -- Start of Comments
95 --
96 -- API name : Copy_Lead_To_Opp_Post
97 -- Parameters :
98 -- IN :
99 -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
100 -- p_init_msg_list : Initialize message stack or not. It's
101 -- FND_API.G_FALSE by default.
102 -- p_validation_level : Validation level for pass-in values.
103 -- It's FND_API.G_VALID_LEVEL_FULL by default.
104 -- p_commit : Whether commit the whole API at the end of API.
105 -- It's FND_API.G_FALSE by default.
106 --
107 -- The above four parameters are standard input.
108 --
109 -- IN :
110 -- p_sales_lead_id : sales lead ID
111 -- p_opportunity_id : opportunity ID
112 --
113 -- OUT :
114 -- x_return_status : The return status. If your code completes
115 -- successfully, then FND_API.G_RET_STS_SUCCESS
116 -- should be returned; if you get an expected error,
117 -- then return FND_API.G_RET_STS_ERROR; otherwise
118 -- return FND_API.G_RET_STS_UNEXP_ERROR.
119 -- x_msg_count : The message count.
120 -- Call FND_MSG_PUB.Count_And_Get to get the message
121 -- count and messages.
122 -- x_msg_data : The messages.
123 -- Call FND_MSG_PUB.Count_And_Get to get the message
124 -- count and messages.
125 --
126 -- The above three parameters are standard output
127 -- parameters.
128 --
129 PROCEDURE Copy_Lead_To_Opp_Post(
130 p_api_version_number IN NUMBER,
131 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
133 p_commit IN VARCHAR2 := FND_API.G_FALSE,
134 P_SALES_LEAD_ID IN NUMBER,
135 P_OPPORTUNITY_ID IN NUMBER,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2);
139
140
141
142 -- Start of Comments
143 --
144 -- API name : Link_Lead_To_Opp_Pre
145 -- Parameters :
146 -- IN :
147 -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
148 -- p_init_msg_list : Initialize message stack or not. It's
149 -- FND_API.G_FALSE by default.
150 -- p_validation_level : Validation level for pass-in values.
151 -- It's FND_API.G_VALID_LEVEL_FULL by default.
152 -- p_commit : Whether commit the whole API at the end of API.
153 -- It's FND_API.G_FALSE by default.
154 --
155 -- The above four parameters are standard input.
156 --
157 -- IN :
158 -- p_sales_lead_id : sales lead ID
159 -- p_opportunity_id : opportunity ID
160 --
161 -- OUT :
162 -- x_return_status : The return status. If your code completes
163 -- successfully, then FND_API.G_RET_STS_SUCCESS
164 -- should be returned; if you get an expected error,
165 -- then return FND_API.G_RET_STS_ERROR; otherwise
166 -- return FND_API.G_RET_STS_UNEXP_ERROR.
167 -- x_msg_count : The message count.
168 -- Call FND_MSG_PUB.Count_And_Get to get the message
169 -- count and messages.
170 -- x_msg_data : The messages.
171 -- Call FND_MSG_PUB.Count_And_Get to get the message
172 -- count and messages.
173 --
174 -- The above three parameters are standard output
175 -- parameters.
176 --
177 PROCEDURE Link_Lead_To_Opp_Pre(
178 p_api_version_number IN NUMBER,
179 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
181 p_commit IN VARCHAR2 := FND_API.G_FALSE,
182 P_SALES_LEAD_ID IN NUMBER,
183 P_OPPORTUNITY_ID IN NUMBER,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2);
187
188
189
190 -- Start of Comments
191 --
192 -- API name : Link_Lead_To_Opp_Post
193 -- Parameters :
194 -- IN :
195 -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
196 -- p_init_msg_list : Initialize message stack or not. It's
197 -- FND_API.G_FALSE by default.
198 -- p_validation_level : Validation level for pass-in values.
199 -- It's FND_API.G_VALID_LEVEL_FULL by default.
200 -- p_commit : Whether commit the whole API at the end of API.
201 -- It's FND_API.G_FALSE by default.
202 --
203 -- The above four parameters are standard input.
204 --
205 -- IN :
206 -- p_sales_lead_id : sales lead ID
207 -- p_opportunity_id : opportunity ID
208 --
209 -- OUT :
210 -- x_return_status : The return status. If your code completes
211 -- successfully, then FND_API.G_RET_STS_SUCCESS
212 -- should be returned; if you get an expected error,
213 -- then return FND_API.G_RET_STS_ERROR; otherwise
214 -- return FND_API.G_RET_STS_UNEXP_ERROR.
215 -- x_msg_count : The message count.
216 -- Call FND_MSG_PUB.Count_And_Get to get the message
217 -- count and messages.
218 -- x_msg_data : The messages.
219 -- Call FND_MSG_PUB.Count_And_Get to get the message
220 -- count and messages.
221 --
222 -- The above three parameters are standard output
223 -- parameters.
224 --
225 PROCEDURE Link_Lead_To_Opp_Post(
226 p_api_version_number IN NUMBER,
227 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
228 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
229 p_commit IN VARCHAR2 := FND_API.G_FALSE,
230 P_SALES_LEAD_ID IN NUMBER,
231 P_OPPORTUNITY_ID IN NUMBER,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2);
235
236
237
238 -- Start of Comments
239 --
240 -- API name : Create_Opp_For_Lead_Pre
241 -- Parameters :
242 -- IN :
243 -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
244 -- p_init_msg_list : Initialize message stack or not. It's
245 -- FND_API.G_FALSE by default.
246 -- p_validation_level : Validation level for pass-in values.
247 -- It's FND_API.G_VALID_LEVEL_FULL by default.
248 -- p_commit : Whether commit the whole API at the end of API.
249 -- It's FND_API.G_FALSE by default.
250 --
251 -- The above four parameters are standard input.
252 --
253 -- IN :
254 -- p_sales_lead_id : sales lead ID
255 -- p_opportunity_id : opportunity ID
256 --
257 -- OUT :
258 -- x_return_status : The return status. If your code completes
259 -- successfully, then FND_API.G_RET_STS_SUCCESS
260 -- should be returned; if you get an expected error,
261 -- then return FND_API.G_RET_STS_ERROR; otherwise
262 -- return FND_API.G_RET_STS_UNEXP_ERROR.
263 -- x_msg_count : The message count.
264 -- Call FND_MSG_PUB.Count_And_Get to get the message
265 -- count and messages.
266 -- x_msg_data : The messages.
267 -- Call FND_MSG_PUB.Count_And_Get to get the message
268 -- count and messages.
269 --
270 -- The above three parameters are standard output
271 -- parameters.
272 --
273 PROCEDURE Create_Opp_For_Lead_Pre(
274 p_api_version_number IN NUMBER,
275 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
277 p_commit IN VARCHAR2 := FND_API.G_FALSE,
278 P_SALES_LEAD_ID IN NUMBER,
279 P_OPPORTUNITY_ID IN NUMBER,
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2);
283
284
285
286 -- Start of Comments
287 --
288 -- API name : Create_Opp_For_Lead_Post
289 -- Parameters :
290 -- IN :
291 -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
292 -- p_init_msg_list : Initialize message stack or not. It's
293 -- FND_API.G_FALSE by default.
294 -- p_validation_level : Validation level for pass-in values.
295 -- It's FND_API.G_VALID_LEVEL_FULL by default.
296 -- p_commit : Whether commit the whole API at the end of API.
297 -- It's FND_API.G_FALSE by default.
298 --
299 -- The above four parameters are standard input.
300 --
301 -- IN :
302 -- p_sales_lead_id : sales lead ID
303 -- p_opportunity_id : opportunity ID
304 --
305 -- OUT :
306 -- x_return_status : The return status. If your code completes
307 -- successfully, then FND_API.G_RET_STS_SUCCESS
308 -- should be returned; if you get an expected error,
309 -- then return FND_API.G_RET_STS_ERROR; otherwise
310 -- return FND_API.G_RET_STS_UNEXP_ERROR.
311 -- x_msg_count : The message count.
312 -- Call FND_MSG_PUB.Count_And_Get to get the message
313 -- count and messages.
314 -- x_msg_data : The messages.
315 -- Call FND_MSG_PUB.Count_And_Get to get the message
316 -- count and messages.
317 --
318 -- The above three parameters are standard output
319 -- parameters.
320 --
321 PROCEDURE Create_Opp_For_Lead_Post(
322 p_api_version_number IN NUMBER,
323 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
324 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
325 p_commit IN VARCHAR2 := FND_API.G_FALSE,
326 P_SALES_LEAD_ID IN NUMBER,
327 P_OPPORTUNITY_ID IN NUMBER,
328 x_return_status OUT NOCOPY VARCHAR2,
329 x_msg_count OUT NOCOPY NUMBER,
330 x_msg_data OUT NOCOPY VARCHAR2);
331
332
333 End AS_LINK_LEAD_OPP_UHK;