[Home] [Help]
PACKAGE BODY: APPS.AS_IMPORT_INTERFACE_PKG
Source
1 PACKAGE BODY AS_IMPORT_INTERFACE_PKG as
2 /* $Header: asxtlimb.pls 115.8 2004/01/19 11:30:22 rramakri ship $ */
3 -- Start of Comments
4 -- Package name : AS_IMPORT_INTERFACE_PKG
5 -- Purpose :
6 -- History : added 7 new columns manually
7 -- NOTE : Due to bug in JDBC, The G_MISS_DATE value
8 -- passed from UI is not matching with
9 -- FND_API.G_MISS_DATE. So after discussion
10 -- with Monica, Madhu and George and Shrinivas
11 -- in Update_Row , FND_API.G_MISS_DATE has
12 -- been replaced by rosetta like parameter.
13 -- Whenever the bug gets closed and ETF team
14 -- asks to regenerate the java wrapper, the
15 -- similar variable needs to be applied again.
16 -- End of Comments
17
18
19 G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_IMPORT_INTERFACE_PKG';
20 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtlimb.pls';
21
22 PROCEDURE Insert_Row(
23 px_IMPORT_INTERFACE_ID IN OUT NOCOPY NUMBER,
24 p_LAST_UPDATE_DATE DATE,
25 p_LAST_UPDATED_BY NUMBER,
26 p_CREATION_DATE DATE,
27 p_CREATED_BY NUMBER,
28 p_LAST_UPDATE_LOGIN NUMBER,
29 p_REQUEST_ID NUMBER,
30 p_PROGRAM_APPLICATION_ID NUMBER,
31 p_PROGRAM_ID NUMBER,
32 p_PROGRAM_UPDATE_DATE DATE,
33 p_IMP_LIST_HEADER_NUMBER VARCHAR2,
34 p_LOAD_TYPE VARCHAR2,
35 p_LOAD_DATE DATE,
36 p_LOAD_STATUS VARCHAR2,
37 p_LOAD_ERROR_MESSAGE VARCHAR2,
38 p_PROMOTION_ID NUMBER,
39 p_PROMOTION_CODE VARCHAR2,
40 p_CUSTOMER_ID NUMBER,
41 p_CUSTOMER_NAME VARCHAR2,
42 p_CUSTOMER_NUMBER VARCHAR2,
43 p_CUSTOMER_STATUS VARCHAR2,
44 p_CUSTOMER_TYPE VARCHAR2,
45 p_CUSTOMER_PROSPECT_CODE VARCHAR2,
46 p_CUSTOMER_CLASS_CODE VARCHAR2,
47 p_SALES_CHANNEL_CODE VARCHAR2,
48 p_SIC_CODE VARCHAR2,
49 p_ANALYSIS_FY VARCHAR2,
50 p_CUSTOMER_CATEGORY_CODE VARCHAR2,
51 p_CUSTOMER_GROUP_CODE VARCHAR2,
52 p_CUSTOMER_KEY VARCHAR2,
53 p_CUSTOMER_SUBGROUP_CODE VARCHAR2,
54 p_FISCAL_YEAREND_MONTH VARCHAR2,
55 p_NET_WORTH NUMBER,
56 p_NUM_OF_EMPLOYEES NUMBER,
57 p_POTENTIAL_REVENUE_CURR_FY NUMBER,
58 p_POTENTIAL_REVENUE_NEXT_FY NUMBER,
59 p_CUSTOMER_RANK VARCHAR2,
60 p_REFERENCE_USE_FLAG VARCHAR2,
61 p_TAX_CODE VARCHAR2,
62 p_TAX_REFERENCE VARCHAR2,
63 p_THIRD_PARTY_FLAG VARCHAR2,
64 p_COMPETITOR_FLAG VARCHAR2,
65 p_YEAR_ESTABLISHED NUMBER,
66 p_ADDR_DO_NOT_MAIL_FLAG VARCHAR2,
67 p_URL VARCHAR2,
68 p_ADDRESS_ID NUMBER,
69 p_CONT_DO_NOT_MAIL_FLAG VARCHAR2,
70 p_ADDRESS_STATUS VARCHAR2,
71 p_COUNTRY VARCHAR2,
72 p_ADDRESS1 VARCHAR2,
73 p_ADDRESS2 VARCHAR2,
74 p_ADDRESS3 VARCHAR2,
75 p_ADDRESS4 VARCHAR2,
76 p_CITY VARCHAR2,
77 p_POSTAL_CODE VARCHAR2,
78 p_STATE VARCHAR2,
79 p_PROVINCE VARCHAR2,
80 p_COUNTY VARCHAR2,
81 p_SITE_CONTACT_ID NUMBER,
82 p_EMAIL_ADDRESS VARCHAR2,
83 p_SEX_CODE VARCHAR2,
84 p_SALUTATION VARCHAR2,
85 p_LAST_NAME VARCHAR2,
86 p_TITLE VARCHAR2,
87 p_FIRST_NAME VARCHAR2,
88 p_JOB_TITLE VARCHAR2,
89 p_PHONE_ID NUMBER,
90 p_PHONE_NUMBER VARCHAR2,
91 p_PHONE_STATUS VARCHAR2,
92 p_PHONE_TYPE VARCHAR2,
93 p_AREA_CODE VARCHAR2,
94 p_EXTENSION VARCHAR2,
95 p_LEAD_NUMBER VARCHAR2,
96 p_STATUS_CODE VARCHAR2,
97 p_SOURCE_PROMOTION_ID NUMBER,
98 p_INITIATING_CONTACT_ID NUMBER,
99 p_CONTACT_ROLE_CODE VARCHAR2,
100 p_CHANNEL_CODE VARCHAR2,
101 p_BUDGET_AMOUNT NUMBER,
102 p_BUDGET_STATUS_CODE VARCHAR2,
103 p_CURRENCY_CODE VARCHAR2,
104 p_DECISION_TIMEFRAME_CODE VARCHAR2,
105 p_CLOSE_REASON VARCHAR2,
106 p_LEAD_RANK_CODE VARCHAR2,
107 p_PARENT_PROJECT VARCHAR2,
108 p_DESCRIPTION VARCHAR2,
109 p_STATUS_CODE_1 VARCHAR2,
110 p_INTEREST_TYPE_ID_1 NUMBER,
111 p_PRIMARY_INTEREST_CODE_ID_1 NUMBER,
112 p_SECONDARY_INTEREST_CODE_ID_1 NUMBER,
113 p_INVENTORY_ITEM_ID_1 NUMBER,
114 p_ORGANIZATION_ID_1 NUMBER,
115 p_UOM_CODE_1 VARCHAR2,
116 p_QUANTITY_1 NUMBER,
117 p_BUDGET_AMOUNT_1 NUMBER,
118 p_STATUS_CODE_2 VARCHAR2,
119 p_INTEREST_TYPE_ID_2 NUMBER,
120 p_PRIMARY_INTEREST_CODE_ID_2 NUMBER,
121 p_SECONDARY_INTEREST_CODE_ID_2 NUMBER,
122 p_INVENTORY_ITEM_ID_2 NUMBER,
123 p_ORGANIZATION_ID_2 NUMBER,
124 p_UOM_CODE_2 VARCHAR2,
125 p_QUANTITY_2 NUMBER,
126 p_BUDGET_AMOUNT_2 NUMBER,
127 p_STATUS_CODE_3 VARCHAR2,
128 p_INTEREST_TYPE_ID_3 NUMBER,
129 p_PRIMARY_INTEREST_CODE_ID_3 NUMBER,
130 p_SECONDARY_INTEREST_CODE_ID_3 NUMBER,
131 p_INVENTORY_ITEM_ID_3 NUMBER,
132 p_ORGANIZATION_ID_3 NUMBER,
133 p_UOM_CODE_3 VARCHAR2,
134 p_QUANTITY_3 NUMBER,
135 p_BUDGET_AMOUNT_3 NUMBER,
136 p_STATUS_CODE_4 VARCHAR2,
137 p_INTEREST_TYPE_ID_4 NUMBER,
138 p_PRIMARY_INTEREST_CODE_ID_4 NUMBER,
139 p_SECONDARY_INTEREST_CODE_ID_4 NUMBER,
140 p_INVENTORY_ITEM_ID_4 NUMBER,
141 p_ORGANIZATION_ID_4 NUMBER,
142 p_UOM_CODE_4 VARCHAR2,
143 p_QUANTITY_4 NUMBER,
144 p_BUDGET_AMOUNT_4 NUMBER,
145 p_STATUS_CODE_5 VARCHAR2,
146 p_INTEREST_TYPE_ID_5 NUMBER,
147 p_PRIMARY_INTEREST_CODE_ID_5 NUMBER,
148 p_SECONDARY_INTEREST_CODE_ID_5 NUMBER,
149 p_INVENTORY_ITEM_ID_5 NUMBER,
150 p_ORGANIZATION_ID_5 NUMBER,
151 p_UOM_CODE_5 VARCHAR2,
152 p_QUANTITY_5 NUMBER,
153 p_BUDGET_AMOUNT_5 NUMBER,
154 p_INTERACTION_NOTES_1 VARCHAR2,
155 p_PRIORITY_1 NUMBER,
156 p_TODO_DATE_1 DATE,
157 p_TODO_START_TIME_1 VARCHAR2,
158 p_ACTIVITY_CODE_1 VARCHAR2,
159 p_INTERACTION_NOTES_2 VARCHAR2,
160 p_PRIORITY_2 NUMBER,
161 p_TODO_DATE_2 DATE,
162 p_TODO_START_TIME_2 VARCHAR2,
163 p_ACTIVITY_CODE_2 VARCHAR2,
164 p_INTERACTION_NOTES_3 VARCHAR2,
165 p_PRIORITY_3 NUMBER,
166 p_TODO_DATE_3 DATE,
167 p_TODO_START_TIME_3 VARCHAR2,
168 p_ACTIVITY_CODE_3 VARCHAR2,
169 p_INTERACTION_NOTES_4 VARCHAR2,
170 p_PRIORITY_4 NUMBER,
171 p_TODO_DATE_4 DATE,
172 p_TODO_START_TIME_4 VARCHAR2,
173 p_ACTIVITY_CODE_4 VARCHAR2,
174 p_INTERACTION_NOTES_5 VARCHAR2,
175 p_PRIORITY_5 NUMBER,
176 p_TODO_DATE_5 DATE,
177 p_TODO_START_TIME_5 VARCHAR2,
178 p_ACTIVITY_CODE_5 VARCHAR2,
179 p_INTERACTION_NOTES_6 VARCHAR2,
180 p_PRIORITY_6 NUMBER,
181 p_TODO_DATE_6 DATE,
182 p_TODO_START_TIME_6 VARCHAR2,
183 p_ACTIVITY_CODE_6 VARCHAR2,
184 p_INTERACTION_NOTES_7 VARCHAR2,
185 p_PRIORITY_7 NUMBER,
186 p_TODO_DATE_7 DATE,
187 p_TODO_START_TIME_7 VARCHAR2,
188 p_ACTIVITY_CODE_7 VARCHAR2,
189 p_INTERACTION_NOTES_8 VARCHAR2,
190 p_PRIORITY_8 NUMBER,
191 p_TODO_DATE_8 DATE,
192 p_TODO_START_TIME_8 VARCHAR2,
193 p_ACTIVITY_CODE_8 VARCHAR2,
194 p_INTERACTION_NOTES_9 VARCHAR2,
195 p_PRIORITY_9 NUMBER,
196 p_TODO_DATE_9 DATE,
197 p_TODO_START_TIME_9 VARCHAR2,
198 p_ACTIVITY_CODE_9 VARCHAR2,
199 p_INTERACTION_NOTES_10 VARCHAR2,
200 p_PRIORITY_10 NUMBER,
201 p_TODO_DATE_10 DATE,
202 p_TODO_START_TIME_10 VARCHAR2,
203 p_ACTIVITY_CODE_10 VARCHAR2,
204 p_LEAD_NOTE VARCHAR2,
205 p_MIDDLE_INITIAL VARCHAR2,
206 p_FAX_NUMBER VARCHAR2,
207 p_FAX_AREA_CODE VARCHAR2,
208 p_MAIL_STOP VARCHAR2,
209 p_NUM_ENROLLED NUMBER,
210 p_CONFIRMED_FLAG VARCHAR2,
211 p_PAYMENT_AMOUNT NUMBER,
212 p_NUM_ATTENDED NUMBER,
213 p_PROMOTION_NAME VARCHAR2,
214 p_STATUS_CHANGE_FLAG VARCHAR2,
215 p_VEHICLE_RESPONSE_CODE VARCHAR2,
216 p_SOURCE_SYSTEM VARCHAR2,
217 p_CONTACT_PARTY_ID NUMBER,
218 p_PRM_SALES_LEAD_TYPE VARCHAR2,
219 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
220 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
221 p_INC_PARTNER_PARTY_ID NUMBER,
222 p_INC_PARTNER_RESOURCE_ID NUMBER,
223 p_OFFER_ID NUMBER,
224 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
225 p_PARTY_TYPE VARCHAR2,
226 p_BATCH_ID NUMBER,
227 p_PARTY_ID NUMBER,
228 p_PARTY_SITE_ID NUMBER,
229 p_LOCATION_ID NUMBER,
230 p_REL_PARTY_ID NUMBER,
231 p_SALES_LEAD_ID NUMBER,
232 p_ADDRESS_KEY VARCHAR2,
233 p_CONTACT_KEY VARCHAR2,
234 p_JOB_TITLE_CODE VARCHAR2,
235 p_DO_NOT_PHONE_FLAG VARCHAR2,
236 p_DO_NOT_FAX_FLAG VARCHAR2,
237 p_DO_NOT_EMAIL_FLAG VARCHAR2,
238 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
239 p_LEAD_RANK_ID NUMBER,
240 p_NEW_PARTY_FLAG NUMBER,
241 p_NEW_LOC_FLAG NUMBER,
242 p_NEW_PS_FLAG NUMBER,
243 p_NEW_REL_FLAG NUMBER,
244 p_NEW_CON_FLAG NUMBER,
245 p_ORIG_SYSTEM_CODE VARCHAR2,
246 p_URGENT_FLAG VARCHAR2,
247 p_SIC_CODE_TYPE VARCHAR2,
248 p_SITE_USE_TYPE VARCHAR2,
249 p_PRIMARY_CONTACT_FLAG VARCHAR2,
250 p_RANK VARCHAR2,
251 p_ADDRESS_STYLE VARCHAR2,
252 p_PRIMARY_PER_TYPE VARCHAR2,
253 p_DEPARTMENT_CODE VARCHAR2)
254
255 IS
256 CURSOR C2 IS SELECT AS_IMPORT_INTERFACE_S.nextval FROM sys.dual;
257 BEGIN
258 If (px_IMPORT_INTERFACE_ID IS NULL) OR (px_IMPORT_INTERFACE_ID = FND_API.G_MISS_NUM) then
259 OPEN C2;
260 FETCH C2 INTO px_IMPORT_INTERFACE_ID;
261 CLOSE C2;
262 End If;
263 INSERT INTO AS_IMPORT_INTERFACE(
264 IMPORT_INTERFACE_ID,
265 LAST_UPDATE_DATE,
266 LAST_UPDATED_BY,
267 CREATION_DATE,
268 CREATED_BY,
269 LAST_UPDATE_LOGIN,
270 REQUEST_ID,
271 PROGRAM_APPLICATION_ID,
272 PROGRAM_ID,
273 PROGRAM_UPDATE_DATE,
274 IMP_LIST_HEADER_NUMBER,
275 LOAD_TYPE,
276 LOAD_DATE,
277 LOAD_STATUS,
278 LOAD_ERROR_MESSAGE,
279 PROMOTION_ID,
280 PROMOTION_CODE,
281 CUSTOMER_ID,
282 CUSTOMER_NAME,
283 CUSTOMER_NUMBER,
284 CUSTOMER_STATUS,
285 CUSTOMER_TYPE,
286 CUSTOMER_PROSPECT_CODE,
287 CUSTOMER_CLASS_CODE,
288 SALES_CHANNEL_CODE,
289 SIC_CODE,
290 ANALYSIS_FY,
291 CUSTOMER_CATEGORY_CODE,
292 CUSTOMER_GROUP_CODE,
293 CUSTOMER_KEY,
294 CUSTOMER_SUBGROUP_CODE,
295 FISCAL_YEAREND_MONTH,
296 NET_WORTH,
297 NUM_OF_EMPLOYEES,
298 POTENTIAL_REVENUE_CURR_FY,
299 POTENTIAL_REVENUE_NEXT_FY,
300 CUSTOMER_RANK,
301 REFERENCE_USE_FLAG,
302 TAX_CODE,
303 TAX_REFERENCE,
304 THIRD_PARTY_FLAG,
305 COMPETITOR_FLAG,
306 YEAR_ESTABLISHED,
307 ADDR_DO_NOT_MAIL_FLAG,
308 URL,
309 ADDRESS_ID,
310 CONT_DO_NOT_MAIL_FLAG,
311 ADDRESS_STATUS,
312 COUNTRY,
313 ADDRESS1,
314 ADDRESS2,
315 ADDRESS3,
316 ADDRESS4,
317 CITY,
318 POSTAL_CODE,
319 STATE,
320 PROVINCE,
321 COUNTY,
322 SITE_CONTACT_ID,
323 EMAIL_ADDRESS,
324 SEX_CODE,
325 SALUTATION,
326 LAST_NAME,
327 TITLE,
328 FIRST_NAME,
329 JOB_TITLE,
330 PHONE_ID,
331 PHONE_NUMBER,
332 PHONE_STATUS,
333 PHONE_TYPE,
334 AREA_CODE,
335 EXTENSION,
336 LEAD_NUMBER,
337 STATUS_CODE,
338 SOURCE_PROMOTION_ID,
339 INITIATING_CONTACT_ID,
340 CONTACT_ROLE_CODE,
341 CHANNEL_CODE,
342 BUDGET_AMOUNT,
343 BUDGET_STATUS_CODE,
344 CURRENCY_CODE,
345 DECISION_TIMEFRAME_CODE,
346 CLOSE_REASON,
347 LEAD_RANK_CODE,
348 PARENT_PROJECT,
349 DESCRIPTION,
350 STATUS_CODE_1,
351 INTEREST_TYPE_ID_1,
352 PRIMARY_INTEREST_CODE_ID_1,
353 SECONDARY_INTEREST_CODE_ID_1,
354 INVENTORY_ITEM_ID_1,
355 ORGANIZATION_ID_1,
356 UOM_CODE_1,
357 QUANTITY_1,
358 BUDGET_AMOUNT_1,
359 STATUS_CODE_2,
363 INVENTORY_ITEM_ID_2,
360 INTEREST_TYPE_ID_2,
361 PRIMARY_INTEREST_CODE_ID_2,
362 SECONDARY_INTEREST_CODE_ID_2,
364 ORGANIZATION_ID_2,
365 UOM_CODE_2,
366 QUANTITY_2,
367 BUDGET_AMOUNT_2,
368 STATUS_CODE_3,
369 INTEREST_TYPE_ID_3,
370 PRIMARY_INTEREST_CODE_ID_3,
371 SECONDARY_INTEREST_CODE_ID_3,
372 INVENTORY_ITEM_ID_3,
373 ORGANIZATION_ID_3,
374 UOM_CODE_3,
375 QUANTITY_3,
376 BUDGET_AMOUNT_3,
377 STATUS_CODE_4,
378 INTEREST_TYPE_ID_4,
379 PRIMARY_INTEREST_CODE_ID_4,
380 SECONDARY_INTEREST_CODE_ID_4,
381 INVENTORY_ITEM_ID_4,
382 ORGANIZATION_ID_4,
383 UOM_CODE_4,
384 QUANTITY_4,
385 BUDGET_AMOUNT_4,
386 STATUS_CODE_5,
387 INTEREST_TYPE_ID_5,
388 PRIMARY_INTEREST_CODE_ID_5,
389 SECONDARY_INTEREST_CODE_ID_5,
390 INVENTORY_ITEM_ID_5,
391 ORGANIZATION_ID_5,
392 UOM_CODE_5,
393 QUANTITY_5,
394 BUDGET_AMOUNT_5,
395 INTERACTION_NOTES_1,
396 PRIORITY_1,
397 TODO_DATE_1,
398 TODO_START_TIME_1,
399 ACTIVITY_CODE_1,
400 INTERACTION_NOTES_2,
401 PRIORITY_2,
402 TODO_DATE_2,
403 TODO_START_TIME_2,
404 ACTIVITY_CODE_2,
405 INTERACTION_NOTES_3,
406 PRIORITY_3,
407 TODO_DATE_3,
408 TODO_START_TIME_3,
409 ACTIVITY_CODE_3,
410 INTERACTION_NOTES_4,
411 PRIORITY_4,
412 TODO_DATE_4,
413 TODO_START_TIME_4,
414 ACTIVITY_CODE_4,
415 INTERACTION_NOTES_5,
416 PRIORITY_5,
417 TODO_DATE_5,
418 TODO_START_TIME_5,
419 ACTIVITY_CODE_5,
420 INTERACTION_NOTES_6,
421 PRIORITY_6,
422 TODO_DATE_6,
423 TODO_START_TIME_6,
424 ACTIVITY_CODE_6,
425 INTERACTION_NOTES_7,
426 PRIORITY_7,
427 TODO_DATE_7,
428 TODO_START_TIME_7,
429 ACTIVITY_CODE_7,
430 INTERACTION_NOTES_8,
431 PRIORITY_8,
432 TODO_DATE_8,
433 TODO_START_TIME_8,
434 ACTIVITY_CODE_8,
435 INTERACTION_NOTES_9,
436 PRIORITY_9,
437 TODO_DATE_9,
438 TODO_START_TIME_9,
439 ACTIVITY_CODE_9,
440 INTERACTION_NOTES_10,
441 PRIORITY_10,
442 TODO_DATE_10,
443 TODO_START_TIME_10,
444 ACTIVITY_CODE_10,
445 LEAD_NOTE,
446 MIDDLE_INITIAL,
447 FAX_NUMBER,
448 FAX_AREA_CODE,
449 MAIL_STOP,
450 NUM_ENROLLED,
451 CONFIRMED_FLAG,
452 PAYMENT_AMOUNT,
453 NUM_ATTENDED,
454 PROMOTION_NAME,
455 STATUS_CHANGE_FLAG,
456 VEHICLE_RESPONSE_CODE,
457 SOURCE_SYSTEM,
458 CONTACT_PARTY_ID,
459 PRM_SALES_LEAD_TYPE,
460 PRM_EXEC_SPONSOR_FLAG,
461 PRM_PRJ_LEAD_IN_PLACE_FLAG,
462 INCUMBENT_PARTNER_PARTY_ID,
463 INCUMBENT_PARTNER_RESOURCE_ID,
464 OFFER_ID,
465 PRM_IND_CLASSIFICATION_CODE,
466 PARTY_TYPE,
467 BATCH_ID,
468 PARTY_ID,
469 PARTY_SITE_ID,
470 LOCATION_ID,
471 REL_PARTY_ID,
472 SALES_LEAD_ID,
473 ADDRESS_KEY,
474 CONTACT_KEY,
475 JOB_TITLE_CODE,
476 DO_NOT_PHONE_FLAG,
477 DO_NOT_FAX_FLAG,
478 DO_NOT_EMAIL_FLAG,
479 ORIG_SYSTEM_REFERENCE,
480 LEAD_RANK_ID,
481 NEW_PARTY_FLAG,
482 NEW_LOC_FLAG,
483 NEW_PS_FLAG,
484 NEW_REL_FLAG,
485 NEW_CON_FLAG,
486 ORIG_SYSTEM_CODE,
487 URGENT_FLAG
488 ) VALUES (
489 px_IMPORT_INTERFACE_ID,
490 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
491 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
492 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
493 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
494 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
495 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
496 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
497 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
498 decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
499 decode( p_IMP_LIST_HEADER_NUMBER, FND_API.G_MISS_CHAR, NULL, p_IMP_LIST_HEADER_NUMBER),
500 decode( p_LOAD_TYPE, FND_API.G_MISS_CHAR, NULL, p_LOAD_TYPE),
501 decode( p_LOAD_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LOAD_DATE),
502 decode( p_LOAD_STATUS, FND_API.G_MISS_CHAR, NULL, p_LOAD_STATUS),
503 decode( p_LOAD_ERROR_MESSAGE, FND_API.G_MISS_CHAR, NULL, p_LOAD_ERROR_MESSAGE),
507 decode( p_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_NAME),
504 decode( p_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_PROMOTION_ID),
505 decode( p_PROMOTION_CODE, FND_API.G_MISS_CHAR, NULL, p_PROMOTION_CODE),
506 decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
508 decode( p_CUSTOMER_NUMBER, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_NUMBER),
509 decode( p_CUSTOMER_STATUS, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_STATUS),
510 decode( p_CUSTOMER_TYPE, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_TYPE),
511 decode( p_CUSTOMER_PROSPECT_CODE, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_PROSPECT_CODE),
512 decode( p_CUSTOMER_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_CLASS_CODE),
513 decode( p_SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CHANNEL_CODE),
514 decode( p_SIC_CODE, FND_API.G_MISS_CHAR, NULL, p_SIC_CODE),
515 decode( p_ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, p_ANALYSIS_FY),
516 decode( p_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_CATEGORY_CODE),
517 decode( p_CUSTOMER_GROUP_CODE, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_GROUP_CODE),
518 decode( p_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_KEY),
519 decode( p_CUSTOMER_SUBGROUP_CODE, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_SUBGROUP_CODE),
520 decode( p_FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, p_FISCAL_YEAREND_MONTH),
521 decode( p_NET_WORTH, FND_API.G_MISS_NUM, NULL, p_NET_WORTH),
522 decode( p_NUM_OF_EMPLOYEES, FND_API.G_MISS_NUM, NULL, p_NUM_OF_EMPLOYEES),
523 decode( p_POTENTIAL_REVENUE_CURR_FY, FND_API.G_MISS_NUM, NULL, p_POTENTIAL_REVENUE_CURR_FY),
524 decode( p_POTENTIAL_REVENUE_NEXT_FY, FND_API.G_MISS_NUM, NULL, p_POTENTIAL_REVENUE_NEXT_FY),
525 decode( p_CUSTOMER_RANK, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_RANK),
526 decode( p_REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, NULL, p_REFERENCE_USE_FLAG),
527 decode( p_TAX_CODE, FND_API.G_MISS_CHAR, NULL, p_TAX_CODE),
528 decode( p_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_TAX_REFERENCE),
529 decode( p_THIRD_PARTY_FLAG, FND_API.G_MISS_CHAR, NULL, p_THIRD_PARTY_FLAG),
530 decode( p_COMPETITOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPETITOR_FLAG),
531 decode( p_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, p_YEAR_ESTABLISHED),
532 decode( p_ADDR_DO_NOT_MAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_ADDR_DO_NOT_MAIL_FLAG),
533 decode( p_URL, FND_API.G_MISS_CHAR, NULL, p_URL),
534 decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
535 decode( p_CONT_DO_NOT_MAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_CONT_DO_NOT_MAIL_FLAG),
536 decode( p_ADDRESS_STATUS, FND_API.G_MISS_CHAR, NULL, p_ADDRESS_STATUS),
537 decode( p_COUNTRY, FND_API.G_MISS_CHAR, NULL, p_COUNTRY),
538 decode( p_ADDRESS1, FND_API.G_MISS_CHAR, NULL, p_ADDRESS1),
539 decode( p_ADDRESS2, FND_API.G_MISS_CHAR, NULL, p_ADDRESS2),
540 decode( p_ADDRESS3, FND_API.G_MISS_CHAR, NULL, p_ADDRESS3),
541 decode( p_ADDRESS4, FND_API.G_MISS_CHAR, NULL, p_ADDRESS4),
542 decode( p_CITY, FND_API.G_MISS_CHAR, NULL, p_CITY),
543 decode( p_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, p_POSTAL_CODE),
544 decode( p_STATE, FND_API.G_MISS_CHAR, NULL, p_STATE),
545 decode( p_PROVINCE, FND_API.G_MISS_CHAR, NULL, p_PROVINCE),
546 decode( p_COUNTY, FND_API.G_MISS_CHAR, NULL, p_COUNTY),
547 decode( p_SITE_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_SITE_CONTACT_ID),
548 decode( p_EMAIL_ADDRESS, FND_API.G_MISS_CHAR, NULL, p_EMAIL_ADDRESS),
549 decode( p_SEX_CODE, FND_API.G_MISS_CHAR, NULL, p_SEX_CODE),
550 decode( p_SALUTATION, FND_API.G_MISS_CHAR, NULL, p_SALUTATION),
551 decode( p_LAST_NAME, FND_API.G_MISS_CHAR, NULL, p_LAST_NAME),
552 decode( p_TITLE, FND_API.G_MISS_CHAR, NULL, p_TITLE),
553 decode( p_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, p_FIRST_NAME),
554 decode( p_JOB_TITLE, FND_API.G_MISS_CHAR, NULL, p_JOB_TITLE),
555 decode( p_PHONE_ID, FND_API.G_MISS_NUM, NULL, p_PHONE_ID),
556 decode( p_PHONE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_PHONE_NUMBER),
557 decode( p_PHONE_STATUS, FND_API.G_MISS_CHAR, NULL, p_PHONE_STATUS),
558 decode( p_PHONE_TYPE, FND_API.G_MISS_CHAR, NULL, p_PHONE_TYPE),
559 decode( p_AREA_CODE, FND_API.G_MISS_CHAR, NULL, p_AREA_CODE),
560 decode( p_EXTENSION, FND_API.G_MISS_CHAR, NULL, p_EXTENSION),
561 decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LEAD_NUMBER),
562 decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
563 decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROMOTION_ID),
564 decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_INITIATING_CONTACT_ID),
565 decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR, NULL, p_CONTACT_ROLE_CODE),
566 decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
567 decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
568 decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_BUDGET_STATUS_CODE),
569 decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
570 decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE),
571 decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
572 decode( p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_RANK_CODE),
573 decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
574 decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
575 decode( p_STATUS_CODE_1, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE_1),
576 decode( p_INTEREST_TYPE_ID_1, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID_1),
577 decode( p_PRIMARY_INTEREST_CODE_ID_1, FND_API.G_MISS_NUM, NULL, p_PRIMARY_INTEREST_CODE_ID_1),
581 decode( p_UOM_CODE_1, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE_1),
578 decode( p_SECONDARY_INTEREST_CODE_ID_1, FND_API.G_MISS_NUM, NULL, p_SECONDARY_INTEREST_CODE_ID_1),
579 decode( p_INVENTORY_ITEM_ID_1, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID_1),
580 decode( p_ORGANIZATION_ID_1, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID_1),
582 decode( p_QUANTITY_1, FND_API.G_MISS_NUM, NULL, p_QUANTITY_1),
583 decode( p_BUDGET_AMOUNT_1, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT_1),
584 decode( p_STATUS_CODE_2, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE_2),
585 decode( p_INTEREST_TYPE_ID_2, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID_2),
586 decode( p_PRIMARY_INTEREST_CODE_ID_2, FND_API.G_MISS_NUM, NULL, p_PRIMARY_INTEREST_CODE_ID_2),
587 decode( p_SECONDARY_INTEREST_CODE_ID_2, FND_API.G_MISS_NUM, NULL, p_SECONDARY_INTEREST_CODE_ID_2),
588 decode( p_INVENTORY_ITEM_ID_2, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID_2),
589 decode( p_ORGANIZATION_ID_2, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID_2),
590 decode( p_UOM_CODE_2, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE_2),
591 decode( p_QUANTITY_2, FND_API.G_MISS_NUM, NULL, p_QUANTITY_2),
592 decode( p_BUDGET_AMOUNT_2, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT_2),
593 decode( p_STATUS_CODE_3, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE_3),
594 decode( p_INTEREST_TYPE_ID_3, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID_3),
595 decode( p_PRIMARY_INTEREST_CODE_ID_3, FND_API.G_MISS_NUM, NULL, p_PRIMARY_INTEREST_CODE_ID_3),
596 decode( p_SECONDARY_INTEREST_CODE_ID_3, FND_API.G_MISS_NUM, NULL, p_SECONDARY_INTEREST_CODE_ID_3),
597 decode( p_INVENTORY_ITEM_ID_3, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID_3),
598 decode( p_ORGANIZATION_ID_3, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID_3),
599 decode( p_UOM_CODE_3, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE_3),
600 decode( p_QUANTITY_3, FND_API.G_MISS_NUM, NULL, p_QUANTITY_3),
601 decode( p_BUDGET_AMOUNT_3, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT_3),
602 decode( p_STATUS_CODE_4, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE_4),
603 decode( p_INTEREST_TYPE_ID_4, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID_4),
604 decode( p_PRIMARY_INTEREST_CODE_ID_4, FND_API.G_MISS_NUM, NULL, p_PRIMARY_INTEREST_CODE_ID_4),
605 decode( p_SECONDARY_INTEREST_CODE_ID_4, FND_API.G_MISS_NUM, NULL, p_SECONDARY_INTEREST_CODE_ID_4),
606 decode( p_INVENTORY_ITEM_ID_4, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID_4),
607 decode( p_ORGANIZATION_ID_4, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID_4),
608 decode( p_UOM_CODE_4, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE_4),
609 decode( p_QUANTITY_4, FND_API.G_MISS_NUM, NULL, p_QUANTITY_4),
610 decode( p_BUDGET_AMOUNT_4, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT_4),
611 decode( p_STATUS_CODE_5, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE_5),
612 decode( p_INTEREST_TYPE_ID_5, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID_5),
613 decode( p_PRIMARY_INTEREST_CODE_ID_5, FND_API.G_MISS_NUM, NULL, p_PRIMARY_INTEREST_CODE_ID_5),
614 decode( p_SECONDARY_INTEREST_CODE_ID_5, FND_API.G_MISS_NUM, NULL, p_SECONDARY_INTEREST_CODE_ID_5),
615 decode( p_INVENTORY_ITEM_ID_5, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID_5),
616 decode( p_ORGANIZATION_ID_5, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID_5),
617 decode( p_UOM_CODE_5, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE_5),
618 decode( p_QUANTITY_5, FND_API.G_MISS_NUM, NULL, p_QUANTITY_5),
619 decode( p_BUDGET_AMOUNT_5, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT_5),
620 decode( p_INTERACTION_NOTES_1, FND_API.G_MISS_CHAR, NULL, p_INTERACTION_NOTES_1),
621 decode( p_PRIORITY_1, FND_API.G_MISS_NUM, NULL, p_PRIORITY_1),
622 decode( p_TODO_DATE_1, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TODO_DATE_1),
623 decode( p_TODO_START_TIME_1, FND_API.G_MISS_CHAR, NULL, p_TODO_START_TIME_1),
624 decode( p_ACTIVITY_CODE_1, FND_API.G_MISS_CHAR, NULL, p_ACTIVITY_CODE_1),
625 decode( p_INTERACTION_NOTES_2, FND_API.G_MISS_CHAR, NULL, p_INTERACTION_NOTES_2),
626 decode( p_PRIORITY_2, FND_API.G_MISS_NUM, NULL, p_PRIORITY_2),
627 decode( p_TODO_DATE_2, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TODO_DATE_2),
628 decode( p_TODO_START_TIME_2, FND_API.G_MISS_CHAR, NULL, p_TODO_START_TIME_2),
629 decode( p_ACTIVITY_CODE_2, FND_API.G_MISS_CHAR, NULL, p_ACTIVITY_CODE_2),
630 decode( p_INTERACTION_NOTES_3, FND_API.G_MISS_CHAR, NULL, p_INTERACTION_NOTES_3),
631 decode( p_PRIORITY_3, FND_API.G_MISS_NUM, NULL, p_PRIORITY_3),
632 decode( p_TODO_DATE_3, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TODO_DATE_3),
633 decode( p_TODO_START_TIME_3, FND_API.G_MISS_CHAR, NULL, p_TODO_START_TIME_3),
634 decode( p_ACTIVITY_CODE_3, FND_API.G_MISS_CHAR, NULL, p_ACTIVITY_CODE_3),
635 decode( p_INTERACTION_NOTES_4, FND_API.G_MISS_CHAR, NULL, p_INTERACTION_NOTES_4),
636 decode( p_PRIORITY_4, FND_API.G_MISS_NUM, NULL, p_PRIORITY_4),
637 decode( p_TODO_DATE_4, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TODO_DATE_4),
638 decode( p_TODO_START_TIME_4, FND_API.G_MISS_CHAR, NULL, p_TODO_START_TIME_4),
639 decode( p_ACTIVITY_CODE_4, FND_API.G_MISS_CHAR, NULL, p_ACTIVITY_CODE_4),
640 decode( p_INTERACTION_NOTES_5, FND_API.G_MISS_CHAR, NULL, p_INTERACTION_NOTES_5),
641 decode( p_PRIORITY_5, FND_API.G_MISS_NUM, NULL, p_PRIORITY_5),
642 decode( p_TODO_DATE_5, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TODO_DATE_5),
643 decode( p_TODO_START_TIME_5, FND_API.G_MISS_CHAR, NULL, p_TODO_START_TIME_5),
644 decode( p_ACTIVITY_CODE_5, FND_API.G_MISS_CHAR, NULL, p_ACTIVITY_CODE_5),
645 decode( p_INTERACTION_NOTES_6, FND_API.G_MISS_CHAR, NULL, p_INTERACTION_NOTES_6),
646 decode( p_PRIORITY_6, FND_API.G_MISS_NUM, NULL, p_PRIORITY_6),
647 decode( p_TODO_DATE_6, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TODO_DATE_6),
651 decode( p_PRIORITY_7, FND_API.G_MISS_NUM, NULL, p_PRIORITY_7),
648 decode( p_TODO_START_TIME_6, FND_API.G_MISS_CHAR, NULL, p_TODO_START_TIME_6),
649 decode( p_ACTIVITY_CODE_6, FND_API.G_MISS_CHAR, NULL, p_ACTIVITY_CODE_6),
650 decode( p_INTERACTION_NOTES_7, FND_API.G_MISS_CHAR, NULL, p_INTERACTION_NOTES_7),
652 decode( p_TODO_DATE_7, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TODO_DATE_7),
653 decode( p_TODO_START_TIME_7, FND_API.G_MISS_CHAR, NULL, p_TODO_START_TIME_7),
654 decode( p_ACTIVITY_CODE_7, FND_API.G_MISS_CHAR, NULL, p_ACTIVITY_CODE_7),
655 decode( p_INTERACTION_NOTES_8, FND_API.G_MISS_CHAR, NULL, p_INTERACTION_NOTES_8),
656 decode( p_PRIORITY_8, FND_API.G_MISS_NUM, NULL, p_PRIORITY_8),
657 decode( p_TODO_DATE_8, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TODO_DATE_8),
658 decode( p_TODO_START_TIME_8, FND_API.G_MISS_CHAR, NULL, p_TODO_START_TIME_8),
659 decode( p_ACTIVITY_CODE_8, FND_API.G_MISS_CHAR, NULL, p_ACTIVITY_CODE_8),
660 decode( p_INTERACTION_NOTES_9, FND_API.G_MISS_CHAR, NULL, p_INTERACTION_NOTES_9),
661 decode( p_PRIORITY_9, FND_API.G_MISS_NUM, NULL, p_PRIORITY_9),
662 decode( p_TODO_DATE_9, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TODO_DATE_9),
663 decode( p_TODO_START_TIME_9, FND_API.G_MISS_CHAR, NULL, p_TODO_START_TIME_9),
664 decode( p_ACTIVITY_CODE_9, FND_API.G_MISS_CHAR, NULL, p_ACTIVITY_CODE_9),
665 decode( p_INTERACTION_NOTES_10, FND_API.G_MISS_CHAR, NULL, p_INTERACTION_NOTES_10),
666 decode( p_PRIORITY_10, FND_API.G_MISS_NUM, NULL, p_PRIORITY_10),
667 decode( p_TODO_DATE_10, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TODO_DATE_10),
668 decode( p_TODO_START_TIME_10, FND_API.G_MISS_CHAR, NULL, p_TODO_START_TIME_10),
669 decode( p_ACTIVITY_CODE_10, FND_API.G_MISS_CHAR, NULL, p_ACTIVITY_CODE_10),
670 decode( p_LEAD_NOTE, FND_API.G_MISS_CHAR, NULL, p_LEAD_NOTE),
671 decode( p_MIDDLE_INITIAL, FND_API.G_MISS_CHAR, NULL, p_MIDDLE_INITIAL),
672 decode( p_FAX_NUMBER, FND_API.G_MISS_CHAR, NULL, p_FAX_NUMBER),
673 decode( p_FAX_AREA_CODE, FND_API.G_MISS_CHAR, NULL, p_FAX_AREA_CODE),
674 decode( p_MAIL_STOP, FND_API.G_MISS_CHAR, NULL, p_MAIL_STOP),
675 decode( p_NUM_ENROLLED, FND_API.G_MISS_NUM, NULL, p_NUM_ENROLLED),
676 decode( p_CONFIRMED_FLAG, FND_API.G_MISS_CHAR, NULL, p_CONFIRMED_FLAG),
677 decode( p_PAYMENT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PAYMENT_AMOUNT),
678 decode( p_NUM_ATTENDED, FND_API.G_MISS_NUM, NULL, p_NUM_ATTENDED),
679 decode( p_PROMOTION_NAME, FND_API.G_MISS_CHAR, NULL, p_PROMOTION_NAME),
680 decode( p_STATUS_CHANGE_FLAG, FND_API.G_MISS_CHAR, NULL, p_STATUS_CHANGE_FLAG),
681 decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL, p_VEHICLE_RESPONSE_CODE),
682 decode( p_SOURCE_SYSTEM, FND_API.G_MISS_CHAR, NULL, p_SOURCE_SYSTEM),
683 decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CONTACT_PARTY_ID),
684 decode( p_PRM_SALES_LEAD_TYPE, FND_API.G_MISS_CHAR, NULL, p_PRM_SALES_LEAD_TYPE),
685 decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_EXEC_SPONSOR_FLAG),
686 decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
687 decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_PARTY_ID),
688 decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_RESOURCE_ID),
689 decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
690 decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_IND_CLASSIFICATION_CODE),
691 decode( p_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, p_PARTY_TYPE),
692 decode( p_BATCH_ID, FND_API.G_MISS_NUM, NULL, p_BATCH_ID),
693 decode( p_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_PARTY_ID),
694 decode( p_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_PARTY_SITE_ID),
695 decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
696 decode( p_REL_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_REL_PARTY_ID),
697 decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID),
698 decode( p_ADDRESS_KEY, FND_API.G_MISS_CHAR, NULL, p_ADDRESS_KEY),
699 decode( p_CONTACT_KEY, FND_API.G_MISS_CHAR, NULL, p_CONTACT_KEY),
700 decode( p_JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, p_JOB_TITLE_CODE),
701 decode( p_DO_NOT_PHONE_FLAG, FND_API.G_MISS_CHAR, NULL, p_DO_NOT_PHONE_FLAG),
702 decode( p_DO_NOT_FAX_FLAG, FND_API.G_MISS_CHAR, NULL, p_DO_NOT_FAX_FLAG),
703 decode( p_DO_NOT_EMAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_DO_NOT_EMAIL_FLAG),
704 decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_REFERENCE),
705 decode( p_LEAD_RANK_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_RANK_ID),
706 decode( p_NEW_PARTY_FLAG, FND_API.G_MISS_NUM, NULL, p_NEW_PARTY_FLAG),
707 decode( p_NEW_LOC_FLAG, FND_API.G_MISS_NUM, NULL, p_NEW_LOC_FLAG),
708 decode( p_NEW_PS_FLAG, FND_API.G_MISS_NUM, NULL, p_NEW_PS_FLAG),
709 decode( p_NEW_REL_FLAG, FND_API.G_MISS_NUM, NULL, p_NEW_REL_FLAG),
710 decode( p_NEW_CON_FLAG, FND_API.G_MISS_NUM, NULL, p_NEW_CON_FLAG),
711 decode( p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_CODE),
712 decode( p_URGENT_FLAG, FND_API.G_MISS_CHAR, NULL, p_URGENT_FLAG));
713 End Insert_Row;
714
715 PROCEDURE Update_Row(
716 p_IMPORT_INTERFACE_ID NUMBER,
717 p_LAST_UPDATE_DATE DATE,
718 p_LAST_UPDATED_BY NUMBER,
719 p_CREATION_DATE DATE,
720 p_CREATED_BY NUMBER,
721 p_LAST_UPDATE_LOGIN NUMBER,
722 p_REQUEST_ID NUMBER,
723 p_PROGRAM_APPLICATION_ID NUMBER,
724 p_PROGRAM_ID NUMBER,
725 p_PROGRAM_UPDATE_DATE DATE,
726 p_IMP_LIST_HEADER_NUMBER VARCHAR2,
727 p_LOAD_TYPE VARCHAR2,
728 p_LOAD_DATE DATE,
732 p_PROMOTION_CODE VARCHAR2,
729 p_LOAD_STATUS VARCHAR2,
730 p_LOAD_ERROR_MESSAGE VARCHAR2,
731 p_PROMOTION_ID NUMBER,
733 p_CUSTOMER_ID NUMBER,
734 p_CUSTOMER_NAME VARCHAR2,
735 p_CUSTOMER_NUMBER VARCHAR2,
736 p_CUSTOMER_STATUS VARCHAR2,
737 p_CUSTOMER_TYPE VARCHAR2,
738 p_CUSTOMER_PROSPECT_CODE VARCHAR2,
739 p_CUSTOMER_CLASS_CODE VARCHAR2,
740 p_SALES_CHANNEL_CODE VARCHAR2,
741 p_SIC_CODE VARCHAR2,
742 p_ANALYSIS_FY VARCHAR2,
743 p_CUSTOMER_CATEGORY_CODE VARCHAR2,
744 p_CUSTOMER_GROUP_CODE VARCHAR2,
745 p_CUSTOMER_KEY VARCHAR2,
746 p_CUSTOMER_SUBGROUP_CODE VARCHAR2,
747 p_FISCAL_YEAREND_MONTH VARCHAR2,
748 p_NET_WORTH NUMBER,
749 p_NUM_OF_EMPLOYEES NUMBER,
750 p_POTENTIAL_REVENUE_CURR_FY NUMBER,
751 p_POTENTIAL_REVENUE_NEXT_FY NUMBER,
752 p_CUSTOMER_RANK VARCHAR2,
753 p_REFERENCE_USE_FLAG VARCHAR2,
754 p_TAX_CODE VARCHAR2,
755 p_TAX_REFERENCE VARCHAR2,
756 p_THIRD_PARTY_FLAG VARCHAR2,
757 p_COMPETITOR_FLAG VARCHAR2,
758 p_YEAR_ESTABLISHED NUMBER,
759 p_ADDR_DO_NOT_MAIL_FLAG VARCHAR2,
760 p_URL VARCHAR2,
761 p_ADDRESS_ID NUMBER,
762 p_CONT_DO_NOT_MAIL_FLAG VARCHAR2,
763 p_ADDRESS_STATUS VARCHAR2,
764 p_COUNTRY VARCHAR2,
765 p_ADDRESS1 VARCHAR2,
766 p_ADDRESS2 VARCHAR2,
767 p_ADDRESS3 VARCHAR2,
768 p_ADDRESS4 VARCHAR2,
769 p_CITY VARCHAR2,
770 p_POSTAL_CODE VARCHAR2,
771 p_STATE VARCHAR2,
772 p_PROVINCE VARCHAR2,
773 p_COUNTY VARCHAR2,
774 p_SITE_CONTACT_ID NUMBER,
775 p_EMAIL_ADDRESS VARCHAR2,
776 p_SEX_CODE VARCHAR2,
777 p_SALUTATION VARCHAR2,
778 p_LAST_NAME VARCHAR2,
779 p_TITLE VARCHAR2,
780 p_FIRST_NAME VARCHAR2,
781 p_JOB_TITLE VARCHAR2,
782 p_PHONE_ID NUMBER,
783 p_PHONE_NUMBER VARCHAR2,
784 p_PHONE_STATUS VARCHAR2,
785 p_PHONE_TYPE VARCHAR2,
786 p_AREA_CODE VARCHAR2,
787 p_EXTENSION VARCHAR2,
788 p_LEAD_NUMBER VARCHAR2,
789 p_STATUS_CODE VARCHAR2,
790 p_SOURCE_PROMOTION_ID NUMBER,
791 p_INITIATING_CONTACT_ID NUMBER,
792 p_CONTACT_ROLE_CODE VARCHAR2,
793 p_CHANNEL_CODE VARCHAR2,
794 p_BUDGET_AMOUNT NUMBER,
795 p_BUDGET_STATUS_CODE VARCHAR2,
796 p_CURRENCY_CODE VARCHAR2,
797 p_DECISION_TIMEFRAME_CODE VARCHAR2,
798 p_CLOSE_REASON VARCHAR2,
799 p_LEAD_RANK_CODE VARCHAR2,
800 p_PARENT_PROJECT VARCHAR2,
801 p_DESCRIPTION VARCHAR2,
802 p_STATUS_CODE_1 VARCHAR2,
803 p_INTEREST_TYPE_ID_1 NUMBER,
804 p_PRIMARY_INTEREST_CODE_ID_1 NUMBER,
805 p_SECONDARY_INTEREST_CODE_ID_1 NUMBER,
806 p_INVENTORY_ITEM_ID_1 NUMBER,
807 p_ORGANIZATION_ID_1 NUMBER,
808 p_UOM_CODE_1 VARCHAR2,
809 p_QUANTITY_1 NUMBER,
810 p_BUDGET_AMOUNT_1 NUMBER,
811 p_STATUS_CODE_2 VARCHAR2,
812 p_INTEREST_TYPE_ID_2 NUMBER,
813 p_PRIMARY_INTEREST_CODE_ID_2 NUMBER,
814 p_SECONDARY_INTEREST_CODE_ID_2 NUMBER,
815 p_INVENTORY_ITEM_ID_2 NUMBER,
816 p_ORGANIZATION_ID_2 NUMBER,
817 p_UOM_CODE_2 VARCHAR2,
818 p_QUANTITY_2 NUMBER,
819 p_BUDGET_AMOUNT_2 NUMBER,
820 p_STATUS_CODE_3 VARCHAR2,
821 p_INTEREST_TYPE_ID_3 NUMBER,
822 p_PRIMARY_INTEREST_CODE_ID_3 NUMBER,
823 p_SECONDARY_INTEREST_CODE_ID_3 NUMBER,
824 p_INVENTORY_ITEM_ID_3 NUMBER,
825 p_ORGANIZATION_ID_3 NUMBER,
826 p_UOM_CODE_3 VARCHAR2,
827 p_QUANTITY_3 NUMBER,
828 p_BUDGET_AMOUNT_3 NUMBER,
829 p_STATUS_CODE_4 VARCHAR2,
830 p_INTEREST_TYPE_ID_4 NUMBER,
831 p_PRIMARY_INTEREST_CODE_ID_4 NUMBER,
832 p_SECONDARY_INTEREST_CODE_ID_4 NUMBER,
833 p_INVENTORY_ITEM_ID_4 NUMBER,
834 p_ORGANIZATION_ID_4 NUMBER,
835 p_UOM_CODE_4 VARCHAR2,
836 p_QUANTITY_4 NUMBER,
837 p_BUDGET_AMOUNT_4 NUMBER,
838 p_STATUS_CODE_5 VARCHAR2,
839 p_INTEREST_TYPE_ID_5 NUMBER,
840 p_PRIMARY_INTEREST_CODE_ID_5 NUMBER,
841 p_SECONDARY_INTEREST_CODE_ID_5 NUMBER,
842 p_INVENTORY_ITEM_ID_5 NUMBER,
843 p_ORGANIZATION_ID_5 NUMBER,
844 p_UOM_CODE_5 VARCHAR2,
845 p_QUANTITY_5 NUMBER,
846 p_BUDGET_AMOUNT_5 NUMBER,
847 p_INTERACTION_NOTES_1 VARCHAR2,
848 p_PRIORITY_1 NUMBER,
849 p_TODO_DATE_1 DATE,
850 p_TODO_START_TIME_1 VARCHAR2,
851 p_ACTIVITY_CODE_1 VARCHAR2,
852 p_INTERACTION_NOTES_2 VARCHAR2,
853 p_PRIORITY_2 NUMBER,
854 p_TODO_DATE_2 DATE,
855 p_TODO_START_TIME_2 VARCHAR2,
856 p_ACTIVITY_CODE_2 VARCHAR2,
857 p_INTERACTION_NOTES_3 VARCHAR2,
858 p_PRIORITY_3 NUMBER,
859 p_TODO_DATE_3 DATE,
863 p_PRIORITY_4 NUMBER,
860 p_TODO_START_TIME_3 VARCHAR2,
861 p_ACTIVITY_CODE_3 VARCHAR2,
862 p_INTERACTION_NOTES_4 VARCHAR2,
864 p_TODO_DATE_4 DATE,
865 p_TODO_START_TIME_4 VARCHAR2,
866 p_ACTIVITY_CODE_4 VARCHAR2,
867 p_INTERACTION_NOTES_5 VARCHAR2,
868 p_PRIORITY_5 NUMBER,
869 p_TODO_DATE_5 DATE,
870 p_TODO_START_TIME_5 VARCHAR2,
871 p_ACTIVITY_CODE_5 VARCHAR2,
872 p_INTERACTION_NOTES_6 VARCHAR2,
873 p_PRIORITY_6 NUMBER,
874 p_TODO_DATE_6 DATE,
875 p_TODO_START_TIME_6 VARCHAR2,
876 p_ACTIVITY_CODE_6 VARCHAR2,
877 p_INTERACTION_NOTES_7 VARCHAR2,
878 p_PRIORITY_7 NUMBER,
879 p_TODO_DATE_7 DATE,
880 p_TODO_START_TIME_7 VARCHAR2,
881 p_ACTIVITY_CODE_7 VARCHAR2,
882 p_INTERACTION_NOTES_8 VARCHAR2,
883 p_PRIORITY_8 NUMBER,
884 p_TODO_DATE_8 DATE,
885 p_TODO_START_TIME_8 VARCHAR2,
886 p_ACTIVITY_CODE_8 VARCHAR2,
887 p_INTERACTION_NOTES_9 VARCHAR2,
888 p_PRIORITY_9 NUMBER,
889 p_TODO_DATE_9 DATE,
890 p_TODO_START_TIME_9 VARCHAR2,
891 p_ACTIVITY_CODE_9 VARCHAR2,
892 p_INTERACTION_NOTES_10 VARCHAR2,
893 p_PRIORITY_10 NUMBER,
894 p_TODO_DATE_10 DATE,
895 p_TODO_START_TIME_10 VARCHAR2,
896 p_ACTIVITY_CODE_10 VARCHAR2,
897 p_LEAD_NOTE VARCHAR2,
898 p_MIDDLE_INITIAL VARCHAR2,
899 p_FAX_NUMBER VARCHAR2,
900 p_FAX_AREA_CODE VARCHAR2,
901 p_MAIL_STOP VARCHAR2,
902 p_NUM_ENROLLED NUMBER,
903 p_CONFIRMED_FLAG VARCHAR2,
904 p_PAYMENT_AMOUNT NUMBER,
905 p_NUM_ATTENDED NUMBER,
906 p_PROMOTION_NAME VARCHAR2,
907 p_STATUS_CHANGE_FLAG VARCHAR2,
908 p_VEHICLE_RESPONSE_CODE VARCHAR2,
909 p_SOURCE_SYSTEM VARCHAR2,
910 p_CONTACT_PARTY_ID NUMBER,
911 p_PRM_SALES_LEAD_TYPE VARCHAR2,
912 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
913 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
914 p_INC_PARTNER_PARTY_ID NUMBER,
915 p_INC_PARTNER_RESOURCE_ID NUMBER,
916 p_OFFER_ID NUMBER,
917 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
918 p_PARTY_TYPE VARCHAR2,
919 p_BATCH_ID NUMBER,
920 p_PARTY_ID NUMBER,
921 p_PARTY_SITE_ID NUMBER,
922 p_LOCATION_ID NUMBER,
923 p_REL_PARTY_ID NUMBER,
924 p_SALES_LEAD_ID NUMBER,
925 p_ADDRESS_KEY VARCHAR2,
926 p_CONTACT_KEY VARCHAR2,
927 p_JOB_TITLE_CODE VARCHAR2,
928 p_DO_NOT_PHONE_FLAG VARCHAR2,
929 p_DO_NOT_FAX_FLAG VARCHAR2,
930 p_DO_NOT_EMAIL_FLAG VARCHAR2,
931 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
932 p_LEAD_RANK_ID NUMBER,
933 p_NEW_PARTY_FLAG NUMBER,
934 p_NEW_LOC_FLAG NUMBER,
935 p_NEW_PS_FLAG NUMBER,
936 p_NEW_REL_FLAG NUMBER,
937 p_NEW_CON_FLAG NUMBER,
938 p_ORIG_SYSTEM_CODE VARCHAR2,
939 p_URGENT_FLAG VARCHAR2,
940 p_SIC_CODE_TYPE VARCHAR2,
941 p_SITE_USE_TYPE VARCHAR2,
942 p_PRIMARY_CONTACT_FLAG VARCHAR2,
943 p_RANK VARCHAR2,
944 p_ADDRESS_STYLE VARCHAR2,
945 p_PRIMARY_PER_TYPE VARCHAR2,
946 p_DEPARTMENT_CODE VARCHAR2)
947
948
949 IS
950 BEGIN
951 Update_Row(
952 p_IMPORT_INTERFACE_ID ,
953 p_LAST_UPDATE_DATE ,
954 p_LAST_UPDATED_BY ,
955 p_CREATION_DATE ,
956 p_CREATED_BY ,
957 p_LAST_UPDATE_LOGIN ,
958 p_REQUEST_ID ,
959 p_PROGRAM_APPLICATION_ID ,
960 p_PROGRAM_ID ,
961 p_PROGRAM_UPDATE_DATE ,
962 p_IMP_LIST_HEADER_NUMBER ,
963 p_LOAD_TYPE ,
964 p_LOAD_DATE ,
965 p_LOAD_STATUS ,
966 p_LOAD_ERROR_MESSAGE ,
967 p_PROMOTION_ID ,
968 p_PROMOTION_CODE ,
969 p_CUSTOMER_ID ,
970 p_CUSTOMER_NAME ,
971 p_CUSTOMER_NUMBER ,
972 p_CUSTOMER_STATUS ,
973 p_CUSTOMER_TYPE ,
974 p_CUSTOMER_PROSPECT_CODE ,
975 p_CUSTOMER_CLASS_CODE ,
976 p_SALES_CHANNEL_CODE ,
977 p_SIC_CODE ,
978 p_ANALYSIS_FY ,
979 p_CUSTOMER_CATEGORY_CODE ,
980 p_CUSTOMER_GROUP_CODE ,
981 p_CUSTOMER_KEY ,
982 p_CUSTOMER_SUBGROUP_CODE ,
983 p_FISCAL_YEAREND_MONTH ,
984 p_NET_WORTH ,
985 p_NUM_OF_EMPLOYEES ,
986 p_POTENTIAL_REVENUE_CURR_FY ,
987 p_POTENTIAL_REVENUE_NEXT_FY ,
988 p_CUSTOMER_RANK ,
989 p_REFERENCE_USE_FLAG ,
990 p_TAX_CODE ,
991 p_TAX_REFERENCE ,
992 p_THIRD_PARTY_FLAG ,
993 p_COMPETITOR_FLAG ,
994 p_YEAR_ESTABLISHED ,
995 p_ADDR_DO_NOT_MAIL_FLAG ,
996 p_URL ,
997 p_ADDRESS_ID ,
1001 p_ADDRESS1 ,
998 p_CONT_DO_NOT_MAIL_FLAG ,
999 p_ADDRESS_STATUS ,
1000 p_COUNTRY ,
1002 p_ADDRESS2 ,
1003 p_ADDRESS3 ,
1004 p_ADDRESS4 ,
1005 p_CITY ,
1006 p_POSTAL_CODE ,
1007 p_STATE ,
1008 p_PROVINCE ,
1009 p_COUNTY ,
1010 p_SITE_CONTACT_ID ,
1011 p_EMAIL_ADDRESS ,
1012 p_SEX_CODE ,
1013 p_SALUTATION ,
1014 p_LAST_NAME ,
1015 p_TITLE ,
1016 p_FIRST_NAME ,
1017 p_JOB_TITLE ,
1018 p_PHONE_ID ,
1019 p_PHONE_NUMBER ,
1020 p_PHONE_STATUS ,
1021 p_PHONE_TYPE ,
1022 p_AREA_CODE ,
1023 p_EXTENSION ,
1024 p_LEAD_NUMBER ,
1025 p_STATUS_CODE ,
1026 p_SOURCE_PROMOTION_ID ,
1027 p_INITIATING_CONTACT_ID ,
1028 p_CONTACT_ROLE_CODE ,
1029 p_CHANNEL_CODE ,
1030 p_BUDGET_AMOUNT ,
1031 p_BUDGET_STATUS_CODE ,
1032 p_CURRENCY_CODE ,
1033 p_DECISION_TIMEFRAME_CODE ,
1034 p_CLOSE_REASON ,
1035 p_LEAD_RANK_CODE ,
1036 p_PARENT_PROJECT ,
1037 p_DESCRIPTION ,
1038 p_STATUS_CODE_1 ,
1039 p_INTEREST_TYPE_ID_1 ,
1040 p_PRIMARY_INTEREST_CODE_ID_1 ,
1041 p_SECONDARY_INTEREST_CODE_ID_1 ,
1042 p_INVENTORY_ITEM_ID_1 ,
1043 p_ORGANIZATION_ID_1 ,
1044 p_UOM_CODE_1 ,
1045 p_QUANTITY_1 ,
1046 p_BUDGET_AMOUNT_1 ,
1047 p_STATUS_CODE_2 ,
1048 p_INTEREST_TYPE_ID_2 ,
1049 p_PRIMARY_INTEREST_CODE_ID_2 ,
1050 p_SECONDARY_INTEREST_CODE_ID_2 ,
1051 p_INVENTORY_ITEM_ID_2 ,
1052 p_ORGANIZATION_ID_2 ,
1053 p_UOM_CODE_2 ,
1054 p_QUANTITY_2 ,
1055 p_BUDGET_AMOUNT_2 ,
1056 p_STATUS_CODE_3 ,
1057 p_INTEREST_TYPE_ID_3 ,
1058 p_PRIMARY_INTEREST_CODE_ID_3 ,
1059 p_SECONDARY_INTEREST_CODE_ID_3 ,
1060 p_INVENTORY_ITEM_ID_3 ,
1061 p_ORGANIZATION_ID_3 ,
1062 p_UOM_CODE_3 ,
1063 p_QUANTITY_3 ,
1064 p_BUDGET_AMOUNT_3 ,
1065 p_STATUS_CODE_4 ,
1066 p_INTEREST_TYPE_ID_4 ,
1067 p_PRIMARY_INTEREST_CODE_ID_4 ,
1068 p_SECONDARY_INTEREST_CODE_ID_4 ,
1069 p_INVENTORY_ITEM_ID_4 ,
1070 p_ORGANIZATION_ID_4 ,
1071 p_UOM_CODE_4 ,
1072 p_QUANTITY_4 ,
1073 p_BUDGET_AMOUNT_4 ,
1074 p_STATUS_CODE_5 ,
1075 p_INTEREST_TYPE_ID_5 ,
1076 p_PRIMARY_INTEREST_CODE_ID_5 ,
1077 p_SECONDARY_INTEREST_CODE_ID_5 ,
1078 p_INVENTORY_ITEM_ID_5 ,
1079 p_ORGANIZATION_ID_5 ,
1080 p_UOM_CODE_5 ,
1081 p_QUANTITY_5 ,
1082 p_BUDGET_AMOUNT_5 ,
1083 p_INTERACTION_NOTES_1 ,
1084 p_PRIORITY_1 ,
1085 p_TODO_DATE_1 ,
1086 p_TODO_START_TIME_1 ,
1087 p_ACTIVITY_CODE_1 ,
1088 p_INTERACTION_NOTES_2 ,
1089 p_PRIORITY_2 ,
1090 p_TODO_DATE_2 ,
1091 p_TODO_START_TIME_2 ,
1092 p_ACTIVITY_CODE_2 ,
1093 p_INTERACTION_NOTES_3 ,
1094 p_PRIORITY_3 ,
1095 p_TODO_DATE_3 ,
1096 p_TODO_START_TIME_3 ,
1097 p_ACTIVITY_CODE_3 ,
1098 p_INTERACTION_NOTES_4 ,
1099 p_PRIORITY_4 ,
1100 p_TODO_DATE_4 ,
1101 p_TODO_START_TIME_4 ,
1102 p_ACTIVITY_CODE_4 ,
1103 p_INTERACTION_NOTES_5 ,
1104 p_PRIORITY_5 ,
1105 p_TODO_DATE_5 ,
1106 p_TODO_START_TIME_5 ,
1107 p_ACTIVITY_CODE_5 ,
1108 p_INTERACTION_NOTES_6 ,
1109 p_PRIORITY_6 ,
1110 p_TODO_DATE_6 ,
1111 p_TODO_START_TIME_6 ,
1112 p_ACTIVITY_CODE_6 ,
1113 p_INTERACTION_NOTES_7 ,
1114 p_PRIORITY_7 ,
1115 p_TODO_DATE_7 ,
1116 p_TODO_START_TIME_7 ,
1117 p_ACTIVITY_CODE_7 ,
1118 p_INTERACTION_NOTES_8 ,
1119 p_PRIORITY_8 ,
1120 p_TODO_DATE_8 ,
1121 p_TODO_START_TIME_8 ,
1122 p_ACTIVITY_CODE_8 ,
1123 p_INTERACTION_NOTES_9 ,
1124 p_PRIORITY_9 ,
1125 p_TODO_DATE_9 ,
1126 p_TODO_START_TIME_9 ,
1127 p_ACTIVITY_CODE_9 ,
1128 p_INTERACTION_NOTES_10 ,
1129 p_PRIORITY_10 ,
1130 p_TODO_DATE_10 ,
1131 p_TODO_START_TIME_10 ,
1132 p_ACTIVITY_CODE_10 ,
1133 p_LEAD_NOTE ,
1134 p_MIDDLE_INITIAL ,
1135 p_FAX_NUMBER ,
1136 p_FAX_AREA_CODE ,
1137 p_MAIL_STOP ,
1138 p_NUM_ENROLLED ,
1139 p_CONFIRMED_FLAG ,
1140 p_PAYMENT_AMOUNT ,
1141 p_NUM_ATTENDED ,
1142 p_PROMOTION_NAME ,
1143 p_STATUS_CHANGE_FLAG ,
1144 p_VEHICLE_RESPONSE_CODE ,
1148 p_PRM_EXEC_SPONSOR_FLAG ,
1145 p_SOURCE_SYSTEM ,
1146 p_CONTACT_PARTY_ID ,
1147 p_PRM_SALES_LEAD_TYPE ,
1149 p_PRM_PRJ_LEAD_IN_PLACE_FLAG ,
1150 p_INC_PARTNER_PARTY_ID ,
1151 p_INC_PARTNER_RESOURCE_ID ,
1152 p_OFFER_ID ,
1153 p_PRM_IND_CLASSIFICATION_CODE ,
1154 p_PARTY_TYPE ,
1155 p_BATCH_ID ,
1156 p_PARTY_ID ,
1157 p_PARTY_SITE_ID ,
1158 p_LOCATION_ID ,
1159 p_REL_PARTY_ID ,
1160 p_SALES_LEAD_ID ,
1161 p_ADDRESS_KEY ,
1162 p_CONTACT_KEY ,
1163 p_JOB_TITLE_CODE ,
1164 p_DO_NOT_PHONE_FLAG ,
1165 p_DO_NOT_FAX_FLAG ,
1166 p_DO_NOT_EMAIL_FLAG ,
1167 p_ORIG_SYSTEM_REFERENCE ,
1168 p_LEAD_RANK_ID ,
1169 p_NEW_PARTY_FLAG ,
1170 p_NEW_LOC_FLAG ,
1171 p_NEW_PS_FLAG ,
1172 p_NEW_REL_FLAG ,
1173 p_NEW_CON_FLAG ,
1174 p_ORIG_SYSTEM_CODE ,
1175 p_URGENT_FLAG ,
1176 p_SIC_CODE_TYPE ,
1177 p_SITE_USE_TYPE ,
1178 p_PRIMARY_CONTACT_FLAG ,
1179 p_RANK ,
1180 p_ADDRESS_STYLE ,
1181 p_PRIMARY_PER_TYPE ,
1182 p_DEPARTMENT_CODE ,
1183 null,
1184 null,
1185 null);
1186
1187 END Update_Row;
1188
1189
1190
1191 PROCEDURE Update_Row(
1192 p_IMPORT_INTERFACE_ID NUMBER,
1193 p_LAST_UPDATE_DATE DATE,
1194 p_LAST_UPDATED_BY NUMBER,
1195 p_CREATION_DATE DATE,
1196 p_CREATED_BY NUMBER,
1197 p_LAST_UPDATE_LOGIN NUMBER,
1198 p_REQUEST_ID NUMBER,
1199 p_PROGRAM_APPLICATION_ID NUMBER,
1200 p_PROGRAM_ID NUMBER,
1201 p_PROGRAM_UPDATE_DATE DATE,
1202 p_IMP_LIST_HEADER_NUMBER VARCHAR2,
1203 p_LOAD_TYPE VARCHAR2,
1204 p_LOAD_DATE DATE,
1205 p_LOAD_STATUS VARCHAR2,
1206 p_LOAD_ERROR_MESSAGE VARCHAR2,
1207 p_PROMOTION_ID NUMBER,
1208 p_PROMOTION_CODE VARCHAR2,
1209 p_CUSTOMER_ID NUMBER,
1210 p_CUSTOMER_NAME VARCHAR2,
1211 p_CUSTOMER_NUMBER VARCHAR2,
1212 p_CUSTOMER_STATUS VARCHAR2,
1213 p_CUSTOMER_TYPE VARCHAR2,
1214 p_CUSTOMER_PROSPECT_CODE VARCHAR2,
1215 p_CUSTOMER_CLASS_CODE VARCHAR2,
1216 p_SALES_CHANNEL_CODE VARCHAR2,
1217 p_SIC_CODE VARCHAR2,
1218 p_ANALYSIS_FY VARCHAR2,
1219 p_CUSTOMER_CATEGORY_CODE VARCHAR2,
1220 p_CUSTOMER_GROUP_CODE VARCHAR2,
1221 p_CUSTOMER_KEY VARCHAR2,
1222 p_CUSTOMER_SUBGROUP_CODE VARCHAR2,
1223 p_FISCAL_YEAREND_MONTH VARCHAR2,
1224 p_NET_WORTH NUMBER,
1225 p_NUM_OF_EMPLOYEES NUMBER,
1226 p_POTENTIAL_REVENUE_CURR_FY NUMBER,
1227 p_POTENTIAL_REVENUE_NEXT_FY NUMBER,
1228 p_CUSTOMER_RANK VARCHAR2,
1229 p_REFERENCE_USE_FLAG VARCHAR2,
1230 p_TAX_CODE VARCHAR2,
1231 p_TAX_REFERENCE VARCHAR2,
1232 p_THIRD_PARTY_FLAG VARCHAR2,
1233 p_COMPETITOR_FLAG VARCHAR2,
1234 p_YEAR_ESTABLISHED NUMBER,
1235 p_ADDR_DO_NOT_MAIL_FLAG VARCHAR2,
1236 p_URL VARCHAR2,
1237 p_ADDRESS_ID NUMBER,
1238 p_CONT_DO_NOT_MAIL_FLAG VARCHAR2,
1239 p_ADDRESS_STATUS VARCHAR2,
1240 p_COUNTRY VARCHAR2,
1241 p_ADDRESS1 VARCHAR2,
1242 p_ADDRESS2 VARCHAR2,
1243 p_ADDRESS3 VARCHAR2,
1244 p_ADDRESS4 VARCHAR2,
1245 p_CITY VARCHAR2,
1246 p_POSTAL_CODE VARCHAR2,
1247 p_STATE VARCHAR2,
1248 p_PROVINCE VARCHAR2,
1249 p_COUNTY VARCHAR2,
1250 p_SITE_CONTACT_ID NUMBER,
1251 p_EMAIL_ADDRESS VARCHAR2,
1252 p_SEX_CODE VARCHAR2,
1253 p_SALUTATION VARCHAR2,
1254 p_LAST_NAME VARCHAR2,
1255 p_TITLE VARCHAR2,
1256 p_FIRST_NAME VARCHAR2,
1257 p_JOB_TITLE VARCHAR2,
1258 p_PHONE_ID NUMBER,
1259 p_PHONE_NUMBER VARCHAR2,
1260 p_PHONE_STATUS VARCHAR2,
1261 p_PHONE_TYPE VARCHAR2,
1262 p_AREA_CODE VARCHAR2,
1263 p_EXTENSION VARCHAR2,
1264 p_LEAD_NUMBER VARCHAR2,
1265 p_STATUS_CODE VARCHAR2,
1266 p_SOURCE_PROMOTION_ID NUMBER,
1267 p_INITIATING_CONTACT_ID NUMBER,
1268 p_CONTACT_ROLE_CODE VARCHAR2,
1269 p_CHANNEL_CODE VARCHAR2,
1270 p_BUDGET_AMOUNT NUMBER,
1271 p_BUDGET_STATUS_CODE VARCHAR2,
1272 p_CURRENCY_CODE VARCHAR2,
1273 p_DECISION_TIMEFRAME_CODE VARCHAR2,
1274 p_CLOSE_REASON VARCHAR2,
1275 p_LEAD_RANK_CODE VARCHAR2,
1276 p_PARENT_PROJECT VARCHAR2,
1277 p_DESCRIPTION VARCHAR2,
1278 p_STATUS_CODE_1 VARCHAR2,
1279 p_INTEREST_TYPE_ID_1 NUMBER,
1280 p_PRIMARY_INTEREST_CODE_ID_1 NUMBER,
1281 p_SECONDARY_INTEREST_CODE_ID_1 NUMBER,
1282 p_INVENTORY_ITEM_ID_1 NUMBER,
1283 p_ORGANIZATION_ID_1 NUMBER,
1287 p_STATUS_CODE_2 VARCHAR2,
1284 p_UOM_CODE_1 VARCHAR2,
1285 p_QUANTITY_1 NUMBER,
1286 p_BUDGET_AMOUNT_1 NUMBER,
1288 p_INTEREST_TYPE_ID_2 NUMBER,
1289 p_PRIMARY_INTEREST_CODE_ID_2 NUMBER,
1290 p_SECONDARY_INTEREST_CODE_ID_2 NUMBER,
1291 p_INVENTORY_ITEM_ID_2 NUMBER,
1292 p_ORGANIZATION_ID_2 NUMBER,
1293 p_UOM_CODE_2 VARCHAR2,
1294 p_QUANTITY_2 NUMBER,
1295 p_BUDGET_AMOUNT_2 NUMBER,
1296 p_STATUS_CODE_3 VARCHAR2,
1297 p_INTEREST_TYPE_ID_3 NUMBER,
1298 p_PRIMARY_INTEREST_CODE_ID_3 NUMBER,
1299 p_SECONDARY_INTEREST_CODE_ID_3 NUMBER,
1300 p_INVENTORY_ITEM_ID_3 NUMBER,
1301 p_ORGANIZATION_ID_3 NUMBER,
1302 p_UOM_CODE_3 VARCHAR2,
1303 p_QUANTITY_3 NUMBER,
1304 p_BUDGET_AMOUNT_3 NUMBER,
1305 p_STATUS_CODE_4 VARCHAR2,
1306 p_INTEREST_TYPE_ID_4 NUMBER,
1307 p_PRIMARY_INTEREST_CODE_ID_4 NUMBER,
1308 p_SECONDARY_INTEREST_CODE_ID_4 NUMBER,
1309 p_INVENTORY_ITEM_ID_4 NUMBER,
1310 p_ORGANIZATION_ID_4 NUMBER,
1311 p_UOM_CODE_4 VARCHAR2,
1312 p_QUANTITY_4 NUMBER,
1313 p_BUDGET_AMOUNT_4 NUMBER,
1314 p_STATUS_CODE_5 VARCHAR2,
1315 p_INTEREST_TYPE_ID_5 NUMBER,
1316 p_PRIMARY_INTEREST_CODE_ID_5 NUMBER,
1317 p_SECONDARY_INTEREST_CODE_ID_5 NUMBER,
1318 p_INVENTORY_ITEM_ID_5 NUMBER,
1319 p_ORGANIZATION_ID_5 NUMBER,
1320 p_UOM_CODE_5 VARCHAR2,
1321 p_QUANTITY_5 NUMBER,
1322 p_BUDGET_AMOUNT_5 NUMBER,
1323 p_INTERACTION_NOTES_1 VARCHAR2,
1324 p_PRIORITY_1 NUMBER,
1325 p_TODO_DATE_1 DATE,
1326 p_TODO_START_TIME_1 VARCHAR2,
1327 p_ACTIVITY_CODE_1 VARCHAR2,
1328 p_INTERACTION_NOTES_2 VARCHAR2,
1329 p_PRIORITY_2 NUMBER,
1330 p_TODO_DATE_2 DATE,
1331 p_TODO_START_TIME_2 VARCHAR2,
1332 p_ACTIVITY_CODE_2 VARCHAR2,
1333 p_INTERACTION_NOTES_3 VARCHAR2,
1334 p_PRIORITY_3 NUMBER,
1335 p_TODO_DATE_3 DATE,
1336 p_TODO_START_TIME_3 VARCHAR2,
1337 p_ACTIVITY_CODE_3 VARCHAR2,
1338 p_INTERACTION_NOTES_4 VARCHAR2,
1339 p_PRIORITY_4 NUMBER,
1340 p_TODO_DATE_4 DATE,
1341 p_TODO_START_TIME_4 VARCHAR2,
1342 p_ACTIVITY_CODE_4 VARCHAR2,
1343 p_INTERACTION_NOTES_5 VARCHAR2,
1344 p_PRIORITY_5 NUMBER,
1345 p_TODO_DATE_5 DATE,
1346 p_TODO_START_TIME_5 VARCHAR2,
1347 p_ACTIVITY_CODE_5 VARCHAR2,
1348 p_INTERACTION_NOTES_6 VARCHAR2,
1349 p_PRIORITY_6 NUMBER,
1350 p_TODO_DATE_6 DATE,
1351 p_TODO_START_TIME_6 VARCHAR2,
1352 p_ACTIVITY_CODE_6 VARCHAR2,
1353 p_INTERACTION_NOTES_7 VARCHAR2,
1354 p_PRIORITY_7 NUMBER,
1355 p_TODO_DATE_7 DATE,
1356 p_TODO_START_TIME_7 VARCHAR2,
1357 p_ACTIVITY_CODE_7 VARCHAR2,
1358 p_INTERACTION_NOTES_8 VARCHAR2,
1359 p_PRIORITY_8 NUMBER,
1360 p_TODO_DATE_8 DATE,
1361 p_TODO_START_TIME_8 VARCHAR2,
1362 p_ACTIVITY_CODE_8 VARCHAR2,
1363 p_INTERACTION_NOTES_9 VARCHAR2,
1364 p_PRIORITY_9 NUMBER,
1365 p_TODO_DATE_9 DATE,
1366 p_TODO_START_TIME_9 VARCHAR2,
1367 p_ACTIVITY_CODE_9 VARCHAR2,
1368 p_INTERACTION_NOTES_10 VARCHAR2,
1369 p_PRIORITY_10 NUMBER,
1370 p_TODO_DATE_10 DATE,
1371 p_TODO_START_TIME_10 VARCHAR2,
1372 p_ACTIVITY_CODE_10 VARCHAR2,
1373 p_LEAD_NOTE VARCHAR2,
1374 p_MIDDLE_INITIAL VARCHAR2,
1375 p_FAX_NUMBER VARCHAR2,
1376 p_FAX_AREA_CODE VARCHAR2,
1377 p_MAIL_STOP VARCHAR2,
1378 p_NUM_ENROLLED NUMBER,
1379 p_CONFIRMED_FLAG VARCHAR2,
1380 p_PAYMENT_AMOUNT NUMBER,
1381 p_NUM_ATTENDED NUMBER,
1382 p_PROMOTION_NAME VARCHAR2,
1383 p_STATUS_CHANGE_FLAG VARCHAR2,
1384 p_VEHICLE_RESPONSE_CODE VARCHAR2,
1385 p_SOURCE_SYSTEM VARCHAR2,
1386 p_CONTACT_PARTY_ID NUMBER,
1387 p_PRM_SALES_LEAD_TYPE VARCHAR2,
1388 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
1389 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
1390 p_INC_PARTNER_PARTY_ID NUMBER,
1391 p_INC_PARTNER_RESOURCE_ID NUMBER,
1392 p_OFFER_ID NUMBER,
1393 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
1394 p_PARTY_TYPE VARCHAR2,
1395 p_BATCH_ID NUMBER,
1396 p_PARTY_ID NUMBER,
1397 p_PARTY_SITE_ID NUMBER,
1398 p_LOCATION_ID NUMBER,
1399 p_REL_PARTY_ID NUMBER,
1400 p_SALES_LEAD_ID NUMBER,
1401 p_ADDRESS_KEY VARCHAR2,
1402 p_CONTACT_KEY VARCHAR2,
1403 p_JOB_TITLE_CODE VARCHAR2,
1404 p_DO_NOT_PHONE_FLAG VARCHAR2,
1405 p_DO_NOT_FAX_FLAG VARCHAR2,
1406 p_DO_NOT_EMAIL_FLAG VARCHAR2,
1407 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
1408 p_LEAD_RANK_ID NUMBER,
1409 p_NEW_PARTY_FLAG NUMBER,
1410 p_NEW_LOC_FLAG NUMBER,
1411 p_NEW_PS_FLAG NUMBER,
1412 p_NEW_REL_FLAG NUMBER,
1413 p_NEW_CON_FLAG NUMBER,
1414 p_ORIG_SYSTEM_CODE VARCHAR2,
1418 p_PRIMARY_CONTACT_FLAG VARCHAR2,
1415 p_URGENT_FLAG VARCHAR2,
1416 p_SIC_CODE_TYPE VARCHAR2,
1417 p_SITE_USE_TYPE VARCHAR2,
1419 p_RANK VARCHAR2,
1420 p_ADDRESS_STYLE VARCHAR2,
1421 p_PRIMARY_PER_TYPE VARCHAR2,
1422 p_DEPARTMENT_CODE VARCHAR2,
1423 p_SALES_FORCE_ID NUMBER,
1424 p_GROUP_ID NUMBER,
1425 p_PERSON_ID NUMBER,
1426 p_CATEGORY_ID1 NUMBER DEFAULT NULL,
1427 p_CATEGORY_ID2 NUMBER DEFAULT NULL,
1428 p_CATEGORY_ID3 NUMBER DEFAULT NULL,
1429 p_CATEGORY_ID4 NUMBER DEFAULT NULL,
1430 p_CATEGORY_ID5 NUMBER DEFAULT NULL)
1431
1432
1433 IS
1434 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
1435
1436
1437 BEGIN
1438 Update AS_IMPORT_INTERFACE
1439 SET
1440 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, rosetta_g_mistake_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
1441 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
1442 CREATION_DATE = decode( p_CREATION_DATE, rosetta_g_mistake_date, CREATION_DATE, p_CREATION_DATE),
1443 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
1444 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
1445 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
1446 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
1447 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
1448 PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, rosetta_g_mistake_date, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
1449 IMP_LIST_HEADER_NUMBER = decode( p_IMP_LIST_HEADER_NUMBER, FND_API.G_MISS_CHAR, IMP_LIST_HEADER_NUMBER, p_IMP_LIST_HEADER_NUMBER),
1450 LOAD_TYPE = decode( p_LOAD_TYPE, FND_API.G_MISS_CHAR, LOAD_TYPE, p_LOAD_TYPE),
1451 LOAD_DATE = decode( p_LOAD_DATE, rosetta_g_mistake_date, LOAD_DATE, p_LOAD_DATE),
1452 LOAD_STATUS = decode( p_LOAD_STATUS, FND_API.G_MISS_CHAR, LOAD_STATUS, p_LOAD_STATUS),
1453 LOAD_ERROR_MESSAGE = decode( p_LOAD_ERROR_MESSAGE, FND_API.G_MISS_CHAR, LOAD_ERROR_MESSAGE, p_LOAD_ERROR_MESSAGE),
1454 PROMOTION_ID = decode( p_PROMOTION_ID, FND_API.G_MISS_NUM, PROMOTION_ID, p_PROMOTION_ID),
1455 PROMOTION_CODE = decode( p_PROMOTION_CODE, FND_API.G_MISS_CHAR, PROMOTION_CODE, p_PROMOTION_CODE),
1456 CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),
1457 CUSTOMER_NAME = decode( p_CUSTOMER_NAME, FND_API.G_MISS_CHAR, CUSTOMER_NAME, p_CUSTOMER_NAME),
1458 CUSTOMER_NUMBER = decode( p_CUSTOMER_NUMBER, FND_API.G_MISS_CHAR, CUSTOMER_NUMBER, p_CUSTOMER_NUMBER),
1459 CUSTOMER_STATUS = decode( p_CUSTOMER_STATUS, FND_API.G_MISS_CHAR, CUSTOMER_STATUS, p_CUSTOMER_STATUS),
1460 CUSTOMER_TYPE = decode( p_CUSTOMER_TYPE, FND_API.G_MISS_CHAR, CUSTOMER_TYPE, p_CUSTOMER_TYPE),
1461 CUSTOMER_PROSPECT_CODE = decode( p_CUSTOMER_PROSPECT_CODE, FND_API.G_MISS_CHAR, CUSTOMER_PROSPECT_CODE, p_CUSTOMER_PROSPECT_CODE),
1462 CUSTOMER_CLASS_CODE = decode( p_CUSTOMER_CLASS_CODE, FND_API.G_MISS_CHAR, CUSTOMER_CLASS_CODE, p_CUSTOMER_CLASS_CODE),
1463 SALES_CHANNEL_CODE = decode( p_SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR, SALES_CHANNEL_CODE, p_SALES_CHANNEL_CODE),
1464 SIC_CODE = decode( p_SIC_CODE, FND_API.G_MISS_CHAR, SIC_CODE, p_SIC_CODE),
1465 ANALYSIS_FY = decode( p_ANALYSIS_FY, FND_API.G_MISS_CHAR, ANALYSIS_FY, p_ANALYSIS_FY),
1466 CUSTOMER_CATEGORY_CODE = decode( p_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, CUSTOMER_CATEGORY_CODE, p_CUSTOMER_CATEGORY_CODE),
1467 CUSTOMER_GROUP_CODE = decode( p_CUSTOMER_GROUP_CODE, FND_API.G_MISS_CHAR, CUSTOMER_GROUP_CODE, p_CUSTOMER_GROUP_CODE),
1468 CUSTOMER_KEY = decode( p_CUSTOMER_KEY, FND_API.G_MISS_CHAR, CUSTOMER_KEY, p_CUSTOMER_KEY),
1469 CUSTOMER_SUBGROUP_CODE = decode( p_CUSTOMER_SUBGROUP_CODE, FND_API.G_MISS_CHAR, CUSTOMER_SUBGROUP_CODE, p_CUSTOMER_SUBGROUP_CODE),
1470 FISCAL_YEAREND_MONTH = decode( p_FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, FISCAL_YEAREND_MONTH, p_FISCAL_YEAREND_MONTH),
1471 NET_WORTH = decode( p_NET_WORTH, FND_API.G_MISS_NUM, NET_WORTH, p_NET_WORTH),
1472 NUM_OF_EMPLOYEES = decode( p_NUM_OF_EMPLOYEES, FND_API.G_MISS_NUM, NUM_OF_EMPLOYEES, p_NUM_OF_EMPLOYEES),
1473 POTENTIAL_REVENUE_CURR_FY = decode( p_POTENTIAL_REVENUE_CURR_FY, FND_API.G_MISS_NUM, POTENTIAL_REVENUE_CURR_FY, p_POTENTIAL_REVENUE_CURR_FY),
1474 POTENTIAL_REVENUE_NEXT_FY = decode( p_POTENTIAL_REVENUE_NEXT_FY, FND_API.G_MISS_NUM, POTENTIAL_REVENUE_NEXT_FY, p_POTENTIAL_REVENUE_NEXT_FY),
1475 CUSTOMER_RANK = decode( p_CUSTOMER_RANK, FND_API.G_MISS_CHAR, CUSTOMER_RANK, p_CUSTOMER_RANK),
1476 REFERENCE_USE_FLAG = decode( p_REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, REFERENCE_USE_FLAG, p_REFERENCE_USE_FLAG),
1477 TAX_CODE = decode( p_TAX_CODE, FND_API.G_MISS_CHAR, TAX_CODE, p_TAX_CODE),
1478 TAX_REFERENCE = decode( p_TAX_REFERENCE, FND_API.G_MISS_CHAR, TAX_REFERENCE, p_TAX_REFERENCE),
1479 THIRD_PARTY_FLAG = decode( p_THIRD_PARTY_FLAG, FND_API.G_MISS_CHAR, THIRD_PARTY_FLAG, p_THIRD_PARTY_FLAG),
1480 COMPETITOR_FLAG = decode( p_COMPETITOR_FLAG, FND_API.G_MISS_CHAR, COMPETITOR_FLAG, p_COMPETITOR_FLAG),
1481 YEAR_ESTABLISHED = decode( p_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, YEAR_ESTABLISHED, p_YEAR_ESTABLISHED),
1482 ADDR_DO_NOT_MAIL_FLAG = decode( p_ADDR_DO_NOT_MAIL_FLAG, FND_API.G_MISS_CHAR, ADDR_DO_NOT_MAIL_FLAG, p_ADDR_DO_NOT_MAIL_FLAG),
1483 URL = decode( p_URL, FND_API.G_MISS_CHAR, URL, p_URL),
1484 ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID, p_ADDRESS_ID),
1488 ADDRESS1 = decode( p_ADDRESS1, FND_API.G_MISS_CHAR, ADDRESS1, p_ADDRESS1),
1485 CONT_DO_NOT_MAIL_FLAG = decode( p_CONT_DO_NOT_MAIL_FLAG, FND_API.G_MISS_CHAR, CONT_DO_NOT_MAIL_FLAG, p_CONT_DO_NOT_MAIL_FLAG),
1486 ADDRESS_STATUS = decode( p_ADDRESS_STATUS, FND_API.G_MISS_CHAR, ADDRESS_STATUS, p_ADDRESS_STATUS),
1487 COUNTRY = decode( p_COUNTRY, FND_API.G_MISS_CHAR, COUNTRY, p_COUNTRY),
1489 ADDRESS2 = decode( p_ADDRESS2, FND_API.G_MISS_CHAR, ADDRESS2, p_ADDRESS2),
1490 ADDRESS3 = decode( p_ADDRESS3, FND_API.G_MISS_CHAR, ADDRESS3, p_ADDRESS3),
1491 ADDRESS4 = decode( p_ADDRESS4, FND_API.G_MISS_CHAR, ADDRESS4, p_ADDRESS4),
1492 CITY = decode( p_CITY, FND_API.G_MISS_CHAR, CITY, p_CITY),
1493 POSTAL_CODE = decode( p_POSTAL_CODE, FND_API.G_MISS_CHAR, POSTAL_CODE, p_POSTAL_CODE),
1494 STATE = decode( p_STATE, FND_API.G_MISS_CHAR, STATE, p_STATE),
1495 PROVINCE = decode( p_PROVINCE, FND_API.G_MISS_CHAR, PROVINCE, p_PROVINCE),
1496 COUNTY = decode( p_COUNTY, FND_API.G_MISS_CHAR, COUNTY, p_COUNTY),
1497 SITE_CONTACT_ID = decode( p_SITE_CONTACT_ID, FND_API.G_MISS_NUM, SITE_CONTACT_ID, p_SITE_CONTACT_ID),
1498 EMAIL_ADDRESS = decode( p_EMAIL_ADDRESS, FND_API.G_MISS_CHAR, EMAIL_ADDRESS, p_EMAIL_ADDRESS),
1499 SEX_CODE = decode( p_SEX_CODE, FND_API.G_MISS_CHAR, SEX_CODE, p_SEX_CODE),
1500 SALUTATION = decode( p_SALUTATION, FND_API.G_MISS_CHAR, SALUTATION, p_SALUTATION),
1501 LAST_NAME = decode( p_LAST_NAME, FND_API.G_MISS_CHAR, LAST_NAME, p_LAST_NAME),
1502 TITLE = decode( p_TITLE, FND_API.G_MISS_CHAR, TITLE, p_TITLE),
1503 FIRST_NAME = decode( p_FIRST_NAME, FND_API.G_MISS_CHAR, FIRST_NAME, p_FIRST_NAME),
1504 JOB_TITLE = decode( p_JOB_TITLE, FND_API.G_MISS_CHAR, JOB_TITLE, p_JOB_TITLE),
1505 PHONE_ID = decode( p_PHONE_ID, FND_API.G_MISS_NUM, PHONE_ID, p_PHONE_ID),
1506 PHONE_NUMBER = decode( p_PHONE_NUMBER, FND_API.G_MISS_CHAR, PHONE_NUMBER, p_PHONE_NUMBER),
1507 PHONE_STATUS = decode( p_PHONE_STATUS, FND_API.G_MISS_CHAR, PHONE_STATUS, p_PHONE_STATUS),
1508 PHONE_TYPE = decode( p_PHONE_TYPE, FND_API.G_MISS_CHAR, PHONE_TYPE, p_PHONE_TYPE),
1509 AREA_CODE = decode( p_AREA_CODE, FND_API.G_MISS_CHAR, AREA_CODE, p_AREA_CODE),
1510 EXTENSION = decode( p_EXTENSION, FND_API.G_MISS_CHAR, EXTENSION, p_EXTENSION),
1511 LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER, p_LEAD_NUMBER),
1512 STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
1513 SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID, p_SOURCE_PROMOTION_ID),
1514 INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, INITIATING_CONTACT_ID, p_INITIATING_CONTACT_ID),
1515 CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR, CONTACT_ROLE_CODE, p_CONTACT_ROLE_CODE),
1516 CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, p_CHANNEL_CODE),
1517 BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, BUDGET_AMOUNT, p_BUDGET_AMOUNT),
1518 BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
1519 CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
1520 DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE),
1521 CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, CLOSE_REASON, p_CLOSE_REASON),
1522 LEAD_RANK_CODE = decode( p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR, LEAD_RANK_CODE, p_LEAD_RANK_CODE),
1523 PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, PARENT_PROJECT, p_PARENT_PROJECT),
1524 DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
1525 STATUS_CODE_1 = decode( p_STATUS_CODE_1, FND_API.G_MISS_CHAR, STATUS_CODE_1, p_STATUS_CODE_1),
1526 INTEREST_TYPE_ID_1 = decode( p_INTEREST_TYPE_ID_1, FND_API.G_MISS_NUM, INTEREST_TYPE_ID_1, p_INTEREST_TYPE_ID_1),
1527 PRIMARY_INTEREST_CODE_ID_1 = decode( p_PRIMARY_INTEREST_CODE_ID_1, FND_API.G_MISS_NUM, PRIMARY_INTEREST_CODE_ID_1, p_PRIMARY_INTEREST_CODE_ID_1),
1528 SECONDARY_INTEREST_CODE_ID_1 = decode( p_SECONDARY_INTEREST_CODE_ID_1, FND_API.G_MISS_NUM, SECONDARY_INTEREST_CODE_ID_1, p_SECONDARY_INTEREST_CODE_ID_1),
1529 INVENTORY_ITEM_ID_1 = decode( p_INVENTORY_ITEM_ID_1, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID_1, p_INVENTORY_ITEM_ID_1),
1530 ORGANIZATION_ID_1 = decode( p_ORGANIZATION_ID_1, FND_API.G_MISS_NUM, ORGANIZATION_ID_1, p_ORGANIZATION_ID_1),
1531 UOM_CODE_1 = decode( p_UOM_CODE_1, FND_API.G_MISS_CHAR, UOM_CODE_1, p_UOM_CODE_1),
1532 QUANTITY_1 = decode( p_QUANTITY_1, FND_API.G_MISS_NUM, QUANTITY_1, p_QUANTITY_1),
1533 BUDGET_AMOUNT_1 = decode( p_BUDGET_AMOUNT_1, FND_API.G_MISS_NUM, BUDGET_AMOUNT_1, p_BUDGET_AMOUNT_1),
1534 STATUS_CODE_2 = decode( p_STATUS_CODE_2, FND_API.G_MISS_CHAR, STATUS_CODE_2, p_STATUS_CODE_2),
1535 INTEREST_TYPE_ID_2 = decode( p_INTEREST_TYPE_ID_2, FND_API.G_MISS_NUM, INTEREST_TYPE_ID_2, p_INTEREST_TYPE_ID_2),
1536 PRIMARY_INTEREST_CODE_ID_2 = decode( p_PRIMARY_INTEREST_CODE_ID_2, FND_API.G_MISS_NUM, PRIMARY_INTEREST_CODE_ID_2, p_PRIMARY_INTEREST_CODE_ID_2),
1537 SECONDARY_INTEREST_CODE_ID_2 = decode( p_SECONDARY_INTEREST_CODE_ID_2, FND_API.G_MISS_NUM, SECONDARY_INTEREST_CODE_ID_2, p_SECONDARY_INTEREST_CODE_ID_2),
1538 INVENTORY_ITEM_ID_2 = decode( p_INVENTORY_ITEM_ID_2, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID_2, p_INVENTORY_ITEM_ID_2),
1539 ORGANIZATION_ID_2 = decode( p_ORGANIZATION_ID_2, FND_API.G_MISS_NUM, ORGANIZATION_ID_2, p_ORGANIZATION_ID_2),
1540 UOM_CODE_2 = decode( p_UOM_CODE_2, FND_API.G_MISS_CHAR, UOM_CODE_2, p_UOM_CODE_2),
1544 INTEREST_TYPE_ID_3 = decode( p_INTEREST_TYPE_ID_3, FND_API.G_MISS_NUM, INTEREST_TYPE_ID_3, p_INTEREST_TYPE_ID_3),
1541 QUANTITY_2 = decode( p_QUANTITY_2, FND_API.G_MISS_NUM, QUANTITY_2, p_QUANTITY_2),
1542 BUDGET_AMOUNT_2 = decode( p_BUDGET_AMOUNT_2, FND_API.G_MISS_NUM, BUDGET_AMOUNT_2, p_BUDGET_AMOUNT_2),
1543 STATUS_CODE_3 = decode( p_STATUS_CODE_3, FND_API.G_MISS_CHAR, STATUS_CODE_3, p_STATUS_CODE_3),
1545 PRIMARY_INTEREST_CODE_ID_3 = decode( p_PRIMARY_INTEREST_CODE_ID_3, FND_API.G_MISS_NUM, PRIMARY_INTEREST_CODE_ID_3, p_PRIMARY_INTEREST_CODE_ID_3),
1546 SECONDARY_INTEREST_CODE_ID_3 = decode( p_SECONDARY_INTEREST_CODE_ID_3, FND_API.G_MISS_NUM, SECONDARY_INTEREST_CODE_ID_3, p_SECONDARY_INTEREST_CODE_ID_3),
1547 INVENTORY_ITEM_ID_3 = decode( p_INVENTORY_ITEM_ID_3, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID_3, p_INVENTORY_ITEM_ID_3),
1548 ORGANIZATION_ID_3 = decode( p_ORGANIZATION_ID_3, FND_API.G_MISS_NUM, ORGANIZATION_ID_3, p_ORGANIZATION_ID_3),
1549 UOM_CODE_3 = decode( p_UOM_CODE_3, FND_API.G_MISS_CHAR, UOM_CODE_3, p_UOM_CODE_3),
1550 QUANTITY_3 = decode( p_QUANTITY_3, FND_API.G_MISS_NUM, QUANTITY_3, p_QUANTITY_3),
1551 BUDGET_AMOUNT_3 = decode( p_BUDGET_AMOUNT_3, FND_API.G_MISS_NUM, BUDGET_AMOUNT_3, p_BUDGET_AMOUNT_3),
1552 STATUS_CODE_4 = decode( p_STATUS_CODE_4, FND_API.G_MISS_CHAR, STATUS_CODE_4, p_STATUS_CODE_4),
1553 INTEREST_TYPE_ID_4 = decode( p_INTEREST_TYPE_ID_4, FND_API.G_MISS_NUM, INTEREST_TYPE_ID_4, p_INTEREST_TYPE_ID_4),
1554 PRIMARY_INTEREST_CODE_ID_4 = decode( p_PRIMARY_INTEREST_CODE_ID_4, FND_API.G_MISS_NUM, PRIMARY_INTEREST_CODE_ID_4, p_PRIMARY_INTEREST_CODE_ID_4),
1555 SECONDARY_INTEREST_CODE_ID_4 = decode( p_SECONDARY_INTEREST_CODE_ID_4, FND_API.G_MISS_NUM, SECONDARY_INTEREST_CODE_ID_4, p_SECONDARY_INTEREST_CODE_ID_4),
1556 INVENTORY_ITEM_ID_4 = decode( p_INVENTORY_ITEM_ID_4, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID_4, p_INVENTORY_ITEM_ID_4),
1557 ORGANIZATION_ID_4 = decode( p_ORGANIZATION_ID_4, FND_API.G_MISS_NUM, ORGANIZATION_ID_4, p_ORGANIZATION_ID_4),
1558 UOM_CODE_4 = decode( p_UOM_CODE_4, FND_API.G_MISS_CHAR, UOM_CODE_4, p_UOM_CODE_4),
1559 QUANTITY_4 = decode( p_QUANTITY_4, FND_API.G_MISS_NUM, QUANTITY_4, p_QUANTITY_4),
1560 BUDGET_AMOUNT_4 = decode( p_BUDGET_AMOUNT_4, FND_API.G_MISS_NUM, BUDGET_AMOUNT_4, p_BUDGET_AMOUNT_4),
1561 STATUS_CODE_5 = decode( p_STATUS_CODE_5, FND_API.G_MISS_CHAR, STATUS_CODE_5, p_STATUS_CODE_5),
1562 INTEREST_TYPE_ID_5 = decode( p_INTEREST_TYPE_ID_5, FND_API.G_MISS_NUM, INTEREST_TYPE_ID_5, p_INTEREST_TYPE_ID_5),
1563 PRIMARY_INTEREST_CODE_ID_5 = decode( p_PRIMARY_INTEREST_CODE_ID_5, FND_API.G_MISS_NUM, PRIMARY_INTEREST_CODE_ID_5, p_PRIMARY_INTEREST_CODE_ID_5),
1564 SECONDARY_INTEREST_CODE_ID_5 = decode( p_SECONDARY_INTEREST_CODE_ID_5, FND_API.G_MISS_NUM, SECONDARY_INTEREST_CODE_ID_5, p_SECONDARY_INTEREST_CODE_ID_5),
1565 INVENTORY_ITEM_ID_5 = decode( p_INVENTORY_ITEM_ID_5, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID_5, p_INVENTORY_ITEM_ID_5),
1566 ORGANIZATION_ID_5 = decode( p_ORGANIZATION_ID_5, FND_API.G_MISS_NUM, ORGANIZATION_ID_5, p_ORGANIZATION_ID_5),
1567 UOM_CODE_5 = decode( p_UOM_CODE_5, FND_API.G_MISS_CHAR, UOM_CODE_5, p_UOM_CODE_5),
1568 QUANTITY_5 = decode( p_QUANTITY_5, FND_API.G_MISS_NUM, QUANTITY_5, p_QUANTITY_5),
1569 BUDGET_AMOUNT_5 = decode( p_BUDGET_AMOUNT_5, FND_API.G_MISS_NUM, BUDGET_AMOUNT_5, p_BUDGET_AMOUNT_5),
1570 INTERACTION_NOTES_1 = decode( p_INTERACTION_NOTES_1, FND_API.G_MISS_CHAR, INTERACTION_NOTES_1, p_INTERACTION_NOTES_1),
1571 PRIORITY_1 = decode( p_PRIORITY_1, FND_API.G_MISS_NUM, PRIORITY_1, p_PRIORITY_1),
1572 TODO_DATE_1 = decode( p_TODO_DATE_1, rosetta_g_mistake_date, TODO_DATE_1, p_TODO_DATE_1),
1573 TODO_START_TIME_1 = decode( p_TODO_START_TIME_1, FND_API.G_MISS_CHAR, TODO_START_TIME_1, p_TODO_START_TIME_1),
1574 ACTIVITY_CODE_1 = decode( p_ACTIVITY_CODE_1, FND_API.G_MISS_CHAR, ACTIVITY_CODE_1, p_ACTIVITY_CODE_1),
1575 INTERACTION_NOTES_2 = decode( p_INTERACTION_NOTES_2, FND_API.G_MISS_CHAR, INTERACTION_NOTES_2, p_INTERACTION_NOTES_2),
1576 PRIORITY_2 = decode( p_PRIORITY_2, FND_API.G_MISS_NUM, PRIORITY_2, p_PRIORITY_2),
1577 TODO_DATE_2 = decode( p_TODO_DATE_2, rosetta_g_mistake_date, TODO_DATE_2, p_TODO_DATE_2),
1578 TODO_START_TIME_2 = decode( p_TODO_START_TIME_2, FND_API.G_MISS_CHAR, TODO_START_TIME_2, p_TODO_START_TIME_2),
1579 ACTIVITY_CODE_2 = decode( p_ACTIVITY_CODE_2, FND_API.G_MISS_CHAR, ACTIVITY_CODE_2, p_ACTIVITY_CODE_2),
1580 INTERACTION_NOTES_3 = decode( p_INTERACTION_NOTES_3, FND_API.G_MISS_CHAR, INTERACTION_NOTES_3, p_INTERACTION_NOTES_3),
1581 PRIORITY_3 = decode( p_PRIORITY_3, FND_API.G_MISS_NUM, PRIORITY_3, p_PRIORITY_3),
1582 TODO_DATE_3 = decode( p_TODO_DATE_3, rosetta_g_mistake_date, TODO_DATE_3, p_TODO_DATE_3),
1583 TODO_START_TIME_3 = decode( p_TODO_START_TIME_3, FND_API.G_MISS_CHAR, TODO_START_TIME_3, p_TODO_START_TIME_3),
1584 ACTIVITY_CODE_3 = decode( p_ACTIVITY_CODE_3, FND_API.G_MISS_CHAR, ACTIVITY_CODE_3, p_ACTIVITY_CODE_3),
1585 INTERACTION_NOTES_4 = decode( p_INTERACTION_NOTES_4, FND_API.G_MISS_CHAR, INTERACTION_NOTES_4, p_INTERACTION_NOTES_4),
1586 PRIORITY_4 = decode( p_PRIORITY_4, FND_API.G_MISS_NUM, PRIORITY_4, p_PRIORITY_4),
1587 TODO_DATE_4 = decode( p_TODO_DATE_4, rosetta_g_mistake_date, TODO_DATE_4, p_TODO_DATE_4),
1588 TODO_START_TIME_4 = decode( p_TODO_START_TIME_4, FND_API.G_MISS_CHAR, TODO_START_TIME_4, p_TODO_START_TIME_4),
1589 ACTIVITY_CODE_4 = decode( p_ACTIVITY_CODE_4, FND_API.G_MISS_CHAR, ACTIVITY_CODE_4, p_ACTIVITY_CODE_4),
1590 INTERACTION_NOTES_5 = decode( p_INTERACTION_NOTES_5, FND_API.G_MISS_CHAR, INTERACTION_NOTES_5, p_INTERACTION_NOTES_5),
1591 PRIORITY_5 = decode( p_PRIORITY_5, FND_API.G_MISS_NUM, PRIORITY_5, p_PRIORITY_5),
1592 TODO_DATE_5 = decode( p_TODO_DATE_5, rosetta_g_mistake_date, TODO_DATE_5, p_TODO_DATE_5),
1596 PRIORITY_6 = decode( p_PRIORITY_6, FND_API.G_MISS_NUM, PRIORITY_6, p_PRIORITY_6),
1593 TODO_START_TIME_5 = decode( p_TODO_START_TIME_5, FND_API.G_MISS_CHAR, TODO_START_TIME_5, p_TODO_START_TIME_5),
1594 ACTIVITY_CODE_5 = decode( p_ACTIVITY_CODE_5, FND_API.G_MISS_CHAR, ACTIVITY_CODE_5, p_ACTIVITY_CODE_5),
1595 INTERACTION_NOTES_6 = decode( p_INTERACTION_NOTES_6, FND_API.G_MISS_CHAR, INTERACTION_NOTES_6, p_INTERACTION_NOTES_6),
1597 TODO_DATE_6 = decode( p_TODO_DATE_6, rosetta_g_mistake_date, TODO_DATE_6, p_TODO_DATE_6),
1598 TODO_START_TIME_6 = decode( p_TODO_START_TIME_6, FND_API.G_MISS_CHAR, TODO_START_TIME_6, p_TODO_START_TIME_6),
1599 ACTIVITY_CODE_6 = decode( p_ACTIVITY_CODE_6, FND_API.G_MISS_CHAR, ACTIVITY_CODE_6, p_ACTIVITY_CODE_6),
1600 INTERACTION_NOTES_7 = decode( p_INTERACTION_NOTES_7, FND_API.G_MISS_CHAR, INTERACTION_NOTES_7, p_INTERACTION_NOTES_7),
1601 PRIORITY_7 = decode( p_PRIORITY_7, FND_API.G_MISS_NUM, PRIORITY_7, p_PRIORITY_7),
1602 TODO_DATE_7 = decode( p_TODO_DATE_7, rosetta_g_mistake_date, TODO_DATE_7, p_TODO_DATE_7),
1603 TODO_START_TIME_7 = decode( p_TODO_START_TIME_7, FND_API.G_MISS_CHAR, TODO_START_TIME_7, p_TODO_START_TIME_7),
1604 ACTIVITY_CODE_7 = decode( p_ACTIVITY_CODE_7, FND_API.G_MISS_CHAR, ACTIVITY_CODE_7, p_ACTIVITY_CODE_7),
1605 INTERACTION_NOTES_8 = decode( p_INTERACTION_NOTES_8, FND_API.G_MISS_CHAR, INTERACTION_NOTES_8, p_INTERACTION_NOTES_8),
1606 PRIORITY_8 = decode( p_PRIORITY_8, FND_API.G_MISS_NUM, PRIORITY_8, p_PRIORITY_8),
1607 TODO_DATE_8 = decode( p_TODO_DATE_8, rosetta_g_mistake_date, TODO_DATE_8, p_TODO_DATE_8),
1608 TODO_START_TIME_8 = decode( p_TODO_START_TIME_8, FND_API.G_MISS_CHAR, TODO_START_TIME_8, p_TODO_START_TIME_8),
1609 ACTIVITY_CODE_8 = decode( p_ACTIVITY_CODE_8, FND_API.G_MISS_CHAR, ACTIVITY_CODE_8, p_ACTIVITY_CODE_8),
1610 INTERACTION_NOTES_9 = decode( p_INTERACTION_NOTES_9, FND_API.G_MISS_CHAR, INTERACTION_NOTES_9, p_INTERACTION_NOTES_9),
1611 PRIORITY_9 = decode( p_PRIORITY_9, FND_API.G_MISS_NUM, PRIORITY_9, p_PRIORITY_9),
1612 TODO_DATE_9 = decode( p_TODO_DATE_9, rosetta_g_mistake_date, TODO_DATE_9, p_TODO_DATE_9),
1613 TODO_START_TIME_9 = decode( p_TODO_START_TIME_9, FND_API.G_MISS_CHAR, TODO_START_TIME_9, p_TODO_START_TIME_9),
1614 ACTIVITY_CODE_9 = decode( p_ACTIVITY_CODE_9, FND_API.G_MISS_CHAR, ACTIVITY_CODE_9, p_ACTIVITY_CODE_9),
1615 INTERACTION_NOTES_10 = decode( p_INTERACTION_NOTES_10, FND_API.G_MISS_CHAR, INTERACTION_NOTES_10, p_INTERACTION_NOTES_10),
1616 PRIORITY_10 = decode( p_PRIORITY_10, FND_API.G_MISS_NUM, PRIORITY_10, p_PRIORITY_10),
1617 TODO_DATE_10 = decode( p_TODO_DATE_10, rosetta_g_mistake_date, TODO_DATE_10, p_TODO_DATE_10),
1618 TODO_START_TIME_10 = decode( p_TODO_START_TIME_10, FND_API.G_MISS_CHAR, TODO_START_TIME_10, p_TODO_START_TIME_10),
1619 ACTIVITY_CODE_10 = decode( p_ACTIVITY_CODE_10, FND_API.G_MISS_CHAR, ACTIVITY_CODE_10, p_ACTIVITY_CODE_10),
1620 LEAD_NOTE = decode( p_LEAD_NOTE, FND_API.G_MISS_CHAR, LEAD_NOTE, p_LEAD_NOTE),
1621 MIDDLE_INITIAL = decode( p_MIDDLE_INITIAL, FND_API.G_MISS_CHAR, MIDDLE_INITIAL, p_MIDDLE_INITIAL),
1622 FAX_NUMBER = decode( p_FAX_NUMBER, FND_API.G_MISS_CHAR, FAX_NUMBER, p_FAX_NUMBER),
1623 FAX_AREA_CODE = decode( p_FAX_AREA_CODE, FND_API.G_MISS_CHAR, FAX_AREA_CODE, p_FAX_AREA_CODE),
1624 MAIL_STOP = decode( p_MAIL_STOP, FND_API.G_MISS_CHAR, MAIL_STOP, p_MAIL_STOP),
1625 NUM_ENROLLED = decode( p_NUM_ENROLLED, FND_API.G_MISS_NUM, NUM_ENROLLED, p_NUM_ENROLLED),
1626 CONFIRMED_FLAG = decode( p_CONFIRMED_FLAG, FND_API.G_MISS_CHAR, CONFIRMED_FLAG, p_CONFIRMED_FLAG),
1627 PAYMENT_AMOUNT = decode( p_PAYMENT_AMOUNT, FND_API.G_MISS_NUM, PAYMENT_AMOUNT, p_PAYMENT_AMOUNT),
1628 NUM_ATTENDED = decode( p_NUM_ATTENDED, FND_API.G_MISS_NUM, NUM_ATTENDED, p_NUM_ATTENDED),
1629 PROMOTION_NAME = decode( p_PROMOTION_NAME, FND_API.G_MISS_CHAR, PROMOTION_NAME, p_PROMOTION_NAME),
1630 STATUS_CHANGE_FLAG = decode( p_STATUS_CHANGE_FLAG, FND_API.G_MISS_CHAR, STATUS_CHANGE_FLAG, p_STATUS_CHANGE_FLAG),
1631 VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),
1632 SOURCE_SYSTEM = decode( p_SOURCE_SYSTEM, FND_API.G_MISS_CHAR, SOURCE_SYSTEM, p_SOURCE_SYSTEM),
1633 CONTACT_PARTY_ID = decode( p_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, CONTACT_PARTY_ID, p_CONTACT_PARTY_ID),
1634 PRM_SALES_LEAD_TYPE = decode( p_PRM_SALES_LEAD_TYPE, FND_API.G_MISS_CHAR, PRM_SALES_LEAD_TYPE, p_PRM_SALES_LEAD_TYPE),
1635 PRM_EXEC_SPONSOR_FLAG = decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, PRM_EXEC_SPONSOR_FLAG, p_PRM_EXEC_SPONSOR_FLAG),
1636 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),
1637 INCUMBENT_PARTNER_PARTY_ID = decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_PARTY_ID, p_INC_PARTNER_PARTY_ID),
1638 INCUMBENT_PARTNER_RESOURCE_ID = decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_RESOURCE_ID, p_INC_PARTNER_RESOURCE_ID),
1639 OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
1640 PRM_IND_CLASSIFICATION_CODE = decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, PRM_IND_CLASSIFICATION_CODE, p_PRM_IND_CLASSIFICATION_CODE),
1641 PARTY_TYPE = decode( p_PARTY_TYPE, FND_API.G_MISS_CHAR, PARTY_TYPE, p_PARTY_TYPE),
1642 BATCH_ID = decode( p_BATCH_ID, FND_API.G_MISS_NUM, BATCH_ID, p_BATCH_ID),
1643 PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
1644 PARTY_SITE_ID = decode( p_PARTY_SITE_ID, FND_API.G_MISS_NUM, PARTY_SITE_ID, p_PARTY_SITE_ID),
1645 LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
1649 CONTACT_KEY = decode( p_CONTACT_KEY, FND_API.G_MISS_CHAR, CONTACT_KEY, p_CONTACT_KEY),
1646 REL_PARTY_ID = decode( p_REL_PARTY_ID, FND_API.G_MISS_NUM, REL_PARTY_ID, p_REL_PARTY_ID),
1647 SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, SALES_LEAD_ID, p_SALES_LEAD_ID),
1648 ADDRESS_KEY = decode( p_ADDRESS_KEY, FND_API.G_MISS_CHAR, ADDRESS_KEY, p_ADDRESS_KEY),
1650 JOB_TITLE_CODE = decode( p_JOB_TITLE_CODE, FND_API.G_MISS_CHAR, JOB_TITLE_CODE, p_JOB_TITLE_CODE),
1651 DO_NOT_PHONE_FLAG = decode( p_DO_NOT_PHONE_FLAG, FND_API.G_MISS_CHAR, DO_NOT_PHONE_FLAG, p_DO_NOT_PHONE_FLAG),
1652 DO_NOT_FAX_FLAG = decode( p_DO_NOT_FAX_FLAG, FND_API.G_MISS_CHAR, DO_NOT_FAX_FLAG, p_DO_NOT_FAX_FLAG),
1653 DO_NOT_EMAIL_FLAG = decode( p_DO_NOT_EMAIL_FLAG, FND_API.G_MISS_CHAR, DO_NOT_EMAIL_FLAG, p_DO_NOT_EMAIL_FLAG),
1654 ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, p_ORIG_SYSTEM_REFERENCE),
1655 LEAD_RANK_ID = decode( p_LEAD_RANK_ID, FND_API.G_MISS_NUM, LEAD_RANK_ID, p_LEAD_RANK_ID),
1656 NEW_PARTY_FLAG = decode( p_NEW_PARTY_FLAG, FND_API.G_MISS_NUM, NEW_PARTY_FLAG, p_NEW_PARTY_FLAG),
1657 NEW_LOC_FLAG = decode( p_NEW_LOC_FLAG, FND_API.G_MISS_NUM, NEW_LOC_FLAG, p_NEW_LOC_FLAG),
1658 NEW_PS_FLAG = decode( p_NEW_PS_FLAG, FND_API.G_MISS_NUM, NEW_PS_FLAG, p_NEW_PS_FLAG),
1659 NEW_REL_FLAG = decode( p_NEW_REL_FLAG, FND_API.G_MISS_NUM, NEW_REL_FLAG, p_NEW_REL_FLAG),
1660 NEW_CON_FLAG = decode( p_NEW_CON_FLAG, FND_API.G_MISS_NUM, NEW_CON_FLAG, p_NEW_CON_FLAG),
1661 ORIG_SYSTEM_CODE = decode( p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_CODE, p_ORIG_SYSTEM_CODE),
1662 URGENT_FLAG = decode( p_URGENT_FLAG, FND_API.G_MISS_CHAR, URGENT_FLAG, p_URGENT_FLAG),
1663 SIC_CODE_TYPE = decode( p_SIC_CODE_TYPE, FND_API.G_MISS_CHAR, URGENT_FLAG, p_SIC_CODE_TYPE),
1664 SITE_USE_TYPE = decode( p_SITE_USE_TYPE, FND_API.G_MISS_CHAR, SITE_USE_TYPE, p_SITE_USE_TYPE),
1665 PRIMARY_CONTACT_FLAG = decode( p_PRIMARY_CONTACT_FLAG, FND_API.G_MISS_CHAR, PRIMARY_CONTACT_FLAG, p_PRIMARY_CONTACT_FLAG),
1666 RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
1667 ADDRESS_STYLE = decode( p_ADDRESS_STYLE, FND_API.G_MISS_CHAR, ADDRESS_STYLE, p_ADDRESS_STYLE),
1668 PRIMARY_PER_TYPE = decode( p_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, PRIMARY_PER_TYPE, p_PRIMARY_PER_TYPE),
1669 DEPARTMENT_CODE = decode( p_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, DEPARTMENT_CODE, p_DEPARTMENT_CODE),
1670 ASSIGN_TO_SALESFORCE_ID = decode( p_SALES_FORCE_ID, FND_API.G_MISS_NUM,ASSIGN_TO_SALESFORCE_ID,p_SALES_FORCE_ID),
1671 ASSIGN_SALES_GROUP_ID = decode( p_GROUP_ID, FND_API.G_MISS_NUM,ASSIGN_SALES_GROUP_ID,p_GROUP_ID),
1672 ASSIGN_TO_PERSON_ID = decode( p_PERSON_ID, FND_API.G_MISS_NUM,ASSIGN_TO_PERSON_ID,p_PERSON_ID),
1673 CATEGORY_ID_1=decode(p_CATEGORY_ID1,FND_API.G_MISS_NUM,CATEGORY_ID_1,p_CATEGORY_ID1),
1674 CATEGORY_ID_2=decode(p_CATEGORY_ID2,FND_API.G_MISS_NUM,CATEGORY_ID_2,p_CATEGORY_ID2),
1675 CATEGORY_ID_3=decode(p_CATEGORY_ID3,FND_API.G_MISS_NUM,CATEGORY_ID_3,p_CATEGORY_ID3),
1676 CATEGORY_ID_4=decode(p_CATEGORY_ID4,FND_API.G_MISS_NUM,CATEGORY_ID_4,p_CATEGORY_ID4),
1677 CATEGORY_ID_5=decode(p_CATEGORY_ID5,FND_API.G_MISS_NUM,CATEGORY_ID_5,p_CATEGORY_ID5)
1678
1679 where IMPORT_INTERFACE_ID = p_IMPORT_INTERFACE_ID;
1680
1681 If (SQL%NOTFOUND) then
1682 RAISE NO_DATA_FOUND;
1683 End If;
1684 END Update_Row;
1685
1686
1687 PROCEDURE Delete_Row(
1688 p_IMPORT_INTERFACE_ID NUMBER)
1689 IS
1690 BEGIN
1691 DELETE FROM AS_IMPORT_INTERFACE
1692 WHERE IMPORT_INTERFACE_ID = p_IMPORT_INTERFACE_ID;
1693 If (SQL%NOTFOUND) then
1694 RAISE NO_DATA_FOUND;
1695 End If;
1696 END Delete_Row;
1697
1698 PROCEDURE Lock_Row(
1699 p_IMPORT_INTERFACE_ID NUMBER,
1700 p_LAST_UPDATE_DATE DATE,
1701 p_LAST_UPDATED_BY NUMBER,
1702 p_CREATION_DATE DATE,
1703 p_CREATED_BY NUMBER,
1704 p_LAST_UPDATE_LOGIN NUMBER,
1705 p_REQUEST_ID NUMBER,
1706 p_PROGRAM_APPLICATION_ID NUMBER,
1707 p_PROGRAM_ID NUMBER,
1708 p_PROGRAM_UPDATE_DATE DATE,
1709 p_IMP_LIST_HEADER_NUMBER VARCHAR2,
1710 p_LOAD_TYPE VARCHAR2,
1711 p_LOAD_DATE DATE,
1712 p_LOAD_STATUS VARCHAR2,
1713 p_LOAD_ERROR_MESSAGE VARCHAR2,
1714 p_PROMOTION_ID NUMBER,
1715 p_PROMOTION_CODE VARCHAR2,
1716 p_CUSTOMER_ID NUMBER,
1717 p_CUSTOMER_NAME VARCHAR2,
1718 p_CUSTOMER_NUMBER VARCHAR2,
1719 p_CUSTOMER_STATUS VARCHAR2,
1720 p_CUSTOMER_TYPE VARCHAR2,
1721 p_CUSTOMER_PROSPECT_CODE VARCHAR2,
1722 p_CUSTOMER_CLASS_CODE VARCHAR2,
1723 p_SALES_CHANNEL_CODE VARCHAR2,
1724 p_SIC_CODE VARCHAR2,
1725 p_ANALYSIS_FY VARCHAR2,
1726 p_CUSTOMER_CATEGORY_CODE VARCHAR2,
1727 p_CUSTOMER_GROUP_CODE VARCHAR2,
1728 p_CUSTOMER_KEY VARCHAR2,
1729 p_CUSTOMER_SUBGROUP_CODE VARCHAR2,
1730 p_FISCAL_YEAREND_MONTH VARCHAR2,
1731 p_NET_WORTH NUMBER,
1732 p_NUM_OF_EMPLOYEES NUMBER,
1733 p_POTENTIAL_REVENUE_CURR_FY NUMBER,
1734 p_POTENTIAL_REVENUE_NEXT_FY NUMBER,
1735 p_CUSTOMER_RANK VARCHAR2,
1736 p_REFERENCE_USE_FLAG VARCHAR2,
1737 p_TAX_CODE VARCHAR2,
1738 p_TAX_REFERENCE VARCHAR2,
1739 p_THIRD_PARTY_FLAG VARCHAR2,
1740 p_COMPETITOR_FLAG VARCHAR2,
1744 p_ADDRESS_ID NUMBER,
1741 p_YEAR_ESTABLISHED NUMBER,
1742 p_ADDR_DO_NOT_MAIL_FLAG VARCHAR2,
1743 p_URL VARCHAR2,
1745 p_CONT_DO_NOT_MAIL_FLAG VARCHAR2,
1746 p_ADDRESS_STATUS VARCHAR2,
1747 p_COUNTRY VARCHAR2,
1748 p_ADDRESS1 VARCHAR2,
1749 p_ADDRESS2 VARCHAR2,
1750 p_ADDRESS3 VARCHAR2,
1751 p_ADDRESS4 VARCHAR2,
1752 p_CITY VARCHAR2,
1753 p_POSTAL_CODE VARCHAR2,
1754 p_STATE VARCHAR2,
1755 p_PROVINCE VARCHAR2,
1756 p_COUNTY VARCHAR2,
1757 p_SITE_CONTACT_ID NUMBER,
1758 p_EMAIL_ADDRESS VARCHAR2,
1759 p_SEX_CODE VARCHAR2,
1760 p_SALUTATION VARCHAR2,
1761 p_LAST_NAME VARCHAR2,
1762 p_TITLE VARCHAR2,
1763 p_FIRST_NAME VARCHAR2,
1764 p_JOB_TITLE VARCHAR2,
1765 p_PHONE_ID NUMBER,
1766 p_PHONE_NUMBER VARCHAR2,
1767 p_PHONE_STATUS VARCHAR2,
1768 p_PHONE_TYPE VARCHAR2,
1769 p_AREA_CODE VARCHAR2,
1770 p_EXTENSION VARCHAR2,
1771 p_LEAD_NUMBER VARCHAR2,
1772 p_STATUS_CODE VARCHAR2,
1773 p_SOURCE_PROMOTION_ID NUMBER,
1774 p_INITIATING_CONTACT_ID NUMBER,
1775 p_CONTACT_ROLE_CODE VARCHAR2,
1776 p_CHANNEL_CODE VARCHAR2,
1777 p_BUDGET_AMOUNT NUMBER,
1778 p_BUDGET_STATUS_CODE VARCHAR2,
1779 p_CURRENCY_CODE VARCHAR2,
1780 p_DECISION_TIMEFRAME_CODE VARCHAR2,
1781 p_CLOSE_REASON VARCHAR2,
1782 p_LEAD_RANK_CODE VARCHAR2,
1783 p_PARENT_PROJECT VARCHAR2,
1784 p_DESCRIPTION VARCHAR2,
1785 p_STATUS_CODE_1 VARCHAR2,
1786 p_INTEREST_TYPE_ID_1 NUMBER,
1787 p_PRIMARY_INTEREST_CODE_ID_1 NUMBER,
1788 p_SECONDARY_INTEREST_CODE_ID_1 NUMBER,
1789 p_INVENTORY_ITEM_ID_1 NUMBER,
1790 p_ORGANIZATION_ID_1 NUMBER,
1791 p_UOM_CODE_1 VARCHAR2,
1792 p_QUANTITY_1 NUMBER,
1793 p_BUDGET_AMOUNT_1 NUMBER,
1794 p_STATUS_CODE_2 VARCHAR2,
1795 p_INTEREST_TYPE_ID_2 NUMBER,
1796 p_PRIMARY_INTEREST_CODE_ID_2 NUMBER,
1797 p_SECONDARY_INTEREST_CODE_ID_2 NUMBER,
1798 p_INVENTORY_ITEM_ID_2 NUMBER,
1799 p_ORGANIZATION_ID_2 NUMBER,
1800 p_UOM_CODE_2 VARCHAR2,
1801 p_QUANTITY_2 NUMBER,
1802 p_BUDGET_AMOUNT_2 NUMBER,
1803 p_STATUS_CODE_3 VARCHAR2,
1804 p_INTEREST_TYPE_ID_3 NUMBER,
1805 p_PRIMARY_INTEREST_CODE_ID_3 NUMBER,
1806 p_SECONDARY_INTEREST_CODE_ID_3 NUMBER,
1807 p_INVENTORY_ITEM_ID_3 NUMBER,
1808 p_ORGANIZATION_ID_3 NUMBER,
1809 p_UOM_CODE_3 VARCHAR2,
1810 p_QUANTITY_3 NUMBER,
1811 p_BUDGET_AMOUNT_3 NUMBER,
1812 p_STATUS_CODE_4 VARCHAR2,
1813 p_INTEREST_TYPE_ID_4 NUMBER,
1814 p_PRIMARY_INTEREST_CODE_ID_4 NUMBER,
1815 p_SECONDARY_INTEREST_CODE_ID_4 NUMBER,
1816 p_INVENTORY_ITEM_ID_4 NUMBER,
1817 p_ORGANIZATION_ID_4 NUMBER,
1818 p_UOM_CODE_4 VARCHAR2,
1819 p_QUANTITY_4 NUMBER,
1820 p_BUDGET_AMOUNT_4 NUMBER,
1821 p_STATUS_CODE_5 VARCHAR2,
1822 p_INTEREST_TYPE_ID_5 NUMBER,
1823 p_PRIMARY_INTEREST_CODE_ID_5 NUMBER,
1824 p_SECONDARY_INTEREST_CODE_ID_5 NUMBER,
1825 p_INVENTORY_ITEM_ID_5 NUMBER,
1826 p_ORGANIZATION_ID_5 NUMBER,
1827 p_UOM_CODE_5 VARCHAR2,
1828 p_QUANTITY_5 NUMBER,
1829 p_BUDGET_AMOUNT_5 NUMBER,
1830 p_INTERACTION_NOTES_1 VARCHAR2,
1831 p_PRIORITY_1 NUMBER,
1832 p_TODO_DATE_1 DATE,
1833 p_TODO_START_TIME_1 VARCHAR2,
1834 p_ACTIVITY_CODE_1 VARCHAR2,
1835 p_INTERACTION_NOTES_2 VARCHAR2,
1836 p_PRIORITY_2 NUMBER,
1837 p_TODO_DATE_2 DATE,
1838 p_TODO_START_TIME_2 VARCHAR2,
1839 p_ACTIVITY_CODE_2 VARCHAR2,
1840 p_INTERACTION_NOTES_3 VARCHAR2,
1841 p_PRIORITY_3 NUMBER,
1842 p_TODO_DATE_3 DATE,
1843 p_TODO_START_TIME_3 VARCHAR2,
1844 p_ACTIVITY_CODE_3 VARCHAR2,
1845 p_INTERACTION_NOTES_4 VARCHAR2,
1846 p_PRIORITY_4 NUMBER,
1847 p_TODO_DATE_4 DATE,
1848 p_TODO_START_TIME_4 VARCHAR2,
1849 p_ACTIVITY_CODE_4 VARCHAR2,
1850 p_INTERACTION_NOTES_5 VARCHAR2,
1851 p_PRIORITY_5 NUMBER,
1852 p_TODO_DATE_5 DATE,
1853 p_TODO_START_TIME_5 VARCHAR2,
1854 p_ACTIVITY_CODE_5 VARCHAR2,
1855 p_INTERACTION_NOTES_6 VARCHAR2,
1856 p_PRIORITY_6 NUMBER,
1857 p_TODO_DATE_6 DATE,
1858 p_TODO_START_TIME_6 VARCHAR2,
1859 p_ACTIVITY_CODE_6 VARCHAR2,
1860 p_INTERACTION_NOTES_7 VARCHAR2,
1861 p_PRIORITY_7 NUMBER,
1862 p_TODO_DATE_7 DATE,
1863 p_TODO_START_TIME_7 VARCHAR2,
1864 p_ACTIVITY_CODE_7 VARCHAR2,
1865 p_INTERACTION_NOTES_8 VARCHAR2,
1866 p_PRIORITY_8 NUMBER,
1867 p_TODO_DATE_8 DATE,
1868 p_TODO_START_TIME_8 VARCHAR2,
1869 p_ACTIVITY_CODE_8 VARCHAR2,
1870 p_INTERACTION_NOTES_9 VARCHAR2,
1871 p_PRIORITY_9 NUMBER,
1872 p_TODO_DATE_9 DATE,
1873 p_TODO_START_TIME_9 VARCHAR2,
1877 p_TODO_DATE_10 DATE,
1874 p_ACTIVITY_CODE_9 VARCHAR2,
1875 p_INTERACTION_NOTES_10 VARCHAR2,
1876 p_PRIORITY_10 NUMBER,
1878 p_TODO_START_TIME_10 VARCHAR2,
1879 p_ACTIVITY_CODE_10 VARCHAR2,
1880 p_LEAD_NOTE VARCHAR2,
1881 p_MIDDLE_INITIAL VARCHAR2,
1882 p_FAX_NUMBER VARCHAR2,
1883 p_FAX_AREA_CODE VARCHAR2,
1884 p_MAIL_STOP VARCHAR2,
1885 p_NUM_ENROLLED NUMBER,
1886 p_CONFIRMED_FLAG VARCHAR2,
1887 p_PAYMENT_AMOUNT NUMBER,
1888 p_NUM_ATTENDED NUMBER,
1889 p_PROMOTION_NAME VARCHAR2,
1890 p_STATUS_CHANGE_FLAG VARCHAR2,
1891 p_VEHICLE_RESPONSE_CODE VARCHAR2,
1892 p_SOURCE_SYSTEM VARCHAR2,
1893 p_CONTACT_PARTY_ID NUMBER,
1894 p_PRM_SALES_LEAD_TYPE VARCHAR2,
1895 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
1896 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
1897 p_INC_PARTNER_PARTY_ID NUMBER,
1898 p_INC_PARTNER_RESOURCE_ID NUMBER,
1899 p_OFFER_ID NUMBER,
1900 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
1901 p_PARTY_TYPE VARCHAR2,
1902 p_BATCH_ID NUMBER,
1903 p_PARTY_ID NUMBER,
1904 p_PARTY_SITE_ID NUMBER,
1905 p_LOCATION_ID NUMBER,
1906 p_REL_PARTY_ID NUMBER,
1907 p_SALES_LEAD_ID NUMBER,
1908 p_ADDRESS_KEY VARCHAR2,
1909 p_CONTACT_KEY VARCHAR2,
1910 p_JOB_TITLE_CODE VARCHAR2,
1911 p_DO_NOT_PHONE_FLAG VARCHAR2,
1912 p_DO_NOT_FAX_FLAG VARCHAR2,
1913 p_DO_NOT_EMAIL_FLAG VARCHAR2,
1914 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
1915 p_LEAD_RANK_ID NUMBER,
1916 p_NEW_PARTY_FLAG NUMBER,
1917 p_NEW_LOC_FLAG NUMBER,
1918 p_NEW_PS_FLAG NUMBER,
1919 p_NEW_REL_FLAG NUMBER,
1920 p_NEW_CON_FLAG NUMBER,
1921 p_ORIG_SYSTEM_CODE VARCHAR2,
1922 p_URGENT_FLAG VARCHAR2,
1923 p_SIC_CODE_TYPE VARCHAR2,
1924 p_SITE_USE_TYPE VARCHAR2,
1925 p_PRIMARY_CONTACT_FLAG VARCHAR2,
1926 p_RANK VARCHAR2,
1927 p_ADDRESS_STYLE VARCHAR2,
1928 p_PRIMARY_PER_TYPE VARCHAR2,
1929 p_DEPARTMENT_CODE VARCHAR2)
1930
1931 IS
1932 CURSOR C IS
1933 SELECT *
1934 FROM AS_IMPORT_INTERFACE
1935 WHERE IMPORT_INTERFACE_ID = p_IMPORT_INTERFACE_ID
1936 FOR UPDATE of IMPORT_INTERFACE_ID NOWAIT;
1937 Recinfo C%ROWTYPE;
1938 BEGIN
1939 OPEN C;
1940 FETCH C INTO Recinfo;
1941 If (C%NOTFOUND) then
1942 CLOSE C;
1943 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1944 APP_EXCEPTION.RAISE_EXCEPTION;
1945 End If;
1946 CLOSE C;
1947 if (
1948 ( Recinfo.IMPORT_INTERFACE_ID = p_IMPORT_INTERFACE_ID)
1949 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
1950 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
1951 AND ( p_LAST_UPDATE_DATE IS NULL )))
1952 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
1953 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
1954 AND ( p_LAST_UPDATED_BY IS NULL )))
1955 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
1956 OR ( ( Recinfo.CREATION_DATE IS NULL )
1957 AND ( p_CREATION_DATE IS NULL )))
1958 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
1959 OR ( ( Recinfo.CREATED_BY IS NULL )
1960 AND ( p_CREATED_BY IS NULL )))
1961 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
1962 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
1963 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
1964 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
1965 OR ( ( Recinfo.REQUEST_ID IS NULL )
1966 AND ( p_REQUEST_ID IS NULL )))
1967 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
1968 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
1969 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
1970 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
1971 OR ( ( Recinfo.PROGRAM_ID IS NULL )
1972 AND ( p_PROGRAM_ID IS NULL )))
1973 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
1974 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
1975 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
1976 AND ( ( Recinfo.IMP_LIST_HEADER_NUMBER = p_IMP_LIST_HEADER_NUMBER)
1977 OR ( ( Recinfo.IMP_LIST_HEADER_NUMBER IS NULL )
1978 AND ( p_IMP_LIST_HEADER_NUMBER IS NULL )))
1979 AND ( ( Recinfo.LOAD_TYPE = p_LOAD_TYPE)
1980 OR ( ( Recinfo.LOAD_TYPE IS NULL )
1981 AND ( p_LOAD_TYPE IS NULL )))
1982 AND ( ( Recinfo.LOAD_DATE = p_LOAD_DATE)
1983 OR ( ( Recinfo.LOAD_DATE IS NULL )
1984 AND ( p_LOAD_DATE IS NULL )))
1985 AND ( ( Recinfo.LOAD_STATUS = p_LOAD_STATUS)
1986 OR ( ( Recinfo.LOAD_STATUS IS NULL )
1987 AND ( p_LOAD_STATUS IS NULL )))
1988 AND ( ( Recinfo.LOAD_ERROR_MESSAGE = p_LOAD_ERROR_MESSAGE)
1989 OR ( ( Recinfo.LOAD_ERROR_MESSAGE IS NULL )
1990 AND ( p_LOAD_ERROR_MESSAGE IS NULL )))
1991 AND ( ( Recinfo.PROMOTION_ID = p_PROMOTION_ID)
1992 OR ( ( Recinfo.PROMOTION_ID IS NULL )
1993 AND ( p_PROMOTION_ID IS NULL )))
1994 AND ( ( Recinfo.PROMOTION_CODE = p_PROMOTION_CODE)
1998 OR ( ( Recinfo.CUSTOMER_ID IS NULL )
1995 OR ( ( Recinfo.PROMOTION_CODE IS NULL )
1996 AND ( p_PROMOTION_CODE IS NULL )))
1997 AND ( ( Recinfo.CUSTOMER_ID = p_CUSTOMER_ID)
1999 AND ( p_CUSTOMER_ID IS NULL )))
2000 AND ( ( Recinfo.CUSTOMER_NAME = p_CUSTOMER_NAME)
2001 OR ( ( Recinfo.CUSTOMER_NAME IS NULL )
2002 AND ( p_CUSTOMER_NAME IS NULL )))
2003 AND ( ( Recinfo.CUSTOMER_NUMBER = p_CUSTOMER_NUMBER)
2004 OR ( ( Recinfo.CUSTOMER_NUMBER IS NULL )
2005 AND ( p_CUSTOMER_NUMBER IS NULL )))
2006 AND ( ( Recinfo.CUSTOMER_STATUS = p_CUSTOMER_STATUS)
2007 OR ( ( Recinfo.CUSTOMER_STATUS IS NULL )
2008 AND ( p_CUSTOMER_STATUS IS NULL )))
2009 AND ( ( Recinfo.CUSTOMER_TYPE = p_CUSTOMER_TYPE)
2010 OR ( ( Recinfo.CUSTOMER_TYPE IS NULL )
2011 AND ( p_CUSTOMER_TYPE IS NULL )))
2012 AND ( ( Recinfo.CUSTOMER_PROSPECT_CODE = p_CUSTOMER_PROSPECT_CODE)
2013 OR ( ( Recinfo.CUSTOMER_PROSPECT_CODE IS NULL )
2014 AND ( p_CUSTOMER_PROSPECT_CODE IS NULL )))
2015 AND ( ( Recinfo.CUSTOMER_CLASS_CODE = p_CUSTOMER_CLASS_CODE)
2016 OR ( ( Recinfo.CUSTOMER_CLASS_CODE IS NULL )
2017 AND ( p_CUSTOMER_CLASS_CODE IS NULL )))
2018 AND ( ( Recinfo.SALES_CHANNEL_CODE = p_SALES_CHANNEL_CODE)
2019 OR ( ( Recinfo.SALES_CHANNEL_CODE IS NULL )
2020 AND ( p_SALES_CHANNEL_CODE IS NULL )))
2021 AND ( ( Recinfo.SIC_CODE = p_SIC_CODE)
2022 OR ( ( Recinfo.SIC_CODE IS NULL )
2023 AND ( p_SIC_CODE IS NULL )))
2024 AND ( ( Recinfo.ANALYSIS_FY = p_ANALYSIS_FY)
2025 OR ( ( Recinfo.ANALYSIS_FY IS NULL )
2026 AND ( p_ANALYSIS_FY IS NULL )))
2027 AND ( ( Recinfo.CUSTOMER_CATEGORY_CODE = p_CUSTOMER_CATEGORY_CODE)
2028 OR ( ( Recinfo.CUSTOMER_CATEGORY_CODE IS NULL )
2029 AND ( p_CUSTOMER_CATEGORY_CODE IS NULL )))
2030 AND ( ( Recinfo.CUSTOMER_GROUP_CODE = p_CUSTOMER_GROUP_CODE)
2031 OR ( ( Recinfo.CUSTOMER_GROUP_CODE IS NULL )
2032 AND ( p_CUSTOMER_GROUP_CODE IS NULL )))
2033 AND ( ( Recinfo.CUSTOMER_KEY = p_CUSTOMER_KEY)
2034 OR ( ( Recinfo.CUSTOMER_KEY IS NULL )
2035 AND ( p_CUSTOMER_KEY IS NULL )))
2036 AND ( ( Recinfo.CUSTOMER_SUBGROUP_CODE = p_CUSTOMER_SUBGROUP_CODE)
2037 OR ( ( Recinfo.CUSTOMER_SUBGROUP_CODE IS NULL )
2038 AND ( p_CUSTOMER_SUBGROUP_CODE IS NULL )))
2039 AND ( ( Recinfo.FISCAL_YEAREND_MONTH = p_FISCAL_YEAREND_MONTH)
2040 OR ( ( Recinfo.FISCAL_YEAREND_MONTH IS NULL )
2041 AND ( p_FISCAL_YEAREND_MONTH IS NULL )))
2042 AND ( ( Recinfo.NET_WORTH = p_NET_WORTH)
2043 OR ( ( Recinfo.NET_WORTH IS NULL )
2044 AND ( p_NET_WORTH IS NULL )))
2045 AND ( ( Recinfo.NUM_OF_EMPLOYEES = p_NUM_OF_EMPLOYEES)
2046 OR ( ( Recinfo.NUM_OF_EMPLOYEES IS NULL )
2047 AND ( p_NUM_OF_EMPLOYEES IS NULL )))
2048 AND ( ( Recinfo.POTENTIAL_REVENUE_CURR_FY = p_POTENTIAL_REVENUE_CURR_FY)
2049 OR ( ( Recinfo.POTENTIAL_REVENUE_CURR_FY IS NULL )
2050 AND ( p_POTENTIAL_REVENUE_CURR_FY IS NULL )))
2051 AND ( ( Recinfo.POTENTIAL_REVENUE_NEXT_FY = p_POTENTIAL_REVENUE_NEXT_FY)
2052 OR ( ( Recinfo.POTENTIAL_REVENUE_NEXT_FY IS NULL )
2053 AND ( p_POTENTIAL_REVENUE_NEXT_FY IS NULL )))
2054 AND ( ( Recinfo.CUSTOMER_RANK = p_CUSTOMER_RANK)
2055 OR ( ( Recinfo.CUSTOMER_RANK IS NULL )
2056 AND ( p_CUSTOMER_RANK IS NULL )))
2057 AND ( ( Recinfo.REFERENCE_USE_FLAG = p_REFERENCE_USE_FLAG)
2058 OR ( ( Recinfo.REFERENCE_USE_FLAG IS NULL )
2059 AND ( p_REFERENCE_USE_FLAG IS NULL )))
2060 AND ( ( Recinfo.TAX_CODE = p_TAX_CODE)
2061 OR ( ( Recinfo.TAX_CODE IS NULL )
2062 AND ( p_TAX_CODE IS NULL )))
2063 AND ( ( Recinfo.TAX_REFERENCE = p_TAX_REFERENCE)
2064 OR ( ( Recinfo.TAX_REFERENCE IS NULL )
2065 AND ( p_TAX_REFERENCE IS NULL )))
2066 AND ( ( Recinfo.THIRD_PARTY_FLAG = p_THIRD_PARTY_FLAG)
2067 OR ( ( Recinfo.THIRD_PARTY_FLAG IS NULL )
2068 AND ( p_THIRD_PARTY_FLAG IS NULL )))
2069 AND ( ( Recinfo.COMPETITOR_FLAG = p_COMPETITOR_FLAG)
2070 OR ( ( Recinfo.COMPETITOR_FLAG IS NULL )
2071 AND ( p_COMPETITOR_FLAG IS NULL )))
2072 AND ( ( Recinfo.YEAR_ESTABLISHED = p_YEAR_ESTABLISHED)
2073 OR ( ( Recinfo.YEAR_ESTABLISHED IS NULL )
2074 AND ( p_YEAR_ESTABLISHED IS NULL )))
2075 AND ( ( Recinfo.ADDR_DO_NOT_MAIL_FLAG = p_ADDR_DO_NOT_MAIL_FLAG)
2076 OR ( ( Recinfo.ADDR_DO_NOT_MAIL_FLAG IS NULL )
2077 AND ( p_ADDR_DO_NOT_MAIL_FLAG IS NULL )))
2078 AND ( ( Recinfo.URL = p_URL)
2079 OR ( ( Recinfo.URL IS NULL )
2080 AND ( p_URL IS NULL )))
2081 AND ( ( Recinfo.ADDRESS_ID = p_ADDRESS_ID)
2082 OR ( ( Recinfo.ADDRESS_ID IS NULL )
2083 AND ( p_ADDRESS_ID IS NULL )))
2084 AND ( ( Recinfo.CONT_DO_NOT_MAIL_FLAG = p_CONT_DO_NOT_MAIL_FLAG)
2085 OR ( ( Recinfo.CONT_DO_NOT_MAIL_FLAG IS NULL )
2086 AND ( p_CONT_DO_NOT_MAIL_FLAG IS NULL )))
2087 AND ( ( Recinfo.ADDRESS_STATUS = p_ADDRESS_STATUS)
2088 OR ( ( Recinfo.ADDRESS_STATUS IS NULL )
2089 AND ( p_ADDRESS_STATUS IS NULL )))
2090 AND ( ( Recinfo.COUNTRY = p_COUNTRY)
2091 OR ( ( Recinfo.COUNTRY IS NULL )
2095 AND ( p_ADDRESS1 IS NULL )))
2092 AND ( p_COUNTRY IS NULL )))
2093 AND ( ( Recinfo.ADDRESS1 = p_ADDRESS1)
2094 OR ( ( Recinfo.ADDRESS1 IS NULL )
2096 AND ( ( Recinfo.ADDRESS2 = p_ADDRESS2)
2097 OR ( ( Recinfo.ADDRESS2 IS NULL )
2098 AND ( p_ADDRESS2 IS NULL )))
2099 AND ( ( Recinfo.ADDRESS3 = p_ADDRESS3)
2100 OR ( ( Recinfo.ADDRESS3 IS NULL )
2101 AND ( p_ADDRESS3 IS NULL )))
2102 AND ( ( Recinfo.ADDRESS4 = p_ADDRESS4)
2103 OR ( ( Recinfo.ADDRESS4 IS NULL )
2104 AND ( p_ADDRESS4 IS NULL )))
2105 AND ( ( Recinfo.CITY = p_CITY)
2106 OR ( ( Recinfo.CITY IS NULL )
2107 AND ( p_CITY IS NULL )))
2108 AND ( ( Recinfo.POSTAL_CODE = p_POSTAL_CODE)
2109 OR ( ( Recinfo.POSTAL_CODE IS NULL )
2110 AND ( p_POSTAL_CODE IS NULL )))
2111 AND ( ( Recinfo.STATE = p_STATE)
2112 OR ( ( Recinfo.STATE IS NULL )
2113 AND ( p_STATE IS NULL )))
2114 AND ( ( Recinfo.PROVINCE = p_PROVINCE)
2115 OR ( ( Recinfo.PROVINCE IS NULL )
2116 AND ( p_PROVINCE IS NULL )))
2117 AND ( ( Recinfo.COUNTY = p_COUNTY)
2118 OR ( ( Recinfo.COUNTY IS NULL )
2119 AND ( p_COUNTY IS NULL )))
2120 AND ( ( Recinfo.SITE_CONTACT_ID = p_SITE_CONTACT_ID)
2121 OR ( ( Recinfo.SITE_CONTACT_ID IS NULL )
2122 AND ( p_SITE_CONTACT_ID IS NULL )))
2123 AND ( ( Recinfo.EMAIL_ADDRESS = p_EMAIL_ADDRESS)
2124 OR ( ( Recinfo.EMAIL_ADDRESS IS NULL )
2125 AND ( p_EMAIL_ADDRESS IS NULL )))
2126 AND ( ( Recinfo.SEX_CODE = p_SEX_CODE)
2127 OR ( ( Recinfo.SEX_CODE IS NULL )
2128 AND ( p_SEX_CODE IS NULL )))
2129 AND ( ( Recinfo.SALUTATION = p_SALUTATION)
2130 OR ( ( Recinfo.SALUTATION IS NULL )
2131 AND ( p_SALUTATION IS NULL )))
2132 AND ( ( Recinfo.LAST_NAME = p_LAST_NAME)
2133 OR ( ( Recinfo.LAST_NAME IS NULL )
2134 AND ( p_LAST_NAME IS NULL )))
2135 AND ( ( Recinfo.TITLE = p_TITLE)
2136 OR ( ( Recinfo.TITLE IS NULL )
2137 AND ( p_TITLE IS NULL )))
2138 AND ( ( Recinfo.FIRST_NAME = p_FIRST_NAME)
2139 OR ( ( Recinfo.FIRST_NAME IS NULL )
2140 AND ( p_FIRST_NAME IS NULL )))
2141 AND ( ( Recinfo.JOB_TITLE = p_JOB_TITLE)
2142 OR ( ( Recinfo.JOB_TITLE IS NULL )
2143 AND ( p_JOB_TITLE IS NULL )))
2144 AND ( ( Recinfo.PHONE_ID = p_PHONE_ID)
2145 OR ( ( Recinfo.PHONE_ID IS NULL )
2146 AND ( p_PHONE_ID IS NULL )))
2147 AND ( ( Recinfo.PHONE_NUMBER = p_PHONE_NUMBER)
2148 OR ( ( Recinfo.PHONE_NUMBER IS NULL )
2149 AND ( p_PHONE_NUMBER IS NULL )))
2150 AND ( ( Recinfo.PHONE_STATUS = p_PHONE_STATUS)
2151 OR ( ( Recinfo.PHONE_STATUS IS NULL )
2152 AND ( p_PHONE_STATUS IS NULL )))
2153 AND ( ( Recinfo.PHONE_TYPE = p_PHONE_TYPE)
2154 OR ( ( Recinfo.PHONE_TYPE IS NULL )
2155 AND ( p_PHONE_TYPE IS NULL )))
2156 AND ( ( Recinfo.AREA_CODE = p_AREA_CODE)
2157 OR ( ( Recinfo.AREA_CODE IS NULL )
2158 AND ( p_AREA_CODE IS NULL )))
2159 AND ( ( Recinfo.EXTENSION = p_EXTENSION)
2160 OR ( ( Recinfo.EXTENSION IS NULL )
2161 AND ( p_EXTENSION IS NULL )))
2162 AND ( ( Recinfo.LEAD_NUMBER = p_LEAD_NUMBER)
2163 OR ( ( Recinfo.LEAD_NUMBER IS NULL )
2164 AND ( p_LEAD_NUMBER IS NULL )))
2165 AND ( ( Recinfo.STATUS_CODE = p_STATUS_CODE)
2166 OR ( ( Recinfo.STATUS_CODE IS NULL )
2167 AND ( p_STATUS_CODE IS NULL )))
2168 AND ( ( Recinfo.SOURCE_PROMOTION_ID = p_SOURCE_PROMOTION_ID)
2169 OR ( ( Recinfo.SOURCE_PROMOTION_ID IS NULL )
2170 AND ( p_SOURCE_PROMOTION_ID IS NULL )))
2171 AND ( ( Recinfo.INITIATING_CONTACT_ID = p_INITIATING_CONTACT_ID)
2172 OR ( ( Recinfo.INITIATING_CONTACT_ID IS NULL )
2173 AND ( p_INITIATING_CONTACT_ID IS NULL )))
2174 AND ( ( Recinfo.CONTACT_ROLE_CODE = p_CONTACT_ROLE_CODE)
2175 OR ( ( Recinfo.CONTACT_ROLE_CODE IS NULL )
2176 AND ( p_CONTACT_ROLE_CODE IS NULL )))
2177 AND ( ( Recinfo.CHANNEL_CODE = p_CHANNEL_CODE)
2178 OR ( ( Recinfo.CHANNEL_CODE IS NULL )
2179 AND ( p_CHANNEL_CODE IS NULL )))
2180 AND ( ( Recinfo.BUDGET_AMOUNT = p_BUDGET_AMOUNT)
2181 OR ( ( Recinfo.BUDGET_AMOUNT IS NULL )
2182 AND ( p_BUDGET_AMOUNT IS NULL )))
2183 AND ( ( Recinfo.BUDGET_STATUS_CODE = p_BUDGET_STATUS_CODE)
2184 OR ( ( Recinfo.BUDGET_STATUS_CODE IS NULL )
2185 AND ( p_BUDGET_STATUS_CODE IS NULL )))
2186 AND ( ( Recinfo.CURRENCY_CODE = p_CURRENCY_CODE)
2187 OR ( ( Recinfo.CURRENCY_CODE IS NULL )
2188 AND ( p_CURRENCY_CODE IS NULL )))
2189 AND ( ( Recinfo.DECISION_TIMEFRAME_CODE = p_DECISION_TIMEFRAME_CODE)
2190 OR ( ( Recinfo.DECISION_TIMEFRAME_CODE IS NULL )
2191 AND ( p_DECISION_TIMEFRAME_CODE IS NULL )))
2192 AND ( ( Recinfo.CLOSE_REASON = p_CLOSE_REASON)
2193 OR ( ( Recinfo.CLOSE_REASON IS NULL )
2194 AND ( p_CLOSE_REASON IS NULL )))
2195 AND ( ( Recinfo.LEAD_RANK_CODE = p_LEAD_RANK_CODE)
2196 OR ( ( Recinfo.LEAD_RANK_CODE IS NULL )
2200 AND ( p_PARENT_PROJECT IS NULL )))
2197 AND ( p_LEAD_RANK_CODE IS NULL )))
2198 AND ( ( Recinfo.PARENT_PROJECT = p_PARENT_PROJECT)
2199 OR ( ( Recinfo.PARENT_PROJECT IS NULL )
2201 AND ( ( Recinfo.DESCRIPTION = p_DESCRIPTION)
2202 OR ( ( Recinfo.DESCRIPTION IS NULL )
2203 AND ( p_DESCRIPTION IS NULL )))
2204 AND ( ( Recinfo.STATUS_CODE_1 = p_STATUS_CODE_1)
2205 OR ( ( Recinfo.STATUS_CODE_1 IS NULL )
2206 AND ( p_STATUS_CODE_1 IS NULL )))
2207 AND ( ( Recinfo.INTEREST_TYPE_ID_1 = p_INTEREST_TYPE_ID_1)
2208 OR ( ( Recinfo.INTEREST_TYPE_ID_1 IS NULL )
2209 AND ( p_INTEREST_TYPE_ID_1 IS NULL )))
2210 AND ( ( Recinfo.PRIMARY_INTEREST_CODE_ID_1 = p_PRIMARY_INTEREST_CODE_ID_1)
2211 OR ( ( Recinfo.PRIMARY_INTEREST_CODE_ID_1 IS NULL )
2212 AND ( p_PRIMARY_INTEREST_CODE_ID_1 IS NULL )))
2213 AND ( ( Recinfo.SECONDARY_INTEREST_CODE_ID_1 = p_SECONDARY_INTEREST_CODE_ID_1)
2214 OR ( ( Recinfo.SECONDARY_INTEREST_CODE_ID_1 IS NULL )
2215 AND ( p_SECONDARY_INTEREST_CODE_ID_1 IS NULL )))
2216 AND ( ( Recinfo.INVENTORY_ITEM_ID_1 = p_INVENTORY_ITEM_ID_1)
2217 OR ( ( Recinfo.INVENTORY_ITEM_ID_1 IS NULL )
2218 AND ( p_INVENTORY_ITEM_ID_1 IS NULL )))
2219 AND ( ( Recinfo.ORGANIZATION_ID_1 = p_ORGANIZATION_ID_1)
2220 OR ( ( Recinfo.ORGANIZATION_ID_1 IS NULL )
2221 AND ( p_ORGANIZATION_ID_1 IS NULL )))
2222 AND ( ( Recinfo.UOM_CODE_1 = p_UOM_CODE_1)
2223 OR ( ( Recinfo.UOM_CODE_1 IS NULL )
2224 AND ( p_UOM_CODE_1 IS NULL )))
2225 AND ( ( Recinfo.QUANTITY_1 = p_QUANTITY_1)
2226 OR ( ( Recinfo.QUANTITY_1 IS NULL )
2227 AND ( p_QUANTITY_1 IS NULL )))
2228 AND ( ( Recinfo.BUDGET_AMOUNT_1 = p_BUDGET_AMOUNT_1)
2229 OR ( ( Recinfo.BUDGET_AMOUNT_1 IS NULL )
2230 AND ( p_BUDGET_AMOUNT_1 IS NULL )))
2231 AND ( ( Recinfo.STATUS_CODE_2 = p_STATUS_CODE_2)
2232 OR ( ( Recinfo.STATUS_CODE_2 IS NULL )
2233 AND ( p_STATUS_CODE_2 IS NULL )))
2234 AND ( ( Recinfo.INTEREST_TYPE_ID_2 = p_INTEREST_TYPE_ID_2)
2235 OR ( ( Recinfo.INTEREST_TYPE_ID_2 IS NULL )
2236 AND ( p_INTEREST_TYPE_ID_2 IS NULL )))
2237 AND ( ( Recinfo.PRIMARY_INTEREST_CODE_ID_2 = p_PRIMARY_INTEREST_CODE_ID_2)
2238 OR ( ( Recinfo.PRIMARY_INTEREST_CODE_ID_2 IS NULL )
2239 AND ( p_PRIMARY_INTEREST_CODE_ID_2 IS NULL )))
2240 AND ( ( Recinfo.SECONDARY_INTEREST_CODE_ID_2 = p_SECONDARY_INTEREST_CODE_ID_2)
2241 OR ( ( Recinfo.SECONDARY_INTEREST_CODE_ID_2 IS NULL )
2242 AND ( p_SECONDARY_INTEREST_CODE_ID_2 IS NULL )))
2243 AND ( ( Recinfo.INVENTORY_ITEM_ID_2 = p_INVENTORY_ITEM_ID_2)
2244 OR ( ( Recinfo.INVENTORY_ITEM_ID_2 IS NULL )
2245 AND ( p_INVENTORY_ITEM_ID_2 IS NULL )))
2246 AND ( ( Recinfo.ORGANIZATION_ID_2 = p_ORGANIZATION_ID_2)
2247 OR ( ( Recinfo.ORGANIZATION_ID_2 IS NULL )
2248 AND ( p_ORGANIZATION_ID_2 IS NULL )))
2249 AND ( ( Recinfo.UOM_CODE_2 = p_UOM_CODE_2)
2250 OR ( ( Recinfo.UOM_CODE_2 IS NULL )
2251 AND ( p_UOM_CODE_2 IS NULL )))
2252 AND ( ( Recinfo.QUANTITY_2 = p_QUANTITY_2)
2253 OR ( ( Recinfo.QUANTITY_2 IS NULL )
2254 AND ( p_QUANTITY_2 IS NULL )))
2255 AND ( ( Recinfo.BUDGET_AMOUNT_2 = p_BUDGET_AMOUNT_2)
2256 OR ( ( Recinfo.BUDGET_AMOUNT_2 IS NULL )
2257 AND ( p_BUDGET_AMOUNT_2 IS NULL )))
2258 AND ( ( Recinfo.STATUS_CODE_3 = p_STATUS_CODE_3)
2259 OR ( ( Recinfo.STATUS_CODE_3 IS NULL )
2260 AND ( p_STATUS_CODE_3 IS NULL )))
2261 AND ( ( Recinfo.INTEREST_TYPE_ID_3 = p_INTEREST_TYPE_ID_3)
2262 OR ( ( Recinfo.INTEREST_TYPE_ID_3 IS NULL )
2263 AND ( p_INTEREST_TYPE_ID_3 IS NULL )))
2264 AND ( ( Recinfo.PRIMARY_INTEREST_CODE_ID_3 = p_PRIMARY_INTEREST_CODE_ID_3)
2265 OR ( ( Recinfo.PRIMARY_INTEREST_CODE_ID_3 IS NULL )
2266 AND ( p_PRIMARY_INTEREST_CODE_ID_3 IS NULL )))
2267 AND ( ( Recinfo.SECONDARY_INTEREST_CODE_ID_3 = p_SECONDARY_INTEREST_CODE_ID_3)
2268 OR ( ( Recinfo.SECONDARY_INTEREST_CODE_ID_3 IS NULL )
2269 AND ( p_SECONDARY_INTEREST_CODE_ID_3 IS NULL )))
2270 AND ( ( Recinfo.INVENTORY_ITEM_ID_3 = p_INVENTORY_ITEM_ID_3)
2271 OR ( ( Recinfo.INVENTORY_ITEM_ID_3 IS NULL )
2272 AND ( p_INVENTORY_ITEM_ID_3 IS NULL )))
2273 AND ( ( Recinfo.ORGANIZATION_ID_3 = p_ORGANIZATION_ID_3)
2274 OR ( ( Recinfo.ORGANIZATION_ID_3 IS NULL )
2275 AND ( p_ORGANIZATION_ID_3 IS NULL )))
2276 AND ( ( Recinfo.UOM_CODE_3 = p_UOM_CODE_3)
2277 OR ( ( Recinfo.UOM_CODE_3 IS NULL )
2278 AND ( p_UOM_CODE_3 IS NULL )))
2279 AND ( ( Recinfo.QUANTITY_3 = p_QUANTITY_3)
2280 OR ( ( Recinfo.QUANTITY_3 IS NULL )
2281 AND ( p_QUANTITY_3 IS NULL )))
2282 AND ( ( Recinfo.BUDGET_AMOUNT_3 = p_BUDGET_AMOUNT_3)
2283 OR ( ( Recinfo.BUDGET_AMOUNT_3 IS NULL )
2284 AND ( p_BUDGET_AMOUNT_3 IS NULL )))
2285 AND ( ( Recinfo.STATUS_CODE_4 = p_STATUS_CODE_4)
2286 OR ( ( Recinfo.STATUS_CODE_4 IS NULL )
2287 AND ( p_STATUS_CODE_4 IS NULL )))
2288 AND ( ( Recinfo.INTEREST_TYPE_ID_4 = p_INTEREST_TYPE_ID_4)
2289 OR ( ( Recinfo.INTEREST_TYPE_ID_4 IS NULL )
2290 AND ( p_INTEREST_TYPE_ID_4 IS NULL )))
2294 AND ( ( Recinfo.SECONDARY_INTEREST_CODE_ID_4 = p_SECONDARY_INTEREST_CODE_ID_4)
2291 AND ( ( Recinfo.PRIMARY_INTEREST_CODE_ID_4 = p_PRIMARY_INTEREST_CODE_ID_4)
2292 OR ( ( Recinfo.PRIMARY_INTEREST_CODE_ID_4 IS NULL )
2293 AND ( p_PRIMARY_INTEREST_CODE_ID_4 IS NULL )))
2295 OR ( ( Recinfo.SECONDARY_INTEREST_CODE_ID_4 IS NULL )
2296 AND ( p_SECONDARY_INTEREST_CODE_ID_4 IS NULL )))
2297 AND ( ( Recinfo.INVENTORY_ITEM_ID_4 = p_INVENTORY_ITEM_ID_4)
2298 OR ( ( Recinfo.INVENTORY_ITEM_ID_4 IS NULL )
2299 AND ( p_INVENTORY_ITEM_ID_4 IS NULL )))
2300 AND ( ( Recinfo.ORGANIZATION_ID_4 = p_ORGANIZATION_ID_4)
2301 OR ( ( Recinfo.ORGANIZATION_ID_4 IS NULL )
2302 AND ( p_ORGANIZATION_ID_4 IS NULL )))
2303 AND ( ( Recinfo.UOM_CODE_4 = p_UOM_CODE_4)
2304 OR ( ( Recinfo.UOM_CODE_4 IS NULL )
2305 AND ( p_UOM_CODE_4 IS NULL )))
2306 AND ( ( Recinfo.QUANTITY_4 = p_QUANTITY_4)
2307 OR ( ( Recinfo.QUANTITY_4 IS NULL )
2308 AND ( p_QUANTITY_4 IS NULL )))
2309 AND ( ( Recinfo.BUDGET_AMOUNT_4 = p_BUDGET_AMOUNT_4)
2310 OR ( ( Recinfo.BUDGET_AMOUNT_4 IS NULL )
2311 AND ( p_BUDGET_AMOUNT_4 IS NULL )))
2312 AND ( ( Recinfo.STATUS_CODE_5 = p_STATUS_CODE_5)
2313 OR ( ( Recinfo.STATUS_CODE_5 IS NULL )
2314 AND ( p_STATUS_CODE_5 IS NULL )))
2315 AND ( ( Recinfo.INTEREST_TYPE_ID_5 = p_INTEREST_TYPE_ID_5)
2316 OR ( ( Recinfo.INTEREST_TYPE_ID_5 IS NULL )
2317 AND ( p_INTEREST_TYPE_ID_5 IS NULL )))
2318 AND ( ( Recinfo.PRIMARY_INTEREST_CODE_ID_5 = p_PRIMARY_INTEREST_CODE_ID_5)
2319 OR ( ( Recinfo.PRIMARY_INTEREST_CODE_ID_5 IS NULL )
2320 AND ( p_PRIMARY_INTEREST_CODE_ID_5 IS NULL )))
2321 AND ( ( Recinfo.SECONDARY_INTEREST_CODE_ID_5 = p_SECONDARY_INTEREST_CODE_ID_5)
2322 OR ( ( Recinfo.SECONDARY_INTEREST_CODE_ID_5 IS NULL )
2323 AND ( p_SECONDARY_INTEREST_CODE_ID_5 IS NULL )))
2324 AND ( ( Recinfo.INVENTORY_ITEM_ID_5 = p_INVENTORY_ITEM_ID_5)
2325 OR ( ( Recinfo.INVENTORY_ITEM_ID_5 IS NULL )
2326 AND ( p_INVENTORY_ITEM_ID_5 IS NULL )))
2327 AND ( ( Recinfo.ORGANIZATION_ID_5 = p_ORGANIZATION_ID_5)
2328 OR ( ( Recinfo.ORGANIZATION_ID_5 IS NULL )
2329 AND ( p_ORGANIZATION_ID_5 IS NULL )))
2330 AND ( ( Recinfo.UOM_CODE_5 = p_UOM_CODE_5)
2331 OR ( ( Recinfo.UOM_CODE_5 IS NULL )
2332 AND ( p_UOM_CODE_5 IS NULL )))
2333 AND ( ( Recinfo.QUANTITY_5 = p_QUANTITY_5)
2334 OR ( ( Recinfo.QUANTITY_5 IS NULL )
2335 AND ( p_QUANTITY_5 IS NULL )))
2336 AND ( ( Recinfo.BUDGET_AMOUNT_5 = p_BUDGET_AMOUNT_5)
2337 OR ( ( Recinfo.BUDGET_AMOUNT_5 IS NULL )
2338 AND ( p_BUDGET_AMOUNT_5 IS NULL )))
2339 AND ( ( Recinfo.INTERACTION_NOTES_1 = p_INTERACTION_NOTES_1)
2340 OR ( ( Recinfo.INTERACTION_NOTES_1 IS NULL )
2341 AND ( p_INTERACTION_NOTES_1 IS NULL )))
2342 AND ( ( Recinfo.PRIORITY_1 = p_PRIORITY_1)
2343 OR ( ( Recinfo.PRIORITY_1 IS NULL )
2344 AND ( p_PRIORITY_1 IS NULL )))
2345 AND ( ( Recinfo.TODO_DATE_1 = p_TODO_DATE_1)
2346 OR ( ( Recinfo.TODO_DATE_1 IS NULL )
2347 AND ( p_TODO_DATE_1 IS NULL )))
2348 AND ( ( Recinfo.TODO_START_TIME_1 = p_TODO_START_TIME_1)
2349 OR ( ( Recinfo.TODO_START_TIME_1 IS NULL )
2350 AND ( p_TODO_START_TIME_1 IS NULL )))
2351 AND ( ( Recinfo.ACTIVITY_CODE_1 = p_ACTIVITY_CODE_1)
2352 OR ( ( Recinfo.ACTIVITY_CODE_1 IS NULL )
2353 AND ( p_ACTIVITY_CODE_1 IS NULL )))
2354 AND ( ( Recinfo.INTERACTION_NOTES_2 = p_INTERACTION_NOTES_2)
2355 OR ( ( Recinfo.INTERACTION_NOTES_2 IS NULL )
2356 AND ( p_INTERACTION_NOTES_2 IS NULL )))
2357 AND ( ( Recinfo.PRIORITY_2 = p_PRIORITY_2)
2358 OR ( ( Recinfo.PRIORITY_2 IS NULL )
2359 AND ( p_PRIORITY_2 IS NULL )))
2360 AND ( ( Recinfo.TODO_DATE_2 = p_TODO_DATE_2)
2361 OR ( ( Recinfo.TODO_DATE_2 IS NULL )
2362 AND ( p_TODO_DATE_2 IS NULL )))
2363 AND ( ( Recinfo.TODO_START_TIME_2 = p_TODO_START_TIME_2)
2364 OR ( ( Recinfo.TODO_START_TIME_2 IS NULL )
2365 AND ( p_TODO_START_TIME_2 IS NULL )))
2366 AND ( ( Recinfo.ACTIVITY_CODE_2 = p_ACTIVITY_CODE_2)
2367 OR ( ( Recinfo.ACTIVITY_CODE_2 IS NULL )
2368 AND ( p_ACTIVITY_CODE_2 IS NULL )))
2369 AND ( ( Recinfo.INTERACTION_NOTES_3 = p_INTERACTION_NOTES_3)
2370 OR ( ( Recinfo.INTERACTION_NOTES_3 IS NULL )
2371 AND ( p_INTERACTION_NOTES_3 IS NULL )))
2372 AND ( ( Recinfo.PRIORITY_3 = p_PRIORITY_3)
2373 OR ( ( Recinfo.PRIORITY_3 IS NULL )
2374 AND ( p_PRIORITY_3 IS NULL )))
2375 AND ( ( Recinfo.TODO_DATE_3 = p_TODO_DATE_3)
2376 OR ( ( Recinfo.TODO_DATE_3 IS NULL )
2377 AND ( p_TODO_DATE_3 IS NULL )))
2378 AND ( ( Recinfo.TODO_START_TIME_3 = p_TODO_START_TIME_3)
2379 OR ( ( Recinfo.TODO_START_TIME_3 IS NULL )
2380 AND ( p_TODO_START_TIME_3 IS NULL )))
2381 AND ( ( Recinfo.ACTIVITY_CODE_3 = p_ACTIVITY_CODE_3)
2382 OR ( ( Recinfo.ACTIVITY_CODE_3 IS NULL )
2383 AND ( p_ACTIVITY_CODE_3 IS NULL )))
2384 AND ( ( Recinfo.INTERACTION_NOTES_4 = p_INTERACTION_NOTES_4)
2385 OR ( ( Recinfo.INTERACTION_NOTES_4 IS NULL )
2386 AND ( p_INTERACTION_NOTES_4 IS NULL )))
2387 AND ( ( Recinfo.PRIORITY_4 = p_PRIORITY_4)
2388 OR ( ( Recinfo.PRIORITY_4 IS NULL )
2389 AND ( p_PRIORITY_4 IS NULL )))
2393 AND ( ( Recinfo.TODO_START_TIME_4 = p_TODO_START_TIME_4)
2390 AND ( ( Recinfo.TODO_DATE_4 = p_TODO_DATE_4)
2391 OR ( ( Recinfo.TODO_DATE_4 IS NULL )
2392 AND ( p_TODO_DATE_4 IS NULL )))
2394 OR ( ( Recinfo.TODO_START_TIME_4 IS NULL )
2395 AND ( p_TODO_START_TIME_4 IS NULL )))
2396 AND ( ( Recinfo.ACTIVITY_CODE_4 = p_ACTIVITY_CODE_4)
2397 OR ( ( Recinfo.ACTIVITY_CODE_4 IS NULL )
2398 AND ( p_ACTIVITY_CODE_4 IS NULL )))
2399 AND ( ( Recinfo.INTERACTION_NOTES_5 = p_INTERACTION_NOTES_5)
2400 OR ( ( Recinfo.INTERACTION_NOTES_5 IS NULL )
2401 AND ( p_INTERACTION_NOTES_5 IS NULL )))
2402 AND ( ( Recinfo.PRIORITY_5 = p_PRIORITY_5)
2403 OR ( ( Recinfo.PRIORITY_5 IS NULL )
2404 AND ( p_PRIORITY_5 IS NULL )))
2405 AND ( ( Recinfo.TODO_DATE_5 = p_TODO_DATE_5)
2406 OR ( ( Recinfo.TODO_DATE_5 IS NULL )
2407 AND ( p_TODO_DATE_5 IS NULL )))
2408 AND ( ( Recinfo.TODO_START_TIME_5 = p_TODO_START_TIME_5)
2409 OR ( ( Recinfo.TODO_START_TIME_5 IS NULL )
2410 AND ( p_TODO_START_TIME_5 IS NULL )))
2411 AND ( ( Recinfo.ACTIVITY_CODE_5 = p_ACTIVITY_CODE_5)
2412 OR ( ( Recinfo.ACTIVITY_CODE_5 IS NULL )
2413 AND ( p_ACTIVITY_CODE_5 IS NULL )))
2414 AND ( ( Recinfo.INTERACTION_NOTES_6 = p_INTERACTION_NOTES_6)
2415 OR ( ( Recinfo.INTERACTION_NOTES_6 IS NULL )
2416 AND ( p_INTERACTION_NOTES_6 IS NULL )))
2417 AND ( ( Recinfo.PRIORITY_6 = p_PRIORITY_6)
2418 OR ( ( Recinfo.PRIORITY_6 IS NULL )
2419 AND ( p_PRIORITY_6 IS NULL )))
2420 AND ( ( Recinfo.TODO_DATE_6 = p_TODO_DATE_6)
2421 OR ( ( Recinfo.TODO_DATE_6 IS NULL )
2422 AND ( p_TODO_DATE_6 IS NULL )))
2423 AND ( ( Recinfo.TODO_START_TIME_6 = p_TODO_START_TIME_6)
2424 OR ( ( Recinfo.TODO_START_TIME_6 IS NULL )
2425 AND ( p_TODO_START_TIME_6 IS NULL )))
2426 AND ( ( Recinfo.ACTIVITY_CODE_6 = p_ACTIVITY_CODE_6)
2427 OR ( ( Recinfo.ACTIVITY_CODE_6 IS NULL )
2428 AND ( p_ACTIVITY_CODE_6 IS NULL )))
2429 AND ( ( Recinfo.INTERACTION_NOTES_7 = p_INTERACTION_NOTES_7)
2430 OR ( ( Recinfo.INTERACTION_NOTES_7 IS NULL )
2431 AND ( p_INTERACTION_NOTES_7 IS NULL )))
2432 AND ( ( Recinfo.PRIORITY_7 = p_PRIORITY_7)
2433 OR ( ( Recinfo.PRIORITY_7 IS NULL )
2434 AND ( p_PRIORITY_7 IS NULL )))
2435 AND ( ( Recinfo.TODO_DATE_7 = p_TODO_DATE_7)
2436 OR ( ( Recinfo.TODO_DATE_7 IS NULL )
2437 AND ( p_TODO_DATE_7 IS NULL )))
2438 AND ( ( Recinfo.TODO_START_TIME_7 = p_TODO_START_TIME_7)
2439 OR ( ( Recinfo.TODO_START_TIME_7 IS NULL )
2440 AND ( p_TODO_START_TIME_7 IS NULL )))
2441 AND ( ( Recinfo.ACTIVITY_CODE_7 = p_ACTIVITY_CODE_7)
2442 OR ( ( Recinfo.ACTIVITY_CODE_7 IS NULL )
2443 AND ( p_ACTIVITY_CODE_7 IS NULL )))
2444 AND ( ( Recinfo.INTERACTION_NOTES_8 = p_INTERACTION_NOTES_8)
2445 OR ( ( Recinfo.INTERACTION_NOTES_8 IS NULL )
2446 AND ( p_INTERACTION_NOTES_8 IS NULL )))
2447 AND ( ( Recinfo.PRIORITY_8 = p_PRIORITY_8)
2448 OR ( ( Recinfo.PRIORITY_8 IS NULL )
2449 AND ( p_PRIORITY_8 IS NULL )))
2450 AND ( ( Recinfo.TODO_DATE_8 = p_TODO_DATE_8)
2451 OR ( ( Recinfo.TODO_DATE_8 IS NULL )
2452 AND ( p_TODO_DATE_8 IS NULL )))
2453 AND ( ( Recinfo.TODO_START_TIME_8 = p_TODO_START_TIME_8)
2454 OR ( ( Recinfo.TODO_START_TIME_8 IS NULL )
2455 AND ( p_TODO_START_TIME_8 IS NULL )))
2456 AND ( ( Recinfo.ACTIVITY_CODE_8 = p_ACTIVITY_CODE_8)
2457 OR ( ( Recinfo.ACTIVITY_CODE_8 IS NULL )
2458 AND ( p_ACTIVITY_CODE_8 IS NULL )))
2459 AND ( ( Recinfo.INTERACTION_NOTES_9 = p_INTERACTION_NOTES_9)
2460 OR ( ( Recinfo.INTERACTION_NOTES_9 IS NULL )
2461 AND ( p_INTERACTION_NOTES_9 IS NULL )))
2462 AND ( ( Recinfo.PRIORITY_9 = p_PRIORITY_9)
2463 OR ( ( Recinfo.PRIORITY_9 IS NULL )
2464 AND ( p_PRIORITY_9 IS NULL )))
2465 AND ( ( Recinfo.TODO_DATE_9 = p_TODO_DATE_9)
2466 OR ( ( Recinfo.TODO_DATE_9 IS NULL )
2467 AND ( p_TODO_DATE_9 IS NULL )))
2468 AND ( ( Recinfo.TODO_START_TIME_9 = p_TODO_START_TIME_9)
2469 OR ( ( Recinfo.TODO_START_TIME_9 IS NULL )
2470 AND ( p_TODO_START_TIME_9 IS NULL )))
2471 AND ( ( Recinfo.ACTIVITY_CODE_9 = p_ACTIVITY_CODE_9)
2472 OR ( ( Recinfo.ACTIVITY_CODE_9 IS NULL )
2473 AND ( p_ACTIVITY_CODE_9 IS NULL )))
2474 AND ( ( Recinfo.INTERACTION_NOTES_10 = p_INTERACTION_NOTES_10)
2475 OR ( ( Recinfo.INTERACTION_NOTES_10 IS NULL )
2476 AND ( p_INTERACTION_NOTES_10 IS NULL )))
2477 AND ( ( Recinfo.PRIORITY_10 = p_PRIORITY_10)
2478 OR ( ( Recinfo.PRIORITY_10 IS NULL )
2479 AND ( p_PRIORITY_10 IS NULL )))
2480 AND ( ( Recinfo.TODO_DATE_10 = p_TODO_DATE_10)
2481 OR ( ( Recinfo.TODO_DATE_10 IS NULL )
2482 AND ( p_TODO_DATE_10 IS NULL )))
2483 AND ( ( Recinfo.TODO_START_TIME_10 = p_TODO_START_TIME_10)
2484 OR ( ( Recinfo.TODO_START_TIME_10 IS NULL )
2485 AND ( p_TODO_START_TIME_10 IS NULL )))
2486 AND ( ( Recinfo.ACTIVITY_CODE_10 = p_ACTIVITY_CODE_10)
2487 OR ( ( Recinfo.ACTIVITY_CODE_10 IS NULL )
2488 AND ( p_ACTIVITY_CODE_10 IS NULL )))
2489 AND ( ( Recinfo.LEAD_NOTE = p_LEAD_NOTE)
2490 OR ( ( Recinfo.LEAD_NOTE IS NULL )
2494 AND ( p_MIDDLE_INITIAL IS NULL )))
2491 AND ( p_LEAD_NOTE IS NULL )))
2492 AND ( ( Recinfo.MIDDLE_INITIAL = p_MIDDLE_INITIAL)
2493 OR ( ( Recinfo.MIDDLE_INITIAL IS NULL )
2495 AND ( ( Recinfo.FAX_NUMBER = p_FAX_NUMBER)
2496 OR ( ( Recinfo.FAX_NUMBER IS NULL )
2497 AND ( p_FAX_NUMBER IS NULL )))
2498 AND ( ( Recinfo.FAX_AREA_CODE = p_FAX_AREA_CODE)
2499 OR ( ( Recinfo.FAX_AREA_CODE IS NULL )
2500 AND ( p_FAX_AREA_CODE IS NULL )))
2501 AND ( ( Recinfo.MAIL_STOP = p_MAIL_STOP)
2502 OR ( ( Recinfo.MAIL_STOP IS NULL )
2503 AND ( p_MAIL_STOP IS NULL )))
2504 AND ( ( Recinfo.NUM_ENROLLED = p_NUM_ENROLLED)
2505 OR ( ( Recinfo.NUM_ENROLLED IS NULL )
2506 AND ( p_NUM_ENROLLED IS NULL )))
2507 AND ( ( Recinfo.CONFIRMED_FLAG = p_CONFIRMED_FLAG)
2508 OR ( ( Recinfo.CONFIRMED_FLAG IS NULL )
2509 AND ( p_CONFIRMED_FLAG IS NULL )))
2510 AND ( ( Recinfo.PAYMENT_AMOUNT = p_PAYMENT_AMOUNT)
2511 OR ( ( Recinfo.PAYMENT_AMOUNT IS NULL )
2512 AND ( p_PAYMENT_AMOUNT IS NULL )))
2513 AND ( ( Recinfo.NUM_ATTENDED = p_NUM_ATTENDED)
2514 OR ( ( Recinfo.NUM_ATTENDED IS NULL )
2515 AND ( p_NUM_ATTENDED IS NULL )))
2516 AND ( ( Recinfo.PROMOTION_NAME = p_PROMOTION_NAME)
2517 OR ( ( Recinfo.PROMOTION_NAME IS NULL )
2518 AND ( p_PROMOTION_NAME IS NULL )))
2519 AND ( ( Recinfo.STATUS_CHANGE_FLAG = p_STATUS_CHANGE_FLAG)
2520 OR ( ( Recinfo.STATUS_CHANGE_FLAG IS NULL )
2521 AND ( p_STATUS_CHANGE_FLAG IS NULL )))
2522 AND ( ( Recinfo.VEHICLE_RESPONSE_CODE = p_VEHICLE_RESPONSE_CODE)
2523 OR ( ( Recinfo.VEHICLE_RESPONSE_CODE IS NULL )
2524 AND ( p_VEHICLE_RESPONSE_CODE IS NULL )))
2525 AND ( ( Recinfo.SOURCE_SYSTEM = p_SOURCE_SYSTEM)
2526 OR ( ( Recinfo.SOURCE_SYSTEM IS NULL )
2527 AND ( p_SOURCE_SYSTEM IS NULL )))
2528 AND ( ( Recinfo.CONTACT_PARTY_ID = p_CONTACT_PARTY_ID)
2529 OR ( ( Recinfo.CONTACT_PARTY_ID IS NULL )
2530 AND ( p_CONTACT_PARTY_ID IS NULL )))
2531 AND ( ( Recinfo.PRM_SALES_LEAD_TYPE = p_PRM_SALES_LEAD_TYPE)
2532 OR ( ( Recinfo.PRM_SALES_LEAD_TYPE IS NULL )
2533 AND ( p_PRM_SALES_LEAD_TYPE IS NULL )))
2534 AND ( ( Recinfo.PRM_EXEC_SPONSOR_FLAG = p_PRM_EXEC_SPONSOR_FLAG)
2535 OR ( ( Recinfo.PRM_EXEC_SPONSOR_FLAG IS NULL )
2536 AND ( p_PRM_EXEC_SPONSOR_FLAG IS NULL )))
2537 AND ( ( Recinfo.PRM_PRJ_LEAD_IN_PLACE_FLAG = p_PRM_PRJ_LEAD_IN_PLACE_FLAG)
2538 OR ( ( Recinfo.PRM_PRJ_LEAD_IN_PLACE_FLAG IS NULL )
2539 AND ( p_PRM_PRJ_LEAD_IN_PLACE_FLAG IS NULL )))
2540 AND ( ( Recinfo.INCUMBENT_PARTNER_PARTY_ID = p_INC_PARTNER_PARTY_ID)
2541 OR ( ( Recinfo.INCUMBENT_PARTNER_PARTY_ID IS NULL )
2542 AND ( p_INC_PARTNER_PARTY_ID IS NULL )))
2543 AND ( ( Recinfo.INCUMBENT_PARTNER_RESOURCE_ID = p_INC_PARTNER_RESOURCE_ID)
2544 OR ( ( Recinfo.INCUMBENT_PARTNER_RESOURCE_ID IS NULL )
2545 AND ( p_INC_PARTNER_RESOURCE_ID IS NULL )))
2546 AND ( ( Recinfo.OFFER_ID = p_OFFER_ID)
2547 OR ( ( Recinfo.OFFER_ID IS NULL )
2548 AND ( p_OFFER_ID IS NULL )))
2549 AND ( ( Recinfo.PRM_IND_CLASSIFICATION_CODE = p_PRM_IND_CLASSIFICATION_CODE)
2550 OR ( ( Recinfo.PRM_IND_CLASSIFICATION_CODE IS NULL )
2551 AND ( p_PRM_IND_CLASSIFICATION_CODE IS NULL )))
2552 AND ( ( Recinfo.PARTY_TYPE = p_PARTY_TYPE)
2553 OR ( ( Recinfo.PARTY_TYPE IS NULL )
2554 AND ( p_PARTY_TYPE IS NULL )))
2555 AND ( ( Recinfo.BATCH_ID = p_BATCH_ID)
2556 OR ( ( Recinfo.BATCH_ID IS NULL )
2557 AND ( p_BATCH_ID IS NULL )))
2558 AND ( ( Recinfo.PARTY_ID = p_PARTY_ID)
2559 OR ( ( Recinfo.PARTY_ID IS NULL )
2560 AND ( p_PARTY_ID IS NULL )))
2561 AND ( ( Recinfo.PARTY_SITE_ID = p_PARTY_SITE_ID)
2562 OR ( ( Recinfo.PARTY_SITE_ID IS NULL )
2563 AND ( p_PARTY_SITE_ID IS NULL )))
2564 AND ( ( Recinfo.LOCATION_ID = p_LOCATION_ID)
2565 OR ( ( Recinfo.LOCATION_ID IS NULL )
2566 AND ( p_LOCATION_ID IS NULL )))
2567 AND ( ( Recinfo.REL_PARTY_ID = p_REL_PARTY_ID)
2568 OR ( ( Recinfo.REL_PARTY_ID IS NULL )
2569 AND ( p_REL_PARTY_ID IS NULL )))
2570 AND ( ( Recinfo.SALES_LEAD_ID = p_SALES_LEAD_ID)
2571 OR ( ( Recinfo.SALES_LEAD_ID IS NULL )
2572 AND ( p_SALES_LEAD_ID IS NULL )))
2573 AND ( ( Recinfo.ADDRESS_KEY = p_ADDRESS_KEY)
2574 OR ( ( Recinfo.ADDRESS_KEY IS NULL )
2575 AND ( p_ADDRESS_KEY IS NULL )))
2576 AND ( ( Recinfo.CONTACT_KEY = p_CONTACT_KEY)
2577 OR ( ( Recinfo.CONTACT_KEY IS NULL )
2578 AND ( p_CONTACT_KEY IS NULL )))
2579 AND ( ( Recinfo.JOB_TITLE_CODE = p_JOB_TITLE_CODE)
2580 OR ( ( Recinfo.JOB_TITLE_CODE IS NULL )
2581 AND ( p_JOB_TITLE_CODE IS NULL )))
2582 AND ( ( Recinfo.DO_NOT_PHONE_FLAG = p_DO_NOT_PHONE_FLAG)
2583 OR ( ( Recinfo.DO_NOT_PHONE_FLAG IS NULL )
2584 AND ( p_DO_NOT_PHONE_FLAG IS NULL )))
2585 AND ( ( Recinfo.DO_NOT_FAX_FLAG = p_DO_NOT_FAX_FLAG)
2586 OR ( ( Recinfo.DO_NOT_FAX_FLAG IS NULL )
2587 AND ( p_DO_NOT_FAX_FLAG IS NULL )))
2588 AND ( ( Recinfo.DO_NOT_EMAIL_FLAG = p_DO_NOT_EMAIL_FLAG)
2589 OR ( ( Recinfo.DO_NOT_EMAIL_FLAG IS NULL )
2590 AND ( p_DO_NOT_EMAIL_FLAG IS NULL )))
2591 AND ( ( Recinfo.ORIG_SYSTEM_REFERENCE = p_ORIG_SYSTEM_REFERENCE)
2595 OR ( ( Recinfo.LEAD_RANK_ID IS NULL )
2592 OR ( ( Recinfo.ORIG_SYSTEM_REFERENCE IS NULL )
2593 AND ( p_ORIG_SYSTEM_REFERENCE IS NULL )))
2594 AND ( ( Recinfo.LEAD_RANK_ID = p_LEAD_RANK_ID)
2596 AND ( p_LEAD_RANK_ID IS NULL )))
2597 AND ( ( Recinfo.NEW_PARTY_FLAG = p_NEW_PARTY_FLAG)
2598 OR ( ( Recinfo.NEW_PARTY_FLAG IS NULL )
2599 AND ( p_NEW_PARTY_FLAG IS NULL )))
2600 AND ( ( Recinfo.NEW_LOC_FLAG = p_NEW_LOC_FLAG)
2601 OR ( ( Recinfo.NEW_LOC_FLAG IS NULL )
2602 AND ( p_NEW_LOC_FLAG IS NULL )))
2603 AND ( ( Recinfo.NEW_PS_FLAG = p_NEW_PS_FLAG)
2604 OR ( ( Recinfo.NEW_PS_FLAG IS NULL )
2605 AND ( p_NEW_PS_FLAG IS NULL )))
2606 AND ( ( Recinfo.NEW_REL_FLAG = p_NEW_REL_FLAG)
2607 OR ( ( Recinfo.NEW_REL_FLAG IS NULL )
2608 AND ( p_NEW_REL_FLAG IS NULL )))
2609 AND ( ( Recinfo.NEW_CON_FLAG = p_NEW_CON_FLAG)
2610 OR ( ( Recinfo.NEW_CON_FLAG IS NULL )
2611 AND ( p_NEW_CON_FLAG IS NULL )))
2612 AND ( ( Recinfo.ORIG_SYSTEM_CODE = p_ORIG_SYSTEM_CODE)
2613 OR ( ( Recinfo.ORIG_SYSTEM_CODE IS NULL )
2614 AND ( p_ORIG_SYSTEM_CODE IS NULL )))
2615 AND ( ( Recinfo.URGENT_FLAG = p_URGENT_FLAG)
2616 OR ( ( Recinfo.URGENT_FLAG IS NULL )
2617 AND ( p_URGENT_FLAG IS NULL )))
2618 ) then
2619 return;
2620 else
2621 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
2622 APP_EXCEPTION.RAISE_EXCEPTION;
2623 End If;
2624 END Lock_Row;
2625
2626 End AS_IMPORT_INTERFACE_PKG;