[Home] [Help]
PACKAGE BODY: APPS.CSI_FA_INSTANCE_GRP_W
Source
1 package body csi_fa_instance_grp_w as
2 /* $Header: csigfawb.pls 120.11 2008/01/15 03:38:47 devijay ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5 rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
6 rosetta_g_mistake_date_low date := to_date('01/01/-4710', 'MM/DD/SYYYY');
7
8 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9 function rosetta_g_miss_date_in_map(d date) return date as
10 begin
11 if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12 if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13 return d;
14 end;
15
16 function rosetta_g_miss_num_map(n number) return number as
17 a number := fnd_api.g_miss_num;
18 b number := 0-1962.0724;
19 begin
20 if n=a then return b; end if;
21 if n=b then return a; end if;
22 return n;
23 end;
24
25 procedure rosetta_table_copy_in_p4(t out nocopy csi_fa_instance_grp.instance_serial_tbl, a0 JTF_VARCHAR2_TABLE_100
26 , a1 JTF_VARCHAR2_TABLE_100
27 , a2 JTF_VARCHAR2_TABLE_100
28 , a3 JTF_VARCHAR2_TABLE_100
29 , a4 JTF_VARCHAR2_TABLE_100
30 , a5 JTF_VARCHAR2_TABLE_300
31 , a6 JTF_VARCHAR2_TABLE_100
32 ) as
33 ddindx binary_integer; indx binary_integer;
34 begin
35 if a0 is not null and a0.count > 0 then
36 if a0.count > 0 then
37 indx := a0.first;
38 ddindx := 1;
39 while true loop
40 t(ddindx).instance_number := a0(indx);
41 t(ddindx).serial_number := a1(indx);
42 t(ddindx).lot_number := a2(indx);
43 t(ddindx).external_reference := a3(indx);
44 t(ddindx).instance_usage_code := a4(indx);
45 t(ddindx).instance_description := a5(indx);
46 t(ddindx).operational_status_code := a6(indx);
47 ddindx := ddindx+1;
48 if a0.last =indx
49 then exit;
50 end if;
51 indx := a0.next(indx);
52 end loop;
53 end if;
54 end if;
55 end rosetta_table_copy_in_p4;
56 procedure rosetta_table_copy_out_p4(t csi_fa_instance_grp.instance_serial_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
57 , a1 out nocopy JTF_VARCHAR2_TABLE_100
58 , a2 out nocopy JTF_VARCHAR2_TABLE_100
59 , a3 out nocopy JTF_VARCHAR2_TABLE_100
60 , a4 out nocopy JTF_VARCHAR2_TABLE_100
61 , a5 out nocopy JTF_VARCHAR2_TABLE_300
62 , a6 out nocopy JTF_VARCHAR2_TABLE_100
63 ) as
64 ddindx binary_integer; indx binary_integer;
65 begin
66 if t is null or t.count = 0 then
67 a0 := JTF_VARCHAR2_TABLE_100();
68 a1 := JTF_VARCHAR2_TABLE_100();
69 a2 := JTF_VARCHAR2_TABLE_100();
70 a3 := JTF_VARCHAR2_TABLE_100();
71 a4 := JTF_VARCHAR2_TABLE_100();
72 a5 := JTF_VARCHAR2_TABLE_300();
73 a6 := JTF_VARCHAR2_TABLE_100();
74 else
75 a0 := JTF_VARCHAR2_TABLE_100();
76 a1 := JTF_VARCHAR2_TABLE_100();
77 a2 := JTF_VARCHAR2_TABLE_100();
78 a3 := JTF_VARCHAR2_TABLE_100();
79 a4 := JTF_VARCHAR2_TABLE_100();
80 a5 := JTF_VARCHAR2_TABLE_300();
81 a6 := JTF_VARCHAR2_TABLE_100();
82 if t.count > 0 then
83 a0.extend(t.count);
84 a1.extend(t.count);
85 a2.extend(t.count);
86 a3.extend(t.count);
87 a4.extend(t.count);
88 a5.extend(t.count);
89 a6.extend(t.count);
90 ddindx := t.first;
91 indx := 1;
92 while true loop
93 a0(indx) := t(ddindx).instance_number;
94 a1(indx) := t(ddindx).serial_number;
95 a2(indx) := t(ddindx).lot_number;
96 a3(indx) := t(ddindx).external_reference;
97 a4(indx) := t(ddindx).instance_usage_code;
98 a5(indx) := t(ddindx).instance_description;
99 a6(indx) := t(ddindx).operational_status_code;
100 indx := indx+1;
101 if t.last =ddindx
102 then exit;
103 end if;
104 ddindx := t.next(ddindx);
105 end loop;
106 end if;
107 end if;
108 end rosetta_table_copy_out_p4;
109
110 procedure create_item_instance(p3_a0 JTF_VARCHAR2_TABLE_100
111 , p3_a1 JTF_VARCHAR2_TABLE_100
112 , p3_a2 JTF_VARCHAR2_TABLE_100
113 , p3_a3 JTF_VARCHAR2_TABLE_100
114 , p3_a4 JTF_VARCHAR2_TABLE_100
115 , p3_a5 JTF_VARCHAR2_TABLE_300
116 , p3_a6 JTF_VARCHAR2_TABLE_100
117 , p4_a0 JTF_NUMBER_TABLE
118 , p4_a1 JTF_NUMBER_TABLE
119 , p4_a2 JTF_VARCHAR2_TABLE_100
120 , p4_a3 JTF_NUMBER_TABLE
121 , p4_a4 JTF_VARCHAR2_TABLE_100
122 , p4_a5 JTF_VARCHAR2_TABLE_100
123 , p4_a6 JTF_NUMBER_TABLE
124 , p4_a7 JTF_DATE_TABLE
125 , p4_a8 JTF_DATE_TABLE
126 , p4_a9 JTF_VARCHAR2_TABLE_100
127 , p4_a10 JTF_VARCHAR2_TABLE_200
128 , p4_a11 JTF_VARCHAR2_TABLE_200
129 , p4_a12 JTF_VARCHAR2_TABLE_200
130 , p4_a13 JTF_VARCHAR2_TABLE_200
131 , p4_a14 JTF_VARCHAR2_TABLE_200
132 , p4_a15 JTF_VARCHAR2_TABLE_200
133 , p4_a16 JTF_VARCHAR2_TABLE_200
134 , p4_a17 JTF_VARCHAR2_TABLE_200
135 , p4_a18 JTF_VARCHAR2_TABLE_200
136 , p4_a19 JTF_VARCHAR2_TABLE_200
137 , p4_a20 JTF_VARCHAR2_TABLE_200
138 , p4_a21 JTF_VARCHAR2_TABLE_200
139 , p4_a22 JTF_VARCHAR2_TABLE_200
140 , p4_a23 JTF_VARCHAR2_TABLE_200
141 , p4_a24 JTF_VARCHAR2_TABLE_200
142 , p4_a25 JTF_NUMBER_TABLE
143 , p4_a26 JTF_VARCHAR2_TABLE_100
144 , p4_a27 JTF_VARCHAR2_TABLE_100
145 , p4_a28 JTF_NUMBER_TABLE
146 , p4_a29 JTF_VARCHAR2_TABLE_100
147 , p4_a30 JTF_NUMBER_TABLE
148 , p4_a31 JTF_NUMBER_TABLE
149 , p4_a32 JTF_VARCHAR2_TABLE_100
150 , p5_a0 JTF_NUMBER_TABLE
151 , p5_a1 JTF_NUMBER_TABLE
152 , p5_a2 JTF_NUMBER_TABLE
153 , p5_a3 JTF_NUMBER_TABLE
154 , p5_a4 JTF_VARCHAR2_TABLE_100
155 , p5_a5 JTF_NUMBER_TABLE
156 , p5_a6 JTF_NUMBER_TABLE
157 , p5_a7 JTF_DATE_TABLE
158 , p5_a8 JTF_DATE_TABLE
159 , p5_a9 JTF_VARCHAR2_TABLE_100
160 , p5_a10 JTF_VARCHAR2_TABLE_200
161 , p5_a11 JTF_VARCHAR2_TABLE_200
162 , p5_a12 JTF_VARCHAR2_TABLE_200
163 , p5_a13 JTF_VARCHAR2_TABLE_200
164 , p5_a14 JTF_VARCHAR2_TABLE_200
165 , p5_a15 JTF_VARCHAR2_TABLE_200
166 , p5_a16 JTF_VARCHAR2_TABLE_200
167 , p5_a17 JTF_VARCHAR2_TABLE_200
168 , p5_a18 JTF_VARCHAR2_TABLE_200
169 , p5_a19 JTF_VARCHAR2_TABLE_200
170 , p5_a20 JTF_VARCHAR2_TABLE_200
171 , p5_a21 JTF_VARCHAR2_TABLE_200
172 , p5_a22 JTF_VARCHAR2_TABLE_200
173 , p5_a23 JTF_VARCHAR2_TABLE_200
174 , p5_a24 JTF_VARCHAR2_TABLE_200
175 , p5_a25 JTF_NUMBER_TABLE
176 , p5_a26 JTF_VARCHAR2_TABLE_100
177 , p5_a27 JTF_NUMBER_TABLE
178 , p5_a28 JTF_VARCHAR2_TABLE_100
179 , p5_a29 JTF_VARCHAR2_TABLE_100
180 , p5_a30 JTF_NUMBER_TABLE
181 , p5_a31 JTF_NUMBER_TABLE
182 , p5_a32 JTF_NUMBER_TABLE
183 , p5_a33 JTF_DATE_TABLE
184 , p5_a34 JTF_NUMBER_TABLE
185 , p5_a35 JTF_VARCHAR2_TABLE_100
186 , p6_a0 in out nocopy NUMBER
187 , p6_a1 in out nocopy DATE
188 , p6_a2 in out nocopy DATE
189 , p6_a3 in out nocopy NUMBER
190 , p6_a4 in out nocopy NUMBER
191 , p6_a5 in out nocopy NUMBER
192 , p6_a6 in out nocopy VARCHAR2
193 , p6_a7 in out nocopy NUMBER
194 , p6_a8 in out nocopy VARCHAR2
195 , p6_a9 in out nocopy NUMBER
196 , p6_a10 in out nocopy VARCHAR2
197 , p6_a11 in out nocopy NUMBER
198 , p6_a12 in out nocopy NUMBER
199 , p6_a13 in out nocopy NUMBER
200 , p6_a14 in out nocopy NUMBER
201 , p6_a15 in out nocopy VARCHAR2
202 , p6_a16 in out nocopy NUMBER
203 , p6_a17 in out nocopy VARCHAR2
204 , p6_a18 in out nocopy VARCHAR2
205 , p6_a19 in out nocopy NUMBER
206 , p6_a20 in out nocopy VARCHAR2
207 , p6_a21 in out nocopy VARCHAR2
208 , p6_a22 in out nocopy VARCHAR2
209 , p6_a23 in out nocopy VARCHAR2
210 , p6_a24 in out nocopy VARCHAR2
211 , p6_a25 in out nocopy VARCHAR2
212 , p6_a26 in out nocopy VARCHAR2
213 , p6_a27 in out nocopy VARCHAR2
214 , p6_a28 in out nocopy VARCHAR2
215 , p6_a29 in out nocopy VARCHAR2
216 , p6_a30 in out nocopy VARCHAR2
217 , p6_a31 in out nocopy VARCHAR2
218 , p6_a32 in out nocopy VARCHAR2
219 , p6_a33 in out nocopy VARCHAR2
220 , p6_a34 in out nocopy VARCHAR2
221 , p6_a35 in out nocopy VARCHAR2
222 , p6_a36 in out nocopy NUMBER
223 , p6_a37 in out nocopy VARCHAR2
224 , p6_a38 in out nocopy DATE
225 , p6_a39 in out nocopy NUMBER
226 , p7_a0 out nocopy JTF_NUMBER_TABLE
227 , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
228 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
229 , p7_a3 out nocopy JTF_NUMBER_TABLE
230 , p7_a4 out nocopy JTF_NUMBER_TABLE
231 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
232 , p7_a6 out nocopy JTF_NUMBER_TABLE
233 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
234 , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
235 , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
236 , p7_a10 out nocopy JTF_NUMBER_TABLE
237 , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
238 , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
239 , p7_a13 out nocopy JTF_NUMBER_TABLE
240 , p7_a14 out nocopy JTF_NUMBER_TABLE
241 , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
242 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
243 , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
244 , p7_a18 out nocopy JTF_NUMBER_TABLE
245 , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
246 , p7_a20 out nocopy JTF_DATE_TABLE
247 , p7_a21 out nocopy JTF_DATE_TABLE
248 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
249 , p7_a23 out nocopy JTF_NUMBER_TABLE
250 , p7_a24 out nocopy JTF_NUMBER_TABLE
251 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
252 , p7_a26 out nocopy JTF_NUMBER_TABLE
253 , p7_a27 out nocopy JTF_NUMBER_TABLE
254 , p7_a28 out nocopy JTF_NUMBER_TABLE
255 , p7_a29 out nocopy JTF_NUMBER_TABLE
256 , p7_a30 out nocopy JTF_NUMBER_TABLE
257 , p7_a31 out nocopy JTF_NUMBER_TABLE
258 , p7_a32 out nocopy JTF_NUMBER_TABLE
259 , p7_a33 out nocopy JTF_NUMBER_TABLE
260 , p7_a34 out nocopy JTF_NUMBER_TABLE
261 , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
262 , p7_a36 out nocopy JTF_NUMBER_TABLE
263 , p7_a37 out nocopy JTF_NUMBER_TABLE
264 , p7_a38 out nocopy JTF_NUMBER_TABLE
265 , p7_a39 out nocopy JTF_NUMBER_TABLE
266 , p7_a40 out nocopy JTF_DATE_TABLE
267 , p7_a41 out nocopy JTF_VARCHAR2_TABLE_100
268 , p7_a42 out nocopy JTF_DATE_TABLE
269 , p7_a43 out nocopy JTF_DATE_TABLE
270 , p7_a44 out nocopy JTF_VARCHAR2_TABLE_100
271 , p7_a45 out nocopy JTF_VARCHAR2_TABLE_100
272 , p7_a46 out nocopy JTF_VARCHAR2_TABLE_300
273 , p7_a47 out nocopy JTF_VARCHAR2_TABLE_300
274 , p7_a48 out nocopy JTF_VARCHAR2_TABLE_100
275 , p7_a49 out nocopy JTF_VARCHAR2_TABLE_300
276 , p7_a50 out nocopy JTF_VARCHAR2_TABLE_300
277 , p7_a51 out nocopy JTF_VARCHAR2_TABLE_300
278 , p7_a52 out nocopy JTF_VARCHAR2_TABLE_300
279 , p7_a53 out nocopy JTF_VARCHAR2_TABLE_300
280 , p7_a54 out nocopy JTF_VARCHAR2_TABLE_300
281 , p7_a55 out nocopy JTF_VARCHAR2_TABLE_300
282 , p7_a56 out nocopy JTF_VARCHAR2_TABLE_300
283 , p7_a57 out nocopy JTF_VARCHAR2_TABLE_300
284 , p7_a58 out nocopy JTF_VARCHAR2_TABLE_300
285 , p7_a59 out nocopy JTF_VARCHAR2_TABLE_300
286 , p7_a60 out nocopy JTF_VARCHAR2_TABLE_300
287 , p7_a61 out nocopy JTF_VARCHAR2_TABLE_300
288 , p7_a62 out nocopy JTF_VARCHAR2_TABLE_300
289 , p7_a63 out nocopy JTF_VARCHAR2_TABLE_300
290 , p7_a64 out nocopy JTF_NUMBER_TABLE
291 , p7_a65 out nocopy JTF_NUMBER_TABLE
292 , p7_a66 out nocopy JTF_VARCHAR2_TABLE_100
293 , p7_a67 out nocopy JTF_NUMBER_TABLE
294 , p7_a68 out nocopy JTF_VARCHAR2_TABLE_100
295 , p7_a69 out nocopy JTF_VARCHAR2_TABLE_100
296 , p7_a70 out nocopy JTF_VARCHAR2_TABLE_100
297 , p7_a71 out nocopy JTF_VARCHAR2_TABLE_100
298 , p7_a72 out nocopy JTF_NUMBER_TABLE
299 , p7_a73 out nocopy JTF_VARCHAR2_TABLE_100
300 , p7_a74 out nocopy JTF_NUMBER_TABLE
301 , p7_a75 out nocopy JTF_NUMBER_TABLE
302 , p7_a76 out nocopy JTF_NUMBER_TABLE
303 , p7_a77 out nocopy JTF_VARCHAR2_TABLE_100
304 , p7_a78 out nocopy JTF_VARCHAR2_TABLE_300
305 , p7_a79 out nocopy JTF_VARCHAR2_TABLE_100
306 , p7_a80 out nocopy JTF_NUMBER_TABLE
307 , p7_a81 out nocopy JTF_NUMBER_TABLE
308 , p7_a82 out nocopy JTF_NUMBER_TABLE
309 , p7_a83 out nocopy JTF_DATE_TABLE
310 , p7_a84 out nocopy JTF_VARCHAR2_TABLE_100
311 , p7_a85 out nocopy JTF_VARCHAR2_TABLE_100
312 , p7_a86 out nocopy JTF_VARCHAR2_TABLE_100
313 , p7_a87 out nocopy JTF_NUMBER_TABLE
314 , p7_a88 out nocopy JTF_VARCHAR2_TABLE_100
315 , p7_a89 out nocopy JTF_NUMBER_TABLE
316 , p7_a90 out nocopy JTF_NUMBER_TABLE
317 , p7_a91 out nocopy JTF_VARCHAR2_TABLE_100
318 , p7_a92 out nocopy JTF_NUMBER_TABLE
319 , p7_a93 out nocopy JTF_VARCHAR2_TABLE_100
320 , p7_a94 out nocopy JTF_NUMBER_TABLE
321 , p7_a95 out nocopy JTF_DATE_TABLE
322 , p7_a96 out nocopy JTF_VARCHAR2_TABLE_300
323 , p7_a97 out nocopy JTF_VARCHAR2_TABLE_300
324 , p7_a98 out nocopy JTF_VARCHAR2_TABLE_300
325 , p7_a99 out nocopy JTF_VARCHAR2_TABLE_300
326 , p7_a100 out nocopy JTF_VARCHAR2_TABLE_300
327 , p7_a101 out nocopy JTF_VARCHAR2_TABLE_300
328 , p7_a102 out nocopy JTF_VARCHAR2_TABLE_300
329 , p7_a103 out nocopy JTF_VARCHAR2_TABLE_300
330 , p7_a104 out nocopy JTF_VARCHAR2_TABLE_300
331 , p7_a105 out nocopy JTF_VARCHAR2_TABLE_300
332 , p7_a106 out nocopy JTF_VARCHAR2_TABLE_300
333 , p7_a107 out nocopy JTF_VARCHAR2_TABLE_300
334 , p7_a108 out nocopy JTF_VARCHAR2_TABLE_300
335 , p7_a109 out nocopy JTF_VARCHAR2_TABLE_300
336 , p7_a110 out nocopy JTF_VARCHAR2_TABLE_300
337 , p7_a111 out nocopy JTF_NUMBER_TABLE
338 , p7_a112 out nocopy JTF_VARCHAR2_TABLE_100
339 , p7_a113 out nocopy JTF_NUMBER_TABLE
340 , p7_a114 out nocopy JTF_VARCHAR2_TABLE_100
341 , p7_a115 out nocopy JTF_NUMBER_TABLE
342 , p7_a116 out nocopy JTF_VARCHAR2_TABLE_100
343 , p7_a117 out nocopy JTF_VARCHAR2_TABLE_100
344 , p7_a118 out nocopy JTF_NUMBER_TABLE
345 , p7_a119 out nocopy JTF_VARCHAR2_TABLE_100
346 , p7_a120 out nocopy JTF_NUMBER_TABLE
347 , p7_a121 out nocopy JTF_NUMBER_TABLE
348 , p7_a122 out nocopy JTF_VARCHAR2_TABLE_100
349 , p8_a0 out nocopy JTF_NUMBER_TABLE
350 , p8_a1 out nocopy JTF_NUMBER_TABLE
351 , p8_a2 out nocopy JTF_NUMBER_TABLE
352 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
353 , p8_a4 out nocopy JTF_NUMBER_TABLE
354 , p8_a5 out nocopy JTF_NUMBER_TABLE
355 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
356 , p8_a7 out nocopy JTF_DATE_TABLE
360 , p8_a11 out nocopy JTF_NUMBER_TABLE
357 , p8_a8 out nocopy JTF_DATE_TABLE
358 , p8_a9 out nocopy JTF_NUMBER_TABLE
359 , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
361 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
362 , p8_a13 out nocopy JTF_NUMBER_TABLE
363 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
364 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
365 , x_return_status out nocopy VARCHAR2
366 , x_error_message out nocopy VARCHAR2
367 , p0_a0 NUMBER := 0-1962.0724
368 , p0_a1 VARCHAR2 := fnd_api.g_miss_char
369 , p0_a2 NUMBER := 0-1962.0724
370 , p0_a3 NUMBER := 0-1962.0724
371 , p0_a4 VARCHAR2 := fnd_api.g_miss_char
372 , p0_a5 VARCHAR2 := fnd_api.g_miss_char
373 , p1_a0 NUMBER := 0-1962.0724
374 , p1_a1 VARCHAR2 := fnd_api.g_miss_char
375 , p1_a2 NUMBER := 0-1962.0724
376 , p1_a3 VARCHAR2 := fnd_api.g_miss_char
377 , p1_a4 NUMBER := 0-1962.0724
378 , p1_a5 NUMBER := 0-1962.0724
379 , p2_a0 NUMBER := 0-1962.0724
380 , p2_a1 VARCHAR2 := fnd_api.g_miss_char
381 , p2_a2 VARCHAR2 := fnd_api.g_miss_char
382 , p2_a3 NUMBER := 0-1962.0724
383 , p2_a4 NUMBER := 0-1962.0724
384 , p2_a5 VARCHAR2 := fnd_api.g_miss_char
385 , p2_a6 NUMBER := 0-1962.0724
386 , p2_a7 VARCHAR2 := fnd_api.g_miss_char
387 , p2_a8 VARCHAR2 := fnd_api.g_miss_char
388 , p2_a9 VARCHAR2 := fnd_api.g_miss_char
389 , p2_a10 NUMBER := 0-1962.0724
390 , p2_a11 VARCHAR2 := fnd_api.g_miss_char
391 , p2_a12 VARCHAR2 := fnd_api.g_miss_char
392 , p2_a13 NUMBER := 0-1962.0724
393 , p2_a14 NUMBER := 0-1962.0724
394 , p2_a15 VARCHAR2 := fnd_api.g_miss_char
395 , p2_a16 VARCHAR2 := fnd_api.g_miss_char
396 , p2_a17 VARCHAR2 := fnd_api.g_miss_char
397 , p2_a18 NUMBER := 0-1962.0724
398 , p2_a19 VARCHAR2 := fnd_api.g_miss_char
399 , p2_a20 DATE := fnd_api.g_miss_date
400 , p2_a21 DATE := fnd_api.g_miss_date
401 , p2_a22 VARCHAR2 := fnd_api.g_miss_char
402 , p2_a23 NUMBER := 0-1962.0724
403 , p2_a24 NUMBER := 0-1962.0724
404 , p2_a25 VARCHAR2 := fnd_api.g_miss_char
405 , p2_a26 NUMBER := 0-1962.0724
406 , p2_a27 NUMBER := 0-1962.0724
407 , p2_a28 NUMBER := 0-1962.0724
408 , p2_a29 NUMBER := 0-1962.0724
409 , p2_a30 NUMBER := 0-1962.0724
410 , p2_a31 NUMBER := 0-1962.0724
411 , p2_a32 NUMBER := 0-1962.0724
412 , p2_a33 NUMBER := 0-1962.0724
413 , p2_a34 NUMBER := 0-1962.0724
414 , p2_a35 VARCHAR2 := fnd_api.g_miss_char
415 , p2_a36 NUMBER := 0-1962.0724
416 , p2_a37 NUMBER := 0-1962.0724
417 , p2_a38 NUMBER := 0-1962.0724
418 , p2_a39 NUMBER := 0-1962.0724
419 , p2_a40 DATE := fnd_api.g_miss_date
420 , p2_a41 VARCHAR2 := fnd_api.g_miss_char
421 , p2_a42 DATE := fnd_api.g_miss_date
422 , p2_a43 DATE := fnd_api.g_miss_date
423 , p2_a44 VARCHAR2 := fnd_api.g_miss_char
424 , p2_a45 VARCHAR2 := fnd_api.g_miss_char
425 , p2_a46 VARCHAR2 := fnd_api.g_miss_char
426 , p2_a47 VARCHAR2 := fnd_api.g_miss_char
427 , p2_a48 VARCHAR2 := fnd_api.g_miss_char
428 , p2_a49 VARCHAR2 := fnd_api.g_miss_char
429 , p2_a50 VARCHAR2 := fnd_api.g_miss_char
430 , p2_a51 VARCHAR2 := fnd_api.g_miss_char
431 , p2_a52 VARCHAR2 := fnd_api.g_miss_char
432 , p2_a53 VARCHAR2 := fnd_api.g_miss_char
433 , p2_a54 VARCHAR2 := fnd_api.g_miss_char
434 , p2_a55 VARCHAR2 := fnd_api.g_miss_char
435 , p2_a56 VARCHAR2 := fnd_api.g_miss_char
436 , p2_a57 VARCHAR2 := fnd_api.g_miss_char
437 , p2_a58 VARCHAR2 := fnd_api.g_miss_char
438 , p2_a59 VARCHAR2 := fnd_api.g_miss_char
439 , p2_a60 VARCHAR2 := fnd_api.g_miss_char
440 , p2_a61 VARCHAR2 := fnd_api.g_miss_char
441 , p2_a62 VARCHAR2 := fnd_api.g_miss_char
442 , p2_a63 VARCHAR2 := fnd_api.g_miss_char
443 , p2_a64 NUMBER := 0-1962.0724
444 , p2_a65 NUMBER := 0-1962.0724
445 , p2_a66 VARCHAR2 := fnd_api.g_miss_char
446 , p2_a67 NUMBER := 0-1962.0724
447 , p2_a68 VARCHAR2 := fnd_api.g_miss_char
448 , p2_a69 VARCHAR2 := fnd_api.g_miss_char
449 , p2_a70 VARCHAR2 := fnd_api.g_miss_char
450 , p2_a71 VARCHAR2 := fnd_api.g_miss_char
451 , p2_a72 NUMBER := 0-1962.0724
452 , p2_a73 VARCHAR2 := fnd_api.g_miss_char
453 , p2_a74 NUMBER := 0-1962.0724
454 , p2_a75 NUMBER := 0-1962.0724
455 , p2_a76 NUMBER := 0-1962.0724
456 , p2_a77 VARCHAR2 := fnd_api.g_miss_char
457 , p2_a78 VARCHAR2 := fnd_api.g_miss_char
458 , p2_a79 VARCHAR2 := fnd_api.g_miss_char
459 , p2_a80 NUMBER := 0-1962.0724
460 , p2_a81 NUMBER := 0-1962.0724
461 , p2_a82 NUMBER := 0-1962.0724
462 , p2_a83 DATE := fnd_api.g_miss_date
463 , p2_a84 VARCHAR2 := fnd_api.g_miss_char
464 , p2_a85 VARCHAR2 := fnd_api.g_miss_char
465 , p2_a86 VARCHAR2 := fnd_api.g_miss_char
466 , p2_a87 NUMBER := 0-1962.0724
467 , p2_a88 VARCHAR2 := fnd_api.g_miss_char
468 , p2_a89 NUMBER := 0-1962.0724
469 , p2_a90 NUMBER := 0-1962.0724
470 , p2_a91 VARCHAR2 := fnd_api.g_miss_char
471 , p2_a92 NUMBER := 0-1962.0724
472 , p2_a93 VARCHAR2 := fnd_api.g_miss_char
473 , p2_a94 NUMBER := 0-1962.0724
474 , p2_a95 DATE := fnd_api.g_miss_date
475 , p2_a96 VARCHAR2 := fnd_api.g_miss_char
479 , p2_a100 VARCHAR2 := fnd_api.g_miss_char
476 , p2_a97 VARCHAR2 := fnd_api.g_miss_char
477 , p2_a98 VARCHAR2 := fnd_api.g_miss_char
478 , p2_a99 VARCHAR2 := fnd_api.g_miss_char
480 , p2_a101 VARCHAR2 := fnd_api.g_miss_char
481 , p2_a102 VARCHAR2 := fnd_api.g_miss_char
482 , p2_a103 VARCHAR2 := fnd_api.g_miss_char
483 , p2_a104 VARCHAR2 := fnd_api.g_miss_char
484 , p2_a105 VARCHAR2 := fnd_api.g_miss_char
485 , p2_a106 VARCHAR2 := fnd_api.g_miss_char
486 , p2_a107 VARCHAR2 := fnd_api.g_miss_char
487 , p2_a108 VARCHAR2 := fnd_api.g_miss_char
488 , p2_a109 VARCHAR2 := fnd_api.g_miss_char
489 , p2_a110 VARCHAR2 := fnd_api.g_miss_char
490 , p2_a111 NUMBER := 0-1962.0724
491 , p2_a112 VARCHAR2 := fnd_api.g_miss_char
492 , p2_a113 NUMBER := 0-1962.0724
493 , p2_a114 VARCHAR2 := fnd_api.g_miss_char
494 , p2_a115 NUMBER := 0-1962.0724
495 , p2_a116 VARCHAR2 := fnd_api.g_miss_char
496 , p2_a117 VARCHAR2 := fnd_api.g_miss_char
497 , p2_a118 NUMBER := 0-1962.0724
498 , p2_a119 VARCHAR2 := fnd_api.g_miss_char
499 , p2_a120 NUMBER := 0-1962.0724
500 , p2_a121 NUMBER := 0-1962.0724
501 , p2_a122 VARCHAR2 := fnd_api.g_miss_char
502 )
503
504 as
505 ddp_fixed_asset_rec csi_fa_instance_grp.fixed_asset_rec;
506 ddp_eam_rec csi_fa_instance_grp.eam_rec;
507 ddp_instance_rec csi_datastructures_pub.instance_rec;
508 ddp_instance_serial_tbl csi_fa_instance_grp.instance_serial_tbl;
509 ddp_party_tbl csi_datastructures_pub.party_tbl;
510 ddp_party_account_tbl csi_datastructures_pub.party_account_tbl;
511 ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
512 ddx_instance_tbl csi_datastructures_pub.instance_tbl;
513 ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
514 ddindx binary_integer; indx binary_integer;
515 begin
516
517 -- copy data to the local IN or IN-OUT args, if any
518 ddp_fixed_asset_rec.asset_id := rosetta_g_miss_num_map(p0_a0);
519 ddp_fixed_asset_rec.book_type_code := p0_a1;
520 ddp_fixed_asset_rec.asset_location_id := rosetta_g_miss_num_map(p0_a2);
521 ddp_fixed_asset_rec.asset_quantity := rosetta_g_miss_num_map(p0_a3);
522 ddp_fixed_asset_rec.fa_sync_flag := p0_a4;
523 ddp_fixed_asset_rec.fa_sync_validation_reqd := p0_a5;
524
525 ddp_eam_rec.category_id := rosetta_g_miss_num_map(p1_a0);
526 ddp_eam_rec.asset_criticality_code := p1_a1;
527 ddp_eam_rec.owning_department_id := rosetta_g_miss_num_map(p1_a2);
528 ddp_eam_rec.wip_accounting_class_code := p1_a3;
529 ddp_eam_rec.area_id := rosetta_g_miss_num_map(p1_a4);
530 ddp_eam_rec.parent_instance_id := rosetta_g_miss_num_map(p1_a5);
531
532 ddp_instance_rec.instance_id := rosetta_g_miss_num_map(p2_a0);
533 ddp_instance_rec.instance_number := p2_a1;
534 ddp_instance_rec.external_reference := p2_a2;
535 ddp_instance_rec.inventory_item_id := rosetta_g_miss_num_map(p2_a3);
536 ddp_instance_rec.vld_organization_id := rosetta_g_miss_num_map(p2_a4);
537 ddp_instance_rec.inventory_revision := p2_a5;
538 ddp_instance_rec.inv_master_organization_id := rosetta_g_miss_num_map(p2_a6);
539 ddp_instance_rec.serial_number := p2_a7;
540 ddp_instance_rec.mfg_serial_number_flag := p2_a8;
541 ddp_instance_rec.lot_number := p2_a9;
542 ddp_instance_rec.quantity := rosetta_g_miss_num_map(p2_a10);
543 ddp_instance_rec.unit_of_measure := p2_a11;
544 ddp_instance_rec.accounting_class_code := p2_a12;
545 ddp_instance_rec.instance_condition_id := rosetta_g_miss_num_map(p2_a13);
546 ddp_instance_rec.instance_status_id := rosetta_g_miss_num_map(p2_a14);
547 ddp_instance_rec.customer_view_flag := p2_a15;
548 ddp_instance_rec.merchant_view_flag := p2_a16;
549 ddp_instance_rec.sellable_flag := p2_a17;
550 ddp_instance_rec.system_id := rosetta_g_miss_num_map(p2_a18);
551 ddp_instance_rec.instance_type_code := p2_a19;
552 ddp_instance_rec.active_start_date := rosetta_g_miss_date_in_map(p2_a20);
553 ddp_instance_rec.active_end_date := rosetta_g_miss_date_in_map(p2_a21);
554 ddp_instance_rec.location_type_code := p2_a22;
555 ddp_instance_rec.location_id := rosetta_g_miss_num_map(p2_a23);
556 ddp_instance_rec.inv_organization_id := rosetta_g_miss_num_map(p2_a24);
557 ddp_instance_rec.inv_subinventory_name := p2_a25;
558 ddp_instance_rec.inv_locator_id := rosetta_g_miss_num_map(p2_a26);
559 ddp_instance_rec.pa_project_id := rosetta_g_miss_num_map(p2_a27);
560 ddp_instance_rec.pa_project_task_id := rosetta_g_miss_num_map(p2_a28);
561 ddp_instance_rec.in_transit_order_line_id := rosetta_g_miss_num_map(p2_a29);
562 ddp_instance_rec.wip_job_id := rosetta_g_miss_num_map(p2_a30);
563 ddp_instance_rec.po_order_line_id := rosetta_g_miss_num_map(p2_a31);
564 ddp_instance_rec.last_oe_order_line_id := rosetta_g_miss_num_map(p2_a32);
565 ddp_instance_rec.last_oe_rma_line_id := rosetta_g_miss_num_map(p2_a33);
566 ddp_instance_rec.last_po_po_line_id := rosetta_g_miss_num_map(p2_a34);
567 ddp_instance_rec.last_oe_po_number := p2_a35;
568 ddp_instance_rec.last_wip_job_id := rosetta_g_miss_num_map(p2_a36);
569 ddp_instance_rec.last_pa_project_id := rosetta_g_miss_num_map(p2_a37);
570 ddp_instance_rec.last_pa_task_id := rosetta_g_miss_num_map(p2_a38);
574 ddp_instance_rec.return_by_date := rosetta_g_miss_date_in_map(p2_a42);
571 ddp_instance_rec.last_oe_agreement_id := rosetta_g_miss_num_map(p2_a39);
572 ddp_instance_rec.install_date := rosetta_g_miss_date_in_map(p2_a40);
573 ddp_instance_rec.manually_created_flag := p2_a41;
575 ddp_instance_rec.actual_return_date := rosetta_g_miss_date_in_map(p2_a43);
576 ddp_instance_rec.creation_complete_flag := p2_a44;
577 ddp_instance_rec.completeness_flag := p2_a45;
578 ddp_instance_rec.version_label := p2_a46;
579 ddp_instance_rec.version_label_description := p2_a47;
580 ddp_instance_rec.context := p2_a48;
581 ddp_instance_rec.attribute1 := p2_a49;
582 ddp_instance_rec.attribute2 := p2_a50;
583 ddp_instance_rec.attribute3 := p2_a51;
584 ddp_instance_rec.attribute4 := p2_a52;
585 ddp_instance_rec.attribute5 := p2_a53;
586 ddp_instance_rec.attribute6 := p2_a54;
587 ddp_instance_rec.attribute7 := p2_a55;
588 ddp_instance_rec.attribute8 := p2_a56;
589 ddp_instance_rec.attribute9 := p2_a57;
590 ddp_instance_rec.attribute10 := p2_a58;
591 ddp_instance_rec.attribute11 := p2_a59;
592 ddp_instance_rec.attribute12 := p2_a60;
593 ddp_instance_rec.attribute13 := p2_a61;
594 ddp_instance_rec.attribute14 := p2_a62;
595 ddp_instance_rec.attribute15 := p2_a63;
596 ddp_instance_rec.object_version_number := rosetta_g_miss_num_map(p2_a64);
597 ddp_instance_rec.last_txn_line_detail_id := rosetta_g_miss_num_map(p2_a65);
598 ddp_instance_rec.install_location_type_code := p2_a66;
599 ddp_instance_rec.install_location_id := rosetta_g_miss_num_map(p2_a67);
600 ddp_instance_rec.instance_usage_code := p2_a68;
601 ddp_instance_rec.check_for_instance_expiry := p2_a69;
602 ddp_instance_rec.processed_flag := p2_a70;
603 ddp_instance_rec.call_contracts := p2_a71;
604 ddp_instance_rec.interface_id := rosetta_g_miss_num_map(p2_a72);
605 ddp_instance_rec.grp_call_contracts := p2_a73;
606 ddp_instance_rec.config_inst_hdr_id := rosetta_g_miss_num_map(p2_a74);
607 ddp_instance_rec.config_inst_rev_num := rosetta_g_miss_num_map(p2_a75);
608 ddp_instance_rec.config_inst_item_id := rosetta_g_miss_num_map(p2_a76);
609 ddp_instance_rec.config_valid_status := p2_a77;
610 ddp_instance_rec.instance_description := p2_a78;
611 ddp_instance_rec.call_batch_validation := p2_a79;
612 ddp_instance_rec.request_id := rosetta_g_miss_num_map(p2_a80);
613 ddp_instance_rec.program_application_id := rosetta_g_miss_num_map(p2_a81);
614 ddp_instance_rec.program_id := rosetta_g_miss_num_map(p2_a82);
615 ddp_instance_rec.program_update_date := rosetta_g_miss_date_in_map(p2_a83);
616 ddp_instance_rec.cascade_ownership_flag := p2_a84;
617 ddp_instance_rec.network_asset_flag := p2_a85;
618 ddp_instance_rec.maintainable_flag := p2_a86;
619 ddp_instance_rec.pn_location_id := rosetta_g_miss_num_map(p2_a87);
620 ddp_instance_rec.asset_criticality_code := p2_a88;
621 ddp_instance_rec.category_id := rosetta_g_miss_num_map(p2_a89);
622 ddp_instance_rec.equipment_gen_object_id := rosetta_g_miss_num_map(p2_a90);
623 ddp_instance_rec.instantiation_flag := p2_a91;
624 ddp_instance_rec.linear_location_id := rosetta_g_miss_num_map(p2_a92);
625 ddp_instance_rec.operational_log_flag := p2_a93;
626 ddp_instance_rec.checkin_status := rosetta_g_miss_num_map(p2_a94);
627 ddp_instance_rec.supplier_warranty_exp_date := rosetta_g_miss_date_in_map(p2_a95);
628 ddp_instance_rec.attribute16 := p2_a96;
629 ddp_instance_rec.attribute17 := p2_a97;
630 ddp_instance_rec.attribute18 := p2_a98;
631 ddp_instance_rec.attribute19 := p2_a99;
632 ddp_instance_rec.attribute20 := p2_a100;
633 ddp_instance_rec.attribute21 := p2_a101;
634 ddp_instance_rec.attribute22 := p2_a102;
635 ddp_instance_rec.attribute23 := p2_a103;
636 ddp_instance_rec.attribute24 := p2_a104;
637 ddp_instance_rec.attribute25 := p2_a105;
638 ddp_instance_rec.attribute26 := p2_a106;
639 ddp_instance_rec.attribute27 := p2_a107;
640 ddp_instance_rec.attribute28 := p2_a108;
641 ddp_instance_rec.attribute29 := p2_a109;
642 ddp_instance_rec.attribute30 := p2_a110;
643 ddp_instance_rec.purchase_unit_price := rosetta_g_miss_num_map(p2_a111);
644 ddp_instance_rec.purchase_currency_code := p2_a112;
645 ddp_instance_rec.payables_unit_price := rosetta_g_miss_num_map(p2_a113);
646 ddp_instance_rec.payables_currency_code := p2_a114;
647 ddp_instance_rec.sales_unit_price := rosetta_g_miss_num_map(p2_a115);
648 ddp_instance_rec.sales_currency_code := p2_a116;
649 ddp_instance_rec.operational_status_code := p2_a117;
650 ddp_instance_rec.department_id := rosetta_g_miss_num_map(p2_a118);
651 ddp_instance_rec.wip_accounting_class := p2_a119;
652 ddp_instance_rec.area_id := rosetta_g_miss_num_map(p2_a120);
653 ddp_instance_rec.owner_party_id := rosetta_g_miss_num_map(p2_a121);
654 ddp_instance_rec.source_code := p2_a122;
655
656 csi_fa_instance_grp_w.rosetta_table_copy_in_p4(ddp_instance_serial_tbl, p3_a0
657 , p3_a1
658 , p3_a2
659 , p3_a3
660 , p3_a4
661 , p3_a5
662 , p3_a6
663 );
664
665 csi_datastructures_pub_w.rosetta_table_copy_in_p9(ddp_party_tbl, p4_a0
666 , p4_a1
667 , p4_a2
668 , p4_a3
669 , p4_a4
670 , p4_a5
671 , p4_a6
672 , p4_a7
673 , p4_a8
674 , p4_a9
678 , p4_a13
675 , p4_a10
676 , p4_a11
677 , p4_a12
679 , p4_a14
680 , p4_a15
681 , p4_a16
682 , p4_a17
683 , p4_a18
684 , p4_a19
685 , p4_a20
686 , p4_a21
687 , p4_a22
688 , p4_a23
689 , p4_a24
690 , p4_a25
691 , p4_a26
692 , p4_a27
693 , p4_a28
694 , p4_a29
695 , p4_a30
696 , p4_a31
697 , p4_a32
698 );
699
700 csi_datastructures_pub_w.rosetta_table_copy_in_p6(ddp_party_account_tbl, p5_a0
701 , p5_a1
702 , p5_a2
703 , p5_a3
704 , p5_a4
705 , p5_a5
706 , p5_a6
707 , p5_a7
708 , p5_a8
709 , p5_a9
710 , p5_a10
711 , p5_a11
712 , p5_a12
713 , p5_a13
714 , p5_a14
715 , p5_a15
716 , p5_a16
717 , p5_a17
718 , p5_a18
719 , p5_a19
720 , p5_a20
721 , p5_a21
722 , p5_a22
723 , p5_a23
724 , p5_a24
725 , p5_a25
726 , p5_a26
727 , p5_a27
728 , p5_a28
729 , p5_a29
730 , p5_a30
731 , p5_a31
732 , p5_a32
733 , p5_a33
734 , p5_a34
735 , p5_a35
736 );
737
738 ddpx_csi_txn_rec.transaction_id := rosetta_g_miss_num_map(p6_a0);
739 ddpx_csi_txn_rec.transaction_date := rosetta_g_miss_date_in_map(p6_a1);
740 ddpx_csi_txn_rec.source_transaction_date := rosetta_g_miss_date_in_map(p6_a2);
741 ddpx_csi_txn_rec.transaction_type_id := rosetta_g_miss_num_map(p6_a3);
742 ddpx_csi_txn_rec.txn_sub_type_id := rosetta_g_miss_num_map(p6_a4);
743 ddpx_csi_txn_rec.source_group_ref_id := rosetta_g_miss_num_map(p6_a5);
744 ddpx_csi_txn_rec.source_group_ref := p6_a6;
745 ddpx_csi_txn_rec.source_header_ref_id := rosetta_g_miss_num_map(p6_a7);
746 ddpx_csi_txn_rec.source_header_ref := p6_a8;
747 ddpx_csi_txn_rec.source_line_ref_id := rosetta_g_miss_num_map(p6_a9);
748 ddpx_csi_txn_rec.source_line_ref := p6_a10;
749 ddpx_csi_txn_rec.source_dist_ref_id1 := rosetta_g_miss_num_map(p6_a11);
750 ddpx_csi_txn_rec.source_dist_ref_id2 := rosetta_g_miss_num_map(p6_a12);
751 ddpx_csi_txn_rec.inv_material_transaction_id := rosetta_g_miss_num_map(p6_a13);
752 ddpx_csi_txn_rec.transaction_quantity := rosetta_g_miss_num_map(p6_a14);
753 ddpx_csi_txn_rec.transaction_uom_code := p6_a15;
754 ddpx_csi_txn_rec.transacted_by := rosetta_g_miss_num_map(p6_a16);
755 ddpx_csi_txn_rec.transaction_status_code := p6_a17;
756 ddpx_csi_txn_rec.transaction_action_code := p6_a18;
757 ddpx_csi_txn_rec.message_id := rosetta_g_miss_num_map(p6_a19);
758 ddpx_csi_txn_rec.context := p6_a20;
759 ddpx_csi_txn_rec.attribute1 := p6_a21;
760 ddpx_csi_txn_rec.attribute2 := p6_a22;
761 ddpx_csi_txn_rec.attribute3 := p6_a23;
762 ddpx_csi_txn_rec.attribute4 := p6_a24;
763 ddpx_csi_txn_rec.attribute5 := p6_a25;
764 ddpx_csi_txn_rec.attribute6 := p6_a26;
765 ddpx_csi_txn_rec.attribute7 := p6_a27;
766 ddpx_csi_txn_rec.attribute8 := p6_a28;
767 ddpx_csi_txn_rec.attribute9 := p6_a29;
768 ddpx_csi_txn_rec.attribute10 := p6_a30;
769 ddpx_csi_txn_rec.attribute11 := p6_a31;
770 ddpx_csi_txn_rec.attribute12 := p6_a32;
771 ddpx_csi_txn_rec.attribute13 := p6_a33;
772 ddpx_csi_txn_rec.attribute14 := p6_a34;
773 ddpx_csi_txn_rec.attribute15 := p6_a35;
774 ddpx_csi_txn_rec.object_version_number := rosetta_g_miss_num_map(p6_a36);
775 ddpx_csi_txn_rec.split_reason_code := p6_a37;
776 ddpx_csi_txn_rec.src_txn_creation_date := rosetta_g_miss_date_in_map(p6_a38);
777 ddpx_csi_txn_rec.gl_interface_status_code := rosetta_g_miss_num_map(p6_a39);
778
779
780
781
782
783 -- here's the delegated call to the old PL/SQL routine
784 csi_fa_instance_grp.create_item_instance(ddp_fixed_asset_rec,
785 ddp_eam_rec,
786 ddp_instance_rec,
787 ddp_instance_serial_tbl,
788 ddp_party_tbl,
789 ddp_party_account_tbl,
790 ddpx_csi_txn_rec,
791 ddx_instance_tbl,
792 ddx_instance_asset_tbl,
793 x_return_status,
794 x_error_message);
795
796 -- copy data back from the local variables to OUT or IN-OUT args, if any
797
798
799
800
801
802
803 p6_a0 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_id);
804 p6_a1 := ddpx_csi_txn_rec.transaction_date;
805 p6_a2 := ddpx_csi_txn_rec.source_transaction_date;
806 p6_a3 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_type_id);
807 p6_a4 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.txn_sub_type_id);
808 p6_a5 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_group_ref_id);
809 p6_a6 := ddpx_csi_txn_rec.source_group_ref;
810 p6_a7 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_header_ref_id);
811 p6_a8 := ddpx_csi_txn_rec.source_header_ref;
812 p6_a9 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_line_ref_id);
813 p6_a10 := ddpx_csi_txn_rec.source_line_ref;
817 p6_a14 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_quantity);
814 p6_a11 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_dist_ref_id1);
815 p6_a12 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_dist_ref_id2);
816 p6_a13 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.inv_material_transaction_id);
818 p6_a15 := ddpx_csi_txn_rec.transaction_uom_code;
819 p6_a16 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transacted_by);
820 p6_a17 := ddpx_csi_txn_rec.transaction_status_code;
821 p6_a18 := ddpx_csi_txn_rec.transaction_action_code;
822 p6_a19 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.message_id);
823 p6_a20 := ddpx_csi_txn_rec.context;
824 p6_a21 := ddpx_csi_txn_rec.attribute1;
825 p6_a22 := ddpx_csi_txn_rec.attribute2;
826 p6_a23 := ddpx_csi_txn_rec.attribute3;
827 p6_a24 := ddpx_csi_txn_rec.attribute4;
828 p6_a25 := ddpx_csi_txn_rec.attribute5;
829 p6_a26 := ddpx_csi_txn_rec.attribute6;
830 p6_a27 := ddpx_csi_txn_rec.attribute7;
831 p6_a28 := ddpx_csi_txn_rec.attribute8;
832 p6_a29 := ddpx_csi_txn_rec.attribute9;
833 p6_a30 := ddpx_csi_txn_rec.attribute10;
834 p6_a31 := ddpx_csi_txn_rec.attribute11;
835 p6_a32 := ddpx_csi_txn_rec.attribute12;
836 p6_a33 := ddpx_csi_txn_rec.attribute13;
837 p6_a34 := ddpx_csi_txn_rec.attribute14;
838 p6_a35 := ddpx_csi_txn_rec.attribute15;
839 p6_a36 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.object_version_number);
840 p6_a37 := ddpx_csi_txn_rec.split_reason_code;
841 p6_a38 := ddpx_csi_txn_rec.src_txn_creation_date;
842 p6_a39 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.gl_interface_status_code);
843
844 csi_datastructures_pub_w.rosetta_table_copy_out_p19(ddx_instance_tbl, p7_a0
845 , p7_a1
846 , p7_a2
847 , p7_a3
848 , p7_a4
849 , p7_a5
850 , p7_a6
851 , p7_a7
852 , p7_a8
853 , p7_a9
854 , p7_a10
855 , p7_a11
856 , p7_a12
857 , p7_a13
858 , p7_a14
859 , p7_a15
860 , p7_a16
861 , p7_a17
862 , p7_a18
863 , p7_a19
864 , p7_a20
865 , p7_a21
866 , p7_a22
867 , p7_a23
868 , p7_a24
869 , p7_a25
870 , p7_a26
871 , p7_a27
872 , p7_a28
873 , p7_a29
874 , p7_a30
875 , p7_a31
876 , p7_a32
877 , p7_a33
878 , p7_a34
879 , p7_a35
880 , p7_a36
881 , p7_a37
882 , p7_a38
883 , p7_a39
884 , p7_a40
885 , p7_a41
886 , p7_a42
887 , p7_a43
888 , p7_a44
889 , p7_a45
890 , p7_a46
891 , p7_a47
892 , p7_a48
893 , p7_a49
894 , p7_a50
895 , p7_a51
896 , p7_a52
897 , p7_a53
898 , p7_a54
899 , p7_a55
900 , p7_a56
901 , p7_a57
902 , p7_a58
903 , p7_a59
904 , p7_a60
905 , p7_a61
906 , p7_a62
907 , p7_a63
908 , p7_a64
909 , p7_a65
910 , p7_a66
911 , p7_a67
912 , p7_a68
913 , p7_a69
914 , p7_a70
915 , p7_a71
916 , p7_a72
917 , p7_a73
918 , p7_a74
919 , p7_a75
920 , p7_a76
921 , p7_a77
922 , p7_a78
923 , p7_a79
924 , p7_a80
925 , p7_a81
926 , p7_a82
927 , p7_a83
928 , p7_a84
929 , p7_a85
930 , p7_a86
931 , p7_a87
932 , p7_a88
933 , p7_a89
934 , p7_a90
935 , p7_a91
936 , p7_a92
937 , p7_a93
938 , p7_a94
939 , p7_a95
940 , p7_a96
941 , p7_a97
942 , p7_a98
943 , p7_a99
944 , p7_a100
945 , p7_a101
946 , p7_a102
947 , p7_a103
948 , p7_a104
949 , p7_a105
950 , p7_a106
951 , p7_a107
952 , p7_a108
953 , p7_a109
954 , p7_a110
955 , p7_a111
956 , p7_a112
957 , p7_a113
958 , p7_a114
959 , p7_a115
960 , p7_a116
961 , p7_a117
962 , p7_a118
963 , p7_a119
964 , p7_a120
965 , p7_a121
966 , p7_a122
967 );
968
969 csi_datastructures_pub_w.rosetta_table_copy_out_p52(ddx_instance_asset_tbl, p8_a0
970 , p8_a1
971 , p8_a2
972 , p8_a3
973 , p8_a4
974 , p8_a5
975 , p8_a6
976 , p8_a7
977 , p8_a8
978 , p8_a9
979 , p8_a10
980 , p8_a11
981 , p8_a12
982 , p8_a13
983 , p8_a14
984 , p8_a15
985 );
986
987
988 end;
989
990 procedure copy_item_instance(p2_a0 JTF_VARCHAR2_TABLE_100
991 , p2_a1 JTF_VARCHAR2_TABLE_100
992 , p2_a2 JTF_VARCHAR2_TABLE_100
993 , p2_a3 JTF_VARCHAR2_TABLE_100
994 , p2_a4 JTF_VARCHAR2_TABLE_100
998 , p_copy_accounts VARCHAR2
995 , p2_a5 JTF_VARCHAR2_TABLE_300
996 , p2_a6 JTF_VARCHAR2_TABLE_100
997 , p_copy_parties VARCHAR2
999 , p_copy_contacts VARCHAR2
1000 , p_copy_org_assignments VARCHAR2
1001 , p_copy_asset_assignments VARCHAR2
1002 , p_copy_pricing_attribs VARCHAR2
1003 , p_copy_ext_attribs VARCHAR2
1004 , p_copy_inst_children VARCHAR2
1005 , p12_a0 in out nocopy NUMBER
1006 , p12_a1 in out nocopy DATE
1007 , p12_a2 in out nocopy DATE
1008 , p12_a3 in out nocopy NUMBER
1009 , p12_a4 in out nocopy NUMBER
1010 , p12_a5 in out nocopy NUMBER
1011 , p12_a6 in out nocopy VARCHAR2
1012 , p12_a7 in out nocopy NUMBER
1013 , p12_a8 in out nocopy VARCHAR2
1014 , p12_a9 in out nocopy NUMBER
1015 , p12_a10 in out nocopy VARCHAR2
1016 , p12_a11 in out nocopy NUMBER
1017 , p12_a12 in out nocopy NUMBER
1018 , p12_a13 in out nocopy NUMBER
1019 , p12_a14 in out nocopy NUMBER
1020 , p12_a15 in out nocopy VARCHAR2
1021 , p12_a16 in out nocopy NUMBER
1022 , p12_a17 in out nocopy VARCHAR2
1023 , p12_a18 in out nocopy VARCHAR2
1024 , p12_a19 in out nocopy NUMBER
1025 , p12_a20 in out nocopy VARCHAR2
1026 , p12_a21 in out nocopy VARCHAR2
1027 , p12_a22 in out nocopy VARCHAR2
1028 , p12_a23 in out nocopy VARCHAR2
1029 , p12_a24 in out nocopy VARCHAR2
1030 , p12_a25 in out nocopy VARCHAR2
1031 , p12_a26 in out nocopy VARCHAR2
1032 , p12_a27 in out nocopy VARCHAR2
1033 , p12_a28 in out nocopy VARCHAR2
1034 , p12_a29 in out nocopy VARCHAR2
1035 , p12_a30 in out nocopy VARCHAR2
1036 , p12_a31 in out nocopy VARCHAR2
1037 , p12_a32 in out nocopy VARCHAR2
1038 , p12_a33 in out nocopy VARCHAR2
1039 , p12_a34 in out nocopy VARCHAR2
1040 , p12_a35 in out nocopy VARCHAR2
1041 , p12_a36 in out nocopy NUMBER
1042 , p12_a37 in out nocopy VARCHAR2
1043 , p12_a38 in out nocopy DATE
1044 , p12_a39 in out nocopy NUMBER
1045 , p13_a0 out nocopy JTF_NUMBER_TABLE
1046 , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
1047 , p13_a2 out nocopy JTF_VARCHAR2_TABLE_100
1048 , p13_a3 out nocopy JTF_NUMBER_TABLE
1049 , p13_a4 out nocopy JTF_NUMBER_TABLE
1050 , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100
1051 , p13_a6 out nocopy JTF_NUMBER_TABLE
1052 , p13_a7 out nocopy JTF_VARCHAR2_TABLE_100
1053 , p13_a8 out nocopy JTF_VARCHAR2_TABLE_100
1054 , p13_a9 out nocopy JTF_VARCHAR2_TABLE_100
1055 , p13_a10 out nocopy JTF_NUMBER_TABLE
1056 , p13_a11 out nocopy JTF_VARCHAR2_TABLE_100
1057 , p13_a12 out nocopy JTF_VARCHAR2_TABLE_100
1058 , p13_a13 out nocopy JTF_NUMBER_TABLE
1059 , p13_a14 out nocopy JTF_NUMBER_TABLE
1060 , p13_a15 out nocopy JTF_VARCHAR2_TABLE_100
1061 , p13_a16 out nocopy JTF_VARCHAR2_TABLE_100
1062 , p13_a17 out nocopy JTF_VARCHAR2_TABLE_100
1063 , p13_a18 out nocopy JTF_NUMBER_TABLE
1064 , p13_a19 out nocopy JTF_VARCHAR2_TABLE_100
1065 , p13_a20 out nocopy JTF_DATE_TABLE
1066 , p13_a21 out nocopy JTF_DATE_TABLE
1067 , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
1068 , p13_a23 out nocopy JTF_NUMBER_TABLE
1069 , p13_a24 out nocopy JTF_NUMBER_TABLE
1070 , p13_a25 out nocopy JTF_VARCHAR2_TABLE_100
1071 , p13_a26 out nocopy JTF_NUMBER_TABLE
1072 , p13_a27 out nocopy JTF_NUMBER_TABLE
1073 , p13_a28 out nocopy JTF_NUMBER_TABLE
1074 , p13_a29 out nocopy JTF_NUMBER_TABLE
1075 , p13_a30 out nocopy JTF_NUMBER_TABLE
1076 , p13_a31 out nocopy JTF_NUMBER_TABLE
1077 , p13_a32 out nocopy JTF_NUMBER_TABLE
1078 , p13_a33 out nocopy JTF_NUMBER_TABLE
1079 , p13_a34 out nocopy JTF_NUMBER_TABLE
1080 , p13_a35 out nocopy JTF_VARCHAR2_TABLE_100
1081 , p13_a36 out nocopy JTF_NUMBER_TABLE
1082 , p13_a37 out nocopy JTF_NUMBER_TABLE
1083 , p13_a38 out nocopy JTF_NUMBER_TABLE
1084 , p13_a39 out nocopy JTF_NUMBER_TABLE
1085 , p13_a40 out nocopy JTF_DATE_TABLE
1086 , p13_a41 out nocopy JTF_VARCHAR2_TABLE_100
1087 , p13_a42 out nocopy JTF_DATE_TABLE
1088 , p13_a43 out nocopy JTF_DATE_TABLE
1089 , p13_a44 out nocopy JTF_VARCHAR2_TABLE_100
1090 , p13_a45 out nocopy JTF_VARCHAR2_TABLE_100
1091 , p13_a46 out nocopy JTF_VARCHAR2_TABLE_300
1092 , p13_a47 out nocopy JTF_VARCHAR2_TABLE_300
1093 , p13_a48 out nocopy JTF_VARCHAR2_TABLE_100
1094 , p13_a49 out nocopy JTF_VARCHAR2_TABLE_300
1095 , p13_a50 out nocopy JTF_VARCHAR2_TABLE_300
1096 , p13_a51 out nocopy JTF_VARCHAR2_TABLE_300
1097 , p13_a52 out nocopy JTF_VARCHAR2_TABLE_300
1098 , p13_a53 out nocopy JTF_VARCHAR2_TABLE_300
1099 , p13_a54 out nocopy JTF_VARCHAR2_TABLE_300
1100 , p13_a55 out nocopy JTF_VARCHAR2_TABLE_300
1101 , p13_a56 out nocopy JTF_VARCHAR2_TABLE_300
1102 , p13_a57 out nocopy JTF_VARCHAR2_TABLE_300
1103 , p13_a58 out nocopy JTF_VARCHAR2_TABLE_300
1104 , p13_a59 out nocopy JTF_VARCHAR2_TABLE_300
1105 , p13_a60 out nocopy JTF_VARCHAR2_TABLE_300
1106 , p13_a61 out nocopy JTF_VARCHAR2_TABLE_300
1107 , p13_a62 out nocopy JTF_VARCHAR2_TABLE_300
1108 , p13_a63 out nocopy JTF_VARCHAR2_TABLE_300
1109 , p13_a64 out nocopy JTF_NUMBER_TABLE
1110 , p13_a65 out nocopy JTF_NUMBER_TABLE
1111 , p13_a66 out nocopy JTF_VARCHAR2_TABLE_100
1112 , p13_a67 out nocopy JTF_NUMBER_TABLE
1113 , p13_a68 out nocopy JTF_VARCHAR2_TABLE_100
1114 , p13_a69 out nocopy JTF_VARCHAR2_TABLE_100
1115 , p13_a70 out nocopy JTF_VARCHAR2_TABLE_100
1116 , p13_a71 out nocopy JTF_VARCHAR2_TABLE_100
1120 , p13_a75 out nocopy JTF_NUMBER_TABLE
1117 , p13_a72 out nocopy JTF_NUMBER_TABLE
1118 , p13_a73 out nocopy JTF_VARCHAR2_TABLE_100
1119 , p13_a74 out nocopy JTF_NUMBER_TABLE
1121 , p13_a76 out nocopy JTF_NUMBER_TABLE
1122 , p13_a77 out nocopy JTF_VARCHAR2_TABLE_100
1123 , p13_a78 out nocopy JTF_VARCHAR2_TABLE_300
1124 , p13_a79 out nocopy JTF_VARCHAR2_TABLE_100
1125 , p13_a80 out nocopy JTF_NUMBER_TABLE
1126 , p13_a81 out nocopy JTF_NUMBER_TABLE
1127 , p13_a82 out nocopy JTF_NUMBER_TABLE
1128 , p13_a83 out nocopy JTF_DATE_TABLE
1129 , p13_a84 out nocopy JTF_VARCHAR2_TABLE_100
1130 , p13_a85 out nocopy JTF_VARCHAR2_TABLE_100
1131 , p13_a86 out nocopy JTF_VARCHAR2_TABLE_100
1132 , p13_a87 out nocopy JTF_NUMBER_TABLE
1133 , p13_a88 out nocopy JTF_VARCHAR2_TABLE_100
1134 , p13_a89 out nocopy JTF_NUMBER_TABLE
1135 , p13_a90 out nocopy JTF_NUMBER_TABLE
1136 , p13_a91 out nocopy JTF_VARCHAR2_TABLE_100
1137 , p13_a92 out nocopy JTF_NUMBER_TABLE
1138 , p13_a93 out nocopy JTF_VARCHAR2_TABLE_100
1139 , p13_a94 out nocopy JTF_NUMBER_TABLE
1140 , p13_a95 out nocopy JTF_DATE_TABLE
1141 , p13_a96 out nocopy JTF_VARCHAR2_TABLE_300
1142 , p13_a97 out nocopy JTF_VARCHAR2_TABLE_300
1143 , p13_a98 out nocopy JTF_VARCHAR2_TABLE_300
1144 , p13_a99 out nocopy JTF_VARCHAR2_TABLE_300
1145 , p13_a100 out nocopy JTF_VARCHAR2_TABLE_300
1146 , p13_a101 out nocopy JTF_VARCHAR2_TABLE_300
1147 , p13_a102 out nocopy JTF_VARCHAR2_TABLE_300
1148 , p13_a103 out nocopy JTF_VARCHAR2_TABLE_300
1149 , p13_a104 out nocopy JTF_VARCHAR2_TABLE_300
1150 , p13_a105 out nocopy JTF_VARCHAR2_TABLE_300
1151 , p13_a106 out nocopy JTF_VARCHAR2_TABLE_300
1152 , p13_a107 out nocopy JTF_VARCHAR2_TABLE_300
1153 , p13_a108 out nocopy JTF_VARCHAR2_TABLE_300
1154 , p13_a109 out nocopy JTF_VARCHAR2_TABLE_300
1155 , p13_a110 out nocopy JTF_VARCHAR2_TABLE_300
1156 , p13_a111 out nocopy JTF_NUMBER_TABLE
1157 , p13_a112 out nocopy JTF_VARCHAR2_TABLE_100
1158 , p13_a113 out nocopy JTF_NUMBER_TABLE
1159 , p13_a114 out nocopy JTF_VARCHAR2_TABLE_100
1160 , p13_a115 out nocopy JTF_NUMBER_TABLE
1161 , p13_a116 out nocopy JTF_VARCHAR2_TABLE_100
1162 , p13_a117 out nocopy JTF_VARCHAR2_TABLE_100
1163 , p13_a118 out nocopy JTF_NUMBER_TABLE
1164 , p13_a119 out nocopy JTF_VARCHAR2_TABLE_100
1165 , p13_a120 out nocopy JTF_NUMBER_TABLE
1166 , p13_a121 out nocopy JTF_NUMBER_TABLE
1167 , p13_a122 out nocopy JTF_VARCHAR2_TABLE_100
1168 , p14_a0 out nocopy JTF_NUMBER_TABLE
1169 , p14_a1 out nocopy JTF_NUMBER_TABLE
1170 , p14_a2 out nocopy JTF_NUMBER_TABLE
1171 , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
1172 , p14_a4 out nocopy JTF_NUMBER_TABLE
1173 , p14_a5 out nocopy JTF_NUMBER_TABLE
1174 , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
1175 , p14_a7 out nocopy JTF_DATE_TABLE
1176 , p14_a8 out nocopy JTF_DATE_TABLE
1177 , p14_a9 out nocopy JTF_NUMBER_TABLE
1178 , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100
1179 , p14_a11 out nocopy JTF_NUMBER_TABLE
1180 , p14_a12 out nocopy JTF_VARCHAR2_TABLE_100
1181 , p14_a13 out nocopy JTF_NUMBER_TABLE
1182 , p14_a14 out nocopy JTF_VARCHAR2_TABLE_100
1183 , p14_a15 out nocopy JTF_VARCHAR2_TABLE_100
1184 , x_return_status out nocopy VARCHAR2
1185 , x_error_message out nocopy VARCHAR2
1186 , p0_a0 NUMBER := 0-1962.0724
1187 , p0_a1 VARCHAR2 := fnd_api.g_miss_char
1188 , p0_a2 NUMBER := 0-1962.0724
1189 , p0_a3 NUMBER := 0-1962.0724
1190 , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1191 , p0_a5 VARCHAR2 := fnd_api.g_miss_char
1192 , p1_a0 NUMBER := 0-1962.0724
1193 , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1194 , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1195 , p1_a3 NUMBER := 0-1962.0724
1196 , p1_a4 NUMBER := 0-1962.0724
1197 , p1_a5 VARCHAR2 := fnd_api.g_miss_char
1198 , p1_a6 NUMBER := 0-1962.0724
1199 , p1_a7 VARCHAR2 := fnd_api.g_miss_char
1200 , p1_a8 VARCHAR2 := fnd_api.g_miss_char
1201 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
1202 , p1_a10 NUMBER := 0-1962.0724
1203 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
1204 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
1205 , p1_a13 NUMBER := 0-1962.0724
1206 , p1_a14 NUMBER := 0-1962.0724
1207 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
1208 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
1209 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
1210 , p1_a18 NUMBER := 0-1962.0724
1211 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
1212 , p1_a20 DATE := fnd_api.g_miss_date
1213 , p1_a21 DATE := fnd_api.g_miss_date
1214 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
1215 , p1_a23 NUMBER := 0-1962.0724
1216 , p1_a24 NUMBER := 0-1962.0724
1217 , p1_a25 VARCHAR2 := fnd_api.g_miss_char
1218 , p1_a26 NUMBER := 0-1962.0724
1219 , p1_a27 NUMBER := 0-1962.0724
1220 , p1_a28 NUMBER := 0-1962.0724
1221 , p1_a29 NUMBER := 0-1962.0724
1222 , p1_a30 NUMBER := 0-1962.0724
1223 , p1_a31 NUMBER := 0-1962.0724
1224 , p1_a32 NUMBER := 0-1962.0724
1225 , p1_a33 NUMBER := 0-1962.0724
1226 , p1_a34 NUMBER := 0-1962.0724
1227 , p1_a35 VARCHAR2 := fnd_api.g_miss_char
1228 , p1_a36 NUMBER := 0-1962.0724
1229 , p1_a37 NUMBER := 0-1962.0724
1230 , p1_a38 NUMBER := 0-1962.0724
1231 , p1_a39 NUMBER := 0-1962.0724
1232 , p1_a40 DATE := fnd_api.g_miss_date
1236 , p1_a44 VARCHAR2 := fnd_api.g_miss_char
1233 , p1_a41 VARCHAR2 := fnd_api.g_miss_char
1234 , p1_a42 DATE := fnd_api.g_miss_date
1235 , p1_a43 DATE := fnd_api.g_miss_date
1237 , p1_a45 VARCHAR2 := fnd_api.g_miss_char
1238 , p1_a46 VARCHAR2 := fnd_api.g_miss_char
1239 , p1_a47 VARCHAR2 := fnd_api.g_miss_char
1240 , p1_a48 VARCHAR2 := fnd_api.g_miss_char
1241 , p1_a49 VARCHAR2 := fnd_api.g_miss_char
1242 , p1_a50 VARCHAR2 := fnd_api.g_miss_char
1243 , p1_a51 VARCHAR2 := fnd_api.g_miss_char
1244 , p1_a52 VARCHAR2 := fnd_api.g_miss_char
1245 , p1_a53 VARCHAR2 := fnd_api.g_miss_char
1246 , p1_a54 VARCHAR2 := fnd_api.g_miss_char
1247 , p1_a55 VARCHAR2 := fnd_api.g_miss_char
1248 , p1_a56 VARCHAR2 := fnd_api.g_miss_char
1249 , p1_a57 VARCHAR2 := fnd_api.g_miss_char
1250 , p1_a58 VARCHAR2 := fnd_api.g_miss_char
1251 , p1_a59 VARCHAR2 := fnd_api.g_miss_char
1252 , p1_a60 VARCHAR2 := fnd_api.g_miss_char
1253 , p1_a61 VARCHAR2 := fnd_api.g_miss_char
1254 , p1_a62 VARCHAR2 := fnd_api.g_miss_char
1255 , p1_a63 VARCHAR2 := fnd_api.g_miss_char
1256 , p1_a64 NUMBER := 0-1962.0724
1257 , p1_a65 NUMBER := 0-1962.0724
1258 , p1_a66 VARCHAR2 := fnd_api.g_miss_char
1259 , p1_a67 NUMBER := 0-1962.0724
1260 , p1_a68 VARCHAR2 := fnd_api.g_miss_char
1261 , p1_a69 VARCHAR2 := fnd_api.g_miss_char
1262 , p1_a70 VARCHAR2 := fnd_api.g_miss_char
1263 , p1_a71 VARCHAR2 := fnd_api.g_miss_char
1264 , p1_a72 NUMBER := 0-1962.0724
1265 , p1_a73 VARCHAR2 := fnd_api.g_miss_char
1266 , p1_a74 NUMBER := 0-1962.0724
1267 , p1_a75 NUMBER := 0-1962.0724
1268 , p1_a76 NUMBER := 0-1962.0724
1269 , p1_a77 VARCHAR2 := fnd_api.g_miss_char
1270 , p1_a78 VARCHAR2 := fnd_api.g_miss_char
1271 , p1_a79 VARCHAR2 := fnd_api.g_miss_char
1272 , p1_a80 NUMBER := 0-1962.0724
1273 , p1_a81 NUMBER := 0-1962.0724
1274 , p1_a82 NUMBER := 0-1962.0724
1275 , p1_a83 DATE := fnd_api.g_miss_date
1276 , p1_a84 VARCHAR2 := fnd_api.g_miss_char
1277 , p1_a85 VARCHAR2 := fnd_api.g_miss_char
1278 , p1_a86 VARCHAR2 := fnd_api.g_miss_char
1279 , p1_a87 NUMBER := 0-1962.0724
1280 , p1_a88 VARCHAR2 := fnd_api.g_miss_char
1281 , p1_a89 NUMBER := 0-1962.0724
1282 , p1_a90 NUMBER := 0-1962.0724
1283 , p1_a91 VARCHAR2 := fnd_api.g_miss_char
1284 , p1_a92 NUMBER := 0-1962.0724
1285 , p1_a93 VARCHAR2 := fnd_api.g_miss_char
1286 , p1_a94 NUMBER := 0-1962.0724
1287 , p1_a95 DATE := fnd_api.g_miss_date
1288 , p1_a96 VARCHAR2 := fnd_api.g_miss_char
1289 , p1_a97 VARCHAR2 := fnd_api.g_miss_char
1290 , p1_a98 VARCHAR2 := fnd_api.g_miss_char
1291 , p1_a99 VARCHAR2 := fnd_api.g_miss_char
1292 , p1_a100 VARCHAR2 := fnd_api.g_miss_char
1293 , p1_a101 VARCHAR2 := fnd_api.g_miss_char
1294 , p1_a102 VARCHAR2 := fnd_api.g_miss_char
1295 , p1_a103 VARCHAR2 := fnd_api.g_miss_char
1296 , p1_a104 VARCHAR2 := fnd_api.g_miss_char
1297 , p1_a105 VARCHAR2 := fnd_api.g_miss_char
1298 , p1_a106 VARCHAR2 := fnd_api.g_miss_char
1299 , p1_a107 VARCHAR2 := fnd_api.g_miss_char
1300 , p1_a108 VARCHAR2 := fnd_api.g_miss_char
1301 , p1_a109 VARCHAR2 := fnd_api.g_miss_char
1302 , p1_a110 VARCHAR2 := fnd_api.g_miss_char
1303 , p1_a111 NUMBER := 0-1962.0724
1304 , p1_a112 VARCHAR2 := fnd_api.g_miss_char
1305 , p1_a113 NUMBER := 0-1962.0724
1306 , p1_a114 VARCHAR2 := fnd_api.g_miss_char
1307 , p1_a115 NUMBER := 0-1962.0724
1308 , p1_a116 VARCHAR2 := fnd_api.g_miss_char
1309 , p1_a117 VARCHAR2 := fnd_api.g_miss_char
1310 , p1_a118 NUMBER := 0-1962.0724
1311 , p1_a119 VARCHAR2 := fnd_api.g_miss_char
1312 , p1_a120 NUMBER := 0-1962.0724
1313 , p1_a121 NUMBER := 0-1962.0724
1314 , p1_a122 VARCHAR2 := fnd_api.g_miss_char
1315 , p3_a0 NUMBER := 0-1962.0724
1316 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
1317 , p3_a2 NUMBER := 0-1962.0724
1318 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1319 , p3_a4 NUMBER := 0-1962.0724
1320 , p3_a5 NUMBER := 0-1962.0724
1321 )
1322
1323 as
1324 ddp_fixed_asset_rec csi_fa_instance_grp.fixed_asset_rec;
1325 ddp_instance_rec csi_datastructures_pub.instance_rec;
1326 ddp_instance_serial_tbl csi_fa_instance_grp.instance_serial_tbl;
1327 ddp_eam_rec csi_fa_instance_grp.eam_rec;
1328 ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
1329 ddx_instance_tbl csi_datastructures_pub.instance_tbl;
1330 ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1331 ddindx binary_integer; indx binary_integer;
1332 begin
1333
1334 -- copy data to the local IN or IN-OUT args, if any
1335 ddp_fixed_asset_rec.asset_id := rosetta_g_miss_num_map(p0_a0);
1336 ddp_fixed_asset_rec.book_type_code := p0_a1;
1337 ddp_fixed_asset_rec.asset_location_id := rosetta_g_miss_num_map(p0_a2);
1338 ddp_fixed_asset_rec.asset_quantity := rosetta_g_miss_num_map(p0_a3);
1339 ddp_fixed_asset_rec.fa_sync_flag := p0_a4;
1340 ddp_fixed_asset_rec.fa_sync_validation_reqd := p0_a5;
1341
1342 ddp_instance_rec.instance_id := rosetta_g_miss_num_map(p1_a0);
1343 ddp_instance_rec.instance_number := p1_a1;
1344 ddp_instance_rec.external_reference := p1_a2;
1345 ddp_instance_rec.inventory_item_id := rosetta_g_miss_num_map(p1_a3);
1346 ddp_instance_rec.vld_organization_id := rosetta_g_miss_num_map(p1_a4);
1347 ddp_instance_rec.inventory_revision := p1_a5;
1351 ddp_instance_rec.lot_number := p1_a9;
1348 ddp_instance_rec.inv_master_organization_id := rosetta_g_miss_num_map(p1_a6);
1349 ddp_instance_rec.serial_number := p1_a7;
1350 ddp_instance_rec.mfg_serial_number_flag := p1_a8;
1352 ddp_instance_rec.quantity := rosetta_g_miss_num_map(p1_a10);
1353 ddp_instance_rec.unit_of_measure := p1_a11;
1354 ddp_instance_rec.accounting_class_code := p1_a12;
1355 ddp_instance_rec.instance_condition_id := rosetta_g_miss_num_map(p1_a13);
1356 ddp_instance_rec.instance_status_id := rosetta_g_miss_num_map(p1_a14);
1357 ddp_instance_rec.customer_view_flag := p1_a15;
1358 ddp_instance_rec.merchant_view_flag := p1_a16;
1359 ddp_instance_rec.sellable_flag := p1_a17;
1360 ddp_instance_rec.system_id := rosetta_g_miss_num_map(p1_a18);
1361 ddp_instance_rec.instance_type_code := p1_a19;
1362 ddp_instance_rec.active_start_date := rosetta_g_miss_date_in_map(p1_a20);
1363 ddp_instance_rec.active_end_date := rosetta_g_miss_date_in_map(p1_a21);
1364 ddp_instance_rec.location_type_code := p1_a22;
1365 ddp_instance_rec.location_id := rosetta_g_miss_num_map(p1_a23);
1366 ddp_instance_rec.inv_organization_id := rosetta_g_miss_num_map(p1_a24);
1367 ddp_instance_rec.inv_subinventory_name := p1_a25;
1368 ddp_instance_rec.inv_locator_id := rosetta_g_miss_num_map(p1_a26);
1369 ddp_instance_rec.pa_project_id := rosetta_g_miss_num_map(p1_a27);
1370 ddp_instance_rec.pa_project_task_id := rosetta_g_miss_num_map(p1_a28);
1371 ddp_instance_rec.in_transit_order_line_id := rosetta_g_miss_num_map(p1_a29);
1372 ddp_instance_rec.wip_job_id := rosetta_g_miss_num_map(p1_a30);
1373 ddp_instance_rec.po_order_line_id := rosetta_g_miss_num_map(p1_a31);
1374 ddp_instance_rec.last_oe_order_line_id := rosetta_g_miss_num_map(p1_a32);
1375 ddp_instance_rec.last_oe_rma_line_id := rosetta_g_miss_num_map(p1_a33);
1376 ddp_instance_rec.last_po_po_line_id := rosetta_g_miss_num_map(p1_a34);
1377 ddp_instance_rec.last_oe_po_number := p1_a35;
1378 ddp_instance_rec.last_wip_job_id := rosetta_g_miss_num_map(p1_a36);
1379 ddp_instance_rec.last_pa_project_id := rosetta_g_miss_num_map(p1_a37);
1380 ddp_instance_rec.last_pa_task_id := rosetta_g_miss_num_map(p1_a38);
1381 ddp_instance_rec.last_oe_agreement_id := rosetta_g_miss_num_map(p1_a39);
1382 ddp_instance_rec.install_date := rosetta_g_miss_date_in_map(p1_a40);
1383 ddp_instance_rec.manually_created_flag := p1_a41;
1384 ddp_instance_rec.return_by_date := rosetta_g_miss_date_in_map(p1_a42);
1385 ddp_instance_rec.actual_return_date := rosetta_g_miss_date_in_map(p1_a43);
1386 ddp_instance_rec.creation_complete_flag := p1_a44;
1387 ddp_instance_rec.completeness_flag := p1_a45;
1388 ddp_instance_rec.version_label := p1_a46;
1389 ddp_instance_rec.version_label_description := p1_a47;
1390 ddp_instance_rec.context := p1_a48;
1391 ddp_instance_rec.attribute1 := p1_a49;
1392 ddp_instance_rec.attribute2 := p1_a50;
1393 ddp_instance_rec.attribute3 := p1_a51;
1394 ddp_instance_rec.attribute4 := p1_a52;
1395 ddp_instance_rec.attribute5 := p1_a53;
1396 ddp_instance_rec.attribute6 := p1_a54;
1397 ddp_instance_rec.attribute7 := p1_a55;
1398 ddp_instance_rec.attribute8 := p1_a56;
1399 ddp_instance_rec.attribute9 := p1_a57;
1400 ddp_instance_rec.attribute10 := p1_a58;
1401 ddp_instance_rec.attribute11 := p1_a59;
1402 ddp_instance_rec.attribute12 := p1_a60;
1403 ddp_instance_rec.attribute13 := p1_a61;
1404 ddp_instance_rec.attribute14 := p1_a62;
1405 ddp_instance_rec.attribute15 := p1_a63;
1406 ddp_instance_rec.object_version_number := rosetta_g_miss_num_map(p1_a64);
1407 ddp_instance_rec.last_txn_line_detail_id := rosetta_g_miss_num_map(p1_a65);
1408 ddp_instance_rec.install_location_type_code := p1_a66;
1409 ddp_instance_rec.install_location_id := rosetta_g_miss_num_map(p1_a67);
1410 ddp_instance_rec.instance_usage_code := p1_a68;
1411 ddp_instance_rec.check_for_instance_expiry := p1_a69;
1412 ddp_instance_rec.processed_flag := p1_a70;
1413 ddp_instance_rec.call_contracts := p1_a71;
1414 ddp_instance_rec.interface_id := rosetta_g_miss_num_map(p1_a72);
1415 ddp_instance_rec.grp_call_contracts := p1_a73;
1416 ddp_instance_rec.config_inst_hdr_id := rosetta_g_miss_num_map(p1_a74);
1417 ddp_instance_rec.config_inst_rev_num := rosetta_g_miss_num_map(p1_a75);
1418 ddp_instance_rec.config_inst_item_id := rosetta_g_miss_num_map(p1_a76);
1419 ddp_instance_rec.config_valid_status := p1_a77;
1420 ddp_instance_rec.instance_description := p1_a78;
1421 ddp_instance_rec.call_batch_validation := p1_a79;
1422 ddp_instance_rec.request_id := rosetta_g_miss_num_map(p1_a80);
1423 ddp_instance_rec.program_application_id := rosetta_g_miss_num_map(p1_a81);
1424 ddp_instance_rec.program_id := rosetta_g_miss_num_map(p1_a82);
1425 ddp_instance_rec.program_update_date := rosetta_g_miss_date_in_map(p1_a83);
1426 ddp_instance_rec.cascade_ownership_flag := p1_a84;
1427 ddp_instance_rec.network_asset_flag := p1_a85;
1428 ddp_instance_rec.maintainable_flag := p1_a86;
1429 ddp_instance_rec.pn_location_id := rosetta_g_miss_num_map(p1_a87);
1430 ddp_instance_rec.asset_criticality_code := p1_a88;
1431 ddp_instance_rec.category_id := rosetta_g_miss_num_map(p1_a89);
1432 ddp_instance_rec.equipment_gen_object_id := rosetta_g_miss_num_map(p1_a90);
1433 ddp_instance_rec.instantiation_flag := p1_a91;
1434 ddp_instance_rec.linear_location_id := rosetta_g_miss_num_map(p1_a92);
1435 ddp_instance_rec.operational_log_flag := p1_a93;
1439 ddp_instance_rec.attribute17 := p1_a97;
1436 ddp_instance_rec.checkin_status := rosetta_g_miss_num_map(p1_a94);
1437 ddp_instance_rec.supplier_warranty_exp_date := rosetta_g_miss_date_in_map(p1_a95);
1438 ddp_instance_rec.attribute16 := p1_a96;
1440 ddp_instance_rec.attribute18 := p1_a98;
1441 ddp_instance_rec.attribute19 := p1_a99;
1442 ddp_instance_rec.attribute20 := p1_a100;
1443 ddp_instance_rec.attribute21 := p1_a101;
1444 ddp_instance_rec.attribute22 := p1_a102;
1445 ddp_instance_rec.attribute23 := p1_a103;
1446 ddp_instance_rec.attribute24 := p1_a104;
1447 ddp_instance_rec.attribute25 := p1_a105;
1448 ddp_instance_rec.attribute26 := p1_a106;
1449 ddp_instance_rec.attribute27 := p1_a107;
1450 ddp_instance_rec.attribute28 := p1_a108;
1451 ddp_instance_rec.attribute29 := p1_a109;
1452 ddp_instance_rec.attribute30 := p1_a110;
1453 ddp_instance_rec.purchase_unit_price := rosetta_g_miss_num_map(p1_a111);
1454 ddp_instance_rec.purchase_currency_code := p1_a112;
1455 ddp_instance_rec.payables_unit_price := rosetta_g_miss_num_map(p1_a113);
1456 ddp_instance_rec.payables_currency_code := p1_a114;
1457 ddp_instance_rec.sales_unit_price := rosetta_g_miss_num_map(p1_a115);
1458 ddp_instance_rec.sales_currency_code := p1_a116;
1459 ddp_instance_rec.operational_status_code := p1_a117;
1460 ddp_instance_rec.department_id := rosetta_g_miss_num_map(p1_a118);
1461 ddp_instance_rec.wip_accounting_class := p1_a119;
1462 ddp_instance_rec.area_id := rosetta_g_miss_num_map(p1_a120);
1463 ddp_instance_rec.owner_party_id := rosetta_g_miss_num_map(p1_a121);
1464 ddp_instance_rec.source_code := p1_a122;
1465
1466 csi_fa_instance_grp_w.rosetta_table_copy_in_p4(ddp_instance_serial_tbl, p2_a0
1467 , p2_a1
1468 , p2_a2
1469 , p2_a3
1470 , p2_a4
1471 , p2_a5
1472 , p2_a6
1473 );
1474
1475 ddp_eam_rec.category_id := rosetta_g_miss_num_map(p3_a0);
1476 ddp_eam_rec.asset_criticality_code := p3_a1;
1477 ddp_eam_rec.owning_department_id := rosetta_g_miss_num_map(p3_a2);
1478 ddp_eam_rec.wip_accounting_class_code := p3_a3;
1479 ddp_eam_rec.area_id := rosetta_g_miss_num_map(p3_a4);
1480 ddp_eam_rec.parent_instance_id := rosetta_g_miss_num_map(p3_a5);
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490 ddpx_csi_txn_rec.transaction_id := rosetta_g_miss_num_map(p12_a0);
1491 ddpx_csi_txn_rec.transaction_date := rosetta_g_miss_date_in_map(p12_a1);
1492 ddpx_csi_txn_rec.source_transaction_date := rosetta_g_miss_date_in_map(p12_a2);
1493 ddpx_csi_txn_rec.transaction_type_id := rosetta_g_miss_num_map(p12_a3);
1494 ddpx_csi_txn_rec.txn_sub_type_id := rosetta_g_miss_num_map(p12_a4);
1495 ddpx_csi_txn_rec.source_group_ref_id := rosetta_g_miss_num_map(p12_a5);
1496 ddpx_csi_txn_rec.source_group_ref := p12_a6;
1497 ddpx_csi_txn_rec.source_header_ref_id := rosetta_g_miss_num_map(p12_a7);
1498 ddpx_csi_txn_rec.source_header_ref := p12_a8;
1499 ddpx_csi_txn_rec.source_line_ref_id := rosetta_g_miss_num_map(p12_a9);
1500 ddpx_csi_txn_rec.source_line_ref := p12_a10;
1501 ddpx_csi_txn_rec.source_dist_ref_id1 := rosetta_g_miss_num_map(p12_a11);
1502 ddpx_csi_txn_rec.source_dist_ref_id2 := rosetta_g_miss_num_map(p12_a12);
1503 ddpx_csi_txn_rec.inv_material_transaction_id := rosetta_g_miss_num_map(p12_a13);
1504 ddpx_csi_txn_rec.transaction_quantity := rosetta_g_miss_num_map(p12_a14);
1505 ddpx_csi_txn_rec.transaction_uom_code := p12_a15;
1506 ddpx_csi_txn_rec.transacted_by := rosetta_g_miss_num_map(p12_a16);
1507 ddpx_csi_txn_rec.transaction_status_code := p12_a17;
1508 ddpx_csi_txn_rec.transaction_action_code := p12_a18;
1509 ddpx_csi_txn_rec.message_id := rosetta_g_miss_num_map(p12_a19);
1510 ddpx_csi_txn_rec.context := p12_a20;
1511 ddpx_csi_txn_rec.attribute1 := p12_a21;
1512 ddpx_csi_txn_rec.attribute2 := p12_a22;
1513 ddpx_csi_txn_rec.attribute3 := p12_a23;
1514 ddpx_csi_txn_rec.attribute4 := p12_a24;
1515 ddpx_csi_txn_rec.attribute5 := p12_a25;
1516 ddpx_csi_txn_rec.attribute6 := p12_a26;
1517 ddpx_csi_txn_rec.attribute7 := p12_a27;
1518 ddpx_csi_txn_rec.attribute8 := p12_a28;
1519 ddpx_csi_txn_rec.attribute9 := p12_a29;
1520 ddpx_csi_txn_rec.attribute10 := p12_a30;
1521 ddpx_csi_txn_rec.attribute11 := p12_a31;
1522 ddpx_csi_txn_rec.attribute12 := p12_a32;
1523 ddpx_csi_txn_rec.attribute13 := p12_a33;
1524 ddpx_csi_txn_rec.attribute14 := p12_a34;
1525 ddpx_csi_txn_rec.attribute15 := p12_a35;
1526 ddpx_csi_txn_rec.object_version_number := rosetta_g_miss_num_map(p12_a36);
1527 ddpx_csi_txn_rec.split_reason_code := p12_a37;
1528 ddpx_csi_txn_rec.src_txn_creation_date := rosetta_g_miss_date_in_map(p12_a38);
1529 ddpx_csi_txn_rec.gl_interface_status_code := rosetta_g_miss_num_map(p12_a39);
1530
1531
1532
1533
1534
1535 -- here's the delegated call to the old PL/SQL routine
1536 csi_fa_instance_grp.copy_item_instance(ddp_fixed_asset_rec,
1537 ddp_instance_rec,
1538 ddp_instance_serial_tbl,
1539 ddp_eam_rec,
1540 p_copy_parties,
1541 p_copy_accounts,
1542 p_copy_contacts,
1543 p_copy_org_assignments,
1544 p_copy_asset_assignments,
1545 p_copy_pricing_attribs,
1546 p_copy_ext_attribs,
1547 p_copy_inst_children,
1551 x_return_status,
1548 ddpx_csi_txn_rec,
1549 ddx_instance_tbl,
1550 ddx_instance_asset_tbl,
1552 x_error_message);
1553
1554 -- copy data back from the local variables to OUT or IN-OUT args, if any
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567 p12_a0 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_id);
1568 p12_a1 := ddpx_csi_txn_rec.transaction_date;
1569 p12_a2 := ddpx_csi_txn_rec.source_transaction_date;
1570 p12_a3 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_type_id);
1571 p12_a4 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.txn_sub_type_id);
1572 p12_a5 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_group_ref_id);
1573 p12_a6 := ddpx_csi_txn_rec.source_group_ref;
1574 p12_a7 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_header_ref_id);
1575 p12_a8 := ddpx_csi_txn_rec.source_header_ref;
1576 p12_a9 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_line_ref_id);
1577 p12_a10 := ddpx_csi_txn_rec.source_line_ref;
1578 p12_a11 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_dist_ref_id1);
1579 p12_a12 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_dist_ref_id2);
1580 p12_a13 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.inv_material_transaction_id);
1581 p12_a14 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_quantity);
1582 p12_a15 := ddpx_csi_txn_rec.transaction_uom_code;
1583 p12_a16 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transacted_by);
1584 p12_a17 := ddpx_csi_txn_rec.transaction_status_code;
1585 p12_a18 := ddpx_csi_txn_rec.transaction_action_code;
1586 p12_a19 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.message_id);
1587 p12_a20 := ddpx_csi_txn_rec.context;
1588 p12_a21 := ddpx_csi_txn_rec.attribute1;
1589 p12_a22 := ddpx_csi_txn_rec.attribute2;
1590 p12_a23 := ddpx_csi_txn_rec.attribute3;
1591 p12_a24 := ddpx_csi_txn_rec.attribute4;
1592 p12_a25 := ddpx_csi_txn_rec.attribute5;
1593 p12_a26 := ddpx_csi_txn_rec.attribute6;
1594 p12_a27 := ddpx_csi_txn_rec.attribute7;
1595 p12_a28 := ddpx_csi_txn_rec.attribute8;
1596 p12_a29 := ddpx_csi_txn_rec.attribute9;
1597 p12_a30 := ddpx_csi_txn_rec.attribute10;
1598 p12_a31 := ddpx_csi_txn_rec.attribute11;
1599 p12_a32 := ddpx_csi_txn_rec.attribute12;
1600 p12_a33 := ddpx_csi_txn_rec.attribute13;
1601 p12_a34 := ddpx_csi_txn_rec.attribute14;
1602 p12_a35 := ddpx_csi_txn_rec.attribute15;
1603 p12_a36 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.object_version_number);
1604 p12_a37 := ddpx_csi_txn_rec.split_reason_code;
1605 p12_a38 := ddpx_csi_txn_rec.src_txn_creation_date;
1606 p12_a39 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.gl_interface_status_code);
1607
1608 csi_datastructures_pub_w.rosetta_table_copy_out_p19(ddx_instance_tbl, p13_a0
1609 , p13_a1
1610 , p13_a2
1611 , p13_a3
1612 , p13_a4
1613 , p13_a5
1614 , p13_a6
1615 , p13_a7
1616 , p13_a8
1617 , p13_a9
1618 , p13_a10
1619 , p13_a11
1620 , p13_a12
1621 , p13_a13
1622 , p13_a14
1623 , p13_a15
1624 , p13_a16
1625 , p13_a17
1626 , p13_a18
1627 , p13_a19
1628 , p13_a20
1629 , p13_a21
1630 , p13_a22
1631 , p13_a23
1632 , p13_a24
1633 , p13_a25
1634 , p13_a26
1635 , p13_a27
1636 , p13_a28
1637 , p13_a29
1638 , p13_a30
1639 , p13_a31
1640 , p13_a32
1641 , p13_a33
1642 , p13_a34
1643 , p13_a35
1644 , p13_a36
1645 , p13_a37
1646 , p13_a38
1647 , p13_a39
1648 , p13_a40
1649 , p13_a41
1650 , p13_a42
1651 , p13_a43
1652 , p13_a44
1653 , p13_a45
1654 , p13_a46
1655 , p13_a47
1656 , p13_a48
1657 , p13_a49
1658 , p13_a50
1659 , p13_a51
1660 , p13_a52
1661 , p13_a53
1662 , p13_a54
1663 , p13_a55
1664 , p13_a56
1665 , p13_a57
1666 , p13_a58
1667 , p13_a59
1668 , p13_a60
1669 , p13_a61
1670 , p13_a62
1671 , p13_a63
1672 , p13_a64
1673 , p13_a65
1674 , p13_a66
1675 , p13_a67
1676 , p13_a68
1677 , p13_a69
1678 , p13_a70
1679 , p13_a71
1680 , p13_a72
1681 , p13_a73
1682 , p13_a74
1683 , p13_a75
1684 , p13_a76
1685 , p13_a77
1686 , p13_a78
1687 , p13_a79
1688 , p13_a80
1689 , p13_a81
1690 , p13_a82
1691 , p13_a83
1692 , p13_a84
1693 , p13_a85
1694 , p13_a86
1695 , p13_a87
1696 , p13_a88
1697 , p13_a89
1698 , p13_a90
1699 , p13_a91
1700 , p13_a92
1701 , p13_a93
1702 , p13_a94
1703 , p13_a95
1704 , p13_a96
1705 , p13_a97
1706 , p13_a98
1707 , p13_a99
1708 , p13_a100
1709 , p13_a101
1710 , p13_a102
1711 , p13_a103
1715 , p13_a107
1712 , p13_a104
1713 , p13_a105
1714 , p13_a106
1716 , p13_a108
1717 , p13_a109
1718 , p13_a110
1719 , p13_a111
1720 , p13_a112
1721 , p13_a113
1722 , p13_a114
1723 , p13_a115
1724 , p13_a116
1725 , p13_a117
1726 , p13_a118
1727 , p13_a119
1728 , p13_a120
1729 , p13_a121
1730 , p13_a122
1731 );
1732
1733 csi_datastructures_pub_w.rosetta_table_copy_out_p52(ddx_instance_asset_tbl, p14_a0
1734 , p14_a1
1735 , p14_a2
1736 , p14_a3
1737 , p14_a4
1738 , p14_a5
1739 , p14_a6
1740 , p14_a7
1741 , p14_a8
1742 , p14_a9
1743 , p14_a10
1744 , p14_a11
1745 , p14_a12
1746 , p14_a13
1747 , p14_a14
1748 , p14_a15
1749 );
1750
1751
1752 end;
1753
1754 procedure associate_item_instance(p1_a0 JTF_NUMBER_TABLE
1755 , p1_a1 JTF_VARCHAR2_TABLE_100
1756 , p1_a2 JTF_VARCHAR2_TABLE_100
1757 , p1_a3 JTF_NUMBER_TABLE
1758 , p1_a4 JTF_NUMBER_TABLE
1759 , p1_a5 JTF_VARCHAR2_TABLE_100
1760 , p1_a6 JTF_NUMBER_TABLE
1761 , p1_a7 JTF_VARCHAR2_TABLE_100
1762 , p1_a8 JTF_VARCHAR2_TABLE_100
1763 , p1_a9 JTF_VARCHAR2_TABLE_100
1764 , p1_a10 JTF_NUMBER_TABLE
1765 , p1_a11 JTF_VARCHAR2_TABLE_100
1766 , p1_a12 JTF_VARCHAR2_TABLE_100
1767 , p1_a13 JTF_NUMBER_TABLE
1768 , p1_a14 JTF_NUMBER_TABLE
1769 , p1_a15 JTF_VARCHAR2_TABLE_100
1770 , p1_a16 JTF_VARCHAR2_TABLE_100
1771 , p1_a17 JTF_VARCHAR2_TABLE_100
1772 , p1_a18 JTF_NUMBER_TABLE
1773 , p1_a19 JTF_VARCHAR2_TABLE_100
1774 , p1_a20 JTF_DATE_TABLE
1775 , p1_a21 JTF_DATE_TABLE
1776 , p1_a22 JTF_VARCHAR2_TABLE_100
1777 , p1_a23 JTF_NUMBER_TABLE
1778 , p1_a24 JTF_NUMBER_TABLE
1779 , p1_a25 JTF_VARCHAR2_TABLE_100
1780 , p1_a26 JTF_NUMBER_TABLE
1781 , p1_a27 JTF_NUMBER_TABLE
1782 , p1_a28 JTF_NUMBER_TABLE
1783 , p1_a29 JTF_NUMBER_TABLE
1784 , p1_a30 JTF_NUMBER_TABLE
1785 , p1_a31 JTF_NUMBER_TABLE
1786 , p1_a32 JTF_NUMBER_TABLE
1787 , p1_a33 JTF_NUMBER_TABLE
1788 , p1_a34 JTF_NUMBER_TABLE
1789 , p1_a35 JTF_VARCHAR2_TABLE_100
1790 , p1_a36 JTF_NUMBER_TABLE
1791 , p1_a37 JTF_NUMBER_TABLE
1792 , p1_a38 JTF_NUMBER_TABLE
1793 , p1_a39 JTF_NUMBER_TABLE
1794 , p1_a40 JTF_DATE_TABLE
1795 , p1_a41 JTF_VARCHAR2_TABLE_100
1796 , p1_a42 JTF_DATE_TABLE
1797 , p1_a43 JTF_DATE_TABLE
1798 , p1_a44 JTF_VARCHAR2_TABLE_100
1799 , p1_a45 JTF_VARCHAR2_TABLE_100
1800 , p1_a46 JTF_VARCHAR2_TABLE_300
1801 , p1_a47 JTF_VARCHAR2_TABLE_300
1802 , p1_a48 JTF_VARCHAR2_TABLE_100
1803 , p1_a49 JTF_VARCHAR2_TABLE_300
1804 , p1_a50 JTF_VARCHAR2_TABLE_300
1805 , p1_a51 JTF_VARCHAR2_TABLE_300
1806 , p1_a52 JTF_VARCHAR2_TABLE_300
1807 , p1_a53 JTF_VARCHAR2_TABLE_300
1808 , p1_a54 JTF_VARCHAR2_TABLE_300
1809 , p1_a55 JTF_VARCHAR2_TABLE_300
1810 , p1_a56 JTF_VARCHAR2_TABLE_300
1811 , p1_a57 JTF_VARCHAR2_TABLE_300
1812 , p1_a58 JTF_VARCHAR2_TABLE_300
1813 , p1_a59 JTF_VARCHAR2_TABLE_300
1814 , p1_a60 JTF_VARCHAR2_TABLE_300
1815 , p1_a61 JTF_VARCHAR2_TABLE_300
1816 , p1_a62 JTF_VARCHAR2_TABLE_300
1817 , p1_a63 JTF_VARCHAR2_TABLE_300
1818 , p1_a64 JTF_NUMBER_TABLE
1819 , p1_a65 JTF_NUMBER_TABLE
1820 , p1_a66 JTF_VARCHAR2_TABLE_100
1821 , p1_a67 JTF_NUMBER_TABLE
1822 , p1_a68 JTF_VARCHAR2_TABLE_100
1823 , p1_a69 JTF_VARCHAR2_TABLE_100
1824 , p1_a70 JTF_VARCHAR2_TABLE_100
1825 , p1_a71 JTF_VARCHAR2_TABLE_100
1826 , p1_a72 JTF_NUMBER_TABLE
1827 , p1_a73 JTF_VARCHAR2_TABLE_100
1828 , p1_a74 JTF_NUMBER_TABLE
1829 , p1_a75 JTF_NUMBER_TABLE
1830 , p1_a76 JTF_NUMBER_TABLE
1831 , p1_a77 JTF_VARCHAR2_TABLE_100
1832 , p1_a78 JTF_VARCHAR2_TABLE_300
1833 , p1_a79 JTF_VARCHAR2_TABLE_100
1834 , p1_a80 JTF_NUMBER_TABLE
1835 , p1_a81 JTF_NUMBER_TABLE
1836 , p1_a82 JTF_NUMBER_TABLE
1837 , p1_a83 JTF_DATE_TABLE
1838 , p1_a84 JTF_VARCHAR2_TABLE_100
1839 , p1_a85 JTF_VARCHAR2_TABLE_100
1840 , p1_a86 JTF_VARCHAR2_TABLE_100
1841 , p1_a87 JTF_NUMBER_TABLE
1842 , p1_a88 JTF_VARCHAR2_TABLE_100
1843 , p1_a89 JTF_NUMBER_TABLE
1844 , p1_a90 JTF_NUMBER_TABLE
1845 , p1_a91 JTF_VARCHAR2_TABLE_100
1846 , p1_a92 JTF_NUMBER_TABLE
1847 , p1_a93 JTF_VARCHAR2_TABLE_100
1848 , p1_a94 JTF_NUMBER_TABLE
1849 , p1_a95 JTF_DATE_TABLE
1850 , p1_a96 JTF_VARCHAR2_TABLE_300
1851 , p1_a97 JTF_VARCHAR2_TABLE_300
1852 , p1_a98 JTF_VARCHAR2_TABLE_300
1853 , p1_a99 JTF_VARCHAR2_TABLE_300
1854 , p1_a100 JTF_VARCHAR2_TABLE_300
1855 , p1_a101 JTF_VARCHAR2_TABLE_300
1856 , p1_a102 JTF_VARCHAR2_TABLE_300
1857 , p1_a103 JTF_VARCHAR2_TABLE_300
1858 , p1_a104 JTF_VARCHAR2_TABLE_300
1859 , p1_a105 JTF_VARCHAR2_TABLE_300
1860 , p1_a106 JTF_VARCHAR2_TABLE_300
1861 , p1_a107 JTF_VARCHAR2_TABLE_300
1862 , p1_a108 JTF_VARCHAR2_TABLE_300
1863 , p1_a109 JTF_VARCHAR2_TABLE_300
1864 , p1_a110 JTF_VARCHAR2_TABLE_300
1865 , p1_a111 JTF_NUMBER_TABLE
1866 , p1_a112 JTF_VARCHAR2_TABLE_100
1867 , p1_a113 JTF_NUMBER_TABLE
1871 , p1_a117 JTF_VARCHAR2_TABLE_100
1868 , p1_a114 JTF_VARCHAR2_TABLE_100
1869 , p1_a115 JTF_NUMBER_TABLE
1870 , p1_a116 JTF_VARCHAR2_TABLE_100
1872 , p1_a118 JTF_NUMBER_TABLE
1873 , p1_a119 JTF_VARCHAR2_TABLE_100
1874 , p1_a120 JTF_NUMBER_TABLE
1875 , p1_a121 JTF_NUMBER_TABLE
1876 , p1_a122 JTF_VARCHAR2_TABLE_100
1877 , p2_a0 in out nocopy NUMBER
1878 , p2_a1 in out nocopy DATE
1879 , p2_a2 in out nocopy DATE
1880 , p2_a3 in out nocopy NUMBER
1881 , p2_a4 in out nocopy NUMBER
1882 , p2_a5 in out nocopy NUMBER
1883 , p2_a6 in out nocopy VARCHAR2
1884 , p2_a7 in out nocopy NUMBER
1885 , p2_a8 in out nocopy VARCHAR2
1886 , p2_a9 in out nocopy NUMBER
1887 , p2_a10 in out nocopy VARCHAR2
1888 , p2_a11 in out nocopy NUMBER
1889 , p2_a12 in out nocopy NUMBER
1890 , p2_a13 in out nocopy NUMBER
1891 , p2_a14 in out nocopy NUMBER
1892 , p2_a15 in out nocopy VARCHAR2
1893 , p2_a16 in out nocopy NUMBER
1894 , p2_a17 in out nocopy VARCHAR2
1895 , p2_a18 in out nocopy VARCHAR2
1896 , p2_a19 in out nocopy NUMBER
1897 , p2_a20 in out nocopy VARCHAR2
1898 , p2_a21 in out nocopy VARCHAR2
1899 , p2_a22 in out nocopy VARCHAR2
1900 , p2_a23 in out nocopy VARCHAR2
1901 , p2_a24 in out nocopy VARCHAR2
1902 , p2_a25 in out nocopy VARCHAR2
1903 , p2_a26 in out nocopy VARCHAR2
1904 , p2_a27 in out nocopy VARCHAR2
1905 , p2_a28 in out nocopy VARCHAR2
1906 , p2_a29 in out nocopy VARCHAR2
1907 , p2_a30 in out nocopy VARCHAR2
1908 , p2_a31 in out nocopy VARCHAR2
1909 , p2_a32 in out nocopy VARCHAR2
1910 , p2_a33 in out nocopy VARCHAR2
1911 , p2_a34 in out nocopy VARCHAR2
1912 , p2_a35 in out nocopy VARCHAR2
1913 , p2_a36 in out nocopy NUMBER
1914 , p2_a37 in out nocopy VARCHAR2
1915 , p2_a38 in out nocopy DATE
1916 , p2_a39 in out nocopy NUMBER
1917 , p3_a0 out nocopy JTF_NUMBER_TABLE
1918 , p3_a1 out nocopy JTF_NUMBER_TABLE
1919 , p3_a2 out nocopy JTF_NUMBER_TABLE
1920 , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1921 , p3_a4 out nocopy JTF_NUMBER_TABLE
1922 , p3_a5 out nocopy JTF_NUMBER_TABLE
1923 , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
1924 , p3_a7 out nocopy JTF_DATE_TABLE
1925 , p3_a8 out nocopy JTF_DATE_TABLE
1926 , p3_a9 out nocopy JTF_NUMBER_TABLE
1927 , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
1928 , p3_a11 out nocopy JTF_NUMBER_TABLE
1929 , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1930 , p3_a13 out nocopy JTF_NUMBER_TABLE
1931 , p3_a14 out nocopy JTF_VARCHAR2_TABLE_100
1932 , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1933 , x_return_status out nocopy VARCHAR2
1934 , x_error_message out nocopy VARCHAR2
1935 , p0_a0 NUMBER := 0-1962.0724
1936 , p0_a1 VARCHAR2 := fnd_api.g_miss_char
1937 , p0_a2 NUMBER := 0-1962.0724
1938 , p0_a3 NUMBER := 0-1962.0724
1939 , p0_a4 VARCHAR2 := fnd_api.g_miss_char
1940 , p0_a5 VARCHAR2 := fnd_api.g_miss_char
1941 )
1942
1943 as
1944 ddp_fixed_asset_rec csi_fa_instance_grp.fixed_asset_rec;
1945 ddp_instance_tbl csi_datastructures_pub.instance_tbl;
1946 ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
1947 ddx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1948 ddindx binary_integer; indx binary_integer;
1949 begin
1950
1951 -- copy data to the local IN or IN-OUT args, if any
1952 ddp_fixed_asset_rec.asset_id := rosetta_g_miss_num_map(p0_a0);
1953 ddp_fixed_asset_rec.book_type_code := p0_a1;
1954 ddp_fixed_asset_rec.asset_location_id := rosetta_g_miss_num_map(p0_a2);
1955 ddp_fixed_asset_rec.asset_quantity := rosetta_g_miss_num_map(p0_a3);
1956 ddp_fixed_asset_rec.fa_sync_flag := p0_a4;
1957 ddp_fixed_asset_rec.fa_sync_validation_reqd := p0_a5;
1958
1959 csi_datastructures_pub_w.rosetta_table_copy_in_p19(ddp_instance_tbl, p1_a0
1960 , p1_a1
1961 , p1_a2
1962 , p1_a3
1963 , p1_a4
1964 , p1_a5
1965 , p1_a6
1966 , p1_a7
1967 , p1_a8
1968 , p1_a9
1969 , p1_a10
1970 , p1_a11
1971 , p1_a12
1972 , p1_a13
1973 , p1_a14
1974 , p1_a15
1975 , p1_a16
1976 , p1_a17
1977 , p1_a18
1978 , p1_a19
1979 , p1_a20
1980 , p1_a21
1981 , p1_a22
1982 , p1_a23
1983 , p1_a24
1984 , p1_a25
1985 , p1_a26
1986 , p1_a27
1987 , p1_a28
1988 , p1_a29
1989 , p1_a30
1990 , p1_a31
1991 , p1_a32
1992 , p1_a33
1993 , p1_a34
1994 , p1_a35
1995 , p1_a36
1996 , p1_a37
1997 , p1_a38
1998 , p1_a39
1999 , p1_a40
2000 , p1_a41
2001 , p1_a42
2002 , p1_a43
2003 , p1_a44
2004 , p1_a45
2005 , p1_a46
2006 , p1_a47
2007 , p1_a48
2008 , p1_a49
2009 , p1_a50
2010 , p1_a51
2011 , p1_a52
2012 , p1_a53
2013 , p1_a54
2014 , p1_a55
2015 , p1_a56
2016 , p1_a57
2017 , p1_a58
2018 , p1_a59
2019 , p1_a60
2020 , p1_a61
2024 , p1_a65
2021 , p1_a62
2022 , p1_a63
2023 , p1_a64
2025 , p1_a66
2026 , p1_a67
2027 , p1_a68
2028 , p1_a69
2029 , p1_a70
2030 , p1_a71
2031 , p1_a72
2032 , p1_a73
2033 , p1_a74
2034 , p1_a75
2035 , p1_a76
2036 , p1_a77
2037 , p1_a78
2038 , p1_a79
2039 , p1_a80
2040 , p1_a81
2041 , p1_a82
2042 , p1_a83
2043 , p1_a84
2044 , p1_a85
2045 , p1_a86
2046 , p1_a87
2047 , p1_a88
2048 , p1_a89
2049 , p1_a90
2050 , p1_a91
2051 , p1_a92
2052 , p1_a93
2053 , p1_a94
2054 , p1_a95
2055 , p1_a96
2056 , p1_a97
2057 , p1_a98
2058 , p1_a99
2059 , p1_a100
2060 , p1_a101
2061 , p1_a102
2062 , p1_a103
2063 , p1_a104
2064 , p1_a105
2065 , p1_a106
2066 , p1_a107
2067 , p1_a108
2068 , p1_a109
2069 , p1_a110
2070 , p1_a111
2071 , p1_a112
2072 , p1_a113
2073 , p1_a114
2074 , p1_a115
2075 , p1_a116
2076 , p1_a117
2077 , p1_a118
2078 , p1_a119
2079 , p1_a120
2080 , p1_a121
2081 , p1_a122
2082 );
2083
2084 ddpx_csi_txn_rec.transaction_id := rosetta_g_miss_num_map(p2_a0);
2085 ddpx_csi_txn_rec.transaction_date := rosetta_g_miss_date_in_map(p2_a1);
2086 ddpx_csi_txn_rec.source_transaction_date := rosetta_g_miss_date_in_map(p2_a2);
2087 ddpx_csi_txn_rec.transaction_type_id := rosetta_g_miss_num_map(p2_a3);
2088 ddpx_csi_txn_rec.txn_sub_type_id := rosetta_g_miss_num_map(p2_a4);
2089 ddpx_csi_txn_rec.source_group_ref_id := rosetta_g_miss_num_map(p2_a5);
2090 ddpx_csi_txn_rec.source_group_ref := p2_a6;
2091 ddpx_csi_txn_rec.source_header_ref_id := rosetta_g_miss_num_map(p2_a7);
2092 ddpx_csi_txn_rec.source_header_ref := p2_a8;
2093 ddpx_csi_txn_rec.source_line_ref_id := rosetta_g_miss_num_map(p2_a9);
2094 ddpx_csi_txn_rec.source_line_ref := p2_a10;
2095 ddpx_csi_txn_rec.source_dist_ref_id1 := rosetta_g_miss_num_map(p2_a11);
2096 ddpx_csi_txn_rec.source_dist_ref_id2 := rosetta_g_miss_num_map(p2_a12);
2097 ddpx_csi_txn_rec.inv_material_transaction_id := rosetta_g_miss_num_map(p2_a13);
2098 ddpx_csi_txn_rec.transaction_quantity := rosetta_g_miss_num_map(p2_a14);
2099 ddpx_csi_txn_rec.transaction_uom_code := p2_a15;
2100 ddpx_csi_txn_rec.transacted_by := rosetta_g_miss_num_map(p2_a16);
2101 ddpx_csi_txn_rec.transaction_status_code := p2_a17;
2102 ddpx_csi_txn_rec.transaction_action_code := p2_a18;
2103 ddpx_csi_txn_rec.message_id := rosetta_g_miss_num_map(p2_a19);
2104 ddpx_csi_txn_rec.context := p2_a20;
2105 ddpx_csi_txn_rec.attribute1 := p2_a21;
2106 ddpx_csi_txn_rec.attribute2 := p2_a22;
2107 ddpx_csi_txn_rec.attribute3 := p2_a23;
2108 ddpx_csi_txn_rec.attribute4 := p2_a24;
2109 ddpx_csi_txn_rec.attribute5 := p2_a25;
2110 ddpx_csi_txn_rec.attribute6 := p2_a26;
2111 ddpx_csi_txn_rec.attribute7 := p2_a27;
2112 ddpx_csi_txn_rec.attribute8 := p2_a28;
2113 ddpx_csi_txn_rec.attribute9 := p2_a29;
2114 ddpx_csi_txn_rec.attribute10 := p2_a30;
2115 ddpx_csi_txn_rec.attribute11 := p2_a31;
2116 ddpx_csi_txn_rec.attribute12 := p2_a32;
2117 ddpx_csi_txn_rec.attribute13 := p2_a33;
2118 ddpx_csi_txn_rec.attribute14 := p2_a34;
2119 ddpx_csi_txn_rec.attribute15 := p2_a35;
2120 ddpx_csi_txn_rec.object_version_number := rosetta_g_miss_num_map(p2_a36);
2121 ddpx_csi_txn_rec.split_reason_code := p2_a37;
2122 ddpx_csi_txn_rec.src_txn_creation_date := rosetta_g_miss_date_in_map(p2_a38);
2123 ddpx_csi_txn_rec.gl_interface_status_code := rosetta_g_miss_num_map(p2_a39);
2124
2125
2126
2127
2128 -- here's the delegated call to the old PL/SQL routine
2129 csi_fa_instance_grp.associate_item_instance(ddp_fixed_asset_rec,
2130 ddp_instance_tbl,
2131 ddpx_csi_txn_rec,
2132 ddx_instance_asset_tbl,
2133 x_return_status,
2134 x_error_message);
2135
2136 -- copy data back from the local variables to OUT or IN-OUT args, if any
2137
2138
2139 p2_a0 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_id);
2140 p2_a1 := ddpx_csi_txn_rec.transaction_date;
2141 p2_a2 := ddpx_csi_txn_rec.source_transaction_date;
2142 p2_a3 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_type_id);
2143 p2_a4 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.txn_sub_type_id);
2144 p2_a5 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_group_ref_id);
2145 p2_a6 := ddpx_csi_txn_rec.source_group_ref;
2146 p2_a7 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_header_ref_id);
2147 p2_a8 := ddpx_csi_txn_rec.source_header_ref;
2148 p2_a9 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_line_ref_id);
2149 p2_a10 := ddpx_csi_txn_rec.source_line_ref;
2150 p2_a11 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_dist_ref_id1);
2151 p2_a12 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_dist_ref_id2);
2152 p2_a13 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.inv_material_transaction_id);
2153 p2_a14 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_quantity);
2154 p2_a15 := ddpx_csi_txn_rec.transaction_uom_code;
2155 p2_a16 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transacted_by);
2159 p2_a20 := ddpx_csi_txn_rec.context;
2156 p2_a17 := ddpx_csi_txn_rec.transaction_status_code;
2157 p2_a18 := ddpx_csi_txn_rec.transaction_action_code;
2158 p2_a19 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.message_id);
2160 p2_a21 := ddpx_csi_txn_rec.attribute1;
2161 p2_a22 := ddpx_csi_txn_rec.attribute2;
2162 p2_a23 := ddpx_csi_txn_rec.attribute3;
2163 p2_a24 := ddpx_csi_txn_rec.attribute4;
2164 p2_a25 := ddpx_csi_txn_rec.attribute5;
2165 p2_a26 := ddpx_csi_txn_rec.attribute6;
2166 p2_a27 := ddpx_csi_txn_rec.attribute7;
2167 p2_a28 := ddpx_csi_txn_rec.attribute8;
2168 p2_a29 := ddpx_csi_txn_rec.attribute9;
2169 p2_a30 := ddpx_csi_txn_rec.attribute10;
2170 p2_a31 := ddpx_csi_txn_rec.attribute11;
2171 p2_a32 := ddpx_csi_txn_rec.attribute12;
2172 p2_a33 := ddpx_csi_txn_rec.attribute13;
2173 p2_a34 := ddpx_csi_txn_rec.attribute14;
2174 p2_a35 := ddpx_csi_txn_rec.attribute15;
2175 p2_a36 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.object_version_number);
2176 p2_a37 := ddpx_csi_txn_rec.split_reason_code;
2177 p2_a38 := ddpx_csi_txn_rec.src_txn_creation_date;
2178 p2_a39 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.gl_interface_status_code);
2179
2180 csi_datastructures_pub_w.rosetta_table_copy_out_p52(ddx_instance_asset_tbl, p3_a0
2181 , p3_a1
2182 , p3_a2
2183 , p3_a3
2184 , p3_a4
2185 , p3_a5
2186 , p3_a6
2187 , p3_a7
2188 , p3_a8
2189 , p3_a9
2190 , p3_a10
2191 , p3_a11
2192 , p3_a12
2193 , p3_a13
2194 , p3_a14
2195 , p3_a15
2196 );
2197
2198
2199 end;
2200
2201 procedure update_asset_association(p0_a0 JTF_NUMBER_TABLE
2202 , p0_a1 JTF_NUMBER_TABLE
2203 , p0_a2 JTF_NUMBER_TABLE
2204 , p0_a3 JTF_VARCHAR2_TABLE_100
2205 , p0_a4 JTF_NUMBER_TABLE
2206 , p0_a5 JTF_NUMBER_TABLE
2207 , p0_a6 JTF_VARCHAR2_TABLE_100
2208 , p0_a7 JTF_DATE_TABLE
2209 , p0_a8 JTF_DATE_TABLE
2210 , p0_a9 JTF_NUMBER_TABLE
2211 , p0_a10 JTF_VARCHAR2_TABLE_100
2212 , p0_a11 JTF_NUMBER_TABLE
2213 , p0_a12 JTF_VARCHAR2_TABLE_100
2214 , p0_a13 JTF_NUMBER_TABLE
2215 , p0_a14 JTF_VARCHAR2_TABLE_100
2216 , p0_a15 JTF_VARCHAR2_TABLE_100
2217 , p1_a0 in out nocopy NUMBER
2218 , p1_a1 in out nocopy DATE
2219 , p1_a2 in out nocopy DATE
2220 , p1_a3 in out nocopy NUMBER
2221 , p1_a4 in out nocopy NUMBER
2222 , p1_a5 in out nocopy NUMBER
2223 , p1_a6 in out nocopy VARCHAR2
2224 , p1_a7 in out nocopy NUMBER
2225 , p1_a8 in out nocopy VARCHAR2
2226 , p1_a9 in out nocopy NUMBER
2227 , p1_a10 in out nocopy VARCHAR2
2228 , p1_a11 in out nocopy NUMBER
2229 , p1_a12 in out nocopy NUMBER
2230 , p1_a13 in out nocopy NUMBER
2231 , p1_a14 in out nocopy NUMBER
2232 , p1_a15 in out nocopy VARCHAR2
2233 , p1_a16 in out nocopy NUMBER
2234 , p1_a17 in out nocopy VARCHAR2
2235 , p1_a18 in out nocopy VARCHAR2
2236 , p1_a19 in out nocopy NUMBER
2237 , p1_a20 in out nocopy VARCHAR2
2238 , p1_a21 in out nocopy VARCHAR2
2239 , p1_a22 in out nocopy VARCHAR2
2240 , p1_a23 in out nocopy VARCHAR2
2241 , p1_a24 in out nocopy VARCHAR2
2242 , p1_a25 in out nocopy VARCHAR2
2243 , p1_a26 in out nocopy VARCHAR2
2244 , p1_a27 in out nocopy VARCHAR2
2245 , p1_a28 in out nocopy VARCHAR2
2246 , p1_a29 in out nocopy VARCHAR2
2247 , p1_a30 in out nocopy VARCHAR2
2248 , p1_a31 in out nocopy VARCHAR2
2249 , p1_a32 in out nocopy VARCHAR2
2250 , p1_a33 in out nocopy VARCHAR2
2251 , p1_a34 in out nocopy VARCHAR2
2252 , p1_a35 in out nocopy VARCHAR2
2253 , p1_a36 in out nocopy NUMBER
2254 , p1_a37 in out nocopy VARCHAR2
2255 , p1_a38 in out nocopy DATE
2256 , p1_a39 in out nocopy NUMBER
2257 , x_return_status out nocopy VARCHAR2
2258 , x_error_message out nocopy VARCHAR2
2259 )
2260
2261 as
2262 ddp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2263 ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
2264 ddindx binary_integer; indx binary_integer;
2265 begin
2266
2267 -- copy data to the local IN or IN-OUT args, if any
2268 csi_datastructures_pub_w.rosetta_table_copy_in_p52(ddp_instance_asset_tbl, p0_a0
2269 , p0_a1
2270 , p0_a2
2271 , p0_a3
2272 , p0_a4
2273 , p0_a5
2274 , p0_a6
2275 , p0_a7
2276 , p0_a8
2277 , p0_a9
2278 , p0_a10
2279 , p0_a11
2280 , p0_a12
2281 , p0_a13
2282 , p0_a14
2283 , p0_a15
2284 );
2285
2286 ddpx_csi_txn_rec.transaction_id := rosetta_g_miss_num_map(p1_a0);
2287 ddpx_csi_txn_rec.transaction_date := rosetta_g_miss_date_in_map(p1_a1);
2288 ddpx_csi_txn_rec.source_transaction_date := rosetta_g_miss_date_in_map(p1_a2);
2289 ddpx_csi_txn_rec.transaction_type_id := rosetta_g_miss_num_map(p1_a3);
2290 ddpx_csi_txn_rec.txn_sub_type_id := rosetta_g_miss_num_map(p1_a4);
2291 ddpx_csi_txn_rec.source_group_ref_id := rosetta_g_miss_num_map(p1_a5);
2292 ddpx_csi_txn_rec.source_group_ref := p1_a6;
2293 ddpx_csi_txn_rec.source_header_ref_id := rosetta_g_miss_num_map(p1_a7);
2297 ddpx_csi_txn_rec.source_dist_ref_id1 := rosetta_g_miss_num_map(p1_a11);
2294 ddpx_csi_txn_rec.source_header_ref := p1_a8;
2295 ddpx_csi_txn_rec.source_line_ref_id := rosetta_g_miss_num_map(p1_a9);
2296 ddpx_csi_txn_rec.source_line_ref := p1_a10;
2298 ddpx_csi_txn_rec.source_dist_ref_id2 := rosetta_g_miss_num_map(p1_a12);
2299 ddpx_csi_txn_rec.inv_material_transaction_id := rosetta_g_miss_num_map(p1_a13);
2300 ddpx_csi_txn_rec.transaction_quantity := rosetta_g_miss_num_map(p1_a14);
2301 ddpx_csi_txn_rec.transaction_uom_code := p1_a15;
2302 ddpx_csi_txn_rec.transacted_by := rosetta_g_miss_num_map(p1_a16);
2303 ddpx_csi_txn_rec.transaction_status_code := p1_a17;
2304 ddpx_csi_txn_rec.transaction_action_code := p1_a18;
2305 ddpx_csi_txn_rec.message_id := rosetta_g_miss_num_map(p1_a19);
2306 ddpx_csi_txn_rec.context := p1_a20;
2307 ddpx_csi_txn_rec.attribute1 := p1_a21;
2308 ddpx_csi_txn_rec.attribute2 := p1_a22;
2309 ddpx_csi_txn_rec.attribute3 := p1_a23;
2310 ddpx_csi_txn_rec.attribute4 := p1_a24;
2311 ddpx_csi_txn_rec.attribute5 := p1_a25;
2312 ddpx_csi_txn_rec.attribute6 := p1_a26;
2313 ddpx_csi_txn_rec.attribute7 := p1_a27;
2314 ddpx_csi_txn_rec.attribute8 := p1_a28;
2315 ddpx_csi_txn_rec.attribute9 := p1_a29;
2316 ddpx_csi_txn_rec.attribute10 := p1_a30;
2317 ddpx_csi_txn_rec.attribute11 := p1_a31;
2318 ddpx_csi_txn_rec.attribute12 := p1_a32;
2319 ddpx_csi_txn_rec.attribute13 := p1_a33;
2320 ddpx_csi_txn_rec.attribute14 := p1_a34;
2321 ddpx_csi_txn_rec.attribute15 := p1_a35;
2322 ddpx_csi_txn_rec.object_version_number := rosetta_g_miss_num_map(p1_a36);
2323 ddpx_csi_txn_rec.split_reason_code := p1_a37;
2324 ddpx_csi_txn_rec.src_txn_creation_date := rosetta_g_miss_date_in_map(p1_a38);
2325 ddpx_csi_txn_rec.gl_interface_status_code := rosetta_g_miss_num_map(p1_a39);
2326
2327
2328
2329 -- here's the delegated call to the old PL/SQL routine
2330 csi_fa_instance_grp.update_asset_association(ddp_instance_asset_tbl,
2331 ddpx_csi_txn_rec,
2332 x_return_status,
2333 x_error_message);
2334
2335 -- copy data back from the local variables to OUT or IN-OUT args, if any
2336
2337 p1_a0 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_id);
2338 p1_a1 := ddpx_csi_txn_rec.transaction_date;
2339 p1_a2 := ddpx_csi_txn_rec.source_transaction_date;
2340 p1_a3 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_type_id);
2341 p1_a4 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.txn_sub_type_id);
2342 p1_a5 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_group_ref_id);
2343 p1_a6 := ddpx_csi_txn_rec.source_group_ref;
2344 p1_a7 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_header_ref_id);
2345 p1_a8 := ddpx_csi_txn_rec.source_header_ref;
2346 p1_a9 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_line_ref_id);
2347 p1_a10 := ddpx_csi_txn_rec.source_line_ref;
2348 p1_a11 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_dist_ref_id1);
2349 p1_a12 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_dist_ref_id2);
2350 p1_a13 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.inv_material_transaction_id);
2351 p1_a14 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_quantity);
2352 p1_a15 := ddpx_csi_txn_rec.transaction_uom_code;
2353 p1_a16 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transacted_by);
2354 p1_a17 := ddpx_csi_txn_rec.transaction_status_code;
2355 p1_a18 := ddpx_csi_txn_rec.transaction_action_code;
2356 p1_a19 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.message_id);
2357 p1_a20 := ddpx_csi_txn_rec.context;
2358 p1_a21 := ddpx_csi_txn_rec.attribute1;
2359 p1_a22 := ddpx_csi_txn_rec.attribute2;
2360 p1_a23 := ddpx_csi_txn_rec.attribute3;
2361 p1_a24 := ddpx_csi_txn_rec.attribute4;
2362 p1_a25 := ddpx_csi_txn_rec.attribute5;
2363 p1_a26 := ddpx_csi_txn_rec.attribute6;
2364 p1_a27 := ddpx_csi_txn_rec.attribute7;
2365 p1_a28 := ddpx_csi_txn_rec.attribute8;
2366 p1_a29 := ddpx_csi_txn_rec.attribute9;
2367 p1_a30 := ddpx_csi_txn_rec.attribute10;
2368 p1_a31 := ddpx_csi_txn_rec.attribute11;
2369 p1_a32 := ddpx_csi_txn_rec.attribute12;
2370 p1_a33 := ddpx_csi_txn_rec.attribute13;
2371 p1_a34 := ddpx_csi_txn_rec.attribute14;
2372 p1_a35 := ddpx_csi_txn_rec.attribute15;
2373 p1_a36 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.object_version_number);
2374 p1_a37 := ddpx_csi_txn_rec.split_reason_code;
2375 p1_a38 := ddpx_csi_txn_rec.src_txn_creation_date;
2376 p1_a39 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.gl_interface_status_code);
2377
2378
2379 end;
2380
2381 procedure create_instance_assets(p0_a0 in out nocopy JTF_NUMBER_TABLE
2382 , p0_a1 in out nocopy JTF_NUMBER_TABLE
2383 , p0_a2 in out nocopy JTF_NUMBER_TABLE
2384 , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2385 , p0_a4 in out nocopy JTF_NUMBER_TABLE
2386 , p0_a5 in out nocopy JTF_NUMBER_TABLE
2387 , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2388 , p0_a7 in out nocopy JTF_DATE_TABLE
2389 , p0_a8 in out nocopy JTF_DATE_TABLE
2390 , p0_a9 in out nocopy JTF_NUMBER_TABLE
2391 , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
2392 , p0_a11 in out nocopy JTF_NUMBER_TABLE
2393 , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
2394 , p0_a13 in out nocopy JTF_NUMBER_TABLE
2395 , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
2396 , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
2397 , p1_a0 in out nocopy NUMBER
2398 , p1_a1 in out nocopy DATE
2399 , p1_a2 in out nocopy DATE
2400 , p1_a3 in out nocopy NUMBER
2401 , p1_a4 in out nocopy NUMBER
2402 , p1_a5 in out nocopy NUMBER
2403 , p1_a6 in out nocopy VARCHAR2
2404 , p1_a7 in out nocopy NUMBER
2405 , p1_a8 in out nocopy VARCHAR2
2406 , p1_a9 in out nocopy NUMBER
2407 , p1_a10 in out nocopy VARCHAR2
2408 , p1_a11 in out nocopy NUMBER
2409 , p1_a12 in out nocopy NUMBER
2410 , p1_a13 in out nocopy NUMBER
2411 , p1_a14 in out nocopy NUMBER
2412 , p1_a15 in out nocopy VARCHAR2
2413 , p1_a16 in out nocopy NUMBER
2414 , p1_a17 in out nocopy VARCHAR2
2415 , p1_a18 in out nocopy VARCHAR2
2416 , p1_a19 in out nocopy NUMBER
2417 , p1_a20 in out nocopy VARCHAR2
2418 , p1_a21 in out nocopy VARCHAR2
2419 , p1_a22 in out nocopy VARCHAR2
2420 , p1_a23 in out nocopy VARCHAR2
2421 , p1_a24 in out nocopy VARCHAR2
2422 , p1_a25 in out nocopy VARCHAR2
2423 , p1_a26 in out nocopy VARCHAR2
2424 , p1_a27 in out nocopy VARCHAR2
2425 , p1_a28 in out nocopy VARCHAR2
2426 , p1_a29 in out nocopy VARCHAR2
2427 , p1_a30 in out nocopy VARCHAR2
2428 , p1_a31 in out nocopy VARCHAR2
2429 , p1_a32 in out nocopy VARCHAR2
2430 , p1_a33 in out nocopy VARCHAR2
2431 , p1_a34 in out nocopy VARCHAR2
2432 , p1_a35 in out nocopy VARCHAR2
2433 , p1_a36 in out nocopy NUMBER
2434 , p1_a37 in out nocopy VARCHAR2
2435 , p1_a38 in out nocopy DATE
2436 , p1_a39 in out nocopy NUMBER
2437 , x_return_status out nocopy VARCHAR2
2438 , x_error_message out nocopy VARCHAR2
2439 )
2440
2441 as
2442 ddpx_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2443 ddpx_csi_txn_rec csi_datastructures_pub.transaction_rec;
2444 ddindx binary_integer; indx binary_integer;
2445 begin
2446
2447 -- copy data to the local IN or IN-OUT args, if any
2448 csi_datastructures_pub_w.rosetta_table_copy_in_p52(ddpx_instance_asset_tbl, p0_a0
2449 , p0_a1
2450 , p0_a2
2451 , p0_a3
2452 , p0_a4
2453 , p0_a5
2454 , p0_a6
2455 , p0_a7
2456 , p0_a8
2457 , p0_a9
2458 , p0_a10
2459 , p0_a11
2460 , p0_a12
2461 , p0_a13
2462 , p0_a14
2463 , p0_a15
2464 );
2465
2466 ddpx_csi_txn_rec.transaction_id := rosetta_g_miss_num_map(p1_a0);
2467 ddpx_csi_txn_rec.transaction_date := rosetta_g_miss_date_in_map(p1_a1);
2468 ddpx_csi_txn_rec.source_transaction_date := rosetta_g_miss_date_in_map(p1_a2);
2469 ddpx_csi_txn_rec.transaction_type_id := rosetta_g_miss_num_map(p1_a3);
2470 ddpx_csi_txn_rec.txn_sub_type_id := rosetta_g_miss_num_map(p1_a4);
2471 ddpx_csi_txn_rec.source_group_ref_id := rosetta_g_miss_num_map(p1_a5);
2472 ddpx_csi_txn_rec.source_group_ref := p1_a6;
2473 ddpx_csi_txn_rec.source_header_ref_id := rosetta_g_miss_num_map(p1_a7);
2474 ddpx_csi_txn_rec.source_header_ref := p1_a8;
2475 ddpx_csi_txn_rec.source_line_ref_id := rosetta_g_miss_num_map(p1_a9);
2476 ddpx_csi_txn_rec.source_line_ref := p1_a10;
2477 ddpx_csi_txn_rec.source_dist_ref_id1 := rosetta_g_miss_num_map(p1_a11);
2478 ddpx_csi_txn_rec.source_dist_ref_id2 := rosetta_g_miss_num_map(p1_a12);
2479 ddpx_csi_txn_rec.inv_material_transaction_id := rosetta_g_miss_num_map(p1_a13);
2480 ddpx_csi_txn_rec.transaction_quantity := rosetta_g_miss_num_map(p1_a14);
2481 ddpx_csi_txn_rec.transaction_uom_code := p1_a15;
2482 ddpx_csi_txn_rec.transacted_by := rosetta_g_miss_num_map(p1_a16);
2483 ddpx_csi_txn_rec.transaction_status_code := p1_a17;
2484 ddpx_csi_txn_rec.transaction_action_code := p1_a18;
2485 ddpx_csi_txn_rec.message_id := rosetta_g_miss_num_map(p1_a19);
2486 ddpx_csi_txn_rec.context := p1_a20;
2487 ddpx_csi_txn_rec.attribute1 := p1_a21;
2488 ddpx_csi_txn_rec.attribute2 := p1_a22;
2489 ddpx_csi_txn_rec.attribute3 := p1_a23;
2490 ddpx_csi_txn_rec.attribute4 := p1_a24;
2491 ddpx_csi_txn_rec.attribute5 := p1_a25;
2492 ddpx_csi_txn_rec.attribute6 := p1_a26;
2493 ddpx_csi_txn_rec.attribute7 := p1_a27;
2494 ddpx_csi_txn_rec.attribute8 := p1_a28;
2495 ddpx_csi_txn_rec.attribute9 := p1_a29;
2496 ddpx_csi_txn_rec.attribute10 := p1_a30;
2497 ddpx_csi_txn_rec.attribute11 := p1_a31;
2498 ddpx_csi_txn_rec.attribute12 := p1_a32;
2499 ddpx_csi_txn_rec.attribute13 := p1_a33;
2500 ddpx_csi_txn_rec.attribute14 := p1_a34;
2501 ddpx_csi_txn_rec.attribute15 := p1_a35;
2502 ddpx_csi_txn_rec.object_version_number := rosetta_g_miss_num_map(p1_a36);
2503 ddpx_csi_txn_rec.split_reason_code := p1_a37;
2504 ddpx_csi_txn_rec.src_txn_creation_date := rosetta_g_miss_date_in_map(p1_a38);
2505 ddpx_csi_txn_rec.gl_interface_status_code := rosetta_g_miss_num_map(p1_a39);
2506
2507
2508
2509 -- here's the delegated call to the old PL/SQL routine
2510 csi_fa_instance_grp.create_instance_assets(ddpx_instance_asset_tbl,
2511 ddpx_csi_txn_rec,
2512 x_return_status,
2513 x_error_message);
2514
2515 -- copy data back from the local variables to OUT or IN-OUT args, if any
2519 , p0_a3
2516 csi_datastructures_pub_w.rosetta_table_copy_out_p52(ddpx_instance_asset_tbl, p0_a0
2517 , p0_a1
2518 , p0_a2
2520 , p0_a4
2521 , p0_a5
2522 , p0_a6
2523 , p0_a7
2524 , p0_a8
2525 , p0_a9
2526 , p0_a10
2527 , p0_a11
2528 , p0_a12
2529 , p0_a13
2530 , p0_a14
2531 , p0_a15
2532 );
2533
2534 p1_a0 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_id);
2535 p1_a1 := ddpx_csi_txn_rec.transaction_date;
2536 p1_a2 := ddpx_csi_txn_rec.source_transaction_date;
2537 p1_a3 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_type_id);
2538 p1_a4 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.txn_sub_type_id);
2539 p1_a5 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_group_ref_id);
2540 p1_a6 := ddpx_csi_txn_rec.source_group_ref;
2541 p1_a7 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_header_ref_id);
2542 p1_a8 := ddpx_csi_txn_rec.source_header_ref;
2543 p1_a9 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_line_ref_id);
2544 p1_a10 := ddpx_csi_txn_rec.source_line_ref;
2545 p1_a11 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_dist_ref_id1);
2546 p1_a12 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.source_dist_ref_id2);
2547 p1_a13 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.inv_material_transaction_id);
2548 p1_a14 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transaction_quantity);
2549 p1_a15 := ddpx_csi_txn_rec.transaction_uom_code;
2550 p1_a16 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.transacted_by);
2551 p1_a17 := ddpx_csi_txn_rec.transaction_status_code;
2552 p1_a18 := ddpx_csi_txn_rec.transaction_action_code;
2553 p1_a19 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.message_id);
2554 p1_a20 := ddpx_csi_txn_rec.context;
2555 p1_a21 := ddpx_csi_txn_rec.attribute1;
2556 p1_a22 := ddpx_csi_txn_rec.attribute2;
2557 p1_a23 := ddpx_csi_txn_rec.attribute3;
2558 p1_a24 := ddpx_csi_txn_rec.attribute4;
2559 p1_a25 := ddpx_csi_txn_rec.attribute5;
2560 p1_a26 := ddpx_csi_txn_rec.attribute6;
2561 p1_a27 := ddpx_csi_txn_rec.attribute7;
2562 p1_a28 := ddpx_csi_txn_rec.attribute8;
2563 p1_a29 := ddpx_csi_txn_rec.attribute9;
2564 p1_a30 := ddpx_csi_txn_rec.attribute10;
2565 p1_a31 := ddpx_csi_txn_rec.attribute11;
2566 p1_a32 := ddpx_csi_txn_rec.attribute12;
2567 p1_a33 := ddpx_csi_txn_rec.attribute13;
2568 p1_a34 := ddpx_csi_txn_rec.attribute14;
2569 p1_a35 := ddpx_csi_txn_rec.attribute15;
2570 p1_a36 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.object_version_number);
2571 p1_a37 := ddpx_csi_txn_rec.split_reason_code;
2572 p1_a38 := ddpx_csi_txn_rec.src_txn_creation_date;
2573 p1_a39 := rosetta_g_miss_num_map(ddpx_csi_txn_rec.gl_interface_status_code);
2574
2575
2576 end;
2577
2578 end csi_fa_instance_grp_w;