[Home] [Help]
PACKAGE BODY: APPS.EAM_EST_DATASTRUCTURES_PUB_W
Source
1 package body eam_est_datastructures_pub_w as
2 /* $Header: EAMPEDWB.pls 120.0.12010000.3 2009/01/03 00:09:24 devijay noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5 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_p3(t out nocopy eam_est_datastructures_pub.eam_ce_message_tbl, a0 JTF_NUMBER_TABLE
26 , a1 JTF_VARCHAR2_TABLE_100
27 , a2 JTF_VARCHAR2_TABLE_2000
28 , a3 JTF_NUMBER_TABLE
29 , a4 JTF_VARCHAR2_TABLE_100
30 , a5 JTF_VARCHAR2_TABLE_100
31 ) as
32 ddindx binary_integer; indx binary_integer;
33 begin
34 if a0 is not null and a0.count > 0 then
35 if a0.count > 0 then
36 indx := a0.first;
37 ddindx := 1;
38 while true loop
39 t(ddindx).organization_id := rosetta_g_miss_num_map(a0(indx));
40 t(ddindx).estimate_id := a1(indx);
41 t(ddindx).message_text := a2(indx);
42 t(ddindx).row_reference := rosetta_g_miss_num_map(a3(indx));
43 t(ddindx).message_code := a4(indx);
44 t(ddindx).message_type := a5(indx);
45 ddindx := ddindx+1;
46 if a0.last =indx
47 then exit;
48 end if;
49 indx := a0.next(indx);
50 end loop;
51 end if;
52 end if;
53 end rosetta_table_copy_in_p3;
54 procedure rosetta_table_copy_out_p3(t eam_est_datastructures_pub.eam_ce_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
55 , a1 out nocopy JTF_VARCHAR2_TABLE_100
56 , a2 out nocopy JTF_VARCHAR2_TABLE_2000
57 , a3 out nocopy JTF_NUMBER_TABLE
58 , a4 out nocopy JTF_VARCHAR2_TABLE_100
59 , a5 out nocopy JTF_VARCHAR2_TABLE_100
60 ) as
61 ddindx binary_integer; indx binary_integer;
62 begin
63 if t is null or t.count = 0 then
64 a0 := JTF_NUMBER_TABLE();
65 a1 := JTF_VARCHAR2_TABLE_100();
66 a2 := JTF_VARCHAR2_TABLE_2000();
67 a3 := JTF_NUMBER_TABLE();
68 a4 := JTF_VARCHAR2_TABLE_100();
69 a5 := JTF_VARCHAR2_TABLE_100();
70 else
71 a0 := JTF_NUMBER_TABLE();
72 a1 := JTF_VARCHAR2_TABLE_100();
73 a2 := JTF_VARCHAR2_TABLE_2000();
74 a3 := JTF_NUMBER_TABLE();
75 a4 := JTF_VARCHAR2_TABLE_100();
76 a5 := JTF_VARCHAR2_TABLE_100();
77 if t.count > 0 then
78 a0.extend(t.count);
79 a1.extend(t.count);
80 a2.extend(t.count);
81 a3.extend(t.count);
82 a4.extend(t.count);
83 a5.extend(t.count);
84 ddindx := t.first;
85 indx := 1;
86 while true loop
87 a0(indx) := rosetta_g_miss_num_map(t(ddindx).organization_id);
88 a1(indx) := t(ddindx).estimate_id;
89 a2(indx) := t(ddindx).message_text;
90 a3(indx) := rosetta_g_miss_num_map(t(ddindx).row_reference);
91 a4(indx) := t(ddindx).message_code;
92 a5(indx) := t(ddindx).message_type;
93 indx := indx+1;
94 if t.last =ddindx
95 then exit;
96 end if;
97 ddindx := t.next(ddindx);
98 end loop;
99 end if;
100 end if;
101 end rosetta_table_copy_out_p3;
102
103 procedure rosetta_table_copy_in_p7(t out nocopy eam_est_datastructures_pub.eam_construction_estimate_tbl, a0 JTF_NUMBER_TABLE
104 , a1 JTF_NUMBER_TABLE
105 , a2 JTF_VARCHAR2_TABLE_100
106 , a3 JTF_VARCHAR2_TABLE_300
107 , a4 JTF_NUMBER_TABLE
108 , a5 JTF_NUMBER_TABLE
109 , a6 JTF_VARCHAR2_TABLE_100
110 , a7 JTF_VARCHAR2_TABLE_100
111 , a8 JTF_VARCHAR2_TABLE_200
112 , a9 JTF_VARCHAR2_TABLE_200
113 , a10 JTF_VARCHAR2_TABLE_200
114 , a11 JTF_VARCHAR2_TABLE_200
115 , a12 JTF_VARCHAR2_TABLE_200
116 , a13 JTF_VARCHAR2_TABLE_200
117 , a14 JTF_VARCHAR2_TABLE_200
118 , a15 JTF_VARCHAR2_TABLE_200
119 , a16 JTF_VARCHAR2_TABLE_200
120 , a17 JTF_VARCHAR2_TABLE_200
121 , a18 JTF_VARCHAR2_TABLE_200
122 , a19 JTF_VARCHAR2_TABLE_200
123 , a20 JTF_VARCHAR2_TABLE_200
124 , a21 JTF_VARCHAR2_TABLE_200
125 , a22 JTF_VARCHAR2_TABLE_200
126 ) as
127 ddindx binary_integer; indx binary_integer;
128 begin
129 if a0 is not null and a0.count > 0 then
130 if a0.count > 0 then
131 indx := a0.first;
132 ddindx := 1;
133 while true loop
134 t(ddindx).estimate_id := rosetta_g_miss_num_map(a0(indx));
135 t(ddindx).organization_id := rosetta_g_miss_num_map(a1(indx));
136 t(ddindx).estimate_number := a2(indx);
137 t(ddindx).estimate_description := a3(indx);
138 t(ddindx).grouping_option := rosetta_g_miss_num_map(a4(indx));
139 t(ddindx).parent_wo_id := rosetta_g_miss_num_map(a5(indx));
140 t(ddindx).create_parent_wo_flag := a6(indx);
141 t(ddindx).attribute_category := a7(indx);
142 t(ddindx).attribute1 := a8(indx);
143 t(ddindx).attribute2 := a9(indx);
144 t(ddindx).attribute3 := a10(indx);
145 t(ddindx).attribute4 := a11(indx);
146 t(ddindx).attribute5 := a12(indx);
147 t(ddindx).attribute6 := a13(indx);
148 t(ddindx).attribute7 := a14(indx);
149 t(ddindx).attribute8 := a15(indx);
150 t(ddindx).attribute9 := a16(indx);
151 t(ddindx).attribute10 := a17(indx);
152 t(ddindx).attribute11 := a18(indx);
153 t(ddindx).attribute12 := a19(indx);
154 t(ddindx).attribute13 := a20(indx);
155 t(ddindx).attribute14 := a21(indx);
156 t(ddindx).attribute15 := a22(indx);
157 ddindx := ddindx+1;
158 if a0.last =indx
159 then exit;
160 end if;
161 indx := a0.next(indx);
162 end loop;
163 end if;
164 end if;
165 end rosetta_table_copy_in_p7;
166 procedure rosetta_table_copy_out_p7(t eam_est_datastructures_pub.eam_construction_estimate_tbl, a0 out nocopy JTF_NUMBER_TABLE
167 , a1 out nocopy JTF_NUMBER_TABLE
168 , a2 out nocopy JTF_VARCHAR2_TABLE_100
169 , a3 out nocopy JTF_VARCHAR2_TABLE_300
170 , a4 out nocopy JTF_NUMBER_TABLE
171 , a5 out nocopy JTF_NUMBER_TABLE
172 , a6 out nocopy JTF_VARCHAR2_TABLE_100
173 , a7 out nocopy JTF_VARCHAR2_TABLE_100
174 , a8 out nocopy JTF_VARCHAR2_TABLE_200
175 , a9 out nocopy JTF_VARCHAR2_TABLE_200
176 , a10 out nocopy JTF_VARCHAR2_TABLE_200
177 , a11 out nocopy JTF_VARCHAR2_TABLE_200
178 , a12 out nocopy JTF_VARCHAR2_TABLE_200
179 , a13 out nocopy JTF_VARCHAR2_TABLE_200
180 , a14 out nocopy JTF_VARCHAR2_TABLE_200
181 , a15 out nocopy JTF_VARCHAR2_TABLE_200
182 , a16 out nocopy JTF_VARCHAR2_TABLE_200
183 , a17 out nocopy JTF_VARCHAR2_TABLE_200
184 , a18 out nocopy JTF_VARCHAR2_TABLE_200
185 , a19 out nocopy JTF_VARCHAR2_TABLE_200
186 , a20 out nocopy JTF_VARCHAR2_TABLE_200
187 , a21 out nocopy JTF_VARCHAR2_TABLE_200
188 , a22 out nocopy JTF_VARCHAR2_TABLE_200
189 ) as
190 ddindx binary_integer; indx binary_integer;
191 begin
192 if t is null or t.count = 0 then
193 a0 := JTF_NUMBER_TABLE();
194 a1 := JTF_NUMBER_TABLE();
195 a2 := JTF_VARCHAR2_TABLE_100();
196 a3 := JTF_VARCHAR2_TABLE_300();
197 a4 := JTF_NUMBER_TABLE();
198 a5 := JTF_NUMBER_TABLE();
199 a6 := JTF_VARCHAR2_TABLE_100();
200 a7 := JTF_VARCHAR2_TABLE_100();
201 a8 := JTF_VARCHAR2_TABLE_200();
202 a9 := JTF_VARCHAR2_TABLE_200();
203 a10 := JTF_VARCHAR2_TABLE_200();
204 a11 := JTF_VARCHAR2_TABLE_200();
205 a12 := JTF_VARCHAR2_TABLE_200();
206 a13 := JTF_VARCHAR2_TABLE_200();
207 a14 := JTF_VARCHAR2_TABLE_200();
208 a15 := JTF_VARCHAR2_TABLE_200();
209 a16 := JTF_VARCHAR2_TABLE_200();
210 a17 := JTF_VARCHAR2_TABLE_200();
211 a18 := JTF_VARCHAR2_TABLE_200();
212 a19 := JTF_VARCHAR2_TABLE_200();
213 a20 := JTF_VARCHAR2_TABLE_200();
214 a21 := JTF_VARCHAR2_TABLE_200();
215 a22 := JTF_VARCHAR2_TABLE_200();
216 else
217 a0 := JTF_NUMBER_TABLE();
218 a1 := JTF_NUMBER_TABLE();
219 a2 := JTF_VARCHAR2_TABLE_100();
220 a3 := JTF_VARCHAR2_TABLE_300();
221 a4 := JTF_NUMBER_TABLE();
222 a5 := JTF_NUMBER_TABLE();
223 a6 := JTF_VARCHAR2_TABLE_100();
224 a7 := JTF_VARCHAR2_TABLE_100();
225 a8 := JTF_VARCHAR2_TABLE_200();
226 a9 := JTF_VARCHAR2_TABLE_200();
227 a10 := JTF_VARCHAR2_TABLE_200();
228 a11 := JTF_VARCHAR2_TABLE_200();
229 a12 := JTF_VARCHAR2_TABLE_200();
230 a13 := JTF_VARCHAR2_TABLE_200();
231 a14 := JTF_VARCHAR2_TABLE_200();
232 a15 := JTF_VARCHAR2_TABLE_200();
233 a16 := JTF_VARCHAR2_TABLE_200();
234 a17 := JTF_VARCHAR2_TABLE_200();
235 a18 := JTF_VARCHAR2_TABLE_200();
236 a19 := JTF_VARCHAR2_TABLE_200();
237 a20 := JTF_VARCHAR2_TABLE_200();
238 a21 := JTF_VARCHAR2_TABLE_200();
239 a22 := JTF_VARCHAR2_TABLE_200();
240 if t.count > 0 then
241 a0.extend(t.count);
242 a1.extend(t.count);
243 a2.extend(t.count);
244 a3.extend(t.count);
245 a4.extend(t.count);
246 a5.extend(t.count);
247 a6.extend(t.count);
248 a7.extend(t.count);
249 a8.extend(t.count);
250 a9.extend(t.count);
251 a10.extend(t.count);
252 a11.extend(t.count);
253 a12.extend(t.count);
254 a13.extend(t.count);
255 a14.extend(t.count);
256 a15.extend(t.count);
257 a16.extend(t.count);
258 a17.extend(t.count);
259 a18.extend(t.count);
260 a19.extend(t.count);
261 a20.extend(t.count);
262 a21.extend(t.count);
263 a22.extend(t.count);
264 ddindx := t.first;
265 indx := 1;
266 while true loop
267 a0(indx) := rosetta_g_miss_num_map(t(ddindx).estimate_id);
268 a1(indx) := rosetta_g_miss_num_map(t(ddindx).organization_id);
269 a2(indx) := t(ddindx).estimate_number;
270 a3(indx) := t(ddindx).estimate_description;
271 a4(indx) := rosetta_g_miss_num_map(t(ddindx).grouping_option);
272 a5(indx) := rosetta_g_miss_num_map(t(ddindx).parent_wo_id);
273 a6(indx) := t(ddindx).create_parent_wo_flag;
274 a7(indx) := t(ddindx).attribute_category;
275 a8(indx) := t(ddindx).attribute1;
276 a9(indx) := t(ddindx).attribute2;
277 a10(indx) := t(ddindx).attribute3;
278 a11(indx) := t(ddindx).attribute4;
279 a12(indx) := t(ddindx).attribute5;
280 a13(indx) := t(ddindx).attribute6;
281 a14(indx) := t(ddindx).attribute7;
282 a15(indx) := t(ddindx).attribute8;
283 a16(indx) := t(ddindx).attribute9;
284 a17(indx) := t(ddindx).attribute10;
285 a18(indx) := t(ddindx).attribute11;
286 a19(indx) := t(ddindx).attribute12;
287 a20(indx) := t(ddindx).attribute13;
288 a21(indx) := t(ddindx).attribute14;
289 a22(indx) := t(ddindx).attribute15;
290 indx := indx+1;
291 if t.last =ddindx
292 then exit;
293 end if;
294 ddindx := t.next(ddindx);
295 end loop;
296 end if;
297 end if;
298 end rosetta_table_copy_out_p7;
299
300 procedure rosetta_table_copy_in_p9(t out nocopy eam_est_datastructures_pub.eam_construction_units_tbl, a0 JTF_NUMBER_TABLE
301 , a1 JTF_VARCHAR2_TABLE_100
302 , a2 JTF_VARCHAR2_TABLE_300
303 , a3 JTF_NUMBER_TABLE
304 , a4 JTF_DATE_TABLE
305 , a5 JTF_DATE_TABLE
306 ) as
307 ddindx binary_integer; indx binary_integer;
308 begin
309 if a0 is not null and a0.count > 0 then
310 if a0.count > 0 then
311 indx := a0.first;
312 ddindx := 1;
313 while true loop
317 t(ddindx).organization_id := rosetta_g_miss_num_map(a3(indx));
314 t(ddindx).cu_id := rosetta_g_miss_num_map(a0(indx));
315 t(ddindx).cu_name := a1(indx);
316 t(ddindx).description := a2(indx);
318 t(ddindx).cu_effective_from := rosetta_g_miss_date_in_map(a4(indx));
319 t(ddindx).cu_effective_to := rosetta_g_miss_date_in_map(a5(indx));
320 ddindx := ddindx+1;
321 if a0.last =indx
322 then exit;
323 end if;
324 indx := a0.next(indx);
325 end loop;
326 end if;
327 end if;
328 end rosetta_table_copy_in_p9;
329 procedure rosetta_table_copy_out_p9(t eam_est_datastructures_pub.eam_construction_units_tbl, a0 out nocopy JTF_NUMBER_TABLE
330 , a1 out nocopy JTF_VARCHAR2_TABLE_100
331 , a2 out nocopy JTF_VARCHAR2_TABLE_300
332 , a3 out nocopy JTF_NUMBER_TABLE
333 , a4 out nocopy JTF_DATE_TABLE
334 , a5 out nocopy JTF_DATE_TABLE
335 ) as
336 ddindx binary_integer; indx binary_integer;
337 begin
338 if t is null or t.count = 0 then
339 a0 := JTF_NUMBER_TABLE();
340 a1 := JTF_VARCHAR2_TABLE_100();
341 a2 := JTF_VARCHAR2_TABLE_300();
342 a3 := JTF_NUMBER_TABLE();
343 a4 := JTF_DATE_TABLE();
344 a5 := JTF_DATE_TABLE();
345 else
346 a0 := JTF_NUMBER_TABLE();
347 a1 := JTF_VARCHAR2_TABLE_100();
348 a2 := JTF_VARCHAR2_TABLE_300();
349 a3 := JTF_NUMBER_TABLE();
350 a4 := JTF_DATE_TABLE();
351 a5 := JTF_DATE_TABLE();
352 if t.count > 0 then
353 a0.extend(t.count);
354 a1.extend(t.count);
355 a2.extend(t.count);
356 a3.extend(t.count);
357 a4.extend(t.count);
358 a5.extend(t.count);
359 ddindx := t.first;
360 indx := 1;
361 while true loop
362 a0(indx) := rosetta_g_miss_num_map(t(ddindx).cu_id);
363 a1(indx) := t(ddindx).cu_name;
364 a2(indx) := t(ddindx).description;
365 a3(indx) := rosetta_g_miss_num_map(t(ddindx).organization_id);
366 a4(indx) := t(ddindx).cu_effective_from;
367 a5(indx) := t(ddindx).cu_effective_to;
368 indx := indx+1;
369 if t.last =ddindx
370 then exit;
371 end if;
372 ddindx := t.next(ddindx);
373 end loop;
374 end if;
375 end if;
376 end rosetta_table_copy_out_p9;
377
378 procedure rosetta_table_copy_in_p11(t out nocopy eam_est_datastructures_pub.eam_estimate_associations_tbl, a0 JTF_NUMBER_TABLE
379 , a1 JTF_NUMBER_TABLE
380 , a2 JTF_NUMBER_TABLE
381 , a3 JTF_NUMBER_TABLE
382 , a4 JTF_NUMBER_TABLE
383 , a5 JTF_VARCHAR2_TABLE_100
384 , a6 JTF_VARCHAR2_TABLE_300
385 , a7 JTF_VARCHAR2_TABLE_100
386 , a8 JTF_NUMBER_TABLE
387 , a9 JTF_VARCHAR2_TABLE_100
388 , a10 JTF_VARCHAR2_TABLE_300
389 , a11 JTF_NUMBER_TABLE
390 , a12 JTF_NUMBER_TABLE
391 , a13 JTF_NUMBER_TABLE
392 ) as
393 ddindx binary_integer; indx binary_integer;
394 begin
395 if a0 is not null and a0.count > 0 then
396 if a0.count > 0 then
397 indx := a0.first;
398 ddindx := 1;
399 while true loop
400 t(ddindx).estimate_association_id := rosetta_g_miss_num_map(a0(indx));
401 t(ddindx).organization_id := rosetta_g_miss_num_map(a1(indx));
402 t(ddindx).estimate_id := rosetta_g_miss_num_map(a2(indx));
403 t(ddindx).cu_id := rosetta_g_miss_num_map(a3(indx));
404 t(ddindx).cu_qty := rosetta_g_miss_num_map(a4(indx));
405 t(ddindx).cu_name := a5(indx);
406 t(ddindx).cu_description := a6(indx);
407 t(ddindx).acct_class_code := a7(indx);
408 t(ddindx).activity_id := rosetta_g_miss_num_map(a8(indx));
409 t(ddindx).activity_name := a9(indx);
410 t(ddindx).activity_description := a10(indx);
411 t(ddindx).activity_qty := rosetta_g_miss_num_map(a11(indx));
412 t(ddindx).difficulty_id := rosetta_g_miss_num_map(a12(indx));
413 t(ddindx).resource_multiplier := rosetta_g_miss_num_map(a13(indx));
414 ddindx := ddindx+1;
415 if a0.last =indx
416 then exit;
417 end if;
418 indx := a0.next(indx);
419 end loop;
420 end if;
421 end if;
422 end rosetta_table_copy_in_p11;
423 procedure rosetta_table_copy_out_p11(t eam_est_datastructures_pub.eam_estimate_associations_tbl, a0 out nocopy JTF_NUMBER_TABLE
424 , a1 out nocopy JTF_NUMBER_TABLE
425 , a2 out nocopy JTF_NUMBER_TABLE
426 , a3 out nocopy JTF_NUMBER_TABLE
427 , a4 out nocopy JTF_NUMBER_TABLE
428 , a5 out nocopy JTF_VARCHAR2_TABLE_100
429 , a6 out nocopy JTF_VARCHAR2_TABLE_300
430 , a7 out nocopy JTF_VARCHAR2_TABLE_100
431 , a8 out nocopy JTF_NUMBER_TABLE
432 , a9 out nocopy JTF_VARCHAR2_TABLE_100
433 , a10 out nocopy JTF_VARCHAR2_TABLE_300
434 , a11 out nocopy JTF_NUMBER_TABLE
435 , a12 out nocopy JTF_NUMBER_TABLE
436 , a13 out nocopy JTF_NUMBER_TABLE
437 ) as
438 ddindx binary_integer; indx binary_integer;
439 begin
440 if t is null or t.count = 0 then
441 a0 := JTF_NUMBER_TABLE();
442 a1 := JTF_NUMBER_TABLE();
443 a2 := JTF_NUMBER_TABLE();
444 a3 := JTF_NUMBER_TABLE();
445 a4 := JTF_NUMBER_TABLE();
446 a5 := JTF_VARCHAR2_TABLE_100();
447 a6 := JTF_VARCHAR2_TABLE_300();
448 a7 := JTF_VARCHAR2_TABLE_100();
449 a8 := JTF_NUMBER_TABLE();
450 a9 := JTF_VARCHAR2_TABLE_100();
451 a10 := JTF_VARCHAR2_TABLE_300();
452 a11 := JTF_NUMBER_TABLE();
453 a12 := JTF_NUMBER_TABLE();
457 a1 := JTF_NUMBER_TABLE();
454 a13 := JTF_NUMBER_TABLE();
455 else
456 a0 := JTF_NUMBER_TABLE();
458 a2 := JTF_NUMBER_TABLE();
459 a3 := JTF_NUMBER_TABLE();
460 a4 := JTF_NUMBER_TABLE();
461 a5 := JTF_VARCHAR2_TABLE_100();
462 a6 := JTF_VARCHAR2_TABLE_300();
463 a7 := JTF_VARCHAR2_TABLE_100();
464 a8 := JTF_NUMBER_TABLE();
465 a9 := JTF_VARCHAR2_TABLE_100();
466 a10 := JTF_VARCHAR2_TABLE_300();
467 a11 := JTF_NUMBER_TABLE();
468 a12 := JTF_NUMBER_TABLE();
469 a13 := JTF_NUMBER_TABLE();
470 if t.count > 0 then
471 a0.extend(t.count);
472 a1.extend(t.count);
473 a2.extend(t.count);
474 a3.extend(t.count);
475 a4.extend(t.count);
476 a5.extend(t.count);
477 a6.extend(t.count);
478 a7.extend(t.count);
479 a8.extend(t.count);
480 a9.extend(t.count);
481 a10.extend(t.count);
482 a11.extend(t.count);
483 a12.extend(t.count);
484 a13.extend(t.count);
485 ddindx := t.first;
486 indx := 1;
487 while true loop
488 a0(indx) := rosetta_g_miss_num_map(t(ddindx).estimate_association_id);
489 a1(indx) := rosetta_g_miss_num_map(t(ddindx).organization_id);
490 a2(indx) := rosetta_g_miss_num_map(t(ddindx).estimate_id);
491 a3(indx) := rosetta_g_miss_num_map(t(ddindx).cu_id);
492 a4(indx) := rosetta_g_miss_num_map(t(ddindx).cu_qty);
493 a5(indx) := t(ddindx).cu_name;
494 a6(indx) := t(ddindx).cu_description;
495 a7(indx) := t(ddindx).acct_class_code;
496 a8(indx) := rosetta_g_miss_num_map(t(ddindx).activity_id);
497 a9(indx) := t(ddindx).activity_name;
498 a10(indx) := t(ddindx).activity_description;
499 a11(indx) := rosetta_g_miss_num_map(t(ddindx).activity_qty);
500 a12(indx) := rosetta_g_miss_num_map(t(ddindx).difficulty_id);
501 a13(indx) := rosetta_g_miss_num_map(t(ddindx).resource_multiplier);
502 indx := indx+1;
503 if t.last =ddindx
504 then exit;
505 end if;
506 ddindx := t.next(ddindx);
507 end loop;
508 end if;
509 end if;
510 end rosetta_table_copy_out_p11;
511
512 procedure rosetta_table_copy_in_p13(t out nocopy eam_est_datastructures_pub.eam_ce_work_order_lines_tbl, a0 JTF_NUMBER_TABLE
513 , a1 JTF_NUMBER_TABLE
514 , a2 JTF_NUMBER_TABLE
515 , a3 JTF_NUMBER_TABLE
516 , a4 JTF_NUMBER_TABLE
517 , a5 JTF_VARCHAR2_TABLE_100
518 , a6 JTF_NUMBER_TABLE
519 , a7 JTF_NUMBER_TABLE
520 , a8 JTF_NUMBER_TABLE
521 , a9 JTF_VARCHAR2_TABLE_100
522 , a10 JTF_VARCHAR2_TABLE_300
523 , a11 JTF_NUMBER_TABLE
524 , a12 JTF_NUMBER_TABLE
525 , a13 JTF_NUMBER_TABLE
526 , a14 JTF_VARCHAR2_TABLE_100
527 , a15 JTF_DATE_TABLE
528 , a16 JTF_DATE_TABLE
529 , a17 JTF_NUMBER_TABLE
530 , a18 JTF_NUMBER_TABLE
531 , a19 JTF_NUMBER_TABLE
532 , a20 JTF_NUMBER_TABLE
533 , a21 JTF_NUMBER_TABLE
534 , a22 JTF_NUMBER_TABLE
535 , a23 JTF_NUMBER_TABLE
536 , a24 JTF_NUMBER_TABLE
537 , a25 JTF_VARCHAR2_TABLE_300
538 , a26 JTF_NUMBER_TABLE
539 , a27 JTF_NUMBER_TABLE
540 , a28 JTF_VARCHAR2_TABLE_4000
541 , a29 JTF_NUMBER_TABLE
542 , a30 JTF_NUMBER_TABLE
543 , a31 JTF_VARCHAR2_TABLE_100
544 , a32 JTF_NUMBER_TABLE
545 , a33 JTF_NUMBER_TABLE
546 , a34 JTF_NUMBER_TABLE
547 , a35 JTF_NUMBER_TABLE
548 , a36 JTF_NUMBER_TABLE
549 , a37 JTF_NUMBER_TABLE
550 , a38 JTF_NUMBER_TABLE
551 , a39 JTF_VARCHAR2_TABLE_100
552 , a40 JTF_NUMBER_TABLE
553 , a41 JTF_VARCHAR2_TABLE_300
554 , a42 JTF_NUMBER_TABLE
555 , a43 JTF_VARCHAR2_TABLE_100
556 , a44 JTF_NUMBER_TABLE
557 , a45 JTF_NUMBER_TABLE
558 , a46 JTF_NUMBER_TABLE
559 , a47 JTF_VARCHAR2_TABLE_100
560 , a48 JTF_NUMBER_TABLE
561 , a49 JTF_NUMBER_TABLE
562 , a50 JTF_VARCHAR2_TABLE_100
563 , a51 JTF_VARCHAR2_TABLE_300
564 , a52 JTF_NUMBER_TABLE
565 , a53 JTF_VARCHAR2_TABLE_100
566 , a54 JTF_DATE_TABLE
567 , a55 JTF_NUMBER_TABLE
568 , a56 JTF_NUMBER_TABLE
569 , a57 JTF_NUMBER_TABLE
570 , a58 JTF_NUMBER_TABLE
571 , a59 JTF_VARCHAR2_TABLE_300
572 , a60 JTF_NUMBER_TABLE
573 , a61 JTF_NUMBER_TABLE
574 , a62 JTF_NUMBER_TABLE
575 , a63 JTF_NUMBER_TABLE
576 , a64 JTF_NUMBER_TABLE
577 , a65 JTF_NUMBER_TABLE
578 ) as
579 ddindx binary_integer; indx binary_integer;
580 begin
581 if a0 is not null and a0.count > 0 then
582 if a0.count > 0 then
583 indx := a0.first;
584 ddindx := 1;
585 while true loop
586 t(ddindx).estimate_work_order_line_id := rosetta_g_miss_num_map(a0(indx));
587 t(ddindx).src_cu_id := rosetta_g_miss_num_map(a1(indx));
588 t(ddindx).src_activity_id := rosetta_g_miss_num_map(a2(indx));
589 t(ddindx).src_activity_qty := rosetta_g_miss_num_map(a3(indx));
590 t(ddindx).src_op_seq_num := rosetta_g_miss_num_map(a4(indx));
591 t(ddindx).src_acct_class_code := a5(indx);
592 t(ddindx).estimate_id := rosetta_g_miss_num_map(a6(indx));
593 t(ddindx).organization_id := rosetta_g_miss_num_map(a7(indx));
594 t(ddindx).work_order_seq_num := rosetta_g_miss_num_map(a8(indx));
595 t(ddindx).work_order_number := a9(indx);
596 t(ddindx).work_order_description := a10(indx);
597 t(ddindx).ref_wip_entity_id := rosetta_g_miss_num_map(a11(indx));
601 t(ddindx).scheduled_start_date := rosetta_g_miss_date_in_map(a15(indx));
598 t(ddindx).primary_item_id := rosetta_g_miss_num_map(a12(indx));
599 t(ddindx).status_type := rosetta_g_miss_num_map(a13(indx));
600 t(ddindx).acct_class_code := a14(indx);
602 t(ddindx).scheduled_completion_date := rosetta_g_miss_date_in_map(a16(indx));
603 t(ddindx).project_id := rosetta_g_miss_num_map(a17(indx));
604 t(ddindx).task_id := rosetta_g_miss_num_map(a18(indx));
605 t(ddindx).maintenance_object_id := rosetta_g_miss_num_map(a19(indx));
606 t(ddindx).maintenance_object_type := rosetta_g_miss_num_map(a20(indx));
607 t(ddindx).maintenance_object_source := rosetta_g_miss_num_map(a21(indx));
608 t(ddindx).owning_department_id := rosetta_g_miss_num_map(a22(indx));
609 t(ddindx).user_defined_status_id := rosetta_g_miss_num_map(a23(indx));
610 t(ddindx).op_seq_num := rosetta_g_miss_num_map(a24(indx));
611 t(ddindx).op_description := a25(indx);
612 t(ddindx).standard_operation_id := rosetta_g_miss_num_map(a26(indx));
613 t(ddindx).op_department_id := rosetta_g_miss_num_map(a27(indx));
614 t(ddindx).op_long_description := a28(indx);
615 t(ddindx).res_seq_num := rosetta_g_miss_num_map(a29(indx));
616 t(ddindx).res_id := rosetta_g_miss_num_map(a30(indx));
617 t(ddindx).res_uom := a31(indx);
618 t(ddindx).res_basis_type := rosetta_g_miss_num_map(a32(indx));
619 t(ddindx).res_usage_rate_or_amount := rosetta_g_miss_num_map(a33(indx));
620 t(ddindx).res_required_units := rosetta_g_miss_num_map(a34(indx));
621 t(ddindx).res_assigned_units := rosetta_g_miss_num_map(a35(indx));
622 t(ddindx).item_type := rosetta_g_miss_num_map(a36(indx));
623 t(ddindx).required_quantity := rosetta_g_miss_num_map(a37(indx));
624 t(ddindx).unit_price := rosetta_g_miss_num_map(a38(indx));
625 t(ddindx).uom := a39(indx);
626 t(ddindx).basis_type := rosetta_g_miss_num_map(a40(indx));
627 t(ddindx).suggested_vendor_name := a41(indx);
628 t(ddindx).suggested_vendor_id := rosetta_g_miss_num_map(a42(indx));
629 t(ddindx).suggested_vendor_site := a43(indx);
630 t(ddindx).suggested_vendor_site_id := rosetta_g_miss_num_map(a44(indx));
631 t(ddindx).mat_inventory_item_id := rosetta_g_miss_num_map(a45(indx));
632 t(ddindx).mat_component_seq_num := rosetta_g_miss_num_map(a46(indx));
633 t(ddindx).mat_supply_subinventory := a47(indx);
634 t(ddindx).mat_supply_locator_id := rosetta_g_miss_num_map(a48(indx));
635 t(ddindx).di_amount := rosetta_g_miss_num_map(a49(indx));
636 t(ddindx).di_order_type_lookup_code := a50(indx);
637 t(ddindx).di_description := a51(indx);
638 t(ddindx).di_purchase_category_id := rosetta_g_miss_num_map(a52(indx));
639 t(ddindx).di_auto_request_material := a53(indx);
640 t(ddindx).di_need_by_date := rosetta_g_miss_date_in_map(a54(indx));
641 t(ddindx).work_order_line_cost := rosetta_g_miss_num_map(a55(indx));
642 t(ddindx).difficulty_qty := rosetta_g_miss_num_map(a56(indx));
643 t(ddindx).difficulty_id := rosetta_g_miss_num_map(a57(indx));
644 t(ddindx).cu_qty := rosetta_g_miss_num_map(a58(indx));
645 t(ddindx).item_comments := a59(indx);
646 t(ddindx).work_order_type := rosetta_g_miss_num_map(a60(indx));
647 t(ddindx).activity_type := rosetta_g_miss_num_map(a61(indx));
648 t(ddindx).activity_cause := rosetta_g_miss_num_map(a62(indx));
649 t(ddindx).activity_source := rosetta_g_miss_num_map(a63(indx));
650 t(ddindx).available_quantity := rosetta_g_miss_num_map(a64(indx));
651 t(ddindx).res_scheduled_flag := rosetta_g_miss_num_map(a65(indx));
652 ddindx := ddindx+1;
653 if a0.last =indx
654 then exit;
655 end if;
656 indx := a0.next(indx);
657 end loop;
658 end if;
659 end if;
660 end rosetta_table_copy_in_p13;
661 procedure rosetta_table_copy_out_p13(t eam_est_datastructures_pub.eam_ce_work_order_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
662 , a1 out nocopy JTF_NUMBER_TABLE
663 , a2 out nocopy JTF_NUMBER_TABLE
664 , a3 out nocopy JTF_NUMBER_TABLE
665 , a4 out nocopy JTF_NUMBER_TABLE
666 , a5 out nocopy JTF_VARCHAR2_TABLE_100
667 , a6 out nocopy JTF_NUMBER_TABLE
668 , a7 out nocopy JTF_NUMBER_TABLE
669 , a8 out nocopy JTF_NUMBER_TABLE
670 , a9 out nocopy JTF_VARCHAR2_TABLE_100
671 , a10 out nocopy JTF_VARCHAR2_TABLE_300
672 , a11 out nocopy JTF_NUMBER_TABLE
673 , a12 out nocopy JTF_NUMBER_TABLE
674 , a13 out nocopy JTF_NUMBER_TABLE
675 , a14 out nocopy JTF_VARCHAR2_TABLE_100
676 , a15 out nocopy JTF_DATE_TABLE
677 , a16 out nocopy JTF_DATE_TABLE
678 , a17 out nocopy JTF_NUMBER_TABLE
679 , a18 out nocopy JTF_NUMBER_TABLE
680 , a19 out nocopy JTF_NUMBER_TABLE
681 , a20 out nocopy JTF_NUMBER_TABLE
682 , a21 out nocopy JTF_NUMBER_TABLE
683 , a22 out nocopy JTF_NUMBER_TABLE
684 , a23 out nocopy JTF_NUMBER_TABLE
685 , a24 out nocopy JTF_NUMBER_TABLE
686 , a25 out nocopy JTF_VARCHAR2_TABLE_300
687 , a26 out nocopy JTF_NUMBER_TABLE
688 , a27 out nocopy JTF_NUMBER_TABLE
689 , a28 out nocopy JTF_VARCHAR2_TABLE_4000
690 , a29 out nocopy JTF_NUMBER_TABLE
691 , a30 out nocopy JTF_NUMBER_TABLE
692 , a31 out nocopy JTF_VARCHAR2_TABLE_100
693 , a32 out nocopy JTF_NUMBER_TABLE
694 , a33 out nocopy JTF_NUMBER_TABLE
695 , a34 out nocopy JTF_NUMBER_TABLE
696 , a35 out nocopy JTF_NUMBER_TABLE
697 , a36 out nocopy JTF_NUMBER_TABLE
698 , a37 out nocopy JTF_NUMBER_TABLE
699 , a38 out nocopy JTF_NUMBER_TABLE
700 , a39 out nocopy JTF_VARCHAR2_TABLE_100
701 , a40 out nocopy JTF_NUMBER_TABLE
705 , a44 out nocopy JTF_NUMBER_TABLE
702 , a41 out nocopy JTF_VARCHAR2_TABLE_300
703 , a42 out nocopy JTF_NUMBER_TABLE
704 , a43 out nocopy JTF_VARCHAR2_TABLE_100
706 , a45 out nocopy JTF_NUMBER_TABLE
707 , a46 out nocopy JTF_NUMBER_TABLE
708 , a47 out nocopy JTF_VARCHAR2_TABLE_100
709 , a48 out nocopy JTF_NUMBER_TABLE
710 , a49 out nocopy JTF_NUMBER_TABLE
711 , a50 out nocopy JTF_VARCHAR2_TABLE_100
712 , a51 out nocopy JTF_VARCHAR2_TABLE_300
713 , a52 out nocopy JTF_NUMBER_TABLE
714 , a53 out nocopy JTF_VARCHAR2_TABLE_100
715 , a54 out nocopy JTF_DATE_TABLE
716 , a55 out nocopy JTF_NUMBER_TABLE
717 , a56 out nocopy JTF_NUMBER_TABLE
718 , a57 out nocopy JTF_NUMBER_TABLE
719 , a58 out nocopy JTF_NUMBER_TABLE
720 , a59 out nocopy JTF_VARCHAR2_TABLE_300
721 , a60 out nocopy JTF_NUMBER_TABLE
722 , a61 out nocopy JTF_NUMBER_TABLE
723 , a62 out nocopy JTF_NUMBER_TABLE
724 , a63 out nocopy JTF_NUMBER_TABLE
725 , a64 out nocopy JTF_NUMBER_TABLE
726 , a65 out nocopy JTF_NUMBER_TABLE
727 ) as
728 ddindx binary_integer; indx binary_integer;
729 begin
730 if t is null or t.count = 0 then
731 a0 := JTF_NUMBER_TABLE();
732 a1 := JTF_NUMBER_TABLE();
733 a2 := JTF_NUMBER_TABLE();
734 a3 := JTF_NUMBER_TABLE();
735 a4 := JTF_NUMBER_TABLE();
736 a5 := JTF_VARCHAR2_TABLE_100();
737 a6 := JTF_NUMBER_TABLE();
738 a7 := JTF_NUMBER_TABLE();
739 a8 := JTF_NUMBER_TABLE();
740 a9 := JTF_VARCHAR2_TABLE_100();
741 a10 := JTF_VARCHAR2_TABLE_300();
742 a11 := JTF_NUMBER_TABLE();
743 a12 := JTF_NUMBER_TABLE();
744 a13 := JTF_NUMBER_TABLE();
745 a14 := JTF_VARCHAR2_TABLE_100();
746 a15 := JTF_DATE_TABLE();
747 a16 := JTF_DATE_TABLE();
748 a17 := JTF_NUMBER_TABLE();
749 a18 := JTF_NUMBER_TABLE();
750 a19 := JTF_NUMBER_TABLE();
751 a20 := JTF_NUMBER_TABLE();
752 a21 := JTF_NUMBER_TABLE();
753 a22 := JTF_NUMBER_TABLE();
754 a23 := JTF_NUMBER_TABLE();
755 a24 := JTF_NUMBER_TABLE();
756 a25 := JTF_VARCHAR2_TABLE_300();
757 a26 := JTF_NUMBER_TABLE();
758 a27 := JTF_NUMBER_TABLE();
759 a28 := JTF_VARCHAR2_TABLE_4000();
760 a29 := JTF_NUMBER_TABLE();
761 a30 := JTF_NUMBER_TABLE();
762 a31 := JTF_VARCHAR2_TABLE_100();
763 a32 := JTF_NUMBER_TABLE();
764 a33 := JTF_NUMBER_TABLE();
765 a34 := JTF_NUMBER_TABLE();
766 a35 := JTF_NUMBER_TABLE();
767 a36 := JTF_NUMBER_TABLE();
768 a37 := JTF_NUMBER_TABLE();
769 a38 := JTF_NUMBER_TABLE();
770 a39 := JTF_VARCHAR2_TABLE_100();
771 a40 := JTF_NUMBER_TABLE();
772 a41 := JTF_VARCHAR2_TABLE_300();
773 a42 := JTF_NUMBER_TABLE();
774 a43 := JTF_VARCHAR2_TABLE_100();
775 a44 := JTF_NUMBER_TABLE();
776 a45 := JTF_NUMBER_TABLE();
777 a46 := JTF_NUMBER_TABLE();
778 a47 := JTF_VARCHAR2_TABLE_100();
779 a48 := JTF_NUMBER_TABLE();
780 a49 := JTF_NUMBER_TABLE();
781 a50 := JTF_VARCHAR2_TABLE_100();
782 a51 := JTF_VARCHAR2_TABLE_300();
783 a52 := JTF_NUMBER_TABLE();
784 a53 := JTF_VARCHAR2_TABLE_100();
785 a54 := JTF_DATE_TABLE();
786 a55 := JTF_NUMBER_TABLE();
787 a56 := JTF_NUMBER_TABLE();
788 a57 := JTF_NUMBER_TABLE();
789 a58 := JTF_NUMBER_TABLE();
790 a59 := JTF_VARCHAR2_TABLE_300();
791 a60 := JTF_NUMBER_TABLE();
792 a61 := JTF_NUMBER_TABLE();
793 a62 := JTF_NUMBER_TABLE();
794 a63 := JTF_NUMBER_TABLE();
795 a64 := JTF_NUMBER_TABLE();
796 a65 := JTF_NUMBER_TABLE();
797 else
798 a0 := JTF_NUMBER_TABLE();
799 a1 := JTF_NUMBER_TABLE();
800 a2 := JTF_NUMBER_TABLE();
801 a3 := JTF_NUMBER_TABLE();
802 a4 := JTF_NUMBER_TABLE();
803 a5 := JTF_VARCHAR2_TABLE_100();
804 a6 := JTF_NUMBER_TABLE();
805 a7 := JTF_NUMBER_TABLE();
806 a8 := JTF_NUMBER_TABLE();
807 a9 := JTF_VARCHAR2_TABLE_100();
808 a10 := JTF_VARCHAR2_TABLE_300();
809 a11 := JTF_NUMBER_TABLE();
810 a12 := JTF_NUMBER_TABLE();
811 a13 := JTF_NUMBER_TABLE();
812 a14 := JTF_VARCHAR2_TABLE_100();
813 a15 := JTF_DATE_TABLE();
814 a16 := JTF_DATE_TABLE();
815 a17 := JTF_NUMBER_TABLE();
816 a18 := JTF_NUMBER_TABLE();
817 a19 := JTF_NUMBER_TABLE();
818 a20 := JTF_NUMBER_TABLE();
819 a21 := JTF_NUMBER_TABLE();
820 a22 := JTF_NUMBER_TABLE();
821 a23 := JTF_NUMBER_TABLE();
822 a24 := JTF_NUMBER_TABLE();
823 a25 := JTF_VARCHAR2_TABLE_300();
824 a26 := JTF_NUMBER_TABLE();
825 a27 := JTF_NUMBER_TABLE();
826 a28 := JTF_VARCHAR2_TABLE_4000();
827 a29 := JTF_NUMBER_TABLE();
828 a30 := JTF_NUMBER_TABLE();
829 a31 := JTF_VARCHAR2_TABLE_100();
830 a32 := JTF_NUMBER_TABLE();
831 a33 := JTF_NUMBER_TABLE();
832 a34 := JTF_NUMBER_TABLE();
833 a35 := JTF_NUMBER_TABLE();
834 a36 := JTF_NUMBER_TABLE();
835 a37 := JTF_NUMBER_TABLE();
836 a38 := JTF_NUMBER_TABLE();
837 a39 := JTF_VARCHAR2_TABLE_100();
838 a40 := JTF_NUMBER_TABLE();
839 a41 := JTF_VARCHAR2_TABLE_300();
840 a42 := JTF_NUMBER_TABLE();
841 a43 := JTF_VARCHAR2_TABLE_100();
842 a44 := JTF_NUMBER_TABLE();
843 a45 := JTF_NUMBER_TABLE();
844 a46 := JTF_NUMBER_TABLE();
845 a47 := JTF_VARCHAR2_TABLE_100();
846 a48 := JTF_NUMBER_TABLE();
847 a49 := JTF_NUMBER_TABLE();
848 a50 := JTF_VARCHAR2_TABLE_100();
849 a51 := JTF_VARCHAR2_TABLE_300();
850 a52 := JTF_NUMBER_TABLE();
854 a56 := JTF_NUMBER_TABLE();
851 a53 := JTF_VARCHAR2_TABLE_100();
852 a54 := JTF_DATE_TABLE();
853 a55 := JTF_NUMBER_TABLE();
855 a57 := JTF_NUMBER_TABLE();
856 a58 := JTF_NUMBER_TABLE();
857 a59 := JTF_VARCHAR2_TABLE_300();
858 a60 := JTF_NUMBER_TABLE();
859 a61 := JTF_NUMBER_TABLE();
860 a62 := JTF_NUMBER_TABLE();
861 a63 := JTF_NUMBER_TABLE();
862 a64 := JTF_NUMBER_TABLE();
863 a65 := JTF_NUMBER_TABLE();
864 if t.count > 0 then
865 a0.extend(t.count);
866 a1.extend(t.count);
867 a2.extend(t.count);
868 a3.extend(t.count);
869 a4.extend(t.count);
870 a5.extend(t.count);
871 a6.extend(t.count);
872 a7.extend(t.count);
873 a8.extend(t.count);
874 a9.extend(t.count);
875 a10.extend(t.count);
876 a11.extend(t.count);
877 a12.extend(t.count);
878 a13.extend(t.count);
879 a14.extend(t.count);
880 a15.extend(t.count);
881 a16.extend(t.count);
882 a17.extend(t.count);
883 a18.extend(t.count);
884 a19.extend(t.count);
885 a20.extend(t.count);
886 a21.extend(t.count);
887 a22.extend(t.count);
888 a23.extend(t.count);
889 a24.extend(t.count);
890 a25.extend(t.count);
891 a26.extend(t.count);
892 a27.extend(t.count);
893 a28.extend(t.count);
894 a29.extend(t.count);
895 a30.extend(t.count);
896 a31.extend(t.count);
897 a32.extend(t.count);
898 a33.extend(t.count);
899 a34.extend(t.count);
900 a35.extend(t.count);
901 a36.extend(t.count);
902 a37.extend(t.count);
903 a38.extend(t.count);
904 a39.extend(t.count);
905 a40.extend(t.count);
906 a41.extend(t.count);
907 a42.extend(t.count);
908 a43.extend(t.count);
909 a44.extend(t.count);
910 a45.extend(t.count);
911 a46.extend(t.count);
912 a47.extend(t.count);
913 a48.extend(t.count);
914 a49.extend(t.count);
915 a50.extend(t.count);
916 a51.extend(t.count);
917 a52.extend(t.count);
918 a53.extend(t.count);
919 a54.extend(t.count);
920 a55.extend(t.count);
921 a56.extend(t.count);
922 a57.extend(t.count);
923 a58.extend(t.count);
924 a59.extend(t.count);
925 a60.extend(t.count);
926 a61.extend(t.count);
927 a62.extend(t.count);
928 a63.extend(t.count);
929 a64.extend(t.count);
930 a65.extend(t.count);
931 ddindx := t.first;
932 indx := 1;
933 while true loop
934 a0(indx) := rosetta_g_miss_num_map(t(ddindx).estimate_work_order_line_id);
935 a1(indx) := rosetta_g_miss_num_map(t(ddindx).src_cu_id);
936 a2(indx) := rosetta_g_miss_num_map(t(ddindx).src_activity_id);
937 a3(indx) := rosetta_g_miss_num_map(t(ddindx).src_activity_qty);
938 a4(indx) := rosetta_g_miss_num_map(t(ddindx).src_op_seq_num);
939 a5(indx) := t(ddindx).src_acct_class_code;
940 a6(indx) := rosetta_g_miss_num_map(t(ddindx).estimate_id);
941 a7(indx) := rosetta_g_miss_num_map(t(ddindx).organization_id);
942 a8(indx) := rosetta_g_miss_num_map(t(ddindx).work_order_seq_num);
943 a9(indx) := t(ddindx).work_order_number;
944 a10(indx) := t(ddindx).work_order_description;
945 a11(indx) := rosetta_g_miss_num_map(t(ddindx).ref_wip_entity_id);
946 a12(indx) := rosetta_g_miss_num_map(t(ddindx).primary_item_id);
947 a13(indx) := rosetta_g_miss_num_map(t(ddindx).status_type);
948 a14(indx) := t(ddindx).acct_class_code;
949 a15(indx) := t(ddindx).scheduled_start_date;
950 a16(indx) := t(ddindx).scheduled_completion_date;
951 a17(indx) := rosetta_g_miss_num_map(t(ddindx).project_id);
952 a18(indx) := rosetta_g_miss_num_map(t(ddindx).task_id);
953 a19(indx) := rosetta_g_miss_num_map(t(ddindx).maintenance_object_id);
954 a20(indx) := rosetta_g_miss_num_map(t(ddindx).maintenance_object_type);
955 a21(indx) := rosetta_g_miss_num_map(t(ddindx).maintenance_object_source);
956 a22(indx) := rosetta_g_miss_num_map(t(ddindx).owning_department_id);
957 a23(indx) := rosetta_g_miss_num_map(t(ddindx).user_defined_status_id);
958 a24(indx) := rosetta_g_miss_num_map(t(ddindx).op_seq_num);
959 a25(indx) := t(ddindx).op_description;
960 a26(indx) := rosetta_g_miss_num_map(t(ddindx).standard_operation_id);
961 a27(indx) := rosetta_g_miss_num_map(t(ddindx).op_department_id);
962 a28(indx) := t(ddindx).op_long_description;
963 a29(indx) := rosetta_g_miss_num_map(t(ddindx).res_seq_num);
964 a30(indx) := rosetta_g_miss_num_map(t(ddindx).res_id);
965 a31(indx) := t(ddindx).res_uom;
966 a32(indx) := rosetta_g_miss_num_map(t(ddindx).res_basis_type);
967 a33(indx) := rosetta_g_miss_num_map(t(ddindx).res_usage_rate_or_amount);
968 a34(indx) := rosetta_g_miss_num_map(t(ddindx).res_required_units);
969 a35(indx) := rosetta_g_miss_num_map(t(ddindx).res_assigned_units);
970 a36(indx) := rosetta_g_miss_num_map(t(ddindx).item_type);
971 a37(indx) := rosetta_g_miss_num_map(t(ddindx).required_quantity);
972 a38(indx) := rosetta_g_miss_num_map(t(ddindx).unit_price);
973 a39(indx) := t(ddindx).uom;
974 a40(indx) := rosetta_g_miss_num_map(t(ddindx).basis_type);
975 a41(indx) := t(ddindx).suggested_vendor_name;
976 a42(indx) := rosetta_g_miss_num_map(t(ddindx).suggested_vendor_id);
977 a43(indx) := t(ddindx).suggested_vendor_site;
978 a44(indx) := rosetta_g_miss_num_map(t(ddindx).suggested_vendor_site_id);
979 a45(indx) := rosetta_g_miss_num_map(t(ddindx).mat_inventory_item_id);
980 a46(indx) := rosetta_g_miss_num_map(t(ddindx).mat_component_seq_num);
981 a47(indx) := t(ddindx).mat_supply_subinventory;
982 a48(indx) := rosetta_g_miss_num_map(t(ddindx).mat_supply_locator_id);
983 a49(indx) := rosetta_g_miss_num_map(t(ddindx).di_amount);
984 a50(indx) := t(ddindx).di_order_type_lookup_code;
985 a51(indx) := t(ddindx).di_description;
986 a52(indx) := rosetta_g_miss_num_map(t(ddindx).di_purchase_category_id);
987 a53(indx) := t(ddindx).di_auto_request_material;
988 a54(indx) := t(ddindx).di_need_by_date;
989 a55(indx) := rosetta_g_miss_num_map(t(ddindx).work_order_line_cost);
990 a56(indx) := rosetta_g_miss_num_map(t(ddindx).difficulty_qty);
991 a57(indx) := rosetta_g_miss_num_map(t(ddindx).difficulty_id);
992 a58(indx) := rosetta_g_miss_num_map(t(ddindx).cu_qty);
993 a59(indx) := t(ddindx).item_comments;
994 a60(indx) := rosetta_g_miss_num_map(t(ddindx).work_order_type);
995 a61(indx) := rosetta_g_miss_num_map(t(ddindx).activity_type);
996 a62(indx) := rosetta_g_miss_num_map(t(ddindx).activity_cause);
997 a63(indx) := rosetta_g_miss_num_map(t(ddindx).activity_source);
998 a64(indx) := rosetta_g_miss_num_map(t(ddindx).available_quantity);
999 a65(indx) := rosetta_g_miss_num_map(t(ddindx).res_scheduled_flag);
1000 indx := indx+1;
1001 if t.last =ddindx
1002 then exit;
1003 end if;
1004 ddindx := t.next(ddindx);
1005 end loop;
1006 end if;
1007 end if;
1008 end rosetta_table_copy_out_p13;
1009
1010 end eam_est_datastructures_pub_w;