[Home] [Help]
PACKAGE BODY: APPS.AS_LEADS_PKG
Source
1 PACKAGE BODY AS_LEADS_PKG as
2 /* $Header: asxtldhb.pls 120.1 2005/07/22 02:26:41 appldev ship $ */
3 -- Start of Comments
4 -- Package name : AS_LEADS_PKG
5 -- Purpose :
6 -- History : 06/30/00 FFANG Modified.
7 -- 08/02/00 FFANG Use lead_id as lead_number when insert.
8 -- 01/15/01 FFANG For bug 1580045, instead of AS_LEADS,
9 -- use AS_LEADS_ALL.
10 -- 02/12/04 RKUMARES For Bug#3437528. Update_row of PRM_REFERRAL_CODE changed.
11 -- NOTE :
12 -- End of Comments
13
14
15 G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_LEADS_PKG';
16 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtldhb.pls';
17
18 PROCEDURE Insert_Row(
19 px_LEAD_ID IN OUT NOCOPY NUMBER,
20 p_LAST_UPDATE_DATE DATE,
21 p_LAST_UPDATED_BY NUMBER,
22 p_CREATION_DATE DATE,
23 p_CREATED_BY NUMBER,
24 p_LAST_UPDATE_LOGIN NUMBER,
25 p_REQUEST_ID NUMBER,
26 p_PROGRAM_APPLICATION_ID NUMBER,
27 p_PROGRAM_ID NUMBER,
28 p_PROGRAM_UPDATE_DATE DATE,
29 p_LEAD_NUMBER VARCHAR2,
30 p_STATUS VARCHAR2,
31 p_CUSTOMER_ID NUMBER,
32 p_ADDRESS_ID NUMBER,
33 p_SALES_STAGE_ID NUMBER,
34 p_INITIATING_CONTACT_ID NUMBER,
35 p_CHANNEL_CODE VARCHAR2,
36 p_TOTAL_AMOUNT NUMBER,
37 p_CURRENCY_CODE VARCHAR2,
38 p_DECISION_DATE DATE,
39 p_WIN_PROBABILITY NUMBER,
40 p_CLOSE_REASON VARCHAR2,
41 p_CLOSE_COMPETITOR_CODE VARCHAR2,
42 p_CLOSE_COMPETITOR VARCHAR2,
43 p_CLOSE_COMMENT VARCHAR2,
44 p_DESCRIPTION VARCHAR2,
45 p_RANK VARCHAR2,
46 p_SOURCE_PROMOTION_ID NUMBER,
47 p_END_USER_CUSTOMER_ID NUMBER,
48 p_END_USER_ADDRESS_ID NUMBER,
49 p_OWNER_SALESFORCE_ID NUMBER,
50 p_OWNER_SALES_GROUP_ID NUMBER,
51 --p_OWNER_ASSIGN_DATE DATE,
52 p_ORG_ID NUMBER,
53 p_NO_OPP_ALLOWED_FLAG VARCHAR2,
54 p_DELETE_ALLOWED_FLAG VARCHAR2,
55 p_ATTRIBUTE_CATEGORY VARCHAR2,
56 p_ATTRIBUTE1 VARCHAR2,
57 p_ATTRIBUTE2 VARCHAR2,
58 p_ATTRIBUTE3 VARCHAR2,
59 p_ATTRIBUTE4 VARCHAR2,
60 p_ATTRIBUTE5 VARCHAR2,
61 p_ATTRIBUTE6 VARCHAR2,
62 p_ATTRIBUTE7 VARCHAR2,
63 p_ATTRIBUTE8 VARCHAR2,
64 p_ATTRIBUTE9 VARCHAR2,
65 p_ATTRIBUTE10 VARCHAR2,
66 p_ATTRIBUTE11 VARCHAR2,
67 p_ATTRIBUTE12 VARCHAR2,
68 p_ATTRIBUTE13 VARCHAR2,
69 p_ATTRIBUTE14 VARCHAR2,
70 p_ATTRIBUTE15 VARCHAR2,
71 p_PARENT_PROJECT VARCHAR2,
72 p_LEAD_SOURCE_CODE VARCHAR2,
73 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
74 p_CLOSE_COMPETITOR_ID NUMBER,
75 p_END_USER_CUSTOMER_NAME VARCHAR2,
76 p_PRICE_LIST_ID NUMBER,
77 p_DELETED_FLAG VARCHAR2,
78 p_AUTO_ASSIGNMENT_TYPE VARCHAR2,
79 p_PRM_ASSIGNMENT_TYPE VARCHAR2,
80 p_CUSTOMER_BUDGET NUMBER,
81 p_METHODOLOGY_CODE VARCHAR2,
82 p_SALES_METHODOLOGY_ID NUMBER,
83 p_ORIGINAL_LEAD_ID NUMBER,
84 p_DECISION_TIMEFRAME_CODE VARCHAR2,
85 p_INC_PARTNER_RESOURCE_ID NUMBER,
86 p_INC_PARTNER_PARTY_ID NUMBER,
87 p_OFFER_ID NUMBER,
88 p_VEHICLE_RESPONSE_CODE VARCHAR2,
89 p_BUDGET_STATUS_CODE VARCHAR2,
90 p_FOLLOWUP_DATE DATE,
91 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
92 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
93 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
94 p_PRM_LEAD_TYPE VARCHAR2,
95 p_FREEZE_FLAG VARCHAR2,
96 p_PRM_REFERRAL_CODE VARCHAR2,
97 p_TOT_REVENUE_OPP_FORECAST_AMT NUMBER) -- Added for ASNB
98
99 IS
100 CURSOR C2 IS SELECT AS_LEADS_S.nextval FROM sys.dual;
101 BEGIN
102 If (px_LEAD_ID IS NULL) OR (px_LEAD_ID = FND_API.G_MISS_NUM) then
103 OPEN C2;
104 FETCH C2 INTO px_LEAD_ID;
105 CLOSE C2;
106 End If;
107 -- INSERT INTO AS_LEADS(
108 INSERT INTO AS_LEADS_ALL(
109 LEAD_ID,
110 LAST_UPDATE_DATE,
111 LAST_UPDATED_BY,
112 CREATION_DATE,
113 CREATED_BY,
114 LAST_UPDATE_LOGIN,
115 REQUEST_ID,
116 PROGRAM_APPLICATION_ID,
117 PROGRAM_ID,
118 PROGRAM_UPDATE_DATE,
119 LEAD_NUMBER,
120 STATUS,
121 CUSTOMER_ID,
122 ADDRESS_ID,
123 SALES_STAGE_ID,
124 INITIATING_CONTACT_ID,
125 CHANNEL_CODE,
126 TOTAL_AMOUNT,
127 CURRENCY_CODE,
128 DECISION_DATE,
129 WIN_PROBABILITY,
130 CLOSE_REASON,
131 CLOSE_COMPETITOR_CODE,
132 CLOSE_COMPETITOR,
133 CLOSE_COMMENT,
134 DESCRIPTION,
135 RANK,
136 SOURCE_PROMOTION_ID,
137 END_USER_CUSTOMER_ID,
138 END_USER_ADDRESS_ID,
139 OWNER_SALESFORCE_ID,
140 OWNER_SALES_GROUP_ID,
141 --OWNER_ASSIGN_DATE,
142 -- Added for MOAC
143 ORG_ID,
144 NO_OPP_ALLOWED_FLAG,
145 DELETE_ALLOWED_FLAG,
146 ATTRIBUTE_CATEGORY,
147 ATTRIBUTE1,
148 ATTRIBUTE2,
149 ATTRIBUTE3,
150 ATTRIBUTE4,
151 ATTRIBUTE5,
152 ATTRIBUTE6,
153 ATTRIBUTE7,
154 ATTRIBUTE8,
155 ATTRIBUTE9,
156 ATTRIBUTE10,
157 ATTRIBUTE11,
158 ATTRIBUTE12,
159 ATTRIBUTE13,
160 ATTRIBUTE14,
161 ATTRIBUTE15,
162 PARENT_PROJECT,
163 LEAD_SOURCE_CODE,
164 ORIG_SYSTEM_REFERENCE,
165 CLOSE_COMPETITOR_ID,
166 END_USER_CUSTOMER_NAME,
167 PRICE_LIST_ID,
168 DELETED_FLAG,
169 AUTO_ASSIGNMENT_TYPE,
170 PRM_ASSIGNMENT_TYPE,
171 CUSTOMER_BUDGET,
172 METHODOLOGY_CODE,
173 SALES_METHODOLOGY_ID,
174 ORIGINAL_LEAD_ID,
175 DECISION_TIMEFRAME_CODE,
176 INCUMBENT_PARTNER_RESOURCE_ID,
177 INCUMBENT_PARTNER_PARTY_ID,
178 OFFER_ID,
179 VEHICLE_RESPONSE_CODE,
180 BUDGET_STATUS_CODE,
181 FOLLOWUP_DATE,
182 PRM_EXEC_SPONSOR_FLAG,
183 PRM_PRJ_LEAD_IN_PLACE_FLAG,
184 PRM_IND_CLASSIFICATION_CODE,
185 PRM_LEAD_TYPE,
186 FREEZE_FLAG,
187 PRM_REFERRAL_CODE,
188 TOTAL_REVENUE_OPP_FORECAST_AMT
189 ) VALUES (
190 px_LEAD_ID,
191 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
192 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
196 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
193 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
194 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
195 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
197 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
198 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
199 decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
200 -- decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LEAD_NUMBER),
201 px_LEAD_ID,
202 decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
203 decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
204 decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
205 decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL, p_SALES_STAGE_ID),
206 decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_INITIATING_CONTACT_ID),
207 decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
208 decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TOTAL_AMOUNT),
209 decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
210 decode( p_DECISION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DECISION_DATE),
211 decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, NULL, p_WIN_PROBABILITY),
212 decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
213 decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR_CODE),
214 decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR),
215 decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMMENT),
216 decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
217 decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
218 decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROMOTION_ID),
219 decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_CUSTOMER_ID),
220 decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_ADDRESS_ID),
221 decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALESFORCE_ID),
222 decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALES_GROUP_ID),
223 --decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OWNER_ASSIGN_DATE),
224 decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),
225 decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_NO_OPP_ALLOWED_FLAG),
226 decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETE_ALLOWED_FLAG),
227 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
228 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
229 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
230 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
231 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
232 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
233 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
234 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
235 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
236 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
237 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
238 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
239 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
240 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
241 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
242 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
243 decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
244 decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_SOURCE_CODE),
245 decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_REFERENCE),
246 decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, NULL, p_CLOSE_COMPETITOR_ID),
247 decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, p_END_USER_CUSTOMER_NAME),
248 decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),
249 decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
250 decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_AUTO_ASSIGNMENT_TYPE),
251 decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_PRM_ASSIGNMENT_TYPE),
252 decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_BUDGET),
253 decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, NULL, p_METHODOLOGY_CODE),
254 decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID),
255 decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_LEAD_ID),
256 decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE),
257 decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_RESOURCE_ID),
258 decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_PARTY_ID),
259 decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
260 decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL, p_VEHICLE_RESPONSE_CODE),
261 decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_BUDGET_STATUS_CODE),
262 decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, NULL, p_FOLLOWUP_DATE),
263 decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_EXEC_SPONSOR_FLAG),
264 decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
265 decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_IND_CLASSIFICATION_CODE),
271
266 decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR,NULL, p_PRM_LEAD_TYPE),
267 decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FREEZE_FLAG),
268 decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_REFERRAL_CODE),
269 decode( p_TOT_REVENUE_OPP_FORECAST_AMT, FND_API.G_MISS_NUM, 0, p_TOT_REVENUE_OPP_FORECAST_AMT)); -- Added for ASNB
270 End Insert_Row;
272 PROCEDURE Update_Row(
273 p_LEAD_ID NUMBER,
274 p_LAST_UPDATE_DATE DATE,
275 p_LAST_UPDATED_BY NUMBER,
276 p_CREATION_DATE DATE,
277 p_CREATED_BY NUMBER,
278 p_LAST_UPDATE_LOGIN NUMBER,
279 p_REQUEST_ID NUMBER,
280 p_PROGRAM_APPLICATION_ID NUMBER,
281 p_PROGRAM_ID NUMBER,
282 p_PROGRAM_UPDATE_DATE DATE,
283 p_LEAD_NUMBER VARCHAR2,
284 p_STATUS VARCHAR2,
285 p_CUSTOMER_ID NUMBER,
286 p_ADDRESS_ID NUMBER,
287 p_SALES_STAGE_ID NUMBER,
288 p_INITIATING_CONTACT_ID NUMBER,
289 p_CHANNEL_CODE VARCHAR2,
290 p_TOTAL_AMOUNT NUMBER,
291 p_CURRENCY_CODE VARCHAR2,
292 p_DECISION_DATE DATE,
293 p_WIN_PROBABILITY NUMBER,
294 p_CLOSE_REASON VARCHAR2,
295 p_CLOSE_COMPETITOR_CODE VARCHAR2,
296 p_CLOSE_COMPETITOR VARCHAR2,
297 p_CLOSE_COMMENT VARCHAR2,
298 p_DESCRIPTION VARCHAR2,
299 p_RANK VARCHAR2,
300 p_SOURCE_PROMOTION_ID NUMBER,
301 p_END_USER_CUSTOMER_ID NUMBER,
302 p_END_USER_ADDRESS_ID NUMBER,
303 p_OWNER_SALESFORCE_ID NUMBER,
304 p_OWNER_SALES_GROUP_ID NUMBER,
305 --p_OWNER_ASSIGN_DATE DATE,
306 p_ORG_ID NUMBER,
307 p_NO_OPP_ALLOWED_FLAG VARCHAR2,
308 p_DELETE_ALLOWED_FLAG VARCHAR2,
309 p_ATTRIBUTE_CATEGORY VARCHAR2,
310 p_ATTRIBUTE1 VARCHAR2,
311 p_ATTRIBUTE2 VARCHAR2,
312 p_ATTRIBUTE3 VARCHAR2,
313 p_ATTRIBUTE4 VARCHAR2,
314 p_ATTRIBUTE5 VARCHAR2,
315 p_ATTRIBUTE6 VARCHAR2,
316 p_ATTRIBUTE7 VARCHAR2,
317 p_ATTRIBUTE8 VARCHAR2,
318 p_ATTRIBUTE9 VARCHAR2,
319 p_ATTRIBUTE10 VARCHAR2,
320 p_ATTRIBUTE11 VARCHAR2,
321 p_ATTRIBUTE12 VARCHAR2,
322 p_ATTRIBUTE13 VARCHAR2,
323 p_ATTRIBUTE14 VARCHAR2,
324 p_ATTRIBUTE15 VARCHAR2,
325 p_PARENT_PROJECT VARCHAR2,
326 p_LEAD_SOURCE_CODE VARCHAR2,
327 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
328 p_CLOSE_COMPETITOR_ID NUMBER,
329 p_END_USER_CUSTOMER_NAME VARCHAR2,
330 p_PRICE_LIST_ID NUMBER,
331 p_DELETED_FLAG VARCHAR2,
332 p_AUTO_ASSIGNMENT_TYPE VARCHAR2,
333 p_PRM_ASSIGNMENT_TYPE VARCHAR2,
334 p_CUSTOMER_BUDGET NUMBER,
335 p_METHODOLOGY_CODE VARCHAR2,
336 p_SALES_METHODOLOGY_ID NUMBER,
337 p_ORIGINAL_LEAD_ID NUMBER,
338 p_DECISION_TIMEFRAME_CODE VARCHAR2,
339 p_INC_PARTNER_RESOURCE_ID NUMBER,
340 p_INC_PARTNER_PARTY_ID NUMBER,
341 p_OFFER_ID NUMBER,
342 p_VEHICLE_RESPONSE_CODE VARCHAR2,
343 p_BUDGET_STATUS_CODE VARCHAR2,
344 p_FOLLOWUP_DATE DATE,
345 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
346 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
347 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
348 p_PRM_LEAD_TYPE VARCHAR2,
349 p_FREEZE_FLAG VARCHAR2,
350 p_PRM_REFERRAL_CODE VARCHAR2)
351
352 IS
353 BEGIN
354 -- Update AS_LEADS
355 Update AS_LEADS_ALL
356 SET object_version_number = nvl(object_version_number,0) + 1,
357 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
358 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
359 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
360 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
361 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
362 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
363 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
364 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
368 CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),
365 PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
366 LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER, p_LEAD_NUMBER),
367 STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
369 ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID, p_ADDRESS_ID),
370 SALES_STAGE_ID = decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, SALES_STAGE_ID, p_SALES_STAGE_ID),
371 INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, INITIATING_CONTACT_ID, p_INITIATING_CONTACT_ID),
372 CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, p_CHANNEL_CODE),
373 TOTAL_AMOUNT = decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, TOTAL_AMOUNT, p_TOTAL_AMOUNT),
374 CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
375 DECISION_DATE = decode( p_DECISION_DATE, FND_API.G_MISS_DATE, DECISION_DATE, p_DECISION_DATE),
376 WIN_PROBABILITY = decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, WIN_PROBABILITY, p_WIN_PROBABILITY),
377 CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, CLOSE_REASON, p_CLOSE_REASON),
378 CLOSE_COMPETITOR_CODE = decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR_CODE, p_CLOSE_COMPETITOR_CODE),
379 CLOSE_COMPETITOR = decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR, p_CLOSE_COMPETITOR),
380 CLOSE_COMMENT = decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, CLOSE_COMMENT, p_CLOSE_COMMENT),
381 DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
382 RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
383 SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID, p_SOURCE_PROMOTION_ID),
384 END_USER_CUSTOMER_ID = decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, END_USER_CUSTOMER_ID, p_END_USER_CUSTOMER_ID),
385 END_USER_ADDRESS_ID = decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, END_USER_ADDRESS_ID, p_END_USER_ADDRESS_ID),
389 --ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
386 OWNER_SALESFORCE_ID = decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, OWNER_SALESFORCE_ID, p_OWNER_SALESFORCE_ID),
387 OWNER_SALES_GROUP_ID = decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, OWNER_SALES_GROUP_ID , p_OWNER_SALES_GROUP_ID),
388 --OWNER_ASSIGN_DATE = decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, OWNER_ASSIGN_DATE, p_OWNER_ASSIGN_DATE),
390 NO_OPP_ALLOWED_FLAG = decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NO_OPP_ALLOWED_FLAG, p_NO_OPP_ALLOWED_FLAG),
391 DELETE_ALLOWED_FLAG = decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, DELETE_ALLOWED_FLAG, p_DELETE_ALLOWED_FLAG),
392 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
393 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
394 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
395 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
396 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
397 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
398 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
399 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
400 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
401 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
402 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
403 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
404 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
405 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
406 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
407 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
408 PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, PARENT_PROJECT, p_PARENT_PROJECT),
409 LEAD_SOURCE_CODE = decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, LEAD_SOURCE_CODE, p_LEAD_SOURCE_CODE),
410 ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, p_ORIG_SYSTEM_REFERENCE),
411 CLOSE_COMPETITOR_ID = decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, CLOSE_COMPETITOR_ID, p_CLOSE_COMPETITOR_ID),
412 END_USER_CUSTOMER_NAME = decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, END_USER_CUSTOMER_NAME, p_END_USER_CUSTOMER_NAME),
416 PRM_ASSIGNMENT_TYPE = decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, PRM_ASSIGNMENT_TYPE, p_PRM_ASSIGNMENT_TYPE),
413 PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),
414 DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, DELETED_FLAG, p_DELETED_FLAG),
415 AUTO_ASSIGNMENT_TYPE = decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, AUTO_ASSIGNMENT_TYPE, p_AUTO_ASSIGNMENT_TYPE),
417 CUSTOMER_BUDGET = decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, CUSTOMER_BUDGET, p_CUSTOMER_BUDGET),
418 METHODOLOGY_CODE = decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, METHODOLOGY_CODE, p_METHODOLOGY_CODE),
419 SALES_METHODOLOGY_ID = decode(p_SALES_METHODOLOGY_ID , FND_API.G_MISS_NUM, SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID),
420 ORIGINAL_LEAD_ID = decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, ORIGINAL_LEAD_ID, p_ORIGINAL_LEAD_ID),
421 DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE),
422 INCUMBENT_PARTNER_RESOURCE_ID = decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_RESOURCE_ID, p_INC_PARTNER_RESOURCE_ID),
423 INCUMBENT_PARTNER_PARTY_ID = decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_PARTY_ID, P_INC_PARTNER_PARTY_ID),
424 OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
425 VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),
426 BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
427 FOLLOWUP_DATE = decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, FOLLOWUP_DATE, p_FOLLOWUP_DATE),
428 PRM_EXEC_SPONSOR_FLAG = decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, PRM_EXEC_SPONSOR_FLAG, p_PRM_EXEC_SPONSOR_FLAG),
429 PRM_PRJ_LEAD_IN_PLACE_FLAG = decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, PRM_PRJ_LEAD_IN_PLACE_FLAG, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
430 PRM_IND_CLASSIFICATION_CODE = decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, PRM_IND_CLASSIFICATION_CODE, p_PRM_IND_CLASSIFICATION_CODE),
431 PRM_LEAD_TYPE = decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR, PRM_LEAD_TYPE, p_PRM_LEAD_TYPE),
432 FREEZE_FLAG = decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, FREEZE_FLAG, p_FREEZE_FLAG),
433 PRM_REFERRAL_CODE = decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, PRM_REFERRAL_CODE, p_PRM_REFERRAL_CODE)
434 where LEAD_ID = p_LEAD_ID;
435
436 If (SQL%NOTFOUND) then
437 RAISE NO_DATA_FOUND;
438 End If;
439 END Update_Row;
440
441 PROCEDURE Delete_Row(
442 p_LEAD_ID NUMBER)
443 IS
444 BEGIN
445 -- DELETE FROM AS_LEADS
446 DELETE FROM AS_LEADS_ALL
447 WHERE LEAD_ID = p_LEAD_ID;
448 If (SQL%NOTFOUND) then
449 RAISE NO_DATA_FOUND;
450 End If;
451 END Delete_Row;
452
453 PROCEDURE Lock_Row(
454 p_LEAD_ID NUMBER,
455 p_LAST_UPDATE_DATE DATE,
456 p_LAST_UPDATED_BY NUMBER,
457 p_CREATION_DATE DATE,
458 p_CREATED_BY NUMBER,
459 p_LAST_UPDATE_LOGIN NUMBER,
460 p_REQUEST_ID NUMBER,
461 p_PROGRAM_APPLICATION_ID NUMBER,
462 p_PROGRAM_ID NUMBER,
463 p_PROGRAM_UPDATE_DATE DATE,
464 p_LEAD_NUMBER VARCHAR2,
465 p_STATUS VARCHAR2,
466 p_CUSTOMER_ID NUMBER,
467 p_ADDRESS_ID NUMBER,
468 p_SALES_STAGE_ID NUMBER,
469 p_INITIATING_CONTACT_ID NUMBER,
470 p_CHANNEL_CODE VARCHAR2,
471 p_TOTAL_AMOUNT NUMBER,
472 p_CURRENCY_CODE VARCHAR2,
473 p_DECISION_DATE DATE,
474 p_WIN_PROBABILITY NUMBER,
475 p_CLOSE_REASON VARCHAR2,
476 p_CLOSE_COMPETITOR_CODE VARCHAR2,
477 p_CLOSE_COMPETITOR VARCHAR2,
478 p_CLOSE_COMMENT VARCHAR2,
482 p_END_USER_CUSTOMER_ID NUMBER,
479 p_DESCRIPTION VARCHAR2,
480 p_RANK VARCHAR2,
481 p_SOURCE_PROMOTION_ID NUMBER,
483 p_END_USER_ADDRESS_ID NUMBER,
484 p_OWNER_SALESFORCE_ID NUMBER,
485 p_OWNER_SALES_GROUP_ID NUMBER,
486 --p_OWNER_ASSIGN_DATE DATE,
487 p_ORG_ID NUMBER,
488 p_NO_OPP_ALLOWED_FLAG VARCHAR2,
489 p_DELETE_ALLOWED_FLAG VARCHAR2,
490 p_ATTRIBUTE_CATEGORY VARCHAR2,
491 p_ATTRIBUTE1 VARCHAR2,
492 p_ATTRIBUTE2 VARCHAR2,
493 p_ATTRIBUTE3 VARCHAR2,
494 p_ATTRIBUTE4 VARCHAR2,
495 p_ATTRIBUTE5 VARCHAR2,
496 p_ATTRIBUTE6 VARCHAR2,
497 p_ATTRIBUTE7 VARCHAR2,
501 p_ATTRIBUTE11 VARCHAR2,
498 p_ATTRIBUTE8 VARCHAR2,
499 p_ATTRIBUTE9 VARCHAR2,
500 p_ATTRIBUTE10 VARCHAR2,
502 p_ATTRIBUTE12 VARCHAR2,
503 p_ATTRIBUTE13 VARCHAR2,
504 p_ATTRIBUTE14 VARCHAR2,
505 p_ATTRIBUTE15 VARCHAR2,
506 p_PARENT_PROJECT VARCHAR2,
507 p_LEAD_SOURCE_CODE VARCHAR2,
508 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
509 p_CLOSE_COMPETITOR_ID NUMBER,
510 p_END_USER_CUSTOMER_NAME VARCHAR2,
511 p_PRICE_LIST_ID NUMBER,
512 p_DELETED_FLAG VARCHAR2,
513 p_AUTO_ASSIGNMENT_TYPE VARCHAR2,
514 p_PRM_ASSIGNMENT_TYPE VARCHAR2,
515 p_CUSTOMER_BUDGET NUMBER,
516 p_METHODOLOGY_CODE VARCHAR2,
517 p_SALES_METHODOLOGY_ID NUMBER,
518 p_ORIGINAL_LEAD_ID NUMBER,
519 p_DECISION_TIMEFRAME_CODE VARCHAR2,
520 p_INC_PARTNER_RESOURCE_ID NUMBER,
521 p_INC_PARTNER_PARTY_ID NUMBER,
522 p_OFFER_ID NUMBER,
523 p_VEHICLE_RESPONSE_CODE VARCHAR2,
524 p_BUDGET_STATUS_CODE VARCHAR2,
525 p_FOLLOWUP_DATE DATE,
526 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
527 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
528 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
529 p_PRM_LEAD_TYPE VARCHAR2,
530 p_FREEZE_FLAG VARCHAR2,
531 p_PRM_REFERRAL_CODE VARCHAR2)
532
533 IS
534 CURSOR C IS
535 SELECT *
536 -- FROM AS_LEADS
537 FROM AS_LEADS_ALL
538 WHERE LEAD_ID = p_LEAD_ID
539 FOR UPDATE of LEAD_ID NOWAIT;
540 Recinfo C%ROWTYPE;
541 BEGIN
542 OPEN C;
543 FETCH C INTO Recinfo;
544 If (C%NOTFOUND) then
545 CLOSE C;
546 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
547 APP_EXCEPTION.RAISE_EXCEPTION;
548 End If;
549 CLOSE C;
550 if (
551 ( Recinfo.LEAD_ID = p_LEAD_ID)
552 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
553 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
554 AND ( p_LAST_UPDATE_DATE IS NULL )))
555 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
556 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
557 AND ( p_LAST_UPDATED_BY IS NULL )))
558 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
559 OR ( ( Recinfo.CREATION_DATE IS NULL )
560 AND ( p_CREATION_DATE IS NULL )))
561 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
562 OR ( ( Recinfo.CREATED_BY IS NULL )
563 AND ( p_CREATED_BY IS NULL )))
564 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
565 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
566 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
567 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
568 OR ( ( Recinfo.REQUEST_ID IS NULL )
569 AND ( p_REQUEST_ID IS NULL )))
570 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
571 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
572 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
573 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
574 OR ( ( Recinfo.PROGRAM_ID IS NULL )
575 AND ( p_PROGRAM_ID IS NULL )))
576 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
577 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
578 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
579 AND ( ( Recinfo.LEAD_NUMBER = p_LEAD_NUMBER)
580 OR ( ( Recinfo.LEAD_NUMBER IS NULL )
581 AND ( p_LEAD_NUMBER IS NULL )))
582 AND ( ( Recinfo.STATUS = p_STATUS)
583 OR ( ( Recinfo.STATUS IS NULL )
584 AND ( p_STATUS IS NULL )))
585 AND ( ( Recinfo.CUSTOMER_ID = p_CUSTOMER_ID)
586 OR ( ( Recinfo.CUSTOMER_ID IS NULL )
587 AND ( p_CUSTOMER_ID IS NULL )))
588 AND ( ( Recinfo.ADDRESS_ID = p_ADDRESS_ID)
589 OR ( ( Recinfo.ADDRESS_ID IS NULL )
590 AND ( p_ADDRESS_ID IS NULL )))
591 AND ( ( Recinfo.SALES_STAGE_ID = p_SALES_STAGE_ID)
592 OR ( ( Recinfo.SALES_STAGE_ID IS NULL )
593 AND ( p_SALES_STAGE_ID IS NULL )))
594 AND ( ( Recinfo.INITIATING_CONTACT_ID = p_INITIATING_CONTACT_ID)
595 OR ( ( Recinfo.INITIATING_CONTACT_ID IS NULL )
596 AND ( p_INITIATING_CONTACT_ID IS NULL )))
597 AND ( ( Recinfo.CHANNEL_CODE = p_CHANNEL_CODE)
598 OR ( ( Recinfo.CHANNEL_CODE IS NULL )
599 AND ( p_CHANNEL_CODE IS NULL )))
600 AND ( ( Recinfo.TOTAL_AMOUNT = p_TOTAL_AMOUNT)
601 OR ( ( Recinfo.TOTAL_AMOUNT IS NULL )
602 AND ( p_TOTAL_AMOUNT IS NULL )))
603 AND ( ( Recinfo.CURRENCY_CODE = p_CURRENCY_CODE)
604 OR ( ( Recinfo.CURRENCY_CODE IS NULL )
605 AND ( p_CURRENCY_CODE IS NULL )))
606 AND ( ( Recinfo.DECISION_DATE = p_DECISION_DATE)
607 OR ( ( Recinfo.DECISION_DATE IS NULL )
608 AND ( p_DECISION_DATE IS NULL )))
609 AND ( ( Recinfo.WIN_PROBABILITY = p_WIN_PROBABILITY)
610 OR ( ( Recinfo.WIN_PROBABILITY IS NULL )
611 AND ( p_WIN_PROBABILITY IS NULL )))
612 AND ( ( Recinfo.CLOSE_REASON = p_CLOSE_REASON)
613 OR ( ( Recinfo.CLOSE_REASON IS NULL )
614 AND ( p_CLOSE_REASON IS NULL )))
615 AND ( ( Recinfo.CLOSE_COMPETITOR_CODE = p_CLOSE_COMPETITOR_CODE)
616 OR ( ( Recinfo.CLOSE_COMPETITOR_CODE IS NULL )
622 OR ( ( Recinfo.CLOSE_COMMENT IS NULL )
617 AND ( p_CLOSE_COMPETITOR_CODE IS NULL )))
618 AND ( ( Recinfo.CLOSE_COMPETITOR = p_CLOSE_COMPETITOR)
619 OR ( ( Recinfo.CLOSE_COMPETITOR IS NULL )
620 AND ( p_CLOSE_COMPETITOR IS NULL )))
621 AND ( ( Recinfo.CLOSE_COMMENT = p_CLOSE_COMMENT)
623 AND ( p_CLOSE_COMMENT IS NULL )))
624 AND ( ( Recinfo.DESCRIPTION = p_DESCRIPTION)
625 OR ( ( Recinfo.DESCRIPTION IS NULL )
626 AND ( p_DESCRIPTION IS NULL )))
627 AND ( ( Recinfo.RANK = p_RANK)
628 OR ( ( Recinfo.RANK IS NULL )
629 AND ( p_RANK IS NULL )))
630 AND ( ( Recinfo.SOURCE_PROMOTION_ID = p_SOURCE_PROMOTION_ID)
631 OR ( ( Recinfo.SOURCE_PROMOTION_ID IS NULL )
632 AND ( p_SOURCE_PROMOTION_ID IS NULL )))
633 AND ( ( Recinfo.END_USER_CUSTOMER_ID = p_END_USER_CUSTOMER_ID)
634 OR ( ( Recinfo.END_USER_CUSTOMER_ID IS NULL )
635 AND ( p_END_USER_CUSTOMER_ID IS NULL )))
636 AND ( ( Recinfo.END_USER_ADDRESS_ID = p_END_USER_ADDRESS_ID)
637 OR ( ( Recinfo.END_USER_ADDRESS_ID IS NULL )
638 AND ( p_END_USER_ADDRESS_ID IS NULL )))
639 AND ( ( Recinfo.OWNER_SALESFORCE_ID = p_OWNER_SALESFORCE_ID)
640 OR ( ( Recinfo.OWNER_SALESFORCE_ID IS NULL )
641 AND ( p_OWNER_SALESFORCE_ID IS NULL )))
642 AND ( ( Recinfo.OWNER_SALES_GROUP_ID = p_OWNER_SALES_GROUP_ID)
643 OR ( ( Recinfo.OWNER_SALES_GROUP_ID IS NULL )
644 AND ( p_OWNER_SALES_GROUP_ID IS NULL )))
645 --AND ( ( Recinfo.OWNER_ASSIGN_DATE = p_OWNER_ASSIGN_DATE)
646 --OR ( ( Recinfo.OWNER_ASSIGN_DATE IS NULL )
647 --AND ( p_OWNER_ASSIGN_DATE IS NULL )))
648 --AND ( ( Recinfo.ORG_ID = p_ORG_ID)
649 --OR ( ( Recinfo.ORG_ID IS NULL )
650 --AND ( p_ORG_ID IS NULL )))
651 AND ( ( Recinfo.NO_OPP_ALLOWED_FLAG = p_NO_OPP_ALLOWED_FLAG)
652 OR ( ( Recinfo.NO_OPP_ALLOWED_FLAG IS NULL )
653 AND ( p_NO_OPP_ALLOWED_FLAG IS NULL )))
654 AND ( ( Recinfo.DELETE_ALLOWED_FLAG = p_DELETE_ALLOWED_FLAG)
655 OR ( ( Recinfo.DELETE_ALLOWED_FLAG IS NULL )
656 AND ( p_DELETE_ALLOWED_FLAG IS NULL )))
657 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
658 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
659 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
660 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
661 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
662 AND ( p_ATTRIBUTE1 IS NULL )))
663 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
664 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
665 AND ( p_ATTRIBUTE2 IS NULL )))
666 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
667 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
668 AND ( p_ATTRIBUTE3 IS NULL )))
669 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
670 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
671 AND ( p_ATTRIBUTE4 IS NULL )))
672 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
673 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
674 AND ( p_ATTRIBUTE5 IS NULL )))
675 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
676 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
677 AND ( p_ATTRIBUTE6 IS NULL )))
678 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
679 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
680 AND ( p_ATTRIBUTE7 IS NULL )))
681 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
682 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
683 AND ( p_ATTRIBUTE8 IS NULL )))
684 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
685 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
686 AND ( p_ATTRIBUTE9 IS NULL )))
687 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
688 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
689 AND ( p_ATTRIBUTE10 IS NULL )))
690 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
691 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
692 AND ( p_ATTRIBUTE11 IS NULL )))
693 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
694 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
695 AND ( p_ATTRIBUTE12 IS NULL )))
696 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
697 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
701 AND ( p_ATTRIBUTE14 IS NULL )))
698 AND ( p_ATTRIBUTE13 IS NULL )))
699 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
700 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
702 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
703 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
704 AND ( p_ATTRIBUTE15 IS NULL )))
705 AND ( ( Recinfo.PARENT_PROJECT = p_PARENT_PROJECT)
706 OR ( ( Recinfo.PARENT_PROJECT IS NULL )
707 AND ( p_PARENT_PROJECT IS NULL )))
708 AND ( ( Recinfo.LEAD_SOURCE_CODE = p_LEAD_SOURCE_CODE)
709 OR ( ( Recinfo.LEAD_SOURCE_CODE IS NULL )
710 AND ( p_LEAD_SOURCE_CODE IS NULL )))
711 AND ( ( Recinfo.ORIG_SYSTEM_REFERENCE = p_ORIG_SYSTEM_REFERENCE)
712 OR ( ( Recinfo.ORIG_SYSTEM_REFERENCE IS NULL )
713 AND ( p_ORIG_SYSTEM_REFERENCE IS NULL )))
714 AND ( ( Recinfo.CLOSE_COMPETITOR_ID = p_CLOSE_COMPETITOR_ID)
715 OR ( ( Recinfo.CLOSE_COMPETITOR_ID IS NULL )
716 AND ( p_CLOSE_COMPETITOR_ID IS NULL )))
717 AND ( ( Recinfo.END_USER_CUSTOMER_NAME = p_END_USER_CUSTOMER_NAME)
718 OR ( ( Recinfo.END_USER_CUSTOMER_NAME IS NULL )
719 AND ( p_END_USER_CUSTOMER_NAME IS NULL )))
720 AND ( ( Recinfo.PRICE_LIST_ID = p_PRICE_LIST_ID)
721 OR ( ( Recinfo.PRICE_LIST_ID IS NULL )
722 AND ( p_PRICE_LIST_ID IS NULL )))
723 AND ( ( Recinfo.DELETED_FLAG = p_DELETED_FLAG)
724 OR ( ( Recinfo.DELETED_FLAG IS NULL )
725 AND ( p_DELETED_FLAG IS NULL )))
726 AND ( ( Recinfo.AUTO_ASSIGNMENT_TYPE = p_AUTO_ASSIGNMENT_TYPE)
727 OR ( ( Recinfo.AUTO_ASSIGNMENT_TYPE IS NULL )
728 AND ( p_AUTO_ASSIGNMENT_TYPE IS NULL )))
729 AND ( ( Recinfo.PRM_ASSIGNMENT_TYPE = p_PRM_ASSIGNMENT_TYPE)
730 OR ( ( Recinfo.PRM_ASSIGNMENT_TYPE IS NULL )
731 AND ( p_PRM_ASSIGNMENT_TYPE IS NULL )))
732 AND ( ( Recinfo.CUSTOMER_BUDGET = p_CUSTOMER_BUDGET)
733 OR ( ( Recinfo.CUSTOMER_BUDGET IS NULL )
734 AND ( p_CUSTOMER_BUDGET IS NULL )))
735 AND ( ( Recinfo.METHODOLOGY_CODE = p_METHODOLOGY_CODE)
739 OR ( ( Recinfo.SALES_METHODOLOGY_ID IS NULL )
736 OR ( ( Recinfo.METHODOLOGY_CODE IS NULL )
737 AND ( p_METHODOLOGY_CODE IS NULL )))
738 AND ( ( Recinfo.SALES_METHODOLOGY_ID = p_SALES_METHODOLOGY_ID)
740 AND ( p_SALES_METHODOLOGY_ID IS NULL )))
741 AND ( ( Recinfo.ORIGINAL_LEAD_ID = p_ORIGINAL_LEAD_ID)
742 OR ( ( Recinfo.ORIGINAL_LEAD_ID IS NULL )
743 AND ( p_ORIGINAL_LEAD_ID IS NULL )))
744 AND ( ( Recinfo.DECISION_TIMEFRAME_CODE = p_DECISION_TIMEFRAME_CODE)
745 OR ( ( Recinfo.DECISION_TIMEFRAME_CODE IS NULL )
746 AND ( p_DECISION_TIMEFRAME_CODE IS NULL )))
747 AND ( ( Recinfo.INCUMBENT_PARTNER_RESOURCE_ID = p_INC_PARTNER_RESOURCE_ID)
748 OR ( ( Recinfo.INCUMBENT_PARTNER_RESOURCE_ID IS NULL )
749 AND ( p_INC_PARTNER_RESOURCE_ID IS NULL )))
750 AND ( ( Recinfo.INCUMBENT_PARTNER_PARTY_ID = p_INC_PARTNER_PARTY_ID)
751 OR ( ( Recinfo.INCUMBENT_PARTNER_PARTY_ID IS NULL )
752 AND ( p_INC_PARTNER_PARTY_ID IS NULL )))
753 AND ( ( Recinfo.OFFER_ID = p_OFFER_ID)
754 OR ( ( Recinfo.OFFER_ID IS NULL )
755 AND ( p_OFFER_ID IS NULL )))
756 AND ( ( Recinfo.VEHICLE_RESPONSE_CODE = p_VEHICLE_RESPONSE_CODE)
757 OR ( ( Recinfo.VEHICLE_RESPONSE_CODE IS NULL )
758 AND ( p_VEHICLE_RESPONSE_CODE IS NULL )))
759 AND ( ( Recinfo.BUDGET_STATUS_CODE = p_BUDGET_STATUS_CODE)
760 OR ( ( Recinfo.BUDGET_STATUS_CODE IS NULL )
761 AND ( p_BUDGET_STATUS_CODE IS NULL )))
762 AND ( ( Recinfo.FOLLOWUP_DATE = p_FOLLOWUP_DATE)
763 OR ( ( Recinfo.FOLLOWUP_DATE IS NULL )
764 AND ( p_FOLLOWUP_DATE IS NULL )))
765 AND ( ( Recinfo.PRM_EXEC_SPONSOR_FLAG = p_PRM_EXEC_SPONSOR_FLAG)
766 OR ( ( Recinfo.PRM_EXEC_SPONSOR_FLAG IS NULL )
767 AND ( p_PRM_EXEC_SPONSOR_FLAG IS NULL )))
768 AND ( ( Recinfo.PRM_PRJ_LEAD_IN_PLACE_FLAG = p_PRM_PRJ_LEAD_IN_PLACE_FLAG)
769 OR ( ( Recinfo.PRM_PRJ_LEAD_IN_PLACE_FLAG IS NULL )
770 AND ( p_PRM_PRJ_LEAD_IN_PLACE_FLAG IS NULL )))
771 AND ( ( Recinfo.PRM_IND_CLASSIFICATION_CODE = p_PRM_IND_CLASSIFICATION_CODE)
772 OR ( ( Recinfo.PRM_IND_CLASSIFICATION_CODE IS NULL )
776 AND ( p_PRM_LEAD_TYPE IS NULL )))
773 AND ( p_PRM_IND_CLASSIFICATION_CODE IS NULL )))
774 AND ( ( Recinfo.PRM_LEAD_TYPE = p_PRM_LEAD_TYPE)
775 OR ( ( Recinfo.PRM_LEAD_TYPE IS NULL )
777 AND ( ( Recinfo.FREEZE_FLAG = p_FREEZE_FLAG)
778 OR ( ( Recinfo.FREEZE_FLAG IS NULL )
779 AND ( p_FREEZE_FLAG IS NULL )))
780 AND ( ( Recinfo.PRM_REFERRAL_CODE = p_PRM_REFERRAL_CODE)
781 OR ( ( Recinfo.PRM_REFERRAL_CODE IS NULL )
782 AND ( p_PRM_REFERRAL_CODE IS NULL )))
783 ) then
784 return;
785 else
786 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
787 APP_EXCEPTION.RAISE_EXCEPTION;
788 End If;
789 END Lock_Row;
790
791 End AS_LEADS_PKG;