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: APPS.AMS_LIST_HEADERS_VL_PKG

Source


1 package AMS_LIST_HEADERS_VL_PKG as
2 /* $Header: amstlhvs.pls 120.3 2005/09/15 04:18:54 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 procedure LOCK_ROW (
132   X_LIST_HEADER_ID in NUMBER,
133   X_PURPOSE_CODE in VARCHAR2,
134   X_NO_OF_ROWS_FATIGUED in NUMBER,
135   X_NO_OF_ROWS_SUPPRESSED in NUMBER,
136   X_QUERY_TEMPLATE_ID in NUMBER,
137   X_MIGRATION_DATE in DATE,
138   X_TCA_FAILED_RECORDS in NUMBER,
139   X_USER_STATUS_ID in NUMBER,
140   X_QUANTUM in NUMBER,
141   X_RELEASE_CONTROL_ALG_ID in NUMBER,
142   X_DIALING_METHOD in VARCHAR2,
143   X_CALLING_CALENDAR_ID in NUMBER,
144   X_RELEASE_STRATEGY in VARCHAR2,
145   X_CUSTOM_SETUP_ID in NUMBER,
146   X_COUNTRY in NUMBER,
147   X_CALLBACK_PRIORITY_FLAG in VARCHAR2,
148   X_CALL_CENTER_READY_FLAG in VARCHAR2,
149   X_PURGE_FLAG in VARCHAR2,
150   X_QUOTA in NUMBER,
151   X_QUOTA_RESET in NUMBER,
152   X_RECYCLING_ALG_ID in NUMBER,
153   X_PUBLIC_FLAG in VARCHAR2,
154   X_LIST_CATEGORY in VARCHAR2,
155   X_NO_OF_ROWS_MANUALLY_ENTERED in NUMBER,
156   X_NO_OF_ROWS_DO_NOT_CALL in NUMBER,
157   X_NO_OF_ROWS_DO_NOT_MAIL in NUMBER,
158   X_NO_OF_ROWS_RANDOM in NUMBER,
159   X_MAIN_GEN_START_TIME in DATE,
160   X_MAIN_GEN_END_TIME in DATE,
161   X_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
162   X_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
163   X_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
164   X_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
165   X_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
166   X_RESULT_TEXT in VARCHAR2,
167   X_KEYWORDS in VARCHAR2,
168   X_DESCRIPTION in VARCHAR2,
169   X_LIST_PRIORITY in NUMBER,
170   X_ASSIGN_PERSON_ID in NUMBER,
171   X_LIST_SOURCE in VARCHAR2,
172   X_LIST_SOURCE_TYPE in VARCHAR2,
173   X_LIST_ONLINE_FLAG in VARCHAR2,
174   X_RANDOM_LIST_ID in NUMBER,
175   X_ENABLED_FLAG in VARCHAR2,
176   X_ASSIGNED_TO in NUMBER,
177   X_QUERY_ID in NUMBER,
178   X_OWNER_PERSON_ID in NUMBER,
179   X_ARCHIVED_BY in NUMBER,
180   X_ARCHIVED_DATE in DATE,
181   X_ATTRIBUTE_CATEGORY in VARCHAR2,
182   X_ATTRIBUTE1 in VARCHAR2,
183   X_ATTRIBUTE2 in VARCHAR2,
184   X_ATTRIBUTE3 in VARCHAR2,
185   X_ATTRIBUTE4 in VARCHAR2,
186   X_ATTRIBUTE5 in VARCHAR2,
187   X_ATTRIBUTE6 in VARCHAR2,
188   X_ATTRIBUTE7 in VARCHAR2,
189   X_ATTRIBUTE8 in VARCHAR2,
190   X_ATTRIBUTE9 in VARCHAR2,
191   X_ATTRIBUTE10 in VARCHAR2,
192   X_ATTRIBUTE11 in VARCHAR2,
193   X_ATTRIBUTE12 in VARCHAR2,
194   X_ATTRIBUTE13 in VARCHAR2,
195   X_ATTRIBUTE14 in VARCHAR2,
196   X_ATTRIBUTE15 in VARCHAR2,
197   X_TIMEZONE_ID in NUMBER,
198   X_USER_ENTERED_START_TIME in DATE,
199   X_OBJECT_VERSION_NUMBER in NUMBER,
200   X_REQUEST_ID in NUMBER,
201   X_VIEW_APPLICATION_ID in NUMBER,
202   X_LIST_USED_BY_ID in NUMBER,
203   X_ARC_LIST_USED_BY in VARCHAR2,
204   X_LIST_TYPE in VARCHAR2,
205   X_STATUS_CODE in VARCHAR2,
206   X_STATUS_DATE in DATE,
207   X_GENERATION_TYPE in VARCHAR2,
208   X_REPEAT_EXCLUDE_TYPE in VARCHAR2,
209   X_ROW_SELECTION_TYPE in VARCHAR2,
210   X_OWNER_USER_ID in NUMBER,
211   X_ACCESS_LEVEL in VARCHAR2,
212   X_ENABLE_LOG_FLAG in VARCHAR2,
213   X_ENABLE_WORD_REPLACEMENT_FLAG in VARCHAR2,
214   X_ENABLE_PARALLEL_DML_FLAG in VARCHAR2,
215   X_DEDUPE_DURING_GENERATION_FLA in VARCHAR2,
216   X_GENERATE_CONTROL_GROUP_FLAG in VARCHAR2,
217   X_LAST_GENERATION_SUCCESS_FLAG in VARCHAR2,
218   X_FORECASTED_START_DATE in DATE,
219   X_FORECASTED_END_DATE in DATE,
220   X_ACTUAL_END_DATE in DATE,
221   X_SENT_OUT_DATE in DATE,
222   X_DEDUPE_START_DATE in DATE,
223   X_LAST_DEDUPE_DATE in DATE,
224   X_LAST_DEDUPED_BY_USER_ID in NUMBER,
225   X_WORKFLOW_ITEM_KEY in NUMBER,
226   X_NO_OF_ROWS_DUPLICATES in NUMBER,
227   X_NO_OF_ROWS_MIN_REQUESTED in NUMBER,
228   X_NO_OF_ROWS_MAX_REQUESTED in NUMBER,
229   X_NO_OF_ROWS_IN_LIST in NUMBER,
230   X_NO_OF_ROWS_IN_CTRL_GROUP in NUMBER,
231   X_NO_OF_ROWS_ACTIVE in NUMBER,
232   X_NO_OF_ROWS_INACTIVE in NUMBER,
233   X_APPLY_TRAFFIC_COP in VARCHAR2,
234   X_LIST_NAME in VARCHAR2,
235   X_PROGRAM_ID NUMBER,
236   X_PROGRAM_APPLICATION_ID NUMBER,
237   X_PROGRAM_UPDATE_DATE DATE,
238   X_ORG_ID NUMBER,
239   X_NO_OF_ROWS_PREV_CONTACTED NUMBER,
240   X_PARENT_LIST_HEADER_ID NUMBER,
241   X_SPLIT_TYPE VARCHAR,
242   X_SPLIT_VALUE NUMBER,
243     X_CTRL_CONF_LEVEL NUMBER,
244         X_CTRL_REQ_RESP_RATE NUMBER,
245         X_CTRL_LIMIT_OF_ERROR NUMBER,
246         X_STATUS_CODE_OLD VARCHAR2,
247         X_CTRL_CONC_JOB_ID NUMBER,
248         X_CTRL_STATUS_CODE VARCHAR2,
249         X_CTRL_GEN_MODE VARCHAR2,
250 	X_APPLY_SUPPRESSION_FLAG VARCHAR2    --rmbhanda bug #4609206
251 
252 
253 );
254 procedure UPDATE_ROW (
255   X_LIST_HEADER_ID in NUMBER,
256   X_PURPOSE_CODE in VARCHAR2,
257   X_NO_OF_ROWS_FATIGUED in NUMBER,
258   X_NO_OF_ROWS_SUPPRESSED in NUMBER,
259   X_QUERY_TEMPLATE_ID in NUMBER,
260   X_MIGRATION_DATE in DATE,
261   X_TCA_FAILED_RECORDS in NUMBER,
262   X_USER_STATUS_ID in NUMBER,
263   X_QUANTUM in NUMBER,
264   X_RELEASE_CONTROL_ALG_ID in NUMBER,
265   X_DIALING_METHOD in VARCHAR2,
266   X_CALLING_CALENDAR_ID in NUMBER,
267   X_RELEASE_STRATEGY in VARCHAR2,
268   X_CUSTOM_SETUP_ID in NUMBER,
269   X_COUNTRY in NUMBER,
270   X_CALLBACK_PRIORITY_FLAG in VARCHAR2,
271   X_CALL_CENTER_READY_FLAG in VARCHAR2,
272   X_PURGE_FLAG in VARCHAR2,
273   X_QUOTA in NUMBER,
274   X_QUOTA_RESET in NUMBER,
275   X_RECYCLING_ALG_ID in NUMBER,
276   X_PUBLIC_FLAG in VARCHAR2,
277   X_LIST_CATEGORY in VARCHAR2,
278   X_NO_OF_ROWS_MANUALLY_ENTERED in NUMBER,
279   X_NO_OF_ROWS_DO_NOT_CALL in NUMBER,
280   X_NO_OF_ROWS_DO_NOT_MAIL in NUMBER,
281   X_NO_OF_ROWS_RANDOM in NUMBER,
282   X_MAIN_GEN_START_TIME in DATE,
283   X_MAIN_GEN_END_TIME in DATE,
284   X_MAIN_RANDOM_NTH_ROW_SELECTIO in NUMBER,
285   X_MAIN_RANDOM_PCT_ROW_SELECTIO in NUMBER,
286   X_CTRL_RANDOM_NTH_ROW_SELECTIO in NUMBER,
287   X_CTRL_RANDOM_PCT_ROW_SELECTIO in NUMBER,
288   X_REPEAT_SOURCE_LIST_HEADER_ID in VARCHAR2,
289   X_RESULT_TEXT in VARCHAR2,
290   X_KEYWORDS in VARCHAR2,
291   X_DESCRIPTION in VARCHAR2,
292   X_LIST_PRIORITY in NUMBER,
293   X_ASSIGN_PERSON_ID in NUMBER,
294   X_LIST_SOURCE in VARCHAR2,
295   X_LIST_SOURCE_TYPE in VARCHAR2,
296   X_LIST_ONLINE_FLAG in VARCHAR2,
297   X_RANDOM_LIST_ID in NUMBER,
298   X_ENABLED_FLAG in VARCHAR2,
299   X_ASSIGNED_TO in NUMBER,
300   X_QUERY_ID in NUMBER,
301   X_OWNER_PERSON_ID in NUMBER,
302   X_ARCHIVED_BY in NUMBER,
303   X_ARCHIVED_DATE in DATE,
304   X_ATTRIBUTE_CATEGORY in VARCHAR2,
305   X_ATTRIBUTE1 in VARCHAR2,
306   X_ATTRIBUTE2 in VARCHAR2,
307   X_ATTRIBUTE3 in VARCHAR2,
308   X_ATTRIBUTE4 in VARCHAR2,
309   X_ATTRIBUTE5 in VARCHAR2,
310   X_ATTRIBUTE6 in VARCHAR2,
311   X_ATTRIBUTE7 in VARCHAR2,
312   X_ATTRIBUTE8 in VARCHAR2,
313   X_ATTRIBUTE9 in VARCHAR2,
314   X_ATTRIBUTE10 in VARCHAR2,
315   X_ATTRIBUTE11 in VARCHAR2,
316   X_ATTRIBUTE12 in VARCHAR2,
317   X_ATTRIBUTE13 in VARCHAR2,
318   X_ATTRIBUTE14 in VARCHAR2,
319   X_ATTRIBUTE15 in VARCHAR2,
320   X_TIMEZONE_ID in NUMBER,
321   X_USER_ENTERED_START_TIME in DATE,
322   X_OBJECT_VERSION_NUMBER in NUMBER,
323   X_REQUEST_ID in NUMBER,
324   X_VIEW_APPLICATION_ID in NUMBER,
325   X_LIST_USED_BY_ID in NUMBER,
326   X_ARC_LIST_USED_BY in VARCHAR2,
327   X_LIST_TYPE in VARCHAR2,
328   X_STATUS_CODE in VARCHAR2,
329   X_STATUS_DATE in DATE,
330   X_GENERATION_TYPE in VARCHAR2,
331   X_REPEAT_EXCLUDE_TYPE in VARCHAR2,
332   X_ROW_SELECTION_TYPE in VARCHAR2,
333   X_OWNER_USER_ID in NUMBER,
334   X_ACCESS_LEVEL in VARCHAR2,
335   X_ENABLE_LOG_FLAG in VARCHAR2,
336   X_ENABLE_WORD_REPLACEMENT_FLAG in VARCHAR2,
337   X_ENABLE_PARALLEL_DML_FLAG in VARCHAR2,
338   X_DEDUPE_DURING_GENERATION_FLA in VARCHAR2,
339   X_GENERATE_CONTROL_GROUP_FLAG in VARCHAR2,
340   X_LAST_GENERATION_SUCCESS_FLAG in VARCHAR2,
341   X_FORECASTED_START_DATE in DATE,
342   X_FORECASTED_END_DATE in DATE,
343   X_ACTUAL_END_DATE in DATE,
344   X_SENT_OUT_DATE in DATE,
345   X_DEDUPE_START_DATE in DATE,
346   X_LAST_DEDUPE_DATE in DATE,
347   X_LAST_DEDUPED_BY_USER_ID in NUMBER,
348   X_WORKFLOW_ITEM_KEY in NUMBER,
349   X_NO_OF_ROWS_DUPLICATES in NUMBER,
350   X_NO_OF_ROWS_MIN_REQUESTED in NUMBER,
351   X_NO_OF_ROWS_MAX_REQUESTED in NUMBER,
352   X_NO_OF_ROWS_IN_LIST in NUMBER,
353   X_NO_OF_ROWS_IN_CTRL_GROUP in NUMBER,
354   X_NO_OF_ROWS_ACTIVE in NUMBER,
355   X_NO_OF_ROWS_INACTIVE in NUMBER,
356   X_APPLY_TRAFFIC_COP in VARCHAR2,
357   X_LIST_NAME in VARCHAR2,
358   X_LAST_UPDATE_DATE in DATE,
359   X_LAST_UPDATED_BY in NUMBER,
360   X_LAST_UPDATE_LOGIN in NUMBER,
361   X_PROGRAM_ID NUMBER,
362   X_PROGRAM_APPLICATION_ID NUMBER,
363   X_PROGRAM_UPDATE_DATE DATE,
364   X_ORG_ID NUMBER,
365   X_NO_OF_ROWS_PREV_CONTACTED NUMBER,
366   X_PARENT_LIST_HEADER_ID NUMBER,
367   X_SPLIT_TYPE VARCHAR,
368   X_SPLIT_VALUE NUMBER,
369     X_CTRL_CONF_LEVEL NUMBER,
370         X_CTRL_REQ_RESP_RATE NUMBER,
371         X_CTRL_LIMIT_OF_ERROR NUMBER,
372         X_STATUS_CODE_OLD VARCHAR2,
373         X_CTRL_CONC_JOB_ID NUMBER,
374         X_CTRL_STATUS_CODE VARCHAR2,
375         X_CTRL_GEN_MODE VARCHAR2,
376 	X_APPLY_SUPPRESSION_FLAG  VARCHAR2   --rmbhanda bug#4609206
377 
378 );
379 procedure DELETE_ROW (
380   X_LIST_HEADER_ID in NUMBER
381 );
382 procedure ADD_LANGUAGE;
383 end AMS_LIST_HEADERS_VL_PKG;