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;