[Home] [Help]
PACKAGE: APPS.AS_SALES_LEADS_PVT
Source
1 PACKAGE AS_SALES_LEADS_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvslms.pls 115.34 2003/01/23 02:38:36 chchandr ship $ */
3 -- Start of Comments
4 -- Package name : AS_SALES_LEADS_PVT
5 -- Purpose : Sales Leads Management
6 -- NOTE :
7 -- History :
8 -- 06/05/2000 FFANG Created.
9 -- 06/06/2000 FFANG Modified according data schema changes.
10 -- 11/06/2000 FFANG For bug 1423478, add procedure CALL_WF_TO_ASSIGN
11 -- 12/12/2000 FFANG For bug 1529886, add one parameter P_OPP_STATUS in
12 -- create_opportunity_for_lead to get opportunity status
13 -- when creating opportunity
14 -- End of Comments
15
16 -- Default number of records fetch per call
17
18 -- *************************
19 -- Validation Procedures
20 -- *************************
21
22 -- Item level validation procedures
23
24 /* Since this column is not required, this validation procedure
25 is not needed any more. ffang 05/15/00
26 PROCEDURE Validate_LEAD_NUMBER (
27 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
28 P_Validation_mode IN VARCHAR2,
29 P_LEAD_NUMBER IN VARCHAR2,
30 X_Return_Status OUT NOCOPY VARCHAR2,
31 X_Msg_Count OUT NOCOPY NUMBER,
32 X_Msg_Data OUT NOCOPY VARCHAR2
33 );
34 */
35
36 PROCEDURE Validate_SALES_LEAD_ID (
37 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
38 P_Validation_mode IN VARCHAR2,
39 P_Sales_Lead_Id IN NUMBER,
40 X_Return_Status OUT NOCOPY VARCHAR2,
41 X_Msg_Count OUT NOCOPY NUMBER,
42 X_Msg_Data OUT NOCOPY VARCHAR2
43 );
44
45 PROCEDURE Validate_CUSTOMER_ID (
46 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
47 P_Validation_mode IN VARCHAR2,
48 P_CUSTOMER_ID IN NUMBER,
49 X_Return_Status OUT NOCOPY VARCHAR2,
50 X_Msg_Count OUT NOCOPY NUMBER,
51 X_Msg_Data OUT NOCOPY VARCHAR2
52 );
53
54
55
56 PROCEDURE Validate_ADDRESS_ID (
57 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
58 P_Validation_mode IN VARCHAR2,
59 P_CUSTOMER_ID IN NUMBER,
60 P_ADDRESS_ID IN NUMBER,
61 X_Return_Status OUT NOCOPY VARCHAR2,
62 X_Msg_Count OUT NOCOPY NUMBER,
63 X_Msg_Data OUT NOCOPY VARCHAR2
64 );
65
66
67
68
69 PROCEDURE Validate_STATUS_CODE (
70 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
71 P_Validation_mode IN VARCHAR2,
72 P_STATUS_CODE IN VARCHAR2,
73 P_Sales_lead_id IN NUMBER,
74 X_Return_Status OUT NOCOPY VARCHAR2,
75 X_Msg_Count OUT NOCOPY NUMBER,
76 X_Msg_Data OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE Validate_SOURCE_PROMOTION_ID (
80 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
81 P_Validation_mode IN VARCHAR2,
82 P_SOURCE_PROMOTION_ID IN NUMBER,
83 X_Return_Status OUT NOCOPY VARCHAR2,
84 X_Msg_Count OUT NOCOPY NUMBER,
85 X_Msg_Data OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE Validate_CHANNEL_CODE (
89 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
90 P_Validation_mode IN VARCHAR2,
91 P_CHANNEL_CODE IN VARCHAR2,
92 X_Return_Status OUT NOCOPY VARCHAR2,
93 X_Msg_Count OUT NOCOPY NUMBER,
94 X_Msg_Data OUT NOCOPY VARCHAR2
95 );
96
97 PROCEDURE Validate_CURRENCY_CODE (
98 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
99 P_Validation_mode IN VARCHAR2,
100 P_CURRENCY_CODE IN VARCHAR2,
101 X_Return_Status OUT NOCOPY VARCHAR2,
102 X_Msg_Count OUT NOCOPY NUMBER,
103 X_Msg_Data OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE Validate_DECN_TIMEFRAME_CODE (
107 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
108 P_Validation_mode IN VARCHAR2,
109 P_DECISION_TIMEFRAME_CODE IN VARCHAR2,
110 X_Return_Status OUT NOCOPY VARCHAR2,
111 X_Msg_Count OUT NOCOPY NUMBER,
112 X_Msg_Data OUT NOCOPY VARCHAR2
113 );
114
115 PROCEDURE Validate_CLOSE_REASON (
116 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
117 P_Validation_mode IN VARCHAR2,
118 P_CLOSE_REASON IN VARCHAR2,
119 X_Return_Status OUT NOCOPY VARCHAR2,
120 X_Msg_Count OUT NOCOPY NUMBER,
121 X_Msg_Data OUT NOCOPY VARCHAR2
122 );
123
124 PROCEDURE Validate_LEAD_RANK_ID (
125 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
126 P_Validation_mode IN VARCHAR2,
127 P_LEAD_RANK_ID IN NUMBER,
128 X_Return_Status OUT NOCOPY VARCHAR2,
129 X_Msg_Count OUT NOCOPY NUMBER,
130 X_Msg_Data OUT NOCOPY VARCHAR2
131 );
132
133 PROCEDURE Validate_ASSIGN_TO_PERSON_ID (
134 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
135 P_Validation_mode IN VARCHAR2,
136 P_ASSIGN_TO_PERSON_ID IN NUMBER,
137 X_Return_Status OUT NOCOPY VARCHAR2,
138 X_Msg_Count OUT NOCOPY NUMBER,
139 X_Msg_Data OUT NOCOPY VARCHAR2
140 );
141
142 PROCEDURE Validate_ASSIGN_TO_SF_ID (
143 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
144 P_Validation_mode IN VARCHAR2,
145 P_ASSIGN_TO_SALESFORCE_ID IN NUMBER,
146 X_Return_Status OUT NOCOPY VARCHAR2,
147 X_Msg_Count OUT NOCOPY NUMBER,
148 X_Msg_Data OUT NOCOPY VARCHAR2
149 );
150
151 PROCEDURE Validate_BUDGET_STATUS_CODE (
152 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
153 P_Validation_mode IN VARCHAR2,
154 P_BUDGET_STATUS_CODE IN VARCHAR2,
155 X_Return_Status OUT NOCOPY VARCHAR2,
156 X_Msg_Count OUT NOCOPY NUMBER,
157 X_Msg_Data OUT NOCOPY VARCHAR2
158 );
159
160 PROCEDURE Validate_VEHICLE_RESPONSE_CODE (
161 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162 P_Validation_mode IN VARCHAR2,
163 P_VEHICLE_RESPONSE_CODE IN VARCHAR2,
164 X_Return_Status OUT NOCOPY VARCHAR2,
165 X_Msg_Count OUT NOCOPY NUMBER,
166 X_Msg_Data OUT NOCOPY VARCHAR2
167 );
168
169 PROCEDURE Validate_REJECT_REASON_CODE (
170 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
171 P_Validation_mode IN VARCHAR2,
172 P_REJECT_REASON_CODE IN VARCHAR2,
173 X_Return_Status OUT NOCOPY VARCHAR2,
174 X_Msg_Count OUT NOCOPY NUMBER,
175 X_Msg_Data OUT NOCOPY VARCHAR2
176 );
177
178 PROCEDURE Validate_Flags (
179 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
180 P_Validation_mode IN VARCHAR2,
181 P_Flag_Value IN VARCHAR2,
182 P_Flag_Type IN VARCHAR2,
183 X_Return_Status OUT NOCOPY VARCHAR2,
184 X_Msg_Count OUT NOCOPY NUMBER,
185 X_Msg_Data OUT NOCOPY VARCHAR2
186 );
187
188
189 PROCEDURE Validate_STATUS_CLOSE_REASON (
190 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
191 P_Validation_mode IN VARCHAR2,
192 P_STATUS_CODE IN VARCHAR2,
193 P_CLOSE_REASON_CODE IN OUT NOCOPY VARCHAR2,
194 X_Return_Status OUT NOCOPY VARCHAR2,
195 X_Msg_Count OUT NOCOPY NUMBER,
196 X_Msg_Data OUT NOCOPY VARCHAR2
197 );
198 /*
199 PROCEDURE Validate_REF_BY_REF_TYPE (
200 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
201 P_Validation_mode IN VARCHAR2,
202 P_REF_TYPE_CODE IN VARCHAR2,
203 P_REF_BY_ID IN NUMBER,
204 X_Return_Status OUT NOCOPY VARCHAR2,
205 X_Msg_Count OUT NOCOPY NUMBER,
206 X_Msg_Data OUT NOCOPY VARCHAR2
207 );
208 */
209
210
211 PROCEDURE Validate_OFFER_ID (
212 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
213 P_Validation_mode IN VARCHAR2,
214 P_SOURCE_PROMOTION_ID IN NUMBER,
215 P_OFFER_ID IN NUMBER,
216 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
217 X_Return_Status OUT NOCOPY VARCHAR2,
218 X_Msg_Count OUT NOCOPY NUMBER,
219 X_Msg_Data OUT NOCOPY VARCHAR2
220 );
221
222
223 PROCEDURE Validate_INC_PARTNER_PARTY_ID (
224 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225 P_Validation_mode IN VARCHAR2,
226 P_INC_PARTNER_PARTY_ID IN NUMBER,
227 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
228 X_Return_Status OUT NOCOPY VARCHAR2,
229 X_Msg_Count OUT NOCOPY NUMBER,
230 X_Msg_Data OUT NOCOPY VARCHAR2
231 );
232
233 PROCEDURE Validate_INC_PRTNR_RESOURCE_ID (
234 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
235 P_Validation_mode IN VARCHAR2,
236 P_INC_PARTNER_RESOURCE_ID IN NUMBER,
237 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
238 X_Return_Status OUT NOCOPY VARCHAR2,
239 X_Msg_Count OUT NOCOPY NUMBER,
240 X_Msg_Data OUT NOCOPY VARCHAR2
241 );
242
243 PROCEDURE Validate_PRM_EXEC_SPONSOR_FLAG (
244 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
245 P_Validation_mode IN VARCHAR2,
246 P_PRM_EXEC_SPONSOR_FLAG IN VARCHAR2,
247 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
248 X_Return_Status OUT NOCOPY VARCHAR2,
249 X_Msg_Count OUT NOCOPY NUMBER,
250 X_Msg_Data OUT NOCOPY VARCHAR2
251 );
252
253 PROCEDURE Validate_PRM_PRJ_LDINPLE_FLAG (
254 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
255 P_Validation_mode IN VARCHAR2,
256 P_PRM_PRJ_LEAD_IN_PLACE_FLAG IN VARCHAR2,
257 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
258 X_Return_Status OUT NOCOPY VARCHAR2,
259 X_Msg_Count OUT NOCOPY NUMBER,
260 X_Msg_Data OUT NOCOPY VARCHAR2
261 );
262
263 PROCEDURE Validate_PRM_LEAD_TYPE (
264 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
265 P_Validation_mode IN VARCHAR2,
266 P_PRM_LEAD_TYPE IN VARCHAR2,
267 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
268 X_Return_Status OUT NOCOPY VARCHAR2,
269 X_Msg_Count OUT NOCOPY NUMBER,
270 X_Msg_Data OUT NOCOPY VARCHAR2
271 );
272
273 PROCEDURE Validate_PRM_IND_CLS_CODE (
274 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
275 P_Validation_mode IN VARCHAR2,
276 P_PRM_IND_CLASSIFICATION_CODE IN VARCHAR2,
277 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
278 X_Return_Status OUT NOCOPY VARCHAR2,
279 X_Msg_Count OUT NOCOPY NUMBER,
280 X_Msg_Data OUT NOCOPY VARCHAR2
281 );
282
283 PROCEDURE Validate_PRM_ASSIGNMENT_TYPE (
284 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
285 P_Validation_mode IN VARCHAR2,
286 P_PRM_ASSIGNMENT_TYPE IN VARCHAR2,
287 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
288 X_Return_Status OUT NOCOPY VARCHAR2,
289 X_Msg_Count OUT NOCOPY NUMBER,
290 X_Msg_Data OUT NOCOPY VARCHAR2
291 );
292
293 PROCEDURE Validate_AUTO_ASSIGNMENT_TYPE (
294 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295 P_Validation_mode IN VARCHAR2,
296 P_AUTO_ASSIGNMENT_TYPE IN VARCHAR2,
297 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
298 X_Return_Status OUT NOCOPY VARCHAR2,
299 X_Msg_Count OUT NOCOPY NUMBER,
300 X_Msg_Data OUT NOCOPY VARCHAR2
301 );
302
303
304
305
306
307 -- Record level validation procedures
308
309
310 -- Inter-record level validation
311
312 PROCEDURE Validate_Budget_Amounts(
313 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
314 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315 P_Validation_mode IN VARCHAR2,
316 P_SALES_LEAD_ID IN NUMBER,
317 X_Return_Status OUT NOCOPY VARCHAR2,
318 X_Msg_Count OUT NOCOPY NUMBER,
319 X_Msg_Data OUT NOCOPY VARCHAR2
320 );
321
322
323 -- validation procedures
324
325 PROCEDURE Validate_sales_lead(
326 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
327 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
328 P_Validation_mode IN VARCHAR2,
329 P_SALES_LEAD_Rec IN OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,
330 P_Referral_type IN VARCHAR2,
331 P_Referred_By IN NUMBER,
332 X_Return_Status OUT NOCOPY VARCHAR2,
333 X_Msg_Count OUT NOCOPY NUMBER,
334 X_Msg_Data OUT NOCOPY VARCHAR2
335 );
336
337
338 -- **************************
339 -- Sales Lead Header APIs
340 -- **************************
341
342 -- API Name: Create_sales_lead
343
344 PROCEDURE Create_sales_lead(
345 P_Api_Version_Number IN NUMBER,
346 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
347 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
348 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
349 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
350 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
351 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
352 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
353 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
354 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
355 P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
356 := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
357 P_SALES_LEAD_LINE_tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_tbl_type
358 := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_tbl,
359 P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
360 := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
361 X_SALES_LEAD_ID OUT NOCOPY NUMBER,
362 X_SALES_LEAD_LINE_OUT_Tbl OUT
363 AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
367 X_Msg_Data OUT NOCOPY VARCHAR2
364 X_SALES_LEAD_CNT_OUT_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_tbl_Type,
365 X_Return_Status OUT NOCOPY VARCHAR2,
366 X_Msg_Count OUT NOCOPY NUMBER,
368 );
369
370
371 -- API Name: Update_sales_lead
372
373 PROCEDURE Update_sales_lead(
374 P_Api_Version_Number IN NUMBER,
375 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
376 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
377 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
378 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
379 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
380 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
381 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
382 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
383 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
384 P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,
385 -- P_Calling_From_WF_Flag IN VARCHAR2 := 'N',
386 X_Return_Status OUT NOCOPY VARCHAR2,
387 X_Msg_Count OUT NOCOPY NUMBER,
388 X_Msg_Data OUT NOCOPY VARCHAR2
389 );
390
391 /*
392 -- API Name: Delete_sales_lead
393
394 PROCEDURE Delete_sales_lead(
395 P_Api_Version_Number IN NUMBER,
396 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
397 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
398 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
400 P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
401 P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
402 P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
403 P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
404 := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
405 P_SALES_LEAD_ID IN NUMBER,
406 X_Return_Status OUT NOCOPY VARCHAR2,
407 X_Msg_Count OUT NOCOPY NUMBER,
408 X_Msg_Data OUT NOCOPY VARCHAR2
409 );
410 */
411
412 /*
413 This function is decomissioned
414
415 FUNCTION IS_LEAD_QUALIFIED(
416 P_Sales_lead_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
417 := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
418 P_phone_id IN NUMBER := FND_API.G_MISS_NUM,
419 P_contact_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
420 ) RETURN VARCHAR;
421 */
422
423 End AS_SALES_LEADS_PVT;