[Home] [Help]
PACKAGE BODY: APPS.AMS_LIST_ENTRIES_PUB_W
Source
1 package body ams_list_entries_pub_w as
2 /* $Header: amszlieb.pls 115.8 2002/11/22 08:58:14 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_list_entries(p_api_version_number NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , x_return_status OUT NOCOPY VARCHAR2
26 , x_msg_count OUT NOCOPY NUMBER
27 , x_msg_data OUT NOCOPY VARCHAR2
28 , x_list_entry_id OUT NOCOPY NUMBER
29 , p6_a0 NUMBER := 0-1962.0724
30 , p6_a1 NUMBER := 0-1962.0724
31 , p6_a2 DATE := fnd_api.g_miss_date
32 , p6_a3 NUMBER := 0-1962.0724
33 , p6_a4 DATE := fnd_api.g_miss_date
34 , p6_a5 NUMBER := 0-1962.0724
35 , p6_a6 NUMBER := 0-1962.0724
36 , p6_a7 NUMBER := 0-1962.0724
37 , p6_a8 NUMBER := 0-1962.0724
38 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
39 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
40 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
41 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
42 , p6_a13 NUMBER := 0-1962.0724
43 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
44 , p6_a15 NUMBER := 0-1962.0724
45 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
46 , p6_a17 NUMBER := 0-1962.0724
47 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
48 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
49 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
50 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
51 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
52 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
53 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
54 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
55 , p6_a26 NUMBER := 0-1962.0724
56 , p6_a27 NUMBER := 0-1962.0724
57 , p6_a28 NUMBER := 0-1962.0724
58 , p6_a29 NUMBER := 0-1962.0724
59 , p6_a30 NUMBER := 0-1962.0724
60 , p6_a31 NUMBER := 0-1962.0724
61 , p6_a32 NUMBER := 0-1962.0724
62 , p6_a33 NUMBER := 0-1962.0724
63 , p6_a34 NUMBER := 0-1962.0724
64 , p6_a35 VARCHAR2 := fnd_api.g_miss_char
65 , p6_a36 VARCHAR2 := fnd_api.g_miss_char
66 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
67 , p6_a38 NUMBER := 0-1962.0724
68 , p6_a39 VARCHAR2 := fnd_api.g_miss_char
69 , p6_a40 NUMBER := 0-1962.0724
70 , p6_a41 NUMBER := 0-1962.0724
71 , p6_a42 NUMBER := 0-1962.0724
72 , p6_a43 NUMBER := 0-1962.0724
73 , p6_a44 VARCHAR2 := fnd_api.g_miss_char
74 , p6_a45 VARCHAR2 := fnd_api.g_miss_char
75 , p6_a46 VARCHAR2 := fnd_api.g_miss_char
76 , p6_a47 VARCHAR2 := fnd_api.g_miss_char
77 , p6_a48 VARCHAR2 := fnd_api.g_miss_char
78 , p6_a49 VARCHAR2 := fnd_api.g_miss_char
79 , p6_a50 VARCHAR2 := fnd_api.g_miss_char
80 , p6_a51 VARCHAR2 := fnd_api.g_miss_char
81 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
82 , p6_a53 VARCHAR2 := fnd_api.g_miss_char
83 , p6_a54 VARCHAR2 := fnd_api.g_miss_char
84 , p6_a55 VARCHAR2 := fnd_api.g_miss_char
85 , p6_a56 VARCHAR2 := fnd_api.g_miss_char
86 , p6_a57 VARCHAR2 := fnd_api.g_miss_char
87 , p6_a58 VARCHAR2 := fnd_api.g_miss_char
88 , p6_a59 VARCHAR2 := fnd_api.g_miss_char
89 , p6_a60 VARCHAR2 := fnd_api.g_miss_char
90 , p6_a61 VARCHAR2 := fnd_api.g_miss_char
91 , p6_a62 VARCHAR2 := fnd_api.g_miss_char
92 , p6_a63 VARCHAR2 := fnd_api.g_miss_char
93 , p6_a64 VARCHAR2 := fnd_api.g_miss_char
94 , p6_a65 VARCHAR2 := fnd_api.g_miss_char
95 , p6_a66 VARCHAR2 := fnd_api.g_miss_char
96 , p6_a67 VARCHAR2 := fnd_api.g_miss_char
97 , p6_a68 VARCHAR2 := fnd_api.g_miss_char
98 , p6_a69 VARCHAR2 := fnd_api.g_miss_char
99 , p6_a70 VARCHAR2 := fnd_api.g_miss_char
100 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
101 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
102 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
103 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
104 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
105 , p6_a76 VARCHAR2 := fnd_api.g_miss_char
106 , p6_a77 VARCHAR2 := fnd_api.g_miss_char
107 , p6_a78 VARCHAR2 := fnd_api.g_miss_char
108 , p6_a79 VARCHAR2 := fnd_api.g_miss_char
109 , p6_a80 VARCHAR2 := fnd_api.g_miss_char
110 , p6_a81 VARCHAR2 := fnd_api.g_miss_char
111 , p6_a82 VARCHAR2 := fnd_api.g_miss_char
112 , p6_a83 VARCHAR2 := fnd_api.g_miss_char
113 , p6_a84 VARCHAR2 := fnd_api.g_miss_char
114 , p6_a85 VARCHAR2 := fnd_api.g_miss_char
115 , p6_a86 VARCHAR2 := fnd_api.g_miss_char
116 , p6_a87 VARCHAR2 := fnd_api.g_miss_char
117 , p6_a88 VARCHAR2 := fnd_api.g_miss_char
118 , p6_a89 VARCHAR2 := fnd_api.g_miss_char
119 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
120 , p6_a91 VARCHAR2 := fnd_api.g_miss_char
121 , p6_a92 VARCHAR2 := fnd_api.g_miss_char
122 , p6_a93 VARCHAR2 := fnd_api.g_miss_char
123 , p6_a94 VARCHAR2 := fnd_api.g_miss_char
124 , p6_a95 VARCHAR2 := fnd_api.g_miss_char
125 , p6_a96 VARCHAR2 := fnd_api.g_miss_char
126 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
127 , p6_a98 VARCHAR2 := fnd_api.g_miss_char
128 , p6_a99 VARCHAR2 := fnd_api.g_miss_char
129 , p6_a100 VARCHAR2 := fnd_api.g_miss_char
130 , p6_a101 VARCHAR2 := fnd_api.g_miss_char
131 , p6_a102 VARCHAR2 := fnd_api.g_miss_char
132 , p6_a103 VARCHAR2 := fnd_api.g_miss_char
133 , p6_a104 VARCHAR2 := fnd_api.g_miss_char
134 , p6_a105 VARCHAR2 := fnd_api.g_miss_char
135 , p6_a106 VARCHAR2 := fnd_api.g_miss_char
136 , p6_a107 VARCHAR2 := fnd_api.g_miss_char
137 , p6_a108 VARCHAR2 := fnd_api.g_miss_char
138 , p6_a109 VARCHAR2 := fnd_api.g_miss_char
139 , p6_a110 VARCHAR2 := fnd_api.g_miss_char
140 , p6_a111 VARCHAR2 := fnd_api.g_miss_char
141 , p6_a112 VARCHAR2 := fnd_api.g_miss_char
142 , p6_a113 VARCHAR2 := fnd_api.g_miss_char
143 , p6_a114 VARCHAR2 := fnd_api.g_miss_char
144 , p6_a115 VARCHAR2 := fnd_api.g_miss_char
145 , p6_a116 VARCHAR2 := fnd_api.g_miss_char
146 , p6_a117 VARCHAR2 := fnd_api.g_miss_char
147 , p6_a118 VARCHAR2 := fnd_api.g_miss_char
148 , p6_a119 VARCHAR2 := fnd_api.g_miss_char
149 , p6_a120 VARCHAR2 := fnd_api.g_miss_char
150 , p6_a121 VARCHAR2 := fnd_api.g_miss_char
151 , p6_a122 VARCHAR2 := fnd_api.g_miss_char
152 , p6_a123 VARCHAR2 := fnd_api.g_miss_char
153 , p6_a124 VARCHAR2 := fnd_api.g_miss_char
154 , p6_a125 VARCHAR2 := fnd_api.g_miss_char
155 , p6_a126 VARCHAR2 := fnd_api.g_miss_char
156 , p6_a127 VARCHAR2 := fnd_api.g_miss_char
157 , p6_a128 VARCHAR2 := fnd_api.g_miss_char
158 , p6_a129 VARCHAR2 := fnd_api.g_miss_char
159 , p6_a130 VARCHAR2 := fnd_api.g_miss_char
160 , p6_a131 VARCHAR2 := fnd_api.g_miss_char
161 , p6_a132 VARCHAR2 := fnd_api.g_miss_char
162 , p6_a133 VARCHAR2 := fnd_api.g_miss_char
163 , p6_a134 VARCHAR2 := fnd_api.g_miss_char
164 , p6_a135 VARCHAR2 := fnd_api.g_miss_char
165 , p6_a136 VARCHAR2 := fnd_api.g_miss_char
166 , p6_a137 VARCHAR2 := fnd_api.g_miss_char
167 , p6_a138 VARCHAR2 := fnd_api.g_miss_char
168 , p6_a139 VARCHAR2 := fnd_api.g_miss_char
169 , p6_a140 VARCHAR2 := fnd_api.g_miss_char
170 , p6_a141 VARCHAR2 := fnd_api.g_miss_char
171 , p6_a142 VARCHAR2 := fnd_api.g_miss_char
172 , p6_a143 VARCHAR2 := fnd_api.g_miss_char
173 , p6_a144 VARCHAR2 := fnd_api.g_miss_char
174 , p6_a145 VARCHAR2 := fnd_api.g_miss_char
175 , p6_a146 VARCHAR2 := fnd_api.g_miss_char
176 , p6_a147 VARCHAR2 := fnd_api.g_miss_char
177 , p6_a148 VARCHAR2 := fnd_api.g_miss_char
178 , p6_a149 VARCHAR2 := fnd_api.g_miss_char
179 , p6_a150 VARCHAR2 := fnd_api.g_miss_char
180 , p6_a151 VARCHAR2 := fnd_api.g_miss_char
181 , p6_a152 VARCHAR2 := fnd_api.g_miss_char
182 , p6_a153 VARCHAR2 := fnd_api.g_miss_char
183 , p6_a154 VARCHAR2 := fnd_api.g_miss_char
184 , p6_a155 VARCHAR2 := fnd_api.g_miss_char
185 , p6_a156 VARCHAR2 := fnd_api.g_miss_char
186 , p6_a157 VARCHAR2 := fnd_api.g_miss_char
187 , p6_a158 VARCHAR2 := fnd_api.g_miss_char
188 , p6_a159 VARCHAR2 := fnd_api.g_miss_char
189 , p6_a160 VARCHAR2 := fnd_api.g_miss_char
190 , p6_a161 VARCHAR2 := fnd_api.g_miss_char
191 , p6_a162 VARCHAR2 := fnd_api.g_miss_char
192 , p6_a163 VARCHAR2 := fnd_api.g_miss_char
193 , p6_a164 VARCHAR2 := fnd_api.g_miss_char
194 , p6_a165 VARCHAR2 := fnd_api.g_miss_char
195 , p6_a166 VARCHAR2 := fnd_api.g_miss_char
196 , p6_a167 VARCHAR2 := fnd_api.g_miss_char
197 , p6_a168 VARCHAR2 := fnd_api.g_miss_char
198 , p6_a169 VARCHAR2 := fnd_api.g_miss_char
199 , p6_a170 VARCHAR2 := fnd_api.g_miss_char
200 , p6_a171 VARCHAR2 := fnd_api.g_miss_char
201 , p6_a172 VARCHAR2 := fnd_api.g_miss_char
202 , p6_a173 VARCHAR2 := fnd_api.g_miss_char
203 , p6_a174 VARCHAR2 := fnd_api.g_miss_char
204 , p6_a175 VARCHAR2 := fnd_api.g_miss_char
205 , p6_a176 VARCHAR2 := fnd_api.g_miss_char
206 , p6_a177 VARCHAR2 := fnd_api.g_miss_char
207 , p6_a178 VARCHAR2 := fnd_api.g_miss_char
208 , p6_a179 VARCHAR2 := fnd_api.g_miss_char
209 , p6_a180 VARCHAR2 := fnd_api.g_miss_char
210 , p6_a181 VARCHAR2 := fnd_api.g_miss_char
211 , p6_a182 VARCHAR2 := fnd_api.g_miss_char
212 , p6_a183 VARCHAR2 := fnd_api.g_miss_char
213 , p6_a184 VARCHAR2 := fnd_api.g_miss_char
214 , p6_a185 VARCHAR2 := fnd_api.g_miss_char
215 , p6_a186 VARCHAR2 := fnd_api.g_miss_char
216 , p6_a187 VARCHAR2 := fnd_api.g_miss_char
217 , p6_a188 VARCHAR2 := fnd_api.g_miss_char
218 , p6_a189 VARCHAR2 := fnd_api.g_miss_char
219 , p6_a190 VARCHAR2 := fnd_api.g_miss_char
220 , p6_a191 VARCHAR2 := fnd_api.g_miss_char
221 , p6_a192 VARCHAR2 := fnd_api.g_miss_char
222 , p6_a193 VARCHAR2 := fnd_api.g_miss_char
223 , p6_a194 VARCHAR2 := fnd_api.g_miss_char
224 , p6_a195 VARCHAR2 := fnd_api.g_miss_char
225 , p6_a196 VARCHAR2 := fnd_api.g_miss_char
226 , p6_a197 VARCHAR2 := fnd_api.g_miss_char
227 , p6_a198 VARCHAR2 := fnd_api.g_miss_char
228 , p6_a199 VARCHAR2 := fnd_api.g_miss_char
229 , p6_a200 VARCHAR2 := fnd_api.g_miss_char
230 , p6_a201 VARCHAR2 := fnd_api.g_miss_char
231 , p6_a202 VARCHAR2 := fnd_api.g_miss_char
232 , p6_a203 VARCHAR2 := fnd_api.g_miss_char
233 , p6_a204 VARCHAR2 := fnd_api.g_miss_char
234 , p6_a205 VARCHAR2 := fnd_api.g_miss_char
235 , p6_a206 VARCHAR2 := fnd_api.g_miss_char
236 , p6_a207 VARCHAR2 := fnd_api.g_miss_char
237 , p6_a208 VARCHAR2 := fnd_api.g_miss_char
238 , p6_a209 VARCHAR2 := fnd_api.g_miss_char
239 , p6_a210 VARCHAR2 := fnd_api.g_miss_char
240 , p6_a211 VARCHAR2 := fnd_api.g_miss_char
241 , p6_a212 VARCHAR2 := fnd_api.g_miss_char
242 , p6_a213 VARCHAR2 := fnd_api.g_miss_char
243 , p6_a214 VARCHAR2 := fnd_api.g_miss_char
244 , p6_a215 VARCHAR2 := fnd_api.g_miss_char
245 , p6_a216 VARCHAR2 := fnd_api.g_miss_char
246 , p6_a217 VARCHAR2 := fnd_api.g_miss_char
247 , p6_a218 VARCHAR2 := fnd_api.g_miss_char
248 , p6_a219 VARCHAR2 := fnd_api.g_miss_char
249 , p6_a220 VARCHAR2 := fnd_api.g_miss_char
250 , p6_a221 VARCHAR2 := fnd_api.g_miss_char
251 , p6_a222 VARCHAR2 := fnd_api.g_miss_char
252 , p6_a223 VARCHAR2 := fnd_api.g_miss_char
253 , p6_a224 VARCHAR2 := fnd_api.g_miss_char
254 , p6_a225 VARCHAR2 := fnd_api.g_miss_char
255 , p6_a226 VARCHAR2 := fnd_api.g_miss_char
256 , p6_a227 VARCHAR2 := fnd_api.g_miss_char
257 , p6_a228 VARCHAR2 := fnd_api.g_miss_char
258 , p6_a229 VARCHAR2 := fnd_api.g_miss_char
259 , p6_a230 VARCHAR2 := fnd_api.g_miss_char
260 , p6_a231 VARCHAR2 := fnd_api.g_miss_char
261 , p6_a232 VARCHAR2 := fnd_api.g_miss_char
262 , p6_a233 VARCHAR2 := fnd_api.g_miss_char
263 , p6_a234 VARCHAR2 := fnd_api.g_miss_char
264 , p6_a235 VARCHAR2 := fnd_api.g_miss_char
265 , p6_a236 VARCHAR2 := fnd_api.g_miss_char
266 , p6_a237 VARCHAR2 := fnd_api.g_miss_char
267 , p6_a238 VARCHAR2 := fnd_api.g_miss_char
268 , p6_a239 VARCHAR2 := fnd_api.g_miss_char
269 , p6_a240 VARCHAR2 := fnd_api.g_miss_char
270 , p6_a241 VARCHAR2 := fnd_api.g_miss_char
271 , p6_a242 VARCHAR2 := fnd_api.g_miss_char
272 , p6_a243 VARCHAR2 := fnd_api.g_miss_char
273 , p6_a244 VARCHAR2 := fnd_api.g_miss_char
274 , p6_a245 VARCHAR2 := fnd_api.g_miss_char
275 , p6_a246 VARCHAR2 := fnd_api.g_miss_char
276 , p6_a247 VARCHAR2 := fnd_api.g_miss_char
277 , p6_a248 VARCHAR2 := fnd_api.g_miss_char
278 , p6_a249 VARCHAR2 := fnd_api.g_miss_char
279 , p6_a250 VARCHAR2 := fnd_api.g_miss_char
280 , p6_a251 VARCHAR2 := fnd_api.g_miss_char
281 , p6_a252 VARCHAR2 := fnd_api.g_miss_char
282 , p6_a253 VARCHAR2 := fnd_api.g_miss_char
283 , p6_a254 VARCHAR2 := fnd_api.g_miss_char
284 , p6_a255 VARCHAR2 := fnd_api.g_miss_char
285 , p6_a256 VARCHAR2 := fnd_api.g_miss_char
286 , p6_a257 VARCHAR2 := fnd_api.g_miss_char
287 , p6_a258 NUMBER := 0-1962.0724
288 , p6_a259 NUMBER := 0-1962.0724
289 , p6_a260 NUMBER := 0-1962.0724
290 , p6_a261 VARCHAR2 := fnd_api.g_miss_char
291 , p6_a262 DATE := fnd_api.g_miss_date
292 , p6_a263 VARCHAR2 := fnd_api.g_miss_char
293 , p6_a264 VARCHAR2 := fnd_api.g_miss_char
294 , p6_a265 VARCHAR2 := fnd_api.g_miss_char
295 , p6_a266 VARCHAR2 := fnd_api.g_miss_char
296 , p6_a267 DATE := fnd_api.g_miss_date
297 )
298 as
299 ddp_list_entries_rec ams_list_entries_pvt.list_entries_rec_type;
300 ddindx binary_integer; indx binary_integer;
301 begin
302
303 -- copy data to the local IN or IN-OUT args, if any
304
305
306
307
308
309
310 ddp_list_entries_rec.list_entry_id := rosetta_g_miss_num_map(p6_a0);
311 ddp_list_entries_rec.list_header_id := rosetta_g_miss_num_map(p6_a1);
312 ddp_list_entries_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a2);
313 ddp_list_entries_rec.last_updated_by := rosetta_g_miss_num_map(p6_a3);
314 ddp_list_entries_rec.creation_date := rosetta_g_miss_date_in_map(p6_a4);
315 ddp_list_entries_rec.created_by := rosetta_g_miss_num_map(p6_a5);
316 ddp_list_entries_rec.last_update_login := rosetta_g_miss_num_map(p6_a6);
317 ddp_list_entries_rec.object_version_number := rosetta_g_miss_num_map(p6_a7);
318 ddp_list_entries_rec.list_select_action_id := rosetta_g_miss_num_map(p6_a8);
319 ddp_list_entries_rec.arc_list_select_action_from := p6_a9;
320 ddp_list_entries_rec.list_select_action_from_name := p6_a10;
321 ddp_list_entries_rec.source_code := p6_a11;
322 ddp_list_entries_rec.arc_list_used_by_source := p6_a12;
323 ddp_list_entries_rec.source_code_for_id := rosetta_g_miss_num_map(p6_a13);
324 ddp_list_entries_rec.pin_code := p6_a14;
325 ddp_list_entries_rec.list_entry_source_system_id := rosetta_g_miss_num_map(p6_a15);
326 ddp_list_entries_rec.list_entry_source_system_type := p6_a16;
327 ddp_list_entries_rec.view_application_id := rosetta_g_miss_num_map(p6_a17);
328 ddp_list_entries_rec.manually_entered_flag := p6_a18;
329 ddp_list_entries_rec.marked_as_duplicate_flag := p6_a19;
330 ddp_list_entries_rec.marked_as_random_flag := p6_a20;
331 ddp_list_entries_rec.part_of_control_group_flag := p6_a21;
332 ddp_list_entries_rec.exclude_in_triggered_list_flag := p6_a22;
333 ddp_list_entries_rec.enabled_flag := p6_a23;
334 ddp_list_entries_rec.cell_code := p6_a24;
335 ddp_list_entries_rec.dedupe_key := p6_a25;
336 ddp_list_entries_rec.randomly_generated_number := rosetta_g_miss_num_map(p6_a26);
337 ddp_list_entries_rec.campaign_id := rosetta_g_miss_num_map(p6_a27);
338 ddp_list_entries_rec.media_id := rosetta_g_miss_num_map(p6_a28);
339 ddp_list_entries_rec.channel_id := rosetta_g_miss_num_map(p6_a29);
340 ddp_list_entries_rec.channel_schedule_id := rosetta_g_miss_num_map(p6_a30);
341 ddp_list_entries_rec.event_offer_id := rosetta_g_miss_num_map(p6_a31);
342 ddp_list_entries_rec.customer_id := rosetta_g_miss_num_map(p6_a32);
343 ddp_list_entries_rec.market_segment_id := rosetta_g_miss_num_map(p6_a33);
344 ddp_list_entries_rec.vendor_id := rosetta_g_miss_num_map(p6_a34);
345 ddp_list_entries_rec.transfer_flag := p6_a35;
346 ddp_list_entries_rec.transfer_status := p6_a36;
347 ddp_list_entries_rec.list_source := p6_a37;
348 ddp_list_entries_rec.duplicate_master_entry_id := rosetta_g_miss_num_map(p6_a38);
349 ddp_list_entries_rec.marked_flag := p6_a39;
350 ddp_list_entries_rec.lead_id := rosetta_g_miss_num_map(p6_a40);
351 ddp_list_entries_rec.letter_id := rosetta_g_miss_num_map(p6_a41);
352 ddp_list_entries_rec.picking_header_id := rosetta_g_miss_num_map(p6_a42);
353 ddp_list_entries_rec.batch_id := rosetta_g_miss_num_map(p6_a43);
354 ddp_list_entries_rec.suffix := p6_a44;
355 ddp_list_entries_rec.first_name := p6_a45;
356 ddp_list_entries_rec.last_name := p6_a46;
357 ddp_list_entries_rec.customer_name := p6_a47;
358 ddp_list_entries_rec.title := p6_a48;
359 ddp_list_entries_rec.address_line1 := p6_a49;
360 ddp_list_entries_rec.address_line2 := p6_a50;
361 ddp_list_entries_rec.city := p6_a51;
362 ddp_list_entries_rec.state := p6_a52;
363 ddp_list_entries_rec.zipcode := p6_a53;
364 ddp_list_entries_rec.country := p6_a54;
365 ddp_list_entries_rec.fax := p6_a55;
366 ddp_list_entries_rec.phone := p6_a56;
367 ddp_list_entries_rec.email_address := p6_a57;
368 ddp_list_entries_rec.col1 := p6_a58;
369 ddp_list_entries_rec.col2 := p6_a59;
370 ddp_list_entries_rec.col3 := p6_a60;
371 ddp_list_entries_rec.col4 := p6_a61;
372 ddp_list_entries_rec.col5 := p6_a62;
373 ddp_list_entries_rec.col6 := p6_a63;
374 ddp_list_entries_rec.col7 := p6_a64;
375 ddp_list_entries_rec.col8 := p6_a65;
376 ddp_list_entries_rec.col9 := p6_a66;
377 ddp_list_entries_rec.col10 := p6_a67;
378 ddp_list_entries_rec.col11 := p6_a68;
379 ddp_list_entries_rec.col12 := p6_a69;
380 ddp_list_entries_rec.col13 := p6_a70;
381 ddp_list_entries_rec.col14 := p6_a71;
382 ddp_list_entries_rec.col15 := p6_a72;
383 ddp_list_entries_rec.col16 := p6_a73;
384 ddp_list_entries_rec.col17 := p6_a74;
385 ddp_list_entries_rec.col18 := p6_a75;
386 ddp_list_entries_rec.col19 := p6_a76;
387 ddp_list_entries_rec.col20 := p6_a77;
388 ddp_list_entries_rec.col21 := p6_a78;
389 ddp_list_entries_rec.col22 := p6_a79;
390 ddp_list_entries_rec.col23 := p6_a80;
391 ddp_list_entries_rec.col24 := p6_a81;
392 ddp_list_entries_rec.col25 := p6_a82;
393 ddp_list_entries_rec.col26 := p6_a83;
394 ddp_list_entries_rec.col27 := p6_a84;
395 ddp_list_entries_rec.col28 := p6_a85;
396 ddp_list_entries_rec.col29 := p6_a86;
397 ddp_list_entries_rec.col30 := p6_a87;
398 ddp_list_entries_rec.col31 := p6_a88;
399 ddp_list_entries_rec.col32 := p6_a89;
400 ddp_list_entries_rec.col33 := p6_a90;
401 ddp_list_entries_rec.col34 := p6_a91;
402 ddp_list_entries_rec.col35 := p6_a92;
403 ddp_list_entries_rec.col36 := p6_a93;
404 ddp_list_entries_rec.col37 := p6_a94;
405 ddp_list_entries_rec.col38 := p6_a95;
406 ddp_list_entries_rec.col39 := p6_a96;
407 ddp_list_entries_rec.col40 := p6_a97;
408 ddp_list_entries_rec.col41 := p6_a98;
409 ddp_list_entries_rec.col42 := p6_a99;
410 ddp_list_entries_rec.col43 := p6_a100;
411 ddp_list_entries_rec.col44 := p6_a101;
412 ddp_list_entries_rec.col45 := p6_a102;
413 ddp_list_entries_rec.col46 := p6_a103;
414 ddp_list_entries_rec.col47 := p6_a104;
415 ddp_list_entries_rec.col48 := p6_a105;
416 ddp_list_entries_rec.col49 := p6_a106;
417 ddp_list_entries_rec.col50 := p6_a107;
418 ddp_list_entries_rec.col51 := p6_a108;
419 ddp_list_entries_rec.col52 := p6_a109;
420 ddp_list_entries_rec.col53 := p6_a110;
421 ddp_list_entries_rec.col54 := p6_a111;
422 ddp_list_entries_rec.col55 := p6_a112;
423 ddp_list_entries_rec.col56 := p6_a113;
424 ddp_list_entries_rec.col57 := p6_a114;
425 ddp_list_entries_rec.col58 := p6_a115;
426 ddp_list_entries_rec.col59 := p6_a116;
427 ddp_list_entries_rec.col60 := p6_a117;
428 ddp_list_entries_rec.col61 := p6_a118;
429 ddp_list_entries_rec.col62 := p6_a119;
430 ddp_list_entries_rec.col63 := p6_a120;
431 ddp_list_entries_rec.col64 := p6_a121;
432 ddp_list_entries_rec.col65 := p6_a122;
433 ddp_list_entries_rec.col66 := p6_a123;
434 ddp_list_entries_rec.col67 := p6_a124;
435 ddp_list_entries_rec.col68 := p6_a125;
436 ddp_list_entries_rec.col69 := p6_a126;
437 ddp_list_entries_rec.col70 := p6_a127;
438 ddp_list_entries_rec.col71 := p6_a128;
439 ddp_list_entries_rec.col72 := p6_a129;
440 ddp_list_entries_rec.col73 := p6_a130;
441 ddp_list_entries_rec.col74 := p6_a131;
442 ddp_list_entries_rec.col75 := p6_a132;
443 ddp_list_entries_rec.col76 := p6_a133;
444 ddp_list_entries_rec.col77 := p6_a134;
445 ddp_list_entries_rec.col78 := p6_a135;
446 ddp_list_entries_rec.col79 := p6_a136;
447 ddp_list_entries_rec.col80 := p6_a137;
448 ddp_list_entries_rec.col81 := p6_a138;
449 ddp_list_entries_rec.col82 := p6_a139;
450 ddp_list_entries_rec.col83 := p6_a140;
451 ddp_list_entries_rec.col84 := p6_a141;
452 ddp_list_entries_rec.col85 := p6_a142;
453 ddp_list_entries_rec.col86 := p6_a143;
454 ddp_list_entries_rec.col87 := p6_a144;
455 ddp_list_entries_rec.col88 := p6_a145;
456 ddp_list_entries_rec.col89 := p6_a146;
457 ddp_list_entries_rec.col90 := p6_a147;
458 ddp_list_entries_rec.col91 := p6_a148;
459 ddp_list_entries_rec.col92 := p6_a149;
460 ddp_list_entries_rec.col93 := p6_a150;
461 ddp_list_entries_rec.col94 := p6_a151;
462 ddp_list_entries_rec.col95 := p6_a152;
463 ddp_list_entries_rec.col96 := p6_a153;
464 ddp_list_entries_rec.col97 := p6_a154;
465 ddp_list_entries_rec.col98 := p6_a155;
466 ddp_list_entries_rec.col99 := p6_a156;
467 ddp_list_entries_rec.col100 := p6_a157;
468 ddp_list_entries_rec.col101 := p6_a158;
469 ddp_list_entries_rec.col102 := p6_a159;
470 ddp_list_entries_rec.col103 := p6_a160;
471 ddp_list_entries_rec.col104 := p6_a161;
472 ddp_list_entries_rec.col105 := p6_a162;
473 ddp_list_entries_rec.col106 := p6_a163;
474 ddp_list_entries_rec.col107 := p6_a164;
475 ddp_list_entries_rec.col108 := p6_a165;
476 ddp_list_entries_rec.col109 := p6_a166;
477 ddp_list_entries_rec.col110 := p6_a167;
478 ddp_list_entries_rec.col111 := p6_a168;
479 ddp_list_entries_rec.col112 := p6_a169;
480 ddp_list_entries_rec.col113 := p6_a170;
481 ddp_list_entries_rec.col114 := p6_a171;
482 ddp_list_entries_rec.col115 := p6_a172;
483 ddp_list_entries_rec.col116 := p6_a173;
484 ddp_list_entries_rec.col117 := p6_a174;
485 ddp_list_entries_rec.col118 := p6_a175;
486 ddp_list_entries_rec.col119 := p6_a176;
487 ddp_list_entries_rec.col120 := p6_a177;
488 ddp_list_entries_rec.col121 := p6_a178;
489 ddp_list_entries_rec.col122 := p6_a179;
490 ddp_list_entries_rec.col123 := p6_a180;
491 ddp_list_entries_rec.col124 := p6_a181;
492 ddp_list_entries_rec.col125 := p6_a182;
493 ddp_list_entries_rec.col126 := p6_a183;
494 ddp_list_entries_rec.col127 := p6_a184;
495 ddp_list_entries_rec.col128 := p6_a185;
496 ddp_list_entries_rec.col129 := p6_a186;
497 ddp_list_entries_rec.col130 := p6_a187;
498 ddp_list_entries_rec.col131 := p6_a188;
499 ddp_list_entries_rec.col132 := p6_a189;
500 ddp_list_entries_rec.col133 := p6_a190;
501 ddp_list_entries_rec.col134 := p6_a191;
502 ddp_list_entries_rec.col135 := p6_a192;
503 ddp_list_entries_rec.col136 := p6_a193;
504 ddp_list_entries_rec.col137 := p6_a194;
505 ddp_list_entries_rec.col138 := p6_a195;
506 ddp_list_entries_rec.col139 := p6_a196;
507 ddp_list_entries_rec.col140 := p6_a197;
508 ddp_list_entries_rec.col141 := p6_a198;
509 ddp_list_entries_rec.col142 := p6_a199;
510 ddp_list_entries_rec.col143 := p6_a200;
511 ddp_list_entries_rec.col144 := p6_a201;
512 ddp_list_entries_rec.col145 := p6_a202;
513 ddp_list_entries_rec.col146 := p6_a203;
514 ddp_list_entries_rec.col147 := p6_a204;
515 ddp_list_entries_rec.col148 := p6_a205;
516 ddp_list_entries_rec.col149 := p6_a206;
517 ddp_list_entries_rec.col150 := p6_a207;
518 ddp_list_entries_rec.col151 := p6_a208;
519 ddp_list_entries_rec.col152 := p6_a209;
520 ddp_list_entries_rec.col153 := p6_a210;
521 ddp_list_entries_rec.col154 := p6_a211;
522 ddp_list_entries_rec.col155 := p6_a212;
523 ddp_list_entries_rec.col156 := p6_a213;
524 ddp_list_entries_rec.col157 := p6_a214;
525 ddp_list_entries_rec.col158 := p6_a215;
526 ddp_list_entries_rec.col159 := p6_a216;
527 ddp_list_entries_rec.col160 := p6_a217;
528 ddp_list_entries_rec.col161 := p6_a218;
529 ddp_list_entries_rec.col162 := p6_a219;
530 ddp_list_entries_rec.col163 := p6_a220;
531 ddp_list_entries_rec.col164 := p6_a221;
532 ddp_list_entries_rec.col165 := p6_a222;
533 ddp_list_entries_rec.col166 := p6_a223;
534 ddp_list_entries_rec.col167 := p6_a224;
535 ddp_list_entries_rec.col168 := p6_a225;
536 ddp_list_entries_rec.col169 := p6_a226;
537 ddp_list_entries_rec.col170 := p6_a227;
538 ddp_list_entries_rec.col171 := p6_a228;
539 ddp_list_entries_rec.col172 := p6_a229;
540 ddp_list_entries_rec.col173 := p6_a230;
541 ddp_list_entries_rec.col174 := p6_a231;
542 ddp_list_entries_rec.col175 := p6_a232;
543 ddp_list_entries_rec.col176 := p6_a233;
544 ddp_list_entries_rec.col177 := p6_a234;
545 ddp_list_entries_rec.col178 := p6_a235;
546 ddp_list_entries_rec.col179 := p6_a236;
547 ddp_list_entries_rec.col180 := p6_a237;
548 ddp_list_entries_rec.col181 := p6_a238;
549 ddp_list_entries_rec.col182 := p6_a239;
550 ddp_list_entries_rec.col183 := p6_a240;
551 ddp_list_entries_rec.col184 := p6_a241;
552 ddp_list_entries_rec.col185 := p6_a242;
553 ddp_list_entries_rec.col186 := p6_a243;
554 ddp_list_entries_rec.col187 := p6_a244;
555 ddp_list_entries_rec.col188 := p6_a245;
556 ddp_list_entries_rec.col189 := p6_a246;
557 ddp_list_entries_rec.col190 := p6_a247;
558 ddp_list_entries_rec.col191 := p6_a248;
559 ddp_list_entries_rec.col192 := p6_a249;
560 ddp_list_entries_rec.col193 := p6_a250;
561 ddp_list_entries_rec.col194 := p6_a251;
562 ddp_list_entries_rec.col195 := p6_a252;
563 ddp_list_entries_rec.col196 := p6_a253;
564 ddp_list_entries_rec.col197 := p6_a254;
565 ddp_list_entries_rec.col198 := p6_a255;
566 ddp_list_entries_rec.col199 := p6_a256;
567 ddp_list_entries_rec.col200 := p6_a257;
568 ddp_list_entries_rec.party_id := rosetta_g_miss_num_map(p6_a258);
569 ddp_list_entries_rec.parent_party_id := rosetta_g_miss_num_map(p6_a259);
570 ddp_list_entries_rec.imp_source_line_id := rosetta_g_miss_num_map(p6_a260);
571 ddp_list_entries_rec.usage_restriction := p6_a261;
572 ddp_list_entries_rec.next_call_time := rosetta_g_miss_date_in_map(p6_a262);
573 ddp_list_entries_rec.callback_flag := p6_a263;
574 ddp_list_entries_rec.do_not_use_flag := p6_a264;
575 ddp_list_entries_rec.do_not_use_reason := p6_a265;
576 ddp_list_entries_rec.record_out_flag := p6_a266;
577 ddp_list_entries_rec.record_release_time := rosetta_g_miss_date_in_map(p6_a267);
578
579
580 -- here's the delegated call to the old PL/SQL routine
581 ams_list_entries_pub.create_list_entries(p_api_version_number,
582 p_init_msg_list,
583 p_commit,
584 x_return_status,
585 x_msg_count,
586 x_msg_data,
587 ddp_list_entries_rec,
588 x_list_entry_id);
589
590 -- copy data back from the local OUT or IN-OUT args, if any
591
592
593
594
595
596
597
598 end;
599
600 procedure update_list_entries(p_api_version_number NUMBER
601 , p_init_msg_list VARCHAR2
602 , p_commit VARCHAR2
603 , x_return_status OUT NOCOPY VARCHAR2
604 , x_msg_count OUT NOCOPY NUMBER
605 , x_msg_data OUT NOCOPY VARCHAR2
606 , x_object_version_number OUT NOCOPY NUMBER
607 , p6_a0 NUMBER := 0-1962.0724
608 , p6_a1 NUMBER := 0-1962.0724
609 , p6_a2 DATE := fnd_api.g_miss_date
610 , p6_a3 NUMBER := 0-1962.0724
611 , p6_a4 DATE := fnd_api.g_miss_date
612 , p6_a5 NUMBER := 0-1962.0724
613 , p6_a6 NUMBER := 0-1962.0724
614 , p6_a7 NUMBER := 0-1962.0724
615 , p6_a8 NUMBER := 0-1962.0724
616 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
617 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
618 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
619 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
620 , p6_a13 NUMBER := 0-1962.0724
621 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
622 , p6_a15 NUMBER := 0-1962.0724
623 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
624 , p6_a17 NUMBER := 0-1962.0724
625 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
626 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
627 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
628 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
629 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
630 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
631 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
632 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
633 , p6_a26 NUMBER := 0-1962.0724
634 , p6_a27 NUMBER := 0-1962.0724
635 , p6_a28 NUMBER := 0-1962.0724
636 , p6_a29 NUMBER := 0-1962.0724
637 , p6_a30 NUMBER := 0-1962.0724
638 , p6_a31 NUMBER := 0-1962.0724
639 , p6_a32 NUMBER := 0-1962.0724
640 , p6_a33 NUMBER := 0-1962.0724
641 , p6_a34 NUMBER := 0-1962.0724
642 , p6_a35 VARCHAR2 := fnd_api.g_miss_char
643 , p6_a36 VARCHAR2 := fnd_api.g_miss_char
644 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
645 , p6_a38 NUMBER := 0-1962.0724
646 , p6_a39 VARCHAR2 := fnd_api.g_miss_char
647 , p6_a40 NUMBER := 0-1962.0724
648 , p6_a41 NUMBER := 0-1962.0724
649 , p6_a42 NUMBER := 0-1962.0724
650 , p6_a43 NUMBER := 0-1962.0724
651 , p6_a44 VARCHAR2 := fnd_api.g_miss_char
652 , p6_a45 VARCHAR2 := fnd_api.g_miss_char
653 , p6_a46 VARCHAR2 := fnd_api.g_miss_char
654 , p6_a47 VARCHAR2 := fnd_api.g_miss_char
655 , p6_a48 VARCHAR2 := fnd_api.g_miss_char
656 , p6_a49 VARCHAR2 := fnd_api.g_miss_char
657 , p6_a50 VARCHAR2 := fnd_api.g_miss_char
658 , p6_a51 VARCHAR2 := fnd_api.g_miss_char
659 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
660 , p6_a53 VARCHAR2 := fnd_api.g_miss_char
661 , p6_a54 VARCHAR2 := fnd_api.g_miss_char
662 , p6_a55 VARCHAR2 := fnd_api.g_miss_char
663 , p6_a56 VARCHAR2 := fnd_api.g_miss_char
664 , p6_a57 VARCHAR2 := fnd_api.g_miss_char
665 , p6_a58 VARCHAR2 := fnd_api.g_miss_char
666 , p6_a59 VARCHAR2 := fnd_api.g_miss_char
667 , p6_a60 VARCHAR2 := fnd_api.g_miss_char
668 , p6_a61 VARCHAR2 := fnd_api.g_miss_char
669 , p6_a62 VARCHAR2 := fnd_api.g_miss_char
670 , p6_a63 VARCHAR2 := fnd_api.g_miss_char
671 , p6_a64 VARCHAR2 := fnd_api.g_miss_char
672 , p6_a65 VARCHAR2 := fnd_api.g_miss_char
673 , p6_a66 VARCHAR2 := fnd_api.g_miss_char
674 , p6_a67 VARCHAR2 := fnd_api.g_miss_char
675 , p6_a68 VARCHAR2 := fnd_api.g_miss_char
676 , p6_a69 VARCHAR2 := fnd_api.g_miss_char
677 , p6_a70 VARCHAR2 := fnd_api.g_miss_char
678 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
679 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
680 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
681 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
682 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
683 , p6_a76 VARCHAR2 := fnd_api.g_miss_char
684 , p6_a77 VARCHAR2 := fnd_api.g_miss_char
685 , p6_a78 VARCHAR2 := fnd_api.g_miss_char
686 , p6_a79 VARCHAR2 := fnd_api.g_miss_char
687 , p6_a80 VARCHAR2 := fnd_api.g_miss_char
688 , p6_a81 VARCHAR2 := fnd_api.g_miss_char
689 , p6_a82 VARCHAR2 := fnd_api.g_miss_char
690 , p6_a83 VARCHAR2 := fnd_api.g_miss_char
691 , p6_a84 VARCHAR2 := fnd_api.g_miss_char
692 , p6_a85 VARCHAR2 := fnd_api.g_miss_char
693 , p6_a86 VARCHAR2 := fnd_api.g_miss_char
694 , p6_a87 VARCHAR2 := fnd_api.g_miss_char
695 , p6_a88 VARCHAR2 := fnd_api.g_miss_char
696 , p6_a89 VARCHAR2 := fnd_api.g_miss_char
697 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
698 , p6_a91 VARCHAR2 := fnd_api.g_miss_char
699 , p6_a92 VARCHAR2 := fnd_api.g_miss_char
700 , p6_a93 VARCHAR2 := fnd_api.g_miss_char
701 , p6_a94 VARCHAR2 := fnd_api.g_miss_char
702 , p6_a95 VARCHAR2 := fnd_api.g_miss_char
703 , p6_a96 VARCHAR2 := fnd_api.g_miss_char
704 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
705 , p6_a98 VARCHAR2 := fnd_api.g_miss_char
706 , p6_a99 VARCHAR2 := fnd_api.g_miss_char
707 , p6_a100 VARCHAR2 := fnd_api.g_miss_char
708 , p6_a101 VARCHAR2 := fnd_api.g_miss_char
709 , p6_a102 VARCHAR2 := fnd_api.g_miss_char
710 , p6_a103 VARCHAR2 := fnd_api.g_miss_char
711 , p6_a104 VARCHAR2 := fnd_api.g_miss_char
712 , p6_a105 VARCHAR2 := fnd_api.g_miss_char
713 , p6_a106 VARCHAR2 := fnd_api.g_miss_char
714 , p6_a107 VARCHAR2 := fnd_api.g_miss_char
715 , p6_a108 VARCHAR2 := fnd_api.g_miss_char
716 , p6_a109 VARCHAR2 := fnd_api.g_miss_char
717 , p6_a110 VARCHAR2 := fnd_api.g_miss_char
718 , p6_a111 VARCHAR2 := fnd_api.g_miss_char
719 , p6_a112 VARCHAR2 := fnd_api.g_miss_char
720 , p6_a113 VARCHAR2 := fnd_api.g_miss_char
721 , p6_a114 VARCHAR2 := fnd_api.g_miss_char
722 , p6_a115 VARCHAR2 := fnd_api.g_miss_char
723 , p6_a116 VARCHAR2 := fnd_api.g_miss_char
724 , p6_a117 VARCHAR2 := fnd_api.g_miss_char
725 , p6_a118 VARCHAR2 := fnd_api.g_miss_char
726 , p6_a119 VARCHAR2 := fnd_api.g_miss_char
727 , p6_a120 VARCHAR2 := fnd_api.g_miss_char
728 , p6_a121 VARCHAR2 := fnd_api.g_miss_char
729 , p6_a122 VARCHAR2 := fnd_api.g_miss_char
730 , p6_a123 VARCHAR2 := fnd_api.g_miss_char
731 , p6_a124 VARCHAR2 := fnd_api.g_miss_char
732 , p6_a125 VARCHAR2 := fnd_api.g_miss_char
733 , p6_a126 VARCHAR2 := fnd_api.g_miss_char
734 , p6_a127 VARCHAR2 := fnd_api.g_miss_char
735 , p6_a128 VARCHAR2 := fnd_api.g_miss_char
736 , p6_a129 VARCHAR2 := fnd_api.g_miss_char
737 , p6_a130 VARCHAR2 := fnd_api.g_miss_char
738 , p6_a131 VARCHAR2 := fnd_api.g_miss_char
739 , p6_a132 VARCHAR2 := fnd_api.g_miss_char
740 , p6_a133 VARCHAR2 := fnd_api.g_miss_char
741 , p6_a134 VARCHAR2 := fnd_api.g_miss_char
742 , p6_a135 VARCHAR2 := fnd_api.g_miss_char
743 , p6_a136 VARCHAR2 := fnd_api.g_miss_char
744 , p6_a137 VARCHAR2 := fnd_api.g_miss_char
745 , p6_a138 VARCHAR2 := fnd_api.g_miss_char
746 , p6_a139 VARCHAR2 := fnd_api.g_miss_char
747 , p6_a140 VARCHAR2 := fnd_api.g_miss_char
748 , p6_a141 VARCHAR2 := fnd_api.g_miss_char
749 , p6_a142 VARCHAR2 := fnd_api.g_miss_char
750 , p6_a143 VARCHAR2 := fnd_api.g_miss_char
751 , p6_a144 VARCHAR2 := fnd_api.g_miss_char
752 , p6_a145 VARCHAR2 := fnd_api.g_miss_char
753 , p6_a146 VARCHAR2 := fnd_api.g_miss_char
754 , p6_a147 VARCHAR2 := fnd_api.g_miss_char
755 , p6_a148 VARCHAR2 := fnd_api.g_miss_char
756 , p6_a149 VARCHAR2 := fnd_api.g_miss_char
757 , p6_a150 VARCHAR2 := fnd_api.g_miss_char
758 , p6_a151 VARCHAR2 := fnd_api.g_miss_char
759 , p6_a152 VARCHAR2 := fnd_api.g_miss_char
760 , p6_a153 VARCHAR2 := fnd_api.g_miss_char
761 , p6_a154 VARCHAR2 := fnd_api.g_miss_char
762 , p6_a155 VARCHAR2 := fnd_api.g_miss_char
763 , p6_a156 VARCHAR2 := fnd_api.g_miss_char
764 , p6_a157 VARCHAR2 := fnd_api.g_miss_char
765 , p6_a158 VARCHAR2 := fnd_api.g_miss_char
766 , p6_a159 VARCHAR2 := fnd_api.g_miss_char
767 , p6_a160 VARCHAR2 := fnd_api.g_miss_char
768 , p6_a161 VARCHAR2 := fnd_api.g_miss_char
769 , p6_a162 VARCHAR2 := fnd_api.g_miss_char
770 , p6_a163 VARCHAR2 := fnd_api.g_miss_char
771 , p6_a164 VARCHAR2 := fnd_api.g_miss_char
772 , p6_a165 VARCHAR2 := fnd_api.g_miss_char
773 , p6_a166 VARCHAR2 := fnd_api.g_miss_char
774 , p6_a167 VARCHAR2 := fnd_api.g_miss_char
775 , p6_a168 VARCHAR2 := fnd_api.g_miss_char
776 , p6_a169 VARCHAR2 := fnd_api.g_miss_char
777 , p6_a170 VARCHAR2 := fnd_api.g_miss_char
778 , p6_a171 VARCHAR2 := fnd_api.g_miss_char
779 , p6_a172 VARCHAR2 := fnd_api.g_miss_char
780 , p6_a173 VARCHAR2 := fnd_api.g_miss_char
781 , p6_a174 VARCHAR2 := fnd_api.g_miss_char
782 , p6_a175 VARCHAR2 := fnd_api.g_miss_char
783 , p6_a176 VARCHAR2 := fnd_api.g_miss_char
784 , p6_a177 VARCHAR2 := fnd_api.g_miss_char
785 , p6_a178 VARCHAR2 := fnd_api.g_miss_char
786 , p6_a179 VARCHAR2 := fnd_api.g_miss_char
787 , p6_a180 VARCHAR2 := fnd_api.g_miss_char
788 , p6_a181 VARCHAR2 := fnd_api.g_miss_char
789 , p6_a182 VARCHAR2 := fnd_api.g_miss_char
790 , p6_a183 VARCHAR2 := fnd_api.g_miss_char
791 , p6_a184 VARCHAR2 := fnd_api.g_miss_char
792 , p6_a185 VARCHAR2 := fnd_api.g_miss_char
793 , p6_a186 VARCHAR2 := fnd_api.g_miss_char
794 , p6_a187 VARCHAR2 := fnd_api.g_miss_char
795 , p6_a188 VARCHAR2 := fnd_api.g_miss_char
796 , p6_a189 VARCHAR2 := fnd_api.g_miss_char
797 , p6_a190 VARCHAR2 := fnd_api.g_miss_char
798 , p6_a191 VARCHAR2 := fnd_api.g_miss_char
799 , p6_a192 VARCHAR2 := fnd_api.g_miss_char
800 , p6_a193 VARCHAR2 := fnd_api.g_miss_char
801 , p6_a194 VARCHAR2 := fnd_api.g_miss_char
802 , p6_a195 VARCHAR2 := fnd_api.g_miss_char
803 , p6_a196 VARCHAR2 := fnd_api.g_miss_char
804 , p6_a197 VARCHAR2 := fnd_api.g_miss_char
805 , p6_a198 VARCHAR2 := fnd_api.g_miss_char
806 , p6_a199 VARCHAR2 := fnd_api.g_miss_char
807 , p6_a200 VARCHAR2 := fnd_api.g_miss_char
808 , p6_a201 VARCHAR2 := fnd_api.g_miss_char
809 , p6_a202 VARCHAR2 := fnd_api.g_miss_char
810 , p6_a203 VARCHAR2 := fnd_api.g_miss_char
811 , p6_a204 VARCHAR2 := fnd_api.g_miss_char
812 , p6_a205 VARCHAR2 := fnd_api.g_miss_char
813 , p6_a206 VARCHAR2 := fnd_api.g_miss_char
814 , p6_a207 VARCHAR2 := fnd_api.g_miss_char
815 , p6_a208 VARCHAR2 := fnd_api.g_miss_char
816 , p6_a209 VARCHAR2 := fnd_api.g_miss_char
817 , p6_a210 VARCHAR2 := fnd_api.g_miss_char
818 , p6_a211 VARCHAR2 := fnd_api.g_miss_char
819 , p6_a212 VARCHAR2 := fnd_api.g_miss_char
820 , p6_a213 VARCHAR2 := fnd_api.g_miss_char
821 , p6_a214 VARCHAR2 := fnd_api.g_miss_char
822 , p6_a215 VARCHAR2 := fnd_api.g_miss_char
823 , p6_a216 VARCHAR2 := fnd_api.g_miss_char
824 , p6_a217 VARCHAR2 := fnd_api.g_miss_char
825 , p6_a218 VARCHAR2 := fnd_api.g_miss_char
826 , p6_a219 VARCHAR2 := fnd_api.g_miss_char
827 , p6_a220 VARCHAR2 := fnd_api.g_miss_char
828 , p6_a221 VARCHAR2 := fnd_api.g_miss_char
829 , p6_a222 VARCHAR2 := fnd_api.g_miss_char
830 , p6_a223 VARCHAR2 := fnd_api.g_miss_char
831 , p6_a224 VARCHAR2 := fnd_api.g_miss_char
832 , p6_a225 VARCHAR2 := fnd_api.g_miss_char
833 , p6_a226 VARCHAR2 := fnd_api.g_miss_char
834 , p6_a227 VARCHAR2 := fnd_api.g_miss_char
835 , p6_a228 VARCHAR2 := fnd_api.g_miss_char
836 , p6_a229 VARCHAR2 := fnd_api.g_miss_char
837 , p6_a230 VARCHAR2 := fnd_api.g_miss_char
838 , p6_a231 VARCHAR2 := fnd_api.g_miss_char
839 , p6_a232 VARCHAR2 := fnd_api.g_miss_char
840 , p6_a233 VARCHAR2 := fnd_api.g_miss_char
841 , p6_a234 VARCHAR2 := fnd_api.g_miss_char
842 , p6_a235 VARCHAR2 := fnd_api.g_miss_char
843 , p6_a236 VARCHAR2 := fnd_api.g_miss_char
844 , p6_a237 VARCHAR2 := fnd_api.g_miss_char
845 , p6_a238 VARCHAR2 := fnd_api.g_miss_char
846 , p6_a239 VARCHAR2 := fnd_api.g_miss_char
847 , p6_a240 VARCHAR2 := fnd_api.g_miss_char
848 , p6_a241 VARCHAR2 := fnd_api.g_miss_char
849 , p6_a242 VARCHAR2 := fnd_api.g_miss_char
850 , p6_a243 VARCHAR2 := fnd_api.g_miss_char
851 , p6_a244 VARCHAR2 := fnd_api.g_miss_char
852 , p6_a245 VARCHAR2 := fnd_api.g_miss_char
853 , p6_a246 VARCHAR2 := fnd_api.g_miss_char
854 , p6_a247 VARCHAR2 := fnd_api.g_miss_char
855 , p6_a248 VARCHAR2 := fnd_api.g_miss_char
856 , p6_a249 VARCHAR2 := fnd_api.g_miss_char
857 , p6_a250 VARCHAR2 := fnd_api.g_miss_char
858 , p6_a251 VARCHAR2 := fnd_api.g_miss_char
859 , p6_a252 VARCHAR2 := fnd_api.g_miss_char
860 , p6_a253 VARCHAR2 := fnd_api.g_miss_char
861 , p6_a254 VARCHAR2 := fnd_api.g_miss_char
862 , p6_a255 VARCHAR2 := fnd_api.g_miss_char
863 , p6_a256 VARCHAR2 := fnd_api.g_miss_char
864 , p6_a257 VARCHAR2 := fnd_api.g_miss_char
865 , p6_a258 NUMBER := 0-1962.0724
866 , p6_a259 NUMBER := 0-1962.0724
867 , p6_a260 NUMBER := 0-1962.0724
868 , p6_a261 VARCHAR2 := fnd_api.g_miss_char
869 , p6_a262 DATE := fnd_api.g_miss_date
870 , p6_a263 VARCHAR2 := fnd_api.g_miss_char
871 , p6_a264 VARCHAR2 := fnd_api.g_miss_char
872 , p6_a265 VARCHAR2 := fnd_api.g_miss_char
873 , p6_a266 VARCHAR2 := fnd_api.g_miss_char
874 , p6_a267 DATE := fnd_api.g_miss_date
875 )
876 as
877 ddp_list_entries_rec ams_list_entries_pvt.list_entries_rec_type;
878 ddindx binary_integer; indx binary_integer;
879 begin
880
881 -- copy data to the local IN or IN-OUT args, if any
882
883
884
885
886
887
888 ddp_list_entries_rec.list_entry_id := rosetta_g_miss_num_map(p6_a0);
889 ddp_list_entries_rec.list_header_id := rosetta_g_miss_num_map(p6_a1);
890 ddp_list_entries_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a2);
891 ddp_list_entries_rec.last_updated_by := rosetta_g_miss_num_map(p6_a3);
892 ddp_list_entries_rec.creation_date := rosetta_g_miss_date_in_map(p6_a4);
893 ddp_list_entries_rec.created_by := rosetta_g_miss_num_map(p6_a5);
894 ddp_list_entries_rec.last_update_login := rosetta_g_miss_num_map(p6_a6);
895 ddp_list_entries_rec.object_version_number := rosetta_g_miss_num_map(p6_a7);
896 ddp_list_entries_rec.list_select_action_id := rosetta_g_miss_num_map(p6_a8);
897 ddp_list_entries_rec.arc_list_select_action_from := p6_a9;
898 ddp_list_entries_rec.list_select_action_from_name := p6_a10;
899 ddp_list_entries_rec.source_code := p6_a11;
900 ddp_list_entries_rec.arc_list_used_by_source := p6_a12;
901 ddp_list_entries_rec.source_code_for_id := rosetta_g_miss_num_map(p6_a13);
902 ddp_list_entries_rec.pin_code := p6_a14;
903 ddp_list_entries_rec.list_entry_source_system_id := rosetta_g_miss_num_map(p6_a15);
904 ddp_list_entries_rec.list_entry_source_system_type := p6_a16;
905 ddp_list_entries_rec.view_application_id := rosetta_g_miss_num_map(p6_a17);
906 ddp_list_entries_rec.manually_entered_flag := p6_a18;
907 ddp_list_entries_rec.marked_as_duplicate_flag := p6_a19;
908 ddp_list_entries_rec.marked_as_random_flag := p6_a20;
909 ddp_list_entries_rec.part_of_control_group_flag := p6_a21;
910 ddp_list_entries_rec.exclude_in_triggered_list_flag := p6_a22;
911 ddp_list_entries_rec.enabled_flag := p6_a23;
912 ddp_list_entries_rec.cell_code := p6_a24;
913 ddp_list_entries_rec.dedupe_key := p6_a25;
914 ddp_list_entries_rec.randomly_generated_number := rosetta_g_miss_num_map(p6_a26);
915 ddp_list_entries_rec.campaign_id := rosetta_g_miss_num_map(p6_a27);
916 ddp_list_entries_rec.media_id := rosetta_g_miss_num_map(p6_a28);
917 ddp_list_entries_rec.channel_id := rosetta_g_miss_num_map(p6_a29);
918 ddp_list_entries_rec.channel_schedule_id := rosetta_g_miss_num_map(p6_a30);
919 ddp_list_entries_rec.event_offer_id := rosetta_g_miss_num_map(p6_a31);
920 ddp_list_entries_rec.customer_id := rosetta_g_miss_num_map(p6_a32);
921 ddp_list_entries_rec.market_segment_id := rosetta_g_miss_num_map(p6_a33);
922 ddp_list_entries_rec.vendor_id := rosetta_g_miss_num_map(p6_a34);
923 ddp_list_entries_rec.transfer_flag := p6_a35;
924 ddp_list_entries_rec.transfer_status := p6_a36;
925 ddp_list_entries_rec.list_source := p6_a37;
926 ddp_list_entries_rec.duplicate_master_entry_id := rosetta_g_miss_num_map(p6_a38);
927 ddp_list_entries_rec.marked_flag := p6_a39;
928 ddp_list_entries_rec.lead_id := rosetta_g_miss_num_map(p6_a40);
929 ddp_list_entries_rec.letter_id := rosetta_g_miss_num_map(p6_a41);
930 ddp_list_entries_rec.picking_header_id := rosetta_g_miss_num_map(p6_a42);
931 ddp_list_entries_rec.batch_id := rosetta_g_miss_num_map(p6_a43);
932 ddp_list_entries_rec.suffix := p6_a44;
933 ddp_list_entries_rec.first_name := p6_a45;
934 ddp_list_entries_rec.last_name := p6_a46;
935 ddp_list_entries_rec.customer_name := p6_a47;
936 ddp_list_entries_rec.title := p6_a48;
937 ddp_list_entries_rec.address_line1 := p6_a49;
938 ddp_list_entries_rec.address_line2 := p6_a50;
939 ddp_list_entries_rec.city := p6_a51;
940 ddp_list_entries_rec.state := p6_a52;
941 ddp_list_entries_rec.zipcode := p6_a53;
942 ddp_list_entries_rec.country := p6_a54;
943 ddp_list_entries_rec.fax := p6_a55;
944 ddp_list_entries_rec.phone := p6_a56;
945 ddp_list_entries_rec.email_address := p6_a57;
946 ddp_list_entries_rec.col1 := p6_a58;
947 ddp_list_entries_rec.col2 := p6_a59;
948 ddp_list_entries_rec.col3 := p6_a60;
949 ddp_list_entries_rec.col4 := p6_a61;
950 ddp_list_entries_rec.col5 := p6_a62;
951 ddp_list_entries_rec.col6 := p6_a63;
952 ddp_list_entries_rec.col7 := p6_a64;
953 ddp_list_entries_rec.col8 := p6_a65;
954 ddp_list_entries_rec.col9 := p6_a66;
955 ddp_list_entries_rec.col10 := p6_a67;
956 ddp_list_entries_rec.col11 := p6_a68;
957 ddp_list_entries_rec.col12 := p6_a69;
958 ddp_list_entries_rec.col13 := p6_a70;
959 ddp_list_entries_rec.col14 := p6_a71;
960 ddp_list_entries_rec.col15 := p6_a72;
961 ddp_list_entries_rec.col16 := p6_a73;
962 ddp_list_entries_rec.col17 := p6_a74;
963 ddp_list_entries_rec.col18 := p6_a75;
964 ddp_list_entries_rec.col19 := p6_a76;
965 ddp_list_entries_rec.col20 := p6_a77;
966 ddp_list_entries_rec.col21 := p6_a78;
967 ddp_list_entries_rec.col22 := p6_a79;
968 ddp_list_entries_rec.col23 := p6_a80;
969 ddp_list_entries_rec.col24 := p6_a81;
970 ddp_list_entries_rec.col25 := p6_a82;
971 ddp_list_entries_rec.col26 := p6_a83;
972 ddp_list_entries_rec.col27 := p6_a84;
973 ddp_list_entries_rec.col28 := p6_a85;
974 ddp_list_entries_rec.col29 := p6_a86;
975 ddp_list_entries_rec.col30 := p6_a87;
976 ddp_list_entries_rec.col31 := p6_a88;
977 ddp_list_entries_rec.col32 := p6_a89;
978 ddp_list_entries_rec.col33 := p6_a90;
979 ddp_list_entries_rec.col34 := p6_a91;
980 ddp_list_entries_rec.col35 := p6_a92;
981 ddp_list_entries_rec.col36 := p6_a93;
982 ddp_list_entries_rec.col37 := p6_a94;
983 ddp_list_entries_rec.col38 := p6_a95;
984 ddp_list_entries_rec.col39 := p6_a96;
985 ddp_list_entries_rec.col40 := p6_a97;
986 ddp_list_entries_rec.col41 := p6_a98;
987 ddp_list_entries_rec.col42 := p6_a99;
988 ddp_list_entries_rec.col43 := p6_a100;
989 ddp_list_entries_rec.col44 := p6_a101;
990 ddp_list_entries_rec.col45 := p6_a102;
991 ddp_list_entries_rec.col46 := p6_a103;
992 ddp_list_entries_rec.col47 := p6_a104;
993 ddp_list_entries_rec.col48 := p6_a105;
994 ddp_list_entries_rec.col49 := p6_a106;
995 ddp_list_entries_rec.col50 := p6_a107;
996 ddp_list_entries_rec.col51 := p6_a108;
997 ddp_list_entries_rec.col52 := p6_a109;
998 ddp_list_entries_rec.col53 := p6_a110;
999 ddp_list_entries_rec.col54 := p6_a111;
1000 ddp_list_entries_rec.col55 := p6_a112;
1001 ddp_list_entries_rec.col56 := p6_a113;
1002 ddp_list_entries_rec.col57 := p6_a114;
1003 ddp_list_entries_rec.col58 := p6_a115;
1004 ddp_list_entries_rec.col59 := p6_a116;
1005 ddp_list_entries_rec.col60 := p6_a117;
1006 ddp_list_entries_rec.col61 := p6_a118;
1007 ddp_list_entries_rec.col62 := p6_a119;
1008 ddp_list_entries_rec.col63 := p6_a120;
1009 ddp_list_entries_rec.col64 := p6_a121;
1010 ddp_list_entries_rec.col65 := p6_a122;
1011 ddp_list_entries_rec.col66 := p6_a123;
1012 ddp_list_entries_rec.col67 := p6_a124;
1013 ddp_list_entries_rec.col68 := p6_a125;
1014 ddp_list_entries_rec.col69 := p6_a126;
1015 ddp_list_entries_rec.col70 := p6_a127;
1016 ddp_list_entries_rec.col71 := p6_a128;
1017 ddp_list_entries_rec.col72 := p6_a129;
1018 ddp_list_entries_rec.col73 := p6_a130;
1019 ddp_list_entries_rec.col74 := p6_a131;
1020 ddp_list_entries_rec.col75 := p6_a132;
1021 ddp_list_entries_rec.col76 := p6_a133;
1022 ddp_list_entries_rec.col77 := p6_a134;
1023 ddp_list_entries_rec.col78 := p6_a135;
1024 ddp_list_entries_rec.col79 := p6_a136;
1025 ddp_list_entries_rec.col80 := p6_a137;
1026 ddp_list_entries_rec.col81 := p6_a138;
1027 ddp_list_entries_rec.col82 := p6_a139;
1028 ddp_list_entries_rec.col83 := p6_a140;
1029 ddp_list_entries_rec.col84 := p6_a141;
1030 ddp_list_entries_rec.col85 := p6_a142;
1031 ddp_list_entries_rec.col86 := p6_a143;
1032 ddp_list_entries_rec.col87 := p6_a144;
1033 ddp_list_entries_rec.col88 := p6_a145;
1034 ddp_list_entries_rec.col89 := p6_a146;
1035 ddp_list_entries_rec.col90 := p6_a147;
1036 ddp_list_entries_rec.col91 := p6_a148;
1037 ddp_list_entries_rec.col92 := p6_a149;
1038 ddp_list_entries_rec.col93 := p6_a150;
1039 ddp_list_entries_rec.col94 := p6_a151;
1040 ddp_list_entries_rec.col95 := p6_a152;
1041 ddp_list_entries_rec.col96 := p6_a153;
1042 ddp_list_entries_rec.col97 := p6_a154;
1043 ddp_list_entries_rec.col98 := p6_a155;
1044 ddp_list_entries_rec.col99 := p6_a156;
1045 ddp_list_entries_rec.col100 := p6_a157;
1046 ddp_list_entries_rec.col101 := p6_a158;
1047 ddp_list_entries_rec.col102 := p6_a159;
1048 ddp_list_entries_rec.col103 := p6_a160;
1049 ddp_list_entries_rec.col104 := p6_a161;
1050 ddp_list_entries_rec.col105 := p6_a162;
1051 ddp_list_entries_rec.col106 := p6_a163;
1052 ddp_list_entries_rec.col107 := p6_a164;
1053 ddp_list_entries_rec.col108 := p6_a165;
1054 ddp_list_entries_rec.col109 := p6_a166;
1055 ddp_list_entries_rec.col110 := p6_a167;
1056 ddp_list_entries_rec.col111 := p6_a168;
1057 ddp_list_entries_rec.col112 := p6_a169;
1058 ddp_list_entries_rec.col113 := p6_a170;
1059 ddp_list_entries_rec.col114 := p6_a171;
1060 ddp_list_entries_rec.col115 := p6_a172;
1061 ddp_list_entries_rec.col116 := p6_a173;
1062 ddp_list_entries_rec.col117 := p6_a174;
1063 ddp_list_entries_rec.col118 := p6_a175;
1064 ddp_list_entries_rec.col119 := p6_a176;
1065 ddp_list_entries_rec.col120 := p6_a177;
1066 ddp_list_entries_rec.col121 := p6_a178;
1067 ddp_list_entries_rec.col122 := p6_a179;
1068 ddp_list_entries_rec.col123 := p6_a180;
1069 ddp_list_entries_rec.col124 := p6_a181;
1070 ddp_list_entries_rec.col125 := p6_a182;
1071 ddp_list_entries_rec.col126 := p6_a183;
1072 ddp_list_entries_rec.col127 := p6_a184;
1073 ddp_list_entries_rec.col128 := p6_a185;
1074 ddp_list_entries_rec.col129 := p6_a186;
1075 ddp_list_entries_rec.col130 := p6_a187;
1076 ddp_list_entries_rec.col131 := p6_a188;
1077 ddp_list_entries_rec.col132 := p6_a189;
1078 ddp_list_entries_rec.col133 := p6_a190;
1079 ddp_list_entries_rec.col134 := p6_a191;
1080 ddp_list_entries_rec.col135 := p6_a192;
1081 ddp_list_entries_rec.col136 := p6_a193;
1082 ddp_list_entries_rec.col137 := p6_a194;
1083 ddp_list_entries_rec.col138 := p6_a195;
1084 ddp_list_entries_rec.col139 := p6_a196;
1085 ddp_list_entries_rec.col140 := p6_a197;
1086 ddp_list_entries_rec.col141 := p6_a198;
1087 ddp_list_entries_rec.col142 := p6_a199;
1088 ddp_list_entries_rec.col143 := p6_a200;
1089 ddp_list_entries_rec.col144 := p6_a201;
1090 ddp_list_entries_rec.col145 := p6_a202;
1091 ddp_list_entries_rec.col146 := p6_a203;
1092 ddp_list_entries_rec.col147 := p6_a204;
1093 ddp_list_entries_rec.col148 := p6_a205;
1094 ddp_list_entries_rec.col149 := p6_a206;
1095 ddp_list_entries_rec.col150 := p6_a207;
1096 ddp_list_entries_rec.col151 := p6_a208;
1097 ddp_list_entries_rec.col152 := p6_a209;
1098 ddp_list_entries_rec.col153 := p6_a210;
1099 ddp_list_entries_rec.col154 := p6_a211;
1100 ddp_list_entries_rec.col155 := p6_a212;
1101 ddp_list_entries_rec.col156 := p6_a213;
1102 ddp_list_entries_rec.col157 := p6_a214;
1103 ddp_list_entries_rec.col158 := p6_a215;
1104 ddp_list_entries_rec.col159 := p6_a216;
1105 ddp_list_entries_rec.col160 := p6_a217;
1106 ddp_list_entries_rec.col161 := p6_a218;
1107 ddp_list_entries_rec.col162 := p6_a219;
1108 ddp_list_entries_rec.col163 := p6_a220;
1109 ddp_list_entries_rec.col164 := p6_a221;
1110 ddp_list_entries_rec.col165 := p6_a222;
1111 ddp_list_entries_rec.col166 := p6_a223;
1112 ddp_list_entries_rec.col167 := p6_a224;
1113 ddp_list_entries_rec.col168 := p6_a225;
1114 ddp_list_entries_rec.col169 := p6_a226;
1115 ddp_list_entries_rec.col170 := p6_a227;
1116 ddp_list_entries_rec.col171 := p6_a228;
1117 ddp_list_entries_rec.col172 := p6_a229;
1118 ddp_list_entries_rec.col173 := p6_a230;
1119 ddp_list_entries_rec.col174 := p6_a231;
1120 ddp_list_entries_rec.col175 := p6_a232;
1121 ddp_list_entries_rec.col176 := p6_a233;
1122 ddp_list_entries_rec.col177 := p6_a234;
1123 ddp_list_entries_rec.col178 := p6_a235;
1124 ddp_list_entries_rec.col179 := p6_a236;
1125 ddp_list_entries_rec.col180 := p6_a237;
1126 ddp_list_entries_rec.col181 := p6_a238;
1127 ddp_list_entries_rec.col182 := p6_a239;
1128 ddp_list_entries_rec.col183 := p6_a240;
1129 ddp_list_entries_rec.col184 := p6_a241;
1130 ddp_list_entries_rec.col185 := p6_a242;
1131 ddp_list_entries_rec.col186 := p6_a243;
1132 ddp_list_entries_rec.col187 := p6_a244;
1133 ddp_list_entries_rec.col188 := p6_a245;
1134 ddp_list_entries_rec.col189 := p6_a246;
1135 ddp_list_entries_rec.col190 := p6_a247;
1136 ddp_list_entries_rec.col191 := p6_a248;
1137 ddp_list_entries_rec.col192 := p6_a249;
1138 ddp_list_entries_rec.col193 := p6_a250;
1139 ddp_list_entries_rec.col194 := p6_a251;
1140 ddp_list_entries_rec.col195 := p6_a252;
1141 ddp_list_entries_rec.col196 := p6_a253;
1142 ddp_list_entries_rec.col197 := p6_a254;
1143 ddp_list_entries_rec.col198 := p6_a255;
1144 ddp_list_entries_rec.col199 := p6_a256;
1145 ddp_list_entries_rec.col200 := p6_a257;
1146 ddp_list_entries_rec.party_id := rosetta_g_miss_num_map(p6_a258);
1147 ddp_list_entries_rec.parent_party_id := rosetta_g_miss_num_map(p6_a259);
1148 ddp_list_entries_rec.imp_source_line_id := rosetta_g_miss_num_map(p6_a260);
1149 ddp_list_entries_rec.usage_restriction := p6_a261;
1150 ddp_list_entries_rec.next_call_time := rosetta_g_miss_date_in_map(p6_a262);
1151 ddp_list_entries_rec.callback_flag := p6_a263;
1152 ddp_list_entries_rec.do_not_use_flag := p6_a264;
1153 ddp_list_entries_rec.do_not_use_reason := p6_a265;
1154 ddp_list_entries_rec.record_out_flag := p6_a266;
1155 ddp_list_entries_rec.record_release_time := rosetta_g_miss_date_in_map(p6_a267);
1156
1157
1158 -- here's the delegated call to the old PL/SQL routine
1159 ams_list_entries_pub.update_list_entries(p_api_version_number,
1160 p_init_msg_list,
1161 p_commit,
1162 x_return_status,
1163 x_msg_count,
1164 x_msg_data,
1165 ddp_list_entries_rec,
1166 x_object_version_number);
1167
1168 -- copy data back from the local OUT or IN-OUT args, if any
1169
1170
1171
1172
1173
1174
1175
1176 end;
1177
1178 end ams_list_entries_pub_w;