[Home] [Help]
PACKAGE BODY: APPS.AMS_LIST_ENTRIES_PKG
Source
1 PACKAGE BODY AMS_LIST_ENTRIES_PKG as
2 /* $Header: amstlieb.pls 115.14 2003/04/25 22:44:46 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
17 G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_LIST_ENTRIES_PKG';
18 G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstlieb.pls';
19
20
21 ----------------------------------------------------------
22 ---- MEDIA ----
23 ----------------------------------------------------------
24
25 -- ========================================================
26 --
27 -- NAME
28 -- createInsertBody
29 --
30 -- PURPOSE
31 --
32 -- NOTES
33 --
34 -- HISTORY
35 --
36 -- ========================================================
37 AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
38 AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
39 AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
40
41 PROCEDURE Insert_Row(
42 px_list_entry_id IN OUT NOCOPY NUMBER,
43 p_list_header_id NUMBER,
44 p_last_update_date DATE,
45 p_last_updated_by NUMBER,
46 p_creation_date DATE,
47 p_created_by NUMBER,
48 p_last_update_login NUMBER,
49 px_object_version_number IN OUT NOCOPY NUMBER,
50 p_list_select_action_id NUMBER,
51 p_arc_list_select_action_from VARCHAR2,
52 p_list_select_action_from_name VARCHAR2,
53 p_source_code VARCHAR2,
54 p_arc_list_used_by_source VARCHAR2,
55 p_source_code_for_id NUMBER,
56 p_pin_code VARCHAR2,
57 p_list_entry_source_system_id NUMBER,
58 p_list_entry_source_system_tp VARCHAR2,
59 p_view_application_id NUMBER,
60 p_manually_entered_flag VARCHAR2,
61 p_marked_as_duplicate_flag VARCHAR2,
62 p_marked_as_random_flag VARCHAR2,
63 p_part_of_control_group_flag VARCHAR2,
64 p_exclude_in_triggered_list_fg VARCHAR2,
65 p_enabled_flag VARCHAR2,
66 p_cell_code VARCHAR2,
67 p_dedupe_key VARCHAR2,
68 p_randomly_generated_number NUMBER,
69 p_campaign_id NUMBER,
70 p_media_id NUMBER,
71 p_channel_id NUMBER,
72 p_channel_schedule_id NUMBER,
73 p_event_offer_id NUMBER,
74 p_customer_id NUMBER,
75 p_market_segment_id NUMBER,
76 p_vendor_id NUMBER,
77 p_transfer_flag VARCHAR2,
78 p_transfer_status VARCHAR2,
79 p_list_source VARCHAR2,
80 p_duplicate_master_entry_id NUMBER,
81 p_marked_flag VARCHAR2,
82 p_lead_id NUMBER,
83 p_letter_id NUMBER,
84 p_picking_header_id NUMBER,
85 p_batch_id NUMBER,
86 p_suffix VARCHAR2,
87 p_first_name VARCHAR2,
88 p_last_name VARCHAR2,
89 p_customer_name VARCHAR2,
90 p_title VARCHAR2,
91 p_address_line1 VARCHAR2,
92 p_address_line2 VARCHAR2,
93 p_city VARCHAR2,
94 p_state VARCHAR2,
95 p_zipcode VARCHAR2,
96 p_country VARCHAR2,
97 p_fax VARCHAR2,
98 p_phone VARCHAR2,
99 p_email_address VARCHAR2,
100 p_col1 VARCHAR2,
101 p_col2 VARCHAR2,
102 p_col3 VARCHAR2,
103 p_col4 VARCHAR2,
104 p_col5 VARCHAR2,
105 p_col6 VARCHAR2,
106 p_col7 VARCHAR2,
107 p_col8 VARCHAR2,
108 p_col9 VARCHAR2,
109 p_col10 VARCHAR2,
110 p_col11 VARCHAR2,
111 p_col12 VARCHAR2,
112 p_col13 VARCHAR2,
113 p_col14 VARCHAR2,
114 p_col15 VARCHAR2,
115 p_col16 VARCHAR2,
116 p_col17 VARCHAR2,
117 p_col18 VARCHAR2,
118 p_col19 VARCHAR2,
119 p_col20 VARCHAR2,
120 p_col21 VARCHAR2,
121 p_col22 VARCHAR2,
122 p_col23 VARCHAR2,
123 p_col24 VARCHAR2,
124 p_col25 VARCHAR2,
125 p_col26 VARCHAR2,
126 p_col27 VARCHAR2,
127 p_col28 VARCHAR2,
128 p_col29 VARCHAR2,
129 p_col30 VARCHAR2,
130 p_col31 VARCHAR2,
131 p_col32 VARCHAR2,
132 p_col33 VARCHAR2,
133 p_col34 VARCHAR2,
134 p_col35 VARCHAR2,
135 p_col36 VARCHAR2,
136 p_col37 VARCHAR2,
137 p_col38 VARCHAR2,
138 p_col39 VARCHAR2,
139 p_col40 VARCHAR2,
140 p_col41 VARCHAR2,
141 p_col42 VARCHAR2,
142 p_col43 VARCHAR2,
143 p_col44 VARCHAR2,
144 p_col45 VARCHAR2,
145 p_col46 VARCHAR2,
146 p_col47 VARCHAR2,
147 p_col48 VARCHAR2,
148 p_col49 VARCHAR2,
149 p_col50 VARCHAR2,
150 p_col51 VARCHAR2,
151 p_col52 VARCHAR2,
152 p_col53 VARCHAR2,
153 p_col54 VARCHAR2,
154 p_col55 VARCHAR2,
155 p_col56 VARCHAR2,
156 p_col57 VARCHAR2,
157 p_col58 VARCHAR2,
158 p_col59 VARCHAR2,
159 p_col60 VARCHAR2,
160 p_col61 VARCHAR2,
161 p_col62 VARCHAR2,
162 p_col63 VARCHAR2,
163 p_col64 VARCHAR2,
164 p_col65 VARCHAR2,
165 p_col66 VARCHAR2,
166 p_col67 VARCHAR2,
167 p_col68 VARCHAR2,
168 p_col69 VARCHAR2,
169 p_col70 VARCHAR2,
170 p_col71 VARCHAR2,
171 p_col72 VARCHAR2,
172 p_col73 VARCHAR2,
173 p_col74 VARCHAR2,
174 p_col75 VARCHAR2,
175 p_col76 VARCHAR2,
176 p_col77 VARCHAR2,
177 p_col78 VARCHAR2,
178 p_col79 VARCHAR2,
179 p_col80 VARCHAR2,
180 p_col81 VARCHAR2,
181 p_col82 VARCHAR2,
182 p_col83 VARCHAR2,
183 p_col84 VARCHAR2,
184 p_col85 VARCHAR2,
185 p_col86 VARCHAR2,
186 p_col87 VARCHAR2,
187 p_col88 VARCHAR2,
188 p_col89 VARCHAR2,
189 p_col90 VARCHAR2,
190 p_col91 VARCHAR2,
191 p_col92 VARCHAR2,
192 p_col93 VARCHAR2,
193 p_col94 VARCHAR2,
194 p_col95 VARCHAR2,
195 p_col96 VARCHAR2,
196 p_col97 VARCHAR2,
197 p_col98 VARCHAR2,
198 p_col99 VARCHAR2,
199 p_col100 VARCHAR2,
200 p_col101 VARCHAR2,
201 p_col102 VARCHAR2,
202 p_col103 VARCHAR2,
203 p_col104 VARCHAR2,
204 p_col105 VARCHAR2,
205 p_col106 VARCHAR2,
206 p_col107 VARCHAR2,
207 p_col108 VARCHAR2,
208 p_col109 VARCHAR2,
209 p_col110 VARCHAR2,
210 p_col111 VARCHAR2,
211 p_col112 VARCHAR2,
212 p_col113 VARCHAR2,
213 p_col114 VARCHAR2,
214 p_col115 VARCHAR2,
215 p_col116 VARCHAR2,
216 p_col117 VARCHAR2,
217 p_col118 VARCHAR2,
218 p_col119 VARCHAR2,
219 p_col120 VARCHAR2,
220 p_col121 VARCHAR2,
221 p_col122 VARCHAR2,
222 p_col123 VARCHAR2,
223 p_col124 VARCHAR2,
224 p_col125 VARCHAR2,
225 p_col126 VARCHAR2,
226 p_col127 VARCHAR2,
227 p_col128 VARCHAR2,
228 p_col129 VARCHAR2,
229 p_col130 VARCHAR2,
230 p_col131 VARCHAR2,
231 p_col132 VARCHAR2,
232 p_col133 VARCHAR2,
233 p_col134 VARCHAR2,
234 p_col135 VARCHAR2,
235 p_col136 VARCHAR2,
236 p_col137 VARCHAR2,
237 p_col138 VARCHAR2,
238 p_col139 VARCHAR2,
239 p_col140 VARCHAR2,
240 p_col141 VARCHAR2,
241 p_col142 VARCHAR2,
242 p_col143 VARCHAR2,
243 p_col144 VARCHAR2,
244 p_col145 VARCHAR2,
245 p_col146 VARCHAR2,
246 p_col147 VARCHAR2,
247 p_col148 VARCHAR2,
248 p_col149 VARCHAR2,
249 p_col150 VARCHAR2,
250 p_col151 VARCHAR2,
251 p_col152 VARCHAR2,
252 p_col153 VARCHAR2,
253 p_col154 VARCHAR2,
254 p_col155 VARCHAR2,
255 p_col156 VARCHAR2,
256 p_col157 VARCHAR2,
257 p_col158 VARCHAR2,
258 p_col159 VARCHAR2,
259 p_col160 VARCHAR2,
260 p_col161 VARCHAR2,
261 p_col162 VARCHAR2,
262 p_col163 VARCHAR2,
263 p_col164 VARCHAR2,
264 p_col165 VARCHAR2,
265 p_col166 VARCHAR2,
266 p_col167 VARCHAR2,
267 p_col168 VARCHAR2,
268 p_col169 VARCHAR2,
269 p_col170 VARCHAR2,
270 p_col171 VARCHAR2,
271 p_col172 VARCHAR2,
272 p_col173 VARCHAR2,
273 p_col174 VARCHAR2,
274 p_col175 VARCHAR2,
275 p_col176 VARCHAR2,
276 p_col177 VARCHAR2,
277 p_col178 VARCHAR2,
278 p_col179 VARCHAR2,
279 p_col180 VARCHAR2,
280 p_col181 VARCHAR2,
281 p_col182 VARCHAR2,
282 p_col183 VARCHAR2,
283 p_col184 VARCHAR2,
284 p_col185 VARCHAR2,
285 p_col186 VARCHAR2,
286 p_col187 VARCHAR2,
287 p_col188 VARCHAR2,
288 p_col189 VARCHAR2,
289 p_col190 VARCHAR2,
290 p_col191 VARCHAR2,
291 p_col192 VARCHAR2,
292 p_col193 VARCHAR2,
293 p_col194 VARCHAR2,
294 p_col195 VARCHAR2,
295 p_col196 VARCHAR2,
296 p_col197 VARCHAR2,
297 p_col198 VARCHAR2,
298 p_col199 VARCHAR2,
299 p_col200 VARCHAR2,
300 p_col201 VARCHAR2,
301 p_col202 VARCHAR2,
302 p_col203 VARCHAR2,
303 p_col204 VARCHAR2,
304 p_col205 VARCHAR2,
305 p_col206 VARCHAR2,
306 p_col207 VARCHAR2,
307 p_col208 VARCHAR2,
308 p_col209 VARCHAR2,
309 p_col210 VARCHAR2,
310 p_col211 VARCHAR2,
311 p_col212 VARCHAR2,
312 p_col213 VARCHAR2,
313 p_col214 VARCHAR2,
314 p_col215 VARCHAR2,
315 p_col216 VARCHAR2,
316 p_col217 VARCHAR2,
317 p_col218 VARCHAR2,
318 p_col219 VARCHAR2,
319 p_col220 VARCHAR2,
320 p_col221 VARCHAR2,
321 p_col222 VARCHAR2,
322 p_col223 VARCHAR2,
323 p_col224 VARCHAR2,
324 p_col225 VARCHAR2,
325 p_col226 VARCHAR2,
326 p_col227 VARCHAR2,
327 p_col228 VARCHAR2,
328 p_col229 VARCHAR2,
329 p_col230 VARCHAR2,
330 p_col231 VARCHAR2,
331 p_col232 VARCHAR2,
332 p_col233 VARCHAR2,
333 p_col234 VARCHAR2,
334 p_col235 VARCHAR2,
335 p_col236 VARCHAR2,
336 p_col237 VARCHAR2,
337 p_col238 VARCHAR2,
338 p_col239 VARCHAR2,
339 p_col240 VARCHAR2,
340 p_col241 VARCHAR2,
341 p_col242 VARCHAR2,
342 p_col243 VARCHAR2,
343 p_col244 VARCHAR2,
344 p_col245 VARCHAR2,
345 p_col246 VARCHAR2,
346 p_col247 VARCHAR2,
347 p_col248 VARCHAR2,
348 p_col249 VARCHAR2,
349 p_col250 VARCHAR2,
350 p_col251 VARCHAR2,
351 p_col252 VARCHAR2,
352 p_col253 VARCHAR2,
353 p_col254 VARCHAR2,
354 p_col255 VARCHAR2,
355 p_col256 VARCHAR2,
356 p_col257 VARCHAR2,
357 p_col258 VARCHAR2,
358 p_col259 VARCHAR2,
359 p_col260 VARCHAR2,
360 p_col261 VARCHAR2,
361 p_col262 VARCHAR2,
362 p_col263 VARCHAR2,
363 p_col264 VARCHAR2,
364 p_col265 VARCHAR2,
365 p_col266 VARCHAR2,
366 p_col267 VARCHAR2,
367 p_col268 VARCHAR2,
368 p_col269 VARCHAR2,
369 p_col270 VARCHAR2,
370 p_col271 VARCHAR2,
371 p_col272 VARCHAR2,
372 p_col273 VARCHAR2,
373 p_col274 VARCHAR2,
374 p_col275 VARCHAR2,
375 p_col276 VARCHAR2,
376 p_col277 VARCHAR2,
377 p_col278 VARCHAR2,
378 p_col279 VARCHAR2,
379 p_col280 VARCHAR2,
380 p_col281 VARCHAR2,
381 p_col282 VARCHAR2,
385 p_col286 VARCHAR2,
382 p_col283 VARCHAR2,
383 p_col284 VARCHAR2,
384 p_col285 VARCHAR2,
386 p_col287 VARCHAR2,
387 p_col288 VARCHAR2,
388 p_col289 VARCHAR2,
389 p_col290 VARCHAR2,
390 p_col291 VARCHAR2,
391 p_col292 VARCHAR2,
392 p_col293 VARCHAR2,
393 p_col294 VARCHAR2,
394 p_col295 VARCHAR2,
395 p_col296 VARCHAR2,
396 p_col297 VARCHAR2,
397 p_col298 VARCHAR2,
398 p_col299 VARCHAR2,
399 p_col300 VARCHAR2,
400 p_party_id NUMBER,
401 p_parent_party_id NUMBER,
402 --p_geometry SDO_GEOMETRY,
403 p_imp_source_line_id NUMBER,
404 p_usage_restriction VARCHAR2,
405 p_next_call_time DATE,
406 p_callback_flag VARCHAR2,
407 p_do_not_use_flag VARCHAR2,
408 p_do_not_use_reason VARCHAR2,
409 p_record_out_flag VARCHAR2,
410 p_record_release_time DATE,
411 p_group_code VARCHAR2,
412 p_newly_updated_flag VARCHAR2,
413 p_outcome_id number,
414 p_result_id number,
415 p_reason_id number,
416 p_notes varchar2,
417 p_VEHICLE_RESPONSE_CODE varchar2,
418 p_SALES_AGENT_EMAIL_ADDRESS varchar2,
419 p_RESOURCE_ID number,
420 p_LOCATION_ID NUMBER,
421 p_CONTACT_POINT_ID NUMBER,
422 p_last_contacted_date DATE
423 )
424
425 IS
426 x_rowid VARCHAR2(30);
427
428
429 BEGIN
430
431
432 px_object_version_number := 1;
433
434
435 INSERT INTO AMS_LIST_ENTRIES(
436 list_entry_id,
437 list_header_id,
438 last_update_date,
439 last_updated_by,
440 creation_date,
441 created_by,
442 last_update_login,
443 object_version_number,
444 list_select_action_id,
445 arc_list_select_action_from,
446 list_select_action_from_name,
447 source_code,
448 arc_list_used_by_source,
449 source_code_for_id,
450 pin_code,
451 list_entry_source_system_id,
452 list_entry_source_system_type,
453 view_application_id,
454 manually_entered_flag,
455 marked_as_duplicate_flag,
456 marked_as_random_flag,
457 part_of_control_group_flag,
458 exclude_in_triggered_list_flag,
459 enabled_flag,
460 cell_code,
461 dedupe_key,
462 randomly_generated_number,
463 campaign_id,
464 media_id,
465 channel_id,
466 channel_schedule_id,
467 event_offer_id,
468 customer_id,
469 market_segment_id,
470 vendor_id,
471 transfer_flag,
472 transfer_status,
473 list_source,
474 duplicate_master_entry_id,
475 marked_flag,
476 lead_id,
477 letter_id,
478 picking_header_id,
479 batch_id,
480 suffix,
481 first_name,
482 last_name,
483 customer_name,
484 title,
485 address_line1,
486 address_line2,
487 city,
488 state,
489 zipcode,
490 country,
491 fax,
492 phone,
493 email_address,
494 col1,
495 col2,
496 col3,
497 col4,
498 col5,
499 col6,
500 col7,
501 col8,
502 col9,
503 col10,
504 col11,
505 col12,
506 col13,
507 col14,
508 col15,
509 col16,
510 col17,
511 col18,
512 col19,
513 col20,
514 col21,
515 col22,
516 col23,
517 col24,
518 col25,
519 col26,
520 col27,
521 col28,
522 col29,
523 col30,
524 col31,
525 col32,
526 col33,
527 col34,
528 col35,
529 col36,
530 col37,
531 col38,
532 col39,
533 col40,
534 col41,
535 col42,
536 col43,
537 col44,
538 col45,
539 col46,
540 col47,
541 col48,
542 col49,
543 col50,
544 col51,
545 col52,
546 col53,
547 col54,
548 col55,
549 col56,
550 col57,
551 col58,
552 col59,
553 col60,
554 col61,
555 col62,
556 col63,
557 col64,
558 col65,
559 col66,
560 col67,
561 col68,
562 col69,
563 col70,
564 col71,
565 col72,
566 col73,
567 col74,
568 col75,
572 col79,
569 col76,
570 col77,
571 col78,
573 col80,
574 col81,
575 col82,
576 col83,
577 col84,
578 col85,
579 col86,
580 col87,
581 col88,
582 col89,
583 col90,
584 col91,
585 col92,
586 col93,
587 col94,
588 col95,
589 col96,
590 col97,
591 col98,
592 col99,
593 col100,
594 col101,
595 col102,
596 col103,
597 col104,
598 col105,
599 col106,
600 col107,
601 col108,
602 col109,
603 col110,
604 col111,
605 col112,
606 col113,
607 col114,
608 col115,
609 col116,
610 col117,
611 col118,
612 col119,
613 col120,
614 col121,
615 col122,
616 col123,
617 col124,
618 col125,
619 col126,
620 col127,
621 col128,
622 col129,
623 col130,
624 col131,
625 col132,
626 col133,
627 col134,
628 col135,
629 col136,
630 col137,
631 col138,
632 col139,
633 col140,
634 col141,
635 col142,
636 col143,
637 col144,
638 col145,
639 col146,
640 col147,
641 col148,
642 col149,
643 col150,
644 col151,
645 col152,
646 col153,
647 col154,
648 col155,
649 col156,
650 col157,
651 col158,
652 col159,
653 col160,
654 col161,
655 col162,
656 col163,
657 col164,
658 col165,
659 col166,
660 col167,
661 col168,
662 col169,
663 col170,
664 col171,
665 col172,
666 col173,
667 col174,
668 col175,
669 col176,
670 col177,
671 col178,
672 col179,
673 col180,
674 col181,
675 col182,
676 col183,
677 col184,
678 col185,
679 col186,
680 col187,
681 col188,
682 col189,
683 col190,
684 col191,
685 col192,
686 col193,
687 col194,
688 col195,
689 col196,
690 col197,
691 col198,
692 col199,
693 col200,
694 col201,
695 col202,
696 col203,
697 col204,
698 col205,
699 col206,
700 col207,
701 col208,
702 col209,
703 col210,
704 col211,
705 col212,
706 col213,
707 col214,
708 col215,
709 col216,
710 col217,
711 col218,
712 col219,
713 col220,
714 col221,
715 col222,
716 col223,
717 col224,
718 col225,
719 col226,
720 col227,
721 col228,
722 col229,
723 col230,
724 col231,
725 col232,
726 col233,
727 col234,
728 col235,
729 col236,
730 col237,
731 col238,
732 col239,
733 col240,
734 col241,
735 col242,
736 col243,
737 col244,
738 col245,
739 col246,
740 col247,
741 col248,
742 col249,
743 col250,
744 col251,
745 col252,
746 col253,
747 col254,
748 col255,
749 col256,
750 col257,
751 col258,
752 col259,
753 col260,
754 col261,
755 col262,
756 col263,
757 col264,
758 col265,
759 col266,
760 col267,
761 col268,
762 col269,
763 col270,
764 col271,
765 col272,
766 col273,
767 col274,
768 col275,
769 col276,
770 col277,
771 col278,
772 col279,
773 col280,
774 col281,
775 col282,
776 col283,
777 col284,
778 col285,
779 col286,
780 col287,
781 col288,
782 col289,
783 col290,
784 col291,
788 col295,
785 col292,
786 col293,
787 col294,
789 col296,
790 col297,
791 col298,
792 col299,
793 col300,
794 party_id,
795 parent_party_id,
796 -- geometry,
797 imp_source_line_id,
798 usage_restriction,
799 next_call_time,
800 callback_flag,
801 do_not_use_flag,
802 do_not_use_reason,
803 record_out_flag,
804 record_release_time,
805 group_code,
806 newly_updated_flag,
807 outcome_id,
808 result_id,
809 reason_id,
810 notes ,
811 VEHICLE_RESPONSE_CODE ,
812 SALES_AGENT_EMAIL_ADDRESS ,
813 RESOURCE_ID ,
814 LOCATION_ID ,
815 CONTACT_POINT_ID ,
816 last_contacted_date
817
818 ) VALUES (
819 DECODE( px_list_entry_id, FND_API.g_miss_num, NULL, px_list_entry_id),
820 DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
821 DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
822 DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
823 DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
824 DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
825 DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
826 DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
827 DECODE( p_list_select_action_id, FND_API.g_miss_num, NULL, p_list_select_action_id),
828 DECODE( p_arc_list_select_action_from, FND_API.g_miss_char, NULL, p_arc_list_select_action_from),
829 DECODE( p_list_select_action_from_name, FND_API.g_miss_char, NULL, p_list_select_action_from_name),
830 DECODE( p_source_code, FND_API.g_miss_char, NULL, p_source_code),
831 DECODE( p_arc_list_used_by_source, FND_API.g_miss_char, NULL, p_arc_list_used_by_source),
832 DECODE( p_source_code_for_id, FND_API.g_miss_num, NULL, p_source_code_for_id),
833 DECODE( p_pin_code, FND_API.g_miss_char, NULL, p_pin_code),
834 DECODE( p_list_entry_source_system_id, FND_API.g_miss_num, NULL, p_list_entry_source_system_id),
835 DECODE( p_list_entry_source_system_tp, FND_API.g_miss_char, NULL, p_list_entry_source_system_tp),
836 DECODE( p_view_application_id, FND_API.g_miss_num, NULL, p_view_application_id),
837 DECODE( p_manually_entered_flag, FND_API.g_miss_char, NULL, p_manually_entered_flag),
838 DECODE( p_marked_as_duplicate_flag, FND_API.g_miss_char, NULL, p_marked_as_duplicate_flag),
839 DECODE( p_marked_as_random_flag, FND_API.g_miss_char, NULL, p_marked_as_random_flag),
840 DECODE( p_part_of_control_group_flag, FND_API.g_miss_char, NULL, p_part_of_control_group_flag),
841 DECODE( p_exclude_in_triggered_list_fg, FND_API.g_miss_char, NULL, p_exclude_in_triggered_list_fg),
842 DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
843 DECODE( p_cell_code, FND_API.g_miss_char, NULL, p_cell_code),
844 DECODE( p_dedupe_key, FND_API.g_miss_char, NULL, p_dedupe_key),
845 DECODE( p_randomly_generated_number, FND_API.g_miss_num, NULL, p_randomly_generated_number),
846 DECODE( p_campaign_id, FND_API.g_miss_num, NULL, p_campaign_id),
847 DECODE( p_media_id, FND_API.g_miss_num, NULL, p_media_id),
848 DECODE( p_channel_id, FND_API.g_miss_num, NULL, p_channel_id),
849 DECODE( p_channel_schedule_id, FND_API.g_miss_num, NULL, p_channel_schedule_id),
850 DECODE( p_event_offer_id, FND_API.g_miss_num, NULL, p_event_offer_id),
851 DECODE( p_customer_id, FND_API.g_miss_num, NULL, p_customer_id),
852 DECODE( p_market_segment_id, FND_API.g_miss_num, NULL, p_market_segment_id),
853 DECODE( p_vendor_id, FND_API.g_miss_num, NULL, p_vendor_id),
854 DECODE( p_transfer_flag, FND_API.g_miss_char, NULL, p_transfer_flag),
855 DECODE( p_transfer_status, FND_API.g_miss_char, NULL, p_transfer_status),
856 DECODE( p_list_source, FND_API.g_miss_char, NULL, p_list_source),
857 DECODE( p_duplicate_master_entry_id, FND_API.g_miss_num, NULL, p_duplicate_master_entry_id),
858 DECODE( p_marked_flag, FND_API.g_miss_char, NULL, p_marked_flag),
859 DECODE( p_lead_id, FND_API.g_miss_num, NULL, p_lead_id),
860 DECODE( p_letter_id, FND_API.g_miss_num, NULL, p_letter_id),
861 DECODE( p_picking_header_id, FND_API.g_miss_num, NULL, p_picking_header_id),
862 DECODE( p_batch_id, FND_API.g_miss_num, NULL, p_batch_id),
863 DECODE( p_suffix, FND_API.g_miss_char, NULL, p_suffix),
864 DECODE( p_first_name, FND_API.g_miss_char, NULL, p_first_name),
865 DECODE( p_last_name, FND_API.g_miss_char, NULL, p_last_name),
866 DECODE( p_customer_name, FND_API.g_miss_char, NULL, p_customer_name),
867 DECODE( p_title, FND_API.g_miss_char, NULL, p_title),
868 DECODE( p_address_line1, FND_API.g_miss_char, NULL, p_address_line1),
869 DECODE( p_address_line2, FND_API.g_miss_char, NULL, p_address_line2),
870 DECODE( p_city, FND_API.g_miss_char, NULL, p_city),
871 DECODE( p_state, FND_API.g_miss_char, NULL, p_state),
872 DECODE( p_zipcode, FND_API.g_miss_char, NULL, p_zipcode),
873 DECODE( p_country, FND_API.g_miss_char, NULL, p_country),
874 DECODE( p_fax, FND_API.g_miss_char, NULL, p_fax),
875 DECODE( p_phone, FND_API.g_miss_char, NULL, p_phone),
876 DECODE( p_email_address, FND_API.g_miss_char, NULL, p_email_address),
877 DECODE( p_col1, FND_API.g_miss_char, NULL, p_col1),
878 DECODE( p_col2, FND_API.g_miss_char, NULL, p_col2),
879 DECODE( p_col3, FND_API.g_miss_char, NULL, p_col3),
883 DECODE( p_col7, FND_API.g_miss_char, NULL, p_col7),
880 DECODE( p_col4, FND_API.g_miss_char, NULL, p_col4),
881 DECODE( p_col5, FND_API.g_miss_char, NULL, p_col5),
882 DECODE( p_col6, FND_API.g_miss_char, NULL, p_col6),
884 DECODE( p_col8, FND_API.g_miss_char, NULL, p_col8),
885 DECODE( p_col9, FND_API.g_miss_char, NULL, p_col9),
886 DECODE( p_col10, FND_API.g_miss_char, NULL, p_col10),
887 DECODE( p_col11, FND_API.g_miss_char, NULL, p_col11),
888 DECODE( p_col12, FND_API.g_miss_char, NULL, p_col12),
889 DECODE( p_col13, FND_API.g_miss_char, NULL, p_col13),
890 DECODE( p_col14, FND_API.g_miss_char, NULL, p_col14),
891 DECODE( p_col15, FND_API.g_miss_char, NULL, p_col15),
892 DECODE( p_col16, FND_API.g_miss_char, NULL, p_col16),
893 DECODE( p_col17, FND_API.g_miss_char, NULL, p_col17),
894 DECODE( p_col18, FND_API.g_miss_char, NULL, p_col18),
895 DECODE( p_col19, FND_API.g_miss_char, NULL, p_col19),
896 DECODE( p_col20, FND_API.g_miss_char, NULL, p_col20),
897 DECODE( p_col21, FND_API.g_miss_char, NULL, p_col21),
898 DECODE( p_col22, FND_API.g_miss_char, NULL, p_col22),
899 DECODE( p_col23, FND_API.g_miss_char, NULL, p_col23),
900 DECODE( p_col24, FND_API.g_miss_char, NULL, p_col24),
901 DECODE( p_col25, FND_API.g_miss_char, NULL, p_col25),
902 DECODE( p_col26, FND_API.g_miss_char, NULL, p_col26),
903 DECODE( p_col27, FND_API.g_miss_char, NULL, p_col27),
904 DECODE( p_col28, FND_API.g_miss_char, NULL, p_col28),
905 DECODE( p_col29, FND_API.g_miss_char, NULL, p_col29),
906 DECODE( p_col30, FND_API.g_miss_char, NULL, p_col30),
907 DECODE( p_col31, FND_API.g_miss_char, NULL, p_col31),
908 DECODE( p_col32, FND_API.g_miss_char, NULL, p_col32),
909 DECODE( p_col33, FND_API.g_miss_char, NULL, p_col33),
910 DECODE( p_col34, FND_API.g_miss_char, NULL, p_col34),
911 DECODE( p_col35, FND_API.g_miss_char, NULL, p_col35),
912 DECODE( p_col36, FND_API.g_miss_char, NULL, p_col36),
913 DECODE( p_col37, FND_API.g_miss_char, NULL, p_col37),
914 DECODE( p_col38, FND_API.g_miss_char, NULL, p_col38),
915 DECODE( p_col39, FND_API.g_miss_char, NULL, p_col39),
916 DECODE( p_col40, FND_API.g_miss_char, NULL, p_col40),
917 DECODE( p_col41, FND_API.g_miss_char, NULL, p_col41),
918 DECODE( p_col42, FND_API.g_miss_char, NULL, p_col42),
919 DECODE( p_col43, FND_API.g_miss_char, NULL, p_col43),
920 DECODE( p_col44, FND_API.g_miss_char, NULL, p_col44),
921 DECODE( p_col45, FND_API.g_miss_char, NULL, p_col45),
922 DECODE( p_col46, FND_API.g_miss_char, NULL, p_col46),
923 DECODE( p_col47, FND_API.g_miss_char, NULL, p_col47),
924 DECODE( p_col48, FND_API.g_miss_char, NULL, p_col48),
925 DECODE( p_col49, FND_API.g_miss_char, NULL, p_col49),
926 DECODE( p_col50, FND_API.g_miss_char, NULL, p_col50),
927 DECODE( p_col51, FND_API.g_miss_char, NULL, p_col51),
928 DECODE( p_col52, FND_API.g_miss_char, NULL, p_col52),
929 DECODE( p_col53, FND_API.g_miss_char, NULL, p_col53),
930 DECODE( p_col54, FND_API.g_miss_char, NULL, p_col54),
931 DECODE( p_col55, FND_API.g_miss_char, NULL, p_col55),
932 DECODE( p_col56, FND_API.g_miss_char, NULL, p_col56),
933 DECODE( p_col57, FND_API.g_miss_char, NULL, p_col57),
934 DECODE( p_col58, FND_API.g_miss_char, NULL, p_col58),
935 DECODE( p_col59, FND_API.g_miss_char, NULL, p_col59),
936 DECODE( p_col60, FND_API.g_miss_char, NULL, p_col60),
937 DECODE( p_col61, FND_API.g_miss_char, NULL, p_col61),
938 DECODE( p_col62, FND_API.g_miss_char, NULL, p_col62),
939 DECODE( p_col63, FND_API.g_miss_char, NULL, p_col63),
940 DECODE( p_col64, FND_API.g_miss_char, NULL, p_col64),
941 DECODE( p_col65, FND_API.g_miss_char, NULL, p_col65),
942 DECODE( p_col66, FND_API.g_miss_char, NULL, p_col66),
943 DECODE( p_col67, FND_API.g_miss_char, NULL, p_col67),
944 DECODE( p_col68, FND_API.g_miss_char, NULL, p_col68),
945 DECODE( p_col69, FND_API.g_miss_char, NULL, p_col69),
946 DECODE( p_col70, FND_API.g_miss_char, NULL, p_col70),
947 DECODE( p_col71, FND_API.g_miss_char, NULL, p_col71),
948 DECODE( p_col72, FND_API.g_miss_char, NULL, p_col72),
949 DECODE( p_col73, FND_API.g_miss_char, NULL, p_col73),
950 DECODE( p_col74, FND_API.g_miss_char, NULL, p_col74),
951 DECODE( p_col75, FND_API.g_miss_char, NULL, p_col75),
952 DECODE( p_col76, FND_API.g_miss_char, NULL, p_col76),
953 DECODE( p_col77, FND_API.g_miss_char, NULL, p_col77),
954 DECODE( p_col78, FND_API.g_miss_char, NULL, p_col78),
955 DECODE( p_col79, FND_API.g_miss_char, NULL, p_col79),
956 DECODE( p_col80, FND_API.g_miss_char, NULL, p_col80),
957 DECODE( p_col81, FND_API.g_miss_char, NULL, p_col81),
958 DECODE( p_col82, FND_API.g_miss_char, NULL, p_col82),
959 DECODE( p_col83, FND_API.g_miss_char, NULL, p_col83),
960 DECODE( p_col84, FND_API.g_miss_char, NULL, p_col84),
961 DECODE( p_col85, FND_API.g_miss_char, NULL, p_col85),
962 DECODE( p_col86, FND_API.g_miss_char, NULL, p_col86),
963 DECODE( p_col87, FND_API.g_miss_char, NULL, p_col87),
964 DECODE( p_col88, FND_API.g_miss_char, NULL, p_col88),
965 DECODE( p_col89, FND_API.g_miss_char, NULL, p_col89),
966 DECODE( p_col90, FND_API.g_miss_char, NULL, p_col90),
967 DECODE( p_col91, FND_API.g_miss_char, NULL, p_col91),
968 DECODE( p_col92, FND_API.g_miss_char, NULL, p_col92),
972 DECODE( p_col96, FND_API.g_miss_char, NULL, p_col96),
969 DECODE( p_col93, FND_API.g_miss_char, NULL, p_col93),
970 DECODE( p_col94, FND_API.g_miss_char, NULL, p_col94),
971 DECODE( p_col95, FND_API.g_miss_char, NULL, p_col95),
973 DECODE( p_col97, FND_API.g_miss_char, NULL, p_col97),
974 DECODE( p_col98, FND_API.g_miss_char, NULL, p_col98),
975 DECODE( p_col99, FND_API.g_miss_char, NULL, p_col99),
976 DECODE( p_col100, FND_API.g_miss_char, NULL, p_col100),
977 DECODE( p_col101, FND_API.g_miss_char, NULL, p_col101),
978 DECODE( p_col102, FND_API.g_miss_char, NULL, p_col102),
979 DECODE( p_col103, FND_API.g_miss_char, NULL, p_col103),
980 DECODE( p_col104, FND_API.g_miss_char, NULL, p_col104),
981 DECODE( p_col105, FND_API.g_miss_char, NULL, p_col105),
982 DECODE( p_col106, FND_API.g_miss_char, NULL, p_col106),
983 DECODE( p_col107, FND_API.g_miss_char, NULL, p_col107),
984 DECODE( p_col108, FND_API.g_miss_char, NULL, p_col108),
985 DECODE( p_col109, FND_API.g_miss_char, NULL, p_col109),
986 DECODE( p_col110, FND_API.g_miss_char, NULL, p_col110),
987 DECODE( p_col111, FND_API.g_miss_char, NULL, p_col111),
988 DECODE( p_col112, FND_API.g_miss_char, NULL, p_col112),
989 DECODE( p_col113, FND_API.g_miss_char, NULL, p_col113),
990 DECODE( p_col114, FND_API.g_miss_char, NULL, p_col114),
991 DECODE( p_col115, FND_API.g_miss_char, NULL, p_col115),
992 DECODE( p_col116, FND_API.g_miss_char, NULL, p_col116),
993 DECODE( p_col117, FND_API.g_miss_char, NULL, p_col117),
994 DECODE( p_col118, FND_API.g_miss_char, NULL, p_col118),
995 DECODE( p_col119, FND_API.g_miss_char, NULL, p_col119),
996 DECODE( p_col120, FND_API.g_miss_char, NULL, p_col120),
997 DECODE( p_col121, FND_API.g_miss_char, NULL, p_col121),
998 DECODE( p_col122, FND_API.g_miss_char, NULL, p_col122),
999 DECODE( p_col123, FND_API.g_miss_char, NULL, p_col123),
1000 DECODE( p_col124, FND_API.g_miss_char, NULL, p_col124),
1001 DECODE( p_col125, FND_API.g_miss_char, NULL, p_col125),
1002 DECODE( p_col126, FND_API.g_miss_char, NULL, p_col126),
1003 DECODE( p_col127, FND_API.g_miss_char, NULL, p_col127),
1004 DECODE( p_col128, FND_API.g_miss_char, NULL, p_col128),
1005 DECODE( p_col129, FND_API.g_miss_char, NULL, p_col129),
1006 DECODE( p_col130, FND_API.g_miss_char, NULL, p_col130),
1007 DECODE( p_col131, FND_API.g_miss_char, NULL, p_col131),
1008 DECODE( p_col132, FND_API.g_miss_char, NULL, p_col132),
1009 DECODE( p_col133, FND_API.g_miss_char, NULL, p_col133),
1010 DECODE( p_col134, FND_API.g_miss_char, NULL, p_col134),
1011 DECODE( p_col135, FND_API.g_miss_char, NULL, p_col135),
1012 DECODE( p_col136, FND_API.g_miss_char, NULL, p_col136),
1013 DECODE( p_col137, FND_API.g_miss_char, NULL, p_col137),
1014 DECODE( p_col138, FND_API.g_miss_char, NULL, p_col138),
1015 DECODE( p_col139, FND_API.g_miss_char, NULL, p_col139),
1016 DECODE( p_col140, FND_API.g_miss_char, NULL, p_col140),
1017 DECODE( p_col141, FND_API.g_miss_char, NULL, p_col141),
1018 DECODE( p_col142, FND_API.g_miss_char, NULL, p_col142),
1019 DECODE( p_col143, FND_API.g_miss_char, NULL, p_col143),
1020 DECODE( p_col144, FND_API.g_miss_char, NULL, p_col144),
1021 DECODE( p_col145, FND_API.g_miss_char, NULL, p_col145),
1022 DECODE( p_col146, FND_API.g_miss_char, NULL, p_col146),
1023 DECODE( p_col147, FND_API.g_miss_char, NULL, p_col147),
1024 DECODE( p_col148, FND_API.g_miss_char, NULL, p_col148),
1025 DECODE( p_col149, FND_API.g_miss_char, NULL, p_col149),
1026 DECODE( p_col150, FND_API.g_miss_char, NULL, p_col150),
1027 DECODE( p_col151, FND_API.g_miss_char, NULL, p_col151),
1028 DECODE( p_col152, FND_API.g_miss_char, NULL, p_col152),
1029 DECODE( p_col153, FND_API.g_miss_char, NULL, p_col153),
1030 DECODE( p_col154, FND_API.g_miss_char, NULL, p_col154),
1031 DECODE( p_col155, FND_API.g_miss_char, NULL, p_col155),
1032 DECODE( p_col156, FND_API.g_miss_char, NULL, p_col156),
1033 DECODE( p_col157, FND_API.g_miss_char, NULL, p_col157),
1034 DECODE( p_col158, FND_API.g_miss_char, NULL, p_col158),
1035 DECODE( p_col159, FND_API.g_miss_char, NULL, p_col159),
1036 DECODE( p_col160, FND_API.g_miss_char, NULL, p_col160),
1037 DECODE( p_col161, FND_API.g_miss_char, NULL, p_col161),
1038 DECODE( p_col162, FND_API.g_miss_char, NULL, p_col162),
1039 DECODE( p_col163, FND_API.g_miss_char, NULL, p_col163),
1040 DECODE( p_col164, FND_API.g_miss_char, NULL, p_col164),
1041 DECODE( p_col165, FND_API.g_miss_char, NULL, p_col165),
1042 DECODE( p_col166, FND_API.g_miss_char, NULL, p_col166),
1043 DECODE( p_col167, FND_API.g_miss_char, NULL, p_col167),
1044 DECODE( p_col168, FND_API.g_miss_char, NULL, p_col168),
1045 DECODE( p_col169, FND_API.g_miss_char, NULL, p_col169),
1046 DECODE( p_col170, FND_API.g_miss_char, NULL, p_col170),
1047 DECODE( p_col171, FND_API.g_miss_char, NULL, p_col171),
1048 DECODE( p_col172, FND_API.g_miss_char, NULL, p_col172),
1049 DECODE( p_col173, FND_API.g_miss_char, NULL, p_col173),
1050 DECODE( p_col174, FND_API.g_miss_char, NULL, p_col174),
1051 DECODE( p_col175, FND_API.g_miss_char, NULL, p_col175),
1052 DECODE( p_col176, FND_API.g_miss_char, NULL, p_col176),
1053 DECODE( p_col177, FND_API.g_miss_char, NULL, p_col177),
1054 DECODE( p_col178, FND_API.g_miss_char, NULL, p_col178),
1055 DECODE( p_col179, FND_API.g_miss_char, NULL, p_col179),
1059 DECODE( p_col183, FND_API.g_miss_char, NULL, p_col183),
1056 DECODE( p_col180, FND_API.g_miss_char, NULL, p_col180),
1057 DECODE( p_col181, FND_API.g_miss_char, NULL, p_col181),
1058 DECODE( p_col182, FND_API.g_miss_char, NULL, p_col182),
1060 DECODE( p_col184, FND_API.g_miss_char, NULL, p_col184),
1061 DECODE( p_col185, FND_API.g_miss_char, NULL, p_col185),
1062 DECODE( p_col186, FND_API.g_miss_char, NULL, p_col186),
1063 DECODE( p_col187, FND_API.g_miss_char, NULL, p_col187),
1064 DECODE( p_col188, FND_API.g_miss_char, NULL, p_col188),
1065 DECODE( p_col189, FND_API.g_miss_char, NULL, p_col189),
1066 DECODE( p_col190, FND_API.g_miss_char, NULL, p_col190),
1067 DECODE( p_col191, FND_API.g_miss_char, NULL, p_col191),
1068 DECODE( p_col192, FND_API.g_miss_char, NULL, p_col192),
1069 DECODE( p_col193, FND_API.g_miss_char, NULL, p_col193),
1070 DECODE( p_col194, FND_API.g_miss_char, NULL, p_col194),
1071 DECODE( p_col195, FND_API.g_miss_char, NULL, p_col195),
1072 DECODE( p_col196, FND_API.g_miss_char, NULL, p_col196),
1073 DECODE( p_col197, FND_API.g_miss_char, NULL, p_col197),
1074 DECODE( p_col198, FND_API.g_miss_char, NULL, p_col198),
1075 DECODE( p_col199, FND_API.g_miss_char, NULL, p_col199),
1076 DECODE( p_col200, FND_API.g_miss_char, NULL, p_col200),
1077 DECODE( p_col201, FND_API.g_miss_char, NULL, p_col201),
1078 DECODE( p_col202, FND_API.g_miss_char, NULL, p_col202),
1079 DECODE( p_col203, FND_API.g_miss_char, NULL, p_col203),
1080 DECODE( p_col204, FND_API.g_miss_char, NULL, p_col204),
1081 DECODE( p_col205, FND_API.g_miss_char, NULL, p_col205),
1082 DECODE( p_col206, FND_API.g_miss_char, NULL, p_col206),
1083 DECODE( p_col207, FND_API.g_miss_char, NULL, p_col207),
1084 DECODE( p_col208, FND_API.g_miss_char, NULL, p_col208),
1085 DECODE( p_col209, FND_API.g_miss_char, NULL, p_col209),
1086 DECODE( p_col210, FND_API.g_miss_char, NULL, p_col210),
1087 DECODE( p_col211, FND_API.g_miss_char, NULL, p_col211),
1088 DECODE( p_col212, FND_API.g_miss_char, NULL, p_col212),
1089 DECODE( p_col213, FND_API.g_miss_char, NULL, p_col213),
1090 DECODE( p_col214, FND_API.g_miss_char, NULL, p_col214),
1091 DECODE( p_col215, FND_API.g_miss_char, NULL, p_col215),
1092 DECODE( p_col216, FND_API.g_miss_char, NULL, p_col216),
1093 DECODE( p_col217, FND_API.g_miss_char, NULL, p_col217),
1094 DECODE( p_col218, FND_API.g_miss_char, NULL, p_col218),
1095 DECODE( p_col219, FND_API.g_miss_char, NULL, p_col219),
1096 DECODE( p_col220, FND_API.g_miss_char, NULL, p_col220),
1097 DECODE( p_col221, FND_API.g_miss_char, NULL, p_col221),
1098 DECODE( p_col222, FND_API.g_miss_char, NULL, p_col222),
1099 DECODE( p_col223, FND_API.g_miss_char, NULL, p_col223),
1100 DECODE( p_col224, FND_API.g_miss_char, NULL, p_col224),
1101 DECODE( p_col225, FND_API.g_miss_char, NULL, p_col225),
1102 DECODE( p_col226, FND_API.g_miss_char, NULL, p_col226),
1103 DECODE( p_col227, FND_API.g_miss_char, NULL, p_col227),
1104 DECODE( p_col228, FND_API.g_miss_char, NULL, p_col228),
1105 DECODE( p_col229, FND_API.g_miss_char, NULL, p_col229),
1106 DECODE( p_col230, FND_API.g_miss_char, NULL, p_col230),
1107 DECODE( p_col231, FND_API.g_miss_char, NULL, p_col231),
1108 DECODE( p_col232, FND_API.g_miss_char, NULL, p_col232),
1109 DECODE( p_col233, FND_API.g_miss_char, NULL, p_col233),
1110 DECODE( p_col234, FND_API.g_miss_char, NULL, p_col234),
1111 DECODE( p_col235, FND_API.g_miss_char, NULL, p_col235),
1112 DECODE( p_col236, FND_API.g_miss_char, NULL, p_col236),
1113 DECODE( p_col237, FND_API.g_miss_char, NULL, p_col237),
1114 DECODE( p_col238, FND_API.g_miss_char, NULL, p_col238),
1115 DECODE( p_col239, FND_API.g_miss_char, NULL, p_col239),
1116 DECODE( p_col240, FND_API.g_miss_char, NULL, p_col240),
1117 DECODE( p_col241, FND_API.g_miss_char, NULL, p_col241),
1118 DECODE( p_col242, FND_API.g_miss_char, NULL, p_col242),
1119 DECODE( p_col243, FND_API.g_miss_char, NULL, p_col243),
1120 DECODE( p_col244, FND_API.g_miss_char, NULL, p_col244),
1121 DECODE( p_col245, FND_API.g_miss_char, NULL, p_col245),
1122 DECODE( p_col246, FND_API.g_miss_char, NULL, p_col246),
1123 DECODE( p_col247, FND_API.g_miss_char, NULL, p_col247),
1124 DECODE( p_col248, FND_API.g_miss_char, NULL, p_col248),
1125 DECODE( p_col249, FND_API.g_miss_char, NULL, p_col249),
1126 DECODE( p_col250, FND_API.g_miss_char, NULL, p_col250),
1127 DECODE( p_col251, FND_API.g_miss_char, NULL, p_col251),
1128 DECODE( p_col252, FND_API.g_miss_char, NULL, p_col252),
1129 DECODE( p_col253, FND_API.g_miss_char, NULL, p_col253),
1130 DECODE( p_col254, FND_API.g_miss_char, NULL, p_col254),
1131 DECODE( p_col255, FND_API.g_miss_char, NULL, p_col255),
1132 DECODE( p_col256, FND_API.g_miss_char, NULL, p_col256),
1133 DECODE( p_col257, FND_API.g_miss_char, NULL, p_col257),
1134 DECODE( p_col258, FND_API.g_miss_char, NULL, p_col258),
1135 DECODE( p_col259, FND_API.g_miss_char, NULL, p_col259),
1136 DECODE( p_col260, FND_API.g_miss_char, NULL, p_col260),
1137 DECODE( p_col261, FND_API.g_miss_char, NULL, p_col261),
1138 DECODE( p_col262, FND_API.g_miss_char, NULL, p_col262),
1139 DECODE( p_col263, FND_API.g_miss_char, NULL, p_col263),
1140 DECODE( p_col264, FND_API.g_miss_char, NULL, p_col264),
1141 DECODE( p_col265, FND_API.g_miss_char, NULL, p_col265),
1142 DECODE( p_col266, FND_API.g_miss_char, NULL, p_col266),
1143 DECODE( p_col267, FND_API.g_miss_char, NULL, p_col267),
1147 DECODE( p_col271, FND_API.g_miss_char, NULL, p_col271),
1144 DECODE( p_col268, FND_API.g_miss_char, NULL, p_col268),
1145 DECODE( p_col269, FND_API.g_miss_char, NULL, p_col269),
1146 DECODE( p_col270, FND_API.g_miss_char, NULL, p_col270),
1148 DECODE( p_col272, FND_API.g_miss_char, NULL, p_col272),
1149 DECODE( p_col273, FND_API.g_miss_char, NULL, p_col273),
1150 DECODE( p_col274, FND_API.g_miss_char, NULL, p_col274),
1151 DECODE( p_col275, FND_API.g_miss_char, NULL, p_col275),
1152 DECODE( p_col276, FND_API.g_miss_char, NULL, p_col276),
1153 DECODE( p_col277, FND_API.g_miss_char, NULL, p_col277),
1154 DECODE( p_col278, FND_API.g_miss_char, NULL, p_col278),
1155 DECODE( p_col279, FND_API.g_miss_char, NULL, p_col279),
1156 DECODE( p_col280, FND_API.g_miss_char, NULL, p_col280),
1157 DECODE( p_col281, FND_API.g_miss_char, NULL, p_col281),
1158 DECODE( p_col282, FND_API.g_miss_char, NULL, p_col282),
1159 DECODE( p_col283, FND_API.g_miss_char, NULL, p_col283),
1160 DECODE( p_col284, FND_API.g_miss_char, NULL, p_col284),
1161 DECODE( p_col285, FND_API.g_miss_char, NULL, p_col285),
1162 DECODE( p_col286, FND_API.g_miss_char, NULL, p_col286),
1163 DECODE( p_col287, FND_API.g_miss_char, NULL, p_col287),
1164 DECODE( p_col288, FND_API.g_miss_char, NULL, p_col288),
1165 DECODE( p_col289, FND_API.g_miss_char, NULL, p_col289),
1166 DECODE( p_col290, FND_API.g_miss_char, NULL, p_col290),
1167 DECODE( p_col291, FND_API.g_miss_char, NULL, p_col291),
1168 DECODE( p_col292, FND_API.g_miss_char, NULL, p_col292),
1169 DECODE( p_col293, FND_API.g_miss_char, NULL, p_col293),
1170 DECODE( p_col294, FND_API.g_miss_char, NULL, p_col294),
1171 DECODE( p_col295, FND_API.g_miss_char, NULL, p_col295),
1172 DECODE( p_col296, FND_API.g_miss_char, NULL, p_col296),
1173 DECODE( p_col297, FND_API.g_miss_char, NULL, p_col297),
1174 DECODE( p_col298, FND_API.g_miss_char, NULL, p_col298),
1175 DECODE( p_col299, FND_API.g_miss_char, NULL, p_col299),
1176 DECODE( p_col300, FND_API.g_miss_char, NULL, p_col300),
1177 DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id),
1178 DECODE( p_parent_party_id, FND_API.g_miss_num, NULL, p_parent_party_id),
1179 -- DECODE( p_geometry, FND_API.g_miss_char, NULL, p_geometry),
1180 DECODE( p_imp_source_line_id, FND_API.g_miss_num, NULL, p_imp_source_line_id),
1181 DECODE( p_usage_restriction, FND_API.g_miss_char, NULL, p_usage_restriction),
1182 DECODE( p_next_call_time, FND_API.g_miss_date, NULL, p_next_call_time),
1183 DECODE( p_callback_flag, FND_API.g_miss_char, NULL, p_callback_flag),
1184 DECODE( p_do_not_use_flag, FND_API.g_miss_char, NULL, p_do_not_use_flag),
1185 DECODE( p_do_not_use_reason, FND_API.g_miss_char, NULL, p_do_not_use_reason),
1186 DECODE( p_record_out_flag, FND_API.g_miss_char, NULL, p_record_out_flag),
1187 DECODE( p_record_release_time, FND_API.g_miss_date, NULL, p_record_release_time),
1188 DECODE( p_group_code, FND_API.g_miss_char, NULL, p_group_code),
1189 DECODE( p_newly_updated_flag, FND_API.g_miss_char, NULL, p_newly_updated_flag),
1190 DECODE( p_outcome_id, FND_API.g_miss_num, NULL, p_outcome_id),
1191 DECODE( p_result_id, FND_API.g_miss_num, NULL, p_result_id),
1192 DECODE( p_reason_id, FND_API.g_miss_num, NULL, p_reason_id),
1193 DECODE( p_notes, FND_API.g_miss_char, NULL, p_notes),
1194 DECODE( p_VEHICLE_RESPONSE_CODE, FND_API.g_miss_char, NULL, p_vehicle_response_code),
1195 DECODE( p_SALES_AGENT_EMAIL_ADDRESS, FND_API.g_miss_char, NULL, p_SALES_AGENT_EMAIL_ADDRESS),
1196 DECODE( p_resource_id, FND_API.g_miss_num, NULL, p_resource_id),
1197 DECODE( p_location_id, FND_API.g_miss_num, NULL, p_location_id),
1198 DECODE( p_contact_point_id, FND_API.g_miss_num, NULL, p_contact_point_id),
1199 DECODE( p_last_contacted_date, FND_API.g_miss_date, NULL, p_last_contacted_date)
1200 );
1201 END Insert_Row;
1202
1203
1204 ----------------------------------------------------------
1205 ---- MEDIA ----
1206 ----------------------------------------------------------
1207
1208 -- ========================================================
1209 --
1210 -- NAME
1211 -- createUpdateBody
1212 --
1213 -- PURPOSE
1214 --
1215 -- NOTES
1216 --
1217 -- HISTORY
1218 --
1219 -- ========================================================
1220 PROCEDURE Update_Row(
1221 p_list_entry_id NUMBER,
1222 p_list_header_id NUMBER,
1223 p_last_update_date DATE,
1224 p_last_updated_by NUMBER,
1225 p_creation_date DATE,
1226 p_created_by NUMBER,
1227 p_last_update_login NUMBER,
1228 p_object_version_number NUMBER,
1229 p_list_select_action_id NUMBER,
1230 p_arc_list_select_action_from VARCHAR2,
1231 p_list_select_action_from_name VARCHAR2,
1232 p_source_code VARCHAR2,
1233 p_arc_list_used_by_source VARCHAR2,
1234 p_source_code_for_id NUMBER,
1235 p_pin_code VARCHAR2,
1236 p_list_entry_source_system_id NUMBER,
1237 p_list_entry_source_system_tp VARCHAR2,
1238 p_view_application_id NUMBER,
1239 p_manually_entered_flag VARCHAR2,
1240 p_marked_as_duplicate_flag VARCHAR2,
1241 p_marked_as_random_flag VARCHAR2,
1242 p_part_of_control_group_flag VARCHAR2,
1243 p_exclude_in_triggered_list_fg VARCHAR2,
1244 p_enabled_flag VARCHAR2,
1245 p_cell_code VARCHAR2,
1246 p_dedupe_key VARCHAR2,
1247 p_randomly_generated_number NUMBER,
1251 p_channel_schedule_id NUMBER,
1248 p_campaign_id NUMBER,
1249 p_media_id NUMBER,
1250 p_channel_id NUMBER,
1252 p_event_offer_id NUMBER,
1253 p_customer_id NUMBER,
1254 p_market_segment_id NUMBER,
1255 p_vendor_id NUMBER,
1256 p_transfer_flag VARCHAR2,
1257 p_transfer_status VARCHAR2,
1258 p_list_source VARCHAR2,
1259 p_duplicate_master_entry_id NUMBER,
1260 p_marked_flag VARCHAR2,
1261 p_lead_id NUMBER,
1262 p_letter_id NUMBER,
1263 p_picking_header_id NUMBER,
1264 p_batch_id NUMBER,
1265 p_suffix VARCHAR2,
1266 p_first_name VARCHAR2,
1267 p_last_name VARCHAR2,
1268 p_customer_name VARCHAR2,
1269 p_title VARCHAR2,
1270 p_address_line1 VARCHAR2,
1271 p_address_line2 VARCHAR2,
1272 p_city VARCHAR2,
1273 p_state VARCHAR2,
1274 p_zipcode VARCHAR2,
1275 p_country VARCHAR2,
1276 p_fax VARCHAR2,
1277 p_phone VARCHAR2,
1278 p_email_address VARCHAR2,
1279 p_col1 VARCHAR2,
1280 p_col2 VARCHAR2,
1281 p_col3 VARCHAR2,
1282 p_col4 VARCHAR2,
1283 p_col5 VARCHAR2,
1284 p_col6 VARCHAR2,
1285 p_col7 VARCHAR2,
1286 p_col8 VARCHAR2,
1287 p_col9 VARCHAR2,
1288 p_col10 VARCHAR2,
1289 p_col11 VARCHAR2,
1290 p_col12 VARCHAR2,
1291 p_col13 VARCHAR2,
1292 p_col14 VARCHAR2,
1293 p_col15 VARCHAR2,
1294 p_col16 VARCHAR2,
1295 p_col17 VARCHAR2,
1296 p_col18 VARCHAR2,
1297 p_col19 VARCHAR2,
1298 p_col20 VARCHAR2,
1299 p_col21 VARCHAR2,
1300 p_col22 VARCHAR2,
1301 p_col23 VARCHAR2,
1302 p_col24 VARCHAR2,
1303 p_col25 VARCHAR2,
1304 p_col26 VARCHAR2,
1305 p_col27 VARCHAR2,
1306 p_col28 VARCHAR2,
1307 p_col29 VARCHAR2,
1308 p_col30 VARCHAR2,
1309 p_col31 VARCHAR2,
1310 p_col32 VARCHAR2,
1311 p_col33 VARCHAR2,
1312 p_col34 VARCHAR2,
1313 p_col35 VARCHAR2,
1314 p_col36 VARCHAR2,
1315 p_col37 VARCHAR2,
1316 p_col38 VARCHAR2,
1317 p_col39 VARCHAR2,
1318 p_col40 VARCHAR2,
1319 p_col41 VARCHAR2,
1320 p_col42 VARCHAR2,
1321 p_col43 VARCHAR2,
1322 p_col44 VARCHAR2,
1323 p_col45 VARCHAR2,
1324 p_col46 VARCHAR2,
1325 p_col47 VARCHAR2,
1326 p_col48 VARCHAR2,
1327 p_col49 VARCHAR2,
1328 p_col50 VARCHAR2,
1329 p_col51 VARCHAR2,
1330 p_col52 VARCHAR2,
1331 p_col53 VARCHAR2,
1332 p_col54 VARCHAR2,
1333 p_col55 VARCHAR2,
1334 p_col56 VARCHAR2,
1335 p_col57 VARCHAR2,
1336 p_col58 VARCHAR2,
1337 p_col59 VARCHAR2,
1338 p_col60 VARCHAR2,
1339 p_col61 VARCHAR2,
1340 p_col62 VARCHAR2,
1341 p_col63 VARCHAR2,
1342 p_col64 VARCHAR2,
1343 p_col65 VARCHAR2,
1344 p_col66 VARCHAR2,
1345 p_col67 VARCHAR2,
1346 p_col68 VARCHAR2,
1347 p_col69 VARCHAR2,
1348 p_col70 VARCHAR2,
1349 p_col71 VARCHAR2,
1350 p_col72 VARCHAR2,
1351 p_col73 VARCHAR2,
1352 p_col74 VARCHAR2,
1353 p_col75 VARCHAR2,
1354 p_col76 VARCHAR2,
1355 p_col77 VARCHAR2,
1356 p_col78 VARCHAR2,
1357 p_col79 VARCHAR2,
1358 p_col80 VARCHAR2,
1359 p_col81 VARCHAR2,
1360 p_col82 VARCHAR2,
1361 p_col83 VARCHAR2,
1362 p_col84 VARCHAR2,
1363 p_col85 VARCHAR2,
1364 p_col86 VARCHAR2,
1365 p_col87 VARCHAR2,
1366 p_col88 VARCHAR2,
1367 p_col89 VARCHAR2,
1368 p_col90 VARCHAR2,
1369 p_col91 VARCHAR2,
1370 p_col92 VARCHAR2,
1371 p_col93 VARCHAR2,
1372 p_col94 VARCHAR2,
1373 p_col95 VARCHAR2,
1374 p_col96 VARCHAR2,
1375 p_col97 VARCHAR2,
1376 p_col98 VARCHAR2,
1377 p_col99 VARCHAR2,
1378 p_col100 VARCHAR2,
1379 p_col101 VARCHAR2,
1380 p_col102 VARCHAR2,
1381 p_col103 VARCHAR2,
1382 p_col104 VARCHAR2,
1383 p_col105 VARCHAR2,
1384 p_col106 VARCHAR2,
1385 p_col107 VARCHAR2,
1386 p_col108 VARCHAR2,
1387 p_col109 VARCHAR2,
1388 p_col110 VARCHAR2,
1389 p_col111 VARCHAR2,
1390 p_col112 VARCHAR2,
1391 p_col113 VARCHAR2,
1392 p_col114 VARCHAR2,
1393 p_col115 VARCHAR2,
1394 p_col116 VARCHAR2,
1395 p_col117 VARCHAR2,
1396 p_col118 VARCHAR2,
1397 p_col119 VARCHAR2,
1401 p_col123 VARCHAR2,
1398 p_col120 VARCHAR2,
1399 p_col121 VARCHAR2,
1400 p_col122 VARCHAR2,
1402 p_col124 VARCHAR2,
1403 p_col125 VARCHAR2,
1404 p_col126 VARCHAR2,
1405 p_col127 VARCHAR2,
1406 p_col128 VARCHAR2,
1407 p_col129 VARCHAR2,
1408 p_col130 VARCHAR2,
1409 p_col131 VARCHAR2,
1410 p_col132 VARCHAR2,
1411 p_col133 VARCHAR2,
1412 p_col134 VARCHAR2,
1413 p_col135 VARCHAR2,
1414 p_col136 VARCHAR2,
1415 p_col137 VARCHAR2,
1416 p_col138 VARCHAR2,
1417 p_col139 VARCHAR2,
1418 p_col140 VARCHAR2,
1419 p_col141 VARCHAR2,
1420 p_col142 VARCHAR2,
1421 p_col143 VARCHAR2,
1422 p_col144 VARCHAR2,
1423 p_col145 VARCHAR2,
1424 p_col146 VARCHAR2,
1425 p_col147 VARCHAR2,
1426 p_col148 VARCHAR2,
1427 p_col149 VARCHAR2,
1428 p_col150 VARCHAR2,
1429 p_col151 VARCHAR2,
1430 p_col152 VARCHAR2,
1431 p_col153 VARCHAR2,
1432 p_col154 VARCHAR2,
1433 p_col155 VARCHAR2,
1434 p_col156 VARCHAR2,
1435 p_col157 VARCHAR2,
1436 p_col158 VARCHAR2,
1437 p_col159 VARCHAR2,
1438 p_col160 VARCHAR2,
1439 p_col161 VARCHAR2,
1440 p_col162 VARCHAR2,
1441 p_col163 VARCHAR2,
1442 p_col164 VARCHAR2,
1443 p_col165 VARCHAR2,
1444 p_col166 VARCHAR2,
1445 p_col167 VARCHAR2,
1446 p_col168 VARCHAR2,
1447 p_col169 VARCHAR2,
1448 p_col170 VARCHAR2,
1449 p_col171 VARCHAR2,
1450 p_col172 VARCHAR2,
1451 p_col173 VARCHAR2,
1452 p_col174 VARCHAR2,
1453 p_col175 VARCHAR2,
1454 p_col176 VARCHAR2,
1455 p_col177 VARCHAR2,
1456 p_col178 VARCHAR2,
1457 p_col179 VARCHAR2,
1458 p_col180 VARCHAR2,
1459 p_col181 VARCHAR2,
1460 p_col182 VARCHAR2,
1461 p_col183 VARCHAR2,
1462 p_col184 VARCHAR2,
1463 p_col185 VARCHAR2,
1464 p_col186 VARCHAR2,
1465 p_col187 VARCHAR2,
1466 p_col188 VARCHAR2,
1467 p_col189 VARCHAR2,
1468 p_col190 VARCHAR2,
1469 p_col191 VARCHAR2,
1470 p_col192 VARCHAR2,
1471 p_col193 VARCHAR2,
1472 p_col194 VARCHAR2,
1473 p_col195 VARCHAR2,
1474 p_col196 VARCHAR2,
1475 p_col197 VARCHAR2,
1476 p_col198 VARCHAR2,
1477 p_col199 VARCHAR2,
1478 p_col200 VARCHAR2,
1479 p_col201 VARCHAR2,
1480 p_col202 VARCHAR2,
1481 p_col203 VARCHAR2,
1482 p_col204 VARCHAR2,
1483 p_col205 VARCHAR2,
1484 p_col206 VARCHAR2,
1485 p_col207 VARCHAR2,
1486 p_col208 VARCHAR2,
1487 p_col209 VARCHAR2,
1488 p_col210 VARCHAR2,
1489 p_col211 VARCHAR2,
1490 p_col212 VARCHAR2,
1491 p_col213 VARCHAR2,
1492 p_col214 VARCHAR2,
1493 p_col215 VARCHAR2,
1494 p_col216 VARCHAR2,
1495 p_col217 VARCHAR2,
1496 p_col218 VARCHAR2,
1497 p_col219 VARCHAR2,
1498 p_col220 VARCHAR2,
1499 p_col221 VARCHAR2,
1500 p_col222 VARCHAR2,
1501 p_col223 VARCHAR2,
1502 p_col224 VARCHAR2,
1503 p_col225 VARCHAR2,
1504 p_col226 VARCHAR2,
1505 p_col227 VARCHAR2,
1506 p_col228 VARCHAR2,
1507 p_col229 VARCHAR2,
1508 p_col230 VARCHAR2,
1509 p_col231 VARCHAR2,
1510 p_col232 VARCHAR2,
1511 p_col233 VARCHAR2,
1512 p_col234 VARCHAR2,
1513 p_col235 VARCHAR2,
1514 p_col236 VARCHAR2,
1515 p_col237 VARCHAR2,
1516 p_col238 VARCHAR2,
1517 p_col239 VARCHAR2,
1518 p_col240 VARCHAR2,
1519 p_col241 VARCHAR2,
1520 p_col242 VARCHAR2,
1521 p_col243 VARCHAR2,
1522 p_col244 VARCHAR2,
1523 p_col245 VARCHAR2,
1524 p_col246 VARCHAR2,
1525 p_col247 VARCHAR2,
1526 p_col248 VARCHAR2,
1527 p_col249 VARCHAR2,
1528 p_col250 VARCHAR2,
1529 p_col251 VARCHAR2,
1530 p_col252 VARCHAR2,
1531 p_col253 VARCHAR2,
1532 p_col254 VARCHAR2,
1533 p_col255 VARCHAR2,
1534 p_col256 VARCHAR2,
1535 p_col257 VARCHAR2,
1536 p_col258 VARCHAR2,
1537 p_col259 VARCHAR2,
1538 p_col260 VARCHAR2,
1539 p_col261 VARCHAR2,
1540 p_col262 VARCHAR2,
1541 p_col263 VARCHAR2,
1542 p_col264 VARCHAR2,
1543 p_col265 VARCHAR2,
1544 p_col266 VARCHAR2,
1545 p_col267 VARCHAR2,
1546 p_col268 VARCHAR2,
1547 p_col269 VARCHAR2,
1548 p_col270 VARCHAR2,
1549 p_col271 VARCHAR2,
1550 p_col272 VARCHAR2,
1551 p_col273 VARCHAR2,
1552 p_col274 VARCHAR2,
1556 p_col278 VARCHAR2,
1553 p_col275 VARCHAR2,
1554 p_col276 VARCHAR2,
1555 p_col277 VARCHAR2,
1557 p_col279 VARCHAR2,
1558 p_col280 VARCHAR2,
1559 p_col281 VARCHAR2,
1560 p_col282 VARCHAR2,
1561 p_col283 VARCHAR2,
1562 p_col284 VARCHAR2,
1563 p_col285 VARCHAR2,
1564 p_col286 VARCHAR2,
1565 p_col287 VARCHAR2,
1566 p_col288 VARCHAR2,
1567 p_col289 VARCHAR2,
1568 p_col290 VARCHAR2,
1569 p_col291 VARCHAR2,
1570 p_col292 VARCHAR2,
1571 p_col293 VARCHAR2,
1572 p_col294 VARCHAR2,
1573 p_col295 VARCHAR2,
1574 p_col296 VARCHAR2,
1575 p_col297 VARCHAR2,
1576 p_col298 VARCHAR2,
1577 p_col299 VARCHAR2,
1578 p_col300 VARCHAR2,
1579 p_party_id NUMBER,
1580 p_parent_party_id NUMBER,
1581 --p_geometry SDO_GEOMETRY,
1582 p_imp_source_line_id NUMBER,
1583 p_usage_restriction VARCHAR2,
1584 p_next_call_time DATE,
1585 p_callback_flag VARCHAR2,
1586 p_do_not_use_flag VARCHAR2,
1587 p_do_not_use_reason VARCHAR2,
1588 p_record_out_flag VARCHAR2,
1589 p_record_release_time DATE,
1590 p_group_code VARCHAR2,
1591 p_newly_updated_flag VARCHAR2,
1592 p_outcome_id number,
1593 p_result_id number,
1594 p_reason_id number,
1595 p_notes varchar2,
1596 p_VEHICLE_RESPONSE_CODE varchar2,
1597 p_SALES_AGENT_EMAIL_ADDRESS varchar2,
1598 p_RESOURCE_ID number,
1599 p_LOCATION_ID NUMBER,
1600 p_CONTACT_POINT_ID NUMBER,
1601 p_last_contacted_date DATE
1602 )
1603
1604 IS
1605 BEGIN
1606 Update AMS_LIST_ENTRIES
1607 SET
1608 list_entry_id = DECODE( p_list_entry_id, FND_API.g_miss_num, list_entry_id, p_list_entry_id),
1609 list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
1610 last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
1611 last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
1612 creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
1613 created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
1614 last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
1615 object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
1616 list_select_action_id = DECODE( p_list_select_action_id, FND_API.g_miss_num, list_select_action_id, p_list_select_action_id),
1617 arc_list_select_action_from = DECODE( p_arc_list_select_action_from, FND_API.g_miss_char, arc_list_select_action_from, p_arc_list_select_action_from),
1618 list_select_action_from_name = DECODE( p_list_select_action_from_name, FND_API.g_miss_char, list_select_action_from_name, p_list_select_action_from_name),
1619 source_code = DECODE( p_source_code, FND_API.g_miss_char, source_code, p_source_code),
1620 arc_list_used_by_source = DECODE( p_arc_list_used_by_source, FND_API.g_miss_char, arc_list_used_by_source, p_arc_list_used_by_source),
1621 source_code_for_id = DECODE( p_source_code_for_id, FND_API.g_miss_num, source_code_for_id, p_source_code_for_id),
1622 pin_code = DECODE( p_pin_code, FND_API.g_miss_char, pin_code, p_pin_code),
1623 list_entry_source_system_id = DECODE( p_list_entry_source_system_id, FND_API.g_miss_num, list_entry_source_system_id, p_list_entry_source_system_id),
1624 list_entry_source_system_type = DECODE( p_list_entry_source_system_tp, FND_API.g_miss_char, list_entry_source_system_type, p_list_entry_source_system_tp),
1625 view_application_id = DECODE( p_view_application_id, FND_API.g_miss_num, view_application_id, p_view_application_id),
1626 manually_entered_flag = DECODE( p_manually_entered_flag, FND_API.g_miss_char, manually_entered_flag, p_manually_entered_flag),
1627 marked_as_duplicate_flag = DECODE( p_marked_as_duplicate_flag, FND_API.g_miss_char, marked_as_duplicate_flag, p_marked_as_duplicate_flag),
1628 marked_as_random_flag = DECODE( p_marked_as_random_flag, FND_API.g_miss_char, marked_as_random_flag, p_marked_as_random_flag),
1629 part_of_control_group_flag = DECODE( p_part_of_control_group_flag, FND_API.g_miss_char, part_of_control_group_flag, p_part_of_control_group_flag),
1630 exclude_in_triggered_list_flag = DECODE( p_exclude_in_triggered_list_fg, FND_API.g_miss_char, exclude_in_triggered_list_flag, p_exclude_in_triggered_list_fg),
1631 enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
1632 cell_code = DECODE( p_cell_code, FND_API.g_miss_char, cell_code, p_cell_code),
1633 dedupe_key = DECODE( p_dedupe_key, FND_API.g_miss_char, dedupe_key, p_dedupe_key),
1634 randomly_generated_number = DECODE( p_randomly_generated_number, FND_API.g_miss_num, randomly_generated_number, p_randomly_generated_number),
1635 campaign_id = DECODE( p_campaign_id, FND_API.g_miss_num, campaign_id, p_campaign_id),
1636 media_id = DECODE( p_media_id, FND_API.g_miss_num, media_id, p_media_id),
1637 channel_id = DECODE( p_channel_id, FND_API.g_miss_num, channel_id, p_channel_id),
1638 channel_schedule_id = DECODE( p_channel_schedule_id, FND_API.g_miss_num, channel_schedule_id, p_channel_schedule_id),
1639 event_offer_id = DECODE( p_event_offer_id, FND_API.g_miss_num, event_offer_id, p_event_offer_id),
1640 customer_id = DECODE( p_customer_id, FND_API.g_miss_num, customer_id, p_customer_id),
1644 transfer_status = DECODE( p_transfer_status, FND_API.g_miss_char, transfer_status, p_transfer_status),
1641 market_segment_id = DECODE( p_market_segment_id, FND_API.g_miss_num, market_segment_id, p_market_segment_id),
1642 vendor_id = DECODE( p_vendor_id, FND_API.g_miss_num, vendor_id, p_vendor_id),
1643 transfer_flag = DECODE( p_transfer_flag, FND_API.g_miss_char, transfer_flag, p_transfer_flag),
1645 list_source = DECODE( p_list_source, FND_API.g_miss_char, list_source, p_list_source),
1646 duplicate_master_entry_id = DECODE( p_duplicate_master_entry_id, FND_API.g_miss_num, duplicate_master_entry_id, p_duplicate_master_entry_id),
1647 marked_flag = DECODE( p_marked_flag, FND_API.g_miss_char, marked_flag, p_marked_flag),
1648 lead_id = DECODE( p_lead_id, FND_API.g_miss_num, lead_id, p_lead_id),
1649 letter_id = DECODE( p_letter_id, FND_API.g_miss_num, letter_id, p_letter_id),
1650 picking_header_id = DECODE( p_picking_header_id, FND_API.g_miss_num, picking_header_id, p_picking_header_id),
1651 batch_id = DECODE( p_batch_id, FND_API.g_miss_num, batch_id, p_batch_id),
1652 suffix = DECODE( p_suffix, FND_API.g_miss_char, suffix, p_suffix),
1653 first_name = DECODE( p_first_name, FND_API.g_miss_char, first_name, p_first_name),
1654 last_name = DECODE( p_last_name, FND_API.g_miss_char, last_name, p_last_name),
1655 customer_name = DECODE( p_customer_name, FND_API.g_miss_char, customer_name, p_customer_name),
1656 title = DECODE( p_title, FND_API.g_miss_char, title, p_title),
1657 address_line1 = DECODE( p_address_line1, FND_API.g_miss_char, address_line1, p_address_line1),
1658 address_line2 = DECODE( p_address_line2, FND_API.g_miss_char, address_line2, p_address_line2),
1659 city = DECODE( p_city, FND_API.g_miss_char, city, p_city),
1660 state = DECODE( p_state, FND_API.g_miss_char, state, p_state),
1661 zipcode = DECODE( p_zipcode, FND_API.g_miss_char, zipcode, p_zipcode),
1662 country = DECODE( p_country, FND_API.g_miss_char, country, p_country),
1663 fax = DECODE( p_fax, FND_API.g_miss_char, fax, p_fax),
1664 phone = DECODE( p_phone, FND_API.g_miss_char, phone, p_phone),
1665 email_address = DECODE( p_email_address, FND_API.g_miss_char, email_address, p_email_address),
1666 col1 = DECODE( p_col1, FND_API.g_miss_char, col1, p_col1),
1667 col2 = DECODE( p_col2, FND_API.g_miss_char, col2, p_col2),
1668 col3 = DECODE( p_col3, FND_API.g_miss_char, col3, p_col3),
1669 col4 = DECODE( p_col4, FND_API.g_miss_char, col4, p_col4),
1670 col5 = DECODE( p_col5, FND_API.g_miss_char, col5, p_col5),
1671 col6 = DECODE( p_col6, FND_API.g_miss_char, col6, p_col6),
1672 col7 = DECODE( p_col7, FND_API.g_miss_char, col7, p_col7),
1673 col8 = DECODE( p_col8, FND_API.g_miss_char, col8, p_col8),
1674 col9 = DECODE( p_col9, FND_API.g_miss_char, col9, p_col9),
1675 col10 = DECODE( p_col10, FND_API.g_miss_char, col10, p_col10),
1676 col11 = DECODE( p_col11, FND_API.g_miss_char, col11, p_col11),
1677 col12 = DECODE( p_col12, FND_API.g_miss_char, col12, p_col12),
1678 col13 = DECODE( p_col13, FND_API.g_miss_char, col13, p_col13),
1679 col14 = DECODE( p_col14, FND_API.g_miss_char, col14, p_col14),
1680 col15 = DECODE( p_col15, FND_API.g_miss_char, col15, p_col15),
1681 col16 = DECODE( p_col16, FND_API.g_miss_char, col16, p_col16),
1682 col17 = DECODE( p_col17, FND_API.g_miss_char, col17, p_col17),
1683 col18 = DECODE( p_col18, FND_API.g_miss_char, col18, p_col18),
1684 col19 = DECODE( p_col19, FND_API.g_miss_char, col19, p_col19),
1685 col20 = DECODE( p_col20, FND_API.g_miss_char, col20, p_col20),
1686 col21 = DECODE( p_col21, FND_API.g_miss_char, col21, p_col21),
1687 col22 = DECODE( p_col22, FND_API.g_miss_char, col22, p_col22),
1688 col23 = DECODE( p_col23, FND_API.g_miss_char, col23, p_col23),
1689 col24 = DECODE( p_col24, FND_API.g_miss_char, col24, p_col24),
1690 col25 = DECODE( p_col25, FND_API.g_miss_char, col25, p_col25),
1691 col26 = DECODE( p_col26, FND_API.g_miss_char, col26, p_col26),
1692 col27 = DECODE( p_col27, FND_API.g_miss_char, col27, p_col27),
1693 col28 = DECODE( p_col28, FND_API.g_miss_char, col28, p_col28),
1694 col29 = DECODE( p_col29, FND_API.g_miss_char, col29, p_col29),
1695 col30 = DECODE( p_col30, FND_API.g_miss_char, col30, p_col30),
1696 col31 = DECODE( p_col31, FND_API.g_miss_char, col31, p_col31),
1697 col32 = DECODE( p_col32, FND_API.g_miss_char, col32, p_col32),
1698 col33 = DECODE( p_col33, FND_API.g_miss_char, col33, p_col33),
1699 col34 = DECODE( p_col34, FND_API.g_miss_char, col34, p_col34),
1700 col35 = DECODE( p_col35, FND_API.g_miss_char, col35, p_col35),
1701 col36 = DECODE( p_col36, FND_API.g_miss_char, col36, p_col36),
1702 col37 = DECODE( p_col37, FND_API.g_miss_char, col37, p_col37),
1703 col38 = DECODE( p_col38, FND_API.g_miss_char, col38, p_col38),
1704 col39 = DECODE( p_col39, FND_API.g_miss_char, col39, p_col39),
1705 col40 = DECODE( p_col40, FND_API.g_miss_char, col40, p_col40),
1706 col41 = DECODE( p_col41, FND_API.g_miss_char, col41, p_col41),
1707 col42 = DECODE( p_col42, FND_API.g_miss_char, col42, p_col42),
1708 col43 = DECODE( p_col43, FND_API.g_miss_char, col43, p_col43),
1709 col44 = DECODE( p_col44, FND_API.g_miss_char, col44, p_col44),
1710 col45 = DECODE( p_col45, FND_API.g_miss_char, col45, p_col45),
1711 col46 = DECODE( p_col46, FND_API.g_miss_char, col46, p_col46),
1712 col47 = DECODE( p_col47, FND_API.g_miss_char, col47, p_col47),
1713 col48 = DECODE( p_col48, FND_API.g_miss_char, col48, p_col48),
1717 col52 = DECODE( p_col52, FND_API.g_miss_char, col52, p_col52),
1714 col49 = DECODE( p_col49, FND_API.g_miss_char, col49, p_col49),
1715 col50 = DECODE( p_col50, FND_API.g_miss_char, col50, p_col50),
1716 col51 = DECODE( p_col51, FND_API.g_miss_char, col51, p_col51),
1718 col53 = DECODE( p_col53, FND_API.g_miss_char, col53, p_col53),
1719 col54 = DECODE( p_col54, FND_API.g_miss_char, col54, p_col54),
1720 col55 = DECODE( p_col55, FND_API.g_miss_char, col55, p_col55),
1721 col56 = DECODE( p_col56, FND_API.g_miss_char, col56, p_col56),
1722 col57 = DECODE( p_col57, FND_API.g_miss_char, col57, p_col57),
1723 col58 = DECODE( p_col58, FND_API.g_miss_char, col58, p_col58),
1724 col59 = DECODE( p_col59, FND_API.g_miss_char, col59, p_col59),
1725 col60 = DECODE( p_col60, FND_API.g_miss_char, col60, p_col60),
1726 col61 = DECODE( p_col61, FND_API.g_miss_char, col61, p_col61),
1727 col62 = DECODE( p_col62, FND_API.g_miss_char, col62, p_col62),
1728 col63 = DECODE( p_col63, FND_API.g_miss_char, col63, p_col63),
1729 col64 = DECODE( p_col64, FND_API.g_miss_char, col64, p_col64),
1730 col65 = DECODE( p_col65, FND_API.g_miss_char, col65, p_col65),
1731 col66 = DECODE( p_col66, FND_API.g_miss_char, col66, p_col66),
1732 col67 = DECODE( p_col67, FND_API.g_miss_char, col67, p_col67),
1733 col68 = DECODE( p_col68, FND_API.g_miss_char, col68, p_col68),
1734 col69 = DECODE( p_col69, FND_API.g_miss_char, col69, p_col69),
1735 col70 = DECODE( p_col70, FND_API.g_miss_char, col70, p_col70),
1736 col71 = DECODE( p_col71, FND_API.g_miss_char, col71, p_col71),
1737 col72 = DECODE( p_col72, FND_API.g_miss_char, col72, p_col72),
1738 col73 = DECODE( p_col73, FND_API.g_miss_char, col73, p_col73),
1739 col74 = DECODE( p_col74, FND_API.g_miss_char, col74, p_col74),
1740 col75 = DECODE( p_col75, FND_API.g_miss_char, col75, p_col75),
1741 col76 = DECODE( p_col76, FND_API.g_miss_char, col76, p_col76),
1742 col77 = DECODE( p_col77, FND_API.g_miss_char, col77, p_col77),
1743 col78 = DECODE( p_col78, FND_API.g_miss_char, col78, p_col78),
1744 col79 = DECODE( p_col79, FND_API.g_miss_char, col79, p_col79),
1745 col80 = DECODE( p_col80, FND_API.g_miss_char, col80, p_col80),
1746 col81 = DECODE( p_col81, FND_API.g_miss_char, col81, p_col81),
1747 col82 = DECODE( p_col82, FND_API.g_miss_char, col82, p_col82),
1748 col83 = DECODE( p_col83, FND_API.g_miss_char, col83, p_col83),
1749 col84 = DECODE( p_col84, FND_API.g_miss_char, col84, p_col84),
1750 col85 = DECODE( p_col85, FND_API.g_miss_char, col85, p_col85),
1751 col86 = DECODE( p_col86, FND_API.g_miss_char, col86, p_col86),
1752 col87 = DECODE( p_col87, FND_API.g_miss_char, col87, p_col87),
1753 col88 = DECODE( p_col88, FND_API.g_miss_char, col88, p_col88),
1754 col89 = DECODE( p_col89, FND_API.g_miss_char, col89, p_col89),
1755 col90 = DECODE( p_col90, FND_API.g_miss_char, col90, p_col90),
1756 col91 = DECODE( p_col91, FND_API.g_miss_char, col91, p_col91),
1757 col92 = DECODE( p_col92, FND_API.g_miss_char, col92, p_col92),
1758 col93 = DECODE( p_col93, FND_API.g_miss_char, col93, p_col93),
1759 col94 = DECODE( p_col94, FND_API.g_miss_char, col94, p_col94),
1760 col95 = DECODE( p_col95, FND_API.g_miss_char, col95, p_col95),
1761 col96 = DECODE( p_col96, FND_API.g_miss_char, col96, p_col96),
1762 col97 = DECODE( p_col97, FND_API.g_miss_char, col97, p_col97),
1763 col98 = DECODE( p_col98, FND_API.g_miss_char, col98, p_col98),
1764 col99 = DECODE( p_col99, FND_API.g_miss_char, col99, p_col99),
1765 col100 = DECODE( p_col100, FND_API.g_miss_char, col100, p_col100),
1766 col101 = DECODE( p_col101, FND_API.g_miss_char, col101, p_col101),
1767 col102 = DECODE( p_col102, FND_API.g_miss_char, col102, p_col102),
1768 col103 = DECODE( p_col103, FND_API.g_miss_char, col103, p_col103),
1769 col104 = DECODE( p_col104, FND_API.g_miss_char, col104, p_col104),
1770 col105 = DECODE( p_col105, FND_API.g_miss_char, col105, p_col105),
1771 col106 = DECODE( p_col106, FND_API.g_miss_char, col106, p_col106),
1772 col107 = DECODE( p_col107, FND_API.g_miss_char, col107, p_col107),
1773 col108 = DECODE( p_col108, FND_API.g_miss_char, col108, p_col108),
1774 col109 = DECODE( p_col109, FND_API.g_miss_char, col109, p_col109),
1775 col110 = DECODE( p_col110, FND_API.g_miss_char, col110, p_col110),
1776 col111 = DECODE( p_col111, FND_API.g_miss_char, col111, p_col111),
1777 col112 = DECODE( p_col112, FND_API.g_miss_char, col112, p_col112),
1778 col113 = DECODE( p_col113, FND_API.g_miss_char, col113, p_col113),
1779 col114 = DECODE( p_col114, FND_API.g_miss_char, col114, p_col114),
1780 col115 = DECODE( p_col115, FND_API.g_miss_char, col115, p_col115),
1781 col116 = DECODE( p_col116, FND_API.g_miss_char, col116, p_col116),
1782 col117 = DECODE( p_col117, FND_API.g_miss_char, col117, p_col117),
1783 col118 = DECODE( p_col118, FND_API.g_miss_char, col118, p_col118),
1784 col119 = DECODE( p_col119, FND_API.g_miss_char, col119, p_col119),
1785 col120 = DECODE( p_col120, FND_API.g_miss_char, col120, p_col120),
1786 col121 = DECODE( p_col121, FND_API.g_miss_char, col121, p_col121),
1787 col122 = DECODE( p_col122, FND_API.g_miss_char, col122, p_col122),
1788 col123 = DECODE( p_col123, FND_API.g_miss_char, col123, p_col123),
1789 col124 = DECODE( p_col124, FND_API.g_miss_char, col124, p_col124),
1790 col125 = DECODE( p_col125, FND_API.g_miss_char, col125, p_col125),
1794 col129 = DECODE( p_col129, FND_API.g_miss_char, col129, p_col129),
1791 col126 = DECODE( p_col126, FND_API.g_miss_char, col126, p_col126),
1792 col127 = DECODE( p_col127, FND_API.g_miss_char, col127, p_col127),
1793 col128 = DECODE( p_col128, FND_API.g_miss_char, col128, p_col128),
1795 col130 = DECODE( p_col130, FND_API.g_miss_char, col130, p_col130),
1796 col131 = DECODE( p_col131, FND_API.g_miss_char, col131, p_col131),
1797 col132 = DECODE( p_col132, FND_API.g_miss_char, col132, p_col132),
1798 col133 = DECODE( p_col133, FND_API.g_miss_char, col133, p_col133),
1799 col134 = DECODE( p_col134, FND_API.g_miss_char, col134, p_col134),
1800 col135 = DECODE( p_col135, FND_API.g_miss_char, col135, p_col135),
1801 col136 = DECODE( p_col136, FND_API.g_miss_char, col136, p_col136),
1802 col137 = DECODE( p_col137, FND_API.g_miss_char, col137, p_col137),
1803 col138 = DECODE( p_col138, FND_API.g_miss_char, col138, p_col138),
1804 col139 = DECODE( p_col139, FND_API.g_miss_char, col139, p_col139),
1805 col140 = DECODE( p_col140, FND_API.g_miss_char, col140, p_col140),
1806 col141 = DECODE( p_col141, FND_API.g_miss_char, col141, p_col141),
1807 col142 = DECODE( p_col142, FND_API.g_miss_char, col142, p_col142),
1808 col143 = DECODE( p_col143, FND_API.g_miss_char, col143, p_col143),
1809 col144 = DECODE( p_col144, FND_API.g_miss_char, col144, p_col144),
1810 col145 = DECODE( p_col145, FND_API.g_miss_char, col145, p_col145),
1811 col146 = DECODE( p_col146, FND_API.g_miss_char, col146, p_col146),
1812 col147 = DECODE( p_col147, FND_API.g_miss_char, col147, p_col147),
1813 col148 = DECODE( p_col148, FND_API.g_miss_char, col148, p_col148),
1814 col149 = DECODE( p_col149, FND_API.g_miss_char, col149, p_col149),
1815 col150 = DECODE( p_col150, FND_API.g_miss_char, col150, p_col150),
1816 col151 = DECODE( p_col151, FND_API.g_miss_char, col151, p_col151),
1817 col152 = DECODE( p_col152, FND_API.g_miss_char, col152, p_col152),
1818 col153 = DECODE( p_col153, FND_API.g_miss_char, col153, p_col153),
1819 col154 = DECODE( p_col154, FND_API.g_miss_char, col154, p_col154),
1820 col155 = DECODE( p_col155, FND_API.g_miss_char, col155, p_col155),
1821 col156 = DECODE( p_col156, FND_API.g_miss_char, col156, p_col156),
1822 col157 = DECODE( p_col157, FND_API.g_miss_char, col157, p_col157),
1823 col158 = DECODE( p_col158, FND_API.g_miss_char, col158, p_col158),
1824 col159 = DECODE( p_col159, FND_API.g_miss_char, col159, p_col159),
1825 col160 = DECODE( p_col160, FND_API.g_miss_char, col160, p_col160),
1826 col161 = DECODE( p_col161, FND_API.g_miss_char, col161, p_col161),
1827 col162 = DECODE( p_col162, FND_API.g_miss_char, col162, p_col162),
1828 col163 = DECODE( p_col163, FND_API.g_miss_char, col163, p_col163),
1829 col164 = DECODE( p_col164, FND_API.g_miss_char, col164, p_col164),
1830 col165 = DECODE( p_col165, FND_API.g_miss_char, col165, p_col165),
1831 col166 = DECODE( p_col166, FND_API.g_miss_char, col166, p_col166),
1832 col167 = DECODE( p_col167, FND_API.g_miss_char, col167, p_col167),
1833 col168 = DECODE( p_col168, FND_API.g_miss_char, col168, p_col168),
1834 col169 = DECODE( p_col169, FND_API.g_miss_char, col169, p_col169),
1835 col170 = DECODE( p_col170, FND_API.g_miss_char, col170, p_col170),
1836 col171 = DECODE( p_col171, FND_API.g_miss_char, col171, p_col171),
1837 col172 = DECODE( p_col172, FND_API.g_miss_char, col172, p_col172),
1838 col173 = DECODE( p_col173, FND_API.g_miss_char, col173, p_col173),
1839 col174 = DECODE( p_col174, FND_API.g_miss_char, col174, p_col174),
1840 col175 = DECODE( p_col175, FND_API.g_miss_char, col175, p_col175),
1841 col176 = DECODE( p_col176, FND_API.g_miss_char, col176, p_col176),
1842 col177 = DECODE( p_col177, FND_API.g_miss_char, col177, p_col177),
1843 col178 = DECODE( p_col178, FND_API.g_miss_char, col178, p_col178),
1844 col179 = DECODE( p_col179, FND_API.g_miss_char, col179, p_col179),
1845 col180 = DECODE( p_col180, FND_API.g_miss_char, col180, p_col180),
1846 col181 = DECODE( p_col181, FND_API.g_miss_char, col181, p_col181),
1847 col182 = DECODE( p_col182, FND_API.g_miss_char, col182, p_col182),
1848 col183 = DECODE( p_col183, FND_API.g_miss_char, col183, p_col183),
1849 col184 = DECODE( p_col184, FND_API.g_miss_char, col184, p_col184),
1850 col185 = DECODE( p_col185, FND_API.g_miss_char, col185, p_col185),
1851 col186 = DECODE( p_col186, FND_API.g_miss_char, col186, p_col186),
1852 col187 = DECODE( p_col187, FND_API.g_miss_char, col187, p_col187),
1853 col188 = DECODE( p_col188, FND_API.g_miss_char, col188, p_col188),
1854 col189 = DECODE( p_col189, FND_API.g_miss_char, col189, p_col189),
1855 col190 = DECODE( p_col190, FND_API.g_miss_char, col190, p_col190),
1856 col191 = DECODE( p_col191, FND_API.g_miss_char, col191, p_col191),
1857 col192 = DECODE( p_col192, FND_API.g_miss_char, col192, p_col192),
1858 col193 = DECODE( p_col193, FND_API.g_miss_char, col193, p_col193),
1859 col194 = DECODE( p_col194, FND_API.g_miss_char, col194, p_col194),
1860 col195 = DECODE( p_col195, FND_API.g_miss_char, col195, p_col195),
1861 col196 = DECODE( p_col196, FND_API.g_miss_char, col196, p_col196),
1862 col197 = DECODE( p_col197, FND_API.g_miss_char, col197, p_col197),
1863 col198 = DECODE( p_col198, FND_API.g_miss_char, col198, p_col198),
1864 col199 = DECODE( p_col199, FND_API.g_miss_char, col199, p_col199),
1865 col200 = DECODE( p_col200, FND_API.g_miss_char, col200, p_col200),
1869 col204 = DECODE( p_col204, FND_API.g_miss_char, col204, p_col204),
1866 col201 = DECODE( p_col201, FND_API.g_miss_char, col201, p_col201),
1867 col202 = DECODE( p_col202, FND_API.g_miss_char, col202, p_col202),
1868 col203 = DECODE( p_col203, FND_API.g_miss_char, col203, p_col203),
1870 col205 = DECODE( p_col205, FND_API.g_miss_char, col205, p_col205),
1871 col206 = DECODE( p_col206, FND_API.g_miss_char, col206, p_col206),
1872 col207 = DECODE( p_col207, FND_API.g_miss_char, col207, p_col207),
1873 col208 = DECODE( p_col208, FND_API.g_miss_char, col208, p_col208),
1874 col209 = DECODE( p_col209, FND_API.g_miss_char, col209, p_col209),
1875 col210 = DECODE( p_col210, FND_API.g_miss_char, col210, p_col210),
1876 col211 = DECODE( p_col211, FND_API.g_miss_char, col211, p_col211),
1877 col212 = DECODE( p_col112, FND_API.g_miss_char, col212, p_col212),
1878 col213 = DECODE( p_col213, FND_API.g_miss_char, col213, p_col213),
1879 col214 = DECODE( p_col214, FND_API.g_miss_char, col214, p_col214),
1880 col215 = DECODE( p_col215, FND_API.g_miss_char, col215, p_col215),
1881 col216 = DECODE( p_col216, FND_API.g_miss_char, col216, p_col216),
1882 col217 = DECODE( p_col217, FND_API.g_miss_char, col217, p_col217),
1883 col218 = DECODE( p_col218, FND_API.g_miss_char, col218, p_col218),
1884 col219 = DECODE( p_col219, FND_API.g_miss_char, col219, p_col219),
1885 col220 = DECODE( p_col220, FND_API.g_miss_char, col220, p_col220),
1886 col221 = DECODE( p_col221, FND_API.g_miss_char, col221, p_col221),
1887 col222 = DECODE( p_col222, FND_API.g_miss_char, col222, p_col222),
1888 col223 = DECODE( p_col223, FND_API.g_miss_char, col223, p_col223),
1889 col224 = DECODE( p_col224, FND_API.g_miss_char, col224, p_col224),
1890 col225 = DECODE( p_col225, FND_API.g_miss_char, col225, p_col225),
1891 col226 = DECODE( p_col226, FND_API.g_miss_char, col226, p_col226),
1892 col227 = DECODE( p_col227, FND_API.g_miss_char, col227, p_col227),
1893 col228 = DECODE( p_col228, FND_API.g_miss_char, col228, p_col228),
1894 col229 = DECODE( p_col229, FND_API.g_miss_char, col229, p_col229),
1895 col230 = DECODE( p_col230, FND_API.g_miss_char, col230, p_col230),
1896 col231 = DECODE( p_col231, FND_API.g_miss_char, col231, p_col231),
1897 col232 = DECODE( p_col232, FND_API.g_miss_char, col232, p_col232),
1898 col233 = DECODE( p_col233, FND_API.g_miss_char, col233, p_col233),
1899 col234 = DECODE( p_col234, FND_API.g_miss_char, col234, p_col234),
1900 col235 = DECODE( p_col235, FND_API.g_miss_char, col235, p_col235),
1901 col236 = DECODE( p_col236, FND_API.g_miss_char, col236, p_col236),
1902 col237 = DECODE( p_col237, FND_API.g_miss_char, col237, p_col237),
1903 col238 = DECODE( p_col238, FND_API.g_miss_char, col238, p_col238),
1904 col239 = DECODE( p_col239, FND_API.g_miss_char, col239, p_col239),
1905 col240 = DECODE( p_col240, FND_API.g_miss_char, col240, p_col240),
1906 col241 = DECODE( p_col241, FND_API.g_miss_char, col241, p_col241),
1907 col242 = DECODE( p_col242, FND_API.g_miss_char, col242, p_col242),
1908 col243 = DECODE( p_col243, FND_API.g_miss_char, col243, p_col243),
1909 col244 = DECODE( p_col244, FND_API.g_miss_char, col244, p_col244),
1910 col245 = DECODE( p_col245, FND_API.g_miss_char, col245, p_col245),
1911 col246 = DECODE( p_col246, FND_API.g_miss_char, col246, p_col246),
1912 col247 = DECODE( p_col247, FND_API.g_miss_char, col247, p_col247),
1913 col248 = DECODE( p_col248, FND_API.g_miss_char, col248, p_col248),
1914 col249 = DECODE( p_col249, FND_API.g_miss_char, col249, p_col249),
1915 col250 = DECODE( p_col250, FND_API.g_miss_char, col250, p_col250),
1916 col251 = DECODE( p_col251, FND_API.g_miss_char, col251, p_col251),
1917 col252 = DECODE( p_col252, FND_API.g_miss_char, col252, p_col252),
1918 col253 = DECODE( p_col253, FND_API.g_miss_char, col253, p_col253),
1919 col254 = DECODE( p_col254, FND_API.g_miss_char, col254, p_col254),
1920 col255 = DECODE( p_col255, FND_API.g_miss_char, col255, p_col255),
1921 col256 = DECODE( p_col256, FND_API.g_miss_char, col256, p_col256),
1922 col257 = DECODE( p_col257, FND_API.g_miss_char, col257, p_col257),
1923 col258 = DECODE( p_col258, FND_API.g_miss_char, col258, p_col258),
1924 col259 = DECODE( p_col259, FND_API.g_miss_char, col259, p_col259),
1925 col260 = DECODE( p_col260, FND_API.g_miss_char, col260, p_col260),
1926 col261 = DECODE( p_col261, FND_API.g_miss_char, col261, p_col261),
1927 col262 = DECODE( p_col262, FND_API.g_miss_char, col262, p_col262),
1928 col263 = DECODE( p_col263, FND_API.g_miss_char, col263, p_col263),
1929 col264 = DECODE( p_col264, FND_API.g_miss_char, col264, p_col264),
1930 col265 = DECODE( p_col265, FND_API.g_miss_char, col265, p_col265),
1934 col269 = DECODE( p_col269, FND_API.g_miss_char, col269, p_col269),
1931 col266 = DECODE( p_col266, FND_API.g_miss_char, col266, p_col266),
1932 col267 = DECODE( p_col267, FND_API.g_miss_char, col267, p_col267),
1933 col268 = DECODE( p_col268, FND_API.g_miss_char, col268, p_col268),
1935 col270 = DECODE( p_col270, FND_API.g_miss_char, col270, p_col270),
1936 col271 = DECODE( p_col271, FND_API.g_miss_char, col271, p_col271),
1937 col272 = DECODE( p_col272, FND_API.g_miss_char, col272, p_col272),
1938 col273 = DECODE( p_col273, FND_API.g_miss_char, col273, p_col273),
1939 col274 = DECODE( p_col274, FND_API.g_miss_char, col274, p_col274),
1940 col275 = DECODE( p_col275, FND_API.g_miss_char, col275, p_col275),
1941 col276 = DECODE( p_col276, FND_API.g_miss_char, col276, p_col276),
1942 col277 = DECODE( p_col277, FND_API.g_miss_char, col277, p_col277),
1943 col278 = DECODE( p_col278, FND_API.g_miss_char, col278, p_col278),
1944 col279 = DECODE( p_col279, FND_API.g_miss_char, col279, p_col279),
1945 col280 = DECODE( p_col280, FND_API.g_miss_char, col280, p_col280),
1946 col281 = DECODE( p_col281, FND_API.g_miss_char, col281, p_col281),
1947 col282 = DECODE( p_col282, FND_API.g_miss_char, col282, p_col282),
1948 col283 = DECODE( p_col283, FND_API.g_miss_char, col283, p_col283),
1949 col284 = DECODE( p_col284, FND_API.g_miss_char, col284, p_col284),
1950 col285 = DECODE( p_col285, FND_API.g_miss_char, col285, p_col285),
1951 col286 = DECODE( p_col286, FND_API.g_miss_char, col286, p_col286),
1952 col287 = DECODE( p_col287, FND_API.g_miss_char, col287, p_col287),
1953 col288 = DECODE( p_col288, FND_API.g_miss_char, col288, p_col288),
1954 col289 = DECODE( p_col289, FND_API.g_miss_char, col289, p_col289),
1955 col290 = DECODE( p_col290, FND_API.g_miss_char, col290, p_col290),
1956 col291 = DECODE( p_col291, FND_API.g_miss_char, col291, p_col291),
1957 col292 = DECODE( p_col292, FND_API.g_miss_char, col292, p_col292),
1958 col293 = DECODE( p_col293, FND_API.g_miss_char, col293, p_col293),
1959 col294 = DECODE( p_col294, FND_API.g_miss_char, col294, p_col294),
1960 col295 = DECODE( p_col295, FND_API.g_miss_char, col295, p_col295),
1961 col296 = DECODE( p_col296, FND_API.g_miss_char, col296, p_col296),
1962 col297 = DECODE( p_col297, FND_API.g_miss_char, col297, p_col297),
1963 col298 = DECODE( p_col298, FND_API.g_miss_char, col298, p_col298),
1964 col299 = DECODE( p_col299, FND_API.g_miss_char, col299, p_col299),
1965 col300 = DECODE( p_col300, FND_API.g_miss_char, col300, p_col300),
1966 party_id = DECODE( p_party_id, FND_API.g_miss_num, party_id, p_party_id),
1967 parent_party_id = DECODE( p_parent_party_id, FND_API.g_miss_num, parent_party_id, p_parent_party_id),
1968 -- geometry = DECODE( p_geometry, FND_API.g_miss_char, geometry, p_geometry),
1969 imp_source_line_id = DECODE( p_imp_source_line_id, FND_API.g_miss_num, imp_source_line_id, p_imp_source_line_id),
1970 usage_restriction = DECODE( p_usage_restriction, FND_API.g_miss_char, usage_restriction, p_usage_restriction),
1971 next_call_time = DECODE( p_next_call_time, FND_API.g_miss_date, next_call_time, p_next_call_time),
1972 callback_flag = DECODE( p_callback_flag, FND_API.g_miss_char, callback_flag, p_callback_flag),
1973 do_not_use_flag = DECODE( p_do_not_use_flag, FND_API.g_miss_char, do_not_use_flag, p_do_not_use_flag),
1974 do_not_use_reason = DECODE( p_do_not_use_reason, FND_API.g_miss_char, do_not_use_reason, p_do_not_use_reason),
1975 record_out_flag = DECODE( p_record_out_flag, FND_API.g_miss_char, record_out_flag, p_record_out_flag),
1976 record_release_time = DECODE( p_record_release_time, FND_API.g_miss_date, record_release_time, p_record_release_time),
1977 group_code = DECODE( p_group_code, FND_API.g_miss_char, group_code, p_group_code),
1978 newly_updated_flag = DECODE( p_newly_updated_flag, FND_API.g_miss_char, newly_updated_flag, p_newly_updated_flag),
1979 outcome_id= DECODE( p_outcome_id, FND_API.g_miss_num, outcome_id, p_outcome_id),
1980 result_id= DECODE( p_result_id, FND_API.g_miss_num, result_id, p_result_id),
1981 reason_id= DECODE( p_reason_id, FND_API.g_miss_num, reason_id, p_reason_id),
1982 notes = DECODE( p_notes, FND_API.g_miss_char, notes, p_notes),
1983 VEHICLE_RESPONSE_CODE = DECODE( p_VEHICLE_RESPONSE_CODE, FND_API.g_miss_char, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),
1984 SALES_AGENT_EMAIL_ADDRESS = DECODE( p_SALES_AGENT_EMAIL_ADDRESS, FND_API.g_miss_char, SALES_AGENT_EMAIL_ADDRESS, p_SALES_AGENT_EMAIL_ADDRESS),
1985 resource_id= DECODE( p_resource_id, FND_API.g_miss_num, resource_id, p_resource_id),
1986 location_id= DECODE( p_location_id, FND_API.g_miss_num, location_id, p_location_id),
1987 contact_point_id= DECODE( p_contact_point_id, FND_API.g_miss_num, contact_point_id, p_contact_point_id),
1988 last_contacted_date = DECODE( p_last_contacted_date, FND_API.g_miss_date, last_contacted_date, p_last_contacted_date)
1989
1990 WHERE LIST_ENTRY_ID = p_LIST_ENTRY_ID
1991 AND object_version_number = p_object_version_number;
1992
1993 IF (SQL%NOTFOUND) THEN
1994 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1995 END IF;
1996 END Update_Row;
1997
1998
1999 ----------------------------------------------------------
2000 ---- MEDIA ----
2001 ----------------------------------------------------------
2002
2003 -- ========================================================
2007 --
2004 --
2005 -- NAME
2006 -- createDeleteBody
2008 -- PURPOSE
2009 --
2010 -- NOTES
2011 --
2012 -- HISTORY
2013 --
2014 -- ========================================================
2015 PROCEDURE Delete_Row(
2016 p_LIST_ENTRY_ID NUMBER)
2017 IS
2018 BEGIN
2019 DELETE FROM AMS_LIST_ENTRIES
2020 WHERE LIST_ENTRY_ID = p_LIST_ENTRY_ID;
2021 If (SQL%NOTFOUND) then
2022 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2023 End If;
2024 END Delete_Row ;
2025
2026
2027
2028 ----------------------------------------------------------
2029 ---- MEDIA ----
2030 ----------------------------------------------------------
2031
2032 -- ========================================================
2033 --
2034 -- NAME
2035 -- createLockBody
2036 --
2037 -- PURPOSE
2038 --
2039 -- NOTES
2040 --
2041 -- HISTORY
2042 --
2043 -- ========================================================
2044 PROCEDURE Lock_Row(
2045 p_list_entry_id NUMBER,
2046 p_list_header_id NUMBER,
2047 p_last_update_date DATE,
2048 p_last_updated_by NUMBER,
2049 p_creation_date DATE,
2050 p_created_by NUMBER,
2051 p_last_update_login NUMBER,
2052 p_object_version_number NUMBER,
2053 p_list_select_action_id NUMBER,
2054 p_arc_list_select_action_from VARCHAR2,
2055 p_list_select_action_from_name VARCHAR2,
2056 p_source_code VARCHAR2,
2057 p_arc_list_used_by_source VARCHAR2,
2058 p_source_code_for_id NUMBER,
2059 p_pin_code VARCHAR2,
2060 p_list_entry_source_system_id NUMBER,
2061 p_list_entry_source_system_tp VARCHAR2,
2062 p_view_application_id NUMBER,
2063 p_manually_entered_flag VARCHAR2,
2064 p_marked_as_duplicate_flag VARCHAR2,
2065 p_marked_as_random_flag VARCHAR2,
2066 p_part_of_control_group_flag VARCHAR2,
2067 p_exclude_in_triggered_list_fg VARCHAR2,
2068 p_enabled_flag VARCHAR2,
2069 p_cell_code VARCHAR2,
2070 p_dedupe_key VARCHAR2,
2071 p_randomly_generated_number NUMBER,
2072 p_campaign_id NUMBER,
2073 p_media_id NUMBER,
2074 p_channel_id NUMBER,
2075 p_channel_schedule_id NUMBER,
2076 p_event_offer_id NUMBER,
2077 p_customer_id NUMBER,
2078 p_market_segment_id NUMBER,
2079 p_vendor_id NUMBER,
2080 p_transfer_flag VARCHAR2,
2081 p_transfer_status VARCHAR2,
2082 p_list_source VARCHAR2,
2083 p_duplicate_master_entry_id NUMBER,
2084 p_marked_flag VARCHAR2,
2085 p_lead_id NUMBER,
2086 p_letter_id NUMBER,
2087 p_picking_header_id NUMBER,
2088 p_batch_id NUMBER,
2089 p_suffix VARCHAR2,
2090 p_first_name VARCHAR2,
2091 p_last_name VARCHAR2,
2092 p_customer_name VARCHAR2,
2093 p_title VARCHAR2,
2094 p_address_line1 VARCHAR2,
2095 p_address_line2 VARCHAR2,
2096 p_city VARCHAR2,
2097 p_state VARCHAR2,
2098 p_zipcode VARCHAR2,
2099 p_country VARCHAR2,
2100 p_fax VARCHAR2,
2101 p_phone VARCHAR2,
2102 p_email_address VARCHAR2,
2103 p_col1 VARCHAR2,
2104 p_col2 VARCHAR2,
2105 p_col3 VARCHAR2,
2106 p_col4 VARCHAR2,
2107 p_col5 VARCHAR2,
2108 p_col6 VARCHAR2,
2109 p_col7 VARCHAR2,
2110 p_col8 VARCHAR2,
2111 p_col9 VARCHAR2,
2112 p_col10 VARCHAR2,
2113 p_col11 VARCHAR2,
2114 p_col12 VARCHAR2,
2115 p_col13 VARCHAR2,
2116 p_col14 VARCHAR2,
2117 p_col15 VARCHAR2,
2118 p_col16 VARCHAR2,
2119 p_col17 VARCHAR2,
2120 p_col18 VARCHAR2,
2121 p_col19 VARCHAR2,
2122 p_col20 VARCHAR2,
2123 p_col21 VARCHAR2,
2124 p_col22 VARCHAR2,
2125 p_col23 VARCHAR2,
2126 p_col24 VARCHAR2,
2127 p_col25 VARCHAR2,
2128 p_col26 VARCHAR2,
2129 p_col27 VARCHAR2,
2130 p_col28 VARCHAR2,
2131 p_col29 VARCHAR2,
2132 p_col30 VARCHAR2,
2133 p_col31 VARCHAR2,
2134 p_col32 VARCHAR2,
2135 p_col33 VARCHAR2,
2136 p_col34 VARCHAR2,
2137 p_col35 VARCHAR2,
2138 p_col36 VARCHAR2,
2139 p_col37 VARCHAR2,
2140 p_col38 VARCHAR2,
2141 p_col39 VARCHAR2,
2142 p_col40 VARCHAR2,
2143 p_col41 VARCHAR2,
2144 p_col42 VARCHAR2,
2145 p_col43 VARCHAR2,
2146 p_col44 VARCHAR2,
2147 p_col45 VARCHAR2,
2148 p_col46 VARCHAR2,
2149 p_col47 VARCHAR2,
2150 p_col48 VARCHAR2,
2151 p_col49 VARCHAR2,
2152 p_col50 VARCHAR2,
2153 p_col51 VARCHAR2,
2154 p_col52 VARCHAR2,
2155 p_col53 VARCHAR2,
2156 p_col54 VARCHAR2,
2157 p_col55 VARCHAR2,
2158 p_col56 VARCHAR2,
2159 p_col57 VARCHAR2,
2160 p_col58 VARCHAR2,
2161 p_col59 VARCHAR2,
2162 p_col60 VARCHAR2,
2166 p_col64 VARCHAR2,
2163 p_col61 VARCHAR2,
2164 p_col62 VARCHAR2,
2165 p_col63 VARCHAR2,
2167 p_col65 VARCHAR2,
2168 p_col66 VARCHAR2,
2169 p_col67 VARCHAR2,
2170 p_col68 VARCHAR2,
2171 p_col69 VARCHAR2,
2172 p_col70 VARCHAR2,
2173 p_col71 VARCHAR2,
2174 p_col72 VARCHAR2,
2175 p_col73 VARCHAR2,
2176 p_col74 VARCHAR2,
2177 p_col75 VARCHAR2,
2178 p_col76 VARCHAR2,
2179 p_col77 VARCHAR2,
2180 p_col78 VARCHAR2,
2181 p_col79 VARCHAR2,
2182 p_col80 VARCHAR2,
2183 p_col81 VARCHAR2,
2184 p_col82 VARCHAR2,
2185 p_col83 VARCHAR2,
2186 p_col84 VARCHAR2,
2187 p_col85 VARCHAR2,
2188 p_col86 VARCHAR2,
2189 p_col87 VARCHAR2,
2190 p_col88 VARCHAR2,
2191 p_col89 VARCHAR2,
2192 p_col90 VARCHAR2,
2193 p_col91 VARCHAR2,
2194 p_col92 VARCHAR2,
2195 p_col93 VARCHAR2,
2196 p_col94 VARCHAR2,
2197 p_col95 VARCHAR2,
2198 p_col96 VARCHAR2,
2199 p_col97 VARCHAR2,
2200 p_col98 VARCHAR2,
2201 p_col99 VARCHAR2,
2202 p_col100 VARCHAR2,
2203 p_col101 VARCHAR2,
2204 p_col102 VARCHAR2,
2205 p_col103 VARCHAR2,
2206 p_col104 VARCHAR2,
2207 p_col105 VARCHAR2,
2208 p_col106 VARCHAR2,
2209 p_col107 VARCHAR2,
2210 p_col108 VARCHAR2,
2211 p_col109 VARCHAR2,
2212 p_col110 VARCHAR2,
2213 p_col111 VARCHAR2,
2214 p_col112 VARCHAR2,
2215 p_col113 VARCHAR2,
2216 p_col114 VARCHAR2,
2217 p_col115 VARCHAR2,
2218 p_col116 VARCHAR2,
2219 p_col117 VARCHAR2,
2220 p_col118 VARCHAR2,
2221 p_col119 VARCHAR2,
2222 p_col120 VARCHAR2,
2226 p_col124 VARCHAR2,
2223 p_col121 VARCHAR2,
2224 p_col122 VARCHAR2,
2225 p_col123 VARCHAR2,
2227 p_col125 VARCHAR2,
2228 p_col126 VARCHAR2,
2229 p_col127 VARCHAR2,
2230 p_col128 VARCHAR2,
2231 p_col129 VARCHAR2,
2232 p_col130 VARCHAR2,
2233 p_col131 VARCHAR2,
2234 p_col132 VARCHAR2,
2235 p_col133 VARCHAR2,
2236 p_col134 VARCHAR2,
2237 p_col135 VARCHAR2,
2238 p_col136 VARCHAR2,
2239 p_col137 VARCHAR2,
2240 p_col138 VARCHAR2,
2241 p_col139 VARCHAR2,
2242 p_col140 VARCHAR2,
2243 p_col141 VARCHAR2,
2244 p_col142 VARCHAR2,
2245 p_col143 VARCHAR2,
2246 p_col144 VARCHAR2,
2247 p_col145 VARCHAR2,
2248 p_col146 VARCHAR2,
2249 p_col147 VARCHAR2,
2250 p_col148 VARCHAR2,
2251 p_col149 VARCHAR2,
2252 p_col150 VARCHAR2,
2253 p_col151 VARCHAR2,
2254 p_col152 VARCHAR2,
2255 p_col153 VARCHAR2,
2256 p_col154 VARCHAR2,
2257 p_col155 VARCHAR2,
2258 p_col156 VARCHAR2,
2259 p_col157 VARCHAR2,
2260 p_col158 VARCHAR2,
2261 p_col159 VARCHAR2,
2262 p_col160 VARCHAR2,
2263 p_col161 VARCHAR2,
2264 p_col162 VARCHAR2,
2265 p_col163 VARCHAR2,
2266 p_col164 VARCHAR2,
2267 p_col165 VARCHAR2,
2268 p_col166 VARCHAR2,
2269 p_col167 VARCHAR2,
2270 p_col168 VARCHAR2,
2271 p_col169 VARCHAR2,
2272 p_col170 VARCHAR2,
2273 p_col171 VARCHAR2,
2274 p_col172 VARCHAR2,
2275 p_col173 VARCHAR2,
2276 p_col174 VARCHAR2,
2277 p_col175 VARCHAR2,
2278 p_col176 VARCHAR2,
2279 p_col177 VARCHAR2,
2280 p_col178 VARCHAR2,
2281 p_col179 VARCHAR2,
2282 p_col180 VARCHAR2,
2283 p_col181 VARCHAR2,
2284 p_col182 VARCHAR2,
2285 p_col183 VARCHAR2,
2286 p_col184 VARCHAR2,
2287 p_col185 VARCHAR2,
2288 p_col186 VARCHAR2,
2289 p_col187 VARCHAR2,
2290 p_col188 VARCHAR2,
2291 p_col189 VARCHAR2,
2292 p_col190 VARCHAR2,
2293 p_col191 VARCHAR2,
2294 p_col192 VARCHAR2,
2295 p_col193 VARCHAR2,
2296 p_col194 VARCHAR2,
2297 p_col195 VARCHAR2,
2298 p_col196 VARCHAR2,
2299 p_col197 VARCHAR2,
2300 p_col198 VARCHAR2,
2301 p_col199 VARCHAR2,
2302 p_col200 VARCHAR2,
2303 p_col201 VARCHAR2,
2304 p_col202 VARCHAR2,
2305 p_col203 VARCHAR2,
2306 p_col204 VARCHAR2,
2307 p_col205 VARCHAR2,
2308 p_col206 VARCHAR2,
2309 p_col207 VARCHAR2,
2310 p_col208 VARCHAR2,
2311 p_col209 VARCHAR2,
2312 p_col210 VARCHAR2,
2313 p_col211 VARCHAR2,
2314 p_col212 VARCHAR2,
2315 p_col213 VARCHAR2,
2316 p_col214 VARCHAR2,
2317 p_col215 VARCHAR2,
2318 p_col216 VARCHAR2,
2319 p_col217 VARCHAR2,
2320 p_col218 VARCHAR2,
2321 p_col219 VARCHAR2,
2322 p_col220 VARCHAR2,
2323 p_col221 VARCHAR2,
2324 p_col222 VARCHAR2,
2325 p_col223 VARCHAR2,
2326 p_col224 VARCHAR2,
2327 p_col225 VARCHAR2,
2328 p_col226 VARCHAR2,
2329 p_col227 VARCHAR2,
2330 p_col228 VARCHAR2,
2331 p_col229 VARCHAR2,
2332 p_col230 VARCHAR2,
2333 p_col231 VARCHAR2,
2334 p_col232 VARCHAR2,
2335 p_col233 VARCHAR2,
2336 p_col234 VARCHAR2,
2337 p_col235 VARCHAR2,
2338 p_col236 VARCHAR2,
2339 p_col237 VARCHAR2,
2340 p_col238 VARCHAR2,
2341 p_col239 VARCHAR2,
2342 p_col240 VARCHAR2,
2343 p_col241 VARCHAR2,
2344 p_col242 VARCHAR2,
2345 p_col243 VARCHAR2,
2346 p_col244 VARCHAR2,
2347 p_col245 VARCHAR2,
2348 p_col246 VARCHAR2,
2349 p_col247 VARCHAR2,
2350 p_col248 VARCHAR2,
2351 p_col249 VARCHAR2,
2352 p_col250 VARCHAR2,
2353 p_col251 VARCHAR2,
2354 p_col252 VARCHAR2,
2355 p_col253 VARCHAR2,
2356 p_col254 VARCHAR2,
2357 p_col255 VARCHAR2,
2358 p_col256 VARCHAR2,
2359 p_col257 VARCHAR2,
2360 p_col258 VARCHAR2,
2361 p_col259 VARCHAR2,
2362 p_col260 VARCHAR2,
2363 p_col261 VARCHAR2,
2364 p_col262 VARCHAR2,
2365 p_col263 VARCHAR2,
2366 p_col264 VARCHAR2,
2367 p_col265 VARCHAR2,
2368 p_col266 VARCHAR2,
2369 p_col267 VARCHAR2,
2370 p_col268 VARCHAR2,
2371 p_col269 VARCHAR2,
2372 p_col270 VARCHAR2,
2373 p_col271 VARCHAR2,
2377 p_col275 VARCHAR2,
2374 p_col272 VARCHAR2,
2375 p_col273 VARCHAR2,
2376 p_col274 VARCHAR2,
2378 p_col276 VARCHAR2,
2379 p_col277 VARCHAR2,
2380 p_col278 VARCHAR2,
2381 p_col279 VARCHAR2,
2382 p_col280 VARCHAR2,
2383 p_col281 VARCHAR2,
2384 p_col282 VARCHAR2,
2385 p_col283 VARCHAR2,
2386 p_col284 VARCHAR2,
2387 p_col285 VARCHAR2,
2388 p_col286 VARCHAR2,
2389 p_col287 VARCHAR2,
2390 p_col288 VARCHAR2,
2391 p_col289 VARCHAR2,
2392 p_col290 VARCHAR2,
2393 p_col291 VARCHAR2,
2394 p_col292 VARCHAR2,
2395 p_col293 VARCHAR2,
2396 p_col294 VARCHAR2,
2397 p_col295 VARCHAR2,
2398 p_col296 VARCHAR2,
2399 p_col297 VARCHAR2,
2400 p_col298 VARCHAR2,
2401 p_col299 VARCHAR2,
2402 p_col300 VARCHAR2,
2403 p_party_id NUMBER,
2404 p_parent_party_id NUMBER,
2405 --p_geometry SDO_GEOMETRY,
2406 p_imp_source_line_id NUMBER,
2407 p_usage_restriction VARCHAR2,
2408 p_next_call_time DATE,
2409 p_callback_flag VARCHAR2,
2410 p_do_not_use_flag VARCHAR2,
2411 p_do_not_use_reason varchar2,
2412 p_record_out_flag VARCHAR2,
2413 p_record_release_time DATE,
2414 p_group_code VARCHAR2,
2415 p_newly_updated_flag VARCHAR2,
2416 p_outcome_id number,
2417 p_result_id number,
2418 p_reason_id number
2419 )
2420
2421 IS
2422 CURSOR C IS
2423 SELECT *
2424 FROM AMS_LIST_ENTRIES
2425 WHERE LIST_ENTRY_ID = p_LIST_ENTRY_ID
2426 FOR UPDATE of LIST_ENTRY_ID NOWAIT;
2427 Recinfo C%ROWTYPE;
2428 BEGIN
2429 OPEN c;
2430 FETCH c INTO Recinfo;
2431 If (c%NOTFOUND) then
2432 CLOSE c;
2433 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
2434 APP_EXCEPTION.RAISE_EXCEPTION;
2435 END IF;
2436 CLOSE C;
2437 IF (
2438 ( Recinfo.list_entry_id = p_list_entry_id)
2439 AND ( ( Recinfo.list_header_id = p_list_header_id)
2440 OR ( ( Recinfo.list_header_id IS NULL )
2441 AND ( p_list_header_id IS NULL )))
2442 AND ( ( Recinfo.last_update_date = p_last_update_date)
2443 OR ( ( Recinfo.last_update_date IS NULL )
2444 AND ( p_last_update_date IS NULL )))
2445 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
2446 OR ( ( Recinfo.last_updated_by IS NULL )
2447 AND ( p_last_updated_by IS NULL )))
2448 AND ( ( Recinfo.creation_date = p_creation_date)
2449 OR ( ( Recinfo.creation_date IS NULL )
2450 AND ( p_creation_date IS NULL )))
2451 AND ( ( Recinfo.created_by = p_created_by)
2452 OR ( ( Recinfo.created_by IS NULL )
2453 AND ( p_created_by IS NULL )))
2454 AND ( ( Recinfo.last_update_login = p_last_update_login)
2455 OR ( ( Recinfo.last_update_login IS NULL )
2456 AND ( p_last_update_login IS NULL )))
2457 AND ( ( Recinfo.object_version_number = p_object_version_number)
2458 OR ( ( Recinfo.object_version_number IS NULL )
2459 AND ( p_object_version_number IS NULL )))
2460 AND ( ( Recinfo.list_select_action_id = p_list_select_action_id)
2461 OR ( ( Recinfo.list_select_action_id IS NULL )
2462 AND ( p_list_select_action_id IS NULL )))
2463 AND ( ( Recinfo.arc_list_select_action_from = p_arc_list_select_action_from)
2464 OR ( ( Recinfo.arc_list_select_action_from IS NULL )
2465 AND ( p_arc_list_select_action_from IS NULL )))
2466 AND ( ( Recinfo.list_select_action_from_name = p_list_select_action_from_name)
2467 OR ( ( Recinfo.list_select_action_from_name IS NULL )
2468 AND ( p_list_select_action_from_name IS NULL )))
2469 AND ( ( Recinfo.source_code = p_source_code)
2470 OR ( ( Recinfo.source_code IS NULL )
2471 AND ( p_source_code IS NULL )))
2472 AND ( ( Recinfo.arc_list_used_by_source = p_arc_list_used_by_source)
2473 OR ( ( Recinfo.arc_list_used_by_source IS NULL )
2474 AND ( p_arc_list_used_by_source IS NULL )))
2475 AND ( ( Recinfo.source_code_for_id = p_source_code_for_id)
2476 OR ( ( Recinfo.source_code_for_id IS NULL )
2477 AND ( p_source_code_for_id IS NULL )))
2478 AND ( ( Recinfo.pin_code = p_pin_code)
2479 OR ( ( Recinfo.pin_code IS NULL )
2480 AND ( p_pin_code IS NULL )))
2481 AND ( ( Recinfo.list_entry_source_system_id = p_list_entry_source_system_id)
2482 OR ( ( Recinfo.list_entry_source_system_id IS NULL )
2483 AND ( p_list_entry_source_system_id IS NULL )))
2484 AND ( ( Recinfo.list_entry_source_system_type = p_list_entry_source_system_tp)
2485 OR ( ( Recinfo.list_entry_source_system_type IS NULL )
2486 AND ( p_list_entry_source_system_tp IS NULL )))
2487 AND ( ( Recinfo.view_application_id = p_view_application_id)
2488 OR ( ( Recinfo.view_application_id IS NULL )
2489 AND ( p_view_application_id IS NULL )))
2490 AND ( ( Recinfo.manually_entered_flag = p_manually_entered_flag)
2491 OR ( ( Recinfo.manually_entered_flag IS NULL )
2492 AND ( p_manually_entered_flag IS NULL )))
2493 AND ( ( Recinfo.marked_as_duplicate_flag = p_marked_as_duplicate_flag)
2497 OR ( ( Recinfo.marked_as_random_flag IS NULL )
2494 OR ( ( Recinfo.marked_as_duplicate_flag IS NULL )
2495 AND ( p_marked_as_duplicate_flag IS NULL )))
2496 AND ( ( Recinfo.marked_as_random_flag = p_marked_as_random_flag)
2498 AND ( p_marked_as_random_flag IS NULL )))
2499 AND ( ( Recinfo.part_of_control_group_flag = p_part_of_control_group_flag)
2500 OR ( ( Recinfo.part_of_control_group_flag IS NULL )
2501 AND ( p_part_of_control_group_flag IS NULL )))
2502 AND ( ( Recinfo.exclude_in_triggered_list_flag = p_exclude_in_triggered_list_fg)
2503 OR ( ( Recinfo.exclude_in_triggered_list_flag IS NULL )
2504 AND ( p_exclude_in_triggered_list_fg IS NULL )))
2505 AND ( ( Recinfo.enabled_flag = p_enabled_flag)
2506 OR ( ( Recinfo.enabled_flag IS NULL )
2507 AND ( p_enabled_flag IS NULL )))
2508 AND ( ( Recinfo.cell_code = p_cell_code)
2509 OR ( ( Recinfo.cell_code IS NULL )
2510 AND ( p_cell_code IS NULL )))
2511 AND ( ( Recinfo.dedupe_key = p_dedupe_key)
2512 OR ( ( Recinfo.dedupe_key IS NULL )
2513 AND ( p_dedupe_key IS NULL )))
2514 AND ( ( Recinfo.randomly_generated_number = p_randomly_generated_number)
2515 OR ( ( Recinfo.randomly_generated_number IS NULL )
2516 AND ( p_randomly_generated_number IS NULL )))
2517 AND ( ( Recinfo.campaign_id = p_campaign_id)
2518 OR ( ( Recinfo.campaign_id IS NULL )
2519 AND ( p_campaign_id IS NULL )))
2520 AND ( ( Recinfo.media_id = p_media_id)
2521 OR ( ( Recinfo.media_id IS NULL )
2522 AND ( p_media_id IS NULL )))
2523 AND ( ( Recinfo.channel_id = p_channel_id)
2524 OR ( ( Recinfo.channel_id IS NULL )
2525 AND ( p_channel_id IS NULL )))
2526 AND ( ( Recinfo.channel_schedule_id = p_channel_schedule_id)
2527 OR ( ( Recinfo.channel_schedule_id IS NULL )
2528 AND ( p_channel_schedule_id IS NULL )))
2529 AND ( ( Recinfo.event_offer_id = p_event_offer_id)
2530 OR ( ( Recinfo.event_offer_id IS NULL )
2531 AND ( p_event_offer_id IS NULL )))
2532 AND ( ( Recinfo.customer_id = p_customer_id)
2533 OR ( ( Recinfo.customer_id IS NULL )
2534 AND ( p_customer_id IS NULL )))
2535 AND ( ( Recinfo.market_segment_id = p_market_segment_id)
2536 OR ( ( Recinfo.market_segment_id IS NULL )
2537 AND ( p_market_segment_id IS NULL )))
2538 AND ( ( Recinfo.vendor_id = p_vendor_id)
2539 OR ( ( Recinfo.vendor_id IS NULL )
2540 AND ( p_vendor_id IS NULL )))
2541 AND ( ( Recinfo.transfer_flag = p_transfer_flag)
2542 OR ( ( Recinfo.transfer_flag IS NULL )
2543 AND ( p_transfer_flag IS NULL )))
2544 AND ( ( Recinfo.transfer_status = p_transfer_status)
2545 OR ( ( Recinfo.transfer_status IS NULL )
2546 AND ( p_transfer_status IS NULL )))
2547 AND ( ( Recinfo.list_source = p_list_source)
2548 OR ( ( Recinfo.list_source IS NULL )
2549 AND ( p_list_source IS NULL )))
2550 AND ( ( Recinfo.duplicate_master_entry_id = p_duplicate_master_entry_id)
2551 OR ( ( Recinfo.duplicate_master_entry_id IS NULL )
2552 AND ( p_duplicate_master_entry_id IS NULL )))
2553 AND ( ( Recinfo.marked_flag = p_marked_flag)
2554 OR ( ( Recinfo.marked_flag IS NULL )
2555 AND ( p_marked_flag IS NULL )))
2556 AND ( ( Recinfo.lead_id = p_lead_id)
2557 OR ( ( Recinfo.lead_id IS NULL )
2558 AND ( p_lead_id IS NULL )))
2559 AND ( ( Recinfo.letter_id = p_letter_id)
2560 OR ( ( Recinfo.letter_id IS NULL )
2561 AND ( p_letter_id IS NULL )))
2562 AND ( ( Recinfo.picking_header_id = p_picking_header_id)
2563 OR ( ( Recinfo.picking_header_id IS NULL )
2564 AND ( p_picking_header_id IS NULL )))
2565 AND ( ( Recinfo.batch_id = p_batch_id)
2566 OR ( ( Recinfo.batch_id IS NULL )
2567 AND ( p_batch_id IS NULL )))
2568 AND ( ( Recinfo.suffix = p_suffix)
2569 OR ( ( Recinfo.suffix IS NULL )
2570 AND ( p_suffix IS NULL )))
2571 AND ( ( Recinfo.first_name = p_first_name)
2572 OR ( ( Recinfo.first_name IS NULL )
2573 AND ( p_first_name IS NULL )))
2574 AND ( ( Recinfo.last_name = p_last_name)
2575 OR ( ( Recinfo.last_name IS NULL )
2576 AND ( p_last_name IS NULL )))
2577 AND ( ( Recinfo.customer_name = p_customer_name)
2578 OR ( ( Recinfo.customer_name IS NULL )
2579 AND ( p_customer_name IS NULL )))
2580 AND ( ( Recinfo.title = p_title)
2581 OR ( ( Recinfo.title IS NULL )
2582 AND ( p_title IS NULL )))
2583 AND ( ( Recinfo.address_line1 = p_address_line1)
2584 OR ( ( Recinfo.address_line1 IS NULL )
2585 AND ( p_address_line1 IS NULL )))
2586 AND ( ( Recinfo.address_line2 = p_address_line2)
2587 OR ( ( Recinfo.address_line2 IS NULL )
2588 AND ( p_address_line2 IS NULL )))
2589 AND ( ( Recinfo.city = p_city)
2590 OR ( ( Recinfo.city IS NULL )
2591 AND ( p_city IS NULL )))
2592 AND ( ( Recinfo.state = p_state)
2593 OR ( ( Recinfo.state IS NULL )
2594 AND ( p_state IS NULL )))
2595 AND ( ( Recinfo.zipcode = p_zipcode)
2596 OR ( ( Recinfo.zipcode IS NULL )
2597 AND ( p_zipcode IS NULL )))
2601 AND ( ( Recinfo.fax = p_fax)
2598 AND ( ( Recinfo.country = p_country)
2599 OR ( ( Recinfo.country IS NULL )
2600 AND ( p_country IS NULL )))
2602 OR ( ( Recinfo.fax IS NULL )
2603 AND ( p_fax IS NULL )))
2604 AND ( ( Recinfo.phone = p_phone)
2605 OR ( ( Recinfo.phone IS NULL )
2606 AND ( p_phone IS NULL )))
2607 AND ( ( Recinfo.email_address = p_email_address)
2608 OR ( ( Recinfo.email_address IS NULL )
2609 AND ( p_email_address IS NULL )))
2610 AND ( ( Recinfo.col1 = p_col1)
2611 OR ( ( Recinfo.col1 IS NULL )
2612 AND ( p_col1 IS NULL )))
2613 AND ( ( Recinfo.col2 = p_col2)
2614 OR ( ( Recinfo.col2 IS NULL )
2615 AND ( p_col2 IS NULL )))
2616 AND ( ( Recinfo.col3 = p_col3)
2617 OR ( ( Recinfo.col3 IS NULL )
2618 AND ( p_col3 IS NULL )))
2619 AND ( ( Recinfo.col4 = p_col4)
2620 OR ( ( Recinfo.col4 IS NULL )
2621 AND ( p_col4 IS NULL )))
2622 AND ( ( Recinfo.col5 = p_col5)
2623 OR ( ( Recinfo.col5 IS NULL )
2624 AND ( p_col5 IS NULL )))
2625 AND ( ( Recinfo.col6 = p_col6)
2626 OR ( ( Recinfo.col6 IS NULL )
2627 AND ( p_col6 IS NULL )))
2628 AND ( ( Recinfo.col7 = p_col7)
2629 OR ( ( Recinfo.col7 IS NULL )
2630 AND ( p_col7 IS NULL )))
2631 AND ( ( Recinfo.col8 = p_col8)
2632 OR ( ( Recinfo.col8 IS NULL )
2633 AND ( p_col8 IS NULL )))
2634 AND ( ( Recinfo.col9 = p_col9)
2635 OR ( ( Recinfo.col9 IS NULL )
2636 AND ( p_col9 IS NULL )))
2637 AND ( ( Recinfo.col10 = p_col10)
2638 OR ( ( Recinfo.col10 IS NULL )
2639 AND ( p_col10 IS NULL )))
2640 AND ( ( Recinfo.col11 = p_col11)
2641 OR ( ( Recinfo.col11 IS NULL )
2642 AND ( p_col11 IS NULL )))
2643 AND ( ( Recinfo.col12 = p_col12)
2644 OR ( ( Recinfo.col12 IS NULL )
2645 AND ( p_col12 IS NULL )))
2646 AND ( ( Recinfo.col13 = p_col13)
2647 OR ( ( Recinfo.col13 IS NULL )
2648 AND ( p_col13 IS NULL )))
2649 AND ( ( Recinfo.col14 = p_col14)
2650 OR ( ( Recinfo.col14 IS NULL )
2651 AND ( p_col14 IS NULL )))
2652 AND ( ( Recinfo.col15 = p_col15)
2653 OR ( ( Recinfo.col15 IS NULL )
2654 AND ( p_col15 IS NULL )))
2655 AND ( ( Recinfo.col16 = p_col16)
2656 OR ( ( Recinfo.col16 IS NULL )
2657 AND ( p_col16 IS NULL )))
2658 AND ( ( Recinfo.col17 = p_col17)
2659 OR ( ( Recinfo.col17 IS NULL )
2660 AND ( p_col17 IS NULL )))
2661 AND ( ( Recinfo.col18 = p_col18)
2662 OR ( ( Recinfo.col18 IS NULL )
2663 AND ( p_col18 IS NULL )))
2664 AND ( ( Recinfo.col19 = p_col19)
2665 OR ( ( Recinfo.col19 IS NULL )
2666 AND ( p_col19 IS NULL )))
2667 AND ( ( Recinfo.col20 = p_col20)
2668 OR ( ( Recinfo.col20 IS NULL )
2669 AND ( p_col20 IS NULL )))
2670 AND ( ( Recinfo.col21 = p_col21)
2671 OR ( ( Recinfo.col21 IS NULL )
2672 AND ( p_col21 IS NULL )))
2673 AND ( ( Recinfo.col22 = p_col22)
2674 OR ( ( Recinfo.col22 IS NULL )
2675 AND ( p_col22 IS NULL )))
2676 AND ( ( Recinfo.col23 = p_col23)
2677 OR ( ( Recinfo.col23 IS NULL )
2678 AND ( p_col23 IS NULL )))
2679 AND ( ( Recinfo.col24 = p_col24)
2680 OR ( ( Recinfo.col24 IS NULL )
2681 AND ( p_col24 IS NULL )))
2682 AND ( ( Recinfo.col25 = p_col25)
2683 OR ( ( Recinfo.col25 IS NULL )
2684 AND ( p_col25 IS NULL )))
2685 AND ( ( Recinfo.col26 = p_col26)
2686 OR ( ( Recinfo.col26 IS NULL )
2687 AND ( p_col26 IS NULL )))
2688 AND ( ( Recinfo.col27 = p_col27)
2689 OR ( ( Recinfo.col27 IS NULL )
2690 AND ( p_col27 IS NULL )))
2691 AND ( ( Recinfo.col28 = p_col28)
2692 OR ( ( Recinfo.col28 IS NULL )
2693 AND ( p_col28 IS NULL )))
2694 AND ( ( Recinfo.col29 = p_col29)
2695 OR ( ( Recinfo.col29 IS NULL )
2696 AND ( p_col29 IS NULL )))
2697 AND ( ( Recinfo.col30 = p_col30)
2698 OR ( ( Recinfo.col30 IS NULL )
2699 AND ( p_col30 IS NULL )))
2700 AND ( ( Recinfo.col31 = p_col31)
2701 OR ( ( Recinfo.col31 IS NULL )
2702 AND ( p_col31 IS NULL )))
2703 AND ( ( Recinfo.col32 = p_col32)
2704 OR ( ( Recinfo.col32 IS NULL )
2705 AND ( p_col32 IS NULL )))
2706 AND ( ( Recinfo.col33 = p_col33)
2707 OR ( ( Recinfo.col33 IS NULL )
2708 AND ( p_col33 IS NULL )))
2709 AND ( ( Recinfo.col34 = p_col34)
2710 OR ( ( Recinfo.col34 IS NULL )
2711 AND ( p_col34 IS NULL )))
2712 AND ( ( Recinfo.col35 = p_col35)
2713 OR ( ( Recinfo.col35 IS NULL )
2714 AND ( p_col35 IS NULL )))
2715 AND ( ( Recinfo.col36 = p_col36)
2716 OR ( ( Recinfo.col36 IS NULL )
2717 AND ( p_col36 IS NULL )))
2718 AND ( ( Recinfo.col37 = p_col37)
2719 OR ( ( Recinfo.col37 IS NULL )
2723 AND ( p_col38 IS NULL )))
2720 AND ( p_col37 IS NULL )))
2721 AND ( ( Recinfo.col38 = p_col38)
2722 OR ( ( Recinfo.col38 IS NULL )
2724 AND ( ( Recinfo.col39 = p_col39)
2725 OR ( ( Recinfo.col39 IS NULL )
2726 AND ( p_col39 IS NULL )))
2727 AND ( ( Recinfo.col40 = p_col40)
2728 OR ( ( Recinfo.col40 IS NULL )
2729 AND ( p_col40 IS NULL )))
2730 AND ( ( Recinfo.col41 = p_col41)
2731 OR ( ( Recinfo.col41 IS NULL )
2732 AND ( p_col41 IS NULL )))
2733 AND ( ( Recinfo.col42 = p_col42)
2734 OR ( ( Recinfo.col42 IS NULL )
2735 AND ( p_col42 IS NULL )))
2736 AND ( ( Recinfo.col43 = p_col43)
2737 OR ( ( Recinfo.col43 IS NULL )
2738 AND ( p_col43 IS NULL )))
2739 AND ( ( Recinfo.col44 = p_col44)
2740 OR ( ( Recinfo.col44 IS NULL )
2741 AND ( p_col44 IS NULL )))
2742 AND ( ( Recinfo.col45 = p_col45)
2743 OR ( ( Recinfo.col45 IS NULL )
2744 AND ( p_col45 IS NULL )))
2745 AND ( ( Recinfo.col46 = p_col46)
2746 OR ( ( Recinfo.col46 IS NULL )
2747 AND ( p_col46 IS NULL )))
2748 AND ( ( Recinfo.col47 = p_col47)
2749 OR ( ( Recinfo.col47 IS NULL )
2750 AND ( p_col47 IS NULL )))
2751 AND ( ( Recinfo.col48 = p_col48)
2752 OR ( ( Recinfo.col48 IS NULL )
2753 AND ( p_col48 IS NULL )))
2754 AND ( ( Recinfo.col49 = p_col49)
2755 OR ( ( Recinfo.col49 IS NULL )
2756 AND ( p_col49 IS NULL )))
2757 AND ( ( Recinfo.col50 = p_col50)
2758 OR ( ( Recinfo.col50 IS NULL )
2759 AND ( p_col50 IS NULL )))
2760 AND ( ( Recinfo.col51 = p_col51)
2761 OR ( ( Recinfo.col51 IS NULL )
2762 AND ( p_col51 IS NULL )))
2763 AND ( ( Recinfo.col52 = p_col52)
2764 OR ( ( Recinfo.col52 IS NULL )
2765 AND ( p_col52 IS NULL )))
2766 AND ( ( Recinfo.col53 = p_col53)
2767 OR ( ( Recinfo.col53 IS NULL )
2768 AND ( p_col53 IS NULL )))
2769 AND ( ( Recinfo.col54 = p_col54)
2770 OR ( ( Recinfo.col54 IS NULL )
2771 AND ( p_col54 IS NULL )))
2772 AND ( ( Recinfo.col55 = p_col55)
2773 OR ( ( Recinfo.col55 IS NULL )
2774 AND ( p_col55 IS NULL )))
2775 AND ( ( Recinfo.col56 = p_col56)
2776 OR ( ( Recinfo.col56 IS NULL )
2777 AND ( p_col56 IS NULL )))
2778 AND ( ( Recinfo.col57 = p_col57)
2779 OR ( ( Recinfo.col57 IS NULL )
2780 AND ( p_col57 IS NULL )))
2781 AND ( ( Recinfo.col58 = p_col58)
2782 OR ( ( Recinfo.col58 IS NULL )
2783 AND ( p_col58 IS NULL )))
2784 AND ( ( Recinfo.col59 = p_col59)
2785 OR ( ( Recinfo.col59 IS NULL )
2786 AND ( p_col59 IS NULL )))
2787 AND ( ( Recinfo.col60 = p_col60)
2788 OR ( ( Recinfo.col60 IS NULL )
2789 AND ( p_col60 IS NULL )))
2790 AND ( ( Recinfo.col61 = p_col61)
2791 OR ( ( Recinfo.col61 IS NULL )
2792 AND ( p_col61 IS NULL )))
2793 AND ( ( Recinfo.col62 = p_col62)
2794 OR ( ( Recinfo.col62 IS NULL )
2795 AND ( p_col62 IS NULL )))
2796 AND ( ( Recinfo.col63 = p_col63)
2797 OR ( ( Recinfo.col63 IS NULL )
2798 AND ( p_col63 IS NULL )))
2799 AND ( ( Recinfo.col64 = p_col64)
2800 OR ( ( Recinfo.col64 IS NULL )
2801 AND ( p_col64 IS NULL )))
2802 AND ( ( Recinfo.col65 = p_col65)
2803 OR ( ( Recinfo.col65 IS NULL )
2804 AND ( p_col65 IS NULL )))
2805 AND ( ( Recinfo.col66 = p_col66)
2806 OR ( ( Recinfo.col66 IS NULL )
2807 AND ( p_col66 IS NULL )))
2808 AND ( ( Recinfo.col67 = p_col67)
2809 OR ( ( Recinfo.col67 IS NULL )
2810 AND ( p_col67 IS NULL )))
2811 AND ( ( Recinfo.col68 = p_col68)
2812 OR ( ( Recinfo.col68 IS NULL )
2813 AND ( p_col68 IS NULL )))
2814 AND ( ( Recinfo.col69 = p_col69)
2815 OR ( ( Recinfo.col69 IS NULL )
2816 AND ( p_col69 IS NULL )))
2817 AND ( ( Recinfo.col70 = p_col70)
2818 OR ( ( Recinfo.col70 IS NULL )
2819 AND ( p_col70 IS NULL )))
2820 AND ( ( Recinfo.col71 = p_col71)
2821 OR ( ( Recinfo.col71 IS NULL )
2822 AND ( p_col71 IS NULL )))
2823 AND ( ( Recinfo.col72 = p_col72)
2824 OR ( ( Recinfo.col72 IS NULL )
2825 AND ( p_col72 IS NULL )))
2826 AND ( ( Recinfo.col73 = p_col73)
2827 OR ( ( Recinfo.col73 IS NULL )
2828 AND ( p_col73 IS NULL )))
2829 AND ( ( Recinfo.col74 = p_col74)
2830 OR ( ( Recinfo.col74 IS NULL )
2831 AND ( p_col74 IS NULL )))
2832 AND ( ( Recinfo.col75 = p_col75)
2833 OR ( ( Recinfo.col75 IS NULL )
2834 AND ( p_col75 IS NULL )))
2835 AND ( ( Recinfo.col76 = p_col76)
2836 OR ( ( Recinfo.col76 IS NULL )
2837 AND ( p_col76 IS NULL )))
2838 AND ( ( Recinfo.col77 = p_col77)
2839 OR ( ( Recinfo.col77 IS NULL )
2840 AND ( p_col77 IS NULL )))
2841 AND ( ( Recinfo.col78 = p_col78)
2845 OR ( ( Recinfo.col79 IS NULL )
2842 OR ( ( Recinfo.col78 IS NULL )
2843 AND ( p_col78 IS NULL )))
2844 AND ( ( Recinfo.col79 = p_col79)
2846 AND ( p_col79 IS NULL )))
2847 AND ( ( Recinfo.col80 = p_col80)
2848 OR ( ( Recinfo.col80 IS NULL )
2849 AND ( p_col80 IS NULL )))
2850 AND ( ( Recinfo.col81 = p_col81)
2851 OR ( ( Recinfo.col81 IS NULL )
2852 AND ( p_col81 IS NULL )))
2853 AND ( ( Recinfo.col82 = p_col82)
2854 OR ( ( Recinfo.col82 IS NULL )
2855 AND ( p_col82 IS NULL )))
2856 AND ( ( Recinfo.col83 = p_col83)
2857 OR ( ( Recinfo.col83 IS NULL )
2858 AND ( p_col83 IS NULL )))
2859 AND ( ( Recinfo.col84 = p_col84)
2860 OR ( ( Recinfo.col84 IS NULL )
2861 AND ( p_col84 IS NULL )))
2862 AND ( ( Recinfo.col85 = p_col85)
2863 OR ( ( Recinfo.col85 IS NULL )
2864 AND ( p_col85 IS NULL )))
2865 AND ( ( Recinfo.col86 = p_col86)
2866 OR ( ( Recinfo.col86 IS NULL )
2867 AND ( p_col86 IS NULL )))
2868 AND ( ( Recinfo.col87 = p_col87)
2869 OR ( ( Recinfo.col87 IS NULL )
2870 AND ( p_col87 IS NULL )))
2871 AND ( ( Recinfo.col88 = p_col88)
2872 OR ( ( Recinfo.col88 IS NULL )
2873 AND ( p_col88 IS NULL )))
2874 AND ( ( Recinfo.col89 = p_col89)
2875 OR ( ( Recinfo.col89 IS NULL )
2876 AND ( p_col89 IS NULL )))
2877 AND ( ( Recinfo.col90 = p_col90)
2878 OR ( ( Recinfo.col90 IS NULL )
2879 AND ( p_col90 IS NULL )))
2880 AND ( ( Recinfo.col91 = p_col91)
2881 OR ( ( Recinfo.col91 IS NULL )
2882 AND ( p_col91 IS NULL )))
2883 AND ( ( Recinfo.col92 = p_col92)
2884 OR ( ( Recinfo.col92 IS NULL )
2885 AND ( p_col92 IS NULL )))
2886 AND ( ( Recinfo.col93 = p_col93)
2887 OR ( ( Recinfo.col93 IS NULL )
2888 AND ( p_col93 IS NULL )))
2889 AND ( ( Recinfo.col94 = p_col94)
2890 OR ( ( Recinfo.col94 IS NULL )
2891 AND ( p_col94 IS NULL )))
2892 AND ( ( Recinfo.col95 = p_col95)
2893 OR ( ( Recinfo.col95 IS NULL )
2894 AND ( p_col95 IS NULL )))
2895 AND ( ( Recinfo.col96 = p_col96)
2896 OR ( ( Recinfo.col96 IS NULL )
2897 AND ( p_col96 IS NULL )))
2898 AND ( ( Recinfo.col97 = p_col97)
2899 OR ( ( Recinfo.col97 IS NULL )
2900 AND ( p_col97 IS NULL )))
2901 AND ( ( Recinfo.col98 = p_col98)
2902 OR ( ( Recinfo.col98 IS NULL )
2903 AND ( p_col98 IS NULL )))
2904 AND ( ( Recinfo.col99 = p_col99)
2905 OR ( ( Recinfo.col99 IS NULL )
2906 AND ( p_col99 IS NULL )))
2907 AND ( ( Recinfo.col100 = p_col100)
2908 OR ( ( Recinfo.col100 IS NULL )
2909 AND ( p_col100 IS NULL )))
2910 AND ( ( Recinfo.col101 = p_col101)
2911 OR ( ( Recinfo.col101 IS NULL )
2912 AND ( p_col101 IS NULL )))
2913 AND ( ( Recinfo.col102 = p_col102)
2914 OR ( ( Recinfo.col102 IS NULL )
2915 AND ( p_col102 IS NULL )))
2916 AND ( ( Recinfo.col103 = p_col103)
2917 OR ( ( Recinfo.col103 IS NULL )
2918 AND ( p_col103 IS NULL )))
2919 AND ( ( Recinfo.col104 = p_col104)
2920 OR ( ( Recinfo.col104 IS NULL )
2921 AND ( p_col104 IS NULL )))
2922 AND ( ( Recinfo.col105 = p_col105)
2923 OR ( ( Recinfo.col105 IS NULL )
2924 AND ( p_col105 IS NULL )))
2925 AND ( ( Recinfo.col106 = p_col106)
2926 OR ( ( Recinfo.col106 IS NULL )
2927 AND ( p_col106 IS NULL )))
2928 AND ( ( Recinfo.col107 = p_col107)
2929 OR ( ( Recinfo.col107 IS NULL )
2930 AND ( p_col107 IS NULL )))
2931 AND ( ( Recinfo.col108 = p_col108)
2932 OR ( ( Recinfo.col108 IS NULL )
2933 AND ( p_col108 IS NULL )))
2934 AND ( ( Recinfo.col109 = p_col109)
2935 OR ( ( Recinfo.col109 IS NULL )
2936 AND ( p_col109 IS NULL )))
2937 AND ( ( Recinfo.col110 = p_col110)
2938 OR ( ( Recinfo.col110 IS NULL )
2939 AND ( p_col110 IS NULL )))
2940 AND ( ( Recinfo.col111 = p_col111)
2941 OR ( ( Recinfo.col111 IS NULL )
2942 AND ( p_col111 IS NULL )))
2943 AND ( ( Recinfo.col112 = p_col112)
2944 OR ( ( Recinfo.col112 IS NULL )
2945 AND ( p_col112 IS NULL )))
2946 AND ( ( Recinfo.col113 = p_col113)
2947 OR ( ( Recinfo.col113 IS NULL )
2948 AND ( p_col113 IS NULL )))
2949 AND ( ( Recinfo.col114 = p_col114)
2950 OR ( ( Recinfo.col114 IS NULL )
2951 AND ( p_col114 IS NULL )))
2952 AND ( ( Recinfo.col115 = p_col115)
2953 OR ( ( Recinfo.col115 IS NULL )
2954 AND ( p_col115 IS NULL )))
2955 AND ( ( Recinfo.col116 = p_col116)
2956 OR ( ( Recinfo.col116 IS NULL )
2957 AND ( p_col116 IS NULL )))
2958 AND ( ( Recinfo.col117 = p_col117)
2959 OR ( ( Recinfo.col117 IS NULL )
2960 AND ( p_col117 IS NULL )))
2961 AND ( ( Recinfo.col118 = p_col118)
2962 OR ( ( Recinfo.col118 IS NULL )
2966 AND ( p_col119 IS NULL )))
2963 AND ( p_col118 IS NULL )))
2964 AND ( ( Recinfo.col119 = p_col119)
2965 OR ( ( Recinfo.col119 IS NULL )
2967 AND ( ( Recinfo.col120 = p_col120)
2968 OR ( ( Recinfo.col120 IS NULL )
2969 AND ( p_col120 IS NULL )))
2970 AND ( ( Recinfo.col121 = p_col121)
2971 OR ( ( Recinfo.col121 IS NULL )
2972 AND ( p_col121 IS NULL )))
2973 AND ( ( Recinfo.col122 = p_col122)
2974 OR ( ( Recinfo.col122 IS NULL )
2975 AND ( p_col122 IS NULL )))
2976 AND ( ( Recinfo.col123 = p_col123)
2977 OR ( ( Recinfo.col123 IS NULL )
2978 AND ( p_col123 IS NULL )))
2979 AND ( ( Recinfo.col124 = p_col124)
2980 OR ( ( Recinfo.col124 IS NULL )
2981 AND ( p_col124 IS NULL )))
2982 AND ( ( Recinfo.col125 = p_col125)
2983 OR ( ( Recinfo.col125 IS NULL )
2984 AND ( p_col125 IS NULL )))
2985 AND ( ( Recinfo.col126 = p_col126)
2986 OR ( ( Recinfo.col126 IS NULL )
2987 AND ( p_col126 IS NULL )))
2988 AND ( ( Recinfo.col127 = p_col127)
2989 OR ( ( Recinfo.col127 IS NULL )
2990 AND ( p_col127 IS NULL )))
2991 AND ( ( Recinfo.col128 = p_col128)
2992 OR ( ( Recinfo.col128 IS NULL )
2993 AND ( p_col128 IS NULL )))
2994 AND ( ( Recinfo.col129 = p_col129)
2995 OR ( ( Recinfo.col129 IS NULL )
2996 AND ( p_col129 IS NULL )))
2997 AND ( ( Recinfo.col130 = p_col130)
2998 OR ( ( Recinfo.col130 IS NULL )
2999 AND ( p_col130 IS NULL )))
3000 AND ( ( Recinfo.col131 = p_col131)
3001 OR ( ( Recinfo.col131 IS NULL )
3002 AND ( p_col131 IS NULL )))
3003 AND ( ( Recinfo.col132 = p_col132)
3004 OR ( ( Recinfo.col132 IS NULL )
3005 AND ( p_col132 IS NULL )))
3006 AND ( ( Recinfo.col133 = p_col133)
3007 OR ( ( Recinfo.col133 IS NULL )
3008 AND ( p_col133 IS NULL )))
3009 AND ( ( Recinfo.col134 = p_col134)
3010 OR ( ( Recinfo.col134 IS NULL )
3011 AND ( p_col134 IS NULL )))
3012 AND ( ( Recinfo.col135 = p_col135)
3013 OR ( ( Recinfo.col135 IS NULL )
3014 AND ( p_col135 IS NULL )))
3015 AND ( ( Recinfo.col136 = p_col136)
3016 OR ( ( Recinfo.col136 IS NULL )
3017 AND ( p_col136 IS NULL )))
3018 AND ( ( Recinfo.col137 = p_col137)
3019 OR ( ( Recinfo.col137 IS NULL )
3020 AND ( p_col137 IS NULL )))
3021 AND ( ( Recinfo.col138 = p_col138)
3022 OR ( ( Recinfo.col138 IS NULL )
3023 AND ( p_col138 IS NULL )))
3024 AND ( ( Recinfo.col139 = p_col139)
3025 OR ( ( Recinfo.col139 IS NULL )
3026 AND ( p_col139 IS NULL )))
3027 AND ( ( Recinfo.col140 = p_col140)
3028 OR ( ( Recinfo.col140 IS NULL )
3029 AND ( p_col140 IS NULL )))
3030 AND ( ( Recinfo.col141 = p_col141)
3031 OR ( ( Recinfo.col141 IS NULL )
3032 AND ( p_col141 IS NULL )))
3033 AND ( ( Recinfo.col142 = p_col142)
3034 OR ( ( Recinfo.col142 IS NULL )
3035 AND ( p_col142 IS NULL )))
3036 AND ( ( Recinfo.col143 = p_col143)
3037 OR ( ( Recinfo.col143 IS NULL )
3038 AND ( p_col143 IS NULL )))
3039 AND ( ( Recinfo.col144 = p_col144)
3040 OR ( ( Recinfo.col144 IS NULL )
3041 AND ( p_col144 IS NULL )))
3042 AND ( ( Recinfo.col145 = p_col145)
3043 OR ( ( Recinfo.col145 IS NULL )
3044 AND ( p_col145 IS NULL )))
3045 AND ( ( Recinfo.col146 = p_col146)
3046 OR ( ( Recinfo.col146 IS NULL )
3047 AND ( p_col146 IS NULL )))
3048 AND ( ( Recinfo.col147 = p_col147)
3049 OR ( ( Recinfo.col147 IS NULL )
3050 AND ( p_col147 IS NULL )))
3051 AND ( ( Recinfo.col148 = p_col148)
3052 OR ( ( Recinfo.col148 IS NULL )
3053 AND ( p_col148 IS NULL )))
3054 AND ( ( Recinfo.col149 = p_col149)
3055 OR ( ( Recinfo.col149 IS NULL )
3056 AND ( p_col149 IS NULL )))
3057 AND ( ( Recinfo.col150 = p_col150)
3058 OR ( ( Recinfo.col150 IS NULL )
3059 AND ( p_col150 IS NULL )))
3060 AND ( ( Recinfo.col151 = p_col151)
3061 OR ( ( Recinfo.col151 IS NULL )
3062 AND ( p_col151 IS NULL )))
3063 AND ( ( Recinfo.col152 = p_col152)
3064 OR ( ( Recinfo.col152 IS NULL )
3065 AND ( p_col152 IS NULL )))
3066 AND ( ( Recinfo.col153 = p_col153)
3067 OR ( ( Recinfo.col153 IS NULL )
3068 AND ( p_col153 IS NULL )))
3069 AND ( ( Recinfo.col154 = p_col154)
3070 OR ( ( Recinfo.col154 IS NULL )
3071 AND ( p_col154 IS NULL )))
3072 AND ( ( Recinfo.col155 = p_col155)
3073 OR ( ( Recinfo.col155 IS NULL )
3074 AND ( p_col155 IS NULL )))
3075 AND ( ( Recinfo.col156 = p_col156)
3076 OR ( ( Recinfo.col156 IS NULL )
3077 AND ( p_col156 IS NULL )))
3078 AND ( ( Recinfo.col157 = p_col157)
3079 OR ( ( Recinfo.col157 IS NULL )
3080 AND ( p_col157 IS NULL )))
3081 AND ( ( Recinfo.col158 = p_col158)
3082 OR ( ( Recinfo.col158 IS NULL )
3086 AND ( p_col159 IS NULL )))
3083 AND ( p_col158 IS NULL )))
3084 AND ( ( Recinfo.col159 = p_col159)
3085 OR ( ( Recinfo.col159 IS NULL )
3087 AND ( ( Recinfo.col160 = p_col160)
3088 OR ( ( Recinfo.col160 IS NULL )
3089 AND ( p_col160 IS NULL )))
3090 AND ( ( Recinfo.col161 = p_col161)
3091 OR ( ( Recinfo.col161 IS NULL )
3092 AND ( p_col161 IS NULL )))
3093 AND ( ( Recinfo.col162 = p_col162)
3094 OR ( ( Recinfo.col162 IS NULL )
3095 AND ( p_col162 IS NULL )))
3096 AND ( ( Recinfo.col163 = p_col163)
3097 OR ( ( Recinfo.col163 IS NULL )
3098 AND ( p_col163 IS NULL )))
3099 AND ( ( Recinfo.col164 = p_col164)
3100 OR ( ( Recinfo.col164 IS NULL )
3101 AND ( p_col164 IS NULL )))
3102 AND ( ( Recinfo.col165 = p_col165)
3103 OR ( ( Recinfo.col165 IS NULL )
3104 AND ( p_col165 IS NULL )))
3105 AND ( ( Recinfo.col166 = p_col166)
3106 OR ( ( Recinfo.col166 IS NULL )
3107 AND ( p_col166 IS NULL )))
3108 AND ( ( Recinfo.col167 = p_col167)
3109 OR ( ( Recinfo.col167 IS NULL )
3110 AND ( p_col167 IS NULL )))
3111 AND ( ( Recinfo.col168 = p_col168)
3112 OR ( ( Recinfo.col168 IS NULL )
3113 AND ( p_col168 IS NULL )))
3114 AND ( ( Recinfo.col169 = p_col169)
3115 OR ( ( Recinfo.col169 IS NULL )
3116 AND ( p_col169 IS NULL )))
3117 AND ( ( Recinfo.col170 = p_col170)
3118 OR ( ( Recinfo.col170 IS NULL )
3119 AND ( p_col170 IS NULL )))
3120 AND ( ( Recinfo.col171 = p_col171)
3121 OR ( ( Recinfo.col171 IS NULL )
3122 AND ( p_col171 IS NULL )))
3123 AND ( ( Recinfo.col172 = p_col172)
3124 OR ( ( Recinfo.col172 IS NULL )
3125 AND ( p_col172 IS NULL )))
3126 AND ( ( Recinfo.col173 = p_col173)
3127 OR ( ( Recinfo.col173 IS NULL )
3128 AND ( p_col173 IS NULL )))
3129 AND ( ( Recinfo.col174 = p_col174)
3130 OR ( ( Recinfo.col174 IS NULL )
3131 AND ( p_col174 IS NULL )))
3132 AND ( ( Recinfo.col175 = p_col175)
3133 OR ( ( Recinfo.col175 IS NULL )
3134 AND ( p_col175 IS NULL )))
3135 AND ( ( Recinfo.col176 = p_col176)
3136 OR ( ( Recinfo.col176 IS NULL )
3137 AND ( p_col176 IS NULL )))
3138 AND ( ( Recinfo.col177 = p_col177)
3139 OR ( ( Recinfo.col177 IS NULL )
3140 AND ( p_col177 IS NULL )))
3141 AND ( ( Recinfo.col178 = p_col178)
3142 OR ( ( Recinfo.col178 IS NULL )
3143 AND ( p_col178 IS NULL )))
3144 AND ( ( Recinfo.col179 = p_col179)
3145 OR ( ( Recinfo.col179 IS NULL )
3146 AND ( p_col179 IS NULL )))
3147 AND ( ( Recinfo.col180 = p_col180)
3148 OR ( ( Recinfo.col180 IS NULL )
3149 AND ( p_col180 IS NULL )))
3150 AND ( ( Recinfo.col181 = p_col181)
3151 OR ( ( Recinfo.col181 IS NULL )
3152 AND ( p_col181 IS NULL )))
3153 AND ( ( Recinfo.col182 = p_col182)
3154 OR ( ( Recinfo.col182 IS NULL )
3155 AND ( p_col182 IS NULL )))
3156 AND ( ( Recinfo.col183 = p_col183)
3157 OR ( ( Recinfo.col183 IS NULL )
3158 AND ( p_col183 IS NULL )))
3159 AND ( ( Recinfo.col184 = p_col184)
3160 OR ( ( Recinfo.col184 IS NULL )
3161 AND ( p_col184 IS NULL )))
3162 AND ( ( Recinfo.col185 = p_col185)
3163 OR ( ( Recinfo.col185 IS NULL )
3164 AND ( p_col185 IS NULL )))
3165 AND ( ( Recinfo.col186 = p_col186)
3166 OR ( ( Recinfo.col186 IS NULL )
3167 AND ( p_col186 IS NULL )))
3168 AND ( ( Recinfo.col187 = p_col187)
3169 OR ( ( Recinfo.col187 IS NULL )
3170 AND ( p_col187 IS NULL )))
3171 AND ( ( Recinfo.col188 = p_col188)
3172 OR ( ( Recinfo.col188 IS NULL )
3173 AND ( p_col188 IS NULL )))
3174 AND ( ( Recinfo.col189 = p_col189)
3175 OR ( ( Recinfo.col189 IS NULL )
3176 AND ( p_col189 IS NULL )))
3177 AND ( ( Recinfo.col190 = p_col190)
3178 OR ( ( Recinfo.col190 IS NULL )
3179 AND ( p_col190 IS NULL )))
3180 AND ( ( Recinfo.col191 = p_col191)
3181 OR ( ( Recinfo.col191 IS NULL )
3182 AND ( p_col191 IS NULL )))
3183 AND ( ( Recinfo.col192 = p_col192)
3184 OR ( ( Recinfo.col192 IS NULL )
3185 AND ( p_col192 IS NULL )))
3186 AND ( ( Recinfo.col193 = p_col193)
3187 OR ( ( Recinfo.col193 IS NULL )
3188 AND ( p_col193 IS NULL )))
3189 AND ( ( Recinfo.col194 = p_col194)
3190 OR ( ( Recinfo.col194 IS NULL )
3191 AND ( p_col194 IS NULL )))
3192 AND ( ( Recinfo.col195 = p_col195)
3193 OR ( ( Recinfo.col195 IS NULL )
3194 AND ( p_col195 IS NULL )))
3195 AND ( ( Recinfo.col196 = p_col196)
3196 OR ( ( Recinfo.col196 IS NULL )
3197 AND ( p_col196 IS NULL )))
3198 AND ( ( Recinfo.col197 = p_col197)
3199 OR ( ( Recinfo.col197 IS NULL )
3200 AND ( p_col197 IS NULL )))
3201 AND ( ( Recinfo.col198 = p_col198)
3202 OR ( ( Recinfo.col198 IS NULL )
3206 AND ( p_col199 IS NULL )))
3203 AND ( p_col198 IS NULL )))
3204 AND ( ( Recinfo.col199 = p_col199)
3205 OR ( ( Recinfo.col199 IS NULL )
3207 AND ( ( Recinfo.col200 = p_col200)
3208 OR ( ( Recinfo.col200 IS NULL )
3209 AND ( p_col200 IS NULL )))
3210 AND ( ( Recinfo.col201 = p_col201)
3211 OR ( ( Recinfo.col201 IS NULL )
3212 AND ( p_col201 IS NULL )))
3213 AND ( ( Recinfo.col202 = p_col202)
3214 OR ( ( Recinfo.col202 IS NULL )
3215 AND ( p_col202 IS NULL )))
3216 AND ( ( Recinfo.col203 = p_col203)
3217 OR ( ( Recinfo.col203 IS NULL )
3218 AND ( p_col203 IS NULL )))
3219 AND ( ( Recinfo.col204 = p_col204)
3220 OR ( ( Recinfo.col204 IS NULL )
3221 AND ( p_col204 IS NULL )))
3222 AND ( ( Recinfo.col205 = p_col205)
3223 OR ( ( Recinfo.col205 IS NULL )
3224 AND ( p_col205 IS NULL )))
3225 AND ( ( Recinfo.col206 = p_col206)
3226 OR ( ( Recinfo.col206 IS NULL )
3227 AND ( p_col206 IS NULL )))
3228 AND ( ( Recinfo.col207 = p_col207)
3229 OR ( ( Recinfo.col207 IS NULL )
3230 AND ( p_col207 IS NULL )))
3231 AND ( ( Recinfo.col208 = p_col208)
3232 OR ( ( Recinfo.col208 IS NULL )
3233 AND ( p_col208 IS NULL )))
3234 AND ( ( Recinfo.col209 = p_col209)
3235 OR ( ( Recinfo.col209 IS NULL )
3236 AND ( p_col209 IS NULL )))
3237 AND ( ( Recinfo.col210 = p_col210)
3238 OR ( ( Recinfo.col210 IS NULL )
3239 AND ( p_col210 IS NULL )))
3240 AND ( ( Recinfo.col211 = p_col211)
3241 OR ( ( Recinfo.col211 IS NULL )
3242 AND ( p_col211 IS NULL )))
3243 AND ( ( Recinfo.col212 = p_col212)
3244 OR ( ( Recinfo.col212 IS NULL )
3245 AND ( p_col212 IS NULL )))
3246 AND ( ( Recinfo.col213 = p_col213)
3247 OR ( ( Recinfo.col223 IS NULL )
3248 AND ( p_col213 IS NULL )))
3249 AND ( ( Recinfo.col214 = p_col214)
3250 OR ( ( Recinfo.col214 IS NULL )
3251 AND ( p_col214 IS NULL )))
3252 AND ( ( Recinfo.col215 = p_col215)
3253 OR ( ( Recinfo.col215 IS NULL )
3254 AND ( p_col215 IS NULL )))
3255 AND ( ( Recinfo.col216 = p_col216)
3256 OR ( ( Recinfo.col216 IS NULL )
3257 AND ( p_col216 IS NULL )))
3258 AND ( ( Recinfo.col217 = p_col217)
3259 OR ( ( Recinfo.col217 IS NULL )
3260 AND ( p_col217 IS NULL )))
3261 AND ( ( Recinfo.col218 = p_col218)
3262 OR ( ( Recinfo.col218 IS NULL )
3263 AND ( p_col218 IS NULL )))
3264 AND ( ( Recinfo.col219 = p_col219)
3265 OR ( ( Recinfo.col219 IS NULL )
3266 AND ( p_col219 IS NULL )))
3267 AND ( ( Recinfo.col220 = p_col220)
3268 OR ( ( Recinfo.col220 IS NULL )
3269 AND ( p_col220 IS NULL )))
3270 AND ( ( Recinfo.col221 = p_col221)
3271 OR ( ( Recinfo.col221 IS NULL )
3272 AND ( p_col221 IS NULL )))
3273 AND ( ( Recinfo.col222 = p_col222)
3274 OR ( ( Recinfo.col222 IS NULL )
3275 AND ( p_col222 IS NULL )))
3276 AND ( ( Recinfo.col223 = p_col223)
3277 OR ( ( Recinfo.col223 IS NULL )
3278 AND ( p_col223 IS NULL )))
3279 AND ( ( Recinfo.col224 = p_col224)
3280 OR ( ( Recinfo.col224 IS NULL )
3281 AND ( p_col224 IS NULL )))
3282 AND ( ( Recinfo.col225 = p_col225)
3283 OR ( ( Recinfo.col225 IS NULL )
3284 AND ( p_col225 IS NULL )))
3285 AND ( ( Recinfo.col226 = p_col226)
3286 OR ( ( Recinfo.col226 IS NULL )
3287 AND ( p_col226 IS NULL )))
3288 AND ( ( Recinfo.col227 = p_col227)
3289 OR ( ( Recinfo.col227 IS NULL )
3290 AND ( p_col227 IS NULL )))
3291 AND ( ( Recinfo.col228 = p_col228)
3292 OR ( ( Recinfo.col228 IS NULL )
3293 AND ( p_col228 IS NULL )))
3294 AND ( ( Recinfo.col229 = p_col229)
3295 OR ( ( Recinfo.col229 IS NULL )
3296 AND ( p_col229 IS NULL )))
3297 AND ( ( Recinfo.col230 = p_col230)
3298 OR ( ( Recinfo.col230 IS NULL )
3299 AND ( p_col230 IS NULL )))
3300 AND ( ( Recinfo.col231 = p_col231)
3301 OR ( ( Recinfo.col231 IS NULL )
3302 AND ( p_col231 IS NULL )))
3303 AND ( ( Recinfo.col232 = p_col232)
3304 OR ( ( Recinfo.col232 IS NULL )
3305 AND ( p_col232 IS NULL )))
3306 AND ( ( Recinfo.col233 = p_col233)
3307 OR ( ( Recinfo.col233 IS NULL )
3308 AND ( p_col233 IS NULL )))
3309 AND ( ( Recinfo.col234 = p_col234)
3310 OR ( ( Recinfo.col234 IS NULL )
3311 AND ( p_col234 IS NULL )))
3312 AND ( ( Recinfo.col235 = p_col235)
3313 OR ( ( Recinfo.col235 IS NULL )
3314 AND ( p_col235 IS NULL )))
3315 AND ( ( Recinfo.col236 = p_col236)
3316 OR ( ( Recinfo.col236 IS NULL )
3317 AND ( p_col236 IS NULL )))
3318 AND ( ( Recinfo.col237 = p_col237)
3319 OR ( ( Recinfo.col237 IS NULL )
3320 AND ( p_col237 IS NULL )))
3321 AND ( ( Recinfo.col238 = p_col238)
3325 OR ( ( Recinfo.col239 IS NULL )
3322 OR ( ( Recinfo.col238 IS NULL )
3323 AND ( p_col238 IS NULL )))
3324 AND ( ( Recinfo.col239 = p_col239)
3326 AND ( p_col239 IS NULL )))
3327 AND ( ( Recinfo.col240 = p_col240)
3328 OR ( ( Recinfo.col240 IS NULL )
3329 AND ( p_col240 IS NULL )))
3330 AND ( ( Recinfo.col241 = p_col241)
3331 OR ( ( Recinfo.col241 IS NULL )
3332 AND ( p_col241 IS NULL )))
3333 AND ( ( Recinfo.col242 = p_col242)
3334 OR ( ( Recinfo.col242 IS NULL )
3335 AND ( p_col242 IS NULL )))
3336 AND ( ( Recinfo.col243 = p_col243)
3337 OR ( ( Recinfo.col243 IS NULL )
3338 AND ( p_col243 IS NULL )))
3339 AND ( ( Recinfo.col244 = p_col244)
3340 OR ( ( Recinfo.col244 IS NULL )
3341 AND ( p_col244 IS NULL )))
3342 AND ( ( Recinfo.col245 = p_col245)
3343 OR ( ( Recinfo.col245 IS NULL )
3344 AND ( p_col245 IS NULL )))
3345 AND ( ( Recinfo.col246 = p_col246)
3346 OR ( ( Recinfo.col246 IS NULL )
3347 AND ( p_col246 IS NULL )))
3348 AND ( ( Recinfo.col247 = p_col247)
3349 OR ( ( Recinfo.col247 IS NULL )
3350 AND ( p_col247 IS NULL )))
3351 AND ( ( Recinfo.col248 = p_col248)
3352 OR ( ( Recinfo.col248 IS NULL )
3353 AND ( p_col248 IS NULL )))
3354 AND ( ( Recinfo.col249 = p_col249)
3355 OR ( ( Recinfo.col249 IS NULL )
3356 AND ( p_col249 IS NULL )))
3357 AND ( ( Recinfo.col250 = p_col250)
3358 OR ( ( Recinfo.col250 IS NULL )
3359 AND ( p_col250 IS NULL )))
3360 AND ( ( Recinfo.col251 = p_col251)
3361 OR ( ( Recinfo.col251 IS NULL )
3362 AND ( p_col251 IS NULL )))
3363 AND ( ( Recinfo.col252 = p_col252)
3364 OR ( ( Recinfo.col252 IS NULL )
3365 AND ( p_col252 IS NULL )))
3366 AND ( ( Recinfo.col253 = p_col253)
3367 OR ( ( Recinfo.col253 IS NULL )
3368 AND ( p_col253 IS NULL )))
3369 AND ( ( Recinfo.col254 = p_col254)
3370 OR ( ( Recinfo.col254 IS NULL )
3371 AND ( p_col254 IS NULL )))
3372 AND ( ( Recinfo.col255 = p_col255)
3373 OR ( ( Recinfo.col255 IS NULL )
3374 AND ( p_col255 IS NULL )))
3375 AND ( ( Recinfo.col256 = p_col256)
3376 OR ( ( Recinfo.col256 IS NULL )
3377 AND ( p_col256 IS NULL )))
3378 AND ( ( Recinfo.col257 = p_col257)
3379 OR ( ( Recinfo.col257 IS NULL )
3380 AND ( p_col257 IS NULL )))
3381 AND ( ( Recinfo.col258 = p_col258)
3382 OR ( ( Recinfo.col258 IS NULL )
3383 AND ( p_col258 IS NULL )))
3384 AND ( ( Recinfo.col259 = p_col259)
3385 OR ( ( Recinfo.col259 IS NULL )
3386 AND ( p_col259 IS NULL )))
3387 AND ( ( Recinfo.col260 = p_col260)
3388 OR ( ( Recinfo.col260 IS NULL )
3389 AND ( p_col260 IS NULL )))
3390 AND ( ( Recinfo.col261 = p_col261)
3391 OR ( ( Recinfo.col261 IS NULL )
3392 AND ( p_col261 IS NULL )))
3393 AND ( ( Recinfo.col262 = p_col262)
3394 OR ( ( Recinfo.col262 IS NULL )
3395 AND ( p_col262 IS NULL )))
3396 AND ( ( Recinfo.col263 = p_col263)
3397 OR ( ( Recinfo.col263 IS NULL )
3398 AND ( p_col263 IS NULL )))
3399 AND ( ( Recinfo.col264 = p_col264)
3400 OR ( ( Recinfo.col264 IS NULL )
3401 AND ( p_col264 IS NULL )))
3402 AND ( ( Recinfo.col265 = p_col265)
3403 OR ( ( Recinfo.col265 IS NULL )
3404 AND ( p_col265 IS NULL )))
3405 AND ( ( Recinfo.col266 = p_col266)
3406 OR ( ( Recinfo.col266 IS NULL )
3407 AND ( p_col266 IS NULL )))
3408 AND ( ( Recinfo.col267 = p_col267)
3409 OR ( ( Recinfo.col267 IS NULL )
3410 AND ( p_col267 IS NULL )))
3411 AND ( ( Recinfo.col268 = p_col268)
3412 OR ( ( Recinfo.col268 IS NULL )
3413 AND ( p_col268 IS NULL )))
3414 AND ( ( Recinfo.col269 = p_col269)
3415 OR ( ( Recinfo.col269 IS NULL )
3416 AND ( p_col269 IS NULL )))
3417 AND ( ( Recinfo.col270 = p_col270)
3418 OR ( ( Recinfo.col270 IS NULL )
3419 AND ( p_col270 IS NULL )))
3420 AND ( ( Recinfo.col271 = p_col271)
3421 OR ( ( Recinfo.col271 IS NULL )
3422 AND ( p_col271 IS NULL )))
3423 AND ( ( Recinfo.col272 = p_col272)
3424 OR ( ( Recinfo.col272 IS NULL )
3425 AND ( p_col272 IS NULL )))
3426 AND ( ( Recinfo.col273 = p_col273)
3427 OR ( ( Recinfo.col273 IS NULL )
3428 AND ( p_col273 IS NULL )))
3429 AND ( ( Recinfo.col274 = p_col274)
3430 OR ( ( Recinfo.col274 IS NULL )
3431 AND ( p_col274 IS NULL )))
3432 AND ( ( Recinfo.col275 = p_col275)
3433 OR ( ( Recinfo.col275 IS NULL )
3434 AND ( p_col275 IS NULL )))
3435 AND ( ( Recinfo.col276 = p_col276)
3436 OR ( ( Recinfo.col276 IS NULL )
3437 AND ( p_col276 IS NULL )))
3438 AND ( ( Recinfo.col277 = p_col277)
3439 OR ( ( Recinfo.col277 IS NULL )
3440 AND ( p_col277 IS NULL )))
3441 AND ( ( Recinfo.col278 = p_col278)
3445 OR ( ( Recinfo.col279 IS NULL )
3442 OR ( ( Recinfo.col278 IS NULL )
3443 AND ( p_col278 IS NULL )))
3444 AND ( ( Recinfo.col279 = p_col279)
3446 AND ( p_col279 IS NULL )))
3447 AND ( ( Recinfo.col280 = p_col280)
3448 OR ( ( Recinfo.col280 IS NULL )
3449 AND ( p_col280 IS NULL )))
3450 AND ( ( Recinfo.col281 = p_col281)
3451 OR ( ( Recinfo.col281 IS NULL )
3452 AND ( p_col281 IS NULL )))
3453 AND ( ( Recinfo.col282 = p_col282)
3454 OR ( ( Recinfo.col282 IS NULL )
3455 AND ( p_col282 IS NULL )))
3456 AND ( ( Recinfo.col283 = p_col283)
3457 OR ( ( Recinfo.col283 IS NULL )
3458 AND ( p_col283 IS NULL )))
3459 AND ( ( Recinfo.col284 = p_col284)
3460 OR ( ( Recinfo.col284 IS NULL )
3461 AND ( p_col284 IS NULL )))
3462 AND ( ( Recinfo.col285 = p_col285)
3463 OR ( ( Recinfo.col285 IS NULL )
3464 AND ( p_col285 IS NULL )))
3465 AND ( ( Recinfo.col286 = p_col286)
3466 OR ( ( Recinfo.col286 IS NULL )
3467 AND ( p_col286 IS NULL )))
3468 AND ( ( Recinfo.col287 = p_col287)
3469 OR ( ( Recinfo.col287 IS NULL )
3470 AND ( p_col287 IS NULL )))
3471 AND ( ( Recinfo.col288 = p_col288)
3472 OR ( ( Recinfo.col288 IS NULL )
3473 AND ( p_col288 IS NULL )))
3474 AND ( ( Recinfo.col289 = p_col289)
3475 OR ( ( Recinfo.col289 IS NULL )
3476 AND ( p_col289 IS NULL )))
3477 AND ( ( Recinfo.col290 = p_col290)
3478 OR ( ( Recinfo.col290 IS NULL )
3479 AND ( p_col290 IS NULL )))
3480 AND ( ( Recinfo.col291 = p_col291)
3481 OR ( ( Recinfo.col291 IS NULL )
3482 AND ( p_col291 IS NULL )))
3483 AND ( ( Recinfo.col292 = p_col292)
3484 OR ( ( Recinfo.col292 IS NULL )
3485 AND ( p_col292 IS NULL )))
3486 AND ( ( Recinfo.col293 = p_col293)
3487 OR ( ( Recinfo.col293 IS NULL )
3488 AND ( p_col293 IS NULL )))
3489 AND ( ( Recinfo.col294 = p_col294)
3490 OR ( ( Recinfo.col294 IS NULL )
3491 AND ( p_col294 IS NULL )))
3492 AND ( ( Recinfo.col295 = p_col295)
3493 OR ( ( Recinfo.col295 IS NULL )
3494 AND ( p_col295 IS NULL )))
3495 AND ( ( Recinfo.col296 = p_col296)
3496 OR ( ( Recinfo.col296 IS NULL )
3497 AND ( p_col296 IS NULL )))
3498 AND ( ( Recinfo.col297 = p_col297)
3499 OR ( ( Recinfo.col297 IS NULL )
3500 AND ( p_col297 IS NULL )))
3501 AND ( ( Recinfo.col298 = p_col298)
3502 OR ( ( Recinfo.col298 IS NULL )
3503 AND ( p_col298 IS NULL )))
3504 AND ( ( Recinfo.col299 = p_col299)
3505 OR ( ( Recinfo.col299 IS NULL )
3506 AND ( p_col299 IS NULL )))
3507 AND ( ( Recinfo.col300 = p_col300)
3508 OR ( ( Recinfo.col300 IS NULL )
3509 AND ( p_col300 IS NULL )))
3510 AND ( ( Recinfo.party_id = p_party_id)
3511 OR ( ( Recinfo.party_id IS NULL )
3512 AND ( p_party_id IS NULL )))
3513 AND ( ( Recinfo.parent_party_id = p_parent_party_id)
3514 OR ( ( Recinfo.parent_party_id IS NULL )
3515 AND ( p_parent_party_id IS NULL )))
3516 -- AND ( ( Recinfo.geometry = p_geometry)
3517 -- OR ( ( Recinfo.geometry IS NULL )
3518 -- AND ( p_geometry IS NULL )))
3519 AND ( ( Recinfo.imp_source_line_id = p_imp_source_line_id)
3520 OR ( ( Recinfo.imp_source_line_id IS NULL )
3521 AND ( p_imp_source_line_id IS NULL )))
3522 AND ( ( Recinfo.usage_restriction = p_usage_restriction)
3523 OR ( ( Recinfo.usage_restriction IS NULL )
3524 AND ( p_usage_restriction IS NULL )))
3525 AND ( ( Recinfo.next_call_time = p_next_call_time)
3526 OR ( ( Recinfo.next_call_time IS NULL )
3527 AND ( p_next_call_time IS NULL )))
3528 AND ( ( Recinfo.callback_flag = p_callback_flag)
3529 OR ( ( Recinfo.callback_flag IS NULL )
3530 AND ( p_callback_flag IS NULL )))
3531 AND ( ( Recinfo.do_not_use_flag = p_do_not_use_flag)
3532 OR ( ( Recinfo.do_not_use_flag IS NULL )
3533 AND ( p_do_not_use_flag IS NULL )))
3534 AND ( ( Recinfo.do_not_use_reason = p_do_not_use_reason)
3535 OR ( ( Recinfo.do_not_use_reason IS NULL )
3536 AND ( p_do_not_use_reason IS NULL )))
3537 AND ( ( Recinfo.record_out_flag = p_record_out_flag)
3538 OR ( ( Recinfo.record_out_flag IS NULL )
3539 AND ( p_record_out_flag IS NULL )))
3540 AND ( ( Recinfo.record_release_time = p_record_release_time)
3541 OR ( ( Recinfo.record_release_time IS NULL )
3542 AND ( p_record_release_time IS NULL )))
3543 AND ( ( Recinfo.group_code = p_group_code)
3544 OR ( ( Recinfo.group_code IS NULL )
3545 AND ( p_group_code IS NULL )))
3546 AND ( ( Recinfo.newly_updated_flag = p_newly_updated_flag)
3547 OR ( ( Recinfo.newly_updated_flag IS NULL )
3548 AND ( p_newly_updated_flag IS NULL )))
3549 AND ( ( Recinfo.outcome_id = p_outcome_id)
3550 OR ( ( Recinfo.outcome_id IS NULL )
3551 AND ( p_outcome_id IS NULL )))
3552 AND ( ( Recinfo.result_id = p_result_id)
3553 OR ( ( Recinfo.result_id IS NULL )
3557 AND ( p_reason_id IS NULL )))
3554 AND ( p_result_id IS NULL )))
3555 AND ( ( Recinfo.reason_id = p_reason_id)
3556 OR ( ( Recinfo.reason_id IS NULL )
3558 ) THEN
3559 RETURN;
3560 ELSE
3561 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
3562 APP_EXCEPTION.RAISE_EXCEPTION;
3563 END IF;
3564 END Lock_Row;
3565
3566 END AMS_LIST_ENTRIES_PKG;