[Home] [Help]
PACKAGE BODY: APPS.AMS_LISTHEADER_PVT_W
Source
1 package body ams_listheader_pvt_w as
2 /* $Header: amswlshb.pls 115.20 2004/02/04 01:34:45 vbhandar ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure create_listheader(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , x_return_status out nocopy VARCHAR2
27 , x_msg_count out nocopy NUMBER
28 , x_msg_data out nocopy VARCHAR2
29 , x_listheader_id out nocopy NUMBER
30 , p7_a0 NUMBER := 0-1962.0724
31 , p7_a1 DATE := fnd_api.g_miss_date
32 , p7_a2 NUMBER := 0-1962.0724
33 , p7_a3 DATE := fnd_api.g_miss_date
34 , p7_a4 NUMBER := 0-1962.0724
35 , p7_a5 NUMBER := 0-1962.0724
36 , p7_a6 NUMBER := 0-1962.0724
37 , p7_a7 NUMBER := 0-1962.0724
38 , p7_a8 NUMBER := 0-1962.0724
39 , p7_a9 NUMBER := 0-1962.0724
40 , p7_a10 DATE := fnd_api.g_miss_date
41 , p7_a11 NUMBER := 0-1962.0724
42 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43 , p7_a13 NUMBER := 0-1962.0724
44 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47 , p7_a17 DATE := fnd_api.g_miss_date
48 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51 , p7_a21 NUMBER := 0-1962.0724
52 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a29 DATE := fnd_api.g_miss_date
60 , p7_a30 DATE := fnd_api.g_miss_date
61 , p7_a31 DATE := fnd_api.g_miss_date
62 , p7_a32 DATE := fnd_api.g_miss_date
63 , p7_a33 DATE := fnd_api.g_miss_date
64 , p7_a34 DATE := fnd_api.g_miss_date
65 , p7_a35 NUMBER := 0-1962.0724
66 , p7_a36 NUMBER := 0-1962.0724
67 , p7_a37 NUMBER := 0-1962.0724
68 , p7_a38 NUMBER := 0-1962.0724
69 , p7_a39 NUMBER := 0-1962.0724
70 , p7_a40 NUMBER := 0-1962.0724
71 , p7_a41 NUMBER := 0-1962.0724
72 , p7_a42 NUMBER := 0-1962.0724
73 , p7_a43 NUMBER := 0-1962.0724
74 , p7_a44 NUMBER := 0-1962.0724
75 , p7_a45 NUMBER := 0-1962.0724
76 , p7_a46 NUMBER := 0-1962.0724
77 , p7_a47 NUMBER := 0-1962.0724
78 , p7_a48 NUMBER := 0-1962.0724
79 , p7_a49 DATE := fnd_api.g_miss_date
80 , p7_a50 DATE := fnd_api.g_miss_date
81 , p7_a51 NUMBER := 0-1962.0724
82 , p7_a52 NUMBER := 0-1962.0724
83 , p7_a53 NUMBER := 0-1962.0724
84 , p7_a54 NUMBER := 0-1962.0724
85 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
86 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
87 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
88 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
89 , p7_a59 NUMBER := 0-1962.0724
90 , p7_a60 NUMBER := 0-1962.0724
91 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
92 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
93 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
94 , p7_a64 NUMBER := 0-1962.0724
95 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
96 , p7_a66 NUMBER := 0-1962.0724
97 , p7_a67 NUMBER := 0-1962.0724
98 , p7_a68 NUMBER := 0-1962.0724
99 , p7_a69 NUMBER := 0-1962.0724
100 , p7_a70 DATE := fnd_api.g_miss_date
101 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
102 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
103 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
104 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
105 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
106 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
107 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
108 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
109 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
110 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
111 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
112 , p7_a82 VARCHAR2 := fnd_api.g_miss_char
113 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
114 , p7_a84 VARCHAR2 := fnd_api.g_miss_char
115 , p7_a85 VARCHAR2 := fnd_api.g_miss_char
116 , p7_a86 VARCHAR2 := fnd_api.g_miss_char
117 , p7_a87 NUMBER := 0-1962.0724
118 , p7_a88 DATE := fnd_api.g_miss_date
119 , p7_a89 NUMBER := 0-1962.0724
120 , p7_a90 NUMBER := 0-1962.0724
121 , p7_a91 NUMBER := 0-1962.0724
122 , p7_a92 VARCHAR2 := fnd_api.g_miss_char
123 , p7_a93 NUMBER := 0-1962.0724
124 , p7_a94 VARCHAR2 := fnd_api.g_miss_char
125 , p7_a95 NUMBER := 0-1962.0724
126 , p7_a96 NUMBER := 0-1962.0724
127 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
128 , p7_a98 VARCHAR2 := fnd_api.g_miss_char
129 , p7_a99 VARCHAR2 := fnd_api.g_miss_char
130 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
131 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
132 , p7_a102 VARCHAR2 := fnd_api.g_miss_char
133 , p7_a103 NUMBER := 0-1962.0724
134 , p7_a104 NUMBER := 0-1962.0724
135 , p7_a105 NUMBER := 0-1962.0724
136 , p7_a106 VARCHAR2 := fnd_api.g_miss_char
137 , p7_a107 NUMBER := 0-1962.0724
138 , p7_a108 VARCHAR2 := fnd_api.g_miss_char
139 )
140
141 as
142 ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
143 ddindx binary_integer; indx binary_integer;
144 begin
145
146 -- copy data to the local IN or IN-OUT args, if any
147
148
149
150
151
152
153
154 ddp_listheader_rec.list_header_id := rosetta_g_miss_num_map(p7_a0);
155 ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
156 ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
157 ddp_listheader_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
158 ddp_listheader_rec.created_by := rosetta_g_miss_num_map(p7_a4);
159 ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
160 ddp_listheader_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
161 ddp_listheader_rec.request_id := rosetta_g_miss_num_map(p7_a7);
162 ddp_listheader_rec.program_id := rosetta_g_miss_num_map(p7_a8);
163 ddp_listheader_rec.program_application_id := rosetta_g_miss_num_map(p7_a9);
164 ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a10);
165 ddp_listheader_rec.view_application_id := rosetta_g_miss_num_map(p7_a11);
166 ddp_listheader_rec.list_name := p7_a12;
167 ddp_listheader_rec.list_used_by_id := rosetta_g_miss_num_map(p7_a13);
168 ddp_listheader_rec.arc_list_used_by := p7_a14;
169 ddp_listheader_rec.list_type := p7_a15;
170 ddp_listheader_rec.status_code := p7_a16;
171 ddp_listheader_rec.status_date := rosetta_g_miss_date_in_map(p7_a17);
172 ddp_listheader_rec.generation_type := p7_a18;
173 ddp_listheader_rec.repeat_exclude_type := p7_a19;
174 ddp_listheader_rec.row_selection_type := p7_a20;
175 ddp_listheader_rec.owner_user_id := rosetta_g_miss_num_map(p7_a21);
176 ddp_listheader_rec.access_level := p7_a22;
177 ddp_listheader_rec.enable_log_flag := p7_a23;
178 ddp_listheader_rec.enable_word_replacement_flag := p7_a24;
179 ddp_listheader_rec.enable_parallel_dml_flag := p7_a25;
180 ddp_listheader_rec.dedupe_during_generation_flag := p7_a26;
181 ddp_listheader_rec.generate_control_group_flag := p7_a27;
182 ddp_listheader_rec.last_generation_success_flag := p7_a28;
183 ddp_listheader_rec.forecasted_start_date := rosetta_g_miss_date_in_map(p7_a29);
184 ddp_listheader_rec.forecasted_end_date := rosetta_g_miss_date_in_map(p7_a30);
185 ddp_listheader_rec.actual_end_date := rosetta_g_miss_date_in_map(p7_a31);
186 ddp_listheader_rec.sent_out_date := rosetta_g_miss_date_in_map(p7_a32);
187 ddp_listheader_rec.dedupe_start_date := rosetta_g_miss_date_in_map(p7_a33);
188 ddp_listheader_rec.last_dedupe_date := rosetta_g_miss_date_in_map(p7_a34);
189 ddp_listheader_rec.last_deduped_by_user_id := rosetta_g_miss_num_map(p7_a35);
190 ddp_listheader_rec.workflow_item_key := rosetta_g_miss_num_map(p7_a36);
191 ddp_listheader_rec.no_of_rows_duplicates := rosetta_g_miss_num_map(p7_a37);
192 ddp_listheader_rec.no_of_rows_min_requested := rosetta_g_miss_num_map(p7_a38);
193 ddp_listheader_rec.no_of_rows_max_requested := rosetta_g_miss_num_map(p7_a39);
194 ddp_listheader_rec.no_of_rows_in_list := rosetta_g_miss_num_map(p7_a40);
195 ddp_listheader_rec.no_of_rows_in_ctrl_group := rosetta_g_miss_num_map(p7_a41);
196 ddp_listheader_rec.no_of_rows_active := rosetta_g_miss_num_map(p7_a42);
197 ddp_listheader_rec.no_of_rows_inactive := rosetta_g_miss_num_map(p7_a43);
198 ddp_listheader_rec.no_of_rows_manually_entered := rosetta_g_miss_num_map(p7_a44);
199 ddp_listheader_rec.no_of_rows_do_not_call := rosetta_g_miss_num_map(p7_a45);
200 ddp_listheader_rec.no_of_rows_do_not_mail := rosetta_g_miss_num_map(p7_a46);
201 ddp_listheader_rec.no_of_rows_random := rosetta_g_miss_num_map(p7_a47);
202 ddp_listheader_rec.org_id := rosetta_g_miss_num_map(p7_a48);
203 ddp_listheader_rec.main_gen_start_time := rosetta_g_miss_date_in_map(p7_a49);
204 ddp_listheader_rec.main_gen_end_time := rosetta_g_miss_date_in_map(p7_a50);
205 ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p7_a51);
206 ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p7_a52);
207 ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p7_a53);
208 ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p7_a54);
209 ddp_listheader_rec.repeat_source_list_header_id := p7_a55;
210 ddp_listheader_rec.result_text := p7_a56;
211 ddp_listheader_rec.keywords := p7_a57;
212 ddp_listheader_rec.description := p7_a58;
213 ddp_listheader_rec.list_priority := rosetta_g_miss_num_map(p7_a59);
214 ddp_listheader_rec.assign_person_id := rosetta_g_miss_num_map(p7_a60);
215 ddp_listheader_rec.list_source := p7_a61;
216 ddp_listheader_rec.list_source_type := p7_a62;
217 ddp_listheader_rec.list_online_flag := p7_a63;
218 ddp_listheader_rec.random_list_id := rosetta_g_miss_num_map(p7_a64);
219 ddp_listheader_rec.enabled_flag := p7_a65;
220 ddp_listheader_rec.assigned_to := rosetta_g_miss_num_map(p7_a66);
221 ddp_listheader_rec.query_id := rosetta_g_miss_num_map(p7_a67);
222 ddp_listheader_rec.owner_person_id := rosetta_g_miss_num_map(p7_a68);
223 ddp_listheader_rec.archived_by := rosetta_g_miss_num_map(p7_a69);
224 ddp_listheader_rec.archived_date := rosetta_g_miss_date_in_map(p7_a70);
225 ddp_listheader_rec.attribute_category := p7_a71;
226 ddp_listheader_rec.attribute1 := p7_a72;
227 ddp_listheader_rec.attribute2 := p7_a73;
228 ddp_listheader_rec.attribute3 := p7_a74;
229 ddp_listheader_rec.attribute4 := p7_a75;
230 ddp_listheader_rec.attribute5 := p7_a76;
231 ddp_listheader_rec.attribute6 := p7_a77;
232 ddp_listheader_rec.attribute7 := p7_a78;
233 ddp_listheader_rec.attribute8 := p7_a79;
234 ddp_listheader_rec.attribute9 := p7_a80;
235 ddp_listheader_rec.attribute10 := p7_a81;
236 ddp_listheader_rec.attribute11 := p7_a82;
237 ddp_listheader_rec.attribute12 := p7_a83;
238 ddp_listheader_rec.attribute13 := p7_a84;
239 ddp_listheader_rec.attribute14 := p7_a85;
240 ddp_listheader_rec.attribute15 := p7_a86;
241 ddp_listheader_rec.timezone_id := rosetta_g_miss_num_map(p7_a87);
242 ddp_listheader_rec.user_entered_start_time := rosetta_g_miss_date_in_map(p7_a88);
243 ddp_listheader_rec.user_status_id := rosetta_g_miss_num_map(p7_a89);
244 ddp_listheader_rec.quantum := rosetta_g_miss_num_map(p7_a90);
245 ddp_listheader_rec.release_control_alg_id := rosetta_g_miss_num_map(p7_a91);
246 ddp_listheader_rec.dialing_method := p7_a92;
247 ddp_listheader_rec.calling_calendar_id := rosetta_g_miss_num_map(p7_a93);
248 ddp_listheader_rec.release_strategy := p7_a94;
249 ddp_listheader_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a95);
250 ddp_listheader_rec.country := rosetta_g_miss_num_map(p7_a96);
251 ddp_listheader_rec.callback_priority_flag := p7_a97;
252 ddp_listheader_rec.call_center_ready_flag := p7_a98;
253 ddp_listheader_rec.language := p7_a99;
254 ddp_listheader_rec.purge_flag := p7_a100;
255 ddp_listheader_rec.public_flag := p7_a101;
256 ddp_listheader_rec.list_category := p7_a102;
257 ddp_listheader_rec.quota := rosetta_g_miss_num_map(p7_a103);
258 ddp_listheader_rec.quota_reset := rosetta_g_miss_num_map(p7_a104);
259 ddp_listheader_rec.recycling_alg_id := rosetta_g_miss_num_map(p7_a105);
260 ddp_listheader_rec.source_lang := p7_a106;
261 ddp_listheader_rec.no_of_rows_prev_contacted := rosetta_g_miss_num_map(p7_a107);
262 ddp_listheader_rec.apply_traffic_cop := p7_a108;
263
264
265 -- here's the delegated call to the old PL/SQL routine
266 ams_listheader_pvt.create_listheader(p_api_version,
267 p_init_msg_list,
268 p_commit,
269 p_validation_level,
270 x_return_status,
271 x_msg_count,
272 x_msg_data,
273 ddp_listheader_rec,
274 x_listheader_id);
275
276 -- copy data back from the local variables to OUT or IN-OUT args, if any
277
278
279
280
281
282
283
284
285 end;
286
287 procedure update_listheader(p_api_version NUMBER
288 , p_init_msg_list VARCHAR2
289 , p_commit VARCHAR2
290 , p_validation_level NUMBER
291 , x_return_status out nocopy VARCHAR2
292 , x_msg_count out nocopy NUMBER
293 , x_msg_data out nocopy VARCHAR2
294 , p7_a0 NUMBER := 0-1962.0724
295 , p7_a1 DATE := fnd_api.g_miss_date
296 , p7_a2 NUMBER := 0-1962.0724
297 , p7_a3 DATE := fnd_api.g_miss_date
298 , p7_a4 NUMBER := 0-1962.0724
299 , p7_a5 NUMBER := 0-1962.0724
300 , p7_a6 NUMBER := 0-1962.0724
301 , p7_a7 NUMBER := 0-1962.0724
302 , p7_a8 NUMBER := 0-1962.0724
303 , p7_a9 NUMBER := 0-1962.0724
304 , p7_a10 DATE := fnd_api.g_miss_date
305 , p7_a11 NUMBER := 0-1962.0724
306 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
307 , p7_a13 NUMBER := 0-1962.0724
308 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
309 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
310 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
311 , p7_a17 DATE := fnd_api.g_miss_date
312 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
313 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
314 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
315 , p7_a21 NUMBER := 0-1962.0724
316 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
317 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
318 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
319 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
320 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
321 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
322 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
323 , p7_a29 DATE := fnd_api.g_miss_date
324 , p7_a30 DATE := fnd_api.g_miss_date
325 , p7_a31 DATE := fnd_api.g_miss_date
326 , p7_a32 DATE := fnd_api.g_miss_date
327 , p7_a33 DATE := fnd_api.g_miss_date
328 , p7_a34 DATE := fnd_api.g_miss_date
329 , p7_a35 NUMBER := 0-1962.0724
330 , p7_a36 NUMBER := 0-1962.0724
331 , p7_a37 NUMBER := 0-1962.0724
332 , p7_a38 NUMBER := 0-1962.0724
333 , p7_a39 NUMBER := 0-1962.0724
334 , p7_a40 NUMBER := 0-1962.0724
335 , p7_a41 NUMBER := 0-1962.0724
336 , p7_a42 NUMBER := 0-1962.0724
337 , p7_a43 NUMBER := 0-1962.0724
338 , p7_a44 NUMBER := 0-1962.0724
339 , p7_a45 NUMBER := 0-1962.0724
340 , p7_a46 NUMBER := 0-1962.0724
341 , p7_a47 NUMBER := 0-1962.0724
342 , p7_a48 NUMBER := 0-1962.0724
343 , p7_a49 DATE := fnd_api.g_miss_date
344 , p7_a50 DATE := fnd_api.g_miss_date
345 , p7_a51 NUMBER := 0-1962.0724
349 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
346 , p7_a52 NUMBER := 0-1962.0724
347 , p7_a53 NUMBER := 0-1962.0724
348 , p7_a54 NUMBER := 0-1962.0724
350 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
351 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
352 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
353 , p7_a59 NUMBER := 0-1962.0724
354 , p7_a60 NUMBER := 0-1962.0724
355 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
356 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
357 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
358 , p7_a64 NUMBER := 0-1962.0724
359 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
360 , p7_a66 NUMBER := 0-1962.0724
361 , p7_a67 NUMBER := 0-1962.0724
362 , p7_a68 NUMBER := 0-1962.0724
363 , p7_a69 NUMBER := 0-1962.0724
364 , p7_a70 DATE := fnd_api.g_miss_date
365 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
366 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
367 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
368 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
369 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
370 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
371 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
372 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
373 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
374 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
375 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
376 , p7_a82 VARCHAR2 := fnd_api.g_miss_char
377 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
378 , p7_a84 VARCHAR2 := fnd_api.g_miss_char
379 , p7_a85 VARCHAR2 := fnd_api.g_miss_char
380 , p7_a86 VARCHAR2 := fnd_api.g_miss_char
381 , p7_a87 NUMBER := 0-1962.0724
382 , p7_a88 DATE := fnd_api.g_miss_date
383 , p7_a89 NUMBER := 0-1962.0724
384 , p7_a90 NUMBER := 0-1962.0724
385 , p7_a91 NUMBER := 0-1962.0724
386 , p7_a92 VARCHAR2 := fnd_api.g_miss_char
387 , p7_a93 NUMBER := 0-1962.0724
388 , p7_a94 VARCHAR2 := fnd_api.g_miss_char
389 , p7_a95 NUMBER := 0-1962.0724
390 , p7_a96 NUMBER := 0-1962.0724
391 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
392 , p7_a98 VARCHAR2 := fnd_api.g_miss_char
393 , p7_a99 VARCHAR2 := fnd_api.g_miss_char
394 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
395 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
396 , p7_a102 VARCHAR2 := fnd_api.g_miss_char
397 , p7_a103 NUMBER := 0-1962.0724
398 , p7_a104 NUMBER := 0-1962.0724
399 , p7_a105 NUMBER := 0-1962.0724
400 , p7_a106 VARCHAR2 := fnd_api.g_miss_char
401 , p7_a107 NUMBER := 0-1962.0724
402 , p7_a108 VARCHAR2 := fnd_api.g_miss_char
403 )
404
405 as
406 ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
407 ddindx binary_integer; indx binary_integer;
408 begin
409
410 -- copy data to the local IN or IN-OUT args, if any
411
412
413
414
415
416
417
418 ddp_listheader_rec.list_header_id := rosetta_g_miss_num_map(p7_a0);
419 ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
420 ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
421 ddp_listheader_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
422 ddp_listheader_rec.created_by := rosetta_g_miss_num_map(p7_a4);
423 ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
424 ddp_listheader_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
425 ddp_listheader_rec.request_id := rosetta_g_miss_num_map(p7_a7);
426 ddp_listheader_rec.program_id := rosetta_g_miss_num_map(p7_a8);
427 ddp_listheader_rec.program_application_id := rosetta_g_miss_num_map(p7_a9);
428 ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a10);
429 ddp_listheader_rec.view_application_id := rosetta_g_miss_num_map(p7_a11);
430 ddp_listheader_rec.list_name := p7_a12;
431 ddp_listheader_rec.list_used_by_id := rosetta_g_miss_num_map(p7_a13);
432 ddp_listheader_rec.arc_list_used_by := p7_a14;
433 ddp_listheader_rec.list_type := p7_a15;
434 ddp_listheader_rec.status_code := p7_a16;
435 ddp_listheader_rec.status_date := rosetta_g_miss_date_in_map(p7_a17);
436 ddp_listheader_rec.generation_type := p7_a18;
437 ddp_listheader_rec.repeat_exclude_type := p7_a19;
438 ddp_listheader_rec.row_selection_type := p7_a20;
439 ddp_listheader_rec.owner_user_id := rosetta_g_miss_num_map(p7_a21);
440 ddp_listheader_rec.access_level := p7_a22;
441 ddp_listheader_rec.enable_log_flag := p7_a23;
442 ddp_listheader_rec.enable_word_replacement_flag := p7_a24;
443 ddp_listheader_rec.enable_parallel_dml_flag := p7_a25;
444 ddp_listheader_rec.dedupe_during_generation_flag := p7_a26;
445 ddp_listheader_rec.generate_control_group_flag := p7_a27;
446 ddp_listheader_rec.last_generation_success_flag := p7_a28;
447 ddp_listheader_rec.forecasted_start_date := rosetta_g_miss_date_in_map(p7_a29);
448 ddp_listheader_rec.forecasted_end_date := rosetta_g_miss_date_in_map(p7_a30);
449 ddp_listheader_rec.actual_end_date := rosetta_g_miss_date_in_map(p7_a31);
450 ddp_listheader_rec.sent_out_date := rosetta_g_miss_date_in_map(p7_a32);
451 ddp_listheader_rec.dedupe_start_date := rosetta_g_miss_date_in_map(p7_a33);
452 ddp_listheader_rec.last_dedupe_date := rosetta_g_miss_date_in_map(p7_a34);
453 ddp_listheader_rec.last_deduped_by_user_id := rosetta_g_miss_num_map(p7_a35);
454 ddp_listheader_rec.workflow_item_key := rosetta_g_miss_num_map(p7_a36);
455 ddp_listheader_rec.no_of_rows_duplicates := rosetta_g_miss_num_map(p7_a37);
459 ddp_listheader_rec.no_of_rows_in_ctrl_group := rosetta_g_miss_num_map(p7_a41);
456 ddp_listheader_rec.no_of_rows_min_requested := rosetta_g_miss_num_map(p7_a38);
457 ddp_listheader_rec.no_of_rows_max_requested := rosetta_g_miss_num_map(p7_a39);
458 ddp_listheader_rec.no_of_rows_in_list := rosetta_g_miss_num_map(p7_a40);
460 ddp_listheader_rec.no_of_rows_active := rosetta_g_miss_num_map(p7_a42);
461 ddp_listheader_rec.no_of_rows_inactive := rosetta_g_miss_num_map(p7_a43);
462 ddp_listheader_rec.no_of_rows_manually_entered := rosetta_g_miss_num_map(p7_a44);
463 ddp_listheader_rec.no_of_rows_do_not_call := rosetta_g_miss_num_map(p7_a45);
464 ddp_listheader_rec.no_of_rows_do_not_mail := rosetta_g_miss_num_map(p7_a46);
465 ddp_listheader_rec.no_of_rows_random := rosetta_g_miss_num_map(p7_a47);
466 ddp_listheader_rec.org_id := rosetta_g_miss_num_map(p7_a48);
467 ddp_listheader_rec.main_gen_start_time := rosetta_g_miss_date_in_map(p7_a49);
468 ddp_listheader_rec.main_gen_end_time := rosetta_g_miss_date_in_map(p7_a50);
469 ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p7_a51);
470 ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p7_a52);
471 ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p7_a53);
472 ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p7_a54);
473 ddp_listheader_rec.repeat_source_list_header_id := p7_a55;
474 ddp_listheader_rec.result_text := p7_a56;
475 ddp_listheader_rec.keywords := p7_a57;
476 ddp_listheader_rec.description := p7_a58;
477 ddp_listheader_rec.list_priority := rosetta_g_miss_num_map(p7_a59);
478 ddp_listheader_rec.assign_person_id := rosetta_g_miss_num_map(p7_a60);
479 ddp_listheader_rec.list_source := p7_a61;
480 ddp_listheader_rec.list_source_type := p7_a62;
481 ddp_listheader_rec.list_online_flag := p7_a63;
482 ddp_listheader_rec.random_list_id := rosetta_g_miss_num_map(p7_a64);
483 ddp_listheader_rec.enabled_flag := p7_a65;
484 ddp_listheader_rec.assigned_to := rosetta_g_miss_num_map(p7_a66);
485 ddp_listheader_rec.query_id := rosetta_g_miss_num_map(p7_a67);
486 ddp_listheader_rec.owner_person_id := rosetta_g_miss_num_map(p7_a68);
487 ddp_listheader_rec.archived_by := rosetta_g_miss_num_map(p7_a69);
488 ddp_listheader_rec.archived_date := rosetta_g_miss_date_in_map(p7_a70);
489 ddp_listheader_rec.attribute_category := p7_a71;
490 ddp_listheader_rec.attribute1 := p7_a72;
491 ddp_listheader_rec.attribute2 := p7_a73;
492 ddp_listheader_rec.attribute3 := p7_a74;
493 ddp_listheader_rec.attribute4 := p7_a75;
494 ddp_listheader_rec.attribute5 := p7_a76;
495 ddp_listheader_rec.attribute6 := p7_a77;
496 ddp_listheader_rec.attribute7 := p7_a78;
497 ddp_listheader_rec.attribute8 := p7_a79;
498 ddp_listheader_rec.attribute9 := p7_a80;
499 ddp_listheader_rec.attribute10 := p7_a81;
500 ddp_listheader_rec.attribute11 := p7_a82;
501 ddp_listheader_rec.attribute12 := p7_a83;
502 ddp_listheader_rec.attribute13 := p7_a84;
503 ddp_listheader_rec.attribute14 := p7_a85;
504 ddp_listheader_rec.attribute15 := p7_a86;
505 ddp_listheader_rec.timezone_id := rosetta_g_miss_num_map(p7_a87);
506 ddp_listheader_rec.user_entered_start_time := rosetta_g_miss_date_in_map(p7_a88);
507 ddp_listheader_rec.user_status_id := rosetta_g_miss_num_map(p7_a89);
508 ddp_listheader_rec.quantum := rosetta_g_miss_num_map(p7_a90);
509 ddp_listheader_rec.release_control_alg_id := rosetta_g_miss_num_map(p7_a91);
510 ddp_listheader_rec.dialing_method := p7_a92;
511 ddp_listheader_rec.calling_calendar_id := rosetta_g_miss_num_map(p7_a93);
512 ddp_listheader_rec.release_strategy := p7_a94;
513 ddp_listheader_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a95);
514 ddp_listheader_rec.country := rosetta_g_miss_num_map(p7_a96);
515 ddp_listheader_rec.callback_priority_flag := p7_a97;
516 ddp_listheader_rec.call_center_ready_flag := p7_a98;
517 ddp_listheader_rec.language := p7_a99;
518 ddp_listheader_rec.purge_flag := p7_a100;
519 ddp_listheader_rec.public_flag := p7_a101;
520 ddp_listheader_rec.list_category := p7_a102;
521 ddp_listheader_rec.quota := rosetta_g_miss_num_map(p7_a103);
522 ddp_listheader_rec.quota_reset := rosetta_g_miss_num_map(p7_a104);
523 ddp_listheader_rec.recycling_alg_id := rosetta_g_miss_num_map(p7_a105);
524 ddp_listheader_rec.source_lang := p7_a106;
525 ddp_listheader_rec.no_of_rows_prev_contacted := rosetta_g_miss_num_map(p7_a107);
526 ddp_listheader_rec.apply_traffic_cop := p7_a108;
527
528 -- here's the delegated call to the old PL/SQL routine
529 ams_listheader_pvt.update_listheader(p_api_version,
530 p_init_msg_list,
531 p_commit,
532 p_validation_level,
533 x_return_status,
534 x_msg_count,
535 x_msg_data,
536 ddp_listheader_rec);
537
538 -- copy data back from the local variables to OUT or IN-OUT args, if any
539
540
541
542
543
544
545
546 end;
547
548 procedure validate_listheader(p_api_version NUMBER
549 , p_init_msg_list VARCHAR2
550 , p_validation_level NUMBER
551 , x_return_status out nocopy VARCHAR2
552 , x_msg_count out nocopy NUMBER
553 , x_msg_data out nocopy VARCHAR2
554 , p6_a0 NUMBER := 0-1962.0724
555 , p6_a1 DATE := fnd_api.g_miss_date
556 , p6_a2 NUMBER := 0-1962.0724
557 , p6_a3 DATE := fnd_api.g_miss_date
558 , p6_a4 NUMBER := 0-1962.0724
559 , p6_a5 NUMBER := 0-1962.0724
563 , p6_a9 NUMBER := 0-1962.0724
560 , p6_a6 NUMBER := 0-1962.0724
561 , p6_a7 NUMBER := 0-1962.0724
562 , p6_a8 NUMBER := 0-1962.0724
564 , p6_a10 DATE := fnd_api.g_miss_date
565 , p6_a11 NUMBER := 0-1962.0724
566 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
567 , p6_a13 NUMBER := 0-1962.0724
568 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
569 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
570 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
571 , p6_a17 DATE := fnd_api.g_miss_date
572 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
573 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
574 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
575 , p6_a21 NUMBER := 0-1962.0724
576 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
577 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
578 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
579 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
580 , p6_a26 VARCHAR2 := fnd_api.g_miss_char
581 , p6_a27 VARCHAR2 := fnd_api.g_miss_char
582 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
583 , p6_a29 DATE := fnd_api.g_miss_date
584 , p6_a30 DATE := fnd_api.g_miss_date
585 , p6_a31 DATE := fnd_api.g_miss_date
586 , p6_a32 DATE := fnd_api.g_miss_date
587 , p6_a33 DATE := fnd_api.g_miss_date
588 , p6_a34 DATE := fnd_api.g_miss_date
589 , p6_a35 NUMBER := 0-1962.0724
590 , p6_a36 NUMBER := 0-1962.0724
591 , p6_a37 NUMBER := 0-1962.0724
592 , p6_a38 NUMBER := 0-1962.0724
593 , p6_a39 NUMBER := 0-1962.0724
594 , p6_a40 NUMBER := 0-1962.0724
595 , p6_a41 NUMBER := 0-1962.0724
596 , p6_a42 NUMBER := 0-1962.0724
597 , p6_a43 NUMBER := 0-1962.0724
598 , p6_a44 NUMBER := 0-1962.0724
599 , p6_a45 NUMBER := 0-1962.0724
600 , p6_a46 NUMBER := 0-1962.0724
601 , p6_a47 NUMBER := 0-1962.0724
602 , p6_a48 NUMBER := 0-1962.0724
603 , p6_a49 DATE := fnd_api.g_miss_date
604 , p6_a50 DATE := fnd_api.g_miss_date
605 , p6_a51 NUMBER := 0-1962.0724
606 , p6_a52 NUMBER := 0-1962.0724
607 , p6_a53 NUMBER := 0-1962.0724
608 , p6_a54 NUMBER := 0-1962.0724
609 , p6_a55 VARCHAR2 := fnd_api.g_miss_char
610 , p6_a56 VARCHAR2 := fnd_api.g_miss_char
611 , p6_a57 VARCHAR2 := fnd_api.g_miss_char
612 , p6_a58 VARCHAR2 := fnd_api.g_miss_char
613 , p6_a59 NUMBER := 0-1962.0724
614 , p6_a60 NUMBER := 0-1962.0724
615 , p6_a61 VARCHAR2 := fnd_api.g_miss_char
616 , p6_a62 VARCHAR2 := fnd_api.g_miss_char
617 , p6_a63 VARCHAR2 := fnd_api.g_miss_char
618 , p6_a64 NUMBER := 0-1962.0724
619 , p6_a65 VARCHAR2 := fnd_api.g_miss_char
620 , p6_a66 NUMBER := 0-1962.0724
621 , p6_a67 NUMBER := 0-1962.0724
622 , p6_a68 NUMBER := 0-1962.0724
623 , p6_a69 NUMBER := 0-1962.0724
624 , p6_a70 DATE := fnd_api.g_miss_date
625 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
626 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
627 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
628 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
629 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
630 , p6_a76 VARCHAR2 := fnd_api.g_miss_char
631 , p6_a77 VARCHAR2 := fnd_api.g_miss_char
632 , p6_a78 VARCHAR2 := fnd_api.g_miss_char
633 , p6_a79 VARCHAR2 := fnd_api.g_miss_char
634 , p6_a80 VARCHAR2 := fnd_api.g_miss_char
635 , p6_a81 VARCHAR2 := fnd_api.g_miss_char
636 , p6_a82 VARCHAR2 := fnd_api.g_miss_char
637 , p6_a83 VARCHAR2 := fnd_api.g_miss_char
638 , p6_a84 VARCHAR2 := fnd_api.g_miss_char
639 , p6_a85 VARCHAR2 := fnd_api.g_miss_char
640 , p6_a86 VARCHAR2 := fnd_api.g_miss_char
641 , p6_a87 NUMBER := 0-1962.0724
642 , p6_a88 DATE := fnd_api.g_miss_date
643 , p6_a89 NUMBER := 0-1962.0724
644 , p6_a90 NUMBER := 0-1962.0724
645 , p6_a91 NUMBER := 0-1962.0724
646 , p6_a92 VARCHAR2 := fnd_api.g_miss_char
647 , p6_a93 NUMBER := 0-1962.0724
648 , p6_a94 VARCHAR2 := fnd_api.g_miss_char
649 , p6_a95 NUMBER := 0-1962.0724
650 , p6_a96 NUMBER := 0-1962.0724
651 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
652 , p6_a98 VARCHAR2 := fnd_api.g_miss_char
653 , p6_a99 VARCHAR2 := fnd_api.g_miss_char
654 , p6_a100 VARCHAR2 := fnd_api.g_miss_char
655 , p6_a101 VARCHAR2 := fnd_api.g_miss_char
656 , p6_a102 VARCHAR2 := fnd_api.g_miss_char
657 , p6_a103 NUMBER := 0-1962.0724
658 , p6_a104 NUMBER := 0-1962.0724
659 , p6_a105 NUMBER := 0-1962.0724
660 , p6_a106 VARCHAR2 := fnd_api.g_miss_char
661 , p6_a107 NUMBER := 0-1962.0724
662 , p6_a108 VARCHAR2 := fnd_api.g_miss_char
663 )
664
665 as
666 ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
667 ddindx binary_integer; indx binary_integer;
668 begin
669
670 -- copy data to the local IN or IN-OUT args, if any
671
672
673
674
675
676
677 ddp_listheader_rec.list_header_id := rosetta_g_miss_num_map(p6_a0);
678 ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
679 ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
680 ddp_listheader_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
681 ddp_listheader_rec.created_by := rosetta_g_miss_num_map(p6_a4);
682 ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
686 ddp_listheader_rec.program_application_id := rosetta_g_miss_num_map(p6_a9);
683 ddp_listheader_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
684 ddp_listheader_rec.request_id := rosetta_g_miss_num_map(p6_a7);
685 ddp_listheader_rec.program_id := rosetta_g_miss_num_map(p6_a8);
687 ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p6_a10);
688 ddp_listheader_rec.view_application_id := rosetta_g_miss_num_map(p6_a11);
689 ddp_listheader_rec.list_name := p6_a12;
690 ddp_listheader_rec.list_used_by_id := rosetta_g_miss_num_map(p6_a13);
691 ddp_listheader_rec.arc_list_used_by := p6_a14;
692 ddp_listheader_rec.list_type := p6_a15;
693 ddp_listheader_rec.status_code := p6_a16;
694 ddp_listheader_rec.status_date := rosetta_g_miss_date_in_map(p6_a17);
695 ddp_listheader_rec.generation_type := p6_a18;
696 ddp_listheader_rec.repeat_exclude_type := p6_a19;
697 ddp_listheader_rec.row_selection_type := p6_a20;
698 ddp_listheader_rec.owner_user_id := rosetta_g_miss_num_map(p6_a21);
699 ddp_listheader_rec.access_level := p6_a22;
700 ddp_listheader_rec.enable_log_flag := p6_a23;
701 ddp_listheader_rec.enable_word_replacement_flag := p6_a24;
702 ddp_listheader_rec.enable_parallel_dml_flag := p6_a25;
703 ddp_listheader_rec.dedupe_during_generation_flag := p6_a26;
704 ddp_listheader_rec.generate_control_group_flag := p6_a27;
705 ddp_listheader_rec.last_generation_success_flag := p6_a28;
706 ddp_listheader_rec.forecasted_start_date := rosetta_g_miss_date_in_map(p6_a29);
707 ddp_listheader_rec.forecasted_end_date := rosetta_g_miss_date_in_map(p6_a30);
708 ddp_listheader_rec.actual_end_date := rosetta_g_miss_date_in_map(p6_a31);
709 ddp_listheader_rec.sent_out_date := rosetta_g_miss_date_in_map(p6_a32);
710 ddp_listheader_rec.dedupe_start_date := rosetta_g_miss_date_in_map(p6_a33);
711 ddp_listheader_rec.last_dedupe_date := rosetta_g_miss_date_in_map(p6_a34);
712 ddp_listheader_rec.last_deduped_by_user_id := rosetta_g_miss_num_map(p6_a35);
713 ddp_listheader_rec.workflow_item_key := rosetta_g_miss_num_map(p6_a36);
714 ddp_listheader_rec.no_of_rows_duplicates := rosetta_g_miss_num_map(p6_a37);
715 ddp_listheader_rec.no_of_rows_min_requested := rosetta_g_miss_num_map(p6_a38);
716 ddp_listheader_rec.no_of_rows_max_requested := rosetta_g_miss_num_map(p6_a39);
717 ddp_listheader_rec.no_of_rows_in_list := rosetta_g_miss_num_map(p6_a40);
718 ddp_listheader_rec.no_of_rows_in_ctrl_group := rosetta_g_miss_num_map(p6_a41);
719 ddp_listheader_rec.no_of_rows_active := rosetta_g_miss_num_map(p6_a42);
720 ddp_listheader_rec.no_of_rows_inactive := rosetta_g_miss_num_map(p6_a43);
721 ddp_listheader_rec.no_of_rows_manually_entered := rosetta_g_miss_num_map(p6_a44);
722 ddp_listheader_rec.no_of_rows_do_not_call := rosetta_g_miss_num_map(p6_a45);
723 ddp_listheader_rec.no_of_rows_do_not_mail := rosetta_g_miss_num_map(p6_a46);
724 ddp_listheader_rec.no_of_rows_random := rosetta_g_miss_num_map(p6_a47);
725 ddp_listheader_rec.org_id := rosetta_g_miss_num_map(p6_a48);
726 ddp_listheader_rec.main_gen_start_time := rosetta_g_miss_date_in_map(p6_a49);
727 ddp_listheader_rec.main_gen_end_time := rosetta_g_miss_date_in_map(p6_a50);
728 ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p6_a51);
729 ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p6_a52);
730 ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p6_a53);
731 ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p6_a54);
732 ddp_listheader_rec.repeat_source_list_header_id := p6_a55;
733 ddp_listheader_rec.result_text := p6_a56;
734 ddp_listheader_rec.keywords := p6_a57;
735 ddp_listheader_rec.description := p6_a58;
736 ddp_listheader_rec.list_priority := rosetta_g_miss_num_map(p6_a59);
737 ddp_listheader_rec.assign_person_id := rosetta_g_miss_num_map(p6_a60);
738 ddp_listheader_rec.list_source := p6_a61;
739 ddp_listheader_rec.list_source_type := p6_a62;
740 ddp_listheader_rec.list_online_flag := p6_a63;
741 ddp_listheader_rec.random_list_id := rosetta_g_miss_num_map(p6_a64);
742 ddp_listheader_rec.enabled_flag := p6_a65;
743 ddp_listheader_rec.assigned_to := rosetta_g_miss_num_map(p6_a66);
744 ddp_listheader_rec.query_id := rosetta_g_miss_num_map(p6_a67);
745 ddp_listheader_rec.owner_person_id := rosetta_g_miss_num_map(p6_a68);
746 ddp_listheader_rec.archived_by := rosetta_g_miss_num_map(p6_a69);
747 ddp_listheader_rec.archived_date := rosetta_g_miss_date_in_map(p6_a70);
748 ddp_listheader_rec.attribute_category := p6_a71;
749 ddp_listheader_rec.attribute1 := p6_a72;
750 ddp_listheader_rec.attribute2 := p6_a73;
751 ddp_listheader_rec.attribute3 := p6_a74;
752 ddp_listheader_rec.attribute4 := p6_a75;
753 ddp_listheader_rec.attribute5 := p6_a76;
754 ddp_listheader_rec.attribute6 := p6_a77;
755 ddp_listheader_rec.attribute7 := p6_a78;
756 ddp_listheader_rec.attribute8 := p6_a79;
757 ddp_listheader_rec.attribute9 := p6_a80;
758 ddp_listheader_rec.attribute10 := p6_a81;
759 ddp_listheader_rec.attribute11 := p6_a82;
760 ddp_listheader_rec.attribute12 := p6_a83;
761 ddp_listheader_rec.attribute13 := p6_a84;
762 ddp_listheader_rec.attribute14 := p6_a85;
763 ddp_listheader_rec.attribute15 := p6_a86;
764 ddp_listheader_rec.timezone_id := rosetta_g_miss_num_map(p6_a87);
765 ddp_listheader_rec.user_entered_start_time := rosetta_g_miss_date_in_map(p6_a88);
766 ddp_listheader_rec.user_status_id := rosetta_g_miss_num_map(p6_a89);
767 ddp_listheader_rec.quantum := rosetta_g_miss_num_map(p6_a90);
771 ddp_listheader_rec.release_strategy := p6_a94;
768 ddp_listheader_rec.release_control_alg_id := rosetta_g_miss_num_map(p6_a91);
769 ddp_listheader_rec.dialing_method := p6_a92;
770 ddp_listheader_rec.calling_calendar_id := rosetta_g_miss_num_map(p6_a93);
772 ddp_listheader_rec.custom_setup_id := rosetta_g_miss_num_map(p6_a95);
773 ddp_listheader_rec.country := rosetta_g_miss_num_map(p6_a96);
774 ddp_listheader_rec.callback_priority_flag := p6_a97;
775 ddp_listheader_rec.call_center_ready_flag := p6_a98;
776 ddp_listheader_rec.language := p6_a99;
777 ddp_listheader_rec.purge_flag := p6_a100;
778 ddp_listheader_rec.public_flag := p6_a101;
779 ddp_listheader_rec.list_category := p6_a102;
780 ddp_listheader_rec.quota := rosetta_g_miss_num_map(p6_a103);
781 ddp_listheader_rec.quota_reset := rosetta_g_miss_num_map(p6_a104);
782 ddp_listheader_rec.recycling_alg_id := rosetta_g_miss_num_map(p6_a105);
783 ddp_listheader_rec.source_lang := p6_a106;
784 ddp_listheader_rec.no_of_rows_prev_contacted := rosetta_g_miss_num_map(p6_a107);
785 ddp_listheader_rec.apply_traffic_cop := p6_a108;
786
787 -- here's the delegated call to the old PL/SQL routine
788 ams_listheader_pvt.validate_listheader(p_api_version,
789 p_init_msg_list,
790 p_validation_level,
791 x_return_status,
792 x_msg_count,
793 x_msg_data,
794 ddp_listheader_rec);
795
796 -- copy data back from the local variables to OUT or IN-OUT args, if any
797
798
799
800
801
802
803 end;
804
805 procedure validate_list_items(p_validation_mode VARCHAR2
806 , x_return_status out nocopy VARCHAR2
807 , p0_a0 NUMBER := 0-1962.0724
808 , p0_a1 DATE := fnd_api.g_miss_date
809 , p0_a2 NUMBER := 0-1962.0724
810 , p0_a3 DATE := fnd_api.g_miss_date
811 , p0_a4 NUMBER := 0-1962.0724
812 , p0_a5 NUMBER := 0-1962.0724
813 , p0_a6 NUMBER := 0-1962.0724
814 , p0_a7 NUMBER := 0-1962.0724
815 , p0_a8 NUMBER := 0-1962.0724
816 , p0_a9 NUMBER := 0-1962.0724
817 , p0_a10 DATE := fnd_api.g_miss_date
818 , p0_a11 NUMBER := 0-1962.0724
819 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
820 , p0_a13 NUMBER := 0-1962.0724
821 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
822 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
823 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
824 , p0_a17 DATE := fnd_api.g_miss_date
825 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
826 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
827 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
828 , p0_a21 NUMBER := 0-1962.0724
829 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
830 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
831 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
832 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
833 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
834 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
835 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
836 , p0_a29 DATE := fnd_api.g_miss_date
837 , p0_a30 DATE := fnd_api.g_miss_date
838 , p0_a31 DATE := fnd_api.g_miss_date
839 , p0_a32 DATE := fnd_api.g_miss_date
840 , p0_a33 DATE := fnd_api.g_miss_date
841 , p0_a34 DATE := fnd_api.g_miss_date
842 , p0_a35 NUMBER := 0-1962.0724
843 , p0_a36 NUMBER := 0-1962.0724
844 , p0_a37 NUMBER := 0-1962.0724
845 , p0_a38 NUMBER := 0-1962.0724
846 , p0_a39 NUMBER := 0-1962.0724
847 , p0_a40 NUMBER := 0-1962.0724
848 , p0_a41 NUMBER := 0-1962.0724
849 , p0_a42 NUMBER := 0-1962.0724
850 , p0_a43 NUMBER := 0-1962.0724
851 , p0_a44 NUMBER := 0-1962.0724
852 , p0_a45 NUMBER := 0-1962.0724
853 , p0_a46 NUMBER := 0-1962.0724
854 , p0_a47 NUMBER := 0-1962.0724
855 , p0_a48 NUMBER := 0-1962.0724
856 , p0_a49 DATE := fnd_api.g_miss_date
857 , p0_a50 DATE := fnd_api.g_miss_date
858 , p0_a51 NUMBER := 0-1962.0724
859 , p0_a52 NUMBER := 0-1962.0724
860 , p0_a53 NUMBER := 0-1962.0724
861 , p0_a54 NUMBER := 0-1962.0724
862 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
863 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
864 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
865 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
866 , p0_a59 NUMBER := 0-1962.0724
867 , p0_a60 NUMBER := 0-1962.0724
868 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
869 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
870 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
871 , p0_a64 NUMBER := 0-1962.0724
872 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
873 , p0_a66 NUMBER := 0-1962.0724
874 , p0_a67 NUMBER := 0-1962.0724
875 , p0_a68 NUMBER := 0-1962.0724
876 , p0_a69 NUMBER := 0-1962.0724
877 , p0_a70 DATE := fnd_api.g_miss_date
878 , p0_a71 VARCHAR2 := fnd_api.g_miss_char
879 , p0_a72 VARCHAR2 := fnd_api.g_miss_char
880 , p0_a73 VARCHAR2 := fnd_api.g_miss_char
881 , p0_a74 VARCHAR2 := fnd_api.g_miss_char
882 , p0_a75 VARCHAR2 := fnd_api.g_miss_char
883 , p0_a76 VARCHAR2 := fnd_api.g_miss_char
884 , p0_a77 VARCHAR2 := fnd_api.g_miss_char
885 , p0_a78 VARCHAR2 := fnd_api.g_miss_char
886 , p0_a79 VARCHAR2 := fnd_api.g_miss_char
887 , p0_a80 VARCHAR2 := fnd_api.g_miss_char
888 , p0_a81 VARCHAR2 := fnd_api.g_miss_char
889 , p0_a82 VARCHAR2 := fnd_api.g_miss_char
893 , p0_a86 VARCHAR2 := fnd_api.g_miss_char
890 , p0_a83 VARCHAR2 := fnd_api.g_miss_char
891 , p0_a84 VARCHAR2 := fnd_api.g_miss_char
892 , p0_a85 VARCHAR2 := fnd_api.g_miss_char
894 , p0_a87 NUMBER := 0-1962.0724
895 , p0_a88 DATE := fnd_api.g_miss_date
896 , p0_a89 NUMBER := 0-1962.0724
897 , p0_a90 NUMBER := 0-1962.0724
898 , p0_a91 NUMBER := 0-1962.0724
899 , p0_a92 VARCHAR2 := fnd_api.g_miss_char
900 , p0_a93 NUMBER := 0-1962.0724
901 , p0_a94 VARCHAR2 := fnd_api.g_miss_char
902 , p0_a95 NUMBER := 0-1962.0724
903 , p0_a96 NUMBER := 0-1962.0724
904 , p0_a97 VARCHAR2 := fnd_api.g_miss_char
905 , p0_a98 VARCHAR2 := fnd_api.g_miss_char
906 , p0_a99 VARCHAR2 := fnd_api.g_miss_char
907 , p0_a100 VARCHAR2 := fnd_api.g_miss_char
908 , p0_a101 VARCHAR2 := fnd_api.g_miss_char
909 , p0_a102 VARCHAR2 := fnd_api.g_miss_char
910 , p0_a103 NUMBER := 0-1962.0724
911 , p0_a104 NUMBER := 0-1962.0724
912 , p0_a105 NUMBER := 0-1962.0724
913 , p0_a106 VARCHAR2 := fnd_api.g_miss_char
914 , p0_a107 NUMBER := 0-1962.0724
915 , p0_a108 VARCHAR2 := fnd_api.g_miss_char
916 )
917
918 as
919 ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
920 ddindx binary_integer; indx binary_integer;
921 begin
922
923 -- copy data to the local IN or IN-OUT args, if any
924 ddp_listheader_rec.list_header_id := rosetta_g_miss_num_map(p0_a0);
925 ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
926 ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
927 ddp_listheader_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
928 ddp_listheader_rec.created_by := rosetta_g_miss_num_map(p0_a4);
929 ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
930 ddp_listheader_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
931 ddp_listheader_rec.request_id := rosetta_g_miss_num_map(p0_a7);
932 ddp_listheader_rec.program_id := rosetta_g_miss_num_map(p0_a8);
933 ddp_listheader_rec.program_application_id := rosetta_g_miss_num_map(p0_a9);
934 ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a10);
935 ddp_listheader_rec.view_application_id := rosetta_g_miss_num_map(p0_a11);
936 ddp_listheader_rec.list_name := p0_a12;
937 ddp_listheader_rec.list_used_by_id := rosetta_g_miss_num_map(p0_a13);
938 ddp_listheader_rec.arc_list_used_by := p0_a14;
939 ddp_listheader_rec.list_type := p0_a15;
940 ddp_listheader_rec.status_code := p0_a16;
941 ddp_listheader_rec.status_date := rosetta_g_miss_date_in_map(p0_a17);
942 ddp_listheader_rec.generation_type := p0_a18;
943 ddp_listheader_rec.repeat_exclude_type := p0_a19;
944 ddp_listheader_rec.row_selection_type := p0_a20;
945 ddp_listheader_rec.owner_user_id := rosetta_g_miss_num_map(p0_a21);
946 ddp_listheader_rec.access_level := p0_a22;
947 ddp_listheader_rec.enable_log_flag := p0_a23;
948 ddp_listheader_rec.enable_word_replacement_flag := p0_a24;
949 ddp_listheader_rec.enable_parallel_dml_flag := p0_a25;
950 ddp_listheader_rec.dedupe_during_generation_flag := p0_a26;
951 ddp_listheader_rec.generate_control_group_flag := p0_a27;
952 ddp_listheader_rec.last_generation_success_flag := p0_a28;
953 ddp_listheader_rec.forecasted_start_date := rosetta_g_miss_date_in_map(p0_a29);
954 ddp_listheader_rec.forecasted_end_date := rosetta_g_miss_date_in_map(p0_a30);
955 ddp_listheader_rec.actual_end_date := rosetta_g_miss_date_in_map(p0_a31);
956 ddp_listheader_rec.sent_out_date := rosetta_g_miss_date_in_map(p0_a32);
957 ddp_listheader_rec.dedupe_start_date := rosetta_g_miss_date_in_map(p0_a33);
958 ddp_listheader_rec.last_dedupe_date := rosetta_g_miss_date_in_map(p0_a34);
959 ddp_listheader_rec.last_deduped_by_user_id := rosetta_g_miss_num_map(p0_a35);
960 ddp_listheader_rec.workflow_item_key := rosetta_g_miss_num_map(p0_a36);
961 ddp_listheader_rec.no_of_rows_duplicates := rosetta_g_miss_num_map(p0_a37);
962 ddp_listheader_rec.no_of_rows_min_requested := rosetta_g_miss_num_map(p0_a38);
963 ddp_listheader_rec.no_of_rows_max_requested := rosetta_g_miss_num_map(p0_a39);
964 ddp_listheader_rec.no_of_rows_in_list := rosetta_g_miss_num_map(p0_a40);
965 ddp_listheader_rec.no_of_rows_in_ctrl_group := rosetta_g_miss_num_map(p0_a41);
966 ddp_listheader_rec.no_of_rows_active := rosetta_g_miss_num_map(p0_a42);
967 ddp_listheader_rec.no_of_rows_inactive := rosetta_g_miss_num_map(p0_a43);
968 ddp_listheader_rec.no_of_rows_manually_entered := rosetta_g_miss_num_map(p0_a44);
969 ddp_listheader_rec.no_of_rows_do_not_call := rosetta_g_miss_num_map(p0_a45);
970 ddp_listheader_rec.no_of_rows_do_not_mail := rosetta_g_miss_num_map(p0_a46);
971 ddp_listheader_rec.no_of_rows_random := rosetta_g_miss_num_map(p0_a47);
972 ddp_listheader_rec.org_id := rosetta_g_miss_num_map(p0_a48);
973 ddp_listheader_rec.main_gen_start_time := rosetta_g_miss_date_in_map(p0_a49);
974 ddp_listheader_rec.main_gen_end_time := rosetta_g_miss_date_in_map(p0_a50);
975 ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p0_a51);
976 ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p0_a52);
977 ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p0_a53);
978 ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p0_a54);
979 ddp_listheader_rec.repeat_source_list_header_id := p0_a55;
980 ddp_listheader_rec.result_text := p0_a56;
981 ddp_listheader_rec.keywords := p0_a57;
982 ddp_listheader_rec.description := p0_a58;
986 ddp_listheader_rec.list_source_type := p0_a62;
983 ddp_listheader_rec.list_priority := rosetta_g_miss_num_map(p0_a59);
984 ddp_listheader_rec.assign_person_id := rosetta_g_miss_num_map(p0_a60);
985 ddp_listheader_rec.list_source := p0_a61;
987 ddp_listheader_rec.list_online_flag := p0_a63;
988 ddp_listheader_rec.random_list_id := rosetta_g_miss_num_map(p0_a64);
989 ddp_listheader_rec.enabled_flag := p0_a65;
990 ddp_listheader_rec.assigned_to := rosetta_g_miss_num_map(p0_a66);
991 ddp_listheader_rec.query_id := rosetta_g_miss_num_map(p0_a67);
992 ddp_listheader_rec.owner_person_id := rosetta_g_miss_num_map(p0_a68);
993 ddp_listheader_rec.archived_by := rosetta_g_miss_num_map(p0_a69);
994 ddp_listheader_rec.archived_date := rosetta_g_miss_date_in_map(p0_a70);
995 ddp_listheader_rec.attribute_category := p0_a71;
996 ddp_listheader_rec.attribute1 := p0_a72;
997 ddp_listheader_rec.attribute2 := p0_a73;
998 ddp_listheader_rec.attribute3 := p0_a74;
999 ddp_listheader_rec.attribute4 := p0_a75;
1000 ddp_listheader_rec.attribute5 := p0_a76;
1001 ddp_listheader_rec.attribute6 := p0_a77;
1002 ddp_listheader_rec.attribute7 := p0_a78;
1003 ddp_listheader_rec.attribute8 := p0_a79;
1004 ddp_listheader_rec.attribute9 := p0_a80;
1005 ddp_listheader_rec.attribute10 := p0_a81;
1006 ddp_listheader_rec.attribute11 := p0_a82;
1007 ddp_listheader_rec.attribute12 := p0_a83;
1008 ddp_listheader_rec.attribute13 := p0_a84;
1009 ddp_listheader_rec.attribute14 := p0_a85;
1010 ddp_listheader_rec.attribute15 := p0_a86;
1011 ddp_listheader_rec.timezone_id := rosetta_g_miss_num_map(p0_a87);
1012 ddp_listheader_rec.user_entered_start_time := rosetta_g_miss_date_in_map(p0_a88);
1013 ddp_listheader_rec.user_status_id := rosetta_g_miss_num_map(p0_a89);
1014 ddp_listheader_rec.quantum := rosetta_g_miss_num_map(p0_a90);
1015 ddp_listheader_rec.release_control_alg_id := rosetta_g_miss_num_map(p0_a91);
1016 ddp_listheader_rec.dialing_method := p0_a92;
1017 ddp_listheader_rec.calling_calendar_id := rosetta_g_miss_num_map(p0_a93);
1018 ddp_listheader_rec.release_strategy := p0_a94;
1019 ddp_listheader_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a95);
1020 ddp_listheader_rec.country := rosetta_g_miss_num_map(p0_a96);
1021 ddp_listheader_rec.callback_priority_flag := p0_a97;
1022 ddp_listheader_rec.call_center_ready_flag := p0_a98;
1023 ddp_listheader_rec.language := p0_a99;
1024 ddp_listheader_rec.purge_flag := p0_a100;
1025 ddp_listheader_rec.public_flag := p0_a101;
1026 ddp_listheader_rec.list_category := p0_a102;
1027 ddp_listheader_rec.quota := rosetta_g_miss_num_map(p0_a103);
1028 ddp_listheader_rec.quota_reset := rosetta_g_miss_num_map(p0_a104);
1029 ddp_listheader_rec.recycling_alg_id := rosetta_g_miss_num_map(p0_a105);
1030 ddp_listheader_rec.source_lang := p0_a106;
1031 ddp_listheader_rec.no_of_rows_prev_contacted := rosetta_g_miss_num_map(p0_a107);
1032 ddp_listheader_rec.apply_traffic_cop := p0_a108;
1033
1034
1035
1036 -- here's the delegated call to the old PL/SQL routine
1037 ams_listheader_pvt.validate_list_items(ddp_listheader_rec,
1038 p_validation_mode,
1039 x_return_status);
1040
1041 -- copy data back from the local variables to OUT or IN-OUT args, if any
1042
1043
1044 end;
1045
1046 procedure validate_list_record(x_return_status out nocopy VARCHAR2
1047 , p0_a0 NUMBER := 0-1962.0724
1048 , p0_a1 DATE := fnd_api.g_miss_date
1049 , p0_a2 NUMBER := 0-1962.0724
1050 , p0_a3 DATE := fnd_api.g_miss_date
1051 , p0_a4 NUMBER := 0-1962.0724
1052 , p0_a5 NUMBER := 0-1962.0724
1053 , p0_a6 NUMBER := 0-1962.0724
1054 , p0_a7 NUMBER := 0-1962.0724
1055 , p0_a8 NUMBER := 0-1962.0724
1056 , p0_a9 NUMBER := 0-1962.0724
1057 , p0_a10 DATE := fnd_api.g_miss_date
1058 , p0_a11 NUMBER := 0-1962.0724
1059 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
1060 , p0_a13 NUMBER := 0-1962.0724
1061 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1062 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1063 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1064 , p0_a17 DATE := fnd_api.g_miss_date
1065 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1066 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1067 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1068 , p0_a21 NUMBER := 0-1962.0724
1069 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1070 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1071 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1072 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
1073 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
1074 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1075 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1076 , p0_a29 DATE := fnd_api.g_miss_date
1077 , p0_a30 DATE := fnd_api.g_miss_date
1078 , p0_a31 DATE := fnd_api.g_miss_date
1079 , p0_a32 DATE := fnd_api.g_miss_date
1080 , p0_a33 DATE := fnd_api.g_miss_date
1081 , p0_a34 DATE := fnd_api.g_miss_date
1082 , p0_a35 NUMBER := 0-1962.0724
1083 , p0_a36 NUMBER := 0-1962.0724
1084 , p0_a37 NUMBER := 0-1962.0724
1085 , p0_a38 NUMBER := 0-1962.0724
1086 , p0_a39 NUMBER := 0-1962.0724
1087 , p0_a40 NUMBER := 0-1962.0724
1088 , p0_a41 NUMBER := 0-1962.0724
1089 , p0_a42 NUMBER := 0-1962.0724
1090 , p0_a43 NUMBER := 0-1962.0724
1091 , p0_a44 NUMBER := 0-1962.0724
1092 , p0_a45 NUMBER := 0-1962.0724
1093 , p0_a46 NUMBER := 0-1962.0724
1094 , p0_a47 NUMBER := 0-1962.0724
1095 , p0_a48 NUMBER := 0-1962.0724
1099 , p0_a52 NUMBER := 0-1962.0724
1096 , p0_a49 DATE := fnd_api.g_miss_date
1097 , p0_a50 DATE := fnd_api.g_miss_date
1098 , p0_a51 NUMBER := 0-1962.0724
1100 , p0_a53 NUMBER := 0-1962.0724
1101 , p0_a54 NUMBER := 0-1962.0724
1102 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1103 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1104 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
1105 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
1106 , p0_a59 NUMBER := 0-1962.0724
1107 , p0_a60 NUMBER := 0-1962.0724
1108 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
1109 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
1110 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
1111 , p0_a64 NUMBER := 0-1962.0724
1112 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
1113 , p0_a66 NUMBER := 0-1962.0724
1114 , p0_a67 NUMBER := 0-1962.0724
1115 , p0_a68 NUMBER := 0-1962.0724
1116 , p0_a69 NUMBER := 0-1962.0724
1117 , p0_a70 DATE := fnd_api.g_miss_date
1118 , p0_a71 VARCHAR2 := fnd_api.g_miss_char
1119 , p0_a72 VARCHAR2 := fnd_api.g_miss_char
1120 , p0_a73 VARCHAR2 := fnd_api.g_miss_char
1121 , p0_a74 VARCHAR2 := fnd_api.g_miss_char
1122 , p0_a75 VARCHAR2 := fnd_api.g_miss_char
1123 , p0_a76 VARCHAR2 := fnd_api.g_miss_char
1124 , p0_a77 VARCHAR2 := fnd_api.g_miss_char
1125 , p0_a78 VARCHAR2 := fnd_api.g_miss_char
1126 , p0_a79 VARCHAR2 := fnd_api.g_miss_char
1127 , p0_a80 VARCHAR2 := fnd_api.g_miss_char
1128 , p0_a81 VARCHAR2 := fnd_api.g_miss_char
1129 , p0_a82 VARCHAR2 := fnd_api.g_miss_char
1130 , p0_a83 VARCHAR2 := fnd_api.g_miss_char
1131 , p0_a84 VARCHAR2 := fnd_api.g_miss_char
1132 , p0_a85 VARCHAR2 := fnd_api.g_miss_char
1133 , p0_a86 VARCHAR2 := fnd_api.g_miss_char
1134 , p0_a87 NUMBER := 0-1962.0724
1135 , p0_a88 DATE := fnd_api.g_miss_date
1136 , p0_a89 NUMBER := 0-1962.0724
1137 , p0_a90 NUMBER := 0-1962.0724
1138 , p0_a91 NUMBER := 0-1962.0724
1139 , p0_a92 VARCHAR2 := fnd_api.g_miss_char
1140 , p0_a93 NUMBER := 0-1962.0724
1141 , p0_a94 VARCHAR2 := fnd_api.g_miss_char
1142 , p0_a95 NUMBER := 0-1962.0724
1143 , p0_a96 NUMBER := 0-1962.0724
1144 , p0_a97 VARCHAR2 := fnd_api.g_miss_char
1145 , p0_a98 VARCHAR2 := fnd_api.g_miss_char
1146 , p0_a99 VARCHAR2 := fnd_api.g_miss_char
1147 , p0_a100 VARCHAR2 := fnd_api.g_miss_char
1148 , p0_a101 VARCHAR2 := fnd_api.g_miss_char
1149 , p0_a102 VARCHAR2 := fnd_api.g_miss_char
1150 , p0_a103 NUMBER := 0-1962.0724
1151 , p0_a104 NUMBER := 0-1962.0724
1152 , p0_a105 NUMBER := 0-1962.0724
1153 , p0_a106 VARCHAR2 := fnd_api.g_miss_char
1154 , p0_a107 NUMBER := 0-1962.0724
1155 , p0_a108 VARCHAR2 := fnd_api.g_miss_char
1156 , p1_a0 NUMBER := 0-1962.0724
1157 , p1_a1 DATE := fnd_api.g_miss_date
1158 , p1_a2 NUMBER := 0-1962.0724
1159 , p1_a3 DATE := fnd_api.g_miss_date
1160 , p1_a4 NUMBER := 0-1962.0724
1161 , p1_a5 NUMBER := 0-1962.0724
1162 , p1_a6 NUMBER := 0-1962.0724
1163 , p1_a7 NUMBER := 0-1962.0724
1164 , p1_a8 NUMBER := 0-1962.0724
1165 , p1_a9 NUMBER := 0-1962.0724
1166 , p1_a10 DATE := fnd_api.g_miss_date
1167 , p1_a11 NUMBER := 0-1962.0724
1168 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
1169 , p1_a13 NUMBER := 0-1962.0724
1170 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
1171 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
1172 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
1173 , p1_a17 DATE := fnd_api.g_miss_date
1174 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
1175 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
1176 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
1177 , p1_a21 NUMBER := 0-1962.0724
1178 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
1179 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
1180 , p1_a24 VARCHAR2 := fnd_api.g_miss_char
1181 , p1_a25 VARCHAR2 := fnd_api.g_miss_char
1182 , p1_a26 VARCHAR2 := fnd_api.g_miss_char
1183 , p1_a27 VARCHAR2 := fnd_api.g_miss_char
1184 , p1_a28 VARCHAR2 := fnd_api.g_miss_char
1185 , p1_a29 DATE := fnd_api.g_miss_date
1186 , p1_a30 DATE := fnd_api.g_miss_date
1187 , p1_a31 DATE := fnd_api.g_miss_date
1188 , p1_a32 DATE := fnd_api.g_miss_date
1189 , p1_a33 DATE := fnd_api.g_miss_date
1190 , p1_a34 DATE := fnd_api.g_miss_date
1191 , p1_a35 NUMBER := 0-1962.0724
1192 , p1_a36 NUMBER := 0-1962.0724
1193 , p1_a37 NUMBER := 0-1962.0724
1194 , p1_a38 NUMBER := 0-1962.0724
1195 , p1_a39 NUMBER := 0-1962.0724
1196 , p1_a40 NUMBER := 0-1962.0724
1197 , p1_a41 NUMBER := 0-1962.0724
1198 , p1_a42 NUMBER := 0-1962.0724
1199 , p1_a43 NUMBER := 0-1962.0724
1200 , p1_a44 NUMBER := 0-1962.0724
1201 , p1_a45 NUMBER := 0-1962.0724
1202 , p1_a46 NUMBER := 0-1962.0724
1203 , p1_a47 NUMBER := 0-1962.0724
1204 , p1_a48 NUMBER := 0-1962.0724
1205 , p1_a49 DATE := fnd_api.g_miss_date
1206 , p1_a50 DATE := fnd_api.g_miss_date
1207 , p1_a51 NUMBER := 0-1962.0724
1208 , p1_a52 NUMBER := 0-1962.0724
1209 , p1_a53 NUMBER := 0-1962.0724
1210 , p1_a54 NUMBER := 0-1962.0724
1211 , p1_a55 VARCHAR2 := fnd_api.g_miss_char
1212 , p1_a56 VARCHAR2 := fnd_api.g_miss_char
1213 , p1_a57 VARCHAR2 := fnd_api.g_miss_char
1214 , p1_a58 VARCHAR2 := fnd_api.g_miss_char
1215 , p1_a59 NUMBER := 0-1962.0724
1216 , p1_a60 NUMBER := 0-1962.0724
1217 , p1_a61 VARCHAR2 := fnd_api.g_miss_char
1221 , p1_a65 VARCHAR2 := fnd_api.g_miss_char
1218 , p1_a62 VARCHAR2 := fnd_api.g_miss_char
1219 , p1_a63 VARCHAR2 := fnd_api.g_miss_char
1220 , p1_a64 NUMBER := 0-1962.0724
1222 , p1_a66 NUMBER := 0-1962.0724
1223 , p1_a67 NUMBER := 0-1962.0724
1224 , p1_a68 NUMBER := 0-1962.0724
1225 , p1_a69 NUMBER := 0-1962.0724
1226 , p1_a70 DATE := fnd_api.g_miss_date
1227 , p1_a71 VARCHAR2 := fnd_api.g_miss_char
1228 , p1_a72 VARCHAR2 := fnd_api.g_miss_char
1229 , p1_a73 VARCHAR2 := fnd_api.g_miss_char
1230 , p1_a74 VARCHAR2 := fnd_api.g_miss_char
1231 , p1_a75 VARCHAR2 := fnd_api.g_miss_char
1232 , p1_a76 VARCHAR2 := fnd_api.g_miss_char
1233 , p1_a77 VARCHAR2 := fnd_api.g_miss_char
1234 , p1_a78 VARCHAR2 := fnd_api.g_miss_char
1235 , p1_a79 VARCHAR2 := fnd_api.g_miss_char
1236 , p1_a80 VARCHAR2 := fnd_api.g_miss_char
1237 , p1_a81 VARCHAR2 := fnd_api.g_miss_char
1238 , p1_a82 VARCHAR2 := fnd_api.g_miss_char
1239 , p1_a83 VARCHAR2 := fnd_api.g_miss_char
1240 , p1_a84 VARCHAR2 := fnd_api.g_miss_char
1241 , p1_a85 VARCHAR2 := fnd_api.g_miss_char
1242 , p1_a86 VARCHAR2 := fnd_api.g_miss_char
1243 , p1_a87 NUMBER := 0-1962.0724
1244 , p1_a88 DATE := fnd_api.g_miss_date
1245 , p1_a89 NUMBER := 0-1962.0724
1246 , p1_a90 NUMBER := 0-1962.0724
1247 , p1_a91 NUMBER := 0-1962.0724
1248 , p1_a92 VARCHAR2 := fnd_api.g_miss_char
1249 , p1_a93 NUMBER := 0-1962.0724
1250 , p1_a94 VARCHAR2 := fnd_api.g_miss_char
1251 , p1_a95 NUMBER := 0-1962.0724
1252 , p1_a96 NUMBER := 0-1962.0724
1253 , p1_a97 VARCHAR2 := fnd_api.g_miss_char
1254 , p1_a98 VARCHAR2 := fnd_api.g_miss_char
1255 , p1_a99 VARCHAR2 := fnd_api.g_miss_char
1256 , p1_a100 VARCHAR2 := fnd_api.g_miss_char
1257 , p1_a101 VARCHAR2 := fnd_api.g_miss_char
1258 , p1_a102 VARCHAR2 := fnd_api.g_miss_char
1259 , p1_a103 NUMBER := 0-1962.0724
1260 , p1_a104 NUMBER := 0-1962.0724
1261 , p1_a105 NUMBER := 0-1962.0724
1262 , p1_a106 VARCHAR2 := fnd_api.g_miss_char
1263 , p1_a107 NUMBER := 0-1962.0724
1264 , p1_a108 VARCHAR2 := fnd_api.g_miss_char
1265 )
1266
1267 as
1268 ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
1269 ddp_complete_rec ams_listheader_pvt.list_header_rec_type;
1270 ddindx binary_integer; indx binary_integer;
1271 begin
1272
1273 -- copy data to the local IN or IN-OUT args, if any
1274 ddp_listheader_rec.list_header_id := rosetta_g_miss_num_map(p0_a0);
1275 ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1276 ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1277 ddp_listheader_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1278 ddp_listheader_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1279 ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1280 ddp_listheader_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1281 ddp_listheader_rec.request_id := rosetta_g_miss_num_map(p0_a7);
1282 ddp_listheader_rec.program_id := rosetta_g_miss_num_map(p0_a8);
1283 ddp_listheader_rec.program_application_id := rosetta_g_miss_num_map(p0_a9);
1284 ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a10);
1285 ddp_listheader_rec.view_application_id := rosetta_g_miss_num_map(p0_a11);
1286 ddp_listheader_rec.list_name := p0_a12;
1287 ddp_listheader_rec.list_used_by_id := rosetta_g_miss_num_map(p0_a13);
1288 ddp_listheader_rec.arc_list_used_by := p0_a14;
1289 ddp_listheader_rec.list_type := p0_a15;
1290 ddp_listheader_rec.status_code := p0_a16;
1291 ddp_listheader_rec.status_date := rosetta_g_miss_date_in_map(p0_a17);
1292 ddp_listheader_rec.generation_type := p0_a18;
1293 ddp_listheader_rec.repeat_exclude_type := p0_a19;
1294 ddp_listheader_rec.row_selection_type := p0_a20;
1295 ddp_listheader_rec.owner_user_id := rosetta_g_miss_num_map(p0_a21);
1296 ddp_listheader_rec.access_level := p0_a22;
1297 ddp_listheader_rec.enable_log_flag := p0_a23;
1298 ddp_listheader_rec.enable_word_replacement_flag := p0_a24;
1299 ddp_listheader_rec.enable_parallel_dml_flag := p0_a25;
1300 ddp_listheader_rec.dedupe_during_generation_flag := p0_a26;
1301 ddp_listheader_rec.generate_control_group_flag := p0_a27;
1302 ddp_listheader_rec.last_generation_success_flag := p0_a28;
1303 ddp_listheader_rec.forecasted_start_date := rosetta_g_miss_date_in_map(p0_a29);
1304 ddp_listheader_rec.forecasted_end_date := rosetta_g_miss_date_in_map(p0_a30);
1305 ddp_listheader_rec.actual_end_date := rosetta_g_miss_date_in_map(p0_a31);
1306 ddp_listheader_rec.sent_out_date := rosetta_g_miss_date_in_map(p0_a32);
1307 ddp_listheader_rec.dedupe_start_date := rosetta_g_miss_date_in_map(p0_a33);
1308 ddp_listheader_rec.last_dedupe_date := rosetta_g_miss_date_in_map(p0_a34);
1309 ddp_listheader_rec.last_deduped_by_user_id := rosetta_g_miss_num_map(p0_a35);
1310 ddp_listheader_rec.workflow_item_key := rosetta_g_miss_num_map(p0_a36);
1311 ddp_listheader_rec.no_of_rows_duplicates := rosetta_g_miss_num_map(p0_a37);
1312 ddp_listheader_rec.no_of_rows_min_requested := rosetta_g_miss_num_map(p0_a38);
1313 ddp_listheader_rec.no_of_rows_max_requested := rosetta_g_miss_num_map(p0_a39);
1314 ddp_listheader_rec.no_of_rows_in_list := rosetta_g_miss_num_map(p0_a40);
1315 ddp_listheader_rec.no_of_rows_in_ctrl_group := rosetta_g_miss_num_map(p0_a41);
1316 ddp_listheader_rec.no_of_rows_active := rosetta_g_miss_num_map(p0_a42);
1320 ddp_listheader_rec.no_of_rows_do_not_mail := rosetta_g_miss_num_map(p0_a46);
1317 ddp_listheader_rec.no_of_rows_inactive := rosetta_g_miss_num_map(p0_a43);
1318 ddp_listheader_rec.no_of_rows_manually_entered := rosetta_g_miss_num_map(p0_a44);
1319 ddp_listheader_rec.no_of_rows_do_not_call := rosetta_g_miss_num_map(p0_a45);
1321 ddp_listheader_rec.no_of_rows_random := rosetta_g_miss_num_map(p0_a47);
1322 ddp_listheader_rec.org_id := rosetta_g_miss_num_map(p0_a48);
1323 ddp_listheader_rec.main_gen_start_time := rosetta_g_miss_date_in_map(p0_a49);
1324 ddp_listheader_rec.main_gen_end_time := rosetta_g_miss_date_in_map(p0_a50);
1325 ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p0_a51);
1326 ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p0_a52);
1327 ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p0_a53);
1328 ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p0_a54);
1329 ddp_listheader_rec.repeat_source_list_header_id := p0_a55;
1330 ddp_listheader_rec.result_text := p0_a56;
1331 ddp_listheader_rec.keywords := p0_a57;
1332 ddp_listheader_rec.description := p0_a58;
1333 ddp_listheader_rec.list_priority := rosetta_g_miss_num_map(p0_a59);
1334 ddp_listheader_rec.assign_person_id := rosetta_g_miss_num_map(p0_a60);
1335 ddp_listheader_rec.list_source := p0_a61;
1336 ddp_listheader_rec.list_source_type := p0_a62;
1337 ddp_listheader_rec.list_online_flag := p0_a63;
1338 ddp_listheader_rec.random_list_id := rosetta_g_miss_num_map(p0_a64);
1339 ddp_listheader_rec.enabled_flag := p0_a65;
1340 ddp_listheader_rec.assigned_to := rosetta_g_miss_num_map(p0_a66);
1341 ddp_listheader_rec.query_id := rosetta_g_miss_num_map(p0_a67);
1342 ddp_listheader_rec.owner_person_id := rosetta_g_miss_num_map(p0_a68);
1343 ddp_listheader_rec.archived_by := rosetta_g_miss_num_map(p0_a69);
1344 ddp_listheader_rec.archived_date := rosetta_g_miss_date_in_map(p0_a70);
1345 ddp_listheader_rec.attribute_category := p0_a71;
1346 ddp_listheader_rec.attribute1 := p0_a72;
1347 ddp_listheader_rec.attribute2 := p0_a73;
1348 ddp_listheader_rec.attribute3 := p0_a74;
1349 ddp_listheader_rec.attribute4 := p0_a75;
1350 ddp_listheader_rec.attribute5 := p0_a76;
1351 ddp_listheader_rec.attribute6 := p0_a77;
1352 ddp_listheader_rec.attribute7 := p0_a78;
1353 ddp_listheader_rec.attribute8 := p0_a79;
1354 ddp_listheader_rec.attribute9 := p0_a80;
1355 ddp_listheader_rec.attribute10 := p0_a81;
1356 ddp_listheader_rec.attribute11 := p0_a82;
1357 ddp_listheader_rec.attribute12 := p0_a83;
1358 ddp_listheader_rec.attribute13 := p0_a84;
1359 ddp_listheader_rec.attribute14 := p0_a85;
1360 ddp_listheader_rec.attribute15 := p0_a86;
1361 ddp_listheader_rec.timezone_id := rosetta_g_miss_num_map(p0_a87);
1362 ddp_listheader_rec.user_entered_start_time := rosetta_g_miss_date_in_map(p0_a88);
1363 ddp_listheader_rec.user_status_id := rosetta_g_miss_num_map(p0_a89);
1364 ddp_listheader_rec.quantum := rosetta_g_miss_num_map(p0_a90);
1365 ddp_listheader_rec.release_control_alg_id := rosetta_g_miss_num_map(p0_a91);
1366 ddp_listheader_rec.dialing_method := p0_a92;
1367 ddp_listheader_rec.calling_calendar_id := rosetta_g_miss_num_map(p0_a93);
1368 ddp_listheader_rec.release_strategy := p0_a94;
1369 ddp_listheader_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a95);
1370 ddp_listheader_rec.country := rosetta_g_miss_num_map(p0_a96);
1371 ddp_listheader_rec.callback_priority_flag := p0_a97;
1372 ddp_listheader_rec.call_center_ready_flag := p0_a98;
1373 ddp_listheader_rec.language := p0_a99;
1374 ddp_listheader_rec.purge_flag := p0_a100;
1375 ddp_listheader_rec.public_flag := p0_a101;
1376 ddp_listheader_rec.list_category := p0_a102;
1377 ddp_listheader_rec.quota := rosetta_g_miss_num_map(p0_a103);
1378 ddp_listheader_rec.quota_reset := rosetta_g_miss_num_map(p0_a104);
1379 ddp_listheader_rec.recycling_alg_id := rosetta_g_miss_num_map(p0_a105);
1380 ddp_listheader_rec.source_lang := p0_a106;
1381 ddp_listheader_rec.no_of_rows_prev_contacted := rosetta_g_miss_num_map(p0_a107);
1382 ddp_listheader_rec.apply_traffic_cop := p0_a108;
1383
1384 ddp_complete_rec.list_header_id := rosetta_g_miss_num_map(p1_a0);
1385 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
1386 ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
1387 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
1388 ddp_complete_rec.created_by := rosetta_g_miss_num_map(p1_a4);
1389 ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
1390 ddp_complete_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
1391 ddp_complete_rec.request_id := rosetta_g_miss_num_map(p1_a7);
1392 ddp_complete_rec.program_id := rosetta_g_miss_num_map(p1_a8);
1393 ddp_complete_rec.program_application_id := rosetta_g_miss_num_map(p1_a9);
1394 ddp_complete_rec.program_update_date := rosetta_g_miss_date_in_map(p1_a10);
1395 ddp_complete_rec.view_application_id := rosetta_g_miss_num_map(p1_a11);
1396 ddp_complete_rec.list_name := p1_a12;
1397 ddp_complete_rec.list_used_by_id := rosetta_g_miss_num_map(p1_a13);
1398 ddp_complete_rec.arc_list_used_by := p1_a14;
1399 ddp_complete_rec.list_type := p1_a15;
1400 ddp_complete_rec.status_code := p1_a16;
1401 ddp_complete_rec.status_date := rosetta_g_miss_date_in_map(p1_a17);
1402 ddp_complete_rec.generation_type := p1_a18;
1403 ddp_complete_rec.repeat_exclude_type := p1_a19;
1404 ddp_complete_rec.row_selection_type := p1_a20;
1408 ddp_complete_rec.enable_word_replacement_flag := p1_a24;
1405 ddp_complete_rec.owner_user_id := rosetta_g_miss_num_map(p1_a21);
1406 ddp_complete_rec.access_level := p1_a22;
1407 ddp_complete_rec.enable_log_flag := p1_a23;
1409 ddp_complete_rec.enable_parallel_dml_flag := p1_a25;
1410 ddp_complete_rec.dedupe_during_generation_flag := p1_a26;
1411 ddp_complete_rec.generate_control_group_flag := p1_a27;
1412 ddp_complete_rec.last_generation_success_flag := p1_a28;
1413 ddp_complete_rec.forecasted_start_date := rosetta_g_miss_date_in_map(p1_a29);
1414 ddp_complete_rec.forecasted_end_date := rosetta_g_miss_date_in_map(p1_a30);
1415 ddp_complete_rec.actual_end_date := rosetta_g_miss_date_in_map(p1_a31);
1416 ddp_complete_rec.sent_out_date := rosetta_g_miss_date_in_map(p1_a32);
1417 ddp_complete_rec.dedupe_start_date := rosetta_g_miss_date_in_map(p1_a33);
1418 ddp_complete_rec.last_dedupe_date := rosetta_g_miss_date_in_map(p1_a34);
1419 ddp_complete_rec.last_deduped_by_user_id := rosetta_g_miss_num_map(p1_a35);
1420 ddp_complete_rec.workflow_item_key := rosetta_g_miss_num_map(p1_a36);
1421 ddp_complete_rec.no_of_rows_duplicates := rosetta_g_miss_num_map(p1_a37);
1422 ddp_complete_rec.no_of_rows_min_requested := rosetta_g_miss_num_map(p1_a38);
1423 ddp_complete_rec.no_of_rows_max_requested := rosetta_g_miss_num_map(p1_a39);
1424 ddp_complete_rec.no_of_rows_in_list := rosetta_g_miss_num_map(p1_a40);
1425 ddp_complete_rec.no_of_rows_in_ctrl_group := rosetta_g_miss_num_map(p1_a41);
1426 ddp_complete_rec.no_of_rows_active := rosetta_g_miss_num_map(p1_a42);
1427 ddp_complete_rec.no_of_rows_inactive := rosetta_g_miss_num_map(p1_a43);
1428 ddp_complete_rec.no_of_rows_manually_entered := rosetta_g_miss_num_map(p1_a44);
1429 ddp_complete_rec.no_of_rows_do_not_call := rosetta_g_miss_num_map(p1_a45);
1430 ddp_complete_rec.no_of_rows_do_not_mail := rosetta_g_miss_num_map(p1_a46);
1431 ddp_complete_rec.no_of_rows_random := rosetta_g_miss_num_map(p1_a47);
1432 ddp_complete_rec.org_id := rosetta_g_miss_num_map(p1_a48);
1433 ddp_complete_rec.main_gen_start_time := rosetta_g_miss_date_in_map(p1_a49);
1434 ddp_complete_rec.main_gen_end_time := rosetta_g_miss_date_in_map(p1_a50);
1435 ddp_complete_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p1_a51);
1436 ddp_complete_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p1_a52);
1437 ddp_complete_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p1_a53);
1438 ddp_complete_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p1_a54);
1439 ddp_complete_rec.repeat_source_list_header_id := p1_a55;
1440 ddp_complete_rec.result_text := p1_a56;
1441 ddp_complete_rec.keywords := p1_a57;
1442 ddp_complete_rec.description := p1_a58;
1443 ddp_complete_rec.list_priority := rosetta_g_miss_num_map(p1_a59);
1444 ddp_complete_rec.assign_person_id := rosetta_g_miss_num_map(p1_a60);
1445 ddp_complete_rec.list_source := p1_a61;
1446 ddp_complete_rec.list_source_type := p1_a62;
1447 ddp_complete_rec.list_online_flag := p1_a63;
1448 ddp_complete_rec.random_list_id := rosetta_g_miss_num_map(p1_a64);
1449 ddp_complete_rec.enabled_flag := p1_a65;
1450 ddp_complete_rec.assigned_to := rosetta_g_miss_num_map(p1_a66);
1451 ddp_complete_rec.query_id := rosetta_g_miss_num_map(p1_a67);
1452 ddp_complete_rec.owner_person_id := rosetta_g_miss_num_map(p1_a68);
1453 ddp_complete_rec.archived_by := rosetta_g_miss_num_map(p1_a69);
1454 ddp_complete_rec.archived_date := rosetta_g_miss_date_in_map(p1_a70);
1455 ddp_complete_rec.attribute_category := p1_a71;
1456 ddp_complete_rec.attribute1 := p1_a72;
1457 ddp_complete_rec.attribute2 := p1_a73;
1458 ddp_complete_rec.attribute3 := p1_a74;
1459 ddp_complete_rec.attribute4 := p1_a75;
1460 ddp_complete_rec.attribute5 := p1_a76;
1461 ddp_complete_rec.attribute6 := p1_a77;
1462 ddp_complete_rec.attribute7 := p1_a78;
1463 ddp_complete_rec.attribute8 := p1_a79;
1464 ddp_complete_rec.attribute9 := p1_a80;
1465 ddp_complete_rec.attribute10 := p1_a81;
1466 ddp_complete_rec.attribute11 := p1_a82;
1467 ddp_complete_rec.attribute12 := p1_a83;
1468 ddp_complete_rec.attribute13 := p1_a84;
1469 ddp_complete_rec.attribute14 := p1_a85;
1470 ddp_complete_rec.attribute15 := p1_a86;
1471 ddp_complete_rec.timezone_id := rosetta_g_miss_num_map(p1_a87);
1472 ddp_complete_rec.user_entered_start_time := rosetta_g_miss_date_in_map(p1_a88);
1473 ddp_complete_rec.user_status_id := rosetta_g_miss_num_map(p1_a89);
1474 ddp_complete_rec.quantum := rosetta_g_miss_num_map(p1_a90);
1475 ddp_complete_rec.release_control_alg_id := rosetta_g_miss_num_map(p1_a91);
1476 ddp_complete_rec.dialing_method := p1_a92;
1477 ddp_complete_rec.calling_calendar_id := rosetta_g_miss_num_map(p1_a93);
1478 ddp_complete_rec.release_strategy := p1_a94;
1479 ddp_complete_rec.custom_setup_id := rosetta_g_miss_num_map(p1_a95);
1480 ddp_complete_rec.country := rosetta_g_miss_num_map(p1_a96);
1481 ddp_complete_rec.callback_priority_flag := p1_a97;
1482 ddp_complete_rec.call_center_ready_flag := p1_a98;
1483 ddp_complete_rec.language := p1_a99;
1484 ddp_complete_rec.purge_flag := p1_a100;
1485 ddp_complete_rec.public_flag := p1_a101;
1486 ddp_complete_rec.list_category := p1_a102;
1487 ddp_complete_rec.quota := rosetta_g_miss_num_map(p1_a103);
1488 ddp_complete_rec.quota_reset := rosetta_g_miss_num_map(p1_a104);
1489 ddp_complete_rec.recycling_alg_id := rosetta_g_miss_num_map(p1_a105);
1490 ddp_complete_rec.source_lang := p1_a106;
1491 ddp_complete_rec.no_of_rows_prev_contacted := rosetta_g_miss_num_map(p1_a107);
1492 ddp_complete_rec.apply_traffic_cop := p1_a108;
1493
1494
1495 -- here's the delegated call to the old PL/SQL routine
1499
1496 ams_listheader_pvt.validate_list_record(ddp_listheader_rec,
1497 ddp_complete_rec,
1498 x_return_status);
1500 -- copy data back from the local variables to OUT or IN-OUT args, if any
1501
1502
1503 end;
1504
1505 procedure init_listheader_rec(p0_a0 out nocopy NUMBER
1506 , p0_a1 out nocopy DATE
1507 , p0_a2 out nocopy NUMBER
1508 , p0_a3 out nocopy DATE
1509 , p0_a4 out nocopy NUMBER
1510 , p0_a5 out nocopy NUMBER
1511 , p0_a6 out nocopy NUMBER
1512 , p0_a7 out nocopy NUMBER
1513 , p0_a8 out nocopy NUMBER
1514 , p0_a9 out nocopy NUMBER
1515 , p0_a10 out nocopy DATE
1516 , p0_a11 out nocopy NUMBER
1517 , p0_a12 out nocopy VARCHAR2
1518 , p0_a13 out nocopy NUMBER
1519 , p0_a14 out nocopy VARCHAR2
1520 , p0_a15 out nocopy VARCHAR2
1521 , p0_a16 out nocopy VARCHAR2
1522 , p0_a17 out nocopy DATE
1523 , p0_a18 out nocopy VARCHAR2
1524 , p0_a19 out nocopy VARCHAR2
1525 , p0_a20 out nocopy VARCHAR2
1526 , p0_a21 out nocopy NUMBER
1527 , p0_a22 out nocopy VARCHAR2
1528 , p0_a23 out nocopy VARCHAR2
1529 , p0_a24 out nocopy VARCHAR2
1530 , p0_a25 out nocopy VARCHAR2
1531 , p0_a26 out nocopy VARCHAR2
1532 , p0_a27 out nocopy VARCHAR2
1533 , p0_a28 out nocopy VARCHAR2
1534 , p0_a29 out nocopy DATE
1535 , p0_a30 out nocopy DATE
1536 , p0_a31 out nocopy DATE
1537 , p0_a32 out nocopy DATE
1538 , p0_a33 out nocopy DATE
1539 , p0_a34 out nocopy DATE
1540 , p0_a35 out nocopy NUMBER
1541 , p0_a36 out nocopy NUMBER
1542 , p0_a37 out nocopy NUMBER
1543 , p0_a38 out nocopy NUMBER
1544 , p0_a39 out nocopy NUMBER
1545 , p0_a40 out nocopy NUMBER
1546 , p0_a41 out nocopy NUMBER
1547 , p0_a42 out nocopy NUMBER
1548 , p0_a43 out nocopy NUMBER
1549 , p0_a44 out nocopy NUMBER
1550 , p0_a45 out nocopy NUMBER
1551 , p0_a46 out nocopy NUMBER
1552 , p0_a47 out nocopy NUMBER
1553 , p0_a48 out nocopy NUMBER
1554 , p0_a49 out nocopy DATE
1555 , p0_a50 out nocopy DATE
1556 , p0_a51 out nocopy NUMBER
1557 , p0_a52 out nocopy NUMBER
1558 , p0_a53 out nocopy NUMBER
1559 , p0_a54 out nocopy NUMBER
1560 , p0_a55 out nocopy VARCHAR2
1561 , p0_a56 out nocopy VARCHAR2
1562 , p0_a57 out nocopy VARCHAR2
1563 , p0_a58 out nocopy VARCHAR2
1564 , p0_a59 out nocopy NUMBER
1565 , p0_a60 out nocopy NUMBER
1566 , p0_a61 out nocopy VARCHAR2
1567 , p0_a62 out nocopy VARCHAR2
1568 , p0_a63 out nocopy VARCHAR2
1569 , p0_a64 out nocopy NUMBER
1570 , p0_a65 out nocopy VARCHAR2
1571 , p0_a66 out nocopy NUMBER
1572 , p0_a67 out nocopy NUMBER
1573 , p0_a68 out nocopy NUMBER
1574 , p0_a69 out nocopy NUMBER
1575 , p0_a70 out nocopy DATE
1576 , p0_a71 out nocopy VARCHAR2
1577 , p0_a72 out nocopy VARCHAR2
1578 , p0_a73 out nocopy VARCHAR2
1579 , p0_a74 out nocopy VARCHAR2
1580 , p0_a75 out nocopy VARCHAR2
1581 , p0_a76 out nocopy VARCHAR2
1582 , p0_a77 out nocopy VARCHAR2
1583 , p0_a78 out nocopy VARCHAR2
1584 , p0_a79 out nocopy VARCHAR2
1585 , p0_a80 out nocopy VARCHAR2
1586 , p0_a81 out nocopy VARCHAR2
1587 , p0_a82 out nocopy VARCHAR2
1588 , p0_a83 out nocopy VARCHAR2
1589 , p0_a84 out nocopy VARCHAR2
1590 , p0_a85 out nocopy VARCHAR2
1591 , p0_a86 out nocopy VARCHAR2
1592 , p0_a87 out nocopy NUMBER
1593 , p0_a88 out nocopy DATE
1594 , p0_a89 out nocopy NUMBER
1595 , p0_a90 out nocopy NUMBER
1596 , p0_a91 out nocopy NUMBER
1597 , p0_a92 out nocopy VARCHAR2
1598 , p0_a93 out nocopy NUMBER
1599 , p0_a94 out nocopy VARCHAR2
1600 , p0_a95 out nocopy NUMBER
1601 , p0_a96 out nocopy NUMBER
1602 , p0_a97 out nocopy VARCHAR2
1603 , p0_a98 out nocopy VARCHAR2
1604 , p0_a99 out nocopy VARCHAR2
1605 , p0_a100 out nocopy VARCHAR2
1606 , p0_a101 out nocopy VARCHAR2
1607 , p0_a102 out nocopy VARCHAR2
1608 , p0_a103 out nocopy NUMBER
1609 , p0_a104 out nocopy NUMBER
1610 , p0_a105 out nocopy NUMBER
1611 , p0_a106 out nocopy VARCHAR2
1612 , p0_a107 out nocopy NUMBER
1613 , p0_a108 out nocopy VARCHAR2
1614 )
1615
1616 as
1617 ddx_listheader_rec ams_listheader_pvt.list_header_rec_type;
1618 ddindx binary_integer; indx binary_integer;
1619 begin
1620
1621 -- copy data to the local IN or IN-OUT args, if any
1622
1623 -- here's the delegated call to the old PL/SQL routine
1624 ams_listheader_pvt.init_listheader_rec(ddx_listheader_rec);
1625
1626 -- copy data back from the local variables to OUT or IN-OUT args, if any
1627 p0_a0 := rosetta_g_miss_num_map(ddx_listheader_rec.list_header_id);
1628 p0_a1 := ddx_listheader_rec.last_update_date;
1629 p0_a2 := rosetta_g_miss_num_map(ddx_listheader_rec.last_updated_by);
1630 p0_a3 := ddx_listheader_rec.creation_date;
1631 p0_a4 := rosetta_g_miss_num_map(ddx_listheader_rec.created_by);
1632 p0_a5 := rosetta_g_miss_num_map(ddx_listheader_rec.last_update_login);
1633 p0_a6 := rosetta_g_miss_num_map(ddx_listheader_rec.object_version_number);
1637 p0_a10 := ddx_listheader_rec.program_update_date;
1634 p0_a7 := rosetta_g_miss_num_map(ddx_listheader_rec.request_id);
1635 p0_a8 := rosetta_g_miss_num_map(ddx_listheader_rec.program_id);
1636 p0_a9 := rosetta_g_miss_num_map(ddx_listheader_rec.program_application_id);
1638 p0_a11 := rosetta_g_miss_num_map(ddx_listheader_rec.view_application_id);
1639 p0_a12 := ddx_listheader_rec.list_name;
1640 p0_a13 := rosetta_g_miss_num_map(ddx_listheader_rec.list_used_by_id);
1641 p0_a14 := ddx_listheader_rec.arc_list_used_by;
1642 p0_a15 := ddx_listheader_rec.list_type;
1643 p0_a16 := ddx_listheader_rec.status_code;
1644 p0_a17 := ddx_listheader_rec.status_date;
1645 p0_a18 := ddx_listheader_rec.generation_type;
1646 p0_a19 := ddx_listheader_rec.repeat_exclude_type;
1647 p0_a20 := ddx_listheader_rec.row_selection_type;
1648 p0_a21 := rosetta_g_miss_num_map(ddx_listheader_rec.owner_user_id);
1649 p0_a22 := ddx_listheader_rec.access_level;
1650 p0_a23 := ddx_listheader_rec.enable_log_flag;
1651 p0_a24 := ddx_listheader_rec.enable_word_replacement_flag;
1652 p0_a25 := ddx_listheader_rec.enable_parallel_dml_flag;
1653 p0_a26 := ddx_listheader_rec.dedupe_during_generation_flag;
1654 p0_a27 := ddx_listheader_rec.generate_control_group_flag;
1655 p0_a28 := ddx_listheader_rec.last_generation_success_flag;
1656 p0_a29 := ddx_listheader_rec.forecasted_start_date;
1657 p0_a30 := ddx_listheader_rec.forecasted_end_date;
1658 p0_a31 := ddx_listheader_rec.actual_end_date;
1659 p0_a32 := ddx_listheader_rec.sent_out_date;
1660 p0_a33 := ddx_listheader_rec.dedupe_start_date;
1661 p0_a34 := ddx_listheader_rec.last_dedupe_date;
1662 p0_a35 := rosetta_g_miss_num_map(ddx_listheader_rec.last_deduped_by_user_id);
1663 p0_a36 := rosetta_g_miss_num_map(ddx_listheader_rec.workflow_item_key);
1664 p0_a37 := rosetta_g_miss_num_map(ddx_listheader_rec.no_of_rows_duplicates);
1665 p0_a38 := rosetta_g_miss_num_map(ddx_listheader_rec.no_of_rows_min_requested);
1666 p0_a39 := rosetta_g_miss_num_map(ddx_listheader_rec.no_of_rows_max_requested);
1667 p0_a40 := rosetta_g_miss_num_map(ddx_listheader_rec.no_of_rows_in_list);
1668 p0_a41 := rosetta_g_miss_num_map(ddx_listheader_rec.no_of_rows_in_ctrl_group);
1669 p0_a42 := rosetta_g_miss_num_map(ddx_listheader_rec.no_of_rows_active);
1670 p0_a43 := rosetta_g_miss_num_map(ddx_listheader_rec.no_of_rows_inactive);
1671 p0_a44 := rosetta_g_miss_num_map(ddx_listheader_rec.no_of_rows_manually_entered);
1672 p0_a45 := rosetta_g_miss_num_map(ddx_listheader_rec.no_of_rows_do_not_call);
1673 p0_a46 := rosetta_g_miss_num_map(ddx_listheader_rec.no_of_rows_do_not_mail);
1674 p0_a47 := rosetta_g_miss_num_map(ddx_listheader_rec.no_of_rows_random);
1675 p0_a48 := rosetta_g_miss_num_map(ddx_listheader_rec.org_id);
1676 p0_a49 := ddx_listheader_rec.main_gen_start_time;
1677 p0_a50 := ddx_listheader_rec.main_gen_end_time;
1678 p0_a51 := rosetta_g_miss_num_map(ddx_listheader_rec.main_random_nth_row_selection);
1679 p0_a52 := rosetta_g_miss_num_map(ddx_listheader_rec.main_random_pct_row_selection);
1680 p0_a53 := rosetta_g_miss_num_map(ddx_listheader_rec.ctrl_random_nth_row_selection);
1681 p0_a54 := rosetta_g_miss_num_map(ddx_listheader_rec.ctrl_random_pct_row_selection);
1682 p0_a55 := ddx_listheader_rec.repeat_source_list_header_id;
1683 p0_a56 := ddx_listheader_rec.result_text;
1684 p0_a57 := ddx_listheader_rec.keywords;
1685 p0_a58 := ddx_listheader_rec.description;
1686 p0_a59 := rosetta_g_miss_num_map(ddx_listheader_rec.list_priority);
1687 p0_a60 := rosetta_g_miss_num_map(ddx_listheader_rec.assign_person_id);
1688 p0_a61 := ddx_listheader_rec.list_source;
1689 p0_a62 := ddx_listheader_rec.list_source_type;
1690 p0_a63 := ddx_listheader_rec.list_online_flag;
1691 p0_a64 := rosetta_g_miss_num_map(ddx_listheader_rec.random_list_id);
1692 p0_a65 := ddx_listheader_rec.enabled_flag;
1693 p0_a66 := rosetta_g_miss_num_map(ddx_listheader_rec.assigned_to);
1694 p0_a67 := rosetta_g_miss_num_map(ddx_listheader_rec.query_id);
1695 p0_a68 := rosetta_g_miss_num_map(ddx_listheader_rec.owner_person_id);
1696 p0_a69 := rosetta_g_miss_num_map(ddx_listheader_rec.archived_by);
1697 p0_a70 := ddx_listheader_rec.archived_date;
1698 p0_a71 := ddx_listheader_rec.attribute_category;
1699 p0_a72 := ddx_listheader_rec.attribute1;
1700 p0_a73 := ddx_listheader_rec.attribute2;
1701 p0_a74 := ddx_listheader_rec.attribute3;
1702 p0_a75 := ddx_listheader_rec.attribute4;
1703 p0_a76 := ddx_listheader_rec.attribute5;
1704 p0_a77 := ddx_listheader_rec.attribute6;
1705 p0_a78 := ddx_listheader_rec.attribute7;
1706 p0_a79 := ddx_listheader_rec.attribute8;
1707 p0_a80 := ddx_listheader_rec.attribute9;
1708 p0_a81 := ddx_listheader_rec.attribute10;
1709 p0_a82 := ddx_listheader_rec.attribute11;
1710 p0_a83 := ddx_listheader_rec.attribute12;
1711 p0_a84 := ddx_listheader_rec.attribute13;
1712 p0_a85 := ddx_listheader_rec.attribute14;
1713 p0_a86 := ddx_listheader_rec.attribute15;
1714 p0_a87 := rosetta_g_miss_num_map(ddx_listheader_rec.timezone_id);
1715 p0_a88 := ddx_listheader_rec.user_entered_start_time;
1716 p0_a89 := rosetta_g_miss_num_map(ddx_listheader_rec.user_status_id);
1717 p0_a90 := rosetta_g_miss_num_map(ddx_listheader_rec.quantum);
1718 p0_a91 := rosetta_g_miss_num_map(ddx_listheader_rec.release_control_alg_id);
1719 p0_a92 := ddx_listheader_rec.dialing_method;
1720 p0_a93 := rosetta_g_miss_num_map(ddx_listheader_rec.calling_calendar_id);
1721 p0_a94 := ddx_listheader_rec.release_strategy;
1722 p0_a95 := rosetta_g_miss_num_map(ddx_listheader_rec.custom_setup_id);
1723 p0_a96 := rosetta_g_miss_num_map(ddx_listheader_rec.country);
1724 p0_a97 := ddx_listheader_rec.callback_priority_flag;
1728 p0_a101 := ddx_listheader_rec.public_flag;
1725 p0_a98 := ddx_listheader_rec.call_center_ready_flag;
1726 p0_a99 := ddx_listheader_rec.language;
1727 p0_a100 := ddx_listheader_rec.purge_flag;
1729 p0_a102 := ddx_listheader_rec.list_category;
1730 p0_a103 := rosetta_g_miss_num_map(ddx_listheader_rec.quota);
1731 p0_a104 := rosetta_g_miss_num_map(ddx_listheader_rec.quota_reset);
1732 p0_a105 := rosetta_g_miss_num_map(ddx_listheader_rec.recycling_alg_id);
1733 p0_a106 := ddx_listheader_rec.source_lang;
1734 p0_a107 := rosetta_g_miss_num_map(ddx_listheader_rec.no_of_rows_prev_contacted);
1735 p0_a108 := ddx_listheader_rec.apply_traffic_cop;
1736 end;
1737
1738 procedure complete_listheader_rec(p1_a0 out nocopy NUMBER
1739 , p1_a1 out nocopy DATE
1740 , p1_a2 out nocopy NUMBER
1741 , p1_a3 out nocopy DATE
1742 , p1_a4 out nocopy NUMBER
1743 , p1_a5 out nocopy NUMBER
1744 , p1_a6 out nocopy NUMBER
1745 , p1_a7 out nocopy NUMBER
1746 , p1_a8 out nocopy NUMBER
1747 , p1_a9 out nocopy NUMBER
1748 , p1_a10 out nocopy DATE
1749 , p1_a11 out nocopy NUMBER
1750 , p1_a12 out nocopy VARCHAR2
1751 , p1_a13 out nocopy NUMBER
1752 , p1_a14 out nocopy VARCHAR2
1753 , p1_a15 out nocopy VARCHAR2
1754 , p1_a16 out nocopy VARCHAR2
1755 , p1_a17 out nocopy DATE
1756 , p1_a18 out nocopy VARCHAR2
1757 , p1_a19 out nocopy VARCHAR2
1758 , p1_a20 out nocopy VARCHAR2
1759 , p1_a21 out nocopy NUMBER
1760 , p1_a22 out nocopy VARCHAR2
1761 , p1_a23 out nocopy VARCHAR2
1762 , p1_a24 out nocopy VARCHAR2
1763 , p1_a25 out nocopy VARCHAR2
1764 , p1_a26 out nocopy VARCHAR2
1765 , p1_a27 out nocopy VARCHAR2
1766 , p1_a28 out nocopy VARCHAR2
1767 , p1_a29 out nocopy DATE
1768 , p1_a30 out nocopy DATE
1769 , p1_a31 out nocopy DATE
1770 , p1_a32 out nocopy DATE
1771 , p1_a33 out nocopy DATE
1772 , p1_a34 out nocopy DATE
1773 , p1_a35 out nocopy NUMBER
1774 , p1_a36 out nocopy NUMBER
1775 , p1_a37 out nocopy NUMBER
1776 , p1_a38 out nocopy NUMBER
1777 , p1_a39 out nocopy NUMBER
1778 , p1_a40 out nocopy NUMBER
1779 , p1_a41 out nocopy NUMBER
1780 , p1_a42 out nocopy NUMBER
1781 , p1_a43 out nocopy NUMBER
1782 , p1_a44 out nocopy NUMBER
1783 , p1_a45 out nocopy NUMBER
1784 , p1_a46 out nocopy NUMBER
1785 , p1_a47 out nocopy NUMBER
1786 , p1_a48 out nocopy NUMBER
1787 , p1_a49 out nocopy DATE
1788 , p1_a50 out nocopy DATE
1789 , p1_a51 out nocopy NUMBER
1790 , p1_a52 out nocopy NUMBER
1791 , p1_a53 out nocopy NUMBER
1792 , p1_a54 out nocopy NUMBER
1793 , p1_a55 out nocopy VARCHAR2
1794 , p1_a56 out nocopy VARCHAR2
1795 , p1_a57 out nocopy VARCHAR2
1796 , p1_a58 out nocopy VARCHAR2
1797 , p1_a59 out nocopy NUMBER
1798 , p1_a60 out nocopy NUMBER
1799 , p1_a61 out nocopy VARCHAR2
1800 , p1_a62 out nocopy VARCHAR2
1801 , p1_a63 out nocopy VARCHAR2
1802 , p1_a64 out nocopy NUMBER
1803 , p1_a65 out nocopy VARCHAR2
1804 , p1_a66 out nocopy NUMBER
1805 , p1_a67 out nocopy NUMBER
1806 , p1_a68 out nocopy NUMBER
1807 , p1_a69 out nocopy NUMBER
1808 , p1_a70 out nocopy DATE
1809 , p1_a71 out nocopy VARCHAR2
1810 , p1_a72 out nocopy VARCHAR2
1811 , p1_a73 out nocopy VARCHAR2
1812 , p1_a74 out nocopy VARCHAR2
1813 , p1_a75 out nocopy VARCHAR2
1814 , p1_a76 out nocopy VARCHAR2
1815 , p1_a77 out nocopy VARCHAR2
1816 , p1_a78 out nocopy VARCHAR2
1817 , p1_a79 out nocopy VARCHAR2
1818 , p1_a80 out nocopy VARCHAR2
1819 , p1_a81 out nocopy VARCHAR2
1820 , p1_a82 out nocopy VARCHAR2
1821 , p1_a83 out nocopy VARCHAR2
1822 , p1_a84 out nocopy VARCHAR2
1823 , p1_a85 out nocopy VARCHAR2
1824 , p1_a86 out nocopy VARCHAR2
1825 , p1_a87 out nocopy NUMBER
1826 , p1_a88 out nocopy DATE
1827 , p1_a89 out nocopy NUMBER
1828 , p1_a90 out nocopy NUMBER
1829 , p1_a91 out nocopy NUMBER
1830 , p1_a92 out nocopy VARCHAR2
1831 , p1_a93 out nocopy NUMBER
1832 , p1_a94 out nocopy VARCHAR2
1833 , p1_a95 out nocopy NUMBER
1834 , p1_a96 out nocopy NUMBER
1835 , p1_a97 out nocopy VARCHAR2
1836 , p1_a98 out nocopy VARCHAR2
1837 , p1_a99 out nocopy VARCHAR2
1838 , p1_a100 out nocopy VARCHAR2
1839 , p1_a101 out nocopy VARCHAR2
1840 , p1_a102 out nocopy VARCHAR2
1841 , p1_a103 out nocopy NUMBER
1842 , p1_a104 out nocopy NUMBER
1843 , p1_a105 out nocopy NUMBER
1844 , p1_a106 out nocopy VARCHAR2
1845 , p1_a107 out nocopy NUMBER
1846 , p1_a108 out nocopy VARCHAR2
1847 , p0_a0 NUMBER := 0-1962.0724
1848 , p0_a1 DATE := fnd_api.g_miss_date
1849 , p0_a2 NUMBER := 0-1962.0724
1850 , p0_a3 DATE := fnd_api.g_miss_date
1851 , p0_a4 NUMBER := 0-1962.0724
1852 , p0_a5 NUMBER := 0-1962.0724
1853 , p0_a6 NUMBER := 0-1962.0724
1854 , p0_a7 NUMBER := 0-1962.0724
1855 , p0_a8 NUMBER := 0-1962.0724
1856 , p0_a9 NUMBER := 0-1962.0724
1857 , p0_a10 DATE := fnd_api.g_miss_date
1858 , p0_a11 NUMBER := 0-1962.0724
1859 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
1860 , p0_a13 NUMBER := 0-1962.0724
1864 , p0_a17 DATE := fnd_api.g_miss_date
1861 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1862 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1863 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1865 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1866 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1867 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1868 , p0_a21 NUMBER := 0-1962.0724
1869 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1870 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1871 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1872 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
1873 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
1874 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1875 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1876 , p0_a29 DATE := fnd_api.g_miss_date
1877 , p0_a30 DATE := fnd_api.g_miss_date
1878 , p0_a31 DATE := fnd_api.g_miss_date
1879 , p0_a32 DATE := fnd_api.g_miss_date
1880 , p0_a33 DATE := fnd_api.g_miss_date
1881 , p0_a34 DATE := fnd_api.g_miss_date
1882 , p0_a35 NUMBER := 0-1962.0724
1883 , p0_a36 NUMBER := 0-1962.0724
1884 , p0_a37 NUMBER := 0-1962.0724
1885 , p0_a38 NUMBER := 0-1962.0724
1886 , p0_a39 NUMBER := 0-1962.0724
1887 , p0_a40 NUMBER := 0-1962.0724
1888 , p0_a41 NUMBER := 0-1962.0724
1889 , p0_a42 NUMBER := 0-1962.0724
1890 , p0_a43 NUMBER := 0-1962.0724
1891 , p0_a44 NUMBER := 0-1962.0724
1892 , p0_a45 NUMBER := 0-1962.0724
1893 , p0_a46 NUMBER := 0-1962.0724
1894 , p0_a47 NUMBER := 0-1962.0724
1895 , p0_a48 NUMBER := 0-1962.0724
1896 , p0_a49 DATE := fnd_api.g_miss_date
1897 , p0_a50 DATE := fnd_api.g_miss_date
1898 , p0_a51 NUMBER := 0-1962.0724
1899 , p0_a52 NUMBER := 0-1962.0724
1900 , p0_a53 NUMBER := 0-1962.0724
1901 , p0_a54 NUMBER := 0-1962.0724
1902 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1903 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1904 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
1905 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
1906 , p0_a59 NUMBER := 0-1962.0724
1907 , p0_a60 NUMBER := 0-1962.0724
1908 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
1909 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
1910 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
1911 , p0_a64 NUMBER := 0-1962.0724
1912 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
1913 , p0_a66 NUMBER := 0-1962.0724
1914 , p0_a67 NUMBER := 0-1962.0724
1915 , p0_a68 NUMBER := 0-1962.0724
1916 , p0_a69 NUMBER := 0-1962.0724
1917 , p0_a70 DATE := fnd_api.g_miss_date
1918 , p0_a71 VARCHAR2 := fnd_api.g_miss_char
1919 , p0_a72 VARCHAR2 := fnd_api.g_miss_char
1920 , p0_a73 VARCHAR2 := fnd_api.g_miss_char
1921 , p0_a74 VARCHAR2 := fnd_api.g_miss_char
1922 , p0_a75 VARCHAR2 := fnd_api.g_miss_char
1923 , p0_a76 VARCHAR2 := fnd_api.g_miss_char
1924 , p0_a77 VARCHAR2 := fnd_api.g_miss_char
1925 , p0_a78 VARCHAR2 := fnd_api.g_miss_char
1926 , p0_a79 VARCHAR2 := fnd_api.g_miss_char
1927 , p0_a80 VARCHAR2 := fnd_api.g_miss_char
1928 , p0_a81 VARCHAR2 := fnd_api.g_miss_char
1929 , p0_a82 VARCHAR2 := fnd_api.g_miss_char
1930 , p0_a83 VARCHAR2 := fnd_api.g_miss_char
1931 , p0_a84 VARCHAR2 := fnd_api.g_miss_char
1932 , p0_a85 VARCHAR2 := fnd_api.g_miss_char
1933 , p0_a86 VARCHAR2 := fnd_api.g_miss_char
1934 , p0_a87 NUMBER := 0-1962.0724
1935 , p0_a88 DATE := fnd_api.g_miss_date
1936 , p0_a89 NUMBER := 0-1962.0724
1937 , p0_a90 NUMBER := 0-1962.0724
1938 , p0_a91 NUMBER := 0-1962.0724
1939 , p0_a92 VARCHAR2 := fnd_api.g_miss_char
1940 , p0_a93 NUMBER := 0-1962.0724
1941 , p0_a94 VARCHAR2 := fnd_api.g_miss_char
1942 , p0_a95 NUMBER := 0-1962.0724
1943 , p0_a96 NUMBER := 0-1962.0724
1944 , p0_a97 VARCHAR2 := fnd_api.g_miss_char
1945 , p0_a98 VARCHAR2 := fnd_api.g_miss_char
1946 , p0_a99 VARCHAR2 := fnd_api.g_miss_char
1947 , p0_a100 VARCHAR2 := fnd_api.g_miss_char
1948 , p0_a101 VARCHAR2 := fnd_api.g_miss_char
1949 , p0_a102 VARCHAR2 := fnd_api.g_miss_char
1950 , p0_a103 NUMBER := 0-1962.0724
1951 , p0_a104 NUMBER := 0-1962.0724
1952 , p0_a105 NUMBER := 0-1962.0724
1953 , p0_a106 VARCHAR2 := fnd_api.g_miss_char
1954 , p0_a107 NUMBER := 0-1962.0724
1955 , p0_a108 VARCHAR2 := fnd_api.g_miss_char
1956 )
1957
1958 as
1959 ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
1960 ddx_complete_rec ams_listheader_pvt.list_header_rec_type;
1961 ddindx binary_integer; indx binary_integer;
1962 begin
1963
1964 -- copy data to the local IN or IN-OUT args, if any
1965 ddp_listheader_rec.list_header_id := rosetta_g_miss_num_map(p0_a0);
1966 ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1967 ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1968 ddp_listheader_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1969 ddp_listheader_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1970 ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1971 ddp_listheader_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1972 ddp_listheader_rec.request_id := rosetta_g_miss_num_map(p0_a7);
1973 ddp_listheader_rec.program_id := rosetta_g_miss_num_map(p0_a8);
1974 ddp_listheader_rec.program_application_id := rosetta_g_miss_num_map(p0_a9);
1975 ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a10);
1976 ddp_listheader_rec.view_application_id := rosetta_g_miss_num_map(p0_a11);
1980 ddp_listheader_rec.list_type := p0_a15;
1977 ddp_listheader_rec.list_name := p0_a12;
1978 ddp_listheader_rec.list_used_by_id := rosetta_g_miss_num_map(p0_a13);
1979 ddp_listheader_rec.arc_list_used_by := p0_a14;
1981 ddp_listheader_rec.status_code := p0_a16;
1982 ddp_listheader_rec.status_date := rosetta_g_miss_date_in_map(p0_a17);
1983 ddp_listheader_rec.generation_type := p0_a18;
1984 ddp_listheader_rec.repeat_exclude_type := p0_a19;
1985 ddp_listheader_rec.row_selection_type := p0_a20;
1986 ddp_listheader_rec.owner_user_id := rosetta_g_miss_num_map(p0_a21);
1987 ddp_listheader_rec.access_level := p0_a22;
1988 ddp_listheader_rec.enable_log_flag := p0_a23;
1989 ddp_listheader_rec.enable_word_replacement_flag := p0_a24;
1990 ddp_listheader_rec.enable_parallel_dml_flag := p0_a25;
1991 ddp_listheader_rec.dedupe_during_generation_flag := p0_a26;
1992 ddp_listheader_rec.generate_control_group_flag := p0_a27;
1993 ddp_listheader_rec.last_generation_success_flag := p0_a28;
1994 ddp_listheader_rec.forecasted_start_date := rosetta_g_miss_date_in_map(p0_a29);
1995 ddp_listheader_rec.forecasted_end_date := rosetta_g_miss_date_in_map(p0_a30);
1996 ddp_listheader_rec.actual_end_date := rosetta_g_miss_date_in_map(p0_a31);
1997 ddp_listheader_rec.sent_out_date := rosetta_g_miss_date_in_map(p0_a32);
1998 ddp_listheader_rec.dedupe_start_date := rosetta_g_miss_date_in_map(p0_a33);
1999 ddp_listheader_rec.last_dedupe_date := rosetta_g_miss_date_in_map(p0_a34);
2000 ddp_listheader_rec.last_deduped_by_user_id := rosetta_g_miss_num_map(p0_a35);
2001 ddp_listheader_rec.workflow_item_key := rosetta_g_miss_num_map(p0_a36);
2002 ddp_listheader_rec.no_of_rows_duplicates := rosetta_g_miss_num_map(p0_a37);
2003 ddp_listheader_rec.no_of_rows_min_requested := rosetta_g_miss_num_map(p0_a38);
2004 ddp_listheader_rec.no_of_rows_max_requested := rosetta_g_miss_num_map(p0_a39);
2005 ddp_listheader_rec.no_of_rows_in_list := rosetta_g_miss_num_map(p0_a40);
2006 ddp_listheader_rec.no_of_rows_in_ctrl_group := rosetta_g_miss_num_map(p0_a41);
2007 ddp_listheader_rec.no_of_rows_active := rosetta_g_miss_num_map(p0_a42);
2008 ddp_listheader_rec.no_of_rows_inactive := rosetta_g_miss_num_map(p0_a43);
2009 ddp_listheader_rec.no_of_rows_manually_entered := rosetta_g_miss_num_map(p0_a44);
2010 ddp_listheader_rec.no_of_rows_do_not_call := rosetta_g_miss_num_map(p0_a45);
2011 ddp_listheader_rec.no_of_rows_do_not_mail := rosetta_g_miss_num_map(p0_a46);
2012 ddp_listheader_rec.no_of_rows_random := rosetta_g_miss_num_map(p0_a47);
2013 ddp_listheader_rec.org_id := rosetta_g_miss_num_map(p0_a48);
2014 ddp_listheader_rec.main_gen_start_time := rosetta_g_miss_date_in_map(p0_a49);
2015 ddp_listheader_rec.main_gen_end_time := rosetta_g_miss_date_in_map(p0_a50);
2016 ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p0_a51);
2017 ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p0_a52);
2018 ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p0_a53);
2019 ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p0_a54);
2020 ddp_listheader_rec.repeat_source_list_header_id := p0_a55;
2021 ddp_listheader_rec.result_text := p0_a56;
2022 ddp_listheader_rec.keywords := p0_a57;
2023 ddp_listheader_rec.description := p0_a58;
2024 ddp_listheader_rec.list_priority := rosetta_g_miss_num_map(p0_a59);
2025 ddp_listheader_rec.assign_person_id := rosetta_g_miss_num_map(p0_a60);
2026 ddp_listheader_rec.list_source := p0_a61;
2027 ddp_listheader_rec.list_source_type := p0_a62;
2028 ddp_listheader_rec.list_online_flag := p0_a63;
2029 ddp_listheader_rec.random_list_id := rosetta_g_miss_num_map(p0_a64);
2030 ddp_listheader_rec.enabled_flag := p0_a65;
2031 ddp_listheader_rec.assigned_to := rosetta_g_miss_num_map(p0_a66);
2032 ddp_listheader_rec.query_id := rosetta_g_miss_num_map(p0_a67);
2033 ddp_listheader_rec.owner_person_id := rosetta_g_miss_num_map(p0_a68);
2034 ddp_listheader_rec.archived_by := rosetta_g_miss_num_map(p0_a69);
2035 ddp_listheader_rec.archived_date := rosetta_g_miss_date_in_map(p0_a70);
2036 ddp_listheader_rec.attribute_category := p0_a71;
2037 ddp_listheader_rec.attribute1 := p0_a72;
2038 ddp_listheader_rec.attribute2 := p0_a73;
2039 ddp_listheader_rec.attribute3 := p0_a74;
2040 ddp_listheader_rec.attribute4 := p0_a75;
2041 ddp_listheader_rec.attribute5 := p0_a76;
2042 ddp_listheader_rec.attribute6 := p0_a77;
2043 ddp_listheader_rec.attribute7 := p0_a78;
2044 ddp_listheader_rec.attribute8 := p0_a79;
2045 ddp_listheader_rec.attribute9 := p0_a80;
2046 ddp_listheader_rec.attribute10 := p0_a81;
2047 ddp_listheader_rec.attribute11 := p0_a82;
2048 ddp_listheader_rec.attribute12 := p0_a83;
2049 ddp_listheader_rec.attribute13 := p0_a84;
2050 ddp_listheader_rec.attribute14 := p0_a85;
2051 ddp_listheader_rec.attribute15 := p0_a86;
2052 ddp_listheader_rec.timezone_id := rosetta_g_miss_num_map(p0_a87);
2053 ddp_listheader_rec.user_entered_start_time := rosetta_g_miss_date_in_map(p0_a88);
2054 ddp_listheader_rec.user_status_id := rosetta_g_miss_num_map(p0_a89);
2055 ddp_listheader_rec.quantum := rosetta_g_miss_num_map(p0_a90);
2056 ddp_listheader_rec.release_control_alg_id := rosetta_g_miss_num_map(p0_a91);
2057 ddp_listheader_rec.dialing_method := p0_a92;
2058 ddp_listheader_rec.calling_calendar_id := rosetta_g_miss_num_map(p0_a93);
2059 ddp_listheader_rec.release_strategy := p0_a94;
2060 ddp_listheader_rec.custom_setup_id := rosetta_g_miss_num_map(p0_a95);
2061 ddp_listheader_rec.country := rosetta_g_miss_num_map(p0_a96);
2062 ddp_listheader_rec.callback_priority_flag := p0_a97;
2066 ddp_listheader_rec.public_flag := p0_a101;
2063 ddp_listheader_rec.call_center_ready_flag := p0_a98;
2064 ddp_listheader_rec.language := p0_a99;
2065 ddp_listheader_rec.purge_flag := p0_a100;
2067 ddp_listheader_rec.list_category := p0_a102;
2068 ddp_listheader_rec.quota := rosetta_g_miss_num_map(p0_a103);
2069 ddp_listheader_rec.quota_reset := rosetta_g_miss_num_map(p0_a104);
2070 ddp_listheader_rec.recycling_alg_id := rosetta_g_miss_num_map(p0_a105);
2071 ddp_listheader_rec.source_lang := p0_a106;
2072 ddp_listheader_rec.no_of_rows_prev_contacted := rosetta_g_miss_num_map(p0_a107);
2073 ddp_listheader_rec.apply_traffic_cop := p0_a108;
2074
2075
2076 -- here's the delegated call to the old PL/SQL routine
2077 ams_listheader_pvt.complete_listheader_rec(ddp_listheader_rec,
2078 ddx_complete_rec);
2079
2080 -- copy data back from the local variables to OUT or IN-OUT args, if any
2081
2082 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.list_header_id);
2083 p1_a1 := ddx_complete_rec.last_update_date;
2084 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
2085 p1_a3 := ddx_complete_rec.creation_date;
2086 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
2087 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
2088 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
2089 p1_a7 := rosetta_g_miss_num_map(ddx_complete_rec.request_id);
2090 p1_a8 := rosetta_g_miss_num_map(ddx_complete_rec.program_id);
2091 p1_a9 := rosetta_g_miss_num_map(ddx_complete_rec.program_application_id);
2092 p1_a10 := ddx_complete_rec.program_update_date;
2093 p1_a11 := rosetta_g_miss_num_map(ddx_complete_rec.view_application_id);
2094 p1_a12 := ddx_complete_rec.list_name;
2095 p1_a13 := rosetta_g_miss_num_map(ddx_complete_rec.list_used_by_id);
2096 p1_a14 := ddx_complete_rec.arc_list_used_by;
2097 p1_a15 := ddx_complete_rec.list_type;
2098 p1_a16 := ddx_complete_rec.status_code;
2099 p1_a17 := ddx_complete_rec.status_date;
2100 p1_a18 := ddx_complete_rec.generation_type;
2101 p1_a19 := ddx_complete_rec.repeat_exclude_type;
2102 p1_a20 := ddx_complete_rec.row_selection_type;
2103 p1_a21 := rosetta_g_miss_num_map(ddx_complete_rec.owner_user_id);
2104 p1_a22 := ddx_complete_rec.access_level;
2105 p1_a23 := ddx_complete_rec.enable_log_flag;
2106 p1_a24 := ddx_complete_rec.enable_word_replacement_flag;
2107 p1_a25 := ddx_complete_rec.enable_parallel_dml_flag;
2108 p1_a26 := ddx_complete_rec.dedupe_during_generation_flag;
2109 p1_a27 := ddx_complete_rec.generate_control_group_flag;
2110 p1_a28 := ddx_complete_rec.last_generation_success_flag;
2111 p1_a29 := ddx_complete_rec.forecasted_start_date;
2112 p1_a30 := ddx_complete_rec.forecasted_end_date;
2113 p1_a31 := ddx_complete_rec.actual_end_date;
2114 p1_a32 := ddx_complete_rec.sent_out_date;
2115 p1_a33 := ddx_complete_rec.dedupe_start_date;
2116 p1_a34 := ddx_complete_rec.last_dedupe_date;
2117 p1_a35 := rosetta_g_miss_num_map(ddx_complete_rec.last_deduped_by_user_id);
2118 p1_a36 := rosetta_g_miss_num_map(ddx_complete_rec.workflow_item_key);
2119 p1_a37 := rosetta_g_miss_num_map(ddx_complete_rec.no_of_rows_duplicates);
2120 p1_a38 := rosetta_g_miss_num_map(ddx_complete_rec.no_of_rows_min_requested);
2121 p1_a39 := rosetta_g_miss_num_map(ddx_complete_rec.no_of_rows_max_requested);
2122 p1_a40 := rosetta_g_miss_num_map(ddx_complete_rec.no_of_rows_in_list);
2123 p1_a41 := rosetta_g_miss_num_map(ddx_complete_rec.no_of_rows_in_ctrl_group);
2124 p1_a42 := rosetta_g_miss_num_map(ddx_complete_rec.no_of_rows_active);
2125 p1_a43 := rosetta_g_miss_num_map(ddx_complete_rec.no_of_rows_inactive);
2126 p1_a44 := rosetta_g_miss_num_map(ddx_complete_rec.no_of_rows_manually_entered);
2127 p1_a45 := rosetta_g_miss_num_map(ddx_complete_rec.no_of_rows_do_not_call);
2128 p1_a46 := rosetta_g_miss_num_map(ddx_complete_rec.no_of_rows_do_not_mail);
2129 p1_a47 := rosetta_g_miss_num_map(ddx_complete_rec.no_of_rows_random);
2130 p1_a48 := rosetta_g_miss_num_map(ddx_complete_rec.org_id);
2131 p1_a49 := ddx_complete_rec.main_gen_start_time;
2132 p1_a50 := ddx_complete_rec.main_gen_end_time;
2133 p1_a51 := rosetta_g_miss_num_map(ddx_complete_rec.main_random_nth_row_selection);
2134 p1_a52 := rosetta_g_miss_num_map(ddx_complete_rec.main_random_pct_row_selection);
2135 p1_a53 := rosetta_g_miss_num_map(ddx_complete_rec.ctrl_random_nth_row_selection);
2136 p1_a54 := rosetta_g_miss_num_map(ddx_complete_rec.ctrl_random_pct_row_selection);
2137 p1_a55 := ddx_complete_rec.repeat_source_list_header_id;
2138 p1_a56 := ddx_complete_rec.result_text;
2139 p1_a57 := ddx_complete_rec.keywords;
2140 p1_a58 := ddx_complete_rec.description;
2141 p1_a59 := rosetta_g_miss_num_map(ddx_complete_rec.list_priority);
2142 p1_a60 := rosetta_g_miss_num_map(ddx_complete_rec.assign_person_id);
2143 p1_a61 := ddx_complete_rec.list_source;
2144 p1_a62 := ddx_complete_rec.list_source_type;
2145 p1_a63 := ddx_complete_rec.list_online_flag;
2146 p1_a64 := rosetta_g_miss_num_map(ddx_complete_rec.random_list_id);
2147 p1_a65 := ddx_complete_rec.enabled_flag;
2148 p1_a66 := rosetta_g_miss_num_map(ddx_complete_rec.assigned_to);
2149 p1_a67 := rosetta_g_miss_num_map(ddx_complete_rec.query_id);
2150 p1_a68 := rosetta_g_miss_num_map(ddx_complete_rec.owner_person_id);
2151 p1_a69 := rosetta_g_miss_num_map(ddx_complete_rec.archived_by);
2152 p1_a70 := ddx_complete_rec.archived_date;
2153 p1_a71 := ddx_complete_rec.attribute_category;
2157 p1_a75 := ddx_complete_rec.attribute4;
2154 p1_a72 := ddx_complete_rec.attribute1;
2155 p1_a73 := ddx_complete_rec.attribute2;
2156 p1_a74 := ddx_complete_rec.attribute3;
2158 p1_a76 := ddx_complete_rec.attribute5;
2159 p1_a77 := ddx_complete_rec.attribute6;
2160 p1_a78 := ddx_complete_rec.attribute7;
2161 p1_a79 := ddx_complete_rec.attribute8;
2162 p1_a80 := ddx_complete_rec.attribute9;
2163 p1_a81 := ddx_complete_rec.attribute10;
2164 p1_a82 := ddx_complete_rec.attribute11;
2165 p1_a83 := ddx_complete_rec.attribute12;
2166 p1_a84 := ddx_complete_rec.attribute13;
2167 p1_a85 := ddx_complete_rec.attribute14;
2168 p1_a86 := ddx_complete_rec.attribute15;
2169 p1_a87 := rosetta_g_miss_num_map(ddx_complete_rec.timezone_id);
2170 p1_a88 := ddx_complete_rec.user_entered_start_time;
2171 p1_a89 := rosetta_g_miss_num_map(ddx_complete_rec.user_status_id);
2172 p1_a90 := rosetta_g_miss_num_map(ddx_complete_rec.quantum);
2173 p1_a91 := rosetta_g_miss_num_map(ddx_complete_rec.release_control_alg_id);
2174 p1_a92 := ddx_complete_rec.dialing_method;
2175 p1_a93 := rosetta_g_miss_num_map(ddx_complete_rec.calling_calendar_id);
2176 p1_a94 := ddx_complete_rec.release_strategy;
2177 p1_a95 := rosetta_g_miss_num_map(ddx_complete_rec.custom_setup_id);
2178 p1_a96 := rosetta_g_miss_num_map(ddx_complete_rec.country);
2179 p1_a97 := ddx_complete_rec.callback_priority_flag;
2180 p1_a98 := ddx_complete_rec.call_center_ready_flag;
2181 p1_a99 := ddx_complete_rec.language;
2182 p1_a100 := ddx_complete_rec.purge_flag;
2183 p1_a101 := ddx_complete_rec.public_flag;
2184 p1_a102 := ddx_complete_rec.list_category;
2185 p1_a103 := rosetta_g_miss_num_map(ddx_complete_rec.quota);
2186 p1_a104 := rosetta_g_miss_num_map(ddx_complete_rec.quota_reset);
2187 p1_a105 := rosetta_g_miss_num_map(ddx_complete_rec.recycling_alg_id);
2188 p1_a106 := ddx_complete_rec.source_lang;
2189 p1_a107 := rosetta_g_miss_num_map(ddx_complete_rec.no_of_rows_prev_contacted);
2190 p1_a108 := ddx_complete_rec.apply_traffic_cop;
2191 end;
2192
2193 procedure update_prev_contacted_count(p_used_by_id NUMBER
2194 , p_used_by VARCHAR2
2195 , p_last_contacted_date date
2196 , p_init_msg_list VARCHAR2
2197 , p_commit VARCHAR2
2198 , x_return_status out nocopy VARCHAR2
2199 , x_msg_count out nocopy NUMBER
2200 , x_msg_data out nocopy VARCHAR2
2201 )
2202
2203 as
2204 ddp_last_contacted_date date;
2205 ddindx binary_integer; indx binary_integer;
2206 begin
2207
2208 -- copy data to the local IN or IN-OUT args, if any
2209
2210
2211 ddp_last_contacted_date := rosetta_g_miss_date_in_map(p_last_contacted_date);
2212
2213
2214
2215
2216
2217
2218 -- here's the delegated call to the old PL/SQL routine
2219 ams_listheader_pvt.update_prev_contacted_count(p_used_by_id,
2220 p_used_by,
2221 ddp_last_contacted_date,
2222 p_init_msg_list,
2223 p_commit,
2224 x_return_status,
2225 x_msg_count,
2226 x_msg_data);
2227
2228 -- copy data back from the local variables to OUT or IN-OUT args, if any
2229
2230
2231
2232
2233
2234
2235
2236 end;
2237
2238 procedure copy_list(p_api_version NUMBER
2239 , p_init_msg_list VARCHAR2
2240 , p_commit VARCHAR2
2241 , p_validation_level NUMBER
2242 , x_return_status out nocopy VARCHAR2
2243 , x_msg_count out nocopy NUMBER
2244 , x_msg_data out nocopy VARCHAR2
2245 , p_source_listheader_id NUMBER
2246 , p_copy_select_actions VARCHAR2
2247 , p_copy_list_queries VARCHAR2
2248 , p_copy_list_entries VARCHAR2
2249 , x_listheader_id out nocopy NUMBER
2250 , p8_a0 NUMBER := 0-1962.0724
2251 , p8_a1 DATE := fnd_api.g_miss_date
2252 , p8_a2 NUMBER := 0-1962.0724
2253 , p8_a3 DATE := fnd_api.g_miss_date
2254 , p8_a4 NUMBER := 0-1962.0724
2255 , p8_a5 NUMBER := 0-1962.0724
2256 , p8_a6 NUMBER := 0-1962.0724
2257 , p8_a7 NUMBER := 0-1962.0724
2258 , p8_a8 NUMBER := 0-1962.0724
2259 , p8_a9 NUMBER := 0-1962.0724
2260 , p8_a10 DATE := fnd_api.g_miss_date
2261 , p8_a11 NUMBER := 0-1962.0724
2262 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
2263 , p8_a13 NUMBER := 0-1962.0724
2264 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
2265 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
2266 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
2267 , p8_a17 DATE := fnd_api.g_miss_date
2268 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
2269 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
2270 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
2271 , p8_a21 NUMBER := 0-1962.0724
2272 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
2273 , p8_a23 VARCHAR2 := fnd_api.g_miss_char
2274 , p8_a24 VARCHAR2 := fnd_api.g_miss_char
2275 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
2276 , p8_a26 VARCHAR2 := fnd_api.g_miss_char
2277 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
2278 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
2279 , p8_a29 DATE := fnd_api.g_miss_date
2280 , p8_a30 DATE := fnd_api.g_miss_date
2281 , p8_a31 DATE := fnd_api.g_miss_date
2282 , p8_a32 DATE := fnd_api.g_miss_date
2283 , p8_a33 DATE := fnd_api.g_miss_date
2284 , p8_a34 DATE := fnd_api.g_miss_date
2285 , p8_a35 NUMBER := 0-1962.0724
2286 , p8_a36 NUMBER := 0-1962.0724
2287 , p8_a37 NUMBER := 0-1962.0724
2291 , p8_a41 NUMBER := 0-1962.0724
2288 , p8_a38 NUMBER := 0-1962.0724
2289 , p8_a39 NUMBER := 0-1962.0724
2290 , p8_a40 NUMBER := 0-1962.0724
2292 , p8_a42 NUMBER := 0-1962.0724
2293 , p8_a43 NUMBER := 0-1962.0724
2294 , p8_a44 NUMBER := 0-1962.0724
2295 , p8_a45 NUMBER := 0-1962.0724
2296 , p8_a46 NUMBER := 0-1962.0724
2297 , p8_a47 NUMBER := 0-1962.0724
2298 , p8_a48 NUMBER := 0-1962.0724
2299 , p8_a49 DATE := fnd_api.g_miss_date
2300 , p8_a50 DATE := fnd_api.g_miss_date
2301 , p8_a51 NUMBER := 0-1962.0724
2302 , p8_a52 NUMBER := 0-1962.0724
2303 , p8_a53 NUMBER := 0-1962.0724
2304 , p8_a54 NUMBER := 0-1962.0724
2305 , p8_a55 VARCHAR2 := fnd_api.g_miss_char
2306 , p8_a56 VARCHAR2 := fnd_api.g_miss_char
2307 , p8_a57 VARCHAR2 := fnd_api.g_miss_char
2308 , p8_a58 VARCHAR2 := fnd_api.g_miss_char
2309 , p8_a59 NUMBER := 0-1962.0724
2310 , p8_a60 NUMBER := 0-1962.0724
2311 , p8_a61 VARCHAR2 := fnd_api.g_miss_char
2312 , p8_a62 VARCHAR2 := fnd_api.g_miss_char
2313 , p8_a63 VARCHAR2 := fnd_api.g_miss_char
2314 , p8_a64 NUMBER := 0-1962.0724
2315 , p8_a65 VARCHAR2 := fnd_api.g_miss_char
2316 , p8_a66 NUMBER := 0-1962.0724
2317 , p8_a67 NUMBER := 0-1962.0724
2318 , p8_a68 NUMBER := 0-1962.0724
2319 , p8_a69 NUMBER := 0-1962.0724
2320 , p8_a70 DATE := fnd_api.g_miss_date
2321 , p8_a71 VARCHAR2 := fnd_api.g_miss_char
2322 , p8_a72 VARCHAR2 := fnd_api.g_miss_char
2323 , p8_a73 VARCHAR2 := fnd_api.g_miss_char
2324 , p8_a74 VARCHAR2 := fnd_api.g_miss_char
2325 , p8_a75 VARCHAR2 := fnd_api.g_miss_char
2326 , p8_a76 VARCHAR2 := fnd_api.g_miss_char
2327 , p8_a77 VARCHAR2 := fnd_api.g_miss_char
2328 , p8_a78 VARCHAR2 := fnd_api.g_miss_char
2329 , p8_a79 VARCHAR2 := fnd_api.g_miss_char
2330 , p8_a80 VARCHAR2 := fnd_api.g_miss_char
2331 , p8_a81 VARCHAR2 := fnd_api.g_miss_char
2332 , p8_a82 VARCHAR2 := fnd_api.g_miss_char
2333 , p8_a83 VARCHAR2 := fnd_api.g_miss_char
2334 , p8_a84 VARCHAR2 := fnd_api.g_miss_char
2335 , p8_a85 VARCHAR2 := fnd_api.g_miss_char
2336 , p8_a86 VARCHAR2 := fnd_api.g_miss_char
2337 , p8_a87 NUMBER := 0-1962.0724
2338 , p8_a88 DATE := fnd_api.g_miss_date
2339 , p8_a89 NUMBER := 0-1962.0724
2340 , p8_a90 NUMBER := 0-1962.0724
2341 , p8_a91 NUMBER := 0-1962.0724
2342 , p8_a92 VARCHAR2 := fnd_api.g_miss_char
2343 , p8_a93 NUMBER := 0-1962.0724
2344 , p8_a94 VARCHAR2 := fnd_api.g_miss_char
2345 , p8_a95 NUMBER := 0-1962.0724
2346 , p8_a96 NUMBER := 0-1962.0724
2347 , p8_a97 VARCHAR2 := fnd_api.g_miss_char
2348 , p8_a98 VARCHAR2 := fnd_api.g_miss_char
2349 , p8_a99 VARCHAR2 := fnd_api.g_miss_char
2350 , p8_a100 VARCHAR2 := fnd_api.g_miss_char
2351 , p8_a101 VARCHAR2 := fnd_api.g_miss_char
2352 , p8_a102 VARCHAR2 := fnd_api.g_miss_char
2353 , p8_a103 NUMBER := 0-1962.0724
2354 , p8_a104 NUMBER := 0-1962.0724
2355 , p8_a105 NUMBER := 0-1962.0724
2356 , p8_a106 VARCHAR2 := fnd_api.g_miss_char
2357 , p8_a107 NUMBER := 0-1962.0724
2358 , p8_a108 VARCHAR2 := fnd_api.g_miss_char
2359 )
2360
2361 as
2362 ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
2363 ddindx binary_integer; indx binary_integer;
2364 begin
2365
2366 -- copy data to the local IN or IN-OUT args, if any
2367
2368
2369
2370
2371
2372
2373
2374
2375 ddp_listheader_rec.list_header_id := rosetta_g_miss_num_map(p8_a0);
2376 ddp_listheader_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a1);
2377 ddp_listheader_rec.last_updated_by := rosetta_g_miss_num_map(p8_a2);
2378 ddp_listheader_rec.creation_date := rosetta_g_miss_date_in_map(p8_a3);
2379 ddp_listheader_rec.created_by := rosetta_g_miss_num_map(p8_a4);
2380 ddp_listheader_rec.last_update_login := rosetta_g_miss_num_map(p8_a5);
2381 ddp_listheader_rec.object_version_number := rosetta_g_miss_num_map(p8_a6);
2382 ddp_listheader_rec.request_id := rosetta_g_miss_num_map(p8_a7);
2383 ddp_listheader_rec.program_id := rosetta_g_miss_num_map(p8_a8);
2384 ddp_listheader_rec.program_application_id := rosetta_g_miss_num_map(p8_a9);
2385 ddp_listheader_rec.program_update_date := rosetta_g_miss_date_in_map(p8_a10);
2386 ddp_listheader_rec.view_application_id := rosetta_g_miss_num_map(p8_a11);
2387 ddp_listheader_rec.list_name := p8_a12;
2388 ddp_listheader_rec.list_used_by_id := rosetta_g_miss_num_map(p8_a13);
2389 ddp_listheader_rec.arc_list_used_by := p8_a14;
2390 ddp_listheader_rec.list_type := p8_a15;
2391 ddp_listheader_rec.status_code := p8_a16;
2392 ddp_listheader_rec.status_date := rosetta_g_miss_date_in_map(p8_a17);
2393 ddp_listheader_rec.generation_type := p8_a18;
2394 ddp_listheader_rec.repeat_exclude_type := p8_a19;
2395 ddp_listheader_rec.row_selection_type := p8_a20;
2396 ddp_listheader_rec.owner_user_id := rosetta_g_miss_num_map(p8_a21);
2397 ddp_listheader_rec.access_level := p8_a22;
2398 ddp_listheader_rec.enable_log_flag := p8_a23;
2399 ddp_listheader_rec.enable_word_replacement_flag := p8_a24;
2400 ddp_listheader_rec.enable_parallel_dml_flag := p8_a25;
2401 ddp_listheader_rec.dedupe_during_generation_flag := p8_a26;
2402 ddp_listheader_rec.generate_control_group_flag := p8_a27;
2403 ddp_listheader_rec.last_generation_success_flag := p8_a28;
2407 ddp_listheader_rec.sent_out_date := rosetta_g_miss_date_in_map(p8_a32);
2404 ddp_listheader_rec.forecasted_start_date := rosetta_g_miss_date_in_map(p8_a29);
2405 ddp_listheader_rec.forecasted_end_date := rosetta_g_miss_date_in_map(p8_a30);
2406 ddp_listheader_rec.actual_end_date := rosetta_g_miss_date_in_map(p8_a31);
2408 ddp_listheader_rec.dedupe_start_date := rosetta_g_miss_date_in_map(p8_a33);
2409 ddp_listheader_rec.last_dedupe_date := rosetta_g_miss_date_in_map(p8_a34);
2410 ddp_listheader_rec.last_deduped_by_user_id := rosetta_g_miss_num_map(p8_a35);
2411 ddp_listheader_rec.workflow_item_key := rosetta_g_miss_num_map(p8_a36);
2412 ddp_listheader_rec.no_of_rows_duplicates := rosetta_g_miss_num_map(p8_a37);
2413 ddp_listheader_rec.no_of_rows_min_requested := rosetta_g_miss_num_map(p8_a38);
2414 ddp_listheader_rec.no_of_rows_max_requested := rosetta_g_miss_num_map(p8_a39);
2415 ddp_listheader_rec.no_of_rows_in_list := rosetta_g_miss_num_map(p8_a40);
2416 ddp_listheader_rec.no_of_rows_in_ctrl_group := rosetta_g_miss_num_map(p8_a41);
2417 ddp_listheader_rec.no_of_rows_active := rosetta_g_miss_num_map(p8_a42);
2418 ddp_listheader_rec.no_of_rows_inactive := rosetta_g_miss_num_map(p8_a43);
2419 ddp_listheader_rec.no_of_rows_manually_entered := rosetta_g_miss_num_map(p8_a44);
2420 ddp_listheader_rec.no_of_rows_do_not_call := rosetta_g_miss_num_map(p8_a45);
2421 ddp_listheader_rec.no_of_rows_do_not_mail := rosetta_g_miss_num_map(p8_a46);
2422 ddp_listheader_rec.no_of_rows_random := rosetta_g_miss_num_map(p8_a47);
2423 ddp_listheader_rec.org_id := rosetta_g_miss_num_map(p8_a48);
2424 ddp_listheader_rec.main_gen_start_time := rosetta_g_miss_date_in_map(p8_a49);
2425 ddp_listheader_rec.main_gen_end_time := rosetta_g_miss_date_in_map(p8_a50);
2426 ddp_listheader_rec.main_random_nth_row_selection := rosetta_g_miss_num_map(p8_a51);
2427 ddp_listheader_rec.main_random_pct_row_selection := rosetta_g_miss_num_map(p8_a52);
2431 ddp_listheader_rec.result_text := p8_a56;
2428 ddp_listheader_rec.ctrl_random_nth_row_selection := rosetta_g_miss_num_map(p8_a53);
2429 ddp_listheader_rec.ctrl_random_pct_row_selection := rosetta_g_miss_num_map(p8_a54);
2430 ddp_listheader_rec.repeat_source_list_header_id := p8_a55;
2432 ddp_listheader_rec.keywords := p8_a57;
2433 ddp_listheader_rec.description := p8_a58;
2434 ddp_listheader_rec.list_priority := rosetta_g_miss_num_map(p8_a59);
2435 ddp_listheader_rec.assign_person_id := rosetta_g_miss_num_map(p8_a60);
2436 ddp_listheader_rec.list_source := p8_a61;
2437 ddp_listheader_rec.list_source_type := p8_a62;
2438 ddp_listheader_rec.list_online_flag := p8_a63;
2439 ddp_listheader_rec.random_list_id := rosetta_g_miss_num_map(p8_a64);
2440 ddp_listheader_rec.enabled_flag := p8_a65;
2441 ddp_listheader_rec.assigned_to := rosetta_g_miss_num_map(p8_a66);
2442 ddp_listheader_rec.query_id := rosetta_g_miss_num_map(p8_a67);
2443 ddp_listheader_rec.owner_person_id := rosetta_g_miss_num_map(p8_a68);
2444 ddp_listheader_rec.archived_by := rosetta_g_miss_num_map(p8_a69);
2445 ddp_listheader_rec.archived_date := rosetta_g_miss_date_in_map(p8_a70);
2446 ddp_listheader_rec.attribute_category := p8_a71;
2447 ddp_listheader_rec.attribute1 := p8_a72;
2448 ddp_listheader_rec.attribute2 := p8_a73;
2449 ddp_listheader_rec.attribute3 := p8_a74;
2450 ddp_listheader_rec.attribute4 := p8_a75;
2451 ddp_listheader_rec.attribute5 := p8_a76;
2452 ddp_listheader_rec.attribute6 := p8_a77;
2453 ddp_listheader_rec.attribute7 := p8_a78;
2454 ddp_listheader_rec.attribute8 := p8_a79;
2455 ddp_listheader_rec.attribute9 := p8_a80;
2456 ddp_listheader_rec.attribute10 := p8_a81;
2457 ddp_listheader_rec.attribute11 := p8_a82;
2458 ddp_listheader_rec.attribute12 := p8_a83;
2459 ddp_listheader_rec.attribute13 := p8_a84;
2460 ddp_listheader_rec.attribute14 := p8_a85;
2461 ddp_listheader_rec.attribute15 := p8_a86;
2462 ddp_listheader_rec.timezone_id := rosetta_g_miss_num_map(p8_a87);
2463 ddp_listheader_rec.user_entered_start_time := rosetta_g_miss_date_in_map(p8_a88);
2464 ddp_listheader_rec.user_status_id := rosetta_g_miss_num_map(p8_a89);
2465 ddp_listheader_rec.quantum := rosetta_g_miss_num_map(p8_a90);
2466 ddp_listheader_rec.release_control_alg_id := rosetta_g_miss_num_map(p8_a91);
2467 ddp_listheader_rec.dialing_method := p8_a92;
2468 ddp_listheader_rec.calling_calendar_id := rosetta_g_miss_num_map(p8_a93);
2469 ddp_listheader_rec.release_strategy := p8_a94;
2470 ddp_listheader_rec.custom_setup_id := rosetta_g_miss_num_map(p8_a95);
2471 ddp_listheader_rec.country := rosetta_g_miss_num_map(p8_a96);
2472 ddp_listheader_rec.callback_priority_flag := p8_a97;
2473 ddp_listheader_rec.call_center_ready_flag := p8_a98;
2474 ddp_listheader_rec.language := p8_a99;
2475 ddp_listheader_rec.purge_flag := p8_a100;
2476 ddp_listheader_rec.public_flag := p8_a101;
2477 ddp_listheader_rec.list_category := p8_a102;
2478 ddp_listheader_rec.quota := rosetta_g_miss_num_map(p8_a103);
2479 ddp_listheader_rec.quota_reset := rosetta_g_miss_num_map(p8_a104);
2480 ddp_listheader_rec.recycling_alg_id := rosetta_g_miss_num_map(p8_a105);
2481 ddp_listheader_rec.source_lang := p8_a106;
2482 ddp_listheader_rec.no_of_rows_prev_contacted := rosetta_g_miss_num_map(p8_a107);
2483 ddp_listheader_rec.apply_traffic_cop := p8_a108;
2484
2485
2486
2487
2488
2489 -- here's the delegated call to the old PL/SQL routine
2490 ams_listheader_pvt.copy_list(p_api_version,
2491 p_init_msg_list,
2492 p_commit,
2493 p_validation_level,
2494 x_return_status,
2495 x_msg_count,
2496 x_msg_data,
2497 p_source_listheader_id,
2498 ddp_listheader_rec,
2499 p_copy_select_actions,
2500 p_copy_list_queries,
2501 p_copy_list_entries,
2502 x_listheader_id);
2503
2504 -- copy data back from the local variables to OUT or IN-OUT args, if any
2505
2506
2507
2508
2509
2510
2511
2512
2513
2514
2515
2516
2517 end;
2518
2519 end ams_listheader_pvt_w;