[Home] [Help]
PACKAGE BODY: APPS.PVX_LEAD_PSS_LINES_PVT_W
Source
1 package body pvx_lead_pss_lines_pvt_w as
2 /* $Header: pvxwpssb.pls 115.9 2002/11/20 02:05:23 pklin 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_lead_pss_line(p_api_version_number NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , x_return_status out nocopy VARCHAR2
27 , x_msg_count out nocopy NUMBER
28 , x_msg_data out nocopy VARCHAR2
29 , x_lead_pss_line_id out nocopy NUMBER
30 , p7_a0 NUMBER := 0-1962.0724
31 , p7_a1 DATE := fnd_api.g_miss_date
32 , p7_a2 NUMBER := 0-1962.0724
33 , p7_a3 DATE := fnd_api.g_miss_date
34 , p7_a4 NUMBER := 0-1962.0724
35 , p7_a5 NUMBER := 0-1962.0724
36 , p7_a6 NUMBER := 0-1962.0724
37 , p7_a7 NUMBER := 0-1962.0724
38 , p7_a8 NUMBER := 0-1962.0724
39 , p7_a9 NUMBER := 0-1962.0724
40 , p7_a10 DATE := fnd_api.g_miss_date
41 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42 , p7_a12 NUMBER := 0-1962.0724
43 , p7_a13 NUMBER := 0-1962.0724
44 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45 , p7_a15 NUMBER := 0-1962.0724
46 , p7_a16 NUMBER := 0-1962.0724
47 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
63 , p7_a33 NUMBER := 0-1962.0724
64 , p7_a34 NUMBER := 0-1962.0724
65 )
66 as
67 ddp_lead_pss_lines_rec pvx_lead_pss_lines_pvt.lead_pss_lines_rec_type;
68 ddindx binary_integer; indx binary_integer;
69 begin
70
71 -- copy data to the local IN or IN-OUT args, if any
72
73
74
75
76
77
78
79 ddp_lead_pss_lines_rec.lead_pss_line_id := rosetta_g_miss_num_map(p7_a0);
80 ddp_lead_pss_lines_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
81 ddp_lead_pss_lines_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
82 ddp_lead_pss_lines_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
83 ddp_lead_pss_lines_rec.created_by := rosetta_g_miss_num_map(p7_a4);
84 ddp_lead_pss_lines_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
85 ddp_lead_pss_lines_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
86 ddp_lead_pss_lines_rec.request_id := rosetta_g_miss_num_map(p7_a7);
87 ddp_lead_pss_lines_rec.program_application_id := rosetta_g_miss_num_map(p7_a8);
88 ddp_lead_pss_lines_rec.program_id := rosetta_g_miss_num_map(p7_a9);
89 ddp_lead_pss_lines_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a10);
90 ddp_lead_pss_lines_rec.object_name := p7_a11;
91 ddp_lead_pss_lines_rec.attr_code_id := rosetta_g_miss_num_map(p7_a12);
92 ddp_lead_pss_lines_rec.lead_id := rosetta_g_miss_num_map(p7_a13);
93 ddp_lead_pss_lines_rec.uom_code := p7_a14;
94 ddp_lead_pss_lines_rec.quantity := rosetta_g_miss_num_map(p7_a15);
95 ddp_lead_pss_lines_rec.amount := rosetta_g_miss_num_map(p7_a16);
96 ddp_lead_pss_lines_rec.attribute_category := p7_a17;
97 ddp_lead_pss_lines_rec.attribute1 := p7_a18;
98 ddp_lead_pss_lines_rec.attribute2 := p7_a19;
99 ddp_lead_pss_lines_rec.attribute3 := p7_a20;
100 ddp_lead_pss_lines_rec.attribute4 := p7_a21;
101 ddp_lead_pss_lines_rec.attribute5 := p7_a22;
102 ddp_lead_pss_lines_rec.attribute6 := p7_a23;
103 ddp_lead_pss_lines_rec.attribute7 := p7_a24;
104 ddp_lead_pss_lines_rec.attribute8 := p7_a25;
105 ddp_lead_pss_lines_rec.attribute9 := p7_a26;
106 ddp_lead_pss_lines_rec.attribute10 := p7_a27;
107 ddp_lead_pss_lines_rec.attribute11 := p7_a28;
108 ddp_lead_pss_lines_rec.attribute12 := p7_a29;
109 ddp_lead_pss_lines_rec.attribute13 := p7_a30;
110 ddp_lead_pss_lines_rec.attribute14 := p7_a31;
111 ddp_lead_pss_lines_rec.attribute15 := p7_a32;
112 ddp_lead_pss_lines_rec.object_id := rosetta_g_miss_num_map(p7_a33);
113 ddp_lead_pss_lines_rec.partner_id := rosetta_g_miss_num_map(p7_a34);
114
115
116 -- here's the delegated call to the old PL/SQL routine
117 pvx_lead_pss_lines_pvt.create_lead_pss_line(p_api_version_number,
118 p_init_msg_list,
119 p_commit,
120 p_validation_level,
121 x_return_status,
122 x_msg_count,
123 x_msg_data,
124 ddp_lead_pss_lines_rec,
125 x_lead_pss_line_id);
126
127 -- copy data back from the local OUT or IN-OUT args, if any
128
129
130
131
132
133
134
135
136 end;
137
138 procedure update_lead_pss_line(p_api_version_number NUMBER
139 , p_init_msg_list VARCHAR2
140 , p_commit VARCHAR2
141 , p_validation_level NUMBER
142 , x_return_status out nocopy VARCHAR2
143 , x_msg_count out nocopy NUMBER
144 , x_msg_data out nocopy VARCHAR2
145 , p7_a0 NUMBER := 0-1962.0724
146 , p7_a1 DATE := fnd_api.g_miss_date
147 , p7_a2 NUMBER := 0-1962.0724
148 , p7_a3 DATE := fnd_api.g_miss_date
149 , p7_a4 NUMBER := 0-1962.0724
150 , p7_a5 NUMBER := 0-1962.0724
151 , p7_a6 NUMBER := 0-1962.0724
152 , p7_a7 NUMBER := 0-1962.0724
153 , p7_a8 NUMBER := 0-1962.0724
154 , p7_a9 NUMBER := 0-1962.0724
155 , p7_a10 DATE := fnd_api.g_miss_date
156 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
157 , p7_a12 NUMBER := 0-1962.0724
158 , p7_a13 NUMBER := 0-1962.0724
159 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
160 , p7_a15 NUMBER := 0-1962.0724
161 , p7_a16 NUMBER := 0-1962.0724
162 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
163 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
164 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
165 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
166 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
167 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
168 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
169 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
170 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
171 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
172 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
173 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
174 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
175 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
176 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
177 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
178 , p7_a33 NUMBER := 0-1962.0724
179 , p7_a34 NUMBER := 0-1962.0724
180 )
181 as
182 ddp_lead_pss_lines_rec pvx_lead_pss_lines_pvt.lead_pss_lines_rec_type;
183 ddindx binary_integer; indx binary_integer;
184 begin
185
186 -- copy data to the local IN or IN-OUT args, if any
187
188
189
190
191
192
193
194 ddp_lead_pss_lines_rec.lead_pss_line_id := rosetta_g_miss_num_map(p7_a0);
195 ddp_lead_pss_lines_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
196 ddp_lead_pss_lines_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
197 ddp_lead_pss_lines_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
198 ddp_lead_pss_lines_rec.created_by := rosetta_g_miss_num_map(p7_a4);
199 ddp_lead_pss_lines_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
200 ddp_lead_pss_lines_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
201 ddp_lead_pss_lines_rec.request_id := rosetta_g_miss_num_map(p7_a7);
202 ddp_lead_pss_lines_rec.program_application_id := rosetta_g_miss_num_map(p7_a8);
203 ddp_lead_pss_lines_rec.program_id := rosetta_g_miss_num_map(p7_a9);
204 ddp_lead_pss_lines_rec.program_update_date := rosetta_g_miss_date_in_map(p7_a10);
205 ddp_lead_pss_lines_rec.object_name := p7_a11;
206 ddp_lead_pss_lines_rec.attr_code_id := rosetta_g_miss_num_map(p7_a12);
207 ddp_lead_pss_lines_rec.lead_id := rosetta_g_miss_num_map(p7_a13);
208 ddp_lead_pss_lines_rec.uom_code := p7_a14;
209 ddp_lead_pss_lines_rec.quantity := rosetta_g_miss_num_map(p7_a15);
210 ddp_lead_pss_lines_rec.amount := rosetta_g_miss_num_map(p7_a16);
211 ddp_lead_pss_lines_rec.attribute_category := p7_a17;
212 ddp_lead_pss_lines_rec.attribute1 := p7_a18;
213 ddp_lead_pss_lines_rec.attribute2 := p7_a19;
214 ddp_lead_pss_lines_rec.attribute3 := p7_a20;
215 ddp_lead_pss_lines_rec.attribute4 := p7_a21;
216 ddp_lead_pss_lines_rec.attribute5 := p7_a22;
217 ddp_lead_pss_lines_rec.attribute6 := p7_a23;
218 ddp_lead_pss_lines_rec.attribute7 := p7_a24;
219 ddp_lead_pss_lines_rec.attribute8 := p7_a25;
220 ddp_lead_pss_lines_rec.attribute9 := p7_a26;
221 ddp_lead_pss_lines_rec.attribute10 := p7_a27;
222 ddp_lead_pss_lines_rec.attribute11 := p7_a28;
223 ddp_lead_pss_lines_rec.attribute12 := p7_a29;
224 ddp_lead_pss_lines_rec.attribute13 := p7_a30;
225 ddp_lead_pss_lines_rec.attribute14 := p7_a31;
226 ddp_lead_pss_lines_rec.attribute15 := p7_a32;
227 ddp_lead_pss_lines_rec.object_id := rosetta_g_miss_num_map(p7_a33);
228 ddp_lead_pss_lines_rec.partner_id := rosetta_g_miss_num_map(p7_a34);
229
230 -- here's the delegated call to the old PL/SQL routine
231 pvx_lead_pss_lines_pvt.update_lead_pss_line(p_api_version_number,
232 p_init_msg_list,
233 p_commit,
234 p_validation_level,
235 x_return_status,
236 x_msg_count,
237 x_msg_data,
238 ddp_lead_pss_lines_rec);
239
240 -- copy data back from the local OUT or IN-OUT args, if any
241
242
243
244
245
246
247
248 end;
249
250 procedure validate_lead_pss_line(p_api_version_number NUMBER
251 , p_init_msg_list VARCHAR2
252 , p_validation_level NUMBER
253 , x_return_status out nocopy VARCHAR2
254 , x_msg_count out nocopy NUMBER
255 , x_msg_data out nocopy VARCHAR2
256 , p6_a0 NUMBER := 0-1962.0724
257 , p6_a1 DATE := fnd_api.g_miss_date
258 , p6_a2 NUMBER := 0-1962.0724
259 , p6_a3 DATE := fnd_api.g_miss_date
260 , p6_a4 NUMBER := 0-1962.0724
261 , p6_a5 NUMBER := 0-1962.0724
262 , p6_a6 NUMBER := 0-1962.0724
263 , p6_a7 NUMBER := 0-1962.0724
264 , p6_a8 NUMBER := 0-1962.0724
265 , p6_a9 NUMBER := 0-1962.0724
266 , p6_a10 DATE := fnd_api.g_miss_date
267 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
268 , p6_a12 NUMBER := 0-1962.0724
269 , p6_a13 NUMBER := 0-1962.0724
270 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
271 , p6_a15 NUMBER := 0-1962.0724
272 , p6_a16 NUMBER := 0-1962.0724
273 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
274 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
275 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
276 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
277 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
278 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
279 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
280 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
281 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
282 , p6_a26 VARCHAR2 := fnd_api.g_miss_char
283 , p6_a27 VARCHAR2 := fnd_api.g_miss_char
284 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
285 , p6_a29 VARCHAR2 := fnd_api.g_miss_char
286 , p6_a30 VARCHAR2 := fnd_api.g_miss_char
287 , p6_a31 VARCHAR2 := fnd_api.g_miss_char
288 , p6_a32 VARCHAR2 := fnd_api.g_miss_char
289 , p6_a33 NUMBER := 0-1962.0724
290 , p6_a34 NUMBER := 0-1962.0724
291 )
292 as
293 ddp_lead_pss_lines_rec pvx_lead_pss_lines_pvt.lead_pss_lines_rec_type;
294 ddindx binary_integer; indx binary_integer;
295 begin
296
297 -- copy data to the local IN or IN-OUT args, if any
298
299
300
301
302
303
304 ddp_lead_pss_lines_rec.lead_pss_line_id := rosetta_g_miss_num_map(p6_a0);
305 ddp_lead_pss_lines_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
306 ddp_lead_pss_lines_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
307 ddp_lead_pss_lines_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
308 ddp_lead_pss_lines_rec.created_by := rosetta_g_miss_num_map(p6_a4);
309 ddp_lead_pss_lines_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
310 ddp_lead_pss_lines_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
311 ddp_lead_pss_lines_rec.request_id := rosetta_g_miss_num_map(p6_a7);
312 ddp_lead_pss_lines_rec.program_application_id := rosetta_g_miss_num_map(p6_a8);
313 ddp_lead_pss_lines_rec.program_id := rosetta_g_miss_num_map(p6_a9);
314 ddp_lead_pss_lines_rec.program_update_date := rosetta_g_miss_date_in_map(p6_a10);
315 ddp_lead_pss_lines_rec.object_name := p6_a11;
316 ddp_lead_pss_lines_rec.attr_code_id := rosetta_g_miss_num_map(p6_a12);
317 ddp_lead_pss_lines_rec.lead_id := rosetta_g_miss_num_map(p6_a13);
318 ddp_lead_pss_lines_rec.uom_code := p6_a14;
319 ddp_lead_pss_lines_rec.quantity := rosetta_g_miss_num_map(p6_a15);
320 ddp_lead_pss_lines_rec.amount := rosetta_g_miss_num_map(p6_a16);
321 ddp_lead_pss_lines_rec.attribute_category := p6_a17;
322 ddp_lead_pss_lines_rec.attribute1 := p6_a18;
323 ddp_lead_pss_lines_rec.attribute2 := p6_a19;
324 ddp_lead_pss_lines_rec.attribute3 := p6_a20;
325 ddp_lead_pss_lines_rec.attribute4 := p6_a21;
326 ddp_lead_pss_lines_rec.attribute5 := p6_a22;
327 ddp_lead_pss_lines_rec.attribute6 := p6_a23;
328 ddp_lead_pss_lines_rec.attribute7 := p6_a24;
329 ddp_lead_pss_lines_rec.attribute8 := p6_a25;
330 ddp_lead_pss_lines_rec.attribute9 := p6_a26;
331 ddp_lead_pss_lines_rec.attribute10 := p6_a27;
332 ddp_lead_pss_lines_rec.attribute11 := p6_a28;
333 ddp_lead_pss_lines_rec.attribute12 := p6_a29;
334 ddp_lead_pss_lines_rec.attribute13 := p6_a30;
335 ddp_lead_pss_lines_rec.attribute14 := p6_a31;
336 ddp_lead_pss_lines_rec.attribute15 := p6_a32;
337 ddp_lead_pss_lines_rec.object_id := rosetta_g_miss_num_map(p6_a33);
338 ddp_lead_pss_lines_rec.partner_id := rosetta_g_miss_num_map(p6_a34);
339
340 -- here's the delegated call to the old PL/SQL routine
341 pvx_lead_pss_lines_pvt.validate_lead_pss_line(p_api_version_number,
342 p_init_msg_list,
343 p_validation_level,
344 x_return_status,
345 x_msg_count,
346 x_msg_data,
347 ddp_lead_pss_lines_rec);
348
349 -- copy data back from the local OUT or IN-OUT args, if any
350
351
352
353
354
355
356 end;
357
358 procedure check_lead_pss_line_items(p_validation_mode VARCHAR2
359 , x_return_status out nocopy VARCHAR2
360 , p2_a0 NUMBER := 0-1962.0724
361 , p2_a1 DATE := fnd_api.g_miss_date
362 , p2_a2 NUMBER := 0-1962.0724
363 , p2_a3 DATE := fnd_api.g_miss_date
364 , p2_a4 NUMBER := 0-1962.0724
365 , p2_a5 NUMBER := 0-1962.0724
366 , p2_a6 NUMBER := 0-1962.0724
367 , p2_a7 NUMBER := 0-1962.0724
368 , p2_a8 NUMBER := 0-1962.0724
369 , p2_a9 NUMBER := 0-1962.0724
370 , p2_a10 DATE := fnd_api.g_miss_date
371 , p2_a11 VARCHAR2 := fnd_api.g_miss_char
372 , p2_a12 NUMBER := 0-1962.0724
373 , p2_a13 NUMBER := 0-1962.0724
374 , p2_a14 VARCHAR2 := fnd_api.g_miss_char
375 , p2_a15 NUMBER := 0-1962.0724
376 , p2_a16 NUMBER := 0-1962.0724
377 , p2_a17 VARCHAR2 := fnd_api.g_miss_char
378 , p2_a18 VARCHAR2 := fnd_api.g_miss_char
379 , p2_a19 VARCHAR2 := fnd_api.g_miss_char
383 , p2_a23 VARCHAR2 := fnd_api.g_miss_char
380 , p2_a20 VARCHAR2 := fnd_api.g_miss_char
381 , p2_a21 VARCHAR2 := fnd_api.g_miss_char
382 , p2_a22 VARCHAR2 := fnd_api.g_miss_char
384 , p2_a24 VARCHAR2 := fnd_api.g_miss_char
385 , p2_a25 VARCHAR2 := fnd_api.g_miss_char
386 , p2_a26 VARCHAR2 := fnd_api.g_miss_char
387 , p2_a27 VARCHAR2 := fnd_api.g_miss_char
388 , p2_a28 VARCHAR2 := fnd_api.g_miss_char
389 , p2_a29 VARCHAR2 := fnd_api.g_miss_char
390 , p2_a30 VARCHAR2 := fnd_api.g_miss_char
391 , p2_a31 VARCHAR2 := fnd_api.g_miss_char
392 , p2_a32 VARCHAR2 := fnd_api.g_miss_char
393 , p2_a33 NUMBER := 0-1962.0724
394 , p2_a34 NUMBER := 0-1962.0724
395 )
396 as
397 ddp_lead_pss_lines_rec pvx_lead_pss_lines_pvt.lead_pss_lines_rec_type;
398 ddindx binary_integer; indx binary_integer;
399 begin
400
401 -- copy data to the local IN or IN-OUT args, if any
402
403
404 ddp_lead_pss_lines_rec.lead_pss_line_id := rosetta_g_miss_num_map(p2_a0);
405 ddp_lead_pss_lines_rec.last_update_date := rosetta_g_miss_date_in_map(p2_a1);
406 ddp_lead_pss_lines_rec.last_updated_by := rosetta_g_miss_num_map(p2_a2);
407 ddp_lead_pss_lines_rec.creation_date := rosetta_g_miss_date_in_map(p2_a3);
408 ddp_lead_pss_lines_rec.created_by := rosetta_g_miss_num_map(p2_a4);
409 ddp_lead_pss_lines_rec.last_update_login := rosetta_g_miss_num_map(p2_a5);
410 ddp_lead_pss_lines_rec.object_version_number := rosetta_g_miss_num_map(p2_a6);
411 ddp_lead_pss_lines_rec.request_id := rosetta_g_miss_num_map(p2_a7);
412 ddp_lead_pss_lines_rec.program_application_id := rosetta_g_miss_num_map(p2_a8);
413 ddp_lead_pss_lines_rec.program_id := rosetta_g_miss_num_map(p2_a9);
414 ddp_lead_pss_lines_rec.program_update_date := rosetta_g_miss_date_in_map(p2_a10);
415 ddp_lead_pss_lines_rec.object_name := p2_a11;
416 ddp_lead_pss_lines_rec.attr_code_id := rosetta_g_miss_num_map(p2_a12);
417 ddp_lead_pss_lines_rec.lead_id := rosetta_g_miss_num_map(p2_a13);
418 ddp_lead_pss_lines_rec.uom_code := p2_a14;
419 ddp_lead_pss_lines_rec.quantity := rosetta_g_miss_num_map(p2_a15);
420 ddp_lead_pss_lines_rec.amount := rosetta_g_miss_num_map(p2_a16);
421 ddp_lead_pss_lines_rec.attribute_category := p2_a17;
422 ddp_lead_pss_lines_rec.attribute1 := p2_a18;
423 ddp_lead_pss_lines_rec.attribute2 := p2_a19;
424 ddp_lead_pss_lines_rec.attribute3 := p2_a20;
425 ddp_lead_pss_lines_rec.attribute4 := p2_a21;
426 ddp_lead_pss_lines_rec.attribute5 := p2_a22;
427 ddp_lead_pss_lines_rec.attribute6 := p2_a23;
428 ddp_lead_pss_lines_rec.attribute7 := p2_a24;
429 ddp_lead_pss_lines_rec.attribute8 := p2_a25;
430 ddp_lead_pss_lines_rec.attribute9 := p2_a26;
431 ddp_lead_pss_lines_rec.attribute10 := p2_a27;
432 ddp_lead_pss_lines_rec.attribute11 := p2_a28;
433 ddp_lead_pss_lines_rec.attribute12 := p2_a29;
434 ddp_lead_pss_lines_rec.attribute13 := p2_a30;
435 ddp_lead_pss_lines_rec.attribute14 := p2_a31;
436 ddp_lead_pss_lines_rec.attribute15 := p2_a32;
437 ddp_lead_pss_lines_rec.object_id := rosetta_g_miss_num_map(p2_a33);
438 ddp_lead_pss_lines_rec.partner_id := rosetta_g_miss_num_map(p2_a34);
439
440 -- here's the delegated call to the old PL/SQL routine
441 pvx_lead_pss_lines_pvt.check_lead_pss_line_items(p_validation_mode,
442 x_return_status,
443 ddp_lead_pss_lines_rec);
444
445 -- copy data back from the local OUT or IN-OUT args, if any
446
447
448 end;
449
450 procedure check_lead_pss_line_record(p_mode VARCHAR2
451 , x_return_status out nocopy VARCHAR2
452 , p0_a0 NUMBER := 0-1962.0724
453 , p0_a1 DATE := fnd_api.g_miss_date
454 , p0_a2 NUMBER := 0-1962.0724
455 , p0_a3 DATE := fnd_api.g_miss_date
456 , p0_a4 NUMBER := 0-1962.0724
457 , p0_a5 NUMBER := 0-1962.0724
458 , p0_a6 NUMBER := 0-1962.0724
459 , p0_a7 NUMBER := 0-1962.0724
460 , p0_a8 NUMBER := 0-1962.0724
461 , p0_a9 NUMBER := 0-1962.0724
462 , p0_a10 DATE := fnd_api.g_miss_date
463 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
464 , p0_a12 NUMBER := 0-1962.0724
465 , p0_a13 NUMBER := 0-1962.0724
466 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
467 , p0_a15 NUMBER := 0-1962.0724
468 , p0_a16 NUMBER := 0-1962.0724
469 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
470 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
471 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
472 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
473 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
474 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
475 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
476 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
477 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
478 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
479 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
480 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
481 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
482 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
483 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
484 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
485 , p0_a33 NUMBER := 0-1962.0724
486 , p0_a34 NUMBER := 0-1962.0724
487 , p1_a0 NUMBER := 0-1962.0724
488 , p1_a1 DATE := fnd_api.g_miss_date
489 , p1_a2 NUMBER := 0-1962.0724
490 , p1_a3 DATE := fnd_api.g_miss_date
491 , p1_a4 NUMBER := 0-1962.0724
492 , p1_a5 NUMBER := 0-1962.0724
493 , p1_a6 NUMBER := 0-1962.0724
497 , p1_a10 DATE := fnd_api.g_miss_date
494 , p1_a7 NUMBER := 0-1962.0724
495 , p1_a8 NUMBER := 0-1962.0724
496 , p1_a9 NUMBER := 0-1962.0724
498 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
499 , p1_a12 NUMBER := 0-1962.0724
500 , p1_a13 NUMBER := 0-1962.0724
501 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
502 , p1_a15 NUMBER := 0-1962.0724
503 , p1_a16 NUMBER := 0-1962.0724
504 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
505 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
506 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
507 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
508 , p1_a21 VARCHAR2 := fnd_api.g_miss_char
509 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
510 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
511 , p1_a24 VARCHAR2 := fnd_api.g_miss_char
512 , p1_a25 VARCHAR2 := fnd_api.g_miss_char
513 , p1_a26 VARCHAR2 := fnd_api.g_miss_char
514 , p1_a27 VARCHAR2 := fnd_api.g_miss_char
515 , p1_a28 VARCHAR2 := fnd_api.g_miss_char
516 , p1_a29 VARCHAR2 := fnd_api.g_miss_char
517 , p1_a30 VARCHAR2 := fnd_api.g_miss_char
518 , p1_a31 VARCHAR2 := fnd_api.g_miss_char
519 , p1_a32 VARCHAR2 := fnd_api.g_miss_char
520 , p1_a33 NUMBER := 0-1962.0724
521 , p1_a34 NUMBER := 0-1962.0724
522 )
523 as
524 ddp_lead_pss_lines_rec pvx_lead_pss_lines_pvt.lead_pss_lines_rec_type;
525 ddp_complete_rec pvx_lead_pss_lines_pvt.lead_pss_lines_rec_type;
526 ddindx binary_integer; indx binary_integer;
527 begin
528
529 -- copy data to the local IN or IN-OUT args, if any
530 ddp_lead_pss_lines_rec.lead_pss_line_id := rosetta_g_miss_num_map(p0_a0);
531 ddp_lead_pss_lines_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
532 ddp_lead_pss_lines_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
533 ddp_lead_pss_lines_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
534 ddp_lead_pss_lines_rec.created_by := rosetta_g_miss_num_map(p0_a4);
535 ddp_lead_pss_lines_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
536 ddp_lead_pss_lines_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
537 ddp_lead_pss_lines_rec.request_id := rosetta_g_miss_num_map(p0_a7);
538 ddp_lead_pss_lines_rec.program_application_id := rosetta_g_miss_num_map(p0_a8);
539 ddp_lead_pss_lines_rec.program_id := rosetta_g_miss_num_map(p0_a9);
540 ddp_lead_pss_lines_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a10);
541 ddp_lead_pss_lines_rec.object_name := p0_a11;
542 ddp_lead_pss_lines_rec.attr_code_id := rosetta_g_miss_num_map(p0_a12);
543 ddp_lead_pss_lines_rec.lead_id := rosetta_g_miss_num_map(p0_a13);
544 ddp_lead_pss_lines_rec.uom_code := p0_a14;
545 ddp_lead_pss_lines_rec.quantity := rosetta_g_miss_num_map(p0_a15);
546 ddp_lead_pss_lines_rec.amount := rosetta_g_miss_num_map(p0_a16);
547 ddp_lead_pss_lines_rec.attribute_category := p0_a17;
548 ddp_lead_pss_lines_rec.attribute1 := p0_a18;
549 ddp_lead_pss_lines_rec.attribute2 := p0_a19;
550 ddp_lead_pss_lines_rec.attribute3 := p0_a20;
551 ddp_lead_pss_lines_rec.attribute4 := p0_a21;
552 ddp_lead_pss_lines_rec.attribute5 := p0_a22;
553 ddp_lead_pss_lines_rec.attribute6 := p0_a23;
554 ddp_lead_pss_lines_rec.attribute7 := p0_a24;
555 ddp_lead_pss_lines_rec.attribute8 := p0_a25;
556 ddp_lead_pss_lines_rec.attribute9 := p0_a26;
557 ddp_lead_pss_lines_rec.attribute10 := p0_a27;
558 ddp_lead_pss_lines_rec.attribute11 := p0_a28;
559 ddp_lead_pss_lines_rec.attribute12 := p0_a29;
560 ddp_lead_pss_lines_rec.attribute13 := p0_a30;
561 ddp_lead_pss_lines_rec.attribute14 := p0_a31;
562 ddp_lead_pss_lines_rec.attribute15 := p0_a32;
563 ddp_lead_pss_lines_rec.object_id := rosetta_g_miss_num_map(p0_a33);
564 ddp_lead_pss_lines_rec.partner_id := rosetta_g_miss_num_map(p0_a34);
565
566 ddp_complete_rec.lead_pss_line_id := rosetta_g_miss_num_map(p1_a0);
567 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
568 ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
569 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
570 ddp_complete_rec.created_by := rosetta_g_miss_num_map(p1_a4);
571 ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
572 ddp_complete_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
573 ddp_complete_rec.request_id := rosetta_g_miss_num_map(p1_a7);
574 ddp_complete_rec.program_application_id := rosetta_g_miss_num_map(p1_a8);
575 ddp_complete_rec.program_id := rosetta_g_miss_num_map(p1_a9);
576 ddp_complete_rec.program_update_date := rosetta_g_miss_date_in_map(p1_a10);
577 ddp_complete_rec.object_name := p1_a11;
578 ddp_complete_rec.attr_code_id := rosetta_g_miss_num_map(p1_a12);
579 ddp_complete_rec.lead_id := rosetta_g_miss_num_map(p1_a13);
580 ddp_complete_rec.uom_code := p1_a14;
581 ddp_complete_rec.quantity := rosetta_g_miss_num_map(p1_a15);
582 ddp_complete_rec.amount := rosetta_g_miss_num_map(p1_a16);
583 ddp_complete_rec.attribute_category := p1_a17;
584 ddp_complete_rec.attribute1 := p1_a18;
585 ddp_complete_rec.attribute2 := p1_a19;
586 ddp_complete_rec.attribute3 := p1_a20;
587 ddp_complete_rec.attribute4 := p1_a21;
588 ddp_complete_rec.attribute5 := p1_a22;
589 ddp_complete_rec.attribute6 := p1_a23;
590 ddp_complete_rec.attribute7 := p1_a24;
591 ddp_complete_rec.attribute8 := p1_a25;
592 ddp_complete_rec.attribute9 := p1_a26;
593 ddp_complete_rec.attribute10 := p1_a27;
597 ddp_complete_rec.attribute14 := p1_a31;
594 ddp_complete_rec.attribute11 := p1_a28;
595 ddp_complete_rec.attribute12 := p1_a29;
596 ddp_complete_rec.attribute13 := p1_a30;
598 ddp_complete_rec.attribute15 := p1_a32;
599 ddp_complete_rec.object_id := rosetta_g_miss_num_map(p1_a33);
600 ddp_complete_rec.partner_id := rosetta_g_miss_num_map(p1_a34);
601
602
603
604 -- here's the delegated call to the old PL/SQL routine
605 pvx_lead_pss_lines_pvt.check_lead_pss_line_record(ddp_lead_pss_lines_rec,
606 ddp_complete_rec,
607 p_mode,
608 x_return_status);
609
610 -- copy data back from the local OUT or IN-OUT args, if any
611
612
613
614 end;
615
616 procedure init_lead_pss_line_rec(p0_a0 out nocopy NUMBER
617 , p0_a1 out nocopy DATE
618 , p0_a2 out nocopy NUMBER
619 , p0_a3 out nocopy DATE
620 , p0_a4 out nocopy NUMBER
621 , p0_a5 out nocopy NUMBER
622 , p0_a6 out nocopy NUMBER
623 , p0_a7 out nocopy NUMBER
624 , p0_a8 out nocopy NUMBER
625 , p0_a9 out nocopy NUMBER
626 , p0_a10 out nocopy DATE
627 , p0_a11 out nocopy VARCHAR2
628 , p0_a12 out nocopy NUMBER
629 , p0_a13 out nocopy NUMBER
630 , p0_a14 out nocopy VARCHAR2
631 , p0_a15 out nocopy NUMBER
632 , p0_a16 out nocopy NUMBER
633 , p0_a17 out nocopy VARCHAR2
634 , p0_a18 out nocopy VARCHAR2
635 , p0_a19 out nocopy VARCHAR2
636 , p0_a20 out nocopy VARCHAR2
637 , p0_a21 out nocopy VARCHAR2
638 , p0_a22 out nocopy VARCHAR2
639 , p0_a23 out nocopy VARCHAR2
640 , p0_a24 out nocopy VARCHAR2
641 , p0_a25 out nocopy VARCHAR2
642 , p0_a26 out nocopy VARCHAR2
643 , p0_a27 out nocopy VARCHAR2
644 , p0_a28 out nocopy VARCHAR2
645 , p0_a29 out nocopy VARCHAR2
646 , p0_a30 out nocopy VARCHAR2
647 , p0_a31 out nocopy VARCHAR2
648 , p0_a32 out nocopy VARCHAR2
649 , p0_a33 out nocopy NUMBER
650 , p0_a34 out nocopy NUMBER
651 )
652 as
653 ddx_lead_pss_lines_rec pvx_lead_pss_lines_pvt.lead_pss_lines_rec_type;
654 ddindx binary_integer; indx binary_integer;
655 begin
656
657 -- copy data to the local IN or IN-OUT args, if any
658
659 -- here's the delegated call to the old PL/SQL routine
660 pvx_lead_pss_lines_pvt.init_lead_pss_line_rec(ddx_lead_pss_lines_rec);
661
662 -- copy data back from the local OUT or IN-OUT args, if any
663 p0_a0 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.lead_pss_line_id);
664 p0_a1 := ddx_lead_pss_lines_rec.last_update_date;
665 p0_a2 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.last_updated_by);
666 p0_a3 := ddx_lead_pss_lines_rec.creation_date;
667 p0_a4 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.created_by);
668 p0_a5 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.last_update_login);
669 p0_a6 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.object_version_number);
670 p0_a7 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.request_id);
671 p0_a8 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.program_application_id);
672 p0_a9 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.program_id);
673 p0_a10 := ddx_lead_pss_lines_rec.program_update_date;
674 p0_a11 := ddx_lead_pss_lines_rec.object_name;
675 p0_a12 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.attr_code_id);
676 p0_a13 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.lead_id);
677 p0_a14 := ddx_lead_pss_lines_rec.uom_code;
678 p0_a15 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.quantity);
679 p0_a16 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.amount);
680 p0_a17 := ddx_lead_pss_lines_rec.attribute_category;
681 p0_a18 := ddx_lead_pss_lines_rec.attribute1;
682 p0_a19 := ddx_lead_pss_lines_rec.attribute2;
683 p0_a20 := ddx_lead_pss_lines_rec.attribute3;
684 p0_a21 := ddx_lead_pss_lines_rec.attribute4;
685 p0_a22 := ddx_lead_pss_lines_rec.attribute5;
686 p0_a23 := ddx_lead_pss_lines_rec.attribute6;
687 p0_a24 := ddx_lead_pss_lines_rec.attribute7;
688 p0_a25 := ddx_lead_pss_lines_rec.attribute8;
689 p0_a26 := ddx_lead_pss_lines_rec.attribute9;
690 p0_a27 := ddx_lead_pss_lines_rec.attribute10;
691 p0_a28 := ddx_lead_pss_lines_rec.attribute11;
692 p0_a29 := ddx_lead_pss_lines_rec.attribute12;
693 p0_a30 := ddx_lead_pss_lines_rec.attribute13;
694 p0_a31 := ddx_lead_pss_lines_rec.attribute14;
695 p0_a32 := ddx_lead_pss_lines_rec.attribute15;
696 p0_a33 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.object_id);
697 p0_a34 := rosetta_g_miss_num_map(ddx_lead_pss_lines_rec.partner_id);
698 end;
699
700 procedure complete_lead_pss_line_rec(p1_a0 out nocopy NUMBER
701 , p1_a1 out nocopy DATE
702 , p1_a2 out nocopy NUMBER
703 , p1_a3 out nocopy DATE
704 , p1_a4 out nocopy NUMBER
705 , p1_a5 out nocopy NUMBER
706 , p1_a6 out nocopy NUMBER
707 , p1_a7 out nocopy NUMBER
708 , p1_a8 out nocopy NUMBER
709 , p1_a9 out nocopy NUMBER
710 , p1_a10 out nocopy DATE
711 , p1_a11 out nocopy VARCHAR2
712 , p1_a12 out nocopy NUMBER
713 , p1_a13 out nocopy NUMBER
714 , p1_a14 out nocopy VARCHAR2
715 , p1_a15 out nocopy NUMBER
716 , p1_a16 out nocopy NUMBER
717 , p1_a17 out nocopy VARCHAR2
721 , p1_a21 out nocopy VARCHAR2
718 , p1_a18 out nocopy VARCHAR2
719 , p1_a19 out nocopy VARCHAR2
720 , p1_a20 out nocopy VARCHAR2
722 , p1_a22 out nocopy VARCHAR2
723 , p1_a23 out nocopy VARCHAR2
724 , p1_a24 out nocopy VARCHAR2
725 , p1_a25 out nocopy VARCHAR2
726 , p1_a26 out nocopy VARCHAR2
727 , p1_a27 out nocopy VARCHAR2
728 , p1_a28 out nocopy VARCHAR2
729 , p1_a29 out nocopy VARCHAR2
730 , p1_a30 out nocopy VARCHAR2
731 , p1_a31 out nocopy VARCHAR2
732 , p1_a32 out nocopy VARCHAR2
733 , p1_a33 out nocopy NUMBER
734 , p1_a34 out nocopy NUMBER
735 , p0_a0 NUMBER := 0-1962.0724
736 , p0_a1 DATE := fnd_api.g_miss_date
737 , p0_a2 NUMBER := 0-1962.0724
738 , p0_a3 DATE := fnd_api.g_miss_date
739 , p0_a4 NUMBER := 0-1962.0724
740 , p0_a5 NUMBER := 0-1962.0724
741 , p0_a6 NUMBER := 0-1962.0724
742 , p0_a7 NUMBER := 0-1962.0724
743 , p0_a8 NUMBER := 0-1962.0724
744 , p0_a9 NUMBER := 0-1962.0724
745 , p0_a10 DATE := fnd_api.g_miss_date
746 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
747 , p0_a12 NUMBER := 0-1962.0724
748 , p0_a13 NUMBER := 0-1962.0724
749 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
750 , p0_a15 NUMBER := 0-1962.0724
751 , p0_a16 NUMBER := 0-1962.0724
752 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
753 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
754 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
755 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
756 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
757 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
758 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
759 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
760 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
761 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
762 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
763 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
764 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
765 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
766 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
767 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
768 , p0_a33 NUMBER := 0-1962.0724
769 , p0_a34 NUMBER := 0-1962.0724
770 )
771 as
772 ddp_lead_pss_lines_rec pvx_lead_pss_lines_pvt.lead_pss_lines_rec_type;
773 ddx_complete_rec pvx_lead_pss_lines_pvt.lead_pss_lines_rec_type;
774 ddindx binary_integer; indx binary_integer;
775 begin
776
777 -- copy data to the local IN or IN-OUT args, if any
778 ddp_lead_pss_lines_rec.lead_pss_line_id := rosetta_g_miss_num_map(p0_a0);
779 ddp_lead_pss_lines_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
780 ddp_lead_pss_lines_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
781 ddp_lead_pss_lines_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
782 ddp_lead_pss_lines_rec.created_by := rosetta_g_miss_num_map(p0_a4);
783 ddp_lead_pss_lines_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
784 ddp_lead_pss_lines_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
785 ddp_lead_pss_lines_rec.request_id := rosetta_g_miss_num_map(p0_a7);
786 ddp_lead_pss_lines_rec.program_application_id := rosetta_g_miss_num_map(p0_a8);
787 ddp_lead_pss_lines_rec.program_id := rosetta_g_miss_num_map(p0_a9);
788 ddp_lead_pss_lines_rec.program_update_date := rosetta_g_miss_date_in_map(p0_a10);
789 ddp_lead_pss_lines_rec.object_name := p0_a11;
790 ddp_lead_pss_lines_rec.attr_code_id := rosetta_g_miss_num_map(p0_a12);
791 ddp_lead_pss_lines_rec.lead_id := rosetta_g_miss_num_map(p0_a13);
792 ddp_lead_pss_lines_rec.uom_code := p0_a14;
793 ddp_lead_pss_lines_rec.quantity := rosetta_g_miss_num_map(p0_a15);
794 ddp_lead_pss_lines_rec.amount := rosetta_g_miss_num_map(p0_a16);
795 ddp_lead_pss_lines_rec.attribute_category := p0_a17;
796 ddp_lead_pss_lines_rec.attribute1 := p0_a18;
797 ddp_lead_pss_lines_rec.attribute2 := p0_a19;
798 ddp_lead_pss_lines_rec.attribute3 := p0_a20;
799 ddp_lead_pss_lines_rec.attribute4 := p0_a21;
800 ddp_lead_pss_lines_rec.attribute5 := p0_a22;
801 ddp_lead_pss_lines_rec.attribute6 := p0_a23;
802 ddp_lead_pss_lines_rec.attribute7 := p0_a24;
803 ddp_lead_pss_lines_rec.attribute8 := p0_a25;
804 ddp_lead_pss_lines_rec.attribute9 := p0_a26;
805 ddp_lead_pss_lines_rec.attribute10 := p0_a27;
806 ddp_lead_pss_lines_rec.attribute11 := p0_a28;
807 ddp_lead_pss_lines_rec.attribute12 := p0_a29;
808 ddp_lead_pss_lines_rec.attribute13 := p0_a30;
809 ddp_lead_pss_lines_rec.attribute14 := p0_a31;
810 ddp_lead_pss_lines_rec.attribute15 := p0_a32;
811 ddp_lead_pss_lines_rec.object_id := rosetta_g_miss_num_map(p0_a33);
812 ddp_lead_pss_lines_rec.partner_id := rosetta_g_miss_num_map(p0_a34);
813
814
815 -- here's the delegated call to the old PL/SQL routine
816 pvx_lead_pss_lines_pvt.complete_lead_pss_line_rec(ddp_lead_pss_lines_rec,
817 ddx_complete_rec);
818
819 -- copy data back from the local OUT or IN-OUT args, if any
820
821 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.lead_pss_line_id);
822 p1_a1 := ddx_complete_rec.last_update_date;
823 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
824 p1_a3 := ddx_complete_rec.creation_date;
825 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
826 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
830 p1_a9 := rosetta_g_miss_num_map(ddx_complete_rec.program_id);
827 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
828 p1_a7 := rosetta_g_miss_num_map(ddx_complete_rec.request_id);
829 p1_a8 := rosetta_g_miss_num_map(ddx_complete_rec.program_application_id);
831 p1_a10 := ddx_complete_rec.program_update_date;
832 p1_a11 := ddx_complete_rec.object_name;
833 p1_a12 := rosetta_g_miss_num_map(ddx_complete_rec.attr_code_id);
834 p1_a13 := rosetta_g_miss_num_map(ddx_complete_rec.lead_id);
835 p1_a14 := ddx_complete_rec.uom_code;
836 p1_a15 := rosetta_g_miss_num_map(ddx_complete_rec.quantity);
837 p1_a16 := rosetta_g_miss_num_map(ddx_complete_rec.amount);
838 p1_a17 := ddx_complete_rec.attribute_category;
839 p1_a18 := ddx_complete_rec.attribute1;
840 p1_a19 := ddx_complete_rec.attribute2;
841 p1_a20 := ddx_complete_rec.attribute3;
842 p1_a21 := ddx_complete_rec.attribute4;
843 p1_a22 := ddx_complete_rec.attribute5;
844 p1_a23 := ddx_complete_rec.attribute6;
845 p1_a24 := ddx_complete_rec.attribute7;
846 p1_a25 := ddx_complete_rec.attribute8;
847 p1_a26 := ddx_complete_rec.attribute9;
848 p1_a27 := ddx_complete_rec.attribute10;
849 p1_a28 := ddx_complete_rec.attribute11;
850 p1_a29 := ddx_complete_rec.attribute12;
851 p1_a30 := ddx_complete_rec.attribute13;
852 p1_a31 := ddx_complete_rec.attribute14;
853 p1_a32 := ddx_complete_rec.attribute15;
854 p1_a33 := rosetta_g_miss_num_map(ddx_complete_rec.object_id);
855 p1_a34 := rosetta_g_miss_num_map(ddx_complete_rec.partner_id);
856 end;
857
858 end pvx_lead_pss_lines_pvt_w;