[Home] [Help]
PACKAGE: APPS.AMS_LIST_ENTRIES_PKG
Source
1 PACKAGE AMS_LIST_ENTRIES_PKG AUTHID CURRENT_USER AS
2 /* $Header: amstlies.pls 115.13 2003/04/25 22:44:37 vbhandar ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_LIST_ENTRIES_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 PROCEDURE Insert_Row(
17 px_list_entry_id IN OUT NOCOPY NUMBER,
18 p_list_header_id NUMBER,
19 p_last_update_date DATE,
20 p_last_updated_by NUMBER,
21 p_creation_date DATE,
22 p_created_by NUMBER,
23 p_last_update_login NUMBER,
24 px_object_version_number IN OUT NOCOPY NUMBER,
25 p_list_select_action_id NUMBER,
26 p_arc_list_select_action_from VARCHAR2,
27 p_list_select_action_from_name VARCHAR2,
28 p_source_code VARCHAR2,
29 p_arc_list_used_by_source VARCHAR2,
30 p_source_code_for_id NUMBER,
31 p_pin_code VARCHAR2,
32 p_list_entry_source_system_id NUMBER,
33 p_list_entry_source_system_tp VARCHAR2,
34 p_view_application_id NUMBER,
35 p_manually_entered_flag VARCHAR2,
36 p_marked_as_duplicate_flag VARCHAR2,
37 p_marked_as_random_flag VARCHAR2,
38 p_part_of_control_group_flag VARCHAR2,
39 p_exclude_in_triggered_list_fg VARCHAR2,
40 p_enabled_flag VARCHAR2,
41 p_cell_code VARCHAR2,
42 p_dedupe_key VARCHAR2,
43 p_randomly_generated_number NUMBER,
44 p_campaign_id NUMBER,
45 p_media_id NUMBER,
46 p_channel_id NUMBER,
47 p_channel_schedule_id NUMBER,
48 p_event_offer_id NUMBER,
49 p_customer_id NUMBER,
50 p_market_segment_id NUMBER,
51 p_vendor_id NUMBER,
52 p_transfer_flag VARCHAR2,
53 p_transfer_status VARCHAR2,
54 p_list_source VARCHAR2,
55 p_duplicate_master_entry_id NUMBER,
56 p_marked_flag VARCHAR2,
57 p_lead_id NUMBER,
58 p_letter_id NUMBER,
59 p_picking_header_id NUMBER,
60 p_batch_id NUMBER,
61 p_suffix VARCHAR2,
62 p_first_name VARCHAR2,
63 p_last_name VARCHAR2,
64 p_customer_name VARCHAR2,
65 p_title VARCHAR2,
66 p_address_line1 VARCHAR2,
67 p_address_line2 VARCHAR2,
68 p_city VARCHAR2,
69 p_state VARCHAR2,
70 p_zipcode VARCHAR2,
71 p_country VARCHAR2,
72 p_fax VARCHAR2,
73 p_phone VARCHAR2,
74 p_email_address VARCHAR2,
75 p_col1 VARCHAR2,
76 p_col2 VARCHAR2,
77 p_col3 VARCHAR2,
78 p_col4 VARCHAR2,
79 p_col5 VARCHAR2,
80 p_col6 VARCHAR2,
81 p_col7 VARCHAR2,
82 p_col8 VARCHAR2,
83 p_col9 VARCHAR2,
84 p_col10 VARCHAR2,
85 p_col11 VARCHAR2,
86 p_col12 VARCHAR2,
87 p_col13 VARCHAR2,
88 p_col14 VARCHAR2,
89 p_col15 VARCHAR2,
90 p_col16 VARCHAR2,
91 p_col17 VARCHAR2,
92 p_col18 VARCHAR2,
93 p_col19 VARCHAR2,
94 p_col20 VARCHAR2,
95 p_col21 VARCHAR2,
96 p_col22 VARCHAR2,
97 p_col23 VARCHAR2,
98 p_col24 VARCHAR2,
99 p_col25 VARCHAR2,
100 p_col26 VARCHAR2,
101 p_col27 VARCHAR2,
102 p_col28 VARCHAR2,
103 p_col29 VARCHAR2,
104 p_col30 VARCHAR2,
105 p_col31 VARCHAR2,
106 p_col32 VARCHAR2,
107 p_col33 VARCHAR2,
108 p_col34 VARCHAR2,
109 p_col35 VARCHAR2,
110 p_col36 VARCHAR2,
111 p_col37 VARCHAR2,
112 p_col38 VARCHAR2,
113 p_col39 VARCHAR2,
114 p_col40 VARCHAR2,
115 p_col41 VARCHAR2,
116 p_col42 VARCHAR2,
117 p_col43 VARCHAR2,
118 p_col44 VARCHAR2,
119 p_col45 VARCHAR2,
120 p_col46 VARCHAR2,
121 p_col47 VARCHAR2,
122 p_col48 VARCHAR2,
123 p_col49 VARCHAR2,
124 p_col50 VARCHAR2,
125 p_col51 VARCHAR2,
126 p_col52 VARCHAR2,
127 p_col53 VARCHAR2,
128 p_col54 VARCHAR2,
129 p_col55 VARCHAR2,
130 p_col56 VARCHAR2,
131 p_col57 VARCHAR2,
132 p_col58 VARCHAR2,
133 p_col59 VARCHAR2,
134 p_col60 VARCHAR2,
135 p_col61 VARCHAR2,
136 p_col62 VARCHAR2,
137 p_col63 VARCHAR2,
138 p_col64 VARCHAR2,
139 p_col65 VARCHAR2,
140 p_col66 VARCHAR2,
141 p_col67 VARCHAR2,
142 p_col68 VARCHAR2,
143 p_col69 VARCHAR2,
144 p_col70 VARCHAR2,
145 p_col71 VARCHAR2,
146 p_col72 VARCHAR2,
147 p_col73 VARCHAR2,
148 p_col74 VARCHAR2,
149 p_col75 VARCHAR2,
150 p_col76 VARCHAR2,
151 p_col77 VARCHAR2,
152 p_col78 VARCHAR2,
153 p_col79 VARCHAR2,
154 p_col80 VARCHAR2,
155 p_col81 VARCHAR2,
156 p_col82 VARCHAR2,
157 p_col83 VARCHAR2,
158 p_col84 VARCHAR2,
159 p_col85 VARCHAR2,
160 p_col86 VARCHAR2,
161 p_col87 VARCHAR2,
162 p_col88 VARCHAR2,
163 p_col89 VARCHAR2,
164 p_col90 VARCHAR2,
165 p_col91 VARCHAR2,
166 p_col92 VARCHAR2,
167 p_col93 VARCHAR2,
168 p_col94 VARCHAR2,
169 p_col95 VARCHAR2,
170 p_col96 VARCHAR2,
171 p_col97 VARCHAR2,
172 p_col98 VARCHAR2,
173 p_col99 VARCHAR2,
174 p_col100 VARCHAR2,
175 p_col101 VARCHAR2,
176 p_col102 VARCHAR2,
177 p_col103 VARCHAR2,
178 p_col104 VARCHAR2,
179 p_col105 VARCHAR2,
180 p_col106 VARCHAR2,
181 p_col107 VARCHAR2,
182 p_col108 VARCHAR2,
183 p_col109 VARCHAR2,
184 p_col110 VARCHAR2,
185 p_col111 VARCHAR2,
186 p_col112 VARCHAR2,
187 p_col113 VARCHAR2,
188 p_col114 VARCHAR2,
189 p_col115 VARCHAR2,
190 p_col116 VARCHAR2,
191 p_col117 VARCHAR2,
192 p_col118 VARCHAR2,
193 p_col119 VARCHAR2,
194 p_col120 VARCHAR2,
195 p_col121 VARCHAR2,
196 p_col122 VARCHAR2,
197 p_col123 VARCHAR2,
198 p_col124 VARCHAR2,
199 p_col125 VARCHAR2,
200 p_col126 VARCHAR2,
201 p_col127 VARCHAR2,
202 p_col128 VARCHAR2,
203 p_col129 VARCHAR2,
204 p_col130 VARCHAR2,
205 p_col131 VARCHAR2,
206 p_col132 VARCHAR2,
207 p_col133 VARCHAR2,
208 p_col134 VARCHAR2,
209 p_col135 VARCHAR2,
210 p_col136 VARCHAR2,
211 p_col137 VARCHAR2,
212 p_col138 VARCHAR2,
213 p_col139 VARCHAR2,
214 p_col140 VARCHAR2,
215 p_col141 VARCHAR2,
216 p_col142 VARCHAR2,
217 p_col143 VARCHAR2,
218 p_col144 VARCHAR2,
219 p_col145 VARCHAR2,
220 p_col146 VARCHAR2,
221 p_col147 VARCHAR2,
222 p_col148 VARCHAR2,
223 p_col149 VARCHAR2,
224 p_col150 VARCHAR2,
225 p_col151 VARCHAR2,
226 p_col152 VARCHAR2,
227 p_col153 VARCHAR2,
228 p_col154 VARCHAR2,
229 p_col155 VARCHAR2,
230 p_col156 VARCHAR2,
231 p_col157 VARCHAR2,
232 p_col158 VARCHAR2,
233 p_col159 VARCHAR2,
234 p_col160 VARCHAR2,
235 p_col161 VARCHAR2,
236 p_col162 VARCHAR2,
237 p_col163 VARCHAR2,
238 p_col164 VARCHAR2,
239 p_col165 VARCHAR2,
240 p_col166 VARCHAR2,
241 p_col167 VARCHAR2,
242 p_col168 VARCHAR2,
243 p_col169 VARCHAR2,
244 p_col170 VARCHAR2,
245 p_col171 VARCHAR2,
246 p_col172 VARCHAR2,
247 p_col173 VARCHAR2,
248 p_col174 VARCHAR2,
249 p_col175 VARCHAR2,
250 p_col176 VARCHAR2,
251 p_col177 VARCHAR2,
252 p_col178 VARCHAR2,
253 p_col179 VARCHAR2,
254 p_col180 VARCHAR2,
255 p_col181 VARCHAR2,
256 p_col182 VARCHAR2,
257 p_col183 VARCHAR2,
258 p_col184 VARCHAR2,
259 p_col185 VARCHAR2,
260 p_col186 VARCHAR2,
261 p_col187 VARCHAR2,
262 p_col188 VARCHAR2,
263 p_col189 VARCHAR2,
264 p_col190 VARCHAR2,
265 p_col191 VARCHAR2,
266 p_col192 VARCHAR2,
267 p_col193 VARCHAR2,
268 p_col194 VARCHAR2,
269 p_col195 VARCHAR2,
270 p_col196 VARCHAR2,
271 p_col197 VARCHAR2,
272 p_col198 VARCHAR2,
273 p_col199 VARCHAR2,
274 p_col200 VARCHAR2,
275 p_col201 VARCHAR2,
276 p_col202 VARCHAR2,
277 p_col203 VARCHAR2,
278 p_col204 VARCHAR2,
279 p_col205 VARCHAR2,
280 p_col206 VARCHAR2,
281 p_col207 VARCHAR2,
282 p_col208 VARCHAR2,
283 p_col209 VARCHAR2,
284 p_col210 VARCHAR2,
285 p_col211 VARCHAR2,
286 p_col212 VARCHAR2,
287 p_col213 VARCHAR2,
288 p_col214 VARCHAR2,
289 p_col215 VARCHAR2,
290 p_col216 VARCHAR2,
291 p_col217 VARCHAR2,
292 p_col218 VARCHAR2,
293 p_col219 VARCHAR2,
294 p_col220 VARCHAR2,
295 p_col221 VARCHAR2,
296 p_col222 VARCHAR2,
297 p_col223 VARCHAR2,
298 p_col224 VARCHAR2,
299 p_col225 VARCHAR2,
300 p_col226 VARCHAR2,
301 p_col227 VARCHAR2,
302 p_col228 VARCHAR2,
303 p_col229 VARCHAR2,
304 p_col230 VARCHAR2,
305 p_col231 VARCHAR2,
306 p_col232 VARCHAR2,
307 p_col233 VARCHAR2,
308 p_col234 VARCHAR2,
309 p_col235 VARCHAR2,
310 p_col236 VARCHAR2,
311 p_col237 VARCHAR2,
312 p_col238 VARCHAR2,
313 p_col239 VARCHAR2,
314 p_col240 VARCHAR2,
315 p_col241 VARCHAR2,
316 p_col242 VARCHAR2,
317 p_col243 VARCHAR2,
318 p_col244 VARCHAR2,
319 p_col245 VARCHAR2,
320 p_col246 VARCHAR2,
321 p_col247 VARCHAR2,
322 p_col248 VARCHAR2,
323 p_col249 VARCHAR2,
324 p_col250 VARCHAR2,
325 p_col251 VARCHAR2,
326 p_col252 VARCHAR2,
327 p_col253 VARCHAR2,
328 p_col254 VARCHAR2,
329 p_col255 VARCHAR2,
330 p_col256 VARCHAR2,
331 p_col257 VARCHAR2,
332 p_col258 VARCHAR2,
333 p_col259 VARCHAR2,
334 p_col260 VARCHAR2,
335 p_col261 VARCHAR2,
336 p_col262 VARCHAR2,
337 p_col263 VARCHAR2,
338 p_col264 VARCHAR2,
339 p_col265 VARCHAR2,
340 p_col266 VARCHAR2,
341 p_col267 VARCHAR2,
342 p_col268 VARCHAR2,
343 p_col269 VARCHAR2,
344 p_col270 VARCHAR2,
345 p_col271 VARCHAR2,
346 p_col272 VARCHAR2,
347 p_col273 VARCHAR2,
348 p_col274 VARCHAR2,
349 p_col275 VARCHAR2,
350 p_col276 VARCHAR2,
351 p_col277 VARCHAR2,
352 p_col278 VARCHAR2,
353 p_col279 VARCHAR2,
354 p_col280 VARCHAR2,
355 p_col281 VARCHAR2,
356 p_col282 VARCHAR2,
357 p_col283 VARCHAR2,
358 p_col284 VARCHAR2,
359 p_col285 VARCHAR2,
360 p_col286 VARCHAR2,
361 p_col287 VARCHAR2,
362 p_col288 VARCHAR2,
363 p_col289 VARCHAR2,
364 p_col290 VARCHAR2,
365 p_col291 VARCHAR2,
366 p_col292 VARCHAR2,
367 p_col293 VARCHAR2,
368 p_col294 VARCHAR2,
369 p_col295 VARCHAR2,
373 p_col299 VARCHAR2,
370 p_col296 VARCHAR2,
371 p_col297 VARCHAR2,
372 p_col298 VARCHAR2,
374 p_col300 VARCHAR2,
375 p_party_id NUMBER,
376 p_parent_party_id NUMBER,
377 -- p_geometry SDO_GEOMETRY,
378 p_imp_source_line_id NUMBER,
379 p_usage_restriction VARCHAR2,
380 p_next_call_time DATE,
381 p_callback_flag VARCHAR2,
382 p_do_not_use_flag VARCHAR2,
383 p_do_not_use_reason VARCHAR2,
384 p_record_out_flag VARCHAR2,
385 p_record_release_time DATE,
386 p_group_code VARCHAR2,
387 p_newly_updated_flag VARCHAR2,
388 p_outcome_id number,
389 p_result_id number,
390 p_reason_id number,
391 p_notes varchar2,
392 p_VEHICLE_RESPONSE_CODE varchar2,
393 p_SALES_AGENT_EMAIL_ADDRESS varchar2,
394 p_RESOURCE_ID number,
395 p_LOCATION_ID NUMBER,
396 p_CONTACT_POINT_ID NUMBER,
397 p_last_contacted_date DATE
398
399 );
400
401 PROCEDURE Update_Row(
402 p_list_entry_id NUMBER,
403 p_list_header_id NUMBER,
404 p_last_update_date DATE,
405 p_last_updated_by NUMBER,
406 p_creation_date DATE,
407 p_created_by NUMBER,
408 p_last_update_login NUMBER,
409 p_object_version_number NUMBER,
410 p_list_select_action_id NUMBER,
411 p_arc_list_select_action_from VARCHAR2,
412 p_list_select_action_from_name VARCHAR2,
413 p_source_code VARCHAR2,
414 p_arc_list_used_by_source VARCHAR2,
415 p_source_code_for_id NUMBER,
416 p_pin_code VARCHAR2,
417 p_list_entry_source_system_id NUMBER,
418 p_list_entry_source_system_tp VARCHAR2,
419 p_view_application_id NUMBER,
420 p_manually_entered_flag VARCHAR2,
421 p_marked_as_duplicate_flag VARCHAR2,
422 p_marked_as_random_flag VARCHAR2,
423 p_part_of_control_group_flag VARCHAR2,
424 p_exclude_in_triggered_list_fg VARCHAR2,
425 p_enabled_flag VARCHAR2,
426 p_cell_code VARCHAR2,
427 p_dedupe_key VARCHAR2,
428 p_randomly_generated_number NUMBER,
429 p_campaign_id NUMBER,
430 p_media_id NUMBER,
431 p_channel_id NUMBER,
432 p_channel_schedule_id NUMBER,
433 p_event_offer_id NUMBER,
434 p_customer_id NUMBER,
435 p_market_segment_id NUMBER,
436 p_vendor_id NUMBER,
437 p_transfer_flag VARCHAR2,
438 p_transfer_status VARCHAR2,
439 p_list_source VARCHAR2,
440 p_duplicate_master_entry_id NUMBER,
441 p_marked_flag VARCHAR2,
442 p_lead_id NUMBER,
443 p_letter_id NUMBER,
444 p_picking_header_id NUMBER,
445 p_batch_id NUMBER,
446 p_suffix VARCHAR2,
447 p_first_name VARCHAR2,
448 p_last_name VARCHAR2,
449 p_customer_name VARCHAR2,
450 p_title VARCHAR2,
451 p_address_line1 VARCHAR2,
452 p_address_line2 VARCHAR2,
453 p_city VARCHAR2,
454 p_state VARCHAR2,
455 p_zipcode VARCHAR2,
456 p_country VARCHAR2,
457 p_fax VARCHAR2,
458 p_phone VARCHAR2,
459 p_email_address VARCHAR2,
460 p_col1 VARCHAR2,
461 p_col2 VARCHAR2,
462 p_col3 VARCHAR2,
463 p_col4 VARCHAR2,
464 p_col5 VARCHAR2,
465 p_col6 VARCHAR2,
466 p_col7 VARCHAR2,
467 p_col8 VARCHAR2,
468 p_col9 VARCHAR2,
469 p_col10 VARCHAR2,
470 p_col11 VARCHAR2,
471 p_col12 VARCHAR2,
472 p_col13 VARCHAR2,
473 p_col14 VARCHAR2,
474 p_col15 VARCHAR2,
475 p_col16 VARCHAR2,
476 p_col17 VARCHAR2,
477 p_col18 VARCHAR2,
478 p_col19 VARCHAR2,
479 p_col20 VARCHAR2,
480 p_col21 VARCHAR2,
481 p_col22 VARCHAR2,
482 p_col23 VARCHAR2,
483 p_col24 VARCHAR2,
484 p_col25 VARCHAR2,
485 p_col26 VARCHAR2,
486 p_col27 VARCHAR2,
487 p_col28 VARCHAR2,
488 p_col29 VARCHAR2,
489 p_col30 VARCHAR2,
490 p_col31 VARCHAR2,
491 p_col32 VARCHAR2,
492 p_col33 VARCHAR2,
493 p_col34 VARCHAR2,
494 p_col35 VARCHAR2,
495 p_col36 VARCHAR2,
496 p_col37 VARCHAR2,
497 p_col38 VARCHAR2,
498 p_col39 VARCHAR2,
499 p_col40 VARCHAR2,
500 p_col41 VARCHAR2,
501 p_col42 VARCHAR2,
502 p_col43 VARCHAR2,
503 p_col44 VARCHAR2,
504 p_col45 VARCHAR2,
508 p_col49 VARCHAR2,
505 p_col46 VARCHAR2,
506 p_col47 VARCHAR2,
507 p_col48 VARCHAR2,
509 p_col50 VARCHAR2,
510 p_col51 VARCHAR2,
511 p_col52 VARCHAR2,
512 p_col53 VARCHAR2,
513 p_col54 VARCHAR2,
514 p_col55 VARCHAR2,
515 p_col56 VARCHAR2,
516 p_col57 VARCHAR2,
517 p_col58 VARCHAR2,
518 p_col59 VARCHAR2,
519 p_col60 VARCHAR2,
520 p_col61 VARCHAR2,
521 p_col62 VARCHAR2,
522 p_col63 VARCHAR2,
523 p_col64 VARCHAR2,
524 p_col65 VARCHAR2,
525 p_col66 VARCHAR2,
526 p_col67 VARCHAR2,
527 p_col68 VARCHAR2,
528 p_col69 VARCHAR2,
529 p_col70 VARCHAR2,
530 p_col71 VARCHAR2,
531 p_col72 VARCHAR2,
532 p_col73 VARCHAR2,
533 p_col74 VARCHAR2,
534 p_col75 VARCHAR2,
535 p_col76 VARCHAR2,
536 p_col77 VARCHAR2,
537 p_col78 VARCHAR2,
538 p_col79 VARCHAR2,
539 p_col80 VARCHAR2,
540 p_col81 VARCHAR2,
541 p_col82 VARCHAR2,
542 p_col83 VARCHAR2,
543 p_col84 VARCHAR2,
544 p_col85 VARCHAR2,
545 p_col86 VARCHAR2,
546 p_col87 VARCHAR2,
547 p_col88 VARCHAR2,
548 p_col89 VARCHAR2,
549 p_col90 VARCHAR2,
550 p_col91 VARCHAR2,
551 p_col92 VARCHAR2,
552 p_col93 VARCHAR2,
553 p_col94 VARCHAR2,
554 p_col95 VARCHAR2,
555 p_col96 VARCHAR2,
556 p_col97 VARCHAR2,
557 p_col98 VARCHAR2,
558 p_col99 VARCHAR2,
559 p_col100 VARCHAR2,
560 p_col101 VARCHAR2,
561 p_col102 VARCHAR2,
562 p_col103 VARCHAR2,
563 p_col104 VARCHAR2,
564 p_col105 VARCHAR2,
565 p_col106 VARCHAR2,
566 p_col107 VARCHAR2,
567 p_col108 VARCHAR2,
568 p_col109 VARCHAR2,
569 p_col110 VARCHAR2,
570 p_col111 VARCHAR2,
571 p_col112 VARCHAR2,
572 p_col113 VARCHAR2,
573 p_col114 VARCHAR2,
574 p_col115 VARCHAR2,
575 p_col116 VARCHAR2,
576 p_col117 VARCHAR2,
577 p_col118 VARCHAR2,
578 p_col119 VARCHAR2,
579 p_col120 VARCHAR2,
580 p_col121 VARCHAR2,
581 p_col122 VARCHAR2,
582 p_col123 VARCHAR2,
583 p_col124 VARCHAR2,
584 p_col125 VARCHAR2,
585 p_col126 VARCHAR2,
586 p_col127 VARCHAR2,
587 p_col128 VARCHAR2,
588 p_col129 VARCHAR2,
589 p_col130 VARCHAR2,
590 p_col131 VARCHAR2,
591 p_col132 VARCHAR2,
592 p_col133 VARCHAR2,
593 p_col134 VARCHAR2,
594 p_col135 VARCHAR2,
595 p_col136 VARCHAR2,
596 p_col137 VARCHAR2,
597 p_col138 VARCHAR2,
598 p_col139 VARCHAR2,
599 p_col140 VARCHAR2,
600 p_col141 VARCHAR2,
601 p_col142 VARCHAR2,
602 p_col143 VARCHAR2,
603 p_col144 VARCHAR2,
604 p_col145 VARCHAR2,
605 p_col146 VARCHAR2,
606 p_col147 VARCHAR2,
607 p_col148 VARCHAR2,
608 p_col149 VARCHAR2,
609 p_col150 VARCHAR2,
610 p_col151 VARCHAR2,
611 p_col152 VARCHAR2,
612 p_col153 VARCHAR2,
613 p_col154 VARCHAR2,
614 p_col155 VARCHAR2,
615 p_col156 VARCHAR2,
616 p_col157 VARCHAR2,
617 p_col158 VARCHAR2,
618 p_col159 VARCHAR2,
619 p_col160 VARCHAR2,
620 p_col161 VARCHAR2,
621 p_col162 VARCHAR2,
622 p_col163 VARCHAR2,
623 p_col164 VARCHAR2,
624 p_col165 VARCHAR2,
625 p_col166 VARCHAR2,
626 p_col167 VARCHAR2,
627 p_col168 VARCHAR2,
628 p_col169 VARCHAR2,
629 p_col170 VARCHAR2,
630 p_col171 VARCHAR2,
631 p_col172 VARCHAR2,
632 p_col173 VARCHAR2,
633 p_col174 VARCHAR2,
634 p_col175 VARCHAR2,
635 p_col176 VARCHAR2,
636 p_col177 VARCHAR2,
637 p_col178 VARCHAR2,
638 p_col179 VARCHAR2,
639 p_col180 VARCHAR2,
640 p_col181 VARCHAR2,
641 p_col182 VARCHAR2,
642 p_col183 VARCHAR2,
643 p_col184 VARCHAR2,
644 p_col185 VARCHAR2,
645 p_col186 VARCHAR2,
646 p_col187 VARCHAR2,
647 p_col188 VARCHAR2,
648 p_col189 VARCHAR2,
652 p_col193 VARCHAR2,
649 p_col190 VARCHAR2,
650 p_col191 VARCHAR2,
651 p_col192 VARCHAR2,
653 p_col194 VARCHAR2,
654 p_col195 VARCHAR2,
655 p_col196 VARCHAR2,
656 p_col197 VARCHAR2,
657 p_col198 VARCHAR2,
658 p_col199 VARCHAR2,
659 p_col200 VARCHAR2,
660 p_col201 VARCHAR2,
661 p_col202 VARCHAR2,
662 p_col203 VARCHAR2,
663 p_col204 VARCHAR2,
664 p_col205 VARCHAR2,
665 p_col206 VARCHAR2,
666 p_col207 VARCHAR2,
667 p_col208 VARCHAR2,
668 p_col209 VARCHAR2,
669 p_col210 VARCHAR2,
670 p_col211 VARCHAR2,
671 p_col212 VARCHAR2,
672 p_col213 VARCHAR2,
673 p_col214 VARCHAR2,
674 p_col215 VARCHAR2,
675 p_col216 VARCHAR2,
676 p_col217 VARCHAR2,
677 p_col218 VARCHAR2,
678 p_col219 VARCHAR2,
679 p_col220 VARCHAR2,
680 p_col221 VARCHAR2,
681 p_col222 VARCHAR2,
682 p_col223 VARCHAR2,
683 p_col224 VARCHAR2,
684 p_col225 VARCHAR2,
685 p_col226 VARCHAR2,
686 p_col227 VARCHAR2,
687 p_col228 VARCHAR2,
688 p_col229 VARCHAR2,
689 p_col230 VARCHAR2,
690 p_col231 VARCHAR2,
691 p_col232 VARCHAR2,
692 p_col233 VARCHAR2,
693 p_col234 VARCHAR2,
694 p_col235 VARCHAR2,
695 p_col236 VARCHAR2,
696 p_col237 VARCHAR2,
697 p_col238 VARCHAR2,
698 p_col239 VARCHAR2,
699 p_col240 VARCHAR2,
700 p_col241 VARCHAR2,
701 p_col242 VARCHAR2,
702 p_col243 VARCHAR2,
703 p_col244 VARCHAR2,
704 p_col245 VARCHAR2,
705 p_col246 VARCHAR2,
706 p_col247 VARCHAR2,
707 p_col248 VARCHAR2,
708 p_col249 VARCHAR2,
709 p_col250 VARCHAR2,
710 p_col251 VARCHAR2,
711 p_col252 VARCHAR2,
712 p_col253 VARCHAR2,
713 p_col254 VARCHAR2,
714 p_col255 VARCHAR2,
715 p_col256 VARCHAR2,
716 p_col257 VARCHAR2,
717 p_col258 VARCHAR2,
718 p_col259 VARCHAR2,
719 p_col260 VARCHAR2,
720 p_col261 VARCHAR2,
721 p_col262 VARCHAR2,
722 p_col263 VARCHAR2,
723 p_col264 VARCHAR2,
724 p_col265 VARCHAR2,
725 p_col266 VARCHAR2,
726 p_col267 VARCHAR2,
727 p_col268 VARCHAR2,
728 p_col269 VARCHAR2,
729 p_col270 VARCHAR2,
730 p_col271 VARCHAR2,
731 p_col272 VARCHAR2,
732 p_col273 VARCHAR2,
733 p_col274 VARCHAR2,
734 p_col275 VARCHAR2,
735 p_col276 VARCHAR2,
736 p_col277 VARCHAR2,
737 p_col278 VARCHAR2,
738 p_col279 VARCHAR2,
739 p_col280 VARCHAR2,
740 p_col281 VARCHAR2,
741 p_col282 VARCHAR2,
742 p_col283 VARCHAR2,
743 p_col284 VARCHAR2,
744 p_col285 VARCHAR2,
745 p_col286 VARCHAR2,
746 p_col287 VARCHAR2,
747 p_col288 VARCHAR2,
748 p_col289 VARCHAR2,
749 p_col290 VARCHAR2,
750 p_col291 VARCHAR2,
751 p_col292 VARCHAR2,
752 p_col293 VARCHAR2,
753 p_col294 VARCHAR2,
754 p_col295 VARCHAR2,
755 p_col296 VARCHAR2,
756 p_col297 VARCHAR2,
757 p_col298 VARCHAR2,
758 p_col299 VARCHAR2,
759 p_col300 VARCHAR2,
760 p_party_id NUMBER,
761 p_parent_party_id NUMBER,
762 --p_geometry SDO_GEOMETRY,
763 p_imp_source_line_id NUMBER,
764 p_usage_restriction VARCHAR2,
765 p_next_call_time DATE,
766 p_callback_flag VARCHAR2,
767 p_do_not_use_flag VARCHAR2,
768 p_do_not_use_reason VARCHAR2,
769 p_record_out_flag VARCHAR2,
770 p_record_release_time DATE,
771 p_group_code VARCHAR2,
772 p_newly_updated_flag VARCHAR2,
773 p_outcome_id number,
774 p_result_id number,
775 p_reason_id number,
776 p_notes varchar2,
777 p_VEHICLE_RESPONSE_CODE varchar2,
778 p_SALES_AGENT_EMAIL_ADDRESS varchar2,
779 p_RESOURCE_ID number,
780 p_LOCATION_ID NUMBER,
781 p_CONTACT_POINT_ID NUMBER,
782 p_last_contacted_date DATE
783 );
784
785 PROCEDURE Delete_Row(
786 p_LIST_ENTRY_ID NUMBER);
787 PROCEDURE Lock_Row(
788 p_list_entry_id NUMBER,
789 p_list_header_id NUMBER,
790 p_last_update_date DATE,
794 p_last_update_login NUMBER,
791 p_last_updated_by NUMBER,
792 p_creation_date DATE,
793 p_created_by NUMBER,
795 p_object_version_number NUMBER,
796 p_list_select_action_id NUMBER,
797 p_arc_list_select_action_from VARCHAR2,
798 p_list_select_action_from_name VARCHAR2,
799 p_source_code VARCHAR2,
800 p_arc_list_used_by_source VARCHAR2,
801 p_source_code_for_id NUMBER,
802 p_pin_code VARCHAR2,
803 p_list_entry_source_system_id NUMBER,
804 p_list_entry_source_system_tp VARCHAR2,
805 p_view_application_id NUMBER,
806 p_manually_entered_flag VARCHAR2,
807 p_marked_as_duplicate_flag VARCHAR2,
808 p_marked_as_random_flag VARCHAR2,
809 p_part_of_control_group_flag VARCHAR2,
810 p_exclude_in_triggered_list_fg VARCHAR2,
811 p_enabled_flag VARCHAR2,
812 p_cell_code VARCHAR2,
813 p_dedupe_key VARCHAR2,
814 p_randomly_generated_number NUMBER,
815 p_campaign_id NUMBER,
816 p_media_id NUMBER,
817 p_channel_id NUMBER,
818 p_channel_schedule_id NUMBER,
819 p_event_offer_id NUMBER,
820 p_customer_id NUMBER,
821 p_market_segment_id NUMBER,
822 p_vendor_id NUMBER,
823 p_transfer_flag VARCHAR2,
824 p_transfer_status VARCHAR2,
825 p_list_source VARCHAR2,
826 p_duplicate_master_entry_id NUMBER,
827 p_marked_flag VARCHAR2,
828 p_lead_id NUMBER,
829 p_letter_id NUMBER,
830 p_picking_header_id NUMBER,
831 p_batch_id NUMBER,
832 p_suffix VARCHAR2,
833 p_first_name VARCHAR2,
834 p_last_name VARCHAR2,
835 p_customer_name VARCHAR2,
836 p_title VARCHAR2,
837 p_address_line1 VARCHAR2,
838 p_address_line2 VARCHAR2,
839 p_city VARCHAR2,
840 p_state VARCHAR2,
841 p_zipcode VARCHAR2,
842 p_country VARCHAR2,
843 p_fax VARCHAR2,
844 p_phone VARCHAR2,
845 p_email_address VARCHAR2,
846 p_col1 VARCHAR2,
847 p_col2 VARCHAR2,
848 p_col3 VARCHAR2,
849 p_col4 VARCHAR2,
850 p_col5 VARCHAR2,
851 p_col6 VARCHAR2,
852 p_col7 VARCHAR2,
853 p_col8 VARCHAR2,
854 p_col9 VARCHAR2,
855 p_col10 VARCHAR2,
856 p_col11 VARCHAR2,
857 p_col12 VARCHAR2,
858 p_col13 VARCHAR2,
859 p_col14 VARCHAR2,
860 p_col15 VARCHAR2,
861 p_col16 VARCHAR2,
862 p_col17 VARCHAR2,
863 p_col18 VARCHAR2,
864 p_col19 VARCHAR2,
865 p_col20 VARCHAR2,
866 p_col21 VARCHAR2,
867 p_col22 VARCHAR2,
868 p_col23 VARCHAR2,
869 p_col24 VARCHAR2,
870 p_col25 VARCHAR2,
871 p_col26 VARCHAR2,
872 p_col27 VARCHAR2,
873 p_col28 VARCHAR2,
874 p_col29 VARCHAR2,
875 p_col30 VARCHAR2,
876 p_col31 VARCHAR2,
877 p_col32 VARCHAR2,
878 p_col33 VARCHAR2,
879 p_col34 VARCHAR2,
880 p_col35 VARCHAR2,
881 p_col36 VARCHAR2,
882 p_col37 VARCHAR2,
883 p_col38 VARCHAR2,
884 p_col39 VARCHAR2,
885 p_col40 VARCHAR2,
886 p_col41 VARCHAR2,
887 p_col42 VARCHAR2,
888 p_col43 VARCHAR2,
889 p_col44 VARCHAR2,
890 p_col45 VARCHAR2,
891 p_col46 VARCHAR2,
892 p_col47 VARCHAR2,
893 p_col48 VARCHAR2,
894 p_col49 VARCHAR2,
895 p_col50 VARCHAR2,
896 p_col51 VARCHAR2,
897 p_col52 VARCHAR2,
898 p_col53 VARCHAR2,
899 p_col54 VARCHAR2,
900 p_col55 VARCHAR2,
901 p_col56 VARCHAR2,
902 p_col57 VARCHAR2,
903 p_col58 VARCHAR2,
904 p_col59 VARCHAR2,
905 p_col60 VARCHAR2,
906 p_col61 VARCHAR2,
907 p_col62 VARCHAR2,
908 p_col63 VARCHAR2,
909 p_col64 VARCHAR2,
910 p_col65 VARCHAR2,
911 p_col66 VARCHAR2,
912 p_col67 VARCHAR2,
913 p_col68 VARCHAR2,
914 p_col69 VARCHAR2,
915 p_col70 VARCHAR2,
916 p_col71 VARCHAR2,
917 p_col72 VARCHAR2,
918 p_col73 VARCHAR2,
919 p_col74 VARCHAR2,
920 p_col75 VARCHAR2,
921 p_col76 VARCHAR2,
922 p_col77 VARCHAR2,
923 p_col78 VARCHAR2,
924 p_col79 VARCHAR2,
925 p_col80 VARCHAR2,
929 p_col84 VARCHAR2,
926 p_col81 VARCHAR2,
927 p_col82 VARCHAR2,
928 p_col83 VARCHAR2,
930 p_col85 VARCHAR2,
931 p_col86 VARCHAR2,
932 p_col87 VARCHAR2,
933 p_col88 VARCHAR2,
934 p_col89 VARCHAR2,
935 p_col90 VARCHAR2,
936 p_col91 VARCHAR2,
937 p_col92 VARCHAR2,
938 p_col93 VARCHAR2,
939 p_col94 VARCHAR2,
940 p_col95 VARCHAR2,
941 p_col96 VARCHAR2,
942 p_col97 VARCHAR2,
943 p_col98 VARCHAR2,
944 p_col99 VARCHAR2,
945 p_col100 VARCHAR2,
946 p_col101 VARCHAR2,
947 p_col102 VARCHAR2,
948 p_col103 VARCHAR2,
949 p_col104 VARCHAR2,
950 p_col105 VARCHAR2,
951 p_col106 VARCHAR2,
952 p_col107 VARCHAR2,
953 p_col108 VARCHAR2,
954 p_col109 VARCHAR2,
955 p_col110 VARCHAR2,
956 p_col111 VARCHAR2,
957 p_col112 VARCHAR2,
958 p_col113 VARCHAR2,
959 p_col114 VARCHAR2,
960 p_col115 VARCHAR2,
961 p_col116 VARCHAR2,
962 p_col117 VARCHAR2,
963 p_col118 VARCHAR2,
964 p_col119 VARCHAR2,
965 p_col120 VARCHAR2,
966 p_col121 VARCHAR2,
967 p_col122 VARCHAR2,
968 p_col123 VARCHAR2,
969 p_col124 VARCHAR2,
970 p_col125 VARCHAR2,
971 p_col126 VARCHAR2,
972 p_col127 VARCHAR2,
973 p_col128 VARCHAR2,
974 p_col129 VARCHAR2,
975 p_col130 VARCHAR2,
976 p_col131 VARCHAR2,
977 p_col132 VARCHAR2,
978 p_col133 VARCHAR2,
979 p_col134 VARCHAR2,
980 p_col135 VARCHAR2,
981 p_col136 VARCHAR2,
982 p_col137 VARCHAR2,
983 p_col138 VARCHAR2,
984 p_col139 VARCHAR2,
985 p_col140 VARCHAR2,
986 p_col141 VARCHAR2,
987 p_col142 VARCHAR2,
988 p_col143 VARCHAR2,
989 p_col144 VARCHAR2,
990 p_col145 VARCHAR2,
991 p_col146 VARCHAR2,
992 p_col147 VARCHAR2,
993 p_col148 VARCHAR2,
994 p_col149 VARCHAR2,
995 p_col150 VARCHAR2,
996 p_col151 VARCHAR2,
997 p_col152 VARCHAR2,
998 p_col153 VARCHAR2,
999 p_col154 VARCHAR2,
1000 p_col155 VARCHAR2,
1001 p_col156 VARCHAR2,
1002 p_col157 VARCHAR2,
1003 p_col158 VARCHAR2,
1004 p_col159 VARCHAR2,
1005 p_col160 VARCHAR2,
1006 p_col161 VARCHAR2,
1007 p_col162 VARCHAR2,
1008 p_col163 VARCHAR2,
1009 p_col164 VARCHAR2,
1010 p_col165 VARCHAR2,
1011 p_col166 VARCHAR2,
1012 p_col167 VARCHAR2,
1013 p_col168 VARCHAR2,
1014 p_col169 VARCHAR2,
1015 p_col170 VARCHAR2,
1016 p_col171 VARCHAR2,
1017 p_col172 VARCHAR2,
1018 p_col173 VARCHAR2,
1019 p_col174 VARCHAR2,
1020 p_col175 VARCHAR2,
1021 p_col176 VARCHAR2,
1022 p_col177 VARCHAR2,
1023 p_col178 VARCHAR2,
1024 p_col179 VARCHAR2,
1025 p_col180 VARCHAR2,
1026 p_col181 VARCHAR2,
1027 p_col182 VARCHAR2,
1028 p_col183 VARCHAR2,
1029 p_col184 VARCHAR2,
1030 p_col185 VARCHAR2,
1031 p_col186 VARCHAR2,
1032 p_col187 VARCHAR2,
1033 p_col188 VARCHAR2,
1034 p_col189 VARCHAR2,
1035 p_col190 VARCHAR2,
1036 p_col191 VARCHAR2,
1037 p_col192 VARCHAR2,
1038 p_col193 VARCHAR2,
1039 p_col194 VARCHAR2,
1040 p_col195 VARCHAR2,
1041 p_col196 VARCHAR2,
1042 p_col197 VARCHAR2,
1043 p_col198 VARCHAR2,
1044 p_col199 VARCHAR2,
1045 p_col200 VARCHAR2,
1046 p_col201 VARCHAR2,
1047 p_col202 VARCHAR2,
1048 p_col203 VARCHAR2,
1049 p_col204 VARCHAR2,
1050 p_col205 VARCHAR2,
1051 p_col206 VARCHAR2,
1052 p_col207 VARCHAR2,
1053 p_col208 VARCHAR2,
1054 p_col209 VARCHAR2,
1055 p_col210 VARCHAR2,
1056 p_col211 VARCHAR2,
1057 p_col212 VARCHAR2,
1058 p_col213 VARCHAR2,
1059 p_col214 VARCHAR2,
1060 p_col215 VARCHAR2,
1061 p_col216 VARCHAR2,
1062 p_col217 VARCHAR2,
1063 p_col218 VARCHAR2,
1064 p_col219 VARCHAR2,
1065 p_col220 VARCHAR2,
1066 p_col221 VARCHAR2,
1070 p_col225 VARCHAR2,
1067 p_col222 VARCHAR2,
1068 p_col223 VARCHAR2,
1069 p_col224 VARCHAR2,
1071 p_col226 VARCHAR2,
1072 p_col227 VARCHAR2,
1073 p_col228 VARCHAR2,
1074 p_col229 VARCHAR2,
1075 p_col230 VARCHAR2,
1076 p_col231 VARCHAR2,
1077 p_col232 VARCHAR2,
1078 p_col233 VARCHAR2,
1079 p_col234 VARCHAR2,
1080 p_col235 VARCHAR2,
1081 p_col236 VARCHAR2,
1082 p_col237 VARCHAR2,
1083 p_col238 VARCHAR2,
1084 p_col239 VARCHAR2,
1085 p_col240 VARCHAR2,
1086 p_col241 VARCHAR2,
1087 p_col242 VARCHAR2,
1088 p_col243 VARCHAR2,
1089 p_col244 VARCHAR2,
1090 p_col245 VARCHAR2,
1091 p_col246 VARCHAR2,
1092 p_col247 VARCHAR2,
1093 p_col248 VARCHAR2,
1094 p_col249 VARCHAR2,
1095 p_col250 VARCHAR2,
1096 p_col251 VARCHAR2,
1097 p_col252 VARCHAR2,
1098 p_col253 VARCHAR2,
1099 p_col254 VARCHAR2,
1100 p_col255 VARCHAR2,
1101 p_col256 VARCHAR2,
1102 p_col257 VARCHAR2,
1103 p_col258 VARCHAR2,
1104 p_col259 VARCHAR2,
1105 p_col260 VARCHAR2,
1106 p_col261 VARCHAR2,
1107 p_col262 VARCHAR2,
1108 p_col263 VARCHAR2,
1109 p_col264 VARCHAR2,
1110 p_col265 VARCHAR2,
1111 p_col266 VARCHAR2,
1112 p_col267 VARCHAR2,
1113 p_col268 VARCHAR2,
1114 p_col269 VARCHAR2,
1115 p_col270 VARCHAR2,
1116 p_col271 VARCHAR2,
1117 p_col272 VARCHAR2,
1118 p_col273 VARCHAR2,
1119 p_col274 VARCHAR2,
1120 p_col275 VARCHAR2,
1121 p_col276 VARCHAR2,
1122 p_col277 VARCHAR2,
1123 p_col278 VARCHAR2,
1124 p_col279 VARCHAR2,
1125 p_col280 VARCHAR2,
1126 p_col281 VARCHAR2,
1127 p_col282 VARCHAR2,
1128 p_col283 VARCHAR2,
1129 p_col284 VARCHAR2,
1130 p_col285 VARCHAR2,
1131 p_col286 VARCHAR2,
1132 p_col287 VARCHAR2,
1133 p_col288 VARCHAR2,
1134 p_col289 VARCHAR2,
1135 p_col290 VARCHAR2,
1136 p_col291 VARCHAR2,
1137 p_col292 VARCHAR2,
1138 p_col293 VARCHAR2,
1139 p_col294 VARCHAR2,
1140 p_col295 VARCHAR2,
1141 p_col296 VARCHAR2,
1142 p_col297 VARCHAR2,
1143 p_col298 VARCHAR2,
1144 p_col299 VARCHAR2,
1145 p_col300 VARCHAR2,
1146 p_party_id NUMBER,
1147 p_parent_party_id NUMBER,
1148 --p_geometry SDO_GEOMETRY,
1149 p_imp_source_line_id NUMBER,
1150 p_usage_restriction VARCHAR2,
1151 p_next_call_time DATE,
1152 p_callback_flag VARCHAR2,
1153 p_do_not_use_flag VARCHAR2,
1154 p_do_not_use_reason VARCHAR2,
1155 p_record_out_flag VARCHAR2,
1156 p_record_release_time DATE,
1157 p_group_code VARCHAR2,
1158 p_newly_updated_flag VARCHAR2,
1159 p_outcome_id number,
1160 p_result_id number,
1161 p_reason_id number
1162 );
1163
1164 END AMS_LIST_ENTRIES_PKG;