DBA Data[Home] [Help]

PACKAGE: APPS.AMS_LIST_HEADERS_ALL_PKG

Source


1 package AMS_LIST_HEADERS_ALL_PKG as
2 /* $Header: amstlshs.pls 120.1 2006/06/26 12:19:26 bmuthukr noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in OUT NOCOPY VARCHAR2,
5   X_LIST_HEADER_ID in NUMBER,
6   X_COUNTRY in NUMBER,
7   X_USER_STATUS_ID in NUMBER,
8   X_QUANTUM in NUMBER,
9   X_RELEASE_CONTROL_ALG_ID in NUMBER,
10   X_DIALING_METHOD in VARCHAR2,
11   X_CALLING_CALENDAR_ID in NUMBER,
12   X_RELEASE_STRATEGY in VARCHAR2,
13   X_CALLBACK_PRIORITY_FLAG in VARCHAR2,
14   X_CALL_CENTER_READY_FLAG in VARCHAR2,
15   X_CUSTOM_SETUP_ID in NUMBER,
16   X_OWNER_USER_ID in NUMBER,
17   X_ACCESS_LEVEL in VARCHAR2,
18   X_ENABLE_LOG_FLAG in VARCHAR2,
19   X_ENABLE_WORD_REPLACEMENT_FLAG in VARCHAR2,
20   X_ENABLE_PARALLEL_DML_FLAG in VARCHAR2,
21   X_DEDUPE_DURING_GENERATION_FLA in VARCHAR2,
22   X_GENERATE_CONTROL_GROUP_FLAG in VARCHAR2,
23   X_LAST_GENERATION_SUCCESS_FLAG in VARCHAR2,
24   X_FORECASTED_START_DATE in DATE,
25   X_FORECASTED_END_DATE in DATE,
26   X_ACTUAL_END_DATE in DATE,
27   X_SENT_OUT_DATE in DATE,
28   X_DEDUPE_START_DATE in DATE,
29   X_LAST_DEDUPE_DATE in DATE,
30   X_LAST_DEDUPED_BY_USER_ID in NUMBER,
31   X_WORKFLOW_ITEM_KEY in NUMBER,
32   X_NO_OF_ROWS_DUPLICATES in NUMBER,
33   X_NO_OF_ROWS_MIN_REQUESTED in NUMBER,
34   X_NO_OF_ROWS_MAX_REQUESTED in NUMBER,
35   X_NO_OF_ROWS_IN_LIST in NUMBER,
36   X_NO_OF_ROWS_IN_CTRL_GROUP in NUMBER,
37   X_NO_OF_ROWS_ACTIVE in NUMBER,
38   X_NO_OF_ROWS_INACTIVE in NUMBER,
39   X_NO_OF_ROWS_MANUALLY_ENTERED in NUMBER,
40   X_NO_OF_ROWS_DO_NOT_CALL in NUMBER,
41   X_NO_OF_ROWS_DO_NOT_MAIL in NUMBER,
42   X_NO_OF_ROWS_RANDOM in NUMBER,
43   X_MAIN_GEN_START_TIME in DATE,
44   X_MAIN_GEN_END_TIME in DATE,
45   X_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
46   X_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
47   X_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
48   X_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
49   X_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
50   X_RESULT_TEXT in VARCHAR2,
51   X_KEYWORDS in VARCHAR2,
52   X_LIST_PRIORITY in NUMBER,
53   X_ASSIGN_PERSON_ID in NUMBER,
54   X_LIST_SOURCE in VARCHAR2,
55   X_LIST_SOURCE_TYPE in VARCHAR2,
56   X_LIST_ONLINE_FLAG in VARCHAR2,
57   X_RANDOM_LIST_ID in NUMBER,
58   X_ENABLED_FLAG in VARCHAR2,
59   X_ASSIGNED_TO in NUMBER,
60   X_QUERY_ID in NUMBER,
61   X_OWNER_PERSON_ID in NUMBER,
62   X_ARCHIVED_BY in NUMBER,
63   X_ARCHIVED_DATE in DATE,
64   X_ATTRIBUTE_CATEGORY in VARCHAR2,
65   X_ATTRIBUTE1 in VARCHAR2,
66   X_ATTRIBUTE2 in VARCHAR2,
67   X_ATTRIBUTE3 in VARCHAR2,
68   X_ATTRIBUTE4 in VARCHAR2,
69   X_ATTRIBUTE5 in VARCHAR2,
70   X_ATTRIBUTE6 in VARCHAR2,
71   X_ATTRIBUTE7 in VARCHAR2,
72   X_ATTRIBUTE8 in VARCHAR2,
73   X_ATTRIBUTE9 in VARCHAR2,
74   X_ATTRIBUTE10 in VARCHAR2,
75   X_ATTRIBUTE11 in VARCHAR2,
76   X_ATTRIBUTE12 in VARCHAR2,
77   X_ATTRIBUTE13 in VARCHAR2,
78   X_ATTRIBUTE14 in VARCHAR2,
79   X_ATTRIBUTE15 in VARCHAR2,
80   X_TIMEZONE_ID in NUMBER,
81   X_USER_ENTERED_START_TIME in DATE,
82   X_OBJECT_VERSION_NUMBER in NUMBER,
83   X_REQUEST_ID in NUMBER,
84   X_VIEW_APPLICATION_ID in NUMBER,
85   X_LIST_USED_BY_ID in NUMBER,
86   X_ARC_LIST_USED_BY in VARCHAR2,
87   X_LIST_TYPE in VARCHAR2,
88   X_STATUS_CODE in VARCHAR2,
89   X_STATUS_DATE in DATE,
90   X_GENERATION_TYPE in VARCHAR2,
91   X_REPEAT_EXCLUDE_TYPE in VARCHAR2,
92   X_ROW_SELECTION_TYPE in VARCHAR2,
93   X_LIST_NAME in VARCHAR2,
94   X_DESCRIPTION in VARCHAR2,
95   X_CREATION_DATE in DATE,
96   X_CREATED_BY in NUMBER,
97   X_LAST_UPDATE_DATE in DATE,
98   X_LAST_UPDATED_BY in NUMBER,
99   X_LAST_UPDATE_LOGIN in NUMBER,
100   X_NO_OF_ROWS_PREV_CONTACTED  in NUMBER,
101   X_APPLY_TRAFFIC_COP in VARCHAR2 );
102 procedure LOCK_ROW (
103   X_LIST_HEADER_ID in NUMBER,
104   X_COUNTRY in NUMBER,
105   X_USER_STATUS_ID in NUMBER,
106   X_QUANTUM in NUMBER,
107   X_RELEASE_CONTROL_ALG_ID in NUMBER,
108   X_DIALING_METHOD in VARCHAR2,
109   X_CALLING_CALENDAR_ID in NUMBER,
110   X_RELEASE_STRATEGY in VARCHAR2,
111   X_CALLBACK_PRIORITY_FLAG in VARCHAR2,
112   X_CALL_CENTER_READY_FLAG in VARCHAR2,
113   X_CUSTOM_SETUP_ID in NUMBER,
114   X_OWNER_USER_ID in NUMBER,
115   X_ACCESS_LEVEL in VARCHAR2,
116   X_ENABLE_LOG_FLAG in VARCHAR2,
117   X_ENABLE_WORD_REPLACEMENT_FLAG in VARCHAR2,
118   X_ENABLE_PARALLEL_DML_FLAG in VARCHAR2,
119   X_DEDUPE_DURING_GENERATION_FLA in VARCHAR2,
120   X_GENERATE_CONTROL_GROUP_FLAG in VARCHAR2,
121   X_LAST_GENERATION_SUCCESS_FLAG in VARCHAR2,
122   X_FORECASTED_START_DATE in DATE,
123   X_FORECASTED_END_DATE in DATE,
124   X_ACTUAL_END_DATE in DATE,
125   X_SENT_OUT_DATE in DATE,
126   X_DEDUPE_START_DATE in DATE,
127   X_LAST_DEDUPE_DATE in DATE,
128   X_LAST_DEDUPED_BY_USER_ID in NUMBER,
129   X_WORKFLOW_ITEM_KEY in NUMBER,
130   X_NO_OF_ROWS_DUPLICATES in NUMBER,
131   X_NO_OF_ROWS_MIN_REQUESTED in NUMBER,
132   X_NO_OF_ROWS_MAX_REQUESTED in NUMBER,
133   X_NO_OF_ROWS_IN_LIST in NUMBER,
134   X_NO_OF_ROWS_IN_CTRL_GROUP in NUMBER,
135   X_NO_OF_ROWS_ACTIVE in NUMBER,
136   X_NO_OF_ROWS_INACTIVE in NUMBER,
137   X_NO_OF_ROWS_MANUALLY_ENTERED in NUMBER,
138   X_NO_OF_ROWS_DO_NOT_CALL in NUMBER,
139   X_NO_OF_ROWS_DO_NOT_MAIL in NUMBER,
140   X_NO_OF_ROWS_RANDOM in NUMBER,
141   X_MAIN_GEN_START_TIME in DATE,
142   X_MAIN_GEN_END_TIME in DATE,
143   X_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
144   X_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
145   X_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
146   X_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
147   X_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
148   X_RESULT_TEXT in VARCHAR2,
149   X_KEYWORDS in VARCHAR2,
150   X_LIST_PRIORITY in NUMBER,
151   X_ASSIGN_PERSON_ID in NUMBER,
152   X_LIST_SOURCE in VARCHAR2,
153   X_LIST_SOURCE_TYPE in VARCHAR2,
154   X_LIST_ONLINE_FLAG in VARCHAR2,
155   X_RANDOM_LIST_ID in NUMBER,
156   X_ENABLED_FLAG in VARCHAR2,
157   X_ASSIGNED_TO in NUMBER,
158   X_QUERY_ID in NUMBER,
159   X_OWNER_PERSON_ID in NUMBER,
160   X_ARCHIVED_BY in NUMBER,
161   X_ARCHIVED_DATE in DATE,
162   X_ATTRIBUTE_CATEGORY in VARCHAR2,
163   X_ATTRIBUTE1 in VARCHAR2,
164   X_ATTRIBUTE2 in VARCHAR2,
165   X_ATTRIBUTE3 in VARCHAR2,
166   X_ATTRIBUTE4 in VARCHAR2,
167   X_ATTRIBUTE5 in VARCHAR2,
168   X_ATTRIBUTE6 in VARCHAR2,
169   X_ATTRIBUTE7 in VARCHAR2,
170   X_ATTRIBUTE8 in VARCHAR2,
171   X_ATTRIBUTE9 in VARCHAR2,
172   X_ATTRIBUTE10 in VARCHAR2,
173   X_ATTRIBUTE11 in VARCHAR2,
174   X_ATTRIBUTE12 in VARCHAR2,
175   X_ATTRIBUTE13 in VARCHAR2,
176   X_ATTRIBUTE14 in VARCHAR2,
177   X_ATTRIBUTE15 in VARCHAR2,
178   X_TIMEZONE_ID in NUMBER,
179   X_USER_ENTERED_START_TIME in DATE,
180   X_OBJECT_VERSION_NUMBER in NUMBER,
181   X_REQUEST_ID in NUMBER,
182   X_VIEW_APPLICATION_ID in NUMBER,
183   X_LIST_USED_BY_ID in NUMBER,
184   X_ARC_LIST_USED_BY in VARCHAR2,
185   X_LIST_TYPE in VARCHAR2,
186   X_STATUS_CODE in VARCHAR2,
187   X_STATUS_DATE in DATE,
188   X_GENERATION_TYPE in VARCHAR2,
189   X_REPEAT_EXCLUDE_TYPE in VARCHAR2,
190   X_ROW_SELECTION_TYPE in VARCHAR2,
191   X_LIST_NAME in VARCHAR2,
192   X_DESCRIPTION in VARCHAR2,
193   X_NO_OF_ROWS_PREV_CONTACTED  in NUMBER ,
194   X_APPLY_TRAFFIC_COP in VARCHAR2
195 );
196 procedure UPDATE_ROW (
197   X_LIST_HEADER_ID in NUMBER,
198   X_COUNTRY in NUMBER,
199   X_USER_STATUS_ID in NUMBER,
200   X_QUANTUM in NUMBER,
201   X_RELEASE_CONTROL_ALG_ID in NUMBER,
202   X_DIALING_METHOD in VARCHAR2,
203   X_CALLING_CALENDAR_ID in NUMBER,
204   X_RELEASE_STRATEGY in VARCHAR2,
205   X_CALLBACK_PRIORITY_FLAG in VARCHAR2,
206   X_CALL_CENTER_READY_FLAG in VARCHAR2,
207   X_CUSTOM_SETUP_ID in NUMBER,
208   X_OWNER_USER_ID in NUMBER,
209   X_ACCESS_LEVEL in VARCHAR2,
210   X_ENABLE_LOG_FLAG in VARCHAR2,
211   X_ENABLE_WORD_REPLACEMENT_FLAG in VARCHAR2,
212   X_ENABLE_PARALLEL_DML_FLAG in VARCHAR2,
213   X_DEDUPE_DURING_GENERATION_FLA in VARCHAR2,
214   X_GENERATE_CONTROL_GROUP_FLAG in VARCHAR2,
215   X_LAST_GENERATION_SUCCESS_FLAG in VARCHAR2,
216   X_FORECASTED_START_DATE in DATE,
217   X_FORECASTED_END_DATE in DATE,
218   X_ACTUAL_END_DATE in DATE,
219   X_SENT_OUT_DATE in DATE,
220   X_DEDUPE_START_DATE in DATE,
221   X_LAST_DEDUPE_DATE in DATE,
222   X_LAST_DEDUPED_BY_USER_ID in NUMBER,
223   X_WORKFLOW_ITEM_KEY in NUMBER,
224   X_NO_OF_ROWS_DUPLICATES in NUMBER,
225   X_NO_OF_ROWS_MIN_REQUESTED in NUMBER,
226   X_NO_OF_ROWS_MAX_REQUESTED in NUMBER,
227   X_NO_OF_ROWS_IN_LIST in NUMBER,
228   X_NO_OF_ROWS_IN_CTRL_GROUP in NUMBER,
229   X_NO_OF_ROWS_ACTIVE in NUMBER,
230   X_NO_OF_ROWS_INACTIVE in NUMBER,
231   X_NO_OF_ROWS_MANUALLY_ENTERED in NUMBER,
232   X_NO_OF_ROWS_DO_NOT_CALL in NUMBER,
233   X_NO_OF_ROWS_DO_NOT_MAIL in NUMBER,
234   X_NO_OF_ROWS_RANDOM in NUMBER,
235   X_MAIN_GEN_START_TIME in DATE,
236   X_MAIN_GEN_END_TIME in DATE,
237   X_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
238   X_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
239   X_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
240   X_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
241   X_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
242   X_RESULT_TEXT in VARCHAR2,
243   X_KEYWORDS in VARCHAR2,
244   X_LIST_PRIORITY in NUMBER,
245   X_ASSIGN_PERSON_ID in NUMBER,
246   X_LIST_SOURCE in VARCHAR2,
247   X_LIST_SOURCE_TYPE in VARCHAR2,
248   X_LIST_ONLINE_FLAG in VARCHAR2,
249   X_RANDOM_LIST_ID in NUMBER,
250   X_ENABLED_FLAG in VARCHAR2,
251   X_ASSIGNED_TO in NUMBER,
252   X_QUERY_ID in NUMBER,
253   X_OWNER_PERSON_ID in NUMBER,
254   X_ARCHIVED_BY in NUMBER,
255   X_ARCHIVED_DATE in DATE,
256   X_ATTRIBUTE_CATEGORY in VARCHAR2,
257   X_ATTRIBUTE1 in VARCHAR2,
258   X_ATTRIBUTE2 in VARCHAR2,
259   X_ATTRIBUTE3 in VARCHAR2,
260   X_ATTRIBUTE4 in VARCHAR2,
261   X_ATTRIBUTE5 in VARCHAR2,
262   X_ATTRIBUTE6 in VARCHAR2,
263   X_ATTRIBUTE7 in VARCHAR2,
264   X_ATTRIBUTE8 in VARCHAR2,
265   X_ATTRIBUTE9 in VARCHAR2,
266   X_ATTRIBUTE10 in VARCHAR2,
267   X_ATTRIBUTE11 in VARCHAR2,
268   X_ATTRIBUTE12 in VARCHAR2,
269   X_ATTRIBUTE13 in VARCHAR2,
270   X_ATTRIBUTE14 in VARCHAR2,
271   X_ATTRIBUTE15 in VARCHAR2,
272   X_TIMEZONE_ID in NUMBER,
273   X_USER_ENTERED_START_TIME in DATE,
274   X_OBJECT_VERSION_NUMBER in NUMBER,
275   X_REQUEST_ID in NUMBER,
276   X_VIEW_APPLICATION_ID in NUMBER,
277   X_LIST_USED_BY_ID in NUMBER,
278   X_ARC_LIST_USED_BY in VARCHAR2,
279   X_LIST_TYPE in VARCHAR2,
280   X_STATUS_CODE in VARCHAR2,
281   X_STATUS_DATE in DATE,
282   X_GENERATION_TYPE in VARCHAR2,
283   X_REPEAT_EXCLUDE_TYPE in VARCHAR2,
284   X_ROW_SELECTION_TYPE in VARCHAR2,
285   X_LIST_NAME in VARCHAR2,
286   X_DESCRIPTION in VARCHAR2,
287   X_LAST_UPDATE_DATE in DATE,
288   X_LAST_UPDATED_BY in NUMBER,
289   X_LAST_UPDATE_LOGIN in NUMBER,
290   X_NO_OF_ROWS_PREV_CONTACTED  in NUMBER,
291   X_APPLY_TRAFFIC_COP in VARCHAR2
292 );
293 procedure DELETE_ROW (
294   X_LIST_HEADER_ID in NUMBER
295 );
296 procedure ADD_LANGUAGE;
297 procedure LOAD_ROW (
298   P_LIST_HEADER_ID in NUMBER,
299   P_OWNER in VARCHAR2,
300   P_COUNTRY in NUMBER,
301   P_USER_STATUS_ID in NUMBER,
302   P_QUANTUM in NUMBER,
303   P_RELEASE_CONTROL_ALG_ID in NUMBER,
304   P_DIALING_METHOD in VARCHAR2,
305   P_CALLING_CALENDAR_ID in NUMBER,
306   P_RELEASE_STRATEGY in VARCHAR2,
307   P_CALLBACK_PRIORITY_FLAG in VARCHAR2,
308   P_CALL_CENTER_READY_FLAG in VARCHAR2,
309   P_CUSTOM_SETUP_ID in NUMBER,
310   P_OWNER_USER_ID in NUMBER,
311   P_ACCESS_LEVEL in VARCHAR2,
312   P_ENABLE_LOG_FLAG in VARCHAR2,
313   P_ENABLE_WORD_REPLACEMENT_FLAG in VARCHAR2,
314   P_ENABLE_PARALLEL_DML_FLAG in VARCHAR2,
315   P_DEDUPE_DURING_GENERATION_FLA in VARCHAR2,
316   P_GENERATE_CONTROL_GROUP_FLAG in VARCHAR2,
317   P_LAST_GENERATION_SUCCESS_FLAG in VARCHAR2,
318   P_FORECASTED_START_DATE in DATE,
319   P_FORECASTED_END_DATE in DATE,
320   P_ACTUAL_END_DATE in DATE,
321   P_SENT_OUT_DATE in DATE,
322   P_DEDUPE_START_DATE in DATE,
323   P_LAST_DEDUPE_DATE in DATE,
324   P_LAST_DEDUPED_BY_USER_ID in NUMBER,
325   P_WORKFLOW_ITEM_KEY in NUMBER,
326   P_NO_OF_ROWS_DUPLICATES in NUMBER,
327   P_NO_OF_ROWS_MIN_REQUESTED in NUMBER,
328   P_NO_OF_ROWS_MAX_REQUESTED in NUMBER,
329   P_NO_OF_ROWS_IN_LIST in NUMBER,
330   P_NO_OF_ROWS_IN_CTRL_GROUP in NUMBER,
331   P_NO_OF_ROWS_ACTIVE in NUMBER,
332   P_NO_OF_ROWS_INACTIVE in NUMBER,
333   P_NO_OF_ROWS_MANUALLY_ENTERED in NUMBER,
334   P_NO_OF_ROWS_DO_NOT_CALL in NUMBER,
335   P_NO_OF_ROWS_DO_NOT_MAIL in NUMBER,
336   P_NO_OF_ROWS_RANDOM in NUMBER,
337   P_MAIN_GEN_START_TIME in DATE,
338   P_MAIN_GEN_END_TIME in DATE,
339   P_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
340   P_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
341   P_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
342   P_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
343   P_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
344   P_RESULT_TEXT in VARCHAR2,
345   P_KEYWORDS in VARCHAR2,
346   P_LIST_PRIORITY in NUMBER,
347   P_ASSIGN_PERSON_ID in NUMBER,
348   P_LIST_SOURCE in VARCHAR2,
349   P_LIST_SOURCE_TYPE in VARCHAR2,
350   P_LIST_ONLINE_FLAG in VARCHAR2,
351   P_RANDOM_LIST_ID in NUMBER,
352   P_ENABLED_FLAG in VARCHAR2,
353   P_ASSIGNED_TO in NUMBER,
354   P_QUERY_ID in NUMBER,
355   P_OWNER_PERSON_ID in NUMBER,
356   P_ARCHIVED_BY in NUMBER,
357   P_ARCHIVED_DATE in DATE,
358   P_ATTRIBUTE_CATEGORY in VARCHAR2,
359   P_ATTRIBUTE1 in VARCHAR2,
360   P_ATTRIBUTE2 in VARCHAR2,
361   P_ATTRIBUTE3 in VARCHAR2,
362   P_ATTRIBUTE4 in VARCHAR2,
363   P_ATTRIBUTE5 in VARCHAR2,
364   P_ATTRIBUTE6 in VARCHAR2,
365   P_ATTRIBUTE7 in VARCHAR2,
366   P_ATTRIBUTE8 in VARCHAR2,
367   P_ATTRIBUTE9 in VARCHAR2,
368   P_ATTRIBUTE10 in VARCHAR2,
369   P_ATTRIBUTE11 in VARCHAR2,
370   P_ATTRIBUTE12 in VARCHAR2,
371   P_ATTRIBUTE13 in VARCHAR2,
372   P_ATTRIBUTE14 in VARCHAR2,
373   P_ATTRIBUTE15 in VARCHAR2,
374   P_TIMEZONE_ID in NUMBER,
375   P_USER_ENTERED_START_TIME in DATE,
376   P_OBJECT_VERSION_NUMBER in NUMBER,
377   P_REQUEST_ID in NUMBER,
378   P_VIEW_APPLICATION_ID in NUMBER,
379   P_LIST_USED_BY_ID in NUMBER,
383   P_STATUS_DATE in DATE,
380   P_ARC_LIST_USED_BY in VARCHAR2,
381   P_LIST_TYPE in VARCHAR2,
382   P_STATUS_CODE in VARCHAR2,
384   P_GENERATION_TYPE in VARCHAR2,
385   P_REPEAT_EXCLUDE_TYPE in VARCHAR2,
386   P_ROW_SELECTION_TYPE in VARCHAR2,
387   P_LIST_NAME in VARCHAR2,
388   P_DESCRIPTION in VARCHAR2,
389   P_CREATION_DATE in DATE,
390   P_CREATED_BY in NUMBER,
391   P_LAST_UPDATE_DATE in DATE,
392   P_LAST_UPDATED_BY in NUMBER,
393   P_LAST_UPDATE_LOGIN in NUMBER ,
394   P_NO_OF_ROWS_PREV_CONTACTED  in NUMBER ,
395   P_APPLY_TRAFFIC_COP in VARCHAR2,
396   p_custom_mode    in VARCHAR2
397 
398 );
399 
400 PROCEDURE translate_row(
401   x_list_header_id in number,
402   x_list_name      in varchar2,
403   x_description    in varchar2,
404   x_owner          in varchar2,
405   x_custom_mode    in varchar2
406  );
407 
408 end AMS_LIST_HEADERS_ALL_PKG;