[Home] [Help]
PACKAGE BODY: APPS.AMS_IMP_SOURCE_LINES_PKG
Source
1 PACKAGE BODY AMS_IMP_SOURCE_LINES_PKG as
2 /* $Header: amstislb.pls 115.9 2004/01/22 01:13:53 sranka ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_IMP_SOURCE_LINES_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_IMP_SOURCE_LINES_PKG';
18 G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstislb.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_import_source_line_id IN OUT NOCOPY NUMBER,
43 px_object_version_number IN OUT NOCOPY 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 p_import_list_header_id NUMBER,
50 p_import_successful_flag VARCHAR2,
51 p_enabled_flag VARCHAR2,
52 p_import_failure_reason VARCHAR2,
53 p_re_import_last_done_date DATE,
54 p_party_id NUMBER,
55 p_dedupe_key VARCHAR2,
56 p_col1 VARCHAR2,
57 p_col2 VARCHAR2,
58 p_col3 VARCHAR2,
59 p_col4 VARCHAR2,
60 p_col5 VARCHAR2,
61 p_col6 VARCHAR2,
62 p_col7 VARCHAR2,
63 p_col8 VARCHAR2,
64 p_col9 VARCHAR2,
65 p_col10 VARCHAR2,
66 p_col11 VARCHAR2,
67 p_col12 VARCHAR2,
68 p_col13 VARCHAR2,
69 p_col14 VARCHAR2,
70 p_col15 VARCHAR2,
71 p_col16 VARCHAR2,
72 p_col17 VARCHAR2,
73 p_col18 VARCHAR2,
74 p_col19 VARCHAR2,
75 p_col20 VARCHAR2,
76 p_col21 VARCHAR2,
77 p_col22 VARCHAR2,
78 p_col23 VARCHAR2,
79 p_col24 VARCHAR2,
80 p_col25 VARCHAR2,
81 p_col26 VARCHAR2,
82 p_col27 VARCHAR2,
83 p_col28 VARCHAR2,
84 p_col29 VARCHAR2,
85 p_col30 VARCHAR2,
86 p_col31 VARCHAR2,
87 p_col32 VARCHAR2,
88 p_col33 VARCHAR2,
89 p_col34 VARCHAR2,
90 p_col35 VARCHAR2,
91 p_col36 VARCHAR2,
92 p_col37 VARCHAR2,
93 p_col38 VARCHAR2,
94 p_col39 VARCHAR2,
95 p_col40 VARCHAR2,
96 p_col41 VARCHAR2,
97 p_col42 VARCHAR2,
98 p_col43 VARCHAR2,
99 p_col44 VARCHAR2,
100 p_col45 VARCHAR2,
101 p_col46 VARCHAR2,
102 p_col47 VARCHAR2,
103 p_col48 VARCHAR2,
104 p_col49 VARCHAR2,
105 p_col50 VARCHAR2,
106 p_col51 VARCHAR2,
107 p_col52 VARCHAR2,
108 p_col53 VARCHAR2,
109 p_col54 VARCHAR2,
110 p_col55 VARCHAR2,
111 p_col56 VARCHAR2,
112 p_col57 VARCHAR2,
113 p_col58 VARCHAR2,
114 p_col59 VARCHAR2,
115 p_col60 VARCHAR2,
116 p_col61 VARCHAR2,
117 p_col62 VARCHAR2,
118 p_col63 VARCHAR2,
119 p_col64 VARCHAR2,
120 p_col65 VARCHAR2,
121 p_col66 VARCHAR2,
122 p_col67 VARCHAR2,
123 p_col68 VARCHAR2,
124 p_col69 VARCHAR2,
125 p_col70 VARCHAR2,
126 p_col71 VARCHAR2,
127 p_col72 VARCHAR2,
128 p_col73 VARCHAR2,
129 p_col74 VARCHAR2,
130 p_col75 VARCHAR2,
131 p_col76 VARCHAR2,
132 p_col77 VARCHAR2,
133 p_col78 VARCHAR2,
134 p_col79 VARCHAR2,
135 p_col80 VARCHAR2,
136 p_col81 VARCHAR2,
137 p_col82 VARCHAR2,
138 p_col83 VARCHAR2,
139 p_col84 VARCHAR2,
140 p_col85 VARCHAR2,
141 p_col86 VARCHAR2,
142 p_col87 VARCHAR2,
143 p_col88 VARCHAR2,
144 p_col89 VARCHAR2,
145 p_col90 VARCHAR2,
146 p_col91 VARCHAR2,
147 p_col92 VARCHAR2,
148 p_col93 VARCHAR2,
149 p_col94 VARCHAR2,
150 p_col95 VARCHAR2,
151 p_col96 VARCHAR2,
152 p_col97 VARCHAR2,
153 p_col98 VARCHAR2,
154 p_col99 VARCHAR2,
155 p_col100 VARCHAR2,
156 p_col101 VARCHAR2,
157 p_col102 VARCHAR2,
158 p_col103 VARCHAR2,
159 p_col104 VARCHAR2,
160 p_col105 VARCHAR2,
161 p_col106 VARCHAR2,
162 p_col107 VARCHAR2,
163 p_col108 VARCHAR2,
164 p_col109 VARCHAR2,
165 p_col110 VARCHAR2,
166 p_col111 VARCHAR2,
167 p_col112 VARCHAR2,
168 p_col113 VARCHAR2,
169 p_col114 VARCHAR2,
170 p_col115 VARCHAR2,
171 p_col116 VARCHAR2,
172 p_col117 VARCHAR2,
173 p_col118 VARCHAR2,
174 p_col119 VARCHAR2,
175 p_col120 VARCHAR2,
176 p_col121 VARCHAR2,
177 p_col122 VARCHAR2,
178 p_col123 VARCHAR2,
179 p_col124 VARCHAR2,
180 p_col125 VARCHAR2,
181 p_col126 VARCHAR2,
182 p_col127 VARCHAR2,
183 p_col128 VARCHAR2,
184 p_col129 VARCHAR2,
185 p_col130 VARCHAR2,
186 p_col131 VARCHAR2,
187 p_col132 VARCHAR2,
188 p_col133 VARCHAR2,
189 p_col134 VARCHAR2,
190 p_col135 VARCHAR2,
191 p_col136 VARCHAR2,
192 p_col137 VARCHAR2,
193 p_col138 VARCHAR2,
194 p_col139 VARCHAR2,
195 p_col140 VARCHAR2,
196 p_col141 VARCHAR2,
197 p_col142 VARCHAR2,
198 p_col143 VARCHAR2,
199 p_col144 VARCHAR2,
200 p_col145 VARCHAR2,
201 p_col146 VARCHAR2,
202 p_col147 VARCHAR2,
203 p_col148 VARCHAR2,
204 p_col149 VARCHAR2,
205 p_col150 VARCHAR2,
206 p_col151 VARCHAR2,
207 p_col152 VARCHAR2,
208 p_col153 VARCHAR2,
209 p_col154 VARCHAR2,
210 p_col155 VARCHAR2,
211 p_col156 VARCHAR2,
212 p_col157 VARCHAR2,
213 p_col158 VARCHAR2,
214 p_col159 VARCHAR2,
215 p_col160 VARCHAR2,
216 p_col161 VARCHAR2,
217 p_col162 VARCHAR2,
218 p_col163 VARCHAR2,
219 p_col164 VARCHAR2,
220 p_col165 VARCHAR2,
221 p_col166 VARCHAR2,
222 p_col167 VARCHAR2,
223 p_col168 VARCHAR2,
224 p_col169 VARCHAR2,
225 p_col170 VARCHAR2,
226 p_col171 VARCHAR2,
227 p_col172 VARCHAR2,
228 p_col173 VARCHAR2,
229 p_col174 VARCHAR2,
230 p_col175 VARCHAR2,
231 p_col176 VARCHAR2,
232 p_col177 VARCHAR2,
233 p_col178 VARCHAR2,
234 p_col179 VARCHAR2,
235 p_col180 VARCHAR2,
236 p_col181 VARCHAR2,
237 p_col182 VARCHAR2,
238 p_col183 VARCHAR2,
239 p_col184 VARCHAR2,
240 p_col185 VARCHAR2,
241 p_col186 VARCHAR2,
242 p_col187 VARCHAR2,
243 p_col188 VARCHAR2,
244 p_col189 VARCHAR2,
245 p_col190 VARCHAR2,
246 p_col191 VARCHAR2,
247 p_col192 VARCHAR2,
248 p_col193 VARCHAR2,
249 p_col194 VARCHAR2,
250 p_col195 VARCHAR2,
251 p_col196 VARCHAR2,
252 p_col197 VARCHAR2,
253 p_col198 VARCHAR2,
254 p_col199 VARCHAR2,
255 p_col200 VARCHAR2,
256 p_col201 VARCHAR2,
257 p_col202 VARCHAR2,
258 p_col203 VARCHAR2,
259 p_col204 VARCHAR2,
260 p_col205 VARCHAR2,
261 p_col206 VARCHAR2,
262 p_col207 VARCHAR2,
263 p_col208 VARCHAR2,
264 p_col209 VARCHAR2,
265 p_col210 VARCHAR2,
266 p_col211 VARCHAR2,
267 p_col212 VARCHAR2,
268 p_col213 VARCHAR2,
269 p_col214 VARCHAR2,
270 p_col215 VARCHAR2,
271 p_col216 VARCHAR2,
272 p_col217 VARCHAR2,
273 p_col218 VARCHAR2,
274 p_col219 VARCHAR2,
275 p_col220 VARCHAR2,
276 p_col221 VARCHAR2,
277 p_col222 VARCHAR2,
278 p_col223 VARCHAR2,
279 p_col224 VARCHAR2,
280 p_col225 VARCHAR2,
281 p_col226 VARCHAR2,
282 p_col227 VARCHAR2,
283 p_col228 VARCHAR2,
284 p_col229 VARCHAR2,
285 p_col230 VARCHAR2,
286 p_col231 VARCHAR2,
287 p_col232 VARCHAR2,
288 p_col233 VARCHAR2,
289 p_col234 VARCHAR2,
290 p_col235 VARCHAR2,
291 p_col236 VARCHAR2,
292 p_col237 VARCHAR2,
293 p_col238 VARCHAR2,
294 p_col239 VARCHAR2,
295 p_col240 VARCHAR2,
296 p_col241 VARCHAR2,
297 p_col242 VARCHAR2,
298 p_col243 VARCHAR2,
299 p_col244 VARCHAR2,
300 p_col245 VARCHAR2,
301 p_col246 VARCHAR2,
302 p_col247 VARCHAR2,
303 p_col248 VARCHAR2,
304 p_col249 VARCHAR2,
305 p_col250 VARCHAR2,
306 p_duplicate_flag VARCHAR2,
307 p_current_usage NUMBER,
308 p_notes VARCHAR2,
309 p_sales_agent_email_address VARCHAR2,
310 p_vehicle_response_code VARCHAR2,
311 p_custom_column1 VARCHAR2,
312 p_custom_column2 VARCHAR2,
313 p_custom_column3 VARCHAR2,
314 p_custom_column4 VARCHAR2,
315 p_custom_column5 VARCHAR2,
316 p_custom_column6 VARCHAR2,
317 p_custom_column7 VARCHAR2,
318 p_custom_column8 VARCHAR2,
319 p_custom_column9 VARCHAR2,
320 p_custom_column10 VARCHAR2,
321 p_custom_column11 VARCHAR2,
322 p_custom_column12 VARCHAR2,
323 p_custom_column13 VARCHAR2,
324 p_custom_column14 VARCHAR2,
325 p_custom_column15 VARCHAR2,
326 p_custom_column16 VARCHAR2,
327 p_custom_column17 VARCHAR2,
328 p_custom_column18 VARCHAR2,
329 p_custom_column19 VARCHAR2,
330 p_custom_column20 VARCHAR2,
331 p_custom_column21 VARCHAR2,
332 p_custom_column22 VARCHAR2,
333 p_custom_column23 VARCHAR2,
334 p_custom_column24 VARCHAR2,
335 p_custom_column25 VARCHAR2
336
337 )
338
339 IS
340 x_rowid VARCHAR2(30);
341
342
343 BEGIN
344
345
346 px_object_version_number := 1;
347
348
349 INSERT INTO AMS_IMP_SOURCE_LINES(
350 import_source_line_id,
351 object_version_number,
352 last_update_date,
353 last_updated_by,
354 creation_date,
355 created_by,
356 last_update_login,
357 import_list_header_id,
358 import_successful_flag,
359 enabled_flag,
360 import_failure_reason,
361 re_import_last_done_date,
362 party_id,
363 dedupe_key,
364 col1,
365 col2,
366 col3,
367 col4,
368 col5,
369 col6,
370 col7,
371 col8,
372 col9,
373 col10,
374 col11,
375 col12,
376 col13,
377 col14,
378 col15,
379 col16,
380 col17,
381 col18,
382 col19,
383 col20,
384 col21,
385 col22,
386 col23,
387 col24,
388 col25,
389 col26,
390 col27,
391 col28,
392 col29,
393 col30,
394 col31,
395 col32,
396 col33,
400 col37,
397 col34,
398 col35,
399 col36,
401 col38,
402 col39,
403 col40,
404 col41,
405 col42,
406 col43,
407 col44,
408 col45,
409 col46,
410 col47,
411 col48,
412 col49,
413 col50,
414 col51,
415 col52,
416 col53,
417 col54,
418 col55,
419 col56,
420 col57,
421 col58,
422 col59,
423 col60,
424 col61,
425 col62,
426 col63,
427 col64,
428 col65,
429 col66,
430 col67,
431 col68,
432 col69,
433 col70,
434 col71,
435 col72,
436 col73,
437 col74,
438 col75,
439 col76,
440 col77,
441 col78,
442 col79,
443 col80,
444 col81,
445 col82,
446 col83,
447 col84,
448 col85,
449 col86,
450 col87,
451 col88,
452 col89,
453 col90,
454 col91,
455 col92,
456 col93,
457 col94,
458 col95,
459 col96,
460 col97,
461 col98,
462 col99,
463 col100,
464 col101,
465 col102,
466 col103,
467 col104,
468 col105,
469 col106,
470 col107,
471 col108,
472 col109,
473 col110,
474 col111,
475 col112,
476 col113,
477 col114,
478 col115,
479 col116,
480 col117,
481 col118,
482 col119,
483 col120,
484 col121,
485 col122,
486 col123,
487 col124,
488 col125,
489 col126,
490 col127,
491 col128,
492 col129,
493 col130,
494 col131,
495 col132,
496 col133,
497 col134,
498 col135,
499 col136,
500 col137,
501 col138,
502 col139,
503 col140,
504 col141,
505 col142,
506 col143,
507 col144,
508 col145,
509 col146,
510 col147,
511 col148,
512 col149,
513 col150,
514 col151,
515 col152,
516 col153,
517 col154,
518 col155,
519 col156,
520 col157,
521 col158,
522 col159,
523 col160,
524 col161,
525 col162,
526 col163,
527 col164,
528 col165,
529 col166,
530 col167,
531 col168,
532 col169,
533 col170,
534 col171,
535 col172,
536 col173,
537 col174,
538 col175,
539 col176,
540 col177,
541 col178,
542 col179,
543 col180,
544 col181,
545 col182,
546 col183,
547 col184,
548 col185,
549 col186,
550 col187,
551 col188,
552 col189,
553 col190,
554 col191,
555 col192,
556 col193,
557 col194,
558 col195,
559 col196,
560 col197,
561 col198,
562 col199,
563 col200,
564 col201,
565 col202,
566 col203,
567 col204,
568 col205,
569 col206,
570 col207,
571 col208,
572 col209,
573 col210,
574 col211,
575 col212,
576 col213,
577 col214,
578 col215,
579 col216,
580 col217,
581 col218,
582 col219,
583 col220,
584 col221,
585 col222,
586 col223,
587 col224,
588 col225,
589 col226,
590 col227,
591 col228,
592 col229,
596 col233,
593 col230,
594 col231,
595 col232,
597 col234,
598 col235,
599 col236,
600 col237,
601 col238,
602 col239,
603 col240,
604 col241,
605 col242,
606 col243,
607 col244,
608 col245,
609 col246,
610 col247,
611 col248,
612 col249,
613 col250,
614 duplicate_flag,
615 current_usage,
616 load_status,
617 notes ,
618 sales_agent_email_address,
619 vehicle_response_code,
620 custom_column1,
621 custom_column2,
622 custom_column3,
623 custom_column4,
624 custom_column5,
625 custom_column6,
626 custom_column7,
627 custom_column8,
628 custom_column9,
629 custom_column10,
630 custom_column11,
631 custom_column12,
632 custom_column13,
633 custom_column14,
634 custom_column15,
635 custom_column16,
636 custom_column17,
637 custom_column18,
638 custom_column19,
639 custom_column20,
640 custom_column21,
641 custom_column22,
642 custom_column23,
643 custom_column24,
644 custom_column25
645
646
647 ) VALUES (
648 DECODE( px_import_source_line_id, FND_API.g_miss_num, NULL, px_import_source_line_id),
649 DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
650 DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
651 DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
652 DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
653 DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
654 DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
655 DECODE( p_import_list_header_id, FND_API.g_miss_num, NULL, p_import_list_header_id),
656 DECODE( p_import_successful_flag, FND_API.g_miss_char, NULL, p_import_successful_flag),
657 DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
658 DECODE( p_import_failure_reason, FND_API.g_miss_char, NULL, p_import_failure_reason),
659 DECODE( p_re_import_last_done_date, FND_API.g_miss_date, NULL, p_re_import_last_done_date),
660 DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id),
661 DECODE( p_dedupe_key, FND_API.g_miss_char, NULL, p_dedupe_key),
662 DECODE( p_col1, FND_API.g_miss_char, NULL, p_col1),
663 DECODE( p_col2, FND_API.g_miss_char, NULL, p_col2),
664 DECODE( p_col3, FND_API.g_miss_char, NULL, p_col3),
665 DECODE( p_col4, FND_API.g_miss_char, NULL, p_col4),
666 DECODE( p_col5, FND_API.g_miss_char, NULL, p_col5),
667 DECODE( p_col6, FND_API.g_miss_char, NULL, p_col6),
668 DECODE( p_col7, FND_API.g_miss_char, NULL, p_col7),
669 DECODE( p_col8, FND_API.g_miss_char, NULL, p_col8),
670 DECODE( p_col9, FND_API.g_miss_char, NULL, p_col9),
671 DECODE( p_col10, FND_API.g_miss_char, NULL, p_col10),
672 DECODE( p_col11, FND_API.g_miss_char, NULL, p_col11),
673 DECODE( p_col12, FND_API.g_miss_char, NULL, p_col12),
674 DECODE( p_col13, FND_API.g_miss_char, NULL, p_col13),
675 DECODE( p_col14, FND_API.g_miss_char, NULL, p_col14),
676 DECODE( p_col15, FND_API.g_miss_char, NULL, p_col15),
677 DECODE( p_col16, FND_API.g_miss_char, NULL, p_col16),
678 DECODE( p_col17, FND_API.g_miss_char, NULL, p_col17),
679 DECODE( p_col18, FND_API.g_miss_char, NULL, p_col18),
680 DECODE( p_col19, FND_API.g_miss_char, NULL, p_col19),
681 DECODE( p_col20, FND_API.g_miss_char, NULL, p_col20),
682 DECODE( p_col21, FND_API.g_miss_char, NULL, p_col21),
683 DECODE( p_col22, FND_API.g_miss_char, NULL, p_col22),
684 DECODE( p_col23, FND_API.g_miss_char, NULL, p_col23),
685 DECODE( p_col24, FND_API.g_miss_char, NULL, p_col24),
686 DECODE( p_col25, FND_API.g_miss_char, NULL, p_col25),
687 DECODE( p_col26, FND_API.g_miss_char, NULL, p_col26),
688 DECODE( p_col27, FND_API.g_miss_char, NULL, p_col27),
689 DECODE( p_col28, FND_API.g_miss_char, NULL, p_col28),
690 DECODE( p_col29, FND_API.g_miss_char, NULL, p_col29),
691 DECODE( p_col30, FND_API.g_miss_char, NULL, p_col30),
692 DECODE( p_col31, FND_API.g_miss_char, NULL, p_col31),
693 DECODE( p_col32, FND_API.g_miss_char, NULL, p_col32),
694 DECODE( p_col33, FND_API.g_miss_char, NULL, p_col33),
695 DECODE( p_col34, FND_API.g_miss_char, NULL, p_col34),
696 DECODE( p_col35, FND_API.g_miss_char, NULL, p_col35),
697 DECODE( p_col36, FND_API.g_miss_char, NULL, p_col36),
698 DECODE( p_col37, FND_API.g_miss_char, NULL, p_col37),
699 DECODE( p_col38, FND_API.g_miss_char, NULL, p_col38),
700 DECODE( p_col39, FND_API.g_miss_char, NULL, p_col39),
701 DECODE( p_col40, FND_API.g_miss_char, NULL, p_col40),
702 DECODE( p_col41, FND_API.g_miss_char, NULL, p_col41),
703 DECODE( p_col42, FND_API.g_miss_char, NULL, p_col42),
704 DECODE( p_col43, FND_API.g_miss_char, NULL, p_col43),
705 DECODE( p_col44, FND_API.g_miss_char, NULL, p_col44),
706 DECODE( p_col45, FND_API.g_miss_char, NULL, p_col45),
707 DECODE( p_col46, FND_API.g_miss_char, NULL, p_col46),
708 DECODE( p_col47, FND_API.g_miss_char, NULL, p_col47),
709 DECODE( p_col48, FND_API.g_miss_char, NULL, p_col48),
710 DECODE( p_col49, FND_API.g_miss_char, NULL, p_col49),
714 DECODE( p_col53, FND_API.g_miss_char, NULL, p_col53),
711 DECODE( p_col50, FND_API.g_miss_char, NULL, p_col50),
712 DECODE( p_col51, FND_API.g_miss_char, NULL, p_col51),
713 DECODE( p_col52, FND_API.g_miss_char, NULL, p_col52),
715 DECODE( p_col54, FND_API.g_miss_char, NULL, p_col54),
716 DECODE( p_col55, FND_API.g_miss_char, NULL, p_col55),
717 DECODE( p_col56, FND_API.g_miss_char, NULL, p_col56),
718 DECODE( p_col57, FND_API.g_miss_char, NULL, p_col57),
719 DECODE( p_col58, FND_API.g_miss_char, NULL, p_col58),
720 DECODE( p_col59, FND_API.g_miss_char, NULL, p_col59),
721 DECODE( p_col60, FND_API.g_miss_char, NULL, p_col60),
722 DECODE( p_col61, FND_API.g_miss_char, NULL, p_col61),
723 DECODE( p_col62, FND_API.g_miss_char, NULL, p_col62),
724 DECODE( p_col63, FND_API.g_miss_char, NULL, p_col63),
725 DECODE( p_col64, FND_API.g_miss_char, NULL, p_col64),
726 DECODE( p_col65, FND_API.g_miss_char, NULL, p_col65),
727 DECODE( p_col66, FND_API.g_miss_char, NULL, p_col66),
728 DECODE( p_col67, FND_API.g_miss_char, NULL, p_col67),
729 DECODE( p_col68, FND_API.g_miss_char, NULL, p_col68),
730 DECODE( p_col69, FND_API.g_miss_char, NULL, p_col69),
731 DECODE( p_col70, FND_API.g_miss_char, NULL, p_col70),
732 DECODE( p_col71, FND_API.g_miss_char, NULL, p_col71),
733 DECODE( p_col72, FND_API.g_miss_char, NULL, p_col72),
734 DECODE( p_col73, FND_API.g_miss_char, NULL, p_col73),
735 DECODE( p_col74, FND_API.g_miss_char, NULL, p_col74),
736 DECODE( p_col75, FND_API.g_miss_char, NULL, p_col75),
737 DECODE( p_col76, FND_API.g_miss_char, NULL, p_col76),
738 DECODE( p_col77, FND_API.g_miss_char, NULL, p_col77),
739 DECODE( p_col78, FND_API.g_miss_char, NULL, p_col78),
740 DECODE( p_col79, FND_API.g_miss_char, NULL, p_col79),
741 DECODE( p_col80, FND_API.g_miss_char, NULL, p_col80),
742 DECODE( p_col81, FND_API.g_miss_char, NULL, p_col81),
743 DECODE( p_col82, FND_API.g_miss_char, NULL, p_col82),
744 DECODE( p_col83, FND_API.g_miss_char, NULL, p_col83),
745 DECODE( p_col84, FND_API.g_miss_char, NULL, p_col84),
746 DECODE( p_col85, FND_API.g_miss_char, NULL, p_col85),
747 DECODE( p_col86, FND_API.g_miss_char, NULL, p_col86),
748 DECODE( p_col87, FND_API.g_miss_char, NULL, p_col87),
749 DECODE( p_col88, FND_API.g_miss_char, NULL, p_col88),
750 DECODE( p_col89, FND_API.g_miss_char, NULL, p_col89),
751 DECODE( p_col90, FND_API.g_miss_char, NULL, p_col90),
752 DECODE( p_col91, FND_API.g_miss_char, NULL, p_col91),
753 DECODE( p_col92, FND_API.g_miss_char, NULL, p_col92),
754 DECODE( p_col93, FND_API.g_miss_char, NULL, p_col93),
755 DECODE( p_col94, FND_API.g_miss_char, NULL, p_col94),
756 DECODE( p_col95, FND_API.g_miss_char, NULL, p_col95),
757 DECODE( p_col96, FND_API.g_miss_char, NULL, p_col96),
758 DECODE( p_col97, FND_API.g_miss_char, NULL, p_col97),
762 DECODE( p_col101, FND_API.g_miss_char, NULL, p_col101),
759 DECODE( p_col98, FND_API.g_miss_char, NULL, p_col98),
760 DECODE( p_col99, FND_API.g_miss_char, NULL, p_col99),
761 DECODE( p_col100, FND_API.g_miss_char, NULL, p_col100),
763 DECODE( p_col102, FND_API.g_miss_char, NULL, p_col102),
764 DECODE( p_col103, FND_API.g_miss_char, NULL, p_col103),
765 DECODE( p_col104, FND_API.g_miss_char, NULL, p_col104),
766 DECODE( p_col105, FND_API.g_miss_char, NULL, p_col105),
767 DECODE( p_col106, FND_API.g_miss_char, NULL, p_col106),
768 DECODE( p_col107, FND_API.g_miss_char, NULL, p_col107),
769 DECODE( p_col108, FND_API.g_miss_char, NULL, p_col108),
770 DECODE( p_col109, FND_API.g_miss_char, NULL, p_col109),
771 DECODE( p_col110, FND_API.g_miss_char, NULL, p_col110),
772 DECODE( p_col111, FND_API.g_miss_char, NULL, p_col111),
773 DECODE( p_col112, FND_API.g_miss_char, NULL, p_col112),
774 DECODE( p_col113, FND_API.g_miss_char, NULL, p_col113),
775 DECODE( p_col114, FND_API.g_miss_char, NULL, p_col114),
776 DECODE( p_col115, FND_API.g_miss_char, NULL, p_col115),
777 DECODE( p_col116, FND_API.g_miss_char, NULL, p_col116),
778 DECODE( p_col117, FND_API.g_miss_char, NULL, p_col117),
779 DECODE( p_col118, FND_API.g_miss_char, NULL, p_col118),
780 DECODE( p_col119, FND_API.g_miss_char, NULL, p_col119),
781 DECODE( p_col120, FND_API.g_miss_char, NULL, p_col120),
782 DECODE( p_col121, FND_API.g_miss_char, NULL, p_col121),
783 DECODE( p_col122, FND_API.g_miss_char, NULL, p_col122),
784 DECODE( p_col123, FND_API.g_miss_char, NULL, p_col123),
785 DECODE( p_col124, FND_API.g_miss_char, NULL, p_col124),
786 DECODE( p_col125, FND_API.g_miss_char, NULL, p_col125),
787 DECODE( p_col126, FND_API.g_miss_char, NULL, p_col126),
788 DECODE( p_col127, FND_API.g_miss_char, NULL, p_col127),
789 DECODE( p_col128, FND_API.g_miss_char, NULL, p_col128),
790 DECODE( p_col129, FND_API.g_miss_char, NULL, p_col129),
791 DECODE( p_col130, FND_API.g_miss_char, NULL, p_col130),
792 DECODE( p_col131, FND_API.g_miss_char, NULL, p_col131),
793 DECODE( p_col132, FND_API.g_miss_char, NULL, p_col132),
794 DECODE( p_col133, FND_API.g_miss_char, NULL, p_col133),
795 DECODE( p_col134, FND_API.g_miss_char, NULL, p_col134),
796 DECODE( p_col135, FND_API.g_miss_char, NULL, p_col135),
797 DECODE( p_col136, FND_API.g_miss_char, NULL, p_col136),
798 DECODE( p_col137, FND_API.g_miss_char, NULL, p_col137),
799 DECODE( p_col138, FND_API.g_miss_char, NULL, p_col138),
800 DECODE( p_col139, FND_API.g_miss_char, NULL, p_col139),
801 DECODE( p_col140, FND_API.g_miss_char, NULL, p_col140),
802 DECODE( p_col141, FND_API.g_miss_char, NULL, p_col141),
803 DECODE( p_col142, FND_API.g_miss_char, NULL, p_col142),
804 DECODE( p_col143, FND_API.g_miss_char, NULL, p_col143),
805 DECODE( p_col144, FND_API.g_miss_char, NULL, p_col144),
806 DECODE( p_col145, FND_API.g_miss_char, NULL, p_col145),
807 DECODE( p_col146, FND_API.g_miss_char, NULL, p_col146),
808 DECODE( p_col147, FND_API.g_miss_char, NULL, p_col147),
809 DECODE( p_col148, FND_API.g_miss_char, NULL, p_col148),
810 DECODE( p_col149, FND_API.g_miss_char, NULL, p_col149),
811 DECODE( p_col150, FND_API.g_miss_char, NULL, p_col150),
812 DECODE( p_col151, FND_API.g_miss_char, NULL, p_col151),
813 DECODE( p_col152, FND_API.g_miss_char, NULL, p_col152),
814 DECODE( p_col153, FND_API.g_miss_char, NULL, p_col153),
815 DECODE( p_col154, FND_API.g_miss_char, NULL, p_col154),
816 DECODE( p_col155, FND_API.g_miss_char, NULL, p_col155),
817 DECODE( p_col156, FND_API.g_miss_char, NULL, p_col156),
818 DECODE( p_col157, FND_API.g_miss_char, NULL, p_col157),
819 DECODE( p_col158, FND_API.g_miss_char, NULL, p_col158),
820 DECODE( p_col159, FND_API.g_miss_char, NULL, p_col159),
821 DECODE( p_col160, FND_API.g_miss_char, NULL, p_col160),
822 DECODE( p_col161, FND_API.g_miss_char, NULL, p_col161),
823 DECODE( p_col162, FND_API.g_miss_char, NULL, p_col162),
824 DECODE( p_col163, FND_API.g_miss_char, NULL, p_col163),
825 DECODE( p_col164, FND_API.g_miss_char, NULL, p_col164),
826 DECODE( p_col165, FND_API.g_miss_char, NULL, p_col165),
827 DECODE( p_col166, FND_API.g_miss_char, NULL, p_col166),
828 DECODE( p_col167, FND_API.g_miss_char, NULL, p_col167),
829 DECODE( p_col168, FND_API.g_miss_char, NULL, p_col168),
830 DECODE( p_col169, FND_API.g_miss_char, NULL, p_col169),
831 DECODE( p_col170, FND_API.g_miss_char, NULL, p_col170),
832 DECODE( p_col171, FND_API.g_miss_char, NULL, p_col171),
833 DECODE( p_col172, FND_API.g_miss_char, NULL, p_col172),
834 DECODE( p_col173, FND_API.g_miss_char, NULL, p_col173),
835 DECODE( p_col174, FND_API.g_miss_char, NULL, p_col174),
836 DECODE( p_col175, FND_API.g_miss_char, NULL, p_col175),
837 DECODE( p_col176, FND_API.g_miss_char, NULL, p_col176),
838 DECODE( p_col177, FND_API.g_miss_char, NULL, p_col177),
839 DECODE( p_col178, FND_API.g_miss_char, NULL, p_col178),
840 DECODE( p_col179, FND_API.g_miss_char, NULL, p_col179),
841 DECODE( p_col180, FND_API.g_miss_char, NULL, p_col180),
842 DECODE( p_col181, FND_API.g_miss_char, NULL, p_col181),
843 DECODE( p_col182, FND_API.g_miss_char, NULL, p_col182),
847 DECODE( p_col186, FND_API.g_miss_char, NULL, p_col186),
844 DECODE( p_col183, FND_API.g_miss_char, NULL, p_col183),
845 DECODE( p_col184, FND_API.g_miss_char, NULL, p_col184),
846 DECODE( p_col185, FND_API.g_miss_char, NULL, p_col185),
848 DECODE( p_col187, FND_API.g_miss_char, NULL, p_col187),
849 DECODE( p_col188, FND_API.g_miss_char, NULL, p_col188),
850 DECODE( p_col189, FND_API.g_miss_char, NULL, p_col189),
851 DECODE( p_col190, FND_API.g_miss_char, NULL, p_col190),
852 DECODE( p_col191, FND_API.g_miss_char, NULL, p_col191),
853 DECODE( p_col192, FND_API.g_miss_char, NULL, p_col192),
854 DECODE( p_col193, FND_API.g_miss_char, NULL, p_col193),
855 DECODE( p_col194, FND_API.g_miss_char, NULL, p_col194),
856 DECODE( p_col195, FND_API.g_miss_char, NULL, p_col195),
857 DECODE( p_col196, FND_API.g_miss_char, NULL, p_col196),
858 DECODE( p_col197, FND_API.g_miss_char, NULL, p_col197),
859 DECODE( p_col198, FND_API.g_miss_char, NULL, p_col198),
860 DECODE( p_col199, FND_API.g_miss_char, NULL, p_col199),
861 DECODE( p_col200, FND_API.g_miss_char, NULL, p_col200),
862 DECODE( p_col201, FND_API.g_miss_char, NULL, p_col201),
863 DECODE( p_col202, FND_API.g_miss_char, NULL, p_col202),
864 DECODE( p_col203, FND_API.g_miss_char, NULL, p_col203),
865 DECODE( p_col204, FND_API.g_miss_char, NULL, p_col204),
866 DECODE( p_col205, FND_API.g_miss_char, NULL, p_col205),
867 DECODE( p_col206, FND_API.g_miss_char, NULL, p_col206),
868 DECODE( p_col207, FND_API.g_miss_char, NULL, p_col207),
869 DECODE( p_col208, FND_API.g_miss_char, NULL, p_col208),
870 DECODE( p_col209, FND_API.g_miss_char, NULL, p_col209),
871 DECODE( p_col210, FND_API.g_miss_char, NULL, p_col210),
872 DECODE( p_col211, FND_API.g_miss_char, NULL, p_col211),
873 DECODE( p_col212, FND_API.g_miss_char, NULL, p_col212),
874 DECODE( p_col213, FND_API.g_miss_char, NULL, p_col213),
875 DECODE( p_col214, FND_API.g_miss_char, NULL, p_col214),
876 DECODE( p_col215, FND_API.g_miss_char, NULL, p_col215),
877 DECODE( p_col216, FND_API.g_miss_char, NULL, p_col216),
878 DECODE( p_col217, FND_API.g_miss_char, NULL, p_col217),
879 DECODE( p_col218, FND_API.g_miss_char, NULL, p_col218),
880 DECODE( p_col219, FND_API.g_miss_char, NULL, p_col219),
881 DECODE( p_col220, FND_API.g_miss_char, NULL, p_col220),
882 DECODE( p_col221, FND_API.g_miss_char, NULL, p_col221),
883 DECODE( p_col222, FND_API.g_miss_char, NULL, p_col222),
884 DECODE( p_col223, FND_API.g_miss_char, NULL, p_col223),
885 DECODE( p_col224, FND_API.g_miss_char, NULL, p_col224),
886 DECODE( p_col225, FND_API.g_miss_char, NULL, p_col225),
887 DECODE( p_col226, FND_API.g_miss_char, NULL, p_col226),
888 DECODE( p_col227, FND_API.g_miss_char, NULL, p_col227),
889 DECODE( p_col228, FND_API.g_miss_char, NULL, p_col228),
890 DECODE( p_col229, FND_API.g_miss_char, NULL, p_col229),
891 DECODE( p_col230, FND_API.g_miss_char, NULL, p_col230),
892 DECODE( p_col231, FND_API.g_miss_char, NULL, p_col231),
893 DECODE( p_col232, FND_API.g_miss_char, NULL, p_col232),
894 DECODE( p_col233, FND_API.g_miss_char, NULL, p_col233),
898 DECODE( p_col237, FND_API.g_miss_char, NULL, p_col237),
895 DECODE( p_col234, FND_API.g_miss_char, NULL, p_col234),
896 DECODE( p_col235, FND_API.g_miss_char, NULL, p_col235),
897 DECODE( p_col236, FND_API.g_miss_char, NULL, p_col236),
899 DECODE( p_col238, FND_API.g_miss_char, NULL, p_col238),
900 DECODE( p_col239, FND_API.g_miss_char, NULL, p_col239),
901 DECODE( p_col240, FND_API.g_miss_char, NULL, p_col240),
902 DECODE( p_col241, FND_API.g_miss_char, NULL, p_col241),
903 DECODE( p_col242, FND_API.g_miss_char, NULL, p_col242),
904 DECODE( p_col243, FND_API.g_miss_char, NULL, p_col243),
905 DECODE( p_col244, FND_API.g_miss_char, NULL, p_col244),
906 DECODE( p_col245, FND_API.g_miss_char, NULL, p_col245),
907 DECODE( p_col246, FND_API.g_miss_char, NULL, p_col246),
908 DECODE( p_col247, FND_API.g_miss_char, NULL, p_col247),
909 DECODE( p_col248, FND_API.g_miss_char, NULL, p_col248),
910 DECODE( p_col249, FND_API.g_miss_char, NULL, p_col249),
911 DECODE( p_col250, FND_API.g_miss_char, NULL, p_col250),
912 DECODE( p_duplicate_flag, FND_API.g_miss_char, NULL, p_duplicate_flag),
913 DECODE( p_current_usage, FND_API.g_miss_num, NULL, p_current_usage),
914 'ACTIVE',
915 DECODE( p_notes, FND_API.g_miss_char, NULL, p_notes),
916 DECODE( p_sales_agent_email_address, FND_API.g_miss_char, NULL, p_sales_agent_email_address),
917 DECODE( p_vehicle_response_code, FND_API.g_miss_char, NULL, p_vehicle_response_code),
918 DECODE( p_custom_column1, FND_API.g_miss_char, NULL, p_custom_column1),
919 DECODE( p_custom_column2, FND_API.g_miss_char, NULL, p_custom_column2),
920 DECODE( p_custom_column3, FND_API.g_miss_char, NULL, p_custom_column3),
921 DECODE( p_custom_column4, FND_API.g_miss_char, NULL, p_custom_column4),
922 DECODE( p_custom_column5, FND_API.g_miss_char, NULL, p_custom_column5),
923 DECODE( p_custom_column6, FND_API.g_miss_char, NULL, p_custom_column6),
924 DECODE( p_custom_column7, FND_API.g_miss_char, NULL, p_custom_column7),
925 DECODE( p_custom_column8, FND_API.g_miss_char, NULL, p_custom_column8),
926 DECODE( p_custom_column9, FND_API.g_miss_char, NULL, p_custom_column9),
927 DECODE( p_custom_column10, FND_API.g_miss_char, NULL, p_custom_column10),
928 DECODE( p_custom_column11, FND_API.g_miss_char, NULL, p_custom_column11),
929 DECODE( p_custom_column12, FND_API.g_miss_char, NULL, p_custom_column12),
930 DECODE( p_custom_column13, FND_API.g_miss_char, NULL, p_custom_column13),
931 DECODE( p_custom_column14, FND_API.g_miss_char, NULL, p_custom_column14),
932 DECODE( p_custom_column15, FND_API.g_miss_char, NULL, p_custom_column15),
933 DECODE( p_custom_column16, FND_API.g_miss_char, NULL, p_custom_column16),
934 DECODE( p_custom_column17, FND_API.g_miss_char, NULL, p_custom_column17),
935 DECODE( p_custom_column18, FND_API.g_miss_char, NULL, p_custom_column18),
936 DECODE( p_custom_column19, FND_API.g_miss_char, NULL, p_custom_column19),
937 DECODE( p_custom_column20, FND_API.g_miss_char, NULL, p_custom_column20),
938 DECODE( p_custom_column21, FND_API.g_miss_char, NULL, p_custom_column21),
939 DECODE( p_custom_column22, FND_API.g_miss_char, NULL, p_custom_column22),
940 DECODE( p_custom_column23, FND_API.g_miss_char, NULL, p_custom_column23),
941 DECODE( p_custom_column24, FND_API.g_miss_char, NULL, p_custom_column24),
942 DECODE( p_custom_column25, FND_API.g_miss_char, NULL, p_custom_column25)
943
944
945 );
946 END Insert_Row;
947
948
949 ----------------------------------------------------------
950 ---- MEDIA ----
951 ----------------------------------------------------------
952
953 -- ========================================================
954 --
955 -- NAME
956 -- createUpdateBody
957 --
958 -- PURPOSE
959 --
960 -- NOTES
961 --
962 -- HISTORY
963 --
964 -- ========================================================
965 PROCEDURE Update_Row(
966 p_import_source_line_id NUMBER,
967 p_object_version_number NUMBER,
968 p_last_update_date DATE,
969 p_last_updated_by NUMBER,
970 p_creation_date DATE,
971 p_created_by NUMBER,
972 p_last_update_login NUMBER,
973 p_import_list_header_id NUMBER,
974 p_import_successful_flag VARCHAR2,
975 p_enabled_flag VARCHAR2,
976 p_import_failure_reason VARCHAR2,
977 p_re_import_last_done_date DATE,
978 p_party_id NUMBER,
979 p_dedupe_key VARCHAR2,
980 p_col1 VARCHAR2,
981 p_col2 VARCHAR2,
982 p_col3 VARCHAR2,
983 p_col4 VARCHAR2,
984 p_col5 VARCHAR2,
985 p_col6 VARCHAR2,
986 p_col7 VARCHAR2,
987 p_col8 VARCHAR2,
988 p_col9 VARCHAR2,
989 p_col10 VARCHAR2,
990 p_col11 VARCHAR2,
991 p_col12 VARCHAR2,
992 p_col13 VARCHAR2,
993 p_col14 VARCHAR2,
994 p_col15 VARCHAR2,
995 p_col16 VARCHAR2,
996 p_col17 VARCHAR2,
997 p_col18 VARCHAR2,
998 p_col19 VARCHAR2,
999 p_col20 VARCHAR2,
1000 p_col21 VARCHAR2,
1001 p_col22 VARCHAR2,
1002 p_col23 VARCHAR2,
1003 p_col24 VARCHAR2,
1004 p_col25 VARCHAR2,
1005 p_col26 VARCHAR2,
1006 p_col27 VARCHAR2,
1010 p_col31 VARCHAR2,
1007 p_col28 VARCHAR2,
1008 p_col29 VARCHAR2,
1009 p_col30 VARCHAR2,
1011 p_col32 VARCHAR2,
1012 p_col33 VARCHAR2,
1013 p_col34 VARCHAR2,
1014 p_col35 VARCHAR2,
1015 p_col36 VARCHAR2,
1016 p_col37 VARCHAR2,
1017 p_col38 VARCHAR2,
1018 p_col39 VARCHAR2,
1019 p_col40 VARCHAR2,
1020 p_col41 VARCHAR2,
1021 p_col42 VARCHAR2,
1022 p_col43 VARCHAR2,
1023 p_col44 VARCHAR2,
1024 p_col45 VARCHAR2,
1025 p_col46 VARCHAR2,
1026 p_col47 VARCHAR2,
1027 p_col48 VARCHAR2,
1028 p_col49 VARCHAR2,
1029 p_col50 VARCHAR2,
1030 p_col51 VARCHAR2,
1031 p_col52 VARCHAR2,
1032 p_col53 VARCHAR2,
1033 p_col54 VARCHAR2,
1034 p_col55 VARCHAR2,
1035 p_col56 VARCHAR2,
1036 p_col57 VARCHAR2,
1037 p_col58 VARCHAR2,
1038 p_col59 VARCHAR2,
1039 p_col60 VARCHAR2,
1040 p_col61 VARCHAR2,
1041 p_col62 VARCHAR2,
1042 p_col63 VARCHAR2,
1043 p_col64 VARCHAR2,
1044 p_col65 VARCHAR2,
1045 p_col66 VARCHAR2,
1046 p_col67 VARCHAR2,
1047 p_col68 VARCHAR2,
1048 p_col69 VARCHAR2,
1049 p_col70 VARCHAR2,
1050 p_col71 VARCHAR2,
1051 p_col72 VARCHAR2,
1052 p_col73 VARCHAR2,
1053 p_col74 VARCHAR2,
1054 p_col75 VARCHAR2,
1055 p_col76 VARCHAR2,
1056 p_col77 VARCHAR2,
1057 p_col78 VARCHAR2,
1058 p_col79 VARCHAR2,
1059 p_col80 VARCHAR2,
1060 p_col81 VARCHAR2,
1061 p_col82 VARCHAR2,
1062 p_col83 VARCHAR2,
1063 p_col84 VARCHAR2,
1064 p_col85 VARCHAR2,
1065 p_col86 VARCHAR2,
1066 p_col87 VARCHAR2,
1067 p_col88 VARCHAR2,
1068 p_col89 VARCHAR2,
1069 p_col90 VARCHAR2,
1070 p_col91 VARCHAR2,
1071 p_col92 VARCHAR2,
1072 p_col93 VARCHAR2,
1073 p_col94 VARCHAR2,
1074 p_col95 VARCHAR2,
1075 p_col96 VARCHAR2,
1076 p_col97 VARCHAR2,
1077 p_col98 VARCHAR2,
1078 p_col99 VARCHAR2,
1079 p_col100 VARCHAR2,
1080 p_col101 VARCHAR2,
1081 p_col102 VARCHAR2,
1082 p_col103 VARCHAR2,
1083 p_col104 VARCHAR2,
1084 p_col105 VARCHAR2,
1085 p_col106 VARCHAR2,
1086 p_col107 VARCHAR2,
1087 p_col108 VARCHAR2,
1088 p_col109 VARCHAR2,
1089 p_col110 VARCHAR2,
1090 p_col111 VARCHAR2,
1091 p_col112 VARCHAR2,
1092 p_col113 VARCHAR2,
1093 p_col114 VARCHAR2,
1094 p_col115 VARCHAR2,
1095 p_col116 VARCHAR2,
1096 p_col117 VARCHAR2,
1097 p_col118 VARCHAR2,
1098 p_col119 VARCHAR2,
1099 p_col120 VARCHAR2,
1100 p_col121 VARCHAR2,
1101 p_col122 VARCHAR2,
1102 p_col123 VARCHAR2,
1103 p_col124 VARCHAR2,
1104 p_col125 VARCHAR2,
1105 p_col126 VARCHAR2,
1106 p_col127 VARCHAR2,
1107 p_col128 VARCHAR2,
1108 p_col129 VARCHAR2,
1109 p_col130 VARCHAR2,
1110 p_col131 VARCHAR2,
1111 p_col132 VARCHAR2,
1112 p_col133 VARCHAR2,
1113 p_col134 VARCHAR2,
1114 p_col135 VARCHAR2,
1115 p_col136 VARCHAR2,
1116 p_col137 VARCHAR2,
1117 p_col138 VARCHAR2,
1118 p_col139 VARCHAR2,
1119 p_col140 VARCHAR2,
1120 p_col141 VARCHAR2,
1121 p_col142 VARCHAR2,
1122 p_col143 VARCHAR2,
1123 p_col144 VARCHAR2,
1124 p_col145 VARCHAR2,
1125 p_col146 VARCHAR2,
1126 p_col147 VARCHAR2,
1127 p_col148 VARCHAR2,
1128 p_col149 VARCHAR2,
1129 p_col150 VARCHAR2,
1130 p_col151 VARCHAR2,
1131 p_col152 VARCHAR2,
1132 p_col153 VARCHAR2,
1133 p_col154 VARCHAR2,
1134 p_col155 VARCHAR2,
1135 p_col156 VARCHAR2,
1136 p_col157 VARCHAR2,
1137 p_col158 VARCHAR2,
1138 p_col159 VARCHAR2,
1139 p_col160 VARCHAR2,
1140 p_col161 VARCHAR2,
1141 p_col162 VARCHAR2,
1142 p_col163 VARCHAR2,
1143 p_col164 VARCHAR2,
1144 p_col165 VARCHAR2,
1145 p_col166 VARCHAR2,
1146 p_col167 VARCHAR2,
1147 p_col168 VARCHAR2,
1148 p_col169 VARCHAR2,
1149 p_col170 VARCHAR2,
1150 p_col171 VARCHAR2,
1151 p_col172 VARCHAR2,
1152 p_col173 VARCHAR2,
1153 p_col174 VARCHAR2,
1154 p_col175 VARCHAR2,
1155 p_col176 VARCHAR2,
1156 p_col177 VARCHAR2,
1157 p_col178 VARCHAR2,
1158 p_col179 VARCHAR2,
1159 p_col180 VARCHAR2,
1160 p_col181 VARCHAR2,
1161 p_col182 VARCHAR2,
1162 p_col183 VARCHAR2,
1166 p_col187 VARCHAR2,
1163 p_col184 VARCHAR2,
1164 p_col185 VARCHAR2,
1165 p_col186 VARCHAR2,
1167 p_col188 VARCHAR2,
1168 p_col189 VARCHAR2,
1169 p_col190 VARCHAR2,
1170 p_col191 VARCHAR2,
1171 p_col192 VARCHAR2,
1172 p_col193 VARCHAR2,
1173 p_col194 VARCHAR2,
1174 p_col195 VARCHAR2,
1175 p_col196 VARCHAR2,
1176 p_col197 VARCHAR2,
1177 p_col198 VARCHAR2,
1178 p_col199 VARCHAR2,
1179 p_col200 VARCHAR2,
1180 p_col201 VARCHAR2,
1181 p_col202 VARCHAR2,
1182 p_col203 VARCHAR2,
1183 p_col204 VARCHAR2,
1184 p_col205 VARCHAR2,
1185 p_col206 VARCHAR2,
1186 p_col207 VARCHAR2,
1187 p_col208 VARCHAR2,
1188 p_col209 VARCHAR2,
1189 p_col210 VARCHAR2,
1190 p_col211 VARCHAR2,
1191 p_col212 VARCHAR2,
1192 p_col213 VARCHAR2,
1193 p_col214 VARCHAR2,
1194 p_col215 VARCHAR2,
1195 p_col216 VARCHAR2,
1196 p_col217 VARCHAR2,
1197 p_col218 VARCHAR2,
1198 p_col219 VARCHAR2,
1199 p_col220 VARCHAR2,
1200 p_col221 VARCHAR2,
1201 p_col222 VARCHAR2,
1202 p_col223 VARCHAR2,
1203 p_col224 VARCHAR2,
1204 p_col225 VARCHAR2,
1205 p_col226 VARCHAR2,
1206 p_col227 VARCHAR2,
1207 p_col228 VARCHAR2,
1208 p_col229 VARCHAR2,
1209 p_col230 VARCHAR2,
1210 p_col231 VARCHAR2,
1211 p_col232 VARCHAR2,
1212 p_col233 VARCHAR2,
1213 p_col234 VARCHAR2,
1214 p_col235 VARCHAR2,
1215 p_col236 VARCHAR2,
1216 p_col237 VARCHAR2,
1217 p_col238 VARCHAR2,
1218 p_col239 VARCHAR2,
1219 p_col240 VARCHAR2,
1220 p_col241 VARCHAR2,
1221 p_col242 VARCHAR2,
1222 p_col243 VARCHAR2,
1223 p_col244 VARCHAR2,
1224 p_col245 VARCHAR2,
1225 p_col246 VARCHAR2,
1226 p_col247 VARCHAR2,
1227 p_col248 VARCHAR2,
1228 p_col249 VARCHAR2,
1229 p_col250 VARCHAR2,
1230 p_duplicate_flag VARCHAR2,
1231 p_current_usage NUMBER,
1232 p_load_status VARCHAR2,
1233 p_notes VARCHAR2,
1234 p_sales_agent_email_address VARCHAR2,
1235 p_vehicle_response_code VARCHAR2,
1236 p_custom_column1 VARCHAR2,
1237 p_custom_column2 VARCHAR2,
1238 p_custom_column3 VARCHAR2,
1239 p_custom_column4 VARCHAR2,
1240 p_custom_column5 VARCHAR2,
1241 p_custom_column6 VARCHAR2,
1242 p_custom_column7 VARCHAR2,
1243 p_custom_column8 VARCHAR2,
1244 p_custom_column9 VARCHAR2,
1245 p_custom_column10 VARCHAR2,
1246 p_custom_column11 VARCHAR2,
1247 p_custom_column12 VARCHAR2,
1248 p_custom_column13 VARCHAR2,
1249 p_custom_column14 VARCHAR2,
1250 p_custom_column15 VARCHAR2,
1251 p_custom_column16 VARCHAR2,
1252 p_custom_column17 VARCHAR2,
1253 p_custom_column18 VARCHAR2,
1254 p_custom_column19 VARCHAR2,
1255 p_custom_column20 VARCHAR2,
1256 p_custom_column21 VARCHAR2,
1257 p_custom_column22 VARCHAR2,
1258 p_custom_column23 VARCHAR2,
1259 p_custom_column24 VARCHAR2,
1260 p_custom_column25 VARCHAR2
1261
1262 )
1263
1264
1265 IS
1266 BEGIN
1267 Update AMS_IMP_SOURCE_LINES
1268 SET
1269 import_source_line_id = DECODE( p_import_source_line_id, FND_API.g_miss_num, import_source_line_id, p_import_source_line_id),
1270 object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
1271 last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
1272 last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
1273 creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
1274 created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
1275 last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
1276 import_list_header_id = DECODE( p_import_list_header_id, FND_API.g_miss_num, import_list_header_id, p_import_list_header_id),
1277 import_successful_flag = DECODE( p_import_successful_flag, FND_API.g_miss_char, import_successful_flag, p_import_successful_flag),
1278 enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
1279 import_failure_reason = DECODE( p_import_failure_reason, FND_API.g_miss_char, import_failure_reason, p_import_failure_reason),
1280 re_import_last_done_date = DECODE( p_re_import_last_done_date, FND_API.g_miss_date, re_import_last_done_date, p_re_import_last_done_date),
1281 party_id = DECODE( p_party_id, FND_API.g_miss_num, party_id, p_party_id),
1282 dedupe_key = DECODE( p_dedupe_key, FND_API.g_miss_char, dedupe_key, p_dedupe_key),
1283 col1 = DECODE( p_col1, FND_API.g_miss_char, col1, p_col1),
1284 col2 = DECODE( p_col2, FND_API.g_miss_char, col2, p_col2),
1285 col3 = DECODE( p_col3, FND_API.g_miss_char, col3, p_col3),
1286 col4 = DECODE( p_col4, FND_API.g_miss_char, col4, p_col4),
1287 col5 = DECODE( p_col5, FND_API.g_miss_char, col5, p_col5),
1288 col6 = DECODE( p_col6, FND_API.g_miss_char, col6, p_col6),
1289 col7 = DECODE( p_col7, FND_API.g_miss_char, col7, p_col7),
1293 col11 = DECODE( p_col11, FND_API.g_miss_char, col11, p_col11),
1290 col8 = DECODE( p_col8, FND_API.g_miss_char, col8, p_col8),
1291 col9 = DECODE( p_col9, FND_API.g_miss_char, col9, p_col9),
1292 col10 = DECODE( p_col10, FND_API.g_miss_char, col10, p_col10),
1294 col12 = DECODE( p_col12, FND_API.g_miss_char, col12, p_col12),
1295 col13 = DECODE( p_col13, FND_API.g_miss_char, col13, p_col13),
1296 col14 = DECODE( p_col14, FND_API.g_miss_char, col14, p_col14),
1297 col15 = DECODE( p_col15, FND_API.g_miss_char, col15, p_col15),
1298 col16 = DECODE( p_col16, FND_API.g_miss_char, col16, p_col16),
1299 col17 = DECODE( p_col17, FND_API.g_miss_char, col17, p_col17),
1300 col18 = DECODE( p_col18, FND_API.g_miss_char, col18, p_col18),
1301 col19 = DECODE( p_col19, FND_API.g_miss_char, col19, p_col19),
1302 col20 = DECODE( p_col20, FND_API.g_miss_char, col20, p_col20),
1303 col21 = DECODE( p_col21, FND_API.g_miss_char, col21, p_col21),
1304 col22 = DECODE( p_col22, FND_API.g_miss_char, col22, p_col22),
1305 col23 = DECODE( p_col23, FND_API.g_miss_char, col23, p_col23),
1306 col24 = DECODE( p_col24, FND_API.g_miss_char, col24, p_col24),
1307 col25 = DECODE( p_col25, FND_API.g_miss_char, col25, p_col25),
1308 col26 = DECODE( p_col26, FND_API.g_miss_char, col26, p_col26),
1309 col27 = DECODE( p_col27, FND_API.g_miss_char, col27, p_col27),
1310 col28 = DECODE( p_col28, FND_API.g_miss_char, col28, p_col28),
1311 col29 = DECODE( p_col29, FND_API.g_miss_char, col29, p_col29),
1312 col30 = DECODE( p_col30, FND_API.g_miss_char, col30, p_col30),
1313 col31 = DECODE( p_col31, FND_API.g_miss_char, col31, p_col31),
1314 col32 = DECODE( p_col32, FND_API.g_miss_char, col32, p_col32),
1315 col33 = DECODE( p_col33, FND_API.g_miss_char, col33, p_col33),
1316 col34 = DECODE( p_col34, FND_API.g_miss_char, col34, p_col34),
1317 col35 = DECODE( p_col35, FND_API.g_miss_char, col35, p_col35),
1318 col36 = DECODE( p_col36, FND_API.g_miss_char, col36, p_col36),
1319 col37 = DECODE( p_col37, FND_API.g_miss_char, col37, p_col37),
1320 col38 = DECODE( p_col38, FND_API.g_miss_char, col38, p_col38),
1321 col39 = DECODE( p_col39, FND_API.g_miss_char, col39, p_col39),
1322 col40 = DECODE( p_col40, FND_API.g_miss_char, col40, p_col40),
1323 col41 = DECODE( p_col41, FND_API.g_miss_char, col41, p_col41),
1324 col42 = DECODE( p_col42, FND_API.g_miss_char, col42, p_col42),
1325 col43 = DECODE( p_col43, FND_API.g_miss_char, col43, p_col43),
1326 col44 = DECODE( p_col44, FND_API.g_miss_char, col44, p_col44),
1327 col45 = DECODE( p_col45, FND_API.g_miss_char, col45, p_col45),
1328 col46 = DECODE( p_col46, FND_API.g_miss_char, col46, p_col46),
1329 col47 = DECODE( p_col47, FND_API.g_miss_char, col47, p_col47),
1330 col48 = DECODE( p_col48, FND_API.g_miss_char, col48, p_col48),
1331 col49 = DECODE( p_col49, FND_API.g_miss_char, col49, p_col49),
1332 col50 = DECODE( p_col50, FND_API.g_miss_char, col50, p_col50),
1333 col51 = DECODE( p_col51, FND_API.g_miss_char, col51, p_col51),
1334 col52 = DECODE( p_col52, FND_API.g_miss_char, col52, p_col52),
1335 col53 = DECODE( p_col53, FND_API.g_miss_char, col53, p_col53),
1336 col54 = DECODE( p_col54, FND_API.g_miss_char, col54, p_col54),
1337 col55 = DECODE( p_col55, FND_API.g_miss_char, col55, p_col55),
1338 col56 = DECODE( p_col56, FND_API.g_miss_char, col56, p_col56),
1339 col57 = DECODE( p_col57, FND_API.g_miss_char, col57, p_col57),
1340 col58 = DECODE( p_col58, FND_API.g_miss_char, col58, p_col58),
1341 col59 = DECODE( p_col59, FND_API.g_miss_char, col59, p_col59),
1342 col60 = DECODE( p_col60, FND_API.g_miss_char, col60, p_col60),
1343 col61 = DECODE( p_col61, FND_API.g_miss_char, col61, p_col61),
1344 col62 = DECODE( p_col62, FND_API.g_miss_char, col62, p_col62),
1345 col63 = DECODE( p_col63, FND_API.g_miss_char, col63, p_col63),
1346 col64 = DECODE( p_col64, FND_API.g_miss_char, col64, p_col64),
1347 col65 = DECODE( p_col65, FND_API.g_miss_char, col65, p_col65),
1348 col66 = DECODE( p_col66, FND_API.g_miss_char, col66, p_col66),
1349 col67 = DECODE( p_col67, FND_API.g_miss_char, col67, p_col67),
1350 col68 = DECODE( p_col68, FND_API.g_miss_char, col68, p_col68),
1351 col69 = DECODE( p_col69, FND_API.g_miss_char, col69, p_col69),
1352 col70 = DECODE( p_col70, FND_API.g_miss_char, col70, p_col70),
1353 col71 = DECODE( p_col71, FND_API.g_miss_char, col71, p_col71),
1354 col72 = DECODE( p_col72, FND_API.g_miss_char, col72, p_col72),
1355 col73 = DECODE( p_col73, FND_API.g_miss_char, col73, p_col73),
1356 col74 = DECODE( p_col74, FND_API.g_miss_char, col74, p_col74),
1357 col75 = DECODE( p_col75, FND_API.g_miss_char, col75, p_col75),
1358 col76 = DECODE( p_col76, FND_API.g_miss_char, col76, p_col76),
1359 col77 = DECODE( p_col77, FND_API.g_miss_char, col77, p_col77),
1360 col78 = DECODE( p_col78, FND_API.g_miss_char, col78, p_col78),
1361 col79 = DECODE( p_col79, FND_API.g_miss_char, col79, p_col79),
1362 col80 = DECODE( p_col80, FND_API.g_miss_char, col80, p_col80),
1363 col81 = DECODE( p_col81, FND_API.g_miss_char, col81, p_col81),
1364 col82 = DECODE( p_col82, FND_API.g_miss_char, col82, p_col82),
1365 col83 = DECODE( p_col83, FND_API.g_miss_char, col83, p_col83),
1366 col84 = DECODE( p_col84, FND_API.g_miss_char, col84, p_col84),
1370 col88 = DECODE( p_col88, FND_API.g_miss_char, col88, p_col88),
1367 col85 = DECODE( p_col85, FND_API.g_miss_char, col85, p_col85),
1368 col86 = DECODE( p_col86, FND_API.g_miss_char, col86, p_col86),
1369 col87 = DECODE( p_col87, FND_API.g_miss_char, col87, p_col87),
1371 col89 = DECODE( p_col89, FND_API.g_miss_char, col89, p_col89),
1372 col90 = DECODE( p_col90, FND_API.g_miss_char, col90, p_col90),
1373 col91 = DECODE( p_col91, FND_API.g_miss_char, col91, p_col91),
1374 col92 = DECODE( p_col92, FND_API.g_miss_char, col92, p_col92),
1375 col93 = DECODE( p_col93, FND_API.g_miss_char, col93, p_col93),
1376 col94 = DECODE( p_col94, FND_API.g_miss_char, col94, p_col94),
1377 col95 = DECODE( p_col95, FND_API.g_miss_char, col95, p_col95),
1378 col96 = DECODE( p_col96, FND_API.g_miss_char, col96, p_col96),
1379 col97 = DECODE( p_col97, FND_API.g_miss_char, col97, p_col97),
1380 col98 = DECODE( p_col98, FND_API.g_miss_char, col98, p_col98),
1381 col99 = DECODE( p_col99, FND_API.g_miss_char, col99, p_col99),
1382 col100 = DECODE( p_col100, FND_API.g_miss_char, col100, p_col100),
1383 col101 = DECODE( p_col101, FND_API.g_miss_char, col101, p_col101),
1384 col102 = DECODE( p_col102, FND_API.g_miss_char, col102, p_col102),
1385 col103 = DECODE( p_col103, FND_API.g_miss_char, col103, p_col103),
1386 col104 = DECODE( p_col104, FND_API.g_miss_char, col104, p_col104),
1387 col105 = DECODE( p_col105, FND_API.g_miss_char, col105, p_col105),
1388 col106 = DECODE( p_col106, FND_API.g_miss_char, col106, p_col106),
1389 col107 = DECODE( p_col107, FND_API.g_miss_char, col107, p_col107),
1390 col108 = DECODE( p_col108, FND_API.g_miss_char, col108, p_col108),
1391 col109 = DECODE( p_col109, FND_API.g_miss_char, col109, p_col109),
1392 col110 = DECODE( p_col110, FND_API.g_miss_char, col110, p_col110),
1393 col111 = DECODE( p_col111, FND_API.g_miss_char, col111, p_col111),
1394 col112 = DECODE( p_col112, FND_API.g_miss_char, col112, p_col112),
1395 col113 = DECODE( p_col113, FND_API.g_miss_char, col113, p_col113),
1396 col114 = DECODE( p_col114, FND_API.g_miss_char, col114, p_col114),
1397 col115 = DECODE( p_col115, FND_API.g_miss_char, col115, p_col115),
1398 col116 = DECODE( p_col116, FND_API.g_miss_char, col116, p_col116),
1399 col117 = DECODE( p_col117, FND_API.g_miss_char, col117, p_col117),
1400 col118 = DECODE( p_col118, FND_API.g_miss_char, col118, p_col118),
1401 col119 = DECODE( p_col119, FND_API.g_miss_char, col119, p_col119),
1402 col120 = DECODE( p_col120, FND_API.g_miss_char, col120, p_col120),
1403 col121 = DECODE( p_col121, FND_API.g_miss_char, col121, p_col121),
1404 col122 = DECODE( p_col122, FND_API.g_miss_char, col122, p_col122),
1405 col123 = DECODE( p_col123, FND_API.g_miss_char, col123, p_col123),
1406 col124 = DECODE( p_col124, FND_API.g_miss_char, col124, p_col124),
1407 col125 = DECODE( p_col125, FND_API.g_miss_char, col125, p_col125),
1408 col126 = DECODE( p_col126, FND_API.g_miss_char, col126, p_col126),
1409 col127 = DECODE( p_col127, FND_API.g_miss_char, col127, p_col127),
1410 col128 = DECODE( p_col128, FND_API.g_miss_char, col128, p_col128),
1411 col129 = DECODE( p_col129, FND_API.g_miss_char, col129, p_col129),
1412 col130 = DECODE( p_col130, FND_API.g_miss_char, col130, p_col130),
1413 col131 = DECODE( p_col131, FND_API.g_miss_char, col131, p_col131),
1414 col132 = DECODE( p_col132, FND_API.g_miss_char, col132, p_col132),
1415 col133 = DECODE( p_col133, FND_API.g_miss_char, col133, p_col133),
1416 col134 = DECODE( p_col134, FND_API.g_miss_char, col134, p_col134),
1417 col135 = DECODE( p_col135, FND_API.g_miss_char, col135, p_col135),
1418 col136 = DECODE( p_col136, FND_API.g_miss_char, col136, p_col136),
1419 col137 = DECODE( p_col137, FND_API.g_miss_char, col137, p_col137),
1420 col138 = DECODE( p_col138, FND_API.g_miss_char, col138, p_col138),
1421 col139 = DECODE( p_col139, FND_API.g_miss_char, col139, p_col139),
1422 col140 = DECODE( p_col140, FND_API.g_miss_char, col140, p_col140),
1423 col141 = DECODE( p_col141, FND_API.g_miss_char, col141, p_col141),
1424 col142 = DECODE( p_col142, FND_API.g_miss_char, col142, p_col142),
1425 col143 = DECODE( p_col143, FND_API.g_miss_char, col143, p_col143),
1426 col144 = DECODE( p_col144, FND_API.g_miss_char, col144, p_col144),
1427 col145 = DECODE( p_col145, FND_API.g_miss_char, col145, p_col145),
1428 col146 = DECODE( p_col146, FND_API.g_miss_char, col146, p_col146),
1429 col147 = DECODE( p_col147, FND_API.g_miss_char, col147, p_col147),
1430 col148 = DECODE( p_col148, FND_API.g_miss_char, col148, p_col148),
1431 col149 = DECODE( p_col149, FND_API.g_miss_char, col149, p_col149),
1432 col150 = DECODE( p_col150, FND_API.g_miss_char, col150, p_col150),
1433 col151 = DECODE( p_col151, FND_API.g_miss_char, col151, p_col151),
1434 col152 = DECODE( p_col152, FND_API.g_miss_char, col152, p_col152),
1435 col153 = DECODE( p_col153, FND_API.g_miss_char, col153, p_col153),
1436 col154 = DECODE( p_col154, FND_API.g_miss_char, col154, p_col154),
1437 col155 = DECODE( p_col155, FND_API.g_miss_char, col155, p_col155),
1438 col156 = DECODE( p_col156, FND_API.g_miss_char, col156, p_col156),
1439 col157 = DECODE( p_col157, FND_API.g_miss_char, col157, p_col157),
1440 col158 = DECODE( p_col158, FND_API.g_miss_char, col158, p_col158),
1441 col159 = DECODE( p_col159, FND_API.g_miss_char, col159, p_col159),
1445 col163 = DECODE( p_col163, FND_API.g_miss_char, col163, p_col163),
1442 col160 = DECODE( p_col160, FND_API.g_miss_char, col160, p_col160),
1443 col161 = DECODE( p_col161, FND_API.g_miss_char, col161, p_col161),
1444 col162 = DECODE( p_col162, FND_API.g_miss_char, col162, p_col162),
1446 col164 = DECODE( p_col164, FND_API.g_miss_char, col164, p_col164),
1447 col165 = DECODE( p_col165, FND_API.g_miss_char, col165, p_col165),
1448 col166 = DECODE( p_col166, FND_API.g_miss_char, col166, p_col166),
1449 col167 = DECODE( p_col167, FND_API.g_miss_char, col167, p_col167),
1450 col168 = DECODE( p_col168, FND_API.g_miss_char, col168, p_col168),
1451 col169 = DECODE( p_col169, FND_API.g_miss_char, col169, p_col169),
1452 col170 = DECODE( p_col170, FND_API.g_miss_char, col170, p_col170),
1453 col171 = DECODE( p_col171, FND_API.g_miss_char, col171, p_col171),
1454 col172 = DECODE( p_col172, FND_API.g_miss_char, col172, p_col172),
1455 col173 = DECODE( p_col173, FND_API.g_miss_char, col173, p_col173),
1456 col174 = DECODE( p_col174, FND_API.g_miss_char, col174, p_col174),
1457 col175 = DECODE( p_col175, FND_API.g_miss_char, col175, p_col175),
1458 col176 = DECODE( p_col176, FND_API.g_miss_char, col176, p_col176),
1459 col177 = DECODE( p_col177, FND_API.g_miss_char, col177, p_col177),
1460 col178 = DECODE( p_col178, FND_API.g_miss_char, col178, p_col178),
1461 col179 = DECODE( p_col179, FND_API.g_miss_char, col179, p_col179),
1462 col180 = DECODE( p_col180, FND_API.g_miss_char, col180, p_col180),
1463 col181 = DECODE( p_col181, FND_API.g_miss_char, col181, p_col181),
1464 col182 = DECODE( p_col182, FND_API.g_miss_char, col182, p_col182),
1465 col183 = DECODE( p_col183, FND_API.g_miss_char, col183, p_col183),
1466 col184 = DECODE( p_col184, FND_API.g_miss_char, col184, p_col184),
1467 col185 = DECODE( p_col185, FND_API.g_miss_char, col185, p_col185),
1468 col186 = DECODE( p_col186, FND_API.g_miss_char, col186, p_col186),
1469 col187 = DECODE( p_col187, FND_API.g_miss_char, col187, p_col187),
1470 col188 = DECODE( p_col188, FND_API.g_miss_char, col188, p_col188),
1471 col189 = DECODE( p_col189, FND_API.g_miss_char, col189, p_col189),
1472 col190 = DECODE( p_col190, FND_API.g_miss_char, col190, p_col190),
1473 col191 = DECODE( p_col191, FND_API.g_miss_char, col191, p_col191),
1474 col192 = DECODE( p_col192, FND_API.g_miss_char, col192, p_col192),
1475 col193 = DECODE( p_col193, FND_API.g_miss_char, col193, p_col193),
1476 col194 = DECODE( p_col194, FND_API.g_miss_char, col194, p_col194),
1477 col195 = DECODE( p_col195, FND_API.g_miss_char, col195, p_col195),
1478 col196 = DECODE( p_col196, FND_API.g_miss_char, col196, p_col196),
1479 col197 = DECODE( p_col197, FND_API.g_miss_char, col197, p_col197),
1480 col198 = DECODE( p_col198, FND_API.g_miss_char, col198, p_col198),
1481 col199 = DECODE( p_col199, FND_API.g_miss_char, col199, p_col199),
1482 col200 = DECODE( p_col200, FND_API.g_miss_char, col200, p_col200),
1483 col201 = DECODE( p_col201, FND_API.g_miss_char, col201, p_col201),
1484 col202 = DECODE( p_col202, FND_API.g_miss_char, col202, p_col202),
1485 col203 = DECODE( p_col203, FND_API.g_miss_char, col203, p_col203),
1486 col204 = DECODE( p_col204, FND_API.g_miss_char, col204, p_col204),
1487 col205 = DECODE( p_col205, FND_API.g_miss_char, col205, p_col205),
1488 col206 = DECODE( p_col206, FND_API.g_miss_char, col206, p_col206),
1489 col207 = DECODE( p_col207, FND_API.g_miss_char, col207, p_col207),
1490 col208 = DECODE( p_col208, FND_API.g_miss_char, col208, p_col208),
1491 col209 = DECODE( p_col209, FND_API.g_miss_char, col209, p_col209),
1492 col210 = DECODE( p_col210, FND_API.g_miss_char, col210, p_col210),
1493 col211 = DECODE( p_col211, FND_API.g_miss_char, col211, p_col211),
1494 col212 = DECODE( p_col212, FND_API.g_miss_char, col212, p_col212),
1495 col213 = DECODE( p_col213, FND_API.g_miss_char, col213, p_col213),
1496 col214 = DECODE( p_col214, FND_API.g_miss_char, col214, p_col214),
1497 col215 = DECODE( p_col215, FND_API.g_miss_char, col215, p_col215),
1498 col216 = DECODE( p_col216, FND_API.g_miss_char, col216, p_col216),
1499 col217 = DECODE( p_col217, FND_API.g_miss_char, col217, p_col217),
1500 col218 = DECODE( p_col218, FND_API.g_miss_char, col218, p_col218),
1501 col219 = DECODE( p_col219, FND_API.g_miss_char, col219, p_col219),
1502 col220 = DECODE( p_col220, FND_API.g_miss_char, col220, p_col220),
1503 col221 = DECODE( p_col221, FND_API.g_miss_char, col221, p_col221),
1504 col222 = DECODE( p_col222, FND_API.g_miss_char, col222, p_col222),
1505 col223 = DECODE( p_col223, FND_API.g_miss_char, col223, p_col223),
1506 col224 = DECODE( p_col224, FND_API.g_miss_char, col224, p_col224),
1507 col225 = DECODE( p_col225, FND_API.g_miss_char, col225, p_col225),
1508 col226 = DECODE( p_col226, FND_API.g_miss_char, col226, p_col226),
1509 col227 = DECODE( p_col227, FND_API.g_miss_char, col227, p_col227),
1510 col228 = DECODE( p_col228, FND_API.g_miss_char, col228, p_col228),
1511 col229 = DECODE( p_col229, FND_API.g_miss_char, col229, p_col229),
1512 col230 = DECODE( p_col230, FND_API.g_miss_char, col230, p_col230),
1513 col231 = DECODE( p_col231, FND_API.g_miss_char, col231, p_col231),
1514 col232 = DECODE( p_col232, FND_API.g_miss_char, col232, p_col232),
1515 col233 = DECODE( p_col233, FND_API.g_miss_char, col233, p_col233),
1519 col237 = DECODE( p_col237, FND_API.g_miss_char, col237, p_col237),
1516 col234 = DECODE( p_col234, FND_API.g_miss_char, col234, p_col234),
1517 col235 = DECODE( p_col235, FND_API.g_miss_char, col235, p_col235),
1518 col236 = DECODE( p_col236, FND_API.g_miss_char, col236, p_col236),
1520 col238 = DECODE( p_col238, FND_API.g_miss_char, col238, p_col238),
1521 col239 = DECODE( p_col239, FND_API.g_miss_char, col239, p_col239),
1522 col240 = DECODE( p_col240, FND_API.g_miss_char, col240, p_col240),
1523 col241 = DECODE( p_col241, FND_API.g_miss_char, col241, p_col241),
1524 col242 = DECODE( p_col242, FND_API.g_miss_char, col242, p_col242),
1525 col243 = DECODE( p_col243, FND_API.g_miss_char, col243, p_col243),
1526 col244 = DECODE( p_col244, FND_API.g_miss_char, col244, p_col244),
1527 col245 = DECODE( p_col245, FND_API.g_miss_char, col245, p_col245),
1528 col246 = DECODE( p_col246, FND_API.g_miss_char, col246, p_col246),
1529 col247 = DECODE( p_col247, FND_API.g_miss_char, col247, p_col247),
1530 col248 = DECODE( p_col248, FND_API.g_miss_char, col248, p_col248),
1531 col249 = DECODE( p_col249, FND_API.g_miss_char, col249, p_col249),
1532 col250 = DECODE( p_col250, FND_API.g_miss_char, col250, p_col250),
1533 duplicate_flag = DECODE( p_duplicate_flag, FND_API.g_miss_char, duplicate_flag, p_duplicate_flag),
1534 current_usage = DECODE( p_current_usage, FND_API.g_miss_num, current_usage, p_current_usage),
1535 load_status = DECODE( p_load_status, FND_API.g_miss_char, load_status, p_load_status),
1536 notes = DECODE( p_notes, FND_API.g_miss_char, notes, p_notes),
1537 sales_agent_email_address = DECODE( p_sales_agent_email_address, FND_API.g_miss_char, sales_agent_email_address, p_sales_agent_email_address),
1538 vehicle_response_code = DECODE( p_vehicle_response_code, FND_API.g_miss_char, vehicle_response_code, p_vehicle_response_code),
1539 custom_column1 = DECODE( p_custom_column1, FND_API.g_miss_char, custom_column1, p_custom_column1),
1540 custom_column2 = DECODE( p_custom_column2, FND_API.g_miss_char, custom_column2, p_custom_column2),
1541 custom_column3 = DECODE( p_custom_column3, FND_API.g_miss_char, custom_column3, p_custom_column3),
1542 custom_column4 = DECODE( p_custom_column4, FND_API.g_miss_char, custom_column4, p_custom_column4),
1543 custom_column5 = DECODE( p_custom_column5, FND_API.g_miss_char, custom_column5, p_custom_column5),
1544 custom_column6 = DECODE( p_custom_column6, FND_API.g_miss_char, custom_column6, p_custom_column6),
1545 custom_column7 = DECODE( p_custom_column7, FND_API.g_miss_char, custom_column7, p_custom_column7),
1546 custom_column8 = DECODE( p_custom_column8, FND_API.g_miss_char, custom_column8, p_custom_column8),
1547 custom_column9 = DECODE( p_custom_column9, FND_API.g_miss_char, custom_column9, p_custom_column9),
1548 custom_column10 = DECODE( p_custom_column10, FND_API.g_miss_char, custom_column10, p_custom_column10),
1549 custom_column11 = DECODE( p_custom_column11, FND_API.g_miss_char, custom_column11, p_custom_column11),
1550 custom_column12 = DECODE( p_custom_column12, FND_API.g_miss_char, custom_column12, p_custom_column12),
1551 custom_column13 = DECODE( p_custom_column13, FND_API.g_miss_char, custom_column13, p_custom_column13),
1552 custom_column14 = DECODE( p_custom_column14, FND_API.g_miss_char, custom_column14, p_custom_column14),
1553 custom_column15 = DECODE( p_custom_column15, FND_API.g_miss_char, custom_column15, p_custom_column15),
1554 custom_column16 = DECODE( p_custom_column16, FND_API.g_miss_char, custom_column16, p_custom_column16),
1555 custom_column17 = DECODE( p_custom_column17, FND_API.g_miss_char, custom_column17, p_custom_column17),
1556 custom_column18 = DECODE( p_custom_column18, FND_API.g_miss_char, custom_column18, p_custom_column18),
1557 custom_column19 = DECODE( p_custom_column19, FND_API.g_miss_char, custom_column19, p_custom_column19),
1558 custom_column20 = DECODE( p_custom_column20, FND_API.g_miss_char, custom_column20, p_custom_column20),
1559 custom_column21 = DECODE( p_custom_column21, FND_API.g_miss_char, custom_column21, p_custom_column21),
1560 custom_column22 = DECODE( p_custom_column22, FND_API.g_miss_char, custom_column22, p_custom_column22),
1561 custom_column23 = DECODE( p_custom_column23, FND_API.g_miss_char, custom_column23, p_custom_column23),
1562 custom_column24 = DECODE( p_custom_column24, FND_API.g_miss_char, custom_column24, p_custom_column24),
1563 custom_column25 = DECODE( p_custom_column25, FND_API.g_miss_char, custom_column25, p_custom_column25)
1564
1565
1566 WHERE IMPORT_SOURCE_LINE_ID = p_IMPORT_SOURCE_LINE_ID
1567 AND object_version_number = p_object_version_number;
1568
1569 IF (SQL%NOTFOUND) THEN
1570 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1571 END IF;
1572 END Update_Row;
1573
1574
1575 ----------------------------------------------------------
1576 ---- MEDIA ----
1577 ----------------------------------------------------------
1578
1579 -- ========================================================
1580 --
1581 -- NAME
1582 -- createDeleteBody
1583 --
1584 -- PURPOSE
1585 --
1586 -- NOTES
1587 --
1588 -- HISTORY
1589 --
1590 -- ========================================================
1591 PROCEDURE Delete_Row(
1592 p_IMPORT_SOURCE_LINE_ID NUMBER)
1593 IS
1594 BEGIN
1595 DELETE FROM AMS_IMP_SOURCE_LINES
1596 WHERE IMPORT_SOURCE_LINE_ID = p_IMPORT_SOURCE_LINE_ID;
1597 If (SQL%NOTFOUND) then
1598 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599 End If;
1600 END Delete_Row ;
1601
1602
1603
1604 ----------------------------------------------------------
1605 ---- MEDIA ----
1606 ----------------------------------------------------------
1607
1608 -- ========================================================
1609 --
1610 -- NAME
1611 -- createLockBody
1612 --
1613 -- PURPOSE
1614 --
1618 --
1615 -- NOTES
1616 --
1617 -- HISTORY
1619 -- ========================================================
1620 PROCEDURE Lock_Row(
1621 p_import_source_line_id NUMBER,
1622 p_object_version_number NUMBER,
1623 p_last_update_date DATE,
1624 p_last_updated_by NUMBER,
1625 p_creation_date DATE,
1626 p_created_by NUMBER,
1627 p_last_update_login NUMBER,
1628 p_import_list_header_id NUMBER,
1629 p_import_successful_flag VARCHAR2,
1630 p_enabled_flag VARCHAR2,
1631 p_import_failure_reason VARCHAR2,
1632 p_re_import_last_done_date DATE,
1633 p_party_id NUMBER,
1634 p_dedupe_key VARCHAR2,
1635 p_col1 VARCHAR2,
1636 p_col2 VARCHAR2,
1637 p_col3 VARCHAR2,
1638 p_col4 VARCHAR2,
1639 p_col5 VARCHAR2,
1640 p_col6 VARCHAR2,
1641 p_col7 VARCHAR2,
1642 p_col8 VARCHAR2,
1643 p_col9 VARCHAR2,
1644 p_col10 VARCHAR2,
1645 p_col11 VARCHAR2,
1646 p_col12 VARCHAR2,
1647 p_col13 VARCHAR2,
1648 p_col14 VARCHAR2,
1649 p_col15 VARCHAR2,
1650 p_col16 VARCHAR2,
1651 p_col17 VARCHAR2,
1652 p_col18 VARCHAR2,
1653 p_col19 VARCHAR2,
1654 p_col20 VARCHAR2,
1655 p_col21 VARCHAR2,
1656 p_col22 VARCHAR2,
1657 p_col23 VARCHAR2,
1658 p_col24 VARCHAR2,
1659 p_col25 VARCHAR2,
1660 p_col26 VARCHAR2,
1661 p_col27 VARCHAR2,
1662 p_col28 VARCHAR2,
1663 p_col29 VARCHAR2,
1664 p_col30 VARCHAR2,
1665 p_col31 VARCHAR2,
1666 p_col32 VARCHAR2,
1667 p_col33 VARCHAR2,
1668 p_col34 VARCHAR2,
1669 p_col35 VARCHAR2,
1670 p_col36 VARCHAR2,
1671 p_col37 VARCHAR2,
1672 p_col38 VARCHAR2,
1673 p_col39 VARCHAR2,
1674 p_col40 VARCHAR2,
1675 p_col41 VARCHAR2,
1676 p_col42 VARCHAR2,
1677 p_col43 VARCHAR2,
1678 p_col44 VARCHAR2,
1679 p_col45 VARCHAR2,
1680 p_col46 VARCHAR2,
1681 p_col47 VARCHAR2,
1682 p_col48 VARCHAR2,
1683 p_col49 VARCHAR2,
1684 p_col50 VARCHAR2,
1685 p_col51 VARCHAR2,
1686 p_col52 VARCHAR2,
1687 p_col53 VARCHAR2,
1688 p_col54 VARCHAR2,
1689 p_col55 VARCHAR2,
1690 p_col56 VARCHAR2,
1691 p_col57 VARCHAR2,
1692 p_col58 VARCHAR2,
1693 p_col59 VARCHAR2,
1694 p_col60 VARCHAR2,
1695 p_col61 VARCHAR2,
1696 p_col62 VARCHAR2,
1697 p_col63 VARCHAR2,
1698 p_col64 VARCHAR2,
1699 p_col65 VARCHAR2,
1700 p_col66 VARCHAR2,
1701 p_col67 VARCHAR2,
1702 p_col68 VARCHAR2,
1703 p_col69 VARCHAR2,
1704 p_col70 VARCHAR2,
1705 p_col71 VARCHAR2,
1706 p_col72 VARCHAR2,
1707 p_col73 VARCHAR2,
1708 p_col74 VARCHAR2,
1709 p_col75 VARCHAR2,
1710 p_col76 VARCHAR2,
1711 p_col77 VARCHAR2,
1712 p_col78 VARCHAR2,
1713 p_col79 VARCHAR2,
1714 p_col80 VARCHAR2,
1715 p_col81 VARCHAR2,
1716 p_col82 VARCHAR2,
1717 p_col83 VARCHAR2,
1718 p_col84 VARCHAR2,
1719 p_col85 VARCHAR2,
1720 p_col86 VARCHAR2,
1721 p_col87 VARCHAR2,
1722 p_col88 VARCHAR2,
1723 p_col89 VARCHAR2,
1724 p_col90 VARCHAR2,
1725 p_col91 VARCHAR2,
1726 p_col92 VARCHAR2,
1727 p_col93 VARCHAR2,
1728 p_col94 VARCHAR2,
1729 p_col95 VARCHAR2,
1730 p_col96 VARCHAR2,
1731 p_col97 VARCHAR2,
1732 p_col98 VARCHAR2,
1733 p_col99 VARCHAR2,
1734 p_col100 VARCHAR2,
1735 p_col101 VARCHAR2,
1736 p_col102 VARCHAR2,
1737 p_col103 VARCHAR2,
1738 p_col104 VARCHAR2,
1739 p_col105 VARCHAR2,
1740 p_col106 VARCHAR2,
1741 p_col107 VARCHAR2,
1742 p_col108 VARCHAR2,
1743 p_col109 VARCHAR2,
1744 p_col110 VARCHAR2,
1745 p_col111 VARCHAR2,
1746 p_col112 VARCHAR2,
1747 p_col113 VARCHAR2,
1748 p_col114 VARCHAR2,
1749 p_col115 VARCHAR2,
1750 p_col116 VARCHAR2,
1751 p_col117 VARCHAR2,
1752 p_col118 VARCHAR2,
1753 p_col119 VARCHAR2,
1754 p_col120 VARCHAR2,
1755 p_col121 VARCHAR2,
1756 p_col122 VARCHAR2,
1757 p_col123 VARCHAR2,
1758 p_col124 VARCHAR2,
1759 p_col125 VARCHAR2,
1760 p_col126 VARCHAR2,
1761 p_col127 VARCHAR2,
1762 p_col128 VARCHAR2,
1763 p_col129 VARCHAR2,
1764 p_col130 VARCHAR2,
1765 p_col131 VARCHAR2,
1766 p_col132 VARCHAR2,
1767 p_col133 VARCHAR2,
1768 p_col134 VARCHAR2,
1769 p_col135 VARCHAR2,
1770 p_col136 VARCHAR2,
1774 p_col140 VARCHAR2,
1771 p_col137 VARCHAR2,
1772 p_col138 VARCHAR2,
1773 p_col139 VARCHAR2,
1775 p_col141 VARCHAR2,
1776 p_col142 VARCHAR2,
1777 p_col143 VARCHAR2,
1778 p_col144 VARCHAR2,
1779 p_col145 VARCHAR2,
1780 p_col146 VARCHAR2,
1781 p_col147 VARCHAR2,
1782 p_col148 VARCHAR2,
1783 p_col149 VARCHAR2,
1784 p_col150 VARCHAR2,
1785 p_col151 VARCHAR2,
1786 p_col152 VARCHAR2,
1787 p_col153 VARCHAR2,
1788 p_col154 VARCHAR2,
1789 p_col155 VARCHAR2,
1790 p_col156 VARCHAR2,
1791 p_col157 VARCHAR2,
1792 p_col158 VARCHAR2,
1793 p_col159 VARCHAR2,
1794 p_col160 VARCHAR2,
1795 p_col161 VARCHAR2,
1796 p_col162 VARCHAR2,
1797 p_col163 VARCHAR2,
1798 p_col164 VARCHAR2,
1799 p_col165 VARCHAR2,
1800 p_col166 VARCHAR2,
1801 p_col167 VARCHAR2,
1802 p_col168 VARCHAR2,
1803 p_col169 VARCHAR2,
1804 p_col170 VARCHAR2,
1805 p_col171 VARCHAR2,
1806 p_col172 VARCHAR2,
1807 p_col173 VARCHAR2,
1808 p_col174 VARCHAR2,
1809 p_col175 VARCHAR2,
1810 p_col176 VARCHAR2,
1811 p_col177 VARCHAR2,
1812 p_col178 VARCHAR2,
1813 p_col179 VARCHAR2,
1814 p_col180 VARCHAR2,
1815 p_col181 VARCHAR2,
1816 p_col182 VARCHAR2,
1817 p_col183 VARCHAR2,
1818 p_col184 VARCHAR2,
1819 p_col185 VARCHAR2,
1820 p_col186 VARCHAR2,
1821 p_col187 VARCHAR2,
1822 p_col188 VARCHAR2,
1823 p_col189 VARCHAR2,
1824 p_col190 VARCHAR2,
1825 p_col191 VARCHAR2,
1826 p_col192 VARCHAR2,
1827 p_col193 VARCHAR2,
1828 p_col194 VARCHAR2,
1829 p_col195 VARCHAR2,
1830 p_col196 VARCHAR2,
1831 p_col197 VARCHAR2,
1832 p_col198 VARCHAR2,
1833 p_col199 VARCHAR2,
1834 p_col200 VARCHAR2,
1835 p_col201 VARCHAR2,
1836 p_col202 VARCHAR2,
1837 p_col203 VARCHAR2,
1838 p_col204 VARCHAR2,
1839 p_col205 VARCHAR2,
1840 p_col206 VARCHAR2,
1841 p_col207 VARCHAR2,
1842 p_col208 VARCHAR2,
1843 p_col209 VARCHAR2,
1844 p_col210 VARCHAR2,
1845 p_col211 VARCHAR2,
1846 p_col212 VARCHAR2,
1847 p_col213 VARCHAR2,
1848 p_col214 VARCHAR2,
1849 p_col215 VARCHAR2,
1850 p_col216 VARCHAR2,
1851 p_col217 VARCHAR2,
1852 p_col218 VARCHAR2,
1853 p_col219 VARCHAR2,
1854 p_col220 VARCHAR2,
1855 p_col221 VARCHAR2,
1856 p_col222 VARCHAR2,
1857 p_col223 VARCHAR2,
1858 p_col224 VARCHAR2,
1859 p_col225 VARCHAR2,
1860 p_col226 VARCHAR2,
1861 p_col227 VARCHAR2,
1862 p_col228 VARCHAR2,
1863 p_col229 VARCHAR2,
1864 p_col230 VARCHAR2,
1865 p_col231 VARCHAR2,
1866 p_col232 VARCHAR2,
1867 p_col233 VARCHAR2,
1868 p_col234 VARCHAR2,
1869 p_col235 VARCHAR2,
1870 p_col236 VARCHAR2,
1871 p_col237 VARCHAR2,
1872 p_col238 VARCHAR2,
1873 p_col239 VARCHAR2,
1874 p_col240 VARCHAR2,
1875 p_col241 VARCHAR2,
1876 p_col242 VARCHAR2,
1877 p_col243 VARCHAR2,
1878 p_col244 VARCHAR2,
1879 p_col245 VARCHAR2,
1880 p_col246 VARCHAR2,
1881 p_col247 VARCHAR2,
1882 p_col248 VARCHAR2,
1883 p_col249 VARCHAR2,
1884 p_col250 VARCHAR2,
1885 p_duplicate_flag VARCHAR2,
1886 p_current_usage NUMBER,
1887 p_notes VARCHAR2,
1888 p_sales_agent_email_address VARCHAR2,
1889 p_vehicle_response_code VARCHAR2,
1890 p_custom_column1 VARCHAR2,
1891 p_custom_column2 VARCHAR2,
1892 p_custom_column3 VARCHAR2,
1893 p_custom_column4 VARCHAR2,
1894 p_custom_column5 VARCHAR2,
1895 p_custom_column6 VARCHAR2,
1896 p_custom_column7 VARCHAR2,
1897 p_custom_column8 VARCHAR2,
1898 p_custom_column9 VARCHAR2,
1899 p_custom_column10 VARCHAR2,
1900 p_custom_column11 VARCHAR2,
1901 p_custom_column12 VARCHAR2,
1902 p_custom_column13 VARCHAR2,
1903 p_custom_column14 VARCHAR2,
1904 p_custom_column15 VARCHAR2,
1905 p_custom_column16 VARCHAR2,
1906 p_custom_column17 VARCHAR2,
1907 p_custom_column18 VARCHAR2,
1908 p_custom_column19 VARCHAR2,
1909 p_custom_column20 VARCHAR2,
1910 p_custom_column21 VARCHAR2,
1911 p_custom_column22 VARCHAR2,
1912 p_custom_column23 VARCHAR2,
1913 p_custom_column24 VARCHAR2,
1914 p_custom_column25 VARCHAR2
1915
1916
1917 )
1918
1919
1920 IS
1921 CURSOR C IS
1922 SELECT *
1923 FROM AMS_IMP_SOURCE_LINES
1924 WHERE IMPORT_SOURCE_LINE_ID = p_IMPORT_SOURCE_LINE_ID
1925 FOR UPDATE of IMPORT_SOURCE_LINE_ID NOWAIT;
1926 Recinfo C%ROWTYPE;
1930 If (c%NOTFOUND) then
1927 BEGIN
1928 OPEN c;
1929 FETCH c INTO Recinfo;
1931 CLOSE c;
1932 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1933 APP_EXCEPTION.RAISE_EXCEPTION;
1934 END IF;
1935 CLOSE C;
1936 IF (
1937 ( Recinfo.import_source_line_id = p_import_source_line_id)
1938 AND ( ( Recinfo.object_version_number = p_object_version_number)
1939 OR ( ( Recinfo.object_version_number IS NULL )
1940 AND ( p_object_version_number IS NULL )))
1941 AND ( ( Recinfo.last_update_date = p_last_update_date)
1942 OR ( ( Recinfo.last_update_date IS NULL )
1943 AND ( p_last_update_date IS NULL )))
1944 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
1945 OR ( ( Recinfo.last_updated_by IS NULL )
1946 AND ( p_last_updated_by IS NULL )))
1947 AND ( ( Recinfo.creation_date = p_creation_date)
1948 OR ( ( Recinfo.creation_date IS NULL )
1949 AND ( p_creation_date IS NULL )))
1950 AND ( ( Recinfo.created_by = p_created_by)
1951 OR ( ( Recinfo.created_by IS NULL )
1952 AND ( p_created_by IS NULL )))
1953 AND ( ( Recinfo.last_update_login = p_last_update_login)
1954 OR ( ( Recinfo.last_update_login IS NULL )
1955 AND ( p_last_update_login IS NULL )))
1956 AND ( ( Recinfo.import_list_header_id = p_import_list_header_id)
1957 OR ( ( Recinfo.import_list_header_id IS NULL )
1958 AND ( p_import_list_header_id IS NULL )))
1959 AND ( ( Recinfo.import_successful_flag = p_import_successful_flag)
1960 OR ( ( Recinfo.import_successful_flag IS NULL )
1961 AND ( p_import_successful_flag IS NULL )))
1962 AND ( ( Recinfo.enabled_flag = p_enabled_flag)
1963 OR ( ( Recinfo.enabled_flag IS NULL )
1964 AND ( p_enabled_flag IS NULL )))
1965 AND ( ( Recinfo.import_failure_reason = p_import_failure_reason)
1966 OR ( ( Recinfo.import_failure_reason IS NULL )
1967 AND ( p_import_failure_reason IS NULL )))
1968 AND ( ( Recinfo.re_import_last_done_date = p_re_import_last_done_date)
1969 OR ( ( Recinfo.re_import_last_done_date IS NULL )
1970 AND ( p_re_import_last_done_date IS NULL )))
1971 AND ( ( Recinfo.party_id = p_party_id)
1972 OR ( ( Recinfo.party_id IS NULL )
1973 AND ( p_party_id IS NULL )))
1974 AND ( ( Recinfo.dedupe_key = p_dedupe_key)
1975 OR ( ( Recinfo.dedupe_key IS NULL )
1976 AND ( p_dedupe_key IS NULL )))
1977 AND ( ( Recinfo.col1 = p_col1)
1978 OR ( ( Recinfo.col1 IS NULL )
1979 AND ( p_col1 IS NULL )))
1980 AND ( ( Recinfo.col2 = p_col2)
1981 OR ( ( Recinfo.col2 IS NULL )
1982 AND ( p_col2 IS NULL )))
1983 AND ( ( Recinfo.col3 = p_col3)
1984 OR ( ( Recinfo.col3 IS NULL )
1985 AND ( p_col3 IS NULL )))
1986 AND ( ( Recinfo.col4 = p_col4)
1987 OR ( ( Recinfo.col4 IS NULL )
1988 AND ( p_col4 IS NULL )))
1989 AND ( ( Recinfo.col5 = p_col5)
1990 OR ( ( Recinfo.col5 IS NULL )
1991 AND ( p_col5 IS NULL )))
1992 AND ( ( Recinfo.col6 = p_col6)
1993 OR ( ( Recinfo.col6 IS NULL )
1994 AND ( p_col6 IS NULL )))
1995 AND ( ( Recinfo.col7 = p_col7)
1996 OR ( ( Recinfo.col7 IS NULL )
1997 AND ( p_col7 IS NULL )))
1998 AND ( ( Recinfo.col8 = p_col8)
1999 OR ( ( Recinfo.col8 IS NULL )
2000 AND ( p_col8 IS NULL )))
2001 AND ( ( Recinfo.col9 = p_col9)
2002 OR ( ( Recinfo.col9 IS NULL )
2003 AND ( p_col9 IS NULL )))
2004 AND ( ( Recinfo.col10 = p_col10)
2005 OR ( ( Recinfo.col10 IS NULL )
2006 AND ( p_col10 IS NULL )))
2007 AND ( ( Recinfo.col11 = p_col11)
2008 OR ( ( Recinfo.col11 IS NULL )
2009 AND ( p_col11 IS NULL )))
2010 AND ( ( Recinfo.col12 = p_col12)
2011 OR ( ( Recinfo.col12 IS NULL )
2012 AND ( p_col12 IS NULL )))
2013 AND ( ( Recinfo.col13 = p_col13)
2014 OR ( ( Recinfo.col13 IS NULL )
2015 AND ( p_col13 IS NULL )))
2016 AND ( ( Recinfo.col14 = p_col14)
2017 OR ( ( Recinfo.col14 IS NULL )
2018 AND ( p_col14 IS NULL )))
2019 AND ( ( Recinfo.col15 = p_col15)
2020 OR ( ( Recinfo.col15 IS NULL )
2021 AND ( p_col15 IS NULL )))
2022 AND ( ( Recinfo.col16 = p_col16)
2023 OR ( ( Recinfo.col16 IS NULL )
2024 AND ( p_col16 IS NULL )))
2025 AND ( ( Recinfo.col17 = p_col17)
2026 OR ( ( Recinfo.col17 IS NULL )
2027 AND ( p_col17 IS NULL )))
2028 AND ( ( Recinfo.col18 = p_col18)
2029 OR ( ( Recinfo.col18 IS NULL )
2030 AND ( p_col18 IS NULL )))
2031 AND ( ( Recinfo.col19 = p_col19)
2032 OR ( ( Recinfo.col19 IS NULL )
2033 AND ( p_col19 IS NULL )))
2034 AND ( ( Recinfo.col20 = p_col20)
2035 OR ( ( Recinfo.col20 IS NULL )
2036 AND ( p_col20 IS NULL )))
2037 AND ( ( Recinfo.col21 = p_col21)
2038 OR ( ( Recinfo.col21 IS NULL )
2039 AND ( p_col21 IS NULL )))
2043 AND ( ( Recinfo.col23 = p_col23)
2040 AND ( ( Recinfo.col22 = p_col22)
2041 OR ( ( Recinfo.col22 IS NULL )
2042 AND ( p_col22 IS NULL )))
2044 OR ( ( Recinfo.col23 IS NULL )
2045 AND ( p_col23 IS NULL )))
2046 AND ( ( Recinfo.col24 = p_col24)
2047 OR ( ( Recinfo.col24 IS NULL )
2048 AND ( p_col24 IS NULL )))
2049 AND ( ( Recinfo.col25 = p_col25)
2050 OR ( ( Recinfo.col25 IS NULL )
2051 AND ( p_col25 IS NULL )))
2052 AND ( ( Recinfo.col26 = p_col26)
2053 OR ( ( Recinfo.col26 IS NULL )
2054 AND ( p_col26 IS NULL )))
2055 AND ( ( Recinfo.col27 = p_col27)
2056 OR ( ( Recinfo.col27 IS NULL )
2057 AND ( p_col27 IS NULL )))
2058 AND ( ( Recinfo.col28 = p_col28)
2059 OR ( ( Recinfo.col28 IS NULL )
2060 AND ( p_col28 IS NULL )))
2061 AND ( ( Recinfo.col29 = p_col29)
2062 OR ( ( Recinfo.col29 IS NULL )
2063 AND ( p_col29 IS NULL )))
2064 AND ( ( Recinfo.col30 = p_col30)
2065 OR ( ( Recinfo.col30 IS NULL )
2066 AND ( p_col30 IS NULL )))
2067 AND ( ( Recinfo.col31 = p_col31)
2068 OR ( ( Recinfo.col31 IS NULL )
2069 AND ( p_col31 IS NULL )))
2070 AND ( ( Recinfo.col32 = p_col32)
2071 OR ( ( Recinfo.col32 IS NULL )
2072 AND ( p_col32 IS NULL )))
2073 AND ( ( Recinfo.col33 = p_col33)
2074 OR ( ( Recinfo.col33 IS NULL )
2075 AND ( p_col33 IS NULL )))
2076 AND ( ( Recinfo.col34 = p_col34)
2077 OR ( ( Recinfo.col34 IS NULL )
2078 AND ( p_col34 IS NULL )))
2079 AND ( ( Recinfo.col35 = p_col35)
2080 OR ( ( Recinfo.col35 IS NULL )
2081 AND ( p_col35 IS NULL )))
2082 AND ( ( Recinfo.col36 = p_col36)
2083 OR ( ( Recinfo.col36 IS NULL )
2084 AND ( p_col36 IS NULL )))
2085 AND ( ( Recinfo.col37 = p_col37)
2086 OR ( ( Recinfo.col37 IS NULL )
2087 AND ( p_col37 IS NULL )))
2088 AND ( ( Recinfo.col38 = p_col38)
2089 OR ( ( Recinfo.col38 IS NULL )
2090 AND ( p_col38 IS NULL )))
2091 AND ( ( Recinfo.col39 = p_col39)
2092 OR ( ( Recinfo.col39 IS NULL )
2093 AND ( p_col39 IS NULL )))
2094 AND ( ( Recinfo.col40 = p_col40)
2095 OR ( ( Recinfo.col40 IS NULL )
2096 AND ( p_col40 IS NULL )))
2097 AND ( ( Recinfo.col41 = p_col41)
2098 OR ( ( Recinfo.col41 IS NULL )
2099 AND ( p_col41 IS NULL )))
2100 AND ( ( Recinfo.col42 = p_col42)
2101 OR ( ( Recinfo.col42 IS NULL )
2102 AND ( p_col42 IS NULL )))
2103 AND ( ( Recinfo.col43 = p_col43)
2104 OR ( ( Recinfo.col43 IS NULL )
2105 AND ( p_col43 IS NULL )))
2106 AND ( ( Recinfo.col44 = p_col44)
2107 OR ( ( Recinfo.col44 IS NULL )
2108 AND ( p_col44 IS NULL )))
2109 AND ( ( Recinfo.col45 = p_col45)
2110 OR ( ( Recinfo.col45 IS NULL )
2111 AND ( p_col45 IS NULL )))
2112 AND ( ( Recinfo.col46 = p_col46)
2113 OR ( ( Recinfo.col46 IS NULL )
2114 AND ( p_col46 IS NULL )))
2115 AND ( ( Recinfo.col47 = p_col47)
2116 OR ( ( Recinfo.col47 IS NULL )
2117 AND ( p_col47 IS NULL )))
2118 AND ( ( Recinfo.col48 = p_col48)
2119 OR ( ( Recinfo.col48 IS NULL )
2120 AND ( p_col48 IS NULL )))
2121 AND ( ( Recinfo.col49 = p_col49)
2122 OR ( ( Recinfo.col49 IS NULL )
2123 AND ( p_col49 IS NULL )))
2124 AND ( ( Recinfo.col50 = p_col50)
2125 OR ( ( Recinfo.col50 IS NULL )
2126 AND ( p_col50 IS NULL )))
2127 AND ( ( Recinfo.col51 = p_col51)
2128 OR ( ( Recinfo.col51 IS NULL )
2129 AND ( p_col51 IS NULL )))
2130 AND ( ( Recinfo.col52 = p_col52)
2131 OR ( ( Recinfo.col52 IS NULL )
2132 AND ( p_col52 IS NULL )))
2133 AND ( ( Recinfo.col53 = p_col53)
2134 OR ( ( Recinfo.col53 IS NULL )
2135 AND ( p_col53 IS NULL )))
2136 AND ( ( Recinfo.col54 = p_col54)
2137 OR ( ( Recinfo.col54 IS NULL )
2138 AND ( p_col54 IS NULL )))
2139 AND ( ( Recinfo.col55 = p_col55)
2140 OR ( ( Recinfo.col55 IS NULL )
2141 AND ( p_col55 IS NULL )))
2142 AND ( ( Recinfo.col56 = p_col56)
2143 OR ( ( Recinfo.col56 IS NULL )
2144 AND ( p_col56 IS NULL )))
2145 AND ( ( Recinfo.col57 = p_col57)
2146 OR ( ( Recinfo.col57 IS NULL )
2147 AND ( p_col57 IS NULL )))
2148 AND ( ( Recinfo.col58 = p_col58)
2149 OR ( ( Recinfo.col58 IS NULL )
2150 AND ( p_col58 IS NULL )))
2151 AND ( ( Recinfo.col59 = p_col59)
2152 OR ( ( Recinfo.col59 IS NULL )
2153 AND ( p_col59 IS NULL )))
2154 AND ( ( Recinfo.col60 = p_col60)
2155 OR ( ( Recinfo.col60 IS NULL )
2156 AND ( p_col60 IS NULL )))
2157 AND ( ( Recinfo.col61 = p_col61)
2158 OR ( ( Recinfo.col61 IS NULL )
2159 AND ( p_col61 IS NULL )))
2160 AND ( ( Recinfo.col62 = p_col62)
2161 OR ( ( Recinfo.col62 IS NULL )
2162 AND ( p_col62 IS NULL )))
2166 AND ( ( Recinfo.col64 = p_col64)
2163 AND ( ( Recinfo.col63 = p_col63)
2164 OR ( ( Recinfo.col63 IS NULL )
2165 AND ( p_col63 IS NULL )))
2167 OR ( ( Recinfo.col64 IS NULL )
2168 AND ( p_col64 IS NULL )))
2169 AND ( ( Recinfo.col65 = p_col65)
2170 OR ( ( Recinfo.col65 IS NULL )
2171 AND ( p_col65 IS NULL )))
2172 AND ( ( Recinfo.col66 = p_col66)
2173 OR ( ( Recinfo.col66 IS NULL )
2174 AND ( p_col66 IS NULL )))
2175 AND ( ( Recinfo.col67 = p_col67)
2176 OR ( ( Recinfo.col67 IS NULL )
2177 AND ( p_col67 IS NULL )))
2178 AND ( ( Recinfo.col68 = p_col68)
2179 OR ( ( Recinfo.col68 IS NULL )
2180 AND ( p_col68 IS NULL )))
2181 AND ( ( Recinfo.col69 = p_col69)
2182 OR ( ( Recinfo.col69 IS NULL )
2183 AND ( p_col69 IS NULL )))
2184 AND ( ( Recinfo.col70 = p_col70)
2185 OR ( ( Recinfo.col70 IS NULL )
2186 AND ( p_col70 IS NULL )))
2187 AND ( ( Recinfo.col71 = p_col71)
2188 OR ( ( Recinfo.col71 IS NULL )
2189 AND ( p_col71 IS NULL )))
2190 AND ( ( Recinfo.col72 = p_col72)
2191 OR ( ( Recinfo.col72 IS NULL )
2192 AND ( p_col72 IS NULL )))
2193 AND ( ( Recinfo.col73 = p_col73)
2194 OR ( ( Recinfo.col73 IS NULL )
2195 AND ( p_col73 IS NULL )))
2196 AND ( ( Recinfo.col74 = p_col74)
2197 OR ( ( Recinfo.col74 IS NULL )
2198 AND ( p_col74 IS NULL )))
2199 AND ( ( Recinfo.col75 = p_col75)
2200 OR ( ( Recinfo.col75 IS NULL )
2201 AND ( p_col75 IS NULL )))
2202 AND ( ( Recinfo.col76 = p_col76)
2203 OR ( ( Recinfo.col76 IS NULL )
2204 AND ( p_col76 IS NULL )))
2205 AND ( ( Recinfo.col77 = p_col77)
2206 OR ( ( Recinfo.col77 IS NULL )
2207 AND ( p_col77 IS NULL )))
2208 AND ( ( Recinfo.col78 = p_col78)
2209 OR ( ( Recinfo.col78 IS NULL )
2210 AND ( p_col78 IS NULL )))
2211 AND ( ( Recinfo.col79 = p_col79)
2212 OR ( ( Recinfo.col79 IS NULL )
2213 AND ( p_col79 IS NULL )))
2214 AND ( ( Recinfo.col80 = p_col80)
2215 OR ( ( Recinfo.col80 IS NULL )
2216 AND ( p_col80 IS NULL )))
2217 AND ( ( Recinfo.col81 = p_col81)
2218 OR ( ( Recinfo.col81 IS NULL )
2219 AND ( p_col81 IS NULL )))
2220 AND ( ( Recinfo.col82 = p_col82)
2221 OR ( ( Recinfo.col82 IS NULL )
2222 AND ( p_col82 IS NULL )))
2223 AND ( ( Recinfo.col83 = p_col83)
2224 OR ( ( Recinfo.col83 IS NULL )
2225 AND ( p_col83 IS NULL )))
2226 AND ( ( Recinfo.col84 = p_col84)
2227 OR ( ( Recinfo.col84 IS NULL )
2228 AND ( p_col84 IS NULL )))
2229 AND ( ( Recinfo.col85 = p_col85)
2230 OR ( ( Recinfo.col85 IS NULL )
2231 AND ( p_col85 IS NULL )))
2232 AND ( ( Recinfo.col86 = p_col86)
2233 OR ( ( Recinfo.col86 IS NULL )
2234 AND ( p_col86 IS NULL )))
2235 AND ( ( Recinfo.col87 = p_col87)
2236 OR ( ( Recinfo.col87 IS NULL )
2237 AND ( p_col87 IS NULL )))
2238 AND ( ( Recinfo.col88 = p_col88)
2239 OR ( ( Recinfo.col88 IS NULL )
2240 AND ( p_col88 IS NULL )))
2241 AND ( ( Recinfo.col89 = p_col89)
2242 OR ( ( Recinfo.col89 IS NULL )
2243 AND ( p_col89 IS NULL )))
2244 AND ( ( Recinfo.col90 = p_col90)
2245 OR ( ( Recinfo.col90 IS NULL )
2246 AND ( p_col90 IS NULL )))
2247 AND ( ( Recinfo.col91 = p_col91)
2248 OR ( ( Recinfo.col91 IS NULL )
2249 AND ( p_col91 IS NULL )))
2250 AND ( ( Recinfo.col92 = p_col92)
2251 OR ( ( Recinfo.col92 IS NULL )
2252 AND ( p_col92 IS NULL )))
2253 AND ( ( Recinfo.col93 = p_col93)
2254 OR ( ( Recinfo.col93 IS NULL )
2255 AND ( p_col93 IS NULL )))
2256 AND ( ( Recinfo.col94 = p_col94)
2257 OR ( ( Recinfo.col94 IS NULL )
2258 AND ( p_col94 IS NULL )))
2259 AND ( ( Recinfo.col95 = p_col95)
2260 OR ( ( Recinfo.col95 IS NULL )
2261 AND ( p_col95 IS NULL )))
2262 AND ( ( Recinfo.col96 = p_col96)
2263 OR ( ( Recinfo.col96 IS NULL )
2264 AND ( p_col96 IS NULL )))
2265 AND ( ( Recinfo.col97 = p_col97)
2266 OR ( ( Recinfo.col97 IS NULL )
2267 AND ( p_col97 IS NULL )))
2268 AND ( ( Recinfo.col98 = p_col98)
2269 OR ( ( Recinfo.col98 IS NULL )
2270 AND ( p_col98 IS NULL )))
2271 AND ( ( Recinfo.col99 = p_col99)
2272 OR ( ( Recinfo.col99 IS NULL )
2273 AND ( p_col99 IS NULL )))
2274 AND ( ( Recinfo.col100 = p_col100)
2275 OR ( ( Recinfo.col100 IS NULL )
2276 AND ( p_col100 IS NULL )))
2277 AND ( ( Recinfo.col101 = p_col101)
2278 OR ( ( Recinfo.col101 IS NULL )
2279 AND ( p_col101 IS NULL )))
2280 AND ( ( Recinfo.col102 = p_col102)
2281 OR ( ( Recinfo.col102 IS NULL )
2282 AND ( p_col102 IS NULL )))
2283 AND ( ( Recinfo.col103 = p_col103)
2284 OR ( ( Recinfo.col103 IS NULL )
2288 AND ( p_col104 IS NULL )))
2285 AND ( p_col103 IS NULL )))
2286 AND ( ( Recinfo.col104 = p_col104)
2287 OR ( ( Recinfo.col104 IS NULL )
2289 AND ( ( Recinfo.col105 = p_col105)
2290 OR ( ( Recinfo.col105 IS NULL )
2291 AND ( p_col105 IS NULL )))
2292 AND ( ( Recinfo.col106 = p_col106)
2293 OR ( ( Recinfo.col106 IS NULL )
2294 AND ( p_col106 IS NULL )))
2295 AND ( ( Recinfo.col107 = p_col107)
2296 OR ( ( Recinfo.col107 IS NULL )
2297 AND ( p_col107 IS NULL )))
2298 AND ( ( Recinfo.col108 = p_col108)
2299 OR ( ( Recinfo.col108 IS NULL )
2300 AND ( p_col108 IS NULL )))
2301 AND ( ( Recinfo.col109 = p_col109)
2302 OR ( ( Recinfo.col109 IS NULL )
2303 AND ( p_col109 IS NULL )))
2304 AND ( ( Recinfo.col110 = p_col110)
2305 OR ( ( Recinfo.col110 IS NULL )
2306 AND ( p_col110 IS NULL )))
2307 AND ( ( Recinfo.col111 = p_col111)
2308 OR ( ( Recinfo.col111 IS NULL )
2309 AND ( p_col111 IS NULL )))
2310 AND ( ( Recinfo.col112 = p_col112)
2311 OR ( ( Recinfo.col112 IS NULL )
2312 AND ( p_col112 IS NULL )))
2313 AND ( ( Recinfo.col113 = p_col113)
2314 OR ( ( Recinfo.col113 IS NULL )
2315 AND ( p_col113 IS NULL )))
2316 AND ( ( Recinfo.col114 = p_col114)
2317 OR ( ( Recinfo.col114 IS NULL )
2318 AND ( p_col114 IS NULL )))
2319 AND ( ( Recinfo.col115 = p_col115)
2320 OR ( ( Recinfo.col115 IS NULL )
2321 AND ( p_col115 IS NULL )))
2322 AND ( ( Recinfo.col116 = p_col116)
2323 OR ( ( Recinfo.col116 IS NULL )
2324 AND ( p_col116 IS NULL )))
2325 AND ( ( Recinfo.col117 = p_col117)
2326 OR ( ( Recinfo.col117 IS NULL )
2327 AND ( p_col117 IS NULL )))
2331 AND ( ( Recinfo.col119 = p_col119)
2328 AND ( ( Recinfo.col118 = p_col118)
2329 OR ( ( Recinfo.col118 IS NULL )
2330 AND ( p_col118 IS NULL )))
2332 OR ( ( Recinfo.col119 IS NULL )
2333 AND ( p_col119 IS NULL )))
2334 AND ( ( Recinfo.col120 = p_col120)
2335 OR ( ( Recinfo.col120 IS NULL )
2336 AND ( p_col120 IS NULL )))
2337 AND ( ( Recinfo.col121 = p_col121)
2338 OR ( ( Recinfo.col121 IS NULL )
2339 AND ( p_col121 IS NULL )))
2340 AND ( ( Recinfo.col122 = p_col122)
2341 OR ( ( Recinfo.col122 IS NULL )
2342 AND ( p_col122 IS NULL )))
2343 AND ( ( Recinfo.col123 = p_col123)
2344 OR ( ( Recinfo.col123 IS NULL )
2345 AND ( p_col123 IS NULL )))
2346 AND ( ( Recinfo.col124 = p_col124)
2347 OR ( ( Recinfo.col124 IS NULL )
2348 AND ( p_col124 IS NULL )))
2349 AND ( ( Recinfo.col125 = p_col125)
2350 OR ( ( Recinfo.col125 IS NULL )
2351 AND ( p_col125 IS NULL )))
2352 AND ( ( Recinfo.col126 = p_col126)
2353 OR ( ( Recinfo.col126 IS NULL )
2354 AND ( p_col126 IS NULL )))
2355 AND ( ( Recinfo.col127 = p_col127)
2356 OR ( ( Recinfo.col127 IS NULL )
2357 AND ( p_col127 IS NULL )))
2358 AND ( ( Recinfo.col128 = p_col128)
2359 OR ( ( Recinfo.col128 IS NULL )
2360 AND ( p_col128 IS NULL )))
2361 AND ( ( Recinfo.col129 = p_col129)
2362 OR ( ( Recinfo.col129 IS NULL )
2363 AND ( p_col129 IS NULL )))
2364 AND ( ( Recinfo.col130 = p_col130)
2365 OR ( ( Recinfo.col130 IS NULL )
2366 AND ( p_col130 IS NULL )))
2367 AND ( ( Recinfo.col131 = p_col131)
2368 OR ( ( Recinfo.col131 IS NULL )
2369 AND ( p_col131 IS NULL )))
2370 AND ( ( Recinfo.col132 = p_col132)
2371 OR ( ( Recinfo.col132 IS NULL )
2372 AND ( p_col132 IS NULL )))
2373 AND ( ( Recinfo.col133 = p_col133)
2374 OR ( ( Recinfo.col133 IS NULL )
2375 AND ( p_col133 IS NULL )))
2376 AND ( ( Recinfo.col134 = p_col134)
2377 OR ( ( Recinfo.col134 IS NULL )
2378 AND ( p_col134 IS NULL )))
2379 AND ( ( Recinfo.col135 = p_col135)
2380 OR ( ( Recinfo.col135 IS NULL )
2384 AND ( p_col136 IS NULL )))
2381 AND ( p_col135 IS NULL )))
2382 AND ( ( Recinfo.col136 = p_col136)
2383 OR ( ( Recinfo.col136 IS NULL )
2385 AND ( ( Recinfo.col137 = p_col137)
2386 OR ( ( Recinfo.col137 IS NULL )
2387 AND ( p_col137 IS NULL )))
2388 AND ( ( Recinfo.col138 = p_col138)
2389 OR ( ( Recinfo.col138 IS NULL )
2390 AND ( p_col138 IS NULL )))
2391 AND ( ( Recinfo.col139 = p_col139)
2392 OR ( ( Recinfo.col139 IS NULL )
2393 AND ( p_col139 IS NULL )))
2394 AND ( ( Recinfo.col140 = p_col140)
2395 OR ( ( Recinfo.col140 IS NULL )
2396 AND ( p_col140 IS NULL )))
2397 AND ( ( Recinfo.col141 = p_col141)
2398 OR ( ( Recinfo.col141 IS NULL )
2399 AND ( p_col141 IS NULL )))
2400 AND ( ( Recinfo.col142 = p_col142)
2401 OR ( ( Recinfo.col142 IS NULL )
2402 AND ( p_col142 IS NULL )))
2403 AND ( ( Recinfo.col143 = p_col143)
2404 OR ( ( Recinfo.col143 IS NULL )
2405 AND ( p_col143 IS NULL )))
2406 AND ( ( Recinfo.col144 = p_col144)
2407 OR ( ( Recinfo.col144 IS NULL )
2408 AND ( p_col144 IS NULL )))
2409 AND ( ( Recinfo.col145 = p_col145)
2410 OR ( ( Recinfo.col145 IS NULL )
2411 AND ( p_col145 IS NULL )))
2412 AND ( ( Recinfo.col146 = p_col146)
2413 OR ( ( Recinfo.col146 IS NULL )
2414 AND ( p_col146 IS NULL )))
2415 AND ( ( Recinfo.col147 = p_col147)
2416 OR ( ( Recinfo.col147 IS NULL )
2417 AND ( p_col147 IS NULL )))
2418 AND ( ( Recinfo.col148 = p_col148)
2419 OR ( ( Recinfo.col148 IS NULL )
2420 AND ( p_col148 IS NULL )))
2421 AND ( ( Recinfo.col149 = p_col149)
2422 OR ( ( Recinfo.col149 IS NULL )
2423 AND ( p_col149 IS NULL )))
2424 AND ( ( Recinfo.col150 = p_col150)
2425 OR ( ( Recinfo.col150 IS NULL )
2426 AND ( p_col150 IS NULL )))
2427 AND ( ( Recinfo.col151 = p_col151)
2428 OR ( ( Recinfo.col151 IS NULL )
2429 AND ( p_col151 IS NULL )))
2430 AND ( ( Recinfo.col152 = p_col152)
2431 OR ( ( Recinfo.col152 IS NULL )
2432 AND ( p_col152 IS NULL )))
2433 AND ( ( Recinfo.col153 = p_col153)
2434 OR ( ( Recinfo.col153 IS NULL )
2435 AND ( p_col153 IS NULL )))
2436 AND ( ( Recinfo.col154 = p_col154)
2437 OR ( ( Recinfo.col154 IS NULL )
2438 AND ( p_col154 IS NULL )))
2439 AND ( ( Recinfo.col155 = p_col155)
2440 OR ( ( Recinfo.col155 IS NULL )
2441 AND ( p_col155 IS NULL )))
2442 AND ( ( Recinfo.col156 = p_col156)
2443 OR ( ( Recinfo.col156 IS NULL )
2444 AND ( p_col156 IS NULL )))
2445 AND ( ( Recinfo.col157 = p_col157)
2446 OR ( ( Recinfo.col157 IS NULL )
2447 AND ( p_col157 IS NULL )))
2448 AND ( ( Recinfo.col158 = p_col158)
2449 OR ( ( Recinfo.col158 IS NULL )
2450 AND ( p_col158 IS NULL )))
2451 AND ( ( Recinfo.col159 = p_col159)
2452 OR ( ( Recinfo.col159 IS NULL )
2453 AND ( p_col159 IS NULL )))
2454 AND ( ( Recinfo.col160 = p_col160)
2455 OR ( ( Recinfo.col160 IS NULL )
2456 AND ( p_col160 IS NULL )))
2457 AND ( ( Recinfo.col161 = p_col161)
2458 OR ( ( Recinfo.col161 IS NULL )
2459 AND ( p_col161 IS NULL )))
2460 AND ( ( Recinfo.col162 = p_col162)
2461 OR ( ( Recinfo.col162 IS NULL )
2462 AND ( p_col162 IS NULL )))
2463 AND ( ( Recinfo.col163 = p_col163)
2464 OR ( ( Recinfo.col163 IS NULL )
2465 AND ( p_col163 IS NULL )))
2466 AND ( ( Recinfo.col164 = p_col164)
2467 OR ( ( Recinfo.col164 IS NULL )
2468 AND ( p_col164 IS NULL )))
2469 AND ( ( Recinfo.col165 = p_col165)
2470 OR ( ( Recinfo.col165 IS NULL )
2471 AND ( p_col165 IS NULL )))
2472 AND ( ( Recinfo.col166 = p_col166)
2473 OR ( ( Recinfo.col166 IS NULL )
2474 AND ( p_col166 IS NULL )))
2475 AND ( ( Recinfo.col167 = p_col167)
2476 OR ( ( Recinfo.col167 IS NULL )
2477 AND ( p_col167 IS NULL )))
2478 AND ( ( Recinfo.col168 = p_col168)
2479 OR ( ( Recinfo.col168 IS NULL )
2480 AND ( p_col168 IS NULL )))
2481 AND ( ( Recinfo.col169 = p_col169)
2482 OR ( ( Recinfo.col169 IS NULL )
2483 AND ( p_col169 IS NULL )))
2484 AND ( ( Recinfo.col170 = p_col170)
2485 OR ( ( Recinfo.col170 IS NULL )
2486 AND ( p_col170 IS NULL )))
2487 AND ( ( Recinfo.col171 = p_col171)
2488 OR ( ( Recinfo.col171 IS NULL )
2489 AND ( p_col171 IS NULL )))
2490 AND ( ( Recinfo.col172 = p_col172)
2491 OR ( ( Recinfo.col172 IS NULL )
2492 AND ( p_col172 IS NULL )))
2493 AND ( ( Recinfo.col173 = p_col173)
2494 OR ( ( Recinfo.col173 IS NULL )
2495 AND ( p_col173 IS NULL )))
2496 AND ( ( Recinfo.col174 = p_col174)
2497 OR ( ( Recinfo.col174 IS NULL )
2501 AND ( p_col175 IS NULL )))
2498 AND ( p_col174 IS NULL )))
2499 AND ( ( Recinfo.col175 = p_col175)
2500 OR ( ( Recinfo.col175 IS NULL )
2502 AND ( ( Recinfo.col176 = p_col176)
2503 OR ( ( Recinfo.col176 IS NULL )
2504 AND ( p_col176 IS NULL )))
2505 AND ( ( Recinfo.col177 = p_col177)
2506 OR ( ( Recinfo.col177 IS NULL )
2507 AND ( p_col177 IS NULL )))
2508 AND ( ( Recinfo.col178 = p_col178)
2509 OR ( ( Recinfo.col178 IS NULL )
2510 AND ( p_col178 IS NULL )))
2511 AND ( ( Recinfo.col179 = p_col179)
2512 OR ( ( Recinfo.col179 IS NULL )
2513 AND ( p_col179 IS NULL )))
2514 AND ( ( Recinfo.col180 = p_col180)
2515 OR ( ( Recinfo.col180 IS NULL )
2516 AND ( p_col180 IS NULL )))
2517 AND ( ( Recinfo.col181 = p_col181)
2518 OR ( ( Recinfo.col181 IS NULL )
2519 AND ( p_col181 IS NULL )))
2520 AND ( ( Recinfo.col182 = p_col182)
2521 OR ( ( Recinfo.col182 IS NULL )
2522 AND ( p_col182 IS NULL )))
2523 AND ( ( Recinfo.col183 = p_col183)
2524 OR ( ( Recinfo.col183 IS NULL )
2525 AND ( p_col183 IS NULL )))
2526 AND ( ( Recinfo.col184 = p_col184)
2527 OR ( ( Recinfo.col184 IS NULL )
2528 AND ( p_col184 IS NULL )))
2529 AND ( ( Recinfo.col185 = p_col185)
2530 OR ( ( Recinfo.col185 IS NULL )
2531 AND ( p_col185 IS NULL )))
2532 AND ( ( Recinfo.col186 = p_col186)
2533 OR ( ( Recinfo.col186 IS NULL )
2534 AND ( p_col186 IS NULL )))
2535 AND ( ( Recinfo.col187 = p_col187)
2536 OR ( ( Recinfo.col187 IS NULL )
2537 AND ( p_col187 IS NULL )))
2538 AND ( ( Recinfo.col188 = p_col188)
2539 OR ( ( Recinfo.col188 IS NULL )
2540 AND ( p_col188 IS NULL )))
2541 AND ( ( Recinfo.col189 = p_col189)
2542 OR ( ( Recinfo.col189 IS NULL )
2543 AND ( p_col189 IS NULL )))
2544 AND ( ( Recinfo.col190 = p_col190)
2545 OR ( ( Recinfo.col190 IS NULL )
2546 AND ( p_col190 IS NULL )))
2547 AND ( ( Recinfo.col191 = p_col191)
2548 OR ( ( Recinfo.col191 IS NULL )
2549 AND ( p_col191 IS NULL )))
2550 AND ( ( Recinfo.col192 = p_col192)
2551 OR ( ( Recinfo.col192 IS NULL )
2552 AND ( p_col192 IS NULL )))
2553 AND ( ( Recinfo.col193 = p_col193)
2554 OR ( ( Recinfo.col193 IS NULL )
2555 AND ( p_col193 IS NULL )))
2556 AND ( ( Recinfo.col194 = p_col194)
2557 OR ( ( Recinfo.col194 IS NULL )
2558 AND ( p_col194 IS NULL )))
2559 AND ( ( Recinfo.col195 = p_col195)
2560 OR ( ( Recinfo.col195 IS NULL )
2561 AND ( p_col195 IS NULL )))
2562 AND ( ( Recinfo.col196 = p_col196)
2563 OR ( ( Recinfo.col196 IS NULL )
2564 AND ( p_col196 IS NULL )))
2565 AND ( ( Recinfo.col197 = p_col197)
2566 OR ( ( Recinfo.col197 IS NULL )
2567 AND ( p_col197 IS NULL )))
2568 AND ( ( Recinfo.col198 = p_col198)
2569 OR ( ( Recinfo.col198 IS NULL )
2570 AND ( p_col198 IS NULL )))
2571 AND ( ( Recinfo.col199 = p_col199)
2572 OR ( ( Recinfo.col199 IS NULL )
2573 AND ( p_col199 IS NULL )))
2574 AND ( ( Recinfo.col200 = p_col200)
2575 OR ( ( Recinfo.col200 IS NULL )
2576 AND ( p_col200 IS NULL )))
2577 AND ( ( Recinfo.col201 = p_col201)
2578 OR ( ( Recinfo.col201 IS NULL )
2579 AND ( p_col201 IS NULL )))
2580 AND ( ( Recinfo.col202 = p_col202)
2581 OR ( ( Recinfo.col202 IS NULL )
2582 AND ( p_col202 IS NULL )))
2583 AND ( ( Recinfo.col203 = p_col203)
2584 OR ( ( Recinfo.col203 IS NULL )
2585 AND ( p_col203 IS NULL )))
2586 AND ( ( Recinfo.col204 = p_col204)
2587 OR ( ( Recinfo.col204 IS NULL )
2588 AND ( p_col204 IS NULL )))
2589 AND ( ( Recinfo.col205 = p_col205)
2590 OR ( ( Recinfo.col205 IS NULL )
2591 AND ( p_col205 IS NULL )))
2592 AND ( ( Recinfo.col206 = p_col206)
2593 OR ( ( Recinfo.col206 IS NULL )
2594 AND ( p_col206 IS NULL )))
2595 AND ( ( Recinfo.col207 = p_col207)
2596 OR ( ( Recinfo.col207 IS NULL )
2597 AND ( p_col207 IS NULL )))
2598 AND ( ( Recinfo.col208 = p_col208)
2599 OR ( ( Recinfo.col208 IS NULL )
2600 AND ( p_col208 IS NULL )))
2601 AND ( ( Recinfo.col209 = p_col209)
2602 OR ( ( Recinfo.col209 IS NULL )
2603 AND ( p_col209 IS NULL )))
2604 AND ( ( Recinfo.col210 = p_col210)
2605 OR ( ( Recinfo.col210 IS NULL )
2606 AND ( p_col210 IS NULL )))
2607 AND ( ( Recinfo.col211 = p_col211)
2611 OR ( ( Recinfo.col212 IS NULL )
2608 OR ( ( Recinfo.col211 IS NULL )
2609 AND ( p_col211 IS NULL )))
2610 AND ( ( Recinfo.col212 = p_col212)
2612 AND ( p_col212 IS NULL )))
2613 AND ( ( Recinfo.col213 = p_col213)
2614 OR ( ( Recinfo.col213 IS NULL )
2615 AND ( p_col213 IS NULL )))
2616 AND ( ( Recinfo.col214 = p_col214)
2617 OR ( ( Recinfo.col214 IS NULL )
2618 AND ( p_col214 IS NULL )))
2619 AND ( ( Recinfo.col215 = p_col215)
2620 OR ( ( Recinfo.col215 IS NULL )
2621 AND ( p_col215 IS NULL )))
2622 AND ( ( Recinfo.col216 = p_col216)
2623 OR ( ( Recinfo.col216 IS NULL )
2624 AND ( p_col216 IS NULL )))
2625 AND ( ( Recinfo.col217 = p_col217)
2626 OR ( ( Recinfo.col217 IS NULL )
2627 AND ( p_col217 IS NULL )))
2628 AND ( ( Recinfo.col218 = p_col218)
2629 OR ( ( Recinfo.col218 IS NULL )
2630 AND ( p_col218 IS NULL )))
2631 AND ( ( Recinfo.col219 = p_col219)
2632 OR ( ( Recinfo.col219 IS NULL )
2633 AND ( p_col219 IS NULL )))
2634 AND ( ( Recinfo.col220 = p_col220)
2635 OR ( ( Recinfo.col220 IS NULL )
2636 AND ( p_col220 IS NULL )))
2637 AND ( ( Recinfo.col221 = p_col221)
2638 OR ( ( Recinfo.col221 IS NULL )
2639 AND ( p_col221 IS NULL )))
2640 AND ( ( Recinfo.col222 = p_col222)
2641 OR ( ( Recinfo.col222 IS NULL )
2642 AND ( p_col222 IS NULL )))
2643 AND ( ( Recinfo.col223 = p_col223)
2644 OR ( ( Recinfo.col223 IS NULL )
2645 AND ( p_col223 IS NULL )))
2646 AND ( ( Recinfo.col224 = p_col224)
2647 OR ( ( Recinfo.col224 IS NULL )
2648 AND ( p_col224 IS NULL )))
2649 AND ( ( Recinfo.col225 = p_col225)
2650 OR ( ( Recinfo.col225 IS NULL )
2651 AND ( p_col225 IS NULL )))
2652 AND ( ( Recinfo.col226 = p_col226)
2653 OR ( ( Recinfo.col226 IS NULL )
2654 AND ( p_col226 IS NULL )))
2655 AND ( ( Recinfo.col227 = p_col227)
2656 OR ( ( Recinfo.col227 IS NULL )
2657 AND ( p_col227 IS NULL )))
2658 AND ( ( Recinfo.col228 = p_col228)
2659 OR ( ( Recinfo.col228 IS NULL )
2660 AND ( p_col228 IS NULL )))
2661 AND ( ( Recinfo.col229 = p_col229)
2662 OR ( ( Recinfo.col229 IS NULL )
2663 AND ( p_col229 IS NULL )))
2664 AND ( ( Recinfo.col230 = p_col230)
2665 OR ( ( Recinfo.col230 IS NULL )
2666 AND ( p_col230 IS NULL )))
2667 AND ( ( Recinfo.col231 = p_col231)
2668 OR ( ( Recinfo.col231 IS NULL )
2669 AND ( p_col231 IS NULL )))
2670 AND ( ( Recinfo.col232 = p_col232)
2671 OR ( ( Recinfo.col232 IS NULL )
2672 AND ( p_col232 IS NULL )))
2673 AND ( ( Recinfo.col233 = p_col233)
2674 OR ( ( Recinfo.col233 IS NULL )
2675 AND ( p_col233 IS NULL )))
2676 AND ( ( Recinfo.col234 = p_col234)
2677 OR ( ( Recinfo.col234 IS NULL )
2678 AND ( p_col234 IS NULL )))
2679 AND ( ( Recinfo.col235 = p_col235)
2680 OR ( ( Recinfo.col235 IS NULL )
2681 AND ( p_col235 IS NULL )))
2682 AND ( ( Recinfo.col236 = p_col236)
2683 OR ( ( Recinfo.col236 IS NULL )
2684 AND ( p_col236 IS NULL )))
2685 AND ( ( Recinfo.col237 = p_col237)
2686 OR ( ( Recinfo.col237 IS NULL )
2687 AND ( p_col237 IS NULL )))
2688 AND ( ( Recinfo.col238 = p_col238)
2689 OR ( ( Recinfo.col238 IS NULL )
2690 AND ( p_col238 IS NULL )))
2691 AND ( ( Recinfo.col239 = p_col239)
2692 OR ( ( Recinfo.col239 IS NULL )
2693 AND ( p_col239 IS NULL )))
2694 AND ( ( Recinfo.col240 = p_col240)
2695 OR ( ( Recinfo.col240 IS NULL )
2696 AND ( p_col240 IS NULL )))
2697 AND ( ( Recinfo.col241 = p_col241)
2698 OR ( ( Recinfo.col241 IS NULL )
2699 AND ( p_col241 IS NULL )))
2700 AND ( ( Recinfo.col242 = p_col242)
2701 OR ( ( Recinfo.col242 IS NULL )
2702 AND ( p_col242 IS NULL )))
2703 AND ( ( Recinfo.col243 = p_col243)
2704 OR ( ( Recinfo.col243 IS NULL )
2705 AND ( p_col243 IS NULL )))
2706 AND ( ( Recinfo.col244 = p_col244)
2707 OR ( ( Recinfo.col244 IS NULL )
2708 AND ( p_col244 IS NULL )))
2709 AND ( ( Recinfo.col245 = p_col245)
2710 OR ( ( Recinfo.col245 IS NULL )
2711 AND ( p_col245 IS NULL )))
2712 AND ( ( Recinfo.col246 = p_col246)
2713 OR ( ( Recinfo.col246 IS NULL )
2714 AND ( p_col246 IS NULL )))
2715 AND ( ( Recinfo.col247 = p_col247)
2716 OR ( ( Recinfo.col247 IS NULL )
2717 AND ( p_col247 IS NULL )))
2718 AND ( ( Recinfo.col248 = p_col248)
2719 OR ( ( Recinfo.col248 IS NULL )
2720 AND ( p_col248 IS NULL )))
2721 AND ( ( Recinfo.col249 = p_col249)
2722 OR ( ( Recinfo.col249 IS NULL )
2723 AND ( p_col249 IS NULL )))
2724 AND ( ( Recinfo.col250 = p_col250)
2725 OR ( ( Recinfo.col250 IS NULL )
2726 AND ( p_col250 IS NULL )))
2727 AND ( ( Recinfo.duplicate_flag = p_duplicate_flag)
2728 OR ( ( Recinfo.duplicate_flag IS NULL )
2729 AND ( p_duplicate_flag IS NULL )))
2730 AND ( ( Recinfo.current_usage = p_current_usage)
2731 OR ( ( Recinfo.current_usage IS NULL )
2732 AND ( p_current_usage IS NULL )))
2733 AND ( ( Recinfo.notes = p_notes)
2734 OR ( ( Recinfo.notes IS NULL )
2735 AND ( p_notes IS NULL )))
2736 AND ( ( Recinfo.sales_agent_email_address = p_sales_agent_email_address)
2737 OR ( ( Recinfo.sales_agent_email_address IS NULL )
2738 AND ( p_sales_agent_email_address IS NULL )))
2739 AND ( ( Recinfo.vehicle_response_code = p_vehicle_response_code)
2740 OR ( ( Recinfo.vehicle_response_code IS NULL )
2741 AND ( p_vehicle_response_code IS NULL )))
2742
2743
2744
2745 AND ( ( Recinfo.custom_column1 = p_custom_column1)
2746 OR ( ( Recinfo.custom_column1 IS NULL )
2750 AND ( p_custom_column2 IS NULL )))
2747 AND ( p_custom_column1 IS NULL )))
2748 AND ( ( Recinfo.custom_column2 = p_custom_column2)
2749 OR ( ( Recinfo.custom_column2 IS NULL )
2751 AND ( ( Recinfo.custom_column3 = p_custom_column3)
2752 OR ( ( Recinfo.custom_column3 IS NULL )
2753 AND ( p_custom_column3 IS NULL )))
2754 AND ( ( Recinfo.custom_column4 = p_custom_column4)
2755 OR ( ( Recinfo.custom_column4 IS NULL )
2756 AND ( p_custom_column4 IS NULL )))
2757 AND ( ( Recinfo.custom_column5 = p_custom_column5)
2758 OR ( ( Recinfo.custom_column5 IS NULL )
2759 AND ( p_custom_column5 IS NULL )))
2760 AND ( ( Recinfo.custom_column6 = p_custom_column6)
2761 OR ( ( Recinfo.custom_column6 IS NULL )
2762 AND ( p_custom_column6 IS NULL )))
2763 AND ( ( Recinfo.custom_column7 = p_custom_column7)
2764 OR ( ( Recinfo.custom_column7 IS NULL )
2765 AND ( p_custom_column7 IS NULL )))
2766 AND ( ( Recinfo.custom_column8 = p_custom_column8)
2767 OR ( ( Recinfo.custom_column8 IS NULL )
2768 AND ( p_custom_column8 IS NULL )))
2769 AND ( ( Recinfo.custom_column9 = p_custom_column9)
2770 OR ( ( Recinfo.custom_column9 IS NULL )
2771 AND ( p_custom_column9 IS NULL )))
2772 AND ( ( Recinfo.custom_column10 = p_custom_column10)
2773 OR ( ( Recinfo.custom_column10 IS NULL )
2774 AND ( p_custom_column10 IS NULL )))
2775 AND ( ( Recinfo.custom_column11 = p_custom_column11)
2776 OR ( ( Recinfo.custom_column11 IS NULL )
2777 AND ( p_custom_column11 IS NULL )))
2778 AND ( ( Recinfo.custom_column12 = p_custom_column12)
2779 OR ( ( Recinfo.custom_column12 IS NULL )
2780 AND ( p_custom_column12 IS NULL )))
2781 AND ( ( Recinfo.custom_column13 = p_custom_column13)
2782 OR ( ( Recinfo.custom_column13 IS NULL )
2783 AND ( p_custom_column13 IS NULL )))
2784 AND ( ( Recinfo.custom_column14 = p_custom_column14)
2785 OR ( ( Recinfo.custom_column14 IS NULL )
2786 AND ( p_custom_column14 IS NULL )))
2787 AND ( ( Recinfo.custom_column15 = p_custom_column15)
2788 OR ( ( Recinfo.custom_column15 IS NULL )
2789 AND ( p_custom_column15 IS NULL )))
2790 AND ( ( Recinfo.custom_column16 = p_custom_column16)
2791 OR ( ( Recinfo.custom_column16 IS NULL )
2792 AND ( p_custom_column16 IS NULL )))
2793 AND ( ( Recinfo.custom_column17 = p_custom_column17)
2794 OR ( ( Recinfo.custom_column17 IS NULL )
2795 AND ( p_custom_column17 IS NULL )))
2796 AND ( ( Recinfo.custom_column18 = p_custom_column18)
2797 OR ( ( Recinfo.custom_column18 IS NULL )
2798 AND ( p_custom_column18 IS NULL )))
2799 AND ( ( Recinfo.custom_column19 = p_custom_column19)
2800 OR ( ( Recinfo.custom_column19 IS NULL )
2801 AND ( p_custom_column19 IS NULL )))
2802 AND ( ( Recinfo.custom_column20 = p_custom_column20)
2803 OR ( ( Recinfo.custom_column20 IS NULL )
2804 AND ( p_custom_column20 IS NULL )))
2805 AND ( ( Recinfo.custom_column21 = p_custom_column21)
2806 OR ( ( Recinfo.custom_column21 IS NULL )
2807 AND ( p_custom_column21 IS NULL )))
2808 AND ( ( Recinfo.custom_column22 = p_custom_column22)
2809 OR ( ( Recinfo.custom_column22 IS NULL )
2810 AND ( p_custom_column22 IS NULL )))
2811 AND ( ( Recinfo.custom_column23 = p_custom_column23)
2812 OR ( ( Recinfo.custom_column23 IS NULL )
2816 AND ( p_custom_column24 IS NULL )))
2813 AND ( p_custom_column23 IS NULL )))
2814 AND ( ( Recinfo.custom_column24 = p_custom_column24)
2815 OR ( ( Recinfo.custom_column24 IS NULL )
2817 AND ( ( Recinfo.custom_column25 = p_custom_column25)
2818 OR ( ( Recinfo.custom_column25 IS NULL )
2819 AND ( p_custom_column25 IS NULL )))
2820
2821
2822
2823 ) THEN
2824 RETURN;
2825 ELSE
2826 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
2827 APP_EXCEPTION.RAISE_EXCEPTION;
2828 END IF;
2829 END Lock_Row;
2830
2831 END AMS_IMP_SOURCE_LINES_PKG;