[Home] [Help]
PACKAGE BODY: APPS.AMS_DELIVERABLE_PVT_W
Source
1 package body ams_deliverable_pvt_w as
2 /* $Header: amswdelb.pls 120.0 2005/05/31 22:47:02 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_deliverable(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_deliv_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 VARCHAR2 := fnd_api.g_miss_char
39 , p7_a9 NUMBER := 0-1962.0724
40 , p7_a10 NUMBER := 0-1962.0724
41 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42 , p7_a12 DATE := fnd_api.g_miss_date
43 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
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 NUMBER := 0-1962.0724
49 , p7_a19 NUMBER := 0-1962.0724
50 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52 , p7_a22 NUMBER := 0-1962.0724
53 , p7_a23 NUMBER := 0-1962.0724
54 , p7_a24 NUMBER := 0-1962.0724
55 , p7_a25 NUMBER := 0-1962.0724
56 , p7_a26 DATE := fnd_api.g_miss_date
57 , p7_a27 DATE := fnd_api.g_miss_date
58 , p7_a28 DATE := fnd_api.g_miss_date
59 , p7_a29 DATE := fnd_api.g_miss_date
60 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62 , p7_a32 NUMBER := 0-1962.0724
63 , p7_a33 NUMBER := 0-1962.0724
64 , p7_a34 NUMBER := 0-1962.0724
65 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
66 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
67 , p7_a37 NUMBER := 0-1962.0724
68 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
69 , p7_a39 NUMBER := 0-1962.0724
70 , p7_a40 NUMBER := 0-1962.0724
71 , p7_a41 NUMBER := 0-1962.0724
72 , p7_a42 NUMBER := 0-1962.0724
73 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
74 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
75 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
76 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
77 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
78 , p7_a48 NUMBER := 0-1962.0724
79 , p7_a49 NUMBER := 0-1962.0724
80 , p7_a50 NUMBER := 0-1962.0724
81 , p7_a51 NUMBER := 0-1962.0724
82 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
83 , p7_a53 NUMBER := 0-1962.0724
84 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
85 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
86 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
87 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
88 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
89 , p7_a59 VARCHAR2 := fnd_api.g_miss_char
90 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
91 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
92 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
93 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
94 , p7_a64 VARCHAR2 := fnd_api.g_miss_char
95 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
96 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
97 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
98 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
99 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
100 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
101 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
102 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
103 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
104 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
105 , p7_a75 NUMBER := 0-1962.0724
106 , p7_a76 NUMBER := 0-1962.0724
107 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
108 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
109 , p7_a79 NUMBER := 0-1962.0724
110 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
111 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
112 )
113
114 as
115 ddp_deliv_rec ams_deliverable_pvt.deliv_rec_type;
116 ddindx binary_integer; indx binary_integer;
117 begin
118
119 -- copy data to the local IN or IN-OUT args, if any
120
121
122
123
124
125
126
127 ddp_deliv_rec.deliverable_id := rosetta_g_miss_num_map(p7_a0);
128 ddp_deliv_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
129 ddp_deliv_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
130 ddp_deliv_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
131 ddp_deliv_rec.created_by := rosetta_g_miss_num_map(p7_a4);
132 ddp_deliv_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
133 ddp_deliv_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
134 ddp_deliv_rec.language_code := p7_a7;
135 ddp_deliv_rec.version := p7_a8;
136 ddp_deliv_rec.application_id := rosetta_g_miss_num_map(p7_a9);
137 ddp_deliv_rec.user_status_id := rosetta_g_miss_num_map(p7_a10);
138 ddp_deliv_rec.status_code := p7_a11;
139 ddp_deliv_rec.status_date := rosetta_g_miss_date_in_map(p7_a12);
140 ddp_deliv_rec.active_flag := p7_a13;
141 ddp_deliv_rec.private_flag := p7_a14;
142 ddp_deliv_rec.owner_user_id := rosetta_g_miss_num_map(p7_a15);
143 ddp_deliv_rec.fund_source_id := rosetta_g_miss_num_map(p7_a16);
144 ddp_deliv_rec.fund_source_type := p7_a17;
145 ddp_deliv_rec.category_type_id := rosetta_g_miss_num_map(p7_a18);
146 ddp_deliv_rec.category_sub_type_id := rosetta_g_miss_num_map(p7_a19);
147 ddp_deliv_rec.kit_flag := p7_a20;
148 ddp_deliv_rec.inventory_flag := p7_a21;
149 ddp_deliv_rec.inventory_item_id := rosetta_g_miss_num_map(p7_a22);
150 ddp_deliv_rec.inventory_item_org_id := rosetta_g_miss_num_map(p7_a23);
151 ddp_deliv_rec.pricelist_header_id := rosetta_g_miss_num_map(p7_a24);
152 ddp_deliv_rec.pricelist_line_id := rosetta_g_miss_num_map(p7_a25);
153 ddp_deliv_rec.actual_avail_from_date := rosetta_g_miss_date_in_map(p7_a26);
154 ddp_deliv_rec.actual_avail_to_date := rosetta_g_miss_date_in_map(p7_a27);
155 ddp_deliv_rec.forecasted_complete_date := rosetta_g_miss_date_in_map(p7_a28);
156 ddp_deliv_rec.actual_complete_date := rosetta_g_miss_date_in_map(p7_a29);
157 ddp_deliv_rec.transaction_currency_code := p7_a30;
158 ddp_deliv_rec.functional_currency_code := p7_a31;
159 ddp_deliv_rec.budget_amount_tc := rosetta_g_miss_num_map(p7_a32);
160 ddp_deliv_rec.budget_amount_fc := rosetta_g_miss_num_map(p7_a33);
161 ddp_deliv_rec.replaced_by_deliverable_id := rosetta_g_miss_num_map(p7_a34);
162 ddp_deliv_rec.can_fulfill_electronic_flag := p7_a35;
163 ddp_deliv_rec.can_fulfill_physical_flag := p7_a36;
164 ddp_deliv_rec.jtf_amv_item_id := rosetta_g_miss_num_map(p7_a37);
165 ddp_deliv_rec.non_inv_ctrl_code := p7_a38;
166 ddp_deliv_rec.non_inv_quantity_on_hand := rosetta_g_miss_num_map(p7_a39);
167 ddp_deliv_rec.non_inv_quantity_on_order := rosetta_g_miss_num_map(p7_a40);
168 ddp_deliv_rec.non_inv_quantity_on_reserve := rosetta_g_miss_num_map(p7_a41);
169 ddp_deliv_rec.chargeback_amount := rosetta_g_miss_num_map(p7_a42);
170 ddp_deliv_rec.chargeback_uom := p7_a43;
171 ddp_deliv_rec.chargeback_amount_curr_code := p7_a44;
172 ddp_deliv_rec.deliverable_code := p7_a45;
173 ddp_deliv_rec.deliverable_pick_flag := p7_a46;
174 ddp_deliv_rec.currency_code := p7_a47;
175 ddp_deliv_rec.forecasted_cost := rosetta_g_miss_num_map(p7_a48);
176 ddp_deliv_rec.actual_cost := rosetta_g_miss_num_map(p7_a49);
177 ddp_deliv_rec.forecasted_responses := rosetta_g_miss_num_map(p7_a50);
178 ddp_deliv_rec.actual_responses := rosetta_g_miss_num_map(p7_a51);
179 ddp_deliv_rec.country := p7_a52;
180 ddp_deliv_rec.default_approver_id := rosetta_g_miss_num_map(p7_a53);
181 ddp_deliv_rec.attribute_category := p7_a54;
182 ddp_deliv_rec.attribute1 := p7_a55;
183 ddp_deliv_rec.attribute2 := p7_a56;
184 ddp_deliv_rec.attribute3 := p7_a57;
185 ddp_deliv_rec.attribute4 := p7_a58;
186 ddp_deliv_rec.attribute5 := p7_a59;
187 ddp_deliv_rec.attribute6 := p7_a60;
188 ddp_deliv_rec.attribute7 := p7_a61;
189 ddp_deliv_rec.attribute8 := p7_a62;
190 ddp_deliv_rec.attribute9 := p7_a63;
191 ddp_deliv_rec.attribute10 := p7_a64;
192 ddp_deliv_rec.attribute11 := p7_a65;
193 ddp_deliv_rec.attribute12 := p7_a66;
194 ddp_deliv_rec.attribute13 := p7_a67;
195 ddp_deliv_rec.attribute14 := p7_a68;
196 ddp_deliv_rec.attribute15 := p7_a69;
197 ddp_deliv_rec.deliverable_name := p7_a70;
198 ddp_deliv_rec.description := p7_a71;
199 ddp_deliv_rec.start_period_name := p7_a72;
200 ddp_deliv_rec.end_period_name := p7_a73;
201 ddp_deliv_rec.deliverable_calendar := p7_a74;
202 ddp_deliv_rec.country_id := rosetta_g_miss_num_map(p7_a75);
203 ddp_deliv_rec.setup_id := rosetta_g_miss_num_map(p7_a76);
204 ddp_deliv_rec.item_number := p7_a77;
205 ddp_deliv_rec.associate_flag := p7_a78;
206 ddp_deliv_rec.master_object_id := rosetta_g_miss_num_map(p7_a79);
207 ddp_deliv_rec.master_object_type := p7_a80;
208 ddp_deliv_rec.email_content_type := p7_a81;
209
210
211 -- here's the delegated call to the old PL/SQL routine
212 ams_deliverable_pvt.create_deliverable(p_api_version,
213 p_init_msg_list,
214 p_commit,
215 p_validation_level,
216 x_return_status,
217 x_msg_count,
218 x_msg_data,
219 ddp_deliv_rec,
220 x_deliv_id);
221
222 -- copy data back from the local variables to OUT or IN-OUT args, if any
223
224
225
226
227
228
229
230
231 end;
232
233 procedure update_deliverable(p_api_version NUMBER
234 , p_init_msg_list VARCHAR2
235 , p_commit VARCHAR2
236 , p_validation_level NUMBER
237 , x_return_status out nocopy VARCHAR2
238 , x_msg_count out nocopy NUMBER
239 , x_msg_data out nocopy VARCHAR2
240 , p7_a0 NUMBER := 0-1962.0724
241 , p7_a1 DATE := fnd_api.g_miss_date
242 , p7_a2 NUMBER := 0-1962.0724
243 , p7_a3 DATE := fnd_api.g_miss_date
244 , p7_a4 NUMBER := 0-1962.0724
245 , p7_a5 NUMBER := 0-1962.0724
246 , p7_a6 NUMBER := 0-1962.0724
247 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
248 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
249 , p7_a9 NUMBER := 0-1962.0724
250 , p7_a10 NUMBER := 0-1962.0724
251 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
252 , p7_a12 DATE := fnd_api.g_miss_date
253 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
254 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
255 , p7_a15 NUMBER := 0-1962.0724
256 , p7_a16 NUMBER := 0-1962.0724
257 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
258 , p7_a18 NUMBER := 0-1962.0724
259 , p7_a19 NUMBER := 0-1962.0724
260 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
261 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
262 , p7_a22 NUMBER := 0-1962.0724
263 , p7_a23 NUMBER := 0-1962.0724
264 , p7_a24 NUMBER := 0-1962.0724
265 , p7_a25 NUMBER := 0-1962.0724
266 , p7_a26 DATE := fnd_api.g_miss_date
267 , p7_a27 DATE := fnd_api.g_miss_date
268 , p7_a28 DATE := fnd_api.g_miss_date
269 , p7_a29 DATE := fnd_api.g_miss_date
270 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
271 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
272 , p7_a32 NUMBER := 0-1962.0724
273 , p7_a33 NUMBER := 0-1962.0724
274 , p7_a34 NUMBER := 0-1962.0724
275 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
276 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
277 , p7_a37 NUMBER := 0-1962.0724
278 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
279 , p7_a39 NUMBER := 0-1962.0724
280 , p7_a40 NUMBER := 0-1962.0724
281 , p7_a41 NUMBER := 0-1962.0724
282 , p7_a42 NUMBER := 0-1962.0724
283 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
284 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
285 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
286 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
287 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
288 , p7_a48 NUMBER := 0-1962.0724
289 , p7_a49 NUMBER := 0-1962.0724
290 , p7_a50 NUMBER := 0-1962.0724
291 , p7_a51 NUMBER := 0-1962.0724
292 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
293 , p7_a53 NUMBER := 0-1962.0724
294 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
295 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
296 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
297 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
298 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
299 , p7_a59 VARCHAR2 := fnd_api.g_miss_char
300 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
301 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
302 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
303 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
304 , p7_a64 VARCHAR2 := fnd_api.g_miss_char
305 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
306 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
307 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
308 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
309 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
310 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
311 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
312 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
313 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
314 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
315 , p7_a75 NUMBER := 0-1962.0724
316 , p7_a76 NUMBER := 0-1962.0724
317 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
318 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
319 , p7_a79 NUMBER := 0-1962.0724
320 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
321 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
322 )
323
324 as
325 ddp_deliv_rec ams_deliverable_pvt.deliv_rec_type;
326 ddindx binary_integer; indx binary_integer;
327 begin
328
329 -- copy data to the local IN or IN-OUT args, if any
330
331
332
333
334
335
336
337 ddp_deliv_rec.deliverable_id := rosetta_g_miss_num_map(p7_a0);
338 ddp_deliv_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
339 ddp_deliv_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
340 ddp_deliv_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
341 ddp_deliv_rec.created_by := rosetta_g_miss_num_map(p7_a4);
342 ddp_deliv_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
343 ddp_deliv_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
344 ddp_deliv_rec.language_code := p7_a7;
345 ddp_deliv_rec.version := p7_a8;
346 ddp_deliv_rec.application_id := rosetta_g_miss_num_map(p7_a9);
347 ddp_deliv_rec.user_status_id := rosetta_g_miss_num_map(p7_a10);
348 ddp_deliv_rec.status_code := p7_a11;
349 ddp_deliv_rec.status_date := rosetta_g_miss_date_in_map(p7_a12);
350 ddp_deliv_rec.active_flag := p7_a13;
351 ddp_deliv_rec.private_flag := p7_a14;
352 ddp_deliv_rec.owner_user_id := rosetta_g_miss_num_map(p7_a15);
353 ddp_deliv_rec.fund_source_id := rosetta_g_miss_num_map(p7_a16);
354 ddp_deliv_rec.fund_source_type := p7_a17;
355 ddp_deliv_rec.category_type_id := rosetta_g_miss_num_map(p7_a18);
356 ddp_deliv_rec.category_sub_type_id := rosetta_g_miss_num_map(p7_a19);
357 ddp_deliv_rec.kit_flag := p7_a20;
358 ddp_deliv_rec.inventory_flag := p7_a21;
362 ddp_deliv_rec.pricelist_line_id := rosetta_g_miss_num_map(p7_a25);
359 ddp_deliv_rec.inventory_item_id := rosetta_g_miss_num_map(p7_a22);
360 ddp_deliv_rec.inventory_item_org_id := rosetta_g_miss_num_map(p7_a23);
361 ddp_deliv_rec.pricelist_header_id := rosetta_g_miss_num_map(p7_a24);
363 ddp_deliv_rec.actual_avail_from_date := rosetta_g_miss_date_in_map(p7_a26);
364 ddp_deliv_rec.actual_avail_to_date := rosetta_g_miss_date_in_map(p7_a27);
365 ddp_deliv_rec.forecasted_complete_date := rosetta_g_miss_date_in_map(p7_a28);
366 ddp_deliv_rec.actual_complete_date := rosetta_g_miss_date_in_map(p7_a29);
367 ddp_deliv_rec.transaction_currency_code := p7_a30;
368 ddp_deliv_rec.functional_currency_code := p7_a31;
369 ddp_deliv_rec.budget_amount_tc := rosetta_g_miss_num_map(p7_a32);
370 ddp_deliv_rec.budget_amount_fc := rosetta_g_miss_num_map(p7_a33);
371 ddp_deliv_rec.replaced_by_deliverable_id := rosetta_g_miss_num_map(p7_a34);
372 ddp_deliv_rec.can_fulfill_electronic_flag := p7_a35;
373 ddp_deliv_rec.can_fulfill_physical_flag := p7_a36;
374 ddp_deliv_rec.jtf_amv_item_id := rosetta_g_miss_num_map(p7_a37);
375 ddp_deliv_rec.non_inv_ctrl_code := p7_a38;
376 ddp_deliv_rec.non_inv_quantity_on_hand := rosetta_g_miss_num_map(p7_a39);
377 ddp_deliv_rec.non_inv_quantity_on_order := rosetta_g_miss_num_map(p7_a40);
378 ddp_deliv_rec.non_inv_quantity_on_reserve := rosetta_g_miss_num_map(p7_a41);
379 ddp_deliv_rec.chargeback_amount := rosetta_g_miss_num_map(p7_a42);
380 ddp_deliv_rec.chargeback_uom := p7_a43;
381 ddp_deliv_rec.chargeback_amount_curr_code := p7_a44;
382 ddp_deliv_rec.deliverable_code := p7_a45;
383 ddp_deliv_rec.deliverable_pick_flag := p7_a46;
384 ddp_deliv_rec.currency_code := p7_a47;
385 ddp_deliv_rec.forecasted_cost := rosetta_g_miss_num_map(p7_a48);
386 ddp_deliv_rec.actual_cost := rosetta_g_miss_num_map(p7_a49);
387 ddp_deliv_rec.forecasted_responses := rosetta_g_miss_num_map(p7_a50);
388 ddp_deliv_rec.actual_responses := rosetta_g_miss_num_map(p7_a51);
389 ddp_deliv_rec.country := p7_a52;
390 ddp_deliv_rec.default_approver_id := rosetta_g_miss_num_map(p7_a53);
391 ddp_deliv_rec.attribute_category := p7_a54;
392 ddp_deliv_rec.attribute1 := p7_a55;
393 ddp_deliv_rec.attribute2 := p7_a56;
394 ddp_deliv_rec.attribute3 := p7_a57;
395 ddp_deliv_rec.attribute4 := p7_a58;
396 ddp_deliv_rec.attribute5 := p7_a59;
397 ddp_deliv_rec.attribute6 := p7_a60;
398 ddp_deliv_rec.attribute7 := p7_a61;
399 ddp_deliv_rec.attribute8 := p7_a62;
400 ddp_deliv_rec.attribute9 := p7_a63;
401 ddp_deliv_rec.attribute10 := p7_a64;
402 ddp_deliv_rec.attribute11 := p7_a65;
403 ddp_deliv_rec.attribute12 := p7_a66;
404 ddp_deliv_rec.attribute13 := p7_a67;
405 ddp_deliv_rec.attribute14 := p7_a68;
406 ddp_deliv_rec.attribute15 := p7_a69;
407 ddp_deliv_rec.deliverable_name := p7_a70;
408 ddp_deliv_rec.description := p7_a71;
409 ddp_deliv_rec.start_period_name := p7_a72;
410 ddp_deliv_rec.end_period_name := p7_a73;
411 ddp_deliv_rec.deliverable_calendar := p7_a74;
412 ddp_deliv_rec.country_id := rosetta_g_miss_num_map(p7_a75);
413 ddp_deliv_rec.setup_id := rosetta_g_miss_num_map(p7_a76);
414 ddp_deliv_rec.item_number := p7_a77;
415 ddp_deliv_rec.associate_flag := p7_a78;
416 ddp_deliv_rec.master_object_id := rosetta_g_miss_num_map(p7_a79);
417 ddp_deliv_rec.master_object_type := p7_a80;
418 ddp_deliv_rec.email_content_type := p7_a81;
419
420 -- here's the delegated call to the old PL/SQL routine
421 ams_deliverable_pvt.update_deliverable(p_api_version,
422 p_init_msg_list,
423 p_commit,
424 p_validation_level,
425 x_return_status,
426 x_msg_count,
427 x_msg_data,
428 ddp_deliv_rec);
429
430 -- copy data back from the local variables to OUT or IN-OUT args, if any
431
432
433
434
435
436
437
438 end;
439
440 procedure validate_deliverable(p_api_version NUMBER
441 , p_init_msg_list VARCHAR2
442 , p_validation_level NUMBER
443 , p_validation_mode VARCHAR2
444 , x_return_status out nocopy VARCHAR2
445 , x_msg_count out nocopy NUMBER
446 , x_msg_data out nocopy VARCHAR2
447 , p7_a0 NUMBER := 0-1962.0724
448 , p7_a1 DATE := fnd_api.g_miss_date
449 , p7_a2 NUMBER := 0-1962.0724
450 , p7_a3 DATE := fnd_api.g_miss_date
451 , p7_a4 NUMBER := 0-1962.0724
452 , p7_a5 NUMBER := 0-1962.0724
453 , p7_a6 NUMBER := 0-1962.0724
454 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
455 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
456 , p7_a9 NUMBER := 0-1962.0724
457 , p7_a10 NUMBER := 0-1962.0724
458 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
459 , p7_a12 DATE := fnd_api.g_miss_date
460 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
461 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
462 , p7_a15 NUMBER := 0-1962.0724
463 , p7_a16 NUMBER := 0-1962.0724
464 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
465 , p7_a18 NUMBER := 0-1962.0724
466 , p7_a19 NUMBER := 0-1962.0724
467 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
468 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
469 , p7_a22 NUMBER := 0-1962.0724
470 , p7_a23 NUMBER := 0-1962.0724
471 , p7_a24 NUMBER := 0-1962.0724
472 , p7_a25 NUMBER := 0-1962.0724
473 , p7_a26 DATE := fnd_api.g_miss_date
474 , p7_a27 DATE := fnd_api.g_miss_date
478 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
475 , p7_a28 DATE := fnd_api.g_miss_date
476 , p7_a29 DATE := fnd_api.g_miss_date
477 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
479 , p7_a32 NUMBER := 0-1962.0724
480 , p7_a33 NUMBER := 0-1962.0724
481 , p7_a34 NUMBER := 0-1962.0724
482 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
483 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
484 , p7_a37 NUMBER := 0-1962.0724
485 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
486 , p7_a39 NUMBER := 0-1962.0724
487 , p7_a40 NUMBER := 0-1962.0724
488 , p7_a41 NUMBER := 0-1962.0724
489 , p7_a42 NUMBER := 0-1962.0724
490 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
491 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
492 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
493 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
494 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
495 , p7_a48 NUMBER := 0-1962.0724
496 , p7_a49 NUMBER := 0-1962.0724
497 , p7_a50 NUMBER := 0-1962.0724
498 , p7_a51 NUMBER := 0-1962.0724
499 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
500 , p7_a53 NUMBER := 0-1962.0724
501 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
502 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
503 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
504 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
505 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
506 , p7_a59 VARCHAR2 := fnd_api.g_miss_char
507 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
508 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
509 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
510 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
511 , p7_a64 VARCHAR2 := fnd_api.g_miss_char
512 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
513 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
514 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
515 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
516 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
517 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
518 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
519 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
520 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
521 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
522 , p7_a75 NUMBER := 0-1962.0724
523 , p7_a76 NUMBER := 0-1962.0724
524 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
525 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
526 , p7_a79 NUMBER := 0-1962.0724
527 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
528 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
529 )
530
531 as
532 ddp_deliv_rec ams_deliverable_pvt.deliv_rec_type;
533 ddindx binary_integer; indx binary_integer;
534 begin
535
536 -- copy data to the local IN or IN-OUT args, if any
537
538
539
540
541
542
543
544 ddp_deliv_rec.deliverable_id := rosetta_g_miss_num_map(p7_a0);
545 ddp_deliv_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
546 ddp_deliv_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
547 ddp_deliv_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
548 ddp_deliv_rec.created_by := rosetta_g_miss_num_map(p7_a4);
549 ddp_deliv_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
550 ddp_deliv_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
551 ddp_deliv_rec.language_code := p7_a7;
552 ddp_deliv_rec.version := p7_a8;
553 ddp_deliv_rec.application_id := rosetta_g_miss_num_map(p7_a9);
554 ddp_deliv_rec.user_status_id := rosetta_g_miss_num_map(p7_a10);
555 ddp_deliv_rec.status_code := p7_a11;
556 ddp_deliv_rec.status_date := rosetta_g_miss_date_in_map(p7_a12);
557 ddp_deliv_rec.active_flag := p7_a13;
558 ddp_deliv_rec.private_flag := p7_a14;
559 ddp_deliv_rec.owner_user_id := rosetta_g_miss_num_map(p7_a15);
560 ddp_deliv_rec.fund_source_id := rosetta_g_miss_num_map(p7_a16);
561 ddp_deliv_rec.fund_source_type := p7_a17;
562 ddp_deliv_rec.category_type_id := rosetta_g_miss_num_map(p7_a18);
563 ddp_deliv_rec.category_sub_type_id := rosetta_g_miss_num_map(p7_a19);
564 ddp_deliv_rec.kit_flag := p7_a20;
565 ddp_deliv_rec.inventory_flag := p7_a21;
566 ddp_deliv_rec.inventory_item_id := rosetta_g_miss_num_map(p7_a22);
567 ddp_deliv_rec.inventory_item_org_id := rosetta_g_miss_num_map(p7_a23);
568 ddp_deliv_rec.pricelist_header_id := rosetta_g_miss_num_map(p7_a24);
569 ddp_deliv_rec.pricelist_line_id := rosetta_g_miss_num_map(p7_a25);
570 ddp_deliv_rec.actual_avail_from_date := rosetta_g_miss_date_in_map(p7_a26);
571 ddp_deliv_rec.actual_avail_to_date := rosetta_g_miss_date_in_map(p7_a27);
572 ddp_deliv_rec.forecasted_complete_date := rosetta_g_miss_date_in_map(p7_a28);
573 ddp_deliv_rec.actual_complete_date := rosetta_g_miss_date_in_map(p7_a29);
574 ddp_deliv_rec.transaction_currency_code := p7_a30;
575 ddp_deliv_rec.functional_currency_code := p7_a31;
576 ddp_deliv_rec.budget_amount_tc := rosetta_g_miss_num_map(p7_a32);
577 ddp_deliv_rec.budget_amount_fc := rosetta_g_miss_num_map(p7_a33);
578 ddp_deliv_rec.replaced_by_deliverable_id := rosetta_g_miss_num_map(p7_a34);
579 ddp_deliv_rec.can_fulfill_electronic_flag := p7_a35;
580 ddp_deliv_rec.can_fulfill_physical_flag := p7_a36;
581 ddp_deliv_rec.jtf_amv_item_id := rosetta_g_miss_num_map(p7_a37);
582 ddp_deliv_rec.non_inv_ctrl_code := p7_a38;
583 ddp_deliv_rec.non_inv_quantity_on_hand := rosetta_g_miss_num_map(p7_a39);
587 ddp_deliv_rec.chargeback_uom := p7_a43;
584 ddp_deliv_rec.non_inv_quantity_on_order := rosetta_g_miss_num_map(p7_a40);
585 ddp_deliv_rec.non_inv_quantity_on_reserve := rosetta_g_miss_num_map(p7_a41);
586 ddp_deliv_rec.chargeback_amount := rosetta_g_miss_num_map(p7_a42);
588 ddp_deliv_rec.chargeback_amount_curr_code := p7_a44;
589 ddp_deliv_rec.deliverable_code := p7_a45;
590 ddp_deliv_rec.deliverable_pick_flag := p7_a46;
591 ddp_deliv_rec.currency_code := p7_a47;
592 ddp_deliv_rec.forecasted_cost := rosetta_g_miss_num_map(p7_a48);
593 ddp_deliv_rec.actual_cost := rosetta_g_miss_num_map(p7_a49);
594 ddp_deliv_rec.forecasted_responses := rosetta_g_miss_num_map(p7_a50);
595 ddp_deliv_rec.actual_responses := rosetta_g_miss_num_map(p7_a51);
596 ddp_deliv_rec.country := p7_a52;
597 ddp_deliv_rec.default_approver_id := rosetta_g_miss_num_map(p7_a53);
598 ddp_deliv_rec.attribute_category := p7_a54;
599 ddp_deliv_rec.attribute1 := p7_a55;
600 ddp_deliv_rec.attribute2 := p7_a56;
601 ddp_deliv_rec.attribute3 := p7_a57;
602 ddp_deliv_rec.attribute4 := p7_a58;
603 ddp_deliv_rec.attribute5 := p7_a59;
604 ddp_deliv_rec.attribute6 := p7_a60;
605 ddp_deliv_rec.attribute7 := p7_a61;
606 ddp_deliv_rec.attribute8 := p7_a62;
607 ddp_deliv_rec.attribute9 := p7_a63;
608 ddp_deliv_rec.attribute10 := p7_a64;
609 ddp_deliv_rec.attribute11 := p7_a65;
610 ddp_deliv_rec.attribute12 := p7_a66;
611 ddp_deliv_rec.attribute13 := p7_a67;
612 ddp_deliv_rec.attribute14 := p7_a68;
613 ddp_deliv_rec.attribute15 := p7_a69;
614 ddp_deliv_rec.deliverable_name := p7_a70;
615 ddp_deliv_rec.description := p7_a71;
616 ddp_deliv_rec.start_period_name := p7_a72;
617 ddp_deliv_rec.end_period_name := p7_a73;
618 ddp_deliv_rec.deliverable_calendar := p7_a74;
619 ddp_deliv_rec.country_id := rosetta_g_miss_num_map(p7_a75);
620 ddp_deliv_rec.setup_id := rosetta_g_miss_num_map(p7_a76);
621 ddp_deliv_rec.item_number := p7_a77;
622 ddp_deliv_rec.associate_flag := p7_a78;
623 ddp_deliv_rec.master_object_id := rosetta_g_miss_num_map(p7_a79);
624 ddp_deliv_rec.master_object_type := p7_a80;
625 ddp_deliv_rec.email_content_type := p7_a81;
626
627 -- here's the delegated call to the old PL/SQL routine
628 ams_deliverable_pvt.validate_deliverable(p_api_version,
629 p_init_msg_list,
630 p_validation_level,
631 p_validation_mode,
632 x_return_status,
633 x_msg_count,
634 x_msg_data,
635 ddp_deliv_rec);
636
637 -- copy data back from the local variables to OUT or IN-OUT args, if any
638
639
640
641
642
643
644
645 end;
646
647 procedure check_deliv_items(p_validation_mode VARCHAR2
648 , x_return_status out nocopy VARCHAR2
649 , p0_a0 NUMBER := 0-1962.0724
650 , p0_a1 DATE := fnd_api.g_miss_date
651 , p0_a2 NUMBER := 0-1962.0724
652 , p0_a3 DATE := fnd_api.g_miss_date
653 , p0_a4 NUMBER := 0-1962.0724
654 , p0_a5 NUMBER := 0-1962.0724
655 , p0_a6 NUMBER := 0-1962.0724
656 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
657 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
658 , p0_a9 NUMBER := 0-1962.0724
659 , p0_a10 NUMBER := 0-1962.0724
660 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
661 , p0_a12 DATE := fnd_api.g_miss_date
662 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
663 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
664 , p0_a15 NUMBER := 0-1962.0724
665 , p0_a16 NUMBER := 0-1962.0724
666 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
667 , p0_a18 NUMBER := 0-1962.0724
668 , p0_a19 NUMBER := 0-1962.0724
669 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
670 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
671 , p0_a22 NUMBER := 0-1962.0724
672 , p0_a23 NUMBER := 0-1962.0724
673 , p0_a24 NUMBER := 0-1962.0724
674 , p0_a25 NUMBER := 0-1962.0724
675 , p0_a26 DATE := fnd_api.g_miss_date
676 , p0_a27 DATE := fnd_api.g_miss_date
677 , p0_a28 DATE := fnd_api.g_miss_date
678 , p0_a29 DATE := fnd_api.g_miss_date
679 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
680 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
681 , p0_a32 NUMBER := 0-1962.0724
682 , p0_a33 NUMBER := 0-1962.0724
683 , p0_a34 NUMBER := 0-1962.0724
684 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
685 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
686 , p0_a37 NUMBER := 0-1962.0724
687 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
688 , p0_a39 NUMBER := 0-1962.0724
689 , p0_a40 NUMBER := 0-1962.0724
690 , p0_a41 NUMBER := 0-1962.0724
691 , p0_a42 NUMBER := 0-1962.0724
692 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
693 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
694 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
695 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
696 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
697 , p0_a48 NUMBER := 0-1962.0724
698 , p0_a49 NUMBER := 0-1962.0724
699 , p0_a50 NUMBER := 0-1962.0724
700 , p0_a51 NUMBER := 0-1962.0724
701 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
702 , p0_a53 NUMBER := 0-1962.0724
703 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
704 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
705 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
706 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
707 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
711 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
708 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
709 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
710 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
712 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
713 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
714 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
715 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
716 , p0_a67 VARCHAR2 := fnd_api.g_miss_char
717 , p0_a68 VARCHAR2 := fnd_api.g_miss_char
718 , p0_a69 VARCHAR2 := fnd_api.g_miss_char
719 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
720 , p0_a71 VARCHAR2 := fnd_api.g_miss_char
721 , p0_a72 VARCHAR2 := fnd_api.g_miss_char
722 , p0_a73 VARCHAR2 := fnd_api.g_miss_char
723 , p0_a74 VARCHAR2 := fnd_api.g_miss_char
724 , p0_a75 NUMBER := 0-1962.0724
725 , p0_a76 NUMBER := 0-1962.0724
726 , p0_a77 VARCHAR2 := fnd_api.g_miss_char
727 , p0_a78 VARCHAR2 := fnd_api.g_miss_char
728 , p0_a79 NUMBER := 0-1962.0724
729 , p0_a80 VARCHAR2 := fnd_api.g_miss_char
730 , p0_a81 VARCHAR2 := fnd_api.g_miss_char
731 )
732
733 as
734 ddp_deliv_rec ams_deliverable_pvt.deliv_rec_type;
735 ddindx binary_integer; indx binary_integer;
736 begin
737
738 -- copy data to the local IN or IN-OUT args, if any
739 ddp_deliv_rec.deliverable_id := rosetta_g_miss_num_map(p0_a0);
740 ddp_deliv_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
741 ddp_deliv_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
742 ddp_deliv_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
743 ddp_deliv_rec.created_by := rosetta_g_miss_num_map(p0_a4);
744 ddp_deliv_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
745 ddp_deliv_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
746 ddp_deliv_rec.language_code := p0_a7;
747 ddp_deliv_rec.version := p0_a8;
748 ddp_deliv_rec.application_id := rosetta_g_miss_num_map(p0_a9);
749 ddp_deliv_rec.user_status_id := rosetta_g_miss_num_map(p0_a10);
750 ddp_deliv_rec.status_code := p0_a11;
751 ddp_deliv_rec.status_date := rosetta_g_miss_date_in_map(p0_a12);
752 ddp_deliv_rec.active_flag := p0_a13;
753 ddp_deliv_rec.private_flag := p0_a14;
754 ddp_deliv_rec.owner_user_id := rosetta_g_miss_num_map(p0_a15);
755 ddp_deliv_rec.fund_source_id := rosetta_g_miss_num_map(p0_a16);
756 ddp_deliv_rec.fund_source_type := p0_a17;
757 ddp_deliv_rec.category_type_id := rosetta_g_miss_num_map(p0_a18);
758 ddp_deliv_rec.category_sub_type_id := rosetta_g_miss_num_map(p0_a19);
759 ddp_deliv_rec.kit_flag := p0_a20;
760 ddp_deliv_rec.inventory_flag := p0_a21;
761 ddp_deliv_rec.inventory_item_id := rosetta_g_miss_num_map(p0_a22);
762 ddp_deliv_rec.inventory_item_org_id := rosetta_g_miss_num_map(p0_a23);
763 ddp_deliv_rec.pricelist_header_id := rosetta_g_miss_num_map(p0_a24);
764 ddp_deliv_rec.pricelist_line_id := rosetta_g_miss_num_map(p0_a25);
765 ddp_deliv_rec.actual_avail_from_date := rosetta_g_miss_date_in_map(p0_a26);
766 ddp_deliv_rec.actual_avail_to_date := rosetta_g_miss_date_in_map(p0_a27);
767 ddp_deliv_rec.forecasted_complete_date := rosetta_g_miss_date_in_map(p0_a28);
768 ddp_deliv_rec.actual_complete_date := rosetta_g_miss_date_in_map(p0_a29);
769 ddp_deliv_rec.transaction_currency_code := p0_a30;
770 ddp_deliv_rec.functional_currency_code := p0_a31;
771 ddp_deliv_rec.budget_amount_tc := rosetta_g_miss_num_map(p0_a32);
772 ddp_deliv_rec.budget_amount_fc := rosetta_g_miss_num_map(p0_a33);
773 ddp_deliv_rec.replaced_by_deliverable_id := rosetta_g_miss_num_map(p0_a34);
774 ddp_deliv_rec.can_fulfill_electronic_flag := p0_a35;
775 ddp_deliv_rec.can_fulfill_physical_flag := p0_a36;
776 ddp_deliv_rec.jtf_amv_item_id := rosetta_g_miss_num_map(p0_a37);
777 ddp_deliv_rec.non_inv_ctrl_code := p0_a38;
778 ddp_deliv_rec.non_inv_quantity_on_hand := rosetta_g_miss_num_map(p0_a39);
779 ddp_deliv_rec.non_inv_quantity_on_order := rosetta_g_miss_num_map(p0_a40);
780 ddp_deliv_rec.non_inv_quantity_on_reserve := rosetta_g_miss_num_map(p0_a41);
781 ddp_deliv_rec.chargeback_amount := rosetta_g_miss_num_map(p0_a42);
782 ddp_deliv_rec.chargeback_uom := p0_a43;
783 ddp_deliv_rec.chargeback_amount_curr_code := p0_a44;
784 ddp_deliv_rec.deliverable_code := p0_a45;
785 ddp_deliv_rec.deliverable_pick_flag := p0_a46;
786 ddp_deliv_rec.currency_code := p0_a47;
787 ddp_deliv_rec.forecasted_cost := rosetta_g_miss_num_map(p0_a48);
788 ddp_deliv_rec.actual_cost := rosetta_g_miss_num_map(p0_a49);
789 ddp_deliv_rec.forecasted_responses := rosetta_g_miss_num_map(p0_a50);
790 ddp_deliv_rec.actual_responses := rosetta_g_miss_num_map(p0_a51);
791 ddp_deliv_rec.country := p0_a52;
792 ddp_deliv_rec.default_approver_id := rosetta_g_miss_num_map(p0_a53);
793 ddp_deliv_rec.attribute_category := p0_a54;
794 ddp_deliv_rec.attribute1 := p0_a55;
795 ddp_deliv_rec.attribute2 := p0_a56;
796 ddp_deliv_rec.attribute3 := p0_a57;
797 ddp_deliv_rec.attribute4 := p0_a58;
798 ddp_deliv_rec.attribute5 := p0_a59;
799 ddp_deliv_rec.attribute6 := p0_a60;
800 ddp_deliv_rec.attribute7 := p0_a61;
801 ddp_deliv_rec.attribute8 := p0_a62;
802 ddp_deliv_rec.attribute9 := p0_a63;
803 ddp_deliv_rec.attribute10 := p0_a64;
804 ddp_deliv_rec.attribute11 := p0_a65;
805 ddp_deliv_rec.attribute12 := p0_a66;
806 ddp_deliv_rec.attribute13 := p0_a67;
807 ddp_deliv_rec.attribute14 := p0_a68;
808 ddp_deliv_rec.attribute15 := p0_a69;
809 ddp_deliv_rec.deliverable_name := p0_a70;
813 ddp_deliv_rec.deliverable_calendar := p0_a74;
810 ddp_deliv_rec.description := p0_a71;
811 ddp_deliv_rec.start_period_name := p0_a72;
812 ddp_deliv_rec.end_period_name := p0_a73;
814 ddp_deliv_rec.country_id := rosetta_g_miss_num_map(p0_a75);
815 ddp_deliv_rec.setup_id := rosetta_g_miss_num_map(p0_a76);
816 ddp_deliv_rec.item_number := p0_a77;
817 ddp_deliv_rec.associate_flag := p0_a78;
818 ddp_deliv_rec.master_object_id := rosetta_g_miss_num_map(p0_a79);
819 ddp_deliv_rec.master_object_type := p0_a80;
820 ddp_deliv_rec.email_content_type := p0_a81;
821
822
823
824 -- here's the delegated call to the old PL/SQL routine
825 ams_deliverable_pvt.check_deliv_items(ddp_deliv_rec,
826 p_validation_mode,
827 x_return_status);
828
829 -- copy data back from the local variables to OUT or IN-OUT args, if any
830
831
832 end;
833
834 procedure check_deliv_record(x_return_status out nocopy VARCHAR2
835 , p0_a0 NUMBER := 0-1962.0724
836 , p0_a1 DATE := fnd_api.g_miss_date
837 , p0_a2 NUMBER := 0-1962.0724
838 , p0_a3 DATE := fnd_api.g_miss_date
839 , p0_a4 NUMBER := 0-1962.0724
840 , p0_a5 NUMBER := 0-1962.0724
841 , p0_a6 NUMBER := 0-1962.0724
842 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
843 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
844 , p0_a9 NUMBER := 0-1962.0724
845 , p0_a10 NUMBER := 0-1962.0724
846 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
847 , p0_a12 DATE := fnd_api.g_miss_date
848 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
849 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
850 , p0_a15 NUMBER := 0-1962.0724
851 , p0_a16 NUMBER := 0-1962.0724
852 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
853 , p0_a18 NUMBER := 0-1962.0724
854 , p0_a19 NUMBER := 0-1962.0724
855 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
856 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
857 , p0_a22 NUMBER := 0-1962.0724
858 , p0_a23 NUMBER := 0-1962.0724
859 , p0_a24 NUMBER := 0-1962.0724
860 , p0_a25 NUMBER := 0-1962.0724
861 , p0_a26 DATE := fnd_api.g_miss_date
862 , p0_a27 DATE := fnd_api.g_miss_date
863 , p0_a28 DATE := fnd_api.g_miss_date
864 , p0_a29 DATE := fnd_api.g_miss_date
865 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
866 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
867 , p0_a32 NUMBER := 0-1962.0724
868 , p0_a33 NUMBER := 0-1962.0724
869 , p0_a34 NUMBER := 0-1962.0724
870 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
871 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
872 , p0_a37 NUMBER := 0-1962.0724
873 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
874 , p0_a39 NUMBER := 0-1962.0724
875 , p0_a40 NUMBER := 0-1962.0724
876 , p0_a41 NUMBER := 0-1962.0724
877 , p0_a42 NUMBER := 0-1962.0724
878 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
879 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
880 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
881 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
882 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
883 , p0_a48 NUMBER := 0-1962.0724
884 , p0_a49 NUMBER := 0-1962.0724
885 , p0_a50 NUMBER := 0-1962.0724
886 , p0_a51 NUMBER := 0-1962.0724
887 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
888 , p0_a53 NUMBER := 0-1962.0724
889 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
890 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
891 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
892 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
893 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
894 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
895 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
896 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
897 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
898 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
899 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
900 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
901 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
902 , p0_a67 VARCHAR2 := fnd_api.g_miss_char
903 , p0_a68 VARCHAR2 := fnd_api.g_miss_char
904 , p0_a69 VARCHAR2 := fnd_api.g_miss_char
905 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
906 , p0_a71 VARCHAR2 := fnd_api.g_miss_char
907 , p0_a72 VARCHAR2 := fnd_api.g_miss_char
908 , p0_a73 VARCHAR2 := fnd_api.g_miss_char
909 , p0_a74 VARCHAR2 := fnd_api.g_miss_char
910 , p0_a75 NUMBER := 0-1962.0724
911 , p0_a76 NUMBER := 0-1962.0724
912 , p0_a77 VARCHAR2 := fnd_api.g_miss_char
913 , p0_a78 VARCHAR2 := fnd_api.g_miss_char
914 , p0_a79 NUMBER := 0-1962.0724
915 , p0_a80 VARCHAR2 := fnd_api.g_miss_char
916 , p0_a81 VARCHAR2 := fnd_api.g_miss_char
917 , p1_a0 NUMBER := 0-1962.0724
918 , p1_a1 DATE := fnd_api.g_miss_date
919 , p1_a2 NUMBER := 0-1962.0724
920 , p1_a3 DATE := fnd_api.g_miss_date
921 , p1_a4 NUMBER := 0-1962.0724
922 , p1_a5 NUMBER := 0-1962.0724
923 , p1_a6 NUMBER := 0-1962.0724
924 , p1_a7 VARCHAR2 := fnd_api.g_miss_char
925 , p1_a8 VARCHAR2 := fnd_api.g_miss_char
926 , p1_a9 NUMBER := 0-1962.0724
927 , p1_a10 NUMBER := 0-1962.0724
928 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
929 , p1_a12 DATE := fnd_api.g_miss_date
930 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
931 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
932 , p1_a15 NUMBER := 0-1962.0724
936 , p1_a19 NUMBER := 0-1962.0724
933 , p1_a16 NUMBER := 0-1962.0724
934 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
935 , p1_a18 NUMBER := 0-1962.0724
937 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
938 , p1_a21 VARCHAR2 := fnd_api.g_miss_char
939 , p1_a22 NUMBER := 0-1962.0724
940 , p1_a23 NUMBER := 0-1962.0724
941 , p1_a24 NUMBER := 0-1962.0724
942 , p1_a25 NUMBER := 0-1962.0724
943 , p1_a26 DATE := fnd_api.g_miss_date
944 , p1_a27 DATE := fnd_api.g_miss_date
945 , p1_a28 DATE := fnd_api.g_miss_date
946 , p1_a29 DATE := fnd_api.g_miss_date
947 , p1_a30 VARCHAR2 := fnd_api.g_miss_char
948 , p1_a31 VARCHAR2 := fnd_api.g_miss_char
949 , p1_a32 NUMBER := 0-1962.0724
950 , p1_a33 NUMBER := 0-1962.0724
951 , p1_a34 NUMBER := 0-1962.0724
952 , p1_a35 VARCHAR2 := fnd_api.g_miss_char
953 , p1_a36 VARCHAR2 := fnd_api.g_miss_char
954 , p1_a37 NUMBER := 0-1962.0724
955 , p1_a38 VARCHAR2 := fnd_api.g_miss_char
956 , p1_a39 NUMBER := 0-1962.0724
957 , p1_a40 NUMBER := 0-1962.0724
958 , p1_a41 NUMBER := 0-1962.0724
959 , p1_a42 NUMBER := 0-1962.0724
960 , p1_a43 VARCHAR2 := fnd_api.g_miss_char
961 , p1_a44 VARCHAR2 := fnd_api.g_miss_char
962 , p1_a45 VARCHAR2 := fnd_api.g_miss_char
963 , p1_a46 VARCHAR2 := fnd_api.g_miss_char
964 , p1_a47 VARCHAR2 := fnd_api.g_miss_char
965 , p1_a48 NUMBER := 0-1962.0724
966 , p1_a49 NUMBER := 0-1962.0724
967 , p1_a50 NUMBER := 0-1962.0724
968 , p1_a51 NUMBER := 0-1962.0724
969 , p1_a52 VARCHAR2 := fnd_api.g_miss_char
970 , p1_a53 NUMBER := 0-1962.0724
971 , p1_a54 VARCHAR2 := fnd_api.g_miss_char
972 , p1_a55 VARCHAR2 := fnd_api.g_miss_char
973 , p1_a56 VARCHAR2 := fnd_api.g_miss_char
974 , p1_a57 VARCHAR2 := fnd_api.g_miss_char
975 , p1_a58 VARCHAR2 := fnd_api.g_miss_char
976 , p1_a59 VARCHAR2 := fnd_api.g_miss_char
977 , p1_a60 VARCHAR2 := fnd_api.g_miss_char
978 , p1_a61 VARCHAR2 := fnd_api.g_miss_char
979 , p1_a62 VARCHAR2 := fnd_api.g_miss_char
980 , p1_a63 VARCHAR2 := fnd_api.g_miss_char
981 , p1_a64 VARCHAR2 := fnd_api.g_miss_char
982 , p1_a65 VARCHAR2 := fnd_api.g_miss_char
983 , p1_a66 VARCHAR2 := fnd_api.g_miss_char
984 , p1_a67 VARCHAR2 := fnd_api.g_miss_char
985 , p1_a68 VARCHAR2 := fnd_api.g_miss_char
986 , p1_a69 VARCHAR2 := fnd_api.g_miss_char
987 , p1_a70 VARCHAR2 := fnd_api.g_miss_char
988 , p1_a71 VARCHAR2 := fnd_api.g_miss_char
989 , p1_a72 VARCHAR2 := fnd_api.g_miss_char
990 , p1_a73 VARCHAR2 := fnd_api.g_miss_char
991 , p1_a74 VARCHAR2 := fnd_api.g_miss_char
992 , p1_a75 NUMBER := 0-1962.0724
993 , p1_a76 NUMBER := 0-1962.0724
994 , p1_a77 VARCHAR2 := fnd_api.g_miss_char
995 , p1_a78 VARCHAR2 := fnd_api.g_miss_char
996 , p1_a79 NUMBER := 0-1962.0724
997 , p1_a80 VARCHAR2 := fnd_api.g_miss_char
998 , p1_a81 VARCHAR2 := fnd_api.g_miss_char
999 )
1000
1001 as
1002 ddp_deliv_rec ams_deliverable_pvt.deliv_rec_type;
1003 ddp_complete_rec ams_deliverable_pvt.deliv_rec_type;
1004 ddindx binary_integer; indx binary_integer;
1005 begin
1006
1007 -- copy data to the local IN or IN-OUT args, if any
1008 ddp_deliv_rec.deliverable_id := rosetta_g_miss_num_map(p0_a0);
1009 ddp_deliv_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1010 ddp_deliv_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1011 ddp_deliv_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1012 ddp_deliv_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1013 ddp_deliv_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1014 ddp_deliv_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1015 ddp_deliv_rec.language_code := p0_a7;
1016 ddp_deliv_rec.version := p0_a8;
1017 ddp_deliv_rec.application_id := rosetta_g_miss_num_map(p0_a9);
1018 ddp_deliv_rec.user_status_id := rosetta_g_miss_num_map(p0_a10);
1019 ddp_deliv_rec.status_code := p0_a11;
1020 ddp_deliv_rec.status_date := rosetta_g_miss_date_in_map(p0_a12);
1021 ddp_deliv_rec.active_flag := p0_a13;
1022 ddp_deliv_rec.private_flag := p0_a14;
1023 ddp_deliv_rec.owner_user_id := rosetta_g_miss_num_map(p0_a15);
1024 ddp_deliv_rec.fund_source_id := rosetta_g_miss_num_map(p0_a16);
1025 ddp_deliv_rec.fund_source_type := p0_a17;
1026 ddp_deliv_rec.category_type_id := rosetta_g_miss_num_map(p0_a18);
1027 ddp_deliv_rec.category_sub_type_id := rosetta_g_miss_num_map(p0_a19);
1028 ddp_deliv_rec.kit_flag := p0_a20;
1029 ddp_deliv_rec.inventory_flag := p0_a21;
1030 ddp_deliv_rec.inventory_item_id := rosetta_g_miss_num_map(p0_a22);
1031 ddp_deliv_rec.inventory_item_org_id := rosetta_g_miss_num_map(p0_a23);
1032 ddp_deliv_rec.pricelist_header_id := rosetta_g_miss_num_map(p0_a24);
1033 ddp_deliv_rec.pricelist_line_id := rosetta_g_miss_num_map(p0_a25);
1034 ddp_deliv_rec.actual_avail_from_date := rosetta_g_miss_date_in_map(p0_a26);
1035 ddp_deliv_rec.actual_avail_to_date := rosetta_g_miss_date_in_map(p0_a27);
1036 ddp_deliv_rec.forecasted_complete_date := rosetta_g_miss_date_in_map(p0_a28);
1037 ddp_deliv_rec.actual_complete_date := rosetta_g_miss_date_in_map(p0_a29);
1038 ddp_deliv_rec.transaction_currency_code := p0_a30;
1039 ddp_deliv_rec.functional_currency_code := p0_a31;
1040 ddp_deliv_rec.budget_amount_tc := rosetta_g_miss_num_map(p0_a32);
1041 ddp_deliv_rec.budget_amount_fc := rosetta_g_miss_num_map(p0_a33);
1045 ddp_deliv_rec.jtf_amv_item_id := rosetta_g_miss_num_map(p0_a37);
1042 ddp_deliv_rec.replaced_by_deliverable_id := rosetta_g_miss_num_map(p0_a34);
1043 ddp_deliv_rec.can_fulfill_electronic_flag := p0_a35;
1044 ddp_deliv_rec.can_fulfill_physical_flag := p0_a36;
1046 ddp_deliv_rec.non_inv_ctrl_code := p0_a38;
1047 ddp_deliv_rec.non_inv_quantity_on_hand := rosetta_g_miss_num_map(p0_a39);
1048 ddp_deliv_rec.non_inv_quantity_on_order := rosetta_g_miss_num_map(p0_a40);
1049 ddp_deliv_rec.non_inv_quantity_on_reserve := rosetta_g_miss_num_map(p0_a41);
1050 ddp_deliv_rec.chargeback_amount := rosetta_g_miss_num_map(p0_a42);
1051 ddp_deliv_rec.chargeback_uom := p0_a43;
1052 ddp_deliv_rec.chargeback_amount_curr_code := p0_a44;
1053 ddp_deliv_rec.deliverable_code := p0_a45;
1054 ddp_deliv_rec.deliverable_pick_flag := p0_a46;
1055 ddp_deliv_rec.currency_code := p0_a47;
1056 ddp_deliv_rec.forecasted_cost := rosetta_g_miss_num_map(p0_a48);
1057 ddp_deliv_rec.actual_cost := rosetta_g_miss_num_map(p0_a49);
1058 ddp_deliv_rec.forecasted_responses := rosetta_g_miss_num_map(p0_a50);
1059 ddp_deliv_rec.actual_responses := rosetta_g_miss_num_map(p0_a51);
1060 ddp_deliv_rec.country := p0_a52;
1061 ddp_deliv_rec.default_approver_id := rosetta_g_miss_num_map(p0_a53);
1062 ddp_deliv_rec.attribute_category := p0_a54;
1063 ddp_deliv_rec.attribute1 := p0_a55;
1064 ddp_deliv_rec.attribute2 := p0_a56;
1065 ddp_deliv_rec.attribute3 := p0_a57;
1066 ddp_deliv_rec.attribute4 := p0_a58;
1067 ddp_deliv_rec.attribute5 := p0_a59;
1068 ddp_deliv_rec.attribute6 := p0_a60;
1069 ddp_deliv_rec.attribute7 := p0_a61;
1070 ddp_deliv_rec.attribute8 := p0_a62;
1071 ddp_deliv_rec.attribute9 := p0_a63;
1072 ddp_deliv_rec.attribute10 := p0_a64;
1073 ddp_deliv_rec.attribute11 := p0_a65;
1074 ddp_deliv_rec.attribute12 := p0_a66;
1075 ddp_deliv_rec.attribute13 := p0_a67;
1076 ddp_deliv_rec.attribute14 := p0_a68;
1077 ddp_deliv_rec.attribute15 := p0_a69;
1078 ddp_deliv_rec.deliverable_name := p0_a70;
1079 ddp_deliv_rec.description := p0_a71;
1080 ddp_deliv_rec.start_period_name := p0_a72;
1081 ddp_deliv_rec.end_period_name := p0_a73;
1082 ddp_deliv_rec.deliverable_calendar := p0_a74;
1083 ddp_deliv_rec.country_id := rosetta_g_miss_num_map(p0_a75);
1084 ddp_deliv_rec.setup_id := rosetta_g_miss_num_map(p0_a76);
1085 ddp_deliv_rec.item_number := p0_a77;
1086 ddp_deliv_rec.associate_flag := p0_a78;
1087 ddp_deliv_rec.master_object_id := rosetta_g_miss_num_map(p0_a79);
1088 ddp_deliv_rec.master_object_type := p0_a80;
1089 ddp_deliv_rec.email_content_type := p0_a81;
1090
1091 ddp_complete_rec.deliverable_id := rosetta_g_miss_num_map(p1_a0);
1092 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
1093 ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
1094 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
1095 ddp_complete_rec.created_by := rosetta_g_miss_num_map(p1_a4);
1096 ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
1097 ddp_complete_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
1098 ddp_complete_rec.language_code := p1_a7;
1099 ddp_complete_rec.version := p1_a8;
1100 ddp_complete_rec.application_id := rosetta_g_miss_num_map(p1_a9);
1101 ddp_complete_rec.user_status_id := rosetta_g_miss_num_map(p1_a10);
1102 ddp_complete_rec.status_code := p1_a11;
1103 ddp_complete_rec.status_date := rosetta_g_miss_date_in_map(p1_a12);
1104 ddp_complete_rec.active_flag := p1_a13;
1105 ddp_complete_rec.private_flag := p1_a14;
1106 ddp_complete_rec.owner_user_id := rosetta_g_miss_num_map(p1_a15);
1107 ddp_complete_rec.fund_source_id := rosetta_g_miss_num_map(p1_a16);
1108 ddp_complete_rec.fund_source_type := p1_a17;
1109 ddp_complete_rec.category_type_id := rosetta_g_miss_num_map(p1_a18);
1110 ddp_complete_rec.category_sub_type_id := rosetta_g_miss_num_map(p1_a19);
1111 ddp_complete_rec.kit_flag := p1_a20;
1112 ddp_complete_rec.inventory_flag := p1_a21;
1113 ddp_complete_rec.inventory_item_id := rosetta_g_miss_num_map(p1_a22);
1114 ddp_complete_rec.inventory_item_org_id := rosetta_g_miss_num_map(p1_a23);
1115 ddp_complete_rec.pricelist_header_id := rosetta_g_miss_num_map(p1_a24);
1116 ddp_complete_rec.pricelist_line_id := rosetta_g_miss_num_map(p1_a25);
1117 ddp_complete_rec.actual_avail_from_date := rosetta_g_miss_date_in_map(p1_a26);
1118 ddp_complete_rec.actual_avail_to_date := rosetta_g_miss_date_in_map(p1_a27);
1119 ddp_complete_rec.forecasted_complete_date := rosetta_g_miss_date_in_map(p1_a28);
1120 ddp_complete_rec.actual_complete_date := rosetta_g_miss_date_in_map(p1_a29);
1121 ddp_complete_rec.transaction_currency_code := p1_a30;
1122 ddp_complete_rec.functional_currency_code := p1_a31;
1123 ddp_complete_rec.budget_amount_tc := rosetta_g_miss_num_map(p1_a32);
1124 ddp_complete_rec.budget_amount_fc := rosetta_g_miss_num_map(p1_a33);
1125 ddp_complete_rec.replaced_by_deliverable_id := rosetta_g_miss_num_map(p1_a34);
1126 ddp_complete_rec.can_fulfill_electronic_flag := p1_a35;
1127 ddp_complete_rec.can_fulfill_physical_flag := p1_a36;
1128 ddp_complete_rec.jtf_amv_item_id := rosetta_g_miss_num_map(p1_a37);
1129 ddp_complete_rec.non_inv_ctrl_code := p1_a38;
1130 ddp_complete_rec.non_inv_quantity_on_hand := rosetta_g_miss_num_map(p1_a39);
1131 ddp_complete_rec.non_inv_quantity_on_order := rosetta_g_miss_num_map(p1_a40);
1132 ddp_complete_rec.non_inv_quantity_on_reserve := rosetta_g_miss_num_map(p1_a41);
1133 ddp_complete_rec.chargeback_amount := rosetta_g_miss_num_map(p1_a42);
1137 ddp_complete_rec.deliverable_pick_flag := p1_a46;
1134 ddp_complete_rec.chargeback_uom := p1_a43;
1135 ddp_complete_rec.chargeback_amount_curr_code := p1_a44;
1136 ddp_complete_rec.deliverable_code := p1_a45;
1138 ddp_complete_rec.currency_code := p1_a47;
1139 ddp_complete_rec.forecasted_cost := rosetta_g_miss_num_map(p1_a48);
1140 ddp_complete_rec.actual_cost := rosetta_g_miss_num_map(p1_a49);
1141 ddp_complete_rec.forecasted_responses := rosetta_g_miss_num_map(p1_a50);
1142 ddp_complete_rec.actual_responses := rosetta_g_miss_num_map(p1_a51);
1143 ddp_complete_rec.country := p1_a52;
1144 ddp_complete_rec.default_approver_id := rosetta_g_miss_num_map(p1_a53);
1145 ddp_complete_rec.attribute_category := p1_a54;
1146 ddp_complete_rec.attribute1 := p1_a55;
1147 ddp_complete_rec.attribute2 := p1_a56;
1148 ddp_complete_rec.attribute3 := p1_a57;
1149 ddp_complete_rec.attribute4 := p1_a58;
1150 ddp_complete_rec.attribute5 := p1_a59;
1151 ddp_complete_rec.attribute6 := p1_a60;
1152 ddp_complete_rec.attribute7 := p1_a61;
1153 ddp_complete_rec.attribute8 := p1_a62;
1154 ddp_complete_rec.attribute9 := p1_a63;
1155 ddp_complete_rec.attribute10 := p1_a64;
1156 ddp_complete_rec.attribute11 := p1_a65;
1157 ddp_complete_rec.attribute12 := p1_a66;
1158 ddp_complete_rec.attribute13 := p1_a67;
1159 ddp_complete_rec.attribute14 := p1_a68;
1160 ddp_complete_rec.attribute15 := p1_a69;
1161 ddp_complete_rec.deliverable_name := p1_a70;
1162 ddp_complete_rec.description := p1_a71;
1163 ddp_complete_rec.start_period_name := p1_a72;
1164 ddp_complete_rec.end_period_name := p1_a73;
1165 ddp_complete_rec.deliverable_calendar := p1_a74;
1166 ddp_complete_rec.country_id := rosetta_g_miss_num_map(p1_a75);
1167 ddp_complete_rec.setup_id := rosetta_g_miss_num_map(p1_a76);
1168 ddp_complete_rec.item_number := p1_a77;
1169 ddp_complete_rec.associate_flag := p1_a78;
1170 ddp_complete_rec.master_object_id := rosetta_g_miss_num_map(p1_a79);
1171 ddp_complete_rec.master_object_type := p1_a80;
1172 ddp_complete_rec.email_content_type := p1_a81;
1173
1174
1175 -- here's the delegated call to the old PL/SQL routine
1176 ams_deliverable_pvt.check_deliv_record(ddp_deliv_rec,
1177 ddp_complete_rec,
1178 x_return_status);
1179
1180 -- copy data back from the local variables to OUT or IN-OUT args, if any
1181
1182
1183 end;
1184
1185 procedure init_deliv_rec(p0_a0 out nocopy NUMBER
1186 , p0_a1 out nocopy DATE
1187 , p0_a2 out nocopy NUMBER
1188 , p0_a3 out nocopy DATE
1189 , p0_a4 out nocopy NUMBER
1190 , p0_a5 out nocopy NUMBER
1191 , p0_a6 out nocopy NUMBER
1192 , p0_a7 out nocopy VARCHAR2
1193 , p0_a8 out nocopy VARCHAR2
1194 , p0_a9 out nocopy NUMBER
1195 , p0_a10 out nocopy NUMBER
1196 , p0_a11 out nocopy VARCHAR2
1197 , p0_a12 out nocopy DATE
1198 , p0_a13 out nocopy VARCHAR2
1199 , p0_a14 out nocopy VARCHAR2
1200 , p0_a15 out nocopy NUMBER
1201 , p0_a16 out nocopy NUMBER
1202 , p0_a17 out nocopy VARCHAR2
1203 , p0_a18 out nocopy NUMBER
1204 , p0_a19 out nocopy NUMBER
1205 , p0_a20 out nocopy VARCHAR2
1206 , p0_a21 out nocopy VARCHAR2
1207 , p0_a22 out nocopy NUMBER
1208 , p0_a23 out nocopy NUMBER
1209 , p0_a24 out nocopy NUMBER
1210 , p0_a25 out nocopy NUMBER
1211 , p0_a26 out nocopy DATE
1212 , p0_a27 out nocopy DATE
1213 , p0_a28 out nocopy DATE
1214 , p0_a29 out nocopy DATE
1215 , p0_a30 out nocopy VARCHAR2
1216 , p0_a31 out nocopy VARCHAR2
1217 , p0_a32 out nocopy NUMBER
1218 , p0_a33 out nocopy NUMBER
1219 , p0_a34 out nocopy NUMBER
1220 , p0_a35 out nocopy VARCHAR2
1221 , p0_a36 out nocopy VARCHAR2
1222 , p0_a37 out nocopy NUMBER
1223 , p0_a38 out nocopy VARCHAR2
1224 , p0_a39 out nocopy NUMBER
1225 , p0_a40 out nocopy NUMBER
1226 , p0_a41 out nocopy NUMBER
1227 , p0_a42 out nocopy NUMBER
1228 , p0_a43 out nocopy VARCHAR2
1229 , p0_a44 out nocopy VARCHAR2
1230 , p0_a45 out nocopy VARCHAR2
1231 , p0_a46 out nocopy VARCHAR2
1232 , p0_a47 out nocopy VARCHAR2
1233 , p0_a48 out nocopy NUMBER
1234 , p0_a49 out nocopy NUMBER
1235 , p0_a50 out nocopy NUMBER
1236 , p0_a51 out nocopy NUMBER
1237 , p0_a52 out nocopy VARCHAR2
1238 , p0_a53 out nocopy NUMBER
1239 , p0_a54 out nocopy VARCHAR2
1240 , p0_a55 out nocopy VARCHAR2
1241 , p0_a56 out nocopy VARCHAR2
1242 , p0_a57 out nocopy VARCHAR2
1243 , p0_a58 out nocopy VARCHAR2
1244 , p0_a59 out nocopy VARCHAR2
1245 , p0_a60 out nocopy VARCHAR2
1246 , p0_a61 out nocopy VARCHAR2
1247 , p0_a62 out nocopy VARCHAR2
1248 , p0_a63 out nocopy VARCHAR2
1249 , p0_a64 out nocopy VARCHAR2
1250 , p0_a65 out nocopy VARCHAR2
1251 , p0_a66 out nocopy VARCHAR2
1252 , p0_a67 out nocopy VARCHAR2
1253 , p0_a68 out nocopy VARCHAR2
1254 , p0_a69 out nocopy VARCHAR2
1255 , p0_a70 out nocopy VARCHAR2
1256 , p0_a71 out nocopy VARCHAR2
1257 , p0_a72 out nocopy VARCHAR2
1258 , p0_a73 out nocopy VARCHAR2
1259 , p0_a74 out nocopy VARCHAR2
1260 , p0_a75 out nocopy NUMBER
1261 , p0_a76 out nocopy NUMBER
1262 , p0_a77 out nocopy VARCHAR2
1263 , p0_a78 out nocopy VARCHAR2
1267 )
1264 , p0_a79 out nocopy NUMBER
1265 , p0_a80 out nocopy VARCHAR2
1266 , p0_a81 out nocopy VARCHAR2
1268
1269 as
1270 ddx_deliv_rec ams_deliverable_pvt.deliv_rec_type;
1271 ddindx binary_integer; indx binary_integer;
1272 begin
1273
1274 -- copy data to the local IN or IN-OUT args, if any
1275
1276 -- here's the delegated call to the old PL/SQL routine
1277 ams_deliverable_pvt.init_deliv_rec(ddx_deliv_rec);
1278
1279 -- copy data back from the local variables to OUT or IN-OUT args, if any
1280 p0_a0 := rosetta_g_miss_num_map(ddx_deliv_rec.deliverable_id);
1281 p0_a1 := ddx_deliv_rec.last_update_date;
1282 p0_a2 := rosetta_g_miss_num_map(ddx_deliv_rec.last_updated_by);
1283 p0_a3 := ddx_deliv_rec.creation_date;
1284 p0_a4 := rosetta_g_miss_num_map(ddx_deliv_rec.created_by);
1285 p0_a5 := rosetta_g_miss_num_map(ddx_deliv_rec.last_update_login);
1286 p0_a6 := rosetta_g_miss_num_map(ddx_deliv_rec.object_version_number);
1287 p0_a7 := ddx_deliv_rec.language_code;
1288 p0_a8 := ddx_deliv_rec.version;
1289 p0_a9 := rosetta_g_miss_num_map(ddx_deliv_rec.application_id);
1290 p0_a10 := rosetta_g_miss_num_map(ddx_deliv_rec.user_status_id);
1291 p0_a11 := ddx_deliv_rec.status_code;
1292 p0_a12 := ddx_deliv_rec.status_date;
1293 p0_a13 := ddx_deliv_rec.active_flag;
1294 p0_a14 := ddx_deliv_rec.private_flag;
1295 p0_a15 := rosetta_g_miss_num_map(ddx_deliv_rec.owner_user_id);
1296 p0_a16 := rosetta_g_miss_num_map(ddx_deliv_rec.fund_source_id);
1297 p0_a17 := ddx_deliv_rec.fund_source_type;
1298 p0_a18 := rosetta_g_miss_num_map(ddx_deliv_rec.category_type_id);
1299 p0_a19 := rosetta_g_miss_num_map(ddx_deliv_rec.category_sub_type_id);
1300 p0_a20 := ddx_deliv_rec.kit_flag;
1301 p0_a21 := ddx_deliv_rec.inventory_flag;
1302 p0_a22 := rosetta_g_miss_num_map(ddx_deliv_rec.inventory_item_id);
1303 p0_a23 := rosetta_g_miss_num_map(ddx_deliv_rec.inventory_item_org_id);
1304 p0_a24 := rosetta_g_miss_num_map(ddx_deliv_rec.pricelist_header_id);
1305 p0_a25 := rosetta_g_miss_num_map(ddx_deliv_rec.pricelist_line_id);
1306 p0_a26 := ddx_deliv_rec.actual_avail_from_date;
1307 p0_a27 := ddx_deliv_rec.actual_avail_to_date;
1308 p0_a28 := ddx_deliv_rec.forecasted_complete_date;
1309 p0_a29 := ddx_deliv_rec.actual_complete_date;
1310 p0_a30 := ddx_deliv_rec.transaction_currency_code;
1311 p0_a31 := ddx_deliv_rec.functional_currency_code;
1312 p0_a32 := rosetta_g_miss_num_map(ddx_deliv_rec.budget_amount_tc);
1313 p0_a33 := rosetta_g_miss_num_map(ddx_deliv_rec.budget_amount_fc);
1314 p0_a34 := rosetta_g_miss_num_map(ddx_deliv_rec.replaced_by_deliverable_id);
1315 p0_a35 := ddx_deliv_rec.can_fulfill_electronic_flag;
1316 p0_a36 := ddx_deliv_rec.can_fulfill_physical_flag;
1317 p0_a37 := rosetta_g_miss_num_map(ddx_deliv_rec.jtf_amv_item_id);
1318 p0_a38 := ddx_deliv_rec.non_inv_ctrl_code;
1319 p0_a39 := rosetta_g_miss_num_map(ddx_deliv_rec.non_inv_quantity_on_hand);
1320 p0_a40 := rosetta_g_miss_num_map(ddx_deliv_rec.non_inv_quantity_on_order);
1321 p0_a41 := rosetta_g_miss_num_map(ddx_deliv_rec.non_inv_quantity_on_reserve);
1322 p0_a42 := rosetta_g_miss_num_map(ddx_deliv_rec.chargeback_amount);
1323 p0_a43 := ddx_deliv_rec.chargeback_uom;
1324 p0_a44 := ddx_deliv_rec.chargeback_amount_curr_code;
1325 p0_a45 := ddx_deliv_rec.deliverable_code;
1326 p0_a46 := ddx_deliv_rec.deliverable_pick_flag;
1327 p0_a47 := ddx_deliv_rec.currency_code;
1328 p0_a48 := rosetta_g_miss_num_map(ddx_deliv_rec.forecasted_cost);
1329 p0_a49 := rosetta_g_miss_num_map(ddx_deliv_rec.actual_cost);
1330 p0_a50 := rosetta_g_miss_num_map(ddx_deliv_rec.forecasted_responses);
1331 p0_a51 := rosetta_g_miss_num_map(ddx_deliv_rec.actual_responses);
1332 p0_a52 := ddx_deliv_rec.country;
1333 p0_a53 := rosetta_g_miss_num_map(ddx_deliv_rec.default_approver_id);
1334 p0_a54 := ddx_deliv_rec.attribute_category;
1335 p0_a55 := ddx_deliv_rec.attribute1;
1336 p0_a56 := ddx_deliv_rec.attribute2;
1337 p0_a57 := ddx_deliv_rec.attribute3;
1338 p0_a58 := ddx_deliv_rec.attribute4;
1339 p0_a59 := ddx_deliv_rec.attribute5;
1340 p0_a60 := ddx_deliv_rec.attribute6;
1341 p0_a61 := ddx_deliv_rec.attribute7;
1342 p0_a62 := ddx_deliv_rec.attribute8;
1343 p0_a63 := ddx_deliv_rec.attribute9;
1344 p0_a64 := ddx_deliv_rec.attribute10;
1345 p0_a65 := ddx_deliv_rec.attribute11;
1346 p0_a66 := ddx_deliv_rec.attribute12;
1347 p0_a67 := ddx_deliv_rec.attribute13;
1348 p0_a68 := ddx_deliv_rec.attribute14;
1349 p0_a69 := ddx_deliv_rec.attribute15;
1350 p0_a70 := ddx_deliv_rec.deliverable_name;
1351 p0_a71 := ddx_deliv_rec.description;
1352 p0_a72 := ddx_deliv_rec.start_period_name;
1353 p0_a73 := ddx_deliv_rec.end_period_name;
1354 p0_a74 := ddx_deliv_rec.deliverable_calendar;
1355 p0_a75 := rosetta_g_miss_num_map(ddx_deliv_rec.country_id);
1356 p0_a76 := rosetta_g_miss_num_map(ddx_deliv_rec.setup_id);
1357 p0_a77 := ddx_deliv_rec.item_number;
1358 p0_a78 := ddx_deliv_rec.associate_flag;
1359 p0_a79 := rosetta_g_miss_num_map(ddx_deliv_rec.master_object_id);
1360 p0_a80 := ddx_deliv_rec.master_object_type;
1361 p0_a81 := ddx_deliv_rec.email_content_type;
1362 end;
1363
1364 procedure complete_deliv_rec(p1_a0 out nocopy NUMBER
1365 , p1_a1 out nocopy DATE
1366 , p1_a2 out nocopy NUMBER
1367 , p1_a3 out nocopy DATE
1368 , p1_a4 out nocopy NUMBER
1369 , p1_a5 out nocopy NUMBER
1370 , p1_a6 out nocopy NUMBER
1374 , p1_a10 out nocopy NUMBER
1371 , p1_a7 out nocopy VARCHAR2
1372 , p1_a8 out nocopy VARCHAR2
1373 , p1_a9 out nocopy NUMBER
1375 , p1_a11 out nocopy VARCHAR2
1376 , p1_a12 out nocopy DATE
1377 , p1_a13 out nocopy VARCHAR2
1378 , p1_a14 out nocopy VARCHAR2
1379 , p1_a15 out nocopy NUMBER
1380 , p1_a16 out nocopy NUMBER
1381 , p1_a17 out nocopy VARCHAR2
1382 , p1_a18 out nocopy NUMBER
1383 , p1_a19 out nocopy NUMBER
1384 , p1_a20 out nocopy VARCHAR2
1385 , p1_a21 out nocopy VARCHAR2
1386 , p1_a22 out nocopy NUMBER
1387 , p1_a23 out nocopy NUMBER
1388 , p1_a24 out nocopy NUMBER
1389 , p1_a25 out nocopy NUMBER
1390 , p1_a26 out nocopy DATE
1391 , p1_a27 out nocopy DATE
1392 , p1_a28 out nocopy DATE
1393 , p1_a29 out nocopy DATE
1394 , p1_a30 out nocopy VARCHAR2
1395 , p1_a31 out nocopy VARCHAR2
1396 , p1_a32 out nocopy NUMBER
1397 , p1_a33 out nocopy NUMBER
1398 , p1_a34 out nocopy NUMBER
1399 , p1_a35 out nocopy VARCHAR2
1400 , p1_a36 out nocopy VARCHAR2
1401 , p1_a37 out nocopy NUMBER
1402 , p1_a38 out nocopy VARCHAR2
1403 , p1_a39 out nocopy NUMBER
1404 , p1_a40 out nocopy NUMBER
1405 , p1_a41 out nocopy NUMBER
1406 , p1_a42 out nocopy NUMBER
1407 , p1_a43 out nocopy VARCHAR2
1408 , p1_a44 out nocopy VARCHAR2
1409 , p1_a45 out nocopy VARCHAR2
1410 , p1_a46 out nocopy VARCHAR2
1411 , p1_a47 out nocopy VARCHAR2
1412 , p1_a48 out nocopy NUMBER
1413 , p1_a49 out nocopy NUMBER
1414 , p1_a50 out nocopy NUMBER
1415 , p1_a51 out nocopy NUMBER
1416 , p1_a52 out nocopy VARCHAR2
1417 , p1_a53 out nocopy NUMBER
1418 , p1_a54 out nocopy VARCHAR2
1419 , p1_a55 out nocopy VARCHAR2
1420 , p1_a56 out nocopy VARCHAR2
1421 , p1_a57 out nocopy VARCHAR2
1422 , p1_a58 out nocopy VARCHAR2
1423 , p1_a59 out nocopy VARCHAR2
1424 , p1_a60 out nocopy VARCHAR2
1425 , p1_a61 out nocopy VARCHAR2
1426 , p1_a62 out nocopy VARCHAR2
1427 , p1_a63 out nocopy VARCHAR2
1428 , p1_a64 out nocopy VARCHAR2
1429 , p1_a65 out nocopy VARCHAR2
1430 , p1_a66 out nocopy VARCHAR2
1431 , p1_a67 out nocopy VARCHAR2
1432 , p1_a68 out nocopy VARCHAR2
1433 , p1_a69 out nocopy VARCHAR2
1434 , p1_a70 out nocopy VARCHAR2
1435 , p1_a71 out nocopy VARCHAR2
1436 , p1_a72 out nocopy VARCHAR2
1437 , p1_a73 out nocopy VARCHAR2
1438 , p1_a74 out nocopy VARCHAR2
1439 , p1_a75 out nocopy NUMBER
1440 , p1_a76 out nocopy NUMBER
1441 , p1_a77 out nocopy VARCHAR2
1442 , p1_a78 out nocopy VARCHAR2
1443 , p1_a79 out nocopy NUMBER
1444 , p1_a80 out nocopy VARCHAR2
1445 , p1_a81 out nocopy VARCHAR2
1446 , p0_a0 NUMBER := 0-1962.0724
1447 , p0_a1 DATE := fnd_api.g_miss_date
1448 , p0_a2 NUMBER := 0-1962.0724
1449 , p0_a3 DATE := fnd_api.g_miss_date
1450 , p0_a4 NUMBER := 0-1962.0724
1451 , p0_a5 NUMBER := 0-1962.0724
1452 , p0_a6 NUMBER := 0-1962.0724
1453 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
1454 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
1455 , p0_a9 NUMBER := 0-1962.0724
1456 , p0_a10 NUMBER := 0-1962.0724
1457 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
1458 , p0_a12 DATE := fnd_api.g_miss_date
1459 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1460 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1461 , p0_a15 NUMBER := 0-1962.0724
1462 , p0_a16 NUMBER := 0-1962.0724
1463 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1464 , p0_a18 NUMBER := 0-1962.0724
1465 , p0_a19 NUMBER := 0-1962.0724
1466 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1467 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1468 , p0_a22 NUMBER := 0-1962.0724
1469 , p0_a23 NUMBER := 0-1962.0724
1470 , p0_a24 NUMBER := 0-1962.0724
1471 , p0_a25 NUMBER := 0-1962.0724
1472 , p0_a26 DATE := fnd_api.g_miss_date
1473 , p0_a27 DATE := fnd_api.g_miss_date
1474 , p0_a28 DATE := fnd_api.g_miss_date
1475 , p0_a29 DATE := fnd_api.g_miss_date
1476 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
1477 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
1478 , p0_a32 NUMBER := 0-1962.0724
1479 , p0_a33 NUMBER := 0-1962.0724
1480 , p0_a34 NUMBER := 0-1962.0724
1481 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
1482 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
1483 , p0_a37 NUMBER := 0-1962.0724
1484 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1485 , p0_a39 NUMBER := 0-1962.0724
1486 , p0_a40 NUMBER := 0-1962.0724
1487 , p0_a41 NUMBER := 0-1962.0724
1488 , p0_a42 NUMBER := 0-1962.0724
1489 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1490 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1491 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1492 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1493 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1494 , p0_a48 NUMBER := 0-1962.0724
1495 , p0_a49 NUMBER := 0-1962.0724
1496 , p0_a50 NUMBER := 0-1962.0724
1497 , p0_a51 NUMBER := 0-1962.0724
1498 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1499 , p0_a53 NUMBER := 0-1962.0724
1500 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1501 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1502 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1506 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
1503 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
1504 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
1505 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
1507 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
1508 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
1509 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
1510 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
1511 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
1512 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
1513 , p0_a67 VARCHAR2 := fnd_api.g_miss_char
1514 , p0_a68 VARCHAR2 := fnd_api.g_miss_char
1515 , p0_a69 VARCHAR2 := fnd_api.g_miss_char
1516 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
1517 , p0_a71 VARCHAR2 := fnd_api.g_miss_char
1518 , p0_a72 VARCHAR2 := fnd_api.g_miss_char
1519 , p0_a73 VARCHAR2 := fnd_api.g_miss_char
1520 , p0_a74 VARCHAR2 := fnd_api.g_miss_char
1521 , p0_a75 NUMBER := 0-1962.0724
1522 , p0_a76 NUMBER := 0-1962.0724
1523 , p0_a77 VARCHAR2 := fnd_api.g_miss_char
1524 , p0_a78 VARCHAR2 := fnd_api.g_miss_char
1525 , p0_a79 NUMBER := 0-1962.0724
1526 , p0_a80 VARCHAR2 := fnd_api.g_miss_char
1527 , p0_a81 VARCHAR2 := fnd_api.g_miss_char
1528 )
1529
1530 as
1531 ddp_deliv_rec ams_deliverable_pvt.deliv_rec_type;
1532 ddx_complete_rec ams_deliverable_pvt.deliv_rec_type;
1533 ddindx binary_integer; indx binary_integer;
1534 begin
1535
1536 -- copy data to the local IN or IN-OUT args, if any
1537 ddp_deliv_rec.deliverable_id := rosetta_g_miss_num_map(p0_a0);
1538 ddp_deliv_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1539 ddp_deliv_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1540 ddp_deliv_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1541 ddp_deliv_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1542 ddp_deliv_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1543 ddp_deliv_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1544 ddp_deliv_rec.language_code := p0_a7;
1545 ddp_deliv_rec.version := p0_a8;
1546 ddp_deliv_rec.application_id := rosetta_g_miss_num_map(p0_a9);
1547 ddp_deliv_rec.user_status_id := rosetta_g_miss_num_map(p0_a10);
1548 ddp_deliv_rec.status_code := p0_a11;
1549 ddp_deliv_rec.status_date := rosetta_g_miss_date_in_map(p0_a12);
1550 ddp_deliv_rec.active_flag := p0_a13;
1551 ddp_deliv_rec.private_flag := p0_a14;
1552 ddp_deliv_rec.owner_user_id := rosetta_g_miss_num_map(p0_a15);
1553 ddp_deliv_rec.fund_source_id := rosetta_g_miss_num_map(p0_a16);
1554 ddp_deliv_rec.fund_source_type := p0_a17;
1555 ddp_deliv_rec.category_type_id := rosetta_g_miss_num_map(p0_a18);
1556 ddp_deliv_rec.category_sub_type_id := rosetta_g_miss_num_map(p0_a19);
1557 ddp_deliv_rec.kit_flag := p0_a20;
1558 ddp_deliv_rec.inventory_flag := p0_a21;
1559 ddp_deliv_rec.inventory_item_id := rosetta_g_miss_num_map(p0_a22);
1560 ddp_deliv_rec.inventory_item_org_id := rosetta_g_miss_num_map(p0_a23);
1561 ddp_deliv_rec.pricelist_header_id := rosetta_g_miss_num_map(p0_a24);
1562 ddp_deliv_rec.pricelist_line_id := rosetta_g_miss_num_map(p0_a25);
1563 ddp_deliv_rec.actual_avail_from_date := rosetta_g_miss_date_in_map(p0_a26);
1564 ddp_deliv_rec.actual_avail_to_date := rosetta_g_miss_date_in_map(p0_a27);
1565 ddp_deliv_rec.forecasted_complete_date := rosetta_g_miss_date_in_map(p0_a28);
1566 ddp_deliv_rec.actual_complete_date := rosetta_g_miss_date_in_map(p0_a29);
1567 ddp_deliv_rec.transaction_currency_code := p0_a30;
1568 ddp_deliv_rec.functional_currency_code := p0_a31;
1569 ddp_deliv_rec.budget_amount_tc := rosetta_g_miss_num_map(p0_a32);
1570 ddp_deliv_rec.budget_amount_fc := rosetta_g_miss_num_map(p0_a33);
1571 ddp_deliv_rec.replaced_by_deliverable_id := rosetta_g_miss_num_map(p0_a34);
1572 ddp_deliv_rec.can_fulfill_electronic_flag := p0_a35;
1573 ddp_deliv_rec.can_fulfill_physical_flag := p0_a36;
1574 ddp_deliv_rec.jtf_amv_item_id := rosetta_g_miss_num_map(p0_a37);
1575 ddp_deliv_rec.non_inv_ctrl_code := p0_a38;
1576 ddp_deliv_rec.non_inv_quantity_on_hand := rosetta_g_miss_num_map(p0_a39);
1577 ddp_deliv_rec.non_inv_quantity_on_order := rosetta_g_miss_num_map(p0_a40);
1578 ddp_deliv_rec.non_inv_quantity_on_reserve := rosetta_g_miss_num_map(p0_a41);
1579 ddp_deliv_rec.chargeback_amount := rosetta_g_miss_num_map(p0_a42);
1580 ddp_deliv_rec.chargeback_uom := p0_a43;
1581 ddp_deliv_rec.chargeback_amount_curr_code := p0_a44;
1582 ddp_deliv_rec.deliverable_code := p0_a45;
1583 ddp_deliv_rec.deliverable_pick_flag := p0_a46;
1584 ddp_deliv_rec.currency_code := p0_a47;
1585 ddp_deliv_rec.forecasted_cost := rosetta_g_miss_num_map(p0_a48);
1586 ddp_deliv_rec.actual_cost := rosetta_g_miss_num_map(p0_a49);
1587 ddp_deliv_rec.forecasted_responses := rosetta_g_miss_num_map(p0_a50);
1588 ddp_deliv_rec.actual_responses := rosetta_g_miss_num_map(p0_a51);
1589 ddp_deliv_rec.country := p0_a52;
1590 ddp_deliv_rec.default_approver_id := rosetta_g_miss_num_map(p0_a53);
1591 ddp_deliv_rec.attribute_category := p0_a54;
1592 ddp_deliv_rec.attribute1 := p0_a55;
1593 ddp_deliv_rec.attribute2 := p0_a56;
1594 ddp_deliv_rec.attribute3 := p0_a57;
1595 ddp_deliv_rec.attribute4 := p0_a58;
1596 ddp_deliv_rec.attribute5 := p0_a59;
1597 ddp_deliv_rec.attribute6 := p0_a60;
1598 ddp_deliv_rec.attribute7 := p0_a61;
1599 ddp_deliv_rec.attribute8 := p0_a62;
1600 ddp_deliv_rec.attribute9 := p0_a63;
1601 ddp_deliv_rec.attribute10 := p0_a64;
1602 ddp_deliv_rec.attribute11 := p0_a65;
1603 ddp_deliv_rec.attribute12 := p0_a66;
1607 ddp_deliv_rec.deliverable_name := p0_a70;
1604 ddp_deliv_rec.attribute13 := p0_a67;
1605 ddp_deliv_rec.attribute14 := p0_a68;
1606 ddp_deliv_rec.attribute15 := p0_a69;
1608 ddp_deliv_rec.description := p0_a71;
1609 ddp_deliv_rec.start_period_name := p0_a72;
1610 ddp_deliv_rec.end_period_name := p0_a73;
1611 ddp_deliv_rec.deliverable_calendar := p0_a74;
1612 ddp_deliv_rec.country_id := rosetta_g_miss_num_map(p0_a75);
1613 ddp_deliv_rec.setup_id := rosetta_g_miss_num_map(p0_a76);
1614 ddp_deliv_rec.item_number := p0_a77;
1615 ddp_deliv_rec.associate_flag := p0_a78;
1616 ddp_deliv_rec.master_object_id := rosetta_g_miss_num_map(p0_a79);
1617 ddp_deliv_rec.master_object_type := p0_a80;
1618 ddp_deliv_rec.email_content_type := p0_a81;
1619
1620
1621 -- here's the delegated call to the old PL/SQL routine
1622 ams_deliverable_pvt.complete_deliv_rec(ddp_deliv_rec,
1623 ddx_complete_rec);
1624
1625 -- copy data back from the local variables to OUT or IN-OUT args, if any
1626
1627 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.deliverable_id);
1628 p1_a1 := ddx_complete_rec.last_update_date;
1629 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
1630 p1_a3 := ddx_complete_rec.creation_date;
1631 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
1632 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
1633 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
1634 p1_a7 := ddx_complete_rec.language_code;
1635 p1_a8 := ddx_complete_rec.version;
1636 p1_a9 := rosetta_g_miss_num_map(ddx_complete_rec.application_id);
1637 p1_a10 := rosetta_g_miss_num_map(ddx_complete_rec.user_status_id);
1638 p1_a11 := ddx_complete_rec.status_code;
1639 p1_a12 := ddx_complete_rec.status_date;
1640 p1_a13 := ddx_complete_rec.active_flag;
1641 p1_a14 := ddx_complete_rec.private_flag;
1642 p1_a15 := rosetta_g_miss_num_map(ddx_complete_rec.owner_user_id);
1643 p1_a16 := rosetta_g_miss_num_map(ddx_complete_rec.fund_source_id);
1644 p1_a17 := ddx_complete_rec.fund_source_type;
1645 p1_a18 := rosetta_g_miss_num_map(ddx_complete_rec.category_type_id);
1646 p1_a19 := rosetta_g_miss_num_map(ddx_complete_rec.category_sub_type_id);
1647 p1_a20 := ddx_complete_rec.kit_flag;
1648 p1_a21 := ddx_complete_rec.inventory_flag;
1649 p1_a22 := rosetta_g_miss_num_map(ddx_complete_rec.inventory_item_id);
1650 p1_a23 := rosetta_g_miss_num_map(ddx_complete_rec.inventory_item_org_id);
1651 p1_a24 := rosetta_g_miss_num_map(ddx_complete_rec.pricelist_header_id);
1652 p1_a25 := rosetta_g_miss_num_map(ddx_complete_rec.pricelist_line_id);
1653 p1_a26 := ddx_complete_rec.actual_avail_from_date;
1654 p1_a27 := ddx_complete_rec.actual_avail_to_date;
1655 p1_a28 := ddx_complete_rec.forecasted_complete_date;
1656 p1_a29 := ddx_complete_rec.actual_complete_date;
1657 p1_a30 := ddx_complete_rec.transaction_currency_code;
1658 p1_a31 := ddx_complete_rec.functional_currency_code;
1659 p1_a32 := rosetta_g_miss_num_map(ddx_complete_rec.budget_amount_tc);
1660 p1_a33 := rosetta_g_miss_num_map(ddx_complete_rec.budget_amount_fc);
1661 p1_a34 := rosetta_g_miss_num_map(ddx_complete_rec.replaced_by_deliverable_id);
1662 p1_a35 := ddx_complete_rec.can_fulfill_electronic_flag;
1663 p1_a36 := ddx_complete_rec.can_fulfill_physical_flag;
1664 p1_a37 := rosetta_g_miss_num_map(ddx_complete_rec.jtf_amv_item_id);
1665 p1_a38 := ddx_complete_rec.non_inv_ctrl_code;
1666 p1_a39 := rosetta_g_miss_num_map(ddx_complete_rec.non_inv_quantity_on_hand);
1667 p1_a40 := rosetta_g_miss_num_map(ddx_complete_rec.non_inv_quantity_on_order);
1668 p1_a41 := rosetta_g_miss_num_map(ddx_complete_rec.non_inv_quantity_on_reserve);
1669 p1_a42 := rosetta_g_miss_num_map(ddx_complete_rec.chargeback_amount);
1670 p1_a43 := ddx_complete_rec.chargeback_uom;
1671 p1_a44 := ddx_complete_rec.chargeback_amount_curr_code;
1672 p1_a45 := ddx_complete_rec.deliverable_code;
1673 p1_a46 := ddx_complete_rec.deliverable_pick_flag;
1674 p1_a47 := ddx_complete_rec.currency_code;
1675 p1_a48 := rosetta_g_miss_num_map(ddx_complete_rec.forecasted_cost);
1676 p1_a49 := rosetta_g_miss_num_map(ddx_complete_rec.actual_cost);
1677 p1_a50 := rosetta_g_miss_num_map(ddx_complete_rec.forecasted_responses);
1678 p1_a51 := rosetta_g_miss_num_map(ddx_complete_rec.actual_responses);
1679 p1_a52 := ddx_complete_rec.country;
1680 p1_a53 := rosetta_g_miss_num_map(ddx_complete_rec.default_approver_id);
1681 p1_a54 := ddx_complete_rec.attribute_category;
1682 p1_a55 := ddx_complete_rec.attribute1;
1683 p1_a56 := ddx_complete_rec.attribute2;
1684 p1_a57 := ddx_complete_rec.attribute3;
1685 p1_a58 := ddx_complete_rec.attribute4;
1686 p1_a59 := ddx_complete_rec.attribute5;
1687 p1_a60 := ddx_complete_rec.attribute6;
1688 p1_a61 := ddx_complete_rec.attribute7;
1689 p1_a62 := ddx_complete_rec.attribute8;
1690 p1_a63 := ddx_complete_rec.attribute9;
1691 p1_a64 := ddx_complete_rec.attribute10;
1692 p1_a65 := ddx_complete_rec.attribute11;
1693 p1_a66 := ddx_complete_rec.attribute12;
1694 p1_a67 := ddx_complete_rec.attribute13;
1695 p1_a68 := ddx_complete_rec.attribute14;
1696 p1_a69 := ddx_complete_rec.attribute15;
1697 p1_a70 := ddx_complete_rec.deliverable_name;
1698 p1_a71 := ddx_complete_rec.description;
1699 p1_a72 := ddx_complete_rec.start_period_name;
1700 p1_a73 := ddx_complete_rec.end_period_name;
1701 p1_a74 := ddx_complete_rec.deliverable_calendar;
1702 p1_a75 := rosetta_g_miss_num_map(ddx_complete_rec.country_id);
1703 p1_a76 := rosetta_g_miss_num_map(ddx_complete_rec.setup_id);
1704 p1_a77 := ddx_complete_rec.item_number;
1705 p1_a78 := ddx_complete_rec.associate_flag;
1706 p1_a79 := rosetta_g_miss_num_map(ddx_complete_rec.master_object_id);
1707 p1_a80 := ddx_complete_rec.master_object_type;
1708 p1_a81 := ddx_complete_rec.email_content_type;
1709 end;
1710
1711 end ams_deliverable_pvt_w;