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