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