[Home] [Help]
PACKAGE BODY: APPS.AMS_LISTENTRY_PUB_W
Source
1 package body ams_listentry_pub_w as
2 /* $Header: amszlseb.pls 115.5 2002/11/22 08:58:26 jieli 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 function rosetta_g_miss_num_map(n number) return number as
7 a number := fnd_api.g_miss_num;
8 b number := 0-1962.0724;
9 begin
10 if n=a then return b; end if;
11 if n=b then return a; end if;
12 return n;
13 end;
14
15 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16 function rosetta_g_miss_date_in_map(d date) return date as
17 begin
18 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19 return d;
20 end;
21
22 procedure create_listentry(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 , p7_a0 NUMBER := 0-1962.0724
30 , p7_a1 NUMBER := 0-1962.0724
31 , p7_a2 DATE := fnd_api.g_miss_date
32 , p7_a3 NUMBER := 0-1962.0724
33 , p7_a4 DATE := fnd_api.g_miss_date
34 , p7_a5 NUMBER := 0-1962.0724
35 , p7_a6 NUMBER := 0-1962.0724
36 , p7_a7 NUMBER := 0-1962.0724
37 , p7_a8 NUMBER := 0-1962.0724
38 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
40 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
41 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
42 , p7_a13 NUMBER := 0-1962.0724
43 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
44 , p7_a15 NUMBER := 0-1962.0724
45 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
46 , p7_a17 NUMBER := 0-1962.0724
47 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
48 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
49 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
50 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
51 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
52 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
53 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
54 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
55 , p7_a26 NUMBER := 0-1962.0724
56 , p7_a27 NUMBER := 0-1962.0724
57 , p7_a28 NUMBER := 0-1962.0724
58 , p7_a29 NUMBER := 0-1962.0724
59 , p7_a30 NUMBER := 0-1962.0724
60 , p7_a31 NUMBER := 0-1962.0724
61 , p7_a32 NUMBER := 0-1962.0724
62 , p7_a33 NUMBER := 0-1962.0724
63 , p7_a34 NUMBER := 0-1962.0724
64 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
65 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
66 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
67 , p7_a38 NUMBER := 0-1962.0724
68 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
69 , p7_a40 NUMBER := 0-1962.0724
70 , p7_a41 NUMBER := 0-1962.0724
71 , p7_a42 NUMBER := 0-1962.0724
72 , p7_a43 NUMBER := 0-1962.0724
73 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
74 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
75 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
76 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
77 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
78 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
79 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
80 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
81 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
82 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
83 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
84 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
85 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
86 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
87 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
88 , p7_a59 VARCHAR2 := fnd_api.g_miss_char
89 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
90 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
91 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
92 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
93 , p7_a64 VARCHAR2 := fnd_api.g_miss_char
94 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
95 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
96 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
97 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
98 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
99 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
100 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
101 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
102 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
103 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
104 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
105 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
106 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
107 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
108 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
109 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
110 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
111 , p7_a82 VARCHAR2 := fnd_api.g_miss_char
112 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
113 , p7_a84 VARCHAR2 := fnd_api.g_miss_char
114 , p7_a85 VARCHAR2 := fnd_api.g_miss_char
115 , p7_a86 VARCHAR2 := fnd_api.g_miss_char
116 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
117 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
118 , p7_a89 VARCHAR2 := fnd_api.g_miss_char
119 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
120 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
121 , p7_a92 VARCHAR2 := fnd_api.g_miss_char
122 , p7_a93 VARCHAR2 := fnd_api.g_miss_char
123 , p7_a94 VARCHAR2 := fnd_api.g_miss_char
124 , p7_a95 VARCHAR2 := fnd_api.g_miss_char
125 , p7_a96 VARCHAR2 := fnd_api.g_miss_char
126 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
127 , p7_a98 VARCHAR2 := fnd_api.g_miss_char
128 , p7_a99 VARCHAR2 := fnd_api.g_miss_char
129 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
130 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
131 , p7_a102 VARCHAR2 := fnd_api.g_miss_char
132 , p7_a103 VARCHAR2 := fnd_api.g_miss_char
133 , p7_a104 VARCHAR2 := fnd_api.g_miss_char
134 , p7_a105 VARCHAR2 := fnd_api.g_miss_char
135 , p7_a106 VARCHAR2 := fnd_api.g_miss_char
136 , p7_a107 VARCHAR2 := fnd_api.g_miss_char
137 , p7_a108 VARCHAR2 := fnd_api.g_miss_char
138 , p7_a109 VARCHAR2 := fnd_api.g_miss_char
139 , p7_a110 VARCHAR2 := fnd_api.g_miss_char
140 , p7_a111 VARCHAR2 := fnd_api.g_miss_char
141 , p7_a112 VARCHAR2 := fnd_api.g_miss_char
142 , p7_a113 VARCHAR2 := fnd_api.g_miss_char
143 , p7_a114 VARCHAR2 := fnd_api.g_miss_char
144 , p7_a115 VARCHAR2 := fnd_api.g_miss_char
145 , p7_a116 VARCHAR2 := fnd_api.g_miss_char
146 , p7_a117 VARCHAR2 := fnd_api.g_miss_char
147 , p7_a118 VARCHAR2 := fnd_api.g_miss_char
148 , p7_a119 VARCHAR2 := fnd_api.g_miss_char
149 , p7_a120 VARCHAR2 := fnd_api.g_miss_char
150 , p7_a121 VARCHAR2 := fnd_api.g_miss_char
151 , p7_a122 VARCHAR2 := fnd_api.g_miss_char
152 , p7_a123 VARCHAR2 := fnd_api.g_miss_char
153 , p7_a124 VARCHAR2 := fnd_api.g_miss_char
154 , p7_a125 VARCHAR2 := fnd_api.g_miss_char
155 , p7_a126 VARCHAR2 := fnd_api.g_miss_char
156 , p7_a127 VARCHAR2 := fnd_api.g_miss_char
157 , p7_a128 VARCHAR2 := fnd_api.g_miss_char
158 , p7_a129 VARCHAR2 := fnd_api.g_miss_char
159 , p7_a130 VARCHAR2 := fnd_api.g_miss_char
160 , p7_a131 VARCHAR2 := fnd_api.g_miss_char
161 , p7_a132 VARCHAR2 := fnd_api.g_miss_char
162 , p7_a133 VARCHAR2 := fnd_api.g_miss_char
163 , p7_a134 VARCHAR2 := fnd_api.g_miss_char
164 , p7_a135 VARCHAR2 := fnd_api.g_miss_char
165 , p7_a136 VARCHAR2 := fnd_api.g_miss_char
166 , p7_a137 VARCHAR2 := fnd_api.g_miss_char
167 , p7_a138 VARCHAR2 := fnd_api.g_miss_char
168 , p7_a139 VARCHAR2 := fnd_api.g_miss_char
169 , p7_a140 VARCHAR2 := fnd_api.g_miss_char
170 , p7_a141 VARCHAR2 := fnd_api.g_miss_char
171 , p7_a142 VARCHAR2 := fnd_api.g_miss_char
172 , p7_a143 VARCHAR2 := fnd_api.g_miss_char
173 , p7_a144 VARCHAR2 := fnd_api.g_miss_char
174 , p7_a145 VARCHAR2 := fnd_api.g_miss_char
175 , p7_a146 VARCHAR2 := fnd_api.g_miss_char
176 , p7_a147 VARCHAR2 := fnd_api.g_miss_char
177 , p7_a148 VARCHAR2 := fnd_api.g_miss_char
178 , p7_a149 VARCHAR2 := fnd_api.g_miss_char
179 , p7_a150 VARCHAR2 := fnd_api.g_miss_char
180 , p7_a151 VARCHAR2 := fnd_api.g_miss_char
181 , p7_a152 VARCHAR2 := fnd_api.g_miss_char
182 , p7_a153 VARCHAR2 := fnd_api.g_miss_char
183 , p7_a154 VARCHAR2 := fnd_api.g_miss_char
184 , p7_a155 VARCHAR2 := fnd_api.g_miss_char
185 , p7_a156 VARCHAR2 := fnd_api.g_miss_char
186 , p7_a157 VARCHAR2 := fnd_api.g_miss_char
187 , p7_a158 VARCHAR2 := fnd_api.g_miss_char
188 , p7_a159 VARCHAR2 := fnd_api.g_miss_char
189 , p7_a160 VARCHAR2 := fnd_api.g_miss_char
190 , p7_a161 VARCHAR2 := fnd_api.g_miss_char
191 , p7_a162 VARCHAR2 := fnd_api.g_miss_char
192 , p7_a163 VARCHAR2 := fnd_api.g_miss_char
193 , p7_a164 VARCHAR2 := fnd_api.g_miss_char
194 , p7_a165 VARCHAR2 := fnd_api.g_miss_char
195 , p7_a166 VARCHAR2 := fnd_api.g_miss_char
196 , p7_a167 VARCHAR2 := fnd_api.g_miss_char
197 , p7_a168 VARCHAR2 := fnd_api.g_miss_char
198 , p7_a169 VARCHAR2 := fnd_api.g_miss_char
199 , p7_a170 VARCHAR2 := fnd_api.g_miss_char
200 , p7_a171 VARCHAR2 := fnd_api.g_miss_char
201 , p7_a172 VARCHAR2 := fnd_api.g_miss_char
202 , p7_a173 VARCHAR2 := fnd_api.g_miss_char
203 , p7_a174 VARCHAR2 := fnd_api.g_miss_char
204 , p7_a175 VARCHAR2 := fnd_api.g_miss_char
205 , p7_a176 VARCHAR2 := fnd_api.g_miss_char
206 , p7_a177 VARCHAR2 := fnd_api.g_miss_char
207 , p7_a178 VARCHAR2 := fnd_api.g_miss_char
208 , p7_a179 VARCHAR2 := fnd_api.g_miss_char
209 , p7_a180 VARCHAR2 := fnd_api.g_miss_char
210 , p7_a181 VARCHAR2 := fnd_api.g_miss_char
211 , p7_a182 VARCHAR2 := fnd_api.g_miss_char
212 , p7_a183 VARCHAR2 := fnd_api.g_miss_char
213 , p7_a184 VARCHAR2 := fnd_api.g_miss_char
214 , p7_a185 VARCHAR2 := fnd_api.g_miss_char
215 , p7_a186 VARCHAR2 := fnd_api.g_miss_char
216 , p7_a187 VARCHAR2 := fnd_api.g_miss_char
217 , p7_a188 VARCHAR2 := fnd_api.g_miss_char
218 , p7_a189 VARCHAR2 := fnd_api.g_miss_char
219 , p7_a190 VARCHAR2 := fnd_api.g_miss_char
220 , p7_a191 VARCHAR2 := fnd_api.g_miss_char
221 , p7_a192 VARCHAR2 := fnd_api.g_miss_char
222 , p7_a193 VARCHAR2 := fnd_api.g_miss_char
223 , p7_a194 VARCHAR2 := fnd_api.g_miss_char
224 , p7_a195 VARCHAR2 := fnd_api.g_miss_char
225 , p7_a196 VARCHAR2 := fnd_api.g_miss_char
226 , p7_a197 VARCHAR2 := fnd_api.g_miss_char
227 , p7_a198 VARCHAR2 := fnd_api.g_miss_char
228 , p7_a199 VARCHAR2 := fnd_api.g_miss_char
229 , p7_a200 VARCHAR2 := fnd_api.g_miss_char
230 , p7_a201 VARCHAR2 := fnd_api.g_miss_char
231 , p7_a202 VARCHAR2 := fnd_api.g_miss_char
232 , p7_a203 VARCHAR2 := fnd_api.g_miss_char
233 , p7_a204 VARCHAR2 := fnd_api.g_miss_char
234 , p7_a205 VARCHAR2 := fnd_api.g_miss_char
235 , p7_a206 VARCHAR2 := fnd_api.g_miss_char
236 , p7_a207 VARCHAR2 := fnd_api.g_miss_char
237 , p7_a208 VARCHAR2 := fnd_api.g_miss_char
238 , p7_a209 VARCHAR2 := fnd_api.g_miss_char
239 , p7_a210 VARCHAR2 := fnd_api.g_miss_char
240 , p7_a211 VARCHAR2 := fnd_api.g_miss_char
241 , p7_a212 VARCHAR2 := fnd_api.g_miss_char
242 , p7_a213 VARCHAR2 := fnd_api.g_miss_char
243 , p7_a214 VARCHAR2 := fnd_api.g_miss_char
244 , p7_a215 VARCHAR2 := fnd_api.g_miss_char
245 , p7_a216 VARCHAR2 := fnd_api.g_miss_char
246 , p7_a217 VARCHAR2 := fnd_api.g_miss_char
247 , p7_a218 VARCHAR2 := fnd_api.g_miss_char
248 , p7_a219 VARCHAR2 := fnd_api.g_miss_char
249 , p7_a220 VARCHAR2 := fnd_api.g_miss_char
250 , p7_a221 VARCHAR2 := fnd_api.g_miss_char
251 , p7_a222 VARCHAR2 := fnd_api.g_miss_char
252 , p7_a223 VARCHAR2 := fnd_api.g_miss_char
253 , p7_a224 VARCHAR2 := fnd_api.g_miss_char
254 , p7_a225 VARCHAR2 := fnd_api.g_miss_char
255 , p7_a226 VARCHAR2 := fnd_api.g_miss_char
256 , p7_a227 VARCHAR2 := fnd_api.g_miss_char
257 , p7_a228 VARCHAR2 := fnd_api.g_miss_char
258 , p7_a229 VARCHAR2 := fnd_api.g_miss_char
259 , p7_a230 VARCHAR2 := fnd_api.g_miss_char
260 , p7_a231 VARCHAR2 := fnd_api.g_miss_char
261 , p7_a232 VARCHAR2 := fnd_api.g_miss_char
262 , p7_a233 VARCHAR2 := fnd_api.g_miss_char
263 , p7_a234 VARCHAR2 := fnd_api.g_miss_char
264 , p7_a235 VARCHAR2 := fnd_api.g_miss_char
265 , p7_a236 VARCHAR2 := fnd_api.g_miss_char
266 , p7_a237 VARCHAR2 := fnd_api.g_miss_char
267 , p7_a238 VARCHAR2 := fnd_api.g_miss_char
268 , p7_a239 VARCHAR2 := fnd_api.g_miss_char
269 , p7_a240 VARCHAR2 := fnd_api.g_miss_char
270 , p7_a241 VARCHAR2 := fnd_api.g_miss_char
271 , p7_a242 VARCHAR2 := fnd_api.g_miss_char
272 , p7_a243 VARCHAR2 := fnd_api.g_miss_char
273 , p7_a244 VARCHAR2 := fnd_api.g_miss_char
274 , p7_a245 VARCHAR2 := fnd_api.g_miss_char
275 , p7_a246 VARCHAR2 := fnd_api.g_miss_char
276 , p7_a247 VARCHAR2 := fnd_api.g_miss_char
277 , p7_a248 VARCHAR2 := fnd_api.g_miss_char
278 , p7_a249 VARCHAR2 := fnd_api.g_miss_char
279 , p7_a250 VARCHAR2 := fnd_api.g_miss_char
280 , p7_a251 VARCHAR2 := fnd_api.g_miss_char
281 , p7_a252 VARCHAR2 := fnd_api.g_miss_char
282 , p7_a253 VARCHAR2 := fnd_api.g_miss_char
283 , p7_a254 VARCHAR2 := fnd_api.g_miss_char
284 , p7_a255 VARCHAR2 := fnd_api.g_miss_char
285 , p7_a256 VARCHAR2 := fnd_api.g_miss_char
286 , p7_a257 VARCHAR2 := fnd_api.g_miss_char
287 , p7_a258 VARCHAR2 := fnd_api.g_miss_char
288 , p7_a259 VARCHAR2 := fnd_api.g_miss_char
289 , p7_a260 VARCHAR2 := fnd_api.g_miss_char
290 , p7_a261 VARCHAR2 := fnd_api.g_miss_char
291 , p7_a262 VARCHAR2 := fnd_api.g_miss_char
292 , p7_a263 VARCHAR2 := fnd_api.g_miss_char
293 , p7_a264 VARCHAR2 := fnd_api.g_miss_char
294 , p7_a265 VARCHAR2 := fnd_api.g_miss_char
295 , p7_a266 VARCHAR2 := fnd_api.g_miss_char
296 , p7_a267 VARCHAR2 := fnd_api.g_miss_char
297 , p7_a268 VARCHAR2 := fnd_api.g_miss_char
298 , p7_a269 VARCHAR2 := fnd_api.g_miss_char
299 , p7_a270 VARCHAR2 := fnd_api.g_miss_char
300 , p7_a271 VARCHAR2 := fnd_api.g_miss_char
301 , p7_a272 VARCHAR2 := fnd_api.g_miss_char
302 , p7_a273 VARCHAR2 := fnd_api.g_miss_char
303 , p7_a274 VARCHAR2 := fnd_api.g_miss_char
304 , p7_a275 VARCHAR2 := fnd_api.g_miss_char
305 , p7_a276 VARCHAR2 := fnd_api.g_miss_char
306 , p7_a277 VARCHAR2 := fnd_api.g_miss_char
307 , p7_a278 VARCHAR2 := fnd_api.g_miss_char
308 , p7_a279 VARCHAR2 := fnd_api.g_miss_char
309 , p7_a280 VARCHAR2 := fnd_api.g_miss_char
310 , p7_a281 VARCHAR2 := fnd_api.g_miss_char
311 , p7_a282 VARCHAR2 := fnd_api.g_miss_char
312 , p7_a283 VARCHAR2 := fnd_api.g_miss_char
313 , p7_a284 VARCHAR2 := fnd_api.g_miss_char
314 , p7_a285 VARCHAR2 := fnd_api.g_miss_char
315 , p7_a286 VARCHAR2 := fnd_api.g_miss_char
316 , p7_a287 VARCHAR2 := fnd_api.g_miss_char
317 , p7_a288 VARCHAR2 := fnd_api.g_miss_char
318 , p7_a289 VARCHAR2 := fnd_api.g_miss_char
319 , p7_a290 VARCHAR2 := fnd_api.g_miss_char
320 , p7_a291 VARCHAR2 := fnd_api.g_miss_char
321 , p7_a292 VARCHAR2 := fnd_api.g_miss_char
322 , p7_a293 VARCHAR2 := fnd_api.g_miss_char
323 , p7_a294 VARCHAR2 := fnd_api.g_miss_char
324 , p7_a295 VARCHAR2 := fnd_api.g_miss_char
325 , p7_a296 VARCHAR2 := fnd_api.g_miss_char
326 , p7_a297 VARCHAR2 := fnd_api.g_miss_char
327 , p7_a298 VARCHAR2 := fnd_api.g_miss_char
328 , p7_a299 VARCHAR2 := fnd_api.g_miss_char
329 , p7_a300 VARCHAR2 := fnd_api.g_miss_char
330 , p7_a301 VARCHAR2 := fnd_api.g_miss_char
331 , p7_a302 VARCHAR2 := fnd_api.g_miss_char
332 , p7_a303 VARCHAR2 := fnd_api.g_miss_char
333 , p7_a304 VARCHAR2 := fnd_api.g_miss_char
334 , p7_a305 VARCHAR2 := fnd_api.g_miss_char
335 , p7_a306 VARCHAR2 := fnd_api.g_miss_char
336 , p7_a307 VARCHAR2 := fnd_api.g_miss_char
337 , p7_a308 VARCHAR2 := fnd_api.g_miss_char
338 , p7_a309 VARCHAR2 := fnd_api.g_miss_char
339 , p7_a310 VARCHAR2 := fnd_api.g_miss_char
340 , p7_a311 VARCHAR2 := fnd_api.g_miss_char
341 , p7_a312 VARCHAR2 := fnd_api.g_miss_char
342 , p7_a313 VARCHAR2 := fnd_api.g_miss_char
343 , p7_a314 VARCHAR2 := fnd_api.g_miss_char
344 , p7_a315 VARCHAR2 := fnd_api.g_miss_char
345 , p7_a316 VARCHAR2 := fnd_api.g_miss_char
346 , p7_a317 VARCHAR2 := fnd_api.g_miss_char
347 , p7_a318 VARCHAR2 := fnd_api.g_miss_char
348 , p7_a319 VARCHAR2 := fnd_api.g_miss_char
349 , p7_a320 VARCHAR2 := fnd_api.g_miss_char
350 , p7_a321 VARCHAR2 := fnd_api.g_miss_char
351 , p7_a322 VARCHAR2 := fnd_api.g_miss_char
352 , p7_a323 VARCHAR2 := fnd_api.g_miss_char
353 , p7_a324 VARCHAR2 := fnd_api.g_miss_char
354 , p7_a325 VARCHAR2 := fnd_api.g_miss_char
355 , p7_a326 VARCHAR2 := fnd_api.g_miss_char
356 , p7_a327 VARCHAR2 := fnd_api.g_miss_char
357 , p7_a328 VARCHAR2 := fnd_api.g_miss_char
358 , p7_a329 VARCHAR2 := fnd_api.g_miss_char
359 , p7_a330 VARCHAR2 := fnd_api.g_miss_char
360 , p7_a331 VARCHAR2 := fnd_api.g_miss_char
361 , p7_a332 VARCHAR2 := fnd_api.g_miss_char
362 , p7_a333 VARCHAR2 := fnd_api.g_miss_char
363 , p7_a334 VARCHAR2 := fnd_api.g_miss_char
364 , p7_a335 VARCHAR2 := fnd_api.g_miss_char
365 , p7_a336 VARCHAR2 := fnd_api.g_miss_char
366 , p7_a337 VARCHAR2 := fnd_api.g_miss_char
367 , p7_a338 VARCHAR2 := fnd_api.g_miss_char
368 , p7_a339 VARCHAR2 := fnd_api.g_miss_char
369 , p7_a340 VARCHAR2 := fnd_api.g_miss_char
370 , p7_a341 VARCHAR2 := fnd_api.g_miss_char
371 , p7_a342 VARCHAR2 := fnd_api.g_miss_char
372 , p7_a343 VARCHAR2 := fnd_api.g_miss_char
373 , p7_a344 VARCHAR2 := fnd_api.g_miss_char
374 , p7_a345 VARCHAR2 := fnd_api.g_miss_char
375 , p7_a346 VARCHAR2 := fnd_api.g_miss_char
376 , p7_a347 VARCHAR2 := fnd_api.g_miss_char
377 , p7_a348 VARCHAR2 := fnd_api.g_miss_char
378 , p7_a349 VARCHAR2 := fnd_api.g_miss_char
379 , p7_a350 VARCHAR2 := fnd_api.g_miss_char
380 , p7_a351 VARCHAR2 := fnd_api.g_miss_char
381 , p7_a352 VARCHAR2 := fnd_api.g_miss_char
382 , p7_a353 VARCHAR2 := fnd_api.g_miss_char
383 , p7_a354 VARCHAR2 := fnd_api.g_miss_char
384 , p7_a355 VARCHAR2 := fnd_api.g_miss_char
385 , p7_a356 VARCHAR2 := fnd_api.g_miss_char
386 , p7_a357 VARCHAR2 := fnd_api.g_miss_char
387 , p7_a358 VARCHAR2 := fnd_api.g_miss_char
388 , p7_a359 VARCHAR2 := fnd_api.g_miss_char
389 , p7_a360 VARCHAR2 := fnd_api.g_miss_char
390 , p7_a361 VARCHAR2 := fnd_api.g_miss_char
391 , p7_a362 VARCHAR2 := fnd_api.g_miss_char
392 , p7_a363 VARCHAR2 := fnd_api.g_miss_char
393 , p7_a364 VARCHAR2 := fnd_api.g_miss_char
394 , p7_a365 VARCHAR2 := fnd_api.g_miss_char
395 , p7_a366 NUMBER := 0-1962.0724
396 , p7_a367 NUMBER := 0-1962.0724
397 , p7_a368 NUMBER := 0-1962.0724
398 , p7_a369 NUMBER := 0-1962.0724
399 , p7_a370 NUMBER := 0-1962.0724
400 , p7_a371 NUMBER := 0-1962.0724
401 , p7_a372 DATE := fnd_api.g_miss_date
402 , p7_a373 DATE := fnd_api.g_miss_date
403 , p7_a374 NUMBER := 0-1962.0724
404 , p7_a375 NUMBER := 0-1962.0724
405 , x_entry_id OUT NOCOPY NUMBER
406 )
407 as
408 ddp_entry_rec ams_listentry_pvt.entry_rec_type;
409 ddindx binary_integer; indx binary_integer;
410 begin
411
412 -- copy data to the local IN or IN-OUT args, if any
413
414
415
416
417
418
419
420 ddp_entry_rec.list_entry_id := rosetta_g_miss_num_map(p7_a0);
421 ddp_entry_rec.list_header_id := rosetta_g_miss_num_map(p7_a1);
422 ddp_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
423 ddp_entry_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);
424 ddp_entry_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
425 ddp_entry_rec.created_by := rosetta_g_miss_num_map(p7_a5);
426 ddp_entry_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);
427 ddp_entry_rec.object_version_number := rosetta_g_miss_num_map(p7_a7);
428 ddp_entry_rec.list_select_action_id := rosetta_g_miss_num_map(p7_a8);
429 ddp_entry_rec.arc_list_select_action_from := p7_a9;
430 ddp_entry_rec.list_select_action_from_name := p7_a10;
431 ddp_entry_rec.source_code := p7_a11;
432 ddp_entry_rec.arc_list_used_by_source := p7_a12;
433 ddp_entry_rec.source_code_for_id := rosetta_g_miss_num_map(p7_a13);
434 ddp_entry_rec.pin_code := p7_a14;
435 ddp_entry_rec.list_entry_source_system_id := rosetta_g_miss_num_map(p7_a15);
436 ddp_entry_rec.list_entry_source_system_type := p7_a16;
437 ddp_entry_rec.view_application_id := rosetta_g_miss_num_map(p7_a17);
438 ddp_entry_rec.manually_entered_flag := p7_a18;
439 ddp_entry_rec.marked_as_duplicate_flag := p7_a19;
440 ddp_entry_rec.marked_as_random_flag := p7_a20;
441 ddp_entry_rec.part_of_control_group_flag := p7_a21;
442 ddp_entry_rec.exclude_in_triggered_list_flag := p7_a22;
443 ddp_entry_rec.enabled_flag := p7_a23;
444 ddp_entry_rec.cell_code := p7_a24;
445 ddp_entry_rec.dedupe_key := p7_a25;
446 ddp_entry_rec.randomly_generated_number := rosetta_g_miss_num_map(p7_a26);
447 ddp_entry_rec.campaign_id := rosetta_g_miss_num_map(p7_a27);
448 ddp_entry_rec.media_id := rosetta_g_miss_num_map(p7_a28);
449 ddp_entry_rec.channel_id := rosetta_g_miss_num_map(p7_a29);
450 ddp_entry_rec.channel_schedule_id := rosetta_g_miss_num_map(p7_a30);
451 ddp_entry_rec.event_offer_id := rosetta_g_miss_num_map(p7_a31);
452 ddp_entry_rec.customer_id := rosetta_g_miss_num_map(p7_a32);
453 ddp_entry_rec.market_segment_id := rosetta_g_miss_num_map(p7_a33);
454 ddp_entry_rec.vendor_id := rosetta_g_miss_num_map(p7_a34);
455 ddp_entry_rec.transfer_flag := p7_a35;
456 ddp_entry_rec.transfer_status := p7_a36;
457 ddp_entry_rec.list_source := p7_a37;
458 ddp_entry_rec.duplicate_master_entry_id := rosetta_g_miss_num_map(p7_a38);
459 ddp_entry_rec.marked_flag := p7_a39;
460 ddp_entry_rec.lead_id := rosetta_g_miss_num_map(p7_a40);
461 ddp_entry_rec.letter_id := rosetta_g_miss_num_map(p7_a41);
462 ddp_entry_rec.picking_header_id := rosetta_g_miss_num_map(p7_a42);
463 ddp_entry_rec.batch_id := rosetta_g_miss_num_map(p7_a43);
464 ddp_entry_rec.first_name := p7_a44;
465 ddp_entry_rec.last_name := p7_a45;
466 ddp_entry_rec.customer_name := p7_a46;
467 ddp_entry_rec.col1 := p7_a47;
468 ddp_entry_rec.col2 := p7_a48;
469 ddp_entry_rec.col3 := p7_a49;
470 ddp_entry_rec.col4 := p7_a50;
471 ddp_entry_rec.col5 := p7_a51;
472 ddp_entry_rec.col6 := p7_a52;
473 ddp_entry_rec.col7 := p7_a53;
474 ddp_entry_rec.col8 := p7_a54;
475 ddp_entry_rec.col9 := p7_a55;
476 ddp_entry_rec.col10 := p7_a56;
477 ddp_entry_rec.col11 := p7_a57;
478 ddp_entry_rec.col12 := p7_a58;
479 ddp_entry_rec.col13 := p7_a59;
480 ddp_entry_rec.col14 := p7_a60;
481 ddp_entry_rec.col15 := p7_a61;
482 ddp_entry_rec.col16 := p7_a62;
483 ddp_entry_rec.col17 := p7_a63;
484 ddp_entry_rec.col18 := p7_a64;
485 ddp_entry_rec.col19 := p7_a65;
486 ddp_entry_rec.col20 := p7_a66;
487 ddp_entry_rec.col21 := p7_a67;
488 ddp_entry_rec.col22 := p7_a68;
489 ddp_entry_rec.col23 := p7_a69;
490 ddp_entry_rec.col24 := p7_a70;
491 ddp_entry_rec.col25 := p7_a71;
492 ddp_entry_rec.col26 := p7_a72;
493 ddp_entry_rec.col27 := p7_a73;
494 ddp_entry_rec.col28 := p7_a74;
495 ddp_entry_rec.col29 := p7_a75;
496 ddp_entry_rec.col30 := p7_a76;
497 ddp_entry_rec.col31 := p7_a77;
498 ddp_entry_rec.col32 := p7_a78;
499 ddp_entry_rec.col33 := p7_a79;
500 ddp_entry_rec.col34 := p7_a80;
501 ddp_entry_rec.col35 := p7_a81;
502 ddp_entry_rec.col36 := p7_a82;
503 ddp_entry_rec.col37 := p7_a83;
504 ddp_entry_rec.col38 := p7_a84;
505 ddp_entry_rec.col39 := p7_a85;
506 ddp_entry_rec.col40 := p7_a86;
507 ddp_entry_rec.col41 := p7_a87;
508 ddp_entry_rec.col42 := p7_a88;
509 ddp_entry_rec.col43 := p7_a89;
510 ddp_entry_rec.col44 := p7_a90;
511 ddp_entry_rec.col45 := p7_a91;
512 ddp_entry_rec.col46 := p7_a92;
513 ddp_entry_rec.col47 := p7_a93;
514 ddp_entry_rec.col48 := p7_a94;
515 ddp_entry_rec.col49 := p7_a95;
516 ddp_entry_rec.col50 := p7_a96;
517 ddp_entry_rec.col51 := p7_a97;
518 ddp_entry_rec.col52 := p7_a98;
519 ddp_entry_rec.col53 := p7_a99;
520 ddp_entry_rec.col54 := p7_a100;
521 ddp_entry_rec.col55 := p7_a101;
522 ddp_entry_rec.col56 := p7_a102;
523 ddp_entry_rec.col57 := p7_a103;
524 ddp_entry_rec.col58 := p7_a104;
525 ddp_entry_rec.col59 := p7_a105;
526 ddp_entry_rec.col60 := p7_a106;
527 ddp_entry_rec.col61 := p7_a107;
528 ddp_entry_rec.col62 := p7_a108;
529 ddp_entry_rec.col63 := p7_a109;
530 ddp_entry_rec.col64 := p7_a110;
531 ddp_entry_rec.col65 := p7_a111;
532 ddp_entry_rec.col66 := p7_a112;
533 ddp_entry_rec.col67 := p7_a113;
534 ddp_entry_rec.col68 := p7_a114;
535 ddp_entry_rec.col69 := p7_a115;
536 ddp_entry_rec.col70 := p7_a116;
537 ddp_entry_rec.col71 := p7_a117;
538 ddp_entry_rec.col72 := p7_a118;
539 ddp_entry_rec.col73 := p7_a119;
540 ddp_entry_rec.col74 := p7_a120;
541 ddp_entry_rec.col75 := p7_a121;
542 ddp_entry_rec.col76 := p7_a122;
543 ddp_entry_rec.col77 := p7_a123;
544 ddp_entry_rec.col78 := p7_a124;
545 ddp_entry_rec.col79 := p7_a125;
546 ddp_entry_rec.col80 := p7_a126;
547 ddp_entry_rec.col81 := p7_a127;
548 ddp_entry_rec.col82 := p7_a128;
549 ddp_entry_rec.col83 := p7_a129;
550 ddp_entry_rec.col84 := p7_a130;
551 ddp_entry_rec.col85 := p7_a131;
552 ddp_entry_rec.col86 := p7_a132;
553 ddp_entry_rec.col87 := p7_a133;
554 ddp_entry_rec.col88 := p7_a134;
555 ddp_entry_rec.col89 := p7_a135;
556 ddp_entry_rec.col90 := p7_a136;
557 ddp_entry_rec.col91 := p7_a137;
558 ddp_entry_rec.col92 := p7_a138;
559 ddp_entry_rec.col93 := p7_a139;
560 ddp_entry_rec.col94 := p7_a140;
561 ddp_entry_rec.col95 := p7_a141;
562 ddp_entry_rec.col96 := p7_a142;
563 ddp_entry_rec.col97 := p7_a143;
564 ddp_entry_rec.col98 := p7_a144;
565 ddp_entry_rec.col99 := p7_a145;
566 ddp_entry_rec.col100 := p7_a146;
567 ddp_entry_rec.col101 := p7_a147;
568 ddp_entry_rec.col102 := p7_a148;
569 ddp_entry_rec.col103 := p7_a149;
570 ddp_entry_rec.col104 := p7_a150;
571 ddp_entry_rec.col105 := p7_a151;
572 ddp_entry_rec.col106 := p7_a152;
573 ddp_entry_rec.col107 := p7_a153;
574 ddp_entry_rec.col108 := p7_a154;
575 ddp_entry_rec.col109 := p7_a155;
576 ddp_entry_rec.col110 := p7_a156;
577 ddp_entry_rec.col111 := p7_a157;
578 ddp_entry_rec.col112 := p7_a158;
579 ddp_entry_rec.col113 := p7_a159;
580 ddp_entry_rec.col114 := p7_a160;
581 ddp_entry_rec.col115 := p7_a161;
582 ddp_entry_rec.col116 := p7_a162;
583 ddp_entry_rec.col117 := p7_a163;
584 ddp_entry_rec.col118 := p7_a164;
585 ddp_entry_rec.col119 := p7_a165;
586 ddp_entry_rec.col120 := p7_a166;
587 ddp_entry_rec.col121 := p7_a167;
588 ddp_entry_rec.col122 := p7_a168;
589 ddp_entry_rec.col123 := p7_a169;
590 ddp_entry_rec.col124 := p7_a170;
591 ddp_entry_rec.col125 := p7_a171;
592 ddp_entry_rec.col126 := p7_a172;
593 ddp_entry_rec.col127 := p7_a173;
594 ddp_entry_rec.col128 := p7_a174;
595 ddp_entry_rec.col129 := p7_a175;
596 ddp_entry_rec.col130 := p7_a176;
597 ddp_entry_rec.col131 := p7_a177;
598 ddp_entry_rec.col132 := p7_a178;
599 ddp_entry_rec.col133 := p7_a179;
600 ddp_entry_rec.col134 := p7_a180;
601 ddp_entry_rec.col135 := p7_a181;
602 ddp_entry_rec.col136 := p7_a182;
603 ddp_entry_rec.col137 := p7_a183;
604 ddp_entry_rec.col138 := p7_a184;
605 ddp_entry_rec.col139 := p7_a185;
606 ddp_entry_rec.col140 := p7_a186;
607 ddp_entry_rec.col141 := p7_a187;
608 ddp_entry_rec.col142 := p7_a188;
609 ddp_entry_rec.col143 := p7_a189;
610 ddp_entry_rec.col144 := p7_a190;
611 ddp_entry_rec.col145 := p7_a191;
612 ddp_entry_rec.col146 := p7_a192;
613 ddp_entry_rec.col147 := p7_a193;
614 ddp_entry_rec.col148 := p7_a194;
615 ddp_entry_rec.col149 := p7_a195;
616 ddp_entry_rec.col150 := p7_a196;
617 ddp_entry_rec.col151 := p7_a197;
618 ddp_entry_rec.col152 := p7_a198;
619 ddp_entry_rec.col153 := p7_a199;
620 ddp_entry_rec.col154 := p7_a200;
621 ddp_entry_rec.col155 := p7_a201;
622 ddp_entry_rec.col156 := p7_a202;
623 ddp_entry_rec.col157 := p7_a203;
624 ddp_entry_rec.col158 := p7_a204;
625 ddp_entry_rec.col159 := p7_a205;
626 ddp_entry_rec.col160 := p7_a206;
627 ddp_entry_rec.col161 := p7_a207;
628 ddp_entry_rec.col162 := p7_a208;
629 ddp_entry_rec.col163 := p7_a209;
630 ddp_entry_rec.col164 := p7_a210;
631 ddp_entry_rec.col165 := p7_a211;
632 ddp_entry_rec.col166 := p7_a212;
633 ddp_entry_rec.col167 := p7_a213;
634 ddp_entry_rec.col168 := p7_a214;
635 ddp_entry_rec.col169 := p7_a215;
636 ddp_entry_rec.col170 := p7_a216;
637 ddp_entry_rec.col171 := p7_a217;
638 ddp_entry_rec.col172 := p7_a218;
639 ddp_entry_rec.col173 := p7_a219;
640 ddp_entry_rec.col174 := p7_a220;
641 ddp_entry_rec.col175 := p7_a221;
642 ddp_entry_rec.col176 := p7_a222;
643 ddp_entry_rec.col177 := p7_a223;
644 ddp_entry_rec.col178 := p7_a224;
645 ddp_entry_rec.col179 := p7_a225;
646 ddp_entry_rec.col180 := p7_a226;
647 ddp_entry_rec.col181 := p7_a227;
648 ddp_entry_rec.col182 := p7_a228;
649 ddp_entry_rec.col183 := p7_a229;
650 ddp_entry_rec.col184 := p7_a230;
651 ddp_entry_rec.col185 := p7_a231;
652 ddp_entry_rec.col186 := p7_a232;
653 ddp_entry_rec.col187 := p7_a233;
654 ddp_entry_rec.col188 := p7_a234;
655 ddp_entry_rec.col189 := p7_a235;
656 ddp_entry_rec.col190 := p7_a236;
657 ddp_entry_rec.col191 := p7_a237;
658 ddp_entry_rec.col192 := p7_a238;
659 ddp_entry_rec.col193 := p7_a239;
660 ddp_entry_rec.col194 := p7_a240;
661 ddp_entry_rec.col195 := p7_a241;
662 ddp_entry_rec.col196 := p7_a242;
663 ddp_entry_rec.col197 := p7_a243;
664 ddp_entry_rec.col198 := p7_a244;
665 ddp_entry_rec.col199 := p7_a245;
666 ddp_entry_rec.col200 := p7_a246;
667 ddp_entry_rec.col201 := p7_a247;
668 ddp_entry_rec.col202 := p7_a248;
669 ddp_entry_rec.col203 := p7_a249;
670 ddp_entry_rec.col204 := p7_a250;
671 ddp_entry_rec.col205 := p7_a251;
672 ddp_entry_rec.col206 := p7_a252;
673 ddp_entry_rec.col207 := p7_a253;
674 ddp_entry_rec.col208 := p7_a254;
675 ddp_entry_rec.col209 := p7_a255;
676 ddp_entry_rec.col210 := p7_a256;
677 ddp_entry_rec.col211 := p7_a257;
678 ddp_entry_rec.col212 := p7_a258;
679 ddp_entry_rec.col213 := p7_a259;
680 ddp_entry_rec.col214 := p7_a260;
681 ddp_entry_rec.col215 := p7_a261;
682 ddp_entry_rec.col216 := p7_a262;
683 ddp_entry_rec.col217 := p7_a263;
684 ddp_entry_rec.col218 := p7_a264;
685 ddp_entry_rec.col219 := p7_a265;
686 ddp_entry_rec.col220 := p7_a266;
687 ddp_entry_rec.col221 := p7_a267;
688 ddp_entry_rec.col222 := p7_a268;
689 ddp_entry_rec.col223 := p7_a269;
690 ddp_entry_rec.col224 := p7_a270;
691 ddp_entry_rec.col225 := p7_a271;
692 ddp_entry_rec.col226 := p7_a272;
693 ddp_entry_rec.col227 := p7_a273;
694 ddp_entry_rec.col228 := p7_a274;
695 ddp_entry_rec.col229 := p7_a275;
696 ddp_entry_rec.col230 := p7_a276;
697 ddp_entry_rec.col231 := p7_a277;
698 ddp_entry_rec.col232 := p7_a278;
699 ddp_entry_rec.col233 := p7_a279;
700 ddp_entry_rec.col234 := p7_a280;
701 ddp_entry_rec.col235 := p7_a281;
702 ddp_entry_rec.col236 := p7_a282;
703 ddp_entry_rec.col237 := p7_a283;
704 ddp_entry_rec.col238 := p7_a284;
705 ddp_entry_rec.col239 := p7_a285;
706 ddp_entry_rec.col240 := p7_a286;
707 ddp_entry_rec.col241 := p7_a287;
708 ddp_entry_rec.col242 := p7_a288;
709 ddp_entry_rec.col243 := p7_a289;
710 ddp_entry_rec.col244 := p7_a290;
711 ddp_entry_rec.col245 := p7_a291;
712 ddp_entry_rec.col246 := p7_a292;
713 ddp_entry_rec.col247 := p7_a293;
714 ddp_entry_rec.col248 := p7_a294;
715 ddp_entry_rec.col249 := p7_a295;
716 ddp_entry_rec.col250 := p7_a296;
717 ddp_entry_rec.col251 := p7_a297;
718 ddp_entry_rec.col252 := p7_a298;
719 ddp_entry_rec.col253 := p7_a299;
720 ddp_entry_rec.col254 := p7_a300;
721 ddp_entry_rec.col255 := p7_a301;
722 ddp_entry_rec.col256 := p7_a302;
723 ddp_entry_rec.col257 := p7_a303;
724 ddp_entry_rec.col258 := p7_a304;
725 ddp_entry_rec.col259 := p7_a305;
726 ddp_entry_rec.col260 := p7_a306;
727 ddp_entry_rec.col261 := p7_a307;
728 ddp_entry_rec.col262 := p7_a308;
729 ddp_entry_rec.col263 := p7_a309;
730 ddp_entry_rec.col264 := p7_a310;
731 ddp_entry_rec.col265 := p7_a311;
732 ddp_entry_rec.col266 := p7_a312;
733 ddp_entry_rec.col267 := p7_a313;
734 ddp_entry_rec.col268 := p7_a314;
735 ddp_entry_rec.col269 := p7_a315;
736 ddp_entry_rec.col270 := p7_a316;
737 ddp_entry_rec.col271 := p7_a317;
738 ddp_entry_rec.col272 := p7_a318;
739 ddp_entry_rec.col273 := p7_a319;
740 ddp_entry_rec.col274 := p7_a320;
741 ddp_entry_rec.col275 := p7_a321;
742 ddp_entry_rec.col276 := p7_a322;
743 ddp_entry_rec.col277 := p7_a323;
744 ddp_entry_rec.col278 := p7_a324;
745 ddp_entry_rec.col279 := p7_a325;
746 ddp_entry_rec.col280 := p7_a326;
747 ddp_entry_rec.col281 := p7_a327;
748 ddp_entry_rec.col282 := p7_a328;
749 ddp_entry_rec.col283 := p7_a329;
750 ddp_entry_rec.col284 := p7_a330;
751 ddp_entry_rec.col285 := p7_a331;
752 ddp_entry_rec.col286 := p7_a332;
753 ddp_entry_rec.col287 := p7_a333;
754 ddp_entry_rec.col288 := p7_a334;
755 ddp_entry_rec.col289 := p7_a335;
756 ddp_entry_rec.col290 := p7_a336;
757 ddp_entry_rec.col291 := p7_a337;
758 ddp_entry_rec.col292 := p7_a338;
759 ddp_entry_rec.col293 := p7_a339;
760 ddp_entry_rec.col294 := p7_a340;
761 ddp_entry_rec.col295 := p7_a341;
762 ddp_entry_rec.col296 := p7_a342;
763 ddp_entry_rec.col297 := p7_a343;
764 ddp_entry_rec.col298 := p7_a344;
765 ddp_entry_rec.col299 := p7_a345;
766 ddp_entry_rec.col300 := p7_a346;
767 ddp_entry_rec.address_line1 := p7_a347;
768 ddp_entry_rec.address_line2 := p7_a348;
769 ddp_entry_rec.callback_flag := p7_a349;
770 ddp_entry_rec.city := p7_a350;
771 ddp_entry_rec.country := p7_a351;
772 ddp_entry_rec.do_not_use_flag := p7_a352;
773 ddp_entry_rec.do_not_use_reason := p7_a353;
774 ddp_entry_rec.email_address := p7_a354;
775 ddp_entry_rec.fax := p7_a355;
776 ddp_entry_rec.phone := p7_a356;
777 ddp_entry_rec.record_out_flag := p7_a357;
778 ddp_entry_rec.state := p7_a358;
779 ddp_entry_rec.suffix := p7_a359;
780 ddp_entry_rec.title := p7_a360;
781 ddp_entry_rec.usage_restriction := p7_a361;
782 ddp_entry_rec.zipcode := p7_a362;
783 ddp_entry_rec.curr_cp_country_code := p7_a363;
784 ddp_entry_rec.curr_cp_phone_number := p7_a364;
785 ddp_entry_rec.curr_cp_raw_phone_number := p7_a365;
786 ddp_entry_rec.curr_cp_area_code := rosetta_g_miss_num_map(p7_a366);
787 ddp_entry_rec.curr_cp_id := rosetta_g_miss_num_map(p7_a367);
788 ddp_entry_rec.curr_cp_index := rosetta_g_miss_num_map(p7_a368);
789 ddp_entry_rec.curr_cp_time_zone := rosetta_g_miss_num_map(p7_a369);
790 ddp_entry_rec.curr_cp_time_zone_aux := rosetta_g_miss_num_map(p7_a370);
791 ddp_entry_rec.imp_source_line_id := rosetta_g_miss_num_map(p7_a371);
792 ddp_entry_rec.next_call_time := rosetta_g_miss_date_in_map(p7_a372);
793 ddp_entry_rec.record_release_time := rosetta_g_miss_date_in_map(p7_a373);
794 ddp_entry_rec.party_id := rosetta_g_miss_num_map(p7_a374);
795 ddp_entry_rec.parent_party_id := rosetta_g_miss_num_map(p7_a375);
796
797
798 -- here's the delegated call to the old PL/SQL routine
799 ams_listentry_pub.create_listentry(p_api_version,
800 p_init_msg_list,
801 p_commit,
802 p_validation_level,
803 x_return_status,
804 x_msg_count,
805 x_msg_data,
806 ddp_entry_rec,
807 x_entry_id);
808
809 -- copy data back from the local OUT or IN-OUT args, if any
810
811
812
813
814
815
816
817
818 end;
819
820 procedure update_listentry(p_api_version NUMBER
821 , p_init_msg_list VARCHAR2
822 , p_commit VARCHAR2
823 , p_validation_level NUMBER
824 , x_return_status OUT NOCOPY VARCHAR2
825 , x_msg_count OUT NOCOPY NUMBER
826 , x_msg_data OUT NOCOPY VARCHAR2
827 , p7_a0 NUMBER := 0-1962.0724
828 , p7_a1 NUMBER := 0-1962.0724
829 , p7_a2 DATE := fnd_api.g_miss_date
830 , p7_a3 NUMBER := 0-1962.0724
831 , p7_a4 DATE := fnd_api.g_miss_date
832 , p7_a5 NUMBER := 0-1962.0724
833 , p7_a6 NUMBER := 0-1962.0724
834 , p7_a7 NUMBER := 0-1962.0724
835 , p7_a8 NUMBER := 0-1962.0724
836 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
837 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
838 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
839 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
840 , p7_a13 NUMBER := 0-1962.0724
841 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
842 , p7_a15 NUMBER := 0-1962.0724
843 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
844 , p7_a17 NUMBER := 0-1962.0724
845 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
846 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
847 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
848 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
849 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
850 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
851 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
852 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
853 , p7_a26 NUMBER := 0-1962.0724
854 , p7_a27 NUMBER := 0-1962.0724
855 , p7_a28 NUMBER := 0-1962.0724
856 , p7_a29 NUMBER := 0-1962.0724
857 , p7_a30 NUMBER := 0-1962.0724
858 , p7_a31 NUMBER := 0-1962.0724
859 , p7_a32 NUMBER := 0-1962.0724
860 , p7_a33 NUMBER := 0-1962.0724
861 , p7_a34 NUMBER := 0-1962.0724
862 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
863 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
864 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
865 , p7_a38 NUMBER := 0-1962.0724
866 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
867 , p7_a40 NUMBER := 0-1962.0724
868 , p7_a41 NUMBER := 0-1962.0724
869 , p7_a42 NUMBER := 0-1962.0724
870 , p7_a43 NUMBER := 0-1962.0724
871 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
872 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
873 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
874 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
875 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
876 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
877 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
878 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
879 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
880 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
881 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
882 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
883 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
884 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
885 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
886 , p7_a59 VARCHAR2 := fnd_api.g_miss_char
887 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
888 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
889 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
890 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
891 , p7_a64 VARCHAR2 := fnd_api.g_miss_char
892 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
893 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
894 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
895 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
896 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
897 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
898 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
899 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
900 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
901 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
902 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
903 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
904 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
905 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
906 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
907 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
908 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
909 , p7_a82 VARCHAR2 := fnd_api.g_miss_char
910 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
911 , p7_a84 VARCHAR2 := fnd_api.g_miss_char
912 , p7_a85 VARCHAR2 := fnd_api.g_miss_char
913 , p7_a86 VARCHAR2 := fnd_api.g_miss_char
914 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
915 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
916 , p7_a89 VARCHAR2 := fnd_api.g_miss_char
917 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
918 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
919 , p7_a92 VARCHAR2 := fnd_api.g_miss_char
920 , p7_a93 VARCHAR2 := fnd_api.g_miss_char
921 , p7_a94 VARCHAR2 := fnd_api.g_miss_char
922 , p7_a95 VARCHAR2 := fnd_api.g_miss_char
923 , p7_a96 VARCHAR2 := fnd_api.g_miss_char
924 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
925 , p7_a98 VARCHAR2 := fnd_api.g_miss_char
926 , p7_a99 VARCHAR2 := fnd_api.g_miss_char
927 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
928 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
929 , p7_a102 VARCHAR2 := fnd_api.g_miss_char
930 , p7_a103 VARCHAR2 := fnd_api.g_miss_char
931 , p7_a104 VARCHAR2 := fnd_api.g_miss_char
932 , p7_a105 VARCHAR2 := fnd_api.g_miss_char
933 , p7_a106 VARCHAR2 := fnd_api.g_miss_char
934 , p7_a107 VARCHAR2 := fnd_api.g_miss_char
935 , p7_a108 VARCHAR2 := fnd_api.g_miss_char
936 , p7_a109 VARCHAR2 := fnd_api.g_miss_char
937 , p7_a110 VARCHAR2 := fnd_api.g_miss_char
938 , p7_a111 VARCHAR2 := fnd_api.g_miss_char
939 , p7_a112 VARCHAR2 := fnd_api.g_miss_char
940 , p7_a113 VARCHAR2 := fnd_api.g_miss_char
941 , p7_a114 VARCHAR2 := fnd_api.g_miss_char
942 , p7_a115 VARCHAR2 := fnd_api.g_miss_char
943 , p7_a116 VARCHAR2 := fnd_api.g_miss_char
944 , p7_a117 VARCHAR2 := fnd_api.g_miss_char
945 , p7_a118 VARCHAR2 := fnd_api.g_miss_char
946 , p7_a119 VARCHAR2 := fnd_api.g_miss_char
947 , p7_a120 VARCHAR2 := fnd_api.g_miss_char
948 , p7_a121 VARCHAR2 := fnd_api.g_miss_char
949 , p7_a122 VARCHAR2 := fnd_api.g_miss_char
950 , p7_a123 VARCHAR2 := fnd_api.g_miss_char
951 , p7_a124 VARCHAR2 := fnd_api.g_miss_char
952 , p7_a125 VARCHAR2 := fnd_api.g_miss_char
953 , p7_a126 VARCHAR2 := fnd_api.g_miss_char
954 , p7_a127 VARCHAR2 := fnd_api.g_miss_char
955 , p7_a128 VARCHAR2 := fnd_api.g_miss_char
956 , p7_a129 VARCHAR2 := fnd_api.g_miss_char
957 , p7_a130 VARCHAR2 := fnd_api.g_miss_char
958 , p7_a131 VARCHAR2 := fnd_api.g_miss_char
959 , p7_a132 VARCHAR2 := fnd_api.g_miss_char
960 , p7_a133 VARCHAR2 := fnd_api.g_miss_char
961 , p7_a134 VARCHAR2 := fnd_api.g_miss_char
962 , p7_a135 VARCHAR2 := fnd_api.g_miss_char
963 , p7_a136 VARCHAR2 := fnd_api.g_miss_char
964 , p7_a137 VARCHAR2 := fnd_api.g_miss_char
965 , p7_a138 VARCHAR2 := fnd_api.g_miss_char
966 , p7_a139 VARCHAR2 := fnd_api.g_miss_char
967 , p7_a140 VARCHAR2 := fnd_api.g_miss_char
968 , p7_a141 VARCHAR2 := fnd_api.g_miss_char
969 , p7_a142 VARCHAR2 := fnd_api.g_miss_char
970 , p7_a143 VARCHAR2 := fnd_api.g_miss_char
971 , p7_a144 VARCHAR2 := fnd_api.g_miss_char
972 , p7_a145 VARCHAR2 := fnd_api.g_miss_char
973 , p7_a146 VARCHAR2 := fnd_api.g_miss_char
974 , p7_a147 VARCHAR2 := fnd_api.g_miss_char
975 , p7_a148 VARCHAR2 := fnd_api.g_miss_char
976 , p7_a149 VARCHAR2 := fnd_api.g_miss_char
977 , p7_a150 VARCHAR2 := fnd_api.g_miss_char
978 , p7_a151 VARCHAR2 := fnd_api.g_miss_char
979 , p7_a152 VARCHAR2 := fnd_api.g_miss_char
980 , p7_a153 VARCHAR2 := fnd_api.g_miss_char
981 , p7_a154 VARCHAR2 := fnd_api.g_miss_char
982 , p7_a155 VARCHAR2 := fnd_api.g_miss_char
983 , p7_a156 VARCHAR2 := fnd_api.g_miss_char
984 , p7_a157 VARCHAR2 := fnd_api.g_miss_char
985 , p7_a158 VARCHAR2 := fnd_api.g_miss_char
986 , p7_a159 VARCHAR2 := fnd_api.g_miss_char
987 , p7_a160 VARCHAR2 := fnd_api.g_miss_char
988 , p7_a161 VARCHAR2 := fnd_api.g_miss_char
989 , p7_a162 VARCHAR2 := fnd_api.g_miss_char
990 , p7_a163 VARCHAR2 := fnd_api.g_miss_char
991 , p7_a164 VARCHAR2 := fnd_api.g_miss_char
992 , p7_a165 VARCHAR2 := fnd_api.g_miss_char
993 , p7_a166 VARCHAR2 := fnd_api.g_miss_char
994 , p7_a167 VARCHAR2 := fnd_api.g_miss_char
995 , p7_a168 VARCHAR2 := fnd_api.g_miss_char
996 , p7_a169 VARCHAR2 := fnd_api.g_miss_char
997 , p7_a170 VARCHAR2 := fnd_api.g_miss_char
998 , p7_a171 VARCHAR2 := fnd_api.g_miss_char
999 , p7_a172 VARCHAR2 := fnd_api.g_miss_char
1000 , p7_a173 VARCHAR2 := fnd_api.g_miss_char
1001 , p7_a174 VARCHAR2 := fnd_api.g_miss_char
1002 , p7_a175 VARCHAR2 := fnd_api.g_miss_char
1003 , p7_a176 VARCHAR2 := fnd_api.g_miss_char
1004 , p7_a177 VARCHAR2 := fnd_api.g_miss_char
1005 , p7_a178 VARCHAR2 := fnd_api.g_miss_char
1006 , p7_a179 VARCHAR2 := fnd_api.g_miss_char
1007 , p7_a180 VARCHAR2 := fnd_api.g_miss_char
1008 , p7_a181 VARCHAR2 := fnd_api.g_miss_char
1009 , p7_a182 VARCHAR2 := fnd_api.g_miss_char
1010 , p7_a183 VARCHAR2 := fnd_api.g_miss_char
1011 , p7_a184 VARCHAR2 := fnd_api.g_miss_char
1012 , p7_a185 VARCHAR2 := fnd_api.g_miss_char
1013 , p7_a186 VARCHAR2 := fnd_api.g_miss_char
1014 , p7_a187 VARCHAR2 := fnd_api.g_miss_char
1015 , p7_a188 VARCHAR2 := fnd_api.g_miss_char
1016 , p7_a189 VARCHAR2 := fnd_api.g_miss_char
1017 , p7_a190 VARCHAR2 := fnd_api.g_miss_char
1018 , p7_a191 VARCHAR2 := fnd_api.g_miss_char
1019 , p7_a192 VARCHAR2 := fnd_api.g_miss_char
1020 , p7_a193 VARCHAR2 := fnd_api.g_miss_char
1021 , p7_a194 VARCHAR2 := fnd_api.g_miss_char
1022 , p7_a195 VARCHAR2 := fnd_api.g_miss_char
1023 , p7_a196 VARCHAR2 := fnd_api.g_miss_char
1024 , p7_a197 VARCHAR2 := fnd_api.g_miss_char
1025 , p7_a198 VARCHAR2 := fnd_api.g_miss_char
1026 , p7_a199 VARCHAR2 := fnd_api.g_miss_char
1027 , p7_a200 VARCHAR2 := fnd_api.g_miss_char
1028 , p7_a201 VARCHAR2 := fnd_api.g_miss_char
1029 , p7_a202 VARCHAR2 := fnd_api.g_miss_char
1030 , p7_a203 VARCHAR2 := fnd_api.g_miss_char
1031 , p7_a204 VARCHAR2 := fnd_api.g_miss_char
1032 , p7_a205 VARCHAR2 := fnd_api.g_miss_char
1033 , p7_a206 VARCHAR2 := fnd_api.g_miss_char
1034 , p7_a207 VARCHAR2 := fnd_api.g_miss_char
1035 , p7_a208 VARCHAR2 := fnd_api.g_miss_char
1036 , p7_a209 VARCHAR2 := fnd_api.g_miss_char
1037 , p7_a210 VARCHAR2 := fnd_api.g_miss_char
1038 , p7_a211 VARCHAR2 := fnd_api.g_miss_char
1039 , p7_a212 VARCHAR2 := fnd_api.g_miss_char
1040 , p7_a213 VARCHAR2 := fnd_api.g_miss_char
1041 , p7_a214 VARCHAR2 := fnd_api.g_miss_char
1042 , p7_a215 VARCHAR2 := fnd_api.g_miss_char
1043 , p7_a216 VARCHAR2 := fnd_api.g_miss_char
1044 , p7_a217 VARCHAR2 := fnd_api.g_miss_char
1045 , p7_a218 VARCHAR2 := fnd_api.g_miss_char
1046 , p7_a219 VARCHAR2 := fnd_api.g_miss_char
1047 , p7_a220 VARCHAR2 := fnd_api.g_miss_char
1048 , p7_a221 VARCHAR2 := fnd_api.g_miss_char
1049 , p7_a222 VARCHAR2 := fnd_api.g_miss_char
1050 , p7_a223 VARCHAR2 := fnd_api.g_miss_char
1051 , p7_a224 VARCHAR2 := fnd_api.g_miss_char
1052 , p7_a225 VARCHAR2 := fnd_api.g_miss_char
1053 , p7_a226 VARCHAR2 := fnd_api.g_miss_char
1054 , p7_a227 VARCHAR2 := fnd_api.g_miss_char
1055 , p7_a228 VARCHAR2 := fnd_api.g_miss_char
1056 , p7_a229 VARCHAR2 := fnd_api.g_miss_char
1057 , p7_a230 VARCHAR2 := fnd_api.g_miss_char
1058 , p7_a231 VARCHAR2 := fnd_api.g_miss_char
1059 , p7_a232 VARCHAR2 := fnd_api.g_miss_char
1060 , p7_a233 VARCHAR2 := fnd_api.g_miss_char
1061 , p7_a234 VARCHAR2 := fnd_api.g_miss_char
1062 , p7_a235 VARCHAR2 := fnd_api.g_miss_char
1063 , p7_a236 VARCHAR2 := fnd_api.g_miss_char
1064 , p7_a237 VARCHAR2 := fnd_api.g_miss_char
1065 , p7_a238 VARCHAR2 := fnd_api.g_miss_char
1066 , p7_a239 VARCHAR2 := fnd_api.g_miss_char
1067 , p7_a240 VARCHAR2 := fnd_api.g_miss_char
1068 , p7_a241 VARCHAR2 := fnd_api.g_miss_char
1069 , p7_a242 VARCHAR2 := fnd_api.g_miss_char
1070 , p7_a243 VARCHAR2 := fnd_api.g_miss_char
1071 , p7_a244 VARCHAR2 := fnd_api.g_miss_char
1072 , p7_a245 VARCHAR2 := fnd_api.g_miss_char
1073 , p7_a246 VARCHAR2 := fnd_api.g_miss_char
1074 , p7_a247 VARCHAR2 := fnd_api.g_miss_char
1075 , p7_a248 VARCHAR2 := fnd_api.g_miss_char
1076 , p7_a249 VARCHAR2 := fnd_api.g_miss_char
1077 , p7_a250 VARCHAR2 := fnd_api.g_miss_char
1078 , p7_a251 VARCHAR2 := fnd_api.g_miss_char
1079 , p7_a252 VARCHAR2 := fnd_api.g_miss_char
1080 , p7_a253 VARCHAR2 := fnd_api.g_miss_char
1081 , p7_a254 VARCHAR2 := fnd_api.g_miss_char
1082 , p7_a255 VARCHAR2 := fnd_api.g_miss_char
1083 , p7_a256 VARCHAR2 := fnd_api.g_miss_char
1084 , p7_a257 VARCHAR2 := fnd_api.g_miss_char
1085 , p7_a258 VARCHAR2 := fnd_api.g_miss_char
1086 , p7_a259 VARCHAR2 := fnd_api.g_miss_char
1087 , p7_a260 VARCHAR2 := fnd_api.g_miss_char
1088 , p7_a261 VARCHAR2 := fnd_api.g_miss_char
1089 , p7_a262 VARCHAR2 := fnd_api.g_miss_char
1090 , p7_a263 VARCHAR2 := fnd_api.g_miss_char
1091 , p7_a264 VARCHAR2 := fnd_api.g_miss_char
1092 , p7_a265 VARCHAR2 := fnd_api.g_miss_char
1093 , p7_a266 VARCHAR2 := fnd_api.g_miss_char
1094 , p7_a267 VARCHAR2 := fnd_api.g_miss_char
1095 , p7_a268 VARCHAR2 := fnd_api.g_miss_char
1096 , p7_a269 VARCHAR2 := fnd_api.g_miss_char
1097 , p7_a270 VARCHAR2 := fnd_api.g_miss_char
1098 , p7_a271 VARCHAR2 := fnd_api.g_miss_char
1099 , p7_a272 VARCHAR2 := fnd_api.g_miss_char
1100 , p7_a273 VARCHAR2 := fnd_api.g_miss_char
1101 , p7_a274 VARCHAR2 := fnd_api.g_miss_char
1102 , p7_a275 VARCHAR2 := fnd_api.g_miss_char
1103 , p7_a276 VARCHAR2 := fnd_api.g_miss_char
1104 , p7_a277 VARCHAR2 := fnd_api.g_miss_char
1105 , p7_a278 VARCHAR2 := fnd_api.g_miss_char
1106 , p7_a279 VARCHAR2 := fnd_api.g_miss_char
1107 , p7_a280 VARCHAR2 := fnd_api.g_miss_char
1108 , p7_a281 VARCHAR2 := fnd_api.g_miss_char
1109 , p7_a282 VARCHAR2 := fnd_api.g_miss_char
1110 , p7_a283 VARCHAR2 := fnd_api.g_miss_char
1111 , p7_a284 VARCHAR2 := fnd_api.g_miss_char
1112 , p7_a285 VARCHAR2 := fnd_api.g_miss_char
1113 , p7_a286 VARCHAR2 := fnd_api.g_miss_char
1114 , p7_a287 VARCHAR2 := fnd_api.g_miss_char
1115 , p7_a288 VARCHAR2 := fnd_api.g_miss_char
1116 , p7_a289 VARCHAR2 := fnd_api.g_miss_char
1117 , p7_a290 VARCHAR2 := fnd_api.g_miss_char
1118 , p7_a291 VARCHAR2 := fnd_api.g_miss_char
1119 , p7_a292 VARCHAR2 := fnd_api.g_miss_char
1120 , p7_a293 VARCHAR2 := fnd_api.g_miss_char
1121 , p7_a294 VARCHAR2 := fnd_api.g_miss_char
1122 , p7_a295 VARCHAR2 := fnd_api.g_miss_char
1123 , p7_a296 VARCHAR2 := fnd_api.g_miss_char
1124 , p7_a297 VARCHAR2 := fnd_api.g_miss_char
1125 , p7_a298 VARCHAR2 := fnd_api.g_miss_char
1126 , p7_a299 VARCHAR2 := fnd_api.g_miss_char
1127 , p7_a300 VARCHAR2 := fnd_api.g_miss_char
1128 , p7_a301 VARCHAR2 := fnd_api.g_miss_char
1129 , p7_a302 VARCHAR2 := fnd_api.g_miss_char
1130 , p7_a303 VARCHAR2 := fnd_api.g_miss_char
1131 , p7_a304 VARCHAR2 := fnd_api.g_miss_char
1132 , p7_a305 VARCHAR2 := fnd_api.g_miss_char
1133 , p7_a306 VARCHAR2 := fnd_api.g_miss_char
1134 , p7_a307 VARCHAR2 := fnd_api.g_miss_char
1135 , p7_a308 VARCHAR2 := fnd_api.g_miss_char
1136 , p7_a309 VARCHAR2 := fnd_api.g_miss_char
1137 , p7_a310 VARCHAR2 := fnd_api.g_miss_char
1138 , p7_a311 VARCHAR2 := fnd_api.g_miss_char
1139 , p7_a312 VARCHAR2 := fnd_api.g_miss_char
1140 , p7_a313 VARCHAR2 := fnd_api.g_miss_char
1141 , p7_a314 VARCHAR2 := fnd_api.g_miss_char
1142 , p7_a315 VARCHAR2 := fnd_api.g_miss_char
1143 , p7_a316 VARCHAR2 := fnd_api.g_miss_char
1144 , p7_a317 VARCHAR2 := fnd_api.g_miss_char
1145 , p7_a318 VARCHAR2 := fnd_api.g_miss_char
1146 , p7_a319 VARCHAR2 := fnd_api.g_miss_char
1147 , p7_a320 VARCHAR2 := fnd_api.g_miss_char
1148 , p7_a321 VARCHAR2 := fnd_api.g_miss_char
1149 , p7_a322 VARCHAR2 := fnd_api.g_miss_char
1150 , p7_a323 VARCHAR2 := fnd_api.g_miss_char
1151 , p7_a324 VARCHAR2 := fnd_api.g_miss_char
1152 , p7_a325 VARCHAR2 := fnd_api.g_miss_char
1153 , p7_a326 VARCHAR2 := fnd_api.g_miss_char
1154 , p7_a327 VARCHAR2 := fnd_api.g_miss_char
1155 , p7_a328 VARCHAR2 := fnd_api.g_miss_char
1156 , p7_a329 VARCHAR2 := fnd_api.g_miss_char
1157 , p7_a330 VARCHAR2 := fnd_api.g_miss_char
1158 , p7_a331 VARCHAR2 := fnd_api.g_miss_char
1159 , p7_a332 VARCHAR2 := fnd_api.g_miss_char
1160 , p7_a333 VARCHAR2 := fnd_api.g_miss_char
1161 , p7_a334 VARCHAR2 := fnd_api.g_miss_char
1162 , p7_a335 VARCHAR2 := fnd_api.g_miss_char
1163 , p7_a336 VARCHAR2 := fnd_api.g_miss_char
1164 , p7_a337 VARCHAR2 := fnd_api.g_miss_char
1165 , p7_a338 VARCHAR2 := fnd_api.g_miss_char
1166 , p7_a339 VARCHAR2 := fnd_api.g_miss_char
1167 , p7_a340 VARCHAR2 := fnd_api.g_miss_char
1168 , p7_a341 VARCHAR2 := fnd_api.g_miss_char
1169 , p7_a342 VARCHAR2 := fnd_api.g_miss_char
1170 , p7_a343 VARCHAR2 := fnd_api.g_miss_char
1171 , p7_a344 VARCHAR2 := fnd_api.g_miss_char
1172 , p7_a345 VARCHAR2 := fnd_api.g_miss_char
1173 , p7_a346 VARCHAR2 := fnd_api.g_miss_char
1174 , p7_a347 VARCHAR2 := fnd_api.g_miss_char
1175 , p7_a348 VARCHAR2 := fnd_api.g_miss_char
1176 , p7_a349 VARCHAR2 := fnd_api.g_miss_char
1177 , p7_a350 VARCHAR2 := fnd_api.g_miss_char
1178 , p7_a351 VARCHAR2 := fnd_api.g_miss_char
1179 , p7_a352 VARCHAR2 := fnd_api.g_miss_char
1180 , p7_a353 VARCHAR2 := fnd_api.g_miss_char
1181 , p7_a354 VARCHAR2 := fnd_api.g_miss_char
1182 , p7_a355 VARCHAR2 := fnd_api.g_miss_char
1183 , p7_a356 VARCHAR2 := fnd_api.g_miss_char
1184 , p7_a357 VARCHAR2 := fnd_api.g_miss_char
1185 , p7_a358 VARCHAR2 := fnd_api.g_miss_char
1186 , p7_a359 VARCHAR2 := fnd_api.g_miss_char
1187 , p7_a360 VARCHAR2 := fnd_api.g_miss_char
1188 , p7_a361 VARCHAR2 := fnd_api.g_miss_char
1189 , p7_a362 VARCHAR2 := fnd_api.g_miss_char
1190 , p7_a363 VARCHAR2 := fnd_api.g_miss_char
1191 , p7_a364 VARCHAR2 := fnd_api.g_miss_char
1192 , p7_a365 VARCHAR2 := fnd_api.g_miss_char
1193 , p7_a366 NUMBER := 0-1962.0724
1194 , p7_a367 NUMBER := 0-1962.0724
1195 , p7_a368 NUMBER := 0-1962.0724
1196 , p7_a369 NUMBER := 0-1962.0724
1197 , p7_a370 NUMBER := 0-1962.0724
1198 , p7_a371 NUMBER := 0-1962.0724
1199 , p7_a372 DATE := fnd_api.g_miss_date
1200 , p7_a373 DATE := fnd_api.g_miss_date
1201 , p7_a374 NUMBER := 0-1962.0724
1202 , p7_a375 NUMBER := 0-1962.0724
1203 )
1204 as
1205 ddp_entry_rec ams_listentry_pvt.entry_rec_type;
1206 ddindx binary_integer; indx binary_integer;
1207 begin
1208
1209 -- copy data to the local IN or IN-OUT args, if any
1210
1211
1212
1213
1214
1215
1216
1217 ddp_entry_rec.list_entry_id := rosetta_g_miss_num_map(p7_a0);
1218 ddp_entry_rec.list_header_id := rosetta_g_miss_num_map(p7_a1);
1219 ddp_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a2);
1220 ddp_entry_rec.last_updated_by := rosetta_g_miss_num_map(p7_a3);
1221 ddp_entry_rec.creation_date := rosetta_g_miss_date_in_map(p7_a4);
1222 ddp_entry_rec.created_by := rosetta_g_miss_num_map(p7_a5);
1223 ddp_entry_rec.last_update_login := rosetta_g_miss_num_map(p7_a6);
1224 ddp_entry_rec.object_version_number := rosetta_g_miss_num_map(p7_a7);
1225 ddp_entry_rec.list_select_action_id := rosetta_g_miss_num_map(p7_a8);
1226 ddp_entry_rec.arc_list_select_action_from := p7_a9;
1227 ddp_entry_rec.list_select_action_from_name := p7_a10;
1228 ddp_entry_rec.source_code := p7_a11;
1229 ddp_entry_rec.arc_list_used_by_source := p7_a12;
1230 ddp_entry_rec.source_code_for_id := rosetta_g_miss_num_map(p7_a13);
1231 ddp_entry_rec.pin_code := p7_a14;
1232 ddp_entry_rec.list_entry_source_system_id := rosetta_g_miss_num_map(p7_a15);
1233 ddp_entry_rec.list_entry_source_system_type := p7_a16;
1234 ddp_entry_rec.view_application_id := rosetta_g_miss_num_map(p7_a17);
1235 ddp_entry_rec.manually_entered_flag := p7_a18;
1236 ddp_entry_rec.marked_as_duplicate_flag := p7_a19;
1237 ddp_entry_rec.marked_as_random_flag := p7_a20;
1238 ddp_entry_rec.part_of_control_group_flag := p7_a21;
1239 ddp_entry_rec.exclude_in_triggered_list_flag := p7_a22;
1240 ddp_entry_rec.enabled_flag := p7_a23;
1241 ddp_entry_rec.cell_code := p7_a24;
1242 ddp_entry_rec.dedupe_key := p7_a25;
1243 ddp_entry_rec.randomly_generated_number := rosetta_g_miss_num_map(p7_a26);
1244 ddp_entry_rec.campaign_id := rosetta_g_miss_num_map(p7_a27);
1245 ddp_entry_rec.media_id := rosetta_g_miss_num_map(p7_a28);
1246 ddp_entry_rec.channel_id := rosetta_g_miss_num_map(p7_a29);
1247 ddp_entry_rec.channel_schedule_id := rosetta_g_miss_num_map(p7_a30);
1248 ddp_entry_rec.event_offer_id := rosetta_g_miss_num_map(p7_a31);
1249 ddp_entry_rec.customer_id := rosetta_g_miss_num_map(p7_a32);
1250 ddp_entry_rec.market_segment_id := rosetta_g_miss_num_map(p7_a33);
1251 ddp_entry_rec.vendor_id := rosetta_g_miss_num_map(p7_a34);
1252 ddp_entry_rec.transfer_flag := p7_a35;
1253 ddp_entry_rec.transfer_status := p7_a36;
1254 ddp_entry_rec.list_source := p7_a37;
1255 ddp_entry_rec.duplicate_master_entry_id := rosetta_g_miss_num_map(p7_a38);
1256 ddp_entry_rec.marked_flag := p7_a39;
1257 ddp_entry_rec.lead_id := rosetta_g_miss_num_map(p7_a40);
1258 ddp_entry_rec.letter_id := rosetta_g_miss_num_map(p7_a41);
1259 ddp_entry_rec.picking_header_id := rosetta_g_miss_num_map(p7_a42);
1260 ddp_entry_rec.batch_id := rosetta_g_miss_num_map(p7_a43);
1261 ddp_entry_rec.first_name := p7_a44;
1262 ddp_entry_rec.last_name := p7_a45;
1263 ddp_entry_rec.customer_name := p7_a46;
1264 ddp_entry_rec.col1 := p7_a47;
1265 ddp_entry_rec.col2 := p7_a48;
1266 ddp_entry_rec.col3 := p7_a49;
1267 ddp_entry_rec.col4 := p7_a50;
1268 ddp_entry_rec.col5 := p7_a51;
1269 ddp_entry_rec.col6 := p7_a52;
1270 ddp_entry_rec.col7 := p7_a53;
1271 ddp_entry_rec.col8 := p7_a54;
1272 ddp_entry_rec.col9 := p7_a55;
1273 ddp_entry_rec.col10 := p7_a56;
1274 ddp_entry_rec.col11 := p7_a57;
1275 ddp_entry_rec.col12 := p7_a58;
1276 ddp_entry_rec.col13 := p7_a59;
1277 ddp_entry_rec.col14 := p7_a60;
1278 ddp_entry_rec.col15 := p7_a61;
1279 ddp_entry_rec.col16 := p7_a62;
1280 ddp_entry_rec.col17 := p7_a63;
1281 ddp_entry_rec.col18 := p7_a64;
1282 ddp_entry_rec.col19 := p7_a65;
1283 ddp_entry_rec.col20 := p7_a66;
1284 ddp_entry_rec.col21 := p7_a67;
1285 ddp_entry_rec.col22 := p7_a68;
1286 ddp_entry_rec.col23 := p7_a69;
1287 ddp_entry_rec.col24 := p7_a70;
1288 ddp_entry_rec.col25 := p7_a71;
1289 ddp_entry_rec.col26 := p7_a72;
1290 ddp_entry_rec.col27 := p7_a73;
1291 ddp_entry_rec.col28 := p7_a74;
1292 ddp_entry_rec.col29 := p7_a75;
1293 ddp_entry_rec.col30 := p7_a76;
1294 ddp_entry_rec.col31 := p7_a77;
1295 ddp_entry_rec.col32 := p7_a78;
1296 ddp_entry_rec.col33 := p7_a79;
1297 ddp_entry_rec.col34 := p7_a80;
1298 ddp_entry_rec.col35 := p7_a81;
1299 ddp_entry_rec.col36 := p7_a82;
1300 ddp_entry_rec.col37 := p7_a83;
1301 ddp_entry_rec.col38 := p7_a84;
1302 ddp_entry_rec.col39 := p7_a85;
1303 ddp_entry_rec.col40 := p7_a86;
1304 ddp_entry_rec.col41 := p7_a87;
1305 ddp_entry_rec.col42 := p7_a88;
1306 ddp_entry_rec.col43 := p7_a89;
1307 ddp_entry_rec.col44 := p7_a90;
1308 ddp_entry_rec.col45 := p7_a91;
1309 ddp_entry_rec.col46 := p7_a92;
1310 ddp_entry_rec.col47 := p7_a93;
1311 ddp_entry_rec.col48 := p7_a94;
1312 ddp_entry_rec.col49 := p7_a95;
1313 ddp_entry_rec.col50 := p7_a96;
1314 ddp_entry_rec.col51 := p7_a97;
1315 ddp_entry_rec.col52 := p7_a98;
1316 ddp_entry_rec.col53 := p7_a99;
1317 ddp_entry_rec.col54 := p7_a100;
1318 ddp_entry_rec.col55 := p7_a101;
1319 ddp_entry_rec.col56 := p7_a102;
1320 ddp_entry_rec.col57 := p7_a103;
1321 ddp_entry_rec.col58 := p7_a104;
1322 ddp_entry_rec.col59 := p7_a105;
1323 ddp_entry_rec.col60 := p7_a106;
1324 ddp_entry_rec.col61 := p7_a107;
1325 ddp_entry_rec.col62 := p7_a108;
1326 ddp_entry_rec.col63 := p7_a109;
1327 ddp_entry_rec.col64 := p7_a110;
1328 ddp_entry_rec.col65 := p7_a111;
1329 ddp_entry_rec.col66 := p7_a112;
1330 ddp_entry_rec.col67 := p7_a113;
1331 ddp_entry_rec.col68 := p7_a114;
1332 ddp_entry_rec.col69 := p7_a115;
1333 ddp_entry_rec.col70 := p7_a116;
1334 ddp_entry_rec.col71 := p7_a117;
1335 ddp_entry_rec.col72 := p7_a118;
1336 ddp_entry_rec.col73 := p7_a119;
1337 ddp_entry_rec.col74 := p7_a120;
1338 ddp_entry_rec.col75 := p7_a121;
1339 ddp_entry_rec.col76 := p7_a122;
1340 ddp_entry_rec.col77 := p7_a123;
1341 ddp_entry_rec.col78 := p7_a124;
1342 ddp_entry_rec.col79 := p7_a125;
1343 ddp_entry_rec.col80 := p7_a126;
1344 ddp_entry_rec.col81 := p7_a127;
1345 ddp_entry_rec.col82 := p7_a128;
1346 ddp_entry_rec.col83 := p7_a129;
1347 ddp_entry_rec.col84 := p7_a130;
1348 ddp_entry_rec.col85 := p7_a131;
1349 ddp_entry_rec.col86 := p7_a132;
1350 ddp_entry_rec.col87 := p7_a133;
1351 ddp_entry_rec.col88 := p7_a134;
1352 ddp_entry_rec.col89 := p7_a135;
1353 ddp_entry_rec.col90 := p7_a136;
1354 ddp_entry_rec.col91 := p7_a137;
1355 ddp_entry_rec.col92 := p7_a138;
1356 ddp_entry_rec.col93 := p7_a139;
1357 ddp_entry_rec.col94 := p7_a140;
1358 ddp_entry_rec.col95 := p7_a141;
1359 ddp_entry_rec.col96 := p7_a142;
1360 ddp_entry_rec.col97 := p7_a143;
1361 ddp_entry_rec.col98 := p7_a144;
1362 ddp_entry_rec.col99 := p7_a145;
1363 ddp_entry_rec.col100 := p7_a146;
1364 ddp_entry_rec.col101 := p7_a147;
1365 ddp_entry_rec.col102 := p7_a148;
1366 ddp_entry_rec.col103 := p7_a149;
1367 ddp_entry_rec.col104 := p7_a150;
1368 ddp_entry_rec.col105 := p7_a151;
1369 ddp_entry_rec.col106 := p7_a152;
1370 ddp_entry_rec.col107 := p7_a153;
1371 ddp_entry_rec.col108 := p7_a154;
1372 ddp_entry_rec.col109 := p7_a155;
1373 ddp_entry_rec.col110 := p7_a156;
1374 ddp_entry_rec.col111 := p7_a157;
1375 ddp_entry_rec.col112 := p7_a158;
1376 ddp_entry_rec.col113 := p7_a159;
1377 ddp_entry_rec.col114 := p7_a160;
1378 ddp_entry_rec.col115 := p7_a161;
1379 ddp_entry_rec.col116 := p7_a162;
1380 ddp_entry_rec.col117 := p7_a163;
1381 ddp_entry_rec.col118 := p7_a164;
1382 ddp_entry_rec.col119 := p7_a165;
1383 ddp_entry_rec.col120 := p7_a166;
1384 ddp_entry_rec.col121 := p7_a167;
1385 ddp_entry_rec.col122 := p7_a168;
1386 ddp_entry_rec.col123 := p7_a169;
1387 ddp_entry_rec.col124 := p7_a170;
1388 ddp_entry_rec.col125 := p7_a171;
1389 ddp_entry_rec.col126 := p7_a172;
1390 ddp_entry_rec.col127 := p7_a173;
1391 ddp_entry_rec.col128 := p7_a174;
1392 ddp_entry_rec.col129 := p7_a175;
1393 ddp_entry_rec.col130 := p7_a176;
1394 ddp_entry_rec.col131 := p7_a177;
1395 ddp_entry_rec.col132 := p7_a178;
1396 ddp_entry_rec.col133 := p7_a179;
1397 ddp_entry_rec.col134 := p7_a180;
1398 ddp_entry_rec.col135 := p7_a181;
1399 ddp_entry_rec.col136 := p7_a182;
1400 ddp_entry_rec.col137 := p7_a183;
1401 ddp_entry_rec.col138 := p7_a184;
1402 ddp_entry_rec.col139 := p7_a185;
1403 ddp_entry_rec.col140 := p7_a186;
1404 ddp_entry_rec.col141 := p7_a187;
1405 ddp_entry_rec.col142 := p7_a188;
1406 ddp_entry_rec.col143 := p7_a189;
1407 ddp_entry_rec.col144 := p7_a190;
1408 ddp_entry_rec.col145 := p7_a191;
1409 ddp_entry_rec.col146 := p7_a192;
1410 ddp_entry_rec.col147 := p7_a193;
1411 ddp_entry_rec.col148 := p7_a194;
1412 ddp_entry_rec.col149 := p7_a195;
1413 ddp_entry_rec.col150 := p7_a196;
1414 ddp_entry_rec.col151 := p7_a197;
1415 ddp_entry_rec.col152 := p7_a198;
1416 ddp_entry_rec.col153 := p7_a199;
1417 ddp_entry_rec.col154 := p7_a200;
1418 ddp_entry_rec.col155 := p7_a201;
1419 ddp_entry_rec.col156 := p7_a202;
1420 ddp_entry_rec.col157 := p7_a203;
1421 ddp_entry_rec.col158 := p7_a204;
1422 ddp_entry_rec.col159 := p7_a205;
1423 ddp_entry_rec.col160 := p7_a206;
1424 ddp_entry_rec.col161 := p7_a207;
1425 ddp_entry_rec.col162 := p7_a208;
1426 ddp_entry_rec.col163 := p7_a209;
1427 ddp_entry_rec.col164 := p7_a210;
1428 ddp_entry_rec.col165 := p7_a211;
1429 ddp_entry_rec.col166 := p7_a212;
1430 ddp_entry_rec.col167 := p7_a213;
1431 ddp_entry_rec.col168 := p7_a214;
1432 ddp_entry_rec.col169 := p7_a215;
1433 ddp_entry_rec.col170 := p7_a216;
1434 ddp_entry_rec.col171 := p7_a217;
1435 ddp_entry_rec.col172 := p7_a218;
1436 ddp_entry_rec.col173 := p7_a219;
1437 ddp_entry_rec.col174 := p7_a220;
1438 ddp_entry_rec.col175 := p7_a221;
1439 ddp_entry_rec.col176 := p7_a222;
1440 ddp_entry_rec.col177 := p7_a223;
1441 ddp_entry_rec.col178 := p7_a224;
1442 ddp_entry_rec.col179 := p7_a225;
1443 ddp_entry_rec.col180 := p7_a226;
1444 ddp_entry_rec.col181 := p7_a227;
1445 ddp_entry_rec.col182 := p7_a228;
1446 ddp_entry_rec.col183 := p7_a229;
1447 ddp_entry_rec.col184 := p7_a230;
1448 ddp_entry_rec.col185 := p7_a231;
1449 ddp_entry_rec.col186 := p7_a232;
1450 ddp_entry_rec.col187 := p7_a233;
1451 ddp_entry_rec.col188 := p7_a234;
1452 ddp_entry_rec.col189 := p7_a235;
1453 ddp_entry_rec.col190 := p7_a236;
1454 ddp_entry_rec.col191 := p7_a237;
1455 ddp_entry_rec.col192 := p7_a238;
1456 ddp_entry_rec.col193 := p7_a239;
1457 ddp_entry_rec.col194 := p7_a240;
1458 ddp_entry_rec.col195 := p7_a241;
1459 ddp_entry_rec.col196 := p7_a242;
1460 ddp_entry_rec.col197 := p7_a243;
1461 ddp_entry_rec.col198 := p7_a244;
1462 ddp_entry_rec.col199 := p7_a245;
1463 ddp_entry_rec.col200 := p7_a246;
1464 ddp_entry_rec.col201 := p7_a247;
1465 ddp_entry_rec.col202 := p7_a248;
1466 ddp_entry_rec.col203 := p7_a249;
1467 ddp_entry_rec.col204 := p7_a250;
1468 ddp_entry_rec.col205 := p7_a251;
1469 ddp_entry_rec.col206 := p7_a252;
1470 ddp_entry_rec.col207 := p7_a253;
1471 ddp_entry_rec.col208 := p7_a254;
1472 ddp_entry_rec.col209 := p7_a255;
1473 ddp_entry_rec.col210 := p7_a256;
1474 ddp_entry_rec.col211 := p7_a257;
1475 ddp_entry_rec.col212 := p7_a258;
1476 ddp_entry_rec.col213 := p7_a259;
1477 ddp_entry_rec.col214 := p7_a260;
1478 ddp_entry_rec.col215 := p7_a261;
1479 ddp_entry_rec.col216 := p7_a262;
1480 ddp_entry_rec.col217 := p7_a263;
1481 ddp_entry_rec.col218 := p7_a264;
1482 ddp_entry_rec.col219 := p7_a265;
1483 ddp_entry_rec.col220 := p7_a266;
1484 ddp_entry_rec.col221 := p7_a267;
1485 ddp_entry_rec.col222 := p7_a268;
1486 ddp_entry_rec.col223 := p7_a269;
1487 ddp_entry_rec.col224 := p7_a270;
1488 ddp_entry_rec.col225 := p7_a271;
1489 ddp_entry_rec.col226 := p7_a272;
1490 ddp_entry_rec.col227 := p7_a273;
1491 ddp_entry_rec.col228 := p7_a274;
1492 ddp_entry_rec.col229 := p7_a275;
1493 ddp_entry_rec.col230 := p7_a276;
1494 ddp_entry_rec.col231 := p7_a277;
1495 ddp_entry_rec.col232 := p7_a278;
1496 ddp_entry_rec.col233 := p7_a279;
1497 ddp_entry_rec.col234 := p7_a280;
1498 ddp_entry_rec.col235 := p7_a281;
1499 ddp_entry_rec.col236 := p7_a282;
1500 ddp_entry_rec.col237 := p7_a283;
1501 ddp_entry_rec.col238 := p7_a284;
1502 ddp_entry_rec.col239 := p7_a285;
1503 ddp_entry_rec.col240 := p7_a286;
1504 ddp_entry_rec.col241 := p7_a287;
1505 ddp_entry_rec.col242 := p7_a288;
1506 ddp_entry_rec.col243 := p7_a289;
1507 ddp_entry_rec.col244 := p7_a290;
1508 ddp_entry_rec.col245 := p7_a291;
1509 ddp_entry_rec.col246 := p7_a292;
1510 ddp_entry_rec.col247 := p7_a293;
1511 ddp_entry_rec.col248 := p7_a294;
1512 ddp_entry_rec.col249 := p7_a295;
1513 ddp_entry_rec.col250 := p7_a296;
1514 ddp_entry_rec.col251 := p7_a297;
1515 ddp_entry_rec.col252 := p7_a298;
1516 ddp_entry_rec.col253 := p7_a299;
1517 ddp_entry_rec.col254 := p7_a300;
1518 ddp_entry_rec.col255 := p7_a301;
1519 ddp_entry_rec.col256 := p7_a302;
1520 ddp_entry_rec.col257 := p7_a303;
1521 ddp_entry_rec.col258 := p7_a304;
1522 ddp_entry_rec.col259 := p7_a305;
1523 ddp_entry_rec.col260 := p7_a306;
1524 ddp_entry_rec.col261 := p7_a307;
1525 ddp_entry_rec.col262 := p7_a308;
1526 ddp_entry_rec.col263 := p7_a309;
1527 ddp_entry_rec.col264 := p7_a310;
1528 ddp_entry_rec.col265 := p7_a311;
1529 ddp_entry_rec.col266 := p7_a312;
1530 ddp_entry_rec.col267 := p7_a313;
1531 ddp_entry_rec.col268 := p7_a314;
1532 ddp_entry_rec.col269 := p7_a315;
1533 ddp_entry_rec.col270 := p7_a316;
1534 ddp_entry_rec.col271 := p7_a317;
1535 ddp_entry_rec.col272 := p7_a318;
1536 ddp_entry_rec.col273 := p7_a319;
1537 ddp_entry_rec.col274 := p7_a320;
1538 ddp_entry_rec.col275 := p7_a321;
1539 ddp_entry_rec.col276 := p7_a322;
1540 ddp_entry_rec.col277 := p7_a323;
1541 ddp_entry_rec.col278 := p7_a324;
1542 ddp_entry_rec.col279 := p7_a325;
1543 ddp_entry_rec.col280 := p7_a326;
1544 ddp_entry_rec.col281 := p7_a327;
1545 ddp_entry_rec.col282 := p7_a328;
1546 ddp_entry_rec.col283 := p7_a329;
1547 ddp_entry_rec.col284 := p7_a330;
1548 ddp_entry_rec.col285 := p7_a331;
1549 ddp_entry_rec.col286 := p7_a332;
1550 ddp_entry_rec.col287 := p7_a333;
1551 ddp_entry_rec.col288 := p7_a334;
1552 ddp_entry_rec.col289 := p7_a335;
1553 ddp_entry_rec.col290 := p7_a336;
1554 ddp_entry_rec.col291 := p7_a337;
1555 ddp_entry_rec.col292 := p7_a338;
1556 ddp_entry_rec.col293 := p7_a339;
1557 ddp_entry_rec.col294 := p7_a340;
1558 ddp_entry_rec.col295 := p7_a341;
1559 ddp_entry_rec.col296 := p7_a342;
1560 ddp_entry_rec.col297 := p7_a343;
1561 ddp_entry_rec.col298 := p7_a344;
1562 ddp_entry_rec.col299 := p7_a345;
1563 ddp_entry_rec.col300 := p7_a346;
1564 ddp_entry_rec.address_line1 := p7_a347;
1565 ddp_entry_rec.address_line2 := p7_a348;
1566 ddp_entry_rec.callback_flag := p7_a349;
1567 ddp_entry_rec.city := p7_a350;
1568 ddp_entry_rec.country := p7_a351;
1569 ddp_entry_rec.do_not_use_flag := p7_a352;
1570 ddp_entry_rec.do_not_use_reason := p7_a353;
1571 ddp_entry_rec.email_address := p7_a354;
1572 ddp_entry_rec.fax := p7_a355;
1573 ddp_entry_rec.phone := p7_a356;
1574 ddp_entry_rec.record_out_flag := p7_a357;
1575 ddp_entry_rec.state := p7_a358;
1576 ddp_entry_rec.suffix := p7_a359;
1577 ddp_entry_rec.title := p7_a360;
1578 ddp_entry_rec.usage_restriction := p7_a361;
1579 ddp_entry_rec.zipcode := p7_a362;
1580 ddp_entry_rec.curr_cp_country_code := p7_a363;
1581 ddp_entry_rec.curr_cp_phone_number := p7_a364;
1582 ddp_entry_rec.curr_cp_raw_phone_number := p7_a365;
1583 ddp_entry_rec.curr_cp_area_code := rosetta_g_miss_num_map(p7_a366);
1584 ddp_entry_rec.curr_cp_id := rosetta_g_miss_num_map(p7_a367);
1585 ddp_entry_rec.curr_cp_index := rosetta_g_miss_num_map(p7_a368);
1586 ddp_entry_rec.curr_cp_time_zone := rosetta_g_miss_num_map(p7_a369);
1587 ddp_entry_rec.curr_cp_time_zone_aux := rosetta_g_miss_num_map(p7_a370);
1588 ddp_entry_rec.imp_source_line_id := rosetta_g_miss_num_map(p7_a371);
1589 ddp_entry_rec.next_call_time := rosetta_g_miss_date_in_map(p7_a372);
1590 ddp_entry_rec.record_release_time := rosetta_g_miss_date_in_map(p7_a373);
1591 ddp_entry_rec.party_id := rosetta_g_miss_num_map(p7_a374);
1592 ddp_entry_rec.parent_party_id := rosetta_g_miss_num_map(p7_a375);
1593
1594 -- here's the delegated call to the old PL/SQL routine
1595 ams_listentry_pub.update_listentry(p_api_version,
1596 p_init_msg_list,
1597 p_commit,
1598 p_validation_level,
1599 x_return_status,
1600 x_msg_count,
1601 x_msg_data,
1602 ddp_entry_rec);
1603
1604 -- copy data back from the local OUT or IN-OUT args, if any
1605
1606
1607
1608
1609
1610
1611
1612 end;
1613
1614 procedure validate_listentry(p_api_version NUMBER
1615 , p_init_msg_list VARCHAR2
1616 , p_validation_level NUMBER
1617 , x_return_status OUT NOCOPY VARCHAR2
1618 , x_msg_count OUT NOCOPY NUMBER
1619 , x_msg_data OUT NOCOPY VARCHAR2
1620 , p6_a0 NUMBER := 0-1962.0724
1621 , p6_a1 NUMBER := 0-1962.0724
1622 , p6_a2 DATE := fnd_api.g_miss_date
1623 , p6_a3 NUMBER := 0-1962.0724
1624 , p6_a4 DATE := fnd_api.g_miss_date
1625 , p6_a5 NUMBER := 0-1962.0724
1626 , p6_a6 NUMBER := 0-1962.0724
1627 , p6_a7 NUMBER := 0-1962.0724
1628 , p6_a8 NUMBER := 0-1962.0724
1629 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1630 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1631 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1632 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1633 , p6_a13 NUMBER := 0-1962.0724
1634 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1635 , p6_a15 NUMBER := 0-1962.0724
1636 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1637 , p6_a17 NUMBER := 0-1962.0724
1638 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1639 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1640 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1641 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1642 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1643 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
1644 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
1645 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
1646 , p6_a26 NUMBER := 0-1962.0724
1647 , p6_a27 NUMBER := 0-1962.0724
1648 , p6_a28 NUMBER := 0-1962.0724
1649 , p6_a29 NUMBER := 0-1962.0724
1650 , p6_a30 NUMBER := 0-1962.0724
1651 , p6_a31 NUMBER := 0-1962.0724
1652 , p6_a32 NUMBER := 0-1962.0724
1653 , p6_a33 NUMBER := 0-1962.0724
1654 , p6_a34 NUMBER := 0-1962.0724
1655 , p6_a35 VARCHAR2 := fnd_api.g_miss_char
1656 , p6_a36 VARCHAR2 := fnd_api.g_miss_char
1657 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
1658 , p6_a38 NUMBER := 0-1962.0724
1659 , p6_a39 VARCHAR2 := fnd_api.g_miss_char
1660 , p6_a40 NUMBER := 0-1962.0724
1661 , p6_a41 NUMBER := 0-1962.0724
1662 , p6_a42 NUMBER := 0-1962.0724
1663 , p6_a43 NUMBER := 0-1962.0724
1664 , p6_a44 VARCHAR2 := fnd_api.g_miss_char
1665 , p6_a45 VARCHAR2 := fnd_api.g_miss_char
1666 , p6_a46 VARCHAR2 := fnd_api.g_miss_char
1667 , p6_a47 VARCHAR2 := fnd_api.g_miss_char
1668 , p6_a48 VARCHAR2 := fnd_api.g_miss_char
1669 , p6_a49 VARCHAR2 := fnd_api.g_miss_char
1670 , p6_a50 VARCHAR2 := fnd_api.g_miss_char
1671 , p6_a51 VARCHAR2 := fnd_api.g_miss_char
1672 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
1673 , p6_a53 VARCHAR2 := fnd_api.g_miss_char
1674 , p6_a54 VARCHAR2 := fnd_api.g_miss_char
1675 , p6_a55 VARCHAR2 := fnd_api.g_miss_char
1676 , p6_a56 VARCHAR2 := fnd_api.g_miss_char
1677 , p6_a57 VARCHAR2 := fnd_api.g_miss_char
1678 , p6_a58 VARCHAR2 := fnd_api.g_miss_char
1679 , p6_a59 VARCHAR2 := fnd_api.g_miss_char
1680 , p6_a60 VARCHAR2 := fnd_api.g_miss_char
1681 , p6_a61 VARCHAR2 := fnd_api.g_miss_char
1682 , p6_a62 VARCHAR2 := fnd_api.g_miss_char
1683 , p6_a63 VARCHAR2 := fnd_api.g_miss_char
1684 , p6_a64 VARCHAR2 := fnd_api.g_miss_char
1685 , p6_a65 VARCHAR2 := fnd_api.g_miss_char
1686 , p6_a66 VARCHAR2 := fnd_api.g_miss_char
1687 , p6_a67 VARCHAR2 := fnd_api.g_miss_char
1688 , p6_a68 VARCHAR2 := fnd_api.g_miss_char
1689 , p6_a69 VARCHAR2 := fnd_api.g_miss_char
1690 , p6_a70 VARCHAR2 := fnd_api.g_miss_char
1691 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
1692 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
1693 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
1694 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
1695 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
1696 , p6_a76 VARCHAR2 := fnd_api.g_miss_char
1697 , p6_a77 VARCHAR2 := fnd_api.g_miss_char
1698 , p6_a78 VARCHAR2 := fnd_api.g_miss_char
1699 , p6_a79 VARCHAR2 := fnd_api.g_miss_char
1700 , p6_a80 VARCHAR2 := fnd_api.g_miss_char
1701 , p6_a81 VARCHAR2 := fnd_api.g_miss_char
1702 , p6_a82 VARCHAR2 := fnd_api.g_miss_char
1703 , p6_a83 VARCHAR2 := fnd_api.g_miss_char
1704 , p6_a84 VARCHAR2 := fnd_api.g_miss_char
1705 , p6_a85 VARCHAR2 := fnd_api.g_miss_char
1706 , p6_a86 VARCHAR2 := fnd_api.g_miss_char
1707 , p6_a87 VARCHAR2 := fnd_api.g_miss_char
1708 , p6_a88 VARCHAR2 := fnd_api.g_miss_char
1709 , p6_a89 VARCHAR2 := fnd_api.g_miss_char
1710 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
1711 , p6_a91 VARCHAR2 := fnd_api.g_miss_char
1712 , p6_a92 VARCHAR2 := fnd_api.g_miss_char
1713 , p6_a93 VARCHAR2 := fnd_api.g_miss_char
1714 , p6_a94 VARCHAR2 := fnd_api.g_miss_char
1715 , p6_a95 VARCHAR2 := fnd_api.g_miss_char
1716 , p6_a96 VARCHAR2 := fnd_api.g_miss_char
1717 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
1718 , p6_a98 VARCHAR2 := fnd_api.g_miss_char
1719 , p6_a99 VARCHAR2 := fnd_api.g_miss_char
1720 , p6_a100 VARCHAR2 := fnd_api.g_miss_char
1721 , p6_a101 VARCHAR2 := fnd_api.g_miss_char
1722 , p6_a102 VARCHAR2 := fnd_api.g_miss_char
1723 , p6_a103 VARCHAR2 := fnd_api.g_miss_char
1724 , p6_a104 VARCHAR2 := fnd_api.g_miss_char
1725 , p6_a105 VARCHAR2 := fnd_api.g_miss_char
1726 , p6_a106 VARCHAR2 := fnd_api.g_miss_char
1727 , p6_a107 VARCHAR2 := fnd_api.g_miss_char
1728 , p6_a108 VARCHAR2 := fnd_api.g_miss_char
1729 , p6_a109 VARCHAR2 := fnd_api.g_miss_char
1730 , p6_a110 VARCHAR2 := fnd_api.g_miss_char
1731 , p6_a111 VARCHAR2 := fnd_api.g_miss_char
1732 , p6_a112 VARCHAR2 := fnd_api.g_miss_char
1733 , p6_a113 VARCHAR2 := fnd_api.g_miss_char
1734 , p6_a114 VARCHAR2 := fnd_api.g_miss_char
1735 , p6_a115 VARCHAR2 := fnd_api.g_miss_char
1736 , p6_a116 VARCHAR2 := fnd_api.g_miss_char
1737 , p6_a117 VARCHAR2 := fnd_api.g_miss_char
1738 , p6_a118 VARCHAR2 := fnd_api.g_miss_char
1739 , p6_a119 VARCHAR2 := fnd_api.g_miss_char
1740 , p6_a120 VARCHAR2 := fnd_api.g_miss_char
1741 , p6_a121 VARCHAR2 := fnd_api.g_miss_char
1742 , p6_a122 VARCHAR2 := fnd_api.g_miss_char
1743 , p6_a123 VARCHAR2 := fnd_api.g_miss_char
1744 , p6_a124 VARCHAR2 := fnd_api.g_miss_char
1745 , p6_a125 VARCHAR2 := fnd_api.g_miss_char
1746 , p6_a126 VARCHAR2 := fnd_api.g_miss_char
1747 , p6_a127 VARCHAR2 := fnd_api.g_miss_char
1748 , p6_a128 VARCHAR2 := fnd_api.g_miss_char
1749 , p6_a129 VARCHAR2 := fnd_api.g_miss_char
1750 , p6_a130 VARCHAR2 := fnd_api.g_miss_char
1751 , p6_a131 VARCHAR2 := fnd_api.g_miss_char
1752 , p6_a132 VARCHAR2 := fnd_api.g_miss_char
1753 , p6_a133 VARCHAR2 := fnd_api.g_miss_char
1754 , p6_a134 VARCHAR2 := fnd_api.g_miss_char
1755 , p6_a135 VARCHAR2 := fnd_api.g_miss_char
1756 , p6_a136 VARCHAR2 := fnd_api.g_miss_char
1757 , p6_a137 VARCHAR2 := fnd_api.g_miss_char
1758 , p6_a138 VARCHAR2 := fnd_api.g_miss_char
1759 , p6_a139 VARCHAR2 := fnd_api.g_miss_char
1760 , p6_a140 VARCHAR2 := fnd_api.g_miss_char
1761 , p6_a141 VARCHAR2 := fnd_api.g_miss_char
1762 , p6_a142 VARCHAR2 := fnd_api.g_miss_char
1763 , p6_a143 VARCHAR2 := fnd_api.g_miss_char
1764 , p6_a144 VARCHAR2 := fnd_api.g_miss_char
1765 , p6_a145 VARCHAR2 := fnd_api.g_miss_char
1766 , p6_a146 VARCHAR2 := fnd_api.g_miss_char
1767 , p6_a147 VARCHAR2 := fnd_api.g_miss_char
1768 , p6_a148 VARCHAR2 := fnd_api.g_miss_char
1769 , p6_a149 VARCHAR2 := fnd_api.g_miss_char
1770 , p6_a150 VARCHAR2 := fnd_api.g_miss_char
1771 , p6_a151 VARCHAR2 := fnd_api.g_miss_char
1772 , p6_a152 VARCHAR2 := fnd_api.g_miss_char
1773 , p6_a153 VARCHAR2 := fnd_api.g_miss_char
1774 , p6_a154 VARCHAR2 := fnd_api.g_miss_char
1775 , p6_a155 VARCHAR2 := fnd_api.g_miss_char
1776 , p6_a156 VARCHAR2 := fnd_api.g_miss_char
1777 , p6_a157 VARCHAR2 := fnd_api.g_miss_char
1778 , p6_a158 VARCHAR2 := fnd_api.g_miss_char
1779 , p6_a159 VARCHAR2 := fnd_api.g_miss_char
1780 , p6_a160 VARCHAR2 := fnd_api.g_miss_char
1781 , p6_a161 VARCHAR2 := fnd_api.g_miss_char
1782 , p6_a162 VARCHAR2 := fnd_api.g_miss_char
1783 , p6_a163 VARCHAR2 := fnd_api.g_miss_char
1784 , p6_a164 VARCHAR2 := fnd_api.g_miss_char
1785 , p6_a165 VARCHAR2 := fnd_api.g_miss_char
1786 , p6_a166 VARCHAR2 := fnd_api.g_miss_char
1787 , p6_a167 VARCHAR2 := fnd_api.g_miss_char
1788 , p6_a168 VARCHAR2 := fnd_api.g_miss_char
1789 , p6_a169 VARCHAR2 := fnd_api.g_miss_char
1790 , p6_a170 VARCHAR2 := fnd_api.g_miss_char
1791 , p6_a171 VARCHAR2 := fnd_api.g_miss_char
1792 , p6_a172 VARCHAR2 := fnd_api.g_miss_char
1793 , p6_a173 VARCHAR2 := fnd_api.g_miss_char
1794 , p6_a174 VARCHAR2 := fnd_api.g_miss_char
1795 , p6_a175 VARCHAR2 := fnd_api.g_miss_char
1796 , p6_a176 VARCHAR2 := fnd_api.g_miss_char
1797 , p6_a177 VARCHAR2 := fnd_api.g_miss_char
1798 , p6_a178 VARCHAR2 := fnd_api.g_miss_char
1799 , p6_a179 VARCHAR2 := fnd_api.g_miss_char
1800 , p6_a180 VARCHAR2 := fnd_api.g_miss_char
1801 , p6_a181 VARCHAR2 := fnd_api.g_miss_char
1802 , p6_a182 VARCHAR2 := fnd_api.g_miss_char
1803 , p6_a183 VARCHAR2 := fnd_api.g_miss_char
1804 , p6_a184 VARCHAR2 := fnd_api.g_miss_char
1805 , p6_a185 VARCHAR2 := fnd_api.g_miss_char
1806 , p6_a186 VARCHAR2 := fnd_api.g_miss_char
1807 , p6_a187 VARCHAR2 := fnd_api.g_miss_char
1808 , p6_a188 VARCHAR2 := fnd_api.g_miss_char
1809 , p6_a189 VARCHAR2 := fnd_api.g_miss_char
1810 , p6_a190 VARCHAR2 := fnd_api.g_miss_char
1811 , p6_a191 VARCHAR2 := fnd_api.g_miss_char
1812 , p6_a192 VARCHAR2 := fnd_api.g_miss_char
1813 , p6_a193 VARCHAR2 := fnd_api.g_miss_char
1814 , p6_a194 VARCHAR2 := fnd_api.g_miss_char
1815 , p6_a195 VARCHAR2 := fnd_api.g_miss_char
1816 , p6_a196 VARCHAR2 := fnd_api.g_miss_char
1817 , p6_a197 VARCHAR2 := fnd_api.g_miss_char
1818 , p6_a198 VARCHAR2 := fnd_api.g_miss_char
1819 , p6_a199 VARCHAR2 := fnd_api.g_miss_char
1820 , p6_a200 VARCHAR2 := fnd_api.g_miss_char
1821 , p6_a201 VARCHAR2 := fnd_api.g_miss_char
1822 , p6_a202 VARCHAR2 := fnd_api.g_miss_char
1823 , p6_a203 VARCHAR2 := fnd_api.g_miss_char
1824 , p6_a204 VARCHAR2 := fnd_api.g_miss_char
1825 , p6_a205 VARCHAR2 := fnd_api.g_miss_char
1826 , p6_a206 VARCHAR2 := fnd_api.g_miss_char
1827 , p6_a207 VARCHAR2 := fnd_api.g_miss_char
1828 , p6_a208 VARCHAR2 := fnd_api.g_miss_char
1829 , p6_a209 VARCHAR2 := fnd_api.g_miss_char
1830 , p6_a210 VARCHAR2 := fnd_api.g_miss_char
1831 , p6_a211 VARCHAR2 := fnd_api.g_miss_char
1832 , p6_a212 VARCHAR2 := fnd_api.g_miss_char
1833 , p6_a213 VARCHAR2 := fnd_api.g_miss_char
1834 , p6_a214 VARCHAR2 := fnd_api.g_miss_char
1835 , p6_a215 VARCHAR2 := fnd_api.g_miss_char
1836 , p6_a216 VARCHAR2 := fnd_api.g_miss_char
1837 , p6_a217 VARCHAR2 := fnd_api.g_miss_char
1838 , p6_a218 VARCHAR2 := fnd_api.g_miss_char
1839 , p6_a219 VARCHAR2 := fnd_api.g_miss_char
1840 , p6_a220 VARCHAR2 := fnd_api.g_miss_char
1841 , p6_a221 VARCHAR2 := fnd_api.g_miss_char
1842 , p6_a222 VARCHAR2 := fnd_api.g_miss_char
1843 , p6_a223 VARCHAR2 := fnd_api.g_miss_char
1844 , p6_a224 VARCHAR2 := fnd_api.g_miss_char
1845 , p6_a225 VARCHAR2 := fnd_api.g_miss_char
1846 , p6_a226 VARCHAR2 := fnd_api.g_miss_char
1847 , p6_a227 VARCHAR2 := fnd_api.g_miss_char
1848 , p6_a228 VARCHAR2 := fnd_api.g_miss_char
1849 , p6_a229 VARCHAR2 := fnd_api.g_miss_char
1850 , p6_a230 VARCHAR2 := fnd_api.g_miss_char
1851 , p6_a231 VARCHAR2 := fnd_api.g_miss_char
1852 , p6_a232 VARCHAR2 := fnd_api.g_miss_char
1853 , p6_a233 VARCHAR2 := fnd_api.g_miss_char
1854 , p6_a234 VARCHAR2 := fnd_api.g_miss_char
1855 , p6_a235 VARCHAR2 := fnd_api.g_miss_char
1856 , p6_a236 VARCHAR2 := fnd_api.g_miss_char
1857 , p6_a237 VARCHAR2 := fnd_api.g_miss_char
1858 , p6_a238 VARCHAR2 := fnd_api.g_miss_char
1859 , p6_a239 VARCHAR2 := fnd_api.g_miss_char
1860 , p6_a240 VARCHAR2 := fnd_api.g_miss_char
1861 , p6_a241 VARCHAR2 := fnd_api.g_miss_char
1862 , p6_a242 VARCHAR2 := fnd_api.g_miss_char
1863 , p6_a243 VARCHAR2 := fnd_api.g_miss_char
1864 , p6_a244 VARCHAR2 := fnd_api.g_miss_char
1865 , p6_a245 VARCHAR2 := fnd_api.g_miss_char
1866 , p6_a246 VARCHAR2 := fnd_api.g_miss_char
1867 , p6_a247 VARCHAR2 := fnd_api.g_miss_char
1868 , p6_a248 VARCHAR2 := fnd_api.g_miss_char
1869 , p6_a249 VARCHAR2 := fnd_api.g_miss_char
1870 , p6_a250 VARCHAR2 := fnd_api.g_miss_char
1871 , p6_a251 VARCHAR2 := fnd_api.g_miss_char
1872 , p6_a252 VARCHAR2 := fnd_api.g_miss_char
1873 , p6_a253 VARCHAR2 := fnd_api.g_miss_char
1874 , p6_a254 VARCHAR2 := fnd_api.g_miss_char
1875 , p6_a255 VARCHAR2 := fnd_api.g_miss_char
1876 , p6_a256 VARCHAR2 := fnd_api.g_miss_char
1877 , p6_a257 VARCHAR2 := fnd_api.g_miss_char
1878 , p6_a258 VARCHAR2 := fnd_api.g_miss_char
1879 , p6_a259 VARCHAR2 := fnd_api.g_miss_char
1880 , p6_a260 VARCHAR2 := fnd_api.g_miss_char
1881 , p6_a261 VARCHAR2 := fnd_api.g_miss_char
1882 , p6_a262 VARCHAR2 := fnd_api.g_miss_char
1883 , p6_a263 VARCHAR2 := fnd_api.g_miss_char
1884 , p6_a264 VARCHAR2 := fnd_api.g_miss_char
1885 , p6_a265 VARCHAR2 := fnd_api.g_miss_char
1886 , p6_a266 VARCHAR2 := fnd_api.g_miss_char
1887 , p6_a267 VARCHAR2 := fnd_api.g_miss_char
1888 , p6_a268 VARCHAR2 := fnd_api.g_miss_char
1889 , p6_a269 VARCHAR2 := fnd_api.g_miss_char
1890 , p6_a270 VARCHAR2 := fnd_api.g_miss_char
1891 , p6_a271 VARCHAR2 := fnd_api.g_miss_char
1892 , p6_a272 VARCHAR2 := fnd_api.g_miss_char
1893 , p6_a273 VARCHAR2 := fnd_api.g_miss_char
1894 , p6_a274 VARCHAR2 := fnd_api.g_miss_char
1895 , p6_a275 VARCHAR2 := fnd_api.g_miss_char
1896 , p6_a276 VARCHAR2 := fnd_api.g_miss_char
1897 , p6_a277 VARCHAR2 := fnd_api.g_miss_char
1898 , p6_a278 VARCHAR2 := fnd_api.g_miss_char
1899 , p6_a279 VARCHAR2 := fnd_api.g_miss_char
1900 , p6_a280 VARCHAR2 := fnd_api.g_miss_char
1901 , p6_a281 VARCHAR2 := fnd_api.g_miss_char
1902 , p6_a282 VARCHAR2 := fnd_api.g_miss_char
1903 , p6_a283 VARCHAR2 := fnd_api.g_miss_char
1904 , p6_a284 VARCHAR2 := fnd_api.g_miss_char
1905 , p6_a285 VARCHAR2 := fnd_api.g_miss_char
1906 , p6_a286 VARCHAR2 := fnd_api.g_miss_char
1907 , p6_a287 VARCHAR2 := fnd_api.g_miss_char
1908 , p6_a288 VARCHAR2 := fnd_api.g_miss_char
1909 , p6_a289 VARCHAR2 := fnd_api.g_miss_char
1910 , p6_a290 VARCHAR2 := fnd_api.g_miss_char
1911 , p6_a291 VARCHAR2 := fnd_api.g_miss_char
1912 , p6_a292 VARCHAR2 := fnd_api.g_miss_char
1913 , p6_a293 VARCHAR2 := fnd_api.g_miss_char
1914 , p6_a294 VARCHAR2 := fnd_api.g_miss_char
1915 , p6_a295 VARCHAR2 := fnd_api.g_miss_char
1916 , p6_a296 VARCHAR2 := fnd_api.g_miss_char
1917 , p6_a297 VARCHAR2 := fnd_api.g_miss_char
1918 , p6_a298 VARCHAR2 := fnd_api.g_miss_char
1919 , p6_a299 VARCHAR2 := fnd_api.g_miss_char
1920 , p6_a300 VARCHAR2 := fnd_api.g_miss_char
1921 , p6_a301 VARCHAR2 := fnd_api.g_miss_char
1922 , p6_a302 VARCHAR2 := fnd_api.g_miss_char
1923 , p6_a303 VARCHAR2 := fnd_api.g_miss_char
1924 , p6_a304 VARCHAR2 := fnd_api.g_miss_char
1925 , p6_a305 VARCHAR2 := fnd_api.g_miss_char
1926 , p6_a306 VARCHAR2 := fnd_api.g_miss_char
1927 , p6_a307 VARCHAR2 := fnd_api.g_miss_char
1928 , p6_a308 VARCHAR2 := fnd_api.g_miss_char
1929 , p6_a309 VARCHAR2 := fnd_api.g_miss_char
1930 , p6_a310 VARCHAR2 := fnd_api.g_miss_char
1931 , p6_a311 VARCHAR2 := fnd_api.g_miss_char
1932 , p6_a312 VARCHAR2 := fnd_api.g_miss_char
1933 , p6_a313 VARCHAR2 := fnd_api.g_miss_char
1934 , p6_a314 VARCHAR2 := fnd_api.g_miss_char
1935 , p6_a315 VARCHAR2 := fnd_api.g_miss_char
1936 , p6_a316 VARCHAR2 := fnd_api.g_miss_char
1937 , p6_a317 VARCHAR2 := fnd_api.g_miss_char
1938 , p6_a318 VARCHAR2 := fnd_api.g_miss_char
1939 , p6_a319 VARCHAR2 := fnd_api.g_miss_char
1940 , p6_a320 VARCHAR2 := fnd_api.g_miss_char
1941 , p6_a321 VARCHAR2 := fnd_api.g_miss_char
1942 , p6_a322 VARCHAR2 := fnd_api.g_miss_char
1943 , p6_a323 VARCHAR2 := fnd_api.g_miss_char
1944 , p6_a324 VARCHAR2 := fnd_api.g_miss_char
1945 , p6_a325 VARCHAR2 := fnd_api.g_miss_char
1946 , p6_a326 VARCHAR2 := fnd_api.g_miss_char
1947 , p6_a327 VARCHAR2 := fnd_api.g_miss_char
1948 , p6_a328 VARCHAR2 := fnd_api.g_miss_char
1949 , p6_a329 VARCHAR2 := fnd_api.g_miss_char
1950 , p6_a330 VARCHAR2 := fnd_api.g_miss_char
1951 , p6_a331 VARCHAR2 := fnd_api.g_miss_char
1952 , p6_a332 VARCHAR2 := fnd_api.g_miss_char
1953 , p6_a333 VARCHAR2 := fnd_api.g_miss_char
1954 , p6_a334 VARCHAR2 := fnd_api.g_miss_char
1955 , p6_a335 VARCHAR2 := fnd_api.g_miss_char
1956 , p6_a336 VARCHAR2 := fnd_api.g_miss_char
1957 , p6_a337 VARCHAR2 := fnd_api.g_miss_char
1958 , p6_a338 VARCHAR2 := fnd_api.g_miss_char
1959 , p6_a339 VARCHAR2 := fnd_api.g_miss_char
1960 , p6_a340 VARCHAR2 := fnd_api.g_miss_char
1961 , p6_a341 VARCHAR2 := fnd_api.g_miss_char
1962 , p6_a342 VARCHAR2 := fnd_api.g_miss_char
1963 , p6_a343 VARCHAR2 := fnd_api.g_miss_char
1964 , p6_a344 VARCHAR2 := fnd_api.g_miss_char
1965 , p6_a345 VARCHAR2 := fnd_api.g_miss_char
1966 , p6_a346 VARCHAR2 := fnd_api.g_miss_char
1967 , p6_a347 VARCHAR2 := fnd_api.g_miss_char
1968 , p6_a348 VARCHAR2 := fnd_api.g_miss_char
1969 , p6_a349 VARCHAR2 := fnd_api.g_miss_char
1970 , p6_a350 VARCHAR2 := fnd_api.g_miss_char
1971 , p6_a351 VARCHAR2 := fnd_api.g_miss_char
1972 , p6_a352 VARCHAR2 := fnd_api.g_miss_char
1973 , p6_a353 VARCHAR2 := fnd_api.g_miss_char
1974 , p6_a354 VARCHAR2 := fnd_api.g_miss_char
1975 , p6_a355 VARCHAR2 := fnd_api.g_miss_char
1976 , p6_a356 VARCHAR2 := fnd_api.g_miss_char
1977 , p6_a357 VARCHAR2 := fnd_api.g_miss_char
1978 , p6_a358 VARCHAR2 := fnd_api.g_miss_char
1979 , p6_a359 VARCHAR2 := fnd_api.g_miss_char
1980 , p6_a360 VARCHAR2 := fnd_api.g_miss_char
1981 , p6_a361 VARCHAR2 := fnd_api.g_miss_char
1982 , p6_a362 VARCHAR2 := fnd_api.g_miss_char
1983 , p6_a363 VARCHAR2 := fnd_api.g_miss_char
1984 , p6_a364 VARCHAR2 := fnd_api.g_miss_char
1985 , p6_a365 VARCHAR2 := fnd_api.g_miss_char
1986 , p6_a366 NUMBER := 0-1962.0724
1987 , p6_a367 NUMBER := 0-1962.0724
1988 , p6_a368 NUMBER := 0-1962.0724
1989 , p6_a369 NUMBER := 0-1962.0724
1990 , p6_a370 NUMBER := 0-1962.0724
1991 , p6_a371 NUMBER := 0-1962.0724
1992 , p6_a372 DATE := fnd_api.g_miss_date
1993 , p6_a373 DATE := fnd_api.g_miss_date
1994 , p6_a374 NUMBER := 0-1962.0724
1995 , p6_a375 NUMBER := 0-1962.0724
1996 )
1997 as
1998 ddp_entry_rec ams_listentry_pvt.entry_rec_type;
1999 ddindx binary_integer; indx binary_integer;
2000 begin
2001
2002 -- copy data to the local IN or IN-OUT args, if any
2003
2004
2005
2006
2007
2008
2009 ddp_entry_rec.list_entry_id := rosetta_g_miss_num_map(p6_a0);
2010 ddp_entry_rec.list_header_id := rosetta_g_miss_num_map(p6_a1);
2011 ddp_entry_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a2);
2012 ddp_entry_rec.last_updated_by := rosetta_g_miss_num_map(p6_a3);
2013 ddp_entry_rec.creation_date := rosetta_g_miss_date_in_map(p6_a4);
2014 ddp_entry_rec.created_by := rosetta_g_miss_num_map(p6_a5);
2015 ddp_entry_rec.last_update_login := rosetta_g_miss_num_map(p6_a6);
2016 ddp_entry_rec.object_version_number := rosetta_g_miss_num_map(p6_a7);
2017 ddp_entry_rec.list_select_action_id := rosetta_g_miss_num_map(p6_a8);
2018 ddp_entry_rec.arc_list_select_action_from := p6_a9;
2019 ddp_entry_rec.list_select_action_from_name := p6_a10;
2020 ddp_entry_rec.source_code := p6_a11;
2021 ddp_entry_rec.arc_list_used_by_source := p6_a12;
2022 ddp_entry_rec.source_code_for_id := rosetta_g_miss_num_map(p6_a13);
2023 ddp_entry_rec.pin_code := p6_a14;
2024 ddp_entry_rec.list_entry_source_system_id := rosetta_g_miss_num_map(p6_a15);
2025 ddp_entry_rec.list_entry_source_system_type := p6_a16;
2026 ddp_entry_rec.view_application_id := rosetta_g_miss_num_map(p6_a17);
2027 ddp_entry_rec.manually_entered_flag := p6_a18;
2028 ddp_entry_rec.marked_as_duplicate_flag := p6_a19;
2029 ddp_entry_rec.marked_as_random_flag := p6_a20;
2030 ddp_entry_rec.part_of_control_group_flag := p6_a21;
2031 ddp_entry_rec.exclude_in_triggered_list_flag := p6_a22;
2032 ddp_entry_rec.enabled_flag := p6_a23;
2033 ddp_entry_rec.cell_code := p6_a24;
2034 ddp_entry_rec.dedupe_key := p6_a25;
2035 ddp_entry_rec.randomly_generated_number := rosetta_g_miss_num_map(p6_a26);
2036 ddp_entry_rec.campaign_id := rosetta_g_miss_num_map(p6_a27);
2037 ddp_entry_rec.media_id := rosetta_g_miss_num_map(p6_a28);
2038 ddp_entry_rec.channel_id := rosetta_g_miss_num_map(p6_a29);
2039 ddp_entry_rec.channel_schedule_id := rosetta_g_miss_num_map(p6_a30);
2040 ddp_entry_rec.event_offer_id := rosetta_g_miss_num_map(p6_a31);
2041 ddp_entry_rec.customer_id := rosetta_g_miss_num_map(p6_a32);
2042 ddp_entry_rec.market_segment_id := rosetta_g_miss_num_map(p6_a33);
2043 ddp_entry_rec.vendor_id := rosetta_g_miss_num_map(p6_a34);
2044 ddp_entry_rec.transfer_flag := p6_a35;
2045 ddp_entry_rec.transfer_status := p6_a36;
2046 ddp_entry_rec.list_source := p6_a37;
2047 ddp_entry_rec.duplicate_master_entry_id := rosetta_g_miss_num_map(p6_a38);
2048 ddp_entry_rec.marked_flag := p6_a39;
2049 ddp_entry_rec.lead_id := rosetta_g_miss_num_map(p6_a40);
2050 ddp_entry_rec.letter_id := rosetta_g_miss_num_map(p6_a41);
2051 ddp_entry_rec.picking_header_id := rosetta_g_miss_num_map(p6_a42);
2052 ddp_entry_rec.batch_id := rosetta_g_miss_num_map(p6_a43);
2053 ddp_entry_rec.first_name := p6_a44;
2054 ddp_entry_rec.last_name := p6_a45;
2055 ddp_entry_rec.customer_name := p6_a46;
2056 ddp_entry_rec.col1 := p6_a47;
2057 ddp_entry_rec.col2 := p6_a48;
2058 ddp_entry_rec.col3 := p6_a49;
2059 ddp_entry_rec.col4 := p6_a50;
2060 ddp_entry_rec.col5 := p6_a51;
2061 ddp_entry_rec.col6 := p6_a52;
2062 ddp_entry_rec.col7 := p6_a53;
2063 ddp_entry_rec.col8 := p6_a54;
2064 ddp_entry_rec.col9 := p6_a55;
2065 ddp_entry_rec.col10 := p6_a56;
2066 ddp_entry_rec.col11 := p6_a57;
2067 ddp_entry_rec.col12 := p6_a58;
2068 ddp_entry_rec.col13 := p6_a59;
2069 ddp_entry_rec.col14 := p6_a60;
2070 ddp_entry_rec.col15 := p6_a61;
2071 ddp_entry_rec.col16 := p6_a62;
2072 ddp_entry_rec.col17 := p6_a63;
2073 ddp_entry_rec.col18 := p6_a64;
2074 ddp_entry_rec.col19 := p6_a65;
2075 ddp_entry_rec.col20 := p6_a66;
2076 ddp_entry_rec.col21 := p6_a67;
2077 ddp_entry_rec.col22 := p6_a68;
2078 ddp_entry_rec.col23 := p6_a69;
2079 ddp_entry_rec.col24 := p6_a70;
2080 ddp_entry_rec.col25 := p6_a71;
2081 ddp_entry_rec.col26 := p6_a72;
2082 ddp_entry_rec.col27 := p6_a73;
2083 ddp_entry_rec.col28 := p6_a74;
2084 ddp_entry_rec.col29 := p6_a75;
2085 ddp_entry_rec.col30 := p6_a76;
2086 ddp_entry_rec.col31 := p6_a77;
2087 ddp_entry_rec.col32 := p6_a78;
2088 ddp_entry_rec.col33 := p6_a79;
2089 ddp_entry_rec.col34 := p6_a80;
2090 ddp_entry_rec.col35 := p6_a81;
2091 ddp_entry_rec.col36 := p6_a82;
2092 ddp_entry_rec.col37 := p6_a83;
2093 ddp_entry_rec.col38 := p6_a84;
2094 ddp_entry_rec.col39 := p6_a85;
2095 ddp_entry_rec.col40 := p6_a86;
2096 ddp_entry_rec.col41 := p6_a87;
2097 ddp_entry_rec.col42 := p6_a88;
2098 ddp_entry_rec.col43 := p6_a89;
2099 ddp_entry_rec.col44 := p6_a90;
2100 ddp_entry_rec.col45 := p6_a91;
2101 ddp_entry_rec.col46 := p6_a92;
2102 ddp_entry_rec.col47 := p6_a93;
2103 ddp_entry_rec.col48 := p6_a94;
2104 ddp_entry_rec.col49 := p6_a95;
2105 ddp_entry_rec.col50 := p6_a96;
2106 ddp_entry_rec.col51 := p6_a97;
2107 ddp_entry_rec.col52 := p6_a98;
2108 ddp_entry_rec.col53 := p6_a99;
2109 ddp_entry_rec.col54 := p6_a100;
2110 ddp_entry_rec.col55 := p6_a101;
2111 ddp_entry_rec.col56 := p6_a102;
2112 ddp_entry_rec.col57 := p6_a103;
2113 ddp_entry_rec.col58 := p6_a104;
2114 ddp_entry_rec.col59 := p6_a105;
2115 ddp_entry_rec.col60 := p6_a106;
2116 ddp_entry_rec.col61 := p6_a107;
2117 ddp_entry_rec.col62 := p6_a108;
2118 ddp_entry_rec.col63 := p6_a109;
2119 ddp_entry_rec.col64 := p6_a110;
2120 ddp_entry_rec.col65 := p6_a111;
2121 ddp_entry_rec.col66 := p6_a112;
2122 ddp_entry_rec.col67 := p6_a113;
2123 ddp_entry_rec.col68 := p6_a114;
2124 ddp_entry_rec.col69 := p6_a115;
2125 ddp_entry_rec.col70 := p6_a116;
2126 ddp_entry_rec.col71 := p6_a117;
2127 ddp_entry_rec.col72 := p6_a118;
2128 ddp_entry_rec.col73 := p6_a119;
2129 ddp_entry_rec.col74 := p6_a120;
2130 ddp_entry_rec.col75 := p6_a121;
2131 ddp_entry_rec.col76 := p6_a122;
2132 ddp_entry_rec.col77 := p6_a123;
2133 ddp_entry_rec.col78 := p6_a124;
2134 ddp_entry_rec.col79 := p6_a125;
2135 ddp_entry_rec.col80 := p6_a126;
2136 ddp_entry_rec.col81 := p6_a127;
2137 ddp_entry_rec.col82 := p6_a128;
2138 ddp_entry_rec.col83 := p6_a129;
2139 ddp_entry_rec.col84 := p6_a130;
2140 ddp_entry_rec.col85 := p6_a131;
2141 ddp_entry_rec.col86 := p6_a132;
2142 ddp_entry_rec.col87 := p6_a133;
2143 ddp_entry_rec.col88 := p6_a134;
2144 ddp_entry_rec.col89 := p6_a135;
2145 ddp_entry_rec.col90 := p6_a136;
2146 ddp_entry_rec.col91 := p6_a137;
2147 ddp_entry_rec.col92 := p6_a138;
2148 ddp_entry_rec.col93 := p6_a139;
2149 ddp_entry_rec.col94 := p6_a140;
2150 ddp_entry_rec.col95 := p6_a141;
2151 ddp_entry_rec.col96 := p6_a142;
2152 ddp_entry_rec.col97 := p6_a143;
2153 ddp_entry_rec.col98 := p6_a144;
2154 ddp_entry_rec.col99 := p6_a145;
2155 ddp_entry_rec.col100 := p6_a146;
2156 ddp_entry_rec.col101 := p6_a147;
2157 ddp_entry_rec.col102 := p6_a148;
2158 ddp_entry_rec.col103 := p6_a149;
2159 ddp_entry_rec.col104 := p6_a150;
2160 ddp_entry_rec.col105 := p6_a151;
2161 ddp_entry_rec.col106 := p6_a152;
2162 ddp_entry_rec.col107 := p6_a153;
2163 ddp_entry_rec.col108 := p6_a154;
2164 ddp_entry_rec.col109 := p6_a155;
2165 ddp_entry_rec.col110 := p6_a156;
2166 ddp_entry_rec.col111 := p6_a157;
2167 ddp_entry_rec.col112 := p6_a158;
2168 ddp_entry_rec.col113 := p6_a159;
2169 ddp_entry_rec.col114 := p6_a160;
2170 ddp_entry_rec.col115 := p6_a161;
2171 ddp_entry_rec.col116 := p6_a162;
2172 ddp_entry_rec.col117 := p6_a163;
2173 ddp_entry_rec.col118 := p6_a164;
2174 ddp_entry_rec.col119 := p6_a165;
2175 ddp_entry_rec.col120 := p6_a166;
2176 ddp_entry_rec.col121 := p6_a167;
2177 ddp_entry_rec.col122 := p6_a168;
2178 ddp_entry_rec.col123 := p6_a169;
2179 ddp_entry_rec.col124 := p6_a170;
2180 ddp_entry_rec.col125 := p6_a171;
2181 ddp_entry_rec.col126 := p6_a172;
2182 ddp_entry_rec.col127 := p6_a173;
2183 ddp_entry_rec.col128 := p6_a174;
2184 ddp_entry_rec.col129 := p6_a175;
2185 ddp_entry_rec.col130 := p6_a176;
2186 ddp_entry_rec.col131 := p6_a177;
2187 ddp_entry_rec.col132 := p6_a178;
2188 ddp_entry_rec.col133 := p6_a179;
2189 ddp_entry_rec.col134 := p6_a180;
2190 ddp_entry_rec.col135 := p6_a181;
2191 ddp_entry_rec.col136 := p6_a182;
2192 ddp_entry_rec.col137 := p6_a183;
2193 ddp_entry_rec.col138 := p6_a184;
2194 ddp_entry_rec.col139 := p6_a185;
2195 ddp_entry_rec.col140 := p6_a186;
2196 ddp_entry_rec.col141 := p6_a187;
2197 ddp_entry_rec.col142 := p6_a188;
2198 ddp_entry_rec.col143 := p6_a189;
2199 ddp_entry_rec.col144 := p6_a190;
2200 ddp_entry_rec.col145 := p6_a191;
2201 ddp_entry_rec.col146 := p6_a192;
2202 ddp_entry_rec.col147 := p6_a193;
2203 ddp_entry_rec.col148 := p6_a194;
2204 ddp_entry_rec.col149 := p6_a195;
2205 ddp_entry_rec.col150 := p6_a196;
2206 ddp_entry_rec.col151 := p6_a197;
2207 ddp_entry_rec.col152 := p6_a198;
2208 ddp_entry_rec.col153 := p6_a199;
2209 ddp_entry_rec.col154 := p6_a200;
2210 ddp_entry_rec.col155 := p6_a201;
2211 ddp_entry_rec.col156 := p6_a202;
2212 ddp_entry_rec.col157 := p6_a203;
2213 ddp_entry_rec.col158 := p6_a204;
2214 ddp_entry_rec.col159 := p6_a205;
2215 ddp_entry_rec.col160 := p6_a206;
2216 ddp_entry_rec.col161 := p6_a207;
2217 ddp_entry_rec.col162 := p6_a208;
2218 ddp_entry_rec.col163 := p6_a209;
2219 ddp_entry_rec.col164 := p6_a210;
2220 ddp_entry_rec.col165 := p6_a211;
2221 ddp_entry_rec.col166 := p6_a212;
2222 ddp_entry_rec.col167 := p6_a213;
2223 ddp_entry_rec.col168 := p6_a214;
2224 ddp_entry_rec.col169 := p6_a215;
2225 ddp_entry_rec.col170 := p6_a216;
2226 ddp_entry_rec.col171 := p6_a217;
2227 ddp_entry_rec.col172 := p6_a218;
2228 ddp_entry_rec.col173 := p6_a219;
2229 ddp_entry_rec.col174 := p6_a220;
2230 ddp_entry_rec.col175 := p6_a221;
2231 ddp_entry_rec.col176 := p6_a222;
2232 ddp_entry_rec.col177 := p6_a223;
2233 ddp_entry_rec.col178 := p6_a224;
2234 ddp_entry_rec.col179 := p6_a225;
2235 ddp_entry_rec.col180 := p6_a226;
2236 ddp_entry_rec.col181 := p6_a227;
2237 ddp_entry_rec.col182 := p6_a228;
2238 ddp_entry_rec.col183 := p6_a229;
2239 ddp_entry_rec.col184 := p6_a230;
2240 ddp_entry_rec.col185 := p6_a231;
2241 ddp_entry_rec.col186 := p6_a232;
2242 ddp_entry_rec.col187 := p6_a233;
2243 ddp_entry_rec.col188 := p6_a234;
2244 ddp_entry_rec.col189 := p6_a235;
2245 ddp_entry_rec.col190 := p6_a236;
2246 ddp_entry_rec.col191 := p6_a237;
2247 ddp_entry_rec.col192 := p6_a238;
2248 ddp_entry_rec.col193 := p6_a239;
2249 ddp_entry_rec.col194 := p6_a240;
2250 ddp_entry_rec.col195 := p6_a241;
2251 ddp_entry_rec.col196 := p6_a242;
2252 ddp_entry_rec.col197 := p6_a243;
2253 ddp_entry_rec.col198 := p6_a244;
2254 ddp_entry_rec.col199 := p6_a245;
2255 ddp_entry_rec.col200 := p6_a246;
2256 ddp_entry_rec.col201 := p6_a247;
2257 ddp_entry_rec.col202 := p6_a248;
2258 ddp_entry_rec.col203 := p6_a249;
2259 ddp_entry_rec.col204 := p6_a250;
2260 ddp_entry_rec.col205 := p6_a251;
2261 ddp_entry_rec.col206 := p6_a252;
2262 ddp_entry_rec.col207 := p6_a253;
2263 ddp_entry_rec.col208 := p6_a254;
2264 ddp_entry_rec.col209 := p6_a255;
2265 ddp_entry_rec.col210 := p6_a256;
2266 ddp_entry_rec.col211 := p6_a257;
2267 ddp_entry_rec.col212 := p6_a258;
2268 ddp_entry_rec.col213 := p6_a259;
2269 ddp_entry_rec.col214 := p6_a260;
2270 ddp_entry_rec.col215 := p6_a261;
2271 ddp_entry_rec.col216 := p6_a262;
2272 ddp_entry_rec.col217 := p6_a263;
2273 ddp_entry_rec.col218 := p6_a264;
2274 ddp_entry_rec.col219 := p6_a265;
2275 ddp_entry_rec.col220 := p6_a266;
2276 ddp_entry_rec.col221 := p6_a267;
2277 ddp_entry_rec.col222 := p6_a268;
2278 ddp_entry_rec.col223 := p6_a269;
2279 ddp_entry_rec.col224 := p6_a270;
2280 ddp_entry_rec.col225 := p6_a271;
2281 ddp_entry_rec.col226 := p6_a272;
2282 ddp_entry_rec.col227 := p6_a273;
2283 ddp_entry_rec.col228 := p6_a274;
2284 ddp_entry_rec.col229 := p6_a275;
2285 ddp_entry_rec.col230 := p6_a276;
2286 ddp_entry_rec.col231 := p6_a277;
2287 ddp_entry_rec.col232 := p6_a278;
2288 ddp_entry_rec.col233 := p6_a279;
2289 ddp_entry_rec.col234 := p6_a280;
2290 ddp_entry_rec.col235 := p6_a281;
2291 ddp_entry_rec.col236 := p6_a282;
2292 ddp_entry_rec.col237 := p6_a283;
2293 ddp_entry_rec.col238 := p6_a284;
2294 ddp_entry_rec.col239 := p6_a285;
2295 ddp_entry_rec.col240 := p6_a286;
2296 ddp_entry_rec.col241 := p6_a287;
2297 ddp_entry_rec.col242 := p6_a288;
2298 ddp_entry_rec.col243 := p6_a289;
2299 ddp_entry_rec.col244 := p6_a290;
2300 ddp_entry_rec.col245 := p6_a291;
2301 ddp_entry_rec.col246 := p6_a292;
2302 ddp_entry_rec.col247 := p6_a293;
2303 ddp_entry_rec.col248 := p6_a294;
2304 ddp_entry_rec.col249 := p6_a295;
2305 ddp_entry_rec.col250 := p6_a296;
2306 ddp_entry_rec.col251 := p6_a297;
2307 ddp_entry_rec.col252 := p6_a298;
2308 ddp_entry_rec.col253 := p6_a299;
2309 ddp_entry_rec.col254 := p6_a300;
2310 ddp_entry_rec.col255 := p6_a301;
2311 ddp_entry_rec.col256 := p6_a302;
2312 ddp_entry_rec.col257 := p6_a303;
2313 ddp_entry_rec.col258 := p6_a304;
2314 ddp_entry_rec.col259 := p6_a305;
2315 ddp_entry_rec.col260 := p6_a306;
2316 ddp_entry_rec.col261 := p6_a307;
2317 ddp_entry_rec.col262 := p6_a308;
2318 ddp_entry_rec.col263 := p6_a309;
2319 ddp_entry_rec.col264 := p6_a310;
2320 ddp_entry_rec.col265 := p6_a311;
2321 ddp_entry_rec.col266 := p6_a312;
2322 ddp_entry_rec.col267 := p6_a313;
2323 ddp_entry_rec.col268 := p6_a314;
2324 ddp_entry_rec.col269 := p6_a315;
2325 ddp_entry_rec.col270 := p6_a316;
2326 ddp_entry_rec.col271 := p6_a317;
2327 ddp_entry_rec.col272 := p6_a318;
2328 ddp_entry_rec.col273 := p6_a319;
2329 ddp_entry_rec.col274 := p6_a320;
2330 ddp_entry_rec.col275 := p6_a321;
2331 ddp_entry_rec.col276 := p6_a322;
2332 ddp_entry_rec.col277 := p6_a323;
2333 ddp_entry_rec.col278 := p6_a324;
2334 ddp_entry_rec.col279 := p6_a325;
2335 ddp_entry_rec.col280 := p6_a326;
2336 ddp_entry_rec.col281 := p6_a327;
2337 ddp_entry_rec.col282 := p6_a328;
2338 ddp_entry_rec.col283 := p6_a329;
2339 ddp_entry_rec.col284 := p6_a330;
2340 ddp_entry_rec.col285 := p6_a331;
2341 ddp_entry_rec.col286 := p6_a332;
2342 ddp_entry_rec.col287 := p6_a333;
2343 ddp_entry_rec.col288 := p6_a334;
2344 ddp_entry_rec.col289 := p6_a335;
2345 ddp_entry_rec.col290 := p6_a336;
2346 ddp_entry_rec.col291 := p6_a337;
2347 ddp_entry_rec.col292 := p6_a338;
2348 ddp_entry_rec.col293 := p6_a339;
2349 ddp_entry_rec.col294 := p6_a340;
2350 ddp_entry_rec.col295 := p6_a341;
2351 ddp_entry_rec.col296 := p6_a342;
2352 ddp_entry_rec.col297 := p6_a343;
2353 ddp_entry_rec.col298 := p6_a344;
2354 ddp_entry_rec.col299 := p6_a345;
2355 ddp_entry_rec.col300 := p6_a346;
2356 ddp_entry_rec.address_line1 := p6_a347;
2357 ddp_entry_rec.address_line2 := p6_a348;
2358 ddp_entry_rec.callback_flag := p6_a349;
2359 ddp_entry_rec.city := p6_a350;
2360 ddp_entry_rec.country := p6_a351;
2361 ddp_entry_rec.do_not_use_flag := p6_a352;
2362 ddp_entry_rec.do_not_use_reason := p6_a353;
2363 ddp_entry_rec.email_address := p6_a354;
2364 ddp_entry_rec.fax := p6_a355;
2365 ddp_entry_rec.phone := p6_a356;
2366 ddp_entry_rec.record_out_flag := p6_a357;
2367 ddp_entry_rec.state := p6_a358;
2368 ddp_entry_rec.suffix := p6_a359;
2369 ddp_entry_rec.title := p6_a360;
2370 ddp_entry_rec.usage_restriction := p6_a361;
2371 ddp_entry_rec.zipcode := p6_a362;
2372 ddp_entry_rec.curr_cp_country_code := p6_a363;
2373 ddp_entry_rec.curr_cp_phone_number := p6_a364;
2374 ddp_entry_rec.curr_cp_raw_phone_number := p6_a365;
2375 ddp_entry_rec.curr_cp_area_code := rosetta_g_miss_num_map(p6_a366);
2376 ddp_entry_rec.curr_cp_id := rosetta_g_miss_num_map(p6_a367);
2377 ddp_entry_rec.curr_cp_index := rosetta_g_miss_num_map(p6_a368);
2378 ddp_entry_rec.curr_cp_time_zone := rosetta_g_miss_num_map(p6_a369);
2379 ddp_entry_rec.curr_cp_time_zone_aux := rosetta_g_miss_num_map(p6_a370);
2380 ddp_entry_rec.imp_source_line_id := rosetta_g_miss_num_map(p6_a371);
2381 ddp_entry_rec.next_call_time := rosetta_g_miss_date_in_map(p6_a372);
2382 ddp_entry_rec.record_release_time := rosetta_g_miss_date_in_map(p6_a373);
2383 ddp_entry_rec.party_id := rosetta_g_miss_num_map(p6_a374);
2384 ddp_entry_rec.parent_party_id := rosetta_g_miss_num_map(p6_a375);
2385
2386 -- here's the delegated call to the old PL/SQL routine
2387 ams_listentry_pub.validate_listentry(p_api_version,
2388 p_init_msg_list,
2389 p_validation_level,
2390 x_return_status,
2391 x_msg_count,
2392 x_msg_data,
2393 ddp_entry_rec);
2394
2395 -- copy data back from the local OUT or IN-OUT args, if any
2396
2397
2398
2399
2400
2401
2402 end;
2403
2404 procedure init_entry_rec(p0_a0 OUT NOCOPY NUMBER
2405 , p0_a1 OUT NOCOPY NUMBER
2406 , p0_a2 OUT NOCOPY DATE
2407 , p0_a3 OUT NOCOPY NUMBER
2408 , p0_a4 OUT NOCOPY DATE
2409 , p0_a5 OUT NOCOPY NUMBER
2410 , p0_a6 OUT NOCOPY NUMBER
2411 , p0_a7 OUT NOCOPY NUMBER
2412 , p0_a8 OUT NOCOPY NUMBER
2413 , p0_a9 OUT NOCOPY VARCHAR2
2414 , p0_a10 OUT NOCOPY VARCHAR2
2415 , p0_a11 OUT NOCOPY VARCHAR2
2416 , p0_a12 OUT NOCOPY VARCHAR2
2417 , p0_a13 OUT NOCOPY NUMBER
2418 , p0_a14 OUT NOCOPY VARCHAR2
2419 , p0_a15 OUT NOCOPY NUMBER
2420 , p0_a16 OUT NOCOPY VARCHAR2
2421 , p0_a17 OUT NOCOPY NUMBER
2422 , p0_a18 OUT NOCOPY VARCHAR2
2423 , p0_a19 OUT NOCOPY VARCHAR2
2424 , p0_a20 OUT NOCOPY VARCHAR2
2425 , p0_a21 OUT NOCOPY VARCHAR2
2426 , p0_a22 OUT NOCOPY VARCHAR2
2427 , p0_a23 OUT NOCOPY VARCHAR2
2428 , p0_a24 OUT NOCOPY VARCHAR2
2429 , p0_a25 OUT NOCOPY VARCHAR2
2430 , p0_a26 OUT NOCOPY NUMBER
2431 , p0_a27 OUT NOCOPY NUMBER
2432 , p0_a28 OUT NOCOPY NUMBER
2433 , p0_a29 OUT NOCOPY NUMBER
2434 , p0_a30 OUT NOCOPY NUMBER
2435 , p0_a31 OUT NOCOPY NUMBER
2436 , p0_a32 OUT NOCOPY NUMBER
2437 , p0_a33 OUT NOCOPY NUMBER
2438 , p0_a34 OUT NOCOPY NUMBER
2439 , p0_a35 OUT NOCOPY VARCHAR2
2440 , p0_a36 OUT NOCOPY VARCHAR2
2441 , p0_a37 OUT NOCOPY VARCHAR2
2442 , p0_a38 OUT NOCOPY NUMBER
2443 , p0_a39 OUT NOCOPY VARCHAR2
2444 , p0_a40 OUT NOCOPY NUMBER
2445 , p0_a41 OUT NOCOPY NUMBER
2446 , p0_a42 OUT NOCOPY NUMBER
2447 , p0_a43 OUT NOCOPY NUMBER
2448 , p0_a44 OUT NOCOPY VARCHAR2
2449 , p0_a45 OUT NOCOPY VARCHAR2
2450 , p0_a46 OUT NOCOPY VARCHAR2
2451 , p0_a47 OUT NOCOPY VARCHAR2
2452 , p0_a48 OUT NOCOPY VARCHAR2
2453 , p0_a49 OUT NOCOPY VARCHAR2
2454 , p0_a50 OUT NOCOPY VARCHAR2
2455 , p0_a51 OUT NOCOPY VARCHAR2
2456 , p0_a52 OUT NOCOPY VARCHAR2
2457 , p0_a53 OUT NOCOPY VARCHAR2
2458 , p0_a54 OUT NOCOPY VARCHAR2
2459 , p0_a55 OUT NOCOPY VARCHAR2
2460 , p0_a56 OUT NOCOPY VARCHAR2
2461 , p0_a57 OUT NOCOPY VARCHAR2
2462 , p0_a58 OUT NOCOPY VARCHAR2
2463 , p0_a59 OUT NOCOPY VARCHAR2
2464 , p0_a60 OUT NOCOPY VARCHAR2
2465 , p0_a61 OUT NOCOPY VARCHAR2
2466 , p0_a62 OUT NOCOPY VARCHAR2
2467 , p0_a63 OUT NOCOPY VARCHAR2
2468 , p0_a64 OUT NOCOPY VARCHAR2
2469 , p0_a65 OUT NOCOPY VARCHAR2
2470 , p0_a66 OUT NOCOPY VARCHAR2
2471 , p0_a67 OUT NOCOPY VARCHAR2
2472 , p0_a68 OUT NOCOPY VARCHAR2
2473 , p0_a69 OUT NOCOPY VARCHAR2
2474 , p0_a70 OUT NOCOPY VARCHAR2
2475 , p0_a71 OUT NOCOPY VARCHAR2
2476 , p0_a72 OUT NOCOPY VARCHAR2
2477 , p0_a73 OUT NOCOPY VARCHAR2
2478 , p0_a74 OUT NOCOPY VARCHAR2
2479 , p0_a75 OUT NOCOPY VARCHAR2
2480 , p0_a76 OUT NOCOPY VARCHAR2
2481 , p0_a77 OUT NOCOPY VARCHAR2
2482 , p0_a78 OUT NOCOPY VARCHAR2
2483 , p0_a79 OUT NOCOPY VARCHAR2
2484 , p0_a80 OUT NOCOPY VARCHAR2
2485 , p0_a81 OUT NOCOPY VARCHAR2
2486 , p0_a82 OUT NOCOPY VARCHAR2
2487 , p0_a83 OUT NOCOPY VARCHAR2
2488 , p0_a84 OUT NOCOPY VARCHAR2
2489 , p0_a85 OUT NOCOPY VARCHAR2
2490 , p0_a86 OUT NOCOPY VARCHAR2
2491 , p0_a87 OUT NOCOPY VARCHAR2
2492 , p0_a88 OUT NOCOPY VARCHAR2
2493 , p0_a89 OUT NOCOPY VARCHAR2
2494 , p0_a90 OUT NOCOPY VARCHAR2
2495 , p0_a91 OUT NOCOPY VARCHAR2
2496 , p0_a92 OUT NOCOPY VARCHAR2
2497 , p0_a93 OUT NOCOPY VARCHAR2
2498 , p0_a94 OUT NOCOPY VARCHAR2
2499 , p0_a95 OUT NOCOPY VARCHAR2
2500 , p0_a96 OUT NOCOPY VARCHAR2
2501 , p0_a97 OUT NOCOPY VARCHAR2
2502 , p0_a98 OUT NOCOPY VARCHAR2
2503 , p0_a99 OUT NOCOPY VARCHAR2
2504 , p0_a100 OUT NOCOPY VARCHAR2
2505 , p0_a101 OUT NOCOPY VARCHAR2
2506 , p0_a102 OUT NOCOPY VARCHAR2
2507 , p0_a103 OUT NOCOPY VARCHAR2
2508 , p0_a104 OUT NOCOPY VARCHAR2
2509 , p0_a105 OUT NOCOPY VARCHAR2
2510 , p0_a106 OUT NOCOPY VARCHAR2
2511 , p0_a107 OUT NOCOPY VARCHAR2
2512 , p0_a108 OUT NOCOPY VARCHAR2
2513 , p0_a109 OUT NOCOPY VARCHAR2
2514 , p0_a110 OUT NOCOPY VARCHAR2
2515 , p0_a111 OUT NOCOPY VARCHAR2
2516 , p0_a112 OUT NOCOPY VARCHAR2
2517 , p0_a113 OUT NOCOPY VARCHAR2
2518 , p0_a114 OUT NOCOPY VARCHAR2
2519 , p0_a115 OUT NOCOPY VARCHAR2
2520 , p0_a116 OUT NOCOPY VARCHAR2
2521 , p0_a117 OUT NOCOPY VARCHAR2
2522 , p0_a118 OUT NOCOPY VARCHAR2
2523 , p0_a119 OUT NOCOPY VARCHAR2
2524 , p0_a120 OUT NOCOPY VARCHAR2
2525 , p0_a121 OUT NOCOPY VARCHAR2
2526 , p0_a122 OUT NOCOPY VARCHAR2
2527 , p0_a123 OUT NOCOPY VARCHAR2
2528 , p0_a124 OUT NOCOPY VARCHAR2
2529 , p0_a125 OUT NOCOPY VARCHAR2
2530 , p0_a126 OUT NOCOPY VARCHAR2
2531 , p0_a127 OUT NOCOPY VARCHAR2
2532 , p0_a128 OUT NOCOPY VARCHAR2
2533 , p0_a129 OUT NOCOPY VARCHAR2
2534 , p0_a130 OUT NOCOPY VARCHAR2
2535 , p0_a131 OUT NOCOPY VARCHAR2
2536 , p0_a132 OUT NOCOPY VARCHAR2
2537 , p0_a133 OUT NOCOPY VARCHAR2
2538 , p0_a134 OUT NOCOPY VARCHAR2
2539 , p0_a135 OUT NOCOPY VARCHAR2
2540 , p0_a136 OUT NOCOPY VARCHAR2
2541 , p0_a137 OUT NOCOPY VARCHAR2
2542 , p0_a138 OUT NOCOPY VARCHAR2
2543 , p0_a139 OUT NOCOPY VARCHAR2
2544 , p0_a140 OUT NOCOPY VARCHAR2
2545 , p0_a141 OUT NOCOPY VARCHAR2
2546 , p0_a142 OUT NOCOPY VARCHAR2
2547 , p0_a143 OUT NOCOPY VARCHAR2
2548 , p0_a144 OUT NOCOPY VARCHAR2
2549 , p0_a145 OUT NOCOPY VARCHAR2
2550 , p0_a146 OUT NOCOPY VARCHAR2
2551 , p0_a147 OUT NOCOPY VARCHAR2
2552 , p0_a148 OUT NOCOPY VARCHAR2
2553 , p0_a149 OUT NOCOPY VARCHAR2
2554 , p0_a150 OUT NOCOPY VARCHAR2
2555 , p0_a151 OUT NOCOPY VARCHAR2
2556 , p0_a152 OUT NOCOPY VARCHAR2
2557 , p0_a153 OUT NOCOPY VARCHAR2
2558 , p0_a154 OUT NOCOPY VARCHAR2
2559 , p0_a155 OUT NOCOPY VARCHAR2
2560 , p0_a156 OUT NOCOPY VARCHAR2
2561 , p0_a157 OUT NOCOPY VARCHAR2
2562 , p0_a158 OUT NOCOPY VARCHAR2
2563 , p0_a159 OUT NOCOPY VARCHAR2
2564 , p0_a160 OUT NOCOPY VARCHAR2
2565 , p0_a161 OUT NOCOPY VARCHAR2
2566 , p0_a162 OUT NOCOPY VARCHAR2
2567 , p0_a163 OUT NOCOPY VARCHAR2
2568 , p0_a164 OUT NOCOPY VARCHAR2
2569 , p0_a165 OUT NOCOPY VARCHAR2
2570 , p0_a166 OUT NOCOPY VARCHAR2
2571 , p0_a167 OUT NOCOPY VARCHAR2
2572 , p0_a168 OUT NOCOPY VARCHAR2
2573 , p0_a169 OUT NOCOPY VARCHAR2
2574 , p0_a170 OUT NOCOPY VARCHAR2
2575 , p0_a171 OUT NOCOPY VARCHAR2
2576 , p0_a172 OUT NOCOPY VARCHAR2
2577 , p0_a173 OUT NOCOPY VARCHAR2
2578 , p0_a174 OUT NOCOPY VARCHAR2
2579 , p0_a175 OUT NOCOPY VARCHAR2
2580 , p0_a176 OUT NOCOPY VARCHAR2
2581 , p0_a177 OUT NOCOPY VARCHAR2
2582 , p0_a178 OUT NOCOPY VARCHAR2
2583 , p0_a179 OUT NOCOPY VARCHAR2
2584 , p0_a180 OUT NOCOPY VARCHAR2
2585 , p0_a181 OUT NOCOPY VARCHAR2
2586 , p0_a182 OUT NOCOPY VARCHAR2
2587 , p0_a183 OUT NOCOPY VARCHAR2
2588 , p0_a184 OUT NOCOPY VARCHAR2
2589 , p0_a185 OUT NOCOPY VARCHAR2
2590 , p0_a186 OUT NOCOPY VARCHAR2
2591 , p0_a187 OUT NOCOPY VARCHAR2
2592 , p0_a188 OUT NOCOPY VARCHAR2
2593 , p0_a189 OUT NOCOPY VARCHAR2
2594 , p0_a190 OUT NOCOPY VARCHAR2
2595 , p0_a191 OUT NOCOPY VARCHAR2
2596 , p0_a192 OUT NOCOPY VARCHAR2
2597 , p0_a193 OUT NOCOPY VARCHAR2
2598 , p0_a194 OUT NOCOPY VARCHAR2
2599 , p0_a195 OUT NOCOPY VARCHAR2
2600 , p0_a196 OUT NOCOPY VARCHAR2
2601 , p0_a197 OUT NOCOPY VARCHAR2
2602 , p0_a198 OUT NOCOPY VARCHAR2
2603 , p0_a199 OUT NOCOPY VARCHAR2
2604 , p0_a200 OUT NOCOPY VARCHAR2
2605 , p0_a201 OUT NOCOPY VARCHAR2
2606 , p0_a202 OUT NOCOPY VARCHAR2
2607 , p0_a203 OUT NOCOPY VARCHAR2
2608 , p0_a204 OUT NOCOPY VARCHAR2
2609 , p0_a205 OUT NOCOPY VARCHAR2
2610 , p0_a206 OUT NOCOPY VARCHAR2
2611 , p0_a207 OUT NOCOPY VARCHAR2
2612 , p0_a208 OUT NOCOPY VARCHAR2
2613 , p0_a209 OUT NOCOPY VARCHAR2
2614 , p0_a210 OUT NOCOPY VARCHAR2
2615 , p0_a211 OUT NOCOPY VARCHAR2
2616 , p0_a212 OUT NOCOPY VARCHAR2
2617 , p0_a213 OUT NOCOPY VARCHAR2
2618 , p0_a214 OUT NOCOPY VARCHAR2
2619 , p0_a215 OUT NOCOPY VARCHAR2
2620 , p0_a216 OUT NOCOPY VARCHAR2
2621 , p0_a217 OUT NOCOPY VARCHAR2
2622 , p0_a218 OUT NOCOPY VARCHAR2
2623 , p0_a219 OUT NOCOPY VARCHAR2
2624 , p0_a220 OUT NOCOPY VARCHAR2
2625 , p0_a221 OUT NOCOPY VARCHAR2
2626 , p0_a222 OUT NOCOPY VARCHAR2
2627 , p0_a223 OUT NOCOPY VARCHAR2
2628 , p0_a224 OUT NOCOPY VARCHAR2
2629 , p0_a225 OUT NOCOPY VARCHAR2
2630 , p0_a226 OUT NOCOPY VARCHAR2
2631 , p0_a227 OUT NOCOPY VARCHAR2
2632 , p0_a228 OUT NOCOPY VARCHAR2
2633 , p0_a229 OUT NOCOPY VARCHAR2
2634 , p0_a230 OUT NOCOPY VARCHAR2
2635 , p0_a231 OUT NOCOPY VARCHAR2
2636 , p0_a232 OUT NOCOPY VARCHAR2
2637 , p0_a233 OUT NOCOPY VARCHAR2
2638 , p0_a234 OUT NOCOPY VARCHAR2
2639 , p0_a235 OUT NOCOPY VARCHAR2
2640 , p0_a236 OUT NOCOPY VARCHAR2
2641 , p0_a237 OUT NOCOPY VARCHAR2
2642 , p0_a238 OUT NOCOPY VARCHAR2
2643 , p0_a239 OUT NOCOPY VARCHAR2
2644 , p0_a240 OUT NOCOPY VARCHAR2
2645 , p0_a241 OUT NOCOPY VARCHAR2
2646 , p0_a242 OUT NOCOPY VARCHAR2
2647 , p0_a243 OUT NOCOPY VARCHAR2
2648 , p0_a244 OUT NOCOPY VARCHAR2
2649 , p0_a245 OUT NOCOPY VARCHAR2
2650 , p0_a246 OUT NOCOPY VARCHAR2
2651 , p0_a247 OUT NOCOPY VARCHAR2
2652 , p0_a248 OUT NOCOPY VARCHAR2
2653 , p0_a249 OUT NOCOPY VARCHAR2
2654 , p0_a250 OUT NOCOPY VARCHAR2
2655 , p0_a251 OUT NOCOPY VARCHAR2
2656 , p0_a252 OUT NOCOPY VARCHAR2
2657 , p0_a253 OUT NOCOPY VARCHAR2
2658 , p0_a254 OUT NOCOPY VARCHAR2
2659 , p0_a255 OUT NOCOPY VARCHAR2
2660 , p0_a256 OUT NOCOPY VARCHAR2
2661 , p0_a257 OUT NOCOPY VARCHAR2
2662 , p0_a258 OUT NOCOPY VARCHAR2
2663 , p0_a259 OUT NOCOPY VARCHAR2
2664 , p0_a260 OUT NOCOPY VARCHAR2
2665 , p0_a261 OUT NOCOPY VARCHAR2
2666 , p0_a262 OUT NOCOPY VARCHAR2
2667 , p0_a263 OUT NOCOPY VARCHAR2
2668 , p0_a264 OUT NOCOPY VARCHAR2
2669 , p0_a265 OUT NOCOPY VARCHAR2
2670 , p0_a266 OUT NOCOPY VARCHAR2
2671 , p0_a267 OUT NOCOPY VARCHAR2
2672 , p0_a268 OUT NOCOPY VARCHAR2
2673 , p0_a269 OUT NOCOPY VARCHAR2
2674 , p0_a270 OUT NOCOPY VARCHAR2
2675 , p0_a271 OUT NOCOPY VARCHAR2
2676 , p0_a272 OUT NOCOPY VARCHAR2
2677 , p0_a273 OUT NOCOPY VARCHAR2
2678 , p0_a274 OUT NOCOPY VARCHAR2
2679 , p0_a275 OUT NOCOPY VARCHAR2
2680 , p0_a276 OUT NOCOPY VARCHAR2
2681 , p0_a277 OUT NOCOPY VARCHAR2
2682 , p0_a278 OUT NOCOPY VARCHAR2
2683 , p0_a279 OUT NOCOPY VARCHAR2
2684 , p0_a280 OUT NOCOPY VARCHAR2
2685 , p0_a281 OUT NOCOPY VARCHAR2
2686 , p0_a282 OUT NOCOPY VARCHAR2
2687 , p0_a283 OUT NOCOPY VARCHAR2
2688 , p0_a284 OUT NOCOPY VARCHAR2
2689 , p0_a285 OUT NOCOPY VARCHAR2
2690 , p0_a286 OUT NOCOPY VARCHAR2
2691 , p0_a287 OUT NOCOPY VARCHAR2
2692 , p0_a288 OUT NOCOPY VARCHAR2
2693 , p0_a289 OUT NOCOPY VARCHAR2
2694 , p0_a290 OUT NOCOPY VARCHAR2
2695 , p0_a291 OUT NOCOPY VARCHAR2
2696 , p0_a292 OUT NOCOPY VARCHAR2
2697 , p0_a293 OUT NOCOPY VARCHAR2
2698 , p0_a294 OUT NOCOPY VARCHAR2
2699 , p0_a295 OUT NOCOPY VARCHAR2
2700 , p0_a296 OUT NOCOPY VARCHAR2
2701 , p0_a297 OUT NOCOPY VARCHAR2
2702 , p0_a298 OUT NOCOPY VARCHAR2
2703 , p0_a299 OUT NOCOPY VARCHAR2
2704 , p0_a300 OUT NOCOPY VARCHAR2
2705 , p0_a301 OUT NOCOPY VARCHAR2
2706 , p0_a302 OUT NOCOPY VARCHAR2
2707 , p0_a303 OUT NOCOPY VARCHAR2
2708 , p0_a304 OUT NOCOPY VARCHAR2
2709 , p0_a305 OUT NOCOPY VARCHAR2
2710 , p0_a306 OUT NOCOPY VARCHAR2
2711 , p0_a307 OUT NOCOPY VARCHAR2
2712 , p0_a308 OUT NOCOPY VARCHAR2
2713 , p0_a309 OUT NOCOPY VARCHAR2
2714 , p0_a310 OUT NOCOPY VARCHAR2
2715 , p0_a311 OUT NOCOPY VARCHAR2
2716 , p0_a312 OUT NOCOPY VARCHAR2
2717 , p0_a313 OUT NOCOPY VARCHAR2
2718 , p0_a314 OUT NOCOPY VARCHAR2
2719 , p0_a315 OUT NOCOPY VARCHAR2
2720 , p0_a316 OUT NOCOPY VARCHAR2
2721 , p0_a317 OUT NOCOPY VARCHAR2
2722 , p0_a318 OUT NOCOPY VARCHAR2
2723 , p0_a319 OUT NOCOPY VARCHAR2
2724 , p0_a320 OUT NOCOPY VARCHAR2
2725 , p0_a321 OUT NOCOPY VARCHAR2
2726 , p0_a322 OUT NOCOPY VARCHAR2
2727 , p0_a323 OUT NOCOPY VARCHAR2
2728 , p0_a324 OUT NOCOPY VARCHAR2
2729 , p0_a325 OUT NOCOPY VARCHAR2
2730 , p0_a326 OUT NOCOPY VARCHAR2
2731 , p0_a327 OUT NOCOPY VARCHAR2
2732 , p0_a328 OUT NOCOPY VARCHAR2
2733 , p0_a329 OUT NOCOPY VARCHAR2
2734 , p0_a330 OUT NOCOPY VARCHAR2
2735 , p0_a331 OUT NOCOPY VARCHAR2
2736 , p0_a332 OUT NOCOPY VARCHAR2
2737 , p0_a333 OUT NOCOPY VARCHAR2
2738 , p0_a334 OUT NOCOPY VARCHAR2
2739 , p0_a335 OUT NOCOPY VARCHAR2
2740 , p0_a336 OUT NOCOPY VARCHAR2
2741 , p0_a337 OUT NOCOPY VARCHAR2
2742 , p0_a338 OUT NOCOPY VARCHAR2
2743 , p0_a339 OUT NOCOPY VARCHAR2
2744 , p0_a340 OUT NOCOPY VARCHAR2
2745 , p0_a341 OUT NOCOPY VARCHAR2
2746 , p0_a342 OUT NOCOPY VARCHAR2
2747 , p0_a343 OUT NOCOPY VARCHAR2
2748 , p0_a344 OUT NOCOPY VARCHAR2
2749 , p0_a345 OUT NOCOPY VARCHAR2
2750 , p0_a346 OUT NOCOPY VARCHAR2
2751 , p0_a347 OUT NOCOPY VARCHAR2
2752 , p0_a348 OUT NOCOPY VARCHAR2
2753 , p0_a349 OUT NOCOPY VARCHAR2
2754 , p0_a350 OUT NOCOPY VARCHAR2
2755 , p0_a351 OUT NOCOPY VARCHAR2
2756 , p0_a352 OUT NOCOPY VARCHAR2
2757 , p0_a353 OUT NOCOPY VARCHAR2
2758 , p0_a354 OUT NOCOPY VARCHAR2
2759 , p0_a355 OUT NOCOPY VARCHAR2
2760 , p0_a356 OUT NOCOPY VARCHAR2
2761 , p0_a357 OUT NOCOPY VARCHAR2
2762 , p0_a358 OUT NOCOPY VARCHAR2
2763 , p0_a359 OUT NOCOPY VARCHAR2
2764 , p0_a360 OUT NOCOPY VARCHAR2
2765 , p0_a361 OUT NOCOPY VARCHAR2
2766 , p0_a362 OUT NOCOPY VARCHAR2
2767 , p0_a363 OUT NOCOPY VARCHAR2
2768 , p0_a364 OUT NOCOPY VARCHAR2
2769 , p0_a365 OUT NOCOPY VARCHAR2
2770 , p0_a366 OUT NOCOPY NUMBER
2771 , p0_a367 OUT NOCOPY NUMBER
2772 , p0_a368 OUT NOCOPY NUMBER
2773 , p0_a369 OUT NOCOPY NUMBER
2774 , p0_a370 OUT NOCOPY NUMBER
2775 , p0_a371 OUT NOCOPY NUMBER
2776 , p0_a372 OUT NOCOPY DATE
2777 , p0_a373 OUT NOCOPY DATE
2778 , p0_a374 OUT NOCOPY NUMBER
2779 , p0_a375 OUT NOCOPY NUMBER
2780 )
2781 as
2782 ddx_entry_rec ams_listentry_pvt.entry_rec_type;
2783 ddindx binary_integer; indx binary_integer;
2784 begin
2785
2786 -- copy data to the local IN or IN-OUT args, if any
2787
2788 -- here's the delegated call to the old PL/SQL routine
2789 ams_listentry_pub.init_entry_rec(ddx_entry_rec);
2790
2791 -- copy data back from the local OUT or IN-OUT args, if any
2792 p0_a0 := rosetta_g_miss_num_map(ddx_entry_rec.list_entry_id);
2793 p0_a1 := rosetta_g_miss_num_map(ddx_entry_rec.list_header_id);
2794 p0_a2 := ddx_entry_rec.last_update_date;
2795 p0_a3 := rosetta_g_miss_num_map(ddx_entry_rec.last_updated_by);
2796 p0_a4 := ddx_entry_rec.creation_date;
2797 p0_a5 := rosetta_g_miss_num_map(ddx_entry_rec.created_by);
2798 p0_a6 := rosetta_g_miss_num_map(ddx_entry_rec.last_update_login);
2799 p0_a7 := rosetta_g_miss_num_map(ddx_entry_rec.object_version_number);
2800 p0_a8 := rosetta_g_miss_num_map(ddx_entry_rec.list_select_action_id);
2801 p0_a9 := ddx_entry_rec.arc_list_select_action_from;
2802 p0_a10 := ddx_entry_rec.list_select_action_from_name;
2803 p0_a11 := ddx_entry_rec.source_code;
2804 p0_a12 := ddx_entry_rec.arc_list_used_by_source;
2805 p0_a13 := rosetta_g_miss_num_map(ddx_entry_rec.source_code_for_id);
2806 p0_a14 := ddx_entry_rec.pin_code;
2807 p0_a15 := rosetta_g_miss_num_map(ddx_entry_rec.list_entry_source_system_id);
2808 p0_a16 := ddx_entry_rec.list_entry_source_system_type;
2809 p0_a17 := rosetta_g_miss_num_map(ddx_entry_rec.view_application_id);
2810 p0_a18 := ddx_entry_rec.manually_entered_flag;
2811 p0_a19 := ddx_entry_rec.marked_as_duplicate_flag;
2812 p0_a20 := ddx_entry_rec.marked_as_random_flag;
2813 p0_a21 := ddx_entry_rec.part_of_control_group_flag;
2814 p0_a22 := ddx_entry_rec.exclude_in_triggered_list_flag;
2815 p0_a23 := ddx_entry_rec.enabled_flag;
2816 p0_a24 := ddx_entry_rec.cell_code;
2817 p0_a25 := ddx_entry_rec.dedupe_key;
2818 p0_a26 := rosetta_g_miss_num_map(ddx_entry_rec.randomly_generated_number);
2819 p0_a27 := rosetta_g_miss_num_map(ddx_entry_rec.campaign_id);
2820 p0_a28 := rosetta_g_miss_num_map(ddx_entry_rec.media_id);
2821 p0_a29 := rosetta_g_miss_num_map(ddx_entry_rec.channel_id);
2822 p0_a30 := rosetta_g_miss_num_map(ddx_entry_rec.channel_schedule_id);
2823 p0_a31 := rosetta_g_miss_num_map(ddx_entry_rec.event_offer_id);
2824 p0_a32 := rosetta_g_miss_num_map(ddx_entry_rec.customer_id);
2825 p0_a33 := rosetta_g_miss_num_map(ddx_entry_rec.market_segment_id);
2826 p0_a34 := rosetta_g_miss_num_map(ddx_entry_rec.vendor_id);
2827 p0_a35 := ddx_entry_rec.transfer_flag;
2828 p0_a36 := ddx_entry_rec.transfer_status;
2829 p0_a37 := ddx_entry_rec.list_source;
2830 p0_a38 := rosetta_g_miss_num_map(ddx_entry_rec.duplicate_master_entry_id);
2831 p0_a39 := ddx_entry_rec.marked_flag;
2832 p0_a40 := rosetta_g_miss_num_map(ddx_entry_rec.lead_id);
2833 p0_a41 := rosetta_g_miss_num_map(ddx_entry_rec.letter_id);
2834 p0_a42 := rosetta_g_miss_num_map(ddx_entry_rec.picking_header_id);
2835 p0_a43 := rosetta_g_miss_num_map(ddx_entry_rec.batch_id);
2836 p0_a44 := ddx_entry_rec.first_name;
2837 p0_a45 := ddx_entry_rec.last_name;
2838 p0_a46 := ddx_entry_rec.customer_name;
2839 p0_a47 := ddx_entry_rec.col1;
2840 p0_a48 := ddx_entry_rec.col2;
2841 p0_a49 := ddx_entry_rec.col3;
2842 p0_a50 := ddx_entry_rec.col4;
2843 p0_a51 := ddx_entry_rec.col5;
2844 p0_a52 := ddx_entry_rec.col6;
2845 p0_a53 := ddx_entry_rec.col7;
2846 p0_a54 := ddx_entry_rec.col8;
2847 p0_a55 := ddx_entry_rec.col9;
2848 p0_a56 := ddx_entry_rec.col10;
2849 p0_a57 := ddx_entry_rec.col11;
2850 p0_a58 := ddx_entry_rec.col12;
2851 p0_a59 := ddx_entry_rec.col13;
2852 p0_a60 := ddx_entry_rec.col14;
2853 p0_a61 := ddx_entry_rec.col15;
2854 p0_a62 := ddx_entry_rec.col16;
2855 p0_a63 := ddx_entry_rec.col17;
2856 p0_a64 := ddx_entry_rec.col18;
2857 p0_a65 := ddx_entry_rec.col19;
2858 p0_a66 := ddx_entry_rec.col20;
2859 p0_a67 := ddx_entry_rec.col21;
2860 p0_a68 := ddx_entry_rec.col22;
2861 p0_a69 := ddx_entry_rec.col23;
2862 p0_a70 := ddx_entry_rec.col24;
2863 p0_a71 := ddx_entry_rec.col25;
2864 p0_a72 := ddx_entry_rec.col26;
2865 p0_a73 := ddx_entry_rec.col27;
2866 p0_a74 := ddx_entry_rec.col28;
2867 p0_a75 := ddx_entry_rec.col29;
2868 p0_a76 := ddx_entry_rec.col30;
2869 p0_a77 := ddx_entry_rec.col31;
2870 p0_a78 := ddx_entry_rec.col32;
2871 p0_a79 := ddx_entry_rec.col33;
2872 p0_a80 := ddx_entry_rec.col34;
2873 p0_a81 := ddx_entry_rec.col35;
2874 p0_a82 := ddx_entry_rec.col36;
2875 p0_a83 := ddx_entry_rec.col37;
2876 p0_a84 := ddx_entry_rec.col38;
2877 p0_a85 := ddx_entry_rec.col39;
2878 p0_a86 := ddx_entry_rec.col40;
2879 p0_a87 := ddx_entry_rec.col41;
2880 p0_a88 := ddx_entry_rec.col42;
2881 p0_a89 := ddx_entry_rec.col43;
2882 p0_a90 := ddx_entry_rec.col44;
2883 p0_a91 := ddx_entry_rec.col45;
2884 p0_a92 := ddx_entry_rec.col46;
2885 p0_a93 := ddx_entry_rec.col47;
2886 p0_a94 := ddx_entry_rec.col48;
2887 p0_a95 := ddx_entry_rec.col49;
2888 p0_a96 := ddx_entry_rec.col50;
2889 p0_a97 := ddx_entry_rec.col51;
2890 p0_a98 := ddx_entry_rec.col52;
2891 p0_a99 := ddx_entry_rec.col53;
2892 p0_a100 := ddx_entry_rec.col54;
2893 p0_a101 := ddx_entry_rec.col55;
2894 p0_a102 := ddx_entry_rec.col56;
2895 p0_a103 := ddx_entry_rec.col57;
2896 p0_a104 := ddx_entry_rec.col58;
2897 p0_a105 := ddx_entry_rec.col59;
2898 p0_a106 := ddx_entry_rec.col60;
2899 p0_a107 := ddx_entry_rec.col61;
2900 p0_a108 := ddx_entry_rec.col62;
2901 p0_a109 := ddx_entry_rec.col63;
2902 p0_a110 := ddx_entry_rec.col64;
2903 p0_a111 := ddx_entry_rec.col65;
2904 p0_a112 := ddx_entry_rec.col66;
2905 p0_a113 := ddx_entry_rec.col67;
2906 p0_a114 := ddx_entry_rec.col68;
2907 p0_a115 := ddx_entry_rec.col69;
2908 p0_a116 := ddx_entry_rec.col70;
2909 p0_a117 := ddx_entry_rec.col71;
2910 p0_a118 := ddx_entry_rec.col72;
2911 p0_a119 := ddx_entry_rec.col73;
2912 p0_a120 := ddx_entry_rec.col74;
2913 p0_a121 := ddx_entry_rec.col75;
2914 p0_a122 := ddx_entry_rec.col76;
2915 p0_a123 := ddx_entry_rec.col77;
2916 p0_a124 := ddx_entry_rec.col78;
2917 p0_a125 := ddx_entry_rec.col79;
2918 p0_a126 := ddx_entry_rec.col80;
2919 p0_a127 := ddx_entry_rec.col81;
2920 p0_a128 := ddx_entry_rec.col82;
2921 p0_a129 := ddx_entry_rec.col83;
2922 p0_a130 := ddx_entry_rec.col84;
2923 p0_a131 := ddx_entry_rec.col85;
2924 p0_a132 := ddx_entry_rec.col86;
2925 p0_a133 := ddx_entry_rec.col87;
2926 p0_a134 := ddx_entry_rec.col88;
2927 p0_a135 := ddx_entry_rec.col89;
2928 p0_a136 := ddx_entry_rec.col90;
2929 p0_a137 := ddx_entry_rec.col91;
2930 p0_a138 := ddx_entry_rec.col92;
2931 p0_a139 := ddx_entry_rec.col93;
2932 p0_a140 := ddx_entry_rec.col94;
2933 p0_a141 := ddx_entry_rec.col95;
2934 p0_a142 := ddx_entry_rec.col96;
2935 p0_a143 := ddx_entry_rec.col97;
2936 p0_a144 := ddx_entry_rec.col98;
2937 p0_a145 := ddx_entry_rec.col99;
2938 p0_a146 := ddx_entry_rec.col100;
2939 p0_a147 := ddx_entry_rec.col101;
2940 p0_a148 := ddx_entry_rec.col102;
2941 p0_a149 := ddx_entry_rec.col103;
2942 p0_a150 := ddx_entry_rec.col104;
2943 p0_a151 := ddx_entry_rec.col105;
2944 p0_a152 := ddx_entry_rec.col106;
2945 p0_a153 := ddx_entry_rec.col107;
2946 p0_a154 := ddx_entry_rec.col108;
2947 p0_a155 := ddx_entry_rec.col109;
2948 p0_a156 := ddx_entry_rec.col110;
2949 p0_a157 := ddx_entry_rec.col111;
2950 p0_a158 := ddx_entry_rec.col112;
2951 p0_a159 := ddx_entry_rec.col113;
2952 p0_a160 := ddx_entry_rec.col114;
2953 p0_a161 := ddx_entry_rec.col115;
2954 p0_a162 := ddx_entry_rec.col116;
2955 p0_a163 := ddx_entry_rec.col117;
2956 p0_a164 := ddx_entry_rec.col118;
2957 p0_a165 := ddx_entry_rec.col119;
2958 p0_a166 := ddx_entry_rec.col120;
2959 p0_a167 := ddx_entry_rec.col121;
2960 p0_a168 := ddx_entry_rec.col122;
2961 p0_a169 := ddx_entry_rec.col123;
2962 p0_a170 := ddx_entry_rec.col124;
2963 p0_a171 := ddx_entry_rec.col125;
2964 p0_a172 := ddx_entry_rec.col126;
2965 p0_a173 := ddx_entry_rec.col127;
2966 p0_a174 := ddx_entry_rec.col128;
2967 p0_a175 := ddx_entry_rec.col129;
2968 p0_a176 := ddx_entry_rec.col130;
2969 p0_a177 := ddx_entry_rec.col131;
2970 p0_a178 := ddx_entry_rec.col132;
2971 p0_a179 := ddx_entry_rec.col133;
2972 p0_a180 := ddx_entry_rec.col134;
2973 p0_a181 := ddx_entry_rec.col135;
2974 p0_a182 := ddx_entry_rec.col136;
2975 p0_a183 := ddx_entry_rec.col137;
2976 p0_a184 := ddx_entry_rec.col138;
2977 p0_a185 := ddx_entry_rec.col139;
2978 p0_a186 := ddx_entry_rec.col140;
2979 p0_a187 := ddx_entry_rec.col141;
2980 p0_a188 := ddx_entry_rec.col142;
2981 p0_a189 := ddx_entry_rec.col143;
2982 p0_a190 := ddx_entry_rec.col144;
2983 p0_a191 := ddx_entry_rec.col145;
2984 p0_a192 := ddx_entry_rec.col146;
2985 p0_a193 := ddx_entry_rec.col147;
2986 p0_a194 := ddx_entry_rec.col148;
2987 p0_a195 := ddx_entry_rec.col149;
2988 p0_a196 := ddx_entry_rec.col150;
2989 p0_a197 := ddx_entry_rec.col151;
2990 p0_a198 := ddx_entry_rec.col152;
2991 p0_a199 := ddx_entry_rec.col153;
2992 p0_a200 := ddx_entry_rec.col154;
2993 p0_a201 := ddx_entry_rec.col155;
2994 p0_a202 := ddx_entry_rec.col156;
2995 p0_a203 := ddx_entry_rec.col157;
2996 p0_a204 := ddx_entry_rec.col158;
2997 p0_a205 := ddx_entry_rec.col159;
2998 p0_a206 := ddx_entry_rec.col160;
2999 p0_a207 := ddx_entry_rec.col161;
3000 p0_a208 := ddx_entry_rec.col162;
3001 p0_a209 := ddx_entry_rec.col163;
3002 p0_a210 := ddx_entry_rec.col164;
3003 p0_a211 := ddx_entry_rec.col165;
3004 p0_a212 := ddx_entry_rec.col166;
3005 p0_a213 := ddx_entry_rec.col167;
3006 p0_a214 := ddx_entry_rec.col168;
3007 p0_a215 := ddx_entry_rec.col169;
3008 p0_a216 := ddx_entry_rec.col170;
3009 p0_a217 := ddx_entry_rec.col171;
3010 p0_a218 := ddx_entry_rec.col172;
3011 p0_a219 := ddx_entry_rec.col173;
3012 p0_a220 := ddx_entry_rec.col174;
3013 p0_a221 := ddx_entry_rec.col175;
3014 p0_a222 := ddx_entry_rec.col176;
3015 p0_a223 := ddx_entry_rec.col177;
3016 p0_a224 := ddx_entry_rec.col178;
3017 p0_a225 := ddx_entry_rec.col179;
3018 p0_a226 := ddx_entry_rec.col180;
3019 p0_a227 := ddx_entry_rec.col181;
3020 p0_a228 := ddx_entry_rec.col182;
3021 p0_a229 := ddx_entry_rec.col183;
3022 p0_a230 := ddx_entry_rec.col184;
3023 p0_a231 := ddx_entry_rec.col185;
3024 p0_a232 := ddx_entry_rec.col186;
3025 p0_a233 := ddx_entry_rec.col187;
3026 p0_a234 := ddx_entry_rec.col188;
3027 p0_a235 := ddx_entry_rec.col189;
3028 p0_a236 := ddx_entry_rec.col190;
3029 p0_a237 := ddx_entry_rec.col191;
3030 p0_a238 := ddx_entry_rec.col192;
3031 p0_a239 := ddx_entry_rec.col193;
3032 p0_a240 := ddx_entry_rec.col194;
3033 p0_a241 := ddx_entry_rec.col195;
3034 p0_a242 := ddx_entry_rec.col196;
3035 p0_a243 := ddx_entry_rec.col197;
3036 p0_a244 := ddx_entry_rec.col198;
3037 p0_a245 := ddx_entry_rec.col199;
3038 p0_a246 := ddx_entry_rec.col200;
3039 p0_a247 := ddx_entry_rec.col201;
3040 p0_a248 := ddx_entry_rec.col202;
3041 p0_a249 := ddx_entry_rec.col203;
3042 p0_a250 := ddx_entry_rec.col204;
3043 p0_a251 := ddx_entry_rec.col205;
3044 p0_a252 := ddx_entry_rec.col206;
3045 p0_a253 := ddx_entry_rec.col207;
3046 p0_a254 := ddx_entry_rec.col208;
3047 p0_a255 := ddx_entry_rec.col209;
3048 p0_a256 := ddx_entry_rec.col210;
3049 p0_a257 := ddx_entry_rec.col211;
3050 p0_a258 := ddx_entry_rec.col212;
3051 p0_a259 := ddx_entry_rec.col213;
3052 p0_a260 := ddx_entry_rec.col214;
3053 p0_a261 := ddx_entry_rec.col215;
3054 p0_a262 := ddx_entry_rec.col216;
3055 p0_a263 := ddx_entry_rec.col217;
3056 p0_a264 := ddx_entry_rec.col218;
3057 p0_a265 := ddx_entry_rec.col219;
3058 p0_a266 := ddx_entry_rec.col220;
3059 p0_a267 := ddx_entry_rec.col221;
3060 p0_a268 := ddx_entry_rec.col222;
3061 p0_a269 := ddx_entry_rec.col223;
3062 p0_a270 := ddx_entry_rec.col224;
3063 p0_a271 := ddx_entry_rec.col225;
3064 p0_a272 := ddx_entry_rec.col226;
3065 p0_a273 := ddx_entry_rec.col227;
3066 p0_a274 := ddx_entry_rec.col228;
3067 p0_a275 := ddx_entry_rec.col229;
3068 p0_a276 := ddx_entry_rec.col230;
3069 p0_a277 := ddx_entry_rec.col231;
3070 p0_a278 := ddx_entry_rec.col232;
3071 p0_a279 := ddx_entry_rec.col233;
3072 p0_a280 := ddx_entry_rec.col234;
3073 p0_a281 := ddx_entry_rec.col235;
3074 p0_a282 := ddx_entry_rec.col236;
3075 p0_a283 := ddx_entry_rec.col237;
3076 p0_a284 := ddx_entry_rec.col238;
3077 p0_a285 := ddx_entry_rec.col239;
3078 p0_a286 := ddx_entry_rec.col240;
3079 p0_a287 := ddx_entry_rec.col241;
3080 p0_a288 := ddx_entry_rec.col242;
3081 p0_a289 := ddx_entry_rec.col243;
3082 p0_a290 := ddx_entry_rec.col244;
3083 p0_a291 := ddx_entry_rec.col245;
3084 p0_a292 := ddx_entry_rec.col246;
3085 p0_a293 := ddx_entry_rec.col247;
3086 p0_a294 := ddx_entry_rec.col248;
3087 p0_a295 := ddx_entry_rec.col249;
3088 p0_a296 := ddx_entry_rec.col250;
3089 p0_a297 := ddx_entry_rec.col251;
3090 p0_a298 := ddx_entry_rec.col252;
3091 p0_a299 := ddx_entry_rec.col253;
3092 p0_a300 := ddx_entry_rec.col254;
3093 p0_a301 := ddx_entry_rec.col255;
3094 p0_a302 := ddx_entry_rec.col256;
3095 p0_a303 := ddx_entry_rec.col257;
3096 p0_a304 := ddx_entry_rec.col258;
3097 p0_a305 := ddx_entry_rec.col259;
3098 p0_a306 := ddx_entry_rec.col260;
3099 p0_a307 := ddx_entry_rec.col261;
3100 p0_a308 := ddx_entry_rec.col262;
3101 p0_a309 := ddx_entry_rec.col263;
3102 p0_a310 := ddx_entry_rec.col264;
3103 p0_a311 := ddx_entry_rec.col265;
3104 p0_a312 := ddx_entry_rec.col266;
3105 p0_a313 := ddx_entry_rec.col267;
3106 p0_a314 := ddx_entry_rec.col268;
3107 p0_a315 := ddx_entry_rec.col269;
3108 p0_a316 := ddx_entry_rec.col270;
3109 p0_a317 := ddx_entry_rec.col271;
3110 p0_a318 := ddx_entry_rec.col272;
3111 p0_a319 := ddx_entry_rec.col273;
3112 p0_a320 := ddx_entry_rec.col274;
3113 p0_a321 := ddx_entry_rec.col275;
3114 p0_a322 := ddx_entry_rec.col276;
3115 p0_a323 := ddx_entry_rec.col277;
3116 p0_a324 := ddx_entry_rec.col278;
3117 p0_a325 := ddx_entry_rec.col279;
3118 p0_a326 := ddx_entry_rec.col280;
3119 p0_a327 := ddx_entry_rec.col281;
3120 p0_a328 := ddx_entry_rec.col282;
3121 p0_a329 := ddx_entry_rec.col283;
3122 p0_a330 := ddx_entry_rec.col284;
3123 p0_a331 := ddx_entry_rec.col285;
3124 p0_a332 := ddx_entry_rec.col286;
3125 p0_a333 := ddx_entry_rec.col287;
3126 p0_a334 := ddx_entry_rec.col288;
3127 p0_a335 := ddx_entry_rec.col289;
3128 p0_a336 := ddx_entry_rec.col290;
3129 p0_a337 := ddx_entry_rec.col291;
3130 p0_a338 := ddx_entry_rec.col292;
3131 p0_a339 := ddx_entry_rec.col293;
3132 p0_a340 := ddx_entry_rec.col294;
3133 p0_a341 := ddx_entry_rec.col295;
3134 p0_a342 := ddx_entry_rec.col296;
3135 p0_a343 := ddx_entry_rec.col297;
3136 p0_a344 := ddx_entry_rec.col298;
3137 p0_a345 := ddx_entry_rec.col299;
3138 p0_a346 := ddx_entry_rec.col300;
3139 p0_a347 := ddx_entry_rec.address_line1;
3140 p0_a348 := ddx_entry_rec.address_line2;
3141 p0_a349 := ddx_entry_rec.callback_flag;
3142 p0_a350 := ddx_entry_rec.city;
3143 p0_a351 := ddx_entry_rec.country;
3144 p0_a352 := ddx_entry_rec.do_not_use_flag;
3145 p0_a353 := ddx_entry_rec.do_not_use_reason;
3146 p0_a354 := ddx_entry_rec.email_address;
3147 p0_a355 := ddx_entry_rec.fax;
3148 p0_a356 := ddx_entry_rec.phone;
3149 p0_a357 := ddx_entry_rec.record_out_flag;
3150 p0_a358 := ddx_entry_rec.state;
3151 p0_a359 := ddx_entry_rec.suffix;
3152 p0_a360 := ddx_entry_rec.title;
3153 p0_a361 := ddx_entry_rec.usage_restriction;
3154 p0_a362 := ddx_entry_rec.zipcode;
3155 p0_a363 := ddx_entry_rec.curr_cp_country_code;
3156 p0_a364 := ddx_entry_rec.curr_cp_phone_number;
3157 p0_a365 := ddx_entry_rec.curr_cp_raw_phone_number;
3158 p0_a366 := rosetta_g_miss_num_map(ddx_entry_rec.curr_cp_area_code);
3159 p0_a367 := rosetta_g_miss_num_map(ddx_entry_rec.curr_cp_id);
3160 p0_a368 := rosetta_g_miss_num_map(ddx_entry_rec.curr_cp_index);
3161 p0_a369 := rosetta_g_miss_num_map(ddx_entry_rec.curr_cp_time_zone);
3162 p0_a370 := rosetta_g_miss_num_map(ddx_entry_rec.curr_cp_time_zone_aux);
3163 p0_a371 := rosetta_g_miss_num_map(ddx_entry_rec.imp_source_line_id);
3164 p0_a372 := ddx_entry_rec.next_call_time;
3165 p0_a373 := ddx_entry_rec.record_release_time;
3166 p0_a374 := rosetta_g_miss_num_map(ddx_entry_rec.party_id);
3167 p0_a375 := rosetta_g_miss_num_map(ddx_entry_rec.parent_party_id);
3168 end;
3169
3170 end ams_listentry_pub_w;