[Home] [Help]
PACKAGE: APPS.AS_IMPORT_INTERFACE_PKG
Source
1 PACKAGE AS_IMPORT_INTERFACE_PKG AUTHID CURRENT_USER as
2 /* $Header: asxtlims.pls 115.8 2004/01/19 11:30:42 rramakri ship $ */
3 -- Start of Comments
4 -- Package name : AS_IMPORT_INTERFACE_PKG
5 -- Purpose :
6 -- History : added 7 new columns manually
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_IMPORT_INTERFACE_ID IN OUT NOCOPY NUMBER,
12 p_LAST_UPDATE_DATE DATE,
13 p_LAST_UPDATED_BY NUMBER,
14 p_CREATION_DATE DATE,
15 p_CREATED_BY NUMBER,
16 p_LAST_UPDATE_LOGIN NUMBER,
17 p_REQUEST_ID NUMBER,
18 p_PROGRAM_APPLICATION_ID NUMBER,
19 p_PROGRAM_ID NUMBER,
20 p_PROGRAM_UPDATE_DATE DATE,
21 p_IMP_LIST_HEADER_NUMBER VARCHAR2,
22 p_LOAD_TYPE VARCHAR2,
23 p_LOAD_DATE DATE,
24 p_LOAD_STATUS VARCHAR2,
25 p_LOAD_ERROR_MESSAGE VARCHAR2,
26 p_PROMOTION_ID NUMBER,
27 p_PROMOTION_CODE VARCHAR2,
28 p_CUSTOMER_ID NUMBER,
29 p_CUSTOMER_NAME VARCHAR2,
30 p_CUSTOMER_NUMBER VARCHAR2,
31 p_CUSTOMER_STATUS VARCHAR2,
32 p_CUSTOMER_TYPE VARCHAR2,
33 p_CUSTOMER_PROSPECT_CODE VARCHAR2,
34 p_CUSTOMER_CLASS_CODE VARCHAR2,
35 p_SALES_CHANNEL_CODE VARCHAR2,
36 p_SIC_CODE VARCHAR2,
37 p_ANALYSIS_FY VARCHAR2,
38 p_CUSTOMER_CATEGORY_CODE VARCHAR2,
39 p_CUSTOMER_GROUP_CODE VARCHAR2,
40 p_CUSTOMER_KEY VARCHAR2,
41 p_CUSTOMER_SUBGROUP_CODE VARCHAR2,
42 p_FISCAL_YEAREND_MONTH VARCHAR2,
43 p_NET_WORTH NUMBER,
44 p_NUM_OF_EMPLOYEES NUMBER,
45 p_POTENTIAL_REVENUE_CURR_FY NUMBER,
46 p_POTENTIAL_REVENUE_NEXT_FY NUMBER,
47 p_CUSTOMER_RANK VARCHAR2,
48 p_REFERENCE_USE_FLAG VARCHAR2,
49 p_TAX_CODE VARCHAR2,
50 p_TAX_REFERENCE VARCHAR2,
51 p_THIRD_PARTY_FLAG VARCHAR2,
52 p_COMPETITOR_FLAG VARCHAR2,
53 p_YEAR_ESTABLISHED NUMBER,
54 p_ADDR_DO_NOT_MAIL_FLAG VARCHAR2,
55 p_URL VARCHAR2,
56 p_ADDRESS_ID NUMBER,
57 p_CONT_DO_NOT_MAIL_FLAG VARCHAR2,
58 p_ADDRESS_STATUS VARCHAR2,
59 p_COUNTRY VARCHAR2,
60 p_ADDRESS1 VARCHAR2,
61 p_ADDRESS2 VARCHAR2,
62 p_ADDRESS3 VARCHAR2,
63 p_ADDRESS4 VARCHAR2,
64 p_CITY VARCHAR2,
65 p_POSTAL_CODE VARCHAR2,
66 p_STATE VARCHAR2,
67 p_PROVINCE VARCHAR2,
68 p_COUNTY VARCHAR2,
69 p_SITE_CONTACT_ID NUMBER,
70 p_EMAIL_ADDRESS VARCHAR2,
71 p_SEX_CODE VARCHAR2,
72 p_SALUTATION VARCHAR2,
73 p_LAST_NAME VARCHAR2,
74 p_TITLE VARCHAR2,
75 p_FIRST_NAME VARCHAR2,
76 p_JOB_TITLE VARCHAR2,
77 p_PHONE_ID NUMBER,
78 p_PHONE_NUMBER VARCHAR2,
79 p_PHONE_STATUS VARCHAR2,
80 p_PHONE_TYPE VARCHAR2,
81 p_AREA_CODE VARCHAR2,
82 p_EXTENSION VARCHAR2,
83 p_LEAD_NUMBER VARCHAR2,
84 p_STATUS_CODE VARCHAR2,
85 p_SOURCE_PROMOTION_ID NUMBER,
86 p_INITIATING_CONTACT_ID NUMBER,
87 p_CONTACT_ROLE_CODE VARCHAR2,
88 p_CHANNEL_CODE VARCHAR2,
89 p_BUDGET_AMOUNT NUMBER,
90 p_BUDGET_STATUS_CODE VARCHAR2,
91 p_CURRENCY_CODE VARCHAR2,
92 p_DECISION_TIMEFRAME_CODE VARCHAR2,
93 p_CLOSE_REASON VARCHAR2,
94 p_LEAD_RANK_CODE VARCHAR2,
95 p_PARENT_PROJECT VARCHAR2,
96 p_DESCRIPTION VARCHAR2,
97 p_STATUS_CODE_1 VARCHAR2,
98 p_INTEREST_TYPE_ID_1 NUMBER,
99 p_PRIMARY_INTEREST_CODE_ID_1 NUMBER,
100 p_SECONDARY_INTEREST_CODE_ID_1 NUMBER,
101 p_INVENTORY_ITEM_ID_1 NUMBER,
102 p_ORGANIZATION_ID_1 NUMBER,
103 p_UOM_CODE_1 VARCHAR2,
104 p_QUANTITY_1 NUMBER,
105 p_BUDGET_AMOUNT_1 NUMBER,
106 p_STATUS_CODE_2 VARCHAR2,
107 p_INTEREST_TYPE_ID_2 NUMBER,
108 p_PRIMARY_INTEREST_CODE_ID_2 NUMBER,
109 p_SECONDARY_INTEREST_CODE_ID_2 NUMBER,
110 p_INVENTORY_ITEM_ID_2 NUMBER,
111 p_ORGANIZATION_ID_2 NUMBER,
112 p_UOM_CODE_2 VARCHAR2,
113 p_QUANTITY_2 NUMBER,
114 p_BUDGET_AMOUNT_2 NUMBER,
115 p_STATUS_CODE_3 VARCHAR2,
116 p_INTEREST_TYPE_ID_3 NUMBER,
117 p_PRIMARY_INTEREST_CODE_ID_3 NUMBER,
118 p_SECONDARY_INTEREST_CODE_ID_3 NUMBER,
119 p_INVENTORY_ITEM_ID_3 NUMBER,
120 p_ORGANIZATION_ID_3 NUMBER,
121 p_UOM_CODE_3 VARCHAR2,
122 p_QUANTITY_3 NUMBER,
123 p_BUDGET_AMOUNT_3 NUMBER,
124 p_STATUS_CODE_4 VARCHAR2,
125 p_INTEREST_TYPE_ID_4 NUMBER,
126 p_PRIMARY_INTEREST_CODE_ID_4 NUMBER,
127 p_SECONDARY_INTEREST_CODE_ID_4 NUMBER,
128 p_INVENTORY_ITEM_ID_4 NUMBER,
129 p_ORGANIZATION_ID_4 NUMBER,
130 p_UOM_CODE_4 VARCHAR2,
131 p_QUANTITY_4 NUMBER,
132 p_BUDGET_AMOUNT_4 NUMBER,
133 p_STATUS_CODE_5 VARCHAR2,
134 p_INTEREST_TYPE_ID_5 NUMBER,
135 p_PRIMARY_INTEREST_CODE_ID_5 NUMBER,
136 p_SECONDARY_INTEREST_CODE_ID_5 NUMBER,
137 p_INVENTORY_ITEM_ID_5 NUMBER,
138 p_ORGANIZATION_ID_5 NUMBER,
139 p_UOM_CODE_5 VARCHAR2,
140 p_QUANTITY_5 NUMBER,
141 p_BUDGET_AMOUNT_5 NUMBER,
142 p_INTERACTION_NOTES_1 VARCHAR2,
143 p_PRIORITY_1 NUMBER,
144 p_TODO_DATE_1 DATE,
145 p_TODO_START_TIME_1 VARCHAR2,
146 p_ACTIVITY_CODE_1 VARCHAR2,
147 p_INTERACTION_NOTES_2 VARCHAR2,
148 p_PRIORITY_2 NUMBER,
149 p_TODO_DATE_2 DATE,
150 p_TODO_START_TIME_2 VARCHAR2,
151 p_ACTIVITY_CODE_2 VARCHAR2,
152 p_INTERACTION_NOTES_3 VARCHAR2,
153 p_PRIORITY_3 NUMBER,
154 p_TODO_DATE_3 DATE,
155 p_TODO_START_TIME_3 VARCHAR2,
156 p_ACTIVITY_CODE_3 VARCHAR2,
157 p_INTERACTION_NOTES_4 VARCHAR2,
158 p_PRIORITY_4 NUMBER,
159 p_TODO_DATE_4 DATE,
160 p_TODO_START_TIME_4 VARCHAR2,
161 p_ACTIVITY_CODE_4 VARCHAR2,
162 p_INTERACTION_NOTES_5 VARCHAR2,
163 p_PRIORITY_5 NUMBER,
164 p_TODO_DATE_5 DATE,
165 p_TODO_START_TIME_5 VARCHAR2,
166 p_ACTIVITY_CODE_5 VARCHAR2,
167 p_INTERACTION_NOTES_6 VARCHAR2,
168 p_PRIORITY_6 NUMBER,
169 p_TODO_DATE_6 DATE,
170 p_TODO_START_TIME_6 VARCHAR2,
171 p_ACTIVITY_CODE_6 VARCHAR2,
172 p_INTERACTION_NOTES_7 VARCHAR2,
173 p_PRIORITY_7 NUMBER,
174 p_TODO_DATE_7 DATE,
175 p_TODO_START_TIME_7 VARCHAR2,
176 p_ACTIVITY_CODE_7 VARCHAR2,
177 p_INTERACTION_NOTES_8 VARCHAR2,
178 p_PRIORITY_8 NUMBER,
179 p_TODO_DATE_8 DATE,
180 p_TODO_START_TIME_8 VARCHAR2,
181 p_ACTIVITY_CODE_8 VARCHAR2,
182 p_INTERACTION_NOTES_9 VARCHAR2,
183 p_PRIORITY_9 NUMBER,
184 p_TODO_DATE_9 DATE,
185 p_TODO_START_TIME_9 VARCHAR2,
186 p_ACTIVITY_CODE_9 VARCHAR2,
187 p_INTERACTION_NOTES_10 VARCHAR2,
188 p_PRIORITY_10 NUMBER,
189 p_TODO_DATE_10 DATE,
190 p_TODO_START_TIME_10 VARCHAR2,
191 p_ACTIVITY_CODE_10 VARCHAR2,
192 p_LEAD_NOTE VARCHAR2,
193 p_MIDDLE_INITIAL VARCHAR2,
194 p_FAX_NUMBER VARCHAR2,
195 p_FAX_AREA_CODE VARCHAR2,
196 p_MAIL_STOP VARCHAR2,
197 p_NUM_ENROLLED NUMBER,
198 p_CONFIRMED_FLAG VARCHAR2,
199 p_PAYMENT_AMOUNT NUMBER,
200 p_NUM_ATTENDED NUMBER,
201 p_PROMOTION_NAME VARCHAR2,
202 p_STATUS_CHANGE_FLAG VARCHAR2,
203 p_VEHICLE_RESPONSE_CODE VARCHAR2,
204 p_SOURCE_SYSTEM VARCHAR2,
205 p_CONTACT_PARTY_ID NUMBER,
206 p_PRM_SALES_LEAD_TYPE VARCHAR2,
207 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
208 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
209 p_INC_PARTNER_PARTY_ID NUMBER,
210 p_INC_PARTNER_RESOURCE_ID NUMBER,
211 p_OFFER_ID NUMBER,
212 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
213 p_PARTY_TYPE VARCHAR2,
214 p_BATCH_ID NUMBER,
215 p_PARTY_ID NUMBER,
216 p_PARTY_SITE_ID NUMBER,
217 p_LOCATION_ID NUMBER,
218 p_REL_PARTY_ID NUMBER,
219 p_SALES_LEAD_ID NUMBER,
220 p_ADDRESS_KEY VARCHAR2,
221 p_CONTACT_KEY VARCHAR2,
222 p_JOB_TITLE_CODE VARCHAR2,
223 p_DO_NOT_PHONE_FLAG VARCHAR2,
224 p_DO_NOT_FAX_FLAG VARCHAR2,
225 p_DO_NOT_EMAIL_FLAG VARCHAR2,
226 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
227 p_LEAD_RANK_ID NUMBER,
228 p_NEW_PARTY_FLAG NUMBER,
229 p_NEW_LOC_FLAG NUMBER,
230 p_NEW_PS_FLAG NUMBER,
231 p_NEW_REL_FLAG NUMBER,
232 p_NEW_CON_FLAG NUMBER,
233 p_ORIG_SYSTEM_CODE VARCHAR2,
234 p_URGENT_FLAG VARCHAR2,
235 p_SIC_CODE_TYPE VARCHAR2,
236 p_SITE_USE_TYPE VARCHAR2,
237 p_PRIMARY_CONTACT_FLAG VARCHAR2,
238 p_RANK VARCHAR2,
239 p_ADDRESS_STYLE VARCHAR2,
240 p_PRIMARY_PER_TYPE VARCHAR2,
241 p_DEPARTMENT_CODE VARCHAR2);
242
243 PROCEDURE Update_Row(
244 p_IMPORT_INTERFACE_ID NUMBER,
245 p_LAST_UPDATE_DATE DATE,
246 p_LAST_UPDATED_BY NUMBER,
247 p_CREATION_DATE DATE,
248 p_CREATED_BY NUMBER,
249 p_LAST_UPDATE_LOGIN NUMBER,
250 p_REQUEST_ID NUMBER,
251 p_PROGRAM_APPLICATION_ID NUMBER,
252 p_PROGRAM_ID NUMBER,
253 p_PROGRAM_UPDATE_DATE DATE,
254 p_IMP_LIST_HEADER_NUMBER VARCHAR2,
255 p_LOAD_TYPE VARCHAR2,
256 p_LOAD_DATE DATE,
257 p_LOAD_STATUS VARCHAR2,
258 p_LOAD_ERROR_MESSAGE VARCHAR2,
259 p_PROMOTION_ID NUMBER,
260 p_PROMOTION_CODE VARCHAR2,
261 p_CUSTOMER_ID NUMBER,
262 p_CUSTOMER_NAME VARCHAR2,
263 p_CUSTOMER_NUMBER VARCHAR2,
264 p_CUSTOMER_STATUS VARCHAR2,
265 p_CUSTOMER_TYPE VARCHAR2,
266 p_CUSTOMER_PROSPECT_CODE VARCHAR2,
267 p_CUSTOMER_CLASS_CODE VARCHAR2,
268 p_SALES_CHANNEL_CODE VARCHAR2,
269 p_SIC_CODE VARCHAR2,
270 p_ANALYSIS_FY VARCHAR2,
271 p_CUSTOMER_CATEGORY_CODE VARCHAR2,
272 p_CUSTOMER_GROUP_CODE VARCHAR2,
273 p_CUSTOMER_KEY VARCHAR2,
274 p_CUSTOMER_SUBGROUP_CODE VARCHAR2,
275 p_FISCAL_YEAREND_MONTH VARCHAR2,
276 p_NET_WORTH NUMBER,
277 p_NUM_OF_EMPLOYEES NUMBER,
278 p_POTENTIAL_REVENUE_CURR_FY NUMBER,
279 p_POTENTIAL_REVENUE_NEXT_FY NUMBER,
280 p_CUSTOMER_RANK VARCHAR2,
281 p_REFERENCE_USE_FLAG VARCHAR2,
282 p_TAX_CODE VARCHAR2,
283 p_TAX_REFERENCE VARCHAR2,
284 p_THIRD_PARTY_FLAG VARCHAR2,
285 p_COMPETITOR_FLAG VARCHAR2,
286 p_YEAR_ESTABLISHED NUMBER,
287 p_ADDR_DO_NOT_MAIL_FLAG VARCHAR2,
288 p_URL VARCHAR2,
289 p_ADDRESS_ID NUMBER,
290 p_CONT_DO_NOT_MAIL_FLAG VARCHAR2,
291 p_ADDRESS_STATUS VARCHAR2,
292 p_COUNTRY VARCHAR2,
293 p_ADDRESS1 VARCHAR2,
294 p_ADDRESS2 VARCHAR2,
295 p_ADDRESS3 VARCHAR2,
296 p_ADDRESS4 VARCHAR2,
297 p_CITY VARCHAR2,
298 p_POSTAL_CODE VARCHAR2,
299 p_STATE VARCHAR2,
300 p_PROVINCE VARCHAR2,
301 p_COUNTY VARCHAR2,
302 p_SITE_CONTACT_ID NUMBER,
303 p_EMAIL_ADDRESS VARCHAR2,
304 p_SEX_CODE VARCHAR2,
305 p_SALUTATION VARCHAR2,
306 p_LAST_NAME VARCHAR2,
307 p_TITLE VARCHAR2,
308 p_FIRST_NAME VARCHAR2,
309 p_JOB_TITLE VARCHAR2,
310 p_PHONE_ID NUMBER,
311 p_PHONE_NUMBER VARCHAR2,
312 p_PHONE_STATUS VARCHAR2,
313 p_PHONE_TYPE VARCHAR2,
314 p_AREA_CODE VARCHAR2,
315 p_EXTENSION VARCHAR2,
316 p_LEAD_NUMBER VARCHAR2,
317 p_STATUS_CODE VARCHAR2,
318 p_SOURCE_PROMOTION_ID NUMBER,
319 p_INITIATING_CONTACT_ID NUMBER,
320 p_CONTACT_ROLE_CODE VARCHAR2,
321 p_CHANNEL_CODE VARCHAR2,
322 p_BUDGET_AMOUNT NUMBER,
323 p_BUDGET_STATUS_CODE VARCHAR2,
324 p_CURRENCY_CODE VARCHAR2,
325 p_DECISION_TIMEFRAME_CODE VARCHAR2,
326 p_CLOSE_REASON VARCHAR2,
327 p_LEAD_RANK_CODE VARCHAR2,
328 p_PARENT_PROJECT VARCHAR2,
329 p_DESCRIPTION VARCHAR2,
330 p_STATUS_CODE_1 VARCHAR2,
331 p_INTEREST_TYPE_ID_1 NUMBER,
332 p_PRIMARY_INTEREST_CODE_ID_1 NUMBER,
333 p_SECONDARY_INTEREST_CODE_ID_1 NUMBER,
334 p_INVENTORY_ITEM_ID_1 NUMBER,
335 p_ORGANIZATION_ID_1 NUMBER,
336 p_UOM_CODE_1 VARCHAR2,
337 p_QUANTITY_1 NUMBER,
338 p_BUDGET_AMOUNT_1 NUMBER,
339 p_STATUS_CODE_2 VARCHAR2,
340 p_INTEREST_TYPE_ID_2 NUMBER,
341 p_PRIMARY_INTEREST_CODE_ID_2 NUMBER,
342 p_SECONDARY_INTEREST_CODE_ID_2 NUMBER,
343 p_INVENTORY_ITEM_ID_2 NUMBER,
344 p_ORGANIZATION_ID_2 NUMBER,
345 p_UOM_CODE_2 VARCHAR2,
346 p_QUANTITY_2 NUMBER,
347 p_BUDGET_AMOUNT_2 NUMBER,
348 p_STATUS_CODE_3 VARCHAR2,
349 p_INTEREST_TYPE_ID_3 NUMBER,
350 p_PRIMARY_INTEREST_CODE_ID_3 NUMBER,
351 p_SECONDARY_INTEREST_CODE_ID_3 NUMBER,
352 p_INVENTORY_ITEM_ID_3 NUMBER,
353 p_ORGANIZATION_ID_3 NUMBER,
354 p_UOM_CODE_3 VARCHAR2,
355 p_QUANTITY_3 NUMBER,
356 p_BUDGET_AMOUNT_3 NUMBER,
357 p_STATUS_CODE_4 VARCHAR2,
358 p_INTEREST_TYPE_ID_4 NUMBER,
359 p_PRIMARY_INTEREST_CODE_ID_4 NUMBER,
360 p_SECONDARY_INTEREST_CODE_ID_4 NUMBER,
361 p_INVENTORY_ITEM_ID_4 NUMBER,
362 p_ORGANIZATION_ID_4 NUMBER,
363 p_UOM_CODE_4 VARCHAR2,
364 p_QUANTITY_4 NUMBER,
365 p_BUDGET_AMOUNT_4 NUMBER,
366 p_STATUS_CODE_5 VARCHAR2,
367 p_INTEREST_TYPE_ID_5 NUMBER,
368 p_PRIMARY_INTEREST_CODE_ID_5 NUMBER,
369 p_SECONDARY_INTEREST_CODE_ID_5 NUMBER,
370 p_INVENTORY_ITEM_ID_5 NUMBER,
371 p_ORGANIZATION_ID_5 NUMBER,
372 p_UOM_CODE_5 VARCHAR2,
373 p_QUANTITY_5 NUMBER,
374 p_BUDGET_AMOUNT_5 NUMBER,
375 p_INTERACTION_NOTES_1 VARCHAR2,
379 p_ACTIVITY_CODE_1 VARCHAR2,
376 p_PRIORITY_1 NUMBER,
377 p_TODO_DATE_1 DATE,
378 p_TODO_START_TIME_1 VARCHAR2,
380 p_INTERACTION_NOTES_2 VARCHAR2,
381 p_PRIORITY_2 NUMBER,
382 p_TODO_DATE_2 DATE,
383 p_TODO_START_TIME_2 VARCHAR2,
384 p_ACTIVITY_CODE_2 VARCHAR2,
385 p_INTERACTION_NOTES_3 VARCHAR2,
386 p_PRIORITY_3 NUMBER,
387 p_TODO_DATE_3 DATE,
388 p_TODO_START_TIME_3 VARCHAR2,
389 p_ACTIVITY_CODE_3 VARCHAR2,
390 p_INTERACTION_NOTES_4 VARCHAR2,
391 p_PRIORITY_4 NUMBER,
392 p_TODO_DATE_4 DATE,
393 p_TODO_START_TIME_4 VARCHAR2,
394 p_ACTIVITY_CODE_4 VARCHAR2,
395 p_INTERACTION_NOTES_5 VARCHAR2,
396 p_PRIORITY_5 NUMBER,
397 p_TODO_DATE_5 DATE,
398 p_TODO_START_TIME_5 VARCHAR2,
399 p_ACTIVITY_CODE_5 VARCHAR2,
400 p_INTERACTION_NOTES_6 VARCHAR2,
401 p_PRIORITY_6 NUMBER,
402 p_TODO_DATE_6 DATE,
403 p_TODO_START_TIME_6 VARCHAR2,
404 p_ACTIVITY_CODE_6 VARCHAR2,
405 p_INTERACTION_NOTES_7 VARCHAR2,
406 p_PRIORITY_7 NUMBER,
407 p_TODO_DATE_7 DATE,
408 p_TODO_START_TIME_7 VARCHAR2,
409 p_ACTIVITY_CODE_7 VARCHAR2,
410 p_INTERACTION_NOTES_8 VARCHAR2,
411 p_PRIORITY_8 NUMBER,
412 p_TODO_DATE_8 DATE,
413 p_TODO_START_TIME_8 VARCHAR2,
414 p_ACTIVITY_CODE_8 VARCHAR2,
415 p_INTERACTION_NOTES_9 VARCHAR2,
416 p_PRIORITY_9 NUMBER,
417 p_TODO_DATE_9 DATE,
418 p_TODO_START_TIME_9 VARCHAR2,
419 p_ACTIVITY_CODE_9 VARCHAR2,
420 p_INTERACTION_NOTES_10 VARCHAR2,
421 p_PRIORITY_10 NUMBER,
422 p_TODO_DATE_10 DATE,
423 p_TODO_START_TIME_10 VARCHAR2,
424 p_ACTIVITY_CODE_10 VARCHAR2,
425 p_LEAD_NOTE VARCHAR2,
426 p_MIDDLE_INITIAL VARCHAR2,
427 p_FAX_NUMBER VARCHAR2,
428 p_FAX_AREA_CODE VARCHAR2,
429 p_MAIL_STOP VARCHAR2,
430 p_NUM_ENROLLED NUMBER,
431 p_CONFIRMED_FLAG VARCHAR2,
432 p_PAYMENT_AMOUNT NUMBER,
433 p_NUM_ATTENDED NUMBER,
434 p_PROMOTION_NAME VARCHAR2,
435 p_STATUS_CHANGE_FLAG VARCHAR2,
436 p_VEHICLE_RESPONSE_CODE VARCHAR2,
437 p_SOURCE_SYSTEM VARCHAR2,
438 p_CONTACT_PARTY_ID NUMBER,
439 p_PRM_SALES_LEAD_TYPE VARCHAR2,
440 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
441 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
442 p_INC_PARTNER_PARTY_ID NUMBER,
443 p_INC_PARTNER_RESOURCE_ID NUMBER,
444 p_OFFER_ID NUMBER,
445 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
446 p_PARTY_TYPE VARCHAR2,
447 p_BATCH_ID NUMBER,
448 p_PARTY_ID NUMBER,
449 p_PARTY_SITE_ID NUMBER,
450 p_LOCATION_ID NUMBER,
451 p_REL_PARTY_ID NUMBER,
452 p_SALES_LEAD_ID NUMBER,
453 p_ADDRESS_KEY VARCHAR2,
454 p_CONTACT_KEY VARCHAR2,
455 p_JOB_TITLE_CODE VARCHAR2,
456 p_DO_NOT_PHONE_FLAG VARCHAR2,
457 p_DO_NOT_FAX_FLAG VARCHAR2,
458 p_DO_NOT_EMAIL_FLAG VARCHAR2,
459 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
460 p_LEAD_RANK_ID NUMBER,
461 p_NEW_PARTY_FLAG NUMBER,
462 p_NEW_LOC_FLAG NUMBER,
463 p_NEW_PS_FLAG NUMBER,
464 p_NEW_REL_FLAG NUMBER,
465 p_NEW_CON_FLAG NUMBER,
466 p_ORIG_SYSTEM_CODE VARCHAR2,
467 p_URGENT_FLAG VARCHAR2,
468 p_SIC_CODE_TYPE VARCHAR2,
469 p_SITE_USE_TYPE VARCHAR2,
470 p_PRIMARY_CONTACT_FLAG VARCHAR2,
471 p_RANK VARCHAR2,
472 p_ADDRESS_STYLE VARCHAR2,
473 p_PRIMARY_PER_TYPE VARCHAR2,
474 p_DEPARTMENT_CODE VARCHAR2);
475
476
477 PROCEDURE Update_Row(
478 p_IMPORT_INTERFACE_ID NUMBER,
479 p_LAST_UPDATE_DATE DATE,
480 p_LAST_UPDATED_BY NUMBER,
481 p_CREATION_DATE DATE,
482 p_CREATED_BY NUMBER,
483 p_LAST_UPDATE_LOGIN NUMBER,
484 p_REQUEST_ID NUMBER,
485 p_PROGRAM_APPLICATION_ID NUMBER,
486 p_PROGRAM_ID NUMBER,
487 p_PROGRAM_UPDATE_DATE DATE,
488 p_IMP_LIST_HEADER_NUMBER VARCHAR2,
489 p_LOAD_TYPE VARCHAR2,
490 p_LOAD_DATE DATE,
491 p_LOAD_STATUS VARCHAR2,
492 p_LOAD_ERROR_MESSAGE VARCHAR2,
493 p_PROMOTION_ID NUMBER,
494 p_PROMOTION_CODE VARCHAR2,
495 p_CUSTOMER_ID NUMBER,
496 p_CUSTOMER_NAME VARCHAR2,
497 p_CUSTOMER_NUMBER VARCHAR2,
498 p_CUSTOMER_STATUS VARCHAR2,
499 p_CUSTOMER_TYPE VARCHAR2,
500 p_CUSTOMER_PROSPECT_CODE VARCHAR2,
501 p_CUSTOMER_CLASS_CODE VARCHAR2,
505 p_CUSTOMER_CATEGORY_CODE VARCHAR2,
502 p_SALES_CHANNEL_CODE VARCHAR2,
503 p_SIC_CODE VARCHAR2,
504 p_ANALYSIS_FY VARCHAR2,
506 p_CUSTOMER_GROUP_CODE VARCHAR2,
507 p_CUSTOMER_KEY VARCHAR2,
508 p_CUSTOMER_SUBGROUP_CODE VARCHAR2,
509 p_FISCAL_YEAREND_MONTH VARCHAR2,
510 p_NET_WORTH NUMBER,
511 p_NUM_OF_EMPLOYEES NUMBER,
512 p_POTENTIAL_REVENUE_CURR_FY NUMBER,
513 p_POTENTIAL_REVENUE_NEXT_FY NUMBER,
514 p_CUSTOMER_RANK VARCHAR2,
515 p_REFERENCE_USE_FLAG VARCHAR2,
516 p_TAX_CODE VARCHAR2,
517 p_TAX_REFERENCE VARCHAR2,
518 p_THIRD_PARTY_FLAG VARCHAR2,
519 p_COMPETITOR_FLAG VARCHAR2,
520 p_YEAR_ESTABLISHED NUMBER,
521 p_ADDR_DO_NOT_MAIL_FLAG VARCHAR2,
522 p_URL VARCHAR2,
523 p_ADDRESS_ID NUMBER,
524 p_CONT_DO_NOT_MAIL_FLAG VARCHAR2,
525 p_ADDRESS_STATUS VARCHAR2,
526 p_COUNTRY VARCHAR2,
527 p_ADDRESS1 VARCHAR2,
528 p_ADDRESS2 VARCHAR2,
529 p_ADDRESS3 VARCHAR2,
530 p_ADDRESS4 VARCHAR2,
531 p_CITY VARCHAR2,
532 p_POSTAL_CODE VARCHAR2,
533 p_STATE VARCHAR2,
534 p_PROVINCE VARCHAR2,
535 p_COUNTY VARCHAR2,
536 p_SITE_CONTACT_ID NUMBER,
537 p_EMAIL_ADDRESS VARCHAR2,
538 p_SEX_CODE VARCHAR2,
539 p_SALUTATION VARCHAR2,
540 p_LAST_NAME VARCHAR2,
541 p_TITLE VARCHAR2,
542 p_FIRST_NAME VARCHAR2,
543 p_JOB_TITLE VARCHAR2,
544 p_PHONE_ID NUMBER,
545 p_PHONE_NUMBER VARCHAR2,
546 p_PHONE_STATUS VARCHAR2,
547 p_PHONE_TYPE VARCHAR2,
548 p_AREA_CODE VARCHAR2,
549 p_EXTENSION VARCHAR2,
550 p_LEAD_NUMBER VARCHAR2,
551 p_STATUS_CODE VARCHAR2,
552 p_SOURCE_PROMOTION_ID NUMBER,
553 p_INITIATING_CONTACT_ID NUMBER,
554 p_CONTACT_ROLE_CODE VARCHAR2,
555 p_CHANNEL_CODE VARCHAR2,
556 p_BUDGET_AMOUNT NUMBER,
557 p_BUDGET_STATUS_CODE VARCHAR2,
558 p_CURRENCY_CODE VARCHAR2,
559 p_DECISION_TIMEFRAME_CODE VARCHAR2,
560 p_CLOSE_REASON VARCHAR2,
561 p_LEAD_RANK_CODE VARCHAR2,
562 p_PARENT_PROJECT VARCHAR2,
563 p_DESCRIPTION VARCHAR2,
564 p_STATUS_CODE_1 VARCHAR2,
565 p_INTEREST_TYPE_ID_1 NUMBER,
566 p_PRIMARY_INTEREST_CODE_ID_1 NUMBER,
567 p_SECONDARY_INTEREST_CODE_ID_1 NUMBER,
568 p_INVENTORY_ITEM_ID_1 NUMBER,
569 p_ORGANIZATION_ID_1 NUMBER,
570 p_UOM_CODE_1 VARCHAR2,
571 p_QUANTITY_1 NUMBER,
572 p_BUDGET_AMOUNT_1 NUMBER,
573 p_STATUS_CODE_2 VARCHAR2,
574 p_INTEREST_TYPE_ID_2 NUMBER,
575 p_PRIMARY_INTEREST_CODE_ID_2 NUMBER,
576 p_SECONDARY_INTEREST_CODE_ID_2 NUMBER,
577 p_INVENTORY_ITEM_ID_2 NUMBER,
578 p_ORGANIZATION_ID_2 NUMBER,
579 p_UOM_CODE_2 VARCHAR2,
580 p_QUANTITY_2 NUMBER,
581 p_BUDGET_AMOUNT_2 NUMBER,
582 p_STATUS_CODE_3 VARCHAR2,
583 p_INTEREST_TYPE_ID_3 NUMBER,
584 p_PRIMARY_INTEREST_CODE_ID_3 NUMBER,
585 p_SECONDARY_INTEREST_CODE_ID_3 NUMBER,
586 p_INVENTORY_ITEM_ID_3 NUMBER,
587 p_ORGANIZATION_ID_3 NUMBER,
588 p_UOM_CODE_3 VARCHAR2,
589 p_QUANTITY_3 NUMBER,
590 p_BUDGET_AMOUNT_3 NUMBER,
591 p_STATUS_CODE_4 VARCHAR2,
592 p_INTEREST_TYPE_ID_4 NUMBER,
593 p_PRIMARY_INTEREST_CODE_ID_4 NUMBER,
594 p_SECONDARY_INTEREST_CODE_ID_4 NUMBER,
595 p_INVENTORY_ITEM_ID_4 NUMBER,
596 p_ORGANIZATION_ID_4 NUMBER,
597 p_UOM_CODE_4 VARCHAR2,
598 p_QUANTITY_4 NUMBER,
599 p_BUDGET_AMOUNT_4 NUMBER,
600 p_STATUS_CODE_5 VARCHAR2,
601 p_INTEREST_TYPE_ID_5 NUMBER,
602 p_PRIMARY_INTEREST_CODE_ID_5 NUMBER,
603 p_SECONDARY_INTEREST_CODE_ID_5 NUMBER,
604 p_INVENTORY_ITEM_ID_5 NUMBER,
605 p_ORGANIZATION_ID_5 NUMBER,
606 p_UOM_CODE_5 VARCHAR2,
607 p_QUANTITY_5 NUMBER,
608 p_BUDGET_AMOUNT_5 NUMBER,
609 p_INTERACTION_NOTES_1 VARCHAR2,
610 p_PRIORITY_1 NUMBER,
611 p_TODO_DATE_1 DATE,
612 p_TODO_START_TIME_1 VARCHAR2,
613 p_ACTIVITY_CODE_1 VARCHAR2,
614 p_INTERACTION_NOTES_2 VARCHAR2,
615 p_PRIORITY_2 NUMBER,
616 p_TODO_DATE_2 DATE,
617 p_TODO_START_TIME_2 VARCHAR2,
618 p_ACTIVITY_CODE_2 VARCHAR2,
619 p_INTERACTION_NOTES_3 VARCHAR2,
620 p_PRIORITY_3 NUMBER,
621 p_TODO_DATE_3 DATE,
622 p_TODO_START_TIME_3 VARCHAR2,
623 p_ACTIVITY_CODE_3 VARCHAR2,
624 p_INTERACTION_NOTES_4 VARCHAR2,
625 p_PRIORITY_4 NUMBER,
629 p_INTERACTION_NOTES_5 VARCHAR2,
626 p_TODO_DATE_4 DATE,
627 p_TODO_START_TIME_4 VARCHAR2,
628 p_ACTIVITY_CODE_4 VARCHAR2,
630 p_PRIORITY_5 NUMBER,
631 p_TODO_DATE_5 DATE,
632 p_TODO_START_TIME_5 VARCHAR2,
633 p_ACTIVITY_CODE_5 VARCHAR2,
634 p_INTERACTION_NOTES_6 VARCHAR2,
635 p_PRIORITY_6 NUMBER,
636 p_TODO_DATE_6 DATE,
637 p_TODO_START_TIME_6 VARCHAR2,
638 p_ACTIVITY_CODE_6 VARCHAR2,
639 p_INTERACTION_NOTES_7 VARCHAR2,
640 p_PRIORITY_7 NUMBER,
641 p_TODO_DATE_7 DATE,
642 p_TODO_START_TIME_7 VARCHAR2,
643 p_ACTIVITY_CODE_7 VARCHAR2,
644 p_INTERACTION_NOTES_8 VARCHAR2,
645 p_PRIORITY_8 NUMBER,
646 p_TODO_DATE_8 DATE,
647 p_TODO_START_TIME_8 VARCHAR2,
648 p_ACTIVITY_CODE_8 VARCHAR2,
649 p_INTERACTION_NOTES_9 VARCHAR2,
650 p_PRIORITY_9 NUMBER,
651 p_TODO_DATE_9 DATE,
652 p_TODO_START_TIME_9 VARCHAR2,
653 p_ACTIVITY_CODE_9 VARCHAR2,
654 p_INTERACTION_NOTES_10 VARCHAR2,
655 p_PRIORITY_10 NUMBER,
656 p_TODO_DATE_10 DATE,
657 p_TODO_START_TIME_10 VARCHAR2,
658 p_ACTIVITY_CODE_10 VARCHAR2,
659 p_LEAD_NOTE VARCHAR2,
660 p_MIDDLE_INITIAL VARCHAR2,
661 p_FAX_NUMBER VARCHAR2,
662 p_FAX_AREA_CODE VARCHAR2,
663 p_MAIL_STOP VARCHAR2,
664 p_NUM_ENROLLED NUMBER,
665 p_CONFIRMED_FLAG VARCHAR2,
666 p_PAYMENT_AMOUNT NUMBER,
667 p_NUM_ATTENDED NUMBER,
668 p_PROMOTION_NAME VARCHAR2,
669 p_STATUS_CHANGE_FLAG VARCHAR2,
670 p_VEHICLE_RESPONSE_CODE VARCHAR2,
671 p_SOURCE_SYSTEM VARCHAR2,
672 p_CONTACT_PARTY_ID NUMBER,
673 p_PRM_SALES_LEAD_TYPE VARCHAR2,
674 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
675 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
676 p_INC_PARTNER_PARTY_ID NUMBER,
677 p_INC_PARTNER_RESOURCE_ID NUMBER,
678 p_OFFER_ID NUMBER,
679 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
680 p_PARTY_TYPE VARCHAR2,
681 p_BATCH_ID NUMBER,
682 p_PARTY_ID NUMBER,
683 p_PARTY_SITE_ID NUMBER,
684 p_LOCATION_ID NUMBER,
685 p_REL_PARTY_ID NUMBER,
686 p_SALES_LEAD_ID NUMBER,
687 p_ADDRESS_KEY VARCHAR2,
688 p_CONTACT_KEY VARCHAR2,
689 p_JOB_TITLE_CODE VARCHAR2,
690 p_DO_NOT_PHONE_FLAG VARCHAR2,
691 p_DO_NOT_FAX_FLAG VARCHAR2,
692 p_DO_NOT_EMAIL_FLAG VARCHAR2,
693 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
694 p_LEAD_RANK_ID NUMBER,
695 p_NEW_PARTY_FLAG NUMBER,
696 p_NEW_LOC_FLAG NUMBER,
697 p_NEW_PS_FLAG NUMBER,
698 p_NEW_REL_FLAG NUMBER,
699 p_NEW_CON_FLAG NUMBER,
700 p_ORIG_SYSTEM_CODE VARCHAR2,
701 p_URGENT_FLAG VARCHAR2,
702 p_SIC_CODE_TYPE VARCHAR2,
703 p_SITE_USE_TYPE VARCHAR2,
704 p_PRIMARY_CONTACT_FLAG VARCHAR2,
705 p_RANK VARCHAR2,
706 p_ADDRESS_STYLE VARCHAR2,
707 p_PRIMARY_PER_TYPE VARCHAR2,
708 p_DEPARTMENT_CODE VARCHAR2,
709 p_SALES_FORCE_ID NUMBER,
710 p_GROUP_ID NUMBER,
711 p_PERSON_ID NUMBER,
712 p_CATEGORY_ID1 NUMBER DEFAULT NULL,
713 p_CATEGORY_ID2 NUMBER DEFAULT NULL,
714 p_CATEGORY_ID3 NUMBER DEFAULT NULL,
715 p_CATEGORY_ID4 NUMBER DEFAULT NULL,
716 p_CATEGORY_ID5 NUMBER DEFAULT NULL);
717
718
719 PROCEDURE Lock_Row(
720 p_IMPORT_INTERFACE_ID NUMBER,
721 p_LAST_UPDATE_DATE DATE,
722 p_LAST_UPDATED_BY NUMBER,
723 p_CREATION_DATE DATE,
724 p_CREATED_BY NUMBER,
725 p_LAST_UPDATE_LOGIN NUMBER,
726 p_REQUEST_ID NUMBER,
727 p_PROGRAM_APPLICATION_ID NUMBER,
728 p_PROGRAM_ID NUMBER,
729 p_PROGRAM_UPDATE_DATE DATE,
730 p_IMP_LIST_HEADER_NUMBER VARCHAR2,
731 p_LOAD_TYPE VARCHAR2,
732 p_LOAD_DATE DATE,
733 p_LOAD_STATUS VARCHAR2,
734 p_LOAD_ERROR_MESSAGE VARCHAR2,
735 p_PROMOTION_ID NUMBER,
736 p_PROMOTION_CODE VARCHAR2,
737 p_CUSTOMER_ID NUMBER,
738 p_CUSTOMER_NAME VARCHAR2,
739 p_CUSTOMER_NUMBER VARCHAR2,
740 p_CUSTOMER_STATUS VARCHAR2,
741 p_CUSTOMER_TYPE VARCHAR2,
742 p_CUSTOMER_PROSPECT_CODE VARCHAR2,
743 p_CUSTOMER_CLASS_CODE VARCHAR2,
744 p_SALES_CHANNEL_CODE VARCHAR2,
745 p_SIC_CODE VARCHAR2,
746 p_ANALYSIS_FY VARCHAR2,
747 p_CUSTOMER_CATEGORY_CODE VARCHAR2,
748 p_CUSTOMER_GROUP_CODE VARCHAR2,
749 p_CUSTOMER_KEY VARCHAR2,
750 p_CUSTOMER_SUBGROUP_CODE VARCHAR2,
751 p_FISCAL_YEAREND_MONTH VARCHAR2,
752 p_NET_WORTH NUMBER,
753 p_NUM_OF_EMPLOYEES NUMBER,
754 p_POTENTIAL_REVENUE_CURR_FY NUMBER,
758 p_TAX_CODE VARCHAR2,
755 p_POTENTIAL_REVENUE_NEXT_FY NUMBER,
756 p_CUSTOMER_RANK VARCHAR2,
757 p_REFERENCE_USE_FLAG VARCHAR2,
759 p_TAX_REFERENCE VARCHAR2,
760 p_THIRD_PARTY_FLAG VARCHAR2,
761 p_COMPETITOR_FLAG VARCHAR2,
762 p_YEAR_ESTABLISHED NUMBER,
763 p_ADDR_DO_NOT_MAIL_FLAG VARCHAR2,
764 p_URL VARCHAR2,
765 p_ADDRESS_ID NUMBER,
766 p_CONT_DO_NOT_MAIL_FLAG VARCHAR2,
767 p_ADDRESS_STATUS VARCHAR2,
768 p_COUNTRY VARCHAR2,
769 p_ADDRESS1 VARCHAR2,
770 p_ADDRESS2 VARCHAR2,
771 p_ADDRESS3 VARCHAR2,
772 p_ADDRESS4 VARCHAR2,
773 p_CITY VARCHAR2,
774 p_POSTAL_CODE VARCHAR2,
775 p_STATE VARCHAR2,
776 p_PROVINCE VARCHAR2,
777 p_COUNTY VARCHAR2,
778 p_SITE_CONTACT_ID NUMBER,
779 p_EMAIL_ADDRESS VARCHAR2,
780 p_SEX_CODE VARCHAR2,
781 p_SALUTATION VARCHAR2,
782 p_LAST_NAME VARCHAR2,
783 p_TITLE VARCHAR2,
784 p_FIRST_NAME VARCHAR2,
785 p_JOB_TITLE VARCHAR2,
786 p_PHONE_ID NUMBER,
787 p_PHONE_NUMBER VARCHAR2,
788 p_PHONE_STATUS VARCHAR2,
789 p_PHONE_TYPE VARCHAR2,
790 p_AREA_CODE VARCHAR2,
791 p_EXTENSION VARCHAR2,
792 p_LEAD_NUMBER VARCHAR2,
793 p_STATUS_CODE VARCHAR2,
794 p_SOURCE_PROMOTION_ID NUMBER,
795 p_INITIATING_CONTACT_ID NUMBER,
796 p_CONTACT_ROLE_CODE VARCHAR2,
797 p_CHANNEL_CODE VARCHAR2,
798 p_BUDGET_AMOUNT NUMBER,
799 p_BUDGET_STATUS_CODE VARCHAR2,
800 p_CURRENCY_CODE VARCHAR2,
801 p_DECISION_TIMEFRAME_CODE VARCHAR2,
802 p_CLOSE_REASON VARCHAR2,
803 p_LEAD_RANK_CODE VARCHAR2,
804 p_PARENT_PROJECT VARCHAR2,
805 p_DESCRIPTION VARCHAR2,
806 p_STATUS_CODE_1 VARCHAR2,
807 p_INTEREST_TYPE_ID_1 NUMBER,
808 p_PRIMARY_INTEREST_CODE_ID_1 NUMBER,
809 p_SECONDARY_INTEREST_CODE_ID_1 NUMBER,
810 p_INVENTORY_ITEM_ID_1 NUMBER,
811 p_ORGANIZATION_ID_1 NUMBER,
812 p_UOM_CODE_1 VARCHAR2,
813 p_QUANTITY_1 NUMBER,
814 p_BUDGET_AMOUNT_1 NUMBER,
815 p_STATUS_CODE_2 VARCHAR2,
816 p_INTEREST_TYPE_ID_2 NUMBER,
817 p_PRIMARY_INTEREST_CODE_ID_2 NUMBER,
818 p_SECONDARY_INTEREST_CODE_ID_2 NUMBER,
819 p_INVENTORY_ITEM_ID_2 NUMBER,
820 p_ORGANIZATION_ID_2 NUMBER,
821 p_UOM_CODE_2 VARCHAR2,
822 p_QUANTITY_2 NUMBER,
823 p_BUDGET_AMOUNT_2 NUMBER,
824 p_STATUS_CODE_3 VARCHAR2,
825 p_INTEREST_TYPE_ID_3 NUMBER,
826 p_PRIMARY_INTEREST_CODE_ID_3 NUMBER,
827 p_SECONDARY_INTEREST_CODE_ID_3 NUMBER,
828 p_INVENTORY_ITEM_ID_3 NUMBER,
829 p_ORGANIZATION_ID_3 NUMBER,
830 p_UOM_CODE_3 VARCHAR2,
831 p_QUANTITY_3 NUMBER,
832 p_BUDGET_AMOUNT_3 NUMBER,
833 p_STATUS_CODE_4 VARCHAR2,
834 p_INTEREST_TYPE_ID_4 NUMBER,
835 p_PRIMARY_INTEREST_CODE_ID_4 NUMBER,
836 p_SECONDARY_INTEREST_CODE_ID_4 NUMBER,
837 p_INVENTORY_ITEM_ID_4 NUMBER,
838 p_ORGANIZATION_ID_4 NUMBER,
839 p_UOM_CODE_4 VARCHAR2,
840 p_QUANTITY_4 NUMBER,
841 p_BUDGET_AMOUNT_4 NUMBER,
842 p_STATUS_CODE_5 VARCHAR2,
843 p_INTEREST_TYPE_ID_5 NUMBER,
844 p_PRIMARY_INTEREST_CODE_ID_5 NUMBER,
845 p_SECONDARY_INTEREST_CODE_ID_5 NUMBER,
846 p_INVENTORY_ITEM_ID_5 NUMBER,
847 p_ORGANIZATION_ID_5 NUMBER,
848 p_UOM_CODE_5 VARCHAR2,
849 p_QUANTITY_5 NUMBER,
850 p_BUDGET_AMOUNT_5 NUMBER,
851 p_INTERACTION_NOTES_1 VARCHAR2,
855 p_ACTIVITY_CODE_1 VARCHAR2,
852 p_PRIORITY_1 NUMBER,
853 p_TODO_DATE_1 DATE,
854 p_TODO_START_TIME_1 VARCHAR2,
856 p_INTERACTION_NOTES_2 VARCHAR2,
857 p_PRIORITY_2 NUMBER,
858 p_TODO_DATE_2 DATE,
859 p_TODO_START_TIME_2 VARCHAR2,
860 p_ACTIVITY_CODE_2 VARCHAR2,
861 p_INTERACTION_NOTES_3 VARCHAR2,
862 p_PRIORITY_3 NUMBER,
863 p_TODO_DATE_3 DATE,
864 p_TODO_START_TIME_3 VARCHAR2,
865 p_ACTIVITY_CODE_3 VARCHAR2,
866 p_INTERACTION_NOTES_4 VARCHAR2,
867 p_PRIORITY_4 NUMBER,
868 p_TODO_DATE_4 DATE,
869 p_TODO_START_TIME_4 VARCHAR2,
870 p_ACTIVITY_CODE_4 VARCHAR2,
871 p_INTERACTION_NOTES_5 VARCHAR2,
872 p_PRIORITY_5 NUMBER,
873 p_TODO_DATE_5 DATE,
874 p_TODO_START_TIME_5 VARCHAR2,
875 p_ACTIVITY_CODE_5 VARCHAR2,
876 p_INTERACTION_NOTES_6 VARCHAR2,
877 p_PRIORITY_6 NUMBER,
878 p_TODO_DATE_6 DATE,
879 p_TODO_START_TIME_6 VARCHAR2,
880 p_ACTIVITY_CODE_6 VARCHAR2,
881 p_INTERACTION_NOTES_7 VARCHAR2,
882 p_PRIORITY_7 NUMBER,
883 p_TODO_DATE_7 DATE,
884 p_TODO_START_TIME_7 VARCHAR2,
885 p_ACTIVITY_CODE_7 VARCHAR2,
886 p_INTERACTION_NOTES_8 VARCHAR2,
887 p_PRIORITY_8 NUMBER,
888 p_TODO_DATE_8 DATE,
889 p_TODO_START_TIME_8 VARCHAR2,
890 p_ACTIVITY_CODE_8 VARCHAR2,
891 p_INTERACTION_NOTES_9 VARCHAR2,
892 p_PRIORITY_9 NUMBER,
893 p_TODO_DATE_9 DATE,
894 p_TODO_START_TIME_9 VARCHAR2,
895 p_ACTIVITY_CODE_9 VARCHAR2,
896 p_INTERACTION_NOTES_10 VARCHAR2,
897 p_PRIORITY_10 NUMBER,
898 p_TODO_DATE_10 DATE,
899 p_TODO_START_TIME_10 VARCHAR2,
900 p_ACTIVITY_CODE_10 VARCHAR2,
901 p_LEAD_NOTE VARCHAR2,
902 p_MIDDLE_INITIAL VARCHAR2,
903 p_FAX_NUMBER VARCHAR2,
904 p_FAX_AREA_CODE VARCHAR2,
905 p_MAIL_STOP VARCHAR2,
906 p_NUM_ENROLLED NUMBER,
907 p_CONFIRMED_FLAG VARCHAR2,
908 p_PAYMENT_AMOUNT NUMBER,
909 p_NUM_ATTENDED NUMBER,
910 p_PROMOTION_NAME VARCHAR2,
911 p_STATUS_CHANGE_FLAG VARCHAR2,
912 p_VEHICLE_RESPONSE_CODE VARCHAR2,
913 p_SOURCE_SYSTEM VARCHAR2,
914 p_CONTACT_PARTY_ID NUMBER,
915 p_PRM_SALES_LEAD_TYPE VARCHAR2,
916 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
917 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
918 p_INC_PARTNER_PARTY_ID NUMBER,
919 p_INC_PARTNER_RESOURCE_ID NUMBER,
920 p_OFFER_ID NUMBER,
921 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
922 p_PARTY_TYPE VARCHAR2,
923 p_BATCH_ID NUMBER,
924 p_PARTY_ID NUMBER,
925 p_PARTY_SITE_ID NUMBER,
926 p_LOCATION_ID NUMBER,
927 p_REL_PARTY_ID NUMBER,
928 p_SALES_LEAD_ID NUMBER,
929 p_ADDRESS_KEY VARCHAR2,
930 p_CONTACT_KEY VARCHAR2,
931 p_JOB_TITLE_CODE VARCHAR2,
932 p_DO_NOT_PHONE_FLAG VARCHAR2,
933 p_DO_NOT_FAX_FLAG VARCHAR2,
934 p_DO_NOT_EMAIL_FLAG VARCHAR2,
935 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
936 p_LEAD_RANK_ID NUMBER,
937 p_NEW_PARTY_FLAG NUMBER,
938 p_NEW_LOC_FLAG NUMBER,
939 p_NEW_PS_FLAG NUMBER,
940 p_NEW_REL_FLAG NUMBER,
941 p_NEW_CON_FLAG NUMBER,
942 p_ORIG_SYSTEM_CODE VARCHAR2,
943 p_URGENT_FLAG VARCHAR2,
944 p_SIC_CODE_TYPE VARCHAR2,
945 p_SITE_USE_TYPE VARCHAR2,
946 p_PRIMARY_CONTACT_FLAG VARCHAR2,
947 p_RANK VARCHAR2,
948 p_ADDRESS_STYLE VARCHAR2,
949 p_PRIMARY_PER_TYPE VARCHAR2,
950 p_DEPARTMENT_CODE VARCHAR2);
951
952 PROCEDURE Delete_Row(
953 p_IMPORT_INTERFACE_ID NUMBER);
954 End AS_IMPORT_INTERFACE_PKG;