1 PACKAGE AS_SALES_LEADS_PUB as
2 /* $Header: asxpslms.pls 120.2 2006/06/28 21:30:19 solin noship $ */
3 /*#
4 * This package provides methods to create, update, or delete leads, lead product
5 * interests, and lead contacts for Oracle Leads Management.
6 * @rep:scope public
7 * @rep:product AMS
8 * @rep:lifecycle active
9 * @rep:displayname Oracle Leads Management Public API
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY AMS_LEAD
12 */
13
14 -- Start of Comments
15 -- Package name : AS_SALES_LEADS_PUB
16 -- Purpose : Sales Leads Management
17 -- NOTE :
18 -- History :
19 -- 06/05/2000 FFANG Created.
20 -- creating opportunity
21 -- 12/12/2000 FFANG For bug 1529886, add one parameter P_OPP_STATUS in
22 -- create_opportunity_for_lead to get opportunity status
23 -- when creating opportunity
24 -- 06/05/2001 SOLIN Add API Build_Lead_Sales_Team and
25 -- Rebuild_Lead_Sales_Team.
26 -- 12/10/2001 SOLIN Bug 2102901.
27 -- Add salesgroup_id for current user in
28 -- Build_Lead_Sales_Team and Rebuild_Lead_Sales_Team
29 -- 03/20/2002 SOLIN Add LEAD_ENGINES_OUT_Rec_Type.
30 -- Add API Start_Partner_Matching.
31 -- 03/26/2002 AJOY Add Route_Lead_To_Marketing API for assigning to
32 -- marketing owner for the lead that does not have owner.
33 -- 08/06/2002 SOLIN Comment out API Get_Potential_Opportunity because
34 -- it's moved to package AS_LINK_LEAD_OPP_PUB.
35 -- 11/04/2002 SOLIN Add API Lead_Process_After_Create and
36 -- Lead_Process_After_Update
37 -- 12/17/2003 SOLIN ER 3322617, extend length from 30 to 240 for the
38 -- columns SOURCE_PRIMARY_REFERENCE and
39 -- SOURCE_SECONDARY_REFERENCE
40 --
41 -- End of Comments
42
43 -- Default number of records fetch per call
44 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
45 -- *******************************************************
46 -- Start of Comments
47 -- -------------------------------------------------------
48 -- Record name:SALES_LEAD_Rec_Type
49 -- -------------------------------------------------------
50
51 TYPE SALES_LEAD_Rec_Type IS RECORD
52 (
53 SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
54 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
56 CREATION_DATE DATE := FND_API.G_MISS_DATE,
57 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
59 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
60 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
61 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
62 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63 LEAD_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
64 STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
65 CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
66 ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
67 SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
68 INITIATING_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69 ORIG_SYSTEM_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70 CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
71 CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72 BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74 DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
75 CLOSE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
76 LEAD_RANK_ID NUMBER := FND_API.G_MISS_NUM,
77 LEAD_RANK_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
78 PARENT_PROJECT VARCHAR2(80) := FND_API.G_MISS_CHAR,
79 DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96 ASSIGN_TO_PERSON_ID NUMBER := FND_API.G_MISS_NUM,
97 ASSIGN_TO_SALESFORCE_ID NUMBER := FND_API.G_MISS_NUM,
98 ASSIGN_SALES_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
99 ASSIGN_DATE DATE := FND_API.G_MISS_DATE,
100 BUDGET_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101 ACCEPT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
102 VEHICLE_RESPONSE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103 TOTAL_SCORE NUMBER := FND_API.G_MISS_NUM,
104 SCORECARD_ID NUMBER := FND_API.G_MISS_NUM,
105 KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
106 URGENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
107 IMPORT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
108 REJECT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109 DELETED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
110 OFFER_ID NUMBER := FND_API.G_MISS_NUM,
111 -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
112 INCUMBENT_PARTNER_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
113 INCUMBENT_PARTNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
114 PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115 PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116 PRM_SALES_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
117 PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118 QUALIFIED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
119 ORIG_SYSTEM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120 PRM_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121 AUTO_ASSIGNMENT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122 PRIMARY_CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
123
124 -- new columns added for bug 2098158
125 PRIMARY_CNT_PERSON_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
126 PRIMARY_CONTACT_PHONE_ID NUMBER := FND_API.G_MISS_NUM,
127
128 -- new columns added for CAPRI lead referral
129
130 REFERRED_BY NUMBER := FND_API.G_MISS_NUM,
131 REFERRAL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
132 REFERRAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
133 REF_DECLINE_REASON VARCHAR2(30) := FND_API.G_MISS_CHAR,
134 REF_COMM_LTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
135 REF_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
136 REF_ORDER_AMT NUMBER := FND_API.G_MISS_NUM,
137 REF_COMM_AMT NUMBER := FND_API.G_MISS_NUM,
138 -- bug No.2341515, 2368075
139 LEAD_DATE DATE := FND_API.G_MISS_DATE,
140 SOURCE_SYSTEM VARCHAR2(30) := FND_API.G_MISS_CHAR,
141 COUNTRY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142
143
144 -- 11.5.9
145 TOTAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
146 EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
147 LEAD_ENGINE_RUN_DATE DATE := FND_API.G_MISS_DATE,
148 LEAD_RANK_IND VARCHAR2(1) := FND_API.G_MISS_CHAR,
149 CURRENT_REROUTES NUMBER := FND_API.G_MISS_NUM
150 -- 11.5.10 new columns ckapoor
151 , MARKETING_SCORE NUMBER := FND_API.G_MISS_NUM
152 , INTERACTION_SCORE NUMBER := FND_API.G_MISS_NUM
153 -- ER 3322617, extend length from 30 to 240 for the following two
154 -- columns
155 , SOURCE_PRIMARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR
156 , SOURCE_SECONDARY_REFERENCE VARCHAR2(240) := FND_API.G_MISS_CHAR
157
158 , SALES_METHODOLOGY_ID NUMBER := FND_API.G_MISS_NUM
159 , SALES_STAGE_ID NUMBER := FND_API.G_MISS_NUM
160 );
161
162 G_MISS_SALES_LEAD_REC SALES_LEAD_Rec_Type;
163
164 TYPE SALES_LEAD_Tbl_Type IS TABLE OF SALES_LEAD_Rec_Type
165 INDEX BY BINARY_INTEGER;
166
167 G_MISS_SALES_LEAD_TBL SALES_LEAD_Tbl_Type;
168
169
170 -- -------------------------------------------------------
171 -- Record name:SALES_LEAD_LINE_Rec_Type
172 -- -------------------------------------------------------
173
174 TYPE SALES_LEAD_LINE_Rec_Type IS RECORD
175 (
176 SALES_LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
177 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
178 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
179 CREATION_DATE DATE := FND_API.G_MISS_DATE,
180 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
181 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
182 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
183 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
184 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
185 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
186 SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
187 STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188
189 -- 11.5.10 Rivendell product category changes
190
191 --INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
192 --PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
193 --SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
194
195 CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
196 CATEGORY_SET_ID NUMBER := FND_API.G_MISS_NUM,
197
198
199 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
200 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
201 UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
202 QUANTITY NUMBER := FND_API.G_MISS_NUM,
203 BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
204 SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
205 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
206 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221 OFFER_ID NUMBER := FND_API.G_MISS_NUM
222 -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM
223 );
224
225 G_MISS_SALES_LEAD_LINE_REC SALES_LEAD_LINE_Rec_Type;
226
227 TYPE SALES_LEAD_LINE_Tbl_Type IS TABLE OF SALES_LEAD_LINE_Rec_Type
228 INDEX BY BINARY_INTEGER;
229
230 G_MISS_SALES_LEAD_LINE_TBL SALES_LEAD_LINE_Tbl_Type;
231
232 -- -------------------------------------------------------
233 -- Record name:SALES_LEAD_LINE_OUT_Rec_Type
234 -- -------------------------------------------------------
235
236 TYPE SALES_LEAD_LINE_OUT_Rec_Type IS RECORD
237 (
238 SALES_LEAD_LINE_ID NUMBER,
239 RETURN_STATUS VARCHAR2(1)
240 );
241
242 TYPE SALES_LEAD_LINE_OUT_Tbl_Type IS TABLE OF SALES_LEAD_LINE_OUT_Rec_Type
243 INDEX BY BINARY_INTEGER;
244
245 -- -------------------------------------------------------
246 -- Record name:SALES_LEAD_CONTACT_Rec_Type
247 -- -------------------------------------------------------
248
249 TYPE SALES_LEAD_CONTACT_Rec_Type IS RECORD
250 (
251 LEAD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
252 SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
253 CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
254 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
255 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
256 CREATION_DATE DATE := FND_API.G_MISS_DATE,
257 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
258 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
259 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
260 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
261 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
262 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
263 ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
264 RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
265 CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
266 ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
267 PHONE_ID NUMBER := FND_API.G_MISS_NUM,
268 CONTACT_ROLE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
269 PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
270 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
271 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286 -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
287 CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM
288 );
289
293 INDEX BY BINARY_INTEGER;
290 G_MISS_SALES_LEAD_CONTACT_REC SALES_LEAD_CONTACT_Rec_Type;
291
292 TYPE SALES_LEAD_CONTACT_Tbl_Type IS TABLE OF SALES_LEAD_CONTACT_Rec_Type
294
295 G_MISS_SALES_LEAD_CONTACT_TBL SALES_LEAD_CONTACT_Tbl_Type;
296
297 -- -------------------------------------------------------
298 -- Record name:SALES_LEAD_CNT_OUT_Rec_Type
299 -- -------------------------------------------------------
300
301 TYPE SALES_LEAD_CNT_OUT_Rec_Type IS RECORD
302 (
303 LEAD_CONTACT_ID NUMBER,
304 RETURN_STATUS VARCHAR2(1)
305 );
306
307 TYPE SALES_LEAD_CNT_OUT_Tbl_Type IS TABLE OF SALES_LEAD_CNT_OUT_Rec_Type
308 INDEX BY BINARY_INTEGER;
309
310 -- -------------------------------------------------------
311 -- Record name:Assign_Id_Rec_Type
312 -- -------------------------------------------------------
313
314 Type Assign_Id_Rec_Type Is Record (
315 Resource_Id NUMBER,
316 Sales_Group_Id NUMBER);
317
318 Assign_Id_Rec Assign_Id_Rec_Type;
319
320 Type Assign_Id_Tbl_Type Is TABLE OF Assign_Id_Rec_Type
321 INDEX BY BINARY_INTEGER;
322
323 -- -------------------------------------------------------
324 -- Record name:LEAD_ENGINES_OUT_Rec_Type
325 -- -------------------------------------------------------
326
327 TYPE LEAD_ENGINES_OUT_Rec_Type IS RECORD
328 (
329 qualified_flag VARCHAR2(1),
330 lead_rank_id NUMBER,
331 channel_code VARCHAR2(30),
332 indirect_channel_flag VARCHAR2(1),
333 sales_team_flag VARCHAR2(1)
334 );
335
336 -- -------------------------------------------------------
337 -- Record name:AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL
338 -- -------------------------------------------------------
339
340 --
341 -- API Name: Create_sales_leads
342 --
343 PROCEDURE Create_sales_lead(
344 P_Api_Version_Number IN NUMBER,
345 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
346 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
347 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
350 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
351 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
352 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
353 P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type := G_MISS_SALES_LEAD_REC,
354 P_SALES_LEAD_LINE_tbl IN SALES_LEAD_LINE_tbl_type
355 DEFAULT G_MISS_SALES_LEAD_LINE_tbl,
356 P_SALES_LEAD_CONTACT_tbl IN SALES_LEAD_CONTACT_tbl_type
357 DEFAULT G_MISS_SALES_LEAD_CONTACT_tbl,
358 X_SALES_LEAD_ID OUT NOCOPY NUMBER,
359 X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,
360 X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,
361 X_Return_Status OUT NOCOPY VARCHAR2,
362 X_Msg_Count OUT NOCOPY NUMBER,
363 X_Msg_Data OUT NOCOPY VARCHAR2
364 );
365
366 --
367 -- API Name: Update_sales_leads
368 --
369
370 /*#
371 * This procedure updates a lead. The details of lead will be passed in p_sales_lead_rec.
372 * Check x_return_status output to see if creation was successful.
373 * @param p_api_version_number API version
374 * @param p_init_msg_list Initialize message list
375 * @param p_commit Commit after update
376 * @param p_validation_level Validation level for the record details
377 * @param p_check_access_flag Check access flag
378 * @param p_admin_flag Admin flag to denote admin responsibility
379 * @param p_admin_group_id Admin group id
380 * @param p_identity_salesforce_id Salesforce_id of the lead creator
381 * @param p_sales_lead_profile_tbl Table containing profile values for sales lead
382 * @param p_sales_lead_rec Record containing leads attributes
383 * @param x_return_status Return status of the create operation
384 * @param x_msg_count Number of the error messages returned
385 * @param x_msg_data Error messages
386 * @rep:scope public
387 * @rep:lifecycle active
388 * @rep:displayname Update Sales Lead
389 */
390 PROCEDURE Update_sales_lead(
391 P_Api_Version_Number IN NUMBER,
392 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
394 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
396 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
397 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
398 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
399 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
400 P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type
401 DEFAULT G_MISS_SALES_LEAD_REC,
402 X_Return_Status OUT NOCOPY VARCHAR2,
406
403 X_Msg_Count OUT NOCOPY NUMBER,
404 X_Msg_Data OUT NOCOPY VARCHAR2
405 );
407 /*
408 --
409 -- API Name: Delete_sales_leads
410 --
411 PROCEDURE Delete_sales_lead(
412 P_Api_Version_Number IN NUMBER,
413 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
414 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
415 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
416 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
419 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
420 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
421 P_SALES_LEAD_ID IN NUMBER,
422 X_Return_Status OUT NOCOPY VARCHAR2,
423 X_Msg_Count OUT NOCOPY NUMBER,
424 X_Msg_Data OUT NOCOPY VARCHAR2
425 );
426 */
427
428 -- Start Sales_Lead_Line part
429 --
430 -- API Name: Create_sales_lead_lines
431 --
432
433 /*#
434 * This procedure creates lead product interests. The details of lead product interests
435 * will be passed in p_sales_lead_line_tbl. Check x_return_status output to see if creation
436 * was successful.
437 * @param p_api_version_number API version
438 * @param p_init_msg_list Initialize message list
439 * @param p_commit Commit after update
440 * @param p_validation_level Validation level for the record details
441 * @param p_check_access_flag Check access flag
442 * @param p_admin_flag Admin flag to denote admin responsibility
443 * @param p_admin_group_id Admin group id
444 * @param p_identity_salesforce_id Salesforce_id of the lead creator
445 * @param p_sales_lead_profile_tbl Table containing profile values for sales lead
446 * @param p_sales_lead_line_tbl Table containing lead lines records
447 * @param p_sales_lead_id Sales Lead Id in which lead lines to be created
448 * @param x_sales_lead_line_out_tbl Generated Sales Lead Line Id
449 * @param x_return_status Return status of the create operation
450 * @param x_msg_count Number of the error messages returned
451 * @param x_msg_data Error messages
452 * @rep:scope public
453 * @rep:lifecycle active
454 * @rep:displayname Create Sales Lead Lines
455 */
456 PROCEDURE Create_sales_lead_lines(
457 P_Api_Version_Number IN NUMBER,
458 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
459 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
460 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
462 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
463 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
464 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
465 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
466 P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_Type
467 := G_MISS_SALES_LEAD_LINE_Tbl,
468 P_SALES_LEAD_ID IN NUMBER,
469 X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,
470 X_Return_Status OUT NOCOPY VARCHAR2,
471 X_Msg_Count OUT NOCOPY NUMBER,
472 X_Msg_Data OUT NOCOPY VARCHAR2
473 );
474
475 --
476 -- API Name: Update_sales_lead_lines
477 --
478
479 /*#
480 * This procedure updates lead product interests. The details of lead product interests
481 * will be passed in p_sales_lead_line_tbl. Check x_return_status output to see if the update
482 * was successful.
483 * @param p_api_version_number API version
484 * @param p_init_msg_list Initialize message list
485 * @param p_commit Commit after update
486 * @param p_validation_level Validation level for the record details
487 * @param p_check_access_flag Check access flag
488 * @param p_admin_flag Admin flag to denote admin responsibility
489 * @param p_admin_group_id Admin group id
490 * @param p_identity_salesforce_id Salesforce_id of the lead creator
491 * @param p_sales_lead_profile_tbl Table containing profile values for sales lead
492 * @param p_sales_lead_line_tbl Table containing lead lines records
493 * @param x_sales_lead_line_out_tbl Generated Sales Lead Line Id
494 * @param x_return_status Return status of the update operation
495 * @param x_msg_count Number of the error messages returned
496 * @param x_msg_data Error messages
497 * @rep:scope public
498 * @rep:lifecycle active
499 * @rep:displayname Update Sales Lead Lines
500 */
501 PROCEDURE Update_sales_lead_lines(
502 P_Api_Version_Number IN NUMBER,
503 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
504 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
505 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
507 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
508 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
509 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
510 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
511 P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_Type,
515 X_Msg_Data OUT NOCOPY VARCHAR2
512 X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,
513 X_Return_Status OUT NOCOPY VARCHAR2,
514 X_Msg_Count OUT NOCOPY NUMBER,
516 );
517
518 --
519 -- API Name: Delete_sales_lead_lines
520 --
521
522 /*#
523 * This procedure deletes lead product interests. The details of lead product interests
524 * will be passed in p_sales_lead_line_tbl. Check x_return_status output to see if deletion
525 * was successful.
526 * @param p_api_version_number API version
527 * @param p_init_msg_list Initialize message list
528 * @param p_commit Commit after update
529 * @param p_validation_level Validation level for the record details
530 * @param p_check_access_flag Check access flag
531 * @param p_admin_flag Admin flag to denote admin responsibility
532 * @param p_admin_group_id Admin group id
533 * @param p_identity_salesforce_id Salesforce_id of the lead creator
534 * @param p_sales_lead_profile_tbl Table containing profile values for sales lead
535 * @param p_sales_lead_line_tbl Table containing lead lines records
536 * @param x_sales_lead_line_out_tbl Generated Sales Lead Line Id
537 * @param x_return_status Return status of the delete operation
538 * @param x_msg_count Number of the error messages returned
539 * @param x_msg_data Error messages
540 * @rep:scope public
541 * @rep:lifecycle active
542 * @rep:displayname Delete Sales Lead Lines
543 */
544 PROCEDURE Delete_sales_lead_lines(
545 P_Api_Version_Number IN NUMBER,
546 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
547 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
548 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
549 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
550 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
551 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
552 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
553 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
554 P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_type,
555 X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,
556 X_Return_Status OUT NOCOPY VARCHAR2,
557 X_Msg_Count OUT NOCOPY NUMBER,
558 X_Msg_Data OUT NOCOPY VARCHAR2
559 );
560
561
562 -- Start Sales_Lead_Contact part
563 --
564 -- API Name: Create_sales_lead_contact
565 --
566
567 /*#
568 * This procedure creates lead contacts. The details of lead contacts will be passed in
569 * p_sales_lead_contact_tbl. Check x_return_status output to see if creation was successful.
570 * @param p_api_version_number API version
571 * @param p_init_msg_list Initialize message list
572 * @param p_commit Commit after update
573 * @param p_validation_level Validation level for the record details
574 * @param p_check_access_flag Check access flag
575 * @param p_admin_flag Admin flag to denote admin responsibility
576 * @param p_admin_group_id Admin group id
577 * @param p_identity_salesforce_id Salesforce_id of the lead creator
578 * @param p_sales_lead_profile_tbl Table containing profile values for sales lead
579 * @param p_sales_lead_contact_tbl Table containing lead contacts records
580 * @param p_sales_lead_id Sales Lead Id
581 * @param x_sales_lead_cnt_out_tbl Generated Sales Lead Contacts Id
582 * @param x_return_status Return status of the create operation
583 * @param x_msg_count Number of the error messages returned
584 * @param x_msg_data Error messages
585 * @rep:scope public
586 * @rep:lifecycle active
587 * @rep:displayname Create Sales Lead Contacts
588 */
589 PROCEDURE Create_sales_lead_contacts(
590 P_Api_Version_Number IN NUMBER,
591 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
592 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
593 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
595 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
596 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
597 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
598 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
599 P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type
600 := G_MISS_SALES_LEAD_CONTACT_Tbl,
601 p_SALES_LEAD_ID IN NUMBER,
602 X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,
603 X_Return_Status OUT NOCOPY VARCHAR2,
604 X_Msg_Count OUT NOCOPY NUMBER,
605 X_Msg_Data OUT NOCOPY VARCHAR2
606 );
607
608 --
609 -- API Name: Update_sales_lead_contact
610 --
611
612 /*#
613 * This procedure updates lead contacts. The details of lead contacts will be passed in
614 * p_sales_lead_contact_tbl. Check x_return_status output to see if the update was successful.
615 * @param p_api_version_number API version
616 * @param p_init_msg_list Initialize message list
617 * @param p_commit Commit after update
618 * @param p_validation_level Validation level for the record details
619 * @param p_check_access_flag Check access flag
623 * @param p_sales_lead_profile_tbl Table containing profile values for sales lead
620 * @param p_admin_flag Admin flag to denote admin responsibility
621 * @param p_admin_group_id Admin group id
622 * @param p_identity_salesforce_id Salesforce_id of the lead creator
624 * @param p_sales_lead_contact_tbl Table containing lead contact records
625 * @param x_sales_lead_cnt_out_tbl Generated Sales Lead Contacts Id
626 * @param x_return_status Return status of the update operation
627 * @param x_msg_count Number of the error messages returned
628 * @param x_msg_data Error messages
629 * @rep:scope public
630 * @rep:lifecycle active
631 * @rep:displayname Update Sales Lead Contacts
632 */
633 PROCEDURE Update_sales_lead_contacts(
634 P_Api_Version_Number IN NUMBER,
635 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
636 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
637 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
638 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
639 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
640 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
641 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
642 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
643 P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type,
644 X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,
645 X_Return_Status OUT NOCOPY VARCHAR2,
646 X_Msg_Count OUT NOCOPY NUMBER,
647 X_Msg_Data OUT NOCOPY VARCHAR2
648 );
649
650 --
651 -- API Name: Delete_sales_lead_contact
652 --
653
654 /*#
655 * This procedure deletes lead contacts. The details of lead contacts will be passed in
656 * p_sales_lead_contact_tbl. Check x_return_status output to see if deletion was successful.
657 * @param p_api_version_number API version
658 * @param p_init_msg_list Initialize message list
659 * @param p_commit Commit after update
660 * @param p_validation_level Validation level for the record details
661 * @param p_check_access_flag Check access flag
662 * @param p_admin_flag Admin flag to denote admin responsibility
663 * @param p_admin_group_id Admin group id
664 * @param p_identity_salesforce_id Salesforce_id of the lead creator
665 * @param p_sales_lead_profile_tbl Table containing profile values for sales lead
666 * @param p_sales_lead_contact_tbl Table containing lead contact records
667 * @param x_sales_lead_cnt_out_tbl Generated Sales Lead Contacts Id
668 * @param x_return_status Return status of the delete operation
669 * @param x_msg_count Number of the error messages returned
670 * @param x_msg_data Error messages
671 * @rep:scope public
672 * @rep:lifecycle active
673 * @rep:displayname Delete Sales Lead Contacts
674 */
675 PROCEDURE Delete_sales_lead_contacts(
676 P_Api_Version_Number IN NUMBER,
677 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
678 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
679 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
680 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
681 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
683 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
684 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
685 P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_type,
686 X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,
687 X_Return_Status OUT NOCOPY VARCHAR2,
688 X_Msg_Count OUT NOCOPY NUMBER,
689 X_Msg_Data OUT NOCOPY VARCHAR2
690 );
691
692 -- Start Linking Sales Lead and Opportunity part
693 --
694 -- API Name: Get_Potential_Opportunity
695 --
696 -- 08/06/2002 SOLIN Comment out API Get_Potential_Opportunity because
697 -- it's moved to package AS_LINK_LEAD_OPP_PUB.
698 /*
699 PROCEDURE Get_Potential_Opportunity(
700 P_Api_Version_Number IN NUMBER,
701 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
702 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
703 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
704 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
705 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
706 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
707 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
708 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
709 P_SALES_LEAD_rec IN SALES_LEAD_rec_type,
710 X_Return_Status OUT NOCOPY VARCHAR2,
711 X_Msg_Count OUT NOCOPY NUMBER,
712 X_Msg_Data OUT NOCOPY VARCHAR2,
713 X_OPPORTUNITY_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE,
714 X_OPP_LINES_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.LINE_TBL_TYPE
715 );
716 */
717 --
718 -- API Name: Copy_Lead_To_Opportunity
719 --
720 /* API renamed by Francis on 06/26/2001 from Link_Lead_To_Opportunity to Copy_Lead_To_Opportunity */
721
722 PROCEDURE Copy_Lead_To_Opportunity(
723 P_Api_Version_Number IN NUMBER,
724 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
725 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
726 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
728 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
729 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
730 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
731 P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
732 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
733 P_SALES_LEAD_ID IN NUMBER,
734 P_SALES_LEAD_LINE_TBL IN SALES_LEAD_LINE_TBL_TYPE
735 := G_MISS_SALES_LEAD_LINE_TBL,
736 P_OPPORTUNITY_ID IN NUMBER,
737 X_Return_Status OUT NOCOPY VARCHAR2,
738 X_Msg_Count OUT NOCOPY NUMBER,
739 X_Msg_Data OUT NOCOPY VARCHAR2
740 );
741
742 --
743 -- API Name: Link_Lead_To_Opportunity
744 --
745 /* API added by Francis on 06/26/2001 */
746
747 PROCEDURE Link_Lead_To_Opportunity(
748 P_Api_Version_Number IN NUMBER,
749 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
750 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
751 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
752 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
753 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
754 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
755 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
756 P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
757 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
758 P_SALES_LEAD_ID IN NUMBER,
759 P_OPPORTUNITY_ID IN NUMBER,
760 X_Return_Status OUT NOCOPY VARCHAR2,
761 X_Msg_Count OUT NOCOPY NUMBER,
762 X_Msg_Data OUT NOCOPY VARCHAR2
763 );
764
765
766 --
767 -- API Name: Create_Opportunity_For_Lead
768 --
769 PROCEDURE Create_Opportunity_For_Lead(
770 P_Api_Version_Number IN NUMBER,
771 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
772 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
773 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
774 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
775 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
776 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
777 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
778 P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
779 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
780 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
781 P_SALES_LEAD_ID IN NUMBER,
782 P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
783 X_Return_Status OUT NOCOPY VARCHAR2,
784 X_Msg_Count OUT NOCOPY NUMBER,
785 X_Msg_Data OUT NOCOPY VARCHAR2,
786 X_OPPORTUNITY_ID OUT NOCOPY NUMBER
787 );
788
789 PROCEDURE Assign_Sales_Lead(
790 P_Api_Version_Number IN NUMBER,
791 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
792 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
793 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
794 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
795 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
796 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
797 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
798 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
799 P_Sales_Lead_Id IN NUMBER,
800 X_Return_Status OUT NOCOPY VARCHAR2,
801 X_Msg_Count OUT NOCOPY NUMBER,
802 X_Msg_Data OUT NOCOPY VARCHAR2,
803 X_Assign_Id_Tbl OUT NOCOPY Assign_Id_Tbl_Type
804 );
805
806 --
807 -- Get Access Profiles
808 --
809 -- This procedure gets profile values from profile table type
810 -- and output access profile record type.
811 --
812 -- This procedure is used by internal private APIs where input
813 -- parameter is profile table type and need to call check access
814 -- APIs.
815 --
816
817 PROCEDURE Get_Access_Profiles(
818 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
819 x_access_profile_rec OUT NOCOPY AS_ACCESS_PUB.Access_Profile_Rec_Type
820 );
821
822 --
823 -- Get Profile
824 --
825 -- This function gets profile values from the profile table type
826 -- and return the value for the input profile name.
827 --
828 -- If the profile name is not found in the profile table or
829 -- the profile value is NULL or FND_API.G_MISS_CHAR,
830 -- the function will return NULL
831 --
832 FUNCTION Get_Profile(
833 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
834 p_profile_name IN VARCHAR2 )
835 RETURN VARCHAR2;
836
837 PROCEDURE CALL_WF_TO_ASSIGN (
838 P_Api_Version_Number IN NUMBER,
839 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
840 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
841 P_Sales_Lead_Id IN NUMBER,
842 P_assigned_resource_id IN NUMBER DEFAULT NULL,
843 X_Return_Status OUT NOCOPY VARCHAR2,
844 X_Msg_Count OUT NOCOPY NUMBER,
845 X_Msg_Data OUT NOCOPY VARCHAR2
846 );
847
848 --
849 -- API Name: Build_Lead_Sales_Team
850 --
851 PROCEDURE Build_Lead_Sales_Team (
852 P_Api_Version_Number IN NUMBER,
853 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
854 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
855 p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
856 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
857 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
858 P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
859 P_Sales_Lead_Id IN NUMBER,
860 X_Return_Status OUT NOCOPY VARCHAR2,
861 X_Msg_Count OUT NOCOPY NUMBER,
862 X_Msg_Data OUT NOCOPY VARCHAR2
863 );
864
865 --
866 -- API Name: Rebuild_Lead_Sales_Team
867 --
868 PROCEDURE Rebuild_Lead_Sales_Team (
869 P_Api_Version_Number IN NUMBER,
870 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
871 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
872 p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
874 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
875 P_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
876 P_Sales_Lead_Id IN NUMBER,
877 X_Return_Status OUT NOCOPY VARCHAR2,
878 X_Msg_Count OUT NOCOPY NUMBER,
879 X_Msg_Data OUT NOCOPY VARCHAR2
880 );
881
882
883 --
884 -- API Name: Run_Lead_Engines
885 --
886 PROCEDURE Run_Lead_Engines (
887 P_Api_Version_Number IN NUMBER,
888 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
889 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
890 p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
891 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
892 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
893 P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
894 P_Sales_Lead_Id IN NUMBER,
895 X_Sales_Team_Flag OUT NOCOPY VARCHAR2,
896 X_Return_Status OUT NOCOPY VARCHAR2,
897 X_Msg_Count OUT NOCOPY NUMBER,
898 X_Msg_Data OUT NOCOPY VARCHAR2
899 );
900
901 --
902 -- API Name: Run_Lead_Engines
903 --
904
905 /*#
906 * This procedure runs lead engines. The engine will qualify, rate, and select a channel
907 * for the lead. Qualification, rating, and channel selection rules should be created prior
908 * to running lead engines.
909 * @param p_api_version_number API version
910 * @param p_init_msg_list Initialize message list
911 * @param p_commit Commit after update
912 * @param p_validation_level Validation level for the record details
913 * @param p_admin_group_id Admin group id
914 * @param p_identity_salesforce_id Salesforce_id of the lead creator
915 * @param p_salesgroup_id Sales Group Id of the lead creator
916 * @param p_sales_lead_id Sales Lead Id
917 * @param x_lead_engines_out_rec Outcome of the rules engine
918 * @param x_return_status Return status
919 * @param x_msg_count Number of the error messages returned
920 * @param x_msg_data Error messages
921 * @rep:scope public
922 * @rep:lifecycle active
923 * @rep:displayname Run Lead Rules Engine
924 */
925 PROCEDURE Run_Lead_Engines (
926 P_Api_Version_Number IN NUMBER,
927 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
928 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
929 p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
930 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
931 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
932 P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
933 P_Sales_Lead_Id IN NUMBER,
934 X_Lead_Engines_Out_Rec OUT NOCOPY LEAD_ENGINES_OUT_Rec_Type,
935 X_Return_Status OUT NOCOPY VARCHAR2,
936 X_Msg_Count OUT NOCOPY NUMBER,
937 X_Msg_Data OUT NOCOPY VARCHAR2
938 );
939
940 --
941 -- API Name: Start_Partner_Matching
942 --
943 PROCEDURE Start_Partner_Matching(
944 P_Api_Version_Number IN NUMBER,
945 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
946 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
947 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
948 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
949 P_Identity_Salesforce_Id IN NUMBER,
950 P_Salesgroup_Id IN NUMBER,
951 P_Lead_id IN NUMBER,
952 X_Return_Status OUT NOCOPY VARCHAR2,
953 X_Msg_Count OUT NOCOPY NUMBER,
954 X_Msg_Data OUT NOCOPY VARCHAR2
955 );
956
957 --
958 -- API Name: Route_Lead_To_Marketing
959 --
960 PROCEDURE Route_Lead_To_Marketing(
961 P_Api_Version_Number IN NUMBER,
962 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
963 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
964 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
965 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
966 P_Identity_Salesforce_Id IN NUMBER,
967 P_Sales_Lead_id IN NUMBER,
968 X_Return_Status OUT NOCOPY VARCHAR2,
969 X_Msg_Count OUT NOCOPY NUMBER,
970 X_Msg_Data OUT NOCOPY VARCHAR2
971 );
972
973 PROCEDURE Lead_Process_After_Create (
974 P_Api_Version_Number IN NUMBER,
975 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
976 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
977 p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
978 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
979 p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
980 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
981 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
982 P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
983 P_Sales_Lead_Id IN NUMBER,
984 X_Return_Status OUT NOCOPY VARCHAR2,
985 X_Msg_Count OUT NOCOPY NUMBER,
986 X_Msg_Data OUT NOCOPY VARCHAR2
987 );
988
989 PROCEDURE Lead_Process_After_Update (
990 P_Api_Version_Number IN NUMBER,
991 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
992 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
993 p_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
994 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
995 p_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
996 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
997 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
998 P_Salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
999 P_Sales_Lead_Id IN NUMBER,
1000 X_Return_Status OUT NOCOPY VARCHAR2,
1001 X_Msg_Count OUT NOCOPY NUMBER,
1002 X_Msg_Data OUT NOCOPY VARCHAR2
1003 );
1004
1005
1006 Filter_Exception EXCEPTION;
1007
1008 End AS_SALES_LEADS_PUB;