1 PACKAGE AS_BUSINESS_EVENT_PUB AUTHID CURRENT_USER as
2 /* $Header: asxpbevs.pls 115.1 2003/11/21 13:59:37 sumahali noship $ */
3
4 -- Start of Comments
5 --
6 -- API name : Before_Oppty_Update
7 -- Type : Public
8 -- Function : When called before Opportunity header update, takes
9 -- snapshot of Opp header and returns an event key in
10 -- x_event_key which is to be passed, when raising a
11 -- business event after the update is over using the
12 -- Update_oppty_post_event procedure. If lead_id is
13 -- NULL then a new Event key is returned without taking
14 -- a snapshot. This can be used before creating a new
15 -- opportunity since no lead_id is available.
16 --
17 -- Pre-reqs : Existing lead_id or NULL value.
18 --
19 -- Paramaeters :
20 -- IN :
21 -- p_api_version_number IN NUMBER
22 -- p_init_msg_list IN VARCHAR2
23 -- p_commit IN VARCHAR2
24 -- p_validation_level IN NUMBER
25 -- p_lead_id IN NUMBER
26 -- OUT :
27 -- x_return_status OUT NOCOPY VARCHAR2(1)
28 -- x_msg_count OUT NOCOPY NUMBER
29 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
30 -- x_event_key OUT NOCOPY VARCHAR2
31 --
32 --
33 -- Version : Current version 2.0
34 -- Initial version 2.0
35 --
36 -- Notes:
37 --
38 --
39 -- End of Comments
40
41
42 PROCEDURE Before_Oppty_Update(
43 p_api_version_number IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
47 p_lead_id IN NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 x_event_key OUT NOCOPY VARCHAR2
52 );
53
54 -- Start of Comments
55 --
56 -- API name : Update_oppty_post_event
57 -- Type : Public
58 -- Function : Raises a business event for Opportunity header update.
59 -- The Procedure Before_Oppty_Update should have been
60 -- called and the same event key must be passed.
61 --
62 -- Pre-reqs : Existing lead_id and x_event_key from
63 -- Before_Oppty_Update call.
64 --
65 -- Paramaeters :
66 -- IN :
67 -- p_api_version_number IN NUMBER
68 -- p_init_msg_list IN VARCHAR2
69 -- p_commit IN VARCHAR2
70 -- p_validation_level IN NUMBER
71 -- p_event_key IN VARCHAR2
72 -- p_lead_id IN NUMBER
73 -- OUT :
74 -- x_return_status OUT NOCOPY VARCHAR2(1)
75 -- x_msg_count OUT NOCOPY NUMBER
76 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
77 --
78 --
79 -- Version : Current version 2.0
80 -- Initial version 2.0
81 --
82 -- Notes:
83 --
84 --
85 -- End of Comments
86
87 PROCEDURE Update_oppty_post_event(
88 p_api_version_number IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
92 p_lead_id IN NUMBER,
93 p_event_key IN VARCHAR2,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 -- Start of Comments
100 --
101 -- API name : Before_Opp_Lines_Update
102 -- Type : Public
103 -- Function : When called before Opportunity line update, takes
104 -- snapshot of Opp lines and returns an event key in
105 -- x_event_key which is to be passed, when raising a
106 -- business event after the update is over using the
107 -- Upd_Opp_Lines_post_event procedure. If lead_id is
108 -- NULL then a new Event key is returned without taking
109 -- a snapshot. This can be used before creating a new
110 -- opportunity since no lead_id is available.
111 --
112 -- Pre-reqs : Existing lead_id or NULL value.
113 --
114 -- Paramaeters :
115 -- IN :
116 -- p_api_version_number IN NUMBER
117 -- p_init_msg_list IN VARCHAR2
118 -- p_commit IN VARCHAR2
119 -- p_validation_level IN NUMBER
120 -- p_lead_id IN NUMBER
121 -- OUT :
122 -- x_return_status OUT NOCOPY VARCHAR2(1)
123 -- x_msg_count OUT NOCOPY NUMBER
124 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
125 -- x_event_key OUT NOCOPY VARCHAR2
126 --
127 --
128 -- Version : Current version 2.0
129 -- Initial version 2.0
130 --
131 -- Notes:
132 --
133 --
134 -- End of Comments
135
136
137 PROCEDURE Before_Opp_Lines_Update(
138 p_api_version_number IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
140 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
141 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
142 p_lead_id IN NUMBER,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 x_event_key OUT NOCOPY VARCHAR2
147 );
148
149 -- Start of Comments
150 --
151 -- API name : Upd_Opp_Lines_post_event
152 -- Type : Public
153 -- Function : Raises a business event for Opportunity line update.
154 -- The Procedure Before_Opp_Lines_Update should have been
155 -- called and the same event key must be passed.
156 --
157 -- Pre-reqs : Existing lead_id and x_event_key from
158 -- Before_Opp_Lines_Update call.
159 --
160 -- Paramaeters :
161 -- IN :
162 -- p_api_version_number IN NUMBER
163 -- p_init_msg_list IN VARCHAR2
164 -- p_commit IN VARCHAR2
165 -- p_validation_level IN NUMBER
166 -- p_event_key IN VARCHAR2
167 -- p_lead_id IN NUMBER
168 -- OUT :
169 -- x_return_status OUT NOCOPY VARCHAR2(1)
170 -- x_msg_count OUT NOCOPY NUMBER
171 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
172 --
173 --
174 -- Version : Current version 2.0
175 -- Initial version 2.0
176 --
177 -- Notes:
178 --
179 --
180 -- End of Comments
181
182 PROCEDURE Upd_Opp_Lines_post_event(
183 p_api_version_number IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
185 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
187 p_lead_id IN NUMBER,
188 p_event_key IN VARCHAR2,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2
192 );
193
194 -- Start of Comments
195 --
196 -- API name : Before_Opp_STeam_Update
197 -- Type : Public
198 -- Function : When called before Opportunity sales team update, takes
199 -- snapshot of Opp sales team and returns an event key in
200 -- x_event_key which is to be passed, when raising a
201 -- business event after the update is over using the
202 -- Upd_Opp_STeam_post_event procedure. If lead_id is
203 -- NULL then a new Event key is returned without taking
204 -- a snapshot. This can be used before creating a new
205 -- opportunity since no lead_id is available.
206 --
207 -- Pre-reqs : Existing lead_id or NULL value.
208 --
209 -- Paramaeters :
210 -- IN :
211 -- p_api_version_number IN NUMBER
212 -- p_init_msg_list IN VARCHAR2
213 -- p_commit IN VARCHAR2
214 -- p_validation_level IN NUMBER
215 -- p_lead_id IN NUMBER
216 -- OUT :
217 -- x_return_status OUT NOCOPY VARCHAR2(1)
218 -- x_msg_count OUT NOCOPY NUMBER
219 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
220 -- x_event_key OUT NOCOPY VARCHAR2
221 --
222 --
223 -- Version : Current version 2.0
224 -- Initial version 2.0
225 --
226 -- Notes:
227 --
228 --
229 -- End of Comments
230
231
232 PROCEDURE Before_Opp_STeam_Update(
233 p_api_version_number IN NUMBER,
234 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
235 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
236 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
237 p_lead_id IN NUMBER,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241 x_event_key OUT NOCOPY VARCHAR2
242 );
243
244 -- Start of Comments
245 --
246 -- API name : Upd_Opp_STeam_post_event
247 -- Type : Public
248 -- Function : Raises a business event for Opportunity sales team
249 -- update. The Procedure Before_Opp_STeam_Update should
250 -- have been called and the same event key must be passed.
251 --
252 -- Pre-reqs : Existing lead_id and x_event_key from
253 -- Before_Opp_STeam_Update call.
254 --
255 -- Paramaeters :
256 -- IN :
257 -- p_api_version_number IN NUMBER
258 -- p_init_msg_list IN VARCHAR2
259 -- p_commit IN VARCHAR2
260 -- p_validation_level IN NUMBER
261 -- p_event_key IN VARCHAR2
262 -- p_lead_id IN NUMBER
263 -- OUT :
264 -- x_return_status OUT NOCOPY VARCHAR2(1)
265 -- x_msg_count OUT NOCOPY NUMBER
266 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
267 --
268 --
269 -- Version : Current version 2.0
270 -- Initial version 2.0
271 --
272 -- Notes:
273 --
274 --
275 -- End of Comments
276
277 PROCEDURE Upd_Opp_STeam_post_event(
278 p_api_version_number IN NUMBER,
279 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
280 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
281 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
282 p_lead_id IN NUMBER,
283 p_event_key IN VARCHAR2,
284 x_return_status OUT NOCOPY VARCHAR2,
285 x_msg_count OUT NOCOPY NUMBER,
286 x_msg_data OUT NOCOPY VARCHAR2
287 );
288
289 -- Start of Comments
290 --
291 -- API name : Before_Cust_STeam_Update
292 -- Type : Public
293 -- Function : When called before Customer sales team update, takes
294 -- snapshot of Cust sales team and returns an event key in
295 -- x_event_key which is to be passed, when raising a
296 -- business event after the update is over using the
297 -- Upd_Cust_STeam_post_event procedure. If cust_id is
298 -- NULL then a new Event key is returned without taking
299 -- a snapshot. This can be used before creating a new
300 -- customer since no cust_id is available.
301 --
302 -- Pre-reqs : Existing cust_id or NULL value.
303 --
304 -- Paramaeters :
305 -- IN :
306 -- p_api_version_number IN NUMBER
307 -- p_init_msg_list IN VARCHAR2
308 -- p_commit IN VARCHAR2
309 -- p_validation_level IN NUMBER
310 -- p_cust_id IN NUMBER
311 -- OUT :
312 -- x_return_status OUT NOCOPY VARCHAR2(1)
313 -- x_msg_count OUT NOCOPY NUMBER
314 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
315 -- x_event_key OUT NOCOPY VARCHAR2
316 --
317 --
318 -- Version : Current version 2.0
319 -- Initial version 2.0
320 --
321 -- Notes:
322 --
323 --
324 -- End of Comments
325
326
327 PROCEDURE Before_Cust_STeam_Update(
328 p_api_version_number IN NUMBER,
329 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
330 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
331 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
332 p_cust_id IN NUMBER,
333 x_return_status OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER,
335 x_msg_data OUT NOCOPY VARCHAR2,
336 x_event_key OUT NOCOPY VARCHAR2
337 );
338
339 -- Start of Comments
340 --
341 -- API name : Upd_Cust_STeam_post_event
342 -- Type : Public
343 -- Function : Raises a business event for Customer sales team
344 -- update. The Procedure Before_Cust_STeam_Update should
345 -- have been called and the same event key must be passed.
346 --
347 -- Pre-reqs : Existing cust_id and x_event_key from
348 -- Before_Cust_STeam_Update call.
349 --
350 -- Paramaeters :
351 -- IN :
352 -- p_api_version_number IN NUMBER
353 -- p_init_msg_list IN VARCHAR2
354 -- p_commit IN VARCHAR2
355 -- p_validation_level IN NUMBER
356 -- p_event_key IN VARCHAR2
357 -- p_cust_id IN NUMBER
358 -- OUT :
359 -- x_return_status OUT NOCOPY VARCHAR2(1)
360 -- x_msg_count OUT NOCOPY NUMBER
361 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
362 --
363 --
364 -- Version : Current version 2.0
365 -- Initial version 2.0
366 --
367 -- Notes:
368 --
369 --
370 -- End of Comments
371
372 PROCEDURE Upd_Cust_STeam_post_event(
373 p_api_version_number IN NUMBER,
374 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
375 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
376 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
377 p_cust_id IN NUMBER,
378 p_event_key IN VARCHAR2,
379 x_return_status OUT NOCOPY VARCHAR2,
380 x_msg_count OUT NOCOPY NUMBER,
381 x_msg_data OUT NOCOPY VARCHAR2
382 );
383
384 END AS_BUSINESS_EVENT_PUB;