eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.AMS_LIST_HEADERS_VL_PKG

Source


1 package body AMS_LIST_HEADERS_VL_PKG as
2 /* $Header: amstlhvb.pls 120.3 2005/09/15 04:18:37 rmbhanda ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in OUT NOCOPY VARCHAR2,
5   X_LIST_HEADER_ID in NUMBER,
6   X_PURPOSE_CODE in VARCHAR2,
7   X_NO_OF_ROWS_FATIGUED in NUMBER,
8   X_NO_OF_ROWS_SUPPRESSED in NUMBER,
9   X_QUERY_TEMPLATE_ID in NUMBER,
10   X_MIGRATION_DATE in DATE,
11   X_TCA_FAILED_RECORDS in NUMBER,
12   X_USER_STATUS_ID in NUMBER,
13   X_QUANTUM in NUMBER,
14   X_RELEASE_CONTROL_ALG_ID in NUMBER,
15   X_DIALING_METHOD in VARCHAR2,
16   X_CALLING_CALENDAR_ID in NUMBER,
17   X_RELEASE_STRATEGY in VARCHAR2,
18   X_CUSTOM_SETUP_ID in NUMBER,
19   X_COUNTRY in NUMBER,
20   X_CALLBACK_PRIORITY_FLAG in VARCHAR2,
21   X_CALL_CENTER_READY_FLAG in VARCHAR2,
22   X_PURGE_FLAG in VARCHAR2,
23   X_QUOTA in NUMBER,
24   X_QUOTA_RESET in NUMBER,
25   X_RECYCLING_ALG_ID in NUMBER,
26   X_PUBLIC_FLAG in VARCHAR2,
27   X_LIST_CATEGORY in VARCHAR2,
28   X_NO_OF_ROWS_MANUALLY_ENTERED in NUMBER,
29   X_NO_OF_ROWS_DO_NOT_CALL in NUMBER,
30   X_NO_OF_ROWS_DO_NOT_MAIL in NUMBER,
31   X_NO_OF_ROWS_RANDOM in NUMBER,
32   X_MAIN_GEN_START_TIME in DATE,
33   X_MAIN_GEN_END_TIME in DATE,
34   X_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
35   X_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
36   X_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
37   X_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
38   X_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
39   X_RESULT_TEXT in VARCHAR2,
40   X_KEYWORDS in VARCHAR2,
41   X_DESCRIPTION in VARCHAR2,
42   X_LIST_PRIORITY in NUMBER,
43   X_ASSIGN_PERSON_ID in NUMBER,
44   X_LIST_SOURCE in VARCHAR2,
45   X_LIST_SOURCE_TYPE in VARCHAR2,
46   X_LIST_ONLINE_FLAG in VARCHAR2,
47   X_RANDOM_LIST_ID in NUMBER,
48   X_ENABLED_FLAG in VARCHAR2,
49   X_ASSIGNED_TO in NUMBER,
50   X_QUERY_ID in NUMBER,
51   X_OWNER_PERSON_ID in NUMBER,
52   X_ARCHIVED_BY in NUMBER,
53   X_ARCHIVED_DATE in DATE,
54   X_ATTRIBUTE_CATEGORY in VARCHAR2,
55   X_ATTRIBUTE1 in VARCHAR2,
56   X_ATTRIBUTE2 in VARCHAR2,
57   X_ATTRIBUTE3 in VARCHAR2,
58   X_ATTRIBUTE4 in VARCHAR2,
59   X_ATTRIBUTE5 in VARCHAR2,
60   X_ATTRIBUTE6 in VARCHAR2,
61   X_ATTRIBUTE7 in VARCHAR2,
62   X_ATTRIBUTE8 in VARCHAR2,
63   X_ATTRIBUTE9 in VARCHAR2,
64   X_ATTRIBUTE10 in VARCHAR2,
65   X_ATTRIBUTE11 in VARCHAR2,
66   X_ATTRIBUTE12 in VARCHAR2,
67   X_ATTRIBUTE13 in VARCHAR2,
68   X_ATTRIBUTE14 in VARCHAR2,
69   X_ATTRIBUTE15 in VARCHAR2,
70   X_TIMEZONE_ID in NUMBER,
71   X_USER_ENTERED_START_TIME in DATE,
72   X_OBJECT_VERSION_NUMBER in NUMBER,
73   X_REQUEST_ID in NUMBER,
74   X_VIEW_APPLICATION_ID in NUMBER,
75   X_LIST_USED_BY_ID in NUMBER,
76   X_ARC_LIST_USED_BY in VARCHAR2,
77   X_LIST_TYPE in VARCHAR2,
78   X_STATUS_CODE in VARCHAR2,
79   X_STATUS_DATE in DATE,
80   X_GENERATION_TYPE in VARCHAR2,
81   X_REPEAT_EXCLUDE_TYPE in VARCHAR2,
82   X_ROW_SELECTION_TYPE in VARCHAR2,
83   X_OWNER_USER_ID in NUMBER,
84   X_ACCESS_LEVEL in VARCHAR2,
85   X_ENABLE_LOG_FLAG in VARCHAR2,
86   X_ENABLE_WORD_REPLACEMENT_FLAG in VARCHAR2,
87   X_ENABLE_PARALLEL_DML_FLAG in VARCHAR2,
88   X_DEDUPE_DURING_GENERATION_FLA in VARCHAR2,
89   X_GENERATE_CONTROL_GROUP_FLAG in VARCHAR2,
90   X_LAST_GENERATION_SUCCESS_FLAG in VARCHAR2,
91   X_FORECASTED_START_DATE in DATE,
92   X_FORECASTED_END_DATE in DATE,
93   X_ACTUAL_END_DATE in DATE,
94   X_SENT_OUT_DATE in DATE,
95   X_DEDUPE_START_DATE in DATE,
96   X_LAST_DEDUPE_DATE in DATE,
97   X_LAST_DEDUPED_BY_USER_ID in NUMBER,
98   X_WORKFLOW_ITEM_KEY in NUMBER,
99   X_NO_OF_ROWS_DUPLICATES in NUMBER,
100   X_NO_OF_ROWS_MIN_REQUESTED in NUMBER,
101   X_NO_OF_ROWS_MAX_REQUESTED in NUMBER,
102   X_NO_OF_ROWS_IN_LIST in NUMBER,
103   X_NO_OF_ROWS_IN_CTRL_GROUP in NUMBER,
104   X_NO_OF_ROWS_ACTIVE in NUMBER,
105   X_NO_OF_ROWS_INACTIVE in NUMBER,
106   X_APPLY_TRAFFIC_COP in VARCHAR2,
107   X_LIST_NAME in VARCHAR2,
108   X_CREATION_DATE in DATE,
109   X_CREATED_BY in NUMBER,
110   X_LAST_UPDATE_DATE in DATE,
111   X_LAST_UPDATED_BY in NUMBER,
112   X_LAST_UPDATE_LOGIN in NUMBER,
113   X_PROGRAM_ID NUMBER,
114   X_PROGRAM_APPLICATION_ID NUMBER,
115   X_PROGRAM_UPDATE_DATE date,
116   X_ORG_ID NUMBER,
117   X_NO_OF_ROWS_PREV_CONTACTED NUMBER,
118   X_PARENT_LIST_HEADER_ID NUMBER,
119   X_SPLIT_TYPE VARCHAR,
120   X_SPLIT_VALUE NUMBER,
121    X_CTRL_CONF_LEVEL NUMBER,
122         X_CTRL_REQ_RESP_RATE NUMBER,
123         X_CTRL_LIMIT_OF_ERROR NUMBER,
124         X_STATUS_CODE_OLD VARCHAR2,
125         X_CTRL_CONC_JOB_ID NUMBER,
126         X_CTRL_STATUS_CODE VARCHAR2,
127         X_CTRL_GEN_MODE VARCHAR2,
128 	X_APPLY_SUPPRESSION_FLAG VARCHAR2 --rmbhanda bug#4609206
129 
130 
131 ) is
132   cursor C is select ROWID from AMS_LIST_HEADERS_ALL
133     where LIST_HEADER_ID = X_LIST_HEADER_ID
134     ;
135 begin
136   insert into AMS_LIST_HEADERS_ALL (
137     PURPOSE_CODE,
138     NO_OF_ROWS_FATIGUED,
139     NO_OF_ROWS_SUPPRESSED,
140     QUERY_TEMPLATE_ID,
141     MIGRATION_DATE,
142     TCA_FAILED_RECORDS,
143     USER_STATUS_ID,
144     QUANTUM,
145     RELEASE_CONTROL_ALG_ID,
146     DIALING_METHOD,
147     CALLING_CALENDAR_ID,
148     RELEASE_STRATEGY,
149     CUSTOM_SETUP_ID,
150     COUNTRY,
151     CALLBACK_PRIORITY_FLAG,
152     CALL_CENTER_READY_FLAG,
153     PURGE_FLAG,
154     QUOTA,
155     QUOTA_RESET,
156     RECYCLING_ALG_ID,
157     PUBLIC_FLAG,
158     LIST_CATEGORY,
159     NO_OF_ROWS_MANUALLY_ENTERED,
160     NO_OF_ROWS_DO_NOT_CALL,
161     NO_OF_ROWS_DO_NOT_MAIL,
162     NO_OF_ROWS_RANDOM,
163     MAIN_GEN_START_TIME,
164     MAIN_GEN_END_TIME,
165     MAIN_RANDOM_NTH_ROW_SELECTION,
166     MAIN_RANDOM_PCT_ROW_SELECTION,
167     CTRL_RANDOM_NTH_ROW_SELECTION,
168     CTRL_RANDOM_PCT_ROW_SELECTION,
169     REPEAT_SOURCE_LIST_HEADER_ID,
170     RESULT_TEXT,
171     KEYWORDS,
172     DESCRIPTION,
173     LIST_PRIORITY,
174     ASSIGN_PERSON_ID,
175     LIST_SOURCE,
176     LIST_SOURCE_TYPE,
177     LIST_ONLINE_FLAG,
178     RANDOM_LIST_ID,
179     ENABLED_FLAG,
180     ASSIGNED_TO,
181     QUERY_ID,
182     OWNER_PERSON_ID,
183     ARCHIVED_BY,
184     ARCHIVED_DATE,
185     ATTRIBUTE_CATEGORY,
186     ATTRIBUTE1,
187     ATTRIBUTE2,
188     ATTRIBUTE3,
189     ATTRIBUTE4,
190     ATTRIBUTE5,
191     ATTRIBUTE6,
192     ATTRIBUTE7,
193     ATTRIBUTE8,
194     ATTRIBUTE9,
195     ATTRIBUTE10,
196     ATTRIBUTE11,
197     ATTRIBUTE12,
198     ATTRIBUTE13,
199     ATTRIBUTE14,
200     ATTRIBUTE15,
201     TIMEZONE_ID,
202     USER_ENTERED_START_TIME,
203     LIST_HEADER_ID,
204     OBJECT_VERSION_NUMBER,
205     REQUEST_ID,
206     VIEW_APPLICATION_ID,
207     LIST_USED_BY_ID,
208     ARC_LIST_USED_BY,
209     LIST_TYPE,
210     STATUS_CODE,
211     STATUS_DATE,
212     GENERATION_TYPE,
213     REPEAT_EXCLUDE_TYPE,
214     ROW_SELECTION_TYPE,
215     OWNER_USER_ID,
216     ACCESS_LEVEL,
217     ENABLE_LOG_FLAG,
218     ENABLE_WORD_REPLACEMENT_FLAG,
219     ENABLE_PARALLEL_DML_FLAG,
220     DEDUPE_DURING_GENERATION_FLAG,
221     GENERATE_CONTROL_GROUP_FLAG,
222     LAST_GENERATION_SUCCESS_FLAG,
223     FORECASTED_START_DATE,
224     FORECASTED_END_DATE,
225     ACTUAL_END_DATE,
226     SENT_OUT_DATE,
227     DEDUPE_START_DATE,
228     LAST_DEDUPE_DATE,
229     LAST_DEDUPED_BY_USER_ID,
230     WORKFLOW_ITEM_KEY,
231     NO_OF_ROWS_DUPLICATES,
232     NO_OF_ROWS_MIN_REQUESTED,
233     NO_OF_ROWS_MAX_REQUESTED,
234     NO_OF_ROWS_IN_LIST,
235     NO_OF_ROWS_IN_CTRL_GROUP,
236     NO_OF_ROWS_ACTIVE,
237     NO_OF_ROWS_INACTIVE,
238     APPLY_TRAFFIC_COP,
239     CREATION_DATE,
240     CREATED_BY,
241     LAST_UPDATE_DATE,
242     LAST_UPDATED_BY,
243     LAST_UPDATE_LOGIN,
244     PROGRAM_ID ,
245     PROGRAM_APPLICATION_ID ,
246     PROGRAM_UPDATE_DATE,
247     ORG_ID,
248     NO_OF_ROWS_PREV_CONTACTED,
249     PARENT_LIST_HEADER_ID,
250     SPLIT_TYPE,
251     SPLIT_VALUE,
252          CTRL_CONF_LEVEL,
253         CTRL_REQ_RESP_RATE,
254         CTRL_LIMIT_OF_ERROR,
255         STATUS_CODE_OLD,
256         CTRL_CONC_JOB_ID,
257         CTRL_STATUS_CODE,
258         CTRL_GEN_MODE,
259 	APPLY_SUPPRESSION_FLAG  --rmbhanda bug#4609206
260 
261   ) values (
262     X_PURPOSE_CODE,
263     X_NO_OF_ROWS_FATIGUED,
264     X_NO_OF_ROWS_SUPPRESSED,
265     X_QUERY_TEMPLATE_ID,
266     X_MIGRATION_DATE,
267     X_TCA_FAILED_RECORDS,
268     X_USER_STATUS_ID,
269     X_QUANTUM,
270     X_RELEASE_CONTROL_ALG_ID,
271     X_DIALING_METHOD,
272     X_CALLING_CALENDAR_ID,
273     X_RELEASE_STRATEGY,
274     X_CUSTOM_SETUP_ID,
275     X_COUNTRY,
276     X_CALLBACK_PRIORITY_FLAG,
277     X_CALL_CENTER_READY_FLAG,
278     X_PURGE_FLAG,
279     X_QUOTA,
280     X_QUOTA_RESET,
281     X_RECYCLING_ALG_ID,
282     X_PUBLIC_FLAG,
283     X_LIST_CATEGORY,
284     X_NO_OF_ROWS_MANUALLY_ENTERED,
285     X_NO_OF_ROWS_DO_NOT_CALL,
286     X_NO_OF_ROWS_DO_NOT_MAIL,
287     X_NO_OF_ROWS_RANDOM,
288     X_MAIN_GEN_START_TIME,
289     X_MAIN_GEN_END_TIME,
290     X_MAIN_RANDOM_NTH_ROW_SELECTIO,
291     X_MAIN_RANDOM_PCT_ROW_SELECTIO,
292     X_CTRL_RANDOM_NTH_ROW_SELECTIO,
293     X_CTRL_RANDOM_PCT_ROW_SELECTIO,
294     X_REPEAT_SOURCE_LIST_HEADER_ID,
295     X_RESULT_TEXT,
296     X_KEYWORDS,
297     X_DESCRIPTION,
298     X_LIST_PRIORITY,
299     X_ASSIGN_PERSON_ID,
300     X_LIST_SOURCE,
301     X_LIST_SOURCE_TYPE,
302     X_LIST_ONLINE_FLAG,
303     X_RANDOM_LIST_ID,
304     X_ENABLED_FLAG,
305     X_ASSIGNED_TO,
306     X_QUERY_ID,
307     X_OWNER_PERSON_ID,
308     X_ARCHIVED_BY,
309     X_ARCHIVED_DATE,
310     X_ATTRIBUTE_CATEGORY,
311     X_ATTRIBUTE1,
312     X_ATTRIBUTE2,
313     X_ATTRIBUTE3,
314     X_ATTRIBUTE4,
315     X_ATTRIBUTE5,
316     X_ATTRIBUTE6,
317     X_ATTRIBUTE7,
318     X_ATTRIBUTE8,
319     X_ATTRIBUTE9,
320     X_ATTRIBUTE10,
321     X_ATTRIBUTE11,
322     X_ATTRIBUTE12,
323     X_ATTRIBUTE13,
324     X_ATTRIBUTE14,
325     X_ATTRIBUTE15,
326     X_TIMEZONE_ID,
327     X_USER_ENTERED_START_TIME,
328     X_LIST_HEADER_ID,
329     X_OBJECT_VERSION_NUMBER,
330     X_REQUEST_ID,
331     X_VIEW_APPLICATION_ID,
332     X_LIST_USED_BY_ID,
333     X_ARC_LIST_USED_BY,
334     X_LIST_TYPE,
335     X_STATUS_CODE,
336     X_STATUS_DATE,
337     X_GENERATION_TYPE,
338     X_REPEAT_EXCLUDE_TYPE,
339     X_ROW_SELECTION_TYPE,
340     X_OWNER_USER_ID,
341     X_ACCESS_LEVEL,
342     X_ENABLE_LOG_FLAG,
343     X_ENABLE_WORD_REPLACEMENT_FLAG,
344     X_ENABLE_PARALLEL_DML_FLAG,
345     X_DEDUPE_DURING_GENERATION_FLA,
346     X_GENERATE_CONTROL_GROUP_FLAG,
347     X_LAST_GENERATION_SUCCESS_FLAG,
348     X_FORECASTED_START_DATE,
349     X_FORECASTED_END_DATE,
350     X_ACTUAL_END_DATE,
351     X_SENT_OUT_DATE,
352     X_DEDUPE_START_DATE,
353     X_LAST_DEDUPE_DATE,
354     X_LAST_DEDUPED_BY_USER_ID,
355     X_WORKFLOW_ITEM_KEY,
356     X_NO_OF_ROWS_DUPLICATES,
357     X_NO_OF_ROWS_MIN_REQUESTED,
358     X_NO_OF_ROWS_MAX_REQUESTED,
359     X_NO_OF_ROWS_IN_LIST,
360     X_NO_OF_ROWS_IN_CTRL_GROUP,
361     X_NO_OF_ROWS_ACTIVE,
362     X_NO_OF_ROWS_INACTIVE,
363     X_APPLY_TRAFFIC_COP,
364     X_CREATION_DATE,
365     X_CREATED_BY,
366     X_LAST_UPDATE_DATE,
367     X_LAST_UPDATED_BY,
368     X_LAST_UPDATE_LOGIN,
369     X_PROGRAM_ID ,
370     X_PROGRAM_APPLICATION_ID ,
371     X_PROGRAM_UPDATE_DATE,
372     X_ORG_ID,
373     X_NO_OF_ROWS_PREV_CONTACTED,
374     X_PARENT_LIST_HEADER_ID,
375     X_SPLIT_TYPE,
376     X_SPLIT_VALUE,
377          X_CTRL_CONF_LEVEL,
378         X_CTRL_REQ_RESP_RATE,
379         X_CTRL_LIMIT_OF_ERROR,
380         X_STATUS_CODE_OLD,
381         X_CTRL_CONC_JOB_ID,
382         X_CTRL_STATUS_CODE,
383         X_CTRL_GEN_MODE,
384 	X_APPLY_SUPPRESSION_FLAG  --rmbhanda bug#4609206
385   );
386 
387   insert into AMS_LIST_HEADERS_ALL_TL (
388     LIST_HEADER_ID,
389     LAST_UPDATE_DATE,
390     LAST_UPDATE_BY,
391     CREATION_DATE,
392     CREATED_BY,
393     LAST_UPDATE_LOGIN,
394     LIST_NAME,
395     DESCRIPTION,
396     LANGUAGE,
397     SOURCE_LANG
398   ) select
399     X_LIST_HEADER_ID,
400     X_LAST_UPDATE_DATE,
401     X_LAST_UPDATED_BY,
402     X_CREATION_DATE,
403     X_CREATED_BY,
404     X_LAST_UPDATE_LOGIN,
405     X_LIST_NAME,
406     X_DESCRIPTION,
407     L.LANGUAGE_CODE,
408     userenv('LANG')
409   from FND_LANGUAGES L
410   where L.INSTALLED_FLAG in ('I', 'B')
411   and not exists
412     (select NULL
413     from AMS_LIST_HEADERS_ALL_TL T
414     where T.LIST_HEADER_ID = X_LIST_HEADER_ID
415     and T.LANGUAGE = L.LANGUAGE_CODE);
416 
417   open c;
418   fetch c into X_ROWID;
419   if (c%notfound) then
420     close c;
421     raise no_data_found;
422   end if;
423   close c;
424 
425 end INSERT_ROW;
426 
427 procedure LOCK_ROW (
428   X_LIST_HEADER_ID in NUMBER,
429   X_PURPOSE_CODE in VARCHAR2,
430   X_NO_OF_ROWS_FATIGUED in NUMBER,
431   X_NO_OF_ROWS_SUPPRESSED in NUMBER,
432   X_QUERY_TEMPLATE_ID in NUMBER,
433   X_MIGRATION_DATE in DATE,
434   X_TCA_FAILED_RECORDS in NUMBER,
435   X_USER_STATUS_ID in NUMBER,
436   X_QUANTUM in NUMBER,
437   X_RELEASE_CONTROL_ALG_ID in NUMBER,
438   X_DIALING_METHOD in VARCHAR2,
439   X_CALLING_CALENDAR_ID in NUMBER,
440   X_RELEASE_STRATEGY in VARCHAR2,
441   X_CUSTOM_SETUP_ID in NUMBER,
442   X_COUNTRY in NUMBER,
443   X_CALLBACK_PRIORITY_FLAG in VARCHAR2,
444   X_CALL_CENTER_READY_FLAG in VARCHAR2,
445   X_PURGE_FLAG in VARCHAR2,
446   X_QUOTA in NUMBER,
447   X_QUOTA_RESET in NUMBER,
448   X_RECYCLING_ALG_ID in NUMBER,
449   X_PUBLIC_FLAG in VARCHAR2,
450   X_LIST_CATEGORY in VARCHAR2,
451   X_NO_OF_ROWS_MANUALLY_ENTERED in NUMBER,
452   X_NO_OF_ROWS_DO_NOT_CALL in NUMBER,
453   X_NO_OF_ROWS_DO_NOT_MAIL in NUMBER,
454   X_NO_OF_ROWS_RANDOM in NUMBER,
455   X_MAIN_GEN_START_TIME in DATE,
456   X_MAIN_GEN_END_TIME in DATE,
457   X_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
458   X_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
459   X_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
460   X_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
461   X_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
462   X_RESULT_TEXT in VARCHAR2,
463   X_KEYWORDS in VARCHAR2,
464   X_DESCRIPTION in VARCHAR2,
465   X_LIST_PRIORITY in NUMBER,
466   X_ASSIGN_PERSON_ID in NUMBER,
467   X_LIST_SOURCE in VARCHAR2,
468   X_LIST_SOURCE_TYPE in VARCHAR2,
469   X_LIST_ONLINE_FLAG in VARCHAR2,
470   X_RANDOM_LIST_ID in NUMBER,
471   X_ENABLED_FLAG in VARCHAR2,
472   X_ASSIGNED_TO in NUMBER,
473   X_QUERY_ID in NUMBER,
474   X_OWNER_PERSON_ID in NUMBER,
475   X_ARCHIVED_BY in NUMBER,
476   X_ARCHIVED_DATE in DATE,
477   X_ATTRIBUTE_CATEGORY in VARCHAR2,
478   X_ATTRIBUTE1 in VARCHAR2,
479   X_ATTRIBUTE2 in VARCHAR2,
480   X_ATTRIBUTE3 in VARCHAR2,
481   X_ATTRIBUTE4 in VARCHAR2,
482   X_ATTRIBUTE5 in VARCHAR2,
483   X_ATTRIBUTE6 in VARCHAR2,
484   X_ATTRIBUTE7 in VARCHAR2,
485   X_ATTRIBUTE8 in VARCHAR2,
486   X_ATTRIBUTE9 in VARCHAR2,
487   X_ATTRIBUTE10 in VARCHAR2,
488   X_ATTRIBUTE11 in VARCHAR2,
489   X_ATTRIBUTE12 in VARCHAR2,
490   X_ATTRIBUTE13 in VARCHAR2,
494   X_USER_ENTERED_START_TIME in DATE,
491   X_ATTRIBUTE14 in VARCHAR2,
492   X_ATTRIBUTE15 in VARCHAR2,
493   X_TIMEZONE_ID in NUMBER,
495   X_OBJECT_VERSION_NUMBER in NUMBER,
496   X_REQUEST_ID in NUMBER,
497   X_VIEW_APPLICATION_ID in NUMBER,
498   X_LIST_USED_BY_ID in NUMBER,
499   X_ARC_LIST_USED_BY in VARCHAR2,
500   X_LIST_TYPE in VARCHAR2,
501   X_STATUS_CODE in VARCHAR2,
502   X_STATUS_DATE in DATE,
503   X_GENERATION_TYPE in VARCHAR2,
504   X_REPEAT_EXCLUDE_TYPE in VARCHAR2,
505   X_ROW_SELECTION_TYPE in VARCHAR2,
506   X_OWNER_USER_ID in NUMBER,
507   X_ACCESS_LEVEL in VARCHAR2,
508   X_ENABLE_LOG_FLAG in VARCHAR2,
509   X_ENABLE_WORD_REPLACEMENT_FLAG in VARCHAR2,
510   X_ENABLE_PARALLEL_DML_FLAG in VARCHAR2,
511   X_DEDUPE_DURING_GENERATION_FLA in VARCHAR2,
512   X_GENERATE_CONTROL_GROUP_FLAG in VARCHAR2,
513   X_LAST_GENERATION_SUCCESS_FLAG in VARCHAR2,
514   X_FORECASTED_START_DATE in DATE,
515   X_FORECASTED_END_DATE in DATE,
516   X_ACTUAL_END_DATE in DATE,
517   X_SENT_OUT_DATE in DATE,
518   X_DEDUPE_START_DATE in DATE,
519   X_LAST_DEDUPE_DATE in DATE,
520   X_LAST_DEDUPED_BY_USER_ID in NUMBER,
521   X_WORKFLOW_ITEM_KEY in NUMBER,
522   X_NO_OF_ROWS_DUPLICATES in NUMBER,
523   X_NO_OF_ROWS_MIN_REQUESTED in NUMBER,
524   X_NO_OF_ROWS_MAX_REQUESTED in NUMBER,
525   X_NO_OF_ROWS_IN_LIST in NUMBER,
526   X_NO_OF_ROWS_IN_CTRL_GROUP in NUMBER,
527   X_NO_OF_ROWS_ACTIVE in NUMBER,
528   X_NO_OF_ROWS_INACTIVE in NUMBER,
529   X_APPLY_TRAFFIC_COP in VARCHAR2,
530   X_LIST_NAME in VARCHAR2,
531   X_PROGRAM_ID NUMBER,
532   X_PROGRAM_APPLICATION_ID NUMBER,
533   X_PROGRAM_UPDATE_DATE DATE,
534   X_ORG_ID NUMBER,
535   X_NO_OF_ROWS_PREV_CONTACTED NUMBER,
536   X_PARENT_LIST_HEADER_ID NUMBER,
537   X_SPLIT_TYPE VARCHAR,
538   X_SPLIT_VALUE NUMBER,
539   X_CTRL_CONF_LEVEL NUMBER,
540         X_CTRL_REQ_RESP_RATE NUMBER,
541         X_CTRL_LIMIT_OF_ERROR NUMBER,
542         X_STATUS_CODE_OLD VARCHAR2,
543         X_CTRL_CONC_JOB_ID NUMBER,
544         X_CTRL_STATUS_CODE VARCHAR2,
545         X_CTRL_GEN_MODE VARCHAR2,
546 	X_APPLY_SUPPRESSION_FLAG VARCHAR2 --rmbhanda bug#4609206
547 
548 
549 ) is
550   cursor c is select
551       PURPOSE_CODE,
552       NO_OF_ROWS_FATIGUED,
553       NO_OF_ROWS_SUPPRESSED,
554       QUERY_TEMPLATE_ID,
555       MIGRATION_DATE,
556       TCA_FAILED_RECORDS,
557       USER_STATUS_ID,
558       QUANTUM,
559       RELEASE_CONTROL_ALG_ID,
560       DIALING_METHOD,
561       CALLING_CALENDAR_ID,
562       RELEASE_STRATEGY,
563       CUSTOM_SETUP_ID,
564       COUNTRY,
565       CALLBACK_PRIORITY_FLAG,
566       CALL_CENTER_READY_FLAG,
567       PURGE_FLAG,
568       QUOTA,
569       QUOTA_RESET,
570       RECYCLING_ALG_ID,
571       PUBLIC_FLAG,
572       LIST_CATEGORY,
573       NO_OF_ROWS_MANUALLY_ENTERED,
574       NO_OF_ROWS_DO_NOT_CALL,
575       NO_OF_ROWS_DO_NOT_MAIL,
576       NO_OF_ROWS_RANDOM,
577       MAIN_GEN_START_TIME,
578       MAIN_GEN_END_TIME,
579       MAIN_RANDOM_NTH_ROW_SELECTION,
580       MAIN_RANDOM_PCT_ROW_SELECTION,
581       CTRL_RANDOM_NTH_ROW_SELECTION,
582       CTRL_RANDOM_PCT_ROW_SELECTION,
583       REPEAT_SOURCE_LIST_HEADER_ID,
584       RESULT_TEXT,
585       KEYWORDS,
586       DESCRIPTION,
587       LIST_PRIORITY,
588       ASSIGN_PERSON_ID,
589       LIST_SOURCE,
590       LIST_SOURCE_TYPE,
591       LIST_ONLINE_FLAG,
592       RANDOM_LIST_ID,
593       ENABLED_FLAG,
594       ASSIGNED_TO,
595       QUERY_ID,
596       OWNER_PERSON_ID,
597       ARCHIVED_BY,
598       ARCHIVED_DATE,
599       ATTRIBUTE_CATEGORY,
600       ATTRIBUTE1,
601       ATTRIBUTE2,
602       ATTRIBUTE3,
603       ATTRIBUTE4,
604       ATTRIBUTE5,
605       ATTRIBUTE6,
606       ATTRIBUTE7,
607       ATTRIBUTE8,
608       ATTRIBUTE9,
609       ATTRIBUTE10,
610       ATTRIBUTE11,
611       ATTRIBUTE12,
612       ATTRIBUTE13,
613       ATTRIBUTE14,
614       ATTRIBUTE15,
615       TIMEZONE_ID,
616       USER_ENTERED_START_TIME,
617       OBJECT_VERSION_NUMBER,
618       REQUEST_ID,
619       VIEW_APPLICATION_ID,
620       LIST_USED_BY_ID,
621       ARC_LIST_USED_BY,
622       LIST_TYPE,
623       STATUS_CODE,
624       STATUS_DATE,
625       GENERATION_TYPE,
626       REPEAT_EXCLUDE_TYPE,
627       ROW_SELECTION_TYPE,
628       OWNER_USER_ID,
629       ACCESS_LEVEL,
630       ENABLE_LOG_FLAG,
631       ENABLE_WORD_REPLACEMENT_FLAG,
632       ENABLE_PARALLEL_DML_FLAG,
633       DEDUPE_DURING_GENERATION_FLAG,
634       GENERATE_CONTROL_GROUP_FLAG,
635       LAST_GENERATION_SUCCESS_FLAG,
636       FORECASTED_START_DATE,
637       FORECASTED_END_DATE,
638       ACTUAL_END_DATE,
639       SENT_OUT_DATE,
640       DEDUPE_START_DATE,
641       LAST_DEDUPE_DATE,
642       LAST_DEDUPED_BY_USER_ID,
643       WORKFLOW_ITEM_KEY,
644       NO_OF_ROWS_DUPLICATES,
645       NO_OF_ROWS_MIN_REQUESTED,
646       NO_OF_ROWS_MAX_REQUESTED,
647       NO_OF_ROWS_IN_LIST,
648       NO_OF_ROWS_IN_CTRL_GROUP,
649       NO_OF_ROWS_ACTIVE,
650       NO_OF_ROWS_INACTIVE,
651       APPLY_TRAFFIC_COP,
652       NO_OF_ROWS_PREV_CONTACTED,
653       PARENT_LIST_HEADER_ID,
654       SPLIT_TYPE,
655       SPLIT_VALUE,
659         STATUS_CODE_OLD,
656       CTRL_CONF_LEVEL,
657         CTRL_REQ_RESP_RATE,
658         CTRL_LIMIT_OF_ERROR,
660         CTRL_CONC_JOB_ID,
661         CTRL_STATUS_CODE,
662         CTRL_GEN_MODE,
663 	APPLY_SUPPRESSION_FLAG  --rmbhanda bug#4609206
664 
665 
666 
667     from AMS_LIST_HEADERS_ALL
668     where LIST_HEADER_ID = X_LIST_HEADER_ID
669     for update of LIST_HEADER_ID nowait;
670   recinfo c%rowtype;
671 
672   cursor c1 is select
673       LIST_NAME,
674       decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
675     from AMS_LIST_HEADERS_ALL_TL
676     where LIST_HEADER_ID = X_LIST_HEADER_ID
677     and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
678     for update of LIST_HEADER_ID nowait;
679 begin
680   open c;
681   fetch c into recinfo;
682   if (c%notfound) then
683     close c;
684     fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
685     app_exception.raise_exception;
686   end if;
687   close c;
688   if ( /*  ((recinfo.PURPOSE_CODE = X_PURPOSE_CODE)
689            OR ((recinfo.PURPOSE_CODE is null) AND (X_PURPOSE_CODE is null)))
690       AND ((recinfo.NO_OF_ROWS_FATIGUED = X_NO_OF_ROWS_FATIGUED)
691            OR ((recinfo.NO_OF_ROWS_FATIGUED is null) AND (X_NO_OF_ROWS_FATIGUED is null)))
692       AND ((recinfo.NO_OF_ROWS_SUPPRESSED = X_NO_OF_ROWS_SUPPRESSED)
693            OR ((recinfo.NO_OF_ROWS_SUPPRESSED is null) AND (X_NO_OF_ROWS_SUPPRESSED is null)))
694       AND ((recinfo.QUERY_TEMPLATE_ID = X_QUERY_TEMPLATE_ID)
695            OR ((recinfo.QUERY_TEMPLATE_ID is null) AND (X_QUERY_TEMPLATE_ID is null)))
696       AND ((recinfo.MIGRATION_DATE = X_MIGRATION_DATE)
697            OR ((recinfo.MIGRATION_DATE is null) AND (X_MIGRATION_DATE is null)))
698       AND ((recinfo.TCA_FAILED_RECORDS = X_TCA_FAILED_RECORDS)
699            OR ((recinfo.TCA_FAILED_RECORDS is null) AND (X_TCA_FAILED_RECORDS is null)))
700       AND ((recinfo.USER_STATUS_ID = X_USER_STATUS_ID)
701            OR ((recinfo.USER_STATUS_ID is null) AND (X_USER_STATUS_ID is null)))
702       AND ((recinfo.QUANTUM = X_QUANTUM)
703            OR ((recinfo.QUANTUM is null) AND (X_QUANTUM is null)))
704       AND ((recinfo.RELEASE_CONTROL_ALG_ID = X_RELEASE_CONTROL_ALG_ID)
705            OR ((recinfo.RELEASE_CONTROL_ALG_ID is null) AND (X_RELEASE_CONTROL_ALG_ID is null)))
706       AND ((recinfo.DIALING_METHOD = X_DIALING_METHOD)
707            OR ((recinfo.DIALING_METHOD is null) AND (X_DIALING_METHOD is null)))
708       AND ((recinfo.CALLING_CALENDAR_ID = X_CALLING_CALENDAR_ID)
709            OR ((recinfo.CALLING_CALENDAR_ID is null) AND (X_CALLING_CALENDAR_ID is null)))
710       AND ((recinfo.RELEASE_STRATEGY = X_RELEASE_STRATEGY)
711            OR ((recinfo.RELEASE_STRATEGY is null) AND (X_RELEASE_STRATEGY is null)))
712       AND ((recinfo.CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID)
713            OR ((recinfo.CUSTOM_SETUP_ID is null) AND (X_CUSTOM_SETUP_ID is null)))
714       AND ((recinfo.COUNTRY = X_COUNTRY)
715            OR ((recinfo.COUNTRY is null) AND (X_COUNTRY is null)))
716       AND ((recinfo.CALLBACK_PRIORITY_FLAG = X_CALLBACK_PRIORITY_FLAG)
717            OR ((recinfo.CALLBACK_PRIORITY_FLAG is null) AND (X_CALLBACK_PRIORITY_FLAG is null)))
718       AND ((recinfo.CALL_CENTER_READY_FLAG = X_CALL_CENTER_READY_FLAG)
719            OR ((recinfo.CALL_CENTER_READY_FLAG is null) AND (X_CALL_CENTER_READY_FLAG is null)))
720       AND ((recinfo.PURGE_FLAG = X_PURGE_FLAG)
721            OR ((recinfo.PURGE_FLAG is null) AND (X_PURGE_FLAG is null)))
722       AND ((recinfo.QUOTA = X_QUOTA)
723            OR ((recinfo.QUOTA is null) AND (X_QUOTA is null)))
724       AND ((recinfo.QUOTA_RESET = X_QUOTA_RESET)
725            OR ((recinfo.QUOTA_RESET is null) AND (X_QUOTA_RESET is null)))
726       AND ((recinfo.RECYCLING_ALG_ID = X_RECYCLING_ALG_ID)
727            OR ((recinfo.RECYCLING_ALG_ID is null) AND (X_RECYCLING_ALG_ID is null)))
728       AND ((recinfo.PUBLIC_FLAG = X_PUBLIC_FLAG)
729            OR ((recinfo.PUBLIC_FLAG is null) AND (X_PUBLIC_FLAG is null)))
730       AND ((recinfo.LIST_CATEGORY = X_LIST_CATEGORY)
731            OR ((recinfo.LIST_CATEGORY is null) AND (X_LIST_CATEGORY is null)))
732       AND ((recinfo.NO_OF_ROWS_MANUALLY_ENTERED = X_NO_OF_ROWS_MANUALLY_ENTERED)
733            OR ((recinfo.NO_OF_ROWS_MANUALLY_ENTERED is null) AND (X_NO_OF_ROWS_MANUALLY_ENTERED is null)))
734       AND ((recinfo.NO_OF_ROWS_DO_NOT_CALL = X_NO_OF_ROWS_DO_NOT_CALL)
735            OR ((recinfo.NO_OF_ROWS_DO_NOT_CALL is null) AND (X_NO_OF_ROWS_DO_NOT_CALL is null)))
736       AND ((recinfo.NO_OF_ROWS_DO_NOT_MAIL = X_NO_OF_ROWS_DO_NOT_MAIL)
737            OR ((recinfo.NO_OF_ROWS_DO_NOT_MAIL is null) AND (X_NO_OF_ROWS_DO_NOT_MAIL is null)))
738       AND ((recinfo.NO_OF_ROWS_RANDOM = X_NO_OF_ROWS_RANDOM)
739            OR ((recinfo.NO_OF_ROWS_RANDOM is null) AND (X_NO_OF_ROWS_RANDOM is null)))
740       AND ((recinfo.MAIN_GEN_START_TIME = X_MAIN_GEN_START_TIME)
741            OR ((recinfo.MAIN_GEN_START_TIME is null) AND (X_MAIN_GEN_START_TIME is null)))
742       AND ((recinfo.MAIN_GEN_END_TIME = X_MAIN_GEN_END_TIME)
743            OR ((recinfo.MAIN_GEN_END_TIME is null) AND (X_MAIN_GEN_END_TIME is null)))
744       AND ((recinfo.MAIN_RANDOM_NTH_ROW_SELECTION = X_MAIN_RANDOM_NTH_ROW_SELECTIO)
745            OR ((recinfo.MAIN_RANDOM_NTH_ROW_SELECTION is null) AND (X_MAIN_RANDOM_NTH_ROW_SELECTIO is null)))
746       AND ((recinfo.MAIN_RANDOM_PCT_ROW_SELECTION = X_MAIN_RANDOM_PCT_ROW_SELECTIO)
747            OR ((recinfo.MAIN_RANDOM_PCT_ROW_SELECTION is null) AND (X_MAIN_RANDOM_PCT_ROW_SELECTIO is null)))
748       AND ((recinfo.CTRL_RANDOM_NTH_ROW_SELECTION = X_CTRL_RANDOM_NTH_ROW_SELECTIO)
752       AND ((recinfo.REPEAT_SOURCE_LIST_HEADER_ID = X_REPEAT_SOURCE_LIST_HEADER_ID)
749            OR ((recinfo.CTRL_RANDOM_NTH_ROW_SELECTION is null) AND (X_CTRL_RANDOM_NTH_ROW_SELECTIO is null)))
750       AND ((recinfo.CTRL_RANDOM_PCT_ROW_SELECTION = X_CTRL_RANDOM_PCT_ROW_SELECTIO)
751            OR ((recinfo.CTRL_RANDOM_PCT_ROW_SELECTION is null) AND (X_CTRL_RANDOM_PCT_ROW_SELECTIO is null)))
753            OR ((recinfo.REPEAT_SOURCE_LIST_HEADER_ID is null) AND (X_REPEAT_SOURCE_LIST_HEADER_ID is null)))
754       AND ((recinfo.RESULT_TEXT = X_RESULT_TEXT)
755            OR ((recinfo.RESULT_TEXT is null) AND (X_RESULT_TEXT is null)))
756       AND ((recinfo.KEYWORDS = X_KEYWORDS)
757            OR ((recinfo.KEYWORDS is null) AND (X_KEYWORDS is null)))
758       AND ((recinfo.DESCRIPTION = X_DESCRIPTION)
759            OR ((recinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
760       AND ((recinfo.LIST_PRIORITY = X_LIST_PRIORITY)
761            OR ((recinfo.LIST_PRIORITY is null) AND (X_LIST_PRIORITY is null)))
762       AND ((recinfo.ASSIGN_PERSON_ID = X_ASSIGN_PERSON_ID)
763            OR ((recinfo.ASSIGN_PERSON_ID is null) AND (X_ASSIGN_PERSON_ID is null)))
764       AND ((recinfo.LIST_SOURCE = X_LIST_SOURCE)
765            OR ((recinfo.LIST_SOURCE is null) AND (X_LIST_SOURCE is null)))
766       AND ((recinfo.LIST_SOURCE_TYPE = X_LIST_SOURCE_TYPE)
767            OR ((recinfo.LIST_SOURCE_TYPE is null) AND (X_LIST_SOURCE_TYPE is null)))
768       AND ((recinfo.LIST_ONLINE_FLAG = X_LIST_ONLINE_FLAG)
769            OR ((recinfo.LIST_ONLINE_FLAG is null) AND (X_LIST_ONLINE_FLAG is null)))
770       AND ((recinfo.RANDOM_LIST_ID = X_RANDOM_LIST_ID)
771            OR ((recinfo.RANDOM_LIST_ID is null) AND (X_RANDOM_LIST_ID is null)))
772       AND ((recinfo.ENABLED_FLAG = X_ENABLED_FLAG)
773            OR ((recinfo.ENABLED_FLAG is null) AND (X_ENABLED_FLAG is null)))
774       AND ((recinfo.ASSIGNED_TO = X_ASSIGNED_TO)
775            OR ((recinfo.ASSIGNED_TO is null) AND (X_ASSIGNED_TO is null)))
776       AND ((recinfo.QUERY_ID = X_QUERY_ID)
777            OR ((recinfo.QUERY_ID is null) AND (X_QUERY_ID is null)))
778       AND ((recinfo.OWNER_PERSON_ID = X_OWNER_PERSON_ID)
779            OR ((recinfo.OWNER_PERSON_ID is null) AND (X_OWNER_PERSON_ID is null)))
780       AND ((recinfo.ARCHIVED_BY = X_ARCHIVED_BY)
781            OR ((recinfo.ARCHIVED_BY is null) AND (X_ARCHIVED_BY is null)))
782       AND ((recinfo.ARCHIVED_DATE = X_ARCHIVED_DATE)
783            OR ((recinfo.ARCHIVED_DATE is null) AND (X_ARCHIVED_DATE is null)))
784       AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
785            OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
786       AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
787            OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
788       AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
789            OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
790       AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
791            OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
792       AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
793            OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
794       AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
795            OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
796       AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
797            OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
798       AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
799            OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
800       AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
801            OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
802       AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
803            OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
804       AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
805            OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
806       AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
807            OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
808       AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
809            OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
810       AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
811            OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
812       AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
813            OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
814       AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
815            OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
816       AND ((recinfo.TIMEZONE_ID = X_TIMEZONE_ID)
817            OR ((recinfo.TIMEZONE_ID is null) AND (X_TIMEZONE_ID is null)))
818       AND ((recinfo.USER_ENTERED_START_TIME = X_USER_ENTERED_START_TIME)
819            OR ((recinfo.USER_ENTERED_START_TIME is null) AND (X_USER_ENTERED_START_TIME is null)))
820       AND ((recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
821            OR ((recinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
822       AND ((recinfo.REQUEST_ID = X_REQUEST_ID)
823            OR ((recinfo.REQUEST_ID is null) AND (X_REQUEST_ID is null)))
824       AND ((recinfo.VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID)
825            OR ((recinfo.VIEW_APPLICATION_ID is null) AND (X_VIEW_APPLICATION_ID is null)))
826       AND (recinfo.LIST_USED_BY_ID = X_LIST_USED_BY_ID)
827       AND (recinfo.ARC_LIST_USED_BY = X_ARC_LIST_USED_BY)
828       AND (recinfo.LIST_TYPE = X_LIST_TYPE)
829       AND (recinfo.STATUS_CODE = X_STATUS_CODE)
833            OR ((recinfo.REPEAT_EXCLUDE_TYPE is null) AND (X_REPEAT_EXCLUDE_TYPE is null)))
830       AND (recinfo.STATUS_DATE = X_STATUS_DATE)
831       AND (recinfo.GENERATION_TYPE = X_GENERATION_TYPE)
832       AND ((recinfo.REPEAT_EXCLUDE_TYPE = X_REPEAT_EXCLUDE_TYPE)
834       AND (recinfo.ROW_SELECTION_TYPE = X_ROW_SELECTION_TYPE)
835       AND (recinfo.OWNER_USER_ID = X_OWNER_USER_ID)
836       AND (recinfo.ACCESS_LEVEL = X_ACCESS_LEVEL)
837       AND (recinfo.ENABLE_LOG_FLAG = X_ENABLE_LOG_FLAG)
838       AND (recinfo.ENABLE_WORD_REPLACEMENT_FLAG = X_ENABLE_WORD_REPLACEMENT_FLAG)
839       AND (recinfo.ENABLE_PARALLEL_DML_FLAG = X_ENABLE_PARALLEL_DML_FLAG)
840       AND (recinfo.DEDUPE_DURING_GENERATION_FLAG = X_DEDUPE_DURING_GENERATION_FLA)
841       AND (recinfo.GENERATE_CONTROL_GROUP_FLAG = X_GENERATE_CONTROL_GROUP_FLAG)
842       AND (recinfo.LAST_GENERATION_SUCCESS_FLAG = X_LAST_GENERATION_SUCCESS_FLAG)
843       AND (recinfo.FORECASTED_START_DATE = X_FORECASTED_START_DATE)
844       AND ((recinfo.FORECASTED_END_DATE = X_FORECASTED_END_DATE)
845            OR ((recinfo.FORECASTED_END_DATE is null) AND (X_FORECASTED_END_DATE is null)))
846       AND ((recinfo.ACTUAL_END_DATE = X_ACTUAL_END_DATE)
847            OR ((recinfo.ACTUAL_END_DATE is null) AND (X_ACTUAL_END_DATE is null)))
848       AND ((recinfo.SENT_OUT_DATE = X_SENT_OUT_DATE)
849            OR ((recinfo.SENT_OUT_DATE is null) AND (X_SENT_OUT_DATE is null)))
850       AND ((recinfo.DEDUPE_START_DATE = X_DEDUPE_START_DATE)
851            OR ((recinfo.DEDUPE_START_DATE is null) AND (X_DEDUPE_START_DATE is null)))
852       AND ((recinfo.LAST_DEDUPE_DATE = X_LAST_DEDUPE_DATE)
853            OR ((recinfo.LAST_DEDUPE_DATE is null) AND (X_LAST_DEDUPE_DATE is null)))
854       AND ((recinfo.LAST_DEDUPED_BY_USER_ID = X_LAST_DEDUPED_BY_USER_ID)
855            OR ((recinfo.LAST_DEDUPED_BY_USER_ID is null) AND (X_LAST_DEDUPED_BY_USER_ID is null)))
856       AND ((recinfo.WORKFLOW_ITEM_KEY = X_WORKFLOW_ITEM_KEY)
857            OR ((recinfo.WORKFLOW_ITEM_KEY is null) AND (X_WORKFLOW_ITEM_KEY is null)))
858       AND ((recinfo.NO_OF_ROWS_DUPLICATES = X_NO_OF_ROWS_DUPLICATES)
859            OR ((recinfo.NO_OF_ROWS_DUPLICATES is null) AND (X_NO_OF_ROWS_DUPLICATES is null)))
860       AND ((recinfo.NO_OF_ROWS_MIN_REQUESTED = X_NO_OF_ROWS_MIN_REQUESTED)
861            OR ((recinfo.NO_OF_ROWS_MIN_REQUESTED is null) AND (X_NO_OF_ROWS_MIN_REQUESTED is null)))
862       AND ((recinfo.NO_OF_ROWS_MAX_REQUESTED = X_NO_OF_ROWS_MAX_REQUESTED)
863            OR ((recinfo.NO_OF_ROWS_MAX_REQUESTED is null) AND (X_NO_OF_ROWS_MAX_REQUESTED is null)))
864       AND ((recinfo.NO_OF_ROWS_IN_LIST = X_NO_OF_ROWS_IN_LIST)
865            OR ((recinfo.NO_OF_ROWS_IN_LIST is null) AND (X_NO_OF_ROWS_IN_LIST is null)))
866       AND ((recinfo.NO_OF_ROWS_IN_CTRL_GROUP = X_NO_OF_ROWS_IN_CTRL_GROUP)
867            OR ((recinfo.NO_OF_ROWS_IN_CTRL_GROUP is null) AND (X_NO_OF_ROWS_IN_CTRL_GROUP is null)))
868       AND ((recinfo.NO_OF_ROWS_ACTIVE = X_NO_OF_ROWS_ACTIVE)
869            OR ((recinfo.NO_OF_ROWS_ACTIVE is null) AND (X_NO_OF_ROWS_ACTIVE is null)))
870       AND ((recinfo.NO_OF_ROWS_INACTIVE = X_NO_OF_ROWS_INACTIVE)
871            OR ((recinfo.NO_OF_ROWS_INACTIVE is null) AND (X_NO_OF_ROWS_INACTIVE is null)))
872       AND ((recinfo.APPLY_TRAFFIC_COP = X_APPLY_TRAFFIC_COP)
873            OR ((recinfo.APPLY_TRAFFIC_COP is null) AND (X_APPLY_TRAFFIC_COP is null)))*/
874              ((recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
875            OR ((recinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
876     --rmbhanda   bug#4609206 start
877      AND ((recinfo.APPLY_SUPPRESSION_FLAG = X_APPLY_SUPPRESSION_FLAG)
878            OR ((recinfo.APPLY_SUPPRESSION_FLAG is null) AND (X_APPLY_SUPPRESSION_FLAG is null)))
879     --rmbhanda   bug#4609206   end
880   ) then
881     null;
882   else
883     fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
884     app_exception.raise_exception;
885   end if;
886 
887 /*  for tlinfo in c1 loop
888     if (tlinfo.BASELANG = 'Y') then
889       if (    (tlinfo.LIST_NAME = X_LIST_NAME)
890       ) then
891         null;
892       else
893         fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
894         app_exception.raise_exception;
895       end if;
896     end if;
897   end loop;*/
898   return;
899 end LOCK_ROW;
900 
901 procedure UPDATE_ROW (
902   X_LIST_HEADER_ID in NUMBER,
903   X_PURPOSE_CODE in VARCHAR2,
904   X_NO_OF_ROWS_FATIGUED in NUMBER,
905   X_NO_OF_ROWS_SUPPRESSED in NUMBER,
906   X_QUERY_TEMPLATE_ID in NUMBER,
907   X_MIGRATION_DATE in DATE,
908   X_TCA_FAILED_RECORDS in NUMBER,
909   X_USER_STATUS_ID in NUMBER,
910   X_QUANTUM in NUMBER,
911   X_RELEASE_CONTROL_ALG_ID in NUMBER,
912   X_DIALING_METHOD in VARCHAR2,
913   X_CALLING_CALENDAR_ID in NUMBER,
914   X_RELEASE_STRATEGY in VARCHAR2,
915   X_CUSTOM_SETUP_ID in NUMBER,
916   X_COUNTRY in NUMBER,
917   X_CALLBACK_PRIORITY_FLAG in VARCHAR2,
918   X_CALL_CENTER_READY_FLAG in VARCHAR2,
919   X_PURGE_FLAG in VARCHAR2,
920   X_QUOTA in NUMBER,
921   X_QUOTA_RESET in NUMBER,
922   X_RECYCLING_ALG_ID in NUMBER,
923   X_PUBLIC_FLAG in VARCHAR2,
924   X_LIST_CATEGORY in VARCHAR2,
925   X_NO_OF_ROWS_MANUALLY_ENTERED in NUMBER,
926   X_NO_OF_ROWS_DO_NOT_CALL in NUMBER,
927   X_NO_OF_ROWS_DO_NOT_MAIL in NUMBER,
928   X_NO_OF_ROWS_RANDOM in NUMBER,
932   X_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
929   X_MAIN_GEN_START_TIME in DATE,
930   X_MAIN_GEN_END_TIME in DATE,
931   X_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
933   X_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
934   X_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
935   X_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
936   X_RESULT_TEXT in VARCHAR2,
937   X_KEYWORDS in VARCHAR2,
938   X_DESCRIPTION in VARCHAR2,
939   X_LIST_PRIORITY in NUMBER,
940   X_ASSIGN_PERSON_ID in NUMBER,
941   X_LIST_SOURCE in VARCHAR2,
942   X_LIST_SOURCE_TYPE in VARCHAR2,
943   X_LIST_ONLINE_FLAG in VARCHAR2,
944   X_RANDOM_LIST_ID in NUMBER,
945   X_ENABLED_FLAG in VARCHAR2,
946   X_ASSIGNED_TO in NUMBER,
947   X_QUERY_ID in NUMBER,
948   X_OWNER_PERSON_ID in NUMBER,
949   X_ARCHIVED_BY in NUMBER,
950   X_ARCHIVED_DATE in DATE,
951   X_ATTRIBUTE_CATEGORY in VARCHAR2,
952   X_ATTRIBUTE1 in VARCHAR2,
953   X_ATTRIBUTE2 in VARCHAR2,
954   X_ATTRIBUTE3 in VARCHAR2,
955   X_ATTRIBUTE4 in VARCHAR2,
956   X_ATTRIBUTE5 in VARCHAR2,
957   X_ATTRIBUTE6 in VARCHAR2,
958   X_ATTRIBUTE7 in VARCHAR2,
959   X_ATTRIBUTE8 in VARCHAR2,
960   X_ATTRIBUTE9 in VARCHAR2,
961   X_ATTRIBUTE10 in VARCHAR2,
962   X_ATTRIBUTE11 in VARCHAR2,
963   X_ATTRIBUTE12 in VARCHAR2,
964   X_ATTRIBUTE13 in VARCHAR2,
965   X_ATTRIBUTE14 in VARCHAR2,
966   X_ATTRIBUTE15 in VARCHAR2,
967   X_TIMEZONE_ID in NUMBER,
968   X_USER_ENTERED_START_TIME in DATE,
969   X_OBJECT_VERSION_NUMBER in NUMBER,
970   X_REQUEST_ID in NUMBER,
971   X_VIEW_APPLICATION_ID in NUMBER,
972   X_LIST_USED_BY_ID in NUMBER,
973   X_ARC_LIST_USED_BY in VARCHAR2,
974   X_LIST_TYPE in VARCHAR2,
975   X_STATUS_CODE in VARCHAR2,
976   X_STATUS_DATE in DATE,
977   X_GENERATION_TYPE in VARCHAR2,
978   X_REPEAT_EXCLUDE_TYPE in VARCHAR2,
979   X_ROW_SELECTION_TYPE in VARCHAR2,
980   X_OWNER_USER_ID in NUMBER,
981   X_ACCESS_LEVEL in VARCHAR2,
982   X_ENABLE_LOG_FLAG in VARCHAR2,
983   X_ENABLE_WORD_REPLACEMENT_FLAG in VARCHAR2,
984   X_ENABLE_PARALLEL_DML_FLAG in VARCHAR2,
985   X_DEDUPE_DURING_GENERATION_FLA in VARCHAR2,
986   X_GENERATE_CONTROL_GROUP_FLAG in VARCHAR2,
987   X_LAST_GENERATION_SUCCESS_FLAG in VARCHAR2,
988   X_FORECASTED_START_DATE in DATE,
989   X_FORECASTED_END_DATE in DATE,
990   X_ACTUAL_END_DATE in DATE,
991   X_SENT_OUT_DATE in DATE,
992   X_DEDUPE_START_DATE in DATE,
993   X_LAST_DEDUPE_DATE in DATE,
994   X_LAST_DEDUPED_BY_USER_ID in NUMBER,
995   X_WORKFLOW_ITEM_KEY in NUMBER,
996   X_NO_OF_ROWS_DUPLICATES in NUMBER,
997   X_NO_OF_ROWS_MIN_REQUESTED in NUMBER,
998   X_NO_OF_ROWS_MAX_REQUESTED in NUMBER,
999   X_NO_OF_ROWS_IN_LIST in NUMBER,
1000   X_NO_OF_ROWS_IN_CTRL_GROUP in NUMBER,
1001   X_NO_OF_ROWS_ACTIVE in NUMBER,
1002   X_NO_OF_ROWS_INACTIVE in NUMBER,
1003   X_APPLY_TRAFFIC_COP in VARCHAR2,
1004   X_LIST_NAME in VARCHAR2,
1005   X_LAST_UPDATE_DATE in DATE,
1006   X_LAST_UPDATED_BY in NUMBER,
1007   X_LAST_UPDATE_LOGIN in NUMBER,
1008   X_PROGRAM_ID NUMBER,
1009   X_PROGRAM_APPLICATION_ID NUMBER,
1010   X_PROGRAM_UPDATE_DATE DATE,
1011   X_ORG_ID NUMBER,
1012   X_NO_OF_ROWS_PREV_CONTACTED NUMBER,
1013   X_PARENT_LIST_HEADER_ID NUMBER,
1014   X_SPLIT_TYPE VARCHAR,
1015   X_SPLIT_VALUE NUMBER,
1016     X_CTRL_CONF_LEVEL NUMBER,
1017         X_CTRL_REQ_RESP_RATE NUMBER,
1018         X_CTRL_LIMIT_OF_ERROR NUMBER,
1019         X_STATUS_CODE_OLD VARCHAR2,
1020         X_CTRL_CONC_JOB_ID NUMBER,
1021         X_CTRL_STATUS_CODE VARCHAR2,
1022         X_CTRL_GEN_MODE VARCHAR2,
1023 	X_APPLY_SUPPRESSION_FLAG VARCHAR2 --rmbhanda bug#4609206
1024 
1025 
1026 ) is
1027 begin
1028   update AMS_LIST_HEADERS_ALL set
1029     PURPOSE_CODE = X_PURPOSE_CODE,
1030     NO_OF_ROWS_FATIGUED = X_NO_OF_ROWS_FATIGUED,
1031     NO_OF_ROWS_SUPPRESSED = X_NO_OF_ROWS_SUPPRESSED,
1032     QUERY_TEMPLATE_ID = X_QUERY_TEMPLATE_ID,
1033     MIGRATION_DATE = X_MIGRATION_DATE,
1034     TCA_FAILED_RECORDS = X_TCA_FAILED_RECORDS,
1035     USER_STATUS_ID = X_USER_STATUS_ID,
1036     QUANTUM = X_QUANTUM,
1037     RELEASE_CONTROL_ALG_ID = X_RELEASE_CONTROL_ALG_ID,
1038     DIALING_METHOD = X_DIALING_METHOD,
1039     CALLING_CALENDAR_ID = X_CALLING_CALENDAR_ID,
1040     RELEASE_STRATEGY = X_RELEASE_STRATEGY,
1041     CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID,
1042     COUNTRY = X_COUNTRY,
1043     CALLBACK_PRIORITY_FLAG = X_CALLBACK_PRIORITY_FLAG,
1044     CALL_CENTER_READY_FLAG = X_CALL_CENTER_READY_FLAG,
1045     PURGE_FLAG = X_PURGE_FLAG,
1046     QUOTA = X_QUOTA,
1047     QUOTA_RESET = X_QUOTA_RESET,
1048     RECYCLING_ALG_ID = X_RECYCLING_ALG_ID,
1049     PUBLIC_FLAG = X_PUBLIC_FLAG,
1050     LIST_CATEGORY = X_LIST_CATEGORY,
1051     NO_OF_ROWS_MANUALLY_ENTERED = X_NO_OF_ROWS_MANUALLY_ENTERED,
1052     NO_OF_ROWS_DO_NOT_CALL = X_NO_OF_ROWS_DO_NOT_CALL,
1053     NO_OF_ROWS_DO_NOT_MAIL = X_NO_OF_ROWS_DO_NOT_MAIL,
1054     NO_OF_ROWS_RANDOM = X_NO_OF_ROWS_RANDOM,
1055     MAIN_GEN_START_TIME = X_MAIN_GEN_START_TIME,
1056     MAIN_GEN_END_TIME = X_MAIN_GEN_END_TIME,
1057     MAIN_RANDOM_NTH_ROW_SELECTION = X_MAIN_RANDOM_NTH_ROW_SELECTIO,
1058     MAIN_RANDOM_PCT_ROW_SELECTION = X_MAIN_RANDOM_PCT_ROW_SELECTIO,
1059     CTRL_RANDOM_NTH_ROW_SELECTION = X_CTRL_RANDOM_NTH_ROW_SELECTIO,
1060     CTRL_RANDOM_PCT_ROW_SELECTION = X_CTRL_RANDOM_PCT_ROW_SELECTIO,
1061     REPEAT_SOURCE_LIST_HEADER_ID = X_REPEAT_SOURCE_LIST_HEADER_ID,
1062     RESULT_TEXT = X_RESULT_TEXT,
1063     KEYWORDS = X_KEYWORDS,
1064     DESCRIPTION = X_DESCRIPTION,
1065     LIST_PRIORITY = X_LIST_PRIORITY,
1066     ASSIGN_PERSON_ID = X_ASSIGN_PERSON_ID,
1067     LIST_SOURCE = X_LIST_SOURCE,
1068     LIST_SOURCE_TYPE = X_LIST_SOURCE_TYPE,
1069     LIST_ONLINE_FLAG = X_LIST_ONLINE_FLAG,
1070     RANDOM_LIST_ID = X_RANDOM_LIST_ID,
1071     ENABLED_FLAG = X_ENABLED_FLAG,
1072     ASSIGNED_TO = X_ASSIGNED_TO,
1073     QUERY_ID = X_QUERY_ID,
1074     OWNER_PERSON_ID = X_OWNER_PERSON_ID,
1075     ARCHIVED_BY = X_ARCHIVED_BY,
1076     ARCHIVED_DATE = X_ARCHIVED_DATE,
1077     ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
1078     ATTRIBUTE1 = X_ATTRIBUTE1,
1079     ATTRIBUTE2 = X_ATTRIBUTE2,
1080     ATTRIBUTE3 = X_ATTRIBUTE3,
1081     ATTRIBUTE4 = X_ATTRIBUTE4,
1082     ATTRIBUTE5 = X_ATTRIBUTE5,
1083     ATTRIBUTE6 = X_ATTRIBUTE6,
1084     ATTRIBUTE7 = X_ATTRIBUTE7,
1085     ATTRIBUTE8 = X_ATTRIBUTE8,
1086     ATTRIBUTE9 = X_ATTRIBUTE9,
1087     ATTRIBUTE10 = X_ATTRIBUTE10,
1088     ATTRIBUTE11 = X_ATTRIBUTE11,
1089     ATTRIBUTE12 = X_ATTRIBUTE12,
1090     ATTRIBUTE13 = X_ATTRIBUTE13,
1091     ATTRIBUTE14 = X_ATTRIBUTE14,
1092     ATTRIBUTE15 = X_ATTRIBUTE15,
1093     TIMEZONE_ID = X_TIMEZONE_ID,
1094     USER_ENTERED_START_TIME = X_USER_ENTERED_START_TIME,
1095     OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
1096     REQUEST_ID = X_REQUEST_ID,
1097     VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID,
1098     LIST_USED_BY_ID = X_LIST_USED_BY_ID,
1099     ARC_LIST_USED_BY = X_ARC_LIST_USED_BY,
1100     LIST_TYPE = X_LIST_TYPE,
1101     STATUS_CODE = X_STATUS_CODE,
1102     STATUS_DATE = X_STATUS_DATE,
1103     GENERATION_TYPE = X_GENERATION_TYPE,
1104     REPEAT_EXCLUDE_TYPE = X_REPEAT_EXCLUDE_TYPE,
1105     ROW_SELECTION_TYPE = X_ROW_SELECTION_TYPE,
1106     OWNER_USER_ID = X_OWNER_USER_ID,
1107     ACCESS_LEVEL = X_ACCESS_LEVEL,
1108     ENABLE_LOG_FLAG = X_ENABLE_LOG_FLAG,
1109     ENABLE_WORD_REPLACEMENT_FLAG = X_ENABLE_WORD_REPLACEMENT_FLAG,
1110     ENABLE_PARALLEL_DML_FLAG = X_ENABLE_PARALLEL_DML_FLAG,
1111     DEDUPE_DURING_GENERATION_FLAG = X_DEDUPE_DURING_GENERATION_FLA,
1112     GENERATE_CONTROL_GROUP_FLAG = X_GENERATE_CONTROL_GROUP_FLAG,
1113     LAST_GENERATION_SUCCESS_FLAG = X_LAST_GENERATION_SUCCESS_FLAG,
1114     FORECASTED_START_DATE = X_FORECASTED_START_DATE,
1115     FORECASTED_END_DATE = X_FORECASTED_END_DATE,
1116     ACTUAL_END_DATE = X_ACTUAL_END_DATE,
1117     SENT_OUT_DATE = X_SENT_OUT_DATE,
1118     DEDUPE_START_DATE = X_DEDUPE_START_DATE,
1119     LAST_DEDUPE_DATE = X_LAST_DEDUPE_DATE,
1120     LAST_DEDUPED_BY_USER_ID = X_LAST_DEDUPED_BY_USER_ID,
1121     WORKFLOW_ITEM_KEY = X_WORKFLOW_ITEM_KEY,
1122     NO_OF_ROWS_DUPLICATES = X_NO_OF_ROWS_DUPLICATES,
1123     NO_OF_ROWS_MIN_REQUESTED = X_NO_OF_ROWS_MIN_REQUESTED,
1124     NO_OF_ROWS_MAX_REQUESTED = X_NO_OF_ROWS_MAX_REQUESTED,
1125     NO_OF_ROWS_IN_LIST = X_NO_OF_ROWS_IN_LIST,
1126     NO_OF_ROWS_IN_CTRL_GROUP = X_NO_OF_ROWS_IN_CTRL_GROUP,
1127     NO_OF_ROWS_ACTIVE = X_NO_OF_ROWS_ACTIVE,
1128     NO_OF_ROWS_INACTIVE = X_NO_OF_ROWS_INACTIVE,
1129     APPLY_TRAFFIC_COP = X_APPLY_TRAFFIC_COP,
1130     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1131     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1132     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1133     PROGRAM_ID = X_PROGRAM_ID ,
1134     PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID ,
1135     PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE ,
1136     ORG_ID = X_ORG_ID,
1137     NO_OF_ROWS_PREV_CONTACTED = X_NO_OF_ROWS_PREV_CONTACTED,
1138     PARENT_LIST_HEADER_ID = X_PARENT_LIST_HEADER_ID,
1139     SPLIT_TYPE = X_SPLIT_TYPE,
1140     SPLIT_VALUE = X_SPLIT_VALUE,
1141      CTRL_CONF_LEVEL = X_CTRL_CONF_LEVEL,
1142         CTRL_REQ_RESP_RATE = X_CTRL_REQ_RESP_RATE,
1143         CTRL_LIMIT_OF_ERROR = X_CTRL_LIMIT_OF_ERROR,
1144         STATUS_CODE_OLD = X_STATUS_CODE_OLD,
1145         CTRL_CONC_JOB_ID = X_CTRL_CONC_JOB_ID,
1146         CTRL_STATUS_CODE = X_CTRL_STATUS_CODE,
1147         CTRL_GEN_MODE = X_CTRL_GEN_MODE,
1148 	APPLY_SUPPRESSION_FLAG=X_APPLY_SUPPRESSION_FLAG  --rmbhanda bug#4609206
1149 
1150 
1151   where LIST_HEADER_ID = X_LIST_HEADER_ID;
1152 
1153   if (sql%notfound) then
1154     raise no_data_found;
1155   end if;
1156 
1157   update AMS_LIST_HEADERS_ALL_TL set
1158     LIST_NAME = X_LIST_NAME,
1159     DESCRIPTION = X_DESCRIPTION,
1160     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1161     LAST_UPDATE_BY = X_LAST_UPDATED_BY,
1162     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1163     SOURCE_LANG = userenv('LANG')
1164   where LIST_HEADER_ID = X_LIST_HEADER_ID
1165   and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1166 
1167   if (sql%notfound) then
1168     raise no_data_found;
1172 procedure DELETE_ROW (
1169   end if;
1170 end UPDATE_ROW;
1171 
1173   X_LIST_HEADER_ID in NUMBER
1174 ) is
1175 begin
1176   delete from AMS_LIST_HEADERS_ALL_TL
1177   where LIST_HEADER_ID = X_LIST_HEADER_ID;
1178 
1179   if (sql%notfound) then
1180     raise no_data_found;
1181   end if;
1182 
1183   delete from AMS_LIST_HEADERS_ALL
1184   where LIST_HEADER_ID = X_LIST_HEADER_ID;
1185 
1186   if (sql%notfound) then
1187     raise no_data_found;
1188   end if;
1189 end DELETE_ROW;
1190 
1191 procedure ADD_LANGUAGE
1192 is
1193 begin
1194   delete from AMS_LIST_HEADERS_ALL_TL T
1195   where not exists
1196     (select NULL
1197     from AMS_LIST_HEADERS_ALL B
1198     where B.LIST_HEADER_ID = T.LIST_HEADER_ID
1199     );
1200 
1201   update AMS_LIST_HEADERS_ALL_TL T set (
1202       LIST_NAME
1203     ) = (select
1204       B.LIST_NAME
1205     from AMS_LIST_HEADERS_ALL_TL B
1206     where B.LIST_HEADER_ID = T.LIST_HEADER_ID
1207     and B.LANGUAGE = T.SOURCE_LANG)
1208   where (
1209       T.LIST_HEADER_ID,
1210       T.LANGUAGE
1211   ) in (select
1212       SUBT.LIST_HEADER_ID,
1213       SUBT.LANGUAGE
1214     from AMS_LIST_HEADERS_ALL_TL SUBB, AMS_LIST_HEADERS_ALL_TL SUBT
1215     where SUBB.LIST_HEADER_ID = SUBT.LIST_HEADER_ID
1216     and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1217     and (SUBB.LIST_NAME <> SUBT.LIST_NAME
1218   ));
1219 
1220   insert into AMS_LIST_HEADERS_ALL_TL (
1221     LIST_HEADER_ID,
1222     LAST_UPDATE_DATE,
1223     LAST_UPDATE_BY,
1224     CREATION_DATE,
1225     CREATED_BY,
1226     LAST_UPDATE_LOGIN,
1227     LIST_NAME,
1228     DESCRIPTION,
1229     LANGUAGE,
1230     SOURCE_LANG
1231   ) select
1232     B.LIST_HEADER_ID,
1233     B.LAST_UPDATE_DATE,
1234     B.LAST_UPDATE_BY,
1235     B.CREATION_DATE,
1236     B.CREATED_BY,
1237     B.LAST_UPDATE_LOGIN,
1238     B.LIST_NAME,
1239     B.DESCRIPTION,
1240     L.LANGUAGE_CODE,
1241     B.SOURCE_LANG
1242   from AMS_LIST_HEADERS_ALL_TL B, FND_LANGUAGES L
1243   where L.INSTALLED_FLAG in ('I', 'B')
1244   and B.LANGUAGE = userenv('LANG')
1245   and not exists
1246     (select NULL
1247     from AMS_LIST_HEADERS_ALL_TL T
1248     where T.LIST_HEADER_ID = B.LIST_HEADER_ID
1249     and T.LANGUAGE = L.LANGUAGE_CODE);
1250 end ADD_LANGUAGE;
1251 
1252 end AMS_LIST_HEADERS_VL_PKG;